johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Brazil" and province_or_state = "Pernambuco" sorted by combined_key
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
423079 | 423079 | 2021-10-10 | Brazil | Pernambuco | 624197 | 19845 | 0 | -8.8137 | -36.9541 | 2021-10-11 04:21:31 | Pernambuco, Brazil | |||
427084 | 427084 | 2020-09-07 | Brazil | Pernambuco | 132420 | 7721 | 114990 | 9709 | -8.8137 | -36.9541 | 2020-09-08 04:28:25 | Pernambuco, Brazil | ||
431086 | 431086 | 2022-11-03 | Brazil | Pernambuco | 1065691 | 22411 | 0 | -8.8137 | -36.9541 | 2022-11-04 04:22:11 | Pernambuco, Brazil | |||
435101 | 435101 | 2021-01-21 | Brazil | Pernambuco | 246799 | 10133 | 207478 | 29188 | -8.8137 | -36.9541 | 2021-01-22 05:22:10 | Pernambuco, Brazil | ||
442646 | 442646 | 2020-07-26 | Brazil | Pernambuco | 88466 | 6352 | 65177 | 16937 | -8.8137 | -36.9541 | 2020-07-27 04:35:02 | Pernambuco, Brazil | ||
443083 | 443083 | 2021-10-20 | Brazil | Pernambuco | 627188 | 19914 | 0 | -8.8137 | -36.9541 | 2021-10-21 04:21:18 | Pernambuco, Brazil | |||
447099 | 447099 | 2021-11-17 | Brazil | Pernambuco | 636562 | 20135 | 0 | -8.8137 | -36.9541 | 2021-11-18 04:21:33 | Pernambuco, Brazil | |||
451116 | 451116 | 2022-12-21 | Brazil | Pernambuco | 1113073 | 22548 | 0 | -8.8137 | -36.9541 | 2022-12-22 04:20:56 | Pernambuco, Brazil | |||
458672 | 458672 | 2020-08-07 | Brazil | Pernambuco | 102872 | 6867 | 77379 | 18626 | -8.8137 | -36.9541 | 2020-08-08 04:34:53 | Pernambuco, Brazil | ||
459108 | 459108 | 2022-02-02 | Brazil | Pernambuco | 712083 | 20682 | 0 | -8.8137 | -36.9541 | 2022-02-03 04:21:21 | Pernambuco, Brazil | |||
463125 | 463125 | 2022-05-02 | Brazil | Pernambuco | 923820 | 21611 | 0 | -8.8137 | -36.9541 | 2022-05-03 04:21:00 | Pernambuco, Brazil | |||
467140 | 467140 | 2021-10-07 | Brazil | Pernambuco | 623144 | 19817 | 0 | -8.8137 | -36.9541 | 2021-10-08 04:21:25 | Pernambuco, Brazil | |||
471156 | 471156 | 2021-02-19 | Brazil | Pernambuco | 288424 | 10804 | 248691 | 28929 | -8.8137 | -36.9541 | 2021-02-20 05:22:51 | Pernambuco, Brazil | ||
475171 | 475171 | 2022-06-26 | Brazil | Pernambuco | 965289 | 21836 | 0 | -8.8137 | -36.9541 | 2022-06-27 04:21:00 | Pernambuco, Brazil | |||
479319 | 479319 | 2022-11-08 | Brazil | Pernambuco | 1066414 | 22414 | 0 | -8.8137 | -36.9541 | 2022-11-09 04:21:22 | Pernambuco, Brazil | |||
483334 | 483334 | 2021-07-19 | Brazil | Pernambuco | 579425 | 18342 | 497027 | 64056 | -8.8137 | -36.9541 | 2021-07-20 04:21:48 | Pernambuco, Brazil | ||
487349 | 487349 | 2022-11-25 | Brazil | Pernambuco | 1080757 | 22462 | 0 | -8.8137 | -36.9541 | 2022-11-26 04:21:11 | Pernambuco, Brazil | |||
491364 | 491364 | 2021-10-14 | Brazil | Pernambuco | 625147 | 19866 | 0 | -8.8137 | -36.9541 | 2021-10-15 04:21:26 | Pernambuco, Brazil | |||
495380 | 495380 | 2021-11-06 | Brazil | Pernambuco | 633807 | 20067 | 0 | -8.8137 | -36.9541 | 2021-11-07 04:21:53 | Pernambuco, Brazil | |||
499397 | 499397 | 2022-04-02 | Brazil | Pernambuco | 900432 | 21430 | 0 | -8.8137 | -36.9541 | 2022-04-03 04:20:48 | Pernambuco, Brazil | |||
503413 | 503413 | 2022-12-17 | Brazil | Pernambuco | 1106891 | 22527 | 0 | -8.8137 | -36.9541 | 2022-12-18 04:21:03 | Pernambuco, Brazil | |||
507428 | 507428 | 2021-08-14 | Brazil | Pernambuco | 600002 | 19152 | 0 | -8.8137 | -36.9541 | 2021-08-15 04:21:41 | Pernambuco, Brazil | |||
511442 | 511442 | 2021-08-19 | Brazil | Pernambuco | 602507 | 19224 | 0 | -8.8137 | -36.9541 | 2021-08-20 04:21:33 | Pernambuco, Brazil | |||
515457 | 515457 | 2022-10-15 | Brazil | Pernambuco | 1061247 | 22348 | 0 | -8.8137 | -36.9541 | 2022-10-16 04:22:39 | Pernambuco, Brazil | |||
522601 | 522601 | 2021-06-09 | Brazil | Pernambuco | 509184 | 16549 | 416397 | 76238 | -8.8137 | -36.9541 | 2021-06-10 04:23:17 | Pernambuco, Brazil | ||
530021 | 530021 | 2020-07-04 | Brazil | Pernambuco | 63457 | 5116 | 41925 | 16416 | -8.8137 | -36.9541 | 2020-07-05 04:33:46 | Pernambuco, Brazil | ||
530450 | 530450 | 2021-02-22 | Brazil | Pernambuco | 291189 | 10863 | 249822 | 30504 | -8.8137 | -36.9541 | 2021-02-23 05:23:41 | Pernambuco, Brazil | ||
534464 | 534464 | 2021-10-27 | Brazil | Pernambuco | 629789 | 19970 | 0 | -8.8137 | -36.9541 | 2021-10-28 04:22:08 | Pernambuco, Brazil | |||
538481 | 538481 | 2022-10-26 | Brazil | Pernambuco | 1063149 | 22393 | 0 | -8.8137 | -36.9541 | 2022-10-27 04:22:01 | Pernambuco, Brazil | |||
542497 | 542497 | 2022-12-15 | Brazil | Pernambuco | 1104849 | 22524 | 0 | -8.8137 | -36.9541 | 2022-12-16 04:21:01 | Pernambuco, Brazil | |||
546501 | 546501 | 2020-09-12 | Brazil | Pernambuco | 136413 | 7852 | 118239 | 10322 | -8.8137 | -36.9541 | 2020-09-13 04:30:52 | Pernambuco, Brazil | ||
550502 | 550502 | 2021-12-08 | Brazil | Pernambuco | 642496 | 20294 | 0 | -8.8137 | -36.9541 | 2021-12-09 04:22:49 | Pernambuco, Brazil | |||
554518 | 554518 | 2022-01-16 | Brazil | Pernambuco | 655069 | 20548 | 0 | -8.8137 | -36.9541 | 2022-01-17 04:21:08 | Pernambuco, Brazil | |||
558535 | 558535 | 2022-06-16 | Brazil | Pernambuco | 950225 | 21793 | 0 | -8.8137 | -36.9541 | 2022-06-17 04:20:56 | Pernambuco, Brazil | |||
562711 | 562711 | 2021-06-22 | Brazil | Pernambuco | 539815 | 17343 | 449231 | 73241 | -8.8137 | -36.9541 | 2021-06-23 04:21:46 | Pernambuco, Brazil | ||
566832 | 566832 | 2021-10-29 | Brazil | Pernambuco | 630980 | 20001 | 0 | -8.8137 | -36.9541 | 2021-10-30 04:22:03 | Pernambuco, Brazil | |||
574139 | 574139 | 2020-06-06 | Brazil | Pernambuco | 39361 | 3270 | 0 | 36091 | -8.8137 | -36.9541 | 2020-06-07 03:53:30 | Pernambuco, Brazil | ||
574561 | 574561 | 2022-02-25 | Brazil | Pernambuco | 821592 | 21048 | 0 | -8.8137 | -36.9541 | 2022-02-26 04:21:12 | Pernambuco, Brazil | |||
578576 | 578576 | 2021-07-13 | Brazil | Pernambuco | 572536 | 18166 | 489824 | 64546 | -8.8137 | -36.9541 | 2021-07-14 04:21:35 | Pernambuco, Brazil | ||
582579 | 582579 | 2020-08-13 | Brazil | Pernambuco | 108842 | 7084 | 88252 | 13506 | -8.8137 | -36.9541 | 2020-08-14 04:51:19 | Pernambuco, Brazil | ||
589372 | 589372 | 2021-08-08 | Brazil | Pernambuco | 595842 | 19016 | 0 | -8.8137 | -36.9541 | 2021-08-09 04:21:24 | Pernambuco, Brazil | |||
593387 | 593387 | 2022-07-01 | Brazil | Pernambuco | 979346 | 21870 | 0 | -8.8137 | -36.9541 | 2022-07-02 04:21:16 | Pernambuco, Brazil | |||
597402 | 597402 | 2021-10-19 | Brazil | Pernambuco | 626781 | 19908 | 0 | -8.8137 | -36.9541 | 2021-10-20 04:21:00 | Pernambuco, Brazil | |||
601418 | 601418 | 2021-09-23 | Brazil | Pernambuco | 617304 | 19659 | 0 | -8.8137 | -36.9541 | 2021-09-24 04:21:44 | Pernambuco, Brazil | |||
605433 | 605433 | 2021-04-09 | Brazil | Pernambuco | 366346 | 12686 | 307902 | 45758 | -8.8137 | -36.9541 | 2021-04-10 04:20:59 | Pernambuco, Brazil | ||
609436 | 609436 | 2020-08-29 | Brazil | Pernambuco | 124151 | 7547 | 105381 | 11223 | -8.8137 | -36.9541 | 2020-08-30 04:28:22 | Pernambuco, Brazil | ||
613433 | 613433 | 2021-02-08 | Brazil | Pernambuco | 271542 | 10508 | 226973 | 33334 | -8.8137 | -36.9541 | 2021-02-09 05:23:30 | Pernambuco, Brazil | ||
617591 | 617591 | 2022-11-05 | Brazil | Pernambuco | 1066026 | 22413 | 0 | -8.8137 | -36.9541 | 2022-11-06 04:21:24 | Pernambuco, Brazil | |||
621607 | 621607 | 2022-05-22 | Brazil | Pernambuco | 934383 | 21700 | 0 | -8.8137 | -36.9541 | 2022-05-26 04:20:50 | Pernambuco, Brazil | |||
625622 | 625622 | 2021-07-10 | Brazil | Pernambuco | 568940 | 18100 | 488843 | 61997 | -8.8137 | -36.9541 | 2021-07-11 04:21:43 | Pernambuco, Brazil | ||
629637 | 629637 | 2022-07-12 | Brazil | Pernambuco | 1002825 | 21933 | 0 | -8.8137 | -36.9541 | 2022-07-13 04:20:58 | Pernambuco, Brazil | |||
633652 | 633652 | 2021-10-13 | Brazil | Pernambuco | 624730 | 19857 | 0 | -8.8137 | -36.9541 | 2021-10-14 04:21:29 | Pernambuco, Brazil | |||
637668 | 637668 | 2021-03-31 | Brazil | Pernambuco | 349231 | 12175 | 293723 | 43333 | -8.8137 | -36.9541 | 2021-04-01 04:27:05 | Pernambuco, Brazil | ||
641682 | 641682 | 2021-09-07 | Brazil | Pernambuco | 610980 | 19476 | 0 | -8.8137 | -36.9541 | 2021-09-08 04:21:31 | Pernambuco, Brazil | |||
645696 | 645696 | 2021-05-05 | Brazil | Pernambuco | 414929 | 14333 | 348230 | 52366 | -8.8137 | -36.9541 | 2021-05-06 04:20:38 | Pernambuco, Brazil | ||
649710 | 649710 | 2021-08-09 | Brazil | Pernambuco | 595942 | 19028 | 0 | -8.8137 | -36.9541 | 2021-08-10 04:21:27 | Pernambuco, Brazil | |||
653724 | 653724 | 2021-10-22 | Brazil | Pernambuco | 628125 | 19935 | 0 | -8.8137 | -36.9541 | 2021-10-23 04:21:32 | Pernambuco, Brazil | |||
658043 | 658043 | 2022-05-13 | Brazil | Pernambuco | 930411 | 21657 | 0 | -8.8137 | -36.9541 | 2022-05-14 04:20:48 | Pernambuco, Brazil | |||
662047 | 662047 | 2020-08-11 | Brazil | Pernambuco | 105982 | 7008 | 85731 | 13243 | -8.8137 | -36.9541 | 2020-08-12 04:27:29 | Pernambuco, Brazil | ||
666026 | 666026 | 2020-09-16 | Brazil | Pernambuco | 138568 | 7933 | 119554 | 11081 | -8.8137 | -36.9541 | 2020-09-17 04:22:00 | Pernambuco, Brazil | ||
670028 | 670028 | 2022-07-21 | Brazil | Pernambuco | 1019012 | 21992 | 0 | -8.8137 | -36.9541 | 2022-07-22 04:21:15 | Pernambuco, Brazil | |||
674044 | 674044 | 2022-07-30 | Brazil | Pernambuco | 1028988 | 22042 | 0 | -8.8137 | -36.9541 | 2022-07-31 04:21:02 | Pernambuco, Brazil | |||
678059 | 678059 | 2020-11-23 | Brazil | Pernambuco | 176158 | 8926 | 156384 | 10848 | -8.8137 | -36.9541 | 2020-11-24 05:27:31 | Pernambuco, Brazil | ||
682069 | 682069 | 2021-10-24 | Brazil | Pernambuco | 628757 | 19944 | 0 | -8.8137 | -36.9541 | 2021-10-25 04:22:31 | Pernambuco, Brazil | |||
686085 | 686085 | 2021-11-13 | Brazil | Pernambuco | 635910 | 20115 | 0 | -8.8137 | -36.9541 | 2021-11-14 04:21:31 | Pernambuco, Brazil | |||
690102 | 690102 | 2022-12-23 | Brazil | Pernambuco | 1115463 | 22553 | 0 | -8.8137 | -36.9541 | 2022-12-24 04:21:02 | Pernambuco, Brazil | |||
694118 | 694118 | 2022-03-17 | Brazil | Pernambuco | 874704 | 21253 | 0 | -8.8137 | -36.9541 | 2022-03-18 04:20:55 | Pernambuco, Brazil | |||
698133 | 698133 | 2021-11-04 | Brazil | Pernambuco | 632676 | 20048 | 0 | -8.8137 | -36.9541 | 2021-11-05 04:21:54 | Pernambuco, Brazil | |||
702149 | 702149 | 2021-03-16 | Brazil | Pernambuco | 320931 | 11471 | 275733 | 33727 | -8.8137 | -36.9541 | 2021-03-17 05:25:07 | Pernambuco, Brazil | ||
706163 | 706163 | 2021-09-29 | Brazil | Pernambuco | 620174 | 19724 | 0 | -8.8137 | -36.9541 | 2021-09-30 04:21:20 | Pernambuco, Brazil | |||
710179 | 710179 | 2022-11-01 | Brazil | Pernambuco | 1065225 | 22410 | 0 | -8.8137 | -36.9541 | 2022-11-02 04:22:09 | Pernambuco, Brazil | |||
714194 | 714194 | 2021-11-12 | Brazil | Pernambuco | 635488 | 20107 | 0 | -8.8137 | -36.9541 | 2021-11-13 04:21:38 | Pernambuco, Brazil | |||
718211 | 718211 | 2022-12-04 | Brazil | Pernambuco | 1089123 | 22482 | 0 | -8.8137 | -36.9541 | 2022-12-05 04:20:58 | Pernambuco, Brazil | |||
722226 | 722226 | 2021-11-20 | Brazil | Pernambuco | 637396 | 20166 | 0 | -8.8137 | -36.9541 | 2021-11-21 04:22:13 | Pernambuco, Brazil | |||
726242 | 726242 | 2021-05-22 | Brazil | Pernambuco | 460279 | 15325 | 381891 | 63063 | -8.8137 | -36.9541 | 2021-05-23 04:20:51 | Pernambuco, Brazil | ||
730256 | 730256 | 2021-12-27 | Brazil | Pernambuco | 644189 | 20414 | 0 | -8.8137 | -36.9541 | 2021-12-28 04:21:47 | Pernambuco, Brazil | |||
737618 | 737618 | 2020-06-12 | Brazil | Pernambuco | 43872 | 3694 | 25794 | 14384 | -8.8137 | -36.9541 | 2020-06-13 03:33:14 | Pernambuco, Brazil | ||
738047 | 738047 | 2020-12-02 | Brazil | Pernambuco | 185607 | 9082 | 163498 | 13027 | -8.8137 | -36.9541 | 2020-12-03 05:28:22 | Pernambuco, Brazil | ||
742058 | 742058 | 2021-02-20 | Brazil | Pernambuco | 289556 | 10839 | 249822 | 28895 | -8.8137 | -36.9541 | 2021-02-21 05:24:33 | Pernambuco, Brazil | ||
746073 | 746073 | 2022-04-23 | Brazil | Pernambuco | 918045 | 21566 | 0 | -8.8137 | -36.9541 | 2022-04-24 04:20:56 | Pernambuco, Brazil | |||
753626 | 753626 | 2020-08-01 | Brazil | Pernambuco | 96746 | 6597 | 70967 | 19182 | -8.8137 | -36.9541 | 2020-08-02 04:34:47 | Pernambuco, Brazil | ||
754049 | 754049 | 2020-10-28 | Brazil | Pernambuco | 161161 | 8587 | 142674 | 9900 | -8.8137 | -36.9541 | 2020-10-29 04:24:49 | Pernambuco, Brazil | ||
758056 | 758056 | 2021-11-26 | Brazil | Pernambuco | 639000 | 20217 | 0 | -8.8137 | -36.9541 | 2021-11-27 04:22:45 | Pernambuco, Brazil | |||
762061 | 762061 | 2020-10-18 | Brazil | Pernambuco | 156029 | 8487 | 131135 | 16308 | -8.8137 | -36.9541 | 2020-10-19 04:24:16 | Pernambuco, Brazil | ||
766066 | 766066 | 2020-12-29 | Brazil | Pernambuco | 217772 | 9612 | 184966 | 23194 | -8.8137 | -36.9541 | 2020-12-30 05:22:34 | Pernambuco, Brazil | ||
770077 | 770077 | 2021-10-23 | Brazil | Pernambuco | 628588 | 19940 | 0 | -8.8137 | -36.9541 | 2021-10-24 04:21:22 | Pernambuco, Brazil | |||
774093 | 774093 | 2021-01-12 | Brazil | Pernambuco | 234238 | 9889 | 198249 | 26100 | -8.8137 | -36.9541 | 2021-01-13 05:22:15 | Pernambuco, Brazil | ||
778105 | 778105 | 2021-07-08 | Brazil | Pernambuco | 564789 | 18023 | 475280 | 71486 | -8.8137 | -36.9541 | 2021-07-09 04:21:21 | Pernambuco, Brazil | ||
782119 | 782119 | 2021-12-13 | Brazil | Pernambuco | 643336 | 20327 | 0 | -8.8137 | -36.9541 | 2021-12-14 04:22:38 | Pernambuco, Brazil | |||
786124 | 786124 | 2020-10-15 | Brazil | Pernambuco | 154866 | 8456 | 131135 | 15275 | -8.8137 | -36.9541 | 2020-10-16 04:24:01 | Pernambuco, Brazil | ||
790128 | 790128 | 2021-02-04 | Brazil | Pernambuco | 266999 | 10430 | 226973 | 29596 | -8.8137 | -36.9541 | 2021-02-05 05:22:38 | Pernambuco, Brazil | ||
794143 | 794143 | 2022-10-24 | Brazil | Pernambuco | 1062457 | 22380 | 0 | -8.8137 | -36.9541 | 2022-10-25 04:21:53 | Pernambuco, Brazil | |||
798158 | 798158 | 2021-12-22 | Brazil | Pernambuco | 643441 | 20387 | 0 | -8.8137 | -36.9541 | 2021-12-23 04:21:21 | Pernambuco, Brazil | |||
805439 | 805439 | 2020-06-01 | Brazil | Pernambuco | 34900 | 2875 | 0 | 32025 | -8.8137 | -36.9541 | 2020-06-02 02:33:08 | Pernambuco, Brazil | ||
809320 | 809320 | 2021-09-20 | Brazil | Pernambuco | 615823 | 19620 | 0 | -8.8137 | -36.9541 | 2021-09-21 04:21:26 | Pernambuco, Brazil | |||
813324 | 813324 | 2020-09-05 | Brazil | Pernambuco | 131961 | 7670 | 113496 | 10795 | -8.8137 | -36.9541 | 2020-09-06 04:28:33 | Pernambuco, Brazil | ||
817314 | 817314 | 2020-10-09 | Brazil | Pernambuco | 152414 | 8397 | 131135 | 12882 | -8.8137 | -36.9541 | 2020-10-10 04:23:57 | Pernambuco, Brazil | ||
821317 | 821317 | 2020-11-19 | Brazil | Pernambuco | 173624 | 8890 | 154312 | 10422 | -8.8137 | -36.9541 | 2020-11-20 05:26:28 | Pernambuco, Brazil | ||
825327 | 825327 | 2021-06-06 | Brazil | Pernambuco | 499572 | 16292 | 414367 | 68913 | -8.8137 | -36.9541 | 2021-06-07 04:22:51 | Pernambuco, Brazil | ||
829341 | 829341 | 2021-07-09 | Brazil | Pernambuco | 566979 | 18068 | 475280 | 73631 | -8.8137 | -36.9541 | 2021-07-10 04:21:25 | Pernambuco, Brazil |
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]);