daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where province_or_state = "Assam" sorted by admin2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-03 | India | Assam | 746076 | 8035 | 0 | 26.357149 | 92.830441 | 2022-11-04 04:22:11 | Assam, India | |||
2021-01-21 | India | Assam | 216940 | 1077 | 213295 | 2568 | 26.357149 | 92.830441 | 2021-01-22 05:22:10 | Assam, India | ||
2020-07-26 | India | Assam | 32228 | 79 | 24040 | 8109 | 26.357149 | 92.830441 | 2020-07-27 04:35:02 | Assam, India | ||
2021-10-20 | India | Assam | 607427 | 5958 | 0 | 26.357149 | 92.83044100000001 | 2021-10-21 04:21:18 | Assam, India | |||
2021-11-17 | India | Assam | 614663 | 6061 | 0 | 26.357149 | 92.83044100000001 | 2021-11-18 04:21:33 | Assam, India | |||
2022-12-21 | India | Assam | 746100 | 8035 | 0 | 26.357149 | 92.830441 | 2022-12-22 04:20:56 | Assam, India | |||
2020-08-07 | India | Assam | 55496 | 132 | 38809 | 16555 | 26.357149 | 92.830441 | 2020-08-08 04:34:53 | Assam, India | ||
2022-02-02 | India | Assam | 718920 | 6499 | 0 | 26.357149 | 92.83044100000001 | 2022-02-03 04:21:21 | Assam, India | |||
2022-05-02 | India | Assam | 724213 | 7986 | 0 | 26.357149 | 92.830441 | 2022-05-03 04:21:00 | Assam, India | |||
2021-10-07 | India | Assam | 604218 | 5911 | 0 | 26.357149 | 92.83044100000001 | 2021-10-08 04:21:25 | Assam, India | |||
2021-02-19 | India | Assam | 217367 | 1091 | 214658 | 1618 | 26.357149 | 92.830441 | 2021-02-20 05:22:51 | Assam, India | ||
2022-06-26 | India | Assam | 724587 | 7988 | 0 | 26.357149 | 92.830441 | 2022-06-27 04:21:00 | Assam, India | |||
2022-11-08 | India | Assam | 746079 | 8035 | 0 | 26.357149 | 92.830441 | 2022-11-09 04:21:22 | Assam, India | |||
2021-07-19 | India | Assam | 549080 | 5019 | 526607 | 17454 | 26.357149 | 92.830441 | 2021-07-20 04:21:48 | Assam, India | ||
2022-11-25 | India | Assam | 746099 | 8035 | 0 | 26.357149 | 92.830441 | 2022-11-26 04:21:11 | Assam, India | |||
2021-10-14 | India | Assam | 605847 | 5938 | 0 | 26.357149 | 92.83044100000001 | 2021-10-15 04:21:26 | Assam, India | |||
2021-11-06 | India | Assam | 612134 | 6026 | 0 | 26.357149 | 92.83044100000001 | 2021-11-07 04:21:53 | Assam, India | |||
2022-04-02 | India | Assam | 724196 | 6639 | 0 | 26.357149 | 92.83044100000001 | 2022-04-03 04:20:48 | Assam, India | |||
2022-12-17 | India | Assam | 746100 | 8035 | 0 | 26.357149 | 92.830441 | 2022-12-18 04:21:03 | Assam, India | |||
2021-08-14 | India | Assam | 579488 | 5482 | 0 | 26.357149 | 92.83044100000001 | 2021-08-15 04:21:41 | Assam, India | |||
2021-08-19 | India | Assam | 582750 | 5538 | 0 | 26.357149 | 92.83044100000001 | 2021-08-20 04:21:33 | Assam, India | |||
2022-10-15 | India | Assam | 745898 | 8035 | 0 | 26.357149 | 92.830441 | 2022-10-16 04:22:39 | Assam, India | |||
2021-06-09 | India | Assam | 446445 | 3793 | 392806 | 49846 | 26.357149 | 92.830441 | 2021-06-10 04:23:17 | Assam, India | ||
2020-07-04 | India | Assam | 10668 | 14 | 6657 | 3997 | 26.357149 | 92.83044100000001 | 2020-07-05 04:33:46 | Assam, India | ||
2021-02-22 | India | Assam | 217406 | 1091 | 214712 | 1603 | 26.357149 | 92.830441 | 2021-02-23 05:23:41 | Assam, India | ||
2021-10-27 | India | Assam | 609506 | 5987 | 0 | 26.357149 | 92.83044100000001 | 2021-10-28 04:22:08 | Assam, India | |||
2022-10-26 | India | Assam | 746010 | 8035 | 0 | 26.357149 | 92.830441 | 2022-10-27 04:22:01 | Assam, India | |||
2022-12-15 | India | Assam | 746100 | 8035 | 0 | 26.357149 | 92.830441 | 2022-12-16 04:21:01 | Assam, India | |||
2020-09-12 | India | Assam | 140471 | 453 | 110885 | 29133 | 26.357149 | 92.830441 | 2020-09-13 04:30:52 | Assam, India | ||
2021-12-08 | India | Assam | 618042 | 6127 | 0 | 26.357149 | 92.83044100000001 | 2021-12-09 04:22:49 | Assam, India | |||
2022-01-16 | India | Assam | 646735 | 6206 | 0 | 26.357149 | 92.83044100000001 | 2022-01-17 04:21:08 | Assam, India | |||
2022-06-16 | India | Assam | 724303 | 7988 | 0 | 26.357149 | 92.830441 | 2022-06-17 04:20:56 | Assam, India | |||
2021-06-22 | India | Assam | 488179 | 4280 | 450924 | 32975 | 26.357149 | 92.830441 | 2021-06-23 04:21:46 | Assam, India | ||
2021-10-29 | India | Assam | 610150 | 5992 | 0 | 26.357149 | 92.83044100000001 | 2021-10-30 04:22:03 | Assam, India | |||
2022-02-25 | India | Assam | 724088 | 6638 | 0 | 26.357149 | 92.83044100000001 | 2022-02-26 04:21:12 | Assam, India | |||
2021-07-13 | India | Assam | 538407 | 4888 | 511888 | 21631 | 26.357149 | 92.830441 | 2021-07-14 04:21:35 | Assam, India | ||
2020-08-13 | India | Assam | 71795 | 169 | 49383 | 22243 | 26.357149 | 92.830441 | 2020-08-14 04:51:19 | Assam, India | ||
2021-08-08 | India | Assam | 574100 | 5387 | 0 | 26.357149 | 92.830441 | 2021-08-09 04:21:24 | Assam, India | |||
2022-07-01 | India | Assam | 724926 | 7988 | 0 | 26.357149 | 92.830441 | 2022-07-02 04:21:16 | Assam, India | |||
2021-10-19 | India | Assam | 607119 | 5957 | 0 | 26.357149 | 92.83044100000001 | 2021-10-20 04:21:00 | Assam, India | |||
2021-09-23 | India | Assam | 599642 | 5827 | 0 | 26.357149 | 92.83044100000001 | 2021-09-24 04:21:44 | Assam, India | |||
2021-04-09 | India | Assam | 219553 | 1115 | 215828 | 2610 | 26.357149 | 92.830441 | 2021-04-10 04:20:59 | Assam, India | ||
2020-08-29 | India | Assam | 103794 | 289 | 82510 | 20995 | 26.357149 | 92.830441 | 2020-08-30 04:28:22 | Assam, India | ||
2021-02-08 | India | Assam | 217229 | 1085 | 214473 | 1671 | 26.357149 | 92.830441 | 2021-02-09 05:23:30 | Assam, India | ||
2022-11-05 | India | Assam | 746079 | 8035 | 0 | 26.357149 | 92.830441 | 2022-11-06 04:21:24 | Assam, India | |||
2022-05-22 | India | Assam | 724225 | 7986 | 0 | 26.357149 | 92.830441 | 2022-05-26 04:20:50 | Assam, India | |||
2021-07-10 | India | Assam | 532084 | 4812 | 504723 | 22549 | 26.357149 | 92.830441 | 2021-07-11 04:21:43 | Assam, India | ||
2022-07-12 | India | Assam | 727319 | 7991 | 0 | 26.357149 | 92.830441 | 2022-07-13 04:20:58 | Assam, India | |||
2021-10-13 | India | Assam | 605640 | 5936 | 0 | 26.357149 | 92.83044100000001 | 2021-10-14 04:21:29 | Assam, India | |||
2021-03-31 | India | Assam | 218412 | 1105 | 215445 | 1862 | 26.357149 | 92.830441 | 2021-04-01 04:27:05 | Assam, India | ||
2021-09-07 | India | Assam | 593087 | 5719 | 0 | 26.357149 | 92.83044100000001 | 2021-09-08 04:21:31 | Assam, India | |||
2021-05-05 | India | Assam | 272751 | 1485 | 240004 | 31262 | 26.357149 | 92.830441 | 2021-05-06 04:20:38 | Assam, India | ||
2021-08-09 | India | Assam | 575220 | 5404 | 0 | 26.357149 | 92.83044100000001 | 2021-08-10 04:21:27 | Assam, India | |||
2021-10-22 | India | Assam | 608126 | 5964 | 0 | 26.357149 | 92.83044100000001 | 2021-10-23 04:21:32 | Assam, India | |||
2022-05-13 | India | Assam | 724220 | 7986 | 0 | 26.357149 | 92.830441 | 2022-05-14 04:20:48 | Assam, India | |||
2020-08-11 | India | Assam | 64406 | 155 | 45073 | 19178 | 26.357149 | 92.830441 | 2020-08-12 04:27:29 | Assam, India | ||
2020-09-16 | India | Assam | 148969 | 511 | 119367 | 29091 | 26.357149 | 92.830441 | 2020-09-17 04:22:00 | Assam, India | ||
2022-07-21 | India | Assam | 733212 | 8010 | 0 | 26.357149 | 92.830441 | 2022-07-22 04:21:15 | Assam, India | |||
2022-07-30 | India | Assam | 738946 | 8016 | 0 | 26.357149 | 92.830441 | 2022-07-31 04:21:02 | Assam, India | |||
2020-11-23 | India | Assam | 211682 | 975 | 207528 | 3179 | 26.357149 | 92.830441 | 2020-11-24 05:27:31 | Assam, India | ||
2021-10-24 | India | Assam | 608589 | 5973 | 0 | 26.357149 | 92.83044100000001 | 2021-10-25 04:22:31 | Assam, India | |||
2021-11-13 | India | Assam | 613784 | 6047 | 0 | 26.357149 | 92.83044100000001 | 2021-11-14 04:21:31 | Assam, India | |||
2022-12-23 | India | Assam | 746100 | 8035 | 0 | 26.357149 | 92.830441 | 2022-12-24 04:21:02 | Assam, India | |||
2022-03-17 | India | Assam | 724181 | 6639 | 0 | 26.357149 | 92.83044100000001 | 2022-03-18 04:20:55 | Assam, India | |||
2021-11-04 | India | Assam | 611656 | 6019 | 0 | 26.357149 | 92.83044100000001 | 2021-11-05 04:21:54 | Assam, India | |||
2021-03-16 | India | Assam | 217839 | 1099 | 215127 | 1613 | 26.357149 | 92.830441 | 2021-03-17 05:25:07 | Assam, India | ||
2021-09-29 | India | Assam | 601787 | 5868 | 0 | 26.357149 | 92.83044100000001 | 2021-09-30 04:21:20 | Assam, India | |||
2022-11-01 | India | Assam | 746059 | 8035 | 0 | 26.357149 | 92.830441 | 2022-11-02 04:22:09 | Assam, India | |||
2021-11-12 | India | Assam | 613563 | 6043 | 0 | 26.357149 | 92.83044100000001 | 2021-11-13 04:21:38 | Assam, India | |||
2022-12-04 | India | Assam | 746099 | 8035 | 0 | 26.357149 | 92.830441 | 2022-12-05 04:20:58 | Assam, India | |||
2021-11-20 | India | Assam | 615291 | 6071 | 0 | 26.357149 | 92.83044100000001 | 2021-11-21 04:22:13 | Assam, India | |||
2021-05-22 | India | Assam | 365620 | 2667 | 307548 | 55405 | 26.357149 | 92.830441 | 2021-05-23 04:20:51 | Assam, India | ||
2021-12-27 | India | Assam | 620237 | 6158 | 0 | 26.357149 | 92.83044100000001 | 2021-12-28 04:21:47 | Assam, India | |||
2020-06-12 | India | Assam | 3319 | 6 | 1432 | 1881 | 26.357149 | 92.83044100000001 | 2020-06-13 03:33:14 | Assam, India | ||
2020-12-02 | India | Assam | 213171 | 983 | 208669 | 3519 | 26.357149 | 92.830441 | 2020-12-03 05:28:22 | Assam, India | ||
2021-02-20 | India | Assam | 217383 | 1091 | 214676 | 1616 | 26.357149 | 92.830441 | 2021-02-21 05:24:33 | Assam, India | ||
2022-04-23 | India | Assam | 724205 | 6639 | 0 | 26.357149 | 92.83044100000001 | 2022-04-24 04:20:56 | Assam, India | |||
2020-08-01 | India | Assam | 41726 | 101 | 31442 | 10183 | 26.357149 | 92.830441 | 2020-08-02 04:34:47 | Assam, India | ||
2020-10-28 | India | Assam | 205237 | 917 | 192517 | 11803 | 26.357149 | 92.830441 | 2020-10-29 04:24:49 | Assam, India | ||
2021-11-26 | India | Assam | 616312 | 6086 | 0 | 26.357149 | 92.83044100000001 | 2021-11-27 04:22:45 | Assam, India | |||
2020-10-18 | India | Assam | 200709 | 868 | 171683 | 28158 | 26.357149 | 92.830441 | 2020-10-19 04:24:16 | Assam, India | ||
2020-12-29 | India | Assam | 216063 | 1040 | 211723 | 3300 | 26.357149 | 92.830441 | 2020-12-30 05:22:34 | Assam, India | ||
2021-10-23 | India | Assam | 608450 | 5967 | 0 | 26.357149 | 92.83044100000001 | 2021-10-24 04:21:22 | Assam, India | |||
2021-01-12 | India | Assam | 216690 | 1064 | 212632 | 2994 | 26.357149 | 92.830441 | 2021-01-13 05:22:15 | Assam, India | ||
2021-07-08 | India | Assam | 527200 | 4764 | 499388 | 23048 | 26.357149 | 92.830441 | 2021-07-09 04:21:21 | Assam, India | ||
2021-12-13 | India | Assam | 618716 | 6133 | 0 | 26.357149 | 92.83044100000001 | 2021-12-14 04:22:38 | Assam, India | |||
2020-10-15 | India | Assam | 198982 | 843 | 169335 | 28804 | 26.357149 | 92.830441 | 2020-10-16 04:24:01 | Assam, India | ||
2021-02-04 | India | Assam | 217186 | 1084 | 214374 | 1728 | 26.357149 | 92.830441 | 2021-02-05 05:22:38 | Assam, India | ||
2022-10-24 | India | Assam | 746001 | 8035 | 0 | 26.357149 | 92.830441 | 2022-10-25 04:21:53 | Assam, India | |||
2021-12-22 | India | Assam | 619819 | 6152 | 0 | 26.357149 | 92.83044100000001 | 2021-12-23 04:21:21 | Assam, India | |||
2021-09-20 | India | Assam | 598423 | 5807 | 0 | 26.357149 | 92.83044100000001 | 2021-09-21 04:21:26 | Assam, India | |||
2020-09-05 | India | Assam | 123922 | 352 | 95063 | 28507 | 26.357149 | 92.830441 | 2020-09-06 04:28:33 | Assam, India | ||
2020-10-09 | India | Assam | 192416 | 802 | 161904 | 29710 | 26.357149 | 92.830441 | 2020-10-10 04:23:57 | Assam, India | ||
2020-11-19 | India | Assam | 211040 | 969 | 206878 | 3193 | 26.357149 | 92.830441 | 2020-11-20 05:26:28 | Assam, India | ||
2021-06-06 | India | Assam | 434942 | 3658 | 380419 | 50865 | 26.357149 | 92.830441 | 2021-06-07 04:22:51 | Assam, India | ||
2021-07-09 | India | Assam | 529693 | 4788 | 501869 | 23036 | 26.357149 | 92.830441 | 2021-07-10 04:21:25 | Assam, India | ||
2022-12-02 | India | Assam | 746099 | 8035 | 0 | 26.357149 | 92.830441 | 2022-12-03 04:21:02 | Assam, India | |||
2020-08-17 | India | Assam | 79667 | 197 | 56734 | 22736 | 26.357149 | 92.830441 | 2020-08-18 04:27:56 | Assam, India | ||
2020-07-22 | India | Assam | 26772 | 64 | 18033 | 8675 | 26.357149 | 92.830441 | 2020-07-23 05:15:04 | Assam, India | ||
2020-12-12 | India | Assam | 214584 | 1000 | 210057 | 3527 | 26.357149 | 92.830441 | 2020-12-13 05:27:20 | Assam, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;