{"name":"Mermaid Oyster Bar Times Square","dba_name":"MERMAID OYSTER BAR","operating_legal_name":"MERMAID TIMES SQUARE LLC","declared_type":"Restaurant","address":{"street":"127 West 43rd Street","unit":"","city":"New York","region":"NY","postal_code":"10036","country":"US"},"coordinates":{"latitude":40.7561441,"longitude":-73.9844404},"phone":"+12126759794","email":"","website":"http://www.themermaidnyc.com/","map_url":"","timezone":"","operational_status":"active","cuisines":["Seafood, Contemporary American, Oyster Bar"],"price_range":"$31 to $50","attributes":{},"hours":[{"service":"business","text":"Monday - Sunday 11:30 am-9:00 pm Happy Hour Daily 3:30 pm-5:30 pm"},{"service":"dinner","text":"Monday 15:30-21:00"},{"service":"dinner","text":"Tuesday 15:30-21:00"},{"service":"dinner","text":"Wednesday 15:30-21:00"},{"service":"dinner","text":"Thursday 15:30-21:00"},{"service":"dinner","text":"Friday 15:30-21:00"},{"service":"dinner","text":"Saturday 15:30-21:00"},{"service":"dinner","text":"Sunday 15:30-21:00"},{"service":"happy_hour","text":"Monday 15:30-18:30"},{"service":"happy_hour","text":"Tuesday 15:30-18:30"},{"service":"happy_hour","text":"Wednesday 15:30-18:30"},{"service":"happy_hour","text":"Thursday 15:30-18:30"},{"service":"happy_hour","text":"Friday 15:30-18:30"},{"service":"happy_hour","text":"Saturday 15:30-18:30"},{"service":"happy_hour","text":"Sunday 15:30-18:30"},{"service":"lunch","text":"Monday 11:30-15:30"},{"service":"lunch","text":"Tuesday 11:30-15:30"},{"service":"lunch","text":"Wednesday 11:30-15:30"},{"service":"lunch","text":"Thursday 11:30-15:30"},{"service":"lunch","text":"Friday 11:30-15:30"},{"service":"lunch","text":"Saturday 11:30-15:30"},{"service":"lunch","text":"Sunday 11:30-15:30"}],"links":[{"kind":"reservations","url":"https://www.opentable.com/r/mermaid-oyster-bar-times-square-new-york","provider":"opentable"},{"kind":"reservations","url":"https://www.opentable.com/r/mermaid-oyster-bar-times-square-reservations-new-york?lang=en-US&ot_source=Restaurant+website&restref=1233247","provider":"opentable"}],"resolution_meta":{"dba_name":{"status":"material_conflict","reason":"sources disagree and no evidence separates them; one value is selected by rule, alternatives retained","selected_source":"NYC_DOHMH","alternatives":[{"value":"TS Burger; Mermaid Oyster Bar; Bar Mexicana","source":"NY_SLA"}]},"coordinates":{"status":"material_conflict","reason":"no venue point was published; a reservation platform's point for the listing it keeps","selected_source":"opentable","alternatives":[{"value":{"latitude":40.755861716031,"longitude":-73.984290064783},"source":"us_census_geocoder"},{"value":{"latitude":40.75586636582,"longitude":-73.984453903471},"source":"NYC_DOHMH"},{"value":{"latitude":40.7561,"longitude":-73.98503},"source":"NY_SLA"}]},"address.city":{"status":"material_conflict","reason":"publisher alternative independently corroborated by an associated provider","selected_source":"website location card","alternatives":[{"value":"NY","source":"website location card"}]}},"field_sources":{"name":{"basis":"publisher_declared","via":["https://www.themermaidnyc.com/","website location card"],"last_confirmed_at":"2026-10-23T11:41:52.233964Z"},"phone":{"basis":"publisher_declared","via":["https://www.themermaidnyc.com/","website location card"],"last_confirmed_at":"2026-10-23T11:41:52.233964Z"},"website":{"basis":"external_source","via":["https://www.opentable.com/restaurant/profile/1233247","opentable"],"last_confirmed_at":"2026-10-23T11:43:03.141789Z"},"cuisines":{"basis":"external_source","via":["https://www.opentable.com/restaurant/profile/1233247","opentable"],"last_confirmed_at":"2026-10-23T11:43:03.141789Z"},"dba_name":{"basis":"external_source","via":["https://data.cityofnewyork.us/resource/43nn-pn8j.json?%24limit=100&%24offset=0&%24order=inspection_date+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27MERMAID+OYSTER+BAR+TIMES+SQUARE%27+OR+%28building%3D%27127%27+AND+UPPER%28street%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zipcode%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zipcode+IS+NULL+OR+zipcode%3A%3Atext+%3D+%27%27%29%29%29","NYC_DOHMH"],"last_confirmed_at":"2026-10-23T11:44:10.907205Z"},"coordinates":{"basis":"external_source","via":["https://www.opentable.com/restaurant/profile/1233247","opentable"],"last_confirmed_at":"2026-10-23T11:43:03.141789Z"},"hours.lunch":{"basis":"publisher_declared","via":["https://www.themermaidnyc.com/mermaid-oyster-bar-times-square/","website location card"],"last_confirmed_at":"2026-10-23T11:42:01.691338Z"},"price_range":{"basis":"external_source","via":["https://www.opentable.com/restaurant/profile/1233247","opentable"],"last_confirmed_at":"2026-10-23T11:43:03.141789Z"},"address.city":{"basis":"publisher_declared","via":["https://www.themermaidnyc.com/mermaid-oyster-bar-times-square/","website location card"],"last_confirmed_at":"2026-10-23T11:42:01.691338Z"},"hours.dinner":{"basis":"publisher_declared","via":["https://www.themermaidnyc.com/mermaid-oyster-bar-times-square/","website location card"],"last_confirmed_at":"2026-10-23T11:42:01.691338Z"},"declared_type":{"basis":"external_source","via":["https://www.opentable.com/restaurant/profile/1233247","opentable"],"last_confirmed_at":"2026-10-23T11:43:03.141789Z"},"address.region":{"basis":"publisher_declared","via":["https://www.themermaidnyc.com/","website location card"],"last_confirmed_at":"2026-10-23T11:41:52.233964Z"},"address.street":{"basis":"publisher_declared","via":["https://www.themermaidnyc.com/","website location card"],"last_confirmed_at":"2026-10-23T11:41:52.233964Z"},"hours.business":{"basis":"external_source","via":["https://www.opentable.com/restaurant/profile/1233247","opentable"],"last_confirmed_at":"2026-10-23T11:43:03.141789Z"},"address.country":{"basis":"external_source","via":["https://www.opentable.com/restaurant/profile/1233247","opentable"],"last_confirmed_at":"2026-10-23T11:43:03.141789Z"},"licenses.ny_sla":{"basis":"external_source","via":["https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=UPPER%28legalname%29+IN+%28%27MERMAID+TIMES+SQUARE+LLC%27%2C%27MERMAID+TIMES+SQUARE%2C+LLC%27%2C%27MERMAID+TIMES+SQUARE+L.L.C.%27%2C%27MERMAID+TIMES+SQUARE%2C+L.L.C.%27%2C%27MERMAID+TIMES+SQUARE+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+TIMES+SQUARE%2C+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+TIMES+SQUARE+LIMITED+LIABILITY+CO%27%2C%27MERMAID+TIMES+SQUARE%2C+LIMITED+LIABILITY+CO%27%29","NY_SLA"],"last_confirmed_at":"2026-10-23T11:44:12.216167Z"},"hours.happy_hour":{"basis":"publisher_declared","via":["https://www.themermaidnyc.com/mermaid-oyster-bar-times-square/","website location card"],"last_confirmed_at":"2026-10-23T11:42:01.691338Z"},"operational_status":{"basis":"publisher_declared","via":["https://www.themermaidnyc.com/mermaid-oyster-bar-times-square/","website location card"],"last_confirmed_at":"2026-10-23T11:41:52.046762Z"},"address.postal_code":{"basis":"publisher_declared","via":["https://www.themermaidnyc.com/","website location card"],"last_confirmed_at":"2026-10-23T11:41:52.233964Z"},"operating_legal_name":{"basis":"external_source","via":["https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=UPPER%28legalname%29+IN+%28%27MERMAID+TIMES+SQUARE+LLC%27%2C%27MERMAID+TIMES+SQUARE%2C+LLC%27%2C%27MERMAID+TIMES+SQUARE+L.L.C.%27%2C%27MERMAID+TIMES+SQUARE%2C+L.L.C.%27%2C%27MERMAID+TIMES+SQUARE+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+TIMES+SQUARE%2C+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+TIMES+SQUARE+LIMITED+LIABILITY+CO%27%2C%27MERMAID+TIMES+SQUARE%2C+LIMITED+LIABILITY+CO%27%29","NY_SLA"],"last_confirmed_at":"2026-10-23T11:44:12.216167Z"},"licenses.ny_nyc_health":{"basis":"external_source","via":["https://data.cityofnewyork.us/resource/43nn-pn8j.json?%24limit=100&%24offset=0&%24order=inspection_date+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27MERMAID+OYSTER+BAR+TIMES+SQUARE%27+OR+%28building%3D%27127%27+AND+UPPER%28street%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zipcode%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zipcode+IS+NULL+OR+zipcode%3A%3Atext+%3D+%27%27%29%29%29","NYC_DOHMH"],"last_confirmed_at":"2026-10-23T11:44:10.907205Z"},"licenses.ny_nyc_building":{"basis":"external_source","via":["https://data.cityofnewyork.us/resource/rbx6-tga4.json?%24limit=100&%24offset=0&%24order=expired_date+DESC%2C%3Aid&%24where=%28%28house_no%3D%27127%27+AND+UPPER%28street_name%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zip_code%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zip_code+IS+NULL+OR+zip_code%3A%3Atext+%3D+%27%27%29%29%29","NYC_DOB"],"last_confirmed_at":"2026-10-23T11:44:10.594692Z"}},"id":"a5c6a25c-2daa-48af-810e-0a375108e886","revision":1,"association_status":"accepted","identifiers":[{"provider":"NYC_DOB","kind":"building_permit_id","value":"M00690400-I1","scope":"license","status":"provider_confirmed","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"provider":"NYC_DOB","kind":"building_permit_id","value":"M00690400-S1","scope":"license","status":"provider_confirmed","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"provider":"NYC_DOB","kind":"building_permit_id","value":"M00690400-S2","scope":"license","status":"provider_confirmed","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"provider":"NYC_DOB","kind":"building_permit_id","value":"M00690400-S3","scope":"license","status":"provider_confirmed","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"provider":"NYC_DOB","kind":"building_permit_id","value":"M00741506-I1","scope":"license","status":"provider_confirmed","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"provider":"NYC_DOB","kind":"building_permit_id","value":"M00744351-I1","scope":"license","status":"provider_confirmed","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"provider":"NYC_DOB","kind":"building_permit_id","value":"M00810508-I1","scope":"license","status":"provider_confirmed","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"provider":"NYC_DOB","kind":"building_permit_id","value":"M00971279-I1","scope":"license","status":"provider_confirmed","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"provider":"NYC_DOB","kind":"building_permit_id","value":"M01145549-I1","scope":"license","status":"provider_confirmed","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"provider":"NY_SLA","kind":"liquor_license_id","value":"0340-23-136174","scope":"license","status":"provider_confirmed","first_seen_at":"2026-10-23T11:44:12.216167Z","last_confirmed_at":"2026-10-23T11:44:12.216167Z"},{"provider":"NY_SLA","kind":"liquor_license_id","value":"0423-23-136086","scope":"license","status":"provider_confirmed","first_seen_at":"2026-10-23T11:44:12.216167Z","last_confirmed_at":"2026-10-23T11:44:12.216167Z"},{"provider":"NY_SLA","kind":"liquor_license_id","value":"0423-23-136517","scope":"license","status":"provider_confirmed","first_seen_at":"2026-10-23T11:44:12.216167Z","last_confirmed_at":"2026-10-23T11:44:12.216167Z"},{"provider":"opentable","kind":"opentable_restaurant","value":"mermaid-oyster-bar-times-square-new-york","scope":"location","status":"provider_confirmed","first_seen_at":"2026-10-23T11:43:35.761756Z","last_confirmed_at":"2026-10-23T11:43:35.761756Z"},{"provider":"opentable","kind":"opentable_restaurant","value":"mermaid-oyster-bar-times-square-reservations-new-york","scope":"location","status":"provider_confirmed","first_seen_at":"2026-10-23T11:43:35.761756Z","last_confirmed_at":"2026-10-23T11:43:35.761756Z"},{"provider":"opentable","kind":"opentable_restaurant_id","value":"1233247","scope":"location","status":"provider_confirmed","first_seen_at":"2026-10-23T11:43:35.761756Z","last_confirmed_at":"2026-10-23T11:43:35.761756Z"}],"licenses":[{"source_id":"ny_nyc_building","authority":"NYC_DOB","jurisdiction":"NY","kind":"building_permit","number":"M00690400-I1","parent_number":"","type":"General Construction","status":"Signed-off","state":"not_current","scope":"property","state_basis":"date_outside_current_period","licensee":"FIND AID FOR THE AGED INC","dba_name":"","issued_date":"2022-04-07","original_issue_date":"2022-03-21","effective_date":"","expiration_date":"2023-04-03","seats":null,"floor_area_sqft":null,"valuation_usd":10000,"work_description":"","parties":[],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.cityofnewyork.us/resource/rbx6-tga4.json?%24limit=100&%24offset=0&%24order=expired_date+DESC%2C%3Aid&%24where=%28%28house_no%3D%27127%27+AND+UPPER%28street_name%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zip_code%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zip_code+IS+NULL+OR+zip_code%3A%3Atext+%3D+%27%27%29%29%29","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"source_id":"ny_nyc_building","authority":"NYC_DOB","jurisdiction":"NY","kind":"building_permit","number":"M00690400-S1","parent_number":"","type":"Plumbing","status":"Signed-off","state":"not_current","scope":"property","state_basis":"date_outside_current_period","licensee":"FIND AID FOR THE AGED INC","dba_name":"","issued_date":"2022-08-02","original_issue_date":"","effective_date":"","expiration_date":"2023-04-15","seats":null,"floor_area_sqft":null,"valuation_usd":15000,"work_description":"","parties":[],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.cityofnewyork.us/resource/rbx6-tga4.json?%24limit=100&%24offset=0&%24order=expired_date+DESC%2C%3Aid&%24where=%28%28house_no%3D%27127%27+AND+UPPER%28street_name%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zip_code%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zip_code+IS+NULL+OR+zip_code%3A%3Atext+%3D+%27%27%29%29%29","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"source_id":"ny_nyc_building","authority":"NYC_DOB","jurisdiction":"NY","kind":"building_permit","number":"M00690400-S2","parent_number":"","type":"Mechanical Systems","status":"Signed-off","state":"not_current","scope":"property","state_basis":"date_outside_current_period","licensee":"FIND AID FOR THE AGED INC","dba_name":"","issued_date":"2022-08-10","original_issue_date":"","effective_date":"","expiration_date":"2023-04-10","seats":null,"floor_area_sqft":null,"valuation_usd":10000,"work_description":"","parties":[],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.cityofnewyork.us/resource/rbx6-tga4.json?%24limit=100&%24offset=0&%24order=expired_date+DESC%2C%3Aid&%24where=%28%28house_no%3D%27127%27+AND+UPPER%28street_name%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zip_code%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zip_code+IS+NULL+OR+zip_code%3A%3Atext+%3D+%27%27%29%29%29","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"source_id":"ny_nyc_building","authority":"NYC_DOB","jurisdiction":"NY","kind":"building_permit","number":"M00690400-S3","parent_number":"","type":"Sprinklers","status":"Signed-off","state":"not_current","scope":"property","state_basis":"date_outside_current_period","licensee":"FIND AID FOR THE AGED INC","dba_name":"","issued_date":"2022-08-08","original_issue_date":"","effective_date":"","expiration_date":"2023-03-02","seats":null,"floor_area_sqft":null,"valuation_usd":11000,"work_description":"","parties":[],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.cityofnewyork.us/resource/rbx6-tga4.json?%24limit=100&%24offset=0&%24order=expired_date+DESC%2C%3Aid&%24where=%28%28house_no%3D%27127%27+AND+UPPER%28street_name%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zip_code%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zip_code+IS+NULL+OR+zip_code%3A%3Atext+%3D+%27%27%29%29%29","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"source_id":"ny_nyc_building","authority":"NYC_DOB","jurisdiction":"NY","kind":"building_permit","number":"M00741506-I1","parent_number":"","type":"Sign","status":"Signed-off","state":"not_current","scope":"property","state_basis":"date_outside_current_period","licensee":"FIND AID FOR THE AGED INC","dba_name":"","issued_date":"2022-05-27","original_issue_date":"","effective_date":"","expiration_date":"2023-05-04","seats":null,"floor_area_sqft":null,"valuation_usd":5350,"work_description":"","parties":[],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.cityofnewyork.us/resource/rbx6-tga4.json?%24limit=100&%24offset=0&%24order=expired_date+DESC%2C%3Aid&%24where=%28%28house_no%3D%27127%27+AND+UPPER%28street_name%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zip_code%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zip_code+IS+NULL+OR+zip_code%3A%3Atext+%3D+%27%27%29%29%29","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"source_id":"ny_nyc_building","authority":"NYC_DOB","jurisdiction":"NY","kind":"building_permit","number":"M00744351-I1","parent_number":"","type":"Antenna","status":"Signed-off","state":"not_current","scope":"property","state_basis":"date_outside_current_period","licensee":"T-MOBILE","dba_name":"","issued_date":"2022-12-13","original_issue_date":"","effective_date":"","expiration_date":"2023-12-13","seats":null,"floor_area_sqft":null,"valuation_usd":25000,"work_description":"","parties":[],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.cityofnewyork.us/resource/rbx6-tga4.json?%24limit=100&%24offset=0&%24order=expired_date+DESC%2C%3Aid&%24where=%28%28house_no%3D%27127%27+AND+UPPER%28street_name%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zip_code%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zip_code+IS+NULL+OR+zip_code%3A%3Atext+%3D+%27%27%29%29%29","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"source_id":"ny_nyc_building","authority":"NYC_DOB","jurisdiction":"NY","kind":"building_permit","number":"M00810508-I1","parent_number":"","type":"Antenna","status":"Signed-off","state":"not_current","scope":"property","state_basis":"date_outside_current_period","licensee":"DISH WIRELESS","dba_name":"","issued_date":"2023-04-28","original_issue_date":"","effective_date":"","expiration_date":"2024-01-30","seats":null,"floor_area_sqft":null,"valuation_usd":83800,"work_description":"","parties":[],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.cityofnewyork.us/resource/rbx6-tga4.json?%24limit=100&%24offset=0&%24order=expired_date+DESC%2C%3Aid&%24where=%28%28house_no%3D%27127%27+AND+UPPER%28street_name%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zip_code%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zip_code+IS+NULL+OR+zip_code%3A%3Atext+%3D+%27%27%29%29%29","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"source_id":"ny_nyc_building","authority":"NYC_DOB","jurisdiction":"NY","kind":"building_permit","number":"M00971279-I1","parent_number":"","type":"General Construction","status":"Signed-off","state":"not_current","scope":"property","state_basis":"date_outside_current_period","licensee":"PROJECT FIND","dba_name":"","issued_date":"2024-01-18","original_issue_date":"","effective_date":"","expiration_date":"2024-09-21","seats":null,"floor_area_sqft":null,"valuation_usd":8700,"work_description":"","parties":[],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.cityofnewyork.us/resource/rbx6-tga4.json?%24limit=100&%24offset=0&%24order=expired_date+DESC%2C%3Aid&%24where=%28%28house_no%3D%27127%27+AND+UPPER%28street_name%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zip_code%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zip_code+IS+NULL+OR+zip_code%3A%3Atext+%3D+%27%27%29%29%29","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"source_id":"ny_nyc_building","authority":"NYC_DOB","jurisdiction":"NY","kind":"building_permit","number":"M00971279-I1","parent_number":"","type":"Structural","status":"Signed-off","state":"not_current","scope":"property","state_basis":"date_outside_current_period","licensee":"PROJECT FIND","dba_name":"","issued_date":"2024-01-18","original_issue_date":"","effective_date":"","expiration_date":"2024-09-21","seats":null,"floor_area_sqft":null,"valuation_usd":8700,"work_description":"","parties":[],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.cityofnewyork.us/resource/rbx6-tga4.json?%24limit=100&%24offset=0&%24order=expired_date+DESC%2C%3Aid&%24where=%28%28house_no%3D%27127%27+AND+UPPER%28street_name%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zip_code%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zip_code+IS+NULL+OR+zip_code%3A%3Atext+%3D+%27%27%29%29%29","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"source_id":"ny_nyc_building","authority":"NYC_DOB","jurisdiction":"NY","kind":"building_permit","number":"M01145549-I1","parent_number":"","type":"Suspended Scaffold","status":"Signed-off","state":"not_current","scope":"property","state_basis":"date_outside_current_period","licensee":"Woodstock HDFC","dba_name":"","issued_date":"2025-01-31","original_issue_date":"","effective_date":"","expiration_date":"2025-05-01","seats":null,"floor_area_sqft":null,"valuation_usd":null,"work_description":"","parties":[],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.cityofnewyork.us/resource/rbx6-tga4.json?%24limit=100&%24offset=0&%24order=expired_date+DESC%2C%3Aid&%24where=%28%28house_no%3D%27127%27+AND+UPPER%28street_name%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zip_code%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zip_code+IS+NULL+OR+zip_code%3A%3Atext+%3D+%27%27%29%29%29","first_seen_at":"2026-10-23T11:44:10.594692Z","last_confirmed_at":"2026-10-23T11:44:10.594692Z"},{"source_id":"ny_nyc_health","authority":"NYC_DOHMH","jurisdiction":"NY","kind":"health_inspection","number":"50130433/2024-09-09","parent_number":"50130433","type":"Inter-Agency Task Force / Initial Inspection","status":"No violations were recorded at the time of this inspection.","state":"","scope":"tenant_premises","state_basis":"","licensee":"","dba_name":"MERMAID OYSTER BAR","issued_date":"2024-09-09","original_issue_date":"","effective_date":"","expiration_date":"","seats":null,"floor_area_sqft":null,"valuation_usd":null,"work_description":"","parties":[],"inspection":{"outcome":"unknown","attribution":"accepted","risk":"","score":null,"grade":"","violation_count":0,"violations":[]},"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.cityofnewyork.us/resource/43nn-pn8j.json?%24limit=100&%24offset=0&%24order=inspection_date+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27MERMAID+OYSTER+BAR+TIMES+SQUARE%27+OR+%28building%3D%27127%27+AND+UPPER%28street%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zipcode%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zipcode+IS+NULL+OR+zipcode%3A%3Atext+%3D+%27%27%29%29%29","first_seen_at":"2026-10-23T11:44:10.907205Z","last_confirmed_at":"2026-10-23T11:44:10.907205Z"},{"source_id":"ny_nyc_health","authority":"NYC_DOHMH","jurisdiction":"NY","kind":"health_inspection","number":"50130433/2024-10-23","parent_number":"50130433","type":"Cycle Inspection / Initial Inspection","status":"Violations were cited in the following area(s).","state":"","scope":"tenant_premises","state_basis":"","licensee":"","dba_name":"MERMAID OYSTER BAR","issued_date":"2024-10-23","original_issue_date":"","effective_date":"","expiration_date":"","seats":null,"floor_area_sqft":null,"valuation_usd":null,"work_description":"","parties":[],"inspection":{"outcome":"grade","attribution":"accepted","risk":"","score":9,"grade":"A","violation_count":2,"violations":[{"code":"08A","description":"Establishment is not free of harborage or conditions conducive to rodents, insects or other pests.","comment":"","severity":"Not Critical","points":"","status":""},{"code":"04M","description":"Live roaches in facility's food or non-food area.","comment":"","severity":"Critical","points":"","status":""}]},"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.cityofnewyork.us/resource/43nn-pn8j.json?%24limit=100&%24offset=0&%24order=inspection_date+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27MERMAID+OYSTER+BAR+TIMES+SQUARE%27+OR+%28building%3D%27127%27+AND+UPPER%28street%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zipcode%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zipcode+IS+NULL+OR+zipcode%3A%3Atext+%3D+%27%27%29%29%29","first_seen_at":"2026-10-23T11:44:10.907205Z","last_confirmed_at":"2026-10-23T11:44:10.907205Z"},{"source_id":"ny_nyc_health","authority":"NYC_DOHMH","jurisdiction":"NY","kind":"health_inspection","number":"50130433/2026-07-21","parent_number":"50130433","type":"Cycle Inspection / Initial Inspection","status":"Violations were cited in the following area(s).","state":"","scope":"tenant_premises","state_basis":"","licensee":"","dba_name":"MERMAID OYSTER BAR","issued_date":"2026-07-21","original_issue_date":"","effective_date":"","expiration_date":"","seats":null,"floor_area_sqft":null,"valuation_usd":null,"work_description":"","parties":[],"inspection":{"outcome":"unknown","attribution":"accepted","risk":"","score":19,"grade":"","violation_count":5,"violations":[{"code":"06D","description":"Food contact surface not properly washed, rinsed and sanitized after each use and following any activity when contamination may have occurred.","comment":"","severity":"Critical","points":"","status":""},{"code":"09A","description":"Swollen, leaking, rusted or otherwise damaged canned food to be returned to distributor not segregated from intact product and clearly labeled DO NOT USE","comment":"","severity":"Not Critical","points":"","status":""},{"code":"08C","description":"Pesticide not properly labeled or used by unlicensed individual. Pesticide, other toxic chemical improperly used/stored. Unprotected, unlocked bait station used.","comment":"","severity":"Not Critical","points":"","status":""},{"code":"02G","description":"Cold TCS food item held above 41 °F; smoked or processed fish held above 38 °F; intact raw eggs held above 45 °F; or reduced oxygen packaged (ROP) TCS foods held above required temperatures except during active necessary preparation.","comment":"","severity":"Critical","points":"","status":""},{"code":"10F","description":"Non-food contact surface or equipment made of unacceptable material, not kept clean, or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.","comment":"","severity":"Not Critical","points":"","status":""}]},"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.cityofnewyork.us/resource/43nn-pn8j.json?%24limit=100&%24offset=0&%24order=inspection_date+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27MERMAID+OYSTER+BAR+TIMES+SQUARE%27+OR+%28building%3D%27127%27+AND+UPPER%28street%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28zipcode%3A%3Atext%29+LIKE+%2710036%25%27+OR+%28%28zipcode+IS+NULL+OR+zipcode%3A%3Atext+%3D+%27%27%29%29%29","first_seen_at":"2026-10-23T11:44:10.907205Z","last_confirmed_at":"2026-10-23T11:44:10.907205Z"},{"source_id":"ny_sla","authority":"NY_SLA","jurisdiction":"NY","kind":"liquor_license","number":"0340-23-136174","parent_number":"","type":"Restaurant","status":"","state":"current","scope":"operator","state_basis":"source_active_roster","licensee":"MERMAID TIMES SQUARE LLC","dba_name":"TS Burger; Mermaid Oyster Bar; Bar Mexicana","issued_date":"2026-08-07","original_issue_date":"2026-08-07","effective_date":"2025-05-01","expiration_date":"2027-04-30","seats":null,"floor_area_sqft":null,"valuation_usd":null,"work_description":"","parties":[],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=UPPER%28legalname%29+IN+%28%27MERMAID+TIMES+SQUARE+LLC%27%2C%27MERMAID+TIMES+SQUARE%2C+LLC%27%2C%27MERMAID+TIMES+SQUARE+L.L.C.%27%2C%27MERMAID+TIMES+SQUARE%2C+L.L.C.%27%2C%27MERMAID+TIMES+SQUARE+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+TIMES+SQUARE%2C+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+TIMES+SQUARE+LIMITED+LIABILITY+CO%27%2C%27MERMAID+TIMES+SQUARE%2C+LIMITED+LIABILITY+CO%27%29","first_seen_at":"2026-10-23T11:44:12.216167Z","last_confirmed_at":"2026-10-23T11:44:12.216167Z"},{"source_id":"ny_sla","authority":"NY_SLA","jurisdiction":"NY","kind":"liquor_license","number":"0423-23-136086","parent_number":"0340-23-136174","type":"Additional Bar","status":"","state":"current","scope":"operator","state_basis":"source_active_roster","licensee":"MERMAID TIMES SQUARE LLC","dba_name":"Bar Mexicana","issued_date":"2025-04-17","original_issue_date":"2025-04-17","effective_date":"2025-05-01","expiration_date":"2027-04-30","seats":null,"floor_area_sqft":null,"valuation_usd":null,"work_description":"","parties":[],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=UPPER%28legalname%29+IN+%28%27MERMAID+TIMES+SQUARE+LLC%27%2C%27MERMAID+TIMES+SQUARE%2C+LLC%27%2C%27MERMAID+TIMES+SQUARE+L.L.C.%27%2C%27MERMAID+TIMES+SQUARE%2C+L.L.C.%27%2C%27MERMAID+TIMES+SQUARE+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+TIMES+SQUARE%2C+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+TIMES+SQUARE+LIMITED+LIABILITY+CO%27%2C%27MERMAID+TIMES+SQUARE%2C+LIMITED+LIABILITY+CO%27%29","first_seen_at":"2026-10-23T11:44:12.216167Z","last_confirmed_at":"2026-10-23T11:44:12.216167Z"},{"source_id":"ny_sla","authority":"NY_SLA","jurisdiction":"NY","kind":"liquor_license","number":"0423-23-136517","parent_number":"0340-23-136174","type":"Additional Bar","status":"","state":"current","scope":"operator","state_basis":"source_active_roster","licensee":"MERMAID TIMES SQUARE LLC","dba_name":"Bar Mexicana","issued_date":"2025-04-17","original_issue_date":"2025-04-17","effective_date":"2025-05-01","expiration_date":"2027-04-30","seats":null,"floor_area_sqft":null,"valuation_usd":null,"work_description":"","parties":[],"inspection":null,"occupant_load":null,"occupancy_class":"","parcel_id":"","federal_ein":"","source_url":"https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=UPPER%28legalname%29+IN+%28%27MERMAID+TIMES+SQUARE+LLC%27%2C%27MERMAID+TIMES+SQUARE%2C+LLC%27%2C%27MERMAID+TIMES+SQUARE+L.L.C.%27%2C%27MERMAID+TIMES+SQUARE%2C+L.L.C.%27%2C%27MERMAID+TIMES+SQUARE+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+TIMES+SQUARE%2C+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+TIMES+SQUARE+LIMITED+LIABILITY+CO%27%2C%27MERMAID+TIMES+SQUARE%2C+LIMITED+LIABILITY+CO%27%29","first_seen_at":"2026-10-23T11:44:12.216167Z","last_confirmed_at":"2026-10-23T11:44:12.216167Z"}],"contact_routes":[],"domains":["themermaidnyc.com"],"first_seen_at":"2026-10-23T11:44:12.216167Z","last_confirmed_at":"2026-10-23T11:44:12.216167Z","materially_changed_at":"2026-10-23T11:44:17.184599Z"}