ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
985 rows where cases = 160 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 112
- Montana 66
- Puerto Rico 53
- Virginia 40
- Georgia 36
- Kansas 36
- Iowa 33
- Indiana 32
- North Dakota 32
- Kentucky 30
- Nebraska 28
- Colorado 26
- Ohio 26
- Illinois 25
- Michigan 25
- Missouri 25
- North Carolina 24
- California 22
- Pennsylvania 20
- South Dakota 20
- Wisconsin 20
- Mississippi 19
- Minnesota 18
- Tennessee 18
- Florida 15
- Oklahoma 15
- Oregon 15
- New York 14
- West Virginia 13
- Washington 12
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2248098 | 2248098 | 2022-02-24 | Culebra | Puerto Rico | 72049 | 160 | |
2244847 | 2244847 | 2022-02-23 | Culebra | Puerto Rico | 72049 | 160 | |
2241596 | 2241596 | 2022-02-22 | Culebra | Puerto Rico | 72049 | 160 | |
2238345 | 2238345 | 2022-02-21 | Culebra | Puerto Rico | 72049 | 160 | |
2235094 | 2235094 | 2022-02-20 | Culebra | Puerto Rico | 72049 | 160 | |
2231843 | 2231843 | 2022-02-19 | Culebra | Puerto Rico | 72049 | 160 | |
2228592 | 2228592 | 2022-02-18 | Culebra | Puerto Rico | 72049 | 160 | |
2225341 | 2225341 | 2022-02-17 | Culebra | Puerto Rico | 72049 | 160 | |
2222090 | 2222090 | 2022-02-16 | Culebra | Puerto Rico | 72049 | 160 | |
2218839 | 2218839 | 2022-02-15 | Culebra | Puerto Rico | 72049 | 160 | |
2215588 | 2215588 | 2022-02-14 | Culebra | Puerto Rico | 72049 | 160 | |
2212337 | 2212337 | 2022-02-13 | Culebra | Puerto Rico | 72049 | 160 | |
2209084 | 2209084 | 2022-02-12 | Culebra | Puerto Rico | 72049 | 160 | |
2205831 | 2205831 | 2022-02-11 | Culebra | Puerto Rico | 72049 | 160 | |
2202578 | 2202578 | 2022-02-10 | Culebra | Puerto Rico | 72049 | 160 | |
2199324 | 2199324 | 2022-02-09 | Culebra | Puerto Rico | 72049 | 160 | |
2196070 | 2196070 | 2022-02-08 | Culebra | Puerto Rico | 72049 | 160 | |
2192816 | 2192816 | 2022-02-07 | Culebra | Puerto Rico | 72049 | 160 | |
2189562 | 2189562 | 2022-02-06 | Culebra | Puerto Rico | 72049 | 160 | |
2186309 | 2186309 | 2022-02-05 | Culebra | Puerto Rico | 72049 | 160 | |
2186774 | 2186774 | 2022-02-05 | Roberts | Texas | 48393 | 160 | 1 |
2183057 | 2183057 | 2022-02-04 | Culebra | Puerto Rico | 72049 | 160 | |
2183522 | 2183522 | 2022-02-04 | Roberts | Texas | 48393 | 160 | 1 |
2179805 | 2179805 | 2022-02-03 | Culebra | Puerto Rico | 72049 | 160 | |
2134395 | 2134395 | 2022-01-20 | Jones | South Dakota | 46075 | 160 | 1 |
2099661 | 2099661 | 2022-01-10 | Mineral | Colorado | 8079 | 160 | 1 |
2085875 | 2085875 | 2022-01-05 | Kent | Texas | 48263 | 160 | 3 |
2055607 | 2055607 | 2021-12-27 | Rock | Nebraska | 31149 | 160 | 2 |
2052357 | 2052357 | 2021-12-26 | Rock | Nebraska | 31149 | 160 | 2 |
2053324 | 2053324 | 2021-12-26 | Glasscock | Texas | 48173 | 160 | 3 |
2049107 | 2049107 | 2021-12-25 | Rock | Nebraska | 31149 | 160 | 2 |
2050074 | 2050074 | 2021-12-25 | Glasscock | Texas | 48173 | 160 | 3 |
2045857 | 2045857 | 2021-12-24 | Rock | Nebraska | 31149 | 160 | 2 |
2046824 | 2046824 | 2021-12-24 | Glasscock | Texas | 48173 | 160 | 3 |
2042607 | 2042607 | 2021-12-23 | Rock | Nebraska | 31149 | 160 | 2 |
2043574 | 2043574 | 2021-12-23 | Glasscock | Texas | 48173 | 160 | 3 |
2039358 | 2039358 | 2021-12-22 | Rock | Nebraska | 31149 | 160 | 2 |
2040325 | 2040325 | 2021-12-22 | Glasscock | Texas | 48173 | 160 | 3 |
2037075 | 2037075 | 2021-12-21 | Glasscock | Texas | 48173 | 160 | 3 |
1987233 | 1987233 | 2021-12-06 | Garfield | Montana | 30033 | 160 | 3 |
1970984 | 1970984 | 2021-12-01 | Garfield | Montana | 30033 | 160 | 3 |
1967734 | 1967734 | 2021-11-30 | Garfield | Montana | 30033 | 160 | 3 |
1964482 | 1964482 | 2021-11-29 | Garfield | Montana | 30033 | 160 | 3 |
1961231 | 1961231 | 2021-11-28 | Garfield | Montana | 30033 | 160 | 3 |
1957980 | 1957980 | 2021-11-27 | Garfield | Montana | 30033 | 160 | 3 |
1954729 | 1954729 | 2021-11-26 | Garfield | Montana | 30033 | 160 | 3 |
1915731 | 1915731 | 2021-11-14 | Judith Basin | Montana | 30045 | 160 | 1 |
1912481 | 1912481 | 2021-11-13 | Judith Basin | Montana | 30045 | 160 | 1 |
1909231 | 1909231 | 2021-11-12 | Judith Basin | Montana | 30045 | 160 | 1 |
1893868 | 1893868 | 2021-11-07 | Sully | South Dakota | 46119 | 160 | 3 |
1890618 | 1890618 | 2021-11-06 | Sully | South Dakota | 46119 | 160 | 3 |
1887368 | 1887368 | 2021-11-05 | Sully | South Dakota | 46119 | 160 | 3 |
1870255 | 1870255 | 2021-10-31 | Prairie | Montana | 30079 | 160 | 2 |
1867006 | 1867006 | 2021-10-30 | Prairie | Montana | 30079 | 160 | 2 |
1863757 | 1863757 | 2021-10-29 | Prairie | Montana | 30079 | 160 | 2 |
1860508 | 1860508 | 2021-10-28 | Prairie | Montana | 30079 | 160 | 2 |
1861110 | 1861110 | 2021-10-28 | Sherman | Oregon | 41055 | 160 | 3 |
1857861 | 1857861 | 2021-10-27 | Sherman | Oregon | 41055 | 160 | 3 |
1848350 | 1848350 | 2021-10-24 | Harding | South Dakota | 46063 | 160 | 1 |
1845100 | 1845100 | 2021-10-23 | Harding | South Dakota | 46063 | 160 | 1 |
1841850 | 1841850 | 2021-10-22 | Harding | South Dakota | 46063 | 160 | 1 |
1838601 | 1838601 | 2021-10-21 | Harding | South Dakota | 46063 | 160 | 1 |
1835352 | 1835352 | 2021-10-20 | Harding | South Dakota | 46063 | 160 | 1 |
1813011 | 1813011 | 2021-10-13 | Piute | Utah | 49031 | 160 | 2 |
1809762 | 1809762 | 2021-10-12 | Piute | Utah | 49031 | 160 | 2 |
1785071 | 1785071 | 2021-10-05 | Lane | Kansas | 20101 | 160 | 7 |
1781822 | 1781822 | 2021-10-04 | Lane | Kansas | 20101 | 160 | 7 |
1777879 | 1777879 | 2021-10-03 | Cheyenne | Colorado | 8017 | 160 | 7 |
1774629 | 1774629 | 2021-10-02 | Cheyenne | Colorado | 8017 | 160 | 7 |
1771379 | 1771379 | 2021-10-01 | Cheyenne | Colorado | 8017 | 160 | 7 |
1768130 | 1768130 | 2021-09-30 | Cheyenne | Colorado | 8017 | 160 | 7 |
1764365 | 1764365 | 2021-09-28 | Highland | Virginia | 51091 | 160 | 1 |
1741477 | 1741477 | 2021-09-21 | Sterling | Texas | 48431 | 160 | 5 |
1735463 | 1735463 | 2021-09-20 | Haines Borough | Alaska | 2100 | 160 | 0 |
1735650 | 1735650 | 2021-09-20 | Dolores | Colorado | 8033 | 160 | 1 |
1738228 | 1738228 | 2021-09-20 | Sterling | Texas | 48431 | 160 | 5 |
1732213 | 1732213 | 2021-09-19 | Haines Borough | Alaska | 2100 | 160 | 0 |
1734978 | 1734978 | 2021-09-19 | Sterling | Texas | 48431 | 160 | 5 |
1728963 | 1728963 | 2021-09-18 | Haines Borough | Alaska | 2100 | 160 | 0 |
1731728 | 1731728 | 2021-09-18 | Sterling | Texas | 48431 | 160 | 5 |
1725713 | 1725713 | 2021-09-17 | Haines Borough | Alaska | 2100 | 160 | 0 |
1716413 | 1716413 | 2021-09-14 | Taliaferro | Georgia | 13265 | 160 | 3 |
1698025 | 1698025 | 2021-09-08 | Carter | Montana | 30011 | 160 | 5 |
1670487 | 1670487 | 2021-08-31 | Denali Borough | Alaska | 2068 | 160 | 0 |
1649323 | 1649323 | 2021-08-24 | Meagher | Montana | 30059 | 160 | 7 |
1646074 | 1646074 | 2021-08-23 | Meagher | Montana | 30059 | 160 | 7 |
1642825 | 1642825 | 2021-08-22 | Meagher | Montana | 30059 | 160 | 7 |
1644089 | 1644089 | 2021-08-22 | Wayne | Utah | 49055 | 160 | 0 |
1639575 | 1639575 | 2021-08-21 | Meagher | Montana | 30059 | 160 | 7 |
1640839 | 1640839 | 2021-08-21 | Wayne | Utah | 49055 | 160 | 0 |
1636325 | 1636325 | 2021-08-20 | Meagher | Montana | 30059 | 160 | 7 |
1637589 | 1637589 | 2021-08-20 | Wayne | Utah | 49055 | 160 | 0 |
1633075 | 1633075 | 2021-08-19 | Meagher | Montana | 30059 | 160 | 7 |
1629828 | 1629828 | 2021-08-18 | Meagher | Montana | 30059 | 160 | 7 |
1600990 | 1600990 | 2021-08-09 | Oliver | North Dakota | 38065 | 160 | 3 |
1597356 | 1597356 | 2021-08-08 | Powder River | Montana | 30075 | 160 | 8 |
1597742 | 1597742 | 2021-08-08 | Oliver | North Dakota | 38065 | 160 | 3 |
1594107 | 1594107 | 2021-08-07 | Powder River | Montana | 30075 | 160 | 8 |
1594493 | 1594493 | 2021-08-07 | Oliver | North Dakota | 38065 | 160 | 3 |
1590858 | 1590858 | 2021-08-06 | Powder River | Montana | 30075 | 160 | 8 |
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);