daily_reports (view)
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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
last_update (date) >30 ✖
- 2022-04-13 2
- 2022-05-26 2
- 2020-06-11 1
- 2020-06-12 1
- 2020-06-13 1
- 2020-06-14 1
- 2020-06-15 1
- 2020-06-16 1
- 2020-06-17 1
- 2020-06-18 1
- 2020-06-19 1
- 2020-06-20 1
- 2020-06-21 1
- 2020-06-22 1
- 2020-06-23 1
- 2020-06-24 1
- 2020-06-25 1
- 2020-06-26 1
- 2020-06-27 1
- 2020-06-28 1
- 2020-06-29 1
- 2020-06-30 1
- 2020-07-01 1
- 2020-07-02 1
- 2020-07-03 1
- 2020-07-04 1
- 2020-07-05 1
- 2020-07-06 1
- 2020-07-07 1
- 2020-07-08 1
- …
province_or_state 1
- Himachal Pradesh · 933 ✖
country_or_region 1
- India · 933 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-06-10 | India | Himachal Pradesh | 445 | 5 | 249 | 191 | 31.927213 | 77.233081 | 2020-06-11 03:33:41 | Himachal Pradesh, India | ||
2020-06-12 | India | Himachal Pradesh | 470 | 6 | 280 | 184 | 31.927213000000002 | 77.233081 | 2020-06-13 03:33:14 | Himachal Pradesh, India | ||
2020-06-11 | India | Himachal Pradesh | 470 | 6 | 280 | 184 | 31.927213000000002 | 77.233081 | 2020-06-12 05:09:52 | Himachal Pradesh, India | ||
2020-06-14 | India | Himachal Pradesh | 502 | 6 | 313 | 183 | 31.927213000000002 | 77.233081 | 2020-06-15 03:33:14 | Himachal Pradesh, India | ||
2020-06-13 | India | Himachal Pradesh | 486 | 6 | 297 | 183 | 31.927213000000002 | 77.233081 | 2020-06-14 03:33:15 | Himachal Pradesh, India | ||
2020-06-15 | India | Himachal Pradesh | 556 | 8 | 353 | 195 | 31.927213000000002 | 77.233081 | 2020-06-16 04:33:09 | Himachal Pradesh, India | ||
2020-06-17 | India | Himachal Pradesh | 569 | 8 | 372 | 189 | 31.927213000000002 | 77.233081 | 2020-06-18 04:33:18 | Himachal Pradesh, India | ||
2020-06-22 | India | Himachal Pradesh | 727 | 8 | 437 | 282 | 31.927213000000002 | 77.233081 | 2020-06-23 04:33:22 | Himachal Pradesh, India | ||
2020-06-23 | India | Himachal Pradesh | 775 | 8 | 443 | 324 | 31.927213000000002 | 77.233081 | 2020-06-24 04:33:28 | Himachal Pradesh, India | ||
2020-06-19 | India | Himachal Pradesh | 619 | 8 | 388 | 223 | 31.927213000000002 | 77.233081 | 2020-06-20 04:33:19 | Himachal Pradesh, India | ||
2020-06-16 | India | Himachal Pradesh | 560 | 8 | 372 | 180 | 31.927213000000002 | 77.233081 | 2020-06-17 04:33:21 | Himachal Pradesh, India | ||
2020-06-20 | India | Himachal Pradesh | 656 | 8 | 413 | 235 | 31.927213000000002 | 77.233081 | 2020-06-21 04:33:19 | Himachal Pradesh, India | ||
2020-06-24 | India | Himachal Pradesh | 806 | 8 | 466 | 332 | 31.927213000000002 | 77.233081 | 2020-06-25 05:26:54 | Himachal Pradesh, India | ||
2020-06-21 | India | Himachal Pradesh | 673 | 8 | 425 | 240 | 31.927213000000002 | 77.233081 | 2020-06-22 04:33:20 | Himachal Pradesh, India | ||
2020-06-18 | India | Himachal Pradesh | 595 | 8 | 382 | 205 | 31.927213000000002 | 77.233081 | 2020-06-19 04:33:17 | Himachal Pradesh, India | ||
2020-06-26 | India | Himachal Pradesh | 864 | 9 | 502 | 353 | 31.927213000000002 | 77.233081 | 2020-06-27 04:33:35 | Himachal Pradesh, India | ||
2020-06-27 | India | Himachal Pradesh | 894 | 9 | 509 | 376 | 31.927213000000002 | 77.233081 | 2020-06-28 04:34:04 | Himachal Pradesh, India | ||
2020-06-28 | India | Himachal Pradesh | 916 | 9 | 529 | 378 | 31.927213000000002 | 77.233081 | 2020-06-29 04:33:44 | Himachal Pradesh, India | ||
2020-06-25 | India | Himachal Pradesh | 839 | 9 | 477 | 353 | 31.927213000000002 | 77.233081 | 2020-06-26 04:33:43 | Himachal Pradesh, India | ||
2020-06-29 | India | Himachal Pradesh | 942 | 9 | 556 | 377 | 31.927213 | 77.233081 | 2020-06-30 04:33:48 | Himachal Pradesh, India | ||
2020-07-01 | India | Himachal Pradesh | 979 | 10 | 614 | 355 | 31.927213000000002 | 77.233081 | 2020-07-02 04:33:46 | Himachal Pradesh, India | ||
2020-07-03 | India | Himachal Pradesh | 1033 | 10 | 667 | 356 | 31.927213000000002 | 77.233081 | 2020-07-04 04:33:51 | Himachal Pradesh, India | ||
2020-06-30 | India | Himachal Pradesh | 953 | 10 | 580 | 363 | 31.927213000000002 | 77.233081 | 2020-07-01 04:33:52 | Himachal Pradesh, India | ||
2020-07-02 | India | Himachal Pradesh | 1014 | 10 | 628 | 376 | 31.927213 | 77.233081 | 2020-07-03 04:33:54 | Himachal Pradesh, India | ||
2020-07-23 | India | Himachal Pradesh | 1834 | 11 | 1136 | 687 | 31.927213 | 77.233081 | 2020-07-24 05:30:40 | Himachal Pradesh, India | ||
2020-07-19 | India | Himachal Pradesh | 1483 | 11 | 1059 | 413 | 31.927213000000002 | 77.233081 | 2020-07-20 05:34:40 | Himachal Pradesh, India | ||
2020-07-20 | India | Himachal Pradesh | 1631 | 11 | 1067 | 553 | 31.927213000000002 | 77.233081 | 2020-07-21 04:38:46 | Himachal Pradesh, India | ||
2020-07-16 | India | Himachal Pradesh | 1377 | 11 | 984 | 382 | 31.927213 | 77.233081 | 2020-07-17 04:34:50 | Himachal Pradesh, India | ||
2020-07-05 | India | Himachal Pradesh | 1063 | 11 | 737 | 315 | 31.927213000000002 | 77.233081 | 2020-07-06 04:33:57 | Himachal Pradesh, India | ||
2020-07-04 | India | Himachal Pradesh | 1046 | 11 | 704 | 331 | 31.927213000000002 | 77.233081 | 2020-07-05 04:33:46 | Himachal Pradesh, India | ||
2020-07-22 | India | Himachal Pradesh | 1725 | 11 | 1105 | 609 | 31.927213 | 77.233081 | 2020-07-23 05:15:04 | Himachal Pradesh, India | ||
2020-07-07 | India | Himachal Pradesh | 1083 | 11 | 790 | 282 | 31.927213000000002 | 77.233081 | 2020-07-08 05:33:48 | Himachal Pradesh, India | ||
2020-07-09 | India | Himachal Pradesh | 1140 | 11 | 846 | 283 | 31.927213000000002 | 77.233081 | 2020-07-10 04:34:24 | Himachal Pradesh, India | ||
2020-07-25 | India | Himachal Pradesh | 2049 | 11 | 1173 | 865 | 31.927213 | 77.233081 | 2020-07-26 04:35:00 | Himachal Pradesh, India | ||
2020-07-21 | India | Himachal Pradesh | 1664 | 11 | 1077 | 576 | 31.927213000000002 | 77.233081 | 2020-07-22 04:34:42 | Himachal Pradesh, India | ||
2020-07-14 | India | Himachal Pradesh | 1309 | 11 | 951 | 347 | 31.927213000000002 | 77.233081 | 2020-07-15 04:34:39 | Himachal Pradesh, India | ||
2020-07-08 | India | Himachal Pradesh | 1101 | 11 | 833 | 257 | 31.927213000000002 | 77.233081 | 2020-07-09 04:34:23 | Himachal Pradesh, India | ||
2020-07-24 | India | Himachal Pradesh | 1954 | 11 | 1145 | 798 | 31.927213 | 77.233081 | 2020-07-25 04:47:39 | Himachal Pradesh, India | ||
2020-07-06 | India | Himachal Pradesh | 1077 | 11 | 763 | 303 | 31.927213000000002 | 77.233081 | 2020-07-07 04:34:00 | Himachal Pradesh, India | ||
2020-07-17 | India | Himachal Pradesh | 1417 | 11 | 1024 | 382 | 31.927213000000002 | 77.233081 | 2020-07-18 04:34:45 | Himachal Pradesh, India | ||
2020-07-15 | India | Himachal Pradesh | 1341 | 11 | 979 | 351 | 31.927213 | 77.233081 | 2020-07-16 04:44:59 | Himachal Pradesh, India | ||
2020-07-18 | India | Himachal Pradesh | 1457 | 11 | 1036 | 410 | 31.927213000000002 | 77.233081 | 2020-07-19 04:34:58 | Himachal Pradesh, India | ||
2020-07-10 | India | Himachal Pradesh | 1171 | 11 | 883 | 277 | 31.927213000000002 | 77.233081 | 2020-07-11 04:34:26 | Himachal Pradesh, India | ||
2020-07-11 | India | Himachal Pradesh | 1182 | 11 | 908 | 263 | 31.927213000000002 | 77.233081 | 2020-07-12 04:34:30 | Himachal Pradesh, India | ||
2020-07-13 | India | Himachal Pradesh | 1243 | 11 | 940 | 292 | 31.927213000000002 | 77.233081 | 2020-07-14 04:34:46 | Himachal Pradesh, India | ||
2020-07-12 | India | Himachal Pradesh | 1213 | 11 | 929 | 273 | 31.927213000000002 | 77.233081 | 2020-07-13 04:43:04 | Himachal Pradesh, India | ||
2020-07-26 | India | Himachal Pradesh | 2176 | 12 | 1198 | 966 | 31.927213 | 77.233081 | 2020-07-27 04:35:02 | Himachal Pradesh, India | ||
2020-08-04 | India | Himachal Pradesh | 2879 | 14 | 1710 | 1155 | 31.927213 | 77.233081 | 2020-08-05 04:34:43 | Himachal Pradesh, India | ||
2020-07-27 | India | Himachal Pradesh | 2270 | 14 | 1216 | 1040 | 31.927213 | 77.233081 | 2020-07-28 04:58:43 | Himachal Pradesh, India | ||
2020-08-08 | India | Himachal Pradesh | 3264 | 14 | 2081 | 1169 | 31.927213 | 77.233081 | 2020-08-09 04:34:54 | Himachal Pradesh, India | ||
2020-08-07 | India | Himachal Pradesh | 3150 | 14 | 1954 | 1182 | 31.927213 | 77.233081 | 2020-08-08 04:34:53 | Himachal Pradesh, India | ||
2020-08-01 | India | Himachal Pradesh | 2634 | 14 | 1502 | 1118 | 31.927213 | 77.233081 | 2020-08-02 04:34:47 | Himachal Pradesh, India | ||
2020-07-30 | India | Himachal Pradesh | 2506 | 14 | 1387 | 1105 | 31.927213 | 77.233081 | 2020-07-31 04:35:18 | Himachal Pradesh, India | ||
2020-08-03 | India | Himachal Pradesh | 2818 | 14 | 1658 | 1146 | 31.927213 | 77.233081 | 2020-08-04 04:41:59 | Himachal Pradesh, India | ||
2020-08-02 | India | Himachal Pradesh | 2703 | 14 | 1559 | 1130 | 31.927213 | 77.233081 | 2020-08-03 04:34:35 | Himachal Pradesh, India | ||
2020-07-29 | India | Himachal Pradesh | 2403 | 14 | 1332 | 1057 | 31.927213 | 77.233081 | 2020-07-30 04:35:05 | Himachal Pradesh, India | ||
2020-07-28 | India | Himachal Pradesh | 2270 | 14 | 1216 | 1040 | 31.927213 | 77.233081 | 2020-07-29 04:35:11 | Himachal Pradesh, India | ||
2020-07-31 | India | Himachal Pradesh | 2564 | 14 | 1459 | 1091 | 31.927213 | 77.233081 | 2020-08-01 04:36:27 | Himachal Pradesh, India | ||
2020-08-06 | India | Himachal Pradesh | 3047 | 14 | 1865 | 1168 | 31.927213 | 77.233081 | 2020-08-07 04:35:11 | Himachal Pradesh, India | ||
2020-08-05 | India | Himachal Pradesh | 2916 | 14 | 1762 | 1140 | 31.927213 | 77.233081 | 2020-08-06 04:35:02 | Himachal Pradesh, India | ||
2020-08-09 | India | Himachal Pradesh | 3371 | 15 | 2181 | 1175 | 31.927213 | 77.233081 | 2020-08-10 04:34:55 | Himachal Pradesh, India | ||
2020-08-10 | India | Himachal Pradesh | 3463 | 17 | 2205 | 1241 | 31.927213 | 77.233081 | 2020-08-11 04:35:08 | Himachal Pradesh, India | ||
2020-08-11 | India | Himachal Pradesh | 3497 | 18 | 2273 | 1206 | 31.927213 | 77.233081 | 2020-08-12 04:27:29 | Himachal Pradesh, India | ||
2020-08-12 | India | Himachal Pradesh | 3636 | 18 | 2362 | 1256 | 31.927213 | 77.233081 | 2020-08-13 04:29:15 | Himachal Pradesh, India | ||
2020-08-15 | India | Himachal Pradesh | 3993 | 19 | 2632 | 1342 | 31.927213 | 77.233081 | 2020-08-16 04:27:42 | Himachal Pradesh, India | ||
2020-08-19 | India | Himachal Pradesh | 4411 | 19 | 2992 | 1400 | 31.927213 | 77.233081 | 2020-08-20 04:27:43 | Himachal Pradesh, India | ||
2020-08-13 | India | Himachal Pradesh | 3816 | 19 | 2435 | 1362 | 31.927213 | 77.233081 | 2020-08-14 04:51:19 | Himachal Pradesh, India | ||
2020-08-17 | India | Himachal Pradesh | 4174 | 19 | 2834 | 1321 | 31.927213 | 77.233081 | 2020-08-18 04:27:56 | Himachal Pradesh, India | ||
2020-08-16 | India | Himachal Pradesh | 4156 | 19 | 2720 | 1417 | 31.927213 | 77.233081 | 2020-08-17 04:27:20 | Himachal Pradesh, India | ||
2020-08-14 | India | Himachal Pradesh | 3874 | 19 | 2551 | 1304 | 31.927213 | 77.233081 | 2020-08-15 04:27:31 | Himachal Pradesh, India | ||
2020-08-18 | India | Himachal Pradesh | 4235 | 19 | 2923 | 1293 | 31.927213 | 77.233081 | 2020-08-19 04:27:00 | Himachal Pradesh, India | ||
2020-08-20 | India | Himachal Pradesh | 4538 | 23 | 3085 | 1430 | 31.927213 | 77.233081 | 2020-08-21 04:27:41 | Himachal Pradesh, India | ||
2020-08-21 | India | Himachal Pradesh | 4728 | 25 | 3234 | 1469 | 31.927213 | 77.233081 | 2020-08-22 04:27:49 | Himachal Pradesh, India | ||
2020-08-23 | India | Himachal Pradesh | 5001 | 29 | 3461 | 1511 | 31.927213 | 77.233081 | 2020-08-24 04:27:56 | Himachal Pradesh, India | ||
2020-08-22 | India | Himachal Pradesh | 4895 | 29 | 3341 | 1525 | 31.927213 | 77.233081 | 2020-08-23 04:27:48 | Himachal Pradesh, India | ||
2020-08-24 | India | Himachal Pradesh | 5101 | 29 | 3584 | 1488 | 31.927213 | 77.233081 | 2020-08-25 04:28:02 | Himachal Pradesh, India | ||
2020-08-25 | India | Himachal Pradesh | 5154 | 30 | 3748 | 1376 | 31.927213 | 77.233081 | 2020-08-26 04:28:11 | Himachal Pradesh, India | ||
2020-08-26 | India | Himachal Pradesh | 5321 | 32 | 3810 | 1479 | 31.927213 | 77.233081 | 2020-08-27 04:28:15 | Himachal Pradesh, India | ||
2020-08-28 | India | Himachal Pradesh | 5637 | 33 | 4149 | 1455 | 31.927213 | 77.233081 | 2020-08-29 04:28:19 | Himachal Pradesh, India | ||
2020-08-27 | India | Himachal Pradesh | 5501 | 33 | 4008 | 1460 | 31.927213 | 77.233081 | 2020-08-28 04:28:11 | Himachal Pradesh, India | ||
2020-08-29 | India | Himachal Pradesh | 5781 | 34 | 4308 | 1439 | 31.927213 | 77.233081 | 2020-08-30 04:28:22 | Himachal Pradesh, India | ||
2020-08-30 | India | Himachal Pradesh | 5945 | 35 | 4450 | 1460 | 31.927213 | 77.233081 | 2020-08-31 04:28:27 | Himachal Pradesh, India | ||
2020-08-31 | India | Himachal Pradesh | 6116 | 38 | 4515 | 1563 | 31.927213 | 77.233081 | 2020-09-01 04:28:31 | Himachal Pradesh, India | ||
2020-09-01 | India | Himachal Pradesh | 6255 | 40 | 4688 | 1527 | 31.927213 | 77.233081 | 2020-09-02 04:28:25 | Himachal Pradesh, India | ||
2020-09-02 | India | Himachal Pradesh | 6416 | 43 | 4760 | 1613 | 31.927213 | 77.233081 | 2020-09-03 04:28:22 | Himachal Pradesh, India | ||
2020-09-03 | India | Himachal Pradesh | 6615 | 48 | 4859 | 1708 | 31.927213 | 77.233081 | 2020-09-04 04:28:26 | Himachal Pradesh, India | ||
2020-09-04 | India | Himachal Pradesh | 6830 | 50 | 4965 | 1815 | 31.927213 | 77.233081 | 2020-09-05 04:28:19 | Himachal Pradesh, India | ||
2020-09-05 | India | Himachal Pradesh | 7018 | 54 | 4986 | 1978 | 31.927213 | 77.233081 | 2020-09-06 04:28:33 | Himachal Pradesh, India | ||
2020-09-06 | India | Himachal Pradesh | 7415 | 55 | 5184 | 2176 | 31.927213 | 77.233081 | 2020-09-07 04:28:30 | Himachal Pradesh, India | ||
2020-09-07 | India | Himachal Pradesh | 7660 | 56 | 5370 | 2234 | 31.927213 | 77.233081 | 2020-09-08 04:28:25 | Himachal Pradesh, India | ||
2020-09-08 | India | Himachal Pradesh | 7831 | 60 | 5445 | 2326 | 31.927213 | 77.233081 | 2020-09-09 04:28:48 | Himachal Pradesh, India | ||
2020-09-09 | India | Himachal Pradesh | 8147 | 63 | 5597 | 2487 | 31.927213 | 77.233081 | 2020-09-10 04:29:01 | Himachal Pradesh, India | ||
2020-09-10 | India | Himachal Pradesh | 8466 | 66 | 5677 | 2723 | 31.927213 | 77.233081 | 2020-09-11 04:46:23 | Himachal Pradesh, India | ||
2020-09-11 | India | Himachal Pradesh | 8784 | 71 | 5839 | 2874 | 31.927213 | 77.233081 | 2020-09-12 04:25:05 | Himachal Pradesh, India | ||
2020-09-12 | India | Himachal Pradesh | 9229 | 73 | 5962 | 3194 | 31.927213 | 77.233081 | 2020-09-13 04:30:52 | Himachal Pradesh, India | ||
2020-09-14 | India | Himachal Pradesh | 9555 | 77 | 6114 | 3364 | 31.927213 | 77.233081 | 2020-09-15 03:22:50 | Himachal Pradesh, India | ||
2020-09-13 | India | Himachal Pradesh | 9555 | 77 | 6114 | 3364 | 31.927213 | 77.233081 | 2020-09-14 04:26:00 | Himachal Pradesh, India | ||
2020-09-15 | India | Himachal Pradesh | 10335 | 90 | 6444 | 3801 | 31.927213 | 77.233081 | 2020-09-16 04:22:53 | Himachal Pradesh, India | ||
2020-09-16 | India | Himachal Pradesh | 10795 | 91 | 6558 | 4146 | 31.927213 | 77.233081 | 2020-09-17 04:22:00 | Himachal Pradesh, India | ||
2020-09-17 | India | Himachal Pradesh | 11190 | 98 | 6946 | 4146 | 31.927213 | 77.233081 | 2020-09-18 05:05:00 | Himachal Pradesh, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;