johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,866 rows where 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1491549 | 1491549 | 2021-10-12 | India | Punjab | 601913 | 16531 | 0 | 30.841465000000003 | 75.40879 | 2021-10-13 04:20:51 | Punjab, India | |||
1491750 | 1491750 | 2021-10-12 | Pakistan | Punjab | 436720 | 12800 | 0 | 30.811346 | 72.13913199999998 | 2021-10-13 04:20:51 | Punjab, Pakistan | |||
3007282 | 3007282 | 2021-10-11 | India | Punjab | 601894 | 16531 | 0 | 30.841465000000003 | 75.40879 | 2021-10-12 04:21:09 | Punjab, India | |||
3007483 | 3007483 | 2021-10-11 | Pakistan | Punjab | 436442 | 12792 | 0 | 30.811346 | 72.13913199999998 | 2021-10-12 04:21:09 | Punjab, Pakistan | |||
423298 | 423298 | 2021-10-10 | India | Punjab | 601876 | 16531 | 0 | 30.841465000000003 | 75.40879 | 2021-10-11 04:21:31 | Punjab, India | |||
423499 | 423499 | 2021-10-10 | Pakistan | Punjab | 436197 | 12785 | 0 | 30.811346 | 72.13913199999998 | 2021-10-11 04:21:31 | Punjab, Pakistan | |||
2876155 | 2876155 | 2021-10-09 | India | Punjab | 601849 | 16529 | 0 | 30.841465000000003 | 75.40879 | 2021-10-10 04:21:38 | Punjab, India | |||
2876356 | 2876356 | 2021-10-09 | Pakistan | Punjab | 435882 | 12780 | 0 | 30.811346 | 72.13913199999998 | 2021-10-10 04:21:38 | Punjab, Pakistan | |||
2959321 | 2959321 | 2021-10-08 | India | Punjab | 601821 | 16529 | 0 | 30.841465000000003 | 75.40879 | 2021-10-09 04:21:34 | Punjab, India | |||
2959522 | 2959522 | 2021-10-08 | Pakistan | Punjab | 435512 | 12770 | 0 | 30.811346 | 72.13913199999998 | 2021-10-09 04:21:34 | Punjab, Pakistan | |||
467359 | 467359 | 2021-10-07 | India | Punjab | 601805 | 16526 | 0 | 30.841465000000003 | 75.40879 | 2021-10-08 04:21:25 | Punjab, India | |||
467560 | 467560 | 2021-10-07 | Pakistan | Punjab | 435040 | 12757 | 0 | 30.811346 | 72.13913199999998 | 2021-10-08 04:21:25 | Punjab, Pakistan | |||
2458739 | 2458739 | 2021-10-06 | India | Punjab | 601782 | 16526 | 0 | 30.841465000000003 | 75.40879 | 2021-10-07 04:21:36 | Punjab, India | |||
2458940 | 2458940 | 2021-10-06 | Pakistan | Punjab | 434647 | 12744 | 0 | 30.811346 | 72.13913199999998 | 2021-10-07 04:21:36 | Punjab, Pakistan | |||
3832433 | 3832433 | 2021-10-05 | India | Punjab | 601752 | 16525 | 0 | 30.841465000000003 | 75.40879 | 2021-10-06 04:21:33 | Punjab, India | |||
3832634 | 3832634 | 2021-10-05 | Pakistan | Punjab | 434139 | 12724 | 0 | 30.811346 | 72.13913199999998 | 2021-10-06 04:21:33 | Punjab, Pakistan | |||
986926 | 986926 | 2021-10-04 | India | Punjab | 601739 | 16521 | 0 | 30.841465000000003 | 75.40879 | 2021-10-05 04:21:27 | Punjab, India | |||
987127 | 987127 | 2021-10-04 | Pakistan | Punjab | 433687 | 12710 | 0 | 30.811346 | 72.13913199999998 | 2021-10-05 04:21:27 | Punjab, Pakistan | |||
1274236 | 1274236 | 2021-10-03 | India | Punjab | 601722 | 16520 | 0 | 30.841465000000003 | 75.40879 | 2021-10-04 04:21:31 | Punjab, India | |||
1274437 | 1274437 | 2021-10-03 | Pakistan | Punjab | 433286 | 12685 | 0 | 30.811346 | 72.13913199999998 | 2021-10-04 04:21:31 | Punjab, Pakistan | |||
3927989 | 3927989 | 2021-10-02 | India | Punjab | 601698 | 16520 | 0 | 30.841465000000003 | 75.40879 | 2021-10-03 04:21:24 | Punjab, India | |||
3928190 | 3928190 | 2021-10-02 | Pakistan | Punjab | 432809 | 12672 | 0 | 30.811346 | 72.13913199999998 | 2021-10-03 04:21:24 | Punjab, Pakistan | |||
2131969 | 2131969 | 2021-10-01 | India | Punjab | 601662 | 16518 | 0 | 30.841465000000003 | 75.40879 | 2021-10-02 04:21:25 | Punjab, India | |||
2132170 | 2132170 | 2021-10-01 | Pakistan | Punjab | 432190 | 12661 | 0 | 30.811346 | 72.13913199999998 | 2021-10-02 04:21:25 | Punjab, Pakistan | |||
2772926 | 2772926 | 2021-09-30 | India | Punjab | 601635 | 16516 | 0 | 30.841465000000003 | 75.40879 | 2021-10-01 04:21:35 | Punjab, India | |||
2773127 | 2773127 | 2021-09-30 | Pakistan | Punjab | 431666 | 12637 | 0 | 30.811346 | 72.13913199999998 | 2021-10-01 04:21:35 | Punjab, Pakistan | |||
706382 | 706382 | 2021-09-29 | India | Punjab | 601600 | 16513 | 0 | 30.841465000000003 | 75.40879 | 2021-09-30 04:21:20 | Punjab, India | |||
706583 | 706583 | 2021-09-29 | Pakistan | Punjab | 431092 | 12617 | 0 | 30.811346 | 72.13913199999998 | 2021-09-30 04:21:20 | Punjab, Pakistan | |||
1334224 | 1334224 | 2021-09-28 | India | Punjab | 601578 | 16509 | 0 | 30.841465000000003 | 75.40879 | 2021-09-29 04:21:45 | Punjab, India | |||
1334425 | 1334425 | 2021-09-28 | Pakistan | Punjab | 430353 | 12595 | 0 | 30.811346 | 72.13913199999998 | 2021-09-29 04:21:45 | Punjab, Pakistan | |||
1235593 | 1235593 | 2021-09-27 | India | Punjab | 601538 | 16507 | 0 | 30.841465000000003 | 75.40879 | 2021-09-28 04:21:28 | Punjab, India | |||
1235794 | 1235794 | 2021-09-27 | Pakistan | Punjab | 429655 | 12575 | 0 | 30.811346 | 72.13913199999998 | 2021-09-28 04:21:28 | Punjab, Pakistan | |||
2075894 | 2075894 | 2021-09-26 | India | Punjab | 601500 | 16506 | 0 | 30.841465000000003 | 75.40879 | 2021-09-27 04:21:16 | Punjab, India | |||
2076095 | 2076095 | 2021-09-26 | Pakistan | Punjab | 429081 | 12559 | 0 | 30.811346 | 72.13913199999998 | 2021-09-27 04:21:16 | Punjab, Pakistan | |||
1724446 | 1724446 | 2021-09-25 | India | Punjab | 601468 | 16505 | 0 | 30.841465000000003 | 75.40879 | 2021-09-26 04:21:29 | Punjab, India | |||
1724647 | 1724647 | 2021-09-25 | Pakistan | Punjab | 428394 | 12553 | 0 | 30.811346 | 72.13913199999998 | 2021-09-26 04:21:29 | Punjab, Pakistan | |||
1921166 | 1921166 | 2021-09-24 | India | Punjab | 601444 | 16504 | 0 | 30.841465000000003 | 75.40879 | 2021-09-25 04:21:31 | Punjab, India | |||
1921367 | 1921367 | 2021-09-24 | Pakistan | Punjab | 427583 | 12535 | 0 | 30.811346 | 72.13913199999998 | 2021-09-25 04:21:31 | Punjab, Pakistan | |||
601637 | 601637 | 2021-09-23 | India | Punjab | 601422 | 16503 | 0 | 30.841465000000003 | 75.40879 | 2021-09-24 04:21:44 | Punjab, India | |||
601838 | 601838 | 2021-09-23 | Pakistan | Punjab | 426639 | 12514 | 0 | 30.811346 | 72.13913199999998 | 2021-09-24 04:21:44 | Punjab, Pakistan | |||
3011298 | 3011298 | 2021-09-22 | India | Punjab | 601401 | 16501 | 0 | 30.841465000000003 | 75.40879 | 2021-09-23 04:21:43 | Punjab, India | |||
3011482 | 3011482 | 2021-09-22 | Pakistan | Punjab | 425703 | 12490 | 0 | 30.811346 | 72.13913199999998 | 2021-09-23 04:21:43 | Punjab, Pakistan | |||
3757436 | 3757436 | 2021-09-21 | India | Punjab | 601359 | 16501 | 0 | 30.841465000000003 | 75.40879 | 2021-09-22 04:21:45 | Punjab, India | |||
3757620 | 3757620 | 2021-09-21 | Pakistan | Punjab | 424701 | 12470 | 0 | 30.811346 | 72.13913199999998 | 2021-09-22 04:21:45 | Punjab, Pakistan | |||
809539 | 809539 | 2021-09-20 | India | Punjab | 601323 | 16499 | 0 | 30.841465000000003 | 75.40879 | 2021-09-21 04:21:26 | Punjab, India | |||
809723 | 809723 | 2021-09-20 | Pakistan | Punjab | 423670 | 12449 | 0 | 30.811346 | 72.13913199999998 | 2021-09-21 04:21:26 | Punjab, Pakistan | |||
1814738 | 1814738 | 2021-09-19 | India | Punjab | 601264 | 16468 | 0 | 30.841465000000003 | 75.40879 | 2021-09-20 04:21:22 | Punjab, India | |||
1814922 | 1814922 | 2021-09-19 | Pakistan | Punjab | 422790 | 12407 | 0 | 30.811346 | 72.13913199999998 | 2021-09-20 04:21:22 | Punjab, Pakistan | |||
16318 | 16318 | 2021-09-18 | India | Punjab | 601236 | 16467 | 0 | 30.841465000000003 | 75.40879 | 2021-09-19 04:21:34 | Punjab, India | |||
16502 | 16502 | 2021-09-18 | Pakistan | Punjab | 421800 | 12396 | 0 | 30.811346 | 72.13913199999998 | 2021-09-19 04:21:34 | Punjab, Pakistan | |||
2618003 | 2618003 | 2021-09-17 | India | Punjab | 601206 | 16467 | 0 | 30.841465000000003 | 75.40879 | 2021-09-18 04:21:24 | Punjab, India | |||
2618187 | 2618187 | 2021-09-17 | Pakistan | Punjab | 420615 | 12365 | 0 | 30.811346 | 72.13913199999998 | 2021-09-18 04:21:24 | Punjab, Pakistan | |||
2808711 | 2808711 | 2021-09-16 | India | Punjab | 601180 | 16467 | 0 | 30.841465000000003 | 75.40879 | 2021-09-17 04:21:46 | Punjab, India | |||
2808895 | 2808895 | 2021-09-16 | Pakistan | Punjab | 419423 | 12345 | 0 | 30.811346 | 72.13913199999998 | 2021-09-17 04:21:46 | Punjab, Pakistan | |||
1374456 | 1374456 | 2021-09-15 | India | Punjab | 601150 | 16464 | 0 | 30.841465000000003 | 75.40879 | 2021-09-16 04:22:19 | Punjab, India | |||
1374640 | 1374640 | 2021-09-15 | Pakistan | Punjab | 418196 | 12319 | 0 | 30.811346 | 72.13913199999998 | 2021-09-16 04:22:19 | Punjab, Pakistan | |||
2462755 | 2462755 | 2021-09-14 | India | Punjab | 601109 | 16464 | 0 | 30.841465000000003 | 75.40879 | 2021-09-15 03:22:37 | Punjab, India | |||
2462939 | 2462939 | 2021-09-14 | Pakistan | Punjab | 416901 | 12291 | 0 | 30.811346 | 72.13913199999998 | 2021-09-15 03:22:37 | Punjab, Pakistan | |||
1385594 | 1385594 | 2021-09-13 | India | Punjab | 601072 | 16457 | 0 | 30.841465000000003 | 75.40879 | 2021-09-14 04:21:41 | Punjab, India | |||
1385778 | 1385778 | 2021-09-13 | Pakistan | Punjab | 415654 | 12259 | 0 | 30.811346 | 72.13913199999998 | 2021-09-14 04:21:41 | Punjab, Pakistan | |||
1884963 | 1884963 | 2021-09-12 | India | Punjab | 601040 | 16453 | 0 | 30.841465000000003 | 75.40879 | 2021-09-13 04:21:15 | Punjab, India | |||
1885147 | 1885147 | 2021-09-12 | Pakistan | Punjab | 414390 | 12225 | 0 | 30.811346 | 72.13913199999998 | 2021-09-13 04:21:15 | Punjab, Pakistan | |||
3805866 | 3805866 | 2021-09-11 | India | Punjab | 601009 | 16453 | 0 | 30.841465000000003 | 75.40879 | 2021-09-12 04:21:13 | Punjab, India | |||
3806050 | 3806050 | 2021-09-11 | Pakistan | Punjab | 413182 | 12211 | 0 | 30.811346 | 72.13913199999998 | 2021-09-12 04:21:13 | Punjab, Pakistan | |||
3448806 | 3448806 | 2021-09-10 | India | Punjab | 600970 | 16453 | 0 | 30.841465000000003 | 75.40879 | 2021-09-11 04:21:30 | Punjab, India | |||
3448990 | 3448990 | 2021-09-10 | Pakistan | Punjab | 411808 | 12198 | 0 | 30.811346 | 72.13913199999998 | 2021-09-11 04:21:30 | Punjab, Pakistan | |||
1262752 | 1262752 | 2021-09-09 | India | Punjab | 600940 | 16451 | 0 | 30.841465000000003 | 75.40879 | 2021-09-10 04:21:20 | Punjab, India | |||
1262936 | 1262936 | 2021-09-09 | Pakistan | Punjab | 410463 | 12171 | 0 | 30.811346 | 72.13913199999998 | 2021-09-10 04:21:20 | Punjab, Pakistan | |||
2279122 | 2279122 | 2021-09-08 | India | Punjab | 600914 | 16449 | 0 | 30.841465000000003 | 75.40879 | 2021-09-09 04:21:27 | Punjab, India | |||
2279306 | 2279306 | 2021-09-08 | Pakistan | Punjab | 408758 | 12135 | 0 | 30.811346 | 72.13913199999998 | 2021-09-09 04:21:27 | Punjab, Pakistan | |||
641901 | 641901 | 2021-09-07 | India | Punjab | 600877 | 16447 | 0 | 30.841465000000003 | 75.40879 | 2021-09-08 04:21:31 | Punjab, India | |||
642085 | 642085 | 2021-09-07 | Pakistan | Punjab | 406960 | 12118 | 0 | 30.811346 | 72.13913199999998 | 2021-09-08 04:21:31 | Punjab, Pakistan | |||
3193964 | 3193964 | 2021-09-06 | India | Punjab | 600849 | 16444 | 0 | 30.841465000000003 | 75.40879 | 2021-09-07 04:21:35 | Punjab, India | |||
3194148 | 3194148 | 2021-09-06 | Pakistan | Punjab | 405005 | 12096 | 0 | 30.811346 | 72.13913199999998 | 2021-09-07 04:21:35 | Punjab, Pakistan | |||
3280832 | 3280832 | 2021-09-05 | India | Punjab | 600813 | 16439 | 0 | 30.841465000000003 | 75.40879 | 2021-09-06 04:21:22 | Punjab, India | |||
3281016 | 3281016 | 2021-09-05 | Pakistan | Punjab | 403157 | 12066 | 0 | 30.811346 | 72.13913199999998 | 2021-09-06 04:21:22 | Punjab, Pakistan | |||
249246 | 249246 | 2021-09-04 | India | Punjab | 600780 | 16439 | 0 | 30.841465000000003 | 75.40879 | 2021-09-05 04:21:33 | Punjab, India | |||
249430 | 249430 | 2021-09-04 | Pakistan | Punjab | 401373 | 12039 | 0 | 30.811346 | 72.13913199999998 | 2021-09-05 04:21:33 | Punjab, Pakistan | |||
3974527 | 3974527 | 2021-09-03 | India | Punjab | 600745 | 16437 | 0 | 30.841465000000003 | 75.40879 | 2021-09-04 04:21:28 | Punjab, India | |||
3974711 | 3974711 | 2021-09-03 | Pakistan | Punjab | 397694 | 11979 | 0 | 30.811346 | 72.13913199999998 | 2021-09-04 04:21:28 | Punjab, Pakistan | |||
177989 | 177989 | 2021-09-02 | India | Punjab | 600715 | 16435 | 0 | 30.841465000000003 | 75.40879 | 2021-09-03 04:21:20 | Punjab, India | |||
178173 | 178173 | 2021-09-02 | Pakistan | Punjab | 397694 | 11979 | 0 | 30.811346 | 72.13913199999998 | 2021-09-03 04:21:20 | Punjab, Pakistan | |||
67024 | 67024 | 2021-09-01 | India | Punjab | 600651 | 16434 | 0 | 30.841465000000003 | 75.40879 | 2021-09-02 04:21:15 | Punjab, India | |||
67208 | 67208 | 2021-09-01 | Pakistan | Punjab | 396326 | 11959 | 0 | 30.811346 | 72.13913199999998 | 2021-09-02 04:21:15 | Punjab, Pakistan | |||
2067866 | 2067866 | 2021-08-31 | India | Punjab | 600614 | 16431 | 0 | 30.841465000000003 | 75.40879 | 2021-09-01 04:21:38 | Punjab, India | |||
2068050 | 2068050 | 2021-08-31 | Pakistan | Punjab | 394738 | 11915 | 0 | 30.811346 | 72.13913199999998 | 2021-09-01 04:21:38 | Punjab, Pakistan | |||
1775320 | 1775320 | 2021-08-30 | India | Punjab | 600576 | 16373 | 0 | 30.841465000000003 | 75.40879 | 2021-08-31 04:21:46 | Punjab, India | |||
1775504 | 1775504 | 2021-08-30 | Pakistan | Punjab | 393136 | 11876 | 0 | 30.811346 | 72.13913199999998 | 2021-08-31 04:21:46 | Punjab, Pakistan | |||
3891894 | 3891894 | 2021-08-29 | India | Punjab | 600551 | 16369 | 0 | 30.841465000000003 | 75.40879 | 2021-08-30 04:21:23 | Punjab, India | |||
3892078 | 3892078 | 2021-08-29 | Pakistan | Punjab | 391297 | 11823 | 0 | 30.811346 | 72.13913199999998 | 2021-08-30 04:21:23 | Punjab, Pakistan | |||
2792997 | 2792997 | 2021-08-28 | India | Punjab | 600514 | 16366 | 0 | 30.841465000000003 | 75.40879 | 2021-08-29 04:21:14 | Punjab, India | |||
2793181 | 2793181 | 2021-08-28 | Pakistan | Punjab | 389688 | 11799 | 0 | 30.811346 | 72.13913199999998 | 2021-08-29 04:21:14 | Punjab, Pakistan | |||
2923156 | 2923156 | 2021-08-27 | India | Punjab | 600463 | 16364 | 0 | 30.841465000000003 | 75.40879 | 2021-08-28 04:21:28 | Punjab, India | |||
2923340 | 2923340 | 2021-08-27 | Pakistan | Punjab | 388296 | 11759 | 0 | 30.811346 | 72.13913199999998 | 2021-08-28 04:21:28 | Punjab, Pakistan | |||
1596170 | 1596170 | 2021-08-26 | India | Punjab | 600420 | 16362 | 0 | 30.841465000000003 | 75.40879 | 2021-08-27 04:21:37 | Punjab, India | |||
1596354 | 1596354 | 2021-08-26 | Pakistan | Punjab | 386578 | 11706 | 0 | 30.811346 | 72.13913199999998 | 2021-08-27 04:21:37 | Punjab, Pakistan | |||
32379 | 32379 | 2021-08-25 | India | Punjab | 600378 | 16358 | 0 | 30.841465000000003 | 75.40879 | 2021-08-26 04:21:28 | Punjab, India | |||
32563 | 32563 | 2021-08-25 | Pakistan | Punjab | 385258 | 11666 | 0 | 30.811346 | 72.13913199999998 | 2021-08-26 04:21:28 | Punjab, Pakistan | |||
3105418 | 3105418 | 2021-08-24 | India | Punjab | 600342 | 16355 | 0 | 30.841465000000003 | 75.40879 | 2021-08-25 04:21:41 | Punjab, India | |||
3105602 | 3105602 | 2021-08-24 | Pakistan | Punjab | 383742 | 11633 | 0 | 30.811346 | 72.13913199999998 | 2021-08-25 04:21:41 | 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]);