johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016656 | 2016656 | 2022-09-20 | India | Himachal Pradesh | 311976 | 4208 | 0 | 31.927213 | 77.233081 | 2022-09-21 04:23:22 | Himachal Pradesh, India | |||
3570529 | 3570529 | 2022-09-19 | India | Himachal Pradesh | 311944 | 4208 | 0 | 31.927213 | 77.233081 | 2022-09-20 04:22:48 | Himachal Pradesh, India | |||
419268 | 419268 | 2022-09-18 | India | Himachal Pradesh | 311911 | 4208 | 0 | 31.927213 | 77.233081 | 2022-09-19 04:21:49 | Himachal Pradesh, India | |||
3373292 | 3373292 | 2022-09-17 | India | Himachal Pradesh | 311906 | 4208 | 0 | 31.927213 | 77.233081 | 2022-09-18 04:22:50 | Himachal Pradesh, India | |||
2355400 | 2355400 | 2022-09-16 | India | Himachal Pradesh | 311891 | 4207 | 0 | 31.927213 | 77.233081 | 2022-09-17 04:20:19 | Himachal Pradesh, India | |||
3986557 | 3986557 | 2022-09-15 | India | Himachal Pradesh | 311860 | 4206 | 0 | 31.927213 | 77.233081 | 2022-09-16 04:21:19 | Himachal Pradesh, India | |||
1889074 | 1889074 | 2022-09-14 | India | Himachal Pradesh | 311812 | 4206 | 0 | 31.927213 | 77.233081 | 2022-09-15 04:21:02 | Himachal Pradesh, India | |||
372129 | 372129 | 2022-09-13 | India | Himachal Pradesh | 311745 | 4206 | 0 | 31.927213 | 77.233081 | 2022-09-14 04:20:44 | Himachal Pradesh, India | |||
2394734 | 2394734 | 2022-09-12 | India | Himachal Pradesh | 311705 | 4205 | 0 | 31.927213 | 77.233081 | 2022-09-13 04:20:57 | Himachal Pradesh, India | |||
3765812 | 3765812 | 2022-09-11 | India | Himachal Pradesh | 311649 | 4204 | 0 | 31.927213 | 77.233081 | 2022-09-12 04:20:58 | Himachal Pradesh, India | |||
3824387 | 3824387 | 2022-09-10 | India | Himachal Pradesh | 311626 | 4204 | 0 | 31.927213 | 77.233081 | 2022-09-11 04:20:50 | Himachal Pradesh, India | |||
962844 | 962844 | 2022-09-09 | India | Himachal Pradesh | 311601 | 4204 | 0 | 31.927213 | 77.233081 | 2022-09-10 04:21:10 | Himachal Pradesh, India | |||
253246 | 253246 | 2022-09-08 | India | Himachal Pradesh | 311533 | 4203 | 0 | 31.927213 | 77.233081 | 2022-09-09 04:21:11 | Himachal Pradesh, India | |||
3745044 | 3745044 | 2022-09-07 | India | Himachal Pradesh | 311471 | 4202 | 0 | 31.927213 | 77.233081 | 2022-09-08 04:21:02 | Himachal Pradesh, India | |||
114684 | 114684 | 2022-09-06 | India | Himachal Pradesh | 311413 | 4202 | 0 | 31.927213 | 77.233081 | 2022-09-07 04:20:59 | Himachal Pradesh, India | |||
2633656 | 2633656 | 2022-09-05 | India | Himachal Pradesh | 311341 | 4202 | 0 | 31.927213 | 77.233081 | 2022-09-06 04:21:02 | Himachal Pradesh, India | |||
2987220 | 2987220 | 2022-09-04 | India | Himachal Pradesh | 311300 | 4202 | 0 | 31.927213 | 77.233081 | 2022-09-05 04:21:01 | Himachal Pradesh, India | |||
2712905 | 2712905 | 2022-09-03 | India | Himachal Pradesh | 311266 | 4202 | 0 | 31.927213 | 77.233081 | 2022-09-04 04:21:22 | Himachal Pradesh, India | |||
1393610 | 1393610 | 2022-09-02 | India | Himachal Pradesh | 311191 | 4202 | 0 | 31.927213 | 77.233081 | 2022-09-03 04:21:04 | Himachal Pradesh, India | |||
3547439 | 3547439 | 2022-09-01 | India | Himachal Pradesh | 311104 | 4202 | 0 | 31.927213 | 77.233081 | 2022-09-02 04:21:07 | Himachal Pradesh, India | |||
2343359 | 2343359 | 2022-08-31 | India | Himachal Pradesh | 310983 | 4201 | 0 | 31.927213 | 77.233081 | 2022-09-01 04:21:03 | Himachal Pradesh, India | |||
3773839 | 3773839 | 2022-08-30 | India | Himachal Pradesh | 310643 | 4199 | 0 | 31.927213 | 77.233081 | 2022-08-31 04:20:57 | Himachal Pradesh, India | |||
1680435 | 1680435 | 2022-08-29 | India | Himachal Pradesh | 310643 | 4199 | 0 | 31.927213 | 77.233081 | 2022-08-30 04:21:03 | Himachal Pradesh, India | |||
1876919 | 1876919 | 2022-08-28 | India | Himachal Pradesh | 310643 | 4199 | 0 | 31.927213 | 77.233081 | 2022-08-29 04:21:06 | Himachal Pradesh, India | |||
2096046 | 2096046 | 2022-08-27 | India | Himachal Pradesh | 310576 | 4199 | 0 | 31.927213 | 77.233081 | 2022-08-28 04:21:02 | Himachal Pradesh, India | |||
1531861 | 1531861 | 2022-08-26 | India | Himachal Pradesh | 310428 | 4197 | 0 | 31.927213 | 77.233081 | 2022-08-27 04:20:57 | Himachal Pradesh, India | |||
2828748 | 2828748 | 2022-08-25 | India | Himachal Pradesh | 310271 | 4194 | 0 | 31.927213 | 77.233081 | 2022-08-26 04:21:02 | Himachal Pradesh, India | |||
2323281 | 2323281 | 2022-08-24 | India | Himachal Pradesh | 310064 | 4194 | 0 | 31.927213 | 77.233081 | 2022-08-25 04:21:13 | Himachal Pradesh, India | |||
1250690 | 1250690 | 2022-08-23 | India | Himachal Pradesh | 309866 | 4193 | 0 | 31.927213 | 77.233081 | 2022-08-24 04:20:46 | Himachal Pradesh, India | |||
2852794 | 2852794 | 2022-08-22 | India | Himachal Pradesh | 309589 | 4193 | 0 | 31.927213 | 77.233081 | 2022-08-23 04:20:56 | Himachal Pradesh, India | |||
2402766 | 2402766 | 2022-08-21 | India | Himachal Pradesh | 309351 | 4191 | 0 | 31.927213 | 77.233081 | 2022-08-22 04:20:38 | Himachal Pradesh, India | |||
3797844 | 3797844 | 2022-08-20 | India | Himachal Pradesh | 309301 | 4189 | 0 | 31.927213 | 77.233081 | 2022-08-21 04:20:44 | Himachal Pradesh, India | |||
2363430 | 2363430 | 2022-08-19 | India | Himachal Pradesh | 309058 | 4188 | 0 | 31.927213 | 77.233081 | 2022-08-20 04:21:01 | Himachal Pradesh, India | |||
1161101 | 1161101 | 2022-08-18 | India | Himachal Pradesh | 308944 | 4187 | 0 | 31.927213 | 77.233081 | 2022-08-19 04:20:54 | Himachal Pradesh, India | |||
3950425 | 3950425 | 2022-08-17 | India | Himachal Pradesh | 308556 | 4186 | 0 | 31.927213 | 77.233081 | 2022-08-18 04:21:11 | Himachal Pradesh, India | |||
990927 | 990927 | 2022-08-16 | India | Himachal Pradesh | 308133 | 4186 | 0 | 31.927213 | 77.233081 | 2022-08-17 04:20:59 | Himachal Pradesh, India | |||
2493966 | 2493966 | 2022-08-15 | India | Himachal Pradesh | 307687 | 4184 | 0 | 31.927213 | 77.233081 | 2022-08-16 04:20:58 | Himachal Pradesh, India | |||
3647516 | 3647516 | 2022-08-14 | India | Himachal Pradesh | 307628 | 4184 | 0 | 31.927213 | 77.233081 | 2022-08-15 04:20:59 | Himachal Pradesh, India | |||
1968522 | 1968522 | 2022-08-13 | India | Himachal Pradesh | 307482 | 4183 | 0 | 31.927213 | 77.233081 | 2022-08-14 04:20:55 | Himachal Pradesh, India | |||
2888331 | 2888331 | 2022-08-12 | India | Himachal Pradesh | 307061 | 4182 | 0 | 31.927213 | 77.233081 | 2022-08-13 04:20:52 | Himachal Pradesh, India | |||
3907936 | 3907936 | 2022-08-11 | India | Himachal Pradesh | 306618 | 4181 | 0 | 31.927213 | 77.233081 | 2022-08-12 04:20:54 | Himachal Pradesh, India | |||
1346253 | 1346253 | 2022-08-10 | India | Himachal Pradesh | 306269 | 4181 | 0 | 31.927213 | 77.233081 | 2022-08-11 04:20:49 | Himachal Pradesh, India | |||
1086008 | 1086008 | 2022-08-09 | India | Himachal Pradesh | 305743 | 4180 | 0 | 31.927213 | 77.233081 | 2022-08-10 04:20:57 | Himachal Pradesh, India | |||
3543423 | 3543423 | 2022-08-08 | India | Himachal Pradesh | 305383 | 4177 | 0 | 31.927213 | 77.233081 | 2022-08-09 04:20:34 | Himachal Pradesh, India | |||
1069826 | 1069826 | 2022-08-07 | India | Himachal Pradesh | 304436 | 4174 | 0 | 31.927213 | 77.233081 | 2022-08-08 04:21:08 | Himachal Pradesh, India | |||
1940414 | 1940414 | 2022-08-06 | India | Himachal Pradesh | 304436 | 4174 | 0 | 31.927213 | 77.233081 | 2022-08-07 04:20:54 | Himachal Pradesh, India | |||
880213 | 880213 | 2022-08-05 | India | Himachal Pradesh | 303750 | 4173 | 0 | 31.927213 | 77.233081 | 2022-08-06 04:20:56 | Himachal Pradesh, India | |||
2008624 | 2008624 | 2022-08-04 | India | Himachal Pradesh | 302970 | 4171 | 0 | 31.927213 | 77.233081 | 2022-08-05 04:20:52 | Himachal Pradesh, India | |||
1098051 | 1098051 | 2022-08-03 | India | Himachal Pradesh | 302179 | 4170 | 0 | 31.927213 | 77.233081 | 2022-08-04 04:20:58 | Himachal Pradesh, India | |||
1404976 | 1404976 | 2022-08-02 | India | Himachal Pradesh | 301214 | 4166 | 0 | 31.927213 | 77.233081 | 2022-08-03 04:20:59 | Himachal Pradesh, India | |||
3617014 | 3617014 | 2022-08-01 | India | Himachal Pradesh | 300380 | 4164 | 0 | 31.927213 | 77.233081 | 2022-08-02 04:20:53 | Himachal Pradesh, India | |||
3871494 | 3871494 | 2022-07-31 | India | Himachal Pradesh | 299521 | 4161 | 0 | 31.927213 | 77.233081 | 2022-08-01 04:21:03 | Himachal Pradesh, India | |||
674248 | 674248 | 2022-07-30 | India | Himachal Pradesh | 299323 | 4161 | 0 | 31.927213 | 77.233081 | 2022-07-31 04:21:02 | Himachal Pradesh, India | |||
1783447 | 1783447 | 2022-07-29 | India | Himachal Pradesh | 298450 | 4159 | 0 | 31.927213 | 77.233081 | 2022-07-30 04:20:42 | Himachal Pradesh, India | |||
1065810 | 1065810 | 2022-07-28 | India | Himachal Pradesh | 296590 | 4158 | 0 | 31.927213 | 77.233081 | 2022-07-29 04:20:45 | Himachal Pradesh, India | |||
2335329 | 2335329 | 2022-07-27 | India | Himachal Pradesh | 296590 | 4158 | 0 | 31.927213 | 77.233081 | 2022-07-28 04:20:56 | Himachal Pradesh, India | |||
1487519 | 1487519 | 2022-07-26 | India | Himachal Pradesh | 295674 | 4157 | 0 | 31.927213 | 77.233081 | 2022-07-27 04:21:04 | Himachal Pradesh, India | |||
2593965 | 2593965 | 2022-07-25 | India | Himachal Pradesh | 294688 | 4156 | 0 | 31.927213 | 77.233081 | 2022-07-26 04:20:58 | Himachal Pradesh, India | |||
896080 | 896080 | 2022-07-24 | India | Himachal Pradesh | 293969 | 4156 | 0 | 31.927213 | 77.233081 | 2022-07-25 04:20:51 | Himachal Pradesh, India | |||
91074 | 91074 | 2022-07-23 | India | Himachal Pradesh | 293688 | 4156 | 0 | 31.927213 | 77.233081 | 2022-07-24 04:20:47 | Himachal Pradesh, India | |||
900096 | 900096 | 2022-07-22 | India | Himachal Pradesh | 293018 | 4152 | 0 | 31.927213 | 77.233081 | 2022-07-23 04:20:53 | Himachal Pradesh, India | |||
670232 | 670232 | 2022-07-21 | India | Himachal Pradesh | 292266 | 4152 | 0 | 31.927213 | 77.233081 | 2022-07-22 04:21:15 | Himachal Pradesh, India | |||
1608195 | 1608195 | 2022-07-20 | India | Himachal Pradesh | 291669 | 4149 | 0 | 31.927213 | 77.233081 | 2022-07-21 04:21:10 | Himachal Pradesh, India | |||
958828 | 958828 | 2022-07-19 | India | Himachal Pradesh | 291086 | 4148 | 0 | 31.927213 | 77.233081 | 2022-07-20 04:20:59 | Himachal Pradesh, India | |||
3210215 | 3210215 | 2022-07-18 | India | Himachal Pradesh | 290470 | 4148 | 0 | 31.927213 | 77.233081 | 2022-07-19 04:20:58 | Himachal Pradesh, India | |||
3405390 | 3405390 | 2022-07-17 | India | Himachal Pradesh | 289906 | 4148 | 0 | 31.927213 | 77.233081 | 2022-07-18 04:20:59 | Himachal Pradesh, India | |||
2151590 | 2151590 | 2022-07-16 | India | Himachal Pradesh | 289781 | 4148 | 0 | 31.927213 | 77.233081 | 2022-07-17 04:21:15 | Himachal Pradesh, India | |||
2418823 | 2418823 | 2022-07-15 | India | Himachal Pradesh | 289353 | 4147 | 0 | 31.927213 | 77.233081 | 2022-07-16 04:21:05 | Himachal Pradesh, India | |||
3428898 | 3428898 | 2022-07-14 | India | Himachal Pradesh | 288915 | 4145 | 0 | 31.927213 | 77.233081 | 2022-07-15 04:20:53 | Himachal Pradesh, India | |||
3109418 | 3109418 | 2022-07-13 | India | Himachal Pradesh | 288493 | 4144 | 0 | 31.927213 | 77.233081 | 2022-07-14 04:20:57 | Himachal Pradesh, India | |||
629841 | 629841 | 2022-07-12 | India | Himachal Pradesh | 288135 | 4144 | 0 | 31.927213 | 77.233081 | 2022-07-13 04:20:58 | Himachal Pradesh, India | |||
1211485 | 1211485 | 2022-07-11 | India | Himachal Pradesh | 287779 | 4144 | 0 | 31.927213 | 77.233081 | 2022-07-12 04:20:51 | Himachal Pradesh, India | |||
2788967 | 2788967 | 2022-07-10 | India | Himachal Pradesh | 287535 | 4143 | 0 | 31.927213 | 77.233081 | 2022-07-11 04:20:46 | Himachal Pradesh, India | |||
141920 | 141920 | 2022-07-09 | India | Himachal Pradesh | 287464 | 4142 | 0 | 31.927213 | 77.233081 | 2022-07-10 04:20:54 | Himachal Pradesh, India | |||
1417020 | 1417020 | 2022-07-08 | India | Himachal Pradesh | 287285 | 4142 | 0 | 31.927213 | 77.233081 | 2022-07-09 04:20:59 | Himachal Pradesh, India | |||
2740945 | 2740945 | 2022-07-07 | India | Himachal Pradesh | 287094 | 4141 | 0 | 31.927213 | 77.233081 | 2022-07-08 04:20:56 | Himachal Pradesh, India | |||
1199740 | 1199740 | 2022-07-06 | India | Himachal Pradesh | 286905 | 4141 | 0 | 31.927213 | 77.233081 | 2022-07-07 04:20:55 | Himachal Pradesh, India | |||
3966483 | 3966483 | 2022-07-05 | India | Himachal Pradesh | 286761 | 4141 | 0 | 31.927213 | 77.233081 | 2022-07-06 04:20:58 | Himachal Pradesh, India | |||
3077994 | 3077994 | 2022-07-04 | India | Himachal Pradesh | 286547 | 4141 | 0 | 31.927213 | 77.233081 | 2022-07-05 04:20:45 | Himachal Pradesh, India | |||
1767276 | 1767276 | 2022-07-03 | India | Himachal Pradesh | 286414 | 4141 | 0 | 31.927213 | 77.233081 | 2022-07-04 04:20:54 | Himachal Pradesh, India | |||
3365262 | 3365262 | 2022-07-02 | India | Himachal Pradesh | 286371 | 4141 | 0 | 31.927213 | 77.233081 | 2022-07-03 04:20:59 | Himachal Pradesh, India | |||
593591 | 593591 | 2022-07-01 | India | Himachal Pradesh | 286261 | 4141 | 0 | 31.927213 | 77.233081 | 2022-07-02 04:21:16 | Himachal Pradesh, India | |||
3939992 | 3939992 | 2022-06-30 | India | Himachal Pradesh | 286157 | 4141 | 0 | 31.927213 | 77.233081 | 2022-07-01 04:21:10 | Himachal Pradesh, India | |||
2489950 | 2489950 | 2022-06-29 | India | Himachal Pradesh | 286061 | 4141 | 0 | 31.927213 | 77.233081 | 2022-06-30 04:21:01 | Himachal Pradesh, India | |||
2239332 | 2239332 | 2022-06-28 | India | Himachal Pradesh | 285956 | 4141 | 0 | 31.927213 | 77.233081 | 2022-06-29 04:20:59 | Himachal Pradesh, India | |||
2147574 | 2147574 | 2022-06-27 | India | Himachal Pradesh | 285836 | 4141 | 0 | 31.927213 | 77.233081 | 2022-06-28 04:20:58 | Himachal Pradesh, India | |||
475375 | 475375 | 2022-06-26 | India | Himachal Pradesh | 285742 | 4141 | 0 | 31.927213 | 77.233081 | 2022-06-27 04:21:00 | Himachal Pradesh, India | |||
938750 | 938750 | 2022-06-25 | India | Himachal Pradesh | 285705 | 4141 | 0 | 31.927213 | 77.233081 | 2022-06-26 04:21:02 | Himachal Pradesh, India | |||
3346570 | 3346570 | 2022-06-24 | India | Himachal Pradesh | 285642 | 4140 | 0 | 31.927213 | 77.233081 | 2022-06-25 04:20:57 | Himachal Pradesh, India | |||
1648311 | 1648311 | 2022-06-23 | India | Himachal Pradesh | 285594 | 4140 | 0 | 31.927213 | 77.233081 | 2022-06-24 04:20:58 | Himachal Pradesh, India | |||
2187546 | 2187546 | 2022-06-22 | India | Himachal Pradesh | 285547 | 4139 | 0 | 31.927213 | 77.233081 | 2022-06-23 04:20:55 | Himachal Pradesh, India | |||
165977 | 165977 | 2022-06-21 | India | Himachal Pradesh | 285507 | 4138 | 0 | 31.927213 | 77.233081 | 2022-06-22 04:20:54 | Himachal Pradesh, India | |||
1763260 | 1763260 | 2022-06-20 | India | Himachal Pradesh | 285467 | 4138 | 0 | 31.927213 | 77.233081 | 2022-06-21 04:20:56 | Himachal Pradesh, India | |||
3269446 | 3269446 | 2022-06-19 | India | Himachal Pradesh | 285416 | 4137 | 0 | 31.927213 | 77.233081 | 2022-06-20 04:21:01 | Himachal Pradesh, India | |||
3397358 | 3397358 | 2022-06-18 | India | Himachal Pradesh | 285408 | 4137 | 0 | 31.927213 | 77.233081 | 2022-06-19 04:20:51 | Himachal Pradesh, India | |||
2311235 | 2311235 | 2022-06-17 | India | Himachal Pradesh | 285378 | 4137 | 0 | 31.927213 | 77.233081 | 2022-06-18 04:21:10 | Himachal Pradesh, India | |||
558739 | 558739 | 2022-06-16 | India | Himachal Pradesh | 285347 | 4137 | 0 | 31.927213 | 77.233081 | 2022-06-17 04:20:56 | Himachal Pradesh, India | |||
3982541 | 3982541 | 2022-06-15 | India | Himachal Pradesh | 285321 | 4137 | 0 | 31.927213 | 77.233081 | 2022-06-16 04:20:55 | Himachal Pradesh, India | |||
946782 | 946782 | 2022-06-14 | India | Himachal Pradesh | 285281 | 4136 | 0 | 31.927213 | 77.233081 | 2022-06-15 04:20:54 | Himachal Pradesh, India | |||
2979190 | 2979190 | 2022-06-13 | India | Himachal Pradesh | 285273 | 4136 | 0 | 31.927213 | 77.233081 | 2022-06-14 04:20:52 | 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]);