ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: state, county, fips
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
416038 | 416038 | 2020-08-09 | Jefferson | Louisiana | 22051 | 15279 | 529 |
814188 | 814188 | 2020-12-10 | Linn | Iowa | 19113 | 15279 | 211 |
1045670 | 1045670 | 2021-02-19 | Alamance | North Carolina | 37001 | 15279 | 217 |
1108980 | 1108980 | 2021-03-11 | Pueblo | Colorado | 8101 | 15279 | 366 |
1302380 | 1302380 | 2021-05-09 | Medina | Ohio | 39103 | 15279 | 264 |
1335666 | 1335666 | 2021-05-19 | Arlington | Virginia | 51013 | 15279 | 256 |
1515188 | 1515188 | 2021-07-14 | Rock Island | Illinois | 17161 | 15279 | 372 |
1872572 | 1872572 | 2021-11-01 | Delaware | Indiana | 18035 | 15279 | 278 |
2013860 | 2013860 | 2021-12-14 | Linn | Oregon | 41043 | 15279 | 198 |
2055664 | 2055664 | 2021-12-27 | Hunterdon | New Jersey | 34019 | 15279 | 198 |
2382965 | 2382965 | 2022-04-07 | Coles | Illinois | 17029 | 15279 | 172 |
2426946 | 2426946 | 2022-04-20 | Armstrong | Pennsylvania | 42005 | 15279 | 342 |
2459522 | 2459522 | 2022-04-30 | Columbia | Pennsylvania | 42037 | 15279 | 246 |
632880 | 632880 | 2020-10-15 | Worcester | Massachusetts | 25027 | 15280 | 1137 |
771706 | 771706 | 2020-11-27 | Honolulu | Hawaii | 15003 | 15280 | 188 |
827451 | 827451 | 2020-12-14 | Caddo | Louisiana | 22017 | 15280 | 472 |
1130914 | 1130914 | 2021-03-17 | Kaufman | Texas | 48257 | 15280 | 232 |
1363841 | 1363841 | 2021-05-28 | Saratoga | New York | 36091 | 15280 | 167 |
1365071 | 1365071 | 2021-05-28 | Kanawha | West Virginia | 54039 | 15280 | 345 |
1368317 | 1368317 | 2021-05-29 | Kanawha | West Virginia | 54039 | 15280 | 345 |
1371563 | 1371563 | 2021-05-30 | Kanawha | West Virginia | 54039 | 15280 | 345 |
1374808 | 1374808 | 2021-05-31 | Kanawha | West Virginia | 54039 | 15280 | 345 |
1714775 | 1714775 | 2021-09-13 | Richland | Ohio | 39139 | 15280 | 226 |
1830266 | 1830266 | 2021-10-19 | Macon | Illinois | 17115 | 15280 | 260 |
1941884 | 1941884 | 2021-11-22 | Strafford | New Hampshire | 33017 | 15280 | 132 |
2103819 | 2103819 | 2022-01-11 | Kennebec | Maine | 23011 | 15280 | 163 |
2251724 | 2251724 | 2022-02-25 | Henderson | Texas | 48213 | 15280 | 405 |
2411563 | 2411563 | 2022-04-15 | Columbia | Wisconsin | 55021 | 15280 | 127 |
2414819 | 2414819 | 2022-04-16 | Columbia | Wisconsin | 55021 | 15280 | 127 |
2418075 | 2418075 | 2022-04-17 | Columbia | Wisconsin | 55021 | 15280 | 127 |
943521 | 943521 | 2021-01-19 | Okaloosa | Florida | 12091 | 15281 | 263 |
1190973 | 1190973 | 2021-04-05 | Warren | Kentucky | 21227 | 15281 | 163 |
1435447 | 1435447 | 2021-06-19 | Greene | Ohio | 39057 | 15281 | 248 |
1531142 | 1531142 | 2021-07-19 | Bartow | Georgia | 13015 | 15281 | 241 |
1563460 | 1563460 | 2021-07-29 | Yolo | California | 6113 | 15281 | 215 |
1829707 | 1829707 | 2021-10-19 | Cochise | Arizona | 4003 | 15281 | 335 |
1924155 | 1924155 | 2021-11-17 | Middlesex | Connecticut | 9007 | 15281 | 399 |
2127479 | 2127479 | 2022-01-18 | Geauga | Ohio | 39055 | 15281 | 223 |
2227335 | 2227335 | 2022-02-18 | Pulaski | Kentucky | 21199 | 15281 | 252 |
2230586 | 2230586 | 2022-02-19 | Pulaski | Kentucky | 21199 | 15281 | 252 |
2233837 | 2233837 | 2022-02-20 | Pulaski | Kentucky | 21199 | 15281 | 252 |
2299621 | 2299621 | 2022-03-12 | Cattaraugus | New York | 36009 | 15281 | 218 |
2314730 | 2314730 | 2022-03-17 | Whiteside | Illinois | 17195 | 15281 | 266 |
224708 | 224708 | 2020-06-10 | Maricopa | Arizona | 4013 | 15282 | 519 |
771336 | 771336 | 2020-11-27 | Washington | Arkansas | 5143 | 15282 | 176 |
968459 | 968459 | 2021-01-26 | Montgomery | Tennessee | 47125 | 15282 | 156 |
1141190 | 1141190 | 2021-03-21 | Lee | Alabama | 1081 | 15282 | 166 |
1169062 | 1169062 | 2021-03-29 | Davidson | North Carolina | 37057 | 15282 | 178 |
1310445 | 1310445 | 2021-05-12 | Douglas | Georgia | 13097 | 15282 | 224 |
1361641 | 1361641 | 2021-05-27 | Arlington | Virginia | 51013 | 15282 | 256 |
1498695 | 1498695 | 2021-07-09 | Clarke | Georgia | 13059 | 15282 | 148 |
1501941 | 1501941 | 2021-07-10 | Clarke | Georgia | 13059 | 15282 | 148 |
1505187 | 1505187 | 2021-07-11 | Clarke | Georgia | 13059 | 15282 | 148 |
1563225 | 1563225 | 2021-07-29 | Calhoun | Alabama | 1015 | 15282 | 332 |
1566473 | 1566473 | 2021-07-30 | Calhoun | Alabama | 1015 | 15282 | 332 |
1817067 | 1817067 | 2021-10-15 | Glynn | Georgia | 13127 | 15282 | 329 |
1820316 | 1820316 | 2021-10-16 | Glynn | Georgia | 13127 | 15282 | 329 |
1823565 | 1823565 | 2021-10-17 | Glynn | Georgia | 13127 | 15282 | 329 |
1873800 | 1873800 | 2021-11-01 | Henderson | North Carolina | 37089 | 15282 | 208 |
1873819 | 1873819 | 2021-11-01 | Nash | North Carolina | 37127 | 15282 | 233 |
2061547 | 2061547 | 2021-12-29 | Androscoggin | Maine | 23001 | 15282 | 157 |
2071966 | 2071966 | 2022-01-01 | Chemung | New York | 36015 | 15282 | 194 |
2085343 | 2085343 | 2022-01-05 | Wagoner | Oklahoma | 40145 | 15282 | 221 |
2088594 | 2088594 | 2022-01-06 | Wagoner | Oklahoma | 40145 | 15282 | 221 |
2091846 | 2091846 | 2022-01-07 | Wagoner | Oklahoma | 40145 | 15282 | 221 |
2095098 | 2095098 | 2022-01-08 | Wagoner | Oklahoma | 40145 | 15282 | 221 |
2098350 | 2098350 | 2022-01-09 | Wagoner | Oklahoma | 40145 | 15282 | 221 |
2101601 | 2101601 | 2022-01-10 | Wagoner | Oklahoma | 40145 | 15282 | 221 |
2101658 | 2101658 | 2022-01-10 | Clearfield | Pennsylvania | 42033 | 15282 | 268 |
2104852 | 2104852 | 2022-01-11 | Wagoner | Oklahoma | 40145 | 15282 | 221 |
2319915 | 2319915 | 2022-03-18 | Angelina | Texas | 48005 | 15282 | 478 |
2323169 | 2323169 | 2022-03-19 | Angelina | Texas | 48005 | 15282 | 479 |
900624 | 900624 | 2021-01-05 | Washington | Utah | 49053 | 15283 | 122 |
1114990 | 1114990 | 2021-03-12 | Benton | Washington | 53005 | 15283 | 208 |
1196586 | 1196586 | 2021-04-07 | Santa Cruz | California | 6087 | 15283 | 203 |
1341065 | 1341065 | 2021-05-21 | San Juan | New Mexico | 35045 | 15283 | 476 |
1344313 | 1344313 | 2021-05-22 | San Juan | New Mexico | 35045 | 15283 | 476 |
1347561 | 1347561 | 2021-05-23 | San Juan | New Mexico | 35045 | 15283 | 476 |
1920327 | 1920327 | 2021-11-15 | Hampton city | Virginia | 51650 | 15283 | 244 |
1931877 | 1931877 | 2021-11-19 | Franklin | Missouri | 29071 | 15283 | 258 |
2022107 | 2022107 | 2021-12-17 | Kosciusko | Indiana | 18085 | 15283 | 177 |
2025358 | 2025358 | 2021-12-18 | Kosciusko | Indiana | 18085 | 15283 | 177 |
2028609 | 2028609 | 2021-12-19 | Kosciusko | Indiana | 18085 | 15283 | 177 |
2158022 | 2158022 | 2022-01-28 | Gila | Arizona | 4007 | 15283 | 334 |
2276215 | 2276215 | 2022-03-05 | Cecil | Maryland | 24015 | 15283 | 255 |
2279468 | 2279468 | 2022-03-06 | Cecil | Maryland | 24015 | 15283 | 255 |
2403861 | 2403861 | 2022-04-13 | Pender | North Carolina | 37141 | 15283 | 118 |
2407117 | 2407117 | 2022-04-14 | Pender | North Carolina | 37141 | 15283 | 118 |
2410373 | 2410373 | 2022-04-15 | Pender | North Carolina | 37141 | 15283 | 118 |
2413629 | 2413629 | 2022-04-16 | Pender | North Carolina | 37141 | 15283 | 118 |
2416885 | 2416885 | 2022-04-17 | Pender | North Carolina | 37141 | 15283 | 118 |
2420140 | 2420140 | 2022-04-18 | Pender | North Carolina | 37141 | 15283 | 118 |
2423397 | 2423397 | 2022-04-19 | Pender | North Carolina | 37141 | 15283 | 118 |
2430202 | 2430202 | 2022-04-21 | Armstrong | Pennsylvania | 42005 | 15283 | 343 |
422933 | 422933 | 2020-08-11 | St. Louis | Missouri | 29189 | 15284 | 672 |
845172 | 845172 | 2020-12-19 | Williamson | Tennessee | 47187 | 15284 | 108 |
1134290 | 1134290 | 2021-03-18 | Cache | Utah | 49005 | 15284 | 39 |
1194223 | 1194223 | 2021-04-06 | Warren | Kentucky | 21227 | 15284 | 164 |
1338913 | 1338913 | 2021-05-20 | Arlington | Virginia | 51013 | 15284 | 256 |
1358395 | 1358395 | 2021-05-26 | Arlington | Virginia | 51013 | 15284 | 256 |
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);