ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 17336 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 8
- Mississippi 7
- Wisconsin 3
- New Jersey 2
- Alabama 1
- Louisiana 1
- Minnesota 1
- New York 1
- Ohio 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2370787 | 2370787 | 2022-04-03 | Lamar | Mississippi | 28073 | 17336 | 160 |
2367534 | 2367534 | 2022-04-02 | Lamar | Mississippi | 28073 | 17336 | 160 |
2364281 | 2364281 | 2022-04-01 | Lamar | Mississippi | 28073 | 17336 | 160 |
2361027 | 2361027 | 2022-03-31 | Lamar | Mississippi | 28073 | 17336 | 160 |
2357773 | 2357773 | 2022-03-30 | Lamar | Mississippi | 28073 | 17336 | 160 |
2354520 | 2354520 | 2022-03-29 | Lamar | Mississippi | 28073 | 17336 | 160 |
2351268 | 2351268 | 2022-03-28 | Lamar | Mississippi | 28073 | 17336 | 160 |
2190410 | 2190410 | 2022-02-06 | Portage | Wisconsin | 55097 | 17336 | 147 |
2187157 | 2187157 | 2022-02-05 | Portage | Wisconsin | 55097 | 17336 | 147 |
2183904 | 2183904 | 2022-02-04 | Portage | Wisconsin | 55097 | 17336 | 147 |
1964738 | 1964738 | 2021-11-29 | Rensselaer | New York | 36083 | 17336 | 192 |
1579498 | 1579498 | 2021-08-03 | Lee | Alabama | 1081 | 17336 | 181 |
1565014 | 1565014 | 2021-07-29 | Cumberland | New Jersey | 34011 | 17336 | 442 |
1327634 | 1327634 | 2021-05-17 | Scott | Minnesota | 27139 | 17336 | 126 |
1006894 | 1006894 | 2021-02-07 | Clermont | Ohio | 39025 | 17336 | 125 |
918364 | 918364 | 2021-01-11 | St. Tammany | Louisiana | 22103 | 17336 | 373 |
701572 | 701572 | 2020-11-05 | Ocean | New Jersey | 34029 | 17336 | 1074 |
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);