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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3070177 | 3070177 | 2021-11-23 | Pakistan | Punjab | 442638 | 13005 | 0 | 30.811346 | 72.13913199999998 | 2021-11-24 04:22:14 | Punjab, Pakistan | |||
3749275 | 3749275 | 2021-11-22 | Pakistan | Punjab | 442556 | 13002 | 0 | 30.811346 | 72.13913199999998 | 2021-11-23 04:22:39 | Punjab, Pakistan | |||
1014482 | 1014482 | 2021-11-21 | Pakistan | Punjab | 442479 | 12999 | 0 | 30.811346 | 72.13913199999998 | 2021-11-22 04:22:20 | Punjab, Pakistan | |||
722646 | 722646 | 2021-11-20 | Pakistan | Punjab | 442422 | 12997 | 0 | 30.811346 | 72.13913199999998 | 2021-11-21 04:22:13 | Punjab, Pakistan | |||
162176 | 162176 | 2021-11-19 | Pakistan | Punjab | 442353 | 12994 | 0 | 30.811346 | 72.13913199999998 | 2021-11-20 04:22:17 | Punjab, Pakistan | |||
3289063 | 3289063 | 2021-11-18 | Pakistan | Punjab | 442268 | 12990 | 0 | 30.811346 | 72.13913199999998 | 2021-11-19 04:21:40 | Punjab, Pakistan | |||
447519 | 447519 | 2021-11-17 | Pakistan | Punjab | 442162 | 12986 | 0 | 30.811346 | 72.13913199999998 | 2021-11-18 04:21:33 | Punjab, Pakistan | |||
3342769 | 3342769 | 2021-11-16 | Pakistan | Punjab | 442068 | 12984 | 0 | 30.811346 | 72.13913199999998 | 2021-11-17 04:21:48 | Punjab, Pakistan | |||
2287605 | 2287605 | 2021-11-15 | Pakistan | Punjab | 441965 | 12980 | 0 | 30.811346 | 72.13913199999998 | 2021-11-16 04:21:10 | Punjab, Pakistan | |||
1322379 | 1322379 | 2021-11-14 | Pakistan | Punjab | 441903 | 12978 | 0 | 30.811346 | 72.13913199999998 | 2021-11-15 04:21:36 | Punjab, Pakistan | |||
686505 | 686505 | 2021-11-13 | Pakistan | Punjab | 441720 | 12972 | 0 | 30.811346 | 72.13913199999998 | 2021-11-14 04:21:31 | Punjab, Pakistan | |||
714614 | 714614 | 2021-11-12 | Pakistan | Punjab | 441720 | 12972 | 0 | 30.811346 | 72.13913199999998 | 2021-11-13 04:21:38 | Punjab, Pakistan | |||
28564 | 28564 | 2021-11-11 | Pakistan | Punjab | 441631 | 12967 | 0 | 30.811346 | 72.13913199999998 | 2021-11-12 04:22:01 | Punjab, Pakistan | |||
2845003 | 2845003 | 2021-11-10 | Pakistan | Punjab | 441493 | 12962 | 0 | 30.811346 | 72.13913199999998 | 2021-11-11 04:21:45 | Punjab, Pakistan | |||
87273 | 87273 | 2021-11-09 | Pakistan | Punjab | 441378 | 12957 | 0 | 30.811346 | 72.13913199999998 | 2021-11-10 04:21:38 | Punjab, Pakistan | |||
3639701 | 3639701 | 2021-11-08 | Pakistan | Punjab | 441257 | 12954 | 0 | 30.811346 | 72.13913199999998 | 2021-11-09 04:21:36 | Punjab, Pakistan | |||
2000809 | 2000809 | 2021-11-07 | Pakistan | Punjab | 441176 | 12949 | 0 | 30.811346 | 72.13913199999998 | 2021-11-08 04:21:43 | Punjab, Pakistan | |||
495800 | 495800 | 2021-11-06 | Pakistan | Punjab | 441051 | 12946 | 0 | 30.811346 | 72.13913199999998 | 2021-11-07 04:21:53 | Punjab, Pakistan | |||
3121655 | 3121655 | 2021-11-05 | Pakistan | Punjab | 440918 | 12943 | 0 | 30.811346 | 72.13913199999998 | 2021-11-06 04:21:51 | Punjab, Pakistan | |||
698553 | 698553 | 2021-11-04 | Pakistan | Punjab | 440788 | 12940 | 0 | 30.811346 | 72.13913199999998 | 2021-11-05 04:21:54 | Punjab, Pakistan | |||
276331 | 276331 | 2021-11-03 | Pakistan | Punjab | 440678 | 12936 | 0 | 30.811346 | 72.13913199999998 | 2021-11-04 04:22:20 | Punjab, Pakistan | |||
43856 | 43856 | 2021-11-02 | Pakistan | Punjab | 440542 | 12929 | 0 | 30.811346 | 72.13913199999998 | 2021-11-03 06:22:09 | Punjab, Pakistan | |||
3511552 | 3511552 | 2021-11-01 | Pakistan | Punjab | 440378 | 12924 | 0 | 30.811346 | 72.13913199999998 | 2021-11-02 04:22:03 | Punjab, Pakistan | |||
288144 | 288144 | 2021-10-31 | Pakistan | Punjab | 440259 | 12918 | 0 | 30.811346 | 72.13913199999998 | 2021-11-01 04:22:01 | Punjab, Pakistan | |||
2721150 | 2721150 | 2021-10-30 | Pakistan | Punjab | 440139 | 12915 | 0 | 30.811346 | 72.13913199999998 | 2021-10-31 04:22:08 | Punjab, Pakistan | |||
567252 | 567252 | 2021-10-29 | Pakistan | Punjab | 440003 | 12915 | 0 | 30.811346 | 72.13913199999998 | 2021-10-30 04:22:03 | Punjab, Pakistan | |||
4494 | 4494 | 2021-10-28 | Pakistan | Punjab | 439845 | 12909 | 0 | 30.811346 | 72.13913199999998 | 2021-10-29 04:22:03 | Punjab, Pakistan | |||
534884 | 534884 | 2021-10-27 | Pakistan | Punjab | 439653 | 12904 | 0 | 30.811346 | 72.13913199999998 | 2021-10-28 04:22:08 | Punjab, Pakistan | |||
3492321 | 3492321 | 2021-10-26 | Pakistan | Punjab | 439450 | 12902 | 0 | 30.811346 | 72.13913199999998 | 2021-10-27 04:22:32 | Punjab, Pakistan | |||
3794043 | 3794043 | 2021-10-25 | Pakistan | Punjab | 439307 | 12898 | 0 | 30.811346 | 72.13913199999998 | 2021-10-26 04:22:09 | Punjab, Pakistan | |||
682489 | 682489 | 2021-10-24 | Pakistan | Punjab | 439171 | 12896 | 0 | 30.811346 | 72.13913199999998 | 2021-10-25 04:22:31 | Punjab, Pakistan | |||
770497 | 770497 | 2021-10-23 | Pakistan | Punjab | 438989 | 12895 | 0 | 30.811346 | 72.13913199999998 | 2021-10-24 04:21:22 | Punjab, Pakistan | |||
654144 | 654144 | 2021-10-22 | Pakistan | Punjab | 438818 | 12891 | 0 | 30.811346 | 72.13913199999998 | 2021-10-23 04:21:32 | Punjab, Pakistan | |||
2123891 | 2123891 | 2021-10-21 | Pakistan | Punjab | 438636 | 12883 | 0 | 30.811346 | 72.13913199999998 | 2021-10-22 04:21:14 | Punjab, Pakistan | |||
443503 | 443503 | 2021-10-20 | Pakistan | Punjab | 438433 | 12876 | 0 | 30.811346 | 72.13913199999998 | 2021-10-21 04:21:18 | Punjab, Pakistan | |||
597822 | 597822 | 2021-10-19 | Pakistan | Punjab | 438271 | 12868 | 0 | 30.811346 | 72.13913199999998 | 2021-10-20 04:21:00 | Punjab, Pakistan | |||
2043999 | 2043999 | 2021-10-18 | Pakistan | Punjab | 438133 | 12861 | 0 | 30.811346 | 72.13913199999998 | 2021-10-19 04:20:54 | Punjab, Pakistan | |||
1909360 | 1909360 | 2021-10-17 | Pakistan | Punjab | 437974 | 12849 | 0 | 30.811346 | 72.13913199999998 | 2021-10-18 04:21:10 | Punjab, Pakistan | |||
934949 | 934949 | 2021-10-16 | Pakistan | Punjab | 437793 | 12842 | 0 | 30.811346 | 72.13913199999998 | 2021-10-17 04:21:29 | Punjab, Pakistan | |||
2943504 | 2943504 | 2021-10-15 | Pakistan | Punjab | 437572 | 12833 | 0 | 30.811346 | 72.13913199999998 | 2021-10-16 04:21:15 | Punjab, Pakistan | |||
491784 | 491784 | 2021-10-14 | Pakistan | Punjab | 437316 | 12821 | 0 | 30.811346 | 72.13913199999998 | 2021-10-15 04:21:26 | Punjab, Pakistan | |||
634072 | 634072 | 2021-10-13 | Pakistan | Punjab | 437032 | 12808 | 0 | 30.811346 | 72.13913199999998 | 2021-10-14 04:21:29 | Punjab, Pakistan | |||
1491750 | 1491750 | 2021-10-12 | Pakistan | Punjab | 436720 | 12800 | 0 | 30.811346 | 72.13913199999998 | 2021-10-13 04:20:51 | Punjab, Pakistan | |||
3007483 | 3007483 | 2021-10-11 | Pakistan | Punjab | 436442 | 12792 | 0 | 30.811346 | 72.13913199999998 | 2021-10-12 04:21:09 | Punjab, Pakistan | |||
423499 | 423499 | 2021-10-10 | Pakistan | Punjab | 436197 | 12785 | 0 | 30.811346 | 72.13913199999998 | 2021-10-11 04:21:31 | Punjab, Pakistan | |||
2876356 | 2876356 | 2021-10-09 | Pakistan | Punjab | 435882 | 12780 | 0 | 30.811346 | 72.13913199999998 | 2021-10-10 04:21:38 | Punjab, Pakistan | |||
2959522 | 2959522 | 2021-10-08 | Pakistan | Punjab | 435512 | 12770 | 0 | 30.811346 | 72.13913199999998 | 2021-10-09 04:21:34 | Punjab, Pakistan | |||
467560 | 467560 | 2021-10-07 | Pakistan | Punjab | 435040 | 12757 | 0 | 30.811346 | 72.13913199999998 | 2021-10-08 04:21:25 | Punjab, Pakistan | |||
2458940 | 2458940 | 2021-10-06 | Pakistan | Punjab | 434647 | 12744 | 0 | 30.811346 | 72.13913199999998 | 2021-10-07 04:21:36 | Punjab, Pakistan | |||
3832634 | 3832634 | 2021-10-05 | Pakistan | Punjab | 434139 | 12724 | 0 | 30.811346 | 72.13913199999998 | 2021-10-06 04:21:33 | Punjab, Pakistan | |||
987127 | 987127 | 2021-10-04 | Pakistan | Punjab | 433687 | 12710 | 0 | 30.811346 | 72.13913199999998 | 2021-10-05 04:21:27 | Punjab, Pakistan | |||
1274437 | 1274437 | 2021-10-03 | Pakistan | Punjab | 433286 | 12685 | 0 | 30.811346 | 72.13913199999998 | 2021-10-04 04:21:31 | Punjab, Pakistan | |||
3928190 | 3928190 | 2021-10-02 | Pakistan | Punjab | 432809 | 12672 | 0 | 30.811346 | 72.13913199999998 | 2021-10-03 04:21:24 | Punjab, Pakistan | |||
2132170 | 2132170 | 2021-10-01 | Pakistan | Punjab | 432190 | 12661 | 0 | 30.811346 | 72.13913199999998 | 2021-10-02 04:21:25 | Punjab, Pakistan | |||
2773127 | 2773127 | 2021-09-30 | Pakistan | Punjab | 431666 | 12637 | 0 | 30.811346 | 72.13913199999998 | 2021-10-01 04:21:35 | Punjab, Pakistan | |||
706583 | 706583 | 2021-09-29 | Pakistan | Punjab | 431092 | 12617 | 0 | 30.811346 | 72.13913199999998 | 2021-09-30 04:21:20 | Punjab, Pakistan | |||
1334425 | 1334425 | 2021-09-28 | Pakistan | Punjab | 430353 | 12595 | 0 | 30.811346 | 72.13913199999998 | 2021-09-29 04:21:45 | Punjab, Pakistan | |||
1235794 | 1235794 | 2021-09-27 | Pakistan | Punjab | 429655 | 12575 | 0 | 30.811346 | 72.13913199999998 | 2021-09-28 04:21:28 | Punjab, Pakistan | |||
2076095 | 2076095 | 2021-09-26 | Pakistan | Punjab | 429081 | 12559 | 0 | 30.811346 | 72.13913199999998 | 2021-09-27 04:21:16 | Punjab, Pakistan | |||
1724647 | 1724647 | 2021-09-25 | Pakistan | Punjab | 428394 | 12553 | 0 | 30.811346 | 72.13913199999998 | 2021-09-26 04:21:29 | Punjab, Pakistan | |||
1921367 | 1921367 | 2021-09-24 | Pakistan | Punjab | 427583 | 12535 | 0 | 30.811346 | 72.13913199999998 | 2021-09-25 04:21:31 | Punjab, Pakistan | |||
601838 | 601838 | 2021-09-23 | Pakistan | Punjab | 426639 | 12514 | 0 | 30.811346 | 72.13913199999998 | 2021-09-24 04:21:44 | Punjab, Pakistan | |||
3011482 | 3011482 | 2021-09-22 | Pakistan | Punjab | 425703 | 12490 | 0 | 30.811346 | 72.13913199999998 | 2021-09-23 04:21:43 | Punjab, Pakistan | |||
3757620 | 3757620 | 2021-09-21 | Pakistan | Punjab | 424701 | 12470 | 0 | 30.811346 | 72.13913199999998 | 2021-09-22 04:21:45 | Punjab, Pakistan | |||
809723 | 809723 | 2021-09-20 | Pakistan | Punjab | 423670 | 12449 | 0 | 30.811346 | 72.13913199999998 | 2021-09-21 04:21:26 | Punjab, Pakistan | |||
1814922 | 1814922 | 2021-09-19 | Pakistan | Punjab | 422790 | 12407 | 0 | 30.811346 | 72.13913199999998 | 2021-09-20 04:21:22 | Punjab, Pakistan | |||
16502 | 16502 | 2021-09-18 | Pakistan | Punjab | 421800 | 12396 | 0 | 30.811346 | 72.13913199999998 | 2021-09-19 04:21:34 | Punjab, Pakistan | |||
2618187 | 2618187 | 2021-09-17 | Pakistan | Punjab | 420615 | 12365 | 0 | 30.811346 | 72.13913199999998 | 2021-09-18 04:21:24 | Punjab, Pakistan | |||
2808895 | 2808895 | 2021-09-16 | Pakistan | Punjab | 419423 | 12345 | 0 | 30.811346 | 72.13913199999998 | 2021-09-17 04:21:46 | Punjab, Pakistan | |||
1374640 | 1374640 | 2021-09-15 | Pakistan | Punjab | 418196 | 12319 | 0 | 30.811346 | 72.13913199999998 | 2021-09-16 04:22:19 | Punjab, Pakistan | |||
2462939 | 2462939 | 2021-09-14 | Pakistan | Punjab | 416901 | 12291 | 0 | 30.811346 | 72.13913199999998 | 2021-09-15 03:22:37 | Punjab, Pakistan | |||
1385778 | 1385778 | 2021-09-13 | Pakistan | Punjab | 415654 | 12259 | 0 | 30.811346 | 72.13913199999998 | 2021-09-14 04:21:41 | Punjab, Pakistan | |||
1885147 | 1885147 | 2021-09-12 | Pakistan | Punjab | 414390 | 12225 | 0 | 30.811346 | 72.13913199999998 | 2021-09-13 04:21:15 | Punjab, Pakistan | |||
3806050 | 3806050 | 2021-09-11 | Pakistan | Punjab | 413182 | 12211 | 0 | 30.811346 | 72.13913199999998 | 2021-09-12 04:21:13 | Punjab, Pakistan | |||
3448990 | 3448990 | 2021-09-10 | Pakistan | Punjab | 411808 | 12198 | 0 | 30.811346 | 72.13913199999998 | 2021-09-11 04:21:30 | Punjab, Pakistan | |||
1262936 | 1262936 | 2021-09-09 | Pakistan | Punjab | 410463 | 12171 | 0 | 30.811346 | 72.13913199999998 | 2021-09-10 04:21:20 | Punjab, Pakistan | |||
2279306 | 2279306 | 2021-09-08 | Pakistan | Punjab | 408758 | 12135 | 0 | 30.811346 | 72.13913199999998 | 2021-09-09 04:21:27 | Punjab, Pakistan | |||
642085 | 642085 | 2021-09-07 | Pakistan | Punjab | 406960 | 12118 | 0 | 30.811346 | 72.13913199999998 | 2021-09-08 04:21:31 | Punjab, Pakistan | |||
3194148 | 3194148 | 2021-09-06 | Pakistan | Punjab | 405005 | 12096 | 0 | 30.811346 | 72.13913199999998 | 2021-09-07 04:21:35 | Punjab, Pakistan | |||
3281016 | 3281016 | 2021-09-05 | Pakistan | Punjab | 403157 | 12066 | 0 | 30.811346 | 72.13913199999998 | 2021-09-06 04:21:22 | Punjab, Pakistan | |||
249430 | 249430 | 2021-09-04 | Pakistan | Punjab | 401373 | 12039 | 0 | 30.811346 | 72.13913199999998 | 2021-09-05 04:21:33 | Punjab, Pakistan | |||
3974711 | 3974711 | 2021-09-03 | Pakistan | Punjab | 397694 | 11979 | 0 | 30.811346 | 72.13913199999998 | 2021-09-04 04:21:28 | Punjab, Pakistan | |||
178173 | 178173 | 2021-09-02 | Pakistan | Punjab | 397694 | 11979 | 0 | 30.811346 | 72.13913199999998 | 2021-09-03 04:21:20 | Punjab, Pakistan | |||
67208 | 67208 | 2021-09-01 | Pakistan | Punjab | 396326 | 11959 | 0 | 30.811346 | 72.13913199999998 | 2021-09-02 04:21:15 | Punjab, Pakistan | |||
2068050 | 2068050 | 2021-08-31 | Pakistan | Punjab | 394738 | 11915 | 0 | 30.811346 | 72.13913199999998 | 2021-09-01 04:21:38 | Punjab, Pakistan | |||
1775504 | 1775504 | 2021-08-30 | Pakistan | Punjab | 393136 | 11876 | 0 | 30.811346 | 72.13913199999998 | 2021-08-31 04:21:46 | Punjab, Pakistan | |||
3892078 | 3892078 | 2021-08-29 | Pakistan | Punjab | 391297 | 11823 | 0 | 30.811346 | 72.13913199999998 | 2021-08-30 04:21:23 | Punjab, Pakistan | |||
2793181 | 2793181 | 2021-08-28 | Pakistan | Punjab | 389688 | 11799 | 0 | 30.811346 | 72.13913199999998 | 2021-08-29 04:21:14 | Punjab, Pakistan | |||
2923340 | 2923340 | 2021-08-27 | Pakistan | Punjab | 388296 | 11759 | 0 | 30.811346 | 72.13913199999998 | 2021-08-28 04:21:28 | Punjab, Pakistan | |||
1596354 | 1596354 | 2021-08-26 | Pakistan | Punjab | 386578 | 11706 | 0 | 30.811346 | 72.13913199999998 | 2021-08-27 04:21:37 | Punjab, Pakistan | |||
32563 | 32563 | 2021-08-25 | Pakistan | Punjab | 385258 | 11666 | 0 | 30.811346 | 72.13913199999998 | 2021-08-26 04:21:28 | Punjab, Pakistan | |||
3105602 | 3105602 | 2021-08-24 | Pakistan | Punjab | 383742 | 11633 | 0 | 30.811346 | 72.13913199999998 | 2021-08-25 04:21:41 | Punjab, Pakistan | |||
3165773 | 3165773 | 2021-08-23 | Pakistan | Punjab | 382332 | 11605 | 0 | 30.811346 | 72.13913199999998 | 2021-08-24 04:21:19 | Punjab, Pakistan | |||
2175700 | 2175700 | 2021-08-22 | Pakistan | Punjab | 380844 | 11557 | 0 | 30.811346 | 72.13913199999998 | 2021-08-23 04:21:27 | Punjab, Pakistan | |||
3555796 | 3555796 | 2021-08-21 | Pakistan | Punjab | 379574 | 11527 | 0 | 30.811346 | 72.13913199999998 | 2021-08-22 04:21:29 | Punjab, Pakistan | |||
1854138 | 1854138 | 2021-08-20 | Pakistan | Punjab | 378288 | 11505 | 0 | 30.811346 | 72.13913199999998 | 2021-08-21 04:21:38 | Punjab, Pakistan | |||
511845 | 511845 | 2021-08-19 | Pakistan | Punjab | 377208 | 11479 | 0 | 30.811346 | 72.13913199999998 | 2021-08-20 04:21:33 | Punjab, Pakistan | |||
2518324 | 2518324 | 2021-08-18 | Pakistan | Punjab | 376252 | 11455 | 0 | 30.811346 | 72.13913199999998 | 2021-08-19 04:21:15 | Punjab, Pakistan | |||
245416 | 245416 | 2021-08-17 | Pakistan | Punjab | 374916 | 11434 | 0 | 30.811346 | 72.13913199999998 | 2021-08-18 04:21:35 | Punjab, Pakistan | |||
1604379 | 1604379 | 2021-08-16 | Pakistan | Punjab | 373718 | 11412 | 0 | 30.811346 | 72.13913199999998 | 2021-08-17 04:21:49 | 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]);