ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where deaths = 1931 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- New Jersey 8
- Florida 7
- California 3
- Massachusetts 2
- Maryland 1
- New York 1
- Pennsylvania 1
- Texas 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2194068 | 2194068 | 2022-02-08 | Lee | Florida | 12071 | 180609 | 1931 |
2190814 | 2190814 | 2022-02-07 | Lee | Florida | 12071 | 180609 | 1931 |
2187561 | 2187561 | 2022-02-06 | Lee | Florida | 12071 | 180609 | 1931 |
2184308 | 2184308 | 2022-02-05 | Lee | Florida | 12071 | 180609 | 1931 |
2181056 | 2181056 | 2022-02-04 | Lee | Florida | 12071 | 180609 | 1931 |
2181918 | 2181918 | 2022-02-04 | Montgomery | Maryland | 24031 | 158500 | 1931 |
2177805 | 2177805 | 2022-02-03 | Lee | Florida | 12071 | 175773 | 1931 |
2174552 | 2174552 | 2022-02-02 | Lee | Florida | 12071 | 175773 | 1931 |
2172177 | 2172177 | 2022-02-01 | Hampden | Massachusetts | 25013 | 126701 | 1931 |
2096326 | 2096326 | 2022-01-09 | Kern | California | 6029 | 169213 | 1931 |
2093074 | 2093074 | 2022-01-08 | Kern | California | 6029 | 169213 | 1931 |
2089822 | 2089822 | 2022-01-07 | Kern | California | 6029 | 169213 | 1931 |
2038852 | 2038852 | 2021-12-22 | Norfolk | Massachusetts | 25021 | 77328 | 1931 |
1815226 | 1815226 | 2021-10-14 | Erie | New York | 36029 | 104539 | 1931 |
1813193 | 1813193 | 2021-10-13 | King | Washington | 53033 | 157650 | 1931 |
1441657 | 1441657 | 2021-06-21 | Passaic | New Jersey | 34031 | 73273 | 1931 |
1438411 | 1438411 | 2021-06-20 | Passaic | New Jersey | 34031 | 73267 | 1931 |
1435164 | 1435164 | 2021-06-19 | Passaic | New Jersey | 34031 | 73256 | 1931 |
1431917 | 1431917 | 2021-06-18 | Passaic | New Jersey | 34031 | 73245 | 1931 |
1428672 | 1428672 | 2021-06-17 | Passaic | New Jersey | 34031 | 73211 | 1931 |
1425427 | 1425427 | 2021-06-16 | Passaic | New Jersey | 34031 | 73187 | 1931 |
1312272 | 1312272 | 2021-05-12 | Allegheny | Pennsylvania | 42003 | 99567 | 1931 |
1276107 | 1276107 | 2021-05-01 | Union | New Jersey | 34039 | 70328 | 1931 |
1019602 | 1019602 | 2021-02-11 | Hudson | New Jersey | 34017 | 64440 | 1931 |
871190 | 871190 | 2020-12-27 | Dallas | Texas | 48113 | 186880 | 1931 |
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);