ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where deaths = 1608 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467700 | 2467700 | 2022-05-03 | Will | Illinois | 17197 | 166163 | 1608 |
2346828 | 2346828 | 2022-03-27 | El Paso | Colorado | 8041 | 182333 | 1608 |
2343575 | 2343575 | 2022-03-26 | El Paso | Colorado | 8041 | 182333 | 1608 |
2340322 | 2340322 | 2022-03-25 | El Paso | Colorado | 8041 | 182333 | 1608 |
2310825 | 2310825 | 2022-03-16 | Mobile | Alabama | 1097 | 112978 | 1608 |
2200642 | 2200642 | 2022-02-10 | Cobb | Georgia | 13067 | 167249 | 1608 |
2104915 | 2104915 | 2022-01-11 | Delaware | Pennsylvania | 42045 | 94598 | 1608 |
2034736 | 2034736 | 2021-12-21 | Pasco | Florida | 12101 | 80859 | 1608 |
2031486 | 2031486 | 2021-12-20 | Pasco | Florida | 12101 | 80859 | 1608 |
2028235 | 2028235 | 2021-12-19 | Pasco | Florida | 12101 | 80859 | 1608 |
2024984 | 2024984 | 2021-12-18 | Pasco | Florida | 12101 | 80859 | 1608 |
2021733 | 2021733 | 2021-12-17 | Pasco | Florida | 12101 | 80859 | 1608 |
2018482 | 2018482 | 2021-12-16 | Pasco | Florida | 12101 | 80464 | 1608 |
2015232 | 2015232 | 2021-12-15 | Pasco | Florida | 12101 | 80464 | 1608 |
2011981 | 2011981 | 2021-12-14 | Pasco | Florida | 12101 | 80464 | 1608 |
1606670 | 1606670 | 2021-08-11 | Prince George's | Maryland | 24033 | 88309 | 1608 |
1603421 | 1603421 | 2021-08-10 | Prince George's | Maryland | 24033 | 88143 | 1608 |
1600172 | 1600172 | 2021-08-09 | Prince George's | Maryland | 24033 | 88019 | 1608 |
1596924 | 1596924 | 2021-08-08 | Prince George's | Maryland | 24033 | 87893 | 1608 |
1593675 | 1593675 | 2021-08-07 | Prince George's | Maryland | 24033 | 87722 | 1608 |
1590426 | 1590426 | 2021-08-06 | Prince George's | Maryland | 24033 | 87533 | 1608 |
1271423 | 1271423 | 2021-04-30 | Pinellas | Florida | 12103 | 78803 | 1608 |
1172685 | 1172685 | 2021-03-30 | Montgomery | Pennsylvania | 42091 | 59562 | 1608 |
1016821 | 1016821 | 2021-02-10 | Allegheny | Pennsylvania | 42003 | 72177 | 1608 |
956242 | 956242 | 2021-01-23 | Pima | Arizona | 4019 | 95720 | 1608 |
742268 | 742268 | 2020-11-18 | Broward | Florida | 12011 | 97475 | 1608 |
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);