List of Pubs in Missouri

[
  {
    "name": "Duke's",
    "address": "20**********",
    "phone": "********6686",
    "email": "in**@du**********",
    "lat": 38.6080049,
    "lng": -90.2073668,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "St. Louis",
    "star_count": 4.3,
    "rating_count": 800,
    "category_name": "Bar & grills,Restaurants,Sports bars,Pubs"
  },
  {
    "name": "The Pub at Lake Timberline",
    "address": "93**********",
    "phone": "********8810",
    "email": "",
    "lat": 37.9905377,
    "lng": -90.5301575,
    "url": "",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 4.3,
    "rating_count": 68,
    "category_name": "Pubs"
  },
  {
    "name": "Gunter Hans",
    "address": "7 **********",
    "phone": "********4045",
    "email": "ev****@gu**********",
    "lat": 38.951031,
    "lng": -92.325786,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Columbia",
    "star_count": 4.5,
    "rating_count": 430,
    "category_name": "Wine bars,Beer gardens,German restaurants,Cocktail bars,Modern European restaurants,Event venues,Bars,Pubs,Restaurants"
  },
  {
    "name": "The Crack Fox",
    "address": "11**********",
    "phone": "********5064",
    "email": "ca****@th**********",
    "lat": 38.6292635,
    "lng": -90.19632,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "St. Louis",
    "star_count": 4.7,
    "rating_count": 673,
    "category_name": "Bars,Pubs,Karaokes,Live music venues,Dance halls"
  },
  {
    "name": "Madison Bootlegger's Club",
    "address": "10**********",
    "phone": "********3009",
    "email": "",
    "lat": 39.4237379,
    "lng": -93.1294738,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 4.6,
    "rating_count": 41,
    "category_name": "Pubs"
  },
  {
    "name": "Dennis' Place",
    "address": "92**********",
    "phone": "********8373",
    "email": "",
    "lat": 37.1827238,
    "lng": -93.3025927,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Springfield",
    "star_count": 4.3,
    "rating_count": 652,
    "category_name": "Pubs,Cocktail bars"
  },
  {
    "name": "Riley's Pub",
    "address": "34**********",
    "phone": "********7474",
    "email": "",
    "lat": 38.6021991,
    "lng": -90.2398413,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "St. Louis",
    "star_count": 4.6,
    "rating_count": 388,
    "category_name": "Pubs,Cocktail bars"
  },
  {
    "name": "The Backlot",
    "address": "40**********",
    "phone": "********9599",
    "email": "ma******@al**********",
    "lat": 37.1420214,
    "lng": -93.2947089,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Springfield",
    "star_count": 4.5,
    "rating_count": 124,
    "category_name": "Wine bars,Beer halls,Cocktail bars,Bars,Restaurants,Pubs,Bar & grills"
  },
  {
    "name": "Blackthorn Pizza & Pub",
    "address": "51**********",
    "phone": "********2485",
    "email": "",
    "lat": 37.086363,
    "lng": -94.5146093,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": "Galena",
    "star_count": 4.6,
    "rating_count": 507,
    "category_name": "Irish pubs,Bars,Pubs,Pizza restaurants,Italian restaurants,Night clubs,Live music venues,Pool halls"
  },
  {
    "name": "Playhouse Bar and Grill",
    "address": "21**********",
    "phone": "********5560",
    "email": "",
    "lat": 39.6598129,
    "lng": -93.4427185,
    "url": "ht**********",
    "country": "United States",
    "state": "Missouri",
    "city": null,
    "star_count": 4.6,
    "rating_count": 105,
    "category_name": "Pubs"
  }
]