ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where deaths = 1978 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- Rhode Island 10
- New Jersey 8
- Texas 5
- Alabama 3
- Massachusetts 3
- California 2
- Maryland 2
- Michigan 2
- Connecticut 1
- New York 1
- Pennsylvania 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2377081 | 2377081 | 2022-04-05 | Suffolk | Massachusetts | 25025 | 211229 | 1978 |
2263235 | 2263235 | 2022-03-01 | Plymouth | Massachusetts | 25023 | 114195 | 1978 |
2240457 | 2240457 | 2022-02-22 | Montgomery | Maryland | 24031 | 164659 | 1978 |
2159144 | 2159144 | 2022-01-28 | Prince George's | Maryland | 24033 | 161338 | 1978 |
2156475 | 2156475 | 2022-01-27 | Monmouth | New Jersey | 34025 | 156224 | 1978 |
1894632 | 1894632 | 2021-11-08 | Jefferson | Alabama | 1073 | 115760 | 1978 |
1891382 | 1891382 | 2021-11-07 | Jefferson | Alabama | 1073 | 115726 | 1978 |
1888132 | 1888132 | 2021-11-06 | Jefferson | Alabama | 1073 | 115693 | 1978 |
1884252 | 1884252 | 2021-11-04 | Cameron | Texas | 48061 | 66085 | 1978 |
1784320 | 1784320 | 2021-10-05 | Fresno | California | 6019 | 140950 | 1978 |
1781071 | 1781071 | 2021-10-04 | Fresno | California | 6019 | 140650 | 1978 |
1730696 | 1730696 | 2021-09-18 | Passaic | New Jersey | 34031 | 78636 | 1978 |
1477359 | 1477359 | 2021-07-02 | Union | New Jersey | 34039 | 71810 | 1978 |
1474113 | 1474113 | 2021-07-01 | Union | New Jersey | 34039 | 71783 | 1978 |
1470867 | 1470867 | 2021-06-30 | Union | New Jersey | 34039 | 71768 | 1978 |
1467622 | 1467622 | 2021-06-29 | Union | New Jersey | 34039 | 71760 | 1978 |
1464377 | 1464377 | 2021-06-28 | Union | New Jersey | 34039 | 71741 | 1978 |
1380595 | 1380595 | 2021-06-02 | Providence | Rhode Island | 44007 | 98724 | 1978 |
1377350 | 1377350 | 2021-06-01 | Providence | Rhode Island | 44007 | 98724 | 1978 |
1374104 | 1374104 | 2021-05-31 | Providence | Rhode Island | 44007 | 98724 | 1978 |
1370859 | 1370859 | 2021-05-30 | Providence | Rhode Island | 44007 | 98724 | 1978 |
1367613 | 1367613 | 2021-05-29 | Providence | Rhode Island | 44007 | 98724 | 1978 |
1364367 | 1364367 | 2021-05-28 | Providence | Rhode Island | 44007 | 98724 | 1978 |
1361121 | 1361121 | 2021-05-27 | Providence | Rhode Island | 44007 | 98724 | 1978 |
1357875 | 1357875 | 2021-05-26 | Providence | Rhode Island | 44007 | 98724 | 1978 |
1354629 | 1354629 | 2021-05-25 | Providence | Rhode Island | 44007 | 98724 | 1978 |
1351383 | 1351383 | 2021-05-24 | Providence | Rhode Island | 44007 | 98724 | 1978 |
1090498 | 1090498 | 2021-03-05 | Macomb | Michigan | 26099 | 60378 | 1978 |
1087253 | 1087253 | 2021-03-04 | Macomb | Michigan | 26099 | 60169 | 1978 |
1003377 | 1003377 | 2021-02-06 | Middlesex | New Jersey | 34023 | 66087 | 1978 |
923992 | 923992 | 2021-01-13 | Hartford | Connecticut | 9003 | 55710 | 1978 |
753991 | 753991 | 2020-11-21 | Philadelphia | Pennsylvania | 42101 | 59081 | 1978 |
712226 | 712226 | 2020-11-08 | Hidalgo | Texas | 48215 | 36686 | 1978 |
708982 | 708982 | 2020-11-07 | Hidalgo | Texas | 48215 | 36686 | 1978 |
705738 | 705738 | 2020-11-06 | Hidalgo | Texas | 48215 | 36627 | 1978 |
456305 | 456305 | 2020-08-21 | Harris | Texas | 48201 | 96658 | 1978 |
387168 | 387168 | 2020-07-31 | Middlesex | Massachusetts | 25017 | 25706 | 1978 |
217122 | 217122 | 2020-06-07 | Suffolk | New York | 36103 | 40329 | 1978 |
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);