ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,322 rows where county = "Delta" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
county 1
- Delta · 2,322 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
9612 | 9612 | 2020-03-24 | Delta | Colorado | 8029 | 1 | 0 |
10985 | 10985 | 2020-03-25 | Delta | Colorado | 8029 | 1 | 0 |
12530 | 12530 | 2020-03-26 | Delta | Colorado | 8029 | 1 | 0 |
15981 | 15981 | 2020-03-28 | Delta | Colorado | 8029 | 1 | 0 |
17871 | 17871 | 2020-03-29 | Delta | Colorado | 8029 | 1 | 0 |
19849 | 19849 | 2020-03-30 | Delta | Colorado | 8029 | 1 | 0 |
20524 | 20524 | 2020-03-30 | Delta | Michigan | 26041 | 1 | 0 |
21924 | 21924 | 2020-03-31 | Delta | Colorado | 8029 | 1 | 0 |
22635 | 22635 | 2020-03-31 | Delta | Michigan | 26041 | 1 | 0 |
24083 | 24083 | 2020-04-01 | Delta | Colorado | 8029 | 1 | 0 |
26313 | 26313 | 2020-04-02 | Delta | Colorado | 8029 | 1 | 0 |
42752 | 42752 | 2020-04-08 | Delta | Texas | 48119 | 1 | 0 |
45341 | 45341 | 2020-04-09 | Delta | Texas | 48119 | 1 | 0 |
47961 | 47961 | 2020-04-10 | Delta | Texas | 48119 | 1 | 0 |
50618 | 50618 | 2020-04-11 | Delta | Texas | 48119 | 1 | 0 |
53293 | 53293 | 2020-04-12 | Delta | Texas | 48119 | 1 | 0 |
55981 | 55981 | 2020-04-13 | Delta | Texas | 48119 | 1 | 0 |
58685 | 58685 | 2020-04-14 | Delta | Texas | 48119 | 1 | 0 |
61402 | 61402 | 2020-04-15 | Delta | Texas | 48119 | 1 | 0 |
64129 | 64129 | 2020-04-16 | Delta | Texas | 48119 | 1 | 0 |
66876 | 66876 | 2020-04-17 | Delta | Texas | 48119 | 1 | 0 |
69636 | 69636 | 2020-04-18 | Delta | Texas | 48119 | 1 | 0 |
72404 | 72404 | 2020-04-19 | Delta | Texas | 48119 | 1 | 0 |
75179 | 75179 | 2020-04-20 | Delta | Texas | 48119 | 1 | 0 |
77961 | 77961 | 2020-04-21 | Delta | Texas | 48119 | 1 | 0 |
80752 | 80752 | 2020-04-22 | Delta | Texas | 48119 | 1 | 0 |
83552 | 83552 | 2020-04-23 | Delta | Texas | 48119 | 1 | 0 |
86357 | 86357 | 2020-04-24 | Delta | Texas | 48119 | 1 | 0 |
89172 | 89172 | 2020-04-25 | Delta | Texas | 48119 | 1 | 0 |
91989 | 91989 | 2020-04-26 | Delta | Texas | 48119 | 1 | 0 |
94818 | 94818 | 2020-04-27 | Delta | Texas | 48119 | 1 | 0 |
97658 | 97658 | 2020-04-28 | Delta | Texas | 48119 | 1 | 0 |
100508 | 100508 | 2020-04-29 | Delta | Texas | 48119 | 1 | 0 |
103361 | 103361 | 2020-04-30 | Delta | Texas | 48119 | 1 | 0 |
106225 | 106225 | 2020-05-01 | Delta | Texas | 48119 | 1 | 0 |
109094 | 109094 | 2020-05-02 | Delta | Texas | 48119 | 1 | 0 |
111968 | 111968 | 2020-05-03 | Delta | Texas | 48119 | 1 | 0 |
114850 | 114850 | 2020-05-04 | Delta | Texas | 48119 | 1 | 0 |
117809 | 117809 | 2020-05-05 | Delta | Texas | 48119 | 1 | 0 |
120773 | 120773 | 2020-05-06 | Delta | Texas | 48119 | 1 | 0 |
123752 | 123752 | 2020-05-07 | Delta | Texas | 48119 | 1 | 0 |
126735 | 126735 | 2020-05-08 | Delta | Texas | 48119 | 1 | 0 |
129724 | 129724 | 2020-05-09 | Delta | Texas | 48119 | 1 | 0 |
132714 | 132714 | 2020-05-10 | Delta | Texas | 48119 | 1 | 0 |
135705 | 135705 | 2020-05-11 | Delta | Texas | 48119 | 1 | 0 |
138695 | 138695 | 2020-05-12 | Delta | Texas | 48119 | 1 | 0 |
141691 | 141691 | 2020-05-13 | Delta | Texas | 48119 | 1 | 0 |
144688 | 144688 | 2020-05-14 | Delta | Texas | 48119 | 1 | 0 |
147690 | 147690 | 2020-05-15 | Delta | Texas | 48119 | 1 | 0 |
150698 | 150698 | 2020-05-16 | Delta | Texas | 48119 | 1 | 0 |
153709 | 153709 | 2020-05-17 | Delta | Texas | 48119 | 1 | 0 |
156726 | 156726 | 2020-05-18 | Delta | Texas | 48119 | 1 | 0 |
159748 | 159748 | 2020-05-19 | Delta | Texas | 48119 | 1 | 0 |
162775 | 162775 | 2020-05-20 | Delta | Texas | 48119 | 1 | 0 |
165804 | 165804 | 2020-05-21 | Delta | Texas | 48119 | 1 | 0 |
168840 | 168840 | 2020-05-22 | Delta | Texas | 48119 | 1 | 0 |
171879 | 171879 | 2020-05-23 | Delta | Texas | 48119 | 1 | 0 |
174922 | 174922 | 2020-05-24 | Delta | Texas | 48119 | 1 | 0 |
177966 | 177966 | 2020-05-25 | Delta | Texas | 48119 | 1 | 0 |
181009 | 181009 | 2020-05-26 | Delta | Texas | 48119 | 1 | 0 |
184059 | 184059 | 2020-05-27 | Delta | Texas | 48119 | 1 | 0 |
187116 | 187116 | 2020-05-28 | Delta | Texas | 48119 | 1 | 0 |
190180 | 190180 | 2020-05-29 | Delta | Texas | 48119 | 1 | 0 |
193245 | 193245 | 2020-05-30 | Delta | Texas | 48119 | 1 | 0 |
196315 | 196315 | 2020-05-31 | Delta | Texas | 48119 | 1 | 0 |
199388 | 199388 | 2020-06-01 | Delta | Texas | 48119 | 1 | 0 |
202463 | 202463 | 2020-06-02 | Delta | Texas | 48119 | 1 | 0 |
14198 | 14198 | 2020-03-27 | Delta | Colorado | 8029 | 2 | 0 |
205542 | 205542 | 2020-06-03 | Delta | Texas | 48119 | 2 | 0 |
208624 | 208624 | 2020-06-04 | Delta | Texas | 48119 | 2 | 0 |
211708 | 211708 | 2020-06-05 | Delta | Texas | 48119 | 2 | 0 |
214795 | 214795 | 2020-06-06 | Delta | Texas | 48119 | 2 | 0 |
217885 | 217885 | 2020-06-07 | Delta | Texas | 48119 | 2 | 0 |
220977 | 220977 | 2020-06-08 | Delta | Texas | 48119 | 2 | 0 |
224072 | 224072 | 2020-06-09 | Delta | Texas | 48119 | 2 | 0 |
227172 | 227172 | 2020-06-10 | Delta | Texas | 48119 | 2 | 0 |
230276 | 230276 | 2020-06-11 | Delta | Texas | 48119 | 2 | 0 |
233380 | 233380 | 2020-06-12 | Delta | Texas | 48119 | 2 | 0 |
236486 | 236486 | 2020-06-13 | Delta | Texas | 48119 | 2 | 0 |
239594 | 239594 | 2020-06-14 | Delta | Texas | 48119 | 2 | 0 |
242704 | 242704 | 2020-06-15 | Delta | Texas | 48119 | 2 | 0 |
245816 | 245816 | 2020-06-16 | Delta | Texas | 48119 | 2 | 0 |
24814 | 24814 | 2020-04-01 | Delta | Michigan | 26041 | 3 | 0 |
248929 | 248929 | 2020-06-17 | Delta | Texas | 48119 | 3 | 0 |
252044 | 252044 | 2020-06-18 | Delta | Texas | 48119 | 3 | 0 |
27066 | 27066 | 2020-04-02 | Delta | Michigan | 26041 | 4 | 0 |
28613 | 28613 | 2020-04-03 | Delta | Colorado | 8029 | 4 | 0 |
30970 | 30970 | 2020-04-04 | Delta | Colorado | 8029 | 4 | 0 |
33376 | 33376 | 2020-04-05 | Delta | Colorado | 8029 | 4 | 0 |
255159 | 255159 | 2020-06-19 | Delta | Texas | 48119 | 4 | 0 |
258286 | 258286 | 2020-06-20 | Delta | Texas | 48119 | 4 | 0 |
261413 | 261413 | 2020-06-21 | Delta | Texas | 48119 | 4 | 0 |
264541 | 264541 | 2020-06-22 | Delta | Texas | 48119 | 4 | 0 |
267669 | 267669 | 2020-06-23 | Delta | Texas | 48119 | 4 | 0 |
29384 | 29384 | 2020-04-03 | Delta | Michigan | 26041 | 5 | 0 |
31762 | 31762 | 2020-04-04 | Delta | Michigan | 26041 | 5 | 0 |
35821 | 35821 | 2020-04-06 | Delta | Colorado | 8029 | 5 | 0 |
38311 | 38311 | 2020-04-07 | Delta | Colorado | 8029 | 5 | 0 |
40854 | 40854 | 2020-04-08 | Delta | Colorado | 8029 | 5 | 1 |
270803 | 270803 | 2020-06-24 | Delta | Texas | 48119 | 5 | 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);