ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Morgan" and fips = 29141 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1064811 | 1064811 | 2021-02-25 | Morgan | Missouri | 29141 | 1621 | 40 |
1061567 | 1061567 | 2021-02-24 | Morgan | Missouri | 29141 | 1621 | 40 |
1058321 | 1058321 | 2021-02-23 | Morgan | Missouri | 29141 | 1621 | 40 |
1055075 | 1055075 | 2021-02-22 | Morgan | Missouri | 29141 | 1620 | 39 |
1051828 | 1051828 | 2021-02-21 | Morgan | Missouri | 29141 | 1620 | 39 |
1048581 | 1048581 | 2021-02-20 | Morgan | Missouri | 29141 | 1620 | 39 |
1045335 | 1045335 | 2021-02-19 | Morgan | Missouri | 29141 | 1619 | 39 |
1042090 | 1042090 | 2021-02-18 | Morgan | Missouri | 29141 | 1619 | 39 |
1038845 | 1038845 | 2021-02-17 | Morgan | Missouri | 29141 | 1619 | 39 |
1035600 | 1035600 | 2021-02-16 | Morgan | Missouri | 29141 | 1619 | 39 |
1032355 | 1032355 | 2021-02-15 | Morgan | Missouri | 29141 | 1618 | 39 |
1029108 | 1029108 | 2021-02-14 | Morgan | Missouri | 29141 | 1616 | 39 |
1025862 | 1025862 | 2021-02-13 | Morgan | Missouri | 29141 | 1614 | 39 |
1022617 | 1022617 | 2021-02-12 | Morgan | Missouri | 29141 | 1613 | 39 |
1019372 | 1019372 | 2021-02-11 | Morgan | Missouri | 29141 | 1614 | 39 |
1016127 | 1016127 | 2021-02-10 | Morgan | Missouri | 29141 | 1609 | 39 |
1012882 | 1012882 | 2021-02-09 | Morgan | Missouri | 29141 | 1608 | 39 |
1009637 | 1009637 | 2021-02-08 | Morgan | Missouri | 29141 | 1608 | 37 |
1006390 | 1006390 | 2021-02-07 | Morgan | Missouri | 29141 | 1608 | 37 |
1003144 | 1003144 | 2021-02-06 | Morgan | Missouri | 29141 | 1607 | 37 |
999899 | 999899 | 2021-02-05 | Morgan | Missouri | 29141 | 1603 | 36 |
996653 | 996653 | 2021-02-04 | Morgan | Missouri | 29141 | 1602 | 36 |
993407 | 993407 | 2021-02-03 | Morgan | Missouri | 29141 | 1597 | 36 |
990161 | 990161 | 2021-02-02 | Morgan | Missouri | 29141 | 1597 | 36 |
986914 | 986914 | 2021-02-01 | Morgan | Missouri | 29141 | 1594 | 36 |
983667 | 983667 | 2021-01-31 | Morgan | Missouri | 29141 | 1591 | 36 |
980421 | 980421 | 2021-01-30 | Morgan | Missouri | 29141 | 1589 | 36 |
977175 | 977175 | 2021-01-29 | Morgan | Missouri | 29141 | 1589 | 34 |
973930 | 973930 | 2021-01-28 | Morgan | Missouri | 29141 | 1584 | 34 |
970685 | 970685 | 2021-01-27 | Morgan | Missouri | 29141 | 1584 | 34 |
967440 | 967440 | 2021-01-26 | Morgan | Missouri | 29141 | 1584 | 34 |
964196 | 964196 | 2021-01-25 | Morgan | Missouri | 29141 | 1580 | 34 |
960951 | 960951 | 2021-01-24 | Morgan | Missouri | 29141 | 1577 | 34 |
957705 | 957705 | 2021-01-23 | Morgan | Missouri | 29141 | 1574 | 34 |
954460 | 954460 | 2021-01-22 | Morgan | Missouri | 29141 | 1572 | 34 |
951215 | 951215 | 2021-01-21 | Morgan | Missouri | 29141 | 1571 | 31 |
947969 | 947969 | 2021-01-20 | Morgan | Missouri | 29141 | 1569 | 31 |
944722 | 944722 | 2021-01-19 | Morgan | Missouri | 29141 | 1567 | 31 |
941477 | 941477 | 2021-01-18 | Morgan | Missouri | 29141 | 1567 | 31 |
938232 | 938232 | 2021-01-17 | Morgan | Missouri | 29141 | 1565 | 31 |
934987 | 934987 | 2021-01-16 | Morgan | Missouri | 29141 | 1564 | 31 |
931742 | 931742 | 2021-01-15 | Morgan | Missouri | 29141 | 1559 | 31 |
928497 | 928497 | 2021-01-14 | Morgan | Missouri | 29141 | 1553 | 31 |
925251 | 925251 | 2021-01-13 | Morgan | Missouri | 29141 | 1544 | 31 |
922006 | 922006 | 2021-01-12 | Morgan | Missouri | 29141 | 1540 | 31 |
918761 | 918761 | 2021-01-11 | Morgan | Missouri | 29141 | 1536 | 30 |
915516 | 915516 | 2021-01-10 | Morgan | Missouri | 29141 | 1532 | 30 |
912271 | 912271 | 2021-01-09 | Morgan | Missouri | 29141 | 1523 | 30 |
909026 | 909026 | 2021-01-08 | Morgan | Missouri | 29141 | 1513 | 24 |
905780 | 905780 | 2021-01-07 | Morgan | Missouri | 29141 | 1500 | 24 |
902535 | 902535 | 2021-01-06 | Morgan | Missouri | 29141 | 1484 | 24 |
899290 | 899290 | 2021-01-05 | Morgan | Missouri | 29141 | 1480 | 24 |
896045 | 896045 | 2021-01-04 | Morgan | Missouri | 29141 | 1475 | 24 |
892798 | 892798 | 2021-01-03 | Morgan | Missouri | 29141 | 1475 | 24 |
889552 | 889552 | 2021-01-02 | Morgan | Missouri | 29141 | 1465 | 24 |
886306 | 886306 | 2021-01-01 | Morgan | Missouri | 29141 | 1458 | 24 |
883061 | 883061 | 2020-12-31 | Morgan | Missouri | 29141 | 1444 | 24 |
879816 | 879816 | 2020-12-30 | Morgan | Missouri | 29141 | 1436 | 24 |
876571 | 876571 | 2020-12-29 | Morgan | Missouri | 29141 | 1423 | 23 |
873326 | 873326 | 2020-12-28 | Morgan | Missouri | 29141 | 1414 | 21 |
870081 | 870081 | 2020-12-27 | Morgan | Missouri | 29141 | 1410 | 21 |
866836 | 866836 | 2020-12-26 | Morgan | Missouri | 29141 | 1408 | 21 |
863591 | 863591 | 2020-12-25 | Morgan | Missouri | 29141 | 1402 | 21 |
860346 | 860346 | 2020-12-24 | Morgan | Missouri | 29141 | 1398 | 21 |
857101 | 857101 | 2020-12-23 | Morgan | Missouri | 29141 | 1393 | 21 |
853856 | 853856 | 2020-12-22 | Morgan | Missouri | 29141 | 1388 | 21 |
850611 | 850611 | 2020-12-21 | Morgan | Missouri | 29141 | 1382 | 16 |
847366 | 847366 | 2020-12-20 | Morgan | Missouri | 29141 | 1374 | 16 |
844120 | 844120 | 2020-12-19 | Morgan | Missouri | 29141 | 1364 | 16 |
840875 | 840875 | 2020-12-18 | Morgan | Missouri | 29141 | 1350 | 16 |
837630 | 837630 | 2020-12-17 | Morgan | Missouri | 29141 | 1343 | 16 |
834384 | 834384 | 2020-12-16 | Morgan | Missouri | 29141 | 1314 | 15 |
831137 | 831137 | 2020-12-15 | Morgan | Missouri | 29141 | 1306 | 15 |
827891 | 827891 | 2020-12-14 | Morgan | Missouri | 29141 | 1296 | 14 |
824644 | 824644 | 2020-12-13 | Morgan | Missouri | 29141 | 1291 | 14 |
821398 | 821398 | 2020-12-12 | Morgan | Missouri | 29141 | 1280 | 14 |
818152 | 818152 | 2020-12-11 | Morgan | Missouri | 29141 | 1242 | 13 |
814906 | 814906 | 2020-12-10 | Morgan | Missouri | 29141 | 1242 | 13 |
811661 | 811661 | 2020-12-09 | Morgan | Missouri | 29141 | 1220 | 13 |
808416 | 808416 | 2020-12-08 | Morgan | Missouri | 29141 | 1202 | 14 |
805171 | 805171 | 2020-12-07 | Morgan | Missouri | 29141 | 1181 | 13 |
801926 | 801926 | 2020-12-06 | Morgan | Missouri | 29141 | 1174 | 13 |
798681 | 798681 | 2020-12-05 | Morgan | Missouri | 29141 | 1158 | 13 |
795436 | 795436 | 2020-12-04 | Morgan | Missouri | 29141 | 1129 | 13 |
792191 | 792191 | 2020-12-03 | Morgan | Missouri | 29141 | 1104 | 13 |
788946 | 788946 | 2020-12-02 | Morgan | Missouri | 29141 | 1089 | 12 |
785701 | 785701 | 2020-12-01 | Morgan | Missouri | 29141 | 1085 | 12 |
782457 | 782457 | 2020-11-30 | Morgan | Missouri | 29141 | 1079 | 12 |
779211 | 779211 | 2020-11-29 | Morgan | Missouri | 29141 | 1068 | 12 |
775966 | 775966 | 2020-11-28 | Morgan | Missouri | 29141 | 1056 | 12 |
772721 | 772721 | 2020-11-27 | Morgan | Missouri | 29141 | 1051 | 12 |
769476 | 769476 | 2020-11-26 | Morgan | Missouri | 29141 | 1043 | 12 |
766230 | 766230 | 2020-11-25 | Morgan | Missouri | 29141 | 1027 | 12 |
762985 | 762985 | 2020-11-24 | Morgan | Missouri | 29141 | 1021 | 12 |
759740 | 759740 | 2020-11-23 | Morgan | Missouri | 29141 | 1012 | 9 |
756493 | 756493 | 2020-11-22 | Morgan | Missouri | 29141 | 995 | 9 |
753247 | 753247 | 2020-11-21 | Morgan | Missouri | 29141 | 989 | 9 |
750001 | 750001 | 2020-11-20 | Morgan | Missouri | 29141 | 972 | 9 |
746755 | 746755 | 2020-11-19 | Morgan | Missouri | 29141 | 961 | 9 |
743508 | 743508 | 2020-11-18 | Morgan | Missouri | 29141 | 944 | 9 |
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);