ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
205 rows where cases = 2528 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 22
- Iowa 19
- Tennessee 13
- Kentucky 12
- Missouri 11
- Puerto Rico 11
- Virginia 11
- Florida 10
- Georgia 9
- Arkansas 8
- Ohio 8
- Indiana 7
- Louisiana 6
- Mississippi 6
- Alabama 5
- Michigan 5
- North Carolina 5
- Kansas 4
- New Hampshire 4
- Wisconsin 4
- Nebraska 3
- New York 3
- West Virginia 3
- California 2
- Idaho 2
- Illinois 2
- Oregon 2
- South Carolina 2
- Arizona 1
- Colorado 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2387961 | 2387961 | 2022-04-08 | Ciales | Puerto Rico | 72039 | 2528 | |
2369853 | 2369853 | 2022-04-03 | Stewart | Georgia | 13259 | 2528 | 32 |
2366600 | 2366600 | 2022-04-02 | Stewart | Georgia | 13259 | 2528 | 32 |
2363347 | 2363347 | 2022-04-01 | Stewart | Georgia | 13259 | 2528 | 32 |
2358966 | 2358966 | 2022-03-30 | Blanco | Texas | 48031 | 2528 | 34 |
2359173 | 2359173 | 2022-03-30 | Terry | Texas | 48445 | 2528 | 84 |
2282110 | 2282110 | 2022-03-07 | Valley | Idaho | 16085 | 2528 | 16 |
2279289 | 2279289 | 2022-03-06 | Edmonson | Kentucky | 21061 | 2528 | 38 |
2276036 | 2276036 | 2022-03-05 | Edmonson | Kentucky | 21061 | 2528 | 38 |
2272783 | 2272783 | 2022-03-04 | Edmonson | Kentucky | 21061 | 2528 | 38 |
2269216 | 2269216 | 2022-03-03 | Crawford | Indiana | 18025 | 2528 | 36 |
2269762 | 2269762 | 2022-03-03 | Crawford | Michigan | 26039 | 2528 | 29 |
2266509 | 2266509 | 2022-03-02 | Crawford | Michigan | 26039 | 2528 | 29 |
2248490 | 2248490 | 2022-02-24 | Jim Hogg | Texas | 48247 | 2528 | 21 |
2219053 | 2219053 | 2022-02-15 | Houston | Tennessee | 47083 | 2528 | 56 |
2215802 | 2215802 | 2022-02-14 | Houston | Tennessee | 47083 | 2528 | 56 |
2212551 | 2212551 | 2022-02-13 | Houston | Tennessee | 47083 | 2528 | 56 |
2209298 | 2209298 | 2022-02-12 | Houston | Tennessee | 47083 | 2528 | 56 |
2206045 | 2206045 | 2022-02-11 | Houston | Tennessee | 47083 | 2528 | 56 |
2202792 | 2202792 | 2022-02-10 | Houston | Tennessee | 47083 | 2528 | 56 |
2198893 | 2198893 | 2022-02-09 | Clay | North Carolina | 37043 | 2528 | 38 |
2199538 | 2199538 | 2022-02-09 | Houston | Tennessee | 47083 | 2528 | 56 |
2164569 | 2164569 | 2022-01-30 | Fulton | Arkansas | 5049 | 2528 | 81 |
2161314 | 2161314 | 2022-01-29 | Fulton | Arkansas | 5049 | 2528 | 81 |
2158058 | 2158058 | 2022-01-28 | Fulton | Arkansas | 5049 | 2528 | 81 |
2148965 | 2148965 | 2022-01-25 | Appanoose | Iowa | 19007 | 2528 | 60 |
2145131 | 2145131 | 2022-01-24 | Plumas | California | 6063 | 2528 | 12 |
2145713 | 2145713 | 2022-01-24 | Appanoose | Iowa | 19007 | 2528 | 60 |
2142458 | 2142458 | 2022-01-23 | Appanoose | Iowa | 19007 | 2528 | 60 |
2139203 | 2139203 | 2022-01-22 | Appanoose | Iowa | 19007 | 2528 | 60 |
2135947 | 2135947 | 2022-01-21 | Appanoose | Iowa | 19007 | 2528 | 60 |
2132235 | 2132235 | 2022-01-20 | Franklin | Florida | 12037 | 2528 | 46 |
2132695 | 2132695 | 2022-01-20 | Appanoose | Iowa | 19007 | 2528 | 60 |
2128982 | 2128982 | 2022-01-19 | Franklin | Florida | 12037 | 2528 | 46 |
2129442 | 2129442 | 2022-01-19 | Appanoose | Iowa | 19007 | 2528 | 60 |
2125728 | 2125728 | 2022-01-18 | Franklin | Florida | 12037 | 2528 | 46 |
2122476 | 2122476 | 2022-01-17 | Franklin | Florida | 12037 | 2528 | 46 |
2119224 | 2119224 | 2022-01-16 | Franklin | Florida | 12037 | 2528 | 46 |
2115972 | 2115972 | 2022-01-15 | Franklin | Florida | 12037 | 2528 | 46 |
2112721 | 2112721 | 2022-01-14 | Franklin | Florida | 12037 | 2528 | 46 |
2102048 | 2102048 | 2022-01-10 | Comanche | Texas | 48093 | 2528 | 67 |
2092469 | 2092469 | 2022-01-07 | Terry | Texas | 48445 | 2528 | 73 |
2084854 | 2084854 | 2022-01-05 | Otoe | Nebraska | 31131 | 2528 | 16 |
2057266 | 2057266 | 2021-12-28 | Marion | Arkansas | 5089 | 2528 | 70 |
2033883 | 2033883 | 2021-12-20 | Leon | Texas | 48289 | 2528 | 72 |
2034089 | 2034089 | 2021-12-20 | Giles | Virginia | 51071 | 2528 | 35 |
2030633 | 2030633 | 2021-12-19 | Leon | Texas | 48289 | 2528 | 72 |
2019859 | 2019859 | 2021-12-16 | Seward | Nebraska | 31159 | 2528 | 38 |
2017502 | 2017502 | 2021-12-15 | Bosque | Texas | 48035 | 2528 | 57 |
1991632 | 1991632 | 2021-12-07 | Madison | Texas | 48313 | 2528 | 45 |
1987634 | 1987634 | 2021-12-06 | McKenzie | North Dakota | 38053 | 2528 | 22 |
1970414 | 1970414 | 2021-12-01 | Knott | Kentucky | 21119 | 2528 | 43 |
1962992 | 1962992 | 2021-11-29 | Howard | Arkansas | 5061 | 2528 | 38 |
1944238 | 1944238 | 2021-11-23 | Winneshiek | Iowa | 19191 | 2528 | 41 |
1940988 | 1940988 | 2021-11-22 | Winneshiek | Iowa | 19191 | 2528 | 41 |
1937738 | 1937738 | 2021-11-21 | Winneshiek | Iowa | 19191 | 2528 | 41 |
1934488 | 1934488 | 2021-11-20 | Winneshiek | Iowa | 19191 | 2528 | 41 |
1931237 | 1931237 | 2021-11-19 | Winneshiek | Iowa | 19191 | 2528 | 41 |
1927986 | 1927986 | 2021-11-18 | Winneshiek | Iowa | 19191 | 2528 | 41 |
1924736 | 1924736 | 2021-11-17 | Winneshiek | Iowa | 19191 | 2528 | 41 |
1920608 | 1920608 | 2021-11-16 | Cleburne | Alabama | 1029 | 2528 | 60 |
1922992 | 1922992 | 2021-11-16 | San Sebastian | Puerto Rico | 72131 | 2528 | |
1875163 | 1875163 | 2021-11-02 | Washington | Alabama | 1129 | 2528 | 52 |
1870182 | 1870182 | 2021-10-31 | Pike | Missouri | 29163 | 2528 | 37 |
1852865 | 1852865 | 2021-10-26 | Rabun | Georgia | 13241 | 2528 | 63 |
1835528 | 1835528 | 2021-10-20 | Colorado | Texas | 48089 | 2528 | 51 |
1818228 | 1818228 | 2021-10-15 | Wright | Missouri | 29229 | 2528 | 47 |
1810904 | 1810904 | 2021-10-13 | Vermillion | Indiana | 18165 | 2528 | 54 |
1813071 | 1813071 | 2021-10-13 | Colonial Heights city | Virginia | 51570 | 2528 | 64 |
1809837 | 1809837 | 2021-10-12 | Fluvanna | Virginia | 51065 | 2528 | 22 |
1785682 | 1785682 | 2021-10-05 | Livingston | Missouri | 29117 | 2528 | 62 |
1764503 | 1764503 | 2021-09-28 | McDowell | West Virginia | 54047 | 2528 | 39 |
1756792 | 1756792 | 2021-09-26 | Avery | North Carolina | 37011 | 2528 | 31 |
1753544 | 1753544 | 2021-09-25 | Avery | North Carolina | 37011 | 2528 | 31 |
1750296 | 1750296 | 2021-09-24 | Avery | North Carolina | 37011 | 2528 | 31 |
1700901 | 1700901 | 2021-09-09 | Alpena | Michigan | 26007 | 2528 | 66 |
1697652 | 1697652 | 2021-09-08 | Alpena | Michigan | 26007 | 2528 | 66 |
1691054 | 1691054 | 2021-09-06 | Jackson | Louisiana | 22049 | 2528 | 58 |
1692716 | 1692716 | 2021-09-06 | Panola | Texas | 48365 | 2528 | 89 |
1687804 | 1687804 | 2021-09-05 | Jackson | Louisiana | 22049 | 2528 | 58 |
1689689 | 1689689 | 2021-09-05 | Radford city | Virginia | 51750 | 2528 | 29 |
1684554 | 1684554 | 2021-09-04 | Jackson | Louisiana | 22049 | 2528 | 58 |
1686439 | 1686439 | 2021-09-04 | Radford city | Virginia | 51750 | 2528 | 29 |
1681303 | 1681303 | 2021-09-03 | Jackson | Louisiana | 22049 | 2528 | 58 |
1682952 | 1682952 | 2021-09-03 | Montague | Texas | 48337 | 2528 | 76 |
1683188 | 1683188 | 2021-09-03 | Radford city | Virginia | 51750 | 2528 | 29 |
1673718 | 1673718 | 2021-09-01 | Randolph | Alabama | 1111 | 2528 | 54 |
1670543 | 1670543 | 2021-08-31 | Cross | Arkansas | 5037 | 2528 | 58 |
1668247 | 1668247 | 2021-08-30 | McCreary | Kentucky | 21147 | 2528 | 34 |
1653964 | 1653964 | 2021-08-25 | Russell | Virginia | 51167 | 2528 | 41 |
1642759 | 1642759 | 2021-08-22 | Perry | Missouri | 29157 | 2528 | 30 |
1583479 | 1583479 | 2021-08-04 | Randolph | Indiana | 18135 | 2528 | 85 |
1584952 | 1584952 | 2021-08-04 | Jefferson | Oregon | 41031 | 2528 | 42 |
1574743 | 1574743 | 2021-08-01 | Carroll | New Hampshire | 33003 | 2528 | 13 |
1571495 | 1571495 | 2021-07-31 | Carroll | New Hampshire | 33003 | 2528 | 13 |
1568247 | 1568247 | 2021-07-30 | Carroll | New Hampshire | 33003 | 2528 | 13 |
1565360 | 1565360 | 2021-07-29 | Van Wert | Ohio | 39161 | 2528 | 65 |
1556124 | 1556124 | 2021-07-26 | Burleson | Texas | 48051 | 2528 | 48 |
1516873 | 1516873 | 2021-07-14 | Humacao | Puerto Rico | 72069 | 2528 | |
1505860 | 1505860 | 2021-07-11 | Ohio | Kentucky | 21183 | 2528 | 55 |
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);