johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,024 rows where country_or_region = "China" and province_or_state = "Beijing" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2728805 | 2728805 | 2020-09-15 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-16 04:22:53 | Beijing, China | ||
344077 | 344077 | 2020-09-14 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-15 03:22:50 | Beijing, China | ||
2868516 | 2868516 | 2020-09-13 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-14 04:26:00 | Beijing, China | ||
546555 | 546555 | 2020-09-12 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-13 04:30:52 | Beijing, China | ||
1444384 | 1444384 | 2020-09-11 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-12 04:25:05 | Beijing, China | ||
1172985 | 1172985 | 2020-09-10 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-11 04:46:23 | Beijing, China | ||
2171350 | 2171350 | 2020-09-09 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-10 04:29:01 | Beijing, China | ||
1243559 | 1243559 | 2020-09-08 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-09 04:28:48 | Beijing, China | ||
427138 | 427138 | 2020-09-07 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-08 04:28:25 | Beijing, China | ||
3161423 | 3161423 | 2020-09-06 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-07 04:28:30 | Beijing, China | ||
813378 | 813378 | 2020-09-05 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-06 04:28:33 | Beijing, China | ||
2661578 | 2661578 | 2020-09-04 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-05 04:28:19 | Beijing, China | ||
1354118 | 1354118 | 2020-09-03 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-04 04:28:26 | Beijing, China | ||
1105355 | 1105355 | 2020-09-02 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-03 04:28:22 | Beijing, China | ||
2059684 | 2059684 | 2020-09-01 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-02 04:28:25 | Beijing, China | ||
193869 | 193869 | 2020-08-31 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-09-01 04:28:31 | Beijing, China | ||
3931828 | 3931828 | 2020-08-30 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-08-31 04:28:27 | Beijing, China | ||
609490 | 609490 | 2020-08-29 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-08-30 04:28:22 | Beijing, China | ||
1522985 | 1522985 | 2020-08-28 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-08-29 04:28:19 | Beijing, China | ||
2509986 | 2509986 | 2020-08-27 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-08-28 04:28:11 | Beijing, China | ||
1996446 | 1996446 | 2020-08-26 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-08-27 04:28:15 | Beijing, China | ||
3562370 | 3562370 | 2020-08-25 | China | Beijing | 935 | 9 | 926 | 0 | 40.1824 | 116.4142 | 2020-08-26 04:28:11 | Beijing, China | ||
2991074 | 2991074 | 2020-08-24 | China | Beijing | 935 | 9 | 924 | 2 | 40.1824 | 116.4142 | 2020-08-25 04:28:02 | Beijing, China | ||
2215469 | 2215469 | 2020-08-23 | China | Beijing | 935 | 9 | 924 | 2 | 40.1824 | 116.4142 | 2020-08-24 04:27:56 | Beijing, China | ||
2299251 | 2299251 | 2020-08-22 | China | Beijing | 935 | 9 | 924 | 2 | 40.1824 | 116.4142 | 2020-08-23 04:27:48 | Beijing, China | ||
1479358 | 1479358 | 2020-08-21 | China | Beijing | 935 | 9 | 924 | 2 | 40.1824 | 116.4142 | 2020-08-22 04:27:49 | Beijing, China | ||
3484107 | 3484107 | 2020-08-20 | China | Beijing | 935 | 9 | 924 | 2 | 40.1824 | 116.4142 | 2020-08-21 04:27:41 | Beijing, China | ||
206056 | 206056 | 2020-08-19 | China | Beijing | 935 | 9 | 924 | 2 | 40.1824 | 116.4142 | 2020-08-20 04:27:43 | Beijing, China | ||
3177810 | 3177810 | 2020-08-18 | China | Beijing | 935 | 9 | 924 | 2 | 40.1824 | 116.4142 | 2020-08-19 04:27:00 | Beijing, China | ||
837414 | 837414 | 2020-08-17 | China | Beijing | 935 | 9 | 924 | 2 | 40.1824 | 116.4142 | 2020-08-18 04:27:56 | Beijing, China | ||
1555772 | 1555772 | 2020-08-16 | China | Beijing | 935 | 9 | 923 | 3 | 40.1824 | 116.4142 | 2020-08-17 04:27:20 | Beijing, China | ||
145774 | 145774 | 2020-08-15 | China | Beijing | 935 | 9 | 923 | 3 | 40.1824 | 116.4142 | 2020-08-16 04:27:42 | Beijing, China | ||
1612049 | 1612049 | 2020-08-14 | China | Beijing | 935 | 9 | 923 | 3 | 40.1824 | 116.4142 | 2020-08-15 04:27:31 | Beijing, China | ||
582633 | 582633 | 2020-08-13 | China | Beijing | 935 | 9 | 922 | 4 | 40.1824 | 116.4142 | 2020-08-14 04:51:19 | Beijing, China | ||
3531252 | 3531252 | 2020-08-12 | China | Beijing | 935 | 9 | 920 | 6 | 40.1824 | 116.4142 | 2020-08-13 04:29:15 | Beijing, China | ||
662101 | 662101 | 2020-08-11 | China | Beijing | 935 | 9 | 920 | 6 | 40.1824 | 116.4142 | 2020-08-12 04:27:29 | Beijing, China | ||
1920210 | 1920210 | 2020-08-10 | China | Beijing | 935 | 9 | 920 | 6 | 40.1824 | 116.4142 | 2020-08-11 04:35:08 | Beijing, China | ||
3923019 | 3923019 | 2020-08-09 | China | Beijing | 935 | 9 | 920 | 6 | 40.1824 | 116.4142 | 2020-08-10 04:34:55 | Beijing, China | ||
371187 | 371187 | 2020-08-08 | China | Beijing | 935 | 9 | 920 | 6 | 40.1824 | 116.4142 | 2020-08-09 04:34:54 | Beijing, China | ||
458371 | 458371 | 2020-08-07 | China | Beijing | 935 | 9 | 920 | 6 | 40.1824 | 116.4142 | 2020-08-08 04:34:53 | Beijing, China | ||
3612056 | 3612056 | 2020-08-06 | China | Beijing | 935 | 9 | 920 | 6 | 40.1824 | 116.4142 | 2020-08-07 04:35:11 | Beijing, China | ||
3792886 | 3792886 | 2020-08-05 | China | Beijing | 934 | 9 | 919 | 6 | 40.1824 | 116.4142 | 2020-08-06 04:35:02 | Beijing, China | ||
98122 | 98122 | 2020-08-04 | China | Beijing | 934 | 9 | 919 | 6 | 40.1824 | 116.4142 | 2020-08-05 04:34:43 | Beijing, China | ||
2740005 | 2740005 | 2020-08-03 | China | Beijing | 933 | 9 | 918 | 6 | 40.1824 | 116.4142 | 2020-08-04 04:41:59 | Beijing, China | ||
2807757 | 2807757 | 2020-08-02 | China | Beijing | 933 | 9 | 917 | 7 | 40.1824 | 116.4142 | 2020-08-03 04:34:35 | Beijing, China | ||
753325 | 753325 | 2020-08-01 | China | Beijing | 933 | 9 | 917 | 7 | 40.1824 | 116.4142 | 2020-08-02 04:34:47 | Beijing, China | ||
3264490 | 3264490 | 2020-07-31 | China | Beijing | 933 | 9 | 915 | 9 | 40.1824 | 116.4142 | 2020-08-01 04:36:27 | Beijing, China | ||
1928197 | 1928197 | 2020-07-30 | China | Beijing | 933 | 9 | 911 | 13 | 40.1824 | 116.4142 | 2020-07-31 04:35:18 | Beijing, China | ||
2958365 | 2958365 | 2020-07-29 | China | Beijing | 933 | 9 | 901 | 23 | 40.1824 | 116.4142 | 2020-07-30 04:35:05 | Beijing, China | ||
3184981 | 3184981 | 2020-07-28 | China | Beijing | 932 | 9 | 896 | 27 | 40.1824 | 116.4142 | 2020-07-29 04:35:11 | Beijing, China | ||
177033 | 177033 | 2020-07-27 | China | Beijing | 931 | 9 | 895 | 27 | 40.1824 | 116.4142 | 2020-07-28 04:58:43 | Beijing, China | ||
442346 | 442346 | 2020-07-26 | China | Beijing | 929 | 9 | 881 | 39 | 40.1824 | 116.4142 | 2020-07-27 04:35:02 | Beijing, China | ||
1502590 | 1502590 | 2020-07-25 | China | Beijing | 929 | 9 | 878 | 42 | 40.1824 | 116.4142 | 2020-07-26 04:35:00 | Beijing, China | ||
2563560 | 2563560 | 2020-07-24 | China | Beijing | 929 | 9 | 867 | 53 | 40.1824 | 116.4142 | 2020-07-25 04:47:39 | Beijing, China | ||
61789 | 61789 | 2020-07-23 | China | Beijing | 929 | 9 | 855 | 65 | 40.1824 | 116.4142 | 2020-07-24 05:30:40 | Beijing, China | ||
844580 | 844580 | 2020-07-22 | China | Beijing | 929 | 9 | 841 | 79 | 40.1824 | 116.4142 | 2020-07-23 05:15:04 | Beijing, China | ||
1707319 | 1707319 | 2020-07-21 | China | Beijing | 929 | 9 | 752 | 168 | 40.1824 | 116.4142 | 2020-07-22 04:34:42 | Beijing, China | ||
326810 | 326810 | 2020-07-20 | China | Beijing | 929 | 9 | 752 | 168 | 40.1824 | 116.4142 | 2020-07-21 04:38:46 | Beijing, China | ||
121715 | 121715 | 2020-07-19 | China | Beijing | 929 | 9 | 752 | 168 | 40.1824 | 116.4142 | 2020-07-20 05:34:40 | Beijing, China | ||
3205104 | 3205104 | 2020-07-18 | China | Beijing | 929 | 9 | 752 | 168 | 40.1824 | 116.4142 | 2020-07-19 04:34:58 | Beijing, China | ||
2708406 | 2708406 | 2020-07-17 | China | Beijing | 929 | 9 | 752 | 168 | 40.1824 | 116.4142 | 2020-07-18 04:34:45 | Beijing, China | ||
367225 | 367225 | 2020-07-16 | China | Beijing | 929 | 9 | 752 | 168 | 40.1824 | 116.4142 | 2020-07-17 04:34:50 | Beijing, China | ||
2747893 | 2747893 | 2020-07-15 | China | Beijing | 929 | 9 | 752 | 168 | 40.1824 | 116.4142 | 2020-07-16 04:44:59 | Beijing, China | ||
2158537 | 2158537 | 2020-07-14 | China | Beijing | 929 | 9 | 729 | 191 | 40.1824 | 116.4142 | 2020-07-15 04:34:39 | Beijing, China | ||
3491178 | 3491178 | 2020-07-13 | China | Beijing | 929 | 9 | 694 | 226 | 40.1824 | 116.4142 | 2020-07-14 04:34:46 | Beijing, China | ||
3737440 | 3737440 | 2020-07-12 | China | Beijing | 929 | 9 | 694 | 226 | 40.1824 | 116.4142 | 2020-07-13 04:43:04 | Beijing, China | ||
3435835 | 3435835 | 2020-07-11 | China | Beijing | 929 | 9 | 680 | 240 | 40.1824 | 116.4142 | 2020-07-12 04:34:30 | Beijing, China | ||
3237333 | 3237333 | 2020-07-10 | China | Beijing | 929 | 9 | 645 | 275 | 40.1824 | 116.4142 | 2020-07-11 04:34:26 | Beijing, China | ||
1005318 | 1005318 | 2020-07-09 | China | Beijing | 929 | 9 | 645 | 275 | 40.1824 | 116.4142 | 2020-07-10 04:34:24 | Beijing, China | ||
2222534 | 2222534 | 2020-07-08 | China | Beijing | 929 | 9 | 645 | 275 | 40.1824 | 116.4142 | 2020-07-09 04:34:23 | Beijing, China | ||
887143 | 887143 | 2020-07-07 | China | Beijing | 929 | 9 | 613 | 307 | 40.1824 | 116.4142 | 2020-07-08 05:33:48 | Beijing, China | ||
2684703 | 2684703 | 2020-07-06 | China | Beijing | 929 | 9 | 596 | 324 | 40.1824 | 116.4142 | 2020-07-07 04:34:00 | Beijing, China | ||
415168 | 415168 | 2020-07-05 | China | Beijing | 929 | 9 | 596 | 324 | 40.1824 | 116.4142 | 2020-07-06 04:33:57 | Beijing, China | ||
529730 | 529730 | 2020-07-04 | China | Beijing | 928 | 9 | 595 | 324 | 40.1824 | 116.4142 | 2020-07-05 04:33:46 | Beijing, China | ||
2234391 | 2234391 | 2020-07-03 | China | Beijing | 926 | 9 | 594 | 323 | 40.1824 | 116.4142 | 2020-07-04 04:33:51 | Beijing, China | ||
3045185 | 3045185 | 2020-07-02 | China | Beijing | 925 | 9 | 592 | 324 | 40.1824 | 116.4142 | 2020-07-03 04:33:54 | Beijing, China | ||
302876 | 302876 | 2020-07-01 | China | Beijing | 923 | 9 | 589 | 325 | 40.1824 | 116.4142 | 2020-07-02 04:33:46 | Beijing, China | ||
2974254 | 2974254 | 2020-06-30 | China | Beijing | 922 | 9 | 587 | 326 | 40.1824 | 116.4142 | 2020-07-01 04:33:52 | Beijing, China | ||
2632731 | 2632731 | 2020-06-29 | China | Beijing | 919 | 9 | 586 | 324 | 40.1824 | 116.4142 | 2020-06-30 04:33:48 | Beijing, China | ||
2306294 | 2306294 | 2020-06-28 | China | Beijing | 912 | 9 | 585 | 318 | 40.1824 | 116.4142 | 2020-06-29 04:33:44 | Beijing, China | ||
2039629 | 2039629 | 2020-06-27 | China | Beijing | 905 | 9 | 585 | 311 | 40.1824 | 116.4142 | 2020-06-28 04:34:04 | Beijing, China | ||
1135910 | 1135910 | 2020-06-26 | China | Beijing | 891 | 9 | 585 | 297 | 40.1824 | 116.4142 | 2020-06-27 04:33:35 | Beijing, China | ||
2624897 | 2624897 | 2020-06-25 | China | Beijing | 874 | 9 | 585 | 280 | 40.1824 | 116.4142 | 2020-06-26 04:33:43 | Beijing, China | ||
2700537 | 2700537 | 2020-06-24 | China | Beijing | 863 | 9 | 584 | 270 | 40.1824 | 116.4142 | 2020-06-25 05:26:54 | Beijing, China | ||
1522222 | 1522222 | 2020-06-23 | China | Beijing | 850 | 9 | 584 | 257 | 40.1824 | 116.4142 | 2020-06-24 04:33:28 | Beijing, China | ||
1510416 | 1510416 | 2020-06-22 | China | Beijing | 843 | 9 | 584 | 250 | 40.1824 | 116.4142 | 2020-06-23 04:33:22 | Beijing, China | ||
3249155 | 3249155 | 2020-06-21 | China | Beijing | 830 | 9 | 584 | 237 | 40.1824 | 116.4142 | 2020-06-22 04:33:20 | Beijing, China | ||
2437748 | 2437748 | 2020-06-20 | China | Beijing | 821 | 9 | 584 | 228 | 40.1824 | 116.4142 | 2020-06-21 04:33:19 | Beijing, China | ||
1691326 | 1691326 | 2020-06-19 | China | Beijing | 777 | 9 | 584 | 184 | 40.1824 | 116.4142 | 2020-06-20 04:33:19 | Beijing, China | ||
3682475 | 3682475 | 2020-06-18 | China | Beijing | 777 | 9 | 584 | 184 | 40.1824 | 116.4142 | 2020-06-19 04:33:17 | Beijing, China | ||
1195678 | 1195678 | 2020-06-17 | China | Beijing | 752 | 9 | 584 | 159 | 40.1824 | 116.4142 | 2020-06-18 04:33:18 | Beijing, China | ||
2386441 | 2386441 | 2020-06-16 | China | Beijing | 731 | 9 | 584 | 138 | 40.1824 | 116.4142 | 2020-06-17 04:33:21 | Beijing, China | ||
287004 | 287004 | 2020-06-15 | China | Beijing | 700 | 9 | 584 | 107 | 40.1824 | 116.4142 | 2020-06-16 04:33:09 | Beijing, China | ||
1836955 | 1836955 | 2020-06-14 | China | Beijing | 673 | 9 | 584 | 80 | 40.1824 | 116.4142 | 2020-06-15 03:33:14 | Beijing, China | ||
3061007 | 3061007 | 2020-06-13 | China | Beijing | 637 | 9 | 584 | 44 | 40.1824 | 116.4142 | 2020-06-14 03:33:15 | Beijing, China | ||
737327 | 737327 | 2020-06-12 | China | Beijing | 601 | 9 | 584 | 8 | 40.1824 | 116.4142 | 2020-06-13 03:33:14 | Beijing, China | ||
1273297 | 1273297 | 2020-06-11 | China | Beijing | 595 | 9 | 584 | 2 | 40.1824 | 116.4142 | 2020-06-12 05:09:52 | Beijing, China | ||
2863741 | 2863741 | 2020-06-10 | China | Beijing | 594 | 9 | 584 | 1 | 40.1824 | 116.4142 | 2020-06-11 03:33:41 | Beijing, China | ||
1210595 | 1210595 | 2020-06-09 | China | Beijing | 594 | 9 | 584 | 1 | 40.1824 | 116.4142 | 2020-06-10 04:07:00 | Beijing, China | ||
217022 | 217022 | 2020-06-08 | China | Beijing | 594 | 9 | 584 | 1 | 40.1824 | 116.4142 | 2020-06-09 03:33:03 | 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]);