johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where province_or_state = "Beijing" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, day (date), last_update (date)
recovered 225 ✖
- 0 514
- 926 44
- 1046 33
- 1037 20
- 1038 20
- 584 17
- 927 14
- 929 12
- 581 11
- 940 10
- 1048 9
- 924 8
- 939 8
- 941 8
- 752 7
- 920 7
- 928 7
- 936 6
- 1033 6
- 1066 6
- 1067 6
- 578 5
- 583 5
- 938 5
- 944 5
- 1022 5
- 1063 5
- 585 4
- 932 4
- 937 4
- 951 4
- 977 4
- 1039 4
- 1051 4
- 1064 4
- 2 3
- 4 3
- 525 3
- 547 3
- 645 3
- 923 3
- 1034 3
- 1043 3
- 1045 3
- 1057 3
- 1060 3
- 1061 3
- 9 2
- 297 2
- 401 2
- 418 2
- 509 2
- 560 2
- 574 2
- 596 2
- 694 2
- 917 2
- 919 2
- 931 2
- 933 2
- 947 2
- 964 2
- 965 2
- 973 2
- 998 2
- 1012 2
- 1029 2
- 1047 2
- 1052 2
- 1055 2
- 1068 2
- 1 1
- 5 1
- 12 1
- 23 1
- 24 1
- 31 1
- 33 1
- 34 1
- 37 1
- 44 1
- 48 1
- 56 1
- 69 1
- 80 1
- 98 1
- 108 1
- 114 1
- 122 1
- 145 1
- 153 1
- 169 1
- 178 1
- 189 1
- 198 1
- 215 1
- 235 1
- 248 1
- 257 1
- 271 1
- 276 1
- 282 1
- 288 1
- 299 1
- 303 1
- 308 1
- 315 1
- 320 1
- 326 1
- 334 1
- 342 1
- 349 1
- 353 1
- 360 1
- 369 1
- 378 1
- 380 1
- 390 1
- 396 1
- 400 1
- 403 1
- 406 1
- 408 1
- 410 1
- 412 1
- 415 1
- 424 1
- 434 1
- 438 1
- 441 1
- 443 1
- 448 1
- 455 1
- 464 1
- 469 1
- 474 1
- 479 1
- 484 1
- 491 1
- 495 1
- 503 1
- 510 1
- 514 1
- 516 1
- 518 1
- 524 1
- 536 1
- 538 1
- 542 1
- 553 1
- 554 1
- 555 1
- 557 1
- 565 1
- 568 1
- 571 1
- 573 1
- 576 1
- 577 1
- 579 1
- 586 1
- 587 1
- 589 1
- 592 1
- 594 1
- 595 1
- 613 1
- 680 1
- 729 1
- 841 1
- 855 1
- 867 1
- 878 1
- 881 1
- 895 1
- 896 1
- 901 1
- 911 1
- 915 1
- 918 1
- 922 1
- 935 1
- 943 1
- 945 1
- 948 1
- 950 1
- 955 1
- 957 1
- 958 1
- 959 1
- 960 1
- 962 1
- 966 1
- 968 1
- 972 1
- 976 1
- 978 1
- 980 1
- 983 1
- 986 1
- 988 1
- 991 1
- 994 1
- 997 1
- 1001 1
- 1003 1
- 1004 1
- 1005 1
- 1011 1
- 1014 1
- 1016 1
- 1019 1
- 1020 1
- 1024 1
- 1026 1
- 1027 1
- 1032 1
- 1040 1
- 1041 1
- 1050 1
- 1054 1
- 1058 1
- 1059 1
- 1062 1
- 1065 1
country_or_region 2
- China 1,024
- Mainland China 49
province_or_state 1
- Beijing · 1,073 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752687 | 2752687 | 2022-12-29 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-30 04:21:04 | Beijing, China | |||
1073693 | 1073693 | 2022-12-28 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-29 04:21:01 | Beijing, China | |||
327690 | 327690 | 2022-12-27 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-28 04:21:04 | Beijing, China | |||
217763 | 217763 | 2022-12-26 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-27 04:21:07 | Beijing, China | |||
3222220 | 3222220 | 2022-12-25 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-26 04:21:06 | Beijing, China | |||
1018134 | 1018134 | 2022-12-24 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-25 04:21:04 | Beijing, China | |||
690157 | 690157 | 2022-12-23 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-24 04:21:02 | Beijing, China | |||
2179367 | 2179367 | 2022-12-22 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-23 04:21:04 | Beijing, China | |||
451171 | 451171 | 2022-12-21 | China | Beijing | 28860 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-22 04:20:56 | Beijing, China | |||
2951170 | 2951170 | 2022-12-20 | China | Beijing | 27845 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-21 04:21:03 | Beijing, China | |||
3173572 | 3173572 | 2022-12-19 | China | Beijing | 27845 | 20 | 0 | 40.1824 | 116.4142 | 2022-12-20 04:21:04 | Beijing, China | |||
1628089 | 1628089 | 2022-12-18 | China | Beijing | 27063 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-19 04:21:03 | Beijing, China | |||
503468 | 503468 | 2022-12-17 | China | Beijing | 26660 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-18 04:21:03 | Beijing, China | |||
3324040 | 3324040 | 2022-12-16 | China | Beijing | 25249 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-17 04:21:04 | Beijing, China | |||
542552 | 542552 | 2022-12-15 | China | Beijing | 25249 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-16 04:21:01 | Beijing, China | |||
348080 | 348080 | 2022-12-14 | China | Beijing | 25249 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-15 04:20:58 | Beijing, China | |||
307668 | 307668 | 2022-12-13 | China | Beijing | 25249 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-14 04:21:04 | Beijing, China | |||
1148729 | 1148729 | 2022-12-12 | China | Beijing | 24767 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-13 04:21:01 | Beijing, China | |||
868583 | 868583 | 2022-12-11 | China | Beijing | 24200 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-12 04:21:01 | Beijing, China | |||
257113 | 257113 | 2022-12-10 | China | Beijing | 23667 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-11 04:20:50 | Beijing, China | |||
3935827 | 3935827 | 2022-12-09 | China | Beijing | 22879 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-10 04:21:02 | Beijing, China | |||
3377159 | 3377159 | 2022-12-08 | China | Beijing | 21951 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-09 04:21:05 | Beijing, China | |||
1984430 | 1984430 | 2022-12-07 | China | Beijing | 20761 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-08 04:21:07 | Beijing, China | |||
3713953 | 3713953 | 2022-12-06 | China | Beijing | 18401 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-07 04:20:58 | Beijing, China | |||
2414658 | 2414658 | 2022-12-05 | China | Beijing | 18401 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-06 04:21:03 | Beijing, China | |||
718266 | 718266 | 2022-12-04 | China | Beijing | 17236 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-05 04:20:58 | Beijing, China | |||
2816555 | 2816555 | 2022-12-03 | China | Beijing | 16205 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-04 04:20:56 | Beijing, China | |||
833411 | 833411 | 2022-12-02 | China | Beijing | 15493 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-03 04:21:02 | Beijing, China | |||
2135941 | 2135941 | 2022-12-01 | China | Beijing | 14788 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-02 04:21:07 | Beijing, China | |||
1964357 | 1964357 | 2022-11-30 | China | Beijing | 13840 | 13 | 0 | 40.1824 | 116.4142 | 2022-12-01 04:21:03 | Beijing, China | |||
2556371 | 2556371 | 2022-11-29 | China | Beijing | 11520 | 13 | 0 | 40.1824 | 116.4142 | 2022-11-30 04:21:07 | Beijing, China | |||
1239445 | 1239445 | 2022-11-28 | China | Beijing | 11520 | 13 | 0 | 40.1824 | 116.4142 | 2022-11-29 04:21:05 | Beijing, China | |||
3551433 | 3551433 | 2022-11-27 | China | Beijing | 10547 | 13 | 0 | 40.1824 | 116.4142 | 2022-11-28 04:21:02 | Beijing, China | |||
2099913 | 2099913 | 2022-11-26 | China | Beijing | 9691 | 13 | 0 | 40.1824 | 116.4142 | 2022-11-27 04:21:05 | Beijing, China | |||
487404 | 487404 | 2022-11-25 | China | Beijing | 8941 | 13 | 0 | 40.1824 | 116.4142 | 2022-11-26 04:21:11 | Beijing, China | |||
3523233 | 3523233 | 2022-11-24 | China | Beijing | 8354 | 13 | 0 | 40.1824 | 116.4142 | 2022-11-25 04:21:06 | Beijing, China | |||
3312016 | 3312016 | 2022-11-23 | China | Beijing | 7922 | 13 | 0 | 40.1824 | 116.4142 | 2022-11-24 04:21:09 | Beijing, China | |||
1620057 | 1620057 | 2022-11-22 | China | Beijing | 7405 | 12 | 0 | 40.1824 | 116.4142 | 2022-11-23 04:21:06 | Beijing, China | |||
3459945 | 3459945 | 2022-11-21 | China | Beijing | 7009 | 12 | 0 | 40.1824 | 116.4142 | 2022-11-22 04:20:47 | Beijing, China | |||
1640130 | 1640130 | 2022-11-20 | China | Beijing | 6735 | 12 | 0 | 40.1824 | 116.4142 | 2022-11-21 04:21:05 | Beijing, China | |||
2063687 | 2063687 | 2022-11-19 | China | Beijing | 6578 | 10 | 0 | 40.1824 | 116.4142 | 2022-11-20 04:21:08 | Beijing, China | |||
1755081 | 1755081 | 2022-11-18 | China | Beijing | 6504 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-19 04:21:14 | Beijing, China | |||
3026074 | 3026074 | 2022-11-17 | China | Beijing | 6420 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-18 04:21:15 | Beijing, China | |||
2485785 | 2485785 | 2022-11-16 | China | Beijing | 6319 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-17 04:21:11 | Beijing, China | |||
291796 | 291796 | 2022-11-15 | China | Beijing | 6147 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-16 04:21:09 | Beijing, China | |||
3596826 | 3596826 | 2022-11-14 | China | Beijing | 5945 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-15 04:21:16 | Beijing, China | |||
311684 | 311684 | 2022-11-13 | China | Beijing | 5643 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-14 04:21:09 | Beijing, China | |||
62845 | 62845 | 2022-11-12 | China | Beijing | 5403 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-13 04:21:14 | Beijing, China | |||
2927007 | 2927007 | 2022-11-11 | China | Beijing | 5241 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-12 04:20:41 | Beijing, China | |||
2505843 | 2505843 | 2022-11-10 | China | Beijing | 5171 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-11 04:21:22 | Beijing, China | |||
2430718 | 2430718 | 2022-11-09 | China | Beijing | 5107 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-10 04:21:16 | Beijing, China | |||
479374 | 479374 | 2022-11-08 | China | Beijing | 5069 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-09 04:21:22 | Beijing, China | |||
2438524 | 2438524 | 2022-11-07 | China | Beijing | 5031 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-08 04:21:21 | Beijing, China | |||
1049622 | 1049622 | 2022-11-06 | China | Beijing | 4995 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-07 04:21:26 | Beijing, China | |||
617646 | 617646 | 2022-11-05 | China | Beijing | 4951 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-06 04:21:24 | Beijing, China | |||
1022150 | 1022150 | 2022-11-04 | China | Beijing | 4902 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-05 04:21:52 | Beijing, China | |||
431141 | 431141 | 2022-11-03 | China | Beijing | 4861 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-04 04:22:11 | Beijing, China | |||
849383 | 849383 | 2022-11-02 | China | Beijing | 4823 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-03 04:22:05 | Beijing, China | |||
710234 | 710234 | 2022-11-01 | China | Beijing | 4756 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-02 04:22:09 | Beijing, China | |||
3284683 | 3284683 | 2022-10-31 | China | Beijing | 4723 | 9 | 0 | 40.1824 | 116.4142 | 2022-11-01 04:22:36 | Beijing, China | |||
319716 | 319716 | 2022-10-30 | China | Beijing | 4705 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-31 04:21:36 | Beijing, China | |||
911992 | 911992 | 2022-10-29 | China | Beijing | 4688 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-30 04:22:14 | Beijing, China | |||
1366261 | 1366261 | 2022-10-28 | China | Beijing | 4663 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-29 04:21:13 | Beijing, China | |||
3038116 | 3038116 | 2022-10-27 | China | Beijing | 4663 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-28 04:22:31 | Beijing, China | |||
538536 | 538536 | 2022-10-26 | China | Beijing | 4652 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-27 04:22:01 | Beijing, China | |||
1829937 | 1829937 | 2022-10-25 | China | Beijing | 4637 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-26 04:22:19 | Beijing, China | |||
794198 | 794198 | 2022-10-24 | China | Beijing | 4611 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-25 04:21:53 | Beijing, China | |||
3276653 | 3276653 | 2022-10-23 | China | Beijing | 4592 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-24 04:22:29 | Beijing, China | |||
2267691 | 2267691 | 2022-10-22 | China | Beijing | 4578 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-23 04:22:46 | Beijing, China | |||
1591991 | 1591991 | 2022-10-21 | China | Beijing | 4567 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-22 04:22:53 | Beijing, China | |||
2271707 | 2271707 | 2022-10-20 | China | Beijing | 4542 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-21 04:22:23 | Beijing, China | |||
198042 | 198042 | 2022-10-19 | China | Beijing | 4524 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-20 04:22:59 | Beijing, China | |||
2756703 | 2756703 | 2022-10-18 | China | Beijing | 4505 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-19 04:22:26 | Beijing, China | |||
2024537 | 2024537 | 2022-10-17 | China | Beijing | 4468 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-18 04:22:42 | Beijing, China | |||
2159315 | 2159315 | 2022-10-16 | China | Beijing | 4451 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-17 04:20:31 | Beijing, China | |||
515512 | 515512 | 2022-10-15 | China | Beijing | 4432 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-16 04:22:39 | Beijing, China | |||
2032569 | 2032569 | 2022-10-14 | China | Beijing | 4404 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-15 04:22:00 | Beijing, China | |||
3753257 | 3753257 | 2022-10-13 | China | Beijing | 4382 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-14 04:22:28 | Beijing, China | |||
3214082 | 3214082 | 2022-10-12 | China | Beijing | 4364 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-13 04:22:39 | Beijing, China | |||
3249931 | 3249931 | 2022-10-11 | China | Beijing | 4350 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-12 04:22:51 | Beijing, China | |||
2967190 | 2967190 | 2022-10-10 | China | Beijing | 4337 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-11 04:23:05 | Beijing, China | |||
3097226 | 3097226 | 2022-10-09 | China | Beijing | 4321 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-10 04:22:32 | Beijing, China | |||
4002451 | 4002451 | 2022-10-08 | China | Beijing | 4303 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-09 04:21:16 | Beijing, China | |||
396048 | 396048 | 2022-10-07 | China | Beijing | 4288 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-08 04:22:56 | Beijing, China | |||
2529165 | 2529165 | 2022-10-06 | China | Beijing | 4278 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-07 04:23:08 | Beijing, China | |||
1810559 | 1810559 | 2022-10-05 | China | Beijing | 4268 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-06 04:21:22 | Beijing, China | |||
130533 | 130533 | 2022-10-04 | China | Beijing | 4258 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-05 04:23:06 | Beijing, China | |||
2685480 | 2685480 | 2022-10-03 | China | Beijing | 4250 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-04 04:22:55 | Beijing, China | |||
2259547 | 2259547 | 2022-10-02 | China | Beijing | 4240 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-03 04:23:11 | Beijing, China | |||
2995073 | 2995073 | 2022-10-01 | China | Beijing | 4234 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-02 04:21:23 | Beijing, China | |||
853399 | 853399 | 2022-09-30 | China | Beijing | 4227 | 9 | 0 | 40.1824 | 116.4142 | 2022-10-01 04:23:01 | Beijing, China | |||
2375325 | 2375325 | 2022-09-29 | China | Beijing | 4221 | 9 | 0 | 40.1824 | 116.4142 | 2022-09-30 04:23:09 | Beijing, China | |||
1559876 | 1559876 | 2022-09-28 | China | Beijing | 4215 | 9 | 0 | 40.1824 | 116.4142 | 2022-09-29 04:22:34 | Beijing, China | |||
3994419 | 3994419 | 2022-09-27 | China | Beijing | 4210 | 9 | 0 | 40.1824 | 116.4142 | 2022-09-28 04:23:01 | Beijing, China | |||
2768747 | 2768747 | 2022-09-26 | China | Beijing | 4208 | 9 | 0 | 40.1824 | 116.4142 | 2022-09-27 04:23:01 | Beijing, China | |||
1976400 | 1976400 | 2022-09-25 | China | Beijing | 4196 | 9 | 0 | 40.1824 | 116.4142 | 2022-09-26 04:20:52 | Beijing, China | |||
2649567 | 2649567 | 2022-09-24 | China | Beijing | 4193 | 9 | 0 | 40.1824 | 116.4142 | 2022-09-25 04:23:31 | Beijing, China | |||
384007 | 384007 | 2022-09-23 | China | Beijing | 4186 | 9 | 0 | 40.1824 | 116.4142 | 2022-09-24 04:21:40 | Beijing, China | |||
1624073 | 1624073 | 2022-09-22 | China | Beijing | 4184 | 9 | 0 | 40.1824 | 116.4142 | 2022-09-23 04:23:13 | Beijing, China | |||
1370277 | 1370277 | 2022-09-21 | China | Beijing | 4181 | 9 | 0 | 40.1824 | 116.4142 | 2022-09-22 04:22:56 | Beijing, 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]);