johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
174 rows where country_or_region = "US", deaths = 71 and province_or_state = "West Virginia" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3280376 | 3280376 | 2022-10-23 | US | West Virginia | Morgan | 54065 | 4911 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-24 04:22:29 | Morgan, West Virginia, US | |
2271414 | 2271414 | 2022-10-22 | US | West Virginia | Morgan | 54065 | 4911 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-23 04:22:46 | Morgan, West Virginia, US | |
1595714 | 1595714 | 2022-10-21 | US | West Virginia | Morgan | 54065 | 4911 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-22 04:22:53 | Morgan, West Virginia, US | |
2275430 | 2275430 | 2022-10-20 | US | West Virginia | Morgan | 54065 | 4911 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-21 04:22:23 | Morgan, West Virginia, US | |
201765 | 201765 | 2022-10-19 | US | West Virginia | Morgan | 54065 | 4907 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-20 04:22:59 | Morgan, West Virginia, US | |
2760426 | 2760426 | 2022-10-18 | US | West Virginia | Morgan | 54065 | 4901 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-19 04:22:26 | Morgan, West Virginia, US | |
2028260 | 2028260 | 2022-10-17 | US | West Virginia | Morgan | 54065 | 4899 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-18 04:22:42 | Morgan, West Virginia, US | |
2163038 | 2163038 | 2022-10-16 | US | West Virginia | Morgan | 54065 | 4886 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-17 04:20:31 | Morgan, West Virginia, US | |
519235 | 519235 | 2022-10-15 | US | West Virginia | Morgan | 54065 | 4886 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-16 04:22:39 | Morgan, West Virginia, US | |
2036292 | 2036292 | 2022-10-14 | US | West Virginia | Morgan | 54065 | 4886 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-15 04:22:00 | Morgan, West Virginia, US | |
3756980 | 3756980 | 2022-10-13 | US | West Virginia | Morgan | 54065 | 4880 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-14 04:22:28 | Morgan, West Virginia, US | |
3217805 | 3217805 | 2022-10-12 | US | West Virginia | Morgan | 54065 | 4875 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-13 04:22:39 | Morgan, West Virginia, US | |
3253654 | 3253654 | 2022-10-11 | US | West Virginia | Morgan | 54065 | 4860 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-12 04:22:51 | Morgan, West Virginia, US | |
2970913 | 2970913 | 2022-10-10 | US | West Virginia | Morgan | 54065 | 4837 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-11 04:23:05 | Morgan, West Virginia, US | |
3100949 | 3100949 | 2022-10-09 | US | West Virginia | Morgan | 54065 | 4837 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-10 04:22:32 | Morgan, West Virginia, US | |
4006174 | 4006174 | 2022-10-08 | US | West Virginia | Morgan | 54065 | 4837 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-09 04:21:16 | Morgan, West Virginia, US | |
399771 | 399771 | 2022-10-07 | US | West Virginia | Morgan | 54065 | 4837 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-08 04:22:56 | Morgan, West Virginia, US | |
2532888 | 2532888 | 2022-10-06 | US | West Virginia | Morgan | 54065 | 4830 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-07 04:23:08 | Morgan, West Virginia, US | |
1814282 | 1814282 | 2022-10-05 | US | West Virginia | Morgan | 54065 | 4824 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-06 04:21:22 | Morgan, West Virginia, US | |
134256 | 134256 | 2022-10-04 | US | West Virginia | Morgan | 54065 | 4818 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-05 04:23:06 | Morgan, West Virginia, US | |
2689203 | 2689203 | 2022-10-03 | US | West Virginia | Morgan | 54065 | 4813 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-04 04:22:55 | Morgan, West Virginia, US | |
2263270 | 2263270 | 2022-10-02 | US | West Virginia | Morgan | 54065 | 4806 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-03 04:23:11 | Morgan, West Virginia, US | |
2998796 | 2998796 | 2022-10-01 | US | West Virginia | Morgan | 54065 | 4806 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-02 04:21:23 | Morgan, West Virginia, US | |
857122 | 857122 | 2022-09-30 | US | West Virginia | Morgan | 54065 | 4806 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-10-01 04:23:01 | Morgan, West Virginia, US | |
2379048 | 2379048 | 2022-09-29 | US | West Virginia | Morgan | 54065 | 4804 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-30 04:23:09 | Morgan, West Virginia, US | |
1563599 | 1563599 | 2022-09-28 | US | West Virginia | Morgan | 54065 | 4802 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-29 04:22:34 | Morgan, West Virginia, US | |
3998142 | 3998142 | 2022-09-27 | US | West Virginia | Morgan | 54065 | 4802 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-28 04:23:01 | Morgan, West Virginia, US | |
2772470 | 2772470 | 2022-09-26 | US | West Virginia | Morgan | 54065 | 4800 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-27 04:23:01 | Morgan, West Virginia, US | |
1980123 | 1980123 | 2022-09-25 | US | West Virginia | Morgan | 54065 | 4793 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-26 04:20:52 | Morgan, West Virginia, US | |
2653290 | 2653290 | 2022-09-24 | US | West Virginia | Morgan | 54065 | 4793 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-25 04:23:31 | Morgan, West Virginia, US | |
387730 | 387730 | 2022-09-23 | US | West Virginia | Morgan | 54065 | 4793 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-24 04:21:40 | Morgan, West Virginia, US | |
1627796 | 1627796 | 2022-09-22 | US | West Virginia | Morgan | 54065 | 4792 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-23 04:23:13 | Morgan, West Virginia, US | |
1374000 | 1374000 | 2022-09-21 | US | West Virginia | Morgan | 54065 | 4788 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-22 04:22:56 | Morgan, West Virginia, US | |
2020230 | 2020230 | 2022-09-20 | US | West Virginia | Morgan | 54065 | 4785 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-21 04:23:22 | Morgan, West Virginia, US | |
3574103 | 3574103 | 2022-09-19 | US | West Virginia | Morgan | 54065 | 4784 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-20 04:22:48 | Morgan, West Virginia, US | |
422842 | 422842 | 2022-09-18 | US | West Virginia | Morgan | 54065 | 4776 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-19 04:21:49 | Morgan, West Virginia, US | |
3376866 | 3376866 | 2022-09-17 | US | West Virginia | Morgan | 54065 | 4776 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-18 04:22:50 | Morgan, West Virginia, US | |
2358974 | 2358974 | 2022-09-16 | US | West Virginia | Morgan | 54065 | 4776 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-17 04:20:19 | Morgan, West Virginia, US | |
3990131 | 3990131 | 2022-09-15 | US | West Virginia | Morgan | 54065 | 4772 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-16 04:21:19 | Morgan, West Virginia, US | |
1892648 | 1892648 | 2022-09-14 | US | West Virginia | Morgan | 54065 | 4772 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-15 04:21:02 | Morgan, West Virginia, US | |
375703 | 375703 | 2022-09-13 | US | West Virginia | Morgan | 54065 | 4768 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-14 04:20:44 | Morgan, West Virginia, US | |
2398305 | 2398305 | 2022-09-12 | US | West Virginia | Morgan | 54065 | 4763 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-13 04:20:57 | Morgan, West Virginia, US | |
3769383 | 3769383 | 2022-09-11 | US | West Virginia | Morgan | 54065 | 4754 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-12 04:20:58 | Morgan, West Virginia, US | |
3827958 | 3827958 | 2022-09-10 | US | West Virginia | Morgan | 54065 | 4754 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-11 04:20:50 | Morgan, West Virginia, US | |
966415 | 966415 | 2022-09-09 | US | West Virginia | Morgan | 54065 | 4754 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-10 04:21:10 | Morgan, West Virginia, US | |
256817 | 256817 | 2022-09-08 | US | West Virginia | Morgan | 54065 | 4751 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-09 04:21:11 | Morgan, West Virginia, US | |
3748615 | 3748615 | 2022-09-07 | US | West Virginia | Morgan | 54065 | 4750 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-08 04:21:02 | Morgan, West Virginia, US | |
118255 | 118255 | 2022-09-06 | US | West Virginia | Morgan | 54065 | 4745 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-07 04:20:59 | Morgan, West Virginia, US | |
2637227 | 2637227 | 2022-09-05 | US | West Virginia | Morgan | 54065 | 4725 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-06 04:21:02 | Morgan, West Virginia, US | |
2990791 | 2990791 | 2022-09-04 | US | West Virginia | Morgan | 54065 | 4725 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-05 04:21:01 | Morgan, West Virginia, US | |
2716476 | 2716476 | 2022-09-03 | US | West Virginia | Morgan | 54065 | 4725 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-04 04:21:22 | Morgan, West Virginia, US | |
1397181 | 1397181 | 2022-09-02 | US | West Virginia | Morgan | 54065 | 4725 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-03 04:21:04 | Morgan, West Virginia, US | |
3551010 | 3551010 | 2022-09-01 | US | West Virginia | Morgan | 54065 | 4717 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-02 04:21:07 | Morgan, West Virginia, US | |
2346930 | 2346930 | 2022-08-31 | US | West Virginia | Morgan | 54065 | 4715 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-09-01 04:21:03 | Morgan, West Virginia, US | |
3777410 | 3777410 | 2022-08-30 | US | West Virginia | Morgan | 54065 | 4708 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-31 04:20:57 | Morgan, West Virginia, US | |
1684006 | 1684006 | 2022-08-29 | US | West Virginia | Morgan | 54065 | 4706 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-30 04:21:03 | Morgan, West Virginia, US | |
1880490 | 1880490 | 2022-08-28 | US | West Virginia | Morgan | 54065 | 4694 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-29 04:21:06 | Morgan, West Virginia, US | |
2099617 | 2099617 | 2022-08-27 | US | West Virginia | Morgan | 54065 | 4694 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-28 04:21:02 | Morgan, West Virginia, US | |
1535432 | 1535432 | 2022-08-26 | US | West Virginia | Morgan | 54065 | 4694 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-27 04:20:57 | Morgan, West Virginia, US | |
2832319 | 2832319 | 2022-08-25 | US | West Virginia | Morgan | 54065 | 4688 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-26 04:21:02 | Morgan, West Virginia, US | |
2326852 | 2326852 | 2022-08-24 | US | West Virginia | Morgan | 54065 | 4682 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-25 04:21:13 | Morgan, West Virginia, US | |
1254261 | 1254261 | 2022-08-23 | US | West Virginia | Morgan | 54065 | 4676 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-24 04:20:46 | Morgan, West Virginia, US | |
2856365 | 2856365 | 2022-08-22 | US | West Virginia | Morgan | 54065 | 4672 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-23 04:20:56 | Morgan, West Virginia, US | |
2406337 | 2406337 | 2022-08-21 | US | West Virginia | Morgan | 54065 | 4654 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-22 04:20:38 | Morgan, West Virginia, US | |
3801415 | 3801415 | 2022-08-20 | US | West Virginia | Morgan | 54065 | 4654 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-21 04:20:44 | Morgan, West Virginia, US | |
2367001 | 2367001 | 2022-08-19 | US | West Virginia | Morgan | 54065 | 4654 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-20 04:21:01 | Morgan, West Virginia, US | |
1164672 | 1164672 | 2022-08-18 | US | West Virginia | Morgan | 54065 | 4647 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-19 04:20:54 | Morgan, West Virginia, US | |
3953996 | 3953996 | 2022-08-17 | US | West Virginia | Morgan | 54065 | 4636 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-18 04:21:11 | Morgan, West Virginia, US | |
994498 | 994498 | 2022-08-16 | US | West Virginia | Morgan | 54065 | 4631 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-17 04:20:59 | Morgan, West Virginia, US | |
2497537 | 2497537 | 2022-08-15 | US | West Virginia | Morgan | 54065 | 4628 | 71 | 0 | 39.55439028 | -78.26311676 | 2022-08-16 04:20:58 | Morgan, West Virginia, US | |
1849459 | 1849459 | 2022-04-18 | US | West Virginia | Hampshire | 54027 | 5837 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-19 04:21:00 | Hampshire, West Virginia, US | |
3420403 | 3420403 | 2022-04-17 | US | West Virginia | Hampshire | 54027 | 5830 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-18 04:21:12 | Hampshire, West Virginia, US | |
307352 | 307352 | 2022-04-16 | US | West Virginia | Hampshire | 54027 | 5830 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-17 04:20:59 | Hampshire, West Virginia, US | |
2673297 | 2673297 | 2022-04-15 | US | West Virginia | Hampshire | 54027 | 5830 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-16 04:20:48 | Hampshire, West Virginia, US | |
1227082 | 1227082 | 2022-04-14 | US | West Virginia | Hampshire | 54027 | 5825 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-15 04:20:57 | Hampshire, West Virginia, US | |
2446240 | 2446240 | 2022-04-13 | US | West Virginia | Hampshire | 54027 | 5824 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-13 23:21:06 | Hampshire, West Virginia, US | |
1951997 | 1951997 | 2022-04-12 | US | West Virginia | Hampshire | 54027 | 5829 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-13 04:21:03 | Hampshire, West Virginia, US | |
3209750 | 3209750 | 2022-04-11 | US | West Virginia | Hampshire | 54027 | 5826 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-12 04:20:49 | Hampshire, West Virginia, US | |
1579636 | 1579636 | 2022-04-10 | US | West Virginia | Hampshire | 54027 | 5822 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-11 04:21:02 | Hampshire, West Virginia, US | |
1655878 | 1655878 | 2022-04-09 | US | West Virginia | Hampshire | 54027 | 5822 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-10 04:20:52 | Hampshire, West Virginia, US | |
2119200 | 2119200 | 2022-04-08 | US | West Virginia | Hampshire | 54027 | 5822 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-09 04:20:42 | Hampshire, West Virginia, US | |
3323724 | 3323724 | 2022-04-07 | US | West Virginia | Hampshire | 54027 | 5821 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-08 04:20:48 | Hampshire, West Virginia, US | |
2804260 | 2804260 | 2022-04-06 | US | West Virginia | Hampshire | 54027 | 5818 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-07 04:20:53 | Hampshire, West Virginia, US | |
3871016 | 3871016 | 2022-04-05 | US | West Virginia | Barbour | 54001 | 4787 | 71 | 0 | 39.1307219 | -80.00350858 | 2022-04-06 04:20:49 | Barbour, West Virginia, US | |
3871029 | 3871029 | 2022-04-05 | US | West Virginia | Hampshire | 54027 | 5818 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-06 04:20:49 | Hampshire, West Virginia, US | |
3871042 | 3871042 | 2022-04-05 | US | West Virginia | McDowell | 54047 | 5598 | 71 | 0 | 37.38002939 | -81.65083669 | 2022-04-06 04:20:49 | McDowell, West Virginia, US | |
2752371 | 2752371 | 2022-04-04 | US | West Virginia | Hampshire | 54027 | 5817 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-05 04:20:48 | Hampshire, West Virginia, US | |
2752384 | 2752384 | 2022-04-04 | US | West Virginia | McDowell | 54047 | 5595 | 71 | 0 | 37.38002939 | -81.65083669 | 2022-04-05 04:20:48 | McDowell, West Virginia, US | |
3733717 | 3733717 | 2022-04-03 | US | West Virginia | Hampshire | 54027 | 5815 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-04 04:20:51 | Hampshire, West Virginia, US | |
3733730 | 3733730 | 2022-04-03 | US | West Virginia | McDowell | 54047 | 5595 | 71 | 0 | 37.38002939 | -81.65083669 | 2022-04-04 04:20:51 | McDowell, West Virginia, US | |
503152 | 503152 | 2022-04-02 | US | West Virginia | Hampshire | 54027 | 5815 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-03 04:20:48 | Hampshire, West Virginia, US | |
503165 | 503165 | 2022-04-02 | US | West Virginia | McDowell | 54047 | 5595 | 71 | 0 | 37.38002939 | -81.65083669 | 2022-04-03 04:20:48 | McDowell, West Virginia, US | |
3354137 | 3354137 | 2022-04-01 | US | West Virginia | Hampshire | 54027 | 5815 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-02 04:20:47 | Hampshire, West Virginia, US | |
3354150 | 3354150 | 2022-04-01 | US | West Virginia | McDowell | 54047 | 5595 | 71 | 0 | 37.38002939 | -81.65083669 | 2022-04-02 04:20:47 | McDowell, West Virginia, US | |
1543442 | 1543442 | 2022-03-31 | US | West Virginia | Hampshire | 54027 | 5814 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-04-01 04:20:28 | Hampshire, West Virginia, US | |
1543455 | 1543455 | 2022-03-31 | US | West Virginia | McDowell | 54047 | 5594 | 71 | 0 | 37.38002939 | -81.65083669 | 2022-04-01 04:20:28 | McDowell, West Virginia, US | |
2481455 | 2481455 | 2022-03-30 | US | West Virginia | Hampshire | 54027 | 5815 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-03-31 04:20:56 | Hampshire, West Virginia, US | |
2481468 | 2481468 | 2022-03-30 | US | West Virginia | McDowell | 54047 | 5593 | 71 | 0 | 37.38002939 | -81.65083669 | 2022-03-31 04:20:56 | McDowell, West Virginia, US | |
161496 | 161496 | 2022-03-29 | US | West Virginia | Hampshire | 54027 | 5814 | 71 | 0 | 39.32103553 | -78.60826476 | 2022-03-30 04:20:45 | Hampshire, West Virginia, US | |
161509 | 161509 | 2022-03-29 | US | West Virginia | McDowell | 54047 | 5592 | 71 | 0 | 37.38002939 | -81.65083669 | 2022-03-30 04:20:45 | McDowell, West Virginia, US |
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]);