List of Pumping equipment and services in Northern America

[
  {
    "name": "Global Drilling Resources",
    "address": "1 **********",
    "phone": "********1527",
    "email": "sa***@dr**********",
    "lat": 29.7611732,
    "lng": -95.4627884,
    "url": "ht**********",
    "country": "United States",
    "state": "Texas",
    "city": "Houston",
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Drilling contractors,Drilling equipment suppliers,Oil field equipment suppliers,Well drilling contractors,Industrial chemicals wholesalers,Chemical Exporters,Water Filter Suppliers,Oil & natural gas companies,Pump suppliers,Pumping equipment and services,Air compressor suppliers"
  },
  {
    "name": "West Country Pump and Filtration Ltd.",
    "address": "59**********",
    "phone": "********3640",
    "email": "In**@wa*******",
    "lat": 51.0008069,
    "lng": -113.9857258,
    "url": "ht**********",
    "country": "Canada",
    "state": "Alberta",
    "city": "Calgary",
    "star_count": 5,
    "rating_count": 14,
    "category_name": "Water softening equipment suppliers,Water treatment suppliers,Water tank cleaning services,Water Pump Suppliers,Water Tank Cleaners,Water Filter Suppliers,Pumping equipment and services,Pump suppliers,Water purification companies"
  },
  {
    "name": "Xylem Chicago - Pump Rental & Sales",
    "address": "96**********",
    "phone": "********1560",
    "email": "an********@xy*******",
    "lat": 41.5369908,
    "lng": -87.8533997,
    "url": "ht**********",
    "country": "United States",
    "state": "Illinois",
    "city": "Chicago",
    "star_count": 4,
    "rating_count": 4,
    "category_name": "Pumping equipment and services,Pump suppliers,Construction equipment suppliers,Water treatment suppliers,Equipment rental agencies,Water Pump Suppliers"
  },
  {
    "name": "Mega-Therm",
    "address": "80**********",
    "phone": "********5588",
    "email": "ex****@me**********",
    "lat": 25.7658841,
    "lng": -80.1912117,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Pump suppliers,Pumping equipment and services"
  },
  {
    "name": "GEO Plumbing & Heating",
    "address": "10**********",
    "phone": "********5853",
    "email": "ge*********@co*********",
    "lat": 41.3530189,
    "lng": -72.6465538,
    "url": "ht**********",
    "country": "United States",
    "state": "Connecticut",
    "city": "Madison",
    "star_count": 4.8,
    "rating_count": 6,
    "category_name": "Bathroom remodelers,Air conditioning repair services,Air conditioning contractors,Kitchen remodelers,Remodelers,Pumping equipment and services,Pump suppliers,General contractors,HVAC contractors,Plumbers"
  },
  {
    "name": "Arrow Plumbing Drain & Repair Service",
    "address": "32**********",
    "phone": "********1791",
    "email": "ar**********@gm*******",
    "lat": 34.9449269,
    "lng": -120.4323576,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "Santa Maria",
    "star_count": 4.9,
    "rating_count": 234,
    "category_name": "Pumping equipment and services,Pump suppliers,Plumbers"
  },
  {
    "name": "Lift Stations \"R\" Us, Corporation.",
    "address": "57**********",
    "phone": "********2121",
    "email": "in**@li**********",
    "lat": 25.8253736,
    "lng": -80.2568945,
    "url": "ht**********",
    "country": "United States",
    "state": "Florida",
    "city": "Miami",
    "star_count": 4.1,
    "rating_count": 24,
    "category_name": "Plumbers,Water Pump Suppliers,Sewage disposal services,Drainage services,Pumping equipment and services,Pump suppliers"
  },
  {
    "name": "Northwest Pump",
    "address": "44**********",
    "phone": "********7867",
    "email": "cu**********@nw********",
    "lat": 37.5021752,
    "lng": -121.9578673,
    "url": "ht**********",
    "country": "United States",
    "state": "California",
    "city": "San Francisco",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Pump suppliers,Pumping equipment and services,Air compressor suppliers,Industrial equipment suppliers,Petroleum Products Companies"
  },
  {
    "name": "R.F. MacDonald Co.",
    "address": "66**********",
    "phone": "********6680",
    "email": "in**@rf**********",
    "lat": 36.0697588,
    "lng": -115.1934264,
    "url": "ht**********",
    "country": "United States",
    "state": "Nevada",
    "city": "Las Vegas",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Industrial equipment suppliers,Heating contractors,Heating equipment suppliers,Boiler suppliers,Water Pump Suppliers,Contractors,Hot water system suppliers,Pumping equipment and services,Pump suppliers"
  },
  {
    "name": "Northwest Pump",
    "address": "28**********",
    "phone": "********7867",
    "email": "cu**********@nw********",
    "lat": 45.54269,
    "lng": -122.71293,
    "url": "ht**********",
    "country": "United States",
    "state": "Oregon",
    "city": "Portland",
    "star_count": 5,
    "rating_count": 7,
    "category_name": "Petroleum Products Companies,Industrial equipment suppliers,Air compressor suppliers,Pumping equipment and services,Pump suppliers"
  }
]