ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,649 rows where cases = 40 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 195
- Texas 163
- Kansas 129
- West Virginia 112
- Georgia 111
- Illinois 107
- Kentucky 104
- South Dakota 87
- Puerto Rico 81
- Missouri 76
- Oklahoma 76
- Virginia 75
- Iowa 74
- Ohio 70
- Michigan 64
- Indiana 63
- Idaho 61
- Wisconsin 61
- Montana 60
- Arkansas 57
- Minnesota 54
- Colorado 53
- Tennessee 53
- Alabama 51
- North Carolina 48
- Pennsylvania 44
- Mississippi 41
- North Dakota 41
- Alaska 39
- California 37
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2334435 | 2334435 | 2022-03-23 | Unknown | Iowa | 40 | 0 | |
2288898 | 2288898 | 2022-03-09 | Unknown | Iowa | 40 | 0 | |
2249377 | 2249377 | 2022-02-25 | Unknown | Florida | 40 | 888 | |
2228995 | 2228995 | 2022-02-18 | King | Texas | 48269 | 40 | 0 |
2225744 | 2225744 | 2022-02-17 | King | Texas | 48269 | 40 | 0 |
2222493 | 2222493 | 2022-02-16 | King | Texas | 48269 | 40 | 0 |
2219242 | 2219242 | 2022-02-15 | King | Texas | 48269 | 40 | 0 |
2215991 | 2215991 | 2022-02-14 | King | Texas | 48269 | 40 | 0 |
2212740 | 2212740 | 2022-02-13 | King | Texas | 48269 | 40 | 0 |
2209487 | 2209487 | 2022-02-12 | King | Texas | 48269 | 40 | 0 |
2206234 | 2206234 | 2022-02-11 | King | Texas | 48269 | 40 | 0 |
2202981 | 2202981 | 2022-02-10 | King | Texas | 48269 | 40 | 0 |
2199727 | 2199727 | 2022-02-09 | King | Texas | 48269 | 40 | 0 |
2196473 | 2196473 | 2022-02-08 | King | Texas | 48269 | 40 | 0 |
2193219 | 2193219 | 2022-02-07 | King | Texas | 48269 | 40 | 0 |
2189965 | 2189965 | 2022-02-06 | King | Texas | 48269 | 40 | 0 |
2186712 | 2186712 | 2022-02-05 | King | Texas | 48269 | 40 | 0 |
2183460 | 2183460 | 2022-02-04 | King | Texas | 48269 | 40 | 0 |
2180208 | 2180208 | 2022-02-03 | King | Texas | 48269 | 40 | 0 |
2176957 | 2176957 | 2022-02-02 | King | Texas | 48269 | 40 | 0 |
2173703 | 2173703 | 2022-02-01 | King | Texas | 48269 | 40 | 0 |
2092397 | 2092397 | 2022-01-07 | Loving | Texas | 48301 | 40 | 0 |
1908480 | 1908480 | 2021-11-12 | Unknown | Iowa | 40 | 0 | |
1905231 | 1905231 | 2021-11-11 | Unknown | Iowa | 40 | 0 | |
1901981 | 1901981 | 2021-11-10 | Unknown | Iowa | 40 | 0 | |
1902771 | 1902771 | 2021-11-10 | Blaine | Nebraska | 31009 | 40 | 1 |
1899521 | 1899521 | 2021-11-09 | Blaine | Nebraska | 31009 | 40 | 1 |
1896271 | 1896271 | 2021-11-08 | Blaine | Nebraska | 31009 | 40 | 1 |
1893021 | 1893021 | 2021-11-07 | Blaine | Nebraska | 31009 | 40 | 1 |
1889771 | 1889771 | 2021-11-06 | Blaine | Nebraska | 31009 | 40 | 1 |
1886521 | 1886521 | 2021-11-05 | Blaine | Nebraska | 31009 | 40 | 1 |
1883272 | 1883272 | 2021-11-04 | Blaine | Nebraska | 31009 | 40 | 1 |
1880023 | 1880023 | 2021-11-03 | Blaine | Nebraska | 31009 | 40 | 1 |
1840242 | 1840242 | 2021-10-22 | Unknown | Iowa | 40 | 0 | |
1836993 | 1836993 | 2021-10-21 | Unknown | Iowa | 40 | 0 | |
1833744 | 1833744 | 2021-10-20 | Unknown | Iowa | 40 | 0 | |
1832530 | 1832530 | 2021-10-19 | Unknown | Vermont | 40 | 0 | |
1819534 | 1819534 | 2021-10-15 | Unknown | Vermont | 40 | 0 | |
1792670 | 1792670 | 2021-10-07 | Slope | North Dakota | 38087 | 40 | 0 |
1644704 | 1644704 | 2021-08-23 | Hinsdale | Colorado | 8053 | 40 | 0 |
1641454 | 1641454 | 2021-08-22 | Hinsdale | Colorado | 8053 | 40 | 0 |
1638204 | 1638204 | 2021-08-21 | Hinsdale | Colorado | 8053 | 40 | 0 |
1634954 | 1634954 | 2021-08-20 | Hinsdale | Colorado | 8053 | 40 | 0 |
1621781 | 1621781 | 2021-08-16 | Skagway Municipality | Alaska | 2230 | 40 | 0 |
1542254 | 1542254 | 2021-07-22 | Esmeralda | Nevada | 32009 | 40 | 0 |
1539007 | 1539007 | 2021-07-21 | Esmeralda | Nevada | 32009 | 40 | 0 |
1535760 | 1535760 | 2021-07-20 | Esmeralda | Nevada | 32009 | 40 | 0 |
1532512 | 1532512 | 2021-07-19 | Esmeralda | Nevada | 32009 | 40 | 0 |
1529265 | 1529265 | 2021-07-18 | Esmeralda | Nevada | 32009 | 40 | 0 |
1526018 | 1526018 | 2021-07-17 | Esmeralda | Nevada | 32009 | 40 | 0 |
1522771 | 1522771 | 2021-07-16 | Esmeralda | Nevada | 32009 | 40 | 0 |
1519522 | 1519522 | 2021-07-15 | Esmeralda | Nevada | 32009 | 40 | 0 |
1516275 | 1516275 | 2021-07-14 | Esmeralda | Nevada | 32009 | 40 | 0 |
1334440 | 1334440 | 2021-05-19 | Grant | Nebraska | 31075 | 40 | 4 |
1331193 | 1331193 | 2021-05-18 | Grant | Nebraska | 31075 | 40 | 4 |
1327946 | 1327946 | 2021-05-17 | Grant | Nebraska | 31075 | 40 | 4 |
1266282 | 1266282 | 2021-04-28 | Loup | Nebraska | 31115 | 40 | 0 |
1263035 | 1263035 | 2021-04-27 | Loup | Nebraska | 31115 | 40 | 0 |
1259788 | 1259788 | 2021-04-26 | Loup | Nebraska | 31115 | 40 | 0 |
1256541 | 1256541 | 2021-04-25 | Loup | Nebraska | 31115 | 40 | 0 |
1253294 | 1253294 | 2021-04-24 | Loup | Nebraska | 31115 | 40 | 0 |
1250047 | 1250047 | 2021-04-23 | Loup | Nebraska | 31115 | 40 | 0 |
1246800 | 1246800 | 2021-04-22 | Loup | Nebraska | 31115 | 40 | 0 |
1243553 | 1243553 | 2021-04-21 | Loup | Nebraska | 31115 | 40 | 0 |
1240306 | 1240306 | 2021-04-20 | Loup | Nebraska | 31115 | 40 | 0 |
1237059 | 1237059 | 2021-04-19 | Loup | Nebraska | 31115 | 40 | 0 |
1233812 | 1233812 | 2021-04-18 | Loup | Nebraska | 31115 | 40 | 0 |
1230564 | 1230564 | 2021-04-17 | Loup | Nebraska | 31115 | 40 | 0 |
1227316 | 1227316 | 2021-04-16 | Loup | Nebraska | 31115 | 40 | 0 |
1224068 | 1224068 | 2021-04-15 | Loup | Nebraska | 31115 | 40 | 0 |
1220821 | 1220821 | 2021-04-14 | Loup | Nebraska | 31115 | 40 | 0 |
1215938 | 1215938 | 2021-04-13 | Wrangell City and Borough | Alaska | 2275 | 40 | 0 |
1217573 | 1217573 | 2021-04-13 | Loup | Nebraska | 31115 | 40 | 0 |
1214326 | 1214326 | 2021-04-12 | Loup | Nebraska | 31115 | 40 | 0 |
1211078 | 1211078 | 2021-04-11 | Loup | Nebraska | 31115 | 40 | 0 |
1207829 | 1207829 | 2021-04-10 | Loup | Nebraska | 31115 | 40 | 0 |
1204581 | 1204581 | 2021-04-09 | Loup | Nebraska | 31115 | 40 | 0 |
1201333 | 1201333 | 2021-04-08 | Loup | Nebraska | 31115 | 40 | 0 |
1198084 | 1198084 | 2021-04-07 | Loup | Nebraska | 31115 | 40 | 0 |
1194835 | 1194835 | 2021-04-06 | Loup | Nebraska | 31115 | 40 | 0 |
1191586 | 1191586 | 2021-04-05 | Loup | Nebraska | 31115 | 40 | 0 |
1188338 | 1188338 | 2021-04-04 | Loup | Nebraska | 31115 | 40 | 0 |
1185091 | 1185091 | 2021-04-03 | Loup | Nebraska | 31115 | 40 | 0 |
1181845 | 1181845 | 2021-04-02 | Loup | Nebraska | 31115 | 40 | 0 |
1178598 | 1178598 | 2021-04-01 | Loup | Nebraska | 31115 | 40 | 0 |
1175351 | 1175351 | 2021-03-31 | Loup | Nebraska | 31115 | 40 | 0 |
1172104 | 1172104 | 2021-03-30 | Loup | Nebraska | 31115 | 40 | 0 |
1168856 | 1168856 | 2021-03-29 | Loup | Nebraska | 31115 | 40 | 0 |
1165608 | 1165608 | 2021-03-28 | Loup | Nebraska | 31115 | 40 | 0 |
1162360 | 1162360 | 2021-03-27 | Loup | Nebraska | 31115 | 40 | 0 |
1159112 | 1159112 | 2021-03-26 | Loup | Nebraska | 31115 | 40 | 0 |
1155865 | 1155865 | 2021-03-25 | Loup | Nebraska | 31115 | 40 | 0 |
1152618 | 1152618 | 2021-03-24 | Loup | Nebraska | 31115 | 40 | 0 |
1149371 | 1149371 | 2021-03-23 | Loup | Nebraska | 31115 | 40 | 0 |
1146124 | 1146124 | 2021-03-22 | Loup | Nebraska | 31115 | 40 | 0 |
1142877 | 1142877 | 2021-03-21 | Loup | Nebraska | 31115 | 40 | 0 |
1139630 | 1139630 | 2021-03-20 | Loup | Nebraska | 31115 | 40 | 0 |
1136384 | 1136384 | 2021-03-19 | Loup | Nebraska | 31115 | 40 | 0 |
1133138 | 1133138 | 2021-03-18 | Loup | Nebraska | 31115 | 40 | 0 |
1129890 | 1129890 | 2021-03-17 | Loup | Nebraska | 31115 | 40 | 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);