johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,074 rows where province_or_state = "Hubei" sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 2
- China 931
- Mainland China 43
province_or_state 1
- Hubei · 974 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
367346 | 367346 | 2020-07-16 | China | Hubei | 68135 | 4512 | 63623 | 0 | 30.9756 | 112.2707 | 2020-07-17 04:34:50 | Hubei, China | ||
371313 | 371313 | 2020-08-08 | China | Hubei | 68139 | 4512 | 63623 | 4 | 30.9756 | 112.2707 | 2020-08-09 04:34:54 | Hubei, China | ||
371992 | 371992 | 2022-09-13 | China | Hubei | 68427 | 4512 | 0 | 30.9756 | 112.2707 | 2022-09-14 04:20:44 | Hubei, China | |||
375995 | 375995 | 2020-11-06 | China | Hubei | 68143 | 4512 | 63627 | 4 | 30.9756 | 112.2707 | 2020-11-07 05:24:52 | Hubei, China | ||
380004 | 380004 | 2021-04-30 | China | Hubei | 68158 | 4512 | 63640 | 6 | 30.9756 | 112.2707 | 2021-05-01 04:20:47 | Hubei, China | ||
384019 | 384019 | 2022-09-23 | China | Hubei | 68428 | 4512 | 0 | 30.9756 | 112.2707 | 2022-09-24 04:21:40 | Hubei, China | |||
388034 | 388034 | 2021-04-04 | China | Hubei | 68152 | 4512 | 63639 | 1 | 30.9756 | 112.2707 | 2021-04-05 04:20:35 | Hubei, China | ||
392048 | 392048 | 2020-11-27 | China | Hubei | 68148 | 4512 | 63630 | 6 | 30.9756 | 112.2707 | 2020-11-28 05:25:50 | Hubei, China | ||
396060 | 396060 | 2022-10-07 | China | Hubei | 68430 | 4512 | 0 | 30.9756 | 112.2707 | 2022-10-08 04:22:56 | Hubei, China | |||
400075 | 400075 | 2021-06-29 | China | Hubei | 68162 | 4512 | 63647 | 3 | 30.9756 | 112.2707 | 2021-06-30 04:21:41 | Hubei, China | ||
404089 | 404089 | 2021-12-07 | China | Hubei | 68311 | 4512 | 0 | 30.9756 | 112.2707 | 2021-12-08 04:22:46 | Hubei, China | |||
408105 | 408105 | 2021-07-28 | China | Hubei | 68195 | 4512 | 63663 | 20 | 30.9756 | 112.2707 | 2021-07-29 04:21:33 | Hubei, China | ||
415290 | 415290 | 2020-07-05 | China | Hubei | 68135 | 4512 | 63623 | 0 | 30.9756 | 112.2707 | 2020-07-06 04:33:57 | Hubei, China | ||
415831 | 415831 | 2020-01-26 | Mainland China | Hubei | 1058 | 52 | 42 | 30.9756 | 112.2707 | 1/26/20 16:00 | ||||
418734 | 418734 | 2020-04-18 | China | Hubei | 68128 | 4512 | 63494 | 122 | 30.9756 | 112.2707 | 2020-04-18 01:15:10 | Hubei, China | ||
419131 | 419131 | 2022-09-18 | China | Hubei | 68427 | 4512 | 0 | 30.9756 | 112.2707 | 2022-09-19 04:21:49 | Hubei, China | |||
423146 | 423146 | 2021-10-10 | China | Hubei | 68299 | 4512 | 0 | 30.9756 | 112.2707 | 2021-10-11 04:21:31 | Hubei, China | |||
427150 | 427150 | 2020-09-07 | China | Hubei | 68139 | 4512 | 63627 | 0 | 30.9756 | 112.2707 | 2020-09-08 04:28:25 | Hubei, China | ||
431153 | 431153 | 2022-11-03 | China | Hubei | 68441 | 4512 | 0 | 30.9756 | 112.2707 | 2022-11-04 04:22:11 | Hubei, China | |||
435168 | 435168 | 2021-01-21 | China | Hubei | 68150 | 4512 | 63637 | 1 | 30.9756 | 112.2707 | 2021-01-22 05:22:10 | Hubei, China | ||
442472 | 442472 | 2020-07-26 | China | Hubei | 68135 | 4512 | 63623 | 0 | 30.9756 | 112.2707 | 2020-07-27 04:35:02 | Hubei, China | ||
443150 | 443150 | 2021-10-20 | China | Hubei | 68305 | 4512 | 0 | 30.9756 | 112.2707 | 2021-10-21 04:21:18 | Hubei, China | |||
447166 | 447166 | 2021-11-17 | China | Hubei | 68311 | 4512 | 0 | 30.9756 | 112.2707 | 2021-11-18 04:21:33 | Hubei, China | |||
451183 | 451183 | 2022-12-21 | China | Hubei | 68861 | 4512 | 0 | 30.9756 | 112.2707 | 2022-12-22 04:20:56 | Hubei, China | |||
458497 | 458497 | 2020-08-07 | China | Hubei | 68139 | 4512 | 63623 | 4 | 30.9756 | 112.2707 | 2020-08-08 04:34:53 | Hubei, China | ||
459175 | 459175 | 2022-02-02 | China | Hubei | 68320 | 4512 | 0 | 30.9756 | 112.2707 | 2022-02-03 04:21:21 | Hubei, China | |||
463192 | 463192 | 2022-05-02 | China | Hubei | 68398 | 4512 | 0 | 30.9756 | 112.2707 | 2022-05-03 04:21:00 | Hubei, China | |||
467207 | 467207 | 2021-10-07 | China | Hubei | 68299 | 4512 | 0 | 30.9756 | 112.2707 | 2021-10-08 04:21:25 | Hubei, China | |||
471223 | 471223 | 2021-02-19 | China | Hubei | 68151 | 4512 | 63638 | 1 | 30.9756 | 112.2707 | 2021-02-20 05:22:51 | Hubei, China | ||
475238 | 475238 | 2022-06-26 | China | Hubei | 68402 | 4512 | 0 | 30.9756 | 112.2707 | 2022-06-27 04:21:00 | Hubei, China | |||
479129 | 479129 | 2020-02-25 | Mainland China | Hubei | 64786 | 2563 | 18971 | 30.9756 | 112.2707 | 2020-02-25T15:23:04 | ||||
479386 | 479386 | 2022-11-08 | China | Hubei | 68444 | 4512 | 0 | 30.9756 | 112.2707 | 2022-11-09 04:21:22 | Hubei, China | |||
483401 | 483401 | 2021-07-19 | China | Hubei | 68192 | 4512 | 63648 | 32 | 30.9756 | 112.2707 | 2021-07-20 04:21:48 | Hubei, China | ||
487416 | 487416 | 2022-11-25 | China | Hubei | 68523 | 4512 | 0 | 30.9756 | 112.2707 | 2022-11-26 04:21:11 | Hubei, China | |||
491431 | 491431 | 2021-10-14 | China | Hubei | 68300 | 4512 | 0 | 30.9756 | 112.2707 | 2021-10-15 04:21:26 | Hubei, China | |||
495447 | 495447 | 2021-11-06 | China | Hubei | 68309 | 4512 | 0 | 30.9756 | 112.2707 | 2021-11-07 04:21:53 | Hubei, China | |||
499464 | 499464 | 2022-04-02 | China | Hubei | 68391 | 4512 | 0 | 30.9756 | 112.2707 | 2022-04-03 04:20:48 | Hubei, China | |||
503480 | 503480 | 2022-12-17 | China | Hubei | 68861 | 4512 | 0 | 30.9756 | 112.2707 | 2022-12-18 04:21:03 | Hubei, China | |||
507495 | 507495 | 2021-08-14 | China | Hubei | 68282 | 4512 | 0 | 30.9756 | 112.2707 | 2021-08-15 04:21:41 | Hubei, China | |||
511509 | 511509 | 2021-08-19 | China | Hubei | 68286 | 4512 | 0 | 30.9756 | 112.2707 | 2021-08-20 04:21:33 | Hubei, China | |||
515524 | 515524 | 2022-10-15 | China | Hubei | 68431 | 4512 | 0 | 30.9756 | 112.2707 | 2022-10-16 04:22:39 | Hubei, China | |||
522272 | 522272 | 2020-04-21 | China | Hubei | 68128 | 4512 | 63514 | 102 | 30.9756 | 112.2707 | 2020-04-21 01:02:30 | Hubei, China | ||
522668 | 522668 | 2021-06-09 | China | Hubei | 68159 | 4512 | 63647 | 0 | 30.9756 | 112.2707 | 2021-06-10 04:23:17 | Hubei, China | ||
529852 | 529852 | 2020-07-04 | China | Hubei | 68135 | 4512 | 63623 | 0 | 30.9756 | 112.2707 | 2020-07-05 04:33:46 | Hubei, China | ||
530517 | 530517 | 2021-02-22 | China | Hubei | 68151 | 4512 | 63638 | 1 | 30.9756 | 112.2707 | 2021-02-23 05:23:41 | Hubei, China | ||
534531 | 534531 | 2021-10-27 | China | Hubei | 68306 | 4512 | 0 | 30.9756 | 112.2707 | 2021-10-28 04:22:08 | Hubei, China | |||
538548 | 538548 | 2022-10-26 | China | Hubei | 68439 | 4512 | 0 | 30.9756 | 112.2707 | 2022-10-27 04:22:01 | Hubei, China | |||
542564 | 542564 | 2022-12-15 | China | Hubei | 68862 | 4512 | 0 | 30.9756 | 112.2707 | 2022-12-16 04:21:01 | Hubei, China | |||
546567 | 546567 | 2020-09-12 | China | Hubei | 68139 | 4512 | 63627 | 0 | 30.9756 | 112.2707 | 2020-09-13 04:30:52 | Hubei, China | ||
550569 | 550569 | 2021-12-08 | China | Hubei | 68315 | 4512 | 0 | 30.9756 | 112.2707 | 2021-12-09 04:22:49 | Hubei, China | |||
554585 | 554585 | 2022-01-16 | China | Hubei | 68320 | 4512 | 0 | 30.9756 | 112.2707 | 2022-01-17 04:21:08 | Hubei, China | |||
558602 | 558602 | 2022-06-16 | China | Hubei | 68400 | 4512 | 0 | 30.9756 | 112.2707 | 2022-06-17 04:20:56 | Hubei, China | |||
562493 | 562493 | 2020-03-01 | Mainland China | Hubei | 66907 | 2761 | 31536 | 30.9756 | 112.2707 | 2020-03-01T10:13:19 | ||||
562778 | 562778 | 2021-06-22 | China | Hubei | 68160 | 4512 | 63647 | 1 | 30.9756 | 112.2707 | 2021-06-23 04:21:46 | Hubei, China | ||
566668 | 566668 | 2020-02-06 | Mainland China | Hubei | 22112 | 618 | 817 | 30.9756 | 112.2707 | 2020-02-06T23:23:02 | ||||
566899 | 566899 | 2021-10-29 | China | Hubei | 68308 | 4512 | 0 | 30.9756 | 112.2707 | 2021-10-30 04:22:03 | Hubei, China | |||
573985 | 573985 | 2020-06-06 | China | Hubei | 68135 | 4512 | 63623 | 0 | 30.9756 | 112.2707 | 2020-06-07 03:53:30 | Hubei, China | ||
574628 | 574628 | 2022-02-25 | China | Hubei | 68347 | 4512 | 0 | 30.9756 | 112.2707 | 2022-02-26 04:21:12 | Hubei, China | |||
578643 | 578643 | 2021-07-13 | China | Hubei | 68188 | 4512 | 63648 | 28 | 30.9756 | 112.2707 | 2021-07-14 04:21:35 | Hubei, China | ||
582645 | 582645 | 2020-08-13 | China | Hubei | 68139 | 4512 | 63623 | 4 | 30.9756 | 112.2707 | 2020-08-14 04:51:19 | Hubei, China | ||
589044 | 589044 | 2020-04-05 | China | Hubei | 67803 | 3210 | 63945 | 648 | 30.9756 | 112.2707 | 2020-04-05 02:06:47 | Hubei, China | ||
589439 | 589439 | 2021-08-08 | China | Hubei | 68235 | 4512 | 0 | 30.9756 | 112.2707 | 2021-08-09 04:21:24 | Hubei, China | |||
593454 | 593454 | 2022-07-01 | China | Hubei | 68402 | 4512 | 0 | 30.9756 | 112.2707 | 2022-07-02 04:21:16 | Hubei, China | |||
597469 | 597469 | 2021-10-19 | China | Hubei | 68303 | 4512 | 0 | 30.9756 | 112.2707 | 2021-10-20 04:21:00 | Hubei, China | |||
601485 | 601485 | 2021-09-23 | China | Hubei | 68297 | 4512 | 0 | 30.9756 | 112.2707 | 2021-09-24 04:21:44 | Hubei, China | |||
605500 | 605500 | 2021-04-09 | China | Hubei | 68154 | 4512 | 63640 | 2 | 30.9756 | 112.2707 | 2021-04-10 04:20:59 | Hubei, China | ||
609502 | 609502 | 2020-08-29 | China | Hubei | 68139 | 4512 | 63626 | 1 | 30.9756 | 112.2707 | 2020-08-30 04:28:22 | Hubei, China | ||
613500 | 613500 | 2021-02-08 | China | Hubei | 68150 | 4512 | 63638 | 0 | 30.9756 | 112.2707 | 2021-02-09 05:23:30 | Hubei, China | ||
617390 | 617390 | 2020-02-27 | Mainland China | Hubei | 65596 | 2641 | 23383 | 30.9756 | 112.2707 | 2020-02-27T12:13:14 | ||||
617658 | 617658 | 2022-11-05 | China | Hubei | 68441 | 4512 | 0 | 30.9756 | 112.2707 | 2022-11-06 04:21:24 | Hubei, China | |||
621674 | 621674 | 2022-05-22 | China | Hubei | 68398 | 4512 | 0 | 30.9756 | 112.2707 | 2022-05-26 04:20:50 | Hubei, China | |||
625689 | 625689 | 2021-07-10 | China | Hubei | 68187 | 4512 | 63648 | 27 | 30.9756 | 112.2707 | 2021-07-11 04:21:43 | Hubei, China | ||
629704 | 629704 | 2022-07-12 | China | Hubei | 68403 | 4512 | 0 | 30.9756 | 112.2707 | 2022-07-13 04:20:58 | Hubei, China | |||
633719 | 633719 | 2021-10-13 | China | Hubei | 68300 | 4512 | 0 | 30.9756 | 112.2707 | 2021-10-14 04:21:29 | Hubei, China | |||
637735 | 637735 | 2021-03-31 | China | Hubei | 68152 | 4512 | 63639 | 1 | 30.9756 | 112.2707 | 2021-04-01 04:27:05 | Hubei, China | ||
641749 | 641749 | 2021-09-07 | China | Hubei | 68291 | 4512 | 0 | 30.9756 | 112.2707 | 2021-09-08 04:21:31 | Hubei, China | |||
645763 | 645763 | 2021-05-05 | China | Hubei | 68158 | 4512 | 63640 | 6 | 30.9756 | 112.2707 | 2021-05-06 04:20:38 | Hubei, China | ||
649777 | 649777 | 2021-08-09 | China | Hubei | 68250 | 4512 | 0 | 30.9756 | 112.2707 | 2021-08-10 04:21:27 | Hubei, China | |||
653791 | 653791 | 2021-10-22 | China | Hubei | 68305 | 4512 | 0 | 30.9756 | 112.2707 | 2021-10-23 04:21:32 | Hubei, China | |||
657683 | 657683 | 2020-03-09 | Mainland China | Hubei | 67743 | 3008 | 46488 | 30.9756 | 112.2707 | 2020-03-09T14:33:03 | ||||
658110 | 658110 | 2022-05-13 | China | Hubei | 68398 | 4512 | 0 | 30.9756 | 112.2707 | 2022-05-14 04:20:48 | Hubei, China | |||
662113 | 662113 | 2020-08-11 | China | Hubei | 68139 | 4512 | 63623 | 4 | 30.9756 | 112.2707 | 2020-08-12 04:27:29 | Hubei, China | ||
666092 | 666092 | 2020-09-16 | China | Hubei | 68139 | 4512 | 63627 | 0 | 30.9756 | 112.2707 | 2020-09-17 04:22:00 | Hubei, China | ||
670095 | 670095 | 2022-07-21 | China | Hubei | 68406 | 4512 | 0 | 30.9756 | 112.2707 | 2022-07-22 04:21:15 | Hubei, China | |||
674111 | 674111 | 2022-07-30 | China | Hubei | 68408 | 4512 | 0 | 30.9756 | 112.2707 | 2022-07-31 04:21:02 | Hubei, China | |||
678125 | 678125 | 2020-11-23 | China | Hubei | 68148 | 4512 | 63628 | 8 | 30.9756 | 112.2707 | 2020-11-24 05:27:31 | Hubei, China | ||
682136 | 682136 | 2021-10-24 | China | Hubei | 68305 | 4512 | 0 | 30.9756 | 112.2707 | 2021-10-25 04:22:31 | Hubei, China | |||
686152 | 686152 | 2021-11-13 | China | Hubei | 68311 | 4512 | 0 | 30.9756 | 112.2707 | 2021-11-14 04:21:31 | Hubei, China | |||
690169 | 690169 | 2022-12-23 | China | Hubei | 68861 | 4512 | 0 | 30.9756 | 112.2707 | 2022-12-24 04:21:02 | Hubei, China | |||
694185 | 694185 | 2022-03-17 | China | Hubei | 68388 | 4512 | 0 | 30.9756 | 112.2707 | 2022-03-18 04:20:55 | Hubei, China | |||
698200 | 698200 | 2021-11-04 | China | Hubei | 68309 | 4512 | 0 | 30.9756 | 112.2707 | 2021-11-05 04:21:54 | Hubei, China | |||
702216 | 702216 | 2021-03-16 | China | Hubei | 68151 | 4512 | 63639 | 0 | 30.9756 | 112.2707 | 2021-03-17 05:25:07 | Hubei, China | ||
706230 | 706230 | 2021-09-29 | China | Hubei | 68298 | 4512 | 0 | 30.9756 | 112.2707 | 2021-09-30 04:21:20 | Hubei, China | |||
710246 | 710246 | 2022-11-01 | China | Hubei | 68439 | 4512 | 0 | 30.9756 | 112.2707 | 2022-11-02 04:22:09 | Hubei, China | |||
714261 | 714261 | 2021-11-12 | China | Hubei | 68311 | 4512 | 0 | 30.9756 | 112.2707 | 2021-11-13 04:21:38 | Hubei, China | |||
718278 | 718278 | 2022-12-04 | China | Hubei | 68716 | 4512 | 0 | 30.9756 | 112.2707 | 2022-12-05 04:20:58 | Hubei, China | |||
722293 | 722293 | 2021-11-20 | China | Hubei | 68311 | 4512 | 0 | 30.9756 | 112.2707 | 2021-11-21 04:22:13 | Hubei, China | |||
726309 | 726309 | 2021-05-22 | China | Hubei | 68159 | 4512 | 63645 | 2 | 30.9756 | 112.2707 | 2021-05-23 04:20:51 | Hubei, China | ||
730323 | 730323 | 2021-12-27 | China | Hubei | 68316 | 4512 | 0 | 30.9756 | 112.2707 | 2021-12-28 04:21:47 | Hubei, China | |||
737449 | 737449 | 2020-06-12 | China | Hubei | 68135 | 4512 | 63623 | 0 | 30.9756 | 112.2707 | 2020-06-13 03:33:14 | Hubei, 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]);