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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3254110 | 3254110 | 2021-03-02 | India | Punjab | 183538 | 5860 | 172480 | 5198 | 30.841465000000003 | 75.40879 | 2021-03-03 05:23:28 | Punjab, India | ||
998402 | 998402 | 2021-03-01 | India | Punjab | 182809 | 5850 | 172106 | 4853 | 30.841465000000003 | 75.40879 | 2021-03-02 05:23:30 | Punjab, India | ||
2367460 | 2367460 | 2021-02-28 | India | Punjab | 182176 | 5832 | 171712 | 4632 | 30.841465000000003 | 75.40879 | 2021-03-01 05:23:01 | Punjab, India | ||
3065962 | 3065962 | 2021-02-27 | India | Punjab | 181597 | 5825 | 171336 | 4436 | 30.841465000000003 | 75.40879 | 2021-02-28 05:22:20 | Punjab, India | ||
2183546 | 2183546 | 2021-02-26 | India | Punjab | 181004 | 5814 | 170968 | 4222 | 30.841465000000003 | 75.40879 | 2021-02-27 05:22:28 | Punjab, India | ||
1857968 | 1857968 | 2021-02-25 | India | Punjab | 180382 | 5799 | 170713 | 3870 | 30.841465000000003 | 75.40879 | 2021-02-26 05:22:40 | Punjab, India | ||
280146 | 280146 | 2021-02-24 | India | Punjab | 179819 | 5786 | 170435 | 3598 | 30.841465000000003 | 75.40879 | 2021-02-25 05:24:57 | Punjab, India | ||
1936414 | 1936414 | 2021-02-23 | India | Punjab | 179261 | 5779 | 170187 | 3295 | 30.841465000000003 | 75.40879 | 2021-02-24 05:29:16 | Punjab, India | ||
530669 | 530669 | 2021-02-22 | India | Punjab | 178847 | 5769 | 169911 | 3167 | 30.841465000000003 | 75.40879 | 2021-02-23 05:23:41 | Punjab, India | ||
182003 | 182003 | 2021-02-21 | India | Punjab | 178459 | 5754 | 169686 | 3019 | 30.841465000000003 | 75.40879 | 2021-02-22 05:24:21 | Punjab, India | ||
742277 | 742277 | 2021-02-20 | India | Punjab | 178111 | 5748 | 169480 | 2883 | 30.841465000000003 | 75.40879 | 2021-02-21 05:24:33 | Punjab, India | ||
471375 | 471375 | 2021-02-19 | India | Punjab | 177759 | 5740 | 169216 | 2803 | 30.841465000000003 | 75.40879 | 2021-02-20 05:22:51 | Punjab, India | ||
1153084 | 1153084 | 2021-02-18 | India | Punjab | 177376 | 5732 | 169002 | 2642 | 30.841465000000003 | 75.40879 | 2021-02-19 05:24:16 | Punjab, India | ||
3601004 | 3601004 | 2021-02-17 | India | Punjab | 177101 | 5722 | 168833 | 2546 | 30.841465000000003 | 75.40879 | 2021-02-18 05:22:58 | Punjab, India | ||
3050139 | 3050139 | 2021-02-16 | India | Punjab | 176767 | 5712 | 168654 | 2401 | 30.841465000000003 | 75.40879 | 2021-02-17 05:23:10 | Punjab, India | ||
1338238 | 1338238 | 2021-02-15 | India | Punjab | 176520 | 5707 | 168456 | 2357 | 30.841465000000003 | 75.40879 | 2021-02-16 05:24:38 | Punjab, India | ||
2283389 | 2283389 | 2021-02-14 | India | Punjab | 176296 | 5697 | 168239 | 2360 | 30.841465000000003 | 75.40879 | 2021-02-15 05:24:49 | Punjab, India | ||
2677789 | 2677789 | 2021-02-13 | India | Punjab | 176064 | 5694 | 168035 | 2335 | 30.841465000000003 | 75.40879 | 2021-02-14 05:23:43 | Punjab, India | ||
3539422 | 3539422 | 2021-02-12 | India | Punjab | 175804 | 5690 | 167814 | 2300 | 30.841465000000003 | 75.40879 | 2021-02-13 05:22:12 | Punjab, India | ||
2637685 | 2637685 | 2021-02-11 | India | Punjab | 175558 | 5682 | 167652 | 2224 | 30.841465000000003 | 75.40879 | 2021-02-12 05:23:29 | Punjab, India | ||
3978540 | 3978540 | 2021-02-10 | India | Punjab | 175252 | 5675 | 167465 | 2112 | 30.841465000000003 | 75.40879 | 2021-02-11 05:23:55 | Punjab, India | ||
1527860 | 1527860 | 2021-02-09 | India | Punjab | 175023 | 5661 | 167285 | 2077 | 30.841465000000003 | 75.40879 | 2021-02-10 05:22:41 | Punjab, India | ||
613651 | 613651 | 2021-02-08 | India | Punjab | 174838 | 5653 | 167073 | 2112 | 30.841465000000003 | 75.40879 | 2021-02-09 05:23:30 | Punjab, India | ||
1672420 | 1672420 | 2021-02-07 | India | Punjab | 174646 | 5642 | 166828 | 2176 | 30.841465000000003 | 75.40879 | 2021-02-08 05:22:39 | Punjab, India | ||
974881 | 974881 | 2021-02-06 | India | Punjab | 174439 | 5640 | 166643 | 2156 | 30.841465000000003 | 75.40879 | 2021-02-07 05:23:00 | Punjab, India | ||
1588139 | 1588139 | 2021-02-05 | India | Punjab | 174256 | 5635 | 166477 | 2144 | 30.841465000000003 | 75.40879 | 2021-02-06 05:23:55 | Punjab, India | ||
790346 | 790346 | 2021-02-04 | India | Punjab | 174057 | 5635 | 166263 | 2159 | 30.841465000000003 | 75.40879 | 2021-02-05 05:22:38 | Punjab, India | ||
340238 | 340238 | 2021-02-03 | India | Punjab | 173861 | 5628 | 166103 | 2130 | 30.841465000000003 | 75.40879 | 2021-02-04 05:22:26 | Punjab, India | ||
1684464 | 1684464 | 2021-02-02 | India | Punjab | 173674 | 5628 | 165924 | 2122 | 30.841465000000003 | 75.40879 | 2021-02-03 05:22:52 | Punjab, India | ||
1676434 | 1676434 | 2021-02-01 | India | Punjab | 173470 | 5616 | 165753 | 2101 | 30.841465000000003 | 75.40879 | 2021-02-02 05:22:49 | Punjab, India | ||
1459722 | 1459722 | 2021-01-31 | India | Punjab | 173276 | 5615 | 165533 | 2128 | 30.841465000000003 | 75.40879 | 2021-02-01 05:22:53 | Punjab, India | ||
2211630 | 2211630 | 2021-01-30 | India | Punjab | 173084 | 5609 | 165291 | 2184 | 30.841465000000003 | 75.40879 | 2021-01-31 05:22:42 | Punjab, India | ||
1897117 | 1897117 | 2021-01-29 | India | Punjab | 172860 | 5601 | 165145 | 2114 | 30.841465000000003 | 75.40879 | 2021-01-30 05:22:49 | Punjab, India | ||
2481933 | 2481933 | 2021-01-28 | India | Punjab | 172606 | 5590 | 164937 | 2079 | 30.841465000000003 | 75.40879 | 2021-01-29 05:22:23 | Punjab, India | ||
3153568 | 3153568 | 2021-01-27 | India | Punjab | 172406 | 5581 | 164745 | 2080 | 30.841465000000003 | 75.40879 | 2021-01-28 05:22:24 | Punjab, India | ||
12303 | 12303 | 2021-01-26 | India | Punjab | 172218 | 5571 | 164541 | 2106 | 30.841465000000003 | 75.40879 | 2021-01-27 05:23:41 | Punjab, India | ||
2567627 | 2567627 | 2021-01-25 | India | Punjab | 172089 | 5560 | 164377 | 2152 | 30.841465000000003 | 75.40879 | 2021-01-26 05:22:02 | Punjab, India | ||
1759259 | 1759259 | 2021-01-24 | India | Punjab | 171930 | 5555 | 164119 | 2256 | 30.841465000000003 | 75.40879 | 2021-01-25 05:22:16 | Punjab, India | ||
2426866 | 2426866 | 2021-01-23 | India | Punjab | 171733 | 5553 | 163887 | 2293 | 30.841465000000003 | 75.40879 | 2021-01-24 05:22:35 | Punjab, India | ||
2466768 | 2466768 | 2021-01-22 | India | Punjab | 171522 | 5543 | 163655 | 2324 | 30.841465000000003 | 75.40879 | 2021-01-23 05:22:03 | Punjab, India | ||
435319 | 435319 | 2021-01-21 | India | Punjab | 171316 | 5535 | 163438 | 2343 | 30.841465000000003 | 75.40879 | 2021-01-22 05:22:10 | Punjab, India | ||
1094051 | 1094051 | 2021-01-20 | India | Punjab | 171136 | 5520 | 163211 | 2405 | 30.841465000000003 | 75.40879 | 2021-01-21 05:22:01 | Punjab, India | ||
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 |
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]);