ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
285 rows where cases = 1819 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 20
- North Carolina 16
- Puerto Rico 15
- Indiana 14
- Iowa 14
- Virginia 14
- Georgia 13
- Illinois 13
- Kentucky 12
- Missouri 12
- Nebraska 11
- Alaska 10
- Louisiana 10
- Minnesota 10
- Michigan 9
- Arkansas 8
- Colorado 8
- Montana 6
- Alabama 5
- Idaho 5
- Kansas 5
- Tennessee 5
- California 4
- Florida 4
- Pennsylvania 4
- South Dakota 4
- Mississippi 3
- Ohio 3
- South Carolina 3
- Washington 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501220 | 2501220 | 2022-05-13 | Madison | Montana | 30057 | 1819 | 20 |
2499009 | 2499009 | 2022-05-12 | Delta | Texas | 48119 | 1819 | 25 |
2495751 | 2495751 | 2022-05-11 | Delta | Texas | 48119 | 1819 | 25 |
2492493 | 2492493 | 2022-05-10 | Delta | Texas | 48119 | 1819 | 25 |
2492864 | 2492864 | 2022-05-10 | Williamsburg city | Virginia | 51830 | 1819 | 22 |
2489235 | 2489235 | 2022-05-09 | Delta | Texas | 48119 | 1819 | 25 |
2470534 | 2470534 | 2022-05-04 | Lake | Colorado | 8065 | 1819 | 2 |
2463489 | 2463489 | 2022-05-01 | Lancaster | Virginia | 51103 | 1819 | 31 |
2460233 | 2460233 | 2022-04-30 | Lancaster | Virginia | 51103 | 1819 | 31 |
2456977 | 2456977 | 2022-04-29 | Lancaster | Virginia | 51103 | 1819 | 31 |
2398699 | 2398699 | 2022-04-12 | Dillingham Census Area | Alaska | 2070 | 1819 | 11 |
2395444 | 2395444 | 2022-04-11 | Dillingham Census Area | Alaska | 2070 | 1819 | 11 |
2392188 | 2392188 | 2022-04-10 | Dillingham Census Area | Alaska | 2070 | 1819 | 11 |
2388932 | 2388932 | 2022-04-09 | Dillingham Census Area | Alaska | 2070 | 1819 | 11 |
2385677 | 2385677 | 2022-04-08 | Dillingham Census Area | Alaska | 2070 | 1819 | 11 |
2382422 | 2382422 | 2022-04-07 | Dillingham Census Area | Alaska | 2070 | 1819 | 11 |
2379167 | 2379167 | 2022-04-06 | Dillingham Census Area | Alaska | 2070 | 1819 | 11 |
2338566 | 2338566 | 2022-03-24 | Wayne | Nebraska | 31179 | 1819 | 11 |
2335312 | 2335312 | 2022-03-23 | Wayne | Nebraska | 31179 | 1819 | 11 |
2319045 | 2319045 | 2022-03-18 | Wayne | Nebraska | 31179 | 1819 | 11 |
2315792 | 2315792 | 2022-03-17 | Wayne | Nebraska | 31179 | 1819 | 11 |
2316373 | 2316373 | 2022-03-17 | Arroyo | Puerto Rico | 72015 | 1819 | |
2313120 | 2313120 | 2022-03-16 | Arroyo | Puerto Rico | 72015 | 1819 | |
2309867 | 2309867 | 2022-03-15 | Arroyo | Puerto Rico | 72015 | 1819 | |
2306614 | 2306614 | 2022-03-14 | Arroyo | Puerto Rico | 72015 | 1819 | |
2303363 | 2303363 | 2022-03-13 | Arroyo | Puerto Rico | 72015 | 1819 | |
2294373 | 2294373 | 2022-03-10 | Calhoun | West Virginia | 54013 | 1819 | 13 |
2279797 | 2279797 | 2022-03-06 | Hickory | Missouri | 29085 | 1819 | 54 |
2276544 | 2276544 | 2022-03-05 | Hickory | Missouri | 29085 | 1819 | 54 |
2273291 | 2273291 | 2022-03-04 | Hickory | Missouri | 29085 | 1819 | 54 |
2242112 | 2242112 | 2022-02-22 | Winkler | Texas | 48495 | 1819 | 34 |
2238861 | 2238861 | 2022-02-21 | Winkler | Texas | 48495 | 1819 | 34 |
2235610 | 2235610 | 2022-02-20 | Winkler | Texas | 48495 | 1819 | 34 |
2232359 | 2232359 | 2022-02-19 | Winkler | Texas | 48495 | 1819 | 34 |
2216789 | 2216789 | 2022-02-15 | Yuma | Colorado | 8125 | 1819 | 23 |
2178428 | 2178428 | 2022-02-03 | Russell | Kansas | 20167 | 1819 | 35 |
2175175 | 2175175 | 2022-02-02 | Russell | Kansas | 20167 | 1819 | 35 |
2174138 | 2174138 | 2022-02-01 | Menominee | Wisconsin | 55078 | 1819 | 12 |
2168718 | 2168718 | 2022-01-31 | Crittenden | Kentucky | 21055 | 1819 | 39 |
2145481 | 2145481 | 2022-01-24 | Boundary | Idaho | 16021 | 1819 | 53 |
2141832 | 2141832 | 2022-01-23 | Searcy | Arkansas | 5129 | 1819 | 37 |
2144745 | 2144745 | 2022-01-23 | Lincoln | Washington | 53043 | 1819 | 26 |
2141490 | 2141490 | 2022-01-22 | Lincoln | Washington | 53043 | 1819 | 26 |
2138234 | 2138234 | 2022-01-21 | Lincoln | Washington | 53043 | 1819 | 26 |
2132457 | 2132457 | 2022-01-20 | Benewah | Idaho | 16009 | 1819 | 32 |
2134525 | 2134525 | 2022-01-20 | Archer | Texas | 48009 | 1819 | 24 |
2125872 | 2125872 | 2022-01-18 | Macon | Georgia | 13193 | 1819 | 46 |
2106342 | 2106342 | 2022-01-12 | Heard | Georgia | 13149 | 1819 | 43 |
2103674 | 2103674 | 2022-01-11 | Hancock | Kentucky | 21091 | 1819 | 19 |
2098477 | 2098477 | 2022-01-09 | Ciales | Puerto Rico | 72039 | 1819 | |
2098899 | 2098899 | 2022-01-09 | Live Oak | Texas | 48297 | 1819 | 39 |
2053079 | 2053079 | 2021-12-26 | Bon Homme | South Dakota | 46009 | 1819 | 31 |
2049829 | 2049829 | 2021-12-25 | Bon Homme | South Dakota | 46009 | 1819 | 31 |
2046579 | 2046579 | 2021-12-24 | Bon Homme | South Dakota | 46009 | 1819 | 31 |
2043329 | 2043329 | 2021-12-23 | Bon Homme | South Dakota | 46009 | 1819 | 31 |
2013955 | 2013955 | 2021-12-14 | Camuy | Puerto Rico | 72027 | 1819 | |
2006240 | 2006240 | 2021-12-12 | Catahoula | Louisiana | 22025 | 1819 | 48 |
2002989 | 2002989 | 2021-12-11 | Catahoula | Louisiana | 22025 | 1819 | 48 |
1999739 | 1999739 | 2021-12-10 | Catahoula | Louisiana | 22025 | 1819 | 48 |
1992814 | 1992814 | 2021-12-08 | Brown | Indiana | 18013 | 1819 | 51 |
1973363 | 1973363 | 2021-12-02 | Newton | Indiana | 18111 | 1819 | 54 |
1928729 | 1928729 | 2021-11-18 | Jefferson | Montana | 30043 | 1819 | 13 |
1923841 | 1923841 | 2021-11-16 | Washakie | Wyoming | 56043 | 1819 | 35 |
1914389 | 1914389 | 2021-11-14 | Prowers | Colorado | 8099 | 1819 | 32 |
1911139 | 1911139 | 2021-11-13 | Prowers | Colorado | 8099 | 1819 | 32 |
1907890 | 1907890 | 2021-11-12 | Prowers | Colorado | 8099 | 1819 | 32 |
1905457 | 1905457 | 2021-11-11 | Todd | Kentucky | 21219 | 1819 | 32 |
1902207 | 1902207 | 2021-11-10 | Todd | Kentucky | 21219 | 1819 | 32 |
1860048 | 1860048 | 2021-10-28 | Lincoln | Maine | 23015 | 1819 | 6 |
1861508 | 1861508 | 2021-10-28 | Callahan | Texas | 48059 | 1819 | 53 |
1847157 | 1847157 | 2021-10-24 | Missaukee | Michigan | 26113 | 1819 | 37 |
1843907 | 1843907 | 2021-10-23 | Missaukee | Michigan | 26113 | 1819 | 37 |
1840657 | 1840657 | 2021-10-22 | Missaukee | Michigan | 26113 | 1819 | 37 |
1836709 | 1836709 | 2021-10-21 | Washington | Idaho | 16087 | 1819 | 44 |
1790234 | 1790234 | 2021-10-06 | Ward | Texas | 48475 | 1819 | 26 |
1784324 | 1784324 | 2021-10-05 | Inyo | California | 6027 | 1819 | 39 |
1781961 | 1781961 | 2021-10-04 | Metcalfe | Kentucky | 21169 | 1819 | 37 |
1784102 | 1784102 | 2021-10-04 | Big Horn | Wyoming | 56003 | 1819 | 39 |
1745116 | 1745116 | 2021-09-22 | Converse | Wyoming | 56009 | 1819 | 29 |
1710066 | 1710066 | 2021-09-12 | Mercer | Illinois | 17131 | 1819 | 34 |
1712402 | 1712402 | 2021-09-12 | Martinsville city | Virginia | 51690 | 1819 | 82 |
1706819 | 1706819 | 2021-09-11 | Mercer | Illinois | 17131 | 1819 | 34 |
1709155 | 1709155 | 2021-09-11 | Martinsville city | Virginia | 51690 | 1819 | 82 |
1703571 | 1703571 | 2021-09-10 | Mercer | Illinois | 17131 | 1819 | 34 |
1705908 | 1705908 | 2021-09-10 | Martinsville city | Virginia | 51690 | 1819 | 82 |
1695509 | 1695509 | 2021-09-07 | Cidra | Puerto Rico | 72041 | 1819 | |
1692261 | 1692261 | 2021-09-06 | Cidra | Puerto Rico | 72041 | 1819 | |
1655751 | 1655751 | 2021-08-26 | Pemiscot | Missouri | 29155 | 1819 | 39 |
1632586 | 1632586 | 2021-08-19 | Madison | Louisiana | 22065 | 1819 | 46 |
1630146 | 1630146 | 2021-08-18 | Madison | North Carolina | 37115 | 1819 | 43 |
1618521 | 1618521 | 2021-08-15 | Juneau City and Borough | Alaska | 2110 | 1819 | 3 |
1620084 | 1620084 | 2021-08-15 | Lincoln | Montana | 30053 | 1819 | 21 |
1615273 | 1615273 | 2021-08-14 | Juneau City and Borough | Alaska | 2110 | 1819 | 3 |
1616836 | 1616836 | 2021-08-14 | Lincoln | Montana | 30053 | 1819 | 21 |
1612024 | 1612024 | 2021-08-13 | Juneau City and Borough | Alaska | 2110 | 1819 | 3 |
1613588 | 1613588 | 2021-08-13 | Lincoln | Montana | 30053 | 1819 | 21 |
1610053 | 1610053 | 2021-08-12 | Houston | Minnesota | 27055 | 1819 | 16 |
1604733 | 1604733 | 2021-08-10 | Benton | Tennessee | 47005 | 1819 | 41 |
1596890 | 1596890 | 2021-08-08 | Winn | Louisiana | 22127 | 1819 | 48 |
1593641 | 1593641 | 2021-08-07 | Winn | Louisiana | 22127 | 1819 | 48 |
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);