ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Morgan" and fips = 49029 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1066132 | 1066132 | 2021-02-25 | Morgan | Utah | 49029 | 1125 | 11 |
1062887 | 1062887 | 2021-02-24 | Morgan | Utah | 49029 | 1123 | 11 |
1059642 | 1059642 | 2021-02-23 | Morgan | Utah | 49029 | 1123 | 11 |
1056396 | 1056396 | 2021-02-22 | Morgan | Utah | 49029 | 1119 | 11 |
1053150 | 1053150 | 2021-02-21 | Morgan | Utah | 49029 | 1118 | 11 |
1049903 | 1049903 | 2021-02-20 | Morgan | Utah | 49029 | 1118 | 11 |
1046656 | 1046656 | 2021-02-19 | Morgan | Utah | 49029 | 1116 | 11 |
1043411 | 1043411 | 2021-02-18 | Morgan | Utah | 49029 | 1116 | 11 |
1040166 | 1040166 | 2021-02-17 | Morgan | Utah | 49029 | 1115 | 11 |
1036921 | 1036921 | 2021-02-16 | Morgan | Utah | 49029 | 1114 | 11 |
1033676 | 1033676 | 2021-02-15 | Morgan | Utah | 49029 | 1114 | 11 |
1030430 | 1030430 | 2021-02-14 | Morgan | Utah | 49029 | 1114 | 11 |
1027183 | 1027183 | 2021-02-13 | Morgan | Utah | 49029 | 1114 | 11 |
1023938 | 1023938 | 2021-02-12 | Morgan | Utah | 49029 | 1112 | 11 |
1020693 | 1020693 | 2021-02-11 | Morgan | Utah | 49029 | 1109 | 11 |
1017448 | 1017448 | 2021-02-10 | Morgan | Utah | 49029 | 1105 | 10 |
1014203 | 1014203 | 2021-02-09 | Morgan | Utah | 49029 | 1102 | 10 |
1010958 | 1010958 | 2021-02-08 | Morgan | Utah | 49029 | 1101 | 10 |
1007712 | 1007712 | 2021-02-07 | Morgan | Utah | 49029 | 1100 | 10 |
1004466 | 1004466 | 2021-02-06 | Morgan | Utah | 49029 | 1099 | 10 |
1001220 | 1001220 | 2021-02-05 | Morgan | Utah | 49029 | 1098 | 8 |
997974 | 997974 | 2021-02-04 | Morgan | Utah | 49029 | 1094 | 8 |
994728 | 994728 | 2021-02-03 | Morgan | Utah | 49029 | 1092 | 8 |
991482 | 991482 | 2021-02-02 | Morgan | Utah | 49029 | 1091 | 8 |
988236 | 988236 | 2021-02-01 | Morgan | Utah | 49029 | 1089 | 8 |
984989 | 984989 | 2021-01-31 | Morgan | Utah | 49029 | 1087 | 8 |
981742 | 981742 | 2021-01-30 | Morgan | Utah | 49029 | 1087 | 8 |
978496 | 978496 | 2021-01-29 | Morgan | Utah | 49029 | 1083 | 8 |
975251 | 975251 | 2021-01-28 | Morgan | Utah | 49029 | 1081 | 8 |
972006 | 972006 | 2021-01-27 | Morgan | Utah | 49029 | 1077 | 8 |
968761 | 968761 | 2021-01-26 | Morgan | Utah | 49029 | 1072 | 8 |
965517 | 965517 | 2021-01-25 | Morgan | Utah | 49029 | 1064 | 7 |
962272 | 962272 | 2021-01-24 | Morgan | Utah | 49029 | 1059 | 7 |
959027 | 959027 | 2021-01-23 | Morgan | Utah | 49029 | 1059 | 7 |
955781 | 955781 | 2021-01-22 | Morgan | Utah | 49029 | 1058 | 7 |
952536 | 952536 | 2021-01-21 | Morgan | Utah | 49029 | 1048 | 7 |
949291 | 949291 | 2021-01-20 | Morgan | Utah | 49029 | 1017 | 7 |
946045 | 946045 | 2021-01-19 | Morgan | Utah | 49029 | 1017 | 7 |
942798 | 942798 | 2021-01-18 | Morgan | Utah | 49029 | 1017 | 7 |
939553 | 939553 | 2021-01-17 | Morgan | Utah | 49029 | 1012 | 7 |
936308 | 936308 | 2021-01-16 | Morgan | Utah | 49029 | 1010 | 7 |
933063 | 933063 | 2021-01-15 | Morgan | Utah | 49029 | 1006 | 7 |
929818 | 929818 | 2021-01-14 | Morgan | Utah | 49029 | 997 | 7 |
926573 | 926573 | 2021-01-13 | Morgan | Utah | 49029 | 981 | 7 |
923327 | 923327 | 2021-01-12 | Morgan | Utah | 49029 | 981 | 7 |
920082 | 920082 | 2021-01-11 | Morgan | Utah | 49029 | 974 | 7 |
916837 | 916837 | 2021-01-10 | Morgan | Utah | 49029 | 970 | 7 |
913592 | 913592 | 2021-01-09 | Morgan | Utah | 49029 | 966 | 7 |
910347 | 910347 | 2021-01-08 | Morgan | Utah | 49029 | 949 | 7 |
907102 | 907102 | 2021-01-07 | Morgan | Utah | 49029 | 945 | 7 |
903856 | 903856 | 2021-01-06 | Morgan | Utah | 49029 | 931 | 7 |
900611 | 900611 | 2021-01-05 | Morgan | Utah | 49029 | 920 | 7 |
897366 | 897366 | 2021-01-04 | Morgan | Utah | 49029 | 904 | 7 |
894120 | 894120 | 2021-01-03 | Morgan | Utah | 49029 | 879 | 7 |
890874 | 890874 | 2021-01-02 | Morgan | Utah | 49029 | 879 | 7 |
887627 | 887627 | 2021-01-01 | Morgan | Utah | 49029 | 874 | 7 |
884382 | 884382 | 2020-12-31 | Morgan | Utah | 49029 | 867 | 7 |
881137 | 881137 | 2020-12-30 | Morgan | Utah | 49029 | 853 | 7 |
877892 | 877892 | 2020-12-29 | Morgan | Utah | 49029 | 838 | 7 |
874647 | 874647 | 2020-12-28 | Morgan | Utah | 49029 | 827 | 7 |
871402 | 871402 | 2020-12-27 | Morgan | Utah | 49029 | 817 | 7 |
868157 | 868157 | 2020-12-26 | Morgan | Utah | 49029 | 787 | 7 |
864912 | 864912 | 2020-12-25 | Morgan | Utah | 49029 | 787 | 7 |
861667 | 861667 | 2020-12-24 | Morgan | Utah | 49029 | 787 | 7 |
858422 | 858422 | 2020-12-23 | Morgan | Utah | 49029 | 776 | 7 |
855177 | 855177 | 2020-12-22 | Morgan | Utah | 49029 | 758 | 6 |
851932 | 851932 | 2020-12-21 | Morgan | Utah | 49029 | 745 | 6 |
848687 | 848687 | 2020-12-20 | Morgan | Utah | 49029 | 740 | 6 |
845442 | 845442 | 2020-12-19 | Morgan | Utah | 49029 | 729 | 5 |
842196 | 842196 | 2020-12-18 | Morgan | Utah | 49029 | 708 | 5 |
838951 | 838951 | 2020-12-17 | Morgan | Utah | 49029 | 702 | 4 |
835705 | 835705 | 2020-12-16 | Morgan | Utah | 49029 | 690 | 4 |
832459 | 832459 | 2020-12-15 | Morgan | Utah | 49029 | 679 | 4 |
829212 | 829212 | 2020-12-14 | Morgan | Utah | 49029 | 664 | 4 |
825966 | 825966 | 2020-12-13 | Morgan | Utah | 49029 | 659 | 4 |
822719 | 822719 | 2020-12-12 | Morgan | Utah | 49029 | 639 | 3 |
819473 | 819473 | 2020-12-11 | Morgan | Utah | 49029 | 626 | 3 |
816227 | 816227 | 2020-12-10 | Morgan | Utah | 49029 | 618 | 3 |
812981 | 812981 | 2020-12-09 | Morgan | Utah | 49029 | 613 | 3 |
809737 | 809737 | 2020-12-08 | Morgan | Utah | 49029 | 599 | 3 |
806492 | 806492 | 2020-12-07 | Morgan | Utah | 49029 | 591 | 3 |
803247 | 803247 | 2020-12-06 | Morgan | Utah | 49029 | 586 | 3 |
800002 | 800002 | 2020-12-05 | Morgan | Utah | 49029 | 566 | 3 |
796757 | 796757 | 2020-12-04 | Morgan | Utah | 49029 | 566 | 3 |
793512 | 793512 | 2020-12-03 | Morgan | Utah | 49029 | 557 | 3 |
790267 | 790267 | 2020-12-02 | Morgan | Utah | 49029 | 547 | 3 |
787022 | 787022 | 2020-12-01 | Morgan | Utah | 49029 | 531 | 3 |
783778 | 783778 | 2020-11-30 | Morgan | Utah | 49029 | 512 | 3 |
780533 | 780533 | 2020-11-29 | Morgan | Utah | 49029 | 511 | 3 |
777287 | 777287 | 2020-11-28 | Morgan | Utah | 49029 | 501 | 3 |
774042 | 774042 | 2020-11-27 | Morgan | Utah | 49029 | 495 | 3 |
770797 | 770797 | 2020-11-26 | Morgan | Utah | 49029 | 479 | 3 |
767551 | 767551 | 2020-11-25 | Morgan | Utah | 49029 | 479 | 3 |
764306 | 764306 | 2020-11-24 | Morgan | Utah | 49029 | 465 | 3 |
761061 | 761061 | 2020-11-23 | Morgan | Utah | 49029 | 450 | 2 |
757816 | 757816 | 2020-11-22 | Morgan | Utah | 49029 | 447 | 2 |
754569 | 754569 | 2020-11-21 | Morgan | Utah | 49029 | 435 | 3 |
751323 | 751323 | 2020-11-20 | Morgan | Utah | 49029 | 424 | 2 |
748077 | 748077 | 2020-11-19 | Morgan | Utah | 49029 | 410 | 2 |
744831 | 744831 | 2020-11-18 | Morgan | Utah | 49029 | 391 | 2 |
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);