ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
245 rows where cases = 2303 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 27
- Texas 20
- Alabama 13
- Kentucky 13
- Illinois 12
- Indiana 12
- Kansas 9
- Arkansas 8
- Iowa 8
- Louisiana 8
- Tennessee 8
- Florida 7
- Minnesota 7
- Mississippi 7
- Virginia 7
- Maine 6
- Oregon 6
- Puerto Rico 6
- Missouri 5
- Ohio 5
- South Dakota 5
- California 4
- Michigan 4
- Nebraska 4
- North Carolina 4
- West Virginia 4
- Vermont 3
- Wisconsin 3
- Alaska 2
- Arizona 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495885 | 2495885 | 2022-05-11 | Red River | Texas | 48387 | 2303 | 67 |
2492627 | 2492627 | 2022-05-10 | Red River | Texas | 48387 | 2303 | 67 |
2489369 | 2489369 | 2022-05-09 | Red River | Texas | 48387 | 2303 | 67 |
2484691 | 2484691 | 2022-05-08 | Swift | Minnesota | 27151 | 2303 | 33 |
2486111 | 2486111 | 2022-05-08 | Red River | Texas | 48387 | 2303 | 67 |
2481433 | 2481433 | 2022-05-07 | Swift | Minnesota | 27151 | 2303 | 33 |
2482853 | 2482853 | 2022-05-07 | Red River | Texas | 48387 | 2303 | 67 |
2478175 | 2478175 | 2022-05-06 | Swift | Minnesota | 27151 | 2303 | 33 |
2479595 | 2479595 | 2022-05-06 | Red River | Texas | 48387 | 2303 | 67 |
2476337 | 2476337 | 2022-05-05 | Red River | Texas | 48387 | 2303 | 67 |
2473080 | 2473080 | 2022-05-04 | Red River | Texas | 48387 | 2303 | 67 |
2469824 | 2469824 | 2022-05-03 | Red River | Texas | 48387 | 2303 | 67 |
2466568 | 2466568 | 2022-05-02 | Red River | Texas | 48387 | 2303 | 67 |
2463313 | 2463313 | 2022-05-01 | Red River | Texas | 48387 | 2303 | 67 |
2460057 | 2460057 | 2022-04-30 | Red River | Texas | 48387 | 2303 | 67 |
2398631 | 2398631 | 2022-04-12 | Bullock | Alabama | 1011 | 2303 | 53 |
2399201 | 2399201 | 2022-04-12 | Clearwater | Idaho | 16035 | 2303 | 33 |
2395376 | 2395376 | 2022-04-11 | Bullock | Alabama | 1011 | 2303 | 53 |
2379099 | 2379099 | 2022-04-06 | Bullock | Alabama | 1011 | 2303 | 53 |
2375845 | 2375845 | 2022-04-05 | Bullock | Alabama | 1011 | 2303 | 53 |
2372593 | 2372593 | 2022-04-04 | Bullock | Alabama | 1011 | 2303 | 52 |
2369340 | 2369340 | 2022-04-03 | Bullock | Alabama | 1011 | 2303 | 52 |
2366087 | 2366087 | 2022-04-02 | Bullock | Alabama | 1011 | 2303 | 52 |
2362834 | 2362834 | 2022-04-01 | Bullock | Alabama | 1011 | 2303 | 52 |
2359580 | 2359580 | 2022-03-31 | Bullock | Alabama | 1011 | 2303 | 52 |
2287763 | 2287763 | 2022-03-08 | Lunenburg | Virginia | 51111 | 2303 | 30 |
2282292 | 2282292 | 2022-03-07 | Switzerland | Indiana | 18155 | 2303 | 19 |
2279039 | 2279039 | 2022-03-06 | Switzerland | Indiana | 18155 | 2303 | 19 |
2275786 | 2275786 | 2022-03-05 | Switzerland | Indiana | 18155 | 2303 | 19 |
2272533 | 2272533 | 2022-03-04 | Switzerland | Indiana | 18155 | 2303 | 19 |
2240632 | 2240632 | 2022-02-22 | Rock | Minnesota | 27133 | 2303 | 33 |
2239011 | 2239011 | 2022-02-21 | Poquoson city | Virginia | 51735 | 2303 | 27 |
2212482 | 2212482 | 2022-02-13 | Lake | South Dakota | 46079 | 2303 | 27 |
2209229 | 2209229 | 2022-02-12 | Lake | South Dakota | 46079 | 2303 | 27 |
2205976 | 2205976 | 2022-02-11 | Lake | South Dakota | 46079 | 2303 | 27 |
2202723 | 2202723 | 2022-02-10 | Lake | South Dakota | 46079 | 2303 | 27 |
2195322 | 2195322 | 2022-02-08 | Wayne | Missouri | 29223 | 2303 | 44 |
2174631 | 2174631 | 2022-02-02 | Dooly | Georgia | 13093 | 2303 | 63 |
2176570 | 2176570 | 2022-02-02 | Lajas | Puerto Rico | 72079 | 2303 | |
2153073 | 2153073 | 2022-01-26 | Richland | Montana | 30083 | 2303 | 30 |
2142634 | 2142634 | 2022-01-23 | Rice | Kansas | 20159 | 2303 | 17 |
2139379 | 2139379 | 2022-01-22 | Rice | Kansas | 20159 | 2303 | 17 |
2136123 | 2136123 | 2022-01-21 | Rice | Kansas | 20159 | 2303 | 17 |
2133872 | 2133872 | 2022-01-20 | Perquimans | North Carolina | 37143 | 2303 | 17 |
2114737 | 2114737 | 2022-01-14 | Comerio | Puerto Rico | 72045 | 2303 | |
2106170 | 2106170 | 2022-01-12 | Park | Colorado | 8093 | 2303 | 15 |
2095530 | 2095530 | 2022-01-08 | Camp | Texas | 48063 | 2303 | 69 |
2079531 | 2079531 | 2022-01-03 | Lamoille | Vermont | 50015 | 2303 | 11 |
2056471 | 2056471 | 2021-12-27 | Stewart | Tennessee | 47161 | 2303 | 43 |
2040305 | 2040305 | 2021-12-22 | Eastland | Texas | 48133 | 2303 | 88 |
2030121 | 2030121 | 2021-12-19 | Tillamook | Oregon | 41057 | 2303 | 48 |
2026870 | 2026870 | 2021-12-18 | Tillamook | Oregon | 41057 | 2303 | 48 |
2023619 | 2023619 | 2021-12-17 | Tillamook | Oregon | 41057 | 2303 | 48 |
2018540 | 2018540 | 2021-12-16 | Dade | Georgia | 13083 | 2303 | 22 |
2009054 | 2009054 | 2021-12-13 | Washington | Illinois | 17189 | 2303 | 36 |
1995434 | 1995434 | 2021-12-09 | Kusilvak Census Area | Alaska | 2158 | 2303 | 9 |
1992183 | 1992183 | 2021-12-08 | Kusilvak Census Area | Alaska | 2158 | 2303 | 9 |
1993946 | 1993946 | 2021-12-08 | Socorro | New Mexico | 35053 | 2303 | 66 |
1983419 | 1983419 | 2021-12-05 | Leslie | Kentucky | 21131 | 2303 | 32 |
1980169 | 1980169 | 2021-12-04 | Leslie | Kentucky | 21131 | 2303 | 32 |
1976919 | 1976919 | 2021-12-03 | Leslie | Kentucky | 21131 | 2303 | 32 |
1971010 | 1971010 | 2021-12-01 | Roosevelt | Montana | 30085 | 2303 | 61 |
1972332 | 1972332 | 2021-12-01 | Grayson | Virginia | 51077 | 2303 | 52 |
1963513 | 1963513 | 2021-11-29 | Massac | Illinois | 17127 | 2303 | 57 |
1944184 | 1944184 | 2021-11-23 | Harrison | Iowa | 19085 | 2303 | 78 |
1940934 | 1940934 | 2021-11-22 | Harrison | Iowa | 19085 | 2303 | 78 |
1943326 | 1943326 | 2021-11-22 | Converse | Wyoming | 56009 | 2303 | 39 |
1937684 | 1937684 | 2021-11-21 | Harrison | Iowa | 19085 | 2303 | 78 |
1934434 | 1934434 | 2021-11-20 | Harrison | Iowa | 19085 | 2303 | 78 |
1931183 | 1931183 | 2021-11-19 | Harrison | Iowa | 19085 | 2303 | 78 |
1927932 | 1927932 | 2021-11-18 | Harrison | Iowa | 19085 | 2303 | 78 |
1924682 | 1924682 | 2021-11-17 | Harrison | Iowa | 19085 | 2303 | 78 |
1915621 | 1915621 | 2021-11-14 | Dallas | Missouri | 29059 | 2303 | 43 |
1905828 | 1905828 | 2021-11-11 | Tallahatchie | Mississippi | 28135 | 2303 | 52 |
1902579 | 1902579 | 2021-11-10 | Tallahatchie | Mississippi | 28135 | 2303 | 52 |
1898874 | 1898874 | 2021-11-09 | Clinton | Kentucky | 21053 | 2303 | 35 |
1895683 | 1895683 | 2021-11-08 | Monroe | Kentucky | 21171 | 2303 | 61 |
1886902 | 1886902 | 2021-11-05 | Walsh | North Dakota | 38099 | 2303 | 29 |
1887657 | 1887657 | 2021-11-05 | Pecos | Texas | 48371 | 2303 | 50 |
1875513 | 1875513 | 2021-11-02 | Charlton | Georgia | 13049 | 2303 | 55 |
1872264 | 1872264 | 2021-11-01 | Charlton | Georgia | 13049 | 2303 | 55 |
1856389 | 1856389 | 2021-10-27 | Tipton | Indiana | 18159 | 2303 | 61 |
1830811 | 1830811 | 2021-10-19 | Waldo | Maine | 23027 | 2303 | 31 |
1824672 | 1824672 | 2021-10-17 | Madison | Missouri | 29123 | 2303 | 24 |
1824876 | 1824876 | 2021-10-17 | York | Nebraska | 31185 | 2303 | 19 |
1821627 | 1821627 | 2021-10-16 | York | Nebraska | 31185 | 2303 | 19 |
1818378 | 1818378 | 2021-10-15 | York | Nebraska | 31185 | 2303 | 19 |
1810519 | 1810519 | 2021-10-13 | Bleckley | Georgia | 13023 | 2303 | 66 |
1813035 | 1813035 | 2021-10-13 | Orleans | Vermont | 50019 | 2303 | 13 |
1807767 | 1807767 | 2021-10-12 | Atchison | Kansas | 20005 | 2303 | 24 |
1804516 | 1804516 | 2021-10-11 | Atchison | Kansas | 20005 | 2303 | 24 |
1784085 | 1784085 | 2021-10-04 | Sawyer | Wisconsin | 55113 | 2303 | 31 |
1758271 | 1758271 | 2021-09-27 | Howard | Arkansas | 5061 | 2303 | 30 |
1747048 | 1747048 | 2021-09-23 | Bertie | North Carolina | 37015 | 2303 | 47 |
1748256 | 1748256 | 2021-09-23 | Lincoln | West Virginia | 54043 | 2303 | 33 |
1738942 | 1738942 | 2021-09-21 | Teller | Colorado | 8119 | 2303 | 23 |
1729031 | 1729031 | 2021-09-18 | Izard | Arkansas | 5065 | 2303 | 53 |
1723745 | 1723745 | 2021-09-16 | Hubbard | Minnesota | 27057 | 2303 | 41 |
1698790 | 1698790 | 2021-09-08 | Naranjito | Puerto Rico | 72105 | 2303 | |
1677305 | 1677305 | 2021-09-02 | Banks | Georgia | 13011 | 2303 | 48 |
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);