daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Punjab" sorted by recovered descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, 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-08-04 | India | Punjab | 599266 | 16299 | 582494 | 473 | 30.841465000000003 | 75.40879 | 2021-08-05 04:21:51 | Punjab, India | ||
2021-08-03 | India | Punjab | 599204 | 16299 | 582442 | 463 | 30.841465000000003 | 75.40879 | 2021-08-04 04:21:25 | Punjab, India | ||
2021-08-02 | India | Punjab | 599162 | 16294 | 582395 | 473 | 30.841465000000003 | 75.40879 | 2021-08-03 04:21:39 | Punjab, India | ||
2021-08-01 | India | Punjab | 599130 | 16294 | 582332 | 504 | 30.841465000000003 | 75.40879 | 2021-08-02 04:21:36 | Punjab, India | ||
2021-07-31 | India | Punjab | 599104 | 16293 | 582277 | 534 | 30.841465000000003 | 75.40879 | 2021-08-01 04:21:50 | Punjab, India | ||
2021-07-30 | India | Punjab | 599053 | 16292 | 582217 | 544 | 30.841465000000003 | 75.40879 | 2021-07-31 04:21:35 | Punjab, India | ||
2021-07-29 | India | Punjab | 599005 | 16290 | 582162 | 553 | 30.841465000000003 | 75.40879 | 2021-07-30 04:21:34 | Punjab, India | ||
2021-07-28 | India | Punjab | 598947 | 16286 | 582102 | 559 | 30.841465000000003 | 75.40879 | 2021-07-29 04:21:33 | Punjab, India | ||
2021-07-27 | India | Punjab | 598882 | 16281 | 582018 | 583 | 30.841465000000003 | 75.40879 | 2021-07-28 04:21:39 | Punjab, India | ||
2021-07-26 | India | Punjab | 598840 | 16278 | 581925 | 637 | 30.841465000000003 | 75.40879 | 2021-07-27 04:21:18 | Punjab, India | ||
2021-07-25 | India | Punjab | 598794 | 16266 | 581829 | 699 | 30.841465000000003 | 75.40879 | 2021-07-26 04:21:28 | Punjab, India | ||
2021-07-24 | India | Punjab | 598741 | 16258 | 581712 | 771 | 30.841465000000003 | 75.40879 | 2021-07-25 04:22:12 | Punjab, India | ||
2021-07-23 | India | Punjab | 598658 | 16256 | 581529 | 873 | 30.841465000000003 | 75.40879 | 2021-07-24 00:21:36 | Punjab, India | ||
2021-07-22 | India | Punjab | 598590 | 16250 | 581529 | 811 | 30.841465000000003 | 75.40879 | 2021-07-23 04:21:29 | Punjab, India | ||
2021-07-21 | India | Punjab | 598521 | 16246 | 581406 | 869 | 30.841465000000003 | 75.40879 | 2021-07-22 04:21:19 | Punjab, India | ||
2021-07-20 | India | Punjab | 598455 | 16244 | 581312 | 899 | 30.841465000000003 | 75.40879 | 2021-07-21 04:21:40 | Punjab, India | ||
2021-07-19 | India | Punjab | 598387 | 16237 | 581197 | 953 | 30.841465000000003 | 75.40879 | 2021-07-20 04:21:48 | Punjab, India | ||
2021-07-18 | India | Punjab | 598334 | 16233 | 581055 | 1046 | 30.841465000000003 | 75.40879 | 2021-07-19 04:21:24 | Punjab, India | ||
2021-07-17 | India | Punjab | 598248 | 16224 | 580871 | 1153 | 30.841465000000003 | 75.40879 | 2021-07-18 04:22:07 | Punjab, India | ||
2021-07-16 | India | Punjab | 598130 | 16215 | 580677 | 1238 | 30.841465000000003 | 75.40879 | 2021-07-17 04:22:22 | Punjab, India | ||
2021-07-15 | India | Punjab | 598027 | 16212 | 580483 | 1332 | 30.841465000000003 | 75.40879 | 2021-07-16 04:21:22 | Punjab, India | ||
2021-07-14 | India | Punjab | 597929 | 16207 | 580336 | 1386 | 30.841465000000003 | 75.40879 | 2021-07-15 04:21:48 | Punjab, India | ||
2021-07-13 | India | Punjab | 597821 | 16199 | 580195 | 1427 | 30.841465000000003 | 75.40879 | 2021-07-14 04:21:35 | Punjab, India | ||
2021-07-12 | India | Punjab | 597714 | 16193 | 580027 | 1494 | 30.841465000000003 | 75.40879 | 2021-07-13 04:21:18 | Punjab, India | ||
2021-07-11 | India | Punjab | 597598 | 16186 | 579829 | 1583 | 30.841465000000003 | 75.40879 | 2021-07-12 04:21:34 | Punjab, India | ||
2021-07-10 | India | Punjab | 597469 | 16177 | 579618 | 1674 | 30.841465000000003 | 75.40879 | 2021-07-11 04:21:43 | Punjab, India | ||
2021-07-09 | India | Punjab | 597347 | 16168 | 579370 | 1809 | 30.841465000000003 | 75.40879 | 2021-07-10 04:21:25 | Punjab, India | ||
2021-07-08 | India | Punjab | 597195 | 16157 | 579111 | 1927 | 30.841465000000003 | 75.40879 | 2021-07-09 04:21:21 | Punjab, India | ||
2021-07-07 | India | Punjab | 596970 | 16141 | 578865 | 1964 | 30.841465000000003 | 75.40879 | 2021-07-08 04:21:26 | Punjab, India | ||
2021-07-06 | India | Punjab | 596736 | 16131 | 578590 | 2015 | 30.841465000000003 | 75.40879 | 2021-07-07 04:21:20 | Punjab, India | ||
2021-07-05 | India | Punjab | 596550 | 16122 | 578310 | 2118 | 30.841465000000003 | 75.40879 | 2021-07-06 04:21:32 | Punjab, India | ||
2021-07-04 | India | Punjab | 596416 | 16110 | 577982 | 2324 | 30.841465000000003 | 75.40879 | 2021-07-05 04:21:28 | Punjab, India | ||
2021-07-03 | India | Punjab | 596265 | 16103 | 577624 | 2538 | 30.841465000000003 | 75.40879 | 2021-07-04 04:21:38 | Punjab, India | ||
2021-07-02 | India | Punjab | 596094 | 16086 | 577256 | 2752 | 30.841465000000003 | 75.40879 | 2021-07-03 04:21:37 | Punjab, India | ||
2021-07-01 | India | Punjab | 595899 | 16072 | 576866 | 2961 | 30.841465000000003 | 75.40879 | 2021-07-02 04:21:47 | Punjab, India | ||
2021-06-30 | India | Punjab | 595609 | 16052 | 576423 | 3134 | 30.841465000000003 | 75.40879 | 2021-07-01 04:21:19 | Punjab, India | ||
2021-06-29 | India | Punjab | 595351 | 16033 | 575971 | 3347 | 30.841465000000003 | 75.40879 | 2021-06-30 04:21:41 | Punjab, India | ||
2021-06-28 | India | Punjab | 595136 | 16011 | 575486 | 3639 | 30.841465000000003 | 75.40879 | 2021-06-29 04:21:28 | Punjab, India | ||
2021-06-27 | India | Punjab | 594883 | 15991 | 574872 | 4020 | 30.841465000000003 | 75.40879 | 2021-06-28 04:21:29 | Punjab, India | ||
2021-06-26 | India | Punjab | 594586 | 15979 | 574231 | 4376 | 30.841465000000003 | 75.40879 | 2021-06-27 04:21:39 | Punjab, India | ||
2021-06-25 | India | Punjab | 594279 | 15956 | 573491 | 4832 | 30.841465000000003 | 75.40879 | 2021-06-26 04:21:43 | Punjab, India | ||
2021-06-24 | India | Punjab | 593941 | 15944 | 572723 | 5274 | 30.841465000000003 | 75.40879 | 2021-06-25 04:21:33 | Punjab, India | ||
2021-06-23 | India | Punjab | 593572 | 15923 | 572008 | 5641 | 30.841465000000003 | 75.40879 | 2021-06-24 04:21:55 | Punjab, India | ||
2021-06-22 | India | Punjab | 593063 | 15888 | 571207 | 5968 | 30.841465000000003 | 75.40879 | 2021-06-23 04:21:46 | Punjab, India | ||
2021-06-21 | India | Punjab | 592658 | 15854 | 570327 | 6477 | 30.841465000000003 | 75.40879 | 2021-06-22 04:21:34 | Punjab, India | ||
2021-06-20 | India | Punjab | 592303 | 15826 | 569056 | 7421 | 30.841465000000003 | 75.40879 | 2021-06-21 04:21:41 | Punjab, India | ||
2021-06-19 | India | Punjab | 591762 | 15802 | 567883 | 8077 | 30.841465000000003 | 75.40879 | 2021-06-20 04:21:48 | Punjab, India | ||
2021-06-18 | India | Punjab | 591168 | 15771 | 566568 | 8829 | 30.841465000000003 | 75.40879 | 2021-06-19 04:22:33 | Punjab, India | ||
2021-06-17 | India | Punjab | 590556 | 15738 | 565339 | 9479 | 30.841465000000003 | 75.40879 | 2021-06-18 04:22:16 | Punjab, India | ||
2021-06-16 | India | Punjab | 589828 | 15698 | 564084 | 10046 | 30.841465000000003 | 75.40879 | 2021-06-17 04:22:36 | Punjab, India | ||
2021-06-15 | India | Punjab | 589153 | 15650 | 562701 | 10802 | 30.841465000000003 | 75.40879 | 2021-06-16 04:22:32 | Punjab, India | ||
2021-06-14 | India | Punjab | 588525 | 15602 | 561010 | 11913 | 30.841465000000003 | 75.40879 | 2021-06-15 04:22:22 | Punjab, India | ||
2021-06-13 | India | Punjab | 587903 | 15562 | 559360 | 12981 | 30.841465000000003 | 75.40879 | 2021-06-14 04:22:46 | Punjab, India | ||
2021-06-12 | India | Punjab | 586947 | 15503 | 557380 | 14064 | 30.841465000000003 | 75.40879 | 2021-06-13 04:22:44 | Punjab, India | ||
2021-06-11 | India | Punjab | 585986 | 15435 | 555245 | 15306 | 30.841465000000003 | 75.40879 | 2021-06-12 04:22:22 | Punjab, India | ||
2021-06-10 | India | Punjab | 584785 | 15367 | 553174 | 16244 | 30.841465000000003 | 75.40879 | 2021-06-11 04:23:20 | Punjab, India | ||
2021-06-09 | India | Punjab | 583474 | 15293 | 550837 | 17344 | 30.841465000000003 | 75.40879 | 2021-06-10 04:23:17 | Punjab, India | ||
2021-06-08 | India | Punjab | 582081 | 15219 | 548316 | 18546 | 30.841465000000003 | 75.40879 | 2021-06-09 04:23:31 | Punjab, India | ||
2021-06-07 | India | Punjab | 580829 | 15160 | 545674 | 19995 | 30.841465000000003 | 75.40879 | 2021-06-08 04:22:35 | Punjab, India | ||
2021-06-06 | India | Punjab | 579560 | 15076 | 542324 | 22160 | 30.841465000000003 | 75.40879 | 2021-06-07 04:22:51 | Punjab, India | ||
2021-06-05 | India | Punjab | 577997 | 15009 | 538534 | 24454 | 30.841465000000003 | 75.40879 | 2021-06-06 04:24:03 | Punjab, India | ||
2021-06-04 | India | Punjab | 576119 | 14927 | 534915 | 26277 | 30.841465000000003 | 75.40879 | 2021-06-05 04:23:03 | Punjab, India | ||
2021-06-03 | India | Punjab | 574114 | 14840 | 530601 | 28673 | 30.841465000000003 | 75.40879 | 2021-06-04 04:23:37 | Punjab, India | ||
2021-06-02 | India | Punjab | 571970 | 14748 | 526089 | 31133 | 30.841465000000003 | 75.40879 | 2021-06-03 04:23:32 | Punjab, India | ||
2021-06-01 | India | Punjab | 569756 | 14649 | 521663 | 33444 | 30.841465000000003 | 75.40879 | 2021-06-02 04:24:34 | Punjab, India | ||
2021-05-31 | India | Punjab | 567607 | 14550 | 516624 | 36433 | 30.841465000000003 | 75.40879 | 2021-06-01 04:23:09 | Punjab, India | ||
2021-05-30 | India | Punjab | 565415 | 14432 | 511720 | 39263 | 30.841465000000003 | 75.40879 | 2021-05-31 03:08:59 | Punjab, India | ||
2021-05-29 | India | Punjab | 562831 | 14305 | 506349 | 42177 | 30.841465000000003 | 75.40879 | 2021-05-30 04:20:55 | Punjab, India | ||
2021-05-28 | India | Punjab | 559795 | 14180 | 500651 | 44964 | 30.841465000000003 | 75.40879 | 2021-05-29 04:20:41 | Punjab, India | ||
2021-05-27 | India | Punjab | 556089 | 14004 | 493854 | 48231 | 30.841465000000003 | 75.40879 | 2021-05-28 04:20:36 | Punjab, India | ||
2021-05-26 | India | Punjab | 552235 | 13827 | 487859 | 50549 | 30.841465000000003 | 75.40879 | 2021-05-27 04:20:59 | Punjab, India | ||
2021-05-25 | India | Punjab | 548231 | 13642 | 481462 | 53127 | 30.841465000000003 | 75.40879 | 2021-05-26 04:20:35 | Punjab, India | ||
2021-05-24 | India | Punjab | 543475 | 13468 | 475011 | 54996 | 30.841465000000003 | 75.40879 | 2021-05-25 04:21:08 | Punjab, India | ||
2021-05-23 | India | Punjab | 538994 | 13281 | 468208 | 57505 | 30.841465000000003 | 75.40879 | 2021-05-24 04:20:53 | Punjab, India | ||
2021-05-22 | India | Punjab | 533973 | 13089 | 459681 | 61203 | 30.841465000000003 | 75.40879 | 2021-05-23 04:20:51 | Punjab, India | ||
2021-05-21 | India | Punjab | 528676 | 12888 | 452318 | 63470 | 30.841465000000003 | 75.40879 | 2021-05-22 04:20:45 | Punjab, India | ||
2021-05-20 | India | Punjab | 523423 | 12716 | 443666 | 67041 | 30.841465000000003 | 75.40879 | 2021-05-21 04:20:43 | Punjab, India | ||
2021-05-19 | India | Punjab | 517954 | 12525 | 434930 | 70499 | 30.841465000000003 | 75.40879 | 2021-05-20 04:21:05 | Punjab, India | ||
2021-05-18 | India | Punjab | 511652 | 12317 | 427058 | 72277 | 30.841465000000003 | 75.40879 | 2021-05-19 04:20:42 | Punjab, India | ||
2021-05-17 | India | Punjab | 504586 | 12086 | 418884 | 73616 | 30.841465000000003 | 75.40879 | 2021-05-18 04:20:33 | Punjab, India | ||
2021-05-16 | India | Punjab | 497705 | 11895 | 410332 | 75478 | 30.841465000000003 | 75.40879 | 2021-05-17 04:20:34 | Punjab, India | ||
2021-05-15 | India | Punjab | 490755 | 11693 | 401273 | 77789 | 30.841465000000003 | 75.40879 | 2021-05-16 04:20:49 | Punjab, India | ||
2021-05-14 | India | Punjab | 483984 | 11477 | 393148 | 79359 | 30.841465000000003 | 75.40879 | 2021-05-15 04:20:58 | Punjab, India | ||
2021-05-13 | India | Punjab | 475949 | 11297 | 384702 | 79950 | 30.841465000000003 | 75.40879 | 2021-05-14 04:20:41 | Punjab, India | ||
2021-05-12 | India | Punjab | 467539 | 11111 | 376465 | 79963 | 30.841465000000003 | 75.40879 | 2021-05-13 04:20:51 | Punjab, India | ||
2021-05-11 | India | Punjab | 459268 | 10918 | 371494 | 76856 | 30.841465000000003 | 75.40879 | 2021-05-12 04:21:29 | Punjab, India | ||
2021-05-10 | India | Punjab | 450674 | 10704 | 364170 | 75800 | 30.841465000000003 | 75.40879 | 2021-05-11 04:20:41 | Punjab, India | ||
2021-05-09 | India | Punjab | 442125 | 10506 | 357276 | 74343 | 30.841465000000003 | 75.40879 | 2021-05-10 04:20:38 | Punjab, India | ||
2021-05-08 | India | Punjab | 433689 | 10315 | 351426 | 71948 | 30.841465000000003 | 75.40879 | 2021-05-09 04:20:35 | Punjab, India | ||
2021-05-07 | India | Punjab | 424647 | 10144 | 344779 | 69724 | 30.841465000000003 | 75.40879 | 2021-05-08 04:21:04 | Punjab, India | ||
2021-05-06 | India | Punjab | 416350 | 9979 | 339803 | 66568 | 30.841465000000003 | 75.40879 | 2021-05-07 04:20:40 | Punjab, India | ||
2021-05-05 | India | Punjab | 407509 | 9825 | 334677 | 63007 | 30.841465000000003 | 75.40879 | 2021-05-06 04:20:38 | Punjab, India | ||
2021-05-04 | India | Punjab | 399556 | 9645 | 327976 | 61935 | 30.841465000000003 | 75.40879 | 2021-05-05 04:20:43 | Punjab, India | ||
2021-05-03 | India | Punjab | 392042 | 9472 | 321861 | 60709 | 30.841465000000003 | 75.40879 | 2021-05-04 04:20:34 | Punjab, India | ||
2021-05-02 | India | Punjab | 385270 | 9317 | 315845 | 60108 | 30.841465000000003 | 75.40879 | 2021-05-03 04:20:39 | Punjab, India | ||
2021-05-01 | India | Punjab | 377990 | 9160 | 310601 | 58229 | 30.841465000000003 | 75.40879 | 2021-05-02 04:20:48 | Punjab, India | ||
2021-04-30 | India | Punjab | 370973 | 9022 | 306153 | 55798 | 30.841465000000003 | 75.40879 | 2021-05-01 04:20:47 | Punjab, India | ||
2021-04-29 | India | Punjab | 364910 | 8909 | 301047 | 54954 | 30.841465000000003 | 75.40879 | 2021-04-30 04:21:03 | Punjab, India | ||
2021-04-28 | India | Punjab | 358186 | 8772 | 295988 | 53426 | 30.841465000000003 | 75.40879 | 2021-04-29 04:20:55 | Punjab, India | ||
2021-04-27 | India | Punjab | 351282 | 8630 | 290716 | 51936 | 30.841465000000003 | 75.40879 | 2021-04-28 04:20:32 | Punjab, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;