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
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-11-12 | India | Punjab | 602733 | 16571 | 0 | 30.841465000000003 | 75.40879 | 2021-11-13 04:21:38 | Punjab, India | |||
2022-12-04 | India | Punjab | 785364 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-05 04:20:58 | Punjab, India | |||
2021-11-20 | India | Punjab | 602956 | 16584 | 0 | 30.841465000000003 | 75.40879 | 2021-11-21 04:22:13 | Punjab, India | |||
2021-12-27 | India | Punjab | 604279 | 16640 | 0 | 30.841465000000003 | 75.40879 | 2021-12-28 04:21:47 | Punjab, India | |||
2022-04-23 | India | Punjab | 759401 | 17744 | 0 | 30.841465000000003 | 75.40879 | 2022-04-24 04:20:56 | Punjab, India | |||
2021-11-26 | India | Punjab | 603173 | 16593 | 0 | 30.841465000000003 | 75.40879 | 2021-11-27 04:22:45 | Punjab, India | |||
2021-10-23 | India | Punjab | 602189 | 16551 | 0 | 30.841465000000003 | 75.40879 | 2021-10-24 04:21:22 | Punjab, India | |||
2021-12-13 | India | Punjab | 603761 | 16620 | 0 | 30.841465000000003 | 75.40879 | 2021-12-14 04:22:38 | Punjab, India | |||
2022-10-24 | India | Punjab | 785080 | 17920 | 0 | 30.841465 | 75.40879 | 2022-10-25 04:21:53 | Punjab, India | |||
2021-12-22 | India | Punjab | 604058 | 16635 | 0 | 30.841465000000003 | 75.40879 | 2021-12-23 04:21:21 | Punjab, India | |||
2021-09-20 | India | Punjab | 601323 | 16499 | 0 | 30.841465000000003 | 75.40879 | 2021-09-21 04:21:26 | Punjab, India | |||
2022-12-02 | India | Punjab | 785364 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-03 04:21:02 | Punjab, India | |||
2022-11-02 | India | Punjab | 783981 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-03 04:22:05 | Punjab, India | |||
2022-09-30 | India | Punjab | 784586 | 17916 | 0 | 30.841465 | 75.40879 | 2022-10-01 04:23:01 | Punjab, India | |||
2022-12-11 | India | Punjab | 785371 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-12 04:21:01 | Punjab, India | |||
2022-03-27 | India | Punjab | 759048 | 17740 | 0 | 30.841465000000003 | 75.40879 | 2022-03-28 04:20:33 | Punjab, India | |||
2022-08-05 | India | Punjab | 776246 | 17827 | 0 | 30.841465 | 75.40879 | 2022-08-06 04:20:56 | Punjab, India | |||
2022-07-24 | India | Punjab | 770654 | 17804 | 0 | 30.841465 | 75.40879 | 2022-07-25 04:20:51 | Punjab, India | |||
2022-07-22 | India | Punjab | 769781 | 17800 | 0 | 30.841465 | 75.40879 | 2022-07-23 04:20:53 | Punjab, India | |||
2021-11-24 | India | Punjab | 603095 | 16588 | 0 | 30.841465000000003 | 75.40879 | 2021-11-25 04:22:33 | Punjab, India | |||
2022-10-29 | India | Punjab | 785140 | 17920 | 0 | 30.841465 | 75.40879 | 2022-10-30 04:22:14 | Punjab, India | |||
2022-03-08 | India | Punjab | 758517 | 17722 | 0 | 30.841465000000003 | 75.40879 | 2022-03-09 04:20:59 | Punjab, India | |||
2021-10-16 | India | Punjab | 602008 | 16541 | 0 | 30.841465000000003 | 75.40879 | 2021-10-17 04:21:29 | Punjab, India | |||
2022-06-25 | India | Punjab | 762041 | 17764 | 0 | 30.841465 | 75.40879 | 2022-06-26 04:21:02 | Punjab, India | |||
2022-02-28 | India | Punjab | 758091 | 17706 | 0 | 30.841465000000003 | 75.40879 | 2022-03-01 04:21:09 | Punjab, India | |||
2022-06-14 | India | Punjab | 760833 | 17756 | 0 | 30.841465 | 75.40879 | 2022-06-15 04:20:54 | Punjab, India | |||
2022-03-12 | India | Punjab | 758673 | 17723 | 0 | 30.841465000000003 | 75.40879 | 2022-03-13 04:20:49 | Punjab, India | |||
2022-07-19 | India | Punjab | 766561 | 17796 | 0 | 30.841465 | 75.40879 | 2022-07-20 04:20:59 | Punjab, India | |||
2022-09-09 | India | Punjab | 783815 | 17905 | 0 | 30.841465 | 75.40879 | 2022-09-10 04:21:10 | Punjab, India | |||
2022-06-01 | India | Punjab | 760370 | 17752 | 0 | 30.841465 | 75.40879 | 2022-06-02 05:20:39 | Punjab, India | |||
2022-02-01 | India | Punjab | 745129 | 17292 | 0 | 30.841465000000003 | 75.40879 | 2022-02-02 04:21:09 | Punjab, India | |||
2021-10-04 | India | Punjab | 601739 | 16521 | 0 | 30.841465000000003 | 75.40879 | 2021-10-05 04:21:27 | Punjab, India | |||
2022-08-16 | India | Punjab | 779835 | 17865 | 0 | 30.841465 | 75.40879 | 2022-08-17 04:20:59 | Punjab, India | |||
2021-11-21 | India | Punjab | 602980 | 16584 | 0 | 30.841465000000003 | 75.40879 | 2021-11-22 04:22:20 | Punjab, India | |||
2022-12-24 | India | Punjab | 785404 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-25 04:21:04 | Punjab, India | |||
2022-11-04 | India | Punjab | 785227 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-05 04:21:52 | Punjab, India | |||
2021-12-06 | India | Punjab | 603509 | 16611 | 0 | 30.841465000000003 | 75.40879 | 2021-12-07 04:22:34 | Punjab, India | |||
2022-11-06 | India | Punjab | 785237 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-07 04:21:26 | Punjab, India | |||
2022-02-23 | India | Punjab | 757635 | 17692 | 0 | 30.841465000000003 | 75.40879 | 2022-02-24 04:21:14 | Punjab, India | |||
2022-07-28 | India | Punjab | 771997 | 17807 | 0 | 30.841465 | 75.40879 | 2022-07-29 04:20:45 | Punjab, India | |||
2022-08-07 | India | Punjab | 776664 | 17828 | 0 | 30.841465 | 75.40879 | 2022-08-08 04:21:08 | Punjab, India | |||
2022-12-28 | India | Punjab | 785429 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-29 04:21:01 | Punjab, India | |||
2021-12-09 | India | Punjab | 603638 | 16616 | 0 | 30.841465000000003 | 75.40879 | 2021-12-10 04:22:28 | Punjab, India | |||
2022-08-09 | India | Punjab | 777764 | 17839 | 0 | 30.841465 | 75.40879 | 2022-08-10 04:20:57 | Punjab, India | |||
2022-08-03 | India | Punjab | 775237 | 17823 | 0 | 30.841465 | 75.40879 | 2022-08-04 04:20:58 | Punjab, India | |||
2022-05-21 | India | Punjab | 760180 | 17751 | 0 | 30.841465 | 75.40879 | 2022-05-22 04:20:52 | Punjab, India | |||
2022-01-11 | India | Punjab | 625347 | 16683 | 0 | 30.841465000000003 | 75.40879 | 2022-01-12 04:21:44 | Punjab, India | |||
2021-08-06 | India | Punjab | 599365 | 16312 | 0 | 30.841465000000003 | 75.40879 | 2021-08-07 04:21:30 | Punjab, India | |||
2022-01-23 | India | Punjab | 713445 | 16978 | 0 | 30.841465000000003 | 75.40879 | 2022-01-24 04:21:12 | Punjab, India | |||
2021-12-01 | India | Punjab | 603320 | 16605 | 0 | 30.841465000000003 | 75.40879 | 2021-12-02 04:22:37 | Punjab, India | |||
2022-12-12 | India | Punjab | 785373 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-13 04:21:01 | Punjab, India | |||
2022-04-29 | India | Punjab | 759565 | 17748 | 0 | 30.841465 | 75.40879 | 2022-04-30 04:21:05 | Punjab, India | |||
2022-08-18 | India | Punjab | 780518 | 17872 | 0 | 30.841465 | 75.40879 | 2022-08-19 04:20:54 | Punjab, India | |||
2022-05-20 | India | Punjab | 760167 | 17751 | 0 | 30.841465 | 75.40879 | 2022-05-21 04:20:58 | Punjab, India | |||
2022-05-18 | India | Punjab | 760123 | 17751 | 0 | 30.841465 | 75.40879 | 2022-05-19 04:20:54 | Punjab, India | |||
2022-07-06 | India | Punjab | 763875 | 17781 | 0 | 30.841465 | 75.40879 | 2022-07-07 04:20:55 | Punjab, India | |||
2022-07-11 | India | Punjab | 764781 | 17785 | 0 | 30.841465 | 75.40879 | 2022-07-12 04:20:51 | Punjab, India | |||
2022-01-08 | India | Punjab | 617536 | 16665 | 0 | 30.841465000000003 | 75.40879 | 2022-01-09 04:21:46 | Punjab, India | |||
2022-04-14 | India | Punjab | 759234 | 17743 | 0 | 30.841465000000003 | 75.40879 | 2022-04-15 04:20:57 | Punjab, India | |||
2022-01-24 | India | Punjab | 719142 | 17023 | 0 | 30.841465000000003 | 75.40879 | 2022-01-25 04:21:05 | Punjab, India | |||
2021-11-28 | India | Punjab | 603240 | 16596 | 0 | 30.841465000000003 | 75.40879 | 2021-11-29 04:22:30 | Punjab, India | |||
2021-09-27 | India | Punjab | 601538 | 16507 | 0 | 30.841465000000003 | 75.40879 | 2021-09-28 04:21:28 | Punjab, India | |||
2022-11-28 | India | Punjab | 785358 | 19289 | 0 | 30.841465 | 75.40879 | 2022-11-29 04:21:05 | Punjab, India | |||
2022-08-23 | India | Punjab | 781724 | 17886 | 0 | 30.841465 | 75.40879 | 2022-08-24 04:20:46 | Punjab, India | |||
2021-12-20 | India | Punjab | 603986 | 16630 | 0 | 30.841465000000003 | 75.40879 | 2021-12-21 03:21:27 | Punjab, India | |||
2021-12-18 | India | Punjab | 603892 | 16626 | 0 | 30.841465000000003 | 75.40879 | 2021-12-19 04:21:11 | Punjab, India | |||
2021-09-09 | India | Punjab | 600940 | 16451 | 0 | 30.841465000000003 | 75.40879 | 2021-09-10 04:21:20 | Punjab, India | |||
2021-10-03 | India | Punjab | 601722 | 16520 | 0 | 30.841465000000003 | 75.40879 | 2021-10-04 04:21:31 | Punjab, India | |||
2022-01-05 | India | Punjab | 608723 | 16657 | 0 | 30.841465000000003 | 75.40879 | 2022-01-06 04:22:09 | Punjab, India | |||
2022-01-04 | India | Punjab | 606927 | 16653 | 0 | 30.841465000000003 | 75.40879 | 2022-01-05 04:21:59 | Punjab, India | |||
2022-02-05 | India | Punjab | 751246 | 17408 | 0 | 30.841465000000003 | 75.40879 | 2022-02-06 04:21:00 | Punjab, India | |||
2022-02-17 | India | Punjab | 756725 | 17642 | 0 | 30.841465000000003 | 75.40879 | 2022-02-18 04:21:04 | Punjab, India | |||
2022-05-27 | India | Punjab | 760285 | 17752 | 0 | 30.841465 | 75.40879 | 2022-05-28 04:21:07 | Punjab, India | |||
2022-01-26 | India | Punjab | 728042 | 17081 | 0 | 30.841465000000003 | 75.40879 | 2022-01-27 04:21:19 | Punjab, India | |||
2021-11-14 | India | Punjab | 602795 | 16572 | 0 | 30.841465000000003 | 75.40879 | 2021-11-15 04:21:36 | Punjab, India | |||
2022-04-26 | India | Punjab | 759476 | 17748 | 0 | 30.841465000000003 | 75.40879 | 2022-04-27 04:20:52 | Punjab, India | |||
2021-09-28 | India | Punjab | 601578 | 16509 | 0 | 30.841465000000003 | 75.40879 | 2021-09-29 04:21:45 | Punjab, India | |||
2021-08-11 | India | Punjab | 599678 | 16325 | 0 | 30.841465000000003 | 75.40879 | 2021-08-12 04:21:25 | Punjab, India | |||
2022-08-10 | India | Punjab | 778196 | 17842 | 0 | 30.841465 | 75.40879 | 2022-08-11 04:20:49 | Punjab, India | |||
2021-11-27 | India | Punjab | 603190 | 16593 | 0 | 30.841465000000003 | 75.40879 | 2021-11-28 04:22:43 | Punjab, India | |||
2022-02-08 | India | Punjab | 753124 | 17495 | 0 | 30.841465000000003 | 75.40879 | 2022-02-09 04:21:04 | Punjab, India | |||
2022-10-28 | India | Punjab | 785140 | 17920 | 0 | 30.841465 | 75.40879 | 2022-10-29 04:21:13 | Punjab, India | |||
2022-09-21 | India | Punjab | 784347 | 17911 | 0 | 30.841465 | 75.40879 | 2022-09-22 04:22:56 | Punjab, India | |||
2021-09-15 | India | Punjab | 601150 | 16464 | 0 | 30.841465000000003 | 75.40879 | 2021-09-16 04:22:19 | Punjab, India | |||
2021-09-13 | India | Punjab | 601072 | 16457 | 0 | 30.841465000000003 | 75.40879 | 2021-09-14 04:21:41 | Punjab, India | |||
2022-01-07 | India | Punjab | 613976 | 16663 | 0 | 30.841465000000003 | 75.40879 | 2022-01-08 04:21:53 | Punjab, India | |||
2022-09-02 | India | Punjab | 783267 | 17901 | 0 | 30.841465 | 75.40879 | 2022-09-03 04:21:04 | Punjab, India | |||
2022-05-06 | India | Punjab | 759856 | 17751 | 0 | 30.841465 | 75.40879 | 2022-05-07 04:21:09 | Punjab, India | |||
2022-08-02 | India | Punjab | 774753 | 17820 | 0 | 30.841465 | 75.40879 | 2022-08-03 04:20:59 | Punjab, India | |||
2022-07-08 | India | Punjab | 764312 | 17784 | 0 | 30.841465 | 75.40879 | 2022-07-09 04:20:59 | Punjab, India | |||
2022-06-08 | India | Punjab | 760518 | 17754 | 0 | 30.841465 | 75.40879 | 2022-06-09 04:20:54 | Punjab, India | |||
2021-12-28 | India | Punjab | 604331 | 16642 | 0 | 30.841465000000003 | 75.40879 | 2021-12-29 03:21:43 | Punjab, India | |||
2022-03-28 | India | Punjab | 759067 | 17741 | 0 | 30.841465000000003 | 75.40879 | 2022-03-29 04:20:46 | Punjab, India | |||
2022-02-10 | India | Punjab | 754367 | 17554 | 0 | 30.841465000000003 | 75.40879 | 2022-02-11 04:21:09 | Punjab, India | |||
2022-03-24 | India | Punjab | 758991 | 17738 | 0 | 30.841465000000003 | 75.40879 | 2022-03-25 04:20:46 | Punjab, India | |||
2022-01-17 | India | Punjab | 670460 | 16790 | 0 | 30.841465000000003 | 75.40879 | 2022-01-18 04:21:04 | Punjab, India | |||
2021-08-13 | India | Punjab | 599846 | 16334 | 0 | 30.841465000000003 | 75.40879 | 2021-08-14 04:21:25 | Punjab, India | |||
2022-07-26 | India | Punjab | 771413 | 17807 | 0 | 30.841465 | 75.40879 | 2022-07-27 04:21:04 | Punjab, India | |||
2021-10-12 | India | Punjab | 601913 | 16531 | 0 | 30.841465000000003 | 75.40879 | 2021-10-13 04:20:51 | Punjab, India | |||
2022-05-16 | India | Punjab | 760091 | 17751 | 0 | 30.841465 | 75.40879 | 2022-05-17 04:20:59 | Punjab, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;