ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 9112 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Florida 14
- Rhode Island 7
- Oregon 3
- Georgia 2
- Indiana 2
- Ohio 2
- Arizona 1
- Guam 1
- Hawaii 1
- Massachusetts 1
- Minnesota 1
- Mississippi 1
- New York 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2429306 | 2429306 | 2022-04-21 | Morrison | Minnesota | 27097 | 9112 | 104 |
2382754 | 2382754 | 2022-04-07 | Bryan | Georgia | 13029 | 9112 | 90 |
2132264 | 2132264 | 2022-01-20 | Okeechobee | Florida | 12093 | 9112 | 164 |
2129011 | 2129011 | 2022-01-19 | Okeechobee | Florida | 12093 | 9112 | 164 |
2125757 | 2125757 | 2022-01-18 | Okeechobee | Florida | 12093 | 9112 | 163 |
2122505 | 2122505 | 2022-01-17 | Okeechobee | Florida | 12093 | 9112 | 163 |
2119253 | 2119253 | 2022-01-16 | Okeechobee | Florida | 12093 | 9112 | 163 |
2116001 | 2116001 | 2022-01-15 | Okeechobee | Florida | 12093 | 9112 | 163 |
2112750 | 2112750 | 2022-01-14 | Okeechobee | Florida | 12093 | 9112 | 163 |
1984599 | 1984599 | 2021-12-05 | Klamath | Oregon | 41035 | 9112 | 149 |
1981349 | 1981349 | 2021-12-04 | Klamath | Oregon | 41035 | 9112 | 149 |
1978099 | 1978099 | 2021-12-03 | Klamath | Oregon | 41035 | 9112 | 149 |
1970090 | 1970090 | 2021-12-01 | Henry | Indiana | 18065 | 9112 | 172 |
1746989 | 1746989 | 2021-09-23 | Chemung | New York | 36015 | 9112 | 146 |
1739193 | 1739193 | 2021-09-21 | Maui | Hawaii | 15009 | 9112 | 83 |
1700007 | 1700007 | 2021-09-09 | Jackson | Florida | 12063 | 9112 | 158 |
1696758 | 1696758 | 2021-09-08 | Jackson | Florida | 12063 | 9112 | 158 |
1693510 | 1693510 | 2021-09-07 | Jackson | Florida | 12063 | 9112 | 158 |
1690261 | 1690261 | 2021-09-06 | Jackson | Florida | 12063 | 9112 | 158 |
1687011 | 1687011 | 2021-09-05 | Jackson | Florida | 12063 | 9112 | 158 |
1683761 | 1683761 | 2021-09-04 | Jackson | Florida | 12063 | 9112 | 158 |
1680510 | 1680510 | 2021-09-03 | Jackson | Florida | 12063 | 9112 | 158 |
1640058 | 1640058 | 2021-08-21 | Pickaway | Ohio | 39129 | 9112 | 123 |
1412782 | 1412782 | 2021-06-12 | Wayne | Ohio | 39169 | 9112 | 222 |
1356014 | 1356014 | 2021-05-26 | Unknown | Guam | 9112 | 140 | |
1333968 | 1333968 | 2021-05-19 | Hampshire | Massachusetts | 25015 | 9112 | 295 |
1092849 | 1092849 | 2021-03-06 | Barrow | Georgia | 13013 | 9112 | 120 |
1003034 | 1003034 | 2021-02-06 | Madison | Mississippi | 28089 | 9112 | 186 |
960129 | 960129 | 2021-01-24 | LaPorte | Indiana | 18091 | 9112 | 167 |
465708 | 465708 | 2020-08-24 | Horry | South Carolina | 45051 | 9112 | 177 |
187743 | 187743 | 2020-05-29 | Maricopa | Arizona | 4013 | 9112 | 419 |
159498 | 159498 | 2020-05-19 | Providence | Rhode Island | 44007 | 9112 | 342 |
156477 | 156477 | 2020-05-18 | Providence | Rhode Island | 44007 | 9112 | 342 |
153460 | 153460 | 2020-05-17 | Providence | Rhode Island | 44007 | 9112 | 342 |
150449 | 150449 | 2020-05-16 | Providence | Rhode Island | 44007 | 9112 | 342 |
147441 | 147441 | 2020-05-15 | Providence | Rhode Island | 44007 | 9112 | 342 |
144440 | 144440 | 2020-05-14 | Providence | Rhode Island | 44007 | 9112 | 342 |
141444 | 141444 | 2020-05-13 | Providence | Rhode Island | 44007 | 9112 | 342 |
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);