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

38,002 rows where state = "Missouri" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

state

  • Missouri · 38,002 ✖
Link rowid date ▲ county state fips cases deaths
1067984 1067984 2021-02-26 Adair Missouri 29001 2302 20
1067985 1067985 2021-02-26 Andrew Missouri 29003 1282 17
1067986 1067986 2021-02-26 Atchison Missouri 29005 290 6
1067987 1067987 2021-02-26 Audrain Missouri 29007 2073 58
1067988 1067988 2021-02-26 Barry Missouri 29009 2187 44
1067989 1067989 2021-02-26 Barton Missouri 29011 963 12
1067990 1067990 2021-02-26 Bates Missouri 29013 1078 23
1067991 1067991 2021-02-26 Benton Missouri 29015 1450 26
1067992 1067992 2021-02-26 Bollinger Missouri 29017 1053 12
1067993 1067993 2021-02-26 Boone Missouri 29019 17421 80
1067994 1067994 2021-02-26 Buchanan Missouri 29021 10056 171
1067995 1067995 2021-02-26 Butler Missouri 29023 3478 34
1067996 1067996 2021-02-26 Caldwell Missouri 29025 641 10
1067997 1067997 2021-02-26 Callaway Missouri 29027 4478 43
1067998 1067998 2021-02-26 Camden Missouri 29029 3718 81
1067999 1067999 2021-02-26 Cape Girardeau Missouri 29031 9293 132
1068000 1068000 2021-02-26 Carroll Missouri 29033 834 23
1068001 1068001 2021-02-26 Carter Missouri 29035 424 8
1068002 1068002 2021-02-26 Cass Missouri 29037 7223 89
1068003 1068003 2021-02-26 Cedar Missouri 29039 671 17
1068004 1068004 2021-02-26 Chariton Missouri 29041 421 6
1068005 1068005 2021-02-26 Christian Missouri 29043 8468 78
1068006 1068006 2021-02-26 Clark Missouri 29045 472 6
1068007 1068007 2021-02-26 Clay Missouri 29047 9502 144
1068008 1068008 2021-02-26 Clinton Missouri 29049 1525 64
1068009 1068009 2021-02-26 Cole Missouri 29051 8568 114
1068010 1068010 2021-02-26 Cooper Missouri 29053 1689 26
1068011 1068011 2021-02-26 Crawford Missouri 29055 2048 30
1068012 1068012 2021-02-26 Dade Missouri 29057 705 30
1068013 1068013 2021-02-26 Dallas Missouri 29059 826 24
1068014 1068014 2021-02-26 Daviess Missouri 29061 587 11
1068015 1068015 2021-02-26 DeKalb Missouri 29063 920 27
1068016 1068016 2021-02-26 Dent Missouri 29065 820 16
1068017 1068017 2021-02-26 Douglas Missouri 29067 768 25
1068018 1068018 2021-02-26 Dunklin Missouri 29069 2412 19
1068019 1068019 2021-02-26 Franklin Missouri 29071 8409 154
1068020 1068020 2021-02-26 Gasconade Missouri 29073 876 39
1068021 1068021 2021-02-26 Gentry Missouri 29075 734 20
1068022 1068022 2021-02-26 Greene Missouri 29077 27587 427
1068023 1068023 2021-02-26 Grundy Missouri 29079 828 34
1068024 1068024 2021-02-26 Harrison Missouri 29081 828 14
1068025 1068025 2021-02-26 Henry Missouri 29083 1741 36
1068026 1068026 2021-02-26 Hickory Missouri 29085 467 13
1068027 1068027 2021-02-26 Holt Missouri 29087 366 10
1068028 1068028 2021-02-26 Howard Missouri 29089 716 5
1068029 1068029 2021-02-26 Howell Missouri 29091 2816 42
1068030 1068030 2021-02-26 Iron Missouri 29093 464 5
1068031 1068031 2021-02-26 Jackson Missouri 29095 30082 380
1068032 1068032 2021-02-26 Jasper Missouri 29097 7427 116
1068033 1068033 2021-02-26 Jefferson Missouri 29099 21608 210
1068034 1068034 2021-02-26 Johnson Missouri 29101 3871 45
1068035 1068035 2021-02-26 Joplin Missouri   4785 100
1068036 1068036 2021-02-26 Kansas City Missouri   36643 515
1068037 1068037 2021-02-26 Knox Missouri 29103 179 2
1068038 1068038 2021-02-26 Laclede Missouri 29105 2919 66
1068039 1068039 2021-02-26 Lafayette Missouri 29107 2553 54
1068040 1068040 2021-02-26 Lawrence Missouri 29109 2755 71
1068041 1068041 2021-02-26 Lewis Missouri 29111 629 7
1068042 1068042 2021-02-26 Lincoln Missouri 29113 4289 36
1068043 1068043 2021-02-26 Linn Missouri 29115 541 12
1068044 1068044 2021-02-26 Livingston Missouri 29117 1330 37
1068045 1068045 2021-02-26 Macon Missouri 29121 1211 14
1068046 1068046 2021-02-26 Madison Missouri 29123 1343 16
1068047 1068047 2021-02-26 Maries Missouri 29125 535 7
1068048 1068048 2021-02-26 Marion Missouri 29127 2645 41
1068049 1068049 2021-02-26 McDonald Missouri 29119 2449 31
1068050 1068050 2021-02-26 Mercer Missouri 29129 177 2
1068051 1068051 2021-02-26 Miller Missouri 29131 2315 49
1068052 1068052 2021-02-26 Mississippi Missouri 29133 1266 24
1068053 1068053 2021-02-26 Moniteau Missouri 29135 1679 29
1068054 1068054 2021-02-26 Monroe Missouri 29137 596 10
1068055 1068055 2021-02-26 Montgomery Missouri 29139 567 10
1068056 1068056 2021-02-26 Morgan Missouri 29141 1621 40
1068057 1068057 2021-02-26 New Madrid Missouri 29143 1768 45
1068058 1068058 2021-02-26 Newton Missouri 29145 4076 66
1068059 1068059 2021-02-26 Nodaway Missouri 29147 2559 24
1068060 1068060 2021-02-26 Oregon Missouri 29149 676 3
1068061 1068061 2021-02-26 Osage Missouri 29151 1401 13
1068062 1068062 2021-02-26 Ozark Missouri 29153 550 13
1068063 1068063 2021-02-26 Pemiscot Missouri 29155 1412 28
1068064 1068064 2021-02-26 Perry Missouri 29157 2046 26
1068065 1068065 2021-02-26 Pettis Missouri 29159 4917 76
1068066 1068066 2021-02-26 Phelps Missouri 29161 3018 121
1068067 1068067 2021-02-26 Pike Missouri 29163 1485 22
1068068 1068068 2021-02-26 Platte Missouri 29165 3111 42
1068069 1068069 2021-02-26 Polk Missouri 29167 3225 39
1068070 1068070 2021-02-26 Pulaski Missouri 29169 2988 44
1068071 1068071 2021-02-26 Putnam Missouri 29171 225 3
1068072 1068072 2021-02-26 Ralls Missouri 29173 758 12
1068073 1068073 2021-02-26 Randolph Missouri 29175 1812 29
1068074 1068074 2021-02-26 Ray Missouri 29177 1512 24
1068075 1068075 2021-02-26 Reynolds Missouri 29179 464 4
1068076 1068076 2021-02-26 Ripley Missouri 29181 854 14
1068077 1068077 2021-02-26 Saline Missouri 29195 2424 35
1068078 1068078 2021-02-26 Schuyler Missouri 29197 268 3
1068079 1068079 2021-02-26 Scotland Missouri 29199 263 3
1068080 1068080 2021-02-26 Scott Missouri 29201 3816 76
1068081 1068081 2021-02-26 Shannon Missouri 29203 481 10
1068082 1068082 2021-02-26 Shelby Missouri 29205 353 7
1068083 1068083 2021-02-26 St. Charles Missouri 29183 35426 426

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]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);