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 admin2
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 | |||
8280 | 8280 | 2020-10-25 | India | Himachal Pradesh | 20370 | 291 | 17590 | 2489 | 31.927213 | 77.233081 | 2020-10-26 04:25:02 | Himachal Pradesh, India | ||
12288 | 12288 | 2021-01-26 | India | Himachal Pradesh | 57257 | 973 | 55923 | 361 | 31.927213 | 77.233081 | 2021-01-27 05:23:41 | 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 | |||
20318 | 20318 | 2021-05-28 | India | Himachal Pradesh | 187342 | 3056 | 165791 | 18495 | 31.927213 | 77.233081 | 2021-05-29 04:20:41 | 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 | |||
36378 | 36378 | 2021-04-12 | India | Himachal Pradesh | 70775 | 1124 | 63582 | 6069 | 31.927213 | 77.233081 | 2021-04-13 04:20:37 | 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 | |||
50739 | 50739 | 2021-05-29 | India | Himachal Pradesh | 188604 | 3086 | 168529 | 16989 | 31.927213 | 77.233081 | 2021-05-30 04:20:55 | Himachal Pradesh, India | ||
54753 | 54753 | 2021-03-07 | India | Himachal Pradesh | 59118 | 997 | 57507 | 614 | 31.927213 | 77.233081 | 2021-03-08 05:24:48 | Himachal Pradesh, India | ||
61899 | 61899 | 2020-07-23 | India | Himachal Pradesh | 1834 | 11 | 1136 | 687 | 31.927213 | 77.233081 | 2020-07-24 05:30:40 | 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 | |||
75037 | 75037 | 2020-12-03 | India | Himachal Pradesh | 42697 | 695 | 33914 | 8088 | 31.927213 | 77.233081 | 2020-12-04 05:27:27 | Himachal Pradesh, India | ||
79036 | 79036 | 2020-10-14 | India | Himachal Pradesh | 18008 | 255 | 15233 | 2520 | 31.927213 | 77.233081 | 2020-10-15 04:24:28 | Himachal Pradesh, India | ||
83043 | 83043 | 2021-05-25 | India | Himachal Pradesh | 182982 | 2887 | 157042 | 23053 | 31.927213 | 77.233081 | 2021-05-26 04:20:35 | 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 | |||
98242 | 98242 | 2020-08-04 | India | Himachal Pradesh | 2879 | 14 | 1710 | 1155 | 31.927213 | 77.233081 | 2020-08-05 04:34:43 | 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 | |||
107399 | 107399 | 2021-06-19 | India | Himachal Pradesh | 200282 | 3439 | 193853 | 2990 | 31.927213 | 77.233081 | 2021-06-20 04:21:48 | 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 | |||
121835 | 121835 | 2020-07-19 | India | Himachal Pradesh | 1483 | 11 | 1059 | 413 | 31.927213000000002 | 77.233081 | 2020-07-20 05:34:40 | Himachal Pradesh, India | ||
122652 | 122652 | 2020-11-18 | India | Himachal Pradesh | 31401 | 475 | 24025 | 6901 | 31.927213 | 77.233081 | 2020-11-19 05:25:23 | 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 | |||
145920 | 145920 | 2020-08-15 | India | Himachal Pradesh | 3993 | 19 | 2632 | 1342 | 31.927213 | 77.233081 | 2020-08-16 04:27:42 | 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 | |||
153931 | 153931 | 2021-01-08 | India | Himachal Pradesh | 56146 | 953 | 53973 | 1220 | 31.927213 | 77.233081 | 2021-01-09 05:22:18 | 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 | |||
169992 | 169992 | 2021-04-16 | India | Himachal Pradesh | 74195 | 1168 | 65316 | 7711 | 31.927213 | 77.233081 | 2021-04-17 04:20:40 | Himachal Pradesh, India | ||
177153 | 177153 | 2020-07-27 | India | Himachal Pradesh | 2270 | 14 | 1216 | 1040 | 31.927213 | 77.233081 | 2020-07-28 04:58:43 | 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 | |||
181988 | 181988 | 2021-02-21 | India | Himachal Pradesh | 58385 | 995 | 57156 | 234 | 31.927213 | 77.233081 | 2021-02-22 05:24:21 | 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 | |||
190017 | 190017 | 2021-01-11 | India | Himachal Pradesh | 56521 | 961 | 54686 | 874 | 31.927213 | 77.233081 | 2021-01-12 05:22:15 | Himachal Pradesh, India | ||
194015 | 194015 | 2020-08-31 | India | Himachal Pradesh | 6116 | 38 | 4515 | 1563 | 31.927213 | 77.233081 | 2020-09-01 04:28:31 | 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 | |||
202204 | 202204 | 2020-12-25 | India | Himachal Pradesh | 54058 | 902 | 48809 | 4347 | 31.927213 | 77.233081 | 2020-12-26 05:22:28 | Himachal Pradesh, India | ||
206202 | 206202 | 2020-08-19 | India | Himachal Pradesh | 4411 | 19 | 2992 | 1400 | 31.927213 | 77.233081 | 2020-08-20 04:27:43 | Himachal Pradesh, India | ||
210188 | 210188 | 2020-10-29 | India | Himachal Pradesh | 21476 | 306 | 18402 | 2768 | 31.927213 | 77.233081 | 2020-10-30 04:24:49 | 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 | |||
237189 | 237189 | 2021-01-18 | India | Himachal Pradesh | 56978 | 967 | 55383 | 628 | 31.927213 | 77.233081 | 2021-01-19 05:22:15 | Himachal Pradesh, India | ||
241203 | 241203 | 2021-04-02 | India | Himachal Pradesh | 64420 | 1056 | 60026 | 3338 | 31.927213 | 77.233081 | 2021-04-03 04:20:44 | 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 | |||
272103 | 272103 | 2020-11-10 | India | Himachal Pradesh | 26808 | 396 | 21047 | 5365 | 31.927213 | 77.233081 | 2020-11-11 05:25:30 | 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 | |||
280131 | 280131 | 2021-02-24 | India | Himachal Pradesh | 58457 | 995 | 57233 | 229 | 31.927213 | 77.233081 | 2021-02-25 05:24:57 | Himachal Pradesh, India | ||
287120 | 287120 | 2020-06-15 | India | Himachal Pradesh | 556 | 8 | 353 | 195 | 31.927213000000002 | 77.233081 | 2020-06-16 04:33:09 | 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 | |||
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 | ||
302992 | 302992 | 2020-07-01 | India | Himachal Pradesh | 979 | 10 | 614 | 355 | 31.927213000000002 | 77.233081 | 2020-07-02 04:33:46 | 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 | |||
326930 | 326930 | 2020-07-20 | India | Himachal Pradesh | 1631 | 11 | 1067 | 553 | 31.927213000000002 | 77.233081 | 2020-07-21 04:38:46 | 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 | |||
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 | ||
335869 | 335869 | 2022-03-18 | India | Himachal Pradesh | 284304 | 4132 | 0 | 31.927213000000002 | 77.233081 | 2022-03-19 04:20:47 | Himachal Pradesh, India | |||
340223 | 340223 | 2021-02-03 | India | Himachal Pradesh | 57646 | 981 | 56256 | 409 | 31.927213 | 77.233081 | 2021-02-04 05:22:26 | Himachal Pradesh, India | ||
344223 | 344223 | 2020-09-14 | India | Himachal Pradesh | 9555 | 77 | 6114 | 3364 | 31.927213 | 77.233081 | 2020-09-15 03:22:50 | 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 | |||
352244 | 352244 | 2021-03-11 | India | Himachal Pradesh | 59439 | 1003 | 57774 | 662 | 31.927213 | 77.233081 | 2021-03-12 05:26:50 | 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 | |||
367340 | 367340 | 2020-07-16 | India | Himachal Pradesh | 1377 | 11 | 984 | 382 | 31.927213 | 77.233081 | 2020-07-17 04:34:50 | Himachal Pradesh, India | ||
371307 | 371307 | 2020-08-08 | India | Himachal Pradesh | 3264 | 14 | 2081 | 1169 | 31.927213 | 77.233081 | 2020-08-09 04:34:54 | 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 | |||
376130 | 376130 | 2020-11-06 | India | Himachal Pradesh | 24239 | 361 | 20033 | 3845 | 31.927213 | 77.233081 | 2020-11-07 05:24:52 | Himachal Pradesh, India | ||
380141 | 380141 | 2021-04-30 | India | Himachal Pradesh | 99287 | 1497 | 79365 | 18425 | 31.927213 | 77.233081 | 2021-05-01 04:20:47 | 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 | |||
388171 | 388171 | 2021-04-04 | India | Himachal Pradesh | 65242 | 1070 | 60595 | 3577 | 31.927213 | 77.233081 | 2021-04-05 04:20:35 | Himachal Pradesh, India | ||
392183 | 392183 | 2020-11-27 | India | Himachal Pradesh | 38327 | 612 | 29510 | 8205 | 31.927213 | 77.233081 | 2020-11-28 05:25:50 | 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 | |||
400212 | 400212 | 2021-06-29 | India | Himachal Pradesh | 201980 | 3477 | 196849 | 1654 | 31.927213 | 77.233081 | 2021-06-30 04:21:41 | 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 | |||
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 | ||
415284 | 415284 | 2020-07-05 | India | Himachal Pradesh | 1063 | 11 | 737 | 315 | 31.927213000000002 | 77.233081 | 2020-07-06 04:33:57 | 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 | |||
427284 | 427284 | 2020-09-07 | India | Himachal Pradesh | 7660 | 56 | 5370 | 2234 | 31.927213 | 77.233081 | 2020-09-08 04:28:25 | 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]);