ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14,712 rows where deaths = 39 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 1,198
- Missouri 872
- Georgia 778
- Tennessee 747
- Virginia 746
- North Carolina 699
- Iowa 693
- Mississippi 639
- Kentucky 607
- Arkansas 557
- South Dakota 503
- Oklahoma 450
- Minnesota 417
- Indiana 391
- Ohio 383
- Illinois 381
- Alabama 377
- Louisiana 374
- Michigan 332
- Wisconsin 327
- Vermont 314
- Kansas 310
- New York 305
- Wyoming 214
- Idaho 205
- West Virginia 190
- North Dakota 174
- California 172
- Oregon 161
- Colorado 156
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500119 | 2500119 | 2022-05-13 | Wheeler | Georgia | 13309 | 1414 | 39 |
2500219 | 2500219 | 2022-05-13 | Jo Daviess | Illinois | 17085 | 4105 | 39 |
2500986 | 2500986 | 2022-05-13 | Waseca | Minnesota | 27161 | 5587 | 39 |
2501088 | 2501088 | 2022-05-13 | Caldwell | Missouri | 29025 | 1700 | 39 |
2501139 | 2501139 | 2022-05-13 | Maries | Missouri | 29125 | 1606 | 39 |
2501180 | 2501180 | 2022-05-13 | Ste. Genevieve | Missouri | 29186 | 3689 | 39 |
2501537 | 2501537 | 2022-05-13 | Jones | North Carolina | 37103 | 2235 | 39 |
2501596 | 2501596 | 2022-05-13 | Dickey | North Dakota | 38021 | 1496 | 39 |
2501775 | 2501775 | 2022-05-13 | Love | Oklahoma | 40085 | 3109 | 39 |
2501784 | 2501784 | 2022-05-13 | Noble | Oklahoma | 40103 | 3050 | 39 |
2502048 | 2502048 | 2022-05-13 | Bon Homme | South Dakota | 46009 | 2292 | 39 |
2502067 | 2502067 | 2022-05-13 | Fall River | South Dakota | 46047 | 1807 | 39 |
2502215 | 2502215 | 2022-05-13 | Bailey | Texas | 48017 | 1511 | 39 |
2502310 | 2502310 | 2022-05-13 | Haskell | Texas | 48207 | 897 | 39 |
2502574 | 2502574 | 2022-05-13 | King George | Virginia | 51099 | 5119 | 39 |
2502582 | 2502582 | 2022-05-13 | Lunenburg | Virginia | 51111 | 2460 | 39 |
2502643 | 2502643 | 2022-05-13 | Adams | Washington | 53001 | 4926 | 39 |
2502830 | 2502830 | 2022-05-13 | Uinta | Wyoming | 56041 | 5643 | 39 |
2496861 | 2496861 | 2022-05-12 | Wheeler | Georgia | 13309 | 1414 | 39 |
2496961 | 2496961 | 2022-05-12 | Jo Daviess | Illinois | 17085 | 4095 | 39 |
2497728 | 2497728 | 2022-05-12 | Waseca | Minnesota | 27161 | 5585 | 39 |
2497830 | 2497830 | 2022-05-12 | Caldwell | Missouri | 29025 | 1697 | 39 |
2497881 | 2497881 | 2022-05-12 | Maries | Missouri | 29125 | 1605 | 39 |
2497922 | 2497922 | 2022-05-12 | Ste. Genevieve | Missouri | 29186 | 3671 | 39 |
2498279 | 2498279 | 2022-05-12 | Jones | North Carolina | 37103 | 2235 | 39 |
2498338 | 2498338 | 2022-05-12 | Dickey | North Dakota | 38021 | 1492 | 39 |
2498517 | 2498517 | 2022-05-12 | Love | Oklahoma | 40085 | 3109 | 39 |
2498526 | 2498526 | 2022-05-12 | Noble | Oklahoma | 40103 | 3050 | 39 |
2498790 | 2498790 | 2022-05-12 | Bon Homme | South Dakota | 46009 | 2292 | 39 |
2498809 | 2498809 | 2022-05-12 | Fall River | South Dakota | 46047 | 1807 | 39 |
2498957 | 2498957 | 2022-05-12 | Bailey | Texas | 48017 | 1511 | 39 |
2499052 | 2499052 | 2022-05-12 | Haskell | Texas | 48207 | 897 | 39 |
2499316 | 2499316 | 2022-05-12 | King George | Virginia | 51099 | 5105 | 39 |
2499324 | 2499324 | 2022-05-12 | Lunenburg | Virginia | 51111 | 2458 | 39 |
2499385 | 2499385 | 2022-05-12 | Adams | Washington | 53001 | 4925 | 39 |
2499572 | 2499572 | 2022-05-12 | Uinta | Wyoming | 56041 | 5643 | 39 |
2493603 | 2493603 | 2022-05-11 | Wheeler | Georgia | 13309 | 1414 | 39 |
2493703 | 2493703 | 2022-05-11 | Jo Daviess | Illinois | 17085 | 4091 | 39 |
2494384 | 2494384 | 2022-05-11 | Unknown | Michigan | 12461 | 39 | |
2494470 | 2494470 | 2022-05-11 | Waseca | Minnesota | 27161 | 5580 | 39 |
2494572 | 2494572 | 2022-05-11 | Caldwell | Missouri | 29025 | 1697 | 39 |
2494623 | 2494623 | 2022-05-11 | Maries | Missouri | 29125 | 1605 | 39 |
2494664 | 2494664 | 2022-05-11 | Ste. Genevieve | Missouri | 29186 | 3671 | 39 |
2495021 | 2495021 | 2022-05-11 | Jones | North Carolina | 37103 | 2235 | 39 |
2495080 | 2495080 | 2022-05-11 | Dickey | North Dakota | 38021 | 1492 | 39 |
2495259 | 2495259 | 2022-05-11 | Love | Oklahoma | 40085 | 3103 | 39 |
2495268 | 2495268 | 2022-05-11 | Noble | Oklahoma | 40103 | 3044 | 39 |
2495532 | 2495532 | 2022-05-11 | Bon Homme | South Dakota | 46009 | 2292 | 39 |
2495551 | 2495551 | 2022-05-11 | Fall River | South Dakota | 46047 | 1807 | 39 |
2495699 | 2495699 | 2022-05-11 | Bailey | Texas | 48017 | 1511 | 39 |
2495794 | 2495794 | 2022-05-11 | Haskell | Texas | 48207 | 897 | 39 |
2496058 | 2496058 | 2022-05-11 | King George | Virginia | 51099 | 5095 | 39 |
2496066 | 2496066 | 2022-05-11 | Lunenburg | Virginia | 51111 | 2457 | 39 |
2496127 | 2496127 | 2022-05-11 | Adams | Washington | 53001 | 4925 | 39 |
2496314 | 2496314 | 2022-05-11 | Uinta | Wyoming | 56041 | 5643 | 39 |
2490345 | 2490345 | 2022-05-10 | Wheeler | Georgia | 13309 | 1414 | 39 |
2490445 | 2490445 | 2022-05-10 | Jo Daviess | Illinois | 17085 | 4088 | 39 |
2491212 | 2491212 | 2022-05-10 | Waseca | Minnesota | 27161 | 5577 | 39 |
2491314 | 2491314 | 2022-05-10 | Caldwell | Missouri | 29025 | 1697 | 39 |
2491365 | 2491365 | 2022-05-10 | Maries | Missouri | 29125 | 1605 | 39 |
2491406 | 2491406 | 2022-05-10 | Ste. Genevieve | Missouri | 29186 | 3671 | 39 |
2491763 | 2491763 | 2022-05-10 | Jones | North Carolina | 37103 | 2225 | 39 |
2491822 | 2491822 | 2022-05-10 | Dickey | North Dakota | 38021 | 1492 | 39 |
2492001 | 2492001 | 2022-05-10 | Love | Oklahoma | 40085 | 3103 | 39 |
2492010 | 2492010 | 2022-05-10 | Noble | Oklahoma | 40103 | 3044 | 39 |
2492274 | 2492274 | 2022-05-10 | Bon Homme | South Dakota | 46009 | 2293 | 39 |
2492293 | 2492293 | 2022-05-10 | Fall River | South Dakota | 46047 | 1806 | 39 |
2492441 | 2492441 | 2022-05-10 | Bailey | Texas | 48017 | 1511 | 39 |
2492536 | 2492536 | 2022-05-10 | Haskell | Texas | 48207 | 897 | 39 |
2492808 | 2492808 | 2022-05-10 | Lunenburg | Virginia | 51111 | 2455 | 39 |
2493056 | 2493056 | 2022-05-10 | Uinta | Wyoming | 56041 | 5643 | 39 |
2487088 | 2487088 | 2022-05-09 | Wheeler | Georgia | 13309 | 1414 | 39 |
2487188 | 2487188 | 2022-05-09 | Jo Daviess | Illinois | 17085 | 4082 | 39 |
2487955 | 2487955 | 2022-05-09 | Waseca | Minnesota | 27161 | 5573 | 39 |
2488056 | 2488056 | 2022-05-09 | Caldwell | Missouri | 29025 | 1697 | 39 |
2488107 | 2488107 | 2022-05-09 | Maries | Missouri | 29125 | 1605 | 39 |
2488148 | 2488148 | 2022-05-09 | Ste. Genevieve | Missouri | 29186 | 3671 | 39 |
2488505 | 2488505 | 2022-05-09 | Jones | North Carolina | 37103 | 2225 | 39 |
2488564 | 2488564 | 2022-05-09 | Dickey | North Dakota | 38021 | 1492 | 39 |
2488743 | 2488743 | 2022-05-09 | Love | Oklahoma | 40085 | 3103 | 39 |
2488752 | 2488752 | 2022-05-09 | Noble | Oklahoma | 40103 | 3044 | 39 |
2489016 | 2489016 | 2022-05-09 | Bon Homme | South Dakota | 46009 | 2293 | 39 |
2489035 | 2489035 | 2022-05-09 | Fall River | South Dakota | 46047 | 1806 | 39 |
2489183 | 2489183 | 2022-05-09 | Bailey | Texas | 48017 | 1511 | 39 |
2489278 | 2489278 | 2022-05-09 | Haskell | Texas | 48207 | 897 | 39 |
2489550 | 2489550 | 2022-05-09 | Lunenburg | Virginia | 51111 | 2453 | 39 |
2489798 | 2489798 | 2022-05-09 | Uinta | Wyoming | 56041 | 5635 | 39 |
2483830 | 2483830 | 2022-05-08 | Wheeler | Georgia | 13309 | 1414 | 39 |
2483930 | 2483930 | 2022-05-08 | Jo Daviess | Illinois | 17085 | 4072 | 39 |
2484697 | 2484697 | 2022-05-08 | Waseca | Minnesota | 27161 | 5572 | 39 |
2484799 | 2484799 | 2022-05-08 | Caldwell | Missouri | 29025 | 1697 | 39 |
2484850 | 2484850 | 2022-05-08 | Maries | Missouri | 29125 | 1605 | 39 |
2484891 | 2484891 | 2022-05-08 | Ste. Genevieve | Missouri | 29186 | 3671 | 39 |
2485248 | 2485248 | 2022-05-08 | Jones | North Carolina | 37103 | 2225 | 39 |
2485307 | 2485307 | 2022-05-08 | Dickey | North Dakota | 38021 | 1492 | 39 |
2485486 | 2485486 | 2022-05-08 | Love | Oklahoma | 40085 | 3103 | 39 |
2485495 | 2485495 | 2022-05-08 | Noble | Oklahoma | 40103 | 3044 | 39 |
2485759 | 2485759 | 2022-05-08 | Bon Homme | South Dakota | 46009 | 2293 | 39 |
2485778 | 2485778 | 2022-05-08 | Fall River | South Dakota | 46047 | 1806 | 39 |
2485926 | 2485926 | 2022-05-08 | Bailey | Texas | 48017 | 1511 | 39 |
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);