List of Well drilling contractors in Hokkaidō Prefecture

[
  {
    "name": "㈱神田土質基礎",
    "address": "Ja**********",
    "phone": "********0864",
    "email": "",
    "lat": 43.0286358,
    "lng": 141.4309119,
    "url": "ht**********",
    "country": "Japan",
    "state": "Hokkaidō Prefecture",
    "city": "Sapporo",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Well drilling contractors"
  },
  {
    "name": "㈱白神さく泉",
    "address": "7 **********",
    "phone": "********5341",
    "email": "",
    "lat": 43.0621487,
    "lng": 141.256459,
    "url": "ht**********",
    "country": "Japan",
    "state": "Hokkaidō Prefecture",
    "city": "Sapporo",
    "star_count": 3,
    "rating_count": 1,
    "category_name": "Well drilling contractors"
  },
  {
    "name": "有賀さく泉工業 日高支店",
    "address": "",
    "phone": "********5003",
    "email": "",
    "lat": 42.9024386,
    "lng": 141.9153284,
    "url": "ht**********",
    "country": "Japan",
    "state": "Hokkaidō Prefecture",
    "city": null,
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Service establishments,Well drilling contractors,Companies"
  },
  {
    "name": "北海道地下開発",
    "address": "11**********",
    "phone": "********8000",
    "email": "",
    "lat": 43.2663094,
    "lng": 145.4844287,
    "url": "",
    "country": "Japan",
    "state": "Hokkaidō Prefecture",
    "city": "Nemuro",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Well drilling contractors"
  },
  {
    "name": "㈱丸新荒又組",
    "address": "5 **********",
    "phone": "",
    "email": "",
    "lat": 43.0927166,
    "lng": 141.4010383,
    "url": "ht**********",
    "country": "Japan",
    "state": "Hokkaidō Prefecture",
    "city": "Sapporo",
    "star_count": 4,
    "rating_count": 4,
    "category_name": "Well drilling contractors"
  },
  {
    "name": "㈱北錐工業",
    "address": "Ja**********",
    "phone": "",
    "email": "",
    "lat": 43.7262636,
    "lng": 142.397733,
    "url": "",
    "country": "Japan",
    "state": "Hokkaidō Prefecture",
    "city": "Asahikawa",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Well drilling contractors"
  },
  {
    "name": "㈱島田工業",
    "address": "53**********",
    "phone": "********1177",
    "email": "si******@pl**********",
    "lat": 42.869645,
    "lng": 141.598164,
    "url": "ht**********",
    "country": "Japan",
    "state": "Hokkaidō Prefecture",
    "city": null,
    "star_count": 2.5,
    "rating_count": 4,
    "category_name": "Well drilling contractors,Pipe suppliers,Water works"
  },
  {
    "name": "㈱けいしん水道設備",
    "address": "Ja**********",
    "phone": "********8930",
    "email": "",
    "lat": 42.986166,
    "lng": 141.5627466,
    "url": "ht**********",
    "country": "Japan",
    "state": "Hokkaidō Prefecture",
    "city": "Kitahiroshima",
    "star_count": 1,
    "rating_count": 1,
    "category_name": "Water utility companies,Water works,Electricians,Air conditioning repair services,Heating contractors,Well drilling contractors,HVAC contractors"
  },
  {
    "name": "㈱有賀さく泉工業 帯広本店",
    "address": "Ja**********",
    "phone": "********3363",
    "email": "",
    "lat": 42.911349,
    "lng": 143.2111269,
    "url": "ht**********",
    "country": "Japan",
    "state": "Hokkaidō Prefecture",
    "city": "Obihiro",
    "star_count": 5,
    "rating_count": 4,
    "category_name": "Corporate campus,Well drilling contractors,Corporate offices"
  },
  {
    "name": "㈲藤岡設備",
    "address": "59**********",
    "phone": "********0633",
    "email": "",
    "lat": 41.846507,
    "lng": 140.721546,
    "url": "",
    "country": "Japan",
    "state": "Hokkaidō Prefecture",
    "city": "Hakodate",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Corporate offices,Well drilling contractors,Corporate campus"
  }
]