ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
468 rows where cases = 1151 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 33
- Kansas 32
- Wyoming 29
- Virginia 27
- Minnesota 26
- Mississippi 24
- Kentucky 22
- Texas 22
- Missouri 19
- Iowa 18
- Georgia 17
- Illinois 16
- Nebraska 16
- Arkansas 14
- Montana 13
- Florida 11
- Louisiana 11
- North Carolina 11
- Michigan 10
- Alabama 9
- Indiana 9
- Idaho 7
- Tennessee 7
- Puerto Rico 6
- Washington 6
- West Virginia 6
- Ohio 5
- South Dakota 5
- Oregon 4
- Utah 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498020 | 2498020 | 2022-05-12 | Fillmore | Nebraska | 31059 | 1151 | 13 |
2494762 | 2494762 | 2022-05-11 | Fillmore | Nebraska | 31059 | 1151 | 13 |
2461167 | 2461167 | 2022-05-01 | Putnam | Illinois | 17155 | 1151 | 10 |
2457911 | 2457911 | 2022-04-30 | Putnam | Illinois | 17155 | 1151 | 10 |
2454655 | 2454655 | 2022-04-29 | Putnam | Illinois | 17155 | 1151 | 10 |
2425309 | 2425309 | 2022-04-20 | Henderson | Illinois | 17071 | 1151 | 28 |
2385589 | 2385589 | 2022-04-07 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2382334 | 2382334 | 2022-04-06 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2379079 | 2379079 | 2022-04-05 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2375825 | 2375825 | 2022-04-04 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2372573 | 2372573 | 2022-04-03 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2369320 | 2369320 | 2022-04-02 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2366067 | 2366067 | 2022-04-01 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2362814 | 2362814 | 2022-03-31 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2359274 | 2359274 | 2022-03-30 | Charles City | Virginia | 51036 | 1151 | 27 |
2359560 | 2359560 | 2022-03-30 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2356020 | 2356020 | 2022-03-29 | Charles City | Virginia | 51036 | 1151 | 27 |
2356306 | 2356306 | 2022-03-29 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2353053 | 2353053 | 2022-03-28 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2349801 | 2349801 | 2022-03-27 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2346548 | 2346548 | 2022-03-26 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2343295 | 2343295 | 2022-03-25 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2340042 | 2340042 | 2022-03-24 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2336789 | 2336789 | 2022-03-23 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2333535 | 2333535 | 2022-03-22 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2330281 | 2330281 | 2022-03-21 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2326757 | 2326757 | 2022-03-20 | Emporia city | Virginia | 51595 | 1151 | 53 |
2327029 | 2327029 | 2022-03-20 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2323504 | 2323504 | 2022-03-19 | Emporia city | Virginia | 51595 | 1151 | 53 |
2323776 | 2323776 | 2022-03-19 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2320250 | 2320250 | 2022-03-18 | Emporia city | Virginia | 51595 | 1151 | 53 |
2320522 | 2320522 | 2022-03-18 | Hot Springs | Wyoming | 56017 | 1151 | 15 |
2288526 | 2288526 | 2022-03-09 | Schley | Georgia | 13249 | 1151 | 8 |
2285275 | 2285275 | 2022-03-08 | Schley | Georgia | 13249 | 1151 | 8 |
2282023 | 2282023 | 2022-03-07 | Schley | Georgia | 13249 | 1151 | 8 |
2278770 | 2278770 | 2022-03-06 | Schley | Georgia | 13249 | 1151 | 8 |
2279296 | 2279296 | 2022-03-06 | Fulton | Kentucky | 21075 | 1151 | 24 |
2275517 | 2275517 | 2022-03-05 | Schley | Georgia | 13249 | 1151 | 8 |
2276043 | 2276043 | 2022-03-05 | Fulton | Kentucky | 21075 | 1151 | 24 |
2272264 | 2272264 | 2022-03-04 | Schley | Georgia | 13249 | 1151 | 8 |
2272790 | 2272790 | 2022-03-04 | Fulton | Kentucky | 21075 | 1151 | 24 |
2269538 | 2269538 | 2022-03-03 | Fulton | Kentucky | 21075 | 1151 | 24 |
2266285 | 2266285 | 2022-03-02 | Fulton | Kentucky | 21075 | 1151 | 24 |
2215944 | 2215944 | 2022-02-14 | Goliad | Texas | 48175 | 1151 | 30 |
2195443 | 2195443 | 2022-02-08 | Morrill | Nebraska | 31123 | 1151 | 18 |
2188172 | 2188172 | 2022-02-06 | Ottawa | Kansas | 20143 | 1151 | 16 |
2184919 | 2184919 | 2022-02-05 | Ottawa | Kansas | 20143 | 1151 | 16 |
2181667 | 2181667 | 2022-02-04 | Ottawa | Kansas | 20143 | 1151 | 16 |
2179167 | 2179167 | 2022-02-03 | Kearney | Nebraska | 31099 | 1151 | 7 |
2164978 | 2164978 | 2022-01-30 | Wheeler | Georgia | 13309 | 1151 | 36 |
2166152 | 2166152 | 2022-01-30 | Jefferson | Nebraska | 31095 | 1151 | 6 |
2161723 | 2161723 | 2022-01-29 | Wheeler | Georgia | 13309 | 1151 | 36 |
2162897 | 2162897 | 2022-01-29 | Jefferson | Nebraska | 31095 | 1151 | 6 |
2158467 | 2158467 | 2022-01-28 | Wheeler | Georgia | 13309 | 1151 | 36 |
2159642 | 2159642 | 2022-01-28 | Jefferson | Nebraska | 31095 | 1151 | 6 |
2157743 | 2157743 | 2022-01-27 | Ferry | Washington | 53019 | 1151 | 19 |
2154490 | 2154490 | 2022-01-26 | Ferry | Washington | 53019 | 1151 | 19 |
2146866 | 2146866 | 2022-01-24 | Hyde | North Carolina | 37095 | 1151 | 13 |
2111172 | 2111172 | 2022-01-13 | Ransom | North Dakota | 38073 | 1151 | 23 |
2105261 | 2105261 | 2022-01-11 | Bailey | Texas | 48017 | 1151 | 31 |
2086966 | 2086966 | 2022-01-06 | Power | Idaho | 16077 | 1151 | 17 |
2083714 | 2083714 | 2022-01-05 | Power | Idaho | 16077 | 1151 | 17 |
2074838 | 2074838 | 2022-01-02 | Quitman | Mississippi | 28119 | 1151 | 28 |
2071587 | 2071587 | 2022-01-01 | Quitman | Mississippi | 28119 | 1151 | 28 |
2068336 | 2068336 | 2021-12-31 | Quitman | Mississippi | 28119 | 1151 | 28 |
2065085 | 2065085 | 2021-12-30 | Quitman | Mississippi | 28119 | 1151 | 28 |
2062053 | 2062053 | 2021-12-29 | Dawes | Nebraska | 31045 | 1151 | 21 |
2039370 | 2039370 | 2021-12-22 | Thurston | Nebraska | 31173 | 1151 | 17 |
2035924 | 2035924 | 2021-12-21 | Maries | Missouri | 29125 | 1151 | 22 |
2028795 | 2028795 | 2021-12-19 | Greenwood | Kansas | 20073 | 1151 | 17 |
2030802 | 2030802 | 2021-12-19 | Bland | Virginia | 51021 | 1151 | 18 |
2025544 | 2025544 | 2021-12-18 | Greenwood | Kansas | 20073 | 1151 | 17 |
2027551 | 2027551 | 2021-12-18 | Bland | Virginia | 51021 | 1151 | 18 |
2022293 | 2022293 | 2021-12-17 | Greenwood | Kansas | 20073 | 1151 | 17 |
2024300 | 2024300 | 2021-12-17 | Bland | Virginia | 51021 | 1151 | 18 |
2019096 | 2019096 | 2021-12-16 | Sherman | Kansas | 20181 | 1151 | 16 |
2015846 | 2015846 | 2021-12-15 | Sherman | Kansas | 20181 | 1151 | 16 |
2017350 | 2017350 | 2021-12-15 | Hamlin | South Dakota | 46057 | 1151 | 40 |
1988982 | 1988982 | 2021-12-07 | Dallas | Arkansas | 5039 | 1151 | 19 |
1985732 | 1985732 | 2021-12-06 | Dallas | Arkansas | 5039 | 1151 | 19 |
1982482 | 1982482 | 2021-12-05 | Dallas | Arkansas | 5039 | 1151 | 19 |
1979232 | 1979232 | 2021-12-04 | Dallas | Arkansas | 5039 | 1151 | 19 |
1973228 | 1973228 | 2021-12-02 | Edwards | Illinois | 17047 | 1151 | 20 |
1971363 | 1971363 | 2021-12-01 | Bottineau | North Dakota | 38009 | 1151 | 21 |
1929816 | 1929816 | 2021-11-18 | Hansford | Texas | 48195 | 1151 | 26 |
1926566 | 1926566 | 2021-11-17 | Hansford | Texas | 48195 | 1151 | 25 |
1926723 | 1926723 | 2021-11-17 | Beaver | Utah | 49001 | 1151 | 12 |
1920753 | 1920753 | 2021-11-16 | Montgomery | Arkansas | 5097 | 1151 | 46 |
1921489 | 1921489 | 2021-11-16 | Worth | Iowa | 19195 | 1151 | 9 |
1923316 | 1923316 | 2021-11-16 | Hansford | Texas | 48195 | 1151 | 25 |
1923473 | 1923473 | 2021-11-16 | Beaver | Utah | 49001 | 1151 | 12 |
1923728 | 1923728 | 2021-11-16 | Pendleton | West Virginia | 54071 | 1151 | 15 |
1918239 | 1918239 | 2021-11-15 | Worth | Iowa | 19195 | 1151 | 9 |
1920067 | 1920067 | 2021-11-15 | Hansford | Texas | 48195 | 1151 | 25 |
1914989 | 1914989 | 2021-11-14 | Worth | Iowa | 19195 | 1151 | 9 |
1916817 | 1916817 | 2021-11-14 | Hansford | Texas | 48195 | 1151 | 25 |
1911739 | 1911739 | 2021-11-13 | Worth | Iowa | 19195 | 1151 | 9 |
1913567 | 1913567 | 2021-11-13 | Hansford | Texas | 48195 | 1151 | 25 |
1908490 | 1908490 | 2021-11-12 | Worth | Iowa | 19195 | 1151 | 9 |
1905241 | 1905241 | 2021-11-11 | Worth | Iowa | 19195 | 1151 | 9 |
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);