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

[
  {
    "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": "Pipe suppliers,Water softening equipment suppliers,Water Pump Suppliers,Water Filter Suppliers,Pumping equipment and services,Pump suppliers"
  },
  {
    "name": "O'Tool Industries",
    "address": "13**********",
    "phone": "********1822",
    "email": "Sa***@ot*******",
    "lat": 33.6071691,
    "lng": -101.8506583,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Lubbock",
    "star_count": 4.6,
    "rating_count": 48,
    "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": "Coyle Supply, Inc",
    "address": "14**********",
    "phone": "********1710",
    "email": "ah***@co**********",
    "lat": 39.103909,
    "lng": -94.608953,
    "url": "ht**********",
    "country": "United States",
    "state": "Kansas",
    "city": "Kansas City",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Hardware stores,Plumbing supply stores,Industrial equipment suppliers,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.4,
    "rating_count": 18,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Drainage Solutions Inc. (Leesburg)",
    "address": "79**********",
    "phone": "********4216",
    "email": "sa****@dr**********",
    "lat": 41.3216974,
    "lng": -85.859374,
    "url": "ht**********",
    "country": "United States",
    "state": "Indiana",
    "city": null,
    "star_count": 5,
    "rating_count": 4,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Advanced Drainage Systems (ADS)",
    "address": "24**********",
    "phone": "********2055",
    "email": "ad**********@ad**********",
    "lat": 40.8468685,
    "lng": -111.9194791,
    "url": "ht**********",
    "country": "United States",
    "state": "Utah",
    "city": "North Salt Lake",
    "star_count": 3.9,
    "rating_count": 49,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "T D Williamson Inc",
    "address": "52**********",
    "phone": "********0791",
    "email": "le******@in**********",
    "lat": 29.4834732,
    "lng": -98.3876444,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "San Antonio",
    "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": "Harrington Corporation",
    "address": "11**********",
    "phone": "********1044",
    "email": "Sa***@ha**********",
    "lat": 33.4602612,
    "lng": -112.1061919,
    "url": "ht**********",
    "country": "United States",
    "state": "Arizona",
    "city": "Phoenix",
    "star_count": 3,
    "rating_count": 2,
    "category_name": "Pipe suppliers"
  }
]