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 = "Jammu and Kashmir" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190018 | 190018 | 2021-01-11 | India | Jammu and Kashmir | 122651 | 1911 | 118972 | 1768 | 33.75943 | 76.612638 | 2021-01-12 05:22:15 | Jammu and Kashmir, India | ||
2625821 | 2625821 | 2021-01-10 | India | Jammu and Kashmir | 122538 | 1910 | 118617 | 2011 | 33.75943 | 76.612638 | 2021-01-11 05:21:50 | Jammu and Kashmir, India | ||
3899909 | 3899909 | 2021-01-09 | India | Jammu and Kashmir | 122425 | 1909 | 118422 | 2094 | 33.75943 | 76.612638 | 2021-01-10 05:22:12 | Jammu and Kashmir, India | ||
153932 | 153932 | 2021-01-08 | India | Jammu and Kashmir | 122176 | 1903 | 117877 | 2396 | 33.75943 | 76.612638 | 2021-01-09 05:22:18 | Jammu and Kashmir, India | ||
2541356 | 2541356 | 2021-01-07 | India | Jammu and Kashmir | 122176 | 1903 | 117877 | 2396 | 33.75943 | 76.612638 | 2021-01-08 05:22:42 | Jammu and Kashmir, India | ||
2864665 | 2864665 | 2021-01-06 | India | Jammu and Kashmir | 122049 | 1900 | 117690 | 2459 | 33.75943 | 76.612638 | 2021-01-07 05:22:03 | Jammu and Kashmir, India | ||
3034252 | 3034252 | 2021-01-05 | India | Jammu and Kashmir | 121923 | 1897 | 117426 | 2600 | 33.75943 | 76.612638 | 2021-01-06 05:22:16 | Jammu and Kashmir, India | ||
1061797 | 1061797 | 2021-01-04 | India | Jammu and Kashmir | 121786 | 1891 | 117211 | 2684 | 33.75943 | 76.612638 | 2021-01-05 05:21:49 | Jammu and Kashmir, India | ||
3230400 | 3230400 | 2021-01-03 | India | Jammu and Kashmir | 121653 | 1886 | 116792 | 2975 | 33.75943 | 76.612638 | 2021-01-04 05:22:02 | Jammu and Kashmir, India | ||
2227469 | 2227469 | 2021-01-02 | India | Jammu and Kashmir | 121471 | 1885 | 116587 | 2999 | 33.75943 | 76.612638 | 2021-01-03 05:22:52 | Jammu and Kashmir, India | ||
1136833 | 1136833 | 2021-01-01 | India | Jammu and Kashmir | 121227 | 1884 | 116079 | 3264 | 33.75943 | 76.612638 | 2021-01-02 05:22:33 | Jammu and Kashmir, India | ||
3695439 | 3695439 | 2020-12-31 | India | Jammu and Kashmir | 120744 | 1880 | 115830 | 3034 | 33.75943 | 76.612638 | 2021-01-01 05:23:07 | Jammu and Kashmir, India | ||
1010254 | 1010254 | 2020-12-30 | India | Jammu and Kashmir | 120744 | 1880 | 115830 | 3034 | 33.75943 | 76.612638 | 2020-12-31 05:22:49 | Jammu and Kashmir, India | ||
766269 | 766269 | 2020-12-29 | India | Jammu and Kashmir | 120527 | 1879 | 115560 | 3088 | 33.75943 | 76.612638 | 2020-12-30 05:22:34 | Jammu and Kashmir, India | ||
3761533 | 3761533 | 2020-12-28 | India | Jammu and Kashmir | 120293 | 1875 | 115261 | 3157 | 33.75943 | 76.612638 | 2020-12-29 05:22:37 | Jammu and Kashmir, India | ||
3777853 | 3777853 | 2020-12-27 | India | Jammu and Kashmir | 120137 | 1867 | 114986 | 3284 | 33.75943 | 76.612638 | 2020-12-28 05:22:06 | Jammu and Kashmir, India | ||
2223458 | 2223458 | 2020-12-26 | India | Jammu and Kashmir | 119877 | 1867 | 114722 | 3288 | 33.75943 | 76.612638 | 2020-12-27 05:22:55 | Jammu and Kashmir, India | ||
202205 | 202205 | 2020-12-25 | India | Jammu and Kashmir | 119628 | 1861 | 114353 | 3414 | 33.75943 | 76.612638 | 2020-12-26 05:22:28 | Jammu and Kashmir, India | ||
3691428 | 3691428 | 2020-12-24 | India | Jammu and Kashmir | 119344 | 1860 | 113944 | 3540 | 33.75943 | 76.612638 | 2020-12-25 05:22:48 | Jammu and Kashmir, India | ||
2406780 | 2406780 | 2020-12-23 | India | Jammu and Kashmir | 119053 | 1853 | 113645 | 3555 | 33.75943 | 76.612638 | 2020-12-24 05:23:04 | Jammu and Kashmir, India | ||
3769826 | 3769826 | 2020-12-22 | India | Jammu and Kashmir | 118803 | 1850 | 113307 | 3646 | 33.75943 | 76.612638 | 2020-12-23 05:22:03 | Jammu and Kashmir, India | ||
927642 | 927642 | 2020-12-21 | India | Jammu and Kashmir | 118495 | 1844 | 113026 | 3625 | 33.75943 | 76.612638 | 2020-12-22 05:22:33 | Jammu and Kashmir, India | ||
2119663 | 2119663 | 2020-12-20 | India | Jammu and Kashmir | 118263 | 1841 | 112568 | 3854 | 33.75943 | 76.612638 | 2020-12-21 05:27:58 | Jammu and Kashmir, India | ||
2931170 | 2931170 | 2020-12-19 | India | Jammu and Kashmir | 118006 | 1837 | 112093 | 4076 | 33.75943 | 76.612638 | 2020-12-20 05:27:32 | Jammu and Kashmir, India | ||
1901116 | 1901116 | 2020-12-18 | India | Jammu and Kashmir | 117705 | 1833 | 111628 | 4244 | 33.75943 | 76.612638 | 2020-12-19 05:27:52 | Jammu and Kashmir, India | ||
2127942 | 2127942 | 2020-12-17 | India | Jammu and Kashmir | 117317 | 1826 | 111164 | 4327 | 33.75943 | 76.612638 | 2020-12-18 05:28:18 | Jammu and Kashmir, India | ||
3149542 | 3149542 | 2020-12-16 | India | Jammu and Kashmir | 116932 | 1817 | 110769 | 4346 | 33.75943 | 76.612638 | 2020-12-17 05:28:12 | Jammu and Kashmir, India | ||
1034323 | 1034323 | 2020-12-15 | India | Jammu and Kashmir | 116600 | 1812 | 110354 | 4434 | 33.75943 | 76.612638 | 2020-12-16 05:28:04 | Jammu and Kashmir, India | ||
1751217 | 1751217 | 2020-12-14 | India | Jammu and Kashmir | 116254 | 1802 | 109894 | 4558 | 33.75943 | 76.612638 | 2020-12-15 05:26:38 | Jammu and Kashmir, India | ||
3847737 | 3847737 | 2020-12-13 | India | Jammu and Kashmir | 116008 | 1799 | 109507 | 4702 | 33.75943 | 76.612638 | 2020-12-14 05:26:27 | Jammu and Kashmir, India | ||
845519 | 845519 | 2020-12-12 | India | Jammu and Kashmir | 115626 | 1793 | 109002 | 4831 | 33.75943 | 76.612638 | 2020-12-13 05:27:20 | Jammu and Kashmir, India | ||
860626 | 860626 | 2020-12-11 | India | Jammu and Kashmir | 115207 | 1786 | 108572 | 4849 | 33.75943 | 76.612638 | 2020-12-12 05:26:19 | Jammu and Kashmir, India | ||
1600168 | 1600168 | 2020-12-10 | India | Jammu and Kashmir | 114773 | 1775 | 108150 | 4848 | 33.75943 | 76.612638 | 2020-12-11 05:26:59 | Jammu and Kashmir, India | ||
2975177 | 2975177 | 2020-12-09 | India | Jammu and Kashmir | 114407 | 1767 | 107624 | 5016 | 33.75943 | 76.612638 | 2020-12-10 05:26:19 | Jammu and Kashmir, India | ||
1818737 | 1818737 | 2020-12-08 | India | Jammu and Kashmir | 114038 | 1761 | 107282 | 4995 | 33.75943 | 76.612638 | 2020-12-09 05:28:01 | Jammu and Kashmir, India | ||
2347373 | 2347373 | 2020-12-07 | India | Jammu and Kashmir | 113568 | 1755 | 106758 | 5055 | 33.75943 | 76.612638 | 2020-12-08 05:27:42 | Jammu and Kashmir, India | ||
1006243 | 1006243 | 2020-12-06 | India | Jammu and Kashmir | 113288 | 1746 | 106372 | 5170 | 33.75943 | 76.612638 | 2020-12-07 05:26:14 | Jammu and Kashmir, India | ||
1632252 | 1632252 | 2020-12-05 | India | Jammu and Kashmir | 112757 | 1742 | 106006 | 5009 | 33.75943 | 76.612638 | 2020-12-06 05:26:18 | Jammu and Kashmir, India | ||
3859780 | 3859780 | 2020-12-04 | India | Jammu and Kashmir | 112256 | 1730 | 105537 | 4989 | 33.75943 | 76.612638 | 2020-12-05 05:27:36 | Jammu and Kashmir, India | ||
75038 | 75038 | 2020-12-03 | India | Jammu and Kashmir | 111712 | 1718 | 104890 | 5104 | 33.75943 | 76.612638 | 2020-12-04 05:27:27 | Jammu and Kashmir, India | ||
738250 | 738250 | 2020-12-02 | India | Jammu and Kashmir | 111130 | 1708 | 104471 | 4951 | 33.75943 | 76.612638 | 2020-12-03 05:28:22 | Jammu and Kashmir, India | ||
2537344 | 2537344 | 2020-12-01 | India | Jammu and Kashmir | 110678 | 1702 | 104068 | 4908 | 33.75943 | 76.612638 | 2020-12-02 05:27:41 | Jammu and Kashmir, India | ||
1584113 | 1584113 | 2020-11-30 | India | Jammu and Kashmir | 110224 | 1694 | 103565 | 4965 | 33.75943 | 76.612638 | 2020-12-01 05:26:18 | Jammu and Kashmir, India | ||
3566516 | 3566516 | 2020-11-29 | India | Jammu and Kashmir | 109854 | 1685 | 103082 | 5087 | 33.75943 | 76.612638 | 2020-11-30 05:26:13 | Jammu and Kashmir, India | ||
2935181 | 2935181 | 2020-11-28 | India | Jammu and Kashmir | 109383 | 1680 | 102591 | 5112 | 33.75943 | 76.612638 | 2020-11-29 05:25:55 | Jammu and Kashmir, India | ||
392184 | 392184 | 2020-11-27 | India | Jammu and Kashmir | 108871 | 1676 | 101959 | 5236 | 33.75943 | 76.612638 | 2020-11-28 05:25:50 | Jammu and Kashmir, India | ||
923631 | 923631 | 2020-11-26 | India | Jammu and Kashmir | 108306 | 1668 | 101363 | 5275 | 33.75943 | 76.612638 | 2020-11-27 05:26:53 | Jammu and Kashmir, India | ||
1972536 | 1972536 | 2020-11-25 | India | Jammu and Kashmir | 107819 | 1663 | 100892 | 5264 | 33.75943 | 76.612638 | 2020-11-26 05:27:44 | Jammu and Kashmir, India | ||
1350267 | 1350267 | 2020-11-24 | India | Jammu and Kashmir | 107330 | 1651 | 100322 | 5357 | 33.75943 | 76.612638 | 2020-11-25 05:27:20 | Jammu and Kashmir, India | ||
678261 | 678261 | 2020-11-23 | India | Jammu and Kashmir | 106899 | 1641 | 99827 | 5431 | 33.75943 | 76.612638 | 2020-11-24 05:27:31 | Jammu and Kashmir, India | ||
3189937 | 3189937 | 2020-11-22 | India | Jammu and Kashmir | 106548 | 1629 | 99219 | 5700 | 33.75943 | 76.612638 | 2020-11-23 05:25:26 | Jammu and Kashmir, India | ||
3836431 | 3836431 | 2020-11-21 | India | Jammu and Kashmir | 105984 | 1624 | 98640 | 5720 | 33.75943 | 76.612638 | 2020-11-22 05:25:45 | Jammu and Kashmir, India | ||
2701459 | 2701459 | 2020-11-20 | India | Jammu and Kashmir | 105376 | 1622 | 98076 | 5678 | 33.75943 | 76.612638 | 2020-11-21 05:25:51 | Jammu and Kashmir, India | ||
821519 | 821519 | 2020-11-19 | India | Jammu and Kashmir | 104715 | 1618 | 97537 | 5560 | 33.75943 | 76.612638 | 2020-11-20 05:26:28 | Jammu and Kashmir, India | ||
122653 | 122653 | 2020-11-18 | India | Jammu and Kashmir | 104155 | 1613 | 96972 | 5570 | 33.75943 | 76.612638 | 2020-11-19 05:25:23 | Jammu and Kashmir, India | ||
3338541 | 3338541 | 2020-11-17 | India | Jammu and Kashmir | 103581 | 1604 | 96392 | 5585 | 33.75943 | 76.612638 | 2020-11-18 05:40:31 | Jammu and Kashmir, India | ||
3169586 | 3169586 | 2020-11-16 | India | Jammu and Kashmir | 103009 | 1597 | 95824 | 5588 | 33.75943 | 76.612638 | 2020-11-17 05:25:54 | Jammu and Kashmir, India | ||
2880154 | 2880154 | 2020-11-15 | India | Jammu and Kashmir | 102619 | 1589 | 95342 | 5688 | 33.75943 | 76.612638 | 2020-11-16 05:25:57 | Jammu and Kashmir, India | ||
2915132 | 2915132 | 2020-11-14 | India | Jammu and Kashmir | 102159 | 1580 | 94851 | 5728 | 33.75943 | 76.612638 | 2020-11-15 05:26:53 | Jammu and Kashmir, India | ||
2784954 | 2784954 | 2020-11-13 | India | Jammu and Kashmir | 101594 | 1574 | 94375 | 5645 | 33.75943 | 76.612638 | 2020-11-14 05:25:37 | Jammu and Kashmir, India | ||
864719 | 864719 | 2020-11-12 | India | Jammu and Kashmir | 100968 | 1566 | 93824 | 5578 | 33.75943 | 76.612638 | 2020-11-13 05:25:30 | Jammu and Kashmir, India | ||
3440764 | 3440764 | 2020-11-11 | India | Jammu and Kashmir | 100351 | 1558 | 93313 | 5480 | 33.75943 | 76.612638 | 2020-11-12 05:25:55 | Jammu and Kashmir, India | ||
272104 | 272104 | 2020-11-10 | India | Jammu and Kashmir | 99844 | 1549 | 92880 | 5415 | 33.75943 | 76.612638 | 2020-11-11 05:25:30 | Jammu and Kashmir, India | ||
1988581 | 1988581 | 2020-11-09 | India | Jammu and Kashmir | 99352 | 1542 | 92245 | 5565 | 33.75943 | 76.612638 | 2020-11-10 05:40:07 | Jammu and Kashmir, India | ||
1728433 | 1728433 | 2020-11-08 | India | Jammu and Kashmir | 98892 | 1533 | 91681 | 5678 | 33.75943 | 76.612638 | 2020-11-09 05:25:45 | Jammu and Kashmir, India | ||
1543893 | 1543893 | 2020-11-07 | India | Jammu and Kashmir | 98337 | 1528 | 91225 | 5584 | 33.75943 | 76.612638 | 2020-11-08 05:24:56 | Jammu and Kashmir, India | ||
376131 | 376131 | 2020-11-06 | India | Jammu and Kashmir | 97805 | 1523 | 90537 | 5745 | 33.75943 | 76.612638 | 2020-11-07 05:24:52 | Jammu and Kashmir, India | ||
892069 | 892069 | 2020-11-05 | India | Jammu and Kashmir | 97224 | 1517 | 89905 | 5802 | 33.75943 | 76.612638 | 2020-11-06 05:24:55 | Jammu and Kashmir, India | ||
2919131 | 2919131 | 2020-11-04 | India | Jammu and Kashmir | 96700 | 1511 | 89254 | 5935 | 33.75943 | 76.612638 | 2020-11-05 06:05:03 | Jammu and Kashmir, India | ||
2497968 | 2497968 | 2020-11-03 | India | Jammu and Kashmir | 96188 | 1502 | 88718 | 5968 | 33.75943 | 76.612638 | 2020-11-04 05:25:09 | Jammu and Kashmir, India | ||
3304143 | 3304143 | 2020-11-02 | India | Jammu and Kashmir | 95710 | 1490 | 88140 | 6080 | 33.75943 | 76.612638 | 2020-11-03 06:00:16 | Jammu and Kashmir, India | ||
3409392 | 3409392 | 2020-11-01 | India | Jammu and Kashmir | 95325 | 1482 | 87517 | 6326 | 33.75943 | 76.612638 | 2020-11-02 05:25:04 | Jammu and Kashmir, India | ||
2079881 | 2079881 | 2020-10-31 | India | Jammu and Kashmir | 94785 | 1478 | 86888 | 6419 | 33.75943 | 76.612638 | 2020-11-01 04:36:19 | Jammu and Kashmir, India | ||
2243334 | 2243334 | 2020-10-30 | India | Jammu and Kashmir | 94330 | 1471 | 86024 | 6835 | 33.75943 | 76.612638 | 2020-10-31 04:24:44 | Jammu and Kashmir, India | ||
210189 | 210189 | 2020-10-29 | India | Jammu and Kashmir | 93764 | 1466 | 85370 | 6928 | 33.75943 | 76.612638 | 2020-10-30 04:24:49 | Jammu and Kashmir, India | ||
754251 | 754251 | 2020-10-28 | India | Jammu and Kashmir | 93213 | 1455 | 84782 | 6976 | 33.75943 | 76.612638 | 2020-10-29 04:24:49 | Jammu and Kashmir, India | ||
1452536 | 1452536 | 2020-10-27 | India | Jammu and Kashmir | 92677 | 1451 | 84236 | 6990 | 33.75943 | 76.612638 | 2020-10-28 04:24:39 | Jammu and Kashmir, India | ||
3480260 | 3480260 | 2020-10-26 | India | Jammu and Kashmir | 92225 | 1444 | 83485 | 7296 | 33.75943 | 76.612638 | 2020-10-27 04:24:45 | Jammu and Kashmir, India | ||
8281 | 8281 | 2020-10-25 | India | Jammu and Kashmir | 91861 | 1438 | 82858 | 7565 | 33.75943 | 76.612638 | 2020-10-26 04:25:02 | Jammu and Kashmir, India | ||
3651518 | 3651518 | 2020-10-24 | India | Jammu and Kashmir | 91329 | 1430 | 82219 | 7680 | 33.75943 | 76.612638 | 2020-10-25 04:24:36 | Jammu and Kashmir, India | ||
1053773 | 1053773 | 2020-10-23 | India | Jammu and Kashmir | 90752 | 1424 | 81486 | 7842 | 33.75943 | 76.612638 | 2020-10-24 04:24:46 | Jammu and Kashmir, India | ||
1177443 | 1177443 | 2020-10-22 | India | Jammu and Kashmir | 90166 | 1412 | 80802 | 7952 | 33.75943 | 76.612638 | 2020-10-23 04:24:46 | Jammu and Kashmir, India | ||
2191548 | 2191548 | 2020-10-21 | India | Jammu and Kashmir | 89582 | 1402 | 80092 | 8088 | 33.75943 | 76.612638 | 2020-10-22 04:24:27 | Jammu and Kashmir, India | ||
3990559 | 3990559 | 2020-10-20 | India | Jammu and Kashmir | 88958 | 1397 | 79437 | 8124 | 33.75943 | 76.612638 | 2020-10-21 04:24:14 | Jammu and Kashmir, India | ||
1794579 | 1794579 | 2020-10-19 | India | Jammu and Kashmir | 88369 | 1388 | 78667 | 8314 | 33.75943 | 76.612638 | 2020-10-20 04:24:22 | Jammu and Kashmir, India | ||
762263 | 762263 | 2020-10-18 | India | Jammu and Kashmir | 87942 | 1379 | 77886 | 8677 | 33.75943 | 76.612638 | 2020-10-19 04:24:16 | Jammu and Kashmir, India | ||
1026301 | 1026301 | 2020-10-17 | India | Jammu and Kashmir | 87364 | 1372 | 77288 | 8704 | 33.75943 | 76.612638 | 2020-10-18 04:24:25 | Jammu and Kashmir, India | ||
2856796 | 2856796 | 2020-10-16 | India | Jammu and Kashmir | 86754 | 1366 | 76479 | 8909 | 33.75943 | 76.612638 | 2020-10-17 04:24:12 | Jammu and Kashmir, India | ||
786326 | 786326 | 2020-10-15 | India | Jammu and Kashmir | 86057 | 1358 | 75641 | 9058 | 33.75943 | 76.612638 | 2020-10-16 04:24:01 | Jammu and Kashmir, India | ||
79037 | 79037 | 2020-10-14 | India | Jammu and Kashmir | 85409 | 1352 | 74318 | 9739 | 33.75943 | 76.612638 | 2020-10-15 04:24:28 | Jammu and Kashmir, India | ||
3781852 | 3781852 | 2020-10-13 | India | Jammu and Kashmir | 84708 | 1340 | 73502 | 9866 | 33.75943 | 76.612638 | 2020-10-14 04:24:05 | Jammu and Kashmir, India | ||
2291392 | 2291392 | 2020-10-12 | India | Jammu and Kashmir | 84031 | 1333 | 72706 | 9992 | 33.75943 | 76.612638 | 2020-10-13 04:24:02 | Jammu and Kashmir, India | ||
3785845 | 3785845 | 2020-10-11 | India | Jammu and Kashmir | 83633 | 1322 | 71845 | 10466 | 33.75943 | 76.612638 | 2020-10-12 04:23:45 | Jammu and Kashmir, India | ||
2601983 | 2601983 | 2020-10-10 | India | Jammu and Kashmir | 83064 | 1313 | 70955 | 10796 | 33.75943 | 76.612638 | 2020-10-11 04:23:46 | Jammu and Kashmir, India | ||
817516 | 817516 | 2020-10-09 | India | Jammu and Kashmir | 82429 | 1306 | 69979 | 11144 | 33.75943 | 76.612638 | 2020-10-10 04:23:57 | Jammu and Kashmir, India | ||
2689631 | 2689631 | 2020-10-08 | India | Jammu and Kashmir | 81793 | 1291 | 69020 | 11482 | 33.75943 | 76.612638 | 2020-10-09 04:23:59 | Jammu and Kashmir, India | ||
1041773 | 1041773 | 2020-10-07 | India | Jammu and Kashmir | 81097 | 1282 | 67684 | 12131 | 33.75943 | 76.612638 | 2020-10-08 04:23:56 | Jammu and Kashmir, India | ||
3117434 | 3117434 | 2020-10-06 | India | Jammu and Kashmir | 80476 | 1268 | 65496 | 13712 | 33.75943 | 76.612638 | 2020-10-07 04:23:40 | Jammu and Kashmir, India | ||
3801846 | 3801846 | 2020-10-05 | India | Jammu and Kashmir | 79738 | 1252 | 63790 | 14696 | 33.75943 | 76.612638 | 2020-10-06 04:23:33 | Jammu and Kashmir, India | ||
1822736 | 1822736 | 2020-10-04 | India | Jammu and Kashmir | 79106 | 1242 | 62404 | 15460 | 33.75943 | 76.612638 | 2020-10-05 04:23:33 | Jammu and Kashmir, 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]);