daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
101 rows where country_or_region = "Pakistan" and latitude = "30.3753" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- Pakistan · 101 ✖
province_or_state 0
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-06-09 | Pakistan | 113702 | 2255 | 36308 | 75139 | 30.3753 | 69.3451 | 2020-06-10 04:07:00 | Pakistan | |||
2020-06-08 | Pakistan | 108317 | 2172 | 35018 | 71127 | 30.3753 | 69.3451 | 2020-06-09 03:33:03 | Pakistan | |||
2020-06-07 | Pakistan | 98943 | 2002 | 33465 | 63476 | 30.3753 | 69.3451 | 2020-06-08 03:33:22 | Pakistan | |||
2020-06-06 | Pakistan | 93983 | 1935 | 32581 | 59467 | 30.3753 | 69.3451 | 2020-06-07 03:53:30 | Pakistan | |||
2020-06-05 | Pakistan | 89249 | 1838 | 31198 | 56213 | 30.3753 | 69.3451 | 2020-06-06 02:33:00 | Pakistan | |||
2020-06-04 | Pakistan | 85264 | 1770 | 30128 | 53366 | 30.3753 | 69.3451 | 2020-06-05 02:33:06 | Pakistan | |||
2020-06-03 | Pakistan | 80463 | 1688 | 28923 | 49852 | 30.3753 | 69.3451 | 2020-06-04 02:33:14 | Pakistan | |||
2020-06-02 | Pakistan | 76398 | 1621 | 27110 | 47667 | 30.3753 | 69.3451 | 2020-06-03 02:33:13 | Pakistan | |||
2020-06-01 | Pakistan | 72460 | 1543 | 26083 | 44834 | 30.3753 | 69.3451 | 2020-06-02 02:33:08 | Pakistan | |||
2020-05-31 | Pakistan | 69496 | 1483 | 25271 | 42742 | 30.3753 | 69.3451 | 2020-06-01 02:32:46 | Pakistan | |||
2020-05-30 | Pakistan | 66457 | 1395 | 24131 | 40931 | 30.3753 | 69.3451 | 2020-05-31 02:32:45 | Pakistan | |||
2020-05-29 | Pakistan | 64028 | 1317 | 22305 | 40406 | 30.3753 | 69.3451 | 2020-05-30 02:32:48 | Pakistan | |||
2020-05-28 | Pakistan | 61227 | 1260 | 20231 | 39736 | 30.3753 | 69.3451 | 2020-05-29 02:32:50 | Pakistan | |||
2020-05-27 | Pakistan | 59151 | 1225 | 19142 | 38784 | 30.3753 | 69.3451 | 2020-05-28 02:32:31 | Pakistan | |||
2020-05-26 | Pakistan | 57705 | 1197 | 18314 | 38194 | 30.3753 | 69.3451 | 2020-05-27 02:32:31 | Pakistan | |||
2020-05-25 | Pakistan | 56349 | 1167 | 17482 | 37700 | 30.3753 | 69.3451 | 2020-05-26 02:32:35 | Pakistan | |||
2020-05-24 | Pakistan | 54601 | 1133 | 17198 | 36270 | 30.3753 | 69.3451 | 2020-05-25 02:32:44 | Pakistan | |||
2020-05-23 | Pakistan | 52437 | 1101 | 16653 | 34683 | 30.3753 | 69.3451 | 2020-05-24 02:32:43 | Pakistan | |||
2020-05-22 | Pakistan | 50694 | 1067 | 15201 | 34426 | 30.3753 | 69.3451 | 2020-05-23 02:32:42 | Pakistan | |||
2020-05-21 | Pakistan | 48091 | 1017 | 14155 | 32919 | 30.3753 | 69.3451 | 2020-05-22 02:36:51 | Pakistan | |||
2020-05-20 | Pakistan | 45898 | 985 | 13101 | 31812 | 30.3753 | 69.3451 | 2020-05-21 02:32:48 | Pakistan | |||
2020-05-19 | Pakistan | 43966 | 939 | 12489 | 30538 | 30.3753 | 69.3451 | 2020-05-20 02:32:19 | Pakistan | |||
2020-05-18 | Pakistan | 42125 | 903 | 11922 | 29300 | 30.3753 | 69.3451 | 2020-05-19 02:32:18 | Pakistan | |||
2020-05-17 | Pakistan | 40151 | 873 | 11341 | 27937 | 30.3753 | 69.3451 | 2020-05-18 02:32:21 | Pakistan | |||
2020-05-16 | Pakistan | 38799 | 834 | 10880 | 27085 | 30.3753 | 69.3451 | 2020-05-17 02:32:32 | Pakistan | |||
2020-05-15 | Pakistan | 38799 | 834 | 10880 | 27085 | 30.3753 | 69.3451 | 2020-05-16 02:32:19 | Pakistan | |||
2020-05-14 | Pakistan | 35788 | 770 | 9695 | 25323 | 30.3753 | 69.3451 | 2020-05-15 02:33:02 | Pakistan | |||
2020-05-13 | Pakistan | 35298 | 761 | 8899 | 25638 | 30.3753 | 69.3451 | 2020-05-14 03:32:28 | Pakistan | |||
2020-05-12 | Pakistan | 34336 | 737 | 8812 | 24787 | 30.3753 | 69.3451 | 2020-05-13 03:32:26 | Pakistan | |||
2020-05-11 | Pakistan | 32081 | 706 | 8555 | 22820 | 30.3753 | 69.3451 | 2020-05-12 03:32:27 | Pakistan | |||
2020-05-10 | Pakistan | 30334 | 659 | 8063 | 21612 | 30.3753 | 69.3451 | 2020-05-11 02:32:30 | Pakistan | |||
2020-05-09 | Pakistan | 28736 | 636 | 7809 | 20291 | 30.3753 | 69.3451 | 2020-05-10 02:32:30 | Pakistan | |||
2020-05-08 | Pakistan | 26435 | 599 | 7530 | 18306 | 30.3753 | 69.3451 | 2020-05-09 02:32:35 | Pakistan | |||
2020-05-07 | Pakistan | 24644 | 585 | 6464 | 17595 | 30.3753 | 69.3451 | 2020-05-08 02:32:32 | Pakistan | |||
2020-05-06 | Pakistan | 24073 | 564 | 6464 | 17045 | 30.3753 | 69.3451 | 2020-05-07 02:32:28 | Pakistan | |||
2020-05-05 | Pakistan | 22049 | 514 | 5801 | 15734 | 30.3753 | 69.3451 | 2020-05-06 02:32:31 | Pakistan | |||
2020-05-04 | Pakistan | 20941 | 476 | 5635 | 14830 | 30.3753 | 69.3451 | 2020-05-05 02:32:34 | Pakistan | |||
2020-05-03 | Pakistan | 20084 | 457 | 5114 | 14513 | 30.3753 | 69.3451 | 2020-05-04 02:32:28 | Pakistan | |||
2020-05-02 | Pakistan | 19103 | 440 | 4817 | 13846 | 30.3753 | 69.3451 | 2020-05-03 02:32:28 | Pakistan | |||
2020-05-01 | Pakistan | 18114 | 417 | 4715 | 12982 | 30.3753 | 69.3451 | 2020-05-02 02:32:27 | Pakistan | |||
2020-04-30 | Pakistan | 16817 | 385 | 4315 | 12117 | 30.3753 | 69.3451 | 2020-05-01 02:32:28 | Pakistan | |||
2020-04-29 | Pakistan | 15525 | 343 | 3425 | 11757 | 30.3753 | 69.3451 | 2020-04-30 02:32:27 | Pakistan | |||
2020-04-28 | Pakistan | 14612 | 312 | 3233 | 11067 | 30.3753 | 69.3451 | 2020-04-29 02:32:29 | Pakistan | |||
2020-04-27 | Pakistan | 13915 | 292 | 3029 | 10594 | 30.3753 | 69.3451 | 2020-04-28 02:30:32 | Pakistan | |||
2020-04-26 | Pakistan | 13328 | 281 | 2936 | 10111 | 30.3753 | 69.3451 | 2020-04-27 02:30:33 | Pakistan | |||
2020-04-25 | Pakistan | 12723 | 269 | 2866 | 9588 | 30.3753 | 69.3451 | 2020-04-26 02:30:31 | Pakistan | |||
2020-04-24 | Pakistan | 11940 | 253 | 2755 | 8932 | 30.3753 | 69.3451 | 2020-04-25 06:30:33 | Pakistan | |||
2020-04-23 | Pakistan | 11155 | 237 | 2527 | 8391 | 30.3753 | 69.3451 | 2020-04-24 03:30:31 | Pakistan | |||
2020-04-22 | Pakistan | 10076 | 212 | 2156 | 7708 | 30.3753 | 69.3451 | 2020-04-22 23:30:32 | Pakistan | |||
2020-04-21 | Pakistan | 9565 | 201 | 2073 | 7291 | 30.3753 | 69.3451 | 2020-04-21 23:30:30 | Pakistan | |||
2020-04-20 | Pakistan | 8418 | 176 | 1970 | 6272 | 30.3753 | 69.3451 | 2020-04-20 23:36:27 | Pakistan | |||
2020-04-19 | Pakistan | 8348 | 168 | 1868 | 6312 | 30.3753 | 69.3451 | 2020-04-19 23:40:41 | Pakistan | |||
2020-04-18 | Pakistan | 7638 | 143 | 1832 | 5663 | 30.3753 | 69.3451 | 2020-04-18 22:32:28 | Pakistan | |||
2020-04-17 | Pakistan | 7025 | 135 | 1765 | 5125 | 30.3753 | 69.3451 | 2020-04-17 23:30:32 | Pakistan | |||
2020-04-16 | Pakistan | 6919 | 128 | 1645 | 5146 | 30.3753 | 69.3451 | 2020-04-16 23:30:31 | Pakistan | |||
2020-04-15 | Pakistan | 6383 | 111 | 1446 | 4826 | 30.3753 | 69.3451 | 2020-04-15 22:56:32 | Pakistan | |||
2020-04-14 | Pakistan | 5837 | 96 | 1378 | 4363 | 30.3753 | 69.3451 | 2020-04-14 23:33:12 | Pakistan | |||
2020-04-13 | Pakistan | 5496 | 93 | 1095 | 4308 | 30.3753 | 69.3451 | 2020-04-13 23:07:34 | Pakistan | |||
2020-04-12 | Pakistan | 5230 | 91 | 1028 | 4111 | 30.3753 | 69.3451 | 2020-04-12 23:17:00 | Pakistan | |||
2020-04-11 | Pakistan | 5011 | 86 | 762 | 4163 | 30.3753 | 69.3451 | 2020-04-11 22:45:13 | Pakistan | |||
2020-04-10 | Pakistan | 4695 | 66 | 727 | 3902 | 30.3753 | 69.3451 | 2020-04-10 22:53:48 | Pakistan | |||
2020-04-09 | Pakistan | 4489 | 65 | 572 | 3852 | 30.3753 | 69.3451 | 2020-04-09 23:02:19 | Pakistan | |||
2020-04-08 | Pakistan | 4263 | 61 | 467 | 3735 | 30.3753 | 69.3451 | 2020-04-08 22:51:39 | Pakistan | |||
2020-04-07 | Pakistan | 4035 | 57 | 429 | 3549 | 30.3753 | 69.3451 | 2020-04-07 23:04:29 | Pakistan | |||
2020-04-06 | Pakistan | 3766 | 53 | 259 | 3454 | 30.3753 | 69.3451 | 4/6/20 23:21 | Pakistan | |||
2020-04-05 | Pakistan | 3157 | 47 | 211 | 2899 | 30.3753 | 69.3451 | 2020-04-05 23:06:26 | Pakistan | |||
2020-04-04 | Pakistan | 2818 | 41 | 131 | 2646 | 30.3753 | 69.3451 | 4/4/20 23:34 | Pakistan | |||
2020-04-03 | Pakistan | 2686 | 40 | 126 | 2520 | 30.3753 | 69.3451 | 2020-04-03 22:46:20 | Pakistan | |||
2020-04-02 | Pakistan | 2421 | 34 | 125 | 2262 | 30.3753 | 69.3451 | 4/2/20 23:25 | Pakistan | |||
2020-04-01 | Pakistan | 2118 | 27 | 94 | 1997 | 30.3753 | 69.3451 | 2020-04-01 21:58:34 | Pakistan | |||
2020-03-31 | Pakistan | 1938 | 26 | 76 | 1836 | 30.3753 | 69.3451 | 2020-03-31 23:43:43 | Pakistan | |||
2020-03-30 | Pakistan | 1717 | 21 | 76 | 1620 | 30.3753 | 69.3451 | 3/30/20 22:52 | Pakistan | |||
2020-03-29 | Pakistan | 1597 | 14 | 29 | 1554 | 30.3753 | 69.3451 | 3/29/20 23:08 | Pakistan | |||
2020-03-28 | Pakistan | 1495 | 12 | 29 | 1454 | 30.3753 | 69.3451 | 3/28/20 23:05 | Pakistan | |||
2020-03-27 | Pakistan | 1373 | 11 | 23 | 1339 | 30.3753 | 69.3451 | 2020-03-27 23:23:03 | Pakistan | |||
2020-03-26 | Pakistan | 1201 | 9 | 21 | 1171 | 30.3753 | 69.3451 | 2020-03-26 23:48:18 | Pakistan | |||
2020-03-25 | Pakistan | 1063 | 8 | 21 | 1034 | 30.3753 | 69.3451 | 2020-03-25 23:33:04 | Pakistan | |||
2020-03-24 | Pakistan | 972 | 7 | 18 | 947 | 30.3753 | 69.3451 | 2020-03-24 23:37:15 | Pakistan | |||
2020-03-23 | Pakistan | 875 | 6 | 13 | 856 | 30.3753 | 69.3451 | 2020-03-23 23:19:21 | Pakistan | |||
2020-03-22 | Pakistan | 776 | 4 | 13 | 759 | 30.3753 | 69.3451 | 3/22/20 23:45 | Pakistan | |||
2020-03-21 | Pakistan | 730 | 3 | 13 | 30.3753 | 69.3451 | 2020-03-21T20:13:21 | |||||
2020-03-20 | Pakistan | 501 | 3 | 13 | 30.3753 | 69.3451 | 2020-03-20T20:13:16 | |||||
2020-03-19 | Pakistan | 454 | 2 | 13 | 30.3753 | 69.3451 | 2020-03-19T20:13:08 | |||||
2020-03-18 | Pakistan | 299 | 0 | 2 | 30.3753 | 69.3451 | 2020-03-18T19:14:29 | |||||
2020-03-17 | Pakistan | 236 | 0 | 2 | 30.3753 | 69.3451 | 2020-03-17T15:33:06 | |||||
2020-03-16 | Pakistan | 136 | 0 | 2 | 30.3753 | 69.3451 | 2020-03-16T14:38:45 | |||||
2020-03-15 | Pakistan | 53 | 0 | 2 | 30.3753 | 69.3451 | 2020-03-15T18:20:18 | |||||
2020-03-14 | Pakistan | 31 | 0 | 2 | 30.3753 | 69.3451 | 2020-03-14T20:33:03 | |||||
2020-03-13 | Pakistan | 28 | 0 | 2 | 30.3753 | 69.3451 | 2020-03-11T20:00:00 | |||||
2020-03-12 | Pakistan | 20 | 0 | 2 | 30.3753 | 69.3451 | 2020-03-12T08:53:02 | |||||
2020-03-11 | Pakistan | 19 | 0 | 2 | 30.3753 | 69.3451 | 2020-03-11T21:13:23 | |||||
2020-03-10 | Pakistan | 16 | 0 | 1 | 30.3753 | 69.3451 | 2020-03-10T05:13:07 | |||||
2020-03-09 | Pakistan | 6 | 0 | 1 | 30.3753 | 69.3451 | 2020-03-08T04:53:02 | |||||
2020-03-08 | Pakistan | 6 | 0 | 1 | 30.3753 | 69.3451 | 2020-03-08T04:53:02 | |||||
2020-03-07 | Pakistan | 6 | 0 | 0 | 30.3753 | 69.3451 | 2020-03-06T13:03:12 | |||||
2020-03-06 | Pakistan | 6 | 0 | 0 | 30.3753 | 69.3451 | 2020-03-06T13:03:12 | |||||
2020-03-05 | Pakistan | 5 | 0 | 0 | 30.3753 | 69.3451 | 2020-03-03T04:33:03 | |||||
2020-03-04 | Pakistan | 5 | 0 | 0 | 30.3753 | 69.3451 | 2020-03-03T04:33:03 | |||||
2020-03-03 | Pakistan | 5 | 0 | 0 | 30.3753 | 69.3451 | 2020-03-03T04:33:03 | |||||
2020-03-02 | Pakistan | 4 | 0 | 0 | 30.3753 | 69.3451 | 2020-02-29T18:03:05 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;