johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where province_or_state = "Guangdong" sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, active, day (date), last_update (date)
country_or_region 2
- China 1,024
- Mainland China 49
province_or_state 1
- Guangdong · 1,073 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
117 | 117 | 2021-12-02 | China | Guangdong | 3318 | 8 | 0 | 23.3417 | 113.4244 | 2021-12-03 04:23:05 | Guangdong, China | |||
4133 | 4133 | 2021-10-28 | China | Guangdong | 3221 | 8 | 0 | 23.3417 | 113.4244 | 2021-10-29 04:22:03 | Guangdong, China | |||
16158 | 16158 | 2021-09-18 | China | Guangdong | 3142 | 8 | 0 | 23.3417 | 113.4244 | 2021-09-19 04:21:34 | Guangdong, China | |||
24188 | 24188 | 2022-03-20 | China | Guangdong | 6424 | 8 | 0 | 23.3417 | 113.4244 | 2022-03-21 04:20:50 | Guangdong, China | |||
28203 | 28203 | 2021-11-11 | China | Guangdong | 3251 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-12 04:22:01 | Guangdong, China | |||
32219 | 32219 | 2021-08-25 | China | Guangdong | 3032 | 8 | 0 | 23.3417 | 113.4244 | 2021-08-26 04:21:28 | Guangdong, China | |||
43495 | 43495 | 2021-11-02 | China | Guangdong | 3230 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-03 06:22:09 | Guangdong, China | |||
62849 | 62849 | 2022-11-12 | China | Guangdong | 16859 | 8 | 0 | 23.3417 | 113.4244 | 2022-11-13 04:21:14 | Guangdong, China | |||
66864 | 66864 | 2021-09-01 | China | Guangdong | 3074 | 8 | 0 | 23.3417 | 113.4244 | 2021-09-02 04:21:15 | Guangdong, China | |||
70878 | 70878 | 2022-02-07 | China | Guangdong | 3859 | 8 | 0 | 23.3417 | 113.4244 | 2022-02-08 04:21:15 | Guangdong, China | |||
86912 | 86912 | 2021-11-09 | China | Guangdong | 3248 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-10 04:21:38 | Guangdong, China | |||
90929 | 90929 | 2022-07-23 | China | Guangdong | 7988 | 8 | 0 | 23.3417 | 113.4244 | 2022-07-24 04:20:47 | Guangdong, China | |||
99113 | 99113 | 2022-01-14 | China | Guangdong | 3625 | 8 | 0 | 23.3417 | 113.4244 | 2022-01-15 04:21:07 | Guangdong, China | |||
103129 | 103129 | 2021-08-15 | China | Guangdong | 2968 | 8 | 0 | 23.3417 | 113.4244 | 2021-08-16 04:21:31 | Guangdong, China | |||
114539 | 114539 | 2022-09-06 | China | Guangdong | 9474 | 8 | 0 | 23.3417 | 113.4244 | 2022-09-07 04:20:59 | Guangdong, China | |||
126520 | 126520 | 2022-01-09 | China | Guangdong | 3539 | 8 | 0 | 23.3417 | 113.4244 | 2022-01-10 04:22:07 | Guangdong, China | |||
130537 | 130537 | 2022-10-04 | China | Guangdong | 10229 | 8 | 0 | 23.3417 | 113.4244 | 2022-10-05 04:23:06 | Guangdong, China | |||
137758 | 137758 | 2021-12-04 | China | Guangdong | 3323 | 8 | 0 | 23.3417 | 113.4244 | 2021-12-05 04:22:25 | Guangdong, China | |||
141775 | 141775 | 2022-07-09 | China | Guangdong | 7566 | 8 | 0 | 23.3417 | 113.4244 | 2022-07-10 04:20:54 | Guangdong, China | |||
149771 | 149771 | 2021-11-29 | China | Guangdong | 3310 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-30 04:22:53 | Guangdong, China | |||
157800 | 157800 | 2022-03-29 | China | Guangdong | 6572 | 8 | 0 | 23.3417 | 113.4244 | 2022-03-30 04:20:45 | Guangdong, China | |||
161815 | 161815 | 2021-11-19 | China | Guangdong | 3269 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-20 04:22:17 | Guangdong, China | |||
165832 | 165832 | 2022-06-21 | China | Guangdong | 7385 | 8 | 0 | 23.3417 | 113.4244 | 2022-06-22 04:20:54 | Guangdong, China | |||
177829 | 177829 | 2021-09-02 | China | Guangdong | 3079 | 8 | 0 | 23.3417 | 113.4244 | 2021-09-03 04:21:20 | Guangdong, China | |||
185858 | 185858 | 2022-02-13 | China | Guangdong | 3973 | 8 | 0 | 23.3417 | 113.4244 | 2022-02-14 04:20:51 | Guangdong, China | |||
198046 | 198046 | 2022-10-19 | China | Guangdong | 11086 | 8 | 0 | 23.3417 | 113.4244 | 2022-10-20 04:22:59 | Guangdong, China | |||
217767 | 217767 | 2022-12-26 | China | Guangdong | 63739 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-27 04:21:07 | Guangdong, China | |||
221783 | 221783 | 2022-05-09 | China | Guangdong | 7218 | 8 | 0 | 23.3417 | 113.4244 | 2022-05-10 04:20:50 | Guangdong, China | |||
229014 | 229014 | 2022-05-31 | China | Guangdong | 7303 | 8 | 0 | 23.3417 | 113.4244 | 2022-06-01 04:20:55 | Guangdong, China | |||
233030 | 233030 | 2022-02-11 | China | Guangdong | 3925 | 8 | 0 | 23.3417 | 113.4244 | 2022-02-12 04:21:06 | Guangdong, China | |||
245072 | 245072 | 2021-08-17 | China | Guangdong | 2978 | 8 | 0 | 23.3417 | 113.4244 | 2021-08-18 04:21:35 | Guangdong, China | |||
249086 | 249086 | 2021-09-04 | China | Guangdong | 3087 | 8 | 0 | 23.3417 | 113.4244 | 2021-09-05 04:21:33 | Guangdong, China | |||
253101 | 253101 | 2022-09-08 | China | Guangdong | 9559 | 8 | 0 | 23.3417 | 113.4244 | 2022-09-09 04:21:11 | Guangdong, China | |||
257117 | 257117 | 2022-12-10 | China | Guangdong | 52928 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-11 04:20:50 | Guangdong, China | |||
261320 | 261320 | 2022-03-15 | China | Guangdong | 6048 | 8 | 0 | 23.3417 | 113.4244 | 2022-03-16 04:20:50 | Guangdong, China | |||
275970 | 275970 | 2021-11-03 | China | Guangdong | 3233 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-04 04:22:20 | Guangdong, China | |||
287783 | 287783 | 2021-10-31 | China | Guangdong | 3224 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-01 04:22:01 | Guangdong, China | |||
291800 | 291800 | 2022-11-15 | China | Guangdong | 18778 | 8 | 0 | 23.3417 | 113.4244 | 2022-11-16 04:21:09 | Guangdong, China | |||
303656 | 303656 | 2022-04-16 | China | Guangdong | 6879 | 8 | 0 | 23.3417 | 113.4244 | 2022-04-17 04:20:59 | Guangdong, China | |||
307672 | 307672 | 2022-12-13 | China | Guangdong | 55674 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-14 04:21:04 | Guangdong, China | |||
311688 | 311688 | 2022-11-13 | China | Guangdong | 17585 | 8 | 0 | 23.3417 | 113.4244 | 2022-11-14 04:21:09 | Guangdong, China | |||
315704 | 315704 | 2022-02-12 | China | Guangdong | 3945 | 8 | 0 | 23.3417 | 113.4244 | 2022-02-13 04:21:00 | Guangdong, China | |||
319720 | 319720 | 2022-10-30 | China | Guangdong | 11585 | 8 | 0 | 23.3417 | 113.4244 | 2022-10-31 04:21:36 | Guangdong, China | |||
327694 | 327694 | 2022-12-27 | China | Guangdong | 63739 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-28 04:21:04 | Guangdong, China | |||
335724 | 335724 | 2022-03-18 | China | Guangdong | 6306 | 8 | 0 | 23.3417 | 113.4244 | 2022-03-19 04:20:47 | Guangdong, China | |||
348084 | 348084 | 2022-12-14 | China | Guangdong | 55674 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-15 04:20:58 | Guangdong, China | |||
356114 | 356114 | 2022-03-11 | China | Guangdong | 5683 | 8 | 0 | 23.3417 | 113.4244 | 2022-03-12 04:20:50 | Guangdong, China | |||
360130 | 360130 | 2022-05-07 | China | Guangdong | 7166 | 8 | 0 | 23.3417 | 113.4244 | 2022-05-08 04:20:49 | Guangdong, China | |||
371984 | 371984 | 2022-09-13 | China | Guangdong | 9716 | 8 | 0 | 23.3417 | 113.4244 | 2022-09-14 04:20:44 | Guangdong, China | |||
384011 | 384011 | 2022-09-23 | China | Guangdong | 9863 | 8 | 0 | 23.3417 | 113.4244 | 2022-09-24 04:21:40 | Guangdong, China | |||
396052 | 396052 | 2022-10-07 | China | Guangdong | 10410 | 8 | 0 | 23.3417 | 113.4244 | 2022-10-08 04:22:56 | Guangdong, China | |||
404081 | 404081 | 2021-12-07 | China | Guangdong | 3330 | 8 | 0 | 23.3417 | 113.4244 | 2021-12-08 04:22:46 | Guangdong, China | |||
419123 | 419123 | 2022-09-18 | China | Guangdong | 9783 | 8 | 0 | 23.3417 | 113.4244 | 2022-09-19 04:21:49 | Guangdong, China | |||
423138 | 423138 | 2021-10-10 | China | Guangdong | 3195 | 8 | 0 | 23.3417 | 113.4244 | 2021-10-11 04:21:31 | Guangdong, China | |||
431145 | 431145 | 2022-11-03 | China | Guangdong | 12591 | 8 | 0 | 23.3417 | 113.4244 | 2022-11-04 04:22:11 | Guangdong, China | |||
443142 | 443142 | 2021-10-20 | China | Guangdong | 3208 | 8 | 0 | 23.3417 | 113.4244 | 2021-10-21 04:21:18 | Guangdong, China | |||
447158 | 447158 | 2021-11-17 | China | Guangdong | 3264 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-18 04:21:33 | Guangdong, China | |||
451175 | 451175 | 2022-12-21 | China | Guangdong | 63739 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-22 04:20:56 | Guangdong, China | |||
459167 | 459167 | 2022-02-02 | China | Guangdong | 3785 | 8 | 0 | 23.3417 | 113.4244 | 2022-02-03 04:21:21 | Guangdong, China | |||
463184 | 463184 | 2022-05-02 | China | Guangdong | 7091 | 8 | 0 | 23.3417 | 113.4244 | 2022-05-03 04:21:00 | Guangdong, China | |||
467199 | 467199 | 2021-10-07 | China | Guangdong | 3193 | 8 | 0 | 23.3417 | 113.4244 | 2021-10-08 04:21:25 | Guangdong, China | |||
475230 | 475230 | 2022-06-26 | China | Guangdong | 7431 | 8 | 0 | 23.3417 | 113.4244 | 2022-06-27 04:21:00 | Guangdong, China | |||
479378 | 479378 | 2022-11-08 | China | Guangdong | 14265 | 8 | 0 | 23.3417 | 113.4244 | 2022-11-09 04:21:22 | Guangdong, China | |||
487408 | 487408 | 2022-11-25 | China | Guangdong | 30147 | 8 | 0 | 23.3417 | 113.4244 | 2022-11-26 04:21:11 | Guangdong, China | |||
491423 | 491423 | 2021-10-14 | China | Guangdong | 3199 | 8 | 0 | 23.3417 | 113.4244 | 2021-10-15 04:21:26 | Guangdong, China | |||
495439 | 495439 | 2021-11-06 | China | Guangdong | 3240 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-07 04:21:53 | Guangdong, China | |||
499456 | 499456 | 2022-04-02 | China | Guangdong | 6608 | 8 | 0 | 23.3417 | 113.4244 | 2022-04-03 04:20:48 | Guangdong, China | |||
503472 | 503472 | 2022-12-17 | China | Guangdong | 58258 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-18 04:21:03 | Guangdong, China | |||
507487 | 507487 | 2021-08-14 | China | Guangdong | 2963 | 8 | 0 | 23.3417 | 113.4244 | 2021-08-15 04:21:41 | Guangdong, China | |||
511501 | 511501 | 2021-08-19 | China | Guangdong | 2997 | 8 | 0 | 23.3417 | 113.4244 | 2021-08-20 04:21:33 | Guangdong, China | |||
515516 | 515516 | 2022-10-15 | China | Guangdong | 10896 | 8 | 0 | 23.3417 | 113.4244 | 2022-10-16 04:22:39 | Guangdong, China | |||
534523 | 534523 | 2021-10-27 | China | Guangdong | 3217 | 8 | 0 | 23.3417 | 113.4244 | 2021-10-28 04:22:08 | Guangdong, China | |||
538540 | 538540 | 2022-10-26 | China | Guangdong | 11373 | 8 | 0 | 23.3417 | 113.4244 | 2022-10-27 04:22:01 | Guangdong, China | |||
542556 | 542556 | 2022-12-15 | China | Guangdong | 55674 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-16 04:21:01 | Guangdong, China | |||
550561 | 550561 | 2021-12-08 | China | Guangdong | 3333 | 8 | 0 | 23.3417 | 113.4244 | 2021-12-09 04:22:49 | Guangdong, China | |||
554577 | 554577 | 2022-01-16 | China | Guangdong | 3657 | 8 | 0 | 23.3417 | 113.4244 | 2022-01-17 04:21:08 | Guangdong, China | |||
558594 | 558594 | 2022-06-16 | China | Guangdong | 7361 | 8 | 0 | 23.3417 | 113.4244 | 2022-06-17 04:20:56 | Guangdong, China | |||
566891 | 566891 | 2021-10-29 | China | Guangdong | 3223 | 8 | 0 | 23.3417 | 113.4244 | 2021-10-30 04:22:03 | Guangdong, China | |||
574620 | 574620 | 2022-02-25 | China | Guangdong | 4434 | 8 | 0 | 23.3417 | 113.4244 | 2022-02-26 04:21:12 | Guangdong, China | |||
589431 | 589431 | 2021-08-08 | China | Guangdong | 2923 | 8 | 0 | 23.3417 | 113.4244 | 2021-08-09 04:21:24 | Guangdong, China | |||
593446 | 593446 | 2022-07-01 | China | Guangdong | 7458 | 8 | 0 | 23.3417 | 113.4244 | 2022-07-02 04:21:16 | Guangdong, China | |||
597461 | 597461 | 2021-10-19 | China | Guangdong | 3207 | 8 | 0 | 23.3417 | 113.4244 | 2021-10-20 04:21:00 | Guangdong, China | |||
601477 | 601477 | 2021-09-23 | China | Guangdong | 3150 | 8 | 0 | 23.3417 | 113.4244 | 2021-09-24 04:21:44 | Guangdong, China | |||
617650 | 617650 | 2022-11-05 | China | Guangdong | 13092 | 8 | 0 | 23.3417 | 113.4244 | 2022-11-06 04:21:24 | Guangdong, China | |||
621666 | 621666 | 2022-05-22 | China | Guangdong | 7288 | 8 | 0 | 23.3417 | 113.4244 | 2022-05-26 04:20:50 | Guangdong, China | |||
629696 | 629696 | 2022-07-12 | China | Guangdong | 7651 | 8 | 0 | 23.3417 | 113.4244 | 2022-07-13 04:20:58 | Guangdong, China | |||
633711 | 633711 | 2021-10-13 | China | Guangdong | 3199 | 8 | 0 | 23.3417 | 113.4244 | 2021-10-14 04:21:29 | Guangdong, China | |||
641741 | 641741 | 2021-09-07 | China | Guangdong | 3100 | 8 | 0 | 23.3417 | 113.4244 | 2021-09-08 04:21:31 | Guangdong, China | |||
649769 | 649769 | 2021-08-09 | China | Guangdong | 2931 | 8 | 0 | 23.3417 | 113.4244 | 2021-08-10 04:21:27 | Guangdong, China | |||
653783 | 653783 | 2021-10-22 | China | Guangdong | 3210 | 8 | 0 | 23.3417 | 113.4244 | 2021-10-23 04:21:32 | Guangdong, China | |||
658102 | 658102 | 2022-05-13 | China | Guangdong | 7255 | 8 | 0 | 23.3417 | 113.4244 | 2022-05-14 04:20:48 | Guangdong, China | |||
670087 | 670087 | 2022-07-21 | China | Guangdong | 7933 | 8 | 0 | 23.3417 | 113.4244 | 2022-07-22 04:21:15 | Guangdong, China | |||
674103 | 674103 | 2022-07-30 | China | Guangdong | 8109 | 8 | 0 | 23.3417 | 113.4244 | 2022-07-31 04:21:02 | Guangdong, China | |||
682128 | 682128 | 2021-10-24 | China | Guangdong | 3211 | 8 | 0 | 23.3417 | 113.4244 | 2021-10-25 04:22:31 | Guangdong, China | |||
686144 | 686144 | 2021-11-13 | China | Guangdong | 3253 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-14 04:21:31 | Guangdong, China | |||
690161 | 690161 | 2022-12-23 | China | Guangdong | 63739 | 8 | 0 | 23.3417 | 113.4244 | 2022-12-24 04:21:02 | Guangdong, China | |||
694177 | 694177 | 2022-03-17 | China | Guangdong | 6241 | 8 | 0 | 23.3417 | 113.4244 | 2022-03-18 04:20:55 | Guangdong, China | |||
698192 | 698192 | 2021-11-04 | China | Guangdong | 3234 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-05 04:21:54 | Guangdong, China | |||
706222 | 706222 | 2021-09-29 | China | Guangdong | 3171 | 8 | 0 | 23.3417 | 113.4244 | 2021-09-30 04:21:20 | Guangdong, China | |||
710238 | 710238 | 2022-11-01 | China | Guangdong | 12133 | 8 | 0 | 23.3417 | 113.4244 | 2022-11-02 04:22:09 | Guangdong, 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]);