ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
756 rows where deaths = 282 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 67
- Missouri 46
- Virginia 45
- Florida 44
- Georgia 41
- Oklahoma 37
- Ohio 36
- North Carolina 33
- Iowa 30
- Indiana 27
- Kentucky 26
- Texas 26
- Alabama 24
- Massachusetts 23
- Michigan 22
- Illinois 21
- Arizona 18
- Wisconsin 17
- Washington 16
- Pennsylvania 14
- Colorado 12
- Maryland 12
- South Carolina 12
- Connecticut 11
- Arkansas 9
- Idaho 9
- New Jersey 9
- New Mexico 9
- California 7
- Montana 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499999 | 2499999 | 2022-05-13 | Coffee | Georgia | 13069 | 10872 | 282 |
2501402 | 2501402 | 2022-05-13 | Eddy | New Mexico | 35015 | 17069 | 282 |
2502542 | 2502542 | 2022-05-13 | Danville city | Virginia | 51590 | 11226 | 282 |
2502616 | 2502616 | 2022-05-13 | Roanoke | Virginia | 51161 | 21633 | 282 |
2496741 | 2496741 | 2022-05-12 | Coffee | Georgia | 13069 | 10872 | 282 |
2498144 | 2498144 | 2022-05-12 | Eddy | New Mexico | 35015 | 17063 | 282 |
2499284 | 2499284 | 2022-05-12 | Danville city | Virginia | 51590 | 11207 | 282 |
2499358 | 2499358 | 2022-05-12 | Roanoke | Virginia | 51161 | 21590 | 282 |
2493483 | 2493483 | 2022-05-11 | Coffee | Georgia | 13069 | 10872 | 282 |
2496026 | 2496026 | 2022-05-11 | Danville city | Virginia | 51590 | 11191 | 282 |
2496100 | 2496100 | 2022-05-11 | Roanoke | Virginia | 51161 | 21540 | 282 |
2491646 | 2491646 | 2022-05-10 | Santa Fe | New Mexico | 35049 | 29358 | 282 |
2492768 | 2492768 | 2022-05-10 | Danville city | Virginia | 51590 | 11182 | 282 |
2489510 | 2489510 | 2022-05-09 | Danville city | Virginia | 51590 | 11182 | 282 |
2486253 | 2486253 | 2022-05-08 | Danville city | Virginia | 51590 | 11163 | 282 |
2482995 | 2482995 | 2022-05-07 | Danville city | Virginia | 51590 | 11163 | 282 |
2479737 | 2479737 | 2022-05-06 | Danville city | Virginia | 51590 | 11163 | 282 |
2476479 | 2476479 | 2022-05-05 | Danville city | Virginia | 51590 | 11149 | 282 |
2471781 | 2471781 | 2022-05-04 | Cole | Missouri | 29051 | 20121 | 282 |
2473221 | 2473221 | 2022-05-04 | Danville city | Virginia | 51590 | 11152 | 282 |
2467423 | 2467423 | 2022-05-03 | Coffee | Georgia | 13069 | 11128 | 282 |
2468525 | 2468525 | 2022-05-03 | Cole | Missouri | 29051 | 20121 | 282 |
2469965 | 2469965 | 2022-05-03 | Danville city | Virginia | 51590 | 11120 | 282 |
2464168 | 2464168 | 2022-05-02 | Coffee | Georgia | 13069 | 11128 | 282 |
2465269 | 2465269 | 2022-05-02 | Cole | Missouri | 29051 | 20121 | 282 |
2466709 | 2466709 | 2022-05-02 | Danville city | Virginia | 51590 | 11113 | 282 |
2460912 | 2460912 | 2022-05-01 | Coffee | Georgia | 13069 | 11128 | 282 |
2461591 | 2461591 | 2022-05-01 | Pulaski | Kentucky | 21199 | 18107 | 282 |
2462014 | 2462014 | 2022-05-01 | Cole | Missouri | 29051 | 20121 | 282 |
2463454 | 2463454 | 2022-05-01 | Danville city | Virginia | 51590 | 11090 | 282 |
2457656 | 2457656 | 2022-04-30 | Coffee | Georgia | 13069 | 11128 | 282 |
2458335 | 2458335 | 2022-04-30 | Pulaski | Kentucky | 21199 | 18107 | 282 |
2458758 | 2458758 | 2022-04-30 | Cole | Missouri | 29051 | 20121 | 282 |
2460198 | 2460198 | 2022-04-30 | Danville city | Virginia | 51590 | 11090 | 282 |
2454400 | 2454400 | 2022-04-29 | Coffee | Georgia | 13069 | 11128 | 282 |
2455079 | 2455079 | 2022-04-29 | Pulaski | Kentucky | 21199 | 18107 | 282 |
2455502 | 2455502 | 2022-04-29 | Cole | Missouri | 29051 | 20121 | 282 |
2456942 | 2456942 | 2022-04-29 | Danville city | Virginia | 51590 | 11090 | 282 |
2451144 | 2451144 | 2022-04-28 | Coffee | Georgia | 13069 | 11128 | 282 |
2451823 | 2451823 | 2022-04-28 | Pulaski | Kentucky | 21199 | 18107 | 282 |
2452246 | 2452246 | 2022-04-28 | Cole | Missouri | 29051 | 20121 | 282 |
2447888 | 2447888 | 2022-04-27 | Coffee | Georgia | 13069 | 11128 | 282 |
2448567 | 2448567 | 2022-04-27 | Pulaski | Kentucky | 21199 | 18107 | 282 |
2448990 | 2448990 | 2022-04-27 | Cole | Missouri | 29051 | 20121 | 282 |
2449684 | 2449684 | 2022-04-27 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2444632 | 2444632 | 2022-04-26 | Coffee | Georgia | 13069 | 11138 | 282 |
2445311 | 2445311 | 2022-04-26 | Pulaski | Kentucky | 21199 | 18107 | 282 |
2445733 | 2445733 | 2022-04-26 | Cole | Missouri | 29051 | 20121 | 282 |
2446427 | 2446427 | 2022-04-26 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2441376 | 2441376 | 2022-04-25 | Coffee | Georgia | 13069 | 11138 | 282 |
2442055 | 2442055 | 2022-04-25 | Pulaski | Kentucky | 21199 | 18107 | 282 |
2442478 | 2442478 | 2022-04-25 | Cole | Missouri | 29051 | 20121 | 282 |
2443172 | 2443172 | 2022-04-25 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2438120 | 2438120 | 2022-04-24 | Coffee | Georgia | 13069 | 11139 | 282 |
2438707 | 2438707 | 2022-04-24 | Boone | Kentucky | 21015 | 39767 | 282 |
2439222 | 2439222 | 2022-04-24 | Cole | Missouri | 29051 | 20121 | 282 |
2439916 | 2439916 | 2022-04-24 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2434864 | 2434864 | 2022-04-23 | Coffee | Georgia | 13069 | 11139 | 282 |
2435451 | 2435451 | 2022-04-23 | Boone | Kentucky | 21015 | 39767 | 282 |
2435966 | 2435966 | 2022-04-23 | Cole | Missouri | 29051 | 20121 | 282 |
2436660 | 2436660 | 2022-04-23 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2431608 | 2431608 | 2022-04-22 | Coffee | Georgia | 13069 | 11139 | 282 |
2432195 | 2432195 | 2022-04-22 | Boone | Kentucky | 21015 | 39767 | 282 |
2432710 | 2432710 | 2022-04-22 | Cole | Missouri | 29051 | 20121 | 282 |
2433404 | 2433404 | 2022-04-22 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2428352 | 2428352 | 2022-04-21 | Coffee | Georgia | 13069 | 11139 | 282 |
2428939 | 2428939 | 2022-04-21 | Boone | Kentucky | 21015 | 39700 | 282 |
2429454 | 2429454 | 2022-04-21 | Cole | Missouri | 29051 | 20121 | 282 |
2430148 | 2430148 | 2022-04-21 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2425096 | 2425096 | 2022-04-20 | Coffee | Georgia | 13069 | 11139 | 282 |
2425683 | 2425683 | 2022-04-20 | Boone | Kentucky | 21015 | 39700 | 282 |
2426198 | 2426198 | 2022-04-20 | Cole | Missouri | 29051 | 20121 | 282 |
2421840 | 2421840 | 2022-04-19 | Coffee | Georgia | 13069 | 11187 | 282 |
2422427 | 2422427 | 2022-04-19 | Boone | Kentucky | 21015 | 39700 | 282 |
2422942 | 2422942 | 2022-04-19 | Cole | Missouri | 29051 | 20121 | 282 |
2418584 | 2418584 | 2022-04-18 | Coffee | Georgia | 13069 | 11187 | 282 |
2419171 | 2419171 | 2022-04-18 | Boone | Kentucky | 21015 | 39700 | 282 |
2419685 | 2419685 | 2022-04-18 | Cole | Missouri | 29051 | 20121 | 282 |
2421200 | 2421200 | 2022-04-18 | Roanoke | Virginia | 51161 | 21126 | 282 |
2415328 | 2415328 | 2022-04-17 | Coffee | Georgia | 13069 | 11188 | 282 |
2416430 | 2416430 | 2022-04-17 | Cole | Missouri | 29051 | 20121 | 282 |
2412072 | 2412072 | 2022-04-16 | Coffee | Georgia | 13069 | 11188 | 282 |
2413174 | 2413174 | 2022-04-16 | Cole | Missouri | 29051 | 20121 | 282 |
2408816 | 2408816 | 2022-04-15 | Coffee | Georgia | 13069 | 11188 | 282 |
2409918 | 2409918 | 2022-04-15 | Cole | Missouri | 29051 | 20121 | 282 |
2406662 | 2406662 | 2022-04-14 | Cole | Missouri | 29051 | 20121 | 282 |
2403406 | 2403406 | 2022-04-13 | Cole | Missouri | 29051 | 20121 | 282 |
2400151 | 2400151 | 2022-04-12 | Cole | Missouri | 29051 | 20121 | 282 |
2396896 | 2396896 | 2022-04-11 | Cole | Missouri | 29051 | 20121 | 282 |
2393641 | 2393641 | 2022-04-10 | Cole | Missouri | 29051 | 20121 | 282 |
2390385 | 2390385 | 2022-04-09 | Cole | Missouri | 29051 | 20121 | 282 |
2387129 | 2387129 | 2022-04-08 | Cole | Missouri | 29051 | 20121 | 282 |
2383874 | 2383874 | 2022-04-07 | Cole | Missouri | 29051 | 20121 | 282 |
2380619 | 2380619 | 2022-04-06 | Cole | Missouri | 29051 | 20121 | 282 |
2376264 | 2376264 | 2022-04-05 | Coffee | Georgia | 13069 | 11172 | 282 |
2377364 | 2377364 | 2022-04-05 | Cole | Missouri | 29051 | 20121 | 282 |
2373012 | 2373012 | 2022-04-04 | Coffee | Georgia | 13069 | 11164 | 282 |
2374111 | 2374111 | 2022-04-04 | Cole | Missouri | 29051 | 20121 | 282 |
2370434 | 2370434 | 2022-04-03 | Pike | Kentucky | 21195 | 18873 | 282 |
2370859 | 2370859 | 2022-04-03 | Cole | Missouri | 29051 | 20121 | 282 |
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);