ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 11862 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 |
---|---|---|---|---|---|---|---|
2453648 | 2453648 | 2022-04-28 | Washington | Vermont | 50023 | 11862 | 49 |
2399285 | 2399285 | 2022-04-12 | Marion | Illinois | 17121 | 11862 | 216 |
2337719 | 2337719 | 2022-03-24 | Crawford | Kansas | 20037 | 11862 | 130 |
2334465 | 2334465 | 2022-03-23 | Crawford | Kansas | 20037 | 11862 | 130 |
2311392 | 2311392 | 2022-03-16 | Clinton | Illinois | 17027 | 11862 | 122 |
2105166 | 2105166 | 2022-01-11 | Carter | Tennessee | 47019 | 11862 | 268 |
2101915 | 2101915 | 2022-01-10 | Carter | Tennessee | 47019 | 11862 | 268 |
2098664 | 2098664 | 2022-01-09 | Carter | Tennessee | 47019 | 11862 | 268 |
2095412 | 2095412 | 2022-01-08 | Carter | Tennessee | 47019 | 11862 | 268 |
2092160 | 2092160 | 2022-01-07 | Carter | Tennessee | 47019 | 11862 | 268 |
2088908 | 2088908 | 2022-01-06 | Carter | Tennessee | 47019 | 11862 | 268 |
2085657 | 2085657 | 2022-01-05 | Carter | Tennessee | 47019 | 11862 | 268 |
2082405 | 2082405 | 2022-01-04 | Carter | Tennessee | 47019 | 11862 | 268 |
1989389 | 1989389 | 2021-12-07 | Walker | Georgia | 13295 | 11862 | 163 |
1990986 | 1990986 | 2021-12-07 | Ross | Ohio | 39141 | 11862 | 226 |
1833012 | 1833012 | 2021-10-20 | Lonoke | Arkansas | 5085 | 11862 | 174 |
1826529 | 1826529 | 2021-10-18 | Pope | Arkansas | 5115 | 11862 | 153 |
1717513 | 1717513 | 2021-09-14 | Cascade | Montana | 30013 | 11862 | 199 |
1710543 | 1710543 | 2021-09-12 | Iberia | Louisiana | 22045 | 11862 | 205 |
1707296 | 1707296 | 2021-09-11 | Iberia | Louisiana | 22045 | 11862 | 205 |
1704048 | 1704048 | 2021-09-10 | Iberia | Louisiana | 22045 | 11862 | 205 |
1584252 | 1584252 | 2021-08-04 | Jasper | Missouri | 29097 | 11862 | 146 |
1442778 | 1442778 | 2021-06-21 | Alexandria city | Virginia | 51510 | 11862 | 138 |
1436286 | 1436286 | 2021-06-19 | Alexandria city | Virginia | 51510 | 11862 | 138 |
1296944 | 1296944 | 2021-05-07 | Eau Claire | Wisconsin | 55035 | 11862 | 119 |
1226791 | 1226791 | 2021-04-16 | York | Maine | 23031 | 11862 | 128 |
1102943 | 1102943 | 2021-03-09 | Madison | Indiana | 18095 | 11862 | 344 |
1019028 | 1019028 | 2021-02-11 | Washington | Maryland | 24043 | 11862 | 240 |
875106 | 875106 | 2020-12-29 | Mohave | Arizona | 4015 | 11862 | 331 |
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);