johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
234 rows where "last_update" is on date 2022-04-13 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1950490 | 1950490 | 2022-04-12 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-04-13 04:21:03 | Unassigned, Missouri, US | |
2444733 | 2444733 | 2022-04-13 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-04-13 23:21:06 | Unassigned, Missouri, US | |
1950496 | 1950496 | 2022-04-12 | US | Missouri | Worth | 29227 | 402 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-04-13 04:21:03 | Worth, Missouri, US | |
2444739 | 2444739 | 2022-04-13 | US | Missouri | Worth | 29227 | 402 | 3 | 0 | 40.47945588 | -94.42328751 | 2022-04-13 23:21:06 | Worth, Missouri, US | |
1950433 | 1950433 | 2022-04-12 | US | Missouri | Knox | 29103 | 978 | 13 | 0 | 40.12699751 | -92.14780832 | 2022-04-13 04:21:03 | Knox, Missouri, US | |
1950446 | 1950446 | 2022-04-12 | US | Missouri | Mercer | 29129 | 696 | 13 | 0 | 40.42212303 | -93.56829590000001 | 2022-04-13 04:21:03 | Mercer, Missouri, US | |
2444676 | 2444676 | 2022-04-13 | US | Missouri | Knox | 29103 | 978 | 13 | 0 | 40.12699751 | -92.14780832 | 2022-04-13 23:21:06 | Knox, Missouri, US | |
2444689 | 2444689 | 2022-04-13 | US | Missouri | Mercer | 29129 | 696 | 13 | 0 | 40.42212303 | -93.56829590000001 | 2022-04-13 23:21:06 | Mercer, Missouri, US | |
1950478 | 1950478 | 2022-04-12 | US | Missouri | Shelby | 29205 | 1568 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-04-13 04:21:03 | Shelby, Missouri, US | |
2444721 | 2444721 | 2022-04-13 | US | Missouri | Shelby | 29205 | 1568 | 15 | 0 | 39.79742518 | -92.07634971 | 2022-04-13 23:21:06 | Shelby, Missouri, US | |
1950475 | 1950475 | 2022-04-12 | US | Missouri | Scotland | 29199 | 677 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-04-13 04:21:03 | Scotland, Missouri, US | |
2444718 | 2444718 | 2022-04-13 | US | Missouri | Scotland | 29199 | 677 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-04-13 23:21:06 | Scotland, Missouri, US | |
1950383 | 1950383 | 2022-04-12 | US | Missouri | Atchison | 29005 | 1379 | 21 | 0 | 40.43238737 | -95.42970639 | 2022-04-13 04:21:03 | Atchison, Missouri, US | |
1950487 | 1950487 | 2022-04-12 | US | Missouri | Sullivan | 29211 | 1706 | 21 | 0 | 40.2099105 | -93.11150106 | 2022-04-13 04:21:03 | Sullivan, Missouri, US | |
2444626 | 2444626 | 2022-04-13 | US | Missouri | Atchison | 29005 | 1379 | 21 | 0 | 40.43238737 | -95.42970639 | 2022-04-13 23:21:06 | Atchison, Missouri, US | |
2444730 | 2444730 | 2022-04-13 | US | Missouri | Sullivan | 29211 | 1706 | 21 | 0 | 40.2099105 | -93.11150106 | 2022-04-13 23:21:06 | Sullivan, Missouri, US | |
1950467 | 1950467 | 2022-04-12 | US | Missouri | Putnam | 29171 | 994 | 23 | 0 | 40.47942497 | -93.02042674 | 2022-04-13 04:21:03 | Putnam, Missouri, US | |
2444710 | 2444710 | 2022-04-13 | US | Missouri | Putnam | 29171 | 994 | 23 | 0 | 40.47942497 | -93.02042674 | 2022-04-13 23:21:06 | Putnam, Missouri, US | |
1950398 | 1950398 | 2022-04-12 | US | Missouri | Carter | 29035 | 1491 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-04-13 04:21:03 | Carter, Missouri, US | |
2444641 | 2444641 | 2022-04-13 | US | Missouri | Carter | 29035 | 1491 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-04-13 23:21:06 | Carter, Missouri, US | |
1950471 | 1950471 | 2022-04-12 | US | Missouri | Reynolds | 29179 | 1158 | 25 | 0 | 37.36085952 | -90.97009925 | 2022-04-13 04:21:03 | Reynolds, Missouri, US | |
2444714 | 2444714 | 2022-04-13 | US | Missouri | Reynolds | 29179 | 1158 | 25 | 0 | 37.36085952 | -90.97009925 | 2022-04-13 23:21:06 | Reynolds, Missouri, US | |
1950474 | 1950474 | 2022-04-12 | US | Missouri | Schuyler | 29197 | 736 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-04-13 04:21:03 | Schuyler, Missouri, US | |
2444717 | 2444717 | 2022-04-13 | US | Missouri | Schuyler | 29197 | 736 | 26 | 0 | 40.46921489 | -92.52311943 | 2022-04-13 23:21:06 | Schuyler, Missouri, US | |
1950468 | 1950468 | 2022-04-12 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-13 04:21:03 | Ralls, Missouri, US | |
2444711 | 2444711 | 2022-04-13 | US | Missouri | Ralls | 29173 | 2451 | 27 | 0 | 39.52817427 | -91.51838643 | 2022-04-13 23:21:06 | Ralls, Missouri, US | |
1950411 | 1950411 | 2022-04-12 | US | Missouri | Daviess | 29061 | 1709 | 28 | 0 | 39.96145298 | -93.98519678 | 2022-04-13 04:21:03 | Daviess, Missouri, US | |
2444654 | 2444654 | 2022-04-13 | US | Missouri | Daviess | 29061 | 1709 | 28 | 0 | 39.96145298 | -93.98519678 | 2022-04-13 23:21:06 | Daviess, Missouri, US | |
1950425 | 1950425 | 2022-04-12 | US | Missouri | Howard | 29089 | 2481 | 29 | 0 | 39.1435761 | -92.69756691 | 2022-04-13 04:21:03 | Howard, Missouri, US | |
2444668 | 2444668 | 2022-04-13 | US | Missouri | Howard | 29089 | 2481 | 29 | 0 | 39.1435761 | -92.69756691 | 2022-04-13 23:21:06 | Howard, Missouri, US | |
1950424 | 1950424 | 2022-04-12 | US | Missouri | Holt | 29087 | 1052 | 30 | 0 | 40.09799248 | -95.21638879999999 | 2022-04-13 04:21:03 | Holt, Missouri, US | |
2444667 | 2444667 | 2022-04-13 | US | Missouri | Holt | 29087 | 1052 | 30 | 0 | 40.09799248 | -95.21638879999999 | 2022-04-13 23:21:06 | Holt, Missouri, US | |
1950418 | 1950418 | 2022-04-12 | US | Missouri | Gentry | 29075 | 2156 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-04-13 04:21:03 | Gentry, Missouri, US | |
2444661 | 2444661 | 2022-04-13 | US | Missouri | Gentry | 29075 | 2156 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-04-13 23:21:06 | Gentry, Missouri, US | |
1950403 | 1950403 | 2022-04-12 | US | Missouri | Clark | 29045 | 1580 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-04-13 04:21:03 | Clark, Missouri, US | |
2444646 | 2444646 | 2022-04-13 | US | Missouri | Clark | 29045 | 1580 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-04-13 23:21:06 | Clark, Missouri, US | |
1950421 | 1950421 | 2022-04-12 | US | Missouri | Harrison | 29081 | 1824 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-04-13 04:21:03 | Harrison, Missouri, US | |
1950456 | 1950456 | 2022-04-12 | US | Missouri | Oregon | 29149 | 2019 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-04-13 04:21:03 | Oregon, Missouri, US | |
2444664 | 2444664 | 2022-04-13 | US | Missouri | Harrison | 29081 | 1824 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-04-13 23:21:06 | Harrison, Missouri, US | |
2444699 | 2444699 | 2022-04-13 | US | Missouri | Oregon | 29149 | 2019 | 33 | 0 | 36.68710164 | -91.4033755 | 2022-04-13 23:21:06 | Oregon, Missouri, US | |
1950437 | 1950437 | 2022-04-12 | US | Missouri | Lewis | 29111 | 2753 | 35 | 0 | 40.09673161 | -91.72070156 | 2022-04-13 04:21:03 | Lewis, Missouri, US | |
1950480 | 1950480 | 2022-04-12 | US | Missouri | St. Clair | 29185 | 2097 | 35 | 0 | 38.03699437 | -93.77631447 | 2022-04-13 04:21:03 | St. Clair, Missouri, US | |
2444680 | 2444680 | 2022-04-13 | US | Missouri | Lewis | 29111 | 2753 | 35 | 0 | 40.09673161 | -91.72070156 | 2022-04-13 23:21:06 | Lewis, Missouri, US | |
2444723 | 2444723 | 2022-04-13 | US | Missouri | St. Clair | 29185 | 2097 | 35 | 0 | 38.03699437 | -93.77631447 | 2022-04-13 23:21:06 | St. Clair, Missouri, US | |
1950401 | 1950401 | 2022-04-12 | US | Missouri | Chariton | 29041 | 1697 | 37 | 0 | 39.51499357 | -92.9629191 | 2022-04-13 04:21:03 | Chariton, Missouri, US | |
2444644 | 2444644 | 2022-04-13 | US | Missouri | Chariton | 29041 | 1697 | 37 | 0 | 39.51499357 | -92.9629191 | 2022-04-13 23:21:06 | Chariton, Missouri, US | |
1950393 | 1950393 | 2022-04-12 | US | Missouri | Caldwell | 29025 | 1685 | 38 | 0 | 39.65620858 | -93.98308093 | 2022-04-13 04:21:03 | Caldwell, Missouri, US | |
2444636 | 2444636 | 2022-04-13 | US | Missouri | Caldwell | 29025 | 1685 | 38 | 0 | 39.65620858 | -93.98308093 | 2022-04-13 23:21:06 | Caldwell, Missouri, US | |
1950389 | 1950389 | 2022-04-12 | US | Missouri | Bollinger | 29017 | 2584 | 39 | 0 | 37.32449052 | -90.02725304 | 2022-04-13 04:21:03 | Bollinger, Missouri, US | |
1950443 | 1950443 | 2022-04-12 | US | Missouri | Maries | 29125 | 1601 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-04-13 04:21:03 | Maries, Missouri, US | |
1950477 | 1950477 | 2022-04-12 | US | Missouri | Shannon | 29203 | 1608 | 39 | 0 | 37.15772072 | -91.40190382 | 2022-04-13 04:21:03 | Shannon, Missouri, US | |
1950484 | 1950484 | 2022-04-12 | US | Missouri | Ste. Genevieve | 29186 | 3652 | 39 | 0 | 37.89090059 | -90.1949941 | 2022-04-13 04:21:03 | Ste. Genevieve, Missouri, US | |
2444632 | 2444632 | 2022-04-13 | US | Missouri | Bollinger | 29017 | 2584 | 39 | 0 | 37.32449052 | -90.02725304 | 2022-04-13 23:21:06 | Bollinger, Missouri, US | |
2444686 | 2444686 | 2022-04-13 | US | Missouri | Maries | 29125 | 1601 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-04-13 23:21:06 | Maries, Missouri, US | |
2444720 | 2444720 | 2022-04-13 | US | Missouri | Shannon | 29203 | 1608 | 39 | 0 | 37.15772072 | -91.40190382 | 2022-04-13 23:21:06 | Shannon, Missouri, US | |
2444727 | 2444727 | 2022-04-13 | US | Missouri | Ste. Genevieve | 29186 | 3652 | 39 | 0 | 37.89090059 | -90.1949941 | 2022-04-13 23:21:06 | Ste. Genevieve, Missouri, US | |
1950409 | 1950409 | 2022-04-12 | US | Missouri | Dade | 29057 | 1434 | 41 | 0 | 37.431814 | -93.8503345 | 2022-04-13 04:21:03 | Dade, Missouri, US | |
2444652 | 2444652 | 2022-04-13 | US | Missouri | Dade | 29057 | 1434 | 41 | 0 | 37.431814 | -93.8503345 | 2022-04-13 23:21:06 | Dade, Missouri, US | |
1950450 | 1950450 | 2022-04-12 | US | Missouri | Monroe | 29137 | 2171 | 42 | 0 | 39.49593978 | -92.00043978 | 2022-04-13 04:21:03 | Monroe, Missouri, US | |
2444693 | 2444693 | 2022-04-13 | US | Missouri | Monroe | 29137 | 2171 | 42 | 0 | 39.49593978 | -92.00043978 | 2022-04-13 23:21:06 | Monroe, Missouri, US | |
1950427 | 1950427 | 2022-04-12 | US | Missouri | Iron | 29093 | 2189 | 43 | 0 | 37.55487945 | -90.7735296 | 2022-04-13 04:21:03 | Iron, Missouri, US | |
2444670 | 2444670 | 2022-04-13 | US | Missouri | Iron | 29093 | 2189 | 43 | 0 | 37.55487945 | -90.7735296 | 2022-04-13 23:21:06 | Iron, Missouri, US | |
1950397 | 1950397 | 2022-04-12 | US | Missouri | Carroll | 29033 | 2219 | 44 | 0 | 39.42762566 | -93.50626255 | 2022-04-13 04:21:03 | Carroll, Missouri, US | |
1950455 | 1950455 | 2022-04-12 | US | Missouri | Nodaway | 29147 | 6026 | 44 | 0 | 40.36079813 | -94.88133008 | 2022-04-13 04:21:03 | Nodaway, Missouri, US | |
2444640 | 2444640 | 2022-04-13 | US | Missouri | Carroll | 29033 | 2219 | 44 | 0 | 39.42762566 | -93.50626255 | 2022-04-13 23:21:06 | Carroll, Missouri, US | |
2444698 | 2444698 | 2022-04-13 | US | Missouri | Nodaway | 29147 | 6026 | 44 | 0 | 40.36079813 | -94.88133008 | 2022-04-13 23:21:06 | Nodaway, Missouri, US | |
1950457 | 1950457 | 2022-04-12 | US | Missouri | Osage | 29151 | 3214 | 45 | 0 | 38.46036182 | -91.8613635 | 2022-04-13 04:21:03 | Osage, Missouri, US | |
1950460 | 1950460 | 2022-04-12 | US | Missouri | Perry | 29157 | 5014 | 45 | 0 | 37.70660776 | -89.82741088 | 2022-04-13 04:21:03 | Perry, Missouri, US | |
2444700 | 2444700 | 2022-04-13 | US | Missouri | Osage | 29151 | 3214 | 45 | 0 | 38.46036182 | -91.8613635 | 2022-04-13 23:21:06 | Osage, Missouri, US | |
2444703 | 2444703 | 2022-04-13 | US | Missouri | Perry | 29157 | 5014 | 45 | 0 | 37.70660776 | -89.82741088 | 2022-04-13 23:21:06 | Perry, Missouri, US | |
1950412 | 1950412 | 2022-04-12 | US | Missouri | DeKalb | 29063 | 2206 | 46 | 0 | 39.89201062 | -94.40476508 | 2022-04-13 04:21:03 | DeKalb, Missouri, US | |
2444655 | 2444655 | 2022-04-13 | US | Missouri | DeKalb | 29063 | 2206 | 46 | 0 | 39.89201062 | -94.40476508 | 2022-04-13 23:21:06 | DeKalb, Missouri, US | |
1950386 | 1950386 | 2022-04-12 | US | Missouri | Barton | 29011 | 2837 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-04-13 04:21:03 | Barton, Missouri, US | |
1950494 | 1950494 | 2022-04-12 | US | Missouri | Wayne | 29223 | 2397 | 52 | 0 | 37.11303869 | -90.46001416 | 2022-04-13 04:21:03 | Wayne, Missouri, US | |
2444629 | 2444629 | 2022-04-13 | US | Missouri | Barton | 29011 | 2837 | 52 | 0 | 37.50207671 | -94.34757022 | 2022-04-13 23:21:06 | Barton, Missouri, US | |
2444737 | 2444737 | 2022-04-13 | US | Missouri | Wayne | 29223 | 2397 | 52 | 0 | 37.11303869 | -90.46001416 | 2022-04-13 23:21:06 | Wayne, Missouri, US | |
1950400 | 1950400 | 2022-04-12 | US | Missouri | Cedar | 29039 | 2914 | 55 | 0 | 37.72391475 | -93.85445441 | 2022-04-13 04:21:03 | Cedar, Missouri, US | |
2444643 | 2444643 | 2022-04-13 | US | Missouri | Cedar | 29039 | 2914 | 55 | 0 | 37.72391475 | -93.85445441 | 2022-04-13 23:21:06 | Cedar, Missouri, US | |
1950423 | 1950423 | 2022-04-12 | US | Missouri | Hickory | 29085 | 1825 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-04-13 04:21:03 | Hickory, Missouri, US | |
1950441 | 1950441 | 2022-04-12 | US | Missouri | Macon | 29121 | 3633 | 56 | 0 | 39.83049768 | -92.56453089 | 2022-04-13 04:21:03 | Macon, Missouri, US | |
1950449 | 1950449 | 2022-04-12 | US | Missouri | Moniteau | 29135 | 3816 | 56 | 0 | 38.63571781 | -92.57976951 | 2022-04-13 04:21:03 | Moniteau, Missouri, US | |
1950458 | 1950458 | 2022-04-12 | US | Missouri | Ozark | 29153 | 1713 | 56 | 0 | 36.64916339 | -92.44459066 | 2022-04-13 04:21:03 | Ozark, Missouri, US | |
2444666 | 2444666 | 2022-04-13 | US | Missouri | Hickory | 29085 | 1825 | 56 | 0 | 37.94163617 | -93.3203037 | 2022-04-13 23:21:06 | Hickory, Missouri, US | |
2444684 | 2444684 | 2022-04-13 | US | Missouri | Macon | 29121 | 3633 | 56 | 0 | 39.83049768 | -92.56453089 | 2022-04-13 23:21:06 | Macon, Missouri, US | |
2444692 | 2444692 | 2022-04-13 | US | Missouri | Moniteau | 29135 | 3816 | 56 | 0 | 38.63571781 | -92.57976951 | 2022-04-13 23:21:06 | Moniteau, Missouri, US | |
2444701 | 2444701 | 2022-04-13 | US | Missouri | Ozark | 29153 | 1713 | 56 | 0 | 36.64916339 | -92.44459066 | 2022-04-13 23:21:06 | Ozark, Missouri, US | |
1950382 | 1950382 | 2022-04-12 | US | Missouri | Andrew | 29003 | 4738 | 57 | 0 | 39.98492163 | -94.80163024 | 2022-04-13 04:21:03 | Andrew, Missouri, US | |
1950442 | 1950442 | 2022-04-12 | US | Missouri | Madison | 29123 | 3599 | 57 | 0 | 37.47865134 | -90.34671429999999 | 2022-04-13 04:21:03 | Madison, Missouri, US | |
1950451 | 1950451 | 2022-04-12 | US | Missouri | Montgomery | 29139 | 2500 | 57 | 0 | 38.94022054 | -91.47000721 | 2022-04-13 04:21:03 | Montgomery, Missouri, US | |
2444625 | 2444625 | 2022-04-13 | US | Missouri | Andrew | 29003 | 4738 | 57 | 0 | 39.98492163 | -94.80163024 | 2022-04-13 23:21:06 | Andrew, Missouri, US | |
2444685 | 2444685 | 2022-04-13 | US | Missouri | Madison | 29123 | 3599 | 57 | 0 | 37.47865134 | -90.34671429999999 | 2022-04-13 23:21:06 | Madison, Missouri, US | |
2444694 | 2444694 | 2022-04-13 | US | Missouri | Montgomery | 29139 | 2500 | 57 | 0 | 38.94022054 | -91.47000721 | 2022-04-13 23:21:06 | Montgomery, Missouri, US | |
1950448 | 1950448 | 2022-04-12 | US | Missouri | Mississippi | 29133 | 3468 | 58 | 0 | 36.82516239 | -89.29505753 | 2022-04-13 04:21:03 | Mississippi, Missouri, US | |
2444691 | 2444691 | 2022-04-13 | US | Missouri | Mississippi | 29133 | 3468 | 58 | 0 | 36.82516239 | -89.29505753 | 2022-04-13 23:21:06 | Mississippi, Missouri, US | |
1950472 | 1950472 | 2022-04-12 | US | Missouri | Ripley | 29181 | 2689 | 61 | 0 | 36.65460667 | -90.85990261 | 2022-04-13 04:21:03 | Ripley, Missouri, US | |
2444715 | 2444715 | 2022-04-13 | US | Missouri | Ripley | 29181 | 2689 | 61 | 0 | 36.65460667 | -90.85990261 | 2022-04-13 23:21:06 | Ripley, Missouri, US | |
1950381 | 1950381 | 2022-04-12 | US | Missouri | Adair | 29001 | 5477 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-04-13 04:21:03 | Adair, Missouri, US | |
1950463 | 1950463 | 2022-04-12 | US | Missouri | Pike | 29163 | 4236 | 63 | 0 | 39.34310674 | -91.16980779 | 2022-04-13 04:21:03 | Pike, Missouri, US | |
2444624 | 2444624 | 2022-04-13 | US | Missouri | Adair | 29001 | 5477 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-04-13 23:21:06 | Adair, Missouri, US | |
2444706 | 2444706 | 2022-04-13 | US | Missouri | Pike | 29163 | 4236 | 63 | 0 | 39.34310674 | -91.16980779 | 2022-04-13 23:21:06 | 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]);