Список Компании по добыче нефти и природного газа в Северная Америка

[
  {
    "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": "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": "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": "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": "Renegade Wireline Services - Bryan",
    "address": "16**********",
    "phone": "********0772",
    "email": "lh****@re**********",
    "lat": 30.7040543,
    "lng": -96.3538104,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Bryan",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "Tobinsnet Oil & Gas Ltd",
    "address": "59**********",
    "phone": "********1050",
    "email": "in**@to**********",
    "lat": 30.3415589,
    "lng": -97.7549546,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Austin",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "Renegade Wireline Services",
    "address": "11**********",
    "phone": "********3321",
    "email": "mr*****@re**********",
    "lat": 32.9637102,
    "lng": -102.8449002,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Denver City",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Oil & natural gas companies,Crane services,Oil field equipment suppliers,Oil refineries,Oilfields,Equipment suppliers,Crane rental agencies"
  },
  {
    "name": "ENCO GNV CEDA",
    "address": "Ci**********",
    "phone": "********8549",
    "email": "ca********@en*********",
    "lat": 19.3780627,
    "lng": -99.0818726,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Mexico City",
    "city": "Mexico City",
    "star_count": 4.3,
    "rating_count": 257,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "Impulsora",
    "address": "La**********",
    "phone": "********9657",
    "email": "en*****@im**********",
    "lat": 19.4433947,
    "lng": -99.180992,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Mexico City",
    "city": "Mexico City",
    "star_count": 0,
    "rating_count": 0,
    "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"
  }
]