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

[
  {
    "name": "Raaj Tubes",
    "address": "14**********",
    "phone": "********8000",
    "email": "ra*******@ra**********",
    "lat": 42.0120505,
    "lng": -88.1498004,
    "url": "ht**********",
    "country": "United States",
    "state": "Illinois",
    "city": "Chicago",
    "star_count": 0,
    "rating_count": 0,
    "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": "Lincoln Winwater Works Co.",
    "address": "51**********",
    "phone": "********2988",
    "email": "sa***@li**********",
    "lat": 40.818472,
    "lng": -96.760156,
    "url": "ht**********",
    "country": "United States",
    "state": "Nebraska",
    "city": "Lincoln",
    "star_count": 4.2,
    "rating_count": 5,
    "category_name": "Water works,Pipe suppliers,Wholesalers"
  },
  {
    "name": "Drainage Solutions Inc. (Greenfield)",
    "address": "31**********",
    "phone": "********2210",
    "email": "sa****@dr**********",
    "lat": 39.7805353,
    "lng": -85.8621832,
    "url": "ht**********",
    "country": "United States",
    "state": "Indiana",
    "city": "Indianapolis",
    "star_count": 3.9,
    "rating_count": 11,
    "category_name": "Water softening equipment suppliers,Water Filter Suppliers,Pipe suppliers,Pumping equipment and services,Pump suppliers,Water Pump Suppliers"
  },
  {
    "name": "Chevron Pipe Line Co",
    "address": "10**********",
    "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": "Oneida Plumbing Supply",
    "address": "43**********",
    "phone": "********5600",
    "email": "es****@ho**********",
    "lat": 43.0928258,
    "lng": -75.6602809,
    "url": "",
    "country": "United States",
    "state": "New York",
    "city": "Oneida",
    "star_count": 4.5,
    "rating_count": 44,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "ADS",
    "address": "2n**********",
    "phone": "********3232",
    "email": "ad**********@ad**********",
    "lat": 43.8884785,
    "lng": -92.850296,
    "url": "ht**********",
    "country": "United States",
    "state": "Minnesota",
    "city": "Hayfield",
    "star_count": 0,
    "rating_count": 0,
    "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"
  },
  {
    "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": 4.2,
    "rating_count": 59,
    "category_name": "Pipe 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"
  }
]