2,760 rows

View and edit SQL

id ▼ origin_id ocd_id service_point_id start end modified_at type parent municipality name_fi name_sv name
5541 92-01510 ocd-division/country:fi/kunta:vantaa/postinumero:01510       2020-10-02T09:50:52.309723+03:00 postcode_area 33 vantaa 01510    
5542 92-01520 ocd-division/country:fi/kunta:vantaa/postinumero:01520       2020-10-02T09:50:52.315823+03:00 postcode_area 33 vantaa 01520    
5543 92-01530 ocd-division/country:fi/kunta:vantaa/postinumero:01530       2020-10-02T09:50:52.321425+03:00 postcode_area 33 vantaa 01530    
5544 92-01600 ocd-division/country:fi/kunta:vantaa/postinumero:01600       2020-10-02T09:50:52.326769+03:00 postcode_area 33 vantaa 01600    
5545 92-01610 ocd-division/country:fi/kunta:vantaa/postinumero:01610       2020-10-02T09:50:52.332290+03:00 postcode_area 33 vantaa 01610    
5546 92-01620 ocd-division/country:fi/kunta:vantaa/postinumero:01620       2020-10-02T09:50:52.338460+03:00 postcode_area 33 vantaa 01620    
5547 92-01630 ocd-division/country:fi/kunta:vantaa/postinumero:01630       2020-10-02T09:50:52.344216+03:00 postcode_area 33 vantaa 01630    
5548 92-01640 ocd-division/country:fi/kunta:vantaa/postinumero:01640       2020-10-02T09:50:52.351418+03:00 postcode_area 33 vantaa 01640    
5549 92-01650 ocd-division/country:fi/kunta:vantaa/postinumero:01650       2020-10-02T09:50:52.357951+03:00 postcode_area 33 vantaa 01650    
5550 92-01660 ocd-division/country:fi/kunta:vantaa/postinumero:01660       2020-10-02T09:50:52.363608+03:00 postcode_area 33 vantaa 01660    
5551 92-01670 ocd-division/country:fi/kunta:vantaa/postinumero:01670       2020-10-02T09:50:52.369707+03:00 postcode_area 33 vantaa 01670    
5552 92-01680 ocd-division/country:fi/kunta:vantaa/postinumero:01680       2020-10-02T09:50:52.375413+03:00 postcode_area 33 vantaa 01680    
5553 92-01690 ocd-division/country:fi/kunta:vantaa/postinumero:01690       2020-10-02T09:50:52.381249+03:00 postcode_area 33 vantaa 01690    
5554 92-01700 ocd-division/country:fi/kunta:vantaa/postinumero:01700       2020-10-02T09:50:52.387852+03:00 postcode_area 33 vantaa 01700    
5555 92-01710 ocd-division/country:fi/kunta:vantaa/postinumero:01710       2020-10-02T09:50:52.393826+03:00 postcode_area 33 vantaa 01710    
5556 92-01720 ocd-division/country:fi/kunta:vantaa/postinumero:01720       2020-10-02T09:50:52.401024+03:00 postcode_area 33 vantaa 01720    
5557 92-01730 ocd-division/country:fi/kunta:vantaa/postinumero:01730       2020-10-02T09:50:52.408837+03:00 postcode_area 33 vantaa 01730    
5558 92-01740 ocd-division/country:fi/kunta:vantaa/postinumero:01740       2020-10-02T09:50:52.416798+03:00 postcode_area 33 vantaa 01740    
5559 92-01750 ocd-division/country:fi/kunta:vantaa/postinumero:01750       2020-10-02T09:50:52.423573+03:00 postcode_area 33 vantaa 01750    
5560 92-01760 ocd-division/country:fi/kunta:vantaa/postinumero:01760       2020-10-02T09:50:52.430026+03:00 postcode_area 33 vantaa 01760    
5561 92-01770 ocd-division/country:fi/kunta:vantaa/postinumero:01770       2020-10-02T09:50:52.436878+03:00 postcode_area 33 vantaa 01770    
5562 49-02100 ocd-division/country:fi/kunta:espoo/postinumero:02100       2020-10-02T09:50:52.444846+03:00 postcode_area 11 espoo 02100    
5563 49-02110 ocd-division/country:fi/kunta:espoo/postinumero:02110       2020-10-02T09:50:52.451383+03:00 postcode_area 11 espoo 02110    
5564 49-02120 ocd-division/country:fi/kunta:espoo/postinumero:02120       2020-10-02T09:50:52.458904+03:00 postcode_area 11 espoo 02120    
5565 49-02130 ocd-division/country:fi/kunta:espoo/postinumero:02130       2020-10-02T09:50:52.468973+03:00 postcode_area 11 espoo 02130    
5566 49-02140 ocd-division/country:fi/kunta:espoo/postinumero:02140       2020-10-02T09:50:52.479210+03:00 postcode_area 11 espoo 02140    
5567 49-02150 ocd-division/country:fi/kunta:espoo/postinumero:02150       2020-10-02T09:50:52.486799+03:00 postcode_area 11 espoo 02150    
5568 49-02160 ocd-division/country:fi/kunta:espoo/postinumero:02160       2020-10-02T09:50:52.493684+03:00 postcode_area 11 espoo 02160    
5569 49-02170 ocd-division/country:fi/kunta:espoo/postinumero:02170       2020-10-02T09:50:52.500313+03:00 postcode_area 11 espoo 02170    
5570 49-02180 ocd-division/country:fi/kunta:espoo/postinumero:02180       2020-10-02T09:50:52.506798+03:00 postcode_area 11 espoo 02180    
5571 49-02200 ocd-division/country:fi/kunta:espoo/postinumero:02200       2020-10-02T09:50:52.513112+03:00 postcode_area 11 espoo 02200    
5572 49-02210 ocd-division/country:fi/kunta:espoo/postinumero:02210       2020-10-02T09:50:52.519523+03:00 postcode_area 11 espoo 02210    
5573 49-02230 ocd-division/country:fi/kunta:espoo/postinumero:02230       2020-10-02T09:50:52.527087+03:00 postcode_area 11 espoo 02230    
5574 49-02240 ocd-division/country:fi/kunta:espoo/postinumero:02240       2020-10-02T09:50:52.534294+03:00 postcode_area 11 espoo 02240    
5575 49-02250 ocd-division/country:fi/kunta:espoo/postinumero:02250       2020-10-02T09:50:52.541676+03:00 postcode_area 11 espoo 02250    
5576 49-02260 ocd-division/country:fi/kunta:espoo/postinumero:02260       2020-10-02T09:50:52.548028+03:00 postcode_area 11 espoo 02260    
5577 49-02270 ocd-division/country:fi/kunta:espoo/postinumero:02270       2020-10-02T09:50:52.554521+03:00 postcode_area 11 espoo 02270    
5578 49-02280 ocd-division/country:fi/kunta:espoo/postinumero:02280       2020-10-02T09:50:52.566619+03:00 postcode_area 11 espoo 02280    
5579 49-02290 ocd-division/country:fi/kunta:espoo/postinumero:02290       2020-10-02T09:50:52.573807+03:00 postcode_area 11 espoo 02290    
5580 49-02300 ocd-division/country:fi/kunta:espoo/postinumero:02300       2020-10-02T09:50:52.579606+03:00 postcode_area 11 espoo 02300    
5581 49-02320 ocd-division/country:fi/kunta:espoo/postinumero:02320       2020-10-02T09:50:52.585792+03:00 postcode_area 11 espoo 02320    
5582 49-02330 ocd-division/country:fi/kunta:espoo/postinumero:02330       2020-10-02T09:50:52.591942+03:00 postcode_area 11 espoo 02330    
5583 49-02340 ocd-division/country:fi/kunta:espoo/postinumero:02340       2020-10-02T09:50:52.597889+03:00 postcode_area 11 espoo 02340    
5584 49-02360 ocd-division/country:fi/kunta:espoo/postinumero:02360       2020-10-02T09:50:52.603809+03:00 postcode_area 11 espoo 02360    
5585 49-02380 ocd-division/country:fi/kunta:espoo/postinumero:02380       2020-10-02T09:50:52.609548+03:00 postcode_area 11 espoo 02380    
5586 49-02510 ocd-division/country:fi/kunta:espoo/postinumero:02510       2020-10-02T09:50:52.615716+03:00 postcode_area 11 espoo 02510    
5587 49-02600 ocd-division/country:fi/kunta:espoo/postinumero:02600       2020-10-02T09:50:52.622118+03:00 postcode_area 11 espoo 02600    
5588 49-02610 ocd-division/country:fi/kunta:espoo/postinumero:02610       2020-10-02T09:50:52.628867+03:00 postcode_area 11 espoo 02610    
5589 49-02620 ocd-division/country:fi/kunta:espoo/postinumero:02620       2020-10-02T09:50:52.635326+03:00 postcode_area 11 espoo 02620    
5590 49-02630 ocd-division/country:fi/kunta:espoo/postinumero:02630       2020-10-02T09:50:52.642415+03:00 postcode_area 11 espoo 02630    
5591 49-02650 ocd-division/country:fi/kunta:espoo/postinumero:02650       2020-10-02T09:50:52.650889+03:00 postcode_area 11 espoo 02650    
5592 49-02660 ocd-division/country:fi/kunta:espoo/postinumero:02660       2020-10-02T09:50:52.659467+03:00 postcode_area 11 espoo 02660    
5593 49-02680 ocd-division/country:fi/kunta:espoo/postinumero:02680       2020-10-02T09:50:52.667680+03:00 postcode_area 11 espoo 02680    
5594 49-02700 ocd-division/country:fi/kunta:espoo/postinumero:02700       2020-10-02T09:50:52.675327+03:00 postcode_area 11 espoo 02700    
5595 49-02710 ocd-division/country:fi/kunta:espoo/postinumero:02710       2020-10-02T09:50:52.682380+03:00 postcode_area 11 espoo 02710    
5596 49-02720 ocd-division/country:fi/kunta:espoo/postinumero:02720       2020-10-02T09:50:52.689020+03:00 postcode_area 11 espoo 02720    
5597 49-02730 ocd-division/country:fi/kunta:espoo/postinumero:02730       2020-10-02T09:50:52.694894+03:00 postcode_area 11 espoo 02730    
5598 49-02740 ocd-division/country:fi/kunta:espoo/postinumero:02740       2020-10-02T09:50:52.700810+03:00 postcode_area 11 espoo 02740    
5599 49-02750 ocd-division/country:fi/kunta:espoo/postinumero:02750       2020-10-02T09:50:52.707855+03:00 postcode_area 11 espoo 02750    
5600 49-02760 ocd-division/country:fi/kunta:espoo/postinumero:02760       2020-10-02T09:50:52.714690+03:00 postcode_area 11 espoo 02760    
5601 49-02770 ocd-division/country:fi/kunta:espoo/postinumero:02770       2020-10-02T09:50:52.721605+03:00 postcode_area 11 espoo 02770    
5602 49-02780 ocd-division/country:fi/kunta:espoo/postinumero:02780       2020-10-02T09:50:52.728825+03:00 postcode_area 11 espoo 02780    
5603 49-02810 ocd-division/country:fi/kunta:espoo/postinumero:02810       2020-10-02T09:50:52.736667+03:00 postcode_area 11 espoo 02810    
5604 49-02820 ocd-division/country:fi/kunta:espoo/postinumero:02820       2020-10-02T09:50:52.743566+03:00 postcode_area 11 espoo 02820    
5605 49-02860 ocd-division/country:fi/kunta:espoo/postinumero:02860       2020-10-02T09:50:52.751588+03:00 postcode_area 11 espoo 02860    
5606 49-02920 ocd-division/country:fi/kunta:espoo/postinumero:02920       2020-10-02T09:50:52.759990+03:00 postcode_area 11 espoo 02920    
5607 49-02940 ocd-division/country:fi/kunta:espoo/postinumero:02940       2020-10-02T09:50:52.767218+03:00 postcode_area 11 espoo 02940    
5608 49-02970 ocd-division/country:fi/kunta:espoo/postinumero:02970       2020-10-02T09:50:52.775276+03:00 postcode_area 11 espoo 02970    
5609 49-02980 ocd-division/country:fi/kunta:espoo/postinumero:02980       2020-10-02T09:50:52.782548+03:00 postcode_area 11 espoo 02980    
5610 92-04260 ocd-division/country:fi/kunta:vantaa/postinumero:04260       2020-10-02T09:50:52.789241+03:00 postcode_area 33 vantaa 04260    
5611 92-04320 ocd-division/country:fi/kunta:vantaa/postinumero:04320       2020-10-02T09:50:52.795324+03:00 postcode_area 33 vantaa 04320    
5612 112225.130 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112225.130 130 2021-07-01 2022-08-01 2020-12-07T13:38:54.101186+02:00 preschool_education_fi 32 helsinki Päiväkoti Luotsi    
5613 112212.297 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112212.297 297 2021-07-01 2022-08-01 2020-12-07T13:38:54.323518+02:00 preschool_education_fi 32 helsinki Päiväkoti Viskuri    
5614 112252.306 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112252.306 306 2021-07-01 2022-08-01 2020-12-07T13:38:54.334382+02:00 preschool_education_fi 32 helsinki Päiväkoti Tilhi    
5615 112249.310 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112249.310 310 2021-07-01 2022-08-01 2020-12-07T13:38:54.347127+02:00 preschool_education_fi 32 helsinki Päiväkoti Savela    
5616 112012.387 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112012.387 387 2021-07-01 2022-08-01 2020-12-07T13:38:54.496547+02:00 preschool_education_fi 32 helsinki Päiväkoti Lakka    
5617 112250.515 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112250.515 515 2021-07-01 2022-08-01 2020-12-07T13:38:54.614622+02:00 preschool_education_fi 32 helsinki Päiväkoti Kissankello    
5618 114884.539 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:114884.539 539 2021-07-01 2022-08-01 2020-12-07T13:38:54.626135+02:00 preschool_education_fi 32 helsinki Norlandia Luonnossa kotonaan Peiponpesä    
5619 112206.30033 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112206.30033 30033 2021-07-01 2022-08-01 2020-12-07T13:38:54.748405+02:00 preschool_education_fi 32 helsinki Päiväkoti Pikkutylli    
5620 112226.31059 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112226.31059 31059 2021-07-01 2022-08-01 2020-12-07T13:38:54.757870+02:00 preschool_education_fi 32 helsinki Päiväkoti Anni Lastentarha    
5621 112247.34646 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112247.34646 34646 2021-07-01 2022-08-01 2020-12-07T13:38:54.818876+02:00 preschool_education_fi 32 helsinki Päiväkoti Ankkalampi, Munkkiniemi    
5622 112254.35272 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112254.35272 35272 2021-07-01 2022-08-01 2020-12-07T13:38:54.824421+02:00 preschool_education_fi 32 helsinki Päiväkoti Taikakuu    
5623 112254.45019 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112254.45019 45019 2021-07-01 2022-08-01 2020-12-07T13:38:54.859686+02:00 preschool_education_fi 32 helsinki Päiväkoti Fallpakka    
5624 112078.48870 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112078.48870 48870 2021-07-01 2022-08-01 2020-12-07T13:38:54.890388+02:00 preschool_education_fi 32 helsinki Päiväkoti Ankkalampi Duckies Pakila    
5625 112357.51104 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112357.51104 51104 2021-07-01 2022-08-01 2020-12-07T13:38:54.905095+02:00 preschool_education_fi 32 helsinki Päiväkoti Touhula Lassila    
5626 112048.57403 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112048.57403 57403 2021-07-01 2022-08-01 2020-12-07T13:38:54.953426+02:00 preschool_education_fi 32 helsinki Päiväkoti Little Heroes International Kindergarten    
5627 112228.57507 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112228.57507 57507 2021-07-01 2022-08-01 2020-12-07T13:38:54.969918+02:00 preschool_education_fi 32 helsinki Päiväkoti Arcenciel Länsi-Pasila    
5628 112001.57866 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112001.57866 57866 2021-07-01 2022-08-01 2020-12-07T13:38:54.978179+02:00 preschool_education_fi 32 helsinki Päiväkoti Borgströminmäki    
5629 111985.58455 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:111985.58455 58455 2021-07-01 2022-08-01 2020-12-07T13:38:54.981309+02:00 preschool_education_fi 32 helsinki Päiväkoti Touhula Puistola    
5630 112254.58520 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112254.58520 58520 2021-07-01 2022-08-01 2020-12-07T13:38:54.984657+02:00 preschool_education_fi 32 helsinki Päiväkoti Touhula Kivitasku    
5631 112184.59741 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112184.59741 59741 2021-07-01 2022-08-01 2020-12-07T13:38:54.988594+02:00 preschool_education_fi 32 helsinki Päiväkoti Satulinna    
5632 112228.59878 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112228.59878 59878 2021-07-01 2022-08-01 2020-12-07T13:38:54.992115+02:00 preschool_education_fi 32 helsinki Päiväkoti Pequeño Mundo    
5633 112048.60783 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112048.60783 60783 2021-07-01 2022-08-01 2020-12-07T13:38:54.995633+02:00 preschool_education_fi 32 helsinki Päiväkoti Meri    
5634 112230.60864 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112230.60864 60864 2021-07-01 2022-08-01 2020-12-07T13:38:54.998862+02:00 preschool_education_fi 32 helsinki Päiväkoti Touhula Pitäjänmäki    
5635 112226.60869 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112226.60869 60869 2021-07-01 2022-08-01 2020-12-07T13:38:55.002096+02:00 preschool_education_fi 32 helsinki Päiväkoti Alppimaja, ryhmä Kivitaskut    
5636 112357.60870 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112357.60870 60870 2021-07-01 2022-08-01 2020-12-07T13:38:55.005700+02:00 preschool_education_fi 32 helsinki Päiväkoti Aada    
5637 112230.61887 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112230.61887 61887 2021-07-01 2022-08-01 2020-12-07T13:38:55.009103+02:00 preschool_education_fi 32 helsinki Päiväkoti Kamukoti Pitäjänmäki    
5638 112014.62933 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112014.62933 62933 2021-07-01 2022-08-01 2020-12-07T13:38:55.015603+02:00 preschool_education_fi 32 helsinki Päiväkoti Kankarepuisto    
5639 112226.63131 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112226.63131 63131 2021-07-01 2022-08-01 2020-12-07T13:38:55.018808+02:00 preschool_education_fi 32 helsinki Päiväkoti Fredriksberg    
5640 112357.63145 ocd-division/country:fi/kunta:helsinki/esiopetuksen_oppilaaksiottoalue_fi:112357.63145 63145 2021-07-01 2022-08-01 2020-12-07T13:38:55.022243+02:00 preschool_education_fi 32 helsinki Päiväkoti Laajasuo-Tonttula, ryhmä Ilkka    

Next page

Advanced export

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

CSV options:

CREATE TABLE [administrative_division] (
   [id] INTEGER PRIMARY KEY,
   [origin_id] TEXT,
   [ocd_id] TEXT,
   [service_point_id] TEXT,
   [start] TEXT,
   [end] TEXT,
   [modified_at] TEXT,
   [type] TEXT,
   [parent] INTEGER,
   [municipality] TEXT,
   [name_fi] TEXT,
   [name_sv] TEXT,
   [name] TEXT
);