ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 9587 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Oregon 3
- Tennessee 3
- California 2
- Georgia 2
- North Carolina 2
- Pennsylvania 2
- Texas 2
- Wisconsin 2
- Alabama 1
- Idaho 1
- Illinois 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- Nebraska 1
- New Jersey 1
- New York 1
- North Dakota 1
- Ohio 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2244373 | 2244373 | 2022-02-23 | Otsego | New York | 36077 | 9587 | 86 |
2206262 | 2206262 | 2022-02-11 | Medina | Texas | 48325 | 9587 | 187 |
2197528 | 2197528 | 2022-02-09 | Bingham | Idaho | 16011 | 9587 | 142 |
2168147 | 2168147 | 2022-01-31 | Habersham | Georgia | 13137 | 9587 | 229 |
2152880 | 2152880 | 2022-01-26 | Monroe | Mississippi | 28095 | 9587 | 187 |
2111456 | 2111456 | 2022-01-13 | Venango | Pennsylvania | 42121 | 9587 | 207 |
2109090 | 2109090 | 2022-01-12 | Shawano | Wisconsin | 55115 | 9587 | 117 |
2078558 | 2078558 | 2022-01-03 | Granville | North Carolina | 37077 | 9587 | 107 |
2053878 | 2053878 | 2021-12-27 | Colbert | Alabama | 1033 | 9587 | 214 |
1903186 | 1903186 | 2021-11-10 | Geauga | Ohio | 39055 | 9587 | 165 |
1825702 | 1825702 | 2021-10-17 | Monroe | Tennessee | 47123 | 9587 | 121 |
1822453 | 1822453 | 2021-10-16 | Monroe | Tennessee | 47123 | 9587 | 121 |
1819204 | 1819204 | 2021-10-15 | Monroe | Tennessee | 47123 | 9587 | 121 |
1575219 | 1575219 | 2021-08-01 | Umatilla | Oregon | 41059 | 9587 | 94 |
1571971 | 1571971 | 2021-07-31 | Umatilla | Oregon | 41059 | 9587 | 94 |
1568723 | 1568723 | 2021-07-30 | Umatilla | Oregon | 41059 | 9587 | 94 |
1401139 | 1401139 | 2021-06-09 | Sutter | California | 6101 | 9587 | 111 |
1383692 | 1383692 | 2021-06-03 | Adams | Pennsylvania | 42001 | 9587 | 184 |
1309940 | 1309940 | 2021-05-11 | Jefferson | Wisconsin | 55055 | 9587 | 132 |
1282792 | 1282792 | 2021-05-03 | Wilson | North Carolina | 37195 | 9587 | 172 |
1209747 | 1209747 | 2021-04-11 | Barrow | Georgia | 13013 | 9587 | 128 |
964134 | 964134 | 2021-01-25 | Buchanan | Missouri | 29021 | 9587 | 153 |
964648 | 964648 | 2021-01-25 | Grand Forks | North Dakota | 38035 | 9587 | 72 |
895857 | 895857 | 2021-01-04 | Olmsted | Minnesota | 27109 | 9587 | 64 |
810756 | 810756 | 2020-12-09 | McLean | Illinois | 17113 | 9587 | 64 |
536208 | 536208 | 2020-09-15 | Camden | New Jersey | 34007 | 9587 | 600 |
450612 | 450612 | 2020-08-20 | Ventura | California | 6111 | 9587 | 101 |
368331 | 368331 | 2020-07-25 | Douglas | Nebraska | 31055 | 9587 | 122 |
187112 | 187112 | 2020-05-28 | Dallas | Texas | 48113 | 9587 | 222 |
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);