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 |
---|---|---|---|---|---|---|---|
534710 | 534710 | 2020-09-15 | Morgan | Colorado | 8087 | 726 | 48 |
534915 | 534915 | 2020-09-15 | Morgan | Georgia | 13211 | 454 | 2 |
535089 | 535089 | 2020-09-15 | Morgan | Illinois | 17137 | 619 | 21 |
535178 | 535178 | 2020-09-15 | Morgan | Indiana | 18109 | 680 | 40 |
535508 | 535508 | 2020-09-15 | Morgan | Kentucky | 21175 | 50 | 0 |
535988 | 535988 | 2020-09-15 | Morgan | Missouri | 29141 | 220 | 1 |
536533 | 536533 | 2020-09-15 | Morgan | Ohio | 39115 | 45 | 0 |
537005 | 537005 | 2020-09-15 | Morgan | Tennessee | 47129 | 282 | 2 |
537302 | 537302 | 2020-09-15 | Morgan | Utah | 49029 | 86 | 0 |
537541 | 537541 | 2020-09-15 | Morgan | West Virginia | 54065 | 46 | 0 |
531240 | 531240 | 2020-09-14 | Morgan | Alabama | 1103 | 3094 | 25 |
531475 | 531475 | 2020-09-14 | Morgan | Colorado | 8087 | 725 | 48 |
531680 | 531680 | 2020-09-14 | Morgan | Georgia | 13211 | 452 | 2 |
531854 | 531854 | 2020-09-14 | Morgan | Illinois | 17137 | 615 | 21 |
531943 | 531943 | 2020-09-14 | Morgan | Indiana | 18109 | 678 | 39 |
532273 | 532273 | 2020-09-14 | Morgan | Kentucky | 21175 | 50 | 0 |
532753 | 532753 | 2020-09-14 | Morgan | Missouri | 29141 | 210 | 1 |
533297 | 533297 | 2020-09-14 | Morgan | Ohio | 39115 | 46 | 0 |
533769 | 533769 | 2020-09-14 | Morgan | Tennessee | 47129 | 282 | 2 |
534066 | 534066 | 2020-09-14 | Morgan | Utah | 49029 | 85 | 0 |
534305 | 534305 | 2020-09-14 | Morgan | West Virginia | 54065 | 45 | 0 |
528003 | 528003 | 2020-09-13 | Morgan | Alabama | 1103 | 3080 | 25 |
528238 | 528238 | 2020-09-13 | Morgan | Colorado | 8087 | 729 | 48 |
528443 | 528443 | 2020-09-13 | Morgan | Georgia | 13211 | 451 | 2 |
528617 | 528617 | 2020-09-13 | Morgan | Illinois | 17137 | 606 | 21 |
528706 | 528706 | 2020-09-13 | Morgan | Indiana | 18109 | 673 | 39 |
529036 | 529036 | 2020-09-13 | Morgan | Kentucky | 21175 | 50 | 0 |
529517 | 529517 | 2020-09-13 | Morgan | Missouri | 29141 | 199 | 1 |
530062 | 530062 | 2020-09-13 | Morgan | Ohio | 39115 | 46 | 0 |
530534 | 530534 | 2020-09-13 | Morgan | Tennessee | 47129 | 281 | 2 |
530831 | 530831 | 2020-09-13 | Morgan | Utah | 49029 | 82 | 0 |
531070 | 531070 | 2020-09-13 | Morgan | West Virginia | 54065 | 44 | 0 |
524767 | 524767 | 2020-09-12 | Morgan | Alabama | 1103 | 3062 | 25 |
525002 | 525002 | 2020-09-12 | Morgan | Colorado | 8087 | 727 | 48 |
525207 | 525207 | 2020-09-12 | Morgan | Georgia | 13211 | 448 | 2 |
525381 | 525381 | 2020-09-12 | Morgan | Illinois | 17137 | 606 | 21 |
525470 | 525470 | 2020-09-12 | Morgan | Indiana | 18109 | 658 | 39 |
525800 | 525800 | 2020-09-12 | Morgan | Kentucky | 21175 | 50 | 0 |
526281 | 526281 | 2020-09-12 | Morgan | Missouri | 29141 | 189 | 1 |
526825 | 526825 | 2020-09-12 | Morgan | Ohio | 39115 | 46 | 0 |
527297 | 527297 | 2020-09-12 | Morgan | Tennessee | 47129 | 281 | 2 |
527594 | 527594 | 2020-09-12 | Morgan | Utah | 49029 | 82 | 0 |
527833 | 527833 | 2020-09-12 | Morgan | West Virginia | 54065 | 44 | 0 |
521531 | 521531 | 2020-09-11 | Morgan | Alabama | 1103 | 3053 | 25 |
521766 | 521766 | 2020-09-11 | Morgan | Colorado | 8087 | 724 | 48 |
521971 | 521971 | 2020-09-11 | Morgan | Georgia | 13211 | 446 | 2 |
522145 | 522145 | 2020-09-11 | Morgan | Illinois | 17137 | 601 | 21 |
522234 | 522234 | 2020-09-11 | Morgan | Indiana | 18109 | 648 | 39 |
522564 | 522564 | 2020-09-11 | Morgan | Kentucky | 21175 | 50 | 0 |
523045 | 523045 | 2020-09-11 | Morgan | Missouri | 29141 | 183 | 1 |
523589 | 523589 | 2020-09-11 | Morgan | Ohio | 39115 | 46 | 0 |
524061 | 524061 | 2020-09-11 | Morgan | Tennessee | 47129 | 276 | 2 |
524358 | 524358 | 2020-09-11 | Morgan | Utah | 49029 | 82 | 0 |
524597 | 524597 | 2020-09-11 | Morgan | West Virginia | 54065 | 43 | 0 |
518294 | 518294 | 2020-09-10 | Morgan | Alabama | 1103 | 3034 | 24 |
518529 | 518529 | 2020-09-10 | Morgan | Colorado | 8087 | 723 | 48 |
518734 | 518734 | 2020-09-10 | Morgan | Georgia | 13211 | 442 | 2 |
518908 | 518908 | 2020-09-10 | Morgan | Illinois | 17137 | 598 | 21 |
518997 | 518997 | 2020-09-10 | Morgan | Indiana | 18109 | 646 | 39 |
519327 | 519327 | 2020-09-10 | Morgan | Kentucky | 21175 | 51 | 0 |
519808 | 519808 | 2020-09-10 | Morgan | Missouri | 29141 | 176 | 1 |
520353 | 520353 | 2020-09-10 | Morgan | Ohio | 39115 | 45 | 0 |
520825 | 520825 | 2020-09-10 | Morgan | Tennessee | 47129 | 274 | 2 |
521122 | 521122 | 2020-09-10 | Morgan | Utah | 49029 | 82 | 0 |
521361 | 521361 | 2020-09-10 | Morgan | West Virginia | 54065 | 43 | 0 |
515059 | 515059 | 2020-09-09 | Morgan | Alabama | 1103 | 3027 | 24 |
515294 | 515294 | 2020-09-09 | Morgan | Colorado | 8087 | 723 | 48 |
515499 | 515499 | 2020-09-09 | Morgan | Georgia | 13211 | 441 | 2 |
515673 | 515673 | 2020-09-09 | Morgan | Illinois | 17137 | 598 | 21 |
515762 | 515762 | 2020-09-09 | Morgan | Indiana | 18109 | 644 | 38 |
516092 | 516092 | 2020-09-09 | Morgan | Kentucky | 21175 | 51 | 0 |
516573 | 516573 | 2020-09-09 | Morgan | Missouri | 29141 | 169 | 1 |
517117 | 517117 | 2020-09-09 | Morgan | Ohio | 39115 | 45 | 0 |
517589 | 517589 | 2020-09-09 | Morgan | Tennessee | 47129 | 268 | 2 |
517885 | 517885 | 2020-09-09 | Morgan | Utah | 49029 | 82 | 0 |
518124 | 518124 | 2020-09-09 | Morgan | West Virginia | 54065 | 41 | 0 |
511826 | 511826 | 2020-09-08 | Morgan | Alabama | 1103 | 3010 | 24 |
512061 | 512061 | 2020-09-08 | Morgan | Colorado | 8087 | 721 | 48 |
512266 | 512266 | 2020-09-08 | Morgan | Georgia | 13211 | 440 | 2 |
512440 | 512440 | 2020-09-08 | Morgan | Illinois | 17137 | 594 | 21 |
512529 | 512529 | 2020-09-08 | Morgan | Indiana | 18109 | 638 | 38 |
512859 | 512859 | 2020-09-08 | Morgan | Kentucky | 21175 | 51 | 0 |
513339 | 513339 | 2020-09-08 | Morgan | Missouri | 29141 | 163 | 1 |
513882 | 513882 | 2020-09-08 | Morgan | Ohio | 39115 | 45 | 0 |
514354 | 514354 | 2020-09-08 | Morgan | Tennessee | 47129 | 266 | 2 |
514650 | 514650 | 2020-09-08 | Morgan | Utah | 49029 | 82 | 0 |
514889 | 514889 | 2020-09-08 | Morgan | West Virginia | 54065 | 41 | 0 |
508593 | 508593 | 2020-09-07 | Morgan | Alabama | 1103 | 3002 | 24 |
508828 | 508828 | 2020-09-07 | Morgan | Colorado | 8087 | 721 | 48 |
509033 | 509033 | 2020-09-07 | Morgan | Georgia | 13211 | 436 | 2 |
509207 | 509207 | 2020-09-07 | Morgan | Illinois | 17137 | 594 | 21 |
509296 | 509296 | 2020-09-07 | Morgan | Indiana | 18109 | 637 | 38 |
509627 | 509627 | 2020-09-07 | Morgan | Kentucky | 21175 | 50 | 0 |
510107 | 510107 | 2020-09-07 | Morgan | Missouri | 29141 | 156 | 1 |
510649 | 510649 | 2020-09-07 | Morgan | Ohio | 39115 | 45 | 0 |
511121 | 511121 | 2020-09-07 | Morgan | Tennessee | 47129 | 266 | 2 |
511417 | 511417 | 2020-09-07 | Morgan | Utah | 49029 | 81 | 0 |
511656 | 511656 | 2020-09-07 | Morgan | West Virginia | 54065 | 41 | 0 |
505361 | 505361 | 2020-09-06 | Morgan | Alabama | 1103 | 2995 | 24 |
505596 | 505596 | 2020-09-06 | Morgan | Colorado | 8087 | 720 | 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);