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)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-06-10 | India | Assam | 2937 | 4 | 1085 | 1848 | 26.357149 | 92.830441 | 2020-06-11 03:33:41 | Assam, India | ||
2020-06-11 | India | Assam | 3319 | 6 | 1432 | 1881 | 26.357149 | 92.83044100000001 | 2020-06-12 05:09:52 | Assam, India | ||
2020-06-12 | India | Assam | 3319 | 6 | 1432 | 1881 | 26.357149 | 92.83044100000001 | 2020-06-13 03:33:14 | Assam, India | ||
2020-06-13 | India | Assam | 3498 | 8 | 1537 | 1953 | 26.357149 | 92.83044100000001 | 2020-06-14 03:33:15 | Assam, India | ||
2020-06-14 | India | Assam | 3718 | 8 | 1584 | 2126 | 26.357149 | 92.83044100000001 | 2020-06-15 03:33:14 | Assam, India | ||
2020-06-15 | India | Assam | 4158 | 8 | 2166 | 1984 | 26.357149 | 92.83044100000001 | 2020-06-16 04:33:09 | Assam, India | ||
2020-06-16 | India | Assam | 4319 | 8 | 2166 | 2145 | 26.357149 | 92.83044100000001 | 2020-06-17 04:33:21 | Assam, India | ||
2020-06-17 | India | Assam | 4605 | 8 | 2642 | 1955 | 26.357149 | 92.83044100000001 | 2020-06-18 04:33:18 | Assam, India | ||
2020-06-18 | India | Assam | 4777 | 9 | 2654 | 2114 | 26.357149 | 92.83044100000001 | 2020-06-19 04:33:17 | Assam, India | ||
2020-06-19 | India | Assam | 4904 | 9 | 3039 | 1856 | 26.357149 | 92.83044100000001 | 2020-06-20 04:33:19 | Assam, India | ||
2020-06-20 | India | Assam | 4904 | 9 | 3039 | 1856 | 26.357149 | 92.83044100000001 | 2020-06-21 04:33:19 | Assam, India | ||
2020-06-21 | India | Assam | 5388 | 9 | 3360 | 2019 | 26.357149 | 92.83044100000001 | 2020-06-22 04:33:20 | Assam, India | ||
2020-06-22 | India | Assam | 5586 | 9 | 3521 | 2056 | 26.357149 | 92.83044100000001 | 2020-06-23 04:33:22 | Assam, India | ||
2020-06-23 | India | Assam | 5831 | 9 | 3762 | 2060 | 26.357149 | 92.83044100000001 | 2020-06-24 04:33:28 | Assam, India | ||
2020-06-24 | India | Assam | 6198 | 9 | 3958 | 2231 | 26.357149 | 92.83044100000001 | 2020-06-25 05:26:54 | Assam, India | ||
2020-06-25 | India | Assam | 6321 | 9 | 4033 | 2279 | 26.357149 | 92.83044100000001 | 2020-06-26 04:33:43 | Assam, India | ||
2020-06-26 | India | Assam | 6607 | 9 | 4259 | 2339 | 26.357149 | 92.83044100000001 | 2020-06-27 04:33:35 | Assam, India | ||
2020-06-27 | India | Assam | 6816 | 9 | 4500 | 2307 | 26.357149 | 92.83044100000001 | 2020-06-28 04:34:04 | Assam, India | ||
2020-06-28 | India | Assam | 7206 | 10 | 5088 | 2108 | 26.357149 | 92.83044100000001 | 2020-06-29 04:33:44 | Assam, India | ||
2020-06-29 | India | Assam | 7752 | 11 | 5333 | 2408 | 26.357149 | 92.830441 | 2020-06-30 04:33:48 | Assam, India | ||
2020-06-30 | India | Assam | 8227 | 12 | 5647 | 2568 | 26.357149 | 92.83044100000001 | 2020-07-01 04:33:52 | Assam, India | ||
2020-07-01 | India | Assam | 8582 | 12 | 5851 | 2719 | 26.357149 | 92.83044100000001 | 2020-07-02 04:33:46 | Assam, India | ||
2020-07-02 | India | Assam | 9013 | 12 | 6106 | 2895 | 26.357149 | 92.830441 | 2020-07-03 04:33:54 | Assam, India | ||
2020-07-03 | India | Assam | 9673 | 14 | 6349 | 3310 | 26.357149 | 92.83044100000001 | 2020-07-04 04:33:51 | Assam, India | ||
2020-07-04 | India | Assam | 10668 | 14 | 6657 | 3997 | 26.357149 | 92.83044100000001 | 2020-07-05 04:33:46 | Assam, India | ||
2020-07-05 | India | Assam | 11388 | 14 | 7125 | 4249 | 26.357149 | 92.83044100000001 | 2020-07-06 04:33:57 | Assam, India | ||
2020-07-06 | India | Assam | 12160 | 14 | 7882 | 4264 | 26.357149 | 92.83044100000001 | 2020-07-07 04:34:00 | Assam, India | ||
2020-07-07 | India | Assam | 12522 | 14 | 8329 | 4179 | 26.357149 | 92.83044100000001 | 2020-07-08 05:33:48 | Assam, India | ||
2020-07-08 | India | Assam | 13336 | 16 | 8729 | 4591 | 26.357149 | 92.83044100000001 | 2020-07-09 04:34:23 | Assam, India | ||
2020-07-09 | India | Assam | 14032 | 22 | 8726 | 5284 | 26.357149 | 92.83044100000001 | 2020-07-10 04:34:24 | Assam, India | ||
2020-07-10 | India | Assam | 14600 | 27 | 9147 | 5426 | 26.357149 | 92.83044100000001 | 2020-07-11 04:34:26 | Assam, India | ||
2020-07-11 | India | Assam | 15536 | 35 | 9150 | 6351 | 26.357149 | 92.83044100000001 | 2020-07-12 04:34:30 | Assam, India | ||
2020-07-12 | India | Assam | 16071 | 35 | 10426 | 5610 | 26.357149 | 92.83044100000001 | 2020-07-13 04:43:04 | Assam, India | ||
2020-07-13 | India | Assam | 16806 | 36 | 10894 | 5876 | 26.357149 | 92.83044100000001 | 2020-07-14 04:34:46 | Assam, India | ||
2020-07-14 | India | Assam | 17807 | 40 | 11416 | 6351 | 26.357149 | 92.83044100000001 | 2020-07-15 04:34:39 | Assam, India | ||
2020-07-15 | India | Assam | 18666 | 46 | 12173 | 6447 | 26.357149 | 92.830441 | 2020-07-16 04:44:59 | Assam, India | ||
2020-07-16 | India | Assam | 19754 | 48 | 12888 | 6818 | 26.357149 | 92.830441 | 2020-07-17 04:34:50 | Assam, India | ||
2020-07-17 | India | Assam | 20646 | 51 | 14105 | 6490 | 26.357149 | 92.83044100000001 | 2020-07-18 04:34:45 | Assam, India | ||
2020-07-18 | India | Assam | 22918 | 53 | 15165 | 7700 | 26.357149 | 92.83044100000001 | 2020-07-19 04:34:58 | Assam, India | ||
2020-07-19 | India | Assam | 23999 | 57 | 16023 | 7919 | 26.357149 | 92.83044100000001 | 2020-07-20 05:34:40 | Assam, India | ||
2020-07-20 | India | Assam | 25382 | 58 | 17095 | 8229 | 26.357149 | 92.83044100000001 | 2020-07-21 04:38:46 | Assam, India | ||
2020-07-21 | India | Assam | 25382 | 58 | 18033 | 7291 | 26.357149 | 92.83044100000001 | 2020-07-22 04:34:42 | Assam, India | ||
2020-07-22 | India | Assam | 26772 | 64 | 18033 | 8675 | 26.357149 | 92.830441 | 2020-07-23 05:15:04 | Assam, India | ||
2020-07-23 | India | Assam | 28791 | 70 | 20699 | 8022 | 26.357149 | 92.830441 | 2020-07-24 05:30:40 | Assam, India | ||
2020-07-24 | India | Assam | 29921 | 76 | 21761 | 8084 | 26.357149 | 92.830441 | 2020-07-25 04:47:39 | Assam, India | ||
2020-07-25 | India | Assam | 31086 | 77 | 23055 | 7954 | 26.357149 | 92.830441 | 2020-07-26 04:35:00 | Assam, India | ||
2020-07-26 | India | Assam | 32228 | 79 | 24040 | 8109 | 26.357149 | 92.830441 | 2020-07-27 04:35:02 | Assam, India | ||
2020-07-27 | India | Assam | 33576 | 86 | 25402 | 8088 | 26.357149 | 92.830441 | 2020-07-28 04:58:43 | Assam, India | ||
2020-07-28 | India | Assam | 33576 | 86 | 25402 | 8088 | 26.357149 | 92.830441 | 2020-07-29 04:35:11 | Assam, India | ||
2020-07-29 | India | Assam | 36295 | 92 | 27832 | 8371 | 26.357149 | 92.830441 | 2020-07-30 04:35:05 | Assam, India | ||
2020-07-30 | India | Assam | 38407 | 94 | 29080 | 9233 | 26.357149 | 92.830441 | 2020-07-31 04:35:18 | Assam, India | ||
2020-07-31 | India | Assam | 40269 | 98 | 30357 | 9814 | 26.357149 | 92.830441 | 2020-08-01 04:36:27 | Assam, India | ||
2020-08-01 | India | Assam | 41726 | 101 | 31442 | 10183 | 26.357149 | 92.830441 | 2020-08-02 04:34:47 | Assam, India | ||
2020-08-02 | India | Assam | 42904 | 105 | 32384 | 10415 | 26.357149 | 92.830441 | 2020-08-03 04:34:35 | Assam, India | ||
2020-08-03 | India | Assam | 45275 | 109 | 33428 | 11738 | 26.357149 | 92.830441 | 2020-08-04 04:41:59 | Assam, India | ||
2020-08-04 | India | Assam | 48161 | 115 | 34421 | 13625 | 26.357149 | 92.830441 | 2020-08-05 04:34:43 | Assam, India | ||
2020-08-05 | India | Assam | 50445 | 121 | 35892 | 14432 | 26.357149 | 92.830441 | 2020-08-06 04:35:02 | Assam, India | ||
2020-08-06 | India | Assam | 52817 | 126 | 37224 | 15467 | 26.357149 | 92.830441 | 2020-08-07 04:35:11 | Assam, India | ||
2020-08-07 | India | Assam | 55496 | 132 | 38809 | 16555 | 26.357149 | 92.830441 | 2020-08-08 04:34:53 | Assam, India | ||
2020-08-08 | India | Assam | 57714 | 140 | 40591 | 16983 | 26.357149 | 92.830441 | 2020-08-09 04:34:54 | Assam, India | ||
2020-08-09 | India | Assam | 58837 | 145 | 42325 | 16367 | 26.357149 | 92.830441 | 2020-08-10 04:34:55 | Assam, India | ||
2020-08-10 | India | Assam | 61737 | 151 | 43586 | 18000 | 26.357149 | 92.830441 | 2020-08-11 04:35:08 | Assam, India | ||
2020-08-11 | India | Assam | 64406 | 155 | 45073 | 19178 | 26.357149 | 92.830441 | 2020-08-12 04:27:29 | Assam, India | ||
2020-08-12 | India | Assam | 68999 | 161 | 47209 | 21629 | 26.357149 | 92.830441 | 2020-08-13 04:29:15 | Assam, India | ||
2020-08-13 | India | Assam | 71795 | 169 | 49383 | 22243 | 26.357149 | 92.830441 | 2020-08-14 04:51:19 | Assam, India | ||
2020-08-14 | India | Assam | 74501 | 175 | 51693 | 22633 | 26.357149 | 92.830441 | 2020-08-15 04:27:31 | Assam, India | ||
2020-08-15 | India | Assam | 75558 | 182 | 53286 | 22090 | 26.357149 | 92.830441 | 2020-08-16 04:27:42 | Assam, India | ||
2020-08-16 | India | Assam | 76875 | 189 | 55215 | 21471 | 26.357149 | 92.830441 | 2020-08-17 04:27:20 | Assam, India | ||
2020-08-17 | India | Assam | 79667 | 197 | 56734 | 22736 | 26.357149 | 92.830441 | 2020-08-18 04:27:56 | Assam, India | ||
2020-08-18 | India | Assam | 82201 | 203 | 58294 | 23704 | 26.357149 | 92.830441 | 2020-08-19 04:27:00 | Assam, India | ||
2020-08-19 | India | Assam | 84317 | 213 | 60348 | 23756 | 26.357149 | 92.830441 | 2020-08-20 04:27:43 | Assam, India | ||
2020-08-20 | India | Assam | 86052 | 221 | 63120 | 22711 | 26.357149 | 92.830441 | 2020-08-21 04:27:41 | Assam, India | ||
2020-08-21 | India | Assam | 87908 | 227 | 65596 | 22085 | 26.357149 | 92.830441 | 2020-08-22 04:27:49 | Assam, India | ||
2020-08-22 | India | Assam | 89468 | 234 | 67641 | 21593 | 26.357149 | 92.830441 | 2020-08-23 04:27:48 | Assam, India | ||
2020-08-23 | India | Assam | 90740 | 242 | 70900 | 19598 | 26.357149 | 92.830441 | 2020-08-24 04:27:56 | Assam, India | ||
2020-08-24 | India | Assam | 92619 | 252 | 73090 | 19277 | 26.357149 | 92.830441 | 2020-08-25 04:28:02 | Assam, India | ||
2020-08-25 | India | Assam | 94592 | 260 | 74814 | 19518 | 26.357149 | 92.830441 | 2020-08-26 04:28:11 | Assam, India | ||
2020-08-26 | India | Assam | 96771 | 274 | 76962 | 19535 | 26.357149 | 92.830441 | 2020-08-27 04:28:15 | Assam, India | ||
2020-08-27 | India | Assam | 98807 | 278 | 79307 | 19222 | 26.357149 | 92.830441 | 2020-08-28 04:28:11 | Assam, India | ||
2020-08-28 | India | Assam | 101367 | 286 | 81070 | 20011 | 26.357149 | 92.830441 | 2020-08-29 04:28:19 | Assam, India | ||
2020-08-29 | India | Assam | 103794 | 289 | 82510 | 20995 | 26.357149 | 92.830441 | 2020-08-30 04:28:22 | Assam, India | ||
2020-08-30 | India | Assam | 105774 | 296 | 83927 | 21551 | 26.357149 | 92.830441 | 2020-08-31 04:28:27 | Assam, India | ||
2020-08-31 | India | Assam | 109040 | 306 | 85461 | 23273 | 26.357149 | 92.830441 | 2020-09-01 04:28:31 | Assam, India | ||
2020-09-01 | India | Assam | 111724 | 315 | 86895 | 24514 | 26.357149 | 92.830441 | 2020-09-02 04:28:25 | Assam, India | ||
2020-09-02 | India | Assam | 115279 | 323 | 88729 | 26227 | 26.357149 | 92.830441 | 2020-09-03 04:28:22 | Assam, India | ||
2020-09-03 | India | Assam | 118333 | 330 | 90700 | 27303 | 26.357149 | 92.830441 | 2020-09-04 04:28:26 | Assam, India | ||
2020-09-04 | India | Assam | 121224 | 345 | 92720 | 28159 | 26.357149 | 92.830441 | 2020-09-05 04:28:19 | Assam, India | ||
2020-09-05 | India | Assam | 123922 | 352 | 95063 | 28507 | 26.357149 | 92.830441 | 2020-09-06 04:28:33 | Assam, India | ||
2020-09-06 | India | Assam | 125459 | 360 | 96826 | 28273 | 26.357149 | 92.830441 | 2020-09-07 04:28:30 | Assam, India | ||
2020-09-07 | India | Assam | 128244 | 370 | 99076 | 28798 | 26.357149 | 92.830441 | 2020-09-08 04:28:25 | Assam, India | ||
2020-09-08 | India | Assam | 130823 | 378 | 101239 | 29206 | 26.357149 | 92.830441 | 2020-09-09 04:28:48 | Assam, India | ||
2020-09-09 | India | Assam | 133066 | 396 | 103504 | 29166 | 26.357149 | 92.830441 | 2020-09-10 04:29:01 | Assam, India | ||
2020-09-10 | India | Assam | 135805 | 414 | 105701 | 29690 | 26.357149 | 92.830441 | 2020-09-11 04:46:23 | Assam, India | ||
2020-09-11 | India | Assam | 138339 | 430 | 108329 | 29580 | 26.357149 | 92.830441 | 2020-09-12 04:25:05 | Assam, India | ||
2020-09-12 | India | Assam | 140471 | 453 | 110885 | 29133 | 26.357149 | 92.830441 | 2020-09-13 04:30:52 | Assam, India | ||
2020-09-13 | India | Assam | 141763 | 469 | 113133 | 28161 | 26.357149 | 92.830441 | 2020-09-14 04:26:00 | Assam, India | ||
2020-09-14 | India | Assam | 141763 | 469 | 113133 | 28161 | 26.357149 | 92.830441 | 2020-09-15 03:22:50 | Assam, India | ||
2020-09-15 | India | Assam | 146575 | 492 | 116903 | 29180 | 26.357149 | 92.830441 | 2020-09-16 04:22:53 | Assam, India | ||
2020-09-16 | India | Assam | 148969 | 511 | 119367 | 29091 | 26.357149 | 92.830441 | 2020-09-17 04:22:00 | Assam, India | ||
2020-09-17 | India | Assam | 150349 | 528 | 121613 | 28208 | 26.357149 | 92.830441 | 2020-09-18 05:05:00 | Assam, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;