ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 12500 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502346 | 2502346 | 2022-05-13 | Lamar | Texas | 48277 | 12500 | 256 |
2499088 | 2499088 | 2022-05-12 | Lamar | Texas | 48277 | 12500 | 256 |
2495830 | 2495830 | 2022-05-11 | Lamar | Texas | 48277 | 12500 | 256 |
2492572 | 2492572 | 2022-05-10 | Lamar | Texas | 48277 | 12500 | 256 |
2489314 | 2489314 | 2022-05-09 | Lamar | Texas | 48277 | 12500 | 256 |
2464918 | 2464918 | 2022-05-02 | St. Mary | Louisiana | 22101 | 12500 | 262 |
2461662 | 2461662 | 2022-05-01 | St. Mary | Louisiana | 22101 | 12500 | 262 |
2458406 | 2458406 | 2022-04-30 | St. Mary | Louisiana | 22101 | 12500 | 262 |
2455150 | 2455150 | 2022-04-29 | St. Mary | Louisiana | 22101 | 12500 | 262 |
2451894 | 2451894 | 2022-04-28 | St. Mary | Louisiana | 22101 | 12500 | 262 |
2370372 | 2370372 | 2022-04-03 | Floyd | Kentucky | 21071 | 12500 | 176 |
2367119 | 2367119 | 2022-04-02 | Floyd | Kentucky | 21071 | 12500 | 176 |
2363866 | 2363866 | 2022-04-01 | Floyd | Kentucky | 21071 | 12500 | 176 |
2360612 | 2360612 | 2022-03-31 | Floyd | Kentucky | 21071 | 12500 | 176 |
2357358 | 2357358 | 2022-03-30 | Floyd | Kentucky | 21071 | 12500 | 176 |
2354105 | 2354105 | 2022-03-29 | Floyd | Kentucky | 21071 | 12500 | 176 |
2350853 | 2350853 | 2022-03-28 | Floyd | Kentucky | 21071 | 12500 | 176 |
2308264 | 2308264 | 2022-03-15 | Jackson | Indiana | 18071 | 12500 | 127 |
2106016 | 2106016 | 2022-01-12 | Greene | Arkansas | 5055 | 12500 | 139 |
2055685 | 2055685 | 2021-12-27 | Eddy | New Mexico | 35015 | 12500 | 223 |
1985747 | 1985747 | 2021-12-06 | Jefferson | Arkansas | 5069 | 12500 | 229 |
1844460 | 1844460 | 2021-10-23 | Chautauqua | New York | 36013 | 12500 | 175 |
1699693 | 1699693 | 2021-09-09 | Lauderdale | Alabama | 1077 | 12500 | 261 |
1677377 | 1677377 | 2021-09-02 | Jackson | Georgia | 13157 | 12500 | 165 |
1642727 | 1642727 | 2021-08-22 | Jasper | Missouri | 29097 | 12500 | 157 |
1555305 | 1555305 | 2021-07-26 | McKinley | New Mexico | 35031 | 12500 | 481 |
1518502 | 1518502 | 2021-07-15 | LaPorte | Indiana | 18091 | 12500 | 225 |
1488583 | 1488583 | 2021-07-06 | Marshall | Alabama | 1095 | 12500 | 231 |
1485336 | 1485336 | 2021-07-05 | Marshall | Alabama | 1095 | 12500 | 231 |
1482090 | 1482090 | 2021-07-04 | Marshall | Alabama | 1095 | 12500 | 231 |
1478843 | 1478843 | 2021-07-03 | Marshall | Alabama | 1095 | 12500 | 231 |
1475597 | 1475597 | 2021-07-02 | Marshall | Alabama | 1095 | 12500 | 231 |
1335832 | 1335832 | 2021-05-19 | Berkeley | West Virginia | 54003 | 12500 | 126 |
1112756 | 1112756 | 2021-03-12 | Dubuque | Iowa | 19061 | 12500 | 199 |
1074391 | 1074391 | 2021-02-28 | Wright | Minnesota | 27171 | 12500 | 115 |
1011439 | 1011439 | 2021-02-09 | Craighead | Arkansas | 5031 | 12500 | 173 |
868471 | 868471 | 2020-12-26 | Rock | Wisconsin | 55105 | 12500 | 119 |
862823 | 862823 | 2020-12-25 | Black Hawk | Iowa | 19013 | 12500 | 215 |
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);