Elenco di Compagnie di petrolio e gas naturale in Nord America

[
  {
    "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": "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": "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": "Tyree",
    "address": "16**********",
    "phone": "********0076",
    "email": "ca******@ty**********",
    "lat": 45.4033219,
    "lng": -122.7477214,
    "url": "ht**********",
    "country": "United States",
    "state": "Oregon",
    "city": "Portland",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "Oxy - Kermit",
    "address": "83**********",
    "phone": "********1600",
    "email": "Ow**********@ox*****",
    "lat": 31.8509813,
    "lng": -103.079231,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Kermit",
    "star_count": 4.1,
    "rating_count": 17,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "Meridian Energy Group, Inc",
    "address": "20**********",
    "phone": "********5213",
    "email": "in**@Me**********",
    "lat": 33.6787954,
    "lng": -117.8561399,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Irvine",
    "star_count": 5,
    "rating_count": 4,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "Hexagon Agility",
    "address": "10**********",
    "phone": "********7500",
    "email": "in**@he**********",
    "lat": 34.0717243,
    "lng": -117.4660966,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Bernardino",
    "star_count": 4.4,
    "rating_count": 13,
    "category_name": "Oil & natural gas companies"
  },
  {
    "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": "Alpha Seven Energy",
    "address": "38**********",
    "phone": "********1777",
    "email": "in**@al**********",
    "lat": 32.814054,
    "lng": -96.8007069,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Dallas",
    "star_count": 3.3,
    "rating_count": 12,
    "category_name": "Oil & natural gas companies"
  }
]