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)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2306 | 2306 | 2021-12-02 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-12-03 04:23:05 | Unassigned, Missouri, US | |
6321 | 6321 | 2021-10-28 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Missouri, US | |
18328 | 18328 | 2021-09-18 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-09-19 04:21:34 | Unassigned, Missouri, US | |
22339 | 22339 | 2021-05-28 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-05-29 04:20:41 | Unassigned, Missouri, US | |
26377 | 26377 | 2022-03-20 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-03-21 04:20:50 | Unassigned, Missouri, US | |
30392 | 30392 | 2021-11-11 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-11-12 04:22:01 | Unassigned, Missouri, US | |
34388 | 34388 | 2021-08-25 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-08-26 04:21:28 | Unassigned, Missouri, US | |
38398 | 38398 | 2021-04-12 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-04-13 04:20:37 | Unassigned, Missouri, US | |
42719 | 42719 | 2020-04-13 | US | Missouri | Texas | 29215 | 0 | 0 | 0 | 0 | 37.31728859 | -91.96564727 | 2020-04-13 23:07:54 | Texas, Missouri, US |
42796 | 42796 | 2020-04-13 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2020-04-13 23:07:54 | Unassigned, Missouri, US |
45684 | 45684 | 2021-11-02 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-11-03 06:22:09 | Unassigned, Missouri, US | |
49811 | 49811 | 2020-04-17 | US | Missouri | Texas | 29215 | 0 | 0 | 0 | 0 | 37.31728859 | -91.96564727 | 2020-04-17 23:30:52 | Texas, Missouri, US |
49889 | 49889 | 2020-04-17 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2020-04-17 23:30:52 | Unassigned, Missouri, US |
52760 | 52760 | 2021-05-29 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-05-30 04:20:55 | Unassigned, Missouri, US | |
65042 | 65042 | 2022-11-12 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-11-13 04:21:14 | Unassigned, Missouri, US | |
69033 | 69033 | 2021-09-01 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-09-02 04:21:15 | Unassigned, Missouri, US | |
73067 | 73067 | 2022-02-07 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-02-08 04:21:15 | Unassigned, Missouri, US | |
85063 | 85063 | 2021-05-25 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-05-26 04:20:35 | Unassigned, Missouri, US | |
89101 | 89101 | 2021-11-09 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-11-10 04:21:38 | Unassigned, Missouri, US | |
93119 | 93119 | 2022-07-23 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-07-24 04:20:47 | Unassigned, Missouri, US | |
101302 | 101302 | 2022-01-14 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-01-15 04:21:07 | Unassigned, Missouri, US | |
105298 | 105298 | 2021-08-15 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-08-16 04:21:31 | Unassigned, Missouri, US | |
109422 | 109422 | 2021-06-19 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-06-20 04:21:48 | Unassigned, Missouri, US | |
113725 | 113725 | 2020-05-08 | US | Missouri | Texas | 29215 | 0 | 0 | 0 | 0 | 37.31728859 | -91.96564727 | 2020-05-09 02:32:35 | Texas, Missouri, US |
116729 | 116729 | 2022-09-06 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-09-07 04:20:59 | Unassigned, Missouri, US | |
128709 | 128709 | 2022-01-09 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-01-10 04:22:07 | Unassigned, Missouri, US | |
132730 | 132730 | 2022-10-04 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-10-05 04:23:06 | Unassigned, Missouri, US | |
136955 | 136955 | 2020-04-29 | US | Missouri | Texas | 29215 | 0 | 0 | 0 | 0 | 37.31728859 | -91.96564727 | 2020-04-30 02:32:27 | Texas, Missouri, US |
139947 | 139947 | 2021-12-04 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-12-05 04:22:25 | Unassigned, Missouri, US | |
143965 | 143965 | 2022-07-09 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-07-10 04:20:54 | Unassigned, Missouri, US | |
151960 | 151960 | 2021-11-29 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-11-30 04:22:53 | Unassigned, Missouri, US | |
159989 | 159989 | 2022-03-29 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-03-30 04:20:45 | Unassigned, Missouri, US | |
164004 | 164004 | 2021-11-19 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-11-20 04:22:17 | Unassigned, Missouri, US | |
168022 | 168022 | 2022-06-21 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-06-22 04:20:54 | Unassigned, Missouri, US | |
172012 | 172012 | 2021-04-16 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-04-17 04:20:40 | Unassigned, Missouri, US | |
179998 | 179998 | 2021-09-02 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-09-03 04:21:20 | Unassigned, Missouri, US | |
188047 | 188047 | 2022-02-13 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-02-14 04:20:51 | Unassigned, Missouri, US | |
200239 | 200239 | 2022-10-19 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-10-20 04:22:59 | Unassigned, Missouri, US | |
219960 | 219960 | 2022-12-26 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Missouri, US | |
223972 | 223972 | 2022-05-09 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-05-10 04:20:50 | Unassigned, Missouri, US | |
228207 | 228207 | 2020-04-30 | US | Missouri | Texas | 29215 | 0 | 0 | 0 | 0 | 37.31728859 | -91.96564727 | 2020-05-01 02:32:28 | Texas, Missouri, US |
231204 | 231204 | 2022-05-31 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-06-01 04:20:55 | Unassigned, Missouri, US | |
235219 | 235219 | 2022-02-11 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-02-12 04:21:06 | Unassigned, Missouri, US | |
243223 | 243223 | 2021-04-02 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-04-03 04:20:44 | Unassigned, Missouri, US | |
247241 | 247241 | 2021-08-17 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-08-18 04:21:35 | Unassigned, Missouri, US | |
251255 | 251255 | 2021-09-04 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-09-05 04:21:33 | Unassigned, Missouri, US | |
255291 | 255291 | 2022-09-08 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-09-09 04:21:11 | Unassigned, Missouri, US | |
259310 | 259310 | 2022-12-10 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-12-11 04:20:50 | Unassigned, Missouri, US | |
263509 | 263509 | 2022-03-15 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-03-16 04:20:50 | Unassigned, Missouri, US | |
267825 | 267825 | 2020-05-21 | US | Missouri | Texas | 29215 | 0 | 0 | 0 | 0 | 37.31728859 | -91.96564727 | 2020-05-22 02:36:51 | Texas, Missouri, US |
271169 | 271169 | 2020-04-28 | US | Missouri | Texas | 29215 | 0 | 0 | 0 | 0 | 37.31728859 | -91.96564727 | 2020-04-29 02:32:29 | Texas, Missouri, US |
278159 | 278159 | 2021-11-03 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-11-04 04:22:20 | Unassigned, Missouri, US | |
285093 | 285093 | 2020-06-15 | US | Missouri | Hickory | 29085 | 0 | 0 | 0 | 0 | 37.94163617 | -93.3203037 | 2020-06-16 04:33:09 | Hickory, Missouri, US |
285986 | 285986 | 2020-06-15 | US | Missouri | Ozark | 29153 | 0 | 0 | 0 | 0 | 36.64916339 | -92.44459066 | 2020-06-16 04:33:09 | Ozark, Missouri, US |
286813 | 286813 | 2020-06-15 | US | Missouri | Wayne | 29223 | 0 | 0 | 0 | 0 | 37.11303869 | -90.46001416 | 2020-06-16 04:33:09 | Wayne, Missouri, US |
289971 | 289971 | 2021-10-31 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-11-01 04:22:01 | Unassigned, Missouri, US | |
293993 | 293993 | 2022-11-15 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-11-16 04:21:09 | Unassigned, Missouri, US | |
297984 | 297984 | 2021-07-15 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-07-16 04:21:22 | Unassigned, Missouri, US | |
305845 | 305845 | 2022-04-16 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-04-17 04:20:59 | Unassigned, Missouri, US | |
309865 | 309865 | 2022-12-13 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-12-14 04:21:04 | Unassigned, Missouri, US | |
313881 | 313881 | 2022-11-13 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-11-14 04:21:09 | Unassigned, Missouri, US | |
317893 | 317893 | 2022-02-12 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-02-13 04:21:00 | Unassigned, Missouri, US | |
321913 | 321913 | 2022-10-30 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-10-31 04:21:36 | Unassigned, Missouri, US | |
329887 | 329887 | 2022-12-27 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Missouri, US | |
333878 | 333878 | 2021-08-04 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-08-05 04:21:51 | Unassigned, Missouri, US | |
337913 | 337913 | 2022-03-18 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-03-19 04:20:47 | Unassigned, Missouri, US | |
350277 | 350277 | 2022-12-14 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-12-15 04:20:58 | Unassigned, Missouri, US | |
354262 | 354262 | 2021-03-11 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-03-12 05:26:50 | Unassigned, Missouri, US | |
358303 | 358303 | 2022-03-11 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-03-12 04:20:50 | Unassigned, Missouri, US | |
362319 | 362319 | 2022-05-07 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-05-08 04:20:49 | Unassigned, Missouri, US | |
374177 | 374177 | 2022-09-13 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-09-14 04:20:44 | Unassigned, Missouri, US | |
382161 | 382161 | 2021-04-30 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-05-01 04:20:47 | Unassigned, Missouri, US | |
386204 | 386204 | 2022-09-23 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-09-24 04:21:40 | Unassigned, Missouri, US | |
390191 | 390191 | 2021-04-04 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-04-05 04:20:35 | Unassigned, Missouri, US | |
398245 | 398245 | 2022-10-07 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-10-08 04:22:56 | Unassigned, Missouri, US | |
402236 | 402236 | 2021-06-29 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-06-30 04:21:41 | Unassigned, Missouri, US | |
406270 | 406270 | 2021-12-07 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-12-08 04:22:46 | Unassigned, Missouri, US | |
410266 | 410266 | 2021-07-28 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-07-29 04:21:33 | Unassigned, Missouri, US | |
413225 | 413225 | 2020-07-05 | US | Missouri | Hickory | 29085 | 0 | 0 | 0 | 0 | 37.94163617 | -93.3203037 | 2020-07-06 04:33:57 | Hickory, Missouri, US |
418338 | 418338 | 2020-04-18 | US | Missouri | Texas | 29215 | 0 | 0 | 0 | 0 | 37.31728859 | -91.96564727 | 2020-04-18 22:32:47 | Texas, Missouri, US |
418416 | 418416 | 2020-04-18 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2020-04-18 22:32:47 | Unassigned, Missouri, US |
421316 | 421316 | 2022-09-18 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-09-19 04:21:49 | Unassigned, Missouri, US | |
425326 | 425326 | 2021-10-10 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-10-11 04:21:31 | Unassigned, Missouri, US | |
433338 | 433338 | 2022-11-03 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-11-04 04:22:11 | Unassigned, Missouri, US | |
445330 | 445330 | 2021-10-20 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-10-21 04:21:18 | Unassigned, Missouri, US | |
449347 | 449347 | 2021-11-17 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-11-18 04:21:33 | Unassigned, Missouri, US | |
453368 | 453368 | 2022-12-21 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-12-22 04:20:56 | Unassigned, Missouri, US | |
461356 | 461356 | 2022-02-02 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-02-03 04:21:21 | Unassigned, Missouri, US | |
465373 | 465373 | 2022-05-02 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-05-03 04:21:00 | Unassigned, Missouri, US | |
469387 | 469387 | 2021-10-07 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-10-08 04:21:25 | Unassigned, Missouri, US | |
477420 | 477420 | 2022-06-26 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-06-27 04:21:00 | Unassigned, Missouri, US | |
481571 | 481571 | 2022-11-08 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-11-09 04:21:22 | Unassigned, Missouri, US | |
485562 | 485562 | 2021-07-19 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-07-20 04:21:48 | Unassigned, Missouri, US | |
489601 | 489601 | 2022-11-25 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-11-26 04:21:11 | Unassigned, Missouri, US | |
493611 | 493611 | 2021-10-14 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-10-15 04:21:26 | Unassigned, Missouri, US | |
497628 | 497628 | 2021-11-06 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-11-07 04:21:53 | Unassigned, Missouri, US | |
501645 | 501645 | 2022-04-02 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-04-03 04:20:48 | Unassigned, Missouri, US | |
505665 | 505665 | 2022-12-17 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2022-12-18 04:21:03 | Unassigned, Missouri, US | |
509656 | 509656 | 2021-08-14 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-08-15 04:21:41 | Unassigned, Missouri, US | |
513670 | 513670 | 2021-08-19 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-08-20 04:21:33 | Unassigned, 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]);