ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,110 rows where cases = 52 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 169
- Texas 159
- Georgia 110
- Kansas 91
- Colorado 81
- Kentucky 77
- Minnesota 76
- Tennessee 75
- Virginia 67
- Missouri 64
- Puerto Rico 58
- Michigan 57
- Illinois 52
- South Dakota 48
- Arkansas 47
- Iowa 47
- Mississippi 47
- Oklahoma 47
- Indiana 45
- Ohio 43
- North Carolina 42
- North Dakota 42
- Oregon 40
- West Virginia 39
- Louisiana 38
- Montana 37
- Wisconsin 37
- Idaho 36
- Alabama 33
- Washington 33
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497519 | 2497519 | 2022-05-12 | Unknown | Maine | 52 | 0 | |
2468850 | 2468850 | 2022-05-03 | Unknown | New Mexico | 52 | 0 | |
2082508 | 2082508 | 2022-01-04 | Borden | Texas | 48033 | 52 | 2 |
2062035 | 2062035 | 2021-12-29 | Blaine | Nebraska | 31009 | 52 | 1 |
2058786 | 2058786 | 2021-12-28 | Blaine | Nebraska | 31009 | 52 | 1 |
2037284 | 2037284 | 2021-12-21 | Unknown | Vermont | 52 | 0 | |
2006932 | 2006932 | 2021-12-12 | Harding | New Mexico | 35021 | 52 | 4 |
2003681 | 2003681 | 2021-12-11 | Harding | New Mexico | 35021 | 52 | 4 |
2000431 | 2000431 | 2021-12-10 | Harding | New Mexico | 35021 | 52 | 4 |
1997180 | 1997180 | 2021-12-09 | Harding | New Mexico | 35021 | 52 | 4 |
1993929 | 1993929 | 2021-12-08 | Harding | New Mexico | 35021 | 52 | 4 |
1990678 | 1990678 | 2021-12-07 | Harding | New Mexico | 35021 | 52 | 4 |
1991774 | 1991774 | 2021-12-07 | Unknown | Vermont | 52 | 0 | |
1912893 | 1912893 | 2021-11-13 | Slope | North Dakota | 38087 | 52 | 0 |
1909643 | 1909643 | 2021-11-12 | Slope | North Dakota | 38087 | 52 | 0 |
1906394 | 1906394 | 2021-11-11 | Slope | North Dakota | 38087 | 52 | 0 |
1903145 | 1903145 | 2021-11-10 | Slope | North Dakota | 38087 | 52 | 0 |
1899895 | 1899895 | 2021-11-09 | Slope | North Dakota | 38087 | 52 | 0 |
1824865 | 1824865 | 2021-10-17 | Sioux | Nebraska | 31165 | 52 | 1 |
1821616 | 1821616 | 2021-10-16 | Sioux | Nebraska | 31165 | 52 | 1 |
1818367 | 1818367 | 2021-10-15 | Sioux | Nebraska | 31165 | 52 | 1 |
1815039 | 1815039 | 2021-10-14 | Banner | Nebraska | 31007 | 52 | 0 |
1815118 | 1815118 | 2021-10-14 | Sioux | Nebraska | 31165 | 52 | 1 |
1811791 | 1811791 | 2021-10-13 | Banner | Nebraska | 31007 | 52 | 0 |
1811870 | 1811870 | 2021-10-13 | Sioux | Nebraska | 31165 | 52 | 1 |
1808621 | 1808621 | 2021-10-12 | Sioux | Nebraska | 31165 | 52 | 1 |
1805370 | 1805370 | 2021-10-11 | Sioux | Nebraska | 31165 | 52 | 1 |
1802121 | 1802121 | 2021-10-10 | Sioux | Nebraska | 31165 | 52 | 1 |
1798872 | 1798872 | 2021-10-09 | Sioux | Nebraska | 31165 | 52 | 1 |
1795623 | 1795623 | 2021-10-08 | Sioux | Nebraska | 31165 | 52 | 1 |
1792374 | 1792374 | 2021-10-07 | Sioux | Nebraska | 31165 | 52 | 1 |
1789125 | 1789125 | 2021-10-06 | Sioux | Nebraska | 31165 | 52 | 1 |
1742158 | 1742158 | 2021-09-22 | Hinsdale | Colorado | 8053 | 52 | 0 |
1743649 | 1743649 | 2021-09-22 | Wheeler | Nebraska | 31183 | 52 | 0 |
1738909 | 1738909 | 2021-09-21 | Hinsdale | Colorado | 8053 | 52 | 0 |
1722661 | 1722661 | 2021-09-16 | Hinsdale | Colorado | 8053 | 52 | 0 |
1716164 | 1716164 | 2021-09-14 | Hinsdale | Colorado | 8053 | 52 | 0 |
1693246 | 1693246 | 2021-09-07 | Skagway Municipality | Alaska | 2230 | 52 | 0 |
1673169 | 1673169 | 2021-08-31 | Kenedy | Texas | 48261 | 52 | 2 |
1669921 | 1669921 | 2021-08-30 | Kenedy | Texas | 48261 | 52 | 2 |
1666674 | 1666674 | 2021-08-29 | Kenedy | Texas | 48261 | 52 | 2 |
1384310 | 1384310 | 2021-06-03 | Daggett | Utah | 49009 | 52 | 0 |
1381064 | 1381064 | 2021-06-02 | Daggett | Utah | 49009 | 52 | 0 |
1280883 | 1280883 | 2021-05-03 | Wrangell City and Borough | Alaska | 2275 | 52 | 0 |
1281091 | 1281091 | 2021-05-03 | San Juan | Colorado | 8111 | 52 | 2 |
1277844 | 1277844 | 2021-05-02 | San Juan | Colorado | 8111 | 52 | 2 |
1250075 | 1250075 | 2021-04-23 | Thomas | Nebraska | 31171 | 52 | 1 |
1246828 | 1246828 | 2021-04-22 | Thomas | Nebraska | 31171 | 52 | 1 |
1243581 | 1243581 | 2021-04-21 | Thomas | Nebraska | 31171 | 52 | 1 |
1240334 | 1240334 | 2021-04-20 | Thomas | Nebraska | 31171 | 52 | 1 |
1237087 | 1237087 | 2021-04-19 | Thomas | Nebraska | 31171 | 52 | 1 |
1233840 | 1233840 | 2021-04-18 | Thomas | Nebraska | 31171 | 52 | 1 |
1230592 | 1230592 | 2021-04-17 | Thomas | Nebraska | 31171 | 52 | 1 |
1227344 | 1227344 | 2021-04-16 | Thomas | Nebraska | 31171 | 52 | 1 |
1224096 | 1224096 | 2021-04-15 | Thomas | Nebraska | 31171 | 52 | 1 |
1220849 | 1220849 | 2021-04-14 | Thomas | Nebraska | 31171 | 52 | 1 |
1217601 | 1217601 | 2021-04-13 | Thomas | Nebraska | 31171 | 52 | 1 |
1214354 | 1214354 | 2021-04-12 | Thomas | Nebraska | 31171 | 52 | 1 |
1211106 | 1211106 | 2021-04-11 | Thomas | Nebraska | 31171 | 52 | 1 |
1207857 | 1207857 | 2021-04-10 | Thomas | Nebraska | 31171 | 52 | 1 |
1204609 | 1204609 | 2021-04-09 | Thomas | Nebraska | 31171 | 52 | 1 |
1201361 | 1201361 | 2021-04-08 | Thomas | Nebraska | 31171 | 52 | 1 |
1198112 | 1198112 | 2021-04-07 | Thomas | Nebraska | 31171 | 52 | 1 |
1194863 | 1194863 | 2021-04-06 | Thomas | Nebraska | 31171 | 52 | 1 |
1190132 | 1190132 | 2021-04-05 | Jackson | Colorado | 8057 | 52 | 0 |
1191614 | 1191614 | 2021-04-05 | Thomas | Nebraska | 31171 | 52 | 1 |
1186885 | 1186885 | 2021-04-04 | Jackson | Colorado | 8057 | 52 | 0 |
1188366 | 1188366 | 2021-04-04 | Thomas | Nebraska | 31171 | 52 | 1 |
1183638 | 1183638 | 2021-04-03 | Jackson | Colorado | 8057 | 52 | 0 |
1185119 | 1185119 | 2021-04-03 | Thomas | Nebraska | 31171 | 52 | 1 |
1180391 | 1180391 | 2021-04-02 | Jackson | Colorado | 8057 | 52 | 0 |
1181873 | 1181873 | 2021-04-02 | Thomas | Nebraska | 31171 | 52 | 1 |
1177144 | 1177144 | 2021-04-01 | Jackson | Colorado | 8057 | 52 | 0 |
1178586 | 1178586 | 2021-04-01 | Hooker | Nebraska | 31091 | 52 | 2 |
1178626 | 1178626 | 2021-04-01 | Thomas | Nebraska | 31171 | 52 | 1 |
1173897 | 1173897 | 2021-03-31 | Jackson | Colorado | 8057 | 52 | 0 |
1175339 | 1175339 | 2021-03-31 | Hooker | Nebraska | 31091 | 52 | 2 |
1175379 | 1175379 | 2021-03-31 | Thomas | Nebraska | 31171 | 52 | 1 |
1170650 | 1170650 | 2021-03-30 | Jackson | Colorado | 8057 | 52 | 0 |
1172092 | 1172092 | 2021-03-30 | Hooker | Nebraska | 31091 | 52 | 2 |
1172132 | 1172132 | 2021-03-30 | Thomas | Nebraska | 31171 | 52 | 1 |
1167402 | 1167402 | 2021-03-29 | Jackson | Colorado | 8057 | 52 | 0 |
1168844 | 1168844 | 2021-03-29 | Hooker | Nebraska | 31091 | 52 | 2 |
1168884 | 1168884 | 2021-03-29 | Thomas | Nebraska | 31171 | 52 | 1 |
1164154 | 1164154 | 2021-03-28 | Jackson | Colorado | 8057 | 52 | 0 |
1165596 | 1165596 | 2021-03-28 | Hooker | Nebraska | 31091 | 52 | 2 |
1165636 | 1165636 | 2021-03-28 | Thomas | Nebraska | 31171 | 52 | 1 |
1160906 | 1160906 | 2021-03-27 | Jackson | Colorado | 8057 | 52 | 0 |
1162348 | 1162348 | 2021-03-27 | Hooker | Nebraska | 31091 | 52 | 2 |
1162388 | 1162388 | 2021-03-27 | Thomas | Nebraska | 31171 | 52 | 1 |
1157658 | 1157658 | 2021-03-26 | Jackson | Colorado | 8057 | 52 | 0 |
1159100 | 1159100 | 2021-03-26 | Hooker | Nebraska | 31091 | 52 | 2 |
1159140 | 1159140 | 2021-03-26 | Thomas | Nebraska | 31171 | 52 | 1 |
1154411 | 1154411 | 2021-03-25 | Jackson | Colorado | 8057 | 52 | 0 |
1155853 | 1155853 | 2021-03-25 | Hooker | Nebraska | 31091 | 52 | 2 |
1155893 | 1155893 | 2021-03-25 | Thomas | Nebraska | 31171 | 52 | 1 |
1151164 | 1151164 | 2021-03-24 | Jackson | Colorado | 8057 | 52 | 0 |
1152606 | 1152606 | 2021-03-24 | Hooker | Nebraska | 31091 | 52 | 2 |
1152646 | 1152646 | 2021-03-24 | Thomas | Nebraska | 31171 | 52 | 1 |
1147917 | 1147917 | 2021-03-23 | Jackson | Colorado | 8057 | 52 | 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);