PREVIEW: Specials/imported products

Below are the database queries which are used to create this measure. These are run against a copy of the BSA prescribing data which we store in Google BigQuery. We're working on making our BigQuery tables publicly available at which point it will be possible to run and modify these queries yourself. But even where code and database queries are not directly useable by others we believe it is always preferable to make them public.

Description	Spend on specials/imported products per 1000 registered patients
Why it matters	The Drug Tariff provides the following definitions for specials and imported products: Specials are unlicensed medicinal products manufactured in the UK for human use which have been specially prepared to meet a prescription ordered for individual patients without the need for the manufacturer to hold a marketing authorisation for the medicinal product concerned. Imported products are unlicensed medicinal products sourced from outside the UK under an importers licence issued by the MHRA. These products have been specially sourced to meet a prescription ordered for individual patients without the need for the importer to hold a marketing authorisation for the medicinal product concerned. Both special and imported products have not undergone the same rigorous regulatory requirements and should, therefore, only be used when an appropriate UK-licensed product is unavailable. In addition they are frequently more expensive than licensed alternatives.
Tags
Implies cost savings	Yes
History	View change history on GitHub →

Numerator SQL

SELECT
     CAST(month AS DATE) AS month,
     practice AS practice_id,
     SUM(actual_cost) AS numerator
 FROM hscic.normalised_prescribing
 WHERE bnf_code IN ("0101010I0AAADAD", "0101010I0AAAHAH", "0101010I0AAAXAX", "0101010I0AABPBP", "0101010I0AABRBR", "0101010I0BCAABI", "0101010N0AAABAB", "0101012B0AAALAL", "0101012B0AAAYAY", "0101012B0AABABA", "0101012B0AABMBM", "0101012B0AABTBT", "0101021C0AAANAN", "0101021C0AAATAT", "0101021C0AABDBD", "0101021C0AABQBQ", "0101021C0AACECE", "0101021C0AACKCK", "0101021C0AACRCR", "0101021C0AACUCU", "0101021C0AACWCW", "0101021C0AACXCX", "0101021C0AACYCY", "0102000ACAAAPAP", "0102000ACAAATAT", "0102000ACAAAVAV", "0102000ACAAAZAZ", "0102000ACAABABA", "0102000L0AAADAD", "0102000L0AAAFAF", "0102000L0AAAHAH", "0102000L0AAAIAI", "0102000L0AAALAL", "0102000L0AAAMAM", "0102000L0AAANAN", "0102000L0AAAVAV", "0102000L0AABBBB", "0102000L0AABCBC", "0102000L0AABDBD", "0102000L0AABEBE", "0102000L0AABFBF", "0102000L0AABGBG", "0102000L0AABHBH", "0102000L0AABIBI", "0102000L0AABKBK", "0102000L0AABLBL", "0102000L0AABMBM", "0102000L0AABPBP", "0102000N0AAAFAF", "0102000N0AAAIAI", "0102000N0AAAPAP", "0102000N0AAAQAQ", "0102000P0AAAEAE", "0102000P0AAAFAF", "0102000Y0AAAIAI", "0102000Y0AAAUAU", "0102000Y0AAAZAZ", "0103010D0AAAGAG", "0103010N0AAADAD", "0103010T0AAARAR", "0103010T0AAASAS", "0103010T0AAATAT", "0103010T0AAAYAY", "0103010T0AABABA", "0103010T0AABBBB", "0103010T0AABCBC", "0103010T0AABQBQ", "0103010T0AABRBR", "0103020P0AAAAAA", "0103020P0AAABAB", "0103020P0AAACAC", "0103030S0AAAAAA", "0103030S0AAACAC", "0103030S0AAAEAE", "0103030S0BCAAAA", "0103030S0BDAAAA", "0103050E0AAADAD", "0103050L0AAAIAI", "0103050L0AAAJAJ", "0103050L0AAAKAK", "0103050L0AAALAL", "0103050L0AAAMAM", "0103050L0AAAQAQ", "0103050L0AAARAR", "0103050L0AAASAS", "0103050L0AAAUAU", "0103050L0AAAWAW", "0103050L0AAAXAX", "0103050L0AAAYAY", "0103050L0AAAZAZ", "0103050L0AABBBB", "0103050L0AABCBC", "0103050P0AAAJAJ", "0103050P0AAAKAK", "0103050P0AAALAL", "0103050P0AAAQAQ", "0103050P0AAARAR", "0103050P0AAASAS", "0103050P0AAAWAW", "0103050P0AAAYAY", "0103050P0AAAZAZ", "0103050P0AABABA", "0103050P0AABBBB", "0103050P0AABFBF", "0103050P0AABHBH", "0103050P0AABLBL", "0103050P0AABMBM", "0103050P0AABNBN", "0103050P0AABPBP", "0103050P0AABQBQ", "0103050P0AABRBR", "0103050P0AABSBS", "0103050P0AABTBT", "0104020H0AAAAAA", "0104020H0BBAEAA", "0104020H0BGAAAA", "0104020L0AAAFAF", "0104020L0AAAPAP", "0104020L0AAAQAQ", "0104020L0AAASAS", "0105010B0AAAVAV", "0105010E0AAAEAE", "0105010E0AAAJAJ", "0105010E0AAALAL", "0105010E0AAANAN", "0105020C0AAABAB", "0105020C0AAACAC", "0105020C0AAAGAG", "0105020E0AAACAC", "0105040A0AAABAB", "0106010H0AAATAT", "0106020C0AAAFAF", "0106020C0AAALAL", "0106020C0AAAUAU", "0106020C0AAAVAV", "0106020C0AAAWAW", "0106020C0AAAXAX", "0106020C0BEAAAX", "0106040L0AAAEAE", "0107010AAAAABAB", "0107010AAAAADAD", "0107010AAAAAFAF", "0107010AAAAAIAI", "0107010AAAAAJAJ", "0107010AAAAAKAK", "0107010AAAAANAN", "0107010AAAAAPAP", "0107010AAAAAQAQ", "0107010S0AAAIAI", "0107010S0AAAJAJ", "0107010S0AAAKAK", "0107010S0AAALAL", "0107040A0AAAEAE", "0107040A0AAAJAJ", "0107040A0AAAKAK", "0107040A0AAAWAW", "0109010U0AAAJAJ", "0109010U0AAANAN", "0109010U0AABHBH", "010904000BBABA0", "010904000BBADA0", "0109040N0AABCBC", "0109040N0BDAHAU", "0109040N0BDAIAQ", "0109040N0BGAABA", "0109040N0BHAABB", "0109040N0BHABBC", "0201010F0AAAPAP", "0202010B0AAAQAQ", "0202010B0AAAUAU", "0202010B0AAAXAX", "0202010D0AAAFAF", "0202010D0AAAUAU", "0202010D0AABCBC", "0202010D0AABVBV", "0202010D0AACGCG", "0202010D0AACUCU", "0202010D0AACYCY", "0202010D0AADDDD", "0202010D0AADEDE", "0202010D0AADGDG", "0202010L0AAABAB", "0202010L0AAACAC", "0202010L0AAAMAM", "0202010L0AAAPAP", "0202010L0AAASAS", "0202010L0AAATAT", "0202010L0AAAYAY", "0202010P0AAABAB", "0202010V0AAAHAH", "0202010V0AAAJAJ", "0202010V0AAAKAK", "0202010V0AAAMAM", "0202010V0AAANAN", "0202010V0BEAAAN", "0202010V0BEABAA", "0202020D0AAAGAG", "0202020L0AABXBX", "0202020L0AABYBY", "0202020L0AABZBZ", "0202020L0AACACA", "0202020L0AADKDK", "0202030C0AAAXAX", "0202030C0AAAZAZ", "0202030S0AACMCM", "0202030S0AACPCP", "0202030S0AACQCQ", "0202030S0AACRCR", "0202030S0AACXCX", "0202030S0AACZCZ", "0202030S0AADCDC", "0202030S0AADPDP", "0202030S0AADUDU", "0202030S0AAEAEA", "0202030S0AAEBEB", "0202030S0AAECEC", "0202030S0AAEDED", "0202030S0AAEEEE", "0202030S0AAEFEF", "0202040B0AAAHAH", "0203020D0AAAUAU", "0203020D0AAAVAV", "0203020D0AAAWAW", "0203020D0AAAYAY", "0203020D0AABFBF", "0203020D0AABHBH", "0203020D0AACHCH", "0203020D0AACICI", "0203020F0AAAPAP", "0203020F0AAARAR", "0203020I0AAAZAZ", "0203020I0AABIBI", "0203020I0AABLBL", "0203020I0AABRBR", "0203020I0AABSBS", "0203020I0AABTBT", "0203020P0AAAJAJ", "0203020P0AAAKAK", "0203020P0AAAMAM", "0203020R0AAAEAE", "0203020U0AAAGAG", "020400080AAAPAP", "0204000E0AAANAN", "0204000H0AAARAR", "0204000H0AABBBB", "0204000H0AABDBD", "0204000H0AABEBE", "0204000H0AABFBF", "0204000H0AABGBG", "0204000H0AABHBH", "0204000H0AABIBI", "0204000H0AABJBJ", "0204000I0AAAIAI", "0204000K0AAAFAF", "0204000K0AAASAS", "0204000K0AAATAT", "0204000K0AABKBK", "0204000K0AABLBL", "0204000K0AABMBM", "0204000M0AAAAAA", "0204000M0AAACAC", "0204000M0AAADAD", "0204000M0AAAFAF", "0204000M0AAAGAG", "0204000M0AAAHAH", "0204000M0AAAIAI", "0204000M0AAAJAJ", "0204000M0AAAKAK", "0204000R0AACHCH", "0204000R0AACICI", "0204000R0AACJCJ", "0204000R0AACLCL", "0204000R0AACNCN", "0204000R0AACPCP", "0204000R0AADHDH", "0204000T0AAAMAM", "0204000T0AAANAN", "0204000T0AAATAT", "0204000T0AABCBC", "0205010J0AAA3A3", "0205010J0AAA4A4", "0205010J0AAA5A5", "0205010J0AAA8A8", "0205010J0AABKBK", "0205010J0AABTBT", "0205010J0BCAABK", "0205020E0AAAFAF", "0205020E0AAAGAG", "0205020E0AAAHAH", "0205020E0BBAEAF", "0205020E0BBAFAG", "0205020E0BBAGAH", "0205020G0AAACAC", "0205020G0AAADAD", "0205020H0AAAIAI", "0205040D0AAAHAH", "0205040D0AAAXAX", "0205040D0AAAYAY", "0205040D0AAAZAZ", "0205040D0AABABA", "0205040S0AAADAD", "0205040S0AAAEAE", "0205040S0AAAIAI", "0205040S0BCABAD", "0205040S0BCACAE", "0205051F0AABNBN", "0205051F0AABPBP", "0205051F0AABRBR", "0205051F0AABTBT", "0205051F0AABWBW", "0205051F0AABXBX", "0205051F0AABYBY", "0205051F0AACDCD", "0205051F0AADEDE", "0205051F0AADFDF", "0205051F0AADUDU", "0205051I0AAAUAU", "0205051I0AABFBF", "0205051I0AABTBT", "0205051I0AABYBY", "0205051I0AABZBZ", "0205051I0AACACA", "0205051I0AACBCB", "0205051L0AAAGAG", "0205051L0AAAIAI", "0205051L0AAAKAK", "0205051L0AAANAN", "0205051L0AAARAR", "0205051L0AAAYAY", "0205051L0AAAZAZ", "0205051M0AAAHAH", "0205051M0AAAKAK", "0205051M0AAALAL", "0205051R0AAAEAE", "0205051R0AAAFAF", "0205051R0AAAGAG", "0205051R0AAAHAH", "0205051R0AAAWAW", "0205052B0AAADAD", "0205052C0AAAIAI", "0205052C0AAAJAJ", "0205052I0AAAFAF", "0205052I0AAAGAG", "0205052I0AAAMAM", "0205052N0AAAEAE", "0205052N0AAAFAF", "0205052N0AAAGAG", "0205052N0AAAJAJ", "0205052N0AAALAL", "0205052V0AAAEAE", "0205052W0AAADAD", "0206010I0AAAQAQ", "0206010K0AAALAL", "0206010K0AABBBB", "0206020A0AAACAC", "0206020A0AAADAD", "0206020A0AAAFAF", "0206020A0AAAJAJ", "0206020A0AAAMAM", "0206020B0AAAAAA", "0206020B0AAABAB", "0206020B0BBAAAA", "0206020B0BBABAB", "0206020C0AAARAR", "0206020C0AABIBI", "0206020F0AAAGAG", "0206020F0AAAIAI", "0206020R0AAASAS", "0206020R0AAAUAU", "0206020R0AABCBC", "0206020R0AABKBK", "0206020R0AABQBQ", "0206020R0AABRBR", "0206020R0BTAAAS", "0206020T0AAAZAZ", "0206030N0AAAEAE", "0206040AGAAAFAF", "0206040AGAAAGAG", "0206040ALAAABAB", "0206040ATBBAAAA", "0207010G0AAAAAA", "0207010G0BBAAAA", "0208010K0AABJBJ", "0208020I0AAABAB", "0208020I0BBAAAB", "0208020S0AAAAAA", "0208020S0BBAAAA", "0208020V0AAAIAI", "0208020V0AAAMAM", "0208020V0AAANAN", "0208020V0AAARAR", "0208020V0AAAVAV", "0209000A0AABFBF", "0209000A0AABGBG", "0209000A0AABIBI", "0209000C0AAADAD", "0209000C0AAAJAJ", "0209000C0AAAKAK", "0209000C0AAALAL", "0209000C0AAASAS", "0209000L0AAAHAH", "0209000U0AAABAB", "0211000D0AAAFAF", "0211000P0AAAIAI", "0211000P0AAAKAK", "0211000P0AABBBB", "0211000P0AABCBC", "0211000P0AABDBD", "0211000P0AABEBE", "0212000AAAAAEAE", "0212000B0AAAFAF", "0212000B0AAAGAG", "0212000B0AAAHAH", "0212000B0AAAIAI", "0212000B0AAAQAQ", "0212000B0AAARAR", "0212000D0AAACAC", "0212000K0AAACAC", "0212000K0BBACAC", "0212000U0AAABAB", "0212000U0AAAVAV", "0212000X0AAAHAH", "0212000X0AAAKAK", "0212000Y0AAAFAF", "0301030S0AAAGAG", "0301030S0AABEBE", "0301030S0AABJBJ", "0301030S0AABKBK", "0301030S0AABLBL", "0303020Z0AAABAB", "0304010AGAAADAD", "0304010AGAAAEAE", "0304010E0AAADAD", "0304010E0AAAEAE", "0304010E0AAAGAG", "0304010E0AAAHAH", "0304010F0AAADAD", "0304010F0BCAAAD", "0304010J0AAAEAE", "0304010J0AAAFAF", "0304010J0AAAGAG", "0304010J0AAAHAH", "0304010J0AAAIAI", "0304010J0AAAJAJ", "0304010J0AAALAL", "0304010W0AAAQAQ", "0304010Y0AAAVAV", "0304010Y0AAAYAY", "0307000C0AAAJAJ", "0307000C0AAAPAP", "0307000C0BDAAAA", "0309010L0AAAHAH", "0309010L0AAAXAX", "0309010L0BGAAAH", "0309010N0AAAHAH", "0309010N0AAAKAK", "0401010ADAAACAC", "0401010ADAAAHAH", "0401010ADAAAJAJ", "0401010ADAAAKAK", "0401010ADAAAQAQ", "0401010ADAAAUAU", "0401010ADAABGBG", "0401010ADAABJBJ", "0401010ADAABMBM", "0401010ADAABQBQ", "0401010ADAABTBT", "0401010ADAABVBV", "0401010ADAABWBW", "0401010ADAABYBY", "0401010ADAABZBZ", "0401010ADAACACA", "0401010ADAACBCB", "0401010ADAACCCC", "0401010ADAACDCD", "0401010ADAACECE", "0401010ADAACFCF", "0401010ADAACGCG", "0401010ADAACHCH", "0401010ADAACICI", "0401010ADAACNCN", "0401010ADAACQCQ", "0401010ADAACRCR", "0401010ADAACSCS", "0401010ADAACTCT", "0401010ADAACWCW", "0401010ADAACXCX", "0401010ADAADADA", "0401010ADAADCDC", "0401010ADAADEDE", "0401010ADBCCBBR", "0401010ADBCCCBL", "0401010ADBCCDAE", "0401010ADBCCEBS", "0401010B0AAAJAJ", "0401010B0AAAQAQ", "0401010B0AAASAS", "0401010B0AAAVAV", "0401010B0AAAXAX", "0401010B0AABABA", "0401010B0AABDBD", "0401010B0AABEBE", "0401010B0AABFBF", "0401010B0AABGBG", "0401010B0AABJBJ", "0401010B0AABQBQ", "0401010B0AABWBW", "0401010B0AABXBX", "0401010P0AAAGAG", "0401010R0AAAQAQ", "0401010R0AAAXAX", "0401010Z0AAAJAJ", "0401010Z0AAAKAK", "0401010Z0AAALAL", "0401010Z0AAAMAM", "0401020B0AAACAC", "0401020E0AAAUAU", "0401020G0AAAAAA", "0401020K0AABBBB", "0401020K0AABKBK", "0401020K0AABMBM", "0401020K0AACBCB", "0401020K0AACKCK", "0401020K0AACLCL", "0401020P0AABHBH", "0401020P0AABJBJ", "0401020P0AACDCD", "0401020P0AACECE", "0401020P0AACFCF", "0401020P0AACGCG", "0401020P0AACHCH", "0401020P0AACJCJ", "0401020T0AAAJAJ", "040201030AAARAR", "040201030AAASAS", "040201060AAAIAI", "040201060AAAJAJ", "040201060AABABA", "040201060AABBBB", "0402010A0AAACAC", "0402010A0AAADAD", "0402010ABAAAEAE", "0402010ABAAAHAH", "0402010ABAAAIAI", "0402010ABAAAJAJ", "0402010ABAAALAL", "0402010ABAAAMAM", "0402010ABAAARAR", "0402010ABAAATAT", "0402010ABAAAUAU", "0402010ABAABBBB", "0402010ABAABDBD", "0402010ABAABEBE", "0402010ADAAAJAJ", "0402010AFAAAAAA", "0402010AGAAAAAA", "0402010AGBBAAAA", "0402010B0AAACAC", "0402010C0AAAFAF", "0402010D0AAA2A2", "0402010D0AAA3A3", "0402010D0AAARAR", "0402010D0AABDBD", "0402010F0AAABAB", "0402010I0AAABAB", "0402010J0AAA4A4", "0402010J0AAA5A5", "0402010J0AAA7A7", "0402010J0AAA8A8", "0402010J0AABBBB", "0402010J0AABDBD", "0402010J0AABGBG", "0402010J0AABKBK", "0402010K0AAADAD", "0402010K0AAAEAE", "0402010K0AAAFAF", "0402010K0AAAGAG", "0402010K0AAAHAH", "0402010K0AAALAL", "0402010K0AAAPAP", "0402010K0AAAQAQ", "0402010K0AAARAR", "0402010K0AAASAS", "0402010K0AAAUAU", "0402010Q0AAACAC", "0402010Q0AAADAD", "0402010R0AAAHAH", "0402010S0AAALAL", "0402010S0AAANAN", "0402010U0AAANAN", "0402010W0AAACAC", "0402010W0AAAEAE", "0402010W0AAAFAF", "0402010W0AAAGAG", "0402010W0AAAHAH", "0402020L0AAACAC", "0402020L0AAAFAF", "0402030K0AAAPAP", "0403010B0AAA2A2", "0403010B0AAA5A5", "0403010B0AAA6A6", "0403010B0AABFBF", "0403010C0AAACAC", "0403010F0AAALAL", "0403010F0AAAQAQ", "0403010F0AAARAR", "0403010J0AAA5A5", "0403010J0AAA6A6", "0403010J0AAA7A7", "0403010J0AAA8A8", "0403010J0AABJBJ", "0403010J0AABKBK", "0403010L0AAAEAE", "0403010N0AAAPAP", "0403010R0AAAGAG", "0403010V0AAAGAG", "0403010V0AAANAN", "0403010V0AAAQAQ", "0403010X0AAAGAG", "0403010X0AAAIAI", "0403010X0AAAJAJ", "0403010Y0AAAGAG", "0403010Y0AAAHAH", "0403010Y0AAAKAK", "0403020M0AAABAB", "0403030D0AAADAD", "0403030D0AAAGAG", "0403030E0AAAGAG", "0403030E0AAAQAQ", "0403030P0AAADAD", "0403030P0AAAFAF", "0403030Q0AAAIAI", "0403030Q0AAAKAK", "0403030Q0AAANAN", "0403030Q0AAAPAP", "0403030Q0AAAQAQ", "0403030Q0AAARAR", "0403030Q0AAATAT", "0403030Q0AAAUAU", "0403030Q0AAAVAV", "0403030Q0AAAWAW", "0403030Q0AAAXAX", "0403030Q0AAAYAY", "0403040R0AAAFAF", "0403040S0AAAGAG", "0403040T0AAAAAA", "0403040T0AAABAB", "0403040W0AAAIAI", "0403040W0AAANAN", "0403040W0AAAPAP", "0403040W0AAAQAQ", "0403040W0AAARAR", "0403040X0AAABAB", "0403040X0AAAFAF", "0403040X0AAAKAK", "0403040X0AAASAS", "0404000L0AAAFAF", "0404000L0AAAMAM", "0404000L0AAANAN", "0404000L0AAATAT", "0404000L0AAAYAY", "0404000L0AABABA", "0404000L0BFAAAV", "0404000L0BFADAY", "0404000L0BFAEAF", "0404000L0BFAFBH", "0404000L0BFAHBE", "0404000M0AAACAC", "0404000M0AAAFAF", "0404000M0AAAHAH", "0404000M0AAAXAX", "0404000M0AABBBB", "0404000M0BBABAH", "0404000R0AAADAD", "0404000R0AAAGAG", "0404000S0AAAGAG", "0404000S0AAAIAI", "0404000S0AAALAL", "0404000S0AAANAN", "0404000S0AAAPAP", "0404000S0AAARAR", "0406000ADAAAEAE", "0406000B0AAACAC", "0406000B0AAADAD", "0406000B0AAAGAG", "0406000E0AAAAAA", "0406000E0AAABAB", "0406000E0AAADAD", "0406000E0BBACAD", "0406000E0BCAAAB", "0406000F0AAABAB", "0406000F0AAAEAE", "0406000F0AAAQAQ", "0406000F0AAATAT", "0406000F0AAAVAV", "0406000F0AABABA", "0406000F0AABBBB", "0406000F0AABCBC", "0406000F0AABEBE", "0406000J0AAABAB", "0406000J0AAAFAF", "0406000J0AAAKAK", "0406000L0AAAKAK", "0406000L0AABABA", "0406000L0AABEBE", "0406000L0AABIBI", "0406000L0AABMBM", "0406000L0AABNBN", "0406000L0AABPBP", "0406000L0AABQBQ", "0406000P0AAASAS", "0406000S0AAAFAF", "0406000T0AAAEAE", "0406000T0AAAFAF", "0406000W0AAABAB", "0406000W0AAACAC", "0406000W0AAADAD", "0406000W0AAAFAF", "0406000W0AAAHAH", "0406000W0AAAIAI", "0406000W0AAAKAK", "0406000W0AAALAL", "0406000W0AAANAN", "0406000W0AAAPAP", "0407010F0AAASAS", "0407010H0AACPCP", "0407010H0AADBDB", "0407010H0AADRDR", "0407010N0AAACAC", "0407010N0AAAGAG", "0407010Q0AAAAAA", "0407010Q0AAADAD", "040702040AAAZAZ", "040702050AAAKAK", "0407020ABAAAPAP", "0407020ADAAAJAJ", "0407020C0AAAPAP", "0407020C0AAAQAQ", "0407020C0AAASAS", "0407020C0AAAXAX", "0407020G0AAAMAM", "0407020G0AAANAN", "0407020G0AAAPAP", "0407020K0AACZCZ", "0407020K0AADIDI", "0407020K0AADKDK", "0407020K0AADXDX", "0407020K0AAFPFP", "0407020K0AAFQFQ", "0407020M0AABIBI", "0407020M0AABLBL", "0407020M0AABMBM", "0407020M0AABUBU", "0407020M0AABVBV", "0407020P0AAANAN", "0407020P0AAAPAP", "0407020P0AAAQAQ", "0407020P0AAARAR", "0407020P0AAASAS", "0407020P0AABBBB", "0407020Q0AAAAAA", "0407020Q0AAAEAE", "0407020Q0AABCBC", "0407020Q0AABPBP", "0407020Q0AACRCR", "0407020Q0AADKDK", "0407020Q0AADNDN", "0407020Q0AADSDS", "0407020Q0AADYDY", "0407020Q0AAFDFD", "0407020Q0AAFHFH", "0407020Q0AAFJFJ", "0407020Q0AAFWFW", "0407020Q0AAFXFX", "0407020Q0AAFYFY", "0407020Q0AAGBGB", "0407020Q0AAGDGD", "0407020V0AAATAT", "0407020V0AABFBF", "0407030ADAAAAAA", "0407030ADAAABAB", "0407041F0AAAMAM", "0407042F0AAAFAF", "0407042F0AAAGAG", "0407042F0AAAHAH", "0407042F0AAAIAI", "0407042F0AAAJAJ", "0407042F0AAALAL", "0407042F0AAAMAM", "0407042F0AAARAR", "0407042F0AAAVAV", "0407042F0AAAWAW", "0407042F0AAAYAY", "0407042F0AABABA", "0407042Q0AAADAD", "0407042Q0AAAEAE", "0407042Q0AAAFAF", "0407042Q0AAAHAH", "040801020AAAFAF", "040801020AAAGAG", "040801050AAAQAQ", "040801050AAARAR", "040801050AAAXAX", "040801050AAAZAZ", "040801050AABDBD", "040801050AABSBS", "040801050AABXBX", "040801050AABZBZ", "040801050AACCCC", "040801050AACECE", "040801060AAA1A1", "040801060AAA2A2", "040801060AAA3A3", "040801060AAA4A4", "040801060AAA8A8", "040801060AAAGAG", "040801060AABABA", "040801060AABNBN", "040801060AACCCC", "040801060AACDCD", "040801060AACFCF", "0408010A0AAAFAF", "0408010AAAAABAB", "0408010AAAAACAC", "0408010AABBABAB", "0408010AABCAAAB", "0408010AABCABAC", "0408010ABAAAEAE", "0408010ADAAADAD", "0408010ADAAAEAE", "0408010ADAAAFAF", "0408010AEAAAHAH", "0408010AEAAAJAJ", "0408010AEAAAKAK", "0408010AEAAALAL", "0408010AEAAAMAM", "0408010AEAAAQAQ", "0408010AEAAARAR", "0408010AEAABABA", "0408010AKAAAGAG", "0408010AKAAAKAK", "0408010C0AAAXAX", "0408010C0AAAYAY", "0408010C0AABDBD", "0408010C0AABFBF", "0408010C0AABGBG", "0408010D0AAAFAF", "0408010F0AAAAAA", "0408010F0AABCBC", "0408010F0AABEBE", "0408010F0AABGBG", "0408010F0AABMBM", "0408010F0AABPBP", "0408010F0AABRBR", "0408010F0AABSBS", "0408010F0AABZBZ", "0408010F0AACACA", "0408010F0AACECE", "0408010F0AACFCF", "0408010F0AACSCS", "0408010F0AADCDC", "0408010F0AADDDD", "0408010F0BBAEAA", "0408010G0AAAGAG", "0408010G0AAAPAP", "0408010G0AAAQAQ", "0408010G0AAASAS", "0408010G0AAAVAV", "0408010G0AAAWAW", "0408010G0AAAYAY", "0408010G0AABHBH", "0408010G0AABIBI", "0408010G0BBAFAQ", "0408010H0AAA3A3", "0408010H0AAAZAZ", "0408010H0AABEBE", "0408010H0AABRBR", "0408010H0AABUBU", "0408010K0AAAAAA", "0408010N0AAAMAM", "0408010N0AAASAS", "0408010N0AACLCL", "0408010N0AACMCM", "0408010N0AACNCN", "0408010N0AACPCP", "0408010N0AACQCQ", "0408010N0AACRCR", "0408010N0AACTCT", "0408010N0AACUCU", "0408010N0AACWCW", "0408010N0AACXCX", "0408010N0AACYCY", "0408010N0AADADA", "0408010N0AADIDI", "0408010N0AADJDJ", "0408010N0AADMDM", "0408010N0AADQDQ", "0408010N0AADWDW", "0408010N0AAEAEA", "0408010N0AAEHEH", "0408010N0AAEUEU", "0408010N0AAEVEV", "0408010P0AAAVAV", "0408010P0AAAWAW", "0408010P0AAAYAY", "0408010P0AABABA", "0408010P0AABBBB", "0408010P0AABCBC", "0408010P0AABHBH", "0408010P0AABIBI", "0408010P0AABKBK", "0408010Q0AAAXAX", "0408010U0AAACAC", "0408010U0AAAFAF", "0408010U0AABABA", "0408010U0AABBBB", "0408010U0AABCBC", "0408010W0AAA7A7", "0408010W0AABCBC", "0408010W0BJAACA", "0408010X0AAATAT", "0408010X0AAAUAU", "0408010Y0AAAAAA", "0408010Y0AAABAB", "0408010Y0BBAAAA", "0408010Y0BBABAB", "0408010Z0AAALAL", "0408010Z0AABHBH", "0408010Z0AABIBI", "0408010Z0BCAAAC", "0408010Z0BCABAA", "0408020D0AAAAAA", "0408020D0BBABAA", "0408020Q0AAAJAJ", "0408020V0AAADAD", "0408020V0AAAEAE", "0408020V0AAAFAF", "0408020V0AAAGAG", "0408020V0AAAHAH", "0408020V0AAALAL", "0408020V0AAATAT", "0408020V0AAAUAU", "0408020W0AAAGAG", "0408020W0AAAHAH", "0409010D0AAAAAA", "0409010H0AAATAT", "0409010I0AAAJAJ", "0409010I0AAAKAK", "0409010I0AAAMAM", "0409010K0AAAHAH", "0409010K0AAANAN", "0409010N0AAAIAI", "0409010N0AAAKAK", "0409010N0AAANAN", "0409010N0AAAPAP", "0409010N0AAAQAQ", "0409010N0AAAUAU", "0409010N0AAAVAV", "0409010N0AAAWAW", "0409010N0AAAXAX", "0409010N0AAAYAY", "0409010T0AAALAL", "0409010V0AAACAC", "0409020C0AAAIAI", "0409020C0AAAJAJ", "0409020C0AAAKAK", "0409020C0AAALAL", "0409020C0AAASAS", "0409020E0AAABAB", "0409020G0AAACAC", "0409020N0AAAMAM", "0409020N0BDAAAM", "0409020S0AAAJAJ", "0409020S0AAAKAK", "0409030C0AAARAR", "0409030C0AAASAS", "0410010B0AAAEAE", "0410030C0AAAJAJ", "0410030C0AAAMAM", "0410030C0AAAQAQ", "0410030C0AAARAR", "0410030C0AABEBE", "0410030C0AABFBF", "0410030E0AAAEAE", "0410030E0AAAIAI", "0410030E0AAAKAK", "0410030E0AAAMAM", "0410030E0AAANAN", "0410030E0AAAPAP", "0410030E0AAATAT", "0410030E0AAAUAU", "0410030E0AAAVAV", "0410030E0AAAWAW", "0411000D0AAAFAF", "0501015P0AAACAC", "0501030F0AAAFAF", "0501030F0AAAGAG", "0501030F0AAAIAI", "0501030I0AAAHAH", "0501030I0AAAKAK", "0501030I0AAAMAM", "0501030T0AAAPAP", "0501030V0AAAAAA", "0501030V0AAARAR", "0501040H0AAAWAW", "0501040H0AAAYAY", "0501040U0AAAHAH", "0501050A0AAAHAH", "0501060D0AAAEAE", "0501060D0AAAGAG", "0501060D0AAAHAH", "0501060D0AAAIAI", "0501060D0AAAJAJ", "0501060D0AAANAN", "0501060D0AAAPAP", "0501060D0AAAQAQ", "0501060D0AAASAS", "0501060D0AAATAT", "0501070ABAAAAAA", "0501070ABAAABAB", "0501070U0AAAHAH", "0501070U0AAAKAK", "0501070U0AAALAL", "0501070X0AAACAC", "0501070Z0AAAAAA", "0501080J0AAAHAH", "0501080W0AAAMAM", "0501080W0AAAQAQ", "0501090H0AAARAR", "0501090H0AAASAS", "0501090H0AAAZAZ", "0501090H0AABDBD", "0501090H0AABHBH", "0501090H0AABIBI", "0501090K0AABIBI", "0501090K0AABJBJ", "0501090K0AACUCU", "0501090N0AAA9A9", "0501090N0AABBBB", "0501090N0AABIBI", "0501090N0AABJBJ", "0501090N0AABKBK", "0501090N0AABPBP", "0501100C0AAAAAA", "0501100H0AAALAL", "0501110C0AABLBL", "0501110C0AABQBQ", "0501110C0AABTBT", "0501120L0AAAUAU", "0501120Q0AAAAAA", "0501130R0AAAJAJ", "0501130R0AAAMAM", "0501130R0AAANAN", "0501130R0AAARAR", "0501130R0AAATAT", "0501130R0AAAUAU", "0501130R0AAAVAV", "0501130R0AABEBE", "0501130R0AABSBS", "0501130S0AAAAAA", "0501130S0BBAAAA", "0502010C0AAACAC", "0502010D0AAAEAE", "0502030B0AAAIAI", "0502030B0AAAKAK", "0502030B0AAAXAX", "0502050B0AAAEAE", "0502050B0AAAJAJ", "0502050B0AAAKAK", "0502050B0AAALAL", "0502050B0AAAPAP", "0502050B0AAARAR", "0502050B0AAASAS", "0502050B0AAAZAZ", "0502050B0AABJBJ", "0502050B0AABZBZ", "0502050B0AACBCB", "0502050B0AACDCD", "0502050B0AACKCK", "0502050B0AACLCL", "0502050B0AACSCS", "0502050B0AACUCU", "0502050B0AACVCV", "0502050B0AACXCX", "0502050C0AAABAB", "0502050C0AAADAD", "0502050C0AAAEAE", "0502050C0AAAFAF", "0503021A0AAAFAF", "0503021A0AAAGAG", "0503040B0AAAEAE", "0503040C0AAABAB", "0504010N0AAAIAI", "0504010T0AAAFAF", "0504010Y0AAA2A2", "0504010Y0AAA7A7", "0504010Y0AABCBC", "0504010Y0AABDBD", "0504040M0AAAAAA", "0504040M0AAAGAG", "0504050T0AAAEAE", "0504050T0BCAAAE", "0504060B0AAAAAA", "0505020L0AAABAB", "0505020L0AAAFAF", "0505020L0AAAGAG", "0505020L0BCAAAB", "0505030A0AAABAB", "0505030A0AAACAC", "0505030A0AAADAD", "0505030A0BBABAD", "0505030A0BCAAAB", "0505050P0AAAAAA", "0505050P0AAABAB", "0505050P0AAADAD", "0505050P0BBAAAA", "0505060I0AAADAD", "0505060I0AAAEAE", "0505060I0BBAAAC", "0601011R0AAAEAE", "0601011R0BBABAB", "0601011R0BEAAAE", "0601021A0AAAHAH", "0601021H0AAAAAA", "0601021H0AAABAB", "0601021H0AAAJAJ", "0601021H0AAAKAK", "0601021M0AAAHAH", "0601021M0AAASAS", "0601021M0AAAUAU", "0601022B0AAAIAI", "0601022B0AAAJAJ", "0601022B0AAAMAM", "0601022B0AAANAN", "0601022B0AAAQAQ", "0601023B0AAAEAE", "0601023X0AAAEAE", "0601040E0AAAGAG", "0601040E0AAAPAP", "0601040E0AAAQAQ", "0601040E0AAAXAX", "0601040E0AAAYAY", "0601040E0AABHBH", "0601040E0AABIBI", "0601040E0AABJBJ", "0602010M0AAAIAI", "0602010M0AAASAS", "0602010M0AAAWAW", "0602010M0BFACAW", "0602010V0AAAEAE", "0602010V0AAAFAF", "0602010V0AAAGAG", "0602010V0AAAIAI", "0602010V0AABHBH", "0602010V0AABMBM", "0602010V0AACCCC", "0602010V0AACICI", "0602010V0AACJCJ", "0602010V0AACMCM", "0602010V0AACQCQ", "0602010V0AACVCV", "0602010V0AACWCW", "0602010V0AACXCX", "0602010V0AACYCY", "0602010V0AACZCZ", "0602010V0AADADA", "0602010V0AADBDB", "0602010V0AADCDC", "0602010V0AADMDM", "0602010V0AADNDN", "0602010V0AAEAEA", "0602010V0AAENEN", "0602010V0AAFBFB", "0602010V0AAFQFQ", "0602010V0AAFRFR", "0602010V0AAFUFU", "0602010V0AAFWFW", "0602010V0BJAAAG", "0602010V0BJABAF", "0602010V0BJACCM", "0602010Z0AAAAAA", "0602010Z0AAABAB", "0602010Z0AAACAC", "0602010Z0AAADAD", "0602010Z0AAAJAJ", "0602010Z0AAAKAK", "0602010Z0BBAAAE", "0602010Z0BBABAA", "0602010Z0BBACAB", "0602010Z0BBADAD", "0602010Z0BBAGAC", "0602010Z0BBAHAH", "0602010Z0BDAAAB", "0602010Z0BDABAA", "0602010Z0BDACAD", "0602010Z0BEAAAI", "0602010Z0BEABAJ", "0602010Z0BEACAK", "0602010Z0BFAAAA", "0602010Z0BFABAB", "0602020D0AAAKAK", "0602020D0AAARAR", "0602020D0AAAUAU", "0602020D0AAAWAW", "0602020G0AAABAB", "0602020N0AAAGAG", "0603010I0AAA3A3", "0603010I0AAA4A4", "0603010I0AAA8A8", "0603010I0AAAJAJ", "0603010I0AABHBH", "0603010I0AABSBS", "0603010I0AABYBY", "0603010I0AABZBZ", "0603020ACAAAAAA", "0603020F0AAAHAH", "0603020G0AAA5A5", "0603020G0AAA6A6", "0603020G0AAA7A7", "0603020G0AAA8A8", "0603020G0AABHBH", "0603020G0AABJBJ", "0603020G0AABNBN", "0603020G0AABQBQ", "0603020G0AABUBU", "0603020G0AABVBV", "0603020G0AABYBY", "0603020G0AACCCC", "0603020G0AACECE", "0603020J0AAAJAJ", "0603020J0AAAKAK", "0603020J0AAAXAX", "0603020J0AABCBC", "0603020J0AABDBD", "0603020J0AABJBJ", "0603020J0AABLBL", "0603020J0AACACA", "0603020T0AAAYAY", "0603020T0AAAZAZ", "0603020T0AABCBC", "0603020T0AABGBG", "0604011D0AAALAL", "0604011D0AABFBF", "0604011G0AAABAB", "0604012F0AAAAAA", "0604012P0AAAEAE", "0604012S0AACACA", "0604012S0BMAABY", "0604020B0AAABAB", "0604020C0AAACAC", "0604020K0AAABAB", "0604020K0AABCBC", "0604020K0AABTBT", "0604020K0BRAABT", "0604020P0AAADAD", "0604020P0AAAKAK", "0604030P0AAABAB", "0604030Q0AAAAAA", "0604030Q0AAACAC", "0604030Q0AAAIAI", "0604030Q0AAALAL", "0604030Q0BBAAAA", "0604030Q0BBACAC", "0604030Q0BBAFAI", "0604030Q0BBAGAH", "0604030S0AAAAAA", "0604030S0BBAAAA", "0605010D0AAAIAI", "0605010D0BFAAAH", "0605010D0BFABAI", "0605020E0AAABAB", "0605020E0AAALAL", "0605020E0AAAPAP", "0605020E0AAASAS", "0605020E0AABCBC", "0605020E0AABDBD", "0605020E0AABEBE", "0605020E0AABIBI", "0605020E0AABSBS", "0605020E0AABWBW", "0605020E0BDABBP", "0606020A0AAADAD", "0607020C0AAAAAA", "0607020C0AAAEAE", "0607020C0BCAAAE", "0702020Y0AAAAAA", "0704010A0AAAFAF", "0704010A0AAAHAH", "0704010I0AAABAB", "0704010U0AAACAC", "0704010U0AAAFAF", "0704020AAAAAEAE", "0704020AAAAAFAF", "0704020ABAAAEAE", "0704020G0AAADAD", "0704020J0AAAKAK", "0704020J0AAAMAM", "0704020J0AAARAR", "0704020J0AAAZAZ", "0704020N0AAAEAE", "0704020N0AAAJAJ", "070403000AAAGAG", "0704030G0AAAPAP", "0704030G0AAAZAZ", "0704030G0AABABA", "0704030G0BFACBA", "0704030J0AAAUAU", "0704040G0AAABAB", "0704040G0AAADAD", "0704040G0AAAGAG", "0704050J0AAAHAH", "0704050Y0AAAVAV", "0704050Z0AAAEAE", "0704050Z0AAAFAF", "0704050Z0AAAGAG", "0704050Z0AAAIAI", "0704050Z0AAAKAK", "0704050Z0AAALAL", "0801000I0AAAWAW", "0801030L0AAABAB", "0801030L0AAAFAF", "0801030L0AAAGAG", "0801030L0AAAJAJ", "0801030L0AAALAL", "0801030L0AAANAN", "0801030L0AAAPAP", "0801050P0AAABAB", "0801050P0AAADAD", "0802010G0AAAHAH", "0802010G0AAAPAP", "0802010G0AAASAS", "0802010G0AAATAT", "0802010G0AABCBC", "0802010G0AABIBI", "0802010G0AABRBR", "0802010G0AABYBY", "0802010G0AACGCG", "0802010G0AACHCH", "0802010G0AACICI", "0802010G0AACJCJ", "0802010G0AACKCK", "0802010M0AAAEAE", "0802020T0AAAGAG", "0802020T0AAALAL", "0803020H0AAARAR", "0803020L0AAAAAA", "0803020L0AAACAC", "0803020L0AAAGAG", "0803020L0AAAHAH", "0803020L0AAAJAJ", "0803041B0AAABAB", "0803041L0AAABAB", "0803041S0AAAGAG", "0803041S0AAAHAH", "0803042A0AAADAD", "0901011H0AAAHAH", "0901011P0AAABAB", "0901011P0AABCBC", "0901011P0AABDBD", "0901011P0AABGBG", "0901011P0AABPBP", "0901011P0AABQBQ", "0901011P0AABWBW", "0901011P0AACKCK", "0901012I0AAACAC", "0901020D0BDAAAF", "0901020G0AAAAAA", "0901020G0AABYBY", "0901020G0AABZBZ", "0901020G0AACACA", "0901020G0AACCCC", "0901020G0AACDCD", "0901020G0AACMCM", "0901020N0AAADAD", "0901020N0AAAJAJ", "0901020N0AAAMAM", "0901020T0AAADAD", "0902011U0AAARAR", "0902011U0AAASAS", "0902011U0AAAYAY", "0902011U0AABJBJ", "0902011U0BMAAAH", "0902011U0BNAAAH", "0902012H0AAAKAK", "0902012L0AAAAAA", "0902012L0AAARAR", "0902012L0AAAUAU", "0902012L0AABHBH", "0902012L0AABSBS", "0902012L0AABVBV", "0902012L0AABXBX", "0902012L0AABZBZ", "0902012L0AACUCU", "0902012L0AACWCW", "0902012L0AACXCX", "0902012L0AACZCZ", "0902012L0AADBDB", "0902012L0AADFDF", "0902012L0AADGDG", "0902013P0AAABAB", "0902013P0AAAJAJ", "0902013S0AAADAD", "0902013S0AAAFAF", "090401000BBKNA0", "0905011K0AAAGAG", "0905011K0AAATAT", "090501300AABJBJ", "090501300BBFUA0", "090501300BBFVA0", "0905013A0AAAFAF", "0905013A0AAAGAG", "0905013A0BBAAAF", "0905013A0BBACAI", "0905013F0AAAEAE", "0905013F0BCAAAE", "0905013G0AACXCX", "0905013G0AACYCY", "0905013G0AACZCZ", "0905013G0AADADA", "0905013G0AADHDH", "0905013N0AAALAL", "0905013P0BBAAAA", "090502100AAAMAM", "090502100AAAQAQ", "090502100AAARAR", "090502100BPBBA0", "090502100BPBCA0", "0905021F0AAATAT", "0905021I0AAAKAK", "0905021L0AAAGAG", "0905021L0AAAHAH", "0905021L0AAASAS", "0905041Q0AAA9A9", "0905041Q0AAAGAG", "0906011D0AAAWAW", "0906011D0AAAYAY", "0906011D0AAAZAZ", "0906011D0BCADAX", "0906011D0BGAAAY", "0906022K0AAARAR", "0906022K0BCABAB", "0906024N0AABMBM", "0906024N0AABNBN", "0906024N0AABQBQ", "0906024N0AABSBS", "0906024N0AABUBU", "0906024N0AABWBW", "0906024N0AACECE", "0906024N0AACJCJ", "0906024N0AACMCM", "0906024N0AACSCS", "0906024N0AACTCT", "0906024N0AACYCY", "0906025P0AAA3A3", "0906025P0AAA5A5", "0906025P0AAA9A9", "0906025P0AAAAAA", "0906025P0AAAQAQ", "0906025P0AABGBG", "0906025P0AABNBN", "0906025P0AABPBP", "0906025P0BGAABP", "0906026M0AAAXAX", "0906026M0AAAZAZ", "0906026M0AABIBI", "0906026M0AABJBJ", "0906026M0AABKBK", "090602800AACACA", "090602800AACFCF", "090602800AACPCP", "090602800AACUCU", "090602800AACWCW", "090602800AACXCX", "090602800AACYCY", "090602800BBJFAG", "0906031C0AAAPAP", "0906031C0AABGBG", "0906040B0AAAKAK", "0906040B0AAAMAM", "0906040C0AAAIAI", "0906040G0AAAPAP", "0906040G0AAAQAQ", "0906040G0AAARAR", "0906040G0AAATAT", "0906040G0AAAUAU", "0906040G0AAAYAY", "0906040G0AABJBJ", "0906040G0AABLBL", "0906040G0AACHCH", "0906040G0AACJCJ", "0906040G0AACLCL", "0906040G0AADEDE", "0906040G0AADGDG", "0906040G0AADJDJ", "0906040G0AAEFEF", "0906040G0AAFAFA", "0906040G0AAFGFG", "0906040G0BGAABM", "0906040G0BYAACH", "0906040G0CDAACL", "0906040N0AAAPAP", "0906040N0AACPCP", "0906040N0AADADA", "0906040N0AADBDB", "0906040N0AADCDC", "0906040N0AADIDI", "0906040N0AADJDJ", "0906040N0AADLDL", "0906040N0AADSDS", "0906040N0AADTDT", "0906040N0AADZDZ", "0906040N0AAEAEA", "0906040N0AAEIEI", "0906040N0AAFGFG", "0906040N0AAFHFH", "0906040N0AAFIFI", "0906040N0AAFJFJ", "0906040N0AAFKFK", "0906040N0AAFMFM", "0906040N0AAFNFN", "0906040N0CCAAFH", "0906050T0AAAGAG", "0906050T0BCAAAG", "0906060L0AAAGAG", "0906060L0AAAIAI", "0906060L0AAAKAK", "0906060L0AAAPAP", "0906060Q0AAAHAH", "0906060Q0AAAPAP", "0906060Q0AAAXAX", "0906060Q0AAAYAY", "0906060Q0AABBBB", "0906060Q0AABCBC", "0906060Q0AABDBD", "0906060Q0BDABAY", "0907000H0AAABAB", "0908010ALAAAAAA", "0908010D0AAALAL", "0908010D0AAAMAM", "0908010N0AAABAB", "0908010N0AAAIAI", "0908010N0AAAXAX", "0908010N0AABGBG", "0908010N0AABHBH", "0908010N0AABIBI", "0908010P0AAAEAE", "0908010P0AAATAT", "0908010T0AAAAAA", "0908010Y0BBAAAA", "091101000AADADA", "091101000AAEBEB", "091101000AAFBFB", "091101000AAFMFM", "091101000AAFQFQ", "091101000AAFRFR", "091101000AAFSFS", "091102000AABDBD", "091102000AABHBH", "091102000AABKBK", "091102000AABPBP", "091102000AABUBU", "091102000BBHKA0", "091102000BBIGBA", "091200000AAFAFA", "091200000BFWRFT", "0913191A0AAABAB", "0913471A0BBAAAA", "0913471B0BBAAAA", "0913471B0BBABAB", "1001010C0AAAVAV", "1001010C0AABBBB", "1001010C0AABJBJ", "1001010C0AABLBL", "1001010J0AABIBI", "1001010K0AAAQAQ", "1001010K0AAARAR", "1001010K0AAAXAX", "1001010K0AABABA", "1001010K0AABBBB", "1001010L0AAAPAP", "1001010P0AAARAR", "1001010P0AABCBC", "1001030C0AAAFAF", "1001030C0AAAIAI", "1001030C0AAAKAK", "1001030C0AAARAR", "1001030C0AAASAS", "1001030C0AAATAT", "1001030C0AAAWAW", "1001030C0AABKBK", "1001030C0AABLBL", "1001030F0AAAIAI", "1001030F0AAALAL", "1001030Q0AAAAAA", "1001030Q0AAABAB", "1001030U0AAAEAE", "1001030U0AAAFAF", "1001030U0AAAHAH", "1001030U0AAAIAI", "1001030U0AAAKAK", "1001030U0AAARAR", "1001040A0AAAAAA", "1001040A0AAABAB", "1001040A0BBAAAA", "1001040C0AAALAL", "1001040C0AAAPAP", "1001040C0AAAWAW", "1001040C0AAAXAX", "1001040G0AAAHAH", "1001040G0AAAIAI", "1001040K0AAAAAA", "1001040K0AAADAD", "1001040K0BCAAAA", "1001040P0AAACAC", "100201000AAAEAE", "1002010Q0AAAJAJ", "1002010Q0AAAKAK", "1002010Q0AAALAL", "1002010Q0AAANAN", "1002010Q0AAAPAP", "1002010Q0AAASAS", "1002010Q0AAAWAW", "1002010Q0AAAYAY", "1002010Q0AABDBD", "1002010Q0AABGBG", "1002010Q0AABHBH", "1002010Q0AABIBI", "1002010Q0AABJBJ", "1002020C0AAA1A1", "1002020C0AABDBD", "1002020C0AABEBE", "1002020J0AAARAR", "1002020J0AAAUAU", "1002020J0AABHBH", "1002020J0AABKBK", "1002020J0AABQBQ", "1002020J0AABRBR", "1002020L0AAACAC", "1002020T0AAAIAI", "1002020T0AAAJAJ", "100302010AAACAC", "1003020AAAAAAAA", "1003020AAAAABAB", "1003020N0AAABAB", "110301020AAABAB", "110301020AAACAC", "1103010AJAAAAAA", "1103010AJAAACAC", "1103010B0AAAEAE", "1103010B0AAAFAF", "1103010G0AAAHAH", "1103010G0AAAKAK", "1103010I0AAAAAA", "1103010I0BCAAAA", "1103010P0AAAAAA", "1103010P0AAABAB", "1103010T0AAAAAA", "1103010T0AAACAC", "1103010Z0AAAAAA", "1103020A0AAADAD", "1103020A0AAAEAE", "1103020C0AAABAB", "1103020M0AAABAB", "1103030T0AAABAB", "1104010F0AAAAAA", "1104010F0BDAAAA", "1104010I0AAARAR", "1104010M0AAACAC", "1104010M0AAADAD", "1104010S0AAAAAA", "1104010S0AAARAR", "1104010S0AAAZAZ", "1104010S0AABKBK", "1104010S0AABLBL", "1104010S0AABMBM", "1104010S0AABNBN", "1104010S0AABPBP", "1104010S0AABQBQ", "1104010S0AABRBR", "1104010S0AABSBS", "1104010S0AABTBT", "1104020T0BFABAG", "1105000B0AAADAD", "1105000B0AAAHAH", "1105000H0AAADAD", "1106000B0AAA2A2", "1106000B0AAA7A7", "1106000B0AAASAS", "1106000B0AABQBQ", "1106000X0AAA4A4", "1106000X0AAAFAF", "1106000X0AAASAS", "1106000X0AABGBG", "1106000X0AABKBK", "1106000X0AABMBM", "1106000X0AABNBN", "1106000X0AABPBP", "110801000BLAMA0", "1108010A0AAAAAA", "1108010A0AAACAC", "1108010A0AAAEAE", "1108010AAAAACAC", "1108010AAAAAHAH", "1108010AAAAAIAI", "1108010AAAAAJAJ", "1108010AAAAALAL", "1108010AAAAAMAM", "1108010AAAAARAR", "1108010C0AAAEAE", "1108010C0AAAHAH", "1108010C0AAAIAI", "1108010C0AABABA", "1108010F0AAADAD", "1108010F0AAALAL", "1108010F0AAASAS", "1108010F0AAAXAX", "1108010F0AABQBQ", "1108010F0AABZBZ", "1108010F0AACACA", "1108010K0AAA1A1", "1108010K0AAAAAA", "1108010K0AAACAC", "1108010K0AAAIAI", "1108010K0AAAJAJ", "1108010K0AAALAL", "1108010K0AAAWAW", "1108010K0AACCCC", "1108010K0AACDCD", "1108010K0AACFCF", "1108010L0AAACAC", "1108010Q0AAAIAI", "110802050AAABAB", "1108020G0AAAAAA", "1108030ABAAAAAA", "1108030ABAAABAB", "120101000BBABA0", "1201010ABAAAAAA", "1201010ACAAAAAA", "1201010B0AAAGAG", "1201010C0AAAAAA", "1201010S0AAAAAA", "1202010I0AAACAC", "1202010L0AAACAC", "1202020C0AAABAB", "1202020F0AAAEAE", "1202020F0AAAHAH", "1202020L0AABNBN", "1202020L0AABQBQ", "1202020L0AABZBZ", "1202020L0AACACA", "1202020L0AACBCB", "1202020L0AACDCD", "1203010T0AAAGAG", "1203010W0AAAAAA", "1203020C0AAAAAA", "1203040P0AAAAAA", "130101000AAARAR", "130201000AACGCG", "130201000AACMCM", "130201000AACNCN", "130201000AACWCW", "130201000AACZCZ", "130201000AADCDC", "130201000AADFDF", "130201000AADHDH", "130201000AADIDI", "130201000AADJDJ", "130201000AADNDN", "1302010F0AAANAN", "1302010F0AAAPAP", "1302010F0AAAQAQ", "1302010K0AAAFAF", "1302010K0AAAHAH", "1302010U0AAATAT", "1302010U0AAAVAV", "1302010U0AAAZAZ", "1302010U0AABBBB", "1303000A0AAABAB", "1303000AAAAAKAK", "1303000AAAAAPAP", "1303000AAAAAUAU", "1303000AAAAAWAW", "1303000Q0AAAAAA", "130400000AABHBH", "130400000AABJBJ", "130400000AABKBK", "130400000AABLBL", "1304000C0AACDCD", "1304000C0AACGCG", "1304000C0AACHCH", "1304000D0AACCCC", "1304000D0AACDCD", "1304000D0AACECE", "1304000D0AACFCF", "1304000F0AACPCP", "1304000F0AACRCR", "1304000F0AACSCS", "1304000F0AACTCT", "1304000F0AACZCZ", "1304000F0AADADA", "1304000F0AADBDB", "1304000F0AADGDG", "1304000F0AADHDH", "1304000F0AADIDI", "1304000F0AADKDK", "1304000F0AADMDM", "1304000F0AADNDN", "1304000F0AADPDP", "1304000F0AAEAEA", "1304000F0AAEBEB", "1304000F0AAECEC", "1304000F0AAEIEI", "1304000F0AAEJEJ", "1304000F0AAEKEK", "1304000F0AAENEN", "1304000F0AAEPEP", "1304000F0AAEQEQ", "1304000F0AAESES", "1304000F0AAETET", "1304000F0AAEUEU", "1304000F0AAEVEV", "1304000F0AAEWEW", "1304000F0AAEYEY", "1304000F0AAEZEZ", "1304000F0AAFDFD", "1304000F0AAFGFG", "1304000F0AAFKFK", "1304000F0AAFMFM", "1304000F0AAFQFQ", "1304000F0AAFSFS", "1304000G0AACGCG", "1304000G0AACHCH", "1304000G0AACICI", "1304000G0AACJCJ", "1304000G0AACKCK", "1304000G0AACPCP", "1304000G0AACQCQ", "1304000G0AACVCV", "1304000G0AACYCY", "1304000G0AADADA", "1304000G0AADBDB", "1304000G0AADCDC", "1304000G0AADDDD", "1304000G0AADKDK", "1304000G0AADMDM", "1304000G0AADNDN", "1304000G0AADPDP", "1304000H0AACHCH", "1304000H0AACLCL", "1304000H0AACNCN", "1304000H0AACRCR", "1304000H0AACTCT", "1304000H0AACWCW", "1304000L0AAACAC", "1304000P0AABGBG", "1304000P0AABHBH", "1304000V0AAEEEE", "1304000V0AAEPEP", "1304000V0AAESES", "1304000V0AAETET", "1304000V0AAEUEU", "1304000V0AAEVEV", "1304000V0AAEYEY", "1304000V0AAFAFA", "1304000Y0AABEBE", "1305010J0AAAAAA", "1305010J0AAABAB", "1305010J0AAASAS", "1305010J0AAATAT", "1305010J0AAAVAV", "1305010J0AAAYAY", "1305020A0AAAEAE", "1305020C0AAACAC", "1305020C0AAALAL", "1305020C0AAARAR", "1305020C0AAAVAV", "1305020C0AABSBS", "1305020C0AADXDX", "1305020C0AADYDY", "1305020C0AAEBEB", "1305020C0AAEEEE", "1305020C0AAEFEF", "1305020C0AAEGEG", "1305020C0AAEIEI", "1305020C0AAEKEK", "1305020C0AAELEL", "1305020C0AAEMEM", "1305020C0AAEPEP", "1305020C0AAESES", "1305020C0AAETET", "1305020C0AAEUEU", "1305020C0AAEVEV", "1305020C0AAEWEW", "1305020C0AAEXEX", "1305020C0AAEYEY", "1305020C0AAEZEZ", "1305020C0AAFAFA", "1305020C0AAFEFE", "1305020C0AAFGFG", "1305020C0AAFHFH", "1305020C0AAFIFI", "1305020C0AAFJFJ", "1305020C0AAFLFL", "1305020C0AAFPFP", "1305020C0AAFQFQ", "1305020C0AAFUFU", "1305020C0AAFVFV", "1305020C0AAFXFX", "1305020C0AAFYFY", "1305020C0AAGBGB", "1305020C0AAGFGF", "1305020C0AAGGGG", "1305020C0AAGIGI", "1305020C0AAGLGL", "1305020C0AAGTGT", "1305020C0AAGUGU", "1305020C0AAGVGV", "1305020C0AAGWGW", "1305020C0AAGYGY", "1305020C0AAHAHA", "1305020C0AAHBHB", "1305020C0AAHDHD", "1305020C0AAHFHF", "1305020C0AAHGHG", "1305020F0AACVCV", "1305020F0AACWCW", "1305020F0AAEIEI", "1305020F0AAEQEQ", "1305020F0AAETET", "1305020F0AAEWEW", "1305020F0AAFAFA", "1305020I0AAAGAG", "1305020I0AAAJAJ", "1305020L0AAAMAM", "1305020S0AAA4A4", "1305020S0AAAEAE", "1305020S0AAAJAJ", "1305020S0AABNBN", "1305020S0AABPBP", "1305020S0AABTBT", "1305020S0AABUBU", "1305020S0AABVBV", "1305020S0AACCCC", "1305020S0AACGCG", "1305020S0AACHCH", "1305020S0AACICI", "1305020S0AACJCJ", "1305020S0AACRCR", "1305020S0AACSCS", "1305020S0AACTCT", "1305020S0AACUCU", "1305020S0AACVCV", "1305020S0AACWCW", "1305020S0AACYCY", "1305020S0AACZCZ", "1305020S0AADCDC", "1305020S0AADEDE", "1305020S0AADFDF", "1305020S0AADHDH", "1305020S0AADLDL", "1305020S0AADMDM", "1305020S0AADPDP", "1305020S0AADSDS", "1305020S0AADTDT", "1305020X0AAAAAA", "1305020Z0AAAAAA", "1306010I0AAAEAE", "1306010T0AAAAAA", "1306010T0AAABAB", "1306010T0AAAQAQ", "1306010T0AAARAR", "1306010T0AAASAS", "1306010T0AAATAT", "1306010T0AAAUAU", "1306010T0AAAVAV", "1306010T0AABABA", "1306010T0AABBBB", "1306010T0AABDBD", "1306010T0AABHBH", "1306010T0AABIBI", "1306010T0AABKBK", "1306010T0AABLBL", "1306010V0AAAEAE", "1306010V0AAAKAK", "1306010V0AAALAL", "1306010V0AAAMAM", "1306010V0AAANAN", "1306010V0AAAPAP", "1307000C0AAADAD", "1307000C0AAAFAF", "1307000J0AAAAAA", "1307000J0AAABAB", "1307000M0AABTBT", "1307000M0AABVBV", "1307000M0AABXBX", "1307000M0AABZBZ", "1307000T0AAAMAM", "1307000T0AAAPAP", "1308010U0AAAJAJ", "1308010U0AAAKAK", "1308010U0AAALAL", "130900000AABGBG", "130900000AABLBL", "1310011P0AAAAAA", "1310012I0AAAEAE", "1310012K0AAAEAE", "1310012K0AABHBH", "1310012K0AABIBI", "1310012K0AABJBJ", "1310020D0AAAAAA", "1310020H0AAADAD", "1310020U0AAAAAA", "1310040C0AAAAAA", "1311010S0AAADAD", "1311020L0AAAJAJ", "1311020L0AABUBU", "1311060I0AAABAB", "1311060Q0AAABAB", "1312000G0AAADAD", "1312000G0AAAFAF", "1312000G0AAAIAI", "1312000G0AAAMAM", "1312000G0AAANAN", "1312000G0AAATAT", "1312000G0AAAUAU", "1312000G0AAAVAV", "1312000G0AAAXAX", "1312000G0AAAZAZ", "1312000G0AABABA", "1312000G0AABBBB", "1312000G0AABCBC", "1312000G0AABDBD", "1312000G0AABFBF", "1312000G0AABGBG", "1312000G0AABIBI", "1312000G0AABKBK", "1313080S0AAADAD", "131500000AABNBN", "131500000AABRBR", "131500000AABSBS", "131500000AABTBT", "131500000AABVBV", "131500000AABXBX", "131500000BBNAA0", "131500000BBNBA0", "1315000G0AAALAL", "1315000G0AAAWAW", "1315000G0AABHBH", "1315000G0AABIBI", "1315000G0BLAAA0", "1501010F0AAAEAE", "1501010F0AAAFAF", "1501010F0AAAHAH", "1501041T0AAAUAU", "1501043A0AAAEAE", "1501043A0AAAFAF", "1502010G0AAADAD", "1502010I0AAAHAH", "1502010I0AAAMAM", "1502010J0AAAKAK", "1502010J0AABMBM", "1502010J0AABVBV", "1502010J0AAEMEM", "1502010J0AAEPEP", "1502010J0AAERER", "190400000AAEDED", "190400000AAUJUJ", "190500000AAACAC", "190600000AAA2A2", "190600000AAA9A9", "190600000AAAGAG", "190600000AABLBL", "190601000AABEBE", "190605000AACECE", "190700000BBCQA0", "190800000AAAPAP", "190800000AABTBT", "190900000AAASAS")
 GROUP BY month, practice_id

Denominator SQL

SELECT
     CAST(month AS DATE) AS month,
     practice AS practice_id,
     SUM(total_list_size / 1000.0) AS denominator
 FROM hscic.practice_statistics
 GROUP BY month, practice_id