List of Drinking water fountains in Germany

[
  {
    "name": "trinks",
    "address": "Ba**********",
    "phone": "********8485",
    "email": "ch**********@tr*******",
    "lat": 53.5611684,
    "lng": 9.8990906,
    "url": "ht**********",
    "country": "Germany",
    "state": "Hamburg",
    "city": "Hamburg",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Yucona Gmbh",
    "address": "Fe**********",
    "phone": "********4336",
    "email": "ko*****@ku**********",
    "lat": 51.7206684,
    "lng": 8.7694743,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Paderborn",
    "star_count": 3.8,
    "rating_count": 9,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Water Tap Trinkwasserbrunnen Rathausplatz Erlangen",
    "address": "Ra**********",
    "phone": "********4141",
    "email": "ku**********@es*****",
    "lat": 49.5908137,
    "lng": 11.0064491,
    "url": "ht**********",
    "country": "Germany",
    "state": "Bavaria",
    "city": "Erlangen",
    "star_count": 3,
    "rating_count": 2,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "SPIRITFAKTUR GmbH",
    "address": "Pa**********",
    "phone": "********6175",
    "email": "in**@sp**********",
    "lat": 48.0143974,
    "lng": 7.8449242,
    "url": "ht**********",
    "country": "Germany",
    "state": "Baden-Württemberg",
    "city": "Freiburg",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Jakobsbrunnen",
    "address": "b.**********",
    "phone": "",
    "email": "ch*****@sw*****",
    "lat": 53.8502693,
    "lng": 10.6714154,
    "url": "ht**********",
    "country": "Germany",
    "state": "Schleswig-Holstein",
    "city": null,
    "star_count": 4.7,
    "rating_count": 3,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Trinkwasserbrunnen Maternusplatz",
    "address": "50**********",
    "phone": "",
    "email": "st**********@st**********",
    "lat": 50.8926501,
    "lng": 6.9946908,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": null,
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Trinkwasserspender (Stadt Köln)",
    "address": "WX**********",
    "phone": "",
    "email": "st**********@st**********",
    "lat": 50.918165,
    "lng": 6.9698576,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": null,
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Hotmannspief (Brunnen)",
    "address": "Al**********",
    "phone": "",
    "email": "in**@de**********",
    "lat": 50.7783713,
    "lng": 6.0885907,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Aachen",
    "star_count": 4.3,
    "rating_count": 186,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Ape2o",
    "address": "",
    "phone": "",
    "email": "in**@ap*******",
    "lat": 47.73855,
    "lng": 12.5088275,
    "url": "ht**********",
    "country": "Germany",
    "state": "Bavaria",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Companies,Service establishments,Drinking water fountains"
  },
  {
    "name": "Trinkbrunnen Eigelstein",
    "address": "Ei**********",
    "phone": "",
    "email": "st**********@st**********",
    "lat": 50.949634,
    "lng": 6.9568516,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": null,
    "star_count": 3.3,
    "rating_count": 3,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Trinkwasserbrunnen, Zeppelinstrasse",
    "address": "Ze**********",
    "phone": "",
    "email": "st**********@st**********",
    "lat": 50.9367584,
    "lng": 6.9488836,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": null,
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Morgenstern Brunnen",
    "address": "Un**********",
    "phone": "",
    "email": "tu*@mo**********",
    "lat": 49.8239834,
    "lng": 6.7785753,
    "url": "ht**********",
    "country": "Germany",
    "state": "Rhineland-Palatinate",
    "city": "Schweich",
    "star_count": 4.5,
    "rating_count": 4,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Trinkwasserspender (Stadt Köln)",
    "address": "Bo**********",
    "phone": "",
    "email": "st**********@st**********",
    "lat": 50.9196217,
    "lng": 6.9597381,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Wasserquelle",
    "address": "45**********",
    "phone": "",
    "email": "in**@wa**********",
    "lat": 51.3583409,
    "lng": 6.9607819,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Essen",
    "star_count": 4.4,
    "rating_count": 27,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Trinkwasserspender",
    "address": "Ma**********",
    "phone": "",
    "email": "ab********@rh**********",
    "lat": 49.9998793,
    "lng": 8.2739801,
    "url": "ht**********",
    "country": "Germany",
    "state": "Rhineland-Palatinate",
    "city": "Mainz",
    "star_count": 2,
    "rating_count": 3,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Helene-Weigel-Platz",
    "address": "He**********",
    "phone": "",
    "email": "bw*@ra**********",
    "lat": 52.5273476,
    "lng": 13.5391066,
    "url": "ht**********",
    "country": "Germany",
    "state": "Berlin",
    "city": "Berlin",
    "star_count": 4.2,
    "rating_count": 17,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Heilbrunnen Schweich",
    "address": "Un**********",
    "phone": "",
    "email": "tu*@mo**********",
    "lat": 49.8408631,
    "lng": 6.7259821,
    "url": "ht**********",
    "country": "Germany",
    "state": "Rhineland-Palatinate",
    "city": "Schweich",
    "star_count": 5,
    "rating_count": 5,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Trinkbrunnen Checkpoint Charlie",
    "address": "Fr**********",
    "phone": "********7587",
    "email": "",
    "lat": 52.5079639,
    "lng": 13.3901484,
    "url": "ht**********",
    "country": "Germany",
    "state": "Berlin",
    "city": "Berlin",
    "star_count": 5,
    "rating_count": 11,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Comeniusplatz",
    "address": "To**********",
    "phone": "********7587",
    "email": "",
    "lat": 52.511354,
    "lng": 13.448724,
    "url": "ht**********",
    "country": "Germany",
    "state": "Berlin",
    "city": "Berlin",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Arminiusquelle",
    "address": "Li**********",
    "phone": "******** 260",
    "email": "",
    "lat": 51.7812904,
    "lng": 8.8220657,
    "url": "",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Bad Lippspringe",
    "star_count": 4.4,
    "rating_count": 45,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "TSG Tafelwassersysteme",
    "address": "He**********",
    "phone": "********1510",
    "email": "",
    "lat": 52.377098,
    "lng": 9.735607,
    "url": "",
    "country": "Germany",
    "state": "Lower Saxony",
    "city": "Hannover",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Water TAP",
    "address": "Ha**********",
    "phone": "********9385",
    "email": "",
    "lat": 52.5099991,
    "lng": 13.3352031,
    "url": "ht**********",
    "country": "Germany",
    "state": "Berlin",
    "city": "Berlin",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Wasserspender, Büro Trinkwasserspender",
    "address": "St**********",
    "phone": "******** 495",
    "email": "",
    "lat": 51.8071322,
    "lng": 7.9445851,
    "url": "",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Ahlen",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Wasserturm",
    "address": "Wa**********",
    "phone": "********9690",
    "email": "",
    "lat": 49.6216665,
    "lng": 11.0658504,
    "url": "ht**********",
    "country": "Germany",
    "state": "Bavaria",
    "city": "Marloffstein",
    "star_count": 4.6,
    "rating_count": 77,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Fürst-Bismarck-Quelle",
    "address": "Sa**********",
    "phone": "********6980",
    "email": "",
    "lat": 53.5317195,
    "lng": 10.3035739,
    "url": "ht**********",
    "country": "Germany",
    "state": "Schleswig-Holstein",
    "city": null,
    "star_count": 4,
    "rating_count": 122,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Holidrinks",
    "address": "",
    "phone": "********1735",
    "email": "",
    "lat": 47.73855,
    "lng": 12.5088275,
    "url": "",
    "country": "Germany",
    "state": "Bavaria",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Companies,Service establishments,Drinking water fountains"
  },
  {
    "name": "Draitschbrunnen",
    "address": "Br**********",
    "phone": "********3617",
    "email": "",
    "lat": 50.6801739,
    "lng": 7.1496544,
    "url": "",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Bonn",
    "star_count": 4.7,
    "rating_count": 115,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Trinkbrunnen",
    "address": "Me**********",
    "phone": "********7587",
    "email": "",
    "lat": 52.4836459,
    "lng": 13.3194588,
    "url": "ht**********",
    "country": "Germany",
    "state": "Berlin",
    "city": "Berlin",
    "star_count": 3,
    "rating_count": 1,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Wasserspender Nestle Aquarel D & F Getränkegroßhandel",
    "address": "He**********",
    "phone": "********2735",
    "email": "",
    "lat": 51.0946807,
    "lng": 13.7332746,
    "url": "",
    "country": "Germany",
    "state": "Saxony",
    "city": "Dresden",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drinking water fountains"
  },
  {
    "name": "Delicious Aqua",
    "address": "Bo**********",
    "phone": "********9773",
    "email": "",
    "lat": 51.2222999,
    "lng": 6.6848387,
    "url": "ht**********",
    "country": "Germany",
    "state": "North Rhine-Westphalia",
    "city": "Neuss",
    "star_count": 5,
    "rating_count": 153,
    "category_name": "Water treatment plants,Drinking water fountains"
  }
]