ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where deaths = 1589 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Colorado 7
- Alabama 4
- Pennsylvania 3
- Wisconsin 3
- Massachusetts 2
- Michigan 2
- Florida 1
- Illinois 1
- Indiana 1
- Maryland 1
- Minnesota 1
- New Jersey 1
- New Mexico 1
- South Carolina 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2361850 | 2361850 | 2022-03-31 | Berks | Pennsylvania | 42011 | 102117 | 1589 |
2358596 | 2358596 | 2022-03-30 | Berks | Pennsylvania | 42011 | 102105 | 1589 |
2355342 | 2355342 | 2022-03-29 | Berks | Pennsylvania | 42011 | 102096 | 1589 |
2350517 | 2350517 | 2022-03-28 | Will | Illinois | 17197 | 161405 | 1589 |
2313677 | 2313677 | 2022-03-16 | Salt Lake | Utah | 49035 | 340483 | 1589 |
2278522 | 2278522 | 2022-03-06 | El Paso | Colorado | 8041 | 179309 | 1589 |
2275269 | 2275269 | 2022-03-05 | El Paso | Colorado | 8041 | 179309 | 1589 |
2272016 | 2272016 | 2022-03-04 | El Paso | Colorado | 8041 | 179309 | 1589 |
2268764 | 2268764 | 2022-03-03 | El Paso | Colorado | 8041 | 179169 | 1589 |
2255758 | 2255758 | 2022-02-27 | El Paso | Colorado | 8041 | 178427 | 1589 |
2252507 | 2252507 | 2022-02-26 | El Paso | Colorado | 8041 | 178427 | 1589 |
2249256 | 2249256 | 2022-02-25 | El Paso | Colorado | 8041 | 178427 | 1589 |
2224798 | 2224798 | 2022-02-17 | Bernalillo | New Mexico | 35001 | 143135 | 1589 |
2201487 | 2201487 | 2022-02-10 | Genesee | Michigan | 26049 | 98337 | 1589 |
2198233 | 2198233 | 2022-02-09 | Genesee | Michigan | 26049 | 98337 | 1589 |
2145663 | 2145663 | 2022-01-24 | Lake | Indiana | 18089 | 102241 | 1589 |
2127184 | 2127184 | 2022-01-18 | Camden | New Jersey | 34007 | 114012 | 1589 |
2108318 | 2108318 | 2022-01-12 | Greenville | South Carolina | 45045 | 131064 | 1589 |
1823057 | 1823057 | 2021-10-16 | Milwaukee | Wisconsin | 55079 | 148037 | 1589 |
1819808 | 1819808 | 2021-10-15 | Milwaukee | Wisconsin | 55079 | 148037 | 1589 |
1816559 | 1816559 | 2021-10-14 | Milwaukee | Wisconsin | 55079 | 148037 | 1589 |
1723624 | 1723624 | 2021-09-16 | Hampden | Massachusetts | 25013 | 60233 | 1589 |
1566502 | 1566502 | 2021-07-30 | Jefferson | Alabama | 1073 | 84522 | 1589 |
1563254 | 1563254 | 2021-07-29 | Jefferson | Alabama | 1073 | 84522 | 1589 |
1560006 | 1560006 | 2021-07-28 | Jefferson | Alabama | 1073 | 84198 | 1589 |
1556759 | 1556759 | 2021-07-27 | Jefferson | Alabama | 1073 | 83957 | 1589 |
1424840 | 1424840 | 2021-06-16 | Prince George's | Maryland | 24033 | 85415 | 1589 |
1248694 | 1248694 | 2021-04-23 | Pinellas | Florida | 12103 | 77582 | 1589 |
1139133 | 1139133 | 2021-03-20 | Bristol | Massachusetts | 25005 | 57960 | 1589 |
1090559 | 1090559 | 2021-03-05 | Hennepin | Minnesota | 27053 | 101285 | 1589 |
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);