johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
318 rows where confirmed = 171 and country_or_region = "China" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, longitude, combined_key, day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1250562 | 1250562 | 2022-08-23 | China | Qinghai | 171 | 0 | 0 | 35.7452 | 95.9956 | 2022-08-24 04:20:46 | Qinghai, China | |||
3022064 | 3022064 | 2022-03-23 | China | Guizhou | 171 | 2 | 0 | 26.8154 | 106.8748 | 2022-03-24 04:20:43 | Guizhou, China | |||
1904986 | 1904986 | 2022-03-22 | China | Guizhou | 171 | 2 | 0 | 26.8154 | 106.8748 | 2022-03-23 04:20:48 | Guizhou, China | |||
3238117 | 3238117 | 2022-03-21 | China | Guizhou | 171 | 2 | 0 | 26.8154 | 106.8748 | 2022-03-22 04:20:54 | Guizhou, China | |||
24190 | 24190 | 2022-03-20 | China | Guizhou | 171 | 2 | 0 | 26.8154 | 106.8748 | 2022-03-21 04:20:50 | Guizhou, China | |||
1656200 | 1656200 | 2022-03-19 | China | Guizhou | 171 | 2 | 0 | 26.8154 | 106.8748 | 2022-03-20 04:20:45 | Guizhou, China | |||
335726 | 335726 | 2022-03-18 | China | Guizhou | 171 | 2 | 0 | 26.8154 | 106.8748 | 2022-03-19 04:20:47 | Guizhou, China | |||
982755 | 982755 | 2021-04-17 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-18 04:20:41 | Hainan, China | ||
169850 | 169850 | 2021-04-16 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-17 04:20:40 | Hainan, China | ||
2548681 | 2548681 | 2021-04-15 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-16 04:20:46 | Hainan, China | ||
1841751 | 1841751 | 2021-04-14 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-15 04:20:54 | Hainan, China | ||
2571485 | 2571485 | 2021-04-13 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-14 04:20:41 | Hainan, China | ||
36236 | 36236 | 2021-04-12 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-13 04:20:37 | Hainan, China | ||
3883395 | 3883395 | 2021-04-11 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-12 04:21:00 | Hainan, China | ||
2983063 | 2983063 | 2021-04-10 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-11 04:20:56 | Hainan, China | ||
605495 | 605495 | 2021-04-09 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-10 04:20:59 | Hainan, China | ||
2645559 | 2645559 | 2021-04-08 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-09 04:21:13 | Hainan, China | ||
2247201 | 2247201 | 2021-04-07 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-08 04:21:13 | Hainan, China | ||
3003111 | 3003111 | 2021-04-06 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-07 04:20:53 | Hainan, China | ||
3085106 | 3085106 | 2021-04-05 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-06 04:20:32 | Hainan, China | ||
388029 | 388029 | 2021-04-04 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-05 04:20:35 | Hainan, China | ||
3709945 | 3709945 | 2021-04-03 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-04 04:20:49 | Hainan, China | ||
241061 | 241061 | 2021-04-02 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-03 04:20:44 | Hainan, China | ||
1301858 | 1301858 | 2021-04-01 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-02 04:20:36 | Hainan, China | ||
637730 | 637730 | 2021-03-31 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-04-01 04:27:05 | Hainan, China | ||
3643359 | 3643359 | 2021-03-30 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-31 04:26:25 | Hainan, China | ||
1289812 | 1289812 | 2021-03-29 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-30 04:26:23 | Hainan, China | ||
1535734 | 1535734 | 2021-03-28 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-29 04:28:35 | Hainan, China | ||
1219374 | 1219374 | 2021-03-27 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-28 05:28:10 | Hainan, China | ||
1880792 | 1880792 | 2021-03-26 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-27 05:25:04 | Hainan, China | ||
1980422 | 1980422 | 2021-03-25 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-26 05:26:55 | Hainan, China | ||
2780800 | 2780800 | 2021-03-24 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-25 05:27:00 | Hainan, China | ||
1798445 | 1798445 | 2021-03-23 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-24 05:25:40 | Hainan, China | ||
1203613 | 1203613 | 2021-03-22 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-23 05:26:18 | Hainan, China | ||
3369135 | 3369135 | 2021-03-21 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-22 05:25:43 | Hainan, China | ||
1744345 | 1744345 | 2021-03-20 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-21 05:25:44 | Hainan, China | ||
3420725 | 3420725 | 2021-03-19 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-20 05:25:46 | Hainan, China | ||
3452663 | 3452663 | 2021-03-18 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-19 05:26:09 | Hainan, China | ||
3620887 | 3620887 | 2021-03-17 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-18 05:26:22 | Hainan, China | ||
702211 | 702211 | 2021-03-16 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-17 05:25:07 | Hainan, China | ||
2055689 | 2055689 | 2021-03-15 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-16 05:25:13 | Hainan, China | ||
1732301 | 1732301 | 2021-03-14 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-15 05:25:51 | Hainan, China | ||
1579958 | 1579958 | 2021-03-13 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-14 05:25:37 | Hainan, China | ||
1837737 | 1837737 | 2021-03-12 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-13 05:25:15 | Hainan, China | ||
352102 | 352102 | 2021-03-11 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-12 05:26:50 | Hainan, China | ||
3962326 | 3962326 | 2021-03-10 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-11 05:25:48 | Hainan, China | ||
3663414 | 3663414 | 2021-03-09 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-10 05:24:35 | Hainan, China | ||
2359273 | 2359273 | 2021-03-08 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-09 05:28:19 | Hainan, China | ||
54611 | 54611 | 2021-03-07 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-08 05:24:48 | Hainan, China | ||
3667428 | 3667428 | 2021-03-06 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-07 05:21:54 | Hainan, China | ||
1616049 | 1616049 | 2021-03-05 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-06 04:23:41 | Hainan, China | ||
2207460 | 2207460 | 2021-03-04 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-05 05:26:29 | Hainan, China | ||
1089881 | 1089881 | 2021-03-03 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-04 05:24:24 | Hainan, China | ||
3253953 | 3253953 | 2021-03-02 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-03 05:23:28 | Hainan, China | ||
998245 | 998245 | 2021-03-01 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-02 05:23:30 | Hainan, China | ||
2367303 | 2367303 | 2021-02-28 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-03-01 05:23:01 | Hainan, China | ||
3065805 | 3065805 | 2021-02-27 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-28 05:22:20 | Hainan, China | ||
2183389 | 2183389 | 2021-02-26 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-27 05:22:28 | Hainan, China | ||
1857811 | 1857811 | 2021-02-25 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-26 05:22:40 | Hainan, China | ||
279989 | 279989 | 2021-02-24 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-25 05:24:57 | Hainan, China | ||
1936257 | 1936257 | 2021-02-23 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-24 05:29:16 | Hainan, China | ||
530512 | 530512 | 2021-02-22 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-23 05:23:41 | Hainan, China | ||
181846 | 181846 | 2021-02-21 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-22 05:24:21 | Hainan, China | ||
742120 | 742120 | 2021-02-20 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-21 05:24:33 | Hainan, China | ||
471218 | 471218 | 2021-02-19 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-20 05:22:51 | Hainan, China | ||
1152928 | 1152928 | 2021-02-18 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-19 05:24:16 | Hainan, China | ||
3600848 | 3600848 | 2021-02-17 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-18 05:22:58 | Hainan, China | ||
3049983 | 3049983 | 2021-02-16 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-17 05:23:10 | Hainan, China | ||
1338082 | 1338082 | 2021-02-15 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-16 05:24:38 | Hainan, China | ||
2283233 | 2283233 | 2021-02-14 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-15 05:24:49 | Hainan, China | ||
2677633 | 2677633 | 2021-02-13 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-14 05:23:43 | Hainan, China | ||
3539266 | 3539266 | 2021-02-12 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-13 05:22:12 | Hainan, China | ||
2637529 | 2637529 | 2021-02-11 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-12 05:23:29 | Hainan, China | ||
3978384 | 3978384 | 2021-02-10 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-11 05:23:55 | Hainan, China | ||
1527704 | 1527704 | 2021-02-09 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-10 05:22:41 | Hainan, China | ||
613495 | 613495 | 2021-02-08 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-09 05:23:30 | Hainan, China | ||
1672264 | 1672264 | 2021-02-07 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-08 05:22:39 | Hainan, China | ||
974725 | 974725 | 2021-02-06 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-07 05:23:00 | Hainan, China | ||
1587983 | 1587983 | 2021-02-05 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-06 05:23:55 | Hainan, China | ||
790190 | 790190 | 2021-02-04 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-05 05:22:38 | Hainan, China | ||
340082 | 340082 | 2021-02-03 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-04 05:22:26 | Hainan, China | ||
1684308 | 1684308 | 2021-02-02 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-03 05:22:52 | Hainan, China | ||
1676278 | 1676278 | 2021-02-01 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-02 05:22:49 | Hainan, China | ||
1459566 | 1459566 | 2021-01-31 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-02-01 05:22:53 | Hainan, China | ||
2211474 | 2211474 | 2021-01-30 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-31 05:22:42 | Hainan, China | ||
1896961 | 1896961 | 2021-01-29 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-30 05:22:49 | Hainan, China | ||
2481777 | 2481777 | 2021-01-28 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-29 05:22:23 | Hainan, China | ||
3153412 | 3153412 | 2021-01-27 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-28 05:22:24 | Hainan, China | ||
12147 | 12147 | 2021-01-26 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-27 05:23:41 | Hainan, China | ||
2567471 | 2567471 | 2021-01-25 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-26 05:22:02 | Hainan, China | ||
1759103 | 1759103 | 2021-01-24 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-25 05:22:16 | Hainan, China | ||
2426710 | 2426710 | 2021-01-23 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-24 05:22:35 | Hainan, China | ||
2466612 | 2466612 | 2021-01-22 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-23 05:22:03 | Hainan, China | ||
435163 | 435163 | 2021-01-21 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-22 05:22:10 | Hainan, China | ||
1093895 | 1093895 | 2021-01-20 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-21 05:22:01 | Hainan, China | ||
907985 | 907985 | 2021-01-19 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-20 05:21:54 | Hainan, China | ||
237048 | 237048 | 2021-01-18 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-19 05:22:15 | Hainan, China | ||
3503165 | 3503165 | 2021-01-17 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-18 05:22:34 | Hainan, China | ||
3101248 | 3101248 | 2021-01-16 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-17 05:22:17 | Hainan, China | ||
3515210 | 3515210 | 2021-01-15 | China | Hainan | 171 | 6 | 165 | 0 | 19.1959 | 109.7453 | 2021-01-16 05:22:40 | Hainan, 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]);