ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Adams", fips = 8001 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386183 | 386183 | 2020-07-31 | Adams | Colorado | 8001 | 5957 | 171 |
382965 | 382965 | 2020-07-30 | Adams | Colorado | 8001 | 5868 | 168 |
379748 | 379748 | 2020-07-29 | Adams | Colorado | 8001 | 5794 | 168 |
376531 | 376531 | 2020-07-28 | Adams | Colorado | 8001 | 5713 | 168 |
373317 | 373317 | 2020-07-27 | Adams | Colorado | 8001 | 5626 | 167 |
370105 | 370105 | 2020-07-26 | Adams | Colorado | 8001 | 5587 | 167 |
366895 | 366895 | 2020-07-25 | Adams | Colorado | 8001 | 5535 | 167 |
363688 | 363688 | 2020-07-24 | Adams | Colorado | 8001 | 5433 | 167 |
360481 | 360481 | 2020-07-23 | Adams | Colorado | 8001 | 5312 | 167 |
357276 | 357276 | 2020-07-22 | Adams | Colorado | 8001 | 5248 | 164 |
354073 | 354073 | 2020-07-21 | Adams | Colorado | 8001 | 5184 | 163 |
350871 | 350871 | 2020-07-20 | Adams | Colorado | 8001 | 5133 | 163 |
347670 | 347670 | 2020-07-19 | Adams | Colorado | 8001 | 5094 | 161 |
344470 | 344470 | 2020-07-18 | Adams | Colorado | 8001 | 5058 | 161 |
341271 | 341271 | 2020-07-17 | Adams | Colorado | 8001 | 5024 | 161 |
338075 | 338075 | 2020-07-16 | Adams | Colorado | 8001 | 4972 | 159 |
334880 | 334880 | 2020-07-15 | Adams | Colorado | 8001 | 4916 | 159 |
331687 | 331687 | 2020-07-14 | Adams | Colorado | 8001 | 4847 | 159 |
328501 | 328501 | 2020-07-13 | Adams | Colorado | 8001 | 4788 | 158 |
325315 | 325315 | 2020-07-12 | Adams | Colorado | 8001 | 4757 | 158 |
322134 | 322134 | 2020-07-11 | Adams | Colorado | 8001 | 4719 | 158 |
318955 | 318955 | 2020-07-10 | Adams | Colorado | 8001 | 4669 | 157 |
315782 | 315782 | 2020-07-09 | Adams | Colorado | 8001 | 4588 | 156 |
312607 | 312607 | 2020-07-08 | Adams | Colorado | 8001 | 4546 | 156 |
309437 | 309437 | 2020-07-07 | Adams | Colorado | 8001 | 4478 | 156 |
306269 | 306269 | 2020-07-06 | Adams | Colorado | 8001 | 4400 | 156 |
303105 | 303105 | 2020-07-05 | Adams | Colorado | 8001 | 4362 | 156 |
299941 | 299941 | 2020-07-04 | Adams | Colorado | 8001 | 4322 | 156 |
296779 | 296779 | 2020-07-03 | Adams | Colorado | 8001 | 4293 | 156 |
293623 | 293623 | 2020-07-02 | Adams | Colorado | 8001 | 4267 | 156 |
290469 | 290469 | 2020-07-01 | Adams | Colorado | 8001 | 4226 | 156 |
287318 | 287318 | 2020-06-30 | Adams | Colorado | 8001 | 4185 | 155 |
284172 | 284172 | 2020-06-29 | Adams | Colorado | 8001 | 4170 | 155 |
281026 | 281026 | 2020-06-28 | Adams | Colorado | 8001 | 4148 | 154 |
277879 | 277879 | 2020-06-27 | Adams | Colorado | 8001 | 4093 | 154 |
274731 | 274731 | 2020-06-26 | Adams | Colorado | 8001 | 4058 | 154 |
271591 | 271591 | 2020-06-25 | Adams | Colorado | 8001 | 4013 | 154 |
268456 | 268456 | 2020-06-24 | Adams | Colorado | 8001 | 3971 | 154 |
265326 | 265326 | 2020-06-23 | Adams | Colorado | 8001 | 3941 | 154 |
262198 | 262198 | 2020-06-22 | Adams | Colorado | 8001 | 3932 | 153 |
259071 | 259071 | 2020-06-21 | Adams | Colorado | 8001 | 3909 | 152 |
255944 | 255944 | 2020-06-20 | Adams | Colorado | 8001 | 3872 | 152 |
252825 | 252825 | 2020-06-19 | Adams | Colorado | 8001 | 3852 | 150 |
249710 | 249710 | 2020-06-18 | Adams | Colorado | 8001 | 3819 | 149 |
246598 | 246598 | 2020-06-17 | Adams | Colorado | 8001 | 3791 | 149 |
243485 | 243485 | 2020-06-16 | Adams | Colorado | 8001 | 3771 | 146 |
240374 | 240374 | 2020-06-15 | Adams | Colorado | 8001 | 3759 | 144 |
237266 | 237266 | 2020-06-14 | Adams | Colorado | 8001 | 3743 | 144 |
234159 | 234159 | 2020-06-13 | Adams | Colorado | 8001 | 3729 | 144 |
231053 | 231053 | 2020-06-12 | Adams | Colorado | 8001 | 3698 | 143 |
227950 | 227950 | 2020-06-11 | Adams | Colorado | 8001 | 3663 | 143 |
224848 | 224848 | 2020-06-10 | Adams | Colorado | 8001 | 3643 | 143 |
221753 | 221753 | 2020-06-09 | Adams | Colorado | 8001 | 3627 | 140 |
218658 | 218658 | 2020-06-08 | Adams | Colorado | 8001 | 3605 | 138 |
215567 | 215567 | 2020-06-07 | Adams | Colorado | 8001 | 3575 | 136 |
212480 | 212480 | 2020-06-06 | Adams | Colorado | 8001 | 3552 | 136 |
209395 | 209395 | 2020-06-05 | Adams | Colorado | 8001 | 3515 | 135 |
206314 | 206314 | 2020-06-04 | Adams | Colorado | 8001 | 3458 | 130 |
203234 | 203234 | 2020-06-03 | Adams | Colorado | 8001 | 3379 | 127 |
200158 | 200158 | 2020-06-02 | Adams | Colorado | 8001 | 3338 | 125 |
197085 | 197085 | 2020-06-01 | Adams | Colorado | 8001 | 3291 | 123 |
194015 | 194015 | 2020-05-31 | Adams | Colorado | 8001 | 3258 | 120 |
190948 | 190948 | 2020-05-30 | Adams | Colorado | 8001 | 3224 | 120 |
187883 | 187883 | 2020-05-29 | Adams | Colorado | 8001 | 3142 | 120 |
184827 | 184827 | 2020-05-28 | Adams | Colorado | 8001 | 3070 | 118 |
181773 | 181773 | 2020-05-27 | Adams | Colorado | 8001 | 3006 | 118 |
178729 | 178729 | 2020-05-26 | Adams | Colorado | 8001 | 2964 | 116 |
175685 | 175685 | 2020-05-25 | Adams | Colorado | 8001 | 2908 | 112 |
172641 | 172641 | 2020-05-24 | Adams | Colorado | 8001 | 2869 | 112 |
169600 | 169600 | 2020-05-23 | Adams | Colorado | 8001 | 2856 | 112 |
166563 | 166563 | 2020-05-22 | Adams | Colorado | 8001 | 2802 | 111 |
163530 | 163530 | 2020-05-21 | Adams | Colorado | 8001 | 2759 | 108 |
160502 | 160502 | 2020-05-20 | Adams | Colorado | 8001 | 2737 | 108 |
157476 | 157476 | 2020-05-19 | Adams | Colorado | 8001 | 2675 | 104 |
154460 | 154460 | 2020-05-18 | Adams | Colorado | 8001 | 2640 | 102 |
151448 | 151448 | 2020-05-17 | Adams | Colorado | 8001 | 2613 | 102 |
148439 | 148439 | 2020-05-16 | Adams | Colorado | 8001 | 2575 | 102 |
145436 | 145436 | 2020-05-15 | Adams | Colorado | 8001 | 2520 | 99 |
142436 | 142436 | 2020-05-14 | Adams | Colorado | 8001 | 2448 | 91 |
139440 | 139440 | 2020-05-13 | Adams | Colorado | 8001 | 2374 | 86 |
136449 | 136449 | 2020-05-12 | Adams | Colorado | 8001 | 2322 | 84 |
133460 | 133460 | 2020-05-11 | Adams | Colorado | 8001 | 2278 | 81 |
130469 | 130469 | 2020-05-10 | Adams | Colorado | 8001 | 2242 | 81 |
127479 | 127479 | 2020-05-09 | Adams | Colorado | 8001 | 2205 | 81 |
124493 | 124493 | 2020-05-08 | Adams | Colorado | 8001 | 2117 | 80 |
121513 | 121513 | 2020-05-07 | Adams | Colorado | 8001 | 2046 | 78 |
118546 | 118546 | 2020-05-06 | Adams | Colorado | 8001 | 1952 | 75 |
115587 | 115587 | 2020-05-05 | Adams | Colorado | 8001 | 1883 | 72 |
112704 | 112704 | 2020-05-04 | Adams | Colorado | 8001 | 1815 | 68 |
109829 | 109829 | 2020-05-03 | Adams | Colorado | 8001 | 1780 | 68 |
106960 | 106960 | 2020-05-02 | Adams | Colorado | 8001 | 1730 | 68 |
104095 | 104095 | 2020-05-01 | Adams | Colorado | 8001 | 1665 | 68 |
101240 | 101240 | 2020-04-30 | Adams | Colorado | 8001 | 1585 | 63 |
98390 | 98390 | 2020-04-29 | Adams | Colorado | 8001 | 1490 | 62 |
95545 | 95545 | 2020-04-28 | Adams | Colorado | 8001 | 1430 | 61 |
92713 | 92713 | 2020-04-27 | Adams | Colorado | 8001 | 1391 | 60 |
89895 | 89895 | 2020-04-26 | Adams | Colorado | 8001 | 1348 | 58 |
87078 | 87078 | 2020-04-25 | Adams | Colorado | 8001 | 1302 | 57 |
84270 | 84270 | 2020-04-24 | Adams | Colorado | 8001 | 1252 | 57 |
81470 | 81470 | 2020-04-23 | Adams | Colorado | 8001 | 1082 | 46 |
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);