-
Notifications
You must be signed in to change notification settings - Fork 1
datasets__esd_el_2015
Benjamin Chodoroff edited this page Apr 17, 2015
·
1 revision
mysql> describe esd_el_2015;
+----------------------------------+------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------------------+------------------------+------+-----+---------+-------+
| program_id | int(10) unsigned | NO | PRI | 0 | |
| program_name | varchar(255) | YES | | NULL | |
| CLC_RawAverage | decimal(4,2) unsigned | YES | | NULL | |
| CLC_FairAverage | decimal(4,2) unsigned | YES | | NULL | |
| Professionalism_RawAverage | decimal(4,2) unsigned | YES | | NULL | |
| Professionalism_FairAverage | decimal(4,2) unsigned | YES | | NULL | |
| Safety_RawAverage | decimal(4,2) unsigned | YES | | NULL | |
| Safety_FairAverage | decimal(4,2) unsigned | YES | | NULL | |
| Interactions_RawAverage | decimal(4,2) unsigned | YES | | NULL | |
| Interactions_FairAverage | decimal(4,2) unsigned | YES | | NULL | |
| FamilyCommunity_RawAverage | decimal(4,2) unsigned | YES | | NULL | |
| FamilyCommunity_FairAverage | decimal(4,2) unsigned | YES | | NULL | |
| Development_RawAverage | decimal(4,2) unsigned | YES | | NULL | |
| Development_FairAverage | decimal(4,2) unsigned | YES | | NULL | |
| Global_RawAverage | decimal(4,2) unsigned | YES | | NULL | |
| Global_Fair | decimal(4,2) unsigned | YES | | NULL | |
| Overall_Site_Visit_Rating | varchar(255) | YES | | NULL | |
| CLC_rating | varchar(255) | YES | | NULL | |
| Professionalism_rating | varchar(255) | YES | | NULL | |
| Safety_rating | varchar(255) | YES | | NULL | |
| Interactions_rating | varchar(255) | YES | | NULL | |
| FamilyCommunity_rating | varchar(255) | YES | | NULL | |
| Development_rating | varchar(255) | YES | | NULL | |
| Global_rating | varchar(255) | YES | | NULL | |
| Published_Rating | int(10) unsigned | YES | | NULL | |
| sas_score_rating | varchar(255) | YES | | NULL | |
| n_teacher_responses | int(10) unsigned | YES | | NULL | |
| number_teaching_staff | int(10) unsigned | YES | | NULL | |
| PhysicalEnviron_Staff_Average | decimal(16,8) unsigned | YES | | NULL | |
| FamilyCommunity_Staff_Average | decimal(16,8) unsigned | YES | | NULL | |
| CulturalLinguistic_Staff_Average | decimal(16,8) unsigned | YES | | NULL | |
| CultureClimate_Staff_Average | decimal(16,8) unsigned | YES | | NULL | |
| PhysicalEnvironment_Staff_Rating | varchar(255) | YES | | NULL | |
| FamilyCommunity_Staff_Rating | varchar(255) | YES | | NULL | |
| CulturalLinguistic_Staff_Rating | varchar(255) | YES | | NULL | |
| CultureClimate_Staff_Rating | varchar(255) | YES | | NULL | |
| teacher_survey_rating | varchar(255) | YES | | NULL | |
| site_visit_points | int(10) unsigned | YES | | NULL | |
| SAS_points | int(10) unsigned | YES | | NULL | |
| staff_points | int(10) unsigned | YES | | NULL | |
| total_points | int(10) unsigned | YES | | NULL | |
| overall_rating | varchar(255) | YES | | NULL | |
| provisional | int(10) unsigned | YES | | NULL | |
| Published_QRIS_Rating_2014 | decimal(16,8) | YES | | NULL | |
| teacher_score_mean_2014 | decimal(16,8) unsigned | YES | | NULL | |
| SiteVisitRatingYear | int(10) unsigned | YES | | NULL | |
| StaffSurveyRatingYear | int(10) unsigned | YES | | NULL | |
+----------------------------------+------------------------+------+-----+---------+-------+
47 rows in set (0.00 sec)