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 = "Punjab" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
478 | 478 | 2021-12-02 | Pakistan | Punjab | 443310 | 13031 | 0 | 30.811346 | 72.13913199999998 | 2021-12-03 04:23:05 | Punjab, Pakistan | |||
4494 | 4494 | 2021-10-28 | Pakistan | Punjab | 439845 | 12909 | 0 | 30.811346 | 72.13913199999998 | 2021-10-29 04:22:03 | Punjab, Pakistan | |||
16502 | 16502 | 2021-09-18 | Pakistan | Punjab | 421800 | 12396 | 0 | 30.811346 | 72.13913199999998 | 2021-09-19 04:21:34 | Punjab, Pakistan | |||
24549 | 24549 | 2022-03-20 | Pakistan | Punjab | 504442 | 13550 | 0 | 30.811346 | 72.13913199999998 | 2022-03-21 04:20:50 | Punjab, Pakistan | |||
28564 | 28564 | 2021-11-11 | Pakistan | Punjab | 441631 | 12967 | 0 | 30.811346 | 72.13913199999998 | 2021-11-12 04:22:01 | Punjab, Pakistan | |||
32563 | 32563 | 2021-08-25 | Pakistan | Punjab | 385258 | 11666 | 0 | 30.811346 | 72.13913199999998 | 2021-08-26 04:21:28 | Punjab, Pakistan | |||
43856 | 43856 | 2021-11-02 | Pakistan | Punjab | 440542 | 12929 | 0 | 30.811346 | 72.13913199999998 | 2021-11-03 06:22:09 | Punjab, Pakistan | |||
63213 | 63213 | 2022-11-12 | Pakistan | Punjab | 522880 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-13 04:21:14 | Punjab, Pakistan | |||
67208 | 67208 | 2021-09-01 | Pakistan | Punjab | 396326 | 11959 | 0 | 30.811346 | 72.13913199999998 | 2021-09-02 04:21:15 | Punjab, Pakistan | |||
71239 | 71239 | 2022-02-07 | Pakistan | Punjab | 490103 | 13267 | 0 | 30.811346 | 72.13913199999998 | 2022-02-08 04:21:15 | Punjab, Pakistan | |||
87273 | 87273 | 2021-11-09 | Pakistan | Punjab | 441378 | 12957 | 0 | 30.811346 | 72.13913199999998 | 2021-11-10 04:21:38 | Punjab, Pakistan | |||
91291 | 91291 | 2022-07-23 | Pakistan | Punjab | 511548 | 13586 | 0 | 30.811346 | 72.139132 | 2022-07-24 04:20:47 | Punjab, Pakistan | |||
99474 | 99474 | 2022-01-14 | Pakistan | Punjab | 451408 | 13087 | 0 | 30.811346 | 72.13913199999998 | 2022-01-15 04:21:07 | Punjab, Pakistan | |||
103473 | 103473 | 2021-08-15 | Pakistan | Punjab | 372750 | 11372 | 0 | 30.811346 | 72.13913199999998 | 2021-08-16 04:21:31 | Punjab, Pakistan | |||
114901 | 114901 | 2022-09-06 | Pakistan | Punjab | 521465 | 13609 | 0 | 30.811346 | 72.139132 | 2022-09-07 04:20:59 | Punjab, Pakistan | |||
126881 | 126881 | 2022-01-09 | Pakistan | Punjab | 448091 | 13080 | 0 | 30.811346 | 72.13913199999998 | 2022-01-10 04:22:07 | Punjab, Pakistan | |||
130901 | 130901 | 2022-10-04 | Pakistan | Punjab | 522243 | 13614 | 0 | 30.811346 | 72.139132 | 2022-10-05 04:23:06 | Punjab, Pakistan | |||
138119 | 138119 | 2021-12-04 | Pakistan | Punjab | 443453 | 13037 | 0 | 30.811346 | 72.13913199999998 | 2021-12-05 04:22:25 | Punjab, Pakistan | |||
142137 | 142137 | 2022-07-09 | Pakistan | Punjab | 509399 | 13579 | 0 | 30.811346 | 72.139132 | 2022-07-10 04:20:54 | Punjab, Pakistan | |||
150132 | 150132 | 2021-11-29 | Pakistan | Punjab | 443094 | 13023 | 0 | 30.811346 | 72.13913199999998 | 2021-11-30 04:22:53 | Punjab, Pakistan | |||
158161 | 158161 | 2022-03-29 | Pakistan | Punjab | 504962 | 13554 | 0 | 30.811346 | 72.13913199999998 | 2022-03-30 04:20:45 | Punjab, Pakistan | |||
162176 | 162176 | 2021-11-19 | Pakistan | Punjab | 442353 | 12994 | 0 | 30.811346 | 72.13913199999998 | 2021-11-20 04:22:17 | Punjab, Pakistan | |||
166194 | 166194 | 2022-06-21 | Pakistan | Punjab | 507771 | 13566 | 0 | 30.811346 | 72.139132 | 2022-06-22 04:20:54 | Punjab, Pakistan | |||
178173 | 178173 | 2021-09-02 | Pakistan | Punjab | 397694 | 11979 | 0 | 30.811346 | 72.13913199999998 | 2021-09-03 04:21:20 | Punjab, Pakistan | |||
186219 | 186219 | 2022-02-13 | Pakistan | Punjab | 495430 | 13363 | 0 | 30.811346 | 72.13913199999998 | 2022-02-14 04:20:51 | Punjab, Pakistan | |||
198410 | 198410 | 2022-10-19 | Pakistan | Punjab | 522243 | 13614 | 0 | 30.811346 | 72.139132 | 2022-10-20 04:22:59 | Punjab, Pakistan | |||
218131 | 218131 | 2022-12-26 | Pakistan | Punjab | 523278 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-27 04:21:07 | Punjab, Pakistan | |||
222144 | 222144 | 2022-05-09 | Pakistan | Punjab | 506499 | 13562 | 0 | 30.811346 | 72.139132 | 2022-05-10 04:20:50 | Punjab, Pakistan | |||
229376 | 229376 | 2022-05-31 | Pakistan | Punjab | 507202 | 13564 | 0 | 30.811346 | 72.139132 | 2022-06-01 04:20:55 | Punjab, Pakistan | |||
233391 | 233391 | 2022-02-11 | Pakistan | Punjab | 494238 | 13335 | 0 | 30.811346 | 72.13913199999998 | 2022-02-12 04:21:06 | Punjab, Pakistan | |||
245416 | 245416 | 2021-08-17 | Pakistan | Punjab | 374916 | 11434 | 0 | 30.811346 | 72.13913199999998 | 2021-08-18 04:21:35 | Punjab, Pakistan | |||
249430 | 249430 | 2021-09-04 | Pakistan | Punjab | 401373 | 12039 | 0 | 30.811346 | 72.13913199999998 | 2021-09-05 04:21:33 | Punjab, Pakistan | |||
253463 | 253463 | 2022-09-08 | Pakistan | Punjab | 521586 | 13610 | 0 | 30.811346 | 72.139132 | 2022-09-09 04:21:11 | Punjab, Pakistan | |||
257481 | 257481 | 2022-12-10 | Pakistan | Punjab | 523197 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-11 04:20:50 | Punjab, Pakistan | |||
261681 | 261681 | 2022-03-15 | Pakistan | Punjab | 504045 | 13540 | 0 | 30.811346 | 72.13913199999998 | 2022-03-16 04:20:50 | Punjab, Pakistan | |||
276331 | 276331 | 2021-11-03 | Pakistan | Punjab | 440678 | 12936 | 0 | 30.811346 | 72.13913199999998 | 2021-11-04 04:22:20 | Punjab, Pakistan | |||
288144 | 288144 | 2021-10-31 | Pakistan | Punjab | 440259 | 12918 | 0 | 30.811346 | 72.13913199999998 | 2021-11-01 04:22:01 | Punjab, Pakistan | |||
292164 | 292164 | 2022-11-15 | Pakistan | Punjab | 522921 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-16 04:21:09 | Punjab, Pakistan | |||
304017 | 304017 | 2022-04-16 | Pakistan | Punjab | 505660 | 13559 | 0 | 30.811346 | 72.13913199999998 | 2022-04-17 04:20:59 | Punjab, Pakistan | |||
308036 | 308036 | 2022-12-13 | Pakistan | Punjab | 523226 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-14 04:21:04 | Punjab, Pakistan | |||
312052 | 312052 | 2022-11-13 | Pakistan | Punjab | 522896 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-14 04:21:09 | Punjab, Pakistan | |||
316065 | 316065 | 2022-02-12 | Pakistan | Punjab | 494971 | 13355 | 0 | 30.811346 | 72.13913199999998 | 2022-02-13 04:21:00 | Punjab, Pakistan | |||
320084 | 320084 | 2022-10-30 | Pakistan | Punjab | 522579 | 13615 | 0 | 30.811346 | 72.139132 | 2022-10-31 04:21:36 | Punjab, Pakistan | |||
328058 | 328058 | 2022-12-27 | Pakistan | Punjab | 523278 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-28 04:21:04 | Punjab, Pakistan | |||
336085 | 336085 | 2022-03-18 | Pakistan | Punjab | 504324 | 13547 | 0 | 30.811346 | 72.13913199999998 | 2022-03-19 04:20:47 | Punjab, Pakistan | |||
348448 | 348448 | 2022-12-14 | Pakistan | Punjab | 523226 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-15 04:20:58 | Punjab, Pakistan | |||
356475 | 356475 | 2022-03-11 | Pakistan | Punjab | 503590 | 13536 | 0 | 30.811346 | 72.13913199999998 | 2022-03-12 04:20:50 | Punjab, Pakistan | |||
360491 | 360491 | 2022-05-07 | Pakistan | Punjab | 506018 | 13560 | 0 | 30.811346 | 72.139132 | 2022-05-08 04:20:49 | Punjab, Pakistan | |||
372348 | 372348 | 2022-09-13 | Pakistan | Punjab | 521842 | 13610 | 0 | 30.811346 | 72.139132 | 2022-09-14 04:20:44 | Punjab, Pakistan | |||
384375 | 384375 | 2022-09-23 | Pakistan | Punjab | 522096 | 13613 | 0 | 30.811346 | 72.139132 | 2022-09-24 04:21:40 | Punjab, Pakistan | |||
396416 | 396416 | 2022-10-07 | Pakistan | Punjab | 522243 | 13614 | 0 | 30.811346 | 72.139132 | 2022-10-08 04:22:56 | Punjab, Pakistan | |||
404442 | 404442 | 2021-12-07 | Pakistan | Punjab | 443610 | 13044 | 0 | 30.811346 | 72.13913199999998 | 2021-12-08 04:22:46 | Punjab, Pakistan | |||
419487 | 419487 | 2022-09-18 | Pakistan | Punjab | 522006 | 13612 | 0 | 30.811346 | 72.139132 | 2022-09-19 04:21:49 | Punjab, Pakistan | |||
423499 | 423499 | 2021-10-10 | Pakistan | Punjab | 436197 | 12785 | 0 | 30.811346 | 72.13913199999998 | 2021-10-11 04:21:31 | Punjab, Pakistan | |||
431509 | 431509 | 2022-11-03 | Pakistan | Punjab | 522717 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-04 04:22:11 | Punjab, Pakistan | |||
443503 | 443503 | 2021-10-20 | Pakistan | Punjab | 438433 | 12876 | 0 | 30.811346 | 72.13913199999998 | 2021-10-21 04:21:18 | Punjab, Pakistan | |||
447519 | 447519 | 2021-11-17 | Pakistan | Punjab | 442162 | 12986 | 0 | 30.811346 | 72.13913199999998 | 2021-11-18 04:21:33 | Punjab, Pakistan | |||
451539 | 451539 | 2022-12-21 | Pakistan | Punjab | 523226 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-22 04:20:56 | Punjab, Pakistan | |||
459528 | 459528 | 2022-02-02 | Pakistan | Punjab | 483779 | 13201 | 0 | 30.811346 | 72.13913199999998 | 2022-02-03 04:21:21 | Punjab, Pakistan | |||
463545 | 463545 | 2022-05-02 | Pakistan | Punjab | 506018 | 13560 | 0 | 30.811346 | 72.139132 | 2022-05-03 04:21:00 | Punjab, Pakistan | |||
467560 | 467560 | 2021-10-07 | Pakistan | Punjab | 435040 | 12757 | 0 | 30.811346 | 72.13913199999998 | 2021-10-08 04:21:25 | Punjab, Pakistan | |||
475592 | 475592 | 2022-06-26 | Pakistan | Punjab | 508112 | 13569 | 0 | 30.811346 | 72.139132 | 2022-06-27 04:21:00 | Punjab, Pakistan | |||
479742 | 479742 | 2022-11-08 | Pakistan | Punjab | 522787 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-09 04:21:22 | Punjab, Pakistan | |||
487772 | 487772 | 2022-11-25 | Pakistan | Punjab | 523014 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-26 04:21:11 | Punjab, Pakistan | |||
491784 | 491784 | 2021-10-14 | Pakistan | Punjab | 437316 | 12821 | 0 | 30.811346 | 72.13913199999998 | 2021-10-15 04:21:26 | Punjab, Pakistan | |||
495800 | 495800 | 2021-11-06 | Pakistan | Punjab | 441051 | 12946 | 0 | 30.811346 | 72.13913199999998 | 2021-11-07 04:21:53 | Punjab, Pakistan | |||
499817 | 499817 | 2022-04-02 | Pakistan | Punjab | 505127 | 13558 | 0 | 30.811346 | 72.13913199999998 | 2022-04-03 04:20:48 | Punjab, Pakistan | |||
503836 | 503836 | 2022-12-17 | Pakistan | Punjab | 523226 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-18 04:21:03 | Punjab, Pakistan | |||
507831 | 507831 | 2021-08-14 | Pakistan | Punjab | 371605 | 11347 | 0 | 30.811346 | 72.13913199999998 | 2021-08-15 04:21:41 | Punjab, Pakistan | |||
511845 | 511845 | 2021-08-19 | Pakistan | Punjab | 377208 | 11479 | 0 | 30.811346 | 72.13913199999998 | 2021-08-20 04:21:33 | Punjab, Pakistan | |||
515880 | 515880 | 2022-10-15 | Pakistan | Punjab | 522243 | 13614 | 0 | 30.811346 | 72.139132 | 2022-10-16 04:22:39 | Punjab, Pakistan | |||
534884 | 534884 | 2021-10-27 | Pakistan | Punjab | 439653 | 12904 | 0 | 30.811346 | 72.13913199999998 | 2021-10-28 04:22:08 | Punjab, Pakistan | |||
538904 | 538904 | 2022-10-26 | Pakistan | Punjab | 522243 | 13614 | 0 | 30.811346 | 72.139132 | 2022-10-27 04:22:01 | Punjab, Pakistan | |||
542920 | 542920 | 2022-12-15 | Pakistan | Punjab | 523226 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-16 04:21:01 | Punjab, Pakistan | |||
550922 | 550922 | 2021-12-08 | Pakistan | Punjab | 443682 | 13046 | 0 | 30.811346 | 72.13913199999998 | 2021-12-09 04:22:49 | Punjab, Pakistan | |||
554938 | 554938 | 2022-01-16 | Pakistan | Punjab | 453392 | 13090 | 0 | 30.811346 | 72.13913199999998 | 2022-01-17 04:21:08 | Punjab, Pakistan | |||
558956 | 558956 | 2022-06-16 | Pakistan | Punjab | 507584 | 13566 | 0 | 30.811346 | 72.139132 | 2022-06-17 04:20:56 | Punjab, Pakistan | |||
567252 | 567252 | 2021-10-29 | Pakistan | Punjab | 440003 | 12915 | 0 | 30.811346 | 72.13913199999998 | 2021-10-30 04:22:03 | Punjab, Pakistan | |||
574981 | 574981 | 2022-02-25 | Pakistan | Punjab | 500789 | 13493 | 0 | 30.811346 | 72.13913199999998 | 2022-02-26 04:21:12 | Punjab, Pakistan | |||
589775 | 589775 | 2021-08-08 | Pakistan | Punjab | 364680 | 11201 | 0 | 30.811346 | 72.13913199999998 | 2021-08-09 04:21:24 | Punjab, Pakistan | |||
593808 | 593808 | 2022-07-01 | Pakistan | Punjab | 508485 | 13571 | 0 | 30.811346 | 72.139132 | 2022-07-02 04:21:16 | Punjab, Pakistan | |||
597822 | 597822 | 2021-10-19 | Pakistan | Punjab | 438271 | 12868 | 0 | 30.811346 | 72.13913199999998 | 2021-10-20 04:21:00 | Punjab, Pakistan | |||
601838 | 601838 | 2021-09-23 | Pakistan | Punjab | 426639 | 12514 | 0 | 30.811346 | 72.13913199999998 | 2021-09-24 04:21:44 | Punjab, Pakistan | |||
618014 | 618014 | 2022-11-05 | Pakistan | Punjab | 522737 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-06 04:21:24 | Punjab, Pakistan | |||
622028 | 622028 | 2022-05-22 | Pakistan | Punjab | 507061 | 13564 | 0 | 30.811346 | 72.139132 | 2022-05-26 04:20:50 | Punjab, Pakistan | |||
630058 | 630058 | 2022-07-12 | Pakistan | Punjab | 509729 | 13580 | 0 | 30.811346 | 72.139132 | 2022-07-13 04:20:58 | Punjab, Pakistan | |||
634072 | 634072 | 2021-10-13 | Pakistan | Punjab | 437032 | 12808 | 0 | 30.811346 | 72.13913199999998 | 2021-10-14 04:21:29 | Punjab, Pakistan | |||
642085 | 642085 | 2021-09-07 | Pakistan | Punjab | 406960 | 12118 | 0 | 30.811346 | 72.13913199999998 | 2021-09-08 04:21:31 | Punjab, Pakistan | |||
650113 | 650113 | 2021-08-09 | Pakistan | Punjab | 365824 | 11239 | 0 | 30.811346 | 72.13913199999998 | 2021-08-10 04:21:27 | Punjab, Pakistan | |||
654144 | 654144 | 2021-10-22 | Pakistan | Punjab | 438818 | 12891 | 0 | 30.811346 | 72.13913199999998 | 2021-10-23 04:21:32 | Punjab, Pakistan | |||
658463 | 658463 | 2022-05-13 | Pakistan | Punjab | 506679 | 13562 | 0 | 30.811346 | 72.139132 | 2022-05-14 04:20:48 | Punjab, Pakistan | |||
670449 | 670449 | 2022-07-21 | Pakistan | Punjab | 511087 | 13585 | 0 | 30.811346 | 72.139132 | 2022-07-22 04:21:15 | Punjab, Pakistan | |||
674465 | 674465 | 2022-07-30 | Pakistan | Punjab | 512832 | 13587 | 0 | 30.811346 | 72.139132 | 2022-07-31 04:21:02 | Punjab, Pakistan | |||
682489 | 682489 | 2021-10-24 | Pakistan | Punjab | 439171 | 12896 | 0 | 30.811346 | 72.13913199999998 | 2021-10-25 04:22:31 | Punjab, Pakistan | |||
686505 | 686505 | 2021-11-13 | Pakistan | Punjab | 441720 | 12972 | 0 | 30.811346 | 72.13913199999998 | 2021-11-14 04:21:31 | Punjab, Pakistan | |||
690525 | 690525 | 2022-12-23 | Pakistan | Punjab | 523278 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-24 04:21:02 | Punjab, Pakistan | |||
694538 | 694538 | 2022-03-17 | Pakistan | Punjab | 504219 | 13545 | 0 | 30.811346 | 72.13913199999998 | 2022-03-18 04:20:55 | Punjab, Pakistan | |||
698553 | 698553 | 2021-11-04 | Pakistan | Punjab | 440788 | 12940 | 0 | 30.811346 | 72.13913199999998 | 2021-11-05 04:21:54 | Punjab, Pakistan | |||
706583 | 706583 | 2021-09-29 | Pakistan | Punjab | 431092 | 12617 | 0 | 30.811346 | 72.13913199999998 | 2021-09-30 04:21:20 | Punjab, Pakistan | |||
710602 | 710602 | 2022-11-01 | Pakistan | Punjab | 522650 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-02 04:22:09 | Punjab, 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]);