トルコの水道会社のリスト

[
  {
    "name": "Waternet Water Services Inc.",
    "address": "Fl**********",
    "phone": "********2222",
    "email": "in**@wa**********",
    "lat": 41.0381868,
    "lng": 28.9326541,
    "url": "ht**********",
    "country": "Turkey",
    "state": "Istanbul Province",
    "city": "Istanbul",
    "star_count": 3.6,
    "rating_count": 60,
    "category_name": "Water treatment suppliers,Water utility companies"
  },
  {
    "name": "Aski",
    "address": "Şa**********",
    "phone": "********9 58",
    "email": "bi*********@as*********",
    "lat": 39.7951473,
    "lng": 32.8100795,
    "url": "ht**********",
    "country": "Turkey",
    "state": "Ankara Province",
    "city": "Ankara",
    "star_count": 1.7,
    "rating_count": 28,
    "category_name": "Water utility companies"
  },
  {
    "name": "TESKİ Ergene Şube Müdürlüğü",
    "address": "Sa**********",
    "phone": "********5803",
    "email": "te***@hs*********",
    "lat": 41.1833333,
    "lng": 27.768529,
    "url": "ht**********",
    "country": "Turkey",
    "state": "Tekirdağ Province",
    "city": "Ergene",
    "star_count": 2.7,
    "rating_count": 25,
    "category_name": "Water utility companies,Sewage disposal services"
  },
  {
    "name": "PINAR SU BALÇOVA BAYİİ",
    "address": "On**********",
    "phone": "********7 00",
    "email": "ex****@pi**********",
    "lat": 38.3916505,
    "lng": 27.0543995,
    "url": "ht**********",
    "country": "Turkey",
    "state": "İzmir Province",
    "city": null,
    "star_count": 1,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Seda Doğal Kaynak Suyu",
    "address": "Ma**********",
    "phone": "********6 86",
    "email": "in**@se********",
    "lat": 39.9543992,
    "lng": 32.7568655,
    "url": "ht**********",
    "country": "Turkey",
    "state": "Ankara Province",
    "city": "Ankara",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "KORUSU Odunluk Hüdavendigar Dikkaldırım Doburca Bayi",
    "address": "Hü**********",
    "phone": "********8 25",
    "email": "ko****@ko**********",
    "lat": 40.1961823,
    "lng": 29.008098,
    "url": "ht**********",
    "country": "Turkey",
    "state": "Bursa Province",
    "city": "Osmangazi",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Pinar Ayrancı Bayii",
    "address": "Ay**********",
    "phone": "********9 00",
    "email": "ex****@pi**********",
    "lat": 39.8928675,
    "lng": 32.8458927,
    "url": "ht**********",
    "country": "Turkey",
    "state": "Ankara Province",
    "city": "Ankara",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "HAYAT",
    "address": "İn**********",
    "phone": "********0 12",
    "email": "tu******@ha**********",
    "lat": 41.0363401,
    "lng": 29.1091936,
    "url": "ht**********",
    "country": "Turkey",
    "state": "Istanbul Province",
    "city": "Istanbul",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies"
  },
  {
    "name": "Hayat",
    "address": "Or**********",
    "phone": "********0744",
    "email": "tu******@ha**********",
    "lat": 41.071884,
    "lng": 28.8738637,
    "url": "ht**********",
    "country": "Turkey",
    "state": "Istanbul Province",
    "city": "Istanbul",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Pürsu Manisa",
    "address": "Ça**********",
    "phone": "********4 44",
    "email": "in**@yu**********",
    "lat": 38.6119736,
    "lng": 27.4310531,
    "url": "ht**********",
    "country": "Turkey",
    "state": "Manisa Province",
    "city": "Manisa",
    "star_count": 2.3,
    "rating_count": 3,
    "category_name": "Water utility companies"
  }
]