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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
277921 | 277921 | 2020-06-27 | Morgan | Colorado | 8087 | 651 | 46 |
281068 | 281068 | 2020-06-28 | Morgan | Colorado | 8087 | 652 | 46 |
284214 | 284214 | 2020-06-29 | Morgan | Colorado | 8087 | 652 | 46 |
287360 | 287360 | 2020-06-30 | Morgan | Colorado | 8087 | 652 | 46 |
290511 | 290511 | 2020-07-01 | Morgan | Colorado | 8087 | 653 | 46 |
293665 | 293665 | 2020-07-02 | Morgan | Colorado | 8087 | 654 | 46 |
296821 | 296821 | 2020-07-03 | Morgan | Colorado | 8087 | 654 | 46 |
299983 | 299983 | 2020-07-04 | Morgan | Colorado | 8087 | 655 | 46 |
303147 | 303147 | 2020-07-05 | Morgan | Colorado | 8087 | 655 | 46 |
306311 | 306311 | 2020-07-06 | Morgan | Colorado | 8087 | 655 | 46 |
309479 | 309479 | 2020-07-07 | Morgan | Colorado | 8087 | 655 | 46 |
312649 | 312649 | 2020-07-08 | Morgan | Colorado | 8087 | 655 | 46 |
315824 | 315824 | 2020-07-09 | Morgan | Colorado | 8087 | 655 | 46 |
318997 | 318997 | 2020-07-10 | Morgan | Colorado | 8087 | 656 | 46 |
322176 | 322176 | 2020-07-11 | Morgan | Colorado | 8087 | 656 | 46 |
325357 | 325357 | 2020-07-12 | Morgan | Colorado | 8087 | 656 | 46 |
328543 | 328543 | 2020-07-13 | Morgan | Colorado | 8087 | 660 | 46 |
331729 | 331729 | 2020-07-14 | Morgan | Colorado | 8087 | 661 | 46 |
334922 | 334922 | 2020-07-15 | Morgan | Colorado | 8087 | 663 | 46 |
338117 | 338117 | 2020-07-16 | Morgan | Colorado | 8087 | 663 | 46 |
341314 | 341314 | 2020-07-17 | Morgan | Colorado | 8087 | 665 | 46 |
344513 | 344513 | 2020-07-18 | Morgan | Colorado | 8087 | 665 | 46 |
347713 | 347713 | 2020-07-19 | Morgan | Colorado | 8087 | 665 | 46 |
350914 | 350914 | 2020-07-20 | Morgan | Colorado | 8087 | 665 | 46 |
354116 | 354116 | 2020-07-21 | Morgan | Colorado | 8087 | 665 | 46 |
357319 | 357319 | 2020-07-22 | Morgan | Colorado | 8087 | 666 | 46 |
360524 | 360524 | 2020-07-23 | Morgan | Colorado | 8087 | 666 | 46 |
363731 | 363731 | 2020-07-24 | Morgan | Colorado | 8087 | 670 | 46 |
366938 | 366938 | 2020-07-25 | Morgan | Colorado | 8087 | 672 | 46 |
370148 | 370148 | 2020-07-26 | Morgan | Colorado | 8087 | 672 | 46 |
373360 | 373360 | 2020-07-27 | Morgan | Colorado | 8087 | 673 | 46 |
376574 | 376574 | 2020-07-28 | Morgan | Colorado | 8087 | 673 | 46 |
379791 | 379791 | 2020-07-29 | Morgan | Colorado | 8087 | 673 | 46 |
383008 | 383008 | 2020-07-30 | Morgan | Colorado | 8087 | 673 | 46 |
386226 | 386226 | 2020-07-31 | Morgan | Colorado | 8087 | 674 | 46 |
389443 | 389443 | 2020-08-01 | Morgan | Colorado | 8087 | 676 | 46 |
392660 | 392660 | 2020-08-02 | Morgan | Colorado | 8087 | 677 | 46 |
395876 | 395876 | 2020-08-03 | Morgan | Colorado | 8087 | 677 | 46 |
399092 | 399092 | 2020-08-04 | Morgan | Colorado | 8087 | 678 | 46 |
402308 | 402308 | 2020-08-05 | Morgan | Colorado | 8087 | 681 | 46 |
405526 | 405526 | 2020-08-06 | Morgan | Colorado | 8087 | 681 | 46 |
408746 | 408746 | 2020-08-07 | Morgan | Colorado | 8087 | 683 | 46 |
411965 | 411965 | 2020-08-08 | Morgan | Colorado | 8087 | 684 | 46 |
415185 | 415185 | 2020-08-09 | Morgan | Colorado | 8087 | 685 | 46 |
418406 | 418406 | 2020-08-10 | Morgan | Colorado | 8087 | 686 | 46 |
421627 | 421627 | 2020-08-11 | Morgan | Colorado | 8087 | 687 | 46 |
424848 | 424848 | 2020-08-12 | Morgan | Colorado | 8087 | 687 | 46 |
428072 | 428072 | 2020-08-13 | Morgan | Colorado | 8087 | 693 | 47 |
431300 | 431300 | 2020-08-14 | Morgan | Colorado | 8087 | 694 | 47 |
434525 | 434525 | 2020-08-15 | Morgan | Colorado | 8087 | 695 | 47 |
437751 | 437751 | 2020-08-16 | Morgan | Colorado | 8087 | 698 | 47 |
440977 | 440977 | 2020-08-17 | Morgan | Colorado | 8087 | 699 | 47 |
444203 | 444203 | 2020-08-18 | Morgan | Colorado | 8087 | 700 | 47 |
447430 | 447430 | 2020-08-19 | Morgan | Colorado | 8087 | 701 | 47 |
450658 | 450658 | 2020-08-20 | Morgan | Colorado | 8087 | 702 | 47 |
453886 | 453886 | 2020-08-21 | Morgan | Colorado | 8087 | 703 | 47 |
457114 | 457114 | 2020-08-22 | Morgan | Colorado | 8087 | 704 | 47 |
460341 | 460341 | 2020-08-23 | Morgan | Colorado | 8087 | 705 | 47 |
463570 | 463570 | 2020-08-24 | Morgan | Colorado | 8087 | 706 | 47 |
466799 | 466799 | 2020-08-25 | Morgan | Colorado | 8087 | 708 | 47 |
470028 | 470028 | 2020-08-26 | Morgan | Colorado | 8087 | 710 | 47 |
473260 | 473260 | 2020-08-27 | Morgan | Colorado | 8087 | 711 | 48 |
476493 | 476493 | 2020-08-28 | Morgan | Colorado | 8087 | 711 | 48 |
479726 | 479726 | 2020-08-29 | Morgan | Colorado | 8087 | 712 | 48 |
482960 | 482960 | 2020-08-30 | Morgan | Colorado | 8087 | 713 | 48 |
486195 | 486195 | 2020-08-31 | Morgan | Colorado | 8087 | 713 | 48 |
489428 | 489428 | 2020-09-01 | Morgan | Colorado | 8087 | 716 | 48 |
492661 | 492661 | 2020-09-02 | Morgan | Colorado | 8087 | 716 | 48 |
495895 | 495895 | 2020-09-03 | Morgan | Colorado | 8087 | 717 | 48 |
499128 | 499128 | 2020-09-04 | Morgan | Colorado | 8087 | 718 | 48 |
502362 | 502362 | 2020-09-05 | Morgan | Colorado | 8087 | 720 | 48 |
505596 | 505596 | 2020-09-06 | Morgan | Colorado | 8087 | 720 | 48 |
508828 | 508828 | 2020-09-07 | Morgan | Colorado | 8087 | 721 | 48 |
512061 | 512061 | 2020-09-08 | Morgan | Colorado | 8087 | 721 | 48 |
515294 | 515294 | 2020-09-09 | Morgan | Colorado | 8087 | 723 | 48 |
518529 | 518529 | 2020-09-10 | Morgan | Colorado | 8087 | 723 | 48 |
521766 | 521766 | 2020-09-11 | Morgan | Colorado | 8087 | 724 | 48 |
525002 | 525002 | 2020-09-12 | Morgan | Colorado | 8087 | 727 | 48 |
528238 | 528238 | 2020-09-13 | Morgan | Colorado | 8087 | 729 | 48 |
531475 | 531475 | 2020-09-14 | Morgan | Colorado | 8087 | 725 | 48 |
534710 | 534710 | 2020-09-15 | Morgan | Colorado | 8087 | 726 | 48 |
537946 | 537946 | 2020-09-16 | Morgan | Colorado | 8087 | 727 | 48 |
541183 | 541183 | 2020-09-17 | Morgan | Colorado | 8087 | 728 | 48 |
544419 | 544419 | 2020-09-18 | Morgan | Colorado | 8087 | 731 | 48 |
547657 | 547657 | 2020-09-19 | Morgan | Colorado | 8087 | 732 | 48 |
550896 | 550896 | 2020-09-20 | Morgan | Colorado | 8087 | 732 | 48 |
554135 | 554135 | 2020-09-21 | Morgan | Colorado | 8087 | 733 | 48 |
557372 | 557372 | 2020-09-22 | Morgan | Colorado | 8087 | 736 | 48 |
560608 | 560608 | 2020-09-23 | Morgan | Colorado | 8087 | 736 | 48 |
563848 | 563848 | 2020-09-24 | Morgan | Colorado | 8087 | 739 | 48 |
567088 | 567088 | 2020-09-25 | Morgan | Colorado | 8087 | 743 | 48 |
570330 | 570330 | 2020-09-26 | Morgan | Colorado | 8087 | 746 | 48 |
573572 | 573572 | 2020-09-27 | Morgan | Colorado | 8087 | 747 | 48 |
576815 | 576815 | 2020-09-28 | Morgan | Colorado | 8087 | 750 | 48 |
580056 | 580056 | 2020-09-29 | Morgan | Colorado | 8087 | 755 | 48 |
583295 | 583295 | 2020-09-30 | Morgan | Colorado | 8087 | 756 | 48 |
586535 | 586535 | 2020-10-01 | Morgan | Colorado | 8087 | 755 | 48 |
589776 | 589776 | 2020-10-02 | Morgan | Colorado | 8087 | 757 | 48 |
593016 | 593016 | 2020-10-03 | Morgan | Colorado | 8087 | 760 | 48 |
596258 | 596258 | 2020-10-04 | Morgan | Colorado | 8087 | 761 | 48 |
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);