ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
746 rows where fips = 21169 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500663 | 2500663 | 2022-05-13 | Metcalfe | Kentucky | 21169 | 2875 | 64 |
2497405 | 2497405 | 2022-05-12 | Metcalfe | Kentucky | 21169 | 2875 | 64 |
2494147 | 2494147 | 2022-05-11 | Metcalfe | Kentucky | 21169 | 2875 | 64 |
2490889 | 2490889 | 2022-05-10 | Metcalfe | Kentucky | 21169 | 2875 | 64 |
2487632 | 2487632 | 2022-05-09 | Metcalfe | Kentucky | 21169 | 2875 | 64 |
2484374 | 2484374 | 2022-05-08 | Metcalfe | Kentucky | 21169 | 2872 | 64 |
2481116 | 2481116 | 2022-05-07 | Metcalfe | Kentucky | 21169 | 2872 | 64 |
2477858 | 2477858 | 2022-05-06 | Metcalfe | Kentucky | 21169 | 2872 | 64 |
2474600 | 2474600 | 2022-05-05 | Metcalfe | Kentucky | 21169 | 2872 | 64 |
2471343 | 2471343 | 2022-05-04 | Metcalfe | Kentucky | 21169 | 2872 | 64 |
2468087 | 2468087 | 2022-05-03 | Metcalfe | Kentucky | 21169 | 2872 | 64 |
2464832 | 2464832 | 2022-05-02 | Metcalfe | Kentucky | 21169 | 2872 | 64 |
2461576 | 2461576 | 2022-05-01 | Metcalfe | Kentucky | 21169 | 2868 | 64 |
2458320 | 2458320 | 2022-04-30 | Metcalfe | Kentucky | 21169 | 2868 | 64 |
2455064 | 2455064 | 2022-04-29 | Metcalfe | Kentucky | 21169 | 2868 | 64 |
2451808 | 2451808 | 2022-04-28 | Metcalfe | Kentucky | 21169 | 2868 | 64 |
2448552 | 2448552 | 2022-04-27 | Metcalfe | Kentucky | 21169 | 2868 | 64 |
2445296 | 2445296 | 2022-04-26 | Metcalfe | Kentucky | 21169 | 2868 | 64 |
2442040 | 2442040 | 2022-04-25 | Metcalfe | Kentucky | 21169 | 2868 | 64 |
2438784 | 2438784 | 2022-04-24 | Metcalfe | Kentucky | 21169 | 2867 | 64 |
2435528 | 2435528 | 2022-04-23 | Metcalfe | Kentucky | 21169 | 2867 | 64 |
2432272 | 2432272 | 2022-04-22 | Metcalfe | Kentucky | 21169 | 2867 | 64 |
2429016 | 2429016 | 2022-04-21 | Metcalfe | Kentucky | 21169 | 2867 | 64 |
2425760 | 2425760 | 2022-04-20 | Metcalfe | Kentucky | 21169 | 2867 | 64 |
2422504 | 2422504 | 2022-04-19 | Metcalfe | Kentucky | 21169 | 2867 | 64 |
2419248 | 2419248 | 2022-04-18 | Metcalfe | Kentucky | 21169 | 2867 | 64 |
2415992 | 2415992 | 2022-04-17 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2412736 | 2412736 | 2022-04-16 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2409480 | 2409480 | 2022-04-15 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2406224 | 2406224 | 2022-04-14 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2402968 | 2402968 | 2022-04-13 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2399714 | 2399714 | 2022-04-12 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2396458 | 2396458 | 2022-04-11 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2393203 | 2393203 | 2022-04-10 | Metcalfe | Kentucky | 21169 | 2861 | 61 |
2389947 | 2389947 | 2022-04-09 | Metcalfe | Kentucky | 21169 | 2861 | 61 |
2386691 | 2386691 | 2022-04-08 | Metcalfe | Kentucky | 21169 | 2861 | 61 |
2383436 | 2383436 | 2022-04-07 | Metcalfe | Kentucky | 21169 | 2861 | 61 |
2380181 | 2380181 | 2022-04-06 | Metcalfe | Kentucky | 21169 | 2861 | 61 |
2376926 | 2376926 | 2022-04-05 | Metcalfe | Kentucky | 21169 | 2861 | 61 |
2373674 | 2373674 | 2022-04-04 | Metcalfe | Kentucky | 21169 | 2861 | 61 |
2370421 | 2370421 | 2022-04-03 | Metcalfe | Kentucky | 21169 | 2862 | 61 |
2367168 | 2367168 | 2022-04-02 | Metcalfe | Kentucky | 21169 | 2862 | 61 |
2363915 | 2363915 | 2022-04-01 | Metcalfe | Kentucky | 21169 | 2862 | 61 |
2360661 | 2360661 | 2022-03-31 | Metcalfe | Kentucky | 21169 | 2862 | 61 |
2357407 | 2357407 | 2022-03-30 | Metcalfe | Kentucky | 21169 | 2862 | 61 |
2354154 | 2354154 | 2022-03-29 | Metcalfe | Kentucky | 21169 | 2862 | 61 |
2350902 | 2350902 | 2022-03-28 | Metcalfe | Kentucky | 21169 | 2862 | 61 |
2347649 | 2347649 | 2022-03-27 | Metcalfe | Kentucky | 21169 | 2857 | 61 |
2344396 | 2344396 | 2022-03-26 | Metcalfe | Kentucky | 21169 | 2857 | 61 |
2341143 | 2341143 | 2022-03-25 | Metcalfe | Kentucky | 21169 | 2857 | 61 |
2337890 | 2337890 | 2022-03-24 | Metcalfe | Kentucky | 21169 | 2857 | 61 |
2334636 | 2334636 | 2022-03-23 | Metcalfe | Kentucky | 21169 | 2857 | 61 |
2331382 | 2331382 | 2022-03-22 | Metcalfe | Kentucky | 21169 | 2857 | 61 |
2328130 | 2328130 | 2022-03-21 | Metcalfe | Kentucky | 21169 | 2857 | 61 |
2324877 | 2324877 | 2022-03-20 | Metcalfe | Kentucky | 21169 | 2849 | 59 |
2321623 | 2321623 | 2022-03-19 | Metcalfe | Kentucky | 21169 | 2849 | 59 |
2318369 | 2318369 | 2022-03-18 | Metcalfe | Kentucky | 21169 | 2849 | 59 |
2315116 | 2315116 | 2022-03-17 | Metcalfe | Kentucky | 21169 | 2849 | 59 |
2311863 | 2311863 | 2022-03-16 | Metcalfe | Kentucky | 21169 | 2849 | 59 |
2308610 | 2308610 | 2022-03-15 | Metcalfe | Kentucky | 21169 | 2849 | 59 |
2305359 | 2305359 | 2022-03-14 | Metcalfe | Kentucky | 21169 | 2849 | 59 |
2302107 | 2302107 | 2022-03-13 | Metcalfe | Kentucky | 21169 | 2833 | 59 |
2298855 | 2298855 | 2022-03-12 | Metcalfe | Kentucky | 21169 | 2833 | 59 |
2295603 | 2295603 | 2022-03-11 | Metcalfe | Kentucky | 21169 | 2833 | 59 |
2292351 | 2292351 | 2022-03-10 | Metcalfe | Kentucky | 21169 | 2833 | 59 |
2289099 | 2289099 | 2022-03-09 | Metcalfe | Kentucky | 21169 | 2833 | 59 |
2285848 | 2285848 | 2022-03-08 | Metcalfe | Kentucky | 21169 | 2833 | 59 |
2282596 | 2282596 | 2022-03-07 | Metcalfe | Kentucky | 21169 | 2833 | 59 |
2279343 | 2279343 | 2022-03-06 | Metcalfe | Kentucky | 21169 | 2829 | 59 |
2276090 | 2276090 | 2022-03-05 | Metcalfe | Kentucky | 21169 | 2829 | 59 |
2272837 | 2272837 | 2022-03-04 | Metcalfe | Kentucky | 21169 | 2829 | 59 |
2269585 | 2269585 | 2022-03-03 | Metcalfe | Kentucky | 21169 | 2824 | 58 |
2266332 | 2266332 | 2022-03-02 | Metcalfe | Kentucky | 21169 | 2816 | 58 |
2263081 | 2263081 | 2022-03-01 | Metcalfe | Kentucky | 21169 | 2812 | 58 |
2259830 | 2259830 | 2022-02-28 | Metcalfe | Kentucky | 21169 | 2808 | 58 |
2256579 | 2256579 | 2022-02-27 | Metcalfe | Kentucky | 21169 | 2801 | 58 |
2253328 | 2253328 | 2022-02-26 | Metcalfe | Kentucky | 21169 | 2801 | 58 |
2250077 | 2250077 | 2022-02-25 | Metcalfe | Kentucky | 21169 | 2801 | 58 |
2246826 | 2246826 | 2022-02-24 | Metcalfe | Kentucky | 21169 | 2789 | 58 |
2243575 | 2243575 | 2022-02-23 | Metcalfe | Kentucky | 21169 | 2789 | 58 |
2240324 | 2240324 | 2022-02-22 | Metcalfe | Kentucky | 21169 | 2782 | 58 |
2237073 | 2237073 | 2022-02-21 | Metcalfe | Kentucky | 21169 | 2775 | 58 |
2233822 | 2233822 | 2022-02-20 | Metcalfe | Kentucky | 21169 | 2763 | 57 |
2230571 | 2230571 | 2022-02-19 | Metcalfe | Kentucky | 21169 | 2763 | 57 |
2227320 | 2227320 | 2022-02-18 | Metcalfe | Kentucky | 21169 | 2763 | 57 |
2224069 | 2224069 | 2022-02-17 | Metcalfe | Kentucky | 21169 | 2745 | 57 |
2220818 | 2220818 | 2022-02-16 | Metcalfe | Kentucky | 21169 | 2738 | 57 |
2217567 | 2217567 | 2022-02-15 | Metcalfe | Kentucky | 21169 | 2728 | 57 |
2214316 | 2214316 | 2022-02-14 | Metcalfe | Kentucky | 21169 | 2716 | 57 |
2211064 | 2211064 | 2022-02-13 | Metcalfe | Kentucky | 21169 | 2678 | 54 |
2207811 | 2207811 | 2022-02-12 | Metcalfe | Kentucky | 21169 | 2678 | 54 |
2204558 | 2204558 | 2022-02-11 | Metcalfe | Kentucky | 21169 | 2678 | 54 |
2201305 | 2201305 | 2022-02-10 | Metcalfe | Kentucky | 21169 | 2668 | 54 |
2198051 | 2198051 | 2022-02-09 | Metcalfe | Kentucky | 21169 | 2649 | 54 |
2194797 | 2194797 | 2022-02-08 | Metcalfe | Kentucky | 21169 | 2643 | 54 |
2191543 | 2191543 | 2022-02-07 | Metcalfe | Kentucky | 21169 | 2635 | 54 |
2188290 | 2188290 | 2022-02-06 | Metcalfe | Kentucky | 21169 | 2627 | 54 |
2185037 | 2185037 | 2022-02-05 | Metcalfe | Kentucky | 21169 | 2627 | 54 |
2181785 | 2181785 | 2022-02-04 | Metcalfe | Kentucky | 21169 | 2627 | 54 |
2178534 | 2178534 | 2022-02-03 | Metcalfe | Kentucky | 21169 | 2617 | 54 |
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);