Get percentages from the COBERTURAS PAV (Mensal) report
This is the first report that was outlined by Timoteo:
- The coverage report “PAV Coberturas (Mensal)” utilizes the DHIS Web Reporting module in DHIS2 (https://docs.dhis2.org/2.28/en/user/html/using_reporting_standard_reports.html)
- It doesn’t look like we can get the report directly because it uses JasperReports to execute a number of underlying queries.
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 description | Organisation unit ID | Value from Niassa Province row | Divided by 12 to get the monthly estimate |
|---|---|---|---|
| POP - 17.1 perc População Consultas 0-4 Anos | qGeMdrJaqK6 | 305,939 | 25,495 |
| POP - 13.1 perc População Consultas 1-4 Anos | vr04MSOBMjC | 234,373 | 19,531 |
| POP - 24.9 perc População VAT MIF/ P. Familiar | uFfnh49uAZ0 | 445,493 | 37,124 |
| POP - 3.9 perc População Polio/DPT/HepB/VAS/CCV/PVC10 | uhAcJkYENXE | 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 meses | sTIec6HXB8U | 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-Parto | D1HgqDPmaow | 80,511 | 6,709 |
| POP - 5 perc População VAT Mgrav. /C.Pré-Natal | qXnAuJL2TMs | 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 Description | ID | Niassa value |
|---|---|---|
| PAV - BCG 0 - 11 meses, Brigada Móvel, FEMININO | i7VbzJ0W5qT.AZq6AqCYSfD | 150 |
| PAV - BCG 0 - 11 meses, Brigada Móvel, MASCULINO | i7VbzJ0W5qT.UYnV8StRNy3 | 170 |
| PAV - BCG 0 - 11 meses, Posto Fixo, FEMININO | i7VbzJ0W5qT.qaZHEHPHk6R | 4199 |
| PAV - BCG 0 - 11 meses, Posto Fixo, MASCULINO | i7VbzJ0W5qT.mVw0xixOoBU | 4047 |
| PAV - Polio primario 0 - 11 meses, Brigada Móvel, FEMININO | ytweIW4mUYf.AZq6AqCYSfD | 134 |
| PAV - Polio primario 0 - 11 meses, Brigada Móvel, MASCULINO | ytweIW4mUYf.UYnV8StRNy3 | 151 |
| PAV - Polio primario 0 - 11 meses, Posto Fixo, FEMININO | ytweIW4mUYf.qaZHEHPHk6R | 3984 |
| PAV - Polio primario 0 - 11 meses, Posto Fixo, MASCULINO | ytweIW4mUYf.mVw0xixOoBU | 3796 |
| PAV - Polio 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININO | RBKSa3oUTg2.AZq6AqCYSfD | 359 |
| PAV - Polio 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO | RBKSa3oUTg2.UYnV8StRNy3 | 379 |
| PAV - Polio 1ª Dose 0 - 11 meses, Posto Fixo, FEMININO | RBKSa3oUTg2.qaZHEHPHk6R | 3222 |
| PAV - Polio 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINO | RBKSa3oUTg2.mVw0xixOoBU | 3040 |
| PAV - Polio 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININO | rLHCtgEQdnq.AZq6AqCYSfD | 346 |
| PAV - Polio 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO | rLHCtgEQdnq.UYnV8StRNy3 | 299 |
| PAV - Polio 2ª Dose 0 - 11 meses, Posto Fixo, FEMININO | rLHCtgEQdnq.qaZHEHPHk6R | 2813 |
| PAV - Polio 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINO | rLHCtgEQdnq.mVw0xixOoBU | 2799 |
| PAV - Polio 3ª Dose 0 - 11 meses, Brigada Móvel, FEMININO | xw1x5f1HfOd.AZq6AqCYSfD | 495 |
| PAV - Polio 3ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO | xw1x5f1HfOd.UYnV8StRNy3 | 543 |
| PAV - Polio 3ª Dose 0 - 11 meses, Posto Fixo, FEMININO | xw1x5f1HfOd.qaZHEHPHk6R | 2617 |
| PAV - Polio 3ª Dose 0 - 11 meses, Posto Fixo, MASCULINO | xw1x5f1HfOd.mVw0xixOoBU | 2633 |
| PAV - IPV 0 - 11 meses, Brigada Móvel, FEMININO | BPghXJ1HK64.AZq6AqCYSfD | 329 |
| PAV - IPV 0 - 11 meses, Brigada Móvel, MASCULINO | BPghXJ1HK64.UYnV8StRNy3 | 363 |
| PAV - IPV 0 - 11 meses, Posto Fixo, FEMININO | BPghXJ1HK64.qaZHEHPHk6R | 2154 |
| PAV - IPV 0 - 11 meses, Posto Fixo, MASCULINO | BPghXJ1HK64.mVw0xixOoBU | 2208 |
| PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININO | FeeXwOEJcGz.AZq6AqCYSfD | 341 |
| PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO | FeeXwOEJcGz.UYnV8StRNy3 | 361 |
| PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Posto Fixo, FEMININO | FeeXwOEJcGz.qaZHEHPHk6R | 3228 |
| PAV - DPT-HepB+Hib 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINO | FeeXwOEJcGz.mVw0xixOoBU | 3078 |
| PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININO | S3ReXW7kbv3.AZq6AqCYSfD | 639 |
| PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO | S3ReXW7kbv3.UYnV8StRNy3 | 295 |
| PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Posto Fixo, FEMININO | S3ReXW7kbv3.qaZHEHPHk6R | 2866 |
| PAV - DPT-HepB+Hib 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINO | S3ReXW7kbv3.mVw0xixOoBU | 2839 |
| PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Brigada Móvel, FEMININO | RtYn2iXsvPM.AZq6AqCYSfD | 495 |
| PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO | RtYn2iXsvPM.UYnV8StRNy3 | 535 |
| PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Posto Fixo, FEMININO | RtYn2iXsvPM.qaZHEHPHk6R | 2664 |
| PAV - DPT-HepB+Hib 3ª Dose 0 - 11 meses, Posto Fixo, MASCULINO | RtYn2iXsvPM.mVw0xixOoBU | 2670 |
| PAV - PCV 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININO | BMRTt5gbU85.AZq6AqCYSfD | 341 |
| PAV - PCV 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO | BMRTt5gbU85.UYnV8StRNy3 | 362 |
| PAV - PCV 1ª Dose 0 - 11 meses, Posto Fixo, FEMININO | BMRTt5gbU85.qaZHEHPHk6R | 3227 |
| PAV - PCV 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINO | BMRTt5gbU85.mVw0xixOoBU | 3057 |
| PAV - PCV 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININO | hLvZXyEZUIc.AZq6AqCYSfD | 343 |
| PAV - PCV 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO | hLvZXyEZUIc.UYnV8StRNy3 | 295 |
| PAV - PCV 2ª Dose 0 - 11 meses, Posto Fixo, FEMININO | hLvZXyEZUIc.qaZHEHPHk6R | 2846 |
| PAV - PCV 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINO | hLvZXyEZUIc.mVw0xixOoBU | 2819 |
| PAV - PCV 3ª Dose 0 - 11 meses, Brigada Móvel, FEMININO | EckOKVrmvEX.AZq6AqCYSfD | 487 |
| PAV - PCV 3ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO | EckOKVrmvEX.UYnV8StRNy3 | 535 |
| PAV - PCV 3ª Dose 0 - 11 meses, Posto Fixo, FEMININO | EckOKVrmvEX.qaZHEHPHk6R | 2647 |
| PAV - PCV 3ª Dose 0 - 11 meses, Posto Fixo, MASCULINO | EckOKVrmvEX.mVw0xixOoBU | 2663 |
| PAV - RV 1ª Dose 0 - 11 meses, Brigada Móvel, FEMININO | x2nuUb4JmDs.AZq6AqCYSfD | 325 |
| PAV - RV 1ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO | x2nuUb4JmDs.UYnV8StRNy3 | 336 |
| PAV - RV 1ª Dose 0 - 11 meses, Posto Fixo, FEMININO | x2nuUb4JmDs.qaZHEHPHk6R | 3207 |
| PAV - RV 1ª Dose 0 - 11 meses, Posto Fixo, MASCULINO | x2nuUb4JmDs.mVw0xixOoBU | 3038 |
| PAV - RV 2ª Dose 0 - 11 meses, Brigada Móvel, FEMININO | KWqwoZZXT99.AZq6AqCYSfD | 331 |
| PAV - RV 2ª Dose 0 - 11 meses, Brigada Móvel, MASCULINO | KWqwoZZXT99.UYnV8StRNy3 | 280 |
| PAV - RV 2ª Dose 0 - 11 meses, Posto Fixo, FEMININO | KWqwoZZXT99.qaZHEHPHk6R | 2787 |
| PAV - RV 2ª Dose 0 - 11 meses, Posto Fixo, MASCULINO | KWqwoZZXT99.mVw0xixOoBU | 2768 |
| PAV - Sarampo 0 - 11 meses, Brigada Móvel, FEMININO | KAT4V8gyIIo.AZq6AqCYSfD | 994 |
| PAV - Sarampo 0 - 11 meses, Brigada Móvel, MASCULINO | KAT4V8gyIIo.UYnV8StRNy3 | 794 |
| PAV - Sarampo 0 - 11 meses, Posto Fixo, FEMININO | KAT4V8gyIIo.qaZHEHPHk6R | 2709 |
| PAV - Sarampo 0 - 11 meses, Posto Fixo, MASCULINO | KAT4V8gyIIo.mVw0xixOoBU | 2665 |
| PAV - Sarampo-Rubéola 18-23 meses, Brigada Móvel, FEMININO | E99RDvLYuvZ.cBMku288XIu | 349 |
| PAV - Sarampo-Rubéola 18-23 meses, Brigada Móvel, MASCULINO | E99RDvLYuvZ.Jp1mSZfd94e | 365 |
| PAV - Sarampo-Rubéola 18-23 meses, Posto Fixo, FEMININO | E99RDvLYuvZ.dXjAUcOo5Ms | 1363 |
| PAV - Sarampo-Rubéola 18-23 meses, Posto Fixo, MASCULINO | E99RDvLYuvZ.i7oAiY0OoKb | 1391 |
| PAV - Crianças Completamente Vacinadas Brigada Móvel, FEMININO | wZEOgPMvciS.An0ixEtkvD0 | 951 |
| PAV - Crianças Completamente Vacinadas Brigada Móvel, MASCULINO | wZEOgPMvciS.Vl5SozUWrQB | 774 |
| PAV - Crianças Completamente Vacinadas Posto Fixo, FEMININO | wZEOgPMvciS.wtVP85udKGT | 2655 |
| PAV - Crianças Completamente Vacinadas Posto Fixo, MASCULINO | wZEOgPMvciS.ZHITxfjkOUz | 2574 |
| PAV - Polio 1ª Dose | RBKSa3oUTg2 | 7003 |
| PAV - Polio 3ª Dose | xw1x5f1HfOd | 6297 |
| PAV - DPT-HepB+Hib 1ª Dose | FeeXwOEJcGz | 7010 |
| PAV - DPT-HepB+Hib 3ª Dose | RtYn2iXsvPM | 6379 |
| PAV - PCV 1ª Dose | BMRTt5gbU85 | 6989 |
| PAV - PCV 3ª Dose | EckOKVrmvEX | 6353 |
| PAV - RV 1ª Dose | x2nuUb4JmDs | 6906 |
| PAV - RV 2ª Dose | KWqwoZZXT99 | 6169 |
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