ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
152 rows where deaths = 748 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Texas 21
- Colorado 17
- Louisiana 15
- California 10
- Missouri 7
- New York 7
- Oklahoma 7
- Pennsylvania 7
- Virginia 6
- Michigan 5
- Ohio 5
- South Carolina 5
- Florida 4
- Illinois 4
- New Hampshire 4
- New Jersey 4
- New Mexico 4
- Georgia 3
- Maryland 3
- Washington 3
- Massachusetts 2
- Minnesota 2
- Wisconsin 2
- Alabama 1
- Arizona 1
- Delaware 1
- Indiana 1
- North Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502610 | 2502610 | 2022-05-13 | Prince William | Virginia | 51153 | 97967 | 748 |
2499352 | 2499352 | 2022-05-12 | Prince William | Virginia | 51153 | 97758 | 748 |
2470033 | 2470033 | 2022-05-03 | Prince William | Virginia | 51153 | 96554 | 748 |
2462330 | 2462330 | 2022-05-01 | San Juan | New Mexico | 35045 | 40828 | 748 |
2459074 | 2459074 | 2022-04-30 | San Juan | New Mexico | 35045 | 40828 | 748 |
2455818 | 2455818 | 2022-04-29 | San Juan | New Mexico | 35045 | 40828 | 748 |
2442112 | 2442112 | 2022-04-25 | Ouachita | Louisiana | 22073 | 50617 | 748 |
2438856 | 2438856 | 2022-04-24 | Ouachita | Louisiana | 22073 | 50607 | 748 |
2435600 | 2435600 | 2022-04-23 | Ouachita | Louisiana | 22073 | 50607 | 748 |
2432344 | 2432344 | 2022-04-22 | Ouachita | Louisiana | 22073 | 50607 | 748 |
2429088 | 2429088 | 2022-04-21 | Ouachita | Louisiana | 22073 | 50602 | 748 |
2425832 | 2425832 | 2022-04-20 | Ouachita | Louisiana | 22073 | 50593 | 748 |
2403706 | 2403706 | 2022-04-13 | Doña Ana | New Mexico | 35013 | 63341 | 748 |
2339760 | 2339760 | 2022-03-24 | Chesterfield | Virginia | 51041 | 72062 | 748 |
2336506 | 2336506 | 2022-03-23 | Chesterfield | Virginia | 51041 | 71998 | 748 |
2264160 | 2264160 | 2022-03-01 | Cleveland | Oklahoma | 40027 | 78085 | 748 |
2260910 | 2260910 | 2022-02-28 | Cleveland | Oklahoma | 40027 | 78085 | 748 |
2257659 | 2257659 | 2022-02-27 | Cleveland | Oklahoma | 40027 | 78085 | 748 |
2254408 | 2254408 | 2022-02-26 | Cleveland | Oklahoma | 40027 | 78085 | 748 |
2251157 | 2251157 | 2022-02-25 | Cleveland | Oklahoma | 40027 | 78085 | 748 |
2246236 | 2246236 | 2022-02-24 | Muscogee | Georgia | 13215 | 37619 | 748 |
2247906 | 2247906 | 2022-02-24 | Cleveland | Oklahoma | 40027 | 78085 | 748 |
2244655 | 2244655 | 2022-02-23 | Cleveland | Oklahoma | 40027 | 78085 | 748 |
2217169 | 2217169 | 2022-02-15 | St. Clair | Illinois | 17163 | 67896 | 748 |
2201532 | 2201532 | 2022-02-10 | Ottawa | Michigan | 26139 | 72790 | 748 |
2198278 | 2198278 | 2022-02-09 | Ottawa | Michigan | 26139 | 72790 | 748 |
2194007 | 2194007 | 2022-02-08 | Pueblo | Colorado | 8101 | 42761 | 748 |
2171152 | 2171152 | 2022-02-01 | Merced | California | 6047 | 64843 | 748 |
2123309 | 2123309 | 2022-01-17 | St. Tammany | Louisiana | 22103 | 58119 | 748 |
2124277 | 2124277 | 2022-01-17 | Trumbull | Ohio | 39155 | 38576 | 748 |
2120057 | 2120057 | 2022-01-16 | St. Tammany | Louisiana | 22103 | 58119 | 748 |
2121025 | 2121025 | 2022-01-16 | Trumbull | Ohio | 39155 | 38385 | 748 |
2116805 | 2116805 | 2022-01-15 | St. Tammany | Louisiana | 22103 | 58119 | 748 |
2117773 | 2117773 | 2022-01-15 | Trumbull | Ohio | 39155 | 37996 | 748 |
2118342 | 2118342 | 2022-01-15 | Galveston | Texas | 48167 | 82654 | 748 |
2113554 | 2113554 | 2022-01-14 | St. Tammany | Louisiana | 22103 | 58119 | 748 |
2114522 | 2114522 | 2022-01-14 | Trumbull | Ohio | 39155 | 36959 | 748 |
2110302 | 2110302 | 2022-01-13 | St. Tammany | Louisiana | 22103 | 55677 | 748 |
2107051 | 2107051 | 2022-01-12 | St. Tammany | Louisiana | 22103 | 55677 | 748 |
2078211 | 2078211 | 2022-01-03 | St. Charles | Missouri | 29183 | 75496 | 748 |
2074960 | 2074960 | 2022-01-02 | St. Charles | Missouri | 29183 | 73141 | 748 |
2071709 | 2071709 | 2022-01-01 | St. Charles | Missouri | 29183 | 73141 | 748 |
2068458 | 2068458 | 2021-12-31 | St. Charles | Missouri | 29183 | 73141 | 748 |
2065207 | 2065207 | 2021-12-30 | St. Charles | Missouri | 29183 | 72302 | 748 |
2061957 | 2061957 | 2021-12-29 | St. Charles | Missouri | 29183 | 72250 | 748 |
2063346 | 2063346 | 2021-12-29 | Henrico | Virginia | 51087 | 41247 | 748 |
2058708 | 2058708 | 2021-12-28 | St. Charles | Missouri | 29183 | 71547 | 748 |
2052399 | 2052399 | 2021-12-26 | Hillsborough | New Hampshire | 33011 | 62587 | 748 |
2053251 | 2053251 | 2021-12-26 | Bell | Texas | 48027 | 40272 | 748 |
2049149 | 2049149 | 2021-12-25 | Hillsborough | New Hampshire | 33011 | 62587 | 748 |
2050001 | 2050001 | 2021-12-25 | Bell | Texas | 48027 | 40272 | 748 |
2045899 | 2045899 | 2021-12-24 | Hillsborough | New Hampshire | 33011 | 62587 | 748 |
2046751 | 2046751 | 2021-12-24 | Bell | Texas | 48027 | 40272 | 748 |
2042649 | 2042649 | 2021-12-23 | Hillsborough | New Hampshire | 33011 | 62587 | 748 |
2043501 | 2043501 | 2021-12-23 | Bell | Texas | 48027 | 40272 | 748 |
2040252 | 2040252 | 2021-12-22 | Bell | Texas | 48027 | 40200 | 748 |
2037002 | 2037002 | 2021-12-21 | Bell | Texas | 48027 | 40153 | 748 |
2017286 | 2017286 | 2021-12-15 | Charleston | South Carolina | 45019 | 67679 | 748 |
2012924 | 2012924 | 2021-12-14 | Saginaw | Michigan | 26145 | 35162 | 748 |
2014036 | 2014036 | 2021-12-14 | Charleston | South Carolina | 45019 | 67640 | 748 |
2009673 | 2009673 | 2021-12-13 | Saginaw | Michigan | 26145 | 35162 | 748 |
2010785 | 2010785 | 2021-12-13 | Charleston | South Carolina | 45019 | 67609 | 748 |
1942880 | 1942880 | 2021-11-22 | McLennan | Texas | 48309 | 42918 | 748 |
1939630 | 1939630 | 2021-11-21 | McLennan | Texas | 48309 | 42918 | 748 |
1936380 | 1936380 | 2021-11-20 | McLennan | Texas | 48309 | 42918 | 748 |
1933130 | 1933130 | 2021-11-19 | McLennan | Texas | 48309 | 42850 | 748 |
1929879 | 1929879 | 2021-11-18 | McLennan | Texas | 48309 | 42850 | 748 |
1930315 | 1930315 | 2021-11-18 | Waukesha | Wisconsin | 55133 | 67197 | 748 |
1877519 | 1877519 | 2021-11-02 | Anderson | South Carolina | 45007 | 36710 | 748 |
1874270 | 1874270 | 2021-11-01 | Anderson | South Carolina | 45007 | 36692 | 748 |
1819450 | 1819450 | 2021-10-15 | Smith | Texas | 48423 | 36039 | 748 |
1808661 | 1808661 | 2021-10-12 | Atlantic | New Jersey | 34001 | 38578 | 748 |
1804822 | 1804822 | 2021-10-11 | Anne Arundel | Maryland | 24003 | 51623 | 748 |
1805410 | 1805410 | 2021-10-11 | Atlantic | New Jersey | 34001 | 38515 | 748 |
1802161 | 1802161 | 2021-10-10 | Atlantic | New Jersey | 34001 | 38460 | 748 |
1740949 | 1740949 | 2021-09-21 | Northampton | Pennsylvania | 42095 | 41093 | 748 |
1721021 | 1721021 | 2021-09-15 | Orange | New York | 36071 | 53836 | 748 |
1667010 | 1667010 | 2021-08-29 | Spokane | Washington | 53063 | 55795 | 748 |
1663762 | 1663762 | 2021-08-28 | Spokane | Washington | 53063 | 55795 | 748 |
1660514 | 1660514 | 2021-08-27 | Spokane | Washington | 53063 | 55795 | 748 |
1539234 | 1539234 | 2021-07-21 | Wake | North Carolina | 37183 | 91550 | 748 |
1443201 | 1443201 | 2021-06-22 | Mohave | Arizona | 4015 | 23502 | 748 |
1420619 | 1420619 | 2021-06-15 | Adams | Colorado | 8001 | 61498 | 748 |
1417374 | 1417374 | 2021-06-14 | Adams | Colorado | 8001 | 61498 | 748 |
1414128 | 1414128 | 2021-06-13 | Adams | Colorado | 8001 | 61498 | 748 |
1410883 | 1410883 | 2021-06-12 | Adams | Colorado | 8001 | 61460 | 748 |
1407638 | 1407638 | 2021-06-11 | Adams | Colorado | 8001 | 61352 | 748 |
1404392 | 1404392 | 2021-06-10 | Adams | Colorado | 8001 | 61313 | 748 |
1353346 | 1353346 | 2021-05-25 | Caddo | Louisiana | 22017 | 26540 | 748 |
1305842 | 1305842 | 2021-05-10 | Westmoreland | Pennsylvania | 42129 | 33347 | 748 |
1302596 | 1302596 | 2021-05-09 | Westmoreland | Pennsylvania | 42129 | 33329 | 748 |
1298906 | 1298906 | 2021-05-08 | Rockland | New York | 36087 | 46532 | 748 |
1299349 | 1299349 | 2021-05-08 | Westmoreland | Pennsylvania | 42129 | 33295 | 748 |
1295660 | 1295660 | 2021-05-07 | Rockland | New York | 36087 | 46511 | 748 |
1292414 | 1292414 | 2021-05-06 | Rockland | New York | 36087 | 46483 | 748 |
1289168 | 1289168 | 2021-05-05 | Rockland | New York | 36087 | 46446 | 748 |
1289967 | 1289967 | 2021-05-05 | Denton | Texas | 48121 | 74696 | 748 |
1285922 | 1285922 | 2021-05-04 | Rockland | New York | 36087 | 46388 | 748 |
1286721 | 1286721 | 2021-05-04 | Denton | Texas | 48121 | 74580 | 748 |
1282676 | 1282676 | 2021-05-03 | Rockland | New York | 36087 | 46362 | 748 |
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);