ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 7997 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 |
---|---|---|---|---|---|---|---|
2381974 | 2381974 | 2022-04-06 | Wood | Texas | 48499 | 7997 | 287 |
2378719 | 2378719 | 2022-04-05 | Wood | Texas | 48499 | 7997 | 286 |
2375465 | 2375465 | 2022-04-04 | Wood | Texas | 48499 | 7997 | 286 |
2365156 | 2365156 | 2022-04-01 | Tioga | Pennsylvania | 42117 | 7997 | 192 |
2347838 | 2347838 | 2022-03-27 | Huron | Michigan | 26063 | 7997 | 146 |
2344585 | 2344585 | 2022-03-26 | Huron | Michigan | 26063 | 7997 | 146 |
2341332 | 2341332 | 2022-03-25 | Huron | Michigan | 26063 | 7997 | 146 |
2333716 | 2333716 | 2022-03-23 | Poinsett | Arkansas | 5111 | 7997 | 126 |
2331571 | 2331571 | 2022-03-22 | Huron | Michigan | 26063 | 7997 | 146 |
2328319 | 2328319 | 2022-03-21 | Huron | Michigan | 26063 | 7997 | 146 |
2266829 | 2266829 | 2022-03-02 | Polk | Missouri | 29167 | 7997 | 103 |
2241559 | 2241559 | 2022-02-22 | Snyder | Pennsylvania | 42109 | 7997 | 149 |
2222632 | 2222632 | 2022-02-16 | Sanpete | Utah | 49039 | 7997 | 49 |
2209510 | 2209510 | 2022-02-12 | Matagorda | Texas | 48321 | 7997 | 171 |
2195372 | 2195372 | 2022-02-08 | Silver Bow | Montana | 30093 | 7997 | 118 |
2180469 | 2180469 | 2022-02-03 | Petersburg city | Virginia | 51730 | 7997 | 118 |
2079926 | 2079926 | 2022-01-04 | Tallapoosa | Alabama | 1123 | 7997 | 205 |
2054002 | 2054002 | 2021-12-27 | Hot Spring | Arkansas | 5059 | 7997 | 114 |
2019382 | 2019382 | 2021-12-16 | Hillsdale | Michigan | 26059 | 7997 | 162 |
2016132 | 2016132 | 2021-12-15 | Hillsdale | Michigan | 26059 | 7997 | 162 |
1977716 | 1977716 | 2021-12-03 | Fulton | New York | 36035 | 7997 | 115 |
1919425 | 1919425 | 2021-11-15 | Darke | Ohio | 39037 | 7997 | 171 |
1906292 | 1906292 | 2021-11-11 | Halifax | North Carolina | 37083 | 7997 | 143 |
1903043 | 1903043 | 2021-11-10 | Halifax | North Carolina | 37083 | 7997 | 143 |
1884151 | 1884151 | 2021-11-04 | Franklin | Tennessee | 47051 | 7997 | 102 |
1799219 | 1799219 | 2021-10-09 | Huron | Ohio | 39077 | 7997 | 138 |
1793172 | 1793172 | 2021-10-07 | Dyer | Tennessee | 47045 | 7997 | 139 |
1788093 | 1788093 | 2021-10-06 | Dearborn | Indiana | 18029 | 7997 | 95 |
1511773 | 1511773 | 2021-07-13 | Rockdale | Georgia | 13247 | 7997 | 179 |
1420172 | 1420172 | 2021-06-14 | Suffolk city | Virginia | 51800 | 7997 | 191 |
1309997 | 1309997 | 2021-05-11 | Natrona | Wyoming | 56025 | 7997 | 136 |
1229170 | 1229170 | 2021-04-17 | Columbia | Florida | 12023 | 7997 | 165 |
1049132 | 1049132 | 2021-02-20 | Muskingum | Ohio | 39119 | 7997 | 121 |
977138 | 977138 | 2021-01-29 | Franklin | Missouri | 29071 | 7997 | 131 |
974960 | 974960 | 2021-01-28 | Robertson | Tennessee | 47147 | 7997 | 90 |
854558 | 854558 | 2020-12-22 | Butler | Pennsylvania | 42019 | 7997 | 150 |
839128 | 839128 | 2020-12-17 | Franklin | Washington | 53021 | 7997 | 76 |
819190 | 819190 | 2020-12-11 | Sullivan | Tennessee | 47163 | 7997 | 128 |
518486 | 518486 | 2020-09-10 | Adams | Colorado | 8001 | 7997 | 209 |
521315 | 521315 | 2020-09-10 | Pierce | Washington | 53053 | 7997 | 198 |
364138 | 364138 | 2020-07-24 | Will | Illinois | 17197 | 7997 | 338 |
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);