List of Pumping equipment and services in Missouri

[
  {
    "name": "Pipe and Duct Systems LLC",
    "address": "20**********",
    "phone": "********5700",
    "email": "se*****@pi**********",
    "lat": 38.5482093,
    "lng": -90.447673,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "St. Louis",
    "star_count": 4.2,
    "rating_count": 5,
    "category_name": "Pipe suppliers,HVAC contractors,Mechanical contractors,Pump suppliers,Pumping equipment and services"
  },
  {
    "name": "Zoellner Construction Co Inc",
    "address": "20**********",
    "phone": "********8030",
    "email": "co*****@zc******",
    "lat": 37.7011409,
    "lng": -89.8955202,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Perryville",
    "star_count": 4.9,
    "rating_count": 8,
    "category_name": "Construction companies,Steel erectors,Crane services,Real Estate Builders & Construction Companies,General contractors,Pumping equipment and services,Pump suppliers"
  },
  {
    "name": "Tom Schroeder Rotary Drilling And Pump Company",
    "address": "32**********",
    "phone": "********4620",
    "email": "in**@sc**********",
    "lat": 38.438891,
    "lng": -93.0917868,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 4.3,
    "rating_count": 12,
    "category_name": "Well drilling contractors,Pumping equipment and services,Pump suppliers"
  },
  {
    "name": "Johnson's Pump Service LLC",
    "address": "22**********",
    "phone": "********8886",
    "email": "il*********@gm*******",
    "lat": 37.7753856,
    "lng": -93.6516222,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 4.6,
    "rating_count": 16,
    "category_name": "Contractors,Pump suppliers,Pumping equipment and services,Well drilling contractors"
  },
  {
    "name": "Reed's Plumbing & Excavating",
    "address": "61**********",
    "phone": "********7566",
    "email": "of****@re**********",
    "lat": 37.229455,
    "lng": -93.296627,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Springfield",
    "star_count": 4.7,
    "rating_count": 635,
    "category_name": "Septic system services,Pumping equipment and services,Pump suppliers,Sewage disposal services,Excavating contractors,Plumbers"
  },
  {
    "name": "C & D Plumbing",
    "address": "13**********",
    "phone": "********4972",
    "email": "br*********@gm*******",
    "lat": 36.6117087,
    "lng": -93.2257424,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Branson",
    "star_count": 4.8,
    "rating_count": 38,
    "category_name": "Plumbers,Pump suppliers,Pumping equipment and services"
  },
  {
    "name": "Brabazon Pump & Compressor",
    "address": "25**********",
    "phone": "********2156",
    "email": "sa**********@br**********",
    "lat": 38.7112067,
    "lng": -90.4399945,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "St. Louis",
    "star_count": 0,
    "rating_count": 0,
    "category_name": "Air compressor suppliers,Pumping equipment and services,Pump suppliers"
  },
  {
    "name": "Raney's Well & Pump Service",
    "address": "30**********",
    "phone": "********2024",
    "email": "ra**********@gm*******",
    "lat": 36.6220017,
    "lng": -90.7921019,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Doniphan",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Pumping equipment and services,Pump suppliers,Water Pump Suppliers,Water softening equipment suppliers"
  },
  {
    "name": "Pump Shop",
    "address": "49**********",
    "phone": "********9806",
    "email": "in**@MM**********",
    "lat": 38.6003522,
    "lng": -90.2742815,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "St. Louis",
    "star_count": 5,
    "rating_count": 5,
    "category_name": "Machine shops,Pump suppliers,Pumping equipment and services"
  },
  {
    "name": "Powerflow Fluid Systems",
    "address": "10**********",
    "phone": "********3800",
    "email": "cu*********@pw*******",
    "lat": 38.8890029,
    "lng": -94.3800259,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Lee's Summit",
    "star_count": 5,
    "rating_count": 1,
    "category_name": "Pump suppliers,Hydraulic equipment suppliers,Hydraulic repair services,Pumping equipment and services,Air filter suppliers,Water Filter Suppliers,Manufacturers,Power plant equipment suppliers,Industrial equipment suppliers"
  }
]