⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

320 rows where country_or_region = "China" and province_or_state = "Hong Kong" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • Hong Kong · 320

country_or_region

  • China · 320
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
831904 2021-01-24 China Hong Kong     10085 169 9034 882 22.3 114.2 2021-01-25 05:22:16 Hong Kong, China
901406 2021-01-23 China Hong Kong     10009 168 8998 843 22.3 114.2 2021-01-24 05:22:35 Hong Kong, China
89491 2021-01-22 China Hong Kong     9928 168 8948 812 22.3 114.2 2021-01-23 05:22:03 Hong Kong, China
302397 2021-01-21 China Hong Kong     9928 168 8865 766 22.3 114.2 2021-01-22 05:22:10 Hong Kong, China
897428 2021-01-20 China Hong Kong     9797 166 8865 766 22.3 114.2 2021-01-21 05:22:01 Hong Kong, China
322016 2021-01-19 China Hong Kong     9720 165 8828 727 22.3 114.2 2021-01-20 05:21:54 Hong Kong, China
574002 2021-01-18 China Hong Kong     9664 163 8786 715 22.3 114.2 2021-01-19 05:22:15 Hong Kong, China
538565 2021-01-17 China Hong Kong     9557 162 8758 637 22.3 114.2 2021-01-18 05:22:34 Hong Kong, China
619353 2021-01-16 China Hong Kong     9502 162 8724 616 22.3 114.2 2021-01-17 05:22:17 Hong Kong, China
184494 2021-01-15 China Hong Kong     9452 161 8684 607 22.3 114.2 2021-01-16 05:22:40 Hong Kong, China
597186 2021-01-14 China Hong Kong     9414 161 8631 622 22.3 114.2 2021-01-15 05:22:24 Hong Kong, China
728557 2021-01-13 China Hong Kong     9385 161 8584 640 22.3 114.2 2021-01-14 05:22:32 Hong Kong, China
56913 2021-01-12 China Hong Kong     9343 160 8524 659 22.3 114.2 2021-01-13 05:22:15 Hong Kong, China
269093 2021-01-11 China Hong Kong     9283 159 8468 656 22.3 114.2 2021-01-12 05:22:15 Hong Kong, China
785064 2021-01-10 China Hong Kong     9242 158 8423 661 22.3 114.2 2021-01-11 05:21:50 Hong Kong, China
138508 2021-01-09 China Hong Kong     9211 157 8374 680 22.3 114.2 2021-01-10 05:22:12 Hong Kong, China
466324 2021-01-08 China Hong Kong     9152 155 8307 690 22.3 114.2 2021-01-09 05:22:18 Hong Kong, China
294457 2021-01-07 China Hong Kong     9107 154 8258 695 22.3 114.2 2021-01-08 05:22:42 Hong Kong, China
1057119 2021-01-06 China Hong Kong     9074 154 8201 719 22.3 114.2 2021-01-07 05:22:03 Hong Kong, China
515526 2021-01-05 China Hong Kong     9049 153 8127 769 22.3 114.2 2021-01-06 05:22:16 Hong Kong, China
992183 2021-01-04 China Hong Kong     9017 153 8055 809 22.3 114.2 2021-01-05 05:21:49 Hong Kong, China
531170 2021-01-03 China Hong Kong     8964 150 8011 803 22.3 114.2 2021-01-04 05:22:02 Hong Kong, China
454466 2021-01-02 China Hong Kong     8923 150 7968 805 22.3 114.2 2021-01-03 05:22:52 Hong Kong, China
273070 2021-01-01 China Hong Kong     8888 148 7912 828 22.3 114.2 2021-01-02 05:22:33 Hong Kong, China
550268 2020-12-31 China Hong Kong     8846 148 7813 885 22.3 114.2 2021-01-01 05:23:07 Hong Kong, China
913610 2020-12-30 China Hong Kong     8778 147 7722 909 22.3 114.2 2020-12-31 05:22:49 Hong Kong, China
74999 2020-12-29 China Hong Kong     8724 143 7616 965 22.3 114.2 2020-12-30 05:22:34 Hong Kong, China
419855 2020-12-28 China Hong Kong     8671 141 7526 1004 22.3 114.2 2020-12-29 05:22:37 Hong Kong, China
216066 2020-12-27 China Hong Kong     8610 137 7474 999 22.3 114.2 2020-12-28 05:22:06 Hong Kong, China
239104 2020-12-26 China Hong Kong     8540 136 7394 1010 22.3 114.2 2020-12-27 05:22:55 Hong Kong, China
33700 2020-12-25 China Hong Kong     8481 136 7317 1028 22.3 114.2 2020-12-26 05:22:28 Hong Kong, China
966177 2020-12-24 China Hong Kong     8424 135 7203 1086 22.3 114.2 2020-12-25 05:22:48 Hong Kong, China
18391 2020-12-23 China Hong Kong     8353 133 7112 1108 22.3 114.2 2020-12-24 05:23:04 Hong Kong, China
1045374 2020-12-22 China Hong Kong     8300 132 6995 1173 22.3 114.2 2020-12-23 05:22:03 Hong Kong, China
1003971 2020-12-21 China Hong Kong     8237 131 6910 1196 22.3 114.2 2020-12-22 05:22:33 Hong Kong, China
557984 2020-12-20 China Hong Kong     8152 130 6837 1185 22.3 114.2 2020-12-21 05:27:58 Hong Kong, China
773166 2020-12-19 China Hong Kong     8078 129 6737 1212 22.3 114.2 2020-12-20 05:27:32 Hong Kong, China
1061096 2020-12-18 China Hong Kong     7969 129 6628 1212 22.3 114.2 2020-12-19 05:27:52 Hong Kong, China
450490 2020-12-17 China Hong Kong     7899 125 6534 1240 22.3 114.2 2020-12-18 05:28:18 Hong Kong, China
909634 2020-12-16 China Hong Kong     7803 123 6439 1241 22.3 114.2 2020-12-17 05:28:12 Hong Kong, China
470376 2020-12-15 China Hong Kong     7721 123 6345 1253 22.3 114.2 2020-12-16 05:28:04 Hong Kong, China
1041398 2020-12-14 China Hong Kong     7623 120 6266 1237 22.3 114.2 2020-12-15 05:26:38 Hong Kong, China
235077 2020-12-13 China Hong Kong     7541 117 6202 1222 22.3 114.2 2020-12-14 05:26:27 Hong Kong, China
1018362 2020-12-12 China Hong Kong     7446 115 6114 1217 22.3 114.2 2020-12-13 05:27:20 Hong Kong, China
446514 2020-12-11 China Hong Kong     7377 114 5996 1267 22.3 114.2 2020-12-12 05:26:19 Hong Kong, China
660473 2020-12-10 China Hong Kong     7291 114 5900 1277 22.3 114.2 2020-12-11 05:26:59 Hong Kong, China
310635 2020-12-09 China Hong Kong     7179 114 5783 1282 22.3 114.2 2020-12-10 05:26:19 Hong Kong, China
188472 2020-12-08 China Hong Kong     7075 112 5696 1267 22.3 114.2 2020-12-09 05:28:01 Hong Kong, China
411916 2020-12-07 China Hong Kong     6975 112 5626 1237 22.3 114.2 2020-12-08 05:27:42 Hong Kong, China
1128717 2020-12-06 China Hong Kong     6897 112 5567 1218 22.3 114.2 2020-12-07 05:26:14 Hong Kong, China
890016 2020-12-05 China Hong Kong     6802 112 5511 1179 22.3 114.2 2020-12-06 05:26:18 Hong Kong, China
25764 2020-12-04 China Hong Kong     6701 112 5465 1124 22.3 114.2 2020-12-05 05:27:36 Hong Kong, China
601163 2020-12-03 China Hong Kong     6589 111 5423 1055 22.3 114.2 2020-12-04 05:27:27 Hong Kong, China
380887 2020-12-02 China Hong Kong     6499 110 5394 995 22.3 114.2 2020-12-03 05:28:22 Hong Kong, China
116641 2020-12-01 China Hong Kong     6396 109 5361 926 22.3 114.2 2020-12-02 05:27:41 Hong Kong, China
243080 2020-11-30 China Hong Kong     6314 109 5344 861 22.3 114.2 2020-12-01 05:26:18 Hong Kong, China
781088 2020-11-29 China Hong Kong     6238 109 5340 789 22.3 114.2 2020-11-30 05:26:13 Hong Kong, China
769190 2020-11-28 China Hong Kong     6123 109 5328 686 22.3 114.2 2020-11-29 05:25:55 Hong Kong, China
796790 2020-11-27 China Hong Kong     6039 108 5313 618 22.3 114.2 2020-11-28 05:25:50 Hong Kong, China
1065072 2020-11-26 China Hong Kong     5947 108 5300 539 22.3 114.2 2020-11-27 05:26:53 Hong Kong, China
519503 2020-11-25 China Hong Kong     5866 108 5295 463 22.3 114.2 2020-11-26 05:27:44 Hong Kong, China
954155 2020-11-24 China Hong Kong     5781 108 5274 399 22.3 114.2 2020-11-25 05:27:20 Hong Kong, China
835882 2020-11-23 China Hong Kong     5701 108 5267 326 22.3 114.2 2020-11-24 05:27:31 Hong Kong, China
220041 2020-11-22 China Hong Kong     5628 108 5259 261 22.3 114.2 2020-11-23 05:25:26 Hong Kong, China
765214 2020-11-21 China Hong Kong     5560 108 5248 204 22.3 114.2 2020-11-22 05:25:45 Hong Kong, China
45050 2020-11-20 China Hong Kong     5517 108 5239 170 22.3 114.2 2020-11-21 05:25:51 Hong Kong, China
376911 2020-11-19 China Hong Kong     5491 108 5233 150 22.3 114.2 2020-11-20 05:26:28 Hong Kong, China
698768 2020-11-18 China Hong Kong     5479 108 5224 147 22.3 114.2 2020-11-19 05:25:23 Hong Kong, China
1090393 2020-11-17 China Hong Kong     5470 108 5212 150 22.3 114.2 2020-11-18 05:40:31 Hong Kong, China
196404 2020-11-16 China Hong Kong     5466 108 5198 160 22.3 114.2 2020-11-17 05:25:54 Hong Kong, China
359403 2020-11-15 China Hong Kong     5458 108 5194 156 22.3 114.2 2020-11-16 05:25:57 Hong Kong, China
694718 2020-11-14 China Hong Kong     5444 108 5187 149 22.3 114.2 2020-11-15 05:26:53 Hong Kong, China
905600 2020-11-13 China Hong Kong     5436 108 5177 151 22.3 114.2 2020-11-14 05:25:37 Hong Kong, China
388501 2020-11-12 China Hong Kong     5430 108 5170 152 22.3 114.2 2020-11-13 05:25:30 Hong Kong, China
298422 2020-11-11 China Hong Kong     5407 108 5159 140 22.3 114.2 2020-11-12 05:25:55 Hong Kong, China
415880 2020-11-10 China Hong Kong     5389 108 5153 128 22.3 114.2 2020-11-11 05:25:30 Hong Kong, China
1098105 2020-11-09 China Hong Kong     5380 107 5146 127 22.3 114.2 2020-11-10 05:40:07 Hong Kong, China
10432 2020-11-08 China Hong Kong     5374 107 5144 123 22.3 114.2 2020-11-09 05:25:45 Hong Kong, China
843256 2020-11-07 China Hong Kong     5364 107 5139 118 22.3 114.2 2020-11-08 05:24:56 Hong Kong, China
250995 2020-11-06 China Hong Kong     5361 107 5131 123 22.3 114.2 2020-11-07 05:24:52 Hong Kong, China
1144031 2020-11-05 China Hong Kong     5355 107 5126 122 22.3 114.2 2020-11-06 05:24:55 Hong Kong, China
878208 2020-11-04 China Hong Kong     5348 106 5118 124 22.3 114.2 2020-11-05 06:05:03 Hong Kong, China
474340 2020-11-03 China Hong Kong     5345 105 5109 131 22.3 114.2 2020-11-04 05:25:09 Hong Kong, China
871054 2020-11-02 China Hong Kong     5336 105 5102 129 22.3 114.2 2020-11-03 06:00:16 Hong Kong, China
634031 2020-11-01 China Hong Kong     5330 105 5096 129 22.3 114.2 2020-11-02 05:25:04 Hong Kong, China
500643 2020-10-31 China Hong Kong     5323 105 5089 129 22.3 114.2 2020-11-01 04:36:19 Hong Kong, China
615380 2020-10-30 China Hong Kong     5320 105 5082 133 22.3 114.2 2020-10-31 04:24:44 Hong Kong, China
882242 2020-10-29 China Hong Kong     5313 105 5073 135 22.3 114.2 2020-10-30 04:24:49 Hong Kong, China
227962 2020-10-28 China Hong Kong     5310 105 5063 142 22.3 114.2 2020-10-29 04:24:49 Hong Kong, China
1162503 2020-10-27 China Hong Kong     5308 105 5053 150 22.3 114.2 2020-10-28 04:24:39 Hong Kong, China
337311 2020-10-26 China Hong Kong     5303 105 5050 148 22.3 114.2 2020-10-27 04:24:45 Hong Kong, China
78963 2020-10-25 China Hong Kong     5295 105 5047 143 22.3 114.2 2020-10-26 04:25:02 Hong Kong, China
41079 2020-10-24 China Hong Kong     5289 105 5041 143 22.3 114.2 2020-10-25 04:24:36 Hong Kong, China
732522 2020-10-23 China Hong Kong     5284 105 5029 150 22.3 114.2 2020-10-24 04:24:46 Hong Kong, China
940309 2020-10-22 China Hong Kong     5280 105 5019 156 22.3 114.2 2020-10-23 04:24:46 Hong Kong, China
329394 2020-10-21 China Hong Kong     5269 105 5004 160 22.3 114.2 2020-10-22 04:24:27 Hong Kong, China
29728 2020-10-20 China Hong Kong     5261 105 4996 160 22.3 114.2 2020-10-21 04:24:14 Hong Kong, China
52941 2020-10-19 China Hong Kong     5256 105 4982 169 22.3 114.2 2020-10-20 04:24:22 Hong Kong, China
936350 2020-10-18 China Hong Kong     5241 105 4973 163 22.3 114.2 2020-10-19 04:24:16 Hong Kong, China
988212 2020-10-17 China Hong Kong     5237 105 4963 169 22.3 114.2 2020-10-18 04:24:25 Hong Kong, China

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);