notebooks/princeton-university/week-5-logistic-regression-community-partner-data.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Breakout room goals\n",
    "\n",
    "```\n",
    "* skim https://docs.google.com/document/d/1xk5wB-1xiTkH8wawYwK2hlYFkZKYD3CQcEDi5ewaiVk/edit?usp=sharing to understand what one of the Just Data Lab community partners is interested in\n",
    "* use the skills we have learned so far to (1) download the raw data (2) use duckdb to parse the csv into a parquet file (3) use altair to visualize the columns pertinent to a research question the organization is interested in\n",
    "* post a screenshot in this figma\n",
    "```"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Data download\n",
    "\n",
    "https://drive.google.com/file/d/12-MZ2I2qWoECBHQaEX1JJ2pd77itDmej/view?usp=sharing \n"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Load data into duckdb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Status,Category,Vendor Record Type,Vendor,Associated Prime Vendor,M/WBE Category,Woman Owned Business,Emerging Business,Agency,Expense Category,Contract ID,Parent Contract ID,Version Number,Contract type,Purpose,Industry, Current Amount , Original Amount ,Start date,End Date,Registration date,Received date,Award Method,APT PIN,PIN\n",
      "Registered,Expense,Prime Vendor,PINA M INC,N/A,Women (Non-Minority),Yes,No ,Police Department,EQUIPMENT GENERAL,CT105620231408551,,1,SUPPLIES/MATERIALS/EQUIPMENT,LACTATION PODS  QMS 1529,Goods,\" $55,590.00 \",\" $55,590.00 \",11/9/2022,6/30/2024,12/13/2022,,SM PURCH GOODS SERVICES 100K,,233660122\n",
      "Registered,Expense,Prime Vendor,LIRO ENGINEERS INC,N/A,Non-M/WBE,No ,No ,Police Department,PROF SERV ENGINEER & ARCHITECT,CT105620238805005,,1,REQUIREMENTS-SERVICES,Environmental Engineering & Laboratory Services - Renewal #1,Professional Services,\" $1,225,000.00 \",\" $1,225,000.00 \",11/3/2022,11/2/2025,12/9/2022,,RENEWAL OF CONTRACT,,05620P8148KXLR001\n",
      "Registered,Expense,Prime Vendor,AMCHAR WHOLESALE  INC,N/A,Non-M/WBE,No ,No ,Police Department,SUPPLIES + MATERIALS - GENERAL,CT105620231408596,,1,SUPPLIES/MATERIALS/EQUIPMENT,SIMUNITION AMMO  QMS 1349,Goods,\" $79,970.40 \",\" $79,970.40 \",12/1/2022,6/30/2023,12/9/2022,,SM PURCH GOODS SERVICES 100K,,233700031\n",
      "Registered,Expense,Prime Vendor,ADVANTAGE TRAVEL INC,N/A,Non-M/WBE,No ,No ,Police Department,OVERNIGHT TRVL EXP-GENERAL,CT105620231407951,,1,REQUIREMENTS-SERVICES,TRAVEL AGENT SERVICE  QMS 1248,Goods,\" $80,000.00 \",\" $80,000.00 \",1/1/2023,12/31/2025,12/9/2022,,SM PURCH GOODS SERVICES 100K,,233580015\n",
      "Registered,Expense,Prime Vendor,US CHILLER SERVICE NY LLC,N/A,Non-M/WBE,No ,No ,Police Department,MAINT & OPER OF INFRASTRUCTURE,CT105620238804507,,1,WORK/LABOR,Renewal,Standardized Services,\" $145,731.00 \",\" $145,731.00 \",12/8/2022,12/7/2023,12/8/2022,,RENEWAL OF CONTRACT,,05618B8229KXLR001\n",
      "Registered,Expense,Prime Vendor,AVCO ENTERPRISES DENTSERVE,N/A,Asian American,Yes,No ,Police Department,EQUIPMENT GENERAL,CT105620231408327,,1,SUPPLIES/MATERIALS/EQUIPMENT,COMPRESSION BANDAGES FOR NYPD-POLICE ACADEMY_MERCI UNIT,Goods,\" $40,329.54 \",\" $40,329.54 \",12/2/2022,6/30/2023,12/8/2022,,SM PURCH GOODS SERVICES 100K,,233840073\n",
      "Registered,Expense,Prime Vendor,Walton Isaacson LLC,N/A,Non-M/WBE,No ,No ,Police Department,ADVERTISING,CT105620238804876,,1,REQUIREMENTS-SERVICES,NYPD Recruitment Advertising Media Strategy Services,Professional Services,\" $5,000,000.00 \",\" $5,000,000.00 \",11/1/2022,10/31/2024,12/8/2022,,RENEWAL OF CONTRACT,,05618P8214KXLR001\n",
      "Registered,Expense,Prime Vendor,LUCCAH CONSULTING LLC,N/A,Women (Non-Minority),Yes,No ,Police Department,EQUIPMENT GENERAL,CT105620231409841,,1,SUPPLIES/MATERIALS/EQUIPMENT,RUFF LAND PERFORMANCE DOG KENNELS,Goods,\" $13,610.00 \",\" $13,610.00 \",12/5/2022,6/30/2023,12/6/2022,,SMALL PURCHASE - WRITTEN,,237080033\n",
      "Registered,Expense,Prime Vendor,CEN-MED ENTERPRISES INC,N/A,Asian American,Yes,No ,Police Department,CONTRACTUAL SERVICES GENERAL,CT105620231409331,,1,SUPPLIES/MATERIALS/EQUIPMENT,AGILENT INSTRUMENTS REPAIR AND EXCHANGE  QMS 1580,Goods,\" $18,001.00 \",\" $18,001.00 \",11/28/2022,6/30/2023,12/6/2022,,SMALL PURCHASE - WRITTEN,,235640044\n"
     ]
    }
   ],
   "source": [
    "!head ./data/surveillanceresistancelab.org/raw/JDL_NYPD\\ Contracts\\ 12.15.22.csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\u001b[33mThere's a new jupysql version available (0.7.9), you're running 0.7.8. To upgrade: pip install jupysql --upgrade\u001b[0m\n"
     ]
    }
   ],
   "source": [
    "# Load duckdb, which lets us efficiently load large files\n",
    "import duckdb\n",
    "\n",
    "# Load pandas, which lets us manipulate dataframes\n",
    "import pandas as pd\n",
    "\n",
    "# Import jupysql Jupyter extension to create SQL cells\n",
    "%load_ext sql\n",
    "\n",
    "# Set configrations on jupysql to directly output data to Pandas and to simplify the output that is printed to the notebook.\n",
    "%config SqlMagic.autopandas = True\n",
    "\n",
    "%config SqlMagic.feedback = False\n",
    "%config SqlMagic.displaycon = False\n",
    "\n",
    "# Connect jupysql to DuckDB using a SQLAlchemy-style connection string. Either connect to an in memory DuckDB, or a file backed db.\n",
    "%sql duckdb:///:memory:"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### GPT-4 prompt\n",
    "\n",
    "```quote\n",
    "%%sql\n",
    "SELECT *\n",
    "FROM read_csv('https://data.cityofnewyork.us/api/views/erm2-nwe9/rows.csv?accessType=DOWNLOAD',\n",
    "    header=True,\n",
    "    delim=',',\n",
    "    quote='\"',\n",
    "    columns={'Unique Key': 'BIGINT',\n",
    "    'Created Date': 'VARCHAR',\n",
    "    'Closed Date': 'VARCHAR',\n",
    "    'Agency': 'VARCHAR',\n",
    "    'Agency Name': 'VARCHAR',\n",
    "    'Complaint Type': 'VARCHAR',\n",
    "    'Descriptor': 'VARCHAR',\n",
    "    'Location Type': 'VARCHAR',\n",
    "    'Incident Zip': 'VARCHAR',\n",
    "    'Incident Address': 'VARCHAR',\n",
    "    'Street Name': 'VARCHAR',\n",
    "    'Cross Street 1': 'VARCHAR',\n",
    "    'Cross Street 2': 'VARCHAR',\n",
    "    'Intersection Street 1': 'VARCHAR',\n",
    "    'Intersection Street 2': 'VARCHAR',\n",
    "    'Address Type': 'VARCHAR',\n",
    "    'City': 'VARCHAR',\n",
    "    'Landmark': 'VARCHAR',\n",
    "    'Facility Type': 'VARCHAR',\n",
    "    'Status': 'VARCHAR',\n",
    "    'Due Date': 'VARCHAR',\n",
    "    'Resolution Description': 'VARCHAR',\n",
    "    'Resolution Action Updated Date': 'VARCHAR',\n",
    "    'Community Board': 'VARCHAR',\n",
    "    'BBL': 'VARCHAR',\n",
    "    'Borough': 'VARCHAR',\n",
    "    'X Coordinate (State Plane)': 'VARCHAR',\n",
    "    'Y Coordinate (State Plane)': 'VARCHAR',\n",
    "    'Open Data Channel Type': 'VARCHAR',\n",
    "    'Park Facility Name': 'VARCHAR',\n",
    "    'Park Borough': 'VARCHAR',\n",
    "    'Vehicle Type': 'VARCHAR',\n",
    "    'Taxi Company Borough': 'VARCHAR',\n",
    "    'Taxi Pick Up Location': 'VARCHAR',\n",
    "    'Bridge Highway Name': 'VARCHAR',\n",
    "    'Bridge Highway Direction': 'VARCHAR',\n",
    "    'Road Ramp': 'VARCHAR',\n",
    "    'Bridge Highway Segment': 'VARCHAR',\n",
    "    'Latitude': 'DOUBLE',\n",
    "    'Longitude': 'DOUBLE',\n",
    "    'Location': 'VARCHAR'}) \n",
    "LIMIT 10;\n",
    "\n",
    "please rewrite the above example using this csv file: `./data/surveillanceresistancelab.org/raw/JDL_NYPD\\ Contracts\\ 12.15.22.csv`, whose header is the following: \n",
    "\n",
    "```\n",
    "Status,Category,Vendor Record Type,Vendor,Associated Prime Vendor,M/WBE Category,Woman Owned Business,Emerging Business,Agency,Expense Category,Contract ID,Parent Contract ID,Version Number,Contract type,Purpose,Industry, Current Amount , Original Amount ,Start date,End Date,Registration date,Received date,Award Method,APT PIN,PIN\n",
    "Registered,Expense,Prime Vendor,PINA M INC,N/A,Women (Non-Minority),Yes,No ,Police Department,EQUIPMENT GENERAL,CT105620231408551,,1,SUPPLIES/MATERIALS/EQUIPMENT,LACTATION PODS  QMS 1529,Goods,\" $55,590.00 \",\" $55,590.00 \",11/9/2022,6/30/2024,12/13/2022,,SM PURCH GOODS SERVICES 100K,,233660122\n",
    "Registered,Expense,Prime Vendor,LIRO ENGINEERS INC,N/A,Non-M/WBE,No ,No ,Police Department,PROF SERV ENGINEER & ARCHITECT,CT105620238805005,,1,REQUIREMENTS-SERVICES,Environmental Engineering & Laboratory Services - Renewal #1,Professional Services,\" $1,225,000.00 \",\" $1,225,000.00 \",11/3/2022,11/2/2025,12/9/2022,,RENEWAL OF CONTRACT,,05620P8148KXLR001\n",
    "Registered,Expense,Prime Vendor,AMCHAR WHOLESALE  INC,N/A,Non-M/WBE,No ,No ,Police Department,SUPPLIES + MATERIALS - GENERAL,CT105620231408596,,1,SUPPLIES/MATERIALS/EQUIPMENT,SIMUNITION AMMO  QMS 1349,Goods,\" $79,970.40 \",\" $79,970.40 \",12/1/2022,6/30/2023,12/9/2022,,SM PURCH GOODS SERVICES 100K,,233700031\n",
    "Registered,Expense,Prime Vendor,ADVANTAGE TRAVEL INC,N/A,Non-M/WBE,No ,No ,Police Department,OVERNIGHT TRVL EXP-GENERAL,CT105620231407951,,1,REQUIREMENTS-SERVICES,TRAVEL AGENT SERVICE  QMS 1248,Goods,\" $80,000.00 \",\" $80,000.00 \",1/1/2023,12/31/2025,12/9/2022,,SM PURCH GOODS SERVICES 100K,,233580015\n",
    "Registered,Expense,Prime Vendor,US CHILLER SERVICE NY LLC,N/A,Non-M/WBE,No ,No ,Police Department,MAINT & OPER OF INFRASTRUCTURE,CT105620238804507,,1,WORK/LABOR,Renewal,Standardized Services,\" $145,731.00 \",\" $145,731.00 \",12/8/2022,12/7/2023,12/8/2022,,RENEWAL OF CONTRACT,,05618B8229KXLR001\n",
    "Registered,Expense,Prime Vendor,AVCO ENTERPRISES DENTSERVE,N/A,Asian American,Yes,No ,Police Department,EQUIPMENT GENERAL,CT105620231408327,,1,SUPPLIES/MATERIALS/EQUIPMENT,COMPRESSION BANDAGES FOR NYPD-POLICE ACADEMY_MERCI UNIT,Goods,\" $40,329.54 \",\" $40,329.54 \",12/2/2022,6/30/2023,12/8/2022,,SM PURCH GOODS SERVICES 100K,,233840073\n",
    "Registered,Expense,Prime Vendor,Walton Isaacson LLC,N/A,Non-M/WBE,No ,No ,Police Department,ADVERTISING,CT105620238804876,,1,REQUIREMENTS-SERVICES,NYPD Recruitment Advertising Media Strategy Services,Professional Services,\" $5,000,000.00 \",\" $5,000,000.00 \",11/1/2022,10/31/2024,12/8/2022,,RENEWAL OF CONTRACT,,05618P8214KXLR001\n",
    "Registered,Expense,Prime Vendor,LUCCAH CONSULTING LLC,N/A,Women (Non-Minority),Yes,No ,Police Department,EQUIPMENT GENERAL,CT105620231409841,,1,SUPPLIES/MATERIALS/EQUIPMENT,RUFF LAND PERFORMANCE DOG KENNELS,Goods,\" $13,610.00 \",\" $13,610.00 \",12/5/2022,6/30/2023,12/6/2022,,SMALL PURCHASE - WRITTEN,,237080033\n",
    "Registered,Expense,Prime Vendor,CEN-MED ENTERPRISES INC,N/A,Asian American,Yes,No ,Police Department,CONTRACTUAL SERVICES GENERAL,CT105620231409331,,1,SUPPLIES/MATERIALS/EQUIPMENT,AGILENT INSTRUMENTS REPAIR AND EXCHANGE  QMS 1580,Goods,\" $18,001.00 \",\" $18,001.00 \",11/28/2022,6/30/2023,12/6/2022,,SMALL PURCHASE - WRITTEN,,235640044\n",
    "```\n",
    "```\n",
    "\n",
    "Response: https://chat.openai.com/share/dbe04ed0-b6ff-4d20-83aa-bd96d649f6c3 and below"
   ]
  },
  {
   "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>Status</th>\n",
       "      <th>Category</th>\n",
       "      <th>Vendor Record Type</th>\n",
       "      <th>Vendor</th>\n",
       "      <th>Associated Prime Vendor</th>\n",
       "      <th>M/WBE Category</th>\n",
       "      <th>Woman Owned Business</th>\n",
       "      <th>Emerging Business</th>\n",
       "      <th>Agency</th>\n",
       "      <th>Expense Category</th>\n",
       "      <th>...</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Current Amount</th>\n",
       "      <th>Original Amount</th>\n",
       "      <th>Start date</th>\n",
       "      <th>End Date</th>\n",
       "      <th>Registration date</th>\n",
       "      <th>Received date</th>\n",
       "      <th>Award Method</th>\n",
       "      <th>APT PIN</th>\n",
       "      <th>PIN</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Registered</td>\n",
       "      <td>Expense</td>\n",
       "      <td>Prime Vendor</td>\n",
       "      <td>PINA M INC</td>\n",
       "      <td>N/A</td>\n",
       "      <td>Women (Non-Minority)</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Police Department</td>\n",
       "      <td>EQUIPMENT GENERAL</td>\n",
       "      <td>...</td>\n",
       "      <td>Goods</td>\n",
       "      <td>$55,590.00</td>\n",
       "      <td>$55,590.00</td>\n",
       "      <td>11/9/2022</td>\n",
       "      <td>6/30/2024</td>\n",
       "      <td>12/13/2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SM PURCH GOODS SERVICES 100K</td>\n",
       "      <td>NaN</td>\n",
       "      <td>233660122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Registered</td>\n",
       "      <td>Expense</td>\n",
       "      <td>Prime Vendor</td>\n",
       "      <td>LIRO ENGINEERS INC</td>\n",
       "      <td>N/A</td>\n",
       "      <td>Non-M/WBE</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Police Department</td>\n",
       "      <td>PROF SERV ENGINEER &amp; ARCHITECT</td>\n",
       "      <td>...</td>\n",
       "      <td>Professional Services</td>\n",
       "      <td>$1,225,000.00</td>\n",
       "      <td>$1,225,000.00</td>\n",
       "      <td>11/3/2022</td>\n",
       "      <td>11/2/2025</td>\n",
       "      <td>12/9/2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RENEWAL OF CONTRACT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>05620P8148KXLR001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Registered</td>\n",
       "      <td>Expense</td>\n",
       "      <td>Prime Vendor</td>\n",
       "      <td>AMCHAR WHOLESALE  INC</td>\n",
       "      <td>N/A</td>\n",
       "      <td>Non-M/WBE</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Police Department</td>\n",
       "      <td>SUPPLIES + MATERIALS - GENERAL</td>\n",
       "      <td>...</td>\n",
       "      <td>Goods</td>\n",
       "      <td>$79,970.40</td>\n",
       "      <td>$79,970.40</td>\n",
       "      <td>12/1/2022</td>\n",
       "      <td>6/30/2023</td>\n",
       "      <td>12/9/2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SM PURCH GOODS SERVICES 100K</td>\n",
       "      <td>NaN</td>\n",
       "      <td>233700031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Registered</td>\n",
       "      <td>Expense</td>\n",
       "      <td>Prime Vendor</td>\n",
       "      <td>ADVANTAGE TRAVEL INC</td>\n",
       "      <td>N/A</td>\n",
       "      <td>Non-M/WBE</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Police Department</td>\n",
       "      <td>OVERNIGHT TRVL EXP-GENERAL</td>\n",
       "      <td>...</td>\n",
       "      <td>Goods</td>\n",
       "      <td>$80,000.00</td>\n",
       "      <td>$80,000.00</td>\n",
       "      <td>1/1/2023</td>\n",
       "      <td>12/31/2025</td>\n",
       "      <td>12/9/2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SM PURCH GOODS SERVICES 100K</td>\n",
       "      <td>NaN</td>\n",
       "      <td>233580015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Registered</td>\n",
       "      <td>Expense</td>\n",
       "      <td>Prime Vendor</td>\n",
       "      <td>US CHILLER SERVICE NY LLC</td>\n",
       "      <td>N/A</td>\n",
       "      <td>Non-M/WBE</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Police Department</td>\n",
       "      <td>MAINT &amp; OPER OF INFRASTRUCTURE</td>\n",
       "      <td>...</td>\n",
       "      <td>Standardized Services</td>\n",
       "      <td>$145,731.00</td>\n",
       "      <td>$145,731.00</td>\n",
       "      <td>12/8/2022</td>\n",
       "      <td>12/7/2023</td>\n",
       "      <td>12/8/2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RENEWAL OF CONTRACT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>05618B8229KXLR001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Registered</td>\n",
       "      <td>Expense</td>\n",
       "      <td>Prime Vendor</td>\n",
       "      <td>AVCO ENTERPRISES DENTSERVE</td>\n",
       "      <td>N/A</td>\n",
       "      <td>Asian American</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Police Department</td>\n",
       "      <td>EQUIPMENT GENERAL</td>\n",
       "      <td>...</td>\n",
       "      <td>Goods</td>\n",
       "      <td>$40,329.54</td>\n",
       "      <td>$40,329.54</td>\n",
       "      <td>12/2/2022</td>\n",
       "      <td>6/30/2023</td>\n",
       "      <td>12/8/2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SM PURCH GOODS SERVICES 100K</td>\n",
       "      <td>NaN</td>\n",
       "      <td>233840073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Registered</td>\n",
       "      <td>Expense</td>\n",
       "      <td>Prime Vendor</td>\n",
       "      <td>Walton Isaacson LLC</td>\n",
       "      <td>N/A</td>\n",
       "      <td>Non-M/WBE</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Police Department</td>\n",
       "      <td>ADVERTISING</td>\n",
       "      <td>...</td>\n",
       "      <td>Professional Services</td>\n",
       "      <td>$5,000,000.00</td>\n",
       "      <td>$5,000,000.00</td>\n",
       "      <td>11/1/2022</td>\n",
       "      <td>10/31/2024</td>\n",
       "      <td>12/8/2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RENEWAL OF CONTRACT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>05618P8214KXLR001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Registered</td>\n",
       "      <td>Expense</td>\n",
       "      <td>Prime Vendor</td>\n",
       "      <td>LUCCAH CONSULTING LLC</td>\n",
       "      <td>N/A</td>\n",
       "      <td>Women (Non-Minority)</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Police Department</td>\n",
       "      <td>EQUIPMENT GENERAL</td>\n",
       "      <td>...</td>\n",
       "      <td>Goods</td>\n",
       "      <td>$13,610.00</td>\n",
       "      <td>$13,610.00</td>\n",
       "      <td>12/5/2022</td>\n",
       "      <td>6/30/2023</td>\n",
       "      <td>12/6/2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SMALL PURCHASE - WRITTEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237080033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Registered</td>\n",
       "      <td>Expense</td>\n",
       "      <td>Prime Vendor</td>\n",
       "      <td>CEN-MED ENTERPRISES INC</td>\n",
       "      <td>N/A</td>\n",
       "      <td>Asian American</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Police Department</td>\n",
       "      <td>CONTRACTUAL SERVICES GENERAL</td>\n",
       "      <td>...</td>\n",
       "      <td>Goods</td>\n",
       "      <td>$18,001.00</td>\n",
       "      <td>$18,001.00</td>\n",
       "      <td>11/28/2022</td>\n",
       "      <td>6/30/2023</td>\n",
       "      <td>12/6/2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SMALL PURCHASE - WRITTEN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>235640044</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Registered</td>\n",
       "      <td>Expense</td>\n",
       "      <td>Prime Vendor</td>\n",
       "      <td>QUEST DIAGNOSTICS CLINICAL LABORATORIES INC</td>\n",
       "      <td>N/A</td>\n",
       "      <td>Non-M/WBE</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Police Department</td>\n",
       "      <td>PROF SERV OTHER</td>\n",
       "      <td>...</td>\n",
       "      <td>Not Classified</td>\n",
       "      <td>$440,000.00</td>\n",
       "      <td>$440,000.00</td>\n",
       "      <td>3/4/2020</td>\n",
       "      <td>7/15/2022</td>\n",
       "      <td>12/2/2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>RENEWAL OF CONTRACT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>05616B8252KXLR001</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Status Category Vendor Record Type  \\\n",
       "0  Registered  Expense       Prime Vendor   \n",
       "1  Registered  Expense       Prime Vendor   \n",
       "2  Registered  Expense       Prime Vendor   \n",
       "3  Registered  Expense       Prime Vendor   \n",
       "4  Registered  Expense       Prime Vendor   \n",
       "5  Registered  Expense       Prime Vendor   \n",
       "6  Registered  Expense       Prime Vendor   \n",
       "7  Registered  Expense       Prime Vendor   \n",
       "8  Registered  Expense       Prime Vendor   \n",
       "9  Registered  Expense       Prime Vendor   \n",
       "\n",
       "                                        Vendor Associated Prime Vendor  \\\n",
       "0                                   PINA M INC                     N/A   \n",
       "1                           LIRO ENGINEERS INC                     N/A   \n",
       "2                        AMCHAR WHOLESALE  INC                     N/A   \n",
       "3                         ADVANTAGE TRAVEL INC                     N/A   \n",
       "4                    US CHILLER SERVICE NY LLC                     N/A   \n",
       "5                   AVCO ENTERPRISES DENTSERVE                     N/A   \n",
       "6                          Walton Isaacson LLC                     N/A   \n",
       "7                        LUCCAH CONSULTING LLC                     N/A   \n",
       "8                      CEN-MED ENTERPRISES INC                     N/A   \n",
       "9  QUEST DIAGNOSTICS CLINICAL LABORATORIES INC                     N/A   \n",
       "\n",
       "         M/WBE Category Woman Owned Business Emerging Business  \\\n",
       "0  Women (Non-Minority)                  Yes               No    \n",
       "1             Non-M/WBE                  No                No    \n",
       "2             Non-M/WBE                  No                No    \n",
       "3             Non-M/WBE                  No                No    \n",
       "4             Non-M/WBE                  No                No    \n",
       "5        Asian American                  Yes               No    \n",
       "6             Non-M/WBE                  No                No    \n",
       "7  Women (Non-Minority)                  Yes               No    \n",
       "8        Asian American                  Yes               No    \n",
       "9             Non-M/WBE                  No                No    \n",
       "\n",
       "              Agency                Expense Category  ...  \\\n",
       "0  Police Department               EQUIPMENT GENERAL  ...   \n",
       "1  Police Department  PROF SERV ENGINEER & ARCHITECT  ...   \n",
       "2  Police Department  SUPPLIES + MATERIALS - GENERAL  ...   \n",
       "3  Police Department      OVERNIGHT TRVL EXP-GENERAL  ...   \n",
       "4  Police Department  MAINT & OPER OF INFRASTRUCTURE  ...   \n",
       "5  Police Department               EQUIPMENT GENERAL  ...   \n",
       "6  Police Department                     ADVERTISING  ...   \n",
       "7  Police Department               EQUIPMENT GENERAL  ...   \n",
       "8  Police Department    CONTRACTUAL SERVICES GENERAL  ...   \n",
       "9  Police Department                 PROF SERV OTHER  ...   \n",
       "\n",
       "                Industry   Current Amount  Original Amount  Start date  \\\n",
       "0                  Goods      $55,590.00       $55,590.00    11/9/2022   \n",
       "1  Professional Services   $1,225,000.00    $1,225,000.00    11/3/2022   \n",
       "2                  Goods      $79,970.40       $79,970.40    12/1/2022   \n",
       "3                  Goods      $80,000.00       $80,000.00     1/1/2023   \n",
       "4  Standardized Services     $145,731.00      $145,731.00    12/8/2022   \n",
       "5                  Goods      $40,329.54       $40,329.54    12/2/2022   \n",
       "6  Professional Services   $5,000,000.00    $5,000,000.00    11/1/2022   \n",
       "7                  Goods      $13,610.00       $13,610.00    12/5/2022   \n",
       "8                  Goods      $18,001.00       $18,001.00   11/28/2022   \n",
       "9         Not Classified     $440,000.00      $440,000.00     3/4/2020   \n",
       "\n",
       "     End Date Registration date Received date                  Award Method  \\\n",
       "0   6/30/2024        12/13/2022           NaN  SM PURCH GOODS SERVICES 100K   \n",
       "1   11/2/2025         12/9/2022           NaN           RENEWAL OF CONTRACT   \n",
       "2   6/30/2023         12/9/2022           NaN  SM PURCH GOODS SERVICES 100K   \n",
       "3  12/31/2025         12/9/2022           NaN  SM PURCH GOODS SERVICES 100K   \n",
       "4   12/7/2023         12/8/2022           NaN           RENEWAL OF CONTRACT   \n",
       "5   6/30/2023         12/8/2022           NaN  SM PURCH GOODS SERVICES 100K   \n",
       "6  10/31/2024         12/8/2022           NaN           RENEWAL OF CONTRACT   \n",
       "7   6/30/2023         12/6/2022           NaN      SMALL PURCHASE - WRITTEN   \n",
       "8   6/30/2023         12/6/2022           NaN      SMALL PURCHASE - WRITTEN   \n",
       "9   7/15/2022         12/2/2022           NaN           RENEWAL OF CONTRACT   \n",
       "\n",
       "  APT PIN                PIN  \n",
       "0     NaN          233660122  \n",
       "1     NaN  05620P8148KXLR001  \n",
       "2     NaN          233700031  \n",
       "3     NaN          233580015  \n",
       "4     NaN  05618B8229KXLR001  \n",
       "5     NaN          233840073  \n",
       "6     NaN  05618P8214KXLR001  \n",
       "7     NaN          237080033  \n",
       "8     NaN          235640044  \n",
       "9     NaN  05616B8252KXLR001  \n",
       "\n",
       "[10 rows x 25 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "SELECT *\n",
    "FROM read_csv('./data/surveillanceresistancelab.org/raw/JDL_NYPD Contracts 12.15.22.csv',\n",
    "    header=True,\n",
    "    delim=',',\n",
    "    quote='\"',\n",
    "    columns={'Status': 'VARCHAR',\n",
    "    'Category': 'VARCHAR',\n",
    "    'Vendor Record Type': 'VARCHAR',\n",
    "    'Vendor': 'VARCHAR',\n",
    "    'Associated Prime Vendor': 'VARCHAR',\n",
    "    'M/WBE Category': 'VARCHAR',\n",
    "    'Woman Owned Business': 'VARCHAR',\n",
    "    'Emerging Business': 'VARCHAR',\n",
    "    'Agency': 'VARCHAR',\n",
    "    'Expense Category': 'VARCHAR',\n",
    "    'Contract ID': 'VARCHAR',\n",
    "    'Parent Contract ID': 'VARCHAR',\n",
    "    'Version Number': 'VARCHAR',\n",
    "    'Contract type': 'VARCHAR',\n",
    "    'Purpose': 'VARCHAR',\n",
    "    'Industry': 'VARCHAR',\n",
    "    'Current Amount': 'VARCHAR',\n",
    "    'Original Amount': 'VARCHAR',\n",
    "    'Start date': 'VARCHAR',\n",
    "    'End Date': 'VARCHAR',\n",
    "    'Registration date': 'VARCHAR',\n",
    "    'Received date': 'VARCHAR',\n",
    "    'Award Method': 'VARCHAR',\n",
    "    'APT PIN': 'VARCHAR',\n",
    "    'PIN': 'VARCHAR'})\n",
    "LIMIT 10;\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "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>Count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>17809</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Count\n",
       "0  17809"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "COPY (SELECT *\n",
    "FROM read_csv('./data/surveillanceresistancelab.org/raw/JDL_NYPD Contracts 12.15.22.csv',\n",
    "    header=True,\n",
    "    delim=',',\n",
    "    quote='\"',\n",
    "    nullstr='N/A',\n",
    "    columns={'Status': 'VARCHAR',\n",
    "    'Category': 'VARCHAR',\n",
    "    'Vendor Record Type': 'VARCHAR',\n",
    "    'Vendor': 'VARCHAR',\n",
    "    'Associated Prime Vendor': 'VARCHAR',\n",
    "    'M/WBE Category': 'VARCHAR',\n",
    "    'Woman Owned Business': 'VARCHAR',\n",
    "    'Emerging Business': 'VARCHAR',\n",
    "    'Agency': 'VARCHAR',\n",
    "    'Expense Category': 'VARCHAR',\n",
    "    'Contract ID': 'VARCHAR',\n",
    "    'Parent Contract ID': 'VARCHAR',\n",
    "    'Version Number': 'VARCHAR',\n",
    "    'Contract type': 'VARCHAR',\n",
    "    'Purpose': 'VARCHAR',\n",
    "    'Industry': 'VARCHAR',\n",
    "    'Current Amount': 'VARCHAR',\n",
    "    'Original Amount': 'VARCHAR',\n",
    "    'Start date': 'VARCHAR',\n",
    "    'End Date': 'VARCHAR',\n",
    "    'Registration date': 'VARCHAR',\n",
    "    'Received date': 'VARCHAR',\n",
    "    'Award Method': 'VARCHAR',\n",
    "    'APT PIN': 'VARCHAR',\n",
    "    'PIN': 'VARCHAR'})\n",
    "-- LIMIT 1000000 -- uncomment this line to create a smaller version of the file for testing purposes\n",
    ") TO './data/surveillanceresistancelab.org/processed/JDL_NYPD Contracts 12.15.22.parquet' (COMPRESSION ZSTD);\n"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Visualizing the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "vegafusion.enable(mimetype='html', row_limit=100000000, embed_options=None)"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import vegafusion as vf\n",
    "import polars as pl\n",
    "import altair as alt\n",
    "import altair as alt\n",
    "alt.data_transformers.disable_max_rows()\n",
    "alt.renderers.enable('html')\n",
    "\n",
    "# Configure DuckDB connection\n",
    "vf.runtime.set_connection(\"duckdb\")\n",
    "\n",
    "# Enable Mime Renderer\n",
    "vf.enable(row_limit=100000000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Load the data into a Polars datafram\n",
    "contracts = pl.read_parquet(\"./data/surveillanceresistancelab.org/processed/JDL_NYPD Contracts 12.15.22.parquet\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'Status': Utf8, 'Category': Utf8, 'Vendor Record Type': Utf8, 'Vendor': Utf8, 'Associated Prime Vendor': Utf8, 'M/WBE Category': Utf8, 'Woman Owned Business': Utf8, 'Emerging Business': Utf8, 'Agency': Utf8, 'Expense Category': Utf8, 'Contract ID': Utf8, 'Parent Contract ID': Utf8, 'Version Number': Utf8, 'Contract type': Utf8, 'Purpose': Utf8, 'Industry': Utf8, 'Current Amount': Utf8, 'Original Amount': Utf8, 'Start date': Utf8, 'End Date': Utf8, 'Registration date': Utf8, 'Received date': Utf8, 'Award Method': Utf8, 'APT PIN': Utf8, 'PIN': Utf8}\n"
     ]
    }
   ],
   "source": [
    "print(contracts.schema)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div><style>\n",
       ".dataframe > thead > tr > th,\n",
       ".dataframe > tbody > tr > td {\n",
       "  text-align: right;\n",
       "}\n",
       "</style>\n",
       "<small>shape: (17_809, 25)</small><table border=\"1\" class=\"dataframe\"><thead><tr><th>Status</th><th>Category</th><th>Vendor Record Type</th><th>Vendor</th><th>Associated Prime Vendor</th><th>M/WBE Category</th><th>Woman Owned Business</th><th>Emerging Business</th><th>Agency</th><th>Expense Category</th><th>Contract ID</th><th>Parent Contract ID</th><th>Version Number</th><th>Contract type</th><th>Purpose</th><th>Industry</th><th>Current Amount</th><th>Original Amount</th><th>Start date</th><th>End Date</th><th>Registration date</th><th>Received date</th><th>Award Method</th><th>APT PIN</th><th>PIN</th></tr><tr><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td><td>str</td></tr></thead><tbody><tr><td>&quot;Registered&quot;</td><td>&quot;Expense&quot;</td><td>&quot;Prime Vendor&quot;</td><td>&quot;PINA M INC&quot;</td><td>null</td><td>&quot;Women (Non-Min…</td><td>&quot;Yes&quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;EQUIPMENT GENE…</td><td>&quot;CT105620231408…</td><td>&quot;&quot;</td><td>&quot;1&quot;</td><td>&quot;SUPPLIES/MATER…</td><td>&quot;LACTATION PODS…</td><td>&quot;Goods&quot;</td><td>&quot; $55,590.00 &quot;</td><td>&quot; $55,590.00 &quot;</td><td>&quot;11/9/2022&quot;</td><td>&quot;6/30/2024&quot;</td><td>&quot;12/13/2022&quot;</td><td>&quot;&quot;</td><td>&quot;SM PURCH GOODS…</td><td>&quot;&quot;</td><td>&quot;233660122&quot;</td></tr><tr><td>&quot;Registered&quot;</td><td>&quot;Expense&quot;</td><td>&quot;Prime Vendor&quot;</td><td>&quot;LIRO ENGINEERS…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;PROF SERV ENGI…</td><td>&quot;CT105620238805…</td><td>&quot;&quot;</td><td>&quot;1&quot;</td><td>&quot;REQUIREMENTS-S…</td><td>&quot;Environmental …</td><td>&quot;Professional S…</td><td>&quot; $1,225,000.00…</td><td>&quot; $1,225,000.00…</td><td>&quot;11/3/2022&quot;</td><td>&quot;11/2/2025&quot;</td><td>&quot;12/9/2022&quot;</td><td>&quot;&quot;</td><td>&quot;RENEWAL OF CON…</td><td>&quot;&quot;</td><td>&quot;05620P8148KXLR…</td></tr><tr><td>&quot;Registered&quot;</td><td>&quot;Expense&quot;</td><td>&quot;Prime Vendor&quot;</td><td>&quot;AMCHAR WHOLESA…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;SUPPLIES + MAT…</td><td>&quot;CT105620231408…</td><td>&quot;&quot;</td><td>&quot;1&quot;</td><td>&quot;SUPPLIES/MATER…</td><td>&quot;SIMUNITION AMM…</td><td>&quot;Goods&quot;</td><td>&quot; $79,970.40 &quot;</td><td>&quot; $79,970.40 &quot;</td><td>&quot;12/1/2022&quot;</td><td>&quot;6/30/2023&quot;</td><td>&quot;12/9/2022&quot;</td><td>&quot;&quot;</td><td>&quot;SM PURCH GOODS…</td><td>&quot;&quot;</td><td>&quot;233700031&quot;</td></tr><tr><td>&quot;Registered&quot;</td><td>&quot;Expense&quot;</td><td>&quot;Prime Vendor&quot;</td><td>&quot;ADVANTAGE TRAV…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;OVERNIGHT TRVL…</td><td>&quot;CT105620231407…</td><td>&quot;&quot;</td><td>&quot;1&quot;</td><td>&quot;REQUIREMENTS-S…</td><td>&quot;TRAVEL AGENT S…</td><td>&quot;Goods&quot;</td><td>&quot; $80,000.00 &quot;</td><td>&quot; $80,000.00 &quot;</td><td>&quot;1/1/2023&quot;</td><td>&quot;12/31/2025&quot;</td><td>&quot;12/9/2022&quot;</td><td>&quot;&quot;</td><td>&quot;SM PURCH GOODS…</td><td>&quot;&quot;</td><td>&quot;233580015&quot;</td></tr><tr><td>&quot;Registered&quot;</td><td>&quot;Expense&quot;</td><td>&quot;Prime Vendor&quot;</td><td>&quot;US CHILLER SER…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;MAINT &amp; OPER O…</td><td>&quot;CT105620238804…</td><td>&quot;&quot;</td><td>&quot;1&quot;</td><td>&quot;WORK/LABOR&quot;</td><td>&quot;Renewal&quot;</td><td>&quot;Standardized S…</td><td>&quot; $145,731.00 &quot;</td><td>&quot; $145,731.00 &quot;</td><td>&quot;12/8/2022&quot;</td><td>&quot;12/7/2023&quot;</td><td>&quot;12/8/2022&quot;</td><td>&quot;&quot;</td><td>&quot;RENEWAL OF CON…</td><td>&quot;&quot;</td><td>&quot;05618B8229KXLR…</td></tr><tr><td>&quot;Registered&quot;</td><td>&quot;Expense&quot;</td><td>&quot;Prime Vendor&quot;</td><td>&quot;AVCO ENTERPRIS…</td><td>null</td><td>&quot;Asian American…</td><td>&quot;Yes&quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;EQUIPMENT GENE…</td><td>&quot;CT105620231408…</td><td>&quot;&quot;</td><td>&quot;1&quot;</td><td>&quot;SUPPLIES/MATER…</td><td>&quot;COMPRESSION BA…</td><td>&quot;Goods&quot;</td><td>&quot; $40,329.54 &quot;</td><td>&quot; $40,329.54 &quot;</td><td>&quot;12/2/2022&quot;</td><td>&quot;6/30/2023&quot;</td><td>&quot;12/8/2022&quot;</td><td>&quot;&quot;</td><td>&quot;SM PURCH GOODS…</td><td>&quot;&quot;</td><td>&quot;233840073&quot;</td></tr><tr><td>&quot;Registered&quot;</td><td>&quot;Expense&quot;</td><td>&quot;Prime Vendor&quot;</td><td>&quot;Walton Isaacso…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;ADVERTISING&quot;</td><td>&quot;CT105620238804…</td><td>&quot;&quot;</td><td>&quot;1&quot;</td><td>&quot;REQUIREMENTS-S…</td><td>&quot;NYPD Recruitme…</td><td>&quot;Professional S…</td><td>&quot; $5,000,000.00…</td><td>&quot; $5,000,000.00…</td><td>&quot;11/1/2022&quot;</td><td>&quot;10/31/2024&quot;</td><td>&quot;12/8/2022&quot;</td><td>&quot;&quot;</td><td>&quot;RENEWAL OF CON…</td><td>&quot;&quot;</td><td>&quot;05618P8214KXLR…</td></tr><tr><td>&quot;Registered&quot;</td><td>&quot;Expense&quot;</td><td>&quot;Prime Vendor&quot;</td><td>&quot;LUCCAH CONSULT…</td><td>null</td><td>&quot;Women (Non-Min…</td><td>&quot;Yes&quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;EQUIPMENT GENE…</td><td>&quot;CT105620231409…</td><td>&quot;&quot;</td><td>&quot;1&quot;</td><td>&quot;SUPPLIES/MATER…</td><td>&quot;RUFF LAND PERF…</td><td>&quot;Goods&quot;</td><td>&quot; $13,610.00 &quot;</td><td>&quot; $13,610.00 &quot;</td><td>&quot;12/5/2022&quot;</td><td>&quot;6/30/2023&quot;</td><td>&quot;12/6/2022&quot;</td><td>&quot;&quot;</td><td>&quot;SMALL PURCHASE…</td><td>&quot;&quot;</td><td>&quot;237080033&quot;</td></tr><tr><td>&quot;Registered&quot;</td><td>&quot;Expense&quot;</td><td>&quot;Prime Vendor&quot;</td><td>&quot;CEN-MED ENTERP…</td><td>null</td><td>&quot;Asian American…</td><td>&quot;Yes&quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;CONTRACTUAL SE…</td><td>&quot;CT105620231409…</td><td>&quot;&quot;</td><td>&quot;1&quot;</td><td>&quot;SUPPLIES/MATER…</td><td>&quot;AGILENT INSTRU…</td><td>&quot;Goods&quot;</td><td>&quot; $18,001.00 &quot;</td><td>&quot; $18,001.00 &quot;</td><td>&quot;11/28/2022&quot;</td><td>&quot;6/30/2023&quot;</td><td>&quot;12/6/2022&quot;</td><td>&quot;&quot;</td><td>&quot;SMALL PURCHASE…</td><td>&quot;&quot;</td><td>&quot;235640044&quot;</td></tr><tr><td>&quot;Registered&quot;</td><td>&quot;Expense&quot;</td><td>&quot;Prime Vendor&quot;</td><td>&quot;QUEST DIAGNOST…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;PROF SERV OTHE…</td><td>&quot;CT105620238803…</td><td>&quot;&quot;</td><td>&quot;1&quot;</td><td>&quot;WORK/LABOR&quot;</td><td>&quot;Drug Screening…</td><td>&quot;Not Classified…</td><td>&quot; $440,000.00 &quot;</td><td>&quot; $440,000.00 &quot;</td><td>&quot;3/4/2020&quot;</td><td>&quot;7/15/2022&quot;</td><td>&quot;12/2/2022&quot;</td><td>&quot;&quot;</td><td>&quot;RENEWAL OF CON…</td><td>&quot;&quot;</td><td>&quot;05616B8252KXLR…</td></tr><tr><td>&quot;Registered&quot;</td><td>&quot;Expense&quot;</td><td>&quot;Prime Vendor&quot;</td><td>&quot;OXFORD INSTRUM…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;CONTRACTUAL SE…</td><td>&quot;CT105620231408…</td><td>&quot;&quot;</td><td>&quot;1&quot;</td><td>&quot;WORK/LABOR&quot;</td><td>&quot;INSTRUMENTATIO…</td><td>&quot;Goods&quot;</td><td>&quot; $14,268.00 &quot;</td><td>&quot; $14,268.00 &quot;</td><td>&quot;11/15/2022&quot;</td><td>&quot;6/30/2023&quot;</td><td>&quot;12/1/2022&quot;</td><td>&quot;&quot;</td><td>&quot;SMALL PURCHASE…</td><td>&quot;&quot;</td><td>&quot;235640040&quot;</td></tr><tr><td>&quot;Registered&quot;</td><td>&quot;Expense&quot;</td><td>&quot;Prime Vendor&quot;</td><td>&quot;COMPULINK TECH…</td><td>null</td><td>&quot;Hispanic Ameri…</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;PURCH DATA PRO…</td><td>&quot;CT105620231409…</td><td>&quot;&quot;</td><td>&quot;1&quot;</td><td>&quot;SUPPLIES/MATER…</td><td>&quot;HEADSETS &amp; COR…</td><td>&quot;Goods&quot;</td><td>&quot; $17,168.00 &quot;</td><td>&quot; $17,168.00 &quot;</td><td>&quot;11/21/2022&quot;</td><td>&quot;6/30/2023&quot;</td><td>&quot;12/1/2022&quot;</td><td>&quot;&quot;</td><td>&quot;SMALL PURCHASE…</td><td>&quot;&quot;</td><td>&quot;236220242&quot;</td></tr><tr><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td><td>&hellip;</td></tr><tr><td>&quot;Pending&quot;</td><td>&quot;Expense&quot;</td><td>&quot;&quot;</td><td>&quot;ITEGIX LLC&quot;</td><td>null</td><td>&quot;Hispanic Ameri…</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;&quot;</td><td>&quot;CT105620231408…</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;SUPPLIES/MATER…</td><td>&quot;MONITOR&quot;</td><td>&quot;Goods&quot;</td><td>&quot; $31,840.00 &quot;</td><td>&quot; $31,840.00 &quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;12/8/2022&quot;</td><td>&quot;SMALL PURCHASE…</td><td>&quot;&quot;</td><td>&quot;235050019&quot;</td></tr><tr><td>&quot;Pending&quot;</td><td>&quot;Expense&quot;</td><td>&quot;&quot;</td><td>&quot;CDE AIR CONDIT…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;&quot;</td><td>&quot;CT105620238805…</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;CONSTRUCTION&quot;</td><td>&quot;HVAC MIDTOWN N…</td><td>&quot;Construction S…</td><td>&quot; $1,513,075.00…</td><td>&quot; $1,513,075.00…</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;12/6/2022&quot;</td><td>&quot;COMPETITIVE BI…</td><td>&quot;&quot;</td><td>&quot;05622B0012001&quot;</td></tr><tr><td>&quot;Pending&quot;</td><td>&quot;Expense&quot;</td><td>&quot;&quot;</td><td>&quot;ATLANTIC TACTI…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;&quot;</td><td>&quot;CT105620238805…</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;SUPPLIES/MATER…</td><td>&quot;PROVISION OF S…</td><td>&quot;Goods&quot;</td><td>&quot; $1,294,807.48…</td><td>&quot; $1,294,807.48…</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;12/6/2022&quot;</td><td>&quot;SOLE SOURCE&quot;</td><td>&quot;&quot;</td><td>&quot;05622S0007001&quot;</td></tr><tr><td>&quot;Pending&quot;</td><td>&quot;Expense&quot;</td><td>&quot;&quot;</td><td>&quot;MOTOROLA SOLUT…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;&quot;</td><td>&quot;CTA10562023720…</td><td>&quot;MMA18582017620…</td><td>&quot;&quot;</td><td>&quot;DOITT REQUIREM…</td><td>&quot;MOTOROLA RADIO…</td><td>&quot;Standardized S…</td><td>&quot; $20,730,297.0…</td><td>&quot; $20,730,297.0…</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;12/1/2022&quot;</td><td>&quot;MULTIPLE AWARD…</td><td>&quot;&quot;</td><td>&quot;85817F8002KXLA…</td></tr><tr><td>&quot;Pending&quot;</td><td>&quot;Expense&quot;</td><td>&quot;&quot;</td><td>&quot;CASE SYSTEMS I…</td><td>null</td><td>&quot;Hispanic Ameri…</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;&quot;</td><td>&quot;CTR05620218801…</td><td>&quot;&quot;</td><td>&quot;6&quot;</td><td>&quot;WORK/LABOR&quot;</td><td>&quot;MAINTENANCE  R…</td><td>&quot;Standardized S…</td><td>&quot; $2,330,262.00…</td><td>&quot; $1,340,028.00…</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;11/30/2022&quot;</td><td>&quot;RENEWAL OF CON…</td><td>&quot;&quot;</td><td>&quot;05616B8254KXLA…</td></tr><tr><td>&quot;Pending&quot;</td><td>&quot;Expense&quot;</td><td>&quot;&quot;</td><td>&quot;HI-TECH AIR CO…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;&quot;</td><td>&quot;CTR05620191421…</td><td>&quot;&quot;</td><td>&quot;2&quot;</td><td>&quot;WORK/LABOR&quot;</td><td>&quot;REPLACE OF HVA…</td><td>&quot;Not Classified…</td><td>&quot; $1,488,000.00…</td><td>&quot; $1,488,000.00…</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;11/30/2022&quot;</td><td>&quot;COMPETITIVE BI…</td><td>&quot;5.618E+11&quot;</td><td>&quot;05619B8206KXLC…</td></tr><tr><td>&quot;Pending&quot;</td><td>&quot;Expense&quot;</td><td>&quot;&quot;</td><td>&quot;COMPULINK TECH…</td><td>null</td><td>&quot;Hispanic Ameri…</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;&quot;</td><td>&quot;CT105620231408…</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;SUPPLIES/MATER…</td><td>&quot;236220185 APPL…</td><td>&quot;Goods&quot;</td><td>&quot; $70,150.71 &quot;</td><td>&quot; $70,150.71 &quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;11/22/2022&quot;</td><td>&quot;SMALL PURCHASE…</td><td>&quot;&quot;</td><td>&quot;236220185A&quot;</td></tr><tr><td>&quot;Pending&quot;</td><td>&quot;Expense&quot;</td><td>&quot;&quot;</td><td>&quot;BRUKER AXS LLC…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;&quot;</td><td>&quot;CT105620231404…</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;WORK/LABOR&quot;</td><td>&quot;ANNUAL SERVICE…</td><td>&quot;Goods&quot;</td><td>&quot; $35,185.00 &quot;</td><td>&quot; $35,185.00 &quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;11/22/2022&quot;</td><td>&quot;SMALL PURCHASE…</td><td>&quot;&quot;</td><td>&quot;235640034&quot;</td></tr><tr><td>&quot;Pending&quot;</td><td>&quot;Expense&quot;</td><td>&quot;&quot;</td><td>&quot;ANIMAL MEDICAL…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;&quot;</td><td>&quot;CTR05620217207…</td><td>&quot;MMA10562021620…</td><td>&quot;4&quot;</td><td>&quot;WORK/LABOR&quot;</td><td>&quot;VET SERVICES F…</td><td>&quot;Professional S…</td><td>&quot; $374,608.46 &quot;</td><td>&quot; $171,942.70 &quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;11/18/2022&quot;</td><td>&quot;MULTIPLE AWARD…</td><td>&quot;&quot;</td><td>&quot;05621Z8009KXLA…</td></tr><tr><td>&quot;Pending&quot;</td><td>&quot;Expense&quot;</td><td>&quot;&quot;</td><td>&quot;ANIMAL MEDICAL…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;&quot;</td><td>&quot;CTR05620217207…</td><td>&quot;MMA10562021620…</td><td>&quot;3&quot;</td><td>&quot;WORK/LABOR&quot;</td><td>&quot;VET SERVICES F…</td><td>&quot;Professional S…</td><td>&quot; $331,471.13 &quot;</td><td>&quot; $91,471.13 &quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;11/18/2022&quot;</td><td>&quot;MULTIPLE AWARD…</td><td>&quot;&quot;</td><td>&quot;05621Z8008KXLA…</td></tr><tr><td>&quot;Pending&quot;</td><td>&quot;Expense&quot;</td><td>&quot;&quot;</td><td>&quot;ANIMAL MEDICAL…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;&quot;</td><td>&quot;CTR05620217207…</td><td>&quot;MMA10562021620…</td><td>&quot;1&quot;</td><td>&quot;WORK/LABOR&quot;</td><td>&quot;VET SERVICES F…</td><td>&quot;Professional S…</td><td>&quot; $55,186.28 &quot;</td><td>&quot; $13,537.88 &quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;11/18/2022&quot;</td><td>&quot;MULTIPLE AWARD…</td><td>&quot;&quot;</td><td>&quot;05621Z8007KXLA…</td></tr><tr><td>&quot;Pending&quot;</td><td>&quot;Expense&quot;</td><td>&quot;&quot;</td><td>&quot;THOMAS J MORRI…</td><td>null</td><td>&quot;Non-M/WBE&quot;</td><td>&quot;No &quot;</td><td>&quot;No &quot;</td><td>&quot;Police Departm…</td><td>&quot;&quot;</td><td>&quot;CT105620231406…</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;SUPPLIES/MATER…</td><td>&quot;FEDERAL AMMUNI…</td><td>&quot;Goods&quot;</td><td>&quot; $35,687.16 &quot;</td><td>&quot; $35,687.16 &quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;&quot;</td><td>&quot;11/17/2022&quot;</td><td>&quot;SMALL PURCHASE…</td><td>&quot;&quot;</td><td>&quot;235640127&quot;</td></tr></tbody></table></div>"
      ],
      "text/plain": [
       "shape: (17_809, 25)\n",
       "┌───────────┬──────────┬────────────┬───────────┬───┬────────────┬────────────┬─────────┬──────────┐\n",
       "│ Status    ┆ Category ┆ Vendor     ┆ Vendor    ┆ … ┆ Received   ┆ Award      ┆ APT PIN ┆ PIN      │\n",
       "│ ---       ┆ ---      ┆ Record     ┆ ---       ┆   ┆ date       ┆ Method     ┆ ---     ┆ ---      │\n",
       "│ str       ┆ str      ┆ Type       ┆ str       ┆   ┆ ---        ┆ ---        ┆ str     ┆ str      │\n",
       "│           ┆          ┆ ---        ┆           ┆   ┆ str        ┆ str        ┆         ┆          │\n",
       "│           ┆          ┆ str        ┆           ┆   ┆            ┆            ┆         ┆          │\n",
       "╞═══════════╪══════════╪════════════╪═══════════╪═══╪════════════╪════════════╪═════════╪══════════╡\n",
       "│ Registere ┆ Expense  ┆ Prime      ┆ PINA M    ┆ … ┆            ┆ SM PURCH   ┆         ┆ 23366012 │\n",
       "│ d         ┆          ┆ Vendor     ┆ INC       ┆   ┆            ┆ GOODS      ┆         ┆ 2        │\n",
       "│           ┆          ┆            ┆           ┆   ┆            ┆ SERVICES   ┆         ┆          │\n",
       "│           ┆          ┆            ┆           ┆   ┆            ┆ 100K       ┆         ┆          │\n",
       "│ Registere ┆ Expense  ┆ Prime      ┆ LIRO      ┆ … ┆            ┆ RENEWAL OF ┆         ┆ 05620P81 │\n",
       "│ d         ┆          ┆ Vendor     ┆ ENGINEERS ┆   ┆            ┆ CONTRACT   ┆         ┆ 48KXLR00 │\n",
       "│           ┆          ┆            ┆ INC       ┆   ┆            ┆            ┆         ┆ 1        │\n",
       "│ Registere ┆ Expense  ┆ Prime      ┆ AMCHAR    ┆ … ┆            ┆ SM PURCH   ┆         ┆ 23370003 │\n",
       "│ d         ┆          ┆ Vendor     ┆ WHOLESALE ┆   ┆            ┆ GOODS      ┆         ┆ 1        │\n",
       "│           ┆          ┆            ┆ INC       ┆   ┆            ┆ SERVICES   ┆         ┆          │\n",
       "│           ┆          ┆            ┆           ┆   ┆            ┆ 100K       ┆         ┆          │\n",
       "│ Registere ┆ Expense  ┆ Prime      ┆ ADVANTAGE ┆ … ┆            ┆ SM PURCH   ┆         ┆ 23358001 │\n",
       "│ d         ┆          ┆ Vendor     ┆ TRAVEL    ┆   ┆            ┆ GOODS      ┆         ┆ 5        │\n",
       "│           ┆          ┆            ┆ INC       ┆   ┆            ┆ SERVICES   ┆         ┆          │\n",
       "│           ┆          ┆            ┆           ┆   ┆            ┆ 100K       ┆         ┆          │\n",
       "│ …         ┆ …        ┆ …          ┆ …         ┆ … ┆ …          ┆ …          ┆ …       ┆ …        │\n",
       "│ Pending   ┆ Expense  ┆            ┆ ANIMAL    ┆ … ┆ 11/18/2022 ┆ MULTIPLE   ┆         ┆ 05621Z80 │\n",
       "│           ┆          ┆            ┆ MEDICAL   ┆   ┆            ┆ AWARDS     ┆         ┆ 09KXLA00 │\n",
       "│           ┆          ┆            ┆ CENTER    ┆   ┆            ┆            ┆         ┆ 2        │\n",
       "│ Pending   ┆ Expense  ┆            ┆ ANIMAL    ┆ … ┆ 11/18/2022 ┆ MULTIPLE   ┆         ┆ 05621Z80 │\n",
       "│           ┆          ┆            ┆ MEDICAL   ┆   ┆            ┆ AWARDS     ┆         ┆ 08KXLA00 │\n",
       "│           ┆          ┆            ┆ CENTER    ┆   ┆            ┆            ┆         ┆ 1        │\n",
       "│ Pending   ┆ Expense  ┆            ┆ ANIMAL    ┆ … ┆ 11/18/2022 ┆ MULTIPLE   ┆         ┆ 05621Z80 │\n",
       "│           ┆          ┆            ┆ MEDICAL   ┆   ┆            ┆ AWARDS     ┆         ┆ 07KXLA00 │\n",
       "│           ┆          ┆            ┆ CENTER    ┆   ┆            ┆            ┆         ┆ 2        │\n",
       "│ Pending   ┆ Expense  ┆            ┆ THOMAS J  ┆ … ┆ 11/17/2022 ┆ SMALL      ┆         ┆ 23564012 │\n",
       "│           ┆          ┆            ┆ MORRIS JR ┆   ┆            ┆ PURCHASE   ┆         ┆ 7        │\n",
       "│           ┆          ┆            ┆           ┆   ┆            ┆ GOOD AND   ┆         ┆          │\n",
       "│           ┆          ┆            ┆           ┆   ┆            ┆ SERVICES…  ┆         ┆          │\n",
       "└───────────┴──────────┴────────────┴───────────┴───┴────────────┴────────────┴─────────┴──────────┘"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "contracts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<style>\n",
       "  #altair-viz-b13c8eabd1204eb1a6579a760bf59ace.vega-embed {\n",
       "    width: 100%;\n",
       "    display: flex;\n",
       "  }\n",
       "\n",
       "  #altair-viz-b13c8eabd1204eb1a6579a760bf59ace.vega-embed details,\n",
       "  #altair-viz-b13c8eabd1204eb1a6579a760bf59ace.vega-embed details summary {\n",
       "    position: relative;\n",
       "  }\n",
       "</style>\n",
       "<div id=\"altair-viz-b13c8eabd1204eb1a6579a760bf59ace\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-b13c8eabd1204eb1a6579a760bf59ace\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-b13c8eabd1204eb1a6579a760bf59ace\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm/vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm/vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm/vega-lite@5.8.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm/vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"5.8.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"$schema\": \"https://vega.github.io/schema/vega/v5.json\", \"data\": [{\"name\": \"source_0\", \"values\": [{\"Agency\": \"Police Department\", \"__count\": 17808}, {\"Agency\": \"\", \"__count\": 1}]}, {\"name\": \"source_0_x_domain_Agency\", \"values\": [{\"Agency\": \"Police Department\"}, {\"Agency\": \"\"}]}, {\"name\": \"source_0_y_domain___count\", \"values\": [{\"min\": 1, \"max\": 17808}]}], \"signals\": [{\"name\": \"x_step\", \"value\": 20}, {\"name\": \"width\", \"update\": \"bandspace(domain('x').length, 0.1, 0.05) * x_step\"}], \"marks\": [{\"type\": \"rect\", \"name\": \"marks\", \"from\": {\"data\": \"source_0\"}, \"encode\": {\"update\": {\"fill\": {\"value\": \"#4c78a8\"}, \"x\": {\"field\": \"Agency\", \"scale\": \"x\"}, \"width\": {\"signal\": \"max(0.25, bandwidth('x'))\"}, \"y\": {\"field\": \"__count\", \"scale\": \"y\"}, \"ariaRoleDescription\": {\"value\": \"bar\"}, \"description\": {\"signal\": \"\\\"Agency: \\\" + (isValid(datum[\\\"Agency\\\"]) ? datum[\\\"Agency\\\"] : \\\"\\\"+datum[\\\"Agency\\\"]) + \\\"; Count of Records: \\\" + (format(datum[\\\"__count\\\"], \\\"\\\"))\"}, \"y2\": {\"value\": 0, \"scale\": \"y\"}}}, \"style\": [\"bar\"]}], \"scales\": [{\"name\": \"x\", \"type\": \"band\", \"domain\": {\"data\": \"source_0_x_domain_Agency\", \"field\": \"Agency\", \"sort\": true}, \"range\": {\"step\": {\"signal\": \"x_step\"}}, \"paddingOuter\": 0.05, \"paddingInner\": 0.1}, {\"name\": \"y\", \"type\": \"linear\", \"domain\": [{\"signal\": \"(data(\\\"source_0_y_domain___count\\\")[0] || {}).min\"}, {\"signal\": \"(data(\\\"source_0_y_domain___count\\\")[0] || {}).max\"}], \"range\": [{\"signal\": \"height\"}, 0], \"zero\": true, \"nice\": true}], \"axes\": [{\"scale\": \"y\", \"labels\": false, \"aria\": false, \"ticks\": false, \"minExtent\": 0, \"zindex\": 0, \"domain\": false, \"gridScale\": \"x\", \"tickCount\": {\"signal\": \"ceil(height/40)\"}, \"orient\": \"left\", \"grid\": true, \"maxExtent\": 0}, {\"scale\": \"x\", \"orient\": \"bottom\", \"grid\": false, \"title\": \"Agency\", \"labelAngle\": 270, \"labelBaseline\": \"middle\", \"zindex\": 0, \"labelAlign\": \"right\"}, {\"scale\": \"y\", \"zindex\": 0, \"grid\": false, \"orient\": \"left\", \"labelOverlap\": true, \"tickCount\": {\"signal\": \"ceil(height/40)\"}, \"title\": \"Count of Records\"}], \"style\": \"cell\", \"padding\": 5, \"background\": \"white\", \"height\": 300}, {\"mode\": \"vega\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a bar chart\n",
    "alt.Chart(contracts).mark_bar().encode(\n",
    "    x='Agency:N',\n",
    "    y='count()',\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<style>\n",
       "  #altair-viz-196a9e2f749b4747aad5fcfa71712511.vega-embed {\n",
       "    width: 100%;\n",
       "    display: flex;\n",
       "  }\n",
       "\n",
       "  #altair-viz-196a9e2f749b4747aad5fcfa71712511.vega-embed details,\n",
       "  #altair-viz-196a9e2f749b4747aad5fcfa71712511.vega-embed details summary {\n",
       "    position: relative;\n",
       "  }\n",
       "</style>\n",
       "<div id=\"altair-viz-196a9e2f749b4747aad5fcfa71712511\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-196a9e2f749b4747aad5fcfa71712511\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-196a9e2f749b4747aad5fcfa71712511\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm/vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm/vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm/vega-lite@5.8.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm/vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"5.8.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"$schema\": \"https://vega.github.io/schema/vega/v5.json\", \"data\": [{\"name\": \"source_0\", \"values\": [{\"M/WBE Category\": \"Women (Non-Minority)\", \"__count\": 927}, {\"M/WBE Category\": \"Non-M/WBE\", \"__count\": 15534}, {\"M/WBE Category\": \"Asian American\", \"__count\": 367}, {\"M/WBE Category\": \"Hispanic American\", \"__count\": 419}, {\"M/WBE Category\": \"Black American\", \"__count\": 459}, {\"M/WBE Category\": \"Individuals & Others\", \"__count\": 102}, {\"M/WBE Category\": \"\", \"__count\": 1}]}, {\"name\": \"source_0_x_domain_M/WBE Category\", \"values\": [{\"M/WBE Category\": \"Women (Non-Minority)\"}, {\"M/WBE Category\": \"Non-M/WBE\"}, {\"M/WBE Category\": \"Asian American\"}, {\"M/WBE Category\": \"Hispanic American\"}, {\"M/WBE Category\": \"Black American\"}, {\"M/WBE Category\": \"Individuals & Others\"}, {\"M/WBE Category\": \"\"}]}, {\"name\": \"source_0_y_domain___count\", \"values\": [{\"min\": 1, \"max\": 15534}]}], \"signals\": [{\"name\": \"x_step\", \"value\": 20}, {\"name\": \"width\", \"update\": \"bandspace(domain('x').length, 0.1, 0.05) * x_step\"}], \"marks\": [{\"type\": \"rect\", \"name\": \"marks\", \"from\": {\"data\": \"source_0\"}, \"encode\": {\"update\": {\"description\": {\"signal\": \"\\\"M/WBE Category: \\\" + (isValid(datum[\\\"M/WBE Category\\\"]) ? datum[\\\"M/WBE Category\\\"] : \\\"\\\"+datum[\\\"M/WBE Category\\\"]) + \\\"; Count of Records: \\\" + (format(datum[\\\"__count\\\"], \\\"\\\"))\"}, \"y\": {\"field\": \"__count\", \"scale\": \"y\"}, \"width\": {\"signal\": \"max(0.25, bandwidth('x'))\"}, \"y2\": {\"value\": 0, \"scale\": \"y\"}, \"x\": {\"field\": \"M/WBE Category\", \"scale\": \"x\"}, \"fill\": {\"value\": \"#4c78a8\"}, \"ariaRoleDescription\": {\"value\": \"bar\"}}}, \"style\": [\"bar\"]}], \"scales\": [{\"name\": \"x\", \"type\": \"band\", \"domain\": {\"data\": \"source_0_x_domain_M/WBE Category\", \"field\": \"M/WBE Category\", \"sort\": true}, \"range\": {\"step\": {\"signal\": \"x_step\"}}, \"paddingOuter\": 0.05, \"paddingInner\": 0.1}, {\"name\": \"y\", \"type\": \"linear\", \"domain\": [{\"signal\": \"(data(\\\"source_0_y_domain___count\\\")[0] || {}).min\"}, {\"signal\": \"(data(\\\"source_0_y_domain___count\\\")[0] || {}).max\"}], \"range\": [{\"signal\": \"height\"}, 0], \"zero\": true, \"nice\": true}], \"axes\": [{\"scale\": \"y\", \"labels\": false, \"minExtent\": 0, \"aria\": false, \"zindex\": 0, \"tickCount\": {\"signal\": \"ceil(height/40)\"}, \"maxExtent\": 0, \"gridScale\": \"x\", \"ticks\": false, \"grid\": true, \"domain\": false, \"orient\": \"left\"}, {\"scale\": \"x\", \"labelAlign\": \"right\", \"title\": \"M/WBE Category\", \"labelAngle\": 270, \"labelBaseline\": \"middle\", \"orient\": \"bottom\", \"grid\": false, \"zindex\": 0}, {\"scale\": \"y\", \"orient\": \"left\", \"labelOverlap\": true, \"title\": \"Count of Records\", \"grid\": false, \"tickCount\": {\"signal\": \"ceil(height/40)\"}, \"zindex\": 0}], \"style\": \"cell\", \"height\": 300, \"padding\": 5, \"background\": \"white\"}, {\"mode\": \"vega\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a bar chart\n",
    "alt.Chart(contracts).mark_bar().encode(\n",
    "    x='M/WBE Category:N',\n",
    "    y='count()',\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<style>\n",
       "  #altair-viz-706e687ed1d64df18964674e7efc50da.vega-embed {\n",
       "    width: 100%;\n",
       "    display: flex;\n",
       "  }\n",
       "\n",
       "  #altair-viz-706e687ed1d64df18964674e7efc50da.vega-embed details,\n",
       "  #altair-viz-706e687ed1d64df18964674e7efc50da.vega-embed details summary {\n",
       "    position: relative;\n",
       "  }\n",
       "</style>\n",
       "<div id=\"altair-viz-706e687ed1d64df18964674e7efc50da\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-706e687ed1d64df18964674e7efc50da\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-706e687ed1d64df18964674e7efc50da\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm/vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm/vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm/vega-lite@5.8.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm/vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"5.8.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"$schema\": \"https://vega.github.io/schema/vega/v5.json\", \"data\": [{\"name\": \"source_0\", \"values\": [{\"Expense Category\": \"EQUIPMENT GENERAL\", \"__count\": 3035}, {\"Expense Category\": \"PROF SERV ENGINEER & ARCHITECT\", \"__count\": 8}, {\"Expense Category\": \"SUPPLIES + MATERIALS - GENERAL\", \"__count\": 7245}, {\"Expense Category\": \"OVERNIGHT TRVL EXP-GENERAL\", \"__count\": 6}, {\"Expense Category\": \"MAINT & OPER OF INFRASTRUCTURE\", \"__count\": 334}, {\"Expense Category\": \"ADVERTISING\", \"__count\": 7}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL\", \"__count\": 333}, {\"Expense Category\": \"PROF SERV OTHER\", \"__count\": 55}, {\"Expense Category\": \"PURCH DATA PROCESSING EQUIPT\", \"__count\": 486}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT\", \"__count\": 195}, {\"Expense Category\": \"MISCELLANEOUS AWARDS\", \"__count\": 70}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE\", \"__count\": 414}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES\", \"__count\": 350}, {\"Expense Category\": \"\", \"__count\": 43}, {\"Expense Category\": \"OTHR SERV AND CHRGS-GENERAL\", \"__count\": 129}, {\"Expense Category\": \"MEDICAL SURGICAL & LAB SUPPLY\", \"__count\": 246}, {\"Expense Category\": \"MAINT & OPER OF INFRASTRUCTURE  MAINT & REP GENERAL\", \"__count\": 5}, {\"Expense Category\": \"MAINT & REP GENERAL\", \"__count\": 300}, {\"Expense Category\": \"MOTOR VEHICLES\", \"__count\": 40}, {\"Expense Category\": \"PROF SERV COMPUTER SERVICES\", \"__count\": 56}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS\", \"__count\": 208}, {\"Expense Category\": \"TRAINING PRGM CITY EMPLOYEES\", \"__count\": 286}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  EQUIPMENT GENERAL  PURCH DATA PROCESSING EQUIPT\", \"__count\": 2}, {\"Expense Category\": \"MAINTENANCE SUPPLIES\", \"__count\": 949}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE\", \"__count\": 40}, {\"Expense Category\": \"TEMPORARY SERVICES\", \"__count\": 10}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  EQUIPMENT GENERAL\", \"__count\": 49}, {\"Expense Category\": \"MEDICAL SURGICAL & LAB EQUIP\", \"__count\": 63}, {\"Expense Category\": \"MAINT & REP MOTOR VEH EQUIP\", \"__count\": 115}, {\"Expense Category\": \"CLEANING SERVICES\", \"__count\": 29}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES\", \"__count\": 11}, {\"Expense Category\": \"EDUCATION & REC FOR YOUTH PRGM\", \"__count\": 9}, {\"Expense Category\": \"BOOKS-OTHER\", \"__count\": 32}, {\"Expense Category\": \"TRANSPORTATION EXPENDITURES\", \"__count\": 16}, {\"Expense Category\": \"FOOD & FORAGE SUPPLIES\", \"__count\": 165}, {\"Expense Category\": \"EQUIPMENT GENERAL  MEDICAL SURGICAL & LAB EQUIP\", \"__count\": 11}, {\"Expense Category\": \"SECURITY SERVICES\", \"__count\": 13}, {\"Expense Category\": \"MAINT & REP GENERAL  SUPPLIES + MATERIALS - GENERAL  TRAINING PRGM CITY EMPLOYEES\", \"__count\": 2}, {\"Expense Category\": \"OFFICE FURITURE\", \"__count\": 52}, {\"Expense Category\": \"PRINTING SUPPLIES\", \"__count\": 18}, {\"Expense Category\": \"RENTALS - LAND BLDGS & STRUCTS\", \"__count\": 69}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  PURCH DATA PROCESSING EQUIPT\", \"__count\": 14}, {\"Expense Category\": \"MAINT & OPER OF INFRASTRUCTURE  RENTALS OF MISC.EQUIP\", \"__count\": 10}, {\"Expense Category\": \"CAPITAL ONLY FUNDED SBITA  PROF SERV COMPUTER SERVICES\", \"__count\": 1}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  MAINT & OPER OF INFRASTRUCTURE\", \"__count\": 21}, {\"Expense Category\": \"RENTALS OF MISC.EQUIP\", \"__count\": 40}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  MAINT & OPER OF INFRASTRUCTURE\", \"__count\": 5}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 2}, {\"Expense Category\": \"EQUIPMENT GENERAL  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 97}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  PROF SERV COMPUTER SERVICES\", \"__count\": 8}, {\"Expense Category\": \"OFFICE EQUIPMENT MAINTENANCE\", \"__count\": 38}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  TELECOMMUNICATIONS MAINT\", \"__count\": 4}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  DESIGN-CONSULTANT-BUILDINGS\", \"__count\": 1}, {\"Expense Category\": \"OVERNIGHT TRVL EXP-GENERAL  OVERNIGHT TRVL EXP-SPECIAL\", \"__count\": 5}, {\"Expense Category\": \"TELECOMMUNICATIONS MAINT\", \"__count\": 46}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  OTHR SERV AND CHRGS-GENERAL\", \"__count\": 6}, {\"Expense Category\": \"AUTOMOTIVE SUPPLIES & MATERIAL\", \"__count\": 81}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL  PROF SERV COMPUTER SERVICES  TRAINING PRGM CITY EMPLOYEES\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  TELECOMMUNICATIONS EQUIPMENT\", \"__count\": 1}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  MAINT & REP GENERAL\", \"__count\": 1}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES\", \"__count\": 2}, {\"Expense Category\": \"EQUIPMENT GENERAL  OFFICE FURITURE\", \"__count\": 1}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  MAINT & REP GENERAL\", \"__count\": 11}, {\"Expense Category\": \"TELEPHONE & OTHER COMMUNICATNS\", \"__count\": 39}, {\"Expense Category\": \"PROF SERV OTHER  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 4}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES  TRAINING PRGM CITY EMPLOYEES\", \"__count\": 2}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  CONTRACTUAL SERVICES GENERAL  DESIGN-CONSULTANT-BUILDINGS  DESIGN-CONSULTANT-IOTB  IOTB CONSTRUCTION  MAINT & OPER OF INFRASTRUCTURE  OTHR SERV AND CHRGS-GENERAL  PROF SERV ENGINEER & ARCHITECT\", \"__count\": 5}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  DESIGN-CONSULTANT-BUILDINGS  MAINT & OPER OF INFRASTRUCTURE  OTHR SERV AND CHRGS-GENERAL  PROF SERV ENGINEER & ARCHITECT\", \"__count\": 1}, {\"Expense Category\": \"TELECOMMUNICATIONS EQUIPMENT\", \"__count\": 68}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  OTHR SERV AND CHRGS-GENERAL\", \"__count\": 7}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL\", \"__count\": 3}, {\"Expense Category\": \"MAINT & REP GENERAL  MAINT & REP MOTOR VEH EQUIP\", \"__count\": 3}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  CONTRACTUAL SERVICES GENERAL\", \"__count\": 4}, {\"Expense Category\": \"PROF SERV LEGAL SERVICES\", \"__count\": 8}, {\"Expense Category\": \"PROF SERV COMPUTER SERVICES  PURCH DATA PROCESSING EQUIPT\", \"__count\": 4}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  PURCH DATA PROCESSING EQUIPT\", \"__count\": 18}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  PROF SERV COMPUTER SERVICES  PURCH DATA PROCESSING EQUIPT\", \"__count\": 2}, {\"Expense Category\": \"IOTB CONSTRUCTION  LEASEHOLD IMP CONSTRUCTION  RENTALS - LAND BLDGS & STRUCTS\", \"__count\": 1}, {\"Expense Category\": \"EQUIPMENT GENERAL  MOTOR VEHICLES\", \"__count\": 1}, {\"Expense Category\": \"OFFICE EQUIPMENT\", \"__count\": 59}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES  PURCH DATA PROCESSING EQUIPT\", \"__count\": 1}, {\"Expense Category\": \"LEASEHOLD IMP CONSTRUCTION  RENTALS - LAND BLDGS & STRUCTS\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  CONSTRUCTION-BUILDINGS  DESIGN-CONSULTANT-BUILDINGS  MAINT & OPER OF INFRASTRUCTURE  POLLUTION REMEDIATION OBLIGATIONS  PROF SERV ENGINEER & ARCHITECT\", \"__count\": 9}, {\"Expense Category\": \"SECURITY EQUIPMENT\", \"__count\": 5}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  DESIGN-CONSULTANT-BUILDINGS  DESIGN-CONSULTANT-IOTB  IOTB CONSTRUCTION  MAINT & OPER OF INFRASTRUCTURE  PROF SERV ENGINEER & ARCHITECT\", \"__count\": 1}, {\"Expense Category\": \"DESIGN-CONSULTANT-BUILDINGS  DESIGN-CONSULTANT-IOTB  IOTB CONSTRUCTION  MAINT & OPER OF INFRASTRUCTURE  PROF SERV ENGINEER & ARCHITECT\", \"__count\": 22}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  PROF SERV COMPUTER SERVICES\", \"__count\": 10}, {\"Expense Category\": \"MAINTENANCE SUPPLIES  MAINT & OPER OF INFRASTRUCTURE\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  MAINT & REP GENERAL  PURCH DATA PROCESSING EQUIPT\", \"__count\": 1}, {\"Expense Category\": \"DESIGN-CONSULTANT-BUILDINGS\", \"__count\": 14}, {\"Expense Category\": \"EQUIPMENT GENERAL  MAINT & REP MOTOR VEH EQUIP\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES\", \"__count\": 5}, {\"Expense Category\": \"LEASING OF MISC EQUIP\", \"__count\": 19}, {\"Expense Category\": \"CLEANING SERVICES  RENTALS OF MISC.EQUIP\", \"__count\": 2}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  EQUIPMENT GENERAL\", \"__count\": 5}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  MAINT & OPER OF INFRASTRUCTURE  POLLUTION REMEDIATION OBLIGATIONS\", \"__count\": 1}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  POLLUTION REMEDIATION OBLIGATIONS\", \"__count\": 15}, {\"Expense Category\": \"MEDICAL SURGICAL & LAB SUPPLY  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 4}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  OTHR SERV AND CHRGS-GENERAL  PROF SERV COMPUTER SERVICES\", \"__count\": 1}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  MAINT & REP GENERAL  OTHR SERV AND CHRGS-GENERAL\", \"__count\": 1}, {\"Expense Category\": \"OTHR SERV AND CHRGS-GENERAL  OVERNIGHT TRVL EXP-GENERAL\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  PROF SERV COMPUTER SERVICES  PURCH DATA PROCESSING EQUIPT  TRAINING PRGM CITY EMPLOYEES\", \"__count\": 1}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  OTHR SERV AND CHRGS-GENERAL\", \"__count\": 4}, {\"Expense Category\": \"OTHR SERV AND CHRGS-GENERAL  PROF SERV OTHER\", \"__count\": 5}, {\"Expense Category\": \"MEDICAL SURGICAL & LAB SUPPLY  PROF SERV OTHER\", \"__count\": 1}, {\"Expense Category\": \"IOTB CONSTRUCTION  MAINT & OPER OF INFRASTRUCTURE\", \"__count\": 4}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES\", \"__count\": 2}, {\"Expense Category\": \"LIBRARY BOOKS\", \"__count\": 18}, {\"Expense Category\": \"MAINT & REP GENERAL  MEDICAL SURGICAL & LAB SUPPLY  PROF SERV OTHER  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 1}, {\"Expense Category\": \"MAINT & REP GENERAL  MEDICAL SURGICAL & LAB SUPPLY  PROF SERV OTHER\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES\", \"__count\": 2}, {\"Expense Category\": \"IOTB CONSTRUCTION\", \"__count\": 3}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  IOTB CONSTRUCTION\", \"__count\": 4}, {\"Expense Category\": \"EQUIPMENT GENERAL  OTHR SERV AND CHRGS-GENERAL\", \"__count\": 1}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  CONTRACTUAL SERVICES GENERAL\", \"__count\": 9}, {\"Expense Category\": \"OVERNIGHT TRVL EXP-SPECIAL  PROF SERV OTHER\", \"__count\": 1}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  IOTB CONSTRUCTION  MAINT & OPER OF INFRASTRUCTURE\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  CLEANING SERVICES  CONSTRUCTION-BUILDINGS  CONTRACTUAL SERVICES GENERAL  DESIGN-CONSULTANT-BUILDINGS  IOTB CONSTRUCTION  MAINT & OPER OF INFRASTRUCTURE  POLLUTION REMEDIATION OBLIGATIONS  PROF SERV ENGINEER & ARCHITECT\", \"__count\": 24}, {\"Expense Category\": \"ADVERTISING  CONTRACTUAL SERVICES GENERAL\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES  PURCH DATA PROCESSING EQUIPT  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 3}, {\"Expense Category\": \"OVERNIGHT TRVL EXP-SPECIAL\", \"__count\": 1}, {\"Expense Category\": \"MAINT & REP GENERAL  OTHR SERV AND CHRGS-GENERAL\", \"__count\": 3}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  PROF SERV COMPUTER SERVICES\", \"__count\": 10}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  TRAINING PRGM CITY EMPLOYEES\", \"__count\": 2}, {\"Expense Category\": \"EQUIPMENT GENERAL  TELECOMMUNICATIONS EQUIPMENT\", \"__count\": 4}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  MAINT & OPER OF INFRASTRUCTURE  PURCH DATA PROCESSING EQUIPT\", \"__count\": 4}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 1}, {\"Expense Category\": \"OTHR SERV AND CHRGS-GENERAL  RENTALS - LAND BLDGS & STRUCTS\", \"__count\": 2}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  EQUIPMENT GENERAL  MAINT & REP GENERAL  SUPPLIES + MATERIALS - GENERAL  TRAINING PRGM CITY EMPLOYEES\", \"__count\": 1}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  MAINT & REP MOTOR VEH EQUIP\", \"__count\": 1}, {\"Expense Category\": \"POSTAGE\", \"__count\": 6}, {\"Expense Category\": \"PRINTING CONTRACTS\", \"__count\": 19}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  EQUIPMENT GENERAL  TELECOMMUNICATIONS MAINT\", \"__count\": 1}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  EQUIPMENT GENERAL\", \"__count\": 2}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  PROF SERV OTHER\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING SUPPLIES\", \"__count\": 1}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  IOTB SITE ACQUISITION\", \"__count\": 1}, {\"Expense Category\": \"MOTOR VEHICLE FUEL\", \"__count\": 8}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  EQUIPMENT GENERAL  MAINT & OPER OF INFRASTRUCTURE\", \"__count\": 1}, {\"Expense Category\": \"BOOKS-OTHER  TRAINING PRGM CITY EMPLOYEES\", \"__count\": 1}, {\"Expense Category\": \"EQUIPMENT GENERAL  MAINT & REP GENERAL\", \"__count\": 5}, {\"Expense Category\": \"OFF SVC-MEMBERSHIP DUES & FEES\", \"__count\": 145}, {\"Expense Category\": \"MAINT & REP GENERAL  OFFICE EQUIPMENT MAINTENANCE\", \"__count\": 4}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  MAINT & OPER OF INFRASTRUCTURE  OTHR SERV AND CHRGS-GENERAL\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  PURCH DATA PROCESSING EQUIPT\", \"__count\": 4}, {\"Expense Category\": \"CLEANING SERVICES  CONTRACTUAL SERVICES GENERAL\", \"__count\": 1}, {\"Expense Category\": \"MAINT & OPER OF INFRASTRUCTURE  OTHR SERV AND CHRGS-GENERAL\", \"__count\": 1}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  OTHR SERV AND CHRGS-GENERAL\", \"__count\": 1}, {\"Expense Category\": \"EDUCATION & REC FOR YOUTH PRGM  FOOD & FORAGE SUPPLIES\", \"__count\": 1}, {\"Expense Category\": \"EQUIPMENT GENERAL  PURCH DATA PROCESSING EQUIPT\", \"__count\": 3}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL  LIBRARY BOOKS  MAINT & REP GENERAL  MAINT & REP MOTOR VEH EQUIP  MEDICAL SURGICAL & LAB EQUIP  MEDICAL SURGICAL & LAB SUPPLY  OFFICE EQUIPMENT  OFF SVC-MEMBERSHIP DUES & FEES  OVERNIGHT TRVL EXP-GENERAL  POSTAGE  PROF SERV OTHER  RENTALS OF MISC.EQUIP  SUPPLIES + MATERIALS - GENERAL  TRAINING PRGM CITY EMPLOYEES\", \"__count\": 2}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  PROF SERV COMPUTER SERVICES\", \"__count\": 3}, {\"Expense Category\": \"EQUIPMENT GENERAL  MAINTENANCE SUPPLIES\", \"__count\": 3}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  TRAINING PRGM CITY EMPLOYEES\", \"__count\": 1}, {\"Expense Category\": \"EQUIPMENT GENERAL  MAINT & REP GENERAL  MEDICAL SURGICAL & LAB EQUIP  MEDICAL SURGICAL & LAB SUPPLY  PROF SERV OTHER  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  PAY FOR SURETY BOND/INSUR PREM\", \"__count\": 1}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL  LIBRARY BOOKS  MAINT & REP GENERAL  MEDICAL SURGICAL & LAB SUPPLY  OTHR SERV AND CHRGS-GENERAL  OVERNIGHT TRVL EXP-GENERAL  POSTAGE  PROF SERV OTHER  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  CONTRACTUAL SERVICES GENERAL  DATA PROCESSING EQUIPMENT MAINTENANCE  MAINT & REP GENERAL  OVERNIGHT TRVL EXP-SPECIAL  PAY FOR SURETY BOND/INSUR PREM  TRAINING PRGM CITY EMPLOYEES\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  PROF SERV COMPUTER SERVICES  PROF SERV OTHER\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  MOTOR VEHICLES\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DESIGN-CONSULTANT-BUILDINGS  PURCH DATA PROCESSING EQUIPT\", \"__count\": 1}, {\"Expense Category\": \"DONAT PAT INMATE & DISCHG PRIS\", \"__count\": 1142}, {\"Expense Category\": \"MAINT & REP GENERAL  TELECOMMUNICATIONS MAINT\", \"__count\": 2}, {\"Expense Category\": \"MAINT & REP GENERAL  TELECOMMUNICATIONS EQUIPMENT\", \"__count\": 1}, {\"Expense Category\": \"CLEANING SUPPLIES\", \"__count\": 19}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  TRAINING PRGM CITY EMPLOYEES\", \"__count\": 2}, {\"Expense Category\": \"EQUIPMENT GENERAL  OFFICE EQUIPMENT  OTHR SERV AND CHRGS-GENERAL\", \"__count\": 1}, {\"Expense Category\": \"OFF SVC-MEMBERSHIP DUES & FEES  OTHR SERV AND CHRGS-GENERAL\", \"__count\": 1}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES\", \"__count\": 5}, {\"Expense Category\": \"BOOKS-OTHER  CONTRACTUAL SERVICES GENERAL  DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL  OFFICE FURITURE  OFF SVC-MEMBERSHIP DUES & FEES  PURCH DATA PROCESSING EQUIPT  SUPPLIES + MATERIALS - GENERAL  TELECOMMUNICATIONS EQUIPMENT  TELEPHONE & OTHER COMMUNICATNS  TRAINING PRGM CITY EMPLOYEES\", \"__count\": 1}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  TELECOMMUNICATIONS MAINT\", \"__count\": 2}, {\"Expense Category\": \"MAINTENANCE SUPPLIES  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  CONTRACTUAL SERVICES GENERAL  DATA PROCESSING EQUIPMENT MAINTENANCE  PROF SERV COMPUTER SERVICES\", \"__count\": 1}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL  PROF SERV COMPUTER SERVICES\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL ONLY FUNDED SBITA  DATA PROCESSING EQUIPMENT MAINTENANCE\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  PURCH DATA PROCESSING EQUIPT\", \"__count\": 5}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PURCH DATA PROCESSING EQUIPT\", \"__count\": 4}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL  PURCH DATA PROCESSING EQUIPT\", \"__count\": 2}, {\"Expense Category\": \"OFF SVC-MEMBERSHIP DUES & FEES  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 2}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  CONTRACTUAL SERVICES GENERAL  DATA PROCESSING EQUIPMENT MAINTENANCE  PURCH DATA PROCESSING EQUIPT\", \"__count\": 2}, {\"Expense Category\": \"PURCH DATA PROCESSING EQUIPT  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PURCH DATA PROCESSING EQUIPT  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PURCH DATA PROCESSING EQUIPT\", \"__count\": 1}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL  PURCH DATA PROCESSING EQUIPT  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 1}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  TELECOMMUNICATIONS EQUIPMENT\", \"__count\": 1}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  TRAINING PRGM CITY EMPLOYEES\", \"__count\": 2}, {\"Expense Category\": \"OFFICE EQUIPMENT  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 1}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES  PURCH DATA PROCESSING EQUIPT\", \"__count\": 3}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PURCH DATA PROCESSING EQUIPT  TELEPHONE & OTHER COMMUNICATNS\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES  PURCH DATA PROCESSING EQUIPT  TRAINING PRGM CITY EMPLOYEES\", \"__count\": 1}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  TELECOMMUNICATIONS EQUIPMENT\", \"__count\": 1}, {\"Expense Category\": \"SUPPLIES + MATERIALS - GENERAL--WTC ONLY\", \"__count\": 1}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  EQUIPMENT GENERAL\", \"__count\": 1}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  MAINT & REP GENERAL  OFFICE EQUIPMENT MAINTENANCE\", \"__count\": 2}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  OFFICE EQUIPMENT MAINTENANCE\", \"__count\": 3}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  OTHR SERV AND CHRGS-GENERAL  PURCH DATA PROCESSING EQUIPT\", \"__count\": 1}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  PURCH DATA PROCESSING EQUIPT  TELECOMMUNICATIONS MAINT\", \"__count\": 1}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  DATA PROCESSING SUPPLIES\", \"__count\": 1}, {\"Expense Category\": \"EQUIPMENT GENERAL  SECURITY EQUIPMENT  SUPPLIES + MATERIALS - GENERAL\", \"__count\": 1}]}, {\"name\": \"source_0_x_domain_Expense Category\", \"values\": [{\"Expense Category\": \"EQUIPMENT GENERAL\"}, {\"Expense Category\": \"PROF SERV ENGINEER & ARCHITECT\"}, {\"Expense Category\": \"SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"OVERNIGHT TRVL EXP-GENERAL\"}, {\"Expense Category\": \"MAINT & OPER OF INFRASTRUCTURE\"}, {\"Expense Category\": \"ADVERTISING\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL\"}, {\"Expense Category\": \"PROF SERV OTHER\"}, {\"Expense Category\": \"PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT\"}, {\"Expense Category\": \"MISCELLANEOUS AWARDS\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE\"}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES\"}, {\"Expense Category\": \"\"}, {\"Expense Category\": \"OTHR SERV AND CHRGS-GENERAL\"}, {\"Expense Category\": \"MEDICAL SURGICAL & LAB SUPPLY\"}, {\"Expense Category\": \"MAINT & OPER OF INFRASTRUCTURE  MAINT & REP GENERAL\"}, {\"Expense Category\": \"MAINT & REP GENERAL\"}, {\"Expense Category\": \"MOTOR VEHICLES\"}, {\"Expense Category\": \"PROF SERV COMPUTER SERVICES\"}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS\"}, {\"Expense Category\": \"TRAINING PRGM CITY EMPLOYEES\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  EQUIPMENT GENERAL  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"MAINTENANCE SUPPLIES\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE\"}, {\"Expense Category\": \"TEMPORARY SERVICES\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  EQUIPMENT GENERAL\"}, {\"Expense Category\": \"MEDICAL SURGICAL & LAB EQUIP\"}, {\"Expense Category\": \"MAINT & REP MOTOR VEH EQUIP\"}, {\"Expense Category\": \"CLEANING SERVICES\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES\"}, {\"Expense Category\": \"EDUCATION & REC FOR YOUTH PRGM\"}, {\"Expense Category\": \"BOOKS-OTHER\"}, {\"Expense Category\": \"TRANSPORTATION EXPENDITURES\"}, {\"Expense Category\": \"FOOD & FORAGE SUPPLIES\"}, {\"Expense Category\": \"EQUIPMENT GENERAL  MEDICAL SURGICAL & LAB EQUIP\"}, {\"Expense Category\": \"SECURITY SERVICES\"}, {\"Expense Category\": \"MAINT & REP GENERAL  SUPPLIES + MATERIALS - GENERAL  TRAINING PRGM CITY EMPLOYEES\"}, {\"Expense Category\": \"OFFICE FURITURE\"}, {\"Expense Category\": \"PRINTING SUPPLIES\"}, {\"Expense Category\": \"RENTALS - LAND BLDGS & STRUCTS\"}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"MAINT & OPER OF INFRASTRUCTURE  RENTALS OF MISC.EQUIP\"}, {\"Expense Category\": \"CAPITAL ONLY FUNDED SBITA  PROF SERV COMPUTER SERVICES\"}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  MAINT & OPER OF INFRASTRUCTURE\"}, {\"Expense Category\": \"RENTALS OF MISC.EQUIP\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  MAINT & OPER OF INFRASTRUCTURE\"}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"EQUIPMENT GENERAL  SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  PROF SERV COMPUTER SERVICES\"}, {\"Expense Category\": \"OFFICE EQUIPMENT MAINTENANCE\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  TELECOMMUNICATIONS MAINT\"}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  DESIGN-CONSULTANT-BUILDINGS\"}, {\"Expense Category\": \"OVERNIGHT TRVL EXP-GENERAL  OVERNIGHT TRVL EXP-SPECIAL\"}, {\"Expense Category\": \"TELECOMMUNICATIONS MAINT\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  OTHR SERV AND CHRGS-GENERAL\"}, {\"Expense Category\": \"AUTOMOTIVE SUPPLIES & MATERIAL\"}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL  PROF SERV COMPUTER SERVICES  TRAINING PRGM CITY EMPLOYEES\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  TELECOMMUNICATIONS EQUIPMENT\"}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  MAINT & REP GENERAL\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES\"}, {\"Expense Category\": \"EQUIPMENT GENERAL  OFFICE FURITURE\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  MAINT & REP GENERAL\"}, {\"Expense Category\": \"TELEPHONE & OTHER COMMUNICATNS\"}, {\"Expense Category\": \"PROF SERV OTHER  SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES  TRAINING PRGM CITY EMPLOYEES\"}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  CONTRACTUAL SERVICES GENERAL  DESIGN-CONSULTANT-BUILDINGS  DESIGN-CONSULTANT-IOTB  IOTB CONSTRUCTION  MAINT & OPER OF INFRASTRUCTURE  OTHR SERV AND CHRGS-GENERAL  PROF SERV ENGINEER & ARCHITECT\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  DESIGN-CONSULTANT-BUILDINGS  MAINT & OPER OF INFRASTRUCTURE  OTHR SERV AND CHRGS-GENERAL  PROF SERV ENGINEER & ARCHITECT\"}, {\"Expense Category\": \"TELECOMMUNICATIONS EQUIPMENT\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  OTHR SERV AND CHRGS-GENERAL\"}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL\"}, {\"Expense Category\": \"MAINT & REP GENERAL  MAINT & REP MOTOR VEH EQUIP\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  CONTRACTUAL SERVICES GENERAL\"}, {\"Expense Category\": \"PROF SERV LEGAL SERVICES\"}, {\"Expense Category\": \"PROF SERV COMPUTER SERVICES  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  PROF SERV COMPUTER SERVICES  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"IOTB CONSTRUCTION  LEASEHOLD IMP CONSTRUCTION  RENTALS - LAND BLDGS & STRUCTS\"}, {\"Expense Category\": \"EQUIPMENT GENERAL  MOTOR VEHICLES\"}, {\"Expense Category\": \"OFFICE EQUIPMENT\"}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"LEASEHOLD IMP CONSTRUCTION  RENTALS - LAND BLDGS & STRUCTS\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  CONSTRUCTION-BUILDINGS  DESIGN-CONSULTANT-BUILDINGS  MAINT & OPER OF INFRASTRUCTURE  POLLUTION REMEDIATION OBLIGATIONS  PROF SERV ENGINEER & ARCHITECT\"}, {\"Expense Category\": \"SECURITY EQUIPMENT\"}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  DESIGN-CONSULTANT-BUILDINGS  DESIGN-CONSULTANT-IOTB  IOTB CONSTRUCTION  MAINT & OPER OF INFRASTRUCTURE  PROF SERV ENGINEER & ARCHITECT\"}, {\"Expense Category\": \"DESIGN-CONSULTANT-BUILDINGS  DESIGN-CONSULTANT-IOTB  IOTB CONSTRUCTION  MAINT & OPER OF INFRASTRUCTURE  PROF SERV ENGINEER & ARCHITECT\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  PROF SERV COMPUTER SERVICES\"}, {\"Expense Category\": \"MAINTENANCE SUPPLIES  MAINT & OPER OF INFRASTRUCTURE\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  MAINT & REP GENERAL  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"DESIGN-CONSULTANT-BUILDINGS\"}, {\"Expense Category\": \"EQUIPMENT GENERAL  MAINT & REP MOTOR VEH EQUIP\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES\"}, {\"Expense Category\": \"LEASING OF MISC EQUIP\"}, {\"Expense Category\": \"CLEANING SERVICES  RENTALS OF MISC.EQUIP\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  EQUIPMENT GENERAL\"}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  MAINT & OPER OF INFRASTRUCTURE  POLLUTION REMEDIATION OBLIGATIONS\"}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  POLLUTION REMEDIATION OBLIGATIONS\"}, {\"Expense Category\": \"MEDICAL SURGICAL & LAB SUPPLY  SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  OTHR SERV AND CHRGS-GENERAL  PROF SERV COMPUTER SERVICES\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  MAINT & REP GENERAL  OTHR SERV AND CHRGS-GENERAL\"}, {\"Expense Category\": \"OTHR SERV AND CHRGS-GENERAL  OVERNIGHT TRVL EXP-GENERAL\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  PROF SERV COMPUTER SERVICES  PURCH DATA PROCESSING EQUIPT  TRAINING PRGM CITY EMPLOYEES\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  OTHR SERV AND CHRGS-GENERAL\"}, {\"Expense Category\": \"OTHR SERV AND CHRGS-GENERAL  PROF SERV OTHER\"}, {\"Expense Category\": \"MEDICAL SURGICAL & LAB SUPPLY  PROF SERV OTHER\"}, {\"Expense Category\": \"IOTB CONSTRUCTION  MAINT & OPER OF INFRASTRUCTURE\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES\"}, {\"Expense Category\": \"LIBRARY BOOKS\"}, {\"Expense Category\": \"MAINT & REP GENERAL  MEDICAL SURGICAL & LAB SUPPLY  PROF SERV OTHER  SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"MAINT & REP GENERAL  MEDICAL SURGICAL & LAB SUPPLY  PROF SERV OTHER\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES\"}, {\"Expense Category\": \"IOTB CONSTRUCTION\"}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  IOTB CONSTRUCTION\"}, {\"Expense Category\": \"EQUIPMENT GENERAL  OTHR SERV AND CHRGS-GENERAL\"}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  CONTRACTUAL SERVICES GENERAL\"}, {\"Expense Category\": \"OVERNIGHT TRVL EXP-SPECIAL  PROF SERV OTHER\"}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  IOTB CONSTRUCTION  MAINT & OPER OF INFRASTRUCTURE\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  CLEANING SERVICES  CONSTRUCTION-BUILDINGS  CONTRACTUAL SERVICES GENERAL  DESIGN-CONSULTANT-BUILDINGS  IOTB CONSTRUCTION  MAINT & OPER OF INFRASTRUCTURE  POLLUTION REMEDIATION OBLIGATIONS  PROF SERV ENGINEER & ARCHITECT\"}, {\"Expense Category\": \"ADVERTISING  CONTRACTUAL SERVICES GENERAL\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES  PURCH DATA PROCESSING EQUIPT  SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"OVERNIGHT TRVL EXP-SPECIAL\"}, {\"Expense Category\": \"MAINT & REP GENERAL  OTHR SERV AND CHRGS-GENERAL\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  PROF SERV COMPUTER SERVICES\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  TRAINING PRGM CITY EMPLOYEES\"}, {\"Expense Category\": \"EQUIPMENT GENERAL  TELECOMMUNICATIONS EQUIPMENT\"}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  MAINT & OPER OF INFRASTRUCTURE  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"OTHR SERV AND CHRGS-GENERAL  RENTALS - LAND BLDGS & STRUCTS\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  EQUIPMENT GENERAL  MAINT & REP GENERAL  SUPPLIES + MATERIALS - GENERAL  TRAINING PRGM CITY EMPLOYEES\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  MAINT & REP MOTOR VEH EQUIP\"}, {\"Expense Category\": \"POSTAGE\"}, {\"Expense Category\": \"PRINTING CONTRACTS\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  EQUIPMENT GENERAL  TELECOMMUNICATIONS MAINT\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  EQUIPMENT GENERAL\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  PROF SERV OTHER\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING SUPPLIES\"}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  IOTB SITE ACQUISITION\"}, {\"Expense Category\": \"MOTOR VEHICLE FUEL\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  EQUIPMENT GENERAL  MAINT & OPER OF INFRASTRUCTURE\"}, {\"Expense Category\": \"BOOKS-OTHER  TRAINING PRGM CITY EMPLOYEES\"}, {\"Expense Category\": \"EQUIPMENT GENERAL  MAINT & REP GENERAL\"}, {\"Expense Category\": \"OFF SVC-MEMBERSHIP DUES & FEES\"}, {\"Expense Category\": \"MAINT & REP GENERAL  OFFICE EQUIPMENT MAINTENANCE\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  MAINT & OPER OF INFRASTRUCTURE  OTHR SERV AND CHRGS-GENERAL\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"CLEANING SERVICES  CONTRACTUAL SERVICES GENERAL\"}, {\"Expense Category\": \"MAINT & OPER OF INFRASTRUCTURE  OTHR SERV AND CHRGS-GENERAL\"}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  OTHR SERV AND CHRGS-GENERAL\"}, {\"Expense Category\": \"EDUCATION & REC FOR YOUTH PRGM  FOOD & FORAGE SUPPLIES\"}, {\"Expense Category\": \"EQUIPMENT GENERAL  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL  LIBRARY BOOKS  MAINT & REP GENERAL  MAINT & REP MOTOR VEH EQUIP  MEDICAL SURGICAL & LAB EQUIP  MEDICAL SURGICAL & LAB SUPPLY  OFFICE EQUIPMENT  OFF SVC-MEMBERSHIP DUES & FEES  OVERNIGHT TRVL EXP-GENERAL  POSTAGE  PROF SERV OTHER  RENTALS OF MISC.EQUIP  SUPPLIES + MATERIALS - GENERAL  TRAINING PRGM CITY EMPLOYEES\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  PROF SERV COMPUTER SERVICES\"}, {\"Expense Category\": \"EQUIPMENT GENERAL  MAINTENANCE SUPPLIES\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  TRAINING PRGM CITY EMPLOYEES\"}, {\"Expense Category\": \"EQUIPMENT GENERAL  MAINT & REP GENERAL  MEDICAL SURGICAL & LAB EQUIP  MEDICAL SURGICAL & LAB SUPPLY  PROF SERV OTHER  SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  PAY FOR SURETY BOND/INSUR PREM\"}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL  LIBRARY BOOKS  MAINT & REP GENERAL  MEDICAL SURGICAL & LAB SUPPLY  OTHR SERV AND CHRGS-GENERAL  OVERNIGHT TRVL EXP-GENERAL  POSTAGE  PROF SERV OTHER  SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  CONTRACTUAL SERVICES GENERAL  DATA PROCESSING EQUIPMENT MAINTENANCE  MAINT & REP GENERAL  OVERNIGHT TRVL EXP-SPECIAL  PAY FOR SURETY BOND/INSUR PREM  TRAINING PRGM CITY EMPLOYEES\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  PROF SERV COMPUTER SERVICES  PROF SERV OTHER\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  MOTOR VEHICLES\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DESIGN-CONSULTANT-BUILDINGS  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"DONAT PAT INMATE & DISCHG PRIS\"}, {\"Expense Category\": \"MAINT & REP GENERAL  TELECOMMUNICATIONS MAINT\"}, {\"Expense Category\": \"MAINT & REP GENERAL  TELECOMMUNICATIONS EQUIPMENT\"}, {\"Expense Category\": \"CLEANING SUPPLIES\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  TRAINING PRGM CITY EMPLOYEES\"}, {\"Expense Category\": \"EQUIPMENT GENERAL  OFFICE EQUIPMENT  OTHR SERV AND CHRGS-GENERAL\"}, {\"Expense Category\": \"OFF SVC-MEMBERSHIP DUES & FEES  OTHR SERV AND CHRGS-GENERAL\"}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES\"}, {\"Expense Category\": \"BOOKS-OTHER  CONTRACTUAL SERVICES GENERAL  DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL  OFFICE FURITURE  OFF SVC-MEMBERSHIP DUES & FEES  PURCH DATA PROCESSING EQUIPT  SUPPLIES + MATERIALS - GENERAL  TELECOMMUNICATIONS EQUIPMENT  TELEPHONE & OTHER COMMUNICATNS  TRAINING PRGM CITY EMPLOYEES\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  TELECOMMUNICATIONS MAINT\"}, {\"Expense Category\": \"MAINTENANCE SUPPLIES  SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  CONTRACTUAL SERVICES GENERAL  DATA PROCESSING EQUIPMENT MAINTENANCE  PROF SERV COMPUTER SERVICES\"}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL  PROF SERV COMPUTER SERVICES\"}, {\"Expense Category\": \"CAPITAL ONLY FUNDED SBITA  DATA PROCESSING EQUIPMENT MAINTENANCE\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"OFF SVC-MEMBERSHIP DUES & FEES  SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  CONTRACTUAL SERVICES GENERAL  DATA PROCESSING EQUIPMENT MAINTENANCE  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"PURCH DATA PROCESSING EQUIPT  SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PURCH DATA PROCESSING EQUIPT  SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  EQUIPMENT GENERAL  PURCH DATA PROCESSING EQUIPT  SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  TELECOMMUNICATIONS EQUIPMENT\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  TRAINING PRGM CITY EMPLOYEES\"}, {\"Expense Category\": \"OFFICE EQUIPMENT  SUPPLIES + MATERIALS - GENERAL\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PURCH DATA PROCESSING EQUIPT  TELEPHONE & OTHER COMMUNICATNS\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  PROF SERV COMPUTER SERVICES  PURCH DATA PROCESSING EQUIPT  TRAINING PRGM CITY EMPLOYEES\"}, {\"Expense Category\": \"CAPITAL PURCHASED EQUIPMENT  DATA PROCESSING EQUIPMENT MAINTENANCE  DATA PROCESSING SUPPLIES  TELECOMMUNICATIONS EQUIPMENT\"}, {\"Expense Category\": \"SUPPLIES + MATERIALS - GENERAL--WTC ONLY\"}, {\"Expense Category\": \"CONSTRUCTION-BUILDINGS  EQUIPMENT GENERAL\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  MAINT & REP GENERAL  OFFICE EQUIPMENT MAINTENANCE\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  OFFICE EQUIPMENT MAINTENANCE\"}, {\"Expense Category\": \"DATA PROCESSING SUPPLIES  OTHR SERV AND CHRGS-GENERAL  PURCH DATA PROCESSING EQUIPT\"}, {\"Expense Category\": \"DATA PROCESSING EQUIPMENT MAINTENANCE  PURCH DATA PROCESSING EQUIPT  TELECOMMUNICATIONS MAINT\"}, {\"Expense Category\": \"CONTRACTUAL SERVICES GENERAL  DATA PROCESSING SUPPLIES\"}, {\"Expense Category\": \"EQUIPMENT GENERAL  SECURITY EQUIPMENT  SUPPLIES + MATERIALS - GENERAL\"}]}, {\"name\": \"source_0_y_domain___count\", \"values\": [{\"min\": 1, \"max\": 7245}]}], \"signals\": [{\"name\": \"x_step\", \"value\": 20}, {\"name\": \"width\", \"update\": \"bandspace(domain('x').length, 0.1, 0.05) * x_step\"}], \"marks\": [{\"type\": \"rect\", \"name\": \"marks\", \"from\": {\"data\": \"source_0\"}, \"encode\": {\"update\": {\"description\": {\"signal\": \"\\\"Expense Category: \\\" + (isValid(datum[\\\"Expense Category\\\"]) ? datum[\\\"Expense Category\\\"] : \\\"\\\"+datum[\\\"Expense Category\\\"]) + \\\"; Count of Records: \\\" + (format(datum[\\\"__count\\\"], \\\"\\\"))\"}, \"fill\": {\"value\": \"#4c78a8\"}, \"width\": {\"signal\": \"max(0.25, bandwidth('x'))\"}, \"y\": {\"field\": \"__count\", \"scale\": \"y\"}, \"ariaRoleDescription\": {\"value\": \"bar\"}, \"y2\": {\"value\": 0, \"scale\": \"y\"}, \"x\": {\"field\": \"Expense Category\", \"scale\": \"x\"}}}, \"style\": [\"bar\"]}], \"scales\": [{\"name\": \"x\", \"type\": \"band\", \"domain\": {\"data\": \"source_0_x_domain_Expense Category\", \"field\": \"Expense Category\", \"sort\": true}, \"range\": {\"step\": {\"signal\": \"x_step\"}}, \"paddingInner\": 0.1, \"paddingOuter\": 0.05}, {\"name\": \"y\", \"type\": \"linear\", \"domain\": [{\"signal\": \"(data(\\\"source_0_y_domain___count\\\")[0] || {}).min\"}, {\"signal\": \"(data(\\\"source_0_y_domain___count\\\")[0] || {}).max\"}], \"range\": [{\"signal\": \"height\"}, 0], \"nice\": true, \"zero\": true}], \"axes\": [{\"scale\": \"y\", \"domain\": false, \"gridScale\": \"x\", \"labels\": false, \"tickCount\": {\"signal\": \"ceil(height/40)\"}, \"orient\": \"left\", \"grid\": true, \"aria\": false, \"maxExtent\": 0, \"ticks\": false, \"minExtent\": 0, \"zindex\": 0}, {\"scale\": \"x\", \"orient\": \"bottom\", \"title\": \"Expense Category\", \"labelAlign\": \"right\", \"labelAngle\": 270, \"labelBaseline\": \"middle\", \"zindex\": 0, \"grid\": false}, {\"scale\": \"y\", \"labelOverlap\": true, \"zindex\": 0, \"orient\": \"left\", \"title\": \"Count of Records\", \"grid\": false, \"tickCount\": {\"signal\": \"ceil(height/40)\"}}], \"height\": 300, \"background\": \"white\", \"style\": \"cell\", \"padding\": 5}, {\"mode\": \"vega\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a bar chart\n",
    "alt.Chart(contracts).mark_bar().encode(\n",
    "    x='Expense Category:N',\n",
    "    y='count()',\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<style>\n",
       "  #altair-viz-169c917ce1bd4c5597a8dce8a5be8769.vega-embed {\n",
       "    width: 100%;\n",
       "    display: flex;\n",
       "  }\n",
       "\n",
       "  #altair-viz-169c917ce1bd4c5597a8dce8a5be8769.vega-embed details,\n",
       "  #altair-viz-169c917ce1bd4c5597a8dce8a5be8769.vega-embed details summary {\n",
       "    position: relative;\n",
       "  }\n",
       "</style>\n",
       "<div id=\"altair-viz-169c917ce1bd4c5597a8dce8a5be8769\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-169c917ce1bd4c5597a8dce8a5be8769\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-169c917ce1bd4c5597a8dce8a5be8769\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm/vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm/vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm/vega-lite@5.8.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm/vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"5.8.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"$schema\": \"https://vega.github.io/schema/vega/v5.json\", \"data\": [{\"name\": \"source_0\", \"values\": [{\"Industry\": \"Goods\", \"__count\": 4731}, {\"Industry\": \"Professional Services\", \"__count\": 422}, {\"Industry\": \"Standardized Services\", \"__count\": 278}, {\"Industry\": \"Not Classified\", \"__count\": 312}, {\"Industry\": \"Arch and Engineering\", \"__count\": 8}, {\"Industry\": \"Construction Services\", \"__count\": 295}, {\"Industry\": \"Human Services\", \"__count\": 21}, {\"Industry\": \"\", \"__count\": 11742}]}, {\"name\": \"source_0_x_domain_Industry\", \"values\": [{\"Industry\": \"Goods\"}, {\"Industry\": \"Professional Services\"}, {\"Industry\": \"Standardized Services\"}, {\"Industry\": \"Not Classified\"}, {\"Industry\": \"Arch and Engineering\"}, {\"Industry\": \"Construction Services\"}, {\"Industry\": \"Human Services\"}, {\"Industry\": \"\"}]}, {\"name\": \"source_0_y_domain___count\", \"values\": [{\"min\": 8, \"max\": 11742}]}], \"signals\": [{\"name\": \"x_step\", \"value\": 20}, {\"name\": \"width\", \"update\": \"bandspace(domain('x').length, 0.1, 0.05) * x_step\"}], \"marks\": [{\"type\": \"rect\", \"name\": \"marks\", \"from\": {\"data\": \"source_0\"}, \"encode\": {\"update\": {\"y2\": {\"value\": 0, \"scale\": \"y\"}, \"x\": {\"field\": \"Industry\", \"scale\": \"x\"}, \"y\": {\"field\": \"__count\", \"scale\": \"y\"}, \"ariaRoleDescription\": {\"value\": \"bar\"}, \"description\": {\"signal\": \"\\\"Industry: \\\" + (isValid(datum[\\\"Industry\\\"]) ? datum[\\\"Industry\\\"] : \\\"\\\"+datum[\\\"Industry\\\"]) + \\\"; Count of Records: \\\" + (format(datum[\\\"__count\\\"], \\\"\\\"))\"}, \"width\": {\"signal\": \"max(0.25, bandwidth('x'))\"}, \"fill\": {\"value\": \"#4c78a8\"}}}, \"style\": [\"bar\"]}], \"scales\": [{\"name\": \"x\", \"type\": \"band\", \"domain\": {\"data\": \"source_0_x_domain_Industry\", \"field\": \"Industry\", \"sort\": true}, \"range\": {\"step\": {\"signal\": \"x_step\"}}, \"paddingOuter\": 0.05, \"paddingInner\": 0.1}, {\"name\": \"y\", \"type\": \"linear\", \"domain\": [{\"signal\": \"(data(\\\"source_0_y_domain___count\\\")[0] || {}).min\"}, {\"signal\": \"(data(\\\"source_0_y_domain___count\\\")[0] || {}).max\"}], \"range\": [{\"signal\": \"height\"}, 0], \"nice\": true, \"zero\": true}], \"axes\": [{\"scale\": \"y\", \"labels\": false, \"aria\": false, \"tickCount\": {\"signal\": \"ceil(height/40)\"}, \"ticks\": false, \"maxExtent\": 0, \"gridScale\": \"x\", \"minExtent\": 0, \"zindex\": 0, \"orient\": \"left\", \"grid\": true, \"domain\": false}, {\"scale\": \"x\", \"title\": \"Industry\", \"labelBaseline\": \"middle\", \"zindex\": 0, \"labelAlign\": \"right\", \"grid\": false, \"labelAngle\": 270, \"orient\": \"bottom\"}, {\"scale\": \"y\", \"grid\": false, \"orient\": \"left\", \"labelOverlap\": true, \"tickCount\": {\"signal\": \"ceil(height/40)\"}, \"title\": \"Count of Records\", \"zindex\": 0}], \"background\": \"white\", \"height\": 300, \"padding\": 5, \"style\": \"cell\"}, {\"mode\": \"vega\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a bar chart\n",
    "alt.Chart(contracts).mark_bar().encode(\n",
    "    x='Industry:N',\n",
    "    y='count()',\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "<style>\n",
       "  #altair-viz-47fe814da3104518a83ec17704dcaa64.vega-embed {\n",
       "    width: 100%;\n",
       "    display: flex;\n",
       "  }\n",
       "\n",
       "  #altair-viz-47fe814da3104518a83ec17704dcaa64.vega-embed details,\n",
       "  #altair-viz-47fe814da3104518a83ec17704dcaa64.vega-embed details summary {\n",
       "    position: relative;\n",
       "  }\n",
       "</style>\n",
       "<div id=\"altair-viz-47fe814da3104518a83ec17704dcaa64\"></div>\n",
       "<script type=\"text/javascript\">\n",
       "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
       "  (function(spec, embedOpt){\n",
       "    let outputDiv = document.currentScript.previousElementSibling;\n",
       "    if (outputDiv.id !== \"altair-viz-47fe814da3104518a83ec17704dcaa64\") {\n",
       "      outputDiv = document.getElementById(\"altair-viz-47fe814da3104518a83ec17704dcaa64\");\n",
       "    }\n",
       "    const paths = {\n",
       "      \"vega\": \"https://cdn.jsdelivr.net/npm/vega@5?noext\",\n",
       "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm/vega-lib?noext\",\n",
       "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm/vega-lite@5.8.0?noext\",\n",
       "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm/vega-embed@6?noext\",\n",
       "    };\n",
       "\n",
       "    function maybeLoadScript(lib, version) {\n",
       "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
       "      return (VEGA_DEBUG[key] == version) ?\n",
       "        Promise.resolve(paths[lib]) :\n",
       "        new Promise(function(resolve, reject) {\n",
       "          var s = document.createElement('script');\n",
       "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
       "          s.async = true;\n",
       "          s.onload = () => {\n",
       "            VEGA_DEBUG[key] = version;\n",
       "            return resolve(paths[lib]);\n",
       "          };\n",
       "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
       "          s.src = paths[lib];\n",
       "        });\n",
       "    }\n",
       "\n",
       "    function showError(err) {\n",
       "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
       "      throw err;\n",
       "    }\n",
       "\n",
       "    function displayChart(vegaEmbed) {\n",
       "      vegaEmbed(outputDiv, spec, embedOpt)\n",
       "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
       "    }\n",
       "\n",
       "    if(typeof define === \"function\" && define.amd) {\n",
       "      requirejs.config({paths});\n",
       "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
       "    } else {\n",
       "      maybeLoadScript(\"vega\", \"5\")\n",
       "        .then(() => maybeLoadScript(\"vega-lite\", \"5.8.0\"))\n",
       "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
       "        .catch(showError)\n",
       "        .then(() => displayChart(vegaEmbed));\n",
       "    }\n",
       "  })({\"$schema\": \"https://vega.github.io/schema/vega/v5.json\", \"data\": [{\"name\": \"source_0\", \"values\": [{\"Award Method\": \"SM PURCH GOODS SERVICES 100K\", \"__count\": 1354}, {\"Award Method\": \"RENEWAL OF CONTRACT\", \"__count\": 144}, {\"Award Method\": \"SMALL PURCHASE - WRITTEN\", \"__count\": 2206}, {\"Award Method\": \"SOLE SOURCE\", \"__count\": 28}, {\"Award Method\": \"MULTIPLE AWARDS\", \"__count\": 151}, {\"Award Method\": \"NEG ACQUISITSION  EXTN AND DOE NEGOTIATED SERVICES EXTN\", \"__count\": 9}, {\"Award Method\": \"COMPETITIVE SEALED BIDDING\", \"__count\": 335}, {\"Award Method\": \"MWBE PURCHASE - NOT EXCEEDING $500K\", \"__count\": 96}, {\"Award Method\": \"ASSIGNMENT - NYPD ONLY\", \"__count\": 2}, {\"Award Method\": \"REQUEST FOR  PROPOSAL (RFP)\", \"__count\": 78}, {\"Award Method\": \"INTERGOVERNMENTAL PROCUREMENT\", \"__count\": 426}, {\"Award Method\": \"NEGOTIATED ACQUISITION AND DOE NEGOTIATED SERVICES\", \"__count\": 40}, {\"Award Method\": \"SMALL PURCHASE - INTERGOV'T\", \"__count\": 764}, {\"Award Method\": \"INTERGOVERNMENTAL PROCUREMENT RENEWAL\", \"__count\": 16}, {\"Award Method\": \"EMERGENCY\", \"__count\": 54}, {\"Award Method\": \"ASSIGNMENT\", \"__count\": 34}, {\"Award Method\": \"LESSEE NEGOTIATION\", \"__count\": 85}, {\"Award Method\": \"SUBSCRIPTION ETC PER PPB\", \"__count\": 23}, {\"Award Method\": \"MISCELLANEOUS\", \"__count\": 5}, {\"Award Method\": \"SMALL PURCHASE - UNDER $5 000\", \"__count\": 17}, {\"Award Method\": \"MWBE PURCHASE - NOT EXCEEDING $150K\", \"__count\": 133}, {\"Award Method\": \"CABLE SERVICE NEGOTIATION\", \"__count\": 1}, {\"Award Method\": \"RFP FROM A PQVL\", \"__count\": 16}, {\"Award Method\": \"SMALL PURCH - IT- 25 K TO 100K\", \"__count\": 1}, {\"Award Method\": \"\", \"__count\": 11742}, {\"Award Method\": \"SM PURCH CONSTR - 50K TO 100K\", \"__count\": 14}, {\"Award Method\": \"BORO NEEDS/DISCRETIONARY FUND\", \"__count\": 2}, {\"Award Method\": \"DETERMINED BY GOV'T MANDATE\", \"__count\": 4}, {\"Award Method\": \"DEMONSTRATION PROJECT\", \"__count\": 3}, {\"Award Method\": \"SMALL PURCHASE - INFO TECH\", \"__count\": 2}, {\"Award Method\": \"SMALL PURCHASE - EMERGENCY\", \"__count\": 1}, {\"Award Method\": \"GOVERNMENT TO GOVERNMENT\", \"__count\": 1}, {\"Award Method\": \"SMALL PURCHASE -  RFP\", \"__count\": 1}, {\"Award Method\": \"SMALL PURCH -SUBSCRIPTION ETC\", \"__count\": 6}, {\"Award Method\": \"SMALL PURCHASE-PUBLIC UTILITY\", \"__count\": 2}, {\"Award Method\": \"SMALL PURCHASE - ORAL SOLICITA\", \"__count\": 3}, {\"Award Method\": \"SM. PURCHASE -PROF. MEMBERSHIP\", \"__count\": 1}, {\"Award Method\": \"INTERGOVERNMENTAL RENEWAL\", \"__count\": 1}, {\"Award Method\": \"NEGOTIATED ACQUISITION\", \"__count\": 1}, {\"Award Method\": \"SMALL PURCHASE GOOD AND SERVICES TO $100K\", \"__count\": 5}, {\"Award Method\": \"COMPETITIVE BID\", \"__count\": 2}]}, {\"name\": \"source_0_x_domain_Award Method\", \"values\": [{\"Award Method\": \"SM PURCH GOODS SERVICES 100K\"}, {\"Award Method\": \"RENEWAL OF CONTRACT\"}, {\"Award Method\": \"SMALL PURCHASE - WRITTEN\"}, {\"Award Method\": \"SOLE SOURCE\"}, {\"Award Method\": \"MULTIPLE AWARDS\"}, {\"Award Method\": \"NEG ACQUISITSION  EXTN AND DOE NEGOTIATED SERVICES EXTN\"}, {\"Award Method\": \"COMPETITIVE SEALED BIDDING\"}, {\"Award Method\": \"MWBE PURCHASE - NOT EXCEEDING $500K\"}, {\"Award Method\": \"ASSIGNMENT - NYPD ONLY\"}, {\"Award Method\": \"REQUEST FOR  PROPOSAL (RFP)\"}, {\"Award Method\": \"INTERGOVERNMENTAL PROCUREMENT\"}, {\"Award Method\": \"NEGOTIATED ACQUISITION AND DOE NEGOTIATED SERVICES\"}, {\"Award Method\": \"SMALL PURCHASE - INTERGOV'T\"}, {\"Award Method\": \"INTERGOVERNMENTAL PROCUREMENT RENEWAL\"}, {\"Award Method\": \"EMERGENCY\"}, {\"Award Method\": \"ASSIGNMENT\"}, {\"Award Method\": \"LESSEE NEGOTIATION\"}, {\"Award Method\": \"SUBSCRIPTION ETC PER PPB\"}, {\"Award Method\": \"MISCELLANEOUS\"}, {\"Award Method\": \"SMALL PURCHASE - UNDER $5 000\"}, {\"Award Method\": \"MWBE PURCHASE - NOT EXCEEDING $150K\"}, {\"Award Method\": \"CABLE SERVICE NEGOTIATION\"}, {\"Award Method\": \"RFP FROM A PQVL\"}, {\"Award Method\": \"SMALL PURCH - IT- 25 K TO 100K\"}, {\"Award Method\": \"\"}, {\"Award Method\": \"SM PURCH CONSTR - 50K TO 100K\"}, {\"Award Method\": \"BORO NEEDS/DISCRETIONARY FUND\"}, {\"Award Method\": \"DETERMINED BY GOV'T MANDATE\"}, {\"Award Method\": \"DEMONSTRATION PROJECT\"}, {\"Award Method\": \"SMALL PURCHASE - INFO TECH\"}, {\"Award Method\": \"SMALL PURCHASE - EMERGENCY\"}, {\"Award Method\": \"GOVERNMENT TO GOVERNMENT\"}, {\"Award Method\": \"SMALL PURCHASE -  RFP\"}, {\"Award Method\": \"SMALL PURCH -SUBSCRIPTION ETC\"}, {\"Award Method\": \"SMALL PURCHASE-PUBLIC UTILITY\"}, {\"Award Method\": \"SMALL PURCHASE - ORAL SOLICITA\"}, {\"Award Method\": \"SM. PURCHASE -PROF. MEMBERSHIP\"}, {\"Award Method\": \"INTERGOVERNMENTAL RENEWAL\"}, {\"Award Method\": \"NEGOTIATED ACQUISITION\"}, {\"Award Method\": \"SMALL PURCHASE GOOD AND SERVICES TO $100K\"}, {\"Award Method\": \"COMPETITIVE BID\"}]}, {\"name\": \"source_0_y_domain___count\", \"values\": [{\"min\": 1, \"max\": 11742}]}], \"signals\": [{\"name\": \"x_step\", \"value\": 20}, {\"name\": \"width\", \"update\": \"bandspace(domain('x').length, 0.1, 0.05) * x_step\"}], \"marks\": [{\"type\": \"rect\", \"name\": \"marks\", \"from\": {\"data\": \"source_0\"}, \"encode\": {\"update\": {\"ariaRoleDescription\": {\"value\": \"bar\"}, \"x\": {\"field\": \"Award Method\", \"scale\": \"x\"}, \"y\": {\"field\": \"__count\", \"scale\": \"y\"}, \"description\": {\"signal\": \"\\\"Award Method: \\\" + (isValid(datum[\\\"Award Method\\\"]) ? datum[\\\"Award Method\\\"] : \\\"\\\"+datum[\\\"Award Method\\\"]) + \\\"; Count of Records: \\\" + (format(datum[\\\"__count\\\"], \\\"\\\"))\"}, \"width\": {\"signal\": \"max(0.25, bandwidth('x'))\"}, \"y2\": {\"value\": 0, \"scale\": \"y\"}, \"fill\": {\"value\": \"#4c78a8\"}}}, \"style\": [\"bar\"]}], \"scales\": [{\"name\": \"x\", \"type\": \"band\", \"domain\": {\"data\": \"source_0_x_domain_Award Method\", \"field\": \"Award Method\", \"sort\": true}, \"range\": {\"step\": {\"signal\": \"x_step\"}}, \"paddingInner\": 0.1, \"paddingOuter\": 0.05}, {\"name\": \"y\", \"type\": \"linear\", \"domain\": [{\"signal\": \"(data(\\\"source_0_y_domain___count\\\")[0] || {}).min\"}, {\"signal\": \"(data(\\\"source_0_y_domain___count\\\")[0] || {}).max\"}], \"range\": [{\"signal\": \"height\"}, 0], \"nice\": true, \"zero\": true}], \"axes\": [{\"scale\": \"y\", \"orient\": \"left\", \"gridScale\": \"x\", \"grid\": true, \"tickCount\": {\"signal\": \"ceil(height/40)\"}, \"minExtent\": 0, \"domain\": false, \"maxExtent\": 0, \"zindex\": 0, \"ticks\": false, \"aria\": false, \"labels\": false}, {\"scale\": \"x\", \"zindex\": 0, \"orient\": \"bottom\", \"title\": \"Award Method\", \"grid\": false, \"labelBaseline\": \"middle\", \"labelAngle\": 270, \"labelAlign\": \"right\"}, {\"scale\": \"y\", \"tickCount\": {\"signal\": \"ceil(height/40)\"}, \"orient\": \"left\", \"zindex\": 0, \"grid\": false, \"title\": \"Count of Records\", \"labelOverlap\": true}], \"padding\": 5, \"background\": \"white\", \"height\": 300, \"style\": \"cell\"}, {\"mode\": \"vega\"});\n",
       "</script>"
      ],
      "text/plain": [
       "alt.Chart(...)"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a bar chart\n",
    "alt.Chart(contracts).mark_bar().encode(\n",
    "    x='Award Method:N',\n",
    "    y='count()',\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "datathinking.org",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.0"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}