johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
34,161 rows where province_or_state = "New Mexico" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2547 | 2547 | 2021-12-02 | US | New Mexico | Unassigned | 90035 | 5210 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-12-03 04:23:05 | Unassigned, New Mexico, US | |
6562 | 6562 | 2021-10-28 | US | New Mexico | Unassigned | 90035 | 4970 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-10-29 04:22:03 | Unassigned, New Mexico, US | |
10509 | 10509 | 2020-10-25 | US | New Mexico | De Baca | 35011 | 1 | 0 | 0 | 1 | 34.34274529 | -104.4117842 | 2020-10-26 04:25:02 | De Baca, New Mexico, US |
10514 | 10514 | 2020-10-25 | US | New Mexico | Harding | 35021 | 1 | 0 | 0 | 1 | 35.85751555 | -103.8220938 | 2020-10-26 04:25:02 | Harding, New Mexico, US |
10518 | 10518 | 2020-10-25 | US | New Mexico | Los Alamos | 35028 | 43 | 0 | 0 | 43 | 35.86631386 | -106.3134985 | 2020-10-26 04:25:02 | Los Alamos, New Mexico, US |
10521 | 10521 | 2020-10-25 | US | New Mexico | Mora | 35033 | 14 | 0 | 0 | 14 | 36.01095101 | -104.9497716 | 2020-10-26 04:25:02 | Mora, New Mexico, US |
10527 | 10527 | 2020-10-25 | US | New Mexico | San Miguel | 35047 | 170 | 0 | 0 | 170 | 35.48014807 | -104.8163562 | 2020-10-26 04:25:02 | San Miguel, New Mexico, US |
10534 | 10534 | 2020-10-25 | US | New Mexico | Unassigned | 90035 | 1698 | 0 | 0 | 1698 | 36.60569702 | -108.7151824 | 2020-10-26 04:25:02 | Unassigned, New Mexico, US |
14522 | 14522 | 2021-01-26 | US | New Mexico | De Baca | 35011 | 124 | 0 | 0 | 124 | 34.34274529 | -104.4117842 | 2021-01-27 05:23:41 | De Baca, New Mexico, US |
14527 | 14527 | 2021-01-26 | US | New Mexico | Harding | 35021 | 8 | 0 | 0 | 8 | 35.85751555 | -103.8220938 | 2021-01-27 05:23:41 | Harding, New Mexico, US |
14547 | 14547 | 2021-01-26 | US | New Mexico | Unassigned | 90035 | 3592 | 0 | 0 | 3592 | 36.60569702 | -108.7151824 | 2021-01-27 05:23:41 | Unassigned, New Mexico, US |
18569 | 18569 | 2021-09-18 | US | New Mexico | Unassigned | 90035 | 4817 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-09-19 04:21:34 | Unassigned, New Mexico, US | |
22580 | 22580 | 2021-05-28 | US | New Mexico | Unassigned | 90035 | 4259 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-05-29 04:20:41 | Unassigned, New Mexico, US | |
26618 | 26618 | 2022-03-20 | US | New Mexico | Unassigned | 90035 | 6662 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-03-21 04:20:50 | Unassigned, New Mexico, US | |
30633 | 30633 | 2021-11-11 | US | New Mexico | Unassigned | 90035 | 5039 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-12 04:22:01 | Unassigned, New Mexico, US | |
34629 | 34629 | 2021-08-25 | US | New Mexico | Unassigned | 90035 | 4734 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-08-26 04:21:28 | Unassigned, New Mexico, US | |
38619 | 38619 | 2021-04-12 | US | New Mexico | Harding | 35021 | 9 | 0 | 0 | 35.85751555 | -103.8220938 | 2021-04-13 04:20:37 | Harding, New Mexico, US | |
38639 | 38639 | 2021-04-12 | US | New Mexico | Unassigned | 90035 | 4109 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-04-13 04:20:37 | Unassigned, New Mexico, US | |
40712 | 40712 | 2020-04-13 | US | New Mexico | Catron | 35003 | 1 | 0 | 0 | 1 | 33.91514144 | -108.4046587 | 2020-04-13 23:07:54 | Catron, New Mexico, US |
40742 | 40742 | 2020-04-13 | US | New Mexico | Chaves | 35005 | 19 | 0 | 0 | 19 | 33.36406072 | -104.4665365 | 2020-04-13 23:07:54 | Chaves, New Mexico, US |
40856 | 40856 | 2020-04-13 | US | New Mexico | Colfax | 35007 | 2 | 0 | 0 | 2 | 36.60569702 | -104.64726740000002 | 2020-04-13 23:07:54 | Colfax, New Mexico, US |
40944 | 40944 | 2020-04-13 | US | New Mexico | Curry | 35009 | 10 | 0 | 0 | 10 | 34.57421077 | -103.34688759999999 | 2020-04-13 23:07:54 | Curry, New Mexico, US |
41267 | 41267 | 2020-04-13 | US | New Mexico | Grant | 35017 | 9 | 0 | 0 | 9 | 32.73911281 | -108.3827845 | 2020-04-13 23:07:54 | Grant, New Mexico, US |
41410 | 41410 | 2020-04-13 | US | New Mexico | Hidalgo | 35023 | 0 | 0 | 0 | 0 | 31.91383467 | -108.7151824 | 2020-04-13 23:07:54 | Hidalgo, New Mexico, US |
41706 | 41706 | 2020-04-13 | US | New Mexico | Lea | 35025 | 2 | 0 | 0 | 2 | 32.79215361 | -103.4123733 | 2020-04-13 23:07:54 | Lea, New Mexico, US |
41760 | 41760 | 2020-04-13 | US | New Mexico | Lincoln | 35027 | 1 | 0 | 0 | 1 | 33.74526079 | -105.4586166 | 2020-04-13 23:07:54 | Lincoln, New Mexico, US |
41791 | 41791 | 2020-04-13 | US | New Mexico | Los Alamos | 35028 | 5 | 0 | 0 | 5 | 35.86631386 | -106.31349850000001 | 2020-04-13 23:07:54 | Los Alamos, New Mexico, US |
41805 | 41805 | 2020-04-13 | US | New Mexico | Luna | 35029 | 2 | 0 | 0 | 2 | 32.18179341 | -107.75088259999998 | 2020-04-13 23:07:54 | Luna, New Mexico, US |
42191 | 42191 | 2020-04-13 | US | New Mexico | Otero | 35035 | 4 | 0 | 0 | 4 | 32.61348406 | -105.7417604 | 2020-04-13 23:07:54 | Otero, New Mexico, US |
42367 | 42367 | 2020-04-13 | US | New Mexico | Quay | 35037 | 1 | 0 | 0 | 1 | 35.10403332 | -103.54817270000001 | 2020-04-13 23:07:54 | Quay, New Mexico, US |
42416 | 42416 | 2020-04-13 | US | New Mexico | Rio Arriba | 35039 | 7 | 0 | 0 | 7 | 36.51072137 | -106.69316740000001 | 2020-04-13 23:07:54 | Rio Arriba, New Mexico, US |
42445 | 42445 | 2020-04-13 | US | New Mexico | Roosevelt | 35041 | 1 | 0 | 0 | 1 | 34.02097406 | -103.4799493 | 2020-04-13 23:07:54 | Roosevelt, New Mexico, US |
42488 | 42488 | 2020-04-13 | US | New Mexico | San Miguel | 35047 | 1 | 0 | 0 | 1 | 35.48014807 | -104.8163562 | 2020-04-13 23:07:54 | San Miguel, New Mexico, US |
42499 | 42499 | 2020-04-13 | US | New Mexico | Santa Fe | 35049 | 75 | 0 | 0 | 75 | 35.50708973 | -105.9774716 | 2020-04-13 23:07:54 | Santa Fe, New Mexico, US |
42581 | 42581 | 2020-04-13 | US | New Mexico | Socorro | 35053 | 12 | 0 | 0 | 12 | 34.00715494 | -106.9298354 | 2020-04-13 23:07:54 | Socorro, New Mexico, US |
42698 | 42698 | 2020-04-13 | US | New Mexico | Taos | 35055 | 15 | 0 | 0 | 15 | 36.58006022 | -105.63101979999999 | 2020-04-13 23:07:54 | Taos, New Mexico, US |
42743 | 42743 | 2020-04-13 | US | New Mexico | Torrance | 35057 | 10 | 0 | 0 | 10 | 34.64048375 | -105.8508949 | 2020-04-13 23:07:54 | Torrance, New Mexico, US |
42802 | 42802 | 2020-04-13 | US | New Mexico | Unassigned | 90035 | 0 | 0 | 0 | 0 | 36.60569702 | -108.7151824 | 2020-04-13 23:07:54 | Unassigned, New Mexico, US |
42840 | 42840 | 2020-04-13 | US | New Mexico | Valencia | 35061 | 18 | 0 | 0 | 18 | 34.71669834 | -106.8103733 | 2020-04-13 23:07:54 | Valencia, New Mexico, US |
45925 | 45925 | 2021-11-02 | US | New Mexico | Unassigned | 90035 | 4989 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-03 06:22:09 | Unassigned, New Mexico, US | |
47772 | 47772 | 2020-04-17 | US | New Mexico | Catron | 35003 | 1 | 0 | 0 | 1 | 33.91514144 | -108.4046587 | 2020-04-17 23:30:52 | Catron, New Mexico, US |
47803 | 47803 | 2020-04-17 | US | New Mexico | Chaves | 35005 | 19 | 0 | 0 | 19 | 33.36406072 | -104.4665365 | 2020-04-17 23:30:52 | Chaves, New Mexico, US |
47919 | 47919 | 2020-04-17 | US | New Mexico | Colfax | 35007 | 3 | 0 | 0 | 3 | 36.60569702 | -104.64726740000002 | 2020-04-17 23:30:52 | Colfax, New Mexico, US |
48007 | 48007 | 2020-04-17 | US | New Mexico | Curry | 35009 | 10 | 0 | 0 | 10 | 34.57421077 | -103.34688759999999 | 2020-04-17 23:30:52 | Curry, New Mexico, US |
48331 | 48331 | 2020-04-17 | US | New Mexico | Grant | 35017 | 12 | 0 | 0 | 12 | 32.73911281 | -108.3827845 | 2020-04-17 23:30:52 | Grant, New Mexico, US |
48476 | 48476 | 2020-04-17 | US | New Mexico | Hidalgo | 35023 | 0 | 0 | 0 | 0 | 31.91383467 | -108.7151824 | 2020-04-17 23:30:52 | Hidalgo, New Mexico, US |
48777 | 48777 | 2020-04-17 | US | New Mexico | Lea | 35025 | 2 | 0 | 0 | 2 | 32.79215361 | -103.4123733 | 2020-04-17 23:30:52 | Lea, New Mexico, US |
48831 | 48831 | 2020-04-17 | US | New Mexico | Lincoln | 35027 | 1 | 0 | 0 | 1 | 33.74526079 | -105.4586166 | 2020-04-17 23:30:52 | Lincoln, New Mexico, US |
48864 | 48864 | 2020-04-17 | US | New Mexico | Los Alamos | 35028 | 6 | 0 | 0 | 6 | 35.86631386 | -106.31349850000001 | 2020-04-17 23:30:52 | Los Alamos, New Mexico, US |
48878 | 48878 | 2020-04-17 | US | New Mexico | Luna | 35029 | 3 | 0 | 0 | 3 | 32.18179341 | -107.75088259999998 | 2020-04-17 23:30:52 | Luna, New Mexico, US |
49273 | 49273 | 2020-04-17 | US | New Mexico | Otero | 35035 | 3 | 0 | 0 | 3 | 32.61348406 | -105.7417604 | 2020-04-17 23:30:52 | Otero, New Mexico, US |
49452 | 49452 | 2020-04-17 | US | New Mexico | Quay | 35037 | 1 | 0 | 0 | 1 | 35.10403332 | -103.54817270000001 | 2020-04-17 23:30:52 | Quay, New Mexico, US |
49502 | 49502 | 2020-04-17 | US | New Mexico | Rio Arriba | 35039 | 10 | 0 | 0 | 10 | 36.51072137 | -106.69316740000001 | 2020-04-17 23:30:52 | Rio Arriba, New Mexico, US |
49532 | 49532 | 2020-04-17 | US | New Mexico | Roosevelt | 35041 | 1 | 0 | 0 | 1 | 34.02097406 | -103.4799493 | 2020-04-17 23:30:52 | Roosevelt, New Mexico, US |
49577 | 49577 | 2020-04-17 | US | New Mexico | San Miguel | 35047 | 2 | 0 | 0 | 2 | 35.48014807 | -104.8163562 | 2020-04-17 23:30:52 | San Miguel, New Mexico, US |
49588 | 49588 | 2020-04-17 | US | New Mexico | Santa Fe | 35049 | 79 | 0 | 0 | 79 | 35.50708973 | -105.9774716 | 2020-04-17 23:30:52 | Santa Fe, New Mexico, US |
49673 | 49673 | 2020-04-17 | US | New Mexico | Socorro | 35053 | 20 | 0 | 0 | 20 | 34.00715494 | -106.9298354 | 2020-04-17 23:30:52 | Socorro, New Mexico, US |
49790 | 49790 | 2020-04-17 | US | New Mexico | Taos | 35055 | 15 | 0 | 0 | 15 | 36.58006022 | -105.63101979999999 | 2020-04-17 23:30:52 | Taos, New Mexico, US |
49835 | 49835 | 2020-04-17 | US | New Mexico | Torrance | 35057 | 12 | 0 | 0 | 12 | 34.64048375 | -105.8508949 | 2020-04-17 23:30:52 | Torrance, New Mexico, US |
49895 | 49895 | 2020-04-17 | US | New Mexico | Unassigned | 90035 | 0 | 0 | 0 | 0 | 36.60569702 | -108.7151824 | 2020-04-17 23:30:52 | Unassigned, New Mexico, US |
49935 | 49935 | 2020-04-17 | US | New Mexico | Valencia | 35061 | 24 | 0 | 0 | 24 | 34.71669834 | -106.8103733 | 2020-04-17 23:30:52 | Valencia, New Mexico, US |
53001 | 53001 | 2021-05-29 | US | New Mexico | Unassigned | 90035 | 4259 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-05-30 04:20:55 | Unassigned, New Mexico, US | |
56987 | 56987 | 2021-03-07 | US | New Mexico | De Baca | 35011 | 132 | 0 | 0 | 34.34274529 | -104.4117842 | 2021-03-08 05:24:48 | De Baca, New Mexico, US | |
56992 | 56992 | 2021-03-07 | US | New Mexico | Harding | 35021 | 8 | 0 | 0 | 35.85751555 | -103.8220938 | 2021-03-08 05:24:48 | Harding, New Mexico, US | |
59258 | 59258 | 2020-07-23 | US | New Mexico | De Baca | 35011 | 0 | 0 | 0 | 0 | 34.34274529 | -104.4117842 | 2020-07-24 05:30:40 | De Baca, New Mexico, US |
59659 | 59659 | 2020-07-23 | US | New Mexico | Guadalupe | 35019 | 27 | 0 | 0 | 27 | 34.86319296 | -104.790669 | 2020-07-24 05:30:40 | Guadalupe, New Mexico, US |
59723 | 59723 | 2020-07-23 | US | New Mexico | Harding | 35021 | 1 | 0 | 0 | 1 | 35.85751555 | -103.8220938 | 2020-07-24 05:30:40 | Harding, New Mexico, US |
59788 | 59788 | 2020-07-23 | US | New Mexico | Hidalgo | 35023 | 84 | 0 | 0 | 84 | 31.91383467 | -108.7151824 | 2020-07-24 05:30:40 | Hidalgo, New Mexico, US |
60240 | 60240 | 2020-07-23 | US | New Mexico | Los Alamos | 35028 | 16 | 0 | 0 | 16 | 35.86631386 | -106.3134985 | 2020-07-24 05:30:40 | Los Alamos, New Mexico, US |
60529 | 60529 | 2020-07-23 | US | New Mexico | Mora | 35033 | 6 | 0 | 0 | 6 | 36.01095101 | -104.9497716 | 2020-07-24 05:30:40 | Mora, New Mexico, US |
61054 | 61054 | 2020-07-23 | US | New Mexico | San Miguel | 35047 | 35 | 0 | 0 | 35 | 35.48014807 | -104.8163562 | 2020-07-24 05:30:40 | San Miguel, New Mexico, US |
61151 | 61151 | 2020-07-23 | US | New Mexico | Sierra | 35051 | 22 | 0 | 0 | 22 | 33.13028233 | -107.1925893 | 2020-07-24 05:30:40 | Sierra, New Mexico, US |
61425 | 61425 | 2020-07-23 | US | New Mexico | Unassigned | 90035 | 964 | 0 | 0 | 964 | 36.60569702 | -108.7151824 | 2020-07-24 05:30:40 | Unassigned, New Mexico, US |
61457 | 61457 | 2020-07-23 | US | New Mexico | Union | 35059 | 17 | 0 | 0 | 17 | 36.48126404 | -103.4709624 | 2020-07-24 05:30:40 | Union, New Mexico, US |
65283 | 65283 | 2022-11-12 | US | New Mexico | Unassigned | 90035 | 7082 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-11-13 04:21:14 | Unassigned, New Mexico, US | |
69274 | 69274 | 2021-09-01 | US | New Mexico | Unassigned | 90035 | 4775 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-09-02 04:21:15 | Unassigned, New Mexico, US | |
73308 | 73308 | 2022-02-07 | US | New Mexico | Unassigned | 90035 | 6306 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-02-08 04:21:15 | Unassigned, New Mexico, US | |
77269 | 77269 | 2020-12-03 | US | New Mexico | De Baca | 35011 | 49 | 0 | 0 | 49 | 34.34274529 | -104.4117842 | 2020-12-04 05:27:27 | De Baca, New Mexico, US |
77274 | 77274 | 2020-12-03 | US | New Mexico | Harding | 35021 | 6 | 0 | 0 | 6 | 35.85751555 | -103.8220938 | 2020-12-04 05:27:27 | Harding, New Mexico, US |
77278 | 77278 | 2020-12-03 | US | New Mexico | Los Alamos | 35028 | 162 | 0 | 0 | 162 | 35.86631386 | -106.3134985 | 2020-12-04 05:27:27 | Los Alamos, New Mexico, US |
77281 | 77281 | 2020-12-03 | US | New Mexico | Mora | 35033 | 41 | 0 | 0 | 41 | 36.01095101 | -104.9497716 | 2020-12-04 05:27:27 | Mora, New Mexico, US |
77294 | 77294 | 2020-12-03 | US | New Mexico | Unassigned | 90035 | 2678 | 0 | 0 | 2678 | 36.60569702 | -108.7151824 | 2020-12-04 05:27:27 | Unassigned, New Mexico, US |
81263 | 81263 | 2020-10-14 | US | New Mexico | De Baca | 35011 | 3 | 0 | 0 | 3 | 34.34274529 | -104.4117842 | 2020-10-15 04:24:28 | De Baca, New Mexico, US |
81268 | 81268 | 2020-10-14 | US | New Mexico | Harding | 35021 | 1 | 0 | 0 | 1 | 35.85751555 | -103.8220938 | 2020-10-15 04:24:28 | Harding, New Mexico, US |
81272 | 81272 | 2020-10-14 | US | New Mexico | Los Alamos | 35028 | 37 | 0 | 0 | 37 | 35.86631386 | -106.3134985 | 2020-10-15 04:24:28 | Los Alamos, New Mexico, US |
81275 | 81275 | 2020-10-14 | US | New Mexico | Mora | 35033 | 10 | 0 | 0 | 10 | 36.01095101 | -104.9497716 | 2020-10-15 04:24:28 | Mora, New Mexico, US |
81281 | 81281 | 2020-10-14 | US | New Mexico | San Miguel | 35047 | 125 | 0 | 0 | 125 | 35.48014807 | -104.8163562 | 2020-10-15 04:24:28 | San Miguel, New Mexico, US |
81288 | 81288 | 2020-10-14 | US | New Mexico | Unassigned | 90035 | 1447 | 0 | 0 | 1447 | 36.60569702 | -108.7151824 | 2020-10-15 04:24:28 | Unassigned, New Mexico, US |
85284 | 85284 | 2021-05-25 | US | New Mexico | Harding | 35021 | 12 | 0 | 0 | 35.85751555 | -103.8220938 | 2021-05-26 04:20:35 | Harding, New Mexico, US | |
89342 | 89342 | 2021-11-09 | US | New Mexico | Unassigned | 90035 | 5039 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-10 04:21:38 | Unassigned, New Mexico, US | |
93360 | 93360 | 2022-07-23 | US | New Mexico | Unassigned | 90035 | 6923 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-07-24 04:20:47 | Unassigned, New Mexico, US | |
95581 | 95581 | 2020-08-04 | US | New Mexico | De Baca | 35011 | 0 | 0 | 0 | 0 | 34.34274529 | -104.4117842 | 2020-08-05 04:34:43 | De Baca, New Mexico, US |
95984 | 95984 | 2020-08-04 | US | New Mexico | Guadalupe | 35019 | 31 | 0 | 0 | 31 | 34.86319296 | -104.790669 | 2020-08-05 04:34:43 | Guadalupe, New Mexico, US |
96048 | 96048 | 2020-08-04 | US | New Mexico | Harding | 35021 | 1 | 0 | 0 | 1 | 35.85751555 | -103.8220938 | 2020-08-05 04:34:43 | Harding, New Mexico, US |
96113 | 96113 | 2020-08-04 | US | New Mexico | Hidalgo | 35023 | 88 | 0 | 0 | 88 | 31.91383467 | -108.7151824 | 2020-08-05 04:34:43 | Hidalgo, New Mexico, US |
96565 | 96565 | 2020-08-04 | US | New Mexico | Los Alamos | 35028 | 20 | 0 | 0 | 20 | 35.86631386 | -106.3134985 | 2020-08-05 04:34:43 | Los Alamos, New Mexico, US |
96856 | 96856 | 2020-08-04 | US | New Mexico | Mora | 35033 | 6 | 0 | 0 | 6 | 36.01095101 | -104.9497716 | 2020-08-05 04:34:43 | Mora, New Mexico, US |
97384 | 97384 | 2020-08-04 | US | New Mexico | San Miguel | 35047 | 42 | 0 | 0 | 42 | 35.48014807 | -104.8163562 | 2020-08-05 04:34:43 | San Miguel, New Mexico, US |
97481 | 97481 | 2020-08-04 | US | New Mexico | Sierra | 35051 | 30 | 0 | 0 | 30 | 33.13028233 | -107.1925893 | 2020-08-05 04:34:43 | Sierra, New Mexico, US |
97754 | 97754 | 2020-08-04 | US | New Mexico | Unassigned | 90035 | 1268 | 0 | 0 | 1268 | 36.60569702 | -108.7151824 | 2020-08-05 04:34:43 | Unassigned, New Mexico, 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]);