アメリカ合衆国のパイプ供給者のリスト

[
  {
    "name": "H R Prescott & Sons Inc",
    "address": "16**********",
    "phone": "********4431",
    "email": "in**@hr**********",
    "lat": 42.3410895,
    "lng": -71.7715822,
    "url": "ht**********",
    "country": "United States",
    "state": "Massachusetts",
    "city": "West Boylston",
    "star_count": 5,
    "rating_count": 9,
    "category_name": "Water works equipment suppliers,Pipe suppliers"
  },
  {
    "name": "Advanced Drainage Systems",
    "address": "34**********",
    "phone": "********6710",
    "email": "ad**********@ad**********",
    "lat": 40.7436236,
    "lng": -74.9254973,
    "url": "ht**********",
    "country": "United States",
    "state": "New Jersey",
    "city": null,
    "star_count": 3.3,
    "rating_count": 3,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Alpi Industrial Supply",
    "address": "12**********",
    "phone": "********9266",
    "email": "Jo**@al**********",
    "lat": 33.8518344,
    "lng": -117.8771855,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Placentia",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "MegaTherm",
    "address": "66**********",
    "phone": "********5588",
    "email": "ex****@me**********",
    "lat": 25.7739191,
    "lng": -80.1949873,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pipe suppliers"
  },
  {
    "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": "Howland Pump & Supply Co",
    "address": "76**********",
    "phone": "********3791",
    "email": "sl*****@ho**********",
    "lat": 44.6888999,
    "lng": -75.4724044,
    "url": "ht**********",
    "country": "United States",
    "state": "New York",
    "city": null,
    "star_count": 4.6,
    "rating_count": 30,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "T D Williamson Inc",
    "address": "26**********",
    "phone": "********9884",
    "email": "le******@in**********",
    "lat": 39.6619096,
    "lng": -75.6022251,
    "url": "ht**********",
    "country": "United States",
    "state": "Delaware",
    "city": "New Castle",
    "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": "ADS",
    "address": "10**********",
    "phone": "********9565",
    "email": "ad**********@ad**********",
    "lat": 41.4131355,
    "lng": -84.1011199,
    "url": "ht**********",
    "country": "United States",
    "state": "Ohio",
    "city": "Napoleon",
    "star_count": 3.3,
    "rating_count": 6,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "T.D. Williamson, Inc.",
    "address": "85**********",
    "phone": "********3950",
    "email": "le******@in**********",
    "lat": 61.1435212,
    "lng": -149.8759827,
    "url": "ht**********",
    "country": "United States",
    "state": "Alaska",
    "city": "Anchorage",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pipe suppliers"
  }
]