service_node
37 rows where level = 4 and root = 1401 sorted by unit_count_municipality_kerava
This data as json, CSV (advanced)
Suggested facets: parent, unit_count_municipality_helsinki, unit_count_total, unit_count_municipality_kirkkonummi, unit_count_municipality_espoo, unit_count_municipality_vantaa, unit_count_municipality_kauniainen, last_modified_time (date)
| 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ää |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 150 | [] | Harrastustilat | Hobbylokaler | Hobby facilities | 799 | 2018-08-07T14:00:30.186216+03:00 | 4 | 149 | {} | [799] | 0 | 1401 | 3 | 8 | 2 | 1 | 2 | ||||||||||||||||||||||||||||||
| 151 | [] | Kokouspaikat | Möteslokaler | Meeting places | 326 | 2018-08-07T14:00:30.193967+03:00 | 4 | 149 | {} | [326] | 0 | 1401 | 247 | 293 | 1 | 1 | 1 | 2 | 2 | 17 | 22 | ||||||||||||||||||||||||||
| 152 | [] | Juhlatilat | Festlokaler | Banquet facilities | 214 | 2018-08-07T14:00:30.200626+03:00 | 4 | 149 | {} | [214] | 0 | 1401 | 218 | 249 | 1 | 1 | 1 | 1 | 1 | 10 | 13 | 3 | |||||||||||||||||||||||||
| 154 | [] | Nuorisotilat | Ungdomsgårdar | Youth facilities | 803 | 2018-08-07T14:00:30.213017+03:00 | 4 | 149 | {} | [803] | 0 | 1401 | 17 | 16 | 1 | ||||||||||||||||||||||||||||||||
| 155 | [] | Tilaussaunat | Beställningsbastur | Reservation-only sauna | 804 | 2018-08-07T14:00:30.219845+03:00 | 4 | 149 | {} | [804] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 157 | [] | Liike- ja toimistotilojen vuokraus | Uthyrning av affärs- och kontorslokaler | Commercial and office space rental | 393 | 2018-08-07T14:00:30.231632+03:00 | 4 | 156 | {} | [393] | 0 | 1401 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
| 158 | [] | Tuotantotilojen vuokraus | Uthyrning av produktionslokaler | Production facility rental | 718 | 2018-08-07T14:00:30.238264+03:00 | 4 | 156 | {} | [718] | 0 | 1401 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
| 159 | [] | Varastotilojen vuokraus | Uthyrning av lagerlokaler | Storage space rental | 765 | 2018-08-07T14:00:30.247429+03:00 | 4 | 156 | {} | [765] | 0 | 1401 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
| 160 | [] | Pakastamotilojen vuokraus | Uthyrning av fryslokaler | Cold storage space rental | 494 | 2018-08-07T14:00:30.257660+03:00 | 4 | 156 | {} | [494] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 161 | [] | Teurastamotilojen vuokraus | Uthyrning av slakterilokaler | Slaughterhouse rental | 706 | 2018-08-07T14:00:30.270249+03:00 | 4 | 156 | {} | [706] | 0 | 1401 | 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 | {} | [788] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 199 | [] | kirjanpito | bokföring | accounting | 675 | 2018-08-07T14:00:30.577311+03:00 | 4 | 198 | {} | [675] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 200 | [] | laskutuksen asiakasmaksut | faktureringens kundavgifter | customer payments for invoicing | 674 | 2018-08-07T14:00:30.584039+03:00 | 4 | 198 | {} | [674] | 0 | 1401 | 4 | 4 | |||||||||||||||||||||||||||||||||
| 201 | [] | laskutus | fakturering | invoicing | 676 | 2018-08-07T14:00:30.590863+03:00 | 4 | 198 | {} | [676] | 0 | 1401 | 4 | 4 | |||||||||||||||||||||||||||||||||
| 202 | [] | maksukattoasiat | betalningstakärenden | issues regarding payment limits | 677 | 2018-08-07T14:00:30.597368+03:00 | 4 | 198 | {} | [677] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 203 | [] | maksuliikenne | penningrörelse | payment transactions | 678 | 2018-08-07T14:00:30.605414+03:00 | 4 | 198 | {} | [678] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 204 | [] | ostolaskut | köpfakturor | incoming invoices | 679 | 2018-08-07T14:00:30.612437+03:00 | 4 | 198 | {} | [679] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 205 | [] | palkanlaskenta | löneräkning | payroll administration | 680 | 2018-08-07T14:00:30.620039+03:00 | 4 | 198 | {} | [680] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 206 | [] | suoritukset | betalningar | payments | 681 | 2018-08-07T14:00:30.628457+03:00 | 4 | 198 | {} | [681] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 207 | [] | täsmäykset | avstämningar | synchronisation | 682 | 2018-08-07T14:00:30.636668+03:00 | 4 | 198 | {} | [682] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 208 | [] | yleisökassa | kassa för allmänheten | public fund | 269 | 2018-08-07T14:00:30.645432+03:00 | 4 | 198 | {} | [269] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 210 | [] | antolainat | utlåning | advances | 260 | 2018-08-07T14:00:30.661409+03:00 | 4 | 209 | {} | [260] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 211 | [] | henkilöstökassa | personalkassa | personnel fund | 262 | 2018-08-07T14:00:30.669740+03:00 | 4 | 209 | {} | [262] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 213 | [] | konserniohjaus | koncernstyrning | consolidated corporation guidance | 227 | 2018-08-07T14:00:30.685091+03:00 | 4 | 209 | {} | [227] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 758 | [] | Kaupunginhallituksen ja kaupunginvaltuuston valmistelutehtävät | stadsstyrelsens och stadsförvaltningens beredningsuppgifter | preparatory assignments for City Government and City Council | 274 | 2018-08-07T14:00:30.769165+03:00 | 4 | 757 | {} | [274] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 759 | [] | Kaupunginhallitus | Stadsstyrelsen | City Board | 272 | 2018-08-07T14:00:30.780581+03:00 | 4 | 757 | {} | [272] | 0 | 1401 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
| 760 | [] | Kaupunginvaltuusto | Stadsfullmäktige | City Council | 273 | 2018-08-07T14:00:30.790348+03:00 | 4 | 757 | {} | [273] | 0 | 1401 | 2 | 5 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
| 761 | [] | Lautakunnat ja johtokunnat | Nämnder och direktioner | Committees and boards | 386 | 2018-08-07T14:00:30.800171+03:00 | 4 | 757 | {} | [386] | 0 | 1401 | 1 | 2 | 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 | {} | [743] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 764 | [] | Keskusvaalilautakunta | Centralvalnämnd | Central Election Committee | 290 | 2018-08-07T14:00:30.827173+03:00 | 4 | 763 | {} | [290] | 0 | 1401 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
| 771 | [] | Avioehto | Äktenskapsförord | Prenuptial agreement | 82 | 2018-08-07T14:00:30.878414+03:00 | 4 | 770 | {} | [82] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 773 | [] | Parisuhteen rekisteröinti | Registrering av partnerskap | Registration of partnerships | 498 | 2018-08-07T14:00:30.891417+03:00 | 4 | 770 | {} | [498] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 774 | [] | Siviilivihkiminen | Civil vigsel | Civil marriage | 628 | 2018-08-07T14:00:30.898033+03:00 | 4 | 770 | {} | [628] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 2003 | [] | Kaupungintalot | Stadshus | City halls | 270 | 2018-08-07T14:00:30.383310+03:00 | 4 | 173 | {} | [270] | 0 | 1401 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
| 2004 | [] | Hallinnolliset toimipisteet | Administrativa ämbetsverk | Administrative offices | 271 | 2018-08-07T14:00:30.391457+03:00 | 4 | 173 | {} | [271] | 0 | 1401 | 55 | 65 | 1 | 1 | 7 | 1 | |||||||||||||||||||||||||||||
| 2005 | [] | Valtuustotalot | Fullmäktigehus | Council buildings | 744 | 2018-08-07T14:00:30.401425+03:00 | 4 | 173 | {} | [744] | 0 | 1401 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 2209 | [] | Asukastilat | Invånarlokaler | Resident facilities | 888 | 2019-10-22T09:30:10.261582+03:00 | 4 | 149 | {} | [888] | 0 | 1401 | 1 | 12 | 2 | 9 |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );