ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where deaths = 1928 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- Massachusetts 5
- New Jersey 4
- Ohio 3
- South Carolina 2
- Florida 1
- Georgia 1
- New York 1
- Pennsylvania 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2290455 | 2290455 | 2022-03-09 | Greenville | South Carolina | 45045 | 171511 | 1928 |
2287203 | 2287203 | 2022-03-08 | Greenville | South Carolina | 45045 | 171497 | 1928 |
2129092 | 2129092 | 2022-01-19 | Fulton | Georgia | 13121 | 191427 | 1928 |
1964082 | 1964082 | 2021-11-29 | Bristol | Massachusetts | 25005 | 87300 | 1928 |
1915335 | 1915335 | 2021-11-14 | Suffolk | Massachusetts | 25025 | 109609 | 1928 |
1912085 | 1912085 | 2021-11-13 | Suffolk | Massachusetts | 25025 | 109609 | 1928 |
1908835 | 1908835 | 2021-11-12 | Suffolk | Massachusetts | 25025 | 109609 | 1928 |
1809944 | 1809944 | 2021-10-12 | King | Washington | 53033 | 156949 | 1928 |
1412443 | 1412443 | 2021-06-12 | Passaic | New Jersey | 34031 | 73087 | 1928 |
1409198 | 1409198 | 2021-06-11 | Passaic | New Jersey | 34031 | 73063 | 1928 |
1405953 | 1405953 | 2021-06-10 | Passaic | New Jersey | 34031 | 73045 | 1928 |
1133488 | 1133488 | 2021-03-18 | Cuyahoga | Ohio | 39035 | 99155 | 1928 |
1130240 | 1130240 | 2021-03-17 | Cuyahoga | Ohio | 39035 | 98905 | 1928 |
1126993 | 1126993 | 2021-03-16 | Cuyahoga | Ohio | 39035 | 98710 | 1928 |
1123475 | 1123475 | 2021-03-15 | Ocean | New Jersey | 34029 | 63049 | 1928 |
917520 | 917520 | 2021-01-11 | Broward | Florida | 12011 | 151524 | 1928 |
728026 | 728026 | 2020-11-13 | Philadelphia | Pennsylvania | 42101 | 52723 | 1928 |
335862 | 335862 | 2020-07-15 | Middlesex | Massachusetts | 25017 | 24652 | 1928 |
189427 | 189427 | 2020-05-29 | Suffolk | New York | 36103 | 39445 | 1928 |
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);