ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where deaths = 1307 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Colorado 10
- Ohio 10
- Oklahoma 7
- New Jersey 4
- Delaware 3
- Massachusetts 3
- Maryland 2
- Texas 2
- Alabama 1
- Florida 1
- Georgia 1
- Illinois 1
- Louisiana 1
- New York 1
- North Carolina 1
- Washington 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2346808 | 2346808 | 2022-03-27 | Adams | Colorado | 8001 | 132691 | 1307 |
2343555 | 2343555 | 2022-03-26 | Adams | Colorado | 8001 | 132691 | 1307 |
2340302 | 2340302 | 2022-03-25 | Adams | Colorado | 8001 | 132691 | 1307 |
2301296 | 2301296 | 2022-03-13 | Jefferson | Colorado | 8059 | 119134 | 1307 |
2298044 | 2298044 | 2022-03-12 | Jefferson | Colorado | 8059 | 119134 | 1307 |
2294792 | 2294792 | 2022-03-11 | Jefferson | Colorado | 8059 | 119134 | 1307 |
2285007 | 2285007 | 2022-03-08 | Adams | Colorado | 8001 | 131267 | 1307 |
2281755 | 2281755 | 2022-03-07 | Adams | Colorado | 8001 | 131183 | 1307 |
2278502 | 2278502 | 2022-03-06 | Adams | Colorado | 8001 | 131176 | 1307 |
2275249 | 2275249 | 2022-03-05 | Adams | Colorado | 8001 | 131129 | 1307 |
2266384 | 2266384 | 2022-03-02 | East Baton Rouge | Louisiana | 22033 | 110198 | 1307 |
2236306 | 2236306 | 2022-02-21 | New Castle | Delaware | 10003 | 144554 | 1307 |
2238098 | 2238098 | 2022-02-21 | Lucas | Ohio | 39095 | 98468 | 1307 |
2233055 | 2233055 | 2022-02-20 | New Castle | Delaware | 10003 | 144489 | 1307 |
2234847 | 2234847 | 2022-02-20 | Lucas | Ohio | 39095 | 98444 | 1307 |
2229804 | 2229804 | 2022-02-19 | New Castle | Delaware | 10003 | 144399 | 1307 |
2231596 | 2231596 | 2022-02-19 | Lucas | Ohio | 39095 | 98407 | 1307 |
2228345 | 2228345 | 2022-02-18 | Lucas | Ohio | 39095 | 98326 | 1307 |
2225094 | 2225094 | 2022-02-17 | Lucas | Ohio | 39095 | 98169 | 1307 |
2221843 | 2221843 | 2022-02-16 | Lucas | Ohio | 39095 | 98077 | 1307 |
2218592 | 2218592 | 2022-02-15 | Lucas | Ohio | 39095 | 97914 | 1307 |
2057812 | 2057812 | 2021-12-28 | Will | Illinois | 17197 | 116239 | 1307 |
2036236 | 2036236 | 2021-12-21 | Monroe | New York | 36055 | 107009 | 1307 |
2036328 | 2036328 | 2021-12-21 | Mecklenburg | North Carolina | 37119 | 169288 | 1307 |
2017662 | 2017662 | 2021-12-15 | Nueces | Texas | 48355 | 63096 | 1307 |
1886652 | 1886652 | 2021-11-05 | Morris | New Jersey | 34027 | 58526 | 1307 |
1800416 | 1800416 | 2021-10-10 | Mobile | Alabama | 1097 | 71816 | 1307 |
1724481 | 1724481 | 2021-09-16 | Hamilton | Ohio | 39061 | 95329 | 1307 |
1721232 | 1721232 | 2021-09-15 | Hamilton | Ohio | 39061 | 94887 | 1307 |
1717984 | 1717984 | 2021-09-14 | Hamilton | Ohio | 39061 | 94500 | 1307 |
1445299 | 1445299 | 2021-06-22 | Oklahoma | Oklahoma | 40109 | 87633 | 1307 |
1442054 | 1442054 | 2021-06-21 | Oklahoma | Oklahoma | 40109 | 87633 | 1307 |
1438809 | 1438809 | 2021-06-20 | Oklahoma | Oklahoma | 40109 | 87633 | 1307 |
1435562 | 1435562 | 2021-06-19 | Oklahoma | Oklahoma | 40109 | 87633 | 1307 |
1432315 | 1432315 | 2021-06-18 | Oklahoma | Oklahoma | 40109 | 87633 | 1307 |
1429069 | 1429069 | 2021-06-17 | Oklahoma | Oklahoma | 40109 | 87633 | 1307 |
1425824 | 1425824 | 2021-06-16 | Oklahoma | Oklahoma | 40109 | 87633 | 1307 |
1363749 | 1363749 | 2021-05-28 | Camden | New Jersey | 34007 | 55510 | 1307 |
1360503 | 1360503 | 2021-05-27 | Camden | New Jersey | 34007 | 55480 | 1307 |
1203303 | 1203303 | 2021-04-09 | Fulton | Georgia | 13121 | 93368 | 1307 |
1183310 | 1183310 | 2021-04-02 | Milwaukee | Wisconsin | 55079 | 110601 | 1307 |
1109889 | 1109889 | 2021-03-11 | Baltimore | Maryland | 24005 | 52305 | 1307 |
1054725 | 1054725 | 2021-02-22 | Prince George's | Maryland | 24033 | 72279 | 1307 |
1020876 | 1020876 | 2021-02-11 | King | Washington | 53033 | 81084 | 1307 |
992211 | 992211 | 2021-02-03 | Pinellas | Florida | 12103 | 60322 | 1307 |
889221 | 889221 | 2021-01-02 | Norfolk | Massachusetts | 25021 | 28052 | 1307 |
705687 | 705687 | 2020-11-06 | Dallas | Texas | 48113 | 108631 | 1307 |
616654 | 616654 | 2020-10-10 | Essex | Massachusetts | 25009 | 21078 | 1307 |
613413 | 613413 | 2020-10-09 | Essex | Massachusetts | 25009 | 20945 | 1307 |
273084 | 273084 | 2020-06-25 | Middlesex | New Jersey | 34023 | 16867 | 1307 |
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);