data_extraction/notebooks/csv_extraction.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# CSV extraction"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This notebook shows examples of text extraction from csv files with different packages"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Table of contents**<a id='toc0_'></a>    \n",
    "- 1. [Methods to load csv files](#toc1_)    \n",
    "  - 1.1. [Load from CSV Loader](#toc1_1_)    \n",
    "    - 1.1.1. [Customize csv parsing and loading](#toc1_1_1_)    \n",
    "    - 1.1.2. [CSV loder with custom field names](#toc1_1_2_)    \n",
    "  - 1.2. [Load from pandas](#toc1_2_)    \n",
    "  - 1.3. [Load from Unstructed.io](#toc1_3_)    \n",
    "- 2. [Evaluate loded docs by embedding similarity](#toc2_)    \n",
    "  - 2.1. [Evaluate embedding by similarity](#toc2_1_)    \n",
    "  - 2.2. [Similarity search](#toc2_2_)    \n",
    "\n",
    "<!-- vscode-jupyter-toc-config\n",
    "\tnumbering=true\n",
    "\tanchor=true\n",
    "\tflat=false\n",
    "\tminLevel=2\n",
    "\tmaxLevel=4\n",
    "\t/vscode-jupyter-toc-config -->\n",
    "<!-- THIS CELL WILL BE REPLACED ON TOC UPDATE. DO NOT WRITE YOUR TEXT IN THIS CELL -->"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/p4/y0q2kh796nx_k_yzfhxs57f00000gp/T/ipykernel_17588/524060276.py:15: TqdmWarning: IProgress not found. Please update jupyter and ipywidgets. See https://ipywidgets.readthedocs.io/en/stable/user_install.html\n",
      "  from tqdm.autonotebook import trange\n"
     ]
    }
   ],
   "source": [
    "import os\n",
    "import sys\n",
    "\n",
    "current_dir = os.getcwd()\n",
    "kit_dir = os.path.abspath(os.path.join(current_dir, \"..\"))\n",
    "repo_dir = os.path.abspath(os.path.join(kit_dir, \"..\"))\n",
    "\n",
    "sys.path.append(kit_dir)\n",
    "sys.path.append(repo_dir)\n",
    "\n",
    "import glob\n",
    "import pandas as pd\n",
    "from dotenv import load_dotenv\n",
    "from langchain.text_splitter import RecursiveCharacterTextSplitter\n",
    "from tqdm.autonotebook import trange\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1. <a id='toc1_'></a>[Methods to load csv files](#toc0_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "folder_loc = os.path.join(kit_dir,'data/sample_data/sample_files/')\n",
    "csv_files = list(glob.glob(f'{folder_loc}/*.csv'))\n",
    "file_path = csv_files[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##### Load text splitter"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "text_splitter = RecursiveCharacterTextSplitter(\n",
    "        # Set a small chunk size, just to make splitting evident.\n",
    "        chunk_size = 200,\n",
    "        chunk_overlap  = 20,\n",
    "        length_function = len,\n",
    "        add_start_index = True,\n",
    "        separators = [\"\\n\\n\\n\",\"\\n\",\" \"]\n",
    "    )"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1.1. <a id='toc1_1_'></a>[Load from CSV Loader](#toc0_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index: 1\n",
      "Customer Id: DD37Cf93aecA6Dc\n",
      "First Name: Sheryl\n",
      "Last Name: Baxter\n",
      "Company: Rasmussen Group\n",
      "City: East Leonard\n",
      "Country: Chile\n",
      "Phone 1: 229.077.5154\n",
      "Phone 2: 397.884.0519x718\n",
      "Email: zunigavanessa@smith.info\n",
      "Subscription Date: 2020-08-24\n",
      "Website: http://www.stephenson.com/\n",
      "\n",
      "Index: 2\n",
      "Customer Id: 1Ef7b82A4CAAD10\n",
      "First Name: Preston\n",
      "Last Name: Lozano\n",
      "Company: Vega-Gentry\n",
      "City: East Jimmychester\n",
      "Country: Djibouti\n",
      "Phone 1: 5153435776\n",
      "Phone 2: 686-620-1820x944\n",
      "Email: vmata@colon.com\n",
      "Subscription Date: 2021-04-23\n",
      "Website: http://www.hobbs.com/\n",
      "\n",
      "Index: 3\n",
      "Customer Id: 6F94879bDAfE5a6\n",
      "First Name: Roy\n",
      "Last Name: Berry\n",
      "Company: Murillo-Perry\n",
      "City: Isabelborough\n",
      "Country: Antigua and Barbuda\n",
      "Phone 1: +1-539-402-0259\n",
      "Phone 2: (496)978-3969x58947\n",
      "Email: beckycarr@hogan.com\n",
      "Subscription Date: 2020-03-25\n",
      "Website: http://www.lawrence.com/\n",
      "\n",
      "Index: 4\n",
      "Customer Id: 5Cef8BFA16c5e3c\n",
      "First Name: Linda\n",
      "Last Name: Olsen\n",
      "Company: Dominguez, Mcmillan and Donovan\n",
      "City: Bensonview\n",
      "Country: Dominican Republic\n",
      "Phone 1: 001-808-617-6467x12895\n",
      "Phone 2: +1-813-324-8756\n",
      "Email: stanleyblackwell@benson.org\n",
      "Subscription Date: 2020-06-02\n",
      "Website: http://www.good-lyons.com/\n",
      "\n",
      "Index: 5\n",
      "Customer Id: 053d585Ab6b3159\n",
      "First Name: Joanna\n",
      "Last Name: Bender\n",
      "Company: Martin, Lang and Andrade\n",
      "City: West Priscilla\n",
      "Country: Slovakia (Slovak Republic)\n",
      "Phone 1: 001-234-203-0635x76146\n",
      "Phone 2: 001-199-446-3860x3486\n",
      "Email: colinalvarado@miles.net\n",
      "Subscription Date: 2021-04-17\n",
      "Website: https://goodwin-ingram.com/\n",
      "\n",
      "Index: 6\n",
      "Customer Id: 2d08FB17EE273F4\n",
      "First Name: Aimee\n",
      "Last Name: Downs\n",
      "Company: Steele Group\n",
      "City: Chavezborough\n",
      "Country: Bosnia and Herzegovina\n",
      "Phone 1: (283)437-3886x88321\n",
      "Phone 2: 999-728-1637\n",
      "Email: louis27@gilbert.com\n",
      "Subscription Date: 2020-02-25\n",
      "Website: http://www.berger.net/\n",
      "\n",
      "Index: 7\n",
      "Customer Id: EA4d384DfDbBf77\n",
      "First Name: Darren\n",
      "Last Name: Peck\n",
      "Company: Lester, Woodard and Mitchell\n",
      "City: Lake Ana\n",
      "Country: Pitcairn Islands\n",
      "Phone 1: (496)452-6181x3291\n",
      "Phone 2: +1-247-266-0963x4995\n",
      "Email: tgates@cantrell.com\n",
      "Subscription Date: 2021-08-24\n",
      "Website: https://www.le.com/\n",
      "\n",
      "Index: 8\n",
      "Customer Id: 0e04AFde9f225dE\n",
      "First Name: Brett\n",
      "Last Name: Mullen\n",
      "Company: Sanford, Davenport and Giles\n",
      "City: Kimport\n",
      "Country: Bulgaria\n",
      "Phone 1: 001-583-352-7197x297\n",
      "Phone 2: 001-333-145-0369\n",
      "Email: asnow@colon.com\n",
      "Subscription Date: 2021-04-12\n",
      "Website: https://hammond-ramsey.com/\n",
      "\n",
      "Index: 9\n",
      "Customer Id: C2dE4dEEc489ae0\n",
      "First Name: Sheryl\n",
      "Last Name: Meyers\n",
      "Company: Browning-Simon\n",
      "City: Robersonstad\n",
      "Country: Cyprus\n",
      "Phone 1: 854-138-4911x5772\n",
      "Phone 2: +1-448-910-2276x729\n",
      "Email: mariokhan@ryan-pope.org\n",
      "Subscription Date: 2020-01-13\n",
      "Website: https://www.bullock.net/\n",
      "\n",
      "Index: 10\n",
      "Customer Id: 8C2811a503C7c5a\n",
      "First Name: Michelle\n",
      "Last Name: Gallagher\n",
      "Company: Beck-Hendrix\n",
      "City: Elaineberg\n",
      "Country: Timor-Leste\n",
      "Phone 1: 739.218.2516x459\n",
      "Phone 2: 001-054-401-0347x617\n",
      "Email: mdyer@escobar.net\n",
      "Subscription Date: 2021-11-08\n",
      "Website: https://arias.com/\n",
      "\n",
      "Index: 11\n",
      "Customer Id: 216E205d6eBb815\n",
      "First Name: Carl\n",
      "Last Name: Schroeder\n",
      "Company: Oconnell, Meza and Everett\n",
      "City: Shannonville\n",
      "Country: Guernsey\n",
      "Phone 1: 637-854-0256x825\n",
      "Phone 2: 114.336.0784x788\n",
      "Email: kirksalas@webb.com\n",
      "Subscription Date: 2021-10-20\n",
      "Website: https://simmons-hurley.com/\n",
      "\n",
      "Index: 12\n",
      "Customer Id: CEDec94deE6d69B\n",
      "First Name: Jenna\n",
      "Last Name: Dodson\n",
      "Company: Hoffman, Reed and Mcclain\n",
      "City: East Andrea\n",
      "Country: Vietnam\n",
      "Phone 1: (041)737-3846\n",
      "Phone 2: +1-556-888-3485x42608\n",
      "Email: mark42@robbins.com\n",
      "Subscription Date: 2020-11-29\n",
      "Website: http://www.douglas.net/\n",
      "\n",
      "Index: 13\n",
      "Customer Id: e35426EbDEceaFF\n",
      "First Name: Tracey\n",
      "Last Name: Mata\n",
      "Company: Graham-Francis\n",
      "City: South Joannamouth\n",
      "Country: Togo\n",
      "Phone 1: 001-949-844-8787\n",
      "Phone 2: (855)713-8773\n",
      "Email: alex56@walls.org\n",
      "Subscription Date: 2021-12-02\n",
      "Website: http://www.beck.com/\n",
      "\n",
      "Index: 14\n",
      "Customer Id: A08A8aF8BE9FaD4\n",
      "First Name: Kristine\n",
      "Last Name: Cox\n",
      "Company: Carpenter-Cook\n",
      "City: Jodyberg\n",
      "Country: Sri Lanka\n",
      "Phone 1: 786-284-3358x62152\n",
      "Phone 2: +1-315-627-1796x8074\n",
      "Email: holdenmiranda@clarke.com\n",
      "Subscription Date: 2021-02-08\n",
      "Website: https://www.brandt.com/\n",
      "\n",
      "Index: 15\n",
      "Customer Id: 6fEaA1b7cab7B6C\n",
      "First Name: Faith\n",
      "Last Name: Lutz\n",
      "Company: Carter-Hancock\n",
      "City: Burchbury\n",
      "Country: Singapore\n",
      "Phone 1: (781)861-7180x8306\n",
      "Phone 2: 207-185-3665\n",
      "Email: cassieparrish@blevins-chapman.net\n",
      "Subscription Date: 2022-01-26\n",
      "Website: http://stevenson.org/\n",
      "\n",
      "Index: 16\n",
      "Customer Id: 8cad0b4CBceaeec\n",
      "First Name: Miranda\n",
      "Last Name: Beasley\n",
      "Company: Singleton and Sons\n",
      "City: Desireeshire\n",
      "Country: Oman\n",
      "Phone 1: 540.085.3135x185\n",
      "Phone 2: +1-600-462-6432x21881\n",
      "Email: vduncan@parks-hardy.com\n",
      "Subscription Date: 2022-04-12\n",
      "Website: http://acosta.org/\n",
      "\n",
      "Index: 17\n",
      "Customer Id: a5DC21AE3a21eaA\n",
      "First Name: Caroline\n",
      "Last Name: Foley\n",
      "Company: Winters-Mendoza\n",
      "City: West Adriennestad\n",
      "Country: Western Sahara\n",
      "Phone 1: 936.222.4746x9924\n",
      "Phone 2: 001-469-948-6341x359\n",
      "Email: holtgwendolyn@watson-davenport.com\n",
      "Subscription Date: 2021-03-10\n",
      "Website: http://www.benson-roth.com/\n",
      "\n",
      "Index: 18\n",
      "Customer Id: F8Aa9d6DfcBeeF8\n",
      "First Name: Greg\n",
      "Last Name: Mata\n",
      "Company: Valentine LLC\n",
      "City: Lake Leslie\n",
      "Country: Mozambique\n",
      "Phone 1: (701)087-2415\n",
      "Phone 2: (195)156-1861x26241\n",
      "Email: jaredjuarez@carroll.org\n",
      "Subscription Date: 2022-03-26\n",
      "Website: http://pitts-cherry.com/\n",
      "\n",
      "Index: 19\n",
      "Customer Id: F160f5Db3EfE973\n",
      "First Name: Clifford\n",
      "Last Name: Jacobson\n",
      "Company: Simon LLC\n",
      "City: Harmonview\n",
      "Country: South Georgia and the South Sandwich Islands\n",
      "Phone 1: 001-151-330-3524x0469\n",
      "Phone 2: (748)477-7174\n",
      "Email: joseph26@jacobson.com\n",
      "Subscription Date: 2020-09-24\n",
      "Website: https://mcconnell.com/\n",
      "\n",
      "Index: 20\n",
      "Customer Id: 0F60FF3DdCd7aB0\n",
      "First Name: Joanna\n",
      "Last Name: Kirk\n",
      "Company: Mays-Mccormick\n",
      "City: Jamesshire\n",
      "Country: French Polynesia\n",
      "Phone 1: (266)131-7001x711\n",
      "Phone 2: (283)312-5579x11543\n",
      "Email: tuckerangie@salazar.net\n",
      "Subscription Date: 2021-09-24\n",
      "Website: https://www.camacho.net/\n",
      "\n",
      "Index: 21\n",
      "Customer Id: 9F9AdB7B8A6f7F2\n",
      "First Name: Maxwell\n",
      "Last Name: Frye\n",
      "Company: Patterson Inc\n",
      "City: East Carly\n",
      "Country: Malta\n",
      "Phone 1: 423.262.3059\n",
      "Phone 2: 202-880-0688x7491\n",
      "Email: fgibson@drake-webb.com\n",
      "Subscription Date: 2022-01-12\n",
      "Website: http://www.roberts.com/\n",
      "\n",
      "Index: 22\n",
      "Customer Id: FBd0Ded4F02a742\n",
      "First Name: Kiara\n",
      "Last Name: Houston\n",
      "Company: Manning, Hester and Arroyo\n",
      "City: South Alvin\n",
      "Country: Netherlands\n",
      "Phone 1: 001-274-040-3582x10611\n",
      "Phone 2: +1-528-175-0973x4684\n",
      "Email: blanchardbob@wallace-shannon.com\n",
      "Subscription Date: 2020-09-15\n",
      "Website: https://www.reid-potts.com/\n",
      "\n",
      "Index: 23\n",
      "Customer Id: 2FB0FAA1d429421\n",
      "First Name: Colleen\n",
      "Last Name: Howard\n",
      "Company: Greer and Sons\n",
      "City: Brittanyview\n",
      "Country: Paraguay\n",
      "Phone 1: 1935085151\n",
      "Phone 2: (947)115-7711x5488\n",
      "Email: rsingleton@ryan-cherry.com\n",
      "Subscription Date: 2020-08-19\n",
      "Website: http://paul.biz/\n",
      "\n",
      "Index: 24\n",
      "Customer Id: 010468dAA11382c\n",
      "First Name: Janet\n",
      "Last Name: Valenzuela\n",
      "Company: Watts-Donaldson\n",
      "City: Veronicamouth\n",
      "Country: Lao People's Democratic Republic\n",
      "Phone 1: 354.259.5062x7538\n",
      "Phone 2: 500.433.2022\n",
      "Email: stefanie71@spence.com\n",
      "Subscription Date: 2020-09-08\n",
      "Website: https://moreno.biz/\n",
      "\n",
      "Index: 25\n",
      "Customer Id: eC1927Ca84E033e\n",
      "First Name: Shane\n",
      "Last Name: Wilcox\n",
      "Company: Tucker LLC\n",
      "City: Bryanville\n",
      "Country: Albania\n",
      "Phone 1: (429)005-9030x11004\n",
      "Phone 2: 541-116-4501\n",
      "Email: mariah88@santos.com\n",
      "Subscription Date: 2021-04-06\n",
      "Website: https://www.ramos.com/\n",
      "\n",
      "Index: 26\n",
      "Customer Id: 09D7D7C8Fe09aea\n",
      "First Name: Marcus\n",
      "Last Name: Moody\n",
      "Company: Giles Ltd\n",
      "City: Kaitlyntown\n",
      "Country: Panama\n",
      "Phone 1: 674-677-8623\n",
      "Phone 2: 909-277-5485x566\n",
      "Email: donnamullins@norris-barrett.org\n",
      "Subscription Date: 2022-05-24\n",
      "Website: https://www.curry.com/\n",
      "\n",
      "Index: 27\n",
      "Customer Id: aBdfcF2c50b0bfD\n",
      "First Name: Dakota\n",
      "Last Name: Poole\n",
      "Company: Simmons Group\n",
      "City: Michealshire\n",
      "Country: Belarus\n",
      "Phone 1: (371)987-8576x4720\n",
      "Phone 2: 071-152-1376\n",
      "Email: stacey67@fields.org\n",
      "Subscription Date: 2022-02-20\n",
      "Website: https://sanford-wilcox.biz/\n",
      "\n",
      "Index: 28\n",
      "Customer Id: b92EBfdF8a3f0E6\n",
      "First Name: Frederick\n",
      "Last Name: Harper\n",
      "Company: Hinton, Chaney and Stokes\n",
      "City: South Marissatown\n",
      "Country: Switzerland\n",
      "Phone 1: +1-077-121-1558x0687\n",
      "Phone 2: 264.742.7149\n",
      "Email: jacobkhan@bright.biz\n",
      "Subscription Date: 2022-05-26\n",
      "Website: https://callahan.org/\n",
      "\n",
      "Index: 29\n",
      "Customer Id: 3B5dAAFA41AFa22\n",
      "First Name: Stefanie\n",
      "Last Name: Fitzpatrick\n",
      "Company: Santana-Duran\n",
      "City: Acevedoville\n",
      "Country: Saint Vincent and the Grenadines\n",
      "Phone 1: (752)776-3286\n",
      "Phone 2: +1-472-021-4814x85074\n",
      "Email: wterrell@clark.com\n",
      "Subscription Date: 2020-07-30\n",
      "Website: https://meyers.com/\n",
      "\n",
      "Index: 30\n",
      "Customer Id: EDA69ca7a6e96a2\n",
      "First Name: Kent\n",
      "Last Name: Bradshaw\n",
      "Company: Sawyer PLC\n",
      "City: North Harold\n",
      "Country: Tanzania\n",
      "Phone 1: +1-472-143-5037x884\n",
      "Phone 2: 126.922.6153\n",
      "Email: qjimenez@boyd.com\n",
      "Subscription Date: 2020-04-26\n",
      "Website: http://maynard-ho.com/\n",
      "\n",
      "Index: 31\n",
      "Customer Id: 64DCcDFaB9DFd4e\n",
      "First Name: Jack\n",
      "Last Name: Tate\n",
      "Company: Acosta, Petersen and Morrow\n",
      "City: West Samuel\n",
      "Country: Zimbabwe\n",
      "Phone 1: 965-108-4406x20714\n",
      "Phone 2: 046.906.1442x6784\n",
      "Email: gfigueroa@boone-zavala.com\n",
      "Subscription Date: 2021-09-15\n",
      "Website: http://www.hawkins-ramsey.com/\n",
      "\n",
      "Index: 32\n",
      "Customer Id: 679c6c83DD872d6\n",
      "First Name: Tom\n",
      "Last Name: Trujillo\n",
      "Company: Mcgee Group\n",
      "City: Cunninghamborough\n",
      "Country: Denmark\n",
      "Phone 1: 416-338-3758\n",
      "Phone 2: (775)890-7209\n",
      "Email: tapiagreg@beard.info\n",
      "Subscription Date: 2022-01-13\n",
      "Website: http://www.daniels-klein.com/\n",
      "\n",
      "Index: 33\n",
      "Customer Id: 7Ce381e4Afa4ba9\n",
      "First Name: Gabriel\n",
      "Last Name: Mejia\n",
      "Company: Adkins-Salinas\n",
      "City: Port Annatown\n",
      "Country: Liechtenstein\n",
      "Phone 1: 4077245425\n",
      "Phone 2: 646.044.0696x66800\n",
      "Email: coleolson@jennings.net\n",
      "Subscription Date: 2021-04-24\n",
      "Website: https://patel-hanson.info/\n",
      "\n",
      "Index: 34\n",
      "Customer Id: A09AEc6E3bF70eE\n",
      "First Name: Kaitlyn\n",
      "Last Name: Santana\n",
      "Company: Herrera Group\n",
      "City: New Kaitlyn\n",
      "Country: United States of America\n",
      "Phone 1: 6303643286\n",
      "Phone 2: 447-710-6202x07313\n",
      "Email: georgeross@miles.org\n",
      "Subscription Date: 2021-09-21\n",
      "Website: http://pham.com/\n",
      "\n",
      "Index: 35\n",
      "Customer Id: aA9BAFfBc3710fe\n",
      "First Name: Faith\n",
      "Last Name: Moon\n",
      "Company: Waters, Chase and Aguilar\n",
      "City: West Marthaburgh\n",
      "Country: Bahamas\n",
      "Phone 1: +1-586-217-0359x6317\n",
      "Phone 2: +1-818-199-1403\n",
      "Email: willistonya@randolph-baker.com\n",
      "Subscription Date: 2021-11-03\n",
      "Website: https://spencer-charles.info/\n",
      "\n",
      "Index: 36\n",
      "Customer Id: E11dfb2DB8C9f72\n",
      "First Name: Tammie\n",
      "Last Name: Haley\n",
      "Company: Palmer, Barnes and Houston\n",
      "City: East Teresa\n",
      "Country: Belize\n",
      "Phone 1: 001-276-734-4113x6087\n",
      "Phone 2: (430)300-8770\n",
      "Email: harrisisaiah@jenkins.com\n",
      "Subscription Date: 2022-01-04\n",
      "Website: http://evans-simon.com/\n",
      "\n",
      "Index: 37\n",
      "Customer Id: 889eCf90f68c5Da\n",
      "First Name: Nicholas\n",
      "Last Name: Sosa\n",
      "Company: Jordan Ltd\n",
      "City: South Hunter\n",
      "Country: Uruguay\n",
      "Phone 1: (661)425-6042\n",
      "Phone 2: 975-998-1519\n",
      "Email: fwolfe@dorsey.com\n",
      "Subscription Date: 2021-08-10\n",
      "Website: https://www.fleming-richards.com/\n",
      "\n",
      "Index: 38\n",
      "Customer Id: 7a1Ee69F4fF4B4D\n",
      "First Name: Jordan\n",
      "Last Name: Gay\n",
      "Company: Glover and Sons\n",
      "City: South Walter\n",
      "Country: Solomon Islands\n",
      "Phone 1: 7208417020\n",
      "Phone 2: 8035336772\n",
      "Email: tiffanydavies@harris-mcfarland.org\n",
      "Subscription Date: 2021-02-24\n",
      "Website: http://www.lee.org/\n",
      "\n",
      "Index: 39\n",
      "Customer Id: dca4f1D0A0fc5c9\n",
      "First Name: Bruce\n",
      "Last Name: Esparza\n",
      "Company: Huerta-Mclean\n",
      "City: Poolefurt\n",
      "Country: Montenegro\n",
      "Phone 1: 559-529-4424\n",
      "Phone 2: 001-625-000-7132x0367\n",
      "Email: preese@frye-vega.com\n",
      "Subscription Date: 2021-10-22\n",
      "Website: http://www.farley.org/\n",
      "\n",
      "Index: 40\n",
      "Customer Id: 17aD8e2dB3df03D\n",
      "First Name: Sherry\n",
      "Last Name: Garza\n",
      "Company: Anderson Ltd\n",
      "City: West John\n",
      "Country: Poland\n",
      "Phone 1: 001-067-713-6440x158\n",
      "Phone 2: (978)289-8785x5766\n",
      "Email: ann48@miller.com\n",
      "Subscription Date: 2021-11-01\n",
      "Website: http://spence.com/\n",
      "\n",
      "Index: 41\n",
      "Customer Id: 2f79Cd309624Abb\n",
      "First Name: Natalie\n",
      "Last Name: Gentry\n",
      "Company: Monroe PLC\n",
      "City: West Darius\n",
      "Country: Dominican Republic\n",
      "Phone 1: 830.996.8238\n",
      "Phone 2: 499.122.5415\n",
      "Email: tcummings@fitzpatrick-ashley.com\n",
      "Subscription Date: 2020-10-10\n",
      "Website: http://www.dorsey.biz/\n",
      "\n",
      "Index: 42\n",
      "Customer Id: 6e5ad5a5e2bB5Ca\n",
      "First Name: Bryan\n",
      "Last Name: Dunn\n",
      "Company: Kaufman and Sons\n",
      "City: North Jimstad\n",
      "Country: Burkina Faso\n",
      "Phone 1: 001-710-802-5565\n",
      "Phone 2: 078.699.8982x13881\n",
      "Email: woodwardandres@phelps.com\n",
      "Subscription Date: 2021-09-08\n",
      "Website: http://www.butler.com/\n",
      "\n",
      "Index: 43\n",
      "Customer Id: 7E441b6B228DBcA\n",
      "First Name: Wayne\n",
      "Last Name: Simpson\n",
      "Company: Perkins-Trevino\n",
      "City: East Rebekahborough\n",
      "Country: Bolivia\n",
      "Phone 1: (344)156-8632x1869\n",
      "Phone 2: 463-445-3702x38463\n",
      "Email: barbarapittman@holder.com\n",
      "Subscription Date: 2020-12-13\n",
      "Website: https://gillespie-holder.com/\n",
      "\n",
      "Index: 44\n",
      "Customer Id: D3fC11A9C235Dc6\n",
      "First Name: Luis\n",
      "Last Name: Greer\n",
      "Company: Cross PLC\n",
      "City: North Drew\n",
      "Country: Bulgaria\n",
      "Phone 1: 001-336-025-6849x701\n",
      "Phone 2: 684.698.2911x6092\n",
      "Email: bstuart@williamson-mcclure.com\n",
      "Subscription Date: 2022-05-15\n",
      "Website: https://fletcher-nielsen.com/\n",
      "\n",
      "Index: 45\n",
      "Customer Id: 30Dfa48fe5Ede78\n",
      "First Name: Rhonda\n",
      "Last Name: Frost\n",
      "Company: Herrera, Shepherd and Underwood\n",
      "City: Lake Lindaburgh\n",
      "Country: Monaco\n",
      "Phone 1: (127)081-9339\n",
      "Phone 2: +1-431-028-3337x3492\n",
      "Email: zkrueger@wolf-chavez.net\n",
      "Subscription Date: 2021-12-06\n",
      "Website: http://www.khan.com/\n",
      "\n",
      "Index: 46\n",
      "Customer Id: fD780ED8dbEae7B\n",
      "First Name: Joanne\n",
      "Last Name: Montes\n",
      "Company: Price, Sexton and Mcdaniel\n",
      "City: Gwendolynview\n",
      "Country: Palau\n",
      "Phone 1: (897)726-7952\n",
      "Phone 2: (467)886-9467x5721\n",
      "Email: juan80@henson.net\n",
      "Subscription Date: 2020-07-01\n",
      "Website: http://ochoa.com/\n",
      "\n",
      "Index: 47\n",
      "Customer Id: 300A40d3ce24bBA\n",
      "First Name: Geoffrey\n",
      "Last Name: Guzman\n",
      "Company: Short-Wiggins\n",
      "City: Zimmermanland\n",
      "Country: Uzbekistan\n",
      "Phone 1: 975.235.8921x269\n",
      "Phone 2: (983)188-6873\n",
      "Email: bauercrystal@gay.com\n",
      "Subscription Date: 2020-04-23\n",
      "Website: https://decker-kline.com/\n",
      "\n",
      "Index: 48\n",
      "Customer Id: 283DFCD0Dba40aF\n",
      "First Name: Gloria\n",
      "Last Name: Mccall\n",
      "Company: Brennan, Acosta and Ramos\n",
      "City: North Kerriton\n",
      "Country: Ghana\n",
      "Phone 1: 445-603-6729\n",
      "Phone 2: 001-395-959-4736x4524\n",
      "Email: bartlettjenna@zuniga-moss.biz\n",
      "Subscription Date: 2022-03-11\n",
      "Website: http://burgess-frank.com/\n",
      "\n",
      "Index: 49\n",
      "Customer Id: F4Fc91fEAEad286\n",
      "First Name: Brady\n",
      "Last Name: Cohen\n",
      "Company: Osborne-Erickson\n",
      "City: North Eileenville\n",
      "Country: United Arab Emirates\n",
      "Phone 1: 741.849.0139x524\n",
      "Phone 2: +1-028-691-7497x0894\n",
      "Email: mccalltyrone@durham-rose.biz\n",
      "Subscription Date: 2022-03-10\n",
      "Website: http://hammond-barron.com/\n",
      "\n",
      "Index: 50\n",
      "Customer Id: 80F33Fd2AcebF05\n",
      "First Name: Latoya\n",
      "Last Name: Mccann\n",
      "Company: Hobbs, Garrett and Sanford\n",
      "City: Port Sergiofort\n",
      "Country: Belarus\n",
      "Phone 1: (530)287-4548x29481\n",
      "Phone 2: 162-234-0249x32790\n",
      "Email: bobhammond@barry.biz\n",
      "Subscription Date: 2021-12-02\n",
      "Website: https://www.burton.com/\n",
      "\n",
      "Index: 51\n",
      "Customer Id: Aa20BDe68eAb0e9\n",
      "First Name: Gerald\n",
      "Last Name: Hawkins\n",
      "Company: Phelps, Forbes and Koch\n",
      "City: New Alberttown\n",
      "Country: Canada\n",
      "Phone 1: +1-323-239-1456x96168\n",
      "Phone 2: (092)508-0269\n",
      "Email: uwarner@steele-arias.com\n",
      "Subscription Date: 2021-03-19\n",
      "Website: https://valenzuela.com/\n",
      "\n",
      "Index: 52\n",
      "Customer Id: e898eEB1B9FE22b\n",
      "First Name: Samuel\n",
      "Last Name: Crawford\n",
      "Company: May, Goodwin and Martin\n",
      "City: South Jasmine\n",
      "Country: Algeria\n",
      "Phone 1: 802-242-7457\n",
      "Phone 2: 626.116.9535x8578\n",
      "Email: xpittman@ritter-carney.net\n",
      "Subscription Date: 2021-03-27\n",
      "Website: https://guerrero.org/\n",
      "\n",
      "Index: 53\n",
      "Customer Id: faCEF517ae7D8eB\n",
      "First Name: Patricia\n",
      "Last Name: Goodwin\n",
      "Company: Christian, Winters and Ellis\n",
      "City: Cowanfort\n",
      "Country: Swaziland\n",
      "Phone 1: 322.549.7139x70040\n",
      "Phone 2: (111)741-4173\n",
      "Email: vaughanchristy@lara.biz\n",
      "Subscription Date: 2021-03-08\n",
      "Website: http://clark.info/\n",
      "\n",
      "Index: 54\n",
      "Customer Id: c09952De6Cda8aA\n",
      "First Name: Stacie\n",
      "Last Name: Richard\n",
      "Company: Byrd Inc\n",
      "City: New Deborah\n",
      "Country: Madagascar\n",
      "Phone 1: 001-622-948-3641x24810\n",
      "Phone 2: 001-731-168-2893x8891\n",
      "Email: clinton85@colon-arias.org\n",
      "Subscription Date: 2020-10-15\n",
      "Website: https://kim.com/\n",
      "\n",
      "Index: 55\n",
      "Customer Id: f3BEf3Be028166f\n",
      "First Name: Robin\n",
      "Last Name: West\n",
      "Company: Nixon, Blackwell and Sosa\n",
      "City: Wallstown\n",
      "Country: Ecuador\n",
      "Phone 1: 698.303.4267\n",
      "Phone 2: 001-683-837-7651x525\n",
      "Email: greenemiranda@zimmerman.com\n",
      "Subscription Date: 2022-01-13\n",
      "Website: https://www.mora.com/\n",
      "\n",
      "Index: 56\n",
      "Customer Id: C6F2Fc6a7948a4e\n",
      "First Name: Ralph\n",
      "Last Name: Haas\n",
      "Company: Montes PLC\n",
      "City: Lake Ellenchester\n",
      "Country: Palestinian Territory\n",
      "Phone 1: 2239271999\n",
      "Phone 2: 001-962-434-0867x649\n",
      "Email: goodmancesar@figueroa.biz\n",
      "Subscription Date: 2020-05-25\n",
      "Website: http://may.com/\n",
      "\n",
      "Index: 57\n",
      "Customer Id: c8FE57cBBdCDcb2\n",
      "First Name: Phyllis\n",
      "Last Name: Maldonado\n",
      "Company: Costa PLC\n",
      "City: Lake Whitney\n",
      "Country: Saint Barthelemy\n",
      "Phone 1: 4500370767\n",
      "Phone 2: 001-508-064-6725x017\n",
      "Email: yhanson@warner-diaz.org\n",
      "Subscription Date: 2021-01-25\n",
      "Website: http://www.bernard.com/\n",
      "\n",
      "Index: 58\n",
      "Customer Id: B5acdFC982124F2\n",
      "First Name: Danny\n",
      "Last Name: Parrish\n",
      "Company: Novak LLC\n",
      "City: East Jaredbury\n",
      "Country: United Arab Emirates\n",
      "Phone 1: (669)384-8597x8794\n",
      "Phone 2: 506.731.5952x571\n",
      "Email: howelldarren@house-cohen.com\n",
      "Subscription Date: 2021-03-17\n",
      "Website: http://www.parsons-hudson.com/\n",
      "\n",
      "Index: 59\n",
      "Customer Id: 8c7DdF10798bCC3\n",
      "First Name: Kathy\n",
      "Last Name: Hill\n",
      "Company: Moore, Mccoy and Glass\n",
      "City: Selenabury\n",
      "Country: South Georgia and the South Sandwich Islands\n",
      "Phone 1: 001-171-716-2175x310\n",
      "Phone 2: 888.625.0654\n",
      "Email: ncamacho@boone-simmons.org\n",
      "Subscription Date: 2020-11-15\n",
      "Website: http://hayden.com/\n",
      "\n",
      "Index: 60\n",
      "Customer Id: C681dDd0cc422f7\n",
      "First Name: Kelli\n",
      "Last Name: Hardy\n",
      "Company: Petty Ltd\n",
      "City: Huangfort\n",
      "Country: Sao Tome and Principe\n",
      "Phone 1: 020.324.2191x2022\n",
      "Phone 2: 424-157-8216\n",
      "Email: kristopher62@oliver.com\n",
      "Subscription Date: 2020-12-20\n",
      "Website: http://www.kidd.com/\n",
      "\n",
      "Index: 61\n",
      "Customer Id: a940cE42e035F28\n",
      "First Name: Lynn\n",
      "Last Name: Pham\n",
      "Company: Brennan, Camacho and Tapia\n",
      "City: East Pennyshire\n",
      "Country: Portugal\n",
      "Phone 1: 846.468.6834x611\n",
      "Phone 2: 001-248-691-0006\n",
      "Email: mpham@rios-guzman.com\n",
      "Subscription Date: 2020-08-21\n",
      "Website: https://www.murphy.com/\n",
      "\n",
      "Index: 62\n",
      "Customer Id: 9Cf5E6AFE0aeBfd\n",
      "First Name: Shelley\n",
      "Last Name: Harris\n",
      "Company: Prince, Malone and Pugh\n",
      "City: Port Jasminborough\n",
      "Country: Togo\n",
      "Phone 1: 423.098.0315x8373\n",
      "Phone 2: +1-386-458-8944x15194\n",
      "Email: zachary96@mitchell-bryant.org\n",
      "Subscription Date: 2020-12-10\n",
      "Website: https://www.ryan.com/\n",
      "\n",
      "Index: 63\n",
      "Customer Id: aEcbe5365BbC67D\n",
      "First Name: Eddie\n",
      "Last Name: Jimenez\n",
      "Company: Caldwell Group\n",
      "City: West Kristine\n",
      "Country: Ethiopia\n",
      "Phone 1: +1-235-657-1073x6306\n",
      "Phone 2: (026)401-7353x2417\n",
      "Email: kristiwhitney@bernard.com\n",
      "Subscription Date: 2022-03-24\n",
      "Website: http://cherry.com/\n",
      "\n",
      "Index: 64\n",
      "Customer Id: FCBdfCEAe20A8Dc\n",
      "First Name: Chloe\n",
      "Last Name: Hutchinson\n",
      "Company: Simon LLC\n",
      "City: South Julia\n",
      "Country: Netherlands\n",
      "Phone 1: 981-544-9452\n",
      "Phone 2: +1-288-552-4666x060\n",
      "Email: leah85@sutton-terrell.com\n",
      "Subscription Date: 2022-05-15\n",
      "Website: https://mitchell.info/\n",
      "\n",
      "Index: 65\n",
      "Customer Id: 636cBF0835E10ff\n",
      "First Name: Eileen\n",
      "Last Name: Lynch\n",
      "Company: Knight, Abbott and Hubbard\n",
      "City: Helenborough\n",
      "Country: Liberia\n",
      "Phone 1: +1-158-951-4131x53578\n",
      "Phone 2: 001-673-779-6713x680\n",
      "Email: levigiles@vincent.com\n",
      "Subscription Date: 2021-01-02\n",
      "Website: http://mckay.com/\n",
      "\n",
      "Index: 66\n",
      "Customer Id: fF1b6c9E8Fbf1ff\n",
      "First Name: Fernando\n",
      "Last Name: Lambert\n",
      "Company: Church-Banks\n",
      "City: Lake Nancy\n",
      "Country: Lithuania\n",
      "Phone 1: 497.829.9038\n",
      "Phone 2: 3863743398\n",
      "Email: fisherlinda@schaefer.net\n",
      "Subscription Date: 2021-04-23\n",
      "Website: https://www.vang.com/\n",
      "\n",
      "Index: 67\n",
      "Customer Id: 2A13F74EAa7DA6c\n",
      "First Name: Makayla\n",
      "Last Name: Cannon\n",
      "Company: Henderson Inc\n",
      "City: Georgeport\n",
      "Country: New Caledonia\n",
      "Phone 1: 001-215-801-6392x46009\n",
      "Phone 2: 027-609-6460\n",
      "Email: scottcurtis@hurley.biz\n",
      "Subscription Date: 2020-01-20\n",
      "Website: http://www.velazquez.net/\n",
      "\n",
      "Index: 68\n",
      "Customer Id: a014Ec1b9FccC1E\n",
      "First Name: Tom\n",
      "Last Name: Alvarado\n",
      "Company: Donaldson-Dougherty\n",
      "City: South Sophiaberg\n",
      "Country: Kiribati\n",
      "Phone 1: (585)606-2980x2258\n",
      "Phone 2: 730-797-3594x5614\n",
      "Email: nicholsonnina@montgomery.info\n",
      "Subscription Date: 2020-08-18\n",
      "Website: http://odom-massey.com/\n",
      "\n",
      "Index: 69\n",
      "Customer Id: 421a109cABDf5fa\n",
      "First Name: Virginia\n",
      "Last Name: Dudley\n",
      "Company: Warren Ltd\n",
      "City: Hartbury\n",
      "Country: French Southern Territories\n",
      "Phone 1: 027.846.3705x14184\n",
      "Phone 2: +1-439-171-1846x4636\n",
      "Email: zvalencia@phelps.com\n",
      "Subscription Date: 2021-01-31\n",
      "Website: http://hunter-esparza.com/\n",
      "\n",
      "Index: 70\n",
      "Customer Id: CC68FD1D3Bbbf22\n",
      "First Name: Riley\n",
      "Last Name: Good\n",
      "Company: Wade PLC\n",
      "City: Erikaville\n",
      "Country: Canada\n",
      "Phone 1: 6977745822\n",
      "Phone 2: 855-436-7641\n",
      "Email: alex06@galloway.com\n",
      "Subscription Date: 2020-02-03\n",
      "Website: http://conway.org/\n",
      "\n",
      "Index: 71\n",
      "Customer Id: CBCd2Ac8E3eBDF9\n",
      "First Name: Alexandria\n",
      "Last Name: Buck\n",
      "Company: Keller-Coffey\n",
      "City: Nicolasfort\n",
      "Country: Iran\n",
      "Phone 1: 078-900-4760x76668\n",
      "Phone 2: 414-112-8700x68751\n",
      "Email: lee48@manning.com\n",
      "Subscription Date: 2021-02-20\n",
      "Website: https://ramsey.org/\n",
      "\n",
      "Index: 72\n",
      "Customer Id: Ef859092FbEcC07\n",
      "First Name: Richard\n",
      "Last Name: Roth\n",
      "Company: Conway-Mcbride\n",
      "City: New Jasmineshire\n",
      "Country: Morocco\n",
      "Phone 1: 581-440-6539\n",
      "Phone 2: 9857827463\n",
      "Email: aharper@maddox-townsend.org\n",
      "Subscription Date: 2020-02-23\n",
      "Website: https://www.brooks.com/\n",
      "\n",
      "Index: 73\n",
      "Customer Id: F560f2d3cDFb618\n",
      "First Name: Candice\n",
      "Last Name: Keller\n",
      "Company: Huynh and Sons\n",
      "City: East Summerstad\n",
      "Country: Zimbabwe\n",
      "Phone 1: 001-927-965-8550x92406\n",
      "Phone 2: 001-243-038-4271x53076\n",
      "Email: buckleycory@odonnell.net\n",
      "Subscription Date: 2020-08-22\n",
      "Website: https://www.lucero.com/\n",
      "\n",
      "Index: 74\n",
      "Customer Id: A3F76Be153Df4a3\n",
      "First Name: Anita\n",
      "Last Name: Benson\n",
      "Company: Parrish Ltd\n",
      "City: Skinnerport\n",
      "Country: Russian Federation\n",
      "Phone 1: 874.617.5668x69878\n",
      "Phone 2: (399)820-6418x0071\n",
      "Email: angie04@oconnell.com\n",
      "Subscription Date: 2020-02-09\n",
      "Website: http://oconnor.com/\n",
      "\n",
      "Index: 75\n",
      "Customer Id: D01Af0AF7cBbFeA\n",
      "First Name: Regina\n",
      "Last Name: Stein\n",
      "Company: Guzman-Brown\n",
      "City: Raystad\n",
      "Country: Solomon Islands\n",
      "Phone 1: 001-469-848-0724x4407\n",
      "Phone 2: 001-085-360-4426x00357\n",
      "Email: zrosario@rojas-hardin.net\n",
      "Subscription Date: 2022-01-15\n",
      "Website: http://www.johnston.info/\n",
      "\n",
      "Index: 76\n",
      "Customer Id: d40e89dCade7b2F\n",
      "First Name: Debra\n",
      "Last Name: Riddle\n",
      "Company: Chang, Aguirre and Leblanc\n",
      "City: Colinhaven\n",
      "Country: United States Virgin Islands\n",
      "Phone 1: +1-768-182-6014x14336\n",
      "Phone 2: (303)961-4491\n",
      "Email: shieldskerry@robles.com\n",
      "Subscription Date: 2020-07-11\n",
      "Website: http://kaiser.info/\n",
      "\n",
      "Index: 77\n",
      "Customer Id: BF6a1f9bd1bf8DE\n",
      "First Name: Brittany\n",
      "Last Name: Zuniga\n",
      "Company: Mason-Hester\n",
      "City: West Reginald\n",
      "Country: Kyrgyz Republic\n",
      "Phone 1: (050)136-9025\n",
      "Phone 2: 001-480-851-2496x0157\n",
      "Email: mchandler@cochran-huerta.org\n",
      "Subscription Date: 2021-07-24\n",
      "Website: http://www.boyle.com/\n",
      "\n",
      "Index: 78\n",
      "Customer Id: FfaeFFbbbf280db\n",
      "First Name: Cassidy\n",
      "Last Name: Mcmahon\n",
      "Company: Mcguire, Huynh and Hopkins\n",
      "City: Lake Sherryborough\n",
      "Country: Myanmar\n",
      "Phone 1: 5040771311\n",
      "Phone 2: 684-682-0021x1326\n",
      "Email: katrinalane@fitzgerald.com\n",
      "Subscription Date: 2020-10-21\n",
      "Website: https://hurst.com/\n",
      "\n",
      "Index: 79\n",
      "Customer Id: CbAE1d1e9a8dCb1\n",
      "First Name: Laurie\n",
      "Last Name: Pennington\n",
      "Company: Sanchez, Marsh and Hale\n",
      "City: Port Katherineville\n",
      "Country: Dominica\n",
      "Phone 1: 007.155.3406x553\n",
      "Phone 2: +1-809-862-5566x277\n",
      "Email: cookejill@powell.com\n",
      "Subscription Date: 2020-06-08\n",
      "Website: http://www.hebert.com/\n",
      "\n",
      "Index: 80\n",
      "Customer Id: A7F85c1DE4dB87f\n",
      "First Name: Alejandro\n",
      "Last Name: Blair\n",
      "Company: Combs, Waller and Durham\n",
      "City: Thomasland\n",
      "Country: Iceland\n",
      "Phone 1: (690)068-4641x51468\n",
      "Phone 2: 555.509.8691x2329\n",
      "Email: elizabethbarr@ewing.com\n",
      "Subscription Date: 2020-09-19\n",
      "Website: https://mercado-blevins.com/\n",
      "\n",
      "Index: 81\n",
      "Customer Id: D6CEAfb3BDbaa1A\n",
      "First Name: Leslie\n",
      "Last Name: Jennings\n",
      "Company: Blankenship-Arias\n",
      "City: Coreybury\n",
      "Country: Micronesia\n",
      "Phone 1: 629.198.6346\n",
      "Phone 2: 075.256.0829\n",
      "Email: corey75@wiggins.com\n",
      "Subscription Date: 2021-11-13\n",
      "Website: https://www.juarez.com/\n",
      "\n",
      "Index: 82\n",
      "Customer Id: Ebdb6F6F7c90b69\n",
      "First Name: Kathleen\n",
      "Last Name: Mckay\n",
      "Company: Coffey, Lamb and Johnson\n",
      "City: Lake Janiceton\n",
      "Country: Saint Vincent and the Grenadines\n",
      "Phone 1: (733)910-9968\n",
      "Phone 2: (691)247-4128x0665\n",
      "Email: chloelester@higgins-wilkinson.com\n",
      "Subscription Date: 2021-09-12\n",
      "Website: http://www.owens-mooney.com/\n",
      "\n",
      "Index: 83\n",
      "Customer Id: E8E7e8Cfe516ef0\n",
      "First Name: Hunter\n",
      "Last Name: Moreno\n",
      "Company: Fitzpatrick-Lawrence\n",
      "City: East Clinton\n",
      "Country: Isle of Man\n",
      "Phone 1: (733)833-6754\n",
      "Phone 2: 001-761-013-7121\n",
      "Email: isaac26@benton-finley.com\n",
      "Subscription Date: 2020-12-28\n",
      "Website: http://walls.info/\n",
      "\n",
      "Index: 84\n",
      "Customer Id: 78C06E9b6B3DF20\n",
      "First Name: Chad\n",
      "Last Name: Davidson\n",
      "Company: Garcia-Jimenez\n",
      "City: South Joshuashire\n",
      "Country: Oman\n",
      "Phone 1: 8275702958\n",
      "Phone 2: (804)842-4715\n",
      "Email: justinwalters@jimenez.com\n",
      "Subscription Date: 2021-11-15\n",
      "Website: http://www.garner-oliver.com/\n",
      "\n",
      "Index: 85\n",
      "Customer Id: 03A1E62ADdeb31c\n",
      "First Name: Corey\n",
      "Last Name: Holt\n",
      "Company: Mcdonald, Bird and Ramirez\n",
      "City: New Glenda\n",
      "Country: Fiji\n",
      "Phone 1: 001-439-242-4986x7918\n",
      "Phone 2: 3162708934\n",
      "Email: maurice46@morgan.com\n",
      "Subscription Date: 2020-02-18\n",
      "Website: http://www.watson.com/\n",
      "\n",
      "Index: 86\n",
      "Customer Id: C6763c99d0bd16D\n",
      "First Name: Emma\n",
      "Last Name: Cunningham\n",
      "Company: Stephens Inc\n",
      "City: North Jillianview\n",
      "Country: New Zealand\n",
      "Phone 1: 128-059-0206x60217\n",
      "Phone 2: (312)164-4545x2284\n",
      "Email: walter83@juarez.org\n",
      "Subscription Date: 2022-05-13\n",
      "Website: http://www.reid.info/\n",
      "\n",
      "Index: 87\n",
      "Customer Id: ebe77E5Bf9476CE\n",
      "First Name: Duane\n",
      "Last Name: Woods\n",
      "Company: Montoya-Miller\n",
      "City: Lyonsberg\n",
      "Country: Maldives\n",
      "Phone 1: (636)544-7783x7288\n",
      "Phone 2: (203)287-1003x5932\n",
      "Email: kmercer@wagner.com\n",
      "Subscription Date: 2020-07-21\n",
      "Website: http://murray.org/\n",
      "\n",
      "Index: 88\n",
      "Customer Id: E4Bbcd8AD81fC5f\n",
      "First Name: Alison\n",
      "Last Name: Vargas\n",
      "Company: Vaughn, Watts and Leach\n",
      "City: East Cristinabury\n",
      "Country: Benin\n",
      "Phone 1: 365-273-8144\n",
      "Phone 2: 053-308-7653x6287\n",
      "Email: vcantu@norton.com\n",
      "Subscription Date: 2020-11-10\n",
      "Website: http://mason.info/\n",
      "\n",
      "Index: 89\n",
      "Customer Id: efeb73245CDf1fF\n",
      "First Name: Vernon\n",
      "Last Name: Kane\n",
      "Company: Carter-Strickland\n",
      "City: Thomasfurt\n",
      "Country: Yemen\n",
      "Phone 1: 114-854-1159x555\n",
      "Phone 2: 499-608-4612\n",
      "Email: hilljesse@barrett.info\n",
      "Subscription Date: 2021-04-15\n",
      "Website: http://www.duffy-hensley.net/\n",
      "\n",
      "Index: 90\n",
      "Customer Id: 37Ec4B395641c1E\n",
      "First Name: Lori\n",
      "Last Name: Flowers\n",
      "Company: Decker-Mcknight\n",
      "City: North Joeburgh\n",
      "Country: Namibia\n",
      "Phone 1: 679.415.1210\n",
      "Phone 2: 945-842-3659x4581\n",
      "Email: tyrone77@valenzuela.info\n",
      "Subscription Date: 2021-01-09\n",
      "Website: http://www.deleon-crosby.com/\n",
      "\n",
      "Index: 91\n",
      "Customer Id: 5ef6d3eefdD43bE\n",
      "First Name: Nina\n",
      "Last Name: Chavez\n",
      "Company: Byrd-Campbell\n",
      "City: Cassidychester\n",
      "Country: Bhutan\n",
      "Phone 1: 053-344-3205\n",
      "Phone 2: +1-330-920-5422x571\n",
      "Email: elliserica@frank.com\n",
      "Subscription Date: 2020-03-26\n",
      "Website: https://www.pugh.com/\n",
      "\n",
      "Index: 92\n",
      "Customer Id: 98b3aeDcC3B9FF3\n",
      "First Name: Shane\n",
      "Last Name: Foley\n",
      "Company: Rocha-Hart\n",
      "City: South Dannymouth\n",
      "Country: Hungary\n",
      "Phone 1: +1-822-569-0302\n",
      "Phone 2: 001-626-114-5844x55073\n",
      "Email: nsteele@sparks.com\n",
      "Subscription Date: 2021-07-06\n",
      "Website: https://www.holt-sparks.com/\n",
      "\n",
      "Index: 93\n",
      "Customer Id: aAb6AFc7AfD0fF3\n",
      "First Name: Collin\n",
      "Last Name: Ayers\n",
      "Company: Lamb-Peterson\n",
      "City: South Lonnie\n",
      "Country: Anguilla\n",
      "Phone 1: 404-645-5351x012\n",
      "Phone 2: 001-257-582-8850x8516\n",
      "Email: dudleyemily@gonzales.biz\n",
      "Subscription Date: 2021-06-29\n",
      "Website: http://www.ruiz.com/\n",
      "\n",
      "Index: 94\n",
      "Customer Id: 54B5B5Fe9F1B6C5\n",
      "First Name: Sherry\n",
      "Last Name: Young\n",
      "Company: Lee, Lucero and Johnson\n",
      "City: Frankchester\n",
      "Country: Solomon Islands\n",
      "Phone 1: 158-687-1764\n",
      "Phone 2: (438)375-6207x003\n",
      "Email: alan79@gates-mclaughlin.com\n",
      "Subscription Date: 2021-04-04\n",
      "Website: https://travis.net/\n",
      "\n",
      "Index: 95\n",
      "Customer Id: BE91A0bdcA49Bbc\n",
      "First Name: Darrell\n",
      "Last Name: Douglas\n",
      "Company: Newton, Petersen and Mathis\n",
      "City: Daisyborough\n",
      "Country: Mali\n",
      "Phone 1: 001-084-845-9524x1777\n",
      "Phone 2: 001-769-564-6303\n",
      "Email: grayjean@lowery-good.com\n",
      "Subscription Date: 2022-02-17\n",
      "Website: https://banks.biz/\n",
      "\n",
      "Index: 96\n",
      "Customer Id: cb8E23e48d22Eae\n",
      "First Name: Karl\n",
      "Last Name: Greer\n",
      "Company: Carey LLC\n",
      "City: East Richard\n",
      "Country: Guyana\n",
      "Phone 1: (188)169-1674x58692\n",
      "Phone 2: 001-841-293-3519x614\n",
      "Email: hhart@jensen.com\n",
      "Subscription Date: 2022-01-30\n",
      "Website: http://hayes-perez.com/\n",
      "\n",
      "Index: 97\n",
      "Customer Id: CeD220bdAaCfaDf\n",
      "First Name: Lynn\n",
      "Last Name: Atkinson\n",
      "Company: Ware, Burns and Oneal\n",
      "City: New Bradview\n",
      "Country: Sri Lanka\n",
      "Phone 1: +1-846-706-2218\n",
      "Phone 2: 605.413.3198\n",
      "Email: vkemp@ferrell.com\n",
      "Subscription Date: 2021-07-10\n",
      "Website: https://novak-allison.com/\n",
      "\n",
      "Index: 98\n",
      "Customer Id: 28CDbC0dFe4b1Db\n",
      "First Name: Fred\n",
      "Last Name: Guerra\n",
      "Company: Schmitt-Jones\n",
      "City: Ortegaland\n",
      "Country: Solomon Islands\n",
      "Phone 1: +1-753-067-8419x7170\n",
      "Phone 2: +1-632-666-7507x92121\n",
      "Email: swagner@kane.org\n",
      "Subscription Date: 2021-09-18\n",
      "Website: https://www.ross.com/\n",
      "\n",
      "Index: 99\n",
      "Customer Id: c23d1D9EE8DEB0A\n",
      "First Name: Yvonne\n",
      "Last Name: Farmer\n",
      "Company: Fitzgerald-Harrell\n",
      "City: Lake Elijahview\n",
      "Country: Aruba\n",
      "Phone 1: (530)311-9786\n",
      "Phone 2: 001-869-452-0943x12424\n",
      "Email: mccarthystephen@horn-green.biz\n",
      "Subscription Date: 2021-08-11\n",
      "Website: http://watkins.info/\n",
      "\n",
      "Index: 100\n",
      "Customer Id: 2354a0E336A91A1\n",
      "First Name: Clarence\n",
      "Last Name: Haynes\n",
      "Company: Le, Nash and Cross\n",
      "City: Judymouth\n",
      "Country: Honduras\n",
      "Phone 1: (753)813-6941\n",
      "Phone 2: 783.639.1472\n",
      "Email: colleen91@faulkner.biz\n",
      "Subscription Date: 2020-03-11\n",
      "Website: http://www.hatfield-saunders.net/\n",
      "\n"
     ]
    }
   ],
   "source": [
    "from langchain.document_loaders.csv_loader import CSVLoader\n",
    "\n",
    "\n",
    "loader_csv = CSVLoader(file_path=file_path, encoding=\"utf-8\", csv_args={'delimiter': ','})\n",
    "docs_csv = loader_csv.load()\n",
    "for doc in docs_csv:\n",
    "    print(f'{doc.page_content}\\n')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 1.1.1. <a id='toc1_1_1_'></a>[Customize csv parsing and loading](#toc0_)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Extract field name\n",
    "\n",
    "CSVLoader uses the first line as the field name if fieldname is not specified"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Index',\n",
       " 'Customer Id',\n",
       " 'First Name',\n",
       " 'Last Name',\n",
       " 'Company',\n",
       " 'City',\n",
       " 'Country',\n",
       " 'Phone 1',\n",
       " 'Phone 2',\n",
       " 'Email',\n",
       " 'Subscription Date',\n",
       " 'Website']"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(file_path)\n",
    "fieldnames = df.columns.to_list()\n",
    "fieldnames"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 1.1.2. <a id='toc1_1_2_'></a>[CSV loder with custom field names](#toc0_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index: Index\n",
      "Customer Id: Customer Id\n",
      "First Name: First Name\n",
      "Last Name: Last Name\n",
      "Company: Company\n",
      "City: City\n",
      "Country: Country\n",
      "Phone 1: Phone 1\n",
      "Phone 2: Phone 2\n",
      "Email: Email\n",
      "\n",
      "Email: Email\n",
      "Subscription Date: Subscription Date\n",
      "Website: Website\n",
      "\n",
      "Index: 1\n",
      "Customer Id: DD37Cf93aecA6Dc\n",
      "First Name: Sheryl\n",
      "Last Name: Baxter\n",
      "Company: Rasmussen Group\n",
      "City: East Leonard\n",
      "Country: Chile\n",
      "Phone 1: 229.077.5154\n",
      "Phone 2: 397.884.0519x718\n",
      "\n",
      "Email: zunigavanessa@smith.info\n",
      "Subscription Date: 2020-08-24\n",
      "Website: http://www.stephenson.com/\n",
      "\n",
      "Index: 2\n",
      "Customer Id: 1Ef7b82A4CAAD10\n",
      "First Name: Preston\n",
      "Last Name: Lozano\n",
      "Company: Vega-Gentry\n",
      "City: East Jimmychester\n",
      "Country: Djibouti\n",
      "Phone 1: 5153435776\n",
      "Phone 2: 686-620-1820x944\n",
      "\n",
      "Email: vmata@colon.com\n",
      "Subscription Date: 2021-04-23\n",
      "Website: http://www.hobbs.com/\n",
      "\n",
      "Index: 3\n",
      "Customer Id: 6F94879bDAfE5a6\n",
      "First Name: Roy\n",
      "Last Name: Berry\n",
      "Company: Murillo-Perry\n",
      "City: Isabelborough\n",
      "Country: Antigua and Barbuda\n",
      "Phone 1: +1-539-402-0259\n",
      "Phone 2: (496)978-3969x58947\n",
      "\n",
      "Email: beckycarr@hogan.com\n",
      "Subscription Date: 2020-03-25\n",
      "Website: http://www.lawrence.com/\n",
      "\n",
      "Index: 4\n",
      "Customer Id: 5Cef8BFA16c5e3c\n",
      "First Name: Linda\n",
      "Last Name: Olsen\n",
      "Company: Dominguez, Mcmillan and Donovan\n",
      "City: Bensonview\n",
      "Country: Dominican Republic\n",
      "Phone 1: 001-808-617-6467x12895\n",
      "\n",
      "Phone 2: +1-813-324-8756\n",
      "Email: stanleyblackwell@benson.org\n",
      "Subscription Date: 2020-06-02\n",
      "Website: http://www.good-lyons.com/\n",
      "\n",
      "Index: 5\n",
      "Customer Id: 053d585Ab6b3159\n",
      "First Name: Joanna\n",
      "Last Name: Bender\n",
      "Company: Martin, Lang and Andrade\n",
      "City: West Priscilla\n",
      "Country: Slovakia (Slovak Republic)\n",
      "Phone 1: 001-234-203-0635x76146\n",
      "\n",
      "Phone 2: 001-199-446-3860x3486\n",
      "Email: colinalvarado@miles.net\n",
      "Subscription Date: 2021-04-17\n",
      "Website: https://goodwin-ingram.com/\n",
      "\n",
      "Index: 6\n",
      "Customer Id: 2d08FB17EE273F4\n",
      "First Name: Aimee\n",
      "Last Name: Downs\n",
      "Company: Steele Group\n",
      "City: Chavezborough\n",
      "Country: Bosnia and Herzegovina\n",
      "Phone 1: (283)437-3886x88321\n",
      "Phone 2: 999-728-1637\n",
      "\n",
      "Email: louis27@gilbert.com\n",
      "Subscription Date: 2020-02-25\n",
      "Website: http://www.berger.net/\n",
      "\n",
      "Index: 7\n",
      "Customer Id: EA4d384DfDbBf77\n",
      "First Name: Darren\n",
      "Last Name: Peck\n",
      "Company: Lester, Woodard and Mitchell\n",
      "City: Lake Ana\n",
      "Country: Pitcairn Islands\n",
      "Phone 1: (496)452-6181x3291\n",
      "\n",
      "Phone 2: +1-247-266-0963x4995\n",
      "Email: tgates@cantrell.com\n",
      "Subscription Date: 2021-08-24\n",
      "Website: https://www.le.com/\n",
      "\n",
      "Index: 8\n",
      "Customer Id: 0e04AFde9f225dE\n",
      "First Name: Brett\n",
      "Last Name: Mullen\n",
      "Company: Sanford, Davenport and Giles\n",
      "City: Kimport\n",
      "Country: Bulgaria\n",
      "Phone 1: 001-583-352-7197x297\n",
      "Phone 2: 001-333-145-0369\n",
      "\n",
      "Email: asnow@colon.com\n",
      "Subscription Date: 2021-04-12\n",
      "Website: https://hammond-ramsey.com/\n",
      "\n",
      "Index: 9\n",
      "Customer Id: C2dE4dEEc489ae0\n",
      "First Name: Sheryl\n",
      "Last Name: Meyers\n",
      "Company: Browning-Simon\n",
      "City: Robersonstad\n",
      "Country: Cyprus\n",
      "Phone 1: 854-138-4911x5772\n",
      "Phone 2: +1-448-910-2276x729\n",
      "\n",
      "Email: mariokhan@ryan-pope.org\n",
      "Subscription Date: 2020-01-13\n",
      "Website: https://www.bullock.net/\n",
      "\n",
      "Index: 10\n",
      "Customer Id: 8C2811a503C7c5a\n",
      "First Name: Michelle\n",
      "Last Name: Gallagher\n",
      "Company: Beck-Hendrix\n",
      "City: Elaineberg\n",
      "Country: Timor-Leste\n",
      "Phone 1: 739.218.2516x459\n",
      "Phone 2: 001-054-401-0347x617\n",
      "\n",
      "Email: mdyer@escobar.net\n",
      "Subscription Date: 2021-11-08\n",
      "Website: https://arias.com/\n",
      "\n",
      "Index: 11\n",
      "Customer Id: 216E205d6eBb815\n",
      "First Name: Carl\n",
      "Last Name: Schroeder\n",
      "Company: Oconnell, Meza and Everett\n",
      "City: Shannonville\n",
      "Country: Guernsey\n",
      "Phone 1: 637-854-0256x825\n",
      "\n",
      "Phone 2: 114.336.0784x788\n",
      "Email: kirksalas@webb.com\n",
      "Subscription Date: 2021-10-20\n",
      "Website: https://simmons-hurley.com/\n",
      "\n",
      "Index: 12\n",
      "Customer Id: CEDec94deE6d69B\n",
      "First Name: Jenna\n",
      "Last Name: Dodson\n",
      "Company: Hoffman, Reed and Mcclain\n",
      "City: East Andrea\n",
      "Country: Vietnam\n",
      "Phone 1: (041)737-3846\n",
      "Phone 2: +1-556-888-3485x42608\n",
      "\n",
      "Email: mark42@robbins.com\n",
      "Subscription Date: 2020-11-29\n",
      "Website: http://www.douglas.net/\n",
      "\n",
      "Index: 13\n",
      "Customer Id: e35426EbDEceaFF\n",
      "First Name: Tracey\n",
      "Last Name: Mata\n",
      "Company: Graham-Francis\n",
      "City: South Joannamouth\n",
      "Country: Togo\n",
      "Phone 1: 001-949-844-8787\n",
      "Phone 2: (855)713-8773\n",
      "\n",
      "Email: alex56@walls.org\n",
      "Subscription Date: 2021-12-02\n",
      "Website: http://www.beck.com/\n",
      "\n",
      "Index: 14\n",
      "Customer Id: A08A8aF8BE9FaD4\n",
      "First Name: Kristine\n",
      "Last Name: Cox\n",
      "Company: Carpenter-Cook\n",
      "City: Jodyberg\n",
      "Country: Sri Lanka\n",
      "Phone 1: 786-284-3358x62152\n",
      "Phone 2: +1-315-627-1796x8074\n",
      "\n",
      "Email: holdenmiranda@clarke.com\n",
      "Subscription Date: 2021-02-08\n",
      "Website: https://www.brandt.com/\n",
      "\n",
      "Index: 15\n",
      "Customer Id: 6fEaA1b7cab7B6C\n",
      "First Name: Faith\n",
      "Last Name: Lutz\n",
      "Company: Carter-Hancock\n",
      "City: Burchbury\n",
      "Country: Singapore\n",
      "Phone 1: (781)861-7180x8306\n",
      "Phone 2: 207-185-3665\n",
      "\n",
      "Email: cassieparrish@blevins-chapman.net\n",
      "Subscription Date: 2022-01-26\n",
      "Website: http://stevenson.org/\n",
      "\n",
      "Index: 16\n",
      "Customer Id: 8cad0b4CBceaeec\n",
      "First Name: Miranda\n",
      "Last Name: Beasley\n",
      "Company: Singleton and Sons\n",
      "City: Desireeshire\n",
      "Country: Oman\n",
      "Phone 1: 540.085.3135x185\n",
      "Phone 2: +1-600-462-6432x21881\n",
      "\n",
      "Email: vduncan@parks-hardy.com\n",
      "Subscription Date: 2022-04-12\n",
      "Website: http://acosta.org/\n",
      "\n",
      "Index: 17\n",
      "Customer Id: a5DC21AE3a21eaA\n",
      "First Name: Caroline\n",
      "Last Name: Foley\n",
      "Company: Winters-Mendoza\n",
      "City: West Adriennestad\n",
      "Country: Western Sahara\n",
      "Phone 1: 936.222.4746x9924\n",
      "\n",
      "Phone 2: 001-469-948-6341x359\n",
      "Email: holtgwendolyn@watson-davenport.com\n",
      "Subscription Date: 2021-03-10\n",
      "Website: http://www.benson-roth.com/\n",
      "\n",
      "Index: 18\n",
      "Customer Id: F8Aa9d6DfcBeeF8\n",
      "First Name: Greg\n",
      "Last Name: Mata\n",
      "Company: Valentine LLC\n",
      "City: Lake Leslie\n",
      "Country: Mozambique\n",
      "Phone 1: (701)087-2415\n",
      "Phone 2: (195)156-1861x26241\n",
      "\n",
      "Email: jaredjuarez@carroll.org\n",
      "Subscription Date: 2022-03-26\n",
      "Website: http://pitts-cherry.com/\n",
      "\n",
      "Index: 19\n",
      "Customer Id: F160f5Db3EfE973\n",
      "First Name: Clifford\n",
      "Last Name: Jacobson\n",
      "Company: Simon LLC\n",
      "City: Harmonview\n",
      "Country: South Georgia and the South Sandwich Islands\n",
      "Phone 1: 001-151-330-3524x0469\n",
      "\n",
      "Phone 2: (748)477-7174\n",
      "Email: joseph26@jacobson.com\n",
      "Subscription Date: 2020-09-24\n",
      "Website: https://mcconnell.com/\n",
      "\n",
      "Index: 20\n",
      "Customer Id: 0F60FF3DdCd7aB0\n",
      "First Name: Joanna\n",
      "Last Name: Kirk\n",
      "Company: Mays-Mccormick\n",
      "City: Jamesshire\n",
      "Country: French Polynesia\n",
      "Phone 1: (266)131-7001x711\n",
      "Phone 2: (283)312-5579x11543\n",
      "\n",
      "Email: tuckerangie@salazar.net\n",
      "Subscription Date: 2021-09-24\n",
      "Website: https://www.camacho.net/\n",
      "\n",
      "Index: 21\n",
      "Customer Id: 9F9AdB7B8A6f7F2\n",
      "First Name: Maxwell\n",
      "Last Name: Frye\n",
      "Company: Patterson Inc\n",
      "City: East Carly\n",
      "Country: Malta\n",
      "Phone 1: 423.262.3059\n",
      "Phone 2: 202-880-0688x7491\n",
      "\n",
      "Email: fgibson@drake-webb.com\n",
      "Subscription Date: 2022-01-12\n",
      "Website: http://www.roberts.com/\n",
      "\n",
      "Index: 22\n",
      "Customer Id: FBd0Ded4F02a742\n",
      "First Name: Kiara\n",
      "Last Name: Houston\n",
      "Company: Manning, Hester and Arroyo\n",
      "City: South Alvin\n",
      "Country: Netherlands\n",
      "Phone 1: 001-274-040-3582x10611\n",
      "\n",
      "Phone 2: +1-528-175-0973x4684\n",
      "Email: blanchardbob@wallace-shannon.com\n",
      "Subscription Date: 2020-09-15\n",
      "Website: https://www.reid-potts.com/\n",
      "\n",
      "Index: 23\n",
      "Customer Id: 2FB0FAA1d429421\n",
      "First Name: Colleen\n",
      "Last Name: Howard\n",
      "Company: Greer and Sons\n",
      "City: Brittanyview\n",
      "Country: Paraguay\n",
      "Phone 1: 1935085151\n",
      "Phone 2: (947)115-7711x5488\n",
      "\n",
      "Email: rsingleton@ryan-cherry.com\n",
      "Subscription Date: 2020-08-19\n",
      "Website: http://paul.biz/\n",
      "\n",
      "Index: 24\n",
      "Customer Id: 010468dAA11382c\n",
      "First Name: Janet\n",
      "Last Name: Valenzuela\n",
      "Company: Watts-Donaldson\n",
      "City: Veronicamouth\n",
      "Country: Lao People's Democratic Republic\n",
      "Phone 1: 354.259.5062x7538\n",
      "\n",
      "Phone 2: 500.433.2022\n",
      "Email: stefanie71@spence.com\n",
      "Subscription Date: 2020-09-08\n",
      "Website: https://moreno.biz/\n",
      "\n",
      "Index: 25\n",
      "Customer Id: eC1927Ca84E033e\n",
      "First Name: Shane\n",
      "Last Name: Wilcox\n",
      "Company: Tucker LLC\n",
      "City: Bryanville\n",
      "Country: Albania\n",
      "Phone 1: (429)005-9030x11004\n",
      "Phone 2: 541-116-4501\n",
      "\n",
      "Email: mariah88@santos.com\n",
      "Subscription Date: 2021-04-06\n",
      "Website: https://www.ramos.com/\n",
      "\n",
      "Index: 26\n",
      "Customer Id: 09D7D7C8Fe09aea\n",
      "First Name: Marcus\n",
      "Last Name: Moody\n",
      "Company: Giles Ltd\n",
      "City: Kaitlyntown\n",
      "Country: Panama\n",
      "Phone 1: 674-677-8623\n",
      "Phone 2: 909-277-5485x566\n",
      "\n",
      "Email: donnamullins@norris-barrett.org\n",
      "Subscription Date: 2022-05-24\n",
      "Website: https://www.curry.com/\n",
      "\n",
      "Index: 27\n",
      "Customer Id: aBdfcF2c50b0bfD\n",
      "First Name: Dakota\n",
      "Last Name: Poole\n",
      "Company: Simmons Group\n",
      "City: Michealshire\n",
      "Country: Belarus\n",
      "Phone 1: (371)987-8576x4720\n",
      "Phone 2: 071-152-1376\n",
      "\n",
      "Email: stacey67@fields.org\n",
      "Subscription Date: 2022-02-20\n",
      "Website: https://sanford-wilcox.biz/\n",
      "\n",
      "Index: 28\n",
      "Customer Id: b92EBfdF8a3f0E6\n",
      "First Name: Frederick\n",
      "Last Name: Harper\n",
      "Company: Hinton, Chaney and Stokes\n",
      "City: South Marissatown\n",
      "Country: Switzerland\n",
      "Phone 1: +1-077-121-1558x0687\n",
      "\n",
      "Phone 2: 264.742.7149\n",
      "Email: jacobkhan@bright.biz\n",
      "Subscription Date: 2022-05-26\n",
      "Website: https://callahan.org/\n",
      "\n",
      "Index: 29\n",
      "Customer Id: 3B5dAAFA41AFa22\n",
      "First Name: Stefanie\n",
      "Last Name: Fitzpatrick\n",
      "Company: Santana-Duran\n",
      "City: Acevedoville\n",
      "Country: Saint Vincent and the Grenadines\n",
      "Phone 1: (752)776-3286\n",
      "\n",
      "Phone 2: +1-472-021-4814x85074\n",
      "Email: wterrell@clark.com\n",
      "Subscription Date: 2020-07-30\n",
      "Website: https://meyers.com/\n",
      "\n",
      "Index: 30\n",
      "Customer Id: EDA69ca7a6e96a2\n",
      "First Name: Kent\n",
      "Last Name: Bradshaw\n",
      "Company: Sawyer PLC\n",
      "City: North Harold\n",
      "Country: Tanzania\n",
      "Phone 1: +1-472-143-5037x884\n",
      "Phone 2: 126.922.6153\n",
      "\n",
      "Email: qjimenez@boyd.com\n",
      "Subscription Date: 2020-04-26\n",
      "Website: http://maynard-ho.com/\n",
      "\n",
      "Index: 31\n",
      "Customer Id: 64DCcDFaB9DFd4e\n",
      "First Name: Jack\n",
      "Last Name: Tate\n",
      "Company: Acosta, Petersen and Morrow\n",
      "City: West Samuel\n",
      "Country: Zimbabwe\n",
      "Phone 1: 965-108-4406x20714\n",
      "Phone 2: 046.906.1442x6784\n",
      "\n",
      "Email: gfigueroa@boone-zavala.com\n",
      "Subscription Date: 2021-09-15\n",
      "Website: http://www.hawkins-ramsey.com/\n",
      "\n",
      "Index: 32\n",
      "Customer Id: 679c6c83DD872d6\n",
      "First Name: Tom\n",
      "Last Name: Trujillo\n",
      "Company: Mcgee Group\n",
      "City: Cunninghamborough\n",
      "Country: Denmark\n",
      "Phone 1: 416-338-3758\n",
      "Phone 2: (775)890-7209\n",
      "\n",
      "Email: tapiagreg@beard.info\n",
      "Subscription Date: 2022-01-13\n",
      "Website: http://www.daniels-klein.com/\n",
      "\n",
      "Index: 33\n",
      "Customer Id: 7Ce381e4Afa4ba9\n",
      "First Name: Gabriel\n",
      "Last Name: Mejia\n",
      "Company: Adkins-Salinas\n",
      "City: Port Annatown\n",
      "Country: Liechtenstein\n",
      "Phone 1: 4077245425\n",
      "Phone 2: 646.044.0696x66800\n",
      "\n",
      "Email: coleolson@jennings.net\n",
      "Subscription Date: 2021-04-24\n",
      "Website: https://patel-hanson.info/\n",
      "\n",
      "Index: 34\n",
      "Customer Id: A09AEc6E3bF70eE\n",
      "First Name: Kaitlyn\n",
      "Last Name: Santana\n",
      "Company: Herrera Group\n",
      "City: New Kaitlyn\n",
      "Country: United States of America\n",
      "Phone 1: 6303643286\n",
      "Phone 2: 447-710-6202x07313\n",
      "\n",
      "Email: georgeross@miles.org\n",
      "Subscription Date: 2021-09-21\n",
      "Website: http://pham.com/\n",
      "\n",
      "Index: 35\n",
      "Customer Id: aA9BAFfBc3710fe\n",
      "First Name: Faith\n",
      "Last Name: Moon\n",
      "Company: Waters, Chase and Aguilar\n",
      "City: West Marthaburgh\n",
      "Country: Bahamas\n",
      "Phone 1: +1-586-217-0359x6317\n",
      "\n",
      "Phone 2: +1-818-199-1403\n",
      "Email: willistonya@randolph-baker.com\n",
      "Subscription Date: 2021-11-03\n",
      "Website: https://spencer-charles.info/\n",
      "\n",
      "Index: 36\n",
      "Customer Id: E11dfb2DB8C9f72\n",
      "First Name: Tammie\n",
      "Last Name: Haley\n",
      "Company: Palmer, Barnes and Houston\n",
      "City: East Teresa\n",
      "Country: Belize\n",
      "Phone 1: 001-276-734-4113x6087\n",
      "Phone 2: (430)300-8770\n",
      "\n",
      "Email: harrisisaiah@jenkins.com\n",
      "Subscription Date: 2022-01-04\n",
      "Website: http://evans-simon.com/\n",
      "\n",
      "Index: 37\n",
      "Customer Id: 889eCf90f68c5Da\n",
      "First Name: Nicholas\n",
      "Last Name: Sosa\n",
      "Company: Jordan Ltd\n",
      "City: South Hunter\n",
      "Country: Uruguay\n",
      "Phone 1: (661)425-6042\n",
      "Phone 2: 975-998-1519\n",
      "\n",
      "Email: fwolfe@dorsey.com\n",
      "Subscription Date: 2021-08-10\n",
      "Website: https://www.fleming-richards.com/\n",
      "\n",
      "Index: 38\n",
      "Customer Id: 7a1Ee69F4fF4B4D\n",
      "First Name: Jordan\n",
      "Last Name: Gay\n",
      "Company: Glover and Sons\n",
      "City: South Walter\n",
      "Country: Solomon Islands\n",
      "Phone 1: 7208417020\n",
      "Phone 2: 8035336772\n",
      "\n",
      "Phone 2: 8035336772\n",
      "Email: tiffanydavies@harris-mcfarland.org\n",
      "Subscription Date: 2021-02-24\n",
      "Website: http://www.lee.org/\n",
      "\n",
      "Index: 39\n",
      "Customer Id: dca4f1D0A0fc5c9\n",
      "First Name: Bruce\n",
      "Last Name: Esparza\n",
      "Company: Huerta-Mclean\n",
      "City: Poolefurt\n",
      "Country: Montenegro\n",
      "Phone 1: 559-529-4424\n",
      "Phone 2: 001-625-000-7132x0367\n",
      "\n",
      "Email: preese@frye-vega.com\n",
      "Subscription Date: 2021-10-22\n",
      "Website: http://www.farley.org/\n",
      "\n",
      "Index: 40\n",
      "Customer Id: 17aD8e2dB3df03D\n",
      "First Name: Sherry\n",
      "Last Name: Garza\n",
      "Company: Anderson Ltd\n",
      "City: West John\n",
      "Country: Poland\n",
      "Phone 1: 001-067-713-6440x158\n",
      "Phone 2: (978)289-8785x5766\n",
      "\n",
      "Email: ann48@miller.com\n",
      "Subscription Date: 2021-11-01\n",
      "Website: http://spence.com/\n",
      "\n",
      "Index: 41\n",
      "Customer Id: 2f79Cd309624Abb\n",
      "First Name: Natalie\n",
      "Last Name: Gentry\n",
      "Company: Monroe PLC\n",
      "City: West Darius\n",
      "Country: Dominican Republic\n",
      "Phone 1: 830.996.8238\n",
      "Phone 2: 499.122.5415\n",
      "\n",
      "Email: tcummings@fitzpatrick-ashley.com\n",
      "Subscription Date: 2020-10-10\n",
      "Website: http://www.dorsey.biz/\n",
      "\n",
      "Index: 42\n",
      "Customer Id: 6e5ad5a5e2bB5Ca\n",
      "First Name: Bryan\n",
      "Last Name: Dunn\n",
      "Company: Kaufman and Sons\n",
      "City: North Jimstad\n",
      "Country: Burkina Faso\n",
      "Phone 1: 001-710-802-5565\n",
      "Phone 2: 078.699.8982x13881\n",
      "\n",
      "Email: woodwardandres@phelps.com\n",
      "Subscription Date: 2021-09-08\n",
      "Website: http://www.butler.com/\n",
      "\n",
      "Index: 43\n",
      "Customer Id: 7E441b6B228DBcA\n",
      "First Name: Wayne\n",
      "Last Name: Simpson\n",
      "Company: Perkins-Trevino\n",
      "City: East Rebekahborough\n",
      "Country: Bolivia\n",
      "Phone 1: (344)156-8632x1869\n",
      "Phone 2: 463-445-3702x38463\n",
      "\n",
      "Email: barbarapittman@holder.com\n",
      "Subscription Date: 2020-12-13\n",
      "Website: https://gillespie-holder.com/\n",
      "\n",
      "Index: 44\n",
      "Customer Id: D3fC11A9C235Dc6\n",
      "First Name: Luis\n",
      "Last Name: Greer\n",
      "Company: Cross PLC\n",
      "City: North Drew\n",
      "Country: Bulgaria\n",
      "Phone 1: 001-336-025-6849x701\n",
      "Phone 2: 684.698.2911x6092\n",
      "\n",
      "Email: bstuart@williamson-mcclure.com\n",
      "Subscription Date: 2022-05-15\n",
      "Website: https://fletcher-nielsen.com/\n",
      "\n",
      "Index: 45\n",
      "Customer Id: 30Dfa48fe5Ede78\n",
      "First Name: Rhonda\n",
      "Last Name: Frost\n",
      "Company: Herrera, Shepherd and Underwood\n",
      "City: Lake Lindaburgh\n",
      "Country: Monaco\n",
      "Phone 1: (127)081-9339\n",
      "\n",
      "Phone 2: +1-431-028-3337x3492\n",
      "Email: zkrueger@wolf-chavez.net\n",
      "Subscription Date: 2021-12-06\n",
      "Website: http://www.khan.com/\n",
      "\n",
      "Index: 46\n",
      "Customer Id: fD780ED8dbEae7B\n",
      "First Name: Joanne\n",
      "Last Name: Montes\n",
      "Company: Price, Sexton and Mcdaniel\n",
      "City: Gwendolynview\n",
      "Country: Palau\n",
      "Phone 1: (897)726-7952\n",
      "Phone 2: (467)886-9467x5721\n",
      "\n",
      "Email: juan80@henson.net\n",
      "Subscription Date: 2020-07-01\n",
      "Website: http://ochoa.com/\n",
      "\n",
      "Index: 47\n",
      "Customer Id: 300A40d3ce24bBA\n",
      "First Name: Geoffrey\n",
      "Last Name: Guzman\n",
      "Company: Short-Wiggins\n",
      "City: Zimmermanland\n",
      "Country: Uzbekistan\n",
      "Phone 1: 975.235.8921x269\n",
      "Phone 2: (983)188-6873\n",
      "\n",
      "Email: bauercrystal@gay.com\n",
      "Subscription Date: 2020-04-23\n",
      "Website: https://decker-kline.com/\n",
      "\n",
      "Index: 48\n",
      "Customer Id: 283DFCD0Dba40aF\n",
      "First Name: Gloria\n",
      "Last Name: Mccall\n",
      "Company: Brennan, Acosta and Ramos\n",
      "City: North Kerriton\n",
      "Country: Ghana\n",
      "Phone 1: 445-603-6729\n",
      "Phone 2: 001-395-959-4736x4524\n",
      "\n",
      "Email: bartlettjenna@zuniga-moss.biz\n",
      "Subscription Date: 2022-03-11\n",
      "Website: http://burgess-frank.com/\n",
      "\n",
      "Index: 49\n",
      "Customer Id: F4Fc91fEAEad286\n",
      "First Name: Brady\n",
      "Last Name: Cohen\n",
      "Company: Osborne-Erickson\n",
      "City: North Eileenville\n",
      "Country: United Arab Emirates\n",
      "Phone 1: 741.849.0139x524\n",
      "\n",
      "Phone 2: +1-028-691-7497x0894\n",
      "Email: mccalltyrone@durham-rose.biz\n",
      "Subscription Date: 2022-03-10\n",
      "Website: http://hammond-barron.com/\n",
      "\n",
      "Index: 50\n",
      "Customer Id: 80F33Fd2AcebF05\n",
      "First Name: Latoya\n",
      "Last Name: Mccann\n",
      "Company: Hobbs, Garrett and Sanford\n",
      "City: Port Sergiofort\n",
      "Country: Belarus\n",
      "Phone 1: (530)287-4548x29481\n",
      "\n",
      "Phone 2: 162-234-0249x32790\n",
      "Email: bobhammond@barry.biz\n",
      "Subscription Date: 2021-12-02\n",
      "Website: https://www.burton.com/\n",
      "\n",
      "Index: 51\n",
      "Customer Id: Aa20BDe68eAb0e9\n",
      "First Name: Gerald\n",
      "Last Name: Hawkins\n",
      "Company: Phelps, Forbes and Koch\n",
      "City: New Alberttown\n",
      "Country: Canada\n",
      "Phone 1: +1-323-239-1456x96168\n",
      "Phone 2: (092)508-0269\n",
      "\n",
      "Email: uwarner@steele-arias.com\n",
      "Subscription Date: 2021-03-19\n",
      "Website: https://valenzuela.com/\n",
      "\n",
      "Index: 52\n",
      "Customer Id: e898eEB1B9FE22b\n",
      "First Name: Samuel\n",
      "Last Name: Crawford\n",
      "Company: May, Goodwin and Martin\n",
      "City: South Jasmine\n",
      "Country: Algeria\n",
      "Phone 1: 802-242-7457\n",
      "Phone 2: 626.116.9535x8578\n",
      "\n",
      "Email: xpittman@ritter-carney.net\n",
      "Subscription Date: 2021-03-27\n",
      "Website: https://guerrero.org/\n",
      "\n",
      "Index: 53\n",
      "Customer Id: faCEF517ae7D8eB\n",
      "First Name: Patricia\n",
      "Last Name: Goodwin\n",
      "Company: Christian, Winters and Ellis\n",
      "City: Cowanfort\n",
      "Country: Swaziland\n",
      "Phone 1: 322.549.7139x70040\n",
      "\n",
      "Phone 2: (111)741-4173\n",
      "Email: vaughanchristy@lara.biz\n",
      "Subscription Date: 2021-03-08\n",
      "Website: http://clark.info/\n",
      "\n",
      "Index: 54\n",
      "Customer Id: c09952De6Cda8aA\n",
      "First Name: Stacie\n",
      "Last Name: Richard\n",
      "Company: Byrd Inc\n",
      "City: New Deborah\n",
      "Country: Madagascar\n",
      "Phone 1: 001-622-948-3641x24810\n",
      "Phone 2: 001-731-168-2893x8891\n",
      "\n",
      "Email: clinton85@colon-arias.org\n",
      "Subscription Date: 2020-10-15\n",
      "Website: https://kim.com/\n",
      "\n",
      "Index: 55\n",
      "Customer Id: f3BEf3Be028166f\n",
      "First Name: Robin\n",
      "Last Name: West\n",
      "Company: Nixon, Blackwell and Sosa\n",
      "City: Wallstown\n",
      "Country: Ecuador\n",
      "Phone 1: 698.303.4267\n",
      "Phone 2: 001-683-837-7651x525\n",
      "\n",
      "Email: greenemiranda@zimmerman.com\n",
      "Subscription Date: 2022-01-13\n",
      "Website: https://www.mora.com/\n",
      "\n",
      "Index: 56\n",
      "Customer Id: C6F2Fc6a7948a4e\n",
      "First Name: Ralph\n",
      "Last Name: Haas\n",
      "Company: Montes PLC\n",
      "City: Lake Ellenchester\n",
      "Country: Palestinian Territory\n",
      "Phone 1: 2239271999\n",
      "Phone 2: 001-962-434-0867x649\n",
      "\n",
      "Email: goodmancesar@figueroa.biz\n",
      "Subscription Date: 2020-05-25\n",
      "Website: http://may.com/\n",
      "\n",
      "Index: 57\n",
      "Customer Id: c8FE57cBBdCDcb2\n",
      "First Name: Phyllis\n",
      "Last Name: Maldonado\n",
      "Company: Costa PLC\n",
      "City: Lake Whitney\n",
      "Country: Saint Barthelemy\n",
      "Phone 1: 4500370767\n",
      "Phone 2: 001-508-064-6725x017\n",
      "\n",
      "Email: yhanson@warner-diaz.org\n",
      "Subscription Date: 2021-01-25\n",
      "Website: http://www.bernard.com/\n",
      "\n",
      "Index: 58\n",
      "Customer Id: B5acdFC982124F2\n",
      "First Name: Danny\n",
      "Last Name: Parrish\n",
      "Company: Novak LLC\n",
      "City: East Jaredbury\n",
      "Country: United Arab Emirates\n",
      "Phone 1: (669)384-8597x8794\n",
      "Phone 2: 506.731.5952x571\n",
      "\n",
      "Email: howelldarren@house-cohen.com\n",
      "Subscription Date: 2021-03-17\n",
      "Website: http://www.parsons-hudson.com/\n",
      "\n",
      "Index: 59\n",
      "Customer Id: 8c7DdF10798bCC3\n",
      "First Name: Kathy\n",
      "Last Name: Hill\n",
      "Company: Moore, Mccoy and Glass\n",
      "City: Selenabury\n",
      "Country: South Georgia and the South Sandwich Islands\n",
      "\n",
      "Phone 1: 001-171-716-2175x310\n",
      "Phone 2: 888.625.0654\n",
      "Email: ncamacho@boone-simmons.org\n",
      "Subscription Date: 2020-11-15\n",
      "Website: http://hayden.com/\n",
      "\n",
      "Index: 60\n",
      "Customer Id: C681dDd0cc422f7\n",
      "First Name: Kelli\n",
      "Last Name: Hardy\n",
      "Company: Petty Ltd\n",
      "City: Huangfort\n",
      "Country: Sao Tome and Principe\n",
      "Phone 1: 020.324.2191x2022\n",
      "Phone 2: 424-157-8216\n",
      "\n",
      "Email: kristopher62@oliver.com\n",
      "Subscription Date: 2020-12-20\n",
      "Website: http://www.kidd.com/\n",
      "\n",
      "Index: 61\n",
      "Customer Id: a940cE42e035F28\n",
      "First Name: Lynn\n",
      "Last Name: Pham\n",
      "Company: Brennan, Camacho and Tapia\n",
      "City: East Pennyshire\n",
      "Country: Portugal\n",
      "Phone 1: 846.468.6834x611\n",
      "Phone 2: 001-248-691-0006\n",
      "\n",
      "Email: mpham@rios-guzman.com\n",
      "Subscription Date: 2020-08-21\n",
      "Website: https://www.murphy.com/\n",
      "\n",
      "Index: 62\n",
      "Customer Id: 9Cf5E6AFE0aeBfd\n",
      "First Name: Shelley\n",
      "Last Name: Harris\n",
      "Company: Prince, Malone and Pugh\n",
      "City: Port Jasminborough\n",
      "Country: Togo\n",
      "Phone 1: 423.098.0315x8373\n",
      "\n",
      "Phone 2: +1-386-458-8944x15194\n",
      "Email: zachary96@mitchell-bryant.org\n",
      "Subscription Date: 2020-12-10\n",
      "Website: https://www.ryan.com/\n",
      "\n",
      "Index: 63\n",
      "Customer Id: aEcbe5365BbC67D\n",
      "First Name: Eddie\n",
      "Last Name: Jimenez\n",
      "Company: Caldwell Group\n",
      "City: West Kristine\n",
      "Country: Ethiopia\n",
      "Phone 1: +1-235-657-1073x6306\n",
      "Phone 2: (026)401-7353x2417\n",
      "\n",
      "Email: kristiwhitney@bernard.com\n",
      "Subscription Date: 2022-03-24\n",
      "Website: http://cherry.com/\n",
      "\n",
      "Index: 64\n",
      "Customer Id: FCBdfCEAe20A8Dc\n",
      "First Name: Chloe\n",
      "Last Name: Hutchinson\n",
      "Company: Simon LLC\n",
      "City: South Julia\n",
      "Country: Netherlands\n",
      "Phone 1: 981-544-9452\n",
      "Phone 2: +1-288-552-4666x060\n",
      "\n",
      "Email: leah85@sutton-terrell.com\n",
      "Subscription Date: 2022-05-15\n",
      "Website: https://mitchell.info/\n",
      "\n",
      "Index: 65\n",
      "Customer Id: 636cBF0835E10ff\n",
      "First Name: Eileen\n",
      "Last Name: Lynch\n",
      "Company: Knight, Abbott and Hubbard\n",
      "City: Helenborough\n",
      "Country: Liberia\n",
      "Phone 1: +1-158-951-4131x53578\n",
      "\n",
      "Phone 2: 001-673-779-6713x680\n",
      "Email: levigiles@vincent.com\n",
      "Subscription Date: 2021-01-02\n",
      "Website: http://mckay.com/\n",
      "\n",
      "Index: 66\n",
      "Customer Id: fF1b6c9E8Fbf1ff\n",
      "First Name: Fernando\n",
      "Last Name: Lambert\n",
      "Company: Church-Banks\n",
      "City: Lake Nancy\n",
      "Country: Lithuania\n",
      "Phone 1: 497.829.9038\n",
      "Phone 2: 3863743398\n",
      "\n",
      "Phone 2: 3863743398\n",
      "Email: fisherlinda@schaefer.net\n",
      "Subscription Date: 2021-04-23\n",
      "Website: https://www.vang.com/\n",
      "\n",
      "Index: 67\n",
      "Customer Id: 2A13F74EAa7DA6c\n",
      "First Name: Makayla\n",
      "Last Name: Cannon\n",
      "Company: Henderson Inc\n",
      "City: Georgeport\n",
      "Country: New Caledonia\n",
      "Phone 1: 001-215-801-6392x46009\n",
      "Phone 2: 027-609-6460\n",
      "\n",
      "Email: scottcurtis@hurley.biz\n",
      "Subscription Date: 2020-01-20\n",
      "Website: http://www.velazquez.net/\n",
      "\n",
      "Index: 68\n",
      "Customer Id: a014Ec1b9FccC1E\n",
      "First Name: Tom\n",
      "Last Name: Alvarado\n",
      "Company: Donaldson-Dougherty\n",
      "City: South Sophiaberg\n",
      "Country: Kiribati\n",
      "Phone 1: (585)606-2980x2258\n",
      "Phone 2: 730-797-3594x5614\n",
      "\n",
      "Email: nicholsonnina@montgomery.info\n",
      "Subscription Date: 2020-08-18\n",
      "Website: http://odom-massey.com/\n",
      "\n",
      "Index: 69\n",
      "Customer Id: 421a109cABDf5fa\n",
      "First Name: Virginia\n",
      "Last Name: Dudley\n",
      "Company: Warren Ltd\n",
      "City: Hartbury\n",
      "Country: French Southern Territories\n",
      "Phone 1: 027.846.3705x14184\n",
      "\n",
      "Phone 2: +1-439-171-1846x4636\n",
      "Email: zvalencia@phelps.com\n",
      "Subscription Date: 2021-01-31\n",
      "Website: http://hunter-esparza.com/\n",
      "\n",
      "Index: 70\n",
      "Customer Id: CC68FD1D3Bbbf22\n",
      "First Name: Riley\n",
      "Last Name: Good\n",
      "Company: Wade PLC\n",
      "City: Erikaville\n",
      "Country: Canada\n",
      "Phone 1: 6977745822\n",
      "Phone 2: 855-436-7641\n",
      "Email: alex06@galloway.com\n",
      "\n",
      "Subscription Date: 2020-02-03\n",
      "Website: http://conway.org/\n",
      "\n",
      "Index: 71\n",
      "Customer Id: CBCd2Ac8E3eBDF9\n",
      "First Name: Alexandria\n",
      "Last Name: Buck\n",
      "Company: Keller-Coffey\n",
      "City: Nicolasfort\n",
      "Country: Iran\n",
      "Phone 1: 078-900-4760x76668\n",
      "Phone 2: 414-112-8700x68751\n",
      "\n",
      "Email: lee48@manning.com\n",
      "Subscription Date: 2021-02-20\n",
      "Website: https://ramsey.org/\n",
      "\n",
      "Index: 72\n",
      "Customer Id: Ef859092FbEcC07\n",
      "First Name: Richard\n",
      "Last Name: Roth\n",
      "Company: Conway-Mcbride\n",
      "City: New Jasmineshire\n",
      "Country: Morocco\n",
      "Phone 1: 581-440-6539\n",
      "Phone 2: 9857827463\n",
      "\n",
      "Phone 2: 9857827463\n",
      "Email: aharper@maddox-townsend.org\n",
      "Subscription Date: 2020-02-23\n",
      "Website: https://www.brooks.com/\n",
      "\n",
      "Index: 73\n",
      "Customer Id: F560f2d3cDFb618\n",
      "First Name: Candice\n",
      "Last Name: Keller\n",
      "Company: Huynh and Sons\n",
      "City: East Summerstad\n",
      "Country: Zimbabwe\n",
      "Phone 1: 001-927-965-8550x92406\n",
      "\n",
      "Phone 2: 001-243-038-4271x53076\n",
      "Email: buckleycory@odonnell.net\n",
      "Subscription Date: 2020-08-22\n",
      "Website: https://www.lucero.com/\n",
      "\n",
      "Index: 74\n",
      "Customer Id: A3F76Be153Df4a3\n",
      "First Name: Anita\n",
      "Last Name: Benson\n",
      "Company: Parrish Ltd\n",
      "City: Skinnerport\n",
      "Country: Russian Federation\n",
      "Phone 1: 874.617.5668x69878\n",
      "Phone 2: (399)820-6418x0071\n",
      "\n",
      "Email: angie04@oconnell.com\n",
      "Subscription Date: 2020-02-09\n",
      "Website: http://oconnor.com/\n",
      "\n",
      "Index: 75\n",
      "Customer Id: D01Af0AF7cBbFeA\n",
      "First Name: Regina\n",
      "Last Name: Stein\n",
      "Company: Guzman-Brown\n",
      "City: Raystad\n",
      "Country: Solomon Islands\n",
      "Phone 1: 001-469-848-0724x4407\n",
      "Phone 2: 001-085-360-4426x00357\n",
      "\n",
      "Email: zrosario@rojas-hardin.net\n",
      "Subscription Date: 2022-01-15\n",
      "Website: http://www.johnston.info/\n",
      "\n",
      "Index: 76\n",
      "Customer Id: d40e89dCade7b2F\n",
      "First Name: Debra\n",
      "Last Name: Riddle\n",
      "Company: Chang, Aguirre and Leblanc\n",
      "City: Colinhaven\n",
      "Country: United States Virgin Islands\n",
      "Phone 1: +1-768-182-6014x14336\n",
      "\n",
      "Phone 2: (303)961-4491\n",
      "Email: shieldskerry@robles.com\n",
      "Subscription Date: 2020-07-11\n",
      "Website: http://kaiser.info/\n",
      "\n",
      "Index: 77\n",
      "Customer Id: BF6a1f9bd1bf8DE\n",
      "First Name: Brittany\n",
      "Last Name: Zuniga\n",
      "Company: Mason-Hester\n",
      "City: West Reginald\n",
      "Country: Kyrgyz Republic\n",
      "Phone 1: (050)136-9025\n",
      "Phone 2: 001-480-851-2496x0157\n",
      "\n",
      "Email: mchandler@cochran-huerta.org\n",
      "Subscription Date: 2021-07-24\n",
      "Website: http://www.boyle.com/\n",
      "\n",
      "Index: 78\n",
      "Customer Id: FfaeFFbbbf280db\n",
      "First Name: Cassidy\n",
      "Last Name: Mcmahon\n",
      "Company: Mcguire, Huynh and Hopkins\n",
      "City: Lake Sherryborough\n",
      "Country: Myanmar\n",
      "Phone 1: 5040771311\n",
      "\n",
      "Phone 1: 5040771311\n",
      "Phone 2: 684-682-0021x1326\n",
      "Email: katrinalane@fitzgerald.com\n",
      "Subscription Date: 2020-10-21\n",
      "Website: https://hurst.com/\n",
      "\n",
      "Index: 79\n",
      "Customer Id: CbAE1d1e9a8dCb1\n",
      "First Name: Laurie\n",
      "Last Name: Pennington\n",
      "Company: Sanchez, Marsh and Hale\n",
      "City: Port Katherineville\n",
      "Country: Dominica\n",
      "Phone 1: 007.155.3406x553\n",
      "\n",
      "Phone 2: +1-809-862-5566x277\n",
      "Email: cookejill@powell.com\n",
      "Subscription Date: 2020-06-08\n",
      "Website: http://www.hebert.com/\n",
      "\n",
      "Index: 80\n",
      "Customer Id: A7F85c1DE4dB87f\n",
      "First Name: Alejandro\n",
      "Last Name: Blair\n",
      "Company: Combs, Waller and Durham\n",
      "City: Thomasland\n",
      "Country: Iceland\n",
      "Phone 1: (690)068-4641x51468\n",
      "\n",
      "Phone 2: 555.509.8691x2329\n",
      "Email: elizabethbarr@ewing.com\n",
      "Subscription Date: 2020-09-19\n",
      "Website: https://mercado-blevins.com/\n",
      "\n",
      "Index: 81\n",
      "Customer Id: D6CEAfb3BDbaa1A\n",
      "First Name: Leslie\n",
      "Last Name: Jennings\n",
      "Company: Blankenship-Arias\n",
      "City: Coreybury\n",
      "Country: Micronesia\n",
      "Phone 1: 629.198.6346\n",
      "Phone 2: 075.256.0829\n",
      "\n",
      "Email: corey75@wiggins.com\n",
      "Subscription Date: 2021-11-13\n",
      "Website: https://www.juarez.com/\n",
      "\n",
      "Index: 82\n",
      "Customer Id: Ebdb6F6F7c90b69\n",
      "First Name: Kathleen\n",
      "Last Name: Mckay\n",
      "Company: Coffey, Lamb and Johnson\n",
      "City: Lake Janiceton\n",
      "Country: Saint Vincent and the Grenadines\n",
      "Phone 1: (733)910-9968\n",
      "\n",
      "Phone 2: (691)247-4128x0665\n",
      "Email: chloelester@higgins-wilkinson.com\n",
      "Subscription Date: 2021-09-12\n",
      "Website: http://www.owens-mooney.com/\n",
      "\n",
      "Index: 83\n",
      "Customer Id: E8E7e8Cfe516ef0\n",
      "First Name: Hunter\n",
      "Last Name: Moreno\n",
      "Company: Fitzpatrick-Lawrence\n",
      "City: East Clinton\n",
      "Country: Isle of Man\n",
      "Phone 1: (733)833-6754\n",
      "Phone 2: 001-761-013-7121\n",
      "\n",
      "Email: isaac26@benton-finley.com\n",
      "Subscription Date: 2020-12-28\n",
      "Website: http://walls.info/\n",
      "\n",
      "Index: 84\n",
      "Customer Id: 78C06E9b6B3DF20\n",
      "First Name: Chad\n",
      "Last Name: Davidson\n",
      "Company: Garcia-Jimenez\n",
      "City: South Joshuashire\n",
      "Country: Oman\n",
      "Phone 1: 8275702958\n",
      "Phone 2: (804)842-4715\n",
      "\n",
      "Email: justinwalters@jimenez.com\n",
      "Subscription Date: 2021-11-15\n",
      "Website: http://www.garner-oliver.com/\n",
      "\n",
      "Index: 85\n",
      "Customer Id: 03A1E62ADdeb31c\n",
      "First Name: Corey\n",
      "Last Name: Holt\n",
      "Company: Mcdonald, Bird and Ramirez\n",
      "City: New Glenda\n",
      "Country: Fiji\n",
      "Phone 1: 001-439-242-4986x7918\n",
      "Phone 2: 3162708934\n",
      "\n",
      "Phone 2: 3162708934\n",
      "Email: maurice46@morgan.com\n",
      "Subscription Date: 2020-02-18\n",
      "Website: http://www.watson.com/\n",
      "\n",
      "Index: 86\n",
      "Customer Id: C6763c99d0bd16D\n",
      "First Name: Emma\n",
      "Last Name: Cunningham\n",
      "Company: Stephens Inc\n",
      "City: North Jillianview\n",
      "Country: New Zealand\n",
      "Phone 1: 128-059-0206x60217\n",
      "Phone 2: (312)164-4545x2284\n",
      "\n",
      "Email: walter83@juarez.org\n",
      "Subscription Date: 2022-05-13\n",
      "Website: http://www.reid.info/\n",
      "\n",
      "Index: 87\n",
      "Customer Id: ebe77E5Bf9476CE\n",
      "First Name: Duane\n",
      "Last Name: Woods\n",
      "Company: Montoya-Miller\n",
      "City: Lyonsberg\n",
      "Country: Maldives\n",
      "Phone 1: (636)544-7783x7288\n",
      "Phone 2: (203)287-1003x5932\n",
      "\n",
      "Email: kmercer@wagner.com\n",
      "Subscription Date: 2020-07-21\n",
      "Website: http://murray.org/\n",
      "\n",
      "Index: 88\n",
      "Customer Id: E4Bbcd8AD81fC5f\n",
      "First Name: Alison\n",
      "Last Name: Vargas\n",
      "Company: Vaughn, Watts and Leach\n",
      "City: East Cristinabury\n",
      "Country: Benin\n",
      "Phone 1: 365-273-8144\n",
      "Phone 2: 053-308-7653x6287\n",
      "\n",
      "Email: vcantu@norton.com\n",
      "Subscription Date: 2020-11-10\n",
      "Website: http://mason.info/\n",
      "\n",
      "Index: 89\n",
      "Customer Id: efeb73245CDf1fF\n",
      "First Name: Vernon\n",
      "Last Name: Kane\n",
      "Company: Carter-Strickland\n",
      "City: Thomasfurt\n",
      "Country: Yemen\n",
      "Phone 1: 114-854-1159x555\n",
      "Phone 2: 499-608-4612\n",
      "\n",
      "Email: hilljesse@barrett.info\n",
      "Subscription Date: 2021-04-15\n",
      "Website: http://www.duffy-hensley.net/\n",
      "\n",
      "Index: 90\n",
      "Customer Id: 37Ec4B395641c1E\n",
      "First Name: Lori\n",
      "Last Name: Flowers\n",
      "Company: Decker-Mcknight\n",
      "City: North Joeburgh\n",
      "Country: Namibia\n",
      "Phone 1: 679.415.1210\n",
      "Phone 2: 945-842-3659x4581\n",
      "\n",
      "Email: tyrone77@valenzuela.info\n",
      "Subscription Date: 2021-01-09\n",
      "Website: http://www.deleon-crosby.com/\n",
      "\n",
      "Index: 91\n",
      "Customer Id: 5ef6d3eefdD43bE\n",
      "First Name: Nina\n",
      "Last Name: Chavez\n",
      "Company: Byrd-Campbell\n",
      "City: Cassidychester\n",
      "Country: Bhutan\n",
      "Phone 1: 053-344-3205\n",
      "Phone 2: +1-330-920-5422x571\n",
      "\n",
      "Email: elliserica@frank.com\n",
      "Subscription Date: 2020-03-26\n",
      "Website: https://www.pugh.com/\n",
      "\n",
      "Index: 92\n",
      "Customer Id: 98b3aeDcC3B9FF3\n",
      "First Name: Shane\n",
      "Last Name: Foley\n",
      "Company: Rocha-Hart\n",
      "City: South Dannymouth\n",
      "Country: Hungary\n",
      "Phone 1: +1-822-569-0302\n",
      "Phone 2: 001-626-114-5844x55073\n",
      "\n",
      "Email: nsteele@sparks.com\n",
      "Subscription Date: 2021-07-06\n",
      "Website: https://www.holt-sparks.com/\n",
      "\n",
      "Index: 93\n",
      "Customer Id: aAb6AFc7AfD0fF3\n",
      "First Name: Collin\n",
      "Last Name: Ayers\n",
      "Company: Lamb-Peterson\n",
      "City: South Lonnie\n",
      "Country: Anguilla\n",
      "Phone 1: 404-645-5351x012\n",
      "Phone 2: 001-257-582-8850x8516\n",
      "\n",
      "Email: dudleyemily@gonzales.biz\n",
      "Subscription Date: 2021-06-29\n",
      "Website: http://www.ruiz.com/\n",
      "\n",
      "Index: 94\n",
      "Customer Id: 54B5B5Fe9F1B6C5\n",
      "First Name: Sherry\n",
      "Last Name: Young\n",
      "Company: Lee, Lucero and Johnson\n",
      "City: Frankchester\n",
      "Country: Solomon Islands\n",
      "Phone 1: 158-687-1764\n",
      "Phone 2: (438)375-6207x003\n",
      "\n",
      "Email: alan79@gates-mclaughlin.com\n",
      "Subscription Date: 2021-04-04\n",
      "Website: https://travis.net/\n",
      "\n",
      "Index: 95\n",
      "Customer Id: BE91A0bdcA49Bbc\n",
      "First Name: Darrell\n",
      "Last Name: Douglas\n",
      "Company: Newton, Petersen and Mathis\n",
      "City: Daisyborough\n",
      "Country: Mali\n",
      "Phone 1: 001-084-845-9524x1777\n",
      "\n",
      "Phone 2: 001-769-564-6303\n",
      "Email: grayjean@lowery-good.com\n",
      "Subscription Date: 2022-02-17\n",
      "Website: https://banks.biz/\n",
      "\n",
      "Index: 96\n",
      "Customer Id: cb8E23e48d22Eae\n",
      "First Name: Karl\n",
      "Last Name: Greer\n",
      "Company: Carey LLC\n",
      "City: East Richard\n",
      "Country: Guyana\n",
      "Phone 1: (188)169-1674x58692\n",
      "Phone 2: 001-841-293-3519x614\n",
      "\n",
      "Email: hhart@jensen.com\n",
      "Subscription Date: 2022-01-30\n",
      "Website: http://hayes-perez.com/\n",
      "\n",
      "Index: 97\n",
      "Customer Id: CeD220bdAaCfaDf\n",
      "First Name: Lynn\n",
      "Last Name: Atkinson\n",
      "Company: Ware, Burns and Oneal\n",
      "City: New Bradview\n",
      "Country: Sri Lanka\n",
      "Phone 1: +1-846-706-2218\n",
      "Phone 2: 605.413.3198\n",
      "\n",
      "Email: vkemp@ferrell.com\n",
      "Subscription Date: 2021-07-10\n",
      "Website: https://novak-allison.com/\n",
      "\n",
      "Index: 98\n",
      "Customer Id: 28CDbC0dFe4b1Db\n",
      "First Name: Fred\n",
      "Last Name: Guerra\n",
      "Company: Schmitt-Jones\n",
      "City: Ortegaland\n",
      "Country: Solomon Islands\n",
      "Phone 1: +1-753-067-8419x7170\n",
      "Phone 2: +1-632-666-7507x92121\n",
      "\n",
      "Email: swagner@kane.org\n",
      "Subscription Date: 2021-09-18\n",
      "Website: https://www.ross.com/\n",
      "\n",
      "Index: 99\n",
      "Customer Id: c23d1D9EE8DEB0A\n",
      "First Name: Yvonne\n",
      "Last Name: Farmer\n",
      "Company: Fitzgerald-Harrell\n",
      "City: Lake Elijahview\n",
      "Country: Aruba\n",
      "Phone 1: (530)311-9786\n",
      "Phone 2: 001-869-452-0943x12424\n",
      "\n",
      "Email: mccarthystephen@horn-green.biz\n",
      "Subscription Date: 2021-08-11\n",
      "Website: http://watkins.info/\n",
      "\n",
      "Index: 100\n",
      "Customer Id: 2354a0E336A91A1\n",
      "First Name: Clarence\n",
      "Last Name: Haynes\n",
      "Company: Le, Nash and Cross\n",
      "City: Judymouth\n",
      "Country: Honduras\n",
      "Phone 1: (753)813-6941\n",
      "Phone 2: 783.639.1472\n",
      "\n",
      "Email: colleen91@faulkner.biz\n",
      "Subscription Date: 2020-03-11\n",
      "Website: http://www.hatfield-saunders.net/\n",
      "\n"
     ]
    }
   ],
   "source": [
    "loader_csv = CSVLoader(\n",
    "    file_path=file_path,\n",
    "    csv_args={\n",
    "        \"delimiter\": \",\",\n",
    "        \"quotechar\": '\"',\n",
    "        \"fieldnames\": fieldnames\n",
    "    }\n",
    ")\n",
    "\n",
    "docs_csv = loader_csv.load_and_split(text_splitter = text_splitter)\n",
    "for doc in docs_csv:\n",
    "    print(f'{doc.page_content}\\n')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1.2. <a id='toc1_2_'></a>[Load from pandas](#toc0_)\n",
    "this method can only choose one column to build the embedding"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Rasmussen Group\n",
      "\n",
      "Vega-Gentry\n",
      "\n",
      "Murillo-Perry\n",
      "\n",
      "Dominguez, Mcmillan and Donovan\n",
      "\n",
      "Martin, Lang and Andrade\n",
      "\n",
      "Steele Group\n",
      "\n",
      "Lester, Woodard and Mitchell\n",
      "\n",
      "Sanford, Davenport and Giles\n",
      "\n",
      "Browning-Simon\n",
      "\n",
      "Beck-Hendrix\n",
      "\n",
      "Oconnell, Meza and Everett\n",
      "\n",
      "Hoffman, Reed and Mcclain\n",
      "\n",
      "Graham-Francis\n",
      "\n",
      "Carpenter-Cook\n",
      "\n",
      "Carter-Hancock\n",
      "\n",
      "Singleton and Sons\n",
      "\n",
      "Winters-Mendoza\n",
      "\n",
      "Valentine LLC\n",
      "\n",
      "Simon LLC\n",
      "\n",
      "Mays-Mccormick\n",
      "\n",
      "Patterson Inc\n",
      "\n",
      "Manning, Hester and Arroyo\n",
      "\n",
      "Greer and Sons\n",
      "\n",
      "Watts-Donaldson\n",
      "\n",
      "Tucker LLC\n",
      "\n",
      "Giles Ltd\n",
      "\n",
      "Simmons Group\n",
      "\n",
      "Hinton, Chaney and Stokes\n",
      "\n",
      "Santana-Duran\n",
      "\n",
      "Sawyer PLC\n",
      "\n",
      "Acosta, Petersen and Morrow\n",
      "\n",
      "Mcgee Group\n",
      "\n",
      "Adkins-Salinas\n",
      "\n",
      "Herrera Group\n",
      "\n",
      "Waters, Chase and Aguilar\n",
      "\n",
      "Palmer, Barnes and Houston\n",
      "\n",
      "Jordan Ltd\n",
      "\n",
      "Glover and Sons\n",
      "\n",
      "Huerta-Mclean\n",
      "\n",
      "Anderson Ltd\n",
      "\n",
      "Monroe PLC\n",
      "\n",
      "Kaufman and Sons\n",
      "\n",
      "Perkins-Trevino\n",
      "\n",
      "Cross PLC\n",
      "\n",
      "Herrera, Shepherd and Underwood\n",
      "\n",
      "Price, Sexton and Mcdaniel\n",
      "\n",
      "Short-Wiggins\n",
      "\n",
      "Brennan, Acosta and Ramos\n",
      "\n",
      "Osborne-Erickson\n",
      "\n",
      "Hobbs, Garrett and Sanford\n",
      "\n",
      "Phelps, Forbes and Koch\n",
      "\n",
      "May, Goodwin and Martin\n",
      "\n",
      "Christian, Winters and Ellis\n",
      "\n",
      "Byrd Inc\n",
      "\n",
      "Nixon, Blackwell and Sosa\n",
      "\n",
      "Montes PLC\n",
      "\n",
      "Costa PLC\n",
      "\n",
      "Novak LLC\n",
      "\n",
      "Moore, Mccoy and Glass\n",
      "\n",
      "Petty Ltd\n",
      "\n",
      "Brennan, Camacho and Tapia\n",
      "\n",
      "Prince, Malone and Pugh\n",
      "\n",
      "Caldwell Group\n",
      "\n",
      "Simon LLC\n",
      "\n",
      "Knight, Abbott and Hubbard\n",
      "\n",
      "Church-Banks\n",
      "\n",
      "Henderson Inc\n",
      "\n",
      "Donaldson-Dougherty\n",
      "\n",
      "Warren Ltd\n",
      "\n",
      "Wade PLC\n",
      "\n",
      "Keller-Coffey\n",
      "\n",
      "Conway-Mcbride\n",
      "\n",
      "Huynh and Sons\n",
      "\n",
      "Parrish Ltd\n",
      "\n",
      "Guzman-Brown\n",
      "\n",
      "Chang, Aguirre and Leblanc\n",
      "\n",
      "Mason-Hester\n",
      "\n",
      "Mcguire, Huynh and Hopkins\n",
      "\n",
      "Sanchez, Marsh and Hale\n",
      "\n",
      "Combs, Waller and Durham\n",
      "\n",
      "Blankenship-Arias\n",
      "\n",
      "Coffey, Lamb and Johnson\n",
      "\n",
      "Fitzpatrick-Lawrence\n",
      "\n",
      "Garcia-Jimenez\n",
      "\n",
      "Mcdonald, Bird and Ramirez\n",
      "\n",
      "Stephens Inc\n",
      "\n",
      "Montoya-Miller\n",
      "\n",
      "Vaughn, Watts and Leach\n",
      "\n",
      "Carter-Strickland\n",
      "\n",
      "Decker-Mcknight\n",
      "\n",
      "Byrd-Campbell\n",
      "\n",
      "Rocha-Hart\n",
      "\n",
      "Lamb-Peterson\n",
      "\n",
      "Lee, Lucero and Johnson\n",
      "\n",
      "Newton, Petersen and Mathis\n",
      "\n",
      "Carey LLC\n",
      "\n",
      "Ware, Burns and Oneal\n",
      "\n",
      "Schmitt-Jones\n",
      "\n",
      "Fitzgerald-Harrell\n",
      "\n",
      "Le, Nash and Cross\n",
      "\n"
     ]
    }
   ],
   "source": [
    "from langchain.document_loaders import DataFrameLoader\n",
    "# if no field name in the .csv file, load with pd.read_csv(file_path, names=['filedname1', 'filedname2', ...])\n",
    "df = pd.read_csv(file_path)\n",
    "# must specify which column in the data frame contains the text we'll create embeddings for. \n",
    "loader_pandas = DataFrameLoader(df, page_content_column=\"Company\")\n",
    "                        \n",
    "docs_pandas = loader_pandas.load()\n",
    "for doc in docs_pandas:\n",
    "    print(f'{doc.page_content}\\n')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1.3. <a id='toc1_3_'></a>[Load from Unstructed.io](#toc0_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index\n",
      "Customer Id\n",
      "First Name\n",
      "Last Name\n",
      "Company\n",
      "City\n",
      "Country\n",
      "Phone 1\n",
      "Phone 2\n",
      "Email\n",
      "Subscription Date\n",
      "Website\n",
      "\n",
      "1\n",
      "DD37Cf93aecA6Dc\n",
      "Sheryl\n",
      "Baxter\n",
      "Rasmussen Group\n",
      "East Leonard\n",
      "Chile\n",
      "229.077.5154\n",
      "397.884.0519x718\n",
      "zunigavanessa@smith.info\n",
      "2020-08-24\n",
      "http://www.stephenson.com/\n",
      "\n",
      "2\n",
      "1Ef7b82A4CAAD10\n",
      "Preston\n",
      "Lozano\n",
      "Vega-Gentry\n",
      "East Jimmychester\n",
      "Djibouti\n",
      "5153435776\n",
      "686-620-1820x944\n",
      "vmata@colon.com\n",
      "2021-04-23\n",
      "http://www.hobbs.com/\n",
      "\n",
      "3\n",
      "6F94879bDAfE5a6\n",
      "Roy\n",
      "Berry\n",
      "Murillo-Perry\n",
      "Isabelborough\n",
      "Antigua and Barbuda\n",
      "+1-539-402-0259\n",
      "(496)978-3969x58947\n",
      "beckycarr@hogan.com\n",
      "2020-03-25\n",
      "http://www.lawrence.com/\n",
      "\n",
      "4\n",
      "5Cef8BFA16c5e3c\n",
      "Linda\n",
      "Olsen\n",
      "Dominguez, Mcmillan and Donovan\n",
      "Bensonview\n",
      "Dominican Republic\n",
      "001-808-617-6467x12895\n",
      "+1-813-324-8756\n",
      "stanleyblackwell@benson.org\n",
      "2020-06-02\n",
      "http://www.good-lyons.com/\n",
      "\n",
      "5\n",
      "053d585Ab6b3159\n",
      "Joanna\n",
      "Bender\n",
      "Martin, Lang and Andrade\n",
      "West Priscilla\n",
      "Slovakia (Slovak Republic)\n",
      "001-234-203-0635x76146\n",
      "001-199-446-3860x3486\n",
      "colinalvarado@miles.net\n",
      "2021-04-17\n",
      "\n",
      "2021-04-17\n",
      "https://goodwin-ingram.com/\n",
      "\n",
      "6\n",
      "2d08FB17EE273F4\n",
      "Aimee\n",
      "Downs\n",
      "Steele Group\n",
      "Chavezborough\n",
      "Bosnia and Herzegovina\n",
      "(283)437-3886x88321\n",
      "999-728-1637\n",
      "louis27@gilbert.com\n",
      "2020-02-25\n",
      "http://www.berger.net/\n",
      "\n",
      "7\n",
      "EA4d384DfDbBf77\n",
      "Darren\n",
      "Peck\n",
      "Lester, Woodard and Mitchell\n",
      "Lake Ana\n",
      "Pitcairn Islands\n",
      "(496)452-6181x3291\n",
      "+1-247-266-0963x4995\n",
      "tgates@cantrell.com\n",
      "2021-08-24\n",
      "https://www.le.com/\n",
      "\n",
      "8\n",
      "0e04AFde9f225dE\n",
      "Brett\n",
      "Mullen\n",
      "Sanford, Davenport and Giles\n",
      "Kimport\n",
      "Bulgaria\n",
      "001-583-352-7197x297\n",
      "001-333-145-0369\n",
      "asnow@colon.com\n",
      "2021-04-12\n",
      "https://hammond-ramsey.com/\n",
      "\n",
      "9\n",
      "C2dE4dEEc489ae0\n",
      "Sheryl\n",
      "Meyers\n",
      "Browning-Simon\n",
      "Robersonstad\n",
      "Cyprus\n",
      "854-138-4911x5772\n",
      "+1-448-910-2276x729\n",
      "mariokhan@ryan-pope.org\n",
      "2020-01-13\n",
      "https://www.bullock.net/\n",
      "\n",
      "10\n",
      "8C2811a503C7c5a\n",
      "Michelle\n",
      "Gallagher\n",
      "Beck-Hendrix\n",
      "Elaineberg\n",
      "Timor-Leste\n",
      "739.218.2516x459\n",
      "001-054-401-0347x617\n",
      "mdyer@escobar.net\n",
      "2021-11-08\n",
      "https://arias.com/\n",
      "\n",
      "11\n",
      "216E205d6eBb815\n",
      "Carl\n",
      "Schroeder\n",
      "Oconnell, Meza and Everett\n",
      "Shannonville\n",
      "Guernsey\n",
      "637-854-0256x825\n",
      "114.336.0784x788\n",
      "kirksalas@webb.com\n",
      "2021-10-20\n",
      "https://simmons-hurley.com/\n",
      "\n",
      "12\n",
      "CEDec94deE6d69B\n",
      "Jenna\n",
      "Dodson\n",
      "Hoffman, Reed and Mcclain\n",
      "East Andrea\n",
      "Vietnam\n",
      "(041)737-3846\n",
      "+1-556-888-3485x42608\n",
      "mark42@robbins.com\n",
      "2020-11-29\n",
      "http://www.douglas.net/\n",
      "\n",
      "13\n",
      "e35426EbDEceaFF\n",
      "Tracey\n",
      "Mata\n",
      "Graham-Francis\n",
      "South Joannamouth\n",
      "Togo\n",
      "001-949-844-8787\n",
      "(855)713-8773\n",
      "alex56@walls.org\n",
      "2021-12-02\n",
      "http://www.beck.com/\n",
      "\n",
      "14\n",
      "A08A8aF8BE9FaD4\n",
      "Kristine\n",
      "Cox\n",
      "Carpenter-Cook\n",
      "Jodyberg\n",
      "Sri Lanka\n",
      "786-284-3358x62152\n",
      "+1-315-627-1796x8074\n",
      "holdenmiranda@clarke.com\n",
      "2021-02-08\n",
      "https://www.brandt.com/\n",
      "\n",
      "15\n",
      "6fEaA1b7cab7B6C\n",
      "Faith\n",
      "Lutz\n",
      "Carter-Hancock\n",
      "Burchbury\n",
      "Singapore\n",
      "(781)861-7180x8306\n",
      "207-185-3665\n",
      "cassieparrish@blevins-chapman.net\n",
      "2022-01-26\n",
      "http://stevenson.org/\n",
      "\n",
      "16\n",
      "8cad0b4CBceaeec\n",
      "Miranda\n",
      "Beasley\n",
      "Singleton and Sons\n",
      "Desireeshire\n",
      "Oman\n",
      "540.085.3135x185\n",
      "+1-600-462-6432x21881\n",
      "vduncan@parks-hardy.com\n",
      "2022-04-12\n",
      "http://acosta.org/\n",
      "\n",
      "17\n",
      "a5DC21AE3a21eaA\n",
      "Caroline\n",
      "Foley\n",
      "Winters-Mendoza\n",
      "West Adriennestad\n",
      "Western Sahara\n",
      "936.222.4746x9924\n",
      "001-469-948-6341x359\n",
      "holtgwendolyn@watson-davenport.com\n",
      "2021-03-10\n",
      "http://www.benson-roth.com/\n",
      "\n",
      "18\n",
      "F8Aa9d6DfcBeeF8\n",
      "Greg\n",
      "Mata\n",
      "Valentine LLC\n",
      "Lake Leslie\n",
      "Mozambique\n",
      "(701)087-2415\n",
      "(195)156-1861x26241\n",
      "jaredjuarez@carroll.org\n",
      "2022-03-26\n",
      "http://pitts-cherry.com/\n",
      "\n",
      "19\n",
      "F160f5Db3EfE973\n",
      "Clifford\n",
      "Jacobson\n",
      "Simon LLC\n",
      "Harmonview\n",
      "South Georgia and the South Sandwich Islands\n",
      "001-151-330-3524x0469\n",
      "(748)477-7174\n",
      "joseph26@jacobson.com\n",
      "2020-09-24\n",
      "https://mcconnell.com/\n",
      "\n",
      "20\n",
      "0F60FF3DdCd7aB0\n",
      "Joanna\n",
      "Kirk\n",
      "Mays-Mccormick\n",
      "Jamesshire\n",
      "French Polynesia\n",
      "(266)131-7001x711\n",
      "(283)312-5579x11543\n",
      "tuckerangie@salazar.net\n",
      "2021-09-24\n",
      "https://www.camacho.net/\n",
      "\n",
      "21\n",
      "9F9AdB7B8A6f7F2\n",
      "Maxwell\n",
      "Frye\n",
      "Patterson Inc\n",
      "East Carly\n",
      "Malta\n",
      "423.262.3059\n",
      "202-880-0688x7491\n",
      "fgibson@drake-webb.com\n",
      "2022-01-12\n",
      "http://www.roberts.com/\n",
      "\n",
      "22\n",
      "FBd0Ded4F02a742\n",
      "Kiara\n",
      "Houston\n",
      "Manning, Hester and Arroyo\n",
      "South Alvin\n",
      "Netherlands\n",
      "001-274-040-3582x10611\n",
      "+1-528-175-0973x4684\n",
      "blanchardbob@wallace-shannon.com\n",
      "2020-09-15\n",
      "\n",
      "2020-09-15\n",
      "https://www.reid-potts.com/\n",
      "\n",
      "23\n",
      "2FB0FAA1d429421\n",
      "Colleen\n",
      "Howard\n",
      "Greer and Sons\n",
      "Brittanyview\n",
      "Paraguay\n",
      "1935085151\n",
      "(947)115-7711x5488\n",
      "rsingleton@ryan-cherry.com\n",
      "2020-08-19\n",
      "http://paul.biz/\n",
      "\n",
      "24\n",
      "010468dAA11382c\n",
      "Janet\n",
      "Valenzuela\n",
      "Watts-Donaldson\n",
      "Veronicamouth\n",
      "Lao People's Democratic Republic\n",
      "354.259.5062x7538\n",
      "500.433.2022\n",
      "stefanie71@spence.com\n",
      "2020-09-08\n",
      "https://moreno.biz/\n",
      "\n",
      "25\n",
      "eC1927Ca84E033e\n",
      "Shane\n",
      "Wilcox\n",
      "Tucker LLC\n",
      "Bryanville\n",
      "Albania\n",
      "(429)005-9030x11004\n",
      "541-116-4501\n",
      "mariah88@santos.com\n",
      "2021-04-06\n",
      "https://www.ramos.com/\n",
      "\n",
      "26\n",
      "09D7D7C8Fe09aea\n",
      "Marcus\n",
      "Moody\n",
      "Giles Ltd\n",
      "Kaitlyntown\n",
      "Panama\n",
      "674-677-8623\n",
      "909-277-5485x566\n",
      "donnamullins@norris-barrett.org\n",
      "2022-05-24\n",
      "https://www.curry.com/\n",
      "\n",
      "27\n",
      "aBdfcF2c50b0bfD\n",
      "Dakota\n",
      "Poole\n",
      "Simmons Group\n",
      "Michealshire\n",
      "Belarus\n",
      "(371)987-8576x4720\n",
      "071-152-1376\n",
      "stacey67@fields.org\n",
      "2022-02-20\n",
      "https://sanford-wilcox.biz/\n",
      "\n",
      "28\n",
      "b92EBfdF8a3f0E6\n",
      "Frederick\n",
      "Harper\n",
      "Hinton, Chaney and Stokes\n",
      "South Marissatown\n",
      "Switzerland\n",
      "+1-077-121-1558x0687\n",
      "264.742.7149\n",
      "jacobkhan@bright.biz\n",
      "2022-05-26\n",
      "https://callahan.org/\n",
      "\n",
      "29\n",
      "3B5dAAFA41AFa22\n",
      "Stefanie\n",
      "Fitzpatrick\n",
      "Santana-Duran\n",
      "Acevedoville\n",
      "Saint Vincent and the Grenadines\n",
      "(752)776-3286\n",
      "+1-472-021-4814x85074\n",
      "wterrell@clark.com\n",
      "2020-07-30\n",
      "https://meyers.com/\n",
      "\n",
      "30\n",
      "EDA69ca7a6e96a2\n",
      "Kent\n",
      "Bradshaw\n",
      "Sawyer PLC\n",
      "North Harold\n",
      "Tanzania\n",
      "+1-472-143-5037x884\n",
      "126.922.6153\n",
      "qjimenez@boyd.com\n",
      "2020-04-26\n",
      "http://maynard-ho.com/\n",
      "\n",
      "31\n",
      "64DCcDFaB9DFd4e\n",
      "Jack\n",
      "Tate\n",
      "Acosta, Petersen and Morrow\n",
      "West Samuel\n",
      "Zimbabwe\n",
      "965-108-4406x20714\n",
      "046.906.1442x6784\n",
      "gfigueroa@boone-zavala.com\n",
      "2021-09-15\n",
      "http://www.hawkins-ramsey.com/\n",
      "\n",
      "32\n",
      "679c6c83DD872d6\n",
      "Tom\n",
      "Trujillo\n",
      "Mcgee Group\n",
      "Cunninghamborough\n",
      "Denmark\n",
      "416-338-3758\n",
      "(775)890-7209\n",
      "tapiagreg@beard.info\n",
      "2022-01-13\n",
      "http://www.daniels-klein.com/\n",
      "\n",
      "33\n",
      "7Ce381e4Afa4ba9\n",
      "Gabriel\n",
      "Mejia\n",
      "Adkins-Salinas\n",
      "Port Annatown\n",
      "Liechtenstein\n",
      "4077245425\n",
      "646.044.0696x66800\n",
      "coleolson@jennings.net\n",
      "2021-04-24\n",
      "https://patel-hanson.info/\n",
      "\n",
      "34\n",
      "A09AEc6E3bF70eE\n",
      "Kaitlyn\n",
      "Santana\n",
      "Herrera Group\n",
      "New Kaitlyn\n",
      "United States of America\n",
      "6303643286\n",
      "447-710-6202x07313\n",
      "georgeross@miles.org\n",
      "2021-09-21\n",
      "http://pham.com/\n",
      "\n",
      "35\n",
      "aA9BAFfBc3710fe\n",
      "Faith\n",
      "Moon\n",
      "Waters, Chase and Aguilar\n",
      "West Marthaburgh\n",
      "Bahamas\n",
      "+1-586-217-0359x6317\n",
      "+1-818-199-1403\n",
      "willistonya@randolph-baker.com\n",
      "2021-11-03\n",
      "https://spencer-charles.info/\n",
      "\n",
      "36\n",
      "E11dfb2DB8C9f72\n",
      "Tammie\n",
      "Haley\n",
      "Palmer, Barnes and Houston\n",
      "East Teresa\n",
      "Belize\n",
      "001-276-734-4113x6087\n",
      "(430)300-8770\n",
      "harrisisaiah@jenkins.com\n",
      "2022-01-04\n",
      "http://evans-simon.com/\n",
      "\n",
      "37\n",
      "889eCf90f68c5Da\n",
      "Nicholas\n",
      "Sosa\n",
      "Jordan Ltd\n",
      "South Hunter\n",
      "Uruguay\n",
      "(661)425-6042\n",
      "975-998-1519\n",
      "fwolfe@dorsey.com\n",
      "2021-08-10\n",
      "https://www.fleming-richards.com/\n",
      "\n",
      "38\n",
      "7a1Ee69F4fF4B4D\n",
      "Jordan\n",
      "Gay\n",
      "Glover and Sons\n",
      "South Walter\n",
      "Solomon Islands\n",
      "7208417020\n",
      "8035336772\n",
      "tiffanydavies@harris-mcfarland.org\n",
      "2021-02-24\n",
      "http://www.lee.org/\n",
      "\n",
      "39\n",
      "dca4f1D0A0fc5c9\n",
      "Bruce\n",
      "Esparza\n",
      "Huerta-Mclean\n",
      "Poolefurt\n",
      "Montenegro\n",
      "559-529-4424\n",
      "001-625-000-7132x0367\n",
      "preese@frye-vega.com\n",
      "2021-10-22\n",
      "http://www.farley.org/\n",
      "\n",
      "40\n",
      "17aD8e2dB3df03D\n",
      "Sherry\n",
      "Garza\n",
      "Anderson Ltd\n",
      "West John\n",
      "Poland\n",
      "001-067-713-6440x158\n",
      "(978)289-8785x5766\n",
      "ann48@miller.com\n",
      "2021-11-01\n",
      "http://spence.com/\n",
      "\n",
      "41\n",
      "2f79Cd309624Abb\n",
      "Natalie\n",
      "Gentry\n",
      "Monroe PLC\n",
      "West Darius\n",
      "Dominican Republic\n",
      "830.996.8238\n",
      "499.122.5415\n",
      "tcummings@fitzpatrick-ashley.com\n",
      "2020-10-10\n",
      "http://www.dorsey.biz/\n",
      "\n",
      "42\n",
      "6e5ad5a5e2bB5Ca\n",
      "Bryan\n",
      "Dunn\n",
      "Kaufman and Sons\n",
      "North Jimstad\n",
      "Burkina Faso\n",
      "001-710-802-5565\n",
      "078.699.8982x13881\n",
      "woodwardandres@phelps.com\n",
      "2021-09-08\n",
      "http://www.butler.com/\n",
      "\n",
      "43\n",
      "7E441b6B228DBcA\n",
      "Wayne\n",
      "Simpson\n",
      "Perkins-Trevino\n",
      "East Rebekahborough\n",
      "Bolivia\n",
      "(344)156-8632x1869\n",
      "463-445-3702x38463\n",
      "barbarapittman@holder.com\n",
      "2020-12-13\n",
      "https://gillespie-holder.com/\n",
      "\n",
      "44\n",
      "D3fC11A9C235Dc6\n",
      "Luis\n",
      "Greer\n",
      "Cross PLC\n",
      "North Drew\n",
      "Bulgaria\n",
      "001-336-025-6849x701\n",
      "684.698.2911x6092\n",
      "bstuart@williamson-mcclure.com\n",
      "2022-05-15\n",
      "https://fletcher-nielsen.com/\n",
      "\n",
      "45\n",
      "30Dfa48fe5Ede78\n",
      "Rhonda\n",
      "Frost\n",
      "Herrera, Shepherd and Underwood\n",
      "Lake Lindaburgh\n",
      "Monaco\n",
      "(127)081-9339\n",
      "+1-431-028-3337x3492\n",
      "zkrueger@wolf-chavez.net\n",
      "2021-12-06\n",
      "http://www.khan.com/\n",
      "\n",
      "46\n",
      "fD780ED8dbEae7B\n",
      "Joanne\n",
      "Montes\n",
      "Price, Sexton and Mcdaniel\n",
      "Gwendolynview\n",
      "Palau\n",
      "(897)726-7952\n",
      "(467)886-9467x5721\n",
      "juan80@henson.net\n",
      "2020-07-01\n",
      "http://ochoa.com/\n",
      "\n",
      "47\n",
      "300A40d3ce24bBA\n",
      "Geoffrey\n",
      "Guzman\n",
      "Short-Wiggins\n",
      "Zimmermanland\n",
      "Uzbekistan\n",
      "975.235.8921x269\n",
      "(983)188-6873\n",
      "bauercrystal@gay.com\n",
      "2020-04-23\n",
      "https://decker-kline.com/\n",
      "\n",
      "48\n",
      "283DFCD0Dba40aF\n",
      "Gloria\n",
      "Mccall\n",
      "Brennan, Acosta and Ramos\n",
      "North Kerriton\n",
      "Ghana\n",
      "445-603-6729\n",
      "001-395-959-4736x4524\n",
      "bartlettjenna@zuniga-moss.biz\n",
      "2022-03-11\n",
      "http://burgess-frank.com/\n",
      "\n",
      "49\n",
      "F4Fc91fEAEad286\n",
      "Brady\n",
      "Cohen\n",
      "Osborne-Erickson\n",
      "North Eileenville\n",
      "United Arab Emirates\n",
      "741.849.0139x524\n",
      "+1-028-691-7497x0894\n",
      "mccalltyrone@durham-rose.biz\n",
      "2022-03-10\n",
      "http://hammond-barron.com/\n",
      "\n",
      "50\n",
      "80F33Fd2AcebF05\n",
      "Latoya\n",
      "Mccann\n",
      "Hobbs, Garrett and Sanford\n",
      "Port Sergiofort\n",
      "Belarus\n",
      "(530)287-4548x29481\n",
      "162-234-0249x32790\n",
      "bobhammond@barry.biz\n",
      "2021-12-02\n",
      "https://www.burton.com/\n",
      "\n",
      "51\n",
      "Aa20BDe68eAb0e9\n",
      "Gerald\n",
      "Hawkins\n",
      "Phelps, Forbes and Koch\n",
      "New Alberttown\n",
      "Canada\n",
      "+1-323-239-1456x96168\n",
      "(092)508-0269\n",
      "uwarner@steele-arias.com\n",
      "2021-03-19\n",
      "https://valenzuela.com/\n",
      "\n",
      "52\n",
      "e898eEB1B9FE22b\n",
      "Samuel\n",
      "Crawford\n",
      "May, Goodwin and Martin\n",
      "South Jasmine\n",
      "Algeria\n",
      "802-242-7457\n",
      "626.116.9535x8578\n",
      "xpittman@ritter-carney.net\n",
      "2021-03-27\n",
      "https://guerrero.org/\n",
      "\n",
      "53\n",
      "faCEF517ae7D8eB\n",
      "Patricia\n",
      "Goodwin\n",
      "Christian, Winters and Ellis\n",
      "Cowanfort\n",
      "Swaziland\n",
      "322.549.7139x70040\n",
      "(111)741-4173\n",
      "vaughanchristy@lara.biz\n",
      "2021-03-08\n",
      "http://clark.info/\n",
      "\n",
      "54\n",
      "c09952De6Cda8aA\n",
      "Stacie\n",
      "Richard\n",
      "Byrd Inc\n",
      "New Deborah\n",
      "Madagascar\n",
      "001-622-948-3641x24810\n",
      "001-731-168-2893x8891\n",
      "clinton85@colon-arias.org\n",
      "2020-10-15\n",
      "https://kim.com/\n",
      "\n",
      "55\n",
      "f3BEf3Be028166f\n",
      "Robin\n",
      "West\n",
      "Nixon, Blackwell and Sosa\n",
      "Wallstown\n",
      "Ecuador\n",
      "698.303.4267\n",
      "001-683-837-7651x525\n",
      "greenemiranda@zimmerman.com\n",
      "2022-01-13\n",
      "https://www.mora.com/\n",
      "\n",
      "56\n",
      "C6F2Fc6a7948a4e\n",
      "Ralph\n",
      "Haas\n",
      "Montes PLC\n",
      "Lake Ellenchester\n",
      "Palestinian Territory\n",
      "2239271999\n",
      "001-962-434-0867x649\n",
      "goodmancesar@figueroa.biz\n",
      "2020-05-25\n",
      "http://may.com/\n",
      "\n",
      "57\n",
      "c8FE57cBBdCDcb2\n",
      "Phyllis\n",
      "Maldonado\n",
      "Costa PLC\n",
      "Lake Whitney\n",
      "Saint Barthelemy\n",
      "4500370767\n",
      "001-508-064-6725x017\n",
      "yhanson@warner-diaz.org\n",
      "2021-01-25\n",
      "http://www.bernard.com/\n",
      "\n",
      "58\n",
      "B5acdFC982124F2\n",
      "Danny\n",
      "Parrish\n",
      "Novak LLC\n",
      "East Jaredbury\n",
      "United Arab Emirates\n",
      "(669)384-8597x8794\n",
      "506.731.5952x571\n",
      "howelldarren@house-cohen.com\n",
      "2021-03-17\n",
      "http://www.parsons-hudson.com/\n",
      "\n",
      "59\n",
      "8c7DdF10798bCC3\n",
      "Kathy\n",
      "Hill\n",
      "Moore, Mccoy and Glass\n",
      "Selenabury\n",
      "South Georgia and the South Sandwich Islands\n",
      "001-171-716-2175x310\n",
      "888.625.0654\n",
      "ncamacho@boone-simmons.org\n",
      "2020-11-15\n",
      "\n",
      "2020-11-15\n",
      "http://hayden.com/\n",
      "\n",
      "60\n",
      "C681dDd0cc422f7\n",
      "Kelli\n",
      "Hardy\n",
      "Petty Ltd\n",
      "Huangfort\n",
      "Sao Tome and Principe\n",
      "020.324.2191x2022\n",
      "424-157-8216\n",
      "kristopher62@oliver.com\n",
      "2020-12-20\n",
      "http://www.kidd.com/\n",
      "\n",
      "61\n",
      "a940cE42e035F28\n",
      "Lynn\n",
      "Pham\n",
      "Brennan, Camacho and Tapia\n",
      "East Pennyshire\n",
      "Portugal\n",
      "846.468.6834x611\n",
      "001-248-691-0006\n",
      "mpham@rios-guzman.com\n",
      "2020-08-21\n",
      "https://www.murphy.com/\n",
      "\n",
      "62\n",
      "9Cf5E6AFE0aeBfd\n",
      "Shelley\n",
      "Harris\n",
      "Prince, Malone and Pugh\n",
      "Port Jasminborough\n",
      "Togo\n",
      "423.098.0315x8373\n",
      "+1-386-458-8944x15194\n",
      "zachary96@mitchell-bryant.org\n",
      "2020-12-10\n",
      "https://www.ryan.com/\n",
      "\n",
      "63\n",
      "aEcbe5365BbC67D\n",
      "Eddie\n",
      "Jimenez\n",
      "Caldwell Group\n",
      "West Kristine\n",
      "Ethiopia\n",
      "+1-235-657-1073x6306\n",
      "(026)401-7353x2417\n",
      "kristiwhitney@bernard.com\n",
      "2022-03-24\n",
      "http://cherry.com/\n",
      "\n",
      "64\n",
      "FCBdfCEAe20A8Dc\n",
      "Chloe\n",
      "Hutchinson\n",
      "Simon LLC\n",
      "South Julia\n",
      "Netherlands\n",
      "981-544-9452\n",
      "+1-288-552-4666x060\n",
      "leah85@sutton-terrell.com\n",
      "2022-05-15\n",
      "https://mitchell.info/\n",
      "\n",
      "65\n",
      "636cBF0835E10ff\n",
      "Eileen\n",
      "Lynch\n",
      "Knight, Abbott and Hubbard\n",
      "Helenborough\n",
      "Liberia\n",
      "+1-158-951-4131x53578\n",
      "001-673-779-6713x680\n",
      "levigiles@vincent.com\n",
      "2021-01-02\n",
      "http://mckay.com/\n",
      "\n",
      "66\n",
      "fF1b6c9E8Fbf1ff\n",
      "Fernando\n",
      "Lambert\n",
      "Church-Banks\n",
      "Lake Nancy\n",
      "Lithuania\n",
      "497.829.9038\n",
      "3863743398\n",
      "fisherlinda@schaefer.net\n",
      "2021-04-23\n",
      "https://www.vang.com/\n",
      "\n",
      "67\n",
      "2A13F74EAa7DA6c\n",
      "Makayla\n",
      "Cannon\n",
      "Henderson Inc\n",
      "Georgeport\n",
      "New Caledonia\n",
      "001-215-801-6392x46009\n",
      "027-609-6460\n",
      "scottcurtis@hurley.biz\n",
      "2020-01-20\n",
      "http://www.velazquez.net/\n",
      "\n",
      "68\n",
      "a014Ec1b9FccC1E\n",
      "Tom\n",
      "Alvarado\n",
      "Donaldson-Dougherty\n",
      "South Sophiaberg\n",
      "Kiribati\n",
      "(585)606-2980x2258\n",
      "730-797-3594x5614\n",
      "nicholsonnina@montgomery.info\n",
      "2020-08-18\n",
      "http://odom-massey.com/\n",
      "\n",
      "69\n",
      "421a109cABDf5fa\n",
      "Virginia\n",
      "Dudley\n",
      "Warren Ltd\n",
      "Hartbury\n",
      "French Southern Territories\n",
      "027.846.3705x14184\n",
      "+1-439-171-1846x4636\n",
      "zvalencia@phelps.com\n",
      "2021-01-31\n",
      "http://hunter-esparza.com/\n",
      "\n",
      "70\n",
      "CC68FD1D3Bbbf22\n",
      "Riley\n",
      "Good\n",
      "Wade PLC\n",
      "Erikaville\n",
      "Canada\n",
      "6977745822\n",
      "855-436-7641\n",
      "alex06@galloway.com\n",
      "2020-02-03\n",
      "http://conway.org/\n",
      "\n",
      "71\n",
      "CBCd2Ac8E3eBDF9\n",
      "Alexandria\n",
      "Buck\n",
      "Keller-Coffey\n",
      "Nicolasfort\n",
      "Iran\n",
      "078-900-4760x76668\n",
      "414-112-8700x68751\n",
      "lee48@manning.com\n",
      "2021-02-20\n",
      "https://ramsey.org/\n",
      "\n",
      "72\n",
      "Ef859092FbEcC07\n",
      "Richard\n",
      "Roth\n",
      "Conway-Mcbride\n",
      "New Jasmineshire\n",
      "Morocco\n",
      "581-440-6539\n",
      "9857827463\n",
      "aharper@maddox-townsend.org\n",
      "2020-02-23\n",
      "https://www.brooks.com/\n",
      "\n",
      "73\n",
      "F560f2d3cDFb618\n",
      "Candice\n",
      "Keller\n",
      "Huynh and Sons\n",
      "East Summerstad\n",
      "Zimbabwe\n",
      "001-927-965-8550x92406\n",
      "001-243-038-4271x53076\n",
      "buckleycory@odonnell.net\n",
      "2020-08-22\n",
      "https://www.lucero.com/\n",
      "\n",
      "74\n",
      "A3F76Be153Df4a3\n",
      "Anita\n",
      "Benson\n",
      "Parrish Ltd\n",
      "Skinnerport\n",
      "Russian Federation\n",
      "874.617.5668x69878\n",
      "(399)820-6418x0071\n",
      "angie04@oconnell.com\n",
      "2020-02-09\n",
      "http://oconnor.com/\n",
      "\n",
      "75\n",
      "D01Af0AF7cBbFeA\n",
      "Regina\n",
      "Stein\n",
      "Guzman-Brown\n",
      "Raystad\n",
      "Solomon Islands\n",
      "001-469-848-0724x4407\n",
      "001-085-360-4426x00357\n",
      "zrosario@rojas-hardin.net\n",
      "2022-01-15\n",
      "http://www.johnston.info/\n",
      "\n",
      "76\n",
      "d40e89dCade7b2F\n",
      "Debra\n",
      "Riddle\n",
      "Chang, Aguirre and Leblanc\n",
      "Colinhaven\n",
      "United States Virgin Islands\n",
      "+1-768-182-6014x14336\n",
      "(303)961-4491\n",
      "shieldskerry@robles.com\n",
      "2020-07-11\n",
      "http://kaiser.info/\n",
      "\n",
      "77\n",
      "BF6a1f9bd1bf8DE\n",
      "Brittany\n",
      "Zuniga\n",
      "Mason-Hester\n",
      "West Reginald\n",
      "Kyrgyz Republic\n",
      "(050)136-9025\n",
      "001-480-851-2496x0157\n",
      "mchandler@cochran-huerta.org\n",
      "2021-07-24\n",
      "http://www.boyle.com/\n",
      "\n",
      "78\n",
      "FfaeFFbbbf280db\n",
      "Cassidy\n",
      "Mcmahon\n",
      "Mcguire, Huynh and Hopkins\n",
      "Lake Sherryborough\n",
      "Myanmar\n",
      "5040771311\n",
      "684-682-0021x1326\n",
      "katrinalane@fitzgerald.com\n",
      "2020-10-21\n",
      "https://hurst.com/\n",
      "\n",
      "79\n",
      "CbAE1d1e9a8dCb1\n",
      "Laurie\n",
      "Pennington\n",
      "Sanchez, Marsh and Hale\n",
      "Port Katherineville\n",
      "Dominica\n",
      "007.155.3406x553\n",
      "+1-809-862-5566x277\n",
      "cookejill@powell.com\n",
      "2020-06-08\n",
      "http://www.hebert.com/\n",
      "\n",
      "80\n",
      "A7F85c1DE4dB87f\n",
      "Alejandro\n",
      "Blair\n",
      "Combs, Waller and Durham\n",
      "Thomasland\n",
      "Iceland\n",
      "(690)068-4641x51468\n",
      "555.509.8691x2329\n",
      "elizabethbarr@ewing.com\n",
      "2020-09-19\n",
      "https://mercado-blevins.com/\n",
      "\n",
      "81\n",
      "D6CEAfb3BDbaa1A\n",
      "Leslie\n",
      "Jennings\n",
      "Blankenship-Arias\n",
      "Coreybury\n",
      "Micronesia\n",
      "629.198.6346\n",
      "075.256.0829\n",
      "corey75@wiggins.com\n",
      "2021-11-13\n",
      "https://www.juarez.com/\n",
      "\n",
      "82\n",
      "Ebdb6F6F7c90b69\n",
      "Kathleen\n",
      "Mckay\n",
      "Coffey, Lamb and Johnson\n",
      "Lake Janiceton\n",
      "Saint Vincent and the Grenadines\n",
      "(733)910-9968\n",
      "(691)247-4128x0665\n",
      "chloelester@higgins-wilkinson.com\n",
      "2021-09-12\n",
      "\n",
      "2021-09-12\n",
      "http://www.owens-mooney.com/\n",
      "\n",
      "83\n",
      "E8E7e8Cfe516ef0\n",
      "Hunter\n",
      "Moreno\n",
      "Fitzpatrick-Lawrence\n",
      "East Clinton\n",
      "Isle of Man\n",
      "(733)833-6754\n",
      "001-761-013-7121\n",
      "isaac26@benton-finley.com\n",
      "2020-12-28\n",
      "http://walls.info/\n",
      "\n",
      "84\n",
      "78C06E9b6B3DF20\n",
      "Chad\n",
      "Davidson\n",
      "Garcia-Jimenez\n",
      "South Joshuashire\n",
      "Oman\n",
      "8275702958\n",
      "(804)842-4715\n",
      "justinwalters@jimenez.com\n",
      "2021-11-15\n",
      "http://www.garner-oliver.com/\n",
      "\n",
      "85\n",
      "03A1E62ADdeb31c\n",
      "Corey\n",
      "Holt\n",
      "Mcdonald, Bird and Ramirez\n",
      "New Glenda\n",
      "Fiji\n",
      "001-439-242-4986x7918\n",
      "3162708934\n",
      "maurice46@morgan.com\n",
      "2020-02-18\n",
      "http://www.watson.com/\n",
      "\n",
      "86\n",
      "C6763c99d0bd16D\n",
      "Emma\n",
      "Cunningham\n",
      "Stephens Inc\n",
      "North Jillianview\n",
      "New Zealand\n",
      "128-059-0206x60217\n",
      "(312)164-4545x2284\n",
      "walter83@juarez.org\n",
      "2022-05-13\n",
      "http://www.reid.info/\n",
      "\n",
      "87\n",
      "ebe77E5Bf9476CE\n",
      "Duane\n",
      "Woods\n",
      "Montoya-Miller\n",
      "Lyonsberg\n",
      "Maldives\n",
      "(636)544-7783x7288\n",
      "(203)287-1003x5932\n",
      "kmercer@wagner.com\n",
      "2020-07-21\n",
      "http://murray.org/\n",
      "\n",
      "88\n",
      "E4Bbcd8AD81fC5f\n",
      "Alison\n",
      "Vargas\n",
      "Vaughn, Watts and Leach\n",
      "East Cristinabury\n",
      "Benin\n",
      "365-273-8144\n",
      "053-308-7653x6287\n",
      "vcantu@norton.com\n",
      "2020-11-10\n",
      "http://mason.info/\n",
      "\n",
      "89\n",
      "efeb73245CDf1fF\n",
      "Vernon\n",
      "Kane\n",
      "Carter-Strickland\n",
      "Thomasfurt\n",
      "Yemen\n",
      "114-854-1159x555\n",
      "499-608-4612\n",
      "hilljesse@barrett.info\n",
      "2021-04-15\n",
      "http://www.duffy-hensley.net/\n",
      "\n",
      "90\n",
      "37Ec4B395641c1E\n",
      "Lori\n",
      "Flowers\n",
      "Decker-Mcknight\n",
      "North Joeburgh\n",
      "Namibia\n",
      "679.415.1210\n",
      "945-842-3659x4581\n",
      "tyrone77@valenzuela.info\n",
      "2021-01-09\n",
      "http://www.deleon-crosby.com/\n",
      "\n",
      "91\n",
      "5ef6d3eefdD43bE\n",
      "Nina\n",
      "Chavez\n",
      "Byrd-Campbell\n",
      "Cassidychester\n",
      "Bhutan\n",
      "053-344-3205\n",
      "+1-330-920-5422x571\n",
      "elliserica@frank.com\n",
      "2020-03-26\n",
      "https://www.pugh.com/\n",
      "\n",
      "92\n",
      "98b3aeDcC3B9FF3\n",
      "Shane\n",
      "Foley\n",
      "Rocha-Hart\n",
      "South Dannymouth\n",
      "Hungary\n",
      "+1-822-569-0302\n",
      "001-626-114-5844x55073\n",
      "nsteele@sparks.com\n",
      "2021-07-06\n",
      "https://www.holt-sparks.com/\n",
      "\n",
      "93\n",
      "aAb6AFc7AfD0fF3\n",
      "Collin\n",
      "Ayers\n",
      "Lamb-Peterson\n",
      "South Lonnie\n",
      "Anguilla\n",
      "404-645-5351x012\n",
      "001-257-582-8850x8516\n",
      "dudleyemily@gonzales.biz\n",
      "2021-06-29\n",
      "http://www.ruiz.com/\n",
      "\n",
      "94\n",
      "54B5B5Fe9F1B6C5\n",
      "Sherry\n",
      "Young\n",
      "Lee, Lucero and Johnson\n",
      "Frankchester\n",
      "Solomon Islands\n",
      "158-687-1764\n",
      "(438)375-6207x003\n",
      "alan79@gates-mclaughlin.com\n",
      "2021-04-04\n",
      "https://travis.net/\n",
      "\n",
      "95\n",
      "BE91A0bdcA49Bbc\n",
      "Darrell\n",
      "Douglas\n",
      "Newton, Petersen and Mathis\n",
      "Daisyborough\n",
      "Mali\n",
      "001-084-845-9524x1777\n",
      "001-769-564-6303\n",
      "grayjean@lowery-good.com\n",
      "2022-02-17\n",
      "https://banks.biz/\n",
      "\n",
      "96\n",
      "cb8E23e48d22Eae\n",
      "Karl\n",
      "Greer\n",
      "Carey LLC\n",
      "East Richard\n",
      "Guyana\n",
      "(188)169-1674x58692\n",
      "001-841-293-3519x614\n",
      "hhart@jensen.com\n",
      "2022-01-30\n",
      "http://hayes-perez.com/\n",
      "\n",
      "97\n",
      "CeD220bdAaCfaDf\n",
      "Lynn\n",
      "Atkinson\n",
      "Ware, Burns and Oneal\n",
      "New Bradview\n",
      "Sri Lanka\n",
      "+1-846-706-2218\n",
      "605.413.3198\n",
      "vkemp@ferrell.com\n",
      "2021-07-10\n",
      "https://novak-allison.com/\n",
      "\n",
      "98\n",
      "28CDbC0dFe4b1Db\n",
      "Fred\n",
      "Guerra\n",
      "Schmitt-Jones\n",
      "Ortegaland\n",
      "Solomon Islands\n",
      "+1-753-067-8419x7170\n",
      "+1-632-666-7507x92121\n",
      "swagner@kane.org\n",
      "2021-09-18\n",
      "https://www.ross.com/\n",
      "\n",
      "99\n",
      "c23d1D9EE8DEB0A\n",
      "Yvonne\n",
      "Farmer\n",
      "Fitzgerald-Harrell\n",
      "Lake Elijahview\n",
      "Aruba\n",
      "(530)311-9786\n",
      "001-869-452-0943x12424\n",
      "mccarthystephen@horn-green.biz\n",
      "2021-08-11\n",
      "http://watkins.info/\n",
      "\n",
      "100\n",
      "2354a0E336A91A1\n",
      "Clarence\n",
      "Haynes\n",
      "Le, Nash and Cross\n",
      "Judymouth\n",
      "Honduras\n",
      "(753)813-6941\n",
      "783.639.1472\n",
      "colleen91@faulkner.biz\n",
      "2020-03-11\n",
      "http://www.hatfield-saunders.net/\n",
      "\n"
     ]
    }
   ],
   "source": [
    "from langchain.document_loaders import UnstructuredAPIFileLoader\n",
    "# register at Unstructured.io to get a free API Key\n",
    "load_dotenv(os.path.join(repo_dir,'.env'))\n",
    "\n",
    "loader_unestructured = UnstructuredAPIFileLoader(file_path, mode=\"elements\", \n",
    "                                                 api_key=os.environ.get(\"UNSTRUCTURED_API_KEY\"), \n",
    "                                                 url=os.environ.get(\"UNSTRUCTURED_URL\"))\n",
    "docs_unstructured = loader_unestructured.load_and_split(text_splitter)\n",
    "for doc in docs_unstructured:\n",
    "    print(f'{doc.page_content}\\n')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2. <a id='toc2_'></a>[Evaluate loded docs by embedding similarity](#toc0_)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 2.1. <a id='toc2_1_'></a>[Evaluate embedding by similarity](#toc0_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from langchain.embeddings import HuggingFaceInstructEmbeddings\n",
    "from langchain.vectorstores import FAISS\n",
    "\n",
    "encode_kwargs = {'normalize_embeddings': True}\n",
    "embd_model = HuggingFaceInstructEmbeddings( model_name='intfloat/e5-large-v2',\n",
    "                                            embed_instruction=\"\", # no instructions needed for candidate passages\n",
    "                                            query_instruction=\"Represent this sentence for searching relevant passages: \",\n",
    "                                            encode_kwargs=encode_kwargs)\n",
    "vectorstore_csv = FAISS.from_documents(documents=docs_csv, embedding=embd_model)\n",
    "vectorstore_pandas = FAISS.from_documents(documents=docs_pandas, embedding=embd_model)\n",
    "vectorstore_unstructured = FAISS.from_documents(documents=docs_unstructured, embedding=embd_model)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 2.2. <a id='toc2_2_'></a>[Similarity search](#toc0_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "-------CSV Loader----------\n",
      "\n",
      "Index: 2\n",
      "Customer Id: 1Ef7b82A4CAAD10\n",
      "First Name: Preston\n",
      "Last Name: Lozano\n",
      "Company: Vega-Gentry\n",
      "City: East Jimmychester\n",
      "Country: Djibouti\n",
      "Phone 1: 5153435776\n",
      "Phone 2: 686-620-1820x944\n",
      "--------Pandas------------\n",
      "\n",
      "Lamb-Peterson\n",
      "--------Unstructred------------\n",
      "\n",
      "Index\n",
      "Customer Id\n",
      "First Name\n",
      "Last Name\n",
      "Company\n",
      "City\n",
      "Country\n",
      "Phone 1\n",
      "Phone 2\n",
      "Email\n",
      "Subscription Date\n",
      "Website\n"
     ]
    }
   ],
   "source": [
    "query = \"What is the information about customer with first name Preston?\"\n",
    "ans = vectorstore_csv.similarity_search(query)\n",
    "print(\"-------CSV Loader----------\\n\")\n",
    "print(ans[0].page_content)\n",
    "\n",
    "\n",
    "ans_2 = vectorstore_pandas.similarity_search(query)\n",
    "print(\"--------Pandas------------\\n\")\n",
    "print(ans_2[0].page_content)\n",
    "\n",
    "\n",
    "ans_3 = vectorstore_unstructured.similarity_search(query)\n",
    "print(\"--------Unstructred------------\\n\")\n",
    "print(ans_3[0].page_content)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "c141c502b4874f6f7cd85d57d9f08ebe5bc7ea264c7dc3d59361b279d0075653"
  },
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.10.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}