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

[
  {
    "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": "Intricate Group Inc.",
    "address": "15**********",
    "phone": "********3810",
    "email": "sa***@in**********",
    "lat": 44.6432432,
    "lng": -63.5783192,
    "url": "ht**********",
    "country": "Canada",
    "state": "Nova Scotia",
    "city": "Halifax",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Oil & natural gas companies,Energy equipment and solutions"
  },
  {
    "name": "BKV Corporation",
    "address": "On**********",
    "phone": "********9680",
    "email": "me***@bk*********",
    "lat": 39.7491127,
    "lng": -104.9962861,
    "url": "ht**********",
    "country": "United States",
    "state": "Colorado",
    "city": "Denver",
    "star_count": 3,
    "rating_count": 2,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "Equinor Marketing & Trading US",
    "address": "60**********",
    "phone": "********6900",
    "email": "gm**********@eq*********",
    "lat": 41.0479128,
    "lng": -73.5435907,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Stamford",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Financial institutions,Oil & natural gas companies"
  },
  {
    "name": "Air BP Aviation Services",
    "address": "53**********",
    "phone": "********2032",
    "email": "dp**********@cl**********",
    "lat": 41.4103972,
    "lng": -81.8386329,
    "url": "ht**********",
    "country": "United States",
    "state": "Ohio",
    "city": "Cleveland",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "Phoenix Park Energy Marketing",
    "address": "60**********",
    "phone": "********6372",
    "email": "bi*******@qo******",
    "lat": 30.1423339,
    "lng": -94.6339187,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": null,
    "star_count": 4.5,
    "rating_count": 12,
    "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": "Oil & natural gas companies,Corporate campus,Corporate offices"
  },
  {
    "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": "Alaska Oil & Gas Association",
    "address": "Fi**********",
    "phone": "********1481",
    "email": "in**@ao******",
    "lat": 61.1986093,
    "lng": -149.8839435,
    "url": "ht**********",
    "country": "United States",
    "state": "Alaska",
    "city": "Anchorage",
    "star_count": 4.5,
    "rating_count": 2,
    "category_name": "Oil & natural gas companies"
  },
  {
    "name": "TC Energy",
    "address": "60**********",
    "phone": "********5301",
    "email": "in**********@tc**********",
    "lat": 49.2836336,
    "lng": -123.1171379,
    "url": "ht**********",
    "country": "Canada",
    "state": "British Columbia",
    "city": "Vancouver",
    "star_count": 1.7,
    "rating_count": 27,
    "category_name": "Oil & natural gas companies"
  }
]