unit
14 rows where short_description_en = "Sand field, sport events: football."
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40323 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 2.5. - 1.10.", "sv": "Perioden 2.5 - 1.10.", "en": "Period 2.5. - 1.10."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "tiimiesimies", "sv": "teamchef", "en": "manager"}, "www": null, "email": null, "phone": "+358 9 310 87503", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maaraykset-ja-ohjeet", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/allmanna-ordningsregler-for-idrottsplatser", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-sports-facilities"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 18023 | lipas | 86386 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hiekkakenttä, laji: jalkapallo.Ei valvontaa. | Sand field, sport events: football.No supervision. | Maunulankenttä / Hiekkakenttä | Maunula sports field | Maunulanmäki 5a | Månsasbacken 5a | Maunulanmäki 5a | 2014-09-05T13:29:49+03:00 | 00630 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:00.938632+02:00 | [1403] | helsinki | [659] | [495] | {} | Point | 24.931381 | 60.228367 | Månsasplanen / Bollplan | Hiekkakenttä, laji: jalkapallo. | Bollplan, grenar: fotboll. | Bollplan, grenar: fotboll.Ingen bevakning. | Sand field, sport events: football. | |||||||||||||||||||||||||||||||||||||||||||
40353 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 2.5. - 1.10.", "sv": "Perioden 2.5 - 1.10.", "en": "Period 2.5. - 1.10."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "tiimiesimies ma - to 7.00 - 15.30, pe 7.00 - 13.45", "sv": "teamchef m\u00e5 - to 7.00 - 15.30, fr 7.00 - 13.45", "en": "manager Mon - Thu 7.00 - 15.30, Fri 7.00 - 13.45"}, "www": null, "email": null, "phone": "+358 9 310 87503", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maaraykset-ja-ohjeet", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/allmanna-ordningsregler-for-idrottsplatser", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-sports-facilities"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 21164 | lipas | 84719 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hiekkakenttä, lajit: jalkapallo.Ei valvontaa. | Sand field, sport events: football.No supervision. | Punakivenkenttä / Hiekkakenttä | Punakivi sports field | Lohikäärmeenpolku 5 | Drakstigen 5 | Lohikäärmeenpolku 5 | 2014-09-05T13:29:49+03:00 | 00980 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:01.115271+02:00 | [1403] | helsinki | [659] | [495] | {} | Point | 25.14074 | 60.211636 | Rödstensplanen / Bollplan | Hiekkakenttä, lajit: jalkapallo. | Bollplan, grenar: fotboll. | Bollplan, grenar: fotboll.Ingen bevakning. | Sand field, sport events: football. | |||||||||||||||||||||||||||||||||||||||||||
40531 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 2.5. - 1.10.", "sv": "Perioden 2.5 - 1.10.", "en": "Period 2.5. - 1.10."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "tiimiesimies ma - to 7.00 - 15.30, pe 7.00 - 13.45", "sv": "teamchef m\u00e5 - to 7.00 - 15.30, fr 7.00 - 13.45", "en": "manager Mon - Thu 7.00 - 15.30, Fri 7.00 - 13.45"}, "www": null, "email": null, "phone": "+358 9 310 71513", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maaraykset-ja-ohjeet", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/allmanna-ordningsregler-for-idrottsplatser", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-sports-facilities"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 18688 | lipas | 87064 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hiekkakenttä, laji: jalkapallo.Ei valvontaa. | Sand field, sport events: football.No supervision. | Ollilankenttä / Hiekkakenttä | Ollila Sports field | Ollilantie 2e | Ollasvägen 2e | Ollilantie 2e | 2014-09-05T13:29:49+03:00 | 00780 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:02.121211+02:00 | [1403] | helsinki | [659] | [495] | {} | Point | 24.977123 | 60.259735 | Ollasplanen / Bollplan (sand) | Hiekkakenttä, laji: jalkapallo. | Bollplan, grenar: fotboll. | Bollplan, grenar: fotboll.Ingen bevakning. | Sand field, sport events: football. | |||||||||||||||||||||||||||||||||||||||||||
40532 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 2.5. - 1.10.", "sv": "Perioden 2.5 - 1.10.", "en": "Period 2.5. - 1.10."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "tiimiesimies ma - pe 7.00 - 15.15", "sv": "teamchef m\u00e5 - fr 7.00 - 15.15", "en": "manager Mon - Fri 7.00 - 15.15"}, "www": null, "email": null, "phone": "+358 9 310 87503", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maaraykset-ja-ohjeet", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/allmanna-ordningsregler-for-idrottsplatser", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-sports-facilities"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 18719 | lipas | 87041 | 8bdb8e14-b243-4a1d-b162-ad7b778c3e66 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hiekkakenttä, laji: jalkapallo. Ei valvontaa | Sand field, sport events: football.No supervision | Annalankenttä / Hiekkakenttä | Annala sports field | Valtimontie 6 | Valtimovägen 6 | Valtimontie 6 | 2014-09-05T13:29:49+03:00 | 00610 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:02.138340+02:00 | [1403] | helsinki | [659] | [495] | {} | Point | 24.968945 | 60.21375 | Annebergsplanen / Bollplan | Hiekkakenttä, laji jalkapallo. | Bollplan, grenar: fotboll. | Bollplan, grenar: fotboll.Ingen bevakning | Sand field, sport events: football. | |||||||||||||||||||||||||||||||||||||||||||
40654 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 2.5. - 1.10.", "sv": "Perioden 2.5 - 1.10.", "en": "Period 2.5. - 1.10."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "tiimiesimies", "sv": "teamchef", "en": "manager"}, "www": null, "email": null, "phone": "+358 9 310 87503", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maaraykset-ja-ohjeet", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/allmanna-ordningsregler-for-idrottsplatser", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-sports-facilities"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 18238 | lipas | 86421 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hiekkakenttä, laji: jalkapallo.Ei valvontaa. | Sand field, sport events: football.No supervision. | Malminkartanonkenttä / Hiekkakenttä | Malminkartano sports field | Naapuripellontie 10 | Naboängsvägen 10 | Naapuripellontie 10 | 2014-09-05T13:29:49+03:00 | 00390 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:02.947435+02:00 | [1403] | helsinki | [659] | [495] | {} | Point | 24.848743 | 60.24986 | Malmgårdsplanen / Bollplan (sand) | Hiekkakenttä, laji: jalkapallo. | Bollplan, grenar: fotboll. | Bollplan, grenar: fotboll.Ingen bevakning. | Sand field, sport events: football. | |||||||||||||||||||||||||||||||||||||||||||
40655 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 31.5. - 30.9.", "sv": "Perioden 31.5 - 30.9.", "en": "Period 31.5. - 30.9."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maaraykset-ja-ohjeet", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/allmanna-ordningsregler-for-idrottsplatser", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-sports-facilities"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 18265 | lipas | 74845 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hiekkakenttä, lajit: jalkapallo.Ei valvontaa. | Sand field, sport events: football.No supervision. | Suomenlinnan kenttä | Suomenlinna sports field | Susisaari, Kirkkokenttä | Vargön , Kirkkokenttä | Susisaari, Kirkkokenttä | 2014-09-05T13:29:49+03:00 | 00190 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:02.959736+02:00 | [1403] | helsinki | [665] | [818] | {} | Point | 24.982193 | 60.142673 | Sveaborgs plan | Hiekkakenttä, lajit: jalkapallo. | Bollplan, grenar: fotboll. | Bollplan, grenar: fotboll.Ingen bevakning. | Sand field, sport events: football. | |||||||||||||||||||||||||||||||||||||||||||
40684 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 2.5. - 1.10.", "sv": "Perioden 2.5 - 1.10.", "en": "Period 2.5. - 1.10."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "tiimiesimies ma - to 7.00 - 15.30, pe 7.00 - 13.45", "sv": "teamchef m\u00e5 - to 7.00 - 15.30, fr 7.00 - 13.45", "en": "manager Mon - Thu 7.00 - 15.30, Fri 7.00 - 13.45"}, "www": null, "email": null, "phone": "+358 9 310 64552", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maaraykset-ja-ohjeet", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/allmanna-ordningsregler-for-idrottsplatser", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-sports-facilities"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 20903 | lipas | 87703 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hiekkakenttä, laji: jalkapallo.Ei valvontaa. | Sand field, sport events: football.No supervision. | Landbonkenttä / Hiekkakenttä | Landbo sports field | Landbontie 26 | Landbovägen 26 | Landbontie 26 | 2014-09-05T13:29:49+03:00 | 00890 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:03.142474+02:00 | [1403] | helsinki | [659] | [495] | {} | Point | 25.197708 | 60.268383 | Landboplanen / Bollplan (sand) | Hiekkakenttä, laji: jalkapallo. | Bollplan, grenar: fotboll. | Bollplan, grenar: fotboll.Ingen bevakning. | Sand field, sport events: football. | |||||||||||||||||||||||||||||||||||||||||||
40965 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 2.5. - 1.10.", "sv": "Perioden 2.5 - 1.10.", "en": "Period 2.5. - 1.10."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "liikuntapaikanhoitajat", "sv": "anl\u00e4ggningspersonalen", "en": "facility supervisors"}, "www": null, "email": null, "phone": "+358 9 310 71534", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "tiimiesimies ma - pe 8.00 - 15.00", "sv": "teamchef m\u00e5 - fr 8.00 - 15.00", "en": "manager Mon - Fri 8.00 - 15.00"}, "www": null, "email": null, "phone": "+358 9 310 87503", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maaraykset-ja-ohjeet", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/allmanna-ordningsregler-for-idrottsplatser", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-sports-facilities"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 18768 | lipas | 87105 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hiekkakenttä, laji: jalkapallo.Ei valvontaa. | Sand field, sport events: football.No supervision. | Köökarinkenttä / Hiekkakenttä | Köökari sports field | Köökarinkuja 4 | Kökargränden 4 | Köökarinkuja 4 | 2014-09-05T13:29:49+03:00 | 00840 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:04.885784+02:00 | [1403] | helsinki | [659] | [495] | {} | Point | 25.040852 | 60.177246 | Kökarplanen / Bollplan (sand) | Hiekkakenttä, laji: jalkapallo. | Bollplan, grenar: fotboll. | Bollplan, grenar: fotboll.Ingen bevakning. | Sand field, sport events: football. | |||||||||||||||||||||||||||||||||||||||||||
41007 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 2.5. - 1.10.", "sv": "Perioden 2.5 - 1.10.", "en": "Period 2.5. - 1.10."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "liikuntapaikanhoitajat", "sv": "anl\u00e4ggningspersonalen", "en": "facility supervisors"}, "www": null, "email": null, "phone": "+358 9 310 71467", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "tiimiesimies ma - pe 7.00 - 15.30", "sv": "teamchef m\u00e5 - fr 7.00 - 15.30", "en": "manager Mon - Fri 7.00 - 15.30"}, "www": null, "email": null, "phone": "+358 9 310 87503", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maaraykset-ja-ohjeet", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/allmanna-ordningsregler-for-idrottsplatser", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-sports-facilities"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 20990 | lipas | 87040 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hiekkakenttä, laji: jalkapallo. Ei valvontaa | Sand field, sport events: football.No supervision | Akseli Toivosen kenttä / Hiekkakenttä | Akseli Toivonen sports field | Sampsantie 17a (Metsolantie 18, Pellervontie 14a) | Sampsavägen 17a (Metsolantie 18, Pellervontie 14a) | Sampsantie 17a (Metsolantie 18, Pellervontie 14a) | 2014-09-05T13:29:49+03:00 | 00610 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:05.136475+02:00 | [1403] | helsinki | [659] | [495] | {} | Point | 24.949099 | 60.214172 | Akseli Toivonens plan / Bollplan (sand) | Hiekkakenttä, laji jalkapallo. | Bollplan, grenar: fotboll. | Bollplan, grenar: fotboll.Ingen bevakning | Sand field, sport events: football. | |||||||||||||||||||||||||||||||||||||||||||
41385 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 2.5. - 1.10.", "sv": "Perioden 2.5 - 1.10.", "en": "Period 2.5. - 1.10."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "tiimiesimies", "sv": "teamchef", "en": "manager"}, "www": null, "email": null, "phone": "+358 9 310 87503", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maaraykset-ja-ohjeet", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/allmanna-ordningsregler-for-idrottsplatser", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-sports-facilities"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 18647 | lipas | 87150 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hiekkakenttä, laji: jalkapallo. Ei valvontaa | Sand field, sport events: football.No supervision | Aino Acktén kenttä / Hiekkakenttä | Aino Ackté sports field | Aino Acktén tie 16 | Aino Acktés väg 16 | Aino Acktén tie 16 | 2014-09-05T13:29:49+03:00 | 00400 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:07.136687+02:00 | [1403] | helsinki | [659] | [495] | {} | Point | 24.88923 | 60.22501 | Aino Acktés plan / Bollplan | Hiekkakenttä, laji jalkapallo. | Bollplan, grenar: fotboll. | Bollplan, grenar: fotboll.Ingen bevakning | Sand field, sport events: football. | |||||||||||||||||||||||||||||||||||||||||||
41654 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 2.5. - 1.10.", "sv": "Perioden 2.5 - 1.10.", "en": "Period 2.5. - 1.10."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "tiimiesimies", "sv": "teamchef", "en": "manager"}, "www": null, "email": null, "phone": "+358 9 310 87503", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maaraykset-ja-ohjeet", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/allmanna-ordningsregler-for-idrottsplatser", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-sports-facilities"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 11349 | lipas | 87129 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hiekkakenttä, lajit: jalkapallo.Ei valvontaa. | Sand field, sport events: football.No supervision. | Metsälänkenttä / Hiekkakenttä | Metsälä sports field | Krämertintie 8a | Krämertsvägen 8a | Krämertintie 8a | 2014-09-05T13:29:49+03:00 | 00620 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:08.625610+02:00 | [1403] | helsinki | [659] | [495] | {} | Point | 24.936716 | 60.223377 | Krämertsskogsplanen / Bollplan (sand) | Hiekkakenttä, lajit: jalkapallo. | Bollplan, grenar: fotboll. | Bollplan, grenar: fotboll.Ingen bevakning. | Sand field, sport events: football. | |||||||||||||||||||||||||||||||||||||||||||
41665 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 2.5. - 1.10.", "sv": "Perioden 2.5 - 1.10.", "en": "Period 2.5. - 1.10."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maaraykset-ja-ohjeet", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/allmanna-ordningsregler-for-idrottsplatser", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-sports-facilities"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 11512 | lipas | 87179 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hiekkakenttä, lajit: jalkapallo, pallopelit.Ei valvontaa. | Sand field, sport events: football.No supervision. | Tehtaanpuistonkenttä / Tekonurmikenttä (PPJ) | Tehtaanpuisto sports field | Sepänkatu 2 | Smedsgatan 2 | Sepänkatu 2 | 2014-09-05T13:29:49+03:00 | 00150 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:08.728223+02:00 | [1403] | helsinki | [659] | [495] | {} | Point | 24.941027 | 60.15923 | Fabrikparkenplanen / Bollplan (Konstgräs) (PPJ) | Hiekkakenttä, lajit: jalkapallo, pallopelit. | Bollplan, grenar: fotboll. | Bollplan, grenar: fotboll.Ingen bevakning. | Sand field, sport events: football. | |||||||||||||||||||||||||||||||||||||||||||
41920 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 2.5. - 1.10.", "sv": "Perioden 2.5 - 1.10.", "en": "Period 2.5. - 1.10."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maaraykset-ja-ohjeet", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/allmanna-ordningsregler-for-idrottsplatser", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-sports-facilities"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 11289 | lipas | 86394 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hiekkakenttä, lajit: jalkapallo.Ei valvontaa. | Sand field, sport events: football.No supervision. | Taivalsaarenkenttä | Taivalsaari sports field | Hiekkarannantie | Sandstrandsvägen | Hiekkarannantie | 2014-09-05T13:29:49+03:00 | 00100 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:09.986662+02:00 | [1403] | helsinki | [659] | [495] | {} | Point | 24.90847 | 60.175552 | Taivalsaarisplan | Hiekkakenttä, lajit: jalkapallo. | Bollplan, grenar: fotboll. | Bollplan, grenar: fotboll.Ingen bevakning. | Sand field, sport events: football. | |||||||||||||||||||||||||||||||||||||||||||
45146 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Kausi 2.5. - 1.10.", "sv": "Perioden 2.5 - 1.10.", "en": "Period 2.5. - 1.10."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "tiimiesimies ma - to 7.00 - 15.30, pe 7.00 - 13.45", "sv": "teamchef m\u00e5 - to 7.00 - 15.30, fr 7.00 - 13.45", "en": "manager Mon - Thu 7.00 - 15.30, Fri 7.00 - 13.45"}, "www": null, "email": null, "phone": "+358 9 310 87503", "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "J\u00e4rjestyss\u00e4\u00e4nn\u00f6t", "sv": "Ordningsregler", "en": "Rules and regulations"}, "www": {"fi": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/fi/palvelut/liikunta-ja-ulkoilu/maaraykset-ja-ohjeet", "sv": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/sv/tjanster/motion-och-friluftsliv/allmanna-ordningsregler-for-idrottsplatser", "en": "https://www.hel.fi/kulttuurin-ja-vapaa-ajan-toimiala/en/services/sports-and-recreation/rules-and-regulations-for-sports-facilities"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 16553 | lipas | 519168 | 5647f05f-5c30-43ee-9309-e0c7f75d88c9 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hiekkakenttä, lajit: jalkapallo.Ei valvontaa. | Sand field, sport events: football.No supervision. | Sakarinmäen peruskoulu / Hiekkakenttä 1 | Sakarinmäki sports field | Knutersintie 924 | Knutersvägen 924 | Knutersintie 924 | 2015-06-13T02:40:36+03:00 | 00890 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:32:17.802536+02:00 | [1403] | helsinki | [659] | [495] | {} | Point | 25.211023 | 60.26059 | Grundskolan Sakarinmäen peruskoulu / Bollplan 1 | Hiekkakenttä, lajit: jalkapallo. | Bollplan, grenar: fotboll. | Bollplan, grenar: fotboll.Ingen bevakning. | Sand field, sport events: football. |
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 );