Homework-18-01 - Scraping - Texas Cosmetology Violations (2021)-Tomita.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Texas Cosmetologist Violations\n",
    "\n",
    "Texas has a system for [searching for license violations](https://www.tdlr.texas.gov/cimsfo/fosearch.asp). You're going to search for cosmetologists!"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Setup: Import what you'll need to scrape the page\n",
    "\n",
    "We'll be using Selenium for this, *not* BeautifulSoup and requests."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import time\n",
    "\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.by import By\n",
    "from webdriver_manager.chrome import ChromeDriverManager\n",
    "from selenium.webdriver.support.ui import Select"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/m5/5y2tv80j62v6m1f84pdbl2vm0000gn/T/ipykernel_80967/1503906442.py:1: DeprecationWarning: executable_path has been deprecated, please pass in a Service object\n",
      "  driver = webdriver.Chrome(ChromeDriverManager().install())\n"
     ]
    }
   ],
   "source": [
    "driver = webdriver.Chrome(ChromeDriverManager().install())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "## Starting your search\n",
    "\n",
    "Starting from [here](https://www.tdlr.texas.gov/cimsfo/fosearch.asp), search for cosmetologist violations for people with the last name **Nguyen**."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "driver.get(\"https://www.tdlr.texas.gov/cimsfo/fosearch.asp\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#choose License Program Type\n",
    "dropdown = driver.find_element(By.ID, \"pht_status\")\n",
    "Select(dropdown).select_by_value(\"COS\")\n",
    "\n",
    "#Input the last name\n",
    "driver.find_element(By.ID, \"pht_lnm\").send_keys(\"Nguyen\")\n",
    "\n",
    "#submit\n",
    "driver.find_element(By.XPATH, \"/html/body/div/div/div[2]/div[1]/div/section/div/div/table/tbody/tr/td/form/table/tbody/tr[18]/td/input[1]\").click()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Scraping\n",
    "\n",
    "Once you are on the results page, do this. **I step you through things bit by bit, so it's going to be a little different than we did in class.** Also, no `pd.read_html` allowed because this isn't actual tabular data!\n",
    "\n",
    "> You can use either Selenium by itself or Selenium+BeautifulSoup to scrape the results page. The choice is up to you!"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Loop through each result and print the entire row\n",
    "\n",
    "Okay wait, maybe not, i's a heck of a lot of rows. Use `[:10]` to only do the first ten! For example, if you saved the table rows into `results` you might do something like this:\n",
    "\n",
    "```python\n",
    "for result in results[:10]:\n",
    "    print(result)\n",
    "```\n",
    "\n",
    "Although you'd want to print out the text from the row (I give example output below).\n",
    "\n",
    "> *Tip: If you're using Selenium, `By.TAG_NAME` is used if you don't have a class or ID. If you're using BeautifulSoup, just do your normal thing.*"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The result should look something like this:\n",
    "\n",
    "```\n",
    "Name and Location Order Basis for Order\n",
    "NGUYEN, THANH\n",
    "City: FRISCO\n",
    "County: COLLIN\n",
    "Zip Code: 75034\n",
    "\n",
    "\n",
    "License #: 790672\n",
    "\n",
    "Complaint # COS20210004784 Date: 11/16/2021\n",
    "\n",
    "Respondent is assessed an administrative penalty in the amount of $1,875. Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day, the Department is charging 2 violations; Respondent operated a cosmetology salon without the appropriate license.\n",
    "NGUYEN, LONG D\n",
    "City: SAN SABA\n",
    "County: SAN SABA\n",
    "Zip Code: 76877\n",
    "```"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "results = driver.find_elements(By.CSS_SELECTOR, \"tr\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "NGUYEN, MAI T\n",
      "City: AUSTIN\n",
      "County: TRAVIS\n",
      "Zip Code: 78717\n",
      "\n",
      "\n",
      "License #: 750076\n",
      "\n",
      "Complaint # COS20220000853 Date: 7/7/2022\n",
      "\n",
      "Respondent is assessed an administrative penalty in the amount of $7,500. Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 3 violations; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required, the Department is charging 3 violations; Respondent failed to clean and disinfect all wax pots; Respondent failed to clean diamond, carbide, natural and metal bits after each use with a brush or ultrasonic cleaner, or by immersing in acetone.\n",
      "------\n",
      "NGUYEN, HUNG VU\n",
      "City: HOUSTON\n",
      "County: HARRIS\n",
      "Zip Code: 77086\n",
      "\n",
      "\n",
      "License #: 763912\n",
      "\n",
      "Complaint # COS20200013887 Date: 7/6/2022\n",
      "\n",
      "Respondent is assessed an administrative penalty in the amount of $3,000. Respondent failed to keep floors, walls, ceilings, shelves, furniture, furnishings, and fixtures clean and in good repair; Respondent failed to clean and disinfect multiple use implements after each customer; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 2 violations; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use, the Department is charging 2 violations; Respondent failed to disinfect tools, implements, and supplies with an EPA-registered disinfectant solution; Respondent failed to keep all products properly labeled in compliance with OSHA requirements.\n",
      "------\n",
      "NGUYEN, MINH HIEN LUONG\n",
      "City: CARROLLTON\n",
      "County: DALLAS\n",
      "Zip Code: 75007\n",
      "\n",
      "\n",
      "License #: 777932\n",
      "\n",
      "Complaint # COS20210010437 Date: 6/27/2022\n",
      "\n",
      "Respondent is assessed an administrative penalty in the amount of $500. Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "------\n",
      "NGUYEN, PHUONG T\n",
      "City: PLANO\n",
      "County: COLLIN\n",
      "Zip Code: 75023\n",
      "\n",
      "\n",
      "License #: 766293\n",
      "\n",
      "Complaint # COS20210014779 Date: 6/16/2022\n",
      "\n",
      "Respondent is assessed an administrative penalty in the amount of $6,800. Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 9 violations; Respondent failed to clean and disinfect all wax pots; Respondent failed to utilize clean and disinfected implements; Respondent failed to clean and disinfect manicure tables prior to use for each client; Respondent failed to discard buffer blocks and porous nail files when exposed to a client's broken skin and/or unhealthy nails.\n",
      "------\n",
      "NGUYEN, STEVEN MANH\n",
      "City: FORT WORTH\n",
      "County: TARRANT\n",
      "Zip Code: 76244\n",
      "\n",
      "\n",
      "License #: 773318\n",
      "\n",
      "Complaint # COS20200015190 Date: 6/9/2022\n",
      "\n",
      "Respondent is assessed an administrative penalty in the amount of $1,000. Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license.\n",
      "------\n",
      "NGUYEN, LANG THU\n",
      "City: ALLEN\n",
      "County: COLLIN\n",
      "Zip Code: 75002\n",
      "\n",
      "\n",
      "License #: 744463\n",
      "\n",
      "Complaint # COS20200008154 Date: 6/2/2022\n",
      "\n",
      "Respondent is assessed an administrative penalty in the amount of $1,000. Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required.\n",
      "------\n",
      "NGUYEN, THANH\n",
      "City: FRISCO\n",
      "County: COLLIN\n",
      "Zip Code: 75034\n",
      "\n",
      "\n",
      "License #: 790672\n",
      "\n",
      "Complaint # COS20200007790 Date: 5/2/2022\n",
      "\n",
      "Respondent is assessed an administrative penalty in the amount of $2,625. Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly, the Department is charging 11 violations; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.\n",
      "------\n",
      "NGUYEN, NAM QUANG\n",
      "City: HARKER HEIGHTS\n",
      "County: BELL\n",
      "Zip Code: 76548\n",
      "\n",
      "\n",
      "License #: 745552\n",
      "\n",
      "Complaint # COS20210010525 Date: 4/27/2022\n",
      "\n",
      "Respondent is assessed an administrative penalty in the amount of $2,000. Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 5 violations; Respondent failed to clean and disinfect all wax pots; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.\n",
      "------\n",
      "NGUYEN, JAY TRI\n",
      "City: SAN ANTONIO\n",
      "County: BEXAR\n",
      "Zip Code: 78266\n",
      "\n",
      "\n",
      "License #: 735165\n",
      "\n",
      "Complaint # COS20210015763 Date: 4/27/2022\n",
      "\n",
      "Respondent is assessed an administrative penalty in the amount of $375. Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions.\n",
      "------\n",
      "NGUYEN, HUYEN THANH THI\n",
      "City: MURPHY\n",
      "County: COLLIN\n",
      "Zip Code: 75094\n",
      "\n",
      "\n",
      "License #: 789370\n",
      "\n",
      "Complaint # COS20210011311 Date: 4/26/2022\n",
      "\n",
      "Respondent is assessed an administrative penalty in the amount of $2,275. Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions; Respondent engaged in gross malpractice; Respondent failed to clean and disinfect manicure tables prior to use for each client.\n",
      "------\n"
     ]
    }
   ],
   "source": [
    "for result in results[1:11]:\n",
    "    print(result.text)\n",
    "    print('------')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Loop through each result and print each person's name\n",
    "\n",
    "You'll get an error because the first one doesn't have a name. How do you make that not happen?! If you want to ignore an error, you use code like this:\n",
    "\n",
    "```python\n",
    "try:\n",
    "   # try to do something\n",
    "except:\n",
    "   print(\"It didn't work')\n",
    "```\n",
    "\n",
    "It should help you out. If you don't want to print anything when there's an error, you can type `pass` instead of the `print` statement.\n",
    "\n",
    "**Why doesn't the first one have a name?**\n",
    "\n",
    "Output should look like this:\n",
    "\n",
    "```\n",
    "Doesn't have a name\n",
    "NGUYEN, THANH\n",
    "NGUYEN, LONG D\n",
    "NGUYEN, LUCIE HUONG\n",
    "NGUYEN, CHINH\n",
    "NGUYEN, JIMMY\n",
    "```\n",
    "\n",
    "* *Tip: The name has a class you can use. The class name is reused in a lot of places, but because it's the first one you don't have to worry about that!*\n",
    "* *Tip: Instead of searching across the entire page – `driver.find_element` or `doc.select_one` – you should be doing your searching just inside of each **row** (I used this technique in the beginning of class with BeautifulSoup when we were scraping the books page)* "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "It didn't work\n",
      "NGUYEN, MAI T\n",
      "NGUYEN, HUNG VU\n",
      "NGUYEN, MINH HIEN LUONG\n",
      "NGUYEN, PHUONG T\n",
      "NGUYEN, STEVEN MANH\n",
      "NGUYEN, LANG THU\n",
      "NGUYEN, THANH\n",
      "NGUYEN, NAM QUANG\n",
      "NGUYEN, JAY TRI\n",
      "NGUYEN, HUYEN THANH THI\n",
      "NGUYEN, MATTHEW VIET\n",
      "NGUYEN, LIEU D\n",
      "NGUYEN, OANH\n",
      "NGUYEN, KIMLIEN\n",
      "NGUYEN, JOHNNY DAT\n",
      "NGUYEN, NHO THANH\n",
      "NGUYEN, KEN\n",
      "NGUYEN, MEJ X\n",
      "NGUYEN, THI THU HUNG\n",
      "NGUYEN, LOAN HONG ANH\n",
      "NGUYEN, HONG VU\n",
      "NGUYEN, LEHUONG\n",
      "NGUYEN, HAI THANH\n",
      "NGUYEN, CHI\n",
      "NGUYEN, THY DINH MINH\n",
      "NGUYEN, KATY\n",
      "NGUYEN, HIEU V\n",
      "NGUYEN, ANNA\n",
      "NGUYEN, NGA T\n",
      "NGUYEN, THANH\n",
      "NGUYEN, DAI T\n",
      "NGUYEN, LONG D\n",
      "NGUYEN, LUCIE HUONG\n",
      "NGUYEN, CHINH\n",
      "NGUYEN, HUNG VU\n",
      "NGUYEN, JIMMY\n",
      "NGUYEN, NAM\n",
      "NGUYEN, DUC\n",
      "NGUYEN, THU THAO THI\n",
      "NGUYEN, MINH NHU\n",
      "NGUYEN, DUNG VAN\n",
      "NGUYEN, TINH\n",
      "NGUYEN, HANG NU THANH\n",
      "NGUYEN, LAN N\n",
      "NGUYEN, TIEP HUY\n",
      "NGUYEN, DUNG\n",
      "NGUYEN, THAI VAN\n",
      "NGUYEN, THI THAO UYEN\n",
      "NGUYEN, THANH TRONG\n",
      "NGUYEN, KHANH V\n",
      "NGUYEN, DUC VAN\n",
      "NGUYEN, THI HOAN CHAU\n",
      "NGUYEN, PHUCHUNG\n",
      "NGUYEN, KIM\n",
      "NGUYEN, HUE VAN\n",
      "NGUYEN, HOAI THU T\n",
      "NGUYEN, NGHIA T\n",
      "NGUYEN, HANH THI\n",
      "NGUYEN, HUYEN\n",
      "NGUYEN, CHRISTINA M\n",
      "NGUYEN, THI THIBICH\n",
      "NGUYEN, KIM AN THI\n",
      "NGUYEN, VIVIAN KIM\n",
      "NGUYEN, LONG\n",
      "NGUYEN, MAI\n",
      "NGUYEN, CHINH THI\n",
      "NGUYEN, THU HA\n",
      "NGUYEN, HA THI THU\n",
      "NGUYEN, CHAU\n",
      "NGUYEN, HUNG VU\n",
      "NGUYEN, MIMI PHAM\n",
      "NGUYEN, HA\n",
      "NGUYEN, THAO HONG\n",
      "NGUYEN, CINDY\n",
      "NGUYEN, CHAU KHANH LINH\n",
      "NGUYEN, TRANG T\n",
      "NGUYEN, DUNG MINH\n",
      "NGUYEN, YEN NHI THI\n",
      "NGUYEN, JOHNNY DAT\n",
      "NGUYEN, KELLY PHUONG N\n",
      "NGUYEN, NGA THU\n",
      "NGUYEN, IVY\n",
      "NGUYEN, DIEMTRINH T\n",
      "NGUYEN, HUAN CAO\n",
      "NGUYEN, THOA KIM\n",
      "NGUYEN, TONY\n",
      "NGUYEN, HIEN\n",
      "NGUYEN, NGOC TRAM\n",
      "NGUYEN, TRAN NAM\n",
      "NGUYEN, PHILLIP\n",
      "NGUYEN, THUY T\n",
      "NGUYEN, TRACY\n",
      "NGUYEN, LE PHUC\n",
      "NGUYEN, HAI MINH\n",
      "NGUYEN, TUYET\n",
      "NGUYEN, BA VAN\n",
      "NGUYEN, LAN THANH\n",
      "NGUYEN, PHUOC BA\n",
      "NGUYEN, LINH THUY KIEU\n",
      "NGUYEN, TONY MINH\n",
      "NGUYEN, THANH\n",
      "NGUYEN, HIEN THI MINH\n",
      "NGUYEN, VAN NGOC THAO\n",
      "NGUYEN, TAM THANH\n",
      "NGUYEN, ANDY HUU\n",
      "NGUYEN, CUONG HULL\n",
      "NGUYEN, NANCY HOA\n",
      "NGUYEN, THOA THI KIM\n",
      "NGUYEN, TRANG\n",
      "NGUYEN, THONG VAN\n",
      "NGUYEN, TUAN\n",
      "NGUYEN, LYNDA\n",
      "NGUYEN, CATHY H\n",
      "NGUYEN, PAMELA DAN\n",
      "NGUYEN, SON QUOC\n",
      "NGUYEN, KIM\n",
      "NGUYEN, THAI VAN\n",
      "NGUYEN, HANH THI\n",
      "NGUYEN, DIEP THI NGOC\n",
      "NGUYEN, CASEY\n",
      "NGUYEN, ANTHONY VAN\n",
      "NGUYEN, CHRISTINA D\n",
      "NGUYEN, PHUONG T\n",
      "NGUYEN, KENNY\n",
      "NGUYEN, THAO (MINH THAO\n",
      "NGUYEN, KENNY\n",
      "NGUYEN, BA VAN\n",
      "NGUYEN, KHUYEN THI\n",
      "NGUYEN, SON DANG\n",
      "NGUYEN, TUYEN THANH\n",
      "NGUYEN, STEVEN THAI\n",
      "NGUYEN, CY VAN\n",
      "NGUYEN, KIM NGAN THI\n"
     ]
    }
   ],
   "source": [
    "for result in results:\n",
    "    try:\n",
    "        name = result.find_elements(By.CSS_SELECTOR, \".results_text\")[0].text\n",
    "        print(name)\n",
    "    except:\n",
    "        print(\"It didn't work\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Loop through each result, printing each violation description (\"Basis for order\")\n",
    "\n",
    "Your results should look something like:\n",
    "\n",
    "```\n",
    "Doesn't have a violation\n",
    "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day, the Department is charging 2 violations; Respondent operated a cosmetology salon without the appropriate license.\n",
    "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 2 violations; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to clean and disinfect manicure tables prior to use for each client.\n",
    "...\n",
    "```\n",
    "\n",
    "> - *Tip: You'll get an error even if you're ALMOST right - which row is causing the problem?*\n",
    "> - *Tip: If you're using Selenium by itself, you can get the HTML of something by doing `.get_attribute('innerHTML')` – that way it'll look like BeautifulSoup when you print it. It might help you diagnose your issue!*\n",
    "> - *Tip: Or I guess you could just skip the one with the problem...*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "It didn't work\n",
      "Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 3 violations; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required, the Department is charging 3 violations; Respondent failed to clean and disinfect all wax pots; Respondent failed to clean diamond, carbide, natural and metal bits after each use with a brush or ultrasonic cleaner, or by immersing in acetone.\n",
      "Respondent failed to keep floors, walls, ceilings, shelves, furniture, furnishings, and fixtures clean and in good repair; Respondent failed to clean and disinfect multiple use implements after each customer; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 2 violations; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use, the Department is charging 2 violations; Respondent failed to disinfect tools, implements, and supplies with an EPA-registered disinfectant solution; Respondent failed to keep all products properly labeled in compliance with OSHA requirements.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 9 violations; Respondent failed to clean and disinfect all wax pots; Respondent failed to utilize clean and disinfected implements; Respondent failed to clean and disinfect manicure tables prior to use for each client; Respondent failed to discard buffer blocks and porous nail files when exposed to a client's broken skin and/or unhealthy nails.\n",
      "Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required.\n",
      "Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly, the Department is charging 11 violations; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 5 violations; Respondent failed to clean and disinfect all wax pots; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.\n",
      "Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions; Respondent engaged in gross malpractice; Respondent failed to clean and disinfect manicure tables prior to use for each client.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent used salon as a living, dining, or sleeping quarters; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.\n",
      "Respondent failed to clean and disinfect all wax pots; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to store in a clean, dry, debris-free environment, separate from soiled implements and materials, all cleaned and disinfected implements and materials when not in use.\n",
      "Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent performed an act or practice for which the specialty salon is not licensed.\n",
      "Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license.\n",
      "Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.\n",
      "Respondent's license was revoked upon Respondent's imprisonment in a penitentiary.\n",
      "Respondent performed or attempted to perform a practice of cosmetology without a license.\n",
      "Respondent used a prohibited implement to exfoliate and penetrate the dermis layer of the skin.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instruction; Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license.\n",
      "Respondent engaged in gross malpractice; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.\n",
      "Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions.\n",
      "Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license; Respondent failed to post the human trafficking sign; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 2 violations; Respondent failed to possess an autoclave, dry heat sterilizer or ultraviolet sanitizer; Respondent failed to clean and disinfect all wax pots, the Department is charging 2 violations; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.\n",
      "Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly; Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to remove soiled towels after use on each client.\n",
      "Respondent provided other cosmetology services while only holding a manicurist license; Respondent engaged in gross malpractice.\n",
      "Respondent failed to cooperate with the inspector in the performance of an inspection.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 8 violations; Respondent failed to clean and disinfect all wax pots.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day, the Department is charging 2 violations; Respondent operated a cosmetology salon without the appropriate license.\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to store eyelash extensions in a sealed bag or covered container and kept in a clean dry debris-free storage area.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 2 violations; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to clean and disinfect manicure tables prior to use for each client.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to clean and disinfect manicure tables prior to use for each client; Respondent failed to keep floors, walls, ceilings, shelves, furniture, furnishings, and fixtures clean and in good repair.\n",
      "Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 4 violations; Respondent failed to clean and disinfect manicure tables prior to use for each client.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to keep floors, walls, ceilings, shelves, furniture, furnishings, and fixtures clean and in good repair; Respondent failed to keep all products properly labeled in compliance with OSHA requirements; Respondent's employee failed to have a photograph attached to their license.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.\n",
      "Respondents failed to follow proper sequential cleaning and disinfecting procedures when using portable whirlpool jets; Respondents failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondents failed to maintain powdered alum, styptic powder, or a cyanoacrylate.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "Respondent performed or attempted to perform a practice of cosmetology with an expired license; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to disinfect multi-use equipment, implements, and tools prior to use on each client; Respondent failed to keep floors, walls, ceilings, shelves, furniture, furnishings, and fixtures clean and in good repair.\n",
      "Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions; Respondent failed to follow proper sequential cleaning and disinfecting procedures when using portable whirlpool jets; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to maintain powdered alum, styptic powder, or a cyanoacrylate.\n",
      "Respondent performed or attempted to perform a practice of cosmetology without a license.\n",
      "Respondents leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.\n",
      "Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day, the Department is charging two violations; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.\n",
      "Respondent allowed a licensee to perform a cosmetology service on a client with a contagious condition.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to prepare fresh disinfectant solution daily or more often as needed, for immersion of implements.\n",
      "Respondent engaged in fraud or deceit in obtaining a certificate, license, or permit.\n",
      "Respondent submitted a renewal application that made false statements regarding the Respondent's criminal history; Applicant has been convicted of a crime that was committed within 5 years of their application; Applicant has a deferred adjudication disposition which makes them unfit to hold a license.\n",
      "Respondent failed to clean their hands with soap and water or use a hand sanitizer prior to performing any cosmetology services to ensure a client health and safety.\n",
      "Respondent failed to disinfect tools, implements, and supplies with an EPA-registered disinfectant solution; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging three (3) violations; Respondent failed to keep all products properly labeled in compliance with OSHA requirements; Respondent stored chemicals in a restroom accessible to the public.\n",
      "Respondent performed or attempted to perform a practice of cosmetology without a license.\n",
      "Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions.\n",
      "Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly, the Department is charging two (2) violations; Respondent failed to follow proper sequential cleaning and disinfecting procedures when using portable whirlpool jets.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used. The Department is charging two (2) violations.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging two (2) violations; Respondent failed to properly ventilate the salon to eliminate strong odors away from the public area; Respondent failed to dispose of single use items after each use.\n",
      "Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use, Department is charging two (2) violations; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly, the Department is charging two (2) violations; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required, the Department is charging three (3) violations.\n",
      "Respondent failed to comply with an order previously issued by the Executive Director.\n",
      "Respondent performed or attempted to perform a practice of cosmetology without a license.\n",
      "Respondent failed to clean diamond, carbide, natural and metal bits after each use with a brush or ultrasonic cleaner, or by immersing in acetone; Respondent failed properly clean and sanitize the metal implements used at the Salon; Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent was in possession of bottles containing methyl methacrylate monomer.\n",
      "Respondent performed or attempted to perform a practice of cosmetology without a license.\n",
      "Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly. This constitutes two (2) violations.\n",
      "Respondent failed to clean and disinfect facial chairs and beds, including headrest, prior to providing service to each client\n",
      "Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license.\n",
      "Respondent failed properly clean and sanitize the metal implements used at the Salon; Respondent failed to have chairs made of or covered in a non-porous material so that they can be disinfected.\n",
      "Respondent failed properly clean and sanitize the metal implements used at the Salon; Respondent failed to discard single use implements after each use; Respondent failed to properly ventilate the salon to eliminate strong odors away from the public area; Respondent failed to keep all products properly labeled in compliance with OSHA requirements.\n",
      "Respondent failed properly clean and sanitize the metal implements used at the Salon; Respondent failed to disinfect tools, implements, and supplies with an EPA-registered disinfectant solution.\n",
      "Respondent failed to clean and sanitize four (4) whirlpool foot spas as required at the end of each day, constituting two (2) violations; Respondent failed to keep a record of the date and time of four (4) foot spas daily or bi-weekly cleaning and if the foot spas were not used, constituting two (2) violations.\n",
      "Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.\n",
      "Respondent failed to clean and disinfect all wax pots; Respondent failed to properly clean multi-use items prior to each service.\n",
      "Respondent engaged in fraud or deceit in obtaining a certificate, license, or permit.\n",
      "Respondent failed properly clean and sanitize the metal implements used at the Salon; Respondent failed to wipe clean and disinfect electrical equipment that cannot be immersed in the liquid prior to each use on a client.\n",
      "Respondent failed properly clean and sanitize the metal implements used at the Salon; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer; Respondent failed to store eyelash extensions in a sealed bag or covered container and kept in a clean dry debris-free storage area; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.\n",
      "Respondent failed to clean and disinfect all wax pots; Respondent failed to store in a clean, dry, debris-free environment, separate from soiled implements and materials, all cleaned and disinfected implements and materials when not in use; Respondent stored chemicals in a restroom accessible to the public; Respondent failed to keep all products properly labeled in compliance with OSHA requirements.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day - two violations.\n",
      "Respondent failed properly clean and sanitize the metal implements used at the Salon.\n",
      "Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license; Respondent failed to cooperate with the inspector in the performance of an inspection.\n",
      "Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly; Respondent failed to follow proper sequential cleaning and disinfecting procedures when using portable whirlpool jets; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.\n",
      "Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license; After each client, the following implements shall be cleaned, disinfected and sterilized or sanitized in accordance with the rule: metal pusher and files, cuticle nipper and scissors, metal tweezers, finger and toe-nail clippers, and electric drill bits.\n",
      "Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required.\n",
      "Respondent performed or attempted to perform a practice of cosmetology without a license.\n",
      "Respondent failed to clean and disinfect all wax pots.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "Respondent failed to cooperate with the inspector in the performance of an inspection.\n",
      "Respondent failed to clean diamond, carbide, natural and metal bits after each use with a brush or ultrasonic cleaner, or by immersing in acetone; Respondent failed to sweep up and deposit hair cuttings in a closed receptacle after each hair cut. Respondent failed to thoroughly clean the floors each day.\n",
      "Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed properly clean and sanitize the metal implements used at the Salon.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "Respondent failed to follow proper sequential cleaning and disinfecting procedures when using portable whirlpool jets.\n",
      "Respondent failed properly clean and sanitize the metal implements used at the Salon; Respondent failed to store in a clean, dry, debris-free environment, separate from soiled implements and materials, all cleaned and disinfected implements and materials when not in use.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "Respondent failed to follow proper sequential cleaning and disinfecting procedures when using portable whirlpool jets.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.\n",
      "Respondent failed to maintain cleaning records for whirlpool foot spas; Respondent failed to utilize the sterilizer in the salon for the purpose of sterilizing metal implements; Respondent failed to store cosmetology items in a clean and debris free environment; Respondent stored chemical supplies in the restroom.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to clean, disinfect, and sterilize all multi-use implements prior to each use.\n",
      "The Respondent's license was revoked upon Respondent's imprisonment in a penitentiary.\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent possessed an electric drill other than those specifically designed and manufactured for use in the professional nail industry.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to disinfect tools, implements, and supplies with an EPA-registered disinfectant solution.\n",
      "Respondent possessed or used a prohibited implement, specifically a blade or cutting tool intended for the purpose of removing corns or calluses.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.\n",
      "Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to disinfect the salon's whirlpool foot spa basins with an EPA-registered disinfectant.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to dispose of single use items after each use.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to keep all products properly labeled in compliance with OSHA requirements; Respondent failed to make records, on a department-approved form with the date and time the salon discarded the liners for each whirlpool foot spas.\n",
      "Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.\n",
      "Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to dispose of single use items after each use; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.\n",
      "Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required.\n",
      "Respondent failed to disinfect tools, implements, and supplies with an EPA-registered disinfectant solution; Respondent failed to store in a clean, dry, debris-free environment, separate from soiled implements and materials, all cleaned and disinfected implements and materials when not in use.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.\n",
      "Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions.\n",
      "Respondent failed to dispose of single use items after each use; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer; Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to keep all products properly labeled in compliance with OSHA requirements.\n",
      "Respondent failed to cooperate with the inspector in the performance of an inspection; Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license.\n",
      "Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license; Respondent failed to cooperate with the inspector in the performance of an inspection; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.\n",
      "Respondent failed to keep all products properly labeled in compliance with OSHA requirements; Respondent failed to disinfect tools, implements, and supplies with an EPA-registered disinfectant solution; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly.\n",
      "Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.\n",
      "Respondent operated a cosmetology salon without the appropriate license.\n",
      "Respondent interfered with a Department inspection of the salon.\n"
     ]
    }
   ],
   "source": [
    "for result in results:\n",
    "    try:\n",
    "        basis = result.find_elements(By.CSS_SELECTOR, \"td\")[-1].text\n",
    "        print(basis)\n",
    "    except:\n",
    "        print(\"It didn't work\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Loop through each result, printing the complaint number\n",
    "\n",
    "Output should look like this:\n",
    "\n",
    "```\n",
    "Doesn't have a complaint number\n",
    "COS20210004784\n",
    "COS20210009745\n",
    "COS20210011484\n",
    "...\n",
    "```\n",
    "\n",
    "- *Tip: Think about the order of the elements. Can you count from the opposite direction than you normally do?*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Doesn't have a complaint number\n",
      "COS20220000853\n",
      "COS20200013887\n",
      "COS20210010437\n",
      "COS20210014779\n",
      "COS20200015190\n",
      "COS20200008154\n",
      "COS20200007790\n",
      "COS20210010525\n",
      "COS20210015763\n",
      "COS20210011311\n",
      "COS20210003963\n",
      "COS20190017129\n",
      "COS20200010645\n",
      "COS20210012116\n",
      "COS20210011168\n",
      "COS20210014198\n",
      "COS20220008308\n",
      "COS20210010069\n",
      "COS20210011374\n",
      "COS20220001466\n",
      "COS20210015652\n",
      "COS20210015023\n",
      "COS20220001836\n",
      "COS20210010769\n",
      "COS20200012226\n",
      "COS20200006932\n",
      "COS20210010477\n",
      "COS20210005808\n",
      "COS20210008358\n",
      "COS20210004784\n",
      "COS20210005027\n",
      "COS20210009745\n",
      "COS20210011484\n",
      "COS20210011721\n",
      "COS20200006792\n",
      "COS20200007069\n",
      "COS20210010530\n",
      "COS20200007141\n",
      "COS20200000839\n",
      "COS20210009714\n",
      "COS20210005838\n",
      "COS20200010129\n",
      "COS20210003441\n",
      "COS20200009912\n",
      "COS20210004018\n",
      "COS20210000935\n",
      "COS20210003238\n",
      "COS20200005799\n",
      "COS20210004209\n",
      "COS20200012887\n",
      "COS20190014959\n",
      "COS20190011954\n",
      "COS20200016795\n",
      "COS20200016258\n",
      "COS20200017028\n",
      "COS20200016091\n",
      "COS20210001519\n",
      "COS20200012575\n",
      "COS20200007138\n",
      "COS20200010817\n",
      "COS20190012445\n",
      "COS20190010554\n",
      "COS20200009961\n",
      "COS20200011967\n",
      "COS20200007264\n",
      "COS20200009985\n",
      "COS20200014601\n",
      "COS20200015200\n",
      "COS20210002574\n",
      "COS20190011025\n",
      "COS20190010072\n",
      "COS20190016762\n",
      "COS20200010387\n",
      "COS20200010502\n",
      "COS20190008104\n",
      "COS20200010511\n",
      "COS20200004202\n",
      "COS20190004199\n",
      "COS20200000101\n",
      "COS20200011664\n",
      "COS20200010961\n",
      "COS20200008858\n",
      "COS20200008859\n",
      "COS20200009732\n",
      "COS20200006548\n",
      "COS20200009605\n",
      "COS20190016479\n",
      "COS20190012148\n",
      "COS20190010318\n",
      "COS20190014688\n",
      "COS20190004016\n",
      "COS20190016499\n",
      "COS20200006146\n",
      "COS20190016549\n",
      "COS20190017217\n",
      "COS20190016854\n",
      "COS20190017175\n",
      "COS20190013017\n",
      "COS20190016161\n",
      "COS20200000652\n",
      "COS20190007906\n",
      "COS20190003737\n",
      "COS20190006118\n",
      "COS20200002642\n",
      "COS20190009211\n",
      "COS20190010611\n",
      "COS20190010665\n",
      "COS20190001932\n",
      "COS20190014576\n",
      "COS20190001897\n",
      "COS20190009239\n",
      "COS20190009484\n",
      "COS20190010323\n",
      "COS20190011923\n",
      "COS20190005539\n",
      "COS20190010176\n",
      "COS20190010397\n",
      "COS20190011044\n",
      "COS20190003373\n",
      "COS20190010299\n",
      "COS20190013988\n",
      "COS20190012652\n",
      "COS20180015395\n",
      "COS20190010057\n",
      "COS20190010254\n",
      "COS20190000183\n",
      "COS20190010606\n",
      "COS20190010961\n",
      "COS20190010635\n",
      "COS20190014566\n",
      "COS20190010869\n",
      "COS20190007921\n",
      "COS2009004238D\n"
     ]
    }
   ],
   "source": [
    "for result in results:\n",
    "    try:\n",
    "        complaint_number = result.find_elements(By.CSS_SELECTOR, \".results_text\")[-2].text\n",
    "        print(complaint_number)\n",
    "    except:\n",
    "        print(\"Doesn't have a complaint number\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Saving the results\n",
    "\n",
    "### Loop through each result to create a list of dictionaries\n",
    "\n",
    "Each dictionary must contain\n",
    "\n",
    "- Person's name\n",
    "- Violation description\n",
    "- Violation number\n",
    "- License Numbers\n",
    "- Zip Code\n",
    "- County\n",
    "- City\n",
    "\n",
    "Create a new dictionary for each result (except the header).\n",
    "\n",
    "Based on what you print out, the output might look something like:\n",
    "\n",
    "```\n",
    "This row is broken: Name and Location Order Basis for Order\n",
    "{'name': 'NGUYEN, THANH', 'city': 'FRISCO', 'county': 'COLLIN', 'zip_code': '75034', 'complaint_no': 'COS20210004784', 'license_numbers': '790672', 'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day, the Department is charging 2 violations; Respondent operated a cosmetology salon without the appropriate license.'}\n",
    "{'name': 'NGUYEN, LONG D', 'city': 'SAN SABA', 'county': 'SAN SABA', 'zip_code': '76877', 'complaint_no': 'COS20210009745', 'license_numbers': '760420, 1620583', 'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 2 violations; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to clean and disinfect manicure tables prior to use for each client.'}\n",
    "```\n",
    "\n",
    "> *Tip: If you want to ask for the \"next sibling,\" you can't use `find_next_sibling` in Selenium, you need to use `element.find_element_by_xpath(\"following-sibling::div\")` to find the next div, or `element.find_element_by_xpath(\"following-sibling::*\")` to find the next anything."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "records = []\n",
    "items = [\"name\", \"city\", \"county\", \"zip_code\", 'complaint_no', 'license_numbers','complaint']\n",
    "\n",
    "for result in results:\n",
    "    try:\n",
    "        #\"name\", \"city\", \"county\", \"zip_code\", 'complaint_no', 'license_numbers'\n",
    "        columns = result.find_elements(By.CSS_SELECTOR, \"td\")\n",
    "        elements = columns[0].find_elements(By.CSS_SELECTOR, \".results_text\")\n",
    "        texts = [element.text for element in elements]\n",
    "\n",
    "        #'complaint'\n",
    "        texts.append(columns[-1].text)\n",
    "\n",
    "        #make a dictionary\n",
    "        record = dict(zip(items, texts))\n",
    "        records.append(record)\n",
    "    except:\n",
    "        pass\n",
    "    time.sleep(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'name': 'NGUYEN, MAI T',\n",
       "  'city': 'AUSTIN',\n",
       "  'county': 'TRAVIS',\n",
       "  'zip_code': '78717',\n",
       "  'complaint_no': '750076',\n",
       "  'license_numbers': 'COS20220000853',\n",
       "  'complaint': \"Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 3 violations; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required, the Department is charging 3 violations; Respondent failed to clean and disinfect all wax pots; Respondent failed to clean diamond, carbide, natural and metal bits after each use with a brush or ultrasonic cleaner, or by immersing in acetone.\"},\n",
       " {'name': 'NGUYEN, HUNG VU',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77086',\n",
       "  'complaint_no': '763912',\n",
       "  'license_numbers': 'COS20200013887',\n",
       "  'complaint': 'Respondent failed to keep floors, walls, ceilings, shelves, furniture, furnishings, and fixtures clean and in good repair; Respondent failed to clean and disinfect multiple use implements after each customer; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 2 violations; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use, the Department is charging 2 violations; Respondent failed to disinfect tools, implements, and supplies with an EPA-registered disinfectant solution; Respondent failed to keep all products properly labeled in compliance with OSHA requirements.'},\n",
       " {'name': 'NGUYEN, MINH HIEN LUONG',\n",
       "  'city': 'CARROLLTON',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75007',\n",
       "  'complaint_no': '777932',\n",
       "  'license_numbers': 'COS20210010437',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.'},\n",
       " {'name': 'NGUYEN, PHUONG T',\n",
       "  'city': 'PLANO',\n",
       "  'county': 'COLLIN',\n",
       "  'zip_code': '75023',\n",
       "  'complaint_no': '766293',\n",
       "  'license_numbers': 'COS20210014779',\n",
       "  'complaint': \"Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 9 violations; Respondent failed to clean and disinfect all wax pots; Respondent failed to utilize clean and disinfected implements; Respondent failed to clean and disinfect manicure tables prior to use for each client; Respondent failed to discard buffer blocks and porous nail files when exposed to a client's broken skin and/or unhealthy nails.\"},\n",
       " {'name': 'NGUYEN, STEVEN MANH',\n",
       "  'city': 'FORT WORTH',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '76244',\n",
       "  'complaint_no': '773318',\n",
       "  'license_numbers': 'COS20200015190',\n",
       "  'complaint': 'Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license.'},\n",
       " {'name': 'NGUYEN, LANG THU',\n",
       "  'city': 'ALLEN',\n",
       "  'county': 'COLLIN',\n",
       "  'zip_code': '75002',\n",
       "  'complaint_no': '744463',\n",
       "  'license_numbers': 'COS20200008154',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required.'},\n",
       " {'name': 'NGUYEN, THANH',\n",
       "  'city': 'FRISCO',\n",
       "  'county': 'COLLIN',\n",
       "  'zip_code': '75034',\n",
       "  'complaint_no': '790672',\n",
       "  'license_numbers': 'COS20200007790',\n",
       "  'complaint': 'Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly, the Department is charging 11 violations; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.'},\n",
       " {'name': 'NGUYEN, NAM QUANG',\n",
       "  'city': 'HARKER HEIGHTS',\n",
       "  'county': 'BELL',\n",
       "  'zip_code': '76548',\n",
       "  'complaint_no': '745552',\n",
       "  'license_numbers': 'COS20210010525',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 5 violations; Respondent failed to clean and disinfect all wax pots; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.'},\n",
       " {'name': 'NGUYEN, JAY TRI',\n",
       "  'city': 'SAN ANTONIO',\n",
       "  'county': 'BEXAR',\n",
       "  'zip_code': '78266',\n",
       "  'complaint_no': '735165',\n",
       "  'license_numbers': 'COS20210015763',\n",
       "  'complaint': \"Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions.\"},\n",
       " {'name': 'NGUYEN, HUYEN THANH THI',\n",
       "  'city': 'MURPHY',\n",
       "  'county': 'COLLIN',\n",
       "  'zip_code': '75094',\n",
       "  'complaint_no': '789370',\n",
       "  'license_numbers': 'COS20210011311',\n",
       "  'complaint': \"Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions; Respondent engaged in gross malpractice; Respondent failed to clean and disinfect manicure tables prior to use for each client.\"},\n",
       " {'name': 'NGUYEN, MATTHEW VIET',\n",
       "  'city': 'FORT WORTH',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '76119',\n",
       "  'complaint_no': '788863',\n",
       "  'license_numbers': 'COS20210003963',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent used salon as a living, dining, or sleeping quarters; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.'},\n",
       " {'name': 'NGUYEN, LIEU D',\n",
       "  'city': 'HUMBLE',\n",
       "  'county': '',\n",
       "  'zip_code': '77346',\n",
       "  'complaint_no': '751344',\n",
       "  'license_numbers': 'COS20190017129',\n",
       "  'complaint': 'Respondent failed to clean and disinfect all wax pots; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to store in a clean, dry, debris-free environment, separate from soiled implements and materials, all cleaned and disinfected implements and materials when not in use.'},\n",
       " {'name': 'NGUYEN, OANH',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77089',\n",
       "  'complaint_no': '688244',\n",
       "  'license_numbers': 'COS20200010645',\n",
       "  'complaint': 'Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent performed an act or practice for which the specialty salon is not licensed.'},\n",
       " {'name': 'NGUYEN, KIMLIEN',\n",
       "  'city': 'EL PASO',\n",
       "  'county': 'EL PASO',\n",
       "  'zip_code': '79936',\n",
       "  'complaint_no': '801094',\n",
       "  'license_numbers': 'COS20210012116',\n",
       "  'complaint': 'Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license.'},\n",
       " {'name': 'NGUYEN, JOHNNY DAT',\n",
       "  'city': 'MISSION',\n",
       "  'county': 'HIDALGO',\n",
       "  'zip_code': '78574',\n",
       "  'complaint_no': '797651',\n",
       "  'license_numbers': 'COS20210011168',\n",
       "  'complaint': \"Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions.\"},\n",
       " {'name': 'NGUYEN, NHO THANH',\n",
       "  'city': 'SAN ANTONIO',\n",
       "  'county': 'BEXAR',\n",
       "  'zip_code': '78258',\n",
       "  'complaint_no': '811760',\n",
       "  'license_numbers': 'COS20210014198',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.'},\n",
       " {'name': 'NGUYEN, KEN',\n",
       "  'city': 'SAN ANTONIO',\n",
       "  'county': 'BEXAR',\n",
       "  'zip_code': '78257',\n",
       "  'complaint_no': '1155193',\n",
       "  'license_numbers': 'COS20220008308',\n",
       "  'complaint': \"Respondent's license was revoked upon Respondent's imprisonment in a penitentiary.\"},\n",
       " {'name': 'NGUYEN, MEJ X',\n",
       "  'city': 'PHARR',\n",
       "  'county': 'HIDALGO',\n",
       "  'zip_code': '78577',\n",
       "  'complaint_no': 'Not Licensed',\n",
       "  'license_numbers': 'COS20210010069',\n",
       "  'complaint': 'Respondent performed or attempted to perform a practice of cosmetology without a license.'},\n",
       " {'name': 'NGUYEN, THI THU HUNG',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77072',\n",
       "  'complaint_no': '812471',\n",
       "  'license_numbers': 'COS20210011374',\n",
       "  'complaint': 'Respondent used a prohibited implement to exfoliate and penetrate the dermis layer of the skin.'},\n",
       " {'name': 'NGUYEN, LOAN HONG ANH',\n",
       "  'city': 'COCKRELL HILL',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75211',\n",
       "  'complaint_no': '757086',\n",
       "  'license_numbers': 'COS20220001466',\n",
       "  'complaint': \"Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instruction; Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license.\"},\n",
       " {'name': 'NGUYEN, HONG VU',\n",
       "  'city': 'SAN ANTONIO',\n",
       "  'county': 'BEXAR',\n",
       "  'zip_code': '78239',\n",
       "  'complaint_no': '787211',\n",
       "  'license_numbers': 'COS20210015652',\n",
       "  'complaint': \"Respondent engaged in gross malpractice; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions.\"},\n",
       " {'name': 'NGUYEN, LEHUONG',\n",
       "  'city': 'MCKINNEY',\n",
       "  'county': 'COLLIN',\n",
       "  'zip_code': '75070',\n",
       "  'complaint_no': '809601',\n",
       "  'license_numbers': 'COS20210015023',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.'},\n",
       " {'name': 'NGUYEN, HAI THANH',\n",
       "  'city': 'LAREDO',\n",
       "  'county': 'WEBB',\n",
       "  'zip_code': '78041',\n",
       "  'complaint_no': '731397',\n",
       "  'license_numbers': 'COS20220001836',\n",
       "  'complaint': \"Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions.\"},\n",
       " {'name': 'NGUYEN, CHI',\n",
       "  'city': 'AUSTIN',\n",
       "  'county': 'TRAVIS',\n",
       "  'zip_code': '78745',\n",
       "  'complaint_no': '794158',\n",
       "  'license_numbers': 'COS20210010769',\n",
       "  'complaint': 'Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license; Respondent failed to post the human trafficking sign; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.'},\n",
       " {'name': 'NGUYEN, THY DINH MINH',\n",
       "  'city': 'RICHMOND',\n",
       "  'county': 'FORT BEND',\n",
       "  'zip_code': '77407',\n",
       "  'complaint_no': '791014, 1456306',\n",
       "  'license_numbers': 'COS20200012226',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 2 violations; Respondent failed to possess an autoclave, dry heat sterilizer or ultraviolet sanitizer; Respondent failed to clean and disinfect all wax pots, the Department is charging 2 violations; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.'},\n",
       " {'name': 'NGUYEN, KATY',\n",
       "  'city': 'FORT WORTH',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '76179',\n",
       "  'complaint_no': '789080',\n",
       "  'license_numbers': 'COS20200006932',\n",
       "  'complaint': 'Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly; Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to remove soiled towels after use on each client.'},\n",
       " {'name': 'NGUYEN, HIEU V',\n",
       "  'city': 'LUBBOCK',\n",
       "  'county': 'LUBBOCK',\n",
       "  'zip_code': '79414',\n",
       "  'complaint_no': '1663432',\n",
       "  'license_numbers': 'COS20210010477',\n",
       "  'complaint': 'Respondent provided other cosmetology services while only holding a manicurist license; Respondent engaged in gross malpractice.'},\n",
       " {'name': 'NGUYEN, ANNA',\n",
       "  'city': 'PARKER',\n",
       "  'county': 'COLLIN',\n",
       "  'zip_code': '75002',\n",
       "  'complaint_no': '776928',\n",
       "  'license_numbers': 'COS20210005808',\n",
       "  'complaint': 'Respondent failed to cooperate with the inspector in the performance of an inspection.'},\n",
       " {'name': 'NGUYEN, NGA T',\n",
       "  'city': 'GRAND PRAIRIE',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '75052',\n",
       "  'complaint_no': '733215, 1758833',\n",
       "  'license_numbers': 'COS20210008358',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 8 violations; Respondent failed to clean and disinfect all wax pots.'},\n",
       " {'name': 'NGUYEN, THANH',\n",
       "  'city': 'FRISCO',\n",
       "  'county': 'COLLIN',\n",
       "  'zip_code': '75034',\n",
       "  'complaint_no': '790672',\n",
       "  'license_numbers': 'COS20210004784',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day, the Department is charging 2 violations; Respondent operated a cosmetology salon without the appropriate license.'},\n",
       " {'name': 'NGUYEN, DAI T',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'Harris',\n",
       "  'zip_code': '77034',\n",
       "  'complaint_no': '765339',\n",
       "  'license_numbers': 'COS20210005027',\n",
       "  'complaint': 'Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to store eyelash extensions in a sealed bag or covered container and kept in a clean dry debris-free storage area.'},\n",
       " {'name': 'NGUYEN, LONG D',\n",
       "  'city': 'SAN SABA',\n",
       "  'county': 'SAN SABA',\n",
       "  'zip_code': '76877',\n",
       "  'complaint_no': '760420, 1620583',\n",
       "  'license_numbers': 'COS20210009745',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 2 violations; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to clean and disinfect manicure tables prior to use for each client.'},\n",
       " {'name': 'NGUYEN, LUCIE HUONG',\n",
       "  'city': 'UVALDE',\n",
       "  'county': 'UVALDE',\n",
       "  'zip_code': '78801',\n",
       "  'complaint_no': '762626, 1811788',\n",
       "  'license_numbers': 'COS20210011484',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to clean and disinfect manicure tables prior to use for each client; Respondent failed to keep floors, walls, ceilings, shelves, furniture, furnishings, and fixtures clean and in good repair.'},\n",
       " {'name': 'NGUYEN, CHINH',\n",
       "  'city': 'TEMPLE',\n",
       "  'county': 'BELL',\n",
       "  'zip_code': '76502',\n",
       "  'complaint_no': '777067',\n",
       "  'license_numbers': 'COS20210011721',\n",
       "  'complaint': 'Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging 4 violations; Respondent failed to clean and disinfect manicure tables prior to use for each client.'},\n",
       " {'name': 'NGUYEN, HUNG VU',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77086',\n",
       "  'complaint_no': '730692',\n",
       "  'license_numbers': 'COS20200006792',\n",
       "  'complaint': \"Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to keep floors, walls, ceilings, shelves, furniture, furnishings, and fixtures clean and in good repair; Respondent failed to keep all products properly labeled in compliance with OSHA requirements; Respondent's employee failed to have a photograph attached to their license.\"},\n",
       " {'name': 'NGUYEN, JIMMY',\n",
       "  'city': 'ROWLETT',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75088',\n",
       "  'complaint_no': '796773',\n",
       "  'license_numbers': 'COS20200007069',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.'},\n",
       " {'name': 'NGUYEN, NAM',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77025',\n",
       "  'complaint_no': '688039',\n",
       "  'license_numbers': 'COS20210010530',\n",
       "  'complaint': 'Respondents failed to follow proper sequential cleaning and disinfecting procedures when using portable whirlpool jets; Respondents failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondents failed to maintain powdered alum, styptic powder, or a cyanoacrylate.'},\n",
       " {'name': 'NGUYEN, DUC',\n",
       "  'city': 'ABILENE',\n",
       "  'county': 'TAYLOR',\n",
       "  'zip_code': '79605',\n",
       "  'complaint_no': '758793',\n",
       "  'license_numbers': 'COS20200007141',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.'},\n",
       " {'name': 'NGUYEN, THU THAO THI',\n",
       "  'city': 'SAN ANTONIO',\n",
       "  'county': 'BEXAR',\n",
       "  'zip_code': '78244',\n",
       "  'complaint_no': '802892, 1286737',\n",
       "  'license_numbers': 'COS20200000839',\n",
       "  'complaint': 'Respondent performed or attempted to perform a practice of cosmetology with an expired license; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to disinfect multi-use equipment, implements, and tools prior to use on each client; Respondent failed to keep floors, walls, ceilings, shelves, furniture, furnishings, and fixtures clean and in good repair.'},\n",
       " {'name': 'NGUYEN, MINH NHU',\n",
       "  'city': 'DALLAS',\n",
       "  'county': '',\n",
       "  'zip_code': '75243',\n",
       "  'complaint_no': '766162, 1502172',\n",
       "  'license_numbers': 'COS20210009714',\n",
       "  'complaint': \"Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions; Respondent failed to follow proper sequential cleaning and disinfecting procedures when using portable whirlpool jets; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to maintain powdered alum, styptic powder, or a cyanoacrylate.\"},\n",
       " {'name': 'NGUYEN, DUNG VAN',\n",
       "  'city': 'SAULT SAINTE MARIE',\n",
       "  'county': 'OUT OF STATE',\n",
       "  'zip_code': '49783',\n",
       "  'complaint_no': '1202055',\n",
       "  'license_numbers': 'COS20210005838',\n",
       "  'complaint': 'Respondent performed or attempted to perform a practice of cosmetology without a license.'},\n",
       " {'name': 'NGUYEN, TINH',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77098',\n",
       "  'complaint_no': '652914',\n",
       "  'license_numbers': 'COS20200010129',\n",
       "  'complaint': 'Respondents leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license.'},\n",
       " {'name': 'NGUYEN, HANG NU THANH',\n",
       "  'city': 'PEARLAND',\n",
       "  'county': 'BRAZORIA',\n",
       "  'zip_code': '77584',\n",
       "  'complaint_no': '1642801, 803265, 1704165',\n",
       "  'license_numbers': 'COS20210003441',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.'},\n",
       " {'name': 'NGUYEN, LAN N',\n",
       "  'city': 'SPRING',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77379',\n",
       "  'complaint_no': '726731',\n",
       "  'license_numbers': 'COS20200009912',\n",
       "  'complaint': 'Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required.'},\n",
       " {'name': 'NGUYEN, TIEP HUY',\n",
       "  'city': 'FORT WORTH',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '76244',\n",
       "  'complaint_no': '815126',\n",
       "  'license_numbers': 'COS20210004018',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day, the Department is charging two violations; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.'},\n",
       " {'name': 'NGUYEN, DUNG',\n",
       "  'city': 'WICHITA FALLS',\n",
       "  'county': 'WICHITA',\n",
       "  'zip_code': '76310',\n",
       "  'complaint_no': '772680',\n",
       "  'license_numbers': 'COS20210000935',\n",
       "  'complaint': 'Respondent allowed a licensee to perform a cosmetology service on a client with a contagious condition.'},\n",
       " {'name': 'NGUYEN, THAI VAN',\n",
       "  'city': 'GARLAND',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75040',\n",
       "  'complaint_no': '797287, 1187211',\n",
       "  'license_numbers': 'COS20210003238',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to prepare fresh disinfectant solution daily or more often as needed, for immersion of implements.'},\n",
       " {'name': 'NGUYEN, THI THAO UYEN',\n",
       "  'city': 'CANYON',\n",
       "  'county': 'RANDALL',\n",
       "  'zip_code': '79015',\n",
       "  'complaint_no': '1791395',\n",
       "  'license_numbers': 'COS20200005799',\n",
       "  'complaint': 'Respondent engaged in fraud or deceit in obtaining a certificate, license, or permit.'},\n",
       " {'name': 'NGUYEN, THANH TRONG',\n",
       "  'city': 'GARLAND',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75042',\n",
       "  'complaint_no': '1587055',\n",
       "  'license_numbers': 'COS20210004209',\n",
       "  'complaint': \"Respondent submitted a renewal application that made false statements regarding the Respondent's criminal history; Applicant has been convicted of a crime that was committed within 5 years of their application; Applicant has a deferred adjudication disposition which makes them unfit to hold a license.\"},\n",
       " {'name': 'NGUYEN, KHANH V',\n",
       "  'city': 'LUBBOCK',\n",
       "  'county': 'LUBBOCK',\n",
       "  'zip_code': '79413',\n",
       "  'complaint_no': '790907, 1149880',\n",
       "  'license_numbers': 'COS20200012887',\n",
       "  'complaint': 'Respondent failed to clean their hands with soap and water or use a hand sanitizer prior to performing any cosmetology services to ensure a client health and safety.'},\n",
       " {'name': 'NGUYEN, DUC VAN',\n",
       "  'city': 'MCALLEN',\n",
       "  'county': 'HIDALGO',\n",
       "  'zip_code': '78504',\n",
       "  'complaint_no': '693169',\n",
       "  'license_numbers': 'COS20190014959',\n",
       "  'complaint': 'Respondent failed to disinfect tools, implements, and supplies with an EPA-registered disinfectant solution; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging three (3) violations; Respondent failed to keep all products properly labeled in compliance with OSHA requirements; Respondent stored chemicals in a restroom accessible to the public.'},\n",
       " {'name': 'NGUYEN, THI HOAN CHAU',\n",
       "  'city': 'EDINBURG',\n",
       "  'county': 'HIDALGO',\n",
       "  'zip_code': '78539',\n",
       "  'complaint_no': 'Not Licensed',\n",
       "  'license_numbers': 'COS20190011954',\n",
       "  'complaint': 'Respondent performed or attempted to perform a practice of cosmetology without a license.'},\n",
       " {'name': 'NGUYEN, PHUCHUNG',\n",
       "  'city': 'PLANO',\n",
       "  'county': 'COLLIN',\n",
       "  'zip_code': '75024',\n",
       "  'complaint_no': '686011',\n",
       "  'license_numbers': 'COS20200016795',\n",
       "  'complaint': \"Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions.\"},\n",
       " {'name': 'NGUYEN, KIM',\n",
       "  'city': 'GARLAND',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75041',\n",
       "  'complaint_no': '723732',\n",
       "  'license_numbers': 'COS20200016258',\n",
       "  'complaint': 'Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly, the Department is charging two (2) violations; Respondent failed to follow proper sequential cleaning and disinfecting procedures when using portable whirlpool jets.'},\n",
       " {'name': 'NGUYEN, HUE VAN',\n",
       "  'city': 'SAN ANTONIO',\n",
       "  'county': 'BEXAR',\n",
       "  'zip_code': '78247',\n",
       "  'complaint_no': '749391',\n",
       "  'license_numbers': 'COS20200017028',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used. The Department is charging two (2) violations.'},\n",
       " {'name': 'NGUYEN, HOAI THU T',\n",
       "  'city': 'EL PASO',\n",
       "  'county': 'EL PASO',\n",
       "  'zip_code': '79925',\n",
       "  'complaint_no': '735244',\n",
       "  'license_numbers': 'COS20200016091',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.'},\n",
       " {'name': 'NGUYEN, NGHIA T',\n",
       "  'city': 'FORT WORTH',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '76132',\n",
       "  'complaint_no': '764444',\n",
       "  'license_numbers': 'COS20210001519',\n",
       "  'complaint': \"Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions.\"},\n",
       " {'name': 'NGUYEN, HANH THI',\n",
       "  'city': 'ORANGE',\n",
       "  'county': 'ORANGE',\n",
       "  'zip_code': '77630',\n",
       "  'complaint_no': '722178',\n",
       "  'license_numbers': 'COS20200012575',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used, the Department is charging two (2) violations; Respondent failed to properly ventilate the salon to eliminate strong odors away from the public area; Respondent failed to dispose of single use items after each use.'},\n",
       " {'name': 'NGUYEN, HUYEN',\n",
       "  'city': 'DALLAS',\n",
       "  'county': 'Dallas',\n",
       "  'zip_code': '75231',\n",
       "  'complaint_no': '686742',\n",
       "  'license_numbers': 'COS20200007138',\n",
       "  'complaint': 'Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use, Department is charging two (2) violations; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly, the Department is charging two (2) violations; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required, the Department is charging three (3) violations.'},\n",
       " {'name': 'NGUYEN, CHRISTINA M',\n",
       "  'city': 'MIDLAND',\n",
       "  'county': 'MIDLAND',\n",
       "  'zip_code': '79707',\n",
       "  'complaint_no': '1522245, 772915',\n",
       "  'license_numbers': 'COS20200010817',\n",
       "  'complaint': 'Respondent failed to comply with an order previously issued by the Executive Director.'},\n",
       " {'name': 'NGUYEN, THI THIBICH',\n",
       "  'city': 'CORPUS CHRISTI',\n",
       "  'county': 'NUECES',\n",
       "  'zip_code': '78415',\n",
       "  'complaint_no': '737160',\n",
       "  'license_numbers': 'COS20190012445',\n",
       "  'complaint': 'Respondent performed or attempted to perform a practice of cosmetology without a license.'},\n",
       " {'name': 'NGUYEN, KIM AN THI',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77008',\n",
       "  'complaint_no': '739743',\n",
       "  'license_numbers': 'COS20190010554',\n",
       "  'complaint': 'Respondent failed to clean diamond, carbide, natural and metal bits after each use with a brush or ultrasonic cleaner, or by immersing in acetone; Respondent failed properly clean and sanitize the metal implements used at the Salon; Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.'},\n",
       " {'name': 'NGUYEN, VIVIAN KIM',\n",
       "  'city': 'EL PASO',\n",
       "  'county': 'EL PASO',\n",
       "  'zip_code': '79936',\n",
       "  'complaint_no': '805192',\n",
       "  'license_numbers': 'COS20200009961',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent was in possession of bottles containing methyl methacrylate monomer.'},\n",
       " {'name': 'NGUYEN, LONG',\n",
       "  'city': 'ARLINGTON',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '76002',\n",
       "  'complaint_no': 'Not Licensed',\n",
       "  'license_numbers': 'COS20200011967',\n",
       "  'complaint': 'Respondent performed or attempted to perform a practice of cosmetology without a license.'},\n",
       " {'name': 'NGUYEN, MAI',\n",
       "  'city': 'MESQUITE',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75150',\n",
       "  'complaint_no': '687294',\n",
       "  'license_numbers': 'COS20200007264',\n",
       "  'complaint': 'Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly'},\n",
       " {'name': 'NGUYEN, CHINH THI',\n",
       "  'city': 'RICHARDSON',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75082',\n",
       "  'complaint_no': '766787',\n",
       "  'license_numbers': 'COS20200009985',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly. This constitutes two (2) violations.'},\n",
       " {'name': 'NGUYEN, THU HA',\n",
       "  'city': 'BONHAM',\n",
       "  'county': 'FANNIN',\n",
       "  'zip_code': '75418',\n",
       "  'complaint_no': '789513',\n",
       "  'license_numbers': 'COS20200014601',\n",
       "  'complaint': 'Respondent failed to clean and disinfect facial chairs and beds, including headrest, prior to providing service to each client'},\n",
       " {'name': 'NGUYEN, HA THI THU',\n",
       "  'city': 'DICKINSON',\n",
       "  'county': 'GALVESTON',\n",
       "  'zip_code': '77539',\n",
       "  'complaint_no': '784491',\n",
       "  'license_numbers': 'COS20200015200',\n",
       "  'complaint': 'Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license.'},\n",
       " {'name': 'NGUYEN, CHAU',\n",
       "  'city': 'LEWISVILLE',\n",
       "  'county': 'DENTON',\n",
       "  'zip_code': '75056',\n",
       "  'complaint_no': '777577',\n",
       "  'license_numbers': 'COS20210002574',\n",
       "  'complaint': 'Respondent failed properly clean and sanitize the metal implements used at the Salon; Respondent failed to have chairs made of or covered in a non-porous material so that they can be disinfected.'},\n",
       " {'name': 'NGUYEN, HUNG VU',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77086',\n",
       "  'complaint_no': '730692',\n",
       "  'license_numbers': 'COS20190011025',\n",
       "  'complaint': 'Respondent failed properly clean and sanitize the metal implements used at the Salon; Respondent failed to discard single use implements after each use; Respondent failed to properly ventilate the salon to eliminate strong odors away from the public area; Respondent failed to keep all products properly labeled in compliance with OSHA requirements.'},\n",
       " {'name': 'NGUYEN, MIMI PHAM',\n",
       "  'city': 'KATY',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77449',\n",
       "  'complaint_no': '784210',\n",
       "  'license_numbers': 'COS20190010072',\n",
       "  'complaint': 'Respondent failed properly clean and sanitize the metal implements used at the Salon; Respondent failed to disinfect tools, implements, and supplies with an EPA-registered disinfectant solution.'},\n",
       " {'name': 'NGUYEN, HA',\n",
       "  'city': 'ARLINGTON',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '76017',\n",
       "  'complaint_no': '764888',\n",
       "  'license_numbers': 'COS20190016762',\n",
       "  'complaint': 'Respondent failed to clean and sanitize four (4) whirlpool foot spas as required at the end of each day, constituting two (2) violations; Respondent failed to keep a record of the date and time of four (4) foot spas daily or bi-weekly cleaning and if the foot spas were not used, constituting two (2) violations.'},\n",
       " {'name': 'NGUYEN, THAO HONG',\n",
       "  'city': 'SAN ANTONIO',\n",
       "  'county': 'BEXAR',\n",
       "  'zip_code': '78238',\n",
       "  'complaint_no': '799926, 1753491',\n",
       "  'license_numbers': 'COS20200010387',\n",
       "  'complaint': 'Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.'},\n",
       " {'name': 'NGUYEN, CINDY',\n",
       "  'city': 'CORPUS CHRISTI',\n",
       "  'county': 'NUECES',\n",
       "  'zip_code': '78414',\n",
       "  'complaint_no': '806232, 1260359, 1280071',\n",
       "  'license_numbers': 'COS20200010502',\n",
       "  'complaint': 'Respondent failed to clean and disinfect all wax pots; Respondent failed to properly clean multi-use items prior to each service.'},\n",
       " {'name': 'NGUYEN, CHAU KHANH LINH',\n",
       "  'city': 'MONTGOMERY',\n",
       "  'county': 'OUT OF STATE',\n",
       "  'zip_code': '36116',\n",
       "  'complaint_no': '1764073',\n",
       "  'license_numbers': 'COS20190008104',\n",
       "  'complaint': 'Respondent engaged in fraud or deceit in obtaining a certificate, license, or permit.'},\n",
       " {'name': 'NGUYEN, TRANG T',\n",
       "  'city': 'SEGUIN',\n",
       "  'county': 'GUADALUPE',\n",
       "  'zip_code': '78155',\n",
       "  'complaint_no': '748483',\n",
       "  'license_numbers': 'COS20200010511',\n",
       "  'complaint': 'Respondent failed properly clean and sanitize the metal implements used at the Salon; Respondent failed to wipe clean and disinfect electrical equipment that cannot be immersed in the liquid prior to each use on a client.'},\n",
       " {'name': 'NGUYEN, DUNG MINH',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77066',\n",
       "  'complaint_no': '785878',\n",
       "  'license_numbers': 'COS20200004202',\n",
       "  'complaint': 'Respondent failed properly clean and sanitize the metal implements used at the Salon; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer; Respondent failed to store eyelash extensions in a sealed bag or covered container and kept in a clean dry debris-free storage area; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.'},\n",
       " {'name': 'NGUYEN, YEN NHI THI',\n",
       "  'city': 'AUSTIN',\n",
       "  'county': 'TRAVIS',\n",
       "  'zip_code': '78717',\n",
       "  'complaint_no': '763645',\n",
       "  'license_numbers': 'COS20190004199',\n",
       "  'complaint': 'Respondent failed to clean and disinfect all wax pots; Respondent failed to store in a clean, dry, debris-free environment, separate from soiled implements and materials, all cleaned and disinfected implements and materials when not in use; Respondent stored chemicals in a restroom accessible to the public; Respondent failed to keep all products properly labeled in compliance with OSHA requirements.'},\n",
       " {'name': 'NGUYEN, JOHNNY DAT',\n",
       "  'city': 'MISSION',\n",
       "  'county': 'HIDALGO',\n",
       "  'zip_code': '78574',\n",
       "  'complaint_no': '797651',\n",
       "  'license_numbers': 'COS20200000101',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day - two violations.'},\n",
       " {'name': 'NGUYEN, KELLY PHUONG N',\n",
       "  'city': 'CORPUS CHRISTI',\n",
       "  'county': 'NUECES',\n",
       "  'zip_code': '78413',\n",
       "  'complaint_no': '751553',\n",
       "  'license_numbers': 'COS20200011664',\n",
       "  'complaint': 'Respondent failed properly clean and sanitize the metal implements used at the Salon.'},\n",
       " {'name': 'NGUYEN, NGA THU',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77038',\n",
       "  'complaint_no': '737176',\n",
       "  'license_numbers': 'COS20200010961',\n",
       "  'complaint': 'Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license; Respondent failed to cooperate with the inspector in the performance of an inspection.'},\n",
       " {'name': 'NGUYEN, IVY',\n",
       "  'city': 'SHERMAN',\n",
       "  'county': 'GRAYSON',\n",
       "  'zip_code': '75092',\n",
       "  'complaint_no': '772886',\n",
       "  'license_numbers': 'COS20200008858',\n",
       "  'complaint': 'Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly; Respondent failed to follow proper sequential cleaning and disinfecting procedures when using portable whirlpool jets; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer.'},\n",
       " {'name': 'NGUYEN, DIEMTRINH T',\n",
       "  'city': 'CARROLLTON',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75010',\n",
       "  'complaint_no': '736591',\n",
       "  'license_numbers': 'COS20200008859',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.'},\n",
       " {'name': 'NGUYEN, HUAN CAO',\n",
       "  'city': 'SAN ANTONIO',\n",
       "  'county': 'BEXAR',\n",
       "  'zip_code': '78229',\n",
       "  'complaint_no': '786237',\n",
       "  'license_numbers': 'COS20200009732',\n",
       "  'complaint': 'Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license; After each client, the following implements shall be cleaned, disinfected and sterilized or sanitized in accordance with the rule: metal pusher and files, cuticle nipper and scissors, metal tweezers, finger and toe-nail clippers, and electric drill bits.'},\n",
       " {'name': 'NGUYEN, THOA KIM',\n",
       "  'city': 'CORPUS CHRISTI',\n",
       "  'county': 'NUECES',\n",
       "  'zip_code': '78413',\n",
       "  'complaint_no': '758361',\n",
       "  'license_numbers': 'COS20200006548',\n",
       "  'complaint': 'Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required.'},\n",
       " {'name': 'NGUYEN, TONY',\n",
       "  'city': 'MARBLE FALLS',\n",
       "  'county': 'BURNET',\n",
       "  'zip_code': '78654',\n",
       "  'complaint_no': 'Not Licensed',\n",
       "  'license_numbers': 'COS20200009605',\n",
       "  'complaint': 'Respondent performed or attempted to perform a practice of cosmetology without a license.'},\n",
       " {'name': 'NGUYEN, HIEN',\n",
       "  'city': 'LONGVIEW',\n",
       "  'county': 'GREGG',\n",
       "  'zip_code': '75605',\n",
       "  'complaint_no': '801727',\n",
       "  'license_numbers': 'COS20190016479',\n",
       "  'complaint': 'Respondent failed to clean and disinfect all wax pots.'},\n",
       " {'name': 'NGUYEN, NGOC TRAM',\n",
       "  'city': 'FORT WORTH',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '76137',\n",
       "  'complaint_no': '712767',\n",
       "  'license_numbers': 'COS20190012148',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.'},\n",
       " {'name': 'NGUYEN, TRAN NAM',\n",
       "  'city': 'CANYON',\n",
       "  'county': 'RANDALL',\n",
       "  'zip_code': '79015',\n",
       "  'complaint_no': '733729',\n",
       "  'license_numbers': 'COS20190010318',\n",
       "  'complaint': 'Respondent failed to cooperate with the inspector in the performance of an inspection.'},\n",
       " {'name': 'NGUYEN, PHILLIP',\n",
       "  'city': 'EL PASO',\n",
       "  'county': 'EL PASO',\n",
       "  'zip_code': '79912',\n",
       "  'complaint_no': '692372',\n",
       "  'license_numbers': 'COS20190014688',\n",
       "  'complaint': 'Respondent failed to clean diamond, carbide, natural and metal bits after each use with a brush or ultrasonic cleaner, or by immersing in acetone; Respondent failed to sweep up and deposit hair cuttings in a closed receptacle after each hair cut. Respondent failed to thoroughly clean the floors each day.'},\n",
       " {'name': 'NGUYEN, THUY T',\n",
       "  'city': 'CARROLLTON',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75007',\n",
       "  'complaint_no': '794091',\n",
       "  'license_numbers': 'COS20190004016',\n",
       "  'complaint': 'Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed properly clean and sanitize the metal implements used at the Salon.'},\n",
       " {'name': 'NGUYEN, TRACY',\n",
       "  'city': 'FORT WORTH',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '76137',\n",
       "  'complaint_no': '746762',\n",
       "  'license_numbers': 'COS20190016499',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.'},\n",
       " {'name': 'NGUYEN, LE PHUC',\n",
       "  'city': 'SACHSE',\n",
       "  'county': 'COLLIN',\n",
       "  'zip_code': '75048',\n",
       "  'complaint_no': '739879',\n",
       "  'license_numbers': 'COS20200006146',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.'},\n",
       " {'name': 'NGUYEN, HAI MINH',\n",
       "  'city': 'EL PASO',\n",
       "  'county': 'EL PASO',\n",
       "  'zip_code': '79936',\n",
       "  'complaint_no': '726039, 1110890',\n",
       "  'license_numbers': 'COS20190016549',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.'},\n",
       " {'name': 'NGUYEN, TUYET',\n",
       "  'city': 'GRAND PRAIRIE',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75052',\n",
       "  'complaint_no': '774330, 1658860',\n",
       "  'license_numbers': 'COS20190017217',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.'},\n",
       " {'name': 'NGUYEN, BA VAN',\n",
       "  'city': 'ARLINGTON',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '76001',\n",
       "  'complaint_no': '676940',\n",
       "  'license_numbers': 'COS20190016854',\n",
       "  'complaint': 'Respondent failed to follow proper sequential cleaning and disinfecting procedures when using portable whirlpool jets.'},\n",
       " {'name': 'NGUYEN, LAN THANH',\n",
       "  'city': 'DALLAS',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75216',\n",
       "  'complaint_no': '766697',\n",
       "  'license_numbers': 'COS20190017175',\n",
       "  'complaint': 'Respondent failed properly clean and sanitize the metal implements used at the Salon; Respondent failed to store in a clean, dry, debris-free environment, separate from soiled implements and materials, all cleaned and disinfected implements and materials when not in use.'},\n",
       " {'name': 'NGUYEN, PHUOC BA',\n",
       "  'city': 'SAN ANTONIO',\n",
       "  'county': 'BEXAR',\n",
       "  'zip_code': '78250',\n",
       "  'complaint_no': '788725, 1552617',\n",
       "  'license_numbers': 'COS20190013017',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.'},\n",
       " {'name': 'NGUYEN, LINH THUY KIEU',\n",
       "  'city': 'GARLAND',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75044',\n",
       "  'complaint_no': '795480, 1700076',\n",
       "  'license_numbers': 'COS20190016161',\n",
       "  'complaint': 'Respondent failed to follow proper sequential cleaning and disinfecting procedures when using portable whirlpool jets.'},\n",
       " {'name': 'NGUYEN, TONY MINH',\n",
       "  'city': 'MARBLE FALLS',\n",
       "  'county': 'BURNET',\n",
       "  'zip_code': '78654',\n",
       "  'complaint_no': '791638, 1124706',\n",
       "  'license_numbers': 'COS20200000652',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.'},\n",
       " {'name': 'NGUYEN, THANH',\n",
       "  'city': 'FRISCO',\n",
       "  'county': 'COLLIN',\n",
       "  'zip_code': '75034',\n",
       "  'complaint_no': '790672',\n",
       "  'license_numbers': 'COS20190007906',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.'},\n",
       " {'name': 'NGUYEN, HIEN THI MINH',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77083',\n",
       "  'complaint_no': '795179',\n",
       "  'license_numbers': 'COS20190003737',\n",
       "  'complaint': 'Respondent failed to maintain cleaning records for whirlpool foot spas; Respondent failed to utilize the sterilizer in the salon for the purpose of sterilizing metal implements; Respondent failed to store cosmetology items in a clean and debris free environment; Respondent stored chemical supplies in the restroom.'},\n",
       " {'name': 'NGUYEN, VAN NGOC THAO',\n",
       "  'city': 'WAXAHACHIE',\n",
       "  'county': 'ELLIS',\n",
       "  'zip_code': '75165',\n",
       "  'complaint_no': 'Not Licensed',\n",
       "  'license_numbers': 'COS20190006118',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to clean, disinfect, and sterilize all multi-use implements prior to each use.'},\n",
       " {'name': 'NGUYEN, TAM THANH',\n",
       "  'city': 'SAN ANGELO',\n",
       "  'county': 'TOM GREEN',\n",
       "  'zip_code': '76904',\n",
       "  'complaint_no': '1163702',\n",
       "  'license_numbers': 'COS20200002642',\n",
       "  'complaint': \"The Respondent's license was revoked upon Respondent's imprisonment in a penitentiary.\"},\n",
       " {'name': 'NGUYEN, ANDY HUU',\n",
       "  'city': 'HURST',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '76053',\n",
       "  'complaint_no': '776906, 1189873',\n",
       "  'license_numbers': 'COS20190009211',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly.'},\n",
       " {'name': 'NGUYEN, CUONG HULL',\n",
       "  'city': 'GRAND PRAIRIE',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '75052',\n",
       "  'complaint_no': '767705, 1094245',\n",
       "  'license_numbers': 'COS20190010611',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.'},\n",
       " {'name': 'NGUYEN, NANCY HOA',\n",
       "  'city': 'GARLAND',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75044',\n",
       "  'complaint_no': '785647, 1121812',\n",
       "  'license_numbers': 'COS20190010665',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent possessed an electric drill other than those specifically designed and manufactured for use in the professional nail industry.'},\n",
       " {'name': 'NGUYEN, THOA THI KIM',\n",
       "  'city': 'CORPUS CHRISTI',\n",
       "  'county': 'NUECES',\n",
       "  'zip_code': '78411',\n",
       "  'complaint_no': '739510',\n",
       "  'license_numbers': 'COS20190001932',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to disinfect tools, implements, and supplies with an EPA-registered disinfectant solution.'},\n",
       " {'name': 'NGUYEN, TRANG',\n",
       "  'city': 'GARLAND',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75041',\n",
       "  'complaint_no': '693311',\n",
       "  'license_numbers': 'COS20190014576',\n",
       "  'complaint': 'Respondent possessed or used a prohibited implement, specifically a blade or cutting tool intended for the purpose of removing corns or calluses.'},\n",
       " {'name': 'NGUYEN, THONG VAN',\n",
       "  'city': 'EL PASO',\n",
       "  'county': 'EL PASO',\n",
       "  'zip_code': '79912',\n",
       "  'complaint_no': '750663',\n",
       "  'license_numbers': 'COS20190001897',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.'},\n",
       " {'name': 'NGUYEN, TUAN',\n",
       "  'city': 'DALLAS',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75237',\n",
       "  'complaint_no': '783281',\n",
       "  'license_numbers': 'COS20190009239',\n",
       "  'complaint': \"Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required; Respondent failed to disinfect the salon's whirlpool foot spa basins with an EPA-registered disinfectant.\"},\n",
       " {'name': 'NGUYEN, LYNDA',\n",
       "  'city': 'KATY',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77449',\n",
       "  'complaint_no': '781789',\n",
       "  'license_numbers': 'COS20190009484',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to dispose of single use items after each use.'},\n",
       " {'name': 'NGUYEN, CATHY H',\n",
       "  'city': 'ROUND ROCK',\n",
       "  'county': 'WILLIAMSON',\n",
       "  'zip_code': '78665',\n",
       "  'complaint_no': 'NGUYEN, JOHNNY VAN',\n",
       "  'license_numbers': 'ROUND ROCK',\n",
       "  'complaint': 'WILLIAMSON'},\n",
       " {'name': 'NGUYEN, PAMELA DAN',\n",
       "  'city': 'SEGUIN',\n",
       "  'county': 'GUADALUPE',\n",
       "  'zip_code': '78155',\n",
       "  'complaint_no': '747589',\n",
       "  'license_numbers': 'COS20190011923',\n",
       "  'complaint': 'Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use; Respondent failed to keep all products properly labeled in compliance with OSHA requirements; Respondent failed to make records, on a department-approved form with the date and time the salon discarded the liners for each whirlpool foot spas.'},\n",
       " {'name': 'NGUYEN, SON QUOC',\n",
       "  'city': 'HILLSBORO',\n",
       "  'county': 'HILL',\n",
       "  'zip_code': '76645',\n",
       "  'complaint_no': '772305, 1240974',\n",
       "  'license_numbers': 'COS20190005539',\n",
       "  'complaint': 'Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.'},\n",
       " {'name': 'NGUYEN, KIM',\n",
       "  'city': 'DALLAS',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75240',\n",
       "  'complaint_no': '786602',\n",
       "  'license_numbers': 'COS20190010176',\n",
       "  'complaint': 'Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.'},\n",
       " {'name': 'NGUYEN, THAI VAN',\n",
       "  'city': 'GARLAND',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75040',\n",
       "  'complaint_no': '797287, 1187211',\n",
       "  'license_numbers': 'COS20190010397',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to dispose of single use items after each use; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.'},\n",
       " {'name': 'NGUYEN, HANH THI',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77049',\n",
       "  'complaint_no': '786707',\n",
       "  'license_numbers': 'COS20190011044',\n",
       "  'complaint': 'Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required.'},\n",
       " {'name': 'NGUYEN, DIEP THI NGOC',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77067',\n",
       "  'complaint_no': '760528',\n",
       "  'license_numbers': 'COS20190003373',\n",
       "  'complaint': 'Respondent failed to disinfect tools, implements, and supplies with an EPA-registered disinfectant solution; Respondent failed to store in a clean, dry, debris-free environment, separate from soiled implements and materials, all cleaned and disinfected implements and materials when not in use.'},\n",
       " {'name': 'NGUYEN, CASEY',\n",
       "  'city': 'CYPRESS',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77429',\n",
       "  'complaint_no': '790137',\n",
       "  'license_numbers': 'COS20190010299',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.'},\n",
       " {'name': 'NGUYEN, ANTHONY VAN',\n",
       "  'city': 'HALTOM CITY',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '76117',\n",
       "  'complaint_no': '750159',\n",
       "  'license_numbers': 'COS20190013988',\n",
       "  'complaint': \"Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer in accordance with the sterilizer or sanitizers manufacturer's instructions.\"},\n",
       " {'name': 'NGUYEN, CHRISTINA D',\n",
       "  'city': 'PORT ARTHUR',\n",
       "  'county': 'JEFFERSON',\n",
       "  'zip_code': '77642',\n",
       "  'complaint_no': '716740',\n",
       "  'license_numbers': 'COS20190012652',\n",
       "  'complaint': 'Respondent failed to dispose of single use items after each use; Respondent failed to clean, disinfect, and sterilize metal instruments with a Department-approved sterilizer; Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.'},\n",
       " {'name': 'NGUYEN, PHUONG T',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77083',\n",
       "  'complaint_no': '748459',\n",
       "  'license_numbers': 'COS20180015395',\n",
       "  'complaint': 'Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to keep all products properly labeled in compliance with OSHA requirements.'},\n",
       " {'name': 'NGUYEN, KENNY',\n",
       "  'city': 'DALLAS',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75232',\n",
       "  'complaint_no': '75611',\n",
       "  'license_numbers': 'COS20190010057',\n",
       "  'complaint': 'Respondent failed to cooperate with the inspector in the performance of an inspection; Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license.'},\n",
       " {'name': 'NGUYEN, THAO (MINH THAO',\n",
       "  'city': 'LOCKHART',\n",
       "  'county': 'CALDWELL',\n",
       "  'zip_code': '78644',\n",
       "  'complaint_no': '785264',\n",
       "  'license_numbers': 'COS20190010254',\n",
       "  'complaint': 'Respondent leased space in a salon to an individual who engaged in the practice of cosmetology but had not obtained a cosmetology license; Respondent failed to cooperate with the inspector in the performance of an inspection; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used.'},\n",
       " {'name': 'NGUYEN, KENNY',\n",
       "  'city': 'DALLAS',\n",
       "  'county': 'DALLAS',\n",
       "  'zip_code': '75232',\n",
       "  'complaint_no': '756711',\n",
       "  'license_numbers': 'COS20190000183',\n",
       "  'complaint': 'Respondent failed to keep all products properly labeled in compliance with OSHA requirements; Respondent failed to disinfect tools, implements, and supplies with an EPA-registered disinfectant solution; Respondent failed to keep a record of the date and time of each foot spa daily or bi-weekly cleaning and if the foot spa was not used; Respondent failed to clean, disinfect, and sterilize manicure and pedicure implements after each use.'},\n",
       " {'name': 'NGUYEN, BA VAN',\n",
       "  'city': 'MANSFIELD',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '76063',\n",
       "  'complaint_no': '720112',\n",
       "  'license_numbers': 'COS20190010606',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.'},\n",
       " {'name': 'NGUYEN, KHUYEN THI',\n",
       "  'city': 'HALTOM CITY',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '76117',\n",
       "  'complaint_no': '771681, 1442799',\n",
       "  'license_numbers': 'COS20190010961',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.'},\n",
       " {'name': 'NGUYEN, SON DANG',\n",
       "  'city': 'FOREST HILL',\n",
       "  'county': 'TARRANT',\n",
       "  'zip_code': '76119',\n",
       "  'complaint_no': '720091, 1195752',\n",
       "  'license_numbers': 'COS20190010635',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.'},\n",
       " {'name': 'NGUYEN, TUYEN THANH',\n",
       "  'city': 'AUBREY',\n",
       "  'county': 'DENTON',\n",
       "  'zip_code': '76227',\n",
       "  'complaint_no': '792178, 1468619, 1410422',\n",
       "  'license_numbers': 'COS20190014566',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day; Respondent failed to follow whirlpool foot spas cleaning and sanitization procedures as required bi-weekly.'},\n",
       " {'name': 'NGUYEN, STEVEN THAI',\n",
       "  'city': 'CORSICANA',\n",
       "  'county': 'NAVARRO',\n",
       "  'zip_code': '75110',\n",
       "  'complaint_no': '779635',\n",
       "  'license_numbers': 'COS20190010869',\n",
       "  'complaint': 'Respondent failed to clean and sanitize whirlpool foot spas as required at the end of each day.'},\n",
       " {'name': 'NGUYEN, CY VAN',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77007',\n",
       "  'complaint_no': '765590',\n",
       "  'license_numbers': 'COS20190007921',\n",
       "  'complaint': 'Respondent operated a cosmetology salon without the appropriate license.'},\n",
       " {'name': 'NGUYEN, KIM NGAN THI',\n",
       "  'city': 'HOUSTON',\n",
       "  'county': 'HARRIS',\n",
       "  'zip_code': '77084',\n",
       "  'complaint_no': '1434311',\n",
       "  'license_numbers': 'COS2009004238D',\n",
       "  'complaint': 'Respondent interfered with a Department inspection of the salon.'}]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "records"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Save that to a CSV named `output.csv`\n",
    "\n",
    "The dataframe should look something like...\n",
    "\n",
    "|index|name|city|county|zip_code|complaint_no|license_numbers|complaint|\n",
    "|---|---|---|---|---|---|---|---|\n",
    "|0|NGUYEN, THANH|FRISCO|COLLIN|75034|COS20210004784|790672|Respondent failed to clean and sanitize whirlp...|\n",
    "|1|NGUYEN, LONG D|SAN SABA|SAN SABA|76877|COS20210009745|760420, 1620583|Respondent failed to keep a record of the date...|\n",
    "\n",
    "\n",
    "- *Tip: If you send a list of dictionaries to `pd.DataFrame(...)`, it will create a dataframe out of that list!*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>city</th>\n",
       "      <th>county</th>\n",
       "      <th>zip_code</th>\n",
       "      <th>complaint_no</th>\n",
       "      <th>license_numbers</th>\n",
       "      <th>complaint</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NGUYEN, MAI T</td>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>TRAVIS</td>\n",
       "      <td>78717</td>\n",
       "      <td>750076</td>\n",
       "      <td>COS20220000853</td>\n",
       "      <td>Respondent failed to clean, disinfect, and ste...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NGUYEN, HUNG VU</td>\n",
       "      <td>HOUSTON</td>\n",
       "      <td>HARRIS</td>\n",
       "      <td>77086</td>\n",
       "      <td>763912</td>\n",
       "      <td>COS20200013887</td>\n",
       "      <td>Respondent failed to keep floors, walls, ceili...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NGUYEN, MINH HIEN LUONG</td>\n",
       "      <td>CARROLLTON</td>\n",
       "      <td>DALLAS</td>\n",
       "      <td>75007</td>\n",
       "      <td>777932</td>\n",
       "      <td>COS20210010437</td>\n",
       "      <td>Respondent failed to clean and sanitize whirlp...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NGUYEN, PHUONG T</td>\n",
       "      <td>PLANO</td>\n",
       "      <td>COLLIN</td>\n",
       "      <td>75023</td>\n",
       "      <td>766293</td>\n",
       "      <td>COS20210014779</td>\n",
       "      <td>Respondent failed to keep a record of the date...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NGUYEN, STEVEN MANH</td>\n",
       "      <td>FORT WORTH</td>\n",
       "      <td>TARRANT</td>\n",
       "      <td>76244</td>\n",
       "      <td>773318</td>\n",
       "      <td>COS20200015190</td>\n",
       "      <td>Respondent leased space in a salon to an indiv...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      name        city   county zip_code complaint_no  \\\n",
       "0            NGUYEN, MAI T      AUSTIN   TRAVIS    78717       750076   \n",
       "1          NGUYEN, HUNG VU     HOUSTON   HARRIS    77086       763912   \n",
       "2  NGUYEN, MINH HIEN LUONG  CARROLLTON   DALLAS    75007       777932   \n",
       "3         NGUYEN, PHUONG T       PLANO   COLLIN    75023       766293   \n",
       "4      NGUYEN, STEVEN MANH  FORT WORTH  TARRANT    76244       773318   \n",
       "\n",
       "  license_numbers                                          complaint  \n",
       "0  COS20220000853  Respondent failed to clean, disinfect, and ste...  \n",
       "1  COS20200013887  Respondent failed to keep floors, walls, ceili...  \n",
       "2  COS20210010437  Respondent failed to clean and sanitize whirlp...  \n",
       "3  COS20210014779  Respondent failed to keep a record of the date...  \n",
       "4  COS20200015190  Respondent leased space in a salon to an indiv...  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(records)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"output.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Open the CSV file and examine the first few. Make sure you didn't save an extra weird unnamed column."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>city</th>\n",
       "      <th>county</th>\n",
       "      <th>zip_code</th>\n",
       "      <th>complaint_no</th>\n",
       "      <th>license_numbers</th>\n",
       "      <th>complaint</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NGUYEN, MAI T</td>\n",
       "      <td>AUSTIN</td>\n",
       "      <td>TRAVIS</td>\n",
       "      <td>78717</td>\n",
       "      <td>750076</td>\n",
       "      <td>COS20220000853</td>\n",
       "      <td>Respondent failed to clean, disinfect, and ste...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NGUYEN, HUNG VU</td>\n",
       "      <td>HOUSTON</td>\n",
       "      <td>HARRIS</td>\n",
       "      <td>77086</td>\n",
       "      <td>763912</td>\n",
       "      <td>COS20200013887</td>\n",
       "      <td>Respondent failed to keep floors, walls, ceili...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NGUYEN, MINH HIEN LUONG</td>\n",
       "      <td>CARROLLTON</td>\n",
       "      <td>DALLAS</td>\n",
       "      <td>75007</td>\n",
       "      <td>777932</td>\n",
       "      <td>COS20210010437</td>\n",
       "      <td>Respondent failed to clean and sanitize whirlp...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NGUYEN, PHUONG T</td>\n",
       "      <td>PLANO</td>\n",
       "      <td>COLLIN</td>\n",
       "      <td>75023</td>\n",
       "      <td>766293</td>\n",
       "      <td>COS20210014779</td>\n",
       "      <td>Respondent failed to keep a record of the date...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NGUYEN, STEVEN MANH</td>\n",
       "      <td>FORT WORTH</td>\n",
       "      <td>TARRANT</td>\n",
       "      <td>76244</td>\n",
       "      <td>773318</td>\n",
       "      <td>COS20200015190</td>\n",
       "      <td>Respondent leased space in a salon to an indiv...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      name        city   county  zip_code complaint_no  \\\n",
       "0            NGUYEN, MAI T      AUSTIN   TRAVIS     78717       750076   \n",
       "1          NGUYEN, HUNG VU     HOUSTON   HARRIS     77086       763912   \n",
       "2  NGUYEN, MINH HIEN LUONG  CARROLLTON   DALLAS     75007       777932   \n",
       "3         NGUYEN, PHUONG T       PLANO   COLLIN     75023       766293   \n",
       "4      NGUYEN, STEVEN MANH  FORT WORTH  TARRANT     76244       773318   \n",
       "\n",
       "  license_numbers                                          complaint  \n",
       "0  COS20220000853  Respondent failed to clean, disinfect, and ste...  \n",
       "1  COS20200013887  Respondent failed to keep floors, walls, ceili...  \n",
       "2  COS20210010437  Respondent failed to clean and sanitize whirlp...  \n",
       "3  COS20210014779  Respondent failed to keep a record of the date...  \n",
       "4  COS20200015190  Respondent leased space in a salon to an indiv...  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_csv('output.csv').head()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "venv310",
   "language": "python",
   "name": "venv310"
  },
  "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.3"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": true
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}