ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where deaths = 40, fips = 48055 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 |
---|---|---|---|---|---|---|---|
874406 | 874406 | 2020-12-28 | Caldwell | Texas | 48055 | 2294 | 40 |
871161 | 871161 | 2020-12-27 | Caldwell | Texas | 48055 | 2293 | 40 |
867916 | 867916 | 2020-12-26 | Caldwell | Texas | 48055 | 2292 | 40 |
864671 | 864671 | 2020-12-25 | Caldwell | Texas | 48055 | 2292 | 40 |
861426 | 861426 | 2020-12-24 | Caldwell | Texas | 48055 | 2292 | 40 |
858181 | 858181 | 2020-12-23 | Caldwell | Texas | 48055 | 2276 | 40 |
854936 | 854936 | 2020-12-22 | Caldwell | Texas | 48055 | 2255 | 40 |
851691 | 851691 | 2020-12-21 | Caldwell | Texas | 48055 | 2230 | 40 |
848446 | 848446 | 2020-12-20 | Caldwell | Texas | 48055 | 2230 | 40 |
845201 | 845201 | 2020-12-19 | Caldwell | Texas | 48055 | 2229 | 40 |
841955 | 841955 | 2020-12-18 | Caldwell | Texas | 48055 | 2206 | 40 |
838710 | 838710 | 2020-12-17 | Caldwell | Texas | 48055 | 2193 | 40 |
835464 | 835464 | 2020-12-16 | Caldwell | Texas | 48055 | 2181 | 40 |
832218 | 832218 | 2020-12-15 | Caldwell | Texas | 48055 | 2156 | 40 |
828971 | 828971 | 2020-12-14 | Caldwell | Texas | 48055 | 2149 | 40 |
825725 | 825725 | 2020-12-13 | Caldwell | Texas | 48055 | 2149 | 40 |
822478 | 822478 | 2020-12-12 | Caldwell | Texas | 48055 | 2146 | 40 |
819232 | 819232 | 2020-12-11 | Caldwell | Texas | 48055 | 2124 | 40 |
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);