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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
3832418 | 3832418 | 2021-10-05 | India | Himachal Pradesh | 219746 | 3688 | 0 | 31.927213000000002 | 77.233081 | 2021-10-06 04:21:33 | Himachal Pradesh, India | |||
986911 | 986911 | 2021-10-04 | India | Himachal Pradesh | 219591 | 3685 | 0 | 31.927213000000002 | 77.233081 | 2021-10-05 04:21:27 | Himachal Pradesh, India | |||
1274221 | 1274221 | 2021-10-03 | India | Himachal Pradesh | 219400 | 3681 | 0 | 31.927213000000002 | 77.233081 | 2021-10-04 04:21:31 | Himachal Pradesh, India | |||
3927974 | 3927974 | 2021-10-02 | India | Himachal Pradesh | 219333 | 3681 | 0 | 31.927213000000002 | 77.233081 | 2021-10-03 04:21:24 | Himachal Pradesh, India | |||
2131954 | 2131954 | 2021-10-01 | India | Himachal Pradesh | 219244 | 3679 | 0 | 31.927213000000002 | 77.233081 | 2021-10-02 04:21:25 | Himachal Pradesh, India | |||
2772911 | 2772911 | 2021-09-30 | India | Himachal Pradesh | 219061 | 3676 | 0 | 31.927213000000002 | 77.233081 | 2021-10-01 04:21:35 | Himachal Pradesh, India | |||
706367 | 706367 | 2021-09-29 | India | Himachal Pradesh | 218898 | 3675 | 0 | 31.927213000000002 | 77.233081 | 2021-09-30 04:21:20 | Himachal Pradesh, India | |||
1334209 | 1334209 | 2021-09-28 | India | Himachal Pradesh | 218693 | 3672 | 0 | 31.927213000000002 | 77.233081 | 2021-09-29 04:21:45 | Himachal Pradesh, India | |||
1235578 | 1235578 | 2021-09-27 | India | Himachal Pradesh | 218523 | 3669 | 0 | 31.927213000000002 | 77.233081 | 2021-09-28 04:21:28 | Himachal Pradesh, India | |||
2075879 | 2075879 | 2021-09-26 | India | Himachal Pradesh | 218314 | 3669 | 0 | 31.927213000000002 | 77.233081 | 2021-09-27 04:21:16 | Himachal Pradesh, India | |||
1724431 | 1724431 | 2021-09-25 | India | Himachal Pradesh | 218202 | 3666 | 0 | 31.927213000000002 | 77.233081 | 2021-09-26 04:21:29 | Himachal Pradesh, India | |||
1921151 | 1921151 | 2021-09-24 | India | Himachal Pradesh | 218000 | 3662 | 0 | 31.927213000000002 | 77.233081 | 2021-09-25 04:21:31 | Himachal Pradesh, India | |||
601622 | 601622 | 2021-09-23 | India | Himachal Pradesh | 217776 | 3662 | 0 | 31.927213000000002 | 77.233081 | 2021-09-24 04:21:44 | Himachal Pradesh, India | |||
3011283 | 3011283 | 2021-09-22 | India | Himachal Pradesh | 217615 | 3659 | 0 | 31.927213000000002 | 77.233081 | 2021-09-23 04:21:43 | Himachal Pradesh, India | |||
3757421 | 3757421 | 2021-09-21 | India | Himachal Pradesh | 217403 | 3655 | 0 | 31.927213000000002 | 77.233081 | 2021-09-22 04:21:45 | Himachal Pradesh, India | |||
809524 | 809524 | 2021-09-20 | India | Himachal Pradesh | 217140 | 3653 | 0 | 31.927213000000002 | 77.233081 | 2021-09-21 04:21:26 | Himachal Pradesh, India | |||
1814723 | 1814723 | 2021-09-19 | India | Himachal Pradesh | 216906 | 3650 | 0 | 31.927213000000002 | 77.233081 | 2021-09-20 04:21:22 | Himachal Pradesh, India | |||
16303 | 16303 | 2021-09-18 | India | Himachal Pradesh | 216813 | 3649 | 0 | 31.927213000000002 | 77.233081 | 2021-09-19 04:21:34 | Himachal Pradesh, India | |||
2617988 | 2617988 | 2021-09-17 | India | Himachal Pradesh | 216639 | 3647 | 0 | 31.927213000000002 | 77.233081 | 2021-09-18 04:21:24 | Himachal Pradesh, India | |||
2808696 | 2808696 | 2021-09-16 | India | Himachal Pradesh | 216430 | 3647 | 0 | 31.927213000000002 | 77.233081 | 2021-09-17 04:21:46 | Himachal Pradesh, India | |||
1374441 | 1374441 | 2021-09-15 | India | Himachal Pradesh | 216303 | 3644 | 0 | 31.927213000000002 | 77.233081 | 2021-09-16 04:22:19 | Himachal Pradesh, India | |||
2462740 | 2462740 | 2021-09-14 | India | Himachal Pradesh | 216088 | 3642 | 0 | 31.927213000000002 | 77.233081 | 2021-09-15 03:22:37 | Himachal Pradesh, India | |||
1385579 | 1385579 | 2021-09-13 | India | Himachal Pradesh | 215893 | 3639 | 0 | 31.927213000000002 | 77.233081 | 2021-09-14 04:21:41 | Himachal Pradesh, India | |||
1884948 | 1884948 | 2021-09-12 | India | Himachal Pradesh | 215691 | 3636 | 0 | 31.927213000000002 | 77.233081 | 2021-09-13 04:21:15 | Himachal Pradesh, India | |||
3805851 | 3805851 | 2021-09-11 | India | Himachal Pradesh | 215604 | 3635 | 0 | 31.927213000000002 | 77.233081 | 2021-09-12 04:21:13 | Himachal Pradesh, India | |||
3448791 | 3448791 | 2021-09-10 | India | Himachal Pradesh | 215437 | 3630 | 0 | 31.927213000000002 | 77.233081 | 2021-09-11 04:21:30 | Himachal Pradesh, India | |||
1262737 | 1262737 | 2021-09-09 | India | Himachal Pradesh | 215235 | 3628 | 0 | 31.927213000000002 | 77.233081 | 2021-09-10 04:21:20 | Himachal Pradesh, India | |||
2279107 | 2279107 | 2021-09-08 | India | Himachal Pradesh | 215074 | 3622 | 0 | 31.927213000000002 | 77.233081 | 2021-09-09 04:21:27 | Himachal Pradesh, India | |||
641886 | 641886 | 2021-09-07 | India | Himachal Pradesh | 214911 | 3618 | 0 | 31.927213000000002 | 77.233081 | 2021-09-08 04:21:31 | Himachal Pradesh, India | |||
3193949 | 3193949 | 2021-09-06 | India | Himachal Pradesh | 214732 | 3613 | 0 | 31.927213000000002 | 77.233081 | 2021-09-07 04:21:35 | Himachal Pradesh, India | |||
3280817 | 3280817 | 2021-09-05 | India | Himachal Pradesh | 214504 | 3611 | 0 | 31.927213000000002 | 77.233081 | 2021-09-06 04:21:22 | Himachal Pradesh, India | |||
249231 | 249231 | 2021-09-04 | India | Himachal Pradesh | 214408 | 3609 | 0 | 31.927213000000002 | 77.233081 | 2021-09-05 04:21:33 | Himachal Pradesh, India | |||
3974512 | 3974512 | 2021-09-03 | India | Himachal Pradesh | 214193 | 3608 | 0 | 31.927213000000002 | 77.233081 | 2021-09-04 04:21:28 | Himachal Pradesh, India | |||
177974 | 177974 | 2021-09-02 | India | Himachal Pradesh | 214004 | 3604 | 0 | 31.927213000000002 | 77.233081 | 2021-09-03 04:21:20 | Himachal Pradesh, India | |||
67009 | 67009 | 2021-09-01 | India | Himachal Pradesh | 213799 | 3603 | 0 | 31.927213000000002 | 77.233081 | 2021-09-02 04:21:15 | Himachal Pradesh, India | |||
2067851 | 2067851 | 2021-08-31 | India | Himachal Pradesh | 213548 | 3598 | 0 | 31.927213000000002 | 77.233081 | 2021-09-01 04:21:38 | Himachal Pradesh, India | |||
1775305 | 1775305 | 2021-08-30 | India | Himachal Pradesh | 213341 | 3595 | 0 | 31.927213000000002 | 77.233081 | 2021-08-31 04:21:46 | Himachal Pradesh, India | |||
3891879 | 3891879 | 2021-08-29 | India | Himachal Pradesh | 213245 | 3592 | 0 | 31.927213000000002 | 77.233081 | 2021-08-30 04:21:23 | Himachal Pradesh, India | |||
2792982 | 2792982 | 2021-08-28 | India | Himachal Pradesh | 213122 | 3591 | 0 | 31.927213000000002 | 77.233081 | 2021-08-29 04:21:14 | Himachal Pradesh, India | |||
2923141 | 2923141 | 2021-08-27 | India | Himachal Pradesh | 212913 | 3585 | 0 | 31.927213000000002 | 77.233081 | 2021-08-28 04:21:28 | Himachal Pradesh, India | |||
1596155 | 1596155 | 2021-08-26 | India | Himachal Pradesh | 212727 | 3582 | 0 | 31.927213000000002 | 77.233081 | 2021-08-27 04:21:37 | Himachal Pradesh, India | |||
32364 | 32364 | 2021-08-25 | India | Himachal Pradesh | 212458 | 3579 | 0 | 31.927213000000002 | 77.233081 | 2021-08-26 04:21:28 | Himachal Pradesh, India | |||
3105403 | 3105403 | 2021-08-24 | India | Himachal Pradesh | 212260 | 3578 | 0 | 31.927213000000002 | 77.233081 | 2021-08-25 04:21:41 | Himachal Pradesh, India | |||
3165574 | 3165574 | 2021-08-23 | India | Himachal Pradesh | 211979 | 3574 | 0 | 31.927213000000002 | 77.233081 | 2021-08-24 04:21:19 | Himachal Pradesh, India | |||
2175501 | 2175501 | 2021-08-22 | India | Himachal Pradesh | 211746 | 3569 | 0 | 31.927213000000002 | 77.233081 | 2021-08-23 04:21:27 | Himachal Pradesh, India | |||
3555597 | 3555597 | 2021-08-21 | India | Himachal Pradesh | 211632 | 3563 | 0 | 31.927213000000002 | 77.233081 | 2021-08-22 04:21:29 | Himachal Pradesh, India | |||
1853939 | 1853939 | 2021-08-20 | India | Himachal Pradesh | 211432 | 3562 | 0 | 31.927213000000002 | 77.233081 | 2021-08-21 04:21:38 | Himachal Pradesh, India | |||
511646 | 511646 | 2021-08-19 | India | Himachal Pradesh | 211277 | 3559 | 0 | 31.927213000000002 | 77.233081 | 2021-08-20 04:21:33 | Himachal Pradesh, India | |||
2518125 | 2518125 | 2021-08-18 | India | Himachal Pradesh | 210980 | 3558 | 0 | 31.927213000000002 | 77.233081 | 2021-08-19 04:21:15 | Himachal Pradesh, India | |||
245217 | 245217 | 2021-08-17 | India | Himachal Pradesh | 210719 | 3557 | 0 | 31.927213000000002 | 77.233081 | 2021-08-18 04:21:35 | Himachal Pradesh, India | |||
1604180 | 1604180 | 2021-08-16 | India | Himachal Pradesh | 210419 | 3551 | 0 | 31.927213000000002 | 77.233081 | 2021-08-17 04:21:49 | Himachal Pradesh, India | |||
103274 | 103274 | 2021-08-15 | India | Himachal Pradesh | 210143 | 3548 | 0 | 31.927213000000002 | 77.233081 | 2021-08-16 04:21:31 | Himachal Pradesh, India | |||
507632 | 507632 | 2021-08-14 | India | Himachal Pradesh | 209961 | 3545 | 0 | 31.927213000000002 | 77.233081 | 2021-08-15 04:21:41 | Himachal Pradesh, India | |||
1483504 | 1483504 | 2021-08-13 | India | Himachal Pradesh | 209677 | 3544 | 0 | 31.927213000000002 | 77.233081 | 2021-08-14 04:21:25 | Himachal Pradesh, India | |||
2899634 | 2899634 | 2021-08-12 | India | Himachal Pradesh | 209344 | 3542 | 0 | 31.927213000000002 | 77.233081 | 2021-08-13 04:21:24 | Himachal Pradesh, India | |||
1342238 | 1342238 | 2021-08-11 | India | Himachal Pradesh | 208990 | 3539 | 0 | 31.927213000000002 | 77.233081 | 2021-08-12 04:21:25 | Himachal Pradesh, India | |||
2351385 | 2351385 | 2021-08-10 | India | Himachal Pradesh | 208616 | 3537 | 0 | 31.927213000000002 | 77.233081 | 2021-08-11 04:21:58 | Himachal Pradesh, India | |||
649914 | 649914 | 2021-08-09 | India | Himachal Pradesh | 208197 | 3535 | 0 | 31.927213000000002 | 77.233081 | 2021-08-10 04:21:27 | Himachal Pradesh, India | |||
589576 | 589576 | 2021-08-08 | India | Himachal Pradesh | 207887 | 3534 | 0 | 31.927213 | 77.233081 | 2021-08-09 04:21:24 | Himachal Pradesh, India | |||
2203588 | 2203588 | 2021-08-07 | India | Himachal Pradesh | 207700 | 3533 | 0 | 31.927213 | 77.233081 | 2021-08-08 04:21:33 | Himachal Pradesh, India | |||
1117538 | 1117538 | 2021-08-06 | India | Himachal Pradesh | 207344 | 3533 | 0 | 31.927213 | 77.233081 | 2021-08-07 04:21:30 | Himachal Pradesh, India | |||
1956475 | 1956475 | 2021-08-05 | India | Himachal Pradesh | 207088 | 3531 | 0 | 31.927213 | 77.233081 | 2021-08-06 04:21:18 | Himachal Pradesh, India | |||
331854 | 331854 | 2021-08-04 | India | Himachal Pradesh | 206832 | 3527 | 201797 | 1508 | 31.927213 | 77.233081 | 2021-08-05 04:21:51 | Himachal Pradesh, India | ||
3468125 | 3468125 | 2021-08-03 | India | Himachal Pradesh | 206589 | 3523 | 201652 | 1414 | 31.927213 | 77.233081 | 2021-08-04 04:21:25 | Himachal Pradesh, India | ||
3683399 | 3683399 | 2021-08-02 | India | Himachal Pradesh | 206369 | 3522 | 201543 | 1304 | 31.927213 | 77.233081 | 2021-08-03 04:21:39 | Himachal Pradesh, India | ||
3015298 | 3015298 | 2021-08-01 | India | Himachal Pradesh | 206161 | 3521 | 201411 | 1229 | 31.927213 | 77.233081 | 2021-08-02 04:21:36 | Himachal Pradesh, India | ||
3903921 | 3903921 | 2021-07-31 | India | Himachal Pradesh | 206027 | 3521 | 201289 | 1217 | 31.927213 | 77.233081 | 2021-08-01 04:21:50 | Himachal Pradesh, India | ||
3296126 | 3296126 | 2021-07-30 | India | Himachal Pradesh | 205874 | 3520 | 201217 | 1137 | 31.927213 | 77.233081 | 2021-07-31 04:21:35 | Himachal Pradesh, India | ||
3385337 | 3385337 | 2021-07-29 | India | Himachal Pradesh | 205728 | 3520 | 201110 | 1098 | 31.927213 | 77.233081 | 2021-07-30 04:21:34 | Himachal Pradesh, India | ||
408242 | 408242 | 2021-07-28 | India | Himachal Pradesh | 205499 | 3520 | 201026 | 953 | 31.927213 | 77.233081 | 2021-07-29 04:21:33 | Himachal Pradesh, India | ||
1306103 | 1306103 | 2021-07-27 | India | Himachal Pradesh | 205383 | 3518 | 200942 | 923 | 31.927213 | 77.233081 | 2021-07-28 04:21:39 | Himachal Pradesh, India | ||
3218246 | 3218246 | 2021-07-26 | India | Himachal Pradesh | 205200 | 3516 | 200826 | 858 | 31.927213 | 77.233081 | 2021-07-27 04:21:18 | Himachal Pradesh, India | ||
1378455 | 1378455 | 2021-07-25 | India | Himachal Pradesh | 205061 | 3514 | 200706 | 841 | 31.927213 | 77.233081 | 2021-07-26 04:21:28 | Himachal Pradesh, India | ||
1330195 | 1330195 | 2021-07-24 | India | Himachal Pradesh | 205017 | 3513 | 200573 | 931 | 31.927213 | 77.233081 | 2021-07-25 04:22:12 | Himachal Pradesh, India | ||
3137499 | 3137499 | 2021-07-23 | India | Himachal Pradesh | 204887 | 3511 | 200356 | 1020 | 31.927213 | 77.233081 | 2021-07-24 00:21:36 | Himachal Pradesh, India | ||
3476259 | 3476259 | 2021-07-22 | India | Himachal Pradesh | 204800 | 3509 | 200356 | 935 | 31.927213 | 77.233081 | 2021-07-23 04:21:29 | Himachal Pradesh, India | ||
3331478 | 3331478 | 2021-07-21 | India | Himachal Pradesh | 204685 | 3507 | 200237 | 941 | 31.927213 | 77.233081 | 2021-07-22 04:21:19 | Himachal Pradesh, India | ||
2371459 | 2371459 | 2021-07-20 | India | Himachal Pradesh | 204618 | 3507 | 200154 | 957 | 31.927213 | 77.233081 | 2021-07-21 04:21:40 | Himachal Pradesh, India | ||
483538 | 483538 | 2021-07-19 | India | Himachal Pradesh | 204516 | 3507 | 200040 | 969 | 31.927213 | 77.233081 | 2021-07-20 04:21:48 | Himachal Pradesh, India | ||
2673761 | 2673761 | 2021-07-18 | India | Himachal Pradesh | 204391 | 3507 | 199877 | 1007 | 31.927213 | 77.233081 | 2021-07-19 04:21:24 | Himachal Pradesh, India | ||
3706073 | 3706073 | 2021-07-17 | India | Himachal Pradesh | 204337 | 3505 | 199722 | 1110 | 31.927213 | 77.233081 | 2021-07-18 04:22:07 | Himachal Pradesh, India | ||
2947304 | 2947304 | 2021-07-16 | India | Himachal Pradesh | 204224 | 3504 | 199584 | 1136 | 31.927213 | 77.233081 | 2021-07-17 04:22:22 | Himachal Pradesh, India | ||
295960 | 295960 | 2021-07-15 | India | Himachal Pradesh | 204098 | 3502 | 199446 | 1150 | 31.927213 | 77.233081 | 2021-07-16 04:21:22 | Himachal Pradesh, India | ||
3631905 | 3631905 | 2021-07-14 | India | Himachal Pradesh | 203962 | 3499 | 199272 | 1191 | 31.927213 | 77.233081 | 2021-07-15 04:21:48 | Himachal Pradesh, India | ||
578780 | 578780 | 2021-07-13 | India | Himachal Pradesh | 203869 | 3496 | 199170 | 1203 | 31.927213 | 77.233081 | 2021-07-14 04:21:35 | Himachal Pradesh, India | ||
3741029 | 3741029 | 2021-07-12 | India | Himachal Pradesh | 203719 | 3492 | 199020 | 1207 | 31.927213 | 77.233081 | 2021-07-13 04:21:18 | Himachal Pradesh, India | ||
3659542 | 3659542 | 2021-07-11 | India | Himachal Pradesh | 203626 | 3491 | 198888 | 1247 | 31.927213 | 77.233081 | 2021-07-12 04:21:34 | Himachal Pradesh, India | ||
625826 | 625826 | 2021-07-10 | India | Himachal Pradesh | 203563 | 3490 | 198738 | 1335 | 31.927213 | 77.233081 | 2021-07-11 04:21:43 | Himachal Pradesh, India | ||
829545 | 829545 | 2021-07-09 | India | Himachal Pradesh | 203425 | 3487 | 198579 | 1359 | 31.927213 | 77.233081 | 2021-07-10 04:21:25 | Himachal Pradesh, India | ||
778309 | 778309 | 2021-07-08 | India | Himachal Pradesh | 203245 | 3486 | 198452 | 1307 | 31.927213 | 77.233081 | 2021-07-09 04:21:21 | Himachal Pradesh, India | ||
1440531 | 1440531 | 2021-07-07 | India | Himachal Pradesh | 203117 | 3486 | 198293 | 1338 | 31.927213 | 77.233081 | 2021-07-08 04:21:26 | Himachal Pradesh, India | ||
2693636 | 2693636 | 2021-07-06 | India | Himachal Pradesh | 202945 | 3485 | 198134 | 1326 | 31.927213 | 77.233081 | 2021-07-07 04:21:20 | Himachal Pradesh, India | ||
1932385 | 1932385 | 2021-07-05 | India | Himachal Pradesh | 202800 | 3484 | 197959 | 1357 | 31.927213 | 77.233081 | 2021-07-06 04:21:32 | 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]);