ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Morgan" and fips = 1103 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1060049 | 1060049 | 2021-02-24 | Morgan | Alabama | 1103 | 13571 | 248 |
1056803 | 1056803 | 2021-02-23 | Morgan | Alabama | 1103 | 13529 | 243 |
1053557 | 1053557 | 2021-02-22 | Morgan | Alabama | 1103 | 13500 | 241 |
1050310 | 1050310 | 2021-02-21 | Morgan | Alabama | 1103 | 13483 | 241 |
1047063 | 1047063 | 2021-02-20 | Morgan | Alabama | 1103 | 13468 | 241 |
1043818 | 1043818 | 2021-02-19 | Morgan | Alabama | 1103 | 13464 | 240 |
1040573 | 1040573 | 2021-02-18 | Morgan | Alabama | 1103 | 13448 | 239 |
1037328 | 1037328 | 2021-02-17 | Morgan | Alabama | 1103 | 13424 | 237 |
1034083 | 1034083 | 2021-02-16 | Morgan | Alabama | 1103 | 13418 | 234 |
1030837 | 1030837 | 2021-02-15 | Morgan | Alabama | 1103 | 13407 | 234 |
1027590 | 1027590 | 2021-02-14 | Morgan | Alabama | 1103 | 13395 | 234 |
1024345 | 1024345 | 2021-02-13 | Morgan | Alabama | 1103 | 13375 | 234 |
1021100 | 1021100 | 2021-02-12 | Morgan | Alabama | 1103 | 13346 | 233 |
1017855 | 1017855 | 2021-02-11 | Morgan | Alabama | 1103 | 13329 | 230 |
1014610 | 1014610 | 2021-02-10 | Morgan | Alabama | 1103 | 13303 | 225 |
1011365 | 1011365 | 2021-02-09 | Morgan | Alabama | 1103 | 13285 | 220 |
1008119 | 1008119 | 2021-02-08 | Morgan | Alabama | 1103 | 13272 | 220 |
1004873 | 1004873 | 2021-02-07 | Morgan | Alabama | 1103 | 13250 | 220 |
1001627 | 1001627 | 2021-02-06 | Morgan | Alabama | 1103 | 13217 | 220 |
998381 | 998381 | 2021-02-05 | Morgan | Alabama | 1103 | 13174 | 217 |
995135 | 995135 | 2021-02-04 | Morgan | Alabama | 1103 | 13143 | 216 |
991889 | 991889 | 2021-02-03 | Morgan | Alabama | 1103 | 13086 | 209 |
988643 | 988643 | 2021-02-02 | Morgan | Alabama | 1103 | 13048 | 188 |
985396 | 985396 | 2021-02-01 | Morgan | Alabama | 1103 | 13025 | 175 |
982149 | 982149 | 2021-01-31 | Morgan | Alabama | 1103 | 13001 | 175 |
978903 | 978903 | 2021-01-30 | Morgan | Alabama | 1103 | 12936 | 171 |
975658 | 975658 | 2021-01-29 | Morgan | Alabama | 1103 | 12936 | 171 |
972413 | 972413 | 2021-01-28 | Morgan | Alabama | 1103 | 12867 | 162 |
969168 | 969168 | 2021-01-27 | Morgan | Alabama | 1103 | 12795 | 154 |
965924 | 965924 | 2021-01-26 | Morgan | Alabama | 1103 | 12741 | 145 |
962679 | 962679 | 2021-01-25 | Morgan | Alabama | 1103 | 12678 | 142 |
959434 | 959434 | 2021-01-24 | Morgan | Alabama | 1103 | 12639 | 142 |
956188 | 956188 | 2021-01-23 | Morgan | Alabama | 1103 | 12594 | 142 |
952943 | 952943 | 2021-01-22 | Morgan | Alabama | 1103 | 12526 | 134 |
949698 | 949698 | 2021-01-21 | Morgan | Alabama | 1103 | 12447 | 129 |
946452 | 946452 | 2021-01-20 | Morgan | Alabama | 1103 | 12389 | 119 |
943205 | 943205 | 2021-01-19 | Morgan | Alabama | 1103 | 12321 | 113 |
939960 | 939960 | 2021-01-18 | Morgan | Alabama | 1103 | 12260 | 113 |
936715 | 936715 | 2021-01-17 | Morgan | Alabama | 1103 | 12233 | 113 |
933470 | 933470 | 2021-01-16 | Morgan | Alabama | 1103 | 12175 | 113 |
930225 | 930225 | 2021-01-15 | Morgan | Alabama | 1103 | 12093 | 112 |
926980 | 926980 | 2021-01-14 | Morgan | Alabama | 1103 | 12002 | 112 |
923734 | 923734 | 2021-01-13 | Morgan | Alabama | 1103 | 11936 | 108 |
920489 | 920489 | 2021-01-12 | Morgan | Alabama | 1103 | 11871 | 104 |
917244 | 917244 | 2021-01-11 | Morgan | Alabama | 1103 | 11781 | 104 |
913999 | 913999 | 2021-01-10 | Morgan | Alabama | 1103 | 11727 | 104 |
910754 | 910754 | 2021-01-09 | Morgan | Alabama | 1103 | 11634 | 104 |
907509 | 907509 | 2021-01-08 | Morgan | Alabama | 1103 | 11485 | 103 |
904263 | 904263 | 2021-01-07 | Morgan | Alabama | 1103 | 11336 | 103 |
901018 | 901018 | 2021-01-06 | Morgan | Alabama | 1103 | 11205 | 100 |
897773 | 897773 | 2021-01-05 | Morgan | Alabama | 1103 | 11118 | 90 |
894527 | 894527 | 2021-01-04 | Morgan | Alabama | 1103 | 11017 | 89 |
891281 | 891281 | 2021-01-03 | Morgan | Alabama | 1103 | 10974 | 89 |
888034 | 888034 | 2021-01-02 | Morgan | Alabama | 1103 | 10912 | 89 |
884789 | 884789 | 2021-01-01 | Morgan | Alabama | 1103 | 10817 | 89 |
881544 | 881544 | 2020-12-31 | Morgan | Alabama | 1103 | 10627 | 87 |
878299 | 878299 | 2020-12-30 | Morgan | Alabama | 1103 | 10482 | 87 |
875054 | 875054 | 2020-12-29 | Morgan | Alabama | 1103 | 10334 | 87 |
871809 | 871809 | 2020-12-28 | Morgan | Alabama | 1103 | 10252 | 87 |
868564 | 868564 | 2020-12-27 | Morgan | Alabama | 1103 | 10196 | 87 |
865319 | 865319 | 2020-12-26 | Morgan | Alabama | 1103 | 10124 | 87 |
862074 | 862074 | 2020-12-25 | Morgan | Alabama | 1103 | 10086 | 87 |
858829 | 858829 | 2020-12-24 | Morgan | Alabama | 1103 | 9927 | 87 |
855584 | 855584 | 2020-12-23 | Morgan | Alabama | 1103 | 9817 | 83 |
852339 | 852339 | 2020-12-22 | Morgan | Alabama | 1103 | 9638 | 78 |
849094 | 849094 | 2020-12-21 | Morgan | Alabama | 1103 | 9464 | 78 |
845849 | 845849 | 2020-12-20 | Morgan | Alabama | 1103 | 9355 | 78 |
842603 | 842603 | 2020-12-19 | Morgan | Alabama | 1103 | 9276 | 78 |
839358 | 839358 | 2020-12-18 | Morgan | Alabama | 1103 | 9138 | 73 |
836113 | 836113 | 2020-12-17 | Morgan | Alabama | 1103 | 8967 | 72 |
832867 | 832867 | 2020-12-16 | Morgan | Alabama | 1103 | 8794 | 70 |
829620 | 829620 | 2020-12-15 | Morgan | Alabama | 1103 | 8662 | 64 |
826374 | 826374 | 2020-12-14 | Morgan | Alabama | 1103 | 8580 | 64 |
823127 | 823127 | 2020-12-13 | Morgan | Alabama | 1103 | 8492 | 64 |
819881 | 819881 | 2020-12-12 | Morgan | Alabama | 1103 | 8393 | 64 |
816635 | 816635 | 2020-12-11 | Morgan | Alabama | 1103 | 8259 | 62 |
813389 | 813389 | 2020-12-10 | Morgan | Alabama | 1103 | 8129 | 62 |
810145 | 810145 | 2020-12-09 | Morgan | Alabama | 1103 | 7974 | 60 |
806900 | 806900 | 2020-12-08 | Morgan | Alabama | 1103 | 7834 | 59 |
803655 | 803655 | 2020-12-07 | Morgan | Alabama | 1103 | 7690 | 58 |
800410 | 800410 | 2020-12-06 | Morgan | Alabama | 1103 | 7600 | 58 |
797165 | 797165 | 2020-12-05 | Morgan | Alabama | 1103 | 7512 | 58 |
793920 | 793920 | 2020-12-04 | Morgan | Alabama | 1103 | 7405 | 55 |
790675 | 790675 | 2020-12-03 | Morgan | Alabama | 1103 | 7228 | 55 |
787430 | 787430 | 2020-12-02 | Morgan | Alabama | 1103 | 7108 | 51 |
784186 | 784186 | 2020-12-01 | Morgan | Alabama | 1103 | 6964 | 51 |
780941 | 780941 | 2020-11-30 | Morgan | Alabama | 1103 | 6861 | 50 |
777695 | 777695 | 2020-11-29 | Morgan | Alabama | 1103 | 6751 | 50 |
774450 | 774450 | 2020-11-28 | Morgan | Alabama | 1103 | 6626 | 50 |
771205 | 771205 | 2020-11-27 | Morgan | Alabama | 1103 | 6538 | 50 |
767959 | 767959 | 2020-11-26 | Morgan | Alabama | 1103 | 6480 | 50 |
764714 | 764714 | 2020-11-25 | Morgan | Alabama | 1103 | 6343 | 48 |
761469 | 761469 | 2020-11-24 | Morgan | Alabama | 1103 | 6262 | 47 |
758224 | 758224 | 2020-11-23 | Morgan | Alabama | 1103 | 6182 | 47 |
754977 | 754977 | 2020-11-22 | Morgan | Alabama | 1103 | 6104 | 47 |
751731 | 751731 | 2020-11-21 | Morgan | Alabama | 1103 | 6031 | 47 |
748485 | 748485 | 2020-11-20 | Morgan | Alabama | 1103 | 5913 | 47 |
745239 | 745239 | 2020-11-19 | Morgan | Alabama | 1103 | 5738 | 44 |
741992 | 741992 | 2020-11-18 | Morgan | Alabama | 1103 | 5640 | 44 |
738745 | 738745 | 2020-11-17 | Morgan | Alabama | 1103 | 5535 | 42 |
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);