daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

95 rows where recovered = 573 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: province_or_state

country_or_region 11

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2021-05-11 China Fujian     597 1 573 23 26.0789 117.9874 2021-05-12 04:21:29 Fujian, China
2021-01-22 Japan Aomori     668 9 573 86 40.781541 140.828896 2021-01-23 05:22:03 Aomori, Japan
2021-01-19 Japan Saga     812 4 573 235 33.286977 130.115738 2021-01-20 05:21:54 Saga, Japan
2021-01-19 Japan Ehime     849 15 573 261 33.624835 132.856842 2021-01-20 05:21:54 Ehime, Japan
2021-01-06 Canada New Brunswick     693 9 573 111 46.5653 -66.4619 2021-01-07 05:22:03 New Brunswick, Canada
2021-01-03 Japan Kochi     687 9 573 105 33.422519 133.367307 2021-01-04 05:22:02 Kochi, Japan
2021-01-02 Japan Oita     711 6 573 132 33.200697 131.43323999999998 2021-01-03 05:22:52 Oita, Japan
2020-12-23 Japan Fukushima     782 14 573 195 37.378867 140.223295 2020-12-24 05:23:04 Fukushima, Japan
2020-12-20 Japan Miyazaki     665 5 573 87 32.193203999999994 131.299374 2020-12-21 05:27:58 Miyazaki, Japan
2020-11-06 Japan Miyagi     834 3 573 258 38.446859 140.927086 2020-11-07 05:24:52 Miyagi, Japan
2020-10-17 Italy Molise     929 26 573 330 41.55774754 14.65916051 2020-10-18 04:24:25 Molise, Italy
2020-10-16 Italy Molise     864 26 573 265 41.55774754 14.65916051 2020-10-17 04:24:12 Molise, Italy
2020-09-22 Japan Ibaraki     629 17 573 39 36.303588 140.319591 2020-09-23 04:23:00 Ibaraki, Japan
2020-09-21 Japan Ibaraki     627 16 573 38 36.303588 140.319591 2020-09-22 04:23:00 Ibaraki, Japan
2020-09-08 Ukraine Poltava Oblast     997 22 573 402 49.5883 34.5514 2020-09-09 04:28:48 Poltava Oblast, Ukraine
2020-09-07 Japan Ishikawa     708 39 573 96 36.769464 136.771027 2020-09-08 04:28:25 Ishikawa, Japan
2020-07-18 Colombia Cordoba     2584 286 573 1725 8.0493 -75.574 2020-07-19 04:34:58 Cordoba, Colombia
2020-07-15 Suriname       837 18 573 246 3.9193 -56.0278 2020-07-16 04:44:59 Suriname
2020-07-01 China Chongqing     582 6 573 3 30.0572 107.874 2020-07-02 04:33:46 Chongqing, China
2020-06-30 China Chongqing     582 6 573 3 30.0572 107.874 2020-07-01 04:33:52 Chongqing, China
2020-06-29 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-30 04:33:48 Chongqing, China
2020-06-28 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-29 04:33:44 Chongqing, China
2020-06-27 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-28 04:34:04 Chongqing, China
2020-06-26 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-27 04:33:35 Chongqing, China
2020-06-25 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-26 04:33:43 Chongqing, China
2020-06-24 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-25 05:26:54 Chongqing, China
2020-06-23 China Sichuan     589 3 573 13 30.6171 102.7103 2020-06-24 04:33:28 Sichuan, China
2020-06-23 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-24 04:33:28 Chongqing, China
2020-06-22 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-23 04:33:22 Chongqing, China
2020-06-21 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-22 04:33:20 Chongqing, China
2020-06-20 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-21 04:33:19 Chongqing, China
2020-06-19 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-20 04:33:19 Chongqing, China
2020-06-18 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-19 04:33:17 Chongqing, China
2020-06-17 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-18 04:33:18 Chongqing, China
2020-06-16 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-17 04:33:21 Chongqing, China
2020-06-15 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-16 04:33:09 Chongqing, China
2020-06-14 China Chongqing     582 6 573 3 30.0572 107.874 2020-06-15 03:33:14 Chongqing, China
2020-06-13 China Chongqing     580 6 573 1 30.0572 107.874 2020-06-14 03:33:15 Chongqing, China
2020-06-12 China Chongqing     579 6 573 0 30.0572 107.874 2020-06-13 03:33:14 Chongqing, China
2020-06-11 China Chongqing     579 6 573 0 30.0572 107.874 2020-06-12 05:09:52 Chongqing, China
2020-06-10 China Chongqing     579 6 573 0 30.0572 107.874 2020-06-11 03:33:41 Chongqing, China
2020-06-09 China Chongqing     579 6 573 0 30.0572 107.874 2020-06-10 04:07:00 Chongqing, China
2020-06-08 Ukraine Kharkiv Oblast     1287 52 573 662 49.9935 36.2304 2020-06-09 03:33:03 Kharkiv Oblast, Ukraine
2020-06-08 China Chongqing     579 6 573 0 30.0572 107.874 2020-06-09 03:33:03 Chongqing, China
2020-06-07 China Chongqing     579 6 573 0 30.0572 107.874 2020-06-08 03:33:22 Chongqing, China
2020-06-06 China Chongqing     579 6 573 0 30.0572 107.874 2020-06-07 03:53:30 Chongqing, China
2020-06-05 China Chongqing     579 6 573 0 30.0572 107.874 2020-06-06 02:33:00 Chongqing, China
2020-06-04 China Chongqing     579 6 573 0 30.0572 107.874 2020-06-05 02:33:06 Chongqing, China
2020-06-03 China Chongqing     579 6 573 0 30.0572 107.874 2020-06-04 02:33:14 Chongqing, China
2020-06-02 China Chongqing     579 6 573 0 30.0572 107.874 2020-06-03 02:33:13 Chongqing, China
2020-06-01 China Chongqing     579 6 573 0 30.0572 107.874 2020-06-02 02:33:08 Chongqing, China
2020-05-31 China Chongqing     579 6 573 0 30.0572 107.874 2020-06-01 02:32:46 Chongqing, China
2020-05-30 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-31 02:32:45 Chongqing, China
2020-05-29 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-30 02:32:48 Chongqing, China
2020-05-28 Georgia       738 12 573 153 42.3154 43.3569 2020-05-29 02:32:50 Georgia
2020-05-28 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-29 02:32:50 Chongqing, China
2020-05-27 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-28 02:32:31 Chongqing, China
2020-05-26 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-27 02:32:31 Chongqing, China
2020-05-25 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-26 02:32:35 Chongqing, China
2020-05-24 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-25 02:32:44 Chongqing, China
2020-05-23 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-24 02:32:43 Chongqing, China
2020-05-22 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-23 02:32:42 Chongqing, China
2020-05-21 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-22 02:36:51 Chongqing, China
2020-05-20 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-21 02:32:48 Chongqing, China
2020-05-19 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-20 02:32:19 Chongqing, China
2020-05-18 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-19 02:32:18 Chongqing, China
2020-05-17 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-18 02:32:21 Chongqing, China
2020-05-16 Bulgaria       2175 105 573 1497 42.7339 25.4858 2020-05-17 02:32:32 Bulgaria
2020-05-16 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-17 02:32:32 Chongqing, China
2020-05-15 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-16 02:32:19 Chongqing, China
2020-05-14 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-15 02:33:02 Chongqing, China
2020-05-13 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-14 03:32:28 Chongqing, China
2020-05-12 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-13 03:32:26 Chongqing, China
2020-05-12 China Beijing     593 9 573 11 40.1824 116.4142 2020-05-13 03:32:26 Beijing, China
2020-05-11 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-12 03:32:27 Chongqing, China
2020-05-10 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-11 02:32:30 Chongqing, China
2020-05-09 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-10 02:32:30 Chongqing, China
2020-05-08 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-09 02:32:35 Chongqing, China
2020-05-07 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-08 02:32:32 Chongqing, China
2020-05-06 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-07 02:32:28 Chongqing, China
2020-05-05 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-06 02:32:31 Chongqing, China
2020-05-04 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-05 02:32:34 Chongqing, China
2020-05-03 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-04 02:32:28 Chongqing, China
2020-05-02 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-03 02:32:28 Chongqing, China
2020-05-01 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-02 02:32:27 Chongqing, China
2020-04-30 China Chongqing     579 6 573 0 30.0572 107.874 2020-05-01 02:32:28 Chongqing, China
2020-04-29 China Chongqing     579 6 573 0 30.0572 107.874 2020-04-30 02:32:27 Chongqing, China
2020-04-28 China Chongqing     579 6 573 0 30.0572 107.874 2020-04-29 02:32:29 Chongqing, China
2020-04-27 China Chongqing     579 6 573 0 30.0572 107.874 2020-04-24 00:43:27 Chongqing, China
2020-04-26 China Chongqing     579 6 573 0 30.0572 107.874 2020-04-24 00:43:27 Chongqing, China
2020-04-25 China Chongqing     579 6 573 0 30.0572 107.874 2020-04-24 00:43:27 Chongqing, China
2020-04-24 China Chongqing     579 6 573 0 30.0572 107.874 2020-04-24 00:43:27 Chongqing, China
2020-04-23 China Chongqing     579 6 573 0 30.0572 107.874 2020-04-24 00:43:27 Chongqing, China
2020-04-05 Australia Victoria     1135 8 573 554 -37.8136 144.9631 2020-04-05 23:13:44 Victoria, Australia
2020-02-19 Mainland China Henan     1262 19 573   33.882 113.614 2020-02-19T12:13:08  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;