johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
954 rows where country_or_region = "Mexico" and province_or_state = "Ciudad de Mexico" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533480 | 2533480 | 2022-05-12 | Mexico | Ciudad de Mexico | 1399114 | 42799 | 0 | 19.4326 | -99.1332 | 2022-05-13 04:20:51 | Ciudad de Mexico, Mexico | |||
3444926 | 3444926 | 2022-05-11 | Mexico | Ciudad de Mexico | 1399114 | 42799 | 0 | 19.4326 | -99.1332 | 2022-05-12 04:20:54 | Ciudad de Mexico, Mexico | |||
3535543 | 3535543 | 2022-05-10 | Mexico | Ciudad de Mexico | 1399114 | 42799 | 0 | 19.4326 | -99.1332 | 2022-05-11 04:20:48 | Ciudad de Mexico, Mexico | |||
222078 | 222078 | 2022-05-09 | Mexico | Ciudad de Mexico | 1399114 | 42799 | 0 | 19.4326 | -99.1332 | 2022-05-10 04:20:50 | Ciudad de Mexico, Mexico | |||
2331463 | 2331463 | 2022-05-08 | Mexico | Ciudad de Mexico | 1397401 | 42794 | 0 | 19.4326 | -99.1332 | 2022-05-09 04:20:54 | Ciudad de Mexico, Mexico | |||
360425 | 360425 | 2022-05-07 | Mexico | Ciudad de Mexico | 1397401 | 42794 | 0 | 19.4326 | -99.1332 | 2022-05-08 04:20:49 | Ciudad de Mexico, Mexico | |||
1397776 | 1397776 | 2022-05-06 | Mexico | Ciudad de Mexico | 1397401 | 42794 | 0 | 19.4326 | -99.1332 | 2022-05-07 04:21:09 | Ciudad de Mexico, Mexico | |||
2598131 | 2598131 | 2022-05-05 | Mexico | Ciudad de Mexico | 1397401 | 42794 | 0 | 19.4326 | -99.1332 | 2022-05-06 04:21:00 | Ciudad de Mexico, Mexico | |||
3265580 | 3265580 | 2022-05-04 | Mexico | Ciudad de Mexico | 1397401 | 42794 | 0 | 19.4326 | -99.1332 | 2022-05-05 04:20:55 | Ciudad de Mexico, Mexico | |||
1572219 | 1572219 | 2022-05-03 | Mexico | Ciudad de Mexico | 1397401 | 42794 | 0 | 19.4326 | -99.1332 | 2022-05-04 04:20:59 | Ciudad de Mexico, Mexico | |||
463479 | 463479 | 2022-05-02 | Mexico | Ciudad de Mexico | 1397483 | 42795 | 0 | 19.4326 | -99.1332 | 2022-05-03 04:21:00 | Ciudad de Mexico, Mexico | |||
3916118 | 3916118 | 2022-05-01 | Mexico | Ciudad de Mexico | 1397401 | 42794 | 0 | 19.4326 | -99.1332 | 2022-05-02 04:21:10 | Ciudad de Mexico, Mexico | |||
2840922 | 2840922 | 2022-04-30 | Mexico | Ciudad de Mexico | 1397401 | 42794 | 0 | 19.4326 | -99.1332 | 2022-05-01 04:20:57 | Ciudad de Mexico, Mexico | |||
1157235 | 1157235 | 2022-04-29 | Mexico | Ciudad de Mexico | 1397085 | 42789 | 0 | 19.4326 | -99.1332 | 2022-04-30 04:21:05 | Ciudad de Mexico, Mexico | |||
1696417 | 1696417 | 2022-04-28 | Mexico | Ciudad de Mexico | 1396824 | 42788 | 0 | 19.4326 | -99.1332 | 2022-04-29 04:20:59 | Ciudad de Mexico, Mexico | |||
3851900 | 3851900 | 2022-04-27 | Mexico | Ciudad de Mexico | 1396323 | 42787 | 0 | 19.4326 | -99.1332 | 2022-04-28 04:20:47 | Ciudad de Mexico, Mexico | |||
1326330 | 1326330 | 2022-04-26 | Mexico | Ciudad de Mexico | 1395889 | 42772 | 0 | 19.4326 | -99.1332 | 2022-04-27 04:20:52 | Ciudad de Mexico, Mexico | |||
3722284 | 3722284 | 2022-04-25 | Mexico | Ciudad de Mexico | 1395484 | 42769 | 0 | 19.4326 | -99.1332 | 2022-04-26 04:20:51 | Ciudad de Mexico, Mexico | |||
2028852 | 2028852 | 2022-04-24 | Mexico | Ciudad de Mexico | 1395445 | 42767 | 0 | 19.4326 | -99.1332 | 2022-04-25 04:20:56 | Ciudad de Mexico, Mexico | |||
746427 | 746427 | 2022-04-23 | Mexico | Ciudad de Mexico | 1395351 | 42766 | 0 | 19.4326 | -99.1332 | 2022-04-24 04:20:56 | Ciudad de Mexico, Mexico | |||
3436912 | 3436912 | 2022-04-22 | Mexico | Ciudad de Mexico | 1394698 | 42757 | 0 | 19.4326 | -99.1332 | 2022-04-23 04:20:50 | Ciudad de Mexico, Mexico | |||
2892497 | 2892497 | 2022-04-21 | Mexico | Ciudad de Mexico | 1394698 | 42757 | 0 | 19.4326 | -99.1332 | 2022-04-22 04:20:45 | Ciudad de Mexico, Mexico | |||
2307369 | 2307369 | 2022-04-20 | Mexico | Ciudad de Mexico | 1394311 | 42755 | 0 | 19.4326 | -99.1332 | 2022-04-21 04:20:46 | Ciudad de Mexico, Mexico | |||
2251508 | 2251508 | 2022-04-19 | Mexico | Ciudad de Mexico | 1393937 | 42750 | 0 | 19.4326 | -99.1332 | 2022-04-20 04:20:45 | Ciudad de Mexico, Mexico | |||
1846058 | 1846058 | 2022-04-18 | Mexico | Ciudad de Mexico | 1393367 | 42748 | 0 | 19.4326 | -99.1332 | 2022-04-19 04:21:00 | Ciudad de Mexico, Mexico | |||
3417002 | 3417002 | 2022-04-17 | Mexico | Ciudad de Mexico | 1393367 | 42748 | 0 | 19.4326 | -99.1332 | 2022-04-18 04:21:12 | Ciudad de Mexico, Mexico | |||
303951 | 303951 | 2022-04-16 | Mexico | Ciudad de Mexico | 1393189 | 42747 | 0 | 19.4326 | -99.1332 | 2022-04-17 04:20:59 | Ciudad de Mexico, Mexico | |||
2669896 | 2669896 | 2022-04-15 | Mexico | Ciudad de Mexico | 1393085 | 42742 | 0 | 19.4326 | -99.1332 | 2022-04-16 04:20:48 | Ciudad de Mexico, Mexico | |||
1223681 | 1223681 | 2022-04-14 | Mexico | Ciudad de Mexico | 1392866 | 42741 | 0 | 19.4326 | -99.1332 | 2022-04-15 04:20:57 | Ciudad de Mexico, Mexico | |||
2442839 | 2442839 | 2022-04-13 | Mexico | Ciudad de Mexico | 1392603 | 42736 | 0 | 19.4326 | -99.1332 | 2022-04-13 23:21:06 | Ciudad de Mexico, Mexico | |||
1948596 | 1948596 | 2022-04-12 | Mexico | Ciudad de Mexico | 1392296 | 42722 | 0 | 19.4326 | -99.1332 | 2022-04-13 04:21:03 | Ciudad de Mexico, Mexico | |||
3206349 | 3206349 | 2022-04-11 | Mexico | Ciudad de Mexico | 1392063 | 42697 | 0 | 19.4326 | -99.1332 | 2022-04-12 04:20:49 | Ciudad de Mexico, Mexico | |||
1576235 | 1576235 | 2022-04-10 | Mexico | Ciudad de Mexico | 1392021 | 42697 | 0 | 19.4326 | -99.1332 | 2022-04-11 04:21:02 | Ciudad de Mexico, Mexico | |||
1652477 | 1652477 | 2022-04-09 | Mexico | Ciudad de Mexico | 1391858 | 42697 | 0 | 19.4326 | -99.1332 | 2022-04-10 04:20:52 | Ciudad de Mexico, Mexico | |||
2115799 | 2115799 | 2022-04-08 | Mexico | Ciudad de Mexico | 1391396 | 42692 | 0 | 19.4326 | -99.1332 | 2022-04-09 04:20:42 | Ciudad de Mexico, Mexico | |||
3320323 | 3320323 | 2022-04-07 | Mexico | Ciudad de Mexico | 1390691 | 42669 | 0 | 19.4326 | -99.1332 | 2022-04-08 04:20:48 | Ciudad de Mexico, Mexico | |||
2800859 | 2800859 | 2022-04-06 | Mexico | Ciudad de Mexico | 1389140 | 42650 | 0 | 19.4326 | -99.1332 | 2022-04-07 04:20:53 | Ciudad de Mexico, Mexico | |||
3867628 | 3867628 | 2022-04-05 | Mexico | Ciudad de Mexico | 1388201 | 42640 | 0 | 19.4326 | -99.1332 | 2022-04-06 04:20:49 | Ciudad de Mexico, Mexico | |||
2748970 | 2748970 | 2022-04-04 | Mexico | Ciudad de Mexico | 1387670 | 42628 | 0 | 19.4326 | -99.1332 | 2022-04-05 04:20:48 | Ciudad de Mexico, Mexico | |||
3730316 | 3730316 | 2022-04-03 | Mexico | Ciudad de Mexico | 1387532 | 42626 | 0 | 19.4326 | -99.1332 | 2022-04-04 04:20:51 | Ciudad de Mexico, Mexico | |||
499751 | 499751 | 2022-04-02 | Mexico | Ciudad de Mexico | 1387287 | 42625 | 0 | 19.4326 | -99.1332 | 2022-04-03 04:20:48 | Ciudad de Mexico, Mexico | |||
3350736 | 3350736 | 2022-04-01 | Mexico | Ciudad de Mexico | 1386597 | 42625 | 0 | 19.4326 | -99.1332 | 2022-04-02 04:20:47 | Ciudad de Mexico, Mexico | |||
1540041 | 1540041 | 2022-03-31 | Mexico | Ciudad de Mexico | 1385841 | 42617 | 0 | 19.4326 | -99.1332 | 2022-04-01 04:20:28 | Ciudad de Mexico, Mexico | |||
2478054 | 2478054 | 2022-03-30 | Mexico | Ciudad de Mexico | 1384513 | 42602 | 0 | 19.4326 | -99.1332 | 2022-03-31 04:20:56 | Ciudad de Mexico, Mexico | |||
158095 | 158095 | 2022-03-29 | Mexico | Ciudad de Mexico | 1384513 | 42602 | 0 | 19.4326 | -99.1332 | 2022-03-30 04:20:45 | Ciudad de Mexico, Mexico | |||
1436666 | 1436666 | 2022-03-28 | Mexico | Ciudad de Mexico | 1383907 | 42595 | 0 | 19.4326 | -99.1332 | 2022-03-29 04:20:46 | Ciudad de Mexico, Mexico | |||
876347 | 876347 | 2022-03-27 | Mexico | Ciudad de Mexico | 1383787 | 42591 | 0 | 19.4326 | -99.1332 | 2022-03-28 04:20:33 | Ciudad de Mexico, Mexico | |||
2163630 | 2163630 | 2022-03-26 | Mexico | Ciudad de Mexico | 1382829 | 42581 | 0 | 19.4326 | -99.1332 | 2022-03-27 04:20:47 | Ciudad de Mexico, Mexico | |||
1720566 | 1720566 | 2022-03-25 | Mexico | Ciudad de Mexico | 1382829 | 42581 | 0 | 19.4326 | -99.1332 | 2022-03-26 04:20:23 | Ciudad de Mexico, Mexico | |||
1468183 | 1468183 | 2022-03-24 | Mexico | Ciudad de Mexico | 1381445 | 42560 | 0 | 19.4326 | -99.1332 | 2022-03-25 04:20:46 | Ciudad de Mexico, Mexico | |||
3022357 | 3022357 | 2022-03-23 | Mexico | Ciudad de Mexico | 1380478 | 42541 | 0 | 19.4326 | -99.1332 | 2022-03-24 04:20:43 | Ciudad de Mexico, Mexico | |||
1905279 | 1905279 | 2022-03-22 | Mexico | Ciudad de Mexico | 1380478 | 42541 | 0 | 19.4326 | -99.1332 | 2022-03-23 04:20:48 | Ciudad de Mexico, Mexico | |||
3238410 | 3238410 | 2022-03-21 | Mexico | Ciudad de Mexico | 1380104 | 42531 | 0 | 19.4326 | -99.1332 | 2022-03-22 04:20:54 | Ciudad de Mexico, Mexico | |||
24483 | 24483 | 2022-03-20 | Mexico | Ciudad de Mexico | 1379873 | 42529 | 0 | 19.4326 | -99.1332 | 2022-03-21 04:20:50 | Ciudad de Mexico, Mexico | |||
1656493 | 1656493 | 2022-03-19 | Mexico | Ciudad de Mexico | 1379068 | 42521 | 0 | 19.4326 | -99.1332 | 2022-03-20 04:20:45 | Ciudad de Mexico, Mexico | |||
336019 | 336019 | 2022-03-18 | Mexico | Ciudad de Mexico | 1377867 | 42509 | 0 | 19.4326 | -99.1332 | 2022-03-19 04:20:47 | Ciudad de Mexico, Mexico | |||
694472 | 694472 | 2022-03-17 | Mexico | Ciudad de Mexico | 1377867 | 42509 | 0 | 19.4326 | -99.1332 | 2022-03-18 04:20:55 | Ciudad de Mexico, Mexico | |||
2319415 | 2319415 | 2022-03-16 | Mexico | Ciudad de Mexico | 1375231 | 42458 | 0 | 19.4326 | -99.1332 | 2022-03-17 04:20:56 | Ciudad de Mexico, Mexico | |||
261615 | 261615 | 2022-03-15 | Mexico | Ciudad de Mexico | 1373679 | 42439 | 0 | 19.4326 | -99.1332 | 2022-03-16 04:20:50 | Ciudad de Mexico, Mexico | |||
2263974 | 2263974 | 2022-03-14 | Mexico | Ciudad de Mexico | 1373679 | 42439 | 0 | 19.4326 | -99.1332 | 2022-03-15 04:20:47 | Ciudad de Mexico, Mexico | |||
3628040 | 3628040 | 2022-03-13 | Mexico | Ciudad de Mexico | 1373306 | 42439 | 0 | 19.4326 | -99.1332 | 2022-03-14 04:20:46 | Ciudad de Mexico, Mexico | |||
950948 | 950948 | 2022-03-12 | Mexico | Ciudad de Mexico | 1372979 | 42433 | 0 | 19.4326 | -99.1332 | 2022-03-13 04:20:49 | Ciudad de Mexico, Mexico | |||
356409 | 356409 | 2022-03-11 | Mexico | Ciudad de Mexico | 1370061 | 42389 | 0 | 19.4326 | -99.1332 | 2022-03-12 04:20:50 | Ciudad de Mexico, Mexico | |||
1865561 | 1865561 | 2022-03-10 | Mexico | Ciudad de Mexico | 1370061 | 42389 | 0 | 19.4326 | -99.1332 | 2022-03-11 04:20:50 | Ciudad de Mexico, Mexico | |||
2140256 | 2140256 | 2022-03-09 | Mexico | Ciudad de Mexico | 1368159 | 42359 | 0 | 19.4326 | -99.1332 | 2022-03-10 04:20:48 | Ciudad de Mexico, Mexico | |||
919767 | 919767 | 2022-03-08 | Mexico | Ciudad de Mexico | 1366421 | 42333 | 0 | 19.4326 | -99.1332 | 2022-03-09 04:20:59 | Ciudad de Mexico, Mexico | |||
1548054 | 1548054 | 2022-03-07 | Mexico | Ciudad de Mexico | 1364300 | 42292 | 0 | 19.4326 | -99.1332 | 2022-03-08 04:20:54 | Ciudad de Mexico, Mexico | |||
2199723 | 2199723 | 2022-03-06 | Mexico | Ciudad de Mexico | 1363836 | 42285 | 0 | 19.4326 | -99.1332 | 2022-03-07 04:20:47 | Ciudad de Mexico, Mexico | |||
2092180 | 2092180 | 2022-03-05 | Mexico | Ciudad de Mexico | 1360984 | 42257 | 0 | 19.4326 | -99.1332 | 2022-03-06 04:20:49 | Ciudad de Mexico, Mexico | |||
2665880 | 2665880 | 2022-03-04 | Mexico | Ciudad de Mexico | 1359021 | 42220 | 0 | 19.4326 | -99.1332 | 2022-03-05 04:21:10 | Ciudad de Mexico, Mexico | |||
1644445 | 1644445 | 2022-03-03 | Mexico | Ciudad de Mexico | 1356390 | 42181 | 0 | 19.4326 | -99.1332 | 2022-03-04 04:21:09 | Ciudad de Mexico, Mexico | |||
2525448 | 2525448 | 2022-03-02 | Mexico | Ciudad de Mexico | 1353655 | 42153 | 0 | 19.4326 | -99.1332 | 2022-03-03 04:21:01 | Ciudad de Mexico, Mexico | |||
1992742 | 1992742 | 2022-03-01 | Mexico | Ciudad de Mexico | 1353655 | 42153 | 0 | 19.4326 | -99.1332 | 2022-03-02 04:21:07 | Ciudad de Mexico, Mexico | |||
942916 | 942916 | 2022-02-28 | Mexico | Ciudad de Mexico | 1350114 | 42101 | 0 | 19.4326 | -99.1332 | 2022-03-01 04:21:09 | Ciudad de Mexico, Mexico | |||
2733107 | 2733107 | 2022-02-27 | Mexico | Ciudad de Mexico | 1349542 | 42085 | 0 | 19.4326 | -99.1332 | 2022-02-28 04:21:05 | Ciudad de Mexico, Mexico | |||
3046260 | 3046260 | 2022-02-26 | Mexico | Ciudad de Mexico | 1348398 | 42072 | 0 | 19.4326 | -99.1332 | 2022-02-27 04:21:04 | Ciudad de Mexico, Mexico | |||
574915 | 574915 | 2022-02-25 | Mexico | Ciudad de Mexico | 1345276 | 42047 | 0 | 19.4326 | -99.1332 | 2022-02-26 04:21:12 | Ciudad de Mexico, Mexico | |||
1511491 | 1511491 | 2022-02-24 | Mexico | Ciudad de Mexico | 1342303 | 42013 | 0 | 19.4326 | -99.1332 | 2022-02-25 04:21:11 | Ciudad de Mexico, Mexico | |||
1057932 | 1057932 | 2022-02-23 | Mexico | Ciudad de Mexico | 1337824 | 41988 | 0 | 19.4326 | -99.1332 | 2022-02-24 04:21:14 | Ciudad de Mexico, Mexico | |||
2446855 | 2446855 | 2022-02-22 | Mexico | Ciudad de Mexico | 1329209 | 41913 | 0 | 19.4326 | -99.1332 | 2022-02-23 04:21:09 | Ciudad de Mexico, Mexico | |||
3718268 | 3718268 | 2022-02-21 | Mexico | Ciudad de Mexico | 1327855 | 41902 | 0 | 19.4326 | -99.1332 | 2022-02-22 04:21:01 | Ciudad de Mexico, Mexico | |||
3912102 | 3912102 | 2022-02-20 | Mexico | Ciudad de Mexico | 1327855 | 41902 | 0 | 19.4326 | -99.1332 | 2022-02-21 04:21:05 | Ciudad de Mexico, Mexico | |||
3875660 | 3875660 | 2022-02-19 | Mexico | Ciudad de Mexico | 1326453 | 41880 | 0 | 19.4326 | -99.1332 | 2022-02-20 04:21:00 | Ciudad de Mexico, Mexico | |||
3855916 | 3855916 | 2022-02-18 | Mexico | Ciudad de Mexico | 1317780 | 41785 | 0 | 19.4326 | -99.1332 | 2022-02-19 04:21:11 | Ciudad de Mexico, Mexico | |||
1298135 | 1298135 | 2022-02-17 | Mexico | Ciudad de Mexico | 1317780 | 41785 | 0 | 19.4326 | -99.1332 | 2022-02-18 04:21:04 | Ciudad de Mexico, Mexico | |||
3820521 | 3820521 | 2022-02-16 | Mexico | Ciudad de Mexico | 1312953 | 41742 | 0 | 19.4326 | -99.1332 | 2022-02-17 04:20:56 | Ciudad de Mexico, Mexico | |||
3671735 | 3671735 | 2022-02-15 | Mexico | Ciudad de Mexico | 1302967 | 41670 | 0 | 19.4326 | -99.1332 | 2022-02-16 04:21:10 | Ciudad de Mexico, Mexico | |||
2641836 | 2641836 | 2022-02-14 | Mexico | Ciudad de Mexico | 1300572 | 41651 | 0 | 19.4326 | -99.1332 | 2022-02-15 04:21:09 | Ciudad de Mexico, Mexico | |||
186153 | 186153 | 2022-02-13 | Mexico | Ciudad de Mexico | 1297736 | 41638 | 0 | 19.4326 | -99.1332 | 2022-02-14 04:20:51 | Ciudad de Mexico, Mexico | |||
315999 | 315999 | 2022-02-12 | Mexico | Ciudad de Mexico | 1297736 | 41638 | 0 | 19.4326 | -99.1332 | 2022-02-13 04:21:00 | Ciudad de Mexico, Mexico | |||
233325 | 233325 | 2022-02-11 | Mexico | Ciudad de Mexico | 1285560 | 41538 | 0 | 19.4326 | -99.1332 | 2022-02-12 04:21:06 | Ciudad de Mexico, Mexico | |||
1464167 | 1464167 | 2022-02-10 | Mexico | Ciudad de Mexico | 1278083 | 41452 | 0 | 19.4326 | -99.1332 | 2022-02-11 04:21:09 | Ciudad de Mexico, Mexico | |||
3074128 | 3074128 | 2022-02-09 | Mexico | Ciudad de Mexico | 1278083 | 41452 | 0 | 19.4326 | -99.1332 | 2022-02-10 04:21:14 | Ciudad de Mexico, Mexico | |||
1362435 | 1362435 | 2022-02-08 | Mexico | Ciudad de Mexico | 1272745 | 41387 | 0 | 19.4326 | -99.1332 | 2022-02-09 04:21:04 | Ciudad de Mexico, Mexico | |||
71173 | 71173 | 2022-02-07 | Mexico | Ciudad de Mexico | 1271088 | 41368 | 0 | 19.4326 | -99.1332 | 2022-02-08 04:21:15 | Ciudad de Mexico, Mexico | |||
2012789 | 2012789 | 2022-02-06 | Mexico | Ciudad de Mexico | 1268716 | 41350 | 0 | 19.4326 | -99.1332 | 2022-02-07 04:21:05 | Ciudad de Mexico, Mexico | |||
1294118 | 1294118 | 2022-02-05 | Mexico | Ciudad de Mexico | 1266003 | 41323 | 0 | 19.4326 | -99.1332 | 2022-02-06 04:21:00 | Ciudad de Mexico, Mexico | |||
2327446 | 2327446 | 2022-02-04 | Mexico | Ciudad de Mexico | 1258148 | 41266 | 0 | 19.4326 | -99.1332 | 2022-02-05 04:21:05 | Ciudad de Mexico, Mexico | |||
2474037 | 2474037 | 2022-02-03 | Mexico | Ciudad de Mexico | 1241735 | 41150 | 0 | 19.4326 | -99.1332 | 2022-02-04 04:21:10 | Ciudad de Mexico, Mexico | |||
459462 | 459462 | 2022-02-02 | Mexico | Ciudad de Mexico | 1233164 | 41086 | 0 | 19.4326 | -99.1332 | 2022-02-03 04:21:21 | Ciudad de Mexico, Mexico |
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]);