Texasのパイプ供給者のリスト

[
  {
    "name": "B&L Pipeco Services Inc.",
    "address": "20**********",
    "phone": "********3500",
    "email": "co*****@bl**********",
    "lat": 29.99075,
    "lng": -95.5752438,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 5,
    "rating_count": 0,
    "category_name": "Oil field equipment suppliers,Pipe suppliers"
  },
  {
    "name": "The Pipe Yard, Inc.",
    "address": "15**********",
    "phone": "********7473",
    "email": "in**@th**********",
    "lat": 29.5837211,
    "lng": -95.4050674,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 3.9,
    "rating_count": 0,
    "category_name": "Surplus stores,Pipe suppliers,Environmental Protection Organizations"
  },
  {
    "name": "Synergy Pipe Services",
    "address": "92**********",
    "phone": "********4724",
    "email": "sa***@in**********",
    "lat": 29.7833854,
    "lng": -95.5193793,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Steel and Pipe Supply Co Inc",
    "address": "22**********",
    "phone": "********1000",
    "email": "fr***@da**********",
    "lat": 31.466989,
    "lng": -97.1976684,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Waco",
    "star_count": 4.7,
    "rating_count": 0,
    "category_name": "Pipe suppliers,Metal suppliers"
  },
  {
    "name": "Berg Pipe Houston",
    "address": "10**********",
    "phone": "********1600",
    "email": "so*********@be**********",
    "lat": 29.727061,
    "lng": -95.5563153,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "ADS",
    "address": "21**********",
    "phone": "********9600",
    "email": "ad**********@ad**********",
    "lat": 32.3189551,
    "lng": -96.609492,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Ennis",
    "star_count": 3.6,
    "rating_count": 59,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Chevron Pipe Line Co",
    "address": "86**********",
    "phone": "********2361",
    "email": "ta****@ch*********",
    "lat": 29.8383025,
    "lng": -94.8942248,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Mont Belvieu",
    "star_count": 4,
    "rating_count": 2,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "MIM International Inc",
    "address": "87**********",
    "phone": "********6608",
    "email": "in**@mi********",
    "lat": 29.6777956,
    "lng": -95.3997099,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Chevron Pipe Line Co",
    "address": "90**********",
    "phone": "********5844",
    "email": "ta****@ch*********",
    "lat": 31.3382335,
    "lng": -94.729073,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Lufkin",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Future Pipe Industries, Inc.",
    "address": "11**********",
    "phone": "********2987",
    "email": "sa**********@fu**********",
    "lat": 29.904887,
    "lng": -95.467146,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 4.3,
    "rating_count": 18,
    "category_name": "Pipe suppliers"
  }
]