digital-forensics-lab/AI4Forensics/CKIM2024/HillaryEmails/dataprocessing_sql.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Tables in the SQLite database:\n",
      "Emails\n",
      "Persons\n",
      "Aliases\n",
      "EmailReceivers\n"
     ]
    }
   ],
   "source": [
    "import sqlite3\n",
    "\n",
    "# Connect to the SQLite database\n",
    "conn = sqlite3.connect(\"archive/database.sqlite\")\n",
    "\n",
    "# Get cursor object\n",
    "cursor = conn.cursor()\n",
    "\n",
    "# Query to list all tables\n",
    "query = \"SELECT name FROM sqlite_master WHERE type='table';\"\n",
    "\n",
    "# Execute the query\n",
    "cursor.execute(query)\n",
    "\n",
    "# Fetch all tables\n",
    "tables = cursor.fetchall()\n",
    "\n",
    "# Print the list of tables\n",
    "print(\"Tables in the SQLite database:\")\n",
    "for table in tables:\n",
    "    print(table[0])\n",
    "\n",
    "# Close the connection\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(0, 'Id', 'INTEGER', 0, None, 1)\n",
      "(1, 'DocNumber', 'TEXT', 0, None, 0)\n",
      "(2, 'MetadataSubject', 'TEXT', 0, None, 0)\n",
      "(3, 'MetadataTo', 'TEXT', 0, None, 0)\n",
      "(4, 'MetadataFrom', 'TEXT', 0, None, 0)\n",
      "(5, 'SenderPersonId', 'INTEGER', 0, None, 0)\n",
      "(6, 'MetadataDateSent', 'TEXT', 0, None, 0)\n",
      "(7, 'MetadataDateReleased', 'TEXT', 0, None, 0)\n",
      "(8, 'MetadataPdfLink', 'TEXT', 0, None, 0)\n",
      "(9, 'MetadataCaseNumber', 'TEXT', 0, None, 0)\n",
      "(10, 'MetadataDocumentClass', 'TEXT', 0, None, 0)\n",
      "(11, 'ExtractedSubject', 'TEXT', 0, None, 0)\n",
      "(12, 'ExtractedTo', 'TEXT', 0, None, 0)\n",
      "(13, 'ExtractedFrom', 'TEXT', 0, None, 0)\n",
      "(14, 'ExtractedCc', 'TEXT', 0, None, 0)\n",
      "(15, 'ExtractedDateSent', 'TEXT', 0, None, 0)\n",
      "(16, 'ExtractedCaseNumber', 'TEXT', 0, None, 0)\n",
      "(17, 'ExtractedDocNumber', 'TEXT', 0, None, 0)\n",
      "(18, 'ExtractedDateReleased', 'TEXT', 0, None, 0)\n",
      "(19, 'ExtractedReleaseInPartOrFull', 'TEXT', 0, None, 0)\n",
      "(20, 'ExtractedBodyText', 'TEXT', 0, None, 0)\n",
      "(21, 'RawText', 'TEXT', 0, None, 0)\n"
     ]
    }
   ],
   "source": [
    "import sqlite3\n",
    "\n",
    "# Connect to the SQLite database\n",
    "conn = sqlite3.connect(\"archive/database.sqlite\")\n",
    "\n",
    "# Get cursor object\n",
    "cursor = conn.cursor()\n",
    "\n",
    "# Query to fetch schema of the \"emails\" table\n",
    "query = \"PRAGMA table_info(emails);\"\n",
    "\n",
    "# Execute the query\n",
    "cursor.execute(query)\n",
    "\n",
    "# Fetch all records\n",
    "schema = cursor.fetchall()\n",
    "\n",
    "# Print the schema\n",
    "for column in schema:\n",
    "    print(column)\n",
    "\n",
    "# Close the connection\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1, 'C05739545', 'WOW', 'H', 'Sullivan, Jacob J', 87, '2012-09-12T04:00:00+00:00', '2015-05-22T04:00:00+00:00', 'DOCUMENTS/HRC_Email_1_296/HRCH2/DOC_0C05739545/C05739545.pdf', 'F-2015-04841', 'HRC_Email_296', 'FW: Wow', '', 'Sullivan, Jacob J <Sullivan11@state.gov>', '', 'Wednesday, September 12, 2012 10:16 AM', 'F-2015-04841', 'C05739545', '05/13/2015', 'RELEASE IN FULL', '', 'UNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739545\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nRELEASE IN FULL\\nFrom: Sullivan, Jacob J <Sullivan11@state.gov>\\nSent: Wednesday, September 12, 2012 10:16 AM\\nTo:\\nSubject: FW: Wow\\nFrom: Brose, Christian (Armed Services) (mailto:Christian_Brose@armed-servic,essenate.govi\\nSent: Wednesday, September 12, 2012 10:09 AM\\nTo: Sullivan, Jacob J\\nSubject: Wow\\nWhat a wonderful, strong and moving statement by your boss. please tell her how much Sen. McCain appreciated it. Me\\ntoo\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739545\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-5CB0045247\\n\\x0c')\n",
      "(2, 'C05739546', 'H: LATEST: HOW SYRIA IS AIDING QADDAFI AND MORE... SID', 'H', '', '', '2011-03-03T05:00:00+00:00', '2015-05-22T04:00:00+00:00', 'DOCUMENTS/HRC_Email_1_296/HRCH1/DOC_0C05739546/C05739546.pdf', 'F-2015-04841', 'HRC_Email_296', '', '', '', '', '', 'F-2015-04841', 'C05739546', '05/13/2015', 'RELEASE IN PART', 'B6\\nThursday, March 3, 2011 9:45 PM\\nH: Latest How Syria is aiding Qaddafi and more... Sid\\nhrc memo syria aiding libya 030311.docx; hrc memo syria aiding libya 030311.docx\\nMarch 3, 2011\\nFor: Hillary', \"UNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739546\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nRELEASE IN\\nPART B6\\nFrom:\\nSent:\\nTo:\\nSubject:\\nAttachments:\\nB6\\nThursday, March 3, 2011 9:45 PM\\nH: Latest How Syria is aiding Qaddafi and more... Sid\\nhrc memo syria aiding libya 030311.docx; hrc memo syria aiding libya 030311.docx\\nCONFIDENTIAL\\nMarch 3, 2011\\nFor: Hillary\\nFrom: Sid\\nRe: Syria aiding Qaddafi\\nThis memo has two parts. Part one is the report that Syria is providing air support for Qaddafi. Part two is a note\\nto Cody from Lord David Owen, former UK foreign secretary on his views of an increasingly complex crisis. It\\nseems that the situation is developing into a protracted civil war with various nations backing opposing sides\\nwith unforeseen consequences. Under these circumstances the crucial challenge is to deprive Qaddafi of his\\nstrategic depth—his support both financial and military.\\nI. Report\\nDuring the afternoon of March 3, advisers to Muammar Qaddafi stated privately that the Libyan\\nLeader has decided that civil war is inevitable, pitting troops and mercenary troops loyal to him\\nagainst the rebel forces gathering around Benghazi. Qaddafi is convinced that these rebels are\\nbeing supported by the United States, Western Europe and Israel. On March 2 Qaddafi told his\\nson Saif al-Islam that he believes the intelligence services of the United States, Great Britain,\\nEgypt, and France have deployed paramilitary officers to Benghazi to assist in organizing,\\ntraining, and equipping opposition forces. Qaddafi is convinced that the National Libyan Council\\n(NLC), and its leader, former Minister of Justice Mustafa Mohamed Abdel Galil have been\\nchosen by the foreign powers to replace him. On March 1 advisors to Qaddafi stated that\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739546\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045000\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739546\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nQaddafi's cousin, Col. Ali Qaddafiddam had failed in efforts to recruit fighters among the\\nEgyptian population living immediately across the border with Libya.\\nThese individuals added that during the week of February 21 the Libyan Leader spoke to Syrian\\nPresident Bashir al-Assad on at least three occasions by secure telephone lines. During the\\nconversations Qaddafi asked that Syrian officers and technicians currently training the Libyan\\nAir Force be placed under command of the Libyan Army and allowed to fight against the rebel\\nforces.\\n(Source Comment: Senior Libyan Army officers still loyal to Qaddafi added that On February\\n23, President Assad told General Isam Hallaq, the commander in chief of the Syrian Air Force,\\nto instruct the pilots and technicians in Tripoli to help the Libyan regime, should full scale Civil\\nWar breaks out in the immediate future.)\\nOn March 2, a military officer with ties to Qaddfi's son Khamis stated privately that the number\\nof Libyan pilots defecting to the opposition has destroyed the morale and professional spirit of\\nthe Libyan Air Force at this critical moment, when Tripoli's air superiority is its principal weapon\\nagainst insurgents. In the opinion of this individual Qaddafi and his senior military advisors are\\nconvinced that the European Union and the U.S will impose a no-fly zone over Libya in the\\nimmediate future. These advisors believe that the no fly zone will serve as air support for\\nopposition forces. They are also prepared for the Western allies to bomb anti-aircraft facilities in\\nand around Tripoli in preparation for the establishment of the no-fly zone. Foreign Minister\\nMousa Kousa is convinced that that Russia and Turkey will oppose the move, and may prevent\\nthe implementation of the no fly zone.\\nThe Syrian soldiers in Libya are part of a mission established in 1984 following the signing of a\\nmilitary agreement between Qaddafi and Syria's long-time ruler and Bashir's father, Hafez al-\\nAssad, in the presence of General Soubhi Haddad, who was the commander in chief of the Air\\nForce at the time. Both Air Forces are equipped with Russian materiel and have had long-\\nstanding, close links with Moscow.\\nNote from David Owen, former UK foreign secretary\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739546\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045001\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739546\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nIn exchange for Syria's help, Libya provided financial support to the Syrian state, including funds\\nin support of operations carried out by the Syrian intelligence services in Lebanon. Libyan money\\nhelped Hafez al-Assad bribe his brother Rifaat, the author of an attempted coup d'etat in 1983,\\nto leave the country and go into exile in Spain and France, where he has remained ever since.\\nAccording to individuals with access to the Syrian military, Damascus has also sent a second\\nteam of pilots and technicians to Tripoli. These are lower-ranking officers loyal to the regime\\nwho are specialized in flying helicopters. Before their departure for Tripoli on February 23, they\\nmet with General Allaq and General Jamil Hasan, head of Air Force's Intelligence.\\n(Source Comment: During the afternoon of 3 March, an associate of Saif al-Islam Qaddafi\\nstated that he and the Libyan leaders other family members were concerned over the\\nannouncement of Jose Luis Moreno-Ocampo, chief prosecutor of the International Criminal\\nCourt (ICC), announced that he was investigating Qaddafi, his sons Khamis, the commander of\\nthe 32 battalion, and Montasem, as well as the head of Gadhafi's personal security detail, the\\nDirector-General of the External Security Organization (Abuzaid Dorda), the spokesman of the\\nregime (Musa Ibrahim), and the Minister of Foreign Affairs (Mousa Kousa). This source added\\nthat Saif al-Islam had said that Qaddafi himself found the announcement amusing.)\\nFrom: Lord Owen\\nCody,\\nRealistically the UN will not authorise a no fly zone while Gaddafi continues to hold off bombing and\\nstrafing but keeping it up front and on the military agenda keeps him worried. Yet for a few frustrating months\\nthat ambivalence kept the Serbian aeroplanes on the ground before we acted. My hope is that preparations\\ncontinue with visuals of planes flying off carriers, airborne early warning planes flying and people with clout\\noutside the Administration demanding preparations. But and it is a big BUT what else can and should we be\\ndoing? Encourage humanitarian ships and convoys from Egypt to bring in supplies since we must ensure the\\ncities in the East can hold up living standards, maybe for months. More adventurous, Egyptian Special Forces to\\ngo in and advise, even supplying hand held missiles. It appears they have few missiles; the military in the East\\nhaving been deliberately kept ill-equipped. There is old Nasserite sentiment for a Federation of Egypt, Sudan\\nand Libya. I know some will say Egypt has enough problems and they should stay resolutely focused on\\ndomestic reforms. it is delicate but words alone and the balance of advantage will slip to Gaddafi. A Gaddafi\\nvictory is possible and needs to be weighed in the balance now when deciding what to do.\\nI'm more worried than I am ready to say publicly.\\nYours\\nDavid\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739546\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045002\\n\\x0c\")\n",
      "(3, 'C05739547', 'CHRIS STEVENS', ';H', 'Mills, Cheryl D', 32, '2012-09-12T04:00:00+00:00', '2015-05-22T04:00:00+00:00', 'DOCUMENTS/HRC_Email_1_296/HRCH2/DOC_0C05739547/C05739547.pdf', 'F-2015-04841', 'HRC_Email_296', 'Re: Chris Stevens', 'B6', 'Mills, Cheryl D <MillsCD@state.gov>', 'Abedin, Huma', 'Wednesday, September 12, 2012 11:52 AM', 'F-2015-04841', 'C05739547', '05/14/2015', 'RELEASE IN PART', 'Thx', \"UNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739547\\nDate: 05/14/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nRELEASE IN\\nPART B6\\nFrom: Mills, Cheryl D <MillsCD@state.gov>\\nSent: Wednesday, September 12, 2012 11:52 AM\\nTo: B6\\nCc: Abedin, Huma\\nSubject: Re: Chris Stevens\\nThx\\nOriginal Message\\nFrom: Anne-Marie Slaughter [\\nSent: Wednesday, September 12, 2012 07:46 AM\\nTo: Ihdr22@clintonernail.com' <hdr22@clintonemail corn>\\nCc: Abed in, Huma; Mills, Cheryl D\\nSubject: Chris Stevens\\nTo you and all my former colleagues, I'm so terribly sorry. Our FSOs stand on the front lines just as surely and devotedly\\nas our soldiers do. Thinking of you and Pat and everyone this morning.\\nAM\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739547\\nDate: 05/14/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-5CB0045248\\n\\x0c\")\n",
      "(4, 'C05739550', 'CAIRO CONDEMNATION - FINAL', 'H', 'Mills, Cheryl D', 32, '2012-09-12T04:00:00+00:00', '2015-05-22T04:00:00+00:00', 'DOCUMENTS/HRC_Email_1_296/HRCH2/DOC_0C05739550/C05739550.pdf', 'F-2015-04841', 'HRC_Email_296', 'FVV: Cairo Condemnation - Final', '', 'Mills, Cheryl D <MillsCD@state.gov>', 'Mitchell, Andrew B', 'Wednesday, September 12,2012 12:44 PM', 'F-2015-04841', 'C05739550', '05/13/2015', 'RELEASE IN PART', '', 'UNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739550\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nRELEASE IN PART\\nB5\\nFrom: Mills, Cheryl D <MillsCD@state.gov>\\nSent: Wednesday, September 12,2012 12:44 PM\\nTo:\\nSubject: FVV: Cairo Condemnation - Final\\nFrom: Smith, Dana S (PA)\\nSent: Wednesday, September 12, 2012 11:53 AM\\nTo Mills, Cheryl D\\nSubject FW: Cairo Condemnation - Final\\nB5\\nFrom: Snipe, Aaron D\\nSent: Tuesday, September 11 2012 1:31 PM\\nTo: Smith, Dana S (PA)\\nSubject: FW: Cairo Condemnation Final\\nFYI -\\nFrom: Snipe, Aaron D\\nSent: Tuesday, September 11, 2012 6:18 AM\\nTo Schwartz, Larry; Ranz, David J; Sievers, Marc 3; Linfield, David E; Sayles, Ambrose G; NEA-Press-DL; NEA-Egypt;\\nShea, Peter T\\nCc: Mitchell, Andrew B\\nSubject: RE: Cairo Condemnation - Final\\nAll,\\nADS\\nAaron D. Snipe\\nSpokesperson I Bureau of Near Eastern Affairs I U.S. Department of State\\nUNCLASSIFIF81 C Street NW I Room 6250 I Washington, DC, 20520\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739550 STATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nDate: 05/13/2015 SUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045249\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739550\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nOffice: +1 202-647-9533 I Email: snipead@state.gov\\nFrom: Schwartz, Larry\\nSent Tuesday, September 11, 2012 5:26 AM\\nTo Ranz, David J; Sievers, Marc J; Linfield, David E; Sayles, Ambrose G; NEA-Press-DL; NEA-Egypt; Shea, Peter T\\ncc: Mitchell, Andrew B\\nSubject Cairo Condemnation - Final\\nImportance: High\\nB5\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739550\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-5CB0045250\\n\\x0c')\n",
      "(5, 'C05739554', 'H: LATEST: HOW SYRIA IS AIDING QADDAFI AND MORE... SID', 'Abedin, Huma', 'H', 80, '2011-03-11T05:00:00+00:00', '2015-05-22T04:00:00+00:00', 'DOCUMENTS/HRC_Email_1_296/HRCH1/DOC_0C05739554/C05739554.pdf', 'F-2015-04841', 'HRC_Email_296', '', '', '', '', '', 'F-2015-04841', 'C05739554', '05/13/2015', 'RELEASE IN PART', 'H <hrod17@clintonemail.com>\\nFriday, March 11, 2011 1:36 PM\\nHuma Abedin\\nFw: H: Latest: How Syria is aiding Qaddafi and more... Sid\\nhrc memo syria aiding libya 030311.docx\\nPis print.', \"B6\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739554\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nRELEASE IN\\nPART B6\\nFrom:\\nSent:\\nTo:\\nSubject:\\nAttachments:\\nH <hrod17@clintonemail.com>\\nFriday, March 11, 2011 1:36 PM\\nHuma Abedin\\nFw: H: Latest: How Syria is aiding Qaddafi and more... Sid\\nhrc memo syria aiding libya 030311.docx\\nPis print.\\nFrom:\\nSent: Thursday, March 03, 2011 09:45 PM\\nTo: H\\nSubject: H: Latest: How Syria is aiding Qaddafi and more... Sid\\nCONFIDENTIAL\\nMarch 3, 2011\\nFor: Hillary\\nFrom: Sid\\nRe: Syria aiding Qaddafi\\nThis memo has two parts. Part one is the report that Syria is providing air support for Qaddafi. Part two is a note\\nto Cody from Lord David Owen, former UK foreign secretary on his views of an increasingly complex crisis. It\\nseems that the situation is developing into a protracted civil war with various nations backing opposing sides\\nwith unforeseen consequences. Under these circumstances the crucial challenge is to deprive Qaddafi of his\\nstrategic depth—his support both financial and military.\\nI. Report\\nDuring the afternoon of March 3, advisers to Muammar Qaddafi stated privately that the Libyan\\nLeader has decided that civil war is inevitable, pitting troops and mercenary troops loyal to him\\nagainst the rebel forces gathering around Benghazi. Qaddafi is convinced that these rebels are\\nbeing supported by the United States, Western Europe and Israel. On March 2 Qaddafi told his\\nson Saif al-Islam that he believes the intelligence services of the United States, Great Britain,\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739554\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045003\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739554\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nEgypt, and France have deployed paramilitary officers to Benghazi to assist in organizing,\\n_raining, and equipping opposition forces. Qaddafi is convinced that the National Libyan Council\\n:NLC), and its leader, former Minister of Justice Mustafa Mohamed Abdel Gall have been\\n:thosen by the foreign powers to replace him. On March 1 advisors to Qaddafi stated that\\nQ,addafi's cousin, Col. Al Qaddafiddam had failed in efforts to recruit fighters among the\\nEgyptian population living immediately across the border with Libya.\\nThese individuals added that during the week of February 21 the Libyan Leader spoke to Syrian\\npresident Bashir al-Assad on at least three occasions by secure telephone lines. During the\\n:,onversations Qaddafi asked that Syrian officers and technicians currently training the Libyan\\n/kir Force be placed under command of the Libyan Army and allowed to fight against the rebel\\ntbrces.\\n(Source Comment: Senior Libyan Army officers still loyal to Qaddafi added that On February\\n23, President Assad told General Isam HaIlaq, the commander in chief of the Syrian Air Force,\\n:o instruct the pilots and technicians in Tripoli to help the Libyan regime, should full scale Civil\\nWar breaks out in the immediate future.)\\nOn March 2, a military officer with ties to Qaddfi's son Khamis stated privately that the number\\nDf Libyan pilots defecting to the opposition has destroyed the morale and professional spirit of\\n,he Libyan Air Force at this critical moment, when Tripoli's air superiority is its principal weapon\\nagainst insurgents. In the opinion of this individual Qaddafi and his senior military advisors are\\nconvinced that the European Union and the U.S will impose a no-fly zone over Libya in the\\nimmediate future. These advisors believe that the no fly zone will serve as air support for\\nDpposition forces. They are also prepared for the Western allies to bomb anti-aircraft facilities in\\nand around Tripoli in preparation for the establishment of the no-fly zone. Foreign Minister\\nMousa Kousa is convinced that that Russia and Turkey will oppose the move, and may prevent\\nthe implementation of the no fly zone.\\nThe Syrian soldiers in Libya are part of a mission established in 1984 following the signing of a\\nmilitary agreement between Qaddafi and Syria's long-time ruler and Bashir's father, Hafez al-\\nUNCLASSIFIED\\nIL from David Owen, former UK foreign secretary\\nU.S. Department of State\\nCase No F-2015-04841\\nDoc No C05739554 STATE DEPT - PRODUCED TO HOUSE SELECT BENGHAZI COMM\\nDate 05/13/2015 SUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS NO FOIA WAIVER STATE-SCB0045004\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739554\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nkssad, in the presence of General Soubhi Haddad, who was the commander in chief of the Air\\nForce at the time. Both Air Forces are equipped with Russian materiel and have had long-\\n;tanding, close links with Moscow.\\n:n exchange for Syria's help, Libya provided financial support to the Syrian state, including funds\\nn support of operations carried out by the Syrian intelligence services in Lebanon. Libyan money\\n-wiped Hafez al-Assad bribe his brother Rifaat, the author of an attempted coup d'etat in 1983,\\n.o leave the country and go into exile in Spain and France, where he has remained ever since.\\nkccording to individuals with access to the Syrian military, Damascus has also sent a second\\nearn of pilots and technicians to Tripoli. These are lower-ranking officers loyal to the regime\\nAfho are specialized in flying helicopters. Before their departure for Tripoli on February 23, they\\nnet with General Allaq and General Jamil Hasan, head of Air Force's Intelligence.\\n:Source Comment: During the afternoon of 3 March, an associate of Saif al-Islam Qaddafi\\n;tated that he and the Libyan leaders other family members were concerned over the\\ntrmouncement of Jose Luis Moreno-Ocampo, chief prosecutor of the International Criminal\\n.2ourt (ICC), announced that he was investigating Qaddafi, his sons Khamis, the commander of\\n.he 32 battalion, and Montasem, as well as the head of Gadhafi's personal security detail, the\\nDirector-General of the External Security Organization (Abuzaid Dorda), the spokesman of the\\n-egime (Musa Ibrahim), and the Minister of Foreign Affairs (Mousa Kousa). This source added\\n:hat Saif al-Islam had said that Qaddafi himself found the announcement amusing.)\\nFrom: Lord Owen\\nCody,\\nRealistically the UN will not authorise a no fly zone while Gaddafi continues to hold off bombing and\\nstrafing but keeping it up front and on the military agenda keeps him worried. Yet for a few frustrating months\\nthat ambivalence kept the Serbian aeroplanes on the ground before we acted. My hope is that preparations\\ncontinue with visuals of planes flying off carriers, airborne early warning planes flying and people with clout\\noutside the Administration demanding preparations. But and it is a big BUT what else can and should we be\\ndoing? Encourage humanitarian ships and convoys from Egypt to bring in supplies since we must ensure the\\ncities in the East can hold up living standards, maybe for months. More adventurous, Egyptian Special Forces to\\ngo in and advise, even supplying hand held missiles. It appears they have few missiles; the military in the East\\nhaving been deliberately kept ill-equipped. There is old Nasserite sentiment for a Federation of Egypt, Sudan\\nand Libya. I know some will say Egypt has enough problems and they should stay resolutely focused on\\ndomestic reforms. it is delicate but words alone and the balance of advantage will slip to Gaddafi. A Gaddafi\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739554 STATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nDate: 05/13/2015 SUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045005\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739554\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nvictory is possible and needs to be weighed in the balance now when deciding what to do.\\nPm more worried than I am ready to say publicly.\\nYours\\nDavid\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739554\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-5CB0045006\\n\\x0c\")\n",
      "(6, 'C05739559', 'MEET THE RIGHT-WING EXTREMIST BEHIND ANTI-MUSLIM FILM THAT SPARKED DEADLY RIOTS', 'Russorv@state.gov', 'H', 80, '2012-09-12T04:00:00+00:00', '2015-05-22T04:00:00+00:00', 'DOCUMENTS/HRC_Email_1_296/HRCH2/DOC_0C05739559/C05739559.pdf', 'F-2015-04841', 'HRC_Email_296', 'Meet The Right Wing Extremist Behind Anti-Muslim Film That Sparked Deadly Riots', '', '', '', 'Wednesday, September 12, 2012 01:00 PM', 'F-2015-04841', 'C05739559', '05/13/2015', 'RELEASE IN PART', \"Pis print.\\n-•-...-^\\nH < hrod17@clintonernailcom>\\nWednesday, September 12, 2012 2:11 PM\\n°Russorv@state.gov'\\nFw: Meet The Right-Wing Extremist Behind Anti-fvluslim Film That Sparked Deadly Riots\\nFrom [meat)\\nSent: Wednesday, September 12, 2012 01:00 PM\\nTo: 11\\nSubject: Meet The Right Wing Extremist Behind Anti-Muslim Film That Sparked Deadly Riots\\nhtte/maxbiumenthal.com12012/09/meet-the-right-wing-extremist-behind-anti-musiim-tihn-that-sparked-\\ndeadly-riots/\\nSent from my Verizon Wireless 4G LTE DROID\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739559\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-5CB0045251\", \"B6\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739559\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nRELEASE IN\\nPART B6\\nFrom:\\nSent\\nTo:\\nSubject\\nPis print.\\n-•-...-^\\nH < hrod17@clintonernailcom>\\nWednesday, September 12, 2012 2:11 PM\\n°Russorv@state.gov'\\nFw: Meet The Right-Wing Extremist Behind Anti-fvluslim Film That Sparked Deadly Riots\\nFrom [meat)\\nSent: Wednesday, September 12, 2012 01:00 PM\\nTo: 11\\nSubject: Meet The Right Wing Extremist Behind Anti-Muslim Film That Sparked Deadly Riots\\nhtte/maxbiumenthal.com12012/09/meet-the-right-wing-extremist-behind-anti-musiim-tihn-that-sparked-\\ndeadly-riots/\\nSent from my Verizon Wireless 4G LTE DROID\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739559\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-5CB0045251\\n\\x0c\")\n",
      "(7, 'C05739560', 'ANTI-MUSLIM FILM DIRECTOR IN HIDING, FOLLOWING LIBYA, EGYPT VIOLENCE', 'H', 'Mills, Cheryl D', 32, '2012-09-12T04:00:00+00:00', '2015-05-22T04:00:00+00:00', 'DOCUMENTS/HRC_Email_1_296/HRCH2/DOC_0C05739560/C05739560.pdf', 'F-2015-04841', 'HRC_Email_296', 'FW: Anti-Muslim film director in hiding, following Libya, Egypt violence', '', 'Mills, Cheryl D <MillsCD@state.gov>', '', 'Wednesday, September 12, 2012 4:00 PM', 'F-2015-04841', 'C05739560', '05/13/2015', 'RELEASE IN FULL', '', 'UNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739560\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nRELEASE IN\\nFULL\\nFrom: Mills, Cheryl D <MillsCD@state.gov>\\nSent: Wednesday, September 12, 2012 4:00 PM\\nTo:\\nSubject: FW: Anti-Muslim film director in hiding, following Libya, Egypt violence\\nFrom: Toiv, Nora F\\nSent: Wednesday, September 12, 2012 1:48 PM\\nTo: Mills, Cheryl D\\nSubject: Anti-Muslim film director in hiding, following Libya, Egypt violence\\nAnti-Muslim film director in hiding, following\\nLibya, Egypt violence\\nBy Nia-Malika Henderson and Michelle Boorstein, Updated: Wednesday, September 12,\\n1:30 PM\\nThe director of a controversial anti-Islam film has gone into hiding, according to reports, fearing reprisals over a\\nwork that has sparked violence in Egypt and Libya and led to the deaths of four Americans.\\nSam Bacile, a California real estate developer, posted a 13-minute clip of \"The Innocence of Muslims,\" in July,\\nand the film became a lighting rod after the Egyptian media began showing parts of it on air and dubbed\\nversions of the English-language film appeared on the Internet.\\nIt depicts the Prophet Muhammad as a bumbling idiot, born out of wedlock and making up verses to the Islamic\\nholy book to suit his purposes and desires. The film also shows him as having intimate relations with women\\nand suggests that he was gay.\\nAny flesh-and-blood depiction of Muhammad is offensive to Muslims.\\n\"This is a political movie,\" Bacile, 56, told the Associated Press, adding that he didn\\'t expect the film to spark\\nsuch fury. \"The U.S. lost a lot of money and a lot of people in wars in Iraq and Afghanistan, but we\\'re fighting\\nwith ideas.\"\\nBacile identified himself to several news organizations as an Israeli-born Jew who works as a real estate\\ndeveloper in California. Yet his identity remains something of a mystery—Bacile is not listed in any directories\\nor incorporations or real estate deeds and is not licensed in California as a real estate broker. And Israeli\\nauthorities told the Associated Press that they don\\'t have any records of Bacile.\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739560\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045252\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739560\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nThere are also questions about whether the film sparked the violence in Libya, which according to some reports\\nseemed to be more coordinated than the protests in Egypt where some 2,000 gathered outside the U.S. Embassy\\nin Cairo.\\nThe eruption of violence came around the llth anniversary of the Sept. 11 terror attacks, as Americans paused\\nto remember the 3,000 people who lost their lives.\\nAmbassador J. Christopher Stevens and three others were killed after protesters attacked the U.S. consulate in\\nBenghazi.\\nNihad Awad, national executive director of the Washington-based Council on American-Islamic Relations\\n(CAIR), condemned both the killings and the film. Awad said in a statement:\\n\"We urge that this ignorant attempt to provoke the religious feelings of Muslims in the Arabic-speaking world\\nbe ignored and that its extremist producers not be given the cheap publicity they so desperately seek.\\n\"Those who created this trashy film do not represent the people of America or the Christian faith. The only\\nproper response to intentional provocations such as this film is to redouble efforts to promote mutual\\nunderstanding between faiths and to marginalize extremists of all stripes.\"\\nA controversial Florida pastor was among those promoting \"The Innocence of Muslims,\" which cost $5 million\\nto make and stars amateur actors, some of whom appear to be wearing make-up to darken their faces.\\nBacile said that the film was backed by 100 Jewish donors, according to Bacile.\\nAmong the promoters is Morris Sadek, who heads the National American Cooptic Assembly and the Rev. Terry\\nJones, leader of a small group that holds virulently anti-Islam events.\\nTuesday evening, Jones sent out a press release blaming the Muslim faith for the protests and saying the group\\nwould be running a trailer later in the evening for the film.\\nThe trailer was part of a one-to-two hour \"live event\" that Jones was doing from his Gainesville center for Sept.\\n11, said Fran Ingram, a spokeswoman for his group, Stand Up America. The whole broadcast included the\\nhandlebar-moustached pastor in a black \"infidel\" t-shirt standing in front of a fabric lynched devil dressed in a\\nwhite turban for what they group dubbed \"International Judge Muhammed Day.\"\\nIt wasn\\'t clear if Jones, who garnered worldwide attention in recent years with his threats to burn the Koran,\\nhad promoted \"The Innocence of Muslims\" before the rioting began.\\nAsked if Jones was connected in any way with the making of the film, Ingram said she couldn\\'t comment.\\nAlice Crites contributed to this story.\\n© The Washington Post Company\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739560\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045253\\n\\x0c')\n",
      "(8, 'C05739561', 'H: LATEST: HOW SYRIA IS AIDING QADDAFI AND MORE... SID', 'Abedin, Huma', 'H', 80, '2011-03-11T05:00:00+00:00', '2015-05-22T04:00:00+00:00', 'DOCUMENTS/HRC_Email_1_296/HRCH1/DOC_0C05739561/C05739561.pdf', 'F-2015-04841', 'HRC_Email_296', '', '', '', '', '', 'F-2015-04841', 'C05739561', '05/13/2015', 'RELEASE IN PART', 'H <hrod17@clintonemail.corn>\\nFriday, March 11, 2011 1:36 PM\\nHuma Abedin\\nFw: H: Latest: How Syria is aiding Qaddafi and more... Sid\\nhrc memo Syria aiding libya 030311.docx\\nPis print.', \"B6\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739561\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nRELEASE IN\\nPART B6\\nFrom:\\nSent:\\nTo:\\nSubject:\\nAttachments:\\nH <hrod17@clintonemail.corn>\\nFriday, March 11, 2011 1:36 PM\\nHuma Abedin\\nFw: H: Latest: How Syria is aiding Qaddafi and more... Sid\\nhrc memo Syria aiding libya 030311.docx\\nPis print.\\nFrom:\\nSent: Thursday, March 03, 2011 09:45 PM\\nTo: H\\nSubject: H: Latest: How Syria is aiding Qaddafi and more... Sid\\nCONFIDENTIAL\\nMarch 3, 2011\\nFor: Hillary\\nFrom: Sid\\nRe: Syria aiding Qaddafi\\nThis memo has two parts. Part one is the report that Syria is providing air support for Qaddafi. Part two is a note\\nto Cody from Lord David Owen, former UK foreign secretary on his views of an increasingly complex crisis. It\\nseems that the situation is developing into a protracted civil war with various nations backing opposing sides\\nwith unforeseen consequences. Under these circumstances the crucial challenge is to deprive Qaddafi of his\\nstrategic depth--his support both financial and military.\\nI. Report\\nDuring the afternoon of March 3, advisers to Muammar Qaddafi stated privately that the Libyan\\nLeader has decided that civil war is inevitable, pitting troops and mercenary troops loyal to him\\nagainst the rebel forces gathering around Benghazi. Qaddafi is convinced that these rebels are\\nbeing supported by the United States, Western Europe and Israel. On March 2 Qaddafi told his\\nson Saif al-Islam that he believes the intelligence services of the United States, Great Britain,\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739561\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045007\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739561\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nEgypt, and France have deployed paramilitary officers to Benghazi to assist in organizing,\\ntraining, and equipping opposition forces. Qaddafi is convinced that the National Libyan Council\\n(NLC), and its leader, former Minister of Justice Mustafa Mohamed Abdel Galil have been\\nchosen by the foreign powers to replace him. On March 1 advisors to Qaddafi stated that\\nQaddafi's cousin, Col. Ali Qaddafiddam had failed in efforts to recruit fighters among the\\nEgyptian population living immediately across the border with Libya.\\nThese individuals added that during the week of February 21 the Libyan Leader spoke to Syrian\\nPresident Bashir al-Assad on at least three occasions by secure telephone lines. During the\\nconversations Qaddafi asked that Syrian officers and technicians currently training the Libyan\\nAir Force be placed under command of the Libyan Army and allowed to fight against the rebel\\nforces.\\n(Source Comment: Senior Libyan Army officers still loyal to Qaddafi added that On February\\n23, President Assad told General Isam HaIlaq, the commander in chief of the Syrian Air Force,\\nto instruct the pilots and technicians in Tripoli to help the Libyan regime, should full scale Civil\\nWar breaks out in the immediate future.)\\nOn March 2, a military officer with ties to Qaddfi's son Khamis stated privately that the number\\nof Libyan pilots defecting to the opposition has destroyed the morale and professional spirit of\\nthe Libyan Air Force at this critical moment, when Tripoli's air superiority is its principal weapon\\nagainst insurgents. In the opinion of this individual Qaddafi and his senior military advisors are\\nconvinced that the European Union and the U.S will impose a no-fly zone over Libya in the\\nimmediate future. These advisors believe that the no fly zone will serve as air support for\\nopposition forces. They are also prepared for the Western allies to bomb anti-aircraft facilities in\\nand around Tripoli in preparation for the establishment of the no-fly zone. Foreign Minister\\nMousa Kousa is convinced that that Russia and Turkey will oppose the move, and may prevent\\nthe implementation of the no fly zone.\\nThe Syrian soldiers in Libya are part of a mission established in 1984 following the signing of a\\nmilitary agreement between Qaddafi and Syria's long-time ruler and Bashir's father, Hafez al-\\nUNCLASSIFIED\\nNote from David Owen, former UK foreign secretary\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739561 STATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nDate: 05/13/2015 SUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045008\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739561\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nAssad, in the presence of General Soubhi Haddad, who was the commander in chief of the Air\\nForce at the time. Both Air Forces are equipped with Russian materiel and have had long-\\nstanding, close links with Moscow.\\nIn exchange for Syria's help, Libya provided financial support to the Syrian state, including funds\\nin support of operations carried out by the Syrian intelligence services in Lebanon. Libyan money\\nhelped Hafez al-Assad bribe his brother Rifaat, the author of an attempted coup d'etat in 1983,\\nto leave the country and go into exile in Spain and France, where he has remained ever since.\\nAccording to individuals with access to the Syrian military, Damascus has also sent a second\\nteam of pilots and technicians to Tripoli. These are lower-ranking officers loyal to the regime\\nwho are specialized in flying helicopters. Before their departure for Tripoli on February 23, they\\nmet with General Allaq and General Jamil Hasan, head of Air Force's Intelligence.\\n(Source Comment: During the afternoon of 3 March, an associate of Saif al-Islam Qaddafi\\nstated that he and the Libyan leaders other family members were concerned over the\\nannouncement of Jose Luis Moreno-Ocampo, chief prosecutor of the International Criminal\\nCourt (ICC), announced that he was investigating Qaddafi, his sons Khamis, the commander of\\nthe 32 battalion, and Montasem, as well as the head ofGadhaffs personal security detail, the\\nDirector-General of the External Security Organization (Abuzaid Dorda), the spokesman of the\\nregime (Musa Ibrahim), and the Minister of Foreign Affairs (Mousa Kousa). This source added\\nthat Saif al-Islam had said that Qaddafi himself found the announcement amusing.)\\nFrom: Lord Owen\\nCody,\\nRealistically the UN will not authorise a no fly zone while Gaddafi continues to hold off bombing and\\nstrafing but keeping it up front and on the military agenda keeps him worried. Yet for a few frustrating months\\nthat ambivalence kept the Serbian aeroplanes on the ground before we acted. My hope is that preparations\\ncontinue with visuals of planes flying off carriers, airborne early warning planes flying and people with clout\\noutside the Administration demanding preparations. But and it is a big BUT what else can and should we be\\ndoing? Encourage humanitarian ships and convoys from Egypt to bring in supplies since we must ensure the\\ncities in the East can hold up living standards, maybe for months. More adventurous, Egyptian Special Forces to\\ngo in and advise, even supplying hand held missiles. It appears they have few missiles; the military in the East\\nhaving been deliberately kept ill-equipped. There is old Nasserite sentiment for a Federation of Egypt, Sudan\\nand Libya. I know some will say Egypt has enough problems and they should stay resolutely focused on\\ndomestic reforms. it is delicate but words alone and the balance of advantage will slip to Gaddafi. A Gaddafi\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No F-2015-04841\\nDoc No C05739561 STATE DEPT - PRODUCED TO HOUSE SELECT BENGHAZI COMM\\nDate 05/13/2015 SUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS NO FOIA WAIVER STATE-SCB0045009\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739561\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nvictory is possible and needs to be weighed in the balance now when deciding what to do.\\nPm more worried than I am ready to say publicly.\\nYours\\nDavid\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739561\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-5CB0045010\\n\\x0c\")\n",
      "(9, 'C05739562', \"SECRETARY'S REMARKS\", 'H', 'Sullivan, Jacob J', 87, '2012-09-12T04:00:00+00:00', '2015-05-22T04:00:00+00:00', 'DOCUMENTS/HRC_Email_1_296/HRCH2/DOC_0C05739562/C05739562.pdf', 'F-2015-04841', 'HRC_Email_296', \"FVV: Secretary's remarks\", '', 'Sullivan, Jacob J <Sullivanli@stategov>', '', 'Wednesday, September 12, 2012 6:08 PM', 'F-2015-04841', 'C05739562', '05/13/2015', 'RELEASE IN FULL', 'FYI', 'UNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739562\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nRELEASE IN\\nFULL\\nFrom: Sullivan, Jacob J <Sullivanli@stategov>\\nSent: Wednesday, September 12, 2012 6:08 PM\\nTo:\\nSubject: FVV: Secretary\\'s remarks\\nFYI\\nFrom: Walsh, Matthew P\\nSent: Wednesday, September 12, 2012 5:37 PM\\nTo Daniel, Joshua 3; Benaim, Daniel; Rooney, Megan; Schwerin, Daniel B\\nSubject AN Secretary\\'s remarks\\nDon\\'t know if you guys have seen this, but there is an article on Slate right now that describes the below as \"her most\\neloquent news conference as Secretary of State.\" Really nice work guys.\\nhtto://www.slate.comiarticlesinews arid politics/war stories/2012/09/libya u s embassy attack hillarv clinton was\\neloquent regarding ambassador stevens mitt romnev smirked ,htrni\\nFrom: McAuliffe, Marisa S\\nSent: Wednesday, September 12, 2012 5:31 PM\\nTo: SPoExpandecl\\nSubject: Secretary\\'s remarks\\nFor anyone who missed the Secretary\\'s remarks this morning, they are worth a read:\\nhtto://www,state.govisecretary/rm/2012/09/197654.htm\\nRemarks on the Deaths of American Personnel in Benghazi, Libya\\nRemarks\\nHillary Rodham Clinton\\nSecretary of State\\nTreaty Room\\nWashington, DC\\nSeptember 12, 2012\\nYesterday, our U.S. diplomatic post in Benghazi, Libya was attacked. Heavily armed militants assaulted the compound\\nand set fire to our buildings, American and Libyan security personnel battled the attackers together, Four Americans\\nwere killed, They included Sean Smith, a Foreign Service information management officer, and our Ambassador to Libya\\nChris Stevens. We are still making next of kin notifications for the other two individuals.\\nThis is an attack that should shock the conscience of people of all faiths around the vvorld. We condemn in the strongest\\nterms this senseless act of violence, and we send our prayers to the families, friends, and colleagues of those we\\'ve lost.\\nAll over the world, every day, America\\'s diplomats and development experts risk their lives in the service of our country\\nand our values, because they believe that the United States must be a force for peace and progress in the world, that\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739562\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045254\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739562\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nthese aspirations are worth striving and sacrificing for. Alongside our men and women in uniform, they represent the\\nbest traditions of a bold and generous nation.\\nIn the lobby of this building, the State Department, the names of those who have fallen in the line of duty are inscribed\\nin marble. Our hearts break over each one. And now, because of this tragedy, we have new heroes to honor and more\\nfriends to mourn.\\nChris Stevens fell in love with the Middle East as a young Peace Corps volunteer teaching English in Morocco. He joined\\nthe Foreign Service, learned languages, won friends for America in distant places, and made other people\\'s hopes his\\nown.\\nIn the early days of the Libyan revolution, I asked Chris to be our envoy to the rebel opposition. He arrived on a cargo\\nship in the port of Benghazi and began building our relationships with Libya\\'s revolutionaries. He risked his life to stop a\\ntyrant, then gave his life trying to help build a better Libya. The world needs more Chris Stevenses. I spoke with his\\nsister, Ann, this morning, and told her that he will be remembered as a hero by many nations.\\nSean Smith was an Air Force veteran. He spent 10 years as an information management officer in the State Department,\\nhe was posted at The Hague, and was in Libya on a brief temporary assignment. He was a husband to his wife Heather,\\nwith whom I spoke this morning. He was a father to two young children, Samantha and Nathan. They will grow up being\\nproud of the service their father gave to our country, service that took him from Pretoria to Baghdad, and finally to\\nBenghazi.\\nThe mission that drew Chris and Sean and their colleagues to Libya is both noble and necessary, and we arid the people\\nof Libya honor their memory by carrying it forward. This is not easy. Today, many Americans are asking indeed, I asked\\nmyself — how could this happen? How could this happen in a country we helped liberate, in a city we helped save from\\ndestruction? This question reflects just how complicated and, at times, how confounding the world can be\\nBut we must be clear-eyed, even in our grief. This was an attack by a small and savage group — not the people or\\nGovernment of Libya. Everywhere Chris and his team went in Libya, in a country scarred by war and tyranny, they were\\nhailed as friends and partners. And when the attack came yesterday, Libyans stood and fought to defend our post, Some\\nwere wounded. Libyans carried Chris\\' body to the hospital, and they helped rescue and lead other Americans to safety.\\nAnd last night, when I spoke with the President of Libya, he strongly condemned the violence and pledged every effort\\nto protect our people and pursue those responsible.\\nThe friendship between our countries, borne out of shared struggle, will not be another casualty of this attack. A free\\nand stable Libya is still in America\\'s interest and security, and we will not turn our back on that nor will we rest until\\nthose responsible for these attacks are found and brought to justice. We are working closely with the Libyan authorities\\nto move swiftly and surely. We are also working with partners around the world to safeguard other American embassies,\\nconsulates, and citizens.\\nThere will be more time later to reflect, but today, we have work to do. There is no higher priority than protecting our\\nmen and women wherever they serve. We are working to determine the precise motivations and methods of those who\\ncarried out this assault. Some have sought to justify this vicious behavior, along with the protest that took place at our\\nEmbassy in Cairo yesterday, as a response to inflammatory material posted on the Internet. America\\'s commitment to\\nreligious tolerance goes back to the very beginning of our nation. But let me be clear —there is no justification for this,\\nnone. Violence like this is no way to honor religion or faith. And as long as there are those who would take innocent life\\nin the name of God, the world will never know a true and lasting peace.\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739562\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045255\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739562\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nIt is especially difficult that this happened on September 11th. It\\'s an anniversary that means a great deal to all\\nAmericans. Every year on that day, we are reminded that our work is not yet finished, that the job of putting an end to\\nviolent extremism and building a safe and stable world continues. But September 11th means even more than that. It is a\\nday on which we remember thousands of American heroes, the bonds that connect all Americans, wherever we are on\\nthis Earth, and the values that see us through every storm. And now it is a day on which we will remember Sean, Chris,\\nand their colleagues.\\nMay God bless them, and may God bless the thousands of Americans working in every corner of the world who make\\nthis country the greatest force for peace, prosperity, and progress, and a force that has always stood for human dignity —\\nthe greatest force the world has ever known. And may God continue to bless the United States of America.\\nThank you.\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739562\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045256\\n\\x0c')\n",
      "(10, 'C05739563', 'MORE ON LIBYA', 'H', '', '', '2012-09-12T04:00:00+00:00', '2015-05-22T04:00:00+00:00', 'DOCUMENTS/HRC_Email_1_296/HRCH2/DOC_0C05739563/C05739563.pdf', 'F-2015-04841', 'HRC_Email_296', 'more on Libya', '', '', '', '', 'F-2015-04841', 'C05739563', '05/13/2015', 'RELEASE IN PART', 'B6\\nWednesday, September 12, 2012 6:16 PM\\nFwd: more on libya\\nLibya 37 sept 12 12.docx\\nSending direct. Just in.\\nSent from my Verizon Wireless 4G LTE DRUID', \"UNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739563\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nRELEASE IN\\nPART B6\\nFrom:\\nSent:\\nTo:\\nSubject\\nAttachments:\\nB6\\nWednesday, September 12, 2012 6:16 PM\\nFwd: more on libya\\nLibya 37 sept 12 12.docx\\nSending direct. Just in.\\nSent from my Verizon Wireless 4G LTE DRUID\\nOriginal Message\\nSubject: more on Libya\\nFrom: tyler drumheller &It: igt;\\nTo &It- Fcgt:\\nCC:\\nB6\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739563\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-5CB0045257\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739563\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\n. PROPRIETARY/CONFIDENTIAL\\nSUBJECT: Libya (37)\\nSOURCE: Sources with direct access to the Libyan National Transitional\\nCouncil, as well as the highest levels of European Governments, and Western\\nIntelligence and security services.\\nTHE FOLLOWING INFORMATION COMES FROM AN EXTREMELY\\nSENSITIVE SOURCE AND SHOULD BE HANDLED WITH CARE.\\n1. On September 12, 2012 Libyan President Mohammed Yussef el Magariaf\\ntold senior advisors that the death of the U.S. Ambassador at the hands of Islamist\\nmilitia forces represents a threat to the future of the newly elected General National\\nCongress (GNC) Government. According to a sensitive source, el Magariaf\\nbelieves that the primary goal of this and other attacks on Western facilities is to\\ndemonstrate that the GNC cannot protect its non-Islamic friends. Libyan security\\nofficials believe that the attack was carried out by forces of the Islamist militia\\ngroup calling itself the Ansar al Sharia brigade; working out of camps in the\\nEastern suburbs of Benghazi. These officials added that their sources indicate that\\nthis group is led by former members of the old Libyan Islamic Fighting Group\\n(LIFG), some of whom are loyal to Islamist General Abdelhakim Belhaj. The\\nsame officials were quick to point out that they have no evidence that Belhaj had\\nany direct involvement in this attack. They also have no direct information as to\\nwhether this assault has anything to do with the death of Libyan born al Qai'da\\nleader Abu Yahya al- Libi, but they are pursuing this theme. These officials do\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739563\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045258\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739563\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nbelieve that the attackers having prepared to launch their assault took advantage of\\nthe cover provided by the demonstrations in Benghazi protesting an intemet\\nproduction seen as disrespectful to the prophet Mohammed.\\n2. According to this source, the immediate events were set in motion by a\\nstatement made by a Muslim Cleric in Egypt saying that the internet film was\\ngoing to be shown across the United States on September 11 in an effort to insult\\nMuslims on the anniversary of the attacks on the New York World Trade Center in\\n2001. This statement inspired increasingly hostile demonstrations at the U.S.\\nEmbassy in Cairo, and at diplomatic facilities in Libya. In Benghazi, reporting\\nfrom security sources states, approximately twenty one (21) Ansar al Sharia\\nfighters left their base in East Benghazi just after sundown infiltrated the crowd of\\nabout 2,000 demonstrators at the U.S. Consulate. These forces, operating under\\ncover of darkness, opened fire on the consulate, eventually setting it on fire with\\nrocket propelled grenades. These fighters then withdrew to their camp. El\\nMagariaf ordered security officials to identify and arrest the attackers, adding that\\nhe had been in touch with Egyptian President Mohm_med Morsi, and the two\\nagreed that their intelligence and security personnel will cooperate in this matter.\\n(Note: Some of the Libyan officials believe that the entire demonstration was\\norganized as cover for the attack, however; they point out that there is no evidence\\nof such a complex operation at this time.\\n3.(Source Comment: In the opinion of this individual, Libyan security\\nofficers also informed el Magariaf that the attacks had been planned for\\napproximately one month, based on casing information obtained during an early\\ndemonstration at the U.S. consulate in Benghazi. The attackers were, in the\\nopinion of these individuals, looking for an opportunity to approach the consulate\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739563\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-5CB0045259\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739563\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\nunder cover in a crowd. These officials add that government security officers\\nadmitted to el Magariaf that they do not have the physical capacity to locate,\\nattack, and destroy the Ansar al-Sharia brigade, among others. They describe these\\nforces as well-trained, hardened killers; many of whom have spent time in\\nAfghanistan and Yemen. These fighters are located in camps in Eastern Libya; and\\nLibyan officials doubt they can penetrate these camps because the militia's are\\nbetter armed than the forces of the new National Army.\\n4. In the opinion of a separate source El Magariaf continues to believe that\\nthe attacks were planned and carried out in a political atmosphere where a portion\\nof the Libyan population is focused on past cooperation between Western\\nintelligence and security services, and the regime of former dictator Muammar al\\nQaddafi. According to this source, el Magariaf realizes that the death of the U.S.\\nAmbassador dictates that he must find tangible solutions to the problems tied to\\ndisarming the militias, dealing Salafist violence against the followers of Sufi\\nbeliefs, and efforts to discredit his government through linking him to Western\\nintelligence services. El Magariaf instructed his security officials to cooperate\\nwith their U.S. counterparts. He also warned all of his advisors to be prepared for\\nU.S. retaliation against the suspected perpetrators of this attack, and the angry\\npublic reaction that is sure to follow.\\n5. (Source Comment: A separate, particularly sensitive source added that in\\nprivate conversation el Magariaf stated that if his government cannot protect a\\nsenior diplomatic official, foreign businesses will not be willing to risk opening up\\nnew operations in Libya. According to this sensitive source, el Magariaf believes\\nthat a number of the Islamist militias are now being influenced al Qai'da and other\\nradical groups; working out of camps in the Eastern and Southeastern parts of the\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739563\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045260\\n\\x0cUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739563\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER.\\ncountry. These groups are receiving aid and weapons from supporters in Sudan.\\nIn the end, el Magariaf added that while he does not expect U.S. officials to focus\\non this point, he believes the attacks against the interests and citizens of the U.S.\\nand other Western states are aimed first at overthrowing his government, and\\nreplacing it with a strict Islamic Republic dominated by Salafist leaders. Magariaf\\nalso warned that tribal militias loyal to the Qaddaft family continue to present an\\nequally dangerous threat to the new Government.)\\nCONFIDENTIAL: This message is confidential, privileged, and is covered by\\nthe Electronic Communications Privacy Act (18 USC 2510). This message and\\nany attachments is intended for the sole use of the addresses(s) and any\\ndiscussion, copying and/or distribution is strictly prohibited. If you have\\nreceived this message in error, please notify the sender, and immediately delete\\nfrom your computer system. Thank you.\\nUNCLASSIFIED\\nU.S. Department of State\\nCase No. F-2015-04841\\nDoc No. C05739563\\nDate: 05/13/2015\\nSTATE DEPT. - PRODUCED TO HOUSE SELECT BENGHAZI COMM.\\nSUBJECT TO AGREEMENT ON SENSITIVE INFORMATION & REDACTIONS. NO FOIA WAIVER. STATE-SCB0045261\\n\\x0c\")\n"
     ]
    }
   ],
   "source": [
    "\n",
    "# Connect to the SQLite database\n",
    "conn = sqlite3.connect(\"archive/database.sqlite\")\n",
    "\n",
    "# Get cursor object\n",
    "cursor = conn.cursor()\n",
    "\n",
    "# Query to fetch first 10 records from the \"emails\" table\n",
    "query = \"SELECT * FROM emails LIMIT 10;\"\n",
    "\n",
    "# Execute the query\n",
    "cursor.execute(query)\n",
    "\n",
    "# Fetch all records\n",
    "records = cursor.fetchall()\n",
    "\n",
    "# Print the fetched records\n",
    "for record in records:\n",
    "    print(record)\n",
    "\n",
    "# Close the connection\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "('Sullivan, Jacob J <Sullivan11@state.gov>',)\n",
      "('',)\n",
      "('Mills, Cheryl D <MillsCD@state.gov>',)\n",
      "('Sullivan, Jacob J <Sullivanli@stategov>',)\n",
      "('Sullivan, Jacob 1 <Sullivan)) state.gov>',)\n",
      "('Sullivan, Jacob J <SullivanJJ@state.gov>',)\n",
      "('Mills, Cheryl 0 <MillsCD@state.gov›',)\n",
      "('Koh, Harold Hongju <KohliFf@state.gov>',)\n",
      "('Sherman, Wendy R <ShermanWR@state.gov>',)\n",
      "('Sullivan, Jacobi <Sullivanii@state.gov>',)\n",
      "('H <hrod17©clintonemaiLcom>',)\n",
      "('H <hrod17@clintonemail.com>',)\n",
      "('Sullivan, Jacob .1 ‹Sullivann@state.gov>',)\n",
      "('Sullivan, Jacob I <Sullivanit@state,gov›',)\n",
      "('Mills, Cheryl 0 <MillsCD@stategov>',)\n",
      "('Burns Strider',)\n",
      "('Abedin, Huma <AbedinH@state.goy>',)\n",
      "('McDonough, Denis R. (mailto: B6',)\n",
      "('Mills, Cheryl 0 <MillsCD@state.gov>',)\n",
      "('Sullivan, Jacob .1 <Sullivarill@state.gov>',)\n",
      "('Russo, Robert V <RussoRV©state.gov>',)\n",
      "('Abeclin, Huma <AbedinH@state.gov>',)\n",
      "('Sullivan, Jacobi <SullivanJJOstate.goy>',)\n",
      "('Mills, Cheryl D',)\n",
      "('H < hrod17@clintonemail.com>-',)\n",
      "('H <hrod17@dintonemailcom>',)\n",
      "('Milts, Cheryl 0 <MillsCD@state.gov>',)\n",
      "('Sullivan, Jacobi <Sullivaniiestate.gov>',)\n",
      "('Sidney Blumenthal',)\n",
      "('H < hrod17@clintonemail.com>',)\n",
      "('Marshall, Capricia P <MarshalICP@state.gov>',)\n",
      "('Anne-Marie Slaughter',)\n",
      "('Burns, William J <BurnsW.1@state.gov>',)\n",
      "('H <hrod17@clintonernail.com>',)\n",
      "('Barton, Rick (CSO)',)\n",
      "('Sullivan, Jacob J <Sullivann@state.gov>',)\n",
      "('Sullivan, Jacob J <SullivanDostate.gov>',)\n",
      "('Mills, Cheryl ID <MillsCD@state.gov>',)\n",
      "('H <hrod17@clintonemailcom>',)\n",
      "('Sullivan, Jacob J <Sullivanii@stategov>',)\n",
      "('Sullivan, Jacobi <SullivanJJ state.gov>',)\n",
      "('H <hrodl7@clintonemaii.com›',)\n",
      "('Hanley, Monica R <HanleyMR@state.gov>',)\n",
      "('H <hrod17©clintonemailcom>',)\n",
      "('Sullivan, Jacob <Sullivanil@state.gov›',)\n",
      "('H <hrod17©clintonemail.com>',)\n",
      "('B6',)\n",
      "('Mills, Cheryl D <MillsCD@state.gov›',)\n",
      "('Schwerin, Daniel B <SchwerinDB@state.gov>',)\n",
      "('Sullivan, Jacob 3 <Sullivanii@state.gov>',)\n",
      "('Abedin, Huma <AbedinH@state.gov>',)\n",
      "('Sullivan, Jacobi <Suilivanll@state.gov>',)\n",
      "('Abedin, Hume <AbeclinH@stategov›',)\n",
      "('Hanky, Monica R <HanleyMR@stategov>',)\n",
      "('Reines, Philippe I < reinesp@state.gove',)\n",
      "('Abedin, Hume <AbedinH©state_gov>',)\n",
      "('H ehrod17@clintonemailcom>',)\n",
      "('Schwerin, Daniel B <SchwerinDB@state.gov›',)\n",
      "('Abedin, Hume <AbedinH state.gov>',)\n",
      "('Sullivan, Jacobi <Sullivan.11@state.gov>',)\n",
      "('lvlills, Cheryl D <MilisCD@state.gov>',)\n",
      "('Tomlinson, Christina B3 CIA PERS/ORG',)\n",
      "('H ‹hrod17@clintonernail.com>',)\n",
      "('Hanley, Monica R <HanleyMR©state.gov>',)\n",
      "('H <hroc117©clintonemailcom>',)\n",
      "('Sullivan, Jacob J <Sullivann@stategov>',)\n",
      "('Hanley, Monica R .<HarileyMR@state.gov>',)\n",
      "('H <hrod17@clintonemall.com›',)\n",
      "('Sullivan, Jacob.) <Sullivaralestate.gov>',)\n",
      "('Hemmen, Chris',)\n",
      "('Sullivan, Jacob J <Sullivanil@state.gov>',)\n",
      "('Mills, Cheryl D <MillsCD©state.gova',)\n",
      "('Sullivan, Jacob .‹Suilivan1J©st.ate.gov>',)\n",
      "('H <hrod17@clintortemail.com›',)\n",
      "('Mills, Cheryl D <MillsCDebstategov>',)\n",
      "('Sullivan, Jacob J <SullivanJJ@state,gov>',)\n",
      "('Mills, Chey 0 <MilisCD@state.gov>',)\n",
      "('Mills, Cheryl D <IVIillsCD@state.gov>',)\n",
      "('H <hrodi 7@clintonemail.com>',)\n",
      "('Sidney Blumenthal B6',)\n",
      "('Mills, Cheryl D <MilLsCD@state.gov›',)\n",
      "('Sullivan, Jacob J <Sullivanll@stategov>',)\n",
      "('Verveer, Melanne S <VerveerMS@state.gov>',)\n",
      "('H <hrod17@clintonernail.corn>',)\n",
      "('Coleman, Claire L <ColemanCL@state.gov>',)\n",
      "('H <hrodl7@ci into nemailcom >',)\n",
      "('Mills, Cheryl D <MillsCD@state.goy>',)\n",
      "('Mills, Cheryl 0 <MillsCDOstate.gov>',)\n",
      "('PIR',)\n",
      "('H <hrod17@clintonemail.corn>',)\n",
      "('H <hrod17@dintonemaii.com>',)\n",
      "('H <brod17@clintonernail.com>',)\n",
      "('Huma Abedin <Hurna@clintonemail.com>',)\n",
      "('Mills, Cheryl D <MilisCD@state.gov>.',)\n",
      "('Mills, Cheryl ID <MillsCD@state.gov›',)\n",
      "('H <hrod17@ciintonernailcom>',)\n",
      "('H 1',)\n",
      "('Mills. Cheryl 0 <ivtillsCD@stategov›',)\n",
      "('H <hrod17@clintoriemail.com>',)\n",
      "('Reines, Philippe I <reinesp@state.gov>',)\n",
      "('H < hrod17@clintonemaii.com>',)\n",
      "('H <hroc117@clintonemail.com>',)\n",
      "('Mills, Cheryl 0 <MillsC0@state.gov›',)\n",
      "('Sullivan, Jacob J <Sullivardi@state.gov>',)\n",
      "('Sullivan, Jacob J <Sullivarill@state.gov>',)\n",
      "('Sullivan, Jacob J eSullivanii@state,gov>',)\n",
      "('Sullivan, Jacob I <Stillivaral@state.gov›',)\n",
      "('Mills, Cheryl D -:MilisCD@stategov>',)\n",
      "('Mills, Cheryl D [mailto:MillsCD@stategovi',)\n",
      "('Sullivan, Jacob .1 <Sullivan.1.1@state.gov>',)\n",
      "('Mills, Cheryl D <MillsCD@stategov>',)\n",
      "('Sullivan, Jacob J <Sulliyantl@state.gov>',)\n",
      "('Mills, Cheryl D [mailto:MillsCD©state.gov]',)\n",
      "('Valmoro, Lona J ‹ValmoroU c stategov>',)\n",
      "('Valnnoro, Lona J <Valmoroti@stategov>',)\n",
      "('H <hrod17@c1intonemai1.com>',)\n",
      "('Coleman, Claire L <ColemanCL@state.gov›',)\n",
      "('Mills, Cheryl 0eMillsCD@state.gov>',)\n",
      "('Cheryl Mills < _',)\n",
      "('Cheryl Mills <',)\n",
      "('Mills, Cheryl D <MillsCD©state.gov>',)\n",
      "('Bums, William J <BurnsWi@state.gov>',)\n",
      "('Nides, Thomas R <NidesTR@state.gov>',)\n",
      "('H ‹hrod17@clintonemailcom>',)\n",
      "('H <hrod17@dintonemail.com>',)\n",
      "('Sullivan, Jacob J <Sullivanii@state.gov>',)\n",
      "('Reines, Philippe) <reinesp@state.gov>',)\n",
      "('Sullivan, Jacob I <Sullivanii@state.gov>',)\n",
      "('Sullivan, JacobJ <Sullivann@state.gov>',)\n",
      "('Sullivan, Jacob I <SullivanJJ@state.gov>',)\n",
      "('Jake Sullivan _',)\n",
      "('Sullivan, Jacob I <Sullivanli@state.gove',)\n",
      "('Sullivan, Jacob J <Sullivanll@state,gov›',)\n",
      "('Sullivan, Jacob .1 <SulliyanJJ©state.gov>',)\n",
      "('Stevens, John C',)\n",
      "('H <hrod17©clintonemail.com›',)\n",
      "('Hanley, Monica R <HanleyMROstate.gov>',)\n",
      "('H <hrod17@clintoneniail.com>',)\n",
      "('Nuland, Victoria 3 <nulandvi@state.gov>',)\n",
      "('Otero, Maria <OteroM2@state.gov>',)\n",
      "('Coleman, Claire L <Colernana@stategovs',)\n",
      "('H <hrod17@clintOnemail.com>',)\n",
      "('H <hrod17@clintonemail.com >',)\n",
      "('Alec',)\n",
      "('H <hrod17@clintonemail corn>',)\n",
      "('H\"<hrod17@clintonemail.com>',)\n",
      "('H <HDR22@clintonemail.com>',)\n",
      "('H <hrod17@clintonemail.com;',)\n",
      "('• H <hrod17@clintonemail.com>',)\n",
      "('Cherie Blair',)\n",
      "('. H <hrod17@clintonemail.com >',)\n",
      "(\"1-1'<hrod17@clintonemail.com>\",)\n",
      "('H',)\n",
      "('Andy Manatos',)\n",
      "('Sid',)\n",
      "('H <hrod17@clintonemail.com> ,',)\n",
      "('H <hrod17@clintonemail.coni>',)\n",
      "('Reines, Philippe I (PACE) <ReinesPI@state.gov>',)\n",
      "('jake.sullivan',)\n",
      "('Valmoro, Lona J <ValmoroU@state.gov>',)\n",
      "('Jiloty, Lauren C <JilotyLC@state.gov>',)\n",
      "('Valmoro, Lona J <ValmoroLJ@state.gov>',)\n",
      "('Mills,.Cheryl D <MillsCD@state.gov>',)\n",
      "('Mills, Cheryl D <MillsCD©state.gov> •',)\n",
      "('cheryl.mills',)\n",
      "('Steinberg, James B <SteinbergJB@state.gov>',)\n",
      "('newmyer on behalf of Jackie Newmyer <newmyer',)\n",
      "('Cheryl Mills[',)\n",
      "('Jiloty, Lauren C <JilotyLC©state.goy>',)\n",
      "('newmyer',)\n",
      "('Abed in, Huma <AbedinH@state.gov>',)\n",
      "('Cheryl Mills',)\n",
      "('Cheryl Mills <cheryl.milk',)\n",
      "('jake.sullivar,',)\n",
      "('Mikulski, BAM (Mikulski) <BAM@Mikulski.senate.gov>',)\n",
      "('wburns66',)\n",
      "('Jake Sullivan <jake.sullivar',)\n",
      "(\"' Mills, Cheryl D <MillsCD@state.gov>\",)\n",
      "('Abedin, Huma <AbedinH©state.gov>',)\n",
      "('newmyer on behalf of Jackie Newmyer',)\n",
      "('Abed in, Huma <AbedinH@state.goy>',)\n",
      "('H.<hrod17@clintonemail.com>',)\n",
      "('Huma Abedin <Huma B6',)\n",
      "('Valmoro, Lona J <VaImoroU@state.gov>',)\n",
      "('Jake Sullivan <jake.sullivan',)\n",
      "('Cheryl Mills <cheryl.mill!',)\n",
      "('Huma Abedin <Huma@clintonemail.com>',)\n",
      "('H [mailto:HDR22@clintonemail.com]',)\n",
      "('Ben Kobren',)\n",
      "('Lissa Muscatine',)\n",
      "('Abedin, Huma <AIDedinH@state.gov>',)\n",
      "('Cheryl Mills <cheryl.mills',)\n",
      "('Jackie Newmyer < B61',)\n",
      "('Jake Sullivan <_',)\n",
      "('Jake Sullivan',)\n",
      "('Jake Sullivan <',)\n",
      "('Mills, Cheryl D <MilIsCD@state.gov>',)\n",
      "('Sullivan, Jacob J <SullivanJJ©state.gov>',)\n",
      "('PIR <preine5',)\n",
      "('Neera Tanden <ntanden',)\n",
      "('Jackie Newmyer',)\n",
      "('pverveer B6',)\n",
      "('sbwhoeop',)\n",
      "('Long Term Strategy Group',)\n",
      "('Abedin, Huma <AbedinH©state,gov>',)\n",
      "('Neera Tanden',)\n",
      "('Jiloty, Lauren C <JilotyLC©state.gov>',)\n",
      "('Sullivan, Jacob 1 <SullivanJJ@state.gov>',)\n",
      "('Jiloty, Lauren C <JilotyLC4state.gov>',)\n",
      "('Lee Feinstein',)\n",
      "('cheryl.mills B6',)\n",
      "('Strobe Talbott',)\n",
      "('Berger, Samuel R.',)\n",
      "('• Abedin, Hurna <AbedinH@state.gov>',)\n",
      "('Abed in, Hu ma <AbedinH@state.gov>',)\n",
      "('Sullivan, JacobJ <SullivanJJ@state.gov>',)\n",
      "('Jeffrey L Farrow',)\n",
      "('PVervee _',)\n",
      "('cheryl.mills _',)\n",
      "('PIR <preines',)\n",
      "('Abedin, Hume <AbedinH@state.gov>',)\n",
      "('Balderston, Kris M <BalderstonKM@state.gov>',)\n",
      "('Verma, Richard R <VermaRR@state.gov>',)\n",
      "('postmaster@state.gov',)\n",
      "('Colin Powell',)\n",
      "('Jeffrey Farrow',)\n",
      "('Eizenstat, Stuart',)\n",
      "('Valmoro, Lona J WalmoroU@state.goy>',)\n",
      "('Russo, Robert V <RussoRV@state.gov>',)\n",
      "('Abedin, Hurna <AbedinH@state.gov>',)\n",
      "('Abedin, Hu ma <AbedinH@state.gov>',)\n",
      "('sbwhoeor',)\n",
      "('Strobe Talbott B6',)\n",
      "('Valmoro, Lona 1 <ValmoroU@state.gov>',)\n",
      "('Axelrod, David M.',)\n",
      "('John Podesta',)\n",
      "('Mikulski, BAM (Mikulski) <BAM@Mikulski.senate.gov>.',)\n",
      "('Adler, Caroline E <AdlerCE@state.gov>',)\n",
      "('Sullivan, Jacob J<SullivanJJ@state.gov>',)\n",
      "('Lissa Muscatine B6',)\n",
      "('Minyon Moore .',)\n",
      "('Sullivan, Jacob .1 <Sullivan11@state.gov>',)\n",
      "('Muscatine, Lissa <MuscatineL@state.gov>',)\n",
      "('Muscatine, Lissa <Muscatinel@state.gov>',)\n",
      "('Valmoro, Lona J WalmoroU@state.gov>',)\n",
      "('Wendy Sherman',)\n",
      "('Sullivan, Jacobi <SullivanJJ@state.gov>',)\n",
      "('Muscatine Lissa',)\n",
      "('Huma Abedin',)\n",
      "('Sullivan, Jacob J <SuIlivan1J@state.gov>',)\n",
      "('Sullivan, Jacob J <Sullivan.11@state.gov>',)\n",
      "('Mikulski, BAM (Mikulski)',)\n",
      "('jake.sullivan(',)\n",
      "('Shapiro, Andrew J <ShapiroA@state.gov>',)\n",
      "('ChoIlet, Derek H <CholletDH@state.gov>',)\n",
      "('Philippe Reines',)\n",
      "('Axelrod, David M. B6',)\n",
      "('Wendy Sherman <',)\n",
      "('wburns66 B6 I',)\n",
      "('Donilon, Thomas E.',)\n",
      "('Jacob Lew <',)\n",
      "('Strobe Talbott <',)\n",
      "('PIR <preines B6',)\n",
      "('CdeBaca, Luis',)\n",
      "('Lou de Baca, G/TIP',)\n",
      "('* Abedin, Huma <AbedinH@state.gov>',)\n",
      "('Rubiner, Laurie',)\n",
      "('Ilic, Werner X',)\n",
      "('Muscatine Lissa <',)\n",
      "('Crowley, Philip J <CrowleyPJ@state.gov>',)\n",
      "('Feltman, Jeffrey D <FeltmanJD@state.gov>',)\n",
      "('PVervee',)\n",
      "('pverveer',)\n",
      "('Mitchell, George',)\n",
      "('Valmoro, Lona1 <ValmoroU@state.gov>',)\n",
      "('Sullivan, Jacob J <SulliyanJJ@state.gov>',)\n",
      "('PIR <',)\n",
      "('Campbell, Kurt M <CampbellKM@state.gov>',)\n",
      "('0 Mills, Cheryl D <MillsCD@state.gov>',)\n",
      "('capriciamarshall',)\n",
      "('Fuchs, Michael H <FuchsMH@state.gov>',)\n",
      "('PVerveer',)\n",
      "('pvervee',)\n",
      "('Mills, Cheryl D <MillsCD@state.gov> BEST COPY',)\n",
      "('Abedin, Huma <AbedinH@state.goV>',)\n",
      "('Lew, Jacob J <LewJJ@state.gov>',)\n",
      "('Koh, Harold Hongju',)\n",
      "('Berger, Samuel R. B6',)\n",
      "('Mills, Cheryl D <MiIIsCD©state.gov>',)\n",
      "('Koh, Harold Hongju <KohHH@state.gov>',)\n",
      "('Abedin, Huma <AbedinH@state.gov> .',)\n",
      "('sbwhoeopc',)\n",
      "('sbwhoeop B6',)\n",
      "('Crowley, Philip J <CrowleyPJ©state.gov>',)\n",
      "('Verveer, Melanne S WerveerMS@state.gov>',)\n",
      "('Slaughter, Anne-Marie <SlaughterA@state.gov>',)\n",
      "('Shannon, Thomas A <ShannonTA@state.gov>',)\n",
      "('Jones, Paul W <JonesPW2@state.gov>',)\n",
      "('cheryl.millsc',)\n",
      "('Rodriguez, Miguel E <RodriguezME@state.gov>',)\n",
      "('Hill, Christopher R (Baghdad) <HilICR@state.gov>',)\n",
      "('M.K Albright <',)\n",
      "('Dewan, Linda L <DewanLL@state.gov>',)\n",
      "('Tauscher, Ellen 0 <TauscherE0@state.gov>',)\n",
      "('PIR <preines(',)\n",
      "('Valmoro, Lona J <ValmoroU©state.gov>',)\n",
      "('Jake Sullivar',)\n",
      "('Gina Glantz B6',)\n",
      "('Voda ebeling',)\n",
      "('Abedin, Huma eAbedinH@state.gov>',)\n",
      "('Sullivan, Jacob I <Sullivann@state.gov>',)\n",
      "('Lew, Jacob 1 <Lewil@state.gov>',)\n",
      "('Abedin, Huma <AbedinH©state.goy>',)\n",
      "('sbwhoeop B61',)\n",
      "('Gordon, Philip H <GordonPH©state.gov>',)\n",
      "('Koh, Harold Hongju <KohHH©state.gov>',)\n",
      "('Valmoro, Lona J <ValmoroU@state.goy>',)\n",
      "('info@mailva.evite.com',)\n",
      "('Daniel Baer',)\n",
      "('Reta Jo Lewis, Special Representative, Global Intergovernmental Affairs',)\n",
      "(\"Sullivan, 'Jacob J <SullivanJJ@state.gov>\",)\n",
      "('Carson, Johnnie <CarsonJ@state.gov>',)\n",
      "('Daniel Baer •',)\n",
      "('Daniel Baer <',)\n",
      "('Huma Abedin <',)\n",
      "('Sullivan, Jacobi <Sullivarill@state.gov>',)\n",
      "('Baer, Daniel B <BaerDB@state.gov>',)\n",
      "('Verma, Richard R <VermaRR©state.gov>',)\n",
      "('Marshall, Capricia P <MarshalICP©state.goy>',)\n",
      "('Cherie Blair <',)\n",
      "('Toiv, Nora F <ToivNF@state.gov>',)\n",
      "('KPK',)\n",
      "('Merten, Kenneth H',)\n",
      "('PIR <preine',)\n",
      "('Burns, William J <BurnsWJ@state.gov>',)\n",
      "('McHale, Judith A <McHaleJA@state.gov>',)\n",
      "('Stern, Todd D (S/SECC) <SternTD@state.gov>',)\n",
      "('Verveer, Melanne S <VerveerMS©state.gov>',)\n",
      "('Slaughter, Anne-Marie <SlaughterA©state.gov>',)\n",
      "('Sullivan, Jacob 1 <SullivanJ1@state.gov>',)\n",
      "('Valmoro, Lona 1 <ValmoroU©state.gov>',)\n",
      "('Mills, Cheryl D <MillsCD©state.goy>',)\n",
      "('cheryl.mill',)\n",
      "('Shah, Rajiv (AID/A)',)\n",
      "('sbwhoeor.,',)\n",
      "('Hormats, Robert D <HormatsRD@state.gov>',)\n",
      "('Tillemann, Tomicah S',)\n",
      "('Sullivan, Jacob 1 <Sullivanii@state.gov>',)\n",
      "('McHale, Judith A <McHaleJA©state.gov>',)\n",
      "('sbwhoecip',)\n",
      "('Feltman, Jeffrey D <FeltmanJD©state.gov>',)\n",
      "('Jiloty, Lauren C <JilotyLC@state.goy>',)\n",
      "('. Sullivan, Jacobi <Sullivanil@state.gov>',)\n",
      "('Sullivan, Jacob J <Sullivaral@state.gov>',)\n",
      "('Sullivan, Jacob 1 <Sullivann@state.gov>',)\n",
      "('betsyebelin',)\n",
      "('Shannon, Thomas A',)\n",
      "('Capricia Marshall',)\n",
      "('sbwhoeor B6',)\n",
      "('Recos',)\n",
      "('Kelly, Craig A <KellyC@state.gov>',)\n",
      "('Daniel Meron',)\n",
      "('Butzgy, Christopher H <ButzgyCH2@state.gov>',)\n",
      "('Fuchs, Michael H <FuchsMH©state.gov>',)\n",
      "('Sullivan, Jacob i <Sullivanil@state.gov>',)\n",
      "('Mills; Cheryl D <MillsCD@state.gov>',)\n",
      "('Colby Cooper',)\n",
      "('Burns, William J <BurnsWi@state.gov>',)\n",
      "('Brimmer, Esther D <BrimmerE@state.gov>',)\n",
      "('Sullivan, Jacobi <Sullivan11@state.gov>',)\n",
      "('Cheryl Mills B6',)\n",
      "('Lew, Jacob J <Lew1J@state.gov>',)\n",
      "('Rooney, Megan <RooneyM@state.gov>',)\n",
      "('Ebeling, Betsy',)\n",
      "('sbwhoeor.',)\n",
      "('Sullivan, Jacob J <Sullivan1.1@state.gov>',)\n",
      "('Beale, Courtney A Kramer <BealeCA@state.gov>',)\n",
      "('Fareed Zein',)\n",
      "('Balderston, Kris M <BalderstonKM©state.gov>',)\n",
      "('Tillemann, Tomicah S <TillemannTS@state.gov>',)\n",
      "('Verveer, Melanne S <VerveerM5@state.gov>',)\n",
      "('Sullivan, JacobJ <SullivanJJ©state.gov>',)\n",
      "('Sullivan, Jacob i <Sullivanii@state.gov>',)\n",
      "('Sullivan, Jacobi <Sullivanil@state.gov>',)\n",
      "('Huma Abedin <Huma@clintonemail.com >',)\n",
      "('Blake, Robert 0 <BlakeR2@state.gov>',)\n",
      "('Valenzuela, Arturo A <ValenzuelaAA@state.gov>',)\n",
      "('Sullivan, Jacob J <SullivanJ1@state.gov>',)\n",
      "('Reines, Philippe I <reinesp@state.goy>',)\n",
      "('Crowley, Philip J <CrowleyP1@state.gov>',)\n",
      "('Crowley, Philip 1 <Crowley13.1@state.gov>',)\n",
      "('Crowley, Philip1 <CrowleyR1@state.gov>',)\n",
      "('Tillemann, Tomicah S <TillemannTS©state.gov>',)\n",
      "('Sullivan, Jacob J <Sullivarth@state.gov>',)\n",
      "('Sullivan, Jacobi <Sullivann@state.gov>',)\n",
      "('sbvvhoeop',)\n",
      "('Muscatine, Lissa <MuscatineL©state.gov>',)\n",
      "('H <HDR22@ciintonemail.com>',)\n",
      "('C — Cheryl Mills',)\n",
      "('PIR <preines >',)\n",
      "('Sullivan, Jacob <SullivanJJ@state.gov>',)\n",
      "('Rice, Susan E (USUN) <RiceSE@state.gov>',)\n",
      "('Ebeling, Betsy <',)\n",
      "('Sullivan, Jacobi <SullivanJJ©state.gov>',)\n",
      "('Abedin,,Huma <AbedinH@state.goy>',)\n",
      "('Philippe Reines < B6',)\n",
      "('Philippe Reines <',)\n",
      "('Sullivan, Jacob.) <SullivanJJ@state.gov>',)\n",
      "('Strobe Talbott < >',)\n",
      "('Hanley, Monica R <HanleyMR@state.goy>',)\n",
      "('Cherie Blair < >',)\n",
      "('Valmoro, Lona J <ValmoroU©state.goy>',)\n",
      "('Lew, Jacob J <LewJJ©state.gov>',)\n",
      "('Holbrooke, Richard',)\n",
      "('Slaughter, Anne-Marie',)\n",
      "('P1R <preines',)\n",
      "('McHale, Judith A <McHaleJA©state.goy>',)\n",
      "('Rooney, Megan <RooneyM©state.gov>',)\n",
      "('Sullivan, Jacob 1 <SullivanJJ©state.gov>',)\n",
      "('betsyebeling',)\n",
      "('Zachary Iscol',)\n",
      "('Sullivan, Jacob .1 <SullivanJJ@state.gov>',)\n",
      "('PIR <prein0',)\n",
      "('Jiloty, Lauren C dilotyLC@state.gov>',)\n",
      "('Mitchell, George <',)\n",
      "('Sullivan, Jacobi <Sullivantl@state.gov>',)\n",
      "('Verma, Richard R <VermaRR©state.goy>',)\n",
      "('Marshall, Capricia P <MarshalICP@state.gdy>',)\n",
      "('Samuel Berger',)\n",
      "('PIR <preines(i _',)\n",
      "('PVerveeL',)\n",
      "('Valmoro, Lona .1 <ValmoroU@state.gov>',)\n",
      "('Lauren Jiloty',)\n",
      "('Huma Abedin <Humat',)\n",
      "('Lew, Jacob J <Lewil@state.gov>',)\n",
      "('Sullivan, Jacob J <Sullivan.1.1@state.gov>',)\n",
      "('Jiloty, Lauren C <filotyLC@state.gov>',)\n",
      "('Valmoro, Lona1 <ValmoroLJ@state.gov>',)\n",
      "('Sandy',)\n",
      "('Crowley, Philip J <CrowleyR1@state.gov>',)\n",
      "('Sullivan, Jacob 1 <Sullivan11@state.gov>',)\n",
      "('Lauren Jiloty <laurenjiloty',)\n",
      "('Lauren Jiloty <laurenjiloty B6',)\n",
      "('Jake Sullivan B6',)\n",
      "('Jeffrey L Farrow <',)\n",
      "('Mills, Cheryl D <MillsCDOstate.gov>',)\n",
      "('Slaughter, Anne-Marie <SlaughterA@state.gov> I',)\n",
      "('Campbell, Kurt M <CampbelIKM@state.gov>',)\n",
      "('Abed in, Huma <AbedinH©state.gov>',)\n",
      "('Mills, Cheryl D <MillsCD@state.gov> _',)\n",
      "('Gordon, Philip H <GordonPH@state.gov>',)\n",
      "('Lew, Jacob J <Lewn@state.gov>',)\n",
      "('Jake Sullivan < >',)\n",
      "('Lissa Muscatine <',)\n",
      "('Samuel Berger <',)\n",
      "('Sullivan, Jacob 1 <SullivarW@state.gov>',)\n",
      "('Laszczych, Joanne <Laszczychi@state.gov>',)\n",
      "('Laszczych, Joanne <LaszczychJ@state.gov>',)\n",
      "('Woodard, Eric W <WoodardEW@state.gov>',)\n",
      "('Sullivan, Jacob) <Sullivann@state.gov>',)\n",
      "('Lissa Muscatine < >',)\n",
      "('Lauren Jiloty < >',)\n",
      "('Abedin, Hume <AbedinH©state.gov>',)\n",
      "('Lissa Muscatine < > Bi6',)\n",
      "('Verma, Richard R <VermaRR@state.gov?',)\n",
      "('Sullivan, Jacob J <Sullivard1@state.gov>',)\n",
      "('jake.sullivar',)\n",
      "('Sullivan, Jacob I <Sullivanil@state.gov>',)\n",
      "('Mills, Cheryl D <MiilsCD@state.gov>',)\n",
      "('- Abedin, Huma <AbedinH@state.gov>',)\n",
      "('Daniel, Joshua J <DanieW@state.gov>',)\n",
      "('Daniel, Joshua J <Danielil@state.gov>',)\n",
      "('Megan Rooney',)\n",
      "('Mikulski, BAM (Mikulski) <BAM@Mikuiski.senate.gov>',)\n",
      "('H < hrod17@clintonemail.com >',)\n",
      "('jake.sullivan B6',)\n",
      "('Jiloty, Lauren C <JilotylC@state.gov>',)\n",
      "('H <hrodl7@clintonemail.com>',)\n",
      "('Steven.EVERTS',)\n",
      "('Sullivan, JacobJ <Sullivanil@state.gov>',)\n",
      "('H <hrod176clintonemail.com>',)\n",
      "('H <hrod17@clintonemaiLcom>',)\n",
      "('Smith, James E <SmithJE©state.gov>',)\n",
      "('Campbell, Piper <CampbellP@state.gov>',)\n",
      "('Hyde, Dana <HydeD@state.gov>',)\n",
      "('H <hrod17@clintonernail.com >',)\n",
      "('aclb',)\n",
      "('aclb <',)\n",
      "('Huma Abedin < >',)\n",
      "('Sullivan, Jacob 1 <Sullivanil@state.gov>',)\n",
      "('Rodriguez, Miguel E <RodriguezME©state.gov>',)\n",
      "('Sullivan, Jacob1 <SullivanJJ@state.gov>',)\n",
      "('•H <hrod17@clintonemail.com>',)\n",
      "('Rina Amiri',)\n",
      "('H <hrod17@clintonemail.com> I',)\n",
      "('H hrod17@clintonemail.com>',)\n",
      "('H <hrod17@clintonemail.com>.',)\n",
      "('Burns Strider B6',)\n",
      "('aclb B6',)\n",
      "(\"Sullivan, Jacob.' <SullivanJ1@state.gov>\",)\n",
      "('Scott Gration',)\n",
      "('David Brock',)\n",
      "('Strobe Talbott <STALBOTT',)\n",
      "('Lanny J. Davis',)\n",
      "('Sullivan, Jacob I <Sullivan11@state.gov>',)\n",
      "('PIR <preine;',)\n",
      "('Sullivan, Jacob., <Sullivan.1.1@state.gov>',)\n",
      "('Jake Sullivan •',)\n"
     ]
    }
   ],
   "source": [
    "# Connect to the SQLite database\n",
    "conn = sqlite3.connect(\"archive/database.sqlite\")\n",
    "\n",
    "# Get cursor object\n",
    "cursor = conn.cursor()\n",
    "\n",
    "# Query to fetch first 10 records from the \"emails\" table\n",
    "query = \"SELECT DISTINCT ExtractedFrom FROM emails;\"\n",
    "\n",
    "# Execute the query\n",
    "cursor.execute(query)\n",
    "\n",
    "# Fetch all records\n",
    "records = cursor.fetchall()\n",
    "\n",
    "# Print the fetched records\n",
    "for record in records:\n",
    "    print(record)\n",
    "\n",
    "# Close the connection\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sqlite3\n",
    "\n",
    "# Connect to the SQLite database\n",
    "conn = sqlite3.connect(\"archive/database.sqlite\")\n",
    "\n",
    "# Get cursor object\n",
    "cursor = conn.cursor()\n",
    "\n",
    "# Query to fetch rows containing the keyword \"Israel\" in the \"ExtractedBodyText\" column\n",
    "query = \"SELECT ExtractedBodyText FROM emails WHERE lower(ExtractedBodyText) LIKE '%israel%';\"\n",
    "\n",
    "# Execute the query\n",
    "cursor.execute(query)\n",
    "\n",
    "# Fetch all rows\n",
    "rows = cursor.fetchall()\n",
    "\n",
    "# Define the file name\n",
    "file_name = \"email_israel.txt\"\n",
    "\n",
    "# Open the file in write mode\n",
    "with open(file_name, \"w\") as file:\n",
    "    # Write each row to the file\n",
    "    for row in rows:\n",
    "        file.write(str(row) + \"\\n\")\n",
    "\n",
    "\n",
    "# Close the connection\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.18"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}