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 = "Himachal Pradesh" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190017 | 190017 | 2021-01-11 | India | Himachal Pradesh | 56521 | 961 | 54686 | 874 | 31.927213 | 77.233081 | 2021-01-12 05:22:15 | Himachal Pradesh, India | ||
2625820 | 2625820 | 2021-01-10 | India | Himachal Pradesh | 56452 | 959 | 54522 | 971 | 31.927213 | 77.233081 | 2021-01-11 05:21:50 | Himachal Pradesh, India | ||
3899908 | 3899908 | 2021-01-09 | India | Himachal Pradesh | 56366 | 958 | 54320 | 1088 | 31.927213 | 77.233081 | 2021-01-10 05:22:12 | Himachal Pradesh, India | ||
153931 | 153931 | 2021-01-08 | India | Himachal Pradesh | 56146 | 953 | 53973 | 1220 | 31.927213 | 77.233081 | 2021-01-09 05:22:18 | Himachal Pradesh, India | ||
2541355 | 2541355 | 2021-01-07 | India | Himachal Pradesh | 56146 | 953 | 53973 | 1220 | 31.927213 | 77.233081 | 2021-01-08 05:22:42 | Himachal Pradesh, India | ||
2864664 | 2864664 | 2021-01-06 | India | Himachal Pradesh | 56015 | 952 | 53782 | 1281 | 31.927213 | 77.233081 | 2021-01-07 05:22:03 | Himachal Pradesh, India | ||
3034251 | 3034251 | 2021-01-05 | India | Himachal Pradesh | 55910 | 948 | 53523 | 1439 | 31.927213 | 77.233081 | 2021-01-06 05:22:16 | Himachal Pradesh, India | ||
1061796 | 1061796 | 2021-01-04 | India | Himachal Pradesh | 55808 | 946 | 53216 | 1646 | 31.927213 | 77.233081 | 2021-01-05 05:21:49 | Himachal Pradesh, India | ||
3230399 | 3230399 | 2021-01-03 | India | Himachal Pradesh | 55686 | 944 | 52912 | 1830 | 31.927213 | 77.233081 | 2021-01-04 05:22:02 | Himachal Pradesh, India | ||
2227468 | 2227468 | 2021-01-02 | India | Himachal Pradesh | 55619 | 938 | 52479 | 2202 | 31.927213 | 77.233081 | 2021-01-03 05:22:52 | Himachal Pradesh, India | ||
1136832 | 1136832 | 2021-01-01 | India | Himachal Pradesh | 55470 | 936 | 51728 | 2806 | 31.927213 | 77.233081 | 2021-01-02 05:22:33 | Himachal Pradesh, India | ||
3695438 | 3695438 | 2020-12-31 | India | Himachal Pradesh | 55114 | 931 | 51387 | 2796 | 31.927213 | 77.233081 | 2021-01-01 05:23:07 | Himachal Pradesh, India | ||
1010253 | 1010253 | 2020-12-30 | India | Himachal Pradesh | 55114 | 931 | 51387 | 2796 | 31.927213 | 77.233081 | 2020-12-31 05:22:49 | Himachal Pradesh, India | ||
766268 | 766268 | 2020-12-29 | India | Himachal Pradesh | 54894 | 925 | 50631 | 3338 | 31.927213 | 77.233081 | 2020-12-30 05:22:34 | Himachal Pradesh, India | ||
3761532 | 3761532 | 2020-12-28 | India | Himachal Pradesh | 54680 | 921 | 50079 | 3680 | 31.927213 | 77.233081 | 2020-12-29 05:22:37 | Himachal Pradesh, India | ||
3777852 | 3777852 | 2020-12-27 | India | Himachal Pradesh | 54438 | 919 | 49685 | 3834 | 31.927213 | 77.233081 | 2020-12-28 05:22:06 | Himachal Pradesh, India | ||
2223457 | 2223457 | 2020-12-26 | India | Himachal Pradesh | 54280 | 913 | 49076 | 4291 | 31.927213 | 77.233081 | 2020-12-27 05:22:55 | Himachal Pradesh, India | ||
202204 | 202204 | 2020-12-25 | India | Himachal Pradesh | 54058 | 902 | 48809 | 4347 | 31.927213 | 77.233081 | 2020-12-26 05:22:28 | Himachal Pradesh, India | ||
3691427 | 3691427 | 2020-12-24 | India | Himachal Pradesh | 53766 | 899 | 48186 | 4681 | 31.927213 | 77.233081 | 2020-12-25 05:22:48 | Himachal Pradesh, India | ||
2406779 | 2406779 | 2020-12-23 | India | Himachal Pradesh | 53392 | 894 | 47869 | 4629 | 31.927213 | 77.233081 | 2020-12-24 05:23:04 | Himachal Pradesh, India | ||
3769825 | 3769825 | 2020-12-22 | India | Himachal Pradesh | 52955 | 889 | 47275 | 4791 | 31.927213 | 77.233081 | 2020-12-23 05:22:03 | Himachal Pradesh, India | ||
927641 | 927641 | 2020-12-21 | India | Himachal Pradesh | 52623 | 885 | 46852 | 4886 | 31.927213 | 77.233081 | 2020-12-22 05:22:33 | Himachal Pradesh, India | ||
2119662 | 2119662 | 2020-12-20 | India | Himachal Pradesh | 52329 | 876 | 46257 | 5196 | 31.927213 | 77.233081 | 2020-12-21 05:27:58 | Himachal Pradesh, India | ||
2931169 | 2931169 | 2020-12-19 | India | Himachal Pradesh | 52010 | 870 | 45174 | 5966 | 31.927213 | 77.233081 | 2020-12-20 05:27:32 | Himachal Pradesh, India | ||
1901115 | 1901115 | 2020-12-18 | India | Himachal Pradesh | 51625 | 867 | 44784 | 5974 | 31.927213 | 77.233081 | 2020-12-19 05:27:52 | Himachal Pradesh, India | ||
2127941 | 2127941 | 2020-12-17 | India | Himachal Pradesh | 51143 | 858 | 44146 | 6139 | 31.927213 | 77.233081 | 2020-12-18 05:28:18 | Himachal Pradesh, India | ||
3149541 | 3149541 | 2020-12-16 | India | Himachal Pradesh | 50680 | 848 | 43614 | 6218 | 31.927213 | 77.233081 | 2020-12-17 05:28:12 | Himachal Pradesh, India | ||
1034322 | 1034322 | 2020-12-15 | India | Himachal Pradesh | 50196 | 836 | 42568 | 6792 | 31.927213 | 77.233081 | 2020-12-16 05:28:04 | Himachal Pradesh, India | ||
1751216 | 1751216 | 2020-12-14 | India | Himachal Pradesh | 49761 | 823 | 41990 | 6948 | 31.927213 | 77.233081 | 2020-12-15 05:26:38 | Himachal Pradesh, India | ||
3847736 | 3847736 | 2020-12-13 | India | Himachal Pradesh | 49375 | 811 | 41313 | 7251 | 31.927213 | 77.233081 | 2020-12-14 05:26:27 | Himachal Pradesh, India | ||
845518 | 845518 | 2020-12-12 | India | Himachal Pradesh | 48951 | 803 | 40573 | 7575 | 31.927213 | 77.233081 | 2020-12-13 05:27:20 | Himachal Pradesh, India | ||
860625 | 860625 | 2020-12-11 | India | Himachal Pradesh | 48354 | 793 | 39836 | 7725 | 31.927213 | 77.233081 | 2020-12-12 05:26:19 | Himachal Pradesh, India | ||
1600167 | 1600167 | 2020-12-10 | India | Himachal Pradesh | 47703 | 773 | 39065 | 7865 | 31.927213 | 77.233081 | 2020-12-11 05:26:59 | Himachal Pradesh, India | ||
2975176 | 2975176 | 2020-12-09 | India | Himachal Pradesh | 46930 | 765 | 38690 | 7475 | 31.927213 | 77.233081 | 2020-12-10 05:26:19 | Himachal Pradesh, India | ||
1818736 | 1818736 | 2020-12-08 | India | Himachal Pradesh | 46201 | 753 | 37871 | 7577 | 31.927213 | 77.233081 | 2020-12-09 05:28:01 | Himachal Pradesh, India | ||
2347372 | 2347372 | 2020-12-07 | India | Himachal Pradesh | 45697 | 739 | 37063 | 7895 | 31.927213 | 77.233081 | 2020-12-08 05:27:42 | Himachal Pradesh, India | ||
1006242 | 1006242 | 2020-12-06 | India | Himachal Pradesh | 44958 | 732 | 35957 | 8269 | 31.927213 | 77.233081 | 2020-12-07 05:26:14 | Himachal Pradesh, India | ||
1632251 | 1632251 | 2020-12-05 | India | Himachal Pradesh | 44405 | 721 | 35437 | 8247 | 31.927213 | 77.233081 | 2020-12-06 05:26:18 | Himachal Pradesh, India | ||
3859779 | 3859779 | 2020-12-04 | India | Himachal Pradesh | 43500 | 708 | 34492 | 8300 | 31.927213 | 77.233081 | 2020-12-05 05:27:36 | Himachal Pradesh, India | ||
75037 | 75037 | 2020-12-03 | India | Himachal Pradesh | 42697 | 695 | 33914 | 8088 | 31.927213 | 77.233081 | 2020-12-04 05:27:27 | Himachal Pradesh, India | ||
738249 | 738249 | 2020-12-02 | India | Himachal Pradesh | 41860 | 677 | 33370 | 7813 | 31.927213 | 77.233081 | 2020-12-03 05:28:22 | Himachal Pradesh, India | ||
2537343 | 2537343 | 2020-12-01 | India | Himachal Pradesh | 41227 | 666 | 32343 | 8218 | 31.927213 | 77.233081 | 2020-12-02 05:27:41 | Himachal Pradesh, India | ||
1584112 | 1584112 | 2020-11-30 | India | Himachal Pradesh | 40518 | 645 | 31584 | 8289 | 31.927213 | 77.233081 | 2020-12-01 05:26:18 | Himachal Pradesh, India | ||
3566515 | 3566515 | 2020-11-29 | India | Himachal Pradesh | 40003 | 635 | 30724 | 8644 | 31.927213 | 77.233081 | 2020-11-30 05:26:13 | Himachal Pradesh, India | ||
2935180 | 2935180 | 2020-11-28 | India | Himachal Pradesh | 38977 | 623 | 29780 | 8574 | 31.927213 | 77.233081 | 2020-11-29 05:25:55 | Himachal Pradesh, India | ||
392183 | 392183 | 2020-11-27 | India | Himachal Pradesh | 38327 | 612 | 29510 | 8205 | 31.927213 | 77.233081 | 2020-11-28 05:25:50 | Himachal Pradesh, India | ||
923630 | 923630 | 2020-11-26 | India | Himachal Pradesh | 37497 | 599 | 29020 | 7878 | 31.927213 | 77.233081 | 2020-11-27 05:26:53 | Himachal Pradesh, India | ||
1972535 | 1972535 | 2020-11-25 | India | Himachal Pradesh | 36566 | 585 | 28106 | 7875 | 31.927213 | 77.233081 | 2020-11-26 05:27:44 | Himachal Pradesh, India | ||
1350266 | 1350266 | 2020-11-24 | India | Himachal Pradesh | 35729 | 572 | 28007 | 7150 | 31.927213 | 77.233081 | 2020-11-25 05:27:20 | Himachal Pradesh, India | ||
678260 | 678260 | 2020-11-23 | India | Himachal Pradesh | 34781 | 560 | 27541 | 6680 | 31.927213 | 77.233081 | 2020-11-24 05:27:31 | Himachal Pradesh, India | ||
3189936 | 3189936 | 2020-11-22 | India | Himachal Pradesh | 34327 | 537 | 26756 | 7034 | 31.927213 | 77.233081 | 2020-11-23 05:25:26 | Himachal Pradesh, India | ||
3836430 | 3836430 | 2020-11-21 | India | Himachal Pradesh | 33700 | 518 | 26112 | 7070 | 31.927213 | 77.233081 | 2020-11-22 05:25:45 | Himachal Pradesh, India | ||
2701458 | 2701458 | 2020-11-20 | India | Himachal Pradesh | 32785 | 500 | 25455 | 6830 | 31.927213 | 77.233081 | 2020-11-21 05:25:51 | Himachal Pradesh, India | ||
821518 | 821518 | 2020-11-19 | India | Himachal Pradesh | 32197 | 488 | 24729 | 6980 | 31.927213 | 77.233081 | 2020-11-20 05:26:28 | Himachal Pradesh, India | ||
122652 | 122652 | 2020-11-18 | India | Himachal Pradesh | 31401 | 475 | 24025 | 6901 | 31.927213 | 77.233081 | 2020-11-19 05:25:23 | Himachal Pradesh, India | ||
3338540 | 3338540 | 2020-11-17 | India | Himachal Pradesh | 30740 | 462 | 23506 | 6772 | 31.927213 | 77.233081 | 2020-11-18 05:40:31 | Himachal Pradesh, India | ||
3169585 | 3169585 | 2020-11-16 | India | Himachal Pradesh | 30156 | 450 | 22931 | 6775 | 31.927213 | 77.233081 | 2020-11-17 05:25:54 | Himachal Pradesh, India | ||
2880153 | 2880153 | 2020-11-15 | India | Himachal Pradesh | 29713 | 442 | 22392 | 6879 | 31.927213 | 77.233081 | 2020-11-16 05:25:57 | Himachal Pradesh, India | ||
2915131 | 2915131 | 2020-11-14 | India | Himachal Pradesh | 29330 | 431 | 22183 | 6716 | 31.927213 | 77.233081 | 2020-11-15 05:26:53 | Himachal Pradesh, India | ||
2784953 | 2784953 | 2020-11-13 | India | Himachal Pradesh | 29008 | 423 | 21846 | 6739 | 31.927213 | 77.233081 | 2020-11-14 05:25:37 | Himachal Pradesh, India | ||
864718 | 864718 | 2020-11-12 | India | Himachal Pradesh | 28183 | 411 | 21607 | 6165 | 31.927213 | 77.233081 | 2020-11-13 05:25:30 | Himachal Pradesh, India | ||
3440763 | 3440763 | 2020-11-11 | India | Himachal Pradesh | 27418 | 405 | 21408 | 5605 | 31.927213 | 77.233081 | 2020-11-12 05:25:55 | Himachal Pradesh, India | ||
272103 | 272103 | 2020-11-10 | India | Himachal Pradesh | 26808 | 396 | 21047 | 5365 | 31.927213 | 77.233081 | 2020-11-11 05:25:30 | Himachal Pradesh, India | ||
1988580 | 1988580 | 2020-11-09 | India | Himachal Pradesh | 26197 | 384 | 20621 | 5192 | 31.927213 | 77.233081 | 2020-11-10 05:40:07 | Himachal Pradesh, India | ||
1728432 | 1728432 | 2020-11-08 | India | Himachal Pradesh | 25486 | 377 | 20393 | 4716 | 31.927213 | 77.233081 | 2020-11-09 05:25:45 | Himachal Pradesh, India | ||
1543892 | 1543892 | 2020-11-07 | India | Himachal Pradesh | 24812 | 371 | 20243 | 4198 | 31.927213 | 77.233081 | 2020-11-08 05:24:56 | Himachal Pradesh, India | ||
376130 | 376130 | 2020-11-06 | India | Himachal Pradesh | 24239 | 361 | 20033 | 3845 | 31.927213 | 77.233081 | 2020-11-07 05:24:52 | Himachal Pradesh, India | ||
892068 | 892068 | 2020-11-05 | India | Himachal Pradesh | 23809 | 361 | 19780 | 3668 | 31.927213 | 77.233081 | 2020-11-06 05:24:55 | Himachal Pradesh, India | ||
2919130 | 2919130 | 2020-11-04 | India | Himachal Pradesh | 23365 | 355 | 19579 | 3431 | 31.927213 | 77.233081 | 2020-11-05 06:05:03 | Himachal Pradesh, India | ||
2497967 | 2497967 | 2020-11-03 | India | Himachal Pradesh | 22932 | 344 | 19469 | 3119 | 31.927213 | 77.233081 | 2020-11-04 05:25:09 | Himachal Pradesh, India | ||
3304142 | 3304142 | 2020-11-02 | India | Himachal Pradesh | 22598 | 336 | 19304 | 2958 | 31.927213 | 77.233081 | 2020-11-03 06:00:16 | Himachal Pradesh, India | ||
3409391 | 3409391 | 2020-11-01 | India | Himachal Pradesh | 22264 | 326 | 18965 | 2973 | 31.927213 | 77.233081 | 2020-11-02 05:25:04 | Himachal Pradesh, India | ||
2079880 | 2079880 | 2020-10-31 | India | Himachal Pradesh | 22059 | 317 | 18862 | 2880 | 31.927213 | 77.233081 | 2020-11-01 04:36:19 | Himachal Pradesh, India | ||
2243333 | 2243333 | 2020-10-30 | India | Himachal Pradesh | 21798 | 312 | 18595 | 2891 | 31.927213 | 77.233081 | 2020-10-31 04:24:44 | Himachal Pradesh, India | ||
210188 | 210188 | 2020-10-29 | India | Himachal Pradesh | 21476 | 306 | 18402 | 2768 | 31.927213 | 77.233081 | 2020-10-30 04:24:49 | Himachal Pradesh, India | ||
754250 | 754250 | 2020-10-28 | India | Himachal Pradesh | 21149 | 300 | 18203 | 2646 | 31.927213 | 77.233081 | 2020-10-29 04:24:49 | Himachal Pradesh, India | ||
1452535 | 1452535 | 2020-10-27 | India | Himachal Pradesh | 20817 | 298 | 17998 | 2521 | 31.927213 | 77.233081 | 2020-10-28 04:24:39 | Himachal Pradesh, India | ||
3480259 | 3480259 | 2020-10-26 | India | Himachal Pradesh | 20586 | 293 | 17782 | 2511 | 31.927213 | 77.233081 | 2020-10-27 04:24:45 | Himachal Pradesh, India | ||
8280 | 8280 | 2020-10-25 | India | Himachal Pradesh | 20370 | 291 | 17590 | 2489 | 31.927213 | 77.233081 | 2020-10-26 04:25:02 | Himachal Pradesh, India | ||
3651517 | 3651517 | 2020-10-24 | India | Himachal Pradesh | 20213 | 290 | 17318 | 2605 | 31.927213 | 77.233081 | 2020-10-25 04:24:36 | Himachal Pradesh, India | ||
1053772 | 1053772 | 2020-10-23 | India | Himachal Pradesh | 20040 | 285 | 17135 | 2620 | 31.927213 | 77.233081 | 2020-10-24 04:24:46 | Himachal Pradesh, India | ||
1177442 | 1177442 | 2020-10-22 | India | Himachal Pradesh | 19844 | 284 | 16937 | 2623 | 31.927213 | 77.233081 | 2020-10-23 04:24:46 | Himachal Pradesh, India | ||
2191547 | 2191547 | 2020-10-21 | India | Himachal Pradesh | 19621 | 279 | 16706 | 2636 | 31.927213 | 77.233081 | 2020-10-22 04:24:27 | Himachal Pradesh, India | ||
3990558 | 3990558 | 2020-10-20 | India | Himachal Pradesh | 19357 | 274 | 16487 | 2596 | 31.927213 | 77.233081 | 2020-10-21 04:24:14 | Himachal Pradesh, India | ||
1794578 | 1794578 | 2020-10-19 | India | Himachal Pradesh | 19135 | 272 | 16270 | 2593 | 31.927213 | 77.233081 | 2020-10-20 04:24:22 | Himachal Pradesh, India | ||
762262 | 762262 | 2020-10-18 | India | Himachal Pradesh | 18967 | 268 | 16069 | 2630 | 31.927213 | 77.233081 | 2020-10-19 04:24:16 | Himachal Pradesh, India | ||
1026300 | 1026300 | 2020-10-17 | India | Himachal Pradesh | 18797 | 265 | 15852 | 2680 | 31.927213 | 77.233081 | 2020-10-18 04:24:25 | Himachal Pradesh, India | ||
2856795 | 2856795 | 2020-10-16 | India | Himachal Pradesh | 18522 | 262 | 15618 | 2642 | 31.927213 | 77.233081 | 2020-10-17 04:24:12 | Himachal Pradesh, India | ||
786325 | 786325 | 2020-10-15 | India | Himachal Pradesh | 18303 | 260 | 15389 | 2654 | 31.927213 | 77.233081 | 2020-10-16 04:24:01 | Himachal Pradesh, India | ||
79036 | 79036 | 2020-10-14 | India | Himachal Pradesh | 18008 | 255 | 15233 | 2520 | 31.927213 | 77.233081 | 2020-10-15 04:24:28 | Himachal Pradesh, India | ||
3781851 | 3781851 | 2020-10-13 | India | Himachal Pradesh | 17762 | 254 | 15001 | 2507 | 31.927213 | 77.233081 | 2020-10-14 04:24:05 | Himachal Pradesh, India | ||
2291391 | 2291391 | 2020-10-12 | India | Himachal Pradesh | 17578 | 251 | 14690 | 2637 | 31.927213 | 77.233081 | 2020-10-13 04:24:02 | Himachal Pradesh, India | ||
3785844 | 3785844 | 2020-10-11 | India | Himachal Pradesh | 17408 | 250 | 14471 | 2687 | 31.927213 | 77.233081 | 2020-10-12 04:23:45 | Himachal Pradesh, India | ||
2601982 | 2601982 | 2020-10-10 | India | Himachal Pradesh | 17244 | 248 | 14278 | 2718 | 31.927213 | 77.233081 | 2020-10-11 04:23:46 | Himachal Pradesh, India | ||
817515 | 817515 | 2020-10-09 | India | Himachal Pradesh | 16977 | 245 | 13876 | 2856 | 31.927213 | 77.233081 | 2020-10-10 04:23:57 | Himachal Pradesh, India | ||
2689630 | 2689630 | 2020-10-08 | India | Himachal Pradesh | 16778 | 238 | 13597 | 2943 | 31.927213 | 77.233081 | 2020-10-09 04:23:59 | Himachal Pradesh, India | ||
1041772 | 1041772 | 2020-10-07 | India | Himachal Pradesh | 16565 | 231 | 13338 | 2996 | 31.927213 | 77.233081 | 2020-10-08 04:23:56 | Himachal Pradesh, India | ||
3117433 | 3117433 | 2020-10-06 | India | Himachal Pradesh | 16283 | 229 | 12918 | 3136 | 31.927213 | 77.233081 | 2020-10-07 04:23:40 | Himachal Pradesh, India | ||
3801845 | 3801845 | 2020-10-05 | India | Himachal Pradesh | 16033 | 224 | 12653 | 3156 | 31.927213 | 77.233081 | 2020-10-06 04:23:33 | Himachal Pradesh, India | ||
1822735 | 1822735 | 2020-10-04 | India | Himachal Pradesh | 15851 | 217 | 12361 | 3273 | 31.927213 | 77.233081 | 2020-10-05 04:23:33 | Himachal Pradesh, 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]);