ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where cases = 15315 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- Georgia 5
- Alabama 3
- Arkansas 1
- Illinois 1
- Indiana 1
- Louisiana 1
- Minnesota 1
- New York 1
- North Carolina 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2487725 | 2487725 | 2022-05-09 | Vermilion | Louisiana | 22113 | 15315 | 224 |
2402497 | 2402497 | 2022-04-13 | Coles | Illinois | 17029 | 15315 | 175 |
2242335 | 2242335 | 2022-02-22 | Walla Walla | Washington | 53071 | 15315 | 129 |
2233267 | 2233267 | 2022-02-20 | Troup | Georgia | 13285 | 15315 | 361 |
2230016 | 2230016 | 2022-02-19 | Troup | Georgia | 13285 | 15315 | 361 |
2226765 | 2226765 | 2022-02-18 | Troup | Georgia | 13285 | 15315 | 361 |
2201564 | 2201564 | 2022-02-10 | Crow Wing | Minnesota | 27035 | 15315 | 156 |
2170958 | 2170958 | 2022-02-01 | Colbert | Alabama | 1033 | 15315 | 219 |
2137046 | 2137046 | 2022-01-21 | Tompkins | New York | 36109 | 15315 | 75 |
1595732 | 1595732 | 2021-08-08 | Etowah | Alabama | 1055 | 15315 | 372 |
1592483 | 1592483 | 2021-08-07 | Etowah | Alabama | 1055 | 15315 | 372 |
1362131 | 1362131 | 2021-05-28 | Sebastian | Arkansas | 5131 | 15315 | 283 |
1169100 | 1169100 | 2021-03-29 | Onslow | North Carolina | 37133 | 15315 | 139 |
1037702 | 1037702 | 2021-02-17 | Columbia | Georgia | 13073 | 15315 | 179 |
888764 | 888764 | 2021-01-02 | Tippecanoe | Indiana | 18157 | 15315 | 93 |
370316 | 370316 | 2020-07-26 | Gwinnett | Georgia | 13135 | 15315 | 216 |
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);