Data

The data that is made available through the API now originates only from DUO. For each source the available fields are described, as well as the data they contain.

The data sources present their data aggregated on different granularities: financial data is usually aggregated to the level of the school board, whereas the number of students is available for specific locations (branch) of a school. In order to represent the data properly, the following entities are defined for different levels of education: board, school, branch. Currently there are two types of education are available, primary and secondary education (respectively in Dutch: primair onderwijs or po and voortgezet onderwijs or vo). Examples of the vo entities:

vo_board (in Dutch: schoolbestuur)
A vo_board represents the school board in secondary education. The school board is responsible for decisions about education provided at their school(s), as well as the school in general [1]. For example, the board is responsible for the financial health of its schools. Boards can be responsible for multiple schools.
vo_school (in Dutch: middelbare school)
A vo_school represents an institution where secondary education is provided to students. Data regarding the success rate at exams is aggregated at this level. A vo_school is identified by a BRIN, an identifier for schools and related institutions such as universities [2]. A school can have multiple physical locations (branches), where for example different levels of education are offered.
vo_branch (in Dutch: afdeling middelbare school)
A school can be located at different (geographical) locations. For example, large schools that offer different levels of education [3] often do so at separate buildings. These different departments are represented by a vo_branch.

A similar categorisation for schools at the primary level is available.

Additionally, there’s data available for the appropriate education collaborations (passend onderwijs):

pao_collaboration (in Dutch: samenwerkingsverband passend onderwijs)
With appropriate education schools can provide education more tailored to students who need extra support. In 2014, responsibility for part of what used to be special education moved to the collaborations for appropriate education.
po_lo_collaboration (in Dutch: samenwerkingsverband lichte ondersteuning, primair onderwijs)
Before 2014, schools were part of collaborations for light support.

Note that many fields in the DUO dataset overlap, as these data is available on all levels.

For some fields the original Dutch term is included, in order to allow the API user to look up the definition of that term at the source collection.

DUO

DUO publishes many different datasets, each of these datasets has a different “release cycle”. Some are published annually, just before the start of the new schoolyear, others are updated on a monthly basis. To group related data we introduce the notion of a “reference year”. DUO datasets that are published within the same calendar year are grouped together into a single (vo_board, vo_school or vo_branch) document. For example: DUO published the duostdstruct on October 1, 2012 and duostdres on October 2, 2012, in this case both documents are combined into a single vo_branch document with reference_year 2012. For the sake of completeness, the exact reference date of the original item is also preserved, for example in the student_residences_reference_date and students_by_structure_reference_date attributes.

Note

Currently DUO updates general information (addresses, names, phone numbers, etc.) of educational institutions on a monthly basis. Unfortunately, historical information is not provided. This means that for some reference years the API contains information such as the financial indicators and dropouts of a school, but does not include the address or name. A plausible explanation is that because of mergers or bankruptcies the school no longer exists in recent files.

DuoPoBoard

Source: Primair onderwijs - Adressen - 05. Bevoegde gezagen basisonderwijs

Field Type Original term Description
address Address   Address of this board.
correspondence_address Address   Correspondence address of this board.
board_id integer Bevoegd gezag nummer Identifier (assigned by DUO) of the board of this branch.
name string Bevoegd gezag naam Name of the board.
phone string Telefoonnummer Phone number of the board.
municipality string Gemeente The name of the municipality this board is located in.
municipality_code integer Gemeentenummer Identifier (assigned by CBS [5]) to this municipality.
administrative_office_id integer Administratiekantoor Identifier (assigned by DUO) for the accountancy firm that manages this board finances.
denomination string Denominatie In the Netherlands, schools can be based on a (religious [4]) conviction, which is denoted here.
reference_year integer Peiljaar Year the boards source file was published
website string   URL of the webpage of the board.
financial_key_indicators_per_year_reference_date date Peiljaar Date the financial key indicator source file was published at http://data.duo.nl
financial_key_indicators_per_year_url string   Financial Key Indicators Per Year Url

DuoPoBranch

Source: Primair onderwijs - Adressen - 03. Alle vestigingen basisonderwijs

Field Type Original term Description
corop_area string COROP-gebied A COROP area in the Netherlands is a region consisting of several municipalities, and is primarily used by research institutions to present statistical data.
corop_area_code integer   Identifier of the corop_area.
education_area string Onderwijsgebied Education areas are aggregations of nodal areas based on regional origins and destinations of students in secondary education.
education_area_code integer   Identifier of the education_area.
nodal_area string Nodaal gebied Area defined for the planning of distribution of secondary schools.
nodal_area_code integer   Identifier of the nodal_area.
rmc_region string Rmc-regio Area that is used for the coordination of school dropouts.
rmc_region_code integer   Identifier of the rmc_region.
rpa_area string Rpa-gebied Area defined to cluster information on the labour market.
rpa_area_code integer   Identifier of the rpa_area.
wgr_area string Wgr-gebied Cluster of municipalities per collaborating region according to the ‘Wet gemeenschappelijke regelingen’ [13].
wgr_area_code integer   Identifier of the wgr_area.
address Address   Address of this branch.
correspondence_address Address   Correspondence address of this branch.
name string   Name of the school.
branch_id integer   Identifier (assigned by DUO) of this branch.
board_id integer   Identifier (assigned by DUO) of the board of this branch.
brin string   ‘Basis Registratie Instellingen-nummer’, identifier of the school this branch belongs to. Alphanumeric, four characters long.
denomination string   In the Netherlands, schools can be based on a (religious [4]) conviction, which is denoted here.
municipality string   The name of the municipality this branch is located in.
municipality_code integer   Identifier (assigned by CBS [5]) to this municipality.
phone string   Phone number of the school.
province string   The province [6] this branch is situated in.
website string   Website of this school.
reference_year integer Peiljaar Year the schools source file was published.
ages_per_branch_by_student_weight AgesByStudentWeight   Ages Per Branch By Student Weight
ages_per_branch_by_student_weight_reference_date date   Date the ages per branch by student weight source file was published at http://data.duo.nl
ages_per_branch_by_student_weight_reference_url string   URL of the ages per branch by student weight source file.
pupils_by_origins_reference_date date   Pupils By Origins Reference Date
pupils_by_origins_reference_url string   Pupils By Origins Reference Url
pupil_residences_reference_date date   Pupil Residences Reference Date
pupil_residences_reference_url string   Pupil Residences Reference Url
weights_per_school array of weights_per_school   Weights Per School
weights_per_school_reference_date date   Weights Per School Reference Date
weights_per_school_reference_url string   Weights Per School Reference Url
student_year_reference_date date   Student Year Reference Date
student_year_reference_url string   Student Year Reference Url
spo_law string   Spo Law
spo_edu_type string   Spo Edu Type
spo_cluster integer   Spo Cluster
spo_students_by_birthyear_reference_url string   URL of the source file.
spo_students_by_birthyear_reference_date date   Date the source file was published at http://data.duo.nl
spo_students_by_birthyear array of spo_students_by_birthyear   Spo Students By Birthyear
spo_students_by_edu_type_reference_url string   URL of the source file.
spo_students_by_edu_type_reference_date date   Date the source file was published at http://data.duo.nl
spo_students_by_edu_type array of spo_students_by_edu_type   Spo Students By Edu Type
students_by_advice_reference_url string   URL of the source file.
students_by_advice_reference_date date   Date the source file was published at http://data.duo.nl
students_by_advice array of students_by_advice   Students By Advice
students_in_BRON_reference_url string   Students In Bron Reference Url
students_in_BRON_reference_date date   Students In Bron Reference Date
students_by_year array of students_by_year   Students By Year
students_by_year_reference_url string   Students By Year Reference Url
students_by_year_reference_date date   Students By Year Reference Date

DuoPoSchool

Source: Primair onderwijs - Adressen - 01. Hoofdvestigingen basisonderwijs

Field Type Original term Description
corop_area string COROP-gebied A COROP area in the Netherlands is a region consisting of several municipalities, and is primarily used by research institutions to present statistical data.
corop_area_code integer   Identifier of the corop_area.
education_area string Onderwijsgebied Education areas are aggregations of nodal areas based on regional origins and destinations of students in secondary education.
education_area_code integer   Identifier of the education_area.
nodal_area string Nodaal gebied Area defined for the planning of distribution of secondary schools.
nodal_area_code integer   Identifier of the nodal_area.
rmc_region string Rmc-regio Area that is used for the coordination of school dropouts.
rmc_region_code integer   Identifier of the rmc_region.
rpa_area string Rpa-gebied Area defined to cluster information on the labour market.
rpa_area_code integer   Identifier of the rpa_area.
wgr_area string Wgr-gebied Cluster of municipalities per collaborating region according to the ‘Wet gemeenschappelijke regelingen’ [13].
wgr_area_code integer   Identifier of the wgr_area.
address Address   Address of this school.
correspondence_address Address   Correspondence address of this school.
board_id integer Bevoegd gezag nummer Identifier (assigned by DUO) of the board of this school.
brin string   ‘Basis Registratie Instellingen-nummer’, identifier of the school this branch belongs to. Alphanumeric, four characters long.
denomination string   In the Netherlands, schools can be based on a (religious [4]) conviction, which is denoted here.
municipality string   The name of the municipality this branch is located in.
municipality_code integer   Identifier (assigned by CBS [5]) to this municipality.
name string   Name of the school.
phone string   Phone number of the school.
province string   The province [6] this branch is situated in.
reference_year integer Peiljaar Year the schools source file was published.
website string   Website of this school.
spo_students_per_cluster array of spo_students_per_cluster   Spo Students Per Cluster
spo_students_per_cluster_reference_date date   Date the source file was published at http://data.duo.nl
spo_students_per_cluster_reference_url string   URL of the source file.
po_lo_collaboration_reference_url string   Po Lo Collaboration Reference Url
po_lo_collaboration_reference_date date   Po Lo Collaboration Reference Date
po_lo_collaboration string   Po Lo Collaboration
pao_collaboration_reference_url string   Pao Collaboration Reference Url
pao_collaboration_reference_date date   Pao Collaboration Reference Date
pao_collaboration string   Pao Collaboration

DuoVoBoard

Source: Voortgezet onderwijs - Adressen - 03. Adressen hoofdbesturen

Field Type Original term Description
address Address   Address of this board.
correspondence_address Address   Correspondence address of this board.
board_id integer   Identifier (assigned by DUO) of the board of this branch.
name string   Name of the board.
phone string   Phone number of the board.
municipality string   The name of the municipality this board is located in.
municipality_code integer   Identifier (assigned by CBS [5]) to this municipality.
administrative_office_id integer Administratiekantoor Identifier (assigned by DUO) for the accountancy firm that manages this board finances.
denomination string   In the Netherlands, schools can be based on a (religious [4]) conviction, which is denoted here.
financial_key_indicators_per_year_reference_date date Peiljaar Date the financial key indicator source file was published at http://data.duo.nl
reference_year integer Peiljaar Year the boards source file was published
website string   URL of the webpage of the board.
vavo_students_reference_url string   Vavo Students Reference Url
vavo_students_reference_date date   Vavo Students Reference Date
vavo_students array of vavo_students   Vavo Students

DuoVoBranch

Field Type Original term Description
corop_area string COROP-gebied A COROP area in the Netherlands is a region consisting of several municipalities, and is primarily used by research institutions to present statistical data.
corop_area_code integer   Identifier of the corop_area.
education_area string Onderwijsgebied Education areas are aggregations of nodal areas based on regional origins and destinations of students in secondary education.
education_area_code integer   Identifier of the education_area.
nodal_area string Nodaal gebied Area defined for the planning of distribution of secondary schools.
nodal_area_code integer   Identifier of the nodal_area.
rmc_region string Rmc-regio Area that is used for the coordination of school dropouts.
rmc_region_code integer   Identifier of the rmc_region.
rpa_area string Rpa-gebied Area defined to cluster information on the labour market.
rpa_area_code integer   Identifier of the rpa_area.
wgr_area string Wgr-gebied Cluster of municipalities per collaborating region according to the ‘Wet gemeenschappelijke regelingen’ [13].
wgr_area_code integer   Identifier of the wgr_area.
address Address   Address of this branch.
correspondence_address Address   Correspondence address of this branch.
name string   Name of the school.
branch_id integer   Identifier (assigned by DUO) of this branch.
board_id integer   Identifier (assigned by DUO) of the board of this branch.
brin string   ‘Basis Registratie Instellingen-nummer’, identifier of the school this branch belongs to. Alphanumeric, four characters long.
denomination string   In the Netherlands, schools can be based on a (religious [4]) conviction, which is denoted here.
structure array of structure (String)   Structure
municipality string   The name of the municipality this branch is located in.
municipality_code integer   Identifier (assigned by CBS [5]) to this municipality.
phone string   Phone number of the school.
province string   The province [6] this branch is situated in.
reference_year integer Peiljaar Year the schools source file was published.
website string   Website of this school.
vavo_students_reference_url string   Vavo Students Reference Url
vavo_students_reference_date date   Vavo Students Reference Date
vavo_students array of vavo_students   Vavo Students
students_by_finegrained_structure_reference_url string   Students By Finegrained Structure Reference Url
students_by_finegrained_structure_reference_date date   Students By Finegrained Structure Reference Date
students_by_finegrained_structure array of students_by_finegrained_structure   Students By Finegrained Structure
graduation array of graduation Examenkandidaten en geslaagden Graduation
graduations_reference_date date Peildatum Date the graduations source file was published at http://data.duo.nl
student_residence array of student_residence   Student Residence
student_residences_reference_date date Peildatum Date the student residences source file was published at http://data.duo.nl
students_by_structure array of students_by_structure   Students By Structure
students_by_structure_reference_date date   Students By Structure Reference Date
students_by_structure_url string   Students By Structure Url
exam_grades GradesPerCourse   Exam Grades
exam_grades_reference_date date   Exam Grades Reference Date
exam_grades_reference_url string   Exam Grades Reference Url
vmbo_exam_grades_per_course GradesPerCourse   Vmbo Exam Grades Per Course
vmbo_exam_grades_reference_date date   Vmbo Exam Grades Reference Date
vmbo_exam_grades_reference_url string   Vmbo Exam Grades Reference Url
havo_exam_grades_per_course GradesPerCourse   Havo Exam Grades Per Course
havo_exam_grades_reference_date date   Havo Exam Grades Reference Date
havo_exam_grades_reference_url string   Havo Exam Grades Reference Url
vwo_exam_grades_per_course GradesPerCourse   Vwo Exam Grades Per Course
vwo_exam_grades_reference_date date   Vwo Exam Grades Reference Date
vwo_exam_grades_reference_url string   Vwo Exam Grades Reference Url

DuoVoSchool

Field Type Original term Description
corop_area string COROP-gebied A COROP area in the Netherlands is a region consisting of several municipalities, and is primarily used by research institutions to present statistical data.
corop_area_code integer   Identifier of the corop_area.
education_area string Onderwijsgebied Education areas are aggregations of nodal areas based on regional origins and destinations of students in secondary education.
education_area_code integer   Identifier of the education_area.
nodal_area string Nodaal gebied Area defined for the planning of distribution of secondary schools.
nodal_area_code integer   Identifier of the nodal_area.
rmc_region string Rmc-regio Area that is used for the coordination of school dropouts.
rmc_region_code integer   Identifier of the rmc_region.
rpa_area string Rpa-gebied Area defined to cluster information on the labour market.
rpa_area_code integer   Identifier of the rpa_area.
wgr_area string Wgr-gebied Cluster of municipalities per collaborating region according to the ‘Wet gemeenschappelijke regelingen’ [13].
wgr_area_code integer   Identifier of the wgr_area.
address Address   Address of this school.
correspondence_address Address   Correspondence address of this school.
board_id integer   Identifier (assigned by DUO) of the board of this school.
brin string   ‘Basis Registratie Instellingen-nummer’, identifier of the school this branch belongs to. Alphanumeric, four characters long.
denomination string   In the Netherlands, schools can be based on a (religious [4]) conviction, which is denoted here.
structure array of structure (String)   Structure
municipality string   The name of the municipality this branch is located in.
municipality_code integer   Identifier (assigned by CBS [5]) to this municipality.
phone string   Phone number of the school.
province string   The province [6] this branch is situated in.
reference_year integer Peiljaar Year the schools source file was published.
website string   Website of this school.
students_prognosis array of students_prognosis   Students Prognosis
students_prognosis_reference_date date Peildatum Date the source file was published at http://data.duo.nl
students_prognosis_url string   Students Prognosis Url
vo_lo_collaboration_reference_url string   Vo Lo Collaboration Reference Url
vo_lo_collaboration_reference_date date   Vo Lo Collaboration Reference Date
vo_lo_collaboration string   Vo Lo Collaboration
pao_collaboration_reference_url string   Pao Collaboration Reference Url
pao_collaboration_reference_date date   Pao Collaboration Reference Date
pao_collaboration string   Pao Collaboration
dropout array of dropout   Dropout
dropouts_reference_date date   Dropouts Reference Date

DuoPaoCollaboration

Source: Passend onderwijs - Adressen - 01. Adressen samenwerkingsverbanden lichte ondersteuning primair onderwijs

Field Type Original term Description
address Address   Address of this collaboration.
correspondence_address Address   Correspondence address of this collaboration.
collaboration_id string Administratienummer Identification number of collaboration
reference_year integer   Reference Year

DuoMboBoard

Source: Middelbaar beroepsonderwijs - Adressen - 02. Adressen bevoegde gezagen

Field Type Original term Description
address Address   Address of this board.
administrative_office_id integer   Identifier (assigned by DUO) for the accountancy firm that manages this board finances.
board_id integer   Identifier (assigned by DUO) of this board.
correspondence_address Address   Correspondence address of this board.
denomination string   Denomination
municipality string   Municipality
municipality_code integer   Municipality Code
name string   Name of the board.
phone string   Phone number of the board.
website string   Website of this board.

DuoMboInstitution

Source: Middelbaar beroepsonderwijs - Adressen - 01. Adressen instellingen

Field Type Original term Description
corop_area string COROP-gebied A COROP area in the Netherlands is a region consisting of several municipalities, and is primarily used by research institutions to present statistical data.
corop_area_code integer   Identifier of the corop_area.
education_area string Onderwijsgebied Education areas are aggregations of nodal areas based on regional origins and destinations of students in secondary education.
education_area_code integer   Identifier of the education_area.
nodal_area string Nodaal gebied Area defined for the planning of distribution of secondary schools.
nodal_area_code integer   Identifier of the nodal_area.
rmc_region string Rmc-regio Area that is used for the coordination of school dropouts.
rmc_region_code integer   Identifier of the rmc_region.
rpa_area string Rpa-gebied Area defined to cluster information on the labour market.
rpa_area_code integer   Identifier of the rpa_area.
wgr_area string Wgr-gebied Cluster of municipalities per collaborating region according to the ‘Wet gemeenschappelijke regelingen’ [13].
wgr_area_code integer   Identifier of the wgr_area.
brin string   ‘Basis Registratie Instellingen-nummer’, identifier of the institution. Alphanumeric, four characters long.
board_id integer   Identifier (assigned by DUO) of the board of this institution.
correspondence_address Address   Correspondence address of this institution.
denomination string   Denomination
municipality string   Municipality
municipality_code integer   Municipality Code
address Address   Address of this institution.
name string   Name of the institution.
phone string   Phone number of the institution.
mbo_institution_kind string   Mbo Institution Kind
mbo_institution_kind_code string   Mbo Institution Kind Code
website string   Website of this institution.
qualifications array of qualifications   Qualifications
qualifications_reference_url string   Qualifications Reference Url
qualifications_reference_date date   Qualifications Reference Date
participants_per_qualification array of participants_per_qualification   Participants Per Qualification
participants_per_qualification_reference_url string   URL of the source file.
participants_per_qualification_reference_date date   Date the source file was published at http://data.duo.nl
participants_per_grade_year_and_qualification array of participants_per_grade_year_and_qualification   Participants Per Grade Year And Qualification
participants_per_grade_year_and_qualification_reference_url string   URL of the source file.
participants_per_grade_year_and_qualification_reference_date date   Date the source file was published at http://data.duo.nl
graduates_per_qualification array of graduates_per_qualification   Graduates Per Qualification
graduates_per_qualification_reference_url string   URL of the source file.
graduates_per_qualification_reference_date date   Date the source file was published at http://data.duo.nl

Address

Field Type Original term Description
street string   Street name and number of the address of this branch.
city string   Name of the city or village this branch is located.
zip_code string   Zip code of the address of this branch. A Dutch zip code consists of four digits, a space and two letters (1234 AB) [7]. For normalisation purposes, the whitespace is removed.
geo_location Coordinates   Latitude/longitude coordinates of this address.
geo_viewport Viewport   Latitude/longitude coordinates of the viewport for this address
formatted_address string   Normalised address as returned by the BAG42 geocoding API [20].
address_component array of address_component   Address Component

address_component

Source: BAG42 Geocoding service

Field Type Original term Description
long_name string   Full name of this component. (i.e. ‘Nederland’)
short_name string   Abbreviated form (if applicable) of the long_name. (i.e. ‘NL’)
address_type array of address_type (String)   Address Type

AgesByStudentWeight

This dict has three keys student_weight_0_0, student_weight_0_3 and student_weight_1_2, the weights are based on the pupil’s parents level of education [23].

Source: Primair onderwijs - Leerlingen - 03. Leerlingen basisonderwijs naar leerlinggewicht en leeftijd

Field Type Original term Description
student_weight_0_0 StudentsByAge   Student Weight 0 0
student_weight_0_3 StudentsByAge   Student Weight 0 3
student_weight_1_2 StudentsByAge   Student Weight 1 2

Coordinates

Field Type Original term Description
lat float   Lat
lon float   Lon

department

Field Type Original term Description
candidates GraudationDepartmentCandidates   The total number of exam candidates for this school year
failed GraudationDepartmentCandidates   The number of candidates that did not graduate
passed GraudationDepartmentCandidates   The number of candidates that graduated

dropout

Source: Voortijdig schoolverlaten - Voortijdig schoolverlaten - 02. Vsv in het voortgezet onderwijs per vo instelling

Field Type Original term Description
year integer   The year the dropout numbers apply to.
dropouts_with_mbo1_diploma integer Aantal VSV-ers met MBO 1 diploma Number of dropouts having a MBO 1 diploma (apprenticeship level) [14].
dropouts_with_vmbo_diploma integer Aantal VSV-ers met VMBO diploma Number of dropouts having a VMBO diploma [15].
dropouts_without_diploma integer Aantal VSV-ers zonder diploma Number of dropouts having no diploma.
education_structure string   Level of education [3].
total_dropouts integer   Total dropouts for the given year at this school.
total_students integer   Total students for the given year at this school.

GradesPerCourse

Source: 08. Examenkandidaten vmbo en examencijfers per vak per instelling

Source: 09. Examenkandidaten havo en examencijfers per vak per instelling

Source: 10. Examenkandidaten vwo en examencijfers per vak per instelling

Field Type Original term Description
amount_of_central_exams integer   The amount of central exams [21] conducted for this branch
amount_of_central_exams_counting_for_diploma integer   The amount of central exams [21] conducted at this branch that count for a diploma
amount_of_school_exams_with_grades integer   The amount of school exams [22] conducted at this branch that are graded
amount_of_school_exams_with_grades_counting_for_diploma integer   The amount of school exams [22] conducted at this branch that are graded and count for a diploma
amount_of_school_exams_with_rating integer   Not all school exams are graded, but are rated as ‘onvoldoende’ (insufficient), ‘voldoende’ (sufficient) and ‘goed’ (good). This number denotes the amount of school exams that have rating, rather then a grade
amount_of_school_exams_with_rating_counting_for_diploma integer   The amount of school exams that are rated rather than graded that count for a diploma
average_grade_overall float   The final average grade. This average is based on the grades on the final list of grades
avg_grade_central_exams float   The average grade for central exams.
avg_grade_central_exams_counting_for_diploma float   The average grade of central exams that count toward a diploma
avg_grade_school_exams float   The average grade for school exams
avg_grade_school_exams_counting_for_diploma float   The average grade of school exams that count toward a diploma
course_abbreviation string   Abbreviation used by DUO that denotes the course
course_identifier string   Identifier used by DUO for a course
course_name string   Verbose, human-readable name for the course
education_structure string   Level of education [3]

graduates_per_qualification

Field Type Original term Description
qualification_code integer   Unique code for the program and level
graduates_male integer   Number of male graduates
graduates_female integer   Number of female graduates

graduation

Source: Voortgezet onderwijs - Leerlingen - 06. Examenkandidaten en geslaagden

Field Type Original term Description
candidates integer   The total number of exam candidates for this school year
failed integer   The number of candidates that did not graduate
passed integer   The number of candidates that graduated
department array of department   Department
year string Schooljaar The school year the graduations applay to

GraudationDepartmentCandidates

Field Type Original term Description
male integer   Male
female integer   Female
unkown integer   Unkown
department string OPLEIDINGSNAAM Department
education_structure string ONDERWIJSTYPE VO Education Structure

participants_per_grade_year_and_qualification

Field Type Original term Description
qualification_code integer   Unique code for the program and level
grade_year integer   The grade year that the students are in (years of education completed +1)
participants integer   Number of participants

participants_per_qualification

Field Type Original term Description
qualification_code integer   Unique code for the program and level
participants_male integer   Number of male participants
participants_female integer   Number of female participants

qualifications

Field Type Original term Description
qualification_code integer Kwalificatie Code Unique code for the program and level
mbo_type string Type Mbo  
qualification_level integer Kwalificatie Niveau Qualification Level
qualification_name string Kwalificatie Naam Name for the program and level combination
mbo_sector string Mbo Sector  
mbo_industry string Bedrijfstak Mbo  
brin_knowledge_centre_mbo string Brin Nummer Kenniscentrum Brin code of the knowledge center associated with this institution
knowledge_centre_mbo string Naam Kenniscentrum Name of the knowledge center associated with this institution

spo_students_by_birthyear

Field Type Original term Description
birthyear integer   Year of birth
students integer   Number of students born in this year

spo_students_by_edu_type

Field Type Original term Description
spo_indication string Indicatie Special Basis Onderwijs Indication of type of special education
sbao integer   Sbao
so integer SO Special education.
vso integer SVO Special secondary education.
v_so integer (V)SO Special education and special secondary education.

spo_students_per_cluster

Field Type Original term Description
cluster_1 integer Cluster Number of pupils in schools for visually handicapped students
cluster_2 integer Cluster Number of pupils in schools for auditory / communicatively disabled students: deaf, hard of hearing, severe speech difficulties.
cluster_3 integer Cluster Number of pupils in schools for pupils with physical and / or intellectual disabilities: very difficult learning, protracted illness with physical disabilities.
cluster_4 integer Cluster Number of pupils in schools for pupils with psychiatric disorders and severe learning and / or behavioral problems, chronically ill students without disabilities and students associated with university-associated institutes that provide assistance to children with complex learning, behavioral or emotional problems (Pedologisch Instituut).

student_residence

Number of pupils per age group (up to 25, as special education is included).

Source: Primair onderwijs - Leerlingen - 11. Leerlingen primair onderwijs per gemeente naar postcode leerling en leeftijd

Field Type Original term Description
municipality string   Municipality
municipality_code integer   Municipality Code
city string   City
zip_code string   The zip code where these pupils live.
year_1 integer   Year 1
year_2 integer   Year 2
year_3 integer   Year 3
year_4 integer   Year 4
year_5 integer   Year 5
year_6 integer   Year 6

students_by_advice

The level of education [3] that the primary school recommended the student upon leaving primary education Source: Primair onderwijs - Leerlingen - 12. Leerlingen (speciaal) basisonderwijs per schoolvestiging naar schooladvies

Field Type Original term Description
vso integer VSO Number of students with VSO advice
pro integer PrO Number of students with PrO advice
vmbo_bl integer VMBO BL Number of students with VMBO BL advice
vmbo_bl_kl integer VMBO BL-KL Number of students with VMBO BL-KL advice
vmbo_kl integer VMBO KL Number of students with VMBO KL advice
vmbo_kl_gt integer VMBO KL-GT Number of students with VMBO KL-GT advice
vmbo_gt integer VMBO GT Number of students with VMBO GT advice
vmbo_gt_havo integer VMBO GT-HAVO Number of students with VMBO GT-HAVO advice
havo integer HAVO Number of students with HAVO advice
havo_vwo integer HAVO-VWO Number of students with HAVO-VWO advice
vwo integer VWO Number of students with VWO advice
unknown integer ONBEKEND Number of students with unknown advice

students_by_finegrained_structure

Field Type Original term Description
type string   Type
count integer   Count

students_by_structure

Source: Voortgezet onderwijs - Leerlingen - 01. Leerlingen per vestiging naar onderwijstype, lwoo indicatie, sector, afdeling, opleiding

Field Type Original term Description
department string   Optional. Department of a vmbo track.
education_name string   Name of the education programme.
education_structure string   Level of education [3].
elementcode integer   Elementcode
lwoo boolean   Indicates whether this sector supports ‘Leerwegondersteunend onderwijs’, for students who need additional guidance [18].
vmbo_sector string   Vmbo sector [16].
year_1 StudentsEnrolledInStructure   Distribution of male and female students for year 1.
year_2 StudentsEnrolledInStructure   Distribution of male and female students for year 2.
year_3 StudentsEnrolledInStructure   Distribution of male and female students for year 3.
year_4 StudentsEnrolledInStructure   Distribution of male and female students for year 4.
year_5 StudentsEnrolledInStructure   Distribution of male and female students for year 5.
year_6 StudentsEnrolledInStructure   Distribution of male and female students for year 6.

students_by_year

Source: Primair onderwijs - Leerlingen - 11. Leerlingen (speciaal) basisonderwijs per schoolvestiging naar leerjaar

Field Type Original term Description
year_n integer   Number of students for year n (including special education) .

students_prognosis

Source: Primair onderwijs - Leerlingen - 11. Prognose aantal leerlingen

Field Type Original term Description
year integer   Prognosis is for this year
structure string   Level of education [3].
students integer   Number of students

StudentsByAge

Field Type Original term Description
age_3 integer   Number of children at age 3 in the key’s weight category at this branch.
age_4 integer   Number of children at age 4 in the key’s weight category at this branch.
age_5 integer   Number of children at age 5 in the key’s weight category at this branch.
age_6 integer   Number of children at age 6 in the key’s weight category at this branch.
age_7 integer   Number of children at age 7 in the key’s weight category at this branch.
age_8 integer   Number of children at age 8 in the key’s weight category at this branch.
age_9 integer   Number of children at age 9 in the key’s weight category at this branch.
age_10 integer   Number of children at age 10 in the key’s weight category at this branch.
age_11 integer   Number of children at age 11 in the key’s weight category at this branch.
age_12 integer   Number of children at age 12 in the key’s weight category at this branch.
age_13 integer   Number of children at age 13 in the key’s weight category at this branch.
age_14 integer   Number of children at age 14 in the key’s weight category at this branch.

StudentsEnrolledInStructure

Field Type Original term Description
male integer   Male
female integer   Female
total integer   Total

vavo_students

Students who are registered in secondary education, but are in an adult education program, can still graduate with a secondary education degree (Rutte - regeling)
Field Type Original term Description
non_vavo integer   Number of non-vavo students
vavo integer   Number of students delegated to adult education

Viewport

Field Type Original term Description
northeast Coordinates   Northeast
southwest Coordinates   Southwest

weights_per_school

Source: Primair onderwijs - Leerlingen - 11. Leerlingen (speciaal) basisonderwijs per schoolvestiging naar leerjaar

Field Type Original term Description
student_weight_0_0 integer   Number of pupils who’s parents don’t fall into the weight 0.3 or 1.2 categories.
student_weight_0_3 integer   Number of pupils who’s both parents didn’t get education beyond lbo/vbo, ‘praktijkonderwijs’ or vmbo ‘basis- of kaderberoepsgerichte leerweg’ [23].
student_weight_1_2 integer   Number of pupils who’s parents (one or both) didn’t get education beyond ‘basisonderwijs’ or (v)so-zmlk [23].
school_weight integer Schoolgewicht Based on the student weights and results in extra money for the branch.
impulse_area boolean Impulsgebied True if the branch is located in a so-called impulse area, which is an zipcode area with many families with low income or welfare. In if this is the case the branch gets extra money for each pupil.

Footnotes

[1]http://nl.wikipedia.org/wiki/Schoolbestuur
[2]http://nl.wikipedia.org/wiki/BRIN
[3](1, 2, 3, 4, 5, 6) http://en.wikipedia.org/wiki/Education_in_the_Netherlands#High_school
[4](1, 2, 3, 4, 5, 6) http://en.wikipedia.org/wiki/Education_in_the_Netherlands#General_overview
[5](1, 2, 3, 4, 5, 6) Dutch Bureau of Statistics: http://www.cbs.nl/en-GB/menu/home/default.htm
[6](1, 2, 3, 4) http://en.wikipedia.org/wiki/Dutch_provinces
[7]http://en.wikipedia.org/wiki/Postal_code#Netherlands
[8]http://nl.wikipedia.org/wiki/Medezeggenschapsraad
[9]http://www.vo-raad.nl/
[10]http://www.vo-raad.nl/dossiers/leermiddelen/gedragscode-schoolkosten
[11]http://wiki.schoolvo.nl/mediawiki/index.php/Tevredenheid_leerlingen
[12]http://wiki.schoolvo.nl/mediawiki/index.php/Tevredenheid_ouders
[13](1, 2, 3, 4, 5) http://wetten.overheid.nl/BWBR0003740
[14]http://nl.wikipedia.org/wiki/Middelbaar_beroepsonderwijs#Niveau
[15]http://en.wikipedia.org/wiki/Voorbereidend_middelbaar_beroepsonderwijs
[16]http://nl.wikipedia.org/wiki/Vmbo#Sectoren
[17]http://nl.wikipedia.org/wiki/Profielen_Tweede_Fase#Profielen
[18]http://nl.wikipedia.org/wiki/Lwoo
[19]http://nl.wikipedia.org/wiki/Inspectie_van_het_Onderwijs_(Nederland)
[20]http://calendar42.com/bag42/
[21](1, 2) http://nl.wikipedia.org/wiki/Centraal_examen
[22](1, 2) http://nl.wikipedia.org/wiki/Schoolexamen
[23](1, 2, 3) http://www.rijksoverheid.nl/onderwerpen/leerachterstand/vraag-en-antwoord/wat-is-de-gewichtenregeling-in-het-basisonderwijs.html