johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
281 rows where confirmed = 2301 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- US 265
- Colombia 2
- Malaysia 2
- Sao Tome and Principe 2
- Chile 1
- China 1
- Cote d'Ivoire 1
- India 1
- Japan 1
- Jordan 1
- Liechtenstein 1
- Netherlands 1
- Pakistan 1
- Saint Vincent and the Grenadines 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3379798 | 3379798 | 2022-12-08 | US | North Dakota | Pembina | 38067 | 2301 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-12-09 04:21:05 | Pembina, North Dakota, US | |
1987069 | 1987069 | 2022-12-07 | US | North Dakota | Pembina | 38067 | 2301 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-12-08 04:21:07 | Pembina, North Dakota, US | |
3715405 | 3715405 | 2022-12-06 | US | Iowa | Palo Alto | 19147 | 2301 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-12-07 04:20:58 | Palo Alto, Iowa, US | |
2416788 | 2416788 | 2022-12-05 | US | Missouri | Hickory | 29085 | 2301 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-06 04:21:03 | Hickory, Missouri, US | |
2416110 | 2416110 | 2022-12-05 | US | Iowa | Palo Alto | 19147 | 2301 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-12-06 04:21:03 | Palo Alto, Iowa, US | |
720396 | 720396 | 2022-12-04 | US | Missouri | Hickory | 29085 | 2301 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-05 04:20:58 | Hickory, Missouri, US | |
719718 | 719718 | 2022-12-04 | US | Iowa | Palo Alto | 19147 | 2301 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-12-05 04:20:58 | Palo Alto, Iowa, US | |
2818685 | 2818685 | 2022-12-03 | US | Missouri | Hickory | 29085 | 2301 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-04 04:20:56 | Hickory, Missouri, US | |
2818007 | 2818007 | 2022-12-03 | US | Iowa | Palo Alto | 19147 | 2301 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-12-04 04:20:56 | Palo Alto, Iowa, US | |
835541 | 835541 | 2022-12-02 | US | Missouri | Hickory | 29085 | 2301 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-03 04:21:02 | Hickory, Missouri, US | |
834863 | 834863 | 2022-12-02 | US | Iowa | Palo Alto | 19147 | 2301 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-12-03 04:21:02 | Palo Alto, Iowa, US | |
2138071 | 2138071 | 2022-12-01 | US | Missouri | Hickory | 29085 | 2301 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-02 04:21:07 | Hickory, Missouri, US | |
2137393 | 2137393 | 2022-12-01 | US | Iowa | Palo Alto | 19147 | 2301 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-12-02 04:21:07 | Palo Alto, Iowa, US | |
1966487 | 1966487 | 2022-11-30 | US | Missouri | Hickory | 29085 | 2301 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-12-01 04:21:03 | Hickory, Missouri, US | |
1965809 | 1965809 | 2022-11-30 | US | Iowa | Palo Alto | 19147 | 2301 | 40 | 0 | 43.08193849 | -94.67824621 | 2022-12-01 04:21:03 | Palo Alto, Iowa, US | |
2558501 | 2558501 | 2022-11-29 | US | Missouri | Hickory | 29085 | 2301 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-11-30 04:21:07 | Hickory, Missouri, US | |
711335 | 711335 | 2022-11-01 | US | Georgia | Taylor | 13269 | 2301 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-11-02 04:22:09 | Taylor, Georgia, US | |
3285784 | 3285784 | 2022-10-31 | US | Georgia | Taylor | 13269 | 2301 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-11-01 04:22:36 | Taylor, Georgia, US | |
320817 | 320817 | 2022-10-30 | US | Georgia | Taylor | 13269 | 2301 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-10-31 04:21:36 | Taylor, Georgia, US | |
913093 | 913093 | 2022-10-29 | US | Georgia | Taylor | 13269 | 2301 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-10-30 04:22:14 | Taylor, Georgia, US | |
1367362 | 1367362 | 2022-10-28 | US | Georgia | Taylor | 13269 | 2301 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-10-29 04:21:13 | Taylor, Georgia, US | |
3039217 | 3039217 | 2022-10-27 | US | Georgia | Taylor | 13269 | 2301 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-10-28 04:22:31 | Taylor, Georgia, US | |
539637 | 539637 | 2022-10-26 | US | Georgia | Taylor | 13269 | 2301 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-10-27 04:22:01 | Taylor, Georgia, US | |
1833534 | 1833534 | 2022-10-25 | US | Virginia | Middlesex | 51119 | 2301 | 51 | 0 | 37.63191998 | -76.55064617 | 2022-10-26 04:22:19 | Middlesex, Virginia, US | |
1830678 | 1830678 | 2022-10-25 | US | Arkansas | Prairie | 5117 | 2301 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-10-26 04:22:19 | Prairie, Arkansas, US | |
794939 | 794939 | 2022-10-24 | US | Arkansas | Prairie | 5117 | 2301 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-10-25 04:21:53 | Prairie, Arkansas, US | |
3280390 | 3280390 | 2022-10-23 | US | West Virginia | Tucker | 54093 | 2301 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-10-24 04:22:29 | Tucker, West Virginia, US | |
3277394 | 3277394 | 2022-10-23 | US | Arkansas | Prairie | 5117 | 2301 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-10-24 04:22:29 | Prairie, Arkansas, US | |
2271428 | 2271428 | 2022-10-22 | US | West Virginia | Tucker | 54093 | 2301 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-10-23 04:22:46 | Tucker, West Virginia, US | |
2268432 | 2268432 | 2022-10-22 | US | Arkansas | Prairie | 5117 | 2301 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-10-23 04:22:46 | Prairie, Arkansas, US | |
1595728 | 1595728 | 2022-10-21 | US | West Virginia | Tucker | 54093 | 2301 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-10-22 04:22:53 | Tucker, West Virginia, US | |
1592732 | 1592732 | 2022-10-21 | US | Arkansas | Prairie | 5117 | 2301 | 46 | 0 | 34.83624419 | -91.55162157 | 2022-10-22 04:22:53 | Prairie, Arkansas, US | |
2275444 | 2275444 | 2022-10-20 | US | West Virginia | Tucker | 54093 | 2301 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-10-21 04:22:23 | Tucker, West Virginia, US | |
3754404 | 3754404 | 2022-10-13 | US | Idaho | Boundary | 16021 | 2301 | 67 | 0 | 48.76684761 | -116.4630179 | 2022-10-14 04:22:28 | Boundary, Idaho, US | |
3215229 | 3215229 | 2022-10-12 | US | Idaho | Boundary | 16021 | 2301 | 67 | 0 | 48.76684761 | -116.4630179 | 2022-10-13 04:22:39 | Boundary, Idaho, US | |
2637231 | 2637231 | 2022-09-05 | US | West Virginia | Pleasants | 54073 | 2301 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-09-06 04:21:02 | Pleasants, West Virginia, US | |
2990795 | 2990795 | 2022-09-04 | US | West Virginia | Pleasants | 54073 | 2301 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-09-05 04:21:01 | Pleasants, West Virginia, US | |
2716480 | 2716480 | 2022-09-03 | US | West Virginia | Pleasants | 54073 | 2301 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-09-04 04:21:22 | Pleasants, West Virginia, US | |
1397185 | 1397185 | 2022-09-02 | US | West Virginia | Pleasants | 54073 | 2301 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-09-03 04:21:04 | Pleasants, West Virginia, US | |
3774953 | 3774953 | 2022-08-30 | US | Illinois | Schuyler | 17169 | 2301 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-08-31 04:20:57 | Schuyler, Illinois, US | |
3953441 | 3953441 | 2022-08-17 | US | Tennessee | Hancock | 47067 | 2301 | 39 | 0 | 36.52692871 | -83.22375847 | 2022-08-18 04:21:11 | Hancock, Tennessee, US | |
3952700 | 3952700 | 2022-08-17 | US | New Mexico | Quay | 35037 | 2301 | 66 | 0 | 35.10403332 | -103.5481727 | 2022-08-18 04:21:11 | Quay, New Mexico, US | |
1089126 | 1089126 | 2022-08-09 | US | Texas | Clay | 48077 | 2301 | 39 | 0 | 33.78686685 | -98.20771198 | 2022-08-10 04:20:57 | Clay, Texas, US | |
1100875 | 1100875 | 2022-08-03 | US | Puerto Rico | Las Marias | 72083 | 2301 | 0 | 0 | 18.23679 | -66.98362 | 2022-08-04 04:20:58 | Las Marias, Puerto Rico, US | |
3408549 | 3408549 | 2022-07-17 | US | Texas | Franklin | 48159 | 2301 | 44 | 0 | 33.17653242 | -95.21917243 | 2022-07-18 04:20:59 | Franklin, Texas, US | |
3368308 | 3368308 | 2022-07-02 | US | Tennessee | Moore | 47127 | 2301 | 40 | 0 | 35.27724699 | -86.36230578 | 2022-07-03 04:20:59 | Moore, Tennessee, US | |
596637 | 596637 | 2022-07-01 | US | Tennessee | Moore | 47127 | 2301 | 40 | 0 | 35.27724699 | -86.36230578 | 2022-07-02 04:21:16 | Moore, Tennessee, US | |
941834 | 941834 | 2022-06-25 | US | Texas | Archer | 48009 | 2301 | 28 | 0 | 33.61569967 | -98.68754589 | 2022-06-26 04:21:02 | Archer, Texas, US | |
166998 | 166998 | 2022-06-21 | US | Idaho | Owyhee | 16073 | 2301 | 53 | 0 | 42.58016894 | -116.1693871 | 2022-06-22 04:20:54 | Owyhee, Idaho, US | |
1764281 | 1764281 | 2022-06-20 | US | Idaho | Owyhee | 16073 | 2301 | 53 | 0 | 42.58016894 | -116.1693871 | 2022-06-21 04:20:56 | Owyhee, Idaho, US | |
3270467 | 3270467 | 2022-06-19 | US | Idaho | Owyhee | 16073 | 2301 | 53 | 0 | 42.58016894 | -116.1693871 | 2022-06-20 04:21:01 | Owyhee, Idaho, US | |
3398379 | 3398379 | 2022-06-18 | US | Idaho | Owyhee | 16073 | 2301 | 53 | 0 | 42.58016894 | -116.1693871 | 2022-06-19 04:20:51 | Owyhee, Idaho, US | |
2312256 | 2312256 | 2022-06-17 | US | Idaho | Owyhee | 16073 | 2301 | 53 | 0 | 42.58016894 | -116.1693871 | 2022-06-18 04:21:10 | Owyhee, Idaho, US | |
2979733 | 2979733 | 2022-06-13 | US | Arkansas | Cleveland | 5025 | 2301 | 36 | 0 | 33.89723187 | -92.18537045 | 2022-06-14 04:20:52 | Cleveland, Arkansas, US | |
1424334 | 1424334 | 2022-06-08 | US | Texas | Swisher | 48437 | 2301 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-06-09 04:20:54 | Swisher, Texas, US | |
3729448 | 3729448 | 2022-06-07 | US | Texas | Swisher | 48437 | 2301 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-06-08 04:20:55 | Swisher, Texas, US | |
3890850 | 3890850 | 2022-06-06 | US | Texas | Swisher | 48437 | 2301 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-06-07 04:21:08 | Swisher, Texas, US | |
3510619 | 3510619 | 2022-06-05 | US | Texas | Swisher | 48437 | 2301 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-06-06 04:20:57 | Swisher, Texas, US | |
3530696 | 3530696 | 2022-06-04 | US | Texas | Swisher | 48437 | 2301 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-06-05 04:20:55 | Swisher, Texas, US | |
232273 | 232273 | 2022-05-31 | US | Texas | Castro | 48069 | 2301 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-06-01 04:20:55 | Castro, Texas, US | |
3896487 | 3896487 | 2022-05-19 | US | Arkansas | Scott | 5127 | 2301 | 44 | 0 | 34.85588887 | -94.0632176 | 2022-05-20 04:20:57 | Scott, Arkansas, US | |
1185271 | 1185271 | 2022-05-18 | US | Arkansas | Scott | 5127 | 2301 | 44 | 0 | 34.85588887 | -94.0632176 | 2022-05-19 04:20:54 | Scott, Arkansas, US | |
2600976 | 2600976 | 2022-05-05 | US | Tennessee | Clay | 47027 | 2301 | 50 | 0 | 36.55151008 | -85.53930419 | 2022-05-06 04:21:00 | Clay, Tennessee, US | |
3268425 | 3268425 | 2022-05-04 | US | Tennessee | Clay | 47027 | 2301 | 50 | 0 | 36.55151008 | -85.53930419 | 2022-05-05 04:20:55 | Clay, Tennessee, US | |
3266169 | 3266169 | 2022-05-04 | US | Connecticut | Unassigned | 90009 | 2301 | 1 | 0 | 41.85853803 | 0.0 | 2022-05-05 04:20:55 | Unassigned, Connecticut, US | |
465168 | 465168 | 2022-05-02 | US | Minnesota | Swift | 27151 | 2301 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-05-03 04:21:00 | Swift, Minnesota, US | |
3868479 | 3868479 | 2022-04-05 | US | Idaho | Clearwater | 16035 | 2301 | 33 | 0 | 46.67459924 | -115.6622393 | 2022-04-06 04:20:49 | Clearwater, Idaho, US | |
3733015 | 3733015 | 2022-04-03 | US | Puerto Rico | Santa Isabel | 72133 | 2301 | 0 | 0 | 17.994525 | -66.388913 | 2022-04-04 04:20:51 | Santa Isabel, Puerto Rico, US | |
1645505 | 1645505 | 2022-03-03 | US | Indiana | Switzerland | 18155 | 2301 | 18 | 0 | 38.82767338 | -85.03022429 | 2022-03-04 04:21:09 | Switzerland, Indiana, US | |
1995809 | 1995809 | 2022-03-01 | US | Texas | La Salle | 48283 | 2301 | 45 | 0 | 28.34453111 | -99.09908775 | 2022-03-02 04:21:07 | La Salle, Texas, US | |
1512893 | 1512893 | 2022-02-24 | US | Kentucky | Wolfe | 21237 | 2301 | 18 | 0 | 37.73941626 | -83.49303612 | 2022-02-25 04:21:11 | Wolfe, Kentucky, US | |
1059334 | 1059334 | 2022-02-23 | US | Kentucky | Wolfe | 21237 | 2301 | 18 | 0 | 37.73941626 | -83.49303612 | 2022-02-24 04:21:14 | Wolfe, Kentucky, US | |
3721168 | 3721168 | 2022-02-21 | US | Tennessee | Perry | 47135 | 2301 | 46 | 0 | 35.63708728 | -87.86139634 | 2022-02-22 04:21:01 | Perry, Tennessee, US | |
1465743 | 1465743 | 2022-02-10 | US | Michigan | Mackinac | 26097 | 2301 | 28 | 0 | 46.07028979 | -85.04980537 | 2022-02-11 04:21:09 | Mackinac, Michigan, US | |
3075704 | 3075704 | 2022-02-09 | US | Michigan | Mackinac | 26097 | 2301 | 28 | 0 | 46.07028979 | -85.04980537 | 2022-02-10 04:21:14 | Mackinac, Michigan, US | |
71935 | 71935 | 2022-02-07 | US | Georgia | McIntosh | 13191 | 2301 | 35 | 0 | 31.49683595 | -81.40163426 | 2022-02-08 04:21:15 | McIntosh, Georgia, US | |
2477292 | 2477292 | 2022-02-03 | US | Virginia | Floyd | 51063 | 2301 | 33 | 0 | 36.9302126 | -80.36738849 | 2022-02-04 04:21:10 | Floyd, Virginia, US | |
3303234 | 3303234 | 2022-01-30 | US | Texas | Blanco | 48031 | 2301 | 29 | 0 | 30.26640707 | -98.3999852 | 2022-01-31 04:21:09 | Blanco, Texas, US | |
1780890 | 1780890 | 2022-01-27 | US | Louisiana | East Carroll | 22035 | 2301 | 35 | 0 | 32.73926954 | -91.23425694 | 2022-01-28 04:21:09 | East Carroll, Louisiana, US | |
1321453 | 1321453 | 2022-01-26 | US | Texas | Trinity | 48455 | 2301 | 67 | 0 | 31.0879489 | -95.1367187 | 2022-01-27 04:21:19 | Trinity, Texas, US | |
2055223 | 2055223 | 2022-01-25 | US | Virginia | Franklin City | 51620 | 2301 | 43 | 0 | 36.6831435 | -76.93859681 | 2022-01-26 04:21:07 | Franklin City, Virginia, US | |
3689893 | 3689893 | 2022-01-13 | US | North Dakota | McLean | 38055 | 2301 | 47 | 0 | 47.60766714 | -101.3182418 | 2022-01-14 04:21:54 | McLean, North Dakota, US | |
1695035 | 1695035 | 2022-01-10 | US | Puerto Rico | Aibonito | 72009 | 2301 | 0 | 0 | 18.131361 | -66.264131 | 2022-01-11 04:22:01 | Aibonito, Puerto Rico, US | |
1390224 | 1390224 | 2022-01-07 | US | California | Mono | 6051 | 2301 | 4 | 0 | 37.93899289 | -118.8872409 | 2022-01-08 04:21:53 | Mono, California, US | |
1435175 | 1435175 | 2021-12-28 | US | Oregon | Baker | 41001 | 2301 | 36 | 0 | 44.70915557 | -117.6749883 | 2021-12-29 03:21:43 | Baker, Oregon, US | |
732427 | 732427 | 2021-12-27 | US | Missouri | Dent | 29065 | 2301 | 63 | 0 | 37.60663134 | -91.50790473 | 2021-12-28 04:21:47 | Dent, Missouri, US | |
2966385 | 2966385 | 2021-12-24 | US | Tennessee | Stewart | 47161 | 2301 | 43 | 0 | 36.50235092 | -87.83920548 | 2021-12-25 04:21:37 | Stewart, Tennessee, US | |
2966169 | 2966169 | 2021-12-24 | US | Puerto Rico | San Lorenzo | 72129 | 2301 | 0 | 0 | 18.147987 | -65.976392 | 2021-12-25 04:21:37 | San Lorenzo, Puerto Rico, US | |
3819201 | 3819201 | 2021-12-23 | US | Puerto Rico | San Lorenzo | 72129 | 2301 | 0 | 0 | 18.147987 | -65.976392 | 2021-12-24 04:21:34 | San Lorenzo, Puerto Rico, US | |
3818705 | 3818705 | 2021-12-23 | US | New York | Yates | 36123 | 2301 | 35 | 0 | 42.63505484 | -77.10369919 | 2021-12-24 04:21:34 | Yates, New York, US | |
1257273 | 1257273 | 2021-12-20 | US | Ohio | Noble | 39121 | 2301 | 51 | 0 | 39.76818851 | -81.45937183 | 2021-12-21 03:21:27 | Noble, Ohio, US | |
2906213 | 2906213 | 2021-12-19 | US | Ohio | Morgan | 39115 | 2301 | 46 | 0 | 39.62081738 | -81.85308173 | 2021-12-20 04:21:43 | Morgan, Ohio, US | |
3497896 | 3497896 | 2021-12-15 | US | Minnesota | Chippewa | 27023 | 2301 | 43 | 0 | 45.02343421 | -95.56403693 | 2021-12-16 04:22:11 | Chippewa, Minnesota, US | |
1081374 | 1081374 | 2021-12-09 | US | Washington | Klickitat | 53039 | 2301 | 30 | 0 | 45.87325839 | -120.7913598 | 2021-12-10 04:22:28 | Klickitat, Washington, US | |
1079579 | 1079579 | 2021-12-09 | US | Michigan | Leelanau | 26089 | 2301 | 36 | 0 | 44.94430054 | -85.80150326 | 2021-12-10 04:22:28 | Leelanau, Michigan, US | |
1079123 | 1079123 | 2021-12-09 | US | Iowa | Hancock | 19081 | 2301 | 40 | 0 | 43.08178477 | -93.73454884 | 2021-12-10 04:22:28 | Hancock, Iowa, US | |
552428 | 552428 | 2021-12-08 | US | Michigan | Leelanau | 26089 | 2301 | 36 | 0 | 44.94430054 | -85.80150326 | 2021-12-09 04:22:49 | Leelanau, Michigan, US | |
551972 | 551972 | 2021-12-08 | US | Iowa | Hancock | 19081 | 2301 | 40 | 0 | 43.08178477 | -93.73454884 | 2021-12-09 04:22:49 | Hancock, Iowa, US | |
1760 | 1760 | 2021-12-02 | US | Kentucky | Leslie | 21131 | 2301 | 31 | 0 | 37.09246661 | -83.37999606 | 2021-12-03 04:23:05 | Leslie, Kentucky, US | |
1146641 | 1146641 | 2021-12-01 | US | Minnesota | Cottonwood | 27033 | 2301 | 32 | 0 | 44.00715262 | -95.18138802 | 2021-12-02 04:22:37 | Cottonwood, 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]);