johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where province_or_state = "Hong Kong" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 3
- China 924
- Hong Kong 48
- Hong Kong SAR 1
province_or_state 1
- Hong Kong · 973 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016518 | 2016518 | 2022-09-20 | China | Hong Kong | 1719349 | 9908 | 0 | 22.3 | 114.2 | 2022-09-21 04:23:22 | Hong Kong, China | |||
3570391 | 3570391 | 2022-09-19 | China | Hong Kong | 1713755 | 9901 | 0 | 22.3 | 114.2 | 2022-09-20 04:22:48 | 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 | |||
3373154 | 3373154 | 2022-09-17 | China | Hong Kong | 1700173 | 9868 | 0 | 22.3 | 114.2 | 2022-09-18 04:22:50 | Hong Kong, China | |||
2355262 | 2355262 | 2022-09-16 | China | Hong Kong | 1691895 | 9852 | 0 | 22.3 | 114.2 | 2022-09-17 04:20:19 | Hong Kong, China | |||
3986419 | 3986419 | 2022-09-15 | China | Hong Kong | 1682896 | 9836 | 0 | 22.3 | 114.2 | 2022-09-16 04:21:19 | Hong Kong, China | |||
1888936 | 1888936 | 2022-09-14 | China | Hong Kong | 1674709 | 9830 | 0 | 22.3 | 114.2 | 2022-09-15 04:21:02 | Hong Kong, China | |||
371991 | 371991 | 2022-09-13 | China | Hong Kong | 1667130 | 9820 | 0 | 22.3 | 114.2 | 2022-09-14 04:20:44 | Hong Kong, China | |||
2394596 | 2394596 | 2022-09-12 | China | Hong Kong | 1659912 | 9810 | 0 | 22.3 | 114.2 | 2022-09-13 04:20:57 | Hong Kong, China | |||
3765674 | 3765674 | 2022-09-11 | China | Hong Kong | 1651974 | 9799 | 0 | 22.3 | 114.2 | 2022-09-12 04:20:58 | Hong Kong, China | |||
3824249 | 3824249 | 2022-09-10 | China | Hong Kong | 1642941 | 9788 | 0 | 22.3 | 114.2 | 2022-09-11 04:20:50 | Hong Kong, China | |||
962706 | 962706 | 2022-09-09 | China | Hong Kong | 1633154 | 9780 | 0 | 22.3 | 114.2 | 2022-09-10 04:21:10 | Hong Kong, China | |||
253108 | 253108 | 2022-09-08 | China | Hong Kong | 1623078 | 9769 | 0 | 22.3 | 114.2 | 2022-09-09 04:21:11 | Hong Kong, China | |||
3744906 | 3744906 | 2022-09-07 | China | Hong Kong | 1611987 | 9757 | 0 | 22.3 | 114.2 | 2022-09-08 04:21:02 | Hong Kong, China | |||
114546 | 114546 | 2022-09-06 | China | Hong Kong | 1601793 | 9741 | 0 | 22.3 | 114.2 | 2022-09-07 04:20:59 | Hong Kong, China | |||
2633518 | 2633518 | 2022-09-05 | China | Hong Kong | 1592420 | 9732 | 0 | 22.3 | 114.2 | 2022-09-06 04:21:02 | Hong Kong, China | |||
2987082 | 2987082 | 2022-09-04 | China | Hong Kong | 1582399 | 9724 | 0 | 22.3 | 114.2 | 2022-09-05 04:21:01 | Hong Kong, China | |||
2712767 | 2712767 | 2022-09-03 | China | Hong Kong | 1571716 | 9716 | 0 | 22.3 | 114.2 | 2022-09-04 04:21:22 | Hong Kong, China | |||
1393472 | 1393472 | 2022-09-02 | China | Hong Kong | 1561290 | 9709 | 0 | 22.3 | 114.2 | 2022-09-03 04:21:04 | Hong Kong, China | |||
3547301 | 3547301 | 2022-09-01 | China | Hong Kong | 1551389 | 9701 | 0 | 22.3 | 114.2 | 2022-09-02 04:21:07 | Hong Kong, China | |||
2343221 | 2343221 | 2022-08-31 | China | Hong Kong | 1540803 | 9690 | 0 | 22.3 | 114.2 | 2022-09-01 04:21:03 | Hong Kong, China | |||
3773701 | 3773701 | 2022-08-30 | China | Hong Kong | 1531308 | 9681 | 0 | 22.3 | 114.2 | 2022-08-31 04:20:57 | Hong Kong, China | |||
1680297 | 1680297 | 2022-08-29 | China | Hong Kong | 1522460 | 9668 | 0 | 22.3 | 114.2 | 2022-08-30 04:21:03 | Hong Kong, China | |||
1876781 | 1876781 | 2022-08-28 | China | Hong Kong | 1513972 | 9664 | 0 | 22.3 | 114.2 | 2022-08-29 04:21:06 | Hong Kong, China | |||
2095908 | 2095908 | 2022-08-27 | China | Hong Kong | 1504264 | 9654 | 0 | 22.3 | 114.2 | 2022-08-28 04:21:02 | Hong Kong, China | |||
1531723 | 1531723 | 2022-08-26 | China | Hong Kong | 1495807 | 9650 | 0 | 22.3 | 114.2 | 2022-08-27 04:20:57 | Hong Kong, China | |||
2828610 | 2828610 | 2022-08-25 | China | Hong Kong | 1487972 | 9643 | 0 | 22.3 | 114.2 | 2022-08-26 04:21:02 | Hong Kong, China | |||
2323143 | 2323143 | 2022-08-24 | China | Hong Kong | 1479393 | 9634 | 0 | 22.3 | 114.2 | 2022-08-25 04:21:13 | Hong Kong, China | |||
1250552 | 1250552 | 2022-08-23 | China | Hong Kong | 1471509 | 9620 | 0 | 22.3 | 114.2 | 2022-08-24 04:20:46 | Hong Kong, China | |||
2852656 | 2852656 | 2022-08-22 | China | Hong Kong | 1464855 | 9610 | 0 | 22.3 | 114.2 | 2022-08-23 04:20:56 | Hong Kong, China | |||
2402628 | 2402628 | 2022-08-21 | China | Hong Kong | 1458238 | 9605 | 0 | 22.3 | 114.2 | 2022-08-22 04:20:38 | Hong Kong, China | |||
3797706 | 3797706 | 2022-08-20 | China | Hong Kong | 1451725 | 9602 | 0 | 22.3 | 114.2 | 2022-08-21 04:20:44 | Hong Kong, China | |||
2363292 | 2363292 | 2022-08-19 | China | Hong Kong | 1445336 | 9597 | 0 | 22.3 | 114.2 | 2022-08-20 04:21:01 | Hong Kong, China | |||
1160963 | 1160963 | 2022-08-18 | China | Hong Kong | 1438891 | 9589 | 0 | 22.3 | 114.2 | 2022-08-19 04:20:54 | Hong Kong, China | |||
3950287 | 3950287 | 2022-08-17 | China | Hong Kong | 1432837 | 9584 | 0 | 22.3 | 114.2 | 2022-08-18 04:21:11 | Hong Kong, China | |||
990789 | 990789 | 2022-08-16 | China | Hong Kong | 1427080 | 9580 | 0 | 22.3 | 114.2 | 2022-08-17 04:20:59 | Hong Kong, China | |||
2493828 | 2493828 | 2022-08-15 | China | Hong Kong | 1421918 | 9569 | 0 | 22.3 | 114.2 | 2022-08-16 04:20:58 | Hong Kong, China | |||
3647378 | 3647378 | 2022-08-14 | China | Hong Kong | 1417022 | 9565 | 0 | 22.3 | 114.2 | 2022-08-15 04:20:59 | Hong Kong, China | |||
1968384 | 1968384 | 2022-08-13 | China | Hong Kong | 1412043 | 9562 | 0 | 22.3 | 114.2 | 2022-08-14 04:20:55 | Hong Kong, China | |||
2888193 | 2888193 | 2022-08-12 | China | Hong Kong | 1406735 | 9559 | 0 | 22.3 | 114.2 | 2022-08-13 04:20:52 | Hong Kong, China | |||
3907798 | 3907798 | 2022-08-11 | China | Hong Kong | 1402296 | 9555 | 0 | 22.3 | 114.2 | 2022-08-12 04:20:54 | Hong Kong, China | |||
1346115 | 1346115 | 2022-08-10 | China | Hong Kong | 1397920 | 9554 | 0 | 22.3 | 114.2 | 2022-08-11 04:20:49 | Hong Kong, China | |||
1085870 | 1085870 | 2022-08-09 | China | Hong Kong | 1393327 | 9550 | 0 | 22.3 | 114.2 | 2022-08-10 04:20:57 | Hong Kong, China | |||
3543285 | 3543285 | 2022-08-08 | China | Hong Kong | 1389282 | 9547 | 0 | 22.3 | 114.2 | 2022-08-09 04:20:34 | Hong Kong, China | |||
1069688 | 1069688 | 2022-08-07 | China | Hong Kong | 1385242 | 9540 | 0 | 22.3 | 114.2 | 2022-08-08 04:21:08 | Hong Kong, China | |||
1940276 | 1940276 | 2022-08-06 | China | Hong Kong | 1380968 | 9535 | 0 | 22.3 | 114.2 | 2022-08-07 04:20:54 | Hong Kong, China | |||
880075 | 880075 | 2022-08-05 | China | Hong Kong | 1376366 | 9531 | 0 | 22.3 | 114.2 | 2022-08-06 04:20:56 | Hong Kong, China | |||
2008486 | 2008486 | 2022-08-04 | China | Hong Kong | 1371938 | 9527 | 0 | 22.3 | 114.2 | 2022-08-05 04:20:52 | Hong Kong, China | |||
1097913 | 1097913 | 2022-08-03 | China | Hong Kong | 1366918 | 9524 | 0 | 22.3 | 114.2 | 2022-08-04 04:20:58 | Hong Kong, China | |||
1404838 | 1404838 | 2022-08-02 | China | Hong Kong | 1362371 | 9520 | 0 | 22.3 | 114.2 | 2022-08-03 04:20:59 | Hong Kong, China | |||
3616876 | 3616876 | 2022-08-01 | China | Hong Kong | 1358248 | 9509 | 0 | 22.3 | 114.2 | 2022-08-02 04:20:53 | Hong Kong, China | |||
3871356 | 3871356 | 2022-07-31 | China | Hong Kong | 1353994 | 9503 | 0 | 22.3 | 114.2 | 2022-08-01 04:21:03 | 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 | |||
1783309 | 1783309 | 2022-07-29 | China | Hong Kong | 1344677 | 9498 | 0 | 22.3 | 114.2 | 2022-07-30 04:20:42 | Hong Kong, China | |||
1065672 | 1065672 | 2022-07-28 | China | Hong Kong | 1339793 | 9493 | 0 | 22.3 | 114.2 | 2022-07-29 04:20:45 | Hong Kong, China | |||
2335191 | 2335191 | 2022-07-27 | China | Hong Kong | 1334907 | 9488 | 0 | 22.3 | 114.2 | 2022-07-28 04:20:56 | Hong Kong, China | |||
1487381 | 1487381 | 2022-07-26 | China | Hong Kong | 1330399 | 9478 | 0 | 22.3 | 114.2 | 2022-07-27 04:21:04 | Hong Kong, China | |||
2593827 | 2593827 | 2022-07-25 | China | Hong Kong | 1326123 | 9472 | 0 | 22.3 | 114.2 | 2022-07-26 04:20:58 | Hong Kong, China | |||
895942 | 895942 | 2022-07-24 | China | Hong Kong | 1321993 | 9469 | 0 | 22.3 | 114.2 | 2022-07-25 04:20:51 | Hong Kong, China | |||
90936 | 90936 | 2022-07-23 | China | Hong Kong | 1317743 | 9461 | 0 | 22.3 | 114.2 | 2022-07-24 04:20:47 | Hong Kong, China | |||
899958 | 899958 | 2022-07-22 | China | Hong Kong | 1313478 | 9454 | 0 | 22.3 | 114.2 | 2022-07-23 04:20:53 | 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 | |||
1608057 | 1608057 | 2022-07-20 | China | Hong Kong | 1304833 | 9445 | 0 | 22.3 | 114.2 | 2022-07-21 04:21:10 | Hong Kong, China | |||
958690 | 958690 | 2022-07-19 | China | Hong Kong | 1301028 | 9444 | 0 | 22.3 | 114.2 | 2022-07-20 04:20:59 | Hong Kong, China | |||
3210077 | 3210077 | 2022-07-18 | China | Hong Kong | 1297772 | 9440 | 0 | 22.3 | 114.2 | 2022-07-19 04:20:58 | Hong Kong, China | |||
3405252 | 3405252 | 2022-07-17 | China | Hong Kong | 1294336 | 9437 | 0 | 22.3 | 114.2 | 2022-07-18 04:20:59 | Hong Kong, China | |||
2151452 | 2151452 | 2022-07-16 | China | Hong Kong | 1290850 | 9433 | 0 | 22.3 | 114.2 | 2022-07-17 04:21:15 | Hong Kong, China | |||
2418685 | 2418685 | 2022-07-15 | China | Hong Kong | 1287088 | 9432 | 0 | 22.3 | 114.2 | 2022-07-16 04:21:05 | Hong Kong, China | |||
3428760 | 3428760 | 2022-07-14 | China | Hong Kong | 1283514 | 9427 | 0 | 22.3 | 114.2 | 2022-07-15 04:20:53 | Hong Kong, China | |||
3109280 | 3109280 | 2022-07-13 | China | Hong Kong | 1279840 | 9422 | 0 | 22.3 | 114.2 | 2022-07-14 04:20:57 | 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 | |||
1211347 | 1211347 | 2022-07-11 | China | Hong Kong | 1273917 | 9419 | 0 | 22.3 | 114.2 | 2022-07-12 04:20:51 | Hong Kong, China | |||
2788829 | 2788829 | 2022-07-10 | China | Hong Kong | 1271054 | 9412 | 0 | 22.3 | 114.2 | 2022-07-11 04:20:46 | Hong Kong, China | |||
141782 | 141782 | 2022-07-09 | China | Hong Kong | 1268062 | 9410 | 0 | 22.3 | 114.2 | 2022-07-10 04:20:54 | Hong Kong, China | |||
1416882 | 1416882 | 2022-07-08 | China | Hong Kong | 1265067 | 9410 | 0 | 22.3 | 114.2 | 2022-07-09 04:20:59 | Hong Kong, China | |||
2740807 | 2740807 | 2022-07-07 | China | Hong Kong | 1262122 | 9407 | 0 | 22.3 | 114.2 | 2022-07-08 04:20:56 | Hong Kong, China | |||
1199602 | 1199602 | 2022-07-06 | China | Hong Kong | 1259094 | 9406 | 0 | 22.3 | 114.2 | 2022-07-07 04:20:55 | Hong Kong, China | |||
3966345 | 3966345 | 2022-07-05 | China | Hong Kong | 1256279 | 9405 | 0 | 22.3 | 114.2 | 2022-07-06 04:20:58 | Hong Kong, China | |||
3077856 | 3077856 | 2022-07-04 | China | Hong Kong | 1254011 | 9405 | 0 | 22.3 | 114.2 | 2022-07-05 04:20:45 | Hong Kong, China | |||
1767138 | 1767138 | 2022-07-03 | China | Hong Kong | 1252170 | 9405 | 0 | 22.3 | 114.2 | 2022-07-04 04:20:54 | Hong Kong, China | |||
3365124 | 3365124 | 2022-07-02 | China | Hong Kong | 1250342 | 9405 | 0 | 22.3 | 114.2 | 2022-07-03 04:20:59 | 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 | |||
3939854 | 3939854 | 2022-06-30 | China | Hong Kong | 1245797 | 9401 | 0 | 22.3 | 114.2 | 2022-07-01 04:21:10 | Hong Kong, China | |||
2489812 | 2489812 | 2022-06-29 | China | Hong Kong | 1243439 | 9399 | 0 | 22.3 | 114.2 | 2022-06-30 04:21:01 | Hong Kong, China | |||
2239194 | 2239194 | 2022-06-28 | China | Hong Kong | 1241435 | 9399 | 0 | 22.3 | 114.2 | 2022-06-29 04:20:59 | Hong Kong, China | |||
2147436 | 2147436 | 2022-06-27 | China | Hong Kong | 1239750 | 9398 | 0 | 22.3 | 114.2 | 2022-06-28 04:20:58 | 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 | |||
938612 | 938612 | 2022-06-25 | China | Hong Kong | 1235960 | 9398 | 0 | 22.3 | 114.2 | 2022-06-26 04:21:02 | Hong Kong, China | |||
3346432 | 3346432 | 2022-06-24 | China | Hong Kong | 1234166 | 9398 | 0 | 22.3 | 114.2 | 2022-06-25 04:20:57 | Hong Kong, China | |||
1648173 | 1648173 | 2022-06-23 | China | Hong Kong | 1232306 | 9398 | 0 | 22.3 | 114.2 | 2022-06-24 04:20:58 | Hong Kong, China | |||
2187408 | 2187408 | 2022-06-22 | China | Hong Kong | 1230656 | 9397 | 0 | 22.3 | 114.2 | 2022-06-23 04:20:55 | Hong Kong, China | |||
165839 | 165839 | 2022-06-21 | China | Hong Kong | 1229209 | 9396 | 0 | 22.3 | 114.2 | 2022-06-22 04:20:54 | Hong Kong, China | |||
1763122 | 1763122 | 2022-06-20 | China | Hong Kong | 1228011 | 9396 | 0 | 22.3 | 114.2 | 2022-06-21 04:20:56 | Hong Kong, China | |||
3269308 | 3269308 | 2022-06-19 | China | Hong Kong | 1226684 | 9395 | 0 | 22.3 | 114.2 | 2022-06-20 04:21:01 | Hong Kong, China | |||
3397220 | 3397220 | 2022-06-18 | China | Hong Kong | 1225408 | 9393 | 0 | 22.3 | 114.2 | 2022-06-19 04:20:51 | Hong Kong, China | |||
2311097 | 2311097 | 2022-06-17 | China | Hong Kong | 1224132 | 9393 | 0 | 22.3 | 114.2 | 2022-06-18 04:21:10 | 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 | |||
3982403 | 3982403 | 2022-06-15 | China | Hong Kong | 1221808 | 9392 | 0 | 22.3 | 114.2 | 2022-06-16 04:20:55 | Hong Kong, China | |||
946644 | 946644 | 2022-06-14 | China | Hong Kong | 1220761 | 9391 | 0 | 22.3 | 114.2 | 2022-06-15 04:20:54 | Hong Kong, China | |||
2979052 | 2979052 | 2022-06-13 | China | Hong Kong | 1219912 | 9390 | 0 | 22.3 | 114.2 | 2022-06-14 04:20:52 | 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]);