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 = "Guangdong" sorted by longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▼ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | China | Guangdong | 3318 | 8 | 0 | 23.3417 | 113.4244 | 2021-12-03 04:23:05 | Guangdong, China | |||
2021-10-28 | China | Guangdong | 3221 | 8 | 0 | 23.3417 | 113.4244 | 2021-10-29 04:22:03 | Guangdong, China | |||
2020-10-25 | China | Guangdong | 1908 | 8 | 1865 | 35 | 23.3417 | 113.4244 | 2020-10-26 04:25:02 | Guangdong, China | ||
2021-01-26 | China | Guangdong | 2115 | 8 | 2057 | 50 | 23.3417 | 113.4244 | 2021-01-27 05:23:41 | Guangdong, China | ||
2021-09-18 | China | Guangdong | 3142 | 8 | 0 | 23.3417 | 113.4244 | 2021-09-19 04:21:34 | Guangdong, China | |||
2021-05-28 | China | Guangdong | 2431 | 8 | 2377 | 46 | 23.3417 | 113.4244 | 2021-05-29 04:20:41 | Guangdong, China | ||
2022-03-20 | China | Guangdong | 6424 | 8 | 0 | 23.3417 | 113.4244 | 2022-03-21 04:20:50 | Guangdong, China | |||
2021-11-11 | China | Guangdong | 3251 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-12 04:22:01 | Guangdong, China | |||
2021-08-25 | China | Guangdong | 3032 | 8 | 0 | 23.3417 | 113.4244 | 2021-08-26 04:21:28 | Guangdong, China | |||
2021-04-12 | China | Guangdong | 2301 | 8 | 2254 | 39 | 23.3417 | 113.4244 | 2021-04-13 04:20:37 | Guangdong, China | ||
2020-04-13 | China | Guangdong | 1555 | 8 | 1454 | 93 | 23.3417 | 113.4244 | 2020-04-13 09:36:31 | Guangdong, China | ||
2021-11-02 | China | Guangdong | 3230 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-03 06:22:09 | Guangdong, China | |||
2020-04-17 | China | Guangdong | 1577 | 8 | 1475 | 94 | 23.3417 | 113.4244 | 2020-04-17 00:45:46 | Guangdong, China | ||
2021-05-29 | China | Guangdong | 2432 | 8 | 2381 | 43 | 23.3417 | 113.4244 | 2021-05-30 04:20:55 | Guangdong, China | ||
2021-03-07 | China | Guangdong | 2233 | 8 | 2180 | 45 | 23.3417 | 113.4244 | 2021-03-08 05:24:48 | Guangdong, China | ||
2020-07-23 | China | Guangdong | 1667 | 8 | 1639 | 20 | 23.3417 | 113.4244 | 2020-07-24 05:30:40 | Guangdong, China | ||
2022-11-12 | China | Guangdong | 16859 | 8 | 0 | 23.3417 | 113.4244 | 2022-11-13 04:21:14 | Guangdong, China | |||
2021-09-01 | China | Guangdong | 3074 | 8 | 0 | 23.3417 | 113.4244 | 2021-09-02 04:21:15 | Guangdong, China | |||
2022-02-07 | China | Guangdong | 3859 | 8 | 0 | 23.3417 | 113.4244 | 2022-02-08 04:21:15 | Guangdong, China | |||
2020-12-03 | China | Guangdong | 1997 | 8 | 1953 | 36 | 23.3417 | 113.4244 | 2020-12-04 05:27:27 | Guangdong, China | ||
2020-10-14 | China | Guangdong | 1873 | 8 | 1829 | 36 | 23.3417 | 113.4244 | 2020-10-15 04:24:28 | Guangdong, China | ||
2021-05-25 | China | Guangdong | 2413 | 8 | 2364 | 41 | 23.3417 | 113.4244 | 2021-05-26 04:20:35 | Guangdong, China | ||
2021-11-09 | China | Guangdong | 3248 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-10 04:21:38 | Guangdong, China | |||
2022-07-23 | China | Guangdong | 7988 | 8 | 0 | 23.3417 | 113.4244 | 2022-07-24 04:20:47 | Guangdong, China | |||
2020-08-04 | China | Guangdong | 1687 | 8 | 1661 | 18 | 23.3417 | 113.4244 | 2020-08-05 04:34:43 | Guangdong, China | ||
2022-01-14 | China | Guangdong | 3625 | 8 | 0 | 23.3417 | 113.4244 | 2022-01-15 04:21:07 | Guangdong, China | |||
2021-08-15 | China | Guangdong | 2968 | 8 | 0 | 23.3417 | 113.4244 | 2021-08-16 04:21:31 | Guangdong, China | |||
2021-06-19 | China | Guangdong | 2692 | 8 | 2459 | 225 | 23.3417 | 113.4244 | 2021-06-20 04:21:48 | Guangdong, China | ||
2020-05-08 | China | Guangdong | 1589 | 8 | 1575 | 6 | 23.3417 | 113.4244 | 2020-05-09 02:32:35 | Guangdong, China | ||
2022-09-06 | China | Guangdong | 9474 | 8 | 0 | 23.3417 | 113.4244 | 2022-09-07 04:20:59 | Guangdong, China | |||
2020-07-19 | China | Guangdong | 1650 | 8 | 1636 | 6 | 23.3417 | 113.4244 | 2020-07-20 05:34:40 | Guangdong, China | ||
2020-11-18 | China | Guangdong | 1973 | 8 | 1933 | 32 | 23.3417 | 113.4244 | 2020-11-19 05:25:23 | Guangdong, China | ||
2022-01-09 | China | Guangdong | 3539 | 8 | 0 | 23.3417 | 113.4244 | 2022-01-10 04:22:07 | Guangdong, China | |||
2022-10-04 | China | Guangdong | 10229 | 8 | 0 | 23.3417 | 113.4244 | 2022-10-05 04:23:06 | Guangdong, China | |||
2020-04-29 | China | Guangdong | 1588 | 8 | 1557 | 23 | 23.3417 | 113.4244 | 2020-04-30 02:32:27 | Guangdong, China | ||
2021-12-04 | China | Guangdong | 3323 | 8 | 0 | 23.3417 | 113.4244 | 2021-12-05 04:22:25 | Guangdong, China | |||
2022-07-09 | China | Guangdong | 7566 | 8 | 0 | 23.3417 | 113.4244 | 2022-07-10 04:20:54 | Guangdong, China | |||
2020-08-15 | China | Guangdong | 1712 | 8 | 1684 | 20 | 23.3417 | 113.4244 | 2020-08-16 04:27:42 | Guangdong, China | ||
2021-11-29 | China | Guangdong | 3310 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-30 04:22:53 | Guangdong, China | |||
2021-01-08 | China | Guangdong | 2067 | 8 | 2022 | 37 | 23.3417 | 113.4244 | 2021-01-09 05:22:18 | Guangdong, China | ||
2022-03-29 | China | Guangdong | 6572 | 8 | 0 | 23.3417 | 113.4244 | 2022-03-30 04:20:45 | Guangdong, China | |||
2021-11-19 | China | Guangdong | 3269 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-20 04:22:17 | Guangdong, China | |||
2022-06-21 | China | Guangdong | 7385 | 8 | 0 | 23.3417 | 113.4244 | 2022-06-22 04:20:54 | Guangdong, China | |||
2021-04-16 | China | Guangdong | 2313 | 8 | 2259 | 46 | 23.3417 | 113.4244 | 2021-04-17 04:20:40 | Guangdong, China | ||
2020-07-27 | China | Guangdong | 1672 | 8 | 1645 | 19 | 23.3417 | 113.4244 | 2020-07-28 04:58:43 | Guangdong, China | ||
2021-09-02 | China | Guangdong | 3079 | 8 | 0 | 23.3417 | 113.4244 | 2021-09-03 04:21:20 | Guangdong, China | |||
2021-02-21 | China | Guangdong | 2187 | 8 | 2137 | 42 | 23.3417 | 113.4244 | 2021-02-22 05:24:21 | Guangdong, China | ||
2022-02-13 | China | Guangdong | 3973 | 8 | 0 | 23.3417 | 113.4244 | 2022-02-14 04:20:51 | Guangdong, China | |||
2021-01-11 | China | Guangdong | 2076 | 8 | 2025 | 43 | 23.3417 | 113.4244 | 2021-01-12 05:22:15 | Guangdong, China | ||
2020-08-31 | China | Guangdong | 1740 | 8 | 1721 | 11 | 23.3417 | 113.4244 | 2020-09-01 04:28:31 | Guangdong, China | ||
2022-10-19 | China | Guangdong | 11086 | 8 | 0 | 23.3417 | 113.4244 | 2022-10-20 04:22:59 | Guangdong, China | |||
2020-12-25 | China | Guangdong | 2038 | 8 | 1997 | 33 | 23.3417 | 113.4244 | 2020-12-26 05:22:28 | Guangdong, China | ||
2020-08-19 | China | Guangdong | 1725 | 8 | 1691 | 26 | 23.3417 | 113.4244 | 2020-08-20 04:27:43 | Guangdong, China | ||
2020-10-29 | China | Guangdong | 1916 | 8 | 1877 | 31 | 23.3417 | 113.4244 | 2020-10-30 04:24:49 | Guangdong, China | ||
2020-06-08 | China | Guangdong | 1604 | 8 | 1586 | 10 | 23.3417 | 113.4244 | 2020-06-09 03:33:03 | Guangdong, China | ||
2022-12-26 | China | Guangdong | 63739 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-27 04:21:07 | Guangdong, China | |||
2022-05-09 | China | Guangdong | 7218 | 8 | 0 | 23.3417 | 113.4244 | 2022-05-10 04:20:50 | Guangdong, China | |||
2020-04-30 | China | Guangdong | 1588 | 8 | 1565 | 15 | 23.3417 | 113.4244 | 2020-05-01 02:32:28 | Guangdong, China | ||
2022-05-31 | China | Guangdong | 7303 | 8 | 0 | 23.3417 | 113.4244 | 2022-06-01 04:20:55 | Guangdong, China | |||
2022-02-11 | China | Guangdong | 3925 | 8 | 0 | 23.3417 | 113.4244 | 2022-02-12 04:21:06 | Guangdong, China | |||
2021-01-18 | China | Guangdong | 2090 | 8 | 2039 | 43 | 23.3417 | 113.4244 | 2021-01-19 05:22:15 | Guangdong, China | ||
2021-04-02 | China | Guangdong | 2285 | 8 | 2237 | 40 | 23.3417 | 113.4244 | 2021-04-03 04:20:44 | Guangdong, China | ||
2021-08-17 | China | Guangdong | 2978 | 8 | 0 | 23.3417 | 113.4244 | 2021-08-18 04:21:35 | Guangdong, China | |||
2021-09-04 | China | Guangdong | 3087 | 8 | 0 | 23.3417 | 113.4244 | 2021-09-05 04:21:33 | Guangdong, China | |||
2022-09-08 | China | Guangdong | 9559 | 8 | 0 | 23.3417 | 113.4244 | 2022-09-09 04:21:11 | Guangdong, China | |||
2022-12-10 | China | Guangdong | 52928 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-11 04:20:50 | Guangdong, China | |||
2022-03-15 | China | Guangdong | 6048 | 8 | 0 | 23.3417 | 113.4244 | 2022-03-16 04:20:50 | Guangdong, China | |||
2020-05-21 | China | Guangdong | 1590 | 8 | 1579 | 3 | 23.3417 | 113.4244 | 2020-05-22 02:36:51 | Guangdong, China | ||
2020-04-28 | China | Guangdong | 1588 | 8 | 1554 | 26 | 23.3417 | 113.4244 | 2020-04-29 02:32:29 | Guangdong, China | ||
2020-11-10 | China | Guangdong | 1955 | 8 | 1915 | 32 | 23.3417 | 113.4244 | 2020-11-11 05:25:30 | Guangdong, China | ||
2021-11-03 | China | Guangdong | 3233 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-04 04:22:20 | Guangdong, China | |||
2021-02-24 | China | Guangdong | 2198 | 8 | 2146 | 44 | 23.3417 | 113.4244 | 2021-02-25 05:24:57 | Guangdong, China | ||
2020-06-15 | China | Guangdong | 1628 | 8 | 1592 | 28 | 23.3417 | 113.4244 | 2020-06-16 04:33:09 | Guangdong, China | ||
2021-10-31 | China | Guangdong | 3224 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-01 04:22:01 | Guangdong, China | |||
2022-11-15 | China | Guangdong | 18778 | 8 | 0 | 23.3417 | 113.4244 | 2022-11-16 04:21:09 | Guangdong, China | |||
2021-07-15 | China | Guangdong | 2795 | 8 | 2724 | 63 | 23.3417 | 113.4244 | 2021-07-16 04:21:22 | Guangdong, China | ||
2020-07-01 | China | Guangdong | 1642 | 8 | 1627 | 7 | 23.3417 | 113.4244 | 2020-07-02 04:33:46 | Guangdong, China | ||
2022-04-16 | China | Guangdong | 6879 | 8 | 0 | 23.3417 | 113.4244 | 2022-04-17 04:20:59 | Guangdong, China | |||
2022-12-13 | China | Guangdong | 55674 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-14 04:21:04 | Guangdong, China | |||
2022-11-13 | China | Guangdong | 17585 | 8 | 0 | 23.3417 | 113.4244 | 2022-11-14 04:21:09 | Guangdong, China | |||
2022-02-12 | China | Guangdong | 3945 | 8 | 0 | 23.3417 | 113.4244 | 2022-02-13 04:21:00 | Guangdong, China | |||
2022-10-30 | China | Guangdong | 11585 | 8 | 0 | 23.3417 | 113.4244 | 2022-10-31 04:21:36 | Guangdong, China | |||
2020-07-20 | China | Guangdong | 1650 | 8 | 1636 | 6 | 23.3417 | 113.4244 | 2020-07-21 04:38:46 | Guangdong, China | ||
2022-12-27 | China | Guangdong | 63739 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-28 04:21:04 | Guangdong, China | |||
2021-08-04 | China | Guangdong | 2896 | 8 | 2822 | 66 | 23.3417 | 113.4244 | 2021-08-05 04:21:51 | Guangdong, China | ||
2022-03-18 | China | Guangdong | 6306 | 8 | 0 | 23.3417 | 113.4244 | 2022-03-19 04:20:47 | Guangdong, China | |||
2020-03-21 | China | Guangdong | 1400 | 8 | 1325 | 23.3417 | 113.4244 | 2020-03-21T12:43:08 | ||||
2021-02-03 | China | Guangdong | 2132 | 8 | 2078 | 46 | 23.3417 | 113.4244 | 2021-02-04 05:22:26 | Guangdong, China | ||
2020-09-14 | China | Guangdong | 1782 | 8 | 1755 | 19 | 23.3417 | 113.4244 | 2020-09-15 03:22:50 | Guangdong, China | ||
2022-12-14 | China | Guangdong | 55674 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-15 04:20:58 | Guangdong, China | |||
2021-03-11 | China | Guangdong | 2240 | 8 | 2189 | 43 | 23.3417 | 113.4244 | 2021-03-12 05:26:50 | Guangdong, China | ||
2022-03-11 | China | Guangdong | 5683 | 8 | 0 | 23.3417 | 113.4244 | 2022-03-12 04:20:50 | Guangdong, China | |||
2022-05-07 | China | Guangdong | 7166 | 8 | 0 | 23.3417 | 113.4244 | 2022-05-08 04:20:49 | Guangdong, China | |||
2020-07-16 | China | Guangdong | 1650 | 8 | 1636 | 6 | 23.3417 | 113.4244 | 2020-07-17 04:34:50 | Guangdong, China | ||
2020-08-08 | China | Guangdong | 1693 | 8 | 1669 | 16 | 23.3417 | 113.4244 | 2020-08-09 04:34:54 | Guangdong, China | ||
2022-09-13 | China | Guangdong | 9716 | 8 | 0 | 23.3417 | 113.4244 | 2022-09-14 04:20:44 | Guangdong, China | |||
2020-11-06 | China | Guangdong | 1943 | 8 | 1902 | 33 | 23.3417 | 113.4244 | 2020-11-07 05:24:52 | Guangdong, China | ||
2021-04-30 | China | Guangdong | 2344 | 8 | 2287 | 49 | 23.3417 | 113.4244 | 2021-05-01 04:20:47 | Guangdong, China | ||
2022-09-23 | China | Guangdong | 9863 | 8 | 0 | 23.3417 | 113.4244 | 2022-09-24 04:21:40 | Guangdong, China | |||
2021-04-04 | China | Guangdong | 2287 | 8 | 2239 | 40 | 23.3417 | 113.4244 | 2021-04-05 04:20:35 | Guangdong, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;