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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3254095 | 3254095 | 2021-03-02 | India | Himachal Pradesh | 58800 | 996 | 57367 | 437 | 31.927213 | 77.233081 | 2021-03-03 05:23:28 | Himachal Pradesh, India | ||
998387 | 998387 | 2021-03-01 | India | Himachal Pradesh | 58777 | 996 | 57347 | 434 | 31.927213 | 77.233081 | 2021-03-02 05:23:30 | Himachal Pradesh, India | ||
2367445 | 2367445 | 2021-02-28 | India | Himachal Pradesh | 58645 | 995 | 57332 | 318 | 31.927213 | 77.233081 | 2021-03-01 05:23:01 | Himachal Pradesh, India | ||
3065947 | 3065947 | 2021-02-27 | India | Himachal Pradesh | 58598 | 995 | 57311 | 292 | 31.927213 | 77.233081 | 2021-02-28 05:22:20 | Himachal Pradesh, India | ||
2183531 | 2183531 | 2021-02-26 | India | Himachal Pradesh | 58543 | 995 | 57287 | 261 | 31.927213 | 77.233081 | 2021-02-27 05:22:28 | Himachal Pradesh, India | ||
1857953 | 1857953 | 2021-02-25 | India | Himachal Pradesh | 58499 | 995 | 57260 | 244 | 31.927213 | 77.233081 | 2021-02-26 05:22:40 | Himachal Pradesh, India | ||
280131 | 280131 | 2021-02-24 | India | Himachal Pradesh | 58457 | 995 | 57233 | 229 | 31.927213 | 77.233081 | 2021-02-25 05:24:57 | Himachal Pradesh, India | ||
1936399 | 1936399 | 2021-02-23 | India | Himachal Pradesh | 58423 | 995 | 57210 | 218 | 31.927213 | 77.233081 | 2021-02-24 05:29:16 | Himachal Pradesh, India | ||
530654 | 530654 | 2021-02-22 | India | Himachal Pradesh | 58403 | 995 | 57181 | 227 | 31.927213 | 77.233081 | 2021-02-23 05:23:41 | Himachal Pradesh, India | ||
181988 | 181988 | 2021-02-21 | India | Himachal Pradesh | 58385 | 995 | 57156 | 234 | 31.927213 | 77.233081 | 2021-02-22 05:24:21 | Himachal Pradesh, India | ||
742262 | 742262 | 2021-02-20 | India | Himachal Pradesh | 58366 | 994 | 57120 | 252 | 31.927213 | 77.233081 | 2021-02-21 05:24:33 | Himachal Pradesh, India | ||
471360 | 471360 | 2021-02-19 | India | Himachal Pradesh | 58344 | 994 | 57052 | 298 | 31.927213 | 77.233081 | 2021-02-20 05:22:51 | Himachal Pradesh, India | ||
1153069 | 1153069 | 2021-02-18 | India | Himachal Pradesh | 58312 | 994 | 57017 | 301 | 31.927213 | 77.233081 | 2021-02-19 05:24:16 | Himachal Pradesh, India | ||
3600989 | 3600989 | 2021-02-17 | India | Himachal Pradesh | 58296 | 994 | 56948 | 354 | 31.927213 | 77.233081 | 2021-02-18 05:22:58 | Himachal Pradesh, India | ||
3050124 | 3050124 | 2021-02-16 | India | Himachal Pradesh | 58262 | 994 | 56898 | 370 | 31.927213 | 77.233081 | 2021-02-17 05:23:10 | Himachal Pradesh, India | ||
1338223 | 1338223 | 2021-02-15 | India | Himachal Pradesh | 58243 | 994 | 56851 | 398 | 31.927213 | 77.233081 | 2021-02-16 05:24:38 | Himachal Pradesh, India | ||
2283374 | 2283374 | 2021-02-14 | India | Himachal Pradesh | 58222 | 994 | 56817 | 411 | 31.927213 | 77.233081 | 2021-02-15 05:24:49 | Himachal Pradesh, India | ||
2677774 | 2677774 | 2021-02-13 | India | Himachal Pradesh | 58201 | 992 | 56685 | 524 | 31.927213 | 77.233081 | 2021-02-14 05:23:43 | Himachal Pradesh, India | ||
3539407 | 3539407 | 2021-02-12 | India | Himachal Pradesh | 58142 | 990 | 56647 | 505 | 31.927213 | 77.233081 | 2021-02-13 05:22:12 | Himachal Pradesh, India | ||
2637670 | 2637670 | 2021-02-11 | India | Himachal Pradesh | 58112 | 989 | 56630 | 493 | 31.927213 | 77.233081 | 2021-02-12 05:23:29 | Himachal Pradesh, India | ||
3978525 | 3978525 | 2021-02-10 | India | Himachal Pradesh | 58076 | 988 | 56600 | 488 | 31.927213 | 77.233081 | 2021-02-11 05:23:55 | Himachal Pradesh, India | ||
1527845 | 1527845 | 2021-02-09 | India | Himachal Pradesh | 57993 | 987 | 56551 | 455 | 31.927213 | 77.233081 | 2021-02-10 05:22:41 | Himachal Pradesh, India | ||
613636 | 613636 | 2021-02-08 | India | Himachal Pradesh | 57925 | 984 | 56483 | 458 | 31.927213 | 77.233081 | 2021-02-09 05:23:30 | Himachal Pradesh, India | ||
1672405 | 1672405 | 2021-02-07 | India | Himachal Pradesh | 57896 | 984 | 56448 | 464 | 31.927213 | 77.233081 | 2021-02-08 05:22:39 | Himachal Pradesh, India | ||
974866 | 974866 | 2021-02-06 | India | Himachal Pradesh | 57851 | 983 | 56371 | 497 | 31.927213 | 77.233081 | 2021-02-07 05:23:00 | Himachal Pradesh, India | ||
1588124 | 1588124 | 2021-02-05 | India | Himachal Pradesh | 57764 | 982 | 56320 | 462 | 31.927213 | 77.233081 | 2021-02-06 05:23:55 | Himachal Pradesh, India | ||
790331 | 790331 | 2021-02-04 | India | Himachal Pradesh | 57693 | 982 | 56272 | 439 | 31.927213 | 77.233081 | 2021-02-05 05:22:38 | Himachal Pradesh, India | ||
340223 | 340223 | 2021-02-03 | India | Himachal Pradesh | 57646 | 981 | 56256 | 409 | 31.927213 | 77.233081 | 2021-02-04 05:22:26 | Himachal Pradesh, India | ||
1684449 | 1684449 | 2021-02-02 | India | Himachal Pradesh | 57587 | 980 | 56242 | 365 | 31.927213 | 77.233081 | 2021-02-03 05:22:52 | Himachal Pradesh, India | ||
1676419 | 1676419 | 2021-02-01 | India | Himachal Pradesh | 57561 | 979 | 56204 | 378 | 31.927213 | 77.233081 | 2021-02-02 05:22:49 | Himachal Pradesh, India | ||
1459707 | 1459707 | 2021-01-31 | India | Himachal Pradesh | 57536 | 979 | 56167 | 390 | 31.927213 | 77.233081 | 2021-02-01 05:22:53 | Himachal Pradesh, India | ||
2211615 | 2211615 | 2021-01-30 | India | Himachal Pradesh | 57494 | 976 | 56135 | 383 | 31.927213 | 77.233081 | 2021-01-31 05:22:42 | Himachal Pradesh, India | ||
1897102 | 1897102 | 2021-01-29 | India | Himachal Pradesh | 57400 | 974 | 56083 | 343 | 31.927213 | 77.233081 | 2021-01-30 05:22:49 | Himachal Pradesh, India | ||
2481918 | 2481918 | 2021-01-28 | India | Himachal Pradesh | 57356 | 974 | 56043 | 339 | 31.927213 | 77.233081 | 2021-01-29 05:22:23 | Himachal Pradesh, India | ||
3153553 | 3153553 | 2021-01-27 | India | Himachal Pradesh | 57296 | 974 | 55991 | 331 | 31.927213 | 77.233081 | 2021-01-28 05:22:24 | Himachal Pradesh, India | ||
12288 | 12288 | 2021-01-26 | India | Himachal Pradesh | 57257 | 973 | 55923 | 361 | 31.927213 | 77.233081 | 2021-01-27 05:23:41 | Himachal Pradesh, India | ||
2567612 | 2567612 | 2021-01-25 | India | Himachal Pradesh | 57245 | 973 | 55864 | 408 | 31.927213 | 77.233081 | 2021-01-26 05:22:02 | Himachal Pradesh, India | ||
1759244 | 1759244 | 2021-01-24 | India | Himachal Pradesh | 57210 | 973 | 55801 | 436 | 31.927213 | 77.233081 | 2021-01-25 05:22:16 | Himachal Pradesh, India | ||
2426851 | 2426851 | 2021-01-23 | India | Himachal Pradesh | 57189 | 971 | 55749 | 469 | 31.927213 | 77.233081 | 2021-01-24 05:22:35 | Himachal Pradesh, India | ||
2466753 | 2466753 | 2021-01-22 | India | Himachal Pradesh | 57162 | 970 | 55676 | 516 | 31.927213 | 77.233081 | 2021-01-23 05:22:03 | Himachal Pradesh, India | ||
435304 | 435304 | 2021-01-21 | India | Himachal Pradesh | 57121 | 970 | 55595 | 556 | 31.927213 | 77.233081 | 2021-01-22 05:22:10 | Himachal Pradesh, India | ||
1094036 | 1094036 | 2021-01-20 | India | Himachal Pradesh | 57082 | 967 | 55540 | 575 | 31.927213 | 77.233081 | 2021-01-21 05:22:01 | Himachal Pradesh, India | ||
908126 | 908126 | 2021-01-19 | India | Himachal Pradesh | 57019 | 967 | 55468 | 584 | 31.927213 | 77.233081 | 2021-01-20 05:21:54 | Himachal Pradesh, India | ||
237189 | 237189 | 2021-01-18 | India | Himachal Pradesh | 56978 | 967 | 55383 | 628 | 31.927213 | 77.233081 | 2021-01-19 05:22:15 | Himachal Pradesh, India | ||
3503306 | 3503306 | 2021-01-17 | India | Himachal Pradesh | 56943 | 966 | 55280 | 697 | 31.927213 | 77.233081 | 2021-01-18 05:22:34 | Himachal Pradesh, India | ||
3101389 | 3101389 | 2021-01-16 | India | Himachal Pradesh | 56873 | 964 | 55154 | 755 | 31.927213 | 77.233081 | 2021-01-17 05:22:17 | Himachal Pradesh, India | ||
3515351 | 3515351 | 2021-01-15 | India | Himachal Pradesh | 56802 | 963 | 55072 | 767 | 31.927213 | 77.233081 | 2021-01-16 05:22:40 | Himachal Pradesh, India | ||
3879524 | 3879524 | 2021-01-14 | India | Himachal Pradesh | 56751 | 963 | 54977 | 811 | 31.927213 | 77.233081 | 2021-01-15 17:22 | Himachal Pradesh, India | ||
3308151 | 3308151 | 2021-01-13 | India | Himachal Pradesh | 56689 | 963 | 54896 | 830 | 31.927213 | 77.233081 | 2021-01-14 05:22:32 | Himachal Pradesh, India | ||
774296 | 774296 | 2021-01-12 | India | Himachal Pradesh | 56596 | 961 | 54825 | 810 | 31.927213 | 77.233081 | 2021-01-13 05:22:15 | Himachal Pradesh, India | ||
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 |
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]);