ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,506 rows where cases = 55 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Nebraska 218
- Texas 217
- Montana 211
- Georgia 96
- Missouri 95
- Virginia 93
- Minnesota 88
- Kentucky 84
- North Dakota 74
- Colorado 66
- Illinois 64
- Nevada 63
- Kansas 61
- Michigan 59
- Ohio 58
- New Mexico 56
- Iowa 54
- Oklahoma 53
- Oregon 52
- Puerto Rico 51
- North Carolina 50
- Tennessee 48
- West Virginia 47
- Indiana 45
- Arkansas 44
- Mississippi 41
- Pennsylvania 38
- Maine 37
- California 34
- South Dakota 33
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2097800 | 2097800 | 2022-01-09 | Blaine | Nebraska | 31009 | 55 | 2 |
2094548 | 2094548 | 2022-01-08 | Blaine | Nebraska | 31009 | 55 | 2 |
2091296 | 2091296 | 2022-01-07 | Blaine | Nebraska | 31009 | 55 | 2 |
2088045 | 2088045 | 2022-01-06 | Blaine | Nebraska | 31009 | 55 | 2 |
2088419 | 2088419 | 2022-01-06 | Slope | North Dakota | 38087 | 55 | 0 |
2085167 | 2085167 | 2022-01-05 | Slope | North Dakota | 38087 | 55 | 0 |
2081915 | 2081915 | 2022-01-04 | Slope | North Dakota | 38087 | 55 | 0 |
2078663 | 2078663 | 2022-01-03 | Slope | North Dakota | 38087 | 55 | 0 |
2075412 | 2075412 | 2022-01-02 | Slope | North Dakota | 38087 | 55 | 0 |
2072161 | 2072161 | 2022-01-01 | Slope | North Dakota | 38087 | 55 | 0 |
2068910 | 2068910 | 2021-12-31 | Slope | North Dakota | 38087 | 55 | 0 |
2065659 | 2065659 | 2021-12-30 | Slope | North Dakota | 38087 | 55 | 0 |
2062409 | 2062409 | 2021-12-29 | Slope | North Dakota | 38087 | 55 | 0 |
2059160 | 2059160 | 2021-12-28 | Slope | North Dakota | 38087 | 55 | 0 |
2055911 | 2055911 | 2021-12-27 | Slope | North Dakota | 38087 | 55 | 0 |
2052661 | 2052661 | 2021-12-26 | Slope | North Dakota | 38087 | 55 | 0 |
2049411 | 2049411 | 2021-12-25 | Slope | North Dakota | 38087 | 55 | 0 |
2046161 | 2046161 | 2021-12-24 | Slope | North Dakota | 38087 | 55 | 0 |
2042911 | 2042911 | 2021-12-23 | Slope | North Dakota | 38087 | 55 | 0 |
2039439 | 2039439 | 2021-12-22 | Harding | New Mexico | 35021 | 55 | 4 |
2039662 | 2039662 | 2021-12-22 | Slope | North Dakota | 38087 | 55 | 0 |
2036189 | 2036189 | 2021-12-21 | Harding | New Mexico | 35021 | 55 | 4 |
2036412 | 2036412 | 2021-12-21 | Slope | North Dakota | 38087 | 55 | 0 |
2032939 | 2032939 | 2021-12-20 | Harding | New Mexico | 35021 | 55 | 4 |
2033162 | 2033162 | 2021-12-20 | Slope | North Dakota | 38087 | 55 | 0 |
2029688 | 2029688 | 2021-12-19 | Harding | New Mexico | 35021 | 55 | 4 |
2029912 | 2029912 | 2021-12-19 | Slope | North Dakota | 38087 | 55 | 0 |
2026437 | 2026437 | 2021-12-18 | Harding | New Mexico | 35021 | 55 | 4 |
2026661 | 2026661 | 2021-12-18 | Slope | North Dakota | 38087 | 55 | 0 |
2023186 | 2023186 | 2021-12-17 | Harding | New Mexico | 35021 | 55 | 4 |
2023410 | 2023410 | 2021-12-17 | Slope | North Dakota | 38087 | 55 | 0 |
2019935 | 2019935 | 2021-12-16 | Harding | New Mexico | 35021 | 55 | 4 |
2020159 | 2020159 | 2021-12-16 | Slope | North Dakota | 38087 | 55 | 0 |
2016685 | 2016685 | 2021-12-15 | Harding | New Mexico | 35021 | 55 | 4 |
2016908 | 2016908 | 2021-12-15 | Slope | North Dakota | 38087 | 55 | 0 |
2013434 | 2013434 | 2021-12-14 | Harding | New Mexico | 35021 | 55 | 4 |
2013658 | 2013658 | 2021-12-14 | Slope | North Dakota | 38087 | 55 | 0 |
1990902 | 1990902 | 2021-12-07 | Slope | North Dakota | 38087 | 55 | 0 |
1987651 | 1987651 | 2021-12-06 | Slope | North Dakota | 38087 | 55 | 0 |
1984401 | 1984401 | 2021-12-05 | Slope | North Dakota | 38087 | 55 | 0 |
1981151 | 1981151 | 2021-12-04 | Slope | North Dakota | 38087 | 55 | 0 |
1977901 | 1977901 | 2021-12-03 | Slope | North Dakota | 38087 | 55 | 0 |
1974651 | 1974651 | 2021-12-02 | Slope | North Dakota | 38087 | 55 | 0 |
1971402 | 1971402 | 2021-12-01 | Slope | North Dakota | 38087 | 55 | 0 |
1968152 | 1968152 | 2021-11-30 | Slope | North Dakota | 38087 | 55 | 0 |
1964901 | 1964901 | 2021-11-29 | Slope | North Dakota | 38087 | 55 | 0 |
1961649 | 1961649 | 2021-11-28 | Slope | North Dakota | 38087 | 55 | 0 |
1958398 | 1958398 | 2021-11-27 | Slope | North Dakota | 38087 | 55 | 0 |
1955147 | 1955147 | 2021-11-26 | Slope | North Dakota | 38087 | 55 | 0 |
1951896 | 1951896 | 2021-11-25 | Slope | North Dakota | 38087 | 55 | 0 |
1948645 | 1948645 | 2021-11-24 | Slope | North Dakota | 38087 | 55 | 0 |
1942143 | 1942143 | 2021-11-22 | Slope | North Dakota | 38087 | 55 | 0 |
1867105 | 1867105 | 2021-10-30 | Sioux | Nebraska | 31165 | 55 | 1 |
1863856 | 1863856 | 2021-10-29 | Sioux | Nebraska | 31165 | 55 | 1 |
1860607 | 1860607 | 2021-10-28 | Sioux | Nebraska | 31165 | 55 | 1 |
1857358 | 1857358 | 2021-10-27 | Sioux | Nebraska | 31165 | 55 | 1 |
1854109 | 1854109 | 2021-10-26 | Sioux | Nebraska | 31165 | 55 | 1 |
1850860 | 1850860 | 2021-10-25 | Sioux | Nebraska | 31165 | 55 | 1 |
1847610 | 1847610 | 2021-10-24 | Sioux | Nebraska | 31165 | 55 | 1 |
1844360 | 1844360 | 2021-10-23 | Sioux | Nebraska | 31165 | 55 | 1 |
1841110 | 1841110 | 2021-10-22 | Sioux | Nebraska | 31165 | 55 | 1 |
1836380 | 1836380 | 2021-10-21 | Hinsdale | Colorado | 8053 | 55 | 0 |
1837861 | 1837861 | 2021-10-21 | Sioux | Nebraska | 31165 | 55 | 1 |
1833131 | 1833131 | 2021-10-20 | Hinsdale | Colorado | 8053 | 55 | 0 |
1829882 | 1829882 | 2021-10-19 | Hinsdale | Colorado | 8053 | 55 | 0 |
1826633 | 1826633 | 2021-10-18 | Hinsdale | Colorado | 8053 | 55 | 0 |
1763086 | 1763086 | 2021-09-28 | Grant | Nebraska | 31075 | 55 | 4 |
1763734 | 1763734 | 2021-09-28 | Culebra | Puerto Rico | 72049 | 55 | |
1760485 | 1760485 | 2021-09-27 | Culebra | Puerto Rico | 72049 | 55 | |
1756644 | 1756644 | 2021-09-26 | Wheeler | Nebraska | 31183 | 55 | 0 |
1757237 | 1757237 | 2021-09-26 | Culebra | Puerto Rico | 72049 | 55 | |
1753396 | 1753396 | 2021-09-25 | Wheeler | Nebraska | 31183 | 55 | 0 |
1753989 | 1753989 | 2021-09-25 | Culebra | Puerto Rico | 72049 | 55 | |
1750148 | 1750148 | 2021-09-24 | Wheeler | Nebraska | 31183 | 55 | 0 |
1750741 | 1750741 | 2021-09-24 | Culebra | Puerto Rico | 72049 | 55 | |
1733894 | 1733894 | 2021-09-19 | Thomas | Nebraska | 31171 | 55 | 1 |
1730644 | 1730644 | 2021-09-18 | Thomas | Nebraska | 31171 | 55 | 1 |
1727394 | 1727394 | 2021-09-17 | Thomas | Nebraska | 31171 | 55 | 1 |
1724145 | 1724145 | 2021-09-16 | Thomas | Nebraska | 31171 | 55 | 1 |
1720896 | 1720896 | 2021-09-15 | Thomas | Nebraska | 31171 | 55 | 1 |
1717648 | 1717648 | 2021-09-14 | Thomas | Nebraska | 31171 | 55 | 1 |
1712735 | 1712735 | 2021-09-13 | Skagway Municipality | Alaska | 2230 | 55 | 0 |
1714400 | 1714400 | 2021-09-13 | Thomas | Nebraska | 31171 | 55 | 1 |
1711154 | 1711154 | 2021-09-12 | Thomas | Nebraska | 31171 | 55 | 1 |
1707907 | 1707907 | 2021-09-11 | Thomas | Nebraska | 31171 | 55 | 1 |
1704660 | 1704660 | 2021-09-10 | Thomas | Nebraska | 31171 | 55 | 1 |
1701410 | 1701410 | 2021-09-09 | Thomas | Nebraska | 31171 | 55 | 1 |
1698161 | 1698161 | 2021-09-08 | Thomas | Nebraska | 31171 | 55 | 1 |
1694913 | 1694913 | 2021-09-07 | Thomas | Nebraska | 31171 | 55 | 1 |
1691664 | 1691664 | 2021-09-06 | Thomas | Nebraska | 31171 | 55 | 1 |
1688414 | 1688414 | 2021-09-05 | Thomas | Nebraska | 31171 | 55 | 1 |
1685164 | 1685164 | 2021-09-04 | Thomas | Nebraska | 31171 | 55 | 1 |
1681913 | 1681913 | 2021-09-03 | Thomas | Nebraska | 31171 | 55 | 1 |
1678665 | 1678665 | 2021-09-02 | Thomas | Nebraska | 31171 | 55 | 1 |
1675417 | 1675417 | 2021-09-01 | Thomas | Nebraska | 31171 | 55 | 1 |
1672169 | 1672169 | 2021-08-31 | Thomas | Nebraska | 31171 | 55 | 1 |
1668922 | 1668922 | 2021-08-30 | Thomas | Nebraska | 31171 | 55 | 1 |
1665675 | 1665675 | 2021-08-29 | Thomas | Nebraska | 31171 | 55 | 1 |
1662427 | 1662427 | 2021-08-28 | Thomas | Nebraska | 31171 | 55 | 1 |
1659179 | 1659179 | 2021-08-27 | Thomas | Nebraska | 31171 | 55 | 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);