Name: Teachers And Professors
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Teachers And Professors

Professors are the highest-level of educators and usually specialize in a specific academic subject or field. They are critical faculty at a college. Teachers on the other hand are charged with teaching younger students, focusing on kindergarten through high school.

@article{owidteachersandprofessors,
author = {Max Roser},
title = {Teachers and Professors},
journal = {Our World in Data},
year = {2017},
note = {https://ourworldindata.org/teachers-and-professors}
}

Tables

Actual Teaching Time As Share Of Scheduled Teaching Time

@kaggle.programmerrdai_teachers_and_professors_be_like_work.actual_teaching_time_as_share_of_scheduled_teaching_time

4.12 kB
18 rows
4 columns

CREATE TABLE actual_teaching_time_as_share_of_scheduled_teaching_time (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "percentage_of_scheduled_time_teacher_is_teaching" DOUBLE
);

Number Of Teachers Across Education Levels

@kaggle.programmerrdai_teachers_and_professors_be_like_work.number_of_teachers_across_education_levels

149.35 kB
7,958 rows
8 columns

CREATE TABLE number_of_teachers_across_education_levels (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "teachers_in_pre_primary_education_both_sexes_number" DOUBLE  -- Teachers In Pre-primary Education, Both Sexes (number),
  "teachers_in_primary_education_both_sexes_number" DOUBLE  -- Teachers In Primary Education, Both Sexes (number),
  "teachers_in_lower_secondary_education_both_sexes_number" DOUBLE  -- Teachers In Lower Secondary Education, Both Sexes (number),
  "teachers_in_upper_secondary_education_both_sexes_number" DOUBLE  -- Teachers In Upper Secondary Education, Both Sexes (number),
  "teachers_in_tertiary_education_programmes_both_sexes_number" DOUBLE  -- Teachers In Tertiary Education Programmes, Both Sexes (number)
);

Number Of Teachers Across Education Levels 1

@kaggle.programmerrdai_teachers_and_professors_be_like_work.number_of_teachers_across_education_levels_1

149.35 kB
7,958 rows
8 columns

CREATE TABLE number_of_teachers_across_education_levels_1 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "teachers_in_pre_primary_education_both_sexes_number" DOUBLE  -- Teachers In Pre-primary Education, Both Sexes (number),
  "teachers_in_primary_education_both_sexes_number" DOUBLE  -- Teachers In Primary Education, Both Sexes (number),
  "teachers_in_lower_secondary_education_both_sexes_number" DOUBLE  -- Teachers In Lower Secondary Education, Both Sexes (number),
  "teachers_in_upper_secondary_education_both_sexes_number" DOUBLE  -- Teachers In Upper Secondary Education, Both Sexes (number),
  "teachers_in_tertiary_education_programmes_both_sexes_number" DOUBLE  -- Teachers In Tertiary Education Programmes, Both Sexes (number)
);

Percentage Of Teachers Absent From Class

@kaggle.programmerrdai_teachers_and_professors_be_like_work.percentage_of_teachers_absent_from_class

3.69 kB
7 rows
4 columns

CREATE TABLE percentage_of_teachers_absent_from_class (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "percentage_of_teachers_absent_from_class" BIGINT
);

Percentage Of Teachers Absent From School

@kaggle.programmerrdai_teachers_and_professors_be_like_work.percentage_of_teachers_absent_from_school

3.69 kB
7 rows
4 columns

CREATE TABLE percentage_of_teachers_absent_from_school (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "percentage_of_teachers_absent_from_school" BIGINT
);

Pupils Per Qualified Teacher Vs Gdp Per Capita

@kaggle.programmerrdai_teachers_and_professors_be_like_work.pupils_per_qualified_teacher_vs_gdp_per_capita

486.47 kB
57,131 rows
7 columns

CREATE TABLE pupils_per_qualified_teacher_vs_gdp_per_capita (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "pupil_qualified_teacher_ratio_in_primary_education_hea_ac0aa50d" DOUBLE  -- Pupil/qualified Teacher Ratio In Primary Education (headcount Basis),
  "gdp_per_capita_ppp_current_international" DOUBLE  -- GDP Per Capita, PPP (current International $),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Pupil Teacher Ratio For Primary Education By Country

@kaggle.programmerrdai_teachers_and_professors_be_like_work.pupil_teacher_ratio_for_primary_education_by_country

64.53 kB
6,722 rows
4 columns

CREATE TABLE pupil_teacher_ratio_for_primary_education_by_country (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "pupil_teacher_ratio_in_primary_education_headcount_basis" DOUBLE  -- Pupil-teacher Ratio In Primary Education (headcount Basis)
);

Pupil Teacher Ratio For Primary Education By Country 1

@kaggle.programmerrdai_teachers_and_professors_be_like_work.pupil_teacher_ratio_for_primary_education_by_country_1

64.53 kB
6,722 rows
4 columns

CREATE TABLE pupil_teacher_ratio_for_primary_education_by_country_1 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "pupil_teacher_ratio_in_primary_education_headcount_basis" DOUBLE  -- Pupil-teacher Ratio In Primary Education (headcount Basis)
);

Saber Rating Of Education Policies Aimed At Preparing, Da69dc71

@kaggle.programmerrdai_teachers_and_professors_be_like_work.saber_rating_of_education_policies_aimed_at_preparing__da69dc71

4.31 kB
29 rows
4 columns

CREATE TABLE saber_rating_of_education_policies_aimed_at_preparing__da69dc71 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "saber_teachers_policy_goal_7_supporting_teachers_to_im_99acc051" BIGINT  -- SABER: (Teachers) Policy Goal 7: Supporting Teachers To Improve Instruction
);

Share Of Primary School Teachers Who Are Female

@kaggle.programmerrdai_teachers_and_professors_be_like_work.share_of_primary_school_teachers_who_are_female

55.64 kB
5,840 rows
4 columns

CREATE TABLE share_of_primary_school_teachers_who_are_female (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "percentage_of_teachers_in_primary_education_who_are_female" DOUBLE  -- Percentage Of Teachers In Primary Education Who Are Female (%)
);

Share Of Primary Teachers Qualified

@kaggle.programmerrdai_teachers_and_professors_be_like_work.share_of_primary_teachers_qualified

6.26 kB
132 rows
4 columns

CREATE TABLE share_of_primary_teachers_qualified (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "percentage_of_teachers_in_primary_education_who_are_qu_5fd41f8c" DOUBLE  -- Percentage Of Teachers In Primary Education Who Are Qualified, Both Sexes (%)
);

Share Of Teachers In Primary Education Who Are Trained

@kaggle.programmerrdai_teachers_and_professors_be_like_work.share_of_teachers_in_primary_education_who_are_trained

15.73 kB
1,259 rows
4 columns

CREATE TABLE share_of_teachers_in_primary_education_who_are_trained (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "percentage_of_teachers_in_primary_education_who_are_tr_e49cc57f" DOUBLE  -- Percentage Of Teachers In Primary Education Who Are Trained, Both Sexes (%)
);

Share Of Teachers Who Are Female In Primary Vs Tertiar 9b3e5bec

@kaggle.programmerrdai_teachers_and_professors_be_like_work.share_of_teachers_who_are_female_in_primary_vs_tertiar_9b3e5bec

498.95 kB
56,732 rows
7 columns

CREATE TABLE share_of_teachers_who_are_female_in_primary_vs_tertiar_9b3e5bec (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "percentage_of_teachers_in_tertiary_education_who_are_female" DOUBLE  -- Percentage Of Teachers In Tertiary Education Who Are Female (%),
  "percentage_of_teachers_in_primary_education_who_are_female" DOUBLE  -- Percentage Of Teachers In Primary Education Who Are Female (%),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Share Of Trained Teachers Vs Share Of Qualified Teache F9902392

@kaggle.programmerrdai_teachers_and_professors_be_like_work.share_of_trained_teachers_vs_share_of_qualified_teache_f9902392

425.95 kB
55,842 rows
7 columns

CREATE TABLE share_of_trained_teachers_vs_share_of_qualified_teache_f9902392 (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "percentage_of_teachers_in_primary_education_who_are_qu_5fd41f8c" DOUBLE  -- Percentage Of Teachers In Primary Education Who Are Qualified, Both Sexes (%),
  "percentage_of_teachers_in_primary_education_who_are_tr_e49cc57f" DOUBLE  -- Percentage Of Teachers In Primary Education Who Are Trained, Both Sexes (%),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);

Staff Compensation Share Primary Spending

@kaggle.programmerrdai_teachers_and_professors_be_like_work.staff_compensation_share_primary_spending

16.04 kB
1,135 rows
4 columns

CREATE TABLE staff_compensation_share_primary_spending (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "all_staff_compensation_as_of_total_expenditure_in_prim_bed78b8b" DOUBLE  -- All Staff Compensation As % Of Total Expenditure In Primary Public Institutions (%)
);

Starting Yearly Teacher Salaries In Public Primary Education

@kaggle.programmerrdai_teachers_and_professors_be_like_work.starting_yearly_teacher_salaries_in_public_primary_education

490.74 kB
57,133 rows
7 columns

CREATE TABLE starting_yearly_teacher_salaries_in_public_primary_education (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "annual_statutory_teacher_salaries_in_public_institutio_f66db23c" DOUBLE  -- Annual Statutory Teacher Salaries In Public Institutions In USD. Primary. Starting Salary,
  "gdp_per_capita_ppp_current_international" DOUBLE  -- GDP Per Capita, PPP (current International $),
  "population_historical_estimates" DOUBLE  -- Population (historical Estimates),
  "continent" VARCHAR
);