ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where deaths = 1478 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Ohio 4
- Florida 3
- Illinois 3
- Massachusetts 3
- Pennsylvania 3
- Wisconsin 3
- California 2
- Arizona 1
- Connecticut 1
- Georgia 1
- Indiana 1
- Maryland 1
- Michigan 1
- Minnesota 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2319955 | 2319955 | 2022-03-18 | Collin | Texas | 48085 | 207040 | 1478 |
2193816 | 2193816 | 2022-02-08 | Pinal | Arizona | 4021 | 125376 | 1478 |
2103377 | 2103377 | 2022-01-11 | Lake | Indiana | 18089 | 95573 | 1478 |
2076850 | 2076850 | 2022-01-03 | Stanislaus | California | 6099 | 96598 | 1478 |
2017160 | 2017160 | 2021-12-15 | Lancaster | Pennsylvania | 42071 | 83789 | 1478 |
1965126 | 1965126 | 2021-11-29 | Bucks | Pennsylvania | 42017 | 78779 | 1478 |
1904969 | 1904969 | 2021-11-11 | DuPage | Illinois | 17043 | 112094 | 1478 |
1901719 | 1901719 | 2021-11-10 | DuPage | Illinois | 17043 | 112094 | 1478 |
1898469 | 1898469 | 2021-11-09 | DuPage | Illinois | 17043 | 111728 | 1478 |
1809155 | 1809155 | 2021-10-12 | Delaware | Pennsylvania | 42045 | 60476 | 1478 |
1677110 | 1677110 | 2021-09-02 | Kern | California | 6029 | 126250 | 1478 |
1667113 | 1667113 | 2021-08-29 | Milwaukee | Wisconsin | 55079 | 129744 | 1478 |
1663865 | 1663865 | 2021-08-28 | Milwaukee | Wisconsin | 55079 | 129744 | 1478 |
1660617 | 1660617 | 2021-08-27 | Milwaukee | Wisconsin | 55079 | 129744 | 1478 |
1508464 | 1508464 | 2021-07-12 | Fulton | Georgia | 13121 | 100238 | 1478 |
1464651 | 1464651 | 2021-06-28 | Franklin | Ohio | 39049 | 129120 | 1478 |
1461406 | 1461406 | 2021-06-27 | Franklin | Ohio | 39049 | 129083 | 1478 |
1458161 | 1458161 | 2021-06-26 | Franklin | Ohio | 39049 | 129060 | 1478 |
1454916 | 1454916 | 2021-06-25 | Franklin | Ohio | 39049 | 129028 | 1478 |
1355800 | 1355800 | 2021-05-26 | Duval | Florida | 12031 | 100303 | 1478 |
1349308 | 1349308 | 2021-05-24 | Duval | Florida | 12031 | 100131 | 1478 |
1281995 | 1281995 | 2021-05-03 | Baltimore | Maryland | 24005 | 63871 | 1478 |
941261 | 941261 | 2021-01-18 | Hennepin | Minnesota | 27053 | 92930 | 1478 |
934658 | 934658 | 2021-01-16 | Suffolk | Massachusetts | 25025 | 64867 | 1478 |
872999 | 872999 | 2020-12-28 | Worcester | Massachusetts | 25027 | 40418 | 1478 |
827627 | 827627 | 2020-12-14 | Oakland | Michigan | 26125 | 55183 | 1478 |
761726 | 761726 | 2020-11-24 | Fairfield | Connecticut | 9001 | 35494 | 1478 |
635256 | 635256 | 2020-10-16 | Palm Beach | Florida | 12099 | 48672 | 1478 |
164478 | 164478 | 2020-05-21 | Middlesex | Massachusetts | 25017 | 19930 | 1478 |
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);