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 active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3777716 | 3777716 | 2020-12-27 | China | Hong Kong | 8610 | 136 | 7474 | 999 | 22.3 | 114.2 | 2020-12-28 05:22:06 | 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 | ||
3531263 | 3531263 | 2020-08-12 | China | Hong Kong | 4243 | 63 | 3189 | 991 | 22.3 | 114.2 | 2020-08-13 04:29:15 | Hong Kong, China | ||
2004471 | 2004471 | 2021-05-12 | China | Hong Kong | 11814 | 210 | 11505 | 99 | 22.3 | 114.2 | 2021-05-13 04:20:51 | Hong Kong, China | ||
3954302 | 3954302 | 2021-05-11 | China | Hong Kong | 11812 | 210 | 11503 | 99 | 22.3 | 114.2 | 2021-05-12 04:21:29 | Hong Kong, China | ||
1136029 | 1136029 | 2020-06-26 | China | Hong Kong | 1196 | 7 | 1091 | 98 | 22.3 | 114.2 | 2020-06-27 04:33:35 | Hong Kong, China | ||
2625016 | 2625016 | 2020-06-25 | China | Hong Kong | 1193 | 7 | 1088 | 98 | 22.3 | 114.2 | 2020-06-26 04:33:43 | 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 | ||
3054001 | 3054001 | 2021-05-13 | China | Hong Kong | 11817 | 210 | 11511 | 96 | 22.3 | 114.2 | 2021-05-14 04:20:41 | Hong Kong, China | ||
3295588 | 3295588 | 2020-05-07 | China | Hong Kong | 1044 | 4 | 944 | 96 | 22.3 | 114.2 | 2020-05-08 02:32:32 | 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 | ||
2039748 | 2039748 | 2020-06-27 | China | Hong Kong | 1197 | 7 | 1095 | 95 | 22.3 | 114.2 | 2020-06-28 04:34:04 | Hong Kong, China | ||
2563683 | 2563683 | 2020-07-24 | China | Hong Kong | 2372 | 16 | 1407 | 949 | 22.3 | 114.2 | 2020-07-25 04:47:39 | Hong Kong, China | ||
12151 | 12151 | 2021-01-26 | China | Hong Kong | 10222 | 173 | 9101 | 948 | 22.3 | 114.2 | 2021-01-27 05:23:41 | Hong Kong, China | ||
3153416 | 3153416 | 2021-01-27 | China | Hong Kong | 10282 | 174 | 9162 | 945 | 22.3 | 114.2 | 2021-01-28 05:22:24 | Hong Kong, China | ||
1164978 | 1164978 | 2021-07-04 | China | Hong Kong | 11942 | 211 | 11637 | 94 | 22.3 | 114.2 | 2021-07-05 04:21:28 | Hong Kong, China | ||
1495412 | 1495412 | 2021-07-03 | China | Hong Kong | 11939 | 211 | 11634 | 94 | 22.3 | 114.2 | 2021-07-04 04:21:38 | Hong Kong, China | ||
2071727 | 2071727 | 2021-07-02 | China | Hong Kong | 11938 | 211 | 11633 | 94 | 22.3 | 114.2 | 2021-07-03 04:21:37 | Hong Kong, China | ||
2567475 | 2567475 | 2021-01-25 | China | Hong Kong | 10158 | 171 | 9056 | 931 | 22.3 | 114.2 | 2021-01-26 05:22:02 | Hong Kong, China | ||
1932247 | 1932247 | 2021-07-05 | China | Hong Kong | 11943 | 212 | 11638 | 93 | 22.3 | 114.2 | 2021-07-06 04:21:32 | Hong Kong, China | ||
2537207 | 2537207 | 2020-12-01 | China | Hong Kong | 6396 | 109 | 5361 | 926 | 22.3 | 114.2 | 2020-12-02 05:27:41 | Hong Kong, China | ||
1081735 | 1081735 | 2021-05-14 | China | Hong Kong | 11818 | 210 | 11516 | 92 | 22.3 | 114.2 | 2021-05-15 04:20:58 | Hong Kong, China | ||
2632850 | 2632850 | 2020-06-29 | China | Hong Kong | 1203 | 7 | 1105 | 91 | 22.3 | 114.2 | 2020-06-30 04:33:48 | Hong Kong, China | ||
2974373 | 2974373 | 2020-06-30 | China | Hong Kong | 1205 | 7 | 1107 | 91 | 22.3 | 114.2 | 2020-07-01 04:33:52 | Hong Kong, China | ||
1010117 | 1010117 | 2020-12-30 | China | Hong Kong | 8778 | 146 | 7722 | 909 | 22.3 | 114.2 | 2020-12-31 05:22:49 | Hong Kong, China | ||
2481781 | 2481781 | 2021-01-28 | China | Hong Kong | 10321 | 177 | 9239 | 905 | 22.3 | 114.2 | 2021-01-29 05:22:23 | Hong Kong, China | ||
1612060 | 1612060 | 2020-08-14 | China | Hong Kong | 4360 | 66 | 3392 | 901 | 22.3 | 114.2 | 2020-08-15 04:27:31 | 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 | ||
1440393 | 1440393 | 2021-07-07 | China | Hong Kong | 11945 | 212 | 11643 | 90 | 22.3 | 114.2 | 2021-07-08 04:21:26 | Hong Kong, China | ||
2693498 | 2693498 | 2021-07-06 | China | Hong Kong | 11944 | 212 | 11642 | 90 | 22.3 | 114.2 | 2021-07-07 04:21:20 | 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 | ||
1896965 | 1896965 | 2021-01-29 | China | Hong Kong | 10371 | 178 | 9302 | 891 | 22.3 | 114.2 | 2021-01-30 05:22:49 | Hong Kong, China | ||
829407 | 829407 | 2021-07-09 | China | Hong Kong | 11949 | 212 | 11648 | 89 | 22.3 | 114.2 | 2021-07-10 04:21:25 | Hong Kong, China | ||
1872766 | 1872766 | 2021-05-15 | China | Hong Kong | 11821 | 210 | 11522 | 89 | 22.3 | 114.2 | 2021-05-16 04:20:49 | Hong Kong, China | ||
2939136 | 2939136 | 2021-05-16 | China | Hong Kong | 11824 | 210 | 11525 | 89 | 22.3 | 114.2 | 2021-05-17 04:20:34 | Hong Kong, China | ||
3695302 | 3695302 | 2020-12-31 | China | Hong Kong | 8846 | 148 | 7813 | 885 | 22.3 | 114.2 | 2021-01-01 05:23:07 | Hong Kong, China | ||
1759107 | 1759107 | 2021-01-24 | China | Hong Kong | 10085 | 169 | 9034 | 882 | 22.3 | 114.2 | 2021-01-25 05:22:16 | 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 | ||
1522341 | 1522341 | 2020-06-23 | China | Hong Kong | 1177 | 6 | 1083 | 88 | 22.3 | 114.2 | 2020-06-24 04:33:28 | Hong Kong, China | ||
2306413 | 2306413 | 2020-06-28 | China | Hong Kong | 1199 | 7 | 1104 | 88 | 22.3 | 114.2 | 2020-06-29 04:33:44 | Hong Kong, China | ||
2700656 | 2700656 | 2020-06-24 | China | Hong Kong | 1179 | 6 | 1086 | 87 | 22.3 | 114.2 | 2020-06-25 05:26:54 | Hong Kong, China | ||
1555783 | 1555783 | 2020-08-16 | China | Hong Kong | 4480 | 69 | 3549 | 862 | 22.3 | 114.2 | 2020-08-17 04:27:20 | Hong Kong, China | ||
1583976 | 1583976 | 2020-11-30 | China | Hong Kong | 6314 | 109 | 5344 | 861 | 22.3 | 114.2 | 2020-12-01 05:26:18 | Hong Kong, China | ||
2211478 | 2211478 | 2021-01-30 | China | Hong Kong | 10399 | 178 | 9362 | 858 | 22.3 | 114.2 | 2021-01-31 05:22:42 | Hong Kong, China | ||
837425 | 837425 | 2020-08-17 | China | Hong Kong | 4524 | 69 | 3599 | 856 | 22.3 | 114.2 | 2020-08-18 04:27:56 | Hong Kong, China | ||
61902 | 61902 | 2020-07-23 | China | Hong Kong | 2249 | 15 | 1379 | 855 | 22.3 | 114.2 | 2020-07-24 05:30:40 | Hong Kong, China | ||
2764743 | 2764743 | 2021-07-01 | China | Hong Kong | 11927 | 211 | 11631 | 85 | 22.3 | 114.2 | 2021-07-02 04:21:47 | Hong Kong, China | ||
145785 | 145785 | 2020-08-15 | China | Hong Kong | 4406 | 68 | 3488 | 849 | 22.3 | 114.2 | 2020-08-16 04:27:42 | Hong Kong, China | ||
1459570 | 1459570 | 2021-01-31 | China | Hong Kong | 10452 | 181 | 9423 | 848 | 22.3 | 114.2 | 2021-02-01 05:22:53 | Hong Kong, China | ||
2426714 | 2426714 | 2021-01-23 | China | Hong Kong | 10009 | 168 | 8998 | 843 | 22.3 | 114.2 | 2021-01-24 05:22:35 | Hong Kong, China | ||
3125317 | 3125317 | 2021-06-28 | China | Hong Kong | 11920 | 211 | 11626 | 84 | 22.3 | 114.2 | 2021-06-29 04:21:28 | Hong Kong, China | ||
3574406 | 3574406 | 2021-05-17 | China | Hong Kong | 11825 | 210 | 11531 | 84 | 22.3 | 114.2 | 2021-05-18 04:20:33 | Hong Kong, China | ||
3659404 | 3659404 | 2021-07-11 | China | Hong Kong | 11951 | 212 | 11655 | 84 | 22.3 | 114.2 | 2021-07-12 04:21:34 | Hong Kong, China | ||
1676282 | 1676282 | 2021-02-01 | China | Hong Kong | 10486 | 182 | 9474 | 830 | 22.3 | 114.2 | 2021-02-02 05:22:49 | Hong Kong, China | ||
1136696 | 1136696 | 2021-01-01 | China | Hong Kong | 8888 | 149 | 7912 | 828 | 22.3 | 114.2 | 2021-01-02 05:22:33 | 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 | ||
1892951 | 1892951 | 2021-06-30 | China | Hong Kong | 11923 | 211 | 11630 | 82 | 22.3 | 114.2 | 2021-07-01 04:21:19 | Hong Kong, China | ||
2589812 | 2589812 | 2021-06-27 | China | Hong Kong | 11917 | 211 | 11625 | 82 | 22.3 | 114.2 | 2021-06-28 04:21:29 | Hong Kong, China | ||
2466616 | 2466616 | 2021-01-22 | China | Hong Kong | 9928 | 167 | 8948 | 812 | 22.3 | 114.2 | 2021-01-23 05:22:03 | Hong Kong, China | ||
3177821 | 3177821 | 2020-08-18 | China | Hong Kong | 4560 | 70 | 3677 | 812 | 22.3 | 114.2 | 2020-08-19 04:27:00 | Hong Kong, China | ||
2390581 | 2390581 | 2021-05-18 | China | Hong Kong | 11826 | 210 | 11535 | 81 | 22.3 | 114.2 | 2021-05-19 04:20:42 | Hong Kong, China | ||
1061659 | 1061659 | 2021-01-04 | China | Hong Kong | 9017 | 151 | 8055 | 809 | 22.3 | 114.2 | 2021-01-05 05:21:49 | Hong Kong, China | ||
2227332 | 2227332 | 2021-01-02 | China | Hong Kong | 8923 | 150 | 7968 | 805 | 22.3 | 114.2 | 2021-01-03 05:22:52 | Hong Kong, China | ||
3230262 | 3230262 | 2021-01-03 | China | Hong Kong | 8964 | 150 | 8011 | 803 | 22.3 | 114.2 | 2021-01-04 05:22:02 | Hong Kong, China | ||
114145 | 114145 | 2020-05-08 | China | Hong Kong | 1044 | 4 | 960 | 80 | 22.3 | 114.2 | 2020-05-09 02:32:35 | Hong Kong, China | ||
3566379 | 3566379 | 2020-11-29 | China | Hong Kong | 6238 | 109 | 5340 | 789 | 22.3 | 114.2 | 2020-11-30 05:26:13 | Hong Kong, China | ||
1510535 | 1510535 | 2020-06-22 | China | Hong Kong | 1161 | 5 | 1078 | 78 | 22.3 | 114.2 | 2020-06-23 04:33:22 | Hong Kong, China | ||
2255543 | 2255543 | 2021-05-19 | China | Hong Kong | 11827 | 210 | 11539 | 78 | 22.3 | 114.2 | 2021-05-20 04:21:05 | Hong Kong, China | ||
1684312 | 1684312 | 2021-02-02 | China | Hong Kong | 10511 | 183 | 9549 | 778 | 22.3 | 114.2 | 2021-02-03 05:22:52 | Hong Kong, China | ||
844703 | 844703 | 2020-07-22 | China | Hong Kong | 2131 | 14 | 1344 | 773 | 22.3 | 114.2 | 2020-07-23 05:15:04 | Hong Kong, China | ||
1712135 | 1712135 | 2021-06-25 | China | Hong Kong | 11909 | 211 | 11621 | 77 | 22.3 | 114.2 | 2021-06-26 04:21:43 | Hong Kong, China | ||
3740891 | 3740891 | 2021-07-12 | China | Hong Kong | 11951 | 212 | 11662 | 77 | 22.3 | 114.2 | 2021-07-13 04:21:18 | Hong Kong, China | ||
3958316 | 3958316 | 2021-06-26 | China | Hong Kong | 11911 | 211 | 11624 | 77 | 22.3 | 114.2 | 2021-06-27 04:21:39 | Hong Kong, China | ||
3034114 | 3034114 | 2021-01-05 | China | Hong Kong | 9049 | 153 | 8127 | 769 | 22.3 | 114.2 | 2021-01-06 05:22:16 | Hong Kong, China | ||
1093899 | 1093899 | 2021-01-20 | China | Hong Kong | 9797 | 166 | 8865 | 766 | 22.3 | 114.2 | 2021-01-21 05:22:01 | Hong Kong, China | ||
1913022 | 1913022 | 2021-05-20 | China | Hong Kong | 11828 | 210 | 11542 | 76 | 22.3 | 114.2 | 2021-05-21 04:20:43 | 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 | ||
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 | ||
2295260 | 2295260 | 2021-06-24 | China | Hong Kong | 11905 | 210 | 11621 | 74 | 22.3 | 114.2 | 2021-06-25 04:21:33 | Hong Kong, China | ||
2716782 | 2716782 | 2021-06-10 | China | Hong Kong | 11874 | 210 | 11590 | 74 | 22.3 | 114.2 | 2021-06-11 04:23:20 | Hong Kong, China | ||
3472107 | 3472107 | 2021-06-08 | China | Hong Kong | 11868 | 210 | 11584 | 74 | 22.3 | 114.2 | 2021-06-09 04:23:31 | Hong Kong, China | ||
3631767 | 3631767 | 2021-07-14 | China | Hong Kong | 11955 | 212 | 11669 | 74 | 22.3 | 114.2 | 2021-07-15 04:21:48 | Hong Kong, China | ||
206067 | 206067 | 2020-08-19 | China | Hong Kong | 4586 | 72 | 3779 | 735 | 22.3 | 114.2 | 2020-08-20 04:27:43 | Hong Kong, China | ||
2899096 | 2899096 | 2020-05-09 | China | Hong Kong | 1044 | 4 | 967 | 73 | 22.3 | 114.2 | 2020-05-10 02:32:30 | Hong Kong, China | ||
907989 | 907989 | 2021-01-19 | China | Hong Kong | 9720 | 164 | 8828 | 727 | 22.3 | 114.2 | 2021-01-20 05:21:54 | Hong Kong, China | ||
1736319 | 1736319 | 2021-06-12 | China | Hong Kong | 11877 | 210 | 11595 | 72 | 22.3 | 114.2 | 2021-06-13 04:22:44 | Hong Kong, China | ||
1952323 | 1952323 | 2021-05-21 | China | Hong Kong | 11829 | 210 | 11547 | 72 | 22.3 | 114.2 | 2021-05-22 04:20:45 | Hong Kong, China | ||
2864527 | 2864527 | 2021-01-06 | China | Hong Kong | 9074 | 154 | 8201 | 719 | 22.3 | 114.2 | 2021-01-07 05:22:03 | Hong Kong, China | ||
237052 | 237052 | 2021-01-18 | China | Hong Kong | 9664 | 163 | 8786 | 715 | 22.3 | 114.2 | 2021-01-19 05:22:15 | Hong Kong, China | ||
3021673 | 3021673 | 2020-04-07 | China | Hong Kong | 935 | 4 | 216 | 715 | 22.3 | 114.2 | 2020-04-07 09:08:12 | Hong Kong, China | ||
340086 | 340086 | 2021-02-03 | China | Hong Kong | 10530 | 185 | 9633 | 712 | 22.3 | 114.2 | 2021-02-04 05:22:26 | Hong Kong, China | ||
3137361 | 3137361 | 2021-07-23 | China | Hong Kong | 11973 | 212 | 11690 | 71 | 22.3 | 114.2 | 2021-07-24 00:21:36 | Hong Kong, China | ||
3145391 | 3145391 | 2021-06-07 | China | Hong Kong | 11865 | 210 | 11584 | 71 | 22.3 | 114.2 | 2021-06-08 04:22:35 | Hong Kong, China | ||
3970360 | 3970360 | 2021-06-11 | China | Hong Kong | 11874 | 210 | 11593 | 71 | 22.3 | 114.2 | 2021-06-12 04:22:22 | Hong Kong, China | ||
3484118 | 3484118 | 2020-08-20 | China | Hong Kong | 4604 | 73 | 3827 | 702 | 22.3 | 114.2 | 2020-08-21 04:27:41 | 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 | ||
3030100 | 3030100 | 2021-06-16 | China | Hong Kong | 11881 | 210 | 11601 | 70 | 22.3 | 114.2 | 2021-06-17 04:22:36 | Hong Kong, China | ||
3331340 | 3331340 | 2021-07-21 | China | Hong Kong | 11970 | 212 | 11688 | 70 | 22.3 | 114.2 | 2021-07-22 04:21:19 | Hong Kong, China | ||
2541218 | 2541218 | 2021-01-07 | China | Hong Kong | 9107 | 154 | 8258 | 695 | 22.3 | 114.2 | 2021-01-08 05:22:42 | Hong Kong, China | ||
3627355 | 3627355 | 2020-04-06 | China | Hong Kong | 914 | 4 | 216 | 694 | 22.3 | 114.2 | 4/6/20 9:37 | 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]);