3 rows where accessibility_shortcoming_count_stroller = 2 and accessibility_shortcoming_count_wheelchair = 3

View and edit SQL

extensions_maintenance_organization

accessibility_shortcoming_count_stroller

identifiers_2_namespace

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
7214 [{"section_type": "OPENING_HOURS", "name": {"fi": "Tapaamiset ajanvarauksella.", "sv": "M\u00f6ten med tidsbokning."}, "www": null, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 112}, {"value": "true", "variable": 107}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 116}, {"value": "true", "variable": 49}, {"value": "false", "variable": 102}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "true", "variable": 40}, {"value": "false", "variable": 98}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 37}, {"value": "true", "variable": 114}, {"value": "true", "variable": 62}, {"value": "true", "variable": 58}, {"value": "true", "variable": 59}, {"value": "false", "variable": 33}, {"value": "false", "variable": 22}, {"value": "true", "variable": 82}, {"value": "true", "variable": 20}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 113}, {"value": "false", "variable": 83}, {"value": "false", "variable": 79}, {"value": "false", "variable": 44}, {"value": "true", "variable": 38}, {"value": "true", "variable": 117}, {"value": "at_least_4_steps", "variable": 39}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 115}, {"value": "true", "variable": 109}, {"value": "false", "variable": 42}, {"value": "handrails_on_one_side", "variable": 41}, {"value": "true", "variable": 52}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 6}, {"value": "false", "variable": 34}, {"value": "true", "variable": 53}, {"value": "0", "variable": 1}, {"value": "true", "variable": 50}, {"value": "false", "variable": 92}, {"value": "false", "variable": 43}, {"value": "false", "variable": 29}, {"value": "false", "variable": 111}, {"value": "true", "variable": 106}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 23}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 84}, {"value": "true", "variable": 105}, {"value": "true", "variable": 51}, {"value": "true", "variable": 57}, {"value": "true", "variable": 80}, {"value": "true", "variable": 104}, {"value": "false", "variable": 103}… internal 2786     4e610edd-18c0-4201-af4d-b1a492a14f5e 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Maa-ja kallioperäyksikkö Soil and Bedrock Unit Työpajankatu 8 Verkstadsgatan 8 Työpajankatu 8 https://www.hel.fi/helsinki/fi/asuminen-ja-ymparisto/tontit/maa-ja-kalliopera/ https://www.hel.fi/helsinki/sv/boende-och-miljo/tomter/jordmon/ https://www.hel.fi/helsinki/en/housing/plots-land-buildings/earth-bedrock/   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 22111         2008-12-01T00:00:00+02:00 00580 www.hel.fi kaikki helsinki 2020-11-14T07:30:48.133326+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"} [1400] helsinki [292, 118] [517, 516] {"fi": ["geotekninen asiantuntemus", "kalliorakennussuunnittelu", "maa- ja kallioper\u00e4tietoja suunnittelijoille ja kaupunkilaisille", "pohjarakennussuunnittelu", "pohjatutkimusten tilaukset", "pohjavesien seuranta"]} Point 24.975857 60.188583 PL 58213, 00099 Helsingin kaupunki         Enheten för jordmån och berggrund   2 3     2 P.O. Box 58213, 00099 City of Helsinki 1     3   PB 58213, 00099 Helsingfors stad     3      
8350 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma, to 09-20, ti 09-18, pe 09-16, la 10-16, suljettu ke, su", "sv": "\u00f6ppet m\u00e5n, tor 09-20, tis 09-18, fre 09-16, l\u00f6r 10-16, st\u00e4ngt ons, s\u00f6n", "en": "open Mon, Thu 09-20, Tue 09-18, Fri 09-16, Sat 10-16, closed Wed, Sun"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat", "sv": "\u00d6ppettider", "en": "Opening hours"}, "www": {"fi": "http://www.helmet.fi/kirjasto/84857/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/84857/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/84857/Contact_information/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "HIGHLIGHT", "name": {"fi": "COVID-19: Kirjastojen ohjeita epidemiakaudelle."}, "www": {"fi": "https://www.helmet.fi/fi-FI/Tapahtumat_ja_vinkit/Uutispalat/Kirjastoasioinnista_koronavirusepidemian(208997)"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Facebook", "sv": "Facebook", "en": "Facebook"}, "www": {"fi": "http://www.facebook.com/Maunulankirjasto", "sv": "http://www.facebook.com/Maunulankirjasto", "en": "http://www.facebook.com/Maunulankirjasto"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 117}, {"value": "false", "variable": 44}, {"value": "true", "variable": 76}, {"value": "false", "variable": 22}, {"value": "true", "variable": 72}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 40}, {"value": "true", "variable": 114}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 113}, {"value": "false", "variable": 116}, {"value": "false", "variable": 82}, {"value": "true", "variable": 107}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 51}, {"value": "handrails_on_one_side", "variable": 41}, {"value": "true", "variable": 5}, {"value": "true", "variable": 20}, {"value": "1", "variable": 63}, {"value": "false", "variable": 78}, {"value": "waiting_by_standing", "variable": 81}, {"value": "false", "variable": 33}, {"value": "false", "variable": 53}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 29}, {"value": "short_term_stay", "variable": 60}, {"value": "indoor_facility", "variable": 500}, {"value": "guided_and_clear", "variable": 19}, {"value": "true", "variable": 73}, {"value": "false", "variable": 83}, {"value": "0", "variable": 1}, {"value": "false", "variable": 79}, {"value": "false", "variable": 92}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 34}, {"value": "true", "variable": 38}, {"value": "false", "variable": 80}, {"value": "false", "variable": 98}, {"value": "true", "variable": 104}, {"value": "at_least_4_turning_steps", "variable": 39}, {"value": "false", "variable": 103}, {"value": "true", "variable": 50}, {"value": "false", "variable": 57}, {"value": "true", "variable": 112}, {"value": "true", "variable": 75}, {"value": "false", "variable": 48}, {"value": "false", "variable": 102}, {"value": "false", "variable": 23}, {"value": "false", "variable": 21}, {"value": "false", "variable": 49}, {"value": "true", "variable": 70}, {"value": "false", "variable": 62}, {"value": "sufficiently_wide", "variable": 18… internal 3177 kirkanta 84857 dc7d39db-b35a-4612-a921-1b7b24b0baa3 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://kirkanta.kirjastot.fi/files/photos/medium/maunula-talo-maarit-hohteri-7-5a45f00b23fa86-93126689.jpg   https://maps.google.fi/?q=http:%2F%2Fwww.hel.fi%2Fpalvelukartta%2Fkml.aspx%3Flang%3Dfi%26id%3D8350&ll=60.234341,24.933064&spn=0.00204,0.014699&layer=c&cbll=60.234342,24.933061&cbp=12,220.53,,0,-0.37&t=h&panoid=DIvoEOrnKsJDxlUNvY-z8A&z=17       Maunulan kirjasto Maunula Library Metsäpurontie 4 Skogsbäcksvägen 4 Metsäpurontie 4 http://www.helmet.fi/maunulankirjasto http://www.helmet.fi/maunulankirjasto http://www.helmet.fi/maunulankirjasto   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 85063   +358 9 310 85663 maunulan_kirjasto@hel.fi   2008-09-11T18:47:26+03:00 00630 www.hel.fi kaikki helsinki 2021-01-04T07:30:50.265048+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"} [1402, 1403] helsinki [341, 337, 338, 331, 328, 349] [813, 806, 692, 691, 483] {} Point 24.933672 60.231285 PL 63455, 00099 HELSINGIN KAUPUNKI         Månsas bibliotek   2 3     2 P.O. Box 63455, 00099 HELSINGIN KAUPUNKI 1     3   PB 63455, 00099 HELSINGIN KAUPUNKI     4      
15329 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] [{"value": "floor_1", "variable": 108}, {"value": "true", "variable": 106}, {"value": "sufficiently_wide", "variable": 18}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "true", "variable": 50}, {"value": "true", "variable": 35}, {"value": "false", "variable": 38}, {"value": "false", "variable": 84}, {"value": "false", "variable": 59}, {"value": "false", "variable": 79}, {"value": "5", "variable": 1}, {"value": "true", "variable": 105}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 20}, {"value": "true", "variable": 57}, {"value": "true", "variable": 113}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "false", "variable": 33}, {"value": "true", "variable": 114}, {"value": "true", "variable": 78}, {"value": "long_term_stay", "variable": 60}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 98}, {"value": "true", "variable": 27}, {"value": "false", "variable": 75}, {"value": "true", "variable": 107}, {"value": "true", "variable": 115}, {"value": "false", "variable": 83}, {"value": "at_least_4_steps", "variable": 24}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 102}, {"value": "at_least_3600mm", "variable": 3}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "handrails_on_one_side", "variable": 101}, {"value": "floor_0", "variable": 119}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 28}, {"value": "true", "variable": 44}, {"value": "opens_with_access_control_key", "variable": 77}, {"value": "true", "variable": 70}, {"value": "false", "variable": 103}, {"value": "true", "variable": 104}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 51}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 58}, {"value": "false", "variable": 109}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 100}, {"value": "true", "variable": 5}, {"value": "false", "… internal 4471     d8dab34f-a68f-4244-b906-84e7f651b8e1 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1             Veräjäpellon koulu on yhtenäinen peruskoulu, joka tarjoaa laadukasta perusopetusta eri-ikäisille ja eri kulttuuritaustoista tuleville oppilaille sekä mahdollistaa oppimaan oppimisen kolmiportaisen tuen kaikilla tasoilla.Veräjäpellon koulussa annetaan yleisopetusta vuosiluokilla 1-6. Lisäksi koulussamme on erityisluokkia 1-9 vuosiluokkien oppilaille, joilla on vaikea-asteinen kielellinen erityisvaikeus tai kuulovamma. Koulussa opiskelee 296 oppilasta.Koulun kasvatus- ja opetustyön tavoitteena on, että oppilaat voivat omien edellytystensä mukaan saada mahdollisimman vahvat perustaidot. Koulun sijainti Leppävaarassa tarjoaa erinomaiset mahdollisuudet liikuntaan ja ympäristön tutkimiseen.     Veräjäpellon koulu   Veräjäpellonkatu 12 Grindåkersgatan 12 Veräjäpellonkatu 12 http://www.espoo.fi/verajapellonkoulu http://www.espoo.fi/verajapellonkoulu http://www.espoo.fi/en-US/Childcare_and_education/Comprehensive_education   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8164 0380   +358 9 8164 0085 tarja.lehmonen@espoo.fi Vahtimestari 2015-11-03T12:03:45+02:00 02650 www.espoo.fi kaikki espoo 2020-03-13T09:31:04.665562+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"} [1087] espoo [1123, 1142, 1146, 1100] [661, 108, 35, 15] {"fi": ["ala-aste", "koulu"]} Point 24.806091 60.225338 PL 3106, 02070 ESPOON KAUPUNKI           Veräjäpellon koulu on yhtenäinen peruskoulu, joka tarjoaa laadukasta perusopetusta eri-ikäisille ja eri kulttuuritaustoista tuleville oppilaille. 2 3     2 P.O. Box 3106, 02070 ESPOO CITY 1     3   PB 3106, 02070 ESBO STAD     7      

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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
);