ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
416 rows where cases = 1148 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 31
- Virginia 30
- Texas 29
- Missouri 22
- Georgia 21
- Minnesota 19
- Kentucky 17
- Arkansas 14
- Colorado 14
- Idaho 14
- Oklahoma 14
- Montana 12
- Nebraska 12
- North Carolina 12
- Mississippi 11
- Puerto Rico 11
- Kansas 10
- South Dakota 10
- Iowa 9
- Tennessee 9
- West Virginia 8
- Louisiana 7
- Ohio 7
- Oregon 7
- Alabama 6
- Indiana 6
- North Dakota 6
- Wisconsin 6
- Alaska 5
- Michigan 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2438375 | 2438375 | 2022-04-24 | Putnam | Illinois | 17155 | 1148 | 10 |
2435119 | 2435119 | 2022-04-23 | Putnam | Illinois | 17155 | 1148 | 10 |
2431863 | 2431863 | 2022-04-22 | Putnam | Illinois | 17155 | 1148 | 10 |
2428607 | 2428607 | 2022-04-21 | Putnam | Illinois | 17155 | 1148 | 10 |
2422053 | 2422053 | 2022-04-19 | Henderson | Illinois | 17071 | 1148 | 28 |
2418797 | 2418797 | 2022-04-18 | Henderson | Illinois | 17071 | 1148 | 28 |
2415541 | 2415541 | 2022-04-17 | Henderson | Illinois | 17071 | 1148 | 28 |
2412285 | 2412285 | 2022-04-16 | Henderson | Illinois | 17071 | 1148 | 28 |
2409029 | 2409029 | 2022-04-15 | Henderson | Illinois | 17071 | 1148 | 28 |
2405773 | 2405773 | 2022-04-14 | Henderson | Illinois | 17071 | 1148 | 28 |
2402518 | 2402518 | 2022-04-13 | Henderson | Illinois | 17071 | 1148 | 28 |
2399263 | 2399263 | 2022-04-12 | Henderson | Illinois | 17071 | 1148 | 27 |
2396008 | 2396008 | 2022-04-11 | Henderson | Illinois | 17071 | 1148 | 27 |
2392752 | 2392752 | 2022-04-10 | Henderson | Illinois | 17071 | 1148 | 27 |
2389496 | 2389496 | 2022-04-09 | Henderson | Illinois | 17071 | 1148 | 27 |
2386241 | 2386241 | 2022-04-08 | Henderson | Illinois | 17071 | 1148 | 27 |
2382986 | 2382986 | 2022-04-07 | Henderson | Illinois | 17071 | 1148 | 27 |
2379731 | 2379731 | 2022-04-06 | Henderson | Illinois | 17071 | 1148 | 27 |
2352767 | 2352767 | 2022-03-28 | Charles City | Virginia | 51036 | 1148 | 27 |
2349515 | 2349515 | 2022-03-27 | Charles City | Virginia | 51036 | 1148 | 27 |
2346262 | 2346262 | 2022-03-26 | Charles City | Virginia | 51036 | 1148 | 27 |
2343009 | 2343009 | 2022-03-25 | Charles City | Virginia | 51036 | 1148 | 27 |
2339756 | 2339756 | 2022-03-24 | Charles City | Virginia | 51036 | 1148 | 27 |
2336502 | 2336502 | 2022-03-23 | Charles City | Virginia | 51036 | 1148 | 27 |
2313743 | 2313743 | 2022-03-16 | Emporia city | Virginia | 51595 | 1148 | 53 |
2286351 | 2286351 | 2022-03-08 | Reynolds | Missouri | 29179 | 1148 | 25 |
2284746 | 2284746 | 2022-03-07 | Hot Springs | Wyoming | 56017 | 1148 | 15 |
2281494 | 2281494 | 2022-03-06 | Hot Springs | Wyoming | 56017 | 1148 | 15 |
2278241 | 2278241 | 2022-03-05 | Hot Springs | Wyoming | 56017 | 1148 | 15 |
2274988 | 2274988 | 2022-03-04 | Hot Springs | Wyoming | 56017 | 1148 | 15 |
2262508 | 2262508 | 2022-03-01 | Schley | Georgia | 13249 | 1148 | 8 |
2259264 | 2259264 | 2022-02-28 | Talbot | Georgia | 13263 | 1148 | 31 |
2259783 | 2259783 | 2022-02-28 | Fulton | Kentucky | 21075 | 1148 | 23 |
2261476 | 2261476 | 2022-02-28 | Hemphill | Texas | 48211 | 1148 | 6 |
2258225 | 2258225 | 2022-02-27 | Hemphill | Texas | 48211 | 1148 | 6 |
2254974 | 2254974 | 2022-02-26 | Hemphill | Texas | 48211 | 1148 | 6 |
2244140 | 2244140 | 2022-02-23 | Pondera | Montana | 30073 | 1148 | 6 |
2238769 | 2238769 | 2022-02-21 | Martin | Texas | 48317 | 1148 | 26 |
2224725 | 2224725 | 2022-02-17 | Polk | Nebraska | 31143 | 1148 | 18 |
2212693 | 2212693 | 2022-02-13 | Goliad | Texas | 48175 | 1148 | 30 |
2179065 | 2179065 | 2022-02-03 | Broadwater | Montana | 30007 | 1148 | 18 |
2175915 | 2175915 | 2022-02-02 | Kearney | Nebraska | 31099 | 1148 | 7 |
2138550 | 2138550 | 2022-01-22 | Lafayette | Arkansas | 5073 | 1148 | 28 |
2137950 | 2137950 | 2022-01-21 | Newton | Texas | 48351 | 1148 | 55 |
2132979 | 2132979 | 2022-01-20 | Menifee | Kentucky | 21165 | 1148 | 28 |
2100729 | 2100729 | 2022-01-10 | Grant | Minnesota | 27051 | 1148 | 12 |
2102010 | 2102010 | 2022-01-10 | Bailey | Texas | 48017 | 1148 | 31 |
2088876 | 2088876 | 2022-01-06 | McCook | South Dakota | 46087 | 1148 | 30 |
2081550 | 2081550 | 2022-01-04 | Cedar | Nebraska | 31027 | 1148 | 11 |
2077210 | 2077210 | 2022-01-03 | Power | Idaho | 16077 | 1148 | 17 |
2078210 | 2078210 | 2022-01-03 | Shelby | Missouri | 29205 | 1148 | 13 |
2061854 | 2061854 | 2021-12-29 | Wilkinson | Mississippi | 28157 | 1148 | 39 |
2059630 | 2059630 | 2021-12-28 | Spink | South Dakota | 46115 | 1148 | 31 |
2059759 | 2059759 | 2021-12-28 | Brooks | Texas | 48047 | 1148 | 47 |
2055555 | 2055555 | 2021-12-27 | Dawes | Nebraska | 31045 | 1148 | 21 |
2056510 | 2056510 | 2021-12-27 | Brooks | Texas | 48047 | 1148 | 47 |
2052305 | 2052305 | 2021-12-26 | Dawes | Nebraska | 31045 | 1148 | 21 |
2049055 | 2049055 | 2021-12-25 | Dawes | Nebraska | 31045 | 1148 | 21 |
2045805 | 2045805 | 2021-12-24 | Dawes | Nebraska | 31045 | 1148 | 21 |
2042555 | 2042555 | 2021-12-23 | Dawes | Nebraska | 31045 | 1148 | 21 |
2038983 | 2038983 | 2021-12-22 | Mahnomen | Minnesota | 27087 | 1148 | 15 |
2039306 | 2039306 | 2021-12-22 | Dawes | Nebraska | 31045 | 1148 | 21 |
2039334 | 2039334 | 2021-12-22 | Keith | Nebraska | 31101 | 1148 | 11 |
2036056 | 2036056 | 2021-12-21 | Dawes | Nebraska | 31045 | 1148 | 21 |
2008046 | 2008046 | 2021-12-12 | Bland | Virginia | 51021 | 1148 | 18 |
2004795 | 2004795 | 2021-12-11 | Bland | Virginia | 51021 | 1148 | 18 |
2001544 | 2001544 | 2021-12-10 | Bland | Virginia | 51021 | 1148 | 18 |
1995814 | 1995814 | 2021-12-09 | Hancock | Georgia | 13141 | 1148 | 82 |
1989037 | 1989037 | 2021-12-07 | Woodruff | Arkansas | 5147 | 1148 | 24 |
1945841 | 1945841 | 2021-11-23 | Hutchinson | South Dakota | 46067 | 1148 | 28 |
1909132 | 1909132 | 2021-11-12 | Harrison | Missouri | 29081 | 1148 | 17 |
1905244 | 1905244 | 2021-11-11 | Anderson | Kansas | 20003 | 1148 | 22 |
1901994 | 1901994 | 2021-11-10 | Anderson | Kansas | 20003 | 1148 | 22 |
1877494 | 1877494 | 2021-11-02 | San German | Puerto Rico | 72125 | 1148 | |
1874245 | 1874245 | 2021-11-01 | San German | Puerto Rico | 72125 | 1148 | |
1861095 | 1861095 | 2021-10-28 | Harney | Oregon | 41025 | 1148 | 27 |
1846419 | 1846419 | 2021-10-24 | Benewah | Idaho | 16009 | 1148 | 23 |
1848870 | 1848870 | 2021-10-24 | Northampton | Virginia | 51131 | 1148 | 44 |
1843169 | 1843169 | 2021-10-23 | Benewah | Idaho | 16009 | 1148 | 23 |
1845620 | 1845620 | 2021-10-23 | Northampton | Virginia | 51131 | 1148 | 44 |
1839919 | 1839919 | 2021-10-22 | Benewah | Idaho | 16009 | 1148 | 23 |
1842370 | 1842370 | 2021-10-22 | Northampton | Virginia | 51131 | 1148 | 44 |
1839121 | 1839121 | 2021-10-21 | Northampton | Virginia | 51131 | 1148 | 42 |
1829699 | 1829699 | 2021-10-19 | Southeast Fairbanks Census Area | Alaska | 2240 | 1148 | 10 |
1825151 | 1825151 | 2021-10-17 | Pembina | North Dakota | 38067 | 1148 | 11 |
1826312 | 1826312 | 2021-10-17 | Pepin | Wisconsin | 55091 | 1148 | 10 |
1816471 | 1816471 | 2021-10-14 | Clay | West Virginia | 54015 | 1148 | 17 |
1811146 | 1811146 | 2021-10-13 | Crittenden | Kentucky | 21055 | 1148 | 35 |
1807170 | 1807170 | 2021-10-12 | San Miguel | Colorado | 8113 | 1148 | 3 |
1806726 | 1806726 | 2021-10-11 | Doddridge | West Virginia | 54017 | 1148 | 9 |
1784604 | 1784604 | 2021-10-05 | Lincoln | Georgia | 13181 | 1148 | 32 |
1785526 | 1785526 | 2021-10-05 | Stevens | Minnesota | 27149 | 1148 | 11 |
1771286 | 1771286 | 2021-10-01 | Newton | Arkansas | 5101 | 1148 | 34 |
1766232 | 1766232 | 2021-09-29 | Sullivan | Missouri | 29211 | 1148 | 14 |
1766286 | 1766286 | 2021-09-29 | Sanders | Montana | 30089 | 1148 | 16 |
1761372 | 1761372 | 2021-09-27 | Sublette | Wyoming | 56035 | 1148 | 12 |
1745433 | 1745433 | 2021-09-23 | Rio Grande | Colorado | 8105 | 1148 | 21 |
1744503 | 1744503 | 2021-09-22 | Van Buren | Tennessee | 47175 | 1148 | 25 |
1740290 | 1740290 | 2021-09-21 | Powell | Montana | 30077 | 1148 | 14 |
1732296 | 1732296 | 2021-09-19 | Monroe | Arkansas | 5095 | 1148 | 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);