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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1491330 | 1491330 | 2021-10-12 | Brazil | Pernambuco | 624559 | 19855 | 0 | -8.8137 | -36.9541 | 2021-10-13 04:20:51 | Pernambuco, Brazil | |||
3007063 | 3007063 | 2021-10-11 | Brazil | Pernambuco | 624349 | 19850 | 0 | -8.8137 | -36.9541 | 2021-10-12 04:21:09 | Pernambuco, Brazil | |||
423079 | 423079 | 2021-10-10 | Brazil | Pernambuco | 624197 | 19845 | 0 | -8.8137 | -36.9541 | 2021-10-11 04:21:31 | Pernambuco, Brazil | |||
2875936 | 2875936 | 2021-10-09 | Brazil | Pernambuco | 624018 | 19839 | 0 | -8.8137 | -36.9541 | 2021-10-10 04:21:38 | Pernambuco, Brazil | |||
2959102 | 2959102 | 2021-10-08 | Brazil | Pernambuco | 623561 | 19829 | 0 | -8.8137 | -36.9541 | 2021-10-09 04:21:34 | Pernambuco, Brazil | |||
467140 | 467140 | 2021-10-07 | Brazil | Pernambuco | 623144 | 19817 | 0 | -8.8137 | -36.9541 | 2021-10-08 04:21:25 | Pernambuco, Brazil | |||
2458520 | 2458520 | 2021-10-06 | Brazil | Pernambuco | 622742 | 19805 | 0 | -8.8137 | -36.9541 | 2021-10-07 04:21:36 | Pernambuco, Brazil | |||
3832214 | 3832214 | 2021-10-05 | Brazil | Pernambuco | 622302 | 19793 | 0 | -8.8137 | -36.9541 | 2021-10-06 04:21:33 | Pernambuco, Brazil | |||
986707 | 986707 | 2021-10-04 | Brazil | Pernambuco | 621928 | 19780 | 0 | -8.8137 | -36.9541 | 2021-10-05 04:21:27 | Pernambuco, Brazil | |||
1274017 | 1274017 | 2021-10-03 | Brazil | Pernambuco | 621834 | 19764 | 0 | -8.8137 | -36.9541 | 2021-10-04 04:21:31 | Pernambuco, Brazil | |||
3927770 | 3927770 | 2021-10-02 | Brazil | Pernambuco | 621633 | 19754 | 0 | -8.8137 | -36.9541 | 2021-10-03 04:21:24 | Pernambuco, Brazil | |||
2131750 | 2131750 | 2021-10-01 | Brazil | Pernambuco | 621192 | 19747 | 0 | -8.8137 | -36.9541 | 2021-10-02 04:21:25 | Pernambuco, Brazil | |||
2772707 | 2772707 | 2021-09-30 | Brazil | Pernambuco | 620723 | 19740 | 0 | -8.8137 | -36.9541 | 2021-10-01 04:21:35 | Pernambuco, Brazil | |||
706163 | 706163 | 2021-09-29 | Brazil | Pernambuco | 620174 | 19724 | 0 | -8.8137 | -36.9541 | 2021-09-30 04:21:20 | Pernambuco, Brazil | |||
1334005 | 1334005 | 2021-09-28 | Brazil | Pernambuco | 619551 | 19712 | 0 | -8.8137 | -36.9541 | 2021-09-29 04:21:45 | Pernambuco, Brazil | |||
1235374 | 1235374 | 2021-09-27 | Brazil | Pernambuco | 619239 | 19700 | 0 | -8.8137 | -36.9541 | 2021-09-28 04:21:28 | Pernambuco, Brazil | |||
2075675 | 2075675 | 2021-09-26 | Brazil | Pernambuco | 619048 | 19693 | 0 | -8.8137 | -36.9541 | 2021-09-27 04:21:16 | Pernambuco, Brazil | |||
1724227 | 1724227 | 2021-09-25 | Brazil | Pernambuco | 618843 | 19683 | 0 | -8.8137 | -36.9541 | 2021-09-26 04:21:29 | Pernambuco, Brazil | |||
1920947 | 1920947 | 2021-09-24 | Brazil | Pernambuco | 618327 | 19673 | 0 | -8.8137 | -36.9541 | 2021-09-25 04:21:31 | Pernambuco, Brazil | |||
601418 | 601418 | 2021-09-23 | Brazil | Pernambuco | 617304 | 19659 | 0 | -8.8137 | -36.9541 | 2021-09-24 04:21:44 | Pernambuco, Brazil | |||
3011079 | 3011079 | 2021-09-22 | Brazil | Pernambuco | 616910 | 19647 | 0 | -8.8137 | -36.9541 | 2021-09-23 04:21:43 | Pernambuco, Brazil | |||
3757217 | 3757217 | 2021-09-21 | Brazil | Pernambuco | 616128 | 19639 | 0 | -8.8137 | -36.9541 | 2021-09-22 04:21:45 | Pernambuco, Brazil | |||
809320 | 809320 | 2021-09-20 | Brazil | Pernambuco | 615823 | 19620 | 0 | -8.8137 | -36.9541 | 2021-09-21 04:21:26 | Pernambuco, Brazil | |||
1814519 | 1814519 | 2021-09-19 | Brazil | Pernambuco | 615672 | 19612 | 0 | -8.8137 | -36.9541 | 2021-09-20 04:21:22 | Pernambuco, Brazil | |||
16099 | 16099 | 2021-09-18 | Brazil | Pernambuco | 615550 | 19605 | 0 | -8.8137 | -36.9541 | 2021-09-19 04:21:34 | Pernambuco, Brazil | |||
2617784 | 2617784 | 2021-09-17 | Brazil | Pernambuco | 615196 | 19595 | 0 | -8.8137 | -36.9541 | 2021-09-18 04:21:24 | Pernambuco, Brazil | |||
2808492 | 2808492 | 2021-09-16 | Brazil | Pernambuco | 614860 | 19586 | 0 | -8.8137 | -36.9541 | 2021-09-17 04:21:46 | Pernambuco, Brazil | |||
1374237 | 1374237 | 2021-09-15 | Brazil | Pernambuco | 614430 | 19574 | 0 | -8.8137 | -36.9541 | 2021-09-16 04:22:19 | Pernambuco, Brazil | |||
2462536 | 2462536 | 2021-09-14 | Brazil | Pernambuco | 614141 | 19560 | 0 | -8.8137 | -36.9541 | 2021-09-15 03:22:37 | Pernambuco, Brazil | |||
1385375 | 1385375 | 2021-09-13 | Brazil | Pernambuco | 613526 | 19552 | 0 | -8.8137 | -36.9541 | 2021-09-14 04:21:41 | Pernambuco, Brazil | |||
1884744 | 1884744 | 2021-09-12 | Brazil | Pernambuco | 613436 | 19539 | 0 | -8.8137 | -36.9541 | 2021-09-13 04:21:15 | Pernambuco, Brazil | |||
3805647 | 3805647 | 2021-09-11 | Brazil | Pernambuco | 612857 | 19529 | 0 | -8.8137 | -36.9541 | 2021-09-12 04:21:13 | Pernambuco, Brazil | |||
3448587 | 3448587 | 2021-09-10 | Brazil | Pernambuco | 612680 | 19511 | 0 | -8.8137 | -36.9541 | 2021-09-11 04:21:30 | Pernambuco, Brazil | |||
1262533 | 1262533 | 2021-09-09 | Brazil | Pernambuco | 611739 | 19497 | 0 | -8.8137 | -36.9541 | 2021-09-10 04:21:20 | Pernambuco, Brazil | |||
2278903 | 2278903 | 2021-09-08 | Brazil | Pernambuco | 611475 | 19485 | 0 | -8.8137 | -36.9541 | 2021-09-09 04:21:27 | Pernambuco, Brazil | |||
641682 | 641682 | 2021-09-07 | Brazil | Pernambuco | 610980 | 19476 | 0 | -8.8137 | -36.9541 | 2021-09-08 04:21:31 | Pernambuco, Brazil | |||
3193745 | 3193745 | 2021-09-06 | Brazil | Pernambuco | 610740 | 19469 | 0 | -8.8137 | -36.9541 | 2021-09-07 04:21:35 | Pernambuco, Brazil | |||
3280613 | 3280613 | 2021-09-05 | Brazil | Pernambuco | 610297 | 19462 | 0 | -8.8137 | -36.9541 | 2021-09-06 04:21:22 | Pernambuco, Brazil | |||
249027 | 249027 | 2021-09-04 | Brazil | Pernambuco | 610059 | 19451 | 0 | -8.8137 | -36.9541 | 2021-09-05 04:21:33 | Pernambuco, Brazil | |||
3974308 | 3974308 | 2021-09-03 | Brazil | Pernambuco | 609698 | 19445 | 0 | -8.8137 | -36.9541 | 2021-09-04 04:21:28 | Pernambuco, Brazil | |||
177770 | 177770 | 2021-09-02 | Brazil | Pernambuco | 609157 | 19425 | 0 | -8.8137 | -36.9541 | 2021-09-03 04:21:20 | Pernambuco, Brazil | |||
66805 | 66805 | 2021-09-01 | Brazil | Pernambuco | 608586 | 19411 | 0 | -8.8137 | -36.9541 | 2021-09-02 04:21:15 | Pernambuco, Brazil | |||
2067647 | 2067647 | 2021-08-31 | Brazil | Pernambuco | 607529 | 19383 | 0 | -8.8137 | -36.9541 | 2021-09-01 04:21:38 | Pernambuco, Brazil | |||
1775101 | 1775101 | 2021-08-30 | Brazil | Pernambuco | 607021 | 19370 | 0 | -8.8137 | -36.9541 | 2021-08-31 04:21:46 | Pernambuco, Brazil | |||
3891675 | 3891675 | 2021-08-29 | Brazil | Pernambuco | 606670 | 19364 | 0 | -8.8137 | -36.9541 | 2021-08-30 04:21:23 | Pernambuco, Brazil | |||
2792778 | 2792778 | 2021-08-28 | Brazil | Pernambuco | 606439 | 19359 | 0 | -8.8137 | -36.9541 | 2021-08-29 04:21:14 | Pernambuco, Brazil | |||
2922937 | 2922937 | 2021-08-27 | Brazil | Pernambuco | 606004 | 19345 | 0 | -8.8137 | -36.9541 | 2021-08-28 04:21:28 | Pernambuco, Brazil | |||
1595951 | 1595951 | 2021-08-26 | Brazil | Pernambuco | 605518 | 19337 | 0 | -8.8137 | -36.9541 | 2021-08-27 04:21:37 | Pernambuco, Brazil | |||
32160 | 32160 | 2021-08-25 | Brazil | Pernambuco | 604991 | 19329 | 0 | -8.8137 | -36.9541 | 2021-08-26 04:21:28 | Pernambuco, Brazil | |||
3105199 | 3105199 | 2021-08-24 | Brazil | Pernambuco | 604331 | 19314 | 0 | -8.8137 | -36.9541 | 2021-08-25 04:21:41 | Pernambuco, Brazil | |||
3165370 | 3165370 | 2021-08-23 | Brazil | Pernambuco | 603827 | 19306 | 0 | -8.8137 | -36.9541 | 2021-08-24 04:21:19 | Pernambuco, Brazil | |||
2175297 | 2175297 | 2021-08-22 | Brazil | Pernambuco | 603713 | 19296 | 0 | -8.8137 | -36.9541 | 2021-08-23 04:21:27 | Pernambuco, Brazil | |||
3555393 | 3555393 | 2021-08-21 | Brazil | Pernambuco | 603534 | 19287 | 0 | -8.8137 | -36.9541 | 2021-08-22 04:21:29 | Pernambuco, Brazil | |||
1853735 | 1853735 | 2021-08-20 | Brazil | Pernambuco | 603057 | 19262 | 0 | -8.8137 | -36.9541 | 2021-08-21 04:21:38 | Pernambuco, Brazil | |||
511442 | 511442 | 2021-08-19 | Brazil | Pernambuco | 602507 | 19224 | 0 | -8.8137 | -36.9541 | 2021-08-20 04:21:33 | Pernambuco, Brazil | |||
2517921 | 2517921 | 2021-08-18 | Brazil | Pernambuco | 601974 | 19213 | 0 | -8.8137 | -36.9541 | 2021-08-19 04:21:15 | Pernambuco, Brazil | |||
245013 | 245013 | 2021-08-17 | Brazil | Pernambuco | 601076 | 19188 | 0 | -8.8137 | -36.9541 | 2021-08-18 04:21:35 | Pernambuco, Brazil | |||
1603976 | 1603976 | 2021-08-16 | Brazil | Pernambuco | 600492 | 19173 | 0 | -8.8137 | -36.9541 | 2021-08-17 04:21:49 | Pernambuco, Brazil | |||
103070 | 103070 | 2021-08-15 | Brazil | Pernambuco | 600292 | 19160 | 0 | -8.8137 | -36.9541 | 2021-08-16 04:21:31 | Pernambuco, Brazil | |||
507428 | 507428 | 2021-08-14 | Brazil | Pernambuco | 600002 | 19152 | 0 | -8.8137 | -36.9541 | 2021-08-15 04:21:41 | Pernambuco, Brazil | |||
1483300 | 1483300 | 2021-08-13 | Brazil | Pernambuco | 598708 | 19135 | 0 | -8.8137 | -36.9541 | 2021-08-14 04:21:25 | Pernambuco, Brazil | |||
2899430 | 2899430 | 2021-08-12 | Brazil | Pernambuco | 598050 | 19117 | 0 | -8.8137 | -36.9541 | 2021-08-13 04:21:24 | Pernambuco, Brazil | |||
1342034 | 1342034 | 2021-08-11 | Brazil | Pernambuco | 597338 | 19101 | 0 | -8.8137 | -36.9541 | 2021-08-12 04:21:25 | Pernambuco, Brazil | |||
2351181 | 2351181 | 2021-08-10 | Brazil | Pernambuco | 596513 | 19072 | 0 | -8.8137 | -36.9541 | 2021-08-11 04:21:58 | Pernambuco, Brazil | |||
649710 | 649710 | 2021-08-09 | Brazil | Pernambuco | 595942 | 19028 | 0 | -8.8137 | -36.9541 | 2021-08-10 04:21:27 | Pernambuco, Brazil | |||
589372 | 589372 | 2021-08-08 | Brazil | Pernambuco | 595842 | 19016 | 0 | -8.8137 | -36.9541 | 2021-08-09 04:21:24 | Pernambuco, Brazil | |||
2203384 | 2203384 | 2021-08-07 | Brazil | Pernambuco | 595519 | 19005 | 0 | -8.8137 | -36.9541 | 2021-08-08 04:21:33 | Pernambuco, Brazil | |||
1117334 | 1117334 | 2021-08-06 | Brazil | Pernambuco | 594796 | 18967 | 0 | -8.8137 | -36.9541 | 2021-08-07 04:21:30 | Pernambuco, Brazil | |||
1956271 | 1956271 | 2021-08-05 | Brazil | Pernambuco | 594106 | 18941 | 0 | -8.8137 | -36.9541 | 2021-08-06 04:21:18 | Pernambuco, Brazil | |||
331650 | 331650 | 2021-08-04 | Brazil | Pernambuco | 593462 | 18899 | 508262 | 66301 | -8.8137 | -36.9541 | 2021-08-05 04:21:51 | Pernambuco, Brazil | ||
3467921 | 3467921 | 2021-08-03 | Brazil | Pernambuco | 592724 | 18857 | 508262 | 65605 | -8.8137 | -36.9541 | 2021-08-04 04:21:25 | Pernambuco, Brazil | ||
3683195 | 3683195 | 2021-08-02 | Brazil | Pernambuco | 591952 | 18822 | 508262 | 64868 | -8.8137 | -36.9541 | 2021-08-03 04:21:39 | Pernambuco, Brazil | ||
3015094 | 3015094 | 2021-08-01 | Brazil | Pernambuco | 591428 | 18808 | 508262 | 64358 | -8.8137 | -36.9541 | 2021-08-02 04:21:36 | Pernambuco, Brazil | ||
3903717 | 3903717 | 2021-07-31 | Brazil | Pernambuco | 590785 | 18784 | 508262 | 63739 | -8.8137 | -36.9541 | 2021-08-01 04:21:50 | Pernambuco, Brazil | ||
3295922 | 3295922 | 2021-07-30 | Brazil | Pernambuco | 589843 | 18768 | 508262 | 62813 | -8.8137 | -36.9541 | 2021-07-31 04:21:35 | Pernambuco, Brazil | ||
3385133 | 3385133 | 2021-07-29 | Brazil | Pernambuco | 588887 | 18736 | 508262 | 61889 | -8.8137 | -36.9541 | 2021-07-30 04:21:34 | Pernambuco, Brazil | ||
408038 | 408038 | 2021-07-28 | Brazil | Pernambuco | 587849 | 18702 | 508262 | 60885 | -8.8137 | -36.9541 | 2021-07-29 04:21:33 | Pernambuco, Brazil | ||
1305899 | 1305899 | 2021-07-27 | Brazil | Pernambuco | 586854 | 18665 | 508262 | 59927 | -8.8137 | -36.9541 | 2021-07-28 04:21:39 | Pernambuco, Brazil | ||
3218042 | 3218042 | 2021-07-26 | Brazil | Pernambuco | 586023 | 18629 | 508262 | 59132 | -8.8137 | -36.9541 | 2021-07-27 04:21:18 | Pernambuco, Brazil | ||
1378251 | 1378251 | 2021-07-25 | Brazil | Pernambuco | 585614 | 18616 | 508262 | 58736 | -8.8137 | -36.9541 | 2021-07-26 04:21:28 | Pernambuco, Brazil | ||
1329991 | 1329991 | 2021-07-24 | Brazil | Pernambuco | 584669 | 18599 | 508262 | 57808 | -8.8137 | -36.9541 | 2021-07-25 04:22:12 | Pernambuco, Brazil | ||
3137295 | 3137295 | 2021-07-23 | Brazil | Pernambuco | 583969 | 18548 | 500584 | 64837 | -8.8137 | -36.9541 | 2021-07-24 00:21:36 | Pernambuco, Brazil | ||
3476055 | 3476055 | 2021-07-22 | Brazil | Pernambuco | 582849 | 18502 | 500584 | 63763 | -8.8137 | -36.9541 | 2021-07-23 04:21:29 | Pernambuco, Brazil | ||
3331274 | 3331274 | 2021-07-21 | Brazil | Pernambuco | 581593 | 18444 | 500584 | 62565 | -8.8137 | -36.9541 | 2021-07-22 04:21:19 | Pernambuco, Brazil | ||
2371255 | 2371255 | 2021-07-20 | Brazil | Pernambuco | 579779 | 18388 | 500584 | 60807 | -8.8137 | -36.9541 | 2021-07-21 04:21:40 | 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 | ||
2673557 | 2673557 | 2021-07-18 | Brazil | Pernambuco | 579086 | 18325 | 497027 | 63734 | -8.8137 | -36.9541 | 2021-07-19 04:21:24 | Pernambuco, Brazil | ||
3705869 | 3705869 | 2021-07-17 | Brazil | Pernambuco | 578448 | 18304 | 497027 | 63117 | -8.8137 | -36.9541 | 2021-07-18 04:22:07 | Pernambuco, Brazil | ||
2947100 | 2947100 | 2021-07-16 | Brazil | Pernambuco | 577115 | 18294 | 497027 | 61794 | -8.8137 | -36.9541 | 2021-07-17 04:22:22 | Pernambuco, Brazil | ||
295756 | 295756 | 2021-07-15 | Brazil | Pernambuco | 575865 | 18235 | 489824 | 67806 | -8.8137 | -36.9541 | 2021-07-16 04:21:22 | Pernambuco, Brazil | ||
3631701 | 3631701 | 2021-07-14 | Brazil | Pernambuco | 574681 | 18206 | 489824 | 66651 | -8.8137 | -36.9541 | 2021-07-15 04:21:48 | 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 | ||
3740825 | 3740825 | 2021-07-12 | Brazil | Pernambuco | 570246 | 18131 | 489824 | 62291 | -8.8137 | -36.9541 | 2021-07-13 04:21:18 | Pernambuco, Brazil | ||
3659338 | 3659338 | 2021-07-11 | Brazil | Pernambuco | 569863 | 18110 | 489824 | 61929 | -8.8137 | -36.9541 | 2021-07-12 04:21:34 | 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 | ||
829341 | 829341 | 2021-07-09 | Brazil | Pernambuco | 566979 | 18068 | 475280 | 73631 | -8.8137 | -36.9541 | 2021-07-10 04:21:25 | 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 | ||
1440327 | 1440327 | 2021-07-07 | Brazil | Pernambuco | 563264 | 17979 | 475280 | 70005 | -8.8137 | -36.9541 | 2021-07-08 04:21:26 | Pernambuco, Brazil | ||
2693432 | 2693432 | 2021-07-06 | Brazil | Pernambuco | 561505 | 17953 | 475280 | 68272 | -8.8137 | -36.9541 | 2021-07-07 04:21:20 | Pernambuco, Brazil | ||
1932181 | 1932181 | 2021-07-05 | Brazil | Pernambuco | 559358 | 17908 | 475280 | 66170 | -8.8137 | -36.9541 | 2021-07-06 04:21:32 | 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]);