ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
166 rows where cases = 3202 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 23
- Georgia 12
- Minnesota 9
- Mississippi 9
- Texas 8
- Virginia 8
- Florida 7
- Kentucky 7
- Oregon 7
- Wisconsin 7
- Kansas 6
- Pennsylvania 6
- Puerto Rico 6
- Arkansas 5
- Louisiana 5
- Missouri 5
- Utah 4
- Alabama 3
- Nebraska 3
- New York 3
- South Carolina 3
- California 2
- Illinois 2
- Maryland 2
- North Carolina 2
- Ohio 2
- Washington 2
- West Virginia 2
- Idaho 1
- Indiana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472648 | 2472648 | 2022-05-04 | Orocovis | Puerto Rico | 72107 | 3202 | |
2468816 | 2468816 | 2022-05-03 | Unknown | New Jersey | 3202 | 0 | |
2372280 | 2372280 | 2022-04-03 | Brunswick | Virginia | 51025 | 3202 | 46 |
2369027 | 2369027 | 2022-04-02 | Brunswick | Virginia | 51025 | 3202 | 46 |
2365774 | 2365774 | 2022-04-01 | Brunswick | Virginia | 51025 | 3202 | 46 |
2355644 | 2355644 | 2022-03-29 | Jackson | Tennessee | 47087 | 3202 | 62 |
2352391 | 2352391 | 2022-03-28 | Jackson | Tennessee | 47087 | 3202 | 62 |
2349139 | 2349139 | 2022-03-27 | Jackson | Tennessee | 47087 | 3202 | 62 |
2345886 | 2345886 | 2022-03-26 | Jackson | Tennessee | 47087 | 3202 | 62 |
2342633 | 2342633 | 2022-03-25 | Jackson | Tennessee | 47087 | 3202 | 62 |
2339380 | 2339380 | 2022-03-24 | Jackson | Tennessee | 47087 | 3202 | 62 |
2336126 | 2336126 | 2022-03-23 | Jackson | Tennessee | 47087 | 3202 | 62 |
2324290 | 2324290 | 2022-03-20 | Oglethorpe | Georgia | 13221 | 3202 | 52 |
2321036 | 2321036 | 2022-03-19 | Oglethorpe | Georgia | 13221 | 3202 | 52 |
2317782 | 2317782 | 2022-03-18 | Oglethorpe | Georgia | 13221 | 3202 | 52 |
2292841 | 2292841 | 2022-03-10 | Osage | Missouri | 29151 | 3202 | 42 |
2267344 | 2267344 | 2022-03-02 | Harrison | Ohio | 39067 | 3202 | 72 |
2265153 | 2265153 | 2022-03-01 | Bayfield | Wisconsin | 55007 | 3202 | 38 |
2261903 | 2261903 | 2022-02-28 | Bayfield | Wisconsin | 55007 | 3202 | 38 |
2237405 | 2237405 | 2022-02-21 | Amite | Mississippi | 28005 | 3202 | 65 |
2234154 | 2234154 | 2022-02-20 | Amite | Mississippi | 28005 | 3202 | 65 |
2234472 | 2234472 | 2022-02-20 | Otoe | Nebraska | 31131 | 3202 | 17 |
2230903 | 2230903 | 2022-02-19 | Amite | Mississippi | 28005 | 3202 | 65 |
2231221 | 2231221 | 2022-02-19 | Otoe | Nebraska | 31131 | 3202 | 17 |
2227652 | 2227652 | 2022-02-18 | Amite | Mississippi | 28005 | 3202 | 65 |
2227970 | 2227970 | 2022-02-18 | Otoe | Nebraska | 31131 | 3202 | 17 |
2223945 | 2223945 | 2022-02-17 | Nemaha | Kansas | 20131 | 3202 | 60 |
2220694 | 2220694 | 2022-02-16 | Nemaha | Kansas | 20131 | 3202 | 60 |
2222118 | 2222118 | 2022-02-16 | Naguabo | Puerto Rico | 72103 | 3202 | |
2212873 | 2212873 | 2022-02-13 | Millard | Utah | 49027 | 3202 | 33 |
2209620 | 2209620 | 2022-02-12 | Millard | Utah | 49027 | 3202 | 33 |
2206367 | 2206367 | 2022-02-11 | Millard | Utah | 49027 | 3202 | 33 |
2201373 | 2201373 | 2022-02-10 | Madison | Louisiana | 22065 | 3202 | 58 |
2152809 | 2152809 | 2022-01-26 | Renville | Minnesota | 27129 | 3202 | 53 |
2131272 | 2131272 | 2022-01-19 | Aransas | Texas | 48007 | 3202 | 69 |
2099985 | 2099985 | 2022-01-10 | Carroll | Illinois | 17015 | 3202 | 43 |
2087811 | 2087811 | 2022-01-06 | Holmes | Mississippi | 28051 | 3202 | 93 |
2052020 | 2052020 | 2021-12-26 | Wadena | Minnesota | 27159 | 3202 | 43 |
2048770 | 2048770 | 2021-12-25 | Wadena | Minnesota | 27159 | 3202 | 43 |
2045520 | 2045520 | 2021-12-24 | Wadena | Minnesota | 27159 | 3202 | 43 |
2042270 | 2042270 | 2021-12-23 | Wadena | Minnesota | 27159 | 3202 | 43 |
2031727 | 2031727 | 2021-12-20 | Clay | Illinois | 17025 | 3202 | 60 |
1988884 | 1988884 | 2021-12-07 | Hale | Alabama | 1065 | 3202 | 89 |
1936878 | 1936878 | 2021-11-21 | Henry | Alabama | 1067 | 3202 | 66 |
1927218 | 1927218 | 2021-11-18 | Conway | Arkansas | 5029 | 3202 | 46 |
1923208 | 1923208 | 2021-11-16 | Unicoi | Tennessee | 47171 | 3202 | 65 |
1920561 | 1920561 | 2021-11-15 | Vernon | Wisconsin | 55123 | 3202 | 63 |
1898437 | 1898437 | 2021-11-09 | Minidoka | Idaho | 16067 | 3202 | 48 |
1897195 | 1897195 | 2021-11-08 | Polk | Tennessee | 47139 | 3202 | 31 |
1893945 | 1893945 | 2021-11-07 | Polk | Tennessee | 47139 | 3202 | 31 |
1890695 | 1890695 | 2021-11-06 | Polk | Tennessee | 47139 | 3202 | 31 |
1887445 | 1887445 | 2021-11-05 | Polk | Tennessee | 47139 | 3202 | 31 |
1879358 | 1879358 | 2021-11-03 | Bourbon | Kentucky | 21017 | 3202 | 35 |
1871788 | 1871788 | 2021-10-31 | Langlade | Wisconsin | 55067 | 3202 | 56 |
1865516 | 1865516 | 2021-10-30 | Phillips | Arkansas | 5107 | 3202 | 77 |
1868539 | 1868539 | 2021-10-30 | Langlade | Wisconsin | 55067 | 3202 | 56 |
1862267 | 1862267 | 2021-10-29 | Phillips | Arkansas | 5107 | 3202 | 77 |
1865290 | 1865290 | 2021-10-29 | Langlade | Wisconsin | 55067 | 3202 | 56 |
1850243 | 1850243 | 2021-10-25 | Concordia | Louisiana | 22029 | 3202 | 78 |
1852167 | 1852167 | 2021-10-25 | Adams | Washington | 53001 | 3202 | 31 |
1834650 | 1834650 | 2021-10-20 | Sullivan | New Hampshire | 33019 | 3202 | 36 |
1823511 | 1823511 | 2021-10-17 | Ben Hill | Georgia | 13017 | 3202 | 99 |
1820262 | 1820262 | 2021-10-16 | Ben Hill | Georgia | 13017 | 3202 | 99 |
1817013 | 1817013 | 2021-10-15 | Ben Hill | Georgia | 13017 | 3202 | 99 |
1793659 | 1793659 | 2021-10-07 | Salem city | Virginia | 51775 | 3202 | 56 |
1787544 | 1787544 | 2021-10-06 | Randolph | Arkansas | 5121 | 3202 | 51 |
1767019 | 1767019 | 2021-09-29 | Rio Grande | Puerto Rico | 72119 | 3202 | |
1758179 | 1758179 | 2021-09-27 | Monroe | Alabama | 1099 | 3202 | 53 |
1734371 | 1734371 | 2021-09-19 | Columbia | Oregon | 41009 | 3202 | 37 |
1731121 | 1731121 | 2021-09-18 | Columbia | Oregon | 41009 | 3202 | 37 |
1727871 | 1727871 | 2021-09-17 | Columbia | Oregon | 41009 | 3202 | 37 |
1717465 | 1717465 | 2021-09-14 | Nodaway | Missouri | 29147 | 3202 | 32 |
1696567 | 1696567 | 2021-09-08 | Ouachita | Arkansas | 5103 | 3202 | 68 |
1696939 | 1696939 | 2021-09-08 | Union | Georgia | 13291 | 3202 | 90 |
1699469 | 1699469 | 2021-09-08 | Clallam | Washington | 53009 | 3202 | 23 |
1690978 | 1690978 | 2021-09-06 | Lincoln | Kentucky | 21137 | 3202 | 64 |
1687728 | 1687728 | 2021-09-05 | Lincoln | Kentucky | 21137 | 3202 | 64 |
1684478 | 1684478 | 2021-09-04 | Lincoln | Kentucky | 21137 | 3202 | 64 |
1681227 | 1681227 | 2021-09-03 | Lincoln | Kentucky | 21137 | 3202 | 64 |
1666709 | 1666709 | 2021-08-29 | Milam | Texas | 48331 | 3202 | 59 |
1663461 | 1663461 | 2021-08-28 | Milam | Texas | 48331 | 3202 | 59 |
1655260 | 1655260 | 2021-08-26 | Mercer | Kentucky | 21167 | 3202 | 56 |
1634673 | 1634673 | 2021-08-19 | Park | Wyoming | 56029 | 3202 | 35 |
1621889 | 1621889 | 2021-08-16 | Glenn | California | 6021 | 3202 | 27 |
1621039 | 1621039 | 2021-08-15 | Overton | Tennessee | 47133 | 3202 | 63 |
1617791 | 1617791 | 2021-08-14 | Overton | Tennessee | 47133 | 3202 | 63 |
1613829 | 1613829 | 2021-08-13 | Orleans | New York | 36073 | 3202 | 83 |
1614543 | 1614543 | 2021-08-13 | Overton | Tennessee | 47133 | 3202 | 63 |
1425899 | 1425899 | 2021-06-16 | Clarion | Pennsylvania | 42031 | 3202 | 95 |
1422652 | 1422652 | 2021-06-15 | Clarion | Pennsylvania | 42031 | 3202 | 95 |
1416161 | 1416161 | 2021-06-13 | Clarion | Pennsylvania | 42031 | 3202 | 95 |
1400195 | 1400195 | 2021-06-08 | Claiborne | Tennessee | 47025 | 3202 | 74 |
1396950 | 1396950 | 2021-06-07 | Claiborne | Tennessee | 47025 | 3202 | 74 |
1380722 | 1380722 | 2021-06-02 | Claiborne | Tennessee | 47025 | 3202 | 74 |
1366809 | 1366809 | 2021-05-29 | Warren | Missouri | 29219 | 3202 | 33 |
1361828 | 1361828 | 2021-05-27 | Logan | West Virginia | 54045 | 3202 | 95 |
1325569 | 1325569 | 2021-05-16 | Lauderdale | Tennessee | 47097 | 3202 | 44 |
1320094 | 1320094 | 2021-05-15 | Hardee | Florida | 12049 | 3202 | 44 |
1322323 | 1322323 | 2021-05-15 | Lauderdale | Tennessee | 47097 | 3202 | 44 |
1319077 | 1319077 | 2021-05-14 | Lauderdale | Tennessee | 47097 | 3202 | 44 |
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);