johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where province_or_state = "Assam" sorted by active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, active, longitude, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3264472 | 3264472 | 2020-07-31 | India | Assam | 40269 | 98 | 30357 | 9814 | 26.357149 | 92.830441 | 2020-08-01 04:36:27 | Assam, India | ||
2079871 | 2079871 | 2020-10-31 | India | Assam | 206351 | 930 | 196054 | 9367 | 26.357149 | 92.830441 | 2020-11-01 04:36:19 | Assam, India | ||
1928179 | 1928179 | 2020-07-30 | India | Assam | 38407 | 94 | 29080 | 9233 | 26.357149 | 92.830441 | 2020-07-31 04:35:18 | Assam, India | ||
2020662 | 2020662 | 2021-04-20 | India | Assam | 227473 | 1145 | 217296 | 9032 | 26.357149 | 92.830441 | 2021-04-21 04:21:14 | Assam, India | ||
3409382 | 3409382 | 2020-11-01 | India | Assam | 206517 | 931 | 196784 | 8802 | 26.357149 | 92.830441 | 2020-11-02 05:25:04 | Assam, India | ||
844562 | 844562 | 2020-07-22 | India | Assam | 26772 | 64 | 18033 | 8675 | 26.357149 | 92.830441 | 2020-07-23 05:15:04 | Assam, India | ||
3304133 | 3304133 | 2020-11-02 | India | Assam | 206982 | 932 | 197569 | 8481 | 26.357149 | 92.830441 | 2020-11-03 06:00:16 | Assam, India | ||
2497958 | 2497958 | 2020-11-03 | India | Assam | 207361 | 934 | 198042 | 8385 | 26.357149 | 92.830441 | 2020-11-04 05:25:09 | Assam, India | ||
2958347 | 2958347 | 2020-07-29 | India | Assam | 36295 | 92 | 27832 | 8371 | 26.357149 | 92.830441 | 2020-07-30 04:35:05 | Assam, India | ||
326792 | 326792 | 2020-07-20 | India | Assam | 25382 | 58 | 17095 | 8229 | 26.357149 | 92.83044100000001 | 2020-07-21 04:38:46 | Assam, India | ||
2919121 | 2919121 | 2020-11-04 | India | Assam | 207741 | 934 | 198697 | 8110 | 26.357149 | 92.830441 | 2020-11-05 06:05:03 | Assam, India | ||
442328 | 442328 | 2020-07-26 | India | Assam | 32228 | 79 | 24040 | 8109 | 26.357149 | 92.830441 | 2020-07-27 04:35:02 | Assam, India | ||
177015 | 177015 | 2020-07-27 | India | Assam | 33576 | 86 | 25402 | 8088 | 26.357149 | 92.830441 | 2020-07-28 04:58:43 | Assam, India | ||
3184963 | 3184963 | 2020-07-28 | India | Assam | 33576 | 86 | 25402 | 8088 | 26.357149 | 92.830441 | 2020-07-29 04:35:11 | Assam, India | ||
2563542 | 2563542 | 2020-07-24 | India | Assam | 29921 | 76 | 21761 | 8084 | 26.357149 | 92.830441 | 2020-07-25 04:47:39 | Assam, India | ||
61773 | 61773 | 2020-07-23 | India | Assam | 28791 | 70 | 20699 | 8022 | 26.357149 | 92.830441 | 2020-07-24 05:30:40 | Assam, India | ||
1502572 | 1502572 | 2020-07-25 | India | Assam | 31086 | 77 | 23055 | 7954 | 26.357149 | 92.830441 | 2020-07-26 04:35:00 | Assam, India | ||
121697 | 121697 | 2020-07-19 | India | Assam | 23999 | 57 | 16023 | 7919 | 26.357149 | 92.83044100000001 | 2020-07-20 05:34:40 | Assam, India | ||
3205086 | 3205086 | 2020-07-18 | India | Assam | 22918 | 53 | 15165 | 7700 | 26.357149 | 92.83044100000001 | 2020-07-19 04:34:58 | Assam, India | ||
2410783 | 2410783 | 2021-04-19 | India | Assam | 225822 | 1142 | 217017 | 7663 | 26.357149 | 92.830441 | 2021-04-20 04:20:41 | Assam, India | ||
892059 | 892059 | 2020-11-05 | India | Assam | 208054 | 934 | 199458 | 7662 | 26.357149 | 92.830441 | 2020-11-06 05:24:55 | Assam, India | ||
1707301 | 1707301 | 2020-07-21 | India | Assam | 25382 | 58 | 18033 | 7291 | 26.357149 | 92.83044100000001 | 2020-07-22 04:34:42 | Assam, India | ||
376121 | 376121 | 2020-11-06 | India | Assam | 208389 | 938 | 200384 | 7067 | 26.357149 | 92.830441 | 2020-11-07 05:24:52 | Assam, India | ||
367207 | 367207 | 2020-07-16 | India | Assam | 19754 | 48 | 12888 | 6818 | 26.357149 | 92.830441 | 2020-07-17 04:34:50 | Assam, India | ||
1543883 | 1543883 | 2020-11-07 | India | Assam | 208637 | 940 | 200939 | 6758 | 26.357149 | 92.830441 | 2020-11-08 05:24:56 | Assam, India | ||
3129460 | 3129460 | 2021-04-18 | India | Assam | 224455 | 1135 | 216705 | 6615 | 26.357149 | 92.830441 | 2021-04-19 04:20:57 | Assam, India | ||
1728423 | 1728423 | 2020-11-08 | India | Assam | 208789 | 943 | 201334 | 6512 | 26.357149 | 92.830441 | 2020-11-09 05:25:45 | Assam, India | ||
2708388 | 2708388 | 2020-07-17 | India | Assam | 20646 | 51 | 14105 | 6490 | 26.357149 | 92.83044100000001 | 2020-07-18 04:34:45 | Assam, India | ||
2747875 | 2747875 | 2020-07-15 | India | Assam | 18666 | 46 | 12173 | 6447 | 26.357149 | 92.830441 | 2020-07-16 04:44:59 | Assam, India | ||
2158519 | 2158519 | 2020-07-14 | India | Assam | 17807 | 40 | 11416 | 6351 | 26.357149 | 92.83044100000001 | 2020-07-15 04:34:39 | Assam, India | ||
3435817 | 3435817 | 2020-07-11 | India | Assam | 15536 | 35 | 9150 | 6351 | 26.357149 | 92.83044100000001 | 2020-07-12 04:34:30 | Assam, India | ||
1988571 | 1988571 | 2020-11-09 | India | Assam | 209117 | 947 | 201842 | 6328 | 26.357149 | 92.830441 | 2020-11-10 05:40:07 | Assam, India | ||
982888 | 982888 | 2021-04-17 | India | Assam | 223816 | 1129 | 216546 | 6141 | 26.357149 | 92.830441 | 2021-04-18 04:20:41 | Assam, India | ||
272094 | 272094 | 2020-11-10 | India | Assam | 209388 | 952 | 202471 | 5965 | 26.357149 | 92.830441 | 2020-11-11 05:25:30 | Assam, India | ||
3491160 | 3491160 | 2020-07-13 | India | Assam | 16806 | 36 | 10894 | 5876 | 26.357149 | 92.83044100000001 | 2020-07-14 04:34:46 | Assam, India | ||
50730 | 50730 | 2021-05-29 | India | Assam | 403623 | 3245 | 344083 | 56295 | 26.357149 | 92.830441 | 2021-05-30 04:20:55 | Assam, India | ||
3737422 | 3737422 | 2020-07-12 | India | Assam | 16071 | 35 | 10426 | 5610 | 26.357149 | 92.83044100000001 | 2020-07-13 04:43:04 | Assam, India | ||
726437 | 726437 | 2021-05-22 | India | Assam | 365620 | 2667 | 307548 | 55405 | 26.357149 | 92.830441 | 2021-05-23 04:20:51 | Assam, India | ||
1806684 | 1806684 | 2021-05-27 | India | Assam | 392574 | 3088 | 334418 | 55068 | 26.357149 | 92.830441 | 2021-05-28 04:20:36 | Assam, India | ||
83034 | 83034 | 2021-05-25 | India | Assam | 381171 | 2915 | 323368 | 54888 | 26.357149 | 92.830441 | 2021-05-26 04:20:35 | Assam, India | ||
20309 | 20309 | 2021-05-28 | India | Assam | 398010 | 3168 | 340178 | 54664 | 26.357149 | 92.830441 | 2021-05-29 04:20:41 | Assam, India | ||
3237315 | 3237315 | 2020-07-10 | India | Assam | 14600 | 27 | 9147 | 5426 | 26.357149 | 92.83044100000001 | 2020-07-11 04:34:26 | Assam, India | ||
1310108 | 1310108 | 2021-05-26 | India | Assam | 386870 | 3005 | 329634 | 54231 | 26.357149 | 92.830441 | 2021-05-27 04:20:59 | Assam, India | ||
1952452 | 1952452 | 2021-05-21 | India | Assam | 359640 | 2588 | 302889 | 54163 | 26.357149 | 92.830441 | 2021-05-22 04:20:45 | Assam, India | ||
169983 | 169983 | 2021-04-16 | India | Assam | 222940 | 1127 | 216397 | 5416 | 26.357149 | 92.830441 | 2021-04-17 04:20:40 | Assam, India | ||
1412996 | 1412996 | 2021-05-24 | India | Assam | 375404 | 2823 | 318585 | 53996 | 26.357149 | 92.830441 | 2021-05-25 04:21:08 | Assam, India | ||
3089361 | 3089361 | 2021-05-30 | India | Assam | 406868 | 3300 | 349773 | 53795 | 26.357149 | 92.830441 | 2021-05-31 03:08:59 | Assam, India | ||
3440754 | 3440754 | 2020-11-11 | India | Assam | 209633 | 954 | 203308 | 5371 | 26.357149 | 92.830441 | 2020-11-12 05:25:55 | Assam, India | ||
1913151 | 1913151 | 2021-05-20 | India | Assam | 353574 | 2507 | 297902 | 53165 | 26.357149 | 92.830441 | 2021-05-21 04:20:43 | Assam, India | ||
1771282 | 1771282 | 2021-05-23 | India | Assam | 369183 | 2739 | 313333 | 53111 | 26.357149 | 92.830441 | 2021-05-24 04:20:53 | Assam, India | ||
1188684 | 1188684 | 2021-05-31 | India | Assam | 411216 | 3365 | 354810 | 53041 | 26.357149 | 92.830441 | 2021-06-01 04:23:09 | Assam, India | ||
1005300 | 1005300 | 2020-07-09 | India | Assam | 14032 | 22 | 8726 | 5284 | 26.357149 | 92.83044100000001 | 2020-07-10 04:34:24 | Assam, India | ||
2585927 | 2585927 | 2021-06-05 | India | Assam | 432714 | 3621 | 376343 | 52750 | 26.357149 | 92.830441 | 2021-06-06 04:24:03 | Assam, India | ||
2104068 | 2104068 | 2021-06-01 | India | Assam | 415898 | 3416 | 359802 | 52680 | 26.357149 | 92.830441 | 2021-06-02 04:24:34 | Assam, India | ||
1708250 | 1708250 | 2021-06-02 | India | Assam | 420076 | 3477 | 364191 | 52408 | 26.357149 | 92.830441 | 2021-06-03 04:23:32 | Assam, India | ||
2315241 | 2315241 | 2021-06-04 | India | Assam | 428933 | 3577 | 373244 | 52112 | 26.357149 | 92.830441 | 2021-06-05 04:23:03 | Assam, India | ||
1448526 | 1448526 | 2021-06-03 | India | Assam | 424385 | 3523 | 368981 | 51881 | 26.357149 | 92.830441 | 2021-06-04 04:23:37 | Assam, India | ||
825522 | 825522 | 2021-06-06 | India | Assam | 434942 | 3658 | 380419 | 50865 | 26.357149 | 92.830441 | 2021-06-07 04:22:51 | Assam, India | ||
3472236 | 3472236 | 2021-06-08 | India | Assam | 442694 | 3738 | 388451 | 50505 | 26.357149 | 92.830441 | 2021-06-09 04:23:31 | Assam, India | ||
3145520 | 3145520 | 2021-06-07 | India | Assam | 438746 | 3695 | 385032 | 50019 | 26.357149 | 92.830441 | 2021-06-08 04:22:35 | Assam, India | ||
522796 | 522796 | 2021-06-09 | India | Assam | 446445 | 3793 | 392806 | 49846 | 26.357149 | 92.830441 | 2021-06-10 04:23:17 | Assam, India | ||
2255672 | 2255672 | 2021-05-19 | India | Assam | 347001 | 2433 | 294831 | 49737 | 26.357149 | 92.830441 | 2021-05-20 04:21:05 | Assam, India | ||
2548814 | 2548814 | 2021-04-15 | India | Assam | 222367 | 1123 | 216284 | 4960 | 26.357149 | 92.830441 | 2021-04-16 04:20:46 | Assam, India | ||
2716911 | 2716911 | 2021-06-10 | India | Assam | 450201 | 3844 | 397929 | 48428 | 26.357149 | 92.830441 | 2021-06-11 04:23:20 | Assam, India | ||
864709 | 864709 | 2020-11-12 | India | Assam | 209835 | 957 | 204079 | 4799 | 26.357149 | 92.830441 | 2020-11-13 05:25:30 | Assam, India | ||
2390710 | 2390710 | 2021-05-18 | India | Assam | 340858 | 2344 | 290774 | 47740 | 26.357149 | 92.830441 | 2021-05-19 04:20:42 | Assam, India | ||
3970489 | 3970489 | 2021-06-11 | India | Assam | 453867 | 3873 | 403170 | 46824 | 26.357149 | 92.830441 | 2021-06-12 04:22:22 | Assam, India | ||
3574535 | 3574535 | 2021-05-17 | India | Assam | 335023 | 2271 | 286463 | 46289 | 26.357149 | 92.830441 | 2021-05-18 04:20:33 | Assam, India | ||
2222516 | 2222516 | 2020-07-08 | India | Assam | 13336 | 16 | 8729 | 4591 | 26.357149 | 92.83044100000001 | 2020-07-09 04:34:23 | Assam, India | ||
1841884 | 1841884 | 2021-04-14 | India | Assam | 221868 | 1122 | 216199 | 4547 | 26.357149 | 92.830441 | 2021-04-15 04:20:54 | Assam, India | ||
1872895 | 1872895 | 2021-05-15 | India | Assam | 324979 | 2123 | 277501 | 45355 | 26.357149 | 92.830441 | 2021-05-16 04:20:49 | Assam, India | ||
2939265 | 2939265 | 2021-05-16 | India | Assam | 328629 | 2179 | 281726 | 44724 | 26.357149 | 92.830441 | 2021-05-17 04:20:34 | Assam, India | ||
1736448 | 1736448 | 2021-06-12 | India | Assam | 457330 | 3915 | 408770 | 44645 | 26.357149 | 92.830441 | 2021-06-13 04:22:44 | Assam, India | ||
2784944 | 2784944 | 2020-11-13 | India | Assam | 210068 | 958 | 204721 | 4389 | 26.357149 | 92.830441 | 2020-11-14 05:25:37 | Assam, India | ||
3054130 | 3054130 | 2021-05-13 | India | Assam | 315554 | 1984 | 270079 | 43491 | 26.357149 | 92.830441 | 2021-05-14 04:20:41 | Assam, India | ||
1081864 | 1081864 | 2021-05-14 | India | Assam | 319632 | 2060 | 274247 | 43325 | 26.357149 | 92.830441 | 2021-05-15 04:20:58 | Assam, India | ||
2571618 | 2571618 | 2021-04-13 | India | Assam | 221483 | 1119 | 216093 | 4271 | 26.357149 | 92.830441 | 2021-04-14 04:20:41 | Assam, India | ||
2684685 | 2684685 | 2020-07-06 | India | Assam | 12160 | 14 | 7882 | 4264 | 26.357149 | 92.83044100000001 | 2020-07-07 04:34:00 | Assam, India | ||
415150 | 415150 | 2020-07-05 | India | Assam | 11388 | 14 | 7125 | 4249 | 26.357149 | 92.83044100000001 | 2020-07-06 04:33:57 | Assam, India | ||
2004600 | 2004600 | 2021-05-12 | India | Assam | 310086 | 1909 | 265860 | 42317 | 26.357149 | 92.830441 | 2021-05-13 04:20:51 | Assam, India | ||
887125 | 887125 | 2020-07-07 | India | Assam | 12522 | 14 | 8329 | 4179 | 26.357149 | 92.83044100000001 | 2020-07-08 05:33:48 | Assam, India | ||
3381314 | 3381314 | 2021-06-13 | India | Assam | 459497 | 3951 | 414173 | 41373 | 26.357149 | 92.830441 | 2021-06-14 04:22:46 | Assam, India | ||
2339335 | 2339335 | 2021-06-15 | India | Assam | 466590 | 4028 | 421378 | 41184 | 26.357149 | 92.830441 | 2021-06-16 04:22:32 | Assam, India | ||
1564031 | 1564031 | 2021-06-14 | India | Assam | 463175 | 3994 | 418472 | 40709 | 26.357149 | 92.830441 | 2021-06-15 04:22:22 | Assam, India | ||
3954431 | 3954431 | 2021-05-11 | India | Assam | 304429 | 1838 | 261980 | 40611 | 26.357149 | 92.830441 | 2021-05-12 04:21:29 | Assam, India | ||
529712 | 529712 | 2020-07-04 | India | Assam | 10668 | 14 | 6657 | 3997 | 26.357149 | 92.83044100000001 | 2020-07-05 04:33:46 | Assam, India | ||
3030229 | 3030229 | 2021-06-16 | India | Assam | 469976 | 4064 | 426259 | 39653 | 26.357149 | 92.830441 | 2021-06-17 04:22:36 | Assam, India | ||
2915122 | 2915122 | 2020-11-14 | India | Assam | 210175 | 961 | 205250 | 3964 | 26.357149 | 92.830441 | 2020-11-15 05:26:53 | Assam, India | ||
2820710 | 2820710 | 2021-05-10 | India | Assam | 298171 | 1753 | 257571 | 38847 | 26.357149 | 92.830441 | 2021-05-11 04:20:41 | Assam, India | ||
1551910 | 1551910 | 2021-05-08 | India | Assam | 289069 | 1628 | 249295 | 38146 | 26.357149 | 92.830441 | 2021-05-09 04:20:35 | Assam, India | ||
2911111 | 2911111 | 2021-06-17 | India | Assam | 473453 | 4105 | 431208 | 38140 | 26.357149 | 92.830441 | 2021-06-18 04:22:16 | Assam, India | ||
1425042 | 1425042 | 2021-05-09 | India | Assam | 292368 | 1676 | 253340 | 37352 | 26.357149 | 92.830441 | 2021-05-10 04:20:38 | Assam, India | ||
36369 | 36369 | 2021-04-12 | India | Assam | 220893 | 1118 | 216041 | 3734 | 26.357149 | 92.830441 | 2021-04-13 04:20:37 | Assam, India | ||
1125533 | 1125533 | 2021-06-18 | India | Assam | 477159 | 4138 | 436043 | 36978 | 26.357149 | 92.830441 | 2021-06-19 04:22:33 | Assam, India | ||
2880144 | 2880144 | 2020-11-15 | India | Assam | 210268 | 963 | 205639 | 3666 | 26.357149 | 92.830441 | 2020-11-16 05:25:57 | Assam, India | ||
2347363 | 2347363 | 2020-12-07 | India | Assam | 213925 | 995 | 209345 | 3585 | 26.357149 | 92.830441 | 2020-12-08 05:27:42 | Assam, India | ||
1818727 | 1818727 | 2020-12-08 | India | Assam | 214019 | 997 | 209447 | 3575 | 26.357149 | 92.830441 | 2020-12-09 05:28:01 | Assam, India | ||
1006233 | 1006233 | 2020-12-06 | India | Assam | 213759 | 993 | 209214 | 3552 | 26.357149 | 92.830441 | 2020-12-07 05:26:14 | Assam, India | ||
3859770 | 3859770 | 2020-12-04 | India | Assam | 213505 | 987 | 208967 | 3551 | 26.357149 | 92.830441 | 2020-12-05 05:27:36 | Assam, India | ||
2501968 | 2501968 | 2021-05-07 | India | Assam | 283313 | 1578 | 246242 | 35493 | 26.357149 | 92.830441 | 2021-05-08 04:21:04 | Assam, 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]);