Elenco di Fornitori di attrezzature per acquedotti in America del Nord

[
  {
    "name": "F.W. Webb Company (Waterworks Division) - Latham",
    "address": "7 **********",
    "phone": "********5537",
    "email": "MC*@FW********",
    "lat": 42.7368701,
    "lng": -73.795035,
    "url": "ht**********",
    "country": "United States",
    "state": "New York",
    "city": "Colonie",
    "star_count": 4.8,
    "rating_count": 5,
    "category_name": "Water works equipment suppliers,Pipe suppliers"
  },
  {
    "name": "ICONIX Waterworks Limited Partnership",
    "address": "70**********",
    "phone": "********8998",
    "email": "in*******@ic**********",
    "lat": 50.3124437,
    "lng": -119.2448389,
    "url": "ht**********",
    "country": "Canada",
    "state": "British Columbia",
    "city": null,
    "star_count": 4.2,
    "rating_count": 5,
    "category_name": "Water works equipment suppliers,Pipe suppliers,Industrial equipment suppliers,Construction equipment suppliers,Water utility companies,Irrigation equipment suppliers"
  },
  {
    "name": "ICONIX Waterworks Limited Partnership",
    "address": "85**********",
    "phone": "********4100",
    "email": "in*******@ic**********",
    "lat": 50.977321,
    "lng": -113.964667,
    "url": "ht**********",
    "country": "Canada",
    "state": "Alberta",
    "city": "Calgary",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Irrigation equipment suppliers,Construction equipment suppliers,Water utility companies,Industrial equipment suppliers,Water works equipment suppliers,Pipe suppliers"
  },
  {
    "name": "Kasco Marine Inc",
    "address": "80**********",
    "phone": "********4488",
    "email": "su*****@ka**********",
    "lat": 44.7620964,
    "lng": -92.796318,
    "url": "ht**********",
    "country": "United States",
    "state": "Wisconsin",
    "city": "Prescott",
    "star_count": 4.4,
    "rating_count": 23,
    "category_name": "Water works equipment suppliers"
  },
  {
    "name": "SchellVac Equipment Inc.",
    "address": "12**********",
    "phone": "********0081",
    "email": "ma*******@sc**********",
    "lat": 49.957489,
    "lng": -97.238279,
    "url": "ht**********",
    "country": "Canada",
    "state": "Manitoba",
    "city": null,
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Water works equipment suppliers"
  },
  {
    "name": "ICONIX Waterworks (US) Inc.",
    "address": "28**********",
    "phone": "********7518",
    "email": "in*******@ic**********",
    "lat": 47.0216839,
    "lng": -122.9563799,
    "url": "ht**********",
    "country": "United States",
    "state": "Washington",
    "city": "Olympia",
    "star_count": 4.5,
    "rating_count": 12,
    "category_name": "Pipe suppliers,Water utility companies,Water works equipment suppliers,Industrial equipment suppliers,Construction equipment suppliers,Water Pump Suppliers"
  },
  {
    "name": "Agos Rentals",
    "address": "",
    "phone": "********8590",
    "email": "ag**********@gm*******",
    "lat": 25.960451,
    "lng": -80.2034624,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 5,
    "rating_count": 6,
    "category_name": "Companies,Water works equipment suppliers,Service establishments"
  },
  {
    "name": "Indoor Water Conservation",
    "address": "75**********",
    "phone": "********4705",
    "email": "rs******@in**********",
    "lat": 32.6452711,
    "lng": -117.0018468,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Diego",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water works equipment suppliers"
  },
  {
    "name": "ICONIX Waterworks Limited Partnership",
    "address": "27**********",
    "phone": "********0055",
    "email": "in*******@ic**********",
    "lat": 48.4558979,
    "lng": -123.378402,
    "url": "ht**********",
    "country": "Canada",
    "state": "British Columbia",
    "city": null,
    "star_count": 3.8,
    "rating_count": 4,
    "category_name": "Water works equipment suppliers,Pipe suppliers,Industrial equipment suppliers,Construction equipment suppliers,Water utility companies,Irrigation equipment suppliers"
  },
  {
    "name": "ICONIX Waterworks (US) Inc.",
    "address": "80**********",
    "phone": "********2030",
    "email": "in*******@ic**********",
    "lat": 45.5679437,
    "lng": -122.8977407,
    "url": "ht**********",
    "country": "United States",
    "state": "Oregon",
    "city": "Portland",
    "star_count": 4,
    "rating_count": 2,
    "category_name": "Industrial equipment suppliers,Water works equipment suppliers,Pipe suppliers,Construction equipment suppliers,Water utility companies"
  }
]