Membership

A person Person or an organization Organization can be a member (Member union) of any organization.

People with positions in an organization

The relationship between a person and an organization is described by nodes in the following order:

Person is a person.
Membership is membership information, such as the format or period.
Post is a position in that organization.
Organization is an organization.

For example, if we want to know what positions Chuan Leekpai has held in which organizations.

Membership

Organization

Person

Post

Person

บุคคลที่เกี่ยวข้องทางการเมือง เช่น สมาชิกสภา สมาชิกพรรคการเมือง ฯลฯ

id: 891ea463-c463-4f76-840d-e7d24a97d70c
name_en: Chuan Leekpai
memberships:
- 24/3/62 - now
- บัญชีรายชื่อ
- บัญชีรายชื่อ

*Only showing nodes, properties, and relationships from the query see full schema

query People($where: PersonWhere) {
  people(where: $where) {
    id
    name_en
    memberships {
      id
      label
      start_date
      end_date
      posts {
        id
        label
        organizations {
          id
          name_en
          name
          classification
        }
      }
    }
  }
}

{
  "where": {
    "firstname_en_EQ": "Chuan",
    "lastname_en_EQ": "Leekpai"
  }
}

{
  "data": {
    "people": [
      {
        "__typename": "Person",
        "id": "891ea463-c463-4f76-840d-e7d24a97d70c",
        "name_en": "Chuan Leekpai",
        "memberships": [
          {
            "__typename": "Membership",
            "id": "49ac0932-a805-4e38-ae74-3777a8a49507",
            "label": null,
            "start_date": "2019-03-24",
            "end_date": null,
            "posts": [
              {
                "__typename": "Post",
                "id": "4d16d129-482a-46f2-b60f-0a90abd7433d",
                "label": "สมาชิกพรรคประชาธิปัตย์",
                "organizations": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคประชาธิปัตย์",
                    "name_en": null,
                    "name": "ประชาธิปัตย์",
                    "classification": "POLITICAL_PARTY"
                  }
                ]
              }
            ]
          },
          {
            "__typename": "Membership",
            "id": "d71562c1-ac21-4f24-ad69-2af9188d5e66",
            "label": "บัญชีรายชื่อ",
            "start_date": "2019-03-24",
            "end_date": "2023-03-24",
            "posts": [
              {
                "__typename": "Post",
                "id": "cb3aad93-a9bb-44da-80ad-c46a8ca1f60c",
                "label": "ประธาน สส. ชุดที่ 25",
                "organizations": [
                  {
                    "__typename": "Organization",
                    "id": "สภาผู้แทนราษฎร-25",
                    "name_en": "The 25th House of Representatives",
                    "name": "สภาผู้แทนราษฎร ชุดที่ 25",
                    "classification": "HOUSE_OF_REPRESENTATIVE"
                  }
                ]
              }
            ]
          },
          {
            "__typename": "Membership",
            "id": "cd9798ff-cb86-4527-901a-744f5718be21",
            "label": "บัญชีรายชื่อ",
            "start_date": "2023-05-24",
            "end_date": "2025-12-12",
            "posts": [
              {
                "__typename": "Post",
                "id": "4b7eb105-86f5-4e61-b958-c2f18a4410a0",
                "label": "สส. ชุดที่ 26",
                "organizations": [
                  {
                    "__typename": "Organization",
                    "id": "สภาผู้แทนราษฎร-26",
                    "name_en": "The 26th House of Representatives",
                    "name": "สภาผู้แทนราษฎร ชุดที่ 26",
                    "classification": "HOUSE_OF_REPRESENTATIVE"
                  }
                ]
              }
            ]
          }
        ]
      }
    ]
  }
}

Because the graph database connects all nodes, we can start a query from any node. For example, if we want to know who has ever held the position of leader of the Pheu Thai Party, we can start the query from Post.

Membership

Organization

Person

Post

ตำแหน่งในองค์กร เช่น ประธานสภา หัวหน้าพรรค ฯลฯ

id: 35612073-9dc0-49ee-bb7b-f0c4ff66f64b
label: หัวหน้าพรรคเพื่อไทย
role: หัวหน้าพรรคการเมือง
organizations:
- เพื่อไทย
memberships:
- 12/7/62 - 28/10/64
- 28/10/64 - 30/8/66

*Only showing nodes, properties, and relationships from the query see full schema

query Posts($where: PostWhere) {
  posts(where: $where) {
    id
    label
    role
    organizations {
      id
      name_en
      name
    }
    memberships {
      id
      start_date
      end_date
      members {
        ... on Person {
          id
          name_en
        }
      }
    }
  }
}

{
  "where": {
    "role_EQ": "หัวหน้าพรรคการเมือง",
    "organizations_SOME": {
      "id_EQ": "พรรคเพื่อไทย"
    }
  }
}

{
  "data": {
    "posts": [
      {
        "__typename": "Post",
        "id": "35612073-9dc0-49ee-bb7b-f0c4ff66f64b",
        "label": "หัวหน้าพรรคเพื่อไทย",
        "role": "หัวหน้าพรรคการเมือง",
        "organizations": [
          {
            "__typename": "Organization",
            "id": "พรรคเพื่อไทย",
            "name_en": null,
            "name": "เพื่อไทย"
          }
        ],
        "memberships": [
          {
            "__typename": "Membership",
            "id": "abd82049-53a1-4d1f-b953-a96daedc2bcf",
            "start_date": "2019-07-12",
            "end_date": "2021-10-28",
            "members": [
              {
                "__typename": "Person",
                "id": "fd1eb9bc-ca89-4e38-a6ba-35c93356de89",
                "name_en": "Sompong Amornvivat"
              }
            ]
          },
          {
            "__typename": "Membership",
            "id": "ae6bfbb2-c855-4ed4-a80f-8ba1e854fe24",
            "start_date": "2021-10-28",
            "end_date": "2023-08-30",
            "members": [
              {
                "__typename": "Person",
                "id": "d2e1d82e-75e2-471e-b3c5-d977bc51f395",
                "name_en": "Cholnan Srikaew"
              }
            ]
          }
        ]
      }
    ]
  }
}

Government and Opposition parties

We model “Government parties (พรรคฝ่ายรัฐบาล)” and “Opposition parties (พรรคฝ่ายค้าน)” as a Post in the cabinet organization.

Membership

Organization

Post

Organization

องค์กรที่เกี่ยวข้องทางการเมือง เช่น สส. สว. ครม. พรรคการเมือง ฯลฯ

id: คณะรัฐมนตรี-63
name_en: The 63th Cabinet
posts:
- พรรคฝ่ายค้าน ครม. คณะที่ 63
- พรรคฝ่ายรัฐบาล ครม. คณะที่ 63

*Only showing nodes, properties, and relationships from the query see full schema

query Organizations($where: OrganizationWhere, $postsWhere2: PostWhere) {
  organizations(where: $where) {
    id
    name_en
    posts(where: $postsWhere2) {
      id
      label
      role
      memberships {
        id
        start_date
        end_date
        members {
          ... on Organization {
            id
            name
          }
        }
      }
    }
  }
}

{
  "where": {
    "id_EQ": "คณะรัฐมนตรี-63"
  },
  "postsWhere2": {
    "role_STARTS_WITH": "พรรคฝ่าย"
  }
}

{
  "data": {
    "organizations": [
      {
        "__typename": "Organization",
        "id": "คณะรัฐมนตรี-63",
        "name_en": "The 63th Cabinet",
        "posts": [
          {
            "__typename": "Post",
            "id": "1d4876ef-da4f-4e3d-bae3-e845c940b1c7",
            "label": "พรรคฝ่ายรัฐบาล ครม. คณะที่ 63",
            "role": "พรรคฝ่ายรัฐบาล",
            "memberships": [
              {
                "__typename": "Membership",
                "id": "317f6ca4-0589-4291-9f07-9f6e4741ea85",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคท้องที่ไทย",
                    "name": "ท้องที่ไทย"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "7d9321a9-f04d-4e8e-85b3-5362656f8804",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคพลังสังคมใหม่",
                    "name": "พลังสังคมใหม่"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "76b95f24-47f8-4665-aae1-77e8a6fb17d4",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคเสรีรวมไทย",
                    "name": "เสรีรวมไทย"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "69175fe0-375b-46b1-aea2-8780282ff70b",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคเพื่อไทรวมพลัง",
                    "name": "เพื่อไทรวมพลัง"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "951a8e99-becd-4019-9ccc-ea6a86dd4a05",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคชาติพัฒนากล้า",
                    "name": "ชาติพัฒนากล้า"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "b003bb12-48be-41d1-9113-b19e5d19a6ca",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคประชาชาติ",
                    "name": "ประชาชาติ"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "750aeba6-d7d0-47eb-bca7-707c66107293",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคชาติไทยพัฒนา",
                    "name": "ชาติไทยพัฒนา"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "340b39b2-bd98-4537-a607-21ba98fc5f5b",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรครวมไทยสร้างชาติ",
                    "name": "รวมไทยสร้างชาติ"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "e777bf15-2adf-47f7-9623-ff8b3bd91cbb",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคพลังประชารัฐ",
                    "name": "พลังประชารัฐ"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "f16e7613-0e36-40b0-81e6-77f6ff2764e2",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคภูมิใจไทย",
                    "name": "ภูมิใจไทย"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "01c39bed-9aea-4452-bbda-d3834920bf35",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคเพื่อไทย",
                    "name": "เพื่อไทย"
                  }
                ]
              }
            ]
          },
          {
            "__typename": "Post",
            "id": "123850e1-04e2-434c-84f6-9cf85e0fbe32",
            "label": "พรรคฝ่ายค้าน ครม. คณะที่ 63",
            "role": "พรรคฝ่ายค้าน",
            "memberships": [
              {
                "__typename": "Membership",
                "id": "09f2dbc1-c4fc-49bb-9aa6-3e938f42f8df",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคไทยก้าวหน้า",
                    "name": "ไทยก้าวหน้า"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "8f5e0cd1-aa10-4a97-ab03-3469c149f829",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคครูไทยเพื่อประชาชน",
                    "name": "ครูไทยเพื่อประชาชน"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "919267c6-a355-4d3a-a7a1-fad3fbe7587e",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคประชาธิปไตยใหม่",
                    "name": "ประชาธิปไตยใหม่"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "4e3abbaf-32e8-4c05-bd34-c9483780b98c",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคใหม่",
                    "name": "ใหม่"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "3c997716-32fb-41ab-94e6-0c43cb29fb12",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคเป็นธรรม",
                    "name": "เป็นธรรม"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "0bfed6cc-a6d4-4213-aee6-11ae82dd9344",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคไทยสร้างไทย",
                    "name": "ไทยสร้างไทย"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "aa859c03-5fa0-4636-a40f-85749c1f57b0",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคประชาธิปัตย์",
                    "name": "ประชาธิปัตย์"
                  }
                ]
              },
              {
                "__typename": "Membership",
                "id": "9a0bdaa8-caac-41da-bf66-1d7382ef4549",
                "start_date": "2023-09-01",
                "end_date": "2024-08-14",
                "members": [
                  {
                    "__typename": "Organization",
                    "id": "พรรคก้าวไกล",
                    "name": "ก้าวไกล"
                  }
                ]
              }
            ]
          }
        ]
      }
    ]
  }
}