Skip to content

Instantly share code, notes, and snippets.

@hrwgc
Created June 25, 2012 17:16
Show Gist options
  • Save hrwgc/ee1f3e7dc00137e3434f to your computer and use it in GitHub Desktop.
Save hrwgc/ee1f3e7dc00137e3434f to your computer and use it in GitHub Desktop.
Kenya Data Dictionary

Kenya Grades Database

column name meaning original/modification
g_year year original
g_district_code district code original
g_district_name district name original
g_county county original
g_school_code school code original
g_knec_code knec code original
g_clean_name_5 further refined version of s_clean_name_42 modified
g_clean_name_4 fourth standardization of school name - contains less frequently used terms modified
g_clean_name_42 fourth standardization of school name - contains most frequently used terms modified
g_clean_name_3 third standardization of school name modified
g_clean_name_2 second standardization of school name modified
g_clean_name_1 first standardization of school name modified
g_school_name school name original
g_gender gender original
g_grade_attained grade attained original
g_mean_grade_points mean grade points original
g_frequency frequency original
g_clean_join shows if join was made on first standardization modification

Kenya Schools Database

column name meaning original/modification
s_gid gid original
s_code code original
s_clean_name_5 further refined version of s_clean_name_42 modified
s_clean_name_4 fourth standardization of school name - contains less frequently used terms modified
s_clean_name_42 fourth standardization of school name - contains most frequently used terms modified
s_clean_name_3 third standardization of school name modified
s_clean_name_2 second standardization of school name modified
s_clean_name_1 first standardization of school name modified
s_name_of_school name of school original
s_school_address school address original
s_public_or_private public or private original
school_sponsor l sponsor original
s_gender_recoded gender recoded modified
s_girls_boys_mixed girls boys mixed original
s_day_or_boarding_recoded day or boarding recoded modified
s_day_or_boarding day or boarding original
s_ordinary_or_special ordinary or special original
s_total_enrolment_2007 total enrollment 2007 original
s_total_teaching_staff total teaching staff original
s_pupil_teacher_ratio pupil teacher ratio original
s_acreage_per_enrolment acreage per enrollment original
s_tsc_male_teachers tsc male teachers original
s_tsc_female_teachers tsc female teachers original
s_local_auth_male_teachers local authority male teachers original
s_local_auth_female_teachers local authority female teachers original
s_pta_board_of_gov_male_teacher pta board of governors male teacher original
s_pta_board_of_gov_female_teacher pta board of governors female teacher original
s_other_male_teachers other male teachers original
s_other_female_teachers other female teachers original
s_non_teaching_staff_male non teaching staff male original
s_non_teaching_staff_female non teaching staff female original
s_acreage acreage original
s_district district original
s_division division original
s_location location original
s_sublocation sublocation original
s_school_zone school zone original
s_costituency constituency original
s_province province original
s_lat lat original
s_long long original
s_clean_join specifies the precision of join modified
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment