ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where deaths = 1555 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 9
- Florida 14
- Massachusetts 4
- Pennsylvania 4
- New York 3
- North Carolina 3
- Texas 3
- South Carolina 2
- Illinois 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2403758 | 2403758 | 2022-04-13 | Monroe | New York | 36055 | 153835 | 1555 |
2400503 | 2400503 | 2022-04-12 | Monroe | New York | 36055 | 153495 | 1555 |
2397248 | 2397248 | 2022-04-11 | Monroe | New York | 36055 | 153352 | 1555 |
2338771 | 2338771 | 2022-03-24 | Mecklenburg | North Carolina | 37119 | 277210 | 1555 |
2335517 | 2335517 | 2022-03-23 | Mecklenburg | North Carolina | 37119 | 277142 | 1555 |
2332263 | 2332263 | 2022-03-22 | Mecklenburg | North Carolina | 37119 | 277020 | 1555 |
2246441 | 2246441 | 2022-02-24 | Will | Illinois | 17197 | 159520 | 1555 |
2075664 | 2075664 | 2022-01-02 | Lancaster | Pennsylvania | 42071 | 93158 | 1555 |
2072413 | 2072413 | 2022-01-01 | Lancaster | Pennsylvania | 42071 | 92356 | 1555 |
2040053 | 2040053 | 2021-12-22 | Greenville | South Carolina | 45045 | 110588 | 1555 |
2036803 | 2036803 | 2021-12-21 | Greenville | South Carolina | 45045 | 110456 | 1555 |
2026900 | 2026900 | 2021-12-18 | Delaware | Pennsylvania | 42045 | 70552 | 1555 |
1891719 | 1891719 | 2021-11-07 | Pasco | Florida | 12101 | 79364 | 1555 |
1888469 | 1888469 | 2021-11-06 | Pasco | Florida | 12101 | 79364 | 1555 |
1885219 | 1885219 | 2021-11-05 | Pasco | Florida | 12101 | 79364 | 1555 |
1881970 | 1881970 | 2021-11-04 | Pasco | Florida | 12101 | 79142 | 1555 |
1878721 | 1878721 | 2021-11-03 | Pasco | Florida | 12101 | 79142 | 1555 |
1875472 | 1875472 | 2021-11-02 | Pasco | Florida | 12101 | 79142 | 1555 |
1872223 | 1872223 | 2021-11-01 | Pasco | Florida | 12101 | 79142 | 1555 |
1868974 | 1868974 | 2021-10-31 | Pasco | Florida | 12101 | 79142 | 1555 |
1665154 | 1665154 | 2021-08-29 | Hampden | Massachusetts | 25013 | 56474 | 1555 |
1661906 | 1661906 | 2021-08-28 | Hampden | Massachusetts | 25013 | 56474 | 1555 |
1658658 | 1658658 | 2021-08-27 | Hampden | Massachusetts | 25013 | 56474 | 1555 |
1180491 | 1180491 | 2021-04-02 | Pinellas | Florida | 12103 | 72844 | 1555 |
1177244 | 1177244 | 2021-04-01 | Pinellas | Florida | 12103 | 72557 | 1555 |
1143803 | 1143803 | 2021-03-21 | Cameron | Texas | 48061 | 38122 | 1555 |
1140556 | 1140556 | 2021-03-20 | Cameron | Texas | 48061 | 38122 | 1555 |
1137310 | 1137310 | 2021-03-19 | Cameron | Texas | 48061 | 38122 | 1555 |
1122020 | 1122020 | 2021-03-15 | Hillsborough | Florida | 12057 | 115912 | 1555 |
1118773 | 1118773 | 2021-03-14 | Hillsborough | Florida | 12057 | 115722 | 1555 |
1115526 | 1115526 | 2021-03-13 | Hillsborough | Florida | 12057 | 115482 | 1555 |
1102542 | 1102542 | 2021-03-09 | Hillsborough | Florida | 12057 | 114061 | 1555 |
1022286 | 1022286 | 2021-02-12 | Norfolk | Massachusetts | 25021 | 43037 | 1555 |
994101 | 994101 | 2021-02-03 | Allegheny | Pennsylvania | 42003 | 70165 | 1555 |
896876 | 896876 | 2021-01-04 | Unknown | Puerto Rico | 3926 | 1555 |
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);