ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
11 rows where cases = 15263 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 10
- New York 2
- Arizona 1
- Connecticut 1
- Florida 1
- Georgia 1
- Iowa 1
- Maryland 1
- Mississippi 1
- South Carolina 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2269710 | 2269710 | 2022-03-03 | Cecil | Maryland | 24015 | 15263 | 254 |
2003739 | 2003739 | 2021-12-11 | Oswego | New York | 36075 | 15263 | 138 |
1489429 | 1489429 | 2021-07-06 | Woodbury | Iowa | 19193 | 15263 | 230 |
1357349 | 1357349 | 2021-05-26 | Saratoga | New York | 36091 | 15263 | 167 |
1131042 | 1131042 | 2021-03-17 | Cache | Utah | 49005 | 15263 | 39 |
1065662 | 1065662 | 2021-02-25 | Beaufort | South Carolina | 45013 | 15263 | 178 |
1030890 | 1030890 | 2021-02-15 | Navajo | Arizona | 4017 | 15263 | 474 |
895907 | 895907 | 2021-01-04 | DeSoto | Mississippi | 28033 | 15263 | 141 |
891740 | 891740 | 2021-01-03 | Richmond | Georgia | 13245 | 15263 | 255 |
709831 | 709831 | 2020-11-08 | Collier | Florida | 12021 | 15263 | 259 |
628707 | 628707 | 2020-10-14 | New Haven | Connecticut | 9009 | 15263 | 1119 |
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);