Amerika Birleşik Devletleri içindeki Su işleri ekipman tedarikçileri Listesi

[
  {
    "name": "ICONIX Waterworks (US) Inc.",
    "address": "37**********",
    "phone": "********3311",
    "email": "in*******@ic**********",
    "lat": 37.3872466,
    "lng": -121.9543489,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Jose",
    "star_count": 4.7,
    "rating_count": 6,
    "category_name": "Water utility companies,Industrial equipment suppliers,Water works equipment suppliers,Pipe suppliers,Construction equipment suppliers"
  },
  {
    "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 (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,Water works equipment suppliers,Pipe suppliers"
  },
  {
    "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": "Water Works Supply Corporation.",
    "address": "86**********",
    "phone": "********1238",
    "email": "wa********@fw********",
    "lat": 42.4294954,
    "lng": -71.0450312,
    "url": "ht**********",
    "country": "United States",
    "state": "Massachusetts",
    "city": "Boston",
    "star_count": 5,
    "rating_count": 5,
    "category_name": "Water works equipment 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": "Water utility companies,Industrial equipment suppliers,Water works equipment suppliers,Pipe suppliers,Construction 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": "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"
  },
  {
    "name": "F.W. Webb Company - Water Works Division",
    "address": "10**********",
    "phone": "********3181",
    "email": "JS***@FW********",
    "lat": 43.0844605,
    "lng": -76.1517455,
    "url": "ht**********",
    "country": "United States",
    "state": "New York",
    "city": "Syracuse",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Water works equipment suppliers"
  },
  {
    "name": "H R Prescott Sons Inc",
    "address": "55**********",
    "phone": "********6701",
    "email": "in**@hr**********",
    "lat": 42.582943,
    "lng": -71.2722553,
    "url": "ht**********",
    "country": "United States",
    "state": "Massachusetts",
    "city": "Boston",
    "star_count": 4,
    "rating_count": 4,
    "category_name": "Water works equipment suppliers,Water works"
  }
]