ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where deaths = 2701 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 4
- New York 6
- Connecticut 4
- Florida 3
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2395680 | 2395680 | 2022-04-11 | Fairfield | Connecticut | 9001 | 204191 | 2701 |
2392424 | 2392424 | 2022-04-10 | Fairfield | Connecticut | 9001 | 203593 | 2701 |
2389168 | 2389168 | 2022-04-09 | Fairfield | Connecticut | 9001 | 203593 | 2701 |
2385913 | 2385913 | 2022-04-08 | Fairfield | Connecticut | 9001 | 203593 | 2701 |
2351720 | 2351720 | 2022-03-28 | Westchester | New York | 36119 | 249660 | 2701 |
1354909 | 1354909 | 2021-05-25 | El Paso | Texas | 48141 | 135927 | 2701 |
1216217 | 1216217 | 2021-04-13 | Palm Beach | Florida | 12099 | 136673 | 2701 |
1190186 | 1190186 | 2021-04-05 | Broward | Florida | 12011 | 218184 | 2701 |
1186939 | 1186939 | 2021-04-04 | Broward | Florida | 12011 | 217780 | 2701 |
333279 | 333279 | 2020-07-14 | Nassau | New York | 36059 | 42423 | 2701 |
330089 | 330089 | 2020-07-13 | Nassau | New York | 36059 | 42354 | 2701 |
326902 | 326902 | 2020-07-12 | Nassau | New York | 36059 | 42307 | 2701 |
323718 | 323718 | 2020-07-11 | Nassau | New York | 36059 | 42267 | 2701 |
320538 | 320538 | 2020-07-10 | Nassau | New York | 36059 | 42232 | 2701 |
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);