ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
223 rows where cases = 2193 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 23
- Texas 23
- Virginia 18
- Iowa 16
- Missouri 11
- North Carolina 9
- Puerto Rico 9
- Mississippi 8
- Oklahoma 8
- West Virginia 8
- Arkansas 7
- Idaho 6
- Illinois 6
- Indiana 6
- Minnesota 6
- Kentucky 5
- Louisiana 5
- Florida 4
- Nebraska 4
- Washington 4
- California 3
- Michigan 3
- Nevada 3
- North Dakota 3
- Ohio 3
- Tennessee 3
- Arizona 2
- Colorado 2
- Kansas 2
- New York 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473276 | 2473276 | 2022-05-04 | Northumberland | Virginia | 51133 | 2193 | 46 |
2398084 | 2398084 | 2022-04-11 | Gaines | Texas | 48165 | 2193 | 83 |
2394829 | 2394829 | 2022-04-10 | Gaines | Texas | 48165 | 2193 | 83 |
2391573 | 2391573 | 2022-04-09 | Gaines | Texas | 48165 | 2193 | 83 |
2338349 | 2338349 | 2022-03-24 | Iron | Missouri | 29093 | 2193 | 43 |
2330193 | 2330193 | 2022-03-21 | Tyler | West Virginia | 54095 | 2193 | 31 |
2326941 | 2326941 | 2022-03-20 | Tyler | West Virginia | 54095 | 2193 | 31 |
2323688 | 2323688 | 2022-03-19 | Tyler | West Virginia | 54095 | 2193 | 31 |
2320434 | 2320434 | 2022-03-18 | Tyler | West Virginia | 54095 | 2193 | 31 |
2316366 | 2316366 | 2022-03-17 | Adjuntas | Puerto Rico | 72001 | 2193 | |
2317180 | 2317180 | 2022-03-17 | Tyler | West Virginia | 54095 | 2193 | 31 |
2310609 | 2310609 | 2022-03-15 | Lincoln | Washington | 53043 | 2193 | 27 |
2307356 | 2307356 | 2022-03-14 | Lincoln | Washington | 53043 | 2193 | 27 |
2304025 | 2304025 | 2022-03-13 | Madison | Virginia | 51113 | 2193 | 37 |
2300773 | 2300773 | 2022-03-12 | Madison | Virginia | 51113 | 2193 | 37 |
2297521 | 2297521 | 2022-03-11 | Madison | Virginia | 51113 | 2193 | 37 |
2285627 | 2285627 | 2022-03-08 | Montgomery | Iowa | 19137 | 2193 | 52 |
2282375 | 2282375 | 2022-03-07 | Montgomery | Iowa | 19137 | 2193 | 52 |
2279122 | 2279122 | 2022-03-06 | Montgomery | Iowa | 19137 | 2193 | 52 |
2275869 | 2275869 | 2022-03-05 | Montgomery | Iowa | 19137 | 2193 | 52 |
2272616 | 2272616 | 2022-03-04 | Montgomery | Iowa | 19137 | 2193 | 52 |
2274142 | 2274142 | 2022-03-04 | Penuelas | Puerto Rico | 72111 | 2193 | |
2269364 | 2269364 | 2022-03-03 | Montgomery | Iowa | 19137 | 2193 | 52 |
2266111 | 2266111 | 2022-03-02 | Montgomery | Iowa | 19137 | 2193 | 52 |
2257170 | 2257170 | 2022-02-27 | Box Butte | Nebraska | 31013 | 2193 | 17 |
2253919 | 2253919 | 2022-02-26 | Box Butte | Nebraska | 31013 | 2193 | 17 |
2250668 | 2250668 | 2022-02-25 | Box Butte | Nebraska | 31013 | 2193 | 17 |
2243007 | 2243007 | 2022-02-23 | Stewart | Georgia | 13259 | 2193 | 31 |
2236581 | 2236581 | 2022-02-21 | Owyhee | Idaho | 16073 | 2193 | 49 |
2233330 | 2233330 | 2022-02-20 | Owyhee | Idaho | 16073 | 2193 | 49 |
2230079 | 2230079 | 2022-02-19 | Owyhee | Idaho | 16073 | 2193 | 49 |
2220803 | 2220803 | 2022-02-16 | Livingston | Kentucky | 21139 | 2193 | 56 |
2190630 | 2190630 | 2022-02-07 | Scott | Arkansas | 5127 | 2193 | 37 |
2187377 | 2187377 | 2022-02-06 | Scott | Arkansas | 5127 | 2193 | 37 |
2171418 | 2171418 | 2022-02-01 | Lanier | Georgia | 13173 | 2193 | 18 |
2174192 | 2174192 | 2022-02-01 | Washakie | Wyoming | 56043 | 2193 | 41 |
2149722 | 2149722 | 2022-01-25 | Linn | Missouri | 29115 | 2193 | 59 |
2134247 | 2134247 | 2022-01-20 | Ciales | Puerto Rico | 72039 | 2193 | |
2108820 | 2108820 | 2022-01-12 | Brunswick | Virginia | 51025 | 2193 | 37 |
2095278 | 2095278 | 2022-01-08 | Utuado | Puerto Rico | 72141 | 2193 | |
2080078 | 2080078 | 2022-01-04 | Mono | California | 6051 | 2193 | 4 |
2059767 | 2059767 | 2021-12-28 | Camp | Texas | 48063 | 2193 | 68 |
1992572 | 1992572 | 2021-12-08 | Jasper | Georgia | 13159 | 2193 | 59 |
1966252 | 1966252 | 2021-11-30 | Lee | Arkansas | 5077 | 2193 | 52 |
1963560 | 1963560 | 2021-11-29 | Blackford | Indiana | 18009 | 2193 | 46 |
1945704 | 1945704 | 2021-11-23 | Fajardo | Puerto Rico | 72053 | 2193 | |
1942453 | 1942453 | 2021-11-22 | Fajardo | Puerto Rico | 72053 | 2193 | |
1923613 | 1923613 | 2021-11-16 | Patrick | Virginia | 51141 | 2193 | 58 |
1898277 | 1898277 | 2021-11-09 | Dade | Georgia | 13083 | 2193 | 21 |
1895708 | 1895708 | 2021-11-08 | Trigg | Kentucky | 21221 | 2193 | 23 |
1889671 | 1889671 | 2021-11-06 | Osage | Missouri | 29151 | 2193 | 23 |
1869263 | 1869263 | 2021-10-31 | Massac | Illinois | 17127 | 2193 | 54 |
1866014 | 1866014 | 2021-10-30 | Massac | Illinois | 17127 | 2193 | 54 |
1862765 | 1862765 | 2021-10-29 | Massac | Illinois | 17127 | 2193 | 54 |
1859929 | 1859929 | 2021-10-28 | Magoffin | Kentucky | 21153 | 2193 | 20 |
1853845 | 1853845 | 2021-10-26 | Walthall | Mississippi | 28147 | 2193 | 64 |
1847293 | 1847293 | 2021-10-24 | Greene | Mississippi | 28041 | 2193 | 48 |
1844043 | 1844043 | 2021-10-23 | Greene | Mississippi | 28041 | 2193 | 48 |
1840793 | 1840793 | 2021-10-22 | Greene | Mississippi | 28041 | 2193 | 48 |
1837298 | 1837298 | 2021-10-21 | Franklin | Maine | 23007 | 2193 | 23 |
1808900 | 1808900 | 2021-10-12 | McKenzie | North Dakota | 38053 | 2193 | 20 |
1809745 | 1809745 | 2021-10-12 | Zapata | Texas | 48505 | 2193 | 43 |
1801718 | 1801718 | 2021-10-10 | Fillmore | Minnesota | 27045 | 2193 | 12 |
1798469 | 1798469 | 2021-10-09 | Fillmore | Minnesota | 27045 | 2193 | 12 |
1795220 | 1795220 | 2021-10-08 | Fillmore | Minnesota | 27045 | 2193 | 12 |
1765781 | 1765781 | 2021-09-29 | Madison | Louisiana | 22065 | 2193 | 51 |
1744928 | 1744928 | 2021-09-22 | Southampton | Virginia | 51175 | 2193 | 59 |
1736453 | 1736453 | 2021-09-20 | Lawrence | Kentucky | 21127 | 2193 | 34 |
1736948 | 1736948 | 2021-09-20 | Madison | Missouri | 29123 | 2193 | 19 |
1731199 | 1731199 | 2021-09-18 | Montour | Pennsylvania | 42093 | 2193 | 68 |
1713048 | 1713048 | 2021-09-13 | Bleckley | Georgia | 13023 | 2193 | 56 |
1708195 | 1708195 | 2021-09-11 | Richland | North Dakota | 38077 | 2193 | 19 |
1700268 | 1700268 | 2021-09-09 | Clay | Illinois | 17025 | 2193 | 52 |
1694798 | 1694798 | 2021-09-07 | Lincoln | Montana | 30053 | 2193 | 34 |
1695128 | 1695128 | 2021-09-07 | Northampton | North Carolina | 37131 | 2193 | 62 |
1675553 | 1675553 | 2021-09-01 | Seneca | New York | 36099 | 2193 | 57 |
1676330 | 1676330 | 2021-09-01 | Colorado | Texas | 48089 | 2193 | 36 |
1655569 | 1655569 | 2021-08-26 | Roseau | Minnesota | 27135 | 2193 | 21 |
1625755 | 1625755 | 2021-08-17 | Clay | Iowa | 19041 | 2193 | 27 |
1627745 | 1627745 | 2021-08-17 | Panola | Texas | 48365 | 2193 | 81 |
1622508 | 1622508 | 2021-08-16 | Clay | Iowa | 19041 | 2193 | 27 |
1618915 | 1618915 | 2021-08-15 | Jeff Davis | Georgia | 13161 | 2193 | 44 |
1619261 | 1619261 | 2021-08-15 | Clay | Iowa | 19041 | 2193 | 27 |
1620394 | 1620394 | 2021-08-15 | Hertford | North Carolina | 37091 | 2193 | 64 |
1615667 | 1615667 | 2021-08-14 | Jeff Davis | Georgia | 13161 | 2193 | 44 |
1616013 | 1616013 | 2021-08-14 | Clay | Iowa | 19041 | 2193 | 27 |
1617146 | 1617146 | 2021-08-14 | Hertford | North Carolina | 37091 | 2193 | 64 |
1612418 | 1612418 | 2021-08-13 | Jeff Davis | Georgia | 13161 | 2193 | 44 |
1612764 | 1612764 | 2021-08-13 | Clay | Iowa | 19041 | 2193 | 27 |
1613898 | 1613898 | 2021-08-13 | Hertford | North Carolina | 37091 | 2193 | 64 |
1609516 | 1609516 | 2021-08-12 | Clay | Iowa | 19041 | 2193 | 27 |
1610126 | 1610126 | 2021-08-12 | Clay | Mississippi | 28025 | 2193 | 55 |
1611852 | 1611852 | 2021-08-12 | Wyoming | West Virginia | 54109 | 2193 | 41 |
1606267 | 1606267 | 2021-08-11 | Clay | Iowa | 19041 | 2193 | 27 |
1604397 | 1604397 | 2021-08-10 | Marshall | Oklahoma | 40095 | 2193 | 23 |
1601148 | 1601148 | 2021-08-09 | Marshall | Oklahoma | 40095 | 2193 | 23 |
1596104 | 1596104 | 2021-08-08 | Berrien | Georgia | 13019 | 2193 | 49 |
1597900 | 1597900 | 2021-08-08 | Marshall | Oklahoma | 40095 | 2193 | 23 |
1592855 | 1592855 | 2021-08-07 | Berrien | Georgia | 13019 | 2193 | 49 |
1594651 | 1594651 | 2021-08-07 | Marshall | Oklahoma | 40095 | 2193 | 23 |
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);