ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,942 rows where cases = 66 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
- Texas 158
- Virginia 119
- Nebraska 99
- Oklahoma 83
- Georgia 74
- Illinois 69
- Iowa 69
- Kansas 67
- Kentucky 64
- Michigan 63
- Puerto Rico 58
- Indiana 54
- Minnesota 49
- Pennsylvania 46
- Missouri 45
- Montana 45
- Colorado 44
- South Dakota 41
- Alaska 40
- Mississippi 39
- Wisconsin 39
- West Virginia 37
- Idaho 36
- Ohio 35
- Arkansas 31
- Louisiana 30
- New York 30
- Oregon 30
- Tennessee 30
- North Carolina 29
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2419915 | 2419915 | 2022-04-18 | Sioux | Nebraska | 31165 | 66 | 1 |
2416660 | 2416660 | 2022-04-17 | Sioux | Nebraska | 31165 | 66 | 1 |
2413404 | 2413404 | 2022-04-16 | Sioux | Nebraska | 31165 | 66 | 1 |
2410148 | 2410148 | 2022-04-15 | Sioux | Nebraska | 31165 | 66 | 1 |
2406892 | 2406892 | 2022-04-14 | Sioux | Nebraska | 31165 | 66 | 1 |
2403636 | 2403636 | 2022-04-13 | Sioux | Nebraska | 31165 | 66 | 1 |
2348317 | 2348317 | 2022-03-27 | Sioux | Nebraska | 31165 | 66 | 1 |
2345064 | 2345064 | 2022-03-26 | Sioux | Nebraska | 31165 | 66 | 1 |
2341811 | 2341811 | 2022-03-25 | Sioux | Nebraska | 31165 | 66 | 1 |
2335304 | 2335304 | 2022-03-23 | Sioux | Nebraska | 31165 | 66 | 1 |
2319037 | 2319037 | 2022-03-18 | Sioux | Nebraska | 31165 | 66 | 1 |
2315784 | 2315784 | 2022-03-17 | Sioux | Nebraska | 31165 | 66 | 1 |
2312531 | 2312531 | 2022-03-16 | Sioux | Nebraska | 31165 | 66 | 1 |
2309278 | 2309278 | 2022-03-15 | Sioux | Nebraska | 31165 | 66 | 1 |
2302775 | 2302775 | 2022-03-13 | Sioux | Nebraska | 31165 | 66 | 1 |
2299523 | 2299523 | 2022-03-12 | Sioux | Nebraska | 31165 | 66 | 1 |
2296271 | 2296271 | 2022-03-11 | Sioux | Nebraska | 31165 | 66 | 1 |
2289767 | 2289767 | 2022-03-09 | Sioux | Nebraska | 31165 | 66 | 1 |
2286515 | 2286515 | 2022-03-08 | Sioux | Nebraska | 31165 | 66 | 1 |
2266999 | 2266999 | 2022-03-02 | Sioux | Nebraska | 31165 | 66 | 1 |
2263748 | 2263748 | 2022-03-01 | Sioux | Nebraska | 31165 | 66 | 1 |
2260497 | 2260497 | 2022-02-28 | Sioux | Nebraska | 31165 | 66 | 1 |
2257553 | 2257553 | 2022-02-27 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2254302 | 2254302 | 2022-02-26 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2251051 | 2251051 | 2022-02-25 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2247800 | 2247800 | 2022-02-24 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2244549 | 2244549 | 2022-02-23 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2241298 | 2241298 | 2022-02-22 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2238047 | 2238047 | 2022-02-21 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2234796 | 2234796 | 2022-02-20 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2231545 | 2231545 | 2022-02-19 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2228294 | 2228294 | 2022-02-18 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2225043 | 2225043 | 2022-02-17 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2221792 | 2221792 | 2022-02-16 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2218541 | 2218541 | 2022-02-15 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2215290 | 2215290 | 2022-02-14 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2212039 | 2212039 | 2022-02-13 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2208786 | 2208786 | 2022-02-12 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2205533 | 2205533 | 2022-02-11 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2202280 | 2202280 | 2022-02-10 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2199026 | 2199026 | 2022-02-09 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2195772 | 2195772 | 2022-02-08 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2192518 | 2192518 | 2022-02-07 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2189264 | 2189264 | 2022-02-06 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2186011 | 2186011 | 2022-02-05 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2182759 | 2182759 | 2022-02-04 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2179177 | 2179177 | 2022-02-03 | McPherson | Nebraska | 31117 | 66 | 1 |
2179507 | 2179507 | 2022-02-03 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2175925 | 2175925 | 2022-02-02 | McPherson | Nebraska | 31117 | 66 | 1 |
2176256 | 2176256 | 2022-02-02 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2172672 | 2172672 | 2022-02-01 | McPherson | Nebraska | 31117 | 66 | 1 |
2173003 | 2173003 | 2022-02-01 | Rota | Northern Mariana Islands | 69100 | 66 | 0 |
2169419 | 2169419 | 2022-01-31 | McPherson | Nebraska | 31117 | 66 | 1 |
2134651 | 2134651 | 2022-01-20 | Kenedy | Texas | 48261 | 66 | 2 |
2131399 | 2131399 | 2022-01-19 | Kenedy | Texas | 48261 | 66 | 2 |
2127141 | 2127141 | 2022-01-18 | Sioux | Nebraska | 31165 | 66 | 1 |
2128145 | 2128145 | 2022-01-18 | Kenedy | Texas | 48261 | 66 | 2 |
2124893 | 2124893 | 2022-01-17 | Kenedy | Texas | 48261 | 66 | 2 |
2121641 | 2121641 | 2022-01-16 | Kenedy | Texas | 48261 | 66 | 2 |
2118389 | 2118389 | 2022-01-15 | Kenedy | Texas | 48261 | 66 | 2 |
2118409 | 2118409 | 2022-01-15 | Loving | Texas | 48301 | 66 | 0 |
2115158 | 2115158 | 2022-01-14 | Loving | Texas | 48301 | 66 | 0 |
2090506 | 2090506 | 2022-01-07 | Unknown | Iowa | 66 | 0 | |
2087255 | 2087255 | 2022-01-06 | Unknown | Iowa | 66 | 0 | |
2084003 | 2084003 | 2022-01-05 | Unknown | Iowa | 66 | 0 | |
1941768 | 1941768 | 2021-11-22 | Banner | Nebraska | 31007 | 66 | 2 |
1938518 | 1938518 | 2021-11-21 | Banner | Nebraska | 31007 | 66 | 2 |
1938572 | 1938572 | 2021-11-21 | Loup | Nebraska | 31115 | 66 | 0 |
1935268 | 1935268 | 2021-11-20 | Banner | Nebraska | 31007 | 66 | 2 |
1935322 | 1935322 | 2021-11-20 | Loup | Nebraska | 31115 | 66 | 0 |
1932018 | 1932018 | 2021-11-19 | Banner | Nebraska | 31007 | 66 | 2 |
1932072 | 1932072 | 2021-11-19 | Loup | Nebraska | 31115 | 66 | 0 |
1928821 | 1928821 | 2021-11-18 | Loup | Nebraska | 31115 | 66 | 0 |
1824820 | 1824820 | 2021-10-17 | Grant | Nebraska | 31075 | 66 | 4 |
1821571 | 1821571 | 2021-10-16 | Grant | Nebraska | 31075 | 66 | 4 |
1818322 | 1818322 | 2021-10-15 | Grant | Nebraska | 31075 | 66 | 4 |
1815073 | 1815073 | 2021-10-14 | Grant | Nebraska | 31075 | 66 | 4 |
1761466 | 1761466 | 2021-09-28 | Skagway Municipality | Alaska | 2230 | 66 | 0 |
1763044 | 1763044 | 2021-09-28 | Treasure | Montana | 30103 | 66 | 1 |
1759795 | 1759795 | 2021-09-27 | Treasure | Montana | 30103 | 66 | 1 |
1756514 | 1756514 | 2021-09-26 | Golden Valley | Montana | 30037 | 66 | 2 |
1753266 | 1753266 | 2021-09-25 | Golden Valley | Montana | 30037 | 66 | 2 |
1750018 | 1750018 | 2021-09-24 | Golden Valley | Montana | 30037 | 66 | 2 |
1746768 | 1746768 | 2021-09-23 | Golden Valley | Montana | 30037 | 66 | 2 |
1743519 | 1743519 | 2021-09-22 | Golden Valley | Montana | 30037 | 66 | 2 |
1668937 | 1668937 | 2021-08-30 | Eureka | Nevada | 32011 | 66 | 0 |
1650563 | 1650563 | 2021-08-24 | Daggett | Utah | 49009 | 66 | 0 |
1644065 | 1644065 | 2021-08-22 | Daggett | Utah | 49009 | 66 | 0 |
1640815 | 1640815 | 2021-08-21 | Daggett | Utah | 49009 | 66 | 0 |
1637565 | 1637565 | 2021-08-20 | Daggett | Utah | 49009 | 66 | 0 |
1634315 | 1634315 | 2021-08-19 | Daggett | Utah | 49009 | 66 | 0 |
1592028 | 1592028 | 2021-08-06 | Roberts | Texas | 48393 | 66 | 1 |
1588779 | 1588779 | 2021-08-05 | Roberts | Texas | 48393 | 66 | 1 |
1585529 | 1585529 | 2021-08-04 | Roberts | Texas | 48393 | 66 | 1 |
1582279 | 1582279 | 2021-08-03 | Roberts | Texas | 48393 | 66 | 1 |
1579030 | 1579030 | 2021-08-02 | Roberts | Texas | 48393 | 66 | 1 |
1575782 | 1575782 | 2021-08-01 | Roberts | Texas | 48393 | 66 | 1 |
1572534 | 1572534 | 2021-07-31 | Roberts | Texas | 48393 | 66 | 1 |
1569286 | 1569286 | 2021-07-30 | Roberts | Texas | 48393 | 66 | 1 |
1566038 | 1566038 | 2021-07-29 | Roberts | Texas | 48393 | 66 | 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);