ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where deaths = 2404 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 7
- New Jersey 7
- Massachusetts 4
- Missouri 3
- California 2
- Connecticut 1
- Maryland 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2246946 | 2246946 | 2022-02-24 | Baltimore | Maryland | 24005 | 130348 | 2404 |
2106074 | 2106074 | 2022-01-12 | Fresno | California | 6019 | 176980 | 2404 |
2102823 | 2102823 | 2022-01-11 | Fresno | California | 6019 | 175064 | 2404 |
1964652 | 1964652 | 2021-11-29 | Hudson | New Jersey | 34017 | 99902 | 2404 |
1961401 | 1961401 | 2021-11-28 | Hudson | New Jersey | 34017 | 99801 | 2404 |
1958150 | 1958150 | 2021-11-27 | Hudson | New Jersey | 34017 | 99724 | 2404 |
1954899 | 1954899 | 2021-11-26 | Hudson | New Jersey | 34017 | 99601 | 2404 |
1951648 | 1951648 | 2021-11-25 | Hudson | New Jersey | 34017 | 99506 | 2404 |
1740441 | 1740441 | 2021-09-21 | Middlesex | New Jersey | 34023 | 102078 | 2404 |
1694757 | 1694757 | 2021-09-07 | St. Louis | Missouri | 29189 | 118910 | 2404 |
1691508 | 1691508 | 2021-09-06 | St. Louis | Missouri | 29189 | 118773 | 2404 |
1688258 | 1688258 | 2021-09-05 | St. Louis | Missouri | 29189 | 118689 | 2404 |
1486520 | 1486520 | 2021-07-05 | Essex | Massachusetts | 25009 | 97993 | 2404 |
1483274 | 1483274 | 2021-07-04 | Essex | Massachusetts | 25009 | 97993 | 2404 |
1480028 | 1480028 | 2021-07-03 | Essex | Massachusetts | 25009 | 97993 | 2404 |
1476781 | 1476781 | 2021-07-02 | Essex | Massachusetts | 25009 | 97993 | 2404 |
1307071 | 1307071 | 2021-05-11 | Hartford | Connecticut | 9003 | 82983 | 2404 |
971845 | 971845 | 2021-01-27 | Hidalgo | Texas | 48215 | 61318 | 2404 |
896273 | 896273 | 2021-01-04 | Essex | New Jersey | 34013 | 52314 | 2404 |
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);