ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
287 rows where cases = 2213 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 25
- Georgia 21
- Kentucky 21
- Mississippi 21
- Michigan 19
- Arizona 14
- Virginia 13
- Indiana 11
- Tennessee 11
- Missouri 10
- Iowa 9
- North Carolina 9
- Alabama 8
- Florida 8
- Ohio 8
- Arkansas 7
- Washington 6
- California 5
- Minnesota 5
- West Virginia 5
- Louisiana 4
- New York 4
- Puerto Rico 4
- South Dakota 4
- Wisconsin 4
- Colorado 3
- Idaho 3
- Kansas 3
- Maine 3
- South Carolina 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502211 | 2502211 | 2022-05-13 | Archer | Texas | 48009 | 2213 | 28 |
2475044 | 2475044 | 2022-05-05 | DeKalb | Missouri | 29063 | 2213 | 47 |
2468251 | 2468251 | 2022-05-03 | Baraga | Michigan | 26013 | 2213 | 54 |
2464996 | 2464996 | 2022-05-02 | Baraga | Michigan | 26013 | 2213 | 54 |
2461740 | 2461740 | 2022-05-01 | Baraga | Michigan | 26013 | 2213 | 54 |
2458484 | 2458484 | 2022-04-30 | Baraga | Michigan | 26013 | 2213 | 54 |
2455228 | 2455228 | 2022-04-29 | Baraga | Michigan | 26013 | 2213 | 54 |
2451972 | 2451972 | 2022-04-28 | Baraga | Michigan | 26013 | 2213 | 54 |
2448716 | 2448716 | 2022-04-27 | Baraga | Michigan | 26013 | 2213 | 54 |
2438738 | 2438738 | 2022-04-24 | Gallatin | Kentucky | 21077 | 2213 | 49 |
2435482 | 2435482 | 2022-04-23 | Gallatin | Kentucky | 21077 | 2213 | 49 |
2432226 | 2432226 | 2022-04-22 | Gallatin | Kentucky | 21077 | 2213 | 49 |
2428970 | 2428970 | 2022-04-21 | Gallatin | Kentucky | 21077 | 2213 | 49 |
2425714 | 2425714 | 2022-04-20 | Gallatin | Kentucky | 21077 | 2213 | 49 |
2422458 | 2422458 | 2022-04-19 | Gallatin | Kentucky | 21077 | 2213 | 49 |
2419202 | 2419202 | 2022-04-18 | Gallatin | Kentucky | 21077 | 2213 | 49 |
2353169 | 2353169 | 2022-03-29 | Greenlee | Arizona | 4011 | 2213 | 32 |
2349917 | 2349917 | 2022-03-28 | Greenlee | Arizona | 4011 | 2213 | 32 |
2346664 | 2346664 | 2022-03-27 | Greenlee | Arizona | 4011 | 2213 | 32 |
2343411 | 2343411 | 2022-03-26 | Greenlee | Arizona | 4011 | 2213 | 32 |
2340158 | 2340158 | 2022-03-25 | Greenlee | Arizona | 4011 | 2213 | 32 |
2336905 | 2336905 | 2022-03-24 | Greenlee | Arizona | 4011 | 2213 | 32 |
2333651 | 2333651 | 2022-03-23 | Greenlee | Arizona | 4011 | 2213 | 32 |
2330397 | 2330397 | 2022-03-22 | Greenlee | Arizona | 4011 | 2213 | 32 |
2327145 | 2327145 | 2022-03-21 | Greenlee | Arizona | 4011 | 2213 | 32 |
2323892 | 2323892 | 2022-03-20 | Greenlee | Arizona | 4011 | 2213 | 32 |
2320638 | 2320638 | 2022-03-19 | Greenlee | Arizona | 4011 | 2213 | 32 |
2322930 | 2322930 | 2022-03-19 | Penuelas | Puerto Rico | 72111 | 2213 | |
2317384 | 2317384 | 2022-03-18 | Greenlee | Arizona | 4011 | 2213 | 32 |
2314131 | 2314131 | 2022-03-17 | Greenlee | Arizona | 4011 | 2213 | 32 |
2310878 | 2310878 | 2022-03-16 | Greenlee | Arizona | 4011 | 2213 | 32 |
2301932 | 2301932 | 2022-03-13 | Cloud | Kansas | 20029 | 2213 | 36 |
2302446 | 2302446 | 2022-03-13 | Choctaw | Mississippi | 28019 | 2213 | 33 |
2298680 | 2298680 | 2022-03-12 | Cloud | Kansas | 20029 | 2213 | 36 |
2299194 | 2299194 | 2022-03-12 | Choctaw | Mississippi | 28019 | 2213 | 33 |
2295428 | 2295428 | 2022-03-11 | Cloud | Kansas | 20029 | 2213 | 36 |
2295942 | 2295942 | 2022-03-11 | Choctaw | Mississippi | 28019 | 2213 | 33 |
2292690 | 2292690 | 2022-03-10 | Choctaw | Mississippi | 28019 | 2213 | 33 |
2289438 | 2289438 | 2022-03-09 | Choctaw | Mississippi | 28019 | 2213 | 33 |
2286187 | 2286187 | 2022-03-08 | Choctaw | Mississippi | 28019 | 2213 | 33 |
2282935 | 2282935 | 2022-03-07 | Choctaw | Mississippi | 28019 | 2213 | 33 |
2225276 | 2225276 | 2022-02-17 | Forest | Pennsylvania | 42053 | 2213 | 34 |
2213353 | 2213353 | 2022-02-14 | Cleveland | Arkansas | 5025 | 2213 | 33 |
2213809 | 2213809 | 2022-02-14 | Fremont | Idaho | 16043 | 2213 | 24 |
2210101 | 2210101 | 2022-02-13 | Cleveland | Arkansas | 5025 | 2213 | 33 |
2199856 | 2199856 | 2022-02-09 | Grand | Utah | 49019 | 2213 | 6 |
2194259 | 2194259 | 2022-02-08 | Wilkes | Georgia | 13317 | 2213 | 44 |
2187680 | 2187680 | 2022-02-06 | Lanier | Georgia | 13173 | 2213 | 18 |
2184427 | 2184427 | 2022-02-05 | Lanier | Georgia | 13173 | 2213 | 18 |
2181175 | 2181175 | 2022-02-04 | Lanier | Georgia | 13173 | 2213 | 18 |
2125313 | 2125313 | 2022-01-17 | Forest | Wisconsin | 55041 | 2213 | 47 |
2109889 | 2109889 | 2022-01-13 | Newton | Indiana | 18111 | 2213 | 61 |
2103469 | 2103469 | 2022-01-11 | Humboldt | Iowa | 19091 | 2213 | 33 |
2100218 | 2100218 | 2022-01-10 | Humboldt | Iowa | 19091 | 2213 | 33 |
2096967 | 2096967 | 2022-01-09 | Humboldt | Iowa | 19091 | 2213 | 33 |
2093715 | 2093715 | 2022-01-08 | Humboldt | Iowa | 19091 | 2213 | 33 |
2090463 | 2090463 | 2022-01-07 | Humboldt | Iowa | 19091 | 2213 | 33 |
2091211 | 2091211 | 2022-01-07 | Ripley | Missouri | 29181 | 2213 | 52 |
2087212 | 2087212 | 2022-01-06 | Humboldt | Iowa | 19091 | 2213 | 33 |
2083960 | 2083960 | 2022-01-05 | Humboldt | Iowa | 19091 | 2213 | 33 |
2077211 | 2077211 | 2022-01-03 | Shoshone | Idaho | 16079 | 2213 | 67 |
2051912 | 2051912 | 2021-12-26 | Missaukee | Michigan | 26113 | 2213 | 45 |
2048662 | 2048662 | 2021-12-25 | Missaukee | Michigan | 26113 | 2213 | 45 |
2045412 | 2045412 | 2021-12-24 | Missaukee | Michigan | 26113 | 2213 | 45 |
2042162 | 2042162 | 2021-12-23 | Missaukee | Michigan | 26113 | 2213 | 45 |
2038913 | 2038913 | 2021-12-22 | Missaukee | Michigan | 26113 | 2213 | 45 |
2023252 | 2023252 | 2021-12-17 | Schuyler | New York | 36097 | 2213 | 22 |
2016247 | 2016247 | 2021-12-15 | Pope | Minnesota | 27121 | 2213 | 10 |
1997965 | 1997965 | 2021-12-09 | Stewart | Tennessee | 47161 | 2213 | 39 |
1993426 | 1993426 | 2021-12-08 | Unknown | Michigan | 2213 | 20 | |
1994714 | 1994714 | 2021-12-08 | Stewart | Tennessee | 47161 | 2213 | 39 |
1985751 | 1985751 | 2021-12-06 | Lee | Arkansas | 5077 | 2213 | 52 |
1984711 | 1984711 | 2021-12-05 | Fajardo | Puerto Rico | 72053 | 2213 | |
1981225 | 1981225 | 2021-12-04 | Noble | Ohio | 39121 | 2213 | 49 |
1961089 | 1961089 | 2021-11-28 | Walthall | Mississippi | 28147 | 2213 | 66 |
1962478 | 1962478 | 2021-11-28 | Zapata | Texas | 48505 | 2213 | 46 |
1957838 | 1957838 | 2021-11-27 | Walthall | Mississippi | 28147 | 2213 | 66 |
1959227 | 1959227 | 2021-11-27 | Zapata | Texas | 48505 | 2213 | 46 |
1954587 | 1954587 | 2021-11-26 | Walthall | Mississippi | 28147 | 2213 | 66 |
1955976 | 1955976 | 2021-11-26 | Zapata | Texas | 48505 | 2213 | 46 |
1951336 | 1951336 | 2021-11-25 | Walthall | Mississippi | 28147 | 2213 | 66 |
1952725 | 1952725 | 2021-11-25 | Zapata | Texas | 48505 | 2213 | 46 |
1948085 | 1948085 | 2021-11-24 | Walthall | Mississippi | 28147 | 2213 | 66 |
1949474 | 1949474 | 2021-11-24 | Zapata | Texas | 48505 | 2213 | 46 |
1944834 | 1944834 | 2021-11-23 | Walthall | Mississippi | 28147 | 2213 | 66 |
1946223 | 1946223 | 2021-11-23 | Zapata | Texas | 48505 | 2213 | 45 |
1941583 | 1941583 | 2021-11-22 | Walthall | Mississippi | 28147 | 2213 | 66 |
1929971 | 1929971 | 2021-11-18 | Zapata | Texas | 48505 | 2213 | 45 |
1924274 | 1924274 | 2021-11-17 | Dade | Georgia | 13083 | 2213 | 21 |
1926433 | 1926433 | 2021-11-17 | Meigs | Tennessee | 47121 | 2213 | 30 |
1926721 | 1926721 | 2021-11-17 | Zapata | Texas | 48505 | 2213 | 45 |
1923673 | 1923673 | 2021-11-16 | Klickitat | Washington | 53039 | 2213 | 26 |
1908788 | 1908788 | 2021-11-12 | Knox | Maine | 23013 | 2213 | 13 |
1905458 | 1905458 | 2021-11-11 | Trigg | Kentucky | 21221 | 2213 | 23 |
1905539 | 1905539 | 2021-11-11 | Knox | Maine | 23013 | 2213 | 13 |
1902208 | 1902208 | 2021-11-10 | Trigg | Kentucky | 21221 | 2213 | 23 |
1898428 | 1898428 | 2021-11-09 | Idaho | Idaho | 16049 | 2213 | 36 |
1881952 | 1881952 | 2021-11-04 | Lafayette | Florida | 12067 | 2213 | 35 |
1882096 | 1882096 | 2021-11-04 | Oglethorpe | Georgia | 13221 | 2213 | 41 |
1878703 | 1878703 | 2021-11-03 | Lafayette | Florida | 12067 | 2213 | 35 |
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);