北アメリカの油田設備供給業者のリスト

[
  {
    "name": "Windrock",
    "address": "18**********",
    "phone": "********1100",
    "email": "al**********@ch**********",
    "lat": 35.9630841,
    "lng": -84.0117828,
    "url": "ht**********",
    "country": "United States",
    "state": "Tennessee",
    "city": "Knoxville",
    "star_count": 5,
    "rating_count": 8,
    "category_name": "Oil field equipment suppliers"
  },
  {
    "name": "Apache Pipeline Products",
    "address": "15**********",
    "phone": "********4850",
    "email": "sa***@ap**********",
    "lat": 53.5227012,
    "lng": -113.3656108,
    "url": "ht**********",
    "country": "Canada",
    "state": "Alberta",
    "city": "Sherwood Park",
    "star_count": 4.9,
    "rating_count": 23,
    "category_name": "Oil field equipment suppliers,Manufacturers"
  },
  {
    "name": "J&W Services and Equipment Company",
    "address": "35**********",
    "phone": "********0515",
    "email": "ad**********@jw**********",
    "lat": 31.9792456,
    "lng": -102.0277396,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Midland",
    "star_count": 4.4,
    "rating_count": 16,
    "category_name": "Oil field equipment suppliers"
  },
  {
    "name": "SCS Technologies LLC",
    "address": "34**********",
    "phone": "********6500",
    "email": "in**@sc**********",
    "lat": 32.2647817,
    "lng": -101.4339557,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Big Spring",
    "star_count": 4.9,
    "rating_count": 15,
    "category_name": "Oil field equipment suppliers"
  },
  {
    "name": "ENERFLEX COMPRESSION MEXICO S DE RL DE CV",
    "address": "Ac**********",
    "phone": "********8065",
    "email": "in**@en**********",
    "lat": 19.1654082,
    "lng": -96.2387407,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Veracruz",
    "city": "Veracruz",
    "star_count": 4.2,
    "rating_count": 29,
    "category_name": "Oil field equipment suppliers"
  },
  {
    "name": "DHVI Downhole Video & Intervention",
    "address": "52**********",
    "phone": "********0507",
    "email": "op********@dh******",
    "lat": 51.0489436,
    "lng": -114.0725207,
    "url": "ht**********",
    "country": "Canada",
    "state": "Alberta",
    "city": "Calgary",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Oil field equipment suppliers"
  },
  {
    "name": "Harvest Oilfield Service",
    "address": "15**********",
    "phone": "********1295",
    "email": "in**@ha**********",
    "lat": 44.6432724,
    "lng": -63.5784118,
    "url": "ht**********",
    "country": "Canada",
    "state": "Nova Scotia",
    "city": "Halifax",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Oil field equipment suppliers"
  },
  {
    "name": "Enerflex",
    "address": "20**********",
    "phone": "********8571",
    "email": "in**@en**********",
    "lat": 36.0475232,
    "lng": -95.7477288,
    "url": "ht**********",
    "country": "United States",
    "state": "Oklahoma",
    "city": "Tulsa",
    "star_count": 3.4,
    "rating_count": 10,
    "category_name": "Air compressor suppliers,Oil field equipment suppliers,Oil & natural gas companies"
  },
  {
    "name": "J-W Power Company",
    "address": "14**********",
    "phone": "********6955",
    "email": "cr*******@jw**********",
    "lat": 47.8116233,
    "lng": -103.6452206,
    "url": "ht**********",
    "country": "United States",
    "state": "North Dakota",
    "city": null,
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Oil field equipment suppliers"
  },
  {
    "name": "Refinery Supply Company, Inc.",
    "address": "60**********",
    "phone": "********1700",
    "email": "pa***@re**********",
    "lat": 36.0473369,
    "lng": -95.7784314,
    "url": "ht**********",
    "country": "United States",
    "state": "Oklahoma",
    "city": "Tulsa",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Laboratory equipment suppliers,Oil field equipment suppliers,Safety equipment suppliers"
  }
]