ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where deaths = 1030 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- New Jersey 11
- South Carolina 11
- Texas 10
- Ohio 7
- Illinois 6
- North Carolina 5
- Colorado 4
- New York 4
- California 3
- Kansas 3
- Washington 3
- District of Columbia 2
- Massachusetts 2
- Minnesota 2
- Nevada 2
- Pennsylvania 2
- Florida 1
- Michigan 1
- Tennessee 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2388474 | 2388474 | 2022-04-08 | Webb | Texas | 48479 | 93211 | 1030 |
2385219 | 2385219 | 2022-04-07 | Webb | Texas | 48479 | 93160 | 1030 |
2381964 | 2381964 | 2022-04-06 | Webb | Texas | 48479 | 93126 | 1030 |
2378709 | 2378709 | 2022-04-05 | Webb | Texas | 48479 | 93094 | 1030 |
2375455 | 2375455 | 2022-04-04 | Webb | Texas | 48479 | 93039 | 1030 |
2372203 | 2372203 | 2022-04-03 | Webb | Texas | 48479 | 93038 | 1030 |
2368950 | 2368950 | 2022-04-02 | Webb | Texas | 48479 | 93036 | 1030 |
2365697 | 2365697 | 2022-04-01 | Webb | Texas | 48479 | 93019 | 1030 |
2280255 | 2280255 | 2022-03-06 | Wake | North Carolina | 37183 | 286542 | 1030 |
2277002 | 2277002 | 2022-03-05 | Wake | North Carolina | 37183 | 286542 | 1030 |
2273631 | 2273631 | 2022-03-04 | Onondaga | New York | 36067 | 107408 | 1030 |
2273749 | 2273749 | 2022-03-04 | Wake | North Carolina | 37183 | 286542 | 1030 |
2270378 | 2270378 | 2022-03-03 | Onondaga | New York | 36067 | 107408 | 1030 |
2270496 | 2270496 | 2022-03-03 | Wake | North Carolina | 37183 | 286224 | 1030 |
2215793 | 2215793 | 2022-02-14 | Hamilton | Tennessee | 47065 | 96329 | 1030 |
2104407 | 2104407 | 2022-01-11 | Washoe | Nevada | 32031 | 78412 | 1030 |
2101156 | 2101156 | 2022-01-10 | Washoe | Nevada | 32031 | 77315 | 1030 |
2097067 | 2097067 | 2022-01-09 | Johnson | Kansas | 20091 | 103796 | 1030 |
2097920 | 2097920 | 2022-01-09 | Burlington | New Jersey | 34005 | 83530 | 1030 |
2093815 | 2093815 | 2022-01-08 | Johnson | Kansas | 20091 | 103796 | 1030 |
2094668 | 2094668 | 2022-01-08 | Burlington | New Jersey | 34005 | 82084 | 1030 |
2090563 | 2090563 | 2022-01-07 | Johnson | Kansas | 20091 | 103796 | 1030 |
2005381 | 2005381 | 2021-12-12 | Jefferson | Colorado | 8059 | 75181 | 1030 |
2002130 | 2002130 | 2021-12-11 | Jefferson | Colorado | 8059 | 75181 | 1030 |
1998880 | 1998880 | 2021-12-10 | Jefferson | Colorado | 8059 | 75181 | 1030 |
1997465 | 1997465 | 2021-12-09 | Lucas | Ohio | 39095 | 64550 | 1030 |
1994214 | 1994214 | 2021-12-08 | Lucas | Ohio | 39095 | 64256 | 1030 |
1990963 | 1990963 | 2021-12-07 | Lucas | Ohio | 39095 | 64042 | 1030 |
1961403 | 1961403 | 2021-11-28 | Mercer | New Jersey | 34021 | 41502 | 1030 |
1958152 | 1958152 | 2021-11-27 | Mercer | New Jersey | 34021 | 41426 | 1030 |
1941483 | 1941483 | 2021-11-22 | Ramsey | Minnesota | 27123 | 70883 | 1030 |
1907032 | 1907032 | 2021-11-11 | Denton | Texas | 48121 | 108998 | 1030 |
1907437 | 1907437 | 2021-11-11 | Spokane | Washington | 53063 | 75357 | 1030 |
1904188 | 1904188 | 2021-11-10 | Spokane | Washington | 53063 | 75357 | 1030 |
1900938 | 1900938 | 2021-11-09 | Spokane | Washington | 53063 | 75233 | 1030 |
1805755 | 1805755 | 2021-10-11 | Stark | Ohio | 39151 | 44981 | 1030 |
1802505 | 1802505 | 2021-10-10 | Stark | Ohio | 39151 | 44863 | 1030 |
1799256 | 1799256 | 2021-10-09 | Stark | Ohio | 39151 | 44698 | 1030 |
1796007 | 1796007 | 2021-10-08 | Stark | Ohio | 39151 | 44575 | 1030 |
1790887 | 1790887 | 2021-10-07 | El Paso | Colorado | 8041 | 94170 | 1030 |
1656139 | 1656139 | 2021-08-26 | Mecklenburg | North Carolina | 37119 | 133232 | 1030 |
1452024 | 1452024 | 2021-06-24 | Greenville | South Carolina | 45045 | 75595 | 1030 |
1448778 | 1448778 | 2021-06-23 | Greenville | South Carolina | 45045 | 75576 | 1030 |
1445533 | 1445533 | 2021-06-22 | Greenville | South Carolina | 45045 | 75559 | 1030 |
1442288 | 1442288 | 2021-06-21 | Greenville | South Carolina | 45045 | 75555 | 1030 |
1439043 | 1439043 | 2021-06-20 | Greenville | South Carolina | 45045 | 75510 | 1030 |
1435796 | 1435796 | 2021-06-19 | Greenville | South Carolina | 45045 | 75510 | 1030 |
1430354 | 1430354 | 2021-06-18 | Ventura | California | 6111 | 81638 | 1030 |
1432549 | 1432549 | 2021-06-18 | Greenville | South Carolina | 45045 | 75510 | 1030 |
1429303 | 1429303 | 2021-06-17 | Greenville | South Carolina | 45045 | 75490 | 1030 |
1426058 | 1426058 | 2021-06-16 | Greenville | South Carolina | 45045 | 75470 | 1030 |
1422811 | 1422811 | 2021-06-15 | Greenville | South Carolina | 45045 | 75467 | 1030 |
1419565 | 1419565 | 2021-06-14 | Greenville | South Carolina | 45045 | 75450 | 1030 |
1406996 | 1406996 | 2021-06-10 | Travis | Texas | 48453 | 84072 | 1030 |
1235568 | 1235568 | 2021-04-19 | Stanislaus | California | 6099 | 60513 | 1030 |
1213248 | 1213248 | 2021-04-12 | Lake | Illinois | 17097 | 63797 | 1030 |
1214470 | 1214470 | 2021-04-12 | Monroe | New York | 36055 | 59540 | 1030 |
1210000 | 1210000 | 2021-04-11 | Lake | Illinois | 17097 | 63692 | 1030 |
1206751 | 1206751 | 2021-04-10 | Lake | Illinois | 17097 | 63597 | 1030 |
1203503 | 1203503 | 2021-04-09 | Lake | Illinois | 17097 | 63482 | 1030 |
1096020 | 1096020 | 2021-03-07 | District of Columbia | District of Columbia | 11001 | 41419 | 1030 |
1092774 | 1092774 | 2021-03-06 | District of Columbia | District of Columbia | 11001 | 41273 | 1030 |
1072030 | 1072030 | 2021-02-27 | Lancaster | Pennsylvania | 42071 | 43527 | 1030 |
1068784 | 1068784 | 2021-02-26 | Lancaster | Pennsylvania | 42071 | 43348 | 1030 |
1014933 | 1014933 | 2021-02-10 | Polk | Florida | 12105 | 53316 | 1030 |
998516 | 998516 | 2021-02-05 | Alameda | California | 6001 | 75443 | 1030 |
930119 | 930119 | 2021-01-14 | Milwaukee | Wisconsin | 55079 | 98299 | 1030 |
885359 | 885359 | 2021-01-01 | DuPage | Illinois | 17043 | 61805 | 1030 |
882114 | 882114 | 2020-12-31 | DuPage | Illinois | 17043 | 61805 | 1030 |
880050 | 880050 | 2020-12-30 | Monmouth | New Jersey | 34025 | 31482 | 1030 |
720581 | 720581 | 2020-11-11 | Hennepin | Minnesota | 27053 | 45372 | 1030 |
587538 | 587538 | 2020-10-01 | Macomb | Michigan | 26099 | 15153 | 1030 |
525950 | 525950 | 2020-09-12 | Norfolk | Massachusetts | 25021 | 9809 | 1030 |
513570 | 513570 | 2020-09-08 | Ocean | New Jersey | 34029 | 11585 | 1030 |
510337 | 510337 | 2020-09-07 | Ocean | New Jersey | 34029 | 11558 | 1030 |
507104 | 507104 | 2020-09-06 | Ocean | New Jersey | 34029 | 11525 | 1030 |
503872 | 503872 | 2020-09-05 | Ocean | New Jersey | 34029 | 11490 | 1030 |
500638 | 500638 | 2020-09-04 | Ocean | New Jersey | 34029 | 11421 | 1030 |
342258 | 342258 | 2020-07-17 | Suffolk | Massachusetts | 25025 | 20499 | 1030 |
180181 | 180181 | 2020-05-26 | Union | New Jersey | 34039 | 15293 | 1030 |
52673 | 52673 | 2020-04-12 | Nassau | New York | 36059 | 23553 | 1030 |
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);