Amlan Banerjee [RES, CGPS]
2017-02-17
This document records the process of NCES CCD data preparation for EDIS.
Source: https://nces.ed.gov/ccd/pubschuniv.asp
School Year 2014-15 NCES CCD School Level data is split into six files: 1. Directory 2. Staff 3. Lunch 4. Membership 5. Characteristics 6. Geography
This document presents a quick view of the contents of each of the six files such as number of records, data type of the variables, etc. More detailed information about the variables are available in the data dictionaries, provided by NCES. Links to the data dictionaries are included in this document. Also. shown in this document is how the missing values are coded. In general, NCES assigns -1 or -2 to "missing" and "not applicable" records respectively in numeric variables. For NEA's analytics purposes, both categories are treated equally and recoded as 'NA' - which is treated as blank in R environment.
Number of records
[1] 102799https://nces.ed.gov/ccd/xls/2014-15%20CCD%20Companion_SCH%20Directory_File_Layout.xlsx
'data.frame': 102799 obs. of 66 variables:
$ SURVYEAR : Factor w/ 1 level "2014-2015": 1 1 1 1 1 1 1 1 1 1 ...
$ FIPST : Factor w/ 56 levels "01","02","04",..: 1 1 1 1 1 1 1 1 1 1 ...
$ STABR : Factor w/ 56 levels "AK","AL","AR",..: 2 2 2 2 2 2 2 2 2 2 ...
$ STATENAME : Factor w/ 56 levels "ALABAMA ",..: 1 1 1 1 1 1 1 1 1 1 ...
$ SEANAME : Factor w/ 56 levels "Alabama Department Of Education ",..: 1 1 1 1 1 1 1 1 1 1 ...
$ LEAID : Factor w/ 17655 levels "0100002","0100005",..: 1 1 1 1 1 1 1 2 2 2 ...
$ ST_LEAID : Factor w/ 15888 levels "00000000001894",..: 7793 7793 7793 7793 7793 7793 7793 4648 4648 4648 ...
$ LEA_NAME : Factor w/ 17316 levels "21st Century Charter Sch of Gary ",..: 199 199 199 199 199 199 199 232 232 232 ...
$ SCHID : Factor w/ 13363 levels "00001","00002",..: 277 1402 1667 1670 1705 1706 1876 870 871 879 ...
$ ST_SCHID : Factor w/ 74197 levels "000 ",..: 1903 2019 2688 2887 2110 2454 1289 1664 1903 6688 ...
$ NCESSCH : Factor w/ 102799 levels "010000200277",..: 1 2 3 4 5 6 7 8 9 10 ...
$ SCH_NAME : Factor w/ 90648 levels "1 LT Charles W. Whitcomb School ",..: 73074 25248 11096 20082 84742 51335 1142 1133 1311 25358 ...
$ MSTREET1 : Factor w/ 85162 levels "\"No street address\" ",..: 81316 40922 81171 81171 81171 75962 11173 62236 48798 76675 ...
$ MSTREET2 : Factor w/ 1275 levels " ",..: 1 1 1 1 1 1 1 1 1 1 ...
$ MSTREET3 : Factor w/ 21 levels " ",..: 1 1 1 1 1 1 1 1 1 1 ...
$ MCITY : Factor w/ 14579 levels "Abbeville ",..: 1088 2444 8729 8729 8659 1088 5635 115 115 115 ...
$ MSTATE : Factor w/ 55 levels " ",..: 3 3 3 3 3 3 3 3 3 3 ...
$ MZIP : Factor w/ 22867 levels "00601","00602",..: 7705 7882 7901 7901 7901 7692 7646 7848 7848 7848 ...
$ MZIP4 : Factor w/ 8422 levels " ","0001",..: 1 1 1 1 1 1 1 1 1 1 ...
$ PHONE : Factor w/ 93055 levels "2011660100","2012003200",..: 1444 20331 20091 20091 20092 1533 1454 9769 9772 9774 ...
$ LSTREET1 : Factor w/ 93613 levels "\"No street address\" ",..: 1797 47079 21248 32122 1797 86761 92095 71279 55974 87577 ...
$ LSTREET2 : Factor w/ 1359 levels " ",..: 1 1 1 1 1 1 1 1 1 1 ...
$ LSTREET3 : Factor w/ 28 levels " ",..: 1 1 1 1 1 1 1 1 1 1 ...
$ LCITY : Factor w/ 14794 levels "Abbeville ",..: 1113 2482 10758 13143 8802 1113 8869 114 114 114 ...
$ LSTATE : Factor w/ 55 levels " ",..: 3 3 3 3 3 3 3 3 3 3 ...
$ LZIP : Factor w/ 22902 levels "00601","00602",..: 7684 7857 7878 8038 7875 7671 7875 7823 7823 7823 ...
$ LZIP4 : Factor w/ 8570 levels " ","0001",..: 1 1 1 1 1 1 1 1 1 1 ...
$ UNION : Factor w/ 97 levels "000","001","002",..: 1 1 1 1 1 1 1 1 1 1 ...
$ OUT_OF_STATE_FLAG : Factor w/ 2 levels "N","Y": 1 1 1 1 1 1 1 1 1 1 ...
$ SCH_TYPE_TEXT : Factor w/ 4 levels "Alternative Education School",..: 1 1 1 1 1 1 2 2 2 2 ...
$ SCH_TYPE : Factor w/ 4 levels "1","2","3","4": 4 4 4 4 4 4 1 1 1 1 ...
$ RECON_STATUS : Factor w/ 2 levels "No ","Yes": 1 1 1 1 1 1 1 1 1 1 ...
$ GSLO : Factor w/ 18 levels "01","02","03",..: 7 3 7 7 7 7 16 7 9 5 ...
$ GSHI : Factor w/ 18 levels "01","02","03",..: 12 12 12 12 12 12 16 8 12 6 ...
$ LEVEL : Factor w/ 5 levels "1","2","3","4",..: 3 5 3 3 3 3 5 2 3 2 ...
$ VIRTUAL : Factor w/ 3 levels "MISSING ",..: 2 2 2 2 2 2 2 2 2 2 ...
$ BIES : Factor w/ 2 levels "1","2": 2 2 2 2 2 2 2 2 2 2 ...
$ SY_STATUS_TEXT : Factor w/ 8 levels "Added ",..: 7 3 7 7 7 7 7 7 7 7 ...
$ SY_STATUS : Factor w/ 8 levels "1","2","3","4",..: 1 2 1 1 1 1 1 1 1 1 ...
$ UPDATED_STATUS_TEXT: Factor w/ 8 levels "Added ",..: 7 3 7 7 7 7 7 7 7 7 ...
$ UPDATED_STATUS : Factor w/ 8 levels "1","2","3","4",..: 1 2 1 1 1 1 1 1 1 1 ...
$ EFFECTIVE_DATE : Factor w/ 37877 levels "01APR2015:16:05:35 ",..: 1322 1322 1324 1325 1323 1324 1321 1102 1102 1103 ...
$ CHARTER_TEXT : Factor w/ 3 levels "No ",..: 2 2 2 2 2 2 2 2 2 2 ...
$ PKOFFERED : Factor w/ 2 levels "N","Y": 1 1 1 1 1 1 1 1 1 1 ...
$ KGOFFERED : Factor w/ 2 levels "N","Y": 1 1 1 1 1 1 1 1 1 1 ...
$ G1OFFERED : Factor w/ 2 levels "N","Y": 1 1 1 1 1 1 1 1 1 1 ...
$ G2OFFERED : Factor w/ 2 levels "N","Y": 1 1 1 1 1 1 1 1 1 1 ...
$ G3OFFERED : Factor w/ 2 levels "N","Y": 1 2 1 1 1 1 1 1 1 1 ...
$ G4OFFERED : Factor w/ 2 levels "N","Y": 1 2 1 1 1 1 1 1 1 1 ...
$ G5OFFERED : Factor w/ 2 levels "N","Y": 1 2 1 1 1 1 1 1 1 2 ...
$ G6OFFERED : Factor w/ 2 levels "N","Y": 1 2 1 1 1 1 1 1 1 2 ...
$ G7OFFERED : Factor w/ 2 levels "N","Y": 2 2 2 2 2 2 1 2 1 1 ...
$ G8OFFERED : Factor w/ 2 levels "N","Y": 2 2 2 2 2 2 1 2 1 1 ...
$ G9OFFERED : Factor w/ 2 levels "N","Y": 2 2 2 2 2 2 1 1 2 1 ...
$ G10OFFERED : Factor w/ 2 levels "N","Y": 2 2 2 2 2 2 1 1 2 1 ...
$ G11OFFERED : Factor w/ 2 levels "N","Y": 2 2 2 2 2 2 1 1 2 1 ...
$ G12OFFERED : Factor w/ 2 levels "N","Y": 2 2 2 2 2 2 1 1 2 1 ...
$ G13OFFERED : Factor w/ 2 levels "N","Y": 1 1 1 1 1 1 1 1 1 1 ...
$ AEOFFERED : Factor w/ 2 levels "N","Y": 1 1 1 1 1 1 1 1 1 1 ...
$ UGOFFERED : Factor w/ 2 levels "N","Y": 1 1 1 1 1 1 1 1 1 1 ...
$ NOGRADES : Factor w/ 2 levels "N","Y": 1 1 1 1 1 1 2 1 1 1 ...
$ CHARTAUTH1 : Factor w/ 1052 levels "Academy, School District No. 20, in the county of El Paso an",..: 617 617 617 617 617 617 617 617 617 617 ...
$ CHARTAUTHN1 : Factor w/ 1042 levels "00 ",..: 1039 1039 1039 1039 1039 1039 1039 1039 1039 1039 ...
$ CHARTAUTH2 : Factor w/ 1 level "NOT APPLICABLE": 1 1 1 1 1 1 1 1 1 1 ...
$ CHARTAUTHN2 : Factor w/ 1 level "NOT APPLICABLE": 1 1 1 1 1 1 1 1 1 1 ...
$ IGOFFERED : Factor w/ 2 levels "A","R": 2 2 2 2 2 2 2 2 2 2 ...
- attr(*, "variable.labels")= Named chr "Year corresponding to survey record" "American National Standards Institute (ANSI) state code" "Postal state abbreviation code" "State name" ...
..- attr(*, "names")= chr "SURVYEAR" "FIPST" "STABR" "STATENAME" ...
- attr(*, "codepage")= int 1252Number of records
[1] 100184https://nces.ed.gov/ccd/xls/2014-15%20CCD%20Companion_SCH%20Staff_File_Layout.xlsx
'data.frame': 100184 obs. of 14 variables:
$ SURVYEAR : Factor w/ 1 level "2014-2015": 1 1 1 1 1 1 1 1 1 1 ...
$ FIPST : Factor w/ 56 levels "01","02","04",..: 1 1 1 1 1 1 1 1 1 1 ...
$ STABR : Factor w/ 56 levels "AK","AL","AR",..: 2 2 2 2 2 2 2 2 2 2 ...
$ STATENAME: Factor w/ 56 levels "ALABAMA ",..: 1 1 1 1 1 1 1 1 1 1 ...
$ SEANAME : Factor w/ 56 levels "Alabama Department Of Education ",..: 1 1 1 1 1 1 1 1 1 1 ...
$ LEAID : Factor w/ 17396 levels "0100002","0100005",..: 1 1 1 1 1 1 2 2 2 2 ...
$ ST_LEAID : Factor w/ 15654 levels "00000000001894",..: 7682 7682 7682 7682 7682 7682 4562 4562 4562 4562 ...
$ LEA_NAME : Factor w/ 17063 levels "21st Century Charter Sch of Gary ",..: 192 192 192 192 192 192 225 225 225 225 ...
$ SCHID : Factor w/ 13122 levels "00001","00002",..: 277 1667 1670 1705 1706 1876 870 871 879 889 ...
$ ST_SCHID : Factor w/ 72390 levels "000 ",..: 1881 2657 2854 2083 2424 1278 1646 1881 6586 11246 ...
$ NCESSCH : Factor w/ 100184 levels "010000200277",..: 1 2 3 4 5 6 7 8 9 10 ...
$ SCH_NAME : Factor w/ 88474 levels "1 LT Charles W. Whitcomb School ",..: 71307 10786 19547 82696 50093 1079 1070 1242 24692 1241 ...
$ FTE : num -1 -1 -1 -1 -1 ...
$ ISFTEPUP : Factor w/ 3 levels "NOT APPLICAB",..: 3 3 3 3 3 3 3 3 3 3 ...
- attr(*, "variable.labels")= Named chr "Year corresponding to survey record" "American National Standards Institute (ANSI) state code" "Postal state abbreviation code" "State name" ...
..- attr(*, "names")= chr "SURVYEAR" "FIPST" "STABR" "STATENAME" ...
- attr(*, "codepage")= int 1252FTE - Before Recode
Min. 1st Qu. Median Mean 3rd Qu. Max.
-1.00 12.00 25.10 28.91 38.99 1245.00 FTE - After Recode '-1' as 'blank'
Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
0.01 17.50 28.00 32.84 41.02 1245.00 11621 Check number of records
[1] 100184Number of records
[1] 100187https://nces.ed.gov/ccd/xls/2014-15%20CCD%20Companion_SCH%20Free%20Lunch_File_Layout.xlsx
'data.frame': 100187 obs. of 16 variables:
$ SURVYEAR : Factor w/ 2 levels " ","2014-2015": 2 2 2 2 2 2 2 2 2 2 ...
$ FIPST : Factor w/ 56 levels "01","02","04",..: 1 1 1 1 1 1 1 1 1 1 ...
$ STABR : Factor w/ 56 levels "AK","AL","AR",..: 2 2 2 2 2 2 2 2 2 2 ...
$ STATENAME: Factor w/ 56 levels "ALABAMA ",..: 1 1 1 1 1 1 1 1 1 1 ...
$ SEANAME : Factor w/ 56 levels "Alabama Department Of Education ",..: 1 1 1 1 1 1 1 1 1 1 ...
$ LEAID : Factor w/ 17396 levels "0100002","0100005",..: 1 1 1 1 1 1 2 2 2 2 ...
$ ST_LEAID : Factor w/ 15654 levels "00000000001894",..: 7682 7682 7682 7682 7682 7682 4562 4562 4562 4562 ...
$ LEA_NAME : Factor w/ 17063 levels "21st Century Charter Sch of Gary ",..: 192 192 192 192 192 192 225 225 225 225 ...
$ SCHID : Factor w/ 13122 levels "00001","00002",..: 277 1667 1670 1705 1706 1876 870 871 879 889 ...
$ ST_SCHID : Factor w/ 72391 levels "000 ",..: 1881 2657 2854 2083 2424 1278 1646 1881 6586 11246 ...
$ NCESSCH : Factor w/ 100187 levels "010000200277",..: 1 2 3 4 5 6 7 8 9 10 ...
$ SCH_NAME : Factor w/ 88476 levels "1 LT Charles W. Whitcomb School ",..: 71309 10786 19548 82698 50095 1079 1070 1242 24693 1241 ...
$ TOTFRL : num -1 -1 -1 -1 -1 -1 280 370 326 396 ...
$ FRELCH : num -1 -1 -1 -1 -1 -1 280 370 326 396 ...
$ REDLCH : num -1 -1 -1 -1 -1 -1 0 0 0 0 ...
$ ISFLE : Factor w/ 3 levels "NOT APPLICAB",..: 3 3 3 3 3 3 3 3 3 3 ...
- attr(*, "variable.labels")= Named chr "Year corresponding to survey record" "American National Standards Institute (ANSI) state code" "Postal state abbreviation code" "State name" ...
..- attr(*, "names")= chr "SURVYEAR" "FIPST" "STABR" "STATENAME" ...
- attr(*, "codepage")= int 1252FTE - Before Recode
summary(sch.lunch$TOTFRL) # Summary of TOTFRL Min. 1st Qu. Median Mean 3rd Qu. Max.
-1.0 76.0 195.0 261.8 367.0 9343.0 summary(sch.lunch$FRELCH) # Summary of FRELCH Min. 1st Qu. Median Mean 3rd Qu. Max.
-1.0 54.0 156.0 224.7 318.0 9343.0 summary(sch.lunch$REDLCH) # Summary of REDLCH Min. 1st Qu. Median Mean 3rd Qu. Max.
-1.00 3.00 21.00 30.89 43.00 1804.00 After Recode '-1' as 'blank'
sch.lunch[sch.lunch == -1] <- NA
summary(sch.lunch$TOTFRL) # Summary of TOTFRL Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
0.0 85.0 202.0 269.7 374.0 9343.0 2912 summary(sch.lunch$FRELCH) # Summary of FRELCH Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
0.0 68.0 170.0 237.4 330.0 9343.0 5352 summary(sch.lunch$REDLCH) # Summary of REDLCH Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
0.00 6.00 23.00 32.69 45.00 1804.00 5352 Check number of records
[1] 100187Number of records
[1] 100187https://nces.ed.gov/ccd/xls/2014-15%20CCD%20Companion_School%20Membership_File_Layout.xlsx
'data.frame': 100187 obs. of 294 variables:
$ SURVYEAR : Factor w/ 1 level "2014-2015": 1 1 1 1 1 1 1 1 1 1 ...
$ FIPST : Factor w/ 56 levels "01","02","04",..: 1 1 1 1 1 1 1 1 1 1 ...
$ STABR : Factor w/ 56 levels "AK","AL","AR",..: 2 2 2 2 2 2 2 2 2 2 ...
$ STATENAME: Factor w/ 56 levels "ALABAMA ",..: 1 1 1 1 1 1 1 1 1 1 ...
$ SEANAME : Factor w/ 56 levels "Alabama Department Of Education ",..: 1 1 1 1 1 1 1 1 1 1 ...
$ LEAID : Factor w/ 17396 levels "0100002","0100005",..: 1 1 1 1 1 1 2 2 2 2 ...
$ ST_LEAID : Factor w/ 15654 levels "00000000001894",..: 7682 7682 7682 7682 7682 7682 4562 4562 4562 4562 ...
$ LEA_NAME : Factor w/ 17063 levels "21st Century Charter Sch of Gary ",..: 192 192 192 192 192 192 225 225 225 225 ...
$ SCHID : Factor w/ 13122 levels "00001","00002",..: 277 1667 1670 1705 1706 1876 870 871 879 889 ...
$ ST_SCHID : Factor w/ 72391 levels "000 ",..: 1881 2657 2854 2083 2424 1278 1646 1881 6586 11246 ...
$ NCESSCH : Factor w/ 100187 levels "010000200277",..: 1 2 3 4 5 6 7 8 9 10 ...
$ SCH_NAME : Factor w/ 88476 levels "1 LT Charles W. Whitcomb School ",..: 71309 10786 19548 82698 50095 1079 1070 1242 24693 1241 ...
$ PK : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ KG : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ G01 : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ G02 : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ G03 : num -2 -2 -2 -2 -2 -1 -2 -2 -2 419 ...
$ G04 : num -2 -2 -2 -2 -2 -1 -2 -2 -2 394 ...
$ G05 : num -2 -2 -2 -2 -2 -1 -2 -2 382 -2 ...
$ G06 : num -2 -2 -2 -2 -2 -1 -2 -2 366 -2 ...
$ G07 : num -1 -1 -1 -1 -1 -1 338 -2 -2 -2 ...
$ G08 : num -1 -1 -1 -1 -1 -1 339 -2 -2 -2 ...
$ G09 : num -1 -1 -1 -1 -1 -1 -2 332 -2 -2 ...
$ G10 : num -1 -1 -1 -1 -1 -1 -2 310 -2 -2 ...
$ G11 : num -1 -1 -1 -1 -1 -1 -2 293 -2 -2 ...
$ G12 : num -1 -1 -1 -1 -1 -1 -2 236 -2 -2 ...
$ G13 : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ UG : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ AE : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ TOTAL : num -1 -1 -1 -1 -1 ...
$ MEMBER : num -1 -1 -1 -1 -1 ...
$ AMPKM : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ AMPKF : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ ASPKM : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ ASPKF : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HIPKM : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HIPKF : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ BLPKM : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ BLPKF : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ WHPKM : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ WHPKF : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HPPKM : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HPPKF : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ TRPKM : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ TRPKF : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ AMKGM : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ AMKGF : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ ASKGM : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ ASKGF : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HIKGM : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HIKGF : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ BLKGM : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ BLKGF : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ WHKGM : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ WHKGF : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HPKGM : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HPKGF : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ TRKGM : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ TRKGF : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ AM01M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ AM01F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ AS01M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ AS01F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HI01M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HI01F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ BL01M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ BL01F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ WH01M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ WH01F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HP01M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HP01F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ TR01M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ TR01F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ AM02M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ AM02F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ AS02M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ AS02F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HI02M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HI02F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ BL02M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ BL02F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ WH02M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ WH02F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HP02M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ HP02F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ TR02M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ TR02F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 -2 ...
$ AM03M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 0 ...
$ AM03F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 0 ...
$ AS03M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 1 ...
$ AS03F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 1 ...
$ HI03M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 99 ...
$ HI03F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 101 ...
$ BL03M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 4 ...
$ BL03F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 5 ...
$ WH03M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 110 ...
$ WH03F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 85 ...
$ HP03M : num -2 -2 -2 -2 -2 -1 -2 -2 -2 0 ...
$ HP03F : num -2 -2 -2 -2 -2 -1 -2 -2 -2 0 ...
[list output truncated]
- attr(*, "variable.labels")= Named chr "Year corresponding to survey record" "American National Standards Institute (ANSI) state code" "Postal state abbreviation code" "State name" ...
..- attr(*, "names")= chr "SURVYEAR" "FIPST" "STABR" "STATENAME" ...
- attr(*, "codepage")= int 1252sch.member[sch.member == -1] <- NA
sch.member[sch.member == -2] <- NACheck number of records
[1] 100187Number of records
[1] 100184https://nces.ed.gov/ccd/xls/2014-15%20CCD%20Companion_SCH%20CCD%20School_File_Layout.xlsx
'data.frame': 100184 obs. of 20 variables:
$ SURVYEAR : Factor w/ 1 level "2014-2015": 1 1 1 1 1 1 1 1 1 1 ...
$ FIPST : Factor w/ 56 levels "01","02","04",..: 1 1 1 1 1 1 1 1 1 1 ...
$ STABR : Factor w/ 56 levels "AK","AL","AR",..: 2 2 2 2 2 2 2 2 2 2 ...
$ STATENAME : Factor w/ 56 levels "ALABAMA ",..: 1 1 1 1 1 1 1 1 1 1 ...
$ SEANAME : Factor w/ 56 levels "Alabama Department Of Education ",..: 1 1 1 1 1 1 1 1 1 1 ...
$ LEAID : Factor w/ 17396 levels "0100002","0100005",..: 1 1 1 1 1 1 2 2 2 2 ...
$ ST_LEAID : Factor w/ 15654 levels "00000000001894",..: 7682 7682 7682 7682 7682 7682 4562 4562 4562 4562 ...
$ LEA_NAME : Factor w/ 17063 levels "21st Century Charter Sch of Gary ",..: 192 192 192 192 192 192 225 225 225 225 ...
$ SCHID : Factor w/ 13122 levels "00001","00002",..: 277 1667 1670 1705 1706 1876 870 871 879 889 ...
$ ST_SCHID : Factor w/ 72390 levels "000 ",..: 1881 2657 2854 2083 2424 1278 1646 1881 6586 11246 ...
$ NCESSCH : Factor w/ 100184 levels "010000200277",..: 1 2 3 4 5 6 7 8 9 10 ...
$ SCH_NAME : Factor w/ 88474 levels "1 LT Charles W. Whitcomb School ",..: 71307 10786 19547 82696 50093 1079 1070 1242 24692 1241 ...
$ TITLEI_TEXT : Factor w/ 7 levels "MISSING ",..: 1 1 1 1 1 1 5 5 5 5 ...
$ TITLEI_STATUS : Factor w/ 7 levels "1","2","3","4",..: 7 7 7 7 7 7 5 5 5 5 ...
$ TITLEI : Factor w/ 4 levels "1","2","M","N": 3 3 3 3 3 3 1 1 1 1 ...
$ STITLEI : Factor w/ 4 levels "1","2","M","N": 3 3 3 3 3 3 1 1 1 1 ...
$ SHARED_TIME : Factor w/ 3 levels "MISSING","No ",..: 1 1 1 1 1 1 2 2 2 2 ...
$ MAGNET_TEXT : Factor w/ 4 levels "MISSING ",..: 1 1 1 1 1 1 2 2 2 2 ...
$ NSLPSTATUS_TEXT: Factor w/ 7 levels "MISSING ",..: 1 1 1 1 1 1 3 3 3 3 ...
$ NSLPSTATUS_CODE: Factor w/ 7 levels "CEO","M ","NO ",..: 2 2 2 2 2 2 4 4 4 4 ...
- attr(*, "variable.labels")= Named chr "Year corresponding to survey record" "American National Standards Institute (ANSI) state code" "Postal state abbreviation code" "State name" ...
..- attr(*, "names")= chr "SURVYEAR" "FIPST" "STABR" "STATENAME" ...
- attr(*, "codepage")= int 1252Number of records
[1] 102587SURVYEAR Year corresponding to survey record
NCESSCH NCES school identification number
FIPST FIPS state code
LSTREE Location address
LCITY Location city
LSTATE Location state abbreviation
LZIP Location ZIP
LZIP4 Location ZIP Plus 4
LATCODE Latitude of addressl location
LONGCODE Longitude of address location
CONUM FIPS county code based on the address location
CONAME County name based on address location
CD 114th Congressional District
LOCALE Locale code based on the location of the school: 11=City-Large, 12=City-Midsize, 13=City-Small, 21=Suburban-Large, 22=Suburban-Midsize, 23=Suburban-Small, 31=Town-Fringe, 32=Town-Distant, 33=Town-Remote, 41=Rural-Fringe, 42=Rural-Distant, 43=Rural-Remote
CSA Combined Statisical Area based on address location
CBSA Core Based Statistical Area based on the address location
NECTA New England City and Town Area based on address location
METMIC CBSA Type: 1=Metropolitan, 2=Micropolitan, 0=Not in CBSA
Classes 'tbl_df', 'tbl' and 'data.frame': 102587 obs. of 18 variables:
$ SURVYEAR: num 2014 2014 2014 2014 2014 ...
$ FIPST : num 1 1 1 1 1 1 1 1 1 1 ...
$ LSTREE : chr "1000 INDUSTRIAL SCHOOL ROAD" "315 OUTBACK ROAD" "1601 COUNTY RD. 57" "2109 BASHI RD, BLDG 509" ...
$ LCITY : chr "BIRMINGHAM" "CLAYTON" "PRATTVILLE" "THOMASVILLE" ...
$ LSTATE : chr "AL" "AL" "AL" "AL" ...
$ LZIP : num 35220 36016 36067 36784 36057 ...
$ LZIP4 : num 486 NA NA NA 66 ...
$ LATCODE : num 33.7 31.9 32.5 31.9 32.4 ...
$ LONGCODE: num -86.6 -85.3 -86.5 -87.8 -86.1 ...
$ CONUM : num 1073 1005 1001 1025 1101 ...
$ CONAME : chr "JEFFERSON COUNTY" "BARBOUR COUNTY" "AUTAUGA COUNTY" "CLARKE COUNTY" ...
$ CD : num 106 102 102 107 103 107 103 104 104 104 ...
$ LOCALE : num 21 42 41 41 41 12 41 32 32 32 ...
$ CSA : chr "142" "N" "N" "N" ...
$ CBSA : chr "13820" "N" "33860" "N" ...
$ NECTA : chr "N" "N" "N" "N" ...
$ METMIC : num 1 0 1 0 1 1 1 2 2 2 ...
$ NCESSCH : Factor w/ 102799 levels "010000200277",..: 1 2 3 4 5 6 7 8 9 10 ...