ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Chaffee" sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, 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 |
84277 | 84277 | 2020-04-24 | Chaffee | Colorado | 8015 | 66 | 13 |
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 |
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 |
187891 | 187891 | 2020-05-29 | Chaffee | Colorado | 8015 | 72 | 20 |
190956 | 190956 | 2020-05-30 | Chaffee | Colorado | 8015 | 72 | 20 |
194023 | 194023 | 2020-05-31 | Chaffee | Colorado | 8015 | 72 | 20 |
197093 | 197093 | 2020-06-01 | Chaffee | Colorado | 8015 | 76 | 20 |
200166 | 200166 | 2020-06-02 | Chaffee | Colorado | 8015 | 77 | 20 |
203242 | 203242 | 2020-06-03 | Chaffee | Colorado | 8015 | 76 | 20 |
206322 | 206322 | 2020-06-04 | Chaffee | Colorado | 8015 | 76 | 20 |
209403 | 209403 | 2020-06-05 | Chaffee | Colorado | 8015 | 77 | 20 |
212488 | 212488 | 2020-06-06 | Chaffee | Colorado | 8015 | 78 | 20 |
215575 | 215575 | 2020-06-07 | Chaffee | Colorado | 8015 | 78 | 20 |
218666 | 218666 | 2020-06-08 | Chaffee | Colorado | 8015 | 78 | 20 |
221761 | 221761 | 2020-06-09 | Chaffee | Colorado | 8015 | 78 | 20 |
224856 | 224856 | 2020-06-10 | Chaffee | Colorado | 8015 | 78 | 20 |
227958 | 227958 | 2020-06-11 | Chaffee | Colorado | 8015 | 78 | 20 |
231061 | 231061 | 2020-06-12 | Chaffee | Colorado | 8015 | 78 | 20 |
234167 | 234167 | 2020-06-13 | Chaffee | Colorado | 8015 | 78 | 20 |
237274 | 237274 | 2020-06-14 | Chaffee | Colorado | 8015 | 78 | 20 |
240382 | 240382 | 2020-06-15 | Chaffee | Colorado | 8015 | 78 | 20 |
243493 | 243493 | 2020-06-16 | Chaffee | Colorado | 8015 | 78 | 20 |
246606 | 246606 | 2020-06-17 | Chaffee | Colorado | 8015 | 78 | 20 |
249718 | 249718 | 2020-06-18 | Chaffee | Colorado | 8015 | 78 | 20 |
252833 | 252833 | 2020-06-19 | Chaffee | Colorado | 8015 | 78 | 20 |
255952 | 255952 | 2020-06-20 | Chaffee | Colorado | 8015 | 78 | 20 |
259079 | 259079 | 2020-06-21 | Chaffee | Colorado | 8015 | 78 | 20 |
262206 | 262206 | 2020-06-22 | Chaffee | Colorado | 8015 | 78 | 20 |
265334 | 265334 | 2020-06-23 | Chaffee | Colorado | 8015 | 78 | 20 |
268464 | 268464 | 2020-06-24 | Chaffee | Colorado | 8015 | 78 | 20 |
271599 | 271599 | 2020-06-25 | Chaffee | Colorado | 8015 | 78 | 20 |
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 |
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);