ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 8015 and state = "Colorado" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
6189 | 6189 | 2020-03-21 | Chaffee | Colorado | 8015 | 2 | 0 |
7224 | 7224 | 2020-03-22 | Chaffee | Colorado | 8015 | 3 | 0 |
8367 | 8367 | 2020-03-23 | Chaffee | Colorado | 8015 | 3 | 0 |
9609 | 9609 | 2020-03-24 | Chaffee | Colorado | 8015 | 3 | 0 |
10982 | 10982 | 2020-03-25 | Chaffee | Colorado | 8015 | 3 | 0 |
12527 | 12527 | 2020-03-26 | Chaffee | Colorado | 8015 | 5 | 1 |
14194 | 14194 | 2020-03-27 | Chaffee | Colorado | 8015 | 5 | 1 |
15977 | 15977 | 2020-03-28 | Chaffee | Colorado | 8015 | 11 | 1 |
17867 | 17867 | 2020-03-29 | Chaffee | Colorado | 8015 | 15 | 1 |
19845 | 19845 | 2020-03-30 | Chaffee | Colorado | 8015 | 15 | 1 |
21920 | 21920 | 2020-03-31 | Chaffee | Colorado | 8015 | 17 | 1 |
24079 | 24079 | 2020-04-01 | Chaffee | Colorado | 8015 | 17 | 1 |
26308 | 26308 | 2020-04-02 | Chaffee | Colorado | 8015 | 18 | 2 |
28608 | 28608 | 2020-04-03 | Chaffee | Colorado | 8015 | 19 | 2 |
30965 | 30965 | 2020-04-04 | Chaffee | Colorado | 8015 | 21 | 2 |
33371 | 33371 | 2020-04-05 | Chaffee | Colorado | 8015 | 22 | 2 |
35816 | 35816 | 2020-04-06 | Chaffee | Colorado | 8015 | 22 | 2 |
38306 | 38306 | 2020-04-07 | Chaffee | Colorado | 8015 | 22 | 2 |
40849 | 40849 | 2020-04-08 | Chaffee | Colorado | 8015 | 23 | 2 |
43421 | 43421 | 2020-04-09 | Chaffee | Colorado | 8015 | 26 | 3 |
46021 | 46021 | 2020-04-10 | Chaffee | Colorado | 8015 | 27 | 3 |
48651 | 48651 | 2020-04-11 | Chaffee | Colorado | 8015 | 28 | 3 |
51313 | 51313 | 2020-04-12 | Chaffee | Colorado | 8015 | 28 | 3 |
53992 | 53992 | 2020-04-13 | Chaffee | Colorado | 8015 | 28 | 4 |
56684 | 56684 | 2020-04-14 | Chaffee | Colorado | 8015 | 28 | 4 |
59392 | 59392 | 2020-04-15 | Chaffee | Colorado | 8015 | 31 | 4 |
62111 | 62111 | 2020-04-16 | Chaffee | Colorado | 8015 | 35 | 4 |
64844 | 64844 | 2020-04-17 | Chaffee | Colorado | 8015 | 35 | 4 |
67592 | 67592 | 2020-04-18 | Chaffee | Colorado | 8015 | 37 | 4 |
70354 | 70354 | 2020-04-19 | Chaffee | Colorado | 8015 | 38 | 4 |
73123 | 73123 | 2020-04-20 | Chaffee | Colorado | 8015 | 38 | 4 |
75899 | 75899 | 2020-04-21 | Chaffee | Colorado | 8015 | 38 | 4 |
78683 | 78683 | 2020-04-22 | Chaffee | Colorado | 8015 | 55 | 9 |
81477 | 81477 | 2020-04-23 | Chaffee | Colorado | 8015 | 55 | 9 |
87085 | 87085 | 2020-04-25 | Chaffee | Colorado | 8015 | 65 | 12 |
89902 | 89902 | 2020-04-26 | Chaffee | Colorado | 8015 | 66 | 12 |
92720 | 92720 | 2020-04-27 | Chaffee | Colorado | 8015 | 66 | 12 |
84277 | 84277 | 2020-04-24 | Chaffee | Colorado | 8015 | 66 | 13 |
95552 | 95552 | 2020-04-28 | Chaffee | Colorado | 8015 | 66 | 13 |
98397 | 98397 | 2020-04-29 | Chaffee | Colorado | 8015 | 66 | 15 |
101247 | 101247 | 2020-04-30 | Chaffee | Colorado | 8015 | 66 | 15 |
104102 | 104102 | 2020-05-01 | Chaffee | Colorado | 8015 | 67 | 15 |
106967 | 106967 | 2020-05-02 | Chaffee | Colorado | 8015 | 67 | 15 |
109836 | 109836 | 2020-05-03 | Chaffee | Colorado | 8015 | 67 | 15 |
112711 | 112711 | 2020-05-04 | Chaffee | Colorado | 8015 | 67 | 16 |
115594 | 115594 | 2020-05-05 | Chaffee | Colorado | 8015 | 68 | 16 |
118553 | 118553 | 2020-05-06 | Chaffee | Colorado | 8015 | 68 | 16 |
121520 | 121520 | 2020-05-07 | Chaffee | Colorado | 8015 | 68 | 16 |
124500 | 124500 | 2020-05-08 | Chaffee | Colorado | 8015 | 68 | 16 |
127486 | 127486 | 2020-05-09 | Chaffee | Colorado | 8015 | 68 | 16 |
130477 | 130477 | 2020-05-10 | Chaffee | Colorado | 8015 | 68 | 16 |
133468 | 133468 | 2020-05-11 | Chaffee | Colorado | 8015 | 68 | 16 |
136457 | 136457 | 2020-05-12 | Chaffee | Colorado | 8015 | 68 | 16 |
139448 | 139448 | 2020-05-13 | Chaffee | Colorado | 8015 | 69 | 17 |
142444 | 142444 | 2020-05-14 | Chaffee | Colorado | 8015 | 69 | 17 |
145444 | 145444 | 2020-05-15 | Chaffee | Colorado | 8015 | 69 | 17 |
148447 | 148447 | 2020-05-16 | Chaffee | Colorado | 8015 | 69 | 17 |
151456 | 151456 | 2020-05-17 | Chaffee | Colorado | 8015 | 69 | 17 |
154468 | 154468 | 2020-05-18 | Chaffee | Colorado | 8015 | 69 | 17 |
157484 | 157484 | 2020-05-19 | Chaffee | Colorado | 8015 | 69 | 17 |
160510 | 160510 | 2020-05-20 | Chaffee | Colorado | 8015 | 69 | 18 |
163538 | 163538 | 2020-05-21 | Chaffee | Colorado | 8015 | 69 | 18 |
166571 | 166571 | 2020-05-22 | Chaffee | Colorado | 8015 | 69 | 18 |
169608 | 169608 | 2020-05-23 | Chaffee | Colorado | 8015 | 70 | 18 |
172649 | 172649 | 2020-05-24 | Chaffee | Colorado | 8015 | 70 | 18 |
175693 | 175693 | 2020-05-25 | Chaffee | Colorado | 8015 | 71 | 19 |
178737 | 178737 | 2020-05-26 | Chaffee | Colorado | 8015 | 72 | 19 |
181781 | 181781 | 2020-05-27 | Chaffee | Colorado | 8015 | 71 | 19 |
184835 | 184835 | 2020-05-28 | Chaffee | Colorado | 8015 | 72 | 19 |
274739 | 274739 | 2020-06-26 | Chaffee | Colorado | 8015 | 77 | 19 |
277887 | 277887 | 2020-06-27 | Chaffee | Colorado | 8015 | 77 | 19 |
281034 | 281034 | 2020-06-28 | Chaffee | Colorado | 8015 | 78 | 19 |
284180 | 284180 | 2020-06-29 | Chaffee | Colorado | 8015 | 78 | 19 |
287326 | 287326 | 2020-06-30 | Chaffee | Colorado | 8015 | 77 | 19 |
290477 | 290477 | 2020-07-01 | Chaffee | Colorado | 8015 | 77 | 19 |
293631 | 293631 | 2020-07-02 | Chaffee | Colorado | 8015 | 77 | 19 |
296787 | 296787 | 2020-07-03 | Chaffee | Colorado | 8015 | 77 | 19 |
299949 | 299949 | 2020-07-04 | Chaffee | Colorado | 8015 | 77 | 19 |
303113 | 303113 | 2020-07-05 | Chaffee | Colorado | 8015 | 77 | 19 |
306277 | 306277 | 2020-07-06 | Chaffee | Colorado | 8015 | 78 | 19 |
309445 | 309445 | 2020-07-07 | Chaffee | Colorado | 8015 | 78 | 19 |
312615 | 312615 | 2020-07-08 | Chaffee | Colorado | 8015 | 81 | 19 |
315790 | 315790 | 2020-07-09 | Chaffee | Colorado | 8015 | 81 | 19 |
318963 | 318963 | 2020-07-10 | Chaffee | Colorado | 8015 | 82 | 19 |
322142 | 322142 | 2020-07-11 | Chaffee | Colorado | 8015 | 93 | 19 |
325323 | 325323 | 2020-07-12 | Chaffee | Colorado | 8015 | 116 | 19 |
328509 | 328509 | 2020-07-13 | Chaffee | Colorado | 8015 | 121 | 19 |
331695 | 331695 | 2020-07-14 | Chaffee | Colorado | 8015 | 123 | 19 |
334888 | 334888 | 2020-07-15 | Chaffee | Colorado | 8015 | 123 | 19 |
338083 | 338083 | 2020-07-16 | Chaffee | Colorado | 8015 | 124 | 19 |
341279 | 341279 | 2020-07-17 | Chaffee | Colorado | 8015 | 128 | 19 |
344478 | 344478 | 2020-07-18 | Chaffee | Colorado | 8015 | 210 | 19 |
347678 | 347678 | 2020-07-19 | Chaffee | Colorado | 8015 | 210 | 19 |
350879 | 350879 | 2020-07-20 | Chaffee | Colorado | 8015 | 215 | 19 |
354081 | 354081 | 2020-07-21 | Chaffee | Colorado | 8015 | 215 | 19 |
357284 | 357284 | 2020-07-22 | Chaffee | Colorado | 8015 | 220 | 19 |
360489 | 360489 | 2020-07-23 | Chaffee | Colorado | 8015 | 220 | 19 |
363696 | 363696 | 2020-07-24 | Chaffee | Colorado | 8015 | 224 | 19 |
366903 | 366903 | 2020-07-25 | Chaffee | Colorado | 8015 | 243 | 19 |
370113 | 370113 | 2020-07-26 | Chaffee | Colorado | 8015 | 277 | 19 |
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);