unit: 54626
This data as json
id | connections | accessibility_properties | identifiers_0_namespace | identifiers_0_value | identifiers_1_namespace | identifiers_1_value | department | root_department | provider_type | organizer_type | contract_type_id | contract_type_description_fi | contract_type_description_sv | contract_type_description_en | is_active | deleted_at | organizer_name | organizer_business_id | picture_url | picture_entrance_url | streetview_entrance_url | description_fi | description_en | short_description | name_fi | name_en | street_address_fi | street_address_sv | street_address_en | www_fi | www_sv | www_en | address_postal_full | call_charge_info_fi | call_charge_info_sv | call_charge_info_en | picture_caption | phone | fax | accessibility_phone | accessibility_email | accessibility_www | created_time | address_zip | data_source | extensions_maintenance_group | extensions_maintenance_organization | last_modified_time | accessibility_viewpoints | root_service_nodes | municipality | service_nodes | services | keywords | location_type | location_coordinates_0 | location_coordinates_1 | address_postal_full_fi | identifiers_2_value | picture_caption_fi | call_charge_info | www | name_sv | short_description_fi | accessibility_shortcoming_count_reduced_mobility | accessibility_shortcoming_count_wheelchair | location | picture_caption_sv | accessibility_shortcoming_count_stroller | address_postal_full_en | accessibility_shortcoming_count_hearing_aid | street_address | contract_type | accessibility_shortcoming_count_rollator | identifiers_2_namespace | address_postal_full_sv | short_description_sv | description_sv | accessibility_shortcoming_count_visually_impaired | short_description_en | description | picture_caption_en | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
54626 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma 10:30-17, ti 10:30-24, ke-to 10:30-01, pe 10:30-03, la 12-03, su 10-17", "sv": "\u00f6ppet m\u00e5n 10:30-17, tis 10:30-24, ons-tor 10:30-01, fre 10:30-03, l\u00f6r 12-03, s\u00f6n 10-17", "en": "open Mon 10:30-17, Tue 10:30-24, Wed-Thu 10:30-01, Fri 10:30-03, Sat 12-03, Sun 10-17"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [] | internal | 24209 | visithelsinki | 2669 | 0c71aa86-f76c-466b-b6f3-81143bd9eecc | 83e74666-0836-4c1d-948a-4b34a8b90301 | UNKNOWN_PRODUCTION_METHOD | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Ravintola Oiva, aitoa stadilaista ravintolakulttuuria Kalliossa jo yli 75 vuoden ajan. Arkisin Oivassa nautitaan suosittua lounasta noutopöydästä, iltakeittiö palvelee ti-la ja lauantiaisin sekä sunnuntaisin tarjolla on brunssi. Oivassa on lähes joka ilta tarjolla ohjelmaa: on karaokea, Open Stagea, live-klubia ja superbingoa. Baarin tarjonnasta löytyy mm. erinomainen olutvalikoima. | Ravintola Oiva, genuine Finnish restaurant culture since 1940. On weekdays a buffet lunch is served, a la carte in the evenings and on Saturday's and Sunday's brunch brings people together. Almost every night there is program such as karaoke, open stage or live clubs, and popular superbingo on Sunday evenings. | Ravintola Oiva | Ravintola Oiva | Porthaninkatu 5 | Porthansgatan 5 | Porthaninkatu 5 | http://www.ravintolaoiva.fi | http://www.ravintolaoiva.fi | http://www.ravintolaoiva.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 10 219 2980 | oiva@ravintolaoiva.fi | 2017-10-31T01:06:37+02:00 | 00530 | www.myhelsinki.fi | kaikki | helsinki | 2020-11-05T16:32:32.995851+02:00 | [1403] | helsinki | [2174] | [869] | {} | Point | 24.951263 | 60.18181 | Restaurang Oiva | Restaurang Oiva, äkta helsingforsisk restaurangkultur i Berghäll allt sedan 75år tillbaka. I Oiva serveras stående lunchbord, kvällstid á la carte och brunch på lördag och söndag. Nästan varje kväll finns dessutom något program, som t.ex. karaoke, open stage, live-klubbar och superbingo. |