ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where deaths = 1823 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- Massachusetts 7
- California 5
- New Jersey 3
- Pennsylvania 3
- Indiana 2
- Maryland 2
- New York 2
- Connecticut 1
- Florida 1
- Georgia 1
- Puerto Rico 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2343497 | 2343497 | 2022-03-26 | Alameda | California | 6001 | 268474 | 1823 |
2340244 | 2340244 | 2022-03-25 | Alameda | California | 6001 | 268474 | 1823 |
2327501 | 2327501 | 2022-03-21 | Gwinnett | Georgia | 13135 | 206088 | 1823 |
2264283 | 2264283 | 2022-03-01 | Delaware | Pennsylvania | 42045 | 108839 | 1823 |
2152657 | 2152657 | 2022-01-26 | Plymouth | Massachusetts | 25023 | 109222 | 1823 |
1837314 | 1837314 | 2021-10-21 | Baltimore | Maryland | 24005 | 76081 | 1823 |
1834065 | 1834065 | 2021-10-20 | Baltimore | Maryland | 24005 | 75948 | 1823 |
1815675 | 1815675 | 2021-10-14 | Montgomery | Pennsylvania | 42091 | 83203 | 1823 |
1759360 | 1759360 | 2021-09-27 | Bristol | Massachusetts | 25005 | 76666 | 1823 |
1700893 | 1700893 | 2021-09-09 | Norfolk | Massachusetts | 25021 | 59769 | 1823 |
1697644 | 1697644 | 2021-09-08 | Norfolk | Massachusetts | 25021 | 59610 | 1823 |
1694396 | 1694396 | 2021-09-07 | Norfolk | Massachusetts | 25021 | 59529 | 1823 |
1613808 | 1613808 | 2021-08-13 | Erie | New York | 36029 | 91941 | 1823 |
1610559 | 1610559 | 2021-08-12 | Erie | New York | 36029 | 91826 | 1823 |
1359059 | 1359059 | 2021-05-27 | Hillsborough | Florida | 12057 | 142487 | 1823 |
1356215 | 1356215 | 2021-05-26 | Marion | Indiana | 18097 | 101802 | 1823 |
1352969 | 1352969 | 2021-05-25 | Marion | Indiana | 18097 | 101716 | 1823 |
1308000 | 1308000 | 2021-05-11 | Suffolk | Massachusetts | 25025 | 91792 | 1823 |
1304754 | 1304754 | 2021-05-10 | Suffolk | Massachusetts | 25025 | 91767 | 1823 |
1214405 | 1214405 | 2021-04-12 | Passaic | New Jersey | 34031 | 67536 | 1823 |
1192125 | 1192125 | 2021-04-05 | Allegheny | Pennsylvania | 42003 | 87623 | 1823 |
1126726 | 1126726 | 2021-03-16 | Union | New Jersey | 34039 | 60286 | 1823 |
1095927 | 1095927 | 2021-03-07 | Santa Clara | California | 6085 | 111814 | 1823 |
1092681 | 1092681 | 2021-03-06 | Santa Clara | California | 6085 | 111638 | 1823 |
1089435 | 1089435 | 2021-03-05 | Santa Clara | California | 6085 | 111460 | 1823 |
1058557 | 1058557 | 2021-02-23 | Ocean | New Jersey | 34029 | 57136 | 1823 |
981252 | 981252 | 2021-01-30 | Unknown | Puerto Rico | 4288 | 1823 | |
872067 | 872067 | 2020-12-28 | Hartford | Connecticut | 9003 | 45589 | 1823 |
845230 | 845230 | 2020-12-19 | Dallas | Texas | 48113 | 171583 | 1823 |
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);