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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
894 | 894 | 2020-03-09 | Larimer | Colorado | 8069 | 1 | 0 |
1029 | 1029 | 2020-03-10 | Larimer | Colorado | 8069 | 1 | 0 |
1196 | 1196 | 2020-03-11 | Larimer | Colorado | 8069 | 1 | 0 |
1404 | 1404 | 2020-03-12 | Larimer | Colorado | 8069 | 1 | 0 |
1666 | 1666 | 2020-03-13 | Larimer | Colorado | 8069 | 1 | 0 |
1985 | 1985 | 2020-03-14 | Larimer | Colorado | 8069 | 1 | 0 |
2367 | 2367 | 2020-03-15 | Larimer | Colorado | 8069 | 1 | 0 |
2802 | 2802 | 2020-03-16 | Larimer | Colorado | 8069 | 2 | 0 |
3284 | 3284 | 2020-03-17 | Larimer | Colorado | 8069 | 2 | 0 |
3838 | 3838 | 2020-03-18 | Larimer | Colorado | 8069 | 4 | 0 |
4500 | 4500 | 2020-03-19 | Larimer | Colorado | 8069 | 5 | 0 |
5276 | 5276 | 2020-03-20 | Larimer | Colorado | 8069 | 7 | 0 |
6202 | 6202 | 2020-03-21 | Larimer | Colorado | 8069 | 19 | 0 |
7237 | 7237 | 2020-03-22 | Larimer | Colorado | 8069 | 32 | 0 |
8381 | 8381 | 2020-03-23 | Larimer | Colorado | 8069 | 34 | 0 |
9626 | 9626 | 2020-03-24 | Larimer | Colorado | 8069 | 43 | 0 |
10999 | 10999 | 2020-03-25 | Larimer | Colorado | 8069 | 45 | 1 |
12545 | 12545 | 2020-03-26 | Larimer | Colorado | 8069 | 61 | 1 |
14213 | 14213 | 2020-03-27 | Larimer | Colorado | 8069 | 67 | 1 |
15996 | 15996 | 2020-03-28 | Larimer | Colorado | 8069 | 79 | 3 |
17886 | 17886 | 2020-03-29 | Larimer | Colorado | 8069 | 84 | 3 |
19864 | 19864 | 2020-03-30 | Larimer | Colorado | 8069 | 92 | 4 |
21940 | 21940 | 2020-03-31 | Larimer | Colorado | 8069 | 99 | 6 |
24099 | 24099 | 2020-04-01 | Larimer | Colorado | 8069 | 107 | 7 |
26329 | 26329 | 2020-04-02 | Larimer | Colorado | 8069 | 124 | 7 |
28629 | 28629 | 2020-04-03 | Larimer | Colorado | 8069 | 134 | 7 |
30986 | 30986 | 2020-04-04 | Larimer | Colorado | 8069 | 144 | 8 |
33392 | 33392 | 2020-04-05 | Larimer | Colorado | 8069 | 153 | 8 |
35837 | 35837 | 2020-04-06 | Larimer | Colorado | 8069 | 158 | 8 |
38327 | 38327 | 2020-04-07 | Larimer | Colorado | 8069 | 161 | 8 |
40870 | 40870 | 2020-04-08 | Larimer | Colorado | 8069 | 167 | 8 |
43443 | 43443 | 2020-04-09 | Larimer | Colorado | 8069 | 174 | 9 |
46043 | 46043 | 2020-04-10 | Larimer | Colorado | 8069 | 177 | 9 |
48673 | 48673 | 2020-04-11 | Larimer | Colorado | 8069 | 180 | 9 |
51335 | 51335 | 2020-04-12 | Larimer | Colorado | 8069 | 187 | 9 |
54014 | 54014 | 2020-04-13 | Larimer | Colorado | 8069 | 193 | 9 |
56706 | 56706 | 2020-04-14 | Larimer | Colorado | 8069 | 198 | 9 |
59414 | 59414 | 2020-04-15 | Larimer | Colorado | 8069 | 202 | 9 |
62133 | 62133 | 2020-04-16 | Larimer | Colorado | 8069 | 217 | 9 |
64866 | 64866 | 2020-04-17 | Larimer | Colorado | 8069 | 224 | 10 |
67614 | 67614 | 2020-04-18 | Larimer | Colorado | 8069 | 231 | 12 |
70376 | 70376 | 2020-04-19 | Larimer | Colorado | 8069 | 239 | 12 |
73145 | 73145 | 2020-04-20 | Larimer | Colorado | 8069 | 245 | 13 |
75921 | 75921 | 2020-04-21 | Larimer | Colorado | 8069 | 250 | 13 |
78705 | 78705 | 2020-04-22 | Larimer | Colorado | 8069 | 266 | 14 |
81499 | 81499 | 2020-04-23 | Larimer | Colorado | 8069 | 274 | 15 |
84299 | 84299 | 2020-04-24 | Larimer | Colorado | 8069 | 291 | 18 |
87107 | 87107 | 2020-04-25 | Larimer | Colorado | 8069 | 303 | 18 |
89924 | 89924 | 2020-04-26 | Larimer | Colorado | 8069 | 312 | 18 |
92742 | 92742 | 2020-04-27 | Larimer | Colorado | 8069 | 321 | 19 |
95574 | 95574 | 2020-04-28 | Larimer | Colorado | 8069 | 334 | 19 |
98419 | 98419 | 2020-04-29 | Larimer | Colorado | 8069 | 348 | 19 |
101269 | 101269 | 2020-04-30 | Larimer | Colorado | 8069 | 363 | 19 |
104124 | 104124 | 2020-05-01 | Larimer | Colorado | 8069 | 377 | 19 |
106989 | 106989 | 2020-05-02 | Larimer | Colorado | 8069 | 384 | 19 |
109858 | 109858 | 2020-05-03 | Larimer | Colorado | 8069 | 395 | 19 |
112733 | 112733 | 2020-05-04 | Larimer | Colorado | 8069 | 393 | 19 |
115616 | 115616 | 2020-05-05 | Larimer | Colorado | 8069 | 409 | 19 |
118575 | 118575 | 2020-05-06 | Larimer | Colorado | 8069 | 415 | 19 |
121544 | 121544 | 2020-05-07 | Larimer | Colorado | 8069 | 423 | 19 |
124524 | 124524 | 2020-05-08 | Larimer | Colorado | 8069 | 437 | 19 |
127510 | 127510 | 2020-05-09 | Larimer | Colorado | 8069 | 444 | 19 |
130501 | 130501 | 2020-05-10 | Larimer | Colorado | 8069 | 448 | 19 |
133492 | 133492 | 2020-05-11 | Larimer | Colorado | 8069 | 452 | 19 |
136481 | 136481 | 2020-05-12 | Larimer | Colorado | 8069 | 455 | 19 |
139472 | 139472 | 2020-05-13 | Larimer | Colorado | 8069 | 456 | 19 |
142468 | 142468 | 2020-05-14 | Larimer | Colorado | 8069 | 463 | 19 |
145468 | 145468 | 2020-05-15 | Larimer | Colorado | 8069 | 472 | 21 |
148471 | 148471 | 2020-05-16 | Larimer | Colorado | 8069 | 485 | 21 |
151480 | 151480 | 2020-05-17 | Larimer | Colorado | 8069 | 489 | 21 |
154492 | 154492 | 2020-05-18 | Larimer | Colorado | 8069 | 495 | 21 |
157508 | 157508 | 2020-05-19 | Larimer | Colorado | 8069 | 508 | 21 |
160534 | 160534 | 2020-05-20 | Larimer | Colorado | 8069 | 512 | 21 |
163562 | 163562 | 2020-05-21 | Larimer | Colorado | 8069 | 517 | 21 |
166595 | 166595 | 2020-05-22 | Larimer | Colorado | 8069 | 520 | 21 |
169632 | 169632 | 2020-05-23 | Larimer | Colorado | 8069 | 530 | 21 |
172673 | 172673 | 2020-05-24 | Larimer | Colorado | 8069 | 537 | 21 |
175717 | 175717 | 2020-05-25 | Larimer | Colorado | 8069 | 540 | 21 |
178761 | 178761 | 2020-05-26 | Larimer | Colorado | 8069 | 544 | 21 |
181805 | 181805 | 2020-05-27 | Larimer | Colorado | 8069 | 552 | 22 |
184859 | 184859 | 2020-05-28 | Larimer | Colorado | 8069 | 567 | 27 |
187915 | 187915 | 2020-05-29 | Larimer | Colorado | 8069 | 570 | 27 |
190980 | 190980 | 2020-05-30 | Larimer | Colorado | 8069 | 576 | 27 |
194047 | 194047 | 2020-05-31 | Larimer | Colorado | 8069 | 583 | 27 |
197117 | 197117 | 2020-06-01 | Larimer | Colorado | 8069 | 589 | 28 |
200190 | 200190 | 2020-06-02 | Larimer | Colorado | 8069 | 589 | 28 |
203266 | 203266 | 2020-06-03 | Larimer | Colorado | 8069 | 606 | 28 |
206346 | 206346 | 2020-06-04 | Larimer | Colorado | 8069 | 610 | 28 |
209427 | 209427 | 2020-06-05 | Larimer | Colorado | 8069 | 613 | 28 |
212512 | 212512 | 2020-06-06 | Larimer | Colorado | 8069 | 616 | 28 |
215599 | 215599 | 2020-06-07 | Larimer | Colorado | 8069 | 619 | 28 |
218690 | 218690 | 2020-06-08 | Larimer | Colorado | 8069 | 628 | 28 |
221785 | 221785 | 2020-06-09 | Larimer | Colorado | 8069 | 632 | 28 |
224880 | 224880 | 2020-06-10 | Larimer | Colorado | 8069 | 636 | 28 |
227982 | 227982 | 2020-06-11 | Larimer | Colorado | 8069 | 635 | 27 |
231085 | 231085 | 2020-06-12 | Larimer | Colorado | 8069 | 637 | 27 |
234191 | 234191 | 2020-06-13 | Larimer | Colorado | 8069 | 641 | 27 |
237298 | 237298 | 2020-06-14 | Larimer | Colorado | 8069 | 647 | 27 |
240406 | 240406 | 2020-06-15 | Larimer | Colorado | 8069 | 652 | 27 |
243517 | 243517 | 2020-06-16 | Larimer | Colorado | 8069 | 659 | 29 |
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);