ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where deaths = 27, fips = 48471 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 |
---|---|---|---|---|---|---|---|
249089 | 249089 | 2020-06-17 | Walker | Texas | 48471 | 1879 | 27 |
245976 | 245976 | 2020-06-16 | Walker | Texas | 48471 | 1873 | 27 |
242864 | 242864 | 2020-06-15 | Walker | Texas | 48471 | 1878 | 27 |
239754 | 239754 | 2020-06-14 | Walker | Texas | 48471 | 1871 | 27 |
236646 | 236646 | 2020-06-13 | Walker | Texas | 48471 | 1870 | 27 |
233539 | 233539 | 2020-06-12 | Walker | Texas | 48471 | 1868 | 27 |
230435 | 230435 | 2020-06-11 | Walker | Texas | 48471 | 1866 | 27 |
227331 | 227331 | 2020-06-10 | Walker | Texas | 48471 | 1842 | 27 |
224231 | 224231 | 2020-06-09 | Walker | Texas | 48471 | 1868 | 27 |
221135 | 221135 | 2020-06-08 | Walker | Texas | 48471 | 1851 | 27 |
218043 | 218043 | 2020-06-07 | Walker | Texas | 48471 | 1851 | 27 |
214953 | 214953 | 2020-06-06 | Walker | Texas | 48471 | 1850 | 27 |
211866 | 211866 | 2020-06-05 | Walker | Texas | 48471 | 1843 | 27 |
208781 | 208781 | 2020-06-04 | Walker | Texas | 48471 | 1801 | 27 |
205699 | 205699 | 2020-06-03 | Walker | Texas | 48471 | 1730 | 27 |
202620 | 202620 | 2020-06-02 | Walker | Texas | 48471 | 1574 | 27 |
199544 | 199544 | 2020-06-01 | Walker | Texas | 48471 | 1456 | 27 |
196471 | 196471 | 2020-05-31 | Walker | Texas | 48471 | 1455 | 27 |
193401 | 193401 | 2020-05-30 | Walker | Texas | 48471 | 945 | 27 |
190335 | 190335 | 2020-05-29 | Walker | Texas | 48471 | 869 | 27 |
187271 | 187271 | 2020-05-28 | Walker | Texas | 48471 | 869 | 27 |
184214 | 184214 | 2020-05-27 | Walker | Texas | 48471 | 716 | 27 |
181163 | 181163 | 2020-05-26 | Walker | Texas | 48471 | 475 | 27 |
178119 | 178119 | 2020-05-25 | Walker | Texas | 48471 | 475 | 27 |
175074 | 175074 | 2020-05-24 | Walker | Texas | 48471 | 474 | 27 |
172031 | 172031 | 2020-05-23 | Walker | Texas | 48471 | 462 | 27 |
168991 | 168991 | 2020-05-22 | Walker | Texas | 48471 | 430 | 27 |
165955 | 165955 | 2020-05-21 | Walker | Texas | 48471 | 430 | 27 |
162926 | 162926 | 2020-05-20 | Walker | Texas | 48471 | 552 | 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);