{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Export Dataset to CSV"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This notebook shows an example of how to export a dataset to a csv file. \n",
    "It assumes you found the dataset using techniques shown in `finding_datasets.ipynb` and loaded the dataset using `loading_datasets.ipynb`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import openpolicedata as opd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>State</th>\n",
       "      <th>SourceName</th>\n",
       "      <th>Agency</th>\n",
       "      <th>AgencyFull</th>\n",
       "      <th>TableType</th>\n",
       "      <th>coverage_start</th>\n",
       "      <th>coverage_end</th>\n",
       "      <th>last_coverage_check</th>\n",
       "      <th>Description</th>\n",
       "      <th>source_url</th>\n",
       "      <th>readme</th>\n",
       "      <th>URL</th>\n",
       "      <th>Year</th>\n",
       "      <th>DataType</th>\n",
       "      <th>date_field</th>\n",
       "      <th>dataset_id</th>\n",
       "      <th>agency_field</th>\n",
       "      <th>min_version</th>\n",
       "      <th>query</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>Montgomery County</td>\n",
       "      <td>Montgomery County</td>\n",
       "      <td>Montgomery County Police Department</td>\n",
       "      <td>COMPLAINTS</td>\n",
       "      <td>2013-10-24</td>\n",
       "      <td>2024-05-06</td>\n",
       "      <td>05/10/2024</td>\n",
       "      <td>This dataset contains allegations brought to t...</td>\n",
       "      <td>https://data.montgomerycountymd.gov/Public-Saf...</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>data.montgomerycountymd.gov</td>\n",
       "      <td>MULTIPLE</td>\n",
       "      <td>Socrata</td>\n",
       "      <td>created_dt</td>\n",
       "      <td>usip-62e2</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>Montgomery County</td>\n",
       "      <td>Montgomery County</td>\n",
       "      <td>Montgomery County Police Department</td>\n",
       "      <td>CRASHES - INCIDENTS</td>\n",
       "      <td>2015-12-20</td>\n",
       "      <td>2024-01-03</td>\n",
       "      <td>05/10/2024</td>\n",
       "      <td>general information about each collision and d...</td>\n",
       "      <td>https://data.montgomerycountymd.gov/Public-Saf...</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>data.montgomerycountymd.gov</td>\n",
       "      <td>MULTIPLE</td>\n",
       "      <td>Socrata</td>\n",
       "      <td>crash_date_time</td>\n",
       "      <td>bhju-22kf</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>0.4</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>Montgomery County</td>\n",
       "      <td>Montgomery County</td>\n",
       "      <td>Montgomery County Police Department</td>\n",
       "      <td>CRASHES - NONMOTORIST</td>\n",
       "      <td>2015-03-23</td>\n",
       "      <td>2023-12-31</td>\n",
       "      <td>05/10/2024</td>\n",
       "      <td>information on non-motorists (pedestrians and ...</td>\n",
       "      <td>https://data.montgomerycountymd.gov/Public-Saf...</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>data.montgomerycountymd.gov</td>\n",
       "      <td>MULTIPLE</td>\n",
       "      <td>Socrata</td>\n",
       "      <td>crash_date_time</td>\n",
       "      <td>n7fk-dce5</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>0.5</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>Montgomery County</td>\n",
       "      <td>Montgomery County</td>\n",
       "      <td>Montgomery County Police Department</td>\n",
       "      <td>CRASHES - SUBJECTS</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>2024-01-03</td>\n",
       "      <td>05/10/2024</td>\n",
       "      <td>information on motor vehicle operators (driver...</td>\n",
       "      <td>https://data.montgomerycountymd.gov/Public-Saf...</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>data.montgomerycountymd.gov</td>\n",
       "      <td>MULTIPLE</td>\n",
       "      <td>Socrata</td>\n",
       "      <td>crash_date_time</td>\n",
       "      <td>mmzv-x632</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>0.4</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484</th>\n",
       "      <td>Maryland</td>\n",
       "      <td>Montgomery County</td>\n",
       "      <td>Montgomery County</td>\n",
       "      <td>Montgomery County Police Department</td>\n",
       "      <td>INCIDENTS</td>\n",
       "      <td>2017-04-02</td>\n",
       "      <td>2024-05-10</td>\n",
       "      <td>05/10/2024</td>\n",
       "      <td>list of Police Dispatched Incidents records</td>\n",
       "      <td>https://data.montgomerycountymd.gov/Public-Saf...</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>data.montgomerycountymd.gov</td>\n",
       "      <td>MULTIPLE</td>\n",
       "      <td>Socrata</td>\n",
       "      <td>start_time</td>\n",
       "      <td>98cc-bc7d</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        State         SourceName             Agency  \\\n",
       "480  Maryland  Montgomery County  Montgomery County   \n",
       "481  Maryland  Montgomery County  Montgomery County   \n",
       "482  Maryland  Montgomery County  Montgomery County   \n",
       "483  Maryland  Montgomery County  Montgomery County   \n",
       "484  Maryland  Montgomery County  Montgomery County   \n",
       "\n",
       "                              AgencyFull              TableType  \\\n",
       "480  Montgomery County Police Department             COMPLAINTS   \n",
       "481  Montgomery County Police Department    CRASHES - INCIDENTS   \n",
       "482  Montgomery County Police Department  CRASHES - NONMOTORIST   \n",
       "483  Montgomery County Police Department     CRASHES - SUBJECTS   \n",
       "484  Montgomery County Police Department              INCIDENTS   \n",
       "\n",
       "    coverage_start coverage_end last_coverage_check  \\\n",
       "480     2013-10-24   2024-05-06          05/10/2024   \n",
       "481     2015-12-20   2024-01-03          05/10/2024   \n",
       "482     2015-03-23   2023-12-31          05/10/2024   \n",
       "483     2015-06-30   2024-01-03          05/10/2024   \n",
       "484     2017-04-02   2024-05-10          05/10/2024   \n",
       "\n",
       "                                           Description  \\\n",
       "480  This dataset contains allegations brought to t...   \n",
       "481  general information about each collision and d...   \n",
       "482  information on non-motorists (pedestrians and ...   \n",
       "483  information on motor vehicle operators (driver...   \n",
       "484        list of Police Dispatched Incidents records   \n",
       "\n",
       "                                            source_url readme  \\\n",
       "480  https://data.montgomerycountymd.gov/Public-Saf...   <NA>   \n",
       "481  https://data.montgomerycountymd.gov/Public-Saf...   <NA>   \n",
       "482  https://data.montgomerycountymd.gov/Public-Saf...   <NA>   \n",
       "483  https://data.montgomerycountymd.gov/Public-Saf...   <NA>   \n",
       "484  https://data.montgomerycountymd.gov/Public-Saf...   <NA>   \n",
       "\n",
       "                             URL      Year DataType       date_field  \\\n",
       "480  data.montgomerycountymd.gov  MULTIPLE  Socrata       created_dt   \n",
       "481  data.montgomerycountymd.gov  MULTIPLE  Socrata  crash_date_time   \n",
       "482  data.montgomerycountymd.gov  MULTIPLE  Socrata  crash_date_time   \n",
       "483  data.montgomerycountymd.gov  MULTIPLE  Socrata  crash_date_time   \n",
       "484  data.montgomerycountymd.gov  MULTIPLE  Socrata       start_time   \n",
       "\n",
       "    dataset_id agency_field min_version query  \n",
       "480  usip-62e2         <NA>        <NA>   NaN  \n",
       "481  bhju-22kf         <NA>         0.4   NaN  \n",
       "482  n7fk-dce5         <NA>         0.5   NaN  \n",
       "483  mmzv-x632         <NA>         0.4   NaN  \n",
       "484  98cc-bc7d         <NA>        <NA>   NaN  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# To access the data, create a source using a Source Name (usually a police department name). There is an optional state input to clarify ambiguities.\n",
    "# We will use the above cell's information for Maryland to choose the agency \"Montgomery County\" which we select for the source_name\n",
    "\n",
    "src = opd.Source(source_name=\"Montgomery County\", state=\"Maryland\")\n",
    "src.datasets.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Load traffic stop data for 2021\n",
    "t = src.load(table_type='TRAFFIC STOPS', year=2021)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>geometry</th>\n",
       "      <th>seq_id</th>\n",
       "      <th>date_of_stop</th>\n",
       "      <th>time_of_stop</th>\n",
       "      <th>agency</th>\n",
       "      <th>subagency</th>\n",
       "      <th>description</th>\n",
       "      <th>location</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>...</th>\n",
       "      <th>driver_state</th>\n",
       "      <th>dl_state</th>\n",
       "      <th>arrest_type</th>\n",
       "      <th>search_conducted</th>\n",
       "      <th>search_outcome</th>\n",
       "      <th>search_reason_for_stop</th>\n",
       "      <th>search_disposition</th>\n",
       "      <th>search_reason</th>\n",
       "      <th>search_type</th>\n",
       "      <th>search_arrest_reason</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>POINT (-77.13047 39.01268)</td>\n",
       "      <td>f08d0293-6ade-4802-84c1-4b7b1a707245</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>03:12:00</td>\n",
       "      <td>MCP</td>\n",
       "      <td>2nd District, Bethesda</td>\n",
       "      <td>RECKLESS DRIVING VEHICLE IN WANTON AND WILLFUL...</td>\n",
       "      <td>IFO 9609 SINGLETON DR</td>\n",
       "      <td>39.0126813333333</td>\n",
       "      <td>-77.130466</td>\n",
       "      <td>...</td>\n",
       "      <td>MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>A - Marked Patrol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>POINT (-77.13047 39.01268)</td>\n",
       "      <td>f08d0293-6ade-4802-84c1-4b7b1a707245</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>03:12:00</td>\n",
       "      <td>MCP</td>\n",
       "      <td>2nd District, Bethesda</td>\n",
       "      <td>FAILURE OF VEH. DRIVER IN ACCIDENT TO LOCATE A...</td>\n",
       "      <td>IFO 9609 SINGLETON DR</td>\n",
       "      <td>39.0126813333333</td>\n",
       "      <td>-77.130466</td>\n",
       "      <td>...</td>\n",
       "      <td>MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>A - Marked Patrol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>POINT (-77.13047 39.01268)</td>\n",
       "      <td>f08d0293-6ade-4802-84c1-4b7b1a707245</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>03:12:00</td>\n",
       "      <td>MCP</td>\n",
       "      <td>2nd District, Bethesda</td>\n",
       "      <td>NEGLIGENT DRIVING VEHICLE IN CARELESS AND IMPR...</td>\n",
       "      <td>IFO 9609 SINGLETON DR</td>\n",
       "      <td>39.0126813333333</td>\n",
       "      <td>-77.130466</td>\n",
       "      <td>...</td>\n",
       "      <td>MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>A - Marked Patrol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>POINT (-77.13047 39.01268)</td>\n",
       "      <td>f08d0293-6ade-4802-84c1-4b7b1a707245</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>03:12:00</td>\n",
       "      <td>MCP</td>\n",
       "      <td>2nd District, Bethesda</td>\n",
       "      <td>FAILURE OF VEH. DRIVER TO STOP AFTER UNATTENDE...</td>\n",
       "      <td>IFO 9609 SINGLETON DR</td>\n",
       "      <td>39.0126813333333</td>\n",
       "      <td>-77.130466</td>\n",
       "      <td>...</td>\n",
       "      <td>MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>A - Marked Patrol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>POINT (-77.13047 39.01268)</td>\n",
       "      <td>f08d0293-6ade-4802-84c1-4b7b1a707245</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>03:12:00</td>\n",
       "      <td>MCP</td>\n",
       "      <td>2nd District, Bethesda</td>\n",
       "      <td>FAILURE OF VEH. DRIVER INVOLVED IN ACCIDENT TO...</td>\n",
       "      <td>IFO 9609 SINGLETON DR</td>\n",
       "      <td>39.0126813333333</td>\n",
       "      <td>-77.130466</td>\n",
       "      <td>...</td>\n",
       "      <td>MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>A - Marked Patrol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     geometry                                seq_id  \\\n",
       "0  POINT (-77.13047 39.01268)  f08d0293-6ade-4802-84c1-4b7b1a707245   \n",
       "1  POINT (-77.13047 39.01268)  f08d0293-6ade-4802-84c1-4b7b1a707245   \n",
       "2  POINT (-77.13047 39.01268)  f08d0293-6ade-4802-84c1-4b7b1a707245   \n",
       "3  POINT (-77.13047 39.01268)  f08d0293-6ade-4802-84c1-4b7b1a707245   \n",
       "4  POINT (-77.13047 39.01268)  f08d0293-6ade-4802-84c1-4b7b1a707245   \n",
       "\n",
       "  date_of_stop time_of_stop agency               subagency  \\\n",
       "0   2021-01-01     03:12:00    MCP  2nd District, Bethesda   \n",
       "1   2021-01-01     03:12:00    MCP  2nd District, Bethesda   \n",
       "2   2021-01-01     03:12:00    MCP  2nd District, Bethesda   \n",
       "3   2021-01-01     03:12:00    MCP  2nd District, Bethesda   \n",
       "4   2021-01-01     03:12:00    MCP  2nd District, Bethesda   \n",
       "\n",
       "                                         description               location  \\\n",
       "0  RECKLESS DRIVING VEHICLE IN WANTON AND WILLFUL...  IFO 9609 SINGLETON DR   \n",
       "1  FAILURE OF VEH. DRIVER IN ACCIDENT TO LOCATE A...  IFO 9609 SINGLETON DR   \n",
       "2  NEGLIGENT DRIVING VEHICLE IN CARELESS AND IMPR...  IFO 9609 SINGLETON DR   \n",
       "3  FAILURE OF VEH. DRIVER TO STOP AFTER UNATTENDE...  IFO 9609 SINGLETON DR   \n",
       "4  FAILURE OF VEH. DRIVER INVOLVED IN ACCIDENT TO...  IFO 9609 SINGLETON DR   \n",
       "\n",
       "           latitude   longitude  ... driver_state dl_state        arrest_type  \\\n",
       "0  39.0126813333333  -77.130466  ...           MD       MD  A - Marked Patrol   \n",
       "1  39.0126813333333  -77.130466  ...           MD       MD  A - Marked Patrol   \n",
       "2  39.0126813333333  -77.130466  ...           MD       MD  A - Marked Patrol   \n",
       "3  39.0126813333333  -77.130466  ...           MD       MD  A - Marked Patrol   \n",
       "4  39.0126813333333  -77.130466  ...           MD       MD  A - Marked Patrol   \n",
       "\n",
       "  search_conducted search_outcome search_reason_for_stop search_disposition  \\\n",
       "0              NaN            NaN                    NaN                NaN   \n",
       "1              NaN            NaN                    NaN                NaN   \n",
       "2              NaN            NaN                    NaN                NaN   \n",
       "3              NaN            NaN                    NaN                NaN   \n",
       "4              NaN            NaN                    NaN                NaN   \n",
       "\n",
       "  search_reason search_type search_arrest_reason  \n",
       "0           NaN         NaN                  NaN  \n",
       "1           NaN         NaN                  NaN  \n",
       "2           NaN         NaN                  NaN  \n",
       "3           NaN         NaN                  NaN  \n",
       "4           NaN         NaN                  NaN  \n",
       "\n",
       "[5 rows x 43 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Show the first 5 rows of the table\n",
    "t.table.head(n=5)\n",
    "# Now you are ready for analyzing the data in the table t."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The CSV file will be written to c:\\Users\\matth\\repos\\openpolicedata\\docs\\source\\examples\\opd-examples. Make sure this path is okay before running the next cell. If the path is not okay then modify csv_filepath.\n"
     ]
    }
   ],
   "source": [
    "import os\n",
    "cwd = os.getcwd()\n",
    "csv_filepath = cwd\n",
    "\n",
    "print(f\"The CSV file will be written to {csv_filepath}. Make sure this path is okay before running the next cell. If the path is not okay then modify csv_filepath.\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The CSV file was written to c:\\Users\\matth\\repos\\openpolicedata\\docs\\source\\examples\\opd-examples\\Maryland_Montgomery_County_TRAFFIC_STOPS_2021.csv.\n"
     ]
    }
   ],
   "source": [
    "# Save to CSV. To specify a custom filename, set the filename input\n",
    "csv_written_filename=t.to_csv(output_dir=csv_filepath)\n",
    "print(f\"The CSV file was written to {csv_written_filename}.\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>geometry</th>\n",
       "      <th>seq_id</th>\n",
       "      <th>date_of_stop</th>\n",
       "      <th>time_of_stop</th>\n",
       "      <th>agency</th>\n",
       "      <th>subagency</th>\n",
       "      <th>description</th>\n",
       "      <th>location</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>...</th>\n",
       "      <th>driver_state</th>\n",
       "      <th>dl_state</th>\n",
       "      <th>arrest_type</th>\n",
       "      <th>search_conducted</th>\n",
       "      <th>search_outcome</th>\n",
       "      <th>search_reason_for_stop</th>\n",
       "      <th>search_disposition</th>\n",
       "      <th>search_reason</th>\n",
       "      <th>search_type</th>\n",
       "      <th>search_arrest_reason</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>POINT (-77.130466 39.0126813333333)</td>\n",
       "      <td>f08d0293-6ade-4802-84c1-4b7b1a707245</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>03:12:00</td>\n",
       "      <td>MCP</td>\n",
       "      <td>2nd District, Bethesda</td>\n",
       "      <td>RECKLESS DRIVING VEHICLE IN WANTON AND WILLFUL...</td>\n",
       "      <td>IFO 9609 SINGLETON DR</td>\n",
       "      <td>39.012681</td>\n",
       "      <td>-77.130466</td>\n",
       "      <td>...</td>\n",
       "      <td>MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>A - Marked Patrol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>POINT (-77.130466 39.0126813333333)</td>\n",
       "      <td>f08d0293-6ade-4802-84c1-4b7b1a707245</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>03:12:00</td>\n",
       "      <td>MCP</td>\n",
       "      <td>2nd District, Bethesda</td>\n",
       "      <td>FAILURE OF VEH. DRIVER IN ACCIDENT TO LOCATE A...</td>\n",
       "      <td>IFO 9609 SINGLETON DR</td>\n",
       "      <td>39.012681</td>\n",
       "      <td>-77.130466</td>\n",
       "      <td>...</td>\n",
       "      <td>MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>A - Marked Patrol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>POINT (-77.130466 39.0126813333333)</td>\n",
       "      <td>f08d0293-6ade-4802-84c1-4b7b1a707245</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>03:12:00</td>\n",
       "      <td>MCP</td>\n",
       "      <td>2nd District, Bethesda</td>\n",
       "      <td>NEGLIGENT DRIVING VEHICLE IN CARELESS AND IMPR...</td>\n",
       "      <td>IFO 9609 SINGLETON DR</td>\n",
       "      <td>39.012681</td>\n",
       "      <td>-77.130466</td>\n",
       "      <td>...</td>\n",
       "      <td>MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>A - Marked Patrol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>POINT (-77.130466 39.0126813333333)</td>\n",
       "      <td>f08d0293-6ade-4802-84c1-4b7b1a707245</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>03:12:00</td>\n",
       "      <td>MCP</td>\n",
       "      <td>2nd District, Bethesda</td>\n",
       "      <td>FAILURE OF VEH. DRIVER TO STOP AFTER UNATTENDE...</td>\n",
       "      <td>IFO 9609 SINGLETON DR</td>\n",
       "      <td>39.012681</td>\n",
       "      <td>-77.130466</td>\n",
       "      <td>...</td>\n",
       "      <td>MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>A - Marked Patrol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>POINT (-77.130466 39.0126813333333)</td>\n",
       "      <td>f08d0293-6ade-4802-84c1-4b7b1a707245</td>\n",
       "      <td>2021-01-01</td>\n",
       "      <td>03:12:00</td>\n",
       "      <td>MCP</td>\n",
       "      <td>2nd District, Bethesda</td>\n",
       "      <td>FAILURE OF VEH. DRIVER INVOLVED IN ACCIDENT TO...</td>\n",
       "      <td>IFO 9609 SINGLETON DR</td>\n",
       "      <td>39.012681</td>\n",
       "      <td>-77.130466</td>\n",
       "      <td>...</td>\n",
       "      <td>MD</td>\n",
       "      <td>MD</td>\n",
       "      <td>A - Marked Patrol</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 43 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                              geometry                                seq_id  \\\n",
       "0  POINT (-77.130466 39.0126813333333)  f08d0293-6ade-4802-84c1-4b7b1a707245   \n",
       "1  POINT (-77.130466 39.0126813333333)  f08d0293-6ade-4802-84c1-4b7b1a707245   \n",
       "2  POINT (-77.130466 39.0126813333333)  f08d0293-6ade-4802-84c1-4b7b1a707245   \n",
       "3  POINT (-77.130466 39.0126813333333)  f08d0293-6ade-4802-84c1-4b7b1a707245   \n",
       "4  POINT (-77.130466 39.0126813333333)  f08d0293-6ade-4802-84c1-4b7b1a707245   \n",
       "\n",
       "  date_of_stop time_of_stop agency               subagency  \\\n",
       "0   2021-01-01     03:12:00    MCP  2nd District, Bethesda   \n",
       "1   2021-01-01     03:12:00    MCP  2nd District, Bethesda   \n",
       "2   2021-01-01     03:12:00    MCP  2nd District, Bethesda   \n",
       "3   2021-01-01     03:12:00    MCP  2nd District, Bethesda   \n",
       "4   2021-01-01     03:12:00    MCP  2nd District, Bethesda   \n",
       "\n",
       "                                         description               location  \\\n",
       "0  RECKLESS DRIVING VEHICLE IN WANTON AND WILLFUL...  IFO 9609 SINGLETON DR   \n",
       "1  FAILURE OF VEH. DRIVER IN ACCIDENT TO LOCATE A...  IFO 9609 SINGLETON DR   \n",
       "2  NEGLIGENT DRIVING VEHICLE IN CARELESS AND IMPR...  IFO 9609 SINGLETON DR   \n",
       "3  FAILURE OF VEH. DRIVER TO STOP AFTER UNATTENDE...  IFO 9609 SINGLETON DR   \n",
       "4  FAILURE OF VEH. DRIVER INVOLVED IN ACCIDENT TO...  IFO 9609 SINGLETON DR   \n",
       "\n",
       "    latitude  longitude  ... driver_state dl_state        arrest_type  \\\n",
       "0  39.012681 -77.130466  ...           MD       MD  A - Marked Patrol   \n",
       "1  39.012681 -77.130466  ...           MD       MD  A - Marked Patrol   \n",
       "2  39.012681 -77.130466  ...           MD       MD  A - Marked Patrol   \n",
       "3  39.012681 -77.130466  ...           MD       MD  A - Marked Patrol   \n",
       "4  39.012681 -77.130466  ...           MD       MD  A - Marked Patrol   \n",
       "\n",
       "  search_conducted search_outcome search_reason_for_stop search_disposition  \\\n",
       "0              NaN            NaN                    NaN                NaN   \n",
       "1              NaN            NaN                    NaN                NaN   \n",
       "2              NaN            NaN                    NaN                NaN   \n",
       "3              NaN            NaN                    NaN                NaN   \n",
       "4              NaN            NaN                    NaN                NaN   \n",
       "\n",
       "  search_reason search_type search_arrest_reason  \n",
       "0           NaN         NaN                  NaN  \n",
       "1           NaN         NaN                  NaN  \n",
       "2           NaN         NaN                  NaN  \n",
       "3           NaN         NaN                  NaN  \n",
       "4           NaN         NaN                  NaN  \n",
       "\n",
       "[5 rows x 43 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# To load data back in from CSV, create a new source and use load_from_csv\n",
    "# load_from_csv usage is similar to load except for the output_dir\n",
    "# input\n",
    "src = opd.Source(source_name=\"Montgomery County\", state=\"Maryland\")\n",
    "t = src.load_from_csv(year=2021, table_type='TRAFFIC STOPS', output_dir=csv_filepath)\n",
    "t.table.head()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.9.12 ('opd')",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "a73158d29711b2da05ac73de25b71e5d8cae591f14917bba77a9573b5c85a0ce"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}