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

65,966 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 · 65,966 ✖
Link rowid date ▲ county state fips cases deaths
1844105 1844105 2021-10-23 Adair Missouri 29001 3609 34
1844106 1844106 2021-10-23 Andrew Missouri 29003 2758 24
1844107 1844107 2021-10-23 Atchison Missouri 29005 669 7
1844108 1844108 2021-10-23 Audrain Missouri 29007 3723 64
1844109 1844109 2021-10-23 Barry Missouri 29009 4287 60
1844110 1844110 2021-10-23 Barton Missouri 29011 1795 27
1844111 1844111 2021-10-23 Bates Missouri 29013 2297 43
1844112 1844112 2021-10-23 Benton Missouri 29015 2596 45
1844113 1844113 2021-10-23 Bollinger Missouri 29017 1762 20
1844114 1844114 2021-10-23 Boone Missouri 29019 25341 169
1844115 1844115 2021-10-23 Buchanan Missouri 29021 15135 222
1844116 1844116 2021-10-23 Butler Missouri 29023 6688 71
1844117 1844117 2021-10-23 Caldwell Missouri 29025 1130 20
1844118 1844118 2021-10-23 Callaway Missouri 29027 7409 69
1844119 1844119 2021-10-23 Camden Missouri 29029 6297 123
1844120 1844120 2021-10-23 Cape Girardeau Missouri 29031 13041 153
1844121 1844121 2021-10-23 Carroll Missouri 29033 1373 27
1844122 1844122 2021-10-23 Carter Missouri 29035 1073 14
1844123 1844123 2021-10-23 Cass Missouri 29037 14282 162
1844124 1844124 2021-10-23 Cedar Missouri 29039 1674 30
1844125 1844125 2021-10-23 Chariton Missouri 29041 1033 8
1844126 1844126 2021-10-23 Christian Missouri 29043 12883 157
1844127 1844127 2021-10-23 Clark Missouri 29045 989 12
1844128 1844128 2021-10-23 Clay Missouri 29047 14865 215
1844129 1844129 2021-10-23 Clinton Missouri 29049 2841 77
1844130 1844130 2021-10-23 Cole Missouri 29051 12854 171
1844131 1844131 2021-10-23 Cooper Missouri 29053 2741 33
1844132 1844132 2021-10-23 Crawford Missouri 29055 3602 57
1844133 1844133 2021-10-23 Dade Missouri 29057 865 17
1844134 1844134 2021-10-23 Dallas Missouri 29059 2257 42
1844135 1844135 2021-10-23 Daviess Missouri 29061 1028 14
1844136 1844136 2021-10-23 DeKalb Missouri 29063 1466 33
1844137 1844137 2021-10-23 Dent Missouri 29065 1925 41
1844138 1844138 2021-10-23 Douglas Missouri 29067 1628 46
1844139 1844139 2021-10-23 Dunklin Missouri 29069 4323 61
1844140 1844140 2021-10-23 Franklin Missouri 29071 14385 219
1844141 1844141 2021-10-23 Gasconade Missouri 29073 2178 50
1844142 1844142 2021-10-23 Gentry Missouri 29075 1283 26
1844143 1844143 2021-10-23 Greene Missouri 29077 44625 665
1844144 1844144 2021-10-23 Grundy Missouri 29079 1575 47
1844145 1844145 2021-10-23 Harrison Missouri 29081 1108 17
1844146 1844146 2021-10-23 Henry Missouri 29083 3280 49
1844147 1844147 2021-10-23 Hickory Missouri 29085 1087 21
1844148 1844148 2021-10-23 Holt Missouri 29087 615 16
1844149 1844149 2021-10-23 Howard Missouri 29089 1418 12
1844150 1844150 2021-10-23 Howell Missouri 29091 5702 74
1844151 1844151 2021-10-23 Iron Missouri 29093 1355 14
1844152 1844152 2021-10-23 Jackson Missouri 29095 55607 684
1844153 1844153 2021-10-23 Jasper Missouri 29097 13665 196
1844154 1844154 2021-10-23 Jefferson Missouri 29099 32128 326
1844155 1844155 2021-10-23 Johnson Missouri 29101 7162 73
1844156 1844156 2021-10-23 Joplin Missouri   8692 150
1844157 1844157 2021-10-23 Kansas City Missouri   63075 818
1844158 1844158 2021-10-23 Knox Missouri 29103 513 3
1844159 1844159 2021-10-23 Laclede Missouri 29105 5254 128
1844160 1844160 2021-10-23 Lafayette Missouri 29107 4626 73
1844161 1844161 2021-10-23 Lawrence Missouri 29109 5177 104
1844162 1844162 2021-10-23 Lewis Missouri 29111 1671 22
1844163 1844163 2021-10-23 Lincoln Missouri 29113 9228 68
1844164 1844164 2021-10-23 Linn Missouri 29115 1835 26
1844165 1844165 2021-10-23 Livingston Missouri 29117 2556 62
1844166 1844166 2021-10-23 Macon Missouri 29121 2183 20
1844167 1844167 2021-10-23 Madison Missouri 29123 2322 25
1844168 1844168 2021-10-23 Maries Missouri 29125 981 19
1844169 1844169 2021-10-23 Marion Missouri 29127 5149 63
1844170 1844170 2021-10-23 McDonald Missouri 29119 4000 58
1844171 1844171 2021-10-23 Mercer Missouri 29129 444 3
1844172 1844172 2021-10-23 Miller Missouri 29131 3997 77
1844173 1844173 2021-10-23 Mississippi Missouri 29133 2185 39
1844174 1844174 2021-10-23 Moniteau Missouri 29135 2581 38
1844175 1844175 2021-10-23 Monroe Missouri 29137 1319 13
1844176 1844176 2021-10-23 Montgomery Missouri 29139 1527 19
1844177 1844177 2021-10-23 Morgan Missouri 29141 2612 58
1844178 1844178 2021-10-23 New Madrid Missouri 29143 3299 55
1844179 1844179 2021-10-23 Newton Missouri 29145 7727 125
1844180 1844180 2021-10-23 Nodaway Missouri 29147 3329 34
1844181 1844181 2021-10-23 Oregon Missouri 29149 1331 11
1844182 1844182 2021-10-23 Osage Missouri 29151 2129 23
1844183 1844183 2021-10-23 Ozark Missouri 29153 1103 30
1844184 1844184 2021-10-23 Pemiscot Missouri 29155 2049 43
1844185 1844185 2021-10-23 Perry Missouri 29157 3105 33
1844186 1844186 2021-10-23 Pettis Missouri 29159 7294 103
1844187 1844187 2021-10-23 Phelps Missouri 29161 6178 182
1844188 1844188 2021-10-23 Pike Missouri 29163 2502 37
1844189 1844189 2021-10-23 Platte Missouri 29165 5931 61
1844190 1844190 2021-10-23 Polk Missouri 29167 5100 52
1844191 1844191 2021-10-23 Pulaski Missouri 29169 5192 79
1844192 1844192 2021-10-23 Putnam Missouri 29171 622 10
1844193 1844193 2021-10-23 Ralls Missouri 29173 1531 14
1844194 1844194 2021-10-23 Randolph Missouri 29175 3608 36
1844195 1844195 2021-10-23 Ray Missouri 29177 2930 50
1844196 1844196 2021-10-23 Reynolds Missouri 29179 779 7
1844197 1844197 2021-10-23 Ripley Missouri 29181 1917 24
1844198 1844198 2021-10-23 Saline Missouri 29195 4079 46
1844199 1844199 2021-10-23 Schuyler Missouri 29197 412 9
1844200 1844200 2021-10-23 Scotland Missouri 29199 394 4
1844201 1844201 2021-10-23 Scott Missouri 29201 7145 113
1844202 1844202 2021-10-23 Shannon Missouri 29203 983 17
1844203 1844203 2021-10-23 Shelby Missouri 29205 933 9
1844204 1844204 2021-10-23 St. Charles Missouri 29183 61422 679

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