johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 253,216
- Georgia 161,954
- Virginia 134,920
- Kentucky 121,070
- Missouri 116,516
- Kansas 105,193
- Illinois 104,061
- North Carolina 101,539
- Iowa 100,003
- Tennessee 97,698
- Indiana 93,593
- Nebraska 92,393
- Ohio 89,582
- Minnesota 88,025
- Michigan 87,323
- Mississippi 83,553
- Oklahoma 78,981
- Arkansas 76,253
- Wisconsin 73,246
- Puerto Rico 71,326
- Alabama 69,351
- Pennsylvania 68,510
- Florida 68,428
- Louisiana 66,393
- South Dakota 66,027
- Colorado 65,750
- New York 63,726
- California 59,584
- West Virginia 55,913
- Montana 54,697
- …
country_or_region >30
- US 3,267,206
- Russia 77,809
- Japan 46,136
- China 34,661
- India 34,383
- Colombia 31,985
- Mexico 31,192
- Ukraine 26,457
- Brazil 25,700
- Peru 24,523
- Italy 20,138
- Sweden 19,698
- United Kingdom 19,635
- Spain 19,178
- Malaysia 18,156
- Germany 16,325
- Chile 16,194
- Canada 16,132
- Netherlands 15,740
- France 11,901
- Belgium 9,557
- Australia 8,372
- Pakistan 6,594
- New Zealand 3,172
- Denmark 3,059
- Mainland China 1,517
- Antarctica 1,068
- Korea, North 1,068
- Nauru 1,068
- Palau 1,068
- …
Link | rowid ▼ | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21652 | 21652 | 2021-05-28 | US | Kansas | Gove | 20063 | 386 | 19 | 0 | 38.91588178 | -100.4829321 | 2021-05-29 04:20:41 | Gove, Kansas, US | |
21653 | 21653 | 2021-05-28 | US | Kansas | Graham | 20065 | 265 | 9 | 0 | 39.34987223 | -99.88332493 | 2021-05-29 04:20:41 | Graham, Kansas, US | |
21654 | 21654 | 2021-05-28 | US | Kansas | Grant | 20067 | 946 | 18 | 0 | 37.56227336 | -101.3079758 | 2021-05-29 04:20:41 | Grant, Kansas, US | |
21655 | 21655 | 2021-05-28 | US | Kansas | Gray | 20069 | 566 | 14 | 0 | 37.73836671 | -100.4369088 | 2021-05-29 04:20:41 | Gray, Kansas, US | |
21656 | 21656 | 2021-05-28 | US | Kansas | Greeley | 20071 | 104 | 1 | 0 | 38.4808095 | -101.8061079 | 2021-05-29 04:20:41 | Greeley, Kansas, US | |
21657 | 21657 | 2021-05-28 | US | Kansas | Greenwood | 20073 | 567 | 11 | 0 | 37.8774388 | -96.23250453 | 2021-05-29 04:20:41 | Greenwood, Kansas, US | |
21658 | 21658 | 2021-05-28 | US | Kansas | Hamilton | 20075 | 210 | 1 | 0 | 37.99978709 | -101.7921066 | 2021-05-29 04:20:41 | Hamilton, Kansas, US | |
21659 | 21659 | 2021-05-28 | US | Kansas | Harper | 20077 | 617 | 18 | 0 | 37.19175361 | -98.07578384 | 2021-05-29 04:20:41 | Harper, Kansas, US | |
21660 | 21660 | 2021-05-28 | US | Kansas | Harvey | 20079 | 3678 | 70 | 0 | 38.04293782 | -97.42747573 | 2021-05-29 04:20:41 | Harvey, Kansas, US | |
21661 | 21661 | 2021-05-28 | US | Kansas | Haskell | 20081 | 419 | 9 | 0 | 37.5620394 | -100.8710738 | 2021-05-29 04:20:41 | Haskell, Kansas, US | |
21662 | 21662 | 2021-05-28 | US | Kansas | Hodgeman | 20083 | 213 | 8 | 0 | 38.08780079 | -99.89829881 | 2021-05-29 04:20:41 | Hodgeman, Kansas, US | |
21663 | 21663 | 2021-05-28 | US | Kansas | Jackson | 20085 | 1411 | 16 | 0 | 39.41673394 | -95.79356799 | 2021-05-29 04:20:41 | Jackson, Kansas, US | |
21664 | 21664 | 2021-05-28 | US | Kansas | Jefferson | 20087 | 1742 | 35 | 0 | 39.2347941 | -95.38289232 | 2021-05-29 04:20:41 | Jefferson, Kansas, US | |
21665 | 21665 | 2021-05-28 | US | Kansas | Jewell | 20089 | 213 | 6 | 0 | 39.78470589 | -98.21820662 | 2021-05-29 04:20:41 | Jewell, Kansas, US | |
21666 | 21666 | 2021-05-28 | US | Kansas | Johnson | 20091 | 59144 | 763 | 0 | 38.88548175 | -94.82250877 | 2021-05-29 04:20:41 | Johnson, Kansas, US | |
21667 | 21667 | 2021-05-28 | US | Kansas | Kearny | 20093 | 573 | 10 | 0 | 38.00017981 | -101.321681 | 2021-05-29 04:20:41 | Kearny, Kansas, US | |
21668 | 21668 | 2021-05-28 | US | Kansas | Kingman | 20095 | 772 | 15 | 0 | 37.55909527 | -98.13638678 | 2021-05-29 04:20:41 | Kingman, Kansas, US | |
21669 | 21669 | 2021-05-28 | US | Kansas | Kiowa | 20097 | 238 | 4 | 0 | 37.55848695 | -99.2856537 | 2021-05-29 04:20:41 | Kiowa, Kansas, US | |
21670 | 21670 | 2021-05-28 | US | Kansas | Labette | 20099 | 2751 | 50 | 0 | 37.19113093 | -95.29849679 | 2021-05-29 04:20:41 | Labette, Kansas, US | |
21671 | 21671 | 2021-05-28 | US | Kansas | Lane | 20101 | 128 | 7 | 0 | 38.48119447 | -100.4660754 | 2021-05-29 04:20:41 | Lane, Kansas, US | |
21672 | 21672 | 2021-05-28 | US | Kansas | Leavenworth | 20103 | 7255 | 92 | 0 | 39.20183497 | -95.03620809 | 2021-05-29 04:20:41 | Leavenworth, Kansas, US | |
21673 | 21673 | 2021-05-28 | US | Kansas | Lincoln | 20105 | 265 | 5 | 0 | 39.04549684 | -98.20756994 | 2021-05-29 04:20:41 | Lincoln, Kansas, US | |
21674 | 21674 | 2021-05-28 | US | Kansas | Linn | 20107 | 822 | 8 | 0 | 38.21267844 | -94.84254089 | 2021-05-29 04:20:41 | Linn, Kansas, US | |
21675 | 21675 | 2021-05-28 | US | Kansas | Logan | 20109 | 289 | 6 | 0 | 38.91735806 | -101.148475 | 2021-05-29 04:20:41 | Logan, Kansas, US | |
21676 | 21676 | 2021-05-28 | US | Kansas | Lyon | 20111 | 4299 | 86 | 0 | 38.45576156 | -96.15275715 | 2021-05-29 04:20:41 | Lyon, Kansas, US | |
21677 | 21677 | 2021-05-28 | US | Kansas | Marion | 20115 | 1113 | 24 | 0 | 38.35855394 | -97.0985251 | 2021-05-29 04:20:41 | Marion, Kansas, US | |
21678 | 21678 | 2021-05-28 | US | Kansas | Marshall | 20117 | 1124 | 25 | 0 | 39.78359669 | -96.52278974 | 2021-05-29 04:20:41 | Marshall, Kansas, US | |
21679 | 21679 | 2021-05-28 | US | Kansas | McPherson | 20113 | 3297 | 83 | 0 | 38.39184858 | -97.64769869 | 2021-05-29 04:20:41 | McPherson, Kansas, US | |
21680 | 21680 | 2021-05-28 | US | Kansas | Meade | 20119 | 517 | 12 | 0 | 37.23859987 | -100.364831 | 2021-05-29 04:20:41 | Meade, Kansas, US | |
21681 | 21681 | 2021-05-28 | US | Kansas | Miami | 20121 | 2773 | 42 | 0 | 38.56383358 | -94.83832189 | 2021-05-29 04:20:41 | Miami, Kansas, US | |
21682 | 21682 | 2021-05-28 | US | Kansas | Mitchell | 20123 | 564 | 18 | 0 | 39.39331582 | -98.20906732 | 2021-05-29 04:20:41 | Mitchell, Kansas, US | |
21683 | 21683 | 2021-05-28 | US | Kansas | Montgomery | 20125 | 3472 | 82 | 0 | 37.19236568 | -95.74329258 | 2021-05-29 04:20:41 | Montgomery, Kansas, US | |
21684 | 21684 | 2021-05-28 | US | Kansas | Morris | 20127 | 590 | 23 | 0 | 38.68827511 | -96.65128437 | 2021-05-29 04:20:41 | Morris, Kansas, US | |
21685 | 21685 | 2021-05-28 | US | Kansas | Morton | 20129 | 267 | 8 | 0 | 37.19141121 | -101.79925190000002 | 2021-05-29 04:20:41 | Morton, Kansas, US | |
21686 | 21686 | 2021-05-28 | US | Kansas | Nemaha | 20131 | 1516 | 55 | 0 | 39.78345387 | -96.01392079 | 2021-05-29 04:20:41 | Nemaha, Kansas, US | |
21687 | 21687 | 2021-05-28 | US | Kansas | Neosho | 20133 | 1805 | 35 | 0 | 37.55862897 | -95.30670046 | 2021-05-29 04:20:41 | Neosho, Kansas, US | |
21688 | 21688 | 2021-05-28 | US | Kansas | Ness | 20135 | 372 | 16 | 0 | 38.47974157 | -99.91547333 | 2021-05-29 04:20:41 | Ness, Kansas, US | |
21689 | 21689 | 2021-05-28 | US | Kansas | Norton | 20137 | 1206 | 27 | 0 | 39.78443827 | -99.90286639 | 2021-05-29 04:20:41 | Norton, Kansas, US | |
21690 | 21690 | 2021-05-28 | US | Kansas | Osage | 20139 | 1258 | 26 | 0 | 38.65235984 | -95.72707998 | 2021-05-29 04:20:41 | Osage, Kansas, US | |
21691 | 21691 | 2021-05-28 | US | Kansas | Osborne | 20141 | 290 | 12 | 0 | 39.3503437 | -98.76753828 | 2021-05-29 04:20:41 | Osborne, Kansas, US | |
21692 | 21692 | 2021-05-28 | US | Kansas | Ottawa | 20143 | 552 | 13 | 0 | 39.13237408 | -97.65020313 | 2021-05-29 04:20:41 | Ottawa, Kansas, US | |
21693 | 21693 | 2021-05-28 | US | Kansas | Out of KS | 80020 | 0 | 0 | 0 | 39.82799632 | -99.91547333 | 2021-05-29 04:20:41 | Out of KS, Kansas, US | |
21694 | 21694 | 2021-05-28 | US | Kansas | Pawnee | 20145 | 1172 | 13 | 0 | 38.18108732 | -99.23692334 | 2021-05-29 04:20:41 | Pawnee, Kansas, US | |
21695 | 21695 | 2021-05-28 | US | Kansas | Phillips | 20147 | 714 | 24 | 0 | 39.78465501 | -99.34668865 | 2021-05-29 04:20:41 | Phillips, Kansas, US | |
21696 | 21696 | 2021-05-28 | US | Kansas | Pottawatomie | 20149 | 1919 | 31 | 0 | 39.37925655 | -96.34564657 | 2021-05-29 04:20:41 | Pottawatomie, Kansas, US | |
21697 | 21697 | 2021-05-28 | US | Kansas | Pratt | 20151 | 815 | 25 | 0 | 37.64780729 | -98.73922153 | 2021-05-29 04:20:41 | Pratt, Kansas, US | |
21698 | 21698 | 2021-05-28 | US | Kansas | Rawlins | 20153 | 324 | 7 | 0 | 39.78525843 | -101.0761617 | 2021-05-29 04:20:41 | Rawlins, Kansas, US | |
21699 | 21699 | 2021-05-28 | US | Kansas | Reno | 20155 | 8552 | 139 | 0 | 37.95230263 | -98.08607292 | 2021-05-29 04:20:41 | Reno, Kansas, US | |
21700 | 21700 | 2021-05-28 | US | Kansas | Republic | 20157 | 669 | 13 | 0 | 39.82799632 | -97.65036709 | 2021-05-29 04:20:41 | Republic, Kansas, US | |
21701 | 21701 | 2021-05-28 | US | Kansas | Rice | 20159 | 1078 | 12 | 0 | 38.34616184 | -98.19992118 | 2021-05-29 04:20:41 | Rice, Kansas, US | |
21702 | 21702 | 2021-05-28 | US | Kansas | Riley | 20161 | 6552 | 43 | 0 | 39.28935726 | -96.73420026 | 2021-05-29 04:20:41 | Riley, Kansas, US | |
21703 | 21703 | 2021-05-28 | US | Kansas | Rooks | 20163 | 656 | 11 | 0 | 39.35022773 | -99.32484567 | 2021-05-29 04:20:41 | Rooks, Kansas, US | |
21704 | 21704 | 2021-05-28 | US | Kansas | Rush | 20165 | 433 | 14 | 0 | 38.52275276 | -99.30863983 | 2021-05-29 04:20:41 | Rush, Kansas, US | |
21705 | 21705 | 2021-05-28 | US | Kansas | Russell | 20167 | 859 | 28 | 0 | 38.91462787 | -98.76254297 | 2021-05-29 04:20:41 | Russell, Kansas, US | |
21706 | 21706 | 2021-05-28 | US | Kansas | Saline | 20169 | 6293 | 142 | 0 | 38.78369175 | -97.65185177 | 2021-05-29 04:20:41 | Saline, Kansas, US | |
21707 | 21707 | 2021-05-28 | US | Kansas | Scott | 20171 | 600 | 24 | 0 | 38.48222076 | -100.9066539 | 2021-05-29 04:20:41 | Scott, Kansas, US | |
21708 | 21708 | 2021-05-28 | US | Kansas | Sedgwick | 20173 | 57272 | 767 | 0 | 37.6842718 | -97.4608198 | 2021-05-29 04:20:41 | Sedgwick, Kansas, US | |
21709 | 21709 | 2021-05-28 | US | Kansas | Seward | 20175 | 3873 | 41 | 0 | 37.19324632 | -100.8507201 | 2021-05-29 04:20:41 | Seward, Kansas, US | |
21710 | 21710 | 2021-05-28 | US | Kansas | Shawnee | 20177 | 17569 | 363 | 0 | 39.04100763 | -95.7557264 | 2021-05-29 04:20:41 | Shawnee, Kansas, US | |
21711 | 21711 | 2021-05-28 | US | Kansas | Sheridan | 20179 | 436 | 14 | 0 | 39.35018161 | -100.4418259 | 2021-05-29 04:20:41 | Sheridan, Kansas, US | |
21712 | 21712 | 2021-05-28 | US | Kansas | Sherman | 20181 | 653 | 12 | 0 | 39.35147699 | -101.7197624 | 2021-05-29 04:20:41 | Sherman, Kansas, US | |
21713 | 21713 | 2021-05-28 | US | Kansas | Smith | 20183 | 271 | 3 | 0 | 39.78516566 | -98.78566062 | 2021-05-29 04:20:41 | Smith, Kansas, US | |
21714 | 21714 | 2021-05-28 | US | Kansas | Stafford | 20185 | 344 | 9 | 0 | 38.03100851 | -98.71762001 | 2021-05-29 04:20:41 | Stafford, Kansas, US | |
21715 | 21715 | 2021-05-28 | US | Kansas | Stanton | 20187 | 185 | 6 | 0 | 37.56304714 | -101.7843534 | 2021-05-29 04:20:41 | Stanton, Kansas, US | |
21716 | 21716 | 2021-05-28 | US | Kansas | Stevens | 20189 | 559 | 10 | 0 | 37.1923008 | -101.3118967 | 2021-05-29 04:20:41 | Stevens, Kansas, US | |
21717 | 21717 | 2021-05-28 | US | Kansas | Sumner | 20191 | 2188 | 52 | 0 | 37.23682549 | -97.47721621 | 2021-05-29 04:20:41 | Sumner, Kansas, US | |
21718 | 21718 | 2021-05-28 | US | Kansas | Thomas | 20193 | 1099 | 20 | 0 | 39.35107575 | -101.0553705 | 2021-05-29 04:20:41 | Thomas, Kansas, US | |
21719 | 21719 | 2021-05-28 | US | Kansas | Trego | 20195 | 407 | 8 | 0 | 38.91467218 | -99.87284448 | 2021-05-29 04:20:41 | Trego, Kansas, US | |
21720 | 21720 | 2021-05-28 | US | Kansas | Unassigned | 90020 | 0 | 0 | 0 | 39.82799632 | -99.91547333 | 2021-05-29 04:20:41 | Unassigned, Kansas, US | |
21721 | 21721 | 2021-05-28 | US | Kansas | Wabaunsee | 20197 | 685 | 13 | 0 | 38.95471985 | -96.20350509 | 2021-05-29 04:20:41 | Wabaunsee, Kansas, US | |
21722 | 21722 | 2021-05-28 | US | Kansas | Wallace | 20199 | 179 | 4 | 0 | 38.91686134 | -101.7638876 | 2021-05-29 04:20:41 | Wallace, Kansas, US | |
21723 | 21723 | 2021-05-28 | US | Kansas | Washington | 20201 | 536 | 14 | 0 | 39.78420784 | -97.0875323 | 2021-05-29 04:20:41 | Washington, Kansas, US | |
21724 | 21724 | 2021-05-28 | US | Kansas | Wichita | 20203 | 217 | 6 | 0 | 38.48178252 | -101.3471509 | 2021-05-29 04:20:41 | Wichita, Kansas, US | |
21725 | 21725 | 2021-05-28 | US | Kansas | Wilson | 20205 | 1018 | 16 | 0 | 37.55937174 | -95.74323255 | 2021-05-29 04:20:41 | Wilson, Kansas, US | |
21726 | 21726 | 2021-05-28 | US | Kansas | Woodson | 20207 | 219 | 5 | 0 | 37.8865336 | -95.74006277 | 2021-05-29 04:20:41 | Woodson, Kansas, US | |
21727 | 21727 | 2021-05-28 | US | Kansas | Wyandotte | 20209 | 20603 | 283 | 0 | 39.11727348 | -94.76378225 | 2021-05-29 04:20:41 | Wyandotte, Kansas, US | |
21728 | 21728 | 2021-05-28 | US | Kentucky | Adair | 21001 | 1948 | 54 | 0 | 37.10459774 | -85.28129668 | 2021-05-29 04:20:41 | Adair, Kentucky, US | |
21729 | 21729 | 2021-05-28 | US | Kentucky | Allen | 21003 | 2097 | 41 | 0 | 36.75197631 | -86.19457544 | 2021-05-29 04:20:41 | Allen, Kentucky, US | |
21730 | 21730 | 2021-05-28 | US | Kentucky | Anderson | 21005 | 1757 | 23 | 0 | 38.00671029 | -84.99171713 | 2021-05-29 04:20:41 | Anderson, Kentucky, US | |
21731 | 21731 | 2021-05-28 | US | Kentucky | Ballard | 21007 | 408 | 9 | 0 | 37.05842757 | -88.99427697 | 2021-05-29 04:20:41 | Ballard, Kentucky, US | |
21732 | 21732 | 2021-05-28 | US | Kentucky | Barren | 21009 | 4473 | 93 | 0 | 36.96469836 | -85.93338945 | 2021-05-29 04:20:41 | Barren, Kentucky, US | |
21733 | 21733 | 2021-05-28 | US | Kentucky | Bath | 21011 | 1032 | 22 | 0 | 38.14735938 | -83.74588932 | 2021-05-29 04:20:41 | Bath, Kentucky, US | |
21734 | 21734 | 2021-05-28 | US | Kentucky | Bell | 21013 | 3134 | 56 | 0 | 36.73355174 | -83.67766671 | 2021-05-29 04:20:41 | Bell, Kentucky, US | |
21735 | 21735 | 2021-05-28 | US | Kentucky | Boone | 21015 | 14220 | 126 | 0 | 38.97065142 | -84.72615357 | 2021-05-29 04:20:41 | Boone, Kentucky, US | |
21736 | 21736 | 2021-05-28 | US | Kentucky | Bourbon | 21017 | 1729 | 19 | 0 | 38.2054607 | -84.21827874 | 2021-05-29 04:20:41 | Bourbon, Kentucky, US | |
21737 | 21737 | 2021-05-28 | US | Kentucky | Boyd | 21019 | 5058 | 75 | 0 | 38.36176608 | -82.68652187 | 2021-05-29 04:20:41 | Boyd, Kentucky, US | |
21738 | 21738 | 2021-05-28 | US | Kentucky | Boyle | 21021 | 3456 | 72 | 0 | 37.62680923 | -84.8633779 | 2021-05-29 04:20:41 | Boyle, Kentucky, US | |
21739 | 21739 | 2021-05-28 | US | Kentucky | Bracken | 21023 | 652 | 7 | 0 | 38.69158994 | -84.08532444 | 2021-05-29 04:20:41 | Bracken, Kentucky, US | |
21740 | 21740 | 2021-05-28 | US | Kentucky | Breathitt | 21025 | 1031 | 9 | 0 | 37.52333168 | -83.31959161 | 2021-05-29 04:20:41 | Breathitt, Kentucky, US | |
21741 | 21741 | 2021-05-28 | US | Kentucky | Breckinridge | 21027 | 1293 | 16 | 0 | 37.77377239 | -86.42885017 | 2021-05-29 04:20:41 | Breckinridge, Kentucky, US | |
21742 | 21742 | 2021-05-28 | US | Kentucky | Bullitt | 21029 | 7334 | 75 | 0 | 37.97162523 | -85.68955617 | 2021-05-29 04:20:41 | Bullitt, Kentucky, US | |
21743 | 21743 | 2021-05-28 | US | Kentucky | Butler | 21031 | 1470 | 24 | 0 | 37.20946153 | -86.68748787 | 2021-05-29 04:20:41 | Butler, Kentucky, US | |
21744 | 21744 | 2021-05-28 | US | Kentucky | Caldwell | 21033 | 1461 | 32 | 0 | 37.14749129 | -87.86948214 | 2021-05-29 04:20:41 | Caldwell, Kentucky, US | |
21745 | 21745 | 2021-05-28 | US | Kentucky | Calloway | 21035 | 3543 | 51 | 0 | 36.62093411 | -88.2731593 | 2021-05-29 04:20:41 | Calloway, Kentucky, US | |
21746 | 21746 | 2021-05-28 | US | Kentucky | Campbell | 21037 | 8642 | 71 | 0 | 38.94384345 | -84.37875208 | 2021-05-29 04:20:41 | Campbell, Kentucky, US | |
21747 | 21747 | 2021-05-28 | US | Kentucky | Carlisle | 21039 | 482 | 9 | 0 | 36.85372876 | -88.96692220000001 | 2021-05-29 04:20:41 | Carlisle, Kentucky, US | |
21748 | 21748 | 2021-05-28 | US | Kentucky | Carroll | 21041 | 1025 | 19 | 0 | 38.66599534 | -85.12601074 | 2021-05-29 04:20:41 | Carroll, Kentucky, US | |
21749 | 21749 | 2021-05-28 | US | Kentucky | Carter | 21043 | 2308 | 35 | 0 | 38.31690743 | -83.05092385 | 2021-05-29 04:20:41 | Carter, Kentucky, US | |
21750 | 21750 | 2021-05-28 | US | Kentucky | Casey | 21045 | 1480 | 34 | 0 | 37.32533118 | -84.92726209 | 2021-05-29 04:20:41 | Casey, Kentucky, US | |
21751 | 21751 | 2021-05-28 | US | Kentucky | Christian | 21047 | 6980 | 104 | 0 | 36.89267803 | -87.49055367 | 2021-05-29 04:20:41 | Christian, Kentucky, 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]);