ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
437 rows where cases = 1310 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 39
- North Carolina 35
- Texas 29
- Mississippi 25
- Virginia 25
- Georgia 23
- South Dakota 23
- Puerto Rico 16
- Missouri 15
- Colorado 12
- Indiana 12
- Kentucky 11
- Arkansas 10
- Louisiana 9
- Michigan 9
- Nebraska 9
- West Virginia 9
- Wisconsin 9
- Alabama 8
- Illinois 8
- Minnesota 8
- South Carolina 8
- New Mexico 7
- North Dakota 7
- Washington 7
- Florida 6
- Oklahoma 6
- Tennessee 6
- Kansas 5
- Montana 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502598 | 2502598 | 2022-05-13 | Norton city | Virginia | 51720 | 1310 | 22 |
2423374 | 2423374 | 2022-04-19 | Hyde | North Carolina | 37095 | 1310 | 13 |
2420117 | 2420117 | 2022-04-18 | Hyde | North Carolina | 37095 | 1310 | 13 |
2416862 | 2416862 | 2022-04-17 | Hyde | North Carolina | 37095 | 1310 | 13 |
2413606 | 2413606 | 2022-04-16 | Hyde | North Carolina | 37095 | 1310 | 13 |
2410350 | 2410350 | 2022-04-15 | Hyde | North Carolina | 37095 | 1310 | 13 |
2407094 | 2407094 | 2022-04-14 | Hyde | North Carolina | 37095 | 1310 | 13 |
2403838 | 2403838 | 2022-04-13 | Hyde | North Carolina | 37095 | 1310 | 13 |
2400583 | 2400583 | 2022-04-12 | Hyde | North Carolina | 37095 | 1310 | 13 |
2397328 | 2397328 | 2022-04-11 | Hyde | North Carolina | 37095 | 1310 | 13 |
2394073 | 2394073 | 2022-04-10 | Hyde | North Carolina | 37095 | 1310 | 13 |
2390817 | 2390817 | 2022-04-09 | Hyde | North Carolina | 37095 | 1310 | 13 |
2387561 | 2387561 | 2022-04-08 | Hyde | North Carolina | 37095 | 1310 | 13 |
2384306 | 2384306 | 2022-04-07 | Hyde | North Carolina | 37095 | 1310 | 13 |
2381051 | 2381051 | 2022-04-06 | Hyde | North Carolina | 37095 | 1310 | 13 |
2377796 | 2377796 | 2022-04-05 | Hyde | North Carolina | 37095 | 1310 | 13 |
2378371 | 2378371 | 2022-04-05 | Walworth | South Dakota | 46129 | 1310 | 26 |
2374543 | 2374543 | 2022-04-04 | Hyde | North Carolina | 37095 | 1310 | 13 |
2375117 | 2375117 | 2022-04-04 | Walworth | South Dakota | 46129 | 1310 | 26 |
2371291 | 2371291 | 2022-04-03 | Hyde | North Carolina | 37095 | 1310 | 13 |
2371865 | 2371865 | 2022-04-03 | Walworth | South Dakota | 46129 | 1310 | 26 |
2368038 | 2368038 | 2022-04-02 | Hyde | North Carolina | 37095 | 1310 | 13 |
2368612 | 2368612 | 2022-04-02 | Walworth | South Dakota | 46129 | 1310 | 26 |
2364785 | 2364785 | 2022-04-01 | Hyde | North Carolina | 37095 | 1310 | 13 |
2365359 | 2365359 | 2022-04-01 | Walworth | South Dakota | 46129 | 1310 | 26 |
2361531 | 2361531 | 2022-03-31 | Hyde | North Carolina | 37095 | 1310 | 13 |
2362106 | 2362106 | 2022-03-31 | Walworth | South Dakota | 46129 | 1310 | 26 |
2358277 | 2358277 | 2022-03-30 | Hyde | North Carolina | 37095 | 1310 | 13 |
2358852 | 2358852 | 2022-03-30 | Walworth | South Dakota | 46129 | 1310 | 26 |
2355023 | 2355023 | 2022-03-29 | Hyde | North Carolina | 37095 | 1310 | 13 |
2351770 | 2351770 | 2022-03-28 | Hyde | North Carolina | 37095 | 1310 | 13 |
2348518 | 2348518 | 2022-03-27 | Hyde | North Carolina | 37095 | 1310 | 13 |
2345265 | 2345265 | 2022-03-26 | Hyde | North Carolina | 37095 | 1310 | 13 |
2342012 | 2342012 | 2022-03-25 | Hyde | North Carolina | 37095 | 1310 | 13 |
2332800 | 2332800 | 2022-03-22 | Kingsbury | South Dakota | 46077 | 1310 | 21 |
2329547 | 2329547 | 2022-03-21 | Kingsbury | South Dakota | 46077 | 1310 | 21 |
2326295 | 2326295 | 2022-03-20 | Kingsbury | South Dakota | 46077 | 1310 | 21 |
2323042 | 2323042 | 2022-03-19 | Kingsbury | South Dakota | 46077 | 1310 | 21 |
2319788 | 2319788 | 2022-03-18 | Kingsbury | South Dakota | 46077 | 1310 | 21 |
2316534 | 2316534 | 2022-03-17 | Kingsbury | South Dakota | 46077 | 1310 | 21 |
2313281 | 2313281 | 2022-03-16 | Kingsbury | South Dakota | 46077 | 1310 | 21 |
2310028 | 2310028 | 2022-03-15 | Kingsbury | South Dakota | 46077 | 1310 | 21 |
2306775 | 2306775 | 2022-03-14 | Kingsbury | South Dakota | 46077 | 1310 | 21 |
2262878 | 2262878 | 2022-03-01 | Taylor | Iowa | 19173 | 1310 | 21 |
2259627 | 2259627 | 2022-02-28 | Taylor | Iowa | 19173 | 1310 | 21 |
2256376 | 2256376 | 2022-02-27 | Taylor | Iowa | 19173 | 1310 | 21 |
2253125 | 2253125 | 2022-02-26 | Taylor | Iowa | 19173 | 1310 | 21 |
2249874 | 2249874 | 2022-02-25 | Taylor | Iowa | 19173 | 1310 | 21 |
2246623 | 2246623 | 2022-02-24 | Taylor | Iowa | 19173 | 1310 | 21 |
2243372 | 2243372 | 2022-02-23 | Taylor | Iowa | 19173 | 1310 | 21 |
2240931 | 2240931 | 2022-02-22 | Dawes | Nebraska | 31045 | 1310 | 21 |
2218529 | 2218529 | 2022-02-15 | Sioux | North Dakota | 38085 | 1310 | 19 |
2211803 | 2211803 | 2022-02-13 | Guadalupe | New Mexico | 35019 | 1310 | 16 |
2208550 | 2208550 | 2022-02-12 | Guadalupe | New Mexico | 35019 | 1310 | 16 |
2205297 | 2205297 | 2022-02-11 | Guadalupe | New Mexico | 35019 | 1310 | 16 |
2199318 | 2199318 | 2022-02-09 | Ceiba | Puerto Rico | 72037 | 1310 | |
2196514 | 2196514 | 2022-02-08 | Newton | Texas | 48351 | 1310 | 56 |
2179829 | 2179829 | 2022-02-03 | Maunabo | Puerto Rico | 72095 | 1310 | |
2142969 | 2142969 | 2022-01-23 | Oscoda | Michigan | 26135 | 1310 | 51 |
2139714 | 2139714 | 2022-01-22 | Oscoda | Michigan | 26135 | 1310 | 51 |
2136458 | 2136458 | 2022-01-21 | Oscoda | Michigan | 26135 | 1310 | 51 |
2128047 | 2128047 | 2022-01-18 | Carson | Texas | 48065 | 1310 | 30 |
2105350 | 2105350 | 2022-01-11 | Hansford | Texas | 48195 | 1310 | 27 |
2096422 | 2096422 | 2022-01-09 | Rio Blanco | Colorado | 8103 | 1310 | 11 |
2097537 | 2097537 | 2022-01-09 | Wilkin | Minnesota | 27167 | 1310 | 19 |
2093170 | 2093170 | 2022-01-08 | Rio Blanco | Colorado | 8103 | 1310 | 11 |
2094285 | 2094285 | 2022-01-08 | Wilkin | Minnesota | 27167 | 1310 | 19 |
2089918 | 2089918 | 2022-01-07 | Rio Blanco | Colorado | 8103 | 1310 | 11 |
2091033 | 2091033 | 2022-01-07 | Wilkin | Minnesota | 27167 | 1310 | 19 |
2086667 | 2086667 | 2022-01-06 | Rio Blanco | Colorado | 8103 | 1310 | 11 |
2081597 | 2081597 | 2022-01-04 | Merrick | Nebraska | 31121 | 1310 | 15 |
2078142 | 2078142 | 2022-01-03 | Daviess | Missouri | 29061 | 1310 | 17 |
2074048 | 2074048 | 2022-01-02 | Schuyler | Illinois | 17169 | 1310 | 26 |
2074530 | 2074530 | 2022-01-02 | St. Helena | Louisiana | 22091 | 1310 | 19 |
2070797 | 2070797 | 2022-01-01 | Schuyler | Illinois | 17169 | 1310 | 26 |
2071279 | 2071279 | 2022-01-01 | St. Helena | Louisiana | 22091 | 1310 | 19 |
2067546 | 2067546 | 2021-12-31 | Schuyler | Illinois | 17169 | 1310 | 26 |
2068028 | 2068028 | 2021-12-31 | St. Helena | Louisiana | 22091 | 1310 | 19 |
2064295 | 2064295 | 2021-12-30 | Schuyler | Illinois | 17169 | 1310 | 26 |
2064777 | 2064777 | 2021-12-30 | St. Helena | Louisiana | 22091 | 1310 | 19 |
2062715 | 2062715 | 2021-12-29 | Comerio | Puerto Rico | 72045 | 1310 | |
2056701 | 2056701 | 2021-12-27 | Stephens | Texas | 48429 | 1310 | 37 |
2056996 | 2056996 | 2021-12-27 | Pendleton | West Virginia | 54071 | 1310 | 16 |
2035185 | 2035185 | 2021-12-21 | Davis | Iowa | 19051 | 1310 | 25 |
2036741 | 2036741 | 2021-12-21 | Luquillo | Puerto Rico | 72089 | 1310 | |
2031935 | 2031935 | 2021-12-20 | Davis | Iowa | 19051 | 1310 | 25 |
2032689 | 2032689 | 2021-12-20 | Ozark | Missouri | 29153 | 1310 | 43 |
2033491 | 2033491 | 2021-12-20 | Luquillo | Puerto Rico | 72089 | 1310 | |
2028684 | 2028684 | 2021-12-19 | Davis | Iowa | 19051 | 1310 | 25 |
2025433 | 2025433 | 2021-12-18 | Davis | Iowa | 19051 | 1310 | 25 |
2022182 | 2022182 | 2021-12-17 | Davis | Iowa | 19051 | 1310 | 25 |
2018931 | 2018931 | 2021-12-16 | Davis | Iowa | 19051 | 1310 | 25 |
2015681 | 2015681 | 2021-12-15 | Davis | Iowa | 19051 | 1310 | 25 |
1998636 | 1998636 | 2021-12-10 | Greene | Alabama | 1063 | 1310 | 45 |
1995385 | 1995385 | 2021-12-09 | Greene | Alabama | 1063 | 1310 | 45 |
1997036 | 1997036 | 2021-12-09 | Butler | Nebraska | 31023 | 1310 | 12 |
1992134 | 1992134 | 2021-12-08 | Greene | Alabama | 1063 | 1310 | 45 |
1992650 | 1992650 | 2021-12-08 | Wilcox | Georgia | 13315 | 1310 | 62 |
1989399 | 1989399 | 2021-12-07 | Wilcox | Georgia | 13315 | 1310 | 62 |
1982899 | 1982899 | 2021-12-05 | Wilcox | Georgia | 13315 | 1310 | 60 |
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);