johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Meghalaya" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3254105 | 3254105 | 2021-03-02 | India | Meghalaya | 13966 | 148 | 13803 | 15 | 25.536934 | 91.278882 | 2021-03-03 05:23:28 | Meghalaya, India | ||
998397 | 998397 | 2021-03-01 | India | Meghalaya | 13963 | 148 | 13798 | 17 | 25.536934 | 91.278882 | 2021-03-02 05:23:30 | Meghalaya, India | ||
2367455 | 2367455 | 2021-02-28 | India | Meghalaya | 13962 | 148 | 13797 | 17 | 25.536934 | 91.278882 | 2021-03-01 05:23:01 | Meghalaya, India | ||
3065957 | 3065957 | 2021-02-27 | India | Meghalaya | 13961 | 148 | 13796 | 17 | 25.536934 | 91.278882 | 2021-02-28 05:22:20 | Meghalaya, India | ||
2183541 | 2183541 | 2021-02-26 | India | Meghalaya | 13961 | 148 | 13794 | 19 | 25.536934 | 91.278882 | 2021-02-27 05:22:28 | Meghalaya, India | ||
1857963 | 1857963 | 2021-02-25 | India | Meghalaya | 13961 | 148 | 13793 | 20 | 25.536934 | 91.278882 | 2021-02-26 05:22:40 | Meghalaya, India | ||
280141 | 280141 | 2021-02-24 | India | Meghalaya | 13958 | 148 | 13792 | 18 | 25.536934 | 91.278882 | 2021-02-25 05:24:57 | Meghalaya, India | ||
1936409 | 1936409 | 2021-02-23 | India | Meghalaya | 13955 | 148 | 13787 | 20 | 25.536934 | 91.278882 | 2021-02-24 05:29:16 | Meghalaya, India | ||
530664 | 530664 | 2021-02-22 | India | Meghalaya | 13954 | 148 | 13784 | 22 | 25.536934 | 91.278882 | 2021-02-23 05:23:41 | Meghalaya, India | ||
181998 | 181998 | 2021-02-21 | India | Meghalaya | 13952 | 148 | 13782 | 22 | 25.536934 | 91.278882 | 2021-02-22 05:24:21 | Meghalaya, India | ||
742272 | 742272 | 2021-02-20 | India | Meghalaya | 13952 | 148 | 13778 | 26 | 25.536934 | 91.278882 | 2021-02-21 05:24:33 | Meghalaya, India | ||
471370 | 471370 | 2021-02-19 | India | Meghalaya | 13951 | 148 | 13765 | 38 | 25.536934 | 91.278882 | 2021-02-20 05:22:51 | Meghalaya, India | ||
1153079 | 1153079 | 2021-02-18 | India | Meghalaya | 13946 | 148 | 13743 | 55 | 25.536934 | 91.278882 | 2021-02-19 05:24:16 | Meghalaya, India | ||
3600999 | 3600999 | 2021-02-17 | India | Meghalaya | 13945 | 148 | 13719 | 78 | 25.536934 | 91.278882 | 2021-02-18 05:22:58 | Meghalaya, India | ||
3050134 | 3050134 | 2021-02-16 | India | Meghalaya | 13944 | 148 | 13696 | 100 | 25.536934 | 91.278882 | 2021-02-17 05:23:10 | Meghalaya, India | ||
1338233 | 1338233 | 2021-02-15 | India | Meghalaya | 13942 | 148 | 13666 | 128 | 25.536934 | 91.278882 | 2021-02-16 05:24:38 | Meghalaya, India | ||
2283384 | 2283384 | 2021-02-14 | India | Meghalaya | 13942 | 148 | 13645 | 149 | 25.536934 | 91.278882 | 2021-02-15 05:24:49 | Meghalaya, India | ||
2677784 | 2677784 | 2021-02-13 | India | Meghalaya | 13937 | 148 | 13623 | 166 | 25.536934 | 91.278882 | 2021-02-14 05:23:43 | Meghalaya, India | ||
3539417 | 3539417 | 2021-02-12 | India | Meghalaya | 13932 | 148 | 13620 | 164 | 25.536934 | 91.278882 | 2021-02-13 05:22:12 | Meghalaya, India | ||
2637680 | 2637680 | 2021-02-11 | India | Meghalaya | 13931 | 148 | 13617 | 166 | 25.536934 | 91.278882 | 2021-02-12 05:23:29 | Meghalaya, India | ||
3978535 | 3978535 | 2021-02-10 | India | Meghalaya | 13924 | 148 | 13612 | 164 | 25.536934 | 91.278882 | 2021-02-11 05:23:55 | Meghalaya, India | ||
1527855 | 1527855 | 2021-02-09 | India | Meghalaya | 13893 | 148 | 13608 | 137 | 25.536934 | 91.278882 | 2021-02-10 05:22:41 | Meghalaya, India | ||
613646 | 613646 | 2021-02-08 | India | Meghalaya | 13886 | 148 | 13604 | 134 | 25.536934 | 91.278882 | 2021-02-09 05:23:30 | Meghalaya, India | ||
1672415 | 1672415 | 2021-02-07 | India | Meghalaya | 13885 | 147 | 13601 | 137 | 25.536934 | 91.278882 | 2021-02-08 05:22:39 | Meghalaya, India | ||
974876 | 974876 | 2021-02-06 | India | Meghalaya | 13845 | 147 | 13596 | 102 | 25.536934 | 91.278882 | 2021-02-07 05:23:00 | Meghalaya, India | ||
1588134 | 1588134 | 2021-02-05 | India | Meghalaya | 13821 | 147 | 13593 | 81 | 25.536934 | 91.278882 | 2021-02-06 05:23:55 | Meghalaya, India | ||
790341 | 790341 | 2021-02-04 | India | Meghalaya | 13794 | 147 | 13584 | 63 | 25.536934 | 91.278882 | 2021-02-05 05:22:38 | Meghalaya, India | ||
340233 | 340233 | 2021-02-03 | India | Meghalaya | 13774 | 147 | 13575 | 52 | 25.536934 | 91.278882 | 2021-02-04 05:22:26 | Meghalaya, India | ||
1684459 | 1684459 | 2021-02-02 | India | Meghalaya | 13768 | 147 | 13565 | 56 | 25.536934 | 91.278882 | 2021-02-03 05:22:52 | Meghalaya, India | ||
1676429 | 1676429 | 2021-02-01 | India | Meghalaya | 13764 | 146 | 13556 | 62 | 25.536934 | 91.278882 | 2021-02-02 05:22:49 | Meghalaya, India | ||
1459717 | 1459717 | 2021-01-31 | India | Meghalaya | 13764 | 146 | 13550 | 68 | 25.536934 | 91.278882 | 2021-02-01 05:22:53 | Meghalaya, India | ||
2211625 | 2211625 | 2021-01-30 | India | Meghalaya | 13761 | 146 | 13541 | 74 | 25.536934 | 91.278882 | 2021-01-31 05:22:42 | Meghalaya, India | ||
1897112 | 1897112 | 2021-01-29 | India | Meghalaya | 13753 | 146 | 13524 | 83 | 25.536934 | 91.278882 | 2021-01-30 05:22:49 | Meghalaya, India | ||
2481928 | 2481928 | 2021-01-28 | India | Meghalaya | 13749 | 146 | 13513 | 90 | 25.536934 | 91.278882 | 2021-01-29 05:22:23 | Meghalaya, India | ||
3153563 | 3153563 | 2021-01-27 | India | Meghalaya | 13741 | 146 | 13506 | 89 | 25.536934 | 91.278882 | 2021-01-28 05:22:24 | Meghalaya, India | ||
12298 | 12298 | 2021-01-26 | India | Meghalaya | 13740 | 146 | 13496 | 98 | 25.536934 | 91.278882 | 2021-01-27 05:23:41 | Meghalaya, India | ||
2567622 | 2567622 | 2021-01-25 | India | Meghalaya | 13734 | 146 | 13484 | 104 | 25.536934 | 91.278882 | 2021-01-26 05:22:02 | Meghalaya, India | ||
1759254 | 1759254 | 2021-01-24 | India | Meghalaya | 13732 | 146 | 13475 | 111 | 25.536934 | 91.278882 | 2021-01-25 05:22:16 | Meghalaya, India | ||
2426861 | 2426861 | 2021-01-23 | India | Meghalaya | 13727 | 146 | 13459 | 122 | 25.536934 | 91.278882 | 2021-01-24 05:22:35 | Meghalaya, India | ||
2466763 | 2466763 | 2021-01-22 | India | Meghalaya | 13723 | 146 | 13449 | 128 | 25.536934 | 91.278882 | 2021-01-23 05:22:03 | Meghalaya, India | ||
435314 | 435314 | 2021-01-21 | India | Meghalaya | 13721 | 146 | 13440 | 135 | 25.536934 | 91.278882 | 2021-01-22 05:22:10 | Meghalaya, India | ||
1094046 | 1094046 | 2021-01-20 | India | Meghalaya | 13717 | 144 | 13440 | 133 | 25.536934 | 91.278882 | 2021-01-21 05:22:01 | Meghalaya, India | ||
908136 | 908136 | 2021-01-19 | India | Meghalaya | 13710 | 144 | 13433 | 133 | 25.536934 | 91.278882 | 2021-01-20 05:21:54 | Meghalaya, India | ||
237199 | 237199 | 2021-01-18 | India | Meghalaya | 13707 | 144 | 13415 | 148 | 25.536934 | 91.278882 | 2021-01-19 05:22:15 | Meghalaya, India | ||
3503316 | 3503316 | 2021-01-17 | India | Meghalaya | 13704 | 144 | 13412 | 148 | 25.536934 | 91.278882 | 2021-01-18 05:22:34 | Meghalaya, India | ||
3101399 | 3101399 | 2021-01-16 | India | Meghalaya | 13693 | 144 | 13401 | 148 | 25.536934 | 91.278882 | 2021-01-17 05:22:17 | Meghalaya, India | ||
3515361 | 3515361 | 2021-01-15 | India | Meghalaya | 13691 | 144 | 13386 | 161 | 25.536934 | 91.278882 | 2021-01-16 05:22:40 | Meghalaya, India | ||
3879534 | 3879534 | 2021-01-14 | India | Meghalaya | 13687 | 144 | 13382 | 161 | 25.536934 | 91.278882 | 2021-01-15 17:22 | Meghalaya, India | ||
3308161 | 3308161 | 2021-01-13 | India | Meghalaya | 13669 | 144 | 13365 | 160 | 25.536934 | 91.278882 | 2021-01-14 05:22:32 | Meghalaya, India | ||
774306 | 774306 | 2021-01-12 | India | Meghalaya | 13651 | 143 | 13356 | 152 | 25.536934 | 91.278882 | 2021-01-13 05:22:15 | Meghalaya, India | ||
190027 | 190027 | 2021-01-11 | India | Meghalaya | 13631 | 143 | 13337 | 151 | 25.536934 | 91.278882 | 2021-01-12 05:22:15 | Meghalaya, India | ||
2625830 | 2625830 | 2021-01-10 | India | Meghalaya | 13611 | 143 | 13313 | 155 | 25.536934 | 91.278882 | 2021-01-11 05:21:50 | Meghalaya, India | ||
3899918 | 3899918 | 2021-01-09 | India | Meghalaya | 13592 | 143 | 13286 | 163 | 25.536934 | 91.278882 | 2021-01-10 05:22:12 | Meghalaya, India | ||
153941 | 153941 | 2021-01-08 | India | Meghalaya | 13536 | 141 | 13257 | 138 | 25.536934 | 91.278882 | 2021-01-09 05:22:18 | Meghalaya, India | ||
2541365 | 2541365 | 2021-01-07 | India | Meghalaya | 13536 | 141 | 13257 | 138 | 25.536934 | 91.278882 | 2021-01-08 05:22:42 | Meghalaya, India | ||
2864674 | 2864674 | 2021-01-06 | India | Meghalaya | 13525 | 141 | 13230 | 154 | 25.536934 | 91.278882 | 2021-01-07 05:22:03 | Meghalaya, India | ||
3034261 | 3034261 | 2021-01-05 | India | Meghalaya | 13506 | 141 | 13216 | 149 | 25.536934 | 91.278882 | 2021-01-06 05:22:16 | Meghalaya, India | ||
1061806 | 1061806 | 2021-01-04 | India | Meghalaya | 13482 | 139 | 13204 | 139 | 25.536934 | 91.278882 | 2021-01-05 05:21:49 | Meghalaya, India | ||
3230409 | 3230409 | 2021-01-03 | India | Meghalaya | 13460 | 139 | 13186 | 135 | 25.536934 | 91.278882 | 2021-01-04 05:22:02 | Meghalaya, India | ||
2227478 | 2227478 | 2021-01-02 | India | Meghalaya | 13448 | 139 | 13173 | 136 | 25.536934 | 91.278882 | 2021-01-03 05:22:52 | Meghalaya, India | ||
1136842 | 1136842 | 2021-01-01 | India | Meghalaya | 13445 | 139 | 13139 | 167 | 25.536934 | 91.278882 | 2021-01-02 05:22:33 | Meghalaya, India | ||
3695448 | 3695448 | 2020-12-31 | India | Meghalaya | 13408 | 139 | 13085 | 184 | 25.536934 | 91.278882 | 2021-01-01 05:23:07 | Meghalaya, India | ||
1010263 | 1010263 | 2020-12-30 | India | Meghalaya | 13408 | 139 | 13085 | 184 | 25.536934 | 91.278882 | 2020-12-31 05:22:49 | Meghalaya, India | ||
766278 | 766278 | 2020-12-29 | India | Meghalaya | 13387 | 138 | 13066 | 183 | 25.536934 | 91.278882 | 2020-12-30 05:22:34 | Meghalaya, India | ||
3761542 | 3761542 | 2020-12-28 | India | Meghalaya | 13379 | 138 | 13042 | 199 | 25.536934 | 91.278882 | 2020-12-29 05:22:37 | Meghalaya, India | ||
3777862 | 3777862 | 2020-12-27 | India | Meghalaya | 13376 | 138 | 13012 | 226 | 25.536934 | 91.278882 | 2020-12-28 05:22:06 | Meghalaya, India | ||
2223467 | 2223467 | 2020-12-26 | India | Meghalaya | 13371 | 138 | 12985 | 248 | 25.536934 | 91.278882 | 2020-12-27 05:22:55 | Meghalaya, India | ||
202214 | 202214 | 2020-12-25 | India | Meghalaya | 13369 | 135 | 12940 | 294 | 25.536934 | 91.278882 | 2020-12-26 05:22:28 | Meghalaya, India | ||
3691437 | 3691437 | 2020-12-24 | India | Meghalaya | 13340 | 135 | 12922 | 283 | 25.536934 | 91.278882 | 2020-12-25 05:22:48 | Meghalaya, India | ||
2406789 | 2406789 | 2020-12-23 | India | Meghalaya | 13328 | 135 | 12894 | 299 | 25.536934 | 91.278882 | 2020-12-24 05:23:04 | Meghalaya, India | ||
3769835 | 3769835 | 2020-12-22 | India | Meghalaya | 13299 | 134 | 12735 | 430 | 25.536934 | 91.278882 | 2020-12-23 05:22:03 | Meghalaya, India | ||
927651 | 927651 | 2020-12-21 | India | Meghalaya | 13258 | 134 | 12692 | 432 | 25.536934 | 91.278882 | 2020-12-22 05:22:33 | Meghalaya, India | ||
2119672 | 2119672 | 2020-12-20 | India | Meghalaya | 13253 | 134 | 12620 | 499 | 25.536934 | 91.278882 | 2020-12-21 05:27:58 | Meghalaya, India | ||
2931179 | 2931179 | 2020-12-19 | India | Meghalaya | 13221 | 133 | 12531 | 557 | 25.536934 | 91.278882 | 2020-12-20 05:27:32 | Meghalaya, India | ||
1901125 | 1901125 | 2020-12-18 | India | Meghalaya | 13189 | 133 | 12470 | 586 | 25.536934 | 91.278882 | 2020-12-19 05:27:52 | Meghalaya, India | ||
2127951 | 2127951 | 2020-12-17 | India | Meghalaya | 13141 | 133 | 12322 | 686 | 25.536934 | 91.278882 | 2020-12-18 05:28:18 | Meghalaya, India | ||
3149551 | 3149551 | 2020-12-16 | India | Meghalaya | 13072 | 133 | 12252 | 687 | 25.536934 | 91.278882 | 2020-12-17 05:28:12 | Meghalaya, India | ||
1034332 | 1034332 | 2020-12-15 | India | Meghalaya | 13007 | 131 | 12186 | 690 | 25.536934 | 91.278882 | 2020-12-16 05:28:04 | Meghalaya, India | ||
1751226 | 1751226 | 2020-12-14 | India | Meghalaya | 12941 | 130 | 12058 | 753 | 25.536934 | 91.278882 | 2020-12-15 05:26:38 | Meghalaya, India | ||
3847746 | 3847746 | 2020-12-13 | India | Meghalaya | 12866 | 128 | 12008 | 730 | 25.536934 | 91.278882 | 2020-12-14 05:26:27 | Meghalaya, India | ||
845528 | 845528 | 2020-12-12 | India | Meghalaya | 12743 | 125 | 11977 | 641 | 25.536934 | 91.278882 | 2020-12-13 05:27:20 | Meghalaya, India | ||
860635 | 860635 | 2020-12-11 | India | Meghalaya | 12645 | 124 | 11927 | 594 | 25.536934 | 91.278882 | 2020-12-12 05:26:19 | Meghalaya, India | ||
1600177 | 1600177 | 2020-12-10 | India | Meghalaya | 12586 | 123 | 11883 | 580 | 25.536934 | 91.278882 | 2020-12-11 05:26:59 | Meghalaya, India | ||
2975186 | 2975186 | 2020-12-09 | India | Meghalaya | 12511 | 122 | 11855 | 534 | 25.536934 | 91.278882 | 2020-12-10 05:26:19 | Meghalaya, India | ||
1818746 | 1818746 | 2020-12-08 | India | Meghalaya | 12410 | 122 | 11686 | 602 | 25.536934 | 91.278882 | 2020-12-09 05:28:01 | Meghalaya, India | ||
2347382 | 2347382 | 2020-12-07 | India | Meghalaya | 12314 | 120 | 11573 | 621 | 25.536934 | 91.278882 | 2020-12-08 05:27:42 | Meghalaya, India | ||
1006252 | 1006252 | 2020-12-06 | India | Meghalaya | 12237 | 120 | 11453 | 664 | 25.536934 | 91.278882 | 2020-12-07 05:26:14 | Meghalaya, India | ||
1632261 | 1632261 | 2020-12-05 | India | Meghalaya | 12164 | 118 | 11392 | 654 | 25.536934 | 91.278882 | 2020-12-06 05:26:18 | Meghalaya, India | ||
3859789 | 3859789 | 2020-12-04 | India | Meghalaya | 12067 | 118 | 11319 | 630 | 25.536934 | 91.278882 | 2020-12-05 05:27:36 | Meghalaya, India | ||
75047 | 75047 | 2020-12-03 | India | Meghalaya | 12005 | 116 | 11241 | 648 | 25.536934 | 91.278882 | 2020-12-04 05:27:27 | Meghalaya, India | ||
738259 | 738259 | 2020-12-02 | India | Meghalaya | 11954 | 114 | 11154 | 686 | 25.536934 | 91.278882 | 2020-12-03 05:28:22 | Meghalaya, India | ||
2537353 | 2537353 | 2020-12-01 | India | Meghalaya | 11875 | 112 | 11094 | 669 | 25.536934 | 91.278882 | 2020-12-02 05:27:41 | Meghalaya, India | ||
1584122 | 1584122 | 2020-11-30 | India | Meghalaya | 11810 | 111 | 10936 | 763 | 25.536934 | 91.278882 | 2020-12-01 05:26:18 | Meghalaya, India | ||
3566525 | 3566525 | 2020-11-29 | India | Meghalaya | 11740 | 111 | 10861 | 768 | 25.536934 | 91.278882 | 2020-11-30 05:26:13 | Meghalaya, India | ||
2935190 | 2935190 | 2020-11-28 | India | Meghalaya | 11704 | 111 | 10735 | 858 | 25.536934 | 91.278882 | 2020-11-29 05:25:55 | Meghalaya, India | ||
392193 | 392193 | 2020-11-27 | India | Meghalaya | 11633 | 110 | 10606 | 917 | 25.536934 | 91.278882 | 2020-11-28 05:25:50 | Meghalaya, India | ||
923640 | 923640 | 2020-11-26 | India | Meghalaya | 11581 | 110 | 10524 | 947 | 25.536934 | 91.278882 | 2020-11-27 05:26:53 | Meghalaya, India | ||
1972545 | 1972545 | 2020-11-25 | India | Meghalaya | 11513 | 110 | 10488 | 915 | 25.536934 | 91.278882 | 2020-11-26 05:27:44 | Meghalaya, India | ||
1350276 | 1350276 | 2020-11-24 | India | Meghalaya | 11454 | 110 | 10451 | 893 | 25.536934 | 91.278882 | 2020-11-25 05:27:20 | Meghalaya, India | ||
678270 | 678270 | 2020-11-23 | India | Meghalaya | 11397 | 110 | 10392 | 895 | 25.536934 | 91.278882 | 2020-11-24 05:27:31 | Meghalaya, India |
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]);