ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where county = "Hidalgo" and deaths = 8 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
919017 | 919017 | 2021-01-11 | Hidalgo | New Mexico | 35023 | 278 | 8 |
915772 | 915772 | 2021-01-10 | Hidalgo | New Mexico | 35023 | 276 | 8 |
912527 | 912527 | 2021-01-09 | Hidalgo | New Mexico | 35023 | 272 | 8 |
909282 | 909282 | 2021-01-08 | Hidalgo | New Mexico | 35023 | 270 | 8 |
906036 | 906036 | 2021-01-07 | Hidalgo | New Mexico | 35023 | 265 | 8 |
902791 | 902791 | 2021-01-06 | Hidalgo | New Mexico | 35023 | 258 | 8 |
899546 | 899546 | 2021-01-05 | Hidalgo | New Mexico | 35023 | 254 | 8 |
896301 | 896301 | 2021-01-04 | Hidalgo | New Mexico | 35023 | 254 | 8 |
893054 | 893054 | 2021-01-03 | Hidalgo | New Mexico | 35023 | 255 | 8 |
889808 | 889808 | 2021-01-02 | Hidalgo | New Mexico | 35023 | 243 | 8 |
886562 | 886562 | 2021-01-01 | Hidalgo | New Mexico | 35023 | 242 | 8 |
883317 | 883317 | 2020-12-31 | Hidalgo | New Mexico | 35023 | 240 | 8 |
138736 | 138736 | 2020-05-12 | Hidalgo | Texas | 48215 | 403 | 8 |
135746 | 135746 | 2020-05-11 | Hidalgo | Texas | 48215 | 394 | 8 |
132755 | 132755 | 2020-05-10 | Hidalgo | Texas | 48215 | 389 | 8 |
129765 | 129765 | 2020-05-09 | Hidalgo | Texas | 48215 | 387 | 8 |
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);