ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 8051 and state = "Colorado" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1027 | 1027 | 2020-03-10 | Gunnison | Colorado | 8051 | 1 | 0 |
1194 | 1194 | 2020-03-11 | Gunnison | Colorado | 8051 | 3 | 0 |
1402 | 1402 | 2020-03-12 | Gunnison | Colorado | 8051 | 4 | 0 |
1664 | 1664 | 2020-03-13 | Gunnison | Colorado | 8051 | 5 | 0 |
1983 | 1983 | 2020-03-14 | Gunnison | Colorado | 8051 | 7 | 0 |
2365 | 2365 | 2020-03-15 | Gunnison | Colorado | 8051 | 9 | 0 |
2800 | 2800 | 2020-03-16 | Gunnison | Colorado | 8051 | 11 | 0 |
3282 | 3282 | 2020-03-17 | Gunnison | Colorado | 8051 | 11 | 0 |
3836 | 3836 | 2020-03-18 | Gunnison | Colorado | 8051 | 11 | 0 |
4498 | 4498 | 2020-03-19 | Gunnison | Colorado | 8051 | 13 | 0 |
5274 | 5274 | 2020-03-20 | Gunnison | Colorado | 8051 | 13 | 0 |
6199 | 6199 | 2020-03-21 | Gunnison | Colorado | 8051 | 18 | 0 |
7234 | 7234 | 2020-03-22 | Gunnison | Colorado | 8051 | 22 | 0 |
8377 | 8377 | 2020-03-23 | Gunnison | Colorado | 8051 | 28 | 1 |
9621 | 9621 | 2020-03-24 | Gunnison | Colorado | 8051 | 40 | 1 |
10994 | 10994 | 2020-03-25 | Gunnison | Colorado | 8051 | 52 | 1 |
12539 | 12539 | 2020-03-26 | Gunnison | Colorado | 8051 | 57 | 1 |
14207 | 14207 | 2020-03-27 | Gunnison | Colorado | 8051 | 66 | 1 |
15990 | 15990 | 2020-03-28 | Gunnison | Colorado | 8051 | 78 | 1 |
17880 | 17880 | 2020-03-29 | Gunnison | Colorado | 8051 | 79 | 1 |
19858 | 19858 | 2020-03-30 | Gunnison | Colorado | 8051 | 80 | 1 |
21933 | 21933 | 2020-03-31 | Gunnison | Colorado | 8051 | 82 | 1 |
24092 | 24092 | 2020-04-01 | Gunnison | Colorado | 8051 | 84 | 1 |
26322 | 26322 | 2020-04-02 | Gunnison | Colorado | 8051 | 86 | 1 |
28622 | 28622 | 2020-04-03 | Gunnison | Colorado | 8051 | 88 | 1 |
30979 | 30979 | 2020-04-04 | Gunnison | Colorado | 8051 | 90 | 1 |
33385 | 33385 | 2020-04-05 | Gunnison | Colorado | 8051 | 93 | 1 |
35830 | 35830 | 2020-04-06 | Gunnison | Colorado | 8051 | 95 | 1 |
38320 | 38320 | 2020-04-07 | Gunnison | Colorado | 8051 | 95 | 1 |
40863 | 40863 | 2020-04-08 | Gunnison | Colorado | 8051 | 98 | 1 |
43436 | 43436 | 2020-04-09 | Gunnison | Colorado | 8051 | 99 | 2 |
46036 | 46036 | 2020-04-10 | Gunnison | Colorado | 8051 | 101 | 2 |
48666 | 48666 | 2020-04-11 | Gunnison | Colorado | 8051 | 102 | 3 |
51328 | 51328 | 2020-04-12 | Gunnison | Colorado | 8051 | 101 | 3 |
54007 | 54007 | 2020-04-13 | Gunnison | Colorado | 8051 | 99 | 3 |
56699 | 56699 | 2020-04-14 | Gunnison | Colorado | 8051 | 99 | 3 |
59407 | 59407 | 2020-04-15 | Gunnison | Colorado | 8051 | 104 | 3 |
62126 | 62126 | 2020-04-16 | Gunnison | Colorado | 8051 | 111 | 3 |
64859 | 64859 | 2020-04-17 | Gunnison | Colorado | 8051 | 112 | 3 |
67607 | 67607 | 2020-04-18 | Gunnison | Colorado | 8051 | 114 | 3 |
70369 | 70369 | 2020-04-19 | Gunnison | Colorado | 8051 | 114 | 3 |
73138 | 73138 | 2020-04-20 | Gunnison | Colorado | 8051 | 117 | 3 |
75914 | 75914 | 2020-04-21 | Gunnison | Colorado | 8051 | 121 | 3 |
78698 | 78698 | 2020-04-22 | Gunnison | Colorado | 8051 | 121 | 4 |
81492 | 81492 | 2020-04-23 | Gunnison | Colorado | 8051 | 121 | 4 |
84292 | 84292 | 2020-04-24 | Gunnison | Colorado | 8051 | 123 | 4 |
87100 | 87100 | 2020-04-25 | Gunnison | Colorado | 8051 | 151 | 4 |
89917 | 89917 | 2020-04-26 | Gunnison | Colorado | 8051 | 158 | 4 |
92735 | 92735 | 2020-04-27 | Gunnison | Colorado | 8051 | 158 | 4 |
95567 | 95567 | 2020-04-28 | Gunnison | Colorado | 8051 | 161 | 4 |
98412 | 98412 | 2020-04-29 | Gunnison | Colorado | 8051 | 161 | 4 |
101262 | 101262 | 2020-04-30 | Gunnison | Colorado | 8051 | 166 | 5 |
104117 | 104117 | 2020-05-01 | Gunnison | Colorado | 8051 | 164 | 5 |
106982 | 106982 | 2020-05-02 | Gunnison | Colorado | 8051 | 165 | 5 |
109851 | 109851 | 2020-05-03 | Gunnison | Colorado | 8051 | 165 | 5 |
112726 | 112726 | 2020-05-04 | Gunnison | Colorado | 8051 | 168 | 5 |
115609 | 115609 | 2020-05-05 | Gunnison | Colorado | 8051 | 168 | 5 |
118568 | 118568 | 2020-05-06 | Gunnison | Colorado | 8051 | 172 | 6 |
121537 | 121537 | 2020-05-07 | Gunnison | Colorado | 8051 | 173 | 6 |
124517 | 124517 | 2020-05-08 | Gunnison | Colorado | 8051 | 173 | 6 |
127503 | 127503 | 2020-05-09 | Gunnison | Colorado | 8051 | 173 | 6 |
130494 | 130494 | 2020-05-10 | Gunnison | Colorado | 8051 | 173 | 6 |
133485 | 133485 | 2020-05-11 | Gunnison | Colorado | 8051 | 173 | 6 |
136474 | 136474 | 2020-05-12 | Gunnison | Colorado | 8051 | 174 | 6 |
139465 | 139465 | 2020-05-13 | Gunnison | Colorado | 8051 | 180 | 6 |
142461 | 142461 | 2020-05-14 | Gunnison | Colorado | 8051 | 182 | 6 |
145461 | 145461 | 2020-05-15 | Gunnison | Colorado | 8051 | 182 | 6 |
148464 | 148464 | 2020-05-16 | Gunnison | Colorado | 8051 | 182 | 6 |
151473 | 151473 | 2020-05-17 | Gunnison | Colorado | 8051 | 183 | 6 |
154485 | 154485 | 2020-05-18 | Gunnison | Colorado | 8051 | 179 | 6 |
157501 | 157501 | 2020-05-19 | Gunnison | Colorado | 8051 | 179 | 6 |
160527 | 160527 | 2020-05-20 | Gunnison | Colorado | 8051 | 176 | 6 |
163555 | 163555 | 2020-05-21 | Gunnison | Colorado | 8051 | 177 | 6 |
166588 | 166588 | 2020-05-22 | Gunnison | Colorado | 8051 | 177 | 6 |
169625 | 169625 | 2020-05-23 | Gunnison | Colorado | 8051 | 178 | 6 |
172666 | 172666 | 2020-05-24 | Gunnison | Colorado | 8051 | 180 | 6 |
175710 | 175710 | 2020-05-25 | Gunnison | Colorado | 8051 | 179 | 6 |
178754 | 178754 | 2020-05-26 | Gunnison | Colorado | 8051 | 179 | 6 |
181798 | 181798 | 2020-05-27 | Gunnison | Colorado | 8051 | 179 | 6 |
184852 | 184852 | 2020-05-28 | Gunnison | Colorado | 8051 | 179 | 6 |
187908 | 187908 | 2020-05-29 | Gunnison | Colorado | 8051 | 179 | 6 |
190973 | 190973 | 2020-05-30 | Gunnison | Colorado | 8051 | 177 | 6 |
194040 | 194040 | 2020-05-31 | Gunnison | Colorado | 8051 | 177 | 6 |
197110 | 197110 | 2020-06-01 | Gunnison | Colorado | 8051 | 177 | 6 |
200183 | 200183 | 2020-06-02 | Gunnison | Colorado | 8051 | 178 | 6 |
203259 | 203259 | 2020-06-03 | Gunnison | Colorado | 8051 | 178 | 6 |
206339 | 206339 | 2020-06-04 | Gunnison | Colorado | 8051 | 178 | 6 |
209420 | 209420 | 2020-06-05 | Gunnison | Colorado | 8051 | 178 | 6 |
212505 | 212505 | 2020-06-06 | Gunnison | Colorado | 8051 | 178 | 6 |
215592 | 215592 | 2020-06-07 | Gunnison | Colorado | 8051 | 179 | 6 |
218683 | 218683 | 2020-06-08 | Gunnison | Colorado | 8051 | 180 | 6 |
221778 | 221778 | 2020-06-09 | Gunnison | Colorado | 8051 | 181 | 6 |
224873 | 224873 | 2020-06-10 | Gunnison | Colorado | 8051 | 181 | 6 |
227975 | 227975 | 2020-06-11 | Gunnison | Colorado | 8051 | 181 | 6 |
231078 | 231078 | 2020-06-12 | Gunnison | Colorado | 8051 | 181 | 6 |
234184 | 234184 | 2020-06-13 | Gunnison | Colorado | 8051 | 181 | 6 |
237291 | 237291 | 2020-06-14 | Gunnison | Colorado | 8051 | 181 | 6 |
240399 | 240399 | 2020-06-15 | Gunnison | Colorado | 8051 | 181 | 6 |
243510 | 243510 | 2020-06-16 | Gunnison | Colorado | 8051 | 182 | 6 |
246623 | 246623 | 2020-06-17 | Gunnison | Colorado | 8051 | 182 | 6 |
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);