Escola Virtual Em Números

Open data

The Virtual School Gov now makes its entire database available for download. This way, it is possible to apply filters as needed. The database contains data related to the student, the course taken, professional data, among others that can be used for demographic analyses of interest to each body/organization.

This action aligns with EV.G's transparency policy and aims to ensure more agility in the process and freedom of analysis for interested institutions, public servants, and citizens.

Data dictionary

The data dictionary explains each column present in the provided database.

Order Data Field name Type Description
1 Enrollment Code cod_matricula Alphanumeric Anonymized code that uniquely identifies each student enrollment.
2 Enrollment Date dt_matricula Datetime Date and time when the student completed their enrollment.
3 Course Code cod_curso Alphanumeric Anonymized code that identifies the course.
4 Course Name nome_curso Alphanumeric Course name as registered.
5 Class/Offer Code cod_turma Alphanumeric Anonymized code that uniquely identifies the class/offering of a course.
6 Class/Offer Name nome_turma Alphanumeric Name of the class/offering of a course.
7 Class/Offer Modality modalidade_turma Alphanumeric Modality of the class offering (Distance Learning, In-Person, Blended Learning).
8 Course Workload carga_horaria Numeric Course workload.
9 Enrollment Start Date dt_inicio_insc Date Start date of the enrollment period.
10 Enrollment End Date dt_fim_insc Date End date of the enrollment period.
11 Classes Start Date dt_inicio Datetime Start date of the course for the student.
12 Classes End Date dt_fim Datetime End date of the course for the student.
13 Course Author conteudista Alphanumeric Course author who developed the course.
14 Course Theme tematica Alphanumeric Course theme.
15 Student's Enrollment Status sit_matricula Alphanumeric

Completed = successfully finished the course;

Not Completed = is still taking the course;

Withdrawn = did not finish the course;

Suspended = requested suspension without completing;

Failed = did not obtain the grade required to issue the certificate.

16 Person Code codigo_pessoa Alphanumeric Anonymized code that uniquely identifies each person
17 Student Gender sexo Alphanumeric Student's gender as indicated in their registration.
18 Student's Age idade Numeric Student's age calculated from the date of birth indicated in their registration
19 Student's Disability deficiencia Alphanumeric Student's disability(ies) as indicated in their registration. When there are multiple, they are separated by comma. Value 'Nenhuma' (None) when no disability is reported
20 Student's Race raca Alphanumeric Student's race/color as indicated in their registration
21 Student's Country of Origin nacionalidade Alphanumeric Student's country of birth as indicated in their registration.
22 User's State/UF uf_pessoa Alphanumeric User's state/UF of residence.
23 User's Municipality municipio_pessoa Alphanumeric Student's municipality of residence.
24 instituicao Alphanumeric
25 Branch of Government in Professional Experience poder Alphanumeric Branch of government in their most recent professional experience, as indicated in their registration.
26 esfera Alphanumeric
27 Work State/UF uf_servidor Alphanumeric State/UF where the student works.
28 Work Municipality municipio_servidor Alphanumeric Municipality where the student works.