zBigQuery_Exploration_v001.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "2c78fc2f-7add-4e47-9fa4-3e9fe12906fa",
   "metadata": {},
   "outputs": [],
   "source": [
    "# https://cloud.google.com/vertex-ai/docs/workbench/instances/bigquery\n",
    "# https://cloud.google.com/vertex-ai/docs/workbench/instances/visualize-data-bigquery\n",
    "# https://rspraneethkumar.medium.com/accessing-google-big-query-from-jupyter-notebook-878145ce37dc\n",
    "# https://colab.research.google.com/notebooks/bigquery.ipynb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "62b00634-8401-40fd-a065-9a71f2cbc06f",
   "metadata": {},
   "outputs": [],
   "source": [
    "#%%time\n",
    "#!conda install conda-forge::pandas-gbq --yes\n",
    "#!conda install -c conda-forge google-colab --yes\n",
    "#!conda search google-cloud --channel conda-forge\n",
    "#!pip install google-cloud\n",
    "#!pip install google-cloud-bigquery[pandas]\n",
    "#!pip install google-cloud-storage\n",
    "#!pip install --upgrade pydata-google-auth google-cloud-bigquery[pandas]\n",
    "#!python -m pip install --upgrade pip\n",
    "#!pip install --upgrade google-cloud\n",
    "#!pip install --upgrade google-cloud-bigquery\n",
    "#!pip install --upgrade google-cloud-storage"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8c962d6c-71d1-4d4f-9d48-35bff6998db6",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "23fe8309-1729-45a1-95c8-de4d584154b9",
   "metadata": {},
   "outputs": [],
   "source": [
    "#import pydata_google_auth\n",
    "#link = 'https://www.googleapis.com/auth/bigquery'\n",
    "#credentials = pydata_google_auth.get_user_credentials([link],)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "25c67071-14c0-460d-a342-6c01c7384222",
   "metadata": {},
   "outputs": [],
   "source": [
    "from google.cloud import bigquery; import os\n",
    "PATH_TO_PROJECT_KEY_FILE = r\"C:\\Users\\alber\\Python Projects\\BigQuery\\credentials\\alien-marking-381621-cd22f49bef67.json\"\n",
    "credentials = os.environ['GOOGLE_APPLICATION_CREDENTIALS'] = PATH_TO_PROJECT_KEY_FILE\n",
    "bigquery_client = bigquery.Client()\n",
    "%load_ext google.cloud.bigquery"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "152d11f9-4442-4017-a109-2f30930633e2",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd;\n",
    "pd.options.display.max_columns = 200\n",
    "pd.options.display.precision   = 2\n",
    "pd.set_option.precision        = 2\n",
    "import IPython; #print(IPython.sys_info())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "976a1f76-9b98-4f76-a401-88442d3bd2dc",
   "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>table_catalog</th>\n",
       "      <th>table_schema</th>\n",
       "      <th>table_name</th>\n",
       "      <th>table_type</th>\n",
       "      <th>is_insertable_into</th>\n",
       "      <th>is_typed</th>\n",
       "      <th>creation_time</th>\n",
       "      <th>base_table_catalog</th>\n",
       "      <th>base_table_schema</th>\n",
       "      <th>base_table_name</th>\n",
       "      <th>snapshot_time_ms</th>\n",
       "      <th>ddl</th>\n",
       "      <th>default_collation_name</th>\n",
       "      <th>upsert_stream_apply_watermark</th>\n",
       "      <th>replica_source_catalog</th>\n",
       "      <th>replica_source_schema</th>\n",
       "      <th>replica_source_name</th>\n",
       "      <th>replication_status</th>\n",
       "      <th>replication_error</th>\n",
       "      <th>is_change_history_enabled</th>\n",
       "      <th>sync_status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>bigquery-public-data</td>\n",
       "      <td>fda_drug</td>\n",
       "      <td>drug_label</td>\n",
       "      <td>BASE TABLE</td>\n",
       "      <td>YES</td>\n",
       "      <td>NO</td>\n",
       "      <td>2017-07-14 19:10:10.984000+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaT</td>\n",
       "      <td>CREATE TABLE `bigquery-public-data.fda_drug.dr...</td>\n",
       "      <td>NULL</td>\n",
       "      <td>NaT</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NO</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>bigquery-public-data</td>\n",
       "      <td>fda_drug</td>\n",
       "      <td>drug_enforcement</td>\n",
       "      <td>BASE TABLE</td>\n",
       "      <td>YES</td>\n",
       "      <td>NO</td>\n",
       "      <td>2017-07-14 17:25:58.200000+00:00</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaT</td>\n",
       "      <td>CREATE TABLE `bigquery-public-data.fda_drug.dr...</td>\n",
       "      <td>NULL</td>\n",
       "      <td>NaT</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NO</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          table_catalog table_schema        table_name  table_type  \\\n",
       "0  bigquery-public-data     fda_drug        drug_label  BASE TABLE   \n",
       "1  bigquery-public-data     fda_drug  drug_enforcement  BASE TABLE   \n",
       "\n",
       "  is_insertable_into is_typed                    creation_time  \\\n",
       "0                YES       NO 2017-07-14 19:10:10.984000+00:00   \n",
       "1                YES       NO 2017-07-14 17:25:58.200000+00:00   \n",
       "\n",
       "  base_table_catalog base_table_schema base_table_name snapshot_time_ms  \\\n",
       "0               None              None            None              NaT   \n",
       "1               None              None            None              NaT   \n",
       "\n",
       "                                                 ddl default_collation_name  \\\n",
       "0  CREATE TABLE `bigquery-public-data.fda_drug.dr...                   NULL   \n",
       "1  CREATE TABLE `bigquery-public-data.fda_drug.dr...                   NULL   \n",
       "\n",
       "  upsert_stream_apply_watermark replica_source_catalog replica_source_schema  \\\n",
       "0                           NaT                   None                  None   \n",
       "1                           NaT                   None                  None   \n",
       "\n",
       "  replica_source_name replication_status replication_error  \\\n",
       "0                None               None              None   \n",
       "1                None               None              None   \n",
       "\n",
       "  is_change_history_enabled sync_status  \n",
       "0                        NO        None  \n",
       "1                        NO        None  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## RETURNS METADATA FOR tables IN a single dataset.\n",
    "QUERY = \"\"\"\n",
    "SELECT *\n",
    "FROM   bigquery-public-data.fda_drug.INFORMATION_SCHEMA.TABLES\n",
    "        \"\"\"\n",
    "Query_Results = bigquery_client.query(QUERY)\n",
    "df = Query_Results.to_dataframe()\n",
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "d47a5b0a-2c52-4ab8-bf77-c99f0a5a475b",
   "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>catalog_name</th>\n",
       "      <th>schema_name</th>\n",
       "      <th>schema_owner</th>\n",
       "      <th>creation_time</th>\n",
       "      <th>last_modified_time</th>\n",
       "      <th>location</th>\n",
       "      <th>ddl</th>\n",
       "      <th>default_collation_name</th>\n",
       "      <th>sync_status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [catalog_name, schema_name, schema_owner, creation_time, last_modified_time, location, ddl, default_collation_name, sync_status]\n",
       "Index: []"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "##Returns metadata for all datasets in a region.\n",
    "QUERY = \"\"\"\n",
    "SELECT * FROM region-us.INFORMATION_SCHEMA.SCHEMATA\n",
    "        \"\"\"\n",
    "Query_Results = bigquery_client.query(QUERY)\n",
    "df = Query_Results.to_dataframe()\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "64a43db2-fcc0-4666-b183-8a1e6279f90a",
   "metadata": {},
   "outputs": [],
   "source": [
    "#samples.gsod\n",
    "#fda_drug\n",
    "dataset = \"fda_drug\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "403457f7-9e6e-4835-b44d-136e6cc25e2f",
   "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>table_catalog</th>\n",
       "      <th>table_schema</th>\n",
       "      <th>table_name</th>\n",
       "      <th>column_name</th>\n",
       "      <th>field_path</th>\n",
       "      <th>data_type</th>\n",
       "      <th>description</th>\n",
       "      <th>collation_name</th>\n",
       "      <th>rounding_mode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>bigquery-public-data</td>\n",
       "      <td>fda_drug</td>\n",
       "      <td>drug_label</td>\n",
       "      <td>openfda_spl_set_id</td>\n",
       "      <td>openfda_spl_set_id</td>\n",
       "      <td>STRING</td>\n",
       "      <td>Unique identifier for the Structured Product L...</td>\n",
       "      <td>NULL</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>bigquery-public-data</td>\n",
       "      <td>fda_drug</td>\n",
       "      <td>drug_label</td>\n",
       "      <td>package_label_principal_display_panel</td>\n",
       "      <td>package_label_principal_display_panel</td>\n",
       "      <td>STRING</td>\n",
       "      <td>The content of the principal display panel of ...</td>\n",
       "      <td>NULL</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>bigquery-public-data</td>\n",
       "      <td>fda_drug</td>\n",
       "      <td>drug_label</td>\n",
       "      <td>openfda_manufacturer_name</td>\n",
       "      <td>openfda_manufacturer_name</td>\n",
       "      <td>STRING</td>\n",
       "      <td>Name of manufacturer or company that makes thi...</td>\n",
       "      <td>NULL</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>bigquery-public-data</td>\n",
       "      <td>fda_drug</td>\n",
       "      <td>drug_label</td>\n",
       "      <td>openfda_unii</td>\n",
       "      <td>openfda_unii</td>\n",
       "      <td>STRING</td>\n",
       "      <td>Unique Ingredient Identifier, which is a non-p...</td>\n",
       "      <td>NULL</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>bigquery-public-data</td>\n",
       "      <td>fda_drug</td>\n",
       "      <td>drug_label</td>\n",
       "      <td>openfda_product_type</td>\n",
       "      <td>openfda_product_type</td>\n",
       "      <td>STRING</td>\n",
       "      <td></td>\n",
       "      <td>NULL</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          table_catalog table_schema  table_name  \\\n",
       "0  bigquery-public-data     fda_drug  drug_label   \n",
       "1  bigquery-public-data     fda_drug  drug_label   \n",
       "2  bigquery-public-data     fda_drug  drug_label   \n",
       "3  bigquery-public-data     fda_drug  drug_label   \n",
       "4  bigquery-public-data     fda_drug  drug_label   \n",
       "\n",
       "                             column_name  \\\n",
       "0                     openfda_spl_set_id   \n",
       "1  package_label_principal_display_panel   \n",
       "2              openfda_manufacturer_name   \n",
       "3                           openfda_unii   \n",
       "4                   openfda_product_type   \n",
       "\n",
       "                              field_path data_type  \\\n",
       "0                     openfda_spl_set_id    STRING   \n",
       "1  package_label_principal_display_panel    STRING   \n",
       "2              openfda_manufacturer_name    STRING   \n",
       "3                           openfda_unii    STRING   \n",
       "4                   openfda_product_type    STRING   \n",
       "\n",
       "                                         description collation_name  \\\n",
       "0  Unique identifier for the Structured Product L...           NULL   \n",
       "1  The content of the principal display panel of ...           NULL   \n",
       "2  Name of manufacturer or company that makes thi...           NULL   \n",
       "3  Unique Ingredient Identifier, which is a non-p...           NULL   \n",
       "4                                                              NULL   \n",
       "\n",
       "  rounding_mode  \n",
       "0          None  \n",
       "1          None  \n",
       "2          None  \n",
       "3          None  \n",
       "4          None  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## Retrieves metadata from the Tables\n",
    "dataset = \"fda_drug\"\n",
    "#         .         .         .         .         .         .         .\n",
    "QUERY = f\"\"\"\n",
    "SELECT  *\n",
    "FROM `bigquery-public-data`.{dataset}.INFORMATION_SCHEMA.COLUMN_FIELD_PATHS\n",
    "        \"\"\"\n",
    "Query_Results = bigquery_client.query(QUERY)\n",
    "df = Query_Results.to_dataframe()\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "5236b457-41bd-4e30-89dd-2a1b5a8b8f7a",
   "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>table_catalog</th>\n",
       "      <th>table_schema</th>\n",
       "      <th>table_name</th>\n",
       "      <th>column_name</th>\n",
       "      <th>field_path</th>\n",
       "      <th>data_type</th>\n",
       "      <th>description</th>\n",
       "      <th>collation_name</th>\n",
       "      <th>rounding_mode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>bigquery-public-data</td>\n",
       "      <td>fda_drug</td>\n",
       "      <td>drug_label</td>\n",
       "      <td>openfda_spl_set_id</td>\n",
       "      <td>openfda_spl_set_id</td>\n",
       "      <td>STRING</td>\n",
       "      <td>Unique identifier for the Structured Product L...</td>\n",
       "      <td>NULL</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>bigquery-public-data</td>\n",
       "      <td>fda_drug</td>\n",
       "      <td>drug_label</td>\n",
       "      <td>package_label_principal_display_panel</td>\n",
       "      <td>package_label_principal_display_panel</td>\n",
       "      <td>STRING</td>\n",
       "      <td>The content of the principal display panel of ...</td>\n",
       "      <td>NULL</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>bigquery-public-data</td>\n",
       "      <td>fda_drug</td>\n",
       "      <td>drug_label</td>\n",
       "      <td>openfda_manufacturer_name</td>\n",
       "      <td>openfda_manufacturer_name</td>\n",
       "      <td>STRING</td>\n",
       "      <td>Name of manufacturer or company that makes thi...</td>\n",
       "      <td>NULL</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>bigquery-public-data</td>\n",
       "      <td>fda_drug</td>\n",
       "      <td>drug_label</td>\n",
       "      <td>openfda_unii</td>\n",
       "      <td>openfda_unii</td>\n",
       "      <td>STRING</td>\n",
       "      <td>Unique Ingredient Identifier, which is a non-p...</td>\n",
       "      <td>NULL</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>bigquery-public-data</td>\n",
       "      <td>fda_drug</td>\n",
       "      <td>drug_label</td>\n",
       "      <td>openfda_product_type</td>\n",
       "      <td>openfda_product_type</td>\n",
       "      <td>STRING</td>\n",
       "      <td></td>\n",
       "      <td>NULL</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          table_catalog table_schema  table_name  \\\n",
       "0  bigquery-public-data     fda_drug  drug_label   \n",
       "1  bigquery-public-data     fda_drug  drug_label   \n",
       "2  bigquery-public-data     fda_drug  drug_label   \n",
       "3  bigquery-public-data     fda_drug  drug_label   \n",
       "4  bigquery-public-data     fda_drug  drug_label   \n",
       "\n",
       "                             column_name  \\\n",
       "0                     openfda_spl_set_id   \n",
       "1  package_label_principal_display_panel   \n",
       "2              openfda_manufacturer_name   \n",
       "3                           openfda_unii   \n",
       "4                   openfda_product_type   \n",
       "\n",
       "                              field_path data_type  \\\n",
       "0                     openfda_spl_set_id    STRING   \n",
       "1  package_label_principal_display_panel    STRING   \n",
       "2              openfda_manufacturer_name    STRING   \n",
       "3                           openfda_unii    STRING   \n",
       "4                   openfda_product_type    STRING   \n",
       "\n",
       "                                         description collation_name  \\\n",
       "0  Unique identifier for the Structured Product L...           NULL   \n",
       "1  The content of the principal display panel of ...           NULL   \n",
       "2  Name of manufacturer or company that makes thi...           NULL   \n",
       "3  Unique Ingredient Identifier, which is a non-p...           NULL   \n",
       "4                                                              NULL   \n",
       "\n",
       "  rounding_mode  \n",
       "0          None  \n",
       "1          None  \n",
       "2          None  \n",
       "3          None  \n",
       "4          None  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "## Retrieves metadata from the Tables\n",
    "QUERY = f\"\"\"\n",
    "SELECT  *\n",
    "FROM `bigquery-public-data`.{dataset}.INFORMATION_SCHEMA.COLUMN_FIELD_PATHS\n",
    "        \"\"\"\n",
    "Query_Results = bigquery_client.query(QUERY)\n",
    "df = Query_Results.to_dataframe()\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "71788126-5c7f-4957-8e32-d83e5c7e9f7c",
   "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>openfda_spl_set_id</th>\n",
       "      <th>package_label_principal_display_panel</th>\n",
       "      <th>openfda_manufacturer_name</th>\n",
       "      <th>openfda_unii</th>\n",
       "      <th>openfda_product_type</th>\n",
       "      <th>openfda_rxcui</th>\n",
       "      <th>openfda_route</th>\n",
       "      <th>openfda_generic_name</th>\n",
       "      <th>openfda_brand_name</th>\n",
       "      <th>openfda_product_ndc</th>\n",
       "      <th>openfda_original_packager_product_ndc</th>\n",
       "      <th>openfda_substance_name</th>\n",
       "      <th>openfda_spl_id</th>\n",
       "      <th>openfda_pharm_class_moa</th>\n",
       "      <th>openfda_application_number</th>\n",
       "      <th>openfda_nui</th>\n",
       "      <th>openfda_pharm_class_epc</th>\n",
       "      <th>openfda_package_ndc</th>\n",
       "      <th>carcinogenesis_and_mutagenesis_and_impairment_of_fertility</th>\n",
       "      <th>references</th>\n",
       "      <th>pregnancy</th>\n",
       "      <th>pharmacokinetics</th>\n",
       "      <th>drug_interactions</th>\n",
       "      <th>id</th>\n",
       "      <th>indications_and_usage</th>\n",
       "      <th>pharmacokinetics_table</th>\n",
       "      <th>pharmacodynamics_table</th>\n",
       "      <th>microbiology</th>\n",
       "      <th>contraindications</th>\n",
       "      <th>version</th>\n",
       "      <th>spl_medguide</th>\n",
       "      <th>pediatric_use</th>\n",
       "      <th>information_for_patients</th>\n",
       "      <th>dosage_forms_and_strengths</th>\n",
       "      <th>microbiology_table</th>\n",
       "      <th>recent_major_changes</th>\n",
       "      <th>description</th>\n",
       "      <th>dosage_and_administration</th>\n",
       "      <th>clinical_pharmacology_table</th>\n",
       "      <th>effective_time</th>\n",
       "      <th>mechanism_of_action</th>\n",
       "      <th>geriatric_use</th>\n",
       "      <th>adverse_reactions</th>\n",
       "      <th>clinical_pharmacology</th>\n",
       "      <th>clinical_studies</th>\n",
       "      <th>use_in_specific_populations</th>\n",
       "      <th>nonclinical_toxicology</th>\n",
       "      <th>spl_product_data_elements</th>\n",
       "      <th>clinical_studies_table</th>\n",
       "      <th>overdosage</th>\n",
       "      <th>pharmacodynamics</th>\n",
       "      <th>warnings_and_cautions</th>\n",
       "      <th>dosage_and_administration_table</th>\n",
       "      <th>animal_pharmacology_and_or_toxicology</th>\n",
       "      <th>how_supplied</th>\n",
       "      <th>nursing_mothers</th>\n",
       "      <th>set_id</th>\n",
       "      <th>drug_abuse_and_dependence</th>\n",
       "      <th>controlled_substance</th>\n",
       "      <th>abuse</th>\n",
       "      <th>dependence</th>\n",
       "      <th>drug_and_or_laboratory_test_interactions</th>\n",
       "      <th>purpose</th>\n",
       "      <th>active_ingredient</th>\n",
       "      <th>inactive_ingredient</th>\n",
       "      <th>spl_patient_package_insert</th>\n",
       "      <th>information_for_owners_or_caregivers</th>\n",
       "      <th>instructions_for_use</th>\n",
       "      <th>ask_doctor</th>\n",
       "      <th>ask_doctor_or_pharmacist</th>\n",
       "      <th>do_not_use</th>\n",
       "      <th>keep_out_of_reach_of_children</th>\n",
       "      <th>other_safety_information</th>\n",
       "      <th>questions</th>\n",
       "      <th>stop_use</th>\n",
       "      <th>when_using</th>\n",
       "      <th>patient_medication_information</th>\n",
       "      <th>teratogenic_effects</th>\n",
       "      <th>labor_and_delivery</th>\n",
       "      <th>pregnancy_or_breast_feeding</th>\n",
       "      <th>storage_and_handling</th>\n",
       "      <th>safe_handling_warning</th>\n",
       "      <th>boxed_warning</th>\n",
       "      <th>user_safety_warnings</th>\n",
       "      <th>precautions</th>\n",
       "      <th>warnings</th>\n",
       "      <th>general_precautions</th>\n",
       "      <th>laboratory_tests</th>\n",
       "      <th>spl_unclassified_section</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>cad2d826-2cee-4e2c-9f81-918a6476b365</td>\n",
       "      <td>Green Tussin DM label</td>\n",
       "      <td>Green Choice for Life</td>\n",
       "      <td>9D2RTI9KYH,495W7451VQ</td>\n",
       "      <td>HUMAN OTC DRUG</td>\n",
       "      <td>1298228,1435089</td>\n",
       "      <td>ORAL</td>\n",
       "      <td>GUAIFENESIN, DEXTROMETHORPHAN HBR</td>\n",
       "      <td>Green Tussin DM</td>\n",
       "      <td>55287-100</td>\n",
       "      <td>None</td>\n",
       "      <td>GUAIFENESIN,DEXTROMETHORPHAN HYDROBROMIDE</td>\n",
       "      <td>9cdb77bc-a883-4e1e-ac32-c2ae1af3afe6</td>\n",
       "      <td>None</td>\n",
       "      <td>part341</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>55287-100-06</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>9cdb77bc-a883-4e1e-ac32-c2ae1af3afe6</td>\n",
       "      <td>Uses temporarily relieves cough due to minor t...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Do not exceed 6 doses in 24 hours Use dose cup...</td>\n",
       "      <td>None</td>\n",
       "      <td>2013-08-09</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Green TussinDM Guaifenesin, Dextromethorphan H...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>cad2d826-2cee-4e2c-9f81-918a6476b365</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Cough Suppressant Expectorant</td>\n",
       "      <td>Active Ingredients (in each 15 mL) Dextrometho...</td>\n",
       "      <td>Inactive Ingredients aloe, ascorbic acid, cara...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Do not use this product for persistent or chro...</td>\n",
       "      <td>Keep out of reach of children.</td>\n",
       "      <td>Other information store this product between 1...</td>\n",
       "      <td>Questions? call 305-763-3228 M-F 9 am to 5 pm ...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>If pregnant or breast-feeding, ask health prof...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Warnings Do not exceed recommended dosage. A p...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>64210cdc-75c0-2536-e053-2991aa0abd64</td>\n",
       "      <td>1</td>\n",
       "      <td>ST Life Co.,Ltd.</td>\n",
       "      <td>K72T3FS567</td>\n",
       "      <td>HUMAN OTC DRUG</td>\n",
       "      <td>None</td>\n",
       "      <td>VAGINAL</td>\n",
       "      <td>ADENOSINE</td>\n",
       "      <td>INNER SAVE Feminine Cleansing Mist</td>\n",
       "      <td>72068-0001</td>\n",
       "      <td>None</td>\n",
       "      <td>ADENOSINE</td>\n",
       "      <td>64210cdc-75c5-2536-e053-2991aa0abd64</td>\n",
       "      <td>Adenosine Receptor Agonists [MoA]</td>\n",
       "      <td>None</td>\n",
       "      <td>N0000175788,N0000178375</td>\n",
       "      <td>Adenosine Receptor Agonist [EPC]</td>\n",
       "      <td>72068-0001-1</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>64210cdc-75c5-2536-e053-2991aa0abd64</td>\n",
       "      <td>Take the proper amount of this product and app...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>for external use only</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-02-01</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>INNER SAVE Feminine Cleansing Mist Adenosine A...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>64210cdc-75c0-2536-e053-2991aa0abd64</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Wrinkle repair</td>\n",
       "      <td>Adenosine</td>\n",
       "      <td>Cypress leaf extract, Mugwort extract, Aloe ve...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>keep out or reach of the children</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>[Warning] Stop use and ask a doctor if you hav...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>None</td>\n",
       "      <td>DRUG: Doxepin Hydrochloride GENERIC: doxepin h...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Drug Interactions Drugs Metabolized by P450 2D...</td>\n",
       "      <td>402d4aad-9eaf-6b47-e054-00144ff8d46c</td>\n",
       "      <td>INDICATIONS AND USAGE Doxepin Hydrochloride Ca...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>CONTRAINDICATIONS Doxepin hydrochloride capsul...</td>\n",
       "      <td>156</td>\n",
       "      <td>Medication Guide Antidepressant Medicines, Dep...</td>\n",
       "      <td>None</td>\n",
       "      <td>Information for Patients Prescribers or other ...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>DESCRIPTION Doxepin hydrochloride is one of a ...</td>\n",
       "      <td>DOSAGE AND ADMINISTRATION For most patients wi...</td>\n",
       "      <td>None</td>\n",
       "      <td>2016-10-31</td>\n",
       "      <td>None</td>\n",
       "      <td>Geriatric Use A determination has not been mad...</td>\n",
       "      <td>ADVERSE REACTIONS NOTE: Some of the adverse re...</td>\n",
       "      <td>CLINICAL PHARMACOLOGY The mechanism of action ...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Doxepin Hydrochloride doxepin hydrochloride SI...</td>\n",
       "      <td>None</td>\n",
       "      <td>OVERDOSAGE Deaths may occur from overdosage wi...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HOW SUPPLIED Doxepin Hydrochloride Capsules, U...</td>\n",
       "      <td>None</td>\n",
       "      <td>cea90a32-b896-4776-8236-a3ba6bc51df1</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Suicidality and Antidepressant Drugs Antidepre...</td>\n",
       "      <td>None</td>\n",
       "      <td>PRECAUTIONS Information for Patients Prescribe...</td>\n",
       "      <td>WARNINGS Clinical Worsening and Suicide Risk P...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>05fb437b-3771-4814-ae07-6068b009680b</td>\n",
       "      <td>Principal Display Panel allergy Original presc...</td>\n",
       "      <td>Sam's West Inc</td>\n",
       "      <td>64O047KTOA</td>\n",
       "      <td>HUMAN OTC DRUG</td>\n",
       "      <td>1014678</td>\n",
       "      <td>ORAL</td>\n",
       "      <td>CETIRIZINE HYDROCHLORIDE</td>\n",
       "      <td>simply right cetirizine hydrochloride</td>\n",
       "      <td>68196-702</td>\n",
       "      <td>None</td>\n",
       "      <td>CETIRIZINE HYDROCHLORIDE</td>\n",
       "      <td>05fb437b-3771-4814-ae07-6068b009680b</td>\n",
       "      <td>None</td>\n",
       "      <td>ANDA078336</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>68196-702-13,68196-702-07,68196-702-39,68196-7...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>05fb437b-3771-4814-ae07-6068b009680b</td>\n",
       "      <td>Uses temporarily relieves these symptoms due t...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Directions adults and children 6 years and ove...</td>\n",
       "      <td>None</td>\n",
       "      <td>2013-09-11</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>simply right cetirizine hydrochloride Cetirizi...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>&lt;table&gt; &lt;col width=\"25%\"/&gt; &lt;col width=\"75%\"/&gt; ...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>05fb437b-3771-4814-ae07-6068b009680b</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Purpose Antihistamine</td>\n",
       "      <td>Active ingredient (in each tablet) Cetirizine ...</td>\n",
       "      <td>Inactive ingredients corn starch, FD&amp;C blue no...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Ask a doctor before use if you have liver or k...</td>\n",
       "      <td>Ask a doctor or pharmacist before use if you a...</td>\n",
       "      <td>Do not use if you have ever had an allergic re...</td>\n",
       "      <td>Keep out of reach of children. In case of over...</td>\n",
       "      <td>None</td>\n",
       "      <td>Questions or comments? 1-800-809-0469</td>\n",
       "      <td>Stop use and ask a doctor if an allergic react...</td>\n",
       "      <td>When using this product •drowsiness may occur ...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>If pregnant or breast-feeding: •if breast-feed...</td>\n",
       "      <td>Other information •do not use if blister unit ...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Warnings Do not use if you have ever had an al...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>fb0b4228-33bd-4899-8b46-be5e9d4606d0</td>\n",
       "      <td>PACKAGE LABEL Label Image for 53808-0906 10mg ...</td>\n",
       "      <td>State of Florida DOH Central Pharmacy</td>\n",
       "      <td>I1E9D14F36</td>\n",
       "      <td>HUMAN PRESCRIPTION DRUG</td>\n",
       "      <td>283672</td>\n",
       "      <td>ORAL</td>\n",
       "      <td>CITALOPRAM</td>\n",
       "      <td>Citalopram</td>\n",
       "      <td>53808-0906</td>\n",
       "      <td>0378-6231</td>\n",
       "      <td>CITALOPRAM HYDROBROMIDE</td>\n",
       "      <td>3b9c1dbd-4ce0-45bc-a469-a688ec2b0bae</td>\n",
       "      <td>None</td>\n",
       "      <td>ANDA077042</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>53808-0906-1</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Pharmacokinetics The single- and multiple-dose...</td>\n",
       "      <td>None</td>\n",
       "      <td>3b9c1dbd-4ce0-45bc-a469-a688ec2b0bae</td>\n",
       "      <td>INDICATIONS AND USAGE Citalopram tablets are i...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>CONTRAINDICATIONS The use of MAOIs intended to...</td>\n",
       "      <td>1</td>\n",
       "      <td>MEDICATION GUIDE CITALOPRAM TABLETS, USP (cye ...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>DESCRIPTION Citalopram hydrobromide is an oral...</td>\n",
       "      <td>DOSAGE AND ADMINISTRATION Citalopram tablets s...</td>\n",
       "      <td>None</td>\n",
       "      <td>2014-02-27</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>ADVERSE REACTIONS The premarketing development...</td>\n",
       "      <td>CLINICAL PHARMACOLOGY Pharmacodynamics The mec...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>ANIMAL TOXICOLOGY Retinal Changes in Rats Path...</td>\n",
       "      <td>Citalopram citalopram CITALOPRAM HYDROBROMIDE ...</td>\n",
       "      <td>None</td>\n",
       "      <td>OVERDOSAGE Human Experience In clinical trials...</td>\n",
       "      <td>Pharmacodynamics The mechanism of action of ci...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>HOW SUPPLIED Citalopram Tablets, USP are avail...</td>\n",
       "      <td>None</td>\n",
       "      <td>fb0b4228-33bd-4899-8b46-be5e9d4606d0</td>\n",
       "      <td>DRUG ABUSE AND DEPENDENCE Controlled Substance...</td>\n",
       "      <td>Controlled Substance Class Citalopram hydrobro...</td>\n",
       "      <td>None</td>\n",
       "      <td>Physical and Psychological Dependence Animal s...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Teratogenic Effects</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Suicidality and Antidepressant Drugs: Antidepr...</td>\n",
       "      <td>None</td>\n",
       "      <td>PRECAUTIONS General Discontinuation of Treatme...</td>\n",
       "      <td>WARNINGS Clinical Worsening and Suicide Risk P...</td>\n",
       "      <td>General</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     openfda_spl_set_id  \\\n",
       "0  cad2d826-2cee-4e2c-9f81-918a6476b365   \n",
       "1  64210cdc-75c0-2536-e053-2991aa0abd64   \n",
       "2                                  None   \n",
       "3  05fb437b-3771-4814-ae07-6068b009680b   \n",
       "4  fb0b4228-33bd-4899-8b46-be5e9d4606d0   \n",
       "\n",
       "               package_label_principal_display_panel  \\\n",
       "0                              Green Tussin DM label   \n",
       "1                                                  1   \n",
       "2  DRUG: Doxepin Hydrochloride GENERIC: doxepin h...   \n",
       "3  Principal Display Panel allergy Original presc...   \n",
       "4  PACKAGE LABEL Label Image for 53808-0906 10mg ...   \n",
       "\n",
       "               openfda_manufacturer_name           openfda_unii  \\\n",
       "0                  Green Choice for Life  9D2RTI9KYH,495W7451VQ   \n",
       "1                       ST Life Co.,Ltd.             K72T3FS567   \n",
       "2                                   None                   None   \n",
       "3                         Sam's West Inc             64O047KTOA   \n",
       "4  State of Florida DOH Central Pharmacy             I1E9D14F36   \n",
       "\n",
       "      openfda_product_type    openfda_rxcui openfda_route  \\\n",
       "0           HUMAN OTC DRUG  1298228,1435089          ORAL   \n",
       "1           HUMAN OTC DRUG             None       VAGINAL   \n",
       "2                     None             None          None   \n",
       "3           HUMAN OTC DRUG          1014678          ORAL   \n",
       "4  HUMAN PRESCRIPTION DRUG           283672          ORAL   \n",
       "\n",
       "                openfda_generic_name                     openfda_brand_name  \\\n",
       "0  GUAIFENESIN, DEXTROMETHORPHAN HBR                        Green Tussin DM   \n",
       "1                          ADENOSINE     INNER SAVE Feminine Cleansing Mist   \n",
       "2                               None                                   None   \n",
       "3           CETIRIZINE HYDROCHLORIDE  simply right cetirizine hydrochloride   \n",
       "4                         CITALOPRAM                             Citalopram   \n",
       "\n",
       "  openfda_product_ndc openfda_original_packager_product_ndc  \\\n",
       "0           55287-100                                  None   \n",
       "1          72068-0001                                  None   \n",
       "2                None                                  None   \n",
       "3           68196-702                                  None   \n",
       "4          53808-0906                             0378-6231   \n",
       "\n",
       "                      openfda_substance_name  \\\n",
       "0  GUAIFENESIN,DEXTROMETHORPHAN HYDROBROMIDE   \n",
       "1                                  ADENOSINE   \n",
       "2                                       None   \n",
       "3                   CETIRIZINE HYDROCHLORIDE   \n",
       "4                    CITALOPRAM HYDROBROMIDE   \n",
       "\n",
       "                         openfda_spl_id            openfda_pharm_class_moa  \\\n",
       "0  9cdb77bc-a883-4e1e-ac32-c2ae1af3afe6                               None   \n",
       "1  64210cdc-75c5-2536-e053-2991aa0abd64  Adenosine Receptor Agonists [MoA]   \n",
       "2                                  None                               None   \n",
       "3  05fb437b-3771-4814-ae07-6068b009680b                               None   \n",
       "4  3b9c1dbd-4ce0-45bc-a469-a688ec2b0bae                               None   \n",
       "\n",
       "  openfda_application_number              openfda_nui  \\\n",
       "0                    part341                     None   \n",
       "1                       None  N0000175788,N0000178375   \n",
       "2                       None                     None   \n",
       "3                 ANDA078336                     None   \n",
       "4                 ANDA077042                     None   \n",
       "\n",
       "            openfda_pharm_class_epc  \\\n",
       "0                              None   \n",
       "1  Adenosine Receptor Agonist [EPC]   \n",
       "2                              None   \n",
       "3                              None   \n",
       "4                              None   \n",
       "\n",
       "                                 openfda_package_ndc  \\\n",
       "0                                       55287-100-06   \n",
       "1                                       72068-0001-1   \n",
       "2                                               None   \n",
       "3  68196-702-13,68196-702-07,68196-702-39,68196-7...   \n",
       "4                                       53808-0906-1   \n",
       "\n",
       "  carcinogenesis_and_mutagenesis_and_impairment_of_fertility references  \\\n",
       "0                                               None               None   \n",
       "1                                               None               None   \n",
       "2                                               None               None   \n",
       "3                                               None               None   \n",
       "4                                               None               None   \n",
       "\n",
       "  pregnancy                                   pharmacokinetics  \\\n",
       "0      None                                               None   \n",
       "1      None                                               None   \n",
       "2      None                                               None   \n",
       "3      None                                               None   \n",
       "4      None  Pharmacokinetics The single- and multiple-dose...   \n",
       "\n",
       "                                   drug_interactions  \\\n",
       "0                                               None   \n",
       "1                                               None   \n",
       "2  Drug Interactions Drugs Metabolized by P450 2D...   \n",
       "3                                               None   \n",
       "4                                               None   \n",
       "\n",
       "                                     id  \\\n",
       "0  9cdb77bc-a883-4e1e-ac32-c2ae1af3afe6   \n",
       "1  64210cdc-75c5-2536-e053-2991aa0abd64   \n",
       "2  402d4aad-9eaf-6b47-e054-00144ff8d46c   \n",
       "3  05fb437b-3771-4814-ae07-6068b009680b   \n",
       "4  3b9c1dbd-4ce0-45bc-a469-a688ec2b0bae   \n",
       "\n",
       "                               indications_and_usage pharmacokinetics_table  \\\n",
       "0  Uses temporarily relieves cough due to minor t...                   None   \n",
       "1  Take the proper amount of this product and app...                   None   \n",
       "2  INDICATIONS AND USAGE Doxepin Hydrochloride Ca...                   None   \n",
       "3  Uses temporarily relieves these symptoms due t...                   None   \n",
       "4  INDICATIONS AND USAGE Citalopram tablets are i...                   None   \n",
       "\n",
       "  pharmacodynamics_table microbiology  \\\n",
       "0                   None         None   \n",
       "1                   None         None   \n",
       "2                   None         None   \n",
       "3                   None         None   \n",
       "4                   None         None   \n",
       "\n",
       "                                   contraindications  version  \\\n",
       "0                                               None        1   \n",
       "1                                               None        1   \n",
       "2  CONTRAINDICATIONS Doxepin hydrochloride capsul...      156   \n",
       "3                                               None        1   \n",
       "4  CONTRAINDICATIONS The use of MAOIs intended to...        1   \n",
       "\n",
       "                                        spl_medguide pediatric_use  \\\n",
       "0                                               None          None   \n",
       "1                                               None          None   \n",
       "2  Medication Guide Antidepressant Medicines, Dep...          None   \n",
       "3                                               None          None   \n",
       "4  MEDICATION GUIDE CITALOPRAM TABLETS, USP (cye ...          None   \n",
       "\n",
       "                            information_for_patients  \\\n",
       "0                                               None   \n",
       "1                                               None   \n",
       "2  Information for Patients Prescribers or other ...   \n",
       "3                                               None   \n",
       "4                                               None   \n",
       "\n",
       "  dosage_forms_and_strengths microbiology_table recent_major_changes  \\\n",
       "0                       None               None                 None   \n",
       "1                       None               None                 None   \n",
       "2                       None               None                 None   \n",
       "3                       None               None                 None   \n",
       "4                       None               None                 None   \n",
       "\n",
       "                                         description  \\\n",
       "0                                               None   \n",
       "1                                               None   \n",
       "2  DESCRIPTION Doxepin hydrochloride is one of a ...   \n",
       "3                                               None   \n",
       "4  DESCRIPTION Citalopram hydrobromide is an oral...   \n",
       "\n",
       "                           dosage_and_administration  \\\n",
       "0  Do not exceed 6 doses in 24 hours Use dose cup...   \n",
       "1                              for external use only   \n",
       "2  DOSAGE AND ADMINISTRATION For most patients wi...   \n",
       "3  Directions adults and children 6 years and ove...   \n",
       "4  DOSAGE AND ADMINISTRATION Citalopram tablets s...   \n",
       "\n",
       "  clinical_pharmacology_table effective_time mechanism_of_action  \\\n",
       "0                        None     2013-08-09                None   \n",
       "1                        None     2018-02-01                None   \n",
       "2                        None     2016-10-31                None   \n",
       "3                        None     2013-09-11                None   \n",
       "4                        None     2014-02-27                None   \n",
       "\n",
       "                                       geriatric_use  \\\n",
       "0                                               None   \n",
       "1                                               None   \n",
       "2  Geriatric Use A determination has not been mad...   \n",
       "3                                               None   \n",
       "4                                               None   \n",
       "\n",
       "                                   adverse_reactions  \\\n",
       "0                                               None   \n",
       "1                                               None   \n",
       "2  ADVERSE REACTIONS NOTE: Some of the adverse re...   \n",
       "3                                               None   \n",
       "4  ADVERSE REACTIONS The premarketing development...   \n",
       "\n",
       "                               clinical_pharmacology clinical_studies  \\\n",
       "0                                               None             None   \n",
       "1                                               None             None   \n",
       "2  CLINICAL PHARMACOLOGY The mechanism of action ...             None   \n",
       "3                                               None             None   \n",
       "4  CLINICAL PHARMACOLOGY Pharmacodynamics The mec...             None   \n",
       "\n",
       "  use_in_specific_populations  \\\n",
       "0                        None   \n",
       "1                        None   \n",
       "2                        None   \n",
       "3                        None   \n",
       "4                        None   \n",
       "\n",
       "                              nonclinical_toxicology  \\\n",
       "0                                               None   \n",
       "1                                               None   \n",
       "2                                               None   \n",
       "3                                               None   \n",
       "4  ANIMAL TOXICOLOGY Retinal Changes in Rats Path...   \n",
       "\n",
       "                           spl_product_data_elements clinical_studies_table  \\\n",
       "0  Green TussinDM Guaifenesin, Dextromethorphan H...                   None   \n",
       "1  INNER SAVE Feminine Cleansing Mist Adenosine A...                   None   \n",
       "2  Doxepin Hydrochloride doxepin hydrochloride SI...                   None   \n",
       "3  simply right cetirizine hydrochloride Cetirizi...                   None   \n",
       "4  Citalopram citalopram CITALOPRAM HYDROBROMIDE ...                   None   \n",
       "\n",
       "                                          overdosage  \\\n",
       "0                                               None   \n",
       "1                                               None   \n",
       "2  OVERDOSAGE Deaths may occur from overdosage wi...   \n",
       "3                                               None   \n",
       "4  OVERDOSAGE Human Experience In clinical trials...   \n",
       "\n",
       "                                    pharmacodynamics warnings_and_cautions  \\\n",
       "0                                               None                  None   \n",
       "1                                               None                  None   \n",
       "2                                               None                  None   \n",
       "3                                               None                  None   \n",
       "4  Pharmacodynamics The mechanism of action of ci...                  None   \n",
       "\n",
       "                     dosage_and_administration_table  \\\n",
       "0                                               None   \n",
       "1                                               None   \n",
       "2                                               None   \n",
       "3  <table> <col width=\"25%\"/> <col width=\"75%\"/> ...   \n",
       "4                                               None   \n",
       "\n",
       "  animal_pharmacology_and_or_toxicology  \\\n",
       "0                                  None   \n",
       "1                                  None   \n",
       "2                                  None   \n",
       "3                                  None   \n",
       "4                                  None   \n",
       "\n",
       "                                        how_supplied nursing_mothers  \\\n",
       "0                                               None            None   \n",
       "1                                               None            None   \n",
       "2  HOW SUPPLIED Doxepin Hydrochloride Capsules, U...            None   \n",
       "3                                               None            None   \n",
       "4  HOW SUPPLIED Citalopram Tablets, USP are avail...            None   \n",
       "\n",
       "                                 set_id  \\\n",
       "0  cad2d826-2cee-4e2c-9f81-918a6476b365   \n",
       "1  64210cdc-75c0-2536-e053-2991aa0abd64   \n",
       "2  cea90a32-b896-4776-8236-a3ba6bc51df1   \n",
       "3  05fb437b-3771-4814-ae07-6068b009680b   \n",
       "4  fb0b4228-33bd-4899-8b46-be5e9d4606d0   \n",
       "\n",
       "                           drug_abuse_and_dependence  \\\n",
       "0                                               None   \n",
       "1                                               None   \n",
       "2                                               None   \n",
       "3                                               None   \n",
       "4  DRUG ABUSE AND DEPENDENCE Controlled Substance...   \n",
       "\n",
       "                                controlled_substance abuse  \\\n",
       "0                                               None  None   \n",
       "1                                               None  None   \n",
       "2                                               None  None   \n",
       "3                                               None  None   \n",
       "4  Controlled Substance Class Citalopram hydrobro...  None   \n",
       "\n",
       "                                          dependence  \\\n",
       "0                                               None   \n",
       "1                                               None   \n",
       "2                                               None   \n",
       "3                                               None   \n",
       "4  Physical and Psychological Dependence Animal s...   \n",
       "\n",
       "  drug_and_or_laboratory_test_interactions                        purpose  \\\n",
       "0                                     None  Cough Suppressant Expectorant   \n",
       "1                                     None                 Wrinkle repair   \n",
       "2                                     None                           None   \n",
       "3                                     None          Purpose Antihistamine   \n",
       "4                                     None                           None   \n",
       "\n",
       "                                   active_ingredient  \\\n",
       "0  Active Ingredients (in each 15 mL) Dextrometho...   \n",
       "1                                          Adenosine   \n",
       "2                                               None   \n",
       "3  Active ingredient (in each tablet) Cetirizine ...   \n",
       "4                                               None   \n",
       "\n",
       "                                 inactive_ingredient  \\\n",
       "0  Inactive Ingredients aloe, ascorbic acid, cara...   \n",
       "1  Cypress leaf extract, Mugwort extract, Aloe ve...   \n",
       "2                                               None   \n",
       "3  Inactive ingredients corn starch, FD&C blue no...   \n",
       "4                                               None   \n",
       "\n",
       "  spl_patient_package_insert information_for_owners_or_caregivers  \\\n",
       "0                       None                                 None   \n",
       "1                       None                                 None   \n",
       "2                       None                                 None   \n",
       "3                       None                                 None   \n",
       "4                       None                                 None   \n",
       "\n",
       "  instructions_for_use                                         ask_doctor  \\\n",
       "0                 None                                               None   \n",
       "1                 None                                               None   \n",
       "2                 None                                               None   \n",
       "3                 None  Ask a doctor before use if you have liver or k...   \n",
       "4                 None                                               None   \n",
       "\n",
       "                            ask_doctor_or_pharmacist  \\\n",
       "0                                               None   \n",
       "1                                               None   \n",
       "2                                               None   \n",
       "3  Ask a doctor or pharmacist before use if you a...   \n",
       "4                                               None   \n",
       "\n",
       "                                          do_not_use  \\\n",
       "0  Do not use this product for persistent or chro...   \n",
       "1                                               None   \n",
       "2                                               None   \n",
       "3  Do not use if you have ever had an allergic re...   \n",
       "4                                               None   \n",
       "\n",
       "                       keep_out_of_reach_of_children  \\\n",
       "0                     Keep out of reach of children.   \n",
       "1                  keep out or reach of the children   \n",
       "2                                               None   \n",
       "3  Keep out of reach of children. In case of over...   \n",
       "4                                               None   \n",
       "\n",
       "                            other_safety_information  \\\n",
       "0  Other information store this product between 1...   \n",
       "1                                               None   \n",
       "2                                               None   \n",
       "3                                               None   \n",
       "4                                               None   \n",
       "\n",
       "                                           questions  \\\n",
       "0  Questions? call 305-763-3228 M-F 9 am to 5 pm ...   \n",
       "1                                               None   \n",
       "2                                               None   \n",
       "3              Questions or comments? 1-800-809-0469   \n",
       "4                                               None   \n",
       "\n",
       "                                            stop_use  \\\n",
       "0                                               None   \n",
       "1                                               None   \n",
       "2                                               None   \n",
       "3  Stop use and ask a doctor if an allergic react...   \n",
       "4                                               None   \n",
       "\n",
       "                                          when_using  \\\n",
       "0                                               None   \n",
       "1                                               None   \n",
       "2                                               None   \n",
       "3  When using this product •drowsiness may occur ...   \n",
       "4                                               None   \n",
       "\n",
       "  patient_medication_information  teratogenic_effects labor_and_delivery  \\\n",
       "0                           None                 None               None   \n",
       "1                           None                 None               None   \n",
       "2                           None                 None               None   \n",
       "3                           None                 None               None   \n",
       "4                           None  Teratogenic Effects               None   \n",
       "\n",
       "                         pregnancy_or_breast_feeding  \\\n",
       "0  If pregnant or breast-feeding, ask health prof...   \n",
       "1                                               None   \n",
       "2                                               None   \n",
       "3  If pregnant or breast-feeding: •if breast-feed...   \n",
       "4                                               None   \n",
       "\n",
       "                                storage_and_handling safe_handling_warning  \\\n",
       "0                                               None                  None   \n",
       "1                                               None                  None   \n",
       "2                                               None                  None   \n",
       "3  Other information •do not use if blister unit ...                  None   \n",
       "4                                               None                  None   \n",
       "\n",
       "                                       boxed_warning user_safety_warnings  \\\n",
       "0                                               None                 None   \n",
       "1                                               None                 None   \n",
       "2  Suicidality and Antidepressant Drugs Antidepre...                 None   \n",
       "3                                               None                 None   \n",
       "4  Suicidality and Antidepressant Drugs: Antidepr...                 None   \n",
       "\n",
       "                                         precautions  \\\n",
       "0                                               None   \n",
       "1                                               None   \n",
       "2  PRECAUTIONS Information for Patients Prescribe...   \n",
       "3                                               None   \n",
       "4  PRECAUTIONS General Discontinuation of Treatme...   \n",
       "\n",
       "                                            warnings general_precautions  \\\n",
       "0  Warnings Do not exceed recommended dosage. A p...                None   \n",
       "1  [Warning] Stop use and ask a doctor if you hav...                None   \n",
       "2  WARNINGS Clinical Worsening and Suicide Risk P...                None   \n",
       "3  Warnings Do not use if you have ever had an al...                None   \n",
       "4  WARNINGS Clinical Worsening and Suicide Risk P...             General   \n",
       "\n",
       "  laboratory_tests spl_unclassified_section  \n",
       "0             None                     None  \n",
       "1             None                     None  \n",
       "2             None                     None  \n",
       "3             None                     None  \n",
       "4             None                     None  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataset = \"fda_drug\" ; table = \"drug_label\"\n",
    "#         .         .         .         .         .         .         .\n",
    "QUERY = f\"\"\"\n",
    "SELECT * FROM bigquery-public-data.{dataset}.{table}\n",
    "ORDER BY RAND()\n",
    "LIMIT 5  \"\"\"\n",
    "#         .         .         .         .         .         .         .\n",
    "Query_Results = bigquery_client.query(QUERY)\n",
    "df = Query_Results.to_dataframe()\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4e64e904-730b-492a-b183-bea6cd92d04b",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "68830cb5-d903-4977-b695-e4d31c298442",
   "metadata": {},
   "outputs": [],
   "source": [
    "QUERY = \"\"\"\n",
    "SELECT primary_type, year, COUNT(unique_key) AS Crime_Count\n",
    "FROM  `bigquery-public-data.austin_crime.crime`\n",
    "GROUP BY primary_type, year\n",
    "ORDER BY year DESC, Crime_Count DESC\n",
    "        \"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "d0f97a2f-df5f-47d3-b124-1d7ee6906323",
   "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>primary_type</th>\n",
       "      <th>year</th>\n",
       "      <th>Crime_Count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Theft</td>\n",
       "      <td>2016</td>\n",
       "      <td>26240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Burglary</td>\n",
       "      <td>2016</td>\n",
       "      <td>5171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Agg Assault</td>\n",
       "      <td>2016</td>\n",
       "      <td>2176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Auto Theft</td>\n",
       "      <td>2016</td>\n",
       "      <td>2025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Robbery</td>\n",
       "      <td>2016</td>\n",
       "      <td>1050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Rape</td>\n",
       "      <td>2016</td>\n",
       "      <td>759</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Murder</td>\n",
       "      <td>2016</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Theft</td>\n",
       "      <td>2015</td>\n",
       "      <td>28274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Burglary</td>\n",
       "      <td>2015</td>\n",
       "      <td>4927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Auto Theft</td>\n",
       "      <td>2015</td>\n",
       "      <td>2018</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  primary_type  year  Crime_Count\n",
       "0        Theft  2016        26240\n",
       "1     Burglary  2016         5171\n",
       "2  Agg Assault  2016         2176\n",
       "3   Auto Theft  2016         2025\n",
       "4      Robbery  2016         1050\n",
       "5         Rape  2016          759\n",
       "6       Murder  2016           38\n",
       "7        Theft  2015        28274\n",
       "8     Burglary  2015         4927\n",
       "9   Auto Theft  2015         2018"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Query_Results = bigquery_client.query(QUERY)\n",
    "df = Query_Results.to_dataframe()\n",
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fbd298de-ec38-400d-b6b4-6513b893beb7",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "476988f1-b850-4032-b0b7-1917e34f6819",
   "metadata": {},
   "outputs": [],
   "source": [
    "QUERY = \"\"\"\n",
    "SELECT COUNT(*) as total FROM `bigquery-public-data.austin_crime.crime`\n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "f6b58c55-577c-409a-beb8-0139bb679272",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The full dataset has 116672 rows\n"
     ]
    }
   ],
   "source": [
    "row_count = bigquery_client.query(QUERY).to_dataframe().total[0]\n",
    "print('The full dataset has %d rows' % row_count)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3408b707-ebc7-4863-9a99-aba207bb2b5f",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0fbe35d4-65f3-4b26-9963-9ac943e7a502",
   "metadata": {},
   "outputs": [],
   "source": [
    "QUERY = \"\"\"\n",
    "SELECT source_year AS year, COUNT(is_male) AS birth_count\n",
    "FROM `bigquery-public-data.samples.natality`\n",
    "GROUP BY year\n",
    "ORDER BY year DESC\n",
    "LIMIT 15\"\"\" "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9836bc2e-4a5e-4a49-8d43-8e32ab03124f",
   "metadata": {},
   "outputs": [],
   "source": [
    "Query_Results = bigquery_client.query(QUERY)\n",
    "df = Query_Results.to_dataframe()\n",
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "92190dae-a7c7-4563-b09c-647fc414247a",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "deb1d64f-550d-4c32-a11f-b6c01b19dafc",
   "metadata": {},
   "outputs": [],
   "source": [
    "QUERY = \"\"\"\n",
    "SELECT country_code, country_name, COUNT(DISTINCT region_code) AS num_regions\n",
    "FROM  `bigquery-public-data.google_trends.international_top_terms`\n",
    "WHERE  refresh_date = DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)\n",
    "GROUP BY  country_code,  country_name\n",
    "ORDER BY  num_regions DESC;\n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "53e315fb-1cee-473d-9945-8f2cdd3374f8",
   "metadata": {},
   "outputs": [],
   "source": [
    "Query_Results = bigquery_client.query(QUERY)\n",
    "df = Query_Results.to_dataframe()\n",
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c1f6c09d-9e01-4252-b22a-b22289eb60e0",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "dab5513b-060c-4228-a392-bc5f774ecd3a",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2519cef8-771b-49f2-9b45-bb7bc198d95c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3cd5e32c-125c-4b7c-9b30-6d706a79327b",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b0141665-917c-41fa-bfee-199370e2fcbd",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "057e9c71-d1b5-47f5-a4b5-be71f37cc745",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9b7bacc5-1631-437d-9798-a5a46e96039d",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "01ba2d6e-20cc-4153-bf09-7e5e5c70f161",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "31d45a8f-1a04-437e-abeb-b71069c11bbb",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "edb970ca-200e-479d-9721-49d1c902bfd9",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c91b3fae-38f2-4a70-ada9-27bb477c5dff",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4436fe6b-d0d5-4034-8c42-9a97d45a9997",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "virtualENV",
   "language": "python",
   "name": "virtualenv"
  },
  "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.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}