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 recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, active, latitude, last_update, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
262 | 262 | 2021-12-02 | India | Himachal Pradesh | 227354 | 3850 | 0 | 31.927213000000002 | 77.233081 | 2021-12-03 04:23:05 | 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 | |||
16303 | 16303 | 2021-09-18 | India | Himachal Pradesh | 216813 | 3649 | 0 | 31.927213000000002 | 77.233081 | 2021-09-19 04:21:34 | Himachal Pradesh, India | |||
24333 | 24333 | 2022-03-20 | India | Himachal Pradesh | 284338 | 4132 | 0 | 31.927213000000002 | 77.233081 | 2022-03-21 04:20:50 | 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 | |||
32364 | 32364 | 2021-08-25 | India | Himachal Pradesh | 212458 | 3579 | 0 | 31.927213000000002 | 77.233081 | 2021-08-26 04:21:28 | 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 | |||
62994 | 62994 | 2022-11-12 | India | Himachal Pradesh | 312512 | 4211 | 0 | 31.927213 | 77.233081 | 2022-11-13 04:21:14 | 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 | |||
71023 | 71023 | 2022-02-07 | India | Himachal Pradesh | 277236 | 4051 | 0 | 31.927213000000002 | 77.233081 | 2022-02-08 04:21:15 | 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 | |||
91074 | 91074 | 2022-07-23 | India | Himachal Pradesh | 293688 | 4156 | 0 | 31.927213 | 77.233081 | 2022-07-24 04:20:47 | Himachal Pradesh, India | |||
99258 | 99258 | 2022-01-14 | India | Himachal Pradesh | 240330 | 3889 | 0 | 31.927213000000002 | 77.233081 | 2022-01-15 04:21:07 | 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 | |||
114684 | 114684 | 2022-09-06 | India | Himachal Pradesh | 311413 | 4202 | 0 | 31.927213 | 77.233081 | 2022-09-07 04:20:59 | 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 | |||
130682 | 130682 | 2022-10-04 | India | Himachal Pradesh | 312267 | 4210 | 0 | 31.927213 | 77.233081 | 2022-10-05 04:23:06 | 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 | |||
141920 | 141920 | 2022-07-09 | India | Himachal Pradesh | 287464 | 4142 | 0 | 31.927213 | 77.233081 | 2022-07-10 04:20:54 | 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 | |||
157945 | 157945 | 2022-03-29 | India | Himachal Pradesh | 284504 | 4133 | 0 | 31.927213000000002 | 77.233081 | 2022-03-30 04:20:45 | 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 | |||
165977 | 165977 | 2022-06-21 | India | Himachal Pradesh | 285507 | 4138 | 0 | 31.927213 | 77.233081 | 2022-06-22 04:20:54 | 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 | |||
186003 | 186003 | 2022-02-13 | India | Himachal Pradesh | 280269 | 4083 | 0 | 31.927213000000002 | 77.233081 | 2022-02-14 04:20:51 | Himachal Pradesh, India | |||
198191 | 198191 | 2022-10-19 | India | Himachal Pradesh | 312403 | 4211 | 0 | 31.927213 | 77.233081 | 2022-10-20 04:22:59 | Himachal Pradesh, India | |||
217912 | 217912 | 2022-12-26 | India | Himachal Pradesh | 312641 | 4213 | 0 | 31.927213 | 77.233081 | 2022-12-27 04:21:07 | Himachal Pradesh, India | |||
221928 | 221928 | 2022-05-09 | India | Himachal Pradesh | 284874 | 4134 | 0 | 31.927213 | 77.233081 | 2022-05-10 04:20:50 | Himachal Pradesh, India | |||
229159 | 229159 | 2022-05-31 | India | Himachal Pradesh | 285059 | 4136 | 0 | 31.927213 | 77.233081 | 2022-06-01 04:20:55 | Himachal Pradesh, India | |||
233175 | 233175 | 2022-02-11 | India | Himachal Pradesh | 279697 | 4076 | 0 | 31.927213000000002 | 77.233081 | 2022-02-12 04:21:06 | 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 | |||
249231 | 249231 | 2021-09-04 | India | Himachal Pradesh | 214408 | 3609 | 0 | 31.927213000000002 | 77.233081 | 2021-09-05 04:21:33 | 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 | |||
257262 | 257262 | 2022-12-10 | India | Himachal Pradesh | 312595 | 4213 | 0 | 31.927213 | 77.233081 | 2022-12-11 04:20:50 | Himachal Pradesh, India | |||
261465 | 261465 | 2022-03-15 | India | Himachal Pradesh | 284221 | 4129 | 0 | 31.927213000000002 | 77.233081 | 2022-03-16 04:20:50 | 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 | |||
287928 | 287928 | 2021-10-31 | India | Himachal Pradesh | 224106 | 3754 | 0 | 31.927213000000002 | 77.233081 | 2021-11-01 04:22:01 | Himachal Pradesh, India | |||
291945 | 291945 | 2022-11-15 | India | Himachal Pradesh | 312516 | 4211 | 0 | 31.927213 | 77.233081 | 2022-11-16 04:21:09 | Himachal Pradesh, India | |||
303801 | 303801 | 2022-04-16 | India | Himachal Pradesh | 284681 | 4134 | 0 | 31.927213000000002 | 77.233081 | 2022-04-17 04:20:59 | Himachal Pradesh, India | |||
307817 | 307817 | 2022-12-13 | India | Himachal Pradesh | 312598 | 4213 | 0 | 31.927213 | 77.233081 | 2022-12-14 04:21:04 | Himachal Pradesh, India | |||
311833 | 311833 | 2022-11-13 | India | Himachal Pradesh | 312512 | 4211 | 0 | 31.927213 | 77.233081 | 2022-11-14 04:21:09 | Himachal Pradesh, India | |||
315849 | 315849 | 2022-02-12 | India | Himachal Pradesh | 280106 | 4080 | 0 | 31.927213000000002 | 77.233081 | 2022-02-13 04:21:00 | Himachal Pradesh, India | |||
319865 | 319865 | 2022-10-30 | India | Himachal Pradesh | 312447 | 4211 | 0 | 31.927213 | 77.233081 | 2022-10-31 04:21:36 | Himachal Pradesh, India | |||
327839 | 327839 | 2022-12-27 | India | Himachal Pradesh | 312643 | 4213 | 0 | 31.927213 | 77.233081 | 2022-12-28 04:21:04 | Himachal Pradesh, India | |||
335869 | 335869 | 2022-03-18 | India | Himachal Pradesh | 284304 | 4132 | 0 | 31.927213000000002 | 77.233081 | 2022-03-19 04:20:47 | Himachal Pradesh, India | |||
348229 | 348229 | 2022-12-14 | India | Himachal Pradesh | 312601 | 4213 | 0 | 31.927213 | 77.233081 | 2022-12-15 04:20:58 | Himachal Pradesh, India | |||
356259 | 356259 | 2022-03-11 | India | Himachal Pradesh | 284030 | 4125 | 0 | 31.927213000000002 | 77.233081 | 2022-03-12 04:20:50 | Himachal Pradesh, India | |||
360275 | 360275 | 2022-05-07 | India | Himachal Pradesh | 284862 | 4134 | 0 | 31.927213 | 77.233081 | 2022-05-08 04:20:49 | 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 | |||
384156 | 384156 | 2022-09-23 | India | Himachal Pradesh | 312063 | 4208 | 0 | 31.927213 | 77.233081 | 2022-09-24 04:21:40 | Himachal Pradesh, India | |||
396197 | 396197 | 2022-10-07 | India | Himachal Pradesh | 312308 | 4210 | 0 | 31.927213 | 77.233081 | 2022-10-08 04:22:56 | 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 | |||
419268 | 419268 | 2022-09-18 | India | Himachal Pradesh | 311911 | 4208 | 0 | 31.927213 | 77.233081 | 2022-09-19 04:21:49 | 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 | |||
431290 | 431290 | 2022-11-03 | India | Himachal Pradesh | 312465 | 4211 | 0 | 31.927213 | 77.233081 | 2022-11-04 04:22:11 | 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 | |||
447303 | 447303 | 2021-11-17 | India | Himachal Pradesh | 226118 | 3823 | 0 | 31.927213000000002 | 77.233081 | 2021-11-18 04:21:33 | Himachal Pradesh, India | |||
451320 | 451320 | 2022-12-21 | India | Himachal Pradesh | 312620 | 4213 | 0 | 31.927213 | 77.233081 | 2022-12-22 04:20:56 | Himachal Pradesh, India | |||
459312 | 459312 | 2022-02-02 | India | Himachal Pradesh | 273243 | 4007 | 0 | 31.927213000000002 | 77.233081 | 2022-02-03 04:21:21 | Himachal Pradesh, India | |||
463329 | 463329 | 2022-05-02 | India | Himachal Pradesh | 284822 | 4134 | 0 | 31.927213 | 77.233081 | 2022-05-03 04:21:00 | 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 | |||
475375 | 475375 | 2022-06-26 | India | Himachal Pradesh | 285742 | 4141 | 0 | 31.927213 | 77.233081 | 2022-06-27 04:21:00 | Himachal Pradesh, India | |||
479523 | 479523 | 2022-11-08 | India | Himachal Pradesh | 312478 | 4211 | 0 | 31.927213 | 77.233081 | 2022-11-09 04:21:22 | Himachal Pradesh, India | |||
487553 | 487553 | 2022-11-25 | India | Himachal Pradesh | 312558 | 4211 | 0 | 31.927213 | 77.233081 | 2022-11-26 04:21:11 | 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 | |||
495584 | 495584 | 2021-11-06 | India | Himachal Pradesh | 224830 | 3774 | 0 | 31.927213000000002 | 77.233081 | 2021-11-07 04:21:53 | Himachal Pradesh, India | |||
499601 | 499601 | 2022-04-02 | India | Himachal Pradesh | 284558 | 4133 | 0 | 31.927213000000002 | 77.233081 | 2022-04-03 04:20:48 | Himachal Pradesh, India | |||
503617 | 503617 | 2022-12-17 | India | Himachal Pradesh | 312611 | 4213 | 0 | 31.927213 | 77.233081 | 2022-12-18 04:21:03 | 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 | |||
511646 | 511646 | 2021-08-19 | India | Himachal Pradesh | 211277 | 3559 | 0 | 31.927213000000002 | 77.233081 | 2021-08-20 04:21:33 | Himachal Pradesh, India | |||
515661 | 515661 | 2022-10-15 | India | Himachal Pradesh | 312376 | 4210 | 0 | 31.927213 | 77.233081 | 2022-10-16 04:22:39 | 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 | |||
538685 | 538685 | 2022-10-26 | India | Himachal Pradesh | 312432 | 4211 | 0 | 31.927213 | 77.233081 | 2022-10-27 04:22:01 | Himachal Pradesh, India | |||
542701 | 542701 | 2022-12-15 | India | Himachal Pradesh | 312604 | 4213 | 0 | 31.927213 | 77.233081 | 2022-12-16 04:21:01 | 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 | |||
554722 | 554722 | 2022-01-16 | India | Himachal Pradesh | 243365 | 3891 | 0 | 31.927213000000002 | 77.233081 | 2022-01-17 04:21:08 | 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 | |||
567036 | 567036 | 2021-10-29 | India | Himachal Pradesh | 223876 | 3748 | 0 | 31.927213000000002 | 77.233081 | 2021-10-30 04:22:03 | Himachal Pradesh, India | |||
574765 | 574765 | 2022-02-25 | India | Himachal Pradesh | 283073 | 4114 | 0 | 31.927213000000002 | 77.233081 | 2022-02-26 04:21:12 | 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 | |||
593591 | 593591 | 2022-07-01 | India | Himachal Pradesh | 286261 | 4141 | 0 | 31.927213 | 77.233081 | 2022-07-02 04:21:16 | 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 | |||
601622 | 601622 | 2021-09-23 | India | Himachal Pradesh | 217776 | 3662 | 0 | 31.927213000000002 | 77.233081 | 2021-09-24 04:21:44 | Himachal Pradesh, India | |||
617795 | 617795 | 2022-11-05 | India | Himachal Pradesh | 312478 | 4211 | 0 | 31.927213 | 77.233081 | 2022-11-06 04:21:24 | Himachal Pradesh, India | |||
621811 | 621811 | 2022-05-22 | India | Himachal Pradesh | 285020 | 4136 | 0 | 31.927213 | 77.233081 | 2022-05-26 04:20:50 | 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 | |||
633856 | 633856 | 2021-10-13 | India | Himachal Pradesh | 220931 | 3711 | 0 | 31.927213000000002 | 77.233081 | 2021-10-14 04:21:29 | 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 | |||
649914 | 649914 | 2021-08-09 | India | Himachal Pradesh | 208197 | 3535 | 0 | 31.927213000000002 | 77.233081 | 2021-08-10 04:21:27 | 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 | |||
658247 | 658247 | 2022-05-13 | India | Himachal Pradesh | 284926 | 4136 | 0 | 31.927213 | 77.233081 | 2022-05-14 04:20:48 | 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 | |||
674248 | 674248 | 2022-07-30 | India | Himachal Pradesh | 299323 | 4161 | 0 | 31.927213 | 77.233081 | 2022-07-31 04:21:02 | 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 | |||
686289 | 686289 | 2021-11-13 | India | Himachal Pradesh | 225712 | 3812 | 0 | 31.927213000000002 | 77.233081 | 2021-11-14 04:21:31 | Himachal Pradesh, India | |||
690306 | 690306 | 2022-12-23 | India | Himachal Pradesh | 312630 | 4213 | 0 | 31.927213 | 77.233081 | 2022-12-24 04:21:02 | Himachal Pradesh, India | |||
694322 | 694322 | 2022-03-17 | India | Himachal Pradesh | 284293 | 4130 | 0 | 31.927213000000002 | 77.233081 | 2022-03-18 04:20:55 | 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 | |||
706367 | 706367 | 2021-09-29 | India | Himachal Pradesh | 218898 | 3675 | 0 | 31.927213000000002 | 77.233081 | 2021-09-30 04:21:20 | Himachal Pradesh, India | |||
710383 | 710383 | 2022-11-01 | India | Himachal Pradesh | 312458 | 4211 | 0 | 31.927213 | 77.233081 | 2022-11-02 04:22:09 | 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]);