Elenco di Compagnie di petrolio e gas naturale in Nord America

[
  {
    "name": "K-TRONIX S.A. DE C.V.",
    "address": "Gr**********",
    "phone": "********6062",
    "email": "kt*****@kt**********",
    "lat": 25.706845,
    "lng": -100.3654288,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Nuevo León",
    "city": "Monterrey",
    "star_count": 5,
    "rating_count": 4,
    "category_name": "Oil & natural gas companies,Manufacturers"
  },
  {
    "name": "K-TRONIX S.A. DE C.V.",
    "address": "Ta**********",
    "phone": "********4333",
    "email": "kt*****@kt**********",
    "lat": 19.4320892,
    "lng": -99.1850856,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Mexico City",
    "city": "Mexico City",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "K-TRONIX S.A. DE C.V.",
    "address": "Ho**********",
    "phone": "********5110",
    "email": "kt*****@kt**********",
    "lat": 22.2583946,
    "lng": -97.83484,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Tamaulipas",
    "city": "Ciudad Madero",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "FH Proyectos, S. de R.L. de C.V.",
    "address": "Av**********",
    "phone": "********6811",
    "email": "fh**********@gm*******",
    "lat": 19.6557779,
    "lng": -99.2513784,
    "url": "ht**********",
    "country": "Mexico",
    "state": "México",
    "city": null,
    "star_count": 5,
    "rating_count": 7,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "Yoder Oil - Indianapolis",
    "address": "45**********",
    "phone": "********2107",
    "email": "in**@yo**********",
    "lat": 39.8403863,
    "lng": -86.3812146,
    "url": "ht**********",
    "country": "United States",
    "state": "Indiana",
    "city": "Indianapolis",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "Renegade Wireline Service - Permian Basin Sales",
    "address": "24**********",
    "phone": "********2095",
    "email": "jb****@re**********",
    "lat": 32.0343624,
    "lng": -102.0905526,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Midland",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "Nextdecade, LNG LLC",
    "address": "10**********",
    "phone": "********1880",
    "email": "in**@ne**********",
    "lat": 29.7583065,
    "lng": -95.3683375,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 3,
    "rating_count": 2,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "Renegade Services Levelland",
    "address": "19**********",
    "phone": "********0042",
    "email": "as****@re**********",
    "lat": 33.5631129,
    "lng": -102.3868915,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Levelland",
    "star_count": 5,
    "rating_count": 6,
    "category_name": "Oil & natural gas companies,Oil field equipment suppliers,Well drilling contractors,Contractors"
  },
  {
    "name": "Cenovus Energy Inc",
    "address": "22**********",
    "phone": "********2000",
    "email": "co******@ce*********",
    "lat": 51.0473121,
    "lng": -114.0659052,
    "url": "ht**********",
    "country": "Canada",
    "state": "Alberta",
    "city": "Calgary",
    "star_count": 4.2,
    "rating_count": 52,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "Merica Oil Company",
    "address": "77**********",
    "phone": "********0622",
    "email": "fr*********@me**********",
    "lat": 32.7530975,
    "lng": -97.3296751,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Fort Worth",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Oil & natural gas companies"
  }
]