ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
467 rows where cases = 856 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 76
- Georgia 45
- Nebraska 44
- Iowa 19
- Oklahoma 18
- Minnesota 17
- Puerto Rico 17
- Virginia 17
- Louisiana 15
- Kentucky 13
- Mississippi 12
- West Virginia 12
- Colorado 11
- Missouri 11
- Tennessee 11
- South Dakota 10
- Idaho 8
- Nevada 8
- Alabama 7
- Illinois 7
- Montana 7
- North Carolina 6
- Ohio 6
- Wisconsin 6
- Arkansas 5
- Kansas 5
- Pennsylvania 5
- Utah 5
- Indiana 4
- Michigan 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2482442 | 2482442 | 2022-05-07 | Vieques | Puerto Rico | 72147 | 856 | |
2422823 | 2422823 | 2022-04-19 | Traverse | Minnesota | 27155 | 856 | 10 |
2419567 | 2419567 | 2022-04-18 | Traverse | Minnesota | 27155 | 856 | 10 |
2404703 | 2404703 | 2022-04-13 | Reagan | Texas | 48383 | 856 | 14 |
2401448 | 2401448 | 2022-04-12 | Reagan | Texas | 48383 | 856 | 14 |
2398193 | 2398193 | 2022-04-11 | Reagan | Texas | 48383 | 856 | 14 |
2394938 | 2394938 | 2022-04-10 | Reagan | Texas | 48383 | 856 | 14 |
2391682 | 2391682 | 2022-04-09 | Reagan | Texas | 48383 | 856 | 14 |
2388426 | 2388426 | 2022-04-08 | Reagan | Texas | 48383 | 856 | 14 |
2385171 | 2385171 | 2022-04-07 | Reagan | Texas | 48383 | 856 | 14 |
2381916 | 2381916 | 2022-04-06 | Reagan | Texas | 48383 | 856 | 14 |
2378661 | 2378661 | 2022-04-05 | Reagan | Texas | 48383 | 856 | 14 |
2375407 | 2375407 | 2022-04-04 | Reagan | Texas | 48383 | 856 | 14 |
2372155 | 2372155 | 2022-04-03 | Reagan | Texas | 48383 | 856 | 14 |
2368902 | 2368902 | 2022-04-02 | Reagan | Texas | 48383 | 856 | 14 |
2365649 | 2365649 | 2022-04-01 | Reagan | Texas | 48383 | 856 | 14 |
2362396 | 2362396 | 2022-03-31 | Reagan | Texas | 48383 | 856 | 14 |
2359142 | 2359142 | 2022-03-30 | Reagan | Texas | 48383 | 856 | 14 |
2355888 | 2355888 | 2022-03-29 | Reagan | Texas | 48383 | 856 | 14 |
2352635 | 2352635 | 2022-03-28 | Reagan | Texas | 48383 | 856 | 14 |
2349383 | 2349383 | 2022-03-27 | Reagan | Texas | 48383 | 856 | 14 |
2346130 | 2346130 | 2022-03-26 | Reagan | Texas | 48383 | 856 | 14 |
2342877 | 2342877 | 2022-03-25 | Reagan | Texas | 48383 | 856 | 14 |
2339624 | 2339624 | 2022-03-24 | Reagan | Texas | 48383 | 856 | 14 |
2336370 | 2336370 | 2022-03-23 | Reagan | Texas | 48383 | 856 | 14 |
2333116 | 2333116 | 2022-03-22 | Reagan | Texas | 48383 | 856 | 14 |
2328912 | 2328912 | 2022-03-21 | Hamilton | New York | 36041 | 856 | 5 |
2329863 | 2329863 | 2022-03-21 | Reagan | Texas | 48383 | 856 | 14 |
2325660 | 2325660 | 2022-03-20 | Hamilton | New York | 36041 | 856 | 5 |
2326611 | 2326611 | 2022-03-20 | Reagan | Texas | 48383 | 856 | 14 |
2323358 | 2323358 | 2022-03-19 | Reagan | Texas | 48383 | 856 | 14 |
2320104 | 2320104 | 2022-03-18 | Reagan | Texas | 48383 | 856 | 14 |
2316850 | 2316850 | 2022-03-17 | Reagan | Texas | 48383 | 856 | 14 |
2313597 | 2313597 | 2022-03-16 | Reagan | Texas | 48383 | 856 | 14 |
2310344 | 2310344 | 2022-03-15 | Reagan | Texas | 48383 | 856 | 14 |
2307091 | 2307091 | 2022-03-14 | Reagan | Texas | 48383 | 856 | 14 |
2303840 | 2303840 | 2022-03-13 | Reagan | Texas | 48383 | 856 | 14 |
2300588 | 2300588 | 2022-03-12 | Reagan | Texas | 48383 | 856 | 14 |
2239531 | 2239531 | 2022-02-22 | Phillips | Colorado | 8095 | 856 | 17 |
2236280 | 2236280 | 2022-02-21 | Phillips | Colorado | 8095 | 856 | 17 |
2233029 | 2233029 | 2022-02-20 | Phillips | Colorado | 8095 | 856 | 17 |
2229778 | 2229778 | 2022-02-19 | Phillips | Colorado | 8095 | 856 | 17 |
2226527 | 2226527 | 2022-02-18 | Phillips | Colorado | 8095 | 856 | 17 |
2150651 | 2150651 | 2022-01-25 | Edmunds | South Dakota | 46045 | 856 | 15 |
2133669 | 2133669 | 2022-01-20 | Lincoln | Nevada | 32017 | 856 | 5 |
2127417 | 2127417 | 2022-01-18 | LaMoure | North Dakota | 38045 | 856 | 19 |
2127867 | 2127867 | 2022-01-18 | Corson | South Dakota | 46031 | 856 | 15 |
2118008 | 2118008 | 2022-01-15 | Las Marias | Puerto Rico | 72083 | 856 | |
2111816 | 2111816 | 2022-01-13 | Delta | Texas | 48119 | 856 | 22 |
2112303 | 2112303 | 2022-01-13 | Florence | Wisconsin | 55037 | 856 | 15 |
2107419 | 2107419 | 2022-01-12 | Holt | Missouri | 29087 | 856 | 25 |
2108609 | 2108609 | 2022-01-12 | Hemphill | Texas | 48211 | 856 | 3 |
2103852 | 2103852 | 2022-01-11 | Unknown | Maryland | 856 | 278 | |
2105358 | 2105358 | 2022-01-11 | Hemphill | Texas | 48211 | 856 | 3 |
2096690 | 2096690 | 2022-01-09 | Boise | Idaho | 16015 | 856 | 11 |
2093438 | 2093438 | 2022-01-08 | Boise | Idaho | 16015 | 856 | 11 |
2079564 | 2079564 | 2022-01-03 | Charles City | Virginia | 51036 | 856 | 22 |
2074725 | 2074725 | 2022-01-02 | Kittson | Minnesota | 27069 | 856 | 24 |
2071474 | 2071474 | 2022-01-01 | Kittson | Minnesota | 27069 | 856 | 24 |
2068223 | 2068223 | 2021-12-31 | Kittson | Minnesota | 27069 | 856 | 24 |
2064972 | 2064972 | 2021-12-30 | Kittson | Minnesota | 27069 | 856 | 24 |
2057699 | 2057699 | 2021-12-28 | Lewis | Idaho | 16061 | 856 | 23 |
2057987 | 2057987 | 2021-12-28 | Ringgold | Iowa | 19159 | 856 | 31 |
2054450 | 2054450 | 2021-12-27 | Lewis | Idaho | 16061 | 856 | 23 |
2054738 | 2054738 | 2021-12-27 | Ringgold | Iowa | 19159 | 856 | 31 |
2055613 | 2055613 | 2021-12-27 | Sheridan | Nebraska | 31161 | 856 | 23 |
2051298 | 2051298 | 2021-12-26 | Scott | Illinois | 17171 | 856 | 7 |
2051488 | 2051488 | 2021-12-26 | Ringgold | Iowa | 19159 | 856 | 31 |
2052363 | 2052363 | 2021-12-26 | Sheridan | Nebraska | 31161 | 856 | 23 |
2048048 | 2048048 | 2021-12-25 | Scott | Illinois | 17171 | 856 | 7 |
2048238 | 2048238 | 2021-12-25 | Ringgold | Iowa | 19159 | 856 | 31 |
2049113 | 2049113 | 2021-12-25 | Sheridan | Nebraska | 31161 | 856 | 23 |
2044798 | 2044798 | 2021-12-24 | Scott | Illinois | 17171 | 856 | 7 |
2044988 | 2044988 | 2021-12-24 | Ringgold | Iowa | 19159 | 856 | 31 |
2045863 | 2045863 | 2021-12-24 | Sheridan | Nebraska | 31161 | 856 | 23 |
2041549 | 2041549 | 2021-12-23 | Scott | Illinois | 17171 | 856 | 7 |
2041739 | 2041739 | 2021-12-23 | Ringgold | Iowa | 19159 | 856 | 31 |
2042613 | 2042613 | 2021-12-23 | Sheridan | Nebraska | 31161 | 856 | 23 |
2038489 | 2038489 | 2021-12-22 | Ringgold | Iowa | 19159 | 856 | 31 |
2039631 | 2039631 | 2021-12-22 | Dunn | North Dakota | 38025 | 856 | 7 |
2015898 | 2015898 | 2021-12-15 | Fulton | Kentucky | 21075 | 856 | 22 |
2017364 | 2017364 | 2021-12-15 | Lyman | South Dakota | 46085 | 856 | 11 |
2012239 | 2012239 | 2021-12-14 | Gallatin | Illinois | 17059 | 856 | 11 |
2014114 | 2014114 | 2021-12-14 | Lyman | South Dakota | 46085 | 856 | 11 |
1981760 | 1981760 | 2021-12-04 | Carson | Texas | 48065 | 856 | 26 |
1978510 | 1978510 | 2021-12-03 | Carson | Texas | 48065 | 856 | 25 |
1971126 | 1971126 | 2021-12-01 | Lander | Nevada | 32015 | 856 | 16 |
1968895 | 1968895 | 2021-11-30 | Mills | Texas | 48333 | 856 | 28 |
1964805 | 1964805 | 2021-11-29 | Hyde | North Carolina | 37095 | 856 | 12 |
1965333 | 1965333 | 2021-11-29 | Day | South Dakota | 46037 | 856 | 30 |
1965644 | 1965644 | 2021-11-29 | Mills | Texas | 48333 | 856 | 28 |
1962392 | 1962392 | 2021-11-28 | Mills | Texas | 48333 | 856 | 28 |
1959141 | 1959141 | 2021-11-27 | Mills | Texas | 48333 | 856 | 28 |
1955890 | 1955890 | 2021-11-26 | Mills | Texas | 48333 | 856 | 28 |
1952639 | 1952639 | 2021-11-25 | Mills | Texas | 48333 | 856 | 28 |
1949388 | 1949388 | 2021-11-24 | Mills | Texas | 48333 | 856 | 28 |
1944288 | 1944288 | 2021-11-23 | Kearny | Kansas | 20093 | 856 | 16 |
1944995 | 1944995 | 2021-11-23 | Phillips | Montana | 30071 | 856 | 28 |
1941038 | 1941038 | 2021-11-22 | Kearny | Kansas | 20093 | 856 | 16 |
1927502 | 1927502 | 2021-11-18 | Calhoun | Georgia | 13037 | 856 | 21 |
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);