ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,709 rows where cases = 72 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 179
- Virginia 85
- Idaho 76
- Missouri 75
- Colorado 70
- Nebraska 65
- Georgia 63
- Kentucky 58
- Puerto Rico 57
- Iowa 56
- Pennsylvania 56
- Oklahoma 53
- Indiana 49
- Arkansas 46
- Kansas 44
- Illinois 40
- Minnesota 40
- North Carolina 37
- South Dakota 37
- Ohio 35
- Montana 33
- Tennessee 32
- Mississippi 30
- Alabama 28
- New York 28
- Michigan 27
- Oregon 26
- West Virginia 26
- Washington 25
- Wisconsin 24
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2257223 | 2257223 | 2022-02-27 | McPherson | Nebraska | 31117 | 72 | 1 |
2253972 | 2253972 | 2022-02-26 | McPherson | Nebraska | 31117 | 72 | 1 |
2249086 | 2249086 | 2022-02-25 | Unknown | American Samoa | 72 | 0 | |
2250721 | 2250721 | 2022-02-25 | McPherson | Nebraska | 31117 | 72 | 1 |
2245835 | 2245835 | 2022-02-24 | Unknown | American Samoa | 72 | 0 | |
2247470 | 2247470 | 2022-02-24 | McPherson | Nebraska | 31117 | 72 | 1 |
2244219 | 2244219 | 2022-02-23 | McPherson | Nebraska | 31117 | 72 | 1 |
2226620 | 2226620 | 2022-02-18 | Unknown | Florida | 72 | 1330 | |
2189030 | 2189030 | 2022-02-06 | Harding | New Mexico | 35021 | 72 | 4 |
2185777 | 2185777 | 2022-02-05 | Harding | New Mexico | 35021 | 72 | 4 |
2182525 | 2182525 | 2022-02-04 | Harding | New Mexico | 35021 | 72 | 4 |
2179273 | 2179273 | 2022-02-03 | Harding | New Mexico | 35021 | 72 | 4 |
2176021 | 2176021 | 2022-02-02 | Harding | New Mexico | 35021 | 72 | 4 |
2176953 | 2176953 | 2022-02-02 | Kenedy | Texas | 48261 | 72 | 2 |
2172768 | 2172768 | 2022-02-01 | Harding | New Mexico | 35021 | 72 | 4 |
2173699 | 2173699 | 2022-02-01 | Kenedy | Texas | 48261 | 72 | 2 |
2169515 | 2169515 | 2022-01-31 | Harding | New Mexico | 35021 | 72 | 4 |
2170447 | 2170447 | 2022-01-31 | Kenedy | Texas | 48261 | 72 | 2 |
2167193 | 2167193 | 2022-01-30 | Kenedy | Texas | 48261 | 72 | 2 |
2156423 | 2156423 | 2022-01-27 | Sioux | Nebraska | 31165 | 72 | 1 |
2153170 | 2153170 | 2022-01-26 | Sioux | Nebraska | 31165 | 72 | 1 |
2149918 | 2149918 | 2022-01-25 | Sioux | Nebraska | 31165 | 72 | 1 |
2146666 | 2146666 | 2022-01-24 | Sioux | Nebraska | 31165 | 72 | 1 |
2124913 | 2124913 | 2022-01-17 | Loving | Texas | 48301 | 72 | 0 |
2121661 | 2121661 | 2022-01-16 | Loving | Texas | 48301 | 72 | 0 |
2083390 | 2083390 | 2022-01-05 | Hinsdale | Colorado | 8053 | 72 | 0 |
2078342 | 2078342 | 2022-01-03 | Loup | Nebraska | 31115 | 72 | 0 |
1974358 | 1974358 | 2021-12-02 | Thomas | Nebraska | 31171 | 72 | 1 |
1971109 | 1971109 | 2021-12-01 | Thomas | Nebraska | 31171 | 72 | 1 |
1870323 | 1870323 | 2021-10-31 | Keya Paha | Nebraska | 31103 | 72 | 0 |
1831373 | 1831373 | 2021-10-19 | Wheeler | Nebraska | 31183 | 72 | 0 |
1828124 | 1828124 | 2021-10-18 | Wheeler | Nebraska | 31183 | 72 | 0 |
1773135 | 1773135 | 2021-10-01 | Billings | North Dakota | 38007 | 72 | 0 |
1709673 | 1709673 | 2021-09-12 | Jackson | Colorado | 8057 | 72 | 0 |
1706426 | 1706426 | 2021-09-11 | Jackson | Colorado | 8057 | 72 | 0 |
1703178 | 1703178 | 2021-09-10 | Jackson | Colorado | 8057 | 72 | 0 |
1699928 | 1699928 | 2021-09-09 | Jackson | Colorado | 8057 | 72 | 0 |
1696679 | 1696679 | 2021-09-08 | Jackson | Colorado | 8057 | 72 | 0 |
1693431 | 1693431 | 2021-09-07 | Jackson | Colorado | 8057 | 72 | 0 |
1690182 | 1690182 | 2021-09-06 | Jackson | Colorado | 8057 | 72 | 0 |
1670049 | 1670049 | 2021-08-30 | Daggett | Utah | 49009 | 72 | 0 |
1621768 | 1621768 | 2021-08-16 | Haines Borough | Alaska | 2100 | 72 | 0 |
1529752 | 1529752 | 2021-07-18 | Sherman | Oregon | 41055 | 72 | 2 |
1526505 | 1526505 | 2021-07-17 | Sherman | Oregon | 41055 | 72 | 2 |
1523258 | 1523258 | 2021-07-16 | Sherman | Oregon | 41055 | 72 | 2 |
1518323 | 1518323 | 2021-07-15 | Camas | Idaho | 16025 | 72 | 0 |
1520010 | 1520010 | 2021-07-15 | Sherman | Oregon | 41055 | 72 | 1 |
1515076 | 1515076 | 2021-07-14 | Camas | Idaho | 16025 | 72 | 0 |
1516762 | 1516762 | 2021-07-14 | Sherman | Oregon | 41055 | 72 | 1 |
1511830 | 1511830 | 2021-07-13 | Camas | Idaho | 16025 | 72 | 0 |
1513515 | 1513515 | 2021-07-13 | Sherman | Oregon | 41055 | 72 | 1 |
1508583 | 1508583 | 2021-07-12 | Camas | Idaho | 16025 | 72 | 0 |
1510269 | 1510269 | 2021-07-12 | Sherman | Oregon | 41055 | 72 | 1 |
1505337 | 1505337 | 2021-07-11 | Camas | Idaho | 16025 | 72 | 0 |
1507022 | 1507022 | 2021-07-11 | Sherman | Oregon | 41055 | 72 | 1 |
1502091 | 1502091 | 2021-07-10 | Camas | Idaho | 16025 | 72 | 0 |
1503776 | 1503776 | 2021-07-10 | Sherman | Oregon | 41055 | 72 | 1 |
1498845 | 1498845 | 2021-07-09 | Camas | Idaho | 16025 | 72 | 0 |
1500530 | 1500530 | 2021-07-09 | Sherman | Oregon | 41055 | 72 | 1 |
1495598 | 1495598 | 2021-07-08 | Camas | Idaho | 16025 | 72 | 0 |
1492352 | 1492352 | 2021-07-07 | Camas | Idaho | 16025 | 72 | 0 |
1489105 | 1489105 | 2021-07-06 | Camas | Idaho | 16025 | 72 | 0 |
1485858 | 1485858 | 2021-07-05 | Camas | Idaho | 16025 | 72 | 0 |
1482612 | 1482612 | 2021-07-04 | Camas | Idaho | 16025 | 72 | 0 |
1479365 | 1479365 | 2021-07-03 | Camas | Idaho | 16025 | 72 | 0 |
1476119 | 1476119 | 2021-07-02 | Camas | Idaho | 16025 | 72 | 0 |
1472873 | 1472873 | 2021-07-01 | Camas | Idaho | 16025 | 72 | 0 |
1469627 | 1469627 | 2021-06-30 | Camas | Idaho | 16025 | 72 | 0 |
1466382 | 1466382 | 2021-06-29 | Camas | Idaho | 16025 | 72 | 0 |
1463137 | 1463137 | 2021-06-28 | Camas | Idaho | 16025 | 72 | 0 |
1459892 | 1459892 | 2021-06-27 | Camas | Idaho | 16025 | 72 | 0 |
1456647 | 1456647 | 2021-06-26 | Camas | Idaho | 16025 | 72 | 0 |
1453402 | 1453402 | 2021-06-25 | Camas | Idaho | 16025 | 72 | 0 |
1450156 | 1450156 | 2021-06-24 | Camas | Idaho | 16025 | 72 | 0 |
1446911 | 1446911 | 2021-06-23 | Camas | Idaho | 16025 | 72 | 0 |
1443666 | 1443666 | 2021-06-22 | Camas | Idaho | 16025 | 72 | 0 |
1440421 | 1440421 | 2021-06-21 | Camas | Idaho | 16025 | 72 | 0 |
1437174 | 1437174 | 2021-06-20 | Camas | Idaho | 16025 | 72 | 0 |
1433927 | 1433927 | 2021-06-19 | Camas | Idaho | 16025 | 72 | 0 |
1430681 | 1430681 | 2021-06-18 | Camas | Idaho | 16025 | 72 | 0 |
1427436 | 1427436 | 2021-06-17 | Camas | Idaho | 16025 | 72 | 0 |
1424191 | 1424191 | 2021-06-16 | Camas | Idaho | 16025 | 72 | 0 |
1420943 | 1420943 | 2021-06-15 | Camas | Idaho | 16025 | 72 | 0 |
1417698 | 1417698 | 2021-06-14 | Camas | Idaho | 16025 | 72 | 0 |
1414452 | 1414452 | 2021-06-13 | Camas | Idaho | 16025 | 72 | 0 |
1411207 | 1411207 | 2021-06-12 | Camas | Idaho | 16025 | 72 | 0 |
1407962 | 1407962 | 2021-06-11 | Camas | Idaho | 16025 | 72 | 0 |
1409629 | 1409629 | 2021-06-11 | Gilliam | Oregon | 41021 | 72 | 1 |
1404716 | 1404716 | 2021-06-10 | Camas | Idaho | 16025 | 72 | 0 |
1406384 | 1406384 | 2021-06-10 | Gilliam | Oregon | 41021 | 72 | 1 |
1401471 | 1401471 | 2021-06-09 | Camas | Idaho | 16025 | 72 | 0 |
1403138 | 1403138 | 2021-06-09 | Gilliam | Oregon | 41021 | 72 | 1 |
1398226 | 1398226 | 2021-06-08 | Camas | Idaho | 16025 | 72 | 0 |
1394979 | 1394979 | 2021-06-07 | Camas | Idaho | 16025 | 72 | 0 |
1391734 | 1391734 | 2021-06-06 | Camas | Idaho | 16025 | 72 | 0 |
1388489 | 1388489 | 2021-06-05 | Camas | Idaho | 16025 | 72 | 0 |
1385244 | 1385244 | 2021-06-04 | Camas | Idaho | 16025 | 72 | 0 |
1381998 | 1381998 | 2021-06-03 | Camas | Idaho | 16025 | 72 | 0 |
1378753 | 1378753 | 2021-06-02 | Camas | Idaho | 16025 | 72 | 0 |
1375507 | 1375507 | 2021-06-01 | Camas | Idaho | 16025 | 72 | 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);