daily_reports (view)
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 day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-11 | China | Hong Kong | 126 | 3 | 65 | 22.3 | 114.2 | 2020-03-11T18:52:03 | ||||
2020-03-12 | China | Hong Kong | 129 | 3 | 67 | 22.3 | 114.2 | 2020-03-12T01:53:02 | ||||
2020-03-13 | China | Hong Kong | 134 | 4 | 77 | 22.3 | 114.2 | 2020-03-13T13:33:03 | ||||
2020-03-14 | China | Hong Kong | 140 | 4 | 78 | 22.3 | 114.2 | 2020-03-14T12:53:06 | ||||
2020-03-15 | China | Hong Kong | 145 | 4 | 81 | 22.3 | 114.2 | 2020-03-15T18:20:18 | ||||
2020-03-16 | China | Hong Kong | 155 | 4 | 84 | 22.3 | 114.2 | 2020-03-16T14:38:45 | ||||
2020-03-17 | China | Hong Kong | 162 | 4 | 88 | 22.3 | 114.2 | 2020-03-17T10:13:11 | ||||
2020-03-18 | China | Hong Kong | 181 | 4 | 92 | 22.3 | 114.2 | 2020-03-18T09:33:05 | ||||
2020-03-19 | China | Hong Kong | 208 | 4 | 95 | 22.3 | 114.2 | 2020-03-19T09:53:20 | ||||
2020-03-20 | China | Hong Kong | 256 | 4 | 98 | 22.3 | 114.2 | 2020-03-20T09:43:03 | ||||
2020-03-21 | China | Hong Kong | 273 | 4 | 98 | 22.3 | 114.2 | 2020-03-21T09:13:14 | ||||
2020-03-22 | China | Hong Kong | 317 | 4 | 100 | 213 | 22.3 | 114.2 | 3/22/20 9:33 | Hong Kong, China | ||
2020-03-23 | China | Hong Kong | 351 | 4 | 100 | 252 | 22.3 | 114.2 | 2020-03-23 10:06:18 | Hong Kong, China | ||
2020-03-24 | China | Hong Kong | 382 | 4 | 101 | 281 | 22.3 | 114.2 | 2020-03-24 09:09:41 | Hong Kong, China | ||
2020-03-25 | China | Hong Kong | 407 | 4 | 102 | 304 | 22.3 | 114.2 | 2020-03-25 09:10:20 | Hong Kong, China | ||
2020-03-26 | China | Hong Kong | 452 | 4 | 110 | 339 | 22.3 | 114.2 | 2020-03-26 10:05:28 | Hong Kong, China | ||
2020-03-27 | China | Hong Kong | 494 | 4 | 110 | 405 | 22.3 | 114.2 | 2020-03-27 09:27:52 | Hong Kong, China | ||
2020-03-28 | China | Hong Kong | 526 | 4 | 112 | 445 | 22.3 | 114.2 | 3/28/20 12:50 | Hong Kong, China | ||
2020-03-29 | China | Hong Kong | 577 | 4 | 112 | 525 | 22.3 | 114.2 | 3/29/20 9:40 | Hong Kong, China | ||
2020-03-30 | China | Hong Kong | 623 | 4 | 123 | 555 | 22.3 | 114.2 | 3/30/20 9:27 | Hong Kong, China | ||
2020-03-31 | China | Hong Kong | 680 | 4 | 128 | 582 | 22.3 | 114.2 | 2020-03-31 09:10:05 | Hong Kong, China | ||
2020-04-01 | China | Hong Kong | 737 | 4 | 147 | 614 | 22.3 | 114.2 | 2020-04-01 11:07:39 | Hong Kong, China | ||
2020-04-02 | China | Hong Kong | 784 | 4 | 147 | 651 | 22.3 | 114.2 | 4/2/20 8:53 | Hong Kong, China | ||
2020-04-03 | China | Hong Kong | 831 | 4 | 173 | 668 | 22.3 | 114.2 | 2020-04-03 09:35:41 | Hong Kong, China | ||
2020-04-04 | China | Hong Kong | 853 | 4 | 173 | 685 | 22.3 | 114.2 | 4/4/20 9:38 | Hong Kong, China | ||
2020-04-05 | China | Hong Kong | 882 | 4 | 206 | 680 | 22.3 | 114.2 | 2020-04-05 09:23:04 | Hong Kong, China | ||
2020-04-06 | China | Hong Kong | 914 | 4 | 216 | 694 | 22.3 | 114.2 | 4/6/20 9:37 | Hong Kong, China | ||
2020-04-07 | China | Hong Kong | 935 | 4 | 216 | 715 | 22.3 | 114.2 | 2020-04-07 09:08:12 | Hong Kong, China | ||
2020-04-08 | China | Hong Kong | 960 | 4 | 264 | 692 | 22.3 | 114.2 | 2020-04-08 09:23:07 | Hong Kong, China | ||
2020-04-09 | China | Hong Kong | 973 | 4 | 293 | 676 | 22.3 | 114.2 | 2020-04-09 09:16:48 | Hong Kong, China | ||
2020-04-10 | China | Hong Kong | 989 | 4 | 309 | 676 | 22.3 | 114.2 | 2020-04-10 10:12:56 | Hong Kong, China | ||
2020-04-11 | China | Hong Kong | 1000 | 4 | 336 | 660 | 22.3 | 114.2 | 2020-04-11 08:51:55 | Hong Kong, China | ||
2020-04-12 | China | Hong Kong | 1004 | 4 | 360 | 640 | 22.3 | 114.2 | 2020-04-12 10:22:00 | Hong Kong, China | ||
2020-04-13 | China | Hong Kong | 1009 | 4 | 360 | 645 | 22.3 | 114.2 | 2020-04-13 09:36:31 | Hong Kong, China | ||
2020-04-14 | China | Hong Kong | 1012 | 4 | 434 | 574 | 22.3 | 114.2 | 2020-04-14 10:29:41 | Hong Kong, China | ||
2020-04-15 | China | Hong Kong | 1016 | 4 | 459 | 554 | 22.3 | 114.2 | 2020-04-15 14:46:10 | Hong Kong, China | ||
2020-04-16 | China | Hong Kong | 1017 | 4 | 485 | 528 | 22.3 | 114.2 | 2020-04-16 09:30:36 | Hong Kong, China | ||
2020-04-17 | China | Hong Kong | 1021 | 4 | 533 | 484 | 22.3 | 114.2 | 2020-04-17 09:19:52 | Hong Kong, China | ||
2020-04-18 | China | Hong Kong | 1023 | 4 | 568 | 452 | 22.3 | 114.2 | 2020-04-18 15:25:38 | Hong Kong, China | ||
2020-04-19 | China | Hong Kong | 1025 | 4 | 602 | 419 | 22.3 | 114.2 | 2020-04-19 09:47:33 | Hong Kong, China | ||
2020-04-20 | China | Hong Kong | 1025 | 4 | 630 | 391 | 22.3 | 114.2 | 2020-04-20 09:59:38 | Hong Kong, China | ||
2020-04-21 | China | Hong Kong | 1029 | 4 | 650 | 375 | 22.3 | 114.2 | 2020-04-21 11:31:51 | Hong Kong, China | ||
2020-04-22 | China | Hong Kong | 1033 | 4 | 678 | 351 | 22.3 | 114.2 | 2020-04-22 11:20:17 | Hong Kong, China | ||
2020-04-23 | China | Hong Kong | 1035 | 4 | 699 | 332 | 22.3 | 114.2 | 2020-04-23 10:54:47 | Hong Kong, China | ||
2020-04-24 | China | Hong Kong | 1035 | 4 | 725 | 306 | 22.3 | 114.2 | 2020-04-24 12:45:30 | Hong Kong, China | ||
2020-04-25 | China | Hong Kong | 1037 | 4 | 753 | 280 | 22.3 | 114.2 | 2020-04-25 09:12:59 | Hong Kong, China | ||
2020-04-26 | China | Hong Kong | 1037 | 4 | 772 | 261 | 22.3 | 114.2 | 2020-04-27 00:51:44 | Hong Kong, China | ||
2020-04-27 | China | Hong Kong | 1037 | 4 | 787 | 246 | 22.3 | 114.2 | 2020-04-27 11:55:16 | Hong Kong, China | ||
2020-04-28 | China | Hong Kong | 1037 | 4 | 811 | 222 | 22.3 | 114.2 | 2020-04-29 02:32:29 | Hong Kong, China | ||
2020-04-29 | China | Hong Kong | 1037 | 4 | 830 | 203 | 22.3 | 114.2 | 2020-04-30 02:32:27 | Hong Kong, China | ||
2020-04-30 | China | Hong Kong | 1037 | 4 | 846 | 187 | 22.3 | 114.2 | 2020-05-01 02:32:28 | Hong Kong, China | ||
2020-05-01 | China | Hong Kong | 1039 | 4 | 859 | 176 | 22.3 | 114.2 | 2020-05-02 02:32:27 | Hong Kong, China | ||
2020-05-02 | China | Hong Kong | 1039 | 4 | 864 | 171 | 22.3 | 114.2 | 2020-05-03 02:32:28 | Hong Kong, China | ||
2020-05-03 | China | Hong Kong | 1039 | 4 | 879 | 156 | 22.3 | 114.2 | 2020-05-04 02:32:28 | Hong Kong, China | ||
2020-05-04 | China | Hong Kong | 1040 | 4 | 900 | 136 | 22.3 | 114.2 | 2020-05-05 02:32:34 | Hong Kong, China | ||
2020-05-05 | China | Hong Kong | 1040 | 4 | 920 | 116 | 22.3 | 114.2 | 2020-05-06 02:32:31 | Hong Kong, China | ||
2020-05-06 | China | Hong Kong | 1040 | 4 | 932 | 104 | 22.3 | 114.2 | 2020-05-07 02:32:28 | Hong Kong, China | ||
2020-05-07 | China | Hong Kong | 1044 | 4 | 944 | 96 | 22.3 | 114.2 | 2020-05-08 02:32:32 | Hong Kong, China | ||
2020-05-08 | China | Hong Kong | 1044 | 4 | 960 | 80 | 22.3 | 114.2 | 2020-05-09 02:32:35 | Hong Kong, China | ||
2020-05-09 | China | Hong Kong | 1044 | 4 | 967 | 73 | 22.3 | 114.2 | 2020-05-10 02:32:30 | Hong Kong, China | ||
2020-05-10 | China | Hong Kong | 1047 | 4 | 982 | 61 | 22.3 | 114.2 | 2020-05-11 02:32:30 | Hong Kong, China | ||
2020-05-11 | China | Hong Kong | 1047 | 4 | 985 | 58 | 22.3 | 114.2 | 2020-05-12 03:32:27 | Hong Kong, China | ||
2020-05-12 | China | Hong Kong | 1047 | 4 | 991 | 52 | 22.3 | 114.2 | 2020-05-13 03:32:26 | Hong Kong, China | ||
2020-05-13 | China | Hong Kong | 1050 | 4 | 1008 | 38 | 22.3 | 114.2 | 2020-05-14 03:32:28 | Hong Kong, China | ||
2020-05-14 | China | Hong Kong | 1051 | 4 | 1009 | 38 | 22.3 | 114.2 | 2020-05-15 02:33:02 | Hong Kong, China | ||
2020-05-15 | China | Hong Kong | 1052 | 4 | 1019 | 29 | 22.3 | 114.2 | 2020-05-16 02:32:19 | Hong Kong, China | ||
2020-05-16 | China | Hong Kong | 1052 | 4 | 1022 | 26 | 22.3 | 114.2 | 2020-05-17 02:32:32 | Hong Kong, China | ||
2020-05-17 | China | Hong Kong | 1055 | 4 | 1024 | 27 | 22.3 | 114.2 | 2020-05-18 02:32:21 | Hong Kong, China | ||
2020-05-18 | China | Hong Kong | 1055 | 4 | 1025 | 26 | 22.3 | 114.2 | 2020-05-19 02:32:18 | Hong Kong, China | ||
2020-05-19 | China | Hong Kong | 1055 | 4 | 1025 | 26 | 22.3 | 114.2 | 2020-05-20 02:32:19 | Hong Kong, China | ||
2020-05-20 | China | Hong Kong | 1055 | 4 | 1025 | 26 | 22.3 | 114.2 | 2020-05-21 02:32:48 | Hong Kong, China | ||
2020-05-21 | China | Hong Kong | 1063 | 4 | 1025 | 26 | 22.3 | 114.2 | 2020-05-22 02:36:51 | Hong Kong, China | ||
2020-05-22 | China | Hong Kong | 1065 | 4 | 1029 | 32 | 22.3 | 114.2 | 2020-05-23 02:32:42 | Hong Kong, China | ||
2020-05-23 | China | Hong Kong | 1065 | 4 | 1029 | 32 | 22.3 | 114.2 | 2020-05-24 02:32:43 | Hong Kong, China | ||
2020-05-24 | China | Hong Kong | 1065 | 4 | 1030 | 31 | 22.3 | 114.2 | 2020-05-25 02:32:44 | Hong Kong, China | ||
2020-05-25 | China | Hong Kong | 1065 | 4 | 1030 | 31 | 22.3 | 114.2 | 2020-05-26 02:32:35 | Hong Kong, China | ||
2020-05-26 | China | Hong Kong | 1065 | 4 | 1033 | 28 | 22.3 | 114.2 | 2020-05-27 02:32:31 | Hong Kong, China | ||
2020-05-27 | China | Hong Kong | 1066 | 4 | 1034 | 28 | 22.3 | 114.2 | 2020-05-28 02:32:31 | Hong Kong, China | ||
2020-05-28 | China | Hong Kong | 1066 | 4 | 1035 | 27 | 22.3 | 114.2 | 2020-05-29 02:32:50 | Hong Kong, China | ||
2020-05-29 | China | Hong Kong | 1079 | 4 | 1035 | 40 | 22.3 | 114.2 | 2020-05-30 02:32:48 | Hong Kong, China | ||
2020-05-30 | China | Hong Kong | 1082 | 4 | 1036 | 42 | 22.3 | 114.2 | 2020-05-31 02:32:45 | Hong Kong, China | ||
2020-05-31 | China | Hong Kong | 1084 | 4 | 1037 | 43 | 22.3 | 114.2 | 2020-06-01 02:32:46 | Hong Kong, China | ||
2020-06-01 | China | Hong Kong | 1087 | 4 | 1037 | 46 | 22.3 | 114.2 | 2020-06-02 02:33:08 | Hong Kong, China | ||
2020-06-02 | China | Hong Kong | 1093 | 4 | 1038 | 51 | 22.3 | 114.2 | 2020-06-03 02:33:13 | Hong Kong, China | ||
2020-06-03 | China | Hong Kong | 1093 | 4 | 1039 | 50 | 22.3 | 114.2 | 2020-06-04 02:33:14 | Hong Kong, China | ||
2020-06-04 | China | Hong Kong | 1099 | 4 | 1042 | 53 | 22.3 | 114.2 | 2020-06-05 02:33:06 | Hong Kong, China | ||
2020-06-05 | China | Hong Kong | 1102 | 4 | 1045 | 53 | 22.3 | 114.2 | 2020-06-06 02:33:00 | Hong Kong, China | ||
2020-06-06 | China | Hong Kong | 1105 | 4 | 1048 | 53 | 22.3 | 114.2 | 2020-06-07 03:53:30 | Hong Kong, China | ||
2020-06-07 | China | Hong Kong | 1106 | 4 | 1049 | 53 | 22.3 | 114.2 | 2020-06-08 03:33:22 | Hong Kong, China | ||
2020-06-08 | China | Hong Kong | 1107 | 4 | 1049 | 54 | 22.3 | 114.2 | 2020-06-09 03:33:03 | Hong Kong, China | ||
2020-06-09 | China | Hong Kong | 1107 | 4 | 1050 | 53 | 22.3 | 114.2 | 2020-06-10 04:07:00 | Hong Kong, China | ||
2020-06-10 | China | Hong Kong | 1107 | 4 | 1051 | 52 | 22.3 | 114.2 | 2020-06-11 03:33:41 | Hong Kong, China | ||
2020-06-11 | China | Hong Kong | 1107 | 4 | 1055 | 48 | 22.3 | 114.2 | 2020-06-12 05:09:52 | Hong Kong, China | ||
2020-06-12 | China | Hong Kong | 1108 | 4 | 1060 | 44 | 22.3 | 114.2 | 2020-06-13 03:33:14 | Hong Kong, China | ||
2020-06-13 | China | Hong Kong | 1109 | 4 | 1061 | 44 | 22.3 | 114.2 | 2020-06-14 03:33:15 | Hong Kong, China | ||
2020-06-14 | China | Hong Kong | 1109 | 4 | 1067 | 38 | 22.3 | 114.2 | 2020-06-15 03:33:14 | Hong Kong, China | ||
2020-06-15 | China | Hong Kong | 1112 | 4 | 1067 | 41 | 22.3 | 114.2 | 2020-06-16 04:33:09 | Hong Kong, China | ||
2020-06-16 | China | Hong Kong | 1112 | 4 | 1069 | 39 | 22.3 | 114.2 | 2020-06-17 04:33:21 | Hong Kong, China | ||
2020-06-17 | China | Hong Kong | 1120 | 4 | 1071 | 45 | 22.3 | 114.2 | 2020-06-18 04:33:18 | Hong Kong, China | ||
2020-06-18 | China | Hong Kong | 1124 | 4 | 1072 | 48 | 22.3 | 114.2 | 2020-06-19 04:33:17 | Hong Kong, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;