ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where deaths = 1226 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- Ohio 5
- Pennsylvania 5
- Illinois 4
- New Jersey 4
- Tennessee 3
- California 2
- Texas 2
- Colorado 1
- Georgia 1
- Maryland 1
- Massachusetts 1
- New York 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2267552 | 2267552 | 2022-03-02 | Lehigh | Pennsylvania | 42077 | 88812 | 1226 |
2218284 | 2218284 | 2022-02-15 | Mercer | New Jersey | 34021 | 73931 | 1226 |
2208528 | 2208528 | 2022-02-12 | Mercer | New Jersey | 34021 | 73744 | 1226 |
2199654 | 2199654 | 2022-02-09 | Denton | Texas | 48121 | 171278 | 1226 |
2080517 | 2080517 | 2022-01-04 | Lake | Illinois | 17097 | 106216 | 1226 |
2007655 | 2007655 | 2021-12-12 | Davidson | Tennessee | 47037 | 137371 | 1226 |
2004404 | 2004404 | 2021-12-11 | Davidson | Tennessee | 47037 | 137371 | 1226 |
2001153 | 2001153 | 2021-12-10 | Davidson | Tennessee | 47037 | 137371 | 1226 |
1946242 | 1946242 | 2021-11-23 | Salt Lake | Utah | 49035 | 208196 | 1226 |
1940360 | 1940360 | 2021-11-22 | El Paso | Colorado | 8041 | 112103 | 1226 |
1937546 | 1937546 | 2021-11-21 | Will | Illinois | 17197 | 96506 | 1226 |
1934296 | 1934296 | 2021-11-20 | Will | Illinois | 17197 | 96506 | 1226 |
1931045 | 1931045 | 2021-11-19 | Will | Illinois | 17197 | 96506 | 1226 |
1912717 | 1912717 | 2021-11-13 | Monroe | New York | 36055 | 90875 | 1226 |
1812919 | 1812919 | 2021-10-13 | Nueces | Texas | 48355 | 60963 | 1226 |
1760429 | 1760429 | 2021-09-27 | Lancaster | Pennsylvania | 42071 | 65020 | 1226 |
1757181 | 1757181 | 2021-09-26 | Lancaster | Pennsylvania | 42071 | 64830 | 1226 |
1753933 | 1753933 | 2021-09-25 | Lancaster | Pennsylvania | 42071 | 64634 | 1226 |
1719563 | 1719563 | 2021-09-15 | Cobb | Georgia | 13067 | 101818 | 1226 |
1351061 | 1351061 | 2021-05-24 | Hamilton | Ohio | 39061 | 80741 | 1226 |
1347815 | 1347815 | 2021-05-23 | Hamilton | Ohio | 39061 | 80719 | 1226 |
1344567 | 1344567 | 2021-05-22 | Hamilton | Ohio | 39061 | 80688 | 1226 |
1341319 | 1341319 | 2021-05-21 | Hamilton | Ohio | 39061 | 80641 | 1226 |
1178665 | 1178665 | 2021-04-01 | Camden | New Jersey | 34007 | 49000 | 1226 |
1010145 | 1010145 | 2021-02-08 | Cuyahoga | Ohio | 39035 | 91318 | 1226 |
937881 | 937881 | 2021-01-17 | Montgomery | Maryland | 24031 | 54285 | 1226 |
916254 | 916254 | 2021-01-10 | Montgomery | Pennsylvania | 42091 | 40964 | 1226 |
586465 | 586465 | 2020-10-01 | Riverside | California | 6065 | 59488 | 1226 |
583225 | 583225 | 2020-09-30 | Riverside | California | 6065 | 59405 | 1226 |
470970 | 470970 | 2020-08-26 | Essex | Massachusetts | 25009 | 18628 | 1226 |
220121 | 220121 | 2020-06-08 | Hudson | New Jersey | 34017 | 18584 | 1226 |
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);