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 county
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 |
14198 | 14198 | 2020-03-27 | Delta | Colorado | 8029 | 2 | 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 |
24814 | 24814 | 2020-04-01 | Delta | Michigan | 26041 | 3 | 0 |
26313 | 26313 | 2020-04-02 | Delta | Colorado | 8029 | 1 | 0 |
27066 | 27066 | 2020-04-02 | Delta | Michigan | 26041 | 4 | 0 |
28613 | 28613 | 2020-04-03 | Delta | Colorado | 8029 | 4 | 0 |
29384 | 29384 | 2020-04-03 | Delta | Michigan | 26041 | 5 | 0 |
30970 | 30970 | 2020-04-04 | Delta | Colorado | 8029 | 4 | 0 |
31762 | 31762 | 2020-04-04 | Delta | Michigan | 26041 | 5 | 0 |
33376 | 33376 | 2020-04-05 | Delta | Colorado | 8029 | 4 | 0 |
34187 | 34187 | 2020-04-05 | Delta | Michigan | 26041 | 7 | 0 |
35821 | 35821 | 2020-04-06 | Delta | Colorado | 8029 | 5 | 0 |
36646 | 36646 | 2020-04-06 | Delta | Michigan | 26041 | 7 | 0 |
38311 | 38311 | 2020-04-07 | Delta | Colorado | 8029 | 5 | 0 |
39154 | 39154 | 2020-04-07 | Delta | Michigan | 26041 | 7 | 0 |
40854 | 40854 | 2020-04-08 | Delta | Colorado | 8029 | 5 | 1 |
41706 | 41706 | 2020-04-08 | Delta | Michigan | 26041 | 8 | 0 |
42752 | 42752 | 2020-04-08 | Delta | Texas | 48119 | 1 | 0 |
43426 | 43426 | 2020-04-09 | Delta | Colorado | 8029 | 6 | 1 |
44282 | 44282 | 2020-04-09 | Delta | Michigan | 26041 | 9 | 1 |
45341 | 45341 | 2020-04-09 | Delta | Texas | 48119 | 1 | 0 |
46026 | 46026 | 2020-04-10 | Delta | Colorado | 8029 | 6 | 1 |
46890 | 46890 | 2020-04-10 | Delta | Michigan | 26041 | 9 | 1 |
47961 | 47961 | 2020-04-10 | Delta | Texas | 48119 | 1 | 0 |
48656 | 48656 | 2020-04-11 | Delta | Colorado | 8029 | 6 | 1 |
49533 | 49533 | 2020-04-11 | Delta | Michigan | 26041 | 9 | 1 |
50618 | 50618 | 2020-04-11 | Delta | Texas | 48119 | 1 | 0 |
51318 | 51318 | 2020-04-12 | Delta | Colorado | 8029 | 6 | 1 |
52203 | 52203 | 2020-04-12 | Delta | Michigan | 26041 | 9 | 1 |
53293 | 53293 | 2020-04-12 | Delta | Texas | 48119 | 1 | 0 |
53997 | 53997 | 2020-04-13 | Delta | Colorado | 8029 | 7 | 1 |
54884 | 54884 | 2020-04-13 | Delta | Michigan | 26041 | 9 | 1 |
55981 | 55981 | 2020-04-13 | Delta | Texas | 48119 | 1 | 0 |
56689 | 56689 | 2020-04-14 | Delta | Colorado | 8029 | 12 | 1 |
57582 | 57582 | 2020-04-14 | Delta | Michigan | 26041 | 9 | 1 |
58685 | 58685 | 2020-04-14 | Delta | Texas | 48119 | 1 | 0 |
59397 | 59397 | 2020-04-15 | Delta | Colorado | 8029 | 12 | 1 |
60292 | 60292 | 2020-04-15 | Delta | Michigan | 26041 | 9 | 1 |
61402 | 61402 | 2020-04-15 | Delta | Texas | 48119 | 1 | 0 |
62116 | 62116 | 2020-04-16 | Delta | Colorado | 8029 | 13 | 1 |
63014 | 63014 | 2020-04-16 | Delta | Michigan | 26041 | 10 | 1 |
64129 | 64129 | 2020-04-16 | Delta | Texas | 48119 | 1 | 0 |
64849 | 64849 | 2020-04-17 | Delta | Colorado | 8029 | 16 | 1 |
65752 | 65752 | 2020-04-17 | Delta | Michigan | 26041 | 10 | 1 |
66876 | 66876 | 2020-04-17 | Delta | Texas | 48119 | 1 | 0 |
67597 | 67597 | 2020-04-18 | Delta | Colorado | 8029 | 19 | 1 |
68503 | 68503 | 2020-04-18 | Delta | Michigan | 26041 | 12 | 1 |
69636 | 69636 | 2020-04-18 | Delta | Texas | 48119 | 1 | 0 |
70359 | 70359 | 2020-04-19 | Delta | Colorado | 8029 | 22 | 1 |
71267 | 71267 | 2020-04-19 | Delta | Michigan | 26041 | 12 | 1 |
72404 | 72404 | 2020-04-19 | Delta | Texas | 48119 | 1 | 0 |
73128 | 73128 | 2020-04-20 | Delta | Colorado | 8029 | 25 | 1 |
74039 | 74039 | 2020-04-20 | Delta | Michigan | 26041 | 13 | 1 |
75179 | 75179 | 2020-04-20 | Delta | Texas | 48119 | 1 | 0 |
75904 | 75904 | 2020-04-21 | Delta | Colorado | 8029 | 25 | 1 |
76819 | 76819 | 2020-04-21 | Delta | Michigan | 26041 | 12 | 2 |
77961 | 77961 | 2020-04-21 | Delta | Texas | 48119 | 1 | 0 |
78688 | 78688 | 2020-04-22 | Delta | Colorado | 8029 | 25 | 1 |
79605 | 79605 | 2020-04-22 | Delta | Michigan | 26041 | 12 | 2 |
80752 | 80752 | 2020-04-22 | Delta | Texas | 48119 | 1 | 0 |
81482 | 81482 | 2020-04-23 | Delta | Colorado | 8029 | 25 | 1 |
82400 | 82400 | 2020-04-23 | Delta | Michigan | 26041 | 12 | 2 |
83552 | 83552 | 2020-04-23 | Delta | Texas | 48119 | 1 | 0 |
84282 | 84282 | 2020-04-24 | Delta | Colorado | 8029 | 26 | 1 |
85204 | 85204 | 2020-04-24 | Delta | Michigan | 26041 | 12 | 2 |
86357 | 86357 | 2020-04-24 | Delta | Texas | 48119 | 1 | 0 |
87090 | 87090 | 2020-04-25 | Delta | Colorado | 8029 | 26 | 1 |
88014 | 88014 | 2020-04-25 | Delta | Michigan | 26041 | 12 | 2 |
89172 | 89172 | 2020-04-25 | Delta | Texas | 48119 | 1 | 0 |
89907 | 89907 | 2020-04-26 | Delta | Colorado | 8029 | 27 | 1 |
90830 | 90830 | 2020-04-26 | Delta | Michigan | 26041 | 12 | 2 |
91989 | 91989 | 2020-04-26 | Delta | Texas | 48119 | 1 | 0 |
92725 | 92725 | 2020-04-27 | Delta | Colorado | 8029 | 33 | 1 |
93651 | 93651 | 2020-04-27 | Delta | Michigan | 26041 | 13 | 2 |
94818 | 94818 | 2020-04-27 | Delta | Texas | 48119 | 1 | 0 |
95557 | 95557 | 2020-04-28 | Delta | Colorado | 8029 | 34 | 1 |
96486 | 96486 | 2020-04-28 | Delta | Michigan | 26041 | 13 | 2 |
97658 | 97658 | 2020-04-28 | Delta | Texas | 48119 | 1 | 0 |
98402 | 98402 | 2020-04-29 | Delta | Colorado | 8029 | 43 | 1 |
99332 | 99332 | 2020-04-29 | Delta | Michigan | 26041 | 13 | 2 |
100508 | 100508 | 2020-04-29 | Delta | Texas | 48119 | 1 | 0 |
101252 | 101252 | 2020-04-30 | Delta | Colorado | 8029 | 44 | 1 |
102184 | 102184 | 2020-04-30 | Delta | Michigan | 26041 | 13 | 2 |
103361 | 103361 | 2020-04-30 | Delta | Texas | 48119 | 1 | 0 |
104107 | 104107 | 2020-05-01 | Delta | Colorado | 8029 | 46 | 1 |
105044 | 105044 | 2020-05-01 | Delta | Michigan | 26041 | 13 | 2 |
106225 | 106225 | 2020-05-01 | Delta | Texas | 48119 | 1 | 0 |
106972 | 106972 | 2020-05-02 | Delta | Colorado | 8029 | 48 | 1 |
107908 | 107908 | 2020-05-02 | Delta | Michigan | 26041 | 13 | 2 |
109094 | 109094 | 2020-05-02 | Delta | Texas | 48119 | 1 | 0 |
109841 | 109841 | 2020-05-03 | Delta | Colorado | 8029 | 50 | 1 |
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);