قائمة شركات المرافق المائية في اليابان

[
  {
    "name": "エスピーアール",
    "address": "Ja**********",
    "phone": "********-095",
    "email": "sp*@su********",
    "lat": 35.8584968,
    "lng": 139.7103991,
    "url": "ht**********",
    "country": "Japan",
    "state": "Saitama Prefecture",
    "city": "Saitama",
    "star_count": 5,
    "rating_count": 26,
    "category_name": "Water utility companies,Bathroom remodelers,Remodelers,Kitchen remodelers,Plumbers"
  },
  {
    "name": "東温市 上下水道課",
    "address": "53**********",
    "phone": "********4416",
    "email": "jo*******@ci**********",
    "lat": 33.7910423,
    "lng": 132.8723909,
    "url": "ht**********",
    "country": "Japan",
    "state": "Ehime Prefecture",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "comect",
    "address": "2 **********",
    "phone": "********2012",
    "email": "in**@co********",
    "lat": 35.7420244,
    "lng": 139.6631001,
    "url": "ht**********",
    "country": "Japan",
    "state": "Tokyo",
    "city": "Tokyo",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "ピカンテクリーンサービス",
    "address": "Ja**********",
    "phone": "********1400",
    "email": "in**@pi********",
    "lat": 37.7315273,
    "lng": 140.4741815,
    "url": "ht**********",
    "country": "Japan",
    "state": "Fukushima Prefecture",
    "city": "Fukushima",
    "star_count": 5,
    "rating_count": 4,
    "category_name": "House cleaning services,Water utility companies,Pipe suppliers"
  },
  {
    "name": "(有)関和設備",
    "address": "Ma**********",
    "phone": "********2492",
    "email": "se**********@mi**********",
    "lat": 37.6518135,
    "lng": 140.5370928,
    "url": "ht**********",
    "country": "Japan",
    "state": "Fukushima Prefecture",
    "city": "Fukushima",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Remodelers,Hot water system suppliers,Water utility companies"
  },
  {
    "name": "Kurayoshi Waterworks Bureau",
    "address": "72**********",
    "phone": "********1132",
    "email": "su****@ci**********",
    "lat": 35.430222,
    "lng": 133.8258514,
    "url": "ht**********",
    "country": "Japan",
    "state": "Tottori Prefecture",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "Motomachi Water Distribution Station",
    "address": "1-**********",
    "phone": "********2871",
    "email": "su**********@ci**********",
    "lat": 41.7615559,
    "lng": 140.7129388,
    "url": "ht**********",
    "country": "Japan",
    "state": "Hokkaidō Prefecture",
    "city": "Hakodate",
    "star_count": 4,
    "rating_count": 31,
    "category_name": "Water utility companies"
  },
  {
    "name": "(有)平設備興業",
    "address": "On**********",
    "phone": "********6288",
    "email": "ta**********@gm*******",
    "lat": 37.0577299,
    "lng": 140.8677724,
    "url": "ht**********",
    "country": "Japan",
    "state": "Fukushima Prefecture",
    "city": "Iwaki",
    "star_count": 3.5,
    "rating_count": 2,
    "category_name": "Sports clubs,Water utility companies"
  },
  {
    "name": "有限会社U.Iエンジニアリング",
    "address": "Ja**********",
    "phone": "********8870",
    "email": "12*******@gm*******",
    "lat": 35.333574,
    "lng": 139.6289353,
    "url": "ht**********",
    "country": "Japan",
    "state": "Kanagawa Prefecture",
    "city": "Yokohama",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies"
  },
  {
    "name": "株式会社エヌ・ケー・ワークス",
    "address": "3 **********",
    "phone": "********7609",
    "email": "in**@nk**********",
    "lat": 35.68199,
    "lng": 139.6737407,
    "url": "ht**********",
    "country": "Japan",
    "state": "Tokyo",
    "city": "Tokyo",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water utility companies,Bathroom remodelers,Remodelers"
  }
]