ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
190 rows where cases = 2387 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 15
- Illinois 12
- Kentucky 12
- Mississippi 11
- Puerto Rico 11
- North Carolina 10
- Missouri 9
- Texas 9
- Virginia 8
- Michigan 6
- Georgia 5
- Iowa 5
- Minnesota 5
- Ohio 5
- Tennessee 5
- Florida 4
- Idaho 4
- Indiana 4
- Kansas 4
- Utah 4
- Washington 4
- Arkansas 3
- Maryland 3
- New York 3
- Pennsylvania 3
- Wyoming 3
- Alabama 2
- Colorado 2
- Louisiana 2
- Maine 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2382950 | 2382950 | 2022-04-07 | Washington | Idaho | 16087 | 2387 | 57 |
2265852 | 2265852 | 2022-03-02 | Brown | Illinois | 17009 | 2387 | 21 |
2262601 | 2262601 | 2022-03-01 | Brown | Illinois | 17009 | 2387 | 21 |
2215980 | 2215980 | 2022-02-14 | Jim Hogg | Texas | 48247 | 2387 | 20 |
2199340 | 2199340 | 2022-02-09 | Lajas | Puerto Rico | 72079 | 2387 | |
2191596 | 2191596 | 2022-02-07 | East Carroll | Louisiana | 22035 | 2387 | 35 |
2191963 | 2191963 | 2022-02-07 | Bollinger | Missouri | 29017 | 2387 | 35 |
2187367 | 2187367 | 2022-02-06 | Perry | Arkansas | 5105 | 2387 | 29 |
2173831 | 2173831 | 2022-02-01 | Emery | Utah | 49015 | 2387 | 25 |
2170043 | 2170043 | 2022-01-31 | Ciales | Puerto Rico | 72039 | 2387 | |
2164729 | 2164729 | 2022-01-30 | Prowers | Colorado | 8099 | 2387 | 45 |
2165857 | 2165857 | 2022-01-30 | Carroll | Mississippi | 28015 | 2387 | 43 |
2167667 | 2167667 | 2022-01-30 | Big Horn | Wyoming | 56003 | 2387 | 60 |
2162602 | 2162602 | 2022-01-29 | Carroll | Mississippi | 28015 | 2387 | 43 |
2164412 | 2164412 | 2022-01-29 | Big Horn | Wyoming | 56003 | 2387 | 60 |
2158218 | 2158218 | 2022-01-28 | Prowers | Colorado | 8099 | 2387 | 45 |
2159347 | 2159347 | 2022-01-28 | Carroll | Mississippi | 28015 | 2387 | 43 |
2161157 | 2161157 | 2022-01-28 | Big Horn | Wyoming | 56003 | 2387 | 60 |
2157705 | 2157705 | 2022-01-27 | Richmond | Virginia | 51159 | 2387 | 17 |
2142299 | 2142299 | 2022-01-23 | Jasper | Illinois | 17079 | 2387 | 26 |
2139044 | 2139044 | 2022-01-22 | Jasper | Illinois | 17079 | 2387 | 26 |
2135788 | 2135788 | 2022-01-21 | Jasper | Illinois | 17079 | 2387 | 26 |
2133485 | 2133485 | 2022-01-20 | Ripley | Missouri | 29181 | 2387 | 53 |
2128044 | 2128044 | 2022-01-18 | Callahan | Texas | 48059 | 2387 | 62 |
2100794 | 2100794 | 2022-01-10 | Amite | Mississippi | 28005 | 2387 | 59 |
2054557 | 2054557 | 2021-12-27 | Wabash | Illinois | 17185 | 2387 | 22 |
2024172 | 2024172 | 2021-12-17 | Pecos | Texas | 48371 | 2387 | 58 |
2008000 | 2008000 | 2021-12-12 | Millard | Utah | 49027 | 2387 | 30 |
2004749 | 2004749 | 2021-12-11 | Millard | Utah | 49027 | 2387 | 30 |
2001498 | 2001498 | 2021-12-10 | Millard | Utah | 49027 | 2387 | 30 |
1975734 | 1975734 | 2021-12-02 | Morgan | West Virginia | 54065 | 2387 | 48 |
1968308 | 1968308 | 2021-11-30 | Okfuskee | Oklahoma | 40107 | 2387 | 47 |
1965057 | 1965057 | 2021-11-29 | Okfuskee | Oklahoma | 40107 | 2387 | 47 |
1965956 | 1965956 | 2021-11-29 | Braxton | West Virginia | 54007 | 2387 | 23 |
1961805 | 1961805 | 2021-11-28 | Okfuskee | Oklahoma | 40107 | 2387 | 47 |
1958554 | 1958554 | 2021-11-27 | Okfuskee | Oklahoma | 40107 | 2387 | 47 |
1955303 | 1955303 | 2021-11-26 | Okfuskee | Oklahoma | 40107 | 2387 | 47 |
1952052 | 1952052 | 2021-11-25 | Okfuskee | Oklahoma | 40107 | 2387 | 47 |
1948801 | 1948801 | 2021-11-24 | Okfuskee | Oklahoma | 40107 | 2387 | 47 |
1928725 | 1928725 | 2021-11-18 | Glacier | Montana | 30035 | 2387 | 59 |
1918848 | 1918848 | 2021-11-15 | Bates | Missouri | 29013 | 2387 | 43 |
1915443 | 1915443 | 2021-11-14 | Faribault | Minnesota | 27043 | 2387 | 31 |
1912193 | 1912193 | 2021-11-13 | Faribault | Minnesota | 27043 | 2387 | 31 |
1908943 | 1908943 | 2021-11-12 | Faribault | Minnesota | 27043 | 2387 | 31 |
1906639 | 1906639 | 2021-11-11 | Fulton | Pennsylvania | 42057 | 2387 | 33 |
1872459 | 1872459 | 2021-11-01 | Carroll | Illinois | 17015 | 2387 | 39 |
1873740 | 1873740 | 2021-11-01 | Schoharie | New York | 36095 | 2387 | 23 |
1869619 | 1869619 | 2021-10-31 | Caldwell | Kentucky | 21033 | 2387 | 48 |
1866370 | 1866370 | 2021-10-30 | Caldwell | Kentucky | 21033 | 2387 | 48 |
1863121 | 1863121 | 2021-10-29 | Caldwell | Kentucky | 21033 | 2387 | 48 |
1864488 | 1864488 | 2021-10-29 | Naranjito | Puerto Rico | 72105 | 2387 | |
1853027 | 1853027 | 2021-10-26 | Moultrie | Illinois | 17139 | 2387 | 41 |
1793018 | 1793018 | 2021-10-07 | San Lorenzo | Puerto Rico | 72129 | 2387 | |
1784752 | 1784752 | 2021-10-05 | Ford | Illinois | 17053 | 2387 | 66 |
1758150 | 1758150 | 2021-09-27 | Crenshaw | Alabama | 1041 | 2387 | 70 |
1747469 | 1747469 | 2021-09-23 | Aguada | Puerto Rico | 72003 | 2387 | |
1744219 | 1744219 | 2021-09-22 | Aguada | Puerto Rico | 72003 | 2387 | |
1741019 | 1741019 | 2021-09-21 | Moca | Puerto Rico | 72099 | 2387 | |
1737770 | 1737770 | 2021-09-20 | Moca | Puerto Rico | 72099 | 2387 | |
1734520 | 1734520 | 2021-09-19 | Moca | Puerto Rico | 72099 | 2387 | |
1731557 | 1731557 | 2021-09-18 | Colorado | Texas | 48089 | 2387 | 43 |
1718101 | 1718101 | 2021-09-14 | Pawnee | Oklahoma | 40117 | 2387 | 57 |
1714853 | 1714853 | 2021-09-13 | Pawnee | Oklahoma | 40117 | 2387 | 57 |
1715169 | 1715169 | 2021-09-13 | Union | South Dakota | 46127 | 2387 | 43 |
1711607 | 1711607 | 2021-09-12 | Pawnee | Oklahoma | 40117 | 2387 | 57 |
1706217 | 1706217 | 2021-09-11 | Washington | Alabama | 1129 | 2387 | 43 |
1708360 | 1708360 | 2021-09-11 | Pawnee | Oklahoma | 40117 | 2387 | 57 |
1704518 | 1704518 | 2021-09-10 | Wright | Missouri | 29229 | 2387 | 44 |
1705113 | 1705113 | 2021-09-10 | Pawnee | Oklahoma | 40117 | 2387 | 57 |
1701863 | 1701863 | 2021-09-09 | Pawnee | Oklahoma | 40117 | 2387 | 57 |
1702022 | 1702022 | 2021-09-09 | Isabela | Puerto Rico | 72071 | 2387 | |
1698614 | 1698614 | 2021-09-08 | Pawnee | Oklahoma | 40117 | 2387 | 57 |
1694724 | 1694724 | 2021-09-07 | Moniteau | Missouri | 29135 | 2387 | 36 |
1694727 | 1694727 | 2021-09-07 | Morgan | Missouri | 29141 | 2387 | 53 |
1691475 | 1691475 | 2021-09-06 | Moniteau | Missouri | 29135 | 2387 | 36 |
1672250 | 1672250 | 2021-08-31 | Roosevelt | New Mexico | 35041 | 2387 | 63 |
1644902 | 1644902 | 2021-08-23 | Jeff Davis | Georgia | 13161 | 2387 | 45 |
1622470 | 1622470 | 2021-08-16 | Starke | Indiana | 18149 | 2387 | 61 |
1609127 | 1609127 | 2021-08-12 | Cook | Georgia | 13075 | 2387 | 44 |
1600264 | 1600264 | 2021-08-09 | Otsego | Michigan | 26137 | 2387 | 41 |
1550818 | 1550818 | 2021-07-25 | Minidoka | Idaho | 16067 | 2387 | 33 |
1547571 | 1547571 | 2021-07-24 | Minidoka | Idaho | 16067 | 2387 | 33 |
1544324 | 1544324 | 2021-07-23 | Minidoka | Idaho | 16067 | 2387 | 33 |
1509279 | 1509279 | 2021-07-12 | Emmet | Michigan | 26047 | 2387 | 43 |
1506033 | 1506033 | 2021-07-11 | Emmet | Michigan | 26047 | 2387 | 43 |
1502787 | 1502787 | 2021-07-10 | Emmet | Michigan | 26047 | 2387 | 43 |
1499541 | 1499541 | 2021-07-09 | Emmet | Michigan | 26047 | 2387 | 43 |
1493773 | 1493773 | 2021-07-07 | Transylvania | North Carolina | 37175 | 2387 | 33 |
1487279 | 1487279 | 2021-07-05 | Transylvania | North Carolina | 37175 | 2387 | 33 |
1484033 | 1484033 | 2021-07-04 | Transylvania | North Carolina | 37175 | 2387 | 33 |
1480787 | 1480787 | 2021-07-03 | Transylvania | North Carolina | 37175 | 2387 | 33 |
1477540 | 1477540 | 2021-07-02 | Transylvania | North Carolina | 37175 | 2387 | 33 |
1473711 | 1473711 | 2021-07-01 | Waseca | Minnesota | 27161 | 2387 | 23 |
1463643 | 1463643 | 2021-06-28 | Marion | Kentucky | 21155 | 2387 | 38 |
1460398 | 1460398 | 2021-06-27 | Marion | Kentucky | 21155 | 2387 | 38 |
1457153 | 1457153 | 2021-06-26 | Marion | Kentucky | 21155 | 2387 | 38 |
1453908 | 1453908 | 2021-06-25 | Marion | Kentucky | 21155 | 2387 | 38 |
1422365 | 1422365 | 2021-06-15 | Transylvania | North Carolina | 37175 | 2387 | 33 |
1412981 | 1412981 | 2021-06-12 | Canovanas | Puerto Rico | 72029 | 2387 | |
1410078 | 1410078 | 2021-06-11 | Dimmit | Texas | 48127 | 2387 | 37 |
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);