ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where deaths = 1566 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Arizona 7
- Alabama 4
- Illinois 4
- Pennsylvania 4
- Wisconsin 4
- Massachusetts 3
- Georgia 2
- California 1
- Connecticut 1
- Florida 1
- New Jersey 1
- New Mexico 1
- New York 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2452598 | 2452598 | 2022-04-28 | Monroe | New York | 36055 | 158863 | 1566 |
2330403 | 2330403 | 2022-03-22 | Pinal | Arizona | 4021 | 129486 | 1566 |
2327151 | 2327151 | 2022-03-21 | Pinal | Arizona | 4021 | 129486 | 1566 |
2323898 | 2323898 | 2022-03-20 | Pinal | Arizona | 4021 | 129486 | 1566 |
2320644 | 2320644 | 2022-03-19 | Pinal | Arizona | 4021 | 129486 | 1566 |
2317390 | 2317390 | 2022-03-18 | Pinal | Arizona | 4021 | 129486 | 1566 |
2314137 | 2314137 | 2022-03-17 | Pinal | Arizona | 4021 | 129486 | 1566 |
2310884 | 2310884 | 2022-03-16 | Pinal | Arizona | 4021 | 129486 | 1566 |
2268546 | 2268546 | 2022-03-03 | Mobile | Alabama | 1097 | 112640 | 1566 |
2262696 | 2262696 | 2022-03-01 | Will | Illinois | 17197 | 159806 | 1566 |
2261016 | 2261016 | 2022-02-28 | Berks | Pennsylvania | 42011 | 101556 | 1566 |
2257765 | 2257765 | 2022-02-27 | Berks | Pennsylvania | 42011 | 101541 | 1566 |
2254514 | 2254514 | 2022-02-26 | Berks | Pennsylvania | 42011 | 101525 | 1566 |
2215045 | 2215045 | 2022-02-14 | Bernalillo | New Mexico | 35001 | 142279 | 1566 |
2142351 | 2142351 | 2022-01-23 | Unknown | Illinois | 0 | 1566 | |
2139096 | 2139096 | 2022-01-22 | Unknown | Illinois | 0 | 1566 | |
2103250 | 2103250 | 2022-01-11 | DuPage | Illinois | 17043 | 167764 | 1566 |
2085392 | 2085392 | 2022-01-05 | Bucks | Pennsylvania | 42017 | 96801 | 1566 |
2041320 | 2041320 | 2021-12-23 | Gwinnett | Georgia | 13135 | 142008 | 1566 |
2038070 | 2038070 | 2021-12-22 | Gwinnett | Georgia | 13135 | 141083 | 1566 |
1806813 | 1806813 | 2021-10-11 | Milwaukee | Wisconsin | 55079 | 147110 | 1566 |
1803562 | 1803562 | 2021-10-10 | Milwaukee | Wisconsin | 55079 | 146320 | 1566 |
1800313 | 1800313 | 2021-10-09 | Milwaukee | Wisconsin | 55079 | 146320 | 1566 |
1797064 | 1797064 | 2021-10-08 | Milwaukee | Wisconsin | 55079 | 146320 | 1566 |
1787574 | 1787574 | 2021-10-06 | Kern | California | 6029 | 141102 | 1566 |
1700889 | 1700889 | 2021-09-09 | Hampden | Massachusetts | 25013 | 58693 | 1566 |
1436642 | 1436642 | 2021-06-20 | Jefferson | Alabama | 1073 | 81003 | 1566 |
1433395 | 1433395 | 2021-06-19 | Jefferson | Alabama | 1073 | 81003 | 1566 |
1430149 | 1430149 | 2021-06-18 | Jefferson | Alabama | 1073 | 81003 | 1566 |
1259865 | 1259865 | 2021-04-26 | Monmouth | New Jersey | 34025 | 73835 | 1566 |
1166487 | 1166487 | 2021-03-28 | Shelby | Tennessee | 47157 | 90959 | 1566 |
1125266 | 1125266 | 2021-03-16 | Hillsborough | Florida | 12057 | 116309 | 1566 |
1113160 | 1113160 | 2021-03-12 | Bristol | Massachusetts | 25005 | 56939 | 1566 |
986585 | 986585 | 2021-02-01 | Suffolk | Massachusetts | 25025 | 71869 | 1566 |
803912 | 803912 | 2020-12-07 | Fairfield | Connecticut | 9001 | 43840 | 1566 |
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);