ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 8039 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386204 | 386204 | 2020-07-31 | Elbert | Colorado | 8039 | 85 | 2 |
382986 | 382986 | 2020-07-30 | Elbert | Colorado | 8039 | 83 | 2 |
379769 | 379769 | 2020-07-29 | Elbert | Colorado | 8039 | 82 | 2 |
376552 | 376552 | 2020-07-28 | Elbert | Colorado | 8039 | 81 | 2 |
373338 | 373338 | 2020-07-27 | Elbert | Colorado | 8039 | 79 | 2 |
370126 | 370126 | 2020-07-26 | Elbert | Colorado | 8039 | 77 | 2 |
366916 | 366916 | 2020-07-25 | Elbert | Colorado | 8039 | 77 | 2 |
363709 | 363709 | 2020-07-24 | Elbert | Colorado | 8039 | 76 | 2 |
360502 | 360502 | 2020-07-23 | Elbert | Colorado | 8039 | 76 | 2 |
357297 | 357297 | 2020-07-22 | Elbert | Colorado | 8039 | 75 | 2 |
354094 | 354094 | 2020-07-21 | Elbert | Colorado | 8039 | 73 | 2 |
350892 | 350892 | 2020-07-20 | Elbert | Colorado | 8039 | 70 | 2 |
347691 | 347691 | 2020-07-19 | Elbert | Colorado | 8039 | 69 | 2 |
344491 | 344491 | 2020-07-18 | Elbert | Colorado | 8039 | 68 | 2 |
341292 | 341292 | 2020-07-17 | Elbert | Colorado | 8039 | 67 | 2 |
338095 | 338095 | 2020-07-16 | Elbert | Colorado | 8039 | 67 | 2 |
334900 | 334900 | 2020-07-15 | Elbert | Colorado | 8039 | 67 | 2 |
331707 | 331707 | 2020-07-14 | Elbert | Colorado | 8039 | 65 | 2 |
328521 | 328521 | 2020-07-13 | Elbert | Colorado | 8039 | 63 | 2 |
325335 | 325335 | 2020-07-12 | Elbert | Colorado | 8039 | 62 | 2 |
322154 | 322154 | 2020-07-11 | Elbert | Colorado | 8039 | 62 | 2 |
318975 | 318975 | 2020-07-10 | Elbert | Colorado | 8039 | 61 | 2 |
315802 | 315802 | 2020-07-09 | Elbert | Colorado | 8039 | 60 | 2 |
312627 | 312627 | 2020-07-08 | Elbert | Colorado | 8039 | 60 | 2 |
309457 | 309457 | 2020-07-07 | Elbert | Colorado | 8039 | 60 | 2 |
306289 | 306289 | 2020-07-06 | Elbert | Colorado | 8039 | 58 | 2 |
303125 | 303125 | 2020-07-05 | Elbert | Colorado | 8039 | 57 | 2 |
299961 | 299961 | 2020-07-04 | Elbert | Colorado | 8039 | 57 | 2 |
296799 | 296799 | 2020-07-03 | Elbert | Colorado | 8039 | 57 | 2 |
293643 | 293643 | 2020-07-02 | Elbert | Colorado | 8039 | 57 | 2 |
290489 | 290489 | 2020-07-01 | Elbert | Colorado | 8039 | 57 | 2 |
287338 | 287338 | 2020-06-30 | Elbert | Colorado | 8039 | 57 | 2 |
284192 | 284192 | 2020-06-29 | Elbert | Colorado | 8039 | 57 | 2 |
281046 | 281046 | 2020-06-28 | Elbert | Colorado | 8039 | 57 | 2 |
277899 | 277899 | 2020-06-27 | Elbert | Colorado | 8039 | 56 | 2 |
274751 | 274751 | 2020-06-26 | Elbert | Colorado | 8039 | 56 | 2 |
271611 | 271611 | 2020-06-25 | Elbert | Colorado | 8039 | 55 | 2 |
268476 | 268476 | 2020-06-24 | Elbert | Colorado | 8039 | 54 | 2 |
265346 | 265346 | 2020-06-23 | Elbert | Colorado | 8039 | 54 | 2 |
262218 | 262218 | 2020-06-22 | Elbert | Colorado | 8039 | 54 | 2 |
259091 | 259091 | 2020-06-21 | Elbert | Colorado | 8039 | 54 | 2 |
255964 | 255964 | 2020-06-20 | Elbert | Colorado | 8039 | 54 | 2 |
252845 | 252845 | 2020-06-19 | Elbert | Colorado | 8039 | 54 | 2 |
249730 | 249730 | 2020-06-18 | Elbert | Colorado | 8039 | 54 | 2 |
246618 | 246618 | 2020-06-17 | Elbert | Colorado | 8039 | 54 | 2 |
243505 | 243505 | 2020-06-16 | Elbert | Colorado | 8039 | 54 | 2 |
240394 | 240394 | 2020-06-15 | Elbert | Colorado | 8039 | 54 | 2 |
237286 | 237286 | 2020-06-14 | Elbert | Colorado | 8039 | 54 | 2 |
234179 | 234179 | 2020-06-13 | Elbert | Colorado | 8039 | 54 | 2 |
231073 | 231073 | 2020-06-12 | Elbert | Colorado | 8039 | 54 | 2 |
227970 | 227970 | 2020-06-11 | Elbert | Colorado | 8039 | 54 | 2 |
224868 | 224868 | 2020-06-10 | Elbert | Colorado | 8039 | 54 | 2 |
221773 | 221773 | 2020-06-09 | Elbert | Colorado | 8039 | 57 | 2 |
218678 | 218678 | 2020-06-08 | Elbert | Colorado | 8039 | 56 | 2 |
215587 | 215587 | 2020-06-07 | Elbert | Colorado | 8039 | 54 | 2 |
212500 | 212500 | 2020-06-06 | Elbert | Colorado | 8039 | 54 | 2 |
209415 | 209415 | 2020-06-05 | Elbert | Colorado | 8039 | 53 | 2 |
206334 | 206334 | 2020-06-04 | Elbert | Colorado | 8039 | 53 | 2 |
203254 | 203254 | 2020-06-03 | Elbert | Colorado | 8039 | 53 | 2 |
200178 | 200178 | 2020-06-02 | Elbert | Colorado | 8039 | 53 | 2 |
197105 | 197105 | 2020-06-01 | Elbert | Colorado | 8039 | 53 | 2 |
194035 | 194035 | 2020-05-31 | Elbert | Colorado | 8039 | 53 | 2 |
190968 | 190968 | 2020-05-30 | Elbert | Colorado | 8039 | 52 | 2 |
187903 | 187903 | 2020-05-29 | Elbert | Colorado | 8039 | 52 | 2 |
184847 | 184847 | 2020-05-28 | Elbert | Colorado | 8039 | 51 | 2 |
181793 | 181793 | 2020-05-27 | Elbert | Colorado | 8039 | 51 | 2 |
178749 | 178749 | 2020-05-26 | Elbert | Colorado | 8039 | 49 | 2 |
175705 | 175705 | 2020-05-25 | Elbert | Colorado | 8039 | 49 | 2 |
172661 | 172661 | 2020-05-24 | Elbert | Colorado | 8039 | 48 | 2 |
169620 | 169620 | 2020-05-23 | Elbert | Colorado | 8039 | 48 | 2 |
166583 | 166583 | 2020-05-22 | Elbert | Colorado | 8039 | 48 | 2 |
163550 | 163550 | 2020-05-21 | Elbert | Colorado | 8039 | 48 | 2 |
160522 | 160522 | 2020-05-20 | Elbert | Colorado | 8039 | 48 | 2 |
157496 | 157496 | 2020-05-19 | Elbert | Colorado | 8039 | 47 | 2 |
154480 | 154480 | 2020-05-18 | Elbert | Colorado | 8039 | 47 | 2 |
151468 | 151468 | 2020-05-17 | Elbert | Colorado | 8039 | 45 | 2 |
148459 | 148459 | 2020-05-16 | Elbert | Colorado | 8039 | 44 | 2 |
145456 | 145456 | 2020-05-15 | Elbert | Colorado | 8039 | 42 | 2 |
142456 | 142456 | 2020-05-14 | Elbert | Colorado | 8039 | 41 | 2 |
139460 | 139460 | 2020-05-13 | Elbert | Colorado | 8039 | 41 | 2 |
136469 | 136469 | 2020-05-12 | Elbert | Colorado | 8039 | 40 | 2 |
133480 | 133480 | 2020-05-11 | Elbert | Colorado | 8039 | 39 | 1 |
130489 | 130489 | 2020-05-10 | Elbert | Colorado | 8039 | 39 | 1 |
127498 | 127498 | 2020-05-09 | Elbert | Colorado | 8039 | 39 | 1 |
124512 | 124512 | 2020-05-08 | Elbert | Colorado | 8039 | 39 | 1 |
121532 | 121532 | 2020-05-07 | Elbert | Colorado | 8039 | 37 | 1 |
118563 | 118563 | 2020-05-06 | Elbert | Colorado | 8039 | 37 | 1 |
115604 | 115604 | 2020-05-05 | Elbert | Colorado | 8039 | 36 | 1 |
112721 | 112721 | 2020-05-04 | Elbert | Colorado | 8039 | 32 | 1 |
109846 | 109846 | 2020-05-03 | Elbert | Colorado | 8039 | 31 | 1 |
106977 | 106977 | 2020-05-02 | Elbert | Colorado | 8039 | 31 | 1 |
104112 | 104112 | 2020-05-01 | Elbert | Colorado | 8039 | 30 | 1 |
101257 | 101257 | 2020-04-30 | Elbert | Colorado | 8039 | 29 | 1 |
98407 | 98407 | 2020-04-29 | Elbert | Colorado | 8039 | 28 | 1 |
95562 | 95562 | 2020-04-28 | Elbert | Colorado | 8039 | 27 | 1 |
92730 | 92730 | 2020-04-27 | Elbert | Colorado | 8039 | 27 | 1 |
89912 | 89912 | 2020-04-26 | Elbert | Colorado | 8039 | 27 | 1 |
87095 | 87095 | 2020-04-25 | Elbert | Colorado | 8039 | 27 | 1 |
84287 | 84287 | 2020-04-24 | Elbert | Colorado | 8039 | 27 | 1 |
81487 | 81487 | 2020-04-23 | Elbert | Colorado | 8039 | 26 | 1 |
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);