List of Pumping equipment and services in Missouri

[
  {
    "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": "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.8,
    "rating_count": 12,
    "category_name": "Pumping equipment and services,Pump suppliers,Well drilling contractors,Contractors"
  },
  {
    "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,Pumping equipment and services,Pump suppliers,Mechanical contractors"
  },
  {
    "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": "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,Pumping equipment and services,Pump suppliers,Real Estate Builders & Construction Companies,Crane services,Steel erectors,General contractors"
  },
  {
    "name": "Reed's Plumbing & Excavating",
    "address": "61**********",
    "phone": "********6122",
    "email": "of****@re**********",
    "lat": 37.229455,
    "lng": -93.296627,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Springfield",
    "star_count": 4.5,
    "rating_count": 321,
    "category_name": "Plumbers,Sewage disposal services,Septic system services,Excavating contractors,Pumping equipment and services,Pump suppliers"
  },
  {
    "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": "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": 35,
    "category_name": "Plumbers,Pumping equipment and services,Pump suppliers"
  },
  {
    "name": "All Star Pumping and Sewer Inc.",
    "address": "88**********",
    "phone": "********7863",
    "email": "ma*****@ao*****",
    "lat": 38.8044982,
    "lng": -90.8356297,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "St. Louis",
    "star_count": 3.4,
    "rating_count": 5,
    "category_name": "Pumping equipment and services,Pump suppliers"
  },
  {
    "name": "4 States Mechanical",
    "address": "",
    "phone": "********9021",
    "email": "ki*@4s**********",
    "lat": 37.3356825,
    "lng": -94.3784666,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 5,
    "rating_count": 2,
    "category_name": "Welders,Pumping equipment and services,Pump suppliers,Service establishments,Air conditioning contractors,Mechanical contractors,Furnace repair services,Air conditioning repair services,Construction companies,Plumbers,Companies,Heating contractors,HVAC contractors,Real Estate Builders & Construction Companies"
  }
]