ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 8007 and state = "Colorado" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
19841 | 19841 | 2020-03-30 | Archuleta | Colorado | 8007 | 1 | 0 |
21916 | 21916 | 2020-03-31 | Archuleta | Colorado | 8007 | 1 | 0 |
24075 | 24075 | 2020-04-01 | Archuleta | Colorado | 8007 | 1 | 0 |
26304 | 26304 | 2020-04-02 | Archuleta | Colorado | 8007 | 1 | 0 |
28604 | 28604 | 2020-04-03 | Archuleta | Colorado | 8007 | 1 | 0 |
30961 | 30961 | 2020-04-04 | Archuleta | Colorado | 8007 | 1 | 0 |
33367 | 33367 | 2020-04-05 | Archuleta | Colorado | 8007 | 6 | 0 |
35812 | 35812 | 2020-04-06 | Archuleta | Colorado | 8007 | 6 | 0 |
38302 | 38302 | 2020-04-07 | Archuleta | Colorado | 8007 | 6 | 0 |
40845 | 40845 | 2020-04-08 | Archuleta | Colorado | 8007 | 6 | 0 |
43417 | 43417 | 2020-04-09 | Archuleta | Colorado | 8007 | 6 | 0 |
46017 | 46017 | 2020-04-10 | Archuleta | Colorado | 8007 | 6 | 0 |
48647 | 48647 | 2020-04-11 | Archuleta | Colorado | 8007 | 6 | 0 |
51309 | 51309 | 2020-04-12 | Archuleta | Colorado | 8007 | 6 | 0 |
53988 | 53988 | 2020-04-13 | Archuleta | Colorado | 8007 | 6 | 0 |
56680 | 56680 | 2020-04-14 | Archuleta | Colorado | 8007 | 6 | 0 |
59388 | 59388 | 2020-04-15 | Archuleta | Colorado | 8007 | 6 | 0 |
62107 | 62107 | 2020-04-16 | Archuleta | Colorado | 8007 | 6 | 0 |
64840 | 64840 | 2020-04-17 | Archuleta | Colorado | 8007 | 6 | 0 |
67588 | 67588 | 2020-04-18 | Archuleta | Colorado | 8007 | 7 | 0 |
70350 | 70350 | 2020-04-19 | Archuleta | Colorado | 8007 | 7 | 0 |
73119 | 73119 | 2020-04-20 | Archuleta | Colorado | 8007 | 7 | 0 |
75895 | 75895 | 2020-04-21 | Archuleta | Colorado | 8007 | 7 | 0 |
81473 | 81473 | 2020-04-23 | Archuleta | Colorado | 8007 | 8 | 0 |
84273 | 84273 | 2020-04-24 | Archuleta | Colorado | 8007 | 8 | 0 |
87081 | 87081 | 2020-04-25 | Archuleta | Colorado | 8007 | 8 | 0 |
89898 | 89898 | 2020-04-26 | Archuleta | Colorado | 8007 | 8 | 0 |
92716 | 92716 | 2020-04-27 | Archuleta | Colorado | 8007 | 8 | 0 |
95548 | 95548 | 2020-04-28 | Archuleta | Colorado | 8007 | 8 | 0 |
98393 | 98393 | 2020-04-29 | Archuleta | Colorado | 8007 | 8 | 0 |
101243 | 101243 | 2020-04-30 | Archuleta | Colorado | 8007 | 8 | 0 |
104098 | 104098 | 2020-05-01 | Archuleta | Colorado | 8007 | 8 | 0 |
106963 | 106963 | 2020-05-02 | Archuleta | Colorado | 8007 | 8 | 0 |
109832 | 109832 | 2020-05-03 | Archuleta | Colorado | 8007 | 8 | 0 |
112707 | 112707 | 2020-05-04 | Archuleta | Colorado | 8007 | 8 | 0 |
115590 | 115590 | 2020-05-05 | Archuleta | Colorado | 8007 | 8 | 0 |
118549 | 118549 | 2020-05-06 | Archuleta | Colorado | 8007 | 8 | 0 |
121516 | 121516 | 2020-05-07 | Archuleta | Colorado | 8007 | 8 | 0 |
124496 | 124496 | 2020-05-08 | Archuleta | Colorado | 8007 | 8 | 0 |
127482 | 127482 | 2020-05-09 | Archuleta | Colorado | 8007 | 8 | 0 |
130472 | 130472 | 2020-05-10 | Archuleta | Colorado | 8007 | 8 | 0 |
133463 | 133463 | 2020-05-11 | Archuleta | Colorado | 8007 | 8 | 0 |
136452 | 136452 | 2020-05-12 | Archuleta | Colorado | 8007 | 8 | 0 |
139443 | 139443 | 2020-05-13 | Archuleta | Colorado | 8007 | 8 | 0 |
142439 | 142439 | 2020-05-14 | Archuleta | Colorado | 8007 | 8 | 0 |
145439 | 145439 | 2020-05-15 | Archuleta | Colorado | 8007 | 8 | 0 |
148442 | 148442 | 2020-05-16 | Archuleta | Colorado | 8007 | 8 | 0 |
151451 | 151451 | 2020-05-17 | Archuleta | Colorado | 8007 | 8 | 0 |
154463 | 154463 | 2020-05-18 | Archuleta | Colorado | 8007 | 8 | 0 |
157479 | 157479 | 2020-05-19 | Archuleta | Colorado | 8007 | 8 | 0 |
160505 | 160505 | 2020-05-20 | Archuleta | Colorado | 8007 | 8 | 0 |
163533 | 163533 | 2020-05-21 | Archuleta | Colorado | 8007 | 8 | 0 |
166566 | 166566 | 2020-05-22 | Archuleta | Colorado | 8007 | 8 | 0 |
169603 | 169603 | 2020-05-23 | Archuleta | Colorado | 8007 | 8 | 0 |
172644 | 172644 | 2020-05-24 | Archuleta | Colorado | 8007 | 8 | 0 |
175688 | 175688 | 2020-05-25 | Archuleta | Colorado | 8007 | 8 | 0 |
178732 | 178732 | 2020-05-26 | Archuleta | Colorado | 8007 | 8 | 0 |
181776 | 181776 | 2020-05-27 | Archuleta | Colorado | 8007 | 8 | 0 |
184830 | 184830 | 2020-05-28 | Archuleta | Colorado | 8007 | 8 | 0 |
187886 | 187886 | 2020-05-29 | Archuleta | Colorado | 8007 | 8 | 0 |
190951 | 190951 | 2020-05-30 | Archuleta | Colorado | 8007 | 8 | 0 |
194018 | 194018 | 2020-05-31 | Archuleta | Colorado | 8007 | 8 | 0 |
197088 | 197088 | 2020-06-01 | Archuleta | Colorado | 8007 | 8 | 0 |
200161 | 200161 | 2020-06-02 | Archuleta | Colorado | 8007 | 8 | 0 |
203237 | 203237 | 2020-06-03 | Archuleta | Colorado | 8007 | 8 | 0 |
206317 | 206317 | 2020-06-04 | Archuleta | Colorado | 8007 | 8 | 0 |
209398 | 209398 | 2020-06-05 | Archuleta | Colorado | 8007 | 8 | 0 |
212483 | 212483 | 2020-06-06 | Archuleta | Colorado | 8007 | 8 | 0 |
215570 | 215570 | 2020-06-07 | Archuleta | Colorado | 8007 | 8 | 0 |
218661 | 218661 | 2020-06-08 | Archuleta | Colorado | 8007 | 8 | 0 |
221756 | 221756 | 2020-06-09 | Archuleta | Colorado | 8007 | 8 | 0 |
224851 | 224851 | 2020-06-10 | Archuleta | Colorado | 8007 | 8 | 0 |
227953 | 227953 | 2020-06-11 | Archuleta | Colorado | 8007 | 8 | 0 |
231056 | 231056 | 2020-06-12 | Archuleta | Colorado | 8007 | 8 | 0 |
234162 | 234162 | 2020-06-13 | Archuleta | Colorado | 8007 | 8 | 0 |
237269 | 237269 | 2020-06-14 | Archuleta | Colorado | 8007 | 8 | 0 |
240377 | 240377 | 2020-06-15 | Archuleta | Colorado | 8007 | 8 | 0 |
243488 | 243488 | 2020-06-16 | Archuleta | Colorado | 8007 | 8 | 0 |
246601 | 246601 | 2020-06-17 | Archuleta | Colorado | 8007 | 8 | 0 |
249713 | 249713 | 2020-06-18 | Archuleta | Colorado | 8007 | 8 | 0 |
252828 | 252828 | 2020-06-19 | Archuleta | Colorado | 8007 | 8 | 0 |
255947 | 255947 | 2020-06-20 | Archuleta | Colorado | 8007 | 8 | 0 |
259074 | 259074 | 2020-06-21 | Archuleta | Colorado | 8007 | 8 | 0 |
262201 | 262201 | 2020-06-22 | Archuleta | Colorado | 8007 | 8 | 0 |
268459 | 268459 | 2020-06-24 | Archuleta | Colorado | 8007 | 8 | 0 |
271594 | 271594 | 2020-06-25 | Archuleta | Colorado | 8007 | 8 | 0 |
274734 | 274734 | 2020-06-26 | Archuleta | Colorado | 8007 | 8 | 0 |
277882 | 277882 | 2020-06-27 | Archuleta | Colorado | 8007 | 8 | 0 |
281029 | 281029 | 2020-06-28 | Archuleta | Colorado | 8007 | 8 | 0 |
284175 | 284175 | 2020-06-29 | Archuleta | Colorado | 8007 | 8 | 0 |
287321 | 287321 | 2020-06-30 | Archuleta | Colorado | 8007 | 8 | 0 |
290472 | 290472 | 2020-07-01 | Archuleta | Colorado | 8007 | 8 | 0 |
78679 | 78679 | 2020-04-22 | Archuleta | Colorado | 8007 | 9 | 0 |
265329 | 265329 | 2020-06-23 | Archuleta | Colorado | 8007 | 9 | 0 |
293626 | 293626 | 2020-07-02 | Archuleta | Colorado | 8007 | 9 | 0 |
296782 | 296782 | 2020-07-03 | Archuleta | Colorado | 8007 | 9 | 0 |
299944 | 299944 | 2020-07-04 | Archuleta | Colorado | 8007 | 10 | 0 |
303108 | 303108 | 2020-07-05 | Archuleta | Colorado | 8007 | 10 | 0 |
306272 | 306272 | 2020-07-06 | Archuleta | Colorado | 8007 | 11 | 0 |
309440 | 309440 | 2020-07-07 | Archuleta | Colorado | 8007 | 11 | 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);