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 = "Assam" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
908117 | 908117 | 2021-01-19 | India | Assam | 216887 | 1075 | 213084 | 2728 | 26.357149 | 92.830441 | 2021-01-20 05:21:54 | Assam, India | ||
237180 | 237180 | 2021-01-18 | India | Assam | 216864 | 1075 | 212978 | 2811 | 26.357149 | 92.830441 | 2021-01-19 05:22:15 | Assam, India | ||
3503297 | 3503297 | 2021-01-17 | India | Assam | 216831 | 1073 | 212839 | 2919 | 26.357149 | 92.830441 | 2021-01-18 05:22:34 | Assam, India | ||
3101380 | 3101380 | 2021-01-16 | India | Assam | 216809 | 1070 | 212809 | 2930 | 26.357149 | 92.830441 | 2021-01-17 05:22:17 | Assam, India | ||
3515342 | 3515342 | 2021-01-15 | India | Assam | 216777 | 1066 | 212748 | 2963 | 26.357149 | 92.830441 | 2021-01-16 05:22:40 | Assam, India | ||
3879515 | 3879515 | 2021-01-14 | India | Assam | 216762 | 1065 | 212706 | 2991 | 26.357149 | 92.830441 | 2021-01-15 17:22 | Assam, India | ||
3308142 | 3308142 | 2021-01-13 | India | Assam | 216743 | 1065 | 212675 | 3003 | 26.357149 | 92.830441 | 2021-01-14 05:22:32 | Assam, India | ||
774287 | 774287 | 2021-01-12 | India | Assam | 216690 | 1064 | 212632 | 2994 | 26.357149 | 92.830441 | 2021-01-13 05:22:15 | Assam, India | ||
190008 | 190008 | 2021-01-11 | India | Assam | 216635 | 1064 | 212579 | 2992 | 26.357149 | 92.830441 | 2021-01-12 05:22:15 | Assam, India | ||
2625811 | 2625811 | 2021-01-10 | India | Assam | 216590 | 1061 | 212515 | 3014 | 26.357149 | 92.830441 | 2021-01-11 05:21:50 | Assam, India | ||
3899899 | 3899899 | 2021-01-09 | India | Assam | 216565 | 1060 | 212486 | 3019 | 26.357149 | 92.830441 | 2021-01-10 05:22:12 | Assam, India | ||
153922 | 153922 | 2021-01-08 | India | Assam | 216481 | 1059 | 212376 | 3046 | 26.357149 | 92.830441 | 2021-01-09 05:22:18 | Assam, India | ||
2541346 | 2541346 | 2021-01-07 | India | Assam | 216481 | 1059 | 212376 | 3046 | 26.357149 | 92.830441 | 2021-01-08 05:22:42 | Assam, India | ||
2864655 | 2864655 | 2021-01-06 | India | Assam | 216424 | 1057 | 212328 | 3039 | 26.357149 | 92.830441 | 2021-01-07 05:22:03 | Assam, India | ||
3034242 | 3034242 | 2021-01-05 | India | Assam | 216381 | 1057 | 212249 | 3075 | 26.357149 | 92.830441 | 2021-01-06 05:22:16 | Assam, India | ||
1061787 | 1061787 | 2021-01-04 | India | Assam | 216340 | 1054 | 212199 | 3087 | 26.357149 | 92.830441 | 2021-01-05 05:21:49 | Assam, India | ||
3230390 | 3230390 | 2021-01-03 | India | Assam | 216304 | 1052 | 212132 | 3120 | 26.357149 | 92.830441 | 2021-01-04 05:22:02 | Assam, India | ||
2227459 | 2227459 | 2021-01-02 | India | Assam | 216289 | 1051 | 212072 | 3166 | 26.357149 | 92.830441 | 2021-01-03 05:22:52 | Assam, India | ||
1136823 | 1136823 | 2021-01-01 | India | Assam | 216251 | 1049 | 211910 | 3292 | 26.357149 | 92.830441 | 2021-01-02 05:22:33 | Assam, India | ||
3695429 | 3695429 | 2020-12-31 | India | Assam | 216139 | 1043 | 211838 | 3258 | 26.357149 | 92.830441 | 2021-01-01 05:23:07 | Assam, India | ||
1010244 | 1010244 | 2020-12-30 | India | Assam | 216139 | 1043 | 211838 | 3258 | 26.357149 | 92.830441 | 2020-12-31 05:22:49 | Assam, India | ||
766259 | 766259 | 2020-12-29 | India | Assam | 216063 | 1040 | 211723 | 3300 | 26.357149 | 92.830441 | 2020-12-30 05:22:34 | Assam, India | ||
3761523 | 3761523 | 2020-12-28 | India | Assam | 215997 | 1038 | 211636 | 3323 | 26.357149 | 92.830441 | 2020-12-29 05:22:37 | Assam, India | ||
3777843 | 3777843 | 2020-12-27 | India | Assam | 215939 | 1037 | 211546 | 3356 | 26.357149 | 92.830441 | 2020-12-28 05:22:06 | Assam, India | ||
2223448 | 2223448 | 2020-12-26 | India | Assam | 215910 | 1035 | 211486 | 3389 | 26.357149 | 92.830441 | 2020-12-27 05:22:55 | Assam, India | ||
202195 | 202195 | 2020-12-25 | India | Assam | 215836 | 1033 | 211381 | 3422 | 26.357149 | 92.830441 | 2020-12-26 05:22:28 | Assam, India | ||
3691418 | 3691418 | 2020-12-24 | India | Assam | 215775 | 1033 | 211286 | 3456 | 26.357149 | 92.830441 | 2020-12-25 05:22:48 | Assam, India | ||
2406770 | 2406770 | 2020-12-23 | India | Assam | 215680 | 1029 | 211181 | 3470 | 26.357149 | 92.830441 | 2020-12-24 05:23:04 | Assam, India | ||
3769816 | 3769816 | 2020-12-22 | India | Assam | 215585 | 1024 | 211078 | 3483 | 26.357149 | 92.830441 | 2020-12-23 05:22:03 | Assam, India | ||
927632 | 927632 | 2020-12-21 | India | Assam | 215510 | 1020 | 210965 | 3525 | 26.357149 | 92.830441 | 2020-12-22 05:22:33 | Assam, India | ||
2119653 | 2119653 | 2020-12-20 | India | Assam | 215409 | 1017 | 210872 | 3520 | 26.357149 | 92.830441 | 2020-12-21 05:27:58 | Assam, India | ||
2931160 | 2931160 | 2020-12-19 | India | Assam | 215346 | 1012 | 210808 | 3526 | 26.357149 | 92.830441 | 2020-12-20 05:27:32 | Assam, India | ||
1901106 | 1901106 | 2020-12-18 | India | Assam | 215250 | 1011 | 210700 | 3539 | 26.357149 | 92.830441 | 2020-12-19 05:27:52 | Assam, India | ||
2127932 | 2127932 | 2020-12-17 | India | Assam | 215148 | 1010 | 210615 | 3523 | 26.357149 | 92.830441 | 2020-12-18 05:28:18 | Assam, India | ||
3149532 | 3149532 | 2020-12-16 | India | Assam | 215042 | 1007 | 210491 | 3544 | 26.357149 | 92.830441 | 2020-12-17 05:28:12 | Assam, India | ||
1034313 | 1034313 | 2020-12-15 | India | Assam | 214945 | 1004 | 210401 | 3540 | 26.357149 | 92.830441 | 2020-12-16 05:28:04 | Assam, India | ||
1751207 | 1751207 | 2020-12-14 | India | Assam | 214803 | 1003 | 210299 | 3501 | 26.357149 | 92.830441 | 2020-12-15 05:26:38 | Assam, India | ||
3847727 | 3847727 | 2020-12-13 | India | Assam | 214657 | 1002 | 210174 | 3481 | 26.357149 | 92.830441 | 2020-12-14 05:26:27 | Assam, India | ||
845509 | 845509 | 2020-12-12 | India | Assam | 214584 | 1000 | 210057 | 3527 | 26.357149 | 92.830441 | 2020-12-13 05:27:20 | Assam, India | ||
860616 | 860616 | 2020-12-11 | India | Assam | 214432 | 1000 | 209939 | 3493 | 26.357149 | 92.830441 | 2020-12-12 05:26:19 | Assam, India | ||
1600158 | 1600158 | 2020-12-10 | India | Assam | 214305 | 999 | 209790 | 3516 | 26.357149 | 92.830441 | 2020-12-11 05:26:59 | Assam, India | ||
2975167 | 2975167 | 2020-12-09 | India | Assam | 214165 | 998 | 209625 | 3542 | 26.357149 | 92.830441 | 2020-12-10 05:26:19 | 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 | ||
2347363 | 2347363 | 2020-12-07 | India | Assam | 213925 | 995 | 209345 | 3585 | 26.357149 | 92.830441 | 2020-12-08 05:27:42 | 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 | ||
1632242 | 1632242 | 2020-12-05 | India | Assam | 213662 | 989 | 209130 | 3543 | 26.357149 | 92.830441 | 2020-12-06 05:26:18 | 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 | ||
75028 | 75028 | 2020-12-03 | India | Assam | 213336 | 985 | 208846 | 3505 | 26.357149 | 92.830441 | 2020-12-04 05:27:27 | Assam, India | ||
738240 | 738240 | 2020-12-02 | India | Assam | 213171 | 983 | 208669 | 3519 | 26.357149 | 92.830441 | 2020-12-03 05:28:22 | Assam, India | ||
2537334 | 2537334 | 2020-12-01 | India | Assam | 212998 | 981 | 208531 | 3486 | 26.357149 | 92.830441 | 2020-12-02 05:27:41 | Assam, India | ||
1584103 | 1584103 | 2020-11-30 | India | Assam | 212776 | 981 | 208396 | 3399 | 26.357149 | 92.830441 | 2020-12-01 05:26:18 | Assam, India | ||
3566506 | 3566506 | 2020-11-29 | India | Assam | 212617 | 981 | 208286 | 3350 | 26.357149 | 92.830441 | 2020-11-30 05:26:13 | Assam, India | ||
2935171 | 2935171 | 2020-11-28 | India | Assam | 212483 | 980 | 208190 | 3313 | 26.357149 | 92.830441 | 2020-11-29 05:25:55 | Assam, India | ||
392174 | 392174 | 2020-11-27 | India | Assam | 212320 | 980 | 208068 | 3272 | 26.357149 | 92.830441 | 2020-11-28 05:25:50 | Assam, India | ||
923621 | 923621 | 2020-11-26 | India | Assam | 212171 | 978 | 207908 | 3285 | 26.357149 | 92.830441 | 2020-11-27 05:26:53 | Assam, India | ||
1972526 | 1972526 | 2020-11-25 | India | Assam | 212021 | 978 | 207766 | 3277 | 26.357149 | 92.830441 | 2020-11-26 05:27:44 | Assam, India | ||
1350257 | 1350257 | 2020-11-24 | India | Assam | 211839 | 976 | 207649 | 3214 | 26.357149 | 92.830441 | 2020-11-25 05:27:20 | Assam, India | ||
678251 | 678251 | 2020-11-23 | India | Assam | 211682 | 975 | 207528 | 3179 | 26.357149 | 92.830441 | 2020-11-24 05:27:31 | Assam, India | ||
3189927 | 3189927 | 2020-11-22 | India | Assam | 211513 | 974 | 207397 | 3142 | 26.357149 | 92.830441 | 2020-11-23 05:25:26 | Assam, India | ||
3836421 | 3836421 | 2020-11-21 | India | Assam | 211427 | 973 | 207222 | 3232 | 26.357149 | 92.830441 | 2020-11-22 05:25:45 | Assam, India | ||
2701449 | 2701449 | 2020-11-20 | India | Assam | 211204 | 971 | 207029 | 3204 | 26.357149 | 92.830441 | 2020-11-21 05:25:51 | Assam, India | ||
821509 | 821509 | 2020-11-19 | India | Assam | 211040 | 969 | 206878 | 3193 | 26.357149 | 92.830441 | 2020-11-20 05:26:28 | Assam, India | ||
122643 | 122643 | 2020-11-18 | India | Assam | 210865 | 969 | 206611 | 3285 | 26.357149 | 92.830441 | 2020-11-19 05:25:23 | Assam, India | ||
3338531 | 3338531 | 2020-11-17 | India | Assam | 210696 | 966 | 206401 | 3329 | 26.357149 | 92.830441 | 2020-11-18 05:40:31 | Assam, India | ||
3169576 | 3169576 | 2020-11-16 | India | Assam | 210454 | 964 | 206044 | 3446 | 26.357149 | 92.830441 | 2020-11-17 05:25:54 | 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 | ||
2915122 | 2915122 | 2020-11-14 | India | Assam | 210175 | 961 | 205250 | 3964 | 26.357149 | 92.830441 | 2020-11-15 05:26:53 | 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 | ||
864709 | 864709 | 2020-11-12 | India | Assam | 209835 | 957 | 204079 | 4799 | 26.357149 | 92.830441 | 2020-11-13 05:25:30 | 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 | ||
272094 | 272094 | 2020-11-10 | India | Assam | 209388 | 952 | 202471 | 5965 | 26.357149 | 92.830441 | 2020-11-11 05:25: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 | ||
1728423 | 1728423 | 2020-11-08 | India | Assam | 208789 | 943 | 201334 | 6512 | 26.357149 | 92.830441 | 2020-11-09 05:25:45 | 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 | ||
376121 | 376121 | 2020-11-06 | India | Assam | 208389 | 938 | 200384 | 7067 | 26.357149 | 92.830441 | 2020-11-07 05:24:52 | 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 | ||
2919121 | 2919121 | 2020-11-04 | India | Assam | 207741 | 934 | 198697 | 8110 | 26.357149 | 92.830441 | 2020-11-05 06:05:03 | 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 | ||
3304133 | 3304133 | 2020-11-02 | India | Assam | 206982 | 932 | 197569 | 8481 | 26.357149 | 92.830441 | 2020-11-03 06:00:16 | 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 | ||
2079871 | 2079871 | 2020-10-31 | India | Assam | 206351 | 930 | 196054 | 9367 | 26.357149 | 92.830441 | 2020-11-01 04:36:19 | Assam, India | ||
2243324 | 2243324 | 2020-10-30 | India | Assam | 206015 | 926 | 194668 | 10421 | 26.357149 | 92.830441 | 2020-10-31 04:24:44 | Assam, India | ||
210179 | 210179 | 2020-10-29 | India | Assam | 205635 | 923 | 193574 | 11138 | 26.357149 | 92.830441 | 2020-10-30 04:24:49 | Assam, India | ||
754241 | 754241 | 2020-10-28 | India | Assam | 205237 | 917 | 192517 | 11803 | 26.357149 | 92.830441 | 2020-10-29 04:24:49 | Assam, India | ||
1452526 | 1452526 | 2020-10-27 | India | Assam | 204789 | 914 | 191030 | 12845 | 26.357149 | 92.830441 | 2020-10-28 04:24:39 | Assam, India | ||
3480250 | 3480250 | 2020-10-26 | India | Assam | 204386 | 908 | 188587 | 14891 | 26.357149 | 92.830441 | 2020-10-27 04:24:45 | Assam, India | ||
8271 | 8271 | 2020-10-25 | India | Assam | 204171 | 906 | 185755 | 17510 | 26.357149 | 92.830441 | 2020-10-26 04:25:02 | Assam, India | ||
3651508 | 3651508 | 2020-10-24 | India | Assam | 203967 | 902 | 182794 | 20271 | 26.357149 | 92.830441 | 2020-10-25 04:24:36 | Assam, India | ||
1053763 | 1053763 | 2020-10-23 | India | Assam | 203709 | 900 | 179846 | 22963 | 26.357149 | 92.830441 | 2020-10-24 04:24:46 | Assam, India | ||
1177433 | 1177433 | 2020-10-22 | India | Assam | 203282 | 896 | 177662 | 24724 | 26.357149 | 92.830441 | 2020-10-23 04:24:46 | Assam, India | ||
2191538 | 2191538 | 2020-10-21 | India | Assam | 202774 | 889 | 176078 | 25807 | 26.357149 | 92.830441 | 2020-10-22 04:24:27 | Assam, India | ||
3990549 | 3990549 | 2020-10-20 | India | Assam | 202073 | 884 | 174414 | 26775 | 26.357149 | 92.830441 | 2020-10-21 04:24:14 | Assam, India | ||
1794569 | 1794569 | 2020-10-19 | India | Assam | 201407 | 875 | 173213 | 27319 | 26.357149 | 92.830441 | 2020-10-20 04:24:22 | Assam, India | ||
762253 | 762253 | 2020-10-18 | India | Assam | 200709 | 868 | 171683 | 28158 | 26.357149 | 92.830441 | 2020-10-19 04:24:16 | Assam, India | ||
1026291 | 1026291 | 2020-10-17 | India | Assam | 200391 | 865 | 171084 | 28442 | 26.357149 | 92.830441 | 2020-10-18 04:24:25 | Assam, India | ||
2856786 | 2856786 | 2020-10-16 | India | Assam | 199749 | 853 | 170265 | 28631 | 26.357149 | 92.830441 | 2020-10-17 04:24:12 | Assam, India | ||
786316 | 786316 | 2020-10-15 | India | Assam | 198982 | 843 | 169335 | 28804 | 26.357149 | 92.830441 | 2020-10-16 04:24:01 | Assam, India | ||
79027 | 79027 | 2020-10-14 | India | Assam | 198213 | 834 | 168072 | 29307 | 26.357149 | 92.830441 | 2020-10-15 04:24:28 | Assam, India | ||
3781842 | 3781842 | 2020-10-13 | India | Assam | 196786 | 830 | 167059 | 28897 | 26.357149 | 92.830441 | 2020-10-14 04:24:05 | Assam, India | ||
2291382 | 2291382 | 2020-10-12 | India | Assam | 195304 | 826 | 166039 | 28439 | 26.357149 | 92.830441 | 2020-10-13 04:24:02 | 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]);