ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Morgan" and fips = 47129 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1065832 | 1065832 | 2021-02-25 | Morgan | Tennessee | 47129 | 2288 | 37 |
1062587 | 1062587 | 2021-02-24 | Morgan | Tennessee | 47129 | 2285 | 37 |
1059342 | 1059342 | 2021-02-23 | Morgan | Tennessee | 47129 | 2282 | 36 |
1056096 | 1056096 | 2021-02-22 | Morgan | Tennessee | 47129 | 2282 | 36 |
1052850 | 1052850 | 2021-02-21 | Morgan | Tennessee | 47129 | 2280 | 36 |
1049603 | 1049603 | 2021-02-20 | Morgan | Tennessee | 47129 | 2276 | 36 |
1046356 | 1046356 | 2021-02-19 | Morgan | Tennessee | 47129 | 2272 | 34 |
1043111 | 1043111 | 2021-02-18 | Morgan | Tennessee | 47129 | 2271 | 34 |
1039866 | 1039866 | 2021-02-17 | Morgan | Tennessee | 47129 | 2261 | 34 |
1036621 | 1036621 | 2021-02-16 | Morgan | Tennessee | 47129 | 2257 | 34 |
1033376 | 1033376 | 2021-02-15 | Morgan | Tennessee | 47129 | 2241 | 34 |
1030130 | 1030130 | 2021-02-14 | Morgan | Tennessee | 47129 | 2233 | 34 |
1026883 | 1026883 | 2021-02-13 | Morgan | Tennessee | 47129 | 2216 | 33 |
1023638 | 1023638 | 2021-02-12 | Morgan | Tennessee | 47129 | 2201 | 32 |
1020393 | 1020393 | 2021-02-11 | Morgan | Tennessee | 47129 | 2195 | 30 |
1017148 | 1017148 | 2021-02-10 | Morgan | Tennessee | 47129 | 2163 | 29 |
1013903 | 1013903 | 2021-02-09 | Morgan | Tennessee | 47129 | 2090 | 26 |
1010658 | 1010658 | 2021-02-08 | Morgan | Tennessee | 47129 | 2060 | 25 |
1007412 | 1007412 | 2021-02-07 | Morgan | Tennessee | 47129 | 2058 | 23 |
1004166 | 1004166 | 2021-02-06 | Morgan | Tennessee | 47129 | 2053 | 23 |
1000920 | 1000920 | 2021-02-05 | Morgan | Tennessee | 47129 | 2042 | 23 |
997674 | 997674 | 2021-02-04 | Morgan | Tennessee | 47129 | 2038 | 23 |
994428 | 994428 | 2021-02-03 | Morgan | Tennessee | 47129 | 2032 | 22 |
991182 | 991182 | 2021-02-02 | Morgan | Tennessee | 47129 | 2031 | 20 |
987936 | 987936 | 2021-02-01 | Morgan | Tennessee | 47129 | 2020 | 18 |
984689 | 984689 | 2021-01-31 | Morgan | Tennessee | 47129 | 2019 | 18 |
981442 | 981442 | 2021-01-30 | Morgan | Tennessee | 47129 | 2013 | 17 |
978196 | 978196 | 2021-01-29 | Morgan | Tennessee | 47129 | 2006 | 17 |
974951 | 974951 | 2021-01-28 | Morgan | Tennessee | 47129 | 1982 | 17 |
971706 | 971706 | 2021-01-27 | Morgan | Tennessee | 47129 | 1977 | 17 |
968461 | 968461 | 2021-01-26 | Morgan | Tennessee | 47129 | 1974 | 17 |
965217 | 965217 | 2021-01-25 | Morgan | Tennessee | 47129 | 1966 | 16 |
961972 | 961972 | 2021-01-24 | Morgan | Tennessee | 47129 | 1973 | 16 |
958727 | 958727 | 2021-01-23 | Morgan | Tennessee | 47129 | 1946 | 16 |
955481 | 955481 | 2021-01-22 | Morgan | Tennessee | 47129 | 1939 | 16 |
952236 | 952236 | 2021-01-21 | Morgan | Tennessee | 47129 | 1926 | 16 |
948991 | 948991 | 2021-01-20 | Morgan | Tennessee | 47129 | 1912 | 15 |
945745 | 945745 | 2021-01-19 | Morgan | Tennessee | 47129 | 1898 | 15 |
942498 | 942498 | 2021-01-18 | Morgan | Tennessee | 47129 | 1890 | 15 |
939253 | 939253 | 2021-01-17 | Morgan | Tennessee | 47129 | 1886 | 14 |
936008 | 936008 | 2021-01-16 | Morgan | Tennessee | 47129 | 1871 | 14 |
932763 | 932763 | 2021-01-15 | Morgan | Tennessee | 47129 | 1866 | 15 |
929518 | 929518 | 2021-01-14 | Morgan | Tennessee | 47129 | 1836 | 13 |
926273 | 926273 | 2021-01-13 | Morgan | Tennessee | 47129 | 1816 | 13 |
923027 | 923027 | 2021-01-12 | Morgan | Tennessee | 47129 | 1800 | 12 |
919782 | 919782 | 2021-01-11 | Morgan | Tennessee | 47129 | 1794 | 12 |
916537 | 916537 | 2021-01-10 | Morgan | Tennessee | 47129 | 1777 | 12 |
913292 | 913292 | 2021-01-09 | Morgan | Tennessee | 47129 | 1751 | 12 |
910047 | 910047 | 2021-01-08 | Morgan | Tennessee | 47129 | 1734 | 12 |
906802 | 906802 | 2021-01-07 | Morgan | Tennessee | 47129 | 1712 | 12 |
903556 | 903556 | 2021-01-06 | Morgan | Tennessee | 47129 | 1691 | 12 |
900311 | 900311 | 2021-01-05 | Morgan | Tennessee | 47129 | 1672 | 12 |
897066 | 897066 | 2021-01-04 | Morgan | Tennessee | 47129 | 1625 | 12 |
893820 | 893820 | 2021-01-03 | Morgan | Tennessee | 47129 | 1621 | 11 |
890574 | 890574 | 2021-01-02 | Morgan | Tennessee | 47129 | 1604 | 11 |
887327 | 887327 | 2021-01-01 | Morgan | Tennessee | 47129 | 1534 | 11 |
884082 | 884082 | 2020-12-31 | Morgan | Tennessee | 47129 | 1534 | 11 |
880837 | 880837 | 2020-12-30 | Morgan | Tennessee | 47129 | 1511 | 11 |
877592 | 877592 | 2020-12-29 | Morgan | Tennessee | 47129 | 1475 | 11 |
874347 | 874347 | 2020-12-28 | Morgan | Tennessee | 47129 | 1469 | 11 |
871102 | 871102 | 2020-12-27 | Morgan | Tennessee | 47129 | 1458 | 11 |
867857 | 867857 | 2020-12-26 | Morgan | Tennessee | 47129 | 1451 | 11 |
864612 | 864612 | 2020-12-25 | Morgan | Tennessee | 47129 | 1439 | 11 |
861367 | 861367 | 2020-12-24 | Morgan | Tennessee | 47129 | 1396 | 11 |
858122 | 858122 | 2020-12-23 | Morgan | Tennessee | 47129 | 1379 | 11 |
854877 | 854877 | 2020-12-22 | Morgan | Tennessee | 47129 | 1357 | 11 |
851632 | 851632 | 2020-12-21 | Morgan | Tennessee | 47129 | 1334 | 11 |
848387 | 848387 | 2020-12-20 | Morgan | Tennessee | 47129 | 1306 | 11 |
845142 | 845142 | 2020-12-19 | Morgan | Tennessee | 47129 | 1284 | 11 |
841896 | 841896 | 2020-12-18 | Morgan | Tennessee | 47129 | 1262 | 11 |
838651 | 838651 | 2020-12-17 | Morgan | Tennessee | 47129 | 1186 | 11 |
835405 | 835405 | 2020-12-16 | Morgan | Tennessee | 47129 | 1169 | 10 |
832159 | 832159 | 2020-12-15 | Morgan | Tennessee | 47129 | 1129 | 10 |
828912 | 828912 | 2020-12-14 | Morgan | Tennessee | 47129 | 1091 | 9 |
825666 | 825666 | 2020-12-13 | Morgan | Tennessee | 47129 | 1046 | 8 |
822419 | 822419 | 2020-12-12 | Morgan | Tennessee | 47129 | 994 | 8 |
819173 | 819173 | 2020-12-11 | Morgan | Tennessee | 47129 | 972 | 8 |
815927 | 815927 | 2020-12-10 | Morgan | Tennessee | 47129 | 938 | 8 |
812681 | 812681 | 2020-12-09 | Morgan | Tennessee | 47129 | 920 | 8 |
809437 | 809437 | 2020-12-08 | Morgan | Tennessee | 47129 | 881 | 8 |
806192 | 806192 | 2020-12-07 | Morgan | Tennessee | 47129 | 859 | 7 |
802947 | 802947 | 2020-12-06 | Morgan | Tennessee | 47129 | 834 | 7 |
799702 | 799702 | 2020-12-05 | Morgan | Tennessee | 47129 | 829 | 7 |
796457 | 796457 | 2020-12-04 | Morgan | Tennessee | 47129 | 809 | 7 |
793212 | 793212 | 2020-12-03 | Morgan | Tennessee | 47129 | 799 | 6 |
789967 | 789967 | 2020-12-02 | Morgan | Tennessee | 47129 | 788 | 6 |
786722 | 786722 | 2020-12-01 | Morgan | Tennessee | 47129 | 780 | 6 |
783478 | 783478 | 2020-11-30 | Morgan | Tennessee | 47129 | 762 | 6 |
780233 | 780233 | 2020-11-29 | Morgan | Tennessee | 47129 | 739 | 6 |
776987 | 776987 | 2020-11-28 | Morgan | Tennessee | 47129 | 730 | 6 |
773742 | 773742 | 2020-11-27 | Morgan | Tennessee | 47129 | 709 | 6 |
770497 | 770497 | 2020-11-26 | Morgan | Tennessee | 47129 | 695 | 6 |
767251 | 767251 | 2020-11-25 | Morgan | Tennessee | 47129 | 688 | 6 |
764006 | 764006 | 2020-11-24 | Morgan | Tennessee | 47129 | 679 | 6 |
760761 | 760761 | 2020-11-23 | Morgan | Tennessee | 47129 | 672 | 6 |
757516 | 757516 | 2020-11-22 | Morgan | Tennessee | 47129 | 654 | 6 |
754269 | 754269 | 2020-11-21 | Morgan | Tennessee | 47129 | 639 | 6 |
751023 | 751023 | 2020-11-20 | Morgan | Tennessee | 47129 | 609 | 6 |
747777 | 747777 | 2020-11-19 | Morgan | Tennessee | 47129 | 600 | 6 |
744531 | 744531 | 2020-11-18 | Morgan | Tennessee | 47129 | 594 | 6 |
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);