ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
174 rows where cases = 2880 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 15
- Kentucky 11
- Oklahoma 10
- Florida 9
- Georgia 9
- Indiana 9
- Michigan 8
- Illinois 7
- Mississippi 7
- Utah 7
- Arkansas 6
- Louisiana 6
- Minnesota 5
- Missouri 5
- North Carolina 5
- Puerto Rico 5
- Alabama 4
- California 4
- Colorado 4
- Pennsylvania 4
- Virginia 4
- Wisconsin 4
- Nebraska 3
- New Mexico 3
- Oregon 3
- Tennessee 3
- West Virginia 3
- Idaho 2
- Iowa 2
- Maryland 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501409 | 2501409 | 2022-05-13 | Los Alamos | New Mexico | 35028 | 2880 | 16 |
2498151 | 2498151 | 2022-05-12 | Los Alamos | New Mexico | 35028 | 2880 | 16 |
2483578 | 2483578 | 2022-05-08 | Park | Colorado | 8093 | 2880 | 20 |
2480320 | 2480320 | 2022-05-07 | Park | Colorado | 8093 | 2880 | 20 |
2477062 | 2477062 | 2022-05-06 | Park | Colorado | 8093 | 2880 | 20 |
2375905 | 2375905 | 2022-04-05 | Wilcox | Alabama | 1131 | 2880 | 46 |
2372653 | 2372653 | 2022-04-04 | Wilcox | Alabama | 1131 | 2880 | 46 |
2374977 | 2374977 | 2022-04-04 | Orocovis | Puerto Rico | 72107 | 2880 | |
2307165 | 2307165 | 2022-03-14 | Juab | Utah | 49023 | 2880 | 23 |
2303914 | 2303914 | 2022-03-13 | Juab | Utah | 49023 | 2880 | 23 |
2300662 | 2300662 | 2022-03-12 | Juab | Utah | 49023 | 2880 | 23 |
2297410 | 2297410 | 2022-03-11 | Juab | Utah | 49023 | 2880 | 23 |
2294158 | 2294158 | 2022-03-10 | Juab | Utah | 49023 | 2880 | 23 |
2290906 | 2290906 | 2022-03-09 | Juab | Utah | 49023 | 2880 | 23 |
2287654 | 2287654 | 2022-03-08 | Juab | Utah | 49023 | 2880 | 23 |
2268678 | 2268678 | 2022-03-03 | Stone | Arkansas | 5137 | 2880 | 60 |
2243070 | 2243070 | 2022-02-23 | Gooding | Idaho | 16047 | 2880 | 52 |
2201683 | 2201683 | 2022-02-10 | Montgomery | Mississippi | 28097 | 2880 | 67 |
2172074 | 2172074 | 2022-02-01 | Caldwell | Louisiana | 22021 | 2880 | 44 |
2165652 | 2165652 | 2022-01-30 | Kent | Maryland | 24029 | 2880 | 63 |
2156901 | 2156901 | 2022-01-27 | Baker | Oregon | 41001 | 2880 | 41 |
2149731 | 2149731 | 2022-01-25 | Mississippi | Missouri | 29133 | 2880 | 51 |
2142812 | 2142812 | 2022-01-23 | Madison | Louisiana | 22065 | 2880 | 56 |
2139557 | 2139557 | 2022-01-22 | Madison | Louisiana | 22065 | 2880 | 56 |
2136301 | 2136301 | 2022-01-21 | Madison | Louisiana | 22065 | 2880 | 56 |
2114756 | 2114756 | 2022-01-14 | Lares | Puerto Rico | 72081 | 2880 | |
2100736 | 2100736 | 2022-01-10 | Kanabec | Minnesota | 27065 | 2880 | 48 |
2098870 | 2098870 | 2022-01-09 | Jackson | Texas | 48239 | 2880 | 52 |
2089762 | 2089762 | 2022-01-07 | Howard | Arkansas | 5061 | 2880 | 39 |
2078847 | 2078847 | 2022-01-03 | Clatsop | Oregon | 41007 | 2880 | 36 |
2060514 | 2060514 | 2021-12-29 | Madison | Arkansas | 5087 | 2880 | 44 |
2061004 | 2061004 | 2021-12-29 | Jo Daviess | Illinois | 17085 | 2880 | 35 |
2028258 | 2028258 | 2021-12-19 | Banks | Georgia | 13011 | 2880 | 69 |
2025007 | 2025007 | 2021-12-18 | Banks | Georgia | 13011 | 2880 | 69 |
2021756 | 2021756 | 2021-12-17 | Banks | Georgia | 13011 | 2880 | 69 |
2011509 | 2011509 | 2021-12-13 | Wetzel | West Virginia | 54103 | 2880 | 66 |
2008258 | 2008258 | 2021-12-12 | Wetzel | West Virginia | 54103 | 2880 | 65 |
1983408 | 1983408 | 2021-12-05 | Jackson | Kentucky | 21109 | 2880 | 53 |
1985090 | 1985090 | 2021-12-05 | Houston | Texas | 48225 | 2880 | 87 |
1980158 | 1980158 | 2021-12-04 | Jackson | Kentucky | 21109 | 2880 | 53 |
1981840 | 1981840 | 2021-12-04 | Houston | Texas | 48225 | 2880 | 87 |
1976908 | 1976908 | 2021-12-03 | Jackson | Kentucky | 21109 | 2880 | 53 |
1931868 | 1931868 | 2021-11-19 | Cooper | Missouri | 29053 | 2880 | 51 |
1907583 | 1907583 | 2021-11-11 | Lincoln | Wyoming | 56023 | 2880 | 23 |
1904334 | 1904334 | 2021-11-10 | Lincoln | Wyoming | 56023 | 2880 | 23 |
1881734 | 1881734 | 2021-11-04 | Grant | Arkansas | 5053 | 2880 | 50 |
1877298 | 1877298 | 2021-11-02 | McIntosh | Oklahoma | 40091 | 2880 | 92 |
1874049 | 1874049 | 2021-11-01 | McIntosh | Oklahoma | 40091 | 2880 | 92 |
1870800 | 1870800 | 2021-10-31 | McIntosh | Oklahoma | 40091 | 2880 | 92 |
1867551 | 1867551 | 2021-10-30 | McIntosh | Oklahoma | 40091 | 2880 | 92 |
1864302 | 1864302 | 2021-10-29 | McIntosh | Oklahoma | 40091 | 2880 | 92 |
1861053 | 1861053 | 2021-10-28 | McIntosh | Oklahoma | 40091 | 2880 | 92 |
1855737 | 1855737 | 2021-10-27 | Drew | Arkansas | 5043 | 2880 | 54 |
1857804 | 1857804 | 2021-10-27 | McIntosh | Oklahoma | 40091 | 2880 | 92 |
1857903 | 1857903 | 2021-10-27 | Juniata | Pennsylvania | 42067 | 2880 | 115 |
1807631 | 1807631 | 2021-10-12 | Orange | Indiana | 18117 | 2880 | 66 |
1805044 | 1805044 | 2021-10-11 | Clarke | Mississippi | 28023 | 2880 | 93 |
1801795 | 1801795 | 2021-10-10 | Clarke | Mississippi | 28023 | 2880 | 93 |
1798546 | 1798546 | 2021-10-09 | Clarke | Mississippi | 28023 | 2880 | 93 |
1795297 | 1795297 | 2021-10-08 | Clarke | Mississippi | 28023 | 2880 | 93 |
1759396 | 1759396 | 2021-09-27 | Emmet | Michigan | 26047 | 2880 | 46 |
1740559 | 1740559 | 2021-09-21 | Caswell | North Carolina | 37033 | 2880 | 34 |
1723470 | 1723470 | 2021-09-16 | McCreary | Kentucky | 21147 | 2880 | 37 |
1702649 | 1702649 | 2021-09-09 | Lee | Virginia | 51105 | 2880 | 48 |
1702660 | 1702660 | 2021-09-09 | Mecklenburg | Virginia | 51117 | 2880 | 71 |
1693884 | 1693884 | 2021-09-07 | Fountain | Indiana | 18045 | 2880 | 55 |
1677531 | 1677531 | 2021-09-02 | Douglas | Illinois | 17041 | 2880 | 42 |
1675344 | 1675344 | 2021-09-01 | Cass | Nebraska | 31025 | 2880 | 17 |
1676214 | 1676214 | 2021-09-01 | Fentress | Tennessee | 47049 | 2880 | 50 |
1676375 | 1676375 | 2021-09-01 | Gray | Texas | 48179 | 2880 | 62 |
1668585 | 1668585 | 2021-08-30 | Attala | Mississippi | 28007 | 2880 | 79 |
1665226 | 1665226 | 2021-08-29 | Oceana | Michigan | 26127 | 2880 | 61 |
1661978 | 1661978 | 2021-08-28 | Oceana | Michigan | 26127 | 2880 | 61 |
1658730 | 1658730 | 2021-08-27 | Oceana | Michigan | 26127 | 2880 | 61 |
1611489 | 1611489 | 2021-08-12 | Milam | Texas | 48331 | 2880 | 53 |
1608440 | 1608440 | 2021-08-11 | Hopewell city | Virginia | 51670 | 2880 | 79 |
1596347 | 1596347 | 2021-08-08 | Jersey | Illinois | 17083 | 2880 | 71 |
1593098 | 1593098 | 2021-08-07 | Jersey | Illinois | 17083 | 2880 | 71 |
1589849 | 1589849 | 2021-08-06 | Jersey | Illinois | 17083 | 2880 | 71 |
1585877 | 1585877 | 2021-08-04 | Door | Wisconsin | 55029 | 2880 | 37 |
1576977 | 1576977 | 2021-08-02 | Posey | Indiana | 18129 | 2880 | 35 |
1563607 | 1563607 | 2021-07-29 | Washington | Florida | 12133 | 2880 | 52 |
1560359 | 1560359 | 2021-07-28 | Washington | Florida | 12133 | 2880 | 52 |
1562350 | 1562350 | 2021-07-28 | Mayaguez | Puerto Rico | 72097 | 2880 | |
1557112 | 1557112 | 2021-07-27 | Washington | Florida | 12133 | 2880 | 52 |
1558330 | 1558330 | 2021-07-27 | Washington | Missouri | 29221 | 2880 | 53 |
1553865 | 1553865 | 2021-07-26 | Washington | Florida | 12133 | 2880 | 52 |
1550618 | 1550618 | 2021-07-25 | Washington | Florida | 12133 | 2880 | 52 |
1547371 | 1547371 | 2021-07-24 | Washington | Florida | 12133 | 2880 | 52 |
1544124 | 1544124 | 2021-07-23 | Washington | Florida | 12133 | 2880 | 52 |
1541888 | 1541888 | 2021-07-22 | Todd | Minnesota | 27153 | 2880 | 33 |
1536762 | 1536762 | 2021-07-20 | Limestone | Texas | 48293 | 2880 | 80 |
1474889 | 1474889 | 2021-07-01 | McNairy | Tennessee | 47109 | 2880 | 55 |
1475007 | 1475007 | 2021-07-01 | Frio | Texas | 48163 | 2880 | 52 |
1470212 | 1470212 | 2021-06-30 | Morehouse | Louisiana | 22067 | 2880 | 78 |
1466544 | 1466544 | 2021-06-29 | Greene | Indiana | 18055 | 2880 | 89 |
1463299 | 1463299 | 2021-06-28 | Greene | Indiana | 18055 | 2880 | 89 |
1430372 | 1430372 | 2021-06-18 | Delta | Colorado | 8029 | 2880 | 64 |
1418205 | 1418205 | 2021-06-14 | Marshall | Kentucky | 21157 | 2880 | 58 |
1372764 | 1372764 | 2021-05-31 | Logan | Kentucky | 21141 | 2880 | 67 |
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);