[{"name": "Sandra Hanmer", "elected_office": "Councillor", "party_name": null, "email": "sandra.hanmer@waterloo.ca", "photo_url": "https://maps.waterloo.ca/Images/Councillors/Councillor Hanmer Official Picture.jpg", "personal_url": "https://sandrahanmer.ca/", "gender": null, "offices": "[{\"type\": \"legislature\", \"tel\": \"1 519 747-8784\", \"fax\": \"1 519 747-8500\"}]", "extra": "{}", "source_url": "http://opendata-city-of-waterloo.opendata.arcgis.com/datasets/594698f0bbcd4c20b72977194d2b97b8_0.csv", "url": "https://www.waterloo.ca/en/government/city-council.aspx#Ward-1-councillor-Sandra-Hanmer", "district_name": "Ward 1", "district_id": "1"}, {"name": "Diane Freeman", "elected_office": "Councillor", "party_name": null, "email": "diane.freeman@waterloo.ca", "photo_url": "https://maps.waterloo.ca/Images/Councillors/Councillor Freeman Official Picture.jpg", "personal_url": "http://www.dianefreeman.ca/", "gender": null, "offices": "[{\"type\": \"legislature\", \"tel\": \"1 519 747-8784\", \"fax\": \"1 519 747-8500\"}]", "extra": "{\"facebook\": \"https://www.facebook.com/Diane-Freeman-Ward-4-City-Councillor-Waterloo-140698609306535/\", \"twitter\": \"https://twitter.com/DianeLFreeman\"}", "source_url": "http://opendata-city-of-waterloo.opendata.arcgis.com/datasets/594698f0bbcd4c20b72977194d2b97b8_0.csv", "url": "https://www.waterloo.ca/en/government/city-council.aspx#Ward-4-councillor-Diane-Freeman", "district_name": "Ward 4", "district_id": "4"}, {"name": "Mary Lou Roe", "elected_office": "Councillor", "party_name": null, "email": "marylou.roe@waterloo.ca", "photo_url": "https://maps.waterloo.ca/Images/Councillors/Councillor Roe Official Picture.jpg", "personal_url": "https://marylouroe.ca/", "gender": null, "offices": "[{\"type\": \"legislature\", \"tel\": \"1 519 747-8784\", \"fax\": \"1 519 747-8500\"}]", "extra": "{\"facebook\": \"https://m.facebook.com/marylouroe/\", \"twitter\": \"https://twitter.com/Mary_Lou_Roe\"}", "source_url": "http://opendata-city-of-waterloo.opendata.arcgis.com/datasets/594698f0bbcd4c20b72977194d2b97b8_0.csv", "url": "https://www.waterloo.ca/en/government/city-council.aspx#Ward-6-councillor-Mary-Lou-Roe", "district_name": "Ward 6", "district_id": "6"}, {"name": "Julie Wright", "elected_office": "Councillor", "party_name": null, "email": "julie.wright@waterloo.ca", "photo_url": "https://maps.waterloo.ca/Images/Councillors/Councillor Wright Official Picture.jpg", "personal_url": "https://www.wrightward7.com/", "gender": null, "offices": "[{\"type\": \"legislature\", \"tel\": \"1 519 747-8784\", \"fax\": \"1 519 747-8500\"}]", "extra": "{\"twitter\": \"https://twitter.com/wrightward7\"}", "source_url": "http://opendata-city-of-waterloo.opendata.arcgis.com/datasets/594698f0bbcd4c20b72977194d2b97b8_0.csv", "url": "https://www.waterloo.ca/en/government/city-council.aspx#Ward-7-councillor-Julie-Wright", "district_name": "Ward 7", "district_id": "7"}, {"name": "Dorothy McCabe", "elected_office": "Mayor", "party_name": null, "email": "mayor@waterloo.ca", "photo_url": "https://www.waterloo.ca/en/government/resources/Images/Council/Mayor-McCabe.jpg", "personal_url": "https://mccabe4mayor.ca/", "gender": null, "offices": "[{\"type\": \"legislature\", \"tel\": \"1 519 747-8700\", \"fax\": \"1 519 747-8500\"}]", "extra": "{\"twitter\": \"https://twitter.com/DorothyMcCabe\"}", "source_url": "http://opendata-city-of-waterloo.opendata.arcgis.com/datasets/594698f0bbcd4c20b72977194d2b97b8_0.csv", "url": "https://www.waterloo.ca/en/government/city-council.aspx#Mayor-Dorothy-McCabe", "district_name": "Waterloo", "boundary_url": "/boundaries/census-subdivisions/3530016/"}, {"name": "Royce Bodaly", "elected_office": "Councillor", "party_name": null, "email": "royce.bodaly@waterloo.ca", "photo_url": "https://maps.waterloo.ca/Images/Councillors/Councillor Bodaly Official Picture.jpg", "personal_url": "https://www.roycebodaly.ca/", "gender": null, "offices": "[{\"type\": \"legislature\", \"tel\": \"1 519 747-8784\", \"fax\": \"1 519 747-8500\"}]", "extra": "{\"facebook\": \"https://www.facebook.com/roycebodalyward2/\", \"twitter\": \"https://twitter.com/RoyceBodaly\"}", "source_url": "http://opendata-city-of-waterloo.opendata.arcgis.com/datasets/594698f0bbcd4c20b72977194d2b97b8_0.csv", "url": "https://www.waterloo.ca/en/government/city-council.aspx#Ward-2-councillor-Royce-Bodaly", "district_name": "Ward 2", "district_id": "2"}, {"name": "Jen Vasic", "elected_office": "Councillor", "party_name": null, "email": "jen.vasic@waterloo.ca", "photo_url": "https://maps.waterloo.ca/Images/Councillors/Councillor Jen Vasic Official Picture.jpg", "personal_url": "https://jenvasicwaterloo.ca/", "gender": null, "offices": "[{\"type\": \"legislature\", \"tel\": \"1 519 747-8784\", \"fax\": \"1 519 747-8500\"}]", "extra": "{\"facebook\": \"https://www.facebook.com/jenvasic/\", \"twitter\": \"https://twitter.com/jenvasic\"}", "source_url": "http://opendata-city-of-waterloo.opendata.arcgis.com/datasets/594698f0bbcd4c20b72977194d2b97b8_0.csv", "url": "https://www.waterloo.ca/en/government/city-council.aspx#Ward-5-councillor-Jen-Vasic", "district_name": "Ward 5", "district_id": "5"}, {"name": "Hans Roach", "elected_office": "Councillor", "party_name": null, "email": "hans.roach@waterloo.ca", "photo_url": "https://maps.waterloo.ca/Images/Councillors/Councillor Roach Official Picture.jpg", "personal_url": "https://www.hansroachwaterloo.com/", "gender": null, "offices": "[{\"type\": \"legislature\", \"tel\": \"1 519 747-8784\", \"fax\": \"1 519 747-8500\"}]", "extra": "{\"twitter\": \"https://twitter.com/hans__roach\"}", "source_url": "http://opendata-city-of-waterloo.opendata.arcgis.com/datasets/594698f0bbcd4c20b72977194d2b97b8_0.csv", "url": "https://www.waterloo.ca/en/government/city-council.aspx#Ward-3-councillor-Hans-Roach", "district_name": "Ward 3", "district_id": "3"}]