西ヨーロッパの水道会社のリスト

[
  {
    "name": "Syndicat des Eaux et de l'Assainissement Alsace-Moselle (SDEA)",
    "address": "43**********",
    "phone": "********9 99",
    "email": "ac**********@sd*****",
    "lat": 48.7553887,
    "lng": 7.589113,
    "url": "ht**********",
    "country": "France",
    "state": "Grand Est",
    "city": "Hochfelden",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Berliner Wasserbetriebe",
    "address": "Ho**********",
    "phone": "********7587",
    "email": "bw*@ra**********",
    "lat": 52.5108953,
    "lng": 13.4280215,
    "url": "ht**********",
    "country": "Germany",
    "state": "Berlin",
    "city": "Berlin",
    "star_count": 1,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Water Information Center DEW21",
    "address": "Zu**********",
    "phone": "********5210",
    "email": "ku****@de******",
    "lat": 51.4592536,
    "lng": 7.6360392,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Iserlohn",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "N.V. Waterbedrijf Groningen",
    "address": "Bo**********",
    "phone": "********8688",
    "email": "in**@wa**********",
    "lat": 52.9627974,
    "lng": 7.1354401,
    "url": "ht**********",
    "country": "Netherlands",
    "state": "Groningen",
    "city": "Westerwolde",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Berliner Wasserbetriebe (Rohrnetzbetriebsstelle Jungfernheide)",
    "address": "Mo**********",
    "phone": "********7587",
    "email": "bw*@ra**********",
    "lat": 52.5342264,
    "lng": 13.2606932,
    "url": "ht**********",
    "country": "Germany",
    "state": "Berlin",
    "city": "Berlin",
    "star_count": 4.7,
    "rating_count": 49,
    "category_name": "Water utility companies"
  },
  {
    "name": "Syndicat des Eaux et de l'Assainissement Alsace-Moselle (SDEA)",
    "address": "2 **********",
    "phone": "********9 19",
    "email": "ac**********@sd*****",
    "lat": 48.5326831,
    "lng": 7.4986826,
    "url": "ht**********",
    "country": "France",
    "state": "Grand Est",
    "city": "Dorlisheim",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Water utility companies"
  },
  {
    "name": "Stadtwerke Düsseldorf",
    "address": "Hö**********",
    "phone": "********1821",
    "email": "en**********@sw*******",
    "lat": 51.2226719,
    "lng": 6.8131093,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": null,
    "star_count": 4.2,
    "rating_count": 1410,
    "category_name": "Electric utility companies,Electric Consultants,Water utility companies,Gas companies,Gas Agencies,Public works departments"
  },
  {
    "name": "Service des Eaux - Ville de Luxembourg",
    "address": "33**********",
    "phone": "********8 83",
    "email": "ad**********@vd****",
    "lat": 49.6279851,
    "lng": 6.1115694,
    "url": "ht**********",
    "country": "Luxembourg",
    "state": "Canton of Luxembourg",
    "city": "Luxembourg",
    "star_count": 4.3,
    "rating_count": 6,
    "category_name": "Water utility companies,Water works"
  },
  {
    "name": "Dunea Duin & Water",
    "address": "Pl**********",
    "phone": "********4747",
    "email": "za******@du******",
    "lat": 52.0465266,
    "lng": 4.4757968,
    "url": "ht**********",
    "country": "Netherlands",
    "state": "South Holland",
    "city": "Zoetermeer",
    "star_count": 2.8,
    "rating_count": 41,
    "category_name": "Water utility companies"
  },
  {
    "name": "Vitens",
    "address": "Os**********",
    "phone": "********0359",
    "email": "Ri**********@vi*******",
    "lat": 52.3669955,
    "lng": 5.5447423,
    "url": "ht**********",
    "country": "Netherlands",
    "state": "Flevoland",
    "city": "Zeewolde",
    "star_count": 1.8,
    "rating_count": 5,
    "category_name": "Water utility companies"
  }
]