johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,024 rows where country_or_region = "China" and province_or_state = "Hainan" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98233 | 98233 | 2020-08-04 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-08-05 04:34:43 | Hainan, China | ||
121826 | 121826 | 2020-07-19 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-07-20 05:34:40 | Hainan, China | ||
122512 | 122512 | 2020-11-18 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-11-19 05:25:23 | Hainan, China | ||
145781 | 145781 | 2020-08-15 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-08-16 04:27:42 | Hainan, China | ||
153790 | 153790 | 2021-01-08 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-09 05:22:18 | Hainan, China | ||
169850 | 169850 | 2021-04-16 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-17 04:20:40 | Hainan, China | ||
177144 | 177144 | 2020-07-27 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-07-28 04:58:43 | Hainan, China | ||
181846 | 181846 | 2021-02-21 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-22 05:24:21 | Hainan, China | ||
189876 | 189876 | 2021-01-11 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-12 05:22:15 | Hainan, China | ||
193876 | 193876 | 2020-08-31 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-09-01 04:28:31 | Hainan, China | ||
202064 | 202064 | 2020-12-25 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-12-26 05:22:28 | Hainan, China | ||
206063 | 206063 | 2020-08-19 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-08-20 04:27:43 | Hainan, China | ||
210048 | 210048 | 2020-10-29 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-10-30 04:24:49 | Hainan, China | ||
237048 | 237048 | 2021-01-18 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-19 05:22:15 | Hainan, China | ||
241061 | 241061 | 2021-04-02 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-03 04:20:44 | Hainan, China | ||
271963 | 271963 | 2020-11-10 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-11-11 05:25:30 | Hainan, China | ||
279989 | 279989 | 2021-02-24 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-25 05:24:57 | Hainan, China | ||
287111 | 287111 | 2020-06-15 | China | Hainan | 171 | 6 | 163 | 2 | 19.1959 | 109.7453 | 2020-06-16 04:33:09 | Hainan, China | ||
302983 | 302983 | 2020-07-01 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-07-02 04:33:46 | Hainan, China | ||
326921 | 326921 | 2020-07-20 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-07-21 04:38:46 | Hainan, China | ||
340082 | 340082 | 2021-02-03 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-04 05:22:26 | Hainan, China | ||
344084 | 344084 | 2020-09-14 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-09-15 03:22:50 | Hainan, China | ||
352102 | 352102 | 2021-03-11 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-12 05:26:50 | Hainan, China | ||
367331 | 367331 | 2020-07-16 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-07-17 04:34:50 | Hainan, China | ||
371298 | 371298 | 2020-08-08 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-08-09 04:34:54 | Hainan, China | ||
375990 | 375990 | 2020-11-06 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-11-07 05:24:52 | Hainan, China | ||
388029 | 388029 | 2021-04-04 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-05 04:20:35 | Hainan, China | ||
392043 | 392043 | 2020-11-27 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-11-28 05:25:50 | Hainan, China | ||
415275 | 415275 | 2020-07-05 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-07-06 04:33:57 | Hainan, China | ||
427145 | 427145 | 2020-09-07 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-09-08 04:28:25 | Hainan, China | ||
435163 | 435163 | 2021-01-21 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-22 05:22:10 | Hainan, China | ||
442457 | 442457 | 2020-07-26 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-07-27 04:35:02 | Hainan, China | ||
458482 | 458482 | 2020-08-07 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-08-08 04:34:53 | Hainan, China | ||
471218 | 471218 | 2021-02-19 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-20 05:22:51 | Hainan, China | ||
529837 | 529837 | 2020-07-04 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-07-05 04:33:46 | Hainan, China | ||
530512 | 530512 | 2021-02-22 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-23 05:23:41 | Hainan, China | ||
546562 | 546562 | 2020-09-12 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-09-13 04:30:52 | Hainan, China | ||
582640 | 582640 | 2020-08-13 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-08-14 04:51:19 | Hainan, China | ||
605495 | 605495 | 2021-04-09 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-10 04:20:59 | Hainan, China | ||
609497 | 609497 | 2020-08-29 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-08-30 04:28:22 | Hainan, China | ||
613495 | 613495 | 2021-02-08 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-09 05:23:30 | Hainan, China | ||
637730 | 637730 | 2021-03-31 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-01 04:27:05 | Hainan, China | ||
662108 | 662108 | 2020-08-11 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-08-12 04:27:29 | Hainan, China | ||
666087 | 666087 | 2020-09-16 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-09-17 04:22:00 | Hainan, China | ||
678120 | 678120 | 2020-11-23 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-11-24 05:27:31 | Hainan, China | ||
702211 | 702211 | 2021-03-16 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-17 05:25:07 | Hainan, China | ||
737434 | 737434 | 2020-06-12 | China | Hainan | 171 | 6 | 162 | 3 | 19.1959 | 109.7453 | 2020-06-13 03:33:14 | Hainan, China | ||
738109 | 738109 | 2020-12-02 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-12-03 05:28:22 | Hainan, China | ||
742120 | 742120 | 2021-02-20 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-21 05:24:33 | Hainan, China | ||
753436 | 753436 | 2020-08-01 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-08-02 04:34:47 | Hainan, China | ||
754110 | 754110 | 2020-10-28 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-10-29 04:24:49 | Hainan, China | ||
762122 | 762122 | 2020-10-18 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-10-19 04:24:16 | Hainan, China | ||
766128 | 766128 | 2020-12-29 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-12-30 05:22:34 | Hainan, China | ||
774155 | 774155 | 2021-01-12 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-13 05:22:15 | Hainan, China | ||
786185 | 786185 | 2020-10-15 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-10-16 04:24:01 | Hainan, China | ||
790190 | 790190 | 2021-02-04 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-05 05:22:38 | Hainan, China | ||
813385 | 813385 | 2020-09-05 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-09-06 04:28:33 | Hainan, China | ||
817375 | 817375 | 2020-10-09 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-10-10 04:23:57 | Hainan, China | ||
821378 | 821378 | 2020-11-19 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-11-20 05:26:28 | Hainan, China | ||
837421 | 837421 | 2020-08-17 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-08-18 04:27:56 | Hainan, China | ||
844691 | 844691 | 2020-07-22 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-07-23 05:15:04 | Hainan, China | ||
845378 | 845378 | 2020-12-12 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-12-13 05:27:20 | Hainan, China | ||
860485 | 860485 | 2020-12-11 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-12-12 05:26:19 | Hainan, China | ||
864578 | 864578 | 2020-11-12 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-11-13 05:25:30 | Hainan, China | ||
887250 | 887250 | 2020-07-07 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-07-08 05:33:48 | Hainan, China | ||
891928 | 891928 | 2020-11-05 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-11-06 05:24:55 | Hainan, China | ||
907985 | 907985 | 2021-01-19 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-20 05:21:54 | Hainan, China | ||
923490 | 923490 | 2020-11-26 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-11-27 05:26:53 | Hainan, China | ||
927501 | 927501 | 2020-12-21 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-12-22 05:22:33 | Hainan, China | ||
966705 | 966705 | 2020-09-29 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-09-30 04:23:33 | Hainan, China | ||
974725 | 974725 | 2021-02-06 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-07 05:23:00 | Hainan, China | ||
982755 | 982755 | 2021-04-17 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-18 04:20:41 | Hainan, China | ||
998245 | 998245 | 2021-03-01 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-02 05:23:30 | Hainan, China | ||
1005425 | 1005425 | 2020-07-09 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-07-10 04:34:24 | Hainan, China | ||
1006102 | 1006102 | 2020-12-06 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-12-07 05:26:14 | Hainan, China | ||
1010113 | 1010113 | 2020-12-30 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-12-31 05:22:49 | Hainan, China | ||
1026160 | 1026160 | 2020-10-17 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-10-18 04:24:25 | Hainan, China | ||
1034182 | 1034182 | 2020-12-15 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-12-16 05:28:04 | Hainan, China | ||
1041632 | 1041632 | 2020-10-07 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-10-08 04:23:56 | Hainan, China | ||
1045624 | 1045624 | 2020-09-30 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-10-01 04:23:42 | Hainan, China | ||
1053632 | 1053632 | 2020-10-23 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-10-24 04:24:46 | Hainan, China | ||
1061655 | 1061655 | 2021-01-04 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-05 05:21:49 | Hainan, China | ||
1089881 | 1089881 | 2021-03-03 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-04 05:24:24 | Hainan, China | ||
1093895 | 1093895 | 2021-01-20 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-21 05:22:01 | Hainan, China | ||
1105362 | 1105362 | 2020-09-02 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-09-03 04:28:22 | Hainan, China | ||
1121398 | 1121398 | 2020-09-17 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-09-18 05:05:00 | Hainan, China | ||
1136017 | 1136017 | 2020-06-26 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-06-27 04:33:35 | Hainan, China | ||
1136692 | 1136692 | 2021-01-01 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-02 05:22:33 | Hainan, China | ||
1152928 | 1152928 | 2021-02-18 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-19 05:24:16 | Hainan, China | ||
1172992 | 1172992 | 2020-09-10 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-09-11 04:46:23 | Hainan, China | ||
1177302 | 1177302 | 2020-10-22 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-10-23 04:24:46 | Hainan, China | ||
1195785 | 1195785 | 2020-06-17 | China | Hainan | 171 | 6 | 163 | 2 | 19.1959 | 109.7453 | 2020-06-18 04:33:18 | Hainan, China | ||
1203613 | 1203613 | 2021-03-22 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-23 05:26:18 | Hainan, China | ||
1219374 | 1219374 | 2021-03-27 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-28 05:28:10 | Hainan, China | ||
1243566 | 1243566 | 2020-09-08 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-09-09 04:28:48 | Hainan, China | ||
1289812 | 1289812 | 2021-03-29 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-30 04:26:23 | Hainan, China | ||
1301858 | 1301858 | 2021-04-01 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-02 04:20:36 | Hainan, China | ||
1338082 | 1338082 | 2021-02-15 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-16 05:24:38 | Hainan, China | ||
1350126 | 1350126 | 2020-11-24 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-11-25 05:27:20 | Hainan, China | ||
1354125 | 1354125 | 2020-09-03 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2020-09-04 04:28:26 | Hainan, China |
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]);