360 rows where level = 4 sorted by service_reference descending

View and edit SQL

Suggested facets: children, keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_kauniainen, last_modified_time (date)

unit_count_municipality_porvoo

level

id children name_fi name_sv name_en service_reference ▲ last_modified_time level parent keywords related_services period_enabled root unit_count_municipality_helsinki unit_count_total unit_count_municipality_hanko unit_count_municipality_raasepori unit_count_municipality_siuntio unit_count_municipality_sipoo unit_count_municipality_janakkala unit_count_municipality_nurmijärvi unit_count_municipality_salo unit_count_municipality_virolahti unit_count_municipality_pornainen unit_count_municipality_hämeenlinna unit_count_municipality__unknown unit_count_municipality_lapinjärvi unit_count_municipality_inkoo unit_count_municipality_miehikkälä unit_count_municipality_porvoo unit_count_municipality_lohja unit_count_municipality_tuusula unit_count_municipality_kirkkonummi unit_count_municipality_hamina unit_count_municipality_kouvola unit_count_municipality_loviisa unit_count_municipality_espoo unit_count_municipality_askola unit_count_municipality_kotka unit_count_municipality_mäntsälä unit_count_municipality_vantaa unit_count_municipality_hyvinkää unit_count_municipality_vihti unit_count_municipality_kauniainen unit_count_municipality_järvenpää unit_count_municipality_kerava unit_count_municipality_karkkila unit_count_municipality_pyhtää
2244 [] osapäiväryhmä halvdagsgrupp part-time day care 913*489 2020-10-02T12:00:14.017784+03:00 4 2238 {} 0 1405 1 1                                                                  
2243 [] esiopetus förskoleundervisning pre-primary education 913*160 2020-10-02T12:00:13.998958+03:00 4 2238 {} 1 1405 1 1                                                                  
2239 [] päivähoito dagvård day care 913 2020-10-02T12:00:13.926103+03:00 4 2238 {} 0 1405 1 1                                                                  
2209 [] Asukastilat Invånarlokaler Resident facilities 888 2019-10-22T09:30:10.261582+03:00 4 149 {} 0 1401 1 12                                           2       9              
2198 [] Veneiden lyhytaikainen kiinnittyminen Kortvarig förtöjning av båtar Short-term mooring of boats 881 2019-05-08T14:30:08.739155+03:00 4 542 {} 0 1402 4 4                                                                  
2199 [] Veneiden lyhytaikainen kiinnittyminen Kortvarig förtöjning av båtar Short-term mooring of boats 881 2019-05-08T14:30:08.752556+03:00 4 547 {} 0 1402 4 4                                                                  
2171 [] saamenkielinen opetus undervisning på samiska education in Sami 866 2018-08-07T14:00:25.605807+03:00 4 1109 {} 1 1087 1 1                                                                  
2170 [] saamenkielinen opetus undervisning på samiska education in Sami 865 2018-08-07T14:00:25.510062+03:00 4 1099 {} 1 1087 2 2                                                                  
2150 [] Tietotekniikkaneuvonta opiskelijoille IT rådgivning för studenter IT consultancy for students 848 2018-08-07T14:00:24.978309+03:00 4 2149 {} 0 1402   2                                           2                      
2143 [] Venekerhojen venepaikat Båtklubbarnas båtplatser Boat parking for yacht clubs 847 2018-08-07T14:00:25.248772+03:00 4 547 {} 0 1402 1 1                                                                  
2135 [] Lasten päivähoidon neuvonta Kundbetjäning och rådgivning (barndagvård) Customer service and information (child day care) 844 2018-08-07T14:00:24.729525+03:00 4 317 {} 0 1402 1 1                                                                  
771 [] Avioehto Äktenskapsförord Prenuptial agreement 82 2018-08-07T14:00:30.878414+03:00 4 770 {} 0 1401 1 2                                           1                      
665 [] Yleisurheilun harjoitusalue Träningsområde för friidrott Athletics training area 818 2018-08-07T14:00:24.033733+03:00 4 663 {} 0 1403 28 42                                           14                      
664 [] Yleisurheilukenttä Friidrottsplan Athletics field 817 2018-08-07T14:00:24.025516+03:00 4 663 {} 0 1403 8 17                                           6       3              
632 [] Yksittäinen yleisurheilun suorituspaikka Enstaka övningsplats för friidrott Stand-alone athletics venue 810 2018-08-07T14:00:23.783286+03:00 4 624 {} 0 1403 9 22                                                   12     1        
332 [] WLAN-ulkopisteet WLAN-utomhusstationer WLAN outlets 807 2018-08-07T14:00:24.889824+03:00 4 330 {} 0 1402 10 10                                                                  
331 [] WLAN-sisäpisteet WLAN-inomhusstationer WLAN inlets 806 2018-08-07T14:00:24.883321+03:00 4 330 {} 0 1402 223 230                                                   7              
155 [] Tilaussaunat Beställningsbastur Reservation-only sauna 804 2018-08-07T14:00:30.219845+03:00 4 149 {} 0 1401 1 2                                           1                      
154 [] Nuorisotilat Ungdomsgårdar Youth facilities 803 2018-08-07T14:00:30.213017+03:00 4 149 {} 0 1401   17                                           16             1        
150 [] Harrastustilat Hobbylokaler Hobby facilities 799 2018-08-07T14:00:30.186216+03:00 4 149 {} 0 1401 3 8                                           2       1     2        
275 [] Voimalaitokset Kraftverk Power plants 798 2018-08-07T14:00:22.348354+03:00 4 272 {} 0 1400 4 4                                                                  
613 [] Voimailusali Styrketräningssal Weight training hall 797 2018-08-07T14:00:23.637831+03:00 4 608 {} 0 1403 22 39                                           5       12              
959 [] esiopetus förskoleundervisning pre-primary education 795*160 2018-08-07T14:00:28.844971+03:00 4 953 {} 1 1405 1 1                                                                  
954 [] päivähoito dagvård day care 795 2018-08-07T14:00:28.802386+03:00 4 953 {} 0 1405 1 2                                           1                      
716 [] Virkistysmetsä Friluftsskog Recreational forest 791 2018-08-07T14:00:24.380867+03:00 4 706 {} 0 1403   1                     1                                            
162 [] Vihertukkutilojen vuokraus Uthyrning av lokaler för grönsaksgrossister Green wholesale trade space rental 788 2018-08-07T14:00:30.280128+03:00 4 156 {} 0 1401 1 1                                                                  
545 [] Terminaalit Terminaler Terminals 782 2018-08-07T14:00:25.217022+03:00 4 542 {} 0 1402 6 6                                                                  
249 [] Asuntotonttien vuokraus ja myynti Uthyrning och försäljning av bostadstomter Selling or renting residential lots 78 2018-08-07T14:00:22.162414+03:00 4 245 {} 0 1400 1 3                                           1       1              
683 [] Vesihiihtoalue Område för vattenskidåkning Water ski area 777 2018-08-07T14:00:24.157225+03:00 4 677 {} 0 1403 1 2                                           1                      
2144 [] Vesibussilaiturit Vattenbussbryggor Water bus platforms 776 2018-08-07T14:00:25.224191+03:00 4 542 {} 0 1402 3 3                                                                  
972 [] Venäjänkielinen ryhmäperhepäivähoito Gruppfamiljedagvård på ryska Group family day care in Russian 774 2018-08-07T14:00:28.950155+03:00 4 2145 {} 0 1405   1                                           1                      
946 [] päivähoito dagvård day care 773 2018-08-07T14:00:28.740210+03:00 4 945 {} 0 1405 5 7                                                   2              
1114 [] venäjänkielinen opetus undervisning på ryska education in Russian 772 2018-08-07T14:00:25.622338+03:00 4 1109 {} 1 1087 1 1                                                                  
1104 [] venäjänkielinen opetus undervisning på ryska education in Russian 771 2018-08-07T14:00:25.524519+03:00 4 1099 {} 1 1087 1 1                                                                  
546 [] Venesatamat Båthamnar Marinas 769 2018-08-07T14:00:25.230897+03:00 4 542 {} 0 1402 147 188       2                 1         1       36             1        
705 [] Venesatama Serviceplats för båtfarare Boating services 769 2018-08-07T14:00:24.310541+03:00 4 695 {} 0 1403 147 188       2                 1         1       36             1        
2142 [] Venesatamat Båthamnar Marinas 769 2018-08-07T14:00:25.242377+03:00 4 547 {} 0 1402 147 188       2                 1         1       36             1        
549 [] Veneiden talvisäilytys Vinterförvaring av båtar Winter storage for boats 768 2018-08-07T14:00:25.255633+03:00 4 547 {} 0 1402 1 1                                                                  
299 [] Vedenpuhdistuslaitos Vattenreningsverket Water treatment plant 766 2018-08-07T14:00:22.497732+03:00 4 293 {} 0 1400 2 2                                                                  
159 [] Varastotilojen vuokraus Uthyrning av lagerlokaler Storage space rental 765 2018-08-07T14:00:30.247429+03:00 4 156 {} 0 1401 3 4                                           1                      
2005 [] Valtuustotalot Fullmäktigehus Council buildings 744 2018-08-07T14:00:30.401425+03:00 4 173 {} 0 1401   2                                           1             1        
762 [] Valtuustoryhmät, kansalaislähetystöt Stadsfullmäktigegrupper, medborgardelegationer Council groups, public delegations 743 2018-08-07T14:00:30.809629+03:00 4 757 {} 0 1401 1 2                                                   1              
676 [] Urheiluilmailualue Område för flygsport Sport aviation area 739 2018-08-07T14:00:24.108363+03:00 4 675 {} 0 1403 1 1                                                                  
653 [] Ulkokuntoiluvälineet Konditionspark för utomhusaktiviteter Fitness training park 737 2018-08-07T14:00:23.939410+03:00 4 646 {} 0 1403 168 320                                           100       43   3 6        
574 [] Ulkokiipeilyseinä Utomhusklättervägg Open-air climbing wall 736 2018-08-07T14:00:23.381720+03:00 4 572 {} 0 1403 5 10                                           5                      
548 [] Ulkoilusaaret Friluftsöar Recreational islands 735 2018-10-25T08:00:07.487309+03:00 4 547 {} 0 1402 54 69 1     2                 1   1     1       9                      
704 [] Ulkoilumaja / hiihtomaja Friluftsstuga / skidstuga Outdoor/ski lodge 734 2018-08-07T14:00:24.303405+03:00 4 695 {} 0 1403 3 8                                           4           1          
714 [] Ulkoilualue Friluftsområde Outdoor area 733 2018-08-07T14:00:24.366593+03:00 4 706 {} 0 1403 2 24                         1         3       17           1          
689 [] Uimaranta Badstrand Supervised beach 731 2018-08-07T14:00:24.196951+03:00 4 685 {} 0 1403 13 23                                           8       2              
688 [] Uimapaikka Badplats Unsupervised beach 730 2018-08-07T14:00:24.189679+03:00 4 685 {} 0 1403 14 48                         4                 22       4   4          
693 [] Uimahalli Simhall Public indoor swimming pool 729 2018-08-07T14:00:24.224255+03:00 4 690 {} 0 1403 14 25                                           5       5     1        
692 [] Uima-allas Simbassäng Swimming pool 728 2018-08-07T14:00:24.217361+03:00 4 690 {} 0 1403 21 28                                           6       1              
703 [] Tupa Stuga Hut 721 2018-08-07T14:00:24.296823+03:00 4 695 {} 0 1403   2                                           1           1          
158 [] Tuotantotilojen vuokraus Uthyrning av produktionslokaler Production facility rental 718 2018-08-07T14:00:30.238264+03:00 4 156 {} 0 1401 3 4                                           1                      
257 [] Torimyyntipaikkojen vuokraus Uthyrning av torgförsäljningsplatser Market square vending stall rental 713 2018-08-07T14:00:22.214641+03:00 4 255 {} 0 1400 1 2                                                   1              
318 [] Sosiaali- ja terveyspalvelujen neuvonta Social- och hälsovårdstjänsternas rådgivning Social and health services information and advice 71 2018-08-07T14:00:24.764164+03:00 4 2147 {} 0 1402 1 9                     1                     1       6              
161 [] Teurastamotilojen vuokraus Uthyrning av slakterilokaler Slaughterhouse rental 706 2018-08-07T14:00:30.270249+03:00 4 156 {} 0 1401 1 1                                                                  
662 [] Tenniskenttäalue Område med tennisbanor Tennis court area 700 2018-10-25T08:00:07.016431+03:00 4 654 {"fi": ["tenniskent\u00e4t", "ulkotenniskent\u00e4t"]} 0 1403 45 83                                           11       25     2        
2136 [] Perusopetuksen neuvonta Kundbetjäning och rådgivning (grundläggande utbildning) Customer service and information (basic education) 70 2018-08-07T14:00:24.736470+03:00 4 317 {} 0 1402 1 2                                           1                      
623 [] Tennishalli Tennishall Tennis hall 699 2018-08-07T14:00:23.714268+03:00 4 614 {} 0 1403 13 23                                           7       3              
702 [] Telttailu ja leiriytyminen Tältning och läger Camping 698 2018-08-07T14:00:24.290069+03:00 4 695 {} 0 1403 2 12       1                                   8           1          
631 [] Telinevoimistelutila Utrymme för redskapsgymnastik Artistic gymnastics facility 697 2018-08-07T14:00:23.775695+03:00 4 624 {} 0 1403 6 15                                           5       4              
645 [] Tekojääkenttä Konstis Mechanically frozen open-air ice rink 695 2018-08-07T14:00:23.870223+03:00 4 639 {} 0 1403 11 25                                           10       4              
2137 [] Lukiokoulutuksen neuvonta Kundbetjäning och rådgivning (gymnasieutbildning) Customer service and information (general upper secondary education) 69 2018-08-07T14:00:24.743644+03:00 4 317 {} 0 1402 1 2                                           1                      
630 [] Tanssitila Utrymme för dans Dance studio 687 2018-08-07T14:00:23.767727+03:00 4 624 {} 0 1403 58 71                                           10       3              
687 [] Talviuintipaikka Vinterbadplats Winter swimming area 684 2018-08-07T14:00:24.182493+03:00 4 685 {} 0 1403 13 23                                           8       2              
207 [] täsmäykset avstämningar synchronisation 682 2018-08-07T14:00:30.636668+03:00 4 198 {} 0 1401 2 2                                                                  
206 [] suoritukset betalningar payments 681 2018-08-07T14:00:30.628457+03:00 4 198 {} 0 1401 2 2                                                                  
205 [] palkanlaskenta löneräkning payroll administration 680 2018-08-07T14:00:30.620039+03:00 4 198 {} 0 1401 3 3                                                                  
2138 [] Ammatillisen koulutuksen neuvonta Kundbetjäning och rådgivning (yrkesutbildning) Customer service and information (vocational education and training) 68 2018-08-07T14:00:24.750620+03:00 4 317 {} 0 1402 3 5                                           2                      
204 [] ostolaskut köpfakturor incoming invoices 679 2018-08-07T14:00:30.612437+03:00 4 198 {} 0 1401 3 3                                                                  
203 [] maksuliikenne penningrörelse payment transactions 678 2018-08-07T14:00:30.605414+03:00 4 198 {} 0 1401 2 2                                                                  
202 [] maksukattoasiat betalningstakärenden issues regarding payment limits 677 2018-08-07T14:00:30.597368+03:00 4 198 {} 0 1401 2 2                                                                  
201 [] laskutus fakturering invoicing 676 2018-08-07T14:00:30.590863+03:00 4 198 {} 0 1401 4 4                                                                  
199 [] kirjanpito bokföring accounting 675 2018-08-07T14:00:30.577311+03:00 4 198 {} 0 1401 3 3                                                                  
200 [] laskutuksen asiakasmaksut faktureringens kundavgifter customer payments for invoicing 674 2018-08-07T14:00:30.584039+03:00 4 198 {} 0 1401 4 4                                                                  
747 [] Taidemuseo Konstmuseer Art museums 672 2018-08-07T14:00:24.568656+03:00 4 745 {} 0 1403 61 88           1                     4 1       10       6 1     4      
301 [] Vesilaskut ja asiakaspalvelu Vattenfakturering och kundtjänst Billing for water and customer services 67+781 2018-10-25T08:00:06.456994+03:00 4 293 {} 0 1400 26 26                                                                  
600 [] Suunnistusalue Orienteringsområde Orienteering area 666 2018-08-07T14:00:23.551634+03:00 4 597 {} 0 1403   1                                                   1              
963 [] Suomenkielinen ryhmäperhepäivähoito Gruppfamiljedagvård på finska Group family day care in Finnish 664 2018-10-25T08:00:09.441773+03:00 4 2145 {"fi": ["suomi"]} 0 1405 50 107                                           47       9     1        
880 [] osapäiväryhmä halvdagsgrupp part-time day care 663*489 2018-08-07T14:00:28.322654+03:00 4 870 {} 0 1405 33 33                                                                  
876 [] kielikylpy ruotsi språkbad, svenska language immersion, Swedish 663*294 2018-08-07T14:00:28.297483+03:00 4 870 {} 0 1405 9 19                                           5       3     2        
877 [] kielikylpy englanti språkbad, engelska language immersion, English 663*292 2018-08-07T14:00:28.303776+03:00 4 870 {} 0 1405   2                                           2                      
872 [] iltahoito 17:30-22:00 kvällsvård 17.30-22.00 evening care 5:30pm-10:00pm 663*200 2018-08-07T14:00:28.278055+03:00 4 870 {} 0 1405 6 14                                           3       4     1        
879 [] esiopetus förskoleundervisning pre-primary education 663*160+861*160 2018-10-24T23:30:08.464088+03:00 4 870 {} 1 1405 266 448                                           66       116              
875 [] erityisryhmä specialgrupp special group 663*156 2018-08-07T14:00:28.291078+03:00 4 870 {} 0 1405 49 77                                                   28              
871 [] päivähoito dagvård day care 663 2019-03-05T14:30:09.346786+02:00 4 870 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} 0 1405 389 845                                           277       173     6        
1110 [] suomenkielinen opetus undervisning på finska education in Finnish 662 2018-10-25T08:00:07.635959+03:00 4 1109 {} 1 1087 63 114                               1           27       22 1            
2228 [] Kielirikasteinen opetus (suomi-venäjä) Språkberikande undervisning (finska-ryska) Language-enriched education (Finnish-Russian) 661*911+662*911 2020-06-22T13:30:11.090936+03:00 4 1120 {} 1 1087 1 1                                                                  
2227 [] Kielirikasteinen opetus (suomi-englanti) Språkberikande undervisning (finska-engelska) Language-enriched education (Finnish-English) 661*910+662*910 2020-06-22T13:30:11.061581+03:00 4 1120 {} 1 1087 12 12                                                                  
2233 [] Laajamittainen kaksikielinen opetus (suomi-venäjä) Omfattande undervisning på två språk (finska-ryska) Extensive bilingual education (Finnish-Russian) 661*909+662*909 2020-06-22T13:30:11.232959+03:00 4 1120 {} 1 1087 1 1                                                                  
2234 [] Laajamittainen kaksikielinen opetus (suomi-viro) Omfattande undervisning på två språk (finska-estinska) Extensive bilingual education(Finnish-Estonian) 661*908+662*908 2020-06-22T13:30:11.260046+03:00 4 1120 {} 1 1087 1 1                                                                  
2232 [] Laajamittainen kaksikielinen opetus (suomi-pohjoissaame) Omfattande undervisning på två språk (finska-nordsamiska) Extensive bilingual education (Finnish-Northern Sami) 661*907+662*907 2020-06-22T13:30:11.202979+03:00 4 1120 {} 1 1087 2 2                                                                  
2230 [] Laajamittainen kaksikielinen opetus (suomi-espanja) Omfattande undervisning på två språk (finska-spanska) Extensive bilingual education (Finnish-Spanish) 661*906+662*906 2020-06-22T13:30:11.144374+03:00 4 1120 {} 1 1087 1 1                                                                  
2231 [] Laajamittainen kaksikielinen opetus (suomi-kiina) Omfattande undervisning på två språk (finska-kinesiska) Extensive bilingual education (Finnish-Chinese) 661*905+662*905 2020-06-22T13:30:11.170697+03:00 4 1120 {} 1 1087 2 2                                                                  
2229 [] Laajamittainen kaksikielinen opetus (suomi-englanti) Omfattande undervisning på två språk (finska-engelska) Extensive bilingual education (Finnish-English) 661*904+662*904 2020-06-22T13:30:11.121789+03:00 4 1120 {} 1 1087 8 9                                           1                      
1100 [] suomenkielinen opetus undervisning på finska education in Finnish 661 2018-10-25T08:00:07.595003+03:00 4 1099 {} 1 1087 104 205                                           62       38 1            
1186 [] Autististen ja kehitysvammaisten ryhmät Grupper för autistiska och utvecklingsstörda Groups for autistic and intellectually disabled 656*80 2018-08-07T14:00:26.244278+03:00 4 1181 {} 1 1087 33 33                                                                  
1184 [] Seurakuntien ryhmät Församlingarnas grupper Groups organised by parishes 656*620 2018-08-07T14:00:26.237285+03:00 4 1181 {} 1 1087 18 18                                                                  
1182 [] Koulun järjestämät ryhmät Skolornas grupper Groups organised by schools 656*342 2018-08-07T14:00:26.208350+03:00 4 1181 {} 1 1087 28 28                                                                  

Next page

Advanced export

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

CSV options:

CREATE TABLE [service_node] (
   [id] INTEGER PRIMARY KEY,
   [children] TEXT,
   [name_fi] TEXT,
   [name_sv] TEXT,
   [name_en] TEXT,
   [service_reference] TEXT,
   [last_modified_time] TEXT,
   [level] INTEGER,
   [parent] INTEGER,
   [keywords] TEXT,
   [related_services] TEXT,
   [period_enabled] INTEGER,
   [root] INTEGER,
   [unit_count_municipality_helsinki] INTEGER,
   [unit_count_total] INTEGER,
   [unit_count_municipality_hanko] TEXT,
   [unit_count_municipality_raasepori] TEXT,
   [unit_count_municipality_siuntio] TEXT,
   [unit_count_municipality_sipoo] TEXT,
   [unit_count_municipality_janakkala] TEXT,
   [unit_count_municipality_nurmijärvi] TEXT,
   [unit_count_municipality_salo] TEXT,
   [unit_count_municipality_virolahti] TEXT,
   [unit_count_municipality_pornainen] TEXT,
   [unit_count_municipality_hämeenlinna] TEXT,
   [unit_count_municipality__unknown] TEXT,
   [unit_count_municipality_lapinjärvi] TEXT,
   [unit_count_municipality_inkoo] TEXT,
   [unit_count_municipality_miehikkälä] TEXT,
   [unit_count_municipality_porvoo] TEXT,
   [unit_count_municipality_lohja] INTEGER,
   [unit_count_municipality_tuusula] TEXT,
   [unit_count_municipality_kirkkonummi] TEXT,
   [unit_count_municipality_hamina] TEXT,
   [unit_count_municipality_kouvola] TEXT,
   [unit_count_municipality_loviisa] TEXT,
   [unit_count_municipality_espoo] INTEGER,
   [unit_count_municipality_askola] TEXT,
   [unit_count_municipality_kotka] TEXT,
   [unit_count_municipality_mäntsälä] TEXT,
   [unit_count_municipality_vantaa] INTEGER,
   [unit_count_municipality_hyvinkää] INTEGER,
   [unit_count_municipality_vihti] TEXT,
   [unit_count_municipality_kauniainen] TEXT,
   [unit_count_municipality_järvenpää] TEXT,
   [unit_count_municipality_kerava] TEXT,
   [unit_count_municipality_karkkila] TEXT,
   [unit_count_municipality_pyhtää] TEXT
);