ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 15813 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 |
---|---|---|---|---|---|---|---|
2353195 | 2353195 | 2022-03-29 | Crawford | Arkansas | 5033 | 15813 | 247 |
2211835 | 2211835 | 2022-02-13 | Clinton | New York | 36019 | 15813 | 76 |
2208817 | 2208817 | 2022-02-12 | Geauga | Ohio | 39055 | 15813 | 252 |
2157546 | 2157546 | 2022-01-27 | Wise | Texas | 48497 | 15813 | 229 |
1926297 | 1926297 | 2021-11-17 | Oconee | South Carolina | 45073 | 15813 | 239 |
1914851 | 1914851 | 2021-11-14 | Monroe | Indiana | 18105 | 15813 | 212 |
1911601 | 1911601 | 2021-11-13 | Monroe | Indiana | 18105 | 15813 | 212 |
1908352 | 1908352 | 2021-11-12 | Monroe | Indiana | 18105 | 15813 | 212 |
1859928 | 1859928 | 2021-10-28 | Madison | Kentucky | 21151 | 15813 | 160 |
1711346 | 1711346 | 2021-09-12 | Harnett | North Carolina | 37085 | 15813 | 204 |
1708099 | 1708099 | 2021-09-11 | Harnett | North Carolina | 37085 | 15813 | 204 |
1704852 | 1704852 | 2021-09-10 | Harnett | North Carolina | 37085 | 15813 | 204 |
1419659 | 1419659 | 2021-06-14 | Blount | Tennessee | 47009 | 15813 | 196 |
1416414 | 1416414 | 2021-06-13 | Blount | Tennessee | 47009 | 15813 | 196 |
1413168 | 1413168 | 2021-06-12 | Blount | Tennessee | 47009 | 15813 | 196 |
1409923 | 1409923 | 2021-06-11 | Blount | Tennessee | 47009 | 15813 | 196 |
1317303 | 1317303 | 2021-05-14 | Black Hawk | Iowa | 19013 | 15813 | 308 |
1264956 | 1264956 | 2021-04-28 | Bibb | Georgia | 13021 | 15813 | 445 |
1234965 | 1234965 | 2021-04-18 | Cache | Utah | 49005 | 15813 | 45 |
1231717 | 1231717 | 2021-04-17 | Cache | Utah | 49005 | 15813 | 45 |
1126197 | 1126197 | 2021-03-16 | Kalamazoo | Michigan | 26077 | 15813 | 325 |
1083141 | 1083141 | 2021-03-03 | Columbia | Georgia | 13073 | 15813 | 189 |
987300 | 987300 | 2021-02-01 | Johnston | North Carolina | 37101 | 15813 | 163 |
959317 | 959317 | 2021-01-23 | Kenosha | Wisconsin | 55059 | 15813 | 273 |
745297 | 745297 | 2020-11-19 | Yuma | Arizona | 4027 | 15813 | 369 |
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);