ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 12169 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- New Mexico 2
- New York 2
- Arizona 1
- California 1
- Florida 1
- Georgia 1
- Hawaii 1
- Idaho 1
- Indiana 1
- Louisiana 1
- Minnesota 1
- North Carolina 1
- Texas 1
- Utah 1
- Washington 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449343 | 2449343 | 2022-04-27 | Montgomery | New York | 36057 | 12169 | 204 |
2265198 | 2265198 | 2022-03-01 | Polk | Wisconsin | 55095 | 12169 | 117 |
2231349 | 2231349 | 2022-02-19 | Fulton | New York | 36035 | 12169 | 164 |
1878000 | 1878000 | 2021-11-02 | Tooele | Utah | 49045 | 12169 | 67 |
1714485 | 1714485 | 2021-09-13 | Santa Fe | New Mexico | 35049 | 12169 | 158 |
1611935 | 1611935 | 2021-08-12 | Laramie | Wyoming | 56021 | 12169 | 137 |
1513206 | 1513206 | 2021-07-13 | Harnett | North Carolina | 37085 | 12169 | 182 |
1488983 | 1488983 | 2021-07-06 | Floyd | Georgia | 13115 | 12169 | 239 |
1430209 | 1430209 | 2021-06-18 | Cochise | Arizona | 4003 | 12169 | 292 |
1405985 | 1405985 | 2021-06-10 | Sandoval | New Mexico | 35043 | 12169 | 241 |
1270871 | 1270871 | 2021-04-29 | Franklin | Washington | 53021 | 12169 | 110 |
1190609 | 1190609 | 2021-04-05 | Madison | Indiana | 18095 | 12169 | 353 |
1142531 | 1142531 | 2021-03-21 | Olmsted | Minnesota | 27109 | 12169 | 93 |
1011556 | 1011556 | 2021-02-09 | Yolo | California | 6113 | 12169 | 170 |
907076 | 907076 | 2021-01-07 | Wichita | Texas | 48485 | 12169 | 231 |
625704 | 625704 | 2020-10-13 | Honolulu | Hawaii | 15003 | 12169 | 144 |
541450 | 541450 | 2020-09-17 | Ada | Idaho | 16001 | 12169 | 143 |
529104 | 529104 | 2020-09-13 | Orleans | Louisiana | 22071 | 12169 | 584 |
525046 | 525046 | 2020-09-12 | Collier | Florida | 12021 | 12169 | 192 |
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);