ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,381 rows where cases = 43 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 157
- Georgia 116
- Virginia 110
- Kentucky 104
- Puerto Rico 93
- Colorado 89
- Kansas 89
- Nebraska 89
- Missouri 85
- Iowa 83
- Michigan 82
- North Carolina 76
- Oklahoma 74
- Ohio 69
- Minnesota 65
- North Dakota 63
- Wisconsin 60
- Indiana 59
- Illinois 57
- Tennessee 57
- West Virginia 54
- Arkansas 49
- Montana 42
- Alabama 40
- Mississippi 39
- Pennsylvania 37
- Alaska 36
- South Dakota 35
- Idaho 34
- California 31
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2091683 | 2091683 | 2022-01-07 | Unknown | Northern Mariana Islands | 43 | 1 | |
2039668 | 2039668 | 2021-12-22 | Unknown | North Dakota | 43 | 43 | |
2036418 | 2036418 | 2021-12-21 | Unknown | North Dakota | 43 | 43 | |
2033168 | 2033168 | 2021-12-20 | Unknown | North Dakota | 43 | 43 | |
2029918 | 2029918 | 2021-12-19 | Unknown | North Dakota | 43 | 43 | |
2026667 | 2026667 | 2021-12-18 | Unknown | North Dakota | 43 | 43 | |
2023416 | 2023416 | 2021-12-17 | Unknown | North Dakota | 43 | 43 | |
2020165 | 2020165 | 2021-12-16 | Unknown | North Dakota | 43 | 43 | |
2016914 | 2016914 | 2021-12-15 | Unknown | North Dakota | 43 | 43 | |
2013664 | 2013664 | 2021-12-14 | Unknown | North Dakota | 43 | 43 | |
1997997 | 1997997 | 2021-12-09 | Borden | Texas | 48033 | 43 | 2 |
1994746 | 1994746 | 2021-12-08 | Borden | Texas | 48033 | 43 | 2 |
1991495 | 1991495 | 2021-12-07 | Borden | Texas | 48033 | 43 | 2 |
1988244 | 1988244 | 2021-12-06 | Borden | Texas | 48033 | 43 | 2 |
1984994 | 1984994 | 2021-12-05 | Borden | Texas | 48033 | 43 | 2 |
1981744 | 1981744 | 2021-12-04 | Borden | Texas | 48033 | 43 | 2 |
1978494 | 1978494 | 2021-12-03 | Borden | Texas | 48033 | 43 | 2 |
1975244 | 1975244 | 2021-12-02 | Borden | Texas | 48033 | 43 | 2 |
1971995 | 1971995 | 2021-12-01 | Borden | Texas | 48033 | 43 | 2 |
1968745 | 1968745 | 2021-11-30 | Borden | Texas | 48033 | 43 | 2 |
1965494 | 1965494 | 2021-11-29 | Borden | Texas | 48033 | 43 | 2 |
1962242 | 1962242 | 2021-11-28 | Borden | Texas | 48033 | 43 | 2 |
1958991 | 1958991 | 2021-11-27 | Borden | Texas | 48033 | 43 | 2 |
1955740 | 1955740 | 2021-11-26 | Borden | Texas | 48033 | 43 | 2 |
1952489 | 1952489 | 2021-11-25 | Borden | Texas | 48033 | 43 | 2 |
1949238 | 1949238 | 2021-11-24 | Borden | Texas | 48033 | 43 | 2 |
1945987 | 1945987 | 2021-11-23 | Borden | Texas | 48033 | 43 | 2 |
1942736 | 1942736 | 2021-11-22 | Borden | Texas | 48033 | 43 | 2 |
1939486 | 1939486 | 2021-11-21 | Borden | Texas | 48033 | 43 | 2 |
1935656 | 1935656 | 2021-11-20 | Unknown | Northern Mariana Islands | 43 | 0 | |
1936236 | 1936236 | 2021-11-20 | Borden | Texas | 48033 | 43 | 2 |
1932406 | 1932406 | 2021-11-19 | Unknown | Northern Mariana Islands | 43 | 0 | |
1932986 | 1932986 | 2021-11-19 | Borden | Texas | 48033 | 43 | 2 |
1929735 | 1929735 | 2021-11-18 | Borden | Texas | 48033 | 43 | 2 |
1925518 | 1925518 | 2021-11-17 | Blaine | Nebraska | 31009 | 43 | 1 |
1926485 | 1926485 | 2021-11-17 | Borden | Texas | 48033 | 43 | 2 |
1922269 | 1922269 | 2021-11-16 | Blaine | Nebraska | 31009 | 43 | 1 |
1923235 | 1923235 | 2021-11-16 | Borden | Texas | 48033 | 43 | 2 |
1919019 | 1919019 | 2021-11-15 | Blaine | Nebraska | 31009 | 43 | 1 |
1919986 | 1919986 | 2021-11-15 | Borden | Texas | 48033 | 43 | 2 |
1916736 | 1916736 | 2021-11-14 | Borden | Texas | 48033 | 43 | 2 |
1913486 | 1913486 | 2021-11-13 | Borden | Texas | 48033 | 43 | 2 |
1910236 | 1910236 | 2021-11-12 | Borden | Texas | 48033 | 43 | 2 |
1906987 | 1906987 | 2021-11-11 | Borden | Texas | 48033 | 43 | 2 |
1903738 | 1903738 | 2021-11-10 | Borden | Texas | 48033 | 43 | 2 |
1900488 | 1900488 | 2021-11-09 | Borden | Texas | 48033 | 43 | 2 |
1897238 | 1897238 | 2021-11-08 | Borden | Texas | 48033 | 43 | 2 |
1893988 | 1893988 | 2021-11-07 | Borden | Texas | 48033 | 43 | 2 |
1890738 | 1890738 | 2021-11-06 | Borden | Texas | 48033 | 43 | 2 |
1871521 | 1871521 | 2021-10-31 | Unknown | Vermont | 43 | 0 | |
1857431 | 1857431 | 2021-10-27 | Harding | New Mexico | 35021 | 43 | 3 |
1854182 | 1854182 | 2021-10-26 | Harding | New Mexico | 35021 | 43 | 3 |
1850933 | 1850933 | 2021-10-25 | Harding | New Mexico | 35021 | 43 | 3 |
1847683 | 1847683 | 2021-10-24 | Harding | New Mexico | 35021 | 43 | 3 |
1844433 | 1844433 | 2021-10-23 | Harding | New Mexico | 35021 | 43 | 3 |
1841183 | 1841183 | 2021-10-22 | Harding | New Mexico | 35021 | 43 | 3 |
1837934 | 1837934 | 2021-10-21 | Harding | New Mexico | 35021 | 43 | 3 |
1834685 | 1834685 | 2021-10-20 | Harding | New Mexico | 35021 | 43 | 2 |
1831436 | 1831436 | 2021-10-19 | Harding | New Mexico | 35021 | 43 | 2 |
1828187 | 1828187 | 2021-10-18 | Harding | New Mexico | 35021 | 43 | 2 |
1759803 | 1759803 | 2021-09-27 | Banner | Nebraska | 31007 | 43 | 0 |
1756555 | 1756555 | 2021-09-26 | Banner | Nebraska | 31007 | 43 | 0 |
1753307 | 1753307 | 2021-09-25 | Banner | Nebraska | 31007 | 43 | 0 |
1750059 | 1750059 | 2021-09-24 | Banner | Nebraska | 31007 | 43 | 0 |
1701424 | 1701424 | 2021-09-09 | Esmeralda | Nevada | 32009 | 43 | 0 |
1698175 | 1698175 | 2021-09-08 | Esmeralda | Nevada | 32009 | 43 | 0 |
1694927 | 1694927 | 2021-09-07 | Esmeralda | Nevada | 32009 | 43 | 0 |
1647952 | 1647952 | 2021-08-24 | Hinsdale | Colorado | 8053 | 43 | 0 |
1649741 | 1649741 | 2021-08-24 | Unknown | Northern Mariana Islands | 43 | 0 | |
1646492 | 1646492 | 2021-08-23 | Unknown | Northern Mariana Islands | 43 | 0 | |
1628275 | 1628275 | 2021-08-18 | Skagway Municipality | Alaska | 2230 | 43 | 0 |
1595211 | 1595211 | 2021-08-07 | Kenedy | Texas | 48261 | 43 | 2 |
1383783 | 1383783 | 2021-06-03 | Culebra | Puerto Rico | 72049 | 43 | |
1380537 | 1380537 | 2021-06-02 | Culebra | Puerto Rico | 72049 | 43 | |
1377292 | 1377292 | 2021-06-01 | Culebra | Puerto Rico | 72049 | 43 | |
1374046 | 1374046 | 2021-05-31 | Culebra | Puerto Rico | 72049 | 43 | |
1370801 | 1370801 | 2021-05-30 | Culebra | Puerto Rico | 72049 | 43 | |
1367555 | 1367555 | 2021-05-29 | Culebra | Puerto Rico | 72049 | 43 | |
1364309 | 1364309 | 2021-05-28 | Culebra | Puerto Rico | 72049 | 43 | |
1361063 | 1361063 | 2021-05-27 | Culebra | Puerto Rico | 72049 | 43 | |
1357817 | 1357817 | 2021-05-26 | Culebra | Puerto Rico | 72049 | 43 | |
1354571 | 1354571 | 2021-05-25 | Culebra | Puerto Rico | 72049 | 43 | |
1351325 | 1351325 | 2021-05-24 | Culebra | Puerto Rico | 72049 | 43 | |
1348079 | 1348079 | 2021-05-23 | Culebra | Puerto Rico | 72049 | 43 | |
1344831 | 1344831 | 2021-05-22 | Culebra | Puerto Rico | 72049 | 43 | |
1341583 | 1341583 | 2021-05-21 | Culebra | Puerto Rico | 72049 | 43 | |
1338335 | 1338335 | 2021-05-20 | Culebra | Puerto Rico | 72049 | 43 | |
1335088 | 1335088 | 2021-05-19 | Culebra | Puerto Rico | 72049 | 43 | |
1331841 | 1331841 | 2021-05-18 | Culebra | Puerto Rico | 72049 | 43 | |
1328594 | 1328594 | 2021-05-17 | Culebra | Puerto Rico | 72049 | 43 | |
1329121 | 1329121 | 2021-05-17 | Daggett | Utah | 49009 | 43 | 0 |
1325348 | 1325348 | 2021-05-16 | Culebra | Puerto Rico | 72049 | 43 | |
1325875 | 1325875 | 2021-05-16 | Daggett | Utah | 49009 | 43 | 0 |
1322102 | 1322102 | 2021-05-15 | Culebra | Puerto Rico | 72049 | 43 | |
1322629 | 1322629 | 2021-05-15 | Daggett | Utah | 49009 | 43 | 0 |
1318856 | 1318856 | 2021-05-14 | Culebra | Puerto Rico | 72049 | 43 | |
1315608 | 1315608 | 2021-05-13 | Culebra | Puerto Rico | 72049 | 43 | |
1312362 | 1312362 | 2021-05-12 | Culebra | Puerto Rico | 72049 | 43 | |
1309115 | 1309115 | 2021-05-11 | Culebra | Puerto Rico | 72049 | 43 | |
1305869 | 1305869 | 2021-05-10 | Culebra | Puerto Rico | 72049 | 43 |
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);