johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Punjab" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
908141 | 908141 | 2021-01-19 | India | Punjab | 170937 | 5516 | 163009 | 2412 | 30.841465000000003 | 75.40879 | 2021-01-20 05:21:54 | Punjab, India | ||
237204 | 237204 | 2021-01-18 | India | Punjab | 170729 | 5509 | 162762 | 2458 | 30.841465000000003 | 75.40879 | 2021-01-19 05:22:15 | Punjab, India | ||
3503321 | 3503321 | 2021-01-17 | India | Punjab | 170605 | 5504 | 162484 | 2617 | 30.841465000000003 | 75.40879 | 2021-01-18 05:22:34 | Punjab, India | ||
3101404 | 3101404 | 2021-01-16 | India | Punjab | 170366 | 5499 | 162289 | 2578 | 30.841465000000003 | 75.40879 | 2021-01-17 05:22:17 | Punjab, India | ||
3515366 | 3515366 | 2021-01-15 | India | Punjab | 170191 | 5485 | 161967 | 2739 | 30.841465000000003 | 75.40879 | 2021-01-16 05:22:40 | Punjab, India | ||
3879539 | 3879539 | 2021-01-14 | India | Punjab | 169950 | 5473 | 161710 | 2767 | 30.841465 | 75.40879 | 2021-01-15 17:22 | Punjab, India | ||
3308166 | 3308166 | 2021-01-13 | India | Punjab | 169737 | 5463 | 161457 | 2817 | 30.841465000000003 | 75.40879 | 2021-01-14 05:22:32 | Punjab, India | ||
774311 | 774311 | 2021-01-12 | India | Punjab | 169479 | 5456 | 161235 | 2788 | 30.841465000000003 | 75.40879 | 2021-01-13 05:22:15 | Punjab, India | ||
190032 | 190032 | 2021-01-11 | India | Punjab | 169225 | 5447 | 160920 | 2858 | 30.841465000000003 | 75.40879 | 2021-01-12 05:22:15 | Punjab, India | ||
2625835 | 2625835 | 2021-01-10 | India | Punjab | 169033 | 5445 | 160655 | 2933 | 30.841465000000003 | 75.40879 | 2021-01-11 05:21:50 | Punjab, India | ||
3899923 | 3899923 | 2021-01-09 | India | Punjab | 168734 | 5439 | 160343 | 2952 | 30.841465000000003 | 75.40879 | 2021-01-10 05:22:12 | Punjab, India | ||
153946 | 153946 | 2021-01-08 | India | Punjab | 168187 | 5422 | 159790 | 2975 | 30.841465000000003 | 75.40879 | 2021-01-09 05:22:18 | Punjab, India | ||
2541370 | 2541370 | 2021-01-07 | India | Punjab | 168187 | 5422 | 159790 | 2975 | 30.841465000000003 | 75.40879 | 2021-01-08 05:22:42 | Punjab, India | ||
2864679 | 2864679 | 2021-01-06 | India | Punjab | 167910 | 5412 | 159500 | 2998 | 30.841465000000003 | 75.40879 | 2021-01-07 05:22:03 | Punjab, India | ||
3034266 | 3034266 | 2021-01-05 | India | Punjab | 167652 | 5404 | 159265 | 2983 | 30.841465000000003 | 75.40879 | 2021-01-06 05:22:16 | Punjab, India | ||
1061811 | 1061811 | 2021-01-04 | India | Punjab | 167441 | 5400 | 158972 | 3069 | 30.841465000000003 | 75.40879 | 2021-01-05 05:21:49 | Punjab, India | ||
3230414 | 3230414 | 2021-01-03 | India | Punjab | 167219 | 5376 | 158482 | 3361 | 30.841465000000003 | 75.40879 | 2021-01-04 05:22:02 | Punjab, India | ||
2227483 | 2227483 | 2021-01-02 | India | Punjab | 167012 | 5364 | 158219 | 3429 | 30.841465000000003 | 75.40879 | 2021-01-03 05:22:52 | Punjab, India | ||
1136847 | 1136847 | 2021-01-01 | India | Punjab | 166770 | 5349 | 157496 | 3925 | 30.841465000000003 | 75.40879 | 2021-01-02 05:22:33 | Punjab, India | ||
3695453 | 3695453 | 2020-12-31 | India | Punjab | 166239 | 5331 | 157043 | 3865 | 30.841465000000003 | 75.40879 | 2021-01-01 05:23:07 | Punjab, India | ||
1010268 | 1010268 | 2020-12-30 | India | Punjab | 166239 | 5331 | 157043 | 3865 | 30.841465000000003 | 75.40879 | 2020-12-31 05:22:49 | Punjab, India | ||
766283 | 766283 | 2020-12-29 | India | Punjab | 165878 | 5322 | 156719 | 3837 | 30.841465000000003 | 75.40879 | 2020-12-30 05:22:34 | Punjab, India | ||
3761547 | 3761547 | 2020-12-28 | India | Punjab | 165668 | 5312 | 156342 | 4014 | 30.841465000000003 | 75.40879 | 2020-12-29 05:22:37 | Punjab, India | ||
3777867 | 3777867 | 2020-12-27 | India | Punjab | 165405 | 5299 | 155892 | 4214 | 30.841465000000003 | 75.40879 | 2020-12-28 05:22:06 | Punjab, India | ||
2223472 | 2223472 | 2020-12-26 | India | Punjab | 165126 | 5281 | 155409 | 4436 | 30.841465000000003 | 75.40879 | 2020-12-27 05:22:55 | Punjab, India | ||
202219 | 202219 | 2020-12-25 | India | Punjab | 164821 | 5269 | 154845 | 4707 | 30.841465000000003 | 75.40879 | 2020-12-26 05:22:28 | Punjab, India | ||
3691442 | 3691442 | 2020-12-24 | India | Punjab | 164505 | 5260 | 154433 | 4812 | 30.841465000000003 | 75.40879 | 2020-12-25 05:22:48 | Punjab, India | ||
2406794 | 2406794 | 2020-12-23 | India | Punjab | 164145 | 5243 | 153964 | 4938 | 30.841465000000003 | 75.40879 | 2020-12-24 05:23:04 | Punjab, India | ||
3769840 | 3769840 | 2020-12-22 | India | Punjab | 163665 | 5230 | 153382 | 5053 | 30.841465000000003 | 75.40879 | 2020-12-23 05:22:03 | Punjab, India | ||
927656 | 927656 | 2020-12-21 | India | Punjab | 163378 | 5212 | 152758 | 5408 | 30.841465000000003 | 75.40879 | 2020-12-22 05:22:33 | Punjab, India | ||
2119677 | 2119677 | 2020-12-20 | India | Punjab | 163042 | 5201 | 152223 | 5618 | 30.841465000000003 | 75.40879 | 2020-12-21 05:27:58 | Punjab, India | ||
2931184 | 2931184 | 2020-12-19 | India | Punjab | 162705 | 5189 | 151679 | 5837 | 30.841465000000003 | 75.40879 | 2020-12-20 05:27:32 | Punjab, India | ||
1901130 | 1901130 | 2020-12-18 | India | Punjab | 162270 | 5170 | 151119 | 5981 | 30.841465000000003 | 75.40879 | 2020-12-19 05:27:52 | Punjab, India | ||
2127956 | 2127956 | 2020-12-17 | India | Punjab | 161831 | 5150 | 150636 | 6045 | 30.841465000000003 | 75.40879 | 2020-12-18 05:28:18 | Punjab, India | ||
3149556 | 3149556 | 2020-12-16 | India | Punjab | 161383 | 5135 | 150007 | 6241 | 30.841465000000003 | 75.40879 | 2020-12-17 05:28:12 | Punjab, India | ||
1034337 | 1034337 | 2020-12-15 | India | Punjab | 161053 | 5117 | 149434 | 6502 | 30.841465000000003 | 75.40879 | 2020-12-16 05:28:04 | Punjab, India | ||
1751231 | 1751231 | 2020-12-14 | India | Punjab | 160659 | 5098 | 148680 | 6881 | 30.841465000000003 | 75.40879 | 2020-12-15 05:26:38 | Punjab, India | ||
3847751 | 3847751 | 2020-12-13 | India | Punjab | 160200 | 5077 | 148047 | 7076 | 30.841465000000003 | 75.40879 | 2020-12-14 05:26:27 | Punjab, India | ||
845533 | 845533 | 2020-12-12 | India | Punjab | 159579 | 5057 | 147431 | 7091 | 30.841465000000003 | 75.40879 | 2020-12-13 05:27:20 | Punjab, India | ||
860640 | 860640 | 2020-12-11 | India | Punjab | 159099 | 5036 | 146777 | 7286 | 30.841465000000003 | 75.40879 | 2020-12-12 05:26:19 | Punjab, India | ||
1600182 | 1600182 | 2020-12-10 | India | Punjab | 158556 | 5007 | 146126 | 7423 | 30.841465000000003 | 75.40879 | 2020-12-11 05:26:59 | Punjab, India | ||
2975191 | 2975191 | 2020-12-09 | India | Punjab | 157928 | 4980 | 145623 | 7325 | 30.841465000000003 | 75.40879 | 2020-12-10 05:26:19 | Punjab, India | ||
1818751 | 1818751 | 2020-12-08 | India | Punjab | 157331 | 4964 | 145093 | 7274 | 30.841465000000003 | 75.40879 | 2020-12-09 05:28:01 | Punjab, India | ||
2347387 | 2347387 | 2020-12-07 | India | Punjab | 156839 | 4934 | 144301 | 7604 | 30.841465000000003 | 75.40879 | 2020-12-08 05:27:42 | Punjab, India | ||
1006257 | 1006257 | 2020-12-06 | India | Punjab | 156226 | 4916 | 143414 | 7896 | 30.841465000000003 | 75.40879 | 2020-12-07 05:26:14 | Punjab, India | ||
1632266 | 1632266 | 2020-12-05 | India | Punjab | 155424 | 4906 | 142791 | 7727 | 30.841465000000003 | 75.40879 | 2020-12-06 05:26:18 | Punjab, India | ||
3859794 | 3859794 | 2020-12-04 | India | Punjab | 154788 | 4882 | 142121 | 7785 | 30.841465000000003 | 75.40879 | 2020-12-05 05:27:36 | Punjab, India | ||
75052 | 75052 | 2020-12-03 | India | Punjab | 154064 | 4862 | 141478 | 7724 | 30.841465000000003 | 75.40879 | 2020-12-04 05:27:27 | Punjab, India | ||
738264 | 738264 | 2020-12-02 | India | Punjab | 153308 | 4842 | 140772 | 7694 | 30.841465000000003 | 75.40879 | 2020-12-03 05:28:22 | Punjab, India | ||
2537358 | 2537358 | 2020-12-01 | India | Punjab | 152709 | 4821 | 140254 | 7634 | 30.841465000000003 | 75.40879 | 2020-12-02 05:27:41 | Punjab, India | ||
1584127 | 1584127 | 2020-11-30 | India | Punjab | 152091 | 4807 | 139442 | 7842 | 30.841465000000003 | 75.40879 | 2020-12-01 05:26:18 | Punjab, India | ||
3566530 | 3566530 | 2020-11-29 | India | Punjab | 151538 | 4780 | 138870 | 7888 | 30.841465000000003 | 75.40879 | 2020-11-30 05:26:13 | Punjab, India | ||
2935195 | 2935195 | 2020-11-28 | India | Punjab | 150805 | 4765 | 138206 | 7834 | 30.841465000000003 | 75.40879 | 2020-11-29 05:25:55 | Punjab, India | ||
392198 | 392198 | 2020-11-27 | India | Punjab | 150086 | 4737 | 137630 | 7719 | 30.841465000000003 | 75.40879 | 2020-11-28 05:25:50 | Punjab, India | ||
923645 | 923645 | 2020-11-26 | India | Punjab | 149278 | 4710 | 137089 | 7479 | 30.841465000000003 | 75.40879 | 2020-11-27 05:26:53 | Punjab, India | ||
1972550 | 1972550 | 2020-11-25 | India | Punjab | 148435 | 4684 | 136622 | 7129 | 30.841465000000003 | 75.40879 | 2020-11-26 05:27:44 | Punjab, India | ||
1350281 | 1350281 | 2020-11-24 | India | Punjab | 147665 | 4653 | 136178 | 6834 | 30.841465000000003 | 75.40879 | 2020-11-25 05:27:20 | Punjab, India | ||
678275 | 678275 | 2020-11-23 | India | Punjab | 147057 | 4631 | 135739 | 6687 | 30.841465000000003 | 75.40879 | 2020-11-24 05:27:31 | Punjab, India | ||
3189951 | 3189951 | 2020-11-22 | India | Punjab | 146346 | 4614 | 135008 | 6724 | 30.841465000000003 | 75.40879 | 2020-11-23 05:25:26 | Punjab, India | ||
3836445 | 3836445 | 2020-11-21 | India | Punjab | 145667 | 4595 | 134511 | 6561 | 30.841465000000003 | 75.40879 | 2020-11-22 05:25:45 | Punjab, India | ||
2701473 | 2701473 | 2020-11-20 | India | Punjab | 144995 | 4572 | 133919 | 6504 | 30.841465000000003 | 75.40879 | 2020-11-21 05:25:51 | Punjab, India | ||
821533 | 821533 | 2020-11-19 | India | Punjab | 144177 | 4556 | 133427 | 6194 | 30.841465000000003 | 75.40879 | 2020-11-20 05:26:28 | Punjab, India | ||
122667 | 122667 | 2020-11-18 | India | Punjab | 143395 | 4541 | 132917 | 5937 | 30.841465000000003 | 75.40879 | 2020-11-19 05:25:23 | Punjab, India | ||
3338555 | 3338555 | 2020-11-17 | India | Punjab | 142597 | 4510 | 132266 | 5821 | 30.841465000000003 | 75.40879 | 2020-11-18 05:40:31 | Punjab, India | ||
3169600 | 3169600 | 2020-11-16 | India | Punjab | 142082 | 4480 | 132001 | 5601 | 30.841465000000003 | 75.40879 | 2020-11-17 05:25:54 | Punjab, India | ||
2880168 | 2880168 | 2020-11-15 | India | Punjab | 141658 | 4458 | 131431 | 5769 | 30.841465000000003 | 75.40879 | 2020-11-16 05:25:57 | Punjab, India | ||
2915146 | 2915146 | 2020-11-14 | India | Punjab | 140605 | 4428 | 130406 | 5771 | 30.841465000000003 | 75.40879 | 2020-11-15 05:26:53 | Punjab, India | ||
2784968 | 2784968 | 2020-11-13 | India | Punjab | 140605 | 4428 | 130406 | 5771 | 30.841465000000003 | 75.40879 | 2020-11-14 05:25:37 | Punjab, India | ||
864733 | 864733 | 2020-11-12 | India | Punjab | 139869 | 4412 | 130018 | 5439 | 30.841465000000003 | 75.40879 | 2020-11-13 05:25:30 | Punjab, India | ||
3440778 | 3440778 | 2020-11-11 | India | Punjab | 139184 | 4389 | 129549 | 5246 | 30.841465000000003 | 75.40879 | 2020-11-12 05:25:55 | Punjab, India | ||
272118 | 272118 | 2020-11-10 | India | Punjab | 138485 | 4358 | 129089 | 5038 | 30.841465000000003 | 75.40879 | 2020-11-11 05:25:30 | Punjab, India | ||
1988595 | 1988595 | 2020-11-09 | India | Punjab | 137999 | 4338 | 128727 | 4934 | 30.841465000000003 | 75.40879 | 2020-11-10 05:40:07 | Punjab, India | ||
1728447 | 1728447 | 2020-11-08 | India | Punjab | 137445 | 4318 | 128217 | 4910 | 30.841465000000003 | 75.40879 | 2020-11-09 05:25:45 | Punjab, India | ||
1543907 | 1543907 | 2020-11-07 | India | Punjab | 136958 | 4310 | 127821 | 4827 | 30.841465000000003 | 75.40879 | 2020-11-08 05:24:56 | Punjab, India | ||
376145 | 376145 | 2020-11-06 | India | Punjab | 136481 | 4295 | 127304 | 4882 | 30.841465000000003 | 75.40879 | 2020-11-07 05:24:52 | Punjab, India | ||
892083 | 892083 | 2020-11-05 | India | Punjab | 135834 | 4281 | 126932 | 4621 | 30.841465000000003 | 75.40879 | 2020-11-06 05:24:55 | Punjab, India | ||
2919145 | 2919145 | 2020-11-04 | India | Punjab | 135313 | 4259 | 126583 | 4471 | 30.841465000000003 | 75.40879 | 2020-11-05 06:05:03 | Punjab, India | ||
2497982 | 2497982 | 2020-11-03 | India | Punjab | 134786 | 4245 | 126315 | 4226 | 30.841465000000003 | 75.40879 | 2020-11-04 05:25:09 | Punjab, India | ||
3304157 | 3304157 | 2020-11-02 | India | Punjab | 134371 | 4227 | 125961 | 4183 | 30.841465000000003 | 75.40879 | 2020-11-03 06:00:16 | Punjab, India | ||
3409406 | 3409406 | 2020-11-01 | India | Punjab | 133975 | 4214 | 125566 | 4195 | 30.841465000000003 | 75.40879 | 2020-11-02 05:25:04 | Punjab, India | ||
2079895 | 2079895 | 2020-10-31 | India | Punjab | 133658 | 4203 | 125198 | 4257 | 30.841465000000003 | 75.40879 | 2020-11-01 04:36:19 | Punjab, India | ||
2243348 | 2243348 | 2020-10-30 | India | Punjab | 133158 | 4187 | 124870 | 4101 | 30.841465000000003 | 75.40879 | 2020-10-31 04:24:44 | Punjab, India | ||
210203 | 210203 | 2020-10-29 | India | Punjab | 132727 | 4168 | 124293 | 4266 | 30.841465000000003 | 75.40879 | 2020-10-30 04:24:49 | Punjab, India | ||
754265 | 754265 | 2020-10-28 | India | Punjab | 132263 | 4158 | 123866 | 4239 | 30.841465000000003 | 75.40879 | 2020-10-29 04:24:49 | Punjab, India | ||
1452550 | 1452550 | 2020-10-27 | India | Punjab | 131737 | 4138 | 123510 | 4089 | 30.841465000000003 | 75.40879 | 2020-10-28 04:24:39 | Punjab, India | ||
3480274 | 3480274 | 2020-10-26 | India | Punjab | 131391 | 4125 | 123047 | 4219 | 30.841465000000003 | 75.40879 | 2020-10-27 04:24:45 | Punjab, India | ||
8295 | 8295 | 2020-10-25 | India | Punjab | 131055 | 4117 | 122721 | 4217 | 30.841465000000003 | 75.40879 | 2020-10-26 04:25:02 | Punjab, India | ||
3651532 | 3651532 | 2020-10-24 | India | Punjab | 130640 | 4107 | 122256 | 4277 | 30.841465000000003 | 75.40879 | 2020-10-25 04:24:36 | Punjab, India | ||
1053787 | 1053787 | 2020-10-23 | India | Punjab | 130157 | 4095 | 121735 | 4327 | 30.841465000000003 | 75.40879 | 2020-10-24 04:24:46 | Punjab, India | ||
1177457 | 1177457 | 2020-10-22 | India | Punjab | 129693 | 4072 | 121155 | 4466 | 30.841465000000003 | 75.40879 | 2020-10-23 04:24:46 | Punjab, India | ||
2191562 | 2191562 | 2020-10-21 | India | Punjab | 129088 | 4060 | 120220 | 4808 | 30.841465000000003 | 75.40879 | 2020-10-22 04:24:27 | Punjab, India | ||
3990573 | 3990573 | 2020-10-20 | India | Punjab | 128590 | 4037 | 119658 | 4895 | 30.841465000000003 | 75.40879 | 2020-10-21 04:24:14 | Punjab, India | ||
1794593 | 1794593 | 2020-10-19 | India | Punjab | 128103 | 4029 | 118767 | 5307 | 30.841465000000003 | 75.40879 | 2020-10-20 04:24:22 | Punjab, India | ||
762277 | 762277 | 2020-10-18 | India | Punjab | 127630 | 4012 | 117883 | 5735 | 30.841465000000003 | 75.40879 | 2020-10-19 04:24:16 | Punjab, India | ||
1026315 | 1026315 | 2020-10-17 | India | Punjab | 127154 | 3999 | 116925 | 6230 | 30.841465000000003 | 75.40879 | 2020-10-18 04:24:25 | Punjab, India | ||
2856810 | 2856810 | 2020-10-16 | India | Punjab | 126737 | 3980 | 116165 | 6592 | 30.841465000000003 | 75.40879 | 2020-10-17 04:24:12 | Punjab, India | ||
786340 | 786340 | 2020-10-15 | India | Punjab | 126230 | 3954 | 115186 | 7090 | 30.841465000000003 | 75.40879 | 2020-10-16 04:24:01 | Punjab, India | ||
79051 | 79051 | 2020-10-14 | India | Punjab | 125760 | 3925 | 114075 | 7760 | 30.841465000000003 | 75.40879 | 2020-10-15 04:24:28 | Punjab, India | ||
3781866 | 3781866 | 2020-10-13 | India | Punjab | 125211 | 3894 | 113105 | 8212 | 30.841465000000003 | 75.40879 | 2020-10-14 04:24:05 | Punjab, India | ||
2291406 | 2291406 | 2020-10-12 | India | Punjab | 124535 | 3860 | 112099 | 8576 | 30.841465000000003 | 75.40879 | 2020-10-13 04:24:02 | Punjab, India |
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]);