ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
446 rows where cases = 965 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 65
- Georgia 29
- Arkansas 21
- Iowa 19
- Kansas 19
- Nebraska 19
- Mississippi 17
- Missouri 17
- Minnesota 16
- Kentucky 15
- North Carolina 13
- Puerto Rico 12
- Michigan 11
- Oklahoma 11
- Louisiana 10
- Colorado 9
- Florida 9
- Illinois 9
- Tennessee 9
- Virginia 9
- West Virginia 9
- Alabama 8
- Indiana 8
- North Dakota 7
- Montana 6
- South Dakota 6
- Washington 6
- Idaho 5
- Nevada 5
- New York 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499692 | 2499692 | 2022-05-13 | Calhoun | Arkansas | 5013 | 965 | 10 |
2496434 | 2496434 | 2022-05-12 | Calhoun | Arkansas | 5013 | 965 | 10 |
2493176 | 2493176 | 2022-05-11 | Calhoun | Arkansas | 5013 | 965 | 10 |
2489918 | 2489918 | 2022-05-10 | Calhoun | Arkansas | 5013 | 965 | 10 |
2486661 | 2486661 | 2022-05-09 | Calhoun | Arkansas | 5013 | 965 | 10 |
2483403 | 2483403 | 2022-05-08 | Calhoun | Arkansas | 5013 | 965 | 10 |
2480145 | 2480145 | 2022-05-07 | Calhoun | Arkansas | 5013 | 965 | 10 |
2476887 | 2476887 | 2022-05-06 | Calhoun | Arkansas | 5013 | 965 | 10 |
2473629 | 2473629 | 2022-05-05 | Calhoun | Arkansas | 5013 | 965 | 10 |
2473781 | 2473781 | 2022-05-05 | Gilpin | Colorado | 8047 | 965 | 4 |
2470372 | 2470372 | 2022-05-04 | Calhoun | Arkansas | 5013 | 965 | 10 |
2467116 | 2467116 | 2022-05-03 | Calhoun | Arkansas | 5013 | 965 | 10 |
2463861 | 2463861 | 2022-05-02 | Calhoun | Arkansas | 5013 | 965 | 10 |
2460605 | 2460605 | 2022-05-01 | Calhoun | Arkansas | 5013 | 965 | 10 |
2381254 | 2381254 | 2022-04-06 | Beaver | Oklahoma | 40007 | 965 | 11 |
2377999 | 2377999 | 2022-04-05 | Beaver | Oklahoma | 40007 | 965 | 11 |
2374745 | 2374745 | 2022-04-04 | Beaver | Oklahoma | 40007 | 965 | 11 |
2371493 | 2371493 | 2022-04-03 | Beaver | Oklahoma | 40007 | 965 | 11 |
2368240 | 2368240 | 2022-04-02 | Beaver | Oklahoma | 40007 | 965 | 11 |
2364987 | 2364987 | 2022-04-01 | Beaver | Oklahoma | 40007 | 965 | 11 |
2361734 | 2361734 | 2022-03-31 | Beaver | Oklahoma | 40007 | 965 | 11 |
2339621 | 2339621 | 2022-03-24 | Presidio | Texas | 48377 | 965 | 36 |
2336367 | 2336367 | 2022-03-23 | Presidio | Texas | 48377 | 965 | 36 |
2333113 | 2333113 | 2022-03-22 | Presidio | Texas | 48377 | 965 | 36 |
2329860 | 2329860 | 2022-03-21 | Presidio | Texas | 48377 | 965 | 36 |
2325856 | 2325856 | 2022-03-20 | Unknown | Northern Mariana Islands | 965 | 1 | |
2326608 | 2326608 | 2022-03-20 | Presidio | Texas | 48377 | 965 | 36 |
2322603 | 2322603 | 2022-03-19 | Unknown | Northern Mariana Islands | 965 | 1 | |
2323355 | 2323355 | 2022-03-19 | Presidio | Texas | 48377 | 965 | 36 |
2319349 | 2319349 | 2022-03-18 | Unknown | Northern Mariana Islands | 965 | 1 | |
2320101 | 2320101 | 2022-03-18 | Presidio | Texas | 48377 | 965 | 36 |
2316847 | 2316847 | 2022-03-17 | Presidio | Texas | 48377 | 965 | 36 |
2313594 | 2313594 | 2022-03-16 | Presidio | Texas | 48377 | 965 | 36 |
2310341 | 2310341 | 2022-03-15 | Presidio | Texas | 48377 | 965 | 36 |
2307088 | 2307088 | 2022-03-14 | Presidio | Texas | 48377 | 965 | 36 |
2303837 | 2303837 | 2022-03-13 | Presidio | Texas | 48377 | 965 | 36 |
2300585 | 2300585 | 2022-03-12 | Presidio | Texas | 48377 | 965 | 36 |
2297333 | 2297333 | 2022-03-11 | Presidio | Texas | 48377 | 965 | 36 |
2262932 | 2262932 | 2022-03-01 | Haskell | Kansas | 20081 | 965 | 11 |
2259681 | 2259681 | 2022-02-28 | Haskell | Kansas | 20081 | 965 | 11 |
2256430 | 2256430 | 2022-02-27 | Haskell | Kansas | 20081 | 965 | 11 |
2253179 | 2253179 | 2022-02-26 | Haskell | Kansas | 20081 | 965 | 11 |
2249928 | 2249928 | 2022-02-25 | Haskell | Kansas | 20081 | 965 | 11 |
2247734 | 2247734 | 2022-02-24 | Tyrrell | North Carolina | 37177 | 965 | 8 |
2234487 | 2234487 | 2022-02-20 | Sheridan | Nebraska | 31161 | 965 | 23 |
2231236 | 2231236 | 2022-02-19 | Sheridan | Nebraska | 31161 | 965 | 23 |
2232226 | 2232226 | 2022-02-19 | Hudspeth | Texas | 48229 | 965 | 16 |
2227985 | 2227985 | 2022-02-18 | Sheridan | Nebraska | 31161 | 965 | 23 |
2224734 | 2224734 | 2022-02-17 | Sheridan | Nebraska | 31161 | 965 | 23 |
2221317 | 2221317 | 2022-02-16 | Putnam | Missouri | 29171 | 965 | 22 |
2221753 | 2221753 | 2022-02-16 | Foster | North Dakota | 38031 | 965 | 21 |
2218502 | 2218502 | 2022-02-15 | Foster | North Dakota | 38031 | 965 | 21 |
2211153 | 2211153 | 2022-02-13 | Tensas | Louisiana | 22107 | 965 | 11 |
2211156 | 2211156 | 2022-02-13 | Unknown | Louisiana | 965 | 0 | |
2207900 | 2207900 | 2022-02-12 | Tensas | Louisiana | 22107 | 965 | 11 |
2207903 | 2207903 | 2022-02-12 | Unknown | Louisiana | 965 | 0 | |
2204647 | 2204647 | 2022-02-11 | Tensas | Louisiana | 22107 | 965 | 11 |
2204650 | 2204650 | 2022-02-11 | Unknown | Louisiana | 965 | 0 | |
2201970 | 2201970 | 2022-02-10 | Sheridan | Nebraska | 31161 | 965 | 23 |
2169708 | 2169708 | 2022-01-31 | Dunn | North Dakota | 38025 | 965 | 8 |
2149815 | 2149815 | 2022-01-25 | Phillips | Montana | 30071 | 965 | 28 |
2151215 | 2151215 | 2022-01-25 | Surry | Virginia | 51181 | 965 | 14 |
2146585 | 2146585 | 2022-01-24 | Antelope | Nebraska | 31003 | 965 | 12 |
2142246 | 2142246 | 2022-01-23 | Lewis | Idaho | 16061 | 965 | 24 |
2144488 | 2144488 | 2022-01-23 | San Augustine | Texas | 48405 | 965 | 38 |
2138991 | 2138991 | 2022-01-22 | Lewis | Idaho | 16061 | 965 | 24 |
2129182 | 2129182 | 2022-01-19 | Warren | Georgia | 13301 | 965 | 26 |
2104580 | 2104580 | 2022-01-11 | Hyde | North Carolina | 37095 | 965 | 13 |
2089027 | 2089027 | 2022-01-06 | Carson | Texas | 48065 | 965 | 29 |
2078439 | 2078439 | 2022-01-03 | Guadalupe | New Mexico | 35019 | 965 | 15 |
2078954 | 2078954 | 2022-01-03 | Arroyo | Puerto Rico | 72015 | 965 | |
2075083 | 2075083 | 2022-01-02 | Kearney | Nebraska | 31099 | 965 | 7 |
2076155 | 2076155 | 2022-01-02 | Mills | Texas | 48333 | 965 | 28 |
2071832 | 2071832 | 2022-01-01 | Kearney | Nebraska | 31099 | 965 | 7 |
2072904 | 2072904 | 2022-01-01 | Mills | Texas | 48333 | 965 | 28 |
2068581 | 2068581 | 2021-12-31 | Kearney | Nebraska | 31099 | 965 | 7 |
2069653 | 2069653 | 2021-12-31 | Mills | Texas | 48333 | 965 | 28 |
2065330 | 2065330 | 2021-12-30 | Kearney | Nebraska | 31099 | 965 | 7 |
2066402 | 2066402 | 2021-12-30 | Mills | Texas | 48333 | 965 | 28 |
2063152 | 2063152 | 2021-12-29 | Mills | Texas | 48333 | 965 | 28 |
2058611 | 2058611 | 2021-12-28 | Atchison | Missouri | 29005 | 965 | 18 |
2058831 | 2058831 | 2021-12-28 | Kearney | Nebraska | 31099 | 965 | 7 |
2037624 | 2037624 | 2021-12-22 | Choctaw | Alabama | 1023 | 965 | 30 |
2040005 | 2040005 | 2021-12-22 | Rincon | Puerto Rico | 72117 | 965 | |
2040619 | 2040619 | 2021-12-22 | Mathews | Virginia | 51115 | 965 | 24 |
2001390 | 2001390 | 2021-12-10 | McCulloch | Texas | 48307 | 965 | 39 |
2001757 | 2001757 | 2021-12-10 | Wirt | West Virginia | 54105 | 965 | 17 |
1998140 | 1998140 | 2021-12-09 | McCulloch | Texas | 48307 | 965 | 39 |
1994889 | 1994889 | 2021-12-08 | McCulloch | Texas | 48307 | 965 | 39 |
1989738 | 1989738 | 2021-12-07 | Van Buren | Iowa | 19177 | 965 | 22 |
1991638 | 1991638 | 2021-12-07 | McCulloch | Texas | 48307 | 965 | 39 |
1986488 | 1986488 | 2021-12-06 | Van Buren | Iowa | 19177 | 965 | 22 |
1983238 | 1983238 | 2021-12-05 | Van Buren | Iowa | 19177 | 965 | 22 |
1984400 | 1984400 | 2021-12-05 | Sioux | North Dakota | 38085 | 965 | 18 |
1979988 | 1979988 | 2021-12-04 | Van Buren | Iowa | 19177 | 965 | 22 |
1981150 | 1981150 | 2021-12-04 | Sioux | North Dakota | 38085 | 965 | 18 |
1981929 | 1981929 | 2021-12-04 | Sabine | Texas | 48403 | 965 | 77 |
1976738 | 1976738 | 2021-12-03 | Van Buren | Iowa | 19177 | 965 | 22 |
1973489 | 1973489 | 2021-12-02 | Van Buren | Iowa | 19177 | 965 | 22 |
1970239 | 1970239 | 2021-12-01 | Van Buren | Iowa | 19177 | 965 | 22 |
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);