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

[
  {
    "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": "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": "Equinor Canada Ltd",
    "address": "30**********",
    "phone": "********0123",
    "email": "gm**********@eq*********",
    "lat": 51.0499519,
    "lng": -114.0682712,
    "url": "ht**********",
    "country": "Canada",
    "state": "Alberta",
    "city": "Calgary",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "Warrenton Oil Co",
    "address": "22**********",
    "phone": "********3346",
    "email": "in**@wo********",
    "lat": 38.8097007,
    "lng": -91.1191604,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 3.8,
    "rating_count": 21,
    "category_name": "Corporate offices,Corporate campus,Oil & natural gas companies"
  },
  {
    "name": "Rhino Linings",
    "address": "10**********",
    "phone": "********7772",
    "email": "in**@rh**********",
    "lat": 40.5227894,
    "lng": -107.5506515,
    "url": "ht**********",
    "country": "United States",
    "state": "Colorado",
    "city": "Craig",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Real Estate Builders & Construction Companies,Construction companies,Oil & natural gas companies"
  },
  {
    "name": "Renegade Services",
    "address": "32**********",
    "phone": "********1011",
    "email": "el**********@re**********",
    "lat": 32.735283,
    "lng": -103.160026,
    "url": "ht**********",
    "country": "United States",
    "state": "New Mexico",
    "city": "Hobbs",
    "star_count": 5,
    "rating_count": 4,
    "category_name": "Crane rental agencies,Equipment suppliers,Oil & natural gas companies,Crane services,Oil field equipment suppliers,Oilfields"
  },
  {
    "name": "Devon Energy",
    "address": "De**********",
    "phone": "********4800",
    "email": "mi**********@dv*****",
    "lat": 35.467331,
    "lng": -97.5180455,
    "url": "ht**********",
    "country": "United States",
    "state": "Oklahoma",
    "city": "Oklahoma City",
    "star_count": 4.7,
    "rating_count": 325,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "Oxy Permian",
    "address": "16**********",
    "phone": "********5600",
    "email": "Ow**********@ox*****",
    "lat": 31.9938792,
    "lng": -102.1628965,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Midland",
    "star_count": 4.8,
    "rating_count": 38,
    "category_name": "Oil & natural gas companies"
  }
]