ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 8069 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
312640 | 312640 | 2020-07-08 | Larimer | Colorado | 8069 | 843 | 30 |
309470 | 309470 | 2020-07-07 | Larimer | Colorado | 8069 | 818 | 29 |
306302 | 306302 | 2020-07-06 | Larimer | Colorado | 8069 | 808 | 29 |
303138 | 303138 | 2020-07-05 | Larimer | Colorado | 8069 | 803 | 29 |
299974 | 299974 | 2020-07-04 | Larimer | Colorado | 8069 | 791 | 29 |
296812 | 296812 | 2020-07-03 | Larimer | Colorado | 8069 | 777 | 29 |
293656 | 293656 | 2020-07-02 | Larimer | Colorado | 8069 | 757 | 29 |
290502 | 290502 | 2020-07-01 | Larimer | Colorado | 8069 | 747 | 29 |
287351 | 287351 | 2020-06-30 | Larimer | Colorado | 8069 | 736 | 29 |
284205 | 284205 | 2020-06-29 | Larimer | Colorado | 8069 | 723 | 29 |
281059 | 281059 | 2020-06-28 | Larimer | Colorado | 8069 | 718 | 29 |
277912 | 277912 | 2020-06-27 | Larimer | Colorado | 8069 | 713 | 29 |
274764 | 274764 | 2020-06-26 | Larimer | Colorado | 8069 | 701 | 29 |
271624 | 271624 | 2020-06-25 | Larimer | Colorado | 8069 | 692 | 29 |
268488 | 268488 | 2020-06-24 | Larimer | Colorado | 8069 | 686 | 29 |
265358 | 265358 | 2020-06-23 | Larimer | Colorado | 8069 | 683 | 29 |
262230 | 262230 | 2020-06-22 | Larimer | Colorado | 8069 | 680 | 29 |
259103 | 259103 | 2020-06-21 | Larimer | Colorado | 8069 | 680 | 29 |
255976 | 255976 | 2020-06-20 | Larimer | Colorado | 8069 | 673 | 29 |
252857 | 252857 | 2020-06-19 | Larimer | Colorado | 8069 | 668 | 29 |
249742 | 249742 | 2020-06-18 | Larimer | Colorado | 8069 | 661 | 29 |
246630 | 246630 | 2020-06-17 | Larimer | Colorado | 8069 | 658 | 29 |
243517 | 243517 | 2020-06-16 | Larimer | Colorado | 8069 | 659 | 29 |
240406 | 240406 | 2020-06-15 | Larimer | Colorado | 8069 | 652 | 27 |
237298 | 237298 | 2020-06-14 | Larimer | Colorado | 8069 | 647 | 27 |
234191 | 234191 | 2020-06-13 | Larimer | Colorado | 8069 | 641 | 27 |
231085 | 231085 | 2020-06-12 | Larimer | Colorado | 8069 | 637 | 27 |
227982 | 227982 | 2020-06-11 | Larimer | Colorado | 8069 | 635 | 27 |
224880 | 224880 | 2020-06-10 | Larimer | Colorado | 8069 | 636 | 28 |
221785 | 221785 | 2020-06-09 | Larimer | Colorado | 8069 | 632 | 28 |
218690 | 218690 | 2020-06-08 | Larimer | Colorado | 8069 | 628 | 28 |
215599 | 215599 | 2020-06-07 | Larimer | Colorado | 8069 | 619 | 28 |
212512 | 212512 | 2020-06-06 | Larimer | Colorado | 8069 | 616 | 28 |
209427 | 209427 | 2020-06-05 | Larimer | Colorado | 8069 | 613 | 28 |
206346 | 206346 | 2020-06-04 | Larimer | Colorado | 8069 | 610 | 28 |
203266 | 203266 | 2020-06-03 | Larimer | Colorado | 8069 | 606 | 28 |
200190 | 200190 | 2020-06-02 | Larimer | Colorado | 8069 | 589 | 28 |
197117 | 197117 | 2020-06-01 | Larimer | Colorado | 8069 | 589 | 28 |
194047 | 194047 | 2020-05-31 | Larimer | Colorado | 8069 | 583 | 27 |
190980 | 190980 | 2020-05-30 | Larimer | Colorado | 8069 | 576 | 27 |
187915 | 187915 | 2020-05-29 | Larimer | Colorado | 8069 | 570 | 27 |
184859 | 184859 | 2020-05-28 | Larimer | Colorado | 8069 | 567 | 27 |
181805 | 181805 | 2020-05-27 | Larimer | Colorado | 8069 | 552 | 22 |
178761 | 178761 | 2020-05-26 | Larimer | Colorado | 8069 | 544 | 21 |
175717 | 175717 | 2020-05-25 | Larimer | Colorado | 8069 | 540 | 21 |
172673 | 172673 | 2020-05-24 | Larimer | Colorado | 8069 | 537 | 21 |
169632 | 169632 | 2020-05-23 | Larimer | Colorado | 8069 | 530 | 21 |
166595 | 166595 | 2020-05-22 | Larimer | Colorado | 8069 | 520 | 21 |
163562 | 163562 | 2020-05-21 | Larimer | Colorado | 8069 | 517 | 21 |
160534 | 160534 | 2020-05-20 | Larimer | Colorado | 8069 | 512 | 21 |
157508 | 157508 | 2020-05-19 | Larimer | Colorado | 8069 | 508 | 21 |
154492 | 154492 | 2020-05-18 | Larimer | Colorado | 8069 | 495 | 21 |
151480 | 151480 | 2020-05-17 | Larimer | Colorado | 8069 | 489 | 21 |
148471 | 148471 | 2020-05-16 | Larimer | Colorado | 8069 | 485 | 21 |
145468 | 145468 | 2020-05-15 | Larimer | Colorado | 8069 | 472 | 21 |
142468 | 142468 | 2020-05-14 | Larimer | Colorado | 8069 | 463 | 19 |
139472 | 139472 | 2020-05-13 | Larimer | Colorado | 8069 | 456 | 19 |
136481 | 136481 | 2020-05-12 | Larimer | Colorado | 8069 | 455 | 19 |
133492 | 133492 | 2020-05-11 | Larimer | Colorado | 8069 | 452 | 19 |
130501 | 130501 | 2020-05-10 | Larimer | Colorado | 8069 | 448 | 19 |
127510 | 127510 | 2020-05-09 | Larimer | Colorado | 8069 | 444 | 19 |
124524 | 124524 | 2020-05-08 | Larimer | Colorado | 8069 | 437 | 19 |
121544 | 121544 | 2020-05-07 | Larimer | Colorado | 8069 | 423 | 19 |
118575 | 118575 | 2020-05-06 | Larimer | Colorado | 8069 | 415 | 19 |
115616 | 115616 | 2020-05-05 | Larimer | Colorado | 8069 | 409 | 19 |
112733 | 112733 | 2020-05-04 | Larimer | Colorado | 8069 | 393 | 19 |
109858 | 109858 | 2020-05-03 | Larimer | Colorado | 8069 | 395 | 19 |
106989 | 106989 | 2020-05-02 | Larimer | Colorado | 8069 | 384 | 19 |
104124 | 104124 | 2020-05-01 | Larimer | Colorado | 8069 | 377 | 19 |
101269 | 101269 | 2020-04-30 | Larimer | Colorado | 8069 | 363 | 19 |
98419 | 98419 | 2020-04-29 | Larimer | Colorado | 8069 | 348 | 19 |
95574 | 95574 | 2020-04-28 | Larimer | Colorado | 8069 | 334 | 19 |
92742 | 92742 | 2020-04-27 | Larimer | Colorado | 8069 | 321 | 19 |
89924 | 89924 | 2020-04-26 | Larimer | Colorado | 8069 | 312 | 18 |
87107 | 87107 | 2020-04-25 | Larimer | Colorado | 8069 | 303 | 18 |
84299 | 84299 | 2020-04-24 | Larimer | Colorado | 8069 | 291 | 18 |
81499 | 81499 | 2020-04-23 | Larimer | Colorado | 8069 | 274 | 15 |
78705 | 78705 | 2020-04-22 | Larimer | Colorado | 8069 | 266 | 14 |
75921 | 75921 | 2020-04-21 | Larimer | Colorado | 8069 | 250 | 13 |
73145 | 73145 | 2020-04-20 | Larimer | Colorado | 8069 | 245 | 13 |
70376 | 70376 | 2020-04-19 | Larimer | Colorado | 8069 | 239 | 12 |
67614 | 67614 | 2020-04-18 | Larimer | Colorado | 8069 | 231 | 12 |
64866 | 64866 | 2020-04-17 | Larimer | Colorado | 8069 | 224 | 10 |
62133 | 62133 | 2020-04-16 | Larimer | Colorado | 8069 | 217 | 9 |
59414 | 59414 | 2020-04-15 | Larimer | Colorado | 8069 | 202 | 9 |
56706 | 56706 | 2020-04-14 | Larimer | Colorado | 8069 | 198 | 9 |
54014 | 54014 | 2020-04-13 | Larimer | Colorado | 8069 | 193 | 9 |
51335 | 51335 | 2020-04-12 | Larimer | Colorado | 8069 | 187 | 9 |
48673 | 48673 | 2020-04-11 | Larimer | Colorado | 8069 | 180 | 9 |
46043 | 46043 | 2020-04-10 | Larimer | Colorado | 8069 | 177 | 9 |
43443 | 43443 | 2020-04-09 | Larimer | Colorado | 8069 | 174 | 9 |
40870 | 40870 | 2020-04-08 | Larimer | Colorado | 8069 | 167 | 8 |
38327 | 38327 | 2020-04-07 | Larimer | Colorado | 8069 | 161 | 8 |
35837 | 35837 | 2020-04-06 | Larimer | Colorado | 8069 | 158 | 8 |
33392 | 33392 | 2020-04-05 | Larimer | Colorado | 8069 | 153 | 8 |
30986 | 30986 | 2020-04-04 | Larimer | Colorado | 8069 | 144 | 8 |
28629 | 28629 | 2020-04-03 | Larimer | Colorado | 8069 | 134 | 7 |
26329 | 26329 | 2020-04-02 | Larimer | Colorado | 8069 | 124 | 7 |
24099 | 24099 | 2020-04-01 | Larimer | Colorado | 8069 | 107 | 7 |
21940 | 21940 | 2020-03-31 | Larimer | Colorado | 8069 | 99 | 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);