ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where deaths = 2257 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 8
- New Jersey 3
- New York 3
- Ohio 3
- Pennsylvania 3
- Georgia 1
- Illinois 1
- Massachusetts 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2379544 | 2379544 | 2022-04-06 | Fulton | Georgia | 13121 | 217373 | 2257 |
2373281 | 2373281 | 2022-04-04 | Unknown | Illinois | 0 | 2257 | |
2192265 | 2192265 | 2022-02-07 | Passaic | New Jersey | 34031 | 140561 | 2257 |
1825378 | 1825378 | 2021-10-17 | Allegheny | Pennsylvania | 42003 | 127653 | 2257 |
1822129 | 1822129 | 2021-10-16 | Allegheny | Pennsylvania | 42003 | 127370 | 2257 |
1818880 | 1818880 | 2021-10-15 | Allegheny | Pennsylvania | 42003 | 126989 | 2257 |
1733945 | 1733945 | 2021-09-19 | Ocean | New Jersey | 34029 | 87212 | 2257 |
1542565 | 1542565 | 2021-07-22 | Cuyahoga | Ohio | 39035 | 116920 | 2257 |
1539317 | 1539317 | 2021-07-21 | Cuyahoga | Ohio | 39035 | 116850 | 2257 |
1536070 | 1536070 | 2021-07-20 | Cuyahoga | Ohio | 39035 | 116771 | 2257 |
1276198 | 1276198 | 2021-05-01 | Westchester | New York | 36119 | 127816 | 2257 |
1272951 | 1272951 | 2021-04-30 | Westchester | New York | 36119 | 127663 | 2257 |
1036722 | 1036722 | 2021-02-16 | El Paso | Texas | 48141 | 119997 | 2257 |
854079 | 854079 | 2020-12-22 | Bergen | New Jersey | 34003 | 43963 | 2257 |
782761 | 782761 | 2020-11-30 | Nassau | New York | 36059 | 60701 | 2257 |
671814 | 671814 | 2020-10-27 | Middlesex | Massachusetts | 25017 | 31594 | 2257 |
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);