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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
3785854 | 3785854 | 2020-10-11 | India | Meghalaya | 7683 | 63 | 5142 | 2478 | 25.536934 | 91.278882 | 2020-10-12 04:23:45 | Meghalaya, India | ||
2601992 | 2601992 | 2020-10-10 | India | Meghalaya | 7544 | 62 | 5045 | 2437 | 25.536934 | 91.278882 | 2020-10-11 04:23:46 | Meghalaya, India | ||
817525 | 817525 | 2020-10-09 | India | Meghalaya | 7388 | 61 | 4903 | 2424 | 25.536934 | 91.278882 | 2020-10-10 04:23:57 | Meghalaya, India | ||
2689640 | 2689640 | 2020-10-08 | India | Meghalaya | 7261 | 60 | 4832 | 2369 | 25.536934 | 91.278882 | 2020-10-09 04:23:59 | Meghalaya, India | ||
1041782 | 1041782 | 2020-10-07 | India | Meghalaya | 7165 | 60 | 4694 | 2411 | 25.536934 | 91.278882 | 2020-10-08 04:23:56 | Meghalaya, India | ||
3117443 | 3117443 | 2020-10-06 | India | Meghalaya | 7037 | 60 | 4606 | 2371 | 25.536934 | 91.278882 | 2020-10-07 04:23:40 | Meghalaya, India | ||
3801855 | 3801855 | 2020-10-05 | India | Meghalaya | 6767 | 59 | 4491 | 2217 | 25.536934 | 91.278882 | 2020-10-06 04:23:33 | Meghalaya, India | ||
1822745 | 1822745 | 2020-10-04 | India | Meghalaya | 6656 | 54 | 4393 | 2209 | 25.536934 | 91.278882 | 2020-10-05 04:23:33 | Meghalaya, India | ||
2514129 | 2514129 | 2020-10-03 | India | Meghalaya | 6456 | 54 | 4319 | 2083 | 25.536934 | 91.278882 | 2020-10-04 04:23:44 | Meghalaya, India | ||
3389347 | 3389347 | 2020-10-02 | India | Meghalaya | 6033 | 52 | 4226 | 1755 | 25.536934 | 91.278882 | 2020-10-03 04:23:40 | Meghalaya, India | ||
2379588 | 2379588 | 2020-10-01 | India | Meghalaya | 5802 | 51 | 4001 | 1750 | 25.536934 | 91.278882 | 2020-10-02 04:23:51 | Meghalaya, India | ||
1045774 | 1045774 | 2020-09-30 | India | Meghalaya | 5639 | 49 | 3975 | 1615 | 25.536934 | 91.278882 | 2020-10-01 04:23:42 | Meghalaya, India | ||
966855 | 966855 | 2020-09-29 | India | Meghalaya | 5463 | 47 | 3940 | 1476 | 25.536934 | 91.278882 | 2020-09-30 04:23:33 | Meghalaya, India | ||
1515352 | 1515352 | 2020-09-28 | India | Meghalaya | 5362 | 46 | 3868 | 1448 | 25.536934 | 91.278882 | 2020-09-29 04:23:42 | Meghalaya, India | ||
2581940 | 2581940 | 2020-09-27 | India | Meghalaya | 5302 | 43 | 3779 | 1480 | 25.536934 | 91.278882 | 2020-09-28 04:23:00 | Meghalaya, India | ||
2613992 | 2613992 | 2020-09-26 | India | Meghalaya | 5212 | 43 | 3654 | 1515 | 25.536934 | 91.278882 | 2020-09-27 04:23:00 | Meghalaya, India | ||
2812707 | 2812707 | 2020-09-25 | India | Meghalaya | 5158 | 43 | 3343 | 1772 | 25.536934 | 91.278882 | 2020-09-26 04:23:00 | Meghalaya, India | ||
2605984 | 2605984 | 2020-09-24 | India | Meghalaya | 5078 | 43 | 3058 | 1977 | 25.536934 | 91.278882 | 2020-09-25 04:23:00 | Meghalaya, India | ||
2653727 | 2653727 | 2020-09-23 | India | Meghalaya | 4961 | 42 | 2859 | 2060 | 25.536934 | 91.278882 | 2020-09-24 04:23:00 | Meghalaya, India | ||
3316176 | 3316176 | 2020-09-22 | India | Meghalaya | 4791 | 38 | 2706 | 2047 | 25.536934 | 91.278882 | 2020-09-23 04:23:00 | Meghalaya, India | ||
2836775 | 2836775 | 2020-09-21 | India | Meghalaya | 4733 | 37 | 2527 | 2169 | 25.536934 | 91.278882 | 2020-09-22 04:23:00 | Meghalaya, India | ||
3093379 | 3093379 | 2020-09-20 | India | Meghalaya | 4660 | 36 | 2513 | 2111 | 25.536934 | 91.278882 | 2020-09-21 04:23:00 | Meghalaya, India | ||
2454729 | 2454729 | 2020-09-19 | India | Meghalaya | 4557 | 36 | 2483 | 2038 | 25.536934 | 91.278882 | 2020-09-20 04:22:00 | Meghalaya, India | ||
2848798 | 2848798 | 2020-09-18 | India | Meghalaya | 4445 | 32 | 2437 | 1976 | 25.536934 | 91.278882 | 2020-09-19 04:22:00 | Meghalaya, India | ||
1121547 | 1121547 | 2020-09-17 | India | Meghalaya | 4356 | 31 | 2342 | 1983 | 25.536934 | 91.278882 | 2020-09-18 05:05:00 | Meghalaya, India | ||
666236 | 666236 | 2020-09-16 | India | Meghalaya | 4195 | 29 | 2264 | 1902 | 25.536934 | 91.278882 | 2020-09-17 04:22:00 | Meghalaya, India | ||
2728961 | 2728961 | 2020-09-15 | India | Meghalaya | 4036 | 28 | 2190 | 1818 | 25.536934 | 91.278882 | 2020-09-16 04:22:53 | Meghalaya, India | ||
344233 | 344233 | 2020-09-14 | India | Meghalaya | 3724 | 26 | 2075 | 1623 | 25.536934 | 91.278882 | 2020-09-15 03:22:50 | Meghalaya, India | ||
2868672 | 2868672 | 2020-09-13 | India | Meghalaya | 3724 | 26 | 2075 | 1623 | 25.536934 | 91.278882 | 2020-09-14 04:26:00 | Meghalaya, India | ||
546711 | 546711 | 2020-09-12 | India | Meghalaya | 3615 | 25 | 2020 | 1570 | 25.536934 | 91.278882 | 2020-09-13 04:30:52 | Meghalaya, India | ||
1444540 | 1444540 | 2020-09-11 | India | Meghalaya | 3447 | 24 | 1889 | 1534 | 25.536934 | 91.278882 | 2020-09-12 04:25:05 | Meghalaya, India | ||
1173141 | 1173141 | 2020-09-10 | India | Meghalaya | 3296 | 20 | 1842 | 1434 | 25.536934 | 91.278882 | 2020-09-11 04:46:23 | Meghalaya, India | ||
2171506 | 2171506 | 2020-09-09 | India | Meghalaya | 3197 | 19 | 1823 | 1355 | 25.536934 | 91.278882 | 2020-09-10 04:29:01 | Meghalaya, India | ||
1243715 | 1243715 | 2020-09-08 | India | Meghalaya | 3076 | 17 | 1716 | 1343 | 25.536934 | 91.278882 | 2020-09-09 04:28:48 | Meghalaya, India | ||
427294 | 427294 | 2020-09-07 | India | Meghalaya | 3034 | 17 | 1560 | 1457 | 25.536934 | 91.278882 | 2020-09-08 04:28:25 | Meghalaya, India | ||
3161579 | 3161579 | 2020-09-06 | India | Meghalaya | 3005 | 16 | 1556 | 1433 | 25.536934 | 91.278882 | 2020-09-07 04:28:30 | Meghalaya, India | ||
813534 | 813534 | 2020-09-05 | India | Meghalaya | 2916 | 15 | 1527 | 1374 | 25.536934 | 91.278882 | 2020-09-06 04:28:33 | Meghalaya, India | ||
2661734 | 2661734 | 2020-09-04 | India | Meghalaya | 2734 | 14 | 1468 | 1252 | 25.536934 | 91.278882 | 2020-09-05 04:28:19 | Meghalaya, India | ||
1354274 | 1354274 | 2020-09-03 | India | Meghalaya | 2626 | 13 | 1393 | 1220 | 25.536934 | 91.278882 | 2020-09-04 04:28:26 | Meghalaya, India | ||
1105511 | 1105511 | 2020-09-02 | India | Meghalaya | 2517 | 13 | 1318 | 1186 | 25.536934 | 91.278882 | 2020-09-03 04:28:22 | Meghalaya, India | ||
2059840 | 2059840 | 2020-09-01 | India | Meghalaya | 2440 | 12 | 1235 | 1193 | 25.536934 | 91.278882 | 2020-09-02 04:28:25 | Meghalaya, India | ||
194025 | 194025 | 2020-08-31 | India | Meghalaya | 2368 | 10 | 1162 | 1196 | 25.536934 | 91.278882 | 2020-09-01 04:28:31 | Meghalaya, India | ||
3931984 | 3931984 | 2020-08-30 | India | Meghalaya | 2343 | 10 | 1049 | 1284 | 25.536934 | 91.278882 | 2020-08-31 04:28:27 | Meghalaya, India | ||
609646 | 609646 | 2020-08-29 | India | Meghalaya | 2283 | 10 | 1035 | 1238 | 25.536934 | 91.278882 | 2020-08-30 04:28:22 | Meghalaya, India | ||
1523141 | 1523141 | 2020-08-28 | India | Meghalaya | 2240 | 10 | 958 | 1272 | 25.536934 | 91.278882 | 2020-08-29 04:28:19 | Meghalaya, India | ||
2510142 | 2510142 | 2020-08-27 | India | Meghalaya | 2129 | 8 | 899 | 1222 | 25.536934 | 91.278882 | 2020-08-28 04:28:11 | Meghalaya, India | ||
1996602 | 1996602 | 2020-08-26 | India | Meghalaya | 2050 | 8 | 874 | 1168 | 25.536934 | 91.278882 | 2020-08-27 04:28:15 | Meghalaya, India | ||
3562526 | 3562526 | 2020-08-25 | India | Meghalaya | 2018 | 8 | 832 | 1178 | 25.536934 | 91.278882 | 2020-08-26 04:28:11 | Meghalaya, India | ||
2991230 | 2991230 | 2020-08-24 | India | Meghalaya | 1976 | 8 | 789 | 1179 | 25.536934 | 91.278882 | 2020-08-25 04:28:02 | Meghalaya, India | ||
2215625 | 2215625 | 2020-08-23 | India | Meghalaya | 1917 | 8 | 776 | 1133 | 25.536934 | 91.278882 | 2020-08-24 04:27:56 | Meghalaya, India | ||
2299407 | 2299407 | 2020-08-22 | India | Meghalaya | 1811 | 7 | 769 | 1035 | 25.536934 | 91.278882 | 2020-08-23 04:27:48 | Meghalaya, India | ||
1479514 | 1479514 | 2020-08-21 | India | Meghalaya | 1718 | 6 | 749 | 963 | 25.536934 | 91.278882 | 2020-08-22 04:27:49 | Meghalaya, India | ||
3484263 | 3484263 | 2020-08-20 | India | Meghalaya | 1661 | 6 | 730 | 925 | 25.536934 | 91.278882 | 2020-08-21 04:27:41 | Meghalaya, India | ||
206212 | 206212 | 2020-08-19 | India | Meghalaya | 1506 | 6 | 694 | 806 | 25.536934 | 91.278882 | 2020-08-20 04:27:43 | Meghalaya, India | ||
3177966 | 3177966 | 2020-08-18 | India | Meghalaya | 1457 | 6 | 685 | 766 | 25.536934 | 91.278882 | 2020-08-19 04:27:00 | Meghalaya, India | ||
837570 | 837570 | 2020-08-17 | India | Meghalaya | 1418 | 6 | 679 | 733 | 25.536934 | 91.278882 | 2020-08-18 04:27:56 | Meghalaya, India | ||
1555928 | 1555928 | 2020-08-16 | India | Meghalaya | 1374 | 6 | 675 | 693 | 25.536934 | 91.278882 | 2020-08-17 04:27:20 | Meghalaya, India | ||
145930 | 145930 | 2020-08-15 | India | Meghalaya | 1292 | 6 | 596 | 690 | 25.536934 | 91.278882 | 2020-08-16 04:27:42 | Meghalaya, India | ||
1612205 | 1612205 | 2020-08-14 | India | Meghalaya | 1228 | 6 | 581 | 641 | 25.536934 | 91.278882 | 2020-08-15 04:27:31 | Meghalaya, India | ||
582789 | 582789 | 2020-08-13 | India | Meghalaya | 1193 | 6 | 547 | 640 | 25.536934 | 91.278882 | 2020-08-14 04:51:19 | Meghalaya, India | ||
3531408 | 3531408 | 2020-08-12 | India | Meghalaya | 1179 | 6 | 517 | 656 | 25.536934 | 91.278882 | 2020-08-13 04:29:15 | Meghalaya, India | ||
662257 | 662257 | 2020-08-11 | India | Meghalaya | 1136 | 6 | 509 | 621 | 25.536934 | 91.278882 | 2020-08-12 04:27:29 | Meghalaya, India | ||
1920434 | 1920434 | 2020-08-10 | India | Meghalaya | 1114 | 6 | 498 | 610 | 25.536934 | 91.278882 | 2020-08-11 04:35:08 | Meghalaya, India | ||
3923243 | 3923243 | 2020-08-09 | India | Meghalaya | 1062 | 6 | 490 | 566 | 25.536934 | 91.278882 | 2020-08-10 04:34:55 | Meghalaya, India | ||
371411 | 371411 | 2020-08-08 | India | Meghalaya | 1023 | 6 | 423 | 594 | 25.536934 | 91.278882 | 2020-08-09 04:34:54 | Meghalaya, India | ||
458595 | 458595 | 2020-08-07 | India | Meghalaya | 1006 | 5 | 411 | 590 | 25.536934 | 91.278882 | 2020-08-08 04:34:53 | Meghalaya, India | ||
3612280 | 3612280 | 2020-08-06 | India | Meghalaya | 990 | 5 | 345 | 640 | 25.536934 | 91.278882 | 2020-08-07 04:35:11 | 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]);