Utilities companies in Philippines

{
  "company_id": 5044407,
  "source_id": "832706",
  "company_name": "Manila Water",
  "company_name_alias": [
    "manila water",
    "manila water company, inc."
  ],
  "company_legal_name": null,
  "company_logo": "/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsK\r\nCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUFBQU\r\nFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBT/wAARCAAyADIDASIA\r\nAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA\r\nAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3\r\nODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm\r\np6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA\r\nAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx\r\nBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK\r\nU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3\r\nuLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD9U6KK\r\n4/4pfEHTfhz4UutSvtTttOmZWS0NwjSeZLjgCNSGf1wCPcgc1pTpyrTVOCu2YV69PDUpVqrtGKu3\r\nt+Z1+aht723u2lEE0cxicxyCNw2xh1U46H2NfnfrHxq8Y+Jr+Sa58Uam6FyUSGY26AZ4wkZAHHbn\r\n6mtE+PvEq2sdne6heKyyC5R5iyTKxGN2/hjkeuenFffQ4OrtLmqxu/X+n+B+L4jxRwlKUuTDScV5\r\nrX7r2/H9T9BqK+Tfh1+0dq9nrulW+u3TXmnti1uJZCMhSfkl6feUkhj/ABLjjIyfrEHIzXymZZXi\r\nMrqKFfrs1sz9F4e4kwXElCVbB3XK0mnurq6/y9UxaKKK8g+qGu4jUsxCqBkk9BX51ftbeNV8R/FK\r\nO4t9ch1bTjZQyWUVsGEdtC6hlBJ6u/LkgdCgye36KyRrKjIwDKwIIIyCK/Mj9payuPh3+0fr1/da\r\nJBqGlJPb3MNrcRsLWSF4QI4ztx8uY3XAx/qyO1fXcMuMcXKb3UXbbyPzvjenOtgIU18Lkr76b66d\r\nDmPB1za32v6fb3l8dOtZJlEl0q7jGOuQMjnjAyQMkZ4r3D4haTbeF9InFxfX1/Zz26Pp/wDaEvnS\r\nw3PmLuCyAAFGj3lhgYIAwTg145o/xX8KzWcpufC3h6ykcNH5QtbiRwGJ+ZXyQCNzY4PRR251NF+I\r\nnhi1mVm07RrmNkghEVzY3EnlCNSN4O/JL/LuHcgkYya++qV61SrGpyySj001179P8tO5+Nxy/D0c\r\nPOi5Rbn9rVW0tquv4WevRWE1Xcp57V+hfwi8aWvjrwPY39qXdYv9Ekd/43jAVmHsev41+f8AefEK\r\nz1SG40nT/D+nXUt1iKC5trVkmBbZgIuMlgVIBPJ3GvvD4BeBrn4ffC7SNLv12aiwa5ukznZJIdxT\r\n/gIwp9wa8HimrGthacqi5Z30V+jWr/I+n8O8HUwWYV4UJc1Nx952as0/dX4tnolFFFfmJ/QIV5J+\r\n0f8ABM/GvwFeaPbvZ21+UMkF1PFmQSplohvHITcSGBBGHYjkCvW6K1pVZ0JqpB2aOevQp4mnKlVV\r\n4vc/EXWvC3iDwrrWqaXq2k3ljf6WcXsMkRzbjOAzEcBSSMN905GDzXQeBPCWu+NzdnRrP7YlnH51\r\nzIZ441hj/vsXYAKMjJ6DI9a/XvWfAfh/xDrFjq2o6PZ3mp2QZbe7lhBlRWBDJu6lSCcqcg+lR6D8\r\nOPCnhbUJr/RvDWkaTfTKUkubGxihkZc5ILKoOMgHHtX2q4nahpT978D84nwVCpU1q+76a2Pkv4If\r\nsT65bapZaz4y1JdMggYSpp+l3Badz6NMuAgPfYSSO4r7WUBQAOgpaK+WxuPr5hNTrvbbsj7XK8ow\r\nmT0nSwsbX3b1b9Qooorzj2gooooAKKKKACiiigAooooA/9k=",
  "website": "https://www.manilawater.com",
  "professional_network_url": "https://www.professional-network.com/company/manilawater",
  "twitter_url": [
    "https://www.twitter.com/manilawaterph"
  ],
  "discord_url": [],
  "facebook_url": [
    "https://www.facebook.com/manilawater"
  ],
  "instagram_url": [
    "https://www.instagram.com/manilawaterph"
  ],
  "pinterest_url": [],
  "tiktok_url": [
    "https://tiktok.com/@manila.water"
  ],
  "youtube_url": [
    "https://www.youtube.com/channel/ucrdpv-yrb5-ck_lrfj4lahq"
  ],
  "github_url": [],
  "reddit_url": [],
  "financial_website_url": "https://www.financial-website.com/organization/manila-water",
  "stock_ticker": [
    {
      "exchange": null,
      "ticker": "MWTCF"
    },
    {
      "exchange": "PSE",
      "ticker": "MWC"
    }
  ],
  "is_b2b": 1,
  "industry": "Utilities",
  "sic_codes": [
    "76",
    "769"
  ],
  "naics_codes": [
    "22",
    "221"
  ],
  "categories_and_keywords": [
    "water and wastewater services",
    "law and government > law and government - other (in philippines)",
    "services",
    "sustainability",
    "advisories",
    "wastewater",
    "water",
    "energy-utilities",
    "water purification"
  ],
  "description": null,
  "description_enriched": "Manila Water Enterprise is a company that provides water and wastewater services. They offer advisory services, water conservation tips, water quality pronouncements, bill information, payment facilities, and customer faq. They also have a portfolio of services including water education and environmental advocacy. The company is focused on sustainability and has a corporate governance structure. They have a strong presence in the B2B market.",
  "description_metadata_raw": "Welcome to Manila Water's Enterprise Homepage.",
  "type": "Public Company",
  "status": {
    "value": "active",
    "comment": "Independent Company"
  },
  "founded_year": "1997",
  "size_range": "1001-5000 employees",
  "employees_count": 1686,
  "followers_count_professional_network": 42864,
  "followers_count_twitter": null,
  "followers_count_owler": 26,
  "hq_region": [
    "Asia",
    "South-eastern Asia",
    "APAC"
  ],
  "hq_country": "Philippines",
  "hq_country_iso2": "PH",
  "hq_country_iso3": "PHL",
  "hq_location": "Quezon City, Metro Manila, Philippines",
  "hq_full_address": "*******",
  "hq_city": null,
  "hq_state": null,
  "hq_street": null,
  "hq_zipcode": null,
  "company_locations_full": [
    {
      "location_address": "*******",
      "is_primary": 1
    },
    {
      "location_address": "*******",
      "is_primary": 0
    },
    {
      "location_address": "*******",
      "is_primary": 0
    },
    {
      "location_address": "*******",
      "is_primary": 0
    },
    {
      "location_address": "*******",
      "is_primary": 0
    },
    {
      "location_address": "*******",
      "is_primary": 0
    },
    {
      "location_address": "*******",
      "is_primary": 0
    }
  ],
  "is_public": 1,
  "ipo_date": "2012-02-15",
  "ipo_share_price": null,
  "ipo_share_price_currency": null,
  "revenue_annual_range": {
    "source_4_annual_revenue_range": null,
    "source_6_annual_revenue_range": {
      "annual_revenue_range_from": 200000000,
      "annual_revenue_range_to": 500000000,
      "annual_revenue_range_currency": "$"
    }
  },
  "revenue_annual": {
    "source_5_annual_revenue": {
      "annual_revenue": 376222000,
      "annual_revenue_currency": "$"
    },
    "source_1_annual_revenue": {
      "annual_revenue": 30709868544,
      "annual_revenue_currency": "₱"
    }
  },
  "revenue_quarterly": {
    "value": 7539326976,
    "currency": "₱"
  },
  "income_statements": [
    {
      "cost_of_goods_sold": 1443122944,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 2445221120,
      "ebitda": 6035518976,
      "ebitda_margin": 1.2807255210471158,
      "ebit_margin": 0.5188712197642524,
      "earnings_per_share": null,
      "gross_profit": 6355785216,
      "gross_profit_margin": 1.3486854013372511,
      "income_tax_expense": 460652992,
      "interest_expense": 404384000,
      "interest_income": 105412000,
      "net_income": 1728934016,
      "period_display_end_date": "Q1, 2018",
      "period_end_date": "2018-03-31",
      "period_type": "q1",
      "pre_tax_profit": 2189586944,
      "revenue": 4712578048,
      "total_operating_expense": 429534016
    },
    {
      "cost_of_goods_sold": 957504000,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 2737495808,
      "ebitda": 4966456832,
      "ebitda_margin": 1.0133663582516224,
      "ebit_margin": 0.5585644356773587,
      "earnings_per_share": null,
      "gross_profit": 5839913472,
      "gross_profit_margin": 1.1915882988239026,
      "income_tax_expense": 528230976,
      "interest_expense": 415910976,
      "interest_income": 98016000,
      "net_income": 1912153984,
      "period_display_end_date": "Q2, 2018",
      "period_end_date": "2018-06-30",
      "period_type": "q2",
      "pre_tax_profit": 2440385024,
      "revenue": 4900948992,
      "total_operating_expense": 1103610048
    },
    {
      "cost_of_goods_sold": 1496353024,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 2247357952,
      "ebitda": 4754348032,
      "ebitda_margin": 0.9873788509624934,
      "ebit_margin": 0.4667293385784641,
      "earnings_per_share": null,
      "gross_profit": 5460101120,
      "gross_profit_margin": 1.1339490364858134,
      "income_tax_expense": 514115072,
      "interest_expense": 511573056,
      "interest_income": 150426016,
      "net_income": 1366340096,
      "period_display_end_date": "Q3, 2018",
      "period_end_date": "2018-09-30",
      "period_type": "q3",
      "pre_tax_profit": 1880455168,
      "revenue": 4815120384,
      "total_operating_expense": 880793856
    },
    {
      "cost_of_goods_sold": 4351789056,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 9950027776,
      "ebitda": 22249031680,
      "ebitda_margin": null,
      "ebit_margin": null,
      "earnings_per_share": null,
      "gross_profit": 25274187776,
      "gross_profit_margin": null,
      "income_tax_expense": 1976356992,
      "interest_expense": 1783809024,
      "interest_income": 411883008,
      "net_income": 6635033088,
      "period_display_end_date": "FY, 2018",
      "period_end_date": "2018-12-31",
      "period_type": "fiscal_year",
      "pre_tax_profit": 8611390464,
      "revenue": 19836291072,
      "total_operating_expense": 3724299008
    },
    {
      "cost_of_goods_sold": 1093133056,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 2172968960,
      "ebitda": 4165236992,
      "ebitda_margin": null,
      "ebit_margin": null,
      "earnings_per_share": null,
      "gross_profit": 5405541888,
      "gross_profit_margin": null,
      "income_tax_expense": 540417984,
      "interest_expense": 533076000,
      "interest_income": 162404992,
      "net_income": 1273293952,
      "period_display_end_date": "Q1, 2019",
      "period_end_date": "2019-03-31",
      "period_type": "q1",
      "pre_tax_profit": 1813712000,
      "revenue": 5078764032,
      "total_operating_expense": 1447209984
    },
    {
      "cost_of_goods_sold": 2328142080,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 5037986816,
      "ebitda": 9899814912,
      "ebitda_margin": 0.9391177442262372,
      "ebit_margin": 0.4779142697252321,
      "earnings_per_share": null,
      "gross_profit": 11905705984,
      "gross_profit_margin": 1.1294008874410453,
      "income_tax_expense": 1247849984,
      "interest_expense": 1055587008,
      "interest_income": 265158000,
      "net_income": 2997809920,
      "period_display_end_date": "Q2, 2019",
      "period_end_date": "2019-06-30",
      "period_type": "q2",
      "pre_tax_profit": 4245659904,
      "revenue": 10541612032,
      "total_operating_expense": 2381680896
    },
    {
      "cost_of_goods_sold": 3564788992,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 7593558016,
      "ebitda": 16169207808,
      "ebitda_margin": 1.0017092234309581,
      "ebit_margin": 0.4704335050676892,
      "earnings_per_share": null,
      "gross_profit": 19330496512,
      "gross_profit_margin": 1.1975562983357735,
      "income_tax_expense": 1832233984,
      "interest_expense": 1616019968,
      "interest_income": 370409984,
      "net_income": 4514255872,
      "period_display_end_date": "Q3, 2019",
      "period_end_date": "2019-09-30",
      "period_type": "q3",
      "pre_tax_profit": 6346489856,
      "revenue": 16141618176,
      "total_operating_expense": 3713648128
    },
    {
      "cost_of_goods_sold": 5053233152,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 9688784896,
      "ebitda": 23691104256,
      "ebitda_margin": 1.0793327014168483,
      "ebit_margin": 0.44140713164934026,
      "earnings_per_share": null,
      "gross_profit": 27814164480,
      "gross_profit_margin": 1.2671734065856346,
      "income_tax_expense": 2374668032,
      "interest_expense": 2074708992,
      "interest_income": 404656000,
      "net_income": 5639425024,
      "period_display_end_date": "FY, 2019",
      "period_end_date": "2019-12-31",
      "period_type": "fiscal_year",
      "pre_tax_profit": 8014092800,
      "revenue": 21949769728,
      "total_operating_expense": 4776562176
    },
    {
      "cost_of_goods_sold": 1203127040,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 2307969024,
      "ebitda": 5245369856,
      "ebitda_margin": 0.9469219357099343,
      "ebit_margin": 0.416646786739884,
      "earnings_per_share": null,
      "gross_profit": 5943347200,
      "gross_profit_margin": 1.0729245009830282,
      "income_tax_expense": 595318976,
      "interest_expense": 576529984,
      "interest_income": 115667000,
      "net_income": 1250833024,
      "period_display_end_date": "Q1, 2020",
      "period_end_date": "2020-03-31",
      "period_type": "q1",
      "pre_tax_profit": 1846151936,
      "revenue": 5539389952,
      "total_operating_expense": 917216000
    },
    {
      "cost_of_goods_sold": 1041569024,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 2334191104,
      "ebitda": 4963570176,
      "ebitda_margin": 0.9298599091574838,
      "ebit_margin": 0.4372801533896651,
      "earnings_per_share": null,
      "gross_profit": 6004167680,
      "gross_profit_margin": 1.1248022321687632,
      "income_tax_expense": 556897088,
      "interest_expense": 595631040,
      "interest_income": 131637992,
      "net_income": 1298172032,
      "period_display_end_date": "Q2, 2020",
      "period_end_date": "2020-06-30",
      "period_type": "q2",
      "pre_tax_profit": 1855069184,
      "revenue": 5337976320,
      "total_operating_expense": 946091008
    },
    {
      "cost_of_goods_sold": 1095852032,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 2523917824,
      "ebitda": 6234384384,
      "ebitda_margin": 1.2002443754802838,
      "ebit_margin": 0.485904940382713,
      "earnings_per_share": null,
      "gross_profit": 7139044352,
      "gross_profit_margin": 1.3744096132062118,
      "income_tax_expense": 831143936,
      "interest_expense": 630022016,
      "interest_income": 107642016,
      "net_income": 828614912,
      "period_display_end_date": "Q3, 2020",
      "period_end_date": "2020-09-30",
      "period_type": "q3",
      "pre_tax_profit": 1659758848,
      "revenue": 5194262528,
      "total_operating_expense": 872506880
    },
    {
      "cost_of_goods_sold": 4544318976,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 9271208960,
      "ebitda": 23992283136,
      "ebitda_margin": 1.135722046943638,
      "ebit_margin": 0.4388709635513613,
      "earnings_per_share": null,
      "gross_profit": 27572336640,
      "gross_profit_margin": 1.305190941199464,
      "income_tax_expense": 1748723968,
      "interest_expense": 2260072960,
      "interest_income": 503191008,
      "net_income": 4914845184,
      "period_display_end_date": "FY, 2020",
      "period_end_date": "2020-12-31",
      "period_type": "fiscal_year",
      "pre_tax_profit": 6663568896,
      "revenue": 21125136384,
      "total_operating_expense": 3793889024
    },
    {
      "cost_of_goods_sold": 1081906048,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 2216951040,
      "ebitda": 5528949248,
      "ebitda_margin": 1.1394630576890468,
      "ebit_margin": 0.4568922045538936,
      "earnings_per_share": null,
      "gross_profit": 6275805184,
      "gross_profit_margin": 1.2933828551615258,
      "income_tax_expense": 600617984,
      "interest_expense": 519574016,
      "interest_income": 84157000,
      "net_income": 1330619008,
      "period_display_end_date": "Q1, 2021",
      "period_end_date": "2021-03-31",
      "period_type": "q1",
      "pre_tax_profit": 1931236992,
      "revenue": 4852240896,
      "total_operating_expense": 917409984
    },
    {
      "cost_of_goods_sold": 1174602880,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 2337248000,
      "ebitda": 6651655680,
      "ebitda_margin": 1.2579068721053481,
      "ebit_margin": 0.442001279449041,
      "earnings_per_share": null,
      "gross_profit": 7602503680,
      "gross_profit_margin": 1.4377234908644878,
      "income_tax_expense": 445490048,
      "interest_expense": 572318976,
      "interest_income": 82649000,
      "net_income": 1468522112,
      "period_display_end_date": "Q2, 2021",
      "period_end_date": "2021-06-30",
      "period_type": "q2",
      "pre_tax_profit": 1914012032,
      "revenue": 5287876096,
      "total_operating_expense": 1108560064
    },
    {
      "cost_of_goods_sold": 1271709952,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 2323228160,
      "ebitda": 5511702528,
      "ebitda_margin": 1.0734230318447864,
      "ebit_margin": 0.45245667786053356,
      "earnings_per_share": null,
      "gross_profit": 6716387328,
      "gross_profit_margin": 1.30803954169162,
      "income_tax_expense": 136910976,
      "interest_expense": 687533056,
      "interest_income": 73582000,
      "net_income": 690430976,
      "period_display_end_date": "Q3, 2021",
      "period_end_date": "2021-09-30",
      "period_type": "q3",
      "pre_tax_profit": 827341824,
      "revenue": 5134697472,
      "total_operating_expense": 876417920
    },
    {
      "cost_of_goods_sold": 5097506816,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 7936542208,
      "ebitda": 28614479872,
      "ebitda_margin": 1.4100957502488272,
      "ebit_margin": 0.39110563914608143,
      "earnings_per_share": null,
      "gross_profit": 32182140928,
      "gross_profit_margin": 1.5859068681128479,
      "income_tax_expense": 1539250048,
      "interest_expense": 2473334016,
      "interest_income": 308260000,
      "net_income": 3754138112,
      "period_display_end_date": "FY, 2021",
      "period_end_date": "2021-12-31",
      "period_type": "fiscal_year",
      "pre_tax_profit": 5293387776,
      "revenue": 20292579328,
      "total_operating_expense": 4137121024
    },
    {
      "cost_of_goods_sold": 1314102016,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 2061741952,
      "ebitda": 9145221120,
      "ebitda_margin": 1.7991290092147425,
      "ebit_margin": 0.40560416272999084,
      "earnings_per_share": null,
      "gross_profit": 9954575360,
      "gross_profit_margin": 1.9583523536050147,
      "income_tax_expense": 94505000,
      "interest_expense": 679406976,
      "interest_income": 74122000,
      "net_income": 1123083008,
      "period_display_end_date": "Q1, 2022",
      "period_end_date": "2022-03-31",
      "period_type": "q1",
      "pre_tax_profit": 1217587968,
      "revenue": 5083138048,
      "total_operating_expense": 980084992
    },
    {
      "cost_of_goods_sold": 2662735872,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 4347288064,
      "ebitda": 16773740544,
      "ebitda_margin": 1.56243276088538,
      "ebit_margin": 0.4049392128358164,
      "earnings_per_share": null,
      "gross_profit": 18481627136,
      "gross_profit_margin": 1.7215182049589857,
      "income_tax_expense": 809795008,
      "interest_expense": 1337985024,
      "interest_income": 148990000,
      "net_income": 3006871040,
      "period_display_end_date": "Q2, 2022",
      "period_end_date": "2022-06-30",
      "period_type": "q2",
      "pre_tax_profit": 3816666112,
      "revenue": 10735655936,
      "total_operating_expense": 2015156992
    },
    {
      "cost_of_goods_sold": 4383742976,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 6829053952,
      "ebitda": 9442861056,
      "ebitda_margin": 0.573572987817409,
      "ebit_margin": 0.41480657779308155,
      "earnings_per_share": null,
      "gross_profit": 12537056256,
      "gross_profit_margin": 0.7615188630377808,
      "income_tax_expense": 1307149056,
      "interest_expense": 1934695936,
      "interest_income": 248218000,
      "net_income": 4685435904,
      "period_display_end_date": "Q3, 2022",
      "period_end_date": "2022-09-30",
      "period_type": "q3",
      "pre_tax_profit": 5992585216,
      "revenue": 16463224832,
      "total_operating_expense": 3541221888
    },
    {
      "cost_of_goods_sold": 6206324224,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 10186670080,
      "ebitda": 36513423360,
      "ebitda_margin": 1.6015314636424254,
      "ebit_margin": 0.4468020563839266,
      "earnings_per_share": null,
      "gross_profit": 40933257216,
      "gross_profit_margin": 1.7953917575586194,
      "income_tax_expense": 2013261056,
      "interest_expense": 2816243968,
      "interest_income": 121760000,
      "net_income": 6141408256,
      "period_display_end_date": "FY, 2022",
      "period_end_date": "2022-12-31",
      "period_type": "fiscal_year",
      "pre_tax_profit": 8154669056,
      "revenue": 22799067136,
      "total_operating_expense": 4939900928
    },
    {
      "cost_of_goods_sold": 1604689024,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 3780826112,
      "ebitda": 6940592128,
      "ebitda_margin": 0.9401000417765405,
      "ebit_margin": 0.5121111744201078,
      "earnings_per_share": null,
      "gross_profit": 8151958016,
      "gross_profit_margin": 1.1041789994379863,
      "income_tax_expense": 538262016,
      "interest_expense": 961804992,
      "interest_income": 75484000,
      "net_income": 2361833984,
      "period_display_end_date": "Q1, 2023",
      "period_end_date": "2023-03-31",
      "period_type": "q1",
      "pre_tax_profit": 2900096000,
      "revenue": 7382822912,
      "total_operating_expense": 1370076032
    },
    {
      "cost_of_goods_sold": 1444294016,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 4624768000,
      "ebitda": 3540127744,
      "ebitda_margin": 0.44205108585965786,
      "ebit_margin": 0.5774886851792087,
      "earnings_per_share": null,
      "gross_profit": 4538290688,
      "gross_profit_margin": 0.5666903771982003,
      "income_tax_expense": 822281984,
      "interest_expense": 950323008,
      "interest_income": 80195008,
      "net_income": 2857792000,
      "period_display_end_date": "Q2, 2023",
      "period_end_date": "2023-06-30",
      "period_type": "q2",
      "pre_tax_profit": 3680074240,
      "revenue": 8008413184,
      "total_operating_expense": 1134686080
    },
    {
      "cost_of_goods_sold": 1565734912,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 3814210560,
      "ebitda": 16444684288,
      "ebitda_margin": 2.18118730496084,
      "ebit_margin": 0.5059086271416278,
      "earnings_per_share": null,
      "gross_profit": 17465095168,
      "gross_profit_margin": 2.3165323938856583,
      "income_tax_expense": 817675008,
      "interest_expense": 913564928,
      "interest_income": 293392992,
      "net_income": 2305004032,
      "period_display_end_date": "Q3, 2023",
      "period_end_date": "2023-09-30",
      "period_type": "q3",
      "pre_tax_profit": 3122678272,
      "revenue": 7539326976,
      "total_operating_expense": 1134125824
    },
    {
      "cost_of_goods_sold": 5971341824,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 12814622720,
      "ebitda": 36907810816,
      "ebitda_margin": 1.2018224943919837,
      "ebit_margin": 0.4172802857048921,
      "earnings_per_share": null,
      "gross_profit": 44872314880,
      "gross_profit_margin": 1.4611692269443797,
      "income_tax_expense": 3104517888,
      "interest_expense": 3773677056,
      "interest_income": 301230016,
      "net_income": 5870456832,
      "period_display_end_date": "FY, 2023",
      "period_end_date": "2023-12-31",
      "period_type": "fiscal_year",
      "pre_tax_profit": 8974974976,
      "revenue": 30709868544,
      "total_operating_expense": 4403011072
    },
    {
      "cost_of_goods_sold": 1481502976,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 5163025920,
      "ebitda": 10449208320,
      "ebitda_margin": 1.1849194821113742,
      "ebit_margin": 0.5854768908707144,
      "earnings_per_share": null,
      "gross_profit": 11677592576,
      "gross_profit_margin": 1.3242158184345154,
      "income_tax_expense": 1027953024,
      "interest_expense": 980096000,
      "interest_income": 121098000,
      "net_income": 3226177024,
      "period_display_end_date": "Q1, 2024",
      "period_end_date": "2024-03-31",
      "period_type": "q1",
      "pre_tax_profit": 4254129920,
      "revenue": 8818496512,
      "total_operating_expense": 1313522944
    },
    {
      "cost_of_goods_sold": 1785600000,
      "cost_of_goods_sold_currency": "₱",
      "ebit": 5660220928,
      "ebitda": 12439538688,
      "ebitda_margin": 1.3045225896454857,
      "ebit_margin": 0.5935819846826892,
      "earnings_per_share": null,
      "gross_profit": 13508398080,
      "gross_profit_margin": 1.4166128573789527,
      "income_tax_expense": 1163127936,
      "interest_expense": 847817984,
      "interest_income": 77037008,
      "net_income": 3934420992,
      "period_display_end_date": "Q2, 2024",
      "period_end_date": "2024-06-30",
      "period_type": "q2",
      "pre_tax_profit": 5097549056,
      "revenue": 9535702016,
      "total_operating_expense": 1198626048
    }
  ],
  "stock_information": [
    {
      "closing_price": 0.330000013113021,
      "currency": "$",
      "date": "2021-05-28",
      "marketcap": 764349312
    },
    {
      "closing_price": 0.40000000596046403,
      "currency": "$",
      "date": "2022-04-27",
      "marketcap": 1288405376
    },
    {
      "closing_price": 0.47999998927116305,
      "currency": "$",
      "date": "2022-01-31",
      "marketcap": 1541846400
    },
    {
      "closing_price": 0.330000013113021,
      "currency": "$",
      "date": "2023-06-30",
      "marketcap": 1134239616
    },
    {
      "closing_price": 0.349999994039535,
      "currency": "$",
      "date": "2023-05-31",
      "marketcap": 1089949696
    },
    {
      "closing_price": 0.310000002384185,
      "currency": "$",
      "date": "2023-09-29",
      "marketcap": 959414272
    },
    {
      "closing_price": 0.370000004768371,
      "currency": "$",
      "date": "2022-03-31",
      "marketcap": 1180476160
    },
    {
      "closing_price": 0.310000002384185,
      "currency": "$",
      "date": "2023-11-30",
      "marketcap": 956641344
    },
    {
      "closing_price": 0.349999994039535,
      "currency": "$",
      "date": "2021-02-26",
      "marketcap": 770923968
    },
    {
      "closing_price": 0.330000013113021,
      "currency": "$",
      "date": "2021-04-30",
      "marketcap": 749232000
    },
    {
      "closing_price": 0.340000003576278,
      "currency": "$",
      "date": "2022-05-31",
      "marketcap": 1080898560
    },
    {
      "closing_price": 0.319999992847442,
      "currency": "$",
      "date": "2024-02-29",
      "marketcap": 1018826624
    },
    {
      "closing_price": 0.5,
      "currency": "$",
      "date": "2024-06-28",
      "marketcap": 1373970048
    },
    {
      "closing_price": 0.319999992847442,
      "currency": "$",
      "date": "2023-10-31",
      "marketcap": 879630400
    },
    {
      "closing_price": 0.289999991655349,
      "currency": "$",
      "date": "2021-03-31",
      "marketcap": 808502592
    },
    {
      "closing_price": 0.38999998569488503,
      "currency": "$",
      "date": "2021-10-29",
      "marketcap": 903321856
    },
    {
      "closing_price": 0.340000003576278,
      "currency": "$",
      "date": "2021-07-30",
      "marketcap": 787511360
    },
    {
      "closing_price": 0.45,
      "currency": "$",
      "date": "2024-07-31",
      "marketcap": 1167592500
    },
    {
      "closing_price": 0.259999990463256,
      "currency": "$",
      "date": "2022-11-30",
      "marketcap": 829384832
    },
    {
      "closing_price": 0.330000013113021,
      "currency": "$",
      "date": "2022-12-30",
      "marketcap": 1057979584
    },
    {
      "closing_price": 0.46000000834465005,
      "currency": "$",
      "date": "2024-05-31",
      "marketcap": 1401927040
    },
    {
      "closing_price": 0.360000014305114,
      "currency": "$",
      "date": "2021-06-30",
      "marketcap": 834067200
    },
    {
      "closing_price": 0.46000000834465005,
      "currency": "$",
      "date": "2024-08-30",
      "marketcap": 1419578496
    },
    {
      "closing_price": 0.259999990463256,
      "currency": "$",
      "date": "2022-09-30",
      "marketcap": 829384832
    },
    {
      "closing_price": 0.46000000834465005,
      "currency": "$",
      "date": "2024-10-29",
      "marketcap": 1303980416
    },
    {
      "closing_price": 0.330000013113021,
      "currency": "$",
      "date": "2023-12-29",
      "marketcap": 990225024
    },
    {
      "closing_price": 0.349999994039535,
      "currency": "$",
      "date": "2023-07-31",
      "marketcap": 1166476672
    },
    {
      "closing_price": 0.289999991655349,
      "currency": "$",
      "date": "2022-08-31",
      "marketcap": 946038400
    },
    {
      "closing_price": 0.330000013113021,
      "currency": "$",
      "date": "2023-01-30",
      "marketcap": 1057979584
    },
    {
      "closing_price": 0.340000003576278,
      "currency": "$",
      "date": "2022-06-30",
      "marketcap": 1080898560
    },
    {
      "closing_price": 0.289999991655349,
      "currency": "$",
      "date": "2022-07-29",
      "marketcap": 946038400
    },
    {
      "closing_price": 0.340000003576278,
      "currency": "$",
      "date": "2024-04-30",
      "marketcap": 1271047552
    },
    {
      "closing_price": 0.340000003576278,
      "currency": "$",
      "date": "2023-03-31",
      "marketcap": 1213755776
    },
    {
      "closing_price": 0.349999994039535,
      "currency": "$",
      "date": "2023-04-27",
      "marketcap": 1122412672
    },
    {
      "closing_price": 0.47999998927116305,
      "currency": "$",
      "date": "2022-02-28",
      "marketcap": 1541846400
    },
    {
      "closing_price": 0.46000000834465005,
      "currency": "$",
      "date": "2024-09-30",
      "marketcap": 1391624192
    },
    {
      "closing_price": 0.330000013113021,
      "currency": "$",
      "date": "2024-01-31",
      "marketcap": 938691648
    },
    {
      "closing_price": 0.38999998569488503,
      "currency": "$",
      "date": "2021-09-21",
      "marketcap": 903321856
    },
    {
      "closing_price": 0.540000021457672,
      "currency": "$",
      "date": "2021-11-10",
      "marketcap": 1250753408
    },
    {
      "closing_price": 0.319999992847442,
      "currency": "$",
      "date": "2023-08-31",
      "marketcap": 1061220224
    },
    {
      "closing_price": 0.370000004768371,
      "currency": "$",
      "date": "2023-02-28",
      "marketcap": 1315679744
    },
    {
      "closing_price": 0.370000004768371,
      "currency": "$",
      "date": "2021-08-26",
      "marketcap": 856997696
    },
    {
      "closing_price": 0.340000003576278,
      "currency": "$",
      "date": "2024-03-28",
      "marketcap": 1187266560
    },
    {
      "closing_price": 0.259999990463256,
      "currency": "$",
      "date": "2022-10-31",
      "marketcap": 829384832
    }
  ],
  "last_funding_round_name": null,
  "last_funding_round_announced_date": null,
  "last_funding_round_lead_investors": [],
  "last_funding_round_amount_raised": null,
  "last_funding_round_amount_raised_currency": null,
  "last_funding_round_num_investors": null,
  "funding_rounds": [],
  "ownership_status": "Public",
  "parent_company_information": null,
  "acquired_by_summary": null,
  "num_acquisitions_source_1": null,
  "acquisition_list_source_1": [],
  "num_acquisitions_source_2": 1,
  "acquisition_list_source_2": [
    {
      "acquiree_name": "Clark Water Corp",
      "announced_date": "2011-12-27",
      "price": null,
      "currency": null
    }
  ],
  "num_acquisitions_source_5": null,
  "acquisition_list_source_5": [],
  "competitors": [
    {
      "company_name": "water direct",
      "similarity_score": 99998
    },
    {
      "company_name": "pennon group",
      "similarity_score": null
    },
    {
      "company_name": "iguá saneamento",
      "similarity_score": null
    },
    {
      "company_name": "maynilad",
      "similarity_score": null
    },
    {
      "company_name": "maynilad",
      "similarity_score": 100000
    },
    {
      "company_name": "anglian water",
      "similarity_score": 99999
    },
    {
      "company_name": "gmb ervaar de zekerheid",
      "similarity_score": null
    }
  ],
  "competitors_websites": [
    {
      "website": "mwss.gov.ph",
      "similarity_score": 100,
      "total_website_visits_monthly": 7800,
      "category": "Law and Government > Legal",
      "rank_category": 16940
    },
    {
      "website": "ppp.gov.ph",
      "similarity_score": 91,
      "total_website_visits_monthly": 54100,
      "category": "Law and Government > Law and Government - Other",
      "rank_category": 1603
    },
    {
      "website": "primewatercorp.com",
      "similarity_score": 90,
      "total_website_visits_monthly": 12000,
      "category": "Law and Government > Law and Government - Other",
      "rank_category": 5061
    },
    {
      "website": "pids.gov.ph",
      "similarity_score": 87,
      "total_website_visits_monthly": 217600,
      "category": "Law and Government > Law and Government - Other",
      "rank_category": 545
    },
    {
      "website": "customs.gov.ph",
      "similarity_score": 87,
      "total_website_visits_monthly": 404500,
      "category": "Law and Government > Law and Government - Other",
      "rank_category": 254
    },
    {
      "website": "pna.gov.ph",
      "similarity_score": 87,
      "total_website_visits_monthly": 2200000,
      "category": "Law and Government > Law and Government - Other",
      "rank_category": 90
    },
    {
      "website": "contactnumbersph.com",
      "similarity_score": 70,
      "total_website_visits_monthly": 21000,
      "category": "Law and Government > Government",
      "rank_category": 27905
    },
    {
      "website": "mayniladwater.com.ph",
      "similarity_score": 68,
      "total_website_visits_monthly": 124400,
      "category": "Reference Materials > Public Records and Directories",
      "rank_category": 177
    },
    {
      "website": "mntc.com",
      "similarity_score": 67,
      "total_website_visits_monthly": 0,
      "category": "Law and Government > Legal",
      "rank_category": 0
    },
    {
      "website": "gwp.org",
      "similarity_score": 58,
      "total_website_visits_monthly": 52600,
      "category": "Law and Government > Government",
      "rank_category": 16201
    }
  ],
  "company_phone_numbers": [
    "********",
    "********"
  ],
  "company_emails": [
    "****@manilawater.com"
  ],
  "pricing_available": 0,
  "free_trial_available": 0,
  "demo_available": 0,
  "is_downloadable": 0,
  "mobile_apps_exist": 0,
  "online_reviews_exist": 0,
  "documentation_exist": 0,
  "product_reviews_count": null,
  "product_reviews_aggregate_score": null,
  "product_reviews_score_distribution": null,
  "product_pricing_summary": [],
  "num_news_articles": 0,
  "news_articles": [],
  "num_technologies_used": 20,
  "technologies_used": [
    {
      "technology": "hcm",
      "first_verified_at": "2024-04-04",
      "last_verified_at": "2024-04-22"
    },
    {
      "technology": "successfactors",
      "first_verified_at": "2024-04-04",
      "last_verified_at": "2024-04-22"
    },
    {
      "technology": "microsoft",
      "first_verified_at": "2024-04-04",
      "last_verified_at": "2025-03-31"
    },
    {
      "technology": "mix",
      "first_verified_at": "2024-04-04",
      "last_verified_at": "2024-05-27"
    },
    {
      "technology": "medium",
      "first_verified_at": "2025-02-24",
      "last_verified_at": "2025-03-31"
    },
    {
      "technology": "segment",
      "first_verified_at": "2024-09-30",
      "last_verified_at": "2025-03-24"
    },
    {
      "technology": "namely",
      "first_verified_at": "2024-12-30",
      "last_verified_at": "2025-03-31"
    },
    {
      "technology": "charter",
      "first_verified_at": "2024-11-18",
      "last_verified_at": "2025-03-31"
    },
    {
      "technology": "impact",
      "first_verified_at": "2024-05-20",
      "last_verified_at": "2025-03-31"
    },
    {
      "technology": "well",
      "first_verified_at": "2024-04-04",
      "last_verified_at": "2025-03-31"
    },
    {
      "technology": "box",
      "first_verified_at": "2024-05-20",
      "last_verified_at": "2024-06-03"
    },
    {
      "technology": "ease",
      "first_verified_at": "2024-05-20",
      "last_verified_at": "2024-08-26"
    },
    {
      "technology": "microsoft office",
      "first_verified_at": "2025-02-18",
      "last_verified_at": "2025-03-31"
    },
    {
      "technology": "square",
      "first_verified_at": "2025-03-17",
      "last_verified_at": "2025-03-31"
    },
    {
      "technology": "amp",
      "first_verified_at": "2024-05-20",
      "last_verified_at": "2025-03-31"
    },
    {
      "technology": "ecc",
      "first_verified_at": "2024-05-20",
      "last_verified_at": "2025-03-31"
    },
    {
      "technology": "sap plant maintenance",
      "first_verified_at": "2024-05-20",
      "last_verified_at": "2024-08-26"
    },
    {
      "technology": "microsoft dynamics 365",
      "first_verified_at": "2025-02-20",
      "last_verified_at": "2025-03-31"
    },
    {
      "technology": "arcgis",
      "first_verified_at": "2024-05-20",
      "last_verified_at": "2024-06-03"
    },
    {
      "technology": "php",
      "first_verified_at": "2024-05-20",
      "last_verified_at": "2025-03-31"
    }
  ],
  "total_website_visits_monthly": 33300,
  "visits_change_monthly": 23.22,
  "rank_global": 908644,
  "rank_country": 15155,
  "rank_category": 27,
  "visits_breakdown_by_country": [],
  "visits_breakdown_by_gender": {
    "male_percentage": 51.38,
    "female_percentage": 48.62
  },
  "visits_breakdown_by_age": {
    "age_18_24_percentage": 17.49,
    "age_25_34_percentage": 25.05,
    "age_35_44_percentage": 14.44,
    "age_45_54_percentage": 15.12,
    "age_55_64_percentage": 16.53,
    "age_65_plus_percentage": 11.37
  },
  "bounce_rate": 58.04,
  "pages_per_visit": 1.84,
  "average_visit_duration_seconds": 78,
  "similarly_ranked_websites": [
    "ltfrb.gov.ph",
    "philjobnet.ph",
    "manilawater.com",
    "ngcp.ph",
    "nbiclearance.org",
    "pids.gov.ph",
    "ppp.gov.ph",
    "manilawater.com",
    "primewatercorp.com",
    "mwss.gov.ph"
  ],
  "top_topics": [
    "social network",
    "social",
    "social media",
    "post office",
    "wiki"
  ],
  "company_employee_reviews_count": 201,
  "company_employee_reviews_aggregate_score": 4,
  "employee_reviews_score_breakdown": {
    "business_outlook": 0.74,
    "career_opportunities": 4.1,
    "ceo_approval": 0.79,
    "compensation_benefits": 4.2,
    "culture_values": 4,
    "diversity_inclusion": 4.2,
    "recommend": 0.84,
    "senior_management": 3.6,
    "work_life_balance": 3.5
  },
  "employee_reviews_score_distribution": {
    "1": 4,
    "2": 7,
    "3": 14,
    "4": 24,
    "5": 25
  },
  "active_job_postings_count": 4,
  "active_job_postings_titles": [
    "Corporate Legal Counsel - Contracts",
    "Head of Internal Control",
    "Environment and Sanitation Operations Shift head",
    "Solutions Project Manager"
  ],
  "base_salary": [
    {
      "title": "Department Head",
      "salary_p25": 960000,
      "salary_median": 1200000,
      "salary_p75": 1800000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-12-06"
    },
    {
      "title": "Engineer",
      "salary_p25": 495000,
      "salary_median": 630000,
      "salary_p75": 1155000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-06-12"
    },
    {
      "title": "Section Head",
      "salary_p25": 780000,
      "salary_median": 870000,
      "salary_p75": 960000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2022-09-07"
    },
    {
      "title": "Network Manager",
      "salary_p25": 240000,
      "salary_median": 312000,
      "salary_p75": 312000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-07-26"
    },
    {
      "title": "Operations Manager",
      "salary_p25": 412500,
      "salary_median": 960000,
      "salary_p75": 1430000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-08-07"
    },
    {
      "title": "Senior Territory Manager",
      "salary_p25": 375000,
      "salary_median": 468000,
      "salary_p75": 570000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-08-31"
    },
    {
      "title": "Territory Manager",
      "salary_p25": 75000,
      "salary_median": 214000,
      "salary_p75": 435000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-08-31"
    },
    {
      "title": "Senior Legal Counsel",
      "salary_p25": 2625846,
      "salary_median": 2912923,
      "salary_p75": 3200000,
      "currency": "PHP",
      "pay_period": "ANNUAL",
      "salary_updated_at": "2024-04-01"
    },
    {
      "title": "Plant Shift Head",
      "salary_p25": 276000,
      "salary_median": 341600,
      "salary_p75": 500000,
      "currency": "PHP",
      "pay_period": "ANNUAL",
      "salary_updated_at": "2024-06-29"
    },
    {
      "title": "Plant Manager",
      "salary_p25": 276000,
      "salary_median": 360000,
      "salary_p75": 480000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-02-01"
    },
    {
      "title": "Human Resources Manager",
      "salary_p25": 552000,
      "salary_median": 756000,
      "salary_p75": 960000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-02-14"
    },
    {
      "title": "Project Manager",
      "salary_p25": 425000,
      "salary_median": 720000,
      "salary_p75": 1200000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-10-11"
    },
    {
      "title": "Internal Audit Manager",
      "salary_p25": 840000,
      "salary_median": 900000,
      "salary_p75": 960000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-05-03"
    },
    {
      "title": "Shift Engineer",
      "salary_p25": 300000,
      "salary_median": 339000,
      "salary_p75": 378000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2022-09-04"
    },
    {
      "title": "Business Development Manager",
      "salary_p25": 507000,
      "salary_median": 702000,
      "salary_p75": 897000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-06-24"
    },
    {
      "title": "Mechanical Engineer",
      "salary_p25": 300000,
      "salary_median": 360000,
      "salary_p75": 516000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-08-25"
    },
    {
      "title": "Key Accounts Manager",
      "salary_p25": 480000,
      "salary_median": 552000,
      "salary_p75": 600000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-11-26"
    },
    {
      "title": "Procurement Manager",
      "salary_p25": 660000,
      "salary_median": 830000,
      "salary_p75": 1000000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2021-04-11"
    },
    {
      "title": "Human Resources Business Partner",
      "salary_p25": 876000,
      "salary_median": 1158000,
      "salary_p75": 1440000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-02-14"
    },
    {
      "title": "IT Specialist",
      "salary_p25": 600000,
      "salary_median": 600000,
      "salary_p75": 600000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2022-08-17"
    },
    {
      "title": "Internship",
      "salary_p25": 115008,
      "salary_median": 120463.8,
      "salary_p75": 125919.6,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-08-06"
    }
  ],
  "additional_pay": [
    {
      "title": "Key Accounts Manager",
      "additional_pay_values": [
        {
          "additional_pay_p25": 60000,
          "additional_pay_median": 97500,
          "additional_pay_p75": 135000,
          "additional_pay_type": "Cash Bonus"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-11-26"
    },
    {
      "title": "IT Specialist",
      "additional_pay_values": [
        {
          "additional_pay_p25": 76608,
          "additional_pay_median": 80185.2,
          "additional_pay_p75": 83762.4,
          "additional_pay_type": "Cash Bonus"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2022-08-17"
    },
    {
      "title": "Internal Audit Manager",
      "additional_pay_values": [
        {
          "additional_pay_p25": 285897,
          "additional_pay_median": 300231,
          "additional_pay_p75": 314565,
          "additional_pay_type": "Cash Bonus"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-05-03"
    },
    {
      "title": "Procurement Manager",
      "additional_pay_values": [
        {
          "additional_pay_p25": 96113,
          "additional_pay_median": 100373,
          "additional_pay_p75": 104633,
          "additional_pay_type": "Cash Bonus"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2021-04-11"
    },
    {
      "title": "Business Development Manager",
      "additional_pay_values": [
        {
          "additional_pay_p25": 120000,
          "additional_pay_median": 120000,
          "additional_pay_p75": 120000,
          "additional_pay_type": "Cash Bonus"
        },
        {
          "additional_pay_p25": 50000,
          "additional_pay_median": 50000,
          "additional_pay_p75": 50000,
          "additional_pay_type": "Profit Sharing"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-06-24"
    },
    {
      "title": "Business Development Manager",
      "additional_pay_values": [
        {
          "additional_pay_p25": 120000,
          "additional_pay_median": 120000,
          "additional_pay_p75": 120000,
          "additional_pay_type": "Cash Bonus"
        },
        {
          "additional_pay_p25": 50000,
          "additional_pay_median": 50000,
          "additional_pay_p75": 50000,
          "additional_pay_type": "Profit Sharing"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-06-24"
    },
    {
      "title": "Senior Legal Counsel",
      "additional_pay_values": [
        {
          "additional_pay_p25": 193000,
          "additional_pay_median": 196500,
          "additional_pay_p75": 200000,
          "additional_pay_type": "Cash Bonus"
        }
      ],
      "currency": "PHP",
      "pay_period": "ANNUAL",
      "salary_updated_at": "2024-04-01"
    },
    {
      "title": "Engineer",
      "additional_pay_values": [
        {
          "additional_pay_p25": 30000,
          "additional_pay_median": 30000,
          "additional_pay_p75": 30000,
          "additional_pay_type": "Cash Bonus"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-06-12"
    },
    {
      "title": "Territory Manager",
      "additional_pay_values": [
        {
          "additional_pay_p25": 18000,
          "additional_pay_median": 34000,
          "additional_pay_p75": 50000,
          "additional_pay_type": "Cash Bonus"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-08-31"
    },
    {
      "title": "Human Resources Manager",
      "additional_pay_values": [
        {
          "additional_pay_p25": 115087.2,
          "additional_pay_median": 120379.8,
          "additional_pay_p75": 125672.4,
          "additional_pay_type": "Cash Bonus"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-02-14"
    },
    {
      "title": "Network Manager",
      "additional_pay_values": [
        {
          "additional_pay_p25": 60000,
          "additional_pay_median": 78000,
          "additional_pay_p75": 312000,
          "additional_pay_type": "Cash Bonus"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-07-26"
    },
    {
      "title": "Operations Manager",
      "additional_pay_values": [
        {
          "additional_pay_p25": 180000,
          "additional_pay_median": 190000,
          "additional_pay_p75": 200000,
          "additional_pay_type": "Cash Bonus"
        },
        {
          "additional_pay_p25": 120000,
          "additional_pay_median": 120000,
          "additional_pay_p75": 120000,
          "additional_pay_type": "Profit Sharing"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-08-07"
    },
    {
      "title": "Operations Manager",
      "additional_pay_values": [
        {
          "additional_pay_p25": 180000,
          "additional_pay_median": 190000,
          "additional_pay_p75": 200000,
          "additional_pay_type": "Cash Bonus"
        },
        {
          "additional_pay_p25": 120000,
          "additional_pay_median": 120000,
          "additional_pay_p75": 120000,
          "additional_pay_type": "Profit Sharing"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-08-07"
    },
    {
      "title": "Senior Territory Manager",
      "additional_pay_values": [
        {
          "additional_pay_p25": 70000,
          "additional_pay_median": 80000,
          "additional_pay_p75": 155000,
          "additional_pay_type": "Cash Bonus"
        },
        {
          "additional_pay_p25": 80000,
          "additional_pay_median": 80000,
          "additional_pay_p75": 80000,
          "additional_pay_type": "Commission Sharing"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-08-31"
    },
    {
      "title": "Senior Territory Manager",
      "additional_pay_values": [
        {
          "additional_pay_p25": 70000,
          "additional_pay_median": 80000,
          "additional_pay_p75": 155000,
          "additional_pay_type": "Cash Bonus"
        },
        {
          "additional_pay_p25": 80000,
          "additional_pay_median": 80000,
          "additional_pay_p75": 80000,
          "additional_pay_type": "Commission Sharing"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-08-31"
    },
    {
      "title": "Plant Manager",
      "additional_pay_values": [
        {
          "additional_pay_p25": 69000,
          "additional_pay_median": 94500,
          "additional_pay_p75": 120000,
          "additional_pay_type": "Cash Bonus"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-02-01"
    },
    {
      "title": "Plant Shift Head",
      "additional_pay_values": [
        {
          "additional_pay_p25": 23000,
          "additional_pay_median": 73300,
          "additional_pay_p75": 123600,
          "additional_pay_type": "Cash Bonus"
        }
      ],
      "currency": "PHP",
      "pay_period": "ANNUAL",
      "salary_updated_at": "2024-06-29"
    },
    {
      "title": "Project Manager",
      "additional_pay_values": [
        {
          "additional_pay_p25": 50000,
          "additional_pay_median": 55000,
          "additional_pay_p75": 60000,
          "additional_pay_type": "Cash Bonus"
        },
        {
          "additional_pay_p25": 5,
          "additional_pay_median": 5,
          "additional_pay_p75": 5,
          "additional_pay_type": "Stock Bonus"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-10-11"
    },
    {
      "title": "Project Manager",
      "additional_pay_values": [
        {
          "additional_pay_p25": 50000,
          "additional_pay_median": 55000,
          "additional_pay_p75": 60000,
          "additional_pay_type": "Cash Bonus"
        },
        {
          "additional_pay_p25": 5,
          "additional_pay_median": 5,
          "additional_pay_p75": 5,
          "additional_pay_type": "Stock Bonus"
        }
      ],
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-10-11"
    }
  ],
  "total_salary": [
    {
      "title": "Network Manager",
      "salary_p25": 300000,
      "salary_median": 390000,
      "salary_p75": 624000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-07-26"
    },
    {
      "title": "Operations Manager",
      "salary_p25": 632500,
      "salary_median": 960000,
      "salary_p75": 1460000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-08-07"
    },
    {
      "title": "Senior Territory Manager",
      "salary_p25": 476500,
      "salary_median": 573000,
      "salary_p75": 802000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-08-31"
    },
    {
      "title": "Senior Legal Counsel",
      "salary_p25": 2825846,
      "salary_median": 3109423,
      "salary_p75": 3393000,
      "currency": "PHP",
      "pay_period": "ANNUAL",
      "salary_updated_at": "2024-04-01"
    },
    {
      "title": "Plant Shift Head",
      "salary_p25": 299000,
      "salary_median": 465200,
      "salary_p75": 500000,
      "currency": "PHP",
      "pay_period": "ANNUAL",
      "salary_updated_at": "2024-06-29"
    },
    {
      "title": "Plant Manager",
      "salary_p25": 345000,
      "salary_median": 360000,
      "salary_p75": 600000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-02-01"
    },
    {
      "title": "Project Manager",
      "salary_p25": 450002.5,
      "salary_median": 780000,
      "salary_p75": 1200000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-10-11"
    },
    {
      "title": "Territory Manager",
      "salary_p25": 75000,
      "salary_median": 223000,
      "salary_p75": 435000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-08-31"
    },
    {
      "title": "Human Resources Manager",
      "salary_p25": 552000,
      "salary_median": 816000,
      "salary_p75": 1080000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-02-14"
    },
    {
      "title": "Internal Audit Manager",
      "salary_p25": 840000,
      "salary_median": 1050000,
      "salary_p75": 1260000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-05-03"
    },
    {
      "title": "Shift Engineer",
      "salary_p25": 300000,
      "salary_median": 339000,
      "salary_p75": 378000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2022-09-04"
    },
    {
      "title": "Business Development Manager",
      "salary_p25": 507000,
      "salary_median": 727000,
      "salary_p75": 999500,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-06-24"
    },
    {
      "title": "Human Resources Business Partner",
      "salary_p25": 876000,
      "salary_median": 1158000,
      "salary_p75": 1440000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-02-14"
    },
    {
      "title": "IT Specialist",
      "salary_p25": 600000,
      "salary_median": 640000,
      "salary_p75": 680000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2022-08-17"
    },
    {
      "title": "Internship",
      "salary_p25": 116350.8,
      "salary_median": 120048,
      "salary_p75": 123745.2,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-08-06"
    },
    {
      "title": "Department Head",
      "salary_p25": 960000,
      "salary_median": 1200000,
      "salary_p75": 1800000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-12-06"
    },
    {
      "title": "Engineer",
      "salary_p25": 495000,
      "salary_median": 645000,
      "salary_p75": 1155000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-06-12"
    },
    {
      "title": "Section Head",
      "salary_p25": 780000,
      "salary_median": 870000,
      "salary_p75": 960000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2022-09-07"
    },
    {
      "title": "Mechanical Engineer",
      "salary_p25": 300000,
      "salary_median": 360000,
      "salary_p75": 516000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2024-08-25"
    },
    {
      "title": "Key Accounts Manager",
      "salary_p25": 540000,
      "salary_median": 552000,
      "salary_p75": 735000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2023-11-26"
    },
    {
      "title": "Procurement Manager",
      "salary_p25": 760000,
      "salary_median": 880000,
      "salary_p75": 1000000,
      "currency": "PHP",
      "pay_period": "MONTHLY",
      "salary_updated_at": "2021-04-11"
    }
  ],
  "employees_count_breakdown_by_seniority": {
    "employees_count_owner": 1,
    "employees_count_founder": 0,
    "employees_count_clevel": 4,
    "employees_count_partner": 5,
    "employees_count_vp": 0,
    "employees_count_head": 90,
    "employees_count_director": 11,
    "employees_count_manager": 284,
    "employees_count_senior": 74,
    "employees_count_intern": 10,
    "employees_count_specialist": 256,
    "employees_count_other_management": 92
  },
  "employees_count_breakdown_by_department": {
    "employees_count_medical": 2,
    "employees_count_sales": 83,
    "employees_count_hr": 28,
    "employees_count_legal": 21,
    "employees_count_marketing": 12,
    "employees_count_finance": 75,
    "employees_count_technical": 106,
    "employees_count_consulting": 3,
    "employees_count_operations": 173,
    "employees_count_product": 0,
    "employees_count_general_management": 7,
    "employees_count_administrative": 35,
    "employees_count_customer_service": 19,
    "employees_count_project_management": 50,
    "employees_count_design": 2,
    "employees_count_research": 24,
    "employees_count_trades": 18,
    "employees_count_real_estate": 6,
    "employees_count_education": 2,
    "employees_count_other_department": 161
  },
  "employees_count_breakdown_by_region": {
    "employees_count_eastern_europe": 1,
    "employees_count_latin_america": 0,
    "employees_count_southern_europe": 0,
    "employees_count_sub_saharan_africa": 0,
    "employees_count_central_asia": 0,
    "employees_count_northern_america": 4,
    "employees_count_australia_new_zealand": 1,
    "employees_count_northern_europe": 1,
    "employees_count_south_eastern_asia": 814,
    "employees_count_polynesia": 0,
    "employees_count_southern_asia": 1,
    "employees_count_northern_africa": 0,
    "employees_count_melanesia": 0,
    "employees_count_western_europe": 1,
    "employees_count_western_asia": 2,
    "employees_count_eastern_asia": 0,
    "employees_count_micronesia": 0,
    "employees_count_unknown": 2
  },
  "employees_count_by_country": [
    {
      "country": "United States",
      "employee_count": 2
    },
    {
      "country": "Germany",
      "employee_count": 1
    },
    {
      "country": "Saint Pierre and Miquelon",
      "employee_count": 1
    },
    {
      "country": "Vietnam",
      "employee_count": 2
    },
    {
      "country": "United Arab Emirates",
      "employee_count": 1
    },
    {
      "country": "Russia",
      "employee_count": 1
    },
    {
      "country": "Canada",
      "employee_count": 1
    },
    {
      "country": "Australia",
      "employee_count": 1
    },
    {
      "country": "Saudi Arabia",
      "employee_count": 1
    },
    {
      "country": "Indonesia",
      "employee_count": 1
    },
    {
      "country": null,
      "employee_count": 2
    },
    {
      "country": "India",
      "employee_count": 1
    },
    {
      "country": "Philippines",
      "employee_count": 811
    },
    {
      "country": "United Kingdom",
      "employee_count": 1
    }
  ],
  "key_executives": [
    {
      "member_id": 285543078,
      "member_full_name": "*******",
      "member_position_title": "Head Of Project Management Department"
    },
    {
      "member_id": 428974407,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 514973864,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 612830115,
      "member_full_name": "*******",
      "member_position_title": "Corporate Procurement Support Head"
    },
    {
      "member_id": 622364815,
      "member_full_name": "*******",
      "member_position_title": "Technical Standards Section Head, OIC"
    },
    {
      "member_id": 757078415,
      "member_full_name": "*******",
      "member_position_title": "Data Management Analytics Department Head"
    },
    {
      "member_id": 627554327,
      "member_full_name": "*******",
      "member_position_title": "Treasury Operations Head"
    },
    {
      "member_id": 173496914,
      "member_full_name": "*******",
      "member_position_title": "CIO And Group Director Of Business And Technology Services"
    },
    {
      "member_id": 786996281,
      "member_full_name": "*******",
      "member_position_title": "Service Area Head"
    },
    {
      "member_id": 800514549,
      "member_full_name": "*******",
      "member_position_title": "Billing And Collection Section Head"
    },
    {
      "member_id": 193955549,
      "member_full_name": "*******",
      "member_position_title": "Group Director, East Zone Business Operations"
    },
    {
      "member_id": 228994366,
      "member_full_name": "*******",
      "member_position_title": "Network Operations Head"
    },
    {
      "member_id": 287376606,
      "member_full_name": "*******",
      "member_position_title": "CAPEX Accounting And Control Head"
    },
    {
      "member_id": 293197549,
      "member_full_name": "*******",
      "member_position_title": "Procurement Section Head"
    },
    {
      "member_id": 136743645,
      "member_full_name": "*******",
      "member_position_title": "Operations Department Head"
    },
    {
      "member_id": 176108824,
      "member_full_name": "*******",
      "member_position_title": "Asset Reliability Department Departmend Head"
    },
    {
      "member_id": 28158890,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 263360050,
      "member_full_name": "*******",
      "member_position_title": "Director, Regulatory Development"
    },
    {
      "member_id": 44918372,
      "member_full_name": "*******",
      "member_position_title": "Concession Finance Head"
    },
    {
      "member_id": 51774726,
      "member_full_name": "*******",
      "member_position_title": "Business Operations Regulation Department Head"
    },
    {
      "member_id": 291998729,
      "member_full_name": "*******",
      "member_position_title": "HR Business Partner"
    },
    {
      "member_id": 325206973,
      "member_full_name": "*******",
      "member_position_title": "Plant Shift Head"
    },
    {
      "member_id": 53950875,
      "member_full_name": "*******",
      "member_position_title": "Commercial And Contracts Head"
    },
    {
      "member_id": 55357966,
      "member_full_name": "*******",
      "member_position_title": "Project Management Section Head"
    },
    {
      "member_id": 114486748,
      "member_full_name": "*******",
      "member_position_title": "Head Of Property Management"
    },
    {
      "member_id": 340775318,
      "member_full_name": "*******",
      "member_position_title": "Department Head"
    },
    {
      "member_id": 422275638,
      "member_full_name": "*******",
      "member_position_title": "Chief Executive Officer"
    },
    {
      "member_id": 425841567,
      "member_full_name": "*******",
      "member_position_title": "Data Management Analytics Department Head"
    },
    {
      "member_id": 69576061,
      "member_full_name": "*******",
      "member_position_title": "Operational Risk Management Department Head"
    },
    {
      "member_id": 491026735,
      "member_full_name": "*******",
      "member_position_title": "Plant Shift Head"
    },
    {
      "member_id": 132487906,
      "member_full_name": "*******",
      "member_position_title": "Business Continuity Head"
    },
    {
      "member_id": 597282453,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 517579652,
      "member_full_name": "*******",
      "member_position_title": "Facility Maintenance Head"
    },
    {
      "member_id": 223577164,
      "member_full_name": "*******",
      "member_position_title": "Operations Group Director"
    },
    {
      "member_id": 237994546,
      "member_full_name": "*******",
      "member_position_title": "System Operations Head"
    },
    {
      "member_id": 234583675,
      "member_full_name": "*******",
      "member_position_title": "Manager, La Mesa (Dam) Headworks"
    },
    {
      "member_id": 645048378,
      "member_full_name": "*******",
      "member_position_title": "Head Of Procurement"
    },
    {
      "member_id": 139613979,
      "member_full_name": "*******",
      "member_position_title": "CFO Treasurer"
    },
    {
      "member_id": 199433131,
      "member_full_name": "*******",
      "member_position_title": "Head Of Treasury"
    },
    {
      "member_id": 334422135,
      "member_full_name": "*******",
      "member_position_title": "Grid Facilities Head"
    },
    {
      "member_id": 415904961,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 32534361,
      "member_full_name": "*******",
      "member_position_title": "Liquidity Planning And Loans Compliance Head Treasury Department"
    },
    {
      "member_id": 649961176,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 392568103,
      "member_full_name": "*******",
      "member_position_title": "Head Of Project Stakeholder Engagement"
    },
    {
      "member_id": 412925895,
      "member_full_name": "*******",
      "member_position_title": "Treasury - Originations And Dealership Head"
    },
    {
      "member_id": 206849590,
      "member_full_name": "*******",
      "member_position_title": "HR Head, East Zone"
    },
    {
      "member_id": 519611663,
      "member_full_name": "*******",
      "member_position_title": "Primary Network Services Department Head"
    },
    {
      "member_id": 527488178,
      "member_full_name": "*******",
      "member_position_title": "Accounting Business Partner Mgr."
    },
    {
      "member_id": 507353510,
      "member_full_name": "*******",
      "member_position_title": "Human Resources Business Partnership Department Head"
    },
    {
      "member_id": 421563941,
      "member_full_name": "*******",
      "member_position_title": "Service Delivery Governance Head"
    },
    {
      "member_id": 446212615,
      "member_full_name": "*******",
      "member_position_title": "Controlleship And Analysis Department Head"
    },
    {
      "member_id": 446528758,
      "member_full_name": "*******",
      "member_position_title": "Financial Accounting Department Head"
    },
    {
      "member_id": 790659035,
      "member_full_name": "*******",
      "member_position_title": "Plant Shift Head"
    },
    {
      "member_id": 788338292,
      "member_full_name": "*******",
      "member_position_title": "Head Of Strategic Planning"
    },
    {
      "member_id": 788433256,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 455680838,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 804376089,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 591413688,
      "member_full_name": "*******",
      "member_position_title": "Plant Shift Head"
    },
    {
      "member_id": 596053545,
      "member_full_name": "*******",
      "member_position_title": "Corporate Procurement Group Head"
    },
    {
      "member_id": 623901290,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 292754411,
      "member_full_name": "*******",
      "member_position_title": "Head Of Strategic Finance"
    },
    {
      "member_id": 758446292,
      "member_full_name": "*******",
      "member_position_title": "Plant Shift Head"
    },
    {
      "member_id": 757574637,
      "member_full_name": "*******",
      "member_position_title": "Land Acquisition Section Head"
    },
    {
      "member_id": 3548042,
      "member_full_name": "*******",
      "member_position_title": "Strategic Finance Lead"
    },
    {
      "member_id": 347478394,
      "member_full_name": "*******",
      "member_position_title": "Project Management Section Head - Project Planning And Control"
    },
    {
      "member_id": 801496887,
      "member_full_name": "*******",
      "member_position_title": "Commercial And Contracts Head"
    },
    {
      "member_id": 494781250,
      "member_full_name": "*******",
      "member_position_title": "IT Service Management Department Head"
    },
    {
      "member_id": 349896070,
      "member_full_name": "*******",
      "member_position_title": "Financial Accounting Head"
    },
    {
      "member_id": 514651233,
      "member_full_name": "*******",
      "member_position_title": "Plant Shift Head"
    },
    {
      "member_id": 3485178,
      "member_full_name": "*******",
      "member_position_title": "Operation Planning Head"
    },
    {
      "member_id": 121826082,
      "member_full_name": "*******",
      "member_position_title": "Head Of Operations"
    },
    {
      "member_id": 188444299,
      "member_full_name": "*******",
      "member_position_title": "Head Of Sustainability"
    },
    {
      "member_id": 136283631,
      "member_full_name": "*******",
      "member_position_title": "Head Analytical Services"
    },
    {
      "member_id": 169447505,
      "member_full_name": "*******",
      "member_position_title": "Head Of Project Management Department"
    },
    {
      "member_id": 515627019,
      "member_full_name": "*******",
      "member_position_title": "HR Business Partner"
    },
    {
      "member_id": 291342341,
      "member_full_name": "*******",
      "member_position_title": "Regional Operations Group Director"
    },
    {
      "member_id": 57774064,
      "member_full_name": "*******",
      "member_position_title": "Human Resources Business Partner"
    },
    {
      "member_id": 352570357,
      "member_full_name": "*******",
      "member_position_title": "Head Of Department"
    },
    {
      "member_id": 425558382,
      "member_full_name": "*******",
      "member_position_title": "Headworks Manager"
    },
    {
      "member_id": 429633177,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 474463014,
      "member_full_name": "*******",
      "member_position_title": "Plant Head"
    },
    {
      "member_id": 508235862,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 518462734,
      "member_full_name": "*******",
      "member_position_title": "Headworks Manager"
    },
    {
      "member_id": 559281303,
      "member_full_name": "*******",
      "member_position_title": "Boss"
    },
    {
      "member_id": 797984658,
      "member_full_name": "*******",
      "member_position_title": "Business Operations Section Head"
    },
    {
      "member_id": 625611950,
      "member_full_name": "*******",
      "member_position_title": "Human Resources Business Partner"
    },
    {
      "member_id": 178751668,
      "member_full_name": "*******",
      "member_position_title": "Portfolio Management Department Head"
    },
    {
      "member_id": 162267364,
      "member_full_name": "*******",
      "member_position_title": "Head, Compliance Section"
    },
    {
      "member_id": 411594644,
      "member_full_name": "*******",
      "member_position_title": "Program Director"
    },
    {
      "member_id": 167030952,
      "member_full_name": "*******",
      "member_position_title": "Chief Information Officer"
    },
    {
      "member_id": 425553149,
      "member_full_name": "*******",
      "member_position_title": "Enterprise Corporate Human Resources Group Director"
    },
    {
      "member_id": 448114743,
      "member_full_name": "*******",
      "member_position_title": "Deputy Chief Financial Officer"
    },
    {
      "member_id": 212780461,
      "member_full_name": "*******",
      "member_position_title": "Head, Corporate Communications"
    },
    {
      "member_id": 477412087,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 758310559,
      "member_full_name": "*******",
      "member_position_title": "Service Area Head"
    },
    {
      "member_id": 757723965,
      "member_full_name": "*******",
      "member_position_title": "Plant Shift Head"
    },
    {
      "member_id": 762897813,
      "member_full_name": "*******",
      "member_position_title": "Head Of Strategic Planning"
    },
    {
      "member_id": 328439723,
      "member_full_name": "*******",
      "member_position_title": "Department Head"
    },
    {
      "member_id": 424443436,
      "member_full_name": "*******",
      "member_position_title": "Head Of Corporate Communications"
    },
    {
      "member_id": 503949480,
      "member_full_name": "*******",
      "member_position_title": "Director, Technical Services"
    },
    {
      "member_id": 537999388,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 696789047,
      "member_full_name": "*******",
      "member_position_title": "Plant Shift-head"
    },
    {
      "member_id": 759137642,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 614975309,
      "member_full_name": "*******",
      "member_position_title": "Treasury Operations Unit Head"
    },
    {
      "member_id": 756545467,
      "member_full_name": "*******",
      "member_position_title": "Plant Shift Head"
    },
    {
      "member_id": 763285306,
      "member_full_name": "*******",
      "member_position_title": "Procurement Section Head"
    },
    {
      "member_id": 59743460,
      "member_full_name": "*******",
      "member_position_title": "Deputy General Director (Thu Duc Water BOO Corporation)"
    },
    {
      "member_id": 233204095,
      "member_full_name": "*******",
      "member_position_title": "Department Head"
    },
    {
      "member_id": 406873649,
      "member_full_name": "*******",
      "member_position_title": "Inventory Planning Manager - Section Head"
    },
    {
      "member_id": 412005628,
      "member_full_name": "*******",
      "member_position_title": "Shift Head"
    },
    {
      "member_id": 441593817,
      "member_full_name": "*******",
      "member_position_title": "Safety Section Head"
    },
    {
      "member_id": 461516523,
      "member_full_name": "*******",
      "member_position_title": "Shift Head (Desludging)"
    },
    {
      "member_id": 526996146,
      "member_full_name": "*******",
      "member_position_title": "Project Management Director"
    },
    {
      "member_id": 590467770,
      "member_full_name": "*******",
      "member_position_title": "Head Of Financial Planning"
    },
    {
      "member_id": 592879437,
      "member_full_name": "*******",
      "member_position_title": "Operations Technology Head"
    },
    {
      "member_id": 29474555,
      "member_full_name": "*******",
      "member_position_title": "Asset Management Dep't Head"
    },
    {
      "member_id": 647376132,
      "member_full_name": "*******",
      "member_position_title": "Plant Shift Head"
    },
    {
      "member_id": 41006558,
      "member_full_name": "*******",
      "member_position_title": "Head, Property Management"
    },
    {
      "member_id": 43922720,
      "member_full_name": "*******",
      "member_position_title": "People Development And Engagement Department Head"
    },
    {
      "member_id": 51441873,
      "member_full_name": "*******",
      "member_position_title": "Chief Administrative Officer (CAO)"
    },
    {
      "member_id": 69880318,
      "member_full_name": "*******",
      "member_position_title": "Business Operations Section Head"
    },
    {
      "member_id": 80701370,
      "member_full_name": "*******",
      "member_position_title": "Group Head, Corporate Operations"
    },
    {
      "member_id": 438413006,
      "member_full_name": "*******",
      "member_position_title": "CIO And Group Director Of Business And Technology Services"
    },
    {
      "member_id": 592796248,
      "member_full_name": "*******",
      "member_position_title": "Water Treatment Shift Engineer"
    },
    {
      "member_id": 351671152,
      "member_full_name": "*******",
      "member_position_title": "Business Operations Head (Laguna)"
    },
    {
      "member_id": 808607589,
      "member_full_name": "*******",
      "member_position_title": "Plant Shift Head"
    },
    {
      "member_id": 394344714,
      "member_full_name": "*******",
      "member_position_title": "Head Of Project Management Office"
    },
    {
      "member_id": 595370391,
      "member_full_name": "*******",
      "member_position_title": "Plant Shift Head"
    },
    {
      "member_id": 756119920,
      "member_full_name": "*******",
      "member_position_title": "Business Operations Section Head"
    }
  ],
  "key_employee_change_events": [],
  "key_executive_arrivals": [
    {
      "member_id": 55357966,
      "member_full_name": "*******",
      "member_position_title": "Project Management Section Head",
      "arrival_date": "Mar 2025"
    },
    {
      "member_id": 69880318,
      "member_full_name": "*******",
      "member_position_title": "Business Operations Section Head",
      "arrival_date": "Dec 2024"
    },
    {
      "member_id": 805153465,
      "member_full_name": "*******",
      "member_position_title": "Shift Head",
      "arrival_date": "Nov 2024"
    },
    {
      "member_id": 788433256,
      "member_full_name": "*******",
      "member_position_title": "Shift Head",
      "arrival_date": "Nov 2024"
    }
  ],
  "key_executive_departures": [
    {
      "member_id": 641744310,
      "member_full_name": "*******",
      "member_position_title": "Technical Services Department Head",
      "departure_date": "Nov 2024"
    },
    {
      "member_id": 762170394,
      "member_full_name": "*******",
      "member_position_title": "Shift Head",
      "departure_date": "Nov 2024"
    }
  ],
  "employees_count_change": {
    "current": 1686,
    "change_monthly": 10,
    "change_monthly_percentage": 0.5966587112171837,
    "change_quarterly": 30,
    "change_quarterly_percentage": 1.8115942028985508,
    "change_yearly": 123,
    "change_yearly_percentage": 7.869481765834934
  },
  "employees_count_by_month": [
    {
      "employees_count": 1193,
      "date": "2020-02"
    },
    {
      "employees_count": 1156,
      "date": "2020-12"
    },
    {
      "employees_count": 1267,
      "date": "2022-02"
    },
    {
      "employees_count": 1656,
      "date": "2025-01"
    },
    {
      "employees_count": 1262,
      "date": "2019-10"
    },
    {
      "employees_count": 1271,
      "date": "2021-11"
    },
    {
      "employees_count": 1308,
      "date": "2019-12"
    },
    {
      "employees_count": 1262,
      "date": "2019-08"
    },
    {
      "employees_count": 1552,
      "date": "2024-01"
    },
    {
      "employees_count": 1676,
      "date": "2025-03"
    },
    {
      "employees_count": 1550,
      "date": "2024-03"
    },
    {
      "employees_count": 1141,
      "date": "2019-05"
    },
    {
      "employees_count": 1525,
      "date": "2023-08"
    },
    {
      "employees_count": 1620,
      "date": "2024-08"
    },
    {
      "employees_count": 1269,
      "date": "2022-03"
    },
    {
      "employees_count": 1416,
      "date": "2023-03"
    },
    {
      "employees_count": 1406,
      "date": "2023-02"
    },
    {
      "employees_count": 1308,
      "date": "2019-11"
    },
    {
      "employees_count": 1235,
      "date": "2021-03"
    },
    {
      "employees_count": 1273,
      "date": "2021-10"
    },
    {
      "employees_count": 1141,
      "date": "2020-08"
    },
    {
      "employees_count": 1138,
      "date": "2020-09"
    },
    {
      "employees_count": 1148,
      "date": "2020-10"
    },
    {
      "employees_count": 1227,
      "date": "2021-04"
    },
    {
      "employees_count": 1324,
      "date": "2022-06"
    },
    {
      "employees_count": 1379,
      "date": "2022-11"
    },
    {
      "employees_count": 1601,
      "date": "2024-07"
    },
    {
      "employees_count": 1287,
      "date": "2022-04"
    },
    {
      "employees_count": 1141,
      "date": "2019-03"
    },
    {
      "employees_count": 1431,
      "date": "2023-04"
    },
    {
      "employees_count": 1542,
      "date": "2024-02"
    },
    {
      "employees_count": 1207,
      "date": "2020-04"
    },
    {
      "employees_count": 1213,
      "date": "2020-05"
    },
    {
      "employees_count": 1539,
      "date": "2023-09"
    },
    {
      "employees_count": 1563,
      "date": "2024-04"
    },
    {
      "employees_count": 1317,
      "date": "2022-07"
    },
    {
      "employees_count": 1226,
      "date": "2021-06"
    },
    {
      "employees_count": 1137,
      "date": "2020-07"
    },
    {
      "employees_count": 1274,
      "date": "2021-12"
    },
    {
      "employees_count": 1332,
      "date": "2022-08"
    },
    {
      "employees_count": 1586,
      "date": "2024-05"
    },
    {
      "employees_count": 1538,
      "date": "2023-11"
    },
    {
      "employees_count": 1141,
      "date": "2019-04"
    },
    {
      "employees_count": 1374,
      "date": "2022-10"
    },
    {
      "employees_count": 1225,
      "date": "2019-06"
    },
    {
      "employees_count": 1646,
      "date": "2024-12"
    },
    {
      "employees_count": 1240,
      "date": "2019-07"
    },
    {
      "employees_count": 1222,
      "date": "2021-05"
    },
    {
      "employees_count": 1390,
      "date": "2022-12"
    },
    {
      "employees_count": 1340,
      "date": "2022-09"
    },
    {
      "employees_count": 1597,
      "date": "2024-06"
    },
    {
      "employees_count": 1535,
      "date": "2023-10"
    },
    {
      "employees_count": 1141,
      "date": "2019-02"
    },
    {
      "employees_count": 1244,
      "date": "2021-07"
    },
    {
      "employees_count": 1673,
      "date": "2025-02"
    },
    {
      "employees_count": 1214,
      "date": "2020-03"
    },
    {
      "employees_count": 1181,
      "date": "2021-01"
    },
    {
      "employees_count": 1549,
      "date": "2023-12"
    },
    {
      "employees_count": 1141,
      "date": "2019-01"
    },
    {
      "employees_count": 1646,
      "date": "2024-11"
    },
    {
      "employees_count": 1186,
      "date": "2021-02"
    },
    {
      "employees_count": 1475,
      "date": "2023-06"
    },
    {
      "employees_count": 1325,
      "date": "2020-01"
    },
    {
      "employees_count": 1265,
      "date": "2021-08"
    },
    {
      "employees_count": 1135,
      "date": "2020-06"
    },
    {
      "employees_count": 1645,
      "date": "2024-10"
    },
    {
      "employees_count": 1628,
      "date": "2024-09"
    },
    {
      "employees_count": 1147,
      "date": "2020-11"
    },
    {
      "employees_count": 1265,
      "date": "2021-09"
    },
    {
      "employees_count": 1305,
      "date": "2022-05"
    },
    {
      "employees_count": 1400,
      "date": "2023-01"
    },
    {
      "employees_count": 1483,
      "date": "2023-07"
    },
    {
      "employees_count": 1262,
      "date": "2019-09"
    },
    {
      "employees_count": 1449,
      "date": "2023-05"
    },
    {
      "employees_count": 1276,
      "date": "2022-01"
    },
    {
      "employees_count": 1686,
      "date": "2025-04"
    }
  ],
  "professional_network_followers_count_change": {
    "current": 42864,
    "change_monthly": 266,
    "change_monthly_percentage": 0.6244424620874219,
    "change_quarterly": 995,
    "change_quarterly_percentage": 2.376459910673768,
    "change_yearly": 6147,
    "change_yearly_percentage": 16.741563853255986
  },
  "professional_network_followers_count_by_month": [
    {
      "follower_count": 35197,
      "date": "2024-02"
    },
    {
      "follower_count": 13592,
      "date": "2020-12"
    },
    {
      "follower_count": 41869,
      "date": "2025-01"
    },
    {
      "follower_count": 8571,
      "date": "2019-10"
    },
    {
      "follower_count": 17229,
      "date": "2021-11"
    },
    {
      "follower_count": 9530,
      "date": "2019-12"
    },
    {
      "follower_count": 14282,
      "date": "2021-03"
    },
    {
      "follower_count": 12398,
      "date": "2020-08"
    },
    {
      "follower_count": 10214,
      "date": "2020-03"
    },
    {
      "follower_count": 13858,
      "date": "2021-01"
    },
    {
      "follower_count": 33471,
      "date": "2023-12"
    },
    {
      "follower_count": 6365,
      "date": "2019-01"
    },
    {
      "follower_count": 41245,
      "date": "2024-11"
    },
    {
      "follower_count": 13990,
      "date": "2021-02"
    },
    {
      "follower_count": 29059,
      "date": "2023-06"
    },
    {
      "follower_count": 15971,
      "date": "2021-07"
    },
    {
      "follower_count": 16854,
      "date": "2021-10"
    },
    {
      "follower_count": 11629,
      "date": "2020-06"
    },
    {
      "follower_count": 41068,
      "date": "2024-10"
    },
    {
      "follower_count": 40308,
      "date": "2024-09"
    },
    {
      "follower_count": 13024,
      "date": "2020-11"
    },
    {
      "follower_count": 12517,
      "date": "2020-09"
    },
    {
      "follower_count": 12663,
      "date": "2020-10"
    },
    {
      "follower_count": 14699,
      "date": "2021-04"
    },
    {
      "follower_count": 20248,
      "date": "2022-06"
    },
    {
      "follower_count": 24965,
      "date": "2022-11"
    },
    {
      "follower_count": 38788,
      "date": "2024-07"
    },
    {
      "follower_count": 18681,
      "date": "2022-04"
    },
    {
      "follower_count": 6365,
      "date": "2019-03"
    },
    {
      "follower_count": 15390,
      "date": "2021-06"
    },
    {
      "follower_count": 9530,
      "date": "2019-11"
    },
    {
      "follower_count": 35569,
      "date": "2024-03"
    },
    {
      "follower_count": 9723,
      "date": "2020-01"
    },
    {
      "follower_count": 16082,
      "date": "2021-08"
    },
    {
      "follower_count": 6365,
      "date": "2019-05"
    },
    {
      "follower_count": 31664,
      "date": "2023-08"
    },
    {
      "follower_count": 39799,
      "date": "2024-08"
    },
    {
      "follower_count": 11180,
      "date": "2020-05"
    },
    {
      "follower_count": 18428,
      "date": "2022-03"
    },
    {
      "follower_count": 32182,
      "date": "2023-09"
    },
    {
      "follower_count": 26324,
      "date": "2023-02"
    },
    {
      "follower_count": 36717,
      "date": "2024-04"
    },
    {
      "follower_count": 8029,
      "date": "2019-07"
    },
    {
      "follower_count": 14968,
      "date": "2021-05"
    },
    {
      "follower_count": 25714,
      "date": "2022-12"
    },
    {
      "follower_count": 23079,
      "date": "2022-09"
    },
    {
      "follower_count": 38206,
      "date": "2024-06"
    },
    {
      "follower_count": 33168,
      "date": "2023-10"
    },
    {
      "follower_count": 6365,
      "date": "2019-02"
    },
    {
      "follower_count": 10811,
      "date": "2020-04"
    },
    {
      "follower_count": 42233,
      "date": "2025-02"
    },
    {
      "follower_count": 16458,
      "date": "2021-09"
    },
    {
      "follower_count": 19100,
      "date": "2022-05"
    },
    {
      "follower_count": 26200,
      "date": "2023-01"
    },
    {
      "follower_count": 29652,
      "date": "2023-07"
    },
    {
      "follower_count": 42864,
      "date": "2025-04"
    },
    {
      "follower_count": 9893,
      "date": "2020-02"
    },
    {
      "follower_count": 17965,
      "date": "2022-02"
    },
    {
      "follower_count": 8571,
      "date": "2019-09"
    },
    {
      "follower_count": 28315,
      "date": "2023-05"
    },
    {
      "follower_count": 17854,
      "date": "2022-01"
    },
    {
      "follower_count": 21291,
      "date": "2022-07"
    },
    {
      "follower_count": 27261,
      "date": "2023-03"
    },
    {
      "follower_count": 12227,
      "date": "2020-07"
    },
    {
      "follower_count": 17714,
      "date": "2021-12"
    },
    {
      "follower_count": 22334,
      "date": "2022-08"
    },
    {
      "follower_count": 37853,
      "date": "2024-05"
    },
    {
      "follower_count": 8571,
      "date": "2019-08"
    },
    {
      "follower_count": 34432,
      "date": "2024-01"
    },
    {
      "follower_count": 42598,
      "date": "2025-03"
    },
    {
      "follower_count": 23850,
      "date": "2022-10"
    },
    {
      "follower_count": 7888,
      "date": "2019-06"
    },
    {
      "follower_count": 41581,
      "date": "2024-12"
    },
    {
      "follower_count": 32694,
      "date": "2023-11"
    },
    {
      "follower_count": 6365,
      "date": "2019-04"
    },
    {
      "follower_count": 27664,
      "date": "2023-04"
    }
  ],
  "active_job_postings_count_change": {
    "current": 4,
    "change_monthly": 1,
    "change_monthly_percentage": 33.33333333333333,
    "change_quarterly": 4,
    "change_quarterly_percentage": null,
    "change_yearly": 4,
    "change_yearly_percentage": null
  },
  "product_reviews_score_change": null,
  "product_reviews_score_by_month": [],
  "total_website_visits_change": {
    "current": 33300,
    "change_monthly": 3400,
    "change_monthly_percentage": 11.37123745819398,
    "change_quarterly": -5500,
    "change_quarterly_percentage": -14.175257731958762,
    "change_yearly": -37600,
    "change_yearly_percentage": -53.032440056417485
  },
  "total_website_visits_by_month": [
    {
      "total_website_visits": 33300,
      "date": "2025-04"
    },
    {
      "total_website_visits": 65400,
      "date": "2024-12"
    },
    {
      "total_website_visits": 88300,
      "date": "2024-08"
    },
    {
      "total_website_visits": 70900,
      "date": "2024-04"
    },
    {
      "total_website_visits": 70900,
      "date": "2024-05"
    },
    {
      "total_website_visits": 52100,
      "date": "2024-11"
    },
    {
      "total_website_visits": 29900,
      "date": "2025-03"
    },
    {
      "total_website_visits": 38800,
      "date": "2025-01"
    },
    {
      "total_website_visits": 88300,
      "date": "2024-07"
    },
    {
      "total_website_visits": 52700,
      "date": "2024-10"
    },
    {
      "total_website_visits": 88300,
      "date": "2024-09"
    },
    {
      "total_website_visits": 29900,
      "date": "2025-02"
    },
    {
      "total_website_visits": 88300,
      "date": "2024-06"
    }
  ],
  "employee_reviews_score_aggregated_change": {
    "current": 4,
    "change_monthly": -0.09999999999999964,
    "change_quarterly": 0,
    "change_yearly": null
  },
  "employee_reviews_score_aggregated_by_month": [
    {
      "aggregated_score": 0,
      "date": "2023-12"
    },
    {
      "aggregated_score": 3.8,
      "date": "2023-03"
    },
    {
      "aggregated_score": 0,
      "date": "2023-09"
    },
    {
      "aggregated_score": 3.9,
      "date": "2024-11"
    },
    {
      "aggregated_score": 4,
      "date": "2024-12"
    },
    {
      "aggregated_score": 0,
      "date": "2023-06"
    },
    {
      "aggregated_score": 0,
      "date": "2023-07"
    },
    {
      "aggregated_score": 0,
      "date": "2024-01"
    },
    {
      "aggregated_score": 0,
      "date": "2024-02"
    },
    {
      "aggregated_score": 0,
      "date": "2023-10"
    },
    {
      "aggregated_score": 0,
      "date": "2023-11"
    },
    {
      "aggregated_score": 3.8,
      "date": "2024-08"
    },
    {
      "aggregated_score": 3.8,
      "date": "2022-12"
    },
    {
      "aggregated_score": 3.8,
      "date": "2022-10"
    },
    {
      "aggregated_score": 4.1,
      "date": "2025-03"
    },
    {
      "aggregated_score": 3.9,
      "date": "2024-09"
    },
    {
      "aggregated_score": 3.9,
      "date": "2023-04"
    },
    {
      "aggregated_score": 0,
      "date": "2023-05"
    },
    {
      "aggregated_score": 0,
      "date": "2023-08"
    },
    {
      "aggregated_score": 0,
      "date": "2024-03"
    },
    {
      "aggregated_score": 3.8,
      "date": "2024-04"
    },
    {
      "aggregated_score": 3.8,
      "date": "2024-05"
    },
    {
      "aggregated_score": 3.8,
      "date": "2024-07"
    },
    {
      "aggregated_score": 3.9,
      "date": "2022-08"
    },
    {
      "aggregated_score": 4,
      "date": "2025-02"
    },
    {
      "aggregated_score": 4,
      "date": "2025-01"
    },
    {
      "aggregated_score": 4,
      "date": "2025-04"
    },
    {
      "aggregated_score": 3.9,
      "date": "2022-06"
    },
    {
      "aggregated_score": 3.9,
      "date": "2022-09"
    },
    {
      "aggregated_score": 3.8,
      "date": "2022-11"
    },
    {
      "aggregated_score": 3.8,
      "date": "2023-01"
    },
    {
      "aggregated_score": 3.8,
      "date": "2023-02"
    },
    {
      "aggregated_score": 3.9,
      "date": "2022-07"
    },
    {
      "aggregated_score": 3.8,
      "date": "2024-06"
    }
  ],
  "employee_reviews_score_business_outlook_change": {
    "current": 0.74,
    "change_monthly": 0,
    "change_quarterly": 0.040000000000000036,
    "change_yearly": null
  },
  "employee_reviews_score_business_outlook_by_month": [
    {
      "business_outlook_score": 0.87,
      "date": "2023-03"
    },
    {
      "business_outlook_score": 0.74,
      "date": "2025-03"
    },
    {
      "business_outlook_score": 0.88,
      "date": "2023-04"
    },
    {
      "business_outlook_score": 0.73,
      "date": "2025-02"
    },
    {
      "business_outlook_score": 0.66,
      "date": "2024-11"
    },
    {
      "business_outlook_score": 0.72,
      "date": "2024-04"
    },
    {
      "business_outlook_score": 0.66,
      "date": "2024-12"
    },
    {
      "business_outlook_score": 0.72,
      "date": "2024-05"
    },
    {
      "business_outlook_score": 0.72,
      "date": "2024-07"
    },
    {
      "business_outlook_score": 0.7,
      "date": "2025-01"
    },
    {
      "business_outlook_score": 0.72,
      "date": "2024-08"
    },
    {
      "business_outlook_score": 0.85,
      "date": "2022-12"
    },
    {
      "business_outlook_score": 0.74,
      "date": "2025-04"
    },
    {
      "business_outlook_score": 0.79,
      "date": "2022-10"
    },
    {
      "business_outlook_score": 0.82,
      "date": "2022-08"
    },
    {
      "business_outlook_score": 0.77,
      "date": "2024-09"
    },
    {
      "business_outlook_score": 0.74,
      "date": "2022-06"
    },
    {
      "business_outlook_score": 0.82,
      "date": "2022-09"
    },
    {
      "business_outlook_score": 0.79,
      "date": "2022-11"
    },
    {
      "business_outlook_score": 0.86,
      "date": "2023-01"
    },
    {
      "business_outlook_score": 0.86,
      "date": "2023-02"
    },
    {
      "business_outlook_score": 0.74,
      "date": "2022-07"
    },
    {
      "business_outlook_score": 0.72,
      "date": "2024-06"
    }
  ],
  "employee_reviews_score_career_opportunities_change": {
    "current": 4.1,
    "change_monthly": 0.09999999999999964,
    "change_quarterly": 0.19999999999999973,
    "change_yearly": null
  },
  "employee_reviews_score_career_opportunities_by_month": [
    {
      "career_opportunities_score": 3.8,
      "date": "2023-03"
    },
    {
      "career_opportunities_score": 4.1,
      "date": "2025-04"
    },
    {
      "career_opportunities_score": 3.8,
      "date": "2024-08"
    },
    {
      "career_opportunities_score": 3.9,
      "date": "2022-12"
    },
    {
      "career_opportunities_score": 3.8,
      "date": "2024-05"
    },
    {
      "career_opportunities_score": 3.8,
      "date": "2024-07"
    },
    {
      "career_opportunities_score": 3.9,
      "date": "2024-12"
    },
    {
      "career_opportunities_score": 3.9,
      "date": "2022-10"
    },
    {
      "career_opportunities_score": 3.8,
      "date": "2022-08"
    },
    {
      "career_opportunities_score": 4,
      "date": "2024-09"
    },
    {
      "career_opportunities_score": 4,
      "date": "2025-02"
    },
    {
      "career_opportunities_score": 3.8,
      "date": "2024-04"
    },
    {
      "career_opportunities_score": 3.9,
      "date": "2025-01"
    },
    {
      "career_opportunities_score": 3.7,
      "date": "2022-06"
    },
    {
      "career_opportunities_score": 3.8,
      "date": "2022-09"
    },
    {
      "career_opportunities_score": 3.9,
      "date": "2022-11"
    },
    {
      "career_opportunities_score": 3.8,
      "date": "2023-01"
    },
    {
      "career_opportunities_score": 3.9,
      "date": "2023-02"
    },
    {
      "career_opportunities_score": 3.7,
      "date": "2022-07"
    },
    {
      "career_opportunities_score": 3.8,
      "date": "2024-06"
    },
    {
      "career_opportunities_score": 3.9,
      "date": "2024-11"
    },
    {
      "career_opportunities_score": 4,
      "date": "2025-03"
    },
    {
      "career_opportunities_score": 3.8,
      "date": "2023-04"
    }
  ],
  "employee_reviews_score_ceo_approval_change": {
    "current": 0.79,
    "change_monthly": -0.12,
    "change_quarterly": -0.09999999999999998,
    "change_yearly": null
  },
  "employee_reviews_score_ceo_approval_by_month": [
    {
      "ceo_approval_score": 0.87,
      "date": "2024-11"
    },
    {
      "ceo_approval_score": 0.89,
      "date": "2024-12"
    },
    {
      "ceo_approval_score": 0.81,
      "date": "2024-08"
    },
    {
      "ceo_approval_score": 0.96,
      "date": "2022-12"
    },
    {
      "ceo_approval_score": 0.96,
      "date": "2022-10"
    },
    {
      "ceo_approval_score": 0.82,
      "date": "2022-08"
    },
    {
      "ceo_approval_score": 0.97,
      "date": "2023-03"
    },
    {
      "ceo_approval_score": 0.9,
      "date": "2025-02"
    },
    {
      "ceo_approval_score": 0.91,
      "date": "2025-03"
    },
    {
      "ceo_approval_score": 0.81,
      "date": "2024-04"
    },
    {
      "ceo_approval_score": 0.81,
      "date": "2024-05"
    },
    {
      "ceo_approval_score": 0.81,
      "date": "2024-07"
    },
    {
      "ceo_approval_score": 0.98,
      "date": "2023-04"
    },
    {
      "ceo_approval_score": 0.79,
      "date": "2025-04"
    },
    {
      "ceo_approval_score": 0.89,
      "date": "2025-01"
    },
    {
      "ceo_approval_score": 0.85,
      "date": "2022-06"
    },
    {
      "ceo_approval_score": 0.96,
      "date": "2022-09"
    },
    {
      "ceo_approval_score": 0.96,
      "date": "2022-11"
    },
    {
      "ceo_approval_score": 0.97,
      "date": "2023-01"
    },
    {
      "ceo_approval_score": 0.97,
      "date": "2023-02"
    },
    {
      "ceo_approval_score": 0.85,
      "date": "2022-07"
    },
    {
      "ceo_approval_score": 0.86,
      "date": "2024-09"
    },
    {
      "ceo_approval_score": 0.81,
      "date": "2024-06"
    }
  ],
  "employee_reviews_score_compensation_benefits_change": {
    "current": 4.2,
    "change_monthly": 0.10000000000000053,
    "change_quarterly": 0.20000000000000018,
    "change_yearly": null
  },
  "employee_reviews_score_compensation_benefits_by_month": [
    {
      "compensation_benefits_score": 4,
      "date": "2024-12"
    },
    {
      "compensation_benefits_score": 4.2,
      "date": "2023-04"
    },
    {
      "compensation_benefits_score": 4,
      "date": "2022-06"
    },
    {
      "compensation_benefits_score": 4.3,
      "date": "2022-09"
    },
    {
      "compensation_benefits_score": 4.2,
      "date": "2025-04"
    },
    {
      "compensation_benefits_score": 3.9,
      "date": "2024-11"
    },
    {
      "compensation_benefits_score": 4,
      "date": "2025-01"
    },
    {
      "compensation_benefits_score": 4.1,
      "date": "2025-03"
    },
    {
      "compensation_benefits_score": 4.3,
      "date": "2022-08"
    },
    {
      "compensation_benefits_score": 4.3,
      "date": "2022-11"
    },
    {
      "compensation_benefits_score": 4.2,
      "date": "2023-01"
    },
    {
      "compensation_benefits_score": 3.8,
      "date": "2024-04"
    },
    {
      "compensation_benefits_score": 3.8,
      "date": "2024-05"
    },
    {
      "compensation_benefits_score": 3.8,
      "date": "2024-07"
    },
    {
      "compensation_benefits_score": 4.2,
      "date": "2023-02"
    },
    {
      "compensation_benefits_score": 4,
      "date": "2022-07"
    },
    {
      "compensation_benefits_score": 4.1,
      "date": "2025-02"
    },
    {
      "compensation_benefits_score": 4.2,
      "date": "2023-03"
    },
    {
      "compensation_benefits_score": 3.8,
      "date": "2024-06"
    },
    {
      "compensation_benefits_score": 3.9,
      "date": "2024-09"
    },
    {
      "compensation_benefits_score": 3.8,
      "date": "2024-08"
    },
    {
      "compensation_benefits_score": 4.3,
      "date": "2022-12"
    },
    {
      "compensation_benefits_score": 4.3,
      "date": "2022-10"
    }
  ],
  "employee_reviews_score_culture_values_change": {
    "current": 4,
    "change_monthly": 0.10000000000000009,
    "change_quarterly": 0.2999999999999998,
    "change_yearly": null
  },
  "employee_reviews_score_culture_values_by_month": [
    {
      "culture_values_score": 3.8,
      "date": "2022-10"
    },
    {
      "culture_values_score": 3.8,
      "date": "2023-03"
    },
    {
      "culture_values_score": 3.6,
      "date": "2024-11"
    },
    {
      "culture_values_score": 3.7,
      "date": "2024-12"
    },
    {
      "culture_values_score": 4,
      "date": "2025-04"
    },
    {
      "culture_values_score": 3.8,
      "date": "2023-02"
    },
    {
      "culture_values_score": 3.7,
      "date": "2022-07"
    },
    {
      "culture_values_score": 3.8,
      "date": "2023-04"
    },
    {
      "culture_values_score": 3.8,
      "date": "2022-11"
    },
    {
      "culture_values_score": 3.8,
      "date": "2023-01"
    },
    {
      "culture_values_score": 3.9,
      "date": "2025-03"
    },
    {
      "culture_values_score": 3.3,
      "date": "2024-04"
    },
    {
      "culture_values_score": 3.5,
      "date": "2024-09"
    },
    {
      "culture_values_score": 3.3,
      "date": "2024-06"
    },
    {
      "culture_values_score": 3.3,
      "date": "2024-05"
    },
    {
      "culture_values_score": 3.3,
      "date": "2024-07"
    },
    {
      "culture_values_score": 3.7,
      "date": "2025-01"
    },
    {
      "culture_values_score": 3.3,
      "date": "2024-08"
    },
    {
      "culture_values_score": 3.8,
      "date": "2022-12"
    },
    {
      "culture_values_score": 3.8,
      "date": "2022-08"
    },
    {
      "culture_values_score": 3.7,
      "date": "2025-02"
    },
    {
      "culture_values_score": 3.7,
      "date": "2022-06"
    },
    {
      "culture_values_score": 3.8,
      "date": "2022-09"
    }
  ],
  "employee_reviews_score_diversity_inclusion_change": {
    "current": 4.2,
    "change_monthly": 0,
    "change_quarterly": 0.20000000000000018,
    "change_yearly": null
  },
  "employee_reviews_score_diversity_inclusion_by_month": [
    {
      "diversity_inclusion_score": 3.6,
      "date": "2023-03"
    },
    {
      "diversity_inclusion_score": 4.2,
      "date": "2025-03"
    },
    {
      "diversity_inclusion_score": 3.6,
      "date": "2023-04"
    },
    {
      "diversity_inclusion_score": 3.9,
      "date": "2024-11"
    },
    {
      "diversity_inclusion_score": 4,
      "date": "2024-12"
    },
    {
      "diversity_inclusion_score": 3.5,
      "date": "2022-08"
    },
    {
      "diversity_inclusion_score": 4.1,
      "date": "2025-02"
    },
    {
      "diversity_inclusion_score": 4,
      "date": "2025-01"
    },
    {
      "diversity_inclusion_score": 3.6,
      "date": "2024-04"
    },
    {
      "diversity_inclusion_score": 3.7,
      "date": "2024-09"
    },
    {
      "diversity_inclusion_score": 3.6,
      "date": "2024-05"
    },
    {
      "diversity_inclusion_score": 3.6,
      "date": "2024-07"
    },
    {
      "diversity_inclusion_score": 4.2,
      "date": "2025-04"
    },
    {
      "diversity_inclusion_score": 3.6,
      "date": "2024-08"
    },
    {
      "diversity_inclusion_score": 3.6,
      "date": "2022-12"
    },
    {
      "diversity_inclusion_score": 3.6,
      "date": "2022-06"
    },
    {
      "diversity_inclusion_score": 3.5,
      "date": "2022-09"
    },
    {
      "diversity_inclusion_score": 3.7,
      "date": "2022-11"
    },
    {
      "diversity_inclusion_score": 3.6,
      "date": "2023-01"
    },
    {
      "diversity_inclusion_score": 3.6,
      "date": "2023-02"
    },
    {
      "diversity_inclusion_score": 3.6,
      "date": "2022-07"
    },
    {
      "diversity_inclusion_score": 3.7,
      "date": "2022-10"
    },
    {
      "diversity_inclusion_score": 3.6,
      "date": "2024-06"
    }
  ],
  "employee_reviews_score_recommend_change": {
    "current": 0.84,
    "change_monthly": 0.020000000000000018,
    "change_quarterly": 0.04999999999999993,
    "change_yearly": null
  },
  "employee_reviews_score_recommend_by_month": [
    {
      "recommend_score": 0.75,
      "date": "2023-03"
    },
    {
      "recommend_score": 0.77,
      "date": "2024-12"
    },
    {
      "recommend_score": 0.87,
      "date": "2022-08"
    },
    {
      "recommend_score": 0.84,
      "date": "2025-04"
    },
    {
      "recommend_score": 0.82,
      "date": "2022-06"
    },
    {
      "recommend_score": 0.87,
      "date": "2022-09"
    },
    {
      "recommend_score": 0.82,
      "date": "2025-03"
    },
    {
      "recommend_score": 0.77,
      "date": "2023-04"
    },
    {
      "recommend_score": 0.75,
      "date": "2024-04"
    },
    {
      "recommend_score": 0.79,
      "date": "2025-01"
    },
    {
      "recommend_score": 0.75,
      "date": "2024-06"
    },
    {
      "recommend_score": 0.77,
      "date": "2024-11"
    },
    {
      "recommend_score": 0.82,
      "date": "2022-11"
    },
    {
      "recommend_score": 0.74,
      "date": "2023-01"
    },
    {
      "recommend_score": 0.82,
      "date": "2022-10"
    },
    {
      "recommend_score": 0.8,
      "date": "2024-09"
    },
    {
      "recommend_score": 0.75,
      "date": "2024-08"
    },
    {
      "recommend_score": 0.88,
      "date": "2022-12"
    },
    {
      "recommend_score": 0.74,
      "date": "2023-02"
    },
    {
      "recommend_score": 0.82,
      "date": "2022-07"
    },
    {
      "recommend_score": 0.81,
      "date": "2025-02"
    },
    {
      "recommend_score": 0.75,
      "date": "2024-05"
    },
    {
      "recommend_score": 0.75,
      "date": "2024-07"
    }
  ],
  "employee_reviews_score_senior_management_change": {
    "current": 3.6,
    "change_monthly": 0.10000000000000009,
    "change_quarterly": 0.30000000000000027,
    "change_yearly": null
  },
  "employee_reviews_score_senior_management_by_month": [
    {
      "senior_management_score": 3.5,
      "date": "2023-03"
    },
    {
      "senior_management_score": 3.3,
      "date": "2025-01"
    },
    {
      "senior_management_score": 3.5,
      "date": "2022-06"
    },
    {
      "senior_management_score": 3.6,
      "date": "2022-09"
    },
    {
      "senior_management_score": 3.6,
      "date": "2025-04"
    },
    {
      "senior_management_score": 3.4,
      "date": "2024-12"
    },
    {
      "senior_management_score": 3.6,
      "date": "2022-11"
    },
    {
      "senior_management_score": 3.6,
      "date": "2023-01"
    },
    {
      "senior_management_score": 3.6,
      "date": "2023-02"
    },
    {
      "senior_management_score": 3.5,
      "date": "2022-07"
    },
    {
      "senior_management_score": 3.2,
      "date": "2024-11"
    },
    {
      "senior_management_score": 2.9,
      "date": "2024-04"
    },
    {
      "senior_management_score": 3.5,
      "date": "2023-04"
    },
    {
      "senior_management_score": 3.1,
      "date": "2024-09"
    },
    {
      "senior_management_score": 2.9,
      "date": "2024-05"
    },
    {
      "senior_management_score": 2.9,
      "date": "2024-07"
    },
    {
      "senior_management_score": 2.9,
      "date": "2024-08"
    },
    {
      "senior_management_score": 3.6,
      "date": "2022-12"
    },
    {
      "senior_management_score": 3.6,
      "date": "2022-10"
    },
    {
      "senior_management_score": 2.9,
      "date": "2024-06"
    },
    {
      "senior_management_score": 3.5,
      "date": "2025-03"
    },
    {
      "senior_management_score": 3.6,
      "date": "2022-08"
    },
    {
      "senior_management_score": 3.4,
      "date": "2025-02"
    }
  ],
  "employee_reviews_score_work_life_balance_change": {
    "current": 3.5,
    "change_monthly": -0.10000000000000009,
    "change_quarterly": 0,
    "change_yearly": null
  },
  "employee_reviews_score_work_life_balance_by_month": [
    {
      "work_life_balance_score": 3,
      "date": "2023-03"
    },
    {
      "work_life_balance_score": 3,
      "date": "2024-09"
    },
    {
      "work_life_balance_score": 3,
      "date": "2022-10"
    },
    {
      "work_life_balance_score": 3.5,
      "date": "2025-01"
    },
    {
      "work_life_balance_score": 2.8,
      "date": "2024-04"
    },
    {
      "work_life_balance_score": 3.6,
      "date": "2025-03"
    },
    {
      "work_life_balance_score": 3.5,
      "date": "2025-04"
    },
    {
      "work_life_balance_score": 3.2,
      "date": "2024-11"
    },
    {
      "work_life_balance_score": 3.3,
      "date": "2024-12"
    },
    {
      "work_life_balance_score": 2.8,
      "date": "2024-05"
    },
    {
      "work_life_balance_score": 2.8,
      "date": "2024-07"
    },
    {
      "work_life_balance_score": 3.3,
      "date": "2023-04"
    },
    {
      "work_life_balance_score": 3,
      "date": "2022-08"
    },
    {
      "work_life_balance_score": 2.8,
      "date": "2024-08"
    },
    {
      "work_life_balance_score": 3.1,
      "date": "2022-12"
    },
    {
      "work_life_balance_score": 3,
      "date": "2022-06"
    },
    {
      "work_life_balance_score": 3,
      "date": "2022-09"
    },
    {
      "work_life_balance_score": 2.8,
      "date": "2024-06"
    },
    {
      "work_life_balance_score": 3.4,
      "date": "2025-02"
    },
    {
      "work_life_balance_score": 3,
      "date": "2022-11"
    },
    {
      "work_life_balance_score": 3,
      "date": "2023-01"
    },
    {
      "work_life_balance_score": 3,
      "date": "2023-02"
    },
    {
      "work_life_balance_score": 3,
      "date": "2022-07"
    }
  ],
  "expired_domain": 0,
  "unique_domain": 1,
  "unique_website": 1,
  "last_updated_at": "2025-04-01",
  "created_at": "2016-06-23",
  "industry_group_1": "Utilities",
  "industry_group_2": null
}