ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 11205 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- North Carolina 7
- Alabama 3
- Georgia 3
- California 2
- Pennsylvania 2
- Texas 2
- Arkansas 1
- Florida 1
- Michigan 1
- Mississippi 1
- New Mexico 1
- New York 1
- North Dakota 1
- Ohio 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468939 | 2468939 | 2022-05-03 | Davie | North Carolina | 37059 | 11205 | 94 |
2465683 | 2465683 | 2022-05-02 | Davie | North Carolina | 37059 | 11205 | 94 |
2462428 | 2462428 | 2022-05-01 | Davie | North Carolina | 37059 | 11205 | 94 |
2459172 | 2459172 | 2022-04-30 | Davie | North Carolina | 37059 | 11205 | 94 |
2455916 | 2455916 | 2022-04-29 | Davie | North Carolina | 37059 | 11205 | 94 |
2452660 | 2452660 | 2022-04-28 | Davie | North Carolina | 37059 | 11205 | 94 |
2449404 | 2449404 | 2022-04-27 | Davie | North Carolina | 37059 | 11205 | 94 |
2346063 | 2346063 | 2022-03-26 | Jim Wells | Texas | 48249 | 11205 | 205 |
2296845 | 2296845 | 2022-03-11 | Venango | Pennsylvania | 42121 | 11205 | 234 |
2174722 | 2174722 | 2022-02-02 | Tift | Georgia | 13277 | 11205 | 199 |
2146733 | 2146733 | 2022-01-24 | Curry | New Mexico | 35009 | 11205 | 154 |
2005233 | 2005233 | 2021-12-12 | Crawford | Arkansas | 5033 | 11205 | 184 |
1918803 | 1918803 | 2021-11-15 | Lowndes | Mississippi | 28087 | 11205 | 193 |
1904752 | 1904752 | 2021-11-11 | Bulloch | Georgia | 13031 | 11205 | 205 |
1901502 | 1901502 | 2021-11-10 | Bulloch | Georgia | 13031 | 11205 | 205 |
1900393 | 1900393 | 2021-11-09 | Cumberland | Tennessee | 47035 | 11205 | 226 |
1678932 | 1678932 | 2021-09-02 | Grand Forks | North Dakota | 38035 | 11205 | 80 |
1599012 | 1599012 | 2021-08-09 | St. Clair | Alabama | 1115 | 11205 | 252 |
1452255 | 1452255 | 2021-06-24 | Comal | Texas | 48091 | 11205 | 325 |
1389803 | 1389803 | 2021-06-05 | Rensselaer | New York | 36083 | 11205 | 142 |
1359959 | 1359959 | 2021-05-27 | Bay | Michigan | 26017 | 11205 | 346 |
974432 | 974432 | 2021-01-28 | Clark | Ohio | 39023 | 11205 | 281 |
901018 | 901018 | 2021-01-06 | Morgan | Alabama | 1103 | 11205 | 100 |
870798 | 870798 | 2020-12-27 | Erie | Pennsylvania | 42049 | 11205 | 194 |
768136 | 768136 | 2020-11-26 | Santa Barbara | California | 6083 | 11205 | 135 |
764890 | 764890 | 2020-11-25 | Santa Barbara | California | 6083 | 11205 | 135 |
709561 | 709561 | 2020-11-08 | Tuscaloosa | Alabama | 1125 | 11205 | 146 |
703374 | 703374 | 2020-11-06 | Marion | Florida | 12083 | 11205 | 355 |
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);