Kuzey Amerika içindeki Sondaj müteahhitleri Listesi

[
  {
    "name": "Aggregate Resource Industries, Inc.",
    "address": "40**********",
    "phone": "********6261",
    "email": "in**@ar********",
    "lat": 44.0499273,
    "lng": -122.9669143,
    "url": "ht**********",
    "country": "United States",
    "state": "Oregon",
    "city": "Springfield",
    "star_count": 4.4,
    "rating_count": 8,
    "category_name": "Quarries,Aggregate suppliers,Drilling contractors,Sand & gravel suppliers,Solar energy system services,Excavating contractors"
  },
  {
    "name": "Aardvark Drilling Inc.",
    "address": "10**********",
    "phone": "********9340",
    "email": "me******@aa**********",
    "lat": 45.1497935,
    "lng": -76.1478549,
    "url": "ht**********",
    "country": "Canada",
    "state": "Ontario",
    "city": "Carleton Place",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Drilling contractors"
  },
  {
    "name": "AES Drilling Fluids",
    "address": "64**********",
    "phone": "********3966",
    "email": "in**@ae**********",
    "lat": 31.9517883,
    "lng": -102.1573131,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Midland",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Drilling contractors"
  },
  {
    "name": "Henry Foundation Drilling Inc.",
    "address": "23**********",
    "phone": "********0306",
    "email": "in**@he**********",
    "lat": 49.1355663,
    "lng": -122.5699134,
    "url": "ht**********",
    "country": "Canada",
    "state": "British Columbia",
    "city": "Vancouver",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Drilling contractors,Drilling equipment suppliers"
  },
  {
    "name": "ClearPath Utility Solutions",
    "address": "29**********",
    "phone": "********4058",
    "email": "in**@di**********",
    "lat": 39.956086,
    "lng": -82.553513,
    "url": "ht**********",
    "country": "United States",
    "state": "Ohio",
    "city": null,
    "star_count": 4.8,
    "rating_count": 27,
    "category_name": "Drilling contractors"
  },
  {
    "name": "Total Support Services, Inc. : TSS Drilling",
    "address": "46**********",
    "phone": "********7174",
    "email": "ts*********@gm*******",
    "lat": 32.6847889,
    "lng": -96.8978206,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Dallas",
    "star_count": 4.8,
    "rating_count": 6,
    "category_name": "Drilling contractors,Geotechnical Engineers"
  },
  {
    "name": "Scientific Drilling",
    "address": "12**********",
    "phone": "********2500",
    "email": "in*********@sc**********",
    "lat": 40.1317678,
    "lng": -79.9841415,
    "url": "ht**********",
    "country": "United States",
    "state": "Pennsylvania",
    "city": null,
    "star_count": 5,
    "rating_count": 5,
    "category_name": "Drilling contractors"
  },
  {
    "name": "Landshark Group",
    "address": "36**********",
    "phone": "********1110",
    "email": "sh****@la**********",
    "lat": 44.333286,
    "lng": -79.875459,
    "url": "ht**********",
    "country": "Canada",
    "state": "Ontario",
    "city": null,
    "star_count": 4,
    "rating_count": 2,
    "category_name": "Drilling contractors,Utility contractors,Environmental consultants"
  },
  {
    "name": "nissglobal",
    "address": "53**********",
    "phone": "********1960",
    "email": "le********@na**********",
    "lat": 47.5337738,
    "lng": -116.06422,
    "url": "ht**********",
    "country": "United States",
    "state": "Idaho",
    "city": "Kellogg",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drilling contractors"
  },
  {
    "name": "Hydrodig Ottawa",
    "address": "",
    "phone": "********8859",
    "email": "bo**********@hy**********",
    "lat": 45.132856,
    "lng": -75.5452235,
    "url": "ht**********",
    "country": "Canada",
    "state": "Ontario",
    "city": "Ottawa",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Companies,Drilling contractors,Excavating contractors,Utility contractors,Service establishments"
  }
]