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)
Suggested facets: recovered, longitude, combined_key, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
277 | 277 | 2021-12-02 | India | Punjab | 603352 | 16606 | 0 | 30.841465000000003 | 75.40879 | 2021-12-03 04:23:05 | Punjab, India | |||
478 | 478 | 2021-12-02 | Pakistan | Punjab | 443310 | 13031 | 0 | 30.811346 | 72.13913199999998 | 2021-12-03 04:23:05 | Punjab, Pakistan | |||
4293 | 4293 | 2021-10-28 | India | Punjab | 602320 | 16556 | 0 | 30.841465000000003 | 75.40879 | 2021-10-29 04:22:03 | Punjab, India | |||
4494 | 4494 | 2021-10-28 | Pakistan | Punjab | 439845 | 12909 | 0 | 30.811346 | 72.13913199999998 | 2021-10-29 04:22:03 | 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 | |||
24348 | 24348 | 2022-03-20 | India | Punjab | 758931 | 17737 | 0 | 30.841465000000003 | 75.40879 | 2022-03-21 04:20:50 | Punjab, India | |||
24549 | 24549 | 2022-03-20 | Pakistan | Punjab | 504442 | 13550 | 0 | 30.811346 | 72.13913199999998 | 2022-03-21 04:20:50 | Punjab, Pakistan | |||
28363 | 28363 | 2021-11-11 | India | Punjab | 602695 | 16570 | 0 | 30.841465000000003 | 75.40879 | 2021-11-12 04:22:01 | Punjab, India | |||
28564 | 28564 | 2021-11-11 | Pakistan | Punjab | 441631 | 12967 | 0 | 30.811346 | 72.13913199999998 | 2021-11-12 04:22:01 | 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 | |||
43655 | 43655 | 2021-11-02 | India | Punjab | 602434 | 16561 | 0 | 30.841465000000003 | 75.40879 | 2021-11-03 06:22:09 | Punjab, India | |||
43856 | 43856 | 2021-11-02 | Pakistan | Punjab | 440542 | 12929 | 0 | 30.811346 | 72.13913199999998 | 2021-11-03 06:22:09 | Punjab, Pakistan | |||
63009 | 63009 | 2022-11-12 | India | Punjab | 785280 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-13 04:21:14 | Punjab, India | |||
63213 | 63213 | 2022-11-12 | Pakistan | Punjab | 522880 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-13 04:21:14 | 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 | |||
71038 | 71038 | 2022-02-07 | India | Punjab | 752635 | 17469 | 0 | 30.841465000000003 | 75.40879 | 2022-02-08 04:21:15 | Punjab, India | |||
71239 | 71239 | 2022-02-07 | Pakistan | Punjab | 490103 | 13267 | 0 | 30.811346 | 72.13913199999998 | 2022-02-08 04:21:15 | Punjab, Pakistan | |||
87072 | 87072 | 2021-11-09 | India | Punjab | 602616 | 16566 | 0 | 30.841465000000003 | 75.40879 | 2021-11-10 04:21:38 | Punjab, India | |||
87273 | 87273 | 2021-11-09 | Pakistan | Punjab | 441378 | 12957 | 0 | 30.811346 | 72.13913199999998 | 2021-11-10 04:21:38 | Punjab, Pakistan | |||
91089 | 91089 | 2022-07-23 | India | Punjab | 770237 | 17800 | 0 | 30.841465 | 75.40879 | 2022-07-24 04:20:47 | Punjab, India | |||
91291 | 91291 | 2022-07-23 | Pakistan | Punjab | 511548 | 13586 | 0 | 30.811346 | 72.139132 | 2022-07-24 04:20:47 | Punjab, Pakistan | |||
99273 | 99273 | 2022-01-14 | India | Punjab | 649736 | 16731 | 0 | 30.841465000000003 | 75.40879 | 2022-01-15 04:21:07 | Punjab, India | |||
99474 | 99474 | 2022-01-14 | Pakistan | Punjab | 451408 | 13087 | 0 | 30.811346 | 72.13913199999998 | 2022-01-15 04:21:07 | Punjab, Pakistan | |||
103289 | 103289 | 2021-08-15 | India | Punjab | 599942 | 16342 | 0 | 30.841465000000003 | 75.40879 | 2021-08-16 04:21:31 | Punjab, India | |||
103473 | 103473 | 2021-08-15 | Pakistan | Punjab | 372750 | 11372 | 0 | 30.811346 | 72.13913199999998 | 2021-08-16 04:21:31 | Punjab, Pakistan | |||
114699 | 114699 | 2022-09-06 | India | Punjab | 780990 | 17904 | 0 | 30.841465 | 75.40879 | 2022-09-07 04:20:59 | Punjab, India | |||
114901 | 114901 | 2022-09-06 | Pakistan | Punjab | 521465 | 13609 | 0 | 30.811346 | 72.139132 | 2022-09-07 04:20:59 | Punjab, Pakistan | |||
126680 | 126680 | 2022-01-09 | India | Punjab | 621419 | 16675 | 0 | 30.841465000000003 | 75.40879 | 2022-01-10 04:22:07 | Punjab, India | |||
126881 | 126881 | 2022-01-09 | Pakistan | Punjab | 448091 | 13080 | 0 | 30.811346 | 72.13913199999998 | 2022-01-10 04:22:07 | Punjab, Pakistan | |||
130697 | 130697 | 2022-10-04 | India | Punjab | 784660 | 17917 | 0 | 30.841465 | 75.40879 | 2022-10-05 04:23:06 | Punjab, India | |||
130901 | 130901 | 2022-10-04 | Pakistan | Punjab | 522243 | 13614 | 0 | 30.811346 | 72.139132 | 2022-10-05 04:23:06 | Punjab, Pakistan | |||
137918 | 137918 | 2021-12-04 | India | Punjab | 603410 | 16607 | 0 | 30.841465000000003 | 75.40879 | 2021-12-05 04:22:25 | Punjab, India | |||
138119 | 138119 | 2021-12-04 | Pakistan | Punjab | 443453 | 13037 | 0 | 30.811346 | 72.13913199999998 | 2021-12-05 04:22:25 | Punjab, Pakistan | |||
141935 | 141935 | 2022-07-09 | India | Punjab | 764513 | 17784 | 0 | 30.841465 | 75.40879 | 2022-07-10 04:20:54 | Punjab, India | |||
142137 | 142137 | 2022-07-09 | Pakistan | Punjab | 509399 | 13579 | 0 | 30.811346 | 72.139132 | 2022-07-10 04:20:54 | Punjab, Pakistan | |||
149931 | 149931 | 2021-11-29 | India | Punjab | 603258 | 16599 | 0 | 30.841465000000003 | 75.40879 | 2021-11-30 04:22:53 | Punjab, India | |||
150132 | 150132 | 2021-11-29 | Pakistan | Punjab | 443094 | 13023 | 0 | 30.811346 | 72.13913199999998 | 2021-11-30 04:22:53 | Punjab, Pakistan | |||
157960 | 157960 | 2022-03-29 | India | Punjab | 759094 | 17741 | 0 | 30.841465000000003 | 75.40879 | 2022-03-30 04:20:45 | Punjab, India | |||
158161 | 158161 | 2022-03-29 | Pakistan | Punjab | 504962 | 13554 | 0 | 30.811346 | 72.13913199999998 | 2022-03-30 04:20:45 | Punjab, Pakistan | |||
161975 | 161975 | 2021-11-19 | India | Punjab | 602943 | 16580 | 0 | 30.841465000000003 | 75.40879 | 2021-11-20 04:22:17 | Punjab, India | |||
162176 | 162176 | 2021-11-19 | Pakistan | Punjab | 442353 | 12994 | 0 | 30.811346 | 72.13913199999998 | 2021-11-20 04:22:17 | Punjab, Pakistan | |||
165992 | 165992 | 2022-06-21 | India | Punjab | 761487 | 17759 | 0 | 30.841465 | 75.40879 | 2022-06-22 04:20:54 | Punjab, India | |||
166194 | 166194 | 2022-06-21 | Pakistan | Punjab | 507771 | 13566 | 0 | 30.811346 | 72.139132 | 2022-06-22 04:20:54 | 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 | |||
186018 | 186018 | 2022-02-13 | India | Punjab | 755561 | 17596 | 0 | 30.841465000000003 | 75.40879 | 2022-02-14 04:20:51 | Punjab, India | |||
186219 | 186219 | 2022-02-13 | Pakistan | Punjab | 495430 | 13363 | 0 | 30.811346 | 72.13913199999998 | 2022-02-14 04:20:51 | Punjab, Pakistan | |||
198206 | 198206 | 2022-10-19 | India | Punjab | 784989 | 17919 | 0 | 30.841465 | 75.40879 | 2022-10-20 04:22:59 | Punjab, India | |||
198410 | 198410 | 2022-10-19 | Pakistan | Punjab | 522243 | 13614 | 0 | 30.811346 | 72.139132 | 2022-10-20 04:22:59 | Punjab, Pakistan | |||
217927 | 217927 | 2022-12-26 | India | Punjab | 785414 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-27 04:21:07 | Punjab, India | |||
218131 | 218131 | 2022-12-26 | Pakistan | Punjab | 523278 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-27 04:21:07 | Punjab, Pakistan | |||
221943 | 221943 | 2022-05-09 | India | Punjab | 759930 | 17751 | 0 | 30.841465 | 75.40879 | 2022-05-10 04:20:50 | Punjab, India | |||
222144 | 222144 | 2022-05-09 | Pakistan | Punjab | 506499 | 13562 | 0 | 30.811346 | 72.139132 | 2022-05-10 04:20:50 | Punjab, Pakistan | |||
229174 | 229174 | 2022-05-31 | India | Punjab | 760356 | 17752 | 0 | 30.841465 | 75.40879 | 2022-06-01 04:20:55 | Punjab, India | |||
229376 | 229376 | 2022-05-31 | Pakistan | Punjab | 507202 | 13564 | 0 | 30.811346 | 72.139132 | 2022-06-01 04:20:55 | Punjab, Pakistan | |||
233190 | 233190 | 2022-02-11 | India | Punjab | 754812 | 17575 | 0 | 30.841465000000003 | 75.40879 | 2022-02-12 04:21:06 | Punjab, India | |||
233391 | 233391 | 2022-02-11 | Pakistan | Punjab | 494238 | 13335 | 0 | 30.811346 | 72.13913199999998 | 2022-02-12 04:21:06 | Punjab, Pakistan | |||
245232 | 245232 | 2021-08-17 | India | Punjab | 600008 | 16345 | 0 | 30.841465000000003 | 75.40879 | 2021-08-18 04:21:35 | Punjab, India | |||
245416 | 245416 | 2021-08-17 | Pakistan | Punjab | 374916 | 11434 | 0 | 30.811346 | 72.13913199999998 | 2021-08-18 04:21:35 | 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 | |||
253261 | 253261 | 2022-09-08 | India | Punjab | 783755 | 17905 | 0 | 30.841465 | 75.40879 | 2022-09-09 04:21:11 | Punjab, India | |||
253463 | 253463 | 2022-09-08 | Pakistan | Punjab | 521586 | 13610 | 0 | 30.811346 | 72.139132 | 2022-09-09 04:21:11 | Punjab, Pakistan | |||
257277 | 257277 | 2022-12-10 | India | Punjab | 785371 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-11 04:20:50 | Punjab, India | |||
257481 | 257481 | 2022-12-10 | Pakistan | Punjab | 523197 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-11 04:20:50 | Punjab, Pakistan | |||
261480 | 261480 | 2022-03-15 | India | Punjab | 758793 | 17736 | 0 | 30.841465000000003 | 75.40879 | 2022-03-16 04:20:50 | Punjab, India | |||
261681 | 261681 | 2022-03-15 | Pakistan | Punjab | 504045 | 13540 | 0 | 30.811346 | 72.13913199999998 | 2022-03-16 04:20:50 | Punjab, Pakistan | |||
276130 | 276130 | 2021-11-03 | India | Punjab | 602466 | 16562 | 0 | 30.841465000000003 | 75.40879 | 2021-11-04 04:22:20 | Punjab, India | |||
276331 | 276331 | 2021-11-03 | Pakistan | Punjab | 440678 | 12936 | 0 | 30.811346 | 72.13913199999998 | 2021-11-04 04:22:20 | Punjab, Pakistan | |||
287943 | 287943 | 2021-10-31 | India | Punjab | 602401 | 16559 | 0 | 30.841465000000003 | 75.40879 | 2021-11-01 04:22:01 | Punjab, India | |||
288144 | 288144 | 2021-10-31 | Pakistan | Punjab | 440259 | 12918 | 0 | 30.811346 | 72.13913199999998 | 2021-11-01 04:22:01 | Punjab, Pakistan | |||
291960 | 291960 | 2022-11-15 | India | Punjab | 785300 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-16 04:21:09 | Punjab, India | |||
292164 | 292164 | 2022-11-15 | Pakistan | Punjab | 522921 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-16 04:21:09 | Punjab, Pakistan | |||
303816 | 303816 | 2022-04-16 | India | Punjab | 759248 | 17743 | 0 | 30.841465000000003 | 75.40879 | 2022-04-17 04:20:59 | Punjab, India | |||
304017 | 304017 | 2022-04-16 | Pakistan | Punjab | 505660 | 13559 | 0 | 30.811346 | 72.13913199999998 | 2022-04-17 04:20:59 | Punjab, Pakistan | |||
307832 | 307832 | 2022-12-13 | India | Punjab | 785374 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-14 04:21:04 | Punjab, India | |||
308036 | 308036 | 2022-12-13 | Pakistan | Punjab | 523226 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-14 04:21:04 | Punjab, Pakistan | |||
311848 | 311848 | 2022-11-13 | India | Punjab | 785291 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-14 04:21:09 | Punjab, India | |||
312052 | 312052 | 2022-11-13 | Pakistan | Punjab | 522896 | 13616 | 0 | 30.811346 | 72.139132 | 2022-11-14 04:21:09 | Punjab, Pakistan | |||
315864 | 315864 | 2022-02-12 | India | Punjab | 755234 | 17585 | 0 | 30.841465000000003 | 75.40879 | 2022-02-13 04:21:00 | Punjab, India | |||
316065 | 316065 | 2022-02-12 | Pakistan | Punjab | 494971 | 13355 | 0 | 30.811346 | 72.13913199999998 | 2022-02-13 04:21:00 | Punjab, Pakistan | |||
319880 | 319880 | 2022-10-30 | India | Punjab | 785160 | 17920 | 0 | 30.841465 | 75.40879 | 2022-10-31 04:21:36 | Punjab, India | |||
320084 | 320084 | 2022-10-30 | Pakistan | Punjab | 522579 | 13615 | 0 | 30.811346 | 72.139132 | 2022-10-31 04:21:36 | Punjab, Pakistan | |||
327854 | 327854 | 2022-12-27 | India | Punjab | 785423 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-28 04:21:04 | Punjab, India | |||
328058 | 328058 | 2022-12-27 | Pakistan | Punjab | 523278 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-28 04:21:04 | Punjab, Pakistan | |||
335884 | 335884 | 2022-03-18 | India | Punjab | 758894 | 17737 | 0 | 30.841465000000003 | 75.40879 | 2022-03-19 04:20:47 | Punjab, India | |||
336085 | 336085 | 2022-03-18 | Pakistan | Punjab | 504324 | 13547 | 0 | 30.811346 | 72.13913199999998 | 2022-03-19 04:20:47 | Punjab, Pakistan | |||
348244 | 348244 | 2022-12-14 | India | Punjab | 785374 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-15 04:20:58 | Punjab, India | |||
348448 | 348448 | 2022-12-14 | Pakistan | Punjab | 523226 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-15 04:20:58 | Punjab, Pakistan | |||
356274 | 356274 | 2022-03-11 | India | Punjab | 758643 | 17723 | 0 | 30.841465000000003 | 75.40879 | 2022-03-12 04:20:50 | Punjab, India | |||
356475 | 356475 | 2022-03-11 | Pakistan | Punjab | 503590 | 13536 | 0 | 30.811346 | 72.13913199999998 | 2022-03-12 04:20:50 | Punjab, Pakistan | |||
360290 | 360290 | 2022-05-07 | India | Punjab | 759882 | 17751 | 0 | 30.841465 | 75.40879 | 2022-05-08 04:20:49 | Punjab, India | |||
360491 | 360491 | 2022-05-07 | Pakistan | Punjab | 506018 | 13560 | 0 | 30.811346 | 72.139132 | 2022-05-08 04:20:49 | Punjab, Pakistan | |||
372144 | 372144 | 2022-09-13 | India | Punjab | 784005 | 17906 | 0 | 30.841465 | 75.40879 | 2022-09-14 04:20:44 | Punjab, India | |||
372348 | 372348 | 2022-09-13 | Pakistan | Punjab | 521842 | 13610 | 0 | 30.811346 | 72.139132 | 2022-09-14 04:20:44 | Punjab, Pakistan | |||
384171 | 384171 | 2022-09-23 | India | Punjab | 784425 | 17911 | 0 | 30.841465 | 75.40879 | 2022-09-24 04:21:40 | Punjab, India | |||
384375 | 384375 | 2022-09-23 | Pakistan | Punjab | 522096 | 13613 | 0 | 30.811346 | 72.139132 | 2022-09-24 04:21:40 | 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]);