ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where deaths = 1061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Florida 17
- California 11
- Ohio 10
- Texas 9
- Oklahoma 7
- Maryland 6
- Washington 6
- North Carolina 4
- South Carolina 4
- Colorado 3
- Illinois 3
- Massachusetts 3
- Tennessee 3
- Connecticut 1
- District of Columbia 1
- Indiana 1
- Louisiana 1
- Michigan 1
- Minnesota 1
- Missouri 1
- New Jersey 1
- Oregon 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2370540 | 2370540 | 2022-04-03 | Anne Arundel | Maryland | 24003 | 89232 | 1061 |
2367287 | 2367287 | 2022-04-02 | Anne Arundel | Maryland | 24003 | 89232 | 1061 |
2364034 | 2364034 | 2022-04-01 | Anne Arundel | Maryland | 24003 | 89232 | 1061 |
2360780 | 2360780 | 2022-03-31 | Anne Arundel | Maryland | 24003 | 89185 | 1061 |
2357526 | 2357526 | 2022-03-30 | Anne Arundel | Maryland | 24003 | 89149 | 1061 |
2333898 | 2333898 | 2022-03-23 | Hernando | Florida | 12053 | 41798 | 1061 |
2335665 | 2335665 | 2022-03-23 | Mahoning | Ohio | 39099 | 53217 | 1061 |
2330644 | 2330644 | 2022-03-22 | Hernando | Florida | 12053 | 41798 | 1061 |
2332411 | 2332411 | 2022-03-22 | Mahoning | Ohio | 39099 | 53217 | 1061 |
2327392 | 2327392 | 2022-03-21 | Hernando | Florida | 12053 | 41798 | 1061 |
2329158 | 2329158 | 2022-03-21 | Mahoning | Ohio | 39099 | 53217 | 1061 |
2324139 | 2324139 | 2022-03-20 | Hernando | Florida | 12053 | 41798 | 1061 |
2325906 | 2325906 | 2022-03-20 | Mahoning | Ohio | 39099 | 53217 | 1061 |
2320885 | 2320885 | 2022-03-19 | Hernando | Florida | 12053 | 41798 | 1061 |
2322653 | 2322653 | 2022-03-19 | Mahoning | Ohio | 39099 | 53217 | 1061 |
2317631 | 2317631 | 2022-03-18 | Hernando | Florida | 12053 | 41798 | 1061 |
2319399 | 2319399 | 2022-03-18 | Mahoning | Ohio | 39099 | 53217 | 1061 |
2314378 | 2314378 | 2022-03-17 | Hernando | Florida | 12053 | 41798 | 1061 |
2316145 | 2316145 | 2022-03-17 | Mahoning | Ohio | 39099 | 53217 | 1061 |
2311125 | 2311125 | 2022-03-16 | Hernando | Florida | 12053 | 41798 | 1061 |
2270755 | 2270755 | 2022-03-03 | Multnomah | Oregon | 41051 | 111056 | 1061 |
2271591 | 2271591 | 2022-03-03 | Snohomish | Washington | 53061 | 147025 | 1061 |
2268339 | 2268339 | 2022-03-02 | Snohomish | Washington | 53061 | 147025 | 1061 |
2212423 | 2212423 | 2022-02-13 | Horry | South Carolina | 45051 | 93770 | 1061 |
2209170 | 2209170 | 2022-02-12 | Horry | South Carolina | 45051 | 93770 | 1061 |
2205917 | 2205917 | 2022-02-11 | Horry | South Carolina | 45051 | 93770 | 1061 |
2201349 | 2201349 | 2022-02-10 | Caddo | Louisiana | 22017 | 66187 | 1061 |
2202664 | 2202664 | 2022-02-10 | Horry | South Carolina | 45051 | 93770 | 1061 |
2146463 | 2146463 | 2022-01-24 | Kansas City | Missouri | 103416 | 1061 | |
2125225 | 2125225 | 2022-01-17 | Pierce | Washington | 53053 | 138758 | 1061 |
2121973 | 2121973 | 2022-01-16 | Pierce | Washington | 53053 | 138758 | 1061 |
2118721 | 2118721 | 2022-01-15 | Pierce | Washington | 53053 | 138758 | 1061 |
2115469 | 2115469 | 2022-01-14 | Pierce | Washington | 53053 | 138758 | 1061 |
2082570 | 2082570 | 2022-01-04 | Fort Bend | Texas | 48157 | 125655 | 1061 |
2079318 | 2079318 | 2022-01-03 | Fort Bend | Texas | 48157 | 123801 | 1061 |
2076067 | 2076067 | 2022-01-02 | Fort Bend | Texas | 48157 | 114766 | 1061 |
2072816 | 2072816 | 2022-01-01 | Fort Bend | Texas | 48157 | 114766 | 1061 |
2069565 | 2069565 | 2021-12-31 | Fort Bend | Texas | 48157 | 114766 | 1061 |
2066314 | 2066314 | 2021-12-30 | Fort Bend | Texas | 48157 | 114766 | 1061 |
2056437 | 2056437 | 2021-12-27 | Knox | Tennessee | 47093 | 84190 | 1061 |
2034608 | 2034608 | 2021-12-21 | Adams | Colorado | 8001 | 90684 | 1061 |
2031388 | 2031388 | 2021-12-20 | Jefferson | Colorado | 8059 | 76732 | 1061 |
2018384 | 2018384 | 2021-12-16 | Jefferson | Colorado | 8059 | 76134 | 1061 |
2005299 | 2005299 | 2021-12-12 | Contra Costa | California | 6013 | 105074 | 1061 |
2002048 | 2002048 | 2021-12-11 | Contra Costa | California | 6013 | 105074 | 1061 |
1998798 | 1998798 | 2021-12-10 | Contra Costa | California | 6013 | 105074 | 1061 |
1988379 | 1988379 | 2021-12-06 | Lubbock | Texas | 48303 | 68713 | 1061 |
1985129 | 1985129 | 2021-12-05 | Lubbock | Texas | 48303 | 68477 | 1061 |
1799786 | 1799786 | 2021-10-09 | Collin | Texas | 48085 | 126282 | 1061 |
1774731 | 1774731 | 2021-10-02 | Lake | Florida | 12069 | 52933 | 1061 |
1771481 | 1771481 | 2021-10-01 | Lake | Florida | 12069 | 52933 | 1061 |
1768232 | 1768232 | 2021-09-30 | Lake | Florida | 12069 | 51932 | 1061 |
1770014 | 1770014 | 2021-09-30 | Summit | Ohio | 39153 | 57761 | 1061 |
1764983 | 1764983 | 2021-09-29 | Lake | Florida | 12069 | 51932 | 1061 |
1766765 | 1766765 | 2021-09-29 | Summit | Ohio | 39153 | 57562 | 1061 |
1761734 | 1761734 | 2021-09-28 | Lake | Florida | 12069 | 51932 | 1061 |
1763516 | 1763516 | 2021-09-28 | Summit | Ohio | 39153 | 57360 | 1061 |
1758486 | 1758486 | 2021-09-27 | Lake | Florida | 12069 | 51932 | 1061 |
1755238 | 1755238 | 2021-09-26 | Lake | Florida | 12069 | 51932 | 1061 |
1751990 | 1751990 | 2021-09-25 | Lake | Florida | 12069 | 51932 | 1061 |
1741184 | 1741184 | 2021-09-21 | Davidson | Tennessee | 47037 | 124991 | 1061 |
1737935 | 1737935 | 2021-09-20 | Davidson | Tennessee | 47037 | 124991 | 1061 |
1691874 | 1691874 | 2021-09-06 | Mecklenburg | North Carolina | 37119 | 137651 | 1061 |
1688624 | 1688624 | 2021-09-05 | Mecklenburg | North Carolina | 37119 | 137651 | 1061 |
1685374 | 1685374 | 2021-09-04 | Mecklenburg | North Carolina | 37119 | 137651 | 1061 |
1682123 | 1682123 | 2021-09-03 | Mecklenburg | North Carolina | 37119 | 137651 | 1061 |
1638174 | 1638174 | 2021-08-21 | Ventura | California | 6111 | 92256 | 1061 |
1495778 | 1495778 | 2021-07-08 | Lake | Indiana | 18089 | 56585 | 1061 |
1354437 | 1354437 | 2021-05-25 | Tulsa | Oklahoma | 40143 | 74893 | 1061 |
1351191 | 1351191 | 2021-05-24 | Tulsa | Oklahoma | 40143 | 74893 | 1061 |
1347945 | 1347945 | 2021-05-23 | Tulsa | Oklahoma | 40143 | 74893 | 1061 |
1344697 | 1344697 | 2021-05-22 | Tulsa | Oklahoma | 40143 | 74893 | 1061 |
1341449 | 1341449 | 2021-05-21 | Tulsa | Oklahoma | 40143 | 74893 | 1061 |
1338201 | 1338201 | 2021-05-20 | Tulsa | Oklahoma | 40143 | 74893 | 1061 |
1334954 | 1334954 | 2021-05-19 | Tulsa | Oklahoma | 40143 | 74893 | 1061 |
1326476 | 1326476 | 2021-05-17 | Stanislaus | California | 6099 | 62310 | 1061 |
1323230 | 1323230 | 2021-05-16 | Stanislaus | California | 6099 | 62249 | 1061 |
1323644 | 1323644 | 2021-05-16 | Lake | Illinois | 17097 | 67398 | 1061 |
1319984 | 1319984 | 2021-05-15 | Stanislaus | California | 6099 | 62249 | 1061 |
1320398 | 1320398 | 2021-05-15 | Lake | Illinois | 17097 | 67328 | 1061 |
1316737 | 1316737 | 2021-05-14 | Stanislaus | California | 6099 | 62188 | 1061 |
1313490 | 1313490 | 2021-05-13 | Stanislaus | California | 6099 | 62142 | 1061 |
1297721 | 1297721 | 2021-05-08 | Will | Illinois | 17197 | 74952 | 1061 |
1235048 | 1235048 | 2021-04-18 | Fairfax | Virginia | 51059 | 74499 | 1061 |
1170698 | 1170698 | 2021-03-30 | District of Columbia | District of Columbia | 11001 | 44413 | 1061 |
1060222 | 1060222 | 2021-02-24 | San Joaquin | California | 6077 | 66462 | 1061 |
933647 | 933647 | 2021-01-16 | Santa Clara | California | 6085 | 91466 | 1061 |
863241 | 863241 | 2020-12-25 | Prince George's | Maryland | 24033 | 52390 | 1061 |
743292 | 743292 | 2020-11-18 | Hennepin | Minnesota | 27053 | 53486 | 1061 |
656163 | 656163 | 2020-10-22 | Ocean | New Jersey | 34029 | 16368 | 1061 |
581003 | 581003 | 2020-09-29 | Norfolk | Massachusetts | 25021 | 10308 | 1061 |
513012 | 513012 | 2020-09-08 | Worcester | Massachusetts | 25027 | 13666 | 1061 |
509780 | 509780 | 2020-09-07 | Worcester | Massachusetts | 25027 | 13654 | 1061 |
463653 | 463653 | 2020-08-24 | Palm Beach | Florida | 12099 | 40744 | 1061 |
259135 | 259135 | 2020-06-21 | New Haven | Connecticut | 9009 | 12185 | 1061 |
228979 | 228979 | 2020-06-11 | Oakland | Michigan | 26125 | 11283 | 1061 |
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);