daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Assam" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-09-18 | India | Assam | 152858 | 540 | 123687 | 28631 | 26.357149 | 92.830441 | 2020-09-19 04:22:00 | Assam, India | ||
2020-09-19 | India | Assam | 155453 | 548 | 125543 | 29362 | 26.357149 | 92.830441 | 2020-09-20 04:22:00 | Assam, India | ||
2020-09-20 | India | Assam | 156680 | 562 | 127338 | 28780 | 26.357149 | 92.830441 | 2020-09-21 04:23:00 | Assam, India | ||
2020-09-21 | India | Assam | 159320 | 578 | 129133 | 29609 | 26.357149 | 92.830441 | 2020-09-22 04:23:00 | Assam, India | ||
2020-09-22 | India | Assam | 161393 | 586 | 130950 | 29857 | 26.357149 | 92.830441 | 2020-09-23 04:23:00 | Assam, India | ||
2020-09-23 | India | Assam | 163491 | 597 | 132712 | 30182 | 26.357149 | 92.830441 | 2020-09-24 04:23:00 | Assam, India | ||
2020-09-24 | India | Assam | 165582 | 608 | 135144 | 29830 | 26.357149 | 92.830441 | 2020-09-25 04:23:00 | Assam, India | ||
2020-09-25 | India | Assam | 167374 | 625 | 136715 | 30034 | 26.357149 | 92.830441 | 2020-09-26 04:23:00 | Assam, India | ||
2020-09-26 | India | Assam | 169110 | 638 | 138310 | 30162 | 26.357149 | 92.830441 | 2020-09-27 04:23:00 | Assam, India | ||
2020-09-27 | India | Assam | 169985 | 655 | 139980 | 29350 | 26.357149 | 92.830441 | 2020-09-28 04:23:00 | Assam, India | ||
2020-09-28 | India | Assam | 173629 | 667 | 142300 | 30662 | 26.357149 | 92.830441 | 2020-09-29 04:23:42 | Assam, India | ||
2020-09-29 | India | Assam | 177221 | 680 | 144002 | 32539 | 26.357149 | 92.830441 | 2020-09-30 04:23:33 | Assam, India | ||
2020-09-30 | India | Assam | 180811 | 697 | 145618 | 34496 | 26.357149 | 92.830441 | 2020-10-01 04:23:42 | Assam, India | ||
2020-10-01 | India | Assam | 182396 | 711 | 147522 | 34163 | 26.357149 | 92.830441 | 2020-10-02 04:23:51 | Assam, India | ||
2020-10-02 | India | Assam | 183812 | 721 | 148963 | 34128 | 26.357149 | 92.830441 | 2020-10-03 04:23:40 | Assam, India | ||
2020-10-03 | India | Assam | 185444 | 735 | 150776 | 33933 | 26.357149 | 92.830441 | 2020-10-04 04:23:44 | Assam, India | ||
2020-10-04 | India | Assam | 186200 | 749 | 152127 | 33324 | 26.357149 | 92.830441 | 2020-10-05 04:23:33 | Assam, India | ||
2020-10-05 | India | Assam | 187718 | 760 | 153491 | 33467 | 26.357149 | 92.830441 | 2020-10-06 04:23:33 | Assam, India | ||
2020-10-06 | India | Assam | 188902 | 778 | 155077 | 33047 | 26.357149 | 92.830441 | 2020-10-07 04:23:40 | Assam, India | ||
2020-10-07 | India | Assam | 190209 | 785 | 157638 | 31786 | 26.357149 | 92.830441 | 2020-10-08 04:23:56 | Assam, India | ||
2020-10-08 | India | Assam | 191397 | 794 | 159836 | 30767 | 26.357149 | 92.830441 | 2020-10-09 04:23:59 | Assam, India | ||
2020-10-09 | India | Assam | 192416 | 802 | 161904 | 29710 | 26.357149 | 92.830441 | 2020-10-10 04:23:57 | Assam, India | ||
2020-10-10 | India | Assam | 193387 | 811 | 163355 | 29221 | 26.357149 | 92.830441 | 2020-10-11 04:23:46 | Assam, India | ||
2020-10-11 | India | Assam | 193783 | 816 | 164582 | 28385 | 26.357149 | 92.830441 | 2020-10-12 04:23:45 | Assam, India | ||
2020-10-12 | India | Assam | 195304 | 826 | 166039 | 28439 | 26.357149 | 92.830441 | 2020-10-13 04:24:02 | Assam, India | ||
2020-10-13 | India | Assam | 196786 | 830 | 167059 | 28897 | 26.357149 | 92.830441 | 2020-10-14 04:24:05 | Assam, India | ||
2020-10-14 | India | Assam | 198213 | 834 | 168072 | 29307 | 26.357149 | 92.830441 | 2020-10-15 04:24:28 | Assam, India | ||
2020-10-15 | India | Assam | 198982 | 843 | 169335 | 28804 | 26.357149 | 92.830441 | 2020-10-16 04:24:01 | Assam, India | ||
2020-10-16 | India | Assam | 199749 | 853 | 170265 | 28631 | 26.357149 | 92.830441 | 2020-10-17 04:24:12 | Assam, India | ||
2020-10-17 | India | Assam | 200391 | 865 | 171084 | 28442 | 26.357149 | 92.830441 | 2020-10-18 04:24:25 | Assam, India | ||
2020-10-18 | India | Assam | 200709 | 868 | 171683 | 28158 | 26.357149 | 92.830441 | 2020-10-19 04:24:16 | Assam, India | ||
2020-10-19 | India | Assam | 201407 | 875 | 173213 | 27319 | 26.357149 | 92.830441 | 2020-10-20 04:24:22 | Assam, India | ||
2020-10-20 | India | Assam | 202073 | 884 | 174414 | 26775 | 26.357149 | 92.830441 | 2020-10-21 04:24:14 | Assam, India | ||
2020-10-21 | India | Assam | 202774 | 889 | 176078 | 25807 | 26.357149 | 92.830441 | 2020-10-22 04:24:27 | Assam, India | ||
2020-10-22 | India | Assam | 203282 | 896 | 177662 | 24724 | 26.357149 | 92.830441 | 2020-10-23 04:24:46 | Assam, India | ||
2020-10-23 | India | Assam | 203709 | 900 | 179846 | 22963 | 26.357149 | 92.830441 | 2020-10-24 04:24:46 | Assam, India | ||
2020-10-24 | India | Assam | 203967 | 902 | 182794 | 20271 | 26.357149 | 92.830441 | 2020-10-25 04:24:36 | Assam, India | ||
2020-10-25 | India | Assam | 204171 | 906 | 185755 | 17510 | 26.357149 | 92.830441 | 2020-10-26 04:25:02 | Assam, India | ||
2020-10-26 | India | Assam | 204386 | 908 | 188587 | 14891 | 26.357149 | 92.830441 | 2020-10-27 04:24:45 | Assam, India | ||
2020-10-27 | India | Assam | 204789 | 914 | 191030 | 12845 | 26.357149 | 92.830441 | 2020-10-28 04:24:39 | Assam, India | ||
2020-10-28 | India | Assam | 205237 | 917 | 192517 | 11803 | 26.357149 | 92.830441 | 2020-10-29 04:24:49 | Assam, India | ||
2020-10-29 | India | Assam | 205635 | 923 | 193574 | 11138 | 26.357149 | 92.830441 | 2020-10-30 04:24:49 | Assam, India | ||
2020-10-30 | India | Assam | 206015 | 926 | 194668 | 10421 | 26.357149 | 92.830441 | 2020-10-31 04:24:44 | Assam, India | ||
2020-10-31 | India | Assam | 206351 | 930 | 196054 | 9367 | 26.357149 | 92.830441 | 2020-11-01 04:36:19 | Assam, India | ||
2020-11-01 | India | Assam | 206517 | 931 | 196784 | 8802 | 26.357149 | 92.830441 | 2020-11-02 05:25:04 | Assam, India | ||
2020-11-02 | India | Assam | 206982 | 932 | 197569 | 8481 | 26.357149 | 92.830441 | 2020-11-03 06:00:16 | Assam, India | ||
2020-11-03 | India | Assam | 207361 | 934 | 198042 | 8385 | 26.357149 | 92.830441 | 2020-11-04 05:25:09 | Assam, India | ||
2020-11-04 | India | Assam | 207741 | 934 | 198697 | 8110 | 26.357149 | 92.830441 | 2020-11-05 06:05:03 | Assam, India | ||
2020-11-05 | India | Assam | 208054 | 934 | 199458 | 7662 | 26.357149 | 92.830441 | 2020-11-06 05:24:55 | Assam, India | ||
2020-11-06 | India | Assam | 208389 | 938 | 200384 | 7067 | 26.357149 | 92.830441 | 2020-11-07 05:24:52 | Assam, India | ||
2020-11-07 | India | Assam | 208637 | 940 | 200939 | 6758 | 26.357149 | 92.830441 | 2020-11-08 05:24:56 | Assam, India | ||
2020-11-08 | India | Assam | 208789 | 943 | 201334 | 6512 | 26.357149 | 92.830441 | 2020-11-09 05:25:45 | Assam, India | ||
2020-11-09 | India | Assam | 209117 | 947 | 201842 | 6328 | 26.357149 | 92.830441 | 2020-11-10 05:40:07 | Assam, India | ||
2020-11-10 | India | Assam | 209388 | 952 | 202471 | 5965 | 26.357149 | 92.830441 | 2020-11-11 05:25:30 | Assam, India | ||
2020-11-11 | India | Assam | 209633 | 954 | 203308 | 5371 | 26.357149 | 92.830441 | 2020-11-12 05:25:55 | Assam, India | ||
2020-11-12 | India | Assam | 209835 | 957 | 204079 | 4799 | 26.357149 | 92.830441 | 2020-11-13 05:25:30 | Assam, India | ||
2020-11-13 | India | Assam | 210068 | 958 | 204721 | 4389 | 26.357149 | 92.830441 | 2020-11-14 05:25:37 | Assam, India | ||
2020-11-14 | India | Assam | 210175 | 961 | 205250 | 3964 | 26.357149 | 92.830441 | 2020-11-15 05:26:53 | Assam, India | ||
2020-11-15 | India | Assam | 210268 | 963 | 205639 | 3666 | 26.357149 | 92.830441 | 2020-11-16 05:25:57 | Assam, India | ||
2020-11-16 | India | Assam | 210454 | 964 | 206044 | 3446 | 26.357149 | 92.830441 | 2020-11-17 05:25:54 | Assam, India | ||
2020-11-17 | India | Assam | 210696 | 966 | 206401 | 3329 | 26.357149 | 92.830441 | 2020-11-18 05:40:31 | Assam, India | ||
2020-11-18 | India | Assam | 210865 | 969 | 206611 | 3285 | 26.357149 | 92.830441 | 2020-11-19 05:25:23 | Assam, India | ||
2020-11-19 | India | Assam | 211040 | 969 | 206878 | 3193 | 26.357149 | 92.830441 | 2020-11-20 05:26:28 | Assam, India | ||
2020-11-20 | India | Assam | 211204 | 971 | 207029 | 3204 | 26.357149 | 92.830441 | 2020-11-21 05:25:51 | Assam, India | ||
2020-11-21 | India | Assam | 211427 | 973 | 207222 | 3232 | 26.357149 | 92.830441 | 2020-11-22 05:25:45 | Assam, India | ||
2020-11-22 | India | Assam | 211513 | 974 | 207397 | 3142 | 26.357149 | 92.830441 | 2020-11-23 05:25:26 | Assam, India | ||
2020-11-23 | India | Assam | 211682 | 975 | 207528 | 3179 | 26.357149 | 92.830441 | 2020-11-24 05:27:31 | Assam, India | ||
2020-11-24 | India | Assam | 211839 | 976 | 207649 | 3214 | 26.357149 | 92.830441 | 2020-11-25 05:27:20 | Assam, India | ||
2020-11-25 | India | Assam | 212021 | 978 | 207766 | 3277 | 26.357149 | 92.830441 | 2020-11-26 05:27:44 | Assam, India | ||
2020-11-26 | India | Assam | 212171 | 978 | 207908 | 3285 | 26.357149 | 92.830441 | 2020-11-27 05:26:53 | Assam, India | ||
2020-11-27 | India | Assam | 212320 | 980 | 208068 | 3272 | 26.357149 | 92.830441 | 2020-11-28 05:25:50 | Assam, India | ||
2020-11-28 | India | Assam | 212483 | 980 | 208190 | 3313 | 26.357149 | 92.830441 | 2020-11-29 05:25:55 | Assam, India | ||
2020-11-29 | India | Assam | 212617 | 981 | 208286 | 3350 | 26.357149 | 92.830441 | 2020-11-30 05:26:13 | Assam, India | ||
2020-11-30 | India | Assam | 212776 | 981 | 208396 | 3399 | 26.357149 | 92.830441 | 2020-12-01 05:26:18 | Assam, India | ||
2020-12-01 | India | Assam | 212998 | 981 | 208531 | 3486 | 26.357149 | 92.830441 | 2020-12-02 05:27:41 | Assam, India | ||
2020-12-02 | India | Assam | 213171 | 983 | 208669 | 3519 | 26.357149 | 92.830441 | 2020-12-03 05:28:22 | Assam, India | ||
2020-12-03 | India | Assam | 213336 | 985 | 208846 | 3505 | 26.357149 | 92.830441 | 2020-12-04 05:27:27 | Assam, India | ||
2020-12-04 | India | Assam | 213505 | 987 | 208967 | 3551 | 26.357149 | 92.830441 | 2020-12-05 05:27:36 | Assam, India | ||
2020-12-05 | India | Assam | 213662 | 989 | 209130 | 3543 | 26.357149 | 92.830441 | 2020-12-06 05:26:18 | Assam, India | ||
2020-12-06 | India | Assam | 213759 | 993 | 209214 | 3552 | 26.357149 | 92.830441 | 2020-12-07 05:26:14 | Assam, India | ||
2020-12-07 | India | Assam | 213925 | 995 | 209345 | 3585 | 26.357149 | 92.830441 | 2020-12-08 05:27:42 | Assam, India | ||
2020-12-08 | India | Assam | 214019 | 997 | 209447 | 3575 | 26.357149 | 92.830441 | 2020-12-09 05:28:01 | Assam, India | ||
2020-12-09 | India | Assam | 214165 | 998 | 209625 | 3542 | 26.357149 | 92.830441 | 2020-12-10 05:26:19 | Assam, India | ||
2020-12-10 | India | Assam | 214305 | 999 | 209790 | 3516 | 26.357149 | 92.830441 | 2020-12-11 05:26:59 | Assam, India | ||
2020-12-11 | India | Assam | 214432 | 1000 | 209939 | 3493 | 26.357149 | 92.830441 | 2020-12-12 05:26:19 | Assam, India | ||
2020-12-12 | India | Assam | 214584 | 1000 | 210057 | 3527 | 26.357149 | 92.830441 | 2020-12-13 05:27:20 | Assam, India | ||
2020-12-13 | India | Assam | 214657 | 1002 | 210174 | 3481 | 26.357149 | 92.830441 | 2020-12-14 05:26:27 | Assam, India | ||
2020-12-14 | India | Assam | 214803 | 1003 | 210299 | 3501 | 26.357149 | 92.830441 | 2020-12-15 05:26:38 | Assam, India | ||
2020-12-15 | India | Assam | 214945 | 1004 | 210401 | 3540 | 26.357149 | 92.830441 | 2020-12-16 05:28:04 | Assam, India | ||
2020-12-16 | India | Assam | 215042 | 1007 | 210491 | 3544 | 26.357149 | 92.830441 | 2020-12-17 05:28:12 | Assam, India | ||
2020-12-17 | India | Assam | 215148 | 1010 | 210615 | 3523 | 26.357149 | 92.830441 | 2020-12-18 05:28:18 | Assam, India | ||
2020-12-18 | India | Assam | 215250 | 1011 | 210700 | 3539 | 26.357149 | 92.830441 | 2020-12-19 05:27:52 | Assam, India | ||
2020-12-19 | India | Assam | 215346 | 1012 | 210808 | 3526 | 26.357149 | 92.830441 | 2020-12-20 05:27:32 | Assam, India | ||
2020-12-20 | India | Assam | 215409 | 1017 | 210872 | 3520 | 26.357149 | 92.830441 | 2020-12-21 05:27:58 | Assam, India | ||
2020-12-21 | India | Assam | 215510 | 1020 | 210965 | 3525 | 26.357149 | 92.830441 | 2020-12-22 05:22:33 | Assam, India | ||
2020-12-22 | India | Assam | 215585 | 1024 | 211078 | 3483 | 26.357149 | 92.830441 | 2020-12-23 05:22:03 | Assam, India | ||
2020-12-23 | India | Assam | 215680 | 1029 | 211181 | 3470 | 26.357149 | 92.830441 | 2020-12-24 05:23:04 | Assam, India | ||
2020-12-24 | India | Assam | 215775 | 1033 | 211286 | 3456 | 26.357149 | 92.830441 | 2020-12-25 05:22:48 | Assam, India | ||
2020-12-25 | India | Assam | 215836 | 1033 | 211381 | 3422 | 26.357149 | 92.830441 | 2020-12-26 05:22:28 | Assam, India | ||
2020-12-26 | India | Assam | 215910 | 1035 | 211486 | 3389 | 26.357149 | 92.830441 | 2020-12-27 05:22:55 | Assam, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;