ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where cases = 8400 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2418183 | 2418183 | 2022-04-18 | Dallas | Alabama | 1047 | 8400 | 243 |
2414927 | 2414927 | 2022-04-17 | Dallas | Alabama | 1047 | 8400 | 243 |
2411671 | 2411671 | 2022-04-16 | Dallas | Alabama | 1047 | 8400 | 243 |
2408415 | 2408415 | 2022-04-15 | Dallas | Alabama | 1047 | 8400 | 243 |
2355548 | 2355548 | 2022-03-29 | Codington | South Dakota | 46029 | 8400 | 99 |
2352295 | 2352295 | 2022-03-28 | Codington | South Dakota | 46029 | 8400 | 99 |
2349043 | 2349043 | 2022-03-27 | Codington | South Dakota | 46029 | 8400 | 99 |
2345790 | 2345790 | 2022-03-26 | Codington | South Dakota | 46029 | 8400 | 99 |
2342537 | 2342537 | 2022-03-25 | Codington | South Dakota | 46029 | 8400 | 99 |
2339284 | 2339284 | 2022-03-24 | Codington | South Dakota | 46029 | 8400 | 99 |
2336030 | 2336030 | 2022-03-23 | Codington | South Dakota | 46029 | 8400 | 99 |
2280383 | 2280383 | 2022-03-06 | Ottawa | Ohio | 39123 | 8400 | 133 |
2240625 | 2240625 | 2022-02-22 | Polk | Minnesota | 27119 | 8400 | 97 |
2241104 | 2241104 | 2022-02-22 | Greene | New York | 36039 | 8400 | 119 |
2107868 | 2107868 | 2022-01-12 | Stokes | North Carolina | 37169 | 8400 | 123 |
2059936 | 2059936 | 2021-12-28 | Rusk | Texas | 48401 | 8400 | 191 |
2035711 | 2035711 | 2021-12-21 | Douglas | Minnesota | 27041 | 8400 | 102 |
2036918 | 2036918 | 2021-12-21 | Franklin | Tennessee | 47051 | 8400 | 110 |
1963378 | 1963378 | 2021-11-29 | Tift | Georgia | 13277 | 8400 | 185 |
1879439 | 1879439 | 2021-11-03 | Nelson | Kentucky | 21179 | 8400 | 90 |
1858761 | 1858761 | 2021-10-27 | Barron | Wisconsin | 55005 | 8400 | 94 |
1608775 | 1608775 | 2021-08-12 | Fairbanks North Star Borough | Alaska | 2090 | 8400 | 45 |
1591850 | 1591850 | 2021-08-06 | Bowie | Texas | 48037 | 8400 | 229 |
1556244 | 1556244 | 2021-07-26 | Liberty | Texas | 48291 | 8400 | 203 |
1422585 | 1422585 | 2021-06-15 | Pottawatomie | Oklahoma | 40125 | 8400 | 131 |
1419339 | 1419339 | 2021-06-14 | Pottawatomie | Oklahoma | 40125 | 8400 | 131 |
1416094 | 1416094 | 2021-06-13 | Pottawatomie | Oklahoma | 40125 | 8400 | 131 |
1412848 | 1412848 | 2021-06-12 | Pottawatomie | Oklahoma | 40125 | 8400 | 131 |
1409603 | 1409603 | 2021-06-11 | Pottawatomie | Oklahoma | 40125 | 8400 | 131 |
1406358 | 1406358 | 2021-06-10 | Pottawatomie | Oklahoma | 40125 | 8400 | 131 |
1403112 | 1403112 | 2021-06-09 | Pottawatomie | Oklahoma | 40125 | 8400 | 131 |
1381490 | 1381490 | 2021-06-03 | Talladega | Alabama | 1121 | 8400 | 181 |
1330220 | 1330220 | 2021-05-18 | Hancock | Indiana | 18059 | 8400 | 146 |
1270606 | 1270606 | 2021-04-29 | Orange | Texas | 48361 | 8400 | 146 |
1188398 | 1188398 | 2021-04-04 | Merrimack | New Hampshire | 33013 | 8400 | 110 |
1143063 | 1143063 | 2021-03-21 | Brunswick | North Carolina | 37019 | 8400 | 142 |
1139816 | 1139816 | 2021-03-20 | Brunswick | North Carolina | 37019 | 8400 | 142 |
1102133 | 1102133 | 2021-03-08 | Manitowoc | Wisconsin | 55071 | 8400 | 82 |
1098887 | 1098887 | 2021-03-07 | Manitowoc | Wisconsin | 55071 | 8400 | 82 |
1095639 | 1095639 | 2021-03-06 | Manitowoc | Wisconsin | 55071 | 8400 | 82 |
1064760 | 1064760 | 2021-02-25 | Christian | Missouri | 29043 | 8400 | 77 |
1061516 | 1061516 | 2021-02-24 | Christian | Missouri | 29043 | 8400 | 77 |
1058270 | 1058270 | 2021-02-23 | Christian | Missouri | 29043 | 8400 | 77 |
1055024 | 1055024 | 2021-02-22 | Christian | Missouri | 29043 | 8400 | 75 |
1027489 | 1027489 | 2021-02-13 | Ozaukee | Wisconsin | 55089 | 8400 | 79 |
979389 | 979389 | 2021-01-30 | Walton | Georgia | 13297 | 8400 | 158 |
908645 | 908645 | 2021-01-08 | Cumberland | Maine | 23005 | 8400 | 110 |
843337 | 843337 | 2020-12-19 | Vigo | Indiana | 18167 | 8400 | 137 |
727460 | 727460 | 2020-11-13 | Sarpy | Nebraska | 31153 | 8400 | 46 |
675981 | 675981 | 2020-10-28 | Cleveland | Oklahoma | 40027 | 8400 | 99 |
616767 | 616767 | 2020-10-10 | Dakota | Minnesota | 27037 | 8400 | 130 |
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);