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 = "Sindh" sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3070178 | 3070178 | 2021-11-23 | Pakistan | Sindh | 474573 | 7613 | 0 | 26.009446 | 68.77680699999999 | 2021-11-24 04:22:14 | Sindh, Pakistan | |||
3749276 | 3749276 | 2021-11-22 | Pakistan | Sindh | 474407 | 7611 | 0 | 26.009446 | 68.77680699999999 | 2021-11-23 04:22:39 | Sindh, Pakistan | |||
1014483 | 1014483 | 2021-11-21 | Pakistan | Sindh | 474243 | 7611 | 0 | 26.009446 | 68.77680699999999 | 2021-11-22 04:22:20 | Sindh, Pakistan | |||
722647 | 722647 | 2021-11-20 | Pakistan | Sindh | 474058 | 7611 | 0 | 26.009446 | 68.77680699999999 | 2021-11-21 04:22:13 | Sindh, Pakistan | |||
162177 | 162177 | 2021-11-19 | Pakistan | Sindh | 473918 | 7611 | 0 | 26.009446 | 68.77680699999999 | 2021-11-20 04:22:17 | Sindh, Pakistan | |||
3289064 | 3289064 | 2021-11-18 | Pakistan | Sindh | 473767 | 7611 | 0 | 26.009446 | 68.77680699999999 | 2021-11-19 04:21:40 | Sindh, Pakistan | |||
447520 | 447520 | 2021-11-17 | Pakistan | Sindh | 473561 | 7609 | 0 | 26.009446 | 68.77680699999999 | 2021-11-18 04:21:33 | Sindh, Pakistan | |||
3342770 | 3342770 | 2021-11-16 | Pakistan | Sindh | 473293 | 7605 | 0 | 26.009446 | 68.77680699999999 | 2021-11-17 04:21:48 | Sindh, Pakistan | |||
2287606 | 2287606 | 2021-11-15 | Pakistan | Sindh | 473250 | 7604 | 0 | 26.009446 | 68.77680699999999 | 2021-11-16 04:21:10 | Sindh, Pakistan | |||
1322380 | 1322380 | 2021-11-14 | Pakistan | Sindh | 473199 | 7603 | 0 | 26.009446 | 68.77680699999999 | 2021-11-15 04:21:36 | Sindh, Pakistan | |||
686506 | 686506 | 2021-11-13 | Pakistan | Sindh | 473081 | 7600 | 0 | 26.009446 | 68.77680699999999 | 2021-11-14 04:21:31 | Sindh, Pakistan | |||
714615 | 714615 | 2021-11-12 | Pakistan | Sindh | 473081 | 7600 | 0 | 26.009446 | 68.77680699999999 | 2021-11-13 04:21:38 | Sindh, Pakistan | |||
28565 | 28565 | 2021-11-11 | Pakistan | Sindh | 473052 | 7599 | 0 | 26.009446 | 68.77680699999999 | 2021-11-12 04:22:01 | Sindh, Pakistan | |||
2845004 | 2845004 | 2021-11-10 | Pakistan | Sindh | 472925 | 7599 | 0 | 26.009446 | 68.77680699999999 | 2021-11-11 04:21:45 | Sindh, Pakistan | |||
87274 | 87274 | 2021-11-09 | Pakistan | Sindh | 472519 | 7599 | 0 | 26.009446 | 68.77680699999999 | 2021-11-10 04:21:38 | Sindh, Pakistan | |||
3639702 | 3639702 | 2021-11-08 | Pakistan | Sindh | 472213 | 7598 | 0 | 26.009446 | 68.77680699999999 | 2021-11-09 04:21:36 | Sindh, Pakistan | |||
2000810 | 2000810 | 2021-11-07 | Pakistan | Sindh | 471963 | 7596 | 0 | 26.009446 | 68.77680699999999 | 2021-11-08 04:21:43 | Sindh, Pakistan | |||
495801 | 495801 | 2021-11-06 | Pakistan | Sindh | 471733 | 7595 | 0 | 26.009446 | 68.77680699999999 | 2021-11-07 04:21:53 | Sindh, Pakistan | |||
3121656 | 3121656 | 2021-11-05 | Pakistan | Sindh | 471497 | 7582 | 0 | 26.009446 | 68.77680699999999 | 2021-11-06 04:21:51 | Sindh, Pakistan | |||
698554 | 698554 | 2021-11-04 | Pakistan | Sindh | 471205 | 7580 | 0 | 26.009446 | 68.77680699999999 | 2021-11-05 04:21:54 | Sindh, Pakistan | |||
276332 | 276332 | 2021-11-03 | Pakistan | Sindh | 470978 | 7579 | 0 | 26.009446 | 68.77680699999999 | 2021-11-04 04:22:20 | Sindh, Pakistan | |||
43857 | 43857 | 2021-11-02 | Pakistan | Sindh | 470690 | 7571 | 0 | 26.009446 | 68.77680699999999 | 2021-11-03 06:22:09 | Sindh, Pakistan | |||
3511553 | 3511553 | 2021-11-01 | Pakistan | Sindh | 470421 | 7569 | 0 | 26.009446 | 68.77680699999999 | 2021-11-02 04:22:03 | Sindh, Pakistan | |||
288145 | 288145 | 2021-10-31 | Pakistan | Sindh | 470175 | 7568 | 0 | 26.009446 | 68.77680699999999 | 2021-11-01 04:22:01 | Sindh, Pakistan | |||
2721151 | 2721151 | 2021-10-30 | Pakistan | Sindh | 469960 | 7567 | 0 | 26.009446 | 68.77680699999999 | 2021-10-31 04:22:08 | Sindh, Pakistan | |||
567253 | 567253 | 2021-10-29 | Pakistan | Sindh | 469475 | 7563 | 0 | 26.009446 | 68.77680699999999 | 2021-10-30 04:22:03 | Sindh, Pakistan | |||
4495 | 4495 | 2021-10-28 | Pakistan | Sindh | 469122 | 7563 | 0 | 26.009446 | 68.77680699999999 | 2021-10-29 04:22:03 | Sindh, Pakistan | |||
534885 | 534885 | 2021-10-27 | Pakistan | Sindh | 468776 | 7557 | 0 | 26.009446 | 68.77680699999999 | 2021-10-28 04:22:08 | Sindh, Pakistan | |||
3492322 | 3492322 | 2021-10-26 | Pakistan | Sindh | 468401 | 7555 | 0 | 26.009446 | 68.77680699999999 | 2021-10-27 04:22:32 | Sindh, Pakistan | |||
3794044 | 3794044 | 2021-10-25 | Pakistan | Sindh | 468164 | 7551 | 0 | 26.009446 | 68.77680699999999 | 2021-10-26 04:22:09 | Sindh, Pakistan | |||
682490 | 682490 | 2021-10-24 | Pakistan | Sindh | 467814 | 7551 | 0 | 26.009446 | 68.77680699999999 | 2021-10-25 04:22:31 | Sindh, Pakistan | |||
770498 | 770498 | 2021-10-23 | Pakistan | Sindh | 467425 | 7548 | 0 | 26.009446 | 68.77680699999999 | 2021-10-24 04:21:22 | Sindh, Pakistan | |||
654145 | 654145 | 2021-10-22 | Pakistan | Sindh | 467142 | 7540 | 0 | 26.009446 | 68.77680699999999 | 2021-10-23 04:21:32 | Sindh, Pakistan | |||
2123892 | 2123892 | 2021-10-21 | Pakistan | Sindh | 466945 | 7539 | 0 | 26.009446 | 68.77680699999999 | 2021-10-22 04:21:14 | Sindh, Pakistan | |||
443504 | 443504 | 2021-10-20 | Pakistan | Sindh | 466750 | 7536 | 0 | 26.009446 | 68.77680699999999 | 2021-10-21 04:21:18 | Sindh, Pakistan | |||
597823 | 597823 | 2021-10-19 | Pakistan | Sindh | 466432 | 7534 | 0 | 26.009446 | 68.77680699999999 | 2021-10-20 04:21:00 | Sindh, Pakistan | |||
2044000 | 2044000 | 2021-10-18 | Pakistan | Sindh | 466154 | 7533 | 0 | 26.009446 | 68.77680699999999 | 2021-10-19 04:20:54 | Sindh, Pakistan | |||
1909361 | 1909361 | 2021-10-17 | Pakistan | Sindh | 465819 | 7530 | 0 | 26.009446 | 68.77680699999999 | 2021-10-18 04:21:10 | Sindh, Pakistan | |||
934950 | 934950 | 2021-10-16 | Pakistan | Sindh | 465486 | 7529 | 0 | 26.009446 | 68.77680699999999 | 2021-10-17 04:21:29 | Sindh, Pakistan | |||
2943505 | 2943505 | 2021-10-15 | Pakistan | Sindh | 465175 | 7525 | 0 | 26.009446 | 68.77680699999999 | 2021-10-16 04:21:15 | Sindh, Pakistan | |||
491785 | 491785 | 2021-10-14 | Pakistan | Sindh | 464746 | 7520 | 0 | 26.009446 | 68.77680699999999 | 2021-10-15 04:21:26 | Sindh, Pakistan | |||
634073 | 634073 | 2021-10-13 | Pakistan | Sindh | 464142 | 7514 | 0 | 26.009446 | 68.77680699999999 | 2021-10-14 04:21:29 | Sindh, Pakistan | |||
1491751 | 1491751 | 2021-10-12 | Pakistan | Sindh | 463703 | 7505 | 0 | 26.009446 | 68.77680699999999 | 2021-10-13 04:20:51 | Sindh, Pakistan | |||
3007484 | 3007484 | 2021-10-11 | Pakistan | Sindh | 463167 | 7502 | 0 | 26.009446 | 68.77680699999999 | 2021-10-12 04:21:09 | Sindh, Pakistan | |||
423500 | 423500 | 2021-10-10 | Pakistan | Sindh | 462859 | 7497 | 0 | 26.009446 | 68.77680699999999 | 2021-10-11 04:21:31 | Sindh, Pakistan | |||
2876357 | 2876357 | 2021-10-09 | Pakistan | Sindh | 462466 | 7484 | 0 | 26.009446 | 68.77680699999999 | 2021-10-10 04:21:38 | Sindh, Pakistan | |||
2959523 | 2959523 | 2021-10-08 | Pakistan | Sindh | 462295 | 7480 | 0 | 26.009446 | 68.77680699999999 | 2021-10-09 04:21:34 | Sindh, Pakistan | |||
467561 | 467561 | 2021-10-07 | Pakistan | Sindh | 462155 | 7474 | 0 | 26.009446 | 68.77680699999999 | 2021-10-08 04:21:25 | Sindh, Pakistan | |||
2458941 | 2458941 | 2021-10-06 | Pakistan | Sindh | 461869 | 7471 | 0 | 26.009446 | 68.77680699999999 | 2021-10-07 04:21:36 | Sindh, Pakistan | |||
3832635 | 3832635 | 2021-10-05 | Pakistan | Sindh | 461258 | 7451 | 0 | 26.009446 | 68.77680699999999 | 2021-10-06 04:21:33 | Sindh, Pakistan | |||
987128 | 987128 | 2021-10-04 | Pakistan | Sindh | 460748 | 7442 | 0 | 26.009446 | 68.77680699999999 | 2021-10-05 04:21:27 | Sindh, Pakistan | |||
1274438 | 1274438 | 2021-10-03 | Pakistan | Sindh | 460111 | 7427 | 0 | 26.009446 | 68.77680699999999 | 2021-10-04 04:21:31 | Sindh, Pakistan | |||
3928191 | 3928191 | 2021-10-02 | Pakistan | Sindh | 459392 | 7425 | 0 | 26.009446 | 68.77680699999999 | 2021-10-03 04:21:24 | Sindh, Pakistan | |||
2132171 | 2132171 | 2021-10-01 | Pakistan | Sindh | 458697 | 7414 | 0 | 26.009446 | 68.77680699999999 | 2021-10-02 04:21:25 | Sindh, Pakistan | |||
2773128 | 2773128 | 2021-09-30 | Pakistan | Sindh | 457928 | 7407 | 0 | 26.009446 | 68.77680699999999 | 2021-10-01 04:21:35 | Sindh, Pakistan | |||
706584 | 706584 | 2021-09-29 | Pakistan | Sindh | 457458 | 7382 | 0 | 26.009446 | 68.77680699999999 | 2021-09-30 04:21:20 | Sindh, Pakistan | |||
1334426 | 1334426 | 2021-09-28 | Pakistan | Sindh | 456897 | 7379 | 0 | 26.009446 | 68.77680699999999 | 2021-09-29 04:21:45 | Sindh, Pakistan | |||
1235795 | 1235795 | 2021-09-27 | Pakistan | Sindh | 456343 | 7361 | 0 | 26.009446 | 68.77680699999999 | 2021-09-28 04:21:28 | Sindh, Pakistan | |||
2076096 | 2076096 | 2021-09-26 | Pakistan | Sindh | 455808 | 7350 | 0 | 26.009446 | 68.77680699999999 | 2021-09-27 04:21:16 | Sindh, Pakistan | |||
1724648 | 1724648 | 2021-09-25 | Pakistan | Sindh | 455065 | 7335 | 0 | 26.009446 | 68.77680699999999 | 2021-09-26 04:21:29 | Sindh, Pakistan | |||
1921368 | 1921368 | 2021-09-24 | Pakistan | Sindh | 454510 | 7327 | 0 | 26.009446 | 68.77680699999999 | 2021-09-25 04:21:31 | Sindh, Pakistan | |||
601839 | 601839 | 2021-09-23 | Pakistan | Sindh | 453858 | 7316 | 0 | 26.009446 | 68.77680699999999 | 2021-09-24 04:21:44 | Sindh, Pakistan | |||
3011483 | 3011483 | 2021-09-22 | Pakistan | Sindh | 453051 | 7310 | 0 | 26.009446 | 68.77680699999999 | 2021-09-23 04:21:43 | Sindh, Pakistan | |||
3757621 | 3757621 | 2021-09-21 | Pakistan | Sindh | 452267 | 7295 | 0 | 26.009446 | 68.77680699999999 | 2021-09-22 04:21:45 | Sindh, Pakistan | |||
809724 | 809724 | 2021-09-20 | Pakistan | Sindh | 451448 | 7289 | 0 | 26.009446 | 68.77680699999999 | 2021-09-21 04:21:26 | Sindh, Pakistan | |||
1814923 | 1814923 | 2021-09-19 | Pakistan | Sindh | 450787 | 7270 | 0 | 26.009446 | 68.77680699999999 | 2021-09-20 04:21:22 | Sindh, Pakistan | |||
16503 | 16503 | 2021-09-18 | Pakistan | Sindh | 450126 | 7258 | 0 | 26.009446 | 68.77680699999999 | 2021-09-19 04:21:34 | Sindh, Pakistan | |||
2618188 | 2618188 | 2021-09-17 | Pakistan | Sindh | 449349 | 7243 | 0 | 26.009446 | 68.77680699999999 | 2021-09-18 04:21:24 | Sindh, Pakistan | |||
2808896 | 2808896 | 2021-09-16 | Pakistan | Sindh | 448658 | 7224 | 0 | 26.009446 | 68.77680699999999 | 2021-09-17 04:21:46 | Sindh, Pakistan | |||
1374641 | 1374641 | 2021-09-15 | Pakistan | Sindh | 447678 | 7210 | 0 | 26.009446 | 68.77680699999999 | 2021-09-16 04:22:19 | Sindh, Pakistan | |||
2462940 | 2462940 | 2021-09-14 | Pakistan | Sindh | 446840 | 7192 | 0 | 26.009446 | 68.77680699999999 | 2021-09-15 03:22:37 | Sindh, Pakistan | |||
1385779 | 1385779 | 2021-09-13 | Pakistan | Sindh | 446045 | 7177 | 0 | 26.009446 | 68.77680699999999 | 2021-09-14 04:21:41 | Sindh, Pakistan | |||
1885148 | 1885148 | 2021-09-12 | Pakistan | Sindh | 445369 | 7159 | 0 | 26.009446 | 68.77680699999999 | 2021-09-13 04:21:15 | Sindh, Pakistan | |||
3806051 | 3806051 | 2021-09-11 | Pakistan | Sindh | 444464 | 7133 | 0 | 26.009446 | 68.77680699999999 | 2021-09-12 04:21:13 | Sindh, Pakistan | |||
3448991 | 3448991 | 2021-09-10 | Pakistan | Sindh | 443521 | 7116 | 0 | 26.009446 | 68.77680699999999 | 2021-09-11 04:21:30 | Sindh, Pakistan | |||
1262937 | 1262937 | 2021-09-09 | Pakistan | Sindh | 442401 | 7089 | 0 | 26.009446 | 68.77680699999999 | 2021-09-10 04:21:20 | Sindh, Pakistan | |||
2279307 | 2279307 | 2021-09-08 | Pakistan | Sindh | 441410 | 7073 | 0 | 26.009446 | 68.77680699999999 | 2021-09-09 04:21:27 | Sindh, Pakistan | |||
642086 | 642086 | 2021-09-07 | Pakistan | Sindh | 440164 | 7030 | 0 | 26.009446 | 68.77680699999999 | 2021-09-08 04:21:31 | Sindh, Pakistan | |||
3194149 | 3194149 | 2021-09-06 | Pakistan | Sindh | 439119 | 6995 | 0 | 26.009446 | 68.77680699999999 | 2021-09-07 04:21:35 | Sindh, Pakistan | |||
3281017 | 3281017 | 2021-09-05 | Pakistan | Sindh | 438327 | 6960 | 0 | 26.009446 | 68.77680699999999 | 2021-09-06 04:21:22 | Sindh, Pakistan | |||
249431 | 249431 | 2021-09-04 | Pakistan | Sindh | 437311 | 6955 | 0 | 26.009446 | 68.77680699999999 | 2021-09-05 04:21:33 | Sindh, Pakistan | |||
3974712 | 3974712 | 2021-09-03 | Pakistan | Sindh | 435159 | 6932 | 0 | 26.009446 | 68.77680699999999 | 2021-09-04 04:21:28 | Sindh, Pakistan | |||
178174 | 178174 | 2021-09-02 | Pakistan | Sindh | 435159 | 6932 | 0 | 26.009446 | 68.77680699999999 | 2021-09-03 04:21:20 | Sindh, Pakistan | |||
67209 | 67209 | 2021-09-01 | Pakistan | Sindh | 433931 | 6924 | 0 | 26.009446 | 68.77680699999999 | 2021-09-02 04:21:15 | Sindh, Pakistan | |||
2068051 | 2068051 | 2021-08-31 | Pakistan | Sindh | 432637 | 6910 | 0 | 26.009446 | 68.77680699999999 | 2021-09-01 04:21:38 | Sindh, Pakistan | |||
1775505 | 1775505 | 2021-08-30 | Pakistan | Sindh | 431636 | 6875 | 0 | 26.009446 | 68.77680699999999 | 2021-08-31 04:21:46 | Sindh, Pakistan | |||
3892079 | 3892079 | 2021-08-29 | Pakistan | Sindh | 430594 | 6834 | 0 | 26.009446 | 68.77680699999999 | 2021-08-30 04:21:23 | Sindh, Pakistan | |||
2793182 | 2793182 | 2021-08-28 | Pakistan | Sindh | 429422 | 6812 | 0 | 26.009446 | 68.77680699999999 | 2021-08-29 04:21:14 | Sindh, Pakistan | |||
2923341 | 2923341 | 2021-08-27 | Pakistan | Sindh | 428254 | 6803 | 0 | 26.009446 | 68.77680699999999 | 2021-08-28 04:21:28 | Sindh, Pakistan | |||
1596355 | 1596355 | 2021-08-26 | Pakistan | Sindh | 427037 | 6766 | 0 | 26.009446 | 68.77680699999999 | 2021-08-27 04:21:37 | Sindh, Pakistan | |||
32564 | 32564 | 2021-08-25 | Pakistan | Sindh | 425570 | 6742 | 0 | 26.009446 | 68.77680699999999 | 2021-08-26 04:21:28 | Sindh, Pakistan | |||
3105603 | 3105603 | 2021-08-24 | Pakistan | Sindh | 424139 | 6698 | 0 | 26.009446 | 68.77680699999999 | 2021-08-25 04:21:41 | Sindh, Pakistan | |||
3165774 | 3165774 | 2021-08-23 | Pakistan | Sindh | 422418 | 6627 | 0 | 26.009446 | 68.77680699999999 | 2021-08-24 04:21:19 | Sindh, Pakistan | |||
2175701 | 2175701 | 2021-08-22 | Pakistan | Sindh | 420955 | 6612 | 0 | 26.009446 | 68.77680699999999 | 2021-08-23 04:21:27 | Sindh, Pakistan | |||
3555797 | 3555797 | 2021-08-21 | Pakistan | Sindh | 419810 | 6590 | 0 | 26.009446 | 68.77680699999999 | 2021-08-22 04:21:29 | Sindh, Pakistan | |||
1854139 | 1854139 | 2021-08-20 | Pakistan | Sindh | 418478 | 6566 | 0 | 26.009446 | 68.77680699999999 | 2021-08-21 04:21:38 | Sindh, Pakistan | |||
511846 | 511846 | 2021-08-19 | Pakistan | Sindh | 417439 | 6556 | 0 | 26.009446 | 68.77680699999999 | 2021-08-20 04:21:33 | Sindh, Pakistan | |||
2518325 | 2518325 | 2021-08-18 | Pakistan | Sindh | 416230 | 6529 | 0 | 26.009446 | 68.77680699999999 | 2021-08-19 04:21:15 | Sindh, Pakistan | |||
245417 | 245417 | 2021-08-17 | Pakistan | Sindh | 414850 | 6497 | 0 | 26.009446 | 68.77680699999999 | 2021-08-18 04:21:35 | Sindh, Pakistan | |||
1604380 | 1604380 | 2021-08-16 | Pakistan | Sindh | 413379 | 6475 | 0 | 26.009446 | 68.77680699999999 | 2021-08-17 04:21:49 | Sindh, 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]);