See http://api.cde.ca.gov/datafiles.html for more information.
| Field # | Field Name | Type | Description |
|---|---|---|---|
| 1 | id | Numeric | Observation id |
| 2 | cds | Character | County/District/School code |
| 3 | stype | Numeric | School Type: (E = Elem, M = Middle, H = High, S = Special) |
| 4 | sname | Character | School Name |
| 5 | dname | Character | District Name |
| 6 | cname | Character | County Name |
| 7 | flag | Numeric | Flag Values |
| 8 | valid_num | Numeric | Number of Students Included in the 2003 API |
| 9a | api99 | Numeric | Tested 1999 API (Base) |
| 9b | api00 | Numeric | Tested 2000 API (Base) |
| 9c | api01 | Numeric | Tested 2001 API (Base) |
| 9d | api02 | Numeric | Tested 2002 API (Base) |
| 9e | api03 | Numeric | Tested 2003 API (Base) (Note: Should have asterick if Valid_Num < 100) |
| 10 | st_rank | Numeric | Statewide Rank (Note: Should have asterisk if Valid_Num < 100) |
| 11 | sim_rank | Numeric | Similar Schools Rank |
| 12 | gr_targ | Numeric | 2003 API Growth Target |
| 13 | api_targ | Numeric | 2003 API Target |
| 14 | aa_num | Numeric | Number of African Americans Included in API. |
| 15 | aa_sig | Numeric | African Americans Significant?(Yes/No) |
| 16 | aa_api | Numeric | 2003 African American API (Base) |
| 17 | aa_gt | Numeric | 2003 African American Subgroup Growth Target |
| 18 | aa_targ | Numeric | 2003 African American Subgroup API Target |
| 19 | ai_num | Numeric | Number of American Indians Included in API. |
| 20 | ai_sig | Numeric | American Indians Significant?(Yes/No) |
| 21 | ai_api | Numeric | 2003 American Indians API (Base) |
| 22 | ai_gt | Numeric | 2003 American Indians Subgroup Growth Target |
| 23 | ai_targ | Numeric | 2003 American Indians Subgroup API Target |
| 24 | as_num | Numeric | Number of Asians Included in API. |
| 25 | as_sig | Numeric | Asians Significant?(Yes/No) |
| 26 | as_api | Numeric | 2003 Asian API (Base) |
| 27 | as_gt | Numeric | 2003 Asian Subgroup Growth Target |
| 28 | as_targ | Numeric | 2003 Asian Subgroup API Target |
| 29 | fi_num | Numeric | Number of Filipinos Included in API. |
| 30 | fi_sig | Numeric | Filipino Significant?(Yes/No) |
| 31 | fi_api | Numeric |
2003 Filipino API (Base) |
| 32 | fi_gt | Numeric | 2003 Filipino Subgroup Growth Target |
| 33 | fi_targ | Numeric | 2003 Filipino Subgroup API Target |
| 34 | hi_num | Numeric | Number of Hispanics included in API. |
| 35 | hi_sig | Numeric | Hispanics Significant?(Yes/No) |
| 36 | hi_api | Numeric | 2003 Hispanics API (Base) |
| 37 | hi_gt | Numeric | 2003 Hispanics Subgroup Growth Target |
| 38 | hi_targ | Numeric | 2003 Hispanics Subgroup API Target |
| 39 | pi_num | Numeric | Number of Pacific Islanders Included in API. |
| 40 | pi_sig | Numeric | Pacific Islanders Significant?(Yes/No) |
| 41 | pi_api | Numeric | 2003 Pacific Islanders API (Base) |
| 42 | pi_gt | Numeric | 2003 Pacific Islanders Subgroup Growth Target |
| 43 | pi_targ | Numeric | 2003 Subgroup API Target |
| 44 | wh_num | Numeric | Number of whites included in API. |
| 45 | wh_sig | Numeric | White Significant?(Yes/No) |
| 46 | wh_api | Numeric | 2003 Whites API (Base) |
| 47 | wh_gt | Numeric | 2003 Whites Subgroup Growth Target |
| 48 | wh_targ | Numeric | 2003 White API Target |
| 49 | sd_num | Numeric | Number of Socioeconomically Disadvantaged (SD) Students Included in API. |
| 50 | sd_sig | Numeric | Socioeconomically Disadvantaged Significant?(Yes/No) |
| 51 | sd_api | Numeric | 2003 Socioeconomically Disadvantaged API (Base) |
| 52 | sd_gt | Numeric | 2003 Socioeconomically Disadvantaged subgroup Growth Target |
| 53 | sd_targ | Numeric | 2003 Socioeconomically Disadvantaged API Target |
| 54 | pct_aa | Numeric | Percent African American |
| 55 | pct_ai | Numeric | Percent American Indian |
| 56 | pct_as | Numeric | Percent Asian |
| 57 | pct_fi | Numeric | Percent Filipino |
| 58 | pct_hi | Numeric | Percent Hispanic or Latino |
| 59 | pct_pi | Numeric | Percent Pacific Islander |
| 60 | pct_wh | Numeric | Percent White |
| 61 | meals | Numeric | Percentage of Students Tested that are Participants in the Free or Reduced Price Lunch Program |
| 62 | el | Numeric | Percent English Learners |
| 63 | yr_rnd | Numeric | Year Round School |
| 64 | smob | Numeric | Percentage of Students Who First Attended this School in the Present Year. |
| 65 | dmob | Numeric | Percentage of Students counted as part of district enrollment in October 2003 CBEDS and has been continuously enrolled since that date. |
| 66 | acs_k3 | Numeric | Average Class Size (Grades K-3) |
| 67 | acs_46 | Numeric | Average Class Size (Grades 4-6) |
| 68 | acs_core | Numeric | Number of Core Academic Courses |
| 69 | pct_resp | Numeric | Percent of Student Answer Documents with Parent Education Level Information |
| 70 | not_hsg | Numeric | Parent Ed Level: Percent Not HS Grad |
| 71 | hsg | Numeric | Parent Ed Level: Percent HS Graduate |
| 72 | some_col | Numeric | Parent Ed Level: Percent Some College |
| 73 | col_grad | Numeric | Parent Ed Level: Percent College Graduate |
| 74 | grad_sch | Numeric | Parent Ed Level: Percent Graduate School |
| 75 | avg_ed | Numeric | Average Parent Education Level |
| 76 | full | Numeric | Percent Teachers at This School with Full Credentials |
| 77 | emer | Numeric | Percent Teachers at this school with Emergency Credentials |
| 78 | enroll | Numeric | Number of Students Enrolled on the First Day of Testing for Grades 2-11 |
| 79 | capam | Numeric | Students marked as taking the CAPA |
| 80 | parent_opt | Numeric | Number of Students Excused from Testing by Parental Written Request |
| 81 | tested | Numeric | Number of Students Tested on STAR |
| 82 | capat | Numeric | Number of Students Tested on CAPA |
| 83 | cbmob | Numeric | School Mobility from CBEDS |
| 84 | sci | Numeric | School Characteristic Index |