johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
234 rows where "last_update" is on date 2022-03-22 and province_or_state = "Missouri" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1907173 | 1907173 | 2022-03-22 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-03-22 23:20:51 | Unassigned, Missouri, US | |
3240304 | 3240304 | 2022-03-21 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-03-22 04:20:54 | Unassigned, Missouri, US | |
1907179 | 1907179 | 2022-03-22 | US | Missouri | Worth | 29227 | 401 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-03-22 23:20:51 | Worth, Missouri, US | |
3240310 | 3240310 | 2022-03-21 | US | Missouri | Worth | 29227 | 401 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-03-22 04:20:54 | Worth, Missouri, US | |
1907116 | 1907116 | 2022-03-22 | US | Missouri | Knox | 29103 | 959 | 12 | 0 | 40.12699751 | -92.14780832 | 2022-03-22 23:20:51 | Knox, Missouri, US | |
3240247 | 3240247 | 2022-03-21 | US | Missouri | Knox | 29103 | 962 | 12 | 0 | 40.12699751 | -92.14780832 | 2022-03-22 04:20:54 | Knox, Missouri, US | |
1907129 | 1907129 | 2022-03-22 | US | Missouri | Mercer | 29129 | 694 | 13 | 0 | 40.42212303 | -93.56829590000001 | 2022-03-22 23:20:51 | Mercer, Missouri, US | |
3240260 | 3240260 | 2022-03-21 | US | Missouri | Mercer | 29129 | 694 | 13 | 0 | 40.42212303 | -93.56829590000001 | 2022-03-22 04:20:54 | Mercer, Missouri, US | |
1907161 | 1907161 | 2022-03-22 | US | Missouri | Shelby | 29205 | 1511 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-03-22 23:20:51 | Shelby, Missouri, US | |
3240292 | 3240292 | 2022-03-21 | US | Missouri | Shelby | 29205 | 1522 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-03-22 04:20:54 | Shelby, Missouri, US | |
1907158 | 1907158 | 2022-03-22 | US | Missouri | Scotland | 29199 | 682 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-03-22 23:20:51 | Scotland, Missouri, US | |
3240289 | 3240289 | 2022-03-21 | US | Missouri | Scotland | 29199 | 682 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-03-22 04:20:54 | Scotland, Missouri, US | |
1907066 | 1907066 | 2022-03-22 | US | Missouri | Atchison | 29005 | 1388 | 20 | 0 | 40.43238737 | -95.42970639 | 2022-03-22 23:20:51 | Atchison, Missouri, US | |
3240197 | 3240197 | 2022-03-21 | US | Missouri | Atchison | 29005 | 1389 | 20 | 0 | 40.43238737 | -95.42970639 | 2022-03-22 04:20:54 | Atchison, Missouri, US | |
1907170 | 1907170 | 2022-03-22 | US | Missouri | Sullivan | 29211 | 1705 | 21 | 0 | 40.2099105 | -93.11150106 | 2022-03-22 23:20:51 | Sullivan, Missouri, US | |
3240301 | 3240301 | 2022-03-21 | US | Missouri | Sullivan | 29211 | 1706 | 21 | 0 | 40.2099105 | -93.11150106 | 2022-03-22 04:20:54 | Sullivan, Missouri, US | |
1907150 | 1907150 | 2022-03-22 | US | Missouri | Putnam | 29171 | 991 | 22 | 0 | 40.47942497 | -93.02042674 | 2022-03-22 23:20:51 | Putnam, Missouri, US | |
3240281 | 3240281 | 2022-03-21 | US | Missouri | Putnam | 29171 | 991 | 22 | 0 | 40.47942497 | -93.02042674 | 2022-03-22 04:20:54 | Putnam, Missouri, US | |
1907081 | 1907081 | 2022-03-22 | US | Missouri | Carter | 29035 | 1493 | 23 | 0 | 36.94160441 | -90.96051322 | 2022-03-22 23:20:51 | Carter, Missouri, US | |
3240212 | 3240212 | 2022-03-21 | US | Missouri | Carter | 29035 | 1495 | 23 | 0 | 36.94160441 | -90.96051322 | 2022-03-22 04:20:54 | Carter, Missouri, US | |
1907108 | 1907108 | 2022-03-22 | US | Missouri | Howard | 29089 | 2160 | 25 | 0 | 39.1435761 | -92.69756691 | 2022-03-22 23:20:51 | Howard, Missouri, US | |
1907151 | 1907151 | 2022-03-22 | US | Missouri | Ralls | 29173 | 2451 | 25 | 0 | 39.52817427 | -91.51838643 | 2022-03-22 23:20:51 | Ralls, Missouri, US | |
1907154 | 1907154 | 2022-03-22 | US | Missouri | Reynolds | 29179 | 1154 | 25 | 0 | 37.36085952 | -90.97009925 | 2022-03-22 23:20:51 | Reynolds, Missouri, US | |
3240239 | 3240239 | 2022-03-21 | US | Missouri | Howard | 29089 | 2163 | 25 | 0 | 39.1435761 | -92.69756691 | 2022-03-22 04:20:54 | Howard, Missouri, US | |
3240282 | 3240282 | 2022-03-21 | US | Missouri | Ralls | 29173 | 2452 | 25 | 0 | 39.52817427 | -91.51838643 | 2022-03-22 04:20:54 | Ralls, Missouri, US | |
3240285 | 3240285 | 2022-03-21 | US | Missouri | Reynolds | 29179 | 1154 | 25 | 0 | 37.36085952 | -90.97009925 | 2022-03-22 04:20:54 | Reynolds, Missouri, US | |
1907094 | 1907094 | 2022-03-22 | US | Missouri | Daviess | 29061 | 1695 | 26 | 0 | 39.96145298 | -93.98519678 | 2022-03-22 23:20:51 | Daviess, Missouri, US | |
1907157 | 1907157 | 2022-03-22 | US | Missouri | Schuyler | 29197 | 725 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-03-22 23:20:51 | Schuyler, Missouri, US | |
3240225 | 3240225 | 2022-03-21 | US | Missouri | Daviess | 29061 | 1698 | 26 | 0 | 39.96145298 | -93.98519678 | 2022-03-22 04:20:54 | Daviess, Missouri, US | |
3240288 | 3240288 | 2022-03-21 | US | Missouri | Schuyler | 29197 | 725 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-03-22 04:20:54 | Schuyler, Missouri, US | |
1907107 | 1907107 | 2022-03-22 | US | Missouri | Holt | 29087 | 1053 | 29 | 0 | 40.09799248 | -95.21638879999999 | 2022-03-22 23:20:51 | Holt, Missouri, US | |
3240238 | 3240238 | 2022-03-21 | US | Missouri | Holt | 29087 | 1053 | 29 | 0 | 40.09799248 | -95.21638879999999 | 2022-03-22 04:20:54 | Holt, Missouri, US | |
1907101 | 1907101 | 2022-03-22 | US | Missouri | Gentry | 29075 | 2152 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-03-22 23:20:51 | Gentry, Missouri, US | |
3240232 | 3240232 | 2022-03-21 | US | Missouri | Gentry | 29075 | 2156 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-03-22 04:20:54 | Gentry, Missouri, US | |
1907086 | 1907086 | 2022-03-22 | US | Missouri | Clark | 29045 | 1581 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-22 23:20:51 | Clark, Missouri, US | |
1907104 | 1907104 | 2022-03-22 | US | Missouri | Harrison | 29081 | 1813 | 32 | 0 | 40.35570088 | -93.99222144 | 2022-03-22 23:20:51 | Harrison, Missouri, US | |
1907139 | 1907139 | 2022-03-22 | US | Missouri | Oregon | 29149 | 2017 | 32 | 0 | 36.68710164 | -91.4033755 | 2022-03-22 23:20:51 | Oregon, Missouri, US | |
3240217 | 3240217 | 2022-03-21 | US | Missouri | Clark | 29045 | 1582 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-22 04:20:54 | Clark, Missouri, US | |
3240235 | 3240235 | 2022-03-21 | US | Missouri | Harrison | 29081 | 1813 | 32 | 0 | 40.35570088 | -93.99222144 | 2022-03-22 04:20:54 | Harrison, Missouri, US | |
3240270 | 3240270 | 2022-03-21 | US | Missouri | Oregon | 29149 | 2019 | 32 | 0 | 36.68710164 | -91.4033755 | 2022-03-22 04:20:54 | Oregon, Missouri, US | |
1907163 | 1907163 | 2022-03-22 | US | Missouri | St. Clair | 29185 | 2096 | 33 | 0 | 38.03699437 | -93.77631447 | 2022-03-22 23:20:51 | St. Clair, Missouri, US | |
3240294 | 3240294 | 2022-03-21 | US | Missouri | St. Clair | 29185 | 2099 | 33 | 0 | 38.03699437 | -93.77631447 | 2022-03-22 04:20:54 | St. Clair, Missouri, US | |
1907120 | 1907120 | 2022-03-22 | US | Missouri | Lewis | 29111 | 2736 | 34 | 0 | 40.09673161 | -91.72070156 | 2022-03-22 23:20:51 | Lewis, Missouri, US | |
3240251 | 3240251 | 2022-03-21 | US | Missouri | Lewis | 29111 | 2743 | 34 | 0 | 40.09673161 | -91.72070156 | 2022-03-22 04:20:54 | Lewis, Missouri, US | |
1907126 | 1907126 | 2022-03-22 | US | Missouri | Maries | 29125 | 1596 | 35 | 0 | 38.16193985 | -91.92249662 | 2022-03-22 23:20:51 | Maries, Missouri, US | |
3240257 | 3240257 | 2022-03-21 | US | Missouri | Maries | 29125 | 1597 | 35 | 0 | 38.16193985 | -91.92249662 | 2022-03-22 04:20:54 | Maries, Missouri, US | |
1907076 | 1907076 | 2022-03-22 | US | Missouri | Caldwell | 29025 | 1680 | 36 | 0 | 39.65620858 | -93.98308093 | 2022-03-22 23:20:51 | Caldwell, Missouri, US | |
1907084 | 1907084 | 2022-03-22 | US | Missouri | Chariton | 29041 | 1694 | 36 | 0 | 39.51499357 | -92.9629191 | 2022-03-22 23:20:51 | Chariton, Missouri, US | |
3240207 | 3240207 | 2022-03-21 | US | Missouri | Caldwell | 29025 | 1682 | 36 | 0 | 39.65620858 | -93.98308093 | 2022-03-22 04:20:54 | Caldwell, Missouri, US | |
3240215 | 3240215 | 2022-03-21 | US | Missouri | Chariton | 29041 | 1695 | 36 | 0 | 39.51499357 | -92.9629191 | 2022-03-22 04:20:54 | Chariton, Missouri, US | |
1907072 | 1907072 | 2022-03-22 | US | Missouri | Bollinger | 29017 | 2565 | 37 | 0 | 37.32449052 | -90.02725304 | 2022-03-22 23:20:51 | Bollinger, Missouri, US | |
1907160 | 1907160 | 2022-03-22 | US | Missouri | Shannon | 29203 | 1599 | 37 | 0 | 37.15772072 | -91.40190382 | 2022-03-22 23:20:51 | Shannon, Missouri, US | |
3240203 | 3240203 | 2022-03-21 | US | Missouri | Bollinger | 29017 | 2566 | 37 | 0 | 37.32449052 | -90.02725304 | 2022-03-22 04:20:54 | Bollinger, Missouri, US | |
3240291 | 3240291 | 2022-03-21 | US | Missouri | Shannon | 29203 | 1601 | 37 | 0 | 37.15772072 | -91.40190382 | 2022-03-22 04:20:54 | Shannon, Missouri, US | |
1907167 | 1907167 | 2022-03-22 | US | Missouri | Ste. Genevieve | 29186 | 3646 | 39 | 0 | 37.89090059 | -90.1949941 | 2022-03-22 23:20:51 | Ste. Genevieve, Missouri, US | |
3240298 | 3240298 | 2022-03-21 | US | Missouri | Ste. Genevieve | 29186 | 3647 | 39 | 0 | 37.89090059 | -90.1949941 | 2022-03-22 04:20:54 | Ste. Genevieve, Missouri, US | |
1907092 | 1907092 | 2022-03-22 | US | Missouri | Dade | 29057 | 1425 | 41 | 0 | 37.431814 | -93.8503345 | 2022-03-22 23:20:51 | Dade, Missouri, US | |
3240223 | 3240223 | 2022-03-21 | US | Missouri | Dade | 29057 | 1426 | 41 | 0 | 37.431814 | -93.8503345 | 2022-03-22 04:20:54 | Dade, Missouri, US | |
1907110 | 1907110 | 2022-03-22 | US | Missouri | Iron | 29093 | 2182 | 42 | 0 | 37.55487945 | -90.7735296 | 2022-03-22 23:20:51 | Iron, Missouri, US | |
1907133 | 1907133 | 2022-03-22 | US | Missouri | Monroe | 29137 | 2165 | 42 | 0 | 39.49593978 | -92.00043978 | 2022-03-22 23:20:51 | Monroe, Missouri, US | |
3240241 | 3240241 | 2022-03-21 | US | Missouri | Iron | 29093 | 2187 | 42 | 0 | 37.55487945 | -90.7735296 | 2022-03-22 04:20:54 | Iron, Missouri, US | |
3240264 | 3240264 | 2022-03-21 | US | Missouri | Monroe | 29137 | 2165 | 42 | 0 | 39.49593978 | -92.00043978 | 2022-03-22 04:20:54 | Monroe, Missouri, US | |
1907138 | 1907138 | 2022-03-22 | US | Missouri | Nodaway | 29147 | 6010 | 43 | 0 | 40.36079813 | -94.88133008 | 2022-03-22 23:20:51 | Nodaway, Missouri, US | |
1907140 | 1907140 | 2022-03-22 | US | Missouri | Osage | 29151 | 3204 | 43 | 0 | 38.46036182 | -91.8613635 | 2022-03-22 23:20:51 | Osage, Missouri, US | |
3240271 | 3240271 | 2022-03-21 | US | Missouri | Osage | 29151 | 3206 | 43 | 0 | 38.46036182 | -91.8613635 | 2022-03-22 04:20:54 | Osage, Missouri, US | |
1907080 | 1907080 | 2022-03-22 | US | Missouri | Carroll | 29033 | 2221 | 44 | 0 | 39.42762566 | -93.50626255 | 2022-03-22 23:20:51 | Carroll, Missouri, US | |
1907143 | 1907143 | 2022-03-22 | US | Missouri | Perry | 29157 | 4925 | 44 | 0 | 37.70660776 | -89.82741088 | 2022-03-22 23:20:51 | Perry, Missouri, US | |
3240211 | 3240211 | 2022-03-21 | US | Missouri | Carroll | 29033 | 2223 | 44 | 0 | 39.42762566 | -93.50626255 | 2022-03-22 04:20:54 | Carroll, Missouri, US | |
3240269 | 3240269 | 2022-03-21 | US | Missouri | Nodaway | 29147 | 6017 | 44 | 0 | 40.36079813 | -94.88133008 | 2022-03-22 04:20:54 | Nodaway, Missouri, US | |
3240274 | 3240274 | 2022-03-21 | US | Missouri | Perry | 29157 | 4934 | 44 | 0 | 37.70660776 | -89.82741088 | 2022-03-22 04:20:54 | Perry, Missouri, US | |
1907095 | 1907095 | 2022-03-22 | US | Missouri | DeKalb | 29063 | 2175 | 45 | 0 | 39.89201062 | -94.40476508 | 2022-03-22 23:20:51 | DeKalb, Missouri, US | |
3240226 | 3240226 | 2022-03-21 | US | Missouri | DeKalb | 29063 | 2187 | 45 | 0 | 39.89201062 | -94.40476508 | 2022-03-22 04:20:54 | DeKalb, Missouri, US | |
1907069 | 1907069 | 2022-03-22 | US | Missouri | Barton | 29011 | 2812 | 51 | 0 | 37.50207671 | -94.34757022 | 2022-03-22 23:20:51 | Barton, Missouri, US | |
1907177 | 1907177 | 2022-03-22 | US | Missouri | Wayne | 29223 | 2369 | 51 | 0 | 37.11303869 | -90.46001416 | 2022-03-22 23:20:51 | Wayne, Missouri, US | |
3240200 | 3240200 | 2022-03-21 | US | Missouri | Barton | 29011 | 2824 | 51 | 0 | 37.50207671 | -94.34757022 | 2022-03-22 04:20:54 | Barton, Missouri, US | |
3240308 | 3240308 | 2022-03-21 | US | Missouri | Wayne | 29223 | 2371 | 51 | 0 | 37.11303869 | -90.46001416 | 2022-03-22 04:20:54 | Wayne, Missouri, US | |
1907083 | 1907083 | 2022-03-22 | US | Missouri | Cedar | 29039 | 2908 | 52 | 0 | 37.72391475 | -93.85445441 | 2022-03-22 23:20:51 | Cedar, Missouri, US | |
3240214 | 3240214 | 2022-03-21 | US | Missouri | Cedar | 29039 | 2912 | 52 | 0 | 37.72391475 | -93.85445441 | 2022-03-22 04:20:54 | Cedar, Missouri, US | |
1907124 | 1907124 | 2022-03-22 | US | Missouri | Macon | 29121 | 3624 | 53 | 0 | 39.83049768 | -92.56453089 | 2022-03-22 23:20:51 | Macon, Missouri, US | |
3240255 | 3240255 | 2022-03-21 | US | Missouri | Macon | 29121 | 3630 | 53 | 0 | 39.83049768 | -92.56453089 | 2022-03-22 04:20:54 | Macon, Missouri, US | |
1907106 | 1907106 | 2022-03-22 | US | Missouri | Hickory | 29085 | 1826 | 55 | 0 | 37.94163617 | -93.3203037 | 2022-03-22 23:20:51 | Hickory, Missouri, US | |
1907132 | 1907132 | 2022-03-22 | US | Missouri | Moniteau | 29135 | 3810 | 55 | 0 | 38.63571781 | -92.57976951 | 2022-03-22 23:20:51 | Moniteau, Missouri, US | |
1907141 | 1907141 | 2022-03-22 | US | Missouri | Ozark | 29153 | 1697 | 55 | 0 | 36.64916339 | -92.44459066 | 2022-03-22 23:20:51 | Ozark, Missouri, US | |
3240237 | 3240237 | 2022-03-21 | US | Missouri | Hickory | 29085 | 1825 | 55 | 0 | 37.94163617 | -93.3203037 | 2022-03-22 04:20:54 | Hickory, Missouri, US | |
3240263 | 3240263 | 2022-03-21 | US | Missouri | Moniteau | 29135 | 3810 | 55 | 0 | 38.63571781 | -92.57976951 | 2022-03-22 04:20:54 | Moniteau, Missouri, US | |
3240272 | 3240272 | 2022-03-21 | US | Missouri | Ozark | 29153 | 1701 | 55 | 0 | 36.64916339 | -92.44459066 | 2022-03-22 04:20:54 | Ozark, Missouri, US | |
1907065 | 1907065 | 2022-03-22 | US | Missouri | Andrew | 29003 | 4724 | 56 | 0 | 39.98492163 | -94.80163024 | 2022-03-22 23:20:51 | Andrew, Missouri, US | |
1907125 | 1907125 | 2022-03-22 | US | Missouri | Madison | 29123 | 3566 | 56 | 0 | 37.47865134 | -90.34671429999999 | 2022-03-22 23:20:51 | Madison, Missouri, US | |
1907131 | 1907131 | 2022-03-22 | US | Missouri | Mississippi | 29133 | 3363 | 56 | 0 | 36.82516239 | -89.29505753 | 2022-03-22 23:20:51 | Mississippi, Missouri, US | |
3240196 | 3240196 | 2022-03-21 | US | Missouri | Andrew | 29003 | 4735 | 56 | 0 | 39.98492163 | -94.80163024 | 2022-03-22 04:20:54 | Andrew, Missouri, US | |
3240256 | 3240256 | 2022-03-21 | US | Missouri | Madison | 29123 | 3569 | 56 | 0 | 37.47865134 | -90.34671429999999 | 2022-03-22 04:20:54 | Madison, Missouri, US | |
3240262 | 3240262 | 2022-03-21 | US | Missouri | Mississippi | 29133 | 3366 | 56 | 0 | 36.82516239 | -89.29505753 | 2022-03-22 04:20:54 | Mississippi, Missouri, US | |
3240265 | 3240265 | 2022-03-21 | US | Missouri | Montgomery | 29139 | 2548 | 56 | 0 | 38.94022054 | -91.47000721 | 2022-03-22 04:20:54 | Montgomery, Missouri, US | |
1907134 | 1907134 | 2022-03-22 | US | Missouri | Montgomery | 29139 | 2458 | 57 | 0 | 38.94022054 | -91.47000721 | 2022-03-22 23:20:51 | Montgomery, Missouri, US | |
1907064 | 1907064 | 2022-03-22 | US | Missouri | Adair | 29001 | 5485 | 61 | 0 | 40.19058551 | -92.60078167 | 2022-03-22 23:20:51 | Adair, Missouri, US | |
1907155 | 1907155 | 2022-03-22 | US | Missouri | Ripley | 29181 | 2678 | 61 | 0 | 36.65460667 | -90.85990261 | 2022-03-22 23:20:51 | Ripley, Missouri, US | |
3240195 | 3240195 | 2022-03-21 | US | Missouri | Adair | 29001 | 5490 | 61 | 0 | 40.19058551 | -92.60078167 | 2022-03-22 04:20:54 | Adair, Missouri, US | |
3240286 | 3240286 | 2022-03-21 | US | Missouri | Ripley | 29181 | 2679 | 61 | 0 | 36.65460667 | -90.85990261 | 2022-03-22 04:20:54 | Ripley, Missouri, US | |
1907122 | 1907122 | 2022-03-22 | US | Missouri | Linn | 29115 | 2540 | 63 | 0 | 39.87001769 | -93.10704106 | 2022-03-22 23:20:51 | Linn, Missouri, US | |
1907146 | 1907146 | 2022-03-22 | US | Missouri | Pike | 29163 | 4236 | 63 | 0 | 39.34310674 | -91.16980779 | 2022-03-22 23:20:51 | Pike, Missouri, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);