ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
760 rows where county = "Casey", fips = 21045 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 |
---|---|---|---|---|---|---|---|
2500601 | 2500601 | 2022-05-13 | Casey | Kentucky | 21045 | 4216 | 74 |
2497343 | 2497343 | 2022-05-12 | Casey | Kentucky | 21045 | 4216 | 74 |
2494085 | 2494085 | 2022-05-11 | Casey | Kentucky | 21045 | 4216 | 74 |
2490827 | 2490827 | 2022-05-10 | Casey | Kentucky | 21045 | 4216 | 74 |
2487570 | 2487570 | 2022-05-09 | Casey | Kentucky | 21045 | 4216 | 74 |
2484312 | 2484312 | 2022-05-08 | Casey | Kentucky | 21045 | 4212 | 72 |
2481054 | 2481054 | 2022-05-07 | Casey | Kentucky | 21045 | 4212 | 72 |
2477796 | 2477796 | 2022-05-06 | Casey | Kentucky | 21045 | 4212 | 72 |
2474538 | 2474538 | 2022-05-05 | Casey | Kentucky | 21045 | 4212 | 72 |
2471281 | 2471281 | 2022-05-04 | Casey | Kentucky | 21045 | 4212 | 72 |
2468025 | 2468025 | 2022-05-03 | Casey | Kentucky | 21045 | 4212 | 72 |
2464770 | 2464770 | 2022-05-02 | Casey | Kentucky | 21045 | 4212 | 72 |
2461514 | 2461514 | 2022-05-01 | Casey | Kentucky | 21045 | 4211 | 72 |
2458258 | 2458258 | 2022-04-30 | Casey | Kentucky | 21045 | 4211 | 72 |
2455002 | 2455002 | 2022-04-29 | Casey | Kentucky | 21045 | 4211 | 72 |
2451746 | 2451746 | 2022-04-28 | Casey | Kentucky | 21045 | 4211 | 72 |
2448490 | 2448490 | 2022-04-27 | Casey | Kentucky | 21045 | 4211 | 72 |
2445234 | 2445234 | 2022-04-26 | Casey | Kentucky | 21045 | 4211 | 72 |
2441978 | 2441978 | 2022-04-25 | Casey | Kentucky | 21045 | 4211 | 72 |
2438722 | 2438722 | 2022-04-24 | Casey | Kentucky | 21045 | 4212 | 72 |
2435466 | 2435466 | 2022-04-23 | Casey | Kentucky | 21045 | 4212 | 72 |
2432210 | 2432210 | 2022-04-22 | Casey | Kentucky | 21045 | 4212 | 72 |
2428954 | 2428954 | 2022-04-21 | Casey | Kentucky | 21045 | 4212 | 72 |
2425698 | 2425698 | 2022-04-20 | Casey | Kentucky | 21045 | 4212 | 72 |
2422442 | 2422442 | 2022-04-19 | Casey | Kentucky | 21045 | 4212 | 72 |
2419186 | 2419186 | 2022-04-18 | Casey | Kentucky | 21045 | 4212 | 72 |
2415930 | 2415930 | 2022-04-17 | Casey | Kentucky | 21045 | 4210 | 72 |
2412674 | 2412674 | 2022-04-16 | Casey | Kentucky | 21045 | 4210 | 72 |
2409418 | 2409418 | 2022-04-15 | Casey | Kentucky | 21045 | 4210 | 72 |
2406162 | 2406162 | 2022-04-14 | Casey | Kentucky | 21045 | 4210 | 72 |
2402906 | 2402906 | 2022-04-13 | Casey | Kentucky | 21045 | 4210 | 72 |
2399652 | 2399652 | 2022-04-12 | Casey | Kentucky | 21045 | 4210 | 72 |
2396396 | 2396396 | 2022-04-11 | Casey | Kentucky | 21045 | 4210 | 72 |
2393141 | 2393141 | 2022-04-10 | Casey | Kentucky | 21045 | 4210 | 72 |
2389885 | 2389885 | 2022-04-09 | Casey | Kentucky | 21045 | 4210 | 72 |
2386629 | 2386629 | 2022-04-08 | Casey | Kentucky | 21045 | 4210 | 72 |
2383374 | 2383374 | 2022-04-07 | Casey | Kentucky | 21045 | 4210 | 72 |
2380119 | 2380119 | 2022-04-06 | Casey | Kentucky | 21045 | 4210 | 72 |
2376864 | 2376864 | 2022-04-05 | Casey | Kentucky | 21045 | 4210 | 72 |
2373612 | 2373612 | 2022-04-04 | Casey | Kentucky | 21045 | 4210 | 72 |
2370359 | 2370359 | 2022-04-03 | Casey | Kentucky | 21045 | 4203 | 72 |
2367106 | 2367106 | 2022-04-02 | Casey | Kentucky | 21045 | 4203 | 72 |
2363853 | 2363853 | 2022-04-01 | Casey | Kentucky | 21045 | 4203 | 72 |
2360599 | 2360599 | 2022-03-31 | Casey | Kentucky | 21045 | 4203 | 72 |
2357345 | 2357345 | 2022-03-30 | Casey | Kentucky | 21045 | 4203 | 72 |
2354092 | 2354092 | 2022-03-29 | Casey | Kentucky | 21045 | 4203 | 72 |
2350840 | 2350840 | 2022-03-28 | Casey | Kentucky | 21045 | 4203 | 72 |
2347587 | 2347587 | 2022-03-27 | Casey | Kentucky | 21045 | 4161 | 71 |
2344334 | 2344334 | 2022-03-26 | Casey | Kentucky | 21045 | 4161 | 71 |
2341081 | 2341081 | 2022-03-25 | Casey | Kentucky | 21045 | 4161 | 71 |
2337828 | 2337828 | 2022-03-24 | Casey | Kentucky | 21045 | 4161 | 71 |
2334574 | 2334574 | 2022-03-23 | Casey | Kentucky | 21045 | 4161 | 71 |
2331320 | 2331320 | 2022-03-22 | Casey | Kentucky | 21045 | 4161 | 71 |
2328068 | 2328068 | 2022-03-21 | Casey | Kentucky | 21045 | 4161 | 71 |
2324815 | 2324815 | 2022-03-20 | Casey | Kentucky | 21045 | 4015 | 69 |
2321561 | 2321561 | 2022-03-19 | Casey | Kentucky | 21045 | 4015 | 69 |
2318307 | 2318307 | 2022-03-18 | Casey | Kentucky | 21045 | 4015 | 69 |
2315054 | 2315054 | 2022-03-17 | Casey | Kentucky | 21045 | 4015 | 69 |
2311801 | 2311801 | 2022-03-16 | Casey | Kentucky | 21045 | 4015 | 69 |
2308548 | 2308548 | 2022-03-15 | Casey | Kentucky | 21045 | 4015 | 69 |
2305297 | 2305297 | 2022-03-14 | Casey | Kentucky | 21045 | 4015 | 69 |
2302045 | 2302045 | 2022-03-13 | Casey | Kentucky | 21045 | 3959 | 66 |
2298793 | 2298793 | 2022-03-12 | Casey | Kentucky | 21045 | 3959 | 66 |
2295541 | 2295541 | 2022-03-11 | Casey | Kentucky | 21045 | 3959 | 66 |
2292289 | 2292289 | 2022-03-10 | Casey | Kentucky | 21045 | 3959 | 66 |
2289037 | 2289037 | 2022-03-09 | Casey | Kentucky | 21045 | 3959 | 66 |
2285786 | 2285786 | 2022-03-08 | Casey | Kentucky | 21045 | 3959 | 66 |
2282534 | 2282534 | 2022-03-07 | Casey | Kentucky | 21045 | 3959 | 66 |
2279281 | 2279281 | 2022-03-06 | Casey | Kentucky | 21045 | 3955 | 66 |
2276028 | 2276028 | 2022-03-05 | Casey | Kentucky | 21045 | 3955 | 66 |
2272775 | 2272775 | 2022-03-04 | Casey | Kentucky | 21045 | 3955 | 66 |
2269523 | 2269523 | 2022-03-03 | Casey | Kentucky | 21045 | 3934 | 66 |
2266270 | 2266270 | 2022-03-02 | Casey | Kentucky | 21045 | 3931 | 66 |
2263019 | 2263019 | 2022-03-01 | Casey | Kentucky | 21045 | 3921 | 66 |
2259768 | 2259768 | 2022-02-28 | Casey | Kentucky | 21045 | 3915 | 66 |
2256517 | 2256517 | 2022-02-27 | Casey | Kentucky | 21045 | 3900 | 66 |
2253266 | 2253266 | 2022-02-26 | Casey | Kentucky | 21045 | 3900 | 66 |
2250015 | 2250015 | 2022-02-25 | Casey | Kentucky | 21045 | 3900 | 66 |
2246764 | 2246764 | 2022-02-24 | Casey | Kentucky | 21045 | 3884 | 66 |
2243513 | 2243513 | 2022-02-23 | Casey | Kentucky | 21045 | 3884 | 66 |
2240262 | 2240262 | 2022-02-22 | Casey | Kentucky | 21045 | 3874 | 66 |
2237011 | 2237011 | 2022-02-21 | Casey | Kentucky | 21045 | 3852 | 66 |
2233760 | 2233760 | 2022-02-20 | Casey | Kentucky | 21045 | 3824 | 66 |
2230509 | 2230509 | 2022-02-19 | Casey | Kentucky | 21045 | 3824 | 66 |
2227258 | 2227258 | 2022-02-18 | Casey | Kentucky | 21045 | 3824 | 66 |
2224007 | 2224007 | 2022-02-17 | Casey | Kentucky | 21045 | 3802 | 66 |
2220756 | 2220756 | 2022-02-16 | Casey | Kentucky | 21045 | 3779 | 66 |
2217505 | 2217505 | 2022-02-15 | Casey | Kentucky | 21045 | 3757 | 65 |
2214254 | 2214254 | 2022-02-14 | Casey | Kentucky | 21045 | 3720 | 65 |
2211002 | 2211002 | 2022-02-13 | Casey | Kentucky | 21045 | 3634 | 65 |
2207749 | 2207749 | 2022-02-12 | Casey | Kentucky | 21045 | 3634 | 65 |
2204496 | 2204496 | 2022-02-11 | Casey | Kentucky | 21045 | 3634 | 65 |
2201243 | 2201243 | 2022-02-10 | Casey | Kentucky | 21045 | 3613 | 65 |
2197989 | 2197989 | 2022-02-09 | Casey | Kentucky | 21045 | 3597 | 65 |
2194735 | 2194735 | 2022-02-08 | Casey | Kentucky | 21045 | 3590 | 65 |
2191481 | 2191481 | 2022-02-07 | Casey | Kentucky | 21045 | 3579 | 65 |
2188228 | 2188228 | 2022-02-06 | Casey | Kentucky | 21045 | 3561 | 65 |
2184975 | 2184975 | 2022-02-05 | Casey | Kentucky | 21045 | 3561 | 65 |
2181723 | 2181723 | 2022-02-04 | Casey | Kentucky | 21045 | 3561 | 65 |
2178472 | 2178472 | 2022-02-03 | Casey | Kentucky | 21045 | 3547 | 65 |
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);