ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 1, fips = 48385 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
296113 | 296113 | 2020-07-02 | Real | Texas | 48385 | 1 | 0 |
292958 | 292958 | 2020-07-01 | Real | Texas | 48385 | 1 | 0 |
289805 | 289805 | 2020-06-30 | Real | Texas | 48385 | 1 | 0 |
286655 | 286655 | 2020-06-29 | Real | Texas | 48385 | 1 | 0 |
283509 | 283509 | 2020-06-28 | Real | Texas | 48385 | 1 | 0 |
280363 | 280363 | 2020-06-27 | Real | Texas | 48385 | 1 | 0 |
277215 | 277215 | 2020-06-26 | Real | Texas | 48385 | 1 | 0 |
274067 | 274067 | 2020-06-25 | Real | Texas | 48385 | 1 | 0 |
270927 | 270927 | 2020-06-24 | Real | Texas | 48385 | 1 | 0 |
267793 | 267793 | 2020-06-23 | Real | Texas | 48385 | 1 | 0 |
264665 | 264665 | 2020-06-22 | Real | Texas | 48385 | 1 | 0 |
261536 | 261536 | 2020-06-21 | Real | Texas | 48385 | 1 | 0 |
258409 | 258409 | 2020-06-20 | Real | Texas | 48385 | 1 | 0 |
255282 | 255282 | 2020-06-19 | Real | Texas | 48385 | 1 | 0 |
252167 | 252167 | 2020-06-18 | Real | Texas | 48385 | 1 | 0 |
249052 | 249052 | 2020-06-17 | Real | Texas | 48385 | 1 | 0 |
245939 | 245939 | 2020-06-16 | Real | Texas | 48385 | 1 | 0 |
242827 | 242827 | 2020-06-15 | Real | Texas | 48385 | 1 | 0 |
239717 | 239717 | 2020-06-14 | Real | Texas | 48385 | 1 | 0 |
236609 | 236609 | 2020-06-13 | Real | Texas | 48385 | 1 | 0 |
233503 | 233503 | 2020-06-12 | Real | Texas | 48385 | 1 | 0 |
230399 | 230399 | 2020-06-11 | Real | Texas | 48385 | 1 | 0 |
227295 | 227295 | 2020-06-10 | Real | Texas | 48385 | 1 | 0 |
224195 | 224195 | 2020-06-09 | Real | Texas | 48385 | 1 | 0 |
221100 | 221100 | 2020-06-08 | Real | Texas | 48385 | 1 | 0 |
218008 | 218008 | 2020-06-07 | Real | Texas | 48385 | 1 | 0 |
214918 | 214918 | 2020-06-06 | Real | Texas | 48385 | 1 | 0 |
211831 | 211831 | 2020-06-05 | Real | Texas | 48385 | 1 | 0 |
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);