ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
880 rows where cases = 216 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 130
- Texas 110
- Virginia 43
- Georgia 32
- Kentucky 29
- Puerto Rico 28
- Missouri 25
- Minnesota 23
- West Virginia 23
- Nebraska 22
- Ohio 22
- Colorado 21
- North Carolina 21
- Indiana 19
- Oklahoma 18
- Tennessee 18
- Alabama 17
- Illinois 17
- Iowa 17
- Michigan 16
- New York 16
- North Dakota 16
- Arkansas 14
- Louisiana 14
- Montana 14
- Vermont 14
- South Dakota 13
- Alaska 12
- Pennsylvania 11
- Wisconsin 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2218118 | 2218118 | 2022-02-15 | Judith Basin | Montana | 30045 | 216 | 1 |
2195342 | 2195342 | 2022-02-08 | Garfield | Montana | 30033 | 216 | 3 |
2180195 | 2180195 | 2022-02-03 | Jeff Davis | Texas | 48243 | 216 | 8 |
2174480 | 2174480 | 2022-02-02 | Mineral | Colorado | 8079 | 216 | 1 |
2176944 | 2176944 | 2022-02-02 | Jeff Davis | Texas | 48243 | 216 | 8 |
2171227 | 2171227 | 2022-02-01 | Mineral | Colorado | 8079 | 216 | 1 |
2173690 | 2173690 | 2022-02-01 | Jeff Davis | Texas | 48243 | 216 | 8 |
2170438 | 2170438 | 2022-01-31 | Jeff Davis | Texas | 48243 | 216 | 8 |
2167184 | 2167184 | 2022-01-30 | Jeff Davis | Texas | 48243 | 216 | 8 |
2163929 | 2163929 | 2022-01-29 | Jeff Davis | Texas | 48243 | 216 | 8 |
2160674 | 2160674 | 2022-01-28 | Jeff Davis | Texas | 48243 | 216 | 8 |
2157418 | 2157418 | 2022-01-27 | Jeff Davis | Texas | 48243 | 216 | 8 |
2104884 | 2104884 | 2022-01-11 | Sherman | Oregon | 41055 | 216 | 3 |
2101898 | 2101898 | 2022-01-10 | Sully | South Dakota | 46119 | 216 | 3 |
2089116 | 2089116 | 2022-01-06 | Jeff Davis | Texas | 48243 | 216 | 6 |
2085591 | 2085591 | 2022-01-05 | Campbell | South Dakota | 46021 | 216 | 6 |
2085865 | 2085865 | 2022-01-05 | Jeff Davis | Texas | 48243 | 216 | 6 |
2082613 | 2082613 | 2022-01-04 | Jeff Davis | Texas | 48243 | 216 | 6 |
2021098 | 2021098 | 2021-12-16 | Highland | Virginia | 51091 | 216 | 4 |
2006053 | 2006053 | 2021-12-12 | Lane | Kansas | 20101 | 216 | 9 |
2002802 | 2002802 | 2021-12-11 | Lane | Kansas | 20101 | 216 | 9 |
1999552 | 1999552 | 2021-12-10 | Lane | Kansas | 20101 | 216 | 9 |
1989784 | 1989784 | 2021-12-07 | Greeley | Kansas | 20071 | 216 | 3 |
1986534 | 1986534 | 2021-12-06 | Greeley | Kansas | 20071 | 216 | 3 |
1974649 | 1974649 | 2021-12-02 | Sheridan | North Dakota | 38083 | 216 | 4 |
1971400 | 1971400 | 2021-12-01 | Sheridan | North Dakota | 38083 | 216 | 4 |
1971850 | 1971850 | 2021-12-01 | Hyde | South Dakota | 46069 | 216 | 5 |
1968150 | 1968150 | 2021-11-30 | Sheridan | North Dakota | 38083 | 216 | 4 |
1962943 | 1962943 | 2021-11-29 | Wrangell City and Borough | Alaska | 2275 | 216 | 1 |
1943577 | 1943577 | 2021-11-23 | Sierra | California | 6091 | 216 | 0 |
1940327 | 1940327 | 2021-11-22 | Sierra | California | 6091 | 216 | 0 |
1899541 | 1899541 | 2021-11-09 | Deuel | Nebraska | 31049 | 216 | 2 |
1860670 | 1860670 | 2021-10-28 | Catron | New Mexico | 35003 | 216 | 7 |
1835506 | 1835506 | 2021-10-20 | Briscoe | Texas | 48045 | 216 | 7 |
1832257 | 1832257 | 2021-10-19 | Briscoe | Texas | 48045 | 216 | 7 |
1829008 | 1829008 | 2021-10-18 | Briscoe | Texas | 48045 | 216 | 7 |
1825759 | 1825759 | 2021-10-17 | Briscoe | Texas | 48045 | 216 | 7 |
1822510 | 1822510 | 2021-10-16 | Briscoe | Texas | 48045 | 216 | 7 |
1819261 | 1819261 | 2021-10-15 | Briscoe | Texas | 48045 | 216 | 7 |
1819455 | 1819455 | 2021-10-15 | Stonewall | Texas | 48433 | 216 | 6 |
1816012 | 1816012 | 2021-10-14 | Briscoe | Texas | 48045 | 216 | 7 |
1803710 | 1803710 | 2021-10-11 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 216 | 2 |
1800630 | 1800630 | 2021-10-10 | Dolores | Colorado | 8033 | 216 | 2 |
1797381 | 1797381 | 2021-10-09 | Dolores | Colorado | 8033 | 216 | 2 |
1794132 | 1794132 | 2021-10-08 | Dolores | Colorado | 8033 | 216 | 2 |
1793692 | 1793692 | 2021-10-07 | Garfield | Washington | 53023 | 216 | 7 |
1785737 | 1785737 | 2021-10-05 | Worth | Missouri | 29227 | 216 | 2 |
1782488 | 1782488 | 2021-10-04 | Worth | Missouri | 29227 | 216 | 2 |
1779238 | 1779238 | 2021-10-03 | Worth | Missouri | 29227 | 216 | 2 |
1775988 | 1775988 | 2021-10-02 | Worth | Missouri | 29227 | 216 | 2 |
1767302 | 1767302 | 2021-09-29 | Cottle | Texas | 48101 | 216 | 9 |
1764053 | 1764053 | 2021-09-28 | Cottle | Texas | 48101 | 216 | 9 |
1745207 | 1745207 | 2021-09-23 | Denali Borough | Alaska | 2068 | 216 | 0 |
1740261 | 1740261 | 2021-09-21 | Daniels | Montana | 30019 | 216 | 9 |
1737012 | 1737012 | 2021-09-20 | Daniels | Montana | 30019 | 216 | 8 |
1704921 | 1704921 | 2021-09-10 | Divide | North Dakota | 38023 | 216 | 2 |
1667675 | 1667675 | 2021-08-30 | Quitman | Georgia | 13239 | 216 | 3 |
1664840 | 1664840 | 2021-08-29 | Elk | Kansas | 20049 | 216 | 5 |
1661592 | 1661592 | 2021-08-28 | Elk | Kansas | 20049 | 216 | 5 |
1658344 | 1658344 | 2021-08-27 | Elk | Kansas | 20049 | 216 | 5 |
1636705 | 1636705 | 2021-08-20 | Grant | North Dakota | 38037 | 216 | 7 |
1625876 | 1625876 | 2021-08-17 | Hodgeman | Kansas | 20083 | 216 | 9 |
1622629 | 1622629 | 2021-08-16 | Hodgeman | Kansas | 20083 | 216 | 9 |
1619378 | 1619378 | 2021-08-15 | Hamilton | Kansas | 20075 | 216 | 1 |
1619382 | 1619382 | 2021-08-15 | Hodgeman | Kansas | 20083 | 216 | 9 |
1619385 | 1619385 | 2021-08-15 | Jewell | Kansas | 20089 | 216 | 6 |
1616130 | 1616130 | 2021-08-14 | Hamilton | Kansas | 20075 | 216 | 1 |
1616134 | 1616134 | 2021-08-14 | Hodgeman | Kansas | 20083 | 216 | 9 |
1616137 | 1616137 | 2021-08-14 | Jewell | Kansas | 20089 | 216 | 6 |
1612881 | 1612881 | 2021-08-13 | Hamilton | Kansas | 20075 | 216 | 1 |
1612885 | 1612885 | 2021-08-13 | Hodgeman | Kansas | 20083 | 216 | 9 |
1612888 | 1612888 | 2021-08-13 | Jewell | Kansas | 20089 | 216 | 6 |
1609637 | 1609637 | 2021-08-12 | Hodgeman | Kansas | 20083 | 216 | 9 |
1609640 | 1609640 | 2021-08-12 | Jewell | Kansas | 20089 | 216 | 6 |
1606388 | 1606388 | 2021-08-11 | Hodgeman | Kansas | 20083 | 216 | 9 |
1606391 | 1606391 | 2021-08-11 | Jewell | Kansas | 20089 | 216 | 6 |
1607858 | 1607858 | 2021-08-11 | Vieques | Puerto Rico | 72147 | 216 | |
1604609 | 1604609 | 2021-08-10 | Vieques | Puerto Rico | 72147 | 216 | |
1556104 | 1556104 | 2021-07-26 | Armstrong | Texas | 48011 | 216 | 7 |
1552857 | 1552857 | 2021-07-25 | Armstrong | Texas | 48011 | 216 | 7 |
1549610 | 1549610 | 2021-07-24 | Armstrong | Texas | 48011 | 216 | 7 |
1549768 | 1549768 | 2021-07-24 | Menard | Texas | 48327 | 216 | 9 |
1546363 | 1546363 | 2021-07-23 | Armstrong | Texas | 48011 | 216 | 7 |
1546521 | 1546521 | 2021-07-23 | Menard | Texas | 48327 | 216 | 9 |
1543274 | 1543274 | 2021-07-22 | Menard | Texas | 48327 | 216 | 9 |
1540026 | 1540026 | 2021-07-21 | Menard | Texas | 48327 | 216 | 9 |
1536779 | 1536779 | 2021-07-20 | Menard | Texas | 48327 | 216 | 9 |
1533531 | 1533531 | 2021-07-19 | Menard | Texas | 48327 | 216 | 9 |
1530284 | 1530284 | 2021-07-18 | Menard | Texas | 48327 | 216 | 9 |
1527037 | 1527037 | 2021-07-17 | Menard | Texas | 48327 | 216 | 9 |
1489476 | 1489476 | 2021-07-06 | Jewell | Kansas | 20089 | 216 | 6 |
1486229 | 1486229 | 2021-07-05 | Jewell | Kansas | 20089 | 216 | 6 |
1482983 | 1482983 | 2021-07-04 | Jewell | Kansas | 20089 | 216 | 6 |
1479736 | 1479736 | 2021-07-03 | Jewell | Kansas | 20089 | 216 | 6 |
1476490 | 1476490 | 2021-07-02 | Jewell | Kansas | 20089 | 216 | 6 |
1473244 | 1473244 | 2021-07-01 | Jewell | Kansas | 20089 | 216 | 6 |
1469998 | 1469998 | 2021-06-30 | Jewell | Kansas | 20089 | 216 | 6 |
1466753 | 1466753 | 2021-06-29 | Jewell | Kansas | 20089 | 216 | 6 |
1463508 | 1463508 | 2021-06-28 | Jewell | Kansas | 20089 | 216 | 6 |
1460263 | 1460263 | 2021-06-27 | Jewell | Kansas | 20089 | 216 | 6 |
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);