daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where province_or_state = "Assam" sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | India | Assam | 617163 | 6111 | 0 | 26.357149 | 92.83044100000001 | 2021-12-03 04:23:05 | Assam, India | |||
2021-10-28 | India | Assam | 609828 | 5989 | 0 | 26.357149 | 92.83044100000001 | 2021-10-29 04:22:03 | Assam, India | |||
2020-10-25 | India | Assam | 204171 | 906 | 185755 | 17510 | 26.357149 | 92.830441 | 2020-10-26 04:25:02 | Assam, India | ||
2021-01-26 | India | Assam | 217025 | 1079 | 213763 | 2183 | 26.357149 | 92.830441 | 2021-01-27 05:23:41 | Assam, India | ||
2021-09-18 | India | Assam | 597709 | 5790 | 0 | 26.357149 | 92.83044100000001 | 2021-09-19 04:21:34 | Assam, India | |||
2021-05-28 | India | Assam | 398010 | 3168 | 340178 | 54664 | 26.357149 | 92.830441 | 2021-05-29 04:20:41 | Assam, India | ||
2022-03-20 | India | Assam | 724190 | 6639 | 0 | 26.357149 | 92.83044100000001 | 2022-03-21 04:20:50 | Assam, India | |||
2021-11-11 | India | Assam | 613312 | 6042 | 0 | 26.357149 | 92.83044100000001 | 2021-11-12 04:22:01 | Assam, India | |||
2021-08-25 | India | Assam | 586378 | 5607 | 0 | 26.357149 | 92.83044100000001 | 2021-08-26 04:21:28 | Assam, India | |||
2021-04-12 | India | Assam | 220893 | 1118 | 216041 | 3734 | 26.357149 | 92.830441 | 2021-04-13 04:20:37 | Assam, India | ||
2021-11-02 | India | Assam | 611211 | 6011 | 0 | 26.357149 | 92.83044100000001 | 2021-11-03 06:22:09 | Assam, India | |||
2021-05-29 | India | Assam | 403623 | 3245 | 344083 | 56295 | 26.357149 | 92.830441 | 2021-05-30 04:20:55 | Assam, India | ||
2021-03-07 | India | Assam | 217668 | 1094 | 214947 | 1627 | 26.357149 | 92.830441 | 2021-03-08 05:24:48 | Assam, India | ||
2020-07-23 | India | Assam | 28791 | 70 | 20699 | 8022 | 26.357149 | 92.830441 | 2020-07-24 05:30:40 | Assam, India | ||
2022-11-12 | India | Assam | 746090 | 8035 | 0 | 26.357149 | 92.830441 | 2022-11-13 04:21:14 | Assam, India | |||
2021-09-01 | India | Assam | 589999 | 5671 | 0 | 26.357149 | 92.83044100000001 | 2021-09-02 04:21:15 | Assam, India | |||
2022-02-07 | India | Assam | 721937 | 6571 | 0 | 26.357149 | 92.83044100000001 | 2022-02-08 04:21:15 | Assam, India | |||
2020-12-03 | India | Assam | 213336 | 985 | 208846 | 3505 | 26.357149 | 92.830441 | 2020-12-04 05:27:27 | Assam, India | ||
2020-10-14 | India | Assam | 198213 | 834 | 168072 | 29307 | 26.357149 | 92.830441 | 2020-10-15 04:24:28 | Assam, India | ||
2021-05-25 | India | Assam | 381171 | 2915 | 323368 | 54888 | 26.357149 | 92.830441 | 2021-05-26 04:20:35 | Assam, India | ||
2021-11-09 | India | Assam | 612798 | 6034 | 0 | 26.357149 | 92.83044100000001 | 2021-11-10 04:21:38 | Assam, India | |||
2022-07-23 | India | Assam | 734748 | 8013 | 0 | 26.357149 | 92.830441 | 2022-07-24 04:20:47 | Assam, India | |||
2020-08-04 | India | Assam | 48161 | 115 | 34421 | 13625 | 26.357149 | 92.830441 | 2020-08-05 04:34:43 | Assam, India | ||
2022-01-14 | India | Assam | 640636 | 6197 | 0 | 26.357149 | 92.83044100000001 | 2022-01-15 04:21:07 | Assam, India | |||
2021-08-15 | India | Assam | 579899 | 5492 | 0 | 26.357149 | 92.83044100000001 | 2021-08-16 04:21:31 | Assam, India | |||
2021-06-19 | India | Assam | 480730 | 4178 | 441184 | 35368 | 26.357149 | 92.830441 | 2021-06-20 04:21:48 | Assam, India | ||
2022-09-06 | India | Assam | 744756 | 8033 | 0 | 26.357149 | 92.830441 | 2022-09-07 04:20:59 | Assam, India | |||
2020-07-19 | India | Assam | 23999 | 57 | 16023 | 7919 | 26.357149 | 92.83044100000001 | 2020-07-20 05:34:40 | Assam, India | ||
2020-11-18 | India | Assam | 210865 | 969 | 206611 | 3285 | 26.357149 | 92.830441 | 2020-11-19 05:25:23 | Assam, India | ||
2022-01-09 | India | Assam | 626741 | 6181 | 0 | 26.357149 | 92.83044100000001 | 2022-01-10 04:22:07 | Assam, India | |||
2022-10-04 | India | Assam | 745674 | 8035 | 0 | 26.357149 | 92.830441 | 2022-10-05 04:23:06 | Assam, India | |||
2021-12-04 | India | Assam | 617306 | 6113 | 0 | 26.357149 | 92.83044100000001 | 2021-12-05 04:22:25 | Assam, India | |||
2022-07-09 | India | Assam | 726455 | 7991 | 0 | 26.357149 | 92.830441 | 2022-07-10 04:20:54 | Assam, India | |||
2020-08-15 | India | Assam | 75558 | 182 | 53286 | 22090 | 26.357149 | 92.830441 | 2020-08-16 04:27:42 | Assam, India | ||
2021-11-29 | India | Assam | 616708 | 6098 | 0 | 26.357149 | 92.83044100000001 | 2021-11-30 04:22:53 | Assam, India | |||
2021-01-08 | India | Assam | 216481 | 1059 | 212376 | 3046 | 26.357149 | 92.830441 | 2021-01-09 05:22:18 | Assam, India | ||
2022-03-29 | India | Assam | 724196 | 6639 | 0 | 26.357149 | 92.83044100000001 | 2022-03-30 04:20:45 | Assam, India | |||
2021-11-19 | India | Assam | 615053 | 6066 | 0 | 26.357149 | 92.83044100000001 | 2021-11-20 04:22:17 | Assam, India | |||
2022-06-21 | India | Assam | 724398 | 7988 | 0 | 26.357149 | 92.830441 | 2022-06-22 04:20:54 | Assam, India | |||
2021-04-16 | India | Assam | 222940 | 1127 | 216397 | 5416 | 26.357149 | 92.830441 | 2021-04-17 04:20:40 | Assam, India | ||
2020-07-27 | India | Assam | 33576 | 86 | 25402 | 8088 | 26.357149 | 92.830441 | 2020-07-28 04:58:43 | Assam, India | ||
2021-09-02 | India | Assam | 590553 | 5677 | 0 | 26.357149 | 92.83044100000001 | 2021-09-03 04:21:20 | Assam, India | |||
2021-02-21 | India | Assam | 217392 | 1091 | 214694 | 1607 | 26.357149 | 92.830441 | 2021-02-22 05:24:21 | Assam, India | ||
2022-02-13 | India | Assam | 723495 | 6605 | 0 | 26.357149 | 92.83044100000001 | 2022-02-14 04:20:51 | Assam, India | |||
2021-01-11 | India | Assam | 216635 | 1064 | 212579 | 2992 | 26.357149 | 92.830441 | 2021-01-12 05:22:15 | Assam, India | ||
2020-08-31 | India | Assam | 109040 | 306 | 85461 | 23273 | 26.357149 | 92.830441 | 2020-09-01 04:28:31 | Assam, India | ||
2022-10-19 | India | Assam | 745933 | 8035 | 0 | 26.357149 | 92.830441 | 2022-10-20 04:22:59 | Assam, India | |||
2020-12-25 | India | Assam | 215836 | 1033 | 211381 | 3422 | 26.357149 | 92.830441 | 2020-12-26 05:22:28 | Assam, India | ||
2020-08-19 | India | Assam | 84317 | 213 | 60348 | 23756 | 26.357149 | 92.830441 | 2020-08-20 04:27:43 | Assam, India | ||
2020-10-29 | India | Assam | 205635 | 923 | 193574 | 11138 | 26.357149 | 92.830441 | 2020-10-30 04:24:49 | Assam, India | ||
2022-12-26 | India | Assam | 746100 | 8035 | 0 | 26.357149 | 92.830441 | 2022-12-27 04:21:07 | Assam, India | |||
2022-05-09 | India | Assam | 724219 | 7986 | 0 | 26.357149 | 92.830441 | 2022-05-10 04:20:50 | Assam, India | |||
2022-05-31 | India | Assam | 724230 | 7986 | 0 | 26.357149 | 92.830441 | 2022-06-01 04:20:55 | Assam, India | |||
2022-02-11 | India | Assam | 723244 | 6596 | 0 | 26.357149 | 92.83044100000001 | 2022-02-12 04:21:06 | Assam, India | |||
2021-01-18 | India | Assam | 216864 | 1075 | 212978 | 2811 | 26.357149 | 92.830441 | 2021-01-19 05:22:15 | Assam, India | ||
2021-04-02 | India | Assam | 218533 | 1107 | 215517 | 1909 | 26.357149 | 92.830441 | 2021-04-03 04:20:44 | Assam, India | ||
2021-08-17 | India | Assam | 581398 | 5513 | 0 | 26.357149 | 92.83044100000001 | 2021-08-18 04:21:35 | Assam, India | |||
2021-09-04 | India | Assam | 591659 | 5693 | 0 | 26.357149 | 92.83044100000001 | 2021-09-05 04:21:33 | Assam, India | |||
2022-09-08 | India | Assam | 744877 | 8033 | 0 | 26.357149 | 92.830441 | 2022-09-09 04:21:11 | Assam, India | |||
2022-12-10 | India | Assam | 746100 | 8035 | 0 | 26.357149 | 92.830441 | 2022-12-11 04:20:50 | Assam, India | |||
2022-03-15 | India | Assam | 724178 | 6639 | 0 | 26.357149 | 92.83044100000001 | 2022-03-16 04:20:50 | Assam, India | |||
2020-11-10 | India | Assam | 209388 | 952 | 202471 | 5965 | 26.357149 | 92.830441 | 2020-11-11 05:25:30 | Assam, India | ||
2021-11-03 | India | Assam | 611487 | 6015 | 0 | 26.357149 | 92.83044100000001 | 2021-11-04 04:22:20 | Assam, India | |||
2021-02-24 | India | Assam | 217454 | 1091 | 214757 | 1606 | 26.357149 | 92.830441 | 2021-02-25 05:24:57 | Assam, India | ||
2020-06-15 | India | Assam | 4158 | 8 | 2166 | 1984 | 26.357149 | 92.83044100000001 | 2020-06-16 04:33:09 | Assam, India | ||
2021-10-31 | India | Assam | 610645 | 5997 | 0 | 26.357149 | 92.83044100000001 | 2021-11-01 04:22:01 | Assam, India | |||
2022-11-15 | India | Assam | 746095 | 8035 | 0 | 26.357149 | 92.830441 | 2022-11-16 04:21:09 | Assam, India | |||
2021-07-15 | India | Assam | 542445 | 4937 | 517041 | 20467 | 26.357149 | 92.830441 | 2021-07-16 04:21:22 | Assam, India | ||
2020-07-01 | India | Assam | 8582 | 12 | 5851 | 2719 | 26.357149 | 92.83044100000001 | 2020-07-02 04:33:46 | Assam, India | ||
2022-04-16 | India | Assam | 724200 | 6639 | 0 | 26.357149 | 92.83044100000001 | 2022-04-17 04:20:59 | Assam, India | |||
2022-12-13 | India | Assam | 746100 | 8035 | 0 | 26.357149 | 92.830441 | 2022-12-14 04:21:04 | Assam, India | |||
2022-11-13 | India | Assam | 746094 | 8035 | 0 | 26.357149 | 92.830441 | 2022-11-14 04:21:09 | Assam, India | |||
2022-02-12 | India | Assam | 723416 | 6601 | 0 | 26.357149 | 92.83044100000001 | 2022-02-13 04:21:00 | Assam, India | |||
2022-10-30 | India | Assam | 746046 | 8035 | 0 | 26.357149 | 92.830441 | 2022-10-31 04:21:36 | Assam, India | |||
2020-07-20 | India | Assam | 25382 | 58 | 17095 | 8229 | 26.357149 | 92.83044100000001 | 2020-07-21 04:38:46 | Assam, India | ||
2022-12-27 | India | Assam | 746100 | 8035 | 0 | 26.357149 | 92.830441 | 2022-12-28 04:21:04 | Assam, India | |||
2021-08-04 | India | Assam | 570504 | 5326 | 552955 | 12223 | 26.357149 | 92.830441 | 2021-08-05 04:21:51 | Assam, India | ||
2022-03-18 | India | Assam | 724185 | 6639 | 0 | 26.357149 | 92.83044100000001 | 2022-03-19 04:20:47 | Assam, India | |||
2021-02-03 | India | Assam | 217175 | 1083 | 214344 | 1748 | 26.357149 | 92.830441 | 2021-02-04 05:22:26 | Assam, India | ||
2020-09-14 | India | Assam | 141763 | 469 | 113133 | 28161 | 26.357149 | 92.830441 | 2020-09-15 03:22:50 | Assam, India | ||
2022-12-14 | India | Assam | 746100 | 8035 | 0 | 26.357149 | 92.830441 | 2022-12-15 04:20:58 | Assam, India | |||
2021-03-11 | India | Assam | 217745 | 1097 | 215023 | 1625 | 26.357149 | 92.830441 | 2021-03-12 05:26:50 | Assam, India | ||
2022-03-11 | India | Assam | 724170 | 6639 | 0 | 26.357149 | 92.83044100000001 | 2022-03-12 04:20:50 | Assam, India | |||
2022-05-07 | India | Assam | 724219 | 7986 | 0 | 26.357149 | 92.830441 | 2022-05-08 04:20:49 | Assam, India | |||
2020-07-16 | India | Assam | 19754 | 48 | 12888 | 6818 | 26.357149 | 92.830441 | 2020-07-17 04:34:50 | Assam, India | ||
2020-08-08 | India | Assam | 57714 | 140 | 40591 | 16983 | 26.357149 | 92.830441 | 2020-08-09 04:34:54 | Assam, India | ||
2022-09-13 | India | Assam | 745177 | 8034 | 0 | 26.357149 | 92.830441 | 2022-09-14 04:20:44 | Assam, India | |||
2020-11-06 | India | Assam | 208389 | 938 | 200384 | 7067 | 26.357149 | 92.830441 | 2020-11-07 05:24:52 | Assam, India | ||
2021-04-30 | India | Assam | 253123 | 1307 | 226643 | 25173 | 26.357149 | 92.830441 | 2021-05-01 04:20:47 | Assam, India | ||
2022-09-23 | India | Assam | 745495 | 8034 | 0 | 26.357149 | 92.830441 | 2022-09-24 04:21:40 | Assam, India | |||
2021-04-04 | India | Assam | 218670 | 1109 | 215597 | 1964 | 26.357149 | 92.830441 | 2021-04-05 04:20:35 | Assam, India | ||
2020-11-27 | India | Assam | 212320 | 980 | 208068 | 3272 | 26.357149 | 92.830441 | 2020-11-28 05:25:50 | Assam, India | ||
2022-10-07 | India | Assam | 745703 | 8035 | 0 | 26.357149 | 92.830441 | 2022-10-08 04:22:56 | Assam, India | |||
2021-06-29 | India | Assam | 506005 | 4509 | 474457 | 27039 | 26.357149 | 92.830441 | 2021-06-30 04:21:41 | Assam, India | ||
2021-12-07 | India | Assam | 617908 | 6127 | 0 | 26.357149 | 92.83044100000001 | 2021-12-08 04:22:46 | Assam, India | |||
2021-07-28 | India | Assam | 562731 | 5201 | 543031 | 14499 | 26.357149 | 92.830441 | 2021-07-29 04:21:33 | Assam, India | ||
2020-07-05 | India | Assam | 11388 | 14 | 7125 | 4249 | 26.357149 | 92.83044100000001 | 2020-07-06 04:33:57 | Assam, India | ||
2022-09-18 | India | Assam | 745305 | 8034 | 0 | 26.357149 | 92.830441 | 2022-09-19 04:21:49 | Assam, India | |||
2021-10-10 | India | Assam | 604969 | 5926 | 0 | 26.357149 | 92.83044100000001 | 2021-10-11 04:21:31 | Assam, India | |||
2020-09-07 | India | Assam | 128244 | 370 | 99076 | 28798 | 26.357149 | 92.830441 | 2020-09-08 04:28:25 | Assam, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;