johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
317 rows where confirmed = 2524 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 17
- US 297
- Sao Tome and Principe 3
- Colombia 2
- Japan 2
- Bhutan 1
- Bosnia and Herzegovina 1
- Canada 1
- China 1
- Mexico 1
- Monaco 1
- New Zealand 1
- Russia 1
- Sierra Leone 1
- Sweden 1
- Timor-Leste 1
- Uganda 1
- Vietnam 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
221318 | 221318 | 2022-12-26 | US | Virginia | Fairfax City | 51600 | 2524 | 49 | 0 | 38.85157547 | -77.2977964 | 2022-12-27 04:21:07 | Fairfax City, Virginia, US | |
2952617 | 2952617 | 2022-12-20 | US | Iowa | Montgomery | 19137 | 2524 | 58 | 0 | 41.03018714 | -95.15642896 | 2022-12-21 04:21:03 | Montgomery, Iowa, US | |
3175019 | 3175019 | 2022-12-19 | US | Iowa | Montgomery | 19137 | 2524 | 58 | 0 | 41.03018714 | -95.15642896 | 2022-12-20 04:21:04 | Montgomery, Iowa, US | |
1629536 | 1629536 | 2022-12-18 | US | Iowa | Montgomery | 19137 | 2524 | 58 | 0 | 41.03018714 | -95.15642896 | 2022-12-19 04:21:03 | Montgomery, Iowa, US | |
504915 | 504915 | 2022-12-17 | US | Iowa | Montgomery | 19137 | 2524 | 58 | 0 | 41.03018714 | -95.15642896 | 2022-12-18 04:21:03 | Montgomery, Iowa, US | |
3325487 | 3325487 | 2022-12-16 | US | Iowa | Montgomery | 19137 | 2524 | 58 | 0 | 41.03018714 | -95.15642896 | 2022-12-17 04:21:04 | Montgomery, Iowa, US | |
543999 | 543999 | 2022-12-15 | US | Iowa | Montgomery | 19137 | 2524 | 58 | 0 | 41.03018714 | -95.15642896 | 2022-12-16 04:21:01 | Montgomery, Iowa, US | |
349527 | 349527 | 2022-12-14 | US | Iowa | Montgomery | 19137 | 2524 | 58 | 0 | 41.03018714 | -95.15642896 | 2022-12-15 04:20:58 | Montgomery, Iowa, US | |
1621214 | 1621214 | 2022-11-22 | US | Idaho | Franklin | 16041 | 2524 | 31 | 0 | 42.18332217 | -111.8149666 | 2022-11-23 04:21:06 | Franklin, Idaho, US | |
3462070 | 3462070 | 2022-11-21 | US | Missouri | Gentry | 29075 | 2524 | 37 | 0 | 40.21097916 | -94.40944419 | 2022-11-22 04:20:47 | Gentry, Missouri, US | |
3461102 | 3461102 | 2022-11-21 | US | Idaho | Franklin | 16041 | 2524 | 31 | 0 | 42.18332217 | -111.8149666 | 2022-11-22 04:20:47 | Franklin, Idaho, US | |
1642255 | 1642255 | 2022-11-20 | US | Missouri | Gentry | 29075 | 2524 | 37 | 0 | 40.21097916 | -94.40944419 | 2022-11-21 04:21:05 | Gentry, Missouri, US | |
1641287 | 1641287 | 2022-11-20 | US | Idaho | Franklin | 16041 | 2524 | 31 | 0 | 42.18332217 | -111.8149666 | 2022-11-21 04:21:05 | Franklin, Idaho, US | |
2065812 | 2065812 | 2022-11-19 | US | Missouri | Gentry | 29075 | 2524 | 37 | 0 | 40.21097916 | -94.40944419 | 2022-11-20 04:21:08 | Gentry, Missouri, US | |
2064844 | 2064844 | 2022-11-19 | US | Idaho | Franklin | 16041 | 2524 | 31 | 0 | 42.18332217 | -111.8149666 | 2022-11-20 04:21:08 | Franklin, Idaho, US | |
1757206 | 1757206 | 2022-11-18 | US | Missouri | Gentry | 29075 | 2524 | 37 | 0 | 40.21097916 | -94.40944419 | 2022-11-19 04:21:14 | Gentry, Missouri, US | |
1756238 | 1756238 | 2022-11-18 | US | Idaho | Franklin | 16041 | 2524 | 31 | 0 | 42.18332217 | -111.8149666 | 2022-11-19 04:21:14 | Franklin, Idaho, US | |
3028199 | 3028199 | 2022-11-17 | US | Missouri | Gentry | 29075 | 2524 | 37 | 0 | 40.21097916 | -94.40944419 | 2022-11-18 04:21:15 | Gentry, Missouri, US | |
3027231 | 3027231 | 2022-11-17 | US | Idaho | Franklin | 16041 | 2524 | 31 | 0 | 42.18332217 | -111.8149666 | 2022-11-18 04:21:15 | Franklin, Idaho, US | |
2487910 | 2487910 | 2022-11-16 | US | Missouri | Gentry | 29075 | 2524 | 37 | 0 | 40.21097916 | -94.40944419 | 2022-11-17 04:21:11 | Gentry, Missouri, US | |
2486942 | 2486942 | 2022-11-16 | US | Idaho | Franklin | 16041 | 2524 | 31 | 0 | 42.18332217 | -111.8149666 | 2022-11-17 04:21:11 | Franklin, Idaho, US | |
293921 | 293921 | 2022-11-15 | US | Missouri | Gentry | 29075 | 2524 | 37 | 0 | 40.21097916 | -94.40944419 | 2022-11-16 04:21:09 | Gentry, Missouri, US | |
311711 | 311711 | 2022-11-13 | China | Tianjin | 2524 | 3 | 0 | 39.3054 | 117.323 | 2022-11-14 04:21:09 | Tianjin, China | |||
850597 | 850597 | 2022-11-02 | US | Illinois | Hamilton | 17065 | 2524 | 32 | 0 | 38.08163641 | -88.53883373 | 2022-11-03 04:22:05 | Hamilton, Illinois, US | |
2760307 | 2760307 | 2022-10-18 | US | Virginia | Northumberland | 51133 | 2524 | 44 | 0 | 37.89202088 | -76.41949732 | 2022-10-19 04:22:26 | Northumberland, Virginia, US | |
1373065 | 1373065 | 2022-09-21 | US | Oklahoma | Latimer | 40077 | 2524 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-22 04:22:56 | Latimer, Oklahoma, US | |
2019295 | 2019295 | 2022-09-20 | US | Oklahoma | Latimer | 40077 | 2524 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-21 04:23:22 | Latimer, Oklahoma, US | |
3573168 | 3573168 | 2022-09-19 | US | Oklahoma | Latimer | 40077 | 2524 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-20 04:22:48 | Latimer, Oklahoma, US | |
421907 | 421907 | 2022-09-18 | US | Oklahoma | Latimer | 40077 | 2524 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-19 04:21:49 | Latimer, Oklahoma, US | |
420733 | 420733 | 2022-09-18 | US | Kentucky | Cumberland | 21057 | 2524 | 33 | 0 | 36.78926125 | -85.39050034 | 2022-09-19 04:21:49 | Cumberland, Kentucky, US | |
420716 | 420716 | 2022-09-18 | US | Kentucky | Bracken | 21023 | 2524 | 28 | 0 | 38.69158994 | -84.08532444 | 2022-09-19 04:21:49 | Bracken, Kentucky, US | |
3375931 | 3375931 | 2022-09-17 | US | Oklahoma | Latimer | 40077 | 2524 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-18 04:22:50 | Latimer, Oklahoma, US | |
3375547 | 3375547 | 2022-09-17 | US | New Jersey | Unassigned | 90034 | 2524 | 0 | 0 | 41.13891592 | 0.0 | 2022-09-18 04:22:50 | Unassigned, New Jersey, US | |
3374757 | 3374757 | 2022-09-17 | US | Kentucky | Cumberland | 21057 | 2524 | 33 | 0 | 36.78926125 | -85.39050034 | 2022-09-18 04:22:50 | Cumberland, Kentucky, US | |
3374740 | 3374740 | 2022-09-17 | US | Kentucky | Bracken | 21023 | 2524 | 28 | 0 | 38.69158994 | -84.08532444 | 2022-09-18 04:22:50 | Bracken, Kentucky, US | |
2358039 | 2358039 | 2022-09-16 | US | Oklahoma | Latimer | 40077 | 2524 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-17 04:20:19 | Latimer, Oklahoma, US | |
2356865 | 2356865 | 2022-09-16 | US | Kentucky | Cumberland | 21057 | 2524 | 33 | 0 | 36.78926125 | -85.39050034 | 2022-09-17 04:20:19 | Cumberland, Kentucky, US | |
2356848 | 2356848 | 2022-09-16 | US | Kentucky | Bracken | 21023 | 2524 | 28 | 0 | 38.69158994 | -84.08532444 | 2022-09-17 04:20:19 | Bracken, Kentucky, US | |
3989196 | 3989196 | 2022-09-15 | US | Oklahoma | Latimer | 40077 | 2524 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-16 04:21:19 | Latimer, Oklahoma, US | |
3988022 | 3988022 | 2022-09-15 | US | Kentucky | Cumberland | 21057 | 2524 | 33 | 0 | 36.78926125 | -85.39050034 | 2022-09-16 04:21:19 | Cumberland, Kentucky, US | |
3988005 | 3988005 | 2022-09-15 | US | Kentucky | Bracken | 21023 | 2524 | 28 | 0 | 38.69158994 | -84.08532444 | 2022-09-16 04:21:19 | Bracken, Kentucky, US | |
1890539 | 1890539 | 2022-09-14 | US | Kentucky | Cumberland | 21057 | 2524 | 33 | 0 | 36.78926125 | -85.39050034 | 2022-09-15 04:21:02 | Cumberland, Kentucky, US | |
1890522 | 1890522 | 2022-09-14 | US | Kentucky | Bracken | 21023 | 2524 | 28 | 0 | 38.69158994 | -84.08532444 | 2022-09-15 04:21:02 | Bracken, Kentucky, US | |
373594 | 373594 | 2022-09-13 | US | Kentucky | Cumberland | 21057 | 2524 | 33 | 0 | 36.78926125 | -85.39050034 | 2022-09-14 04:20:44 | Cumberland, Kentucky, US | |
373577 | 373577 | 2022-09-13 | US | Kentucky | Bracken | 21023 | 2524 | 28 | 0 | 38.69158994 | -84.08532444 | 2022-09-14 04:20:44 | Bracken, Kentucky, US | |
2396196 | 2396196 | 2022-09-12 | US | Kentucky | Cumberland | 21057 | 2524 | 33 | 0 | 36.78926125 | -85.39050034 | 2022-09-13 04:20:57 | Cumberland, Kentucky, US | |
2396179 | 2396179 | 2022-09-12 | US | Kentucky | Bracken | 21023 | 2524 | 28 | 0 | 38.69158994 | -84.08532444 | 2022-09-13 04:20:57 | Bracken, Kentucky, US | |
3777240 | 3777240 | 2022-08-30 | US | Virginia | Essex | 51057 | 2524 | 36 | 0 | 37.93357639 | -76.94230311 | 2022-08-31 04:20:57 | Essex, Virginia, US | |
1073277 | 1073277 | 2022-08-07 | US | Virginia | Northampton | 51131 | 2524 | 68 | 0 | 37.34062933 | -75.87751591 | 2022-08-08 04:21:08 | Northampton, Virginia, US | |
1943865 | 1943865 | 2022-08-06 | US | Virginia | Northampton | 51131 | 2524 | 68 | 0 | 37.34062933 | -75.87751591 | 2022-08-07 04:20:54 | Northampton, Virginia, US | |
883664 | 883664 | 2022-08-05 | US | Virginia | Northampton | 51131 | 2524 | 68 | 0 | 37.34062933 | -75.87751591 | 2022-08-06 04:20:56 | Northampton, Virginia, US | |
1407946 | 1407946 | 2022-08-02 | US | South Dakota | Roberts | 46109 | 2524 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-08-03 04:20:59 | Roberts, South Dakota, US | |
3619984 | 3619984 | 2022-08-01 | US | South Dakota | Roberts | 46109 | 2524 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-08-02 04:20:53 | Roberts, South Dakota, US | |
3874464 | 3874464 | 2022-07-31 | US | South Dakota | Roberts | 46109 | 2524 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-08-01 04:21:03 | Roberts, South Dakota, US | |
677218 | 677218 | 2022-07-30 | US | South Dakota | Roberts | 46109 | 2524 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-07-31 04:21:02 | Roberts, South Dakota, US | |
1786417 | 1786417 | 2022-07-29 | US | South Dakota | Roberts | 46109 | 2524 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-07-30 04:20:42 | Roberts, South Dakota, US | |
1068780 | 1068780 | 2022-07-28 | US | South Dakota | Roberts | 46109 | 2524 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-07-29 04:20:45 | Roberts, South Dakota, US | |
2338299 | 2338299 | 2022-07-27 | US | South Dakota | Roberts | 46109 | 2524 | 53 | 0 | 45.62975048 | -96.94672673 | 2022-07-28 04:20:56 | Roberts, South Dakota, US | |
3112059 | 3112059 | 2022-07-13 | US | Oklahoma | Major | 40093 | 2524 | 41 | 0 | 36.31149996 | -98.53467076 | 2022-07-14 04:20:57 | Major, Oklahoma, US | |
632482 | 632482 | 2022-07-12 | US | Oklahoma | Major | 40093 | 2524 | 41 | 0 | 36.31149996 | -98.53467076 | 2022-07-13 04:20:58 | Major, Oklahoma, US | |
1214126 | 1214126 | 2022-07-11 | US | Oklahoma | Major | 40093 | 2524 | 41 | 0 | 36.31149996 | -98.53467076 | 2022-07-12 04:20:51 | Major, Oklahoma, US | |
2791608 | 2791608 | 2022-07-10 | US | Oklahoma | Major | 40093 | 2524 | 41 | 0 | 36.31149996 | -98.53467076 | 2022-07-11 04:20:46 | Major, Oklahoma, US | |
144561 | 144561 | 2022-07-09 | US | Oklahoma | Major | 40093 | 2524 | 41 | 0 | 36.31149996 | -98.53467076 | 2022-07-10 04:20:54 | Major, Oklahoma, US | |
1419661 | 1419661 | 2022-07-08 | US | Oklahoma | Major | 40093 | 2524 | 41 | 0 | 36.31149996 | -98.53467076 | 2022-07-09 04:20:59 | Major, Oklahoma, US | |
1417745 | 1417745 | 2022-07-08 | US | Colorado | San Miguel | 8113 | 2524 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-07-09 04:20:59 | San Miguel, Colorado, US | |
2743586 | 2743586 | 2022-07-07 | US | Oklahoma | Major | 40093 | 2524 | 41 | 0 | 36.31149996 | -98.53467076 | 2022-07-08 04:20:56 | Major, Oklahoma, US | |
2741670 | 2741670 | 2022-07-07 | US | Colorado | San Miguel | 8113 | 2524 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-07-08 04:20:56 | San Miguel, Colorado, US | |
2242792 | 2242792 | 2022-06-28 | US | Virginia | Poquoson | 51735 | 2524 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-06-29 04:20:59 | Poquoson, Virginia, US | |
2191032 | 2191032 | 2022-06-22 | US | Virginia | Sussex | 51183 | 2524 | 42 | 0 | 36.92432914 | -77.25791182 | 2022-06-23 04:20:55 | Sussex, Virginia, US | |
169463 | 169463 | 2022-06-21 | US | Virginia | Sussex | 51183 | 2524 | 42 | 0 | 36.92432914 | -77.25791182 | 2022-06-22 04:20:54 | Sussex, Virginia, US | |
950186 | 950186 | 2022-06-14 | US | Virginia | Falls Church | 51610 | 2524 | 17 | 0 | 38.88485255 | -77.17560759 | 2022-06-15 04:20:54 | Falls Church, Virginia, US | |
3729731 | 3729731 | 2022-06-07 | US | West Virginia | Ritchie | 54085 | 2524 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-06-08 04:20:55 | Ritchie, West Virginia, US | |
3729589 | 3729589 | 2022-06-07 | US | Virginia | Madison | 51113 | 2524 | 42 | 0 | 38.41531222 | -78.28220331 | 2022-06-08 04:20:55 | Madison, Virginia, US | |
232596 | 232596 | 2022-05-31 | US | Virginia | Lunenburg | 51111 | 2524 | 39 | 0 | 36.94618528 | -78.24133319 | 2022-06-01 04:20:55 | Lunenburg, Virginia, US | |
2599955 | 2599955 | 2022-05-05 | US | Missouri | Grundy | 29079 | 2524 | 68 | 0 | 40.11406587 | -93.56509276 | 2022-05-06 04:21:00 | Grundy, Missouri, US | |
3267404 | 3267404 | 2022-05-04 | US | Missouri | Grundy | 29079 | 2524 | 68 | 0 | 40.11406587 | -93.56509276 | 2022-05-05 04:20:55 | Grundy, Missouri, US | |
1574043 | 1574043 | 2022-05-03 | US | Missouri | Grundy | 29079 | 2524 | 68 | 0 | 40.11406587 | -93.56509276 | 2022-05-04 04:20:59 | Grundy, Missouri, US | |
465303 | 465303 | 2022-05-02 | US | Missouri | Grundy | 29079 | 2524 | 68 | 0 | 40.11406587 | -93.56509276 | 2022-05-03 04:21:00 | Grundy, Missouri, US | |
3917942 | 3917942 | 2022-05-01 | US | Missouri | Grundy | 29079 | 2524 | 68 | 0 | 40.11406587 | -93.56509276 | 2022-05-02 04:21:10 | Grundy, Missouri, US | |
2842746 | 2842746 | 2022-04-30 | US | Missouri | Grundy | 29079 | 2524 | 68 | 0 | 40.11406587 | -93.56509276 | 2022-05-01 04:20:57 | Grundy, Missouri, US | |
1159059 | 1159059 | 2022-04-29 | US | Missouri | Grundy | 29079 | 2524 | 68 | 0 | 40.11406587 | -93.56509276 | 2022-04-30 04:21:05 | Grundy, Missouri, US | |
1698241 | 1698241 | 2022-04-28 | US | Missouri | Grundy | 29079 | 2524 | 68 | 0 | 40.11406587 | -93.56509276 | 2022-04-29 04:20:59 | Grundy, Missouri, US | |
3208122 | 3208122 | 2022-04-11 | US | Mississippi | Tunica | 28143 | 2524 | 46 | 0 | 34.64967704 | -90.37481167 | 2022-04-12 04:20:49 | Tunica, Mississippi, US | |
1578008 | 1578008 | 2022-04-10 | US | Mississippi | Tunica | 28143 | 2524 | 46 | 0 | 34.64967704 | -90.37481167 | 2022-04-11 04:21:02 | Tunica, Mississippi, US | |
1654250 | 1654250 | 2022-04-09 | US | Mississippi | Tunica | 28143 | 2524 | 46 | 0 | 34.64967704 | -90.37481167 | 2022-04-10 04:20:52 | Tunica, Mississippi, US | |
2117572 | 2117572 | 2022-04-08 | US | Mississippi | Tunica | 28143 | 2524 | 46 | 0 | 34.64967704 | -90.37481167 | 2022-04-09 04:20:42 | Tunica, Mississippi, US | |
3322096 | 3322096 | 2022-04-07 | US | Mississippi | Tunica | 28143 | 2524 | 46 | 0 | 34.64967704 | -90.37481167 | 2022-04-08 04:20:48 | Tunica, Mississippi, US | |
2802632 | 2802632 | 2022-04-06 | US | Mississippi | Tunica | 28143 | 2524 | 46 | 0 | 34.64967704 | -90.37481167 | 2022-04-07 04:20:53 | Tunica, Mississippi, US | |
3869401 | 3869401 | 2022-04-05 | US | Mississippi | Tunica | 28143 | 2524 | 46 | 0 | 34.64967704 | -90.37481167 | 2022-04-06 04:20:49 | Tunica, Mississippi, US | |
2750743 | 2750743 | 2022-04-04 | US | Mississippi | Tunica | 28143 | 2524 | 46 | 0 | 34.64967704 | -90.37481167 | 2022-04-05 04:20:48 | Tunica, Mississippi, US | |
3731109 | 3731109 | 2022-04-03 | US | Georgia | Stewart | 13259 | 2524 | 32 | 0 | 32.07996777 | -84.83208037 | 2022-04-04 04:20:51 | Stewart, Georgia, US | |
500544 | 500544 | 2022-04-02 | US | Georgia | Stewart | 13259 | 2524 | 32 | 0 | 32.07996777 | -84.83208037 | 2022-04-03 04:20:48 | Stewart, Georgia, US | |
3353892 | 3353892 | 2022-04-01 | US | Texas | Trinity | 48455 | 2524 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-04-02 04:20:47 | Trinity, Texas, US | |
3351529 | 3351529 | 2022-04-01 | US | Georgia | Stewart | 13259 | 2524 | 32 | 0 | 32.07996777 | -84.83208037 | 2022-04-02 04:20:47 | Stewart, Georgia, US | |
1543197 | 1543197 | 2022-03-31 | US | Texas | Trinity | 48455 | 2524 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-04-01 04:20:28 | Trinity, Texas, US | |
1541742 | 1541742 | 2022-03-31 | US | Minnesota | Yellow Medicine | 27173 | 2524 | 29 | 0 | 44.71710183 | -95.86842453 | 2022-04-01 04:20:28 | Yellow Medicine, Minnesota, US | |
2479755 | 2479755 | 2022-03-30 | US | Minnesota | Yellow Medicine | 27173 | 2524 | 29 | 0 | 44.71710183 | -95.86842453 | 2022-03-31 04:20:56 | Yellow Medicine, Minnesota, US | |
159796 | 159796 | 2022-03-29 | US | Minnesota | Yellow Medicine | 27173 | 2524 | 29 | 0 | 44.71710183 | -95.86842453 | 2022-03-30 04:20:45 | Yellow Medicine, Minnesota, US | |
1438367 | 1438367 | 2022-03-28 | US | Minnesota | Yellow Medicine | 27173 | 2524 | 29 | 0 | 44.71710183 | -95.86842453 | 2022-03-29 04:20:46 | Yellow Medicine, Minnesota, US | |
878048 | 878048 | 2022-03-27 | US | Minnesota | Yellow Medicine | 27173 | 2524 | 29 | 0 | 44.71710183 | -95.86842453 | 2022-03-28 04:20:33 | Yellow Medicine, Minnesota, 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]);