ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,154 rows where cases = 139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 121
- Montana 61
- Georgia 59
- Missouri 52
- Kentucky 50
- Iowa 46
- Virginia 45
- Nebraska 39
- South Dakota 38
- New York 34
- Michigan 31
- Kansas 30
- Illinois 28
- Indiana 27
- Mississippi 27
- Ohio 27
- Wisconsin 27
- North Carolina 26
- Utah 25
- West Virginia 25
- Oregon 24
- Oklahoma 23
- North Dakota 22
- Pennsylvania 21
- Puerto Rico 21
- Arkansas 20
- Tennessee 20
- Colorado 19
- Louisiana 16
- Minnesota 16
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2432070 | 2432070 | 2022-04-22 | Unknown | Iowa | 139 | 0 | |
2428814 | 2428814 | 2022-04-21 | Unknown | Iowa | 139 | 0 | |
2259314 | 2259314 | 2022-02-28 | Camas | Idaho | 16025 | 139 | 2 |
2256063 | 2256063 | 2022-02-27 | Camas | Idaho | 16025 | 139 | 2 |
2252812 | 2252812 | 2022-02-26 | Camas | Idaho | 16025 | 139 | 2 |
2249561 | 2249561 | 2022-02-25 | Camas | Idaho | 16025 | 139 | 2 |
2218490 | 2218490 | 2022-02-15 | Billings | North Dakota | 38007 | 139 | 1 |
2211705 | 2211705 | 2022-02-13 | Logan | Nebraska | 31113 | 139 | 0 |
2208452 | 2208452 | 2022-02-12 | Logan | Nebraska | 31113 | 139 | 0 |
2205199 | 2205199 | 2022-02-11 | Logan | Nebraska | 31113 | 139 | 0 |
2201946 | 2201946 | 2022-02-10 | Logan | Nebraska | 31113 | 139 | 0 |
2198692 | 2198692 | 2022-02-09 | Logan | Nebraska | 31113 | 139 | 0 |
2195438 | 2195438 | 2022-02-08 | Logan | Nebraska | 31113 | 139 | 0 |
2192184 | 2192184 | 2022-02-07 | Logan | Nebraska | 31113 | 139 | 0 |
2186728 | 2186728 | 2022-02-05 | Loving | Texas | 48301 | 139 | 0 |
2179456 | 2179456 | 2022-02-03 | Billings | North Dakota | 38007 | 139 | 1 |
2175828 | 2175828 | 2022-02-02 | Golden Valley | Montana | 30037 | 139 | 5 |
2176205 | 2176205 | 2022-02-02 | Billings | North Dakota | 38007 | 139 | 1 |
2167322 | 2167322 | 2022-01-30 | Daggett | Utah | 49009 | 139 | 0 |
2164067 | 2164067 | 2022-01-29 | Daggett | Utah | 49009 | 139 | 0 |
2160812 | 2160812 | 2022-01-28 | Daggett | Utah | 49009 | 139 | 0 |
2124924 | 2124924 | 2022-01-17 | McMullen | Texas | 48311 | 139 | 8 |
2121672 | 2121672 | 2022-01-16 | McMullen | Texas | 48311 | 139 | 8 |
2118420 | 2118420 | 2022-01-15 | McMullen | Texas | 48311 | 139 | 8 |
2075627 | 2075627 | 2022-01-02 | Wheeler | Oregon | 41069 | 139 | 2 |
2072376 | 2072376 | 2022-01-01 | Wheeler | Oregon | 41069 | 139 | 2 |
2069125 | 2069125 | 2021-12-31 | Wheeler | Oregon | 41069 | 139 | 2 |
2065874 | 2065874 | 2021-12-30 | Wheeler | Oregon | 41069 | 139 | 2 |
2062624 | 2062624 | 2021-12-29 | Wheeler | Oregon | 41069 | 139 | 2 |
2059374 | 2059374 | 2021-12-28 | Wheeler | Oregon | 41069 | 139 | 2 |
1946194 | 1946194 | 2021-11-23 | Throckmorton | Texas | 48447 | 139 | 7 |
1942943 | 1942943 | 2021-11-22 | Throckmorton | Texas | 48447 | 139 | 7 |
1939693 | 1939693 | 2021-11-21 | Throckmorton | Texas | 48447 | 139 | 7 |
1936443 | 1936443 | 2021-11-20 | Throckmorton | Texas | 48447 | 139 | 7 |
1933193 | 1933193 | 2021-11-19 | Throckmorton | Texas | 48447 | 139 | 7 |
1929942 | 1929942 | 2021-11-18 | Throckmorton | Texas | 48447 | 139 | 7 |
1845948 | 1845948 | 2021-10-24 | Wrangell City and Borough | Alaska | 2275 | 139 | 0 |
1842698 | 1842698 | 2021-10-23 | Wrangell City and Borough | Alaska | 2275 | 139 | 0 |
1839449 | 1839449 | 2021-10-22 | Wrangell City and Borough | Alaska | 2275 | 139 | 0 |
1836200 | 1836200 | 2021-10-21 | Wrangell City and Borough | Alaska | 2275 | 139 | 0 |
1832951 | 1832951 | 2021-10-20 | Wrangell City and Borough | Alaska | 2275 | 139 | 0 |
1829702 | 1829702 | 2021-10-19 | Wrangell City and Borough | Alaska | 2275 | 139 | 0 |
1815002 | 1815002 | 2021-10-14 | Judith Basin | Montana | 30045 | 139 | 1 |
1811754 | 1811754 | 2021-10-13 | Judith Basin | Montana | 30045 | 139 | 1 |
1773173 | 1773173 | 2021-10-01 | Sheridan | North Dakota | 38083 | 139 | 3 |
1738099 | 1738099 | 2021-09-20 | Glasscock | Texas | 48173 | 139 | 3 |
1738282 | 1738282 | 2021-09-20 | Piute | Utah | 49031 | 139 | 2 |
1734849 | 1734849 | 2021-09-19 | Glasscock | Texas | 48173 | 139 | 3 |
1735032 | 1735032 | 2021-09-19 | Piute | Utah | 49031 | 139 | 2 |
1729120 | 1729120 | 2021-09-18 | Sierra | California | 6091 | 139 | 0 |
1731599 | 1731599 | 2021-09-18 | Glasscock | Texas | 48173 | 139 | 3 |
1731782 | 1731782 | 2021-09-18 | Piute | Utah | 49031 | 139 | 2 |
1728532 | 1728532 | 2021-09-17 | Piute | Utah | 49031 | 139 | 2 |
1724058 | 1724058 | 2021-09-16 | Wibaux | Montana | 30109 | 139 | 6 |
1720809 | 1720809 | 2021-09-15 | Wibaux | Montana | 30109 | 139 | 6 |
1717561 | 1717561 | 2021-09-14 | Wibaux | Montana | 30109 | 139 | 6 |
1686121 | 1686121 | 2021-09-04 | Glasscock | Texas | 48173 | 139 | 3 |
1669638 | 1669638 | 2021-08-30 | Campbell | South Dakota | 46021 | 139 | 4 |
1631506 | 1631506 | 2021-08-19 | Denali Borough | Alaska | 2068 | 139 | 0 |
1626577 | 1626577 | 2021-08-17 | Liberty | Montana | 30051 | 139 | 1 |
1604944 | 1604944 | 2021-08-10 | Irion | Texas | 48235 | 139 | 1 |
1533809 | 1533809 | 2021-07-19 | Columbia | Washington | 53013 | 139 | 6 |
1523909 | 1523909 | 2021-07-16 | Wayne | Utah | 49055 | 139 | 0 |
1520661 | 1520661 | 2021-07-15 | Wayne | Utah | 49055 | 139 | 0 |
1517413 | 1517413 | 2021-07-14 | Wayne | Utah | 49055 | 139 | 0 |
1514166 | 1514166 | 2021-07-13 | Wayne | Utah | 49055 | 139 | 0 |
1510920 | 1510920 | 2021-07-12 | Wayne | Utah | 49055 | 139 | 0 |
1403993 | 1403993 | 2021-06-09 | Wahkiakum | Washington | 53069 | 139 | 1 |
1400748 | 1400748 | 2021-06-08 | Wahkiakum | Washington | 53069 | 139 | 1 |
1263128 | 1263128 | 2021-04-27 | De Baca | New Mexico | 35011 | 139 | 1 |
1259881 | 1259881 | 2021-04-26 | De Baca | New Mexico | 35011 | 139 | 1 |
1240222 | 1240222 | 2021-04-20 | Meagher | Montana | 30059 | 139 | 7 |
1228109 | 1228109 | 2021-04-16 | Sully | South Dakota | 46119 | 139 | 3 |
1224861 | 1224861 | 2021-04-15 | Sully | South Dakota | 46119 | 139 | 3 |
1221614 | 1221614 | 2021-04-14 | Sully | South Dakota | 46119 | 139 | 3 |
1218366 | 1218366 | 2021-04-13 | Sully | South Dakota | 46119 | 139 | 3 |
1195754 | 1195754 | 2021-04-06 | Briscoe | Texas | 48045 | 139 | 5 |
1192506 | 1192506 | 2021-04-05 | Briscoe | Texas | 48045 | 139 | 5 |
1189257 | 1189257 | 2021-04-04 | Briscoe | Texas | 48045 | 139 | 5 |
1186010 | 1186010 | 2021-04-03 | Briscoe | Texas | 48045 | 139 | 5 |
1182763 | 1182763 | 2021-04-02 | Briscoe | Texas | 48045 | 139 | 5 |
1179516 | 1179516 | 2021-04-01 | Briscoe | Texas | 48045 | 139 | 5 |
1174966 | 1174966 | 2021-03-31 | Cook | Minnesota | 27031 | 139 | 0 |
1176269 | 1176269 | 2021-03-31 | Briscoe | Texas | 48045 | 139 | 5 |
1173022 | 1173022 | 2021-03-30 | Briscoe | Texas | 48045 | 139 | 5 |
1167671 | 1167671 | 2021-03-29 | Webster | Georgia | 13307 | 139 | 4 |
1169775 | 1169775 | 2021-03-29 | Briscoe | Texas | 48045 | 139 | 5 |
1164423 | 1164423 | 2021-03-28 | Webster | Georgia | 13307 | 139 | 4 |
1166527 | 1166527 | 2021-03-28 | Briscoe | Texas | 48045 | 139 | 5 |
1166775 | 1166775 | 2021-03-28 | Rich | Utah | 49033 | 139 | 0 |
1161175 | 1161175 | 2021-03-27 | Webster | Georgia | 13307 | 139 | 4 |
1163279 | 1163279 | 2021-03-27 | Briscoe | Texas | 48045 | 139 | 5 |
1163527 | 1163527 | 2021-03-27 | Rich | Utah | 49033 | 139 | 0 |
1157927 | 1157927 | 2021-03-26 | Webster | Georgia | 13307 | 139 | 4 |
1160030 | 1160030 | 2021-03-26 | Briscoe | Texas | 48045 | 139 | 5 |
1160278 | 1160278 | 2021-03-26 | Rich | Utah | 49033 | 139 | 0 |
1154680 | 1154680 | 2021-03-25 | Webster | Georgia | 13307 | 139 | 4 |
1156783 | 1156783 | 2021-03-25 | Briscoe | Texas | 48045 | 139 | 5 |
1157031 | 1157031 | 2021-03-25 | Rich | Utah | 49033 | 139 | 0 |
1151433 | 1151433 | 2021-03-24 | Webster | Georgia | 13307 | 139 | 4 |
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);