939 rows where "last_modified_time" is on date 2018-08-07 sorted by name_fi

View and edit SQL

Suggested facets: level, keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_nurmijärvi, unit_count_municipality__unknown, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_lohja, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_hamina, unit_count_municipality_loviisa, unit_count_municipality_kotka, unit_count_municipality_mäntsälä, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, unit_count_municipality_kerava, unit_count_municipality_karkkila

unit_count_municipality_hyvinkää

last_modified_time (date)

  • 2018-08-07 · 939
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ää
1244 [] 3. luokalta alkava soveltuvuuskoepainotus lämplighetstestbetoning från årskurs 3 special emphasis starting from 3rd grade 601*2 2018-08-07T14:00:26.674416+03:00 4 1242 {} 1 1087 1 1                                                                  
1245 [] 7. luokalta alkava soveltuvuuskoepainotus lämplighetstestbetoning från årskurs 7 special emphasis starting from 7th grade 602*3 2018-08-07T14:00:26.681590+03:00 4 1242 {} 1 1087 1 1                                                                  
1306 [] A-englanti A-engelska A-English 598*4 2018-08-07T14:00:27.131698+03:00 4 1303 {} 1 1087 2 3                                                   1              
1312 [] A-ranska A-franska A-French 598*10 2018-08-07T14:00:27.175551+03:00 4 1303 {} 1 1087 1 1                                                                  
1313 [] A-saksa A-tyska A-German 598*12 2018-08-07T14:00:27.183391+03:00 4 1303 {} 1 1087 1 1                                                                  
1304 [] A-suomi A-finska A-Finnish 598*13 2018-08-07T14:00:27.116631+03:00 4 1303 {} 1 1087 3 4                                                   1              
2042 [2056, 2049] Aamu- ja iltapäivätoiminta Morgon- och eftermiddagsverksamhet Morning and afternoon activities   2018-08-07T14:00:25.343707+03:00 1 1087 {} 0 1087 208 223                                           11       4              
1335 [1343, 1336] Aikuiskoulutus Vuxenutbildning Adult education   2018-08-07T14:00:27.345252+03:00 1 1087 {} 0 1087 5 11                                           2       3     1        
1340 [] Aikuisten lukioaineiden opetus Undervisning i gymnasiets läroämnen för vuxna Education on upper secondary school subjects for adults 649 2018-08-07T14:00:27.379870+03:00 3 1336 {} 1 1087 3 3                                                                  
1346 [] Aikuisten lukioaineiden opetus Undervisning i gymnasiets läroämnen för vuxna Education on upper secondary school subjects for adults 589 2018-08-07T14:00:27.419564+03:00 3 1343 {} 1 1087 1 1                                                                  
1337 [] Aikuisten lukiokoulutus Gymnasieutbildning för vuxna Upper secondary school education for adults 650 2018-08-07T14:00:27.357192+03:00 3 1336 {} 1 1087 2 7                                           2       3              
1344 [] Aikuisten lukiokoulutus Gymnasieutbildning för vuxna Upper secondary school education for adults 590 2018-08-07T14:00:27.406024+03:00 3 1343 {} 1 1087 1 1                                                                  
1341 [] Aikuisten peruskouluaineiden opetus Undervisning i grundskolans läroämnen för vuxna Education on comprehensive school subjects for adults 651 2018-08-07T14:00:27.386151+03:00 3 1336 {} 1 1087 3 3                                                                  
1347 [] Aikuisten peruskouluaineiden opetus Undervisning i grundskolans läroämnen för vuxna Education on comprehensive school subjects for adults 591 2018-08-07T14:00:27.426296+03:00 3 1343 {} 1 1087 1 1                                                                  
1338 [] Aikuisten peruskoulutus Grundläggande utbildning för vuxna Basic education for adults 652 2018-08-07T14:00:27.364989+03:00 3 1336 {} 1 1087 3 4                                           1                      
1345 [] Aikuisten peruskoulutus Grundläggande utbildning för vuxna Basic education for adults 592 2018-08-07T14:00:27.412986+03:00 3 1343 {} 1 1087 1 1                                                                  
848 [] Aikuisten sosiaaliohjaus Socialhandledning för vuxna Social care work for adults 41 2018-08-07T14:00:28.131053+03:00 2 845 {} 0 783 6 9                                           1       2              
846 [] Aikuisten sosiaalityö Socialt arbete för vuxna Social work for adults 42 2018-08-07T14:00:28.117778+03:00 2 845 {} 0 783 21 25                                           3       1              
1001 [] Aikuisten terveyskeskuspäivystys ja päivystyspoliklinikka Hälsocentraljour och jourpoliklinik för vuxna Health centre on-call service and emergency outpatient clinic for adults 43 2018-08-07T14:00:29.242685+03:00 2 1000 {"fi": ["p\u00e4ivystys"]} 0 986   3                                           1       1     1        
527 [] Ajoneuvojen siirrot Flyttning av fordon Towing vehicles 44 2018-08-07T14:00:25.100072+03:00 3 526 {} 0 1402 2 5                                           1       2              
35 [] Akkujen keräys Återvinning av bilbatterier Car battery recycling 45 2018-08-07T14:00:21.789985+03:00 3 34 {"fi": ["akut"]} 0 1400 34 79                                           18       26     1        
1020 [] Akuuttipsykiatria Akutpsykiatri Acute psychiatry 46 2018-08-07T14:00:29.412887+03:00 2 1019 {} 0 986 1 4                                                   3              
168 [] Alkavien yrittäjien neuvonta Rådgivning för nya företagare Advice for start-up entrepreneurs 48 2018-08-07T14:00:30.339989+03:00 3 167 {} 0 1401 4 8                                           2       2              
847 [] Alueellinen kumppanuustyö Områdesvist partnerskapsarbete Regional partnership work 49 2018-08-07T14:00:28.124411+03:00 2 845 {} 0 783 19 119       1                                   1       96     1   1    
303 [304] Aluerakentaminen Områdesbyggandet Regional construction   2018-08-07T14:00:22.515802+03:00 4 302 {} 0 1400 1 1                                                                  
1381 [] Ammatillisen koulutuksen neuvonta Kundbetjäning och rådgivning (yrkesutbildning) Customer service and information (vocational education and training) 68 2018-08-07T14:00:27.686734+03:00 2 1378 {} 0 1087 3 5                                           2                      
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                      
123 [] Ammatinvalinnanohjaus Yrkesvägledning Vocational guidance 51 2018-08-07T14:00:30.001277+03:00 2 122 {} 0 1401 4 6                                           1       1              
1356 [1357] Ammattikorkeakoulut Yrkeshögskolor Polytechnics 654 2018-08-07T14:00:27.483584+03:00 1 1087 {} 0 1087 1 2                                                         1        
593 [] Ampumahiihdon harjoittelualue Träningsområde för skidskytte Training area for biathlon 52 2018-08-07T14:00:23.502563+03:00 4 592 {} 0 1403   1       1                                                          
594 [] Ampumahiihtokeskus Skidskyttecentrum Biathlon centre 53 2018-08-07T14:00:23.509751+03:00 4 592 {} 0 1403   1                                           1                      
560 [] Ampumarata Skjutbana Open-air shooting range 54 2018-08-07T14:00:23.293024+03:00 4 559 {} 0 1403   1                                           1                      
561 [] Ampumaurheilukeskus Sportskyttecentrum Shooting sports centre 55 2018-08-07T14:00:23.299465+03:00 4 559 {} 0 1403   1       1                                                          
559 [560, 561, 562, 563] Ampumaurheilupaikat Sportskytteplatser Shooting sports facilities   2018-08-07T14:00:23.287538+03:00 3 558 {} 0 1403 6 10       1                                   3                      
990 [] Apteekki Apotek Pharmacy 57 2018-08-07T14:00:29.143841+03:00 1 986 {} 0 986 1 8                                                   7              
1029 [] Apuvälinepalvelut Hjälpmedelstjänster Aid services 352 2018-08-07T14:00:29.484194+03:00 2 1028 {} 0 986 5 10                                           1       3     1        
897 [903, 898] Arabiankielinen päivähoito Arabiskspråkig dagvård Day care in Arabic 58 2018-08-07T14:00:28.436562+03:00 3 869 {} 0 1405 2 2                                                                  
307 [308, 313, 309, 310, 312] Arkistot Arkiv Archives   2018-08-07T14:00:24.657353+03:00 2 306 {} 0 1402 4 11                                           2       4     1        
308 [] Asemakaava-arkisto Detaljplanearkiv Town plan archive 60 2018-08-07T14:00:24.662512+03:00 3 307 {} 0 1402   1                                                         1        
25 [] Asiakaspalvelu Kundtjänst Customer services 62 2018-08-07T14:00:21.743023+03:00 2 24 {} 0 1400 1 2                                                   1              
223 [] Asiakaspalvelu Kundtjänst Customer services 64 2018-08-07T14:00:22.006084+03:00 3 222 {} 0 1400   3                                           1       1     1        
273 [] Asiakaspalvelu Kundtjänst Customer services 62 2018-08-07T14:00:22.333741+03:00 4 272 {} 0 1400 1 2                                                   1              
314 [319, 315, 317, 316, 2147, 2159] Asiakaspalvelu ja neuvonta Kundbetjäning och rådgivning Customer service and information   2018-08-07T14:00:24.703287+03:00 2 306 {} 0 1402 12 39                     1                     12       13     1        
371 [] Askartelu Hobbyverksamhet Hobby crafts 72 2018-08-07T14:00:22.898108+03:00 3 368 {} 0 1403 3 9                                           2       4              
2 [3, 4, 5, 7, 2191, 8] Asuminen Boende Housing   2018-08-07T14:00:21.231002+03:00 1 1400 {} 0 1400 742 1530       16   23 1       1       27   51 40       246     3 256 35 10 1 37 41    
1400 [2, 1, 14, 24, 31, 221, 85] Asuminen ja kaupunkiympäristö Boende och stadsmiljö Housing and urban environment   2018-08-07T14:00:21.224786+03:00 0   {} 0 1400 2311 4077       17 1 23 1     1 4 1     30   53 43       737     3 698 35 10 31 37 41    
3 [] Asumisen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för boendeärenden Electronic housing services and forms 74 2018-08-07T14:00:21.236014+03:00 2 2 {} 0 1400   1                     1                                            
4 [] Asumisen tuet Bostadsbidrag Housing allowances 75 2018-08-07T14:00:21.243003+03:00 2 2 {} 0 1400 3 9       1                                   2       2         1    
5 [6] Asumisoikeusasuminen Bostadsrättsbostäder Right-of-occupancy housing 76 2018-08-07T14:00:21.249052+03:00 2 2 {} 0 1400 331 1108       15   23 1               27   51 40       242     3 253 35 10   37 40    
104 [] Asumisterveys Boendehälsa Housing health 77 2018-08-07T14:00:21.579504+03:00 3 103 {} 0 1400 2 5                                 1         1       1              
1 [28, 57, 58, 59, 60, 74, 80, 73, 94, 95, 101, 97, 100, 102, 103, 115, 116] Asumisympäristö Boendemiljön Housing environment   2018-08-07T14:00:21.308151+03:00 1 1400 {} 0 1400 1002 1524                     2           2         294       218     6        
137 [] Asuntotonttien vuokraus ja myynti Uthyrning och försäljning av bostadstomter Selling or renting residential lots 78 2018-08-07T14:00:30.100472+03:00 3 134 {} 0 1401 1 3                                           1       1              
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              
7 [] Asuntotuotanto Bostadsproduktion Housing production 79 2018-08-07T14:00:21.261214+03:00 2 2 {} 0 1400 1 3                                           1       1              
271 [] Asuntotuotanto Bostadsproduktion Housing production 79 2018-08-07T14:00:22.320238+03:00 3 270 {} 0 1400 1 3                                           1       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                                                                  
2055 [] Autististen ja kehitysvammaisten ryhmät Grupper för autistiska och utvecklingsstörda Groups for autistic and mentally handicapped 656*80 2018-08-07T14:00:25.392562+03:00 3 2049 {} 1 1087 33 33                                                                  
374 [] Av- ja leirivälinelainaamo Utlåning av AV-utrustning och campingutrustning Loaning service for audiovisual and camping equipment 81 2018-08-07T14:00:22.905139+03:00 3 368 {} 0 1403 3 4                                           1                      
771 [] Avioehto Äktenskapsförord Prenuptial agreement 82 2018-08-07T14:00:30.878414+03:00 4 770 {} 0 1401 1 2                                           1                      
770 [771, 773, 774] Avioliitto ja rekisteröity parisuhde Äktenskap och registrering av partnerskap Marriage and registered partnership   2018-08-07T14:00:30.869982+03:00 3 769 {} 0 1401 1 2                                           1                      
124 [] Avoimet työpaikat Lediga jobb Open jobs 84 2018-08-07T14:00:30.009390+03:00 2 122 {} 0 1401 5 7                                           1       1              
375 [] Avoin nuorisotoiminta Öppen ungdomsverksamhet Open youth activities 85 2018-08-07T14:00:22.911924+03:00 3 368 {} 0 1403 41 78                                           22       14     1        
220 [] Avustusten sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för bidragsärenden Electronic services and forms related to benefits 87 2018-08-07T14:00:30.732707+03:00 3 219 {} 0 1401   1                                                   1              
1317 [] B-englanti B-engelska B-English 598*88 2018-08-07T14:00:27.214095+03:00 4 1303 {} 1 1087 2 2                                                                  
1318 [] B-espanja B-spanska B-Spanish 598*89 2018-08-07T14:00:27.222850+03:00 4 1303 {} 1 1087 3 4                                                   1              
1319 [] B-italia B-italienska B-Italian 598*90 2018-08-07T14:00:27.230479+03:00 4 1303 {} 1 1087 3 3                                                                  
1321 [] B-kiina B-kinesiska B-Chinese 598*92 2018-08-07T14:00:27.245446+03:00 4 1303 {} 1 1087 3 3                                                                  
1324 [] B-ranska B-franska B-French 598*95 2018-08-07T14:00:27.267203+03:00 4 1303 {} 1 1087 3 4                                                   1              
1325 [] B-saksa B-tyska B-German 598*97 2018-08-07T14:00:27.274071+03:00 4 1303 {} 1 1087 3 4                                                   1              
1315 [] B-suomi B-finska B-Finnish 598*98 2018-08-07T14:00:27.199171+03:00 4 1303 {} 1 1087 2 2                                                                  
1326 [] B-venäjä B-ryska B-Russian 598*99 2018-08-07T14:00:27.281070+03:00 4 1303 {} 1 1087 1 1                                                                  
2174 [] Baarit ja yöelämä Barer och nattliv Bars and nightlife 869 2018-08-07T14:00:24.408116+03:00 3 718 {} 0 1403 179 181                                                   2              
655 [] Beachvolleykenttä Beachvolleyplan Beach volleyball court 125 2018-08-07T14:00:23.954884+03:00 4 654 {} 0 1403 39 85                                           27       18     1        
376 [] Biljardi Biljard Billiards 126 2018-08-07T14:00:22.918484+03:00 3 368 {} 0 1403   16                                           13       3              
36 [] Bio- ja puutarhajäte Trädgårdsavfall Garden waste 127 2018-08-07T14:00:21.797808+03:00 3 34 {} 0 1400 2 4                                           1       1              
378 [] Bänditoiminta/-tila Bandverksamhet eller bandlokal Band activity or practice space 128 2018-08-07T14:00:22.924860+03:00 3 368 {} 0 1403 2 12                                           5       5              
568 [] Curlingrata Curlingbana Curling sheet 129 2018-08-07T14:00:23.345064+03:00 4 567 {} 0 1403 1 1                                                                  
756 [757, 763] Demokratia Demokrati Democracy   2018-08-07T14:00:30.749902+03:00 2 755 {} 0 1401 8 13                                           3       1     1        
381 [] Demostudio Demostudio Demo studio 130 2018-08-07T14:00:22.931253+03:00 3 368 {} 0 1403 1 2                                                   1              
2162 [] Digitaalinen nuorisotyö Digital ungdomsarbete Digital youth work 859 2018-08-07T14:00:23.214339+03:00 2 365 {} 0 1403   2                                           1       1              
775 [] Edunvalvonta Intressebevakning Trusteeship 131 2018-08-07T14:00:30.904881+03:00 3 769 {} 0 1401 1 3                                           2                      
2011 [] Ehkäisevä toimeentulotuki Förebyggande utkomststöd Preventive social assistance 840 2018-08-07T14:00:28.099014+03:00 2 839 {} 0 783 7 8                                                         1        
122 [123, 124, 126, 128, 130, 131, 132, 133, 134, 141, 146, 163, 164, 165, 166, 167] Elinkeino, työ ja verotus Näringar, arbete och beskattning Entrepreneurship, work and taxation   2018-08-07T14:00:29.995212+03:00 1 1401 {} 0 1401 322 452       2 1         1 2 1     2     2       51       62     5   1    
126 [] Elinkeinoasiat Näringslivsfrågor Trade and industry matters 132 2018-08-07T14:00:30.024180+03:00 2 122 {} 0 1401 2 2                                                                  
142 [] Elinkeinomarkkinointi Näringslivmarknadsföring Business marketing 133 2018-08-07T14:00:30.132324+03:00 3 141 {} 0 1401 2 2                                                                  
128 [] Elinkeinopalvelujen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för näringslivsservicen Electronic services and forms related to business services 135 2018-08-07T14:00:30.039148+03:00 2 122 {} 0 1401   1                     1                                            
105 [] Elintarvikevalvonta Livsmedelsbevakning Food control 137 2018-08-07T14:00:21.585963+03:00 3 103 {} 0 1400 1 4                                 1         1       1              
353 [] Elokuvateatterit Biografteater Cinemas 138 2018-08-07T14:00:22.603098+03:00 3 352 {} 0 1403 15 21                                           2       4              
14 [16, 23] Eläimet Djur Animals   2018-08-07T14:00:21.679608+03:00 1 1400 {} 0 1400 103 150                                           22       25              
106 [] Eläinlääkäripalvelut Veterinärtjänster Vet services 140 2018-08-07T14:00:21.592468+03:00 3 103 {} 0 1400 1 4                                 1         1       1              
107 [] Eläinsuojelu Djurskydd Animal protection 141 2018-08-07T14:00:21.598706+03:00 3 103 {} 0 1400 1 4                                           1       2              
721 [] Eläintarha Högholmens djurgård Helsinki Zoo 142 2018-08-07T14:00:24.428725+03:00 4 719 {} 0 1403 9 9                                                                  
719 [721, 723, 724, 725, 730] Eläintarhat Djurparker Zoos   2018-08-07T14:00:24.415879+03:00 3 718 {} 0 1403 13 14                     1                                            
552 [553, 2007] Eläinurheilualueet Anläggningar för djursport Animal sports areas   2018-08-07T14:00:23.225274+03:00 2 551 {} 0 1403 27 75                                           31       17              
130 [] Eläkkeet Pensioner Pension matters 143 2018-08-07T14:00:30.054750+03:00 2 122 {} 0 1401 4 10       1                                   2       2         1    
24 [25, 26, 27] Energia Energi Energy   2018-08-07T14:00:21.738244+03:00 1 1400 {} 0 1400 6 7                                                   1              
272 [273, 274, 275] Energia Energi Energy   2018-08-07T14:00:22.327547+03:00 3 270 {} 0 1400 6 7                                                   1              
232 [] Energia-avustukset energiunderstöd energy grants 144 2018-08-07T14:00:22.065643+03:00 3 231 {} 0 1400   1                                           1                      
37 [] Energiajäte Energiavfall Energy waste 145 2018-08-07T14:00:21.805057+03:00 3 34 {} 0 1400   1                                                   1              
26 [] Energianeuvonta Energirådgivning Energy counselling 146 2018-08-07T14:00:21.749651+03:00 2 24 {} 0 1400 1 1                                                                  

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