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 recovered
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
396212 | 396212 | 2022-10-07 | India | Punjab | 784721 | 17917 | 0 | 30.841465 | 75.40879 | 2022-10-08 04:22:56 | Punjab, India | |||
396416 | 396416 | 2022-10-07 | Pakistan | Punjab | 522243 | 13614 | 0 | 30.811346 | 72.139132 | 2022-10-08 04:22:56 | Punjab, Pakistan | |||
404241 | 404241 | 2021-12-07 | India | Punjab | 603556 | 16612 | 0 | 30.841465000000003 | 75.40879 | 2021-12-08 04:22:46 | Punjab, India | |||
404442 | 404442 | 2021-12-07 | Pakistan | Punjab | 443610 | 13044 | 0 | 30.811346 | 72.13913199999998 | 2021-12-08 04:22:46 | Punjab, Pakistan | |||
419283 | 419283 | 2022-09-18 | India | Punjab | 784215 | 17910 | 0 | 30.841465 | 75.40879 | 2022-09-19 04:21:49 | Punjab, India | |||
419487 | 419487 | 2022-09-18 | Pakistan | Punjab | 522006 | 13612 | 0 | 30.811346 | 72.139132 | 2022-09-19 04:21:49 | 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 | |||
431305 | 431305 | 2022-11-03 | India | Punjab | 785217 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-04 04:22:11 | Punjab, India | |||
431509 | 431509 | 2022-11-03 | Pakistan | Punjab | 522717 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-04 04:22:11 | Punjab, Pakistan | |||
443302 | 443302 | 2021-10-20 | India | Punjab | 602113 | 16550 | 0 | 30.841465000000003 | 75.40879 | 2021-10-21 04:21:18 | Punjab, India | |||
443503 | 443503 | 2021-10-20 | Pakistan | Punjab | 438433 | 12876 | 0 | 30.811346 | 72.13913199999998 | 2021-10-21 04:21:18 | Punjab, Pakistan | |||
447318 | 447318 | 2021-11-17 | India | Punjab | 602870 | 16575 | 0 | 30.841465000000003 | 75.40879 | 2021-11-18 04:21:33 | Punjab, India | |||
447519 | 447519 | 2021-11-17 | Pakistan | Punjab | 442162 | 12986 | 0 | 30.811346 | 72.13913199999998 | 2021-11-18 04:21:33 | Punjab, Pakistan | |||
451335 | 451335 | 2022-12-21 | India | Punjab | 785375 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-22 04:20:56 | Punjab, India | |||
451539 | 451539 | 2022-12-21 | Pakistan | Punjab | 523226 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-22 04:20:56 | Punjab, Pakistan | |||
459327 | 459327 | 2022-02-02 | India | Punjab | 746837 | 17320 | 0 | 30.841465000000003 | 75.40879 | 2022-02-03 04:21:21 | Punjab, India | |||
459528 | 459528 | 2022-02-02 | Pakistan | Punjab | 483779 | 13201 | 0 | 30.811346 | 72.13913199999998 | 2022-02-03 04:21:21 | Punjab, Pakistan | |||
463344 | 463344 | 2022-05-02 | India | Punjab | 759646 | 17751 | 0 | 30.841465 | 75.40879 | 2022-05-03 04:21:00 | Punjab, India | |||
463545 | 463545 | 2022-05-02 | Pakistan | Punjab | 506018 | 13560 | 0 | 30.811346 | 72.139132 | 2022-05-03 04:21:00 | 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 | |||
475390 | 475390 | 2022-06-26 | India | Punjab | 762209 | 17766 | 0 | 30.841465 | 75.40879 | 2022-06-27 04:21:00 | Punjab, India | |||
475592 | 475592 | 2022-06-26 | Pakistan | Punjab | 508112 | 13569 | 0 | 30.811346 | 72.139132 | 2022-06-27 04:21:00 | Punjab, Pakistan | |||
479538 | 479538 | 2022-11-08 | India | Punjab | 784026 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-09 04:21:22 | Punjab, India | |||
479742 | 479742 | 2022-11-08 | Pakistan | Punjab | 522787 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-09 04:21:22 | Punjab, Pakistan | |||
487568 | 487568 | 2022-11-25 | India | Punjab | 785351 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-26 04:21:11 | Punjab, India | |||
487772 | 487772 | 2022-11-25 | Pakistan | Punjab | 523014 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-26 04:21:11 | Punjab, Pakistan | |||
491583 | 491583 | 2021-10-14 | India | Punjab | 601971 | 16538 | 0 | 30.841465000000003 | 75.40879 | 2021-10-15 04:21:26 | Punjab, India | |||
491784 | 491784 | 2021-10-14 | Pakistan | Punjab | 437316 | 12821 | 0 | 30.811346 | 72.13913199999998 | 2021-10-15 04:21:26 | Punjab, Pakistan | |||
495599 | 495599 | 2021-11-06 | India | Punjab | 602517 | 16562 | 0 | 30.841465000000003 | 75.40879 | 2021-11-07 04:21:53 | Punjab, India | |||
495800 | 495800 | 2021-11-06 | Pakistan | Punjab | 441051 | 12946 | 0 | 30.811346 | 72.13913199999998 | 2021-11-07 04:21:53 | Punjab, Pakistan | |||
499616 | 499616 | 2022-04-02 | India | Punjab | 759143 | 17741 | 0 | 30.841465000000003 | 75.40879 | 2022-04-03 04:20:48 | Punjab, India | |||
499817 | 499817 | 2022-04-02 | Pakistan | Punjab | 505127 | 13558 | 0 | 30.811346 | 72.13913199999998 | 2022-04-03 04:20:48 | Punjab, Pakistan | |||
503632 | 503632 | 2022-12-17 | India | Punjab | 785375 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-18 04:21:03 | Punjab, India | |||
503836 | 503836 | 2022-12-17 | Pakistan | Punjab | 523226 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-18 04:21:03 | Punjab, Pakistan | |||
507647 | 507647 | 2021-08-14 | India | Punjab | 599896 | 16340 | 0 | 30.841465000000003 | 75.40879 | 2021-08-15 04:21:41 | Punjab, India | |||
507831 | 507831 | 2021-08-14 | Pakistan | Punjab | 371605 | 11347 | 0 | 30.811346 | 72.13913199999998 | 2021-08-15 04:21:41 | Punjab, Pakistan | |||
511661 | 511661 | 2021-08-19 | India | Punjab | 600123 | 16347 | 0 | 30.841465000000003 | 75.40879 | 2021-08-20 04:21:33 | Punjab, India | |||
511845 | 511845 | 2021-08-19 | Pakistan | Punjab | 377208 | 11479 | 0 | 30.811346 | 72.13913199999998 | 2021-08-20 04:21:33 | Punjab, Pakistan | |||
515676 | 515676 | 2022-10-15 | India | Punjab | 784923 | 17918 | 0 | 30.841465 | 75.40879 | 2022-10-16 04:22:39 | Punjab, India | |||
515880 | 515880 | 2022-10-15 | Pakistan | Punjab | 522243 | 13614 | 0 | 30.811346 | 72.139132 | 2022-10-16 04:22:39 | Punjab, Pakistan | |||
534683 | 534683 | 2021-10-27 | India | Punjab | 602289 | 16556 | 0 | 30.841465000000003 | 75.40879 | 2021-10-28 04:22:08 | Punjab, India | |||
534884 | 534884 | 2021-10-27 | Pakistan | Punjab | 439653 | 12904 | 0 | 30.811346 | 72.13913199999998 | 2021-10-28 04:22:08 | Punjab, Pakistan | |||
538700 | 538700 | 2022-10-26 | India | Punjab | 785100 | 17920 | 0 | 30.841465 | 75.40879 | 2022-10-27 04:22:01 | Punjab, India | |||
538904 | 538904 | 2022-10-26 | Pakistan | Punjab | 522243 | 13614 | 0 | 30.811346 | 72.139132 | 2022-10-27 04:22:01 | Punjab, Pakistan | |||
542716 | 542716 | 2022-12-15 | India | Punjab | 785375 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-16 04:21:01 | Punjab, India | |||
542920 | 542920 | 2022-12-15 | Pakistan | Punjab | 523226 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-16 04:21:01 | Punjab, Pakistan | |||
550721 | 550721 | 2021-12-08 | India | Punjab | 603578 | 16614 | 0 | 30.841465000000003 | 75.40879 | 2021-12-09 04:22:49 | Punjab, India | |||
550922 | 550922 | 2021-12-08 | Pakistan | Punjab | 443682 | 13046 | 0 | 30.811346 | 72.13913199999998 | 2021-12-09 04:22:49 | Punjab, Pakistan | |||
554737 | 554737 | 2022-01-16 | India | Punjab | 663867 | 16769 | 0 | 30.841465000000003 | 75.40879 | 2022-01-17 04:21:08 | Punjab, India | |||
554938 | 554938 | 2022-01-16 | Pakistan | Punjab | 453392 | 13090 | 0 | 30.811346 | 72.13913199999998 | 2022-01-17 04:21:08 | Punjab, Pakistan | |||
558754 | 558754 | 2022-06-16 | India | Punjab | 760999 | 17756 | 0 | 30.841465 | 75.40879 | 2022-06-17 04:20:56 | Punjab, India | |||
558956 | 558956 | 2022-06-16 | Pakistan | Punjab | 507584 | 13566 | 0 | 30.811346 | 72.139132 | 2022-06-17 04:20:56 | Punjab, Pakistan | |||
567051 | 567051 | 2021-10-29 | India | Punjab | 602349 | 16557 | 0 | 30.841465000000003 | 75.40879 | 2021-10-30 04:22:03 | Punjab, India | |||
567252 | 567252 | 2021-10-29 | Pakistan | Punjab | 440003 | 12915 | 0 | 30.811346 | 72.13913199999998 | 2021-10-30 04:22:03 | Punjab, Pakistan | |||
574780 | 574780 | 2022-02-25 | India | Punjab | 757859 | 17701 | 0 | 30.841465000000003 | 75.40879 | 2022-02-26 04:21:12 | Punjab, India | |||
574981 | 574981 | 2022-02-25 | Pakistan | Punjab | 500789 | 13493 | 0 | 30.811346 | 72.13913199999998 | 2022-02-26 04:21:12 | Punjab, Pakistan | |||
589591 | 589591 | 2021-08-08 | India | Punjab | 599482 | 16316 | 0 | 30.841465000000003 | 75.40879 | 2021-08-09 04:21:24 | Punjab, India | |||
589775 | 589775 | 2021-08-08 | Pakistan | Punjab | 364680 | 11201 | 0 | 30.811346 | 72.13913199999998 | 2021-08-09 04:21:24 | Punjab, Pakistan | |||
593606 | 593606 | 2022-07-01 | India | Punjab | 763150 | 17776 | 0 | 30.841465 | 75.40879 | 2022-07-02 04:21:16 | Punjab, India | |||
593808 | 593808 | 2022-07-01 | Pakistan | Punjab | 508485 | 13571 | 0 | 30.811346 | 72.139132 | 2022-07-02 04:21:16 | Punjab, Pakistan | |||
597621 | 597621 | 2021-10-19 | India | Punjab | 602081 | 16549 | 0 | 30.841465000000003 | 75.40879 | 2021-10-20 04:21:00 | Punjab, India | |||
597822 | 597822 | 2021-10-19 | Pakistan | Punjab | 438271 | 12868 | 0 | 30.811346 | 72.13913199999998 | 2021-10-20 04:21:00 | 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 | |||
617810 | 617810 | 2022-11-05 | India | Punjab | 785237 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-06 04:21:24 | Punjab, India | |||
618014 | 618014 | 2022-11-05 | Pakistan | Punjab | 522737 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-06 04:21:24 | Punjab, Pakistan | |||
621826 | 621826 | 2022-05-22 | India | Punjab | 760241 | 17752 | 0 | 30.841465 | 75.40879 | 2022-05-26 04:20:50 | Punjab, India | |||
622028 | 622028 | 2022-05-22 | Pakistan | Punjab | 507061 | 13564 | 0 | 30.811346 | 72.139132 | 2022-05-26 04:20:50 | Punjab, Pakistan | |||
629856 | 629856 | 2022-07-12 | India | Punjab | 765017 | 17786 | 0 | 30.841465 | 75.40879 | 2022-07-13 04:20:58 | Punjab, India | |||
630058 | 630058 | 2022-07-12 | Pakistan | Punjab | 509729 | 13580 | 0 | 30.811346 | 72.139132 | 2022-07-13 04:20:58 | Punjab, Pakistan | |||
633871 | 633871 | 2021-10-13 | India | Punjab | 601938 | 16532 | 0 | 30.841465000000003 | 75.40879 | 2021-10-14 04:21:29 | Punjab, India | |||
634072 | 634072 | 2021-10-13 | Pakistan | Punjab | 437032 | 12808 | 0 | 30.811346 | 72.13913199999998 | 2021-10-14 04:21:29 | 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 | |||
649929 | 649929 | 2021-08-09 | India | Punjab | 599514 | 16320 | 0 | 30.841465000000003 | 75.40879 | 2021-08-10 04:21:27 | Punjab, India | |||
650113 | 650113 | 2021-08-09 | Pakistan | Punjab | 365824 | 11239 | 0 | 30.811346 | 72.13913199999998 | 2021-08-10 04:21:27 | Punjab, Pakistan | |||
653943 | 653943 | 2021-10-22 | India | Punjab | 602163 | 16551 | 0 | 30.841465000000003 | 75.40879 | 2021-10-23 04:21:32 | Punjab, India | |||
654144 | 654144 | 2021-10-22 | Pakistan | Punjab | 438818 | 12891 | 0 | 30.811346 | 72.13913199999998 | 2021-10-23 04:21:32 | Punjab, Pakistan | |||
658262 | 658262 | 2022-05-13 | India | Punjab | 760028 | 17751 | 0 | 30.841465 | 75.40879 | 2022-05-14 04:20:48 | Punjab, India | |||
658463 | 658463 | 2022-05-13 | Pakistan | Punjab | 506679 | 13562 | 0 | 30.811346 | 72.139132 | 2022-05-14 04:20:48 | Punjab, Pakistan | |||
670247 | 670247 | 2022-07-21 | India | Punjab | 769349 | 17800 | 0 | 30.841465 | 75.40879 | 2022-07-22 04:21:15 | Punjab, India | |||
670449 | 670449 | 2022-07-21 | Pakistan | Punjab | 511087 | 13585 | 0 | 30.811346 | 72.139132 | 2022-07-22 04:21:15 | Punjab, Pakistan | |||
674263 | 674263 | 2022-07-30 | India | Punjab | 773530 | 17814 | 0 | 30.841465 | 75.40879 | 2022-07-31 04:21:02 | Punjab, India | |||
674465 | 674465 | 2022-07-30 | Pakistan | Punjab | 512832 | 13587 | 0 | 30.811346 | 72.139132 | 2022-07-31 04:21:02 | Punjab, Pakistan | |||
682288 | 682288 | 2021-10-24 | India | Punjab | 602209 | 16551 | 0 | 30.841465000000003 | 75.40879 | 2021-10-25 04:22:31 | Punjab, India | |||
682489 | 682489 | 2021-10-24 | Pakistan | Punjab | 439171 | 12896 | 0 | 30.811346 | 72.13913199999998 | 2021-10-25 04:22:31 | Punjab, Pakistan | |||
686304 | 686304 | 2021-11-13 | India | Punjab | 602778 | 16571 | 0 | 30.841465000000003 | 75.40879 | 2021-11-14 04:21:31 | Punjab, India | |||
686505 | 686505 | 2021-11-13 | Pakistan | Punjab | 441720 | 12972 | 0 | 30.811346 | 72.13913199999998 | 2021-11-14 04:21:31 | Punjab, Pakistan | |||
690321 | 690321 | 2022-12-23 | India | Punjab | 785389 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-24 04:21:02 | Punjab, India | |||
690525 | 690525 | 2022-12-23 | Pakistan | Punjab | 523278 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-24 04:21:02 | Punjab, Pakistan | |||
694337 | 694337 | 2022-03-17 | India | Punjab | 758875 | 17737 | 0 | 30.841465000000003 | 75.40879 | 2022-03-18 04:20:55 | Punjab, India | |||
694538 | 694538 | 2022-03-17 | Pakistan | Punjab | 504219 | 13545 | 0 | 30.811346 | 72.13913199999998 | 2022-03-18 04:20:55 | Punjab, Pakistan | |||
698352 | 698352 | 2021-11-04 | India | Punjab | 602466 | 16562 | 0 | 30.841465000000003 | 75.40879 | 2021-11-05 04:21:54 | Punjab, India | |||
698553 | 698553 | 2021-11-04 | Pakistan | Punjab | 440788 | 12940 | 0 | 30.811346 | 72.13913199999998 | 2021-11-05 04:21:54 | 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 | |||
710398 | 710398 | 2022-11-01 | India | Punjab | 785196 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-02 04:22:09 | Punjab, India | |||
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]);