ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where deaths = 1929 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 7
- Massachusetts 5
- California 3
- Indiana 3
- New Jersey 3
- Ohio 3
- Minnesota 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2217721 | 2217721 | 2022-02-15 | Plymouth | Massachusetts | 25023 | 113374 | 1929 |
2065697 | 2065697 | 2021-12-30 | Franklin | Ohio | 39049 | 206135 | 1929 |
2062447 | 2062447 | 2021-12-29 | Franklin | Ohio | 39049 | 203519 | 1929 |
2059197 | 2059197 | 2021-12-28 | Franklin | Ohio | 39049 | 200689 | 1929 |
2035602 | 2035602 | 2021-12-21 | Norfolk | Massachusetts | 25021 | 76621 | 1929 |
1982581 | 1982581 | 2021-12-05 | Santa Clara | California | 6085 | 152857 | 1929 |
1979331 | 1979331 | 2021-12-04 | Santa Clara | California | 6085 | 152857 | 1929 |
1976081 | 1976081 | 2021-12-03 | Santa Clara | California | 6085 | 152857 | 1929 |
1905586 | 1905586 | 2021-11-11 | Suffolk | Massachusetts | 25025 | 109231 | 1929 |
1902337 | 1902337 | 2021-11-10 | Suffolk | Massachusetts | 25025 | 109231 | 1929 |
1850461 | 1850461 | 2021-10-25 | Hennepin | Minnesota | 27053 | 154134 | 1929 |
1664672 | 1664672 | 2021-08-29 | Marion | Indiana | 18097 | 115897 | 1929 |
1661424 | 1661424 | 2021-08-28 | Marion | Indiana | 18097 | 115897 | 1929 |
1658176 | 1658176 | 2021-08-27 | Marion | Indiana | 18097 | 115897 | 1929 |
1415689 | 1415689 | 2021-06-13 | Passaic | New Jersey | 34031 | 73107 | 1929 |
1272860 | 1272860 | 2021-04-30 | Union | New Jersey | 34039 | 70239 | 1929 |
987147 | 987147 | 2021-02-01 | Middlesex | New Jersey | 34023 | 64349 | 1929 |
970348 | 970348 | 2021-01-27 | Essex | Massachusetts | 25009 | 75810 | 1929 |
936109 | 936109 | 2021-01-16 | El Paso | Texas | 48141 | 106312 | 1929 |
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);