ny_times_us_counties

⚠️ 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

11,092 rows where state = "Missouri" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • Missouri · 11,092
Link rowid date ▲ county state fips cases deaths
317928 2020-07-11 Adair Missouri 29001 104 0
317929 2020-07-11 Andrew Missouri 29003 55 1
317930 2020-07-11 Atchison Missouri 29005 6 0
317931 2020-07-11 Audrain Missouri 29007 142 1
317932 2020-07-11 Barry Missouri 29009 96 0
317933 2020-07-11 Barton Missouri 29011 33 0
317934 2020-07-11 Bates Missouri 29013 13 1
317935 2020-07-11 Benton Missouri 29015 22 0
317936 2020-07-11 Bollinger Missouri 29017 21 0
317937 2020-07-11 Boone Missouri 29019 726 2
317938 2020-07-11 Buchanan Missouri 29021 938 5
317939 2020-07-11 Butler Missouri 29023 117 0
317940 2020-07-11 Caldwell Missouri 29025 15 1
317941 2020-07-11 Callaway Missouri 29027 63 1
317942 2020-07-11 Camden Missouri 29029 83 2
317943 2020-07-11 Cape Girardeau Missouri 29031 329 3
317944 2020-07-11 Carroll Missouri 29033 26 0
317945 2020-07-11 Carter Missouri 29035 7 1
317946 2020-07-11 Cass Missouri 29037 239 9
317947 2020-07-11 Cedar Missouri 29039 12 0
317948 2020-07-11 Chariton Missouri 29041 6 0
317949 2020-07-11 Christian Missouri 29043 85 1
317950 2020-07-11 Clark Missouri 29045 2 0
317951 2020-07-11 Clay Missouri 29047 557 20
317952 2020-07-11 Clinton Missouri 29049 33 0
317953 2020-07-11 Cole Missouri 29051 134 2
317954 2020-07-11 Cooper Missouri 29053 28 0
317955 2020-07-11 Crawford Missouri 29055 21 0
317956 2020-07-11 Dade Missouri 29057 2 0
317957 2020-07-11 Dallas Missouri 29059 18 1
317958 2020-07-11 Daviess Missouri 29061 11 0
317959 2020-07-11 DeKalb Missouri 29063 16 0
317960 2020-07-11 Dent Missouri 29065 5 0
317961 2020-07-11 Douglas Missouri 29067 12 0
317962 2020-07-11 Dunklin Missouri 29069 127 3
317963 2020-07-11 Franklin Missouri 29071 273 18
317964 2020-07-11 Gasconade Missouri 29073 15 0
317965 2020-07-11 Gentry Missouri 29075 67 9
317966 2020-07-11 Greene Missouri 29077 510 9
317967 2020-07-11 Grundy Missouri 29079 21 1
317968 2020-07-11 Harrison Missouri 29081 28 0
317969 2020-07-11 Henry Missouri 29083 25 3
317970 2020-07-11 Hickory Missouri 29085 1 0
317971 2020-07-11 Holt Missouri 29087 1 0
317972 2020-07-11 Howard Missouri 29089 5 0
317973 2020-07-11 Howell Missouri 29091 49 0
317974 2020-07-11 Iron Missouri 29093 3 0
317975 2020-07-11 Jackson Missouri 29095 1657 43
317976 2020-07-11 Jasper Missouri 29097 761 1
317977 2020-07-11 Jefferson Missouri 29099 666 23
317978 2020-07-11 Johnson Missouri 29101 238 2
317979 2020-07-11 Joplin Missouri   254 14
317980 2020-07-11 Kansas City Missouri   3086 38
317981 2020-07-11 Knox Missouri 29103 2 0
317982 2020-07-11 Laclede Missouri 29105 85 1
317983 2020-07-11 Lafayette Missouri 29107 102 2
317984 2020-07-11 Lawrence Missouri 29109 58 1
317985 2020-07-11 Lewis Missouri 29111 8 1
317986 2020-07-11 Lincoln Missouri 29113 112 1
317987 2020-07-11 Linn Missouri 29115 20 1
317988 2020-07-11 Livingston Missouri 29117 25 0
317989 2020-07-11 Macon Missouri 29121 24 0
317990 2020-07-11 Madison Missouri 29123 7 0
317991 2020-07-11 Maries Missouri 29125 7 0
317992 2020-07-11 Marion Missouri 29127 31 0
317993 2020-07-11 McDonald Missouri 29119 855 1
317994 2020-07-11 Mercer Missouri 29129 7 0
317995 2020-07-11 Miller Missouri 29131 24 0
317996 2020-07-11 Mississippi Missouri 29133 100 0
317997 2020-07-11 Moniteau Missouri 29135 72 1
317998 2020-07-11 Monroe Missouri 29137 5 0
317999 2020-07-11 Montgomery Missouri 29139 22 0
318000 2020-07-11 Morgan Missouri 29141 27 0
318001 2020-07-11 New Madrid Missouri 29143 51 1
318002 2020-07-11 Newton Missouri 29145 550 2
318003 2020-07-11 Nodaway Missouri 29147 26 0
318004 2020-07-11 Oregon Missouri 29149 9 0
318005 2020-07-11 Osage Missouri 29151 13 0
318006 2020-07-11 Ozark Missouri 29153 2 0
318007 2020-07-11 Pemiscot Missouri 29155 116 6
318008 2020-07-11 Perry Missouri 29157 170 3
318009 2020-07-11 Pettis Missouri 29159 154 1
318010 2020-07-11 Phelps Missouri 29161 53 0
318011 2020-07-11 Pike Missouri 29163 40 1
318012 2020-07-11 Platte Missouri 29165 158 6
318013 2020-07-11 Polk Missouri 29167 20 0
318014 2020-07-11 Pulaski Missouri 29169 140 1
318015 2020-07-11 Putnam Missouri 29171 3 0
318016 2020-07-11 Ralls Missouri 29173 10 0
318017 2020-07-11 Randolph Missouri 29175 17 0
318018 2020-07-11 Ray Missouri 29177 30 0
318019 2020-07-11 Reynolds Missouri 29179 6 0
318020 2020-07-11 Ripley Missouri 29181 20 0
318021 2020-07-11 Saline Missouri 29195 309 5
318022 2020-07-11 Schuyler Missouri 29197 5 0
318023 2020-07-11 Scotland Missouri 29199 11 1
318024 2020-07-11 Scott Missouri 29201 206 12
318025 2020-07-11 Shannon Missouri 29203 27 0
318026 2020-07-11 Shelby Missouri 29205 5 0
318027 2020-07-11 St. Charles Missouri 29183 1599 77

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
);
Powered by Datasette · Query took 1099.512ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette