ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where cases = 11586 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 |
---|---|---|---|---|---|---|---|
2446757 | 2446757 | 2022-04-26 | Cocke | Tennessee | 47029 | 11586 | 216 |
2443502 | 2443502 | 2022-04-25 | Cocke | Tennessee | 47029 | 11586 | 216 |
2440246 | 2440246 | 2022-04-24 | Cocke | Tennessee | 47029 | 11586 | 216 |
2436990 | 2436990 | 2022-04-23 | Cocke | Tennessee | 47029 | 11586 | 216 |
2433734 | 2433734 | 2022-04-22 | Cocke | Tennessee | 47029 | 11586 | 216 |
2430478 | 2430478 | 2022-04-21 | Cocke | Tennessee | 47029 | 11586 | 216 |
2427222 | 2427222 | 2022-04-20 | Cocke | Tennessee | 47029 | 11586 | 216 |
2221109 | 2221109 | 2022-02-16 | Mower | Minnesota | 27099 | 11586 | 66 |
2169639 | 2169639 | 2022-01-31 | Haywood | North Carolina | 37087 | 11586 | 172 |
2163982 | 2163982 | 2022-01-29 | Navarro | Texas | 48349 | 11586 | 203 |
2164037 | 2164037 | 2022-01-29 | Unknown | Texas | 11586 | 0 | |
2149284 | 2149284 | 2022-01-25 | Whitley | Kentucky | 21235 | 11586 | 146 |
2128248 | 2128248 | 2022-01-18 | Val Verde | Texas | 48465 | 11586 | 262 |
2091763 | 2091763 | 2022-01-07 | Union | Ohio | 39159 | 11586 | 81 |
2091905 | 2091905 | 2022-01-07 | Columbia | Pennsylvania | 42037 | 11586 | 196 |
1893473 | 1893473 | 2021-11-07 | Pickaway | Ohio | 39129 | 11586 | 148 |
1868190 | 1868190 | 2021-10-30 | Starr | Texas | 48427 | 11586 | 331 |
1851096 | 1851096 | 2021-10-25 | Stanly | North Carolina | 37167 | 11586 | 189 |
1691052 | 1691052 | 2021-09-06 | Iberia | Louisiana | 22045 | 11586 | 199 |
1687802 | 1687802 | 2021-09-05 | Iberia | Louisiana | 22045 | 11586 | 199 |
1684552 | 1684552 | 2021-09-04 | Iberia | Louisiana | 22045 | 11586 | 199 |
1681301 | 1681301 | 2021-09-03 | Iberia | Louisiana | 22045 | 11586 | 199 |
1514303 | 1514303 | 2021-07-13 | Stafford | Virginia | 51179 | 11586 | 83 |
1440264 | 1440264 | 2021-06-21 | Carroll | Georgia | 13045 | 11586 | 245 |
1383355 | 1383355 | 2021-06-03 | Cleveland | North Carolina | 37045 | 11586 | 227 |
1380109 | 1380109 | 2021-06-02 | Cleveland | North Carolina | 37045 | 11586 | 227 |
1311954 | 1311954 | 2021-05-12 | Harnett | North Carolina | 37085 | 11586 | 171 |
1156025 | 1156025 | 2021-03-25 | Schenectady | New York | 36093 | 11586 | 186 |
990422 | 990422 | 2021-02-02 | McKinley | New Mexico | 35031 | 11586 | 416 |
832774 | 832774 | 2020-12-15 | Rock | Wisconsin | 55105 | 11586 | 107 |
761076 | 761076 | 2020-11-23 | Weber | Utah | 49057 | 11586 | 48 |
733053 | 733053 | 2020-11-15 | Linn | Iowa | 19113 | 11586 | 149 |
415007 | 415007 | 2020-08-09 | Yuma | Arizona | 4027 | 11586 | 290 |
99857 | 99857 | 2020-04-29 | Rockland | New York | 36087 | 11586 | 364 |
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);