ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where deaths = 1882 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- Florida 15
- Pennsylvania 11
- Rhode Island 7
- Massachusetts 4
- California 2
- Arizona 1
- New Jersey 1
- New York 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2421789 | 2421789 | 2022-04-19 | Pasco | Florida | 12101 | 122195 | 1882 |
2422657 | 2422657 | 2022-04-19 | Norfolk | Massachusetts | 25021 | 134286 | 1882 |
2418533 | 2418533 | 2022-04-18 | Pasco | Florida | 12101 | 122195 | 1882 |
2420467 | 2420467 | 2022-04-18 | Lancaster | Pennsylvania | 42071 | 121233 | 1882 |
2415277 | 2415277 | 2022-04-17 | Pasco | Florida | 12101 | 122195 | 1882 |
2417211 | 2417211 | 2022-04-17 | Lancaster | Pennsylvania | 42071 | 121212 | 1882 |
2412021 | 2412021 | 2022-04-16 | Pasco | Florida | 12101 | 122195 | 1882 |
2413955 | 2413955 | 2022-04-16 | Lancaster | Pennsylvania | 42071 | 121190 | 1882 |
2408765 | 2408765 | 2022-04-15 | Pasco | Florida | 12101 | 122195 | 1882 |
2405509 | 2405509 | 2022-04-14 | Pasco | Florida | 12101 | 122195 | 1882 |
2402254 | 2402254 | 2022-04-13 | Pasco | Florida | 12101 | 122195 | 1882 |
2404160 | 2404160 | 2022-04-13 | Bucks | Pennsylvania | 42017 | 123455 | 1882 |
2400905 | 2400905 | 2022-04-12 | Bucks | Pennsylvania | 42017 | 123401 | 1882 |
2397650 | 2397650 | 2022-04-11 | Bucks | Pennsylvania | 42017 | 123322 | 1882 |
2394395 | 2394395 | 2022-04-10 | Bucks | Pennsylvania | 42017 | 123296 | 1882 |
2391139 | 2391139 | 2022-04-09 | Bucks | Pennsylvania | 42017 | 123270 | 1882 |
2387883 | 2387883 | 2022-04-08 | Bucks | Pennsylvania | 42017 | 123222 | 1882 |
2194074 | 2194074 | 2022-02-08 | Marion | Florida | 12083 | 79585 | 1882 |
2190820 | 2190820 | 2022-02-07 | Marion | Florida | 12083 | 79585 | 1882 |
2187567 | 2187567 | 2022-02-06 | Marion | Florida | 12083 | 79585 | 1882 |
2184314 | 2184314 | 2022-02-05 | Marion | Florida | 12083 | 79585 | 1882 |
2181062 | 2181062 | 2022-02-04 | Marion | Florida | 12083 | 79585 | 1882 |
2177811 | 2177811 | 2022-02-03 | Marion | Florida | 12083 | 76962 | 1882 |
2174558 | 2174558 | 2022-02-02 | Marion | Florida | 12083 | 76962 | 1882 |
2149400 | 2149400 | 2022-01-25 | Hampden | Massachusetts | 25013 | 123080 | 1882 |
2135092 | 2135092 | 2022-01-20 | Milwaukee | Wisconsin | 55079 | 252921 | 1882 |
1803846 | 1803846 | 2021-10-11 | Santa Clara | California | 6085 | 143968 | 1882 |
1746376 | 1746376 | 2021-09-23 | Suffolk | Massachusetts | 25025 | 103350 | 1882 |
1743747 | 1743747 | 2021-09-22 | Erie | New York | 36029 | 99069 | 1882 |
1729084 | 1729084 | 2021-09-18 | Fresno | California | 6019 | 135172 | 1882 |
1250585 | 1250585 | 2021-04-23 | Allegheny | Pennsylvania | 42003 | 95490 | 1882 |
1214409 | 1214409 | 2021-04-12 | Union | New Jersey | 34039 | 67191 | 1882 |
1150056 | 1150056 | 2021-03-23 | Providence | Rhode Island | 44007 | 86088 | 1882 |
1146809 | 1146809 | 2021-03-22 | Providence | Rhode Island | 44007 | 86088 | 1882 |
1143562 | 1143562 | 2021-03-21 | Providence | Rhode Island | 44007 | 86088 | 1882 |
1140315 | 1140315 | 2021-03-20 | Providence | Rhode Island | 44007 | 86088 | 1882 |
1137069 | 1137069 | 2021-03-19 | Providence | Rhode Island | 44007 | 86088 | 1882 |
1133823 | 1133823 | 2021-03-18 | Providence | Rhode Island | 44007 | 86088 | 1882 |
1130575 | 1130575 | 2021-03-17 | Providence | Rhode Island | 44007 | 86088 | 1882 |
894804 | 894804 | 2021-01-04 | Broward | Florida | 12011 | 141993 | 1882 |
676132 | 676132 | 2020-10-28 | Philadelphia | Pennsylvania | 42101 | 43740 | 1882 |
376390 | 376390 | 2020-07-28 | Maricopa | Arizona | 4013 | 111446 | 1882 |
307247 | 307247 | 2020-07-06 | Middlesex | Massachusetts | 25017 | 24193 | 1882 |
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);