ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where fips = 21195 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 |
---|---|---|---|---|---|---|---|
2500676 | 2500676 | 2022-05-13 | Pike | Kentucky | 21195 | 19099 | 307 |
2497418 | 2497418 | 2022-05-12 | Pike | Kentucky | 21195 | 19099 | 307 |
2494160 | 2494160 | 2022-05-11 | Pike | Kentucky | 21195 | 19099 | 307 |
2490902 | 2490902 | 2022-05-10 | Pike | Kentucky | 21195 | 19099 | 307 |
2487645 | 2487645 | 2022-05-09 | Pike | Kentucky | 21195 | 19099 | 307 |
2484387 | 2484387 | 2022-05-08 | Pike | Kentucky | 21195 | 19051 | 301 |
2481129 | 2481129 | 2022-05-07 | Pike | Kentucky | 21195 | 19051 | 301 |
2477871 | 2477871 | 2022-05-06 | Pike | Kentucky | 21195 | 19051 | 301 |
2474613 | 2474613 | 2022-05-05 | Pike | Kentucky | 21195 | 19051 | 301 |
2471356 | 2471356 | 2022-05-04 | Pike | Kentucky | 21195 | 19051 | 301 |
2468100 | 2468100 | 2022-05-03 | Pike | Kentucky | 21195 | 19051 | 301 |
2464845 | 2464845 | 2022-05-02 | Pike | Kentucky | 21195 | 19051 | 301 |
2461589 | 2461589 | 2022-05-01 | Pike | Kentucky | 21195 | 19001 | 298 |
2458333 | 2458333 | 2022-04-30 | Pike | Kentucky | 21195 | 19001 | 298 |
2455077 | 2455077 | 2022-04-29 | Pike | Kentucky | 21195 | 19001 | 298 |
2451821 | 2451821 | 2022-04-28 | Pike | Kentucky | 21195 | 19001 | 298 |
2448565 | 2448565 | 2022-04-27 | Pike | Kentucky | 21195 | 19001 | 298 |
2445309 | 2445309 | 2022-04-26 | Pike | Kentucky | 21195 | 19001 | 298 |
2442053 | 2442053 | 2022-04-25 | Pike | Kentucky | 21195 | 19001 | 298 |
2438797 | 2438797 | 2022-04-24 | Pike | Kentucky | 21195 | 18979 | 295 |
2435541 | 2435541 | 2022-04-23 | Pike | Kentucky | 21195 | 18979 | 295 |
2432285 | 2432285 | 2022-04-22 | Pike | Kentucky | 21195 | 18979 | 295 |
2429029 | 2429029 | 2022-04-21 | Pike | Kentucky | 21195 | 18979 | 295 |
2425773 | 2425773 | 2022-04-20 | Pike | Kentucky | 21195 | 18979 | 295 |
2422517 | 2422517 | 2022-04-19 | Pike | Kentucky | 21195 | 18979 | 295 |
2419261 | 2419261 | 2022-04-18 | Pike | Kentucky | 21195 | 18979 | 295 |
2416005 | 2416005 | 2022-04-17 | Pike | Kentucky | 21195 | 18938 | 294 |
2412749 | 2412749 | 2022-04-16 | Pike | Kentucky | 21195 | 18938 | 294 |
2409493 | 2409493 | 2022-04-15 | Pike | Kentucky | 21195 | 18938 | 294 |
2406237 | 2406237 | 2022-04-14 | Pike | Kentucky | 21195 | 18938 | 294 |
2402981 | 2402981 | 2022-04-13 | Pike | Kentucky | 21195 | 18938 | 294 |
2399727 | 2399727 | 2022-04-12 | Pike | Kentucky | 21195 | 18938 | 294 |
2396471 | 2396471 | 2022-04-11 | Pike | Kentucky | 21195 | 18938 | 294 |
2393216 | 2393216 | 2022-04-10 | Pike | Kentucky | 21195 | 18899 | 290 |
2389960 | 2389960 | 2022-04-09 | Pike | Kentucky | 21195 | 18899 | 290 |
2386704 | 2386704 | 2022-04-08 | Pike | Kentucky | 21195 | 18899 | 290 |
2383449 | 2383449 | 2022-04-07 | Pike | Kentucky | 21195 | 18899 | 290 |
2380194 | 2380194 | 2022-04-06 | Pike | Kentucky | 21195 | 18899 | 290 |
2376939 | 2376939 | 2022-04-05 | Pike | Kentucky | 21195 | 18899 | 290 |
2373687 | 2373687 | 2022-04-04 | Pike | Kentucky | 21195 | 18899 | 290 |
2370434 | 2370434 | 2022-04-03 | Pike | Kentucky | 21195 | 18873 | 282 |
2367181 | 2367181 | 2022-04-02 | Pike | Kentucky | 21195 | 18873 | 282 |
2363928 | 2363928 | 2022-04-01 | Pike | Kentucky | 21195 | 18873 | 282 |
2360674 | 2360674 | 2022-03-31 | Pike | Kentucky | 21195 | 18873 | 282 |
2357420 | 2357420 | 2022-03-30 | Pike | Kentucky | 21195 | 18873 | 282 |
2354167 | 2354167 | 2022-03-29 | Pike | Kentucky | 21195 | 18873 | 282 |
2350915 | 2350915 | 2022-03-28 | Pike | Kentucky | 21195 | 18873 | 282 |
2347662 | 2347662 | 2022-03-27 | Pike | Kentucky | 21195 | 18808 | 276 |
2344409 | 2344409 | 2022-03-26 | Pike | Kentucky | 21195 | 18808 | 276 |
2341156 | 2341156 | 2022-03-25 | Pike | Kentucky | 21195 | 18808 | 276 |
2337903 | 2337903 | 2022-03-24 | Pike | Kentucky | 21195 | 18808 | 276 |
2334649 | 2334649 | 2022-03-23 | Pike | Kentucky | 21195 | 18808 | 276 |
2331395 | 2331395 | 2022-03-22 | Pike | Kentucky | 21195 | 18808 | 276 |
2328143 | 2328143 | 2022-03-21 | Pike | Kentucky | 21195 | 18808 | 276 |
2324890 | 2324890 | 2022-03-20 | Pike | Kentucky | 21195 | 18706 | 264 |
2321636 | 2321636 | 2022-03-19 | Pike | Kentucky | 21195 | 18706 | 264 |
2318382 | 2318382 | 2022-03-18 | Pike | Kentucky | 21195 | 18706 | 264 |
2315129 | 2315129 | 2022-03-17 | Pike | Kentucky | 21195 | 18706 | 264 |
2311876 | 2311876 | 2022-03-16 | Pike | Kentucky | 21195 | 18706 | 264 |
2308623 | 2308623 | 2022-03-15 | Pike | Kentucky | 21195 | 18706 | 264 |
2305372 | 2305372 | 2022-03-14 | Pike | Kentucky | 21195 | 18706 | 264 |
2302120 | 2302120 | 2022-03-13 | Pike | Kentucky | 21195 | 18443 | 261 |
2298868 | 2298868 | 2022-03-12 | Pike | Kentucky | 21195 | 18443 | 261 |
2295616 | 2295616 | 2022-03-11 | Pike | Kentucky | 21195 | 18443 | 261 |
2292364 | 2292364 | 2022-03-10 | Pike | Kentucky | 21195 | 18443 | 261 |
2289112 | 2289112 | 2022-03-09 | Pike | Kentucky | 21195 | 18443 | 261 |
2285861 | 2285861 | 2022-03-08 | Pike | Kentucky | 21195 | 18443 | 261 |
2282609 | 2282609 | 2022-03-07 | Pike | Kentucky | 21195 | 18443 | 261 |
2279356 | 2279356 | 2022-03-06 | Pike | Kentucky | 21195 | 18403 | 258 |
2276103 | 2276103 | 2022-03-05 | Pike | Kentucky | 21195 | 18403 | 258 |
2272850 | 2272850 | 2022-03-04 | Pike | Kentucky | 21195 | 18403 | 258 |
2269598 | 2269598 | 2022-03-03 | Pike | Kentucky | 21195 | 18267 | 257 |
2266345 | 2266345 | 2022-03-02 | Pike | Kentucky | 21195 | 18088 | 257 |
2263094 | 2263094 | 2022-03-01 | Pike | Kentucky | 21195 | 17928 | 252 |
2259843 | 2259843 | 2022-02-28 | Pike | Kentucky | 21195 | 17735 | 248 |
2256592 | 2256592 | 2022-02-27 | Pike | Kentucky | 21195 | 17662 | 246 |
2253341 | 2253341 | 2022-02-26 | Pike | Kentucky | 21195 | 17662 | 246 |
2250090 | 2250090 | 2022-02-25 | Pike | Kentucky | 21195 | 17662 | 246 |
2246839 | 2246839 | 2022-02-24 | Pike | Kentucky | 21195 | 17473 | 243 |
2243588 | 2243588 | 2022-02-23 | Pike | Kentucky | 21195 | 17473 | 243 |
2240337 | 2240337 | 2022-02-22 | Pike | Kentucky | 21195 | 17359 | 243 |
2237086 | 2237086 | 2022-02-21 | Pike | Kentucky | 21195 | 17205 | 243 |
2233835 | 2233835 | 2022-02-20 | Pike | Kentucky | 21195 | 17105 | 243 |
2230584 | 2230584 | 2022-02-19 | Pike | Kentucky | 21195 | 17105 | 243 |
2227333 | 2227333 | 2022-02-18 | Pike | Kentucky | 21195 | 17105 | 243 |
2224082 | 2224082 | 2022-02-17 | Pike | Kentucky | 21195 | 17047 | 242 |
2220831 | 2220831 | 2022-02-16 | Pike | Kentucky | 21195 | 16900 | 242 |
2217580 | 2217580 | 2022-02-15 | Pike | Kentucky | 21195 | 16787 | 242 |
2214329 | 2214329 | 2022-02-14 | Pike | Kentucky | 21195 | 16642 | 242 |
2211077 | 2211077 | 2022-02-13 | Pike | Kentucky | 21195 | 16381 | 242 |
2207824 | 2207824 | 2022-02-12 | Pike | Kentucky | 21195 | 16381 | 242 |
2204571 | 2204571 | 2022-02-11 | Pike | Kentucky | 21195 | 16381 | 242 |
2201318 | 2201318 | 2022-02-10 | Pike | Kentucky | 21195 | 16285 | 241 |
2198064 | 2198064 | 2022-02-09 | Pike | Kentucky | 21195 | 16187 | 241 |
2194810 | 2194810 | 2022-02-08 | Pike | Kentucky | 21195 | 16064 | 241 |
2191556 | 2191556 | 2022-02-07 | Pike | Kentucky | 21195 | 15900 | 241 |
2188303 | 2188303 | 2022-02-06 | Pike | Kentucky | 21195 | 15790 | 240 |
2185050 | 2185050 | 2022-02-05 | Pike | Kentucky | 21195 | 15790 | 240 |
2181798 | 2181798 | 2022-02-04 | Pike | Kentucky | 21195 | 15790 | 240 |
2178547 | 2178547 | 2022-02-03 | Pike | Kentucky | 21195 | 15698 | 240 |
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);