北アメリカのパイプ供給者のリスト

[
  {
    "name": "ADS",
    "address": "16**********",
    "phone": "********2160",
    "email": "ad**********@ad**********",
    "lat": 41.5611139,
    "lng": -89.0736092,
    "url": "ht**********",
    "country": "United States",
    "state": "Illinois",
    "city": "Mendota",
    "star_count": 4.1,
    "rating_count": 76,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "BK Products",
    "address": "15**********",
    "phone": "********3200",
    "email": "Co*******@bk**********",
    "lat": 35.04158,
    "lng": -89.7026749,
    "url": "ht**********",
    "country": "United States",
    "state": "Tennessee",
    "city": "Memphis",
    "star_count": 1,
    "rating_count": 1,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Urecon Inc",
    "address": "32**********",
    "phone": "********4125",
    "email": "ur********@ge**********",
    "lat": 43.4489866,
    "lng": -79.6663875,
    "url": "ht**********",
    "country": "Canada",
    "state": "Ontario",
    "city": "Oakville",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "The Pipe Yard, Inc.",
    "address": "15**********",
    "phone": "********6322",
    "email": "in**@th**********",
    "lat": 29.5837211,
    "lng": -95.4050674,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 3.8,
    "rating_count": 8,
    "category_name": "Surplus stores,Pipe suppliers,Environmental Protection Organizations"
  },
  {
    "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": "Webco Industries VAF Reno PA",
    "address": "32**********",
    "phone": "******** 109",
    "email": "Po**********@we**********",
    "lat": 41.4158744,
    "lng": -79.7579421,
    "url": "ht**********",
    "country": "United States",
    "state": "Pennsylvania",
    "city": "Sugarcreek",
    "star_count": 4.8,
    "rating_count": 33,
    "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": "Stainless Products Division",
    "address": "50**********",
    "phone": "********4741",
    "email": "Po**********@we**********",
    "lat": 36.1259925,
    "lng": -96.3429387,
    "url": "ht**********",
    "country": "United States",
    "state": "Oklahoma",
    "city": "Mannford",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Pipe suppliers"
  },
  {
    "name": "Drainage Solutions, Inc. (Lebanon)",
    "address": "24**********",
    "phone": "********8788",
    "email": "sa****@dr**********",
    "lat": 40.0733341,
    "lng": -86.4753105,
    "url": "ht**********",
    "country": "United States",
    "state": "Indiana",
    "city": "Lebanon",
    "star_count": 4,
    "rating_count": 6,
    "category_name": "Pipe suppliers,Water softening equipment suppliers,Water Filter Suppliers,Water Pump Suppliers,Pumping equipment and services,Pump suppliers"
  },
  {
    "name": "Milford Companies",
    "address": "14**********",
    "phone": "********7624",
    "email": "co*******@mi**********",
    "lat": 35.6621074,
    "lng": -97.887755,
    "url": "ht**********",
    "country": "United States",
    "state": "Oklahoma",
    "city": "El Reno",
    "star_count": 3.8,
    "rating_count": 5,
    "category_name": "Pipe suppliers"
  }
]