ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 1441 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Wisconsin 6
- California 4
- Massachusetts 4
- New Jersey 3
- Pennsylvania 3
- South Carolina 3
- Tennessee 3
- Virginia 3
- Washington 3
- Arizona 2
- Maryland 2
- Florida 1
- Georgia 1
- Illinois 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2417875 | 2417875 | 2022-04-17 | Fairfax | Virginia | 51059 | 178336 | 1441 |
2414619 | 2414619 | 2022-04-16 | Fairfax | Virginia | 51059 | 178336 | 1441 |
2411363 | 2411363 | 2022-04-15 | Fairfax | Virginia | 51059 | 178336 | 1441 |
2360226 | 2360226 | 2022-03-31 | Lake | Illinois | 17097 | 149161 | 1441 |
2267916 | 2267916 | 2022-03-02 | Collin | Texas | 48085 | 203709 | 1441 |
2167796 | 2167796 | 2022-01-31 | Pinal | Arizona | 4021 | 121256 | 1441 |
2164541 | 2164541 | 2022-01-30 | Pinal | Arizona | 4021 | 120459 | 1441 |
2156476 | 2156476 | 2022-01-27 | Morris | New Jersey | 34027 | 112553 | 1441 |
2084325 | 2084325 | 2022-01-05 | Baltimore city | Maryland | 24510 | 88200 | 1441 |
2012031 | 2012031 | 2021-12-14 | Cobb | Georgia | 13067 | 113895 | 1441 |
1992339 | 1992339 | 2021-12-08 | Stanislaus | California | 6099 | 92420 | 1441 |
1881784 | 1881784 | 2021-11-04 | Alameda | California | 6001 | 122349 | 1441 |
1878535 | 1878535 | 2021-11-03 | Alameda | California | 6001 | 122172 | 1441 |
1871040 | 1871040 | 2021-10-31 | Greenville | South Carolina | 45045 | 105019 | 1441 |
1867791 | 1867791 | 2021-10-30 | Greenville | South Carolina | 45045 | 105019 | 1441 |
1864542 | 1864542 | 2021-10-29 | Greenville | South Carolina | 45045 | 105019 | 1441 |
1692196 | 1692196 | 2021-09-06 | Delaware | Pennsylvania | 42045 | 56505 | 1441 |
1688947 | 1688947 | 2021-09-05 | Delaware | Pennsylvania | 42045 | 56431 | 1441 |
1685697 | 1685697 | 2021-09-04 | Delaware | Pennsylvania | 42045 | 56327 | 1441 |
1628387 | 1628387 | 2021-08-18 | Kern | California | 6029 | 118794 | 1441 |
1624885 | 1624885 | 2021-08-16 | Milwaukee | Wisconsin | 55079 | 126092 | 1441 |
1621638 | 1621638 | 2021-08-15 | Milwaukee | Wisconsin | 55079 | 125408 | 1441 |
1618390 | 1618390 | 2021-08-14 | Milwaukee | Wisconsin | 55079 | 125408 | 1441 |
1615142 | 1615142 | 2021-08-13 | Milwaukee | Wisconsin | 55079 | 125408 | 1441 |
1611893 | 1611893 | 2021-08-12 | Milwaukee | Wisconsin | 55079 | 125035 | 1441 |
1563163 | 1563163 | 2021-07-28 | Milwaukee | Wisconsin | 55079 | 120216 | 1441 |
1415122 | 1415122 | 2021-06-13 | Plymouth | Massachusetts | 25023 | 49236 | 1441 |
1411876 | 1411876 | 2021-06-12 | Plymouth | Massachusetts | 25023 | 49234 | 1441 |
1408631 | 1408631 | 2021-06-11 | Plymouth | Massachusetts | 25023 | 49228 | 1441 |
1168363 | 1168363 | 2021-03-29 | Hampden | Massachusetts | 25013 | 45497 | 1441 |
1119641 | 1119641 | 2021-03-14 | Montgomery | Maryland | 24031 | 64818 | 1441 |
1121498 | 1121498 | 2021-03-14 | King | Washington | 53033 | 86236 | 1441 |
1118251 | 1118251 | 2021-03-13 | King | Washington | 53033 | 86236 | 1441 |
1115004 | 1115004 | 2021-03-12 | King | Washington | 53033 | 86004 | 1441 |
1073352 | 1073352 | 2021-02-28 | Pinellas | Florida | 12103 | 66571 | 1441 |
1036635 | 1036635 | 2021-02-16 | Shelby | Tennessee | 47157 | 86522 | 1441 |
1033390 | 1033390 | 2021-02-15 | Shelby | Tennessee | 47157 | 86522 | 1441 |
1030144 | 1030144 | 2021-02-14 | Shelby | Tennessee | 47157 | 86250 | 1441 |
789187 | 789187 | 2020-12-02 | Union | New Jersey | 34039 | 29140 | 1441 |
652915 | 652915 | 2020-10-21 | Middlesex | New Jersey | 34023 | 21431 | 1441 |
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);