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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
3189946 | 3189946 | 2020-11-22 | India | Meghalaya | 11339 | 110 | 10335 | 894 | 25.536934 | 91.278882 | 2020-11-23 05:25:26 | Meghalaya, India | ||
3836440 | 3836440 | 2020-11-21 | India | Meghalaya | 11269 | 108 | 10236 | 925 | 25.536934 | 91.278882 | 2020-11-22 05:25:45 | Meghalaya, India | ||
2701468 | 2701468 | 2020-11-20 | India | Meghalaya | 11152 | 106 | 10158 | 888 | 25.536934 | 91.278882 | 2020-11-21 05:25:51 | Meghalaya, India | ||
821528 | 821528 | 2020-11-19 | India | Meghalaya | 10979 | 104 | 10074 | 801 | 25.536934 | 91.278882 | 2020-11-20 05:26:28 | Meghalaya, India | ||
122662 | 122662 | 2020-11-18 | India | Meghalaya | 10870 | 103 | 10014 | 753 | 25.536934 | 91.278882 | 2020-11-19 05:25:23 | Meghalaya, India | ||
3338550 | 3338550 | 2020-11-17 | India | Meghalaya | 10791 | 102 | 9955 | 734 | 25.536934 | 91.278882 | 2020-11-18 05:40:31 | Meghalaya, India | ||
3169595 | 3169595 | 2020-11-16 | India | Meghalaya | 10706 | 101 | 9672 | 933 | 25.536934 | 91.278882 | 2020-11-17 05:25:54 | Meghalaya, India | ||
2880163 | 2880163 | 2020-11-15 | India | Meghalaya | 10665 | 100 | 9594 | 971 | 25.536934 | 91.278882 | 2020-11-16 05:25:57 | Meghalaya, India | ||
2915141 | 2915141 | 2020-11-14 | India | Meghalaya | 10632 | 100 | 9518 | 1014 | 25.536934 | 91.278882 | 2020-11-15 05:26:53 | Meghalaya, India | ||
2784963 | 2784963 | 2020-11-13 | India | Meghalaya | 10581 | 98 | 9455 | 1028 | 25.536934 | 91.278882 | 2020-11-14 05:25:37 | Meghalaya, India | ||
864728 | 864728 | 2020-11-12 | India | Meghalaya | 10511 | 98 | 9368 | 1045 | 25.536934 | 91.278882 | 2020-11-13 05:25:30 | Meghalaya, India | ||
3440773 | 3440773 | 2020-11-11 | India | Meghalaya | 10368 | 94 | 9312 | 962 | 25.536934 | 91.278882 | 2020-11-12 05:25:55 | Meghalaya, India | ||
272113 | 272113 | 2020-11-10 | India | Meghalaya | 10296 | 94 | 9241 | 961 | 25.536934 | 91.278882 | 2020-11-11 05:25:30 | Meghalaya, India | ||
1988590 | 1988590 | 2020-11-09 | India | Meghalaya | 10230 | 94 | 9112 | 1024 | 25.536934 | 91.278882 | 2020-11-10 05:40:07 | Meghalaya, India | ||
1728442 | 1728442 | 2020-11-08 | India | Meghalaya | 10202 | 93 | 9075 | 1034 | 25.536934 | 91.278882 | 2020-11-09 05:25:45 | Meghalaya, India | ||
1543902 | 1543902 | 2020-11-07 | India | Meghalaya | 10047 | 93 | 8959 | 995 | 25.536934 | 91.278882 | 2020-11-08 05:24:56 | Meghalaya, India | ||
376140 | 376140 | 2020-11-06 | India | Meghalaya | 9979 | 91 | 8904 | 984 | 25.536934 | 91.278882 | 2020-11-07 05:24:52 | Meghalaya, India | ||
892078 | 892078 | 2020-11-05 | India | Meghalaya | 9893 | 91 | 8813 | 989 | 25.536934 | 91.278882 | 2020-11-06 05:24:55 | Meghalaya, India | ||
2919140 | 2919140 | 2020-11-04 | India | Meghalaya | 9801 | 90 | 8752 | 959 | 25.536934 | 91.278882 | 2020-11-05 06:05:03 | Meghalaya, India | ||
2497977 | 2497977 | 2020-11-03 | India | Meghalaya | 9741 | 90 | 8680 | 971 | 25.536934 | 91.278882 | 2020-11-04 05:25:09 | Meghalaya, India | ||
3304152 | 3304152 | 2020-11-02 | India | Meghalaya | 9678 | 90 | 8579 | 1009 | 25.536934 | 91.278882 | 2020-11-03 06:00:16 | Meghalaya, India | ||
3409401 | 3409401 | 2020-11-01 | India | Meghalaya | 9607 | 90 | 8462 | 1055 | 25.536934 | 91.278882 | 2020-11-02 05:25:04 | Meghalaya, India | ||
2079890 | 2079890 | 2020-10-31 | India | Meghalaya | 9452 | 88 | 8345 | 1019 | 25.536934 | 91.278882 | 2020-11-01 04:36:19 | Meghalaya, India | ||
2243343 | 2243343 | 2020-10-30 | India | Meghalaya | 9382 | 87 | 8125 | 1170 | 25.536934 | 91.278882 | 2020-10-31 04:24:44 | Meghalaya, India | ||
210198 | 210198 | 2020-10-29 | India | Meghalaya | 9303 | 87 | 7890 | 1326 | 25.536934 | 91.278882 | 2020-10-30 04:24:49 | Meghalaya, India | ||
754260 | 754260 | 2020-10-28 | India | Meghalaya | 9226 | 85 | 7777 | 1364 | 25.536934 | 91.278882 | 2020-10-29 04:24:49 | Meghalaya, India | ||
1452545 | 1452545 | 2020-10-27 | India | Meghalaya | 9136 | 82 | 7643 | 1411 | 25.536934 | 91.278882 | 2020-10-28 04:24:39 | Meghalaya, India | ||
3480269 | 3480269 | 2020-10-26 | India | Meghalaya | 9066 | 81 | 7471 | 1514 | 25.536934 | 91.278882 | 2020-10-27 04:24:45 | Meghalaya, India | ||
8290 | 8290 | 2020-10-25 | India | Meghalaya | 9018 | 81 | 7332 | 1605 | 25.536934 | 91.278882 | 2020-10-26 04:25:02 | Meghalaya, India | ||
3651527 | 3651527 | 2020-10-24 | India | Meghalaya | 8882 | 80 | 7228 | 1574 | 25.536934 | 91.278882 | 2020-10-25 04:24:36 | Meghalaya, India | ||
1053782 | 1053782 | 2020-10-23 | India | Meghalaya | 8801 | 79 | 7091 | 1631 | 25.536934 | 91.278882 | 2020-10-24 04:24:46 | Meghalaya, India | ||
1177452 | 1177452 | 2020-10-22 | India | Meghalaya | 8720 | 78 | 6981 | 1661 | 25.536934 | 91.278882 | 2020-10-23 04:24:46 | Meghalaya, India | ||
2191557 | 2191557 | 2020-10-21 | India | Meghalaya | 8621 | 77 | 6674 | 1870 | 25.536934 | 91.278882 | 2020-10-22 04:24:27 | Meghalaya, India | ||
3990568 | 3990568 | 2020-10-20 | India | Meghalaya | 8593 | 76 | 6497 | 2020 | 25.536934 | 91.278882 | 2020-10-21 04:24:14 | Meghalaya, India | ||
1794588 | 1794588 | 2020-10-19 | India | Meghalaya | 8536 | 75 | 6392 | 2069 | 25.536934 | 91.278882 | 2020-10-20 04:24:22 | Meghalaya, India | ||
762272 | 762272 | 2020-10-18 | India | Meghalaya | 8508 | 75 | 6282 | 2151 | 25.536934 | 91.278882 | 2020-10-19 04:24:16 | Meghalaya, India | ||
1026310 | 1026310 | 2020-10-17 | India | Meghalaya | 8404 | 75 | 6034 | 2295 | 25.536934 | 91.278882 | 2020-10-18 04:24:25 | Meghalaya, India | ||
2856805 | 2856805 | 2020-10-16 | India | Meghalaya | 8303 | 75 | 5735 | 2493 | 25.536934 | 91.278882 | 2020-10-17 04:24:12 | Meghalaya, India | ||
786335 | 786335 | 2020-10-15 | India | Meghalaya | 8164 | 73 | 5646 | 2445 | 25.536934 | 91.278882 | 2020-10-16 04:24:01 | Meghalaya, India | ||
79046 | 79046 | 2020-10-14 | India | Meghalaya | 7991 | 70 | 5582 | 2339 | 25.536934 | 91.278882 | 2020-10-15 04:24:28 | Meghalaya, India | ||
3781861 | 3781861 | 2020-10-13 | India | Meghalaya | 7838 | 65 | 5406 | 2367 | 25.536934 | 91.278882 | 2020-10-14 04:24:05 | Meghalaya, India | ||
2291401 | 2291401 | 2020-10-12 | India | Meghalaya | 7771 | 64 | 5273 | 2434 | 25.536934 | 91.278882 | 2020-10-13 04:24:02 | 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]);