unit
3 rows where "last_modified_time" is on date 2020-12-07
This data as json, CSV (advanced)
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20402 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 08-21, la 09-18, su 09-16", "sv": "\u00f6ppet m\u00e5n-fre 08-21, l\u00f6r 09-18, s\u00f6n 09-16", "en": "open Mon-Fri 08-21, Sat 09-18, Sun 09-16"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 57}, {"value": "false", "variable": 48}, {"value": "false", "variable": 103}, {"value": "false", "variable": 111}, {"value": "true", "variable": 117}, {"value": "true", "variable": 107}, {"value": "false", "variable": 23}, {"value": "false", "variable": 34}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 21}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 29}, {"value": "true", "variable": 113}, {"value": "true", "variable": 62}, {"value": "false", "variable": 83}, {"value": "false", "variable": 84}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 112}, {"value": "true", "variable": 114}, {"value": "at_least_3600mm", "variable": 3}, {"value": "false", "variable": 98}, {"value": "false", "variable": 92}, {"value": "under_10m", "variable": 4}, {"value": "true", "variable": 51}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 58}, {"value": "false", "variable": 53}, {"value": "false", "variable": 49}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 52}, {"value": "true", "variable": 20}, {"value": "true", "variable": 37}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 79}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 115}, {"value": "true", "variable": 5}, {"value": "false", "variable": 22}, {"value": "true", "variable": 109}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 6}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "false", "variable": 44}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "false", "variable": 116}, {"value": "true", "variable": 118}, {"value": "false", "variable": 102}, {"value": "false", "variable": 33}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 82}, {"value": "false", "variable": 38}, {"value": "2", "variable": 1}, {"v… | internal | 5739 | visithelsinki | 135 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Espoon kulttuurikeskus on monipuolisesta ohjelmistostaan sekä kahdesta upeasta salistaan tunnettu esittävän taiteen ja kulttuurielämän päänäyttämö Espoossa. Koe Tapiola Sinfoniettan konsertit, Espoon Kaupunginteatterin vierailuesitykset, April Jazz, Espoo Ciné, Kutitus, PianoEspoo, VocalEspoo ja paljon muuta! | Espoo Cultural Centre is the main scene for performing arts and cultural life in Espoo. Tapiola Sinfonietta (the Espoo city orchestra), Espoon Kaupunginteatteri (the Espoo Theatre), April Jazz Festival, Espoo Ciné Festival, PianoEspoo and VocalEspoo Festivals are on stage on a regular basis. Come and enjoy the magic of a live performance! | Espoon kulttuurikeskus | Espoo Cultural Centre | Kulttuuriaukio 2 | Kulturplatsen 2 | https://www.kulttuuriespoo.fi/fi/node/44 | https://www.kulttuuriespoo.fi/sv/node/44 | https://www.kulttuuriespoo.fi/en/node/44 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 816 5051 | espoo.kulttuurikeskus@espoo.fi | +358 9 8165 7200 | espoo.kulttuurikeskus@espoo.fi | https://www.espoo.fi/kulttuurikeskus | 2015-11-03T12:03:45+02:00 | 02100 | www.espoo.fi | kaikki | espoo | 2020-12-07T13:01:04.713362+02:00 | {"00": null, "11": "green", "12": "green", "13": "green", "21": "green", "22": "green", "23": "green", "31": "green", "32": "green", "33": "green", "41": "green", "51": "red", "52": "red", "61": "red"} | [1403] | espoo | [354, 754, 2173, 360, 752] | [868, 694, 405, 329] | {"fi": ["kulttuuri", "n\u00e4yttelytila", "amfi", "konserttisali", "kultsa", "louhisali", "l\u00e4mpi\u00f6", "tapiolan kulttuurikeskus", "tapiolan kulttuuritalo", "tapiolasali", "kulttuurikeskus", "kulttuuritalo", "elokuva", "musiikki", "teatteri"], "sv": ["amfi", "konsertsal", "kultur", "kulturcentrum", "kulturhus", "kultursal", "louhisalen", "tapiolasalen", "konsert", "film", "teater", "dans"], "en": ["music", "film", "dance", "concerts", "theatre", "culture"]} | Point | 24.80395 | 60.177708 | PL 3263, 02070 Espoon kaupunki | | Esbo kulturcentrum | Esittävän taiteen ja kulttuurielämän päänäyttämö Espoossa. | P.O. Box 3263, 02070 City of Espoo | 1 | PB 3263, 02070 Esbo stad | Esbo kulturcentrum i Hagalund är ett centrum för mångsidig kultur i Esbo. | Esbo kulturcentrum i Hagalund är ett centrum för mångsidig kultur och ett utmärkt alternativ för konferens-, mötes- och festarrangörer. Kom och bli förtrollad av levande, högklassiga kulturevenemang som bl.a. Tapiola Sinfonietta, Esbo stadsteater samt festivalerna April Jazz, Espoo Ciné, PianoEspoo, VocalEspoo och Konstkittling erbjuder. | 2 | The main scene for performing arts and cultural life in Espoo | |||||||||||||||||||||||||||
| 21431 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Harrastushaku.fi"}, "www": {"fi": "http://www.espoo.fi/fi-FI/Kulttuuri_ja_liikunta/Liikunta/Ohjattu_liikunta/Lapset_nuoret_perheet"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Nuorisoj\u00e4rjest\u00f6t ja avustukset", "sv": "Ungdomsf\u00f6reningar och underst\u00f6d"}, "www": {"fi": "https://www.espoo.fi/fi-FI/Nuoret/Yhteystiedot(756)", "sv": "https://www.esbo.fi/sv-FI/Unga/Kontaktuppgifter(7942)"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 25}, {"value": "true", "variable": 62}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 52}, {"value": "false", "variable": 33}, {"value": "true", "variable": 22}, {"value": "true", "variable": 50}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 79}, {"value": "true", "variable": 29}, {"value": "false", "variable": 31}, {"value": "handrails_on_both_sides", "variable": 32}, {"value": "true", "variable": 44}, {"value": "false", "variable": 84}, {"value": "less_than_3600mm", "variable": 3}, {"value": "no_handrails", "variable": 26}, {"value": "2", "variable": 1}, {"value": "false", "variable": 105}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 82}, {"value": "short_term_stay", "variable": 60}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 43}, {"value": "true", "variable": 20}, {"value": "true", "variable": 57}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "at_least_4_steps", "variable": 39}, {"value": "false", "variable": 48}, {"value": "no_handrails", "variable": 41}, {"value": "true", "variable": 38}, {"value": "over_20mm", "variable": 91}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "false", "variable": 98}, {"value": "false", "variable": 34}, {"value": "false", "variable": 40}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 6}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 46}, {"value": "true", "variable": 59}, {"value": "true", "variable": 51}, {"value": "false", "variable": 80}, {"value": "false", "variable": 92}, {"value": "false", "variable": 107}, {"value": "false", "variable": 28}, {"value": "at_least_4_steps", "variable": 24}, {"value": "over_10m", "variable": 4}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "true", "variable": 104}, {"value": "false", "variable": 102}, {"value": "handrails_on_both_sides", "variable": 47}, {"value": "true", "variable": … | internal | 5916 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Lasten kulttuurikeskus Aurora on iloisten kohtaamisten paikka lapsille ja aikuisille. Kolmen rakennuksen uniikki tilakokonaisuus sijaitsee erinomaisten kulkuyhteyksien varrella, lähellä hurmaavaa Träskändan kartanoa. Monenlaisiin käyttötarkoituksiin taipuvat tilat ja suojaisa pihapiiri sekä ulkolava tarjoavat upeat olosuhteet monenlaiselle tapahtumatoiminnalle aina esitystaiteesta harrastetoimintaan sekä erilaisiin taidepajoihin ja yksityistilaisuuksiin. | Children's Cultural Centre Aurora is a place of happy experiences for children and adults. This unique complex of three buildings is located close to the charming Träskända Park and Manor and has excellent transport connections. The multipurpose facilities, a courtyard surrounded by the buildings and an outdoor stage, provide a great setting for a wide range of events from performing arts to recreational activities and various art workshops and private events. | Lasten kulttuurikeskus Aurora | Children's Arts Centre Aurora | Järvenperäntie 1-3 | Träskändavägen 1-3 | Järvenperäntie 1-3 | https://www.kulttuuriespoo.fi/fi/node/907 | https://www.kulttuuriespoo.fi/sv/node/907 | https://www.kulttuuriespoo.fi/en/node/907 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8168 3364 | aurora.info@espoo.fi | 2015-11-03T12:03:45+02:00 | 02940 | www.espoo.fi | kaikki | espoo | 2020-12-07T13:01:07.508490+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1403] | espoo | [354, 355, 356, 754, 357, 2154, 752, 360] | [852, 694, 474, 405, 356, 345, 329] | {"fi": ["kirjallisuus", "kulttuuri", "kuvataide", "elokuva", "kulttuuriavustukset", "kulttuuritalot", "kulttuuritoiminta", "lastentapahtumat", "sirkus", "suomenkielinen kulttuuri", "taideharrastus", "vapaa-aika", "tanssi", "kulttuuripalvelut", "musiikki", "teatteri"], "sv": ["konstformer", "konstkurs", "kurser skol- och daghemstid", "verkst\u00e4der"], "en": ["dance", "theatre", "music", "culture"]} | Point | 24.708786 | 60.238876 | PL 94303, 02070 ESPOON KAUPUNKI | Barnkulturcentret Aurora | Lasten kulttuurikeskus Aurora on iloisten kohtaamisten paikka Espoon Järvenperässä lapsille ja aikuisille. | 7 | 6 | P.O. Box 94303, 02070 City of Espoo | 1 | 6 | PB 94303, 02070 ESBO STAD | Barnkulturcentret Aurora ligger i Träskända och är ett kulturcentrum för barn och barnfamiljer. | Barnkulturcentret Aurora är en plats för glada möten för barn och vuxna. Den unika helheten med utrymmen i tre byggnader som ligger i närheten av fantastiska Träskända park och gård nås via utmärkta transportförbindelser. Lokalerna passar för många slags aktiviteter och det skyddade gårdsområdet och friluftsscenen erbjuder en fin miljö för många slags evenemang, från föreställande konst till fritidsverksamhet, olika konstverkstäder och privata tillställningar. | 9 | Located in Järvenperä, Children's Arts Centre Aurora is a cultural centre for children and families. | ||||||||||||||||||||||||||||
| 21432 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Karatalo on suljettuna 31.5.2021 asti.", "sv": "Karahuset \u00e4r st\u00e4ngt till 31.5.2021.", "en": "Karatalo is closed until 31 May 2021."}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 25}, {"value": "over_10m", "variable": 4}, {"value": "at_least_3600mm", "variable": 3}, {"value": "true", "variable": 44}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 114}, {"value": "handrails_on_one_side", "variable": 32}, {"value": "false", "variable": 111}, {"value": "true", "variable": 92}, {"value": "true", "variable": 98}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 33}, {"value": "false", "variable": 104}, {"value": "at_least_4_steps", "variable": 24}, {"value": "false", "variable": 48}, {"value": "false", "variable": 103}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 97}, {"value": "true", "variable": 105}, {"value": "ramp_under_6m_long", "variable": 99}, {"value": "false", "variable": 53}, {"value": "true", "variable": 21}, {"value": "true", "variable": 59}, {"value": "false", "variable": 116}, {"value": "true", "variable": 57}, {"value": "1", "variable": 1}, {"value": "true", "variable": 50}, {"value": "at_least_4_steps", "variable": 93}, {"value": "handrails_on_one_side", "variable": 101}, {"value": "false", "variable": 27}, {"value": "false", "variable": 102}, {"value": "false", "variable": 106}, {"value": "false", "variable": 80}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 82}, {"value": "true", "variable": 29}, {"value": "true", "variable": 100}, {"value": "true", "variable": 28}, {"value": "true", "variable": 62}, {"value": "true", "variable": 52}, {"value": "true", "variable": 109}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 45}, {"value": "over_20mm", "variable": 56}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "true", "variable": 58}, {"value": "false", "variable": 117}, {"value": "true", "variable": 107}, {"value": "false", "variable": 46}, {"value":… | internal | 5943 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Karatalo on monipuolinen kulttuurin, taiteen ja vapaa-ajan harrastus- ja tapahtumapaikka. Karatalossa toimii myös nuorisopalvelut ja talossa on erilaisia opetus- ja toimintatiloja, joissa järjestetään mm. SVEBIn (Svenska bildningstjänster eli ruotsinkieliset sivistyspalvelut), Espoon kuvataidekoulun, Musiikkiopisto Juvenalian, Rytmimusiikkiopisto Taukon ja Omnian (Espoon työväenopisto) opetusta. Lisäksi Karatalossa harjoittelee aktiivinen joukko erilaisia harrasteryhmiä.Karatalossa huomioidaan lähiseudun asukkaiden toiveet ja laajemman yleisön kiinnostuksen kohteet. Karatalossa järjestetään toimintaa ja ohjelmaa kaikille. Karatalon kynnys on matala: osallistu, tule katsomaan ja kokeilemaan − juuri sellaisena kuin olet. | Karatalo is a diverse venue for culture, art and recreational activities. The building also houses youth services and facilities for teaching and activities. The organisations providing teaching include Swedish Education and Cultural Services, Espoo School of Art, Juvenalia Music Institute, Rhythm Music School Tauko and Omnia (Espoo Adult Education Centre). In addition, an active group of different recreational groups rehearse in Karatalo.Karatalo takes the wishes of local residents and the interests of the public at large into account. Activities and events are arranged for everyone. Karatalo is a low-threshold venue: participate, see and try your hand at a variety of activities - come as you are. | Karatalo | Karatalo | Kotkatie 4 | Örnvägen 4 | Kotkatie 4 | https://www.kulttuuriespoo.fi/fi/node/904 | https://www.kulttuuriespoo.fi/sv/node/904 | https://www.kulttuuriespoo.fi/en/node/904 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8168 2708 | 2015-11-03T12:03:45+02:00 | 02620 | www.espoo.fi | kaikki | espoo | 2020-12-07T12:31:09.130955+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} | [1403] | espoo | [354, 355, 356, 754, 357, 752, 360] | [694, 474, 405, 356, 345, 329] | {"fi": ["kirjallisuus", "kulttuuri", "kuvataide", "elokuva", "kulttuuriavustukset", "kulttuuritalot", "kulttuuritoiminta", "lastentapahtumat", "sirkus", "suomenkielinen kulttuuri", "taideharrastus", "vapaa-aika", "tanssi", "kulttuuripalvelut", "musiikki", "teatteri"], "sv": ["dans", "litteratus", "ruotsinkielinen kulttuuri", "kultur", "kulturhus", "teater"], "en": ["theatre", "culture", "film"]} | Point | 24.76183 | 60.229053 | Karabackahuset | Harrastus- ja tapahtumapaikka Karakalliossa | 2 | 5 | 1 | 1 | 5 | Fritids- och evenemangsplats i Karabacka | Karahuset är en mångsidig fritids- och evenemangsplats för kultur, konst och hobbyer. I huset finns även ungdomstjänster och olika undervisnings- och verksamhetslokaler där bland annat SVEBI (Svenska bildningstjänster), Esbo bildkonstskola, musikinstitutet Juvenalia, Rytmimusiikkiopisto Tauko och Omnia (Esbo arbetarinstitut) ordnar undervisning. Dessutom övar olika hobbygrupper i Karahuset.I Karahuset uppmärksammar vi önskemålen från områdets invånare men också det som intresserar en bredare publik. I huset ordas verksamhet och program för alla. Karatalo har en låg tröskel: delta, se och pröva - kom som du är. | 8 | A place for hobby activities and events in Karakallio |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [unit] ( [id] INTEGER PRIMARY KEY, [connections] TEXT, [accessibility_properties] TEXT, [identifiers_0_namespace] TEXT, [identifiers_0_value] TEXT, [identifiers_1_namespace] TEXT, [identifiers_1_value] TEXT, [department] TEXT, [root_department] TEXT, [provider_type] TEXT, [organizer_type] TEXT, [contract_type_id] TEXT, [contract_type_description_fi] TEXT, [contract_type_description_sv] TEXT, [contract_type_description_en] TEXT, [is_active] INTEGER, [deleted_at] TEXT, [organizer_name] TEXT, [organizer_business_id] TEXT, [picture_url] TEXT, [picture_entrance_url] TEXT, [streetview_entrance_url] TEXT, [description_fi] TEXT, [description_en] TEXT, [short_description] TEXT, [name_fi] TEXT, [name_en] TEXT, [street_address_fi] TEXT, [street_address_sv] TEXT, [street_address_en] TEXT, [www_fi] TEXT, [www_sv] TEXT, [www_en] TEXT, [address_postal_full] TEXT, [call_charge_info_fi] TEXT, [call_charge_info_sv] TEXT, [call_charge_info_en] TEXT, [picture_caption] TEXT, [phone] TEXT, [fax] TEXT, [email] TEXT, [accessibility_phone] TEXT, [accessibility_email] TEXT, [accessibility_www] TEXT, [created_time] TEXT, [address_zip] TEXT, [data_source] TEXT, [extensions_maintenance_group] TEXT, [extensions_maintenance_organization] TEXT, [last_modified_time] TEXT, [accessibility_viewpoints] TEXT, [root_service_nodes] TEXT, [municipality] TEXT, [service_nodes] TEXT, [services] TEXT, [keywords] TEXT, [location_type] TEXT, [location_coordinates_0] FLOAT, [location_coordinates_1] FLOAT, [address_postal_full_fi] TEXT, [identifiers_2_value] TEXT, [picture_caption_fi] TEXT, [call_charge_info] TEXT, [www] TEXT, [name_sv] TEXT, [short_description_fi] TEXT, [accessibility_shortcoming_count_reduced_mobility] TEXT, [accessibility_shortcoming_count_wheelchair] TEXT, [location] TEXT, [picture_caption_sv] TEXT, [accessibility_shortcoming_count_stroller] TEXT, [address_postal_full_en] TEXT, [accessibility_shortcoming_count_hearing_aid] TEXT, [street_address] TEXT, [contract_type] TEXT, [accessibility_shortcoming_count_rollator] TEXT, [identifiers_2_namespace] TEXT, [address_postal_full_sv] TEXT, [short_description_sv] TEXT, [description_sv] TEXT, [accessibility_shortcoming_count_visually_impaired] TEXT, [short_description_en] TEXT, [description] TEXT, [picture_caption_en] TEXT );