ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 8029 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 |
---|---|---|---|---|---|---|---|
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 |
21924 | 21924 | 2020-03-31 | Delta | Colorado | 8029 | 1 | 0 |
24083 | 24083 | 2020-04-01 | Delta | Colorado | 8029 | 1 | 0 |
26313 | 26313 | 2020-04-02 | Delta | Colorado | 8029 | 1 | 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 |
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 |
43426 | 43426 | 2020-04-09 | Delta | Colorado | 8029 | 6 | 1 |
46026 | 46026 | 2020-04-10 | Delta | Colorado | 8029 | 6 | 1 |
48656 | 48656 | 2020-04-11 | Delta | Colorado | 8029 | 6 | 1 |
51318 | 51318 | 2020-04-12 | Delta | Colorado | 8029 | 6 | 1 |
53997 | 53997 | 2020-04-13 | Delta | Colorado | 8029 | 7 | 1 |
56689 | 56689 | 2020-04-14 | Delta | Colorado | 8029 | 12 | 1 |
59397 | 59397 | 2020-04-15 | Delta | Colorado | 8029 | 12 | 1 |
62116 | 62116 | 2020-04-16 | Delta | Colorado | 8029 | 13 | 1 |
64849 | 64849 | 2020-04-17 | Delta | Colorado | 8029 | 16 | 1 |
67597 | 67597 | 2020-04-18 | Delta | Colorado | 8029 | 19 | 1 |
70359 | 70359 | 2020-04-19 | Delta | Colorado | 8029 | 22 | 1 |
73128 | 73128 | 2020-04-20 | Delta | Colorado | 8029 | 25 | 1 |
75904 | 75904 | 2020-04-21 | Delta | Colorado | 8029 | 25 | 1 |
78688 | 78688 | 2020-04-22 | Delta | Colorado | 8029 | 25 | 1 |
81482 | 81482 | 2020-04-23 | Delta | Colorado | 8029 | 25 | 1 |
84282 | 84282 | 2020-04-24 | Delta | Colorado | 8029 | 26 | 1 |
87090 | 87090 | 2020-04-25 | Delta | Colorado | 8029 | 26 | 1 |
89907 | 89907 | 2020-04-26 | Delta | Colorado | 8029 | 27 | 1 |
92725 | 92725 | 2020-04-27 | Delta | Colorado | 8029 | 33 | 1 |
95557 | 95557 | 2020-04-28 | Delta | Colorado | 8029 | 34 | 1 |
98402 | 98402 | 2020-04-29 | Delta | Colorado | 8029 | 43 | 1 |
101252 | 101252 | 2020-04-30 | Delta | Colorado | 8029 | 44 | 1 |
104107 | 104107 | 2020-05-01 | Delta | Colorado | 8029 | 46 | 1 |
106972 | 106972 | 2020-05-02 | Delta | Colorado | 8029 | 48 | 1 |
109841 | 109841 | 2020-05-03 | Delta | Colorado | 8029 | 50 | 1 |
112716 | 112716 | 2020-05-04 | Delta | Colorado | 8029 | 51 | 1 |
115599 | 115599 | 2020-05-05 | Delta | Colorado | 8029 | 52 | 1 |
118558 | 118558 | 2020-05-06 | Delta | Colorado | 8029 | 52 | 1 |
121527 | 121527 | 2020-05-07 | Delta | Colorado | 8029 | 53 | 1 |
124507 | 124507 | 2020-05-08 | Delta | Colorado | 8029 | 54 | 1 |
127493 | 127493 | 2020-05-09 | Delta | Colorado | 8029 | 54 | 1 |
130484 | 130484 | 2020-05-10 | Delta | Colorado | 8029 | 55 | 1 |
133475 | 133475 | 2020-05-11 | Delta | Colorado | 8029 | 55 | 1 |
136464 | 136464 | 2020-05-12 | Delta | Colorado | 8029 | 55 | 1 |
139455 | 139455 | 2020-05-13 | Delta | Colorado | 8029 | 54 | 1 |
142451 | 142451 | 2020-05-14 | Delta | Colorado | 8029 | 54 | 1 |
145451 | 145451 | 2020-05-15 | Delta | Colorado | 8029 | 54 | 1 |
148454 | 148454 | 2020-05-16 | Delta | Colorado | 8029 | 55 | 1 |
151463 | 151463 | 2020-05-17 | Delta | Colorado | 8029 | 55 | 1 |
154475 | 154475 | 2020-05-18 | Delta | Colorado | 8029 | 55 | 1 |
157491 | 157491 | 2020-05-19 | Delta | Colorado | 8029 | 55 | 1 |
160517 | 160517 | 2020-05-20 | Delta | Colorado | 8029 | 55 | 1 |
163545 | 163545 | 2020-05-21 | Delta | Colorado | 8029 | 57 | 1 |
166578 | 166578 | 2020-05-22 | Delta | Colorado | 8029 | 61 | 1 |
169615 | 169615 | 2020-05-23 | Delta | Colorado | 8029 | 65 | 1 |
172656 | 172656 | 2020-05-24 | Delta | Colorado | 8029 | 67 | 1 |
175700 | 175700 | 2020-05-25 | Delta | Colorado | 8029 | 67 | 1 |
178744 | 178744 | 2020-05-26 | Delta | Colorado | 8029 | 67 | 1 |
181788 | 181788 | 2020-05-27 | Delta | Colorado | 8029 | 67 | 1 |
184842 | 184842 | 2020-05-28 | Delta | Colorado | 8029 | 67 | 1 |
187898 | 187898 | 2020-05-29 | Delta | Colorado | 8029 | 68 | 1 |
190963 | 190963 | 2020-05-30 | Delta | Colorado | 8029 | 69 | 1 |
194030 | 194030 | 2020-05-31 | Delta | Colorado | 8029 | 69 | 1 |
197100 | 197100 | 2020-06-01 | Delta | Colorado | 8029 | 69 | 1 |
200173 | 200173 | 2020-06-02 | Delta | Colorado | 8029 | 71 | 1 |
203249 | 203249 | 2020-06-03 | Delta | Colorado | 8029 | 72 | 1 |
206329 | 206329 | 2020-06-04 | Delta | Colorado | 8029 | 72 | 1 |
209410 | 209410 | 2020-06-05 | Delta | Colorado | 8029 | 72 | 1 |
212495 | 212495 | 2020-06-06 | Delta | Colorado | 8029 | 74 | 1 |
215582 | 215582 | 2020-06-07 | Delta | Colorado | 8029 | 76 | 1 |
218673 | 218673 | 2020-06-08 | Delta | Colorado | 8029 | 76 | 1 |
221768 | 221768 | 2020-06-09 | Delta | Colorado | 8029 | 76 | 1 |
224863 | 224863 | 2020-06-10 | Delta | Colorado | 8029 | 76 | 1 |
227965 | 227965 | 2020-06-11 | Delta | Colorado | 8029 | 76 | 1 |
231068 | 231068 | 2020-06-12 | Delta | Colorado | 8029 | 76 | 1 |
234174 | 234174 | 2020-06-13 | Delta | Colorado | 8029 | 76 | 1 |
237281 | 237281 | 2020-06-14 | Delta | Colorado | 8029 | 77 | 1 |
240389 | 240389 | 2020-06-15 | Delta | Colorado | 8029 | 78 | 1 |
243500 | 243500 | 2020-06-16 | Delta | Colorado | 8029 | 78 | 1 |
246613 | 246613 | 2020-06-17 | Delta | Colorado | 8029 | 79 | 1 |
249725 | 249725 | 2020-06-18 | Delta | Colorado | 8029 | 80 | 1 |
252840 | 252840 | 2020-06-19 | Delta | Colorado | 8029 | 80 | 1 |
255959 | 255959 | 2020-06-20 | Delta | Colorado | 8029 | 80 | 1 |
259086 | 259086 | 2020-06-21 | Delta | Colorado | 8029 | 80 | 1 |
262213 | 262213 | 2020-06-22 | Delta | Colorado | 8029 | 80 | 1 |
265341 | 265341 | 2020-06-23 | Delta | Colorado | 8029 | 80 | 1 |
268471 | 268471 | 2020-06-24 | Delta | Colorado | 8029 | 81 | 1 |
271606 | 271606 | 2020-06-25 | Delta | Colorado | 8029 | 81 | 1 |
274746 | 274746 | 2020-06-26 | Delta | Colorado | 8029 | 82 | 1 |
277894 | 277894 | 2020-06-27 | Delta | Colorado | 8029 | 82 | 1 |
281041 | 281041 | 2020-06-28 | Delta | Colorado | 8029 | 82 | 1 |
284187 | 284187 | 2020-06-29 | Delta | Colorado | 8029 | 82 | 1 |
287333 | 287333 | 2020-06-30 | Delta | Colorado | 8029 | 83 | 1 |
290484 | 290484 | 2020-07-01 | Delta | Colorado | 8029 | 84 | 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);