ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where deaths = 295 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 68
- Pennsylvania 54
- North Carolina 51
- Tennessee 51
- Texas 44
- Oklahoma 40
- Georgia 30
- Idaho 29
- Florida 28
- South Carolina 28
- Indiana 26
- Ohio 26
- Alabama 25
- California 21
- Missouri 21
- Louisiana 20
- Maryland 20
- Minnesota 20
- Michigan 16
- Mississippi 16
- Iowa 15
- Wisconsin 15
- Arizona 9
- Connecticut 9
- Kentucky 9
- New York 9
- Virginia 9
- West Virginia 9
- Maine 7
- New Mexico 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500403 | 2500403 | 2022-05-13 | Dubuque | Iowa | 19061 | 26325 | 295 |
2501026 | 2501026 | 2022-05-13 | Jones | Mississippi | 28067 | 21234 | 295 |
2501756 | 2501756 | 2022-05-13 | Garfield | Oklahoma | 40047 | 15233 | 295 |
2502028 | 2502028 | 2022-05-13 | Laurens | South Carolina | 45059 | 18667 | 295 |
2502684 | 2502684 | 2022-05-13 | Berkeley | West Virginia | 54003 | 36247 | 295 |
2496916 | 2496916 | 2022-05-12 | Twin Falls | Idaho | 16083 | 24115 | 295 |
2497145 | 2497145 | 2022-05-12 | Dubuque | Iowa | 19061 | 26325 | 295 |
2497768 | 2497768 | 2022-05-12 | Jones | Mississippi | 28067 | 21234 | 295 |
2497919 | 2497919 | 2022-05-12 | St. Francois | Missouri | 29187 | 19092 | 295 |
2498498 | 2498498 | 2022-05-12 | Garfield | Oklahoma | 40047 | 15233 | 295 |
2498770 | 2498770 | 2022-05-12 | Laurens | South Carolina | 45059 | 18667 | 295 |
2499426 | 2499426 | 2022-05-12 | Berkeley | West Virginia | 54003 | 36218 | 295 |
2493658 | 2493658 | 2022-05-11 | Twin Falls | Idaho | 16083 | 24115 | 295 |
2493887 | 2493887 | 2022-05-11 | Dubuque | Iowa | 19061 | 26325 | 295 |
2494510 | 2494510 | 2022-05-11 | Jones | Mississippi | 28067 | 21234 | 295 |
2494661 | 2494661 | 2022-05-11 | St. Francois | Missouri | 29187 | 19092 | 295 |
2495240 | 2495240 | 2022-05-11 | Garfield | Oklahoma | 40047 | 15197 | 295 |
2495512 | 2495512 | 2022-05-11 | Laurens | South Carolina | 45059 | 18667 | 295 |
2490400 | 2490400 | 2022-05-10 | Twin Falls | Idaho | 16083 | 24107 | 295 |
2491252 | 2491252 | 2022-05-10 | Jones | Mississippi | 28067 | 21234 | 295 |
2491403 | 2491403 | 2022-05-10 | St. Francois | Missouri | 29187 | 19092 | 295 |
2491982 | 2491982 | 2022-05-10 | Garfield | Oklahoma | 40047 | 15197 | 295 |
2492254 | 2492254 | 2022-05-10 | Laurens | South Carolina | 45059 | 18650 | 295 |
2487143 | 2487143 | 2022-05-09 | Twin Falls | Idaho | 16083 | 24107 | 295 |
2487995 | 2487995 | 2022-05-09 | Jones | Mississippi | 28067 | 21234 | 295 |
2488145 | 2488145 | 2022-05-09 | St. Francois | Missouri | 29187 | 19092 | 295 |
2488724 | 2488724 | 2022-05-09 | Garfield | Oklahoma | 40047 | 15197 | 295 |
2488996 | 2488996 | 2022-05-09 | Laurens | South Carolina | 45059 | 18650 | 295 |
2483885 | 2483885 | 2022-05-08 | Twin Falls | Idaho | 16083 | 24091 | 295 |
2484737 | 2484737 | 2022-05-08 | Jones | Mississippi | 28067 | 21214 | 295 |
2484888 | 2484888 | 2022-05-08 | St. Francois | Missouri | 29187 | 19092 | 295 |
2485467 | 2485467 | 2022-05-08 | Garfield | Oklahoma | 40047 | 15197 | 295 |
2485739 | 2485739 | 2022-05-08 | Laurens | South Carolina | 45059 | 18650 | 295 |
2480627 | 2480627 | 2022-05-07 | Twin Falls | Idaho | 16083 | 24091 | 295 |
2481479 | 2481479 | 2022-05-07 | Jones | Mississippi | 28067 | 21214 | 295 |
2481630 | 2481630 | 2022-05-07 | St. Francois | Missouri | 29187 | 19092 | 295 |
2482209 | 2482209 | 2022-05-07 | Garfield | Oklahoma | 40047 | 15197 | 295 |
2482481 | 2482481 | 2022-05-07 | Laurens | South Carolina | 45059 | 18650 | 295 |
2477369 | 2477369 | 2022-05-06 | Twin Falls | Idaho | 16083 | 24091 | 295 |
2478221 | 2478221 | 2022-05-06 | Jones | Mississippi | 28067 | 21214 | 295 |
2478372 | 2478372 | 2022-05-06 | St. Francois | Missouri | 29187 | 19092 | 295 |
2478951 | 2478951 | 2022-05-06 | Garfield | Oklahoma | 40047 | 15197 | 295 |
2479223 | 2479223 | 2022-05-06 | Laurens | South Carolina | 45059 | 18650 | 295 |
2474111 | 2474111 | 2022-05-05 | Twin Falls | Idaho | 16083 | 24080 | 295 |
2474963 | 2474963 | 2022-05-05 | Jones | Mississippi | 28067 | 21214 | 295 |
2475114 | 2475114 | 2022-05-05 | St. Francois | Missouri | 29187 | 19070 | 295 |
2475693 | 2475693 | 2022-05-05 | Garfield | Oklahoma | 40047 | 15197 | 295 |
2475965 | 2475965 | 2022-05-05 | Laurens | South Carolina | 45059 | 18650 | 295 |
2470854 | 2470854 | 2022-05-04 | Twin Falls | Idaho | 16083 | 24080 | 295 |
2471706 | 2471706 | 2022-05-04 | Jones | Mississippi | 28067 | 21214 | 295 |
2472708 | 2472708 | 2022-05-04 | Laurens | South Carolina | 45059 | 18650 | 295 |
2467598 | 2467598 | 2022-05-03 | Twin Falls | Idaho | 16083 | 24060 | 295 |
2468450 | 2468450 | 2022-05-03 | Jones | Mississippi | 28067 | 21214 | 295 |
2469452 | 2469452 | 2022-05-03 | Laurens | South Carolina | 45059 | 18650 | 295 |
2464343 | 2464343 | 2022-05-02 | Twin Falls | Idaho | 16083 | 24060 | 295 |
2465195 | 2465195 | 2022-05-02 | Jones | Mississippi | 28067 | 21214 | 295 |
2461087 | 2461087 | 2022-05-01 | Twin Falls | Idaho | 16083 | 24056 | 295 |
2457831 | 2457831 | 2022-04-30 | Twin Falls | Idaho | 16083 | 24056 | 295 |
2454575 | 2454575 | 2022-04-29 | Twin Falls | Idaho | 16083 | 24056 | 295 |
2451319 | 2451319 | 2022-04-28 | Twin Falls | Idaho | 16083 | 24051 | 295 |
2448063 | 2448063 | 2022-04-27 | Twin Falls | Idaho | 16083 | 24051 | 295 |
2444807 | 2444807 | 2022-04-26 | Twin Falls | Idaho | 16083 | 24047 | 295 |
2441551 | 2441551 | 2022-04-25 | Twin Falls | Idaho | 16083 | 24047 | 295 |
2438295 | 2438295 | 2022-04-24 | Twin Falls | Idaho | 16083 | 24041 | 295 |
2438797 | 2438797 | 2022-04-24 | Pike | Kentucky | 21195 | 18979 | 295 |
2435039 | 2435039 | 2022-04-23 | Twin Falls | Idaho | 16083 | 24041 | 295 |
2435541 | 2435541 | 2022-04-23 | Pike | Kentucky | 21195 | 18979 | 295 |
2431783 | 2431783 | 2022-04-22 | Twin Falls | Idaho | 16083 | 24041 | 295 |
2432285 | 2432285 | 2022-04-22 | Pike | Kentucky | 21195 | 18979 | 295 |
2429029 | 2429029 | 2022-04-21 | Pike | Kentucky | 21195 | 18979 | 295 |
2425283 | 2425283 | 2022-04-20 | Champaign | Illinois | 17019 | 64315 | 295 |
2425773 | 2425773 | 2022-04-20 | Pike | Kentucky | 21195 | 18979 | 295 |
2422027 | 2422027 | 2022-04-19 | Champaign | Illinois | 17019 | 64151 | 295 |
2422517 | 2422517 | 2022-04-19 | Pike | Kentucky | 21195 | 18979 | 295 |
2418771 | 2418771 | 2022-04-18 | Champaign | Illinois | 17019 | 63978 | 295 |
2419261 | 2419261 | 2022-04-18 | Pike | Kentucky | 21195 | 18979 | 295 |
2415515 | 2415515 | 2022-04-17 | Champaign | Illinois | 17019 | 63786 | 295 |
2412259 | 2412259 | 2022-04-16 | Champaign | Illinois | 17019 | 63786 | 295 |
2409003 | 2409003 | 2022-04-15 | Champaign | Illinois | 17019 | 63786 | 295 |
2405747 | 2405747 | 2022-04-14 | Champaign | Illinois | 17019 | 63646 | 295 |
2402492 | 2402492 | 2022-04-13 | Champaign | Illinois | 17019 | 63459 | 295 |
2404019 | 2404019 | 2022-04-13 | Ross | Ohio | 39141 | 19236 | 295 |
2399237 | 2399237 | 2022-04-12 | Champaign | Illinois | 17019 | 63243 | 295 |
2400764 | 2400764 | 2022-04-12 | Ross | Ohio | 39141 | 19236 | 295 |
2401675 | 2401675 | 2022-04-12 | Spotsylvania | Virginia | 51177 | 26881 | 295 |
2395982 | 2395982 | 2022-04-11 | Champaign | Illinois | 17019 | 63028 | 295 |
2397509 | 2397509 | 2022-04-11 | Ross | Ohio | 39141 | 19236 | 295 |
2392726 | 2392726 | 2022-04-10 | Champaign | Illinois | 17019 | 62825 | 295 |
2394254 | 2394254 | 2022-04-10 | Ross | Ohio | 39141 | 19236 | 295 |
2389470 | 2389470 | 2022-04-09 | Champaign | Illinois | 17019 | 62825 | 295 |
2390998 | 2390998 | 2022-04-09 | Ross | Ohio | 39141 | 19236 | 295 |
2386215 | 2386215 | 2022-04-08 | Champaign | Illinois | 17019 | 62825 | 295 |
2387742 | 2387742 | 2022-04-08 | Ross | Ohio | 39141 | 19236 | 295 |
2382960 | 2382960 | 2022-04-07 | Champaign | Illinois | 17019 | 62736 | 295 |
2384487 | 2384487 | 2022-04-07 | Ross | Ohio | 39141 | 19236 | 295 |
2385401 | 2385401 | 2022-04-07 | Suffolk city | Virginia | 51800 | 18677 | 295 |
2379571 | 2379571 | 2022-04-06 | Laurens | Georgia | 13175 | 13764 | 295 |
2379705 | 2379705 | 2022-04-06 | Champaign | Illinois | 17019 | 62673 | 295 |
2376317 | 2376317 | 2022-04-05 | Laurens | Georgia | 13175 | 13764 | 295 |
2376451 | 2376451 | 2022-04-05 | Champaign | Illinois | 17019 | 62587 | 295 |
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);