ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
220 rows where cases = 2744 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 30
- Iowa 17
- Georgia 16
- North Carolina 16
- Missouri 15
- Illinois 10
- Indiana 10
- Kentucky 10
- Virginia 7
- West Virginia 7
- Wisconsin 7
- Alabama 5
- Florida 5
- Puerto Rico 5
- Arkansas 4
- Colorado 4
- Michigan 4
- Ohio 4
- Alaska 3
- Kansas 3
- Louisiana 3
- Minnesota 3
- Montana 3
- Oregon 3
- Maryland 2
- Mississippi 2
- Nevada 2
- New Mexico 2
- Pennsylvania 2
- South Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476329 | 2476329 | 2022-05-05 | Pecos | Texas | 48371 | 2744 | 71 |
2472621 | 2472621 | 2022-05-04 | Florida | Puerto Rico | 72054 | 2744 | |
2473072 | 2473072 | 2022-05-04 | Pecos | Texas | 48371 | 2744 | 71 |
2469816 | 2469816 | 2022-05-03 | Pecos | Texas | 48371 | 2744 | 71 |
2466560 | 2466560 | 2022-05-02 | Pecos | Texas | 48371 | 2744 | 71 |
2463305 | 2463305 | 2022-05-01 | Pecos | Texas | 48371 | 2744 | 71 |
2460049 | 2460049 | 2022-04-30 | Pecos | Texas | 48371 | 2744 | 71 |
2456793 | 2456793 | 2022-04-29 | Pecos | Texas | 48371 | 2744 | 71 |
2453099 | 2453099 | 2022-04-28 | Lajas | Puerto Rico | 72079 | 2744 | |
2453537 | 2453537 | 2022-04-28 | Pecos | Texas | 48371 | 2744 | 71 |
2450281 | 2450281 | 2022-04-27 | Pecos | Texas | 48371 | 2744 | 71 |
2447024 | 2447024 | 2022-04-26 | Pecos | Texas | 48371 | 2744 | 71 |
2400607 | 2400607 | 2022-04-12 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2397204 | 2397204 | 2022-04-11 | Los Alamos | New Mexico | 35028 | 2744 | 16 |
2397352 | 2397352 | 2022-04-11 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2394097 | 2394097 | 2022-04-10 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2390841 | 2390841 | 2022-04-09 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2387585 | 2387585 | 2022-04-08 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2384330 | 2384330 | 2022-04-07 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2381075 | 2381075 | 2022-04-06 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2377820 | 2377820 | 2022-04-05 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2374567 | 2374567 | 2022-04-04 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2371315 | 2371315 | 2022-04-03 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2368062 | 2368062 | 2022-04-02 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2364809 | 2364809 | 2022-04-01 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2361555 | 2361555 | 2022-03-31 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2358301 | 2358301 | 2022-03-30 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2316009 | 2316009 | 2022-03-17 | Perquimans | North Carolina | 37143 | 2744 | 18 |
2291704 | 2291704 | 2022-03-10 | Early | Georgia | 13099 | 2744 | 60 |
2291925 | 2291925 | 2022-03-10 | Marshall | Illinois | 17123 | 2744 | 33 |
2288452 | 2288452 | 2022-03-09 | Early | Georgia | 13099 | 2744 | 60 |
2285201 | 2285201 | 2022-03-08 | Early | Georgia | 13099 | 2744 | 60 |
2281949 | 2281949 | 2022-03-07 | Early | Georgia | 13099 | 2744 | 60 |
2236994 | 2236994 | 2022-02-21 | Bath | Kentucky | 21011 | 2744 | 37 |
2219137 | 2219137 | 2022-02-15 | Callahan | Texas | 48059 | 2744 | 70 |
2171228 | 2171228 | 2022-02-01 | Moffat | Colorado | 8081 | 2744 | 51 |
2143890 | 2143890 | 2022-01-23 | Baker | Oregon | 41001 | 2744 | 40 |
2140635 | 2140635 | 2022-01-22 | Baker | Oregon | 41001 | 2744 | 40 |
2137379 | 2137379 | 2022-01-21 | Baker | Oregon | 41001 | 2744 | 40 |
2115787 | 2115787 | 2022-01-15 | Marion | Arkansas | 5089 | 2744 | 76 |
2106573 | 2106573 | 2022-01-12 | Wabash | Illinois | 17185 | 2744 | 22 |
2105262 | 2105262 | 2022-01-11 | Bandera | Texas | 48019 | 2744 | 65 |
2100421 | 2100421 | 2022-01-10 | Green | Kentucky | 21087 | 2744 | 40 |
2100439 | 2100439 | 2022-01-10 | Larue | Kentucky | 21123 | 2744 | 57 |
2089604 | 2089604 | 2022-01-06 | Goshen | Wyoming | 56015 | 2744 | 53 |
2082745 | 2082745 | 2022-01-04 | Zavala | Texas | 48507 | 2744 | 56 |
2083054 | 2083054 | 2022-01-04 | Lafayette | Wisconsin | 55065 | 2744 | 18 |
2058297 | 2058297 | 2021-12-28 | Winn | Louisiana | 22127 | 2744 | 58 |
2006005 | 2006005 | 2021-12-12 | Atchison | Kansas | 20005 | 2744 | 26 |
2006754 | 2006754 | 2021-12-12 | Park | Montana | 30067 | 2744 | 30 |
2002754 | 2002754 | 2021-12-11 | Atchison | Kansas | 20005 | 2744 | 26 |
2003503 | 2003503 | 2021-12-11 | Park | Montana | 30067 | 2744 | 30 |
1999504 | 1999504 | 2021-12-10 | Atchison | Kansas | 20005 | 2744 | 26 |
2000253 | 2000253 | 2021-12-10 | Park | Montana | 30067 | 2744 | 30 |
1992014 | 1992014 | 2021-12-07 | Burnett | Wisconsin | 55013 | 2744 | 33 |
1988763 | 1988763 | 2021-12-06 | Burnett | Wisconsin | 55013 | 2744 | 33 |
1985513 | 1985513 | 2021-12-05 | Burnett | Wisconsin | 55013 | 2744 | 33 |
1982263 | 1982263 | 2021-12-04 | Burnett | Wisconsin | 55013 | 2744 | 33 |
1979013 | 1979013 | 2021-12-03 | Burnett | Wisconsin | 55013 | 2744 | 33 |
1961170 | 1961170 | 2021-11-28 | Morgan | Missouri | 29141 | 2744 | 72 |
1962752 | 1962752 | 2021-11-28 | Wetzel | West Virginia | 54103 | 2744 | 61 |
1957919 | 1957919 | 2021-11-27 | Morgan | Missouri | 29141 | 2744 | 72 |
1959501 | 1959501 | 2021-11-27 | Wetzel | West Virginia | 54103 | 2744 | 61 |
1954668 | 1954668 | 2021-11-26 | Morgan | Missouri | 29141 | 2744 | 72 |
1956250 | 1956250 | 2021-11-26 | Wetzel | West Virginia | 54103 | 2744 | 61 |
1951417 | 1951417 | 2021-11-25 | Morgan | Missouri | 29141 | 2744 | 72 |
1952999 | 1952999 | 2021-11-25 | Wetzel | West Virginia | 54103 | 2744 | 61 |
1948166 | 1948166 | 2021-11-24 | Morgan | Missouri | 29141 | 2744 | 72 |
1949748 | 1949748 | 2021-11-24 | Wetzel | West Virginia | 54103 | 2744 | 61 |
1921050 | 1921050 | 2021-11-16 | Greene | Georgia | 13133 | 2744 | 73 |
1922638 | 1922638 | 2021-11-16 | Richland | North Dakota | 38077 | 2744 | 21 |
1918110 | 1918110 | 2021-11-15 | Perry | Indiana | 18123 | 2744 | 55 |
1918493 | 1918493 | 2021-11-15 | LaSalle | Louisiana | 22059 | 2744 | 46 |
1898684 | 1898684 | 2021-11-09 | Hardin | Iowa | 19083 | 2744 | 52 |
1895434 | 1895434 | 2021-11-08 | Hardin | Iowa | 19083 | 2744 | 52 |
1891429 | 1891429 | 2021-11-07 | North Slope Borough | Alaska | 2185 | 2744 | 6 |
1892184 | 1892184 | 2021-11-07 | Hardin | Iowa | 19083 | 2744 | 52 |
1888179 | 1888179 | 2021-11-06 | North Slope Borough | Alaska | 2185 | 2744 | 6 |
1888934 | 1888934 | 2021-11-06 | Hardin | Iowa | 19083 | 2744 | 52 |
1884929 | 1884929 | 2021-11-05 | North Slope Borough | Alaska | 2185 | 2744 | 6 |
1885684 | 1885684 | 2021-11-05 | Hardin | Iowa | 19083 | 2744 | 52 |
1882435 | 1882435 | 2021-11-04 | Hardin | Iowa | 19083 | 2744 | 52 |
1879186 | 1879186 | 2021-11-03 | Hardin | Iowa | 19083 | 2744 | 52 |
1881447 | 1881447 | 2021-11-03 | Barbour | West Virginia | 54001 | 2744 | 45 |
1857935 | 1857935 | 2021-10-27 | Wyoming | Pennsylvania | 42131 | 2744 | 63 |
1849503 | 1849503 | 2021-10-25 | Banks | Georgia | 13011 | 2744 | 60 |
1846492 | 1846492 | 2021-10-24 | Hancock | Illinois | 17067 | 2744 | 45 |
1848562 | 1848562 | 2021-10-24 | Freestone | Texas | 48161 | 2744 | 67 |
1843242 | 1843242 | 2021-10-23 | Hancock | Illinois | 17067 | 2744 | 45 |
1845312 | 1845312 | 2021-10-23 | Freestone | Texas | 48161 | 2744 | 67 |
1839992 | 1839992 | 2021-10-22 | Hancock | Illinois | 17067 | 2744 | 45 |
1834619 | 1834619 | 2021-10-20 | Washington | Nebraska | 31177 | 2744 | 29 |
1830416 | 1830416 | 2021-10-19 | Buchanan | Iowa | 19019 | 2744 | 39 |
1826666 | 1826666 | 2021-10-18 | Teller | Colorado | 8119 | 2744 | 25 |
1827167 | 1827167 | 2021-10-18 | Buchanan | Iowa | 19019 | 2744 | 39 |
1823918 | 1823918 | 2021-10-17 | Buchanan | Iowa | 19019 | 2744 | 39 |
1820669 | 1820669 | 2021-10-16 | Buchanan | Iowa | 19019 | 2744 | 39 |
1817420 | 1817420 | 2021-10-15 | Buchanan | Iowa | 19019 | 2744 | 39 |
1814172 | 1814172 | 2021-10-14 | Buchanan | Iowa | 19019 | 2744 | 39 |
1810923 | 1810923 | 2021-10-13 | Buchanan | Iowa | 19019 | 2744 | 39 |
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);