ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 21143 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500650 | 2500650 | 2022-05-13 | Lyon | Kentucky | 21143 | 2881 | 34 |
2497392 | 2497392 | 2022-05-12 | Lyon | Kentucky | 21143 | 2881 | 34 |
2494134 | 2494134 | 2022-05-11 | Lyon | Kentucky | 21143 | 2881 | 34 |
2490876 | 2490876 | 2022-05-10 | Lyon | Kentucky | 21143 | 2881 | 34 |
2487619 | 2487619 | 2022-05-09 | Lyon | Kentucky | 21143 | 2881 | 34 |
2484361 | 2484361 | 2022-05-08 | Lyon | Kentucky | 21143 | 2874 | 34 |
2481103 | 2481103 | 2022-05-07 | Lyon | Kentucky | 21143 | 2874 | 34 |
2477845 | 2477845 | 2022-05-06 | Lyon | Kentucky | 21143 | 2874 | 34 |
2474587 | 2474587 | 2022-05-05 | Lyon | Kentucky | 21143 | 2874 | 34 |
2471330 | 2471330 | 2022-05-04 | Lyon | Kentucky | 21143 | 2874 | 34 |
2468074 | 2468074 | 2022-05-03 | Lyon | Kentucky | 21143 | 2874 | 34 |
2464819 | 2464819 | 2022-05-02 | Lyon | Kentucky | 21143 | 2874 | 34 |
2461563 | 2461563 | 2022-05-01 | Lyon | Kentucky | 21143 | 2869 | 34 |
2458307 | 2458307 | 2022-04-30 | Lyon | Kentucky | 21143 | 2869 | 34 |
2455051 | 2455051 | 2022-04-29 | Lyon | Kentucky | 21143 | 2869 | 34 |
2451795 | 2451795 | 2022-04-28 | Lyon | Kentucky | 21143 | 2869 | 34 |
2448539 | 2448539 | 2022-04-27 | Lyon | Kentucky | 21143 | 2869 | 34 |
2445283 | 2445283 | 2022-04-26 | Lyon | Kentucky | 21143 | 2869 | 34 |
2442027 | 2442027 | 2022-04-25 | Lyon | Kentucky | 21143 | 2869 | 34 |
2438771 | 2438771 | 2022-04-24 | Lyon | Kentucky | 21143 | 2864 | 33 |
2435515 | 2435515 | 2022-04-23 | Lyon | Kentucky | 21143 | 2864 | 33 |
2432259 | 2432259 | 2022-04-22 | Lyon | Kentucky | 21143 | 2864 | 33 |
2429003 | 2429003 | 2022-04-21 | Lyon | Kentucky | 21143 | 2864 | 33 |
2425747 | 2425747 | 2022-04-20 | Lyon | Kentucky | 21143 | 2864 | 33 |
2422491 | 2422491 | 2022-04-19 | Lyon | Kentucky | 21143 | 2864 | 33 |
2419235 | 2419235 | 2022-04-18 | Lyon | Kentucky | 21143 | 2864 | 33 |
2415979 | 2415979 | 2022-04-17 | Lyon | Kentucky | 21143 | 2862 | 33 |
2412723 | 2412723 | 2022-04-16 | Lyon | Kentucky | 21143 | 2862 | 33 |
2409467 | 2409467 | 2022-04-15 | Lyon | Kentucky | 21143 | 2862 | 33 |
2406211 | 2406211 | 2022-04-14 | Lyon | Kentucky | 21143 | 2862 | 33 |
2402955 | 2402955 | 2022-04-13 | Lyon | Kentucky | 21143 | 2862 | 33 |
2399701 | 2399701 | 2022-04-12 | Lyon | Kentucky | 21143 | 2862 | 33 |
2396445 | 2396445 | 2022-04-11 | Lyon | Kentucky | 21143 | 2862 | 33 |
2393190 | 2393190 | 2022-04-10 | Lyon | Kentucky | 21143 | 2868 | 33 |
2389934 | 2389934 | 2022-04-09 | Lyon | Kentucky | 21143 | 2868 | 33 |
2386678 | 2386678 | 2022-04-08 | Lyon | Kentucky | 21143 | 2868 | 33 |
2383423 | 2383423 | 2022-04-07 | Lyon | Kentucky | 21143 | 2868 | 33 |
2380168 | 2380168 | 2022-04-06 | Lyon | Kentucky | 21143 | 2868 | 33 |
2376913 | 2376913 | 2022-04-05 | Lyon | Kentucky | 21143 | 2868 | 33 |
2373661 | 2373661 | 2022-04-04 | Lyon | Kentucky | 21143 | 2868 | 33 |
2370408 | 2370408 | 2022-04-03 | Lyon | Kentucky | 21143 | 2869 | 33 |
2367155 | 2367155 | 2022-04-02 | Lyon | Kentucky | 21143 | 2869 | 33 |
2363902 | 2363902 | 2022-04-01 | Lyon | Kentucky | 21143 | 2869 | 33 |
2360648 | 2360648 | 2022-03-31 | Lyon | Kentucky | 21143 | 2869 | 33 |
2357394 | 2357394 | 2022-03-30 | Lyon | Kentucky | 21143 | 2869 | 33 |
2354141 | 2354141 | 2022-03-29 | Lyon | Kentucky | 21143 | 2869 | 33 |
2350889 | 2350889 | 2022-03-28 | Lyon | Kentucky | 21143 | 2869 | 33 |
2347636 | 2347636 | 2022-03-27 | Lyon | Kentucky | 21143 | 2864 | 33 |
2344383 | 2344383 | 2022-03-26 | Lyon | Kentucky | 21143 | 2864 | 33 |
2341130 | 2341130 | 2022-03-25 | Lyon | Kentucky | 21143 | 2864 | 33 |
2337877 | 2337877 | 2022-03-24 | Lyon | Kentucky | 21143 | 2864 | 33 |
2334623 | 2334623 | 2022-03-23 | Lyon | Kentucky | 21143 | 2864 | 33 |
2331369 | 2331369 | 2022-03-22 | Lyon | Kentucky | 21143 | 2864 | 33 |
2328117 | 2328117 | 2022-03-21 | Lyon | Kentucky | 21143 | 2864 | 33 |
2324864 | 2324864 | 2022-03-20 | Lyon | Kentucky | 21143 | 2845 | 33 |
2321610 | 2321610 | 2022-03-19 | Lyon | Kentucky | 21143 | 2845 | 33 |
2318356 | 2318356 | 2022-03-18 | Lyon | Kentucky | 21143 | 2845 | 33 |
2315103 | 2315103 | 2022-03-17 | Lyon | Kentucky | 21143 | 2845 | 33 |
2311850 | 2311850 | 2022-03-16 | Lyon | Kentucky | 21143 | 2845 | 33 |
2308597 | 2308597 | 2022-03-15 | Lyon | Kentucky | 21143 | 2845 | 33 |
2305346 | 2305346 | 2022-03-14 | Lyon | Kentucky | 21143 | 2845 | 33 |
2302094 | 2302094 | 2022-03-13 | Lyon | Kentucky | 21143 | 2822 | 33 |
2298842 | 2298842 | 2022-03-12 | Lyon | Kentucky | 21143 | 2822 | 33 |
2295590 | 2295590 | 2022-03-11 | Lyon | Kentucky | 21143 | 2822 | 33 |
2292338 | 2292338 | 2022-03-10 | Lyon | Kentucky | 21143 | 2822 | 33 |
2289086 | 2289086 | 2022-03-09 | Lyon | Kentucky | 21143 | 2822 | 33 |
2285835 | 2285835 | 2022-03-08 | Lyon | Kentucky | 21143 | 2822 | 33 |
2282583 | 2282583 | 2022-03-07 | Lyon | Kentucky | 21143 | 2822 | 33 |
2279330 | 2279330 | 2022-03-06 | Lyon | Kentucky | 21143 | 2819 | 33 |
2276077 | 2276077 | 2022-03-05 | Lyon | Kentucky | 21143 | 2819 | 33 |
2272824 | 2272824 | 2022-03-04 | Lyon | Kentucky | 21143 | 2819 | 33 |
2269572 | 2269572 | 2022-03-03 | Lyon | Kentucky | 21143 | 2813 | 33 |
2266319 | 2266319 | 2022-03-02 | Lyon | Kentucky | 21143 | 2807 | 33 |
2263068 | 2263068 | 2022-03-01 | Lyon | Kentucky | 21143 | 2802 | 33 |
2259817 | 2259817 | 2022-02-28 | Lyon | Kentucky | 21143 | 2787 | 33 |
2256566 | 2256566 | 2022-02-27 | Lyon | Kentucky | 21143 | 2784 | 33 |
2253315 | 2253315 | 2022-02-26 | Lyon | Kentucky | 21143 | 2784 | 33 |
2250064 | 2250064 | 2022-02-25 | Lyon | Kentucky | 21143 | 2784 | 33 |
2246813 | 2246813 | 2022-02-24 | Lyon | Kentucky | 21143 | 2767 | 33 |
2243562 | 2243562 | 2022-02-23 | Lyon | Kentucky | 21143 | 2767 | 33 |
2240311 | 2240311 | 2022-02-22 | Lyon | Kentucky | 21143 | 2759 | 33 |
2237060 | 2237060 | 2022-02-21 | Lyon | Kentucky | 21143 | 2751 | 33 |
2233809 | 2233809 | 2022-02-20 | Lyon | Kentucky | 21143 | 2738 | 33 |
2230558 | 2230558 | 2022-02-19 | Lyon | Kentucky | 21143 | 2738 | 33 |
2227307 | 2227307 | 2022-02-18 | Lyon | Kentucky | 21143 | 2738 | 33 |
2224056 | 2224056 | 2022-02-17 | Lyon | Kentucky | 21143 | 2735 | 33 |
2220805 | 2220805 | 2022-02-16 | Lyon | Kentucky | 21143 | 2733 | 33 |
2217554 | 2217554 | 2022-02-15 | Lyon | Kentucky | 21143 | 2725 | 33 |
2214303 | 2214303 | 2022-02-14 | Lyon | Kentucky | 21143 | 2722 | 32 |
2211051 | 2211051 | 2022-02-13 | Lyon | Kentucky | 21143 | 2672 | 32 |
2207798 | 2207798 | 2022-02-12 | Lyon | Kentucky | 21143 | 2672 | 32 |
2204545 | 2204545 | 2022-02-11 | Lyon | Kentucky | 21143 | 2672 | 32 |
2201292 | 2201292 | 2022-02-10 | Lyon | Kentucky | 21143 | 2666 | 32 |
2198038 | 2198038 | 2022-02-09 | Lyon | Kentucky | 21143 | 2660 | 32 |
2194784 | 2194784 | 2022-02-08 | Lyon | Kentucky | 21143 | 2650 | 32 |
2191530 | 2191530 | 2022-02-07 | Lyon | Kentucky | 21143 | 2624 | 32 |
2188277 | 2188277 | 2022-02-06 | Lyon | Kentucky | 21143 | 2604 | 32 |
2185024 | 2185024 | 2022-02-05 | Lyon | Kentucky | 21143 | 2604 | 32 |
2181772 | 2181772 | 2022-02-04 | Lyon | Kentucky | 21143 | 2604 | 32 |
2178521 | 2178521 | 2022-02-03 | Lyon | Kentucky | 21143 | 2592 | 32 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);