ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,590 rows where cases = 53 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
- Nebraska 217
- Texas 194
- North Dakota 121
- Kansas 105
- Montana 103
- Oregon 103
- Idaho 102
- Kentucky 92
- Virginia 92
- Missouri 83
- Georgia 79
- Minnesota 78
- West Virginia 69
- Colorado 64
- Iowa 58
- Puerto Rico 58
- Tennessee 57
- Michigan 56
- Arkansas 55
- Ohio 54
- Illinois 52
- Indiana 51
- Alabama 48
- Northern Mariana Islands 43
- Pennsylvania 43
- Mississippi 40
- South Dakota 39
- Maine 38
- New Mexico 38
- Oklahoma 37
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2485137 | 2485137 | 2022-05-08 | Unknown | New Mexico | 53 | 0 | |
2481879 | 2481879 | 2022-05-07 | Unknown | New Mexico | 53 | 7 | |
2478621 | 2478621 | 2022-05-06 | Unknown | New Mexico | 53 | 7 | |
2475363 | 2475363 | 2022-05-05 | Unknown | New Mexico | 53 | 0 | |
2472106 | 2472106 | 2022-05-04 | Unknown | New Mexico | 53 | 0 | |
2266131 | 2266131 | 2022-03-02 | Unknown | Iowa | 53 | 0 | |
2085760 | 2085760 | 2022-01-05 | Borden | Texas | 48033 | 53 | 2 |
1925892 | 1925892 | 2021-11-17 | Slope | North Dakota | 38087 | 53 | 0 |
1922643 | 1922643 | 2021-11-16 | Slope | North Dakota | 38087 | 53 | 0 |
1919393 | 1919393 | 2021-11-15 | Slope | North Dakota | 38087 | 53 | 0 |
1920265 | 1920265 | 2021-11-15 | Unknown | Vermont | 53 | 0 | |
1916143 | 1916143 | 2021-11-14 | Slope | North Dakota | 38087 | 53 | 0 |
1824786 | 1824786 | 2021-10-17 | Banner | Nebraska | 31007 | 53 | 0 |
1821537 | 1821537 | 2021-10-16 | Banner | Nebraska | 31007 | 53 | 0 |
1818288 | 1818288 | 2021-10-15 | Banner | Nebraska | 31007 | 53 | 0 |
1781147 | 1781147 | 2021-10-04 | Hinsdale | Colorado | 8053 | 53 | 0 |
1777897 | 1777897 | 2021-10-03 | Hinsdale | Colorado | 8053 | 53 | 0 |
1774647 | 1774647 | 2021-10-02 | Hinsdale | Colorado | 8053 | 53 | 0 |
1771397 | 1771397 | 2021-10-01 | Hinsdale | Colorado | 8053 | 53 | 0 |
1768148 | 1768148 | 2021-09-30 | Hinsdale | Colorado | 8053 | 53 | 0 |
1764899 | 1764899 | 2021-09-29 | Hinsdale | Colorado | 8053 | 53 | 0 |
1761650 | 1761650 | 2021-09-28 | Hinsdale | Colorado | 8053 | 53 | 0 |
1763106 | 1763106 | 2021-09-28 | Loup | Nebraska | 31115 | 53 | 0 |
1758402 | 1758402 | 2021-09-27 | Hinsdale | Colorado | 8053 | 53 | 0 |
1759837 | 1759837 | 2021-09-27 | Grant | Nebraska | 31075 | 53 | 4 |
1755154 | 1755154 | 2021-09-26 | Hinsdale | Colorado | 8053 | 53 | 0 |
1751906 | 1751906 | 2021-09-25 | Hinsdale | Colorado | 8053 | 53 | 0 |
1748657 | 1748657 | 2021-09-24 | Hinsdale | Colorado | 8053 | 53 | 0 |
1745407 | 1745407 | 2021-09-23 | Hinsdale | Colorado | 8053 | 53 | 0 |
1746898 | 1746898 | 2021-09-23 | Wheeler | Nebraska | 31183 | 53 | 0 |
1731244 | 1731244 | 2021-09-18 | Culebra | Puerto Rico | 72049 | 53 | |
1727994 | 1727994 | 2021-09-17 | Culebra | Puerto Rico | 72049 | 53 | |
1618520 | 1618520 | 2021-08-15 | Haines Borough | Alaska | 2100 | 53 | 0 |
1615272 | 1615272 | 2021-08-14 | Haines Borough | Alaska | 2100 | 53 | 0 |
1612023 | 1612023 | 2021-08-13 | Haines Borough | Alaska | 2100 | 53 | 0 |
1608776 | 1608776 | 2021-08-12 | Haines Borough | Alaska | 2100 | 53 | 0 |
1604465 | 1604465 | 2021-08-10 | Wheeler | Oregon | 41069 | 53 | 1 |
1601216 | 1601216 | 2021-08-09 | Wheeler | Oregon | 41069 | 53 | 1 |
1597968 | 1597968 | 2021-08-08 | Wheeler | Oregon | 41069 | 53 | 1 |
1594719 | 1594719 | 2021-08-07 | Wheeler | Oregon | 41069 | 53 | 1 |
1591470 | 1591470 | 2021-08-06 | Wheeler | Oregon | 41069 | 53 | 1 |
1438326 | 1438326 | 2021-06-20 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1435079 | 1435079 | 2021-06-19 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1431832 | 1431832 | 2021-06-18 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1428587 | 1428587 | 2021-06-17 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1425342 | 1425342 | 2021-06-16 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1422094 | 1422094 | 2021-06-15 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1418849 | 1418849 | 2021-06-14 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1415604 | 1415604 | 2021-06-13 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1412358 | 1412358 | 2021-06-12 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1409113 | 1409113 | 2021-06-11 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1405868 | 1405868 | 2021-06-10 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1402622 | 1402622 | 2021-06-09 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1399377 | 1399377 | 2021-06-08 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1396131 | 1396131 | 2021-06-07 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1392885 | 1392885 | 2021-06-06 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1389640 | 1389640 | 2021-06-05 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1390800 | 1390800 | 2021-06-05 | Daggett | Utah | 49009 | 53 | 0 |
1386395 | 1386395 | 2021-06-04 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1387555 | 1387555 | 2021-06-04 | Daggett | Utah | 49009 | 53 | 0 |
1383150 | 1383150 | 2021-06-03 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1379904 | 1379904 | 2021-06-02 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1376659 | 1376659 | 2021-06-01 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1373413 | 1373413 | 2021-05-31 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1370168 | 1370168 | 2021-05-30 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1366922 | 1366922 | 2021-05-29 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1363676 | 1363676 | 2021-05-28 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1360463 | 1360463 | 2021-05-27 | Thomas | Nebraska | 31171 | 53 | 1 |
1357217 | 1357217 | 2021-05-26 | Thomas | Nebraska | 31171 | 53 | 1 |
1353971 | 1353971 | 2021-05-25 | Thomas | Nebraska | 31171 | 53 | 1 |
1350725 | 1350725 | 2021-05-24 | Thomas | Nebraska | 31171 | 53 | 1 |
1347479 | 1347479 | 2021-05-23 | Thomas | Nebraska | 31171 | 53 | 1 |
1344231 | 1344231 | 2021-05-22 | Thomas | Nebraska | 31171 | 53 | 1 |
1340983 | 1340983 | 2021-05-21 | Thomas | Nebraska | 31171 | 53 | 1 |
1337735 | 1337735 | 2021-05-20 | Thomas | Nebraska | 31171 | 53 | 1 |
1334488 | 1334488 | 2021-05-19 | Thomas | Nebraska | 31171 | 53 | 1 |
1331241 | 1331241 | 2021-05-18 | Thomas | Nebraska | 31171 | 53 | 1 |
1327994 | 1327994 | 2021-05-17 | Thomas | Nebraska | 31171 | 53 | 1 |
1324714 | 1324714 | 2021-05-16 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1324748 | 1324748 | 2021-05-16 | Thomas | Nebraska | 31171 | 53 | 1 |
1321468 | 1321468 | 2021-05-15 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1321502 | 1321502 | 2021-05-15 | Thomas | Nebraska | 31171 | 53 | 1 |
1318222 | 1318222 | 2021-05-14 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1318256 | 1318256 | 2021-05-14 | Thomas | Nebraska | 31171 | 53 | 1 |
1314974 | 1314974 | 2021-05-13 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1315008 | 1315008 | 2021-05-13 | Thomas | Nebraska | 31171 | 53 | 1 |
1311728 | 1311728 | 2021-05-12 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1311762 | 1311762 | 2021-05-12 | Thomas | Nebraska | 31171 | 53 | 1 |
1308481 | 1308481 | 2021-05-11 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1308515 | 1308515 | 2021-05-11 | Thomas | Nebraska | 31171 | 53 | 1 |
1305235 | 1305235 | 2021-05-10 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1305269 | 1305269 | 2021-05-10 | Thomas | Nebraska | 31171 | 53 | 1 |
1305284 | 1305284 | 2021-05-10 | Eureka | Nevada | 32011 | 53 | 0 |
1300361 | 1300361 | 2021-05-09 | Wrangell City and Borough | Alaska | 2275 | 53 | 0 |
1301989 | 1301989 | 2021-05-09 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1302023 | 1302023 | 2021-05-09 | Thomas | Nebraska | 31171 | 53 | 1 |
1302038 | 1302038 | 2021-05-09 | Eureka | Nevada | 32011 | 53 | 0 |
1297114 | 1297114 | 2021-05-08 | Wrangell City and Borough | Alaska | 2275 | 53 | 0 |
1298741 | 1298741 | 2021-05-08 | Keya Paha | Nebraska | 31103 | 53 | 0 |
1298775 | 1298775 | 2021-05-08 | Thomas | Nebraska | 31171 | 53 | 1 |
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);