ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 17592 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Tennessee 7
- Texas 5
- Illinois 3
- Montana 3
- Louisiana 2
- Ohio 2
- Pennsylvania 2
- Arizona 1
- California 1
- Florida 1
- Georgia 1
- Idaho 1
- Maryland 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2378457 | 2378457 | 2022-04-05 | Tipton | Tennessee | 47167 | 17592 | 230 |
2375203 | 2375203 | 2022-04-04 | Tipton | Tennessee | 47167 | 17592 | 230 |
2371951 | 2371951 | 2022-04-03 | Tipton | Tennessee | 47167 | 17592 | 230 |
2368698 | 2368698 | 2022-04-02 | Tipton | Tennessee | 47167 | 17592 | 230 |
2365445 | 2365445 | 2022-04-01 | Tipton | Tennessee | 47167 | 17592 | 230 |
2362192 | 2362192 | 2022-03-31 | Tipton | Tennessee | 47167 | 17592 | 230 |
2358938 | 2358938 | 2022-03-30 | Tipton | Tennessee | 47167 | 17592 | 230 |
2294038 | 2294038 | 2022-03-10 | Liberty | Texas | 48291 | 17592 | 396 |
2005762 | 2005762 | 2021-12-12 | Macon | Illinois | 17115 | 17592 | 275 |
2006752 | 2006752 | 2021-12-12 | Missoula | Montana | 30063 | 17592 | 189 |
2002511 | 2002511 | 2021-12-11 | Macon | Illinois | 17115 | 17592 | 275 |
2003501 | 2003501 | 2021-12-11 | Missoula | Montana | 30063 | 17592 | 189 |
1999261 | 1999261 | 2021-12-10 | Macon | Illinois | 17115 | 17592 | 275 |
2000251 | 2000251 | 2021-12-10 | Missoula | Montana | 30063 | 17592 | 189 |
1878543 | 1878543 | 2021-11-03 | El Dorado | California | 6017 | 17592 | 154 |
1646570 | 1646570 | 2021-08-23 | Trumbull | Ohio | 39155 | 17592 | 494 |
1643266 | 1643266 | 2021-08-22 | Fairfield | Ohio | 39045 | 17592 | 211 |
1491226 | 1491226 | 2021-07-06 | Ector | Texas | 48135 | 17592 | 379 |
1487979 | 1487979 | 2021-07-05 | Ector | Texas | 48135 | 17592 | 379 |
1484732 | 1484732 | 2021-07-04 | Ector | Texas | 48135 | 17592 | 379 |
1481486 | 1481486 | 2021-07-03 | Ector | Texas | 48135 | 17592 | 379 |
1432384 | 1432384 | 2021-06-18 | Butler | Pennsylvania | 42019 | 17592 | 418 |
1429926 | 1429926 | 2021-06-17 | Benton | Washington | 53005 | 17592 | 226 |
1266853 | 1266853 | 2021-04-28 | Lackawanna | Pennsylvania | 42069 | 17592 | 455 |
1248418 | 1248418 | 2021-04-23 | Coconino | Arizona | 4005 | 17592 | 329 |
1245657 | 1245657 | 2021-04-22 | Kootenai | Idaho | 16055 | 17592 | 206 |
1144773 | 1144773 | 2021-03-22 | Santa Rosa | Florida | 12113 | 17592 | 276 |
1048169 | 1048169 | 2021-02-20 | Ouachita | Louisiana | 22073 | 17592 | 404 |
1044924 | 1044924 | 2021-02-19 | Ouachita | Louisiana | 22073 | 17592 | 404 |
894894 | 894894 | 2021-01-04 | Cherokee | Georgia | 13057 | 17592 | 131 |
231997 | 231997 | 2020-06-12 | Prince George's | Maryland | 24033 | 17592 | 631 |
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);