Список Подрядчики по бурению в Северная Америка

[
  {
    "name": "MGL STRATEGIES LLC",
    "address": "23**********",
    "phone": "********2303",
    "email": "Mg*@mg**********",
    "lat": 38.2160465,
    "lng": -85.5780263,
    "url": "ht**********",
    "country": "United States",
    "state": "Kentucky",
    "city": "Louisville",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drilling 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": "Precision Sampling Inc.",
    "address": "24**********",
    "phone": "********3925",
    "email": "co*****@ob********",
    "lat": 35.1097605,
    "lng": -106.6169566,
    "url": "ht**********",
    "country": "United States",
    "state": "New Mexico",
    "city": "Albuquerque",
    "star_count": 0,
    "rating_count": 0,
    "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": "Geotechnical Engineers,Drilling contractors"
  },
  {
    "name": "Riggs Distler & Company, Inc.",
    "address": "30**********",
    "phone": "********9193",
    "email": "in**@ri**********",
    "lat": 42.102128,
    "lng": -73.971266,
    "url": "ht**********",
    "country": "United States",
    "state": "New York",
    "city": "Saugerties",
    "star_count": 5,
    "rating_count": 2,
    "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": "ClearPath Utility Solutions, LLC.",
    "address": "81**********",
    "phone": "********4058",
    "email": "in**@di**********",
    "lat": 39.954474,
    "lng": -82.1451916,
    "url": "ht**********",
    "country": "United States",
    "state": "Ohio",
    "city": null,
    "star_count": 4.8,
    "rating_count": 40,
    "category_name": "Drilling contractors,Utility 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,Excavating contractors,Service establishments,Utility contractors,Drilling contractors"
  }
]