ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
141 rows where deaths = 768 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Pennsylvania 12
- Georgia 11
- Michigan 9
- California 8
- Florida 8
- Colorado 7
- Louisiana 7
- New Jersey 7
- New York 7
- Washington 7
- Maryland 6
- South Carolina 6
- Kansas 5
- Ohio 5
- Indiana 4
- Missouri 4
- Nebraska 4
- New Mexico 4
- Massachusetts 3
- North Carolina 3
- Texas 3
- Alabama 2
- Arizona 2
- Illinois 2
- District of Columbia 1
- Idaho 1
- Minnesota 1
- Puerto Rico 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2485112 | 2485112 | 2022-05-08 | Doña Ana | New Mexico | 35013 | 63755 | 768 |
2481854 | 2481854 | 2022-05-07 | Doña Ana | New Mexico | 35013 | 63755 | 768 |
2478596 | 2478596 | 2022-05-06 | Doña Ana | New Mexico | 35013 | 63755 | 768 |
2426978 | 2426978 | 2022-04-20 | Lackawanna | Pennsylvania | 42069 | 43814 | 768 |
2423722 | 2423722 | 2022-04-19 | Lackawanna | Pennsylvania | 42069 | 43779 | 768 |
2375902 | 2375902 | 2022-04-05 | Tuscaloosa | Alabama | 1125 | 55917 | 768 |
2372650 | 2372650 | 2022-04-04 | Tuscaloosa | Alabama | 1125 | 55858 | 768 |
2356722 | 2356722 | 2022-03-30 | Bibb | Georgia | 13021 | 37039 | 768 |
2353469 | 2353469 | 2022-03-29 | Bibb | Georgia | 13021 | 37026 | 768 |
2350217 | 2350217 | 2022-03-28 | Bibb | Georgia | 13021 | 37018 | 768 |
2346964 | 2346964 | 2022-03-27 | Bibb | Georgia | 13021 | 37010 | 768 |
2349665 | 2349665 | 2022-03-27 | Yakima | Washington | 53077 | 73269 | 768 |
2343711 | 2343711 | 2022-03-26 | Bibb | Georgia | 13021 | 37010 | 768 |
2346412 | 2346412 | 2022-03-26 | Yakima | Washington | 53077 | 73269 | 768 |
2340458 | 2340458 | 2022-03-25 | Bibb | Georgia | 13021 | 37010 | 768 |
2343159 | 2343159 | 2022-03-25 | Yakima | Washington | 53077 | 73269 | 768 |
2329951 | 2329951 | 2022-03-21 | Utah | Utah | 49049 | 201323 | 768 |
2294333 | 2294333 | 2022-03-10 | Clark | Washington | 53011 | 85592 | 768 |
2291081 | 2291081 | 2022-03-09 | Clark | Washington | 53011 | 85592 | 768 |
2285258 | 2285258 | 2022-03-08 | Muscogee | Georgia | 13215 | 37788 | 768 |
2280197 | 2280197 | 2022-03-06 | Forsyth | North Carolina | 37067 | 91426 | 768 |
2276944 | 2276944 | 2022-03-05 | Forsyth | North Carolina | 37067 | 91426 | 768 |
2273691 | 2273691 | 2022-03-04 | Forsyth | North Carolina | 37067 | 91426 | 768 |
2256806 | 2256806 | 2022-02-27 | Ottawa | Michigan | 26139 | 73937 | 768 |
2253555 | 2253555 | 2022-02-26 | Ottawa | Michigan | 26139 | 73937 | 768 |
2250304 | 2250304 | 2022-02-25 | Ottawa | Michigan | 26139 | 73937 | 768 |
2247053 | 2247053 | 2022-02-24 | Ottawa | Michigan | 26139 | 73808 | 768 |
2243802 | 2243802 | 2022-02-23 | Ottawa | Michigan | 26139 | 73808 | 768 |
2240567 | 2240567 | 2022-02-22 | Anoka | Minnesota | 27003 | 96997 | 768 |
2237865 | 2237865 | 2022-02-21 | Oneida | New York | 36065 | 51864 | 768 |
2223442 | 2223442 | 2022-02-17 | Hall | Georgia | 13139 | 53024 | 768 |
2173392 | 2173392 | 2022-02-01 | Lexington | South Carolina | 45063 | 90035 | 768 |
2170140 | 2170140 | 2022-01-31 | Lexington | South Carolina | 45063 | 89719 | 768 |
2152590 | 2152590 | 2022-01-26 | St. Tammany | Louisiana | 22103 | 67414 | 768 |
2148868 | 2148868 | 2022-01-25 | Winnebago | Illinois | 17201 | 71089 | 768 |
2147553 | 2147553 | 2022-01-24 | Bell | Texas | 48027 | 57604 | 768 |
2119662 | 2119662 | 2022-01-16 | St. Joseph | Indiana | 18141 | 62011 | 768 |
2116410 | 2116410 | 2022-01-15 | St. Joseph | Indiana | 18141 | 62011 | 768 |
2113159 | 2113159 | 2022-01-14 | St. Joseph | Indiana | 18141 | 62011 | 768 |
2103138 | 2103138 | 2022-01-11 | Richmond | Georgia | 13245 | 41921 | 768 |
2056647 | 2056647 | 2021-12-27 | McLennan | Texas | 48309 | 44237 | 768 |
2016659 | 2016659 | 2021-12-15 | Gloucester | New Jersey | 34015 | 43690 | 768 |
1959799 | 1959799 | 2021-11-28 | Imperial | California | 6025 | 38128 | 768 |
1956548 | 1956548 | 2021-11-27 | Imperial | California | 6025 | 38128 | 768 |
1953297 | 1953297 | 2021-11-26 | Imperial | California | 6025 | 38128 | 768 |
1950046 | 1950046 | 2021-11-25 | Imperial | California | 6025 | 38128 | 768 |
1946795 | 1946795 | 2021-11-24 | Imperial | California | 6025 | 38128 | 768 |
1897687 | 1897687 | 2021-11-08 | Snohomish | Washington | 53061 | 67587 | 768 |
1893803 | 1893803 | 2021-11-07 | Richland | South Carolina | 45079 | 69303 | 768 |
1890553 | 1890553 | 2021-11-06 | Richland | South Carolina | 45079 | 69303 | 768 |
1887303 | 1887303 | 2021-11-05 | Richland | South Carolina | 45079 | 69303 | 768 |
1876304 | 1876304 | 2021-11-02 | Anne Arundel | Maryland | 24003 | 53261 | 768 |
1856163 | 1856163 | 2021-10-27 | Ada | Idaho | 16001 | 80452 | 768 |
1854235 | 1854235 | 2021-10-26 | Onondaga | New York | 36067 | 52686 | 768 |
1850900 | 1850900 | 2021-10-25 | Atlantic | New Jersey | 34001 | 39326 | 768 |
1847650 | 1847650 | 2021-10-24 | Atlantic | New Jersey | 34001 | 39286 | 768 |
1844400 | 1844400 | 2021-10-23 | Atlantic | New Jersey | 34001 | 39250 | 768 |
1828242 | 1828242 | 2021-10-18 | Orange | New York | 36071 | 57285 | 768 |
1824993 | 1824993 | 2021-10-17 | Orange | New York | 36071 | 57207 | 768 |
1805930 | 1805930 | 2021-10-11 | Northampton | Pennsylvania | 42095 | 43156 | 768 |
1802680 | 1802680 | 2021-10-10 | Northampton | Pennsylvania | 42095 | 43098 | 768 |
1799431 | 1799431 | 2021-10-09 | Northampton | Pennsylvania | 42095 | 43050 | 768 |
1796182 | 1796182 | 2021-10-08 | Northampton | Pennsylvania | 42095 | 42961 | 768 |
1740187 | 1740187 | 2021-09-21 | Kansas City | Missouri | 60066 | 768 | |
1740524 | 1740524 | 2021-09-21 | Rockland | New York | 36087 | 50818 | 768 |
1737275 | 1737275 | 2021-09-20 | Rockland | New York | 36087 | 50716 | 768 |
1733836 | 1733836 | 2021-09-19 | Douglas | Nebraska | 31055 | 81354 | 768 |
1734025 | 1734025 | 2021-09-19 | Rockland | New York | 36087 | 50600 | 768 |
1730586 | 1730586 | 2021-09-18 | Douglas | Nebraska | 31055 | 81354 | 768 |
1727336 | 1727336 | 2021-09-17 | Douglas | Nebraska | 31055 | 81354 | 768 |
1724087 | 1724087 | 2021-09-16 | Douglas | Nebraska | 31055 | 80846 | 768 |
1716598 | 1716598 | 2021-09-14 | Allen | Indiana | 18003 | 52117 | 768 |
1566710 | 1566710 | 2021-07-30 | Adams | Colorado | 8001 | 63507 | 768 |
1563462 | 1563462 | 2021-07-29 | Adams | Colorado | 8001 | 63507 | 768 |
1541615 | 1541615 | 2021-07-22 | Caddo | Louisiana | 22017 | 28122 | 768 |
1538368 | 1538368 | 2021-07-21 | Caddo | Louisiana | 22017 | 28035 | 768 |
1535120 | 1535120 | 2021-07-20 | Caddo | Louisiana | 22017 | 27930 | 768 |
1531873 | 1531873 | 2021-07-19 | Caddo | Louisiana | 22017 | 27852 | 768 |
1521106 | 1521106 | 2021-07-16 | Mohave | Arizona | 4015 | 24517 | 768 |
1517858 | 1517858 | 2021-07-15 | Mohave | Arizona | 4015 | 24471 | 768 |
1421315 | 1421315 | 2021-06-15 | Johnson | Kansas | 20091 | 59450 | 768 |
1418070 | 1418070 | 2021-06-14 | Johnson | Kansas | 20091 | 59450 | 768 |
1403585 | 1403585 | 2021-06-09 | Denton | Texas | 48121 | 76434 | 768 |
1392147 | 1392147 | 2021-06-06 | Sedgwick | Kansas | 20173 | 57417 | 768 |
1388902 | 1388902 | 2021-06-05 | Sedgwick | Kansas | 20173 | 57417 | 768 |
1385657 | 1385657 | 2021-06-04 | Sedgwick | Kansas | 20173 | 57417 | 768 |
1323367 | 1323367 | 2021-05-16 | Pasco | Florida | 12101 | 42109 | 768 |
1320121 | 1320121 | 2021-05-15 | Pasco | Florida | 12101 | 42063 | 768 |
1316776 | 1316776 | 2021-05-14 | Jefferson | Colorado | 8059 | 46989 | 768 |
1316874 | 1316874 | 2021-05-14 | Pasco | Florida | 12101 | 41998 | 768 |
1313627 | 1313627 | 2021-05-13 | Pasco | Florida | 12101 | 41921 | 768 |
1307134 | 1307134 | 2021-05-11 | Pasco | Florida | 12101 | 41776 | 768 |
1247181 | 1247181 | 2021-04-22 | Lucas | Ohio | 39095 | 40667 | 768 |
1243934 | 1243934 | 2021-04-21 | Lucas | Ohio | 39095 | 40568 | 768 |
1238966 | 1238966 | 2021-04-20 | Volusia | Florida | 12127 | 41500 | 768 |
1240687 | 1240687 | 2021-04-20 | Lucas | Ohio | 39095 | 40405 | 768 |
1240857 | 1240857 | 2021-04-20 | Chester | Pennsylvania | 42029 | 37749 | 768 |
1219358 | 1219358 | 2021-04-14 | El Paso | Colorado | 8041 | 59786 | 768 |
1202063 | 1202063 | 2021-04-08 | Spartanburg | South Carolina | 45083 | 39590 | 768 |
1145664 | 1145664 | 2021-03-22 | Genesee | Michigan | 26049 | 28035 | 768 |
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);