johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
45 rows where recovered = 1047 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
625690 | 625690 | 2021-07-10 | China | Hunan | 1061 | 4 | 1047 | 10 | 27.6104 | 111.7088 | 2021-07-11 04:21:43 | Hunan, China | ||
829409 | 829409 | 2021-07-09 | China | Hunan | 1061 | 4 | 1047 | 10 | 27.6104 | 111.7088 | 2021-07-10 04:21:25 | Hunan, China | ||
778173 | 778173 | 2021-07-08 | China | Hunan | 1061 | 4 | 1047 | 10 | 27.6104 | 111.7088 | 2021-07-09 04:21:21 | Hunan, China | ||
1440395 | 1440395 | 2021-07-07 | China | Hunan | 1061 | 4 | 1047 | 10 | 27.6104 | 111.7088 | 2021-07-08 04:21:26 | Hunan, China | ||
2693500 | 2693500 | 2021-07-06 | China | Hunan | 1061 | 4 | 1047 | 10 | 27.6104 | 111.7088 | 2021-07-07 04:21:20 | Hunan, China | ||
1932249 | 1932249 | 2021-07-05 | China | Hunan | 1061 | 4 | 1047 | 10 | 27.6104 | 111.7088 | 2021-07-06 04:21:32 | Hunan, China | ||
1164980 | 1164980 | 2021-07-04 | China | Hunan | 1061 | 4 | 1047 | 10 | 27.6104 | 111.7088 | 2021-07-05 04:21:28 | Hunan, China | ||
1495414 | 1495414 | 2021-07-03 | China | Hunan | 1061 | 4 | 1047 | 10 | 27.6104 | 111.7088 | 2021-07-04 04:21:38 | Hunan, China | ||
2071729 | 2071729 | 2021-07-02 | China | Hunan | 1061 | 4 | 1047 | 10 | 27.6104 | 111.7088 | 2021-07-03 04:21:37 | Hunan, China | ||
2764745 | 2764745 | 2021-07-01 | China | Hunan | 1057 | 4 | 1047 | 6 | 27.6104 | 111.7088 | 2021-07-02 04:21:47 | Hunan, China | ||
1892953 | 1892953 | 2021-06-30 | China | Hunan | 1057 | 4 | 1047 | 6 | 27.6104 | 111.7088 | 2021-07-01 04:21:19 | Hunan, China | ||
400076 | 400076 | 2021-06-29 | China | Hunan | 1057 | 4 | 1047 | 6 | 27.6104 | 111.7088 | 2021-06-30 04:21:41 | Hunan, China | ||
3125319 | 3125319 | 2021-06-28 | China | Hunan | 1056 | 4 | 1047 | 5 | 27.6104 | 111.7088 | 2021-06-29 04:21:28 | Hunan, China | ||
2589814 | 2589814 | 2021-06-27 | China | Hunan | 1056 | 4 | 1047 | 5 | 27.6104 | 111.7088 | 2021-06-28 04:21:29 | Hunan, China | ||
3958331 | 3958331 | 2021-06-26 | China | Sichuan | 1091 | 3 | 1047 | 41 | 30.6171 | 102.7103 | 2021-06-27 04:21:39 | Sichuan, China | ||
3958318 | 3958318 | 2021-06-26 | China | Hunan | 1054 | 4 | 1047 | 3 | 27.6104 | 111.7088 | 2021-06-27 04:21:39 | Hunan, China | ||
1712137 | 1712137 | 2021-06-25 | China | Hunan | 1054 | 4 | 1047 | 3 | 27.6104 | 111.7088 | 2021-06-26 04:21:43 | Hunan, China | ||
2295262 | 2295262 | 2021-06-24 | China | Hunan | 1052 | 4 | 1047 | 1 | 27.6104 | 111.7088 | 2021-06-25 04:21:33 | Hunan, China | ||
2422702 | 2422702 | 2021-06-23 | China | Hunan | 1051 | 4 | 1047 | 0 | 27.6104 | 111.7088 | 2021-06-24 04:21:55 | Hunan, China | ||
2716771 | 2716771 | 2021-06-10 | China | Beijing | 1068 | 9 | 1047 | 12 | 40.1824 | 116.4142 | 2021-06-11 04:23:20 | Beijing, China | ||
522656 | 522656 | 2021-06-09 | China | Beijing | 1067 | 9 | 1047 | 11 | 40.1824 | 116.4142 | 2021-06-10 04:23:17 | Beijing, China | ||
1913227 | 1913227 | 2021-05-20 | Japan | Iwate | 1300 | 42 | 1047 | 211 | 39.593287 | 141.361777 | 2021-05-21 04:20:43 | Iwate, Japan | ||
3663642 | 3663642 | 2021-03-09 | Japan | Saga | 1114 | 10 | 1047 | 57 | 33.286977 | 130.115738 | 2021-03-10 05:24:35 | Saga, Japan | ||
2975355 | 2975355 | 2020-12-09 | Netherlands | Sint Maarten | 1185 | 26 | 1047 | 112 | 18.0425 | -63.0548 | 2020-12-10 05:26:19 | Sint Maarten, Netherlands | ||
1177342 | 1177342 | 2020-10-22 | Colombia | Guainia | 1097 | 18 | 1047 | 32 | 2.5854 | -68.5247 | 2020-10-23 04:24:46 | Guainia, Colombia | ||
1354108 | 1354108 | 2020-09-03 | Chile | Los Rios | 1155 | 15 | 1047 | 93 | -40.231 | -72.3311 | 2020-09-04 04:28:26 | Los Rios, Chile | ||
3484366 | 3484366 | 2020-08-20 | Libya | 9707 | 173 | 1047 | 8487 | 26.3351 | 17.228331 | 2020-08-21 04:27:41 | Libya | |||
3177865 | 3177865 | 2020-08-18 | Colombia | Putumayo | 2181 | 99 | 1047 | 1035 | 0.436 | -75.5277 | 2020-08-19 04:27:00 | Putumayo, Colombia | ||
837451 | 837451 | 2020-08-17 | Colombia | Boyaca | 2249 | 54 | 1047 | 1148 | 5.4545 | -73.362 | 2020-08-18 04:27:56 | Boyaca, Colombia | ||
122144 | 122144 | 2020-07-19 | Italy | Valle d'Aosta | 1196 | 146 | 1047 | 3 | 45.73750286 | 7.320149366 | 2020-07-20 05:34:40 | Valle d'Aosta, Italy | ||
3491598 | 3491598 | 2020-07-13 | Italy | Valle d'Aosta | 1196 | 146 | 1047 | 3 | 45.73750286 | 7.320149366 | 2020-07-14 04:34:46 | Valle d'Aosta, Italy | ||
3737861 | 3737861 | 2020-07-12 | Italy | Valle d'Aosta | 1196 | 146 | 1047 | 3 | 45.73750286 | 7.320149366 | 2020-07-13 04:43:04 | Valle d'Aosta, Italy | ||
3436256 | 3436256 | 2020-07-11 | Italy | Valle d'Aosta | 1196 | 146 | 1047 | 3 | 45.73750286 | 7.320149366 | 2020-07-12 04:34:30 | Valle d'Aosta, Italy | ||
2306836 | 2306836 | 2020-06-28 | Kosovo | 2169 | 37 | 1047 | 1085 | 42.602636 | 20.902977 | 2020-06-29 04:33:44 | Kosovo | |||
2040171 | 2040171 | 2020-06-27 | Kosovo | 2169 | 37 | 1047 | 1085 | 42.602636 | 20.902977 | 2020-06-28 04:34:04 | Kosovo | |||
1136452 | 1136452 | 2020-06-26 | Kosovo | 2169 | 37 | 1047 | 1085 | 42.602636 | 20.902977 | 2020-06-27 04:33:35 | Kosovo | |||
2625439 | 2625439 | 2020-06-25 | Kosovo | 2169 | 37 | 1047 | 1085 | 42.602636 | 20.902977 | 2020-06-26 04:33:43 | Kosovo | |||
2624966 | 2624966 | 2020-06-25 | Mexico | Durango | 1567 | 132 | 1047 | 388 | 24.5593 | -104.6588 | 2020-06-26 04:33:43 | Durango, Mexico | ||
2701079 | 2701079 | 2020-06-24 | Kosovo | 2169 | 37 | 1047 | 1085 | 42.602636 | 20.902977 | 2020-06-25 05:26:54 | Kosovo | |||
1522764 | 1522764 | 2020-06-23 | Kosovo | 2169 | 37 | 1047 | 1085 | 42.602636 | 20.902977 | 2020-06-24 04:33:28 | Kosovo | |||
1510958 | 1510958 | 2020-06-22 | Kosovo | 2169 | 37 | 1047 | 1085 | 42.602636 | 20.902977 | 2020-06-23 04:33:22 | Kosovo | |||
574242 | 574242 | 2020-06-06 | Russia | Tyumen Oblast | 1873 | 11 | 1047 | 815 | 58.8206488 | 70.36588370000001 | 2020-06-07 03:53:30 | Tyumen Oblast, Russia | ||
2555918 | 2555918 | 2020-06-02 | Australia | Queensland | 1059 | 6 | 1047 | 6 | -27.4698 | 153.0251 | 2020-06-03 02:33:13 | Queensland, Australia | ||
1041304 | 1041304 | 2020-05-26 | Mexico | Yucatan | 1567 | 128 | 1047 | 392 | 20.7099 | -89.0943 | 2020-05-27 02:32:31 | Yucatan, Mexico | ||
1385103 | 1385103 | 2020-04-19 | Algeria | 2629 | 375 | 1047 | 1207 | 28.0339 | 1.6596 | 2020-04-19 23:40:41 | Algeria |
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]);