ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21,342 rows where deaths = 23 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,605
- Kansas 1,491
- Iowa 1,295
- Kentucky 1,140
- Georgia 986
- Minnesota 938
- Virginia 917
- Missouri 905
- Illinois 889
- Oklahoma 750
- Arkansas 624
- Idaho 613
- Nebraska 594
- North Dakota 585
- Mississippi 562
- Tennessee 550
- Colorado 510
- Wisconsin 473
- Michigan 429
- West Virginia 416
- Montana 402
- Louisiana 378
- Indiana 367
- Alabama 355
- North Carolina 336
- Ohio 334
- Washington 307
- Oregon 290
- Wyoming 257
- Pennsylvania 245
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499883 | 2499883 | 2022-05-13 | Yuma | Colorado | 8125 | 1886 | 23 |
2500504 | 2500504 | 2022-05-13 | Gove | Kansas | 20063 | 790 | 23 |
2500507 | 2500507 | 2022-05-13 | Gray | Kansas | 20069 | 1236 | 23 |
2500509 | 2500509 | 2022-05-13 | Greenwood | Kansas | 20073 | 1807 | 23 |
2500552 | 2500552 | 2022-05-13 | Rice | Kansas | 20159 | 2614 | 23 |
2500744 | 2500744 | 2022-05-13 | St. Helena | Louisiana | 22091 | 1920 | 23 |
2500948 | 2500948 | 2022-05-13 | Marshall | Minnesota | 27089 | 2122 | 23 |
2500988 | 2500988 | 2022-05-13 | Watonwan | Minnesota | 27165 | 2990 | 23 |
2501078 | 2501078 | 2022-05-13 | Atchison | Missouri | 29005 | 1387 | 23 |
2501214 | 2501214 | 2022-05-13 | Jefferson | Montana | 30043 | 2601 | 23 |
2501329 | 2501329 | 2022-05-13 | Sheridan | Nebraska | 31161 | 969 | 23 |
2501335 | 2501335 | 2022-05-13 | Thurston | Nebraska | 31173 | 1736 | 23 |
2501588 | 2501588 | 2022-05-13 | Benson | North Dakota | 38005 | 1980 | 23 |
2501601 | 2501601 | 2022-05-13 | Foster | North Dakota | 38031 | 992 | 23 |
2501624 | 2501624 | 2022-05-13 | Richland | North Dakota | 38077 | 4108 | 23 |
2502246 | 2502246 | 2022-05-13 | Cochran | Texas | 48079 | 891 | 23 |
2502449 | 2502449 | 2022-05-13 | Wheeler | Texas | 48483 | 1193 | 23 |
2496625 | 2496625 | 2022-05-12 | Yuma | Colorado | 8125 | 1886 | 23 |
2497246 | 2497246 | 2022-05-12 | Gove | Kansas | 20063 | 786 | 23 |
2497249 | 2497249 | 2022-05-12 | Gray | Kansas | 20069 | 1234 | 23 |
2497251 | 2497251 | 2022-05-12 | Greenwood | Kansas | 20073 | 1804 | 23 |
2497294 | 2497294 | 2022-05-12 | Rice | Kansas | 20159 | 2612 | 23 |
2497486 | 2497486 | 2022-05-12 | St. Helena | Louisiana | 22091 | 1919 | 23 |
2497690 | 2497690 | 2022-05-12 | Marshall | Minnesota | 27089 | 2120 | 23 |
2497730 | 2497730 | 2022-05-12 | Watonwan | Minnesota | 27165 | 2988 | 23 |
2497820 | 2497820 | 2022-05-12 | Atchison | Missouri | 29005 | 1385 | 23 |
2497956 | 2497956 | 2022-05-12 | Jefferson | Montana | 30043 | 2598 | 23 |
2498071 | 2498071 | 2022-05-12 | Sheridan | Nebraska | 31161 | 968 | 23 |
2498077 | 2498077 | 2022-05-12 | Thurston | Nebraska | 31173 | 1734 | 23 |
2498330 | 2498330 | 2022-05-12 | Benson | North Dakota | 38005 | 1976 | 23 |
2498343 | 2498343 | 2022-05-12 | Foster | North Dakota | 38031 | 991 | 23 |
2498366 | 2498366 | 2022-05-12 | Richland | North Dakota | 38077 | 4100 | 23 |
2498988 | 2498988 | 2022-05-12 | Cochran | Texas | 48079 | 891 | 23 |
2499191 | 2499191 | 2022-05-12 | Wheeler | Texas | 48483 | 1193 | 23 |
2493367 | 2493367 | 2022-05-11 | Yuma | Colorado | 8125 | 1883 | 23 |
2493988 | 2493988 | 2022-05-11 | Gove | Kansas | 20063 | 786 | 23 |
2493991 | 2493991 | 2022-05-11 | Gray | Kansas | 20069 | 1234 | 23 |
2493993 | 2493993 | 2022-05-11 | Greenwood | Kansas | 20073 | 1804 | 23 |
2494036 | 2494036 | 2022-05-11 | Rice | Kansas | 20159 | 2612 | 23 |
2494228 | 2494228 | 2022-05-11 | St. Helena | Louisiana | 22091 | 1918 | 23 |
2494432 | 2494432 | 2022-05-11 | Marshall | Minnesota | 27089 | 2115 | 23 |
2494472 | 2494472 | 2022-05-11 | Watonwan | Minnesota | 27165 | 2988 | 23 |
2494562 | 2494562 | 2022-05-11 | Atchison | Missouri | 29005 | 1385 | 23 |
2494698 | 2494698 | 2022-05-11 | Jefferson | Montana | 30043 | 2598 | 23 |
2494813 | 2494813 | 2022-05-11 | Sheridan | Nebraska | 31161 | 968 | 23 |
2494819 | 2494819 | 2022-05-11 | Thurston | Nebraska | 31173 | 1734 | 23 |
2495072 | 2495072 | 2022-05-11 | Benson | North Dakota | 38005 | 1976 | 23 |
2495085 | 2495085 | 2022-05-11 | Foster | North Dakota | 38031 | 991 | 23 |
2495108 | 2495108 | 2022-05-11 | Richland | North Dakota | 38077 | 4100 | 23 |
2495730 | 2495730 | 2022-05-11 | Cochran | Texas | 48079 | 891 | 23 |
2495933 | 2495933 | 2022-05-11 | Wheeler | Texas | 48483 | 1193 | 23 |
2490109 | 2490109 | 2022-05-10 | Yuma | Colorado | 8125 | 1883 | 23 |
2490730 | 2490730 | 2022-05-10 | Gove | Kansas | 20063 | 786 | 23 |
2490733 | 2490733 | 2022-05-10 | Gray | Kansas | 20069 | 1234 | 23 |
2490735 | 2490735 | 2022-05-10 | Greenwood | Kansas | 20073 | 1804 | 23 |
2490778 | 2490778 | 2022-05-10 | Rice | Kansas | 20159 | 2612 | 23 |
2490970 | 2490970 | 2022-05-10 | St. Helena | Louisiana | 22091 | 1917 | 23 |
2491174 | 2491174 | 2022-05-10 | Marshall | Minnesota | 27089 | 2115 | 23 |
2491214 | 2491214 | 2022-05-10 | Watonwan | Minnesota | 27165 | 2988 | 23 |
2491304 | 2491304 | 2022-05-10 | Atchison | Missouri | 29005 | 1385 | 23 |
2491440 | 2491440 | 2022-05-10 | Jefferson | Montana | 30043 | 2598 | 23 |
2491555 | 2491555 | 2022-05-10 | Sheridan | Nebraska | 31161 | 1010 | 23 |
2491561 | 2491561 | 2022-05-10 | Thurston | Nebraska | 31173 | 1798 | 23 |
2491783 | 2491783 | 2022-05-10 | Perquimans | North Carolina | 37143 | 2765 | 23 |
2491814 | 2491814 | 2022-05-10 | Benson | North Dakota | 38005 | 1976 | 23 |
2491827 | 2491827 | 2022-05-10 | Foster | North Dakota | 38031 | 991 | 23 |
2491850 | 2491850 | 2022-05-10 | Richland | North Dakota | 38077 | 4100 | 23 |
2492472 | 2492472 | 2022-05-10 | Cochran | Texas | 48079 | 891 | 23 |
2492528 | 2492528 | 2022-05-10 | Hall | Texas | 48191 | 1101 | 23 |
2492675 | 2492675 | 2022-05-10 | Wheeler | Texas | 48483 | 1193 | 23 |
2486852 | 2486852 | 2022-05-09 | Yuma | Colorado | 8125 | 1883 | 23 |
2487473 | 2487473 | 2022-05-09 | Gove | Kansas | 20063 | 786 | 23 |
2487476 | 2487476 | 2022-05-09 | Gray | Kansas | 20069 | 1234 | 23 |
2487478 | 2487478 | 2022-05-09 | Greenwood | Kansas | 20073 | 1804 | 23 |
2487521 | 2487521 | 2022-05-09 | Rice | Kansas | 20159 | 2612 | 23 |
2487713 | 2487713 | 2022-05-09 | St. Helena | Louisiana | 22091 | 1917 | 23 |
2487917 | 2487917 | 2022-05-09 | Marshall | Minnesota | 27089 | 2112 | 23 |
2487957 | 2487957 | 2022-05-09 | Watonwan | Minnesota | 27165 | 2986 | 23 |
2488046 | 2488046 | 2022-05-09 | Atchison | Missouri | 29005 | 1385 | 23 |
2488182 | 2488182 | 2022-05-09 | Jefferson | Montana | 30043 | 2598 | 23 |
2488297 | 2488297 | 2022-05-09 | Sheridan | Nebraska | 31161 | 1010 | 23 |
2488303 | 2488303 | 2022-05-09 | Thurston | Nebraska | 31173 | 1798 | 23 |
2488525 | 2488525 | 2022-05-09 | Perquimans | North Carolina | 37143 | 2765 | 23 |
2488556 | 2488556 | 2022-05-09 | Benson | North Dakota | 38005 | 1976 | 23 |
2488569 | 2488569 | 2022-05-09 | Foster | North Dakota | 38031 | 991 | 23 |
2488592 | 2488592 | 2022-05-09 | Richland | North Dakota | 38077 | 4100 | 23 |
2489214 | 2489214 | 2022-05-09 | Cochran | Texas | 48079 | 891 | 23 |
2489270 | 2489270 | 2022-05-09 | Hall | Texas | 48191 | 1101 | 23 |
2489417 | 2489417 | 2022-05-09 | Wheeler | Texas | 48483 | 1193 | 23 |
2483594 | 2483594 | 2022-05-08 | Yuma | Colorado | 8125 | 1883 | 23 |
2484215 | 2484215 | 2022-05-08 | Gove | Kansas | 20063 | 786 | 23 |
2484218 | 2484218 | 2022-05-08 | Gray | Kansas | 20069 | 1234 | 23 |
2484220 | 2484220 | 2022-05-08 | Greenwood | Kansas | 20073 | 1804 | 23 |
2484263 | 2484263 | 2022-05-08 | Rice | Kansas | 20159 | 2612 | 23 |
2484455 | 2484455 | 2022-05-08 | St. Helena | Louisiana | 22091 | 1915 | 23 |
2484659 | 2484659 | 2022-05-08 | Marshall | Minnesota | 27089 | 2110 | 23 |
2484699 | 2484699 | 2022-05-08 | Watonwan | Minnesota | 27165 | 2986 | 23 |
2484789 | 2484789 | 2022-05-08 | Atchison | Missouri | 29005 | 1385 | 23 |
2484925 | 2484925 | 2022-05-08 | Jefferson | Montana | 30043 | 2598 | 23 |
2485040 | 2485040 | 2022-05-08 | Sheridan | Nebraska | 31161 | 1010 | 23 |
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);