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

89,600 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 >30

county >30

state 1

  • Missouri · 89,600 ✖
Link rowid date ▲ county state fips cases deaths
2501076 2501076 2022-05-13 Adair Missouri 29001 6095 63
2501077 2501077 2022-05-13 Andrew Missouri 29003 4828 58
2501078 2501078 2022-05-13 Atchison Missouri 29005 1387 23
2501079 2501079 2022-05-13 Audrain Missouri 29007 5717 110
2501080 2501080 2022-05-13 Barry Missouri 29009 6648 132
2501081 2501081 2022-05-13 Barton Missouri 29011 2859 52
2501082 2501082 2022-05-13 Bates Missouri 29013 3766 96
2501083 2501083 2022-05-13 Benton Missouri 29015 4248 107
2501084 2501084 2022-05-13 Bollinger Missouri 29017 2635 41
2501085 2501085 2022-05-13 Boone Missouri 29019 45035 252
2501086 2501086 2022-05-13 Buchanan Missouri 29021 24863 318
2501087 2501087 2022-05-13 Butler Missouri 29023 10206 169
2501088 2501088 2022-05-13 Caldwell Missouri 29025 1700 39
2501089 2501089 2022-05-13 Callaway Missouri 29027 12150 130
2501090 2501090 2022-05-13 Camden Missouri 29029 9331 180
2501091 2501091 2022-05-13 Cape Girardeau Missouri 29031 18923 246
2501092 2501092 2022-05-13 Carroll Missouri 29033 2233 44
2501093 2501093 2022-05-13 Carter Missouri 29035 1500 24
2501094 2501094 2022-05-13 Cass Missouri 29037 25249 315
2501095 2501095 2022-05-13 Cedar Missouri 29039 2936 57
2501096 2501096 2022-05-13 Chariton Missouri 29041 1718 38
2501097 2501097 2022-05-13 Christian Missouri 29043 20961 263
2501098 2501098 2022-05-13 Clark Missouri 29045 1597 37
2501099 2501099 2022-05-13 Clay Missouri 29047 27390 363
2501100 2501100 2022-05-13 Clinton Missouri 29049 4829 119
2501101 2501101 2022-05-13 Cole Missouri 29051 20202 286
2501102 2501102 2022-05-13 Cooper Missouri 29053 4138 77
2501103 2501103 2022-05-13 Crawford Missouri 29055 5422 104
2501104 2501104 2022-05-13 Dade Missouri 29057 1447 42
2501105 2501105 2022-05-13 Dallas Missouri 29059 3826 72
2501106 2501106 2022-05-13 Daviess Missouri 29061 1730 29
2501107 2501107 2022-05-13 DeKalb Missouri 29063 2222 47
2501108 2501108 2022-05-13 Dent Missouri 29065 3263 83
2501109 2501109 2022-05-13 Douglas Missouri 29067 2560 80
2501110 2501110 2022-05-13 Dunklin Missouri 29069 7824 117
2501111 2501111 2022-05-13 Franklin Missouri 29071 25852 373
2501112 2501112 2022-05-13 Gasconade Missouri 29073 3385 102
2501113 2501113 2022-05-13 Gentry Missouri 29075 2172 31
2501114 2501114 2022-05-13 Greene Missouri 29077 71775 1040
2501115 2501115 2022-05-13 Grundy Missouri 29079 2543 69
2501116 2501116 2022-05-13 Harrison Missouri 29081 1876 33
2501117 2501117 2022-05-13 Henry Missouri 29083 5758 86
2501118 2501118 2022-05-13 Hickory Missouri 29085 1838 56
2501119 2501119 2022-05-13 Holt Missouri 29087 1060 30
2501120 2501120 2022-05-13 Howard Missouri 29089 2515 30
2501121 2501121 2022-05-13 Howell Missouri 29091 9185 215
2501122 2501122 2022-05-13 Iron Missouri 29093 2200 44
2501123 2501123 2022-05-13 Jackson Missouri 29095 97164 1217
2501124 2501124 2022-05-13 Jasper Missouri 29097 20879 317
2501125 2501125 2022-05-13 Jefferson Missouri 29099 54493 653
2501126 2501126 2022-05-13 Johnson Missouri 29101 12251 143
2501127 2501127 2022-05-13 Joplin Missouri   13761 219
2501128 2501128 2022-05-13 Kansas City Missouri   114636 1310
2501129 2501129 2022-05-13 Knox Missouri 29103 990 14
2501130 2501130 2022-05-13 Laclede Missouri 29105 8096 176
2501131 2501131 2022-05-13 Lafayette Missouri 29107 7832 134
2501132 2501132 2022-05-13 Lawrence Missouri 29109 7798 164
2501133 2501133 2022-05-13 Lewis Missouri 29111 2796 36
2501134 2501134 2022-05-13 Lincoln Missouri 29113 15187 138
2501135 2501135 2022-05-13 Linn Missouri 29115 2560 65
2501136 2501136 2022-05-13 Livingston Missouri 29117 3748 97
2501137 2501137 2022-05-13 Macon Missouri 29121 3652 58
2501138 2501138 2022-05-13 Madison Missouri 29123 3622 57
2501139 2501139 2022-05-13 Maries Missouri 29125 1606 39
2501140 2501140 2022-05-13 Marion Missouri 29127 8051 118
2501141 2501141 2022-05-13 McDonald Missouri 29119 5813 73
2501142 2501142 2022-05-13 Mercer Missouri 29129 704 14
2501143 2501143 2022-05-13 Miller Missouri 29131 6123 123
2501144 2501144 2022-05-13 Mississippi Missouri 29133 3521 59
2501145 2501145 2022-05-13 Moniteau Missouri 29135 3838 57
2501146 2501146 2022-05-13 Monroe Missouri 29137 2180 43
2501147 2501147 2022-05-13 Montgomery Missouri 29139 2522 57
2501148 2501148 2022-05-13 Morgan Missouri 29141 4053 115
2501149 2501149 2022-05-13 New Madrid Missouri 29143 5036 86
2501150 2501150 2022-05-13 Newton Missouri 29145 11768 206
2501151 2501151 2022-05-13 Nodaway Missouri 29147 6089 44
2501152 2501152 2022-05-13 Oregon Missouri 29149 2024 33
2501153 2501153 2022-05-13 Osage Missouri 29151 3230 46
2501154 2501154 2022-05-13 Ozark Missouri 29153 1735 58
2501155 2501155 2022-05-13 Pemiscot Missouri 29155 3013 74
2501156 2501156 2022-05-13 Perry Missouri 29157 5059 46
2501157 2501157 2022-05-13 Pettis Missouri 29159 12392 168
2501158 2501158 2022-05-13 Phelps Missouri 29161 10317 243
2501159 2501159 2022-05-13 Pike Missouri 29163 4264 63
2501160 2501160 2022-05-13 Platte Missouri 29165 10580 102
2501161 2501161 2022-05-13 Polk Missouri 29167 8073 108
2501162 2501162 2022-05-13 Pulaski Missouri 29169 8918 116
2501163 2501163 2022-05-13 Putnam Missouri 29171 1013 24
2501164 2501164 2022-05-13 Ralls Missouri 29173 2470 28
2501165 2501165 2022-05-13 Randolph Missouri 29175 6058 103
2501166 2501166 2022-05-13 Ray Missouri 29177 5221 94
2501167 2501167 2022-05-13 Reynolds Missouri 29179 1165 26
2501168 2501168 2022-05-13 Ripley Missouri 29181 2697 61
2501169 2501169 2022-05-13 Saline Missouri 29195 6288 107
2501170 2501170 2022-05-13 Schuyler Missouri 29197 740 26
2501171 2501171 2022-05-13 Scotland Missouri 29199 680 18
2501172 2501172 2022-05-13 Scott Missouri 29201 11133 161
2501173 2501173 2022-05-13 Shannon Missouri 29203 1609 40
2501174 2501174 2022-05-13 Shelby Missouri 29205 1603 15
2501175 2501175 2022-05-13 St. Charles Missouri 29183 103932 938

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