ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124 rows where deaths = 777 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Colorado 15
- Florida 13
- Pennsylvania 13
- Texas 12
- Georgia 10
- New York 10
- Michigan 9
- California 7
- Louisiana 4
- Massachusetts 4
- Washington 4
- Idaho 3
- Nevada 3
- New Jersey 3
- South Carolina 3
- Alabama 2
- Arizona 2
- Missouri 2
- Illinois 1
- Maryland 1
- North Carolina 1
- Tennessee 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2424968 | 2424968 | 2022-04-20 | Pueblo | Colorado | 8101 | 46665 | 777 |
2421712 | 2421712 | 2022-04-19 | Pueblo | Colorado | 8101 | 46616 | 777 |
2418456 | 2418456 | 2022-04-18 | Pueblo | Colorado | 8101 | 46562 | 777 |
2408241 | 2408241 | 2022-04-14 | Yakima | Washington | 53077 | 73395 | 777 |
2402282 | 2402282 | 2022-04-13 | Bibb | Georgia | 13021 | 37146 | 777 |
2404985 | 2404985 | 2022-04-13 | Yakima | Washington | 53077 | 73382 | 777 |
2392516 | 2392516 | 2022-04-10 | Bibb | Georgia | 13021 | 37117 | 777 |
2389260 | 2389260 | 2022-04-09 | Bibb | Georgia | 13021 | 37117 | 777 |
2386005 | 2386005 | 2022-04-08 | Bibb | Georgia | 13021 | 37117 | 777 |
2308837 | 2308837 | 2022-03-15 | Ottawa | Michigan | 26139 | 74298 | 777 |
2304769 | 2304769 | 2022-03-14 | Muscogee | Georgia | 13215 | 37847 | 777 |
2305586 | 2305586 | 2022-03-14 | Ottawa | Michigan | 26139 | 74298 | 777 |
2301517 | 2301517 | 2022-03-13 | Muscogee | Georgia | 13215 | 37826 | 777 |
2302334 | 2302334 | 2022-03-13 | Ottawa | Michigan | 26139 | 74269 | 777 |
2298265 | 2298265 | 2022-03-12 | Muscogee | Georgia | 13215 | 37826 | 777 |
2299082 | 2299082 | 2022-03-12 | Ottawa | Michigan | 26139 | 74269 | 777 |
2295013 | 2295013 | 2022-03-11 | Muscogee | Georgia | 13215 | 37826 | 777 |
2295830 | 2295830 | 2022-03-11 | Ottawa | Michigan | 26139 | 74269 | 777 |
2276883 | 2276883 | 2022-03-05 | Oneida | New York | 36065 | 52286 | 777 |
2273630 | 2273630 | 2022-03-04 | Oneida | New York | 36065 | 52230 | 777 |
2270377 | 2270377 | 2022-03-03 | Oneida | New York | 36065 | 52230 | 777 |
2267125 | 2267125 | 2022-03-02 | Oneida | New York | 36065 | 52197 | 777 |
2242699 | 2242699 | 2022-02-23 | Merced | California | 6047 | 70485 | 777 |
2199715 | 2199715 | 2022-02-09 | Jefferson | Texas | 48245 | 42150 | 777 |
2179897 | 2179897 | 2022-02-03 | Lexington | South Carolina | 45063 | 90810 | 777 |
2175368 | 2175368 | 2022-02-02 | St. Tammany | Louisiana | 22103 | 69464 | 777 |
2151928 | 2151928 | 2022-01-26 | Richmond | Georgia | 13245 | 46637 | 777 |
2136744 | 2136744 | 2022-01-21 | St. Charles | Missouri | 29183 | 93724 | 777 |
2137435 | 2137435 | 2022-01-21 | Cumberland | Pennsylvania | 42041 | 45447 | 777 |
2134767 | 2134767 | 2022-01-20 | Williamson | Texas | 48491 | 110876 | 777 |
2095659 | 2095659 | 2022-01-08 | McLennan | Texas | 48309 | 47270 | 777 |
2045912 | 2045912 | 2021-12-24 | Gloucester | New Jersey | 34015 | 45980 | 777 |
1992302 | 1992302 | 2021-12-08 | Imperial | California | 6025 | 39228 | 777 |
1989051 | 1989051 | 2021-12-07 | Imperial | California | 6025 | 39179 | 777 |
1989273 | 1989273 | 2021-12-07 | Clayton | Georgia | 13063 | 40512 | 777 |
1985801 | 1985801 | 2021-12-06 | Imperial | California | 6025 | 39148 | 777 |
1943454 | 1943454 | 2021-11-23 | Yavapai | Arizona | 4025 | 31654 | 777 |
1926934 | 1926934 | 2021-11-17 | Snohomish | Washington | 53061 | 69926 | 777 |
1923050 | 1923050 | 2021-11-16 | Richland | South Carolina | 45079 | 69719 | 777 |
1923684 | 1923684 | 2021-11-16 | Snohomish | Washington | 53061 | 69356 | 777 |
1901146 | 1901146 | 2021-11-10 | Montgomery | Alabama | 1101 | 34307 | 777 |
1872408 | 1872408 | 2021-11-01 | Ada | Idaho | 16001 | 81515 | 777 |
1873729 | 1873729 | 2021-11-01 | Onondaga | New York | 36067 | 53813 | 777 |
1869159 | 1869159 | 2021-10-31 | Ada | Idaho | 16001 | 81282 | 777 |
1865910 | 1865910 | 2021-10-30 | Ada | Idaho | 16001 | 81230 | 777 |
1858441 | 1858441 | 2021-10-27 | Smith | Texas | 48423 | 36437 | 777 |
1854237 | 1854237 | 2021-10-26 | Orange | New York | 36071 | 57893 | 777 |
1846188 | 1846188 | 2021-10-24 | Citrus | Florida | 12017 | 20328 | 777 |
1842938 | 1842938 | 2021-10-23 | Citrus | Florida | 12017 | 20328 | 777 |
1839688 | 1839688 | 2021-10-22 | Citrus | Florida | 12017 | 20328 | 777 |
1836439 | 1836439 | 2021-10-21 | Citrus | Florida | 12017 | 20261 | 777 |
1833190 | 1833190 | 2021-10-20 | Citrus | Florida | 12017 | 20261 | 777 |
1829941 | 1829941 | 2021-10-19 | Citrus | Florida | 12017 | 20261 | 777 |
1826692 | 1826692 | 2021-10-18 | Citrus | Florida | 12017 | 20261 | 777 |
1818501 | 1818501 | 2021-10-15 | Rockland | New York | 36087 | 52711 | 777 |
1815252 | 1815252 | 2021-10-14 | Rockland | New York | 36087 | 52635 | 777 |
1812004 | 1812004 | 2021-10-13 | Rockland | New York | 36087 | 52558 | 777 |
1808755 | 1808755 | 2021-10-12 | Rockland | New York | 36087 | 52466 | 777 |
1790016 | 1790016 | 2021-10-06 | Brazoria | Texas | 48039 | 57795 | 777 |
1749935 | 1749935 | 2021-09-24 | Kansas City | Missouri | 60515 | 777 | |
1747578 | 1747578 | 2021-09-23 | Horry | South Carolina | 45051 | 58348 | 777 |
1724964 | 1724964 | 2021-09-16 | Knox | Tennessee | 47093 | 70308 | 777 |
1711178 | 1711178 | 2021-09-12 | Washoe | Nevada | 32031 | 57048 | 777 |
1707931 | 1707931 | 2021-09-11 | Washoe | Nevada | 32031 | 57048 | 777 |
1704684 | 1704684 | 2021-09-10 | Washoe | Nevada | 32031 | 57048 | 777 |
1643885 | 1643885 | 2021-08-22 | Fort Bend | Texas | 48157 | 80530 | 777 |
1640635 | 1640635 | 2021-08-21 | Fort Bend | Texas | 48157 | 80530 | 777 |
1637385 | 1637385 | 2021-08-20 | Fort Bend | Texas | 48157 | 80530 | 777 |
1625184 | 1625184 | 2021-08-17 | Adams | Colorado | 8001 | 65305 | 777 |
1621937 | 1621937 | 2021-08-16 | Adams | Colorado | 8001 | 65139 | 777 |
1618690 | 1618690 | 2021-08-15 | Adams | Colorado | 8001 | 65139 | 777 |
1587087 | 1587087 | 2021-08-05 | Caddo | Louisiana | 22017 | 30320 | 777 |
1583837 | 1583837 | 2021-08-04 | Caddo | Louisiana | 22017 | 30058 | 777 |
1471384 | 1471384 | 2021-06-30 | Westmoreland | Pennsylvania | 42129 | 34426 | 777 |
1471741 | 1471741 | 2021-06-30 | Denton | Texas | 48121 | 77057 | 777 |
1468139 | 1468139 | 2021-06-29 | Westmoreland | Pennsylvania | 42129 | 34417 | 777 |
1342751 | 1342751 | 2021-05-22 | Jefferson | Colorado | 8059 | 47571 | 777 |
1339503 | 1339503 | 2021-05-21 | Jefferson | Colorado | 8059 | 47504 | 777 |
1333107 | 1333107 | 2021-05-19 | Pasco | Florida | 12101 | 42268 | 777 |
1329860 | 1329860 | 2021-05-18 | Pasco | Florida | 12101 | 42203 | 777 |
1307008 | 1307008 | 2021-05-11 | Arapahoe | Colorado | 8005 | 60522 | 777 |
1303762 | 1303762 | 2021-05-10 | Arapahoe | Colorado | 8005 | 60339 | 777 |
1300515 | 1300515 | 2021-05-09 | Arapahoe | Colorado | 8005 | 60236 | 777 |
1283068 | 1283068 | 2021-05-03 | Chester | Pennsylvania | 42029 | 39343 | 777 |
1279821 | 1279821 | 2021-05-02 | Chester | Pennsylvania | 42029 | 39301 | 777 |
1276574 | 1276574 | 2021-05-01 | Chester | Pennsylvania | 42029 | 39226 | 777 |
1259344 | 1259344 | 2021-04-26 | Kent | Michigan | 26081 | 66888 | 777 |
1256097 | 1256097 | 2021-04-25 | Kent | Michigan | 26081 | 66329 | 777 |
1252850 | 1252850 | 2021-04-24 | Kent | Michigan | 26081 | 66329 | 777 |
1248707 | 1248707 | 2021-04-23 | Volusia | Florida | 12127 | 41950 | 777 |
1242091 | 1242091 | 2021-04-21 | El Paso | Colorado | 8041 | 61361 | 777 |
1238844 | 1238844 | 2021-04-20 | El Paso | Colorado | 8041 | 61137 | 777 |
1235597 | 1235597 | 2021-04-19 | El Paso | Colorado | 8041 | 60762 | 777 |
1232350 | 1232350 | 2021-04-18 | El Paso | Colorado | 8041 | 60646 | 777 |
1216038 | 1216038 | 2021-04-13 | Contra Costa | California | 6013 | 66567 | 777 |
1212791 | 1212791 | 2021-04-12 | Contra Costa | California | 6013 | 66442 | 777 |
1206294 | 1206294 | 2021-04-10 | Contra Costa | California | 6013 | 66262 | 777 |
1176398 | 1176398 | 2021-03-31 | Lubbock | Texas | 48303 | 48591 | 777 |
1147692 | 1147692 | 2021-03-23 | Mobile | Alabama | 1097 | 37320 | 777 |
1144774 | 1144774 | 2021-03-22 | Sarasota | Florida | 12115 | 28515 | 777 |
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);