ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17,810 rows where cases = 2 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 1,687
- Missouri 1,134
- Kansas 1,043
- Kentucky 731
- Nebraska 729
- Illinois 728
- Virginia 561
- Minnesota 552
- Wisconsin 549
- Oklahoma 502
- North Dakota 493
- Montana 469
- Colorado 464
- Iowa 460
- West Virginia 458
- Georgia 445
- Arkansas 431
- Tennessee 430
- South Dakota 390
- California 374
- Washington 373
- Idaho 356
- North Carolina 356
- Northern Mariana Islands 346
- Michigan 300
- New Mexico 276
- Florida 255
- Ohio 253
- Wyoming 223
- Maine 219
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2346949 | 2346949 | 2022-03-27 | Unknown | Florida | 2 | 427 | |
2343696 | 2343696 | 2022-03-26 | Unknown | Florida | 2 | 427 | |
2340443 | 2340443 | 2022-03-25 | Unknown | Florida | 2 | 427 | |
2301407 | 2301407 | 2022-03-13 | Unknown | Florida | 2 | 863 | |
2298155 | 2298155 | 2022-03-12 | Unknown | Florida | 2 | 863 | |
2294903 | 2294903 | 2022-03-11 | Unknown | Florida | 2 | 863 | |
2200327 | 2200327 | 2022-02-10 | Unknown | Arizona | 2 | 0 | |
2197073 | 2197073 | 2022-02-09 | Unknown | Arizona | 2 | 0 | |
2193818 | 2193818 | 2022-02-08 | Unknown | Arizona | 2 | 0 | |
2194911 | 2194911 | 2022-02-08 | Unknown | Maine | 2 | 0 | |
2191657 | 2191657 | 2022-02-07 | Unknown | Maine | 2 | 0 | |
2188404 | 2188404 | 2022-02-06 | Unknown | Maine | 2 | 0 | |
2185151 | 2185151 | 2022-02-05 | Unknown | Maine | 2 | 0 | |
2172142 | 2172142 | 2022-02-01 | Unknown | Maine | 2 | 0 | |
2138511 | 2138511 | 2022-01-22 | Unknown | Arizona | 2 | 0 | |
2136347 | 2136347 | 2022-01-21 | Unknown | Maine | 2 | 0 | |
2133095 | 2133095 | 2022-01-20 | Unknown | Maine | 2 | 0 | |
2112489 | 2112489 | 2022-01-14 | Unknown | Arizona | 2 | 0 | |
2109237 | 2109237 | 2022-01-13 | Unknown | Arizona | 2 | 0 | |
2099484 | 2099484 | 2022-01-10 | Unknown | Arizona | 2 | 0 | |
2096233 | 2096233 | 2022-01-09 | Unknown | Arizona | 2 | 0 | |
2092981 | 2092981 | 2022-01-08 | Unknown | Arizona | 2 | 0 | |
2089729 | 2089729 | 2022-01-07 | Unknown | Arizona | 2 | 0 | |
2086478 | 2086478 | 2022-01-06 | Unknown | Arizona | 2 | 0 | |
2050998 | 2050998 | 2021-12-26 | Unknown | Florida | 2 | 127 | |
2047748 | 2047748 | 2021-12-25 | Unknown | Florida | 2 | 127 | |
2044498 | 2044498 | 2021-12-24 | Unknown | Florida | 2 | 127 | |
2022560 | 2022560 | 2021-12-17 | Unknown | Maine | 2 | 0 | |
1977052 | 1977052 | 2021-12-03 | Unknown | Maine | 2 | 0 | |
1895796 | 1895796 | 2021-11-08 | Unknown | Maine | 2 | 0 | |
1892546 | 1892546 | 2021-11-07 | Unknown | Maine | 2 | 0 | |
1889296 | 1889296 | 2021-11-06 | Unknown | Maine | 2 | 0 | |
1879548 | 1879548 | 2021-11-03 | Unknown | Maine | 2 | 0 | |
1862489 | 1862489 | 2021-10-29 | Unknown | Florida | 2 | 867 | |
1856805 | 1856805 | 2021-10-27 | Unknown | Maine | 2 | 0 | |
1850307 | 1850307 | 2021-10-25 | Unknown | Maine | 2 | 0 | |
1847057 | 1847057 | 2021-10-24 | Unknown | Maine | 2 | 0 | |
1843807 | 1843807 | 2021-10-23 | Unknown | Maine | 2 | 0 | |
1817839 | 1817839 | 2021-10-15 | Unknown | Maryland | 2 | 60 | |
1814590 | 1814590 | 2021-10-14 | Unknown | Maryland | 2 | 71 | |
1808068 | 1808068 | 2021-10-12 | Unknown | Maine | 2 | 0 | |
1804817 | 1804817 | 2021-10-11 | Unknown | Maine | 2 | 0 | |
1801568 | 1801568 | 2021-10-10 | Unknown | Maine | 2 | 0 | |
1798319 | 1798319 | 2021-10-09 | Unknown | Maine | 2 | 0 | |
1772325 | 1772325 | 2021-10-01 | Unknown | Maine | 2 | 0 | |
1703290 | 1703290 | 2021-09-10 | Unknown | Florida | 2 | 11799 | |
1688721 | 1688721 | 2021-09-05 | Unknown | Northern Mariana Islands | 2 | 0 | |
1685471 | 1685471 | 2021-09-04 | Unknown | Northern Mariana Islands | 2 | 0 | |
1682220 | 1682220 | 2021-09-03 | Unknown | Northern Mariana Islands | 2 | 0 | |
1683306 | 1683306 | 2021-09-03 | Unknown | West Virginia | 2 | 0 | |
1657532 | 1657532 | 2021-08-27 | Unknown | Arizona | 2 | 0 | |
1649740 | 1649740 | 2021-08-24 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1646491 | 1646491 | 2021-08-23 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1643242 | 1643242 | 2021-08-22 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1639992 | 1639992 | 2021-08-21 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1636742 | 1636742 | 2021-08-20 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1633492 | 1633492 | 2021-08-19 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1630245 | 1630245 | 2021-08-18 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1626998 | 1626998 | 2021-08-17 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1623751 | 1623751 | 2021-08-16 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1620504 | 1620504 | 2021-08-15 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1617256 | 1617256 | 2021-08-14 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1614008 | 1614008 | 2021-08-13 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1610759 | 1610759 | 2021-08-12 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1607511 | 1607511 | 2021-08-11 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1604262 | 1604262 | 2021-08-10 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1599339 | 1599339 | 2021-08-09 | Unknown | Florida | 2 | 2961 | |
1600152 | 1600152 | 2021-08-09 | Unknown | Maine | 2 | 0 | |
1600177 | 1600177 | 2021-08-09 | Unknown | Maryland | 2 | 31 | |
1601013 | 1601013 | 2021-08-09 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1596090 | 1596090 | 2021-08-08 | Unknown | Florida | 2 | 2722 | |
1596904 | 1596904 | 2021-08-08 | Unknown | Maine | 2 | 0 | |
1596929 | 1596929 | 2021-08-08 | Unknown | Maryland | 2 | 27 | |
1597765 | 1597765 | 2021-08-08 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1592841 | 1592841 | 2021-08-07 | Unknown | Florida | 2 | 2722 | |
1593655 | 1593655 | 2021-08-07 | Unknown | Maine | 2 | 0 | |
1593680 | 1593680 | 2021-08-07 | Unknown | Maryland | 2 | 20 | |
1594516 | 1594516 | 2021-08-07 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1589592 | 1589592 | 2021-08-06 | Unknown | Florida | 2 | 2722 | |
1590431 | 1590431 | 2021-08-06 | Unknown | Maryland | 2 | 20 | |
1591267 | 1591267 | 2021-08-06 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1587182 | 1587182 | 2021-08-05 | Unknown | Maryland | 2 | 22 | |
1588018 | 1588018 | 2021-08-05 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1583931 | 1583931 | 2021-08-04 | Unknown | Maryland | 2 | 26 | |
1584768 | 1584768 | 2021-08-04 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1580682 | 1580682 | 2021-08-03 | Unknown | Maryland | 2 | 25 | |
1581518 | 1581518 | 2021-08-03 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1576595 | 1576595 | 2021-08-02 | Unknown | Florida | 2 | 2106 | |
1577408 | 1577408 | 2021-08-02 | Unknown | Maine | 2 | 0 | |
1577433 | 1577433 | 2021-08-02 | Unknown | Maryland | 2 | 24 | |
1578269 | 1578269 | 2021-08-02 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1573347 | 1573347 | 2021-08-01 | Unknown | Florida | 2 | 2106 | |
1574160 | 1574160 | 2021-08-01 | Unknown | Maine | 2 | 0 | |
1575021 | 1575021 | 2021-08-01 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1570099 | 1570099 | 2021-07-31 | Unknown | Florida | 2 | 2106 | |
1570912 | 1570912 | 2021-07-31 | Unknown | Maine | 2 | 0 | |
1571773 | 1571773 | 2021-07-31 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1566851 | 1566851 | 2021-07-30 | Unknown | Florida | 2 | 2106 | |
1568525 | 1568525 | 2021-07-30 | Tinian | Northern Mariana Islands | 69120 | 2 | 0 |
1564416 | 1564416 | 2021-07-29 | Unknown | Maine | 2 | 0 |
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);