{"help": "https://data.wprdc.org/de/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "records_format": "objects", "resource_id": "e88c10d5-541d-417f-aef6-25cc5637aeb1", "total_estimation_threshold": null, "records": [{"_id":1,"license_number":"MD1227","license_type_name":"Mechanical Device","naics_code":"713290","business_name":"STARPORT LLC","license_state":"Expired","initial_issue_date":"2017-11-08T13:59:42","most_recent_issue_date":"2017-11-08T14:01:13","effective_date":"2017-11-08T14:01:13","expiration_date":"2018-11-08T14:01:13","parcel_number":null,"address":null,"email_address":"STARPORTARCADE@GMAIL.COM","primary_phone_number":"(412) 973-5087","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":1,"number_of_nongambling_machines":2,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":0,"number_of_units":null},{"_id":2,"license_number":"17-SNC00002773","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"LAMAR ADVERTISING","license_state":"Expired","initial_issue_date":"2017-11-09T09:59:51","most_recent_issue_date":"2017-11-09T10:37:16","effective_date":"2017-11-09T10:37:16","expiration_date":"2018-11-09T10:37:16","parcel_number":"0044C00325000900","address":null,"email_address":"ayelenic@lamar.com","primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":1,"number_of_small_signs":0,"number_of_signs_total":0,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":3,"license_number":"PK01074","license_type_name":"Parking Lot","naics_code":"812930","business_name":"BLUFF'S PARKING LLC","license_state":"Active","initial_issue_date":"2017-11-14T14:59:58","most_recent_issue_date":"2025-09-30T00:00:00","effective_date":"2025-11-14T00:00:00","expiration_date":"2026-11-13T00:00:00","parcel_number":"0002H00035000000","address":"1522 5TH AVE, Pittsburgh, PA 15219-","email_address":"BLUFFSPARKING412@GMAIL.COM","primary_phone_number":"(412) 969-9430","insurance_expiration_date":"2019-12-15","number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":7,"number_of_revgen_spaces":7,"total_number_of_spaces":7,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":4,"license_number":"PED1277","license_type_name":"Peddler","naics_code":"722330","business_name":"CHARLES MILLER","license_state":"Expired","initial_issue_date":"2017-11-16T14:11:57","most_recent_issue_date":"2017-11-16T14:16:59","effective_date":"2017-11-16T14:16:59","expiration_date":"2018-11-16T14:16:59","parcel_number":null,"address":null,"email_address":"CHUCKIEMILLER@OUTLOOK.COM","primary_phone_number":"(513) 601-6968","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":5,"license_number":"PK01075","license_type_name":"Parking Lot","naics_code":"812930","business_name":"CONCORD HOTELS","license_state":"Expired","initial_issue_date":"2017-11-21T11:23:22","most_recent_issue_date":"2020-12-07T00:00:00","effective_date":"2020-11-22T00:00:00","expiration_date":"2021-11-21T00:00:00","parcel_number":"0051L00088000000","address":"5310 LIBERTY AVE, Pittsburgh, PA 15232-","email_address":"THOMAS.MAERZ@CONCORDHOTELS.COM","primary_phone_number":"(412) 683-3113","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":64,"number_of_revgen_spaces":64,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":6,"license_number":"17-SNC00002777","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"LAMAR ADVERTISING","license_state":"Expired","initial_issue_date":"2017-12-04T10:59:24","most_recent_issue_date":"2017-12-04T11:01:32","effective_date":"2017-12-04T11:01:32","expiration_date":"2018-12-04T11:01:32","parcel_number":"0025D00070000000","address":"3223 PENN AVE, Pittsburgh, PA 15201-","email_address":"ayelenic@lamar.com","primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":1,"number_of_small_signs":0,"number_of_signs_total":0,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":7,"license_number":"17-SNC00002780","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"LAMAR ADVERTISING","license_state":"Expired","initial_issue_date":"2017-12-04T11:18:58","most_recent_issue_date":"2017-12-04T11:19:59","effective_date":"2017-12-04T11:19:59","expiration_date":"2018-12-04T11:19:59","parcel_number":"0088F00051000000","address":null,"email_address":"ayelenic@lamar.com","primary_phone_number":"(412) 722-0200","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":2,"number_of_small_signs":0,"number_of_signs_total":0,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":8,"license_number":"17-SNC00002781","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"LAMAR ADVERTISING","license_state":"Expired","initial_issue_date":"2017-12-04T11:23:42","most_recent_issue_date":"2017-12-04T11:26:21","effective_date":"2017-12-04T11:26:21","expiration_date":"2018-12-04T11:26:21","parcel_number":"0095J00084000000","address":"2209 SAW MILL RUN BLVD, Pittsburgh, PA 15210-","email_address":"ayelenic@lamar.com","primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":1,"number_of_small_signs":0,"number_of_signs_total":0,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":9,"license_number":"17-SNC00002784","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"LAMAR ADVERTISING","license_state":"Expired","initial_issue_date":"2017-12-04T14:23:12","most_recent_issue_date":"2017-12-04T14:29:20","effective_date":"2017-12-04T14:29:20","expiration_date":"2018-12-04T14:29:20","parcel_number":"0139M00073000000","address":"2640 LIBRARY RD, Pittsburgh, PA 15234-","email_address":"ayelenic@lamar.com","primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":2,"number_of_small_signs":0,"number_of_signs_total":0,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":10,"license_number":"17-SNC00002787","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"LAMAR ADVERTISING","license_state":"Expired","initial_issue_date":"2017-12-04T15:01:12","most_recent_issue_date":"2017-12-04T15:02:09","effective_date":"2017-12-04T15:02:09","expiration_date":"2018-12-04T15:02:09","parcel_number":"0009A00191000000","address":"234 VOEGHTLY ST, Pittsburgh, PA 15212-","email_address":"ayelenic@lamar.com","primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":1,"number_of_small_signs":0,"number_of_signs_total":0,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":11,"license_number":"AP000786","license_type_name":"Amusement Producer","naics_code":"713110","business_name":"PPG PAINTS ARENA","license_state":"Expired","initial_issue_date":"2017-12-29T00:00:00","most_recent_issue_date":"2017-12-29T00:00:00","effective_date":"2017-12-29T00:00:00","expiration_date":"2017-12-30T00:00:00","parcel_number":"0002G00066000000","address":"1027 5TH AVE, Pittsburgh, PA 15219-","email_address":"JGRANT@PPGPAINTSARENA.COM","primary_phone_number":"(412) 804-2699","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":12,"license_number":"TOW0577","license_type_name":"Limited Towing","naics_code":"488410","business_name":"RIVERSET CREDIT UNION","license_state":"Expired","initial_issue_date":"2017-12-19T12:31:00","most_recent_issue_date":"2019-11-12T00:00:00","effective_date":"2019-12-20T00:00:00","expiration_date":"2020-12-19T00:00:00","parcel_number":"0003G00105000000","address":"1700 JANE ST, Pittsburgh, PA 15203-","email_address":"management@RIVERSET.COM","primary_phone_number":"(412) 488-2525","insurance_expiration_date":"2019-10-10","number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":13,"license_number":"PK00622","license_type_name":"Parking Lot","naics_code":"812930","business_name":"LINDA FINE","license_state":"Expired","initial_issue_date":"2012-10-09T11:52:56","most_recent_issue_date":"2016-10-26T13:24:27","effective_date":"2016-10-26T13:24:27","expiration_date":"2017-10-26T13:24:27","parcel_number":"0051E00106000000","address":"704 S MATHILDA ST, Pittsburgh, PA 15224-","email_address":null,"primary_phone_number":"(412) 688-9793","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":3,"number_of_revgen_spaces":3,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":14,"license_number":"PK00628","license_type_name":"Parking Lot","naics_code":"812930","business_name":"ALCO PARKING CORP","license_state":"Expired","initial_issue_date":"2012-10-09T11:48:58","most_recent_issue_date":"2016-11-18T14:12:45","effective_date":"2016-11-18T14:12:45","expiration_date":"2017-11-18T14:12:45","parcel_number":"0002F00230000000","address":"500 ROSS ST, Pittsburgh, PA 15219","email_address":"DCHURETTA@ALCOPARKING.COM","primary_phone_number":"(412) 323-4455","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":650,"number_of_revgen_spaces":650,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":15,"license_number":"PK00675","license_type_name":"Parking Lot","naics_code":"812930","business_name":"UNIVERSITY OF PITTSBURGH","license_state":"Expired","initial_issue_date":"2012-01-18T14:25:03","most_recent_issue_date":"2017-12-08T11:09:04","effective_date":"2017-12-08T11:09:04","expiration_date":"2018-12-08T11:09:04","parcel_number":"0028F00159000000","address":"3501 FORBES AVE, Pittsburgh, PA 15213-","email_address":"JYEAMAN@BC.PITT.EDU","primary_phone_number":"(412) 648-8271","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":0,"number_of_revgen_spaces":0,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":16,"license_number":"PK00654","license_type_name":"Parking Lot","naics_code":"812930","business_name":"UNIVERSITY OF PITTSBURGH","license_state":"Expired","initial_issue_date":"2012-01-18T10:53:08","most_recent_issue_date":"2015-12-01T10:01:10","effective_date":"2015-12-01T10:01:10","expiration_date":"2016-12-01T10:01:10","parcel_number":"0027S00125000000","address":"4200 5TH AVE, Pittsburgh, PA 15213-","email_address":null,"primary_phone_number":"(412) 624-8904","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":0,"number_of_revgen_spaces":0,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":17,"license_number":"PK00659","license_type_name":"Parking Lot","naics_code":"812930","business_name":"UNIVERSITY OF PITTSBURGH","license_state":"Expired","initial_issue_date":"2012-01-17T09:19:20","most_recent_issue_date":"2015-02-03T15:29:54","effective_date":"2015-02-03T15:29:54","expiration_date":"2016-02-03T15:29:54","parcel_number":"0028B00166000000","address":"130 DESOTO ST, Pittsburgh, PA 15213-","email_address":null,"primary_phone_number":"(412) 624-8904","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":151,"number_of_revgen_spaces":151,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":18,"license_number":"AP000482","license_type_name":"Amusement Producer","naics_code":"713110","business_name":"AEG - CONSOL ENERGY CENTER","license_state":"Expired","initial_issue_date":"2013-11-16T00:00:00","most_recent_issue_date":"2013-11-16T00:00:00","effective_date":"2013-11-16T00:00:00","expiration_date":"2013-11-16T00:00:00","parcel_number":"0002G00066000000","address":"1027 5TH AVE, Pittsburgh, PA 15219-","email_address":null,"primary_phone_number":"(412) 804-7806","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":19,"license_number":"AP000489","license_type_name":"Amusement Producer","naics_code":"713110","business_name":"AEG - CONSOL ENERGY CENTER","license_state":"Expired","initial_issue_date":"2013-12-14T00:00:00","most_recent_issue_date":"2013-12-14T00:00:00","effective_date":"2013-12-14T00:00:00","expiration_date":"2013-12-14T00:00:00","parcel_number":"0002G00066000000","address":"1027 5TH AVE, Pittsburgh, PA 15219-","email_address":null,"primary_phone_number":"(412) 804-7806","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":20,"license_number":"AP000494","license_type_name":"Amusement Producer","naics_code":"713110","business_name":"PITTSBURGH CULTURAL TRUST","license_state":"Expired","initial_issue_date":"2013-10-24T00:00:00","most_recent_issue_date":"2013-10-24T00:00:00","effective_date":"2013-10-24T00:00:00","expiration_date":"2013-10-27T00:00:00","parcel_number":"0008S00074000000","address":"101 6TH ST, Pittsburgh, PA 15222-","email_address":null,"primary_phone_number":"(412) 456-1377","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":21,"license_number":"SD0277","license_type_name":"Secondhand Dealer","naics_code":"453310","business_name":"NECESSITIES I","license_state":"Expired","initial_issue_date":"2015-03-18T13:03:49","most_recent_issue_date":"2014-03-22T09:09:44","effective_date":"2014-03-22T09:09:44","expiration_date":"2015-03-22T09:09:44","parcel_number":"0097D00060000000","address":"824 BROOKLINE BLVD, Pittsburgh, PA 15226-","email_address":null,"primary_phone_number":"(412) 805-1702","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":22,"license_number":"AP000499","license_type_name":"Amusement Producer","naics_code":"713110","business_name":"AEG - CONSOL ENERGY CENTER","license_state":"Expired","initial_issue_date":"2013-10-11T00:00:00","most_recent_issue_date":"2013-10-11T00:00:00","effective_date":"2013-10-11T00:00:00","expiration_date":"2013-10-11T00:00:00","parcel_number":"0002G00066000000","address":"1027 5TH AVE, Pittsburgh, PA 15219-","email_address":null,"primary_phone_number":"(412) 804-7806","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":23,"license_number":"SD0278","license_type_name":"Secondhand Dealer","naics_code":"453310","business_name":"BOMB BOOKS","license_state":"Expired","initial_issue_date":"2013-12-03T13:10:45","most_recent_issue_date":"2016-12-14T10:55:19","effective_date":"2016-12-14T10:55:19","expiration_date":"2017-12-14T10:55:19","parcel_number":"0002K00004000000","address":"398 SHINGISS ST, Pittsburgh, PA 15219-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":24,"license_number":"PED0932","license_type_name":"Peddler","naics_code":"722330","business_name":"VARIPOINT","license_state":"Expired","initial_issue_date":"2015-01-21T14:19:55","most_recent_issue_date":"2013-12-20T10:21:20","effective_date":"2013-12-20T10:21:20","expiration_date":"2014-12-20T10:21:20","parcel_number":null,"address":null,"email_address":null,"primary_phone_number":"(724) 234-8523","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":25,"license_number":"AP000502","license_type_name":"Amusement Producer","naics_code":"713110","business_name":"AEG - CONSOL ENERGY CENTER","license_state":"Expired","initial_issue_date":"2014-01-10T00:00:00","most_recent_issue_date":"2014-01-10T00:00:00","effective_date":"2014-01-10T00:00:00","expiration_date":"2014-01-12T00:00:00","parcel_number":"0002G00066000000","address":"1027 5TH AVE, Pittsburgh, PA 15219-","email_address":null,"primary_phone_number":"(412) 804-7806","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":26,"license_number":"AP000506","license_type_name":"Amusement Producer","naics_code":"713110","business_name":"AEG - CONSTOL ENERGY CENTER","license_state":"Expired","initial_issue_date":"2014-02-21T00:00:00","most_recent_issue_date":"2014-02-21T00:00:00","effective_date":"2014-02-21T00:00:00","expiration_date":"2014-02-21T00:00:00","parcel_number":"0002G00066000000","address":"1027 5TH AVE, Pittsburgh, PA 15219-","email_address":null,"primary_phone_number":"(412) 804-7806","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":27,"license_number":"MD1117","license_type_name":"Mechanical Device","naics_code":"713290","business_name":"HARTMAN MUSIC INC","license_state":"Expired","initial_issue_date":"2014-02-11T11:15:10","most_recent_issue_date":"2016-02-26T15:41:32","effective_date":"2016-02-26T15:41:32","expiration_date":"2017-02-26T15:41:32","parcel_number":"0003M00323000000","address":"111 S 12TH ST, Pittsburgh, PA 15203-","email_address":"HARTMANMUSICINC@AOL.COM","primary_phone_number":"(412) 488-8316","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":0,"number_of_nongambling_machines":1,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":0,"number_of_units":null},{"_id":28,"license_number":"AP000513","license_type_name":"Amusement Producer","naics_code":"713110","business_name":"AEG - CONSOL ENERGY CENTER","license_state":"Expired","initial_issue_date":"2014-04-02T00:00:00","most_recent_issue_date":"2014-04-02T00:00:00","effective_date":"2014-04-02T00:00:00","expiration_date":"2014-04-02T00:00:00","parcel_number":"0002G00066000000","address":"1027 5TH AVE, Pittsburgh, PA 15219-","email_address":null,"primary_phone_number":"(412) 804-7806","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":29,"license_number":"MD1119","license_type_name":"Mechanical Device","naics_code":"713290","business_name":"SOUTH PITTSBURGH VENDING INC","license_state":"Expired","initial_issue_date":"2014-02-12T11:28:16","most_recent_issue_date":"2019-04-05T00:00:00","effective_date":"2019-04-07T10:35:17","expiration_date":"2020-04-06T00:00:00","parcel_number":"0019S00144000000","address":"412 GREENTREE RD, Pittsburgh, PA 15220-","email_address":"KCANDROSIE@AOL.COM","primary_phone_number":"(412) 881-8901","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":1,"number_of_nongambling_machines":0,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":1,"number_of_units":null},{"_id":30,"license_number":"PED0939","license_type_name":"Peddler","naics_code":"722330","business_name":"RENEWAL BY ANDERSON","license_state":"Expired","initial_issue_date":"2015-01-21T14:20:02","most_recent_issue_date":"2014-02-13T10:12:52","effective_date":"2014-02-13T10:12:52","expiration_date":"2015-02-13T10:12:52","parcel_number":null,"address":null,"email_address":null,"primary_phone_number":"(724) 594-6443","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":31,"license_number":"PED0944","license_type_name":"Peddler","naics_code":"722330","business_name":"RENEWAL BY ANDERSON","license_state":"Expired","initial_issue_date":"2015-01-21T14:19:32","most_recent_issue_date":"2014-02-13T11:12:11","effective_date":"2014-02-13T11:12:11","expiration_date":"2015-02-13T11:12:11","parcel_number":null,"address":null,"email_address":null,"primary_phone_number":"(330) 719-4005","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":32,"license_number":"PED0946","license_type_name":"Peddler","naics_code":"722330","business_name":"RENEWAL BY ANDERSEN","license_state":"Expired","initial_issue_date":"2015-01-21T14:19:58","most_recent_issue_date":"2014-02-14T09:40:23","effective_date":"2014-02-14T09:40:23","expiration_date":"2015-02-14T09:40:23","parcel_number":null,"address":null,"email_address":null,"primary_phone_number":"(301) 257-4132","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":33,"license_number":"15-SNC00001016","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"ALL OCCASIONS","license_state":"Expired","initial_issue_date":"2015-08-31T08:35:01","most_recent_issue_date":"2016-06-20T12:48:44","effective_date":"2016-06-20T12:48:44","expiration_date":"2017-06-20T12:48:44","parcel_number":"0026A00120000000","address":"3600 LIBERTY AVE, Pittsburgh, PA 15201-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":34,"license_number":"15-SNC00001020","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"CARL'S TV SERVICE","license_state":"Expired","initial_issue_date":"2015-08-31T08:57:37","most_recent_issue_date":"2016-07-08T15:47:40","effective_date":"2016-07-08T15:47:40","expiration_date":"2017-07-08T15:47:40","parcel_number":"0050K00340000000","address":"5025 PENN AVE, Pittsburgh, PA 15224-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":35,"license_number":"15-SNC00001023","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"RIVER VUE ASSOCIATES","license_state":"Expired","initial_issue_date":"2015-08-31T09:28:35","most_recent_issue_date":"2017-08-02T13:06:50","effective_date":"2017-08-02T13:06:50","expiration_date":"2018-08-02T13:06:50","parcel_number":"0001G00043000000","address":"300 LIBERTY AVE, Pittsburgh, PA 15222-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":36,"license_number":"15-SNC00001027","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"MACY'S CORPORATE SERVICES INC","license_state":"Expired","initial_issue_date":"2015-08-31T09:44:42","most_recent_issue_date":"2015-08-31T09:47:59","effective_date":"2015-08-31T09:47:59","expiration_date":"2016-08-31T09:47:59","parcel_number":null,"address":null,"email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":30,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":37,"license_number":"15-SNC00001031","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"LOYAL ORDER OF MOOSE 609 BEECHVIEW","license_state":"Expired","initial_issue_date":"2015-08-31T09:58:40","most_recent_issue_date":"2017-07-14T09:53:09","effective_date":"2017-07-14T09:53:09","expiration_date":"2018-07-14T09:53:09","parcel_number":"0035G00022000000","address":"1607 BROADWAY AVE, Pittsburgh, PA 15216-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":38,"license_number":"15-SNC00001035","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"BUCA C, LLC","license_state":"Closed","initial_issue_date":"2015-08-31T10:05:47","most_recent_issue_date":"2021-05-17T00:00:00","effective_date":"2021-06-12T00:00:00","expiration_date":"2022-06-11T00:00:00","parcel_number":"0001R00020000000","address":"236 W STATION SQUARE DR, Pittsburgh, PA 15219-","email_address":"licensing@bucainc.com","primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":4,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":39,"license_number":"15-SNC00001038","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"YOXHEIMER SUSAN M & THOMAS J (H)","license_state":"Expired","initial_issue_date":"2015-08-31T10:08:24","most_recent_issue_date":"2017-07-28T14:39:31","effective_date":"2017-07-28T14:39:31","expiration_date":"2018-07-28T14:39:31","parcel_number":"0003H00040000000","address":"1314 E CARSON ST, Pittsburgh, PA 15203-","email_address":"LADYYOX@YAHOO.COM","primary_phone_number":"(412) 913-3270","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":40,"license_number":"15-SNC00001042","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"EASTMINSTER PRESBYTERIAN CHURCH","license_state":"Expired","initial_issue_date":"2015-08-31T10:13:55","most_recent_issue_date":"2016-07-12T17:40:33","effective_date":"2016-07-12T17:40:33","expiration_date":"2017-07-12T17:40:33","parcel_number":"0083R00224000000","address":"6023 HARVARD ST, Pittsburgh, PA 15206-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":41,"license_number":"15-SNC00001047","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"SUBWAY RESTAURANT","license_state":"Expired","initial_issue_date":"2015-08-31T10:23:33","most_recent_issue_date":"2015-08-31T10:24:39","effective_date":"2015-08-31T10:24:39","expiration_date":"2016-08-31T10:24:39","parcel_number":null,"address":null,"email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":2,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":42,"license_number":"15-SNC00001051","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"ATLAS TRANSMISSIONS","license_state":"Expired","initial_issue_date":"2015-08-31T10:31:55","most_recent_issue_date":"2016-07-25T09:35:09","effective_date":"2016-07-25T09:35:09","expiration_date":"2017-07-25T09:35:09","parcel_number":"0035M00174000000","address":null,"email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":3,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":43,"license_number":"15-SNC00001054","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"MONEY MART","license_state":"Expired","initial_issue_date":"2015-08-31T10:41:22","most_recent_issue_date":"2017-11-09T09:28:35","effective_date":"2017-11-09T09:28:35","expiration_date":"2018-11-09T09:28:35","parcel_number":"0024N00203000000","address":"621 E OHIO ST, Pittsburgh, PA 15212-","email_address":"KIM.LOVE@DFG.COM","primary_phone_number":"(610) 640-5923","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":1,"number_of_small_signs":0,"number_of_signs_total":0,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":44,"license_number":"15-SNC00001059","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"ROYAL PLACE INC","license_state":"Expired","initial_issue_date":"2015-08-31T10:58:53","most_recent_issue_date":"2015-09-01T16:04:56","effective_date":"2015-09-01T16:04:56","expiration_date":"2016-09-01T16:04:56","parcel_number":"0139M00100000000","address":"2660 LIBRARY RD, Pittsburgh, PA 15234-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":2,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":45,"license_number":"15-SNC00001064","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"SIENNA ON THE SQUARE","license_state":"Expired","initial_issue_date":"2015-08-31T11:43:21","most_recent_issue_date":"2017-07-12T12:20:59","effective_date":"2017-07-12T12:20:59","expiration_date":"2018-07-12T12:20:59","parcel_number":null,"address":null,"email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":46,"license_number":"15-SNC00001068","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"THREE RIVERS FOOD LLC","license_state":"Expired","initial_issue_date":"2015-08-31T13:22:53","most_recent_issue_date":"2016-06-20T08:38:16","effective_date":"2016-06-20T08:38:16","expiration_date":"2017-06-20T08:38:16","parcel_number":"0001M00120000000","address":"107 SMITHFIELD ST, Pittsburgh, PA 15222-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":47,"license_number":"15-SNC00001071","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"Advance Stores Company Incorporated","license_state":"Expired","initial_issue_date":"2015-08-31T13:57:14","most_recent_issue_date":"2018-07-06T12:49:42","effective_date":"2018-07-06T12:49:42","expiration_date":"2019-07-06T12:49:42","parcel_number":"0059P00141000000","address":"557 BRINWOOD AVE, Pittsburgh, PA 15227-","email_address":"ANNTOINETTE.TRUXEL@ADVANCE-AUTO.COM","primary_phone_number":"(540) 561-6892","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":2,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":48,"license_number":"15-SNC00001076","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"MIGUEL J  QUINTERO MD","license_state":"Expired","initial_issue_date":"2015-08-31T14:24:56","most_recent_issue_date":"2016-06-13T08:20:30","effective_date":"2016-06-13T08:20:30","expiration_date":"2017-06-13T08:20:30","parcel_number":"0012K00284000000","address":"144 S 20TH ST, Pittsburgh, PA 15203-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":2,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":49,"license_number":"15-SNC00001080","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"TRUSTEES OF THE SYNOD OF THE REFORMED PRESBYTERIAN CHURCH O NORTH AMERICA","license_state":"Expired","initial_issue_date":"2015-08-31T14:36:18","most_recent_issue_date":"2016-06-23T08:07:41","effective_date":"2016-06-23T08:07:41","expiration_date":"2017-06-23T08:07:41","parcel_number":"0175J00080000000","address":"7414 PENN AVE, Pittsburgh, PA 15208-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":50,"license_number":"15-SNC00001084","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"UNIVERSITY OF PITTSBURGH","license_state":"Expired","initial_issue_date":"2015-08-31T14:59:18","most_recent_issue_date":"2015-08-31T15:02:14","effective_date":"2015-08-31T15:02:14","expiration_date":"2016-08-31T15:02:14","parcel_number":"0027P00080000003","address":"3943 OHARA ST, Pittsburgh, PA 15213-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":51,"license_number":"15-SNC00001093","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"SSKJ ENTERPRISES INC DBA VITAL SIGNS","license_state":"Expired","initial_issue_date":"2015-09-01T09:22:36","most_recent_issue_date":"2016-06-30T13:57:20","effective_date":"2016-06-30T13:57:20","expiration_date":"2017-06-30T13:57:20","parcel_number":"0067G00050000000","address":"2812 IDLEWOOD RD, Pittsburgh, PA 15106-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":2,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":52,"license_number":"15-SNC00001097","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"PRIZANT DERMATOLOGY","license_state":"Expired","initial_issue_date":"2015-09-01T09:41:56","most_recent_issue_date":"2016-06-15T09:28:21","effective_date":"2016-06-15T09:28:21","expiration_date":"2017-06-15T09:28:21","parcel_number":"0084E00152000000","address":"5770 BAUM BLVD, Pittsburgh, PA 15206-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":5,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":53,"license_number":"15-SNC00001105","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"ARNHEIM & NEELY INC","license_state":"Expired","initial_issue_date":"2015-09-01T12:57:41","most_recent_issue_date":"2016-06-23T09:23:57","effective_date":"2016-06-23T09:23:57","expiration_date":"2017-06-23T09:23:57","parcel_number":"0086R00054010200","address":"5715 BEACON ST, Pittsburgh, PA 15217-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":54,"license_number":"15-SNC00001111","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"NICKS IMPORTS","license_state":"Expired","initial_issue_date":"2015-09-01T14:29:22","most_recent_issue_date":"2015-09-01T14:37:13","effective_date":"2015-09-01T14:37:13","expiration_date":"2016-09-01T14:37:13","parcel_number":null,"address":null,"email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":3,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":55,"license_number":"15-SNC00001115","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"EMANUEL J RIGAS","license_state":"Expired","initial_issue_date":"2015-09-01T15:11:22","most_recent_issue_date":"2017-08-07T09:22:20","effective_date":"2017-08-07T09:22:20","expiration_date":"2018-08-07T09:22:20","parcel_number":"0023L00108000000","address":"1200 FEDERAL ST, Pittsburgh, PA 15212-","email_address":null,"primary_phone_number":"(412) 321-2335","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":56,"license_number":"15-SNC00001118","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"CAROL WALKOWSKI AGENCY","license_state":"Expired","initial_issue_date":"2015-09-02T08:55:55","most_recent_issue_date":"2015-09-02T08:57:58","effective_date":"2015-09-02T08:57:58","expiration_date":"2016-09-02T08:57:58","parcel_number":"0051A00145000000","address":"4757 LIBERTY AVE, Pittsburgh, PA 15224-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":57,"license_number":"15-SNC00001120","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"MANOCHA PROPERTIES LLC","license_state":"Expired","initial_issue_date":"2015-09-02T09:10:10","most_recent_issue_date":"2016-07-18T10:15:41","effective_date":"2016-07-18T10:15:41","expiration_date":"2017-07-18T10:15:41","parcel_number":"0036R00188000000","address":"2806 BANKSVILLE AVE, Pittsburgh, PA 15216-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":58,"license_number":"15-SNC00001123","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"ATTN: TAX DEPARTMENT","license_state":"Closed","initial_issue_date":"2015-09-02T09:31:25","most_recent_issue_date":"2021-08-23T00:00:00","effective_date":"2021-08-15T00:00:00","expiration_date":"2022-08-14T00:00:00","parcel_number":"0012G00022000000","address":"2315 E CARSON ST, Pittsburgh, PA 15203-","email_address":"TAXISSUES@RENTACENTER.COM","primary_phone_number":"(972) 801-1280","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":2,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":59,"license_number":"15-SNC00001125","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"PITTSBURGH POST GAZETTE","license_state":"Closed","initial_issue_date":"2015-09-02T12:41:47","most_recent_issue_date":"2022-03-18T00:00:00","effective_date":"2022-04-25T00:00:00","expiration_date":"2023-04-24T00:00:00","parcel_number":"0001G00151000000","address":"34 BLVD OF THE ALLIES, Pittsburgh, PA 15222-","email_address":"SSTAFF@POST-GAZETTE.COM","primary_phone_number":"(412) 263-3786","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":1,"number_of_small_signs":1,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":60,"license_number":"15-SNC00001129","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"MILKY WAY DAIRY & VEG. RESTAURANT","license_state":"Expired","initial_issue_date":"2015-09-02T13:07:01","most_recent_issue_date":"2016-06-15T07:42:04","effective_date":"2016-06-15T07:42:04","expiration_date":"2017-06-15T07:42:04","parcel_number":"0087C00030000000","address":"2120 MURRAY AVE, Pittsburgh, PA 15217-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":61,"license_number":"15-SNC00001131","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"100 ROSS STREET ASSOC LP","license_state":"Expired","initial_issue_date":"2015-09-03T07:40:08","most_recent_issue_date":"2015-09-03T07:43:02","effective_date":"2015-09-03T07:43:02","expiration_date":"2016-09-03T07:43:02","parcel_number":"0002J00244000000","address":"100 ROSS ST, Pittsburgh, PA 15219-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":62,"license_number":"15-SNC00001136","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"DONNA CHEVALIER/ #4008","license_state":"Expired","initial_issue_date":"2015-09-03T08:35:25","most_recent_issue_date":"2016-07-26T09:20:39","effective_date":"2016-07-26T09:20:39","expiration_date":"2017-07-26T09:20:39","parcel_number":"0001H00228000000","address":"242 5TH AVE, Pittsburgh, PA 15222-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":3,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":63,"license_number":"15-SNC00001138","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"DONNA CHEVALIER/ #3189","license_state":"Expired","initial_issue_date":"2015-09-03T08:48:38","most_recent_issue_date":"2016-07-26T09:03:05","effective_date":"2016-07-26T09:03:05","expiration_date":"2017-07-26T09:03:05","parcel_number":"0062R00135000000","address":"510 BROOKLINE BLVD, Pittsburgh, PA 15226-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":10,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":64,"license_number":"AP000787","license_type_name":"Amusement Producer","naics_code":"713110","business_name":"AEG","license_state":"Expired","initial_issue_date":"2018-01-06T00:00:00","most_recent_issue_date":"2018-01-06T00:00:00","effective_date":"2018-01-06T00:00:00","expiration_date":"2018-01-06T00:00:00","parcel_number":"0002G00066000000","address":"1001 5TH AVE, Pittsburgh, PA 15219-","email_address":"JGRANT@PPGPAINTSARENA.COM","primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":65,"license_number":"AP000792","license_type_name":"Amusement Producer","naics_code":"713110","business_name":"PPG PAINTS ARENA","license_state":"Expired","initial_issue_date":"2018-02-01T00:00:00","most_recent_issue_date":"2018-02-01T00:00:00","effective_date":"2018-02-01T00:00:00","expiration_date":"2018-02-01T00:00:00","parcel_number":"0002G00066000000","address":"1027 5TH AVE, Pittsburgh, PA 15219-","email_address":"JGRANT@PPGPAINTSARENA.COM","primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":66,"license_number":"AP000801","license_type_name":"Amusement Producer","naics_code":"713110","business_name":"PPG PAINTS ARENA","license_state":"Expired","initial_issue_date":"2018-03-10T00:00:00","most_recent_issue_date":"2018-03-10T00:00:00","effective_date":"2018-03-10T00:00:00","expiration_date":"2018-03-10T00:00:00","parcel_number":"0002G00066000000","address":"1027 5TH AVE, Pittsburgh, PA 15219-","email_address":"JGRANT@PPGPAINTSARENA.COM","primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":67,"license_number":"TOW0581","license_type_name":"Limited Towing","naics_code":"488410","business_name":"VERA HOLDINGS LLC","license_state":"Expired","initial_issue_date":"2018-02-01T11:52:35","most_recent_issue_date":"2020-12-22T00:00:00","effective_date":"2021-02-02T00:00:00","expiration_date":"2022-02-01T00:00:00","parcel_number":"0088F00038000000","address":"4375 MURRAY AVE, Pittsburgh, PA 15217-","email_address":"SEPT1062@YAHOO.COM","primary_phone_number":"(412) 760-5188","insurance_expiration_date":"2019-11-10","number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":68,"license_number":"AP000804","license_type_name":"Amusement Producer","naics_code":"713110","business_name":"PPG PAINTS ARENA","license_state":"Expired","initial_issue_date":"2018-03-24T00:00:00","most_recent_issue_date":"2018-03-24T00:00:00","effective_date":"2018-03-24T00:00:00","expiration_date":"2018-03-24T00:00:00","parcel_number":"0002G00066000000","address":"1027 5TH AVE, Pittsburgh, PA 15219-","email_address":"JGRANT@PPGPAINTSARENA.COM","primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":69,"license_number":"AP000809","license_type_name":"Amusement Producer","naics_code":"713110","business_name":"AEG MANAGEMENT PITTSBURGH","license_state":"Expired","initial_issue_date":"2018-06-01T00:00:00","most_recent_issue_date":"2018-06-01T00:00:00","effective_date":"2018-06-01T00:00:00","expiration_date":"2018-06-01T00:00:00","parcel_number":"0002G00066000000","address":"1027 5TH AVE, Pittsburgh, PA 15219-","email_address":"JGRANT@PPGPAINTSARENA.COM","primary_phone_number":"(412) 804-2699","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":70,"license_number":"MD1230","license_type_name":"Mechanical Device","naics_code":"713290","business_name":"ACME VENDING INC","license_state":"Expired","initial_issue_date":"2018-03-08T12:38:43","most_recent_issue_date":"2018-03-08T12:40:32","effective_date":"2018-03-08T12:40:32","expiration_date":"2019-03-08T12:40:32","parcel_number":null,"address":null,"email_address":"ACMEVENDINGINC@HOTMAIL.COM","primary_phone_number":"(412) 781-3630","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":1,"number_of_nongambling_machines":0,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":0,"number_of_units":null},{"_id":71,"license_number":"PK00688","license_type_name":"Parking Lot","naics_code":"812930","business_name":"UNIVERSITY OF PITTSBURGH","license_state":"Expired","initial_issue_date":"2012-01-18T08:55:38","most_recent_issue_date":"2015-02-04T10:09:28","effective_date":"2015-02-04T10:09:28","expiration_date":"2016-02-04T10:09:28","parcel_number":"0027K00028000000","address":"5243 UNIVERSITY C DR, Pittsburgh, PA 15213-","email_address":null,"primary_phone_number":"(412) 624-8904","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":0,"number_of_revgen_spaces":0,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":72,"license_number":"PK00706","license_type_name":"Parking Lot","naics_code":"812930","business_name":"CENTRAL PARKING SYSTEM","license_state":"Expired","initial_issue_date":"2012-06-13T09:54:00","most_recent_issue_date":"2018-03-08T13:18:03","effective_date":"2018-03-08T13:18:03","expiration_date":"2019-03-08T13:18:03","parcel_number":"0001C01661000000","address":null,"email_address":null,"primary_phone_number":"(615) 297-9453","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":0,"number_of_revgen_spaces":0,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":73,"license_number":"SD0012","license_type_name":"Secondhand Dealer","naics_code":"453310","business_name":"TEX'S AUTO SALES LLC","license_state":"Expired","initial_issue_date":"2011-02-28T08:45:39","most_recent_issue_date":"2015-06-23T11:43:59","effective_date":"2015-06-23T11:43:59","expiration_date":"2016-06-23T11:43:59","parcel_number":"0080D00019000000","address":"5250 BUTLER ST, Pittsburgh, PA 15201-","email_address":null,"primary_phone_number":"(412) 781-3333","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":74,"license_number":"SD0041","license_type_name":"Secondhand Dealer","naics_code":"453310","business_name":"J&M AUTO SALES","license_state":"Expired","initial_issue_date":"2011-03-16T14:26:59","most_recent_issue_date":"2015-07-15T09:55:11","effective_date":"2015-07-15T09:55:11","expiration_date":"2016-07-15T09:55:11","parcel_number":"0031G00084000000","address":"4602 E CARSON ST, Pittsburgh, PA 15203-","email_address":null,"primary_phone_number":"(412) 831-1001","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":75,"license_number":"SD0074","license_type_name":"Secondhand Dealer","naics_code":"453310","business_name":"EONS FASHION ANTIQUE","license_state":"Expired","initial_issue_date":"2011-03-16T15:23:05","most_recent_issue_date":"2015-07-15T10:05:06","effective_date":"2015-07-15T10:05:06","expiration_date":"2016-07-15T10:05:06","parcel_number":"0084J00278000000","address":"5850 ELLSWORTH AVE, Pittsburgh, PA 15232-","email_address":"eonsfashion@gmail.com","primary_phone_number":"(412) 361-3368","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":76,"license_number":"SD0025","license_type_name":"Secondhand Dealer","naics_code":"453310","business_name":"WEISS AUTOMOTIVE SALES","license_state":"Expired","initial_issue_date":"2012-02-15T10:33:15","most_recent_issue_date":"2015-07-13T13:14:29","effective_date":"2015-07-13T13:14:29","expiration_date":"2016-07-13T13:14:29","parcel_number":"0035S00193000000","address":"1803 WEST LIBERTY AVE, Pittsburgh, PA 15226-","email_address":null,"primary_phone_number":"(412) 561-1955","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":77,"license_number":"SD0046","license_type_name":"Secondhand Dealer","naics_code":"453310","business_name":"GOLDSTOCK CO.","license_state":"Expired","initial_issue_date":"2012-02-15T10:46:12","most_recent_issue_date":"2015-06-23T11:58:38","effective_date":"2015-06-23T11:58:38","expiration_date":"2016-06-23T11:58:38","parcel_number":"0001D00066000000","address":"713 LIBERTY AVE, Pittsburgh, PA 15222-","email_address":"info@goldstockjewelers.com","primary_phone_number":"(412) 281-1789","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":78,"license_number":"PK00746","license_type_name":"Parking Lot","naics_code":"812930","business_name":"HOLIDAY INN EXPRESS - SOUTH SIDE","license_state":"Expired","initial_issue_date":"2011-11-11T11:25:14","most_recent_issue_date":"2017-10-23T07:58:00","effective_date":"2017-10-23T07:58:00","expiration_date":"2018-10-23T07:58:00","parcel_number":"0003G00216000000","address":"20 S 10TH ST, Pittsburgh, PA 15203-","email_address":"LICENSING@AIMHOSP.COM","primary_phone_number":"(972) 952-0200","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":91,"number_of_revgen_spaces":91,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":79,"license_number":"SD0149","license_type_name":"Secondhand Dealer","naics_code":"453310","business_name":"TOM LYNCH AUTO SALES","license_state":"Expired","initial_issue_date":"2015-03-18T12:56:55","most_recent_issue_date":"2013-03-25T15:21:44","effective_date":"2013-03-25T15:21:44","expiration_date":"2014-03-25T15:21:44","parcel_number":"0060N00129000000","address":"1875 SAW MILL RUN BLVD, Pittsburgh, PA 15210-","email_address":null,"primary_phone_number":"(412) 881-5070","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":80,"license_number":"TOW0039","license_type_name":"Limited Towing","naics_code":"488410","business_name":"CARLOW UNIVERSITY - PUBLIC SAFETY","license_state":"Expired","initial_issue_date":"2015-10-09T16:45:19","most_recent_issue_date":"2014-12-02T14:57:08","effective_date":"2014-12-02T14:57:08","expiration_date":"2015-12-02T14:57:08","parcel_number":"0028A00187000000","address":null,"email_address":null,"primary_phone_number":"(412) 578-8898","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":81,"license_number":"MD1126","license_type_name":"Mechanical Device","naics_code":"713290","business_name":"V & R VENDING CO","license_state":"Expired","initial_issue_date":"2014-02-20T12:05:30","most_recent_issue_date":"2016-03-07T10:24:54","effective_date":"2016-03-07T10:24:54","expiration_date":"2017-03-07T10:24:54","parcel_number":"0082H00195000000","address":"1426 N EUCLID AVE, Pittsburgh, PA 15206-","email_address":null,"primary_phone_number":"(412) 664-4976","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":1,"number_of_nongambling_machines":0,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":0,"number_of_units":null},{"_id":82,"license_number":"PED0947","license_type_name":"Peddler","naics_code":"722330","business_name":"RENEWAL BY ANDERSON","license_state":"Expired","initial_issue_date":"2015-01-21T14:20:05","most_recent_issue_date":"2014-03-31T12:32:57","effective_date":"2014-03-31T12:32:57","expiration_date":"2015-03-31T12:32:57","parcel_number":null,"address":null,"email_address":null,"primary_phone_number":"(412) 654-7695","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":83,"license_number":"MD1127","license_type_name":"Mechanical Device","naics_code":"713290","business_name":"J & D AMUSEMENT INC","license_state":"Expired","initial_issue_date":"2014-02-27T10:57:54","most_recent_issue_date":"2015-05-06T12:07:04","effective_date":"2015-05-06T12:07:04","expiration_date":"2016-05-06T12:07:04","parcel_number":"0081M00327000000","address":"223 SCHENLEY MANOR DR, Pittsburgh, PA 15201-","email_address":null,"primary_phone_number":"(412) 904-4086","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":1,"number_of_nongambling_machines":0,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":0,"number_of_units":null},{"_id":84,"license_number":"MD1130","license_type_name":"Mechanical Device","naics_code":"713290","business_name":"WINDTOP VENDING","license_state":"Expired","initial_issue_date":"2014-03-01T10:42:04","most_recent_issue_date":"2020-03-23T00:00:00","effective_date":"2020-04-05T00:00:00","expiration_date":"2021-04-04T00:00:00","parcel_number":"0174S00163000000","address":"7906 FRANKSTOWN AVE, Pittsburgh, PA 15221-","email_address":"BELMONT.AMUSEMENT@GMAIL.COM","primary_phone_number":"(412) 488-2220","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":1,"number_of_nongambling_machines":1,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":1,"number_of_units":null},{"_id":85,"license_number":"PED0953","license_type_name":"Peddler","naics_code":"722330","business_name":"PREMIER MARKETING INNOVATIONS INC FOR VERIZON FIOS","license_state":"Expired","initial_issue_date":"2015-01-21T14:20:01","most_recent_issue_date":"2014-03-18T11:20:03","effective_date":"2014-03-18T11:20:03","expiration_date":"2015-03-18T11:20:03","parcel_number":null,"address":null,"email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":86,"license_number":"VEN0331","license_type_name":"Stationary Vendor","naics_code":"453210","business_name":"PGH CREPES LLC","license_state":"Expired","initial_issue_date":"2014-03-27T14:19:50","most_recent_issue_date":"2025-03-12T00:00:00","effective_date":"2025-03-13T00:00:00","expiration_date":"2026-03-12T00:00:00","parcel_number":null,"address":null,"email_address":"PGHCREPES@GMAIL.COM","primary_phone_number":"(412) 251-3227","insurance_expiration_date":"2019-08-31","number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":87,"license_number":"VEN0332","license_type_name":"Stationary Vendor","naics_code":"453210","business_name":"EDWARD COMAS","license_state":"Expired","initial_issue_date":"2014-04-04T08:10:48","most_recent_issue_date":"2020-02-28T00:00:00","effective_date":"2020-02-29T00:00:00","expiration_date":"2021-02-27T00:00:00","parcel_number":null,"address":null,"email_address":"edcomas1@gmail.com","primary_phone_number":"(412) 448-5067","insurance_expiration_date":"2020-01-01","number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":88,"license_number":"TOW0483","license_type_name":"Limited Towing","naics_code":"488410","business_name":"BURGER-KING","license_state":"Expired","initial_issue_date":"2015-10-09T16:46:15","most_recent_issue_date":"2014-12-30T09:31:09","effective_date":"2014-12-30T09:31:09","expiration_date":"2015-12-30T09:31:09","parcel_number":"0137B00128000000","address":"2900 BROWNSVILLE RD, Pittsburgh, PA 15227-","email_address":null,"primary_phone_number":"(412) 885-1710","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":89,"license_number":"SD0283","license_type_name":"Secondhand Dealer","naics_code":"453310","business_name":"TDM TERWILLIGER","license_state":"Expired","initial_issue_date":"2015-03-18T13:03:52","most_recent_issue_date":"2014-04-21T07:58:26","effective_date":"2014-04-21T07:58:26","expiration_date":"2015-04-21T07:58:26","parcel_number":"0027R00190000000","address":"3959 5TH AVE, Pittsburgh, PA 15213-","email_address":null,"primary_phone_number":"(412) 631-7866 Ext. 804","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":90,"license_number":"PED0958","license_type_name":"Peddler","naics_code":"722330","business_name":"James Bell","license_state":"Expired","initial_issue_date":"2015-01-21T14:20:09","most_recent_issue_date":"2014-04-22T13:57:00","effective_date":"2014-04-22T13:57:00","expiration_date":"2015-04-22T13:57:00","parcel_number":null,"address":null,"email_address":null,"primary_phone_number":"(724) 859-7765","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":91,"license_number":"AP000522","license_type_name":"Amusement Producer","naics_code":"713110","business_name":"AEG - CONSOL ENERGY CENTER","license_state":"Expired","initial_issue_date":"2014-05-27T00:00:00","most_recent_issue_date":"2014-05-27T00:00:00","effective_date":"2014-05-27T00:00:00","expiration_date":"2014-05-27T00:00:00","parcel_number":"0002G00066000000","address":"1027 5TH AVE, Pittsburgh, PA 15219-","email_address":null,"primary_phone_number":"(412) 804-7806","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":null,"number_of_small_signs":null,"number_of_signs_total":null,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":92,"license_number":"15-SNC00001142","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"CVS PHARMACY / #4120","license_state":"Expired","initial_issue_date":"2015-09-03T09:25:29","most_recent_issue_date":"2015-09-03T09:45:08","effective_date":"2015-09-03T09:45:08","expiration_date":"2016-09-03T09:45:08","parcel_number":"0002A00016000000","address":"610 WOOD ST, Pittsburgh, PA 15222-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":2,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":93,"license_number":"15-SNC00001145","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"BOY AND GIRLS CLUB OF WESTERN PA","license_state":"Expired","initial_issue_date":"2015-09-03T09:34:51","most_recent_issue_date":"2015-09-16T08:58:47","effective_date":"2015-09-16T08:58:47","expiration_date":"2016-09-16T08:58:47","parcel_number":null,"address":null,"email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":2,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":94,"license_number":"15-SNC00001148","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"SALONIKA GYROS","license_state":"Expired","initial_issue_date":"2015-09-03T09:52:18","most_recent_issue_date":"2016-07-11T15:26:21","effective_date":"2016-07-11T15:26:21","expiration_date":"2017-07-11T15:26:21","parcel_number":"0008S00038000000","address":"143 6TH ST, Pittsburgh, PA 15222-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":95,"license_number":"15-SNC00001151","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"ABRIOLA AUTO PARTS INC","license_state":"Expired","initial_issue_date":"2015-09-03T10:20:56","most_recent_issue_date":"2016-06-09T09:08:50","effective_date":"2016-06-09T09:08:50","expiration_date":"2017-06-09T09:08:50","parcel_number":"0056K00186000000","address":"5035 2ND AVE, Pittsburgh, PA 15207-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":3,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":96,"license_number":"15-SNC00001156","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"LOCOMOTIVE DEVELOPMENT LP","license_state":"Expired","initial_issue_date":"2015-09-03T10:43:04","most_recent_issue_date":"2016-06-24T08:41:41","effective_date":"2016-06-24T08:41:41","expiration_date":"2017-06-24T08:41:41","parcel_number":"0080F00104000000","address":"4840 HARRISON ST, Pittsburgh, PA 15201-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":97,"license_number":"15-SNC00001159","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"SUNRISE MOTOR INC","license_state":"Expired","initial_issue_date":"2015-09-03T10:52:32","most_recent_issue_date":"2017-08-08T14:45:45","effective_date":"2017-08-08T14:45:45","expiration_date":"2018-08-08T14:45:45","parcel_number":"0061M00044000000","address":"1684 SAW MILL RUN BLVD, Pittsburgh, PA 15210-","email_address":null,"primary_phone_number":"(412) 882-300","insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":98,"license_number":"15-SNC00001163","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"ONE OLIVER ASSOCIATES LP/GRUBBS &","license_state":"Expired","initial_issue_date":"2015-09-03T11:00:33","most_recent_issue_date":"2016-07-07T15:45:45","effective_date":"2016-07-07T15:45:45","expiration_date":"2017-07-07T15:45:45","parcel_number":"0001D00221000000","address":"210 6TH AVE, Pittsburgh, PA 15222-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":6,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":99,"license_number":"15-SNC00001166","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"SALON UZORI INC","license_state":"Expired","initial_issue_date":"2015-09-03T11:12:11","most_recent_issue_date":"2015-09-03T11:17:50","effective_date":"2015-09-03T11:17:50","expiration_date":"2016-09-03T11:17:50","parcel_number":"0012L00227000000","address":"2308 E CARSON ST, Pittsburgh, PA 15203-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":1,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null},{"_id":100,"license_number":"15-SNC00001170","license_type_name":"Sign Maintenance Certification","naics_code":"541850","business_name":"BIG B ROWLAND 3878 LLC","license_state":"Expired","initial_issue_date":"2015-09-03T12:10:32","most_recent_issue_date":"2017-08-02T14:15:15","effective_date":"2017-08-02T14:15:15","expiration_date":"2018-08-02T14:15:15","parcel_number":"0044M00105000000","address":"2650 CALIFORNIA AVE, Pittsburgh, PA 15212-","email_address":null,"primary_phone_number":null,"insurance_expiration_date":null,"number_of_buildings":null,"number_of_employees":null,"number_of_large_signs":0,"number_of_small_signs":0,"number_of_signs_total":2,"number_of_handicap_spaces":null,"number_of_nonleased_pub_spaces":null,"number_of_revgen_spaces":null,"total_number_of_spaces":null,"number_of_jukeboxes":null,"number_of_nongambling_machines":null,"number_of_rooms":null,"number_of_seats":null,"number_of_pool_tables":null,"number_of_units":null}], "fields": [{"id": "_id", "type": "int"}, {"id": "license_number", "type": "text", "info": {"label": "License Number", "notes": "Identification number associated with the license."}}, {"id": "license_type_name", "type": "text", "info": {"label": "License Type Name", "notes": "Specific type of license associated with the issued license."}}, {"id": "naics_code", "type": "text", "info": {"label": "NAICS Code", "notes": "Identification code per the standards of the North American Industry Classification System."}}, {"id": "business_name", "type": "text", "info": {"label": "Business Name", "notes": "Name of business associated with the license. Sole proprietors are referred to by name."}}, {"id": "license_state", "type": "text", "info": {"label": "License State", "notes": "A description of whether the license is currently Active or Expired."}}, {"id": "initial_issue_date", "type": "timestamp", "info": {"label": "Initial Issue Date", "notes": "Date the license was initially issued"}}, {"id": "most_recent_issue_date", "type": "timestamp", "info": {"label": "Most Recent Issue Date", "notes": "Date where the most recent issue or renewal occurred. This may be the same as the initial license date."}}, {"id": "effective_date", "type": "timestamp", "info": {"label": "Effective Date", "notes": "Date the certification became active."}}, {"id": "expiration_date", "type": "timestamp", "info": {"label": "Expiration Date", "notes": "Date the certification will no longer be active."}}, {"id": "parcel_number", "type": "text", "info": {"label": "Parcel Number", "notes": "Parcel Number for the location of the associated business, if applicable."}}, {"id": "address", "type": "text", "info": {"label": "Street address", "notes": "Building number and street. When a structure is demolished the county removes the building number. The structure technically has no address at that point. These properties have a building number of zero."}}, {"id": "email_address", "type": "text", "info": {"label": "", "notes": "Preferred e-mail contact for business"}}, {"id": "primary_phone_number", "type": "text", "info": {"label": "Primary Business Phone Number", "notes": "Formatted version of the phone number associated with the license application."}}, {"id": "insurance_expiration_date", "type": "date", "info": {"label": "Insurance Expiration Date", "notes": "Date when the insurance associated with the license expires, when applicable. "}}, {"id": "number_of_buildings", "type": "int4", "info": {"label": "Number of Buildings", "notes": "Number of buildings that the license applies to, when applicable."}}, {"id": "number_of_employees", "type": "int4", "info": {"label": "Number of Employees", "notes": "Number of employees associated with the license, when applicable."}}, {"id": "number_of_large_signs", "type": "int4", "info": {"label": "Number of Large Signs", "notes": "Number of large signs associated with the license, when applicable."}}, {"id": "number_of_small_signs", "type": "int4", "info": {"label": "Number of Small Signs", "notes": "Number of small signs associated with the license, when applicable."}}, {"id": "number_of_signs_total", "type": "int4", "info": {"label": "Number of Signs, Total", "notes": "Total number of signs associated with the license, when applicable."}}, {"id": "number_of_handicap_spaces", "type": "int4", "info": {"label": "Number of Handicap Spaces", "notes": "If a parking lot permit, the number of handicap spaces that are built into the lot."}}, {"id": "number_of_nonleased_pub_spaces", "type": "int4", "info": {"label": "Number of Non-Leased Public Spaces", "notes": "If a parking lot permit, the number of spaces that are not leased and are available for public use."}}, {"id": "number_of_revgen_spaces", "type": "int4", "info": {"label": "Number of Revenue-generating Spaces", "notes": "If a parking lot permit, the number of spaces that have a fee for use, with the purpose of generating revenue."}}, {"id": "total_number_of_spaces", "type": "int4", "info": {"label": "Total Number of Spaces", "notes": "If a parking lot permit, the total number of spaces available for any use in the lot."}}, {"id": "number_of_jukeboxes", "type": "int4", "info": {"label": "Number of Jukeboxes", "notes": "Number of jukeboxes that are associated with a business' permit."}}, {"id": "number_of_nongambling_machines", "type": "int4", "info": {"label": "Number of Gambling Machines", "notes": "Number of gambling machines that are associated with a business' permit."}}, {"id": "number_of_rooms", "type": "int4", "info": {"label": "Number of Rooms", "notes": "Number of rooms in the building or space that is associated with a business' permit."}}, {"id": "number_of_seats", "type": "int4", "info": {"label": "Number of Seats", "notes": "Number of seats in the building or space that is associated with a business' permit."}}, {"id": "number_of_pool_tables", "type": "int4", "info": {"label": "Number of Pool Tables", "notes": "Number of pool tables in the building or space that is associated with a business' permit."}}, {"id": "number_of_units", "type": "int4", "info": {"label": "Number of Units", "notes": "Number of units in the building or space that is associated with a business' permit."}}], "_links": {"start": "/api/action/datastore_search?resource_id=e88c10d5-541d-417f-aef6-25cc5637aeb1", "next": "/api/action/datastore_search?resource_id=e88c10d5-541d-417f-aef6-25cc5637aeb1&offset=100"}, "total": 8437, "total_was_estimated": false}}