ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
475 rows where cases = 857 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 60
- Nebraska 38
- Texas 33
- Puerto Rico 19
- Virginia 18
- Kentucky 17
- Louisiana 17
- Minnesota 17
- Missouri 16
- West Virginia 15
- Idaho 13
- Iowa 12
- Michigan 12
- Colorado 11
- Ohio 11
- North Carolina 10
- Alabama 9
- Illinois 9
- Indiana 9
- Mississippi 9
- Arkansas 8
- Montana 8
- South Carolina 8
- Tennessee 8
- South Dakota 7
- Wisconsin 7
- Florida 6
- Washington 6
- Kansas 5
- Nevada 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2448871 | 2448871 | 2022-04-27 | Traverse | Minnesota | 27155 | 857 | 10 |
2445615 | 2445615 | 2022-04-26 | Traverse | Minnesota | 27155 | 857 | 10 |
2442359 | 2442359 | 2022-04-25 | Traverse | Minnesota | 27155 | 857 | 10 |
2439103 | 2439103 | 2022-04-24 | Traverse | Minnesota | 27155 | 857 | 10 |
2435847 | 2435847 | 2022-04-23 | Traverse | Minnesota | 27155 | 857 | 10 |
2432591 | 2432591 | 2022-04-22 | Traverse | Minnesota | 27155 | 857 | 10 |
2429335 | 2429335 | 2022-04-21 | Traverse | Minnesota | 27155 | 857 | 10 |
2426079 | 2426079 | 2022-04-20 | Traverse | Minnesota | 27155 | 857 | 10 |
2405457 | 2405457 | 2022-04-14 | Unknown | Delaware | 857 | 0 | |
2372879 | 2372879 | 2022-04-04 | Ouray | Colorado | 8091 | 857 | 6 |
2369626 | 2369626 | 2022-04-03 | Ouray | Colorado | 8091 | 857 | 6 |
2366373 | 2366373 | 2022-04-02 | Ouray | Colorado | 8091 | 857 | 6 |
2363120 | 2363120 | 2022-04-01 | Ouray | Colorado | 8091 | 857 | 6 |
2171009 | 2171009 | 2022-02-01 | Aleutians East Borough | Alaska | 2013 | 857 | 3 |
2167756 | 2167756 | 2022-01-31 | Aleutians East Borough | Alaska | 2013 | 857 | 3 |
2160656 | 2160656 | 2022-01-28 | Haskell | Texas | 48207 | 857 | 37 |
2151055 | 2151055 | 2022-01-25 | Garfield | Utah | 49017 | 857 | 12 |
2142098 | 2142098 | 2022-01-23 | Echols | Georgia | 13101 | 857 | 11 |
2138843 | 2138843 | 2022-01-22 | Echols | Georgia | 13101 | 857 | 11 |
2135587 | 2135587 | 2022-01-21 | Echols | Georgia | 13101 | 857 | 11 |
2136732 | 2136732 | 2022-01-21 | Putnam | Missouri | 29171 | 857 | 20 |
2132795 | 2132795 | 2022-01-20 | Barber | Kansas | 20007 | 857 | 8 |
2134635 | 2134635 | 2022-01-20 | Hudspeth | Texas | 48229 | 857 | 16 |
2129542 | 2129542 | 2022-01-19 | Barber | Kansas | 20007 | 857 | 8 |
2112178 | 2112178 | 2022-01-13 | Surry | Virginia | 51181 | 857 | 13 |
2104949 | 2104949 | 2022-01-11 | Sullivan | Pennsylvania | 42113 | 857 | 32 |
2099941 | 2099941 | 2022-01-10 | Boise | Idaho | 16015 | 857 | 11 |
2088073 | 2088073 | 2022-01-06 | Furnas | Nebraska | 31065 | 857 | 6 |
2080166 | 2080166 | 2022-01-04 | Saguache | Colorado | 8109 | 857 | 10 |
2081538 | 2081538 | 2022-01-04 | Antelope | Nebraska | 31003 | 857 | 10 |
2078286 | 2078286 | 2022-01-03 | Antelope | Nebraska | 31003 | 857 | 10 |
2078290 | 2078290 | 2022-01-03 | Boone | Nebraska | 31011 | 857 | 4 |
2073951 | 2073951 | 2022-01-02 | Lewis | Idaho | 16061 | 857 | 23 |
2070700 | 2070700 | 2022-01-01 | Lewis | Idaho | 16061 | 857 | 23 |
2072482 | 2072482 | 2022-01-01 | Jayuya | Puerto Rico | 72073 | 857 | |
2067449 | 2067449 | 2021-12-31 | Lewis | Idaho | 16061 | 857 | 23 |
2069231 | 2069231 | 2021-12-31 | Jayuya | Puerto Rico | 72073 | 857 | |
2064198 | 2064198 | 2021-12-30 | Lewis | Idaho | 16061 | 857 | 23 |
2060948 | 2060948 | 2021-12-29 | Lewis | Idaho | 16061 | 857 | 23 |
2062723 | 2062723 | 2021-12-29 | Guayanilla | Puerto Rico | 72059 | 857 | |
2056228 | 2056228 | 2021-12-27 | Hormigueros | Puerto Rico | 72067 | 857 | |
2019148 | 2019148 | 2021-12-16 | Fulton | Kentucky | 21075 | 857 | 22 |
2020615 | 2020615 | 2021-12-16 | Lyman | South Dakota | 46085 | 857 | 11 |
2015268 | 2015268 | 2021-12-15 | Calhoun | Georgia | 13037 | 857 | 21 |
2015490 | 2015490 | 2021-12-15 | Gallatin | Illinois | 17059 | 857 | 11 |
1997096 | 1997096 | 2021-12-09 | Polk | Nebraska | 31143 | 857 | 18 |
1992376 | 1992376 | 2021-12-08 | Huerfano | Colorado | 8055 | 857 | 23 |
1993799 | 1993799 | 2021-12-08 | Dixon | Nebraska | 31051 | 857 | 11 |
1993845 | 1993845 | 2021-12-08 | Polk | Nebraska | 31143 | 857 | 18 |
1989125 | 1989125 | 2021-12-07 | Huerfano | Colorado | 8055 | 857 | 23 |
1989261 | 1989261 | 2021-12-07 | Calhoun | Georgia | 13037 | 857 | 21 |
1985442 | 1985442 | 2021-12-05 | Skamania | Washington | 53059 | 857 | 7 |
1982192 | 1982192 | 2021-12-04 | Skamania | Washington | 53059 | 857 | 7 |
1978942 | 1978942 | 2021-12-03 | Skamania | Washington | 53059 | 857 | 7 |
1974375 | 1974375 | 2021-12-02 | Lander | Nevada | 32015 | 857 | 16 |
1975383 | 1975383 | 2021-12-02 | Martin | Texas | 48317 | 857 | 24 |
1968056 | 1968056 | 2021-11-30 | Hyde | North Carolina | 37095 | 857 | 12 |
1960009 | 1960009 | 2021-11-28 | Calhoun | Georgia | 13037 | 857 | 21 |
1956758 | 1956758 | 2021-11-27 | Calhoun | Georgia | 13037 | 857 | 21 |
1953507 | 1953507 | 2021-11-26 | Calhoun | Georgia | 13037 | 857 | 21 |
1950256 | 1950256 | 2021-11-25 | Calhoun | Georgia | 13037 | 857 | 21 |
1947005 | 1947005 | 2021-11-24 | Calhoun | Georgia | 13037 | 857 | 21 |
1943754 | 1943754 | 2021-11-23 | Calhoun | Georgia | 13037 | 857 | 21 |
1940504 | 1940504 | 2021-11-22 | Calhoun | Georgia | 13037 | 857 | 21 |
1937254 | 1937254 | 2021-11-21 | Calhoun | Georgia | 13037 | 857 | 21 |
1938212 | 1938212 | 2021-11-21 | Lincoln | Minnesota | 27081 | 857 | 5 |
1934004 | 1934004 | 2021-11-20 | Calhoun | Georgia | 13037 | 857 | 21 |
1934962 | 1934962 | 2021-11-20 | Lincoln | Minnesota | 27081 | 857 | 5 |
1930752 | 1930752 | 2021-11-19 | Calhoun | Georgia | 13037 | 857 | 21 |
1931712 | 1931712 | 2021-11-19 | Lincoln | Minnesota | 27081 | 857 | 5 |
1927348 | 1927348 | 2021-11-18 | Clear Creek | Colorado | 8019 | 857 | 6 |
1929871 | 1929871 | 2021-11-18 | Lynn | Texas | 48305 | 857 | 27 |
1920741 | 1920741 | 2021-11-16 | Lafayette | Arkansas | 5073 | 857 | 28 |
1915775 | 1915775 | 2021-11-14 | Burt | Nebraska | 31021 | 857 | 13 |
1912525 | 1912525 | 2021-11-13 | Burt | Nebraska | 31021 | 857 | 13 |
1909275 | 1909275 | 2021-11-12 | Burt | Nebraska | 31021 | 857 | 13 |
1895680 | 1895680 | 2021-11-08 | Menifee | Kentucky | 21165 | 857 | 23 |
1897666 | 1897666 | 2021-11-08 | Ferry | Washington | 53019 | 857 | 15 |
1892430 | 1892430 | 2021-11-07 | Menifee | Kentucky | 21165 | 857 | 23 |
1889180 | 1889180 | 2021-11-06 | Menifee | Kentucky | 21165 | 857 | 23 |
1891248 | 1891248 | 2021-11-06 | Wirt | West Virginia | 54105 | 857 | 13 |
1885930 | 1885930 | 2021-11-05 | Menifee | Kentucky | 21165 | 857 | 23 |
1882006 | 1882006 | 2021-11-04 | Calhoun | Georgia | 13037 | 857 | 21 |
1878757 | 1878757 | 2021-11-03 | Calhoun | Georgia | 13037 | 857 | 21 |
1876763 | 1876763 | 2021-11-02 | Teton | Montana | 30099 | 857 | 13 |
1861581 | 1861581 | 2021-10-28 | Hartley | Texas | 48205 | 857 | 2 |
1858332 | 1858332 | 2021-10-27 | Hartley | Texas | 48205 | 857 | 2 |
1855083 | 1855083 | 2021-10-26 | Hartley | Texas | 48205 | 857 | 2 |
1838507 | 1838507 | 2021-10-21 | Santa Isabel | Puerto Rico | 72133 | 857 | |
1836093 | 1836093 | 2021-10-20 | Hot Springs | Wyoming | 56017 | 857 | 8 |
1830991 | 1830991 | 2021-10-19 | Norman | Minnesota | 27107 | 857 | 9 |
1831640 | 1831640 | 2021-10-19 | McHenry | North Dakota | 38049 | 857 | 23 |
1832286 | 1832286 | 2021-10-19 | Crane | Texas | 48103 | 857 | 17 |
1824245 | 1824245 | 2021-10-17 | Cameron | Louisiana | 22023 | 857 | 9 |
1820996 | 1820996 | 2021-10-16 | Cameron | Louisiana | 22023 | 857 | 9 |
1817747 | 1817747 | 2021-10-15 | Cameron | Louisiana | 22023 | 857 | 9 |
1814499 | 1814499 | 2021-10-14 | Cameron | Louisiana | 22023 | 857 | 9 |
1815190 | 1815190 | 2021-10-14 | Guadalupe | New Mexico | 35019 | 857 | 15 |
1811250 | 1811250 | 2021-10-13 | Cameron | Louisiana | 22023 | 857 | 9 |
1806409 | 1806409 | 2021-10-11 | Mills | Texas | 48333 | 857 | 26 |
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);