johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,074 rows where province_or_state = "Hebei" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 2
- China 936
- Mainland China 38
province_or_state 1
- Hebei · 974 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
641745 | 641745 | 2021-09-07 | China | Hebei | 1317 | 7 | 0 | 37.8957 | 114.9042 | 2021-09-08 04:21:31 | Hebei, China | |||
649773 | 649773 | 2021-08-09 | China | Hebei | 1317 | 7 | 0 | 37.8957 | 114.9042 | 2021-08-10 04:21:27 | Hebei, China | |||
653787 | 653787 | 2021-10-22 | China | Hebei | 1318 | 7 | 0 | 37.8957 | 114.9042 | 2021-10-23 04:21:32 | Hebei, China | |||
657708 | 657708 | 2020-03-09 | Mainland China | Hebei | 318 | 6 | 307 | 38.0428 | 114.5149 | 2020-03-07T13:03:05 | ||||
658106 | 658106 | 2022-05-13 | China | Hebei | 2003 | 7 | 0 | 37.8957 | 114.9042 | 2022-05-14 04:20:48 | Hebei, China | |||
670091 | 670091 | 2022-07-21 | China | Hebei | 2007 | 7 | 0 | 37.8957 | 114.9042 | 2022-07-22 04:21:15 | Hebei, China | |||
674107 | 674107 | 2022-07-30 | China | Hebei | 2007 | 7 | 0 | 37.8957 | 114.9042 | 2022-07-31 04:21:02 | Hebei, China | |||
682132 | 682132 | 2021-10-24 | China | Hebei | 1321 | 7 | 0 | 37.8957 | 114.9042 | 2021-10-25 04:22:31 | Hebei, China | |||
686148 | 686148 | 2021-11-13 | China | Hebei | 1452 | 7 | 0 | 37.8957 | 114.9042 | 2021-11-14 04:21:31 | Hebei, China | |||
690165 | 690165 | 2022-12-23 | China | Hebei | 2943 | 7 | 0 | 37.8957 | 114.9042 | 2022-12-24 04:21:02 | Hebei, China | |||
694181 | 694181 | 2022-03-17 | China | Hebei | 1771 | 7 | 0 | 37.8957 | 114.9042 | 2022-03-18 04:20:55 | Hebei, China | |||
698196 | 698196 | 2021-11-04 | China | Hebei | 1385 | 7 | 0 | 37.8957 | 114.9042 | 2021-11-05 04:21:54 | Hebei, China | |||
706226 | 706226 | 2021-09-29 | China | Hebei | 1317 | 7 | 0 | 37.8957 | 114.9042 | 2021-09-30 04:21:20 | Hebei, China | |||
710242 | 710242 | 2022-11-01 | China | Hebei | 2035 | 7 | 0 | 37.8957 | 114.9042 | 2022-11-02 04:22:09 | Hebei, China | |||
714257 | 714257 | 2021-11-12 | China | Hebei | 1449 | 7 | 0 | 37.8957 | 114.9042 | 2021-11-13 04:21:38 | Hebei, China | |||
718274 | 718274 | 2022-12-04 | China | Hebei | 2818 | 7 | 0 | 37.8957 | 114.9042 | 2022-12-05 04:20:58 | Hebei, China | |||
722289 | 722289 | 2021-11-20 | China | Hebei | 1453 | 7 | 0 | 37.8957 | 114.9042 | 2021-11-21 04:22:13 | Hebei, China | |||
730319 | 730319 | 2021-12-27 | China | Hebei | 1458 | 7 | 0 | 37.8957 | 114.9042 | 2021-12-28 04:21:47 | Hebei, China | |||
746136 | 746136 | 2022-04-23 | China | Hebei | 1993 | 7 | 0 | 37.8957 | 114.9042 | 2022-04-24 04:20:56 | Hebei, China | |||
758119 | 758119 | 2021-11-26 | China | Hebei | 1453 | 7 | 0 | 37.8957 | 114.9042 | 2021-11-27 04:22:45 | Hebei, China | |||
770140 | 770140 | 2021-10-23 | China | Hebei | 1319 | 7 | 0 | 37.8957 | 114.9042 | 2021-10-24 04:21:22 | Hebei, China | |||
782182 | 782182 | 2021-12-13 | China | Hebei | 1458 | 7 | 0 | 37.8957 | 114.9042 | 2021-12-14 04:22:38 | Hebei, China | |||
794206 | 794206 | 2022-10-24 | China | Hebei | 2033 | 7 | 0 | 37.8957 | 114.9042 | 2022-10-25 04:21:53 | Hebei, China | |||
798221 | 798221 | 2021-12-22 | China | Hebei | 1458 | 7 | 0 | 37.8957 | 114.9042 | 2021-12-23 04:21:21 | Hebei, China | |||
809383 | 809383 | 2021-09-20 | China | Hebei | 1317 | 7 | 0 | 37.8957 | 114.9042 | 2021-09-21 04:21:26 | Hebei, China | |||
833419 | 833419 | 2022-12-02 | China | Hebei | 2801 | 7 | 0 | 37.8957 | 114.9042 | 2022-12-03 04:21:02 | Hebei, China | |||
849391 | 849391 | 2022-11-02 | China | Hebei | 2035 | 7 | 0 | 37.8957 | 114.9042 | 2022-11-03 04:22:05 | Hebei, China | |||
853407 | 853407 | 2022-09-30 | China | Hebei | 2029 | 7 | 0 | 37.8957 | 114.9042 | 2022-10-01 04:23:01 | Hebei, China | |||
868591 | 868591 | 2022-12-11 | China | Hebei | 2836 | 7 | 0 | 37.8957 | 114.9042 | 2022-12-12 04:21:01 | Hebei, China | |||
876056 | 876056 | 2022-03-27 | China | Hebei | 1935 | 7 | 0 | 37.8957 | 114.9042 | 2022-03-28 04:20:33 | Hebei, China | |||
880072 | 880072 | 2022-08-05 | China | Hebei | 2007 | 7 | 0 | 37.8957 | 114.9042 | 2022-08-06 04:20:56 | Hebei, China | |||
895939 | 895939 | 2022-07-24 | China | Hebei | 2007 | 7 | 0 | 37.8957 | 114.9042 | 2022-07-25 04:20:51 | Hebei, China | |||
899955 | 899955 | 2022-07-22 | China | Hebei | 2007 | 7 | 0 | 37.8957 | 114.9042 | 2022-07-23 04:20:53 | Hebei, China | |||
903970 | 903970 | 2021-11-24 | China | Hebei | 1453 | 7 | 0 | 37.8957 | 114.9042 | 2021-11-25 04:22:33 | Hebei, China | |||
912000 | 912000 | 2022-10-29 | China | Hebei | 2034 | 7 | 0 | 37.8957 | 114.9042 | 2022-10-30 04:22:14 | Hebei, China | |||
919476 | 919476 | 2022-03-08 | China | Hebei | 1526 | 7 | 0 | 37.8957 | 114.9042 | 2022-03-09 04:20:59 | Hebei, China | |||
934592 | 934592 | 2021-10-16 | China | Hebei | 1318 | 7 | 0 | 37.8957 | 114.9042 | 2021-10-17 04:21:29 | Hebei, China | |||
938609 | 938609 | 2022-06-25 | China | Hebei | 2007 | 7 | 0 | 37.8957 | 114.9042 | 2022-06-26 04:21:02 | Hebei, China | |||
942625 | 942625 | 2022-02-28 | China | Hebei | 1476 | 7 | 0 | 37.8957 | 114.9042 | 2022-03-01 04:21:09 | Hebei, China | |||
946641 | 946641 | 2022-06-14 | China | Hebei | 2005 | 7 | 0 | 37.8957 | 114.9042 | 2022-06-15 04:20:54 | Hebei, China | |||
950657 | 950657 | 2022-03-12 | China | Hebei | 1607 | 7 | 0 | 37.8957 | 114.9042 | 2022-03-13 04:20:49 | Hebei, China | |||
958687 | 958687 | 2022-07-19 | China | Hebei | 2007 | 7 | 0 | 37.8957 | 114.9042 | 2022-07-20 04:20:59 | Hebei, China | |||
962703 | 962703 | 2022-09-09 | China | Hebei | 2027 | 7 | 0 | 37.8957 | 114.9042 | 2022-09-10 04:21:10 | Hebei, China | |||
970711 | 970711 | 2022-06-01 | China | Hebei | 2005 | 7 | 0 | 37.8957 | 114.9042 | 2022-06-02 05:20:39 | Hebei, China | |||
978740 | 978740 | 2022-02-01 | China | Hebei | 1474 | 7 | 0 | 37.8957 | 114.9042 | 2022-02-02 04:21:09 | Hebei, China | |||
986770 | 986770 | 2021-10-04 | China | Hebei | 1318 | 7 | 0 | 37.8957 | 114.9042 | 2021-10-05 04:21:27 | Hebei, China | |||
990786 | 990786 | 2022-08-16 | China | Hebei | 2009 | 7 | 0 | 37.8957 | 114.9042 | 2022-08-17 04:20:59 | Hebei, China | |||
1014125 | 1014125 | 2021-11-21 | China | Hebei | 1453 | 7 | 0 | 37.8957 | 114.9042 | 2021-11-22 04:22:20 | Hebei, China | |||
1018142 | 1018142 | 2022-12-24 | China | Hebei | 2943 | 7 | 0 | 37.8957 | 114.9042 | 2022-12-25 04:21:04 | Hebei, China | |||
1022158 | 1022158 | 2022-11-04 | China | Hebei | 2035 | 7 | 0 | 37.8957 | 114.9042 | 2022-11-05 04:21:52 | Hebei, China | |||
1030167 | 1030167 | 2021-12-06 | China | Hebei | 1458 | 7 | 0 | 37.8957 | 114.9042 | 2021-12-07 04:22:34 | Hebei, China | |||
1049630 | 1049630 | 2022-11-06 | China | Hebei | 2037 | 7 | 0 | 37.8957 | 114.9042 | 2022-11-07 04:21:26 | Hebei, China | |||
1057641 | 1057641 | 2022-02-23 | China | Hebei | 1476 | 7 | 0 | 37.8957 | 114.9042 | 2022-02-24 04:21:14 | Hebei, China | |||
1065669 | 1065669 | 2022-07-28 | China | Hebei | 2007 | 7 | 0 | 37.8957 | 114.9042 | 2022-07-29 04:20:45 | Hebei, China | |||
1069685 | 1069685 | 2022-08-07 | China | Hebei | 2009 | 7 | 0 | 37.8957 | 114.9042 | 2022-08-08 04:21:08 | Hebei, China | |||
1073701 | 1073701 | 2022-12-28 | China | Hebei | 2943 | 7 | 0 | 37.8957 | 114.9042 | 2022-12-29 04:21:01 | Hebei, China | |||
1077716 | 1077716 | 2021-12-09 | China | Hebei | 1458 | 7 | 0 | 37.8957 | 114.9042 | 2021-12-10 04:22:28 | Hebei, China | |||
1085642 | 1085642 | 2020-02-22 | Mainland China | Hebei | 309 | 6 | 203 | 38.0428 | 114.5149 | 2020-02-22T12:33:04 | ||||
1085867 | 1085867 | 2022-08-09 | China | Hebei | 2009 | 7 | 0 | 37.8957 | 114.9042 | 2022-08-10 04:20:57 | Hebei, China | |||
1097910 | 1097910 | 2022-08-03 | China | Hebei | 2007 | 7 | 0 | 37.8957 | 114.9042 | 2022-08-04 04:20:58 | Hebei, China | |||
1109366 | 1109366 | 2022-05-21 | China | Hebei | 2004 | 7 | 0 | 37.8957 | 114.9042 | 2022-05-22 04:20:52 | Hebei, China | |||
1113381 | 1113381 | 2022-01-11 | China | Hebei | 1458 | 7 | 0 | 37.8957 | 114.9042 | 2022-01-12 04:21:44 | Hebei, China | |||
1117397 | 1117397 | 2021-08-06 | China | Hebei | 1317 | 7 | 0 | 37.8957 | 114.9042 | 2021-08-07 04:21:30 | Hebei, China | |||
1140704 | 1140704 | 2022-01-23 | China | Hebei | 1461 | 7 | 0 | 37.8957 | 114.9042 | 2022-01-24 04:21:12 | Hebei, China | |||
1144720 | 1144720 | 2021-12-01 | China | Hebei | 1453 | 7 | 0 | 37.8957 | 114.9042 | 2021-12-02 04:22:37 | Hebei, China | |||
1148737 | 1148737 | 2022-12-12 | China | Hebei | 2838 | 7 | 0 | 37.8957 | 114.9042 | 2022-12-13 04:21:01 | Hebei, China | |||
1152650 | 1152650 | 2020-03-02 | Mainland China | Hebei | 318 | 6 | 296 | 38.0428 | 114.5149 | 2020-03-02T09:43:05 | ||||
1156944 | 1156944 | 2022-04-29 | China | Hebei | 1998 | 7 | 0 | 37.8957 | 114.9042 | 2022-04-30 04:21:05 | Hebei, China | |||
1160960 | 1160960 | 2022-08-18 | China | Hebei | 2009 | 7 | 0 | 37.8957 | 114.9042 | 2022-08-19 04:20:54 | Hebei, China | |||
1168990 | 1168990 | 2022-05-20 | China | Hebei | 2004 | 7 | 0 | 37.8957 | 114.9042 | 2022-05-21 04:20:58 | Hebei, China | |||
1176915 | 1176915 | 2020-03-18 | China | Hebei | 318 | 6 | 310 | 38.0428 | 114.5149 | 2020-03-13T11:09:03 | ||||
1184537 | 1184537 | 2022-05-18 | China | Hebei | 2004 | 7 | 0 | 37.8957 | 114.9042 | 2022-05-19 04:20:54 | Hebei, China | |||
1192460 | 1192460 | 2020-02-14 | Mainland China | Hebei | 283 | 3 | 87 | 38.0428 | 114.5149 | 2020-02-14T11:13:22 | ||||
1199599 | 1199599 | 2022-07-06 | China | Hebei | 2007 | 7 | 0 | 37.8957 | 114.9042 | 2022-07-07 04:20:55 | Hebei, China | |||
1211344 | 1211344 | 2022-07-11 | China | Hebei | 2007 | 7 | 0 | 37.8957 | 114.9042 | 2022-07-12 04:20:51 | Hebei, China | |||
1215359 | 1215359 | 2022-01-08 | China | Hebei | 1458 | 7 | 0 | 37.8957 | 114.9042 | 2022-01-09 04:21:46 | Hebei, China | |||
1223390 | 1223390 | 2022-04-14 | China | Hebei | 1984 | 7 | 0 | 37.8957 | 114.9042 | 2022-04-15 04:20:57 | Hebei, China | |||
1227405 | 1227405 | 2022-01-24 | China | Hebei | 1463 | 7 | 0 | 37.8957 | 114.9042 | 2022-01-25 04:21:05 | Hebei, China | |||
1231421 | 1231421 | 2021-11-28 | China | Hebei | 1453 | 7 | 0 | 37.8957 | 114.9042 | 2021-11-29 04:22:30 | Hebei, China | |||
1235437 | 1235437 | 2021-09-27 | China | Hebei | 1317 | 7 | 0 | 37.8957 | 114.9042 | 2021-09-28 04:21:28 | Hebei, China | |||
1239453 | 1239453 | 2022-11-28 | China | Hebei | 2182 | 7 | 0 | 37.8957 | 114.9042 | 2022-11-29 04:21:05 | Hebei, China | |||
1243363 | 1243363 | 2020-02-17 | Mainland China | Hebei | 301 | 3 | 122 | 38.0428 | 114.5149 | 2020-02-17T13:03:06 | ||||
1250549 | 1250549 | 2022-08-23 | China | Hebei | 2009 | 7 | 0 | 37.8957 | 114.9042 | 2022-08-24 04:20:46 | Hebei, China | |||
1254564 | 1254564 | 2021-12-20 | China | Hebei | 1458 | 7 | 0 | 37.8957 | 114.9042 | 2021-12-21 03:21:27 | Hebei, China | |||
1258580 | 1258580 | 2021-12-18 | China | Hebei | 1458 | 7 | 0 | 37.8957 | 114.9042 | 2021-12-19 04:21:11 | Hebei, China | |||
1262596 | 1262596 | 2021-09-09 | China | Hebei | 1317 | 7 | 0 | 37.8957 | 114.9042 | 2021-09-10 04:21:20 | Hebei, China | |||
1274080 | 1274080 | 2021-10-03 | China | Hebei | 1318 | 7 | 0 | 37.8957 | 114.9042 | 2021-10-04 04:21:31 | Hebei, China | |||
1281781 | 1281781 | 2022-01-05 | China | Hebei | 1458 | 7 | 0 | 37.8957 | 114.9042 | 2022-01-06 04:22:09 | Hebei, China | |||
1285797 | 1285797 | 2022-01-04 | China | Hebei | 1458 | 7 | 0 | 37.8957 | 114.9042 | 2022-01-05 04:21:59 | Hebei, China | |||
1293827 | 1293827 | 2022-02-05 | China | Hebei | 1476 | 7 | 0 | 37.8957 | 114.9042 | 2022-02-06 04:21:00 | Hebei, China | |||
1297844 | 1297844 | 2022-02-17 | China | Hebei | 1476 | 7 | 0 | 37.8957 | 114.9042 | 2022-02-18 04:21:04 | Hebei, China | |||
1305772 | 1305772 | 2020-01-28 | Mainland China | Hebei | 33 | 1 | 0 | 38.0428 | 114.5149 | 1/28/20 23:00 | ||||
1313991 | 1313991 | 2022-05-27 | China | Hebei | 2004 | 7 | 0 | 37.8957 | 114.9042 | 2022-05-28 04:21:07 | Hebei, China | |||
1318006 | 1318006 | 2022-01-26 | China | Hebei | 1468 | 7 | 0 | 37.8957 | 114.9042 | 2022-01-27 04:21:19 | Hebei, China | |||
1322022 | 1322022 | 2021-11-14 | China | Hebei | 1453 | 7 | 0 | 37.8957 | 114.9042 | 2021-11-15 04:21:36 | Hebei, China | |||
1326039 | 1326039 | 2022-04-26 | China | Hebei | 1996 | 7 | 0 | 37.8957 | 114.9042 | 2022-04-27 04:20:52 | Hebei, China | |||
1334068 | 1334068 | 2021-09-28 | China | Hebei | 1317 | 7 | 0 | 37.8957 | 114.9042 | 2021-09-29 04:21:45 | Hebei, China | |||
1342097 | 1342097 | 2021-08-11 | China | Hebei | 1317 | 7 | 0 | 37.8957 | 114.9042 | 2021-08-12 04:21:25 | Hebei, China | |||
1346112 | 1346112 | 2022-08-10 | China | Hebei | 2009 | 7 | 0 | 37.8957 | 114.9042 | 2022-08-11 04:20:49 | Hebei, China | |||
1358128 | 1358128 | 2021-11-27 | China | Hebei | 1453 | 7 | 0 | 37.8957 | 114.9042 | 2021-11-28 04:22:43 | Hebei, 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]);