ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where cases = 9594 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Missouri 8
- Kansas 7
- Georgia 6
- Louisiana 5
- California 4
- Kentucky 4
- New York 3
- South Carolina 3
- Colorado 2
- Indiana 2
- Texas 2
- Virginia 2
- Wyoming 2
- Alabama 1
- Illinois 1
- Maryland 1
- Minnesota 1
- Mississippi 1
- Ohio 1
- Pennsylvania 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2441607 | 2441607 | 2022-04-25 | Logan | Illinois | 17107 | 9594 | 100 |
2428865 | 2428865 | 2022-04-21 | Harvey | Kansas | 20079 | 9594 | 123 |
2425609 | 2425609 | 2022-04-20 | Harvey | Kansas | 20079 | 9594 | 123 |
2427800 | 2427800 | 2022-04-20 | Logan | West Virginia | 54045 | 9594 | 182 |
2422353 | 2422353 | 2022-04-19 | Harvey | Kansas | 20079 | 9594 | 123 |
2419097 | 2419097 | 2022-04-18 | Harvey | Kansas | 20079 | 9594 | 123 |
2415841 | 2415841 | 2022-04-17 | Harvey | Kansas | 20079 | 9594 | 123 |
2412585 | 2412585 | 2022-04-16 | Harvey | Kansas | 20079 | 9594 | 123 |
2409329 | 2409329 | 2022-04-15 | Harvey | Kansas | 20079 | 9594 | 123 |
2245550 | 2245550 | 2022-02-23 | York | Virginia | 51199 | 9594 | 101 |
2192315 | 2192315 | 2022-02-07 | Columbia | New York | 36021 | 9594 | 136 |
2178920 | 2178920 | 2022-02-03 | Pontotoc | Mississippi | 28115 | 9594 | 123 |
2133226 | 2133226 | 2022-01-20 | Beltrami | Minnesota | 27007 | 9594 | 112 |
2107749 | 2107749 | 2022-01-12 | Livingston | New York | 36051 | 9594 | 96 |
2081038 | 2081038 | 2022-01-04 | St. Mary | Louisiana | 22101 | 9594 | 232 |
2018092 | 2018092 | 2021-12-15 | Fremont | Wyoming | 56013 | 9594 | 158 |
1869014 | 1869014 | 2021-10-31 | Catoosa | Georgia | 13047 | 9594 | 108 |
1865765 | 1865765 | 2021-10-30 | Catoosa | Georgia | 13047 | 9594 | 108 |
1862516 | 1862516 | 2021-10-29 | Catoosa | Georgia | 13047 | 9594 | 108 |
1848295 | 1848295 | 2021-10-24 | Georgetown | South Carolina | 45043 | 9594 | 173 |
1845045 | 1845045 | 2021-10-23 | Georgetown | South Carolina | 45043 | 9594 | 173 |
1841795 | 1841795 | 2021-10-22 | Georgetown | South Carolina | 45043 | 9594 | 173 |
1830814 | 1830814 | 2021-10-19 | Allegany | Maryland | 24001 | 9594 | 244 |
1718173 | 1718173 | 2021-09-14 | Clearfield | Pennsylvania | 42033 | 9594 | 168 |
1664432 | 1664432 | 2021-08-29 | Rockdale | Georgia | 13247 | 9594 | 189 |
1661184 | 1661184 | 2021-08-28 | Rockdale | Georgia | 13247 | 9594 | 189 |
1662524 | 1662524 | 2021-08-28 | Chautauqua | New York | 36013 | 9594 | 151 |
1657936 | 1657936 | 2021-08-27 | Rockdale | Georgia | 13247 | 9594 | 189 |
1614095 | 1614095 | 2021-08-13 | Wayne | Ohio | 39169 | 9594 | 229 |
1579482 | 1579482 | 2021-08-03 | DeKalb | Alabama | 1049 | 9594 | 192 |
1503043 | 1503043 | 2021-07-10 | Cole | Missouri | 29051 | 9594 | 130 |
1504358 | 1504358 | 2021-07-10 | Starr | Texas | 48427 | 9594 | 305 |
1486362 | 1486362 | 2021-07-05 | Madison | Kentucky | 21151 | 9594 | 112 |
1483116 | 1483116 | 2021-07-04 | Madison | Kentucky | 21151 | 9594 | 112 |
1479869 | 1479869 | 2021-07-03 | Madison | Kentucky | 21151 | 9594 | 112 |
1476623 | 1476623 | 2021-07-02 | Madison | Kentucky | 21151 | 9594 | 112 |
1467324 | 1467324 | 2021-06-29 | Cape Girardeau | Missouri | 29031 | 9594 | 139 |
1464079 | 1464079 | 2021-06-28 | Cape Girardeau | Missouri | 29031 | 9594 | 139 |
1460834 | 1460834 | 2021-06-27 | Cape Girardeau | Missouri | 29031 | 9594 | 139 |
1457589 | 1457589 | 2021-06-26 | Cape Girardeau | Missouri | 29031 | 9594 | 139 |
1454344 | 1454344 | 2021-06-25 | Cape Girardeau | Missouri | 29031 | 9594 | 139 |
1451099 | 1451099 | 2021-06-24 | Cape Girardeau | Missouri | 29031 | 9594 | 139 |
1447853 | 1447853 | 2021-06-23 | Cape Girardeau | Missouri | 29031 | 9594 | 139 |
1378172 | 1378172 | 2021-06-01 | Laramie | Wyoming | 56021 | 9594 | 114 |
1313187 | 1313187 | 2021-05-12 | Jefferson | Wisconsin | 55055 | 9594 | 132 |
1301418 | 1301418 | 2021-05-09 | Lafourche | Louisiana | 22057 | 9594 | 204 |
1298171 | 1298171 | 2021-05-08 | Lafourche | Louisiana | 22057 | 9594 | 204 |
1294925 | 1294925 | 2021-05-07 | Lafourche | Louisiana | 22057 | 9594 | 204 |
1213335 | 1213335 | 2021-04-12 | Howard | Indiana | 18067 | 9594 | 215 |
1183098 | 1183098 | 2021-04-02 | Hampton city | Virginia | 51650 | 9594 | 157 |
1028286 | 1028286 | 2021-02-14 | LaPorte | Indiana | 18091 | 9594 | 196 |
975073 | 975073 | 2021-01-28 | Grayson | Texas | 48181 | 9594 | 254 |
940139 | 940139 | 2021-01-18 | Shasta | California | 6089 | 9594 | 117 |
936894 | 936894 | 2021-01-17 | Shasta | California | 6089 | 9594 | 117 |
933649 | 933649 | 2021-01-16 | Shasta | California | 6089 | 9594 | 117 |
930404 | 930404 | 2021-01-15 | Shasta | California | 6089 | 9594 | 117 |
905339 | 905339 | 2021-01-07 | Bossier | Louisiana | 22015 | 9594 | 204 |
901250 | 901250 | 2021-01-06 | Mesa | Colorado | 8077 | 9594 | 142 |
898005 | 898005 | 2021-01-05 | Mesa | Colorado | 8077 | 9594 | 142 |
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);