ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,549 rows where county = "Morgan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635173 | 635173 | 2020-10-16 | Morgan | Colorado | 8087 | 804 | 48 |
635378 | 635378 | 2020-10-16 | Morgan | Georgia | 13211 | 636 | 4 |
635552 | 635552 | 2020-10-16 | Morgan | Illinois | 17137 | 811 | 25 |
635641 | 635641 | 2020-10-16 | Morgan | Indiana | 18109 | 902 | 43 |
635972 | 635972 | 2020-10-16 | Morgan | Kentucky | 21175 | 100 | 0 |
636453 | 636453 | 2020-10-16 | Morgan | Missouri | 29141 | 551 | 5 |
637001 | 637001 | 2020-10-16 | Morgan | Ohio | 39115 | 65 | 0 |
637474 | 637474 | 2020-10-16 | Morgan | Tennessee | 47129 | 393 | 6 |
637772 | 637772 | 2020-10-16 | Morgan | Utah | 49029 | 150 | 0 |
638011 | 638011 | 2020-10-16 | Morgan | West Virginia | 54065 | 93 | 0 |
631691 | 631691 | 2020-10-15 | Morgan | Alabama | 1103 | 3800 | 32 |
631927 | 631927 | 2020-10-15 | Morgan | Colorado | 8087 | 800 | 48 |
632132 | 632132 | 2020-10-15 | Morgan | Georgia | 13211 | 633 | 4 |
632306 | 632306 | 2020-10-15 | Morgan | Illinois | 17137 | 789 | 25 |
632395 | 632395 | 2020-10-15 | Morgan | Indiana | 18109 | 880 | 43 |
632726 | 632726 | 2020-10-15 | Morgan | Kentucky | 21175 | 99 | 0 |
633207 | 633207 | 2020-10-15 | Morgan | Missouri | 29141 | 535 | 5 |
633755 | 633755 | 2020-10-15 | Morgan | Ohio | 39115 | 63 | 0 |
634228 | 634228 | 2020-10-15 | Morgan | Tennessee | 47129 | 391 | 6 |
634527 | 634527 | 2020-10-15 | Morgan | Utah | 49029 | 147 | 0 |
634766 | 634766 | 2020-10-15 | Morgan | West Virginia | 54065 | 89 | 0 |
628447 | 628447 | 2020-10-14 | Morgan | Alabama | 1103 | 3757 | 32 |
628683 | 628683 | 2020-10-14 | Morgan | Colorado | 8087 | 788 | 48 |
628888 | 628888 | 2020-10-14 | Morgan | Georgia | 13211 | 631 | 4 |
629062 | 629062 | 2020-10-14 | Morgan | Illinois | 17137 | 789 | 25 |
629151 | 629151 | 2020-10-14 | Morgan | Indiana | 18109 | 866 | 43 |
629482 | 629482 | 2020-10-14 | Morgan | Kentucky | 21175 | 99 | 0 |
629962 | 629962 | 2020-10-14 | Morgan | Missouri | 29141 | 526 | 5 |
630510 | 630510 | 2020-10-14 | Morgan | Ohio | 39115 | 61 | 0 |
630983 | 630983 | 2020-10-14 | Morgan | Tennessee | 47129 | 380 | 6 |
631282 | 631282 | 2020-10-14 | Morgan | Utah | 49029 | 144 | 0 |
631521 | 631521 | 2020-10-14 | Morgan | West Virginia | 54065 | 83 | 0 |
625204 | 625204 | 2020-10-13 | Morgan | Alabama | 1103 | 3724 | 32 |
625440 | 625440 | 2020-10-13 | Morgan | Colorado | 8087 | 789 | 48 |
625645 | 625645 | 2020-10-13 | Morgan | Georgia | 13211 | 628 | 4 |
625819 | 625819 | 2020-10-13 | Morgan | Illinois | 17137 | 779 | 25 |
625908 | 625908 | 2020-10-13 | Morgan | Indiana | 18109 | 864 | 43 |
626238 | 626238 | 2020-10-13 | Morgan | Kentucky | 21175 | 98 | 0 |
626718 | 626718 | 2020-10-13 | Morgan | Missouri | 29141 | 497 | 5 |
627266 | 627266 | 2020-10-13 | Morgan | Ohio | 39115 | 59 | 0 |
627739 | 627739 | 2020-10-13 | Morgan | Tennessee | 47129 | 376 | 6 |
628038 | 628038 | 2020-10-13 | Morgan | Utah | 49029 | 143 | 0 |
628277 | 628277 | 2020-10-13 | Morgan | West Virginia | 54065 | 80 | 0 |
621961 | 621961 | 2020-10-12 | Morgan | Alabama | 1103 | 3691 | 32 |
622197 | 622197 | 2020-10-12 | Morgan | Colorado | 8087 | 782 | 48 |
622402 | 622402 | 2020-10-12 | Morgan | Georgia | 13211 | 627 | 4 |
622577 | 622577 | 2020-10-12 | Morgan | Illinois | 17137 | 747 | 25 |
622666 | 622666 | 2020-10-12 | Morgan | Indiana | 18109 | 848 | 43 |
622996 | 622996 | 2020-10-12 | Morgan | Kentucky | 21175 | 98 | 0 |
623476 | 623476 | 2020-10-12 | Morgan | Missouri | 29141 | 497 | 5 |
624024 | 624024 | 2020-10-12 | Morgan | Ohio | 39115 | 60 | 0 |
624497 | 624497 | 2020-10-12 | Morgan | Tennessee | 47129 | 372 | 5 |
624795 | 624795 | 2020-10-12 | Morgan | Utah | 49029 | 138 | 0 |
625034 | 625034 | 2020-10-12 | Morgan | West Virginia | 54065 | 74 | 0 |
618718 | 618718 | 2020-10-11 | Morgan | Alabama | 1103 | 3665 | 32 |
618954 | 618954 | 2020-10-11 | Morgan | Colorado | 8087 | 782 | 48 |
619159 | 619159 | 2020-10-11 | Morgan | Georgia | 13211 | 625 | 4 |
619333 | 619333 | 2020-10-11 | Morgan | Illinois | 17137 | 734 | 25 |
619422 | 619422 | 2020-10-11 | Morgan | Indiana | 18109 | 839 | 43 |
619752 | 619752 | 2020-10-11 | Morgan | Kentucky | 21175 | 98 | 0 |
620233 | 620233 | 2020-10-11 | Morgan | Missouri | 29141 | 497 | 5 |
620781 | 620781 | 2020-10-11 | Morgan | Ohio | 39115 | 57 | 0 |
621254 | 621254 | 2020-10-11 | Morgan | Tennessee | 47129 | 366 | 5 |
621552 | 621552 | 2020-10-11 | Morgan | Utah | 49029 | 138 | 0 |
621791 | 621791 | 2020-10-11 | Morgan | West Virginia | 54065 | 74 | 0 |
615476 | 615476 | 2020-10-10 | Morgan | Alabama | 1103 | 3632 | 32 |
615712 | 615712 | 2020-10-10 | Morgan | Colorado | 8087 | 777 | 48 |
615917 | 615917 | 2020-10-10 | Morgan | Georgia | 13211 | 622 | 4 |
616091 | 616091 | 2020-10-10 | Morgan | Illinois | 17137 | 724 | 25 |
616180 | 616180 | 2020-10-10 | Morgan | Indiana | 18109 | 836 | 43 |
616510 | 616510 | 2020-10-10 | Morgan | Kentucky | 21175 | 96 | 0 |
616991 | 616991 | 2020-10-10 | Morgan | Missouri | 29141 | 497 | 5 |
617539 | 617539 | 2020-10-10 | Morgan | Ohio | 39115 | 57 | 0 |
618011 | 618011 | 2020-10-10 | Morgan | Tennessee | 47129 | 360 | 4 |
618309 | 618309 | 2020-10-10 | Morgan | Utah | 49029 | 130 | 0 |
618548 | 618548 | 2020-10-10 | Morgan | West Virginia | 54065 | 72 | 0 |
612235 | 612235 | 2020-10-09 | Morgan | Alabama | 1103 | 3600 | 32 |
612471 | 612471 | 2020-10-09 | Morgan | Colorado | 8087 | 775 | 48 |
612676 | 612676 | 2020-10-09 | Morgan | Georgia | 13211 | 620 | 3 |
612850 | 612850 | 2020-10-09 | Morgan | Illinois | 17137 | 724 | 25 |
612939 | 612939 | 2020-10-09 | Morgan | Indiana | 18109 | 826 | 43 |
613269 | 613269 | 2020-10-09 | Morgan | Kentucky | 21175 | 90 | 0 |
613750 | 613750 | 2020-10-09 | Morgan | Missouri | 29141 | 468 | 5 |
614297 | 614297 | 2020-10-09 | Morgan | Ohio | 39115 | 57 | 0 |
614769 | 614769 | 2020-10-09 | Morgan | Tennessee | 47129 | 355 | 4 |
615067 | 615067 | 2020-10-09 | Morgan | Utah | 49029 | 130 | 0 |
615306 | 615306 | 2020-10-09 | Morgan | West Virginia | 54065 | 73 | 0 |
608993 | 608993 | 2020-10-08 | Morgan | Alabama | 1103 | 3551 | 33 |
609229 | 609229 | 2020-10-08 | Morgan | Colorado | 8087 | 770 | 48 |
609434 | 609434 | 2020-10-08 | Morgan | Georgia | 13211 | 619 | 3 |
609608 | 609608 | 2020-10-08 | Morgan | Illinois | 17137 | 724 | 25 |
609697 | 609697 | 2020-10-08 | Morgan | Indiana | 18109 | 811 | 43 |
610027 | 610027 | 2020-10-08 | Morgan | Kentucky | 21175 | 85 | 0 |
610508 | 610508 | 2020-10-08 | Morgan | Missouri | 29141 | 457 | 2 |
611056 | 611056 | 2020-10-08 | Morgan | Ohio | 39115 | 55 | 0 |
611528 | 611528 | 2020-10-08 | Morgan | Tennessee | 47129 | 355 | 4 |
611826 | 611826 | 2020-10-08 | Morgan | Utah | 49029 | 127 | 0 |
612065 | 612065 | 2020-10-08 | Morgan | West Virginia | 54065 | 68 | 0 |
605750 | 605750 | 2020-10-07 | Morgan | Alabama | 1103 | 3536 | 31 |
605986 | 605986 | 2020-10-07 | Morgan | Colorado | 8087 | 766 | 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);