ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,640 rows where cases = 79 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 161
- Nebraska 88
- Kentucky 86
- Virginia 74
- Georgia 61
- Illinois 58
- Michigan 56
- Iowa 54
- Missouri 51
- Alaska 50
- Colorado 49
- Kansas 48
- Indiana 46
- Minnesota 45
- Oklahoma 44
- Puerto Rico 43
- Ohio 41
- Montana 38
- Mississippi 35
- West Virginia 33
- Alabama 32
- New York 32
- Wisconsin 31
- Arkansas 30
- Pennsylvania 29
- North Carolina 27
- South Dakota 26
- North Dakota 25
- Tennessee 25
- Idaho 23
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501306 | 2501306 | 2022-05-13 | Loup | Nebraska | 31115 | 79 | 0 |
2498048 | 2498048 | 2022-05-12 | Loup | Nebraska | 31115 | 79 | 0 |
2494790 | 2494790 | 2022-05-11 | Loup | Nebraska | 31115 | 79 | 0 |
2248497 | 2248497 | 2022-02-24 | Kenedy | Texas | 48261 | 79 | 2 |
2245246 | 2245246 | 2022-02-23 | Kenedy | Texas | 48261 | 79 | 2 |
2101104 | 2101104 | 2022-01-10 | Loup | Nebraska | 31115 | 79 | 0 |
2006862 | 2006862 | 2021-12-12 | Thomas | Nebraska | 31171 | 79 | 1 |
2003611 | 2003611 | 2021-12-11 | Thomas | Nebraska | 31171 | 79 | 1 |
2000361 | 2000361 | 2021-12-10 | Thomas | Nebraska | 31171 | 79 | 1 |
1945407 | 1945407 | 2021-11-23 | Unknown | Northern Mariana Islands | 79 | 0 | |
1942156 | 1942156 | 2021-11-22 | Unknown | Northern Mariana Islands | 79 | 0 | |
1919057 | 1919057 | 2021-11-15 | Hayes | Nebraska | 31085 | 79 | 0 |
1906058 | 1906058 | 2021-11-11 | Hayes | Nebraska | 31085 | 79 | 0 |
1902804 | 1902804 | 2021-11-10 | Grant | Nebraska | 31075 | 79 | 4 |
1899554 | 1899554 | 2021-11-09 | Grant | Nebraska | 31075 | 79 | 4 |
1896304 | 1896304 | 2021-11-08 | Grant | Nebraska | 31075 | 79 | 4 |
1870317 | 1870317 | 2021-10-31 | Hooker | Nebraska | 31091 | 79 | 3 |
1867068 | 1867068 | 2021-10-30 | Hooker | Nebraska | 31091 | 79 | 3 |
1863819 | 1863819 | 2021-10-29 | Hooker | Nebraska | 31091 | 79 | 3 |
1860570 | 1860570 | 2021-10-28 | Hooker | Nebraska | 31091 | 79 | 3 |
1857321 | 1857321 | 2021-10-27 | Hooker | Nebraska | 31091 | 79 | 3 |
1725272 | 1725272 | 2021-09-16 | Daggett | Utah | 49009 | 79 | 0 |
1722023 | 1722023 | 2021-09-15 | Daggett | Utah | 49009 | 79 | 0 |
1718775 | 1718775 | 2021-09-14 | Daggett | Utah | 49009 | 79 | 0 |
1699226 | 1699226 | 2021-09-08 | Roberts | Texas | 48393 | 79 | 1 |
1695978 | 1695978 | 2021-09-07 | Roberts | Texas | 48393 | 79 | 1 |
1692730 | 1692730 | 2021-09-06 | Roberts | Texas | 48393 | 79 | 1 |
1689481 | 1689481 | 2021-09-05 | Roberts | Texas | 48393 | 79 | 1 |
1686231 | 1686231 | 2021-09-04 | Roberts | Texas | 48393 | 79 | 1 |
1682980 | 1682980 | 2021-09-03 | Roberts | Texas | 48393 | 79 | 1 |
1650528 | 1650528 | 2021-08-24 | Throckmorton | Texas | 48447 | 79 | 5 |
1621785 | 1621785 | 2021-08-16 | Wrangell City and Borough | Alaska | 2275 | 79 | 0 |
1560201 | 1560201 | 2021-07-28 | Sierra | California | 6091 | 79 | 0 |
1556954 | 1556954 | 2021-07-27 | Sierra | California | 6091 | 79 | 0 |
1553707 | 1553707 | 2021-07-26 | Sierra | California | 6091 | 79 | 0 |
1549826 | 1549826 | 2021-07-24 | Terrell | Texas | 48443 | 79 | 2 |
1274558 | 1274558 | 2021-05-01 | Dolores | Colorado | 8033 | 79 | 0 |
1259691 | 1259691 | 2021-04-26 | Garfield | Montana | 30033 | 79 | 2 |
1256444 | 1256444 | 2021-04-25 | Garfield | Montana | 30033 | 79 | 2 |
1257659 | 1257659 | 2021-04-25 | Terrell | Texas | 48443 | 79 | 2 |
1253197 | 1253197 | 2021-04-24 | Garfield | Montana | 30033 | 79 | 2 |
1249950 | 1249950 | 2021-04-23 | Garfield | Montana | 30033 | 79 | 2 |
1246703 | 1246703 | 2021-04-22 | Garfield | Montana | 30033 | 79 | 2 |
1243456 | 1243456 | 2021-04-21 | Garfield | Montana | 30033 | 79 | 2 |
1240209 | 1240209 | 2021-04-20 | Garfield | Montana | 30033 | 79 | 2 |
1235419 | 1235419 | 2021-04-19 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1232171 | 1232171 | 2021-04-18 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1228923 | 1228923 | 2021-04-17 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1225675 | 1225675 | 2021-04-16 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1222428 | 1222428 | 2021-04-15 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1219180 | 1219180 | 2021-04-14 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1220820 | 1220820 | 2021-04-14 | Logan | Nebraska | 31113 | 79 | 0 |
1215932 | 1215932 | 2021-04-13 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1217572 | 1217572 | 2021-04-13 | Logan | Nebraska | 31113 | 79 | 0 |
1212685 | 1212685 | 2021-04-12 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1214325 | 1214325 | 2021-04-12 | Logan | Nebraska | 31113 | 79 | 0 |
1209436 | 1209436 | 2021-04-11 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1211077 | 1211077 | 2021-04-11 | Logan | Nebraska | 31113 | 79 | 0 |
1206188 | 1206188 | 2021-04-10 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1207828 | 1207828 | 2021-04-10 | Logan | Nebraska | 31113 | 79 | 0 |
1202940 | 1202940 | 2021-04-09 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1204580 | 1204580 | 2021-04-09 | Logan | Nebraska | 31113 | 79 | 0 |
1199692 | 1199692 | 2021-04-08 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1201332 | 1201332 | 2021-04-08 | Logan | Nebraska | 31113 | 79 | 0 |
1196443 | 1196443 | 2021-04-07 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1198083 | 1198083 | 2021-04-07 | Logan | Nebraska | 31113 | 79 | 0 |
1193195 | 1193195 | 2021-04-06 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1194834 | 1194834 | 2021-04-06 | Logan | Nebraska | 31113 | 79 | 0 |
1189945 | 1189945 | 2021-04-05 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1191585 | 1191585 | 2021-04-05 | Logan | Nebraska | 31113 | 79 | 0 |
1186698 | 1186698 | 2021-04-04 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1188337 | 1188337 | 2021-04-04 | Logan | Nebraska | 31113 | 79 | 0 |
1183451 | 1183451 | 2021-04-03 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1185090 | 1185090 | 2021-04-03 | Logan | Nebraska | 31113 | 79 | 0 |
1180204 | 1180204 | 2021-04-02 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1181844 | 1181844 | 2021-04-02 | Logan | Nebraska | 31113 | 79 | 0 |
1176957 | 1176957 | 2021-04-01 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 79 | 1 |
1175350 | 1175350 | 2021-03-31 | Logan | Nebraska | 31113 | 79 | 0 |
1172103 | 1172103 | 2021-03-30 | Logan | Nebraska | 31113 | 79 | 0 |
1168855 | 1168855 | 2021-03-29 | Logan | Nebraska | 31113 | 79 | 0 |
1165607 | 1165607 | 2021-03-28 | Logan | Nebraska | 31113 | 79 | 0 |
1159111 | 1159111 | 2021-03-26 | Logan | Nebraska | 31113 | 79 | 0 |
1147716 | 1147716 | 2021-03-23 | Denali Borough | Alaska | 2068 | 79 | 0 |
1146123 | 1146123 | 2021-03-22 | Logan | Nebraska | 31113 | 79 | 0 |
1142876 | 1142876 | 2021-03-21 | Logan | Nebraska | 31113 | 79 | 0 |
1139629 | 1139629 | 2021-03-20 | Logan | Nebraska | 31113 | 79 | 0 |
1126642 | 1126642 | 2021-03-16 | Logan | Nebraska | 31113 | 79 | 0 |
1101700 | 1101700 | 2021-03-08 | Kent | Texas | 48263 | 79 | 1 |
1098454 | 1098454 | 2021-03-07 | Kent | Texas | 48263 | 79 | 1 |
1095206 | 1095206 | 2021-03-06 | Kent | Texas | 48263 | 79 | 1 |
1091960 | 1091960 | 2021-03-05 | Kent | Texas | 48263 | 79 | 1 |
1088714 | 1088714 | 2021-03-04 | Kent | Texas | 48263 | 79 | 1 |
1073064 | 1073064 | 2021-02-28 | Petersburg Borough | Alaska | 2195 | 79 | 0 |
1069818 | 1069818 | 2021-02-27 | Petersburg Borough | Alaska | 2195 | 79 | 0 |
1066573 | 1066573 | 2021-02-26 | Petersburg Borough | Alaska | 2195 | 79 | 0 |
1040059 | 1040059 | 2021-02-17 | McMullen | Texas | 48311 | 79 | 4 |
1036814 | 1036814 | 2021-02-16 | McMullen | Texas | 48311 | 79 | 4 |
1033569 | 1033569 | 2021-02-15 | McMullen | Texas | 48311 | 79 | 4 |
1029353 | 1029353 | 2021-02-14 | Catron | New Mexico | 35003 | 79 | 5 |
1030323 | 1030323 | 2021-02-14 | McMullen | Texas | 48311 | 79 | 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);