ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
147 rows where deaths = 681 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Texas 18
- Illinois 16
- New York 14
- Pennsylvania 14
- Nevada 13
- California 8
- Delaware 8
- Washington 8
- Colorado 7
- Florida 6
- Indiana 5
- Massachusetts 4
- Tennessee 4
- Arkansas 3
- Maryland 3
- Georgia 2
- Michigan 2
- Virginia 2
- Alabama 1
- Arizona 1
- Louisiana 1
- Minnesota 1
- Missouri 1
- New Jersey 1
- Oklahoma 1
- Oregon 1
- Puerto Rico 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499576 | 2499576 | 2022-05-13 | Baldwin | Alabama | 1003 | 55862 | 681 |
2398093 | 2398093 | 2022-04-11 | Gregg | Texas | 48183 | 23173 | 681 |
2394838 | 2394838 | 2022-04-10 | Gregg | Texas | 48183 | 23172 | 681 |
2391582 | 2391582 | 2022-04-09 | Gregg | Texas | 48183 | 23172 | 681 |
2388326 | 2388326 | 2022-04-08 | Gregg | Texas | 48183 | 23171 | 681 |
2385071 | 2385071 | 2022-04-07 | Gregg | Texas | 48183 | 23169 | 681 |
2381816 | 2381816 | 2022-04-06 | Gregg | Texas | 48183 | 23164 | 681 |
2313033 | 2313033 | 2022-03-16 | Marion | Oregon | 41047 | 68525 | 681 |
2271313 | 2271313 | 2022-03-03 | Potter | Texas | 48375 | 35243 | 681 |
2262302 | 2262302 | 2022-03-01 | Weld | Colorado | 8123 | 80682 | 681 |
2222579 | 2222579 | 2022-02-16 | Taylor | Texas | 48441 | 33052 | 681 |
2195989 | 2195989 | 2022-02-08 | Cambria | Pennsylvania | 42021 | 33438 | 681 |
2183000 | 2183000 | 2022-02-04 | Lackawanna | Pennsylvania | 42069 | 41239 | 681 |
2169981 | 2169981 | 2022-01-31 | Erie | Pennsylvania | 42049 | 54571 | 681 |
2166727 | 2166727 | 2022-01-30 | Erie | Pennsylvania | 42049 | 54449 | 681 |
2167505 | 2167505 | 2022-01-30 | Clark | Washington | 53011 | 73773 | 681 |
2163472 | 2163472 | 2022-01-29 | Erie | Pennsylvania | 42049 | 54282 | 681 |
2164250 | 2164250 | 2022-01-29 | Clark | Washington | 53011 | 73773 | 681 |
2160995 | 2160995 | 2022-01-28 | Clark | Washington | 53011 | 73773 | 681 |
2086690 | 2086690 | 2022-01-06 | Sussex | Delaware | 10005 | 46508 | 681 |
2083438 | 2083438 | 2022-01-05 | Sussex | Delaware | 10005 | 46085 | 681 |
2080186 | 2080186 | 2022-01-04 | Sussex | Delaware | 10005 | 45857 | 681 |
2076934 | 2076934 | 2022-01-03 | Sussex | Delaware | 10005 | 45253 | 681 |
2077934 | 2077934 | 2022-01-03 | St. Clair | Michigan | 26147 | 31613 | 681 |
2073683 | 2073683 | 2022-01-02 | Sussex | Delaware | 10005 | 44896 | 681 |
2074051 | 2074051 | 2022-01-02 | St. Clair | Illinois | 17163 | 48021 | 681 |
2070432 | 2070432 | 2022-01-01 | Sussex | Delaware | 10005 | 44129 | 681 |
2070800 | 2070800 | 2022-01-01 | St. Clair | Illinois | 17163 | 48021 | 681 |
2067181 | 2067181 | 2021-12-31 | Sussex | Delaware | 10005 | 43548 | 681 |
2067549 | 2067549 | 2021-12-31 | St. Clair | Illinois | 17163 | 48021 | 681 |
2063930 | 2063930 | 2021-12-30 | Sussex | Delaware | 10005 | 42695 | 681 |
2064298 | 2064298 | 2021-12-30 | St. Clair | Illinois | 17163 | 48021 | 681 |
2061048 | 2061048 | 2021-12-29 | St. Clair | Illinois | 17163 | 47313 | 681 |
2057225 | 2057225 | 2021-12-28 | Benton | Arkansas | 5007 | 45935 | 681 |
2054565 | 2054565 | 2021-12-27 | Winnebago | Illinois | 17201 | 53019 | 681 |
2037837 | 2037837 | 2021-12-22 | San Francisco | California | 6075 | 59886 | 681 |
2034587 | 2034587 | 2021-12-21 | San Francisco | California | 6075 | 59597 | 681 |
2031337 | 2031337 | 2021-12-20 | San Francisco | California | 6075 | 59294 | 681 |
2032991 | 2032991 | 2021-12-20 | Oneida | New York | 36065 | 36719 | 681 |
2013895 | 2013895 | 2021-12-14 | Cumberland | Pennsylvania | 42041 | 33647 | 681 |
2005884 | 2005884 | 2021-12-12 | St. Joseph | Indiana | 18141 | 51518 | 681 |
2002633 | 2002633 | 2021-12-11 | St. Joseph | Indiana | 18141 | 51518 | 681 |
1999383 | 1999383 | 2021-12-10 | St. Joseph | Indiana | 18141 | 51518 | 681 |
1968665 | 1968665 | 2021-11-30 | Hamilton | Tennessee | 47065 | 65533 | 681 |
1918002 | 1918002 | 2021-11-15 | Madison | Illinois | 17119 | 41417 | 681 |
1914752 | 1914752 | 2021-11-14 | Madison | Illinois | 17119 | 41248 | 681 |
1911502 | 1911502 | 2021-11-13 | Madison | Illinois | 17119 | 41248 | 681 |
1908253 | 1908253 | 2021-11-12 | Madison | Illinois | 17119 | 41248 | 681 |
1905004 | 1905004 | 2021-11-11 | Madison | Illinois | 17119 | 41149 | 681 |
1901754 | 1901754 | 2021-11-10 | Madison | Illinois | 17119 | 41149 | 681 |
1898504 | 1898504 | 2021-11-09 | Madison | Illinois | 17119 | 41047 | 681 |
1895254 | 1895254 | 2021-11-08 | Madison | Illinois | 17119 | 41012 | 681 |
1849522 | 1849522 | 2021-10-25 | Chatham | Georgia | 13051 | 38479 | 681 |
1813787 | 1813787 | 2021-10-14 | Clayton | Georgia | 13063 | 38789 | 681 |
1767612 | 1767612 | 2021-09-29 | Henrico | Virginia | 51087 | 32493 | 681 |
1764363 | 1764363 | 2021-09-28 | Henrico | Virginia | 51087 | 32411 | 681 |
1741727 | 1741727 | 2021-09-21 | Snohomish | Washington | 53061 | 56765 | 681 |
1718536 | 1718536 | 2021-09-14 | Brazoria | Texas | 48039 | 53648 | 681 |
1658628 | 1658628 | 2021-08-27 | Anne Arundel | Maryland | 24003 | 46843 | 681 |
1658973 | 1658973 | 2021-08-27 | Kansas City | Missouri | 55998 | 681 | |
1653502 | 1653502 | 2021-08-25 | Knox | Tennessee | 47093 | 58797 | 681 |
1650255 | 1650255 | 2021-08-24 | Knox | Tennessee | 47093 | 58797 | 681 |
1644269 | 1644269 | 2021-08-22 | Pierce | Washington | 53053 | 66921 | 681 |
1639810 | 1639810 | 2021-08-21 | Onondaga | New York | 36067 | 41256 | 681 |
1641019 | 1641019 | 2021-08-21 | Pierce | Washington | 53053 | 66921 | 681 |
1636560 | 1636560 | 2021-08-20 | Onondaga | New York | 36067 | 41119 | 681 |
1637769 | 1637769 | 2021-08-20 | Pierce | Washington | 53053 | 66921 | 681 |
1633310 | 1633310 | 2021-08-19 | Onondaga | New York | 36067 | 41016 | 681 |
1634519 | 1634519 | 2021-08-19 | Pierce | Washington | 53053 | 66511 | 681 |
1630063 | 1630063 | 2021-08-18 | Onondaga | New York | 36067 | 40912 | 681 |
1626816 | 1626816 | 2021-08-17 | Onondaga | New York | 36067 | 40807 | 681 |
1623569 | 1623569 | 2021-08-16 | Onondaga | New York | 36067 | 40711 | 681 |
1620322 | 1620322 | 2021-08-15 | Onondaga | New York | 36067 | 40621 | 681 |
1617074 | 1617074 | 2021-08-14 | Onondaga | New York | 36067 | 40520 | 681 |
1613826 | 1613826 | 2021-08-13 | Onondaga | New York | 36067 | 40404 | 681 |
1610577 | 1610577 | 2021-08-12 | Onondaga | New York | 36067 | 40301 | 681 |
1607329 | 1607329 | 2021-08-11 | Onondaga | New York | 36067 | 40200 | 681 |
1491952 | 1491952 | 2021-07-07 | Pulaski | Arkansas | 5119 | 41846 | 681 |
1488705 | 1488705 | 2021-07-06 | Pulaski | Arkansas | 5119 | 41703 | 681 |
1444874 | 1444874 | 2021-06-22 | Washoe | Nevada | 32031 | 46167 | 681 |
1441629 | 1441629 | 2021-06-21 | Washoe | Nevada | 32031 | 46166 | 681 |
1392942 | 1392942 | 2021-06-06 | Washoe | Nevada | 32031 | 45930 | 681 |
1389697 | 1389697 | 2021-06-05 | Washoe | Nevada | 32031 | 45930 | 681 |
1386452 | 1386452 | 2021-06-04 | Washoe | Nevada | 32031 | 45930 | 681 |
1383207 | 1383207 | 2021-06-03 | Washoe | Nevada | 32031 | 45906 | 681 |
1379961 | 1379961 | 2021-06-02 | Washoe | Nevada | 32031 | 45902 | 681 |
1376716 | 1376716 | 2021-06-01 | Washoe | Nevada | 32031 | 45894 | 681 |
1373470 | 1373470 | 2021-05-31 | Washoe | Nevada | 32031 | 45855 | 681 |
1374393 | 1374393 | 2021-05-31 | Fort Bend | Texas | 48157 | 68725 | 681 |
1370225 | 1370225 | 2021-05-30 | Washoe | Nevada | 32031 | 45855 | 681 |
1371148 | 1371148 | 2021-05-30 | Fort Bend | Texas | 48157 | 68725 | 681 |
1366979 | 1366979 | 2021-05-29 | Washoe | Nevada | 32031 | 45855 | 681 |
1367902 | 1367902 | 2021-05-29 | Fort Bend | Texas | 48157 | 68725 | 681 |
1363733 | 1363733 | 2021-05-28 | Washoe | Nevada | 32031 | 45855 | 681 |
1360487 | 1360487 | 2021-05-27 | Washoe | Nevada | 32031 | 45841 | 681 |
1323356 | 1323356 | 2021-05-16 | Manatee | Florida | 12081 | 39312 | 681 |
1198668 | 1198668 | 2021-04-07 | Northampton | Pennsylvania | 42095 | 31540 | 681 |
1195419 | 1195419 | 2021-04-06 | Northampton | Pennsylvania | 42095 | 31389 | 681 |
1192171 | 1192171 | 2021-04-05 | Northampton | Pennsylvania | 42095 | 31225 | 681 |
1188922 | 1188922 | 2021-04-04 | Northampton | Pennsylvania | 42095 | 31125 | 681 |
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);