ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,155 rows where cases = 136 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 97
- South Dakota 58
- Georgia 44
- Virginia 41
- Kentucky 40
- Arkansas 38
- Illinois 38
- Michigan 38
- Minnesota 38
- Puerto Rico 37
- Iowa 36
- Kansas 35
- Nebraska 35
- Missouri 34
- West Virginia 34
- Mississippi 29
- Tennessee 29
- Indiana 28
- Ohio 28
- Colorado 27
- Louisiana 27
- Montana 27
- Utah 27
- North Carolina 25
- Oklahoma 22
- Oregon 21
- Washington 21
- New Mexico 20
- California 18
- Pennsylvania 17
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2314118 | 2314118 | 2022-03-17 | Skagway Municipality | Alaska | 2230 | 136 | 0 |
2310865 | 2310865 | 2022-03-16 | Skagway Municipality | Alaska | 2230 | 136 | 0 |
2247406 | 2247406 | 2022-02-24 | Treasure | Montana | 30103 | 136 | 1 |
2220302 | 2220302 | 2022-02-16 | Camas | Idaho | 16025 | 136 | 2 |
2183476 | 2183476 | 2022-02-04 | Loving | Texas | 48301 | 136 | 0 |
2159934 | 2159934 | 2022-01-28 | Billings | North Dakota | 38007 | 136 | 1 |
2156679 | 2156679 | 2022-01-27 | Billings | North Dakota | 38007 | 136 | 1 |
2147799 | 2147799 | 2022-01-24 | Daggett | Utah | 49009 | 136 | 0 |
2144545 | 2144545 | 2022-01-23 | Daggett | Utah | 49009 | 136 | 0 |
2141290 | 2141290 | 2022-01-22 | Daggett | Utah | 49009 | 136 | 0 |
2138034 | 2138034 | 2022-01-21 | Daggett | Utah | 49009 | 136 | 0 |
2132169 | 2132169 | 2022-01-20 | Jackson | Colorado | 8057 | 136 | 0 |
1920193 | 1920193 | 2021-11-15 | Throckmorton | Texas | 48447 | 136 | 7 |
1916943 | 1916943 | 2021-11-14 | Throckmorton | Texas | 48447 | 136 | 7 |
1913693 | 1913693 | 2021-11-13 | Throckmorton | Texas | 48447 | 136 | 7 |
1910443 | 1910443 | 2021-11-12 | Throckmorton | Texas | 48447 | 136 | 7 |
1907194 | 1907194 | 2021-11-11 | Throckmorton | Texas | 48447 | 136 | 7 |
1860485 | 1860485 | 2021-10-28 | Garfield | Montana | 30033 | 136 | 3 |
1789871 | 1789871 | 2021-10-06 | Jones | South Dakota | 46075 | 136 | 0 |
1784216 | 1784216 | 2021-10-05 | Wrangell City and Borough | Alaska | 2275 | 136 | 0 |
1786623 | 1786623 | 2021-10-05 | Jones | South Dakota | 46075 | 136 | 0 |
1780967 | 1780967 | 2021-10-04 | Wrangell City and Borough | Alaska | 2275 | 136 | 0 |
1783374 | 1783374 | 2021-10-04 | Jones | South Dakota | 46075 | 136 | 0 |
1777717 | 1777717 | 2021-10-03 | Wrangell City and Borough | Alaska | 2275 | 136 | 0 |
1780125 | 1780125 | 2021-10-03 | Jones | South Dakota | 46075 | 136 | 0 |
1774467 | 1774467 | 2021-10-02 | Wrangell City and Borough | Alaska | 2275 | 136 | 0 |
1776875 | 1776875 | 2021-10-02 | Jones | South Dakota | 46075 | 136 | 0 |
1771217 | 1771217 | 2021-10-01 | Wrangell City and Borough | Alaska | 2275 | 136 | 0 |
1773625 | 1773625 | 2021-10-01 | Jones | South Dakota | 46075 | 136 | 0 |
1769923 | 1769923 | 2021-09-30 | Sheridan | North Dakota | 38083 | 136 | 3 |
1770375 | 1770375 | 2021-09-30 | Jones | South Dakota | 46075 | 136 | 0 |
1766674 | 1766674 | 2021-09-29 | Sheridan | North Dakota | 38083 | 136 | 3 |
1767126 | 1767126 | 2021-09-29 | Jones | South Dakota | 46075 | 136 | 0 |
1763425 | 1763425 | 2021-09-28 | Sheridan | North Dakota | 38083 | 136 | 3 |
1763877 | 1763877 | 2021-09-28 | Jones | South Dakota | 46075 | 136 | 0 |
1746951 | 1746951 | 2021-09-23 | Catron | New Mexico | 35003 | 136 | 7 |
1743702 | 1743702 | 2021-09-22 | Catron | New Mexico | 35003 | 136 | 7 |
1740332 | 1740332 | 2021-09-21 | Deuel | Nebraska | 31049 | 136 | 2 |
1740453 | 1740453 | 2021-09-21 | Catron | New Mexico | 35003 | 136 | 7 |
1737083 | 1737083 | 2021-09-20 | Deuel | Nebraska | 31049 | 136 | 2 |
1737204 | 1737204 | 2021-09-20 | Catron | New Mexico | 35003 | 136 | 7 |
1734377 | 1734377 | 2021-09-19 | Gilliam | Oregon | 41021 | 136 | 4 |
1731127 | 1731127 | 2021-09-18 | Gilliam | Oregon | 41021 | 136 | 4 |
1727877 | 1727877 | 2021-09-17 | Gilliam | Oregon | 41021 | 136 | 4 |
1711067 | 1711067 | 2021-09-12 | Wibaux | Montana | 30109 | 136 | 6 |
1712109 | 1712109 | 2021-09-12 | Glasscock | Texas | 48173 | 136 | 3 |
1707820 | 1707820 | 2021-09-11 | Wibaux | Montana | 30109 | 136 | 6 |
1708862 | 1708862 | 2021-09-11 | Glasscock | Texas | 48173 | 136 | 3 |
1704573 | 1704573 | 2021-09-10 | Wibaux | Montana | 30109 | 136 | 6 |
1705615 | 1705615 | 2021-09-10 | Glasscock | Texas | 48173 | 136 | 3 |
1701323 | 1701323 | 2021-09-09 | Wibaux | Montana | 30109 | 136 | 6 |
1673125 | 1673125 | 2021-08-31 | Glasscock | Texas | 48173 | 136 | 3 |
1633210 | 1633210 | 2021-08-19 | Storey | Nevada | 32029 | 136 | 4 |
1629963 | 1629963 | 2021-08-18 | Storey | Nevada | 32029 | 136 | 4 |
1625012 | 1625012 | 2021-08-17 | Denali Borough | Alaska | 2068 | 136 | 0 |
1621954 | 1621954 | 2021-08-16 | Dolores | Colorado | 8033 | 136 | 1 |
1618707 | 1618707 | 2021-08-15 | Dolores | Colorado | 8033 | 136 | 1 |
1618966 | 1618966 | 2021-08-15 | Taliaferro | Georgia | 13265 | 136 | 3 |
1615459 | 1615459 | 2021-08-14 | Dolores | Colorado | 8033 | 136 | 1 |
1615718 | 1615718 | 2021-08-14 | Taliaferro | Georgia | 13265 | 136 | 3 |
1612210 | 1612210 | 2021-08-13 | Dolores | Colorado | 8033 | 136 | 1 |
1612469 | 1612469 | 2021-08-13 | Taliaferro | Georgia | 13265 | 136 | 3 |
1608962 | 1608962 | 2021-08-12 | Dolores | Colorado | 8033 | 136 | 1 |
1609221 | 1609221 | 2021-08-12 | Taliaferro | Georgia | 13265 | 136 | 3 |
1608153 | 1608153 | 2021-08-11 | Foard | Texas | 48155 | 136 | 10 |
1530567 | 1530567 | 2021-07-18 | Garfield | Washington | 53023 | 136 | 6 |
1527320 | 1527320 | 2021-07-17 | Garfield | Washington | 53023 | 136 | 6 |
1524073 | 1524073 | 2021-07-16 | Garfield | Washington | 53023 | 136 | 6 |
1520825 | 1520825 | 2021-07-15 | Garfield | Washington | 53023 | 136 | 6 |
1517577 | 1517577 | 2021-07-14 | Garfield | Washington | 53023 | 136 | 6 |
1514330 | 1514330 | 2021-07-13 | Garfield | Washington | 53023 | 136 | 6 |
1511084 | 1511084 | 2021-07-12 | Garfield | Washington | 53023 | 136 | 5 |
1507837 | 1507837 | 2021-07-11 | Garfield | Washington | 53023 | 136 | 5 |
1504591 | 1504591 | 2021-07-10 | Garfield | Washington | 53023 | 136 | 5 |
1501345 | 1501345 | 2021-07-09 | Garfield | Washington | 53023 | 136 | 5 |
1498099 | 1498099 | 2021-07-08 | Garfield | Washington | 53023 | 136 | 5 |
1491441 | 1491441 | 2021-07-06 | Wayne | Utah | 49055 | 136 | 0 |
1387766 | 1387766 | 2021-06-04 | Wahkiakum | Washington | 53069 | 136 | 1 |
1253945 | 1253945 | 2021-04-24 | Maricao | Puerto Rico | 72093 | 136 | |
1233905 | 1233905 | 2021-04-18 | De Baca | New Mexico | 35011 | 136 | 1 |
1230657 | 1230657 | 2021-04-17 | De Baca | New Mexico | 35011 | 136 | 1 |
1227409 | 1227409 | 2021-04-16 | De Baca | New Mexico | 35011 | 136 | 1 |
1224161 | 1224161 | 2021-04-15 | De Baca | New Mexico | 35011 | 136 | 1 |
1220914 | 1220914 | 2021-04-14 | De Baca | New Mexico | 35011 | 136 | 1 |
1217666 | 1217666 | 2021-04-13 | De Baca | New Mexico | 35011 | 136 | 1 |
1214418 | 1214418 | 2021-04-12 | De Baca | New Mexico | 35011 | 136 | 1 |
1211171 | 1211171 | 2021-04-11 | De Baca | New Mexico | 35011 | 136 | 1 |
1207922 | 1207922 | 2021-04-10 | De Baca | New Mexico | 35011 | 136 | 1 |
1204674 | 1204674 | 2021-04-09 | De Baca | New Mexico | 35011 | 136 | 1 |
1201426 | 1201426 | 2021-04-08 | De Baca | New Mexico | 35011 | 136 | 1 |
1192947 | 1192947 | 2021-04-05 | San Juan | Washington | 53055 | 136 | 0 |
1176143 | 1176143 | 2021-03-31 | Sully | South Dakota | 46119 | 136 | 3 |
1172896 | 1172896 | 2021-03-30 | Sully | South Dakota | 46119 | 136 | 3 |
1169649 | 1169649 | 2021-03-29 | Sully | South Dakota | 46119 | 136 | 3 |
1166401 | 1166401 | 2021-03-28 | Sully | South Dakota | 46119 | 136 | 3 |
1163153 | 1163153 | 2021-03-27 | Sully | South Dakota | 46119 | 136 | 3 |
1158727 | 1158727 | 2021-03-26 | Cook | Minnesota | 27031 | 136 | 0 |
1159904 | 1159904 | 2021-03-26 | Sully | South Dakota | 46119 | 136 | 3 |
1131076 | 1131076 | 2021-03-17 | Grand Isle | Vermont | 50013 | 136 | 1 |
1127809 | 1127809 | 2021-03-16 | Rich | Utah | 49033 | 136 | 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);