daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where province_or_state = "Hong Kong" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, active, day (date), last_update (date)
country_or_region 3
- China 1,024
- Hong Kong 48
- Hong Kong SAR 1
province_or_state 1
- Hong Kong · 1,073 ✖
day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-01-22 | Hong Kong | Hong Kong | 0 | 0 | 0 | 22.3 | 114.2 | 1/22/2020 17:00 | ||||
2020-01-23 | Hong Kong | Hong Kong | 2 | 0 | 0 | 22.3 | 114.2 | 1/23/20 17:00 | ||||
2020-01-24 | Hong Kong | Hong Kong | 2 | 0 | 0 | 22.3 | 114.2 | 1/24/20 17:00 | ||||
2020-01-25 | Hong Kong | Hong Kong | 5 | 0 | 0 | 22.3 | 114.2 | 1/25/20 17:00 | ||||
2020-01-26 | Hong Kong | Hong Kong | 8 | 0 | 0 | 22.3 | 114.2 | 1/26/20 16:00 | ||||
2020-01-27 | Hong Kong | Hong Kong | 8 | 0 | 0 | 22.3 | 114.2 | 1/27/20 23:59 | ||||
2020-01-28 | Hong Kong | Hong Kong | 8 | 0 | 0 | 22.3 | 114.2 | 1/28/20 23:00 | ||||
2020-01-29 | Hong Kong | Hong Kong | 10 | 0 | 0 | 22.3 | 114.2 | 1/29/20 19:30 | ||||
2020-01-30 | Hong Kong | Hong Kong | 10 | 0 | 0 | 22.3 | 114.2 | 1/30/20 16:00 | ||||
2020-01-31 | Hong Kong | Hong Kong | 12 | 0 | 0 | 22.3 | 114.2 | 1/31/2020 23:59 | ||||
2020-02-01 | Hong Kong | Hong Kong | 13 | 0 | 0 | 22.3 | 114.2 | 2/1/2020 5:37 | ||||
2020-02-02 | Hong Kong | Hong Kong | 15 | 0 | 0 | 22.3 | 114.2 | 2020-02-02T23:53:02 | ||||
2020-02-03 | Hong Kong | Hong Kong | 15 | 0 | 0 | 22.3 | 114.2 | 2020-02-02T23:53:02 | ||||
2020-02-04 | Hong Kong | Hong Kong | 17 | 1 | 0 | 22.3 | 114.2 | 2020-02-04T09:03:02 | ||||
2020-02-05 | Hong Kong | Hong Kong | 21 | 1 | 0 | 22.3 | 114.2 | 2020-02-05T13:13:10 | ||||
2020-02-06 | Hong Kong | Hong Kong | 24 | 1 | 0 | 22.3 | 114.2 | 2020-02-06T14:43:02 | ||||
2020-02-07 | Hong Kong | Hong Kong | 25 | 1 | 0 | 22.3 | 114.2 | 2020-02-07T11:53:02 | ||||
2020-02-08 | Hong Kong | Hong Kong | 26 | 1 | 0 | 22.3 | 114.2 | 2020-02-08T00:03:07 | ||||
2020-02-09 | Hong Kong | Hong Kong | 29 | 1 | 0 | 22.3 | 114.2 | 2020-02-09T09:53:02 | ||||
2020-02-10 | Hong Kong | Hong Kong | 38 | 1 | 0 | 22.3 | 114.2 | 2020-02-10T10:13:06 | ||||
2020-02-11 | Hong Kong | Hong Kong | 49 | 1 | 0 | 22.3 | 114.2 | 2020-02-11T09:43:02 | ||||
2020-02-12 | Hong Kong | Hong Kong | 50 | 1 | 1 | 22.3 | 114.2 | 2020-02-12T09:53:02 | ||||
2020-02-13 | Hong Kong | Hong Kong | 53 | 1 | 1 | 22.3 | 114.2 | 2020-02-13T14:53:02 | ||||
2020-02-14 | Hong Kong | Hong Kong | 56 | 1 | 1 | 22.3 | 114.2 | 2020-02-14T09:03:12 | ||||
2020-02-15 | Hong Kong | Hong Kong | 56 | 1 | 1 | 22.3 | 114.2 | 2020-02-14T09:03:12 | ||||
2020-02-16 | Hong Kong | Hong Kong | 57 | 1 | 2 | 22.3 | 114.2 | 2020-02-16T09:53:01 | ||||
2020-02-17 | Hong Kong | Hong Kong | 60 | 1 | 2 | 22.3 | 114.2 | 2020-02-17T22:53:01 | ||||
2020-02-18 | Hong Kong | Hong Kong | 62 | 1 | 2 | 22.3 | 114.2 | 2020-02-18T23:43:02 | ||||
2020-02-19 | Hong Kong | Hong Kong | 63 | 2 | 5 | 22.3 | 114.2 | 2020-02-19T12:13:08 | ||||
2020-02-20 | Hong Kong | Hong Kong | 68 | 2 | 6 | 22.3 | 114.2 | 2020-02-20T23:13:05 | ||||
2020-02-21 | Hong Kong | Hong Kong | 68 | 2 | 5 | 22.3 | 114.2 | 2020-02-21T03:43:02 | ||||
2020-02-22 | Hong Kong | Hong Kong | 69 | 2 | 6 | 22.3 | 114.2 | 2020-02-22T13:23:05 | ||||
2020-02-23 | Hong Kong | Hong Kong | 74 | 2 | 11 | 22.3 | 114.2 | 2020-02-23T09:53:02 | ||||
2020-02-24 | Hong Kong | Hong Kong | 79 | 2 | 19 | 22.3 | 114.2 | 2020-02-24T11:23:06 | ||||
2020-02-25 | Hong Kong | Hong Kong | 84 | 2 | 19 | 22.3 | 114.2 | 2020-02-25T09:43:02 | ||||
2020-02-26 | Hong Kong | Hong Kong | 91 | 2 | 24 | 22.3 | 114.2 | 2020-02-26T23:43:02 | ||||
2020-02-27 | Hong Kong | Hong Kong | 92 | 2 | 24 | 22.3 | 114.2 | 2020-02-27T09:53:02 | ||||
2020-02-28 | Hong Kong | Hong Kong | 94 | 2 | 30 | 22.3 | 114.2 | 2020-02-28T10:03:12 | ||||
2020-02-29 | Hong Kong | Hong Kong | 95 | 2 | 33 | 22.3 | 114.2 | 2020-02-29T23:53:02 | ||||
2020-03-01 | Hong Kong | Hong Kong | 96 | 2 | 36 | 22.3 | 114.2 | 2020-03-01T14:33:16 | ||||
2020-03-02 | Hong Kong | Hong Kong | 100 | 2 | 36 | 22.3 | 114.2 | 2020-03-02T23:53:02 | ||||
2020-03-03 | Hong Kong | Hong Kong | 100 | 2 | 37 | 22.3 | 114.2 | 2020-03-03T11:53:01 | ||||
2020-03-04 | Hong Kong | Hong Kong | 105 | 2 | 37 | 22.3 | 114.2 | 2020-03-04T23:23:01 | ||||
2020-03-05 | Hong Kong | Hong Kong | 105 | 2 | 43 | 22.3 | 114.2 | 2020-03-05T00:23:07 | ||||
2020-03-06 | Hong Kong | Hong Kong | 107 | 2 | 46 | 22.3 | 114.2 | 2020-03-06T23:13:06 | ||||
2020-03-07 | Hong Kong | Hong Kong | 108 | 2 | 51 | 22.3 | 114.2 | 2020-03-07T10:13:22 | ||||
2020-03-08 | Hong Kong | Hong Kong | 114 | 3 | 58 | 22.3 | 114.2 | 2020-03-08T14:43:03 | ||||
2020-03-09 | Hong Kong | Hong Kong | 115 | 3 | 59 | 22.3 | 114.2 | 2020-03-09T10:03:17 | ||||
2020-03-10 | Hong Kong SAR | Hong Kong | 120 | 3 | 65 | 22.3 | 114.2 | 2020-03-10T23:53:02 | ||||
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 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;