ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
138 rows where deaths = 808 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Colorado 18
- Alabama 15
- Pennsylvania 11
- California 9
- Louisiana 9
- Tennessee 9
- Texas 8
- Florida 7
- Oklahoma 7
- Rhode Island 7
- Georgia 5
- North Carolina 4
- Kentucky 3
- New York 3
- South Carolina 3
- Delaware 2
- Illinois 2
- Indiana 2
- Maryland 2
- Michigan 2
- Minnesota 2
- New Jersey 2
- Washington 2
- Arizona 1
- Arkansas 1
- District of Columbia 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449635 | 2449635 | 2022-04-27 | Cleveland | Oklahoma | 40027 | 79275 | 808 |
2446378 | 2446378 | 2022-04-26 | Cleveland | Oklahoma | 40027 | 79275 | 808 |
2443123 | 2443123 | 2022-04-25 | Cleveland | Oklahoma | 40027 | 79275 | 808 |
2439867 | 2439867 | 2022-04-24 | Cleveland | Oklahoma | 40027 | 79275 | 808 |
2436611 | 2436611 | 2022-04-23 | Cleveland | Oklahoma | 40027 | 79275 | 808 |
2433355 | 2433355 | 2022-04-22 | Cleveland | Oklahoma | 40027 | 79275 | 808 |
2430099 | 2430099 | 2022-04-21 | Cleveland | Oklahoma | 40027 | 79275 | 808 |
2376336 | 2376336 | 2022-04-05 | Muscogee | Georgia | 13215 | 38146 | 808 |
2373084 | 2373084 | 2022-04-04 | Muscogee | Georgia | 13215 | 38143 | 808 |
2291724 | 2291724 | 2022-03-10 | Hall | Georgia | 13139 | 53436 | 808 |
2271248 | 2271248 | 2022-03-03 | Jefferson | Texas | 48245 | 44216 | 808 |
2266566 | 2266566 | 2022-03-02 | St. Clair | Michigan | 26147 | 40107 | 808 |
2242904 | 2242904 | 2022-02-23 | Chatham | Georgia | 13051 | 61317 | 808 |
2196317 | 2196317 | 2022-02-08 | Rutherford | Tennessee | 47149 | 90041 | 808 |
2193063 | 2193063 | 2022-02-07 | Rutherford | Tennessee | 47149 | 90041 | 808 |
2189809 | 2189809 | 2022-02-06 | Rutherford | Tennessee | 47149 | 90041 | 808 |
2186556 | 2186556 | 2022-02-05 | Rutherford | Tennessee | 47149 | 90041 | 808 |
2183304 | 2183304 | 2022-02-04 | Rutherford | Tennessee | 47149 | 90041 | 808 |
2180052 | 2180052 | 2022-02-03 | Rutherford | Tennessee | 47149 | 90041 | 808 |
2176801 | 2176801 | 2022-02-02 | Rutherford | Tennessee | 47149 | 90041 | 808 |
2167733 | 2167733 | 2022-01-31 | Madison | Alabama | 1089 | 82478 | 808 |
2164478 | 2164478 | 2022-01-30 | Madison | Alabama | 1089 | 82168 | 808 |
2161223 | 2161223 | 2022-01-29 | Madison | Alabama | 1089 | 81622 | 808 |
2157973 | 2157973 | 2022-01-28 | Montgomery | Alabama | 1101 | 48723 | 808 |
2154720 | 2154720 | 2022-01-27 | Montgomery | Alabama | 1101 | 48723 | 808 |
2151467 | 2151467 | 2022-01-26 | Montgomery | Alabama | 1101 | 48723 | 808 |
2148215 | 2148215 | 2022-01-25 | Montgomery | Alabama | 1101 | 48723 | 808 |
2144963 | 2144963 | 2022-01-24 | Montgomery | Alabama | 1101 | 48723 | 808 |
2141708 | 2141708 | 2022-01-23 | Montgomery | Alabama | 1101 | 48533 | 808 |
2138452 | 2138452 | 2022-01-22 | Montgomery | Alabama | 1101 | 48337 | 808 |
2135197 | 2135197 | 2022-01-21 | Montgomery | Alabama | 1101 | 47998 | 808 |
2131945 | 2131945 | 2022-01-20 | Montgomery | Alabama | 1101 | 47558 | 808 |
2128691 | 2128691 | 2022-01-19 | Montgomery | Alabama | 1101 | 47132 | 808 |
2106299 | 2106299 | 2022-01-12 | Clayton | Georgia | 13063 | 53183 | 808 |
2078501 | 2078501 | 2022-01-03 | Rockland | New York | 36087 | 69935 | 808 |
2030284 | 2030284 | 2021-12-19 | Anderson | South Carolina | 45007 | 38610 | 808 |
2027033 | 2027033 | 2021-12-18 | Anderson | South Carolina | 45007 | 38610 | 808 |
2023782 | 2023782 | 2021-12-17 | Anderson | South Carolina | 45007 | 38610 | 808 |
2010150 | 2010150 | 2021-12-13 | Atlantic | New Jersey | 34001 | 43029 | 808 |
1991944 | 1991944 | 2021-12-07 | Snohomish | Washington | 53061 | 73617 | 808 |
1988693 | 1988693 | 2021-12-06 | Snohomish | Washington | 53061 | 73370 | 808 |
1954977 | 1954977 | 2021-11-26 | Onondaga | New York | 36067 | 58795 | 808 |
1951726 | 1951726 | 2021-11-25 | Onondaga | New York | 36067 | 58601 | 808 |
1929406 | 1929406 | 2021-11-18 | Northampton | Pennsylvania | 42095 | 46886 | 808 |
1832254 | 1832254 | 2021-10-19 | Brazoria | Texas | 48039 | 59168 | 808 |
1747711 | 1747711 | 2021-09-23 | Knox | Tennessee | 47093 | 73018 | 808 |
1711395 | 1711395 | 2021-09-12 | Wake | North Carolina | 37183 | 116764 | 808 |
1708148 | 1708148 | 2021-09-11 | Wake | North Carolina | 37183 | 116764 | 808 |
1704901 | 1704901 | 2021-09-10 | Wake | North Carolina | 37183 | 116764 | 808 |
1673832 | 1673832 | 2021-09-01 | Pulaski | Arkansas | 5119 | 54257 | 808 |
1634118 | 1634118 | 2021-08-19 | Denton | Texas | 48121 | 85457 | 808 |
1602305 | 1602305 | 2021-08-10 | Mohave | Arizona | 4015 | 26265 | 808 |
1557878 | 1557878 | 2021-07-27 | Orleans | Louisiana | 22071 | 34116 | 808 |
1554631 | 1554631 | 2021-07-26 | Orleans | Louisiana | 22071 | 33827 | 808 |
1551384 | 1551384 | 2021-07-25 | Orleans | Louisiana | 22071 | 33139 | 808 |
1548137 | 1548137 | 2021-07-24 | Orleans | Louisiana | 22071 | 33139 | 808 |
1544890 | 1544890 | 2021-07-23 | Orleans | Louisiana | 22071 | 33139 | 808 |
1541642 | 1541642 | 2021-07-22 | Orleans | Louisiana | 22071 | 32864 | 808 |
1538395 | 1538395 | 2021-07-21 | Orleans | Louisiana | 22071 | 32604 | 808 |
1535147 | 1535147 | 2021-07-20 | Orleans | Louisiana | 22071 | 32367 | 808 |
1531900 | 1531900 | 2021-07-19 | Orleans | Louisiana | 22071 | 32264 | 808 |
1514782 | 1514782 | 2021-07-14 | Jefferson | Colorado | 8059 | 49323 | 808 |
1410831 | 1410831 | 2021-06-12 | Contra Costa | California | 6013 | 70276 | 808 |
1404394 | 1404394 | 2021-06-10 | Arapahoe | Colorado | 8005 | 63246 | 808 |
1401149 | 1401149 | 2021-06-09 | Arapahoe | Colorado | 8005 | 63187 | 808 |
1397904 | 1397904 | 2021-06-08 | Arapahoe | Colorado | 8005 | 63121 | 808 |
1394657 | 1394657 | 2021-06-07 | Arapahoe | Colorado | 8005 | 63080 | 808 |
1391412 | 1391412 | 2021-06-06 | Arapahoe | Colorado | 8005 | 63047 | 808 |
1388167 | 1388167 | 2021-06-05 | Arapahoe | Colorado | 8005 | 62993 | 808 |
1384922 | 1384922 | 2021-06-04 | Arapahoe | Colorado | 8005 | 62934 | 808 |
1381676 | 1381676 | 2021-06-03 | Arapahoe | Colorado | 8005 | 62869 | 808 |
1378431 | 1378431 | 2021-06-02 | Arapahoe | Colorado | 8005 | 62780 | 808 |
1375185 | 1375185 | 2021-06-01 | Arapahoe | Colorado | 8005 | 62757 | 808 |
1371940 | 1371940 | 2021-05-31 | Arapahoe | Colorado | 8005 | 62720 | 808 |
1368695 | 1368695 | 2021-05-30 | Arapahoe | Colorado | 8005 | 62691 | 808 |
1357792 | 1357792 | 2021-05-26 | York | Pennsylvania | 42133 | 46182 | 808 |
1354519 | 1354519 | 2021-05-25 | Luzerne | Pennsylvania | 42079 | 31671 | 808 |
1336174 | 1336174 | 2021-05-20 | Contra Costa | California | 6013 | 69197 | 808 |
1332927 | 1332927 | 2021-05-19 | Contra Costa | California | 6013 | 69120 | 808 |
1316549 | 1316549 | 2021-05-14 | Mobile | Alabama | 1097 | 41177 | 808 |
1313303 | 1313303 | 2021-05-13 | Mobile | Alabama | 1097 | 41089 | 808 |
1310394 | 1310394 | 2021-05-12 | Volusia | Florida | 12127 | 43710 | 808 |
1307148 | 1307148 | 2021-05-11 | Volusia | Florida | 12127 | 43615 | 808 |
1309561 | 1309561 | 2021-05-11 | Nueces | Texas | 48355 | 39014 | 808 |
1303776 | 1303776 | 2021-05-10 | Denver | Colorado | 8031 | 71672 | 808 |
1306315 | 1306315 | 2021-05-10 | Nueces | Texas | 48355 | 38963 | 808 |
1300529 | 1300529 | 2021-05-09 | Denver | Colorado | 8031 | 71613 | 808 |
1297282 | 1297282 | 2021-05-08 | Denver | Colorado | 8031 | 71512 | 808 |
1294036 | 1294036 | 2021-05-07 | Denver | Colorado | 8031 | 71357 | 808 |
1290790 | 1290790 | 2021-05-06 | Denver | Colorado | 8031 | 71211 | 808 |
1271368 | 1271368 | 2021-04-30 | New Castle | Delaware | 10003 | 61647 | 808 |
1268121 | 1268121 | 2021-04-29 | New Castle | Delaware | 10003 | 61447 | 808 |
1245718 | 1245718 | 2021-04-22 | Kane | Illinois | 17089 | 56108 | 808 |
1242204 | 1242204 | 2021-04-21 | Sarasota | Florida | 12115 | 31673 | 808 |
1238957 | 1238957 | 2021-04-20 | Sarasota | Florida | 12115 | 31567 | 808 |
1225007 | 1225007 | 2021-04-15 | Collin | Texas | 48085 | 88074 | 808 |
1221760 | 1221760 | 2021-04-14 | Collin | Texas | 48085 | 88017 | 808 |
1217113 | 1217113 | 2021-04-13 | Genesee | Michigan | 26049 | 34852 | 808 |
1192162 | 1192162 | 2021-04-05 | Lehigh | Pennsylvania | 42077 | 34821 | 808 |
1188913 | 1188913 | 2021-04-04 | Lehigh | Pennsylvania | 42077 | 34706 | 808 |
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);