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 = "Hong Kong" sorted by province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2020-04-27 2
- 2022-04-13 2
- 2022-05-26 2
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-03 1
- 2020-04-05 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-14 1
- 2020-04-15 1
- …
province_or_state 1
- Hong Kong · 924 ✖
country_or_region 1
- China · 924 ✖
Link | rowid | day | country_or_region | province_or_state ▼ | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
392047 | 392047 | 2020-11-27 | China | Hong Kong | 6039 | 108 | 5313 | 618 | 22.3 | 114.2 | 2020-11-28 05:25:50 | Hong Kong, China | ||
396059 | 396059 | 2022-10-07 | China | Hong Kong | 1792024 | 10202 | 0 | 22.3 | 114.2 | 2022-10-08 04:22:56 | Hong Kong, China | |||
400074 | 400074 | 2021-06-29 | China | Hong Kong | 11921 | 211 | 11628 | 82 | 22.3 | 114.2 | 2021-06-30 04:21:41 | Hong Kong, China | ||
404088 | 404088 | 2021-12-07 | China | Hong Kong | 12471 | 213 | 0 | 22.3 | 114.2 | 2021-12-08 04:22:46 | Hong Kong, China | |||
408104 | 408104 | 2021-07-28 | China | Hong Kong | 11980 | 212 | 11707 | 61 | 22.3 | 114.2 | 2021-07-29 04:21:33 | Hong Kong, China | ||
415287 | 415287 | 2020-07-05 | China | Hong Kong | 1268 | 7 | 1156 | 105 | 22.3 | 114.2 | 2020-07-06 04:33:57 | Hong Kong, China | ||
418733 | 418733 | 2020-04-18 | China | Hong Kong | 1023 | 4 | 568 | 452 | 22.3 | 114.2 | 2020-04-18 15:25:38 | Hong Kong, China | ||
419130 | 419130 | 2022-09-18 | China | Hong Kong | 1707495 | 9891 | 0 | 22.3 | 114.2 | 2022-09-19 04:21:49 | Hong Kong, China | |||
423145 | 423145 | 2021-10-10 | China | Hong Kong | 12261 | 213 | 0 | 22.3 | 114.2 | 2021-10-11 04:21:31 | Hong Kong, China | |||
427149 | 427149 | 2020-09-07 | China | Hong Kong | 4889 | 98 | 4524 | 267 | 22.3 | 114.2 | 2020-09-08 04:28:25 | Hong Kong, China | ||
431152 | 431152 | 2022-11-03 | China | Hong Kong | 1933080 | 10428 | 0 | 22.3 | 114.2 | 2022-11-04 04:22:11 | Hong Kong, China | |||
435167 | 435167 | 2021-01-21 | China | Hong Kong | 9867 | 167 | 8865 | 895 | 22.3 | 114.2 | 2021-01-22 05:22:10 | Hong Kong, China | ||
442469 | 442469 | 2020-07-26 | China | Hong Kong | 2633 | 18 | 1495 | 1120 | 22.3 | 114.2 | 2020-07-27 04:35:02 | Hong Kong, China | ||
443149 | 443149 | 2021-10-20 | China | Hong Kong | 12305 | 213 | 0 | 22.3 | 114.2 | 2021-10-21 04:21:18 | Hong Kong, China | |||
447165 | 447165 | 2021-11-17 | China | Hong Kong | 12391 | 213 | 0 | 22.3 | 114.2 | 2021-11-18 04:21:33 | Hong Kong, China | |||
451182 | 451182 | 2022-12-21 | China | Hong Kong | 2402238 | 11334 | 0 | 22.3 | 114.2 | 2022-12-22 04:20:56 | Hong Kong, China | |||
458494 | 458494 | 2020-08-07 | China | Hong Kong | 3938 | 46 | 2620 | 1271 | 22.3 | 114.2 | 2020-08-08 04:34:53 | Hong Kong, China | ||
459174 | 459174 | 2022-02-02 | China | Hong Kong | 14442 | 213 | 0 | 22.3 | 114.2 | 2022-02-03 04:21:21 | Hong Kong, China | |||
463191 | 463191 | 2022-05-02 | China | Hong Kong | 1204793 | 9318 | 0 | 22.3 | 114.2 | 2022-05-03 04:21:00 | Hong Kong, China | |||
467206 | 467206 | 2021-10-07 | China | Hong Kong | 12251 | 213 | 0 | 22.3 | 114.2 | 2021-10-08 04:21:25 | Hong Kong, China | |||
471222 | 471222 | 2021-02-19 | China | Hong Kong | 10833 | 197 | 10329 | 307 | 22.3 | 114.2 | 2021-02-20 05:22:51 | Hong Kong, China | ||
475237 | 475237 | 2022-06-26 | China | Hong Kong | 1237877 | 9398 | 0 | 22.3 | 114.2 | 2022-06-27 04:21:00 | Hong Kong, China | |||
479385 | 479385 | 2022-11-08 | China | Hong Kong | 1957542 | 10479 | 0 | 22.3 | 114.2 | 2022-11-09 04:21:22 | Hong Kong, China | |||
483400 | 483400 | 2021-07-19 | China | Hong Kong | 11958 | 212 | 11686 | 60 | 22.3 | 114.2 | 2021-07-20 04:21:48 | Hong Kong, China | ||
487415 | 487415 | 2022-11-25 | China | Hong Kong | 2077188 | 10663 | 0 | 22.3 | 114.2 | 2022-11-26 04:21:11 | Hong Kong, China | |||
491430 | 491430 | 2021-10-14 | China | Hong Kong | 12276 | 213 | 0 | 22.3 | 114.2 | 2021-10-15 04:21:26 | Hong Kong, China | |||
495446 | 495446 | 2021-11-06 | China | Hong Kong | 12367 | 213 | 0 | 22.3 | 114.2 | 2021-11-07 04:21:53 | Hong Kong, China | |||
499463 | 499463 | 2022-04-02 | China | Hong Kong | 1167713 | 8061 | 0 | 22.3 | 114.2 | 2022-04-03 04:20:48 | Hong Kong, China | |||
503479 | 503479 | 2022-12-17 | China | Hong Kong | 2323123 | 11148 | 0 | 22.3 | 114.2 | 2022-12-18 04:21:03 | Hong Kong, China | |||
507494 | 507494 | 2021-08-14 | China | Hong Kong | 12032 | 212 | 0 | 22.3 | 114.2 | 2021-08-15 04:21:41 | Hong Kong, China | |||
511508 | 511508 | 2021-08-19 | China | Hong Kong | 12047 | 212 | 0 | 22.3 | 114.2 | 2021-08-20 04:21:33 | Hong Kong, China | |||
515523 | 515523 | 2022-10-15 | China | Hong Kong | 1832284 | 10268 | 0 | 22.3 | 114.2 | 2022-10-16 04:22:39 | Hong Kong, China | |||
522271 | 522271 | 2020-04-21 | China | Hong Kong | 1029 | 4 | 650 | 375 | 22.3 | 114.2 | 2020-04-21 11:31:51 | Hong Kong, China | ||
522667 | 522667 | 2021-06-09 | China | Hong Kong | 11872 | 210 | 11587 | 75 | 22.3 | 114.2 | 2021-06-10 04:23:17 | Hong Kong, China | ||
529849 | 529849 | 2020-07-04 | China | Hong Kong | 1258 | 7 | 1145 | 106 | 22.3 | 114.2 | 2020-07-05 04:33:46 | Hong Kong, China | ||
530516 | 530516 | 2021-02-22 | China | Hong Kong | 10884 | 197 | 10404 | 283 | 22.3 | 114.2 | 2021-02-23 05:23:41 | Hong Kong, China | ||
534530 | 534530 | 2021-10-27 | China | Hong Kong | 12335 | 213 | 0 | 22.3 | 114.2 | 2021-10-28 04:22:08 | Hong Kong, China | |||
538547 | 538547 | 2022-10-26 | China | Hong Kong | 1891631 | 10350 | 0 | 22.3 | 114.2 | 2022-10-27 04:22:01 | Hong Kong, China | |||
542563 | 542563 | 2022-12-15 | China | Hong Kong | 2307397 | 11075 | 0 | 22.3 | 114.2 | 2022-12-16 04:21:01 | Hong Kong, China | |||
546566 | 546566 | 2020-09-12 | China | Hong Kong | 4938 | 100 | 4613 | 225 | 22.3 | 114.2 | 2020-09-13 04:30:52 | Hong Kong, China | ||
550568 | 550568 | 2021-12-08 | China | Hong Kong | 12471 | 213 | 0 | 22.3 | 114.2 | 2021-12-09 04:22:49 | Hong Kong, China | |||
554584 | 554584 | 2022-01-16 | China | Hong Kong | 13041 | 213 | 0 | 22.3 | 114.2 | 2022-01-17 04:21:08 | Hong Kong, China | |||
558601 | 558601 | 2022-06-16 | China | Hong Kong | 1222987 | 9392 | 0 | 22.3 | 114.2 | 2022-06-17 04:20:56 | Hong Kong, China | |||
562777 | 562777 | 2021-06-22 | China | Hong Kong | 11896 | 210 | 11618 | 68 | 22.3 | 114.2 | 2021-06-23 04:21:46 | Hong Kong, China | ||
566898 | 566898 | 2021-10-29 | China | Hong Kong | 12342 | 213 | 0 | 22.3 | 114.2 | 2021-10-30 04:22:03 | Hong Kong, China | |||
573982 | 573982 | 2020-06-06 | China | Hong Kong | 1105 | 4 | 1048 | 53 | 22.3 | 114.2 | 2020-06-07 03:53:30 | Hong Kong, China | ||
574627 | 574627 | 2022-02-25 | China | Hong Kong | 94056 | 497 | 0 | 22.3 | 114.2 | 2022-02-26 04:21:12 | Hong Kong, China | |||
578642 | 578642 | 2021-07-13 | China | Hong Kong | 11952 | 212 | 11665 | 75 | 22.3 | 114.2 | 2021-07-14 04:21:35 | Hong Kong, China | ||
582644 | 582644 | 2020-08-13 | China | Hong Kong | 4312 | 65 | 3295 | 951 | 22.3 | 114.2 | 2020-08-14 04:51:19 | Hong Kong, China | ||
589043 | 589043 | 2020-04-05 | China | Hong Kong | 882 | 4 | 206 | 680 | 22.3 | 114.2 | 2020-04-05 09:23:04 | Hong Kong, China | ||
589438 | 589438 | 2021-08-08 | China | Hong Kong | 12013 | 212 | 0 | 22.3 | 114.2 | 2021-08-09 04:21:24 | Hong Kong, China | |||
593453 | 593453 | 2022-07-01 | China | Hong Kong | 1248115 | 9402 | 0 | 22.3 | 114.2 | 2022-07-02 04:21:16 | Hong Kong, China | |||
597468 | 597468 | 2021-10-19 | China | Hong Kong | 12301 | 213 | 0 | 22.3 | 114.2 | 2021-10-20 04:21:00 | Hong Kong, China | |||
601484 | 601484 | 2021-09-23 | China | Hong Kong | 12169 | 213 | 0 | 22.3 | 114.2 | 2021-09-24 04:21:44 | Hong Kong, China | |||
605499 | 605499 | 2021-04-09 | China | Hong Kong | 11563 | 206 | 11186 | 170 | 22.3 | 114.2 | 2021-04-10 04:20:59 | Hong Kong, China | ||
609501 | 609501 | 2020-08-29 | China | Hong Kong | 4786 | 86 | 4287 | 412 | 22.3 | 114.2 | 2020-08-30 04:28:22 | Hong Kong, China | ||
613499 | 613499 | 2021-02-08 | China | Hong Kong | 10667 | 186 | 9918 | 563 | 22.3 | 114.2 | 2021-02-09 05:23:30 | Hong Kong, China | ||
617657 | 617657 | 2022-11-05 | China | Hong Kong | 1942707 | 10457 | 0 | 22.3 | 114.2 | 2022-11-06 04:21:24 | Hong Kong, China | |||
621673 | 621673 | 2022-05-22 | China | Hong Kong | 1211087 | 9372 | 0 | 22.3 | 114.2 | 2022-05-26 04:20:50 | Hong Kong, China | |||
625688 | 625688 | 2021-07-10 | China | Hong Kong | 11950 | 212 | 11648 | 90 | 22.3 | 114.2 | 2021-07-11 04:21:43 | Hong Kong, China | ||
629703 | 629703 | 2022-07-12 | China | Hong Kong | 1276686 | 9420 | 0 | 22.3 | 114.2 | 2022-07-13 04:20:58 | Hong Kong, China | |||
633718 | 633718 | 2021-10-13 | China | Hong Kong | 12275 | 213 | 0 | 22.3 | 114.2 | 2021-10-14 04:21:29 | Hong Kong, China | |||
637734 | 637734 | 2021-03-31 | China | Hong Kong | 11467 | 205 | 11095 | 167 | 22.3 | 114.2 | 2021-04-01 04:27:05 | Hong Kong, China | ||
641748 | 641748 | 2021-09-07 | China | Hong Kong | 12129 | 212 | 0 | 22.3 | 114.2 | 2021-09-08 04:21:31 | Hong Kong, China | |||
645762 | 645762 | 2021-05-05 | China | Hong Kong | 11796 | 210 | 11462 | 124 | 22.3 | 114.2 | 2021-05-06 04:20:38 | Hong Kong, China | ||
649776 | 649776 | 2021-08-09 | China | Hong Kong | 12015 | 212 | 0 | 22.3 | 114.2 | 2021-08-10 04:21:27 | Hong Kong, China | |||
653790 | 653790 | 2021-10-22 | China | Hong Kong | 12313 | 213 | 0 | 22.3 | 114.2 | 2021-10-23 04:21:32 | Hong Kong, China | |||
658109 | 658109 | 2022-05-13 | China | Hong Kong | 1207963 | 9359 | 0 | 22.3 | 114.2 | 2022-05-14 04:20:48 | Hong Kong, China | |||
662112 | 662112 | 2020-08-11 | China | Hong Kong | 4181 | 58 | 3052 | 1070 | 22.3 | 114.2 | 2020-08-12 04:27:29 | Hong Kong, China | ||
666091 | 666091 | 2020-09-16 | China | Hong Kong | 4984 | 102 | 4663 | 219 | 22.3 | 114.2 | 2020-09-17 04:22:00 | Hong Kong, China | ||
670094 | 670094 | 2022-07-21 | China | Hong Kong | 1309208 | 9448 | 0 | 22.3 | 114.2 | 2022-07-22 04:21:15 | Hong Kong, China | |||
674110 | 674110 | 2022-07-30 | China | Hong Kong | 1349360 | 9502 | 0 | 22.3 | 114.2 | 2022-07-31 04:21:02 | Hong Kong, China | |||
678124 | 678124 | 2020-11-23 | China | Hong Kong | 5701 | 108 | 5267 | 326 | 22.3 | 114.2 | 2020-11-24 05:27:31 | Hong Kong, China | ||
682135 | 682135 | 2021-10-24 | China | Hong Kong | 12323 | 213 | 0 | 22.3 | 114.2 | 2021-10-25 04:22:31 | Hong Kong, China | |||
686151 | 686151 | 2021-11-13 | China | Hong Kong | 12380 | 213 | 0 | 22.3 | 114.2 | 2021-11-14 04:21:31 | Hong Kong, China | |||
690168 | 690168 | 2022-12-23 | China | Hong Kong | 2442195 | 11373 | 0 | 22.3 | 114.2 | 2022-12-24 04:21:02 | Hong Kong, China | |||
694184 | 694184 | 2022-03-17 | China | Hong Kong | 996862 | 5136 | 0 | 22.3 | 114.2 | 2022-03-18 04:20:55 | Hong Kong, China | |||
698199 | 698199 | 2021-11-04 | China | Hong Kong | 12359 | 213 | 0 | 22.3 | 114.2 | 2021-11-05 04:21:54 | Hong Kong, China | |||
702215 | 702215 | 2021-03-16 | China | Hong Kong | 11329 | 203 | 10786 | 340 | 22.3 | 114.2 | 2021-03-17 05:25:07 | Hong Kong, China | ||
706229 | 706229 | 2021-09-29 | China | Hong Kong | 12214 | 213 | 0 | 22.3 | 114.2 | 2021-09-30 04:21:20 | Hong Kong, China | |||
710245 | 710245 | 2022-11-01 | China | Hong Kong | 1923126 | 10410 | 0 | 22.3 | 114.2 | 2022-11-02 04:22:09 | Hong Kong, China | |||
714260 | 714260 | 2021-11-12 | China | Hong Kong | 12378 | 213 | 0 | 22.3 | 114.2 | 2021-11-13 04:21:38 | Hong Kong, China | |||
718277 | 718277 | 2022-12-04 | China | Hong Kong | 2157976 | 10806 | 0 | 22.3 | 114.2 | 2022-12-05 04:20:58 | Hong Kong, China | |||
722292 | 722292 | 2021-11-20 | China | Hong Kong | 12399 | 213 | 0 | 22.3 | 114.2 | 2021-11-21 04:22:13 | Hong Kong, China | |||
726308 | 726308 | 2021-05-22 | China | Hong Kong | 11830 | 210 | 11550 | 70 | 22.3 | 114.2 | 2021-05-23 04:20:51 | Hong Kong, China | ||
730322 | 730322 | 2021-12-27 | China | Hong Kong | 12598 | 213 | 0 | 22.3 | 114.2 | 2021-12-28 04:21:47 | Hong Kong, China | |||
737446 | 737446 | 2020-06-12 | China | Hong Kong | 1108 | 4 | 1060 | 44 | 22.3 | 114.2 | 2020-06-13 03:33:14 | Hong Kong, China | ||
738113 | 738113 | 2020-12-02 | China | Hong Kong | 6499 | 110 | 5394 | 995 | 22.3 | 114.2 | 2020-12-03 05:28:22 | Hong Kong, China | ||
742124 | 742124 | 2021-02-20 | China | Hong Kong | 10848 | 197 | 10362 | 289 | 22.3 | 114.2 | 2021-02-21 05:24:33 | Hong Kong, China | ||
746139 | 746139 | 2022-04-23 | China | Hong Kong | 1201431 | 9236 | 0 | 22.3 | 114.2 | 2022-04-24 04:20:56 | Hong Kong, China | |||
753448 | 753448 | 2020-08-01 | China | Hong Kong | 3396 | 31 | 1858 | 1505 | 22.3 | 114.2 | 2020-08-02 04:34:47 | Hong Kong, China | ||
754114 | 754114 | 2020-10-28 | China | Hong Kong | 5310 | 105 | 5063 | 142 | 22.3 | 114.2 | 2020-10-29 04:24:49 | Hong Kong, China | ||
758122 | 758122 | 2021-11-26 | China | Hong Kong | 12421 | 213 | 0 | 22.3 | 114.2 | 2021-11-27 04:22:45 | Hong Kong, China | |||
762126 | 762126 | 2020-10-18 | China | Hong Kong | 5241 | 105 | 4973 | 163 | 22.3 | 114.2 | 2020-10-19 04:24:16 | Hong Kong, China | ||
766132 | 766132 | 2020-12-29 | China | Hong Kong | 8724 | 143 | 7616 | 965 | 22.3 | 114.2 | 2020-12-30 05:22:34 | Hong Kong, China | ||
770143 | 770143 | 2021-10-23 | China | Hong Kong | 12319 | 213 | 0 | 22.3 | 114.2 | 2021-10-24 04:21:22 | Hong Kong, China | |||
774159 | 774159 | 2021-01-12 | China | Hong Kong | 9343 | 159 | 8524 | 659 | 22.3 | 114.2 | 2021-01-13 05:22:15 | Hong Kong, China | ||
778171 | 778171 | 2021-07-08 | China | Hong Kong | 11948 | 212 | 11648 | 88 | 22.3 | 114.2 | 2021-07-09 04:21:21 | Hong Kong, China | ||
782185 | 782185 | 2021-12-13 | China | Hong Kong | 12490 | 213 | 0 | 22.3 | 114.2 | 2021-12-14 04:22:38 | Hong Kong, China | |||
786189 | 786189 | 2020-10-15 | China | Hong Kong | 5213 | 105 | 4943 | 165 | 22.3 | 114.2 | 2020-10-16 04:24:01 | Hong Kong, 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]);