ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
176 rows where cases = 2999 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 21
- Arkansas 12
- Mississippi 12
- Virginia 12
- Georgia 9
- Oklahoma 8
- Illinois 7
- Indiana 7
- Missouri 6
- Texas 6
- Colorado 5
- Kentucky 5
- Louisiana 5
- South Carolina 5
- Alabama 4
- California 4
- Idaho 4
- Minnesota 4
- Pennsylvania 4
- Puerto Rico 4
- Florida 3
- Maryland 3
- New Mexico 3
- North Carolina 3
- West Virginia 3
- New York 2
- Ohio 2
- South Dakota 2
- Wisconsin 2
- Wyoming 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2452050 | 2452050 | 2022-04-28 | Aitkin | Minnesota | 27001 | 2999 | 62 |
2369621 | 2369621 | 2022-04-03 | Moffat | Colorado | 8081 | 2999 | 51 |
2366368 | 2366368 | 2022-04-02 | Moffat | Colorado | 8081 | 2999 | 51 |
2363115 | 2363115 | 2022-04-01 | Moffat | Colorado | 8081 | 2999 | 51 |
2359861 | 2359861 | 2022-03-31 | Moffat | Colorado | 8081 | 2999 | 51 |
2351393 | 2351393 | 2022-03-28 | Pemiscot | Missouri | 29155 | 2999 | 74 |
2323999 | 2323999 | 2022-03-20 | Mariposa | California | 6043 | 2999 | 30 |
2320745 | 2320745 | 2022-03-19 | Mariposa | California | 6043 | 2999 | 30 |
2317491 | 2317491 | 2022-03-18 | Mariposa | California | 6043 | 2999 | 30 |
2283509 | 2283509 | 2022-03-07 | Washington | North Carolina | 37187 | 2999 | 50 |
2278671 | 2278671 | 2022-03-06 | Charlton | Georgia | 13049 | 2999 | 62 |
2275418 | 2275418 | 2022-03-05 | Charlton | Georgia | 13049 | 2999 | 62 |
2272165 | 2272165 | 2022-03-04 | Charlton | Georgia | 13049 | 2999 | 62 |
2242620 | 2242620 | 2022-02-23 | Desha | Arkansas | 5041 | 2999 | 38 |
2212986 | 2212986 | 2022-02-13 | Martinsville city | Virginia | 51690 | 2999 | 107 |
2209733 | 2209733 | 2022-02-12 | Martinsville city | Virginia | 51690 | 2999 | 107 |
2206480 | 2206480 | 2022-02-11 | Martinsville city | Virginia | 51690 | 2999 | 107 |
2178865 | 2178865 | 2022-02-03 | Amite | Mississippi | 28005 | 2999 | 61 |
2157048 | 2157048 | 2022-01-27 | Loiza | Puerto Rico | 72087 | 2999 | |
2150551 | 2150551 | 2022-01-25 | Naguabo | Puerto Rico | 72103 | 2999 | |
2099956 | 2099956 | 2022-01-10 | Gem | Idaho | 16045 | 2999 | 72 |
2097311 | 2097311 | 2022-01-09 | Winn | Louisiana | 22127 | 2999 | 58 |
2094059 | 2094059 | 2022-01-08 | Winn | Louisiana | 22127 | 2999 | 58 |
2090807 | 2090807 | 2022-01-07 | Winn | Louisiana | 22127 | 2999 | 58 |
2054490 | 2054490 | 2021-12-27 | Ford | Illinois | 17053 | 2999 | 67 |
2050749 | 2050749 | 2021-12-26 | Grant | Arkansas | 5053 | 2999 | 52 |
2047499 | 2047499 | 2021-12-25 | Grant | Arkansas | 5053 | 2999 | 52 |
2037186 | 2037186 | 2021-12-21 | Robertson | Texas | 48395 | 2999 | 68 |
1989893 | 1989893 | 2021-12-07 | Garrard | Kentucky | 21079 | 2999 | 55 |
1992091 | 1992091 | 2021-12-07 | Lincoln | Wyoming | 56023 | 2999 | 25 |
1986226 | 1986226 | 2021-12-06 | Edgar | Illinois | 17045 | 2999 | 70 |
1978729 | 1978729 | 2021-12-03 | Young | Texas | 48503 | 2999 | 72 |
1975479 | 1975479 | 2021-12-02 | Young | Texas | 48503 | 2999 | 72 |
1969129 | 1969129 | 2021-11-30 | Prince Edward | Virginia | 51147 | 2999 | 52 |
1927260 | 1927260 | 2021-11-18 | Polk | Arkansas | 5113 | 2999 | 112 |
1924010 | 1924010 | 2021-11-17 | Polk | Arkansas | 5113 | 2999 | 112 |
1926174 | 1926174 | 2021-11-17 | Wyoming | Pennsylvania | 42131 | 2999 | 65 |
1920761 | 1920761 | 2021-11-16 | Polk | Arkansas | 5113 | 2999 | 112 |
1917511 | 1917511 | 2021-11-15 | Polk | Arkansas | 5113 | 2999 | 112 |
1914261 | 1914261 | 2021-11-14 | Polk | Arkansas | 5113 | 2999 | 112 |
1911011 | 1911011 | 2021-11-13 | Polk | Arkansas | 5113 | 2999 | 112 |
1906470 | 1906470 | 2021-11-11 | Paulding | Ohio | 39125 | 2999 | 47 |
1897975 | 1897975 | 2021-11-09 | Cross | Arkansas | 5037 | 2999 | 65 |
1883185 | 1883185 | 2021-11-04 | Ray | Missouri | 29177 | 2999 | 50 |
1876706 | 1876706 | 2021-11-02 | Texas | Missouri | 29215 | 2999 | 43 |
1872613 | 1872613 | 2021-11-01 | Orange | Indiana | 18117 | 2999 | 69 |
1846421 | 1846421 | 2021-10-24 | Blaine | Idaho | 16013 | 2999 | 26 |
1843171 | 1843171 | 2021-10-23 | Blaine | Idaho | 16013 | 2999 | 26 |
1839018 | 1839018 | 2021-10-21 | Bennington | Vermont | 50003 | 2999 | 26 |
1835962 | 1835962 | 2021-10-20 | Brooke | West Virginia | 54009 | 2999 | 71 |
1823810 | 1823810 | 2021-10-17 | Wayne | Illinois | 17191 | 2999 | 62 |
1819872 | 1819872 | 2021-10-16 | Cherokee | Alabama | 1019 | 2999 | 57 |
1820561 | 1820561 | 2021-10-16 | Wayne | Illinois | 17191 | 2999 | 62 |
1817312 | 1817312 | 2021-10-15 | Wayne | Illinois | 17191 | 2999 | 62 |
1803809 | 1803809 | 2021-10-11 | Colusa | California | 6011 | 2999 | 18 |
1792369 | 1792369 | 2021-10-07 | Saunders | Nebraska | 31155 | 2999 | 20 |
1792988 | 1792988 | 2021-10-07 | Humacao | Puerto Rico | 72069 | 2999 | |
1793619 | 1793619 | 2021-10-07 | Louisa | Virginia | 51109 | 2999 | 42 |
1784674 | 1784674 | 2021-10-05 | Worth | Georgia | 13321 | 2999 | 84 |
1784903 | 1784903 | 2021-10-05 | Starke | Indiana | 18149 | 2999 | 69 |
1759538 | 1759538 | 2021-09-27 | Waseca | Minnesota | 27161 | 2999 | 26 |
1760727 | 1760727 | 2021-09-27 | Polk | Tennessee | 47139 | 2999 | 25 |
1741941 | 1741941 | 2021-09-22 | Randolph | Alabama | 1111 | 2999 | 55 |
1737752 | 1737752 | 2021-09-20 | Gurabo | Puerto Rico | 72063 | 2999 | |
1733221 | 1733221 | 2021-09-19 | Meade | Kentucky | 21163 | 2999 | 30 |
1729971 | 1729971 | 2021-09-18 | Meade | Kentucky | 21163 | 2999 | 30 |
1726721 | 1726721 | 2021-09-17 | Meade | Kentucky | 21163 | 2999 | 30 |
1725406 | 1725406 | 2021-09-16 | Orange | Virginia | 51137 | 2999 | 44 |
1720276 | 1720276 | 2021-09-15 | Concordia | Louisiana | 22029 | 2999 | 73 |
1711834 | 1711834 | 2021-09-12 | Fairfield | South Carolina | 45039 | 2999 | 87 |
1708587 | 1708587 | 2021-09-11 | Fairfield | South Carolina | 45039 | 2999 | 87 |
1705340 | 1705340 | 2021-09-10 | Fairfield | South Carolina | 45039 | 2999 | 87 |
1657288 | 1657288 | 2021-08-26 | Hancock | West Virginia | 54029 | 2999 | 90 |
1647089 | 1647089 | 2021-08-23 | Cass | Texas | 48067 | 2999 | 95 |
1643840 | 1643840 | 2021-08-22 | Cass | Texas | 48067 | 2999 | 95 |
1644171 | 1644171 | 2021-08-22 | Hopewell city | Virginia | 51670 | 2999 | 79 |
1640921 | 1640921 | 2021-08-21 | Hopewell city | Virginia | 51670 | 2999 | 79 |
1637395 | 1637395 | 2021-08-20 | Gonzales | Texas | 48177 | 2999 | 60 |
1637671 | 1637671 | 2021-08-20 | Hopewell city | Virginia | 51670 | 2999 | 79 |
1619213 | 1619213 | 2021-08-15 | Posey | Indiana | 18129 | 2999 | 36 |
1615965 | 1615965 | 2021-08-14 | Posey | Indiana | 18129 | 2999 | 36 |
1612716 | 1612716 | 2021-08-13 | Posey | Indiana | 18129 | 2999 | 36 |
1610623 | 1610623 | 2021-08-12 | Cherokee | North Carolina | 37039 | 2999 | 39 |
1541622 | 1541622 | 2021-07-22 | De Soto | Louisiana | 22031 | 2999 | 79 |
1538828 | 1538828 | 2021-07-21 | Saline | Missouri | 29195 | 2999 | 39 |
1520881 | 1520881 | 2021-07-15 | Mineral | West Virginia | 54057 | 2999 | 92 |
1510945 | 1510945 | 2021-07-12 | Amherst | Virginia | 51009 | 2999 | 40 |
1507698 | 1507698 | 2021-07-11 | Amherst | Virginia | 51009 | 2999 | 40 |
1472738 | 1472738 | 2021-07-01 | Decatur | Georgia | 13087 | 2999 | 73 |
1471675 | 1471675 | 2021-06-30 | Wayne | Tennessee | 47181 | 2999 | 36 |
1468430 | 1468430 | 2021-06-29 | Wayne | Tennessee | 47181 | 2999 | 36 |
1465185 | 1465185 | 2021-06-28 | Wayne | Tennessee | 47181 | 2999 | 36 |
1461940 | 1461940 | 2021-06-27 | Wayne | Tennessee | 47181 | 2999 | 36 |
1458695 | 1458695 | 2021-06-26 | Wayne | Tennessee | 47181 | 2999 | 36 |
1455450 | 1455450 | 2021-06-25 | Wayne | Tennessee | 47181 | 2999 | 36 |
1452205 | 1452205 | 2021-06-24 | Wayne | Tennessee | 47181 | 2999 | 36 |
1447770 | 1447770 | 2021-06-23 | Copiah | Mississippi | 28029 | 2999 | 66 |
1448959 | 1448959 | 2021-06-23 | Wayne | Tennessee | 47181 | 2999 | 36 |
1444525 | 1444525 | 2021-06-22 | Copiah | Mississippi | 28029 | 2999 | 66 |
1445714 | 1445714 | 2021-06-22 | Wayne | Tennessee | 47181 | 2999 | 36 |
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);