ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Morgan" and fips = 8087 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386226 | 386226 | 2020-07-31 | Morgan | Colorado | 8087 | 674 | 46 |
383008 | 383008 | 2020-07-30 | Morgan | Colorado | 8087 | 673 | 46 |
379791 | 379791 | 2020-07-29 | Morgan | Colorado | 8087 | 673 | 46 |
376574 | 376574 | 2020-07-28 | Morgan | Colorado | 8087 | 673 | 46 |
373360 | 373360 | 2020-07-27 | Morgan | Colorado | 8087 | 673 | 46 |
370148 | 370148 | 2020-07-26 | Morgan | Colorado | 8087 | 672 | 46 |
366938 | 366938 | 2020-07-25 | Morgan | Colorado | 8087 | 672 | 46 |
363731 | 363731 | 2020-07-24 | Morgan | Colorado | 8087 | 670 | 46 |
360524 | 360524 | 2020-07-23 | Morgan | Colorado | 8087 | 666 | 46 |
357319 | 357319 | 2020-07-22 | Morgan | Colorado | 8087 | 666 | 46 |
354116 | 354116 | 2020-07-21 | Morgan | Colorado | 8087 | 665 | 46 |
350914 | 350914 | 2020-07-20 | Morgan | Colorado | 8087 | 665 | 46 |
347713 | 347713 | 2020-07-19 | Morgan | Colorado | 8087 | 665 | 46 |
344513 | 344513 | 2020-07-18 | Morgan | Colorado | 8087 | 665 | 46 |
341314 | 341314 | 2020-07-17 | Morgan | Colorado | 8087 | 665 | 46 |
338117 | 338117 | 2020-07-16 | Morgan | Colorado | 8087 | 663 | 46 |
334922 | 334922 | 2020-07-15 | Morgan | Colorado | 8087 | 663 | 46 |
331729 | 331729 | 2020-07-14 | Morgan | Colorado | 8087 | 661 | 46 |
328543 | 328543 | 2020-07-13 | Morgan | Colorado | 8087 | 660 | 46 |
325357 | 325357 | 2020-07-12 | Morgan | Colorado | 8087 | 656 | 46 |
322176 | 322176 | 2020-07-11 | Morgan | Colorado | 8087 | 656 | 46 |
318997 | 318997 | 2020-07-10 | Morgan | Colorado | 8087 | 656 | 46 |
315824 | 315824 | 2020-07-09 | Morgan | Colorado | 8087 | 655 | 46 |
312649 | 312649 | 2020-07-08 | Morgan | Colorado | 8087 | 655 | 46 |
309479 | 309479 | 2020-07-07 | Morgan | Colorado | 8087 | 655 | 46 |
306311 | 306311 | 2020-07-06 | Morgan | Colorado | 8087 | 655 | 46 |
303147 | 303147 | 2020-07-05 | Morgan | Colorado | 8087 | 655 | 46 |
299983 | 299983 | 2020-07-04 | Morgan | Colorado | 8087 | 655 | 46 |
296821 | 296821 | 2020-07-03 | Morgan | Colorado | 8087 | 654 | 46 |
293665 | 293665 | 2020-07-02 | Morgan | Colorado | 8087 | 654 | 46 |
290511 | 290511 | 2020-07-01 | Morgan | Colorado | 8087 | 653 | 46 |
287360 | 287360 | 2020-06-30 | Morgan | Colorado | 8087 | 652 | 46 |
284214 | 284214 | 2020-06-29 | Morgan | Colorado | 8087 | 652 | 46 |
281068 | 281068 | 2020-06-28 | Morgan | Colorado | 8087 | 652 | 46 |
277921 | 277921 | 2020-06-27 | Morgan | Colorado | 8087 | 651 | 46 |
274773 | 274773 | 2020-06-26 | Morgan | Colorado | 8087 | 650 | 46 |
271633 | 271633 | 2020-06-25 | Morgan | Colorado | 8087 | 649 | 46 |
268497 | 268497 | 2020-06-24 | Morgan | Colorado | 8087 | 649 | 46 |
265367 | 265367 | 2020-06-23 | Morgan | Colorado | 8087 | 649 | 46 |
262239 | 262239 | 2020-06-22 | Morgan | Colorado | 8087 | 649 | 46 |
259112 | 259112 | 2020-06-21 | Morgan | Colorado | 8087 | 649 | 46 |
255985 | 255985 | 2020-06-20 | Morgan | Colorado | 8087 | 649 | 46 |
252866 | 252866 | 2020-06-19 | Morgan | Colorado | 8087 | 649 | 46 |
249751 | 249751 | 2020-06-18 | Morgan | Colorado | 8087 | 647 | 46 |
246639 | 246639 | 2020-06-17 | Morgan | Colorado | 8087 | 646 | 45 |
243526 | 243526 | 2020-06-16 | Morgan | Colorado | 8087 | 646 | 45 |
240415 | 240415 | 2020-06-15 | Morgan | Colorado | 8087 | 646 | 45 |
237307 | 237307 | 2020-06-14 | Morgan | Colorado | 8087 | 646 | 45 |
234200 | 234200 | 2020-06-13 | Morgan | Colorado | 8087 | 646 | 45 |
231094 | 231094 | 2020-06-12 | Morgan | Colorado | 8087 | 645 | 45 |
227991 | 227991 | 2020-06-11 | Morgan | Colorado | 8087 | 645 | 45 |
224889 | 224889 | 2020-06-10 | Morgan | Colorado | 8087 | 644 | 45 |
221794 | 221794 | 2020-06-09 | Morgan | Colorado | 8087 | 644 | 45 |
218699 | 218699 | 2020-06-08 | Morgan | Colorado | 8087 | 645 | 46 |
215608 | 215608 | 2020-06-07 | Morgan | Colorado | 8087 | 644 | 46 |
212521 | 212521 | 2020-06-06 | Morgan | Colorado | 8087 | 641 | 46 |
209436 | 209436 | 2020-06-05 | Morgan | Colorado | 8087 | 641 | 46 |
206355 | 206355 | 2020-06-04 | Morgan | Colorado | 8087 | 638 | 46 |
203275 | 203275 | 2020-06-03 | Morgan | Colorado | 8087 | 635 | 45 |
200199 | 200199 | 2020-06-02 | Morgan | Colorado | 8087 | 631 | 43 |
197126 | 197126 | 2020-06-01 | Morgan | Colorado | 8087 | 630 | 43 |
194056 | 194056 | 2020-05-31 | Morgan | Colorado | 8087 | 629 | 43 |
190989 | 190989 | 2020-05-30 | Morgan | Colorado | 8087 | 628 | 43 |
187924 | 187924 | 2020-05-29 | Morgan | Colorado | 8087 | 623 | 42 |
184868 | 184868 | 2020-05-28 | Morgan | Colorado | 8087 | 620 | 42 |
181814 | 181814 | 2020-05-27 | Morgan | Colorado | 8087 | 616 | 42 |
178770 | 178770 | 2020-05-26 | Morgan | Colorado | 8087 | 613 | 42 |
175726 | 175726 | 2020-05-25 | Morgan | Colorado | 8087 | 609 | 41 |
172682 | 172682 | 2020-05-24 | Morgan | Colorado | 8087 | 604 | 41 |
169641 | 169641 | 2020-05-23 | Morgan | Colorado | 8087 | 603 | 41 |
166604 | 166604 | 2020-05-22 | Morgan | Colorado | 8087 | 591 | 40 |
163571 | 163571 | 2020-05-21 | Morgan | Colorado | 8087 | 586 | 38 |
160543 | 160543 | 2020-05-20 | Morgan | Colorado | 8087 | 579 | 37 |
157517 | 157517 | 2020-05-19 | Morgan | Colorado | 8087 | 574 | 35 |
154501 | 154501 | 2020-05-18 | Morgan | Colorado | 8087 | 565 | 32 |
151489 | 151489 | 2020-05-17 | Morgan | Colorado | 8087 | 561 | 32 |
148480 | 148480 | 2020-05-16 | Morgan | Colorado | 8087 | 557 | 29 |
145477 | 145477 | 2020-05-15 | Morgan | Colorado | 8087 | 542 | 27 |
142477 | 142477 | 2020-05-14 | Morgan | Colorado | 8087 | 534 | 26 |
139481 | 139481 | 2020-05-13 | Morgan | Colorado | 8087 | 527 | 24 |
136490 | 136490 | 2020-05-12 | Morgan | Colorado | 8087 | 521 | 22 |
133501 | 133501 | 2020-05-11 | Morgan | Colorado | 8087 | 517 | 22 |
130510 | 130510 | 2020-05-10 | Morgan | Colorado | 8087 | 508 | 22 |
127519 | 127519 | 2020-05-09 | Morgan | Colorado | 8087 | 485 | 22 |
124533 | 124533 | 2020-05-08 | Morgan | Colorado | 8087 | 463 | 22 |
121553 | 121553 | 2020-05-07 | Morgan | Colorado | 8087 | 448 | 22 |
118584 | 118584 | 2020-05-06 | Morgan | Colorado | 8087 | 439 | 21 |
115625 | 115625 | 2020-05-05 | Morgan | Colorado | 8087 | 422 | 21 |
112742 | 112742 | 2020-05-04 | Morgan | Colorado | 8087 | 413 | 20 |
109867 | 109867 | 2020-05-03 | Morgan | Colorado | 8087 | 399 | 20 |
106998 | 106998 | 2020-05-02 | Morgan | Colorado | 8087 | 395 | 20 |
104133 | 104133 | 2020-05-01 | Morgan | Colorado | 8087 | 384 | 17 |
101278 | 101278 | 2020-04-30 | Morgan | Colorado | 8087 | 372 | 16 |
98428 | 98428 | 2020-04-29 | Morgan | Colorado | 8087 | 358 | 16 |
95583 | 95583 | 2020-04-28 | Morgan | Colorado | 8087 | 344 | 16 |
92751 | 92751 | 2020-04-27 | Morgan | Colorado | 8087 | 298 | 15 |
89933 | 89933 | 2020-04-26 | Morgan | Colorado | 8087 | 259 | 13 |
87116 | 87116 | 2020-04-25 | Morgan | Colorado | 8087 | 249 | 11 |
84308 | 84308 | 2020-04-24 | Morgan | Colorado | 8087 | 232 | 8 |
81508 | 81508 | 2020-04-23 | Morgan | Colorado | 8087 | 214 | 8 |
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);