ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

3,313 rows where county = "Morgan" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

county

  • Morgan · 3,313 ✖
Link rowid date ▲ county state fips cases deaths
953023 953023 2021-01-22 Morgan Alabama 1103 12526 134
953260 953260 2021-01-22 Morgan Colorado 8087 2335 86
953465 953465 2021-01-22 Morgan Georgia 13211 1568 11
953640 953640 2021-01-22 Morgan Illinois 17137 3362 93
953728 953728 2021-01-22 Morgan Indiana 18109 5370 100
954059 954059 2021-01-22 Morgan Kentucky 21175 1741 0
954540 954540 2021-01-22 Morgan Missouri 29141 1572 34
955088 955088 2021-01-22 Morgan Ohio 39115 826 29
955561 955561 2021-01-22 Morgan Tennessee 47129 1939 16
955861 955861 2021-01-22 Morgan Utah 49029 1058 7
956099 956099 2021-01-22 Morgan West Virginia 54065 838 10
949778 949778 2021-01-21 Morgan Alabama 1103 12447 129
950015 950015 2021-01-21 Morgan Colorado 8087 2330 86
950220 950220 2021-01-21 Morgan Georgia 13211 1556 11
950395 950395 2021-01-21 Morgan Illinois 17137 3347 92
950483 950483 2021-01-21 Morgan Indiana 18109 5320 99
950814 950814 2021-01-21 Morgan Kentucky 21175 1734 0
951295 951295 2021-01-21 Morgan Missouri 29141 1571 31
951843 951843 2021-01-21 Morgan Ohio 39115 822 29
952316 952316 2021-01-21 Morgan Tennessee 47129 1926 16
952616 952616 2021-01-21 Morgan Utah 49029 1048 7
952854 952854 2021-01-21 Morgan West Virginia 54065 833 10
946532 946532 2021-01-20 Morgan Alabama 1103 12389 119
946769 946769 2021-01-20 Morgan Colorado 8087 2313 86
946974 946974 2021-01-20 Morgan Georgia 13211 1525 11
947149 947149 2021-01-20 Morgan Illinois 17137 3347 91
947237 947237 2021-01-20 Morgan Indiana 18109 5277 99
947568 947568 2021-01-20 Morgan Kentucky 21175 1723 0
948049 948049 2021-01-20 Morgan Missouri 29141 1569 31
948598 948598 2021-01-20 Morgan Ohio 39115 804 29
949071 949071 2021-01-20 Morgan Tennessee 47129 1912 15
949371 949371 2021-01-20 Morgan Utah 49029 1017 7
949609 949609 2021-01-20 Morgan West Virginia 54065 830 10
943285 943285 2021-01-19 Morgan Alabama 1103 12321 113
943522 943522 2021-01-19 Morgan Colorado 8087 2308 86
943727 943727 2021-01-19 Morgan Georgia 13211 1510 11
943902 943902 2021-01-19 Morgan Illinois 17137 3347 90
943990 943990 2021-01-19 Morgan Indiana 18109 5256 97
944321 944321 2021-01-19 Morgan Kentucky 21175 1709 0
944802 944802 2021-01-19 Morgan Missouri 29141 1567 31
945352 945352 2021-01-19 Morgan Ohio 39115 797 28
945825 945825 2021-01-19 Morgan Tennessee 47129 1898 15
946125 946125 2021-01-19 Morgan Utah 49029 1017 7
946363 946363 2021-01-19 Morgan West Virginia 54065 827 10
940040 940040 2021-01-18 Morgan Alabama 1103 12260 113
940277 940277 2021-01-18 Morgan Colorado 8087 2305 86
940482 940482 2021-01-18 Morgan Georgia 13211 1481 10
940657 940657 2021-01-18 Morgan Illinois 17137 3306 90
940745 940745 2021-01-18 Morgan Indiana 18109 5209 96
941076 941076 2021-01-18 Morgan Kentucky 21175 1704 0
941557 941557 2021-01-18 Morgan Missouri 29141 1567 31
942105 942105 2021-01-18 Morgan Ohio 39115 796 28
942578 942578 2021-01-18 Morgan Tennessee 47129 1890 15
942878 942878 2021-01-18 Morgan Utah 49029 1017 7
943116 943116 2021-01-18 Morgan West Virginia 54065 819 10
936795 936795 2021-01-17 Morgan Alabama 1103 12233 113
937032 937032 2021-01-17 Morgan Colorado 8087 2302 86
937237 937237 2021-01-17 Morgan Georgia 13211 1474 10
937412 937412 2021-01-17 Morgan Illinois 17137 3306 90
937500 937500 2021-01-17 Morgan Indiana 18109 5177 96
937831 937831 2021-01-17 Morgan Kentucky 21175 1700 0
938312 938312 2021-01-17 Morgan Missouri 29141 1565 31
938860 938860 2021-01-17 Morgan Ohio 39115 791 28
939333 939333 2021-01-17 Morgan Tennessee 47129 1886 14
939633 939633 2021-01-17 Morgan Utah 49029 1012 7
939871 939871 2021-01-17 Morgan West Virginia 54065 813 9
933550 933550 2021-01-16 Morgan Alabama 1103 12175 113
933787 933787 2021-01-16 Morgan Colorado 8087 2297 85
933992 933992 2021-01-16 Morgan Georgia 13211 1465 10
934167 934167 2021-01-16 Morgan Illinois 17137 3306 90
934255 934255 2021-01-16 Morgan Indiana 18109 5138 93
934586 934586 2021-01-16 Morgan Kentucky 21175 1697 0
935067 935067 2021-01-16 Morgan Missouri 29141 1564 31
935615 935615 2021-01-16 Morgan Ohio 39115 782 27
936088 936088 2021-01-16 Morgan Tennessee 47129 1871 14
936388 936388 2021-01-16 Morgan Utah 49029 1010 7
936626 936626 2021-01-16 Morgan West Virginia 54065 811 9
930305 930305 2021-01-15 Morgan Alabama 1103 12093 112
930542 930542 2021-01-15 Morgan Colorado 8087 2292 85
930747 930747 2021-01-15 Morgan Georgia 13211 1451 10
930922 930922 2021-01-15 Morgan Illinois 17137 3306 90
931010 931010 2021-01-15 Morgan Indiana 18109 5107 92
931341 931341 2021-01-15 Morgan Kentucky 21175 1631 0
931822 931822 2021-01-15 Morgan Missouri 29141 1559 31
932370 932370 2021-01-15 Morgan Ohio 39115 770 26
932843 932843 2021-01-15 Morgan Tennessee 47129 1866 15
933143 933143 2021-01-15 Morgan Utah 49029 1006 7
933381 933381 2021-01-15 Morgan West Virginia 54065 800 9
927060 927060 2021-01-14 Morgan Alabama 1103 12002 112
927297 927297 2021-01-14 Morgan Colorado 8087 2282 85
927502 927502 2021-01-14 Morgan Georgia 13211 1444 10
927677 927677 2021-01-14 Morgan Illinois 17137 3289 90
927765 927765 2021-01-14 Morgan Indiana 18109 5029 90
928096 928096 2021-01-14 Morgan Kentucky 21175 1602 0
928577 928577 2021-01-14 Morgan Missouri 29141 1553 31
929125 929125 2021-01-14 Morgan Ohio 39115 758 26
929598 929598 2021-01-14 Morgan Tennessee 47129 1836 13
929898 929898 2021-01-14 Morgan Utah 49029 997 7
930136 930136 2021-01-14 Morgan West Virginia 54065 795 9
923814 923814 2021-01-13 Morgan Alabama 1103 11936 108

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);