ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where deaths = 2369 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 8
- New Jersey 8
- Missouri 4
- Arizona 2
- Massachusetts 2
- Pennsylvania 2
- Alabama 1
- Florida 1
- New York 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470291 | 2470291 | 2022-05-04 | Jefferson | Alabama | 1073 | 185389 | 2369 |
2198196 | 2198196 | 2022-02-09 | Bristol | Massachusetts | 25005 | 146224 | 2369 |
2023264 | 2023264 | 2021-12-17 | Westchester | New York | 36119 | 155408 | 2369 |
1893153 | 1893153 | 2021-11-07 | Ocean | New Jersey | 34029 | 96799 | 2369 |
1883863 | 1883863 | 2021-11-04 | Allegheny | Pennsylvania | 42003 | 134146 | 2369 |
1772926 | 1772926 | 2021-10-01 | Hudson | New Jersey | 34017 | 95777 | 2369 |
1668766 | 1668766 | 2021-08-30 | St. Louis | Missouri | 29189 | 116813 | 2369 |
1665519 | 1665519 | 2021-08-29 | St. Louis | Missouri | 29189 | 116439 | 2369 |
1662271 | 1662271 | 2021-08-28 | St. Louis | Missouri | 29189 | 116424 | 2369 |
1659023 | 1659023 | 2021-08-27 | St. Louis | Missouri | 29189 | 116138 | 2369 |
1490337 | 1490337 | 2021-07-06 | Middlesex | New Jersey | 34023 | 92733 | 2369 |
1487090 | 1487090 | 2021-07-05 | Middlesex | New Jersey | 34023 | 92721 | 2369 |
1483844 | 1483844 | 2021-07-04 | Middlesex | New Jersey | 34023 | 92709 | 2369 |
1480598 | 1480598 | 2021-07-03 | Middlesex | New Jersey | 34023 | 92713 | 2369 |
1477351 | 1477351 | 2021-07-02 | Middlesex | New Jersey | 34023 | 92704 | 2369 |
1474105 | 1474105 | 2021-07-01 | Middlesex | New Jersey | 34023 | 92689 | 2369 |
1324225 | 1324225 | 2021-05-16 | Essex | Massachusetts | 25009 | 96904 | 2369 |
1212704 | 1212704 | 2021-04-12 | Pima | Arizona | 4019 | 113764 | 2369 |
1209455 | 1209455 | 2021-04-11 | Pima | Arizona | 4019 | 113659 | 2369 |
1066815 | 1066815 | 2021-02-26 | Broward | Florida | 12011 | 193560 | 2369 |
861089 | 861089 | 2020-12-24 | Philadelphia | Pennsylvania | 42101 | 89887 | 2369 |
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);