ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
988 rows where cases = 207 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 133
- Nebraska 87
- Alaska 53
- Kansas 42
- Montana 39
- Virginia 34
- Georgia 33
- Kentucky 33
- Minnesota 28
- North Carolina 28
- Indiana 27
- Puerto Rico 27
- Colorado 26
- Oregon 25
- Michigan 24
- Illinois 22
- Iowa 22
- Missouri 21
- New York 21
- South Dakota 21
- Washington 21
- West Virginia 20
- Mississippi 17
- Ohio 17
- Oklahoma 16
- Arkansas 13
- Tennessee 13
- Florida 12
- North Dakota 11
- Pennsylvania 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498680 | 2498680 | 2022-05-12 | Culebra | Puerto Rico | 72049 | 207 | |
2476221 | 2476221 | 2022-05-05 | Foard | Texas | 48155 | 207 | 11 |
2472964 | 2472964 | 2022-05-04 | Foard | Texas | 48155 | 207 | 11 |
2342817 | 2342817 | 2022-03-25 | Kent | Texas | 48263 | 207 | 4 |
2192094 | 2192094 | 2022-02-07 | Judith Basin | Montana | 30045 | 207 | 1 |
2192723 | 2192723 | 2022-02-07 | Wheeler | Oregon | 41069 | 207 | 3 |
2188841 | 2188841 | 2022-02-06 | Judith Basin | Montana | 30045 | 207 | 1 |
2189469 | 2189469 | 2022-02-06 | Wheeler | Oregon | 41069 | 207 | 3 |
2185588 | 2185588 | 2022-02-05 | Judith Basin | Montana | 30045 | 207 | 1 |
2186216 | 2186216 | 2022-02-05 | Wheeler | Oregon | 41069 | 207 | 3 |
2182336 | 2182336 | 2022-02-04 | Judith Basin | Montana | 30045 | 207 | 1 |
2182964 | 2182964 | 2022-02-04 | Wheeler | Oregon | 41069 | 207 | 3 |
2179084 | 2179084 | 2022-02-03 | Judith Basin | Montana | 30045 | 207 | 1 |
2179712 | 2179712 | 2022-02-03 | Wheeler | Oregon | 41069 | 207 | 3 |
2176461 | 2176461 | 2022-02-02 | Wheeler | Oregon | 41069 | 207 | 3 |
2173207 | 2173207 | 2022-02-01 | Wheeler | Oregon | 41069 | 207 | 3 |
2169955 | 2169955 | 2022-01-31 | Wheeler | Oregon | 41069 | 207 | 3 |
2166701 | 2166701 | 2022-01-30 | Wheeler | Oregon | 41069 | 207 | 3 |
2163446 | 2163446 | 2022-01-29 | Wheeler | Oregon | 41069 | 207 | 3 |
2160191 | 2160191 | 2022-01-28 | Wheeler | Oregon | 41069 | 207 | 3 |
2156935 | 2156935 | 2022-01-27 | Wheeler | Oregon | 41069 | 207 | 3 |
2153682 | 2153682 | 2022-01-26 | Wheeler | Oregon | 41069 | 207 | 3 |
2148450 | 2148450 | 2022-01-25 | Mineral | Colorado | 8079 | 207 | 1 |
2149796 | 2149796 | 2022-01-25 | Garfield | Montana | 30033 | 207 | 3 |
2059853 | 2059853 | 2021-12-28 | Irion | Texas | 48235 | 207 | 2 |
2056241 | 2056241 | 2021-12-27 | Maricao | Puerto Rico | 72093 | 207 | |
2052992 | 2052992 | 2021-12-26 | Maricao | Puerto Rico | 72093 | 207 | |
2049742 | 2049742 | 2021-12-25 | Maricao | Puerto Rico | 72093 | 207 | |
2033586 | 2033586 | 2021-12-20 | Campbell | South Dakota | 46021 | 207 | 6 |
2030336 | 2030336 | 2021-12-19 | Campbell | South Dakota | 46021 | 207 | 6 |
2030758 | 2030758 | 2021-12-19 | Piute | Utah | 49031 | 207 | 2 |
2027085 | 2027085 | 2021-12-18 | Campbell | South Dakota | 46021 | 207 | 6 |
2027507 | 2027507 | 2021-12-18 | Piute | Utah | 49031 | 207 | 2 |
2023834 | 2023834 | 2021-12-17 | Campbell | South Dakota | 46021 | 207 | 6 |
2024256 | 2024256 | 2021-12-17 | Piute | Utah | 49031 | 207 | 2 |
2020583 | 2020583 | 2021-12-16 | Campbell | South Dakota | 46021 | 207 | 6 |
2021005 | 2021005 | 2021-12-16 | Piute | Utah | 49031 | 207 | 2 |
2013228 | 2013228 | 2021-12-14 | Carter | Montana | 30011 | 207 | 5 |
2009977 | 2009977 | 2021-12-13 | Carter | Montana | 30011 | 207 | 5 |
2006726 | 2006726 | 2021-12-12 | Carter | Montana | 30011 | 207 | 5 |
2003475 | 2003475 | 2021-12-11 | Carter | Montana | 30011 | 207 | 5 |
2000225 | 2000225 | 2021-12-10 | Carter | Montana | 30011 | 207 | 5 |
1996974 | 1996974 | 2021-12-09 | Carter | Montana | 30011 | 207 | 5 |
1993723 | 1993723 | 2021-12-08 | Carter | Montana | 30011 | 207 | 5 |
1990472 | 1990472 | 2021-12-07 | Carter | Montana | 30011 | 207 | 5 |
1987222 | 1987222 | 2021-12-06 | Carter | Montana | 30011 | 207 | 5 |
1983972 | 1983972 | 2021-12-05 | Carter | Montana | 30011 | 207 | 5 |
1980722 | 1980722 | 2021-12-04 | Carter | Montana | 30011 | 207 | 5 |
1977472 | 1977472 | 2021-12-03 | Carter | Montana | 30011 | 207 | 5 |
1974222 | 1974222 | 2021-12-02 | Carter | Montana | 30011 | 207 | 5 |
1970973 | 1970973 | 2021-12-01 | Carter | Montana | 30011 | 207 | 5 |
1967723 | 1967723 | 2021-11-30 | Carter | Montana | 30011 | 207 | 5 |
1964471 | 1964471 | 2021-11-29 | Carter | Montana | 30011 | 207 | 5 |
1961220 | 1961220 | 2021-11-28 | Carter | Montana | 30011 | 207 | 5 |
1957969 | 1957969 | 2021-11-27 | Carter | Montana | 30011 | 207 | 5 |
1954718 | 1954718 | 2021-11-26 | Carter | Montana | 30011 | 207 | 5 |
1942141 | 1942141 | 2021-11-22 | Sheridan | North Dakota | 38083 | 207 | 4 |
1938891 | 1938891 | 2021-11-21 | Sheridan | North Dakota | 38083 | 207 | 4 |
1923090 | 1923090 | 2021-11-16 | Hyde | South Dakota | 46069 | 207 | 5 |
1880386 | 1880386 | 2021-11-03 | Oliver | North Dakota | 38065 | 207 | 3 |
1876794 | 1876794 | 2021-11-02 | Deuel | Nebraska | 31049 | 207 | 2 |
1873545 | 1873545 | 2021-11-01 | Deuel | Nebraska | 31049 | 207 | 2 |
1850923 | 1850923 | 2021-10-25 | Catron | New Mexico | 35003 | 207 | 7 |
1834630 | 1834630 | 2021-10-20 | Eureka | Nevada | 32011 | 207 | 1 |
1825858 | 1825858 | 2021-10-17 | Jeff Davis | Texas | 48243 | 207 | 6 |
1822609 | 1822609 | 2021-10-16 | Jeff Davis | Texas | 48243 | 207 | 6 |
1816260 | 1816260 | 2021-10-14 | Rich | Utah | 49033 | 207 | 0 |
1783522 | 1783522 | 2021-10-04 | Briscoe | Texas | 48045 | 207 | 7 |
1780273 | 1780273 | 2021-10-03 | Briscoe | Texas | 48045 | 207 | 7 |
1780697 | 1780697 | 2021-10-03 | Garfield | Washington | 53023 | 207 | 7 |
1777023 | 1777023 | 2021-10-02 | Briscoe | Texas | 48045 | 207 | 7 |
1777447 | 1777447 | 2021-10-02 | Garfield | Washington | 53023 | 207 | 7 |
1773773 | 1773773 | 2021-10-01 | Briscoe | Texas | 48045 | 207 | 7 |
1774197 | 1774197 | 2021-10-01 | Garfield | Washington | 53023 | 207 | 7 |
1770523 | 1770523 | 2021-09-30 | Briscoe | Texas | 48045 | 207 | 7 |
1770947 | 1770947 | 2021-09-30 | Garfield | Washington | 53023 | 207 | 7 |
1767274 | 1767274 | 2021-09-29 | Briscoe | Texas | 48045 | 207 | 7 |
1762663 | 1762663 | 2021-09-28 | Keweenaw | Michigan | 26083 | 207 | 4 |
1759414 | 1759414 | 2021-09-27 | Keweenaw | Michigan | 26083 | 207 | 4 |
1756166 | 1756166 | 2021-09-26 | Keweenaw | Michigan | 26083 | 207 | 4 |
1752918 | 1752918 | 2021-09-25 | Keweenaw | Michigan | 26083 | 207 | 4 |
1749670 | 1749670 | 2021-09-24 | Keweenaw | Michigan | 26083 | 207 | 4 |
1748043 | 1748043 | 2021-09-23 | Wayne | Utah | 49055 | 207 | 0 |
1744793 | 1744793 | 2021-09-22 | Wayne | Utah | 49055 | 207 | 0 |
1735460 | 1735460 | 2021-09-20 | Denali Borough | Alaska | 2068 | 207 | 0 |
1733816 | 1733816 | 2021-09-19 | Boyd | Nebraska | 31015 | 207 | 3 |
1730566 | 1730566 | 2021-09-18 | Boyd | Nebraska | 31015 | 207 | 3 |
1727316 | 1727316 | 2021-09-17 | Boyd | Nebraska | 31015 | 207 | 3 |
1724067 | 1724067 | 2021-09-16 | Boyd | Nebraska | 31015 | 207 | 3 |
1720818 | 1720818 | 2021-09-15 | Boyd | Nebraska | 31015 | 207 | 3 |
1721191 | 1721191 | 2021-09-15 | Steele | North Dakota | 38091 | 207 | 2 |
1716888 | 1716888 | 2021-09-14 | Wallace | Kansas | 20199 | 207 | 4 |
1717570 | 1717570 | 2021-09-14 | Boyd | Nebraska | 31015 | 207 | 3 |
1712732 | 1712732 | 2021-09-13 | Petersburg Borough | Alaska | 2195 | 207 | 1 |
1713642 | 1713642 | 2021-09-13 | Wallace | Kansas | 20199 | 207 | 4 |
1713987 | 1713987 | 2021-09-13 | Cook | Minnesota | 27031 | 207 | 0 |
1714322 | 1714322 | 2021-09-13 | Boyd | Nebraska | 31015 | 207 | 3 |
1709485 | 1709485 | 2021-09-12 | Petersburg Borough | Alaska | 2195 | 207 | 1 |
1711076 | 1711076 | 2021-09-12 | Boyd | Nebraska | 31015 | 207 | 3 |
1706238 | 1706238 | 2021-09-11 | Petersburg Borough | Alaska | 2195 | 207 | 1 |
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);