daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

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 descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

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

province_or_state 1

  • Hong Kong · 1,024 ✖

country_or_region 1

  • China · 1,024 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-12-29 China Hong Kong     2568596 11683 0   22.3 114.2 2022-12-30 04:21:04 Hong Kong, China
2022-12-28 China Hong Kong     2543701 11621 0   22.3 114.2 2022-12-29 04:21:01 Hong Kong, China
2022-12-27 China Hong Kong     2522836 11562 0   22.3 114.2 2022-12-28 04:21:04 Hong Kong, China
2022-12-26 China Hong Kong     2504210 11509 0   22.3 114.2 2022-12-27 04:21:07 Hong Kong, China
2022-12-25 China Hong Kong     2484812 11462 0   22.3 114.2 2022-12-26 04:21:06 Hong Kong, China
2022-12-24 China Hong Kong     2463557 11412 0   22.3 114.2 2022-12-25 04:21:04 Hong Kong, China
2022-12-23 China Hong Kong     2442195 11373 0   22.3 114.2 2022-12-24 04:21:02 Hong Kong, China
2022-12-22 China Hong Kong     2421943 11334 0   22.3 114.2 2022-12-23 04:21:04 Hong Kong, China
2022-12-21 China Hong Kong     2402238 11334 0   22.3 114.2 2022-12-22 04:20:56 Hong Kong, China
2022-12-20 China Hong Kong     2385285 11251 0   22.3 114.2 2022-12-21 04:21:03 Hong Kong, China
2022-12-19 China Hong Kong     2370303 11251 0   22.3 114.2 2022-12-20 04:21:04 Hong Kong, China
2022-12-18 China Hong Kong     2338897 11172 0   22.3 114.2 2022-12-19 04:21:03 Hong Kong, China
2022-12-17 China Hong Kong     2323123 11148 0   22.3 114.2 2022-12-18 04:21:03 Hong Kong, China
2022-12-16 China Hong Kong     2323123 11107 0   22.3 114.2 2022-12-17 04:21:04 Hong Kong, China
2022-12-15 China Hong Kong     2307397 11075 0   22.3 114.2 2022-12-16 04:21:01 Hong Kong, China
2022-12-14 China Hong Kong     2290317 11056 0   22.3 114.2 2022-12-15 04:20:58 Hong Kong, China
2022-12-13 China Hong Kong     2275447 11021 0   22.3 114.2 2022-12-14 04:21:04 Hong Kong, China
2022-12-12 China Hong Kong     2261726 10984 0   22.3 114.2 2022-12-13 04:21:01 Hong Kong, China
2022-12-11 China Hong Kong     2247009 10959 0   22.3 114.2 2022-12-12 04:21:01 Hong Kong, China
2022-12-10 China Hong Kong     2232091 10935 0   22.3 114.2 2022-12-11 04:20:50 Hong Kong, China
2022-12-09 China Hong Kong     2217714 10914 0   22.3 114.2 2022-12-10 04:21:02 Hong Kong, China
2022-12-08 China Hong Kong     2203790 10891 0   22.3 114.2 2022-12-09 04:21:05 Hong Kong, China
2022-12-07 China Hong Kong     2189417 10864 0   22.3 114.2 2022-12-08 04:21:07 Hong Kong, China
2022-12-06 China Hong Kong     2177436 10842 0   22.3 114.2 2022-12-07 04:20:58 Hong Kong, China
2022-12-05 China Hong Kong     2167484 10826 0   22.3 114.2 2022-12-06 04:21:03 Hong Kong, China
2022-12-04 China Hong Kong     2157976 10806 0   22.3 114.2 2022-12-05 04:20:58 Hong Kong, China
2022-12-03 China Hong Kong     2148489 10790 0   22.3 114.2 2022-12-04 04:20:56 Hong Kong, China
2022-12-02 China Hong Kong     2138378 10773 0   22.3 114.2 2022-12-03 04:21:02 Hong Kong, China
2022-12-01 China Hong Kong     2128382 10762 0   22.3 114.2 2022-12-02 04:21:07 Hong Kong, China
2022-11-30 China Hong Kong     2118245 10747 0   22.3 114.2 2022-12-01 04:21:03 Hong Kong, China
2022-11-29 China Hong Kong     2109435 10731 0   22.3 114.2 2022-11-30 04:21:07 Hong Kong, China
2022-11-28 China Hong Kong     2101888 10718 0   22.3 114.2 2022-11-29 04:21:05 Hong Kong, China
2022-11-27 China Hong Kong     2094095 10692 0   22.3 114.2 2022-11-28 04:21:02 Hong Kong, China
2022-11-26 China Hong Kong     2086062 10672 0   22.3 114.2 2022-11-27 04:21:05 Hong Kong, China
2022-11-25 China Hong Kong     2077188 10663 0   22.3 114.2 2022-11-26 04:21:11 Hong Kong, China
2022-11-24 China Hong Kong     2068310 10647 0   22.3 114.2 2022-11-25 04:21:06 Hong Kong, China
2022-11-23 China Hong Kong     2059091 10634 0   22.3 114.2 2022-11-24 04:21:09 Hong Kong, China
2022-11-22 China Hong Kong     2051106 10623 0   22.3 114.2 2022-11-23 04:21:06 Hong Kong, China
2022-11-21 China Hong Kong     2043967 10610 0   22.3 114.2 2022-11-22 04:20:47 Hong Kong, China
2022-11-20 China Hong Kong     2036681 10599 0   22.3 114.2 2022-11-21 04:21:05 Hong Kong, China
2022-11-19 China Hong Kong     2028945 10586 0   22.3 114.2 2022-11-20 04:21:08 Hong Kong, China
2022-11-18 China Hong Kong     2020885 10577 0   22.3 114.2 2022-11-19 04:21:14 Hong Kong, China
2022-11-17 China Hong Kong     2012877 10569 0   22.3 114.2 2022-11-18 04:21:15 Hong Kong, China
2022-11-16 China Hong Kong     2004825 10557 0   22.3 114.2 2022-11-17 04:21:11 Hong Kong, China
2022-11-15 China Hong Kong     1998169 10549 0   22.3 114.2 2022-11-16 04:21:09 Hong Kong, China
2022-11-14 China Hong Kong     1992218 10536 0   22.3 114.2 2022-11-15 04:21:16 Hong Kong, China
2022-11-13 China Hong Kong     1986204 10526 0   22.3 114.2 2022-11-14 04:21:09 Hong Kong, China
2022-11-12 China Hong Kong     1979629 10517 0   22.3 114.2 2022-11-13 04:21:14 Hong Kong, China
2022-11-11 China Hong Kong     1973906 10511 0   22.3 114.2 2022-11-12 04:20:41 Hong Kong, China
2022-11-10 China Hong Kong     1968307 10501 0   22.3 114.2 2022-11-11 04:21:22 Hong Kong, China
2022-11-09 China Hong Kong     1962610 10492 0   22.3 114.2 2022-11-10 04:21:16 Hong Kong, China
2022-11-08 China Hong Kong     1957542 10479 0   22.3 114.2 2022-11-09 04:21:22 Hong Kong, China
2022-11-07 China Hong Kong     1952893 10475 0   22.3 114.2 2022-11-08 04:21:21 Hong Kong, China
2022-11-06 China Hong Kong     1947695 10470 0   22.3 114.2 2022-11-07 04:21:26 Hong Kong, China
2022-11-05 China Hong Kong     1942707 10457 0   22.3 114.2 2022-11-06 04:21:24 Hong Kong, China
2022-11-04 China Hong Kong     1937596 10439 0   22.3 114.2 2022-11-05 04:21:52 Hong Kong, China
2022-11-03 China Hong Kong     1933080 10428 0   22.3 114.2 2022-11-04 04:22:11 Hong Kong, China
2022-11-02 China Hong Kong     1927835 10418 0   22.3 114.2 2022-11-03 04:22:05 Hong Kong, China
2022-11-01 China Hong Kong     1923126 10410 0   22.3 114.2 2022-11-02 04:22:09 Hong Kong, China
2022-10-31 China Hong Kong     1918708 10397 0   22.3 114.2 2022-11-01 04:22:36 Hong Kong, China
2022-10-30 China Hong Kong     1913942 10385 0   22.3 114.2 2022-10-31 04:21:36 Hong Kong, China
2022-10-29 China Hong Kong     1908732 10373 0   22.3 114.2 2022-10-30 04:22:14 Hong Kong, China
2022-10-28 China Hong Kong     1903349 10365 0   22.3 114.2 2022-10-29 04:21:13 Hong Kong, China
2022-10-27 China Hong Kong     1897693 10358 0   22.3 114.2 2022-10-28 04:22:31 Hong Kong, China
2022-10-26 China Hong Kong     1891631 10350 0   22.3 114.2 2022-10-27 04:22:01 Hong Kong, China
2022-10-25 China Hong Kong     1886228 10343 0   22.3 114.2 2022-10-26 04:22:19 Hong Kong, China
2022-10-24 China Hong Kong     1881007 10333 0   22.3 114.2 2022-10-25 04:21:53 Hong Kong, China
2022-10-23 China Hong Kong     1875601 10326 0   22.3 114.2 2022-10-24 04:22:29 Hong Kong, China
2022-10-22 China Hong Kong     1870066 10322 0   22.3 114.2 2022-10-23 04:22:46 Hong Kong, China
2022-10-21 China Hong Kong     1864113 10315 0   22.3 114.2 2022-10-22 04:22:53 Hong Kong, China
2022-10-20 China Hong Kong     1858720 10306 0   22.3 114.2 2022-10-21 04:22:23 Hong Kong, China
2022-10-19 China Hong Kong     1853287 10297 0   22.3 114.2 2022-10-20 04:22:59 Hong Kong, China
2022-10-18 China Hong Kong     1848163 10285 0   22.3 114.2 2022-10-19 04:22:26 Hong Kong, China
2022-10-17 China Hong Kong     1843209 10278 0   22.3 114.2 2022-10-18 04:22:42 Hong Kong, China
2022-10-16 China Hong Kong     1837848 10273 0   22.3 114.2 2022-10-17 04:20:31 Hong Kong, China
2022-10-15 China Hong Kong     1832284 10268 0   22.3 114.2 2022-10-16 04:22:39 Hong Kong, China
2022-10-14 China Hong Kong     1826860 10261 0   22.3 114.2 2022-10-15 04:22:00 Hong Kong, China
2022-10-13 China Hong Kong     1821754 10254 0   22.3 114.2 2022-10-14 04:22:28 Hong Kong, China
2022-10-12 China Hong Kong     1816132 10246 0   22.3 114.2 2022-10-13 04:22:39 Hong Kong, China
2022-10-11 China Hong Kong     1811344 10237 0   22.3 114.2 2022-10-12 04:22:51 Hong Kong, China
2022-10-10 China Hong Kong     1806688 10228 0   22.3 114.2 2022-10-11 04:23:05 Hong Kong, China
2022-10-09 China Hong Kong     1801814 10218 0   22.3 114.2 2022-10-10 04:22:32 Hong Kong, China
2022-10-08 China Hong Kong     1796924 10215 0   22.3 114.2 2022-10-09 04:21:16 Hong Kong, China
2022-10-07 China Hong Kong     1792024 10202 0   22.3 114.2 2022-10-08 04:22:56 Hong Kong, China
2022-10-06 China Hong Kong     1787655 10200 0   22.3 114.2 2022-10-07 04:23:08 Hong Kong, China
2022-10-05 China Hong Kong     1783337 10194 0   22.3 114.2 2022-10-06 04:21:22 Hong Kong, China
2022-10-04 China Hong Kong     1779695 10184 0   22.3 114.2 2022-10-05 04:23:06 Hong Kong, China
2022-10-03 China Hong Kong     1776409 10176 0   22.3 114.2 2022-10-04 04:22:55 Hong Kong, China
2022-10-02 China Hong Kong     1772880 10173 0   22.3 114.2 2022-10-03 04:23:11 Hong Kong, China
2022-10-01 China Hong Kong     1769311 10167 0   22.3 114.2 2022-10-02 04:21:23 Hong Kong, China
2022-09-30 China Hong Kong     1765404 10161 0   22.3 114.2 2022-10-01 04:23:01 Hong Kong, China
2022-09-29 China Hong Kong     1761381 10153 0   22.3 114.2 2022-09-30 04:23:09 Hong Kong, China
2022-09-28 China Hong Kong     1757112 10148 0   22.3 114.2 2022-09-29 04:22:34 Hong Kong, China
2022-09-27 China Hong Kong     1753201 10134 0   22.3 114.2 2022-09-28 04:23:01 Hong Kong, China
2022-09-26 China Hong Kong     1749534 10128 0   22.3 114.2 2022-09-27 04:23:01 Hong Kong, China
2022-09-25 China Hong Kong     1745500 10116 0   22.3 114.2 2022-09-26 04:20:52 Hong Kong, China
2022-09-24 China Hong Kong     1741603 10106 0   22.3 114.2 2022-09-25 04:23:31 Hong Kong, China
2022-09-23 China Hong Kong     1736413 10099 0   22.3 114.2 2022-09-24 04:21:40 Hong Kong, China
2022-09-22 China Hong Kong     1731026 9934 0   22.3 114.2 2022-09-23 04:23:13 Hong Kong, China
2022-09-21 China Hong Kong     1725036 9917 0   22.3 114.2 2022-09-22 04:22:56 Hong Kong, China

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;