ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where deaths = 1711 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- Michigan 7
- New Jersey 5
- Florida 3
- Pennsylvania 3
- Texas 3
- Maryland 2
- Massachusetts 2
- Georgia 1
- Illinois 1
- Kentucky 1
- New Mexico 1
- New York 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445478 | 2445478 | 2022-04-26 | Genesee | Michigan | 26049 | 101611 | 1711 |
2442222 | 2442222 | 2022-04-25 | Genesee | Michigan | 26049 | 101611 | 1711 |
2438966 | 2438966 | 2022-04-24 | Genesee | Michigan | 26049 | 101611 | 1711 |
2435710 | 2435710 | 2022-04-23 | Genesee | Michigan | 26049 | 101611 | 1711 |
2432454 | 2432454 | 2022-04-22 | Genesee | Michigan | 26049 | 101611 | 1711 |
2429198 | 2429198 | 2022-04-21 | Genesee | Michigan | 26049 | 101611 | 1711 |
2425942 | 2425942 | 2022-04-20 | Genesee | Michigan | 26049 | 101611 | 1711 |
2312594 | 2312594 | 2022-03-16 | Bernalillo | New Mexico | 35001 | 145923 | 1711 |
2291688 | 2291688 | 2022-03-10 | Cobb | Georgia | 13067 | 170156 | 1711 |
2194334 | 2194334 | 2022-02-08 | DuPage | Illinois | 17043 | 201470 | 1711 |
2169979 | 2169979 | 2022-01-31 | Delaware | Pennsylvania | 42045 | 106126 | 1711 |
2156945 | 2156945 | 2022-01-27 | Bucks | Pennsylvania | 42017 | 117418 | 1711 |
1944402 | 1944402 | 2021-11-23 | Jefferson | Kentucky | 21111 | 124767 | 1711 |
1863322 | 1863322 | 2021-10-29 | Montgomery | Maryland | 24031 | 82416 | 1711 |
1795675 | 1795675 | 2021-10-08 | Monmouth | New Jersey | 34025 | 89965 | 1711 |
1792426 | 1792426 | 2021-10-07 | Monmouth | New Jersey | 34025 | 89812 | 1711 |
1789177 | 1789177 | 2021-10-06 | Monmouth | New Jersey | 34025 | 89683 | 1711 |
1671619 | 1671619 | 2021-08-31 | Baltimore | Maryland | 24005 | 69935 | 1711 |
1578864 | 1578864 | 2021-08-02 | Cameron | Texas | 48061 | 44509 | 1711 |
1575616 | 1575616 | 2021-08-01 | Cameron | Texas | 48061 | 44509 | 1711 |
1572368 | 1572368 | 2021-07-31 | Cameron | Texas | 48061 | 44509 | 1711 |
1354525 | 1354525 | 2021-05-25 | Montgomery | Pennsylvania | 42091 | 69867 | 1711 |
1311237 | 1311237 | 2021-05-12 | Bristol | Massachusetts | 25005 | 65857 | 1711 |
1274646 | 1274646 | 2021-05-01 | Hillsborough | Florida | 12057 | 135705 | 1711 |
1103998 | 1103998 | 2021-03-09 | Passaic | New Jersey | 34031 | 58725 | 1711 |
906113 | 906113 | 2021-01-07 | Westchester | New York | 36119 | 75175 | 1711 |
889782 | 889782 | 2021-01-02 | Hudson | New Jersey | 34017 | 45054 | 1711 |
807176 | 807176 | 2020-12-08 | Broward | Florida | 12011 | 115414 | 1711 |
803931 | 803931 | 2020-12-07 | Broward | Florida | 12011 | 114426 | 1711 |
219617 | 219617 | 2020-06-08 | Middlesex | Massachusetts | 25017 | 22812 | 1711 |
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);