daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
117,101 rows where province_or_state = "Missouri" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-01-23 | US | Missouri | Adair | 29001 | 4914 | 56 | 0 | 40.19058551 | -92.60078167 | 2022-01-24 04:21:12 | Adair, Missouri, US | |
2021-12-01 | US | Missouri | Adair | 29001 | 3639 | 35 | 0 | 40.19058551 | -92.60078167 | 2021-12-02 04:22:37 | Adair, Missouri, US | |
2022-12-12 | US | Missouri | Adair | 29001 | 6445 | 70 | 0 | 40.19058551 | -92.60078167 | 2022-12-13 04:21:01 | Adair, Missouri, US | |
2021-02-18 | US | Missouri | Adair | 29001 | 2050 | 16 | 0 | 2034 | 40.19058551 | -92.60078167 | 2021-02-19 05:24:16 | Adair, Missouri, US |
2022-04-29 | US | Missouri | Adair | 29001 | 5506 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-04-30 04:21:05 | Adair, Missouri, US | |
2022-08-18 | US | Missouri | Adair | 29001 | 6051 | 68 | 0 | 40.19058551 | -92.60078167 | 2022-08-19 04:20:54 | Adair, Missouri, US | |
2021-07-04 | US | Missouri | Adair | 29001 | 2498 | 19 | 0 | 40.19058551 | -92.60078167 | 2021-07-05 04:21:28 | Adair, Missouri, US | |
2022-05-20 | US | Missouri | Adair | 29001 | 5544 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-05-21 04:20:58 | Adair, Missouri, US | |
2020-09-10 | US | Missouri | Adair | 29001 | 283 | 0 | 0 | 283 | 40.19058551 | -92.60078167 | 2020-09-11 04:46:23 | Adair, Missouri, US |
2020-10-22 | US | Missouri | Adair | 29001 | 482 | 0 | 0 | 482 | 40.19058551 | -92.60078167 | 2020-10-23 04:24:46 | Adair, Missouri, US |
2020-05-01 | US | Missouri | Adair | 29001 | 12 | 0 | 0 | 12 | 40.19058551 | -92.60078167 | 2020-05-02 02:32:27 | Adair, Missouri, US |
2022-05-18 | US | Missouri | Adair | 29001 | 5530 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-05-19 04:20:54 | Adair, Missouri, US | |
2021-05-31 | US | Missouri | Adair | 29001 | 2399 | 19 | 0 | 40.19058551 | -92.60078167 | 2021-06-01 04:23:09 | Adair, Missouri, US | |
2020-06-17 | US | Missouri | Adair | 29001 | 85 | 0 | 0 | 85 | 40.19058551 | -92.60078167 | 2020-06-18 04:33:18 | Adair, Missouri, US |
2020-04-22 | US | Missouri | Adair | 29001 | 12 | 0 | 0 | 12 | 40.19058551 | -92.60078167 | 2020-04-22 23:30:53 | Adair, Missouri, US |
2022-07-06 | US | Missouri | Adair | 29001 | 5774 | 67 | 0 | 40.19058551 | -92.60078167 | 2022-07-07 04:20:55 | Adair, Missouri, US | |
2021-03-22 | US | Missouri | Adair | 29001 | 2373 | 18 | 0 | 40.19058551 | -92.60078167 | 2021-03-23 05:26:18 | Adair, Missouri, US | |
2020-06-09 | US | Missouri | Adair | 29001 | 74 | 0 | 0 | 74 | 40.19058551 | -92.60078167 | 2020-06-10 04:07:00 | Adair, Missouri, US |
2022-07-11 | US | Missouri | Adair | 29001 | 5817 | 67 | 0 | 40.19058551 | -92.60078167 | 2022-07-12 04:20:51 | Adair, Missouri, US | |
2022-01-08 | US | Missouri | Adair | 29001 | 4339 | 53 | 0 | 40.19058551 | -92.60078167 | 2022-01-09 04:21:46 | Adair, Missouri, US | |
2021-03-27 | US | Missouri | Adair | 29001 | 2390 | 18 | 0 | 40.19058551 | -92.60078167 | 2021-03-28 05:28:10 | Adair, Missouri, US | |
2022-04-14 | US | Missouri | Adair | 29001 | 5489 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-04-15 04:20:57 | Adair, Missouri, US | |
2022-01-24 | US | Missouri | Adair | 29001 | 4941 | 56 | 0 | 40.19058551 | -92.60078167 | 2022-01-25 04:21:05 | Adair, Missouri, US | |
2021-11-28 | US | Missouri | Adair | 29001 | 3587 | 35 | 0 | 40.19058551 | -92.60078167 | 2021-11-29 04:22:30 | Adair, Missouri, US | |
2021-09-27 | US | Missouri | Adair | 29001 | 3320 | 31 | 0 | 40.19058551 | -92.60078167 | 2021-09-28 04:21:28 | Adair, Missouri, US | |
2022-11-28 | US | Missouri | Adair | 29001 | 6409 | 70 | 0 | 40.19058551 | -92.60078167 | 2022-11-29 04:21:05 | Adair, Missouri, US | |
2020-09-08 | US | Missouri | Adair | 29001 | 275 | 0 | 0 | 275 | 40.19058551 | -92.60078167 | 2020-09-09 04:28:48 | Adair, Missouri, US |
2020-04-10 | US | Missouri | Adair | 29001 | 11 | 0 | 0 | 11 | 40.19058551 | -92.60078167 | 2020-04-10 22:54:07 | Adair, Missouri, US |
2022-08-23 | US | Missouri | Adair | 29001 | 6084 | 68 | 0 | 40.19058551 | -92.60078167 | 2022-08-24 04:20:46 | Adair, Missouri, US | |
2021-12-20 | US | Missouri | Adair | 29001 | 3994 | 45 | 0 | 40.19058551 | -92.60078167 | 2021-12-21 03:21:27 | Adair, Missouri, US | |
2021-12-18 | US | Missouri | Adair | 29001 | 3989 | 45 | 0 | 40.19058551 | -92.60078167 | 2021-12-19 04:21:11 | Adair, Missouri, US | |
2021-09-09 | US | Missouri | Adair | 29001 | 3176 | 28 | 0 | 40.19058551 | -92.60078167 | 2021-09-10 04:21:20 | Adair, Missouri, US | |
2020-06-05 | US | Missouri | Adair | 29001 | 67 | 0 | 0 | 67 | 40.19058551 | -92.60078167 | 2020-06-06 02:33:00 | Adair, Missouri, US |
2020-06-11 | US | Missouri | Adair | 29001 | 74 | 0 | 0 | 74 | 40.19058551 | -92.60078167 | 2020-06-12 05:09:52 | Adair, Missouri, US |
2021-10-03 | US | Missouri | Adair | 29001 | 3347 | 31 | 0 | 40.19058551 | -92.60078167 | 2021-10-04 04:21:31 | Adair, Missouri, US | |
2020-06-04 | US | Missouri | Adair | 29001 | 62 | 0 | 0 | 62 | 40.19058551 | -92.60078167 | 2020-06-05 02:33:06 | Adair, Missouri, US |
2022-01-05 | US | Missouri | Adair | 29001 | 4250 | 53 | 0 | 40.19058551 | -92.60078167 | 2022-01-06 04:22:09 | Adair, Missouri, US | |
2022-01-04 | US | Missouri | Adair | 29001 | 4213 | 53 | 0 | 40.19058551 | -92.60078167 | 2022-01-05 04:21:59 | Adair, Missouri, US | |
2021-03-29 | US | Missouri | Adair | 29001 | 2396 | 18 | 0 | 40.19058551 | -92.60078167 | 2021-03-30 04:26:23 | Adair, Missouri, US | |
2022-02-05 | US | Missouri | Adair | 29001 | 5272 | 58 | 0 | 40.19058551 | -92.60078167 | 2022-02-06 04:21:00 | Adair, Missouri, US | |
2022-02-17 | US | Missouri | Adair | 29001 | 5407 | 59 | 0 | 40.19058551 | -92.60078167 | 2022-02-18 04:21:04 | Adair, Missouri, US | |
2021-04-01 | US | Missouri | Adair | 29001 | 2399 | 18 | 0 | 40.19058551 | -92.60078167 | 2021-04-02 04:20:36 | Adair, Missouri, US | |
2021-07-27 | US | Missouri | Adair | 29001 | 2622 | 21 | 0 | 40.19058551 | -92.60078167 | 2021-07-28 04:21:39 | Adair, Missouri, US | |
2021-05-26 | US | Missouri | Adair | 29001 | 2394 | 19 | 0 | 40.19058551 | -92.60078167 | 2021-05-27 04:20:59 | Adair, Missouri, US | |
2022-05-27 | US | Missouri | Adair | 29001 | 5562 | 65 | 0 | 40.19058551 | -92.60078167 | 2022-05-28 04:21:07 | Adair, Missouri, US | |
2022-01-26 | US | Missouri | Adair | 29001 | 5043 | 56 | 0 | 40.19058551 | -92.60078167 | 2022-01-27 04:21:19 | Adair, Missouri, US | |
2021-11-14 | US | Missouri | Adair | 29001 | 3505 | 34 | 0 | 40.19058551 | -92.60078167 | 2021-11-15 04:21:36 | Adair, Missouri, US | |
2022-04-26 | US | Missouri | Adair | 29001 | 5496 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-04-27 04:20:52 | Adair, Missouri, US | |
2021-07-24 | US | Missouri | Adair | 29001 | 2608 | 20 | 0 | 40.19058551 | -92.60078167 | 2021-07-25 04:22:12 | Adair, Missouri, US | |
2021-09-28 | US | Missouri | Adair | 29001 | 3331 | 31 | 0 | 40.19058551 | -92.60078167 | 2021-09-29 04:21:45 | Adair, Missouri, US | |
2021-02-15 | US | Missouri | Adair | 29001 | 2046 | 13 | 0 | 2033 | 40.19058551 | -92.60078167 | 2021-02-16 05:24:38 | Adair, Missouri, US |
2021-08-11 | US | Missouri | Adair | 29001 | 2819 | 24 | 0 | 40.19058551 | -92.60078167 | 2021-08-12 04:21:25 | Adair, Missouri, US | |
2022-08-10 | US | Missouri | Adair | 29001 | 6010 | 68 | 0 | 40.19058551 | -92.60078167 | 2022-08-11 04:20:49 | Adair, Missouri, US | |
2020-11-24 | US | Missouri | Adair | 29001 | 1032 | 3 | 0 | 1029 | 40.19058551 | -92.60078167 | 2020-11-25 05:27:20 | Adair, Missouri, US |
2020-09-03 | US | Missouri | Adair | 29001 | 248 | 0 | 0 | 248 | 40.19058551 | -92.60078167 | 2020-09-04 04:28:26 | Adair, Missouri, US |
2021-11-27 | US | Missouri | Adair | 29001 | 3587 | 35 | 0 | 40.19058551 | -92.60078167 | 2021-11-28 04:22:43 | Adair, Missouri, US | |
2022-02-08 | US | Missouri | Adair | 29001 | 5300 | 58 | 0 | 40.19058551 | -92.60078167 | 2022-02-09 04:21:04 | Adair, Missouri, US | |
2022-10-28 | US | Missouri | Adair | 29001 | 6351 | 69 | 0 | 40.19058551 | -92.60078167 | 2022-10-29 04:21:13 | Adair, Missouri, US | |
2022-09-21 | US | Missouri | Adair | 29001 | 6235 | 68 | 0 | 40.19058551 | -92.60078167 | 2022-09-22 04:22:56 | Adair, Missouri, US | |
2021-09-15 | US | Missouri | Adair | 29001 | 3224 | 29 | 0 | 40.19058551 | -92.60078167 | 2021-09-16 04:22:19 | Adair, Missouri, US | |
2021-07-25 | US | Missouri | Adair | 29001 | 2614 | 20 | 0 | 40.19058551 | -92.60078167 | 2021-07-26 04:21:28 | Adair, Missouri, US | |
2020-04-19 | US | Missouri | Adair | 29001 | 12 | 0 | 0 | 12 | 40.19058551 | -92.60078167 | 2020-04-19 23:41:01 | Adair, Missouri, US |
2021-09-13 | US | Missouri | Adair | 29001 | 3206 | 29 | 0 | 40.19058551 | -92.60078167 | 2021-09-14 04:21:41 | Adair, Missouri, US | |
2022-01-07 | US | Missouri | Adair | 29001 | 4299 | 53 | 0 | 40.19058551 | -92.60078167 | 2022-01-08 04:21:53 | Adair, Missouri, US | |
2022-09-02 | US | Missouri | Adair | 29001 | 6159 | 68 | 0 | 40.19058551 | -92.60078167 | 2022-09-03 04:21:04 | Adair, Missouri, US | |
2022-05-06 | US | Missouri | Adair | 29001 | 5510 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-05-07 04:21:09 | Adair, Missouri, US | |
2020-05-14 | US | Missouri | Adair | 29001 | 15 | 0 | 0 | 15 | 40.19058551 | -92.60078167 | 2020-05-15 02:33:02 | Adair, Missouri, US |
2022-08-02 | US | Missouri | Adair | 29001 | 5943 | 68 | 0 | 40.19058551 | -92.60078167 | 2022-08-03 04:20:59 | Adair, Missouri, US | |
2021-04-23 | US | Missouri | Adair | 29001 | 2355 | 19 | 0 | 40.19058551 | -92.60078167 | 2021-04-24 04:20:38 | Adair, Missouri, US | |
2021-05-24 | US | Missouri | Adair | 29001 | 2390 | 19 | 0 | 40.19058551 | -92.60078167 | 2021-05-25 04:21:08 | Adair, Missouri, US | |
2022-07-08 | US | Missouri | Adair | 29001 | 5817 | 67 | 0 | 40.19058551 | -92.60078167 | 2022-07-09 04:20:59 | Adair, Missouri, US | |
2022-06-08 | US | Missouri | Adair | 29001 | 5594 | 65 | 0 | 40.19058551 | -92.60078167 | 2022-06-09 04:20:54 | Adair, Missouri, US | |
2021-05-09 | US | Missouri | Adair | 29001 | 2376 | 19 | 0 | 40.19058551 | -92.60078167 | 2021-05-10 04:20:38 | Adair, Missouri, US | |
2020-05-20 | US | Missouri | Adair | 29001 | 34 | 0 | 0 | 34 | 40.19058551 | -92.60078167 | 2020-05-21 02:32:48 | Adair, Missouri, US |
2021-12-28 | US | Missouri | Adair | 29001 | 4090 | 53 | 0 | 40.19058551 | -92.60078167 | 2021-12-29 03:21:43 | Adair, Missouri, US | |
2022-03-28 | US | Missouri | Adair | 29001 | 5497 | 62 | 0 | 40.19058551 | -92.60078167 | 2022-03-29 04:20:46 | Adair, Missouri, US | |
2021-07-07 | US | Missouri | Adair | 29001 | 2509 | 19 | 0 | 40.19058551 | -92.60078167 | 2021-07-08 04:21:26 | Adair, Missouri, US | |
2020-09-11 | US | Missouri | Adair | 29001 | 284 | 0 | 0 | 284 | 40.19058551 | -92.60078167 | 2020-09-12 04:25:05 | Adair, Missouri, US |
2021-06-03 | US | Missouri | Adair | 29001 | 2402 | 19 | 0 | 40.19058551 | -92.60078167 | 2021-06-04 04:23:37 | Adair, Missouri, US | |
2020-10-27 | US | Missouri | Adair | 29001 | 519 | 0 | 0 | 519 | 40.19058551 | -92.60078167 | 2020-10-28 04:24:39 | Adair, Missouri, US |
2020-04-24 | US | Missouri | Adair | 29001 | 12 | 0 | 0 | 12 | 40.19058551 | -92.60078167 | 2020-04-25 06:30:53 | Adair, Missouri, US |
2021-01-31 | US | Missouri | Adair | 29001 | 1992 | 7 | 0 | 1985 | 40.19058551 | -92.60078167 | 2021-02-01 05:22:53 | Adair, Missouri, US |
2022-02-10 | US | Missouri | Adair | 29001 | 5341 | 59 | 0 | 40.19058551 | -92.60078167 | 2022-02-11 04:21:09 | Adair, Missouri, US | |
2022-03-24 | US | Missouri | Adair | 29001 | 5494 | 62 | 0 | 40.19058551 | -92.60078167 | 2022-03-25 04:20:46 | Adair, Missouri, US | |
2022-01-17 | US | Missouri | Adair | 29001 | 4563 | 54 | 0 | 40.19058551 | -92.60078167 | 2022-01-18 04:21:04 | Adair, Missouri, US | |
2020-03-24 | US | Missouri | Adair | 29001 | 1 | 0 | 0 | 1 | 40.19058551 | -92.60078167 | 2020-03-24 23:37:31 | Adair, Missouri, US |
2020-08-21 | US | Missouri | Adair | 29001 | 199 | 0 | 0 | 199 | 40.19058551 | -92.60078167 | 2020-08-22 04:27:49 | Adair, Missouri, US |
2021-08-13 | US | Missouri | Adair | 29001 | 2853 | 24 | 0 | 40.19058551 | -92.60078167 | 2021-08-14 04:21:25 | Adair, Missouri, US | |
2022-07-26 | US | Missouri | Adair | 29001 | 5904 | 68 | 0 | 40.19058551 | -92.60078167 | 2022-07-27 04:21:04 | Adair, Missouri, US | |
2021-10-12 | US | Missouri | Adair | 29001 | 3385 | 32 | 0 | 40.19058551 | -92.60078167 | 2021-10-13 04:20:51 | Adair, Missouri, US | |
2021-07-03 | US | Missouri | Adair | 29001 | 2496 | 19 | 0 | 40.19058551 | -92.60078167 | 2021-07-04 04:21:38 | Adair, Missouri, US | |
2020-07-25 | US | Missouri | Adair | 29001 | 118 | 0 | 0 | 118 | 40.19058551 | -92.60078167 | 2020-07-26 04:35:00 | Adair, Missouri, US |
2022-05-16 | US | Missouri | Adair | 29001 | 5530 | 63 | 0 | 40.19058551 | -92.60078167 | 2022-05-17 04:20:59 | Adair, Missouri, US | |
2020-06-22 | US | Missouri | Adair | 29001 | 86 | 0 | 0 | 86 | 40.19058551 | -92.60078167 | 2020-06-23 04:33:22 | Adair, Missouri, US |
2022-02-24 | US | Missouri | Adair | 29001 | 5447 | 61 | 0 | 40.19058551 | -92.60078167 | 2022-02-25 04:21:11 | Adair, Missouri, US | |
2020-09-28 | US | Missouri | Adair | 29001 | 350 | 0 | 0 | 350 | 40.19058551 | -92.60078167 | 2020-09-29 04:23:42 | Adair, Missouri, US |
2020-06-23 | US | Missouri | Adair | 29001 | 86 | 0 | 0 | 86 | 40.19058551 | -92.60078167 | 2020-06-24 04:33:28 | Adair, Missouri, US |
2020-08-28 | US | Missouri | Adair | 29001 | 222 | 0 | 0 | 222 | 40.19058551 | -92.60078167 | 2020-08-29 04:28:19 | Adair, Missouri, US |
2021-02-09 | US | Missouri | Adair | 29001 | 2019 | 11 | 0 | 2008 | 40.19058551 | -92.60078167 | 2021-02-10 05:22:41 | Adair, Missouri, US |
2022-08-26 | US | Missouri | Adair | 29001 | 6131 | 68 | 0 | 40.19058551 | -92.60078167 | 2022-08-27 04:20:57 | Adair, Missouri, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;