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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687413 | 3687413 | 2022-01-13 | India | Himachal Pradesh | 236639 | 3887 | 0 | 31.927213000000002 | 77.233081 | 2022-01-14 04:21:54 | Himachal Pradesh, India | |||
3612997 | 3612997 | 2022-01-12 | India | Himachal Pradesh | 236639 | 3887 | 0 | 31.927213000000002 | 77.233081 | 2022-01-13 08:00:09 | Himachal Pradesh, India | |||
1113522 | 1113522 | 2022-01-11 | India | Himachal Pradesh | 233285 | 3884 | 0 | 31.927213000000002 | 77.233081 | 2022-01-12 04:21:44 | Himachal Pradesh, India | |||
1692250 | 1692250 | 2022-01-10 | India | Himachal Pradesh | 233285 | 3884 | 0 | 31.927213000000002 | 77.233081 | 2022-01-11 04:22:01 | Himachal Pradesh, India | |||
126665 | 126665 | 2022-01-09 | India | Himachal Pradesh | 232085 | 3882 | 0 | 31.927213000000002 | 77.233081 | 2022-01-10 04:22:07 | Himachal Pradesh, India | |||
1215500 | 1215500 | 2022-01-08 | India | Himachal Pradesh | 231587 | 3881 | 0 | 31.927213000000002 | 77.233081 | 2022-01-09 04:21:46 | Himachal Pradesh, India | |||
1389593 | 1389593 | 2022-01-07 | India | Himachal Pradesh | 230859 | 3881 | 0 | 31.927213000000002 | 77.233081 | 2022-01-08 04:21:53 | Himachal Pradesh, India | |||
2609980 | 2609980 | 2022-01-06 | India | Himachal Pradesh | 230285 | 3880 | 0 | 31.927213000000002 | 77.233081 | 2022-01-07 04:22:09 | Himachal Pradesh, India | |||
1281922 | 1281922 | 2022-01-05 | India | Himachal Pradesh | 229787 | 3880 | 0 | 31.927213000000002 | 77.233081 | 2022-01-06 04:22:09 | Himachal Pradesh, India | |||
1285938 | 1285938 | 2022-01-04 | India | Himachal Pradesh | 229413 | 3879 | 0 | 31.927213000000002 | 77.233081 | 2022-01-05 04:21:59 | Himachal Pradesh, India | |||
1700282 | 1700282 | 2022-01-03 | India | Himachal Pradesh | 229153 | 3879 | 0 | 31.927213000000002 | 77.233081 | 2022-01-04 04:22:17 | Himachal Pradesh, India | |||
3519365 | 3519365 | 2022-01-02 | India | Himachal Pradesh | 229016 | 3878 | 0 | 31.927213000000002 | 77.233081 | 2022-01-03 02:22:25 | Himachal Pradesh, India | |||
2167495 | 2167495 | 2022-01-01 | India | Himachal Pradesh | 228940 | 3877 | 0 | 31.927213000000002 | 77.233081 | 2022-01-02 04:20:52 | Himachal Pradesh, India | |||
2776926 | 2776926 | 2021-12-31 | India | Himachal Pradesh | 228857 | 3876 | 0 | 31.927213000000002 | 77.233081 | 2022-01-01 04:22:14 | Himachal Pradesh, India | |||
3998583 | 3998583 | 2021-12-30 | India | Himachal Pradesh | 228770 | 3875 | 0 | 31.927213000000002 | 77.233081 | 2021-12-31 04:21:50 | Himachal Pradesh, India | |||
1668390 | 1668390 | 2021-12-29 | India | Himachal Pradesh | 228705 | 3874 | 0 | 31.927213000000002 | 77.233081 | 2021-12-30 04:21:25 | Himachal Pradesh, India | |||
1432499 | 1432499 | 2021-12-28 | India | Himachal Pradesh | 228653 | 3873 | 0 | 31.927213000000002 | 77.233081 | 2021-12-29 03:21:43 | Himachal Pradesh, India | |||
730460 | 730460 | 2021-12-27 | India | Himachal Pradesh | 228580 | 3873 | 0 | 31.927213000000002 | 77.233081 | 2021-12-28 04:21:47 | Himachal Pradesh, India | |||
2111632 | 2111632 | 2021-12-26 | India | Himachal Pradesh | 228549 | 3873 | 0 | 31.927213000000002 | 77.233081 | 2021-12-27 04:21:58 | Himachal Pradesh, India | |||
3605004 | 3605004 | 2021-12-25 | India | Himachal Pradesh | 228537 | 3873 | 0 | 31.927213000000002 | 77.233081 | 2021-12-26 04:21:50 | Himachal Pradesh, India | |||
2963322 | 2963322 | 2021-12-24 | India | Himachal Pradesh | 228503 | 3871 | 0 | 31.927213000000002 | 77.233081 | 2021-12-25 04:21:37 | Himachal Pradesh, India | |||
3816354 | 3816354 | 2021-12-23 | India | Himachal Pradesh | 228469 | 3871 | 0 | 31.927213000000002 | 77.233081 | 2021-12-24 04:21:34 | Himachal Pradesh, India | |||
798362 | 798362 | 2021-12-22 | India | Himachal Pradesh | 228435 | 3871 | 0 | 31.927213000000002 | 77.233081 | 2021-12-23 04:21:21 | Himachal Pradesh, India | |||
3828402 | 3828402 | 2021-12-21 | India | Himachal Pradesh | 228370 | 3870 | 0 | 31.927213000000002 | 77.233081 | 2021-12-22 04:21:54 | Himachal Pradesh, India | |||
1254705 | 1254705 | 2021-12-20 | India | Himachal Pradesh | 228328 | 3868 | 0 | 31.927213000000002 | 77.233081 | 2021-12-21 03:21:27 | Himachal Pradesh, India | |||
2903648 | 2903648 | 2021-12-19 | India | Himachal Pradesh | 228295 | 3868 | 0 | 31.927213000000002 | 77.233081 | 2021-12-20 04:21:43 | Himachal Pradesh, India | |||
1258721 | 1258721 | 2021-12-18 | India | Himachal Pradesh | 228227 | 3865 | 0 | 31.927213000000002 | 77.233081 | 2021-12-19 04:21:11 | Himachal Pradesh, India | |||
2398749 | 2398749 | 2021-12-17 | India | Himachal Pradesh | 228170 | 3865 | 0 | 31.927213000000002 | 77.233081 | 2021-12-18 02:22:20 | Himachal Pradesh, India | |||
1716287 | 1716287 | 2021-12-16 | India | Himachal Pradesh | 228170 | 3865 | 0 | 31.927213000000002 | 77.233081 | 2021-12-17 04:22:14 | Himachal Pradesh, India | |||
3496121 | 3496121 | 2021-12-15 | India | Himachal Pradesh | 228116 | 3864 | 0 | 31.927213000000002 | 77.233081 | 2021-12-16 04:22:11 | Himachal Pradesh, India | |||
2087906 | 2087906 | 2021-12-14 | India | Himachal Pradesh | 228048 | 3862 | 0 | 31.927213000000002 | 77.233081 | 2021-12-15 03:22:16 | Himachal Pradesh, India | |||
782323 | 782323 | 2021-12-13 | India | Himachal Pradesh | 228007 | 3860 | 0 | 31.927213000000002 | 77.233081 | 2021-12-14 04:22:38 | Himachal Pradesh, India | |||
1660358 | 1660358 | 2021-12-12 | India | Himachal Pradesh | 227939 | 3860 | 0 | 31.927213000000002 | 77.233081 | 2021-12-13 04:22:02 | Himachal Pradesh, India | |||
1664374 | 1664374 | 2021-12-11 | India | Himachal Pradesh | 227904 | 3860 | 0 | 31.927213000000002 | 77.233081 | 2021-12-12 04:22:12 | Himachal Pradesh, India | |||
3655526 | 3655526 | 2021-12-10 | India | Himachal Pradesh | 227859 | 3859 | 0 | 31.927213000000002 | 77.233081 | 2021-12-11 04:22:45 | Himachal Pradesh, India | |||
1077857 | 1077857 | 2021-12-09 | India | Himachal Pradesh | 227805 | 3859 | 0 | 31.927213000000002 | 77.233081 | 2021-12-10 04:22:28 | Himachal Pradesh, India | |||
550706 | 550706 | 2021-12-08 | India | Himachal Pradesh | 227753 | 3857 | 0 | 31.927213000000002 | 77.233081 | 2021-12-09 04:22:49 | Himachal Pradesh, India | |||
404226 | 404226 | 2021-12-07 | India | Himachal Pradesh | 227684 | 3855 | 0 | 31.927213000000002 | 77.233081 | 2021-12-08 04:22:46 | Himachal Pradesh, India | |||
1030308 | 1030308 | 2021-12-06 | India | Himachal Pradesh | 227630 | 3853 | 0 | 31.927213000000002 | 77.233081 | 2021-12-07 04:22:34 | Himachal Pradesh, India | |||
1740471 | 1740471 | 2021-12-05 | India | Himachal Pradesh | 227518 | 3852 | 0 | 31.927213000000002 | 77.233081 | 2021-12-06 04:22:34 | Himachal Pradesh, India | |||
137903 | 137903 | 2021-12-04 | India | Himachal Pradesh | 227405 | 3852 | 0 | 31.927213000000002 | 77.233081 | 2021-12-05 04:22:25 | Himachal Pradesh, India | |||
2195556 | 2195556 | 2021-12-03 | India | Himachal Pradesh | 227405 | 3852 | 0 | 31.927213000000002 | 77.233081 | 2021-12-04 04:22:18 | Himachal Pradesh, India | |||
262 | 262 | 2021-12-02 | India | Himachal Pradesh | 227354 | 3850 | 0 | 31.927213000000002 | 77.233081 | 2021-12-03 04:23:05 | Himachal Pradesh, India | |||
1144861 | 1144861 | 2021-12-01 | India | Himachal Pradesh | 227269 | 3849 | 0 | 31.927213000000002 | 77.233081 | 2021-12-02 04:22:37 | Himachal Pradesh, India | |||
3401373 | 3401373 | 2021-11-30 | India | Himachal Pradesh | 227195 | 3848 | 0 | 31.927213000000002 | 77.233081 | 2021-12-01 04:22:29 | Himachal Pradesh, India | |||
149916 | 149916 | 2021-11-29 | India | Himachal Pradesh | 227093 | 3847 | 0 | 31.927213000000002 | 77.233081 | 2021-11-30 04:22:53 | Himachal Pradesh, India | |||
1231562 | 1231562 | 2021-11-28 | India | Himachal Pradesh | 227003 | 3847 | 0 | 31.927213000000002 | 77.233081 | 2021-11-29 04:22:30 | Himachal Pradesh, India | |||
1358269 | 1358269 | 2021-11-27 | India | Himachal Pradesh | 226941 | 3845 | 0 | 31.927213000000002 | 77.233081 | 2021-11-28 04:22:43 | Himachal Pradesh, India | |||
758260 | 758260 | 2021-11-26 | India | Himachal Pradesh | 226859 | 3842 | 0 | 31.927213000000002 | 77.233081 | 2021-11-27 04:22:45 | Himachal Pradesh, India | |||
1802677 | 1802677 | 2021-11-25 | India | Himachal Pradesh | 226757 | 3839 | 0 | 31.927213000000002 | 77.233081 | 2021-11-26 04:22:33 | Himachal Pradesh, India | |||
904111 | 904111 | 2021-11-24 | India | Himachal Pradesh | 226705 | 3838 | 0 | 31.927213000000002 | 77.233081 | 2021-11-25 04:22:33 | Himachal Pradesh, India | |||
3069961 | 3069961 | 2021-11-23 | India | Himachal Pradesh | 226589 | 3835 | 0 | 31.927213000000002 | 77.233081 | 2021-11-24 04:22:14 | Himachal Pradesh, India | |||
3749059 | 3749059 | 2021-11-22 | India | Himachal Pradesh | 226505 | 3834 | 0 | 31.927213000000002 | 77.233081 | 2021-11-23 04:22:39 | Himachal Pradesh, India | |||
1014266 | 1014266 | 2021-11-21 | India | Himachal Pradesh | 226395 | 3831 | 0 | 31.927213000000002 | 77.233081 | 2021-11-22 04:22:20 | Himachal Pradesh, India | |||
722430 | 722430 | 2021-11-20 | India | Himachal Pradesh | 226344 | 3829 | 0 | 31.927213000000002 | 77.233081 | 2021-11-21 04:22:13 | Himachal Pradesh, India | |||
161960 | 161960 | 2021-11-19 | India | Himachal Pradesh | 226264 | 3828 | 0 | 31.927213000000002 | 77.233081 | 2021-11-20 04:22:17 | Himachal Pradesh, India | |||
3288847 | 3288847 | 2021-11-18 | India | Himachal Pradesh | 226213 | 3826 | 0 | 31.927213000000002 | 77.233081 | 2021-11-19 04:21:40 | Himachal Pradesh, India | |||
447303 | 447303 | 2021-11-17 | India | Himachal Pradesh | 226118 | 3823 | 0 | 31.927213000000002 | 77.233081 | 2021-11-18 04:21:33 | Himachal Pradesh, India | |||
3342553 | 3342553 | 2021-11-16 | India | Himachal Pradesh | 226022 | 3822 | 0 | 31.927213000000002 | 77.233081 | 2021-11-17 04:21:48 | Himachal Pradesh, India | |||
2287389 | 2287389 | 2021-11-15 | India | Himachal Pradesh | 225893 | 3821 | 0 | 31.927213000000002 | 77.233081 | 2021-11-16 04:21:10 | Himachal Pradesh, India | |||
1322163 | 1322163 | 2021-11-14 | India | Himachal Pradesh | 225768 | 3815 | 0 | 31.927213000000002 | 77.233081 | 2021-11-15 04:21:36 | Himachal Pradesh, India | |||
686289 | 686289 | 2021-11-13 | India | Himachal Pradesh | 225712 | 3812 | 0 | 31.927213000000002 | 77.233081 | 2021-11-14 04:21:31 | Himachal Pradesh, India | |||
714398 | 714398 | 2021-11-12 | India | Himachal Pradesh | 225589 | 3803 | 0 | 31.927213000000002 | 77.233081 | 2021-11-13 04:21:38 | Himachal Pradesh, India | |||
28348 | 28348 | 2021-11-11 | India | Himachal Pradesh | 225464 | 3800 | 0 | 31.927213000000002 | 77.233081 | 2021-11-12 04:22:01 | Himachal Pradesh, India | |||
2844787 | 2844787 | 2021-11-10 | India | Himachal Pradesh | 225319 | 3790 | 0 | 31.927213000000002 | 77.233081 | 2021-11-11 04:21:45 | Himachal Pradesh, India | |||
87057 | 87057 | 2021-11-09 | India | Himachal Pradesh | 225165 | 3785 | 0 | 31.927213000000002 | 77.233081 | 2021-11-10 04:21:38 | Himachal Pradesh, India | |||
3639485 | 3639485 | 2021-11-08 | India | Himachal Pradesh | 225035 | 3784 | 0 | 31.927213000000002 | 77.233081 | 2021-11-09 04:21:36 | Himachal Pradesh, India | |||
2000593 | 2000593 | 2021-11-07 | India | Himachal Pradesh | 224890 | 3779 | 0 | 31.927213000000002 | 77.233081 | 2021-11-08 04:21:43 | Himachal Pradesh, India | |||
495584 | 495584 | 2021-11-06 | India | Himachal Pradesh | 224830 | 3774 | 0 | 31.927213000000002 | 77.233081 | 2021-11-07 04:21:53 | Himachal Pradesh, India | |||
3121439 | 3121439 | 2021-11-05 | India | Himachal Pradesh | 224716 | 3768 | 0 | 31.927213000000002 | 77.233081 | 2021-11-06 04:21:51 | Himachal Pradesh, India | |||
698337 | 698337 | 2021-11-04 | India | Himachal Pradesh | 224619 | 3768 | 0 | 31.927213000000002 | 77.233081 | 2021-11-05 04:21:54 | Himachal Pradesh, India | |||
276115 | 276115 | 2021-11-03 | India | Himachal Pradesh | 224557 | 3766 | 0 | 31.927213000000002 | 77.233081 | 2021-11-04 04:22:20 | Himachal Pradesh, India | |||
43640 | 43640 | 2021-11-02 | India | Himachal Pradesh | 224419 | 3762 | 0 | 31.927213000000002 | 77.233081 | 2021-11-03 06:22:09 | Himachal Pradesh, India | |||
3511336 | 3511336 | 2021-11-01 | India | Himachal Pradesh | 224251 | 3758 | 0 | 31.927213000000002 | 77.233081 | 2021-11-02 04:22:03 | Himachal Pradesh, India | |||
287928 | 287928 | 2021-10-31 | India | Himachal Pradesh | 224106 | 3754 | 0 | 31.927213000000002 | 77.233081 | 2021-11-01 04:22:01 | Himachal Pradesh, India | |||
2720934 | 2720934 | 2021-10-30 | India | Himachal Pradesh | 224021 | 3753 | 0 | 31.927213000000002 | 77.233081 | 2021-10-31 04:22:08 | Himachal Pradesh, India | |||
567036 | 567036 | 2021-10-29 | India | Himachal Pradesh | 223876 | 3748 | 0 | 31.927213000000002 | 77.233081 | 2021-10-30 04:22:03 | Himachal Pradesh, India | |||
4278 | 4278 | 2021-10-28 | India | Himachal Pradesh | 223619 | 3745 | 0 | 31.927213000000002 | 77.233081 | 2021-10-29 04:22:03 | Himachal Pradesh, India | |||
534668 | 534668 | 2021-10-27 | India | Himachal Pradesh | 223406 | 3741 | 0 | 31.927213000000002 | 77.233081 | 2021-10-28 04:22:08 | Himachal Pradesh, India | |||
3492105 | 3492105 | 2021-10-26 | India | Himachal Pradesh | 223145 | 3739 | 0 | 31.927213000000002 | 77.233081 | 2021-10-27 04:22:32 | Himachal Pradesh, India | |||
3793827 | 3793827 | 2021-10-25 | India | Himachal Pradesh | 222890 | 3737 | 0 | 31.927213000000002 | 77.233081 | 2021-10-26 04:22:09 | Himachal Pradesh, India | |||
682273 | 682273 | 2021-10-24 | India | Himachal Pradesh | 222638 | 3736 | 0 | 31.927213000000002 | 77.233081 | 2021-10-25 04:22:31 | Himachal Pradesh, India | |||
770281 | 770281 | 2021-10-23 | India | Himachal Pradesh | 222569 | 3734 | 0 | 31.927213000000002 | 77.233081 | 2021-10-24 04:21:22 | Himachal Pradesh, India | |||
653928 | 653928 | 2021-10-22 | India | Himachal Pradesh | 222312 | 3733 | 0 | 31.927213000000002 | 77.233081 | 2021-10-23 04:21:32 | Himachal Pradesh, India | |||
2123675 | 2123675 | 2021-10-21 | India | Himachal Pradesh | 222138 | 3731 | 0 | 31.927213000000002 | 77.233081 | 2021-10-22 04:21:14 | Himachal Pradesh, India | |||
443287 | 443287 | 2021-10-20 | India | Himachal Pradesh | 221936 | 3727 | 0 | 31.927213000000002 | 77.233081 | 2021-10-21 04:21:18 | Himachal Pradesh, India | |||
597606 | 597606 | 2021-10-19 | India | Himachal Pradesh | 221826 | 3727 | 0 | 31.927213000000002 | 77.233081 | 2021-10-20 04:21:00 | Himachal Pradesh, India | |||
2043783 | 2043783 | 2021-10-18 | India | Himachal Pradesh | 221604 | 3725 | 0 | 31.927213000000002 | 77.233081 | 2021-10-19 04:20:54 | Himachal Pradesh, India | |||
1909144 | 1909144 | 2021-10-17 | India | Himachal Pradesh | 221437 | 3720 | 0 | 31.927213000000002 | 77.233081 | 2021-10-18 04:21:10 | Himachal Pradesh, India | |||
934733 | 934733 | 2021-10-16 | India | Himachal Pradesh | 221306 | 3719 | 0 | 31.927213000000002 | 77.233081 | 2021-10-17 04:21:29 | Himachal Pradesh, India | |||
2943288 | 2943288 | 2021-10-15 | India | Himachal Pradesh | 221203 | 3717 | 0 | 31.927213000000002 | 77.233081 | 2021-10-16 04:21:15 | Himachal Pradesh, India | |||
491568 | 491568 | 2021-10-14 | India | Himachal Pradesh | 221113 | 3715 | 0 | 31.927213000000002 | 77.233081 | 2021-10-15 04:21:26 | Himachal Pradesh, India | |||
633856 | 633856 | 2021-10-13 | India | Himachal Pradesh | 220931 | 3711 | 0 | 31.927213000000002 | 77.233081 | 2021-10-14 04:21:29 | Himachal Pradesh, India | |||
1491534 | 1491534 | 2021-10-12 | India | Himachal Pradesh | 220792 | 3710 | 0 | 31.927213000000002 | 77.233081 | 2021-10-13 04:20:51 | Himachal Pradesh, India | |||
3007267 | 3007267 | 2021-10-11 | India | Himachal Pradesh | 220618 | 3706 | 0 | 31.927213000000002 | 77.233081 | 2021-10-12 04:21:09 | Himachal Pradesh, India | |||
423283 | 423283 | 2021-10-10 | India | Himachal Pradesh | 220479 | 3704 | 0 | 31.927213000000002 | 77.233081 | 2021-10-11 04:21:31 | Himachal Pradesh, India | |||
2876140 | 2876140 | 2021-10-09 | India | Himachal Pradesh | 220392 | 3699 | 0 | 31.927213000000002 | 77.233081 | 2021-10-10 04:21:38 | Himachal Pradesh, India | |||
2959306 | 2959306 | 2021-10-08 | India | Himachal Pradesh | 220254 | 3696 | 0 | 31.927213000000002 | 77.233081 | 2021-10-09 04:21:34 | Himachal Pradesh, India | |||
467344 | 467344 | 2021-10-07 | India | Himachal Pradesh | 220061 | 3694 | 0 | 31.927213000000002 | 77.233081 | 2021-10-08 04:21:25 | Himachal Pradesh, India | |||
2458724 | 2458724 | 2021-10-06 | India | Himachal Pradesh | 219919 | 3690 | 0 | 31.927213000000002 | 77.233081 | 2021-10-07 04:21:36 | 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]);