ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
222 rows where cases = 2478 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 30
- Georgia 15
- Indiana 15
- Ohio 12
- Mississippi 11
- Virginia 11
- Florida 9
- Louisiana 9
- Puerto Rico 9
- Tennessee 9
- California 8
- Kentucky 8
- Oklahoma 7
- West Virginia 7
- Missouri 6
- Iowa 5
- Pennsylvania 5
- Alabama 4
- Arkansas 4
- Michigan 4
- Minnesota 4
- Wisconsin 4
- Utah 3
- Arizona 2
- Colorado 2
- Illinois 2
- Maryland 2
- New York 2
- North Carolina 2
- South Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486179 | 2486179 | 2022-05-08 | Emery | Utah | 49015 | 2478 | 28 |
2428636 | 2428636 | 2022-04-21 | Benton | Indiana | 18007 | 2478 | 21 |
2425380 | 2425380 | 2022-04-20 | Benton | Indiana | 18007 | 2478 | 21 |
2313633 | 2313633 | 2022-03-16 | Trinity | Texas | 48455 | 2478 | 72 |
2262245 | 2262245 | 2022-03-01 | Bent | Colorado | 8011 | 2478 | 47 |
2255040 | 2255040 | 2022-02-26 | Morris | Texas | 48343 | 2478 | 68 |
2243628 | 2243628 | 2022-02-23 | East Carroll | Louisiana | 22035 | 2478 | 35 |
2243904 | 2243904 | 2022-02-23 | Yellow Medicine | Minnesota | 27173 | 2478 | 28 |
2240377 | 2240377 | 2022-02-22 | East Carroll | Louisiana | 22035 | 2478 | 35 |
2237126 | 2237126 | 2022-02-21 | East Carroll | Louisiana | 22035 | 2478 | 35 |
2231886 | 2231886 | 2022-02-19 | Santa Isabel | Puerto Rico | 72133 | 2478 | |
2213947 | 2213947 | 2022-02-14 | Crawford | Indiana | 18025 | 2478 | 35 |
2190622 | 2190622 | 2022-02-07 | Pike | Arkansas | 5109 | 2478 | 39 |
2192287 | 2192287 | 2022-02-07 | Los Alamos | New Mexico | 35028 | 2478 | 12 |
2187369 | 2187369 | 2022-02-06 | Pike | Arkansas | 5109 | 2478 | 39 |
2187736 | 2187736 | 2022-02-06 | Turner | Georgia | 13287 | 2478 | 50 |
2184116 | 2184116 | 2022-02-05 | Pike | Arkansas | 5109 | 2478 | 39 |
2184483 | 2184483 | 2022-02-05 | Turner | Georgia | 13287 | 2478 | 50 |
2181231 | 2181231 | 2022-02-04 | Turner | Georgia | 13287 | 2478 | 50 |
2149251 | 2149251 | 2022-01-25 | Metcalfe | Kentucky | 21169 | 2478 | 54 |
2144524 | 2144524 | 2022-01-23 | Ward | Texas | 48475 | 2478 | 39 |
2089041 | 2089041 | 2022-01-06 | Comanche | Texas | 48093 | 2478 | 67 |
2023479 | 2023479 | 2021-12-17 | Monroe | Ohio | 39111 | 2478 | 64 |
2019145 | 2019145 | 2021-12-16 | Fleming | Kentucky | 21069 | 2478 | 40 |
2020444 | 2020444 | 2021-12-16 | Aguada | Puerto Rico | 72003 | 2478 | |
2014585 | 2014585 | 2021-12-14 | Giles | Virginia | 51071 | 2478 | 35 |
2007425 | 2007425 | 2021-12-12 | Potter | Pennsylvania | 42105 | 2478 | 70 |
1991251 | 1991251 | 2021-12-07 | San Lorenzo | Puerto Rico | 72129 | 2478 | |
1988000 | 1988000 | 2021-12-06 | San Lorenzo | Puerto Rico | 72129 | 2478 | |
1984750 | 1984750 | 2021-12-05 | San Lorenzo | Puerto Rico | 72129 | 2478 | |
1963616 | 1963616 | 2021-11-29 | Parke | Indiana | 18121 | 2478 | 31 |
1965402 | 1965402 | 2021-11-29 | Decatur | Tennessee | 47039 | 2478 | 44 |
1962454 | 1962454 | 2021-11-28 | Tyler | Texas | 48457 | 2478 | 73 |
1959203 | 1959203 | 2021-11-27 | Tyler | Texas | 48457 | 2478 | 73 |
1955952 | 1955952 | 2021-11-26 | Tyler | Texas | 48457 | 2478 | 73 |
1952701 | 1952701 | 2021-11-25 | Tyler | Texas | 48457 | 2478 | 73 |
1949450 | 1949450 | 2021-11-24 | Tyler | Texas | 48457 | 2478 | 73 |
1946199 | 1946199 | 2021-11-23 | Tyler | Texas | 48457 | 2478 | 73 |
1942948 | 1942948 | 2021-11-22 | Tyler | Texas | 48457 | 2478 | 73 |
1939698 | 1939698 | 2021-11-21 | Tyler | Texas | 48457 | 2478 | 73 |
1936448 | 1936448 | 2021-11-20 | Tyler | Texas | 48457 | 2478 | 73 |
1930027 | 1930027 | 2021-11-18 | Appomattox | Virginia | 51011 | 2478 | 36 |
1917544 | 1917544 | 2021-11-15 | Inyo | California | 6027 | 2478 | 42 |
1904700 | 1904700 | 2021-11-11 | Jefferson | Florida | 12065 | 2478 | 36 |
1901450 | 1901450 | 2021-11-10 | Jefferson | Florida | 12065 | 2478 | 36 |
1898200 | 1898200 | 2021-11-09 | Jefferson | Florida | 12065 | 2478 | 36 |
1894950 | 1894950 | 2021-11-08 | Jefferson | Florida | 12065 | 2478 | 36 |
1896342 | 1896342 | 2021-11-08 | Saline | Nebraska | 31151 | 2478 | 6 |
1891700 | 1891700 | 2021-11-07 | Jefferson | Florida | 12065 | 2478 | 36 |
1888450 | 1888450 | 2021-11-06 | Jefferson | Florida | 12065 | 2478 | 36 |
1885200 | 1885200 | 2021-11-05 | Jefferson | Florida | 12065 | 2478 | 36 |
1877331 | 1877331 | 2021-11-02 | Clatsop | Oregon | 41007 | 2478 | 28 |
1874753 | 1874753 | 2021-11-01 | Unknown | Utah | 2478 | 47 | |
1864904 | 1864904 | 2021-10-29 | Nolan | Texas | 48353 | 2478 | 79 |
1861655 | 1861655 | 2021-10-28 | Nolan | Texas | 48353 | 2478 | 79 |
1833987 | 1833987 | 2021-10-20 | Bienville | Louisiana | 22013 | 2478 | 95 |
1830738 | 1830738 | 2021-10-19 | Bienville | Louisiana | 22013 | 2478 | 95 |
1810626 | 1810626 | 2021-10-13 | Rabun | Georgia | 13241 | 2478 | 58 |
1793720 | 1793720 | 2021-10-07 | Barbour | West Virginia | 54001 | 2478 | 43 |
1789951 | 1789951 | 2021-10-06 | Lewis | Tennessee | 47101 | 2478 | 37 |
1786703 | 1786703 | 2021-10-05 | Lewis | Tennessee | 47101 | 2478 | 37 |
1762090 | 1762090 | 2021-09-28 | Carroll | Indiana | 18015 | 2478 | 32 |
1759743 | 1759743 | 2021-09-27 | Wright | Missouri | 29229 | 2478 | 46 |
1756495 | 1756495 | 2021-09-26 | Wright | Missouri | 29229 | 2478 | 46 |
1754752 | 1754752 | 2021-09-25 | Lewis | West Virginia | 54041 | 2478 | 36 |
1743453 | 1743453 | 2021-09-22 | Moniteau | Missouri | 29135 | 2478 | 38 |
1734436 | 1734436 | 2021-09-19 | Juniata | Pennsylvania | 42067 | 2478 | 101 |
1723155 | 1723155 | 2021-09-16 | Perry | Indiana | 18123 | 2478 | 52 |
1720249 | 1720249 | 2021-09-15 | Spencer | Kentucky | 21215 | 2478 | 26 |
1697554 | 1697554 | 2021-09-08 | LaSalle | Louisiana | 22059 | 2478 | 41 |
1695352 | 1695352 | 2021-09-07 | Marshall | Oklahoma | 40095 | 2478 | 25 |
1691330 | 1691330 | 2021-09-06 | Calhoun | Mississippi | 28013 | 2478 | 37 |
1692104 | 1692104 | 2021-09-06 | Marshall | Oklahoma | 40095 | 2478 | 25 |
1688855 | 1688855 | 2021-09-05 | Marshall | Oklahoma | 40095 | 2478 | 25 |
1689397 | 1689397 | 2021-09-05 | Houston | Texas | 48225 | 2478 | 64 |
1685605 | 1685605 | 2021-09-04 | Marshall | Oklahoma | 40095 | 2478 | 25 |
1682354 | 1682354 | 2021-09-03 | Marshall | Oklahoma | 40095 | 2478 | 25 |
1679104 | 1679104 | 2021-09-02 | Marshall | Oklahoma | 40095 | 2478 | 25 |
1675299 | 1675299 | 2021-09-01 | Lake | Montana | 30047 | 2478 | 43 |
1675856 | 1675856 | 2021-09-01 | Marshall | Oklahoma | 40095 | 2478 | 25 |
1673443 | 1673443 | 2021-08-31 | Radford city | Virginia | 51750 | 2478 | 29 |
1673538 | 1673538 | 2021-08-31 | Mason | West Virginia | 54053 | 2478 | 40 |
1670319 | 1670319 | 2021-08-30 | Wyoming | West Virginia | 54109 | 2478 | 41 |
1655292 | 1655292 | 2021-08-26 | Wayne | Kentucky | 21231 | 2478 | 53 |
1655421 | 1655421 | 2021-08-26 | Alpena | Michigan | 26007 | 2478 | 66 |
1652045 | 1652045 | 2021-08-25 | Wayne | Kentucky | 21231 | 2478 | 53 |
1652174 | 1652174 | 2021-08-25 | Alpena | Michigan | 26007 | 2478 | 66 |
1644220 | 1644220 | 2021-08-22 | Russell | Virginia | 51167 | 2478 | 40 |
1640970 | 1640970 | 2021-08-21 | Russell | Virginia | 51167 | 2478 | 40 |
1637720 | 1637720 | 2021-08-20 | Russell | Virginia | 51167 | 2478 | 40 |
1614353 | 1614353 | 2021-08-13 | Vega Alta | Puerto Rico | 72143 | 2478 | |
1606945 | 1606945 | 2021-08-11 | Winston | Mississippi | 28159 | 2478 | 85 |
1592026 | 1592026 | 2021-08-06 | Reeves | Texas | 48389 | 2478 | 45 |
1589175 | 1589175 | 2021-08-05 | Vilas | Wisconsin | 55125 | 2478 | 45 |
1583359 | 1583359 | 2021-08-04 | Lawrence | Illinois | 17101 | 2478 | 36 |
1585715 | 1585715 | 2021-08-04 | Mecklenburg | Virginia | 51117 | 2478 | 68 |
1562543 | 1562543 | 2021-07-28 | Johnson | Tennessee | 47091 | 2478 | 39 |
1555418 | 1555418 | 2021-07-26 | Greene | North Carolina | 37079 | 2478 | 48 |
1527730 | 1527730 | 2021-07-18 | Siskiyou | California | 6093 | 2478 | 40 |
1524483 | 1524483 | 2021-07-17 | Siskiyou | California | 6093 | 2478 | 40 |
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);