ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 1, county = "Dickens" 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 |
---|---|---|---|---|---|---|---|
230278 | 230278 | 2020-06-11 | Dickens | Texas | 48125 | 1 | 0 |
227174 | 227174 | 2020-06-10 | Dickens | Texas | 48125 | 1 | 0 |
224074 | 224074 | 2020-06-09 | Dickens | Texas | 48125 | 1 | 0 |
220979 | 220979 | 2020-06-08 | Dickens | Texas | 48125 | 1 | 0 |
217887 | 217887 | 2020-06-07 | Dickens | Texas | 48125 | 1 | 0 |
214797 | 214797 | 2020-06-06 | Dickens | Texas | 48125 | 1 | 0 |
211710 | 211710 | 2020-06-05 | Dickens | Texas | 48125 | 1 | 0 |
208626 | 208626 | 2020-06-04 | Dickens | Texas | 48125 | 1 | 0 |
205544 | 205544 | 2020-06-03 | Dickens | Texas | 48125 | 1 | 0 |
202465 | 202465 | 2020-06-02 | Dickens | Texas | 48125 | 1 | 0 |
199390 | 199390 | 2020-06-01 | Dickens | Texas | 48125 | 1 | 0 |
196317 | 196317 | 2020-05-31 | Dickens | Texas | 48125 | 1 | 0 |
193247 | 193247 | 2020-05-30 | Dickens | Texas | 48125 | 1 | 0 |
190182 | 190182 | 2020-05-29 | Dickens | Texas | 48125 | 1 | 0 |
187118 | 187118 | 2020-05-28 | Dickens | Texas | 48125 | 1 | 0 |
184061 | 184061 | 2020-05-27 | Dickens | Texas | 48125 | 1 | 0 |
181011 | 181011 | 2020-05-26 | Dickens | Texas | 48125 | 1 | 0 |
177968 | 177968 | 2020-05-25 | Dickens | Texas | 48125 | 1 | 0 |
174924 | 174924 | 2020-05-24 | Dickens | Texas | 48125 | 1 | 0 |
171881 | 171881 | 2020-05-23 | Dickens | Texas | 48125 | 1 | 0 |
168842 | 168842 | 2020-05-22 | Dickens | Texas | 48125 | 1 | 0 |
165806 | 165806 | 2020-05-21 | Dickens | Texas | 48125 | 1 | 0 |
162777 | 162777 | 2020-05-20 | Dickens | Texas | 48125 | 1 | 0 |
159750 | 159750 | 2020-05-19 | Dickens | Texas | 48125 | 1 | 0 |
156728 | 156728 | 2020-05-18 | Dickens | Texas | 48125 | 1 | 0 |
153711 | 153711 | 2020-05-17 | Dickens | Texas | 48125 | 1 | 0 |
150700 | 150700 | 2020-05-16 | Dickens | Texas | 48125 | 1 | 0 |
147692 | 147692 | 2020-05-15 | Dickens | Texas | 48125 | 1 | 0 |
144690 | 144690 | 2020-05-14 | Dickens | Texas | 48125 | 1 | 0 |
141693 | 141693 | 2020-05-13 | Dickens | Texas | 48125 | 1 | 0 |
138697 | 138697 | 2020-05-12 | Dickens | Texas | 48125 | 1 | 0 |
135707 | 135707 | 2020-05-11 | Dickens | Texas | 48125 | 1 | 0 |
132716 | 132716 | 2020-05-10 | Dickens | Texas | 48125 | 1 | 0 |
129726 | 129726 | 2020-05-09 | Dickens | Texas | 48125 | 1 | 0 |
126737 | 126737 | 2020-05-08 | Dickens | Texas | 48125 | 1 | 0 |
123754 | 123754 | 2020-05-07 | Dickens | Texas | 48125 | 1 | 0 |
120775 | 120775 | 2020-05-06 | Dickens | Texas | 48125 | 1 | 0 |
117811 | 117811 | 2020-05-05 | Dickens | Texas | 48125 | 1 | 0 |
114852 | 114852 | 2020-05-04 | Dickens | Texas | 48125 | 1 | 0 |
111970 | 111970 | 2020-05-03 | Dickens | Texas | 48125 | 1 | 0 |
109096 | 109096 | 2020-05-02 | Dickens | Texas | 48125 | 1 | 0 |
106227 | 106227 | 2020-05-01 | Dickens | Texas | 48125 | 1 | 0 |
103363 | 103363 | 2020-04-30 | Dickens | Texas | 48125 | 1 | 0 |
100510 | 100510 | 2020-04-29 | Dickens | Texas | 48125 | 1 | 0 |
97660 | 97660 | 2020-04-28 | Dickens | Texas | 48125 | 1 | 0 |
94820 | 94820 | 2020-04-27 | Dickens | Texas | 48125 | 1 | 0 |
91991 | 91991 | 2020-04-26 | Dickens | Texas | 48125 | 1 | 0 |
89174 | 89174 | 2020-04-25 | Dickens | Texas | 48125 | 1 | 0 |
86359 | 86359 | 2020-04-24 | Dickens | Texas | 48125 | 1 | 0 |
83554 | 83554 | 2020-04-23 | Dickens | Texas | 48125 | 1 | 0 |
80754 | 80754 | 2020-04-22 | Dickens | Texas | 48125 | 1 | 0 |
77963 | 77963 | 2020-04-21 | Dickens | Texas | 48125 | 1 | 0 |
75181 | 75181 | 2020-04-20 | Dickens | Texas | 48125 | 1 | 0 |
72406 | 72406 | 2020-04-19 | Dickens | Texas | 48125 | 1 | 0 |
69638 | 69638 | 2020-04-18 | Dickens | Texas | 48125 | 1 | 0 |
66878 | 66878 | 2020-04-17 | Dickens | Texas | 48125 | 1 | 0 |
64131 | 64131 | 2020-04-16 | Dickens | Texas | 48125 | 1 | 0 |
61404 | 61404 | 2020-04-15 | Dickens | Texas | 48125 | 1 | 0 |
58687 | 58687 | 2020-04-14 | Dickens | Texas | 48125 | 1 | 0 |
55983 | 55983 | 2020-04-13 | Dickens | Texas | 48125 | 1 | 0 |
47963 | 47963 | 2020-04-10 | Dickens | Texas | 48125 | 1 | 0 |
45343 | 45343 | 2020-04-09 | Dickens | Texas | 48125 | 1 | 0 |
42754 | 42754 | 2020-04-08 | Dickens | Texas | 48125 | 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);