ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where cases = 311 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 99
- Virginia 47
- Georgia 41
- Kansas 35
- North Dakota 32
- Missouri 29
- Nebraska 29
- South Dakota 25
- Indiana 22
- Kentucky 22
- California 21
- Iowa 18
- Minnesota 18
- Puerto Rico 18
- Illinois 17
- North Carolina 17
- Washington 17
- Colorado 16
- Mississippi 15
- Arkansas 14
- Pennsylvania 14
- New York 13
- Idaho 12
- Michigan 12
- Montana 12
- Oregon 12
- Alabama 11
- Ohio 11
- Tennessee 11
- Louisiana 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2424098 | 2424098 | 2022-04-19 | Cottle | Texas | 48101 | 311 | 9 |
2270757 | 2270757 | 2022-03-03 | Sherman | Oregon | 41055 | 311 | 4 |
2267505 | 2267505 | 2022-03-02 | Sherman | Oregon | 41055 | 311 | 4 |
2264252 | 2264252 | 2022-03-01 | Sherman | Oregon | 41055 | 311 | 4 |
2261002 | 2261002 | 2022-02-28 | Sherman | Oregon | 41055 | 311 | 4 |
2257751 | 2257751 | 2022-02-27 | Sherman | Oregon | 41055 | 311 | 3 |
2254500 | 2254500 | 2022-02-26 | Sherman | Oregon | 41055 | 311 | 3 |
2251249 | 2251249 | 2022-02-25 | Sherman | Oregon | 41055 | 311 | 3 |
2244184 | 2244184 | 2022-02-23 | Deuel | Nebraska | 31049 | 311 | 2 |
2240933 | 2240933 | 2022-02-22 | Deuel | Nebraska | 31049 | 311 | 2 |
2237682 | 2237682 | 2022-02-21 | Deuel | Nebraska | 31049 | 311 | 2 |
2219964 | 2219964 | 2022-02-16 | Sierra | California | 6091 | 311 | 0 |
2216713 | 2216713 | 2022-02-15 | Sierra | California | 6091 | 311 | 0 |
2213462 | 2213462 | 2022-02-14 | Sierra | California | 6091 | 311 | 0 |
2213484 | 2213484 | 2022-02-14 | Cheyenne | Colorado | 8017 | 311 | 9 |
2200473 | 2200473 | 2022-02-10 | Cheyenne | Colorado | 8017 | 311 | 9 |
2197197 | 2197197 | 2022-02-09 | Sierra | California | 6091 | 311 | 0 |
2169728 | 2169728 | 2022-01-31 | Oliver | North Dakota | 38065 | 311 | 4 |
2148441 | 2148441 | 2022-01-25 | Kiowa | Colorado | 8061 | 311 | 4 |
2147811 | 2147811 | 2022-01-24 | Rich | Utah | 49033 | 311 | 0 |
2144557 | 2144557 | 2022-01-23 | Rich | Utah | 49033 | 311 | 0 |
2141302 | 2141302 | 2022-01-22 | Rich | Utah | 49033 | 311 | 0 |
2138046 | 2138046 | 2022-01-21 | Rich | Utah | 49033 | 311 | 0 |
2132157 | 2132157 | 2022-01-20 | Dolores | Colorado | 8033 | 311 | 7 |
2134792 | 2134792 | 2022-01-20 | Rich | Utah | 49033 | 311 | 0 |
2134969 | 2134969 | 2022-01-20 | Garfield | Washington | 53023 | 311 | 7 |
2096668 | 2096668 | 2022-01-09 | Webster | Georgia | 13307 | 311 | 7 |
2093416 | 2093416 | 2022-01-08 | Webster | Georgia | 13307 | 311 | 7 |
2090164 | 2090164 | 2022-01-07 | Webster | Georgia | 13307 | 311 | 7 |
2086913 | 2086913 | 2022-01-06 | Webster | Georgia | 13307 | 311 | 7 |
2083661 | 2083661 | 2022-01-05 | Webster | Georgia | 13307 | 311 | 7 |
2085498 | 2085498 | 2022-01-05 | Maricao | Puerto Rico | 72093 | 311 | |
2035976 | 2035976 | 2021-12-21 | Worth | Missouri | 29227 | 311 | 2 |
2037199 | 2037199 | 2021-12-21 | Sherman | Texas | 48421 | 311 | 16 |
2033949 | 2033949 | 2021-12-20 | Sherman | Texas | 48421 | 311 | 16 |
2034208 | 2034208 | 2021-12-20 | Wahkiakum | Washington | 53069 | 311 | 5 |
2029486 | 2029486 | 2021-12-19 | Daniels | Montana | 30019 | 311 | 9 |
2030699 | 2030699 | 2021-12-19 | Sherman | Texas | 48421 | 311 | 16 |
2030958 | 2030958 | 2021-12-19 | Wahkiakum | Washington | 53069 | 311 | 5 |
2026224 | 2026224 | 2021-12-18 | Worth | Missouri | 29227 | 311 | 2 |
2026235 | 2026235 | 2021-12-18 | Daniels | Montana | 30019 | 311 | 9 |
2027448 | 2027448 | 2021-12-18 | Sherman | Texas | 48421 | 311 | 16 |
2027707 | 2027707 | 2021-12-18 | Wahkiakum | Washington | 53069 | 311 | 5 |
2022984 | 2022984 | 2021-12-17 | Daniels | Montana | 30019 | 311 | 9 |
2024197 | 2024197 | 2021-12-17 | Sherman | Texas | 48421 | 311 | 16 |
2024456 | 2024456 | 2021-12-17 | Wahkiakum | Washington | 53069 | 311 | 5 |
2019733 | 2019733 | 2021-12-16 | Daniels | Montana | 30019 | 311 | 9 |
2020946 | 2020946 | 2021-12-16 | Sherman | Texas | 48421 | 311 | 16 |
2021205 | 2021205 | 2021-12-16 | Wahkiakum | Washington | 53069 | 311 | 5 |
2017695 | 2017695 | 2021-12-15 | Sherman | Texas | 48421 | 311 | 16 |
2017954 | 2017954 | 2021-12-15 | Wahkiakum | Washington | 53069 | 311 | 5 |
2014704 | 2014704 | 2021-12-14 | Wahkiakum | Washington | 53069 | 311 | 5 |
2011453 | 2011453 | 2021-12-13 | Wahkiakum | Washington | 53069 | 311 | 5 |
2006749 | 2006749 | 2021-12-12 | McCone | Montana | 30055 | 311 | 8 |
2003498 | 2003498 | 2021-12-11 | McCone | Montana | 30055 | 311 | 8 |
2000248 | 2000248 | 2021-12-10 | McCone | Montana | 30055 | 311 | 8 |
1993812 | 1993812 | 2021-12-08 | Greeley | Nebraska | 31077 | 311 | 2 |
1990589 | 1990589 | 2021-12-07 | Pawnee | Nebraska | 31133 | 311 | 4 |
1981733 | 1981733 | 2021-12-04 | Armstrong | Texas | 48011 | 311 | 7 |
1978483 | 1978483 | 2021-12-03 | Armstrong | Texas | 48011 | 311 | 7 |
1968602 | 1968602 | 2021-11-30 | Jerauld | South Dakota | 46073 | 311 | 17 |
1960590 | 1960590 | 2021-11-28 | Stanton | Kansas | 20187 | 311 | 7 |
1957339 | 1957339 | 2021-11-27 | Stanton | Kansas | 20187 | 311 | 7 |
1954088 | 1954088 | 2021-11-26 | Stanton | Kansas | 20187 | 311 | 7 |
1950837 | 1950837 | 2021-11-25 | Stanton | Kansas | 20187 | 311 | 7 |
1947586 | 1947586 | 2021-11-24 | Stanton | Kansas | 20187 | 311 | 7 |
1898767 | 1898767 | 2021-11-09 | Elk | Kansas | 20049 | 311 | 6 |
1895517 | 1895517 | 2021-11-08 | Elk | Kansas | 20049 | 311 | 6 |
1836411 | 1836411 | 2021-10-21 | Sedgwick | Colorado | 8115 | 311 | 4 |
1833162 | 1833162 | 2021-10-20 | Sedgwick | Colorado | 8115 | 311 | 4 |
1809377 | 1809377 | 2021-10-12 | Mellette | South Dakota | 46095 | 311 | 2 |
1786146 | 1786146 | 2021-10-05 | Golden Valley | North Dakota | 38033 | 311 | 4 |
1778727 | 1778727 | 2021-10-03 | Robertson | Kentucky | 21201 | 311 | 15 |
1775477 | 1775477 | 2021-10-02 | Robertson | Kentucky | 21201 | 311 | 15 |
1772227 | 1772227 | 2021-10-01 | Robertson | Kentucky | 21201 | 311 | 15 |
1774041 | 1774041 | 2021-10-01 | Grand Isle | Vermont | 50013 | 311 | 2 |
1770365 | 1770365 | 2021-09-30 | Haakon | South Dakota | 46055 | 311 | 11 |
1764948 | 1764948 | 2021-09-29 | Unknown | Delaware | 311 | 0 | |
1763092 | 1763092 | 2021-09-28 | Hitchcock | Nebraska | 31087 | 311 | 5 |
1759843 | 1759843 | 2021-09-27 | Hitchcock | Nebraska | 31087 | 311 | 5 |
1760822 | 1760822 | 2021-09-27 | Edwards | Texas | 48137 | 311 | 7 |
1739057 | 1739057 | 2021-09-21 | Clay | Georgia | 13061 | 311 | 4 |
1733043 | 1733043 | 2021-09-19 | Chase | Kansas | 20017 | 311 | 3 |
1729793 | 1729793 | 2021-09-18 | Chase | Kansas | 20017 | 311 | 3 |
1726543 | 1726543 | 2021-09-17 | Chase | Kansas | 20017 | 311 | 3 |
1727665 | 1727665 | 2021-09-17 | Kidder | North Dakota | 38043 | 311 | 10 |
1723294 | 1723294 | 2021-09-16 | Chase | Kansas | 20017 | 311 | 3 |
1723305 | 1723305 | 2021-09-16 | Decatur | Kansas | 20039 | 311 | 12 |
1725177 | 1725177 | 2021-09-16 | Menard | Texas | 48327 | 311 | 10 |
1720045 | 1720045 | 2021-09-15 | Chase | Kansas | 20017 | 311 | 3 |
1720056 | 1720056 | 2021-09-15 | Decatur | Kansas | 20039 | 311 | 12 |
1721928 | 1721928 | 2021-09-15 | Menard | Texas | 48327 | 311 | 10 |
1654262 | 1654262 | 2021-08-26 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 311 | 5 |
1653437 | 1653437 | 2021-08-25 | Miner | South Dakota | 46097 | 311 | 10 |
1648074 | 1648074 | 2021-08-24 | Baker | Georgia | 13007 | 311 | 11 |
1650190 | 1650190 | 2021-08-24 | Miner | South Dakota | 46097 | 311 | 10 |
1650316 | 1650316 | 2021-08-24 | Baylor | Texas | 48023 | 311 | 13 |
1646023 | 1646023 | 2021-08-23 | Scotland | Missouri | 29199 | 311 | 4 |
1647067 | 1647067 | 2021-08-23 | Baylor | Texas | 48023 | 311 | 13 |
1642774 | 1642774 | 2021-08-22 | Scotland | Missouri | 29199 | 311 | 4 |
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);