notebooks/highdose.inhaled.steroids.combi.agent.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This list of VMPs/AMPs is derived from the numerator of [OpenPrescribing high dose inhaled corticosteroid measure](https://github.com/ebmdatalab/openprescribing/blob/master/openprescribing/measure_definitions/icsdose.json) definition and inhalers reported with single agent devices removed."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from ebmdatalab import bq\n",
    "import os\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "lines_to_next_cell": 0
   },
   "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>type</th>\n",
       "      <th>id</th>\n",
       "      <th>bnf_code</th>\n",
       "      <th>nm</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>amp</td>\n",
       "      <td>31063411000001101</td>\n",
       "      <td>0302000C0BQABBZ</td>\n",
       "      <td>Fostair 200micrograms/dose / 6micrograms/dose inhaler (Chiesi Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>amp</td>\n",
       "      <td>31063111000001106</td>\n",
       "      <td>0302000C0BRABCA</td>\n",
       "      <td>Fostair NEXThaler 200micrograms/dose / 6micrograms/dose dry powder inhaler (Chiesi Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>amp</td>\n",
       "      <td>4373811000001100</td>\n",
       "      <td>0302000K0BDACAU</td>\n",
       "      <td>Symbicort 400/12 Turbohaler (AstraZeneca UK Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>amp</td>\n",
       "      <td>25254711000001106</td>\n",
       "      <td>0302000K0BHABAU</td>\n",
       "      <td>DuoResp Spiromax 320micrograms/dose / 9micrograms/dose dry powder inhaler (Teva UK Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>amp</td>\n",
       "      <td>34812111000001106</td>\n",
       "      <td>0302000K0BIAAAU</td>\n",
       "      <td>Fobumix Easyhaler 320micrograms/dose / 9micrograms/dose dry powder inhaler (Orion Pharma (UK) Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>amp</td>\n",
       "      <td>31064811000001101</td>\n",
       "      <td>0302000N0AAAZAZ</td>\n",
       "      <td>Fluticasone propionate 500micrograms/dose / Salmeterol 50micrograms/dose dry powder inhaler (A A H Pharmaceuticals Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>amp</td>\n",
       "      <td>3188311000001102</td>\n",
       "      <td>0302000N0BCACAZ</td>\n",
       "      <td>Seretide 500 Accuhaler (GlaxoSmithKline UK Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>amp</td>\n",
       "      <td>539811000001106</td>\n",
       "      <td>0302000N0BCAFBG</td>\n",
       "      <td>Seretide 250 Evohaler (GlaxoSmithKline UK Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>amp</td>\n",
       "      <td>21019711000001107</td>\n",
       "      <td>0302000N0BDABBK</td>\n",
       "      <td>Flutiform 250micrograms/dose / 10micrograms/dose inhaler (Napp Pharmaceuticals Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>amp</td>\n",
       "      <td>29782511000001103</td>\n",
       "      <td>0302000N0BFABBG</td>\n",
       "      <td>Sirdupla 25micrograms/dose / 250micrograms/dose inhaler (Mylan)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>amp</td>\n",
       "      <td>30950311000001106</td>\n",
       "      <td>0302000N0BGAAAZ</td>\n",
       "      <td>AirFluSal Forspiro 50micrograms/dose / 500micrograms/dose dry powder inhaler (Sandoz Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>amp</td>\n",
       "      <td>34215511000001101</td>\n",
       "      <td>0302000N0BGACBG</td>\n",
       "      <td>AirFluSal 25micrograms/dose / 250micrograms/dose inhaler (Sandoz Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>amp</td>\n",
       "      <td>33679711000001103</td>\n",
       "      <td>0302000N0BHAAAZ</td>\n",
       "      <td>Aerivio Spiromax 50micrograms/dose / 500micrograms/dose dry powder inhaler (Teva UK Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>amp</td>\n",
       "      <td>34023811000001102</td>\n",
       "      <td>0302000N0BIABBG</td>\n",
       "      <td>Sereflo 25micrograms/dose / 250micrograms/dose inhaler (Cipla EU Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>amp</td>\n",
       "      <td>34675711000001103</td>\n",
       "      <td>0302000N0BJABBG</td>\n",
       "      <td>Aloflute 25micrograms/dose / 250micrograms/dose inhaler (Mylan)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>amp</td>\n",
       "      <td>35515311000001106</td>\n",
       "      <td>0302000N0BKABAZ</td>\n",
       "      <td>Fusacomb Easyhaler 50micrograms/dose / 500micrograms/dose dry powder inhaler (Orion Pharma (UK) Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>amp</td>\n",
       "      <td>35594411000001101</td>\n",
       "      <td>0302000N0BLACBG</td>\n",
       "      <td>Combisal 25micrograms/dose / 250micrograms/dose inhaler (Aspire Pharma Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>amp</td>\n",
       "      <td>36604711000001102</td>\n",
       "      <td>0302000N0BMAAAZ</td>\n",
       "      <td>Stalpex 50micrograms/dose / 500micrograms/dose dry powder inhaler (Glenmark Pharmaceuticals Europe Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>amp</td>\n",
       "      <td>23621711000001102</td>\n",
       "      <td>0302000V0BBAAAA</td>\n",
       "      <td>Relvar Ellipta 184micrograms/dose / 22micrograms/dose dry powder inhaler (GlaxoSmithKline UK Ltd)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>vmp</td>\n",
       "      <td>31087411000001106</td>\n",
       "      <td>0302000C0AABZBZ</td>\n",
       "      <td>Beclometasone 200micrograms/dose / Formoterol 6micrograms/dose inhaler CFC free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>vmp</td>\n",
       "      <td>31087511000001105</td>\n",
       "      <td>0302000C0AACACA</td>\n",
       "      <td>Beclometasone 200micrograms/dose / Formoterol 6micrograms/dose dry powder inhaler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>vmp</td>\n",
       "      <td>4378111000001103</td>\n",
       "      <td>0302000K0AAAUAU</td>\n",
       "      <td>Budesonide 400micrograms/dose / Formoterol 12micrograms/dose dry powder inhaler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>vmp</td>\n",
       "      <td>320280004</td>\n",
       "      <td>0302000N0AAAZAZ</td>\n",
       "      <td>Fluticasone propionate 500micrograms/dose / Salmeterol 50micrograms/dose dry powder inhaler</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>vmp</td>\n",
       "      <td>320276009</td>\n",
       "      <td>0302000N0AABGBG</td>\n",
       "      <td>Fluticasone 250micrograms/dose / Salmeterol 25micrograms/dose inhaler CFC free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>vmp</td>\n",
       "      <td>21113811000001105</td>\n",
       "      <td>0302000N0AABKBK</td>\n",
       "      <td>Fluticasone 250micrograms/dose / Formoterol 10micrograms/dose inhaler CFC free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>vmp</td>\n",
       "      <td>23661311000001105</td>\n",
       "      <td>0302000V0AAAAAA</td>\n",
       "      <td>Fluticasone furoate 184micrograms/dose / Vilanterol 22micrograms/dose dry powder inhaler</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   type                 id         bnf_code  \\\n",
       "0   amp  31063411000001101  0302000C0BQABBZ   \n",
       "1   amp  31063111000001106  0302000C0BRABCA   \n",
       "2   amp   4373811000001100  0302000K0BDACAU   \n",
       "3   amp  25254711000001106  0302000K0BHABAU   \n",
       "4   amp  34812111000001106  0302000K0BIAAAU   \n",
       "5   amp  31064811000001101  0302000N0AAAZAZ   \n",
       "6   amp   3188311000001102  0302000N0BCACAZ   \n",
       "7   amp    539811000001106  0302000N0BCAFBG   \n",
       "8   amp  21019711000001107  0302000N0BDABBK   \n",
       "9   amp  29782511000001103  0302000N0BFABBG   \n",
       "10  amp  30950311000001106  0302000N0BGAAAZ   \n",
       "11  amp  34215511000001101  0302000N0BGACBG   \n",
       "12  amp  33679711000001103  0302000N0BHAAAZ   \n",
       "13  amp  34023811000001102  0302000N0BIABBG   \n",
       "14  amp  34675711000001103  0302000N0BJABBG   \n",
       "15  amp  35515311000001106  0302000N0BKABAZ   \n",
       "16  amp  35594411000001101  0302000N0BLACBG   \n",
       "17  amp  36604711000001102  0302000N0BMAAAZ   \n",
       "18  amp  23621711000001102  0302000V0BBAAAA   \n",
       "19  vmp  31087411000001106  0302000C0AABZBZ   \n",
       "20  vmp  31087511000001105  0302000C0AACACA   \n",
       "21  vmp   4378111000001103  0302000K0AAAUAU   \n",
       "22  vmp          320280004  0302000N0AAAZAZ   \n",
       "23  vmp          320276009  0302000N0AABGBG   \n",
       "24  vmp  21113811000001105  0302000N0AABKBK   \n",
       "25  vmp  23661311000001105  0302000V0AAAAAA   \n",
       "\n",
       "                                                                                                                         nm  \n",
       "0                                                        Fostair 200micrograms/dose / 6micrograms/dose inhaler (Chiesi Ltd)  \n",
       "1                                   Fostair NEXThaler 200micrograms/dose / 6micrograms/dose dry powder inhaler (Chiesi Ltd)  \n",
       "2                                                                          Symbicort 400/12 Turbohaler (AstraZeneca UK Ltd)  \n",
       "3                                   DuoResp Spiromax 320micrograms/dose / 9micrograms/dose dry powder inhaler (Teva UK Ltd)  \n",
       "4                        Fobumix Easyhaler 320micrograms/dose / 9micrograms/dose dry powder inhaler (Orion Pharma (UK) Ltd)  \n",
       "5   Fluticasone propionate 500micrograms/dose / Salmeterol 50micrograms/dose dry powder inhaler (A A H Pharmaceuticals Ltd)  \n",
       "6                                                                           Seretide 500 Accuhaler (GlaxoSmithKline UK Ltd)  \n",
       "7                                                                            Seretide 250 Evohaler (GlaxoSmithKline UK Ltd)  \n",
       "8                                       Flutiform 250micrograms/dose / 10micrograms/dose inhaler (Napp Pharmaceuticals Ltd)  \n",
       "9                                                           Sirdupla 25micrograms/dose / 250micrograms/dose inhaler (Mylan)  \n",
       "10                                AirFluSal Forspiro 50micrograms/dose / 500micrograms/dose dry powder inhaler (Sandoz Ltd)  \n",
       "11                                                    AirFluSal 25micrograms/dose / 250micrograms/dose inhaler (Sandoz Ltd)  \n",
       "12                                 Aerivio Spiromax 50micrograms/dose / 500micrograms/dose dry powder inhaler (Teva UK Ltd)  \n",
       "13                                                    Sereflo 25micrograms/dose / 250micrograms/dose inhaler (Cipla EU Ltd)  \n",
       "14                                                          Aloflute 25micrograms/dose / 250micrograms/dose inhaler (Mylan)  \n",
       "15                     Fusacomb Easyhaler 50micrograms/dose / 500micrograms/dose dry powder inhaler (Orion Pharma (UK) Ltd)  \n",
       "16                                              Combisal 25micrograms/dose / 250micrograms/dose inhaler (Aspire Pharma Ltd)  \n",
       "17                  Stalpex 50micrograms/dose / 500micrograms/dose dry powder inhaler (Glenmark Pharmaceuticals Europe Ltd)  \n",
       "18                        Relvar Ellipta 184micrograms/dose / 22micrograms/dose dry powder inhaler (GlaxoSmithKline UK Ltd)  \n",
       "19                                          Beclometasone 200micrograms/dose / Formoterol 6micrograms/dose inhaler CFC free  \n",
       "20                                        Beclometasone 200micrograms/dose / Formoterol 6micrograms/dose dry powder inhaler  \n",
       "21                                          Budesonide 400micrograms/dose / Formoterol 12micrograms/dose dry powder inhaler  \n",
       "22                              Fluticasone propionate 500micrograms/dose / Salmeterol 50micrograms/dose dry powder inhaler  \n",
       "23                                           Fluticasone 250micrograms/dose / Salmeterol 25micrograms/dose inhaler CFC free  \n",
       "24                                           Fluticasone 250micrograms/dose / Formoterol 10micrograms/dose inhaler CFC free  \n",
       "25                                 Fluticasone furoate 184micrograms/dose / Vilanterol 22micrograms/dose dry powder inhaler  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sql = '''WITH bnf_codes AS (\n",
    "  SELECT DISTINCT bnf_code FROM measures.dmd_objs_with_form_route WHERE \n",
    "   (bnf_code LIKE \"0302000C0%BZ\" OR # Beclomet/Formoterol_Inh 200/6 (120D) CFF (brands and generic)\",\n",
    "   bnf_code LIKE \"0302000C0%CA\" OR # Beclomet/Formoterol_Inh 200/6 (120D) Dry (brands and generic)\",\n",
    "   bnf_code LIKE \"0302000K0%AU\" OR # Budesonide/Formoterol_InhaB/A 400/12(60D (brands and generic)\",\n",
    "   bnf_code LIKE \"0302000N0%AZ\" OR # Fluticasone/Salmeterol_Inh 500/50mcg 60D (brands and generic)\",\n",
    "   bnf_code LIKE \"0302000N0%BG\" OR # Fluticasone/Salmeterol_Inh 250/25mcg120D (brands and generic)\",\n",
    "   bnf_code LIKE \"0302000N0%BK\" OR # Fluticasone/Formoterol_Inh 250/10mcg120D (brands and generic)\",\n",
    "   bnf_code LIKE \"0302000V0%AA\")   # Fluticasone/Vilanterol_Inha 184/22mcg30D (brands and generic)\"\n",
    "   AND\n",
    "(form_route LIKE '%pressurizedinhalation.inhalation' OR form_route LIKE 'powderinhalation.inhalation%')\n",
    "   )\n",
    "   \n",
    "SELECT \"vmp\" AS type, id, bnf_code, nm\n",
    "FROM dmd.vmp\n",
    "WHERE bnf_code IN (SELECT * FROM bnf_codes)\n",
    "\n",
    "UNION ALL\n",
    "\n",
    "SELECT \"amp\" AS type, id, bnf_code, descr\n",
    "FROM dmd.amp\n",
    "WHERE bnf_code IN (SELECT * FROM bnf_codes)\n",
    "\n",
    "ORDER BY type, bnf_code, id'''\n",
    "\n",
    "highdose_inhaledsteroids_combiagent_codelist = bq.cached_read(sql, csv_path=os.path.join('..','data','highdose_inhaledsteroid_combiagent_codelist.csv'))\n",
    "pd.set_option('display.max_rows', None)\n",
    "pd.set_option('display.max_colwidth', None)\n",
    "highdose_inhaledsteroids_combiagent_codelist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n"
   ]
  }
 ],
 "metadata": {
  "jupytext": {
   "cell_metadata_filter": "all",
   "notebook_metadata_filter": "all,-language_info",
   "text_representation": {
    "extension": ".py",
    "format_name": "light",
    "format_version": "1.5",
    "jupytext_version": "1.3.3"
   }
  },
  "kernelspec": {
   "display_name": "Python 3",
   "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.8.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}