/
SIS-MA DHIS2 Software Requirement Specification

SIS-MA DHIS2 Software Requirement Specification

Steps to extract SISMA_DHIS2_EPI Coverage Data.doc

Get percentages from the COBERTURAS PAV (Mensal) report

This is the first report that was outlined by Timoteo:

Items to hard code:

  • Mozambique Organization Unit: ou=LJX5GuypkKy

This report has two subqueries of the analytics API:

  • Query 1: Get the annual population estimates so you can calculate the Gr.Alvo columns for each immunization type (BCG, Polio Primario, Polio 1a Dose, etc)
  • Sample GET for the headers:
  • https://www.dhis2.org.mz/prod/api/analytics?dimension=dx:qGeMdrJaqK6;vr04MSOBMjC;uFfnh49uAZ0;uhAcJkYENXE;sTIec6HXB8U;D1HgqDPmaow;qXnAuJL2TMs&dimension=ou:L6z1mqFYii6;eCer1W6aTne;cai3Uyc1ngZ;coEbHyby9NV;p9UiH23JS15;f5F6xAskA05;pPGhROE8IIC;wqmPoqfG93D;IvsKEydqOUT;UN0aH8CjbZJ;sIPZ84RBqMM;LJX5GuypkKy&filter=pe:2017&displayProperty=NAME&tableLayout=true&columns=dx&rows=ou
  • We get the annual period (pe:2017) because the population estimates are loaded in at that level
    • There are no estimates for pe:2018
  • The dimensions are predefined based on the custom report. We do not need to change these.
  • This returns the following code block:

    {
      "title": "2017",
      "headers": [
        {
          "name": "Organisation unit ID",
          "column": "organisationunitid",
          "valueType": "TEXT",
          "type": "java.lang.String",
          "hidden": true,
          "meta": true
        },
        {
          "name": "Organisation unit",
          "column": "organisationunitname",
          "valueType": "TEXT",
          "type": "java.lang.String",
          "hidden": false,
          "meta": true
        },
        {
          "name": "Organisation unit code",
          "column": "organisationunitcode",
          "valueType": "TEXT",
          "type": "java.lang.String",
          "hidden": true,
          "meta": true
        },
        {
          "name": "Organisation unit description",
          "column": "organisationunitdescription",
          "valueType": "TEXT",
          "type": "java.lang.String",
          "hidden": true,
          "meta": true
        },
        {
          "name": "POP - 17.1 perc População Consultas 0-4 Anos ",
          "column": "população 171 perc consultas 0-4 anos  ",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "POP - 13.1 perc População Consultas 1-4 Anos",
          "column": "população 131 perc consultas 1-4 anos",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "POP - 24.9 perc População VAT MIF/ P. Familiar",
          "column": "população 249 perc vat mif p familiar",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "POP - 3.9 perc População  Polio/DPT/HepB/VAS/CCV/PVC10",
          "column": "população 39 perc poliodpthepbvasccvpvc10",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "POP - 4 perc População BCG/Polio primario/consultas 0-11 meses",
          "column": "pop 4 perc bcgpolio primarioconsultas 0-11 meses",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "POP - 4.5 perc População Partos /C.Post-Parto",
          "column": "população 45 perc partos cpost-parto",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "POP - 5 perc População VAT Mgrav. /C.Pré-Natal",
          "column": "população 5 perc vat mgrav cpré-natal",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        }
      ],
      "metaData": {
        "items": {
          "2017": {
            "name": "2017"
          },
          "f5F6xAskA05": {
            "name": "NAMPULA"
          },
          "sTIec6HXB8U": {
            "name": "POP - 4 perc População BCG/Polio primario/consultas 0-11 meses"
          },
          "uhAcJkYENXE": {
            "name": "POP - 3.9 perc População  Polio/DPT/HepB/VAS/CCV/PVC10"
          },
          "vr04MSOBMjC": {
            "name": "POP - 13.1 perc População Consultas 1-4 Anos"
          },
          "L6z1mqFYii6": {
            "name": "MAPUTO CIDADE"
          },
          "ou": {
            "name": "Organisation unit"
          },
          "D1HgqDPmaow": {
            "name": "POP - 4.5 perc População Partos /C.Post-Parto"
          },
          "qXnAuJL2TMs": {
            "name": "POP - 5 perc População VAT Mgrav. /C.Pré-Natal"
          },
          "eCer1W6aTne": {
            "name": "ZAMBEZIA"
          },
          "uFfnh49uAZ0": {
            "name": "POP - 24.9 perc População VAT MIF/ P. Familiar"
          },
          "wqmPoqfG93D": {
            "name": "CABO DELGADO"
          },
          "IvsKEydqOUT": {
            "name": "MAPUTO PROVINCIA"
          },
          "cai3Uyc1ngZ": {
            "name": "NIASSA"
          },
          "sIPZ84RBqMM": {
            "name": "INHAMBANE"
          },
          "dx": {
            "name": "Data"
          },
          "pe": {
            "name": "Period"
          },
          "coEbHyby9NV": {
            "name": "TETE"
          },
          "p9UiH23JS15": {
            "name": "GAZA"
          },
          "eHxvggyeOM2": {
            "name": "default"
          },
          "pPGhROE8IIC": {
            "name": "MANICA"
          },
          "UN0aH8CjbZJ": {
            "name": "SOFALA"
          },
          "qGeMdrJaqK6": {
            "name": "POP - 17.1 perc População Consultas 0-4 Anos "
          },
          "LJX5GuypkKy": {
            "name": "MOÇAMBIQUE"
          }
        },
        "dimensions": {
          "dx": [
            "qGeMdrJaqK6",
            "vr04MSOBMjC",
            "uFfnh49uAZ0",
            "uhAcJkYENXE",
            "sTIec6HXB8U",
            "D1HgqDPmaow",
            "qXnAuJL2TMs"
          ],
          "pe": [
            "2017"
          ],
          "ou": [
            "L6z1mqFYii6",
            "eCer1W6aTne",
            "cai3Uyc1ngZ",
            "coEbHyby9NV",
            "p9UiH23JS15",
            "f5F6xAskA05",
            "pPGhROE8IIC",
            "wqmPoqfG93D",
            "IvsKEydqOUT",
            "UN0aH8CjbZJ",
            "sIPZ84RBqMM",
            "LJX5GuypkKy"
          ],
          "co": [
            "eHxvggyeOM2"
          ]
        }
      },
      "rows": [
        [
          "L6z1mqFYii6",
          "MAPUTO CIDADE",
          "111",
          "",
          "217696.0",
          "166774.0",
          "316996.0",
          "49649.0",
          "50922.0",
          "57288.0",
          "63652.0"
        ],
        [
          "eCer1W6aTne",
          "ZAMBEZIA",
          "104",
          "",
          "862372.0",
          "660648.0",
          "1255737.0",
          "196682.0",
          "201724.0",
          "226941.0",
          "252157.0"
        ],
        [
          "cai3Uyc1ngZ",
          "NIASSA",
          "101",
          "",
          "305939.0",
          "234373.0",
          "445493.0",
          "69779.0",
          "71564.0",
          "80511.0",
          "89456.0"
        ],
        [
          "coEbHyby9NV",
          "TETE",
          "105",
          "",
          "465636.0",
          "356714.0",
          "678029.0",
          "106198.0",
          "108921.0",
          "122534.0",
          "136153.0"
        ],
        [
          "p9UiH23JS15",
          "GAZA",
          "109",
          "",
          "251019.0",
          "192300.0",
          "365520.0",
          "57250.0",
          "58718.0",
          "66057.0",
          "73398.0"
        ],
        [
          "f5F6xAskA05",
          "NAMPULA",
          "103",
          "",
          "851768.0",
          "687922.0",
          "1307571.0",
          "204801.0",
          "210053.0",
          "236303.0",
          "262563.0"
        ],
        [
          "pPGhROE8IIC",
          "MANICA",
          "106",
          "",
          "354208.0",
          "271354.0",
          "515780.0",
          "80785.0",
          "82856.0",
          "93213.0",
          "103569.0"
        ],
        [
          "wqmPoqfG93D",
          "CABO DELGADO",
          "102",
          "",
          "333850.0",
          "255758.0",
          "486132.0",
          "76141.0",
          "78095.0",
          "87855.0",
          "97618.0"
        ],
        [
          "IvsKEydqOUT",
          "MAPUTO PROVINCIA",
          "110",
          "",
          "317821.0",
          "243476.0",
          "462791.0",
          "72486.0",
          "74344.0",
          "83637.0",
          "92928.0"
        ],
        [
          "UN0aH8CjbZJ",
          "SOFALA",
          "107",
          "",
          "367781.0",
          "281753.0",
          "535541.0",
          "83878.0",
          "86031.0",
          "96784.0",
          "107538.0"
        ],
        [
          "sIPZ84RBqMM",
          "INHAMBANE",
          "108",
          "",
          "264682.0",
          "202767.0",
          "385415.0",
          "60365.0",
          "61913.0",
          "69653.0",
          "77393.0"
        ],
        [
          "LJX5GuypkKy",
          "MOÇAMBIQUE",
          "1",
          "",
          "4592772.0",
          "3553839.0",
          "6755005.0",
          "1058014.0",
          "1085141.0",
          "1220776.0",
          "1356425.0"
        ]
      ],
      "width": 11,
      "height": 12
    }

When mapped, these values look something like this for the Niassa Province:

Organisation unit descriptionOrganisation unit IDValue from Niassa Province rowDivided by 12 to get the monthly estimate
POP - 17.1 perc População Consultas 0-4 AnosqGeMdrJaqK6          305,939 25,495
POP - 13.1 perc População Consultas 1-4 Anosvr04MSOBMjC          234,373 19,531
POP - 24.9 perc População VAT MIF/ P. FamiliaruFfnh49uAZ0          445,493 37,124
POP - 3.9 perc População  Polio/DPT/HepB/VAS/CCV/PVC10uhAcJkYENXE            69,779    5,815 ← this is the calc for Gr. Alvo 3.9% for all other immunizations for Niassa in the report and it's the denominator for the Cobertura calculation
POP - 4 perc População BCG/Polio primario/consultas 0-11 mesessTIec6HXB8U            71,564    5,964 ← this is the calc for Gr. Alvo 4% for BCG for Niassa in the report and it's the denominator for the Cobertura calculation
POP - 4.5 perc População Partos /C.Post-PartoD1HgqDPmaow            80,511    6,709
POP - 5 perc População VAT Mgrav. /C.Pré-NatalqXnAuJL2TMs            89,456    7,455

We need to store this in the postgres database for future reference. Note that these are values for the year 2017 and we would need to also store values for 2018 when they are available.

Query 2: Get the raw values for the Realizado column

  • The Realizado column is the "actual" number of immunizations given. This is calculated by summing a number of lower level indicators from DHIS2
  • Sample GET request:
  • https://www.dhis2.org.mz/prod/api/analytics?dimension=dx:i7VbzJ0W5qT.AZq6AqCYSfD;i7VbzJ0W5qT.UYnV8StRNy3;i7VbzJ0W5qT.qaZHEHPHk6R;i7VbzJ0W5qT.mVw0xixOoBU;ytweIW4mUYf.AZq6AqCYSfD;ytweIW4mUYf.UYnV8StRNy3;ytweIW4mUYf.qaZHEHPHk6R;ytweIW4mUYf.mVw0xixOoBU;RBKSa3oUTg2.AZq6AqCYSfD;RBKSa3oUTg2.UYnV8StRNy3;RBKSa3oUTg2.qaZHEHPHk6R;RBKSa3oUTg2.mVw0xixOoBU;rLHCtgEQdnq.AZq6AqCYSfD;rLHCtgEQdnq.UYnV8StRNy3;rLHCtgEQdnq.qaZHEHPHk6R;rLHCtgEQdnq.mVw0xixOoBU;xw1x5f1HfOd.AZq6AqCYSfD;xw1x5f1HfOd.UYnV8StRNy3;xw1x5f1HfOd.qaZHEHPHk6R;xw1x5f1HfOd.mVw0xixOoBU;BPghXJ1HK64.AZq6AqCYSfD;BPghXJ1HK64.UYnV8StRNy3;BPghXJ1HK64.qaZHEHPHk6R;BPghXJ1HK64.mVw0xixOoBU;FeeXwOEJcGz.AZq6AqCYSfD;FeeXwOEJcGz.UYnV8StRNy3;FeeXwOEJcGz.qaZHEHPHk6R;FeeXwOEJcGz.mVw0xixOoBU;S3ReXW7kbv3.AZq6AqCYSfD;S3ReXW7kbv3.UYnV8StRNy3;S3ReXW7kbv3.qaZHEHPHk6R;S3ReXW7kbv3.mVw0xixOoBU;RtYn2iXsvPM.AZq6AqCYSfD;RtYn2iXsvPM.UYnV8StRNy3;RtYn2iXsvPM.qaZHEHPHk6R;RtYn2iXsvPM.mVw0xixOoBU;BMRTt5gbU85.AZq6AqCYSfD;BMRTt5gbU85.UYnV8StRNy3;BMRTt5gbU85.qaZHEHPHk6R;BMRTt5gbU85.mVw0xixOoBU;hLvZXyEZUIc.AZq6AqCYSfD;hLvZXyEZUIc.UYnV8StRNy3;hLvZXyEZUIc.qaZHEHPHk6R;hLvZXyEZUIc.mVw0xixOoBU;EckOKVrmvEX.AZq6AqCYSfD;EckOKVrmvEX.UYnV8StRNy3;EckOKVrmvEX.qaZHEHPHk6R;EckOKVrmvEX.mVw0xixOoBU;x2nuUb4JmDs.AZq6AqCYSfD;x2nuUb4JmDs.UYnV8StRNy3;x2nuUb4JmDs.qaZHEHPHk6R;x2nuUb4JmDs.mVw0xixOoBU;KWqwoZZXT99.AZq6AqCYSfD;KWqwoZZXT99.UYnV8StRNy3;KWqwoZZXT99.qaZHEHPHk6R;KWqwoZZXT99.mVw0xixOoBU;KAT4V8gyIIo.AZq6AqCYSfD;KAT4V8gyIIo.UYnV8StRNy3;KAT4V8gyIIo.qaZHEHPHk6R;KAT4V8gyIIo.mVw0xixOoBU;E99RDvLYuvZ.cBMku288XIu;E99RDvLYuvZ.Jp1mSZfd94e;E99RDvLYuvZ.dXjAUcOo5Ms;E99RDvLYuvZ.i7oAiY0OoKb;wZEOgPMvciS.An0ixEtkvD0;wZEOgPMvciS.Vl5SozUWrQB;wZEOgPMvciS.wtVP85udKGT;wZEOgPMvciS.ZHITxfjkOUz;RBKSa3oUTg2;xw1x5f1HfOd;FeeXwOEJcGz;RtYn2iXsvPM;BMRTt5gbU85;EckOKVrmvEX;x2nuUb4JmDs;KWqwoZZXT99&dimension=ou:L6z1mqFYii6;eCer1W6aTne;cai3Uyc1ngZ;coEbHyby9NV;p9UiH23JS15;f5F6xAskA05;pPGhROE8IIC;wqmPoqfG93D;IvsKEydqOUT;UN0aH8CjbZJ;sIPZ84RBqMM;LJX5GuypkKy&filter=pe:201712&displayProperty=NAME&tableLayout=true&columns=dx&rows=ou
  • Again, the dimensions are hard coded in the report and we do not need to change these
  • The filter=pe:201712 is what needs to change. This is the period which has the combination YYYYMM The analytics endpoint will calculate this for each month and return raw JSON if we change this value to be something like 201701 for January 2017

    {
      "title": "Dezembro 2017",
      "headers": [
        {
          "name": "Organisation unit ID",
          "column": "organisationunitid",
          "valueType": "TEXT",
          "type": "java.lang.String",
          "hidden": true,
          "meta": true
        },
        {
          "name": "Organisation unit",
          "column": "organisationunitname",
          "valueType": "TEXT",
          "type": "java.lang.String",
          "hidden": false,
          "meta": true
        },
        {
          "name": "Organisation unit code",
          "column": "organisationunitcode",
          "valueType": "TEXT",
          "type": "java.lang.String",
          "hidden": true,
          "meta": true
        },
        {
          "name": "Organisation unit description",
          "column": "organisationunitdescription",
          "valueType": "TEXT",
          "type": "java.lang.String",
          "hidden": true,
          "meta": true
        },
        {
          "name": "PAV - BCG 0 - 11 meses, Brigada Móvel, FEMININO",
          "column": "pav - bcg 0 - 11 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - BCG 0 - 11 meses, Brigada Móvel, MASCULINO",
          "column": "pav - bcg 0 - 11 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - BCG 0 - 11 meses, Posto Fixo, FEMININO",
          "column": "pav - bcg 0 - 11 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - BCG 0 - 11 meses, Posto Fixo, MASCULINO",
          "column": "pav - bcg 0 - 11 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio primario 0 - 11 meses, Brigada Móvel, FEMININO",
          "column": "pav - polio primario 0 - 11 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio primario 0 - 11 meses, Brigada Móvel, MASCULINO",
          "column": "pav - polio primario 0 - 11 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio primario 0 - 11 meses, Posto Fixo, FEMININO",
          "column": "pav - polio primario 0 - 11 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio primario 0 - 11 meses, Posto Fixo, MASCULINO",
          "column": "pav - polio primario 0 - 11 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININO",
          "column": "pav - polio 1ª dose 0 - 11 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO",
          "column": "pav - polio 1ª dose 0 - 11 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio 1ª Dose 0 - 11 meses, Posto Fixo, FEMININO",
          "column": "pav - polio 1ª dose 0 - 11 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINO",
          "column": "pav - polio 1ª dose 0 - 11 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININO",
          "column": "pav - polio 2ª dose 0 - 11 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO",
          "column": "pav - polio 2ª dose 0 - 11 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio 2ª Dose 0 - 11 meses, Posto Fixo, FEMININO",
          "column": "pav - polio 2ª dose 0 - 11 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINO",
          "column": "pav - polio 2ª dose 0 - 11 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio 3ª Dose 0 - 11 meses, Brigada Móvel, FEMININO",
          "column": "pav - polio 3ª dose 0 - 11 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio 3ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO",
          "column": "pav - polio 3ª dose 0 - 11 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio 3ª Dose 0 - 11 meses, Posto Fixo, FEMININO",
          "column": "pav - polio 3ª dose 0 - 11 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio 3ª Dose 0 - 11 meses, Posto Fixo, MASCULINO",
          "column": "pav - polio 3ª dose 0 - 11 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - IPV 0 - 11 meses, Brigada Móvel, FEMININO",
          "column": "pav - ipv 0 - 11 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - IPV 0 - 11 meses, Brigada Móvel, MASCULINO",
          "column": "pav - ipv 0 - 11 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - IPV 0 - 11 meses, Posto Fixo, FEMININO",
          "column": "pav - ipv 0 - 11 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - IPV 0 - 11 meses, Posto Fixo, MASCULINO",
          "column": "pav - ipv 0 - 11 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININO",
          "column": "pav - dpt-hepb+hib 1ª dose 0 - 11 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO",
          "column": "pav - dpt-hepb+hib 1ª dose 0 - 11 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Posto Fixo, FEMININO",
          "column": "pav - dpt-hepb+hib 1ª dose 0 - 11 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINO",
          "column": "pav - dpt-hepb+hib 1ª dose 0 - 11 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININO",
          "column": "pav - dpt-hepb+hib 2ª dose 0 - 11 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO",
          "column": "pav - dpt-hepb+hib 2ª dose 0 - 11 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Posto Fixo, FEMININO",
          "column": "pav - dpt-hepb+hib 2ª dose 0 - 11 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINO",
          "column": "pav - dpt-hepb+hib 2ª dose 0 - 11 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Brigada Móvel, FEMININO",
          "column": "pav - dpt-hepb+hib 3ª dose 0 - 11 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO",
          "column": "pav - dpt-hepb+hib 3ª dose 0 - 11 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Posto Fixo, FEMININO",
          "column": "pav - dpt-hepb+hib 3ª dose 0 - 11 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Posto Fixo, MASCULINO",
          "column": "pav - dpt-hepb+hib 3ª dose 0 - 11 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - PCV 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININO",
          "column": "pav - pcv 1ª dose 0 - 11 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - PCV 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO",
          "column": "pav - pcv 1ª dose 0 - 11 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - PCV 1ª Dose 0 - 11 meses, Posto Fixo, FEMININO",
          "column": "pav - pcv 1ª dose 0 - 11 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - PCV 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINO",
          "column": "pav - pcv 1ª dose 0 - 11 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - PCV 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININO",
          "column": "pav - pcv 2ª dose 0 - 11 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - PCV 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO",
          "column": "pav - pcv 2ª dose 0 - 11 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - PCV 2ª Dose 0 - 11 meses, Posto Fixo, FEMININO",
          "column": "pav - pcv 2ª dose 0 - 11 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - PCV 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINO",
          "column": "pav - pcv 2ª dose 0 - 11 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - PCV 3ª Dose 0 - 11 meses, Brigada Móvel, FEMININO",
          "column": "pav - pcv 3ª dose 0 - 11 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - PCV 3ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO",
          "column": "pav - pcv 3ª dose 0 - 11 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - PCV 3ª Dose 0 - 11 meses, Posto Fixo, FEMININO",
          "column": "pav - pcv 3ª dose 0 - 11 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - PCV 3ª Dose 0 - 11 meses, Posto Fixo, MASCULINO",
          "column": "pav - pcv 3ª dose 0 - 11 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - RV 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININO",
          "column": "pav - rv 1ª dose 0 - 11 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - RV 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO",
          "column": "pav - rv 1ª dose 0 - 11 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - RV 1ª Dose 0 - 11 meses, Posto Fixo, FEMININO",
          "column": "pav - rv 1ª dose 0 - 11 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - RV 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINO",
          "column": "pav - rv 1ª dose 0 - 11 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - RV 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININO",
          "column": "pav - rv 2ª dose 0 - 11 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - RV 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO",
          "column": "pav - rv 2ª dose 0 - 11 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - RV 2ª Dose 0 - 11 meses, Posto Fixo, FEMININO",
          "column": "pav - rv 2ª dose 0 - 11 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - RV 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINO",
          "column": "pav - rv 2ª dose 0 - 11 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Sarampo 0 - 11 meses, Brigada Móvel, FEMININO",
          "column": "pav - sarampo 0 - 11 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Sarampo 0 - 11 meses, Brigada Móvel, MASCULINO",
          "column": "pav - sarampo 0 - 11 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Sarampo 0 - 11 meses, Posto Fixo, FEMININO",
          "column": "pav - sarampo 0 - 11 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Sarampo 0 - 11 meses, Posto Fixo, MASCULINO",
          "column": "pav - sarampo 0 - 11 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Sarampo-Rubéola 18-23 meses, Brigada Móvel, FEMININO",
          "column": "pav - sarampo-rubéola 18-23 meses, brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Sarampo-Rubéola 18-23 meses, Brigada Móvel, MASCULINO",
          "column": "pav - sarampo-rubéola 18-23 meses, brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Sarampo-Rubéola 18-23 meses, Posto Fixo, FEMININO",
          "column": "pav - sarampo-rubéola 18-23 meses, posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Sarampo-Rubéola 18-23 meses, Posto Fixo, MASCULINO",
          "column": "pav - sarampo-rubéola 18-23 meses, posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Crianças Completamente Vacinadas Brigada Móvel, FEMININO",
          "column": "pav - crianças completamente vacinadas brigada móvel, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Crianças Completamente Vacinadas Brigada Móvel, MASCULINO",
          "column": "pav - crianças completamente vacinadas brigada móvel, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Crianças Completamente Vacinadas Posto Fixo, FEMININO",
          "column": "pav - crianças completamente vacinadas posto fixo, feminino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Crianças Completamente Vacinadas Posto Fixo, MASCULINO",
          "column": "pav - crianças completamente vacinadas posto fixo, masculino",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio 1ª Dose",
          "column": "pav - polio 1ª dose",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - Polio 3ª Dose",
          "column": "pav - polio 3ª dose",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - DPT-HepB+Hib 1ª Dose",
          "column": "pav - dpt-hepb+hib 1ª dose",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - DPT-HepB+Hib 3ª Dose",
          "column": "pav - dpt-hepb+hib 3ª dose",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - PCV 1ª Dose",
          "column": "pav - pcv 1ª dose",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - PCV 3ª Dose",
          "column": "pav - pcv 3ª dose",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - RV 1ª Dose",
          "column": "pav - rv 1ª dose",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        },
        {
          "name": "PAV - RV 2ª Dose",
          "column": "pav - rv 2ª dose",
          "valueType": "NUMBER",
          "type": "java.lang.Double",
          "hidden": false,
          "meta": false
        }
      ],
      "metaData": {
        "items": {
          "201712": {
            "name": "Dezembro 2017"
          },
          "KAT4V8gyIIo.qaZHEHPHk6R": {
            "name": "PAV - Sarampo 0 - 11 meses, Posto Fixo, FEMININO"
          },
          "z9AZ1GTOUzK": {
            "name": "12-23 meses, Brigada Móvel, MASCULINO"
          },
          "FeeXwOEJcGz.AZq6AqCYSfD": {
            "name": "PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININO"
          },
          "x2nuUb4JmDs.AZq6AqCYSfD": {
            "name": "PAV - RV 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININO"
          },
          "BMRTt5gbU85.qaZHEHPHk6R": {
            "name": "PAV - PCV 1ª Dose 0 - 11 meses, Posto Fixo, FEMININO"
          },
          "hLvZXyEZUIc.UYnV8StRNy3": {
            "name": "PAV - PCV 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "xw1x5f1HfOd.qaZHEHPHk6R": {
            "name": "PAV - Polio 3ª Dose 0 - 11 meses, Posto Fixo, FEMININO"
          },
          "wZEOgPMvciS.wtVP85udKGT": {
            "name": "PAV - Crianças Completamente Vacinadas Posto Fixo, FEMININO"
          },
          "RBKSa3oUTg2.AZq6AqCYSfD": {
            "name": "PAV - Polio 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININO"
          },
          "RBKSa3oUTg2.mVw0xixOoBU": {
            "name": "PAV - Polio 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "ytweIW4mUYf.UYnV8StRNy3": {
            "name": "PAV - Polio primario 0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "x2nuUb4JmDs.UYnV8StRNy3": {
            "name": "PAV - RV 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "KAT4V8gyIIo.AZq6AqCYSfD": {
            "name": "PAV - Sarampo 0 - 11 meses, Brigada Móvel, FEMININO"
          },
          "xw1x5f1HfOd": {
            "name": "PAV - Polio 3ª Dose"
          },
          "hLvZXyEZUIc.mVw0xixOoBU": {
            "name": "PAV - PCV 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "FeeXwOEJcGz.mVw0xixOoBU": {
            "name": "PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "BMRTt5gbU85": {
            "name": "PAV - PCV 1ª Dose"
          },
          "S3ReXW7kbv3.UYnV8StRNy3": {
            "name": "PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "RBKSa3oUTg2.qaZHEHPHk6R": {
            "name": "PAV - Polio 1ª Dose 0 - 11 meses, Posto Fixo, FEMININO"
          },
          "BMRTt5gbU85.mVw0xixOoBU": {
            "name": "PAV - PCV 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "BMRTt5gbU85.AZq6AqCYSfD": {
            "name": "PAV - PCV 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININO"
          },
          "xw1x5f1HfOd.UYnV8StRNy3": {
            "name": "PAV - Polio 3ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "EckOKVrmvEX.mVw0xixOoBU": {
            "name": "PAV - PCV 3ª Dose 0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "wZEOgPMvciS.An0ixEtkvD0": {
            "name": "PAV - Crianças Completamente Vacinadas Brigada Móvel, FEMININO"
          },
          "i7VbzJ0W5qT.qaZHEHPHk6R": {
            "name": "PAV - BCG 0 - 11 meses, Posto Fixo, FEMININO"
          },
          "wZEOgPMvciS.ZHITxfjkOUz": {
            "name": "PAV - Crianças Completamente Vacinadas Posto Fixo, MASCULINO"
          },
          "BPghXJ1HK64.UYnV8StRNy3": {
            "name": "PAV - IPV 0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "IvsKEydqOUT": {
            "name": "MAPUTO PROVINCIA"
          },
          "KAT4V8gyIIo.UYnV8StRNy3": {
            "name": "PAV - Sarampo 0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "hLvZXyEZUIc.AZq6AqCYSfD": {
            "name": "PAV - PCV 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININO"
          },
          "qaZHEHPHk6R": {
            "name": "0 - 11 meses, Posto Fixo, FEMININO"
          },
          "x2nuUb4JmDs": {
            "name": "PAV - RV 1ª Dose"
          },
          "GtXOn8sdiYz": {
            "name": "12-23 meses, Brigada Móvel, FEMININO"
          },
          "x2nuUb4JmDs.qaZHEHPHk6R": {
            "name": "PAV - RV 1ª Dose 0 - 11 meses, Posto Fixo, FEMININO"
          },
          "ytweIW4mUYf.mVw0xixOoBU": {
            "name": "PAV - Polio primario 0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "RBKSa3oUTg2.UYnV8StRNy3": {
            "name": "PAV - Polio 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "FeeXwOEJcGz.UYnV8StRNy3": {
            "name": "PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "xw1x5f1HfOd.AZq6AqCYSfD": {
            "name": "PAV - Polio 3ª Dose 0 - 11 meses, Brigada Móvel, FEMININO"
          },
          "BPghXJ1HK64.AZq6AqCYSfD": {
            "name": "PAV - IPV 0 - 11 meses, Brigada Móvel, FEMININO"
          },
          "ytweIW4mUYf.qaZHEHPHk6R": {
            "name": "PAV - Polio primario 0 - 11 meses, Posto Fixo, FEMININO"
          },
          "RtYn2iXsvPM.qaZHEHPHk6R": {
            "name": "PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Posto Fixo, FEMININO"
          },
          "x2nuUb4JmDs.mVw0xixOoBU": {
            "name": "PAV - RV 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "cai3Uyc1ngZ": {
            "name": "NIASSA"
          },
          "RtYn2iXsvPM.UYnV8StRNy3": {
            "name": "PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "BMRTt5gbU85.UYnV8StRNy3": {
            "name": "PAV - PCV 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "FeeXwOEJcGz.qaZHEHPHk6R": {
            "name": "PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Posto Fixo, FEMININO"
          },
          "pPGhROE8IIC": {
            "name": "MANICA"
          },
          "S3ReXW7kbv3.mVw0xixOoBU": {
            "name": "PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "EckOKVrmvEX.qaZHEHPHk6R": {
            "name": "PAV - PCV 3ª Dose 0 - 11 meses, Posto Fixo, FEMININO"
          },
          "i7VbzJ0W5qT.UYnV8StRNy3": {
            "name": "PAV - BCG 0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "KWqwoZZXT99.mVw0xixOoBU": {
            "name": "PAV - RV 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "KWqwoZZXT99.UYnV8StRNy3": {
            "name": "PAV - RV 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "i7VbzJ0W5qT.mVw0xixOoBU": {
            "name": "PAV - BCG 0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "BPghXJ1HK64.qaZHEHPHk6R": {
            "name": "PAV - IPV 0 - 11 meses, Posto Fixo, FEMININO"
          },
          "UYnV8StRNy3": {
            "name": "0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "EckOKVrmvEX": {
            "name": "PAV - PCV 3ª Dose"
          },
          "S3ReXW7kbv3.qaZHEHPHk6R": {
            "name": "PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Posto Fixo, FEMININO"
          },
          "E99RDvLYuvZ.cBMku288XIu": {
            "name": "PAV - Sarampo-Rubéola 18-23 meses, Brigada Móvel, FEMININO"
          },
          "sIPZ84RBqMM": {
            "name": "INHAMBANE"
          },
          "dx": {
            "name": "Data"
          },
          "rLHCtgEQdnq.UYnV8StRNy3": {
            "name": "PAV - Polio 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "LJX5GuypkKy": {
            "name": "MOÇAMBIQUE"
          },
          "wZEOgPMvciS.Vl5SozUWrQB": {
            "name": "PAV - Crianças Completamente Vacinadas Brigada Móvel, MASCULINO"
          },
          "KWqwoZZXT99.AZq6AqCYSfD": {
            "name": "PAV - RV 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININO"
          },
          "wqmPoqfG93D": {
            "name": "CABO DELGADO"
          },
          "i7VbzJ0W5qT.AZq6AqCYSfD": {
            "name": "PAV - BCG 0 - 11 meses, Brigada Móvel, FEMININO"
          },
          "rLHCtgEQdnq.mVw0xixOoBU": {
            "name": "PAV - Polio 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "RtYn2iXsvPM": {
            "name": "PAV - DPT-HepB+Hib 3ª Dose"
          },
          "rLHCtgEQdnq.AZq6AqCYSfD": {
            "name": "PAV - Polio 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININO"
          },
          "RtYn2iXsvPM.AZq6AqCYSfD": {
            "name": "PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Brigada Móvel, FEMININO"
          },
          "mVw0xixOoBU": {
            "name": "0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "AZq6AqCYSfD": {
            "name": "0 - 11 meses, Brigada Móvel, FEMININO"
          },
          "RtYn2iXsvPM.mVw0xixOoBU": {
            "name": "PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "j3c0COpGtbg": {
            "name": "12-23 meses, Posto Fixo, FEMININO"
          },
          "f5F6xAskA05": {
            "name": "NAMPULA"
          },
          "ytweIW4mUYf.AZq6AqCYSfD": {
            "name": "PAV - Polio primario 0 - 11 meses, Brigada Móvel, FEMININO"
          },
          "L6z1mqFYii6": {
            "name": "MAPUTO CIDADE"
          },
          "eCer1W6aTne": {
            "name": "ZAMBEZIA"
          },
          "KWqwoZZXT99.qaZHEHPHk6R": {
            "name": "PAV - RV 2ª Dose 0 - 11 meses, Posto Fixo, FEMININO"
          },
          "p9UiH23JS15": {
            "name": "GAZA"
          },
          "EckOKVrmvEX.UYnV8StRNy3": {
            "name": "PAV - PCV 3ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO"
          },
          "UN0aH8CjbZJ": {
            "name": "SOFALA"
          },
          "KAT4V8gyIIo.mVw0xixOoBU": {
            "name": "PAV - Sarampo 0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "EckOKVrmvEX.AZq6AqCYSfD": {
            "name": "PAV - PCV 3ª Dose 0 - 11 meses, Brigada Móvel, FEMININO"
          },
          "KWqwoZZXT99": {
            "name": "PAV - RV 2ª Dose"
          },
          "ou": {
            "name": "Organisation unit"
          },
          "E99RDvLYuvZ.i7oAiY0OoKb": {
            "name": "PAV - Sarampo-Rubéola 18-23 meses, Posto Fixo, MASCULINO"
          },
          "RBKSa3oUTg2": {
            "name": "PAV - Polio 1ª Dose"
          },
          "E99RDvLYuvZ.Jp1mSZfd94e": {
            "name": "PAV - Sarampo-Rubéola 18-23 meses, Brigada Móvel, MASCULINO"
          },
          "FeeXwOEJcGz": {
            "name": "PAV - DPT-HepB+Hib 1ª Dose"
          },
          "BPghXJ1HK64.mVw0xixOoBU": {
            "name": "PAV - IPV 0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "E99RDvLYuvZ.dXjAUcOo5Ms": {
            "name": "PAV - Sarampo-Rubéola 18-23 meses, Posto Fixo, FEMININO"
          },
          "rLHCtgEQdnq.qaZHEHPHk6R": {
            "name": "PAV - Polio 2ª Dose 0 - 11 meses, Posto Fixo, FEMININO"
          },
          "hLvZXyEZUIc.qaZHEHPHk6R": {
            "name": "PAV - PCV 2ª Dose 0 - 11 meses, Posto Fixo, FEMININO"
          },
          "xw1x5f1HfOd.mVw0xixOoBU": {
            "name": "PAV - Polio 3ª Dose 0 - 11 meses, Posto Fixo, MASCULINO"
          },
          "pe": {
            "name": "Period"
          },
          "coEbHyby9NV": {
            "name": "TETE"
          },
          "yzqmjuC42JY": {
            "name": "12-23 meses, Posto Fixo, MASCULINO"
          },
          "S3ReXW7kbv3.AZq6AqCYSfD": {
            "name": "PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININO"
          }
        },
        "dimensions": {
          "dx": [
            "i7VbzJ0W5qT.AZq6AqCYSfD",
            "i7VbzJ0W5qT.UYnV8StRNy3",
            "i7VbzJ0W5qT.qaZHEHPHk6R",
            "i7VbzJ0W5qT.mVw0xixOoBU",
            "ytweIW4mUYf.AZq6AqCYSfD",
            "ytweIW4mUYf.UYnV8StRNy3",
            "ytweIW4mUYf.qaZHEHPHk6R",
            "ytweIW4mUYf.mVw0xixOoBU",
            "RBKSa3oUTg2.AZq6AqCYSfD",
            "RBKSa3oUTg2.UYnV8StRNy3",
            "RBKSa3oUTg2.qaZHEHPHk6R",
            "RBKSa3oUTg2.mVw0xixOoBU",
            "rLHCtgEQdnq.AZq6AqCYSfD",
            "rLHCtgEQdnq.UYnV8StRNy3",
            "rLHCtgEQdnq.qaZHEHPHk6R",
            "rLHCtgEQdnq.mVw0xixOoBU",
            "xw1x5f1HfOd.AZq6AqCYSfD",
            "xw1x5f1HfOd.UYnV8StRNy3",
            "xw1x5f1HfOd.qaZHEHPHk6R",
            "xw1x5f1HfOd.mVw0xixOoBU",
            "BPghXJ1HK64.AZq6AqCYSfD",
            "BPghXJ1HK64.UYnV8StRNy3",
            "BPghXJ1HK64.qaZHEHPHk6R",
            "BPghXJ1HK64.mVw0xixOoBU",
            "FeeXwOEJcGz.AZq6AqCYSfD",
            "FeeXwOEJcGz.UYnV8StRNy3",
            "FeeXwOEJcGz.qaZHEHPHk6R",
            "FeeXwOEJcGz.mVw0xixOoBU",
            "S3ReXW7kbv3.AZq6AqCYSfD",
            "S3ReXW7kbv3.UYnV8StRNy3",
            "S3ReXW7kbv3.qaZHEHPHk6R",
            "S3ReXW7kbv3.mVw0xixOoBU",
            "RtYn2iXsvPM.AZq6AqCYSfD",
            "RtYn2iXsvPM.UYnV8StRNy3",
            "RtYn2iXsvPM.qaZHEHPHk6R",
            "RtYn2iXsvPM.mVw0xixOoBU",
            "BMRTt5gbU85.AZq6AqCYSfD",
            "BMRTt5gbU85.UYnV8StRNy3",
            "BMRTt5gbU85.qaZHEHPHk6R",
            "BMRTt5gbU85.mVw0xixOoBU",
            "hLvZXyEZUIc.AZq6AqCYSfD",
            "hLvZXyEZUIc.UYnV8StRNy3",
            "hLvZXyEZUIc.qaZHEHPHk6R",
            "hLvZXyEZUIc.mVw0xixOoBU",
            "EckOKVrmvEX.AZq6AqCYSfD",
            "EckOKVrmvEX.UYnV8StRNy3",
            "EckOKVrmvEX.qaZHEHPHk6R",
            "EckOKVrmvEX.mVw0xixOoBU",
            "x2nuUb4JmDs.AZq6AqCYSfD",
            "x2nuUb4JmDs.UYnV8StRNy3",
            "x2nuUb4JmDs.qaZHEHPHk6R",
            "x2nuUb4JmDs.mVw0xixOoBU",
            "KWqwoZZXT99.AZq6AqCYSfD",
            "KWqwoZZXT99.UYnV8StRNy3",
            "KWqwoZZXT99.qaZHEHPHk6R",
            "KWqwoZZXT99.mVw0xixOoBU",
            "KAT4V8gyIIo.AZq6AqCYSfD",
            "KAT4V8gyIIo.UYnV8StRNy3",
            "KAT4V8gyIIo.qaZHEHPHk6R",
            "KAT4V8gyIIo.mVw0xixOoBU",
            "E99RDvLYuvZ.cBMku288XIu",
            "E99RDvLYuvZ.Jp1mSZfd94e",
            "E99RDvLYuvZ.dXjAUcOo5Ms",
            "E99RDvLYuvZ.i7oAiY0OoKb",
            "wZEOgPMvciS.An0ixEtkvD0",
            "wZEOgPMvciS.Vl5SozUWrQB",
            "wZEOgPMvciS.wtVP85udKGT",
            "wZEOgPMvciS.ZHITxfjkOUz",
            "RBKSa3oUTg2",
            "xw1x5f1HfOd",
            "FeeXwOEJcGz",
            "RtYn2iXsvPM",
            "BMRTt5gbU85",
            "EckOKVrmvEX",
            "x2nuUb4JmDs",
            "KWqwoZZXT99"
          ],
          "pe": [
            "201712"
          ],
          "ou": [
            "L6z1mqFYii6",
            "eCer1W6aTne",
            "cai3Uyc1ngZ",
            "coEbHyby9NV",
            "p9UiH23JS15",
            "f5F6xAskA05",
            "pPGhROE8IIC",
            "wqmPoqfG93D",
            "IvsKEydqOUT",
            "UN0aH8CjbZJ",
            "sIPZ84RBqMM",
            "LJX5GuypkKy"
          ],
          "co": [
            "qaZHEHPHk6R",
            "z9AZ1GTOUzK",
            "GtXOn8sdiYz",
            "mVw0xixOoBU",
            "AZq6AqCYSfD",
            "yzqmjuC42JY",
            "j3c0COpGtbg",
            "UYnV8StRNy3"
          ]
        }
      },
      "rows": [
        [
          "L6z1mqFYii6",
          "MAPUTO CIDADE",
          "111",
          "",
          "",
          "",
          "1158.0",
          "1192.0",
          "",
          "",
          "1151.0",
          "1181.0",
          "1.0",
          "2.0",
          "1657.0",
          "1227.0",
          "2.0",
          "2.0",
          "1380.0",
          "1337.0",
          "5.0",
          "1.0",
          "1282.0",
          "1249.0",
          "1.0",
          "",
          "1282.0",
          "1253.0",
          "1.0",
          "2.0",
          "1298.0",
          "1228.0",
          "2.0",
          "2.0",
          "1377.0",
          "1339.0",
          "5.0",
          "1.0",
          "1282.0",
          "1251.0",
          "1.0",
          "2.0",
          "1293.0",
          "1229.0",
          "2.0",
          "2.0",
          "1377.0",
          "1337.0",
          "5.0",
          "1.0",
          "1282.0",
          "1250.0",
          "1.0",
          "2.0",
          "1294.0",
          "1229.0",
          "2.0",
          "2.0",
          "1377.0",
          "1336.0",
          "32.0",
          "35.0",
          "1377.0",
          "1378.0",
          "34.0",
          "42.0",
          "903.0",
          "859.0",
          "47.0",
          "52.0",
          "1381.0",
          "1378.0",
          "2887.0",
          "2538.0",
          "2529.0",
          "2540.0",
          "2525.0",
          "2539.0",
          "2526.0",
          "2717.0"
        ],
        [
          "eCer1W6aTne",
          "ZAMBEZIA",
          "104",
          "",
          "852.0",
          "775.0",
          "9163.0",
          "8804.0",
          "249.0",
          "229.0",
          "3907.0",
          "3777.0",
          "349.0",
          "341.0",
          "4376.0",
          "4322.0",
          "367.0",
          "303.0",
          "3757.0",
          "3742.0",
          "379.0",
          "341.0",
          "3698.0",
          "3499.0",
          "186.0",
          "165.0",
          "1319.0",
          "1264.0",
          "913.0",
          "878.0",
          "8584.0",
          "8560.0",
          "853.0",
          "804.0",
          "7763.0",
          "7422.0",
          "925.0",
          "875.0",
          "7284.0",
          "7138.0",
          "912.0",
          "884.0",
          "8543.0",
          "8530.0",
          "870.0",
          "805.0",
          "7730.0",
          "7404.0",
          "931.0",
          "858.0",
          "7347.0",
          "7112.0",
          "832.0",
          "811.0",
          "8186.0",
          "8097.0",
          "784.0",
          "741.0",
          "7068.0",
          "6842.0",
          "980.0",
          "972.0",
          "6878.0",
          "6418.0",
          "833.0",
          "799.0",
          "3759.0",
          "3676.0",
          "935.0",
          "889.0",
          "6021.0",
          "5689.0",
          "9470.0",
          "8018.0",
          "19140.0",
          "16433.0",
          "19072.0",
          "16478.0",
          "17940.0",
          "15450.0"
        ],
        [
          "cai3Uyc1ngZ",
          "NIASSA",
          "101",
          "",
          "150.0",
          "170.0",
          "4199.0",
          "4047.0",
          "134.0",
          "151.0",
          "3984.0",
          "3796.0",
          "359.0",
          "379.0",
          "3222.0",
          "3040.0",
          "346.0",
          "299.0",
          "2813.0",
          "2799.0",
          "495.0",
          "543.0",
          "2617.0",
          "2633.0",
          "329.0",
          "363.0",
          "2154.0",
          "2208.0",
          "341.0",
          "361.0",
          "3228.0",
          "3078.0",
          "639.0",
          "295.0",
          "2866.0",
          "2839.0",
          "495.0",
          "535.0",
          "2664.0",
          "2670.0",
          "341.0",
          "362.0",
          "3227.0",
          "3057.0",
          "343.0",
          "295.0",
          "2846.0",
          "2819.0",
          "487.0",
          "535.0",
          "2647.0",
          "2663.0",
          "325.0",
          "336.0",
          "3207.0",
          "3038.0",
          "331.0",
          "280.0",
          "2787.0",
          "2768.0",
          "994.0",
          "794.0",
          "2709.0",
          "2665.0",
          "349.0",
          "365.0",
          "1363.0",
          "1391.0",
          "951.0",
          "774.0",
          "2655.0",
          "2574.0",
          "7003.0",
          "6297.0",
          "7010.0",
          "6379.0",
          "6989.0",
          "6353.0",
          "6906.0",
          "6169.0"
        ],
        [
          "coEbHyby9NV",
          "TETE",
          "105",
          "",
          "120.0",
          "103.0",
          "3524.0",
          "3815.0",
          "62.0",
          "60.0",
          "4015.0",
          "3599.0",
          "98.0",
          "69.0",
          "3377.0",
          "3577.0",
          "75.0",
          "57.0",
          "3591.0",
          "3500.0",
          "76.0",
          "52.0",
          "3277.0",
          "3342.0",
          "145.0",
          "116.0",
          "3232.0",
          "3335.0",
          "140.0",
          "107.0",
          "3465.0",
          "3576.0",
          "127.0",
          "107.0",
          "3605.0",
          "3482.0",
          "138.0",
          "105.0",
          "3356.0",
          "3414.0",
          "152.0",
          "122.0",
          "3387.0",
          "3492.0",
          "135.0",
          "119.0",
          "3506.0",
          "3400.0",
          "123.0",
          "102.0",
          "3292.0",
          "3325.0",
          "141.0",
          "111.0",
          "3350.0",
          "3526.0",
          "125.0",
          "109.0",
          "3455.0",
          "3356.0",
          "135.0",
          "133.0",
          "3486.0",
          "3460.0",
          "37.0",
          "51.0",
          "2256.0",
          "2209.0",
          "51.0",
          "56.0",
          "2868.0",
          "2749.0",
          "7193.0",
          "6807.0",
          "7357.0",
          "7071.0",
          "7225.0",
          "6899.0",
          "7128.0",
          "7045.0"
        ],
        [
          "p9UiH23JS15",
          "GAZA",
          "109",
          "",
          "15.0",
          "4.0",
          "2258.0",
          "2153.0",
          "15.0",
          "4.0",
          "2246.0",
          "2145.0",
          "8.0",
          "14.0",
          "2875.0",
          "2579.0",
          "9.0",
          "10.0",
          "2521.0",
          "2438.0",
          "16.0",
          "11.0",
          "2498.0",
          "2429.0",
          "18.0",
          "11.0",
          "2499.0",
          "2427.0",
          "8.0",
          "14.0",
          "2875.0",
          "2579.0",
          "9.0",
          "10.0",
          "2521.0",
          "2438.0",
          "18.0",
          "11.0",
          "2487.0",
          "2440.0",
          "8.0",
          "14.0",
          "2875.0",
          "2579.0",
          "9.0",
          "10.0",
          "2521.0",
          "2438.0",
          "18.0",
          "11.0",
          "2487.0",
          "2440.0",
          "8.0",
          "14.0",
          "2874.0",
          "2579.0",
          "9.0",
          "10.0",
          "2519.0",
          "2436.0",
          "17.0",
          "26.0",
          "2594.0",
          "2559.0",
          "24.0",
          "9.0",
          "1449.0",
          "1385.0",
          "17.0",
          "26.0",
          "2583.0",
          "2557.0",
          "5476.0",
          "4954.0",
          "5476.0",
          "4956.0",
          "5476.0",
          "4956.0",
          "5475.0",
          "4974.0"
        ],
        [
          "f5F6xAskA05",
          "NAMPULA",
          "103",
          "",
          "331.0",
          "333.0",
          "10149.0",
          "9754.0",
          "181.0",
          "187.0",
          "5439.0",
          "5021.0",
          "200.0",
          "218.0",
          "5272.0",
          "5137.0",
          "181.0",
          "207.0",
          "4764.0",
          "4588.0",
          "203.0",
          "191.0",
          "4621.0",
          "4468.0",
          "201.0",
          "185.0",
          "5162.0",
          "4939.0",
          "268.0",
          "278.0",
          "8405.0",
          "7995.0",
          "238.0",
          "260.0",
          "7750.0",
          "7302.0",
          "291.0",
          "277.0",
          "7362.0",
          "7042.0",
          "256.0",
          "252.0",
          "8027.0",
          "7642.0",
          "256.0",
          "267.0",
          "7553.0",
          "7164.0",
          "309.0",
          "287.0",
          "7196.0",
          "6939.0",
          "248.0",
          "263.0",
          "7841.0",
          "7599.0",
          "239.0",
          "250.0",
          "6996.0",
          "6651.0",
          "367.0",
          "341.0",
          "7230.0",
          "6885.0",
          "208.0",
          "188.0",
          "3643.0",
          "3643.0",
          "352.0",
          "287.0",
          "6870.0",
          "6669.0",
          "11047.0",
          "9677.0",
          "17188.0",
          "15183.0",
          "16396.0",
          "14932.0",
          "15953.0",
          "14136.0"
        ],
        [
          "pPGhROE8IIC",
          "MANICA",
          "106",
          "",
          "200.0",
          "179.0",
          "3680.0",
          "3624.0",
          "88.0",
          "74.0",
          "1883.0",
          "1980.0",
          "175.0",
          "167.0",
          "2465.0",
          "2392.0",
          "145.0",
          "118.0",
          "2192.0",
          "2124.0",
          "148.0",
          "130.0",
          "2262.0",
          "2137.0",
          "141.0",
          "146.0",
          "2857.0",
          "2648.0",
          "269.0",
          "247.0",
          "3517.0",
          "3429.0",
          "226.0",
          "200.0",
          "3393.0",
          "3266.0",
          "239.0",
          "199.0",
          "3291.0",
          "3099.0",
          "269.0",
          "247.0",
          "3333.0",
          "3410.0",
          "226.0",
          "200.0",
          "3227.0",
          "3148.0",
          "241.0",
          "196.0",
          "3136.0",
          "2938.0",
          "161.0",
          "155.0",
          "1864.0",
          "1774.0",
          "136.0",
          "111.0",
          "1773.0",
          "1711.0",
          "284.0",
          "243.0",
          "3048.0",
          "2964.0",
          "252.0",
          "215.0",
          "2075.0",
          "1949.0",
          "191.0",
          "163.0",
          "3006.0",
          "2861.0",
          "5228.0",
          "4712.0",
          "7489.0",
          "6861.0",
          "7292.0",
          "6548.0",
          "3973.0",
          "3743.0"
        ],
        [
          "wqmPoqfG93D",
          "CABO DELGADO",
          "102",
          "",
          "1117.0",
          "1232.0",
          "4398.0",
          "4598.0",
          "158.0",
          "180.0",
          "1417.0",
          "1429.0",
          "273.0",
          "254.0",
          "1414.0",
          "1426.0",
          "237.0",
          "271.0",
          "1471.0",
          "1407.0",
          "233.0",
          "265.0",
          "1352.0",
          "1211.0",
          "211.0",
          "231.0",
          "1756.0",
          "1780.0",
          "1065.0",
          "1234.0",
          "3555.0",
          "3630.0",
          "1110.0",
          "1168.0",
          "3594.0",
          "3419.0",
          "1166.0",
          "1214.0",
          "3189.0",
          "3176.0",
          "828.0",
          "923.0",
          "3023.0",
          "2972.0",
          "883.0",
          "941.0",
          "2855.0",
          "2872.0",
          "985.0",
          "934.0",
          "2622.0",
          "2572.0",
          "952.0",
          "1191.0",
          "3336.0",
          "3384.0",
          "899.0",
          "877.0",
          "2938.0",
          "2932.0",
          "1197.0",
          "1282.0",
          "2910.0",
          "2914.0",
          "813.0",
          "820.0",
          "1544.0",
          "1505.0",
          "999.0",
          "1053.0",
          "2578.0",
          "2449.0",
          "3394.0",
          "3125.0",
          "9523.0",
          "8876.0",
          "7789.0",
          "7226.0",
          "8863.0",
          "7649.0"
        ],
        [
          "IvsKEydqOUT",
          "MAPUTO PROVINCIA",
          "110",
          "",
          "",
          "",
          "1512.0",
          "1588.0",
          "",
          "",
          "1494.0",
          "1572.0",
          "",
          "1.0",
          "2113.0",
          "2094.0",
          "3.0",
          "",
          "2177.0",
          "2195.0",
          "3.0",
          "1.0",
          "2186.0",
          "2240.0",
          "3.0",
          "1.0",
          "2210.0",
          "2238.0",
          "",
          "1.0",
          "2107.0",
          "2104.0",
          "3.0",
          "",
          "2180.0",
          "2200.0",
          "3.0",
          "1.0",
          "2185.0",
          "2241.0",
          "",
          "1.0",
          "2113.0",
          "2104.0",
          "3.0",
          "",
          "2178.0",
          "2200.0",
          "1.0",
          "",
          "2185.0",
          "2241.0",
          "",
          "1.0",
          "2146.0",
          "2094.0",
          "3.0",
          "",
          "2161.0",
          "2169.0",
          "4.0",
          "4.0",
          "2158.0",
          "2136.0",
          "3.0",
          "4.0",
          "1355.0",
          "1409.0",
          "4.0",
          "5.0",
          "2015.0",
          "1991.0",
          "4208.0",
          "4430.0",
          "4212.0",
          "4430.0",
          "4218.0",
          "4427.0",
          "4241.0",
          "4333.0"
        ],
        [
          "UN0aH8CjbZJ",
          "SOFALA",
          "107",
          "",
          "169.0",
          "168.0",
          "3522.0",
          "3403.0",
          "51.0",
          "41.0",
          "2289.0",
          "2204.0",
          "96.0",
          "93.0",
          "2836.0",
          "2841.0",
          "103.0",
          "79.0",
          "2392.0",
          "2349.0",
          "108.0",
          "103.0",
          "2066.0",
          "1982.0",
          "117.0",
          "118.0",
          "1518.0",
          "1424.0",
          "225.0",
          "205.0",
          "3701.0",
          "3692.0",
          "175.0",
          "156.0",
          "3571.0",
          "3417.0",
          "221.0",
          "224.0",
          "3263.0",
          "3155.0",
          "213.0",
          "190.0",
          "3703.0",
          "3641.0",
          "171.0",
          "139.0",
          "3612.0",
          "3427.0",
          "221.0",
          "213.0",
          "3276.0",
          "3140.0",
          "200.0",
          "181.0",
          "3537.0",
          "3507.0",
          "154.0",
          "130.0",
          "3476.0",
          "3314.0",
          "235.0",
          "213.0",
          "3065.0",
          "2930.0",
          "172.0",
          "168.0",
          "1949.0",
          "1930.0",
          "197.0",
          "178.0",
          "2643.0",
          "2510.0",
          "5879.0",
          "4278.0",
          "7835.0",
          "6898.0",
          "7755.0",
          "6880.0",
          "7425.0",
          "7074.0"
        ],
        [
          "sIPZ84RBqMM",
          "INHAMBANE",
          "108",
          "",
          "70.0",
          "84.0",
          "2461.0",
          "2335.0",
          "67.0",
          "73.0",
          "2436.0",
          "2321.0",
          "199.0",
          "191.0",
          "2628.0",
          "2545.0",
          "142.0",
          "136.0",
          "2456.0",
          "2426.0",
          "164.0",
          "164.0",
          "2339.0",
          "2351.0",
          "147.0",
          "141.0",
          "2293.0",
          "2284.0",
          "204.0",
          "215.0",
          "2627.0",
          "2540.0",
          "142.0",
          "136.0",
          "2460.0",
          "2431.0",
          "174.0",
          "164.0",
          "2469.0",
          "2351.0",
          "204.0",
          "194.0",
          "2626.0",
          "2468.0",
          "140.0",
          "137.0",
          "2475.0",
          "2435.0",
          "164.0",
          "164.0",
          "2349.0",
          "2349.0",
          "213.0",
          "194.0",
          "2629.0",
          "2543.0",
          "139.0",
          "135.0",
          "2460.0",
          "2421.0",
          "195.0",
          "187.0",
          "2287.0",
          "2245.0",
          "201.0",
          "204.0",
          "1965.0",
          "1929.0",
          "183.0",
          "168.0",
          "2285.0",
          "2260.0",
          "5563.0",
          "5018.0",
          "5586.0",
          "5158.0",
          "5492.0",
          "5026.0",
          "5579.0",
          "5155.0"
        ],
        [
          "LJX5GuypkKy",
          "MOÇAMBIQUE",
          "1",
          "",
          "3024.0",
          "3048.0",
          "46024.0",
          "45313.0",
          "1005.0",
          "999.0",
          "30261.0",
          "29025.0",
          "1758.0",
          "1729.0",
          "32235.0",
          "31180.0",
          "1610.0",
          "1482.0",
          "29514.0",
          "28905.0",
          "1830.0",
          "1802.0",
          "28198.0",
          "27541.0",
          "1499.0",
          "1477.0",
          "26282.0",
          "25800.0",
          "3434.0",
          "3542.0",
          "43362.0",
          "42411.0",
          "3524.0",
          "3138.0",
          "41080.0",
          "39555.0",
          "3675.0",
          "3606.0",
          "38832.0",
          "37977.0",
          "3184.0",
          "3191.0",
          "42150.0",
          "41124.0",
          "3038.0",
          "2915.0",
          "39880.0",
          "38644.0",
          "3485.0",
          "3301.0",
          "37819.0",
          "36969.0",
          "3081.0",
          "3259.0",
          "40264.0",
          "39370.0",
          "2821.0",
          "2645.0",
          "37010.0",
          "35936.0",
          "4440.0",
          "4230.0",
          "37742.0",
          "36554.0",
          "2926.0",
          "2865.0",
          "22261.0",
          "21885.0",
          "3927.0",
          "3651.0",
          "34905.0",
          "33687.0",
          "67348.0",
          "59854.0",
          "93345.0",
          "84785.0",
          "90229.0",
          "82264.0",
          "86009.0",
          "78445.0"
        ]
      ],
      "width": 80,
      "height": 12
    }

This is also a lot of information that needs to be formatted for each province in Mozambique. We will need to adjust the JSON to make more sense of it before we store it in the database. Ultimately, the JSON looks something like this for the Niassa Province. In this table, we sum all of the IDs that have the same value before the dot. So, to get the BCG Realizado value, we add the highlighted cells to get 8566. We then get the coverage percentage by dividing that number by the monthly population estimate for Gr. Alvo 4% from the other query (8566/5964)*100=144%

Indicator DescriptionIDNiassa value
PAV - BCG 0 - 11 meses, Brigada Móvel, FEMININOi7VbzJ0W5qT.AZq6AqCYSfD150
PAV - BCG 0 - 11 meses, Brigada Móvel, MASCULINOi7VbzJ0W5qT.UYnV8StRNy3170
PAV - BCG 0 - 11 meses, Posto Fixo, FEMININOi7VbzJ0W5qT.qaZHEHPHk6R4199
PAV - BCG 0 - 11 meses, Posto Fixo, MASCULINOi7VbzJ0W5qT.mVw0xixOoBU4047
PAV - Polio primario 0 - 11 meses, Brigada Móvel, FEMININOytweIW4mUYf.AZq6AqCYSfD134
PAV - Polio primario 0 - 11 meses, Brigada Móvel, MASCULINOytweIW4mUYf.UYnV8StRNy3151
PAV - Polio primario 0 - 11 meses, Posto Fixo, FEMININOytweIW4mUYf.qaZHEHPHk6R3984
PAV - Polio primario 0 - 11 meses, Posto Fixo, MASCULINOytweIW4mUYf.mVw0xixOoBU3796
PAV - Polio 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININORBKSa3oUTg2.AZq6AqCYSfD359
PAV - Polio 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINORBKSa3oUTg2.UYnV8StRNy3379
PAV - Polio 1ª Dose 0 - 11 meses, Posto Fixo, FEMININORBKSa3oUTg2.qaZHEHPHk6R3222
PAV - Polio 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINORBKSa3oUTg2.mVw0xixOoBU3040
PAV - Polio 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININOrLHCtgEQdnq.AZq6AqCYSfD346
PAV - Polio 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINOrLHCtgEQdnq.UYnV8StRNy3299
PAV - Polio 2ª Dose 0 - 11 meses, Posto Fixo, FEMININOrLHCtgEQdnq.qaZHEHPHk6R2813
PAV - Polio 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINOrLHCtgEQdnq.mVw0xixOoBU2799
PAV - Polio 3ª Dose 0 - 11 meses, Brigada Móvel, FEMININOxw1x5f1HfOd.AZq6AqCYSfD495
PAV - Polio 3ª Dose 0 - 11 meses, Brigada Móvel, MASCULINOxw1x5f1HfOd.UYnV8StRNy3543
PAV - Polio 3ª Dose 0 - 11 meses, Posto Fixo, FEMININOxw1x5f1HfOd.qaZHEHPHk6R2617
PAV - Polio 3ª Dose 0 - 11 meses, Posto Fixo, MASCULINOxw1x5f1HfOd.mVw0xixOoBU2633
PAV - IPV 0 - 11 meses, Brigada Móvel, FEMININOBPghXJ1HK64.AZq6AqCYSfD329
PAV - IPV 0 - 11 meses, Brigada Móvel, MASCULINOBPghXJ1HK64.UYnV8StRNy3363
PAV - IPV 0 - 11 meses, Posto Fixo, FEMININOBPghXJ1HK64.qaZHEHPHk6R2154
PAV - IPV 0 - 11 meses, Posto Fixo, MASCULINOBPghXJ1HK64.mVw0xixOoBU2208
PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININOFeeXwOEJcGz.AZq6AqCYSfD341
PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINOFeeXwOEJcGz.UYnV8StRNy3361
PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Posto Fixo, FEMININOFeeXwOEJcGz.qaZHEHPHk6R3228
PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINOFeeXwOEJcGz.mVw0xixOoBU3078
PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININOS3ReXW7kbv3.AZq6AqCYSfD639
PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINOS3ReXW7kbv3.UYnV8StRNy3295
PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Posto Fixo, FEMININOS3ReXW7kbv3.qaZHEHPHk6R2866
PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINOS3ReXW7kbv3.mVw0xixOoBU2839
PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Brigada Móvel, FEMININORtYn2iXsvPM.AZq6AqCYSfD495
PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Brigada Móvel, MASCULINORtYn2iXsvPM.UYnV8StRNy3535
PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Posto Fixo, FEMININORtYn2iXsvPM.qaZHEHPHk6R2664
PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Posto Fixo, MASCULINORtYn2iXsvPM.mVw0xixOoBU2670
PAV - PCV 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININOBMRTt5gbU85.AZq6AqCYSfD341
PAV - PCV 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINOBMRTt5gbU85.UYnV8StRNy3362
PAV - PCV 1ª Dose 0 - 11 meses, Posto Fixo, FEMININOBMRTt5gbU85.qaZHEHPHk6R3227
PAV - PCV 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINOBMRTt5gbU85.mVw0xixOoBU3057
PAV - PCV 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININOhLvZXyEZUIc.AZq6AqCYSfD343
PAV - PCV 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINOhLvZXyEZUIc.UYnV8StRNy3295
PAV - PCV 2ª Dose 0 - 11 meses, Posto Fixo, FEMININOhLvZXyEZUIc.qaZHEHPHk6R2846
PAV - PCV 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINOhLvZXyEZUIc.mVw0xixOoBU2819
PAV - PCV 3ª Dose 0 - 11 meses, Brigada Móvel, FEMININOEckOKVrmvEX.AZq6AqCYSfD487
PAV - PCV 3ª Dose 0 - 11 meses, Brigada Móvel, MASCULINOEckOKVrmvEX.UYnV8StRNy3535
PAV - PCV 3ª Dose 0 - 11 meses, Posto Fixo, FEMININOEckOKVrmvEX.qaZHEHPHk6R2647
PAV - PCV 3ª Dose 0 - 11 meses, Posto Fixo, MASCULINOEckOKVrmvEX.mVw0xixOoBU2663
PAV - RV 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININOx2nuUb4JmDs.AZq6AqCYSfD325
PAV - RV 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINOx2nuUb4JmDs.UYnV8StRNy3336
PAV - RV 1ª Dose 0 - 11 meses, Posto Fixo, FEMININOx2nuUb4JmDs.qaZHEHPHk6R3207
PAV - RV 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINOx2nuUb4JmDs.mVw0xixOoBU3038
PAV - RV 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININOKWqwoZZXT99.AZq6AqCYSfD331
PAV - RV 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINOKWqwoZZXT99.UYnV8StRNy3280
PAV - RV 2ª Dose 0 - 11 meses, Posto Fixo, FEMININOKWqwoZZXT99.qaZHEHPHk6R2787
PAV - RV 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINOKWqwoZZXT99.mVw0xixOoBU2768
PAV - Sarampo 0 - 11 meses, Brigada Móvel, FEMININOKAT4V8gyIIo.AZq6AqCYSfD994
PAV - Sarampo 0 - 11 meses, Brigada Móvel, MASCULINOKAT4V8gyIIo.UYnV8StRNy3794
PAV - Sarampo 0 - 11 meses, Posto Fixo, FEMININOKAT4V8gyIIo.qaZHEHPHk6R2709
PAV - Sarampo 0 - 11 meses, Posto Fixo, MASCULINOKAT4V8gyIIo.mVw0xixOoBU2665
PAV - Sarampo-Rubéola 18-23 meses, Brigada Móvel, FEMININOE99RDvLYuvZ.cBMku288XIu349
PAV - Sarampo-Rubéola 18-23 meses, Brigada Móvel, MASCULINOE99RDvLYuvZ.Jp1mSZfd94e365
PAV - Sarampo-Rubéola 18-23 meses, Posto Fixo, FEMININOE99RDvLYuvZ.dXjAUcOo5Ms1363
PAV - Sarampo-Rubéola 18-23 meses, Posto Fixo, MASCULINOE99RDvLYuvZ.i7oAiY0OoKb1391
PAV - Crianças Completamente Vacinadas Brigada Móvel, FEMININOwZEOgPMvciS.An0ixEtkvD0951
PAV - Crianças Completamente Vacinadas Brigada Móvel, MASCULINOwZEOgPMvciS.Vl5SozUWrQB774
PAV - Crianças Completamente Vacinadas Posto Fixo, FEMININOwZEOgPMvciS.wtVP85udKGT2655
PAV - Crianças Completamente Vacinadas Posto Fixo, MASCULINOwZEOgPMvciS.ZHITxfjkOUz2574
PAV - Polio 1ª DoseRBKSa3oUTg27003
PAV - Polio 3ª Dosexw1x5f1HfOd6297
PAV - DPT-HepB+Hib 1ª DoseFeeXwOEJcGz7010
PAV - DPT-HepB+Hib 3ª DoseRtYn2iXsvPM6379
PAV - PCV 1ª DoseBMRTt5gbU856989
PAV - PCV 3ª DoseEckOKVrmvEX6353
PAV - RV 1ª Dosex2nuUb4JmDs6906
PAV - RV 2ª DoseKWqwoZZXT996169

In order to get these values, we will need to modify the JSON so it's easier to store in the database table. I don't know if we want to do the calculations in Nifi, the database or Superset.

Note: I have not yet figured out the "Indíce de Quebra Vacinal" Vaccine breakage index


The DHIS-2 API expects individual districts to be identified by the codes contained within Districts Codes.xlsx.

Related content

DHIS2 OpenLMIS COVID Teams collaboration-June 18, 2020
DHIS2 OpenLMIS COVID Teams collaboration-June 18, 2020
More like this
2018 DHIS2 Symposium
2018 DHIS2 Symposium
More like this
2018-06-13 Weekly Check-in
2018-06-13 Weekly Check-in
More like this
DHIS2 Integration Software Requirements Specification
DHIS2 Integration Software Requirements Specification
More like this
Alternate Approaches to the DHIS2 Integration
Alternate Approaches to the DHIS2 Integration
More like this
Reporting and Analytics
Reporting and Analytics
More like this