ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
314 rows where cases = 1754 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 44
- Texas 23
- Virginia 20
- Michigan 19
- Georgia 18
- Illinois 15
- Minnesota 14
- Kansas 13
- Kentucky 13
- Puerto Rico 13
- Arkansas 11
- Mississippi 11
- Alabama 10
- Indiana 9
- Oklahoma 8
- North Carolina 6
- Tennessee 6
- Colorado 5
- Missouri 5
- Montana 5
- Florida 4
- New Mexico 4
- West Virginia 4
- Alaska 3
- Connecticut 3
- Louisiana 3
- Nebraska 3
- Pennsylvania 3
- Wisconsin 3
- Idaho 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491121 | 2491121 | 2022-05-10 | Schoolcraft | Michigan | 26153 | 1754 | 16 |
2487864 | 2487864 | 2022-05-09 | Schoolcraft | Michigan | 26153 | 1754 | 16 |
2484606 | 2484606 | 2022-05-08 | Schoolcraft | Michigan | 26153 | 1754 | 16 |
2481348 | 2481348 | 2022-05-07 | Schoolcraft | Michigan | 26153 | 1754 | 16 |
2478090 | 2478090 | 2022-05-06 | Schoolcraft | Michigan | 26153 | 1754 | 16 |
2473768 | 2473768 | 2022-05-05 | Conejos | Colorado | 8021 | 1754 | 54 |
2474832 | 2474832 | 2022-05-05 | Schoolcraft | Michigan | 26153 | 1754 | 16 |
2470511 | 2470511 | 2022-05-04 | Conejos | Colorado | 8021 | 1754 | 54 |
2471575 | 2471575 | 2022-05-04 | Schoolcraft | Michigan | 26153 | 1754 | 16 |
2467255 | 2467255 | 2022-05-03 | Conejos | Colorado | 8021 | 1754 | 54 |
2422272 | 2422272 | 2022-04-19 | Lucas | Iowa | 19117 | 1754 | 32 |
2419016 | 2419016 | 2022-04-18 | Lucas | Iowa | 19117 | 1754 | 32 |
2415760 | 2415760 | 2022-04-17 | Lucas | Iowa | 19117 | 1754 | 32 |
2412504 | 2412504 | 2022-04-16 | Lucas | Iowa | 19117 | 1754 | 32 |
2409248 | 2409248 | 2022-04-15 | Lucas | Iowa | 19117 | 1754 | 32 |
2405992 | 2405992 | 2022-04-14 | Lucas | Iowa | 19117 | 1754 | 32 |
2402736 | 2402736 | 2022-04-13 | Lucas | Iowa | 19117 | 1754 | 32 |
2399522 | 2399522 | 2022-04-12 | Worth | Iowa | 19195 | 1754 | 16 |
2396266 | 2396266 | 2022-04-11 | Worth | Iowa | 19195 | 1754 | 16 |
2393011 | 2393011 | 2022-04-10 | Worth | Iowa | 19195 | 1754 | 16 |
2389755 | 2389755 | 2022-04-09 | Worth | Iowa | 19195 | 1754 | 16 |
2386499 | 2386499 | 2022-04-08 | Worth | Iowa | 19195 | 1754 | 16 |
2383245 | 2383245 | 2022-04-07 | Worth | Iowa | 19195 | 1754 | 16 |
2379990 | 2379990 | 2022-04-06 | Worth | Iowa | 19195 | 1754 | 16 |
2376735 | 2376735 | 2022-04-05 | Worth | Iowa | 19195 | 1754 | 16 |
2373483 | 2373483 | 2022-04-04 | Worth | Iowa | 19195 | 1754 | 16 |
2370230 | 2370230 | 2022-04-03 | Worth | Iowa | 19195 | 1754 | 16 |
2366977 | 2366977 | 2022-04-02 | Worth | Iowa | 19195 | 1754 | 16 |
2363724 | 2363724 | 2022-04-01 | Worth | Iowa | 19195 | 1754 | 16 |
2360470 | 2360470 | 2022-03-31 | Worth | Iowa | 19195 | 1754 | 16 |
2357216 | 2357216 | 2022-03-30 | Worth | Iowa | 19195 | 1754 | 16 |
2353963 | 2353963 | 2022-03-29 | Worth | Iowa | 19195 | 1754 | 16 |
2350711 | 2350711 | 2022-03-28 | Worth | Iowa | 19195 | 1754 | 16 |
2347188 | 2347188 | 2022-03-27 | Edwards | Illinois | 17047 | 1754 | 29 |
2347458 | 2347458 | 2022-03-27 | Worth | Iowa | 19195 | 1754 | 16 |
2343935 | 2343935 | 2022-03-26 | Edwards | Illinois | 17047 | 1754 | 29 |
2344205 | 2344205 | 2022-03-26 | Worth | Iowa | 19195 | 1754 | 16 |
2340682 | 2340682 | 2022-03-25 | Edwards | Illinois | 17047 | 1754 | 29 |
2340952 | 2340952 | 2022-03-25 | Worth | Iowa | 19195 | 1754 | 16 |
2337699 | 2337699 | 2022-03-24 | Worth | Iowa | 19195 | 1754 | 16 |
2334445 | 2334445 | 2022-03-23 | Worth | Iowa | 19195 | 1754 | 16 |
2333238 | 2333238 | 2022-03-22 | Bland | Virginia | 51021 | 1754 | 21 |
2329985 | 2329985 | 2022-03-21 | Bland | Virginia | 51021 | 1754 | 21 |
2326733 | 2326733 | 2022-03-20 | Bland | Virginia | 51021 | 1754 | 21 |
2323480 | 2323480 | 2022-03-19 | Bland | Virginia | 51021 | 1754 | 21 |
2320226 | 2320226 | 2022-03-18 | Bland | Virginia | 51021 | 1754 | 21 |
2316972 | 2316972 | 2022-03-17 | Bland | Virginia | 51021 | 1754 | 21 |
2313719 | 2313719 | 2022-03-16 | Bland | Virginia | 51021 | 1754 | 21 |
2240982 | 2240982 | 2022-02-22 | Richardson | Nebraska | 31147 | 1754 | 24 |
2237731 | 2237731 | 2022-02-21 | Richardson | Nebraska | 31147 | 1754 | 24 |
2231853 | 2231853 | 2022-02-19 | Hormigueros | Puerto Rico | 72067 | 1754 | |
2228602 | 2228602 | 2022-02-18 | Hormigueros | Puerto Rico | 72067 | 1754 | |
2210603 | 2210603 | 2022-02-13 | Edwards | Illinois | 17047 | 1754 | 26 |
2207350 | 2207350 | 2022-02-12 | Edwards | Illinois | 17047 | 1754 | 26 |
2204097 | 2204097 | 2022-02-11 | Edwards | Illinois | 17047 | 1754 | 26 |
2200844 | 2200844 | 2022-02-10 | Edwards | Illinois | 17047 | 1754 | 26 |
2198503 | 2198503 | 2022-02-09 | Harrison | Missouri | 29081 | 1754 | 27 |
2164901 | 2164901 | 2022-01-30 | Irwin | Georgia | 13155 | 1754 | 42 |
2161646 | 2161646 | 2022-01-29 | Irwin | Georgia | 13155 | 1754 | 42 |
2158390 | 2158390 | 2022-01-28 | Irwin | Georgia | 13155 | 1754 | 42 |
2142568 | 2142568 | 2022-01-23 | Clay | Kansas | 20027 | 1754 | 32 |
2139313 | 2139313 | 2022-01-22 | Clay | Kansas | 20027 | 1754 | 32 |
2136057 | 2136057 | 2022-01-21 | Clay | Kansas | 20027 | 1754 | 32 |
2136745 | 2136745 | 2022-01-21 | St. Clair | Missouri | 29185 | 1754 | 29 |
2133266 | 2133266 | 2022-01-20 | Marshall | Minnesota | 27089 | 1754 | 23 |
2109605 | 2109605 | 2022-01-13 | Lanier | Georgia | 13173 | 1754 | 17 |
2110788 | 2110788 | 2022-01-13 | Sanders | Montana | 30089 | 1754 | 40 |
2099849 | 2099849 | 2022-01-10 | Johnson | Georgia | 13167 | 1754 | 64 |
2062099 | 2062099 | 2021-12-29 | Phelps | Nebraska | 31137 | 1754 | 11 |
2059628 | 2059628 | 2021-12-28 | Roberts | South Dakota | 46109 | 1754 | 45 |
2060064 | 2060064 | 2021-12-28 | Clarke | Virginia | 51043 | 1754 | 33 |
1998180 | 1998180 | 2021-12-09 | Runnels | Texas | 48399 | 1754 | 55 |
1987005 | 1987005 | 2021-12-06 | Swift | Minnesota | 27151 | 1754 | 24 |
1983775 | 1983775 | 2021-12-05 | Carroll | Mississippi | 28015 | 1754 | 41 |
1980525 | 1980525 | 2021-12-04 | Carroll | Mississippi | 28015 | 1754 | 41 |
1977275 | 1977275 | 2021-12-03 | Carroll | Mississippi | 28015 | 1754 | 41 |
1972271 | 1972271 | 2021-12-01 | Orange | Vermont | 50017 | 1754 | 7 |
1960607 | 1960607 | 2021-11-28 | Bath | Kentucky | 21011 | 1754 | 32 |
1957356 | 1957356 | 2021-11-27 | Bath | Kentucky | 21011 | 1754 | 32 |
1954105 | 1954105 | 2021-11-26 | Bath | Kentucky | 21011 | 1754 | 32 |
1950854 | 1950854 | 2021-11-25 | Bath | Kentucky | 21011 | 1754 | 32 |
1946769 | 1946769 | 2021-11-24 | Scott | Arkansas | 5127 | 1754 | 31 |
1947603 | 1947603 | 2021-11-24 | Bath | Kentucky | 21011 | 1754 | 32 |
1944199 | 1944199 | 2021-11-23 | Louisa | Iowa | 19115 | 1754 | 52 |
1945319 | 1945319 | 2021-11-23 | Pamlico | North Carolina | 37137 | 1754 | 26 |
1940949 | 1940949 | 2021-11-22 | Louisa | Iowa | 19115 | 1754 | 52 |
1937699 | 1937699 | 2021-11-21 | Louisa | Iowa | 19115 | 1754 | 52 |
1934449 | 1934449 | 2021-11-20 | Louisa | Iowa | 19115 | 1754 | 52 |
1931198 | 1931198 | 2021-11-19 | Louisa | Iowa | 19115 | 1754 | 52 |
1927158 | 1927158 | 2021-11-18 | Wilcox | Alabama | 1131 | 1754 | 38 |
1927947 | 1927947 | 2021-11-18 | Louisa | Iowa | 19115 | 1754 | 52 |
1924697 | 1924697 | 2021-11-17 | Louisa | Iowa | 19115 | 1754 | 52 |
1922485 | 1922485 | 2021-11-16 | Schuyler | New York | 36097 | 1754 | 19 |
1901231 | 1901231 | 2021-11-10 | Fulton | Arkansas | 5049 | 1754 | 64 |
1870257 | 1870257 | 2021-10-31 | Richland | Montana | 30083 | 1754 | 21 |
1867008 | 1867008 | 2021-10-30 | Richland | Montana | 30083 | 1754 | 21 |
1863759 | 1863759 | 2021-10-29 | Richland | Montana | 30083 | 1754 | 21 |
1861224 | 1861224 | 2021-10-28 | Juana Diaz | Puerto Rico | 72075 | 1754 | |
1857975 | 1857975 | 2021-10-27 | Juana Diaz | Puerto Rico | 72075 | 1754 | |
1854726 | 1854726 | 2021-10-26 | Juana Diaz | Puerto Rico | 72075 | 1754 |
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);