ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where county = "Frio", deaths = 57 and state = "Texas" 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 |
---|---|---|---|---|---|---|---|
1673120 | 1673120 | 2021-08-31 | Frio | Texas | 48163 | 3414 | 57 |
1669872 | 1669872 | 2021-08-30 | Frio | Texas | 48163 | 3386 | 57 |
1666625 | 1666625 | 2021-08-29 | Frio | Texas | 48163 | 3386 | 57 |
1663377 | 1663377 | 2021-08-28 | Frio | Texas | 48163 | 3386 | 57 |
1660129 | 1660129 | 2021-08-27 | Frio | Texas | 48163 | 3386 | 57 |
1656880 | 1656880 | 2021-08-26 | Frio | Texas | 48163 | 3384 | 57 |
1653633 | 1653633 | 2021-08-25 | Frio | Texas | 48163 | 3383 | 57 |
1650386 | 1650386 | 2021-08-24 | Frio | Texas | 48163 | 3372 | 57 |
1647137 | 1647137 | 2021-08-23 | Frio | Texas | 48163 | 3355 | 57 |
1643888 | 1643888 | 2021-08-22 | Frio | Texas | 48163 | 3355 | 57 |
1640638 | 1640638 | 2021-08-21 | Frio | Texas | 48163 | 3355 | 57 |
1637388 | 1637388 | 2021-08-20 | Frio | Texas | 48163 | 3351 | 57 |
1634138 | 1634138 | 2021-08-19 | Frio | Texas | 48163 | 3349 | 57 |
1630891 | 1630891 | 2021-08-18 | Frio | Texas | 48163 | 3340 | 57 |
1627644 | 1627644 | 2021-08-17 | Frio | Texas | 48163 | 3311 | 57 |
1624397 | 1624397 | 2021-08-16 | Frio | Texas | 48163 | 3265 | 57 |
1621150 | 1621150 | 2021-08-15 | Frio | Texas | 48163 | 3265 | 57 |
1617902 | 1617902 | 2021-08-14 | Frio | Texas | 48163 | 3265 | 57 |
1614654 | 1614654 | 2021-08-13 | Frio | Texas | 48163 | 3260 | 57 |
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);