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 |
---|---|---|---|---|---|---|---|
920726 | 920726 | 2021-01-12 | Morgan | Colorado | 8087 | 2258 | 84 |
920931 | 920931 | 2021-01-12 | Morgan | Georgia | 13211 | 1406 | 10 |
921106 | 921106 | 2021-01-12 | Morgan | Illinois | 17137 | 3248 | 87 |
921194 | 921194 | 2021-01-12 | Morgan | Indiana | 18109 | 4958 | 89 |
921525 | 921525 | 2021-01-12 | Morgan | Kentucky | 21175 | 1368 | 0 |
922006 | 922006 | 2021-01-12 | Morgan | Missouri | 29141 | 1540 | 31 |
922554 | 922554 | 2021-01-12 | Morgan | Ohio | 39115 | 730 | 26 |
923027 | 923027 | 2021-01-12 | Morgan | Tennessee | 47129 | 1800 | 12 |
923327 | 923327 | 2021-01-12 | Morgan | Utah | 49029 | 981 | 7 |
923565 | 923565 | 2021-01-12 | Morgan | West Virginia | 54065 | 784 | 9 |
917244 | 917244 | 2021-01-11 | Morgan | Alabama | 1103 | 11781 | 104 |
917481 | 917481 | 2021-01-11 | Morgan | Colorado | 8087 | 2248 | 84 |
917686 | 917686 | 2021-01-11 | Morgan | Georgia | 13211 | 1397 | 10 |
917861 | 917861 | 2021-01-11 | Morgan | Illinois | 17137 | 3248 | 87 |
917949 | 917949 | 2021-01-11 | Morgan | Indiana | 18109 | 4916 | 88 |
918280 | 918280 | 2021-01-11 | Morgan | Kentucky | 21175 | 1359 | 0 |
918761 | 918761 | 2021-01-11 | Morgan | Missouri | 29141 | 1536 | 30 |
919309 | 919309 | 2021-01-11 | Morgan | Ohio | 39115 | 726 | 26 |
919782 | 919782 | 2021-01-11 | Morgan | Tennessee | 47129 | 1794 | 12 |
920082 | 920082 | 2021-01-11 | Morgan | Utah | 49029 | 974 | 7 |
920320 | 920320 | 2021-01-11 | Morgan | West Virginia | 54065 | 781 | 9 |
913999 | 913999 | 2021-01-10 | Morgan | Alabama | 1103 | 11727 | 104 |
914236 | 914236 | 2021-01-10 | Morgan | Colorado | 8087 | 2245 | 84 |
914441 | 914441 | 2021-01-10 | Morgan | Georgia | 13211 | 1361 | 10 |
914616 | 914616 | 2021-01-10 | Morgan | Illinois | 17137 | 3211 | 87 |
914704 | 914704 | 2021-01-10 | Morgan | Indiana | 18109 | 4874 | 87 |
915035 | 915035 | 2021-01-10 | Morgan | Kentucky | 21175 | 1291 | 0 |
915516 | 915516 | 2021-01-10 | Morgan | Missouri | 29141 | 1532 | 30 |
916064 | 916064 | 2021-01-10 | Morgan | Ohio | 39115 | 721 | 26 |
916537 | 916537 | 2021-01-10 | Morgan | Tennessee | 47129 | 1777 | 12 |
916837 | 916837 | 2021-01-10 | Morgan | Utah | 49029 | 970 | 7 |
917075 | 917075 | 2021-01-10 | Morgan | West Virginia | 54065 | 772 | 9 |
910754 | 910754 | 2021-01-09 | Morgan | Alabama | 1103 | 11634 | 104 |
910991 | 910991 | 2021-01-09 | Morgan | Colorado | 8087 | 2237 | 84 |
911196 | 911196 | 2021-01-09 | Morgan | Georgia | 13211 | 1350 | 10 |
911371 | 911371 | 2021-01-09 | Morgan | Illinois | 17137 | 3168 | 87 |
911459 | 911459 | 2021-01-09 | Morgan | Indiana | 18109 | 4813 | 87 |
911790 | 911790 | 2021-01-09 | Morgan | Kentucky | 21175 | 1139 | 0 |
912271 | 912271 | 2021-01-09 | Morgan | Missouri | 29141 | 1523 | 30 |
912819 | 912819 | 2021-01-09 | Morgan | Ohio | 39115 | 713 | 26 |
913292 | 913292 | 2021-01-09 | Morgan | Tennessee | 47129 | 1751 | 12 |
913592 | 913592 | 2021-01-09 | Morgan | Utah | 49029 | 966 | 7 |
913830 | 913830 | 2021-01-09 | Morgan | West Virginia | 54065 | 748 | 9 |
907509 | 907509 | 2021-01-08 | Morgan | Alabama | 1103 | 11485 | 103 |
907746 | 907746 | 2021-01-08 | Morgan | Colorado | 8087 | 2222 | 84 |
907951 | 907951 | 2021-01-08 | Morgan | Georgia | 13211 | 1331 | 10 |
908126 | 908126 | 2021-01-08 | Morgan | Illinois | 17137 | 3146 | 84 |
908214 | 908214 | 2021-01-08 | Morgan | Indiana | 18109 | 4741 | 87 |
908545 | 908545 | 2021-01-08 | Morgan | Kentucky | 21175 | 922 | 0 |
909026 | 909026 | 2021-01-08 | Morgan | Missouri | 29141 | 1513 | 24 |
909574 | 909574 | 2021-01-08 | Morgan | Ohio | 39115 | 708 | 26 |
910047 | 910047 | 2021-01-08 | Morgan | Tennessee | 47129 | 1734 | 12 |
910347 | 910347 | 2021-01-08 | Morgan | Utah | 49029 | 949 | 7 |
910585 | 910585 | 2021-01-08 | Morgan | West Virginia | 54065 | 725 | 9 |
904263 | 904263 | 2021-01-07 | Morgan | Alabama | 1103 | 11336 | 103 |
904500 | 904500 | 2021-01-07 | Morgan | Colorado | 8087 | 2213 | 84 |
904705 | 904705 | 2021-01-07 | Morgan | Georgia | 13211 | 1304 | 10 |
904880 | 904880 | 2021-01-07 | Morgan | Illinois | 17137 | 3146 | 84 |
904968 | 904968 | 2021-01-07 | Morgan | Indiana | 18109 | 4655 | 87 |
905299 | 905299 | 2021-01-07 | Morgan | Kentucky | 21175 | 769 | 0 |
905780 | 905780 | 2021-01-07 | Morgan | Missouri | 29141 | 1500 | 24 |
906329 | 906329 | 2021-01-07 | Morgan | Ohio | 39115 | 693 | 26 |
906802 | 906802 | 2021-01-07 | Morgan | Tennessee | 47129 | 1712 | 12 |
907102 | 907102 | 2021-01-07 | Morgan | Utah | 49029 | 945 | 7 |
907340 | 907340 | 2021-01-07 | Morgan | West Virginia | 54065 | 720 | 9 |
901018 | 901018 | 2021-01-06 | Morgan | Alabama | 1103 | 11205 | 100 |
901255 | 901255 | 2021-01-06 | Morgan | Colorado | 8087 | 2169 | 83 |
901460 | 901460 | 2021-01-06 | Morgan | Georgia | 13211 | 1287 | 10 |
901635 | 901635 | 2021-01-06 | Morgan | Illinois | 17137 | 3146 | 84 |
901723 | 901723 | 2021-01-06 | Morgan | Indiana | 18109 | 4586 | 87 |
902054 | 902054 | 2021-01-06 | Morgan | Kentucky | 21175 | 575 | 0 |
902535 | 902535 | 2021-01-06 | Morgan | Missouri | 29141 | 1484 | 24 |
903083 | 903083 | 2021-01-06 | Morgan | Ohio | 39115 | 690 | 26 |
903556 | 903556 | 2021-01-06 | Morgan | Tennessee | 47129 | 1691 | 12 |
903856 | 903856 | 2021-01-06 | Morgan | Utah | 49029 | 931 | 7 |
904094 | 904094 | 2021-01-06 | Morgan | West Virginia | 54065 | 709 | 9 |
897773 | 897773 | 2021-01-05 | Morgan | Alabama | 1103 | 11118 | 90 |
898010 | 898010 | 2021-01-05 | Morgan | Colorado | 8087 | 2169 | 83 |
898215 | 898215 | 2021-01-05 | Morgan | Georgia | 13211 | 1266 | 10 |
898390 | 898390 | 2021-01-05 | Morgan | Illinois | 17137 | 3146 | 84 |
898478 | 898478 | 2021-01-05 | Morgan | Indiana | 18109 | 4541 | 85 |
898809 | 898809 | 2021-01-05 | Morgan | Kentucky | 21175 | 565 | 0 |
899290 | 899290 | 2021-01-05 | Morgan | Missouri | 29141 | 1480 | 24 |
899838 | 899838 | 2021-01-05 | Morgan | Ohio | 39115 | 676 | 26 |
900311 | 900311 | 2021-01-05 | Morgan | Tennessee | 47129 | 1672 | 12 |
900611 | 900611 | 2021-01-05 | Morgan | Utah | 49029 | 920 | 7 |
900849 | 900849 | 2021-01-05 | Morgan | West Virginia | 54065 | 702 | 8 |
894527 | 894527 | 2021-01-04 | Morgan | Alabama | 1103 | 11017 | 89 |
894765 | 894765 | 2021-01-04 | Morgan | Colorado | 8087 | 2164 | 83 |
894970 | 894970 | 2021-01-04 | Morgan | Georgia | 13211 | 1248 | 10 |
895145 | 895145 | 2021-01-04 | Morgan | Illinois | 17137 | 3060 | 82 |
895233 | 895233 | 2021-01-04 | Morgan | Indiana | 18109 | 4512 | 84 |
895564 | 895564 | 2021-01-04 | Morgan | Kentucky | 21175 | 565 | 0 |
896045 | 896045 | 2021-01-04 | Morgan | Missouri | 29141 | 1475 | 24 |
896593 | 896593 | 2021-01-04 | Morgan | Ohio | 39115 | 669 | 26 |
897066 | 897066 | 2021-01-04 | Morgan | Tennessee | 47129 | 1625 | 12 |
897366 | 897366 | 2021-01-04 | Morgan | Utah | 49029 | 904 | 7 |
897604 | 897604 | 2021-01-04 | Morgan | West Virginia | 54065 | 687 | 8 |
891281 | 891281 | 2021-01-03 | Morgan | Alabama | 1103 | 10974 | 89 |
891518 | 891518 | 2021-01-03 | Morgan | Colorado | 8087 | 2160 | 83 |
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);