ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 8665 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 |
---|---|---|---|---|---|---|---|
2368782 | 2368782 | 2022-04-02 | Erath | Texas | 48143 | 8665 | 123 |
2145582 | 2145582 | 2022-01-24 | Montgomery | Illinois | 17135 | 8665 | 96 |
2074874 | 2074874 | 2022-01-02 | Callaway | Missouri | 29027 | 8665 | 98 |
2071623 | 2071623 | 2022-01-01 | Callaway | Missouri | 29027 | 8665 | 98 |
2068372 | 2068372 | 2021-12-31 | Callaway | Missouri | 29027 | 8665 | 98 |
2065121 | 2065121 | 2021-12-30 | Callaway | Missouri | 29027 | 8665 | 98 |
2010667 | 2010667 | 2021-12-13 | Mifflin | Pennsylvania | 42087 | 8665 | 231 |
1973108 | 1973108 | 2021-12-02 | Polk | Georgia | 13233 | 8665 | 164 |
1969858 | 1969858 | 2021-12-01 | Polk | Georgia | 13233 | 8665 | 164 |
1937599 | 1937599 | 2021-11-21 | Marshall | Indiana | 18099 | 8665 | 151 |
1934349 | 1934349 | 2021-11-20 | Marshall | Indiana | 18099 | 8665 | 151 |
1931098 | 1931098 | 2021-11-19 | Marshall | Indiana | 18099 | 8665 | 151 |
1746301 | 1746301 | 2021-09-23 | St. Charles | Louisiana | 22089 | 8665 | 120 |
1611342 | 1611342 | 2021-08-12 | Bowie | Texas | 48037 | 8665 | 231 |
1581682 | 1581682 | 2021-08-03 | Wagoner | Oklahoma | 40145 | 8665 | 124 |
1578433 | 1578433 | 2021-08-02 | Wagoner | Oklahoma | 40145 | 8665 | 124 |
1575185 | 1575185 | 2021-08-01 | Wagoner | Oklahoma | 40145 | 8665 | 124 |
1571937 | 1571937 | 2021-07-31 | Wagoner | Oklahoma | 40145 | 8665 | 124 |
1568689 | 1568689 | 2021-07-30 | Wagoner | Oklahoma | 40145 | 8665 | 124 |
1563385 | 1563385 | 2021-07-29 | Pope | Arkansas | 5115 | 8665 | 112 |
1565441 | 1565441 | 2021-07-29 | Wagoner | Oklahoma | 40145 | 8665 | 124 |
1562193 | 1562193 | 2021-07-28 | Wagoner | Oklahoma | 40145 | 8665 | 124 |
1563002 | 1563002 | 2021-07-28 | Roanoke | Virginia | 51161 | 8665 | 148 |
1507800 | 1507800 | 2021-07-11 | Roanoke city | Virginia | 51770 | 8665 | 199 |
1464705 | 1464705 | 2021-06-28 | Tuscarawas | Ohio | 39157 | 8665 | 252 |
1461460 | 1461460 | 2021-06-27 | Tuscarawas | Ohio | 39157 | 8665 | 252 |
1323343 | 1323343 | 2021-05-16 | Highlands | Florida | 12055 | 8665 | 361 |
1217966 | 1217966 | 2021-04-13 | Muskingum | Ohio | 39119 | 8665 | 127 |
1194359 | 1194359 | 2021-04-06 | Bay | Michigan | 26017 | 8665 | 309 |
1108829 | 1108829 | 2021-03-11 | Jefferson | Arkansas | 5069 | 8665 | 162 |
963225 | 963225 | 2021-01-25 | Twin Falls | Idaho | 16083 | 8665 | 120 |
891667 | 891667 | 2021-01-03 | Douglas | Georgia | 13097 | 8665 | 109 |
893661 | 893661 | 2021-01-03 | Dorchester | South Carolina | 45035 | 8665 | 129 |
873740 | 873740 | 2020-12-28 | Rowan | North Carolina | 37159 | 8665 | 164 |
867682 | 867682 | 2020-12-26 | Aiken | South Carolina | 45003 | 8665 | 131 |
431119 | 431119 | 2020-08-14 | Pinal | Arizona | 4021 | 8665 | 166 |
326216 | 326216 | 2020-07-12 | Orleans | Louisiana | 22071 | 8665 | 540 |
102704 | 102704 | 2020-04-30 | Orange | New York | 36071 | 8665 | 237 |
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);