ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 12971 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 |
---|---|---|---|---|---|---|---|
2464927 | 2464927 | 2022-05-02 | Washington | Louisiana | 22117 | 12971 | 248 |
2433053 | 2433053 | 2022-04-22 | Fulton | New York | 36035 | 12971 | 169 |
2392852 | 2392852 | 2022-04-10 | Henry | Indiana | 18065 | 12971 | 230 |
2389596 | 2389596 | 2022-04-09 | Henry | Indiana | 18065 | 12971 | 230 |
2386341 | 2386341 | 2022-04-08 | Henry | Indiana | 18065 | 12971 | 230 |
2352786 | 2352786 | 2022-03-28 | Fauquier | Virginia | 51061 | 12971 | 140 |
2331033 | 2331033 | 2022-03-22 | Henry | Indiana | 18065 | 12971 | 228 |
2221837 | 2221837 | 2022-02-16 | Knox | Ohio | 39083 | 12971 | 217 |
2126489 | 2126489 | 2022-01-18 | Pulaski | Kentucky | 21199 | 12971 | 234 |
2061587 | 2061587 | 2021-12-29 | Wicomico | Maryland | 24045 | 12971 | 248 |
1988246 | 1988246 | 2021-12-06 | Bowie | Texas | 48037 | 12971 | 346 |
1959624 | 1959624 | 2021-11-28 | DeKalb | Alabama | 1049 | 12971 | 269 |
1935391 | 1935391 | 2021-11-20 | Cape May | New Jersey | 34009 | 12971 | 242 |
1870741 | 1870741 | 2021-10-31 | Tuscarawas | Ohio | 39157 | 12971 | 316 |
1721026 | 1721026 | 2021-09-15 | Rensselaer | New York | 36083 | 12971 | 154 |
1420856 | 1420856 | 2021-06-15 | Lowndes | Georgia | 13185 | 12971 | 214 |
1300981 | 1300981 | 2021-05-09 | Clark | Indiana | 18019 | 12971 | 200 |
1112496 | 1112496 | 2021-03-12 | Bonneville | Idaho | 16019 | 12971 | 152 |
1102129 | 1102129 | 2021-03-08 | La Crosse | Wisconsin | 55063 | 12971 | 80 |
1098883 | 1098883 | 2021-03-07 | La Crosse | Wisconsin | 55063 | 12971 | 80 |
912988 | 912988 | 2021-01-09 | Erie | Pennsylvania | 42049 | 12971 | 258 |
712579 | 712579 | 2020-11-08 | Pierce | Washington | 53053 | 12971 | 268 |
672436 | 672436 | 2020-10-27 | Erie | New York | 36029 | 12971 | 649 |
664453 | 664453 | 2020-10-25 | Manatee | Florida | 12081 | 12971 | 327 |
369311 | 369311 | 2020-07-25 | El Paso | Texas | 48141 | 12971 | 221 |
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);