22 rows where unit_count_municipality_kirkkonummi = 1

View and edit SQL

Suggested facets: children, name_fi, name_sv, name_en, service_reference, level, parent, related_services, root, unit_count_municipality_helsinki, unit_count_total, unit_count_municipality_sipoo, unit_count_municipality_tuusula, unit_count_municipality_espoo, unit_count_municipality_vantaa, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, 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ää
31 [32, 33, 34, 52, 53, 54] Jätehuolto ja kierrätys Avfallshantering och återvinning Waste management and recycling   2018-08-07T14:00:21.761620+03:00 1 1400 {} 0 1400 215 572                                   1       150       186     20        
52 [] Kierrätyskeskus Återvinningscentral Recycling centre 298 2018-08-07T14:00:21.919516+03:00 2 31 {} 0 1400 3 7                                   1       1       1     1        
152 [] Juhlatilat Festlokaler Banquet facilities 214 2018-08-07T14:00:30.200626+03:00 4 149 {} 0 1401 218 249       1 1         1   1           1       10       13     3        
171 [2203, 172, 177, 178, 179, 180, 186, 187, 191, 197, 216, 219] Hallinto ja talous Förvaltning och ekonomi Administration and economy   2018-08-07T14:00:30.363012+03:00 1 1401 {} 0 1401 124 163       1                           1       17       17     2   1    
172 [173, 176, 2001, 2002] Hallinto Förvaltning Administration   2018-08-07T14:00:30.370486+03:00 2 171 {} 0 1401 59 72                                   1       3       8     1        
173 [2004, 2003, 2005] Hallinnon toimipisteet Förvaltningens verksamhetsställen Administrative offices   2018-08-07T14:00:30.377254+03:00 3 172 {} 0 1401 56 67                                   1       2       7     1        
261 [] Juhlatilat Festlokaler Banquet facilities 214 2018-08-07T14:00:22.239469+03:00 5 258 {} 0 1400 218 249       1 1         1   1           1       10       13     3        
362 [363, 364] Museot Museer Museums   2018-08-07T14:00:22.665582+03:00 2 343 {} 0 1403 64 96           1                     4 1       13       8 1     4      
364 [] Taidemuseo Konstmuseer Art museums 672 2018-08-07T14:00:22.677535+03:00 3 362 {} 0 1403 61 88           1                     4 1       10       6 1     4      
508 [] Juhlatilat Festlokaler Banquet facilities 214 2018-08-07T14:00:22.820471+03:00 3 505 {} 0 1403 218 249       1 1         1   1           1       10       13     3        
542 [543, 544, 545, 2198, 546, 2144] Satamat ja laiturit Hamn och bryggor Harbours, piers and quays   2018-08-07T14:00:25.196186+03:00 3 541 {} 0 1402 168 209       2                 1         1       36             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        
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                      
698 [] Luontotorni Naturtorn Nature observation tower 414 2018-08-07T14:00:24.259792+03:00 4 695 {} 0 1403 1 12                                   1       10                      
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        
737 [] Juhlatilat Festlokaler Banquet facilities 214 2018-08-07T14:00:24.498919+03:00 3 718 {} 0 1403 218 249       1 1         1   1           1       10       13     3        
745 [746, 747] Museot Museer Museums   2018-08-07T14:00:24.555720+03:00 3 718 {} 0 1403 64 96           1                     4 1       13       8 1     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      
749 [] Nähtävyydet Sevärdheter Sights 473 2018-08-07T14:00:24.582404+03:00 3 718 {} 0 1403 234 244                                   1       4       5              
1018 [] Röntgen Röntgen X-rays 606 2018-08-07T14:00:29.396972+03:00 1 986 {} 0 986 11 42 1 1   1   1                 2 1 1 1 1 1 1 6   1 1 6 1 1   1 1 1  
2004 [] Hallinnolliset toimipisteet Administrativa ämbetsverk Administrative offices 271 2018-08-07T14:00:30.391457+03:00 4 173 {} 0 1401 55 65                                   1       1       7     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        

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