ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
371 rows where cases = 1152 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 35
- Missouri 30
- Iowa 29
- Texas 28
- Virginia 22
- Kentucky 16
- Arkansas 13
- Kansas 13
- Indiana 11
- Mississippi 10
- Minnesota 9
- Nebraska 9
- Tennessee 9
- Illinois 8
- Louisiana 8
- Ohio 7
- New Mexico 6
- Oregon 6
- Puerto Rico 6
- South Carolina 6
- South Dakota 6
- Alabama 5
- Michigan 5
- North Carolina 5
- Oklahoma 5
- Utah 5
- Washington 5
- West Virginia 5
- Wyoming 5
- Idaho 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2464423 | 2464423 | 2022-05-02 | Putnam | Illinois | 17155 | 1152 | 10 |
2428565 | 2428565 | 2022-04-21 | Henderson | Illinois | 17071 | 1152 | 28 |
2420856 | 2420856 | 2022-04-18 | Donley | Texas | 48129 | 1152 | 26 |
2398611 | 2398611 | 2022-04-11 | Hot Springs | Wyoming | 56017 | 1152 | 15 |
2395356 | 2395356 | 2022-04-10 | Hot Springs | Wyoming | 56017 | 1152 | 15 |
2392100 | 2392100 | 2022-04-09 | Hot Springs | Wyoming | 56017 | 1152 | 15 |
2388844 | 2388844 | 2022-04-08 | Hot Springs | Wyoming | 56017 | 1152 | 15 |
2336516 | 2336516 | 2022-03-23 | Emporia city | Virginia | 51595 | 1152 | 52 |
2308037 | 2308037 | 2022-03-15 | Schley | Georgia | 13249 | 1152 | 10 |
2304786 | 2304786 | 2022-03-14 | Schley | Georgia | 13249 | 1152 | 10 |
2301534 | 2301534 | 2022-03-13 | Schley | Georgia | 13249 | 1152 | 9 |
2302060 | 2302060 | 2022-03-13 | Fulton | Kentucky | 21075 | 1152 | 24 |
2298282 | 2298282 | 2022-03-12 | Schley | Georgia | 13249 | 1152 | 9 |
2298808 | 2298808 | 2022-03-12 | Fulton | Kentucky | 21075 | 1152 | 24 |
2295030 | 2295030 | 2022-03-11 | Schley | Georgia | 13249 | 1152 | 9 |
2295556 | 2295556 | 2022-03-11 | Fulton | Kentucky | 21075 | 1152 | 24 |
2291778 | 2291778 | 2022-03-10 | Schley | Georgia | 13249 | 1152 | 9 |
2292304 | 2292304 | 2022-03-10 | Fulton | Kentucky | 21075 | 1152 | 24 |
2289052 | 2289052 | 2022-03-09 | Fulton | Kentucky | 21075 | 1152 | 24 |
2285801 | 2285801 | 2022-03-08 | Fulton | Kentucky | 21075 | 1152 | 24 |
2287851 | 2287851 | 2022-03-08 | San Juan | Washington | 53055 | 1152 | 2 |
2282549 | 2282549 | 2022-03-07 | Fulton | Kentucky | 21075 | 1152 | 24 |
2284599 | 2284599 | 2022-03-07 | San Juan | Washington | 53055 | 1152 | 2 |
2270150 | 2270150 | 2022-03-03 | Pondera | Montana | 30073 | 1152 | 6 |
2261612 | 2261612 | 2022-02-28 | Wheeler | Texas | 48483 | 1152 | 20 |
2258361 | 2258361 | 2022-02-27 | Wheeler | Texas | 48483 | 1152 | 20 |
2255110 | 2255110 | 2022-02-26 | Wheeler | Texas | 48483 | 1152 | 20 |
2248522 | 2248522 | 2022-02-24 | Martin | Texas | 48317 | 1152 | 26 |
2240980 | 2240980 | 2022-02-22 | Polk | Nebraska | 31143 | 1152 | 18 |
2237729 | 2237729 | 2022-02-21 | Polk | Nebraska | 31143 | 1152 | 18 |
2221505 | 2221505 | 2022-02-16 | Lander | Nevada | 32015 | 1152 | 17 |
2222446 | 2222446 | 2022-02-16 | Goliad | Texas | 48175 | 1152 | 30 |
2219195 | 2219195 | 2022-02-15 | Goliad | Texas | 48175 | 1152 | 30 |
2190165 | 2190165 | 2022-02-06 | Cumberland | Virginia | 51049 | 1152 | 21 |
2186912 | 2186912 | 2022-02-05 | Cumberland | Virginia | 51049 | 1152 | 21 |
2183659 | 2183659 | 2022-02-04 | Cumberland | Virginia | 51049 | 1152 | 21 |
2147624 | 2147624 | 2022-01-24 | Garza | Texas | 48169 | 1152 | 25 |
2147741 | 2147741 | 2022-01-24 | Sabine | Texas | 48403 | 1152 | 78 |
2141190 | 2141190 | 2022-01-22 | McCulloch | Texas | 48307 | 1152 | 42 |
2131170 | 2131170 | 2022-01-19 | Walworth | South Dakota | 46129 | 1152 | 20 |
2131421 | 2131421 | 2022-01-19 | Lynn | Texas | 48305 | 1152 | 30 |
2101846 | 2101846 | 2022-01-10 | Brule | South Dakota | 46015 | 1152 | 18 |
2075056 | 2075056 | 2022-01-02 | Dawes | Nebraska | 31045 | 1152 | 21 |
2071805 | 2071805 | 2022-01-01 | Dawes | Nebraska | 31045 | 1152 | 21 |
2068554 | 2068554 | 2021-12-31 | Dawes | Nebraska | 31045 | 1152 | 21 |
2065303 | 2065303 | 2021-12-30 | Dawes | Nebraska | 31045 | 1152 | 21 |
2051982 | 2051982 | 2021-12-26 | Mahnomen | Minnesota | 27087 | 1152 | 15 |
2048732 | 2048732 | 2021-12-25 | Mahnomen | Minnesota | 27087 | 1152 | 15 |
2045482 | 2045482 | 2021-12-24 | Mahnomen | Minnesota | 27087 | 1152 | 15 |
2042232 | 2042232 | 2021-12-23 | Mahnomen | Minnesota | 27087 | 1152 | 15 |
2011793 | 2011793 | 2021-12-14 | Woodruff | Arkansas | 5147 | 1152 | 24 |
2005566 | 2005566 | 2021-12-12 | Hancock | Georgia | 13141 | 1152 | 82 |
2002315 | 2002315 | 2021-12-11 | Hancock | Georgia | 13141 | 1152 | 82 |
1999065 | 1999065 | 2021-12-10 | Hancock | Georgia | 13141 | 1152 | 82 |
2000621 | 2000621 | 2021-12-10 | Dickey | North Dakota | 38021 | 1152 | 38 |
1995960 | 1995960 | 2021-12-09 | Brown | Illinois | 17009 | 1152 | 18 |
1992233 | 1992233 | 2021-12-08 | Dallas | Arkansas | 5039 | 1152 | 19 |
1973032 | 1973032 | 2021-12-02 | Crawford | Georgia | 13079 | 1152 | 45 |
1969782 | 1969782 | 2021-12-01 | Crawford | Georgia | 13079 | 1152 | 45 |
1966532 | 1966532 | 2021-11-30 | Crawford | Georgia | 13079 | 1152 | 45 |
1963280 | 1963280 | 2021-11-29 | Crawford | Georgia | 13079 | 1152 | 45 |
1965338 | 1965338 | 2021-11-29 | Fall River | South Dakota | 46047 | 1152 | 24 |
1937630 | 1937630 | 2021-11-21 | Union | Indiana | 18161 | 1152 | 17 |
1934380 | 1934380 | 2021-11-20 | Union | Indiana | 18161 | 1152 | 17 |
1931129 | 1931129 | 2021-11-19 | Union | Indiana | 18161 | 1152 | 17 |
1921958 | 1921958 | 2021-11-16 | Lac qui Parle | Minnesota | 27073 | 1152 | 25 |
1917773 | 1917773 | 2021-11-15 | Crawford | Georgia | 13079 | 1152 | 43 |
1914992 | 1914992 | 2021-11-14 | Anderson | Kansas | 20003 | 1152 | 22 |
1911742 | 1911742 | 2021-11-13 | Anderson | Kansas | 20003 | 1152 | 22 |
1912382 | 1912382 | 2021-11-13 | Harrison | Missouri | 29081 | 1152 | 17 |
1908493 | 1908493 | 2021-11-12 | Anderson | Kansas | 20003 | 1152 | 22 |
1880743 | 1880743 | 2021-11-03 | San German | Puerto Rico | 72125 | 1152 | |
1869581 | 1869581 | 2021-10-31 | Russell | Kansas | 20167 | 1152 | 33 |
1866332 | 1866332 | 2021-10-30 | Russell | Kansas | 20167 | 1152 | 33 |
1867042 | 1867042 | 2021-10-30 | Cuming | Nebraska | 31039 | 1152 | 15 |
1863083 | 1863083 | 2021-10-29 | Russell | Kansas | 20167 | 1152 | 33 |
1863793 | 1863793 | 2021-10-29 | Cuming | Nebraska | 31039 | 1152 | 15 |
1853178 | 1853178 | 2021-10-26 | Davis | Iowa | 19051 | 1152 | 25 |
1849929 | 1849929 | 2021-10-25 | Davis | Iowa | 19051 | 1152 | 25 |
1846679 | 1846679 | 2021-10-24 | Davis | Iowa | 19051 | 1152 | 25 |
1843429 | 1843429 | 2021-10-23 | Davis | Iowa | 19051 | 1152 | 25 |
1840179 | 1840179 | 2021-10-22 | Davis | Iowa | 19051 | 1152 | 25 |
1836930 | 1836930 | 2021-10-21 | Davis | Iowa | 19051 | 1152 | 25 |
1833681 | 1833681 | 2021-10-20 | Davis | Iowa | 19051 | 1152 | 25 |
1811230 | 1811230 | 2021-10-13 | Trimble | Kentucky | 21223 | 1152 | 11 |
1800450 | 1800450 | 2021-10-10 | Nome Census Area | Alaska | 2180 | 1152 | 0 |
1803285 | 1803285 | 2021-10-10 | Orange | Vermont | 50017 | 1152 | 5 |
1797201 | 1797201 | 2021-10-09 | Nome Census Area | Alaska | 2180 | 1152 | 0 |
1800035 | 1800035 | 2021-10-09 | Lamoille | Vermont | 50015 | 1152 | 5 |
1793952 | 1793952 | 2021-10-08 | Nome Census Area | Alaska | 2180 | 1152 | 0 |
1787534 | 1787534 | 2021-10-06 | Newton | Arkansas | 5101 | 1152 | 34 |
1789934 | 1789934 | 2021-10-06 | Hancock | Tennessee | 47067 | 1152 | 18 |
1779230 | 1779230 | 2021-10-03 | Sullivan | Missouri | 29211 | 1152 | 14 |
1775980 | 1775980 | 2021-10-02 | Sullivan | Missouri | 29211 | 1152 | 14 |
1772730 | 1772730 | 2021-10-01 | Sullivan | Missouri | 29211 | 1152 | 14 |
1770820 | 1770820 | 2021-09-30 | Buena Vista city | Virginia | 51530 | 1152 | 22 |
1745660 | 1745660 | 2021-09-23 | Terrell | Georgia | 13273 | 1152 | 55 |
1741746 | 1741746 | 2021-09-21 | Gilmer | West Virginia | 54021 | 1152 | 7 |
1736790 | 1736790 | 2021-09-20 | Stevens | Minnesota | 27149 | 1152 | 11 |
1733572 | 1733572 | 2021-09-19 | Franklin | Mississippi | 28037 | 1152 | 27 |
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);