ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
177 rows where cases = 2771 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 39
- Arkansas 17
- Texas 17
- Missouri 13
- Iowa 11
- Virginia 11
- Kentucky 9
- Georgia 8
- Tennessee 7
- Minnesota 6
- Ohio 6
- Michigan 5
- Mississippi 5
- Pennsylvania 5
- West Virginia 5
- Indiana 4
- Louisiana 4
- Nebraska 4
- Maryland 3
- New Jersey 3
- New York 3
- South Carolina 3
- Wisconsin 3
- Wyoming 3
- Alaska 2
- Arizona 2
- Florida 2
- Illinois 2
- New Mexico 2
- Oregon 2
- Alabama 1
- California 1
- Colorado 1
- Idaho 1
- Maine 1
- Nevada 1
- North Carolina 1
- Puerto Rico 1
- South Dakota 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2395490 | 2395490 | 2022-04-11 | Chicot | Arkansas | 5017 | 2771 | 60 |
2392234 | 2392234 | 2022-04-10 | Chicot | Arkansas | 5017 | 2771 | 60 |
2388978 | 2388978 | 2022-04-09 | Chicot | Arkansas | 5017 | 2771 | 60 |
2385723 | 2385723 | 2022-04-08 | Chicot | Arkansas | 5017 | 2771 | 60 |
2382468 | 2382468 | 2022-04-07 | Chicot | Arkansas | 5017 | 2771 | 60 |
2379213 | 2379213 | 2022-04-06 | Chicot | Arkansas | 5017 | 2771 | 60 |
2375959 | 2375959 | 2022-04-05 | Chicot | Arkansas | 5017 | 2771 | 60 |
2365187 | 2365187 | 2022-04-01 | Comerio | Puerto Rico | 72045 | 2771 | |
2347044 | 2347044 | 2022-03-27 | Long | Georgia | 13183 | 2771 | 34 |
2343791 | 2343791 | 2022-03-26 | Long | Georgia | 13183 | 2771 | 34 |
2340176 | 2340176 | 2022-03-25 | Chicot | Arkansas | 5017 | 2771 | 60 |
2340538 | 2340538 | 2022-03-25 | Long | Georgia | 13183 | 2771 | 34 |
2336923 | 2336923 | 2022-03-24 | Chicot | Arkansas | 5017 | 2771 | 60 |
2333669 | 2333669 | 2022-03-23 | Chicot | Arkansas | 5017 | 2771 | 60 |
2287455 | 2287455 | 2022-03-08 | Eastland | Texas | 48133 | 2771 | 111 |
2188592 | 2188592 | 2022-02-06 | Pope | Minnesota | 27121 | 2771 | 16 |
2185339 | 2185339 | 2022-02-05 | Pope | Minnesota | 27121 | 2771 | 16 |
2182087 | 2182087 | 2022-02-04 | Pope | Minnesota | 27121 | 2771 | 16 |
2145980 | 2145980 | 2022-01-24 | Leslie | Kentucky | 21131 | 2771 | 39 |
2131979 | 2131979 | 2022-01-20 | Northwest Arctic Borough | Alaska | 2188 | 2771 | 10 |
2128725 | 2128725 | 2022-01-19 | Northwest Arctic Borough | Alaska | 2188 | 2771 | 10 |
2130886 | 2130886 | 2022-01-19 | Hood River | Oregon | 41027 | 2771 | 38 |
2108648 | 2108648 | 2022-01-12 | Leon | Texas | 48289 | 2771 | 75 |
2084645 | 2084645 | 2022-01-05 | Dallas | Missouri | 29059 | 2771 | 62 |
2078110 | 2078110 | 2022-01-03 | Yalobusha | Mississippi | 28161 | 2771 | 48 |
2079549 | 2079549 | 2022-01-03 | Appomattox | Virginia | 51011 | 2771 | 38 |
2039359 | 2039359 | 2021-12-22 | Saline | Nebraska | 31151 | 2771 | 6 |
2036596 | 2036596 | 2021-12-21 | Clatsop | Oregon | 41007 | 2771 | 35 |
2021255 | 2021255 | 2021-12-16 | Taylor | West Virginia | 54091 | 2771 | 49 |
2011551 | 2011551 | 2021-12-13 | Marquette | Wisconsin | 55077 | 2771 | 38 |
1983421 | 1983421 | 2021-12-05 | Lewis | Kentucky | 21135 | 2771 | 60 |
1980171 | 1980171 | 2021-12-04 | Lewis | Kentucky | 21135 | 2771 | 60 |
1976921 | 1976921 | 2021-12-03 | Lewis | Kentucky | 21135 | 2771 | 60 |
1977357 | 1977357 | 2021-12-03 | Benton | Missouri | 29015 | 2771 | 70 |
1974107 | 1974107 | 2021-12-02 | Benton | Missouri | 29015 | 2771 | 70 |
1964418 | 1964418 | 2021-11-29 | Moniteau | Missouri | 29135 | 2771 | 46 |
1924899 | 1924899 | 2021-11-17 | Jackson | Kentucky | 21109 | 2771 | 51 |
1921432 | 1921432 | 2021-11-16 | Hardin | Iowa | 19083 | 2771 | 53 |
1918182 | 1918182 | 2021-11-15 | Hardin | Iowa | 19083 | 2771 | 53 |
1914932 | 1914932 | 2021-11-14 | Hardin | Iowa | 19083 | 2771 | 53 |
1911682 | 1911682 | 2021-11-13 | Hardin | Iowa | 19083 | 2771 | 53 |
1908433 | 1908433 | 2021-11-12 | Hardin | Iowa | 19083 | 2771 | 53 |
1905184 | 1905184 | 2021-11-11 | Hardin | Iowa | 19083 | 2771 | 53 |
1901934 | 1901934 | 2021-11-10 | Hardin | Iowa | 19083 | 2771 | 53 |
1876245 | 1876245 | 2021-11-02 | Jackson | Louisiana | 22049 | 2771 | 64 |
1876871 | 1876871 | 2021-11-02 | Humboldt | Nevada | 32013 | 2771 | 36 |
1872996 | 1872996 | 2021-11-01 | Jackson | Louisiana | 22049 | 2771 | 64 |
1871838 | 1871838 | 2021-10-31 | Lincoln | Wyoming | 56023 | 2771 | 20 |
1868589 | 1868589 | 2021-10-30 | Lincoln | Wyoming | 56023 | 2771 | 20 |
1865340 | 1865340 | 2021-10-29 | Lincoln | Wyoming | 56023 | 2771 | 20 |
1831615 | 1831615 | 2021-10-19 | Yancey | North Carolina | 37199 | 2771 | 29 |
1825648 | 1825648 | 2021-10-17 | Cannon | Tennessee | 47015 | 2771 | 40 |
1822399 | 1822399 | 2021-10-16 | Cannon | Tennessee | 47015 | 2771 | 40 |
1819150 | 1819150 | 2021-10-15 | Cannon | Tennessee | 47015 | 2771 | 40 |
1811539 | 1811539 | 2021-10-13 | Calhoun | Mississippi | 28013 | 2771 | 45 |
1788894 | 1788894 | 2021-10-06 | Clinton | Missouri | 29049 | 2771 | 76 |
1784052 | 1784052 | 2021-10-04 | Green Lake | Wisconsin | 55047 | 2771 | 29 |
1757879 | 1757879 | 2021-09-26 | Louisa | Virginia | 51109 | 2771 | 41 |
1754631 | 1754631 | 2021-09-25 | Louisa | Virginia | 51109 | 2771 | 41 |
1751153 | 1751153 | 2021-09-24 | Lee | Texas | 48287 | 2771 | 47 |
1751383 | 1751383 | 2021-09-24 | Louisa | Virginia | 51109 | 2771 | 41 |
1745264 | 1745264 | 2021-09-23 | Cross | Arkansas | 5037 | 2771 | 59 |
1747904 | 1747904 | 2021-09-23 | Lee | Texas | 48287 | 2771 | 47 |
1743095 | 1743095 | 2021-09-22 | Caroline | Maryland | 24011 | 2771 | 39 |
1741242 | 1741242 | 2021-09-21 | Sequatchie | Tennessee | 47153 | 2771 | 30 |
1737993 | 1737993 | 2021-09-20 | Sequatchie | Tennessee | 47153 | 2771 | 30 |
1738349 | 1738349 | 2021-09-20 | Dinwiddie | Virginia | 51053 | 2771 | 47 |
1725211 | 1725211 | 2021-09-16 | Robertson | Texas | 48395 | 2771 | 59 |
1713727 | 1713727 | 2021-09-13 | McCreary | Kentucky | 21147 | 2771 | 36 |
1710480 | 1710480 | 2021-09-12 | McCreary | Kentucky | 21147 | 2771 | 36 |
1712317 | 1712317 | 2021-09-12 | Rutland | Vermont | 50021 | 2771 | 22 |
1707233 | 1707233 | 2021-09-11 | McCreary | Kentucky | 21147 | 2771 | 36 |
1698264 | 1698264 | 2021-09-08 | Delaware | New York | 36025 | 2771 | 39 |
1698846 | 1698846 | 2021-09-08 | Hampton | South Carolina | 45049 | 2771 | 64 |
1694764 | 1694764 | 2021-09-07 | Texas | Missouri | 29215 | 2771 | 34 |
1692946 | 1692946 | 2021-09-06 | Russell | Virginia | 51167 | 2771 | 42 |
1660797 | 1660797 | 2021-08-28 | Conway | Arkansas | 5029 | 2771 | 39 |
1661893 | 1661893 | 2021-08-28 | Somerset | Maryland | 24039 | 2771 | 43 |
1656500 | 1656500 | 2021-08-26 | Warren | Pennsylvania | 42123 | 2771 | 107 |
1651423 | 1651423 | 2021-08-25 | Morgan | Georgia | 13211 | 2771 | 31 |
1588668 | 1588668 | 2021-08-05 | Gillespie | Texas | 48171 | 2771 | 53 |
1558817 | 1558817 | 2021-07-27 | Henry | Ohio | 39069 | 2771 | 67 |
1538692 | 1538692 | 2021-07-21 | Leake | Mississippi | 28079 | 2771 | 75 |
1510808 | 1510808 | 2021-07-12 | Moore | Texas | 48341 | 2771 | 73 |
1505217 | 1505217 | 2021-07-11 | Franklin | Georgia | 13119 | 2771 | 57 |
1507561 | 1507561 | 2021-07-11 | Moore | Texas | 48341 | 2771 | 73 |
1501971 | 1501971 | 2021-07-10 | Franklin | Georgia | 13119 | 2771 | 57 |
1504315 | 1504315 | 2021-07-10 | Moore | Texas | 48341 | 2771 | 73 |
1498725 | 1498725 | 2021-07-09 | Franklin | Georgia | 13119 | 2771 | 57 |
1496335 | 1496335 | 2021-07-08 | Oceana | Michigan | 26127 | 2771 | 60 |
1497823 | 1497823 | 2021-07-08 | Moore | Texas | 48341 | 2771 | 73 |
1493088 | 1493088 | 2021-07-07 | Oceana | Michigan | 26127 | 2771 | 60 |
1493385 | 1493385 | 2021-07-07 | Stone | Missouri | 29209 | 2771 | 49 |
1494576 | 1494576 | 2021-07-07 | Moore | Texas | 48341 | 2771 | 73 |
1489841 | 1489841 | 2021-07-06 | Oceana | Michigan | 26127 | 2771 | 60 |
1491662 | 1491662 | 2021-07-06 | Mingo | West Virginia | 54059 | 2771 | 43 |
1444194 | 1444194 | 2021-06-22 | Perry | Kentucky | 21193 | 2771 | 66 |
1365462 | 1365462 | 2021-05-29 | Delta | Colorado | 8029 | 2771 | 63 |
1296884 | 1296884 | 2021-05-07 | Greenbrier | West Virginia | 54025 | 2771 | 61 |
1291854 | 1291854 | 2021-05-06 | Wexford | Michigan | 26165 | 2771 | 42 |
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);