Elenco di Fornitori di attrezzature per acquedotti in Nord America

[
  {
    "name": "ICONIX Waterworks (US) Inc.",
    "address": "60**********",
    "phone": "********1358",
    "email": "in*******@ic**********",
    "lat": 37.8940476,
    "lng": -121.2765112,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Stockton",
    "star_count": 4,
    "rating_count": 4,
    "category_name": "Water utility companies,Irrigation equipment suppliers,Water works equipment suppliers,Industrial equipment suppliers,Construction equipment suppliers"
  },
  {
    "name": "Utility Technologies, LLC",
    "address": "53**********",
    "phone": "********1940",
    "email": "sa***@ut*********",
    "lat": 39.4342957,
    "lng": -84.2174844,
    "url": "ht**********",
    "country": "United States",
    "state": "Ohio",
    "city": "Cincinnati",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Water works equipment suppliers,Industrial equipment suppliers,Tool stores,GPS suppliers,Water works,Plumbing supply stores,Stores,Consultants"
  },
  {
    "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": "ICONIX Waterworks (US) Inc.",
    "address": "16**********",
    "phone": "********5958",
    "email": "in*******@ic**********",
    "lat": 48.4544162,
    "lng": -122.3282656,
    "url": "ht**********",
    "country": "United States",
    "state": "Washington",
    "city": "Mount Vernon",
    "star_count": 4.9,
    "rating_count": 15,
    "category_name": "Pipe suppliers,Construction equipment suppliers,Industrial equipment suppliers,Water works equipment suppliers,Water utility companies"
  },
  {
    "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": "23**********",
    "phone": "********0378",
    "email": "in*******@ic**********",
    "lat": 34.9176593,
    "lng": -120.4606781,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Santa Maria",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water utility companies,Construction equipment suppliers,Industrial equipment suppliers,Pipe suppliers,Water works equipment suppliers"
  },
  {
    "name": "Parjana Distribution",
    "address": "21**********",
    "phone": "********5418",
    "email": "in**@pa**********",
    "lat": 42.4467315,
    "lng": -83.2545242,
    "url": "ht**********",
    "country": "United States",
    "state": "Michigan",
    "city": "Detroit",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Water works equipment suppliers"
  },
  {
    "name": "Spartan Fire Hydrants - by Sigelock Systems, LLC",
    "address": "",
    "phone": "********3510",
    "email": "in**@si**********",
    "lat": 40.6434759,
    "lng": -73.6675186,
    "url": "ht**********",
    "country": "United States",
    "state": "New York",
    "city": "Hempstead",
    "star_count": 5,
    "rating_count": 3,
    "category_name": "Companies,Service establishments,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"
  }
]