アフリカの水道会社のリスト

[
  {
    "name": "DAWASA TEGETA",
    "address": "95**********",
    "phone": "********0064",
    "email": "in**@da**********",
    "lat": -6.6447118,
    "lng": 39.1690117,
    "url": "ht**********",
    "country": "Tanzania",
    "state": "Dar es Salaam Region",
    "city": "Dar es Salaam",
    "star_count": 3.3,
    "rating_count": 14,
    "category_name": "Water utility companies"
  },
  {
    "name": "EWASCO",
    "address": "",
    "phone": "********1984",
    "email": "in**@em**********",
    "lat": -0.5365621,
    "lng": 37.4607537,
    "url": "ht**********",
    "country": "Kenya",
    "state": "Embu County",
    "city": "Embu",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Companies,Water utility companies,Service establishments"
  },
  {
    "name": "Lydec Agency Ghandi",
    "address": "An**********",
    "phone": "********2020",
    "email": "co*****@ly*********",
    "lat": 33.5729117,
    "lng": -7.648208,
    "url": "ht**********",
    "country": "Morocco",
    "state": "Casablanca-Settat",
    "city": "Casablanca",
    "star_count": 2.6,
    "rating_count": 279,
    "category_name": "Water utility companies,Electric Consultants,Electric utility companies,Sanitation services"
  },
  {
    "name": "Société Togolaise des Eaux-TdE ( agence de Hedzranawoe )",
    "address": "Je**********",
    "phone": "********3000",
    "email": "in**@td****",
    "lat": 6.1891928,
    "lng": 1.2371779,
    "url": "ht**********",
    "country": "Togo",
    "state": "Maritime",
    "city": null,
    "star_count": 2.5,
    "rating_count": 2,
    "category_name": "Water utility companies"
  },
  {
    "name": "Magalies Water",
    "address": "38**********",
    "phone": "********4636",
    "email": "in**@ma**********",
    "lat": -25.6713053,
    "lng": 27.2375695,
    "url": "ht**********",
    "country": "South Africa",
    "state": "North West",
    "city": "Rustenburg",
    "star_count": 2.5,
    "rating_count": 4,
    "category_name": "Water utility companies"
  },
  {
    "name": "FIPAG Hokwe by FerBerMun",
    "address": "75**********",
    "phone": "********3441",
    "email": "su*****@so**********",
    "lat": -24.7078908,
    "lng": 33.1807591,
    "url": "ht**********",
    "country": "Mozambique",
    "state": "Gaza Province",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Sanitary Drainage Authority for Greater Cairo",
    "address": "36**********",
    "phone": "********2937",
    "email": "co*****@ex*********",
    "lat": 30.0582808,
    "lng": 31.2430601,
    "url": "ht**********",
    "country": "Egypt",
    "state": "Cairo Governorate",
    "city": "Cairo",
    "star_count": 3.4,
    "rating_count": 43,
    "category_name": "Water utility companies"
  },
  {
    "name": "RADEEO Siège",
    "address": "Ha**********",
    "phone": "********1406",
    "email": "ra****@ra*******",
    "lat": 34.6566848,
    "lng": -1.9078817,
    "url": "ht**********",
    "country": "Morocco",
    "state": "Oriental",
    "city": null,
    "star_count": 2.1,
    "rating_count": 17,
    "category_name": "Water utility companies"
  },
  {
    "name": "Brains at work Consulting (Private) Limited",
    "address": "3 **********",
    "phone": "********3679",
    "email": "in**@br**********",
    "lat": -20.1838555,
    "lng": 28.5842437,
    "url": "ht**********",
    "country": "Zimbabwe",
    "state": "Bulawayo Province",
    "city": "Bulawayo",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Water utility companies,3D printing services"
  },
  {
    "name": "Pump Tech Limited",
    "address": "C5**********",
    "phone": "********8400",
    "email": "in**@pu**********",
    "lat": 9.4220953,
    "lng": -0.8419844,
    "url": "ht**********",
    "country": "Ghana",
    "state": "Northern Region",
    "city": "Tamale",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Water utility companies"
  }
]