johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
117,101 rows where province_or_state = "Missouri" sorted by confirmed
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
517709 | 517709 | 2022-10-15 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-10-16 04:22:39 | Unassigned, Missouri, US | |
521870 | 521870 | 2020-04-21 | US | Missouri | Texas | 29215 | 0 | 0 | 0 | 0 | 37.31728859 | -91.96564727 | 2020-04-21 23:30:50 | Texas, Missouri, US |
521951 | 521951 | 2020-04-21 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2020-04-21 23:30:50 | Unassigned, Missouri, US |
524826 | 524826 | 2021-06-09 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-06-10 04:23:17 | Unassigned, Missouri, US | |
527788 | 527788 | 2020-07-04 | US | Missouri | Hickory | 29085 | 0 | 0 | 0 | 0 | 37.94163617 | -93.3203037 | 2020-07-05 04:33:46 | Hickory, Missouri, US |
536711 | 536711 | 2021-10-27 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-10-28 04:22:08 | Unassigned, Missouri, US | |
540733 | 540733 | 2022-10-26 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-10-27 04:22:01 | Unassigned, Missouri, US | |
544749 | 544749 | 2022-12-15 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-12-16 04:21:01 | Unassigned, Missouri, US | |
552750 | 552750 | 2021-12-08 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-12-09 04:22:49 | Unassigned, Missouri, US | |
556766 | 556766 | 2022-01-16 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-01-17 04:21:08 | Unassigned, Missouri, US | |
560784 | 560784 | 2022-06-16 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-06-17 04:20:56 | Unassigned, Missouri, US | |
564938 | 564938 | 2021-06-22 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-06-23 04:21:46 | Unassigned, Missouri, US | |
569079 | 569079 | 2021-10-29 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-10-30 04:22:03 | Unassigned, Missouri, US | |
576809 | 576809 | 2022-02-25 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-02-26 04:21:12 | Unassigned, Missouri, US | |
580804 | 580804 | 2021-07-13 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-07-14 04:21:35 | Unassigned, Missouri, US | |
588977 | 588977 | 2020-04-05 | US | Missouri | Worth | 29227 | 0 | 0 | 0 | 0 | 40.47945588 | -94.42328751 | 2020-04-05 23:06:45 | Worth, Missouri, US |
591600 | 591600 | 2021-08-08 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-08-09 04:21:24 | Unassigned, Missouri, US | |
595636 | 595636 | 2022-07-01 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-07-02 04:21:16 | Unassigned, Missouri, US | |
599649 | 599649 | 2021-10-19 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-10-20 04:21:00 | Unassigned, Missouri, US | |
603664 | 603664 | 2021-09-23 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-09-24 04:21:44 | Unassigned, Missouri, US | |
607657 | 607657 | 2021-04-09 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-04-10 04:20:59 | Unassigned, Missouri, US | |
619843 | 619843 | 2022-11-05 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-11-06 04:21:24 | Unassigned, Missouri, US | |
623856 | 623856 | 2022-05-22 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-05-26 04:20:50 | Unassigned, Missouri, US | |
627850 | 627850 | 2021-07-10 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-07-11 04:21:43 | Unassigned, Missouri, US | |
631886 | 631886 | 2022-07-12 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-07-13 04:20:58 | Unassigned, Missouri, US | |
635899 | 635899 | 2021-10-13 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-10-14 04:21:29 | Unassigned, Missouri, US | |
639890 | 639890 | 2021-03-31 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-04-01 04:27:05 | Unassigned, Missouri, US | |
643910 | 643910 | 2021-09-07 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-09-08 04:21:31 | Unassigned, Missouri, US | |
647920 | 647920 | 2021-05-05 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-05-06 04:20:38 | Unassigned, Missouri, US | |
651938 | 651938 | 2021-08-09 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-08-10 04:21:27 | Unassigned, Missouri, US | |
655971 | 655971 | 2021-10-22 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-10-23 04:21:32 | Unassigned, Missouri, US | |
660291 | 660291 | 2022-05-13 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-05-14 04:20:48 | Unassigned, Missouri, US | |
672277 | 672277 | 2022-07-21 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-07-22 04:21:15 | Unassigned, Missouri, US | |
676293 | 676293 | 2022-07-30 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-07-31 04:21:02 | Unassigned, Missouri, US | |
684316 | 684316 | 2021-10-24 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-10-25 04:22:31 | Unassigned, Missouri, US | |
688333 | 688333 | 2021-11-13 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-11-14 04:21:31 | Unassigned, Missouri, US | |
692354 | 692354 | 2022-12-23 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-12-24 04:21:02 | Unassigned, Missouri, US | |
696366 | 696366 | 2022-03-17 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-03-18 04:20:55 | Unassigned, Missouri, US | |
700381 | 700381 | 2021-11-04 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-11-05 04:21:54 | Unassigned, Missouri, US | |
704371 | 704371 | 2021-03-16 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-03-17 05:25:07 | Unassigned, Missouri, US | |
708409 | 708409 | 2021-09-29 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-09-30 04:21:20 | Unassigned, Missouri, US | |
712431 | 712431 | 2022-11-01 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-11-02 04:22:09 | Unassigned, Missouri, US | |
716442 | 716442 | 2021-11-12 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-11-13 04:21:38 | Unassigned, Missouri, US | |
720463 | 720463 | 2022-12-04 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-12-05 04:20:58 | Unassigned, Missouri, US | |
724474 | 724474 | 2021-11-20 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-11-21 04:22:13 | Unassigned, Missouri, US | |
728466 | 728466 | 2021-05-22 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-05-23 04:20:51 | Unassigned, Missouri, US | |
732504 | 732504 | 2021-12-27 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-12-28 04:21:47 | Unassigned, Missouri, US | |
734892 | 734892 | 2020-06-12 | US | Missouri | Dade | 29057 | 0 | 0 | 0 | 0 | 37.431814 | -93.8503345 | 2020-06-13 03:33:14 | Dade, Missouri, US |
735421 | 735421 | 2020-06-12 | US | Missouri | Hickory | 29085 | 0 | 0 | 0 | 0 | 37.94163617 | -93.3203037 | 2020-06-13 03:33:14 | Hickory, Missouri, US |
736312 | 736312 | 2020-06-12 | US | Missouri | Ozark | 29153 | 0 | 0 | 0 | 0 | 36.64916339 | -92.44459066 | 2020-06-13 03:33:14 | Ozark, Missouri, US |
737136 | 737136 | 2020-06-12 | US | Missouri | Wayne | 29223 | 0 | 0 | 0 | 0 | 37.11303869 | -90.46001416 | 2020-06-13 03:33:14 | Wayne, Missouri, US |
748321 | 748321 | 2022-04-23 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-04-24 04:20:56 | Unassigned, Missouri, US | |
760304 | 760304 | 2021-11-26 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-11-27 04:22:45 | Unassigned, Missouri, US | |
772324 | 772324 | 2021-10-23 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-10-24 04:21:22 | Unassigned, Missouri, US | |
780333 | 780333 | 2021-07-08 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-07-09 04:21:21 | Unassigned, Missouri, US | |
784367 | 784367 | 2021-12-13 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-12-14 04:22:38 | Unassigned, Missouri, US | |
796395 | 796395 | 2022-10-24 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-10-25 04:21:53 | Unassigned, Missouri, US | |
800406 | 800406 | 2021-12-22 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-12-23 04:21:21 | Unassigned, Missouri, US | |
805859 | 805859 | 2020-03-27 | US | Missouri | Andrew | 29003 | 0 | 0 | 0 | 0 | 39.98492163 | -94.80163024 | 2020-03-27 22:14:55 | Andrew, Missouri, US |
805899 | 805899 | 2020-03-27 | US | Missouri | Audrain | 29007 | 0 | 0 | 0 | 0 | 39.215877 | -91.84242683 | 2020-03-27 22:14:55 | Audrain, Missouri, US |
805935 | 805935 | 2020-03-27 | US | Missouri | Barry | 29009 | 0 | 0 | 0 | 0 | 36.70978521 | -93.82919888 | 2020-03-27 22:14:55 | Barry, Missouri, US |
805938 | 805938 | 2020-03-27 | US | Missouri | Barton | 29011 | 0 | 0 | 0 | 0 | 37.50207671 | -94.34757022 | 2020-03-27 22:14:55 | Barton, Missouri, US |
806121 | 806121 | 2020-03-27 | US | Missouri | Butler | 29023 | 0 | 0 | 0 | 0 | 36.71462476 | -90.40421163 | 2020-03-27 22:14:55 | Butler, Missouri, US |
806138 | 806138 | 2020-03-27 | US | Missouri | Caldwell | 29025 | 0 | 0 | 0 | 0 | 39.65620858 | -93.98308093 | 2020-03-27 22:14:55 | Caldwell, Missouri, US |
806196 | 806196 | 2020-03-27 | US | Missouri | Carroll | 29033 | 0 | 0 | 0 | 0 | 39.42762566 | -93.50626255 | 2020-03-27 22:14:55 | Carroll, Missouri, US |
806233 | 806233 | 2020-03-27 | US | Missouri | Cedar | 29039 | 0 | 0 | 0 | 0 | 37.72391475 | -93.85445441 | 2020-03-27 22:14:55 | Cedar, Missouri, US |
806321 | 806321 | 2020-03-27 | US | Missouri | Clark | 29045 | 0 | 0 | 0 | 0 | 40.41040752 | -91.73661677 | 2020-03-27 22:14:55 | Clark, Missouri, US |
806457 | 806457 | 2020-03-27 | US | Missouri | Crawford | 29055 | 0 | 0 | 0 | 0 | 37.97663738 | -91.30528104 | 2020-03-27 22:14:55 | Crawford, Missouri, US |
806497 | 806497 | 2020-03-27 | US | Missouri | Dade | 29057 | 0 | 0 | 0 | 0 | 37.431814 | -93.8503345 | 2020-03-27 22:14:55 | Dade, Missouri, US |
806506 | 806506 | 2020-03-27 | US | Missouri | Dallas | 29059 | 0 | 0 | 0 | 0 | 37.681135499999996 | -93.02127031 | 2020-03-27 22:14:55 | Dallas, Missouri, US |
806520 | 806520 | 2020-03-27 | US | Missouri | Daviess | 29061 | 0 | 0 | 0 | 0 | 39.96145298 | -93.98519678 | 2020-03-27 22:14:55 | Daviess, Missouri, US |
806537 | 806537 | 2020-03-27 | US | Missouri | DeKalb | 29063 | 0 | 0 | 0 | 0 | 39.89201062 | -94.40476508 | 2020-03-27 22:14:55 | DeKalb, Missouri, US |
806562 | 806562 | 2020-03-27 | US | Missouri | Dent | 29065 | 0 | 0 | 0 | 0 | 37.60663134 | -91.50790473 | 2020-03-27 22:14:55 | Dent, Missouri, US |
806606 | 806606 | 2020-03-27 | US | Missouri | Douglas | 29067 | 0 | 0 | 0 | 0 | 36.9325593 | -92.49905109 | 2020-03-27 22:14:55 | Douglas, Missouri, US |
806818 | 806818 | 2020-03-27 | US | Missouri | Gasconade | 29073 | 0 | 0 | 0 | 0 | 38.43947277 | -91.50847147 | 2020-03-27 22:14:55 | Gasconade, Missouri, US |
806827 | 806827 | 2020-03-27 | US | Missouri | Gentry | 29075 | 0 | 0 | 0 | 0 | 40.21097916 | -94.40944419 | 2020-03-27 22:14:55 | Gentry, Missouri, US |
806933 | 806933 | 2020-03-27 | US | Missouri | Grundy | 29079 | 0 | 0 | 0 | 0 | 40.11406587 | -93.56509276 | 2020-03-27 22:14:55 | Grundy, Missouri, US |
807011 | 807011 | 2020-03-27 | US | Missouri | Harrison | 29081 | 0 | 0 | 0 | 0 | 40.35570088 | -93.99222144 | 2020-03-27 22:14:55 | Harrison, Missouri, US |
807058 | 807058 | 2020-03-27 | US | Missouri | Hickory | 29085 | 0 | 0 | 0 | 0 | 37.94163617 | -93.3203037 | 2020-03-27 22:14:55 | Hickory, Missouri, US |
807079 | 807079 | 2020-03-27 | US | Missouri | Holt | 29087 | 0 | 0 | 0 | 0 | 40.09799248 | -95.21638879999999 | 2020-03-27 22:14:55 | Holt, Missouri, US |
807102 | 807102 | 2020-03-27 | US | Missouri | Howard | 29089 | 0 | 0 | 0 | 0 | 39.1435761 | -92.69756691 | 2020-03-27 22:14:55 | Howard, Missouri, US |
807105 | 807105 | 2020-03-27 | US | Missouri | Howell | 29091 | 0 | 0 | 0 | 0 | 36.77383887 | -91.88683935 | 2020-03-27 22:14:55 | Howell, Missouri, US |
807144 | 807144 | 2020-03-27 | US | Missouri | Iron | 29093 | 0 | 0 | 0 | 0 | 37.55487945 | -90.7735296 | 2020-03-27 22:14:55 | Iron, Missouri, US |
807325 | 807325 | 2020-03-27 | US | Missouri | Knox | 29103 | 0 | 0 | 0 | 0 | 40.12699751 | -92.14780832 | 2020-03-27 22:14:55 | Knox, Missouri, US |
807348 | 807348 | 2020-03-27 | US | Missouri | Laclede | 29105 | 0 | 0 | 0 | 0 | 37.65896829 | -92.5888493 | 2020-03-27 22:14:55 | Laclede, Missouri, US |
807407 | 807407 | 2020-03-27 | US | Missouri | Lawrence | 29109 | 0 | 0 | 0 | 0 | 37.10626634 | -93.83293097 | 2020-03-27 22:14:55 | Lawrence, Missouri, US |
807443 | 807443 | 2020-03-27 | US | Missouri | Lewis | 29111 | 0 | 0 | 0 | 0 | 40.09673161 | -91.72070156 | 2020-03-27 22:14:55 | Lewis, Missouri, US |
807484 | 807484 | 2020-03-27 | US | Missouri | Linn | 29115 | 0 | 0 | 0 | 0 | 39.87001769 | -93.10704106 | 2020-03-27 22:14:55 | Linn, Missouri, US |
807494 | 807494 | 2020-03-27 | US | Missouri | Livingston | 29117 | 0 | 0 | 0 | 0 | 39.78110272 | -93.54645978 | 2020-03-27 22:14:55 | Livingston, Missouri, US |
807544 | 807544 | 2020-03-27 | US | Missouri | Macon | 29121 | 0 | 0 | 0 | 0 | 39.83049768 | -92.56453089 | 2020-03-27 22:14:55 | Macon, Missouri, US |
807560 | 807560 | 2020-03-27 | US | Missouri | Madison | 29123 | 0 | 0 | 0 | 0 | 37.47865134 | -90.34671429999999 | 2020-03-27 22:14:55 | Madison, Missouri, US |
807583 | 807583 | 2020-03-27 | US | Missouri | Maries | 29125 | 0 | 0 | 0 | 0 | 38.16193985 | -91.92249662 | 2020-03-27 22:14:55 | Maries, Missouri, US |
807596 | 807596 | 2020-03-27 | US | Missouri | Marion | 29127 | 0 | 0 | 0 | 0 | 39.80601912 | -91.62203062 | 2020-03-27 22:14:55 | Marion, Missouri, US |
807694 | 807694 | 2020-03-27 | US | Missouri | Mercer | 29129 | 0 | 0 | 0 | 0 | 40.42212303 | -93.56829590000001 | 2020-03-27 22:14:55 | Mercer, Missouri, US |
807721 | 807721 | 2020-03-27 | US | Missouri | Miller | 29131 | 0 | 0 | 0 | 0 | 38.21450288 | -92.42610898 | 2020-03-27 22:14:55 | Miller, Missouri, US |
807735 | 807735 | 2020-03-27 | US | Missouri | Mississippi | 29133 | 0 | 0 | 0 | 0 | 36.82516239 | -89.29505753 | 2020-03-27 22:14:55 | Mississippi, Missouri, US |
807761 | 807761 | 2020-03-27 | US | Missouri | Monroe | 29137 | 0 | 0 | 0 | 0 | 39.49593978 | -92.00043978 | 2020-03-27 22:14:55 | Monroe, Missouri, US |
807805 | 807805 | 2020-03-27 | US | Missouri | Morgan | 29141 | 0 | 0 | 0 | 0 | 38.4181765 | -92.88791859 | 2020-03-27 22:14:55 | Morgan, Missouri, US |
807860 | 807860 | 2020-03-27 | US | Missouri | New Madrid | 29143 | 0 | 0 | 0 | 0 | 36.59666326 | -89.66070007 | 2020-03-27 22:14:55 | New Madrid, Missouri, US |
807882 | 807882 | 2020-03-27 | US | Missouri | Nodaway | 29147 | 0 | 0 | 0 | 0 | 40.36079813 | -94.88133008 | 2020-03-27 22:14:55 | Nodaway, 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]);