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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3254086 | 3254086 | 2021-03-02 | India | Assam | 217585 | 1093 | 214860 | 1632 | 26.357149 | 92.830441 | 2021-03-03 05:23:28 | Assam, India | ||
998378 | 998378 | 2021-03-01 | India | Assam | 217570 | 1093 | 214846 | 1631 | 26.357149 | 92.830441 | 2021-03-02 05:23:30 | Assam, India | ||
2367436 | 2367436 | 2021-02-28 | India | Assam | 217537 | 1092 | 214830 | 1615 | 26.357149 | 92.830441 | 2021-03-01 05:23:01 | Assam, India | ||
3065938 | 3065938 | 2021-02-27 | India | Assam | 217527 | 1092 | 214815 | 1620 | 26.357149 | 92.830441 | 2021-02-28 05:22:20 | Assam, India | ||
2183522 | 2183522 | 2021-02-26 | India | Assam | 217518 | 1092 | 214792 | 1634 | 26.357149 | 92.830441 | 2021-02-27 05:22:28 | Assam, India | ||
1857944 | 1857944 | 2021-02-25 | India | Assam | 217484 | 1091 | 214770 | 1623 | 26.357149 | 92.830441 | 2021-02-26 05:22:40 | Assam, India | ||
280122 | 280122 | 2021-02-24 | India | Assam | 217454 | 1091 | 214757 | 1606 | 26.357149 | 92.830441 | 2021-02-25 05:24:57 | Assam, India | ||
1936390 | 1936390 | 2021-02-23 | India | Assam | 217427 | 1091 | 214732 | 1604 | 26.357149 | 92.830441 | 2021-02-24 05:29:16 | Assam, India | ||
530645 | 530645 | 2021-02-22 | India | Assam | 217406 | 1091 | 214712 | 1603 | 26.357149 | 92.830441 | 2021-02-23 05:23:41 | Assam, India | ||
181979 | 181979 | 2021-02-21 | India | Assam | 217392 | 1091 | 214694 | 1607 | 26.357149 | 92.830441 | 2021-02-22 05:24:21 | Assam, India | ||
742253 | 742253 | 2021-02-20 | India | Assam | 217383 | 1091 | 214676 | 1616 | 26.357149 | 92.830441 | 2021-02-21 05:24:33 | Assam, India | ||
471351 | 471351 | 2021-02-19 | India | Assam | 217367 | 1091 | 214658 | 1618 | 26.357149 | 92.830441 | 2021-02-20 05:22:51 | Assam, India | ||
1153060 | 1153060 | 2021-02-18 | India | Assam | 217344 | 1091 | 214639 | 1614 | 26.357149 | 92.830441 | 2021-02-19 05:24:16 | Assam, India | ||
3600980 | 3600980 | 2021-02-17 | India | Assam | 217330 | 1090 | 214628 | 1612 | 26.357149 | 92.830441 | 2021-02-18 05:22:58 | Assam, India | ||
3050115 | 3050115 | 2021-02-16 | India | Assam | 217309 | 1089 | 214615 | 1605 | 26.357149 | 92.830441 | 2021-02-17 05:23:10 | Assam, India | ||
1338214 | 1338214 | 2021-02-15 | India | Assam | 217304 | 1089 | 214601 | 1614 | 26.357149 | 92.830441 | 2021-02-16 05:24:38 | Assam, India | ||
2283365 | 2283365 | 2021-02-14 | India | Assam | 217293 | 1087 | 214585 | 1621 | 26.357149 | 92.830441 | 2021-02-15 05:24:49 | Assam, India | ||
2677765 | 2677765 | 2021-02-13 | India | Assam | 217288 | 1087 | 214570 | 1631 | 26.357149 | 92.830441 | 2021-02-14 05:23:43 | Assam, India | ||
3539398 | 3539398 | 2021-02-12 | India | Assam | 217285 | 1086 | 214542 | 1657 | 26.357149 | 92.830441 | 2021-02-13 05:22:12 | Assam, India | ||
2637661 | 2637661 | 2021-02-11 | India | Assam | 217277 | 1086 | 214530 | 1661 | 26.357149 | 92.830441 | 2021-02-12 05:23:29 | Assam, India | ||
3978516 | 3978516 | 2021-02-10 | India | Assam | 217267 | 1086 | 214507 | 1674 | 26.357149 | 92.830441 | 2021-02-11 05:23:55 | Assam, India | ||
1527836 | 1527836 | 2021-02-09 | India | Assam | 217256 | 1086 | 214490 | 1680 | 26.357149 | 92.830441 | 2021-02-10 05:22:41 | Assam, India | ||
613627 | 613627 | 2021-02-08 | India | Assam | 217229 | 1085 | 214473 | 1671 | 26.357149 | 92.830441 | 2021-02-09 05:23:30 | Assam, India | ||
1672396 | 1672396 | 2021-02-07 | India | Assam | 217210 | 1084 | 214447 | 1679 | 26.357149 | 92.830441 | 2021-02-08 05:22:39 | Assam, India | ||
974857 | 974857 | 2021-02-06 | India | Assam | 217202 | 1084 | 214423 | 1695 | 26.357149 | 92.830441 | 2021-02-07 05:23:00 | Assam, India | ||
1588115 | 1588115 | 2021-02-05 | India | Assam | 217193 | 1084 | 214403 | 1706 | 26.357149 | 92.830441 | 2021-02-06 05:23:55 | Assam, India | ||
790322 | 790322 | 2021-02-04 | India | Assam | 217186 | 1084 | 214374 | 1728 | 26.357149 | 92.830441 | 2021-02-05 05:22:38 | Assam, India | ||
340214 | 340214 | 2021-02-03 | India | Assam | 217175 | 1083 | 214344 | 1748 | 26.357149 | 92.830441 | 2021-02-04 05:22:26 | Assam, India | ||
1684440 | 1684440 | 2021-02-02 | India | Assam | 217161 | 1083 | 214285 | 1793 | 26.357149 | 92.830441 | 2021-02-03 05:22:52 | Assam, India | ||
1676410 | 1676410 | 2021-02-01 | India | Assam | 217154 | 1083 | 214248 | 1823 | 26.357149 | 92.830441 | 2021-02-02 05:22:49 | Assam, India | ||
1459698 | 1459698 | 2021-01-31 | India | Assam | 217141 | 1082 | 214178 | 1881 | 26.357149 | 92.830441 | 2021-02-01 05:22:53 | Assam, India | ||
2211606 | 2211606 | 2021-01-30 | India | Assam | 217120 | 1082 | 214124 | 1914 | 26.357149 | 92.830441 | 2021-01-31 05:22:42 | Assam, India | ||
1897093 | 1897093 | 2021-01-29 | India | Assam | 217091 | 1081 | 214054 | 1956 | 26.357149 | 92.830441 | 2021-01-30 05:22:49 | Assam, India | ||
2481909 | 2481909 | 2021-01-28 | India | Assam | 217071 | 1081 | 213952 | 2038 | 26.357149 | 92.830441 | 2021-01-29 05:22:23 | Assam, India | ||
3153544 | 3153544 | 2021-01-27 | India | Assam | 217042 | 1081 | 213857 | 2104 | 26.357149 | 92.830441 | 2021-01-28 05:22:24 | Assam, India | ||
12279 | 12279 | 2021-01-26 | India | Assam | 217025 | 1079 | 213763 | 2183 | 26.357149 | 92.830441 | 2021-01-27 05:23:41 | Assam, India | ||
2567603 | 2567603 | 2021-01-25 | India | Assam | 217017 | 1078 | 213674 | 2265 | 26.357149 | 92.830441 | 2021-01-26 05:22:02 | Assam, India | ||
1759235 | 1759235 | 2021-01-24 | India | Assam | 216992 | 1078 | 213591 | 2323 | 26.357149 | 92.830441 | 2021-01-25 05:22:16 | Assam, India | ||
2426842 | 2426842 | 2021-01-23 | India | Assam | 216976 | 1077 | 213492 | 2407 | 26.357149 | 92.830441 | 2021-01-24 05:22:35 | Assam, India | ||
2466744 | 2466744 | 2021-01-22 | India | Assam | 216957 | 1077 | 213398 | 2482 | 26.357149 | 92.830441 | 2021-01-23 05:22:03 | Assam, India | ||
435295 | 435295 | 2021-01-21 | India | Assam | 216940 | 1077 | 213295 | 2568 | 26.357149 | 92.830441 | 2021-01-22 05:22:10 | Assam, India | ||
1094027 | 1094027 | 2021-01-20 | India | Assam | 216919 | 1077 | 213179 | 2663 | 26.357149 | 92.830441 | 2021-01-21 05:22:01 | Assam, India | ||
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 |
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]);