ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
950 rows where cases = 214 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 86
- Texas 64
- Nebraska 59
- Kansas 51
- Kentucky 48
- Georgia 47
- Virginia 38
- Missouri 33
- Puerto Rico 33
- Minnesota 30
- Iowa 26
- Colorado 25
- Michigan 22
- Pennsylvania 22
- Montana 21
- North Carolina 21
- West Virginia 20
- Arkansas 19
- Indiana 19
- Ohio 19
- Tennessee 18
- South Dakota 15
- Illinois 14
- Nevada 13
- New York 13
- North Dakota 13
- Washington 13
- Alabama 12
- California 12
- Idaho 12
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2211615 | 2211615 | 2022-02-13 | Judith Basin | Montana | 30045 | 214 | 1 |
2208362 | 2208362 | 2022-02-12 | Judith Basin | Montana | 30045 | 214 | 1 |
2205109 | 2205109 | 2022-02-11 | Judith Basin | Montana | 30045 | 214 | 1 |
2175826 | 2175826 | 2022-02-02 | Garfield | Montana | 30033 | 214 | 3 |
2172573 | 2172573 | 2022-02-01 | Garfield | Montana | 30033 | 214 | 3 |
2167974 | 2167974 | 2022-01-31 | Mineral | Colorado | 8079 | 214 | 1 |
2169320 | 2169320 | 2022-01-31 | Garfield | Montana | 30033 | 214 | 3 |
2129163 | 2129163 | 2022-01-19 | Taliaferro | Georgia | 13265 | 214 | 3 |
2104867 | 2104867 | 2022-01-11 | Gilliam | Oregon | 41021 | 214 | 4 |
2101616 | 2101616 | 2022-01-10 | Gilliam | Oregon | 41021 | 214 | 4 |
2098365 | 2098365 | 2022-01-09 | Gilliam | Oregon | 41021 | 214 | 4 |
2095113 | 2095113 | 2022-01-08 | Gilliam | Oregon | 41021 | 214 | 4 |
2091861 | 2091861 | 2022-01-07 | Gilliam | Oregon | 41021 | 214 | 4 |
2082339 | 2082339 | 2022-01-04 | Campbell | South Dakota | 46021 | 214 | 6 |
2079361 | 2079361 | 2022-01-03 | Jeff Davis | Texas | 48243 | 214 | 6 |
2076258 | 2076258 | 2022-01-02 | Piute | Utah | 49031 | 214 | 2 |
2073007 | 2073007 | 2022-01-01 | Piute | Utah | 49031 | 214 | 2 |
2069756 | 2069756 | 2021-12-31 | Piute | Utah | 49031 | 214 | 2 |
2066505 | 2066505 | 2021-12-30 | Piute | Utah | 49031 | 214 | 2 |
2063255 | 2063255 | 2021-12-29 | Piute | Utah | 49031 | 214 | 2 |
2060005 | 2060005 | 2021-12-28 | Piute | Utah | 49031 | 214 | 2 |
1989799 | 1989799 | 2021-12-07 | Lane | Kansas | 20101 | 214 | 8 |
1986549 | 1986549 | 2021-12-06 | Lane | Kansas | 20101 | 214 | 8 |
1937077 | 1937077 | 2021-11-21 | Sierra | California | 6091 | 214 | 0 |
1933827 | 1933827 | 2021-11-20 | Sierra | California | 6091 | 214 | 0 |
1930575 | 1930575 | 2021-11-19 | Sierra | California | 6091 | 214 | 0 |
1896291 | 1896291 | 2021-11-08 | Deuel | Nebraska | 31049 | 214 | 2 |
1873621 | 1873621 | 2021-11-01 | Eureka | Nevada | 32011 | 214 | 1 |
1870372 | 1870372 | 2021-10-31 | Eureka | Nevada | 32011 | 214 | 1 |
1867123 | 1867123 | 2021-10-30 | Eureka | Nevada | 32011 | 214 | 1 |
1863874 | 1863874 | 2021-10-29 | Eureka | Nevada | 32011 | 214 | 1 |
1860625 | 1860625 | 2021-10-28 | Eureka | Nevada | 32011 | 214 | 1 |
1812958 | 1812958 | 2021-10-13 | Stonewall | Texas | 48433 | 214 | 6 |
1801281 | 1801281 | 2021-10-10 | Comanche | Kansas | 20033 | 214 | 11 |
1798032 | 1798032 | 2021-10-09 | Comanche | Kansas | 20033 | 214 | 11 |
1794783 | 1794783 | 2021-10-08 | Comanche | Kansas | 20033 | 214 | 11 |
1769161 | 1769161 | 2021-09-30 | Keweenaw | Michigan | 26083 | 214 | 4 |
1769519 | 1769519 | 2021-09-30 | McCone | Montana | 30055 | 214 | 2 |
1765912 | 1765912 | 2021-09-29 | Keweenaw | Michigan | 26083 | 214 | 4 |
1762991 | 1762991 | 2021-09-28 | Worth | Missouri | 29227 | 214 | 2 |
1759742 | 1759742 | 2021-09-27 | Worth | Missouri | 29227 | 214 | 2 |
1756494 | 1756494 | 2021-09-26 | Worth | Missouri | 29227 | 214 | 2 |
1756521 | 1756521 | 2021-09-26 | Liberty | Montana | 30051 | 214 | 1 |
1753246 | 1753246 | 2021-09-25 | Worth | Missouri | 29227 | 214 | 2 |
1753273 | 1753273 | 2021-09-25 | Liberty | Montana | 30051 | 214 | 1 |
1749998 | 1749998 | 2021-09-24 | Worth | Missouri | 29227 | 214 | 2 |
1750025 | 1750025 | 2021-09-24 | Liberty | Montana | 30051 | 214 | 1 |
1751060 | 1751060 | 2021-09-24 | Cottle | Texas | 48101 | 214 | 9 |
1746748 | 1746748 | 2021-09-23 | Worth | Missouri | 29227 | 214 | 2 |
1747811 | 1747811 | 2021-09-23 | Cottle | Texas | 48101 | 214 | 9 |
1743229 | 1743229 | 2021-09-22 | Cook | Minnesota | 27031 | 214 | 0 |
1743499 | 1743499 | 2021-09-22 | Worth | Missouri | 29227 | 214 | 2 |
1744561 | 1744561 | 2021-09-22 | Cottle | Texas | 48101 | 214 | 9 |
1740250 | 1740250 | 2021-09-21 | Worth | Missouri | 29227 | 214 | 2 |
1740688 | 1740688 | 2021-09-21 | Steele | North Dakota | 38091 | 214 | 2 |
1736731 | 1736731 | 2021-09-20 | Cook | Minnesota | 27031 | 214 | 0 |
1737001 | 1737001 | 2021-09-20 | Worth | Missouri | 29227 | 214 | 2 |
1733762 | 1733762 | 2021-09-19 | Daniels | Montana | 30019 | 214 | 8 |
1730512 | 1730512 | 2021-09-18 | Daniels | Montana | 30019 | 214 | 8 |
1727262 | 1727262 | 2021-09-17 | Daniels | Montana | 30019 | 214 | 8 |
1724013 | 1724013 | 2021-09-16 | Daniels | Montana | 30019 | 214 | 8 |
1724057 | 1724057 | 2021-09-16 | Wheatland | Montana | 30107 | 214 | 9 |
1712492 | 1712492 | 2021-09-12 | Wahkiakum | Washington | 53069 | 214 | 5 |
1709245 | 1709245 | 2021-09-11 | Wahkiakum | Washington | 53069 | 214 | 5 |
1705998 | 1705998 | 2021-09-10 | Wahkiakum | Washington | 53069 | 214 | 5 |
1701671 | 1701671 | 2021-09-09 | Divide | North Dakota | 38023 | 214 | 2 |
1702748 | 1702748 | 2021-09-09 | Wahkiakum | Washington | 53069 | 214 | 5 |
1656861 | 1656861 | 2021-08-26 | Dickens | Texas | 48125 | 214 | 10 |
1657241 | 1657241 | 2021-08-26 | Columbia | Washington | 53013 | 214 | 6 |
1630208 | 1630208 | 2021-08-18 | Grant | North Dakota | 38037 | 214 | 7 |
1605523 | 1605523 | 2021-08-11 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 214 | 0 |
1608539 | 1608539 | 2021-08-11 | San Juan | Washington | 53055 | 214 | 0 |
1603139 | 1603139 | 2021-08-10 | Hodgeman | Kansas | 20083 | 214 | 9 |
1599890 | 1599890 | 2021-08-09 | Hodgeman | Kansas | 20083 | 214 | 9 |
1601360 | 1601360 | 2021-08-09 | Vieques | Puerto Rico | 72147 | 214 | |
1596638 | 1596638 | 2021-08-08 | Hamilton | Kansas | 20075 | 214 | 1 |
1596642 | 1596642 | 2021-08-08 | Hodgeman | Kansas | 20083 | 214 | 9 |
1598112 | 1598112 | 2021-08-08 | Vieques | Puerto Rico | 72147 | 214 | |
1593389 | 1593389 | 2021-08-07 | Hamilton | Kansas | 20075 | 214 | 1 |
1593393 | 1593393 | 2021-08-07 | Hodgeman | Kansas | 20083 | 214 | 9 |
1594863 | 1594863 | 2021-08-07 | Vieques | Puerto Rico | 72147 | 214 | |
1590140 | 1590140 | 2021-08-06 | Hamilton | Kansas | 20075 | 214 | 1 |
1590144 | 1590144 | 2021-08-06 | Hodgeman | Kansas | 20083 | 214 | 9 |
1586895 | 1586895 | 2021-08-05 | Hodgeman | Kansas | 20083 | 214 | 9 |
1583645 | 1583645 | 2021-08-04 | Hodgeman | Kansas | 20083 | 214 | 9 |
1580395 | 1580395 | 2021-08-03 | Hodgeman | Kansas | 20083 | 214 | 9 |
1577146 | 1577146 | 2021-08-02 | Hodgeman | Kansas | 20083 | 214 | 9 |
1467973 | 1467973 | 2021-06-29 | Cimarron | Oklahoma | 40025 | 214 | 2 |
1464728 | 1464728 | 2021-06-28 | Cimarron | Oklahoma | 40025 | 214 | 2 |
1461483 | 1461483 | 2021-06-27 | Cimarron | Oklahoma | 40025 | 214 | 2 |
1458238 | 1458238 | 2021-06-26 | Cimarron | Oklahoma | 40025 | 214 | 2 |
1454993 | 1454993 | 2021-06-25 | Cimarron | Oklahoma | 40025 | 214 | 2 |
1450524 | 1450524 | 2021-06-24 | Hodgeman | Kansas | 20083 | 214 | 8 |
1451748 | 1451748 | 2021-06-24 | Cimarron | Oklahoma | 40025 | 214 | 2 |
1447279 | 1447279 | 2021-06-23 | Hodgeman | Kansas | 20083 | 214 | 8 |
1448502 | 1448502 | 2021-06-23 | Cimarron | Oklahoma | 40025 | 214 | 2 |
1445257 | 1445257 | 2021-06-22 | Cimarron | Oklahoma | 40025 | 214 | 2 |
1442012 | 1442012 | 2021-06-21 | Cimarron | Oklahoma | 40025 | 214 | 2 |
1438767 | 1438767 | 2021-06-20 | Cimarron | Oklahoma | 40025 | 214 | 2 |
1435520 | 1435520 | 2021-06-19 | Cimarron | Oklahoma | 40025 | 214 | 2 |
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);