ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where deaths = 1787 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- Florida 15
- New Jersey 4
- Massachusetts 3
- Indiana 2
- Georgia 1
- Illinois 1
- Michigan 1
- Minnesota 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442189 | 2442189 | 2022-04-25 | Hampden | Massachusetts | 25013 | 135002 | 1787 |
2395994 | 2395994 | 2022-04-11 | DuPage | Illinois | 17043 | 211029 | 1787 |
2393915 | 2393915 | 2022-04-10 | Camden | New Jersey | 34007 | 125894 | 1787 |
2390659 | 2390659 | 2022-04-09 | Camden | New Jersey | 34007 | 125819 | 1787 |
2387403 | 2387403 | 2022-04-08 | Camden | New Jersey | 34007 | 125741 | 1787 |
2268956 | 2268956 | 2022-03-03 | Gwinnett | Georgia | 13135 | 205315 | 1787 |
2102954 | 2102954 | 2022-01-11 | Brevard | Florida | 12009 | 96835 | 1787 |
2099703 | 2099703 | 2022-01-10 | Brevard | Florida | 12009 | 96835 | 1787 |
2096452 | 2096452 | 2022-01-09 | Brevard | Florida | 12009 | 96835 | 1787 |
2093200 | 2093200 | 2022-01-08 | Brevard | Florida | 12009 | 96835 | 1787 |
2089948 | 2089948 | 2022-01-07 | Brevard | Florida | 12009 | 96835 | 1787 |
2086697 | 2086697 | 2022-01-06 | Brevard | Florida | 12009 | 88645 | 1787 |
2083445 | 2083445 | 2022-01-05 | Brevard | Florida | 12009 | 88645 | 1787 |
2034726 | 2034726 | 2021-12-21 | Marion | Florida | 12083 | 57745 | 1787 |
2031476 | 2031476 | 2021-12-20 | Marion | Florida | 12083 | 57745 | 1787 |
2028225 | 2028225 | 2021-12-19 | Marion | Florida | 12083 | 57745 | 1787 |
2024974 | 2024974 | 2021-12-18 | Marion | Florida | 12083 | 57745 | 1787 |
2021723 | 2021723 | 2021-12-17 | Marion | Florida | 12083 | 57745 | 1787 |
2018472 | 2018472 | 2021-12-16 | Marion | Florida | 12083 | 57594 | 1787 |
2015222 | 2015222 | 2021-12-15 | Marion | Florida | 12083 | 57594 | 1787 |
2011971 | 2011971 | 2021-12-14 | Marion | Florida | 12083 | 57594 | 1787 |
1467165 | 1467165 | 2021-06-29 | Hennepin | Minnesota | 27053 | 125181 | 1787 |
1363193 | 1363193 | 2021-05-28 | Norfolk | Massachusetts | 25021 | 54782 | 1787 |
1242578 | 1242578 | 2021-04-21 | Marion | Indiana | 18097 | 97061 | 1787 |
1239331 | 1239331 | 2021-04-20 | Marion | Indiana | 18097 | 96903 | 1787 |
963869 | 963869 | 2021-01-25 | Worcester | Massachusetts | 25027 | 57139 | 1787 |
928233 | 928233 | 2021-01-14 | Oakland | Michigan | 26125 | 66619 | 1787 |
929769 | 929769 | 2021-01-14 | Tarrant | Texas | 48439 | 185513 | 1787 |
925484 | 925484 | 2021-01-13 | Middlesex | New Jersey | 34023 | 55035 | 1787 |
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);