johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
499 rows where active = 471 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 28
- US 428
- Russia 11
- Colombia 9
- Japan 6
- Mexico 5
- Chile 4
- Andorra 3
- France 3
- Germany 3
- Italy 3
- Spain 3
- Ukraine 3
- India 2
- Sao Tome and Principe 2
- Cabo Verde 1
- Canada 1
- Cote d'Ivoire 1
- Eritrea 1
- Guinea-Bissau 1
- Iceland 1
- Malta 1
- Mauritania 1
- Netherlands 1
- Pakistan 1
- Rwanda 1
- Sierra Leone 1
- Sri Lanka 1
- Vietnam 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2947206 | 2947206 | 2021-07-16 | Colombia | La Guajira | 40579 | 1276 | 38832 | 471 | 11.3548 | -72.5205 | 2021-07-17 04:22:22 | La Guajira, Colombia | ||
3659506 | 3659506 | 2021-07-11 | Germany | Hamburg | 77580 | 1598 | 75600 | 471 | 53.5511 | 9.9937 | 2021-07-12 04:21:34 | Hamburg, Germany | ||
1440438 | 1440438 | 2021-07-07 | Colombia | Putumayo | 14005 | 575 | 12959 | 471 | 0.436 | -75.5277 | 2021-07-08 04:21:26 | Putumayo, Colombia | ||
3962128 | 3962128 | 2021-06-26 | Ukraine | Chernivtsi Oblast | 79930 | 1791 | 77668 | 471 | 48.2917 | 25.9352 | 2021-06-27 04:21:39 | Chernivtsi Oblast, Ukraine | ||
562853 | 562853 | 2021-06-22 | Eritrea | 5508 | 21 | 5016 | 471 | 15.1794 | 39.7823 | 2021-06-23 04:21:46 | Eritrea | |||
3358900 | 3358900 | 2021-06-21 | Russia | North Ossetia - Alania Republic | 17186 | 224 | 16491 | 471 | 42.79336110000001 | 44.6324493 | 2021-06-22 04:21:34 | North Ossetia - Alania Republic, Russia | ||
1736547 | 1736547 | 2021-06-12 | Japan | Shizuoka | 8831 | 143 | 8217 | 471 | 34.916975 | 138.40778400000002 | 2021-06-13 04:22:44 | Shizuoka, Japan | ||
1313804 | 1313804 | 2021-05-26 | Ukraine | Sevastopol* | 14741 | 674 | 13596 | 471 | 44.6054 | 33.522 | 2021-05-27 04:20:59 | Sevastopol*, Ukraine | ||
83167 | 83167 | 2021-05-25 | Mauritania | 19251 | 460 | 18320 | 471 | 21.0079 | -10.9408 | 2021-05-26 04:20:35 | Mauritania | |||
2255577 | 2255577 | 2021-05-19 | Colombia | Choco | 9892 | 259 | 9162 | 471 | 5.2528 | -76.82600000000002 | 2021-05-20 04:21:05 | Choco, Colombia | ||
3242555 | 3242555 | 2021-04-21 | Russia | North Ossetia - Alania Republic | 16636 | 193 | 15972 | 471 | 42.79336110000001 | 44.6324493 | 2021-04-22 04:20:53 | North Ossetia - Alania Republic, Russia | ||
3003332 | 3003332 | 2021-04-06 | Japan | Nara | 4026 | 55 | 3500 | 471 | 34.317451 | 135.871644 | 2021-04-07 04:20:53 | Nara, Japan | ||
2781025 | 2781025 | 2021-03-24 | Japan | Okinawa | 8911 | 126 | 8314 | 471 | 25.768923 | 126.668016 | 2021-03-25 05:27:00 | Okinawa, Japan | ||
3420779 | 3420779 | 2021-03-19 | Colombia | Sucre | 21711 | 812 | 20428 | 471 | 8.814 | -74.7233 | 2021-03-20 05:25:46 | Sucre, Colombia | ||
2359676 | 2359676 | 2021-03-08 | Russia | Khakassia Republic | 21465 | 477 | 20517 | 471 | 53.72258845 | 91.44293627 | 2021-03-09 05:28:19 | Khakassia Republic, Russia | ||
3669714 | 3669714 | 2021-03-06 | US | Nebraska | Morrill | 31123 | 486 | 15 | 0 | 471 | 41.71711774 | -103.0061405 | 2021-03-07 05:21:54 | Morrill, Nebraska, US |
3669575 | 3669575 | 2021-03-06 | US | Missouri | Shannon | 29203 | 483 | 12 | 0 | 471 | 37.15772072 | -91.40190382 | 2021-03-07 05:21:54 | Shannon, Missouri, US |
3669361 | 3669361 | 2021-03-06 | US | Minnesota | Norman | 27107 | 479 | 8 | 0 | 471 | 47.32628443 | -96.45620947 | 2021-03-07 05:21:54 | Norman, Minnesota, US |
1618335 | 1618335 | 2021-03-05 | US | Nebraska | Morrill | 31123 | 486 | 15 | 0 | 471 | 41.71711774 | -103.0061405 | 2021-03-06 04:23:41 | Morrill, Nebraska, US |
1618196 | 1618196 | 2021-03-05 | US | Missouri | Shannon | 29203 | 483 | 12 | 0 | 471 | 37.15772072 | -91.40190382 | 2021-03-06 04:23:41 | Shannon, Missouri, US |
2209746 | 2209746 | 2021-03-04 | US | Nebraska | Morrill | 31123 | 486 | 15 | 0 | 471 | 41.71711774 | -103.0061405 | 2021-03-05 05:26:29 | Morrill, Nebraska, US |
2209686 | 2209686 | 2021-03-04 | US | Nebraska | Antelope | 31003 | 477 | 6 | 0 | 471 | 42.17695516 | -98.0666283 | 2021-03-05 05:26:29 | Antelope, Nebraska, US |
1092167 | 1092167 | 2021-03-03 | US | Nebraska | Morrill | 31123 | 486 | 15 | 0 | 471 | 41.71711774 | -103.0061405 | 2021-03-04 05:24:24 | Morrill, Nebraska, US |
1092107 | 1092107 | 2021-03-03 | US | Nebraska | Antelope | 31003 | 477 | 6 | 0 | 471 | 42.17695516 | -98.0666283 | 2021-03-04 05:24:24 | Antelope, Nebraska, US |
1001542 | 1001542 | 2021-03-01 | US | Texas | Hartley | 48205 | 638 | 2 | 0 | 471 | 35.84008013 | -102.6029022 | 2021-03-02 05:23:30 | Hartley, Texas, US |
1000275 | 1000275 | 2021-03-01 | US | Mississippi | Sharkey | 28125 | 488 | 17 | 0 | 471 | 32.88149103 | -90.8159538 | 2021-03-02 05:23:30 | Sharkey, Mississippi, US |
2370600 | 2370600 | 2021-02-28 | US | Texas | Hartley | 48205 | 638 | 2 | 0 | 471 | 35.84008013 | -102.6029022 | 2021-03-01 05:23:01 | Hartley, Texas, US |
2369450 | 2369450 | 2021-02-28 | US | Missouri | Shannon | 29203 | 481 | 10 | 0 | 471 | 37.15772072 | -91.40190382 | 2021-03-01 05:23:01 | Shannon, Missouri, US |
2369333 | 2369333 | 2021-02-28 | US | Mississippi | Sharkey | 28125 | 488 | 17 | 0 | 471 | 32.88149103 | -90.8159538 | 2021-03-01 05:23:01 | Sharkey, Mississippi, US |
3069102 | 3069102 | 2021-02-27 | US | Texas | Hartley | 48205 | 638 | 2 | 0 | 471 | 35.84008013 | -102.6029022 | 2021-02-28 05:22:20 | Hartley, Texas, US |
3067952 | 3067952 | 2021-02-27 | US | Missouri | Shannon | 29203 | 481 | 10 | 0 | 471 | 37.15772072 | -91.40190382 | 2021-02-28 05:22:20 | Shannon, Missouri, US |
3067835 | 3067835 | 2021-02-27 | US | Mississippi | Sharkey | 28125 | 488 | 17 | 0 | 471 | 32.88149103 | -90.8159538 | 2021-02-28 05:22:20 | Sharkey, Mississippi, US |
3067391 | 3067391 | 2021-02-27 | US | Kentucky | Fulton | 21075 | 477 | 6 | 0 | 471 | 36.55238827 | -89.20140068 | 2021-02-28 05:22:20 | Fulton, Kentucky, US |
2186686 | 2186686 | 2021-02-26 | US | Texas | Hartley | 48205 | 638 | 2 | 0 | 471 | 35.84008013 | -102.6029022 | 2021-02-27 05:22:28 | Hartley, Texas, US |
2185536 | 2185536 | 2021-02-26 | US | Missouri | Shannon | 29203 | 481 | 10 | 0 | 471 | 37.15772072 | -91.40190382 | 2021-02-27 05:22:28 | Shannon, Missouri, US |
2185419 | 2185419 | 2021-02-26 | US | Mississippi | Sharkey | 28125 | 488 | 17 | 0 | 471 | 32.88149103 | -90.8159538 | 2021-02-27 05:22:28 | Sharkey, Mississippi, US |
1861108 | 1861108 | 2021-02-25 | US | Texas | Hartley | 48205 | 638 | 2 | 0 | 471 | 35.84008013 | -102.6029022 | 2021-02-26 05:22:40 | Hartley, Texas, US |
1859958 | 1859958 | 2021-02-25 | US | Missouri | Shannon | 29203 | 481 | 10 | 0 | 471 | 37.15772072 | -91.40190382 | 2021-02-26 05:22:40 | Shannon, Missouri, US |
1859841 | 1859841 | 2021-02-25 | US | Mississippi | Sharkey | 28125 | 488 | 17 | 0 | 471 | 32.88149103 | -90.8159538 | 2021-02-26 05:22:40 | Sharkey, Mississippi, US |
282136 | 282136 | 2021-02-24 | US | Missouri | Shannon | 29203 | 481 | 10 | 0 | 471 | 37.15772072 | -91.40190382 | 2021-02-25 05:24:57 | Shannon, Missouri, US |
282019 | 282019 | 2021-02-24 | US | Mississippi | Sharkey | 28125 | 488 | 17 | 0 | 471 | 32.88149103 | -90.8159538 | 2021-02-25 05:24:57 | Sharkey, Mississippi, US |
281609 | 281609 | 2021-02-24 | US | Kentucky | Lyon | 21143 | 484 | 13 | 0 | 471 | 37.02080035 | -88.07886257 | 2021-02-25 05:24:57 | Lyon, Kentucky, US |
1938642 | 1938642 | 2021-02-23 | US | New Mexico | Los Alamos | 35028 | 475 | 4 | 0 | 471 | 35.86631386 | -106.3134985 | 2021-02-24 05:29:16 | Los Alamos, New Mexico, US |
1938404 | 1938404 | 2021-02-23 | US | Missouri | Shannon | 29203 | 481 | 10 | 0 | 471 | 37.15772072 | -91.40190382 | 2021-02-24 05:29:16 | Shannon, Missouri, US |
1938287 | 1938287 | 2021-02-23 | US | Mississippi | Sharkey | 28125 | 488 | 17 | 0 | 471 | 32.88149103 | -90.8159538 | 2021-02-24 05:29:16 | Sharkey, Mississippi, US |
532542 | 532542 | 2021-02-22 | US | Mississippi | Sharkey | 28125 | 488 | 17 | 0 | 471 | 32.88149103 | -90.8159538 | 2021-02-23 05:23:41 | Sharkey, Mississippi, US |
531663 | 531663 | 2021-02-22 | US | Illinois | Calhoun | 17013 | 473 | 2 | 0 | 471 | 39.16840183 | -90.66330078 | 2021-02-23 05:23:41 | Calhoun, Illinois, US |
183876 | 183876 | 2021-02-21 | US | Mississippi | Sharkey | 28125 | 488 | 17 | 0 | 471 | 32.88149103 | -90.8159538 | 2021-02-22 05:24:21 | Sharkey, Mississippi, US |
182997 | 182997 | 2021-02-21 | US | Illinois | Calhoun | 17013 | 473 | 2 | 0 | 471 | 39.16840183 | -90.66330078 | 2021-02-22 05:24:21 | Calhoun, Illinois, US |
744150 | 744150 | 2021-02-20 | US | Mississippi | Sharkey | 28125 | 488 | 17 | 0 | 471 | 32.88149103 | -90.8159538 | 2021-02-21 05:24:33 | Sharkey, Mississippi, US |
743271 | 743271 | 2021-02-20 | US | Illinois | Calhoun | 17013 | 473 | 2 | 0 | 471 | 39.16840183 | -90.66330078 | 2021-02-21 05:24:33 | Calhoun, Illinois, US |
742163 | 742163 | 2021-02-20 | Colombia | Huila | 49254 | 1695 | 47088 | 471 | 2.5359 | -75.5277 | 2021-02-21 05:24:33 | Huila, Colombia | ||
473248 | 473248 | 2021-02-19 | US | Mississippi | Sharkey | 28125 | 488 | 17 | 0 | 471 | 32.88149103 | -90.8159538 | 2021-02-20 05:22:51 | Sharkey, Mississippi, US |
1154957 | 1154957 | 2021-02-18 | US | Mississippi | Sharkey | 28125 | 488 | 17 | 0 | 471 | 32.88149103 | -90.8159538 | 2021-02-19 05:24:16 | Sharkey, Mississippi, US |
1154058 | 1154058 | 2021-02-18 | US | Idaho | Lincoln | 16063 | 482 | 11 | 0 | 471 | 43.0012336 | -114.1358773 | 2021-02-19 05:24:16 | Lincoln, Idaho, US |
3602877 | 3602877 | 2021-02-17 | US | Mississippi | Sharkey | 28125 | 488 | 17 | 0 | 471 | 32.88149103 | -90.8159538 | 2021-02-18 05:22:58 | Sharkey, Mississippi, US |
3602752 | 3602752 | 2021-02-17 | US | Minnesota | Grant | 27051 | 479 | 8 | 0 | 471 | 45.93424769 | -96.01139609 | 2021-02-18 05:22:58 | Grant, Minnesota, US |
3601978 | 3601978 | 2021-02-17 | US | Idaho | Lincoln | 16063 | 482 | 11 | 0 | 471 | 43.0012336 | -114.1358773 | 2021-02-18 05:22:58 | Lincoln, Idaho, US |
3600970 | 3600970 | 2021-02-17 | Guinea-Bissau | 2999 | 46 | 2482 | 471 | 11.8037 | -15.1804 | 2021-02-18 05:22:58 | Guinea-Bissau | |||
3052012 | 3052012 | 2021-02-16 | US | Mississippi | Sharkey | 28125 | 488 | 17 | 0 | 471 | 32.88149103 | -90.8159538 | 2021-02-17 05:23:10 | Sharkey, Mississippi, US |
3051113 | 3051113 | 2021-02-16 | US | Idaho | Lincoln | 16063 | 482 | 11 | 0 | 471 | 43.0012336 | -114.1358773 | 2021-02-17 05:23:10 | Lincoln, Idaho, US |
1340111 | 1340111 | 2021-02-15 | US | Mississippi | Sharkey | 28125 | 488 | 17 | 0 | 471 | 32.88149103 | -90.8159538 | 2021-02-16 05:24:38 | Sharkey, Mississippi, US |
2679807 | 2679807 | 2021-02-13 | US | Montana | Chouteau | 30015 | 476 | 5 | 0 | 471 | 47.88084126 | -110.4353362 | 2021-02-14 05:23:43 | Chouteau, Montana, US |
3542614 | 3542614 | 2021-02-12 | US | Texas | Marion | 48315 | 577 | 24 | 0 | 471 | 32.79868409 | -94.3566123 | 2021-02-13 05:22:12 | Marion, Texas, US |
3542396 | 3542396 | 2021-02-12 | US | Tennessee | Hancock | 47067 | 498 | 11 | 0 | 471 | 36.52692871 | -83.22375847 | 2021-02-13 05:22:12 | Hancock, Tennessee, US |
3541440 | 3541440 | 2021-02-12 | US | Montana | Chouteau | 30015 | 476 | 5 | 0 | 471 | 47.88084126 | -110.4353362 | 2021-02-13 05:22:12 | Chouteau, Montana, US |
2640659 | 2640659 | 2021-02-11 | US | Tennessee | Hancock | 47067 | 495 | 9 | 0 | 471 | 36.52692871 | -83.22375847 | 2021-02-12 05:23:29 | Hancock, Tennessee, US |
2639731 | 2639731 | 2021-02-11 | US | Montana | Phillips | 30071 | 485 | 14 | 0 | 471 | 48.25936577 | -107.9128511 | 2021-02-12 05:23:29 | Phillips, Montana, US |
2639703 | 2639703 | 2021-02-11 | US | Montana | Chouteau | 30015 | 476 | 5 | 0 | 471 | 47.88084126 | -110.4353362 | 2021-02-12 05:23:29 | Chouteau, Montana, US |
2638659 | 2638659 | 2021-02-11 | US | Idaho | Lincoln | 16063 | 481 | 10 | 0 | 471 | 43.0012336 | -114.1358773 | 2021-02-12 05:23:29 | Lincoln, Idaho, US |
3982080 | 3982080 | 2021-02-10 | US | West Virginia | Roane | 54087 | 477 | 6 | 0 | 471 | 38.71622686 | -81.35243568 | 2021-02-11 05:23:55 | Roane, West Virginia, US |
3980586 | 3980586 | 2021-02-10 | US | Montana | Phillips | 30071 | 485 | 14 | 0 | 471 | 48.25936577 | -107.9128511 | 2021-02-11 05:23:55 | Phillips, Montana, US |
3979514 | 3979514 | 2021-02-10 | US | Idaho | Lincoln | 16063 | 481 | 10 | 0 | 471 | 43.0012336 | -114.1358773 | 2021-02-11 05:23:55 | Lincoln, Idaho, US |
1531400 | 1531400 | 2021-02-09 | US | West Virginia | Roane | 54087 | 477 | 6 | 0 | 471 | 38.71622686 | -81.35243568 | 2021-02-10 05:22:41 | Roane, West Virginia, US |
1529906 | 1529906 | 2021-02-09 | US | Montana | Phillips | 30071 | 485 | 14 | 0 | 471 | 48.25936577 | -107.9128511 | 2021-02-10 05:22:41 | Phillips, Montana, US |
1529263 | 1529263 | 2021-02-09 | US | Kentucky | Bracken | 21023 | 475 | 4 | 0 | 471 | 38.69158994 | -84.08532444 | 2021-02-10 05:22:41 | Bracken, Kentucky, US |
1528834 | 1528834 | 2021-02-09 | US | Idaho | Lincoln | 16063 | 481 | 10 | 0 | 471 | 43.0012336 | -114.1358773 | 2021-02-10 05:22:41 | Lincoln, Idaho, US |
617191 | 617191 | 2021-02-08 | US | West Virginia | Roane | 54087 | 477 | 6 | 0 | 471 | 38.71622686 | -81.35243568 | 2021-02-09 05:23:30 | Roane, West Virginia, US |
615751 | 615751 | 2021-02-08 | US | Nebraska | Furnas | 31065 | 475 | 4 | 0 | 471 | 40.17642064 | -99.91247454 | 2021-02-09 05:23:30 | Furnas, Nebraska, US |
614575 | 614575 | 2021-02-08 | US | Georgia | Warren | 13301 | 481 | 10 | 0 | 471 | 33.41146451 | -82.67795848 | 2021-02-09 05:23:30 | Warren, Georgia, US |
1675960 | 1675960 | 2021-02-07 | US | West Virginia | Roane | 54087 | 477 | 6 | 0 | 471 | 38.71622686 | -81.35243568 | 2021-02-08 05:22:39 | Roane, West Virginia, US |
1674520 | 1674520 | 2021-02-07 | US | Nebraska | Furnas | 31065 | 475 | 4 | 0 | 471 | 40.17642064 | -99.91247454 | 2021-02-08 05:22:39 | Furnas, Nebraska, US |
1673344 | 1673344 | 2021-02-07 | US | Georgia | Warren | 13301 | 481 | 10 | 0 | 471 | 33.41146451 | -82.67795848 | 2021-02-08 05:22:39 | Warren, Georgia, US |
976981 | 976981 | 2021-02-06 | US | Nebraska | Furnas | 31065 | 475 | 4 | 0 | 471 | 40.17642064 | -99.91247454 | 2021-02-07 05:23:00 | Furnas, Nebraska, US |
1589111 | 1589111 | 2021-02-05 | US | Idaho | Lemhi | 16059 | 480 | 9 | 0 | 471 | 44.9438088 | -113.9309747 | 2021-02-06 05:23:55 | Lemhi, Idaho, US |
792074 | 792074 | 2021-02-04 | US | Minnesota | Big Stone | 27011 | 474 | 3 | 0 | 471 | 45.42712824 | -96.41403739 | 2021-02-05 05:22:38 | Big Stone, Minnesota, US |
791318 | 791318 | 2021-02-04 | US | Idaho | Lemhi | 16059 | 480 | 9 | 0 | 471 | 44.9438088 | -113.9309747 | 2021-02-05 05:22:38 | Lemhi, Idaho, US |
342311 | 342311 | 2021-02-03 | US | Nebraska | Boone | 31011 | 475 | 4 | 0 | 471 | 41.70759415 | -98.06737183 | 2021-02-04 05:22:26 | Boone, Nebraska, US |
341966 | 341966 | 2021-02-03 | US | Minnesota | Big Stone | 27011 | 474 | 3 | 0 | 471 | 45.42712824 | -96.41403739 | 2021-02-04 05:22:26 | Big Stone, Minnesota, US |
341261 | 341261 | 2021-02-03 | US | Illinois | Henderson | 17071 | 479 | 8 | 0 | 471 | 40.81908672 | -90.92491462 | 2021-02-04 05:22:26 | Henderson, Illinois, US |
341210 | 341210 | 2021-02-03 | US | Idaho | Lemhi | 16059 | 480 | 9 | 0 | 471 | 44.9438088 | -113.9309747 | 2021-02-04 05:22:26 | Lemhi, Idaho, US |
1685808 | 1685808 | 2021-02-02 | US | Kansas | Meade | 20119 | 478 | 7 | 0 | 471 | 37.23859987 | -100.364831 | 2021-02-03 05:22:52 | Meade, Kansas, US |
1677778 | 1677778 | 2021-02-01 | US | Kansas | Meade | 20119 | 478 | 7 | 0 | 471 | 37.23859987 | -100.364831 | 2021-02-02 05:22:49 | Meade, Kansas, US |
1461066 | 1461066 | 2021-01-31 | US | Kansas | Meade | 20119 | 478 | 7 | 0 | 471 | 37.23859987 | -100.364831 | 2021-02-01 05:22:53 | Meade, Kansas, US |
2214529 | 2214529 | 2021-01-30 | US | South Dakota | Gregory | 46053 | 498 | 27 | 0 | 471 | 43.19419064 | -99.18883902 | 2021-01-31 05:22:42 | Gregory, South Dakota, US |
2212974 | 2212974 | 2021-01-30 | US | Kansas | Meade | 20119 | 478 | 7 | 0 | 471 | 37.23859987 | -100.364831 | 2021-01-31 05:22:42 | Meade, Kansas, US |
1900016 | 1900016 | 2021-01-29 | US | South Dakota | Gregory | 46053 | 498 | 27 | 0 | 471 | 43.19419064 | -99.18883902 | 2021-01-30 05:22:49 | Gregory, South Dakota, US |
1898461 | 1898461 | 2021-01-29 | US | Kansas | Meade | 20119 | 478 | 7 | 0 | 471 | 37.23859987 | -100.364831 | 2021-01-30 05:22:49 | Meade, Kansas, US |
1897162 | 1897162 | 2021-01-29 | Japan | Gifu | 4073 | 67 | 3535 | 471 | 35.778671 | 137.055925 | 2021-01-30 05:22:49 | Gifu, Japan | ||
2484832 | 2484832 | 2021-01-28 | US | South Dakota | Gregory | 46053 | 498 | 27 | 0 | 471 | 43.19419064 | -99.18883902 | 2021-01-29 05:22:23 | Gregory, South Dakota, 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]);