daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,866 rows where province_or_state = "Punjab" sorted by province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, combined_key, day (date), last_update (date)
day | country_or_region | province_or_state ▼ | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | India | Punjab | 603352 | 16606 | 0 | 30.841465000000003 | 75.40879 | 2021-12-03 04:23:05 | Punjab, India | |||
2021-12-02 | Pakistan | Punjab | 443310 | 13031 | 0 | 30.811346 | 72.13913199999998 | 2021-12-03 04:23:05 | Punjab, Pakistan | |||
2021-10-28 | India | Punjab | 602320 | 16556 | 0 | 30.841465000000003 | 75.40879 | 2021-10-29 04:22:03 | Punjab, India | |||
2021-10-28 | Pakistan | Punjab | 439845 | 12909 | 0 | 30.811346 | 72.13913199999998 | 2021-10-29 04:22:03 | Punjab, Pakistan | |||
2020-10-25 | India | Punjab | 131055 | 4117 | 122721 | 4217 | 30.841465000000003 | 75.40879 | 2020-10-26 04:25:02 | Punjab, India | ||
2020-10-25 | Pakistan | Punjab | 102875 | 2335 | 97348 | 3192 | 30.811346 | 72.13913199999998 | 2020-10-26 04:25:02 | Punjab, Pakistan | ||
2021-01-26 | India | Punjab | 172218 | 5571 | 164541 | 2106 | 30.841465000000003 | 75.40879 | 2021-01-27 05:23:41 | Punjab, India | ||
2021-01-26 | Pakistan | Punjab | 155214 | 4646 | 139887 | 10681 | 30.811346 | 72.13913199999998 | 2021-01-27 05:23:41 | Punjab, Pakistan | ||
2021-09-18 | India | Punjab | 601236 | 16467 | 0 | 30.841465000000003 | 75.40879 | 2021-09-19 04:21:34 | Punjab, India | |||
2021-09-18 | Pakistan | Punjab | 421800 | 12396 | 0 | 30.811346 | 72.13913199999998 | 2021-09-19 04:21:34 | Punjab, Pakistan | |||
2021-05-28 | India | Punjab | 559795 | 14180 | 500651 | 44964 | 30.841465000000003 | 75.40879 | 2021-05-29 04:20:41 | Punjab, India | ||
2021-05-28 | Pakistan | Punjab | 338377 | 9960 | 308275 | 20142 | 30.811346 | 72.13913199999998 | 2021-05-29 04:20:41 | Punjab, Pakistan | ||
2022-03-20 | India | Punjab | 758931 | 17737 | 0 | 30.841465000000003 | 75.40879 | 2022-03-21 04:20:50 | Punjab, India | |||
2022-03-20 | Pakistan | Punjab | 504442 | 13550 | 0 | 30.811346 | 72.13913199999998 | 2022-03-21 04:20:50 | Punjab, Pakistan | |||
2021-11-11 | India | Punjab | 602695 | 16570 | 0 | 30.841465000000003 | 75.40879 | 2021-11-12 04:22:01 | Punjab, India | |||
2021-11-11 | Pakistan | Punjab | 441631 | 12967 | 0 | 30.811346 | 72.13913199999998 | 2021-11-12 04:22:01 | Punjab, Pakistan | |||
2021-08-25 | India | Punjab | 600378 | 16358 | 0 | 30.841465000000003 | 75.40879 | 2021-08-26 04:21:28 | Punjab, India | |||
2021-08-25 | Pakistan | Punjab | 385258 | 11666 | 0 | 30.811346 | 72.13913199999998 | 2021-08-26 04:21:28 | Punjab, Pakistan | |||
2021-04-12 | India | Punjab | 276223 | 7559 | 240798 | 27866 | 30.841465000000003 | 75.40879 | 2021-04-13 04:20:37 | Punjab, India | ||
2021-04-12 | Pakistan | Punjab | 252974 | 7062 | 205912 | 40000 | 30.811346 | 72.13913199999998 | 2021-04-13 04:20:37 | Punjab, Pakistan | ||
2021-11-02 | India | Punjab | 602434 | 16561 | 0 | 30.841465000000003 | 75.40879 | 2021-11-03 06:22:09 | Punjab, India | |||
2021-11-02 | Pakistan | Punjab | 440542 | 12929 | 0 | 30.811346 | 72.13913199999998 | 2021-11-03 06:22:09 | Punjab, Pakistan | |||
2021-05-29 | India | Punjab | 562831 | 14305 | 506349 | 42177 | 30.841465000000003 | 75.40879 | 2021-05-30 04:20:55 | Punjab, India | ||
2021-05-29 | Pakistan | Punjab | 339073 | 9982 | 308733 | 20358 | 30.811346 | 72.13913199999998 | 2021-05-30 04:20:55 | Punjab, Pakistan | ||
2021-03-07 | India | Punjab | 188391 | 5927 | 174967 | 7497 | 30.841465000000003 | 75.40879 | 2021-03-08 05:24:48 | Punjab, India | ||
2021-03-07 | Pakistan | Punjab | 177823 | 5565 | 165678 | 6580 | 30.811346 | 72.13913199999998 | 2021-03-08 05:24:48 | Punjab, Pakistan | ||
2020-07-23 | India | Punjab | 11739 | 277 | 7741 | 3721 | 30.841465000000003 | 75.40879 | 2020-07-24 05:30:40 | Punjab, India | ||
2020-07-23 | Pakistan | Punjab | 91423 | 2105 | 68439 | 20879 | 30.811346 | 72.13913199999998 | 2020-07-24 05:30:40 | Punjab, Pakistan | ||
2022-11-12 | India | Punjab | 785280 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-13 04:21:14 | Punjab, India | |||
2022-11-12 | Pakistan | Punjab | 522880 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-13 04:21:14 | Punjab, Pakistan | |||
2021-09-01 | India | Punjab | 600651 | 16434 | 0 | 30.841465000000003 | 75.40879 | 2021-09-02 04:21:15 | Punjab, India | |||
2021-09-01 | Pakistan | Punjab | 396326 | 11959 | 0 | 30.811346 | 72.13913199999998 | 2021-09-02 04:21:15 | Punjab, Pakistan | |||
2022-02-07 | India | Punjab | 752635 | 17469 | 0 | 30.841465000000003 | 75.40879 | 2022-02-08 04:21:15 | Punjab, India | |||
2022-02-07 | Pakistan | Punjab | 490103 | 13267 | 0 | 30.811346 | 72.13913199999998 | 2022-02-08 04:21:15 | Punjab, Pakistan | |||
2020-12-03 | India | Punjab | 154064 | 4862 | 141478 | 7724 | 30.841465000000003 | 75.40879 | 2020-12-04 05:27:27 | Punjab, India | ||
2020-12-03 | Pakistan | Punjab | 121753 | 3115 | 99164 | 19474 | 30.811346 | 72.13913199999998 | 2020-12-04 05:27:27 | Punjab, Pakistan | ||
2020-10-14 | India | Punjab | 125760 | 3925 | 114075 | 7760 | 30.841465000000003 | 75.40879 | 2020-10-15 04:24:28 | Punjab, India | ||
2020-10-14 | Pakistan | Punjab | 101237 | 2277 | 96989 | 1971 | 30.811346 | 72.13913199999998 | 2020-10-15 04:24:28 | Punjab, Pakistan | ||
2021-05-25 | India | Punjab | 548231 | 13642 | 481462 | 53127 | 30.841465000000003 | 75.40879 | 2021-05-26 04:20:35 | Punjab, India | ||
2021-05-25 | Pakistan | Punjab | 336315 | 9875 | 304752 | 21688 | 30.811346 | 72.13913199999998 | 2021-05-26 04:20:35 | Punjab, Pakistan | ||
2021-11-09 | India | Punjab | 602616 | 16566 | 0 | 30.841465000000003 | 75.40879 | 2021-11-10 04:21:38 | Punjab, India | |||
2021-11-09 | Pakistan | Punjab | 441378 | 12957 | 0 | 30.811346 | 72.13913199999998 | 2021-11-10 04:21:38 | Punjab, Pakistan | |||
2022-07-23 | India | Punjab | 770237 | 17800 | 0 | 30.841465 | 75.40879 | 2022-07-24 04:20:47 | Punjab, India | |||
2022-07-23 | Pakistan | Punjab | 511548 | 13586 | 0 | 30.811346 | 72.139132 | 2022-07-24 04:20:47 | Punjab, Pakistan | |||
2020-08-04 | India | Punjab | 19015 | 462 | 12491 | 6062 | 30.841465000000003 | 75.40879 | 2020-08-05 04:34:43 | Punjab, India | ||
2020-08-04 | Pakistan | Punjab | 93336 | 2153 | 82575 | 8608 | 30.811346 | 72.13913199999998 | 2020-08-05 04:34:43 | Punjab, Pakistan | ||
2022-01-14 | India | Punjab | 649736 | 16731 | 0 | 30.841465000000003 | 75.40879 | 2022-01-15 04:21:07 | Punjab, India | |||
2022-01-14 | Pakistan | Punjab | 451408 | 13087 | 0 | 30.811346 | 72.13913199999998 | 2022-01-15 04:21:07 | Punjab, Pakistan | |||
2021-08-15 | India | Punjab | 599942 | 16342 | 0 | 30.841465000000003 | 75.40879 | 2021-08-16 04:21:31 | Punjab, India | |||
2021-08-15 | Pakistan | Punjab | 372750 | 11372 | 0 | 30.811346 | 72.13913199999998 | 2021-08-16 04:21:31 | Punjab, Pakistan | |||
2021-06-19 | India | Punjab | 591762 | 15802 | 567883 | 8077 | 30.841465000000003 | 75.40879 | 2021-06-20 04:21:48 | Punjab, India | ||
2021-06-19 | Pakistan | Punjab | 344799 | 10615 | 323925 | 10259 | 30.811346 | 72.13913199999998 | 2021-06-20 04:21:48 | Punjab, Pakistan | ||
2022-09-06 | India | Punjab | 780990 | 17904 | 0 | 30.841465 | 75.40879 | 2022-09-07 04:20:59 | Punjab, India | |||
2022-09-06 | Pakistan | Punjab | 521465 | 13609 | 0 | 30.811346 | 72.139132 | 2022-09-07 04:20:59 | Punjab, Pakistan | |||
2020-07-19 | India | Punjab | 10100 | 254 | 6535 | 3311 | 30.841465000000003 | 75.40879 | 2020-07-20 05:34:40 | Punjab, India | ||
2020-07-19 | Pakistan | Punjab | 90191 | 2083 | 65689 | 22419 | 30.811346 | 72.13913199999998 | 2020-07-20 05:34:40 | Punjab, Pakistan | ||
2020-11-18 | India | Punjab | 143395 | 4541 | 132917 | 5937 | 30.841465000000003 | 75.40879 | 2020-11-19 05:25:23 | Punjab, India | ||
2020-11-18 | Pakistan | Punjab | 112284 | 2519 | 97846 | 11919 | 30.811346 | 72.13913199999998 | 2020-11-19 05:25:23 | Punjab, Pakistan | ||
2022-01-09 | India | Punjab | 621419 | 16675 | 0 | 30.841465000000003 | 75.40879 | 2022-01-10 04:22:07 | Punjab, India | |||
2022-01-09 | Pakistan | Punjab | 448091 | 13080 | 0 | 30.811346 | 72.13913199999998 | 2022-01-10 04:22:07 | Punjab, Pakistan | |||
2022-10-04 | India | Punjab | 784660 | 17917 | 0 | 30.841465 | 75.40879 | 2022-10-05 04:23:06 | Punjab, India | |||
2022-10-04 | Pakistan | Punjab | 522243 | 13614 | 0 | 30.811346 | 72.139132 | 2022-10-05 04:23:06 | Punjab, Pakistan | |||
2021-12-04 | India | Punjab | 603410 | 16607 | 0 | 30.841465000000003 | 75.40879 | 2021-12-05 04:22:25 | Punjab, India | |||
2021-12-04 | Pakistan | Punjab | 443453 | 13037 | 0 | 30.811346 | 72.13913199999998 | 2021-12-05 04:22:25 | Punjab, Pakistan | |||
2022-07-09 | India | Punjab | 764513 | 17784 | 0 | 30.841465 | 75.40879 | 2022-07-10 04:20:54 | Punjab, India | |||
2022-07-09 | Pakistan | Punjab | 509399 | 13579 | 0 | 30.811346 | 72.139132 | 2022-07-10 04:20:54 | Punjab, Pakistan | |||
2020-08-15 | India | Punjab | 30041 | 771 | 18863 | 10407 | 30.841465000000003 | 75.40879 | 2020-08-16 04:27:42 | Punjab, India | ||
2020-08-15 | Pakistan | Punjab | 95203 | 2180 | 86424 | 6599 | 30.811346 | 72.13913199999998 | 2020-08-16 04:27:42 | Punjab, Pakistan | ||
2021-11-29 | India | Punjab | 603258 | 16599 | 0 | 30.841465000000003 | 75.40879 | 2021-11-30 04:22:53 | Punjab, India | |||
2021-11-29 | Pakistan | Punjab | 443094 | 13023 | 0 | 30.811346 | 72.13913199999998 | 2021-11-30 04:22:53 | Punjab, Pakistan | |||
2021-01-08 | India | Punjab | 168187 | 5422 | 159790 | 2975 | 30.841465000000003 | 75.40879 | 2021-01-09 05:22:18 | Punjab, India | ||
2021-01-08 | Pakistan | Punjab | 144111 | 4242 | 129852 | 10017 | 30.811346 | 72.13913199999998 | 2021-01-09 05:22:18 | Punjab, Pakistan | ||
2022-03-29 | India | Punjab | 759094 | 17741 | 0 | 30.841465000000003 | 75.40879 | 2022-03-30 04:20:45 | Punjab, India | |||
2022-03-29 | Pakistan | Punjab | 504962 | 13554 | 0 | 30.811346 | 72.13913199999998 | 2022-03-30 04:20:45 | Punjab, Pakistan | |||
2021-11-19 | India | Punjab | 602943 | 16580 | 0 | 30.841465000000003 | 75.40879 | 2021-11-20 04:22:17 | Punjab, India | |||
2021-11-19 | Pakistan | Punjab | 442353 | 12994 | 0 | 30.811346 | 72.13913199999998 | 2021-11-20 04:22:17 | Punjab, Pakistan | |||
2022-06-21 | India | Punjab | 761487 | 17759 | 0 | 30.841465 | 75.40879 | 2022-06-22 04:20:54 | Punjab, India | |||
2022-06-21 | Pakistan | Punjab | 507771 | 13566 | 0 | 30.811346 | 72.139132 | 2022-06-22 04:20:54 | Punjab, Pakistan | |||
2021-04-16 | India | Punjab | 290707 | 7772 | 252190 | 30745 | 30.841465000000003 | 75.40879 | 2021-04-17 04:20:40 | Punjab, India | ||
2021-04-16 | Pakistan | Punjab | 264010 | 7333 | 213896 | 42781 | 30.811346 | 72.13913199999998 | 2021-04-17 04:20:40 | Punjab, Pakistan | ||
2020-07-27 | India | Punjab | 13769 | 318 | 9064 | 4387 | 30.841465000000003 | 75.40879 | 2020-07-28 04:58:43 | Punjab, India | ||
2020-07-27 | Pakistan | Punjab | 92073 | 2116 | 81260 | 8697 | 30.811346 | 72.13913199999998 | 2020-07-28 04:58:43 | Punjab, Pakistan | ||
2021-09-02 | India | Punjab | 600715 | 16435 | 0 | 30.841465000000003 | 75.40879 | 2021-09-03 04:21:20 | Punjab, India | |||
2021-09-02 | Pakistan | Punjab | 397694 | 11979 | 0 | 30.811346 | 72.13913199999998 | 2021-09-03 04:21:20 | Punjab, Pakistan | |||
2021-02-21 | India | Punjab | 178459 | 5754 | 169686 | 3019 | 30.841465000000003 | 75.40879 | 2021-02-22 05:24:21 | Punjab, India | ||
2021-02-21 | Pakistan | Punjab | 167819 | 5208 | 155632 | 6979 | 30.811346 | 72.13913199999998 | 2021-02-22 05:24:21 | Punjab, Pakistan | ||
2022-02-13 | India | Punjab | 755561 | 17596 | 0 | 30.841465000000003 | 75.40879 | 2022-02-14 04:20:51 | Punjab, India | |||
2022-02-13 | Pakistan | Punjab | 495430 | 13363 | 0 | 30.811346 | 72.13913199999998 | 2022-02-14 04:20:51 | Punjab, Pakistan | |||
2021-01-11 | India | Punjab | 169225 | 5447 | 160920 | 2858 | 30.841465000000003 | 75.40879 | 2021-01-12 05:22:15 | Punjab, India | ||
2021-01-11 | Pakistan | Punjab | 146016 | 4299 | 130765 | 10952 | 30.811346 | 72.13913199999998 | 2021-01-12 05:22:15 | Punjab, Pakistan | ||
2020-08-31 | India | Punjab | 53992 | 1453 | 37027 | 15512 | 30.841465000000003 | 75.40879 | 2020-09-01 04:28:31 | Punjab, India | ||
2020-08-31 | Pakistan | Punjab | 96769 | 2198 | 92481 | 2090 | 30.811346 | 72.13913199999998 | 2020-09-01 04:28:31 | Punjab, Pakistan | ||
2022-10-19 | India | Punjab | 784989 | 17919 | 0 | 30.841465 | 75.40879 | 2022-10-20 04:22:59 | Punjab, India | |||
2022-10-19 | Pakistan | Punjab | 522243 | 13614 | 0 | 30.811346 | 72.139132 | 2022-10-20 04:22:59 | Punjab, Pakistan | |||
2020-12-25 | India | Punjab | 164821 | 5269 | 154845 | 4707 | 30.841465000000003 | 75.40879 | 2020-12-26 05:22:28 | Punjab, India | ||
2020-12-25 | Pakistan | Punjab | 135141 | 3858 | 121625 | 9658 | 30.811346 | 72.13913199999998 | 2020-12-26 05:22:28 | Punjab, Pakistan | ||
2020-08-19 | India | Punjab | 36084 | 921 | 22703 | 12460 | 30.841465000000003 | 75.40879 | 2020-08-20 04:27:43 | Punjab, India | ||
2020-08-19 | Pakistan | Punjab | 95742 | 2186 | 90150 | 3406 | 30.811346 | 72.13913199999998 | 2020-08-20 04:27:43 | Punjab, Pakistan | ||
2020-10-29 | India | Punjab | 132727 | 4168 | 124293 | 4266 | 30.841465000000003 | 75.40879 | 2020-10-30 04:24:49 | Punjab, India | ||
2020-10-29 | Pakistan | Punjab | 103831 | 2354 | 97422 | 4055 | 30.811346 | 72.13913199999998 | 2020-10-30 04:24:49 | Punjab, Pakistan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;