johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,015 rows where country_or_region = "Madagascar" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- Madagascar · 544 ✖
province_or_state 0
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2462859 | 2462859 | 2021-09-14 | Madagascar | 42898 | 958 | 0 | -18.766947000000002 | 46.869107 | 2021-09-15 03:22:37 | Madagascar | ||||
1385698 | 1385698 | 2021-09-13 | Madagascar | 42898 | 958 | 0 | -18.766947000000002 | 46.869107 | 2021-09-14 04:21:41 | Madagascar | ||||
1885067 | 1885067 | 2021-09-12 | Madagascar | 42894 | 958 | 0 | -18.766947000000002 | 46.869107 | 2021-09-13 04:21:15 | Madagascar | ||||
3805970 | 3805970 | 2021-09-11 | Madagascar | 42894 | 958 | 0 | -18.766947000000002 | 46.869107 | 2021-09-12 04:21:13 | Madagascar | ||||
3448910 | 3448910 | 2021-09-10 | Madagascar | 42891 | 958 | 0 | -18.766947000000002 | 46.869107 | 2021-09-11 04:21:30 | Madagascar | ||||
1262856 | 1262856 | 2021-09-09 | Madagascar | 42884 | 957 | 0 | -18.766947000000002 | 46.869107 | 2021-09-10 04:21:20 | Madagascar | ||||
2279226 | 2279226 | 2021-09-08 | Madagascar | 42884 | 957 | 0 | -18.766947000000002 | 46.869107 | 2021-09-09 04:21:27 | Madagascar | ||||
642005 | 642005 | 2021-09-07 | Madagascar | 42884 | 957 | 0 | -18.766947000000002 | 46.869107 | 2021-09-08 04:21:31 | Madagascar | ||||
3194068 | 3194068 | 2021-09-06 | Madagascar | 42884 | 957 | 0 | -18.766947000000002 | 46.869107 | 2021-09-07 04:21:35 | Madagascar | ||||
3280936 | 3280936 | 2021-09-05 | Madagascar | 42884 | 957 | 0 | -18.766947000000002 | 46.869107 | 2021-09-06 04:21:22 | Madagascar | ||||
249350 | 249350 | 2021-09-04 | Madagascar | 42881 | 957 | 0 | -18.766947000000002 | 46.869107 | 2021-09-05 04:21:33 | Madagascar | ||||
3974631 | 3974631 | 2021-09-03 | Madagascar | 42878 | 956 | 0 | -18.766947000000002 | 46.869107 | 2021-09-04 04:21:28 | Madagascar | ||||
178093 | 178093 | 2021-09-02 | Madagascar | 42873 | 956 | 0 | -18.766947000000002 | 46.869107 | 2021-09-03 04:21:20 | Madagascar | ||||
67128 | 67128 | 2021-09-01 | Madagascar | 42873 | 956 | 0 | -18.766947000000002 | 46.869107 | 2021-09-02 04:21:15 | Madagascar | ||||
2067970 | 2067970 | 2021-08-31 | Madagascar | 42869 | 956 | 0 | -18.766947000000002 | 46.869107 | 2021-09-01 04:21:38 | Madagascar | ||||
1775424 | 1775424 | 2021-08-30 | Madagascar | 42862 | 955 | 0 | -18.766947000000002 | 46.869107 | 2021-08-31 04:21:46 | Madagascar | ||||
3891998 | 3891998 | 2021-08-29 | Madagascar | 42862 | 955 | 0 | -18.766947000000002 | 46.869107 | 2021-08-30 04:21:23 | Madagascar | ||||
2793101 | 2793101 | 2021-08-28 | Madagascar | 42862 | 955 | 0 | -18.766947000000002 | 46.869107 | 2021-08-29 04:21:14 | Madagascar | ||||
2923260 | 2923260 | 2021-08-27 | Madagascar | 42857 | 955 | 0 | -18.766947000000002 | 46.869107 | 2021-08-28 04:21:28 | Madagascar | ||||
1596274 | 1596274 | 2021-08-26 | Madagascar | 42854 | 955 | 0 | -18.766947000000002 | 46.869107 | 2021-08-27 04:21:37 | Madagascar | ||||
32483 | 32483 | 2021-08-25 | Madagascar | 42850 | 955 | 0 | -18.766947000000002 | 46.869107 | 2021-08-26 04:21:28 | Madagascar | ||||
3105522 | 3105522 | 2021-08-24 | Madagascar | 42847 | 955 | 0 | -18.766947000000002 | 46.869107 | 2021-08-25 04:21:41 | Madagascar | ||||
3165693 | 3165693 | 2021-08-23 | Madagascar | 42847 | 955 | 0 | -18.766947000000002 | 46.869107 | 2021-08-24 04:21:19 | Madagascar | ||||
2175620 | 2175620 | 2021-08-22 | Madagascar | 42845 | 954 | 0 | -18.766947000000002 | 46.869107 | 2021-08-23 04:21:27 | Madagascar | ||||
3555716 | 3555716 | 2021-08-21 | Madagascar | 42842 | 954 | 0 | -18.766947000000002 | 46.869107 | 2021-08-22 04:21:29 | Madagascar | ||||
1854058 | 1854058 | 2021-08-20 | Madagascar | 42838 | 954 | 0 | -18.766947000000002 | 46.869107 | 2021-08-21 04:21:38 | Madagascar | ||||
511765 | 511765 | 2021-08-19 | Madagascar | 42836 | 954 | 0 | -18.766947000000002 | 46.869107 | 2021-08-20 04:21:33 | Madagascar | ||||
2518244 | 2518244 | 2021-08-18 | Madagascar | 42832 | 954 | 0 | -18.766947000000002 | 46.869107 | 2021-08-19 04:21:15 | Madagascar | ||||
245336 | 245336 | 2021-08-17 | Madagascar | 42819 | 954 | 0 | -18.766947000000002 | 46.869107 | 2021-08-18 04:21:35 | Madagascar | ||||
1604299 | 1604299 | 2021-08-16 | Madagascar | 42819 | 954 | 0 | -18.766947000000002 | 46.869107 | 2021-08-17 04:21:49 | Madagascar | ||||
103393 | 103393 | 2021-08-15 | Madagascar | 42811 | 952 | 0 | -18.766947000000002 | 46.869107 | 2021-08-16 04:21:31 | Madagascar | ||||
507751 | 507751 | 2021-08-14 | Madagascar | 42811 | 952 | 0 | -18.766947000000002 | 46.869107 | 2021-08-15 04:21:41 | Madagascar | ||||
1483623 | 1483623 | 2021-08-13 | Madagascar | 42802 | 951 | 0 | -18.766947000000002 | 46.869107 | 2021-08-14 04:21:25 | Madagascar | ||||
2899753 | 2899753 | 2021-08-12 | Madagascar | 42795 | 950 | 0 | -18.766947000000002 | 46.869107 | 2021-08-13 04:21:24 | Madagascar | ||||
1342357 | 1342357 | 2021-08-11 | Madagascar | 42791 | 949 | 0 | -18.766947000000002 | 46.869107 | 2021-08-12 04:21:25 | Madagascar | ||||
2351504 | 2351504 | 2021-08-10 | Madagascar | 42787 | 948 | 0 | -18.766947000000002 | 46.869107 | 2021-08-11 04:21:58 | Madagascar | ||||
650033 | 650033 | 2021-08-09 | Madagascar | 42781 | 948 | 0 | -18.766947000000002 | 46.869107 | 2021-08-10 04:21:27 | Madagascar | ||||
589695 | 589695 | 2021-08-08 | Madagascar | 42776 | 948 | 0 | -18.766947 | 46.869107 | 2021-08-09 04:21:24 | Madagascar | ||||
2203707 | 2203707 | 2021-08-07 | Madagascar | 42685 | 943 | 0 | -18.766947 | 46.869107 | 2021-08-08 04:21:33 | Madagascar | ||||
1117657 | 1117657 | 2021-08-06 | Madagascar | 42685 | 943 | 0 | -18.766947 | 46.869107 | 2021-08-07 04:21:30 | Madagascar | ||||
1956594 | 1956594 | 2021-08-05 | Madagascar | 42685 | 943 | 0 | -18.766947 | 46.869107 | 2021-08-06 04:21:18 | Madagascar | ||||
331973 | 331973 | 2021-08-04 | Madagascar | 42685 | 943 | 41177 | 565 | -18.766947 | 46.869107 | 2021-08-05 04:21:51 | Madagascar | |||
3468244 | 3468244 | 2021-08-03 | Madagascar | 42674 | 943 | 41173 | 558 | -18.766947 | 46.869107 | 2021-08-04 04:21:25 | Madagascar | |||
3683518 | 3683518 | 2021-08-02 | Madagascar | 42672 | 943 | 41164 | 565 | -18.766947 | 46.869107 | 2021-08-03 04:21:39 | Madagascar | |||
3015417 | 3015417 | 2021-08-01 | Madagascar | 42665 | 943 | 41151 | 571 | -18.766947 | 46.869107 | 2021-08-02 04:21:36 | Madagascar | |||
3904040 | 3904040 | 2021-07-31 | Madagascar | 42663 | 943 | 41143 | 577 | -18.766947 | 46.869107 | 2021-08-01 04:21:50 | Madagascar | |||
3296245 | 3296245 | 2021-07-30 | Madagascar | 42652 | 943 | 41127 | 582 | -18.766947 | 46.869107 | 2021-07-31 04:21:35 | Madagascar | |||
3385456 | 3385456 | 2021-07-29 | Madagascar | 42645 | 942 | 41109 | 594 | -18.766947 | 46.869107 | 2021-07-30 04:21:34 | Madagascar | |||
408361 | 408361 | 2021-07-28 | Madagascar | 42615 | 942 | 41091 | 582 | -18.766947 | 46.869107 | 2021-07-29 04:21:33 | Madagascar | |||
1306222 | 1306222 | 2021-07-27 | Madagascar | 42607 | 941 | 41066 | 600 | -18.766947 | 46.869107 | 2021-07-28 04:21:39 | Madagascar | |||
3218365 | 3218365 | 2021-07-26 | Madagascar | 42599 | 940 | 41039 | 620 | -18.766947 | 46.869107 | 2021-07-27 04:21:18 | Madagascar | |||
1378574 | 1378574 | 2021-07-25 | Madagascar | 42599 | 939 | 41027 | 633 | -18.766947 | 46.869107 | 2021-07-26 04:21:28 | Madagascar | |||
1330314 | 1330314 | 2021-07-24 | Madagascar | 42590 | 939 | 41014 | 637 | -18.766947 | 46.869107 | 2021-07-25 04:22:12 | Madagascar | |||
3137618 | 3137618 | 2021-07-23 | Madagascar | 42581 | 939 | 40999 | 643 | -18.766947 | 46.869107 | 2021-07-24 00:21:36 | Madagascar | |||
3476378 | 3476378 | 2021-07-22 | Madagascar | 42561 | 937 | 40990 | 634 | -18.766947 | 46.869107 | 2021-07-23 04:21:29 | Madagascar | |||
3331597 | 3331597 | 2021-07-21 | Madagascar | 42558 | 937 | 40972 | 649 | -18.766947 | 46.869107 | 2021-07-22 04:21:19 | Madagascar | |||
2371578 | 2371578 | 2021-07-20 | Madagascar | 42551 | 937 | 40951 | 663 | -18.766947 | 46.869107 | 2021-07-21 04:21:40 | Madagascar | |||
483657 | 483657 | 2021-07-19 | Madagascar | 42538 | 937 | 40932 | 669 | -18.766947 | 46.869107 | 2021-07-20 04:21:48 | Madagascar | |||
2673880 | 2673880 | 2021-07-18 | Madagascar | 42536 | 937 | 40916 | 683 | -18.766947 | 46.869107 | 2021-07-19 04:21:24 | Madagascar | |||
3706192 | 3706192 | 2021-07-17 | Madagascar | 42520 | 936 | 40891 | 693 | -18.766947 | 46.869107 | 2021-07-18 04:22:07 | Madagascar | |||
2947423 | 2947423 | 2021-07-16 | Madagascar | 42495 | 936 | 40879 | 680 | -18.766947 | 46.869107 | 2021-07-17 04:22:22 | Madagascar | |||
296079 | 296079 | 2021-07-15 | Madagascar | 42479 | 934 | 40862 | 683 | -18.766947 | 46.869107 | 2021-07-16 04:21:22 | Madagascar | |||
3632024 | 3632024 | 2021-07-14 | Madagascar | 42462 | 933 | 40845 | 684 | -18.766947 | 46.869107 | 2021-07-15 04:21:48 | Madagascar | |||
578899 | 578899 | 2021-07-13 | Madagascar | 42462 | 933 | 40845 | 684 | -18.766947 | 46.869107 | 2021-07-14 04:21:35 | Madagascar | |||
3741148 | 3741148 | 2021-07-12 | Madagascar | 42392 | 928 | 40798 | 666 | -18.766947 | 46.869107 | 2021-07-13 04:21:18 | Madagascar | |||
3659661 | 3659661 | 2021-07-11 | Madagascar | 42392 | 928 | 40798 | 666 | -18.766947 | 46.869107 | 2021-07-12 04:21:34 | Madagascar | |||
625945 | 625945 | 2021-07-10 | Madagascar | 42392 | 928 | 40798 | 666 | -18.766947 | 46.869107 | 2021-07-11 04:21:43 | Madagascar | |||
829664 | 829664 | 2021-07-09 | Madagascar | 42392 | 928 | 40798 | 666 | -18.766947 | 46.869107 | 2021-07-10 04:21:25 | Madagascar | |||
778428 | 778428 | 2021-07-08 | Madagascar | 42376 | 927 | 40780 | 669 | -18.766947 | 46.869107 | 2021-07-09 04:21:21 | Madagascar | |||
1440650 | 1440650 | 2021-07-07 | Madagascar | 42358 | 926 | 40767 | 665 | -18.766947 | 46.869107 | 2021-07-08 04:21:26 | Madagascar | |||
2693755 | 2693755 | 2021-07-06 | Madagascar | 42337 | 924 | 40752 | 661 | -18.766947 | 46.869107 | 2021-07-07 04:21:20 | Madagascar | |||
1932504 | 1932504 | 2021-07-05 | Madagascar | 42329 | 924 | 40736 | 669 | -18.766947 | 46.869107 | 2021-07-06 04:21:32 | Madagascar | |||
1165235 | 1165235 | 2021-07-04 | Madagascar | 42311 | 922 | 40722 | 667 | -18.766947 | 46.869107 | 2021-07-05 04:21:28 | Madagascar | |||
1495669 | 1495669 | 2021-07-03 | Madagascar | 42288 | 921 | 40709 | 658 | -18.766947 | 46.869107 | 2021-07-04 04:21:38 | Madagascar | |||
2071984 | 2071984 | 2021-07-02 | Madagascar | 42264 | 918 | 40679 | 667 | -18.766947 | 46.869107 | 2021-07-03 04:21:37 | Madagascar | |||
2765000 | 2765000 | 2021-07-01 | Madagascar | 42247 | 915 | 40651 | 681 | -18.766947 | 46.869107 | 2021-07-02 04:21:47 | Madagascar | |||
1893208 | 1893208 | 2021-06-30 | Madagascar | 42216 | 913 | 40629 | 674 | -18.766947 | 46.869107 | 2021-07-01 04:21:19 | Madagascar | |||
400331 | 400331 | 2021-06-29 | Madagascar | 42207 | 911 | 40610 | 686 | -18.766947 | 46.869107 | 2021-06-30 04:21:41 | Madagascar | |||
3125574 | 3125574 | 2021-06-28 | Madagascar | 42194 | 909 | 40579 | 706 | -18.766947 | 46.869107 | 2021-06-29 04:21:28 | Madagascar | |||
2590069 | 2590069 | 2021-06-27 | Madagascar | 42194 | 906 | 40569 | 719 | -18.766947 | 46.869107 | 2021-06-28 04:21:29 | Madagascar | |||
3958573 | 3958573 | 2021-06-26 | Madagascar | 42194 | 906 | 40569 | 719 | -18.766947 | 46.869107 | 2021-06-27 04:21:39 | Madagascar | |||
1712392 | 1712392 | 2021-06-25 | Madagascar | 42194 | 906 | 40569 | 719 | -18.766947 | 46.869107 | 2021-06-26 04:21:43 | Madagascar | |||
2295517 | 2295517 | 2021-06-24 | Madagascar | 42166 | 905 | 40524 | 737 | -18.766947 | 46.869107 | 2021-06-25 04:21:33 | Madagascar | |||
2422957 | 2422957 | 2021-06-23 | Madagascar | 42161 | 905 | 40500 | 756 | -18.766947 | 46.869107 | 2021-06-24 04:21:55 | Madagascar | |||
563034 | 563034 | 2021-06-22 | Madagascar | 42137 | 903 | 40469 | 765 | -18.766947 | 46.869107 | 2021-06-23 04:21:46 | Madagascar | |||
3358736 | 3358736 | 2021-06-21 | Madagascar | 42137 | 903 | 40469 | 765 | -18.766947 | 46.869107 | 2021-06-22 04:21:34 | Madagascar | |||
2884435 | 2884435 | 2021-06-20 | Madagascar | 42123 | 901 | 40450 | 772 | -18.766947 | 46.869107 | 2021-06-21 04:21:41 | Madagascar | |||
107518 | 107518 | 2021-06-19 | Madagascar | 42087 | 896 | 40425 | 766 | -18.766947 | 46.869107 | 2021-06-20 04:21:48 | Madagascar | |||
1125661 | 1125661 | 2021-06-18 | Madagascar | 42076 | 895 | 40394 | 787 | -18.766947 | 46.869107 | 2021-06-19 04:22:33 | Madagascar | |||
2911239 | 2911239 | 2021-06-17 | Madagascar | 42034 | 892 | 40345 | 797 | -18.766947 | 46.869107 | 2021-06-18 04:22:16 | Madagascar | |||
3030357 | 3030357 | 2021-06-16 | Madagascar | 41998 | 892 | 40318 | 788 | -18.766947 | 46.869107 | 2021-06-17 04:22:36 | Madagascar | |||
2339463 | 2339463 | 2021-06-15 | Madagascar | 41966 | 891 | 40279 | 796 | -18.766947 | 46.869107 | 2021-06-16 04:22:32 | Madagascar | |||
1564159 | 1564159 | 2021-06-14 | Madagascar | 41948 | 889 | 40264 | 795 | -18.766947 | 46.869107 | 2021-06-15 04:22:22 | Madagascar | |||
3381442 | 3381442 | 2021-06-13 | Madagascar | 41933 | 887 | 40239 | 807 | -18.766947 | 46.869107 | 2021-06-14 04:22:46 | Madagascar | |||
1736576 | 1736576 | 2021-06-12 | Madagascar | 41894 | 882 | 40213 | 799 | -18.766947 | 46.869107 | 2021-06-13 04:22:44 | Madagascar | |||
3970617 | 3970617 | 2021-06-11 | Madagascar | 41869 | 879 | 40190 | 800 | -18.766947 | 46.869107 | 2021-06-12 04:22:22 | Madagascar | |||
2717039 | 2717039 | 2021-06-10 | Madagascar | 41840 | 875 | 40158 | 807 | -18.766947 | 46.869107 | 2021-06-11 04:23:20 | Madagascar | |||
522924 | 522924 | 2021-06-09 | Madagascar | 41786 | 874 | 40130 | 782 | -18.766947 | 46.869107 | 2021-06-10 04:23:17 | Madagascar | |||
3472364 | 3472364 | 2021-06-08 | Madagascar | 41758 | 871 | 40095 | 792 | -18.766947 | 46.869107 | 2021-06-09 04:23:31 | Madagascar | |||
3145648 | 3145648 | 2021-06-07 | Madagascar | 41742 | 866 | 40870 | 6 | -18.766947 | 46.869107 | 2021-06-08 04:22:35 | Madagascar |
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]);