Kuzey Amerika içindeki Sondaj müteahhitleri Listesi

[
  {
    "name": "AES Drilling Fluids",
    "address": "35**********",
    "phone": "********3625",
    "email": "in**@ae**********",
    "lat": 31.1797658,
    "lng": -101.4014633,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Big Lake",
    "star_count": 4.2,
    "rating_count": 13,
    "category_name": "Drilling contractors"
  },
  {
    "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": "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": "Hydrodig Edmonton",
    "address": "",
    "phone": "********0252",
    "email": "ed******@hy**********",
    "lat": 53.2775768,
    "lng": -113.6390052,
    "url": "ht**********",
    "country": "Canada",
    "state": "Alberta",
    "city": null,
    "star_count": 4,
    "rating_count": 1,
    "category_name": "Drilling contractors,Utility contractors,Service establishments,Companies,Excavating contractors"
  },
  {
    "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.3,
    "rating_count": 7,
    "category_name": "Aggregate suppliers,Drilling contractors,Quarries,Sand & gravel suppliers,Solar energy system services,Excavating 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": "AES Drilling Fluids LLC",
    "address": "De**********",
    "phone": "********2800",
    "email": "in**@ae**********",
    "lat": 39.7422445,
    "lng": -104.987833,
    "url": "ht**********",
    "country": "United States",
    "state": "Colorado",
    "city": "Denver",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drilling contractors,General contractors"
  },
  {
    "name": "Total Support Services : TSS Drilling",
    "address": "38**********",
    "phone": "********7174",
    "email": "ts*********@gm*******",
    "lat": 30.3368027,
    "lng": -97.8042645,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Austin",
    "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,Excavating contractors,Service establishments,Utility contractors,Drilling contractors"
  },
  {
    "name": "Mckinney Drilling Company",
    "address": "75**********",
    "phone": "********1235",
    "email": "dm******@ke**********",
    "lat": 39.1549414,
    "lng": -76.7191319,
    "url": "ht**********",
    "country": "United States",
    "state": "Maryland",
    "city": "Baltimore",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drilling contractors,Real Estate Builders & Construction Companies,Construction companies"
  }
]