List of Pumping equipment and services in North America

[
  {
    "name": "Dynapro Pumps Mexico (Oficinas Administrativas)",
    "address": "Ca**********",
    "phone": "********7372",
    "email": "sa***@dy**********",
    "lat": 28.8395792,
    "lng": -111.5114902,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Sonora",
    "city": "Hermosillo",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pumping equipment and services,Pump suppliers"
  },
  {
    "name": "Dynapro Pumps",
    "address": "Ca**********",
    "phone": "********5867",
    "email": "sa***@dy**********",
    "lat": 29.0800021,
    "lng": -111.0757078,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Sonora",
    "city": "Hermosillo",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Mining equipments,Pumping equipment and services,Pump suppliers"
  },
  {
    "name": "Eszett Sellos Mecánicos",
    "address": "Mi**********",
    "phone": "********5341",
    "email": "ve****@es**********",
    "lat": 20.5673372,
    "lng": -100.3800788,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Querétaro",
    "city": null,
    "star_count": 4.3,
    "rating_count": 15,
    "category_name": "Pumping equipment and services,Pump suppliers,Corporate campus,Corporate offices"
  },
  {
    "name": "Hidrosistemas Baja",
    "address": "C.**********",
    "phone": "********9091",
    "email": "co******@hb*******",
    "lat": 32.5095474,
    "lng": -116.8974198,
    "url": "ht**********",
    "country": "Mexico",
    "state": "Baja California",
    "city": "Tijuana",
    "star_count": 4.3,
    "rating_count": 3,
    "category_name": "Fire protection equipment suppliers,Fire protection consultants,Fire protection system suppliers,Fire alarm suppliers,Pumping equipment and services,Pump suppliers"
  },
  {
    "name": "Environmental Pump & Drain Line Solutions",
    "address": "51**********",
    "phone": "********6066",
    "email": "co*******@ep********",
    "lat": 35.552292,
    "lng": -80.993394,
    "url": "ht**********",
    "country": "United States",
    "state": "North Carolina",
    "city": "Lake Norman of Catawba",
    "star_count": 4,
    "rating_count": 4,
    "category_name": "Plumbers,Septic system services,Pumping equipment and services,Pump suppliers,Drainage services"
  },
  {
    "name": "CPS Distributors",
    "address": "17**********",
    "phone": "********1360",
    "email": "go*****@cp**********",
    "lat": 39.7447714,
    "lng": -104.8078688,
    "url": "ht**********",
    "country": "United States",
    "state": "Colorado",
    "city": "Aurora",
    "star_count": 4.2,
    "rating_count": 14,
    "category_name": "Paving materials suppliers,Landscaping supply stores,Pumping equipment and services,Pump suppliers,Wholesalers,Lawn irrigation equipment suppliers,Water Pump Suppliers"
  },
  {
    "name": "Davis Pump",
    "address": "50**********",
    "phone": "********0660",
    "email": "ch******@Cy**********",
    "lat": 35.6304538,
    "lng": -97.491657,
    "url": "ht**********",
    "country": "United States",
    "state": "Oklahoma",
    "city": "Oklahoma City",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pumping equipment and services,Pump suppliers"
  },
  {
    "name": "Goods Plumbing Heating & AC",
    "address": "13**********",
    "phone": "********6038",
    "email": "te********@gm*******",
    "lat": 40.3163739,
    "lng": -79.7506338,
    "url": "ht**********",
    "country": "United States",
    "state": "Pennsylvania",
    "city": null,
    "star_count": 4.8,
    "rating_count": 180,
    "category_name": "Plumbers,HVAC contractors,Pumping equipment and services,Pump suppliers,Excavating contractors,Furnace repair services,Air conditioning repair services"
  },
  {
    "name": "R.F. MacDonald Co.",
    "address": "99**********",
    "phone": "********0300",
    "email": "in**@rf**********",
    "lat": 39.5511282,
    "lng": -119.5520009,
    "url": "ht**********",
    "country": "United States",
    "state": "Nevada",
    "city": null,
    "star_count": 4.7,
    "rating_count": 3,
    "category_name": "Heating contractors,Heating equipment suppliers,Fabrication Engineers,Hot water system suppliers,Contractors,Pumping equipment and services,Pump suppliers,Boiler suppliers,Water Pump Suppliers"
  },
  {
    "name": "Wastecorp Pumps",
    "address": "34**********",
    "phone": "********2783",
    "email": "in**@wa**********",
    "lat": 40.7890465,
    "lng": -73.9796885,
    "url": "ht**********",
    "country": "United States",
    "state": "New York",
    "city": "New York City",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pump suppliers,Sewage treatment plants,Pumping equipment and services,Sanitation services,Industrial equipment suppliers,Tool stores,Manufacturers"
  }
]