ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where deaths = 1879 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- Massachusetts 8
- Pennsylvania 6
- California 3
- Minnesota 3
- New Jersey 3
- Alabama 1
- Maryland 1
- Michigan 1
- New York 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2447651 | 2447651 | 2022-04-27 | Alameda | California | 6001 | 275311 | 1879 |
2444395 | 2444395 | 2022-04-26 | Alameda | California | 6001 | 275311 | 1879 |
2403121 | 2403121 | 2022-04-13 | Norfolk | Massachusetts | 25021 | 133092 | 1879 |
2399867 | 2399867 | 2022-04-12 | Norfolk | Massachusetts | 25021 | 132859 | 1879 |
2397677 | 2397677 | 2022-04-11 | Lancaster | Pennsylvania | 42071 | 120987 | 1879 |
2394422 | 2394422 | 2022-04-10 | Lancaster | Pennsylvania | 42071 | 120978 | 1879 |
2381373 | 2381373 | 2022-04-06 | Bucks | Pennsylvania | 42017 | 123129 | 1879 |
2131840 | 2131840 | 2022-01-19 | Milwaukee | Wisconsin | 55079 | 250909 | 1879 |
2114186 | 2114186 | 2022-01-14 | Monmouth | New Jersey | 34025 | 147301 | 1879 |
2011809 | 2011809 | 2021-12-14 | Kern | California | 6029 | 160477 | 1879 |
1938083 | 1938083 | 2021-11-21 | Norfolk | Massachusetts | 25021 | 67156 | 1879 |
1934833 | 1934833 | 2021-11-20 | Norfolk | Massachusetts | 25021 | 67156 | 1879 |
1931583 | 1931583 | 2021-11-19 | Norfolk | Massachusetts | 25021 | 67156 | 1879 |
1925049 | 1925049 | 2021-11-17 | Baltimore | Maryland | 24005 | 78621 | 1879 |
1919655 | 1919655 | 2021-11-15 | Montgomery | Pennsylvania | 42091 | 89124 | 1879 |
1806904 | 1806904 | 2021-10-12 | Jefferson | Alabama | 1073 | 113810 | 1879 |
1778979 | 1778979 | 2021-10-03 | Hennepin | Minnesota | 27053 | 145233 | 1879 |
1775729 | 1775729 | 2021-10-02 | Hennepin | Minnesota | 27053 | 145233 | 1879 |
1772479 | 1772479 | 2021-10-01 | Hennepin | Minnesota | 27053 | 145233 | 1879 |
1739878 | 1739878 | 2021-09-21 | Suffolk | Massachusetts | 25025 | 103002 | 1879 |
1736629 | 1736629 | 2021-09-20 | Suffolk | Massachusetts | 25025 | 102885 | 1879 |
1733999 | 1733999 | 2021-09-19 | Erie | New York | 36029 | 98475 | 1879 |
1298827 | 1298827 | 2021-05-08 | Passaic | New Jersey | 34031 | 72152 | 1879 |
1247338 | 1247338 | 2021-04-22 | Allegheny | Pennsylvania | 42003 | 95140 | 1879 |
1244091 | 1244091 | 2021-04-21 | Allegheny | Pennsylvania | 42003 | 94841 | 1879 |
1207913 | 1207913 | 2021-04-10 | Union | New Jersey | 34039 | 66826 | 1879 |
993130 | 993130 | 2021-02-03 | Macomb | Michigan | 26099 | 56670 | 1879 |
304080 | 304080 | 2020-07-05 | Middlesex | Massachusetts | 25017 | 24153 | 1879 |
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);