ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
156 rows where deaths = 847 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Texas 30
- Delaware 28
- Florida 13
- Illinois 9
- New Jersey 9
- Arizona 8
- Colorado 7
- Missouri 7
- Arkansas 6
- Louisiana 5
- Pennsylvania 5
- California 4
- Idaho 4
- Ohio 4
- Michigan 3
- Minnesota 3
- Oregon 3
- Kansas 2
- Alabama 1
- District of Columbia 1
- Georgia 1
- Maryland 1
- South Carolina 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489915 | 2489915 | 2022-05-10 | Benton | Arkansas | 5007 | 67017 | 847 |
2486658 | 2486658 | 2022-05-09 | Benton | Arkansas | 5007 | 66986 | 847 |
2483400 | 2483400 | 2022-05-08 | Benton | Arkansas | 5007 | 66981 | 847 |
2480142 | 2480142 | 2022-05-07 | Benton | Arkansas | 5007 | 66962 | 847 |
2476884 | 2476884 | 2022-05-06 | Benton | Arkansas | 5007 | 66941 | 847 |
2473626 | 2473626 | 2022-05-05 | Benton | Arkansas | 5007 | 66925 | 847 |
2421748 | 2421748 | 2022-04-19 | Clay | Florida | 12019 | 53494 | 847 |
2418492 | 2418492 | 2022-04-18 | Clay | Florida | 12019 | 53494 | 847 |
2415236 | 2415236 | 2022-04-17 | Clay | Florida | 12019 | 53494 | 847 |
2411980 | 2411980 | 2022-04-16 | Clay | Florida | 12019 | 53494 | 847 |
2408724 | 2408724 | 2022-04-15 | Clay | Florida | 12019 | 53494 | 847 |
2405468 | 2405468 | 2022-04-14 | Clay | Florida | 12019 | 53494 | 847 |
2402213 | 2402213 | 2022-04-13 | Clay | Florida | 12019 | 53494 | 847 |
2388318 | 2388318 | 2022-04-08 | Galveston | Texas | 48167 | 95595 | 847 |
2385063 | 2385063 | 2022-04-07 | Galveston | Texas | 48167 | 95575 | 847 |
2380268 | 2380268 | 2022-04-06 | St. Tammany | Louisiana | 22103 | 72022 | 847 |
2376543 | 2376543 | 2022-04-05 | Winnebago | Illinois | 17201 | 76408 | 847 |
2373291 | 2373291 | 2022-04-04 | Winnebago | Illinois | 17201 | 76391 | 847 |
2370038 | 2370038 | 2022-04-03 | Winnebago | Illinois | 17201 | 76347 | 847 |
2366785 | 2366785 | 2022-04-02 | Winnebago | Illinois | 17201 | 76347 | 847 |
2363532 | 2363532 | 2022-04-01 | Winnebago | Illinois | 17201 | 76347 | 847 |
2290464 | 2290464 | 2022-03-09 | Lexington | South Carolina | 45063 | 95372 | 847 |
2269157 | 2269157 | 2022-03-03 | Madison | Illinois | 17119 | 69772 | 847 |
2236092 | 2236092 | 2022-02-21 | Navajo | Arizona | 4017 | 37429 | 847 |
2232841 | 2232841 | 2022-02-20 | Navajo | Arizona | 4017 | 37429 | 847 |
2229590 | 2229590 | 2022-02-19 | Navajo | Arizona | 4017 | 37396 | 847 |
2226339 | 2226339 | 2022-02-18 | Navajo | Arizona | 4017 | 37321 | 847 |
2222519 | 2222519 | 2022-02-16 | McLennan | Texas | 48309 | 55466 | 847 |
2194132 | 2194132 | 2022-02-08 | Clayton | Georgia | 13063 | 62327 | 847 |
2192599 | 2192599 | 2022-02-07 | Trumbull | Ohio | 39155 | 40710 | 847 |
2189345 | 2189345 | 2022-02-06 | Trumbull | Ohio | 39155 | 40675 | 847 |
2186092 | 2186092 | 2022-02-05 | Trumbull | Ohio | 39155 | 40650 | 847 |
2182840 | 2182840 | 2022-02-04 | Trumbull | Ohio | 39155 | 40618 | 847 |
2148551 | 2148551 | 2022-01-25 | Unknown | Florida | 102192 | 847 | |
2089592 | 2089592 | 2022-01-06 | Waukesha | Wisconsin | 55133 | 78836 | 847 |
2078150 | 2078150 | 2022-01-03 | Greene | Missouri | 29077 | 50698 | 847 |
2074899 | 2074899 | 2022-01-02 | Greene | Missouri | 29077 | 49923 | 847 |
2071648 | 2071648 | 2022-01-01 | Greene | Missouri | 29077 | 49923 | 847 |
2068397 | 2068397 | 2021-12-31 | Greene | Missouri | 29077 | 49923 | 847 |
2065146 | 2065146 | 2021-12-30 | Greene | Missouri | 29077 | 49923 | 847 |
2061896 | 2061896 | 2021-12-29 | Greene | Missouri | 29077 | 49602 | 847 |
2058647 | 2058647 | 2021-12-28 | Greene | Missouri | 29077 | 49395 | 847 |
2023674 | 2023674 | 2021-12-17 | Northampton | Pennsylvania | 42095 | 53179 | 847 |
2008915 | 2008915 | 2021-12-13 | Ada | Idaho | 16001 | 86911 | 847 |
2005664 | 2005664 | 2021-12-12 | Ada | Idaho | 16001 | 86714 | 847 |
2002413 | 2002413 | 2021-12-11 | Ada | Idaho | 16001 | 86714 | 847 |
1999163 | 1999163 | 2021-12-10 | Ada | Idaho | 16001 | 86663 | 847 |
1984607 | 1984607 | 2021-12-05 | Multnomah | Oregon | 41051 | 60720 | 847 |
1981357 | 1981357 | 2021-12-04 | Multnomah | Oregon | 41051 | 60720 | 847 |
1978107 | 1978107 | 2021-12-03 | Multnomah | Oregon | 41051 | 60720 | 847 |
1879041 | 1879041 | 2021-11-03 | Unknown | Illinois | 0 | 847 | |
1741340 | 1741340 | 2021-09-21 | Fort Bend | Texas | 48157 | 92857 | 847 |
1741431 | 1741431 | 2021-09-21 | Montgomery | Texas | 48339 | 82829 | 847 |
1738091 | 1738091 | 2021-09-20 | Fort Bend | Texas | 48157 | 91995 | 847 |
1734841 | 1734841 | 2021-09-19 | Fort Bend | Texas | 48157 | 91754 | 847 |
1731591 | 1731591 | 2021-09-18 | Fort Bend | Texas | 48157 | 91754 | 847 |
1728341 | 1728341 | 2021-09-17 | Fort Bend | Texas | 48157 | 91754 | 847 |
1725092 | 1725092 | 2021-09-16 | Fort Bend | Texas | 48157 | 91233 | 847 |
1677892 | 1677892 | 2021-09-02 | Sedgwick | Kansas | 20173 | 67400 | 847 |
1674645 | 1674645 | 2021-09-01 | Sedgwick | Kansas | 20173 | 67400 | 847 |
1674792 | 1674792 | 2021-09-01 | Caddo | Louisiana | 22017 | 35761 | 847 |
1631680 | 1631680 | 2021-08-19 | Arapahoe | Colorado | 8005 | 67991 | 847 |
1628433 | 1628433 | 2021-08-18 | Arapahoe | Colorado | 8005 | 67991 | 847 |
1625186 | 1625186 | 2021-08-17 | Arapahoe | Colorado | 8005 | 67814 | 847 |
1626095 | 1626095 | 2021-08-17 | Orleans | Louisiana | 22071 | 40858 | 847 |
1621939 | 1621939 | 2021-08-16 | Arapahoe | Colorado | 8005 | 67613 | 847 |
1618692 | 1618692 | 2021-08-15 | Arapahoe | Colorado | 8005 | 67613 | 847 |
1607260 | 1607260 | 2021-08-11 | Somerset | New Jersey | 34035 | 31155 | 847 |
1604011 | 1604011 | 2021-08-10 | Somerset | New Jersey | 34035 | 31104 | 847 |
1563536 | 1563536 | 2021-07-29 | New Castle | Delaware | 10003 | 65806 | 847 |
1560288 | 1560288 | 2021-07-28 | New Castle | Delaware | 10003 | 65747 | 847 |
1557041 | 1557041 | 2021-07-27 | New Castle | Delaware | 10003 | 65710 | 847 |
1553794 | 1553794 | 2021-07-26 | New Castle | Delaware | 10003 | 65660 | 847 |
1550547 | 1550547 | 2021-07-25 | New Castle | Delaware | 10003 | 65613 | 847 |
1547300 | 1547300 | 2021-07-24 | New Castle | Delaware | 10003 | 65570 | 847 |
1544053 | 1544053 | 2021-07-23 | New Castle | Delaware | 10003 | 65530 | 847 |
1540805 | 1540805 | 2021-07-22 | New Castle | Delaware | 10003 | 65506 | 847 |
1537558 | 1537558 | 2021-07-21 | New Castle | Delaware | 10003 | 65467 | 847 |
1534310 | 1534310 | 2021-07-20 | New Castle | Delaware | 10003 | 65444 | 847 |
1536855 | 1536855 | 2021-07-20 | Webb | Texas | 48479 | 47609 | 847 |
1531063 | 1531063 | 2021-07-19 | New Castle | Delaware | 10003 | 65421 | 847 |
1533607 | 1533607 | 2021-07-19 | Webb | Texas | 48479 | 47609 | 847 |
1527816 | 1527816 | 2021-07-18 | New Castle | Delaware | 10003 | 65399 | 847 |
1530360 | 1530360 | 2021-07-18 | Webb | Texas | 48479 | 47609 | 847 |
1524569 | 1524569 | 2021-07-17 | New Castle | Delaware | 10003 | 65382 | 847 |
1527113 | 1527113 | 2021-07-17 | Webb | Texas | 48479 | 47609 | 847 |
1521321 | 1521321 | 2021-07-16 | New Castle | Delaware | 10003 | 65339 | 847 |
1523866 | 1523866 | 2021-07-16 | Webb | Texas | 48479 | 47609 | 847 |
1517803 | 1517803 | 2021-07-15 | Mobile | Alabama | 1097 | 43476 | 847 |
1518073 | 1518073 | 2021-07-15 | New Castle | Delaware | 10003 | 65320 | 847 |
1520618 | 1520618 | 2021-07-15 | Webb | Texas | 48479 | 47187 | 847 |
1514826 | 1514826 | 2021-07-14 | New Castle | Delaware | 10003 | 65301 | 847 |
1517370 | 1517370 | 2021-07-14 | Webb | Texas | 48479 | 47187 | 847 |
1511580 | 1511580 | 2021-07-13 | New Castle | Delaware | 10003 | 65263 | 847 |
1514123 | 1514123 | 2021-07-13 | Webb | Texas | 48479 | 47187 | 847 |
1508333 | 1508333 | 2021-07-12 | New Castle | Delaware | 10003 | 65251 | 847 |
1509151 | 1509151 | 2021-07-12 | East Baton Rouge | Louisiana | 22033 | 42012 | 847 |
1510877 | 1510877 | 2021-07-12 | Webb | Texas | 48479 | 47187 | 847 |
1505029 | 1505029 | 2021-07-11 | Denver | Colorado | 8031 | 74789 | 847 |
1505087 | 1505087 | 2021-07-11 | New Castle | Delaware | 10003 | 65240 | 847 |
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);