{"help": "https://data.wprdc.org/en/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_next_page": false, "include_total": true, "limit": 100, "records_format": "objects", "resource_id": "df5a8f8a-fcd7-4dda-85f7-37580dbfdee4", "records": [{"_id":1,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Rena Niaros Xillas","Trade_Name":"Fair Oaks Lounge","Bus_Physic":"660 Ambridge Avenue","Bus_Phys_1":"Fair Oaks","Bus_Phys_2":"PA","Bus_Phys_3":"15003","Latitude_A":"40.581116","Longitude_":"-80.213122","DE_LID_Num":"18605","License_Nu":"R-17352"},{"_id":2,"Shape":"Point","Bus_Type":"Drinking Establishment Type II","Status":"Approved","Establishm":"Karen V & Company, Inc.","Trade_Name":"Fat & Sassy Saloon","Bus_Physic":"815 Sixth Avenue","Bus_Phys_1":"Brackenridge","Bus_Phys_2":"PA","Bus_Phys_3":"15014","Latitude_A":"40.605678","Longitude_":"-79.745327","DE_LID_Num":"39003","License_Nu":"R-14307"},{"_id":3,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Boots, Inc.","Trade_Name":null,"Bus_Physic":"819 Second Avenue","Bus_Phys_1":"Brackenridge","Bus_Phys_2":"PA","Bus_Phys_3":"15014","Latitude_A":"40.604242","Longitude_":"-79.74427","DE_LID_Num":"50357","License_Nu":"R-12870"},{"_id":4,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Elizabeth A. Martonik","Trade_Name":"Ship's Wheel","Bus_Physic":"1114 Brackenridge Avenue","Bus_Phys_1":"Brackenridge","Bus_Phys_2":"PA","Bus_Phys_3":"15014","Latitude_A":"40.605942","Longitude_":"-79.735567","DE_LID_Num":"12997","License_Nu":"R-07931"},{"_id":5,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Ernies of Brackenridge, Inc.","Trade_Name":"Ernie's Tavern","Bus_Physic":"1102 Brackenridge Avenue","Bus_Phys_1":"Brackenridge","Bus_Phys_2":"PA","Bus_Phys_3":"15014","Latitude_A":"40.605475","Longitude_":"-79.735841","DE_LID_Num":"33730","License_Nu":"R-01662"},{"_id":6,"Shape":"Point","Bus_Type":"Tobacco Shop","Status":"Approved","Establishm":"Smoke Cigar Shop & Lounge, Inc.","Trade_Name":null,"Bus_Physic":"1597 Washington Pike Suite A16","Bus_Phys_1":"Brigeville","Bus_Phys_2":"PA","Bus_Phys_3":"15017","Latitude_A":"40.382618","Longitude_":"-80.095126","DE_LID_Num":null,"License_Nu":null},{"_id":7,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"The Wheel Bar, Inc.","Trade_Name":"The Wheel Inc.","Bus_Physic":"3058 Washington Pike","Bus_Phys_1":"Bridgeville","Bus_Phys_2":"PA","Bus_Phys_3":"15017","Latitude_A":"40.351654","Longitude_":"-80.114187","DE_LID_Num":"34008","License_Nu":"R-09652"},{"_id":8,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"ARTHUR B., INC.","Trade_Name":null,"Bus_Physic":"429 Railroad Street","Bus_Phys_1":"Bridgeville","Bus_Phys_2":"PA","Bus_Phys_3":"15017","Latitude_A":"40.358279","Longitude_":"-80.110262","DE_LID_Num":"24894","License_Nu":"R-00612"},{"_id":9,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"KEE-MAR, Inc.","Trade_Name":null,"Bus_Physic":"655 Baldwin Street","Bus_Phys_1":"Bridgeville","Bus_Phys_2":"PA","Bus_Phys_3":"15017","Latitude_A":"40.357986","Longitude_":"-80.106464","DE_LID_Num":"14129","License_Nu":"R-09968"},{"_id":10,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"J & J 1020 Restaurant, Inc.","Trade_Name":"RMP's","Bus_Physic":"1020 Washington Pike","Bus_Phys_1":"Bridgeville","Bus_Phys_2":"PA","Bus_Phys_3":"15017","Latitude_A":"40.366061","Longitude_":"-80.106456","DE_LID_Num":"36137","License_Nu":"R-04313"},{"_id":11,"Shape":"Point","Bus_Type":"Drinking Establishment Type II","Status":"Approved","Establishm":"Futules' Harmar House, Inc.","Trade_Name":"Futules' Harmar House","Bus_Physic":"1321 Freeport Road","Bus_Phys_1":"Cheswick","Bus_Phys_2":"PA","Bus_Phys_3":"15024","Latitude_A":"40.540882","Longitude_":"-79.810932","DE_LID_Num":"43236","License_Nu":"H-05609"},{"_id":12,"Shape":"Point","Bus_Type":"Drinking Establishment Type II","Status":"Approved","Establishm":"M.A.L.T.D., INC.","Trade_Name":"Tomasinos Restaurant & Lounge","Bus_Physic":"260 Little Deer Creek Road","Bus_Phys_1":"Cheswick","Bus_Phys_2":"PA","Bus_Phys_3":"15024","Latitude_A":"40.59846","Longitude_":"-79.828979","DE_LID_Num":"29240","License_Nu":"R-05579"},{"_id":13,"Shape":"Point","Bus_Type":"Drinking Establishment Type II","Status":"Approved","Establishm":"Vitale Business Corporation","Trade_Name":"Clyde & Patti's Lounge","Bus_Physic":"901 Freeport Road","Bus_Phys_1":"Cheswick","Bus_Phys_2":"PA","Bus_Phys_3":"15024","Latitude_A":"40.540989","Longitude_":"-79.816015","DE_LID_Num":"31810","License_Nu":"R-09644"},{"_id":14,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Blue Haven Lounge, Inc.","Trade_Name":"Blue Haven Lounge","Bus_Physic":"492 Nixon Road","Bus_Phys_1":"Cheswick","Bus_Phys_2":"PA","Bus_Phys_3":"15024","Latitude_A":"40.556097","Longitude_":"-79.820336","DE_LID_Num":"39529","License_Nu":"R-15645"},{"_id":15,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"The Wicked Witches' Dam View Hotel, Inc.","Trade_Name":null,"Bus_Physic":"919 Freeport Road RD 1","Bus_Phys_1":"Cheswick","Bus_Phys_2":"PA","Bus_Phys_3":"15024","Latitude_A":"40.541734","Longitude_":"-79.799215","DE_LID_Num":"48008","License_Nu":"H-00928"},{"_id":16,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Paterak Enterprises, Inc.","Trade_Name":"Tailgaters","Bus_Physic":"1101 Freeport Road","Bus_Phys_1":"Cheswick","Bus_Phys_2":"PA","Bus_Phys_3":"15024","Latitude_A":"40.540838","Longitude_":"-79.81357","DE_LID_Num":"39934","License_Nu":"R-13509"},{"_id":17,"Shape":"Point","Bus_Type":"Drinking Establishment Type II","Status":"Approved","Establishm":"The Frosted Mug, Inc.","Trade_Name":"Barker's Frosted Mug","Bus_Physic":"1608 Pittsburgh Street","Bus_Phys_1":"Cheswick","Bus_Phys_2":"PA","Bus_Phys_3":"15024","Latitude_A":"40.540897","Longitude_":"-79.797124","DE_LID_Num":"25073","License_Nu":"R-10249"},{"_id":18,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Loughlin's Pub","Trade_Name":"Loughlin's Pub","Bus_Physic":"2373 Saxonburg Boulevard","Bus_Phys_1":"Cheswick","Bus_Phys_2":"PA","Bus_Phys_3":"15024","Latitude_A":"40.607867","Longitude_":"-79.867851","DE_LID_Num":"63823","License_Nu":"R-14483"},{"_id":19,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"WAW, Inc.","Trade_Name":"Valley Hotel","Bus_Physic":"1004 New England Hollow Road","Bus_Phys_1":"Jefferson Hills","Bus_Phys_2":"PA","Bus_Phys_3":"15025","Latitude_A":"40.319139","Longitude_":"-79.899368","DE_LID_Num":"28128","License_Nu":"H-01392"},{"_id":20,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"T&T, Inc.","Trade_Name":"C-Notes Bar & Pizzeria","Bus_Physic":"524 North State Street","Bus_Phys_1":"Clairton","Bus_Phys_2":"PA","Bus_Phys_3":"15025","Latitude_A":"40.30914","Longitude_":"-79.889764","DE_LID_Num":"62861","License_Nu":"R-16698"},{"_id":21,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Sportsman Bar","Trade_Name":null,"Bus_Physic":"330 State Street","Bus_Phys_1":"Clairton","Bus_Phys_2":"PA","Bus_Phys_3":"15025","Latitude_A":"40.295627","Longitude_":"-79.874269","DE_LID_Num":"10784","License_Nu":"R-3039"},{"_id":22,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Brass Monkey Inc.","Trade_Name":null,"Bus_Physic":"428 North State Street","Bus_Phys_1":"Clairton","Bus_Phys_2":"PA","Bus_Phys_3":"15025","Latitude_A":"40.308386","Longitude_":"-79.888494","DE_LID_Num":"57639","License_Nu":"R-3855"},{"_id":23,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Farnan, Inc.","Trade_Name":null,"Bus_Physic":"823 Miller Avenue","Bus_Phys_1":"Clairton","Bus_Phys_2":"PA","Bus_Phys_3":"15025","Latitude_A":"40.286506","Longitude_":"-79.883876","DE_LID_Num":"54147","License_Nu":"R-08767"},{"_id":24,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Rose Marie Persin","Trade_Name":"Persin's Tavern","Bus_Physic":"Main Steet - PO Box 413","Bus_Phys_1":"Clinton","Bus_Phys_2":"PA","Bus_Phys_3":"15026","Latitude_A":"45.908476","Longitude_":"-92.958133","DE_LID_Num":"24341","License_Nu":"R-16710"},{"_id":25,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Pit Stop of West Deer, Inc.","Trade_Name":"Pit Stop","Bus_Physic":"1798 Saxonburg Boulevard PO Box 174","Bus_Phys_1":"Curtisville","Bus_Phys_2":"PA","Bus_Phys_3":"15032","Latitude_A":"40.639275","Longitude_":"-79.849339","DE_LID_Num":"48655","License_Nu":"R-15436"},{"_id":26,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"504 Park Avenue, LLC","Trade_Name":"The Rib Crib","Bus_Physic":"504 Park Avenue","Bus_Phys_1":"Elizabeth","Bus_Phys_2":"PA","Bus_Phys_3":"15037","Latitude_A":"40.272293","Longitude_":"-79.872271","DE_LID_Num":"65751","License_Nu":"R-06926"},{"_id":27,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Brewell Enterprises","Trade_Name":"The Shamrock","Bus_Physic":"100 Second Street","Bus_Phys_1":"Elizabeth","Bus_Phys_2":"PA","Bus_Phys_3":"15037","Latitude_A":"40.272859","Longitude_":"-79.886755","DE_LID_Num":"69271","License_Nu":"R-02205"},{"_id":28,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Southbound Bar and Grille, Inc.","Trade_Name":"Kickstand","Bus_Physic":"1100 Hayden Boulevard","Bus_Phys_1":"Elizabeth","Bus_Phys_2":"PA","Bus_Phys_3":"15037","Latitude_A":"40.224929","Longitude_":"-79.852315","DE_LID_Num":"54563","License_Nu":"R-14512"},{"_id":29,"Shape":"Point","Bus_Type":"Drinking Establishment Type II","Status":"Approved","Establishm":"CROSS CREEK INN, INC.","Trade_Name":null,"Bus_Physic":"620 Boston Hollow Road","Bus_Phys_1":"Elizabeth","Bus_Phys_2":"PA","Bus_Phys_3":"15037","Latitude_A":"40.292047","Longitude_":"-79.833603","DE_LID_Num":"40567","License_Nu":"R-04269"},{"_id":30,"Shape":"Point","Bus_Type":"Drinking Establishment Type II","Status":"Approved","Establishm":"Bar 48 & Grille","Trade_Name":"Bar 48 & Grille","Bus_Physic":"101 Simpson-Howell Road","Bus_Phys_1":"Elizabeth","Bus_Phys_2":"PA","Bus_Phys_3":"15037","Latitude_A":"40.272693","Longitude_":"-79.837216","DE_LID_Num":"63788","License_Nu":"R-02214"},{"_id":31,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Sylvester Skrinjorich / Dorothy M. Skrinjorich","Trade_Name":null,"Bus_Physic":"8800 Roberts Hollow Road","Bus_Phys_1":"Elizabeth","Bus_Phys_2":"PA","Bus_Phys_3":"15037","Latitude_A":"40.249732","Longitude_":"-79.878213","DE_LID_Num":"46212","License_Nu":"R-12814"},{"_id":32,"Shape":"Point","Bus_Type":"Drinking Establishment Type II","Status":"Approved","Establishm":"P. Walls, Inc.","Trade_Name":"Carriage Inn","Bus_Physic":"1601 Lovedale Road","Bus_Phys_1":"Elizabeth","Bus_Phys_2":"PA","Bus_Phys_3":"15037","Latitude_A":"40.284884","Longitude_":"-79.843913","DE_LID_Num":"10958","License_Nu":"R-03400"},{"_id":33,"Shape":"Point","Bus_Type":"Tobacco Shop","Status":"Approved","Establishm":"Klafter's Inc","Trade_Name":"Smoker Friendly/Cigar Express #6","Bus_Physic":"5325 Route 8","Bus_Phys_1":"Gibsonia","Bus_Phys_2":"PA","Bus_Phys_3":"15044","Latitude_A":"40.616898","Longitude_":"-79.946046","DE_LID_Num":null,"License_Nu":null},{"_id":34,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"LVKJR, INC.","Trade_Name":"Lenny's","Bus_Physic":"4118 Bakerstown-Culmerville Road","Bus_Phys_1":"Gibsonia","Bus_Phys_2":"PA","Bus_Phys_3":"15044","Latitude_A":"40.651519","Longitude_":"-79.916604","DE_LID_Num":"63571","License_Nu":"R-07304"},{"_id":35,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Hotel Richland, Inc.","Trade_Name":"Hotel Richland","Bus_Physic":"5370 William Flynn Highway","Bus_Phys_1":"Gibsonia","Bus_Phys_2":"PA","Bus_Phys_3":"15044","Latitude_A":"40.618461","Longitude_":"-79.945186","DE_LID_Num":"23390","License_Nu":"H-04148"},{"_id":36,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Mike's New Moon Saloon, Inc.","Trade_Name":"Mike's New Moon Saloon","Bus_Physic":"2059 Saxonburg Boulevard","Bus_Phys_1":"Gibsonia","Bus_Phys_2":"PA","Bus_Phys_3":"15044","Latitude_A":"40.624919","Longitude_":"-79.861025","DE_LID_Num":"49989","License_Nu":"R-14497"},{"_id":37,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Hott Rodz Inc.","Trade_Name":null,"Bus_Physic":"626 Monogahela Avenue","Bus_Phys_1":"Glassport","Bus_Phys_2":"PA","Bus_Phys_3":"15045","Latitude_A":"40.341953","Longitude_":"-79.885886","DE_LID_Num":"51871","License_Nu":"R-9717"},{"_id":38,"Shape":"Point","Bus_Type":"Tobacco Shop","Status":"Approved","Establishm":"Busch/Kearn, Inc.","Trade_Name":"Puff Discount Tobacco Store #3","Bus_Physic":"741 Monongahela Avenue","Bus_Phys_1":"Glassport","Bus_Phys_2":"PA","Bus_Phys_3":"15045","Latitude_A":"40.323026","Longitude_":"-79.892414","DE_LID_Num":null,"License_Nu":null},{"_id":39,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Chuggers, Inc.","Trade_Name":"Chuggers, Inc.","Bus_Physic":"709 Monongahela Avenue","Bus_Phys_1":"Glassport","Bus_Phys_2":"PA","Bus_Phys_3":"15045","Latitude_A":"40.323979","Longitude_":"-79.892149","DE_LID_Num":"31477","License_Nu":"R-12198"},{"_id":40,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Carol's Cafe","Trade_Name":"Carol A. Wagner","Bus_Physic":"840 Monongahela Avenue","Bus_Phys_1":"Glassport","Bus_Phys_2":"PA","Bus_Phys_3":"15045","Latitude_A":"40.32129","Longitude_":"-79.892703","DE_LID_Num":"36470","License_Nu":"R-13324"},{"_id":41,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"3 ELS LLC","Trade_Name":"Triple L's","Bus_Physic":"601 Allegheny Avenue","Bus_Phys_1":"Glassport","Bus_Phys_2":"PA","Bus_Phys_3":"15045","Latitude_A":"40.32585","Longitude_":"-79.893216","DE_LID_Num":"61466","License_Nu":"R-1453"},{"_id":42,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Tinkers","Trade_Name":"Tinkers","Bus_Physic":"62 McGovern Boulevard","Bus_Phys_1":"Crescent","Bus_Phys_2":"PA","Bus_Phys_3":"15046","Latitude_A":"40.554051","Longitude_":"-80.219763","DE_LID_Num":"10772","License_Nu":"R-02999"},{"_id":43,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Walker's Bar and Grill, Inc.","Trade_Name":null,"Bus_Physic":"176 McGovern Boulevard","Bus_Phys_1":"Crescent","Bus_Phys_2":"PA","Bus_Phys_3":"15046","Latitude_A":"40.565926","Longitude_":"-80.230182","DE_LID_Num":"61723","License_Nu":"R-13271"},{"_id":44,"Shape":"Point","Bus_Type":"Drinking Establishment Type II","Status":"Approved","Establishm":"Thomas Bassetti","Trade_Name":"Bear's Inn","Bus_Physic":"710 Hite Road","Bus_Phys_1":"Harwick","Bus_Phys_2":"PA","Bus_Phys_3":"15049","Latitude_A":"40.555478","Longitude_":"-79.808358","DE_LID_Num":"17579","License_Nu":"R-15773"},{"_id":45,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Have A Drink, Inc.","Trade_Name":"Marroni's","Bus_Physic":"108 Ohio River Boulevard at Riter Street","Bus_Phys_1":"Leetsdale","Bus_Phys_2":"PA","Bus_Phys_3":"15056","Latitude_A":"40.5629","Longitude_":"-80.207607","DE_LID_Num":"67564","License_Nu":"R-11368"},{"_id":46,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"North Star Hotel, Inc.","Trade_Name":"North Star Hotel","Bus_Physic":"8155 Steubenville Pike","Bus_Phys_1":"McDonald","Bus_Phys_2":"PA","Bus_Phys_3":"15057","Latitude_A":"40.431379","Longitude_":"-80.262913","DE_LID_Num":"36187","License_Nu":"H-00763"},{"_id":47,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Caddy Enterprises, Inc.","Trade_Name":"Fine's Castaway Lounge","Bus_Physic":"3383 Rainbow Run Road","Bus_Phys_1":"Monongahela","Bus_Phys_2":"PA","Bus_Phys_3":"15063","Latitude_A":"40.19989","Longitude_":"-79.867569","DE_LID_Num":"49642","License_Nu":"R-12912"},{"_id":48,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Sachmich, Inc.","Trade_Name":"Argonne Inn","Bus_Physic":"1257 Argonne Drive","Bus_Phys_1":"Natrona Heights","Bus_Phys_2":"PA","Bus_Phys_3":"15065","Latitude_A":"40.610179","Longitude_":"-79.732684","DE_LID_Num":"56310","License_Nu":"R-14462"},{"_id":49,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Rooster's Roadhouse Inc.","Trade_Name":null,"Bus_Physic":"5021 Thoms Run Road","Bus_Phys_1":"Oakdale","Bus_Phys_2":"PA","Bus_Phys_3":"15071","Latitude_A":"40.378879","Longitude_":"-80.146317","DE_LID_Num":"64591","License_Nu":"H-0739"},{"_id":50,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"The Sunset Inn, Inc.","Trade_Name":null,"Bus_Physic":"7992 Steubenville Pike","Bus_Phys_1":"Oakdale","Bus_Phys_2":"PA","Bus_Phys_3":"15071","Latitude_A":"40.442015","Longitude_":"-80.23775","DE_LID_Num":"13407","License_Nu":"R-08764"},{"_id":51,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Rylanco, Inc.","Trade_Name":null,"Bus_Physic":"7780 Steubenville Pike - Suite 1","Bus_Phys_1":"Oakdale","Bus_Phys_2":"PA","Bus_Phys_3":"15071","Latitude_A":"40.440113","Longitude_":"-80.21041","DE_LID_Num":"32978","License_Nu":"R-01242"},{"_id":52,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"The Lemon Tree, Inc.","Trade_Name":"The Lemon Tree","Bus_Physic":"Magnolia & Arlington Avenue","Bus_Phys_1":"Sturgeon","Bus_Phys_2":"PA","Bus_Phys_3":"15082","Latitude_A":"0","Longitude_":"0","DE_LID_Num":"14341","License_Nu":"R-10375"},{"_id":53,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Nvevat TVR, LLC","Trade_Name":"Rocco's Bar","Bus_Physic":"319 East 6th Avenue","Bus_Phys_1":"Tarentum","Bus_Phys_2":"PA","Bus_Phys_3":"15084","Latitude_A":"40.603055","Longitude_":"-79.753322","DE_LID_Num":"61359","License_Nu":"R-03176"},{"_id":54,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Joan Dimatto","Trade_Name":null,"Bus_Physic":"1762 Saxonburg Boulevard","Bus_Phys_1":"Tarentum","Bus_Phys_2":"PA","Bus_Phys_3":"15084","Latitude_A":"40.641554","Longitude_":"-79.851111","DE_LID_Num":"12099","License_Nu":"R-06074"},{"_id":55,"Shape":"Point","Bus_Type":"Tobacco Shop","Status":"Approved","Establishm":"Puffs-n-Stuff","Trade_Name":"Puffs-n-Stuff","Bus_Physic":"321 Pittsburgh Mills Circle","Bus_Phys_1":"Tarentum","Bus_Phys_2":"PA","Bus_Phys_3":"15084","Latitude_A":"40.575104","Longitude_":"-79.79593","DE_LID_Num":null,"License_Nu":null},{"_id":56,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Curtis W. Stepp","Trade_Name":null,"Bus_Physic":"240-242 West Seventh Avenue","Bus_Phys_1":"Tarentum","Bus_Phys_2":"PA","Bus_Phys_3":"15084","Latitude_A":"40.599755","Longitude_":"-79.762237","DE_LID_Num":"59389","License_Nu":"R-06825"},{"_id":57,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"JENNIFER L. GRAFF","Trade_Name":null,"Bus_Physic":"218 West Seventh Avenue","Bus_Phys_1":"Tarentum","Bus_Phys_2":"PA","Bus_Phys_3":"15084","Latitude_A":"40.60013","Longitude_":"-79.761543","DE_LID_Num":"38060","License_Nu":"R-07074"},{"_id":58,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"CAS-SUP, LTD.","Trade_Name":"Ziggy's Lounge","Bus_Physic":"201 East Sixth Avenue","Bus_Phys_1":"Tarentum","Bus_Phys_2":"PA","Bus_Phys_3":"15084","Latitude_A":"40.602195","Longitude_":"-79.755345","DE_LID_Num":"60804","License_Nu":"R-18330"},{"_id":59,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Elizabeth S. Hollenbaugh","Trade_Name":null,"Bus_Physic":"620 East Seventh Avenue","Bus_Phys_1":"Tarentum","Bus_Phys_2":"PA","Bus_Phys_3":"15084","Latitude_A":"40.605059","Longitude_":"-79.748236","DE_LID_Num":"16176","License_Nu":"R-13517"},{"_id":60,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Crossroads II, Inc.","Trade_Name":"Hotel Crossroads","Bus_Physic":"1502 Saxonburg Boulevard","Bus_Phys_1":"Tarentum","Bus_Phys_2":"PA","Bus_Phys_3":"15084","Latitude_A":"40.654372","Longitude_":"-79.838392","DE_LID_Num":"49206","License_Nu":"H-04377"},{"_id":61,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Timothy C. Zyra","Trade_Name":"Tim's Corner Bar","Bus_Physic":"700 Fourth Street","Bus_Phys_1":"West Elizabeth","Bus_Phys_2":"PA","Bus_Phys_3":"15088","Latitude_A":"40.272728","Longitude_":"-79.895983","DE_LID_Num":"15796","License_Nu":"R-12872"},{"_id":62,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Fripp Corporation","Trade_Name":null,"Bus_Physic":"Lots 235 and 236 Fifth Street - Route 837","Bus_Phys_1":"West Elizabeth","Bus_Phys_2":"PA","Bus_Phys_3":"15088","Latitude_A":"40.274655","Longitude_":"-79.894105","DE_LID_Num":"54655","License_Nu":"R-12774"},{"_id":63,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Dolores B. Spahr","Trade_Name":"Scotty's","Bus_Physic":"1200 Fifth Street","Bus_Phys_1":"West Elizabeth","Bus_Phys_2":"PA","Bus_Phys_3":"15088","Latitude_A":"40.268164","Longitude_":"-79.90427","DE_LID_Num":"14122","License_Nu":"R-09955"},{"_id":64,"Shape":"Point","Bus_Type":"Tobacco Shop","Status":"Approved","Establishm":"Klafters, Inc.","Trade_Name":"Smoker Friendly # 15","Bus_Physic":"11969 Perry Highway","Bus_Phys_1":"Wexford","Bus_Phys_2":"PA","Bus_Phys_3":"15090","Latitude_A":"40.630716","Longitude_":"-80.057967","DE_LID_Num":null,"License_Nu":null},{"_id":65,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Coles Wexford Hotel, Inc.","Trade_Name":null,"Bus_Physic":"161 Church Road","Bus_Phys_1":"Wexford","Bus_Phys_2":"PA","Bus_Phys_3":"15090","Latitude_A":"40.625597","Longitude_":"-80.055916","DE_LID_Num":"6307","License_Nu":"H-01537"},{"_id":66,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"S and L Pour, Inc.","Trade_Name":"The Pour House","Bus_Physic":"4655 William Flynn Highway Suite 118","Bus_Phys_1":"Allison Park","Bus_Phys_2":"PA","Bus_Phys_3":"15101","Latitude_A":"40.5922","Longitude_":"-79.94923","DE_LID_Num":"58607","License_Nu":"R-07518"},{"_id":67,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"JLDB, Inc.","Trade_Name":null,"Bus_Physic":"3888 William Flynn Highway","Bus_Phys_1":"Allison Park","Bus_Phys_2":"PA","Bus_Phys_3":"15101","Latitude_A":"40.558264","Longitude_":"-79.959059","DE_LID_Num":"47890","License_Nu":"R-04471"},{"_id":68,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Helmet Heads Bar & Grille LP","Trade_Name":"Helmet Heads Bar & Grille LP","Bus_Physic":"4962 Library Road","Bus_Phys_1":"Bethel Park","Bus_Phys_2":"PA","Bus_Phys_3":"15102","Latitude_A":"40.343783","Longitude_":"-80.027073","DE_LID_Num":"65890","License_Nu":"R-16515"},{"_id":69,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Tennyson Lodge, Inc.","Trade_Name":null,"Bus_Physic":"4797 Library Road","Bus_Phys_1":"Bethel Park","Bus_Phys_2":"PA","Bus_Phys_3":"15102","Latitude_A":"40.347443","Longitude_":"-80.026692","DE_LID_Num":"20042","License_Nu":"R-19200"},{"_id":70,"Shape":"Point","Bus_Type":"Drinking Establishment Type II","Status":"Approved","Establishm":"Tony's Villa, Inc.","Trade_Name":"Lemonheads Brightwood Grille","Bus_Physic":"5317 Brightwood Road","Bus_Phys_1":"Bethel Park","Bus_Phys_2":"PA","Bus_Phys_3":"15102","Latitude_A":"40.327395","Longitude_":"-80.030103","DE_LID_Num":"11656","License_Nu":"R-04992"},{"_id":71,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Chris' Bar, Inc.","Trade_Name":null,"Bus_Physic":"2783 South Park Road","Bus_Phys_1":"Bethel Park","Bus_Phys_2":"PA","Bus_Phys_3":"15102","Latitude_A":"40.327662","Longitude_":"-80.034669","DE_LID_Num":"59002","License_Nu":"R-09810"},{"_id":72,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"King's Bar & Grill, Inc.","Trade_Name":null,"Bus_Physic":"11 Fleet Street Rankin","Bus_Phys_1":"Braddock","Bus_Phys_2":"PA","Bus_Phys_3":"15104","Latitude_A":"40.407068","Longitude_":"-79.877333","DE_LID_Num":"47825","License_Nu":"R-00741"},{"_id":73,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"DOLORES, INC.","Trade_Name":null,"Bus_Physic":"115 West Braddock Avenue Rear","Bus_Phys_1":"Braddock","Bus_Phys_2":"PA","Bus_Phys_3":"15104","Latitude_A":"40.403402","Longitude_":"-79.868382","DE_LID_Num":"43107","License_Nu":"R-07776"},{"_id":74,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"DFC, Inc.","Trade_Name":"Lucky Franks","Bus_Physic":"312 Braddock Avenue","Bus_Phys_1":"Braddock","Bus_Phys_2":"PA","Bus_Phys_3":"15104","Latitude_A":"40.405133","Longitude_":"-79.872165","DE_LID_Num":"28914","License_Nu":"R-16529"},{"_id":75,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"B.E.D., INC.","Trade_Name":"Fairways Lounge","Bus_Physic":"1500 Locust Street","Bus_Phys_1":"North Braddock","Bus_Phys_2":"PA","Bus_Phys_3":"15104","Latitude_A":"40.409283","Longitude_":"-79.852465","DE_LID_Num":"35577","License_Nu":"R-14386"},{"_id":76,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Bar Fly, Incorporated","Trade_Name":"Tuns Tavern","Bus_Physic":"1202 Bell Avenue","Bus_Phys_1":"North Braddock","Bus_Phys_2":"PA","Bus_Phys_3":"15104","Latitude_A":"40.400103","Longitude_":"-79.858774","DE_LID_Num":"49197","License_Nu":"R-01509"},{"_id":77,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"JP2 Ventures, LLC.","Trade_Name":null,"Bus_Physic":"1400-1402 Brinton Avenue","Bus_Phys_1":"Braddock","Bus_Phys_2":"PA","Bus_Phys_3":"15104","Latitude_A":"40.404854","Longitude_":"-79.843921","DE_LID_Num":"61131","License_Nu":"R-16508"},{"_id":78,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Tony's Bar of Carnegie, Inc.","Trade_Name":"Tony's Cafe","Bus_Physic":"307 West Main Street","Bus_Phys_1":"Carnegie","Bus_Phys_2":"PA","Bus_Phys_3":"15106","Latitude_A":"40.404211","Longitude_":"-80.0913","DE_LID_Num":"57256","License_Nu":"R-06214"},{"_id":79,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Manny's Rook Station Cafe, Inc.","Trade_Name":"Manny's Rook Station Cafe","Bus_Physic":"201 Hawthorne Street - Greentree","Bus_Phys_1":"Carnegie","Bus_Phys_2":"PA","Bus_Phys_3":"15106","Latitude_A":"40.415147","Longitude_":"-80.067943","DE_LID_Num":"33843","License_Nu":"R-08626"},{"_id":80,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"106 East Mall Plaza, Inc.","Trade_Name":"Nazcarz Saloon","Bus_Physic":"106 East Mall Plaza","Bus_Phys_1":"Carnegie","Bus_Phys_2":"PA","Bus_Phys_3":"15106","Latitude_A":"40.406936","Longitude_":"-80.08756","DE_LID_Num":"45586","License_Nu":"R-10070"},{"_id":81,"Shape":"Point","Bus_Type":"Drinking Establishment Type II","Status":"Approved","Establishm":"JDDM, Inc.","Trade_Name":"Cump's","Bus_Physic":"12 East Main Street","Bus_Phys_1":"Carnegie","Bus_Phys_2":"PA","Bus_Phys_3":"15106","Latitude_A":"40.406814","Longitude_":"-80.087319","DE_LID_Num":"36466","License_Nu":"R-03312"},{"_id":82,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"BIG RICK, INC.","Trade_Name":"Cantley's","Bus_Physic":"609-611 West Main Street","Bus_Phys_1":"Carnegie","Bus_Phys_2":"PA","Bus_Phys_3":"15106","Latitude_A":"40.402023","Longitude_":"-80.09452","DE_LID_Num":"41552","License_Nu":"R-05259"},{"_id":83,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Clawson Enterprises, Inc.","Trade_Name":"Muzzy's II","Bus_Physic":"408 Second Street","Bus_Phys_1":"Carnegie","Bus_Phys_2":"PA","Bus_Phys_3":"15106","Latitude_A":"40.392049","Longitude_":"-80.087931","DE_LID_Num":"52283","License_Nu":"R-14241"},{"_id":84,"Shape":"Point","Bus_Type":"Tobacco Shop","Status":"Approved","Establishm":"Egal, Inc.","Trade_Name":"The Smoke Stack Everything Tobacco","Bus_Physic":"7305 University Boulevard","Bus_Phys_1":"Coraopolis","Bus_Phys_2":"PA","Bus_Phys_3":"15108","Latitude_A":"40.515659","Longitude_":"-80.221788","DE_LID_Num":null,"License_Nu":null},{"_id":85,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Alpha Beta D Corporation","Trade_Name":"Skylark Motor Inn","Bus_Physic":"225 Moon Clinton Road","Bus_Phys_1":"Coraopolis","Bus_Phys_2":"PA","Bus_Phys_3":"15108","Latitude_A":"40.512552","Longitude_":"-80.225373","DE_LID_Num":"42789","License_Nu":"H-04518"},{"_id":86,"Shape":"Point","Bus_Type":"Drinking Establishment Type II","Status":"Approved","Establishm":"JOANT, Inc.","Trade_Name":null,"Bus_Physic":"333 Rouser Road - Building Number 4 - Airport Office Center","Bus_Phys_1":"Moon Township","Bus_Phys_2":"PA","Bus_Phys_3":"15108","Latitude_A":"40.516977","Longitude_":"-80.221348","DE_LID_Num":"59390","License_Nu":"R-06256"},{"_id":87,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"BARTOLOMUCCI, INC.","Trade_Name":null,"Bus_Physic":"859 Fifth Avenue","Bus_Phys_1":"Coraopolis","Bus_Phys_2":"PA","Bus_Phys_3":"15108","Latitude_A":"40.518809","Longitude_":"-80.16775","DE_LID_Num":"27449","License_Nu":"R-05741"},{"_id":88,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Chuckos Place, Inc.","Trade_Name":null,"Bus_Physic":"1033 Fourth Avenue","Bus_Phys_1":"Coraopolis","Bus_Phys_2":"PA","Bus_Phys_3":"15108","Latitude_A":"40.518124","Longitude_":"-80.162327","DE_LID_Num":"47875","License_Nu":"R-13519"},{"_id":89,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Montour Hotel, Inc.","Trade_Name":"Montour Hotel","Bus_Physic":"1500-02 Fourth Avenue","Bus_Phys_1":"Coraopolis","Bus_Phys_2":"PA","Bus_Phys_3":"15108","Latitude_A":"40.514792","Longitude_":"-80.154634","DE_LID_Num":"49146","License_Nu":"H-01601"},{"_id":90,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"ISLAND LIFE, INC.","Trade_Name":"Jailhouse Saloon","Bus_Physic":"929 Fifth Avenue","Bus_Phys_1":"Coraopolis","Bus_Phys_2":"PA","Bus_Phys_3":"15108","Latitude_A":"40.518106","Longitude_":"-80.165432","DE_LID_Num":"59602","License_Nu":"R-11285"},{"_id":91,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Howard G. Massung","Trade_Name":"Stardust Lounge","Bus_Physic":"950 Broadhead Road","Bus_Phys_1":"Coraopolis","Bus_Phys_2":"PA","Bus_Phys_3":"15108","Latitude_A":"40.519437","Longitude_":"-80.223573","DE_LID_Num":"34973","License_Nu":"R-18334"},{"_id":92,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Fourth Avenue Cafe and Comedy Club, Inc.","Trade_Name":"Appian Way Lounge","Bus_Physic":"418 Moon Clinton Road","Bus_Phys_1":"Coraopolis","Bus_Phys_2":"PA","Bus_Phys_3":"15108","Latitude_A":"40.509481","Longitude_":"-80.239437","DE_LID_Num":"39695","License_Nu":"R-07510"},{"_id":93,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Tigger, Inc.","Trade_Name":null,"Bus_Physic":"297 Mahoney Road","Bus_Phys_1":"Coraopolis","Bus_Phys_2":"PA","Bus_Phys_3":"15108","Latitude_A":"40.451486","Longitude_":"-80.206222","DE_LID_Num":"10344","License_Nu":"R-02099"},{"_id":94,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Billy Bob's Enterprises, Inc.","Trade_Name":null,"Bus_Physic":"1016 Duquesne Boulevard","Bus_Phys_1":"Duquesne","Bus_Phys_2":"PA","Bus_Phys_3":"15110","Latitude_A":"40.384196","Longitude_":"-79.859182","DE_LID_Num":"50510","License_Nu":"R-05435"},{"_id":95,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Ann Suzich & Dorothy Suzich","Trade_Name":"Suzich Cafe","Bus_Physic":"917 Grant Avenue","Bus_Phys_1":"Duquesne","Bus_Phys_2":"PA","Bus_Phys_3":"15110","Latitude_A":"40.371221","Longitude_":"-79.854596","DE_LID_Num":"51304","License_Nu":"R-14600"},{"_id":96,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Craig E. Galik","Trade_Name":"Craig's Rounding Third","Bus_Physic":"1301 Kennedy Aveune","Bus_Phys_1":"Duquesne","Bus_Phys_2":"PA","Bus_Phys_3":"15110","Latitude_A":"40.367304","Longitude_":"-79.855913","DE_LID_Num":"16034","License_Nu":"R-13287"},{"_id":97,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Safari Club, Inc.","Trade_Name":"Safari Club","Bus_Physic":"704-706 West Grant Avenue","Bus_Phys_1":"Duquesne","Bus_Phys_2":"PA","Bus_Phys_3":"15110","Latitude_A":"40.372105","Longitude_":"-79.852418","DE_LID_Num":"35572","License_Nu":"R-14388"},{"_id":98,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Extra Point, Inc.","Trade_Name":"Hollywood Show Bar","Bus_Physic":"836-840 Linden Avenue","Bus_Phys_1":"East Pittsburgh","Bus_Phys_2":"PA","Bus_Phys_3":"15112","Latitude_A":"40.400589","Longitude_":"-79.83491","DE_LID_Num":"6010","License_Nu":"H-00192"},{"_id":99,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"MEGZ CORPORATION","Trade_Name":"ELECTRIC AVENUE CAFE","Bus_Physic":"1586 Electric Avenue","Bus_Phys_1":"East Pittsburgh","Bus_Phys_2":"PA","Bus_Phys_3":"15112","Latitude_A":"40.40248","Longitude_":"-79.837612","DE_LID_Num":"49016","License_Nu":"R-05210"},{"_id":100,"Shape":"Point","Bus_Type":"Drinking Establishment Type I","Status":"Approved","Establishm":"Robert L. Pasculle","Trade_Name":"Bob's Lounge","Bus_Physic":"944 Greensburg Pike","Bus_Phys_1":"East Pittsburgh","Bus_Phys_2":"PA","Bus_Phys_3":"15112","Latitude_A":"40.415418","Longitude_":"-79.838575","DE_LID_Num":"16589","License_Nu":"R-14205"}], "fields": [{"id": "_id", "type": "int"}, {"id": "Shape", "type": "text", "info": {"label": "", "notes": "Identifies the type of mapping feature\t"}}, {"id": "Bus_Type", "type": "text", "info": {"label": "", "notes": "Business Type\t"}}, {"id": "Status", "type": "text", "info": {"label": "", "notes": "All sites have been surveyed, if the status is completed it means that the site has been cleaned up\n"}}, {"id": "Establishm", "type": "text", "info": {"label": "", "notes": "Official name that the exemption was filed under\t"}}, {"id": "Trade_Name", "type": "text", "info": {"label": "", "notes": "Common name of the establishment\t"}}, {"id": "Bus_Physic", "type": "text"}, {"id": "Bus_Phys_1", "type": "text", "info": {"label": "", "notes": "Address"}}, {"id": "Bus_Phys_2", "type": "text", "info": {"label": "", "notes": "City/town\t"}}, {"id": "Bus_Phys_3", "type": "text", "info": {"label": "", "notes": "Zipcode\t"}}, {"id": "Latitude_A", "type": "text", "info": {"label": "", "notes": "Latitude\t"}}, {"id": "Longitude_", "type": "text", "info": {"label": "", "notes": "Longitude\t"}}, {"id": "DE_LID_Num", "type": "text", "info": {"label": "", "notes": "License Identification Number\t"}}, {"id": "License_Nu", "type": "text", "info": {"label": "", "notes": "License Number\t"}}], "total": 462}}