ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 11319 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 |
---|---|---|---|---|---|---|---|
2308243 | 2308243 | 2022-03-15 | DeKalb | Indiana | 18033 | 11319 | 148 |
2304992 | 2304992 | 2022-03-14 | DeKalb | Indiana | 18033 | 11319 | 148 |
2125403 | 2125403 | 2022-01-18 | Coffee | Alabama | 1031 | 11319 | 201 |
2125545 | 2125545 | 2022-01-18 | Mississippi | Arkansas | 5093 | 11319 | 165 |
1833371 | 1833371 | 2021-10-20 | Rockdale | Georgia | 13247 | 11319 | 232 |
1669051 | 1669051 | 2021-08-30 | Putnam | New York | 36079 | 11319 | 94 |
1388417 | 1388417 | 2021-06-05 | Newton | Georgia | 13217 | 11319 | 255 |
1277625 | 1277625 | 2021-05-02 | Matanuska-Susitna Borough | Alaska | 2170 | 11319 | 45 |
1274378 | 1274378 | 2021-05-01 | Matanuska-Susitna Borough | Alaska | 2170 | 11319 | 45 |
1271131 | 1271131 | 2021-04-30 | Matanuska-Susitna Borough | Alaska | 2170 | 11319 | 45 |
1167359 | 1167359 | 2021-03-29 | Shasta | California | 6089 | 11319 | 200 |
1164111 | 1164111 | 2021-03-28 | Shasta | California | 6089 | 11319 | 200 |
1160863 | 1160863 | 2021-03-27 | Shasta | California | 6089 | 11319 | 200 |
1157615 | 1157615 | 2021-03-26 | Shasta | California | 6089 | 11319 | 200 |
1154368 | 1154368 | 2021-03-25 | Shasta | California | 6089 | 11319 | 200 |
1082638 | 1082638 | 2021-03-02 | Eau Claire | Wisconsin | 55035 | 11319 | 114 |
963193 | 963193 | 2021-01-25 | Bonneville | Idaho | 16019 | 11319 | 133 |
881601 | 881601 | 2020-12-31 | Yavapai | Arizona | 4025 | 11319 | 218 |
726094 | 726094 | 2020-11-13 | Seminole | Florida | 12117 | 11319 | 255 |
612100 | 612100 | 2020-10-08 | Dane | Wisconsin | 55025 | 11319 | 43 |
402130 | 402130 | 2020-08-05 | Yuma | Arizona | 4027 | 11319 | 276 |
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);