قائمة مقاولو الحفر في أمريكا الشمالية

[
  {
    "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": "Terra Drilling Co Inc",
    "address": "58**********",
    "phone": "********0351",
    "email": "in**@ni**********",
    "lat": 42.3916941,
    "lng": -71.5011223,
    "url": "ht**********",
    "country": "United States",
    "state": "Massachusetts",
    "city": "Boston",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Drilling contractors"
  },
  {
    "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": "Sacramento Drilling Inc",
    "address": "11**********",
    "phone": "********1766",
    "email": "an****@sa**********",
    "lat": 38.6030665,
    "lng": -121.4419423,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Sacramento",
    "star_count": 4.1,
    "rating_count": 13,
    "category_name": "Foundations,General contractors,Drilling contractors,Construction companies,Solar energy system services,Real Estate Builders & Construction Companies"
  },
  {
    "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": "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": "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,Construction companies,Real Estate Builders & Construction Companies"
  },
  {
    "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": "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": "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"
  }
]