Question about Inconsistent use of role in Posts under Fifth Cabinet of Najib Razak

Inconsistent use of role in Posts:

Are Deputy Ministers given "Minister" role; or "Deputy Minister" role?
Ministers under PMO are given "Ministers" role; shouldn't it be "Minister"?
Most role are null; is this correct

[
  {
    "post_id": "55b734577070042c250b332e",
    "label": "Deputy Minister in the Prime Minister's Department",
    "role": null
  },
  {
    "post_id": "55b749d87070042c250c412d",
    "label": "Deputy Minister of Agriculture and Agro-Based Industry",
    "role": null
  },
  {
    "post_id": "55b75b65ed2606a46a89c503",
    "label": "Deputy Minister of Communications and Multimedia",
    "role": null
  },
  {
    "post_id": "55b7373866d0d137274dee07",
    "label": "Deputy Minister of Defence",
    "role": null
  },
  {
    "post_id": "55b75819222b329d5ce5f94d",
    "label": "Deputy Minister of Domestic Trade, Co-operatives and Consumerism",
    "role": null
  },
  {
    "post_id": "55b75a35222b329d5ce62cbd",
    "label": "Deputy Minister of Education",
    "role": null
  },
  {
    "post_id": "55b7456366d0d137274e56f5",
    "label": "Deputy Minister of Energy, Green Technology and Water",
    "role": null
  },
  {
    "post_id": "55b754becf2b56b826ef3e0f",
    "label": "Deputy Minister of Federal Territories",
    "role": null
  },
  {
    "post_id": "55b7348e69b3d487259489da",
    "label": "Deputy Minister of Finance",
    "role": null
  },
  {
    "post_id": "55b72f2469b3d48725943407",
    "label": "Deputy Minister of Foreign Affairs",
    "role": null
  },
  {
    "post_id": "55b7367c7070042c250b6daa",
    "label": "Deputy Minister of Health",
    "role": null
  },
  {
    "post_id": "55b755a7a19ec9ce5a550355",
    "label": "Deputy Minister of Higher Education",
    "role": null
  },
  {
    "post_id": "55b735257070042c250b62dd",
    "label": "Deputy Minister of Home Affairs",
    "role": null
  },
  {
    "post_id": "55b75324c4705304262e17bc",
    "label": "Deputy Minister of Human Resources",
    "role": null
  },
  {
    "post_id": "55b744f9c4705304262dc62d",
    "label": "Deputy Minister of International Trade and industry",
    "role": null
  },
  {
    "post_id": "55b7595eed2606a46a89c4f7",
    "label": "Deputy Minister of Natural Resources and Environment",
    "role": null
  },
  {
    "post_id": "55b745d8c4705304262dc638",
    "label": "Deputy Minister of Plantation Industries and Commodities",
    "role": null
  },
  {
    "post_id": "55b74c3566d0d137274e9370",
    "label": "Deputy Minister of Rural and Regional Development",
    "role": null
  },
  {
    "post_id": "55b74f2b69b3d48725954700",
    "label": "Deputy Minister of Science, Technology and Innovation",
    "role": null
  },
  {
    "post_id": "55b7370269b3d48725949685",
    "label": "Deputy Minister of Tourism and Culture",
    "role": null
  },
  {
    "post_id": "55b7360c7070042c250b6a0e",
    "label": "Deputy Minister of Transport",
    "role": null
  },
  {
    "post_id": "55b7575c027b3e0d5d28f54d",
    "label": "Deputy Minister of Urban Wellbeing, Housing and Local Government",
    "role": null
  },
  {
    "post_id": "55b74fc47070042c250c7862",
    "label": "Deputy Minister of Women, Family and Community Development",
    "role": null
  },
  {
    "post_id": "55b7523466d0d137274ebf0d",
    "label": "Deputy Minister of Works",
    "role": null
  },
  {
    "post_id": "55b7564d1527fde65b033d34",
    "label": "Deputy Minister of Youth and Sports",
    "role": null
  },
  {
    "post_id": "55b7287a9a3fd0026f667a66",
    "label": "Deputy Prime Minister",
    "role": "Minister"
  },
  {
    "post_id": "55b746c369b3d48725950a7b",
    "label": "Minister of Agriculture and Agro-Based Industry",
    "role": null
  },
  {
    "post_id": "55b75aed1527fde65b035d85",
    "label": "Minister of Communications and Multimedia",
    "role": null
  },
  {
    "post_id": "55b731b969b3d4872594537b",
    "label": "Minister of Defense",
    "role": null
  },
  {
    "post_id": "55b757ac222b329d5ce5f8c9",
    "label": "Minister of Domestic Trade, Co-operatives and Consumerism",
    "role": null
  },
  {
    "post_id": "55b759a7ed2606a46a89c500",
    "label": "Minister of Education",
    "role": null
  },
  {
    "post_id": "55b733087070042c250b2fa3",
    "label": "Minister of Energy, Green Technology and Water",
    "role": null
  },
  {
    "post_id": "55b7546d69b3d48725956b9b",
    "label": "Minister of Federal Territories",
    "role": null
  },
  {
    "post_id": "55b74b2169b3d48725952e00",
    "label": "Minister of Finance",
    "role": null
  },
  {
    "post_id": "55b72ee269b3d4872594202a",
    "label": "Minister of Finance II",
    "role": null
  },
  {
    "post_id": "55b72f267070042c250afb3d",
    "label": "Minister of Foreign Affairs",
    "role": null
  },
  {
    "post_id": "55b72e1669b3d48725942014",
    "label": "Minister of Health",
    "role": null
  },
  {
    "post_id": "55b7553bcf2b56b826ef3e13",
    "label": "Minister of Higher Education",
    "role": null
  },
  {
    "post_id": "55b74ad169b3d48725952df5",
    "label": "Minister of Home Affairs",
    "role": null
  },
  {
    "post_id": "55b7527366d0d137274ebf17",
    "label": "Minister of Human Resources",
    "role": null
  },
  {
    "post_id": "55b7321369b3d487259479b5",
    "label": "Minister of International Trade and Industry",
    "role": null
  },
  {
    "post_id": "55b7329669b3d4872594869c",
    "label": "Minister of International Trade and Industry II",
    "role": null
  },
  {
    "post_id": "55b758e9222b329d5ce6228c",
    "label": "Minister of Natural Resources and Environment",
    "role": null
  },
  {
    "post_id": "55b7460dc4705304262dc639",
    "label": "Minister of Plantation Industries and Commodities",
    "role": null
  },
  {
    "post_id": "55b74bf2cf2b56b826eef112",
    "label": "Minister of Rural and Regional Development",
    "role": null
  },
  {
    "post_id": "55b74e9bcf2b56b826ef1e5b",
    "label": "Minister of Science, Technology and Innovation",
    "role": null
  },
  {
    "post_id": "55b7315e69b3d48725945370",
    "label": "Minister of Tourism and Culture",
    "role": null
  },
  {
    "post_id": "55b72a492f71d383700765a4",
    "label": "Minister of Transport",
    "role": null
  },
  {
    "post_id": "55b756e91527fde65b033d35",
    "label": "Minister of Urban Wellbeing, Housing and Local Government",
    "role": null
  },
  {
    "post_id": "55b74f78cf2b56b826ef1e71",
    "label": "Minister of Women, Family and Community Development",
    "role": null
  },
  {
    "post_id": "55b750ac69b3d487259560e2",
    "label": "Minister of Works",
    "role": null
  },
  {
    "post_id": "55b75601222b329d5ce5f26a",
    "label": "Minister of Youth and Sports",
    "role": null
  },
  {
    "post_id": "55b72903869c13f57048ca7e",
    "label": "Ministers in the Prime Minister's Department",
    "role": "Ministers"
  },
  {
    "post_id": "55b7285a916cff2b6d55ae92",
    "label": "Prime Minister",
    "role": "Minister"
  }
]

AQL to extract "Fifth Cabinet of Najib Razak"; with post_id added for convenience:

FOR o IN organizations
    FILTER o.data.classification == "cabinet"
    FILTER LIKE(LOWER(o.data.name), "%fifth%")
    COLLECT posts = o.data.posts
    FOR p IN posts
        // FILTER p.role == null
        // FILTER p.role != null
        // FILTER p.label == null
        // FILTER p.label != null
        SORT p.label
        RETURN { 
            post_id: p.id,
            label: p.label,
            role: p.role
        }

Sinar / popit_ng

Question about Inconsistent use of role in Posts under Fifth Cabinet of Najib Razak #160