johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "Pakistan" and province_or_state = "Islamabad" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026492 | 1026492 | 2020-10-17 | Pakistan | Islamabad | 17996 | 194 | 16672 | 1130 | 33.665087 | 73.121219 | 2020-10-18 04:24:25 | Islamabad, Pakistan | ||
2856987 | 2856987 | 2020-10-16 | Pakistan | Islamabad | 17913 | 194 | 16620 | 1099 | 33.665087 | 73.121219 | 2020-10-17 04:24:12 | Islamabad, Pakistan | ||
786517 | 786517 | 2020-10-15 | Pakistan | Islamabad | 17781 | 193 | 16550 | 1038 | 33.665087 | 73.121219 | 2020-10-16 04:24:01 | Islamabad, Pakistan | ||
79228 | 79228 | 2020-10-14 | Pakistan | Islamabad | 17681 | 191 | 16486 | 1004 | 33.665087 | 73.121219 | 2020-10-15 04:24:28 | Islamabad, Pakistan | ||
3782043 | 3782043 | 2020-10-13 | Pakistan | Islamabad | 17526 | 189 | 16448 | 889 | 33.665087 | 73.121219 | 2020-10-14 04:24:05 | Islamabad, Pakistan | ||
2291583 | 2291583 | 2020-10-12 | Pakistan | Islamabad | 17428 | 189 | 16403 | 836 | 33.665087 | 73.121219 | 2020-10-13 04:24:02 | Islamabad, Pakistan | ||
3786036 | 3786036 | 2020-10-11 | Pakistan | Islamabad | 17331 | 189 | 16367 | 775 | 33.665087 | 73.121219 | 2020-10-12 04:23:45 | Islamabad, Pakistan | ||
2602174 | 2602174 | 2020-10-10 | Pakistan | Islamabad | 17296 | 188 | 16319 | 789 | 33.665087 | 73.121219 | 2020-10-11 04:23:46 | Islamabad, Pakistan | ||
817707 | 817707 | 2020-10-09 | Pakistan | Islamabad | 17210 | 188 | 16279 | 743 | 33.665087 | 73.121219 | 2020-10-10 04:23:57 | Islamabad, Pakistan | ||
2689822 | 2689822 | 2020-10-08 | Pakistan | Islamabad | 17122 | 188 | 16249 | 685 | 33.665087 | 73.121219 | 2020-10-09 04:23:59 | Islamabad, Pakistan | ||
1041964 | 1041964 | 2020-10-07 | Pakistan | Islamabad | 17009 | 187 | 16206 | 616 | 33.665087 | 73.121219 | 2020-10-08 04:23:56 | Islamabad, Pakistan | ||
3117625 | 3117625 | 2020-10-06 | Pakistan | Islamabad | 16936 | 184 | 16153 | 599 | 33.665087 | 73.121219 | 2020-10-07 04:23:40 | Islamabad, Pakistan | ||
3802037 | 3802037 | 2020-10-05 | Pakistan | Islamabad | 16845 | 184 | 16113 | 548 | 33.665087 | 73.121219 | 2020-10-06 04:23:33 | Islamabad, Pakistan | ||
1822927 | 1822927 | 2020-10-04 | Pakistan | Islamabad | 16766 | 183 | 16034 | 549 | 33.665087 | 73.121219 | 2020-10-05 04:23:33 | Islamabad, Pakistan | ||
2514311 | 2514311 | 2020-10-03 | Pakistan | Islamabad | 16766 | 183 | 16034 | 549 | 33.665087 | 73.121219 | 2020-10-04 04:23:44 | Islamabad, Pakistan | ||
3389529 | 3389529 | 2020-10-02 | Pakistan | Islamabad | 16713 | 183 | 15983 | 547 | 33.665087 | 73.121219 | 2020-10-03 04:23:40 | Islamabad, Pakistan | ||
2379770 | 2379770 | 2020-10-01 | Pakistan | Islamabad | 16650 | 182 | 15947 | 521 | 33.665087 | 73.121219 | 2020-10-02 04:23:51 | Islamabad, Pakistan | ||
1045956 | 1045956 | 2020-09-30 | Pakistan | Islamabad | 16611 | 182 | 15916 | 513 | 33.665087 | 73.121219 | 2020-10-01 04:23:42 | Islamabad, Pakistan | ||
967037 | 967037 | 2020-09-29 | Pakistan | Islamabad | 16581 | 182 | 15865 | 534 | 33.665087 | 73.121219 | 2020-09-30 04:23:33 | Islamabad, Pakistan | ||
1515534 | 1515534 | 2020-09-28 | Pakistan | Islamabad | 16532 | 181 | 15826 | 525 | 33.665087 | 73.121219 | 2020-09-29 04:23:42 | Islamabad, Pakistan | ||
2582122 | 2582122 | 2020-09-27 | Pakistan | Islamabad | 16470 | 181 | 15795 | 494 | 33.665087 | 73.121219 | 2020-09-28 04:23:00 | Islamabad, Pakistan | ||
2614174 | 2614174 | 2020-09-26 | Pakistan | Islamabad | 16440 | 181 | 15755 | 504 | 33.665087 | 73.121219 | 2020-09-27 04:23:00 | Islamabad, Pakistan | ||
2812889 | 2812889 | 2020-09-25 | Pakistan | Islamabad | 16367 | 181 | 15718 | 468 | 33.665087 | 73.121219 | 2020-09-26 04:23:00 | Islamabad, Pakistan | ||
2606166 | 2606166 | 2020-09-24 | Pakistan | Islamabad | 16324 | 181 | 15676 | 467 | 33.665087 | 73.121219 | 2020-09-25 04:23:00 | Islamabad, Pakistan | ||
2653909 | 2653909 | 2020-09-23 | Pakistan | Islamabad | 16288 | 181 | 15646 | 461 | 33.665087 | 73.121219 | 2020-09-24 04:23:00 | Islamabad, Pakistan | ||
3316358 | 3316358 | 2020-09-22 | Pakistan | Islamabad | 16246 | 180 | 15629 | 437 | 33.665087 | 73.121219 | 2020-09-23 04:23:00 | Islamabad, Pakistan | ||
2836957 | 2836957 | 2020-09-21 | Pakistan | Islamabad | 16207 | 180 | 15597 | 430 | 33.665087 | 73.121219 | 2020-09-22 04:23:00 | Islamabad, Pakistan | ||
3093561 | 3093561 | 2020-09-20 | Pakistan | Islamabad | 16162 | 180 | 15557 | 425 | 33.665087 | 73.121219 | 2020-09-21 04:23:00 | Islamabad, Pakistan | ||
2454911 | 2454911 | 2020-09-19 | Pakistan | Islamabad | 16124 | 180 | 15529 | 415 | 33.665087 | 73.121219 | 2020-09-20 04:22:00 | Islamabad, Pakistan | ||
2848980 | 2848980 | 2020-09-18 | Pakistan | Islamabad | 16086 | 180 | 15483 | 423 | 33.665087 | 73.121219 | 2020-09-19 04:22:00 | Islamabad, Pakistan | ||
1121729 | 1121729 | 2020-09-17 | Pakistan | Islamabad | 16033 | 180 | 15467 | 386 | 33.665087 | 73.121219 | 2020-09-18 05:05:00 | Islamabad, Pakistan | ||
666418 | 666418 | 2020-09-16 | Pakistan | Islamabad | 16005 | 178 | 15453 | 374 | 33.665087 | 73.121219 | 2020-09-17 04:22:00 | Islamabad, Pakistan | ||
2729143 | 2729143 | 2020-09-15 | Pakistan | Islamabad | 15984 | 178 | 15430 | 376 | 33.665087 | 73.121219 | 2020-09-16 04:22:53 | Islamabad, Pakistan | ||
344415 | 344415 | 2020-09-14 | Pakistan | Islamabad | 15962 | 178 | 15392 | 392 | 33.665087 | 73.121219 | 2020-09-15 03:22:50 | Islamabad, Pakistan | ||
2868854 | 2868854 | 2020-09-13 | Pakistan | Islamabad | 15941 | 178 | 15351 | 412 | 33.665087 | 73.121219 | 2020-09-14 04:26:00 | Islamabad, Pakistan | ||
546893 | 546893 | 2020-09-12 | Pakistan | Islamabad | 15901 | 178 | 15327 | 396 | 33.665087 | 73.121219 | 2020-09-13 04:30:52 | Islamabad, Pakistan | ||
1444722 | 1444722 | 2020-09-11 | Pakistan | Islamabad | 15862 | 178 | 15296 | 388 | 33.665087 | 73.121219 | 2020-09-12 04:25:05 | Islamabad, Pakistan | ||
1173323 | 1173323 | 2020-09-10 | Pakistan | Islamabad | 15832 | 178 | 15270 | 384 | 33.665087 | 73.121219 | 2020-09-11 04:46:23 | Islamabad, Pakistan | ||
2171688 | 2171688 | 2020-09-09 | Pakistan | Islamabad | 15804 | 177 | 15244 | 383 | 33.665087 | 73.121219 | 2020-09-10 04:29:01 | Islamabad, Pakistan | ||
1243897 | 1243897 | 2020-09-08 | Pakistan | Islamabad | 15780 | 177 | 15213 | 390 | 33.665087 | 73.121219 | 2020-09-09 04:28:48 | Islamabad, Pakistan | ||
427476 | 427476 | 2020-09-07 | Pakistan | Islamabad | 15762 | 177 | 15184 | 401 | 33.665087 | 73.121219 | 2020-09-08 04:28:25 | Islamabad, Pakistan | ||
3161761 | 3161761 | 2020-09-06 | Pakistan | Islamabad | 15750 | 176 | 15154 | 420 | 33.665087 | 73.121219 | 2020-09-07 04:28:30 | Islamabad, Pakistan | ||
813716 | 813716 | 2020-09-05 | Pakistan | Islamabad | 15726 | 175 | 15120 | 431 | 33.665087 | 73.121219 | 2020-09-06 04:28:33 | Islamabad, Pakistan | ||
2661916 | 2661916 | 2020-09-04 | Pakistan | Islamabad | 15726 | 175 | 15120 | 431 | 33.665087 | 73.121219 | 2020-09-05 04:28:19 | Islamabad, Pakistan | ||
1354456 | 1354456 | 2020-09-03 | Pakistan | Islamabad | 15714 | 175 | 15094 | 445 | 33.665087 | 73.121219 | 2020-09-04 04:28:26 | Islamabad, Pakistan | ||
1105693 | 1105693 | 2020-09-02 | Pakistan | Islamabad | 15689 | 175 | 15056 | 458 | 33.665087 | 73.121219 | 2020-09-03 04:28:22 | Islamabad, Pakistan | ||
2060022 | 2060022 | 2020-09-01 | Pakistan | Islamabad | 15649 | 175 | 15000 | 474 | 33.665087 | 73.121219 | 2020-09-02 04:28:25 | Islamabad, Pakistan | ||
194207 | 194207 | 2020-08-31 | Pakistan | Islamabad | 15625 | 175 | 14975 | 475 | 33.665087 | 73.121219 | 2020-09-01 04:28:31 | Islamabad, Pakistan | ||
3932166 | 3932166 | 2020-08-30 | Pakistan | Islamabad | 15611 | 175 | 14967 | 469 | 33.665087 | 73.121219 | 2020-08-31 04:28:27 | Islamabad, Pakistan | ||
609828 | 609828 | 2020-08-29 | Pakistan | Islamabad | 15597 | 175 | 14936 | 486 | 33.665087 | 73.121219 | 2020-08-30 04:28:22 | Islamabad, Pakistan | ||
1523323 | 1523323 | 2020-08-28 | Pakistan | Islamabad | 15578 | 175 | 14923 | 480 | 33.665087 | 73.121219 | 2020-08-29 04:28:19 | Islamabad, Pakistan | ||
2510324 | 2510324 | 2020-08-27 | Pakistan | Islamabad | 15562 | 175 | 14884 | 503 | 33.665087 | 73.121219 | 2020-08-28 04:28:11 | Islamabad, Pakistan | ||
1996784 | 1996784 | 2020-08-26 | Pakistan | Islamabad | 15546 | 175 | 14792 | 579 | 33.665087 | 73.121219 | 2020-08-27 04:28:15 | Islamabad, Pakistan | ||
3562708 | 3562708 | 2020-08-25 | Pakistan | Islamabad | 15531 | 175 | 14684 | 672 | 33.665087 | 73.121219 | 2020-08-26 04:28:11 | Islamabad, Pakistan | ||
2991412 | 2991412 | 2020-08-24 | Pakistan | Islamabad | 15515 | 175 | 14621 | 719 | 33.665087 | 73.121219 | 2020-08-25 04:28:02 | Islamabad, Pakistan | ||
2215807 | 2215807 | 2020-08-23 | Pakistan | Islamabad | 15515 | 175 | 14621 | 719 | 33.665087 | 73.121219 | 2020-08-24 04:27:56 | Islamabad, Pakistan | ||
2299589 | 2299589 | 2020-08-22 | Pakistan | Islamabad | 15472 | 175 | 14372 | 925 | 33.665087 | 73.121219 | 2020-08-23 04:27:48 | Islamabad, Pakistan | ||
1479696 | 1479696 | 2020-08-21 | Pakistan | Islamabad | 15453 | 175 | 14101 | 1177 | 33.665087 | 73.121219 | 2020-08-22 04:27:49 | Islamabad, Pakistan | ||
3484445 | 3484445 | 2020-08-20 | Pakistan | Islamabad | 15425 | 175 | 13836 | 1414 | 33.665087 | 73.121219 | 2020-08-21 04:27:41 | Islamabad, Pakistan | ||
206394 | 206394 | 2020-08-19 | Pakistan | Islamabad | 15412 | 175 | 13612 | 1625 | 33.665087 | 73.121219 | 2020-08-20 04:27:43 | Islamabad, Pakistan | ||
3178148 | 3178148 | 2020-08-18 | Pakistan | Islamabad | 15401 | 175 | 13430 | 1796 | 33.665087 | 73.121219 | 2020-08-19 04:27:00 | Islamabad, Pakistan | ||
837752 | 837752 | 2020-08-17 | Pakistan | Islamabad | 15390 | 173 | 13276 | 1941 | 33.665087 | 73.121219 | 2020-08-18 04:27:56 | Islamabad, Pakistan | ||
1556110 | 1556110 | 2020-08-16 | Pakistan | Islamabad | 15390 | 173 | 13276 | 1941 | 33.665087 | 73.121219 | 2020-08-17 04:27:20 | Islamabad, Pakistan | ||
146112 | 146112 | 2020-08-15 | Pakistan | Islamabad | 15346 | 173 | 13100 | 2073 | 33.665087 | 73.121219 | 2020-08-16 04:27:42 | Islamabad, Pakistan | ||
1612387 | 1612387 | 2020-08-14 | Pakistan | Islamabad | 15342 | 173 | 13078 | 2091 | 33.665087 | 73.121219 | 2020-08-15 04:27:31 | Islamabad, Pakistan | ||
582971 | 582971 | 2020-08-13 | Pakistan | Islamabad | 15323 | 173 | 13020 | 2130 | 33.665087 | 73.121219 | 2020-08-14 04:51:19 | Islamabad, Pakistan | ||
3531590 | 3531590 | 2020-08-12 | Pakistan | Islamabad | 15323 | 173 | 13020 | 2130 | 33.665087 | 73.121219 | 2020-08-13 04:29:15 | Islamabad, Pakistan | ||
662439 | 662439 | 2020-08-11 | Pakistan | Islamabad | 15281 | 171 | 12995 | 2115 | 33.665087 | 73.121219 | 2020-08-12 04:27:29 | Islamabad, Pakistan | ||
1920346 | 1920346 | 2020-08-10 | Pakistan | Islamabad | 15261 | 171 | 12969 | 2121 | 33.665087 | 73.121219 | 2020-08-11 04:35:08 | Islamabad, Pakistan | ||
3923155 | 3923155 | 2020-08-09 | Pakistan | Islamabad | 15241 | 171 | 12914 | 2156 | 33.665087 | 73.121219 | 2020-08-10 04:34:55 | Islamabad, Pakistan | ||
371323 | 371323 | 2020-08-08 | Pakistan | Islamabad | 15214 | 171 | 12878 | 2165 | 33.665087 | 73.121219 | 2020-08-09 04:34:54 | Islamabad, Pakistan | ||
458507 | 458507 | 2020-08-07 | Pakistan | Islamabad | 15182 | 170 | 12833 | 2179 | 33.665087 | 73.121219 | 2020-08-08 04:34:53 | Islamabad, Pakistan | ||
3612192 | 3612192 | 2020-08-06 | Pakistan | Islamabad | 15141 | 167 | 12833 | 2141 | 33.665087 | 73.121219 | 2020-08-07 04:35:11 | Islamabad, Pakistan | ||
3793022 | 3793022 | 2020-08-05 | Pakistan | Islamabad | 15122 | 167 | 12732 | 2223 | 33.665087 | 73.121219 | 2020-08-06 04:35:02 | Islamabad, Pakistan | ||
98258 | 98258 | 2020-08-04 | Pakistan | Islamabad | 15095 | 167 | 12678 | 2250 | 33.665087 | 73.121219 | 2020-08-05 04:34:43 | Islamabad, Pakistan | ||
2740141 | 2740141 | 2020-08-03 | Pakistan | Islamabad | 15095 | 167 | 12678 | 2250 | 33.665087 | 73.121219 | 2020-08-04 04:41:59 | Islamabad, Pakistan | ||
2807893 | 2807893 | 2020-08-02 | Pakistan | Islamabad | 15052 | 165 | 12589 | 2298 | 33.665087 | 73.121219 | 2020-08-03 04:34:35 | Islamabad, Pakistan | ||
753461 | 753461 | 2020-08-01 | Pakistan | Islamabad | 15014 | 165 | 12494 | 2355 | 33.665087 | 73.121219 | 2020-08-02 04:34:47 | Islamabad, Pakistan | ||
3264626 | 3264626 | 2020-07-31 | Pakistan | Islamabad | 15014 | 165 | 12494 | 2355 | 33.665087 | 73.121219 | 2020-08-01 04:36:27 | Islamabad, Pakistan | ||
1928333 | 1928333 | 2020-07-30 | Pakistan | Islamabad | 14987 | 165 | 12377 | 2445 | 33.665087 | 73.121219 | 2020-07-31 04:35:18 | Islamabad, Pakistan | ||
2958501 | 2958501 | 2020-07-29 | Pakistan | Islamabad | 14963 | 165 | 12377 | 2421 | 33.665087 | 73.121219 | 2020-07-30 04:35:05 | Islamabad, Pakistan | ||
3185117 | 3185117 | 2020-07-28 | Pakistan | Islamabad | 14938 | 165 | 12377 | 2396 | 33.665087 | 73.121219 | 2020-07-29 04:35:11 | Islamabad, Pakistan | ||
177169 | 177169 | 2020-07-27 | Pakistan | Islamabad | 14884 | 164 | 12253 | 2467 | 33.665087 | 73.121219 | 2020-07-28 04:58:43 | Islamabad, Pakistan | ||
442482 | 442482 | 2020-07-26 | Pakistan | Islamabad | 14841 | 163 | 12253 | 2425 | 33.665087 | 73.121219 | 2020-07-27 04:35:02 | Islamabad, Pakistan | ||
1502726 | 1502726 | 2020-07-25 | Pakistan | Islamabad | 14841 | 163 | 12253 | 2425 | 33.665087 | 73.121219 | 2020-07-26 04:35:00 | Islamabad, Pakistan | ||
2563696 | 2563696 | 2020-07-24 | Pakistan | Islamabad | 14821 | 162 | 12139 | 2520 | 33.665087 | 73.121219 | 2020-07-25 04:47:39 | Islamabad, Pakistan | ||
61915 | 61915 | 2020-07-23 | Pakistan | Islamabad | 14766 | 162 | 12023 | 2581 | 33.665087 | 73.121219 | 2020-07-24 05:30:40 | Islamabad, Pakistan | ||
844716 | 844716 | 2020-07-22 | Pakistan | Islamabad | 14722 | 162 | 12023 | 2537 | 33.665087 | 73.121219 | 2020-07-23 05:15:04 | Islamabad, Pakistan | ||
1707455 | 1707455 | 2020-07-21 | Pakistan | Islamabad | 14701 | 161 | 12023 | 2517 | 33.665087 | 73.121219 | 2020-07-22 04:34:42 | Islamabad, Pakistan | ||
326946 | 326946 | 2020-07-20 | Pakistan | Islamabad | 14625 | 160 | 11912 | 2553 | 33.665087 | 73.121219 | 2020-07-21 04:38:46 | Islamabad, Pakistan | ||
121851 | 121851 | 2020-07-19 | Pakistan | Islamabad | 14599 | 159 | 11836 | 2604 | 33.665087 | 73.121219 | 2020-07-20 05:34:40 | Islamabad, Pakistan | ||
3205240 | 3205240 | 2020-07-18 | Pakistan | Islamabad | 14576 | 157 | 11836 | 2583 | 33.665087 | 73.121219 | 2020-07-19 04:34:58 | Islamabad, Pakistan | ||
2708542 | 2708542 | 2020-07-17 | Pakistan | Islamabad | 14504 | 157 | 11708 | 2639 | 33.665087 | 73.121219 | 2020-07-18 04:34:45 | Islamabad, Pakistan | ||
367356 | 367356 | 2020-07-16 | Pakistan | Islamabad | 14402 | 156 | 11486 | 2760 | 33.665087 | 73.121219 | 2020-07-17 04:34:50 | Islamabad, Pakistan | ||
2748024 | 2748024 | 2020-07-15 | Pakistan | Islamabad | 14402 | 156 | 11486 | 2760 | 33.665087 | 73.121219 | 2020-07-16 04:44:59 | Islamabad, Pakistan | ||
2158668 | 2158668 | 2020-07-14 | Pakistan | Islamabad | 14315 | 155 | 11327 | 2833 | 33.665087 | 73.121219 | 2020-07-15 04:34:39 | Islamabad, Pakistan | ||
3491309 | 3491309 | 2020-07-13 | Pakistan | Islamabad | 14202 | 155 | 11327 | 2720 | 33.665087 | 73.121219 | 2020-07-14 04:34:46 | Islamabad, Pakistan | ||
3737572 | 3737572 | 2020-07-12 | Pakistan | Islamabad | 14108 | 153 | 10883 | 3072 | 33.665087 | 73.121219 | 2020-07-13 04:43:04 | Islamabad, Pakistan | ||
3435967 | 3435967 | 2020-07-11 | Pakistan | Islamabad | 14023 | 152 | 10645 | 3226 | 33.665087 | 73.121219 | 2020-07-12 04:34:30 | Islamabad, Pakistan | ||
3237465 | 3237465 | 2020-07-10 | Pakistan | Islamabad | 13927 | 147 | 10441 | 3339 | 33.665087 | 73.121219 | 2020-07-11 04:34:26 | Islamabad, Pakistan |
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]);