List of Water utility companies in North Rhine-Westphalia

[
  {
    "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": "Stadtwerke Herford GmbH Kundenzentrum Hiddenhausen",
    "address": "Am**********",
    "phone": "********2590",
    "email": "in**@st**********",
    "lat": 52.1522,
    "lng": 8.6383899,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Hiddenhausen",
    "star_count": 3.8,
    "rating_count": 4,
    "category_name": "Water utility companies,Gas companies,Gas Agencies"
  },
  {
    "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": "Stadtwerke Hattingen GmbH: Kundenzentrum",
    "address": "He**********",
    "phone": "********0155",
    "email": "ku**********@st**********",
    "lat": 51.3991045,
    "lng": 7.1839138,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Hattingen",
    "star_count": 4.4,
    "rating_count": 7,
    "category_name": "Water utility companies,Electric Consultants,Solar photovoltaic power plants,Public works departments,Gas companies,Electric utility companies,Gas Agencies"
  },
  {
    "name": "evd energieversorgung dormagen gmbh",
    "address": "Ma**********",
    "phone": "********9710",
    "email": "en*****@ev**********",
    "lat": 51.093388,
    "lng": 6.820007,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Dormagen",
    "star_count": 3.3,
    "rating_count": 113,
    "category_name": "Electric Consultants,Energy equipment and solutions,Water utility companies,Green energy suppliers,Electric utility companies,Gas companies,Gas Agencies"
  },
  {
    "name": "Stadtwerke Hilden GmbH",
    "address": "Am**********",
    "phone": "********5555",
    "email": "ku**********@st**********",
    "lat": 51.1666966,
    "lng": 6.9403464,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Hilden",
    "star_count": 2.7,
    "rating_count": 57,
    "category_name": "Public works departments,Telecommunications service providers,Gas Agencies,Tele Service Companies,Gas companies,Water utility companies,Electric utility companies,Electric Consultants"
  },
  {
    "name": "Aggerverband",
    "address": "So**********",
    "phone": "******** 360",
    "email": "in**@ag**********",
    "lat": 51.0079956,
    "lng": 7.581212,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Gummersbach",
    "star_count": 4.8,
    "rating_count": 4,
    "category_name": "Water utility companies,Water works equipment suppliers,Water treatment plants"
  },
  {
    "name": "Stadtwerke Meerbusch (Service Center)",
    "address": "Am**********",
    "phone": "********7333",
    "email": "ku**********@st********",
    "lat": 51.2514622,
    "lng": 6.6912237,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Meerbusch",
    "star_count": 3.1,
    "rating_count": 9,
    "category_name": "Electric Consultants,Water utility companies,Heating equipment suppliers,Gas Agencies,Solar energy system services,Electric utility companies,Gas companies,Public works departments"
  },
  {
    "name": "NGN NETZGESELLSCHAFT NIEDERRHEIN MBH",
    "address": "St**********",
    "phone": "********3000",
    "email": "ne**********@ng********",
    "lat": 51.3280985,
    "lng": 6.5404282,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Krefeld",
    "star_count": 1.8,
    "rating_count": 70,
    "category_name": "Gas companies,Gas Agencies,Electric Consultants,Electric utility companies,Water utility companies"
  },
  {
    "name": "Stadtwerke Essen AG",
    "address": "Rü**********",
    "phone": "********8000",
    "email": "ku**********@st**********",
    "lat": 51.4416034,
    "lng": 7.0068256,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Essen",
    "star_count": 2.1,
    "rating_count": 123,
    "category_name": "Gas Agencies,Water utility companies,Electric utility companies,Gas companies,Public works departments,Electric Consultants"
  }
]