ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where deaths = 27, fips = 48075 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 |
---|---|---|---|---|---|---|---|
2215894 | 2215894 | 2022-02-14 | Childress | Texas | 48075 | 2380 | 27 |
2212643 | 2212643 | 2022-02-13 | Childress | Texas | 48075 | 2380 | 27 |
2209390 | 2209390 | 2022-02-12 | Childress | Texas | 48075 | 2377 | 27 |
2206137 | 2206137 | 2022-02-11 | Childress | Texas | 48075 | 2375 | 27 |
2202884 | 2202884 | 2022-02-10 | Childress | Texas | 48075 | 2359 | 27 |
2199630 | 2199630 | 2022-02-09 | Childress | Texas | 48075 | 2326 | 27 |
2196376 | 2196376 | 2022-02-08 | Childress | Texas | 48075 | 2326 | 27 |
2193122 | 2193122 | 2022-02-07 | Childress | Texas | 48075 | 2326 | 27 |
2189868 | 2189868 | 2022-02-06 | Childress | Texas | 48075 | 2325 | 27 |
2186615 | 2186615 | 2022-02-05 | Childress | Texas | 48075 | 2320 | 27 |
2183363 | 2183363 | 2022-02-04 | Childress | Texas | 48075 | 2279 | 27 |
2180111 | 2180111 | 2022-02-03 | Childress | Texas | 48075 | 2272 | 27 |
2176860 | 2176860 | 2022-02-02 | Childress | Texas | 48075 | 2267 | 27 |
2173606 | 2173606 | 2022-02-01 | Childress | Texas | 48075 | 2266 | 27 |
2170354 | 2170354 | 2022-01-31 | Childress | Texas | 48075 | 2266 | 27 |
2167100 | 2167100 | 2022-01-30 | Childress | Texas | 48075 | 2266 | 27 |
2163845 | 2163845 | 2022-01-29 | Childress | Texas | 48075 | 2266 | 27 |
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);