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 longitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
478 | 478 | 2021-12-02 | Pakistan | Punjab | 443310 | 13031 | 0 | 30.811346 | 72.13913199999998 | 2021-12-03 04:23:05 | Punjab, Pakistan | |||
4494 | 4494 | 2021-10-28 | Pakistan | Punjab | 439845 | 12909 | 0 | 30.811346 | 72.13913199999998 | 2021-10-29 04:22:03 | Punjab, Pakistan | |||
8474 | 8474 | 2020-10-25 | Pakistan | Punjab | 102875 | 2335 | 97348 | 3192 | 30.811346 | 72.13913199999998 | 2020-10-26 04:25:02 | Punjab, Pakistan | ||
12485 | 12485 | 2021-01-26 | Pakistan | Punjab | 155214 | 4646 | 139887 | 10681 | 30.811346 | 72.13913199999998 | 2021-01-27 05:23:41 | Punjab, Pakistan | ||
16502 | 16502 | 2021-09-18 | Pakistan | Punjab | 421800 | 12396 | 0 | 30.811346 | 72.13913199999998 | 2021-09-19 04:21:34 | Punjab, Pakistan | |||
20516 | 20516 | 2021-05-28 | Pakistan | Punjab | 338377 | 9960 | 308275 | 20142 | 30.811346 | 72.13913199999998 | 2021-05-29 04:20:41 | Punjab, Pakistan | ||
24549 | 24549 | 2022-03-20 | Pakistan | Punjab | 504442 | 13550 | 0 | 30.811346 | 72.13913199999998 | 2022-03-21 04:20:50 | Punjab, Pakistan | |||
28564 | 28564 | 2021-11-11 | Pakistan | Punjab | 441631 | 12967 | 0 | 30.811346 | 72.13913199999998 | 2021-11-12 04:22:01 | Punjab, Pakistan | |||
32563 | 32563 | 2021-08-25 | Pakistan | Punjab | 385258 | 11666 | 0 | 30.811346 | 72.13913199999998 | 2021-08-26 04:21:28 | Punjab, Pakistan | |||
36575 | 36575 | 2021-04-12 | Pakistan | Punjab | 252974 | 7062 | 205912 | 40000 | 30.811346 | 72.13913199999998 | 2021-04-13 04:20:37 | Punjab, Pakistan | ||
43856 | 43856 | 2021-11-02 | Pakistan | Punjab | 440542 | 12929 | 0 | 30.811346 | 72.13913199999998 | 2021-11-03 06:22:09 | Punjab, Pakistan | |||
50937 | 50937 | 2021-05-29 | Pakistan | Punjab | 339073 | 9982 | 308733 | 20358 | 30.811346 | 72.13913199999998 | 2021-05-30 04:20:55 | Punjab, Pakistan | ||
54950 | 54950 | 2021-03-07 | Pakistan | Punjab | 177823 | 5565 | 165678 | 6580 | 30.811346 | 72.13913199999998 | 2021-03-08 05:24:48 | Punjab, Pakistan | ||
62084 | 62084 | 2020-07-23 | Pakistan | Punjab | 91423 | 2105 | 68439 | 20879 | 30.811346 | 72.13913199999998 | 2020-07-24 05:30:40 | Punjab, Pakistan | ||
67208 | 67208 | 2021-09-01 | Pakistan | Punjab | 396326 | 11959 | 0 | 30.811346 | 72.13913199999998 | 2021-09-02 04:21:15 | Punjab, Pakistan | |||
71239 | 71239 | 2022-02-07 | Pakistan | Punjab | 490103 | 13267 | 0 | 30.811346 | 72.13913199999998 | 2022-02-08 04:21:15 | Punjab, Pakistan | |||
75233 | 75233 | 2020-12-03 | Pakistan | Punjab | 121753 | 3115 | 99164 | 19474 | 30.811346 | 72.13913199999998 | 2020-12-04 05:27:27 | Punjab, Pakistan | ||
79230 | 79230 | 2020-10-14 | Pakistan | Punjab | 101237 | 2277 | 96989 | 1971 | 30.811346 | 72.13913199999998 | 2020-10-15 04:24:28 | Punjab, Pakistan | ||
83240 | 83240 | 2021-05-25 | Pakistan | Punjab | 336315 | 9875 | 304752 | 21688 | 30.811346 | 72.13913199999998 | 2021-05-26 04:20:35 | Punjab, Pakistan | ||
87273 | 87273 | 2021-11-09 | Pakistan | Punjab | 441378 | 12957 | 0 | 30.811346 | 72.13913199999998 | 2021-11-10 04:21:38 | Punjab, Pakistan | |||
98436 | 98436 | 2020-08-04 | Pakistan | Punjab | 93336 | 2153 | 82575 | 8608 | 30.811346 | 72.13913199999998 | 2020-08-05 04:34:43 | Punjab, Pakistan | ||
99474 | 99474 | 2022-01-14 | Pakistan | Punjab | 451408 | 13087 | 0 | 30.811346 | 72.13913199999998 | 2022-01-15 04:21:07 | Punjab, Pakistan | |||
103473 | 103473 | 2021-08-15 | Pakistan | Punjab | 372750 | 11372 | 0 | 30.811346 | 72.13913199999998 | 2021-08-16 04:21:31 | Punjab, Pakistan | |||
107598 | 107598 | 2021-06-19 | Pakistan | Punjab | 344799 | 10615 | 323925 | 10259 | 30.811346 | 72.13913199999998 | 2021-06-20 04:21:48 | Punjab, Pakistan | ||
122028 | 122028 | 2020-07-19 | Pakistan | Punjab | 90191 | 2083 | 65689 | 22419 | 30.811346 | 72.13913199999998 | 2020-07-20 05:34:40 | Punjab, Pakistan | ||
122848 | 122848 | 2020-11-18 | Pakistan | Punjab | 112284 | 2519 | 97846 | 11919 | 30.811346 | 72.13913199999998 | 2020-11-19 05:25:23 | Punjab, Pakistan | ||
126881 | 126881 | 2022-01-09 | Pakistan | Punjab | 448091 | 13080 | 0 | 30.811346 | 72.13913199999998 | 2022-01-10 04:22:07 | Punjab, Pakistan | |||
138119 | 138119 | 2021-12-04 | Pakistan | Punjab | 443453 | 13037 | 0 | 30.811346 | 72.13913199999998 | 2021-12-05 04:22:25 | Punjab, Pakistan | |||
146114 | 146114 | 2020-08-15 | Pakistan | Punjab | 95203 | 2180 | 86424 | 6599 | 30.811346 | 72.13913199999998 | 2020-08-16 04:27:42 | Punjab, Pakistan | ||
150132 | 150132 | 2021-11-29 | Pakistan | Punjab | 443094 | 13023 | 0 | 30.811346 | 72.13913199999998 | 2021-11-30 04:22:53 | Punjab, Pakistan | |||
154127 | 154127 | 2021-01-08 | Pakistan | Punjab | 144111 | 4242 | 129852 | 10017 | 30.811346 | 72.13913199999998 | 2021-01-09 05:22:18 | Punjab, Pakistan | ||
158161 | 158161 | 2022-03-29 | Pakistan | Punjab | 504962 | 13554 | 0 | 30.811346 | 72.13913199999998 | 2022-03-30 04:20:45 | Punjab, Pakistan | |||
162176 | 162176 | 2021-11-19 | Pakistan | Punjab | 442353 | 12994 | 0 | 30.811346 | 72.13913199999998 | 2021-11-20 04:22:17 | Punjab, Pakistan | |||
170189 | 170189 | 2021-04-16 | Pakistan | Punjab | 264010 | 7333 | 213896 | 42781 | 30.811346 | 72.13913199999998 | 2021-04-17 04:20:40 | Punjab, Pakistan | ||
177346 | 177346 | 2020-07-27 | Pakistan | Punjab | 92073 | 2116 | 81260 | 8697 | 30.811346 | 72.13913199999998 | 2020-07-28 04:58:43 | Punjab, Pakistan | ||
178173 | 178173 | 2021-09-02 | Pakistan | Punjab | 397694 | 11979 | 0 | 30.811346 | 72.13913199999998 | 2021-09-03 04:21:20 | Punjab, Pakistan | |||
182185 | 182185 | 2021-02-21 | Pakistan | Punjab | 167819 | 5208 | 155632 | 6979 | 30.811346 | 72.13913199999998 | 2021-02-22 05:24:21 | Punjab, Pakistan | ||
186219 | 186219 | 2022-02-13 | Pakistan | Punjab | 495430 | 13363 | 0 | 30.811346 | 72.13913199999998 | 2022-02-14 04:20:51 | Punjab, Pakistan | |||
190213 | 190213 | 2021-01-11 | Pakistan | Punjab | 146016 | 4299 | 130765 | 10952 | 30.811346 | 72.13913199999998 | 2021-01-12 05:22:15 | Punjab, Pakistan | ||
194209 | 194209 | 2020-08-31 | Pakistan | Punjab | 96769 | 2198 | 92481 | 2090 | 30.811346 | 72.13913199999998 | 2020-09-01 04:28:31 | Punjab, Pakistan | ||
202400 | 202400 | 2020-12-25 | Pakistan | Punjab | 135141 | 3858 | 121625 | 9658 | 30.811346 | 72.13913199999998 | 2020-12-26 05:22:28 | Punjab, Pakistan | ||
206396 | 206396 | 2020-08-19 | Pakistan | Punjab | 95742 | 2186 | 90150 | 3406 | 30.811346 | 72.13913199999998 | 2020-08-20 04:27:43 | Punjab, Pakistan | ||
210383 | 210383 | 2020-10-29 | Pakistan | Punjab | 103831 | 2354 | 97422 | 4055 | 30.811346 | 72.13913199999998 | 2020-10-30 04:24:49 | Punjab, Pakistan | ||
233391 | 233391 | 2022-02-11 | Pakistan | Punjab | 494238 | 13335 | 0 | 30.811346 | 72.13913199999998 | 2022-02-12 04:21:06 | Punjab, Pakistan | |||
237385 | 237385 | 2021-01-18 | Pakistan | Punjab | 150316 | 4460 | 134842 | 11014 | 30.811346 | 72.13913199999998 | 2021-01-19 05:22:15 | Punjab, Pakistan | ||
241400 | 241400 | 2021-04-02 | Pakistan | Punjab | 228356 | 6523 | 192452 | 29381 | 30.811346 | 72.13913199999998 | 2021-04-03 04:20:44 | Punjab, Pakistan | ||
245416 | 245416 | 2021-08-17 | Pakistan | Punjab | 374916 | 11434 | 0 | 30.811346 | 72.13913199999998 | 2021-08-18 04:21:35 | Punjab, Pakistan | |||
249430 | 249430 | 2021-09-04 | Pakistan | Punjab | 401373 | 12039 | 0 | 30.811346 | 72.13913199999998 | 2021-09-05 04:21:33 | Punjab, Pakistan | |||
261681 | 261681 | 2022-03-15 | Pakistan | Punjab | 504045 | 13540 | 0 | 30.811346 | 72.13913199999998 | 2022-03-16 04:20:50 | Punjab, Pakistan | |||
272298 | 272298 | 2020-11-10 | Pakistan | Punjab | 107831 | 2429 | 97672 | 7730 | 30.811346 | 72.13913199999998 | 2020-11-11 05:25:30 | Punjab, Pakistan | ||
276331 | 276331 | 2021-11-03 | Pakistan | Punjab | 440678 | 12936 | 0 | 30.811346 | 72.13913199999998 | 2021-11-04 04:22:20 | Punjab, Pakistan | |||
280328 | 280328 | 2021-02-24 | Pakistan | Punjab | 169474 | 5308 | 157459 | 6707 | 30.811346 | 72.13913199999998 | 2021-02-25 05:24:57 | Punjab, Pakistan | ||
287309 | 287309 | 2020-06-15 | Pakistan | Punjab | 55878 | 1081 | 17730 | 37067 | 30.811346 | 72.13913199999998 | 2020-06-16 04:33:09 | Punjab, Pakistan | ||
288144 | 288144 | 2021-10-31 | Pakistan | Punjab | 440259 | 12918 | 0 | 30.811346 | 72.13913199999998 | 2021-11-01 04:22:01 | Punjab, Pakistan | |||
296159 | 296159 | 2021-07-15 | Pakistan | Punjab | 349475 | 10856 | 329344 | 9275 | 30.811346 | 72.13913199999998 | 2021-07-16 04:21:22 | Punjab, Pakistan | ||
303181 | 303181 | 2020-07-01 | Pakistan | Punjab | 77740 | 1784 | 28266 | 47690 | 30.811346 | 72.13913199999998 | 2020-07-02 04:33:46 | Punjab, Pakistan | ||
304017 | 304017 | 2022-04-16 | Pakistan | Punjab | 505660 | 13559 | 0 | 30.811346 | 72.13913199999998 | 2022-04-17 04:20:59 | Punjab, Pakistan | |||
316065 | 316065 | 2022-02-12 | Pakistan | Punjab | 494971 | 13355 | 0 | 30.811346 | 72.13913199999998 | 2022-02-13 04:21:00 | Punjab, Pakistan | |||
327123 | 327123 | 2020-07-20 | Pakistan | Punjab | 90444 | 2090 | 66021 | 22333 | 30.811346 | 72.13913199999998 | 2020-07-21 04:38:46 | Punjab, Pakistan | ||
332053 | 332053 | 2021-08-04 | Pakistan | Punjab | 360494 | 11122 | 334305 | 15067 | 30.811346 | 72.13913199999998 | 2021-08-05 04:21:51 | Punjab, Pakistan | ||
336085 | 336085 | 2022-03-18 | Pakistan | Punjab | 504324 | 13547 | 0 | 30.811346 | 72.13913199999998 | 2022-03-19 04:20:47 | Punjab, Pakistan | |||
340420 | 340420 | 2021-02-03 | Pakistan | Punjab | 159311 | 4821 | 144921 | 9569 | 30.811346 | 72.13913199999998 | 2021-02-04 05:22:26 | Punjab, Pakistan | ||
344417 | 344417 | 2020-09-14 | Pakistan | Punjab | 97817 | 2220 | 94526 | 1071 | 30.811346 | 72.13913199999998 | 2020-09-15 03:22:50 | Punjab, Pakistan | ||
352441 | 352441 | 2021-03-11 | Pakistan | Punjab | 182576 | 5698 | 168186 | 8692 | 30.811346 | 72.13913199999998 | 2021-03-12 05:26:50 | Punjab, Pakistan | ||
356475 | 356475 | 2022-03-11 | Pakistan | Punjab | 503590 | 13536 | 0 | 30.811346 | 72.13913199999998 | 2022-03-12 04:20:50 | Punjab, Pakistan | |||
367529 | 367529 | 2020-07-16 | Pakistan | Punjab | 88539 | 2051 | 64247 | 22241 | 30.811346 | 72.13913199999998 | 2020-07-17 04:34:50 | Punjab, Pakistan | ||
371501 | 371501 | 2020-08-08 | Pakistan | Punjab | 94223 | 2166 | 86240 | 5817 | 30.811346 | 72.13913199999998 | 2020-08-09 04:34:54 | Punjab, Pakistan | ||
376325 | 376325 | 2020-11-06 | Pakistan | Punjab | 106208 | 2399 | 97584 | 6225 | 30.811346 | 72.13913199999998 | 2020-11-07 05:24:52 | Punjab, Pakistan | ||
380338 | 380338 | 2021-04-30 | Pakistan | Punjab | 303182 | 8500 | 247050 | 47632 | 30.811346 | 72.13913199999998 | 2021-05-01 04:20:47 | Punjab, Pakistan | ||
388368 | 388368 | 2021-04-04 | Pakistan | Punjab | 233348 | 6587 | 195684 | 31077 | 30.811346 | 72.13913199999998 | 2021-04-05 04:20:35 | Punjab, Pakistan | ||
392379 | 392379 | 2020-11-27 | Pakistan | Punjab | 117898 | 2960 | 98289 | 16649 | 30.811346 | 72.13913199999998 | 2020-11-28 05:25:50 | Punjab, Pakistan | ||
400411 | 400411 | 2021-06-29 | Pakistan | Punjab | 346180 | 10747 | 326994 | 8439 | 30.811346 | 72.13913199999998 | 2021-06-30 04:21:41 | Punjab, Pakistan | ||
404442 | 404442 | 2021-12-07 | Pakistan | Punjab | 443610 | 13044 | 0 | 30.811346 | 72.13913199999998 | 2021-12-08 04:22:46 | Punjab, Pakistan | |||
408441 | 408441 | 2021-07-28 | Pakistan | Punjab | 354904 | 10995 | 331704 | 12205 | 30.811346 | 72.13913199999998 | 2021-07-29 04:21:33 | Punjab, Pakistan | ||
415473 | 415473 | 2020-07-05 | Pakistan | Punjab | 81963 | 1884 | 45122 | 34957 | 30.811346 | 72.13913199999998 | 2020-07-06 04:33:57 | Punjab, Pakistan | ||
423499 | 423499 | 2021-10-10 | Pakistan | Punjab | 436197 | 12785 | 0 | 30.811346 | 72.13913199999998 | 2021-10-11 04:21:31 | Punjab, Pakistan | |||
427478 | 427478 | 2020-09-07 | Pakistan | Punjab | 97306 | 2211 | 93589 | 1506 | 30.811346 | 72.13913199999998 | 2020-09-08 04:28:25 | Punjab, Pakistan | ||
435501 | 435501 | 2021-01-21 | Pakistan | Punjab | 152158 | 4523 | 136645 | 10990 | 30.811346 | 72.13913199999998 | 2021-01-22 05:22:10 | Punjab, Pakistan | ||
442659 | 442659 | 2020-07-26 | Pakistan | Punjab | 91901 | 2116 | 81250 | 8535 | 30.811346 | 72.13913199999998 | 2020-07-27 04:35:02 | Punjab, Pakistan | ||
443503 | 443503 | 2021-10-20 | Pakistan | Punjab | 438433 | 12876 | 0 | 30.811346 | 72.13913199999998 | 2021-10-21 04:21:18 | Punjab, Pakistan | |||
447519 | 447519 | 2021-11-17 | Pakistan | Punjab | 442162 | 12986 | 0 | 30.811346 | 72.13913199999998 | 2021-11-18 04:21:33 | Punjab, Pakistan | |||
458685 | 458685 | 2020-08-07 | Pakistan | Punjab | 94040 | 2164 | 86085 | 5791 | 30.811346 | 72.13913199999998 | 2020-08-08 04:34:53 | Punjab, Pakistan | ||
459528 | 459528 | 2022-02-02 | Pakistan | Punjab | 483779 | 13201 | 0 | 30.811346 | 72.13913199999998 | 2022-02-03 04:21:21 | Punjab, Pakistan | |||
467560 | 467560 | 2021-10-07 | Pakistan | Punjab | 435040 | 12757 | 0 | 30.811346 | 72.13913199999998 | 2021-10-08 04:21:25 | Punjab, Pakistan | |||
471557 | 471557 | 2021-02-19 | Pakistan | Punjab | 166777 | 5185 | 154568 | 7024 | 30.811346 | 72.13913199999998 | 2021-02-20 05:22:51 | Punjab, Pakistan | ||
483737 | 483737 | 2021-07-19 | Pakistan | Punjab | 351000 | 10892 | 329875 | 10233 | 30.811346 | 72.13913199999998 | 2021-07-20 04:21:48 | Punjab, Pakistan | ||
491784 | 491784 | 2021-10-14 | Pakistan | Punjab | 437316 | 12821 | 0 | 30.811346 | 72.13913199999998 | 2021-10-15 04:21:26 | Punjab, Pakistan | |||
495800 | 495800 | 2021-11-06 | Pakistan | Punjab | 441051 | 12946 | 0 | 30.811346 | 72.13913199999998 | 2021-11-07 04:21:53 | Punjab, Pakistan | |||
499817 | 499817 | 2022-04-02 | Pakistan | Punjab | 505127 | 13558 | 0 | 30.811346 | 72.13913199999998 | 2022-04-03 04:20:48 | Punjab, Pakistan | |||
507831 | 507831 | 2021-08-14 | Pakistan | Punjab | 371605 | 11347 | 0 | 30.811346 | 72.13913199999998 | 2021-08-15 04:21:41 | Punjab, Pakistan | |||
511845 | 511845 | 2021-08-19 | Pakistan | Punjab | 377208 | 11479 | 0 | 30.811346 | 72.13913199999998 | 2021-08-20 04:21:33 | Punjab, Pakistan | |||
523003 | 523003 | 2021-06-09 | Pakistan | Punjab | 343252 | 10436 | 320723 | 12093 | 30.811346 | 72.13913199999998 | 2021-06-10 04:23:17 | Punjab, Pakistan | ||
530035 | 530035 | 2020-07-04 | Pakistan | Punjab | 80297 | 1844 | 42854 | 35599 | 30.811346 | 72.13913199999998 | 2020-07-05 04:33:46 | Punjab, Pakistan | ||
530851 | 530851 | 2021-02-22 | Pakistan | Punjab | 168348 | 5237 | 155948 | 7163 | 30.811346 | 72.13913199999998 | 2021-02-23 05:23:41 | Punjab, Pakistan | ||
534884 | 534884 | 2021-10-27 | Pakistan | Punjab | 439653 | 12904 | 0 | 30.811346 | 72.13913199999998 | 2021-10-28 04:22:08 | Punjab, Pakistan | |||
546895 | 546895 | 2020-09-12 | Pakistan | Punjab | 97679 | 2217 | 94453 | 1009 | 30.811346 | 72.13913199999998 | 2020-09-13 04:30:52 | Punjab, Pakistan | ||
550922 | 550922 | 2021-12-08 | Pakistan | Punjab | 443682 | 13046 | 0 | 30.811346 | 72.13913199999998 | 2021-12-09 04:22:49 | Punjab, Pakistan | |||
554938 | 554938 | 2022-01-16 | Pakistan | Punjab | 453392 | 13090 | 0 | 30.811346 | 72.13913199999998 | 2022-01-17 04:21:08 | Punjab, Pakistan | |||
563114 | 563114 | 2021-06-22 | Pakistan | Punjab | 345251 | 10672 | 325234 | 9345 | 30.811346 | 72.13913199999998 | 2021-06-23 04:21:46 | Punjab, Pakistan | ||
567252 | 567252 | 2021-10-29 | Pakistan | Punjab | 440003 | 12915 | 0 | 30.811346 | 72.13913199999998 | 2021-10-30 04:22:03 | 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]);