enrollments
Data source: Big Local News · About: Big Local
696 rows where grade = "grade_6", state = "OK" and year = 2017 sorted by ccd_school_low_grade
This data as json, CSV (advanced)
Link | rowid | state | county | county_state_id | admin_level | district_nces_id | district_state_id | district_state_type | district | school_nces_id | school_state_id | school | school_state_type | ccd_school_type | ccd_charter_school | ccd_school_lvl | ccd_school_low_grade ▼ | ccd_school_high_grade | year | term | grade | white | black | hispanic | native_american | native_american_alaskan_native | asian | native_hawaiian | asian_pacific_islander | native_hawaiian_pacific_islander | pacific_islander | multiracial | unknown_race | male | female | non_binary | unknown_gender | ell | ell_percent | homeless | homeless_percent | low_income | free_and_reduced | free_and_reduced_percent | disability | section_504 | total | white_int | black_int | hispanic_int | native_american_int | native_american_alaskan_native_int | asian_int | native_hawaiian_int | asian_pacific_islander_int | native_hawaiian_pacific_islander_int | pacific_islander_int | multiracial_int | unknown_race_int | male_int | female_int | non_binary_int | unknown_gender_int | ell_int | homeless_int | low_income_int | free_and_reduced_int | disability_int | section_504_int | total_int |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
484386 | 484386 | OK | TULSA | school | 4030240 | 72-I001 | TULSA | 403024002280 | 198 | GILCREASE ES | Elementary | Regular School | No | Elementary | 01 | 06 | 2017 | grade_6 | 3 | 14 | 6 | 3 | 0 | 0 | 10 | 23 | 13 | 36 | 3 | 14 | 6 | 3 | 0 | 0 | 10 | 23 | 13 | 36 | ||||||||||||||||||||||||||||||||
479693 | 479693 | OK | LINCOLN | school | 4007290 | 41-I001 | CHANDLER | 400729001709 | 120 | PARK ROAD ES | Elementary | Regular School | No | Elementary | 03 | 06 | 2017 | grade_6 | 51 | 7 | 1 | 10 | 0 | 0 | 25 | 50 | 44 | 94 | 51 | 7 | 1 | 10 | 0 | 0 | 25 | 50 | 44 | 94 | ||||||||||||||||||||||||||||||||
482094 | 482094 | OK | OKLAHOMA | school | 4000768 | 55-E002 | OKLAHOMA CITY | 400076802306 | 972 | JUSTICE A.W. SEEWORTH ACADEMY | Charter | Regular School | Yes | Other | 03 | 12 | 2017 | grade_6 | 2 | 9 | 5 | 0 | 0 | 0 | 0 | 11 | 5 | 16 | 2 | 9 | 5 | 0 | 0 | 0 | 0 | 11 | 5 | 16 | ||||||||||||||||||||||||||||||||
482240 | 482240 | OK | OKMULGEE | school | 4022800 | 56-I001 | OKMULGEE | 402280001211 | 145 | DUNBAR ES | Elementary | Regular School | No | Elementary | 03 | 06 | 2017 | grade_6 | 25 | 25 | 5 | 39 | 1 | 0 | 5 | 55 | 45 | 100 | 25 | 25 | 5 | 39 | 1 | 0 | 5 | 55 | 45 | 100 | ||||||||||||||||||||||||||||||||
482398 | 482398 | OK | OSAGE | school | 4023580 | 57-I002 | PAWHUSKA | 402358001251 | 115 | PAWHUSKA ES | Elementary | Regular School | No | Elementary | 03 | 08 | 2017 | grade_6 | 14 | 5 | 2 | 31 | 0 | 0 | 2 | 24 | 30 | 54 | 14 | 5 | 2 | 31 | 0 | 0 | 2 | 24 | 30 | 54 | ||||||||||||||||||||||||||||||||
484258 | 484258 | OK | TULSA | school | 4000772 | 72-G004 | SANKOFA MIDDLE SCHL (CHARTER) | 400077202769 | 974 | SANKOFA MIDDLE SCHOOL | Charter | Regular School | Yes | Elementary | 03 | 08 | 2017 | grade_6 | 0 | 14 | 1 | 0 | 0 | 0 | 0 | 9 | 6 | 15 | 0 | 14 | 1 | 0 | 0 | 0 | 0 | 9 | 6 | 15 | ||||||||||||||||||||||||||||||||
475961 | 475961 | OK | BRYAN | school | 4008220 | 07-I004 | COLBERT | 400822000342 | 105 | WARD ES EAST | Elementary | Regular School | No | Elementary | 04 | 06 | 2017 | grade_6 | 30 | 1 | 6 | 15 | 0 | 0 | 1 | 25 | 28 | 53 | 30 | 1 | 6 | 15 | 0 | 0 | 1 | 25 | 28 | 53 | ||||||||||||||||||||||||||||||||
476034 | 476034 | OK | BRYAN | school | 4010350 | 07-I072 | DURANT | 401035002112 | 125 | DURANT INTERMEDIATE ES | Elementary | Regular School | No | Elementary | 04 | 06 | 2017 | grade_6 | 149 | 4 | 28 | 47 | 3 | 1 | 20 | 129 | 123 | 252 | 149 | 4 | 28 | 47 | 3 | 1 | 20 | 129 | 123 | 252 | ||||||||||||||||||||||||||||||||
476385 | 476385 | OK | CANADIAN | school | 4021000 | 09-I069 | MUSTANG | 402100002782 | 145 | CANYON RIDGE IES | Elementary | Regular School | No | Elementary | 04 | 06 | 2017 | grade_6 | 276 | 20 | 63 | 26 | 33 | 3 | 46 | 251 | 216 | 467 | 276 | 20 | 63 | 26 | 33 | 3 | 46 | 251 | 216 | 467 | ||||||||||||||||||||||||||||||||
477853 | 477853 | OK | CREEK | school | 4016170 | 19-I031 | KELLYVILLE | 401617002340 | 110 | KELLYVILLE UPPER ES | Elementary | Regular School | No | Elementary | 04 | 06 | 2017 | grade_6 | 46 | 0 | 2 | 15 | 0 | 0 | 20 | 33 | 50 | 83 | 46 | 0 | 2 | 15 | 0 | 0 | 20 | 33 | 50 | 83 | ||||||||||||||||||||||||||||||||
478025 | 478025 | OK | DELAWARE | school | 4013530 | 21-I002 | GROVE | 401353000625 | 105 | GROVE UPPER ES | Elementary | Regular School | No | Elementary | 04 | 06 | 2017 | grade_6 | 98 | 2 | 15 | 65 | 1 | 0 | 0 | 94 | 87 | 181 | 98 | 2 | 15 | 65 | 1 | 0 | 0 | 94 | 87 | 181 | ||||||||||||||||||||||||||||||||
478443 | 478443 | OK | GARVIN | school | 4023550 | 25-I018 | PAULS VALLEY | 402355001248 | 115 | LEE ES | Elementary | Regular School | No | Elementary | 04 | 06 | 2017 | grade_6 | 41 | 7 | 14 | 16 | 0 | 0 | 0 | 39 | 39 | 78 | 41 | 7 | 14 | 16 | 0 | 0 | 0 | 39 | 39 | 78 | ||||||||||||||||||||||||||||||||
478862 | 478862 | OK | HUGHES | school | 4014790 | 32-I035 | HOLDENVILLE | 401479002673 | 130 | THOMAS IES | Elementary | Regular School | No | Elementary | 04 | 08 | 2017 | grade_6 | 40 | 7 | 5 | 26 | 0 | 1 | 0 | 44 | 35 | 79 | 40 | 7 | 5 | 26 | 0 | 1 | 0 | 44 | 35 | 79 | ||||||||||||||||||||||||||||||||
479374 | 479374 | OK | KIOWA | school | 4027930 | 38-I004 | SNYDER | 402793001481 | 105 | SNYDER ES | Elementary | Regular School | No | Elementary | 04 | 08 | 2017 | grade_6 | 18 | 0 | 9 | 3 | 0 | 0 | 1 | 19 | 12 | 31 | 18 | 0 | 9 | 3 | 0 | 0 | 1 | 19 | 12 | 31 | ||||||||||||||||||||||||||||||||
479811 | 479811 | OK | LOGAN | school | 4013560 | 42-I001 | GUTHRIE | 401356000631 | 125 | GUTHRIE UPPER ES | Elementary | Regular School | No | Elementary | 04 | 06 | 2017 | grade_6 | 151 | 19 | 41 | 8 | 1 | 1 | 25 | 126 | 120 | 246 | 151 | 19 | 41 | 8 | 1 | 1 | 25 | 126 | 120 | 246 | ||||||||||||||||||||||||||||||||
483009 | 483009 | OK | PONTOTOC | school | 4006060 | 62-I016 | BYNG | 400606000230 | 105 | BYNG ES | Elementary | Regular School | No | Elementary | 04 | 06 | 2017 | grade_6 | 49 | 3 | 4 | 44 | 0 | 0 | 18 | 55 | 63 | 118 | 49 | 3 | 4 | 44 | 0 | 0 | 18 | 55 | 63 | 118 | ||||||||||||||||||||||||||||||||
483596 | 483596 | OK | ROGERS | school | 4031110 | 66-I008 | VERDIGRIS | 403111002758 | 305 | VERDIGRIS UPPER ES | Elementary | Regular School | No | Elementary | 04 | 06 | 2017 | grade_6 | 58 | 0 | 6 | 25 | 2 | 0 | 3 | 51 | 43 | 94 | 58 | 0 | 6 | 25 | 2 | 0 | 3 | 51 | 43 | 94 | ||||||||||||||||||||||||||||||||
483621 | 483621 | OK | SEMINOLE | school | 4027300 | 67-I001 | SEMINOLE | 402730001440 | 110 | NORTHWOOD ES | Elementary | Regular School | No | Elementary | 04 | 06 | 2017 | grade_6 | 57 | 8 | 9 | 20 | 0 | 0 | 22 | 59 | 57 | 116 | 57 | 8 | 9 | 20 | 0 | 0 | 22 | 59 | 57 | 116 | ||||||||||||||||||||||||||||||||
484763 | 484763 | OK | TULSA | school | 4000793 | 72-E019 | TULSA | 400079302818 | 979 | COLLEGIATE HALL CHARTER SCHOOL | Charter | Regular School | Yes | Elementary | 04 | 06 | 2017 | grade_6 | 12 | 15 | 9 | 4 | 0 | 2 | 7 | 23 | 26 | 49 | 12 | 15 | 9 | 4 | 0 | 2 | 7 | 23 | 26 | 49 | ||||||||||||||||||||||||||||||||
484928 | 484928 | OK | TULSA | school | 4004500 | 72-I004 | BIXBY | 400450002665 | 130 | NORTH INTERMEDIATE SCHOOL | Elementary | Regular School | No | Elementary | 04 | 06 | 2017 | grade_6 | 129 | 0 | 21 | 10 | 4 | 0 | 17 | 102 | 79 | 181 | 129 | 0 | 21 | 10 | 4 | 0 | 17 | 102 | 79 | 181 | ||||||||||||||||||||||||||||||||
484931 | 484931 | OK | TULSA | school | 4004500 | 72-I004 | BIXBY | 400450002748 | 140 | CENTRAL INTERMEDIATE SCHOOL | Elementary | Regular School | No | Elementary | 04 | 06 | 2017 | grade_6 | 127 | 4 | 14 | 19 | 3 | 0 | 18 | 105 | 80 | 185 | 127 | 4 | 14 | 19 | 3 | 0 | 18 | 105 | 80 | 185 | ||||||||||||||||||||||||||||||||
485256 | 485256 | OK | WAGONER | school | 4008850 | 73-I017 | COWETA | 400885029814 | 205 | MISSION INTERMEDIATE GRD CTR | Elementary | Regular School | No | Elementary | 04 | 06 | 2017 | grade_6 | 75 | 1 | 9 | 34 | 3 | 1 | 2 | 67 | 58 | 125 | 75 | 1 | 9 | 34 | 3 | 1 | 2 | 67 | 58 | 125 | ||||||||||||||||||||||||||||||||
485259 | 485259 | OK | WAGONER | school | 4008850 | 73-I017 | COWETA | 400885002697 | 210 | HERITAGE INTERMEDIATE GRD CTR | Elementary | Regular School | No | Elementary | 04 | 06 | 2017 | grade_6 | 68 | 4 | 8 | 43 | 1 | 0 | 2 | 72 | 54 | 126 | 68 | 4 | 8 | 43 | 1 | 0 | 2 | 72 | 54 | 126 | ||||||||||||||||||||||||||||||||
475602 | 475602 | OK | ADAIR | school | 4028710 | 01-I025 | STILWELL | 402871001513 | 505 | STILWELL MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 12 | 0 | 10 | 34 | 0 | 0 | 2 | 35 | 23 | 58 | 12 | 0 | 10 | 34 | 0 | 0 | 2 | 35 | 23 | 58 | ||||||||||||||||||||||||||||||||
475616 | 475616 | OK | ADAIR | school | 4006930 | 01-I030 | CAVE SPRINGS | 400693002823 | 505 | CAVE SPRINGS MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 1 | 0 | 1 | 8 | 0 | 0 | 0 | 5 | 5 | 10 | 1 | 0 | 1 | 8 | 0 | 0 | 0 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||
475821 | 475821 | OK | BECKHAM | school | 4010740 | 05-I006 | ELK CITY | 401074000498 | 115 | GRANDVIEW 5TH/6TH GRADE CTR | Elementary | Regular School | No | Middle | 05 | 06 | 2017 | grade_6 | 106 | 2 | 31 | 7 | 3 | 0 | 13 | 83 | 79 | 162 | 106 | 2 | 31 | 7 | 3 | 0 | 13 | 83 | 79 | 162 | ||||||||||||||||||||||||||||||||
476261 | 476261 | OK | CANADIAN | school | 4023970 | 09-I022 | PIEDMONT | 402397002759 | 125 | PIEDMONT INTERMEDIATE ES | Elementary | Regular School | No | Middle | 05 | 06 | 2017 | grade_6 | 184 | 7 | 20 | 34 | 13 | 1 | 12 | 142 | 129 | 271 | 184 | 7 | 20 | 34 | 13 | 1 | 12 | 142 | 129 | 271 | ||||||||||||||||||||||||||||||||
476326 | 476326 | OK | CANADIAN | school | 4010650 | 09-I034 | EL RENO | 401065002103 | 510 | LESLIE F ROBLYER LEARNING CTR | Middle | Regular School | No | Middle | 05 | 06 | 2017 | grade_6 | 87 | 6 | 37 | 16 | 0 | 1 | 15 | 78 | 84 | 162 | 87 | 6 | 37 | 16 | 0 | 1 | 15 | 78 | 84 | 162 | ||||||||||||||||||||||||||||||||
476383 | 476383 | OK | CANADIAN | school | 4021000 | 09-I069 | MUSTANG | 402100002767 | 140 | MUSTANG HORIZON IES | Elementary | Regular School | No | Middle | 05 | 06 | 2017 | grade_6 | 248 | 9 | 45 | 21 | 3 | 1 | 25 | 185 | 167 | 352 | 248 | 9 | 45 | 21 | 3 | 1 | 25 | 185 | 167 | 352 | ||||||||||||||||||||||||||||||||
477351 | 477351 | OK | COMANCHE | school | 4006120 | 16-I001 | CACHE | 400612002757 | 530 | CACHE 5TH AND 6TH GRADE MS | Middle | Regular School | No | Middle | 05 | 06 | 2017 | grade_6 | 76 | 13 | 17 | 29 | 3 | 1 | 11 | 69 | 81 | 150 | 76 | 13 | 17 | 29 | 3 | 1 | 11 | 69 | 81 | 150 | ||||||||||||||||||||||||||||||||
477568 | 477568 | OK | COMANCHE | school | 4010710 | 16-I016 | ELGIN | 401071001980 | 505 | ELGIN MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 112 | 7 | 19 | 16 | 0 | 0 | 14 | 78 | 90 | 168 | 112 | 7 | 19 | 16 | 0 | 0 | 14 | 78 | 90 | 168 | ||||||||||||||||||||||||||||||||
477961 | 477961 | OK | CUSTER | school | 4008070 | 20-I099 | CLINTON | 400807000338 | 120 | WASHINGTON ES | Elementary | Regular School | No | Middle | 05 | 06 | 2017 | grade_6 | 46 | 8 | 87 | 10 | 1 | 0 | 10 | 73 | 89 | 162 | 46 | 8 | 87 | 10 | 1 | 0 | 10 | 73 | 89 | 162 | ||||||||||||||||||||||||||||||||
478457 | 478457 | OK | GARVIN | school | 4033300 | 25-I038 | WYNNEWOOD | 403330001835 | 500 | WYNNEWOOD MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 32 | 5 | 4 | 5 | 0 | 0 | 3 | 34 | 15 | 49 | 32 | 5 | 4 | 5 | 0 | 0 | 3 | 34 | 15 | 49 | ||||||||||||||||||||||||||||||||
478514 | 478514 | OK | GRADY | school | 4007560 | 26-I001 | CHICKASHA | 400756002373 | 115 | LINCOLN ES | Elementary | Regular School | No | Middle | 05 | 06 | 2017 | grade_6 | 94 | 16 | 18 | 22 | 2 | 0 | 18 | 91 | 79 | 170 | 94 | 16 | 18 | 22 | 2 | 0 | 18 | 91 | 79 | 170 | ||||||||||||||||||||||||||||||||
478662 | 478662 | OK | GRANT | school | 4024720 | 27-I090 | POND CREEK-HUNTER | 402472002764 | 505 | POND CREEK-HUNTER MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 21 | 0 | 0 | 1 | 0 | 0 | 2 | 14 | 10 | 24 | 21 | 0 | 0 | 1 | 0 | 0 | 2 | 14 | 10 | 24 | ||||||||||||||||||||||||||||||||
478691 | 478691 | OK | GREER | school | 4018780 | 28-I001 | MANGUM | 401878002321 | 510 | MANGUM MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 40 | 1 | 15 | 0 | 0 | 0 | 4 | 26 | 34 | 60 | 40 | 1 | 15 | 0 | 0 | 0 | 4 | 26 | 34 | 60 | ||||||||||||||||||||||||||||||||
478791 | 478791 | OK | HASKELL | school | 4028650 | 31-I020 | STIGLER | 402865001504 | 505 | STIGLER MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 54 | 0 | 4 | 8 | 0 | 0 | 26 | 46 | 46 | 92 | 54 | 0 | 4 | 8 | 0 | 0 | 26 | 46 | 46 | 92 | ||||||||||||||||||||||||||||||||
478932 | 478932 | OK | JACKSON | school | 4002850 | 33-I018 | ALTUS | 400285002365 | 145 | ALTUS INTERMEDIATE SCHOOL | Elementary | Regular School | No | Middle | 05 | 06 | 2017 | grade_6 | 89 | 13 | 92 | 4 | 4 | 1 | 17 | 117 | 103 | 220 | 89 | 13 | 92 | 4 | 4 | 1 | 17 | 117 | 103 | 220 | ||||||||||||||||||||||||||||||||
479081 | 479081 | OK | JOHNSTON | school | 4030060 | 35-I020 | TISHOMINGO | 403006001574 | 505 | TISHOMINGO MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 30 | 1 | 11 | 13 | 0 | 0 | 24 | 39 | 40 | 79 | 30 | 1 | 11 | 13 | 0 | 0 | 24 | 39 | 40 | 79 | ||||||||||||||||||||||||||||||||
479237 | 479237 | OK | KAY | school | 4021540 | 36-I125 | NEWKIRK | 402154001986 | 505 | NEWKIRK MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 37 | 0 | 2 | 14 | 0 | 0 | 1 | 28 | 26 | 54 | 37 | 0 | 2 | 14 | 0 | 0 | 1 | 28 | 26 | 54 | ||||||||||||||||||||||||||||||||
479280 | 479280 | OK | KINGFISHER | school | 4016560 | 37-I007 | KINGFISHER | 401656001879 | 505 | KINGFISHER MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 57 | 0 | 25 | 8 | 1 | 0 | 7 | 49 | 49 | 98 | 57 | 0 | 25 | 8 | 1 | 0 | 7 | 49 | 49 | 98 | ||||||||||||||||||||||||||||||||
479294 | 479294 | OK | KINGFISHER | school | 4014340 | 37-I016 | HENNESSEY | 401434001917 | 110 | HENNESSEY UPPER ES | Elementary | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 25 | 2 | 21 | 1 | 0 | 0 | 0 | 23 | 26 | 49 | 25 | 2 | 21 | 1 | 0 | 0 | 0 | 23 | 26 | 49 | ||||||||||||||||||||||||||||||||
480421 | 480421 | OK | MCINTOSH | school | 4007350 | 49-I019 | CHECOTAH | 400735001859 | 505 | CHECOTAH MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 41 | 4 | 2 | 32 | 0 | 1 | 16 | 43 | 53 | 96 | 41 | 4 | 2 | 32 | 0 | 1 | 16 | 43 | 53 | 96 | ||||||||||||||||||||||||||||||||
480479 | 480479 | OK | MURRAY | school | 4009510 | 50-I010 | DAVIS | 400951000411 | 505 | DAVIS MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 49 | 1 | 6 | 23 | 0 | 1 | 6 | 35 | 51 | 86 | 49 | 1 | 6 | 23 | 0 | 1 | 6 | 35 | 51 | 86 | ||||||||||||||||||||||||||||||||
480857 | 480857 | OK | OKFUSKEE | school | 4000782 | 54-I054 | GRAHAM-DUSTIN | 400078200608 | 105 | GRAHAM ES | Elementary | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 4 | 0 | 2 | 2 | 0 | 0 | 1 | 4 | 5 | 9 | 4 | 0 | 2 | 2 | 0 | 0 | 1 | 4 | 5 | 9 | ||||||||||||||||||||||||||||||||
481062 | 481062 | OK | OKLAHOMA | school | 4018630 | 55-I003 | LUTHER | 401863001949 | 505 | LUTHER MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 36 | 4 | 8 | 3 | 1 | 0 | 7 | 30 | 29 | 59 | 36 | 4 | 8 | 3 | 1 | 0 | 7 | 30 | 29 | 59 | ||||||||||||||||||||||||||||||||
481135 | 481135 | OK | OKLAHOMA | school | 4009570 | 55-I006 | DEER CREEK | 400957002749 | 125 | DEER CREEK INTERMEDIATE SCHOOL | Elementary | Regular School | No | Middle | 05 | 06 | 2017 | grade_6 | 310 | 39 | 32 | 44 | 32 | 1 | 4 | 219 | 243 | 462 | 310 | 39 | 32 | 44 | 32 | 1 | 4 | 219 | 243 | 462 | ||||||||||||||||||||||||||||||||
481377 | 481377 | OK | OKLAHOMA | school | 4032370 | 55-I041 | WESTERN HEIGHTS | 403237002729 | 120 | BRIDGESTONE ES | Elementary | Regular School | No | Middle | 05 | 06 | 2017 | grade_6 | 46 | 43 | 75 | 15 | 5 | 2 | 11 | 93 | 104 | 197 | 46 | 43 | 75 | 15 | 5 | 2 | 11 | 93 | 104 | 197 | ||||||||||||||||||||||||||||||||
482128 | 482128 | OK | OKLAHOMA | school | 4000766 | 55-E012 | OKLAHOMA CITY | 400076602408 | 982 | KIPP REACH COLLEGE PREPARATORY | Charter | Regular School | Yes | Middle | 05 | 08 | 2017 | grade_6 | 2 | 51 | 7 | 1 | 1 | 0 | 4 | 36 | 30 | 66 | 2 | 51 | 7 | 1 | 1 | 0 | 4 | 36 | 30 | 66 | ||||||||||||||||||||||||||||||||
482282 | 482282 | OK | OKMULGEE | school | 4003810 | 56-I004 | BEGGS | 400381000120 | 505 | BEGGS MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 41 | 7 | 6 | 10 | 0 | 0 | 14 | 40 | 38 | 78 | 41 | 7 | 6 | 10 | 0 | 0 | 14 | 40 | 38 | 78 | ||||||||||||||||||||||||||||||||
482414 | 482414 | OK | OSAGE | school | 4027630 | 57-I011 | SHIDLER | 402763002689 | 505 | SHIDLER MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 14 | 0 | 0 | 5 | 0 | 0 | 0 | 10 | 9 | 19 | 14 | 0 | 0 | 5 | 0 | 0 | 0 | 10 | 9 | 19 | ||||||||||||||||||||||||||||||||
482484 | 482484 | OK | OSAGE | school | 4030048 | 57-I090 | WOODLAND | 403004829729 | 110 | WOODLAND UPPER ES | Elementary | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 12 | 0 | 0 | 13 | 0 | 0 | 0 | 13 | 12 | 25 | 12 | 0 | 0 | 13 | 0 | 0 | 0 | 13 | 12 | 25 | ||||||||||||||||||||||||||||||||
482739 | 482739 | OK | PAYNE | school | 4009240 | 60-I067 | CUSHING | 400924000388 | 505 | CUSHING MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 81 | 2 | 13 | 29 | 1 | 0 | 8 | 61 | 73 | 134 | 81 | 2 | 13 | 29 | 1 | 0 | 8 | 61 | 73 | 134 | ||||||||||||||||||||||||||||||||
482970 | 482970 | OK | PITTSBURG | school | 4019440 | 61-I080 | MCALESTER | 401944002388 | 150 | PARKER INTERMEDIATE CTR | Elementary | Regular School | No | Middle | 05 | 06 | 2017 | grade_6 | 94 | 10 | 28 | 25 | 1 | 1 | 28 | 97 | 90 | 187 | 94 | 10 | 28 | 25 | 1 | 1 | 28 | 97 | 90 | 187 | ||||||||||||||||||||||||||||||||
483038 | 483038 | OK | PONTOTOC | school | 4002430 | 62-I019 | ADA | 400243000008 | 130 | WILLARD ES | Elementary | Regular School | No | Middle | 05 | 06 | 2017 | grade_6 | 64 | 4 | 19 | 41 | 2 | 1 | 16 | 84 | 63 | 147 | 64 | 4 | 19 | 41 | 2 | 1 | 16 | 84 | 63 | 147 | ||||||||||||||||||||||||||||||||
483066 | 483066 | OK | PONTOTOC | school | 4028800 | 62-I030 | STONEWALL | 402880002389 | 515 | MCLISH MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 13 | 0 | 0 | 13 | 0 | 0 | 2 | 14 | 14 | 28 | 13 | 0 | 0 | 13 | 0 | 0 | 2 | 14 | 14 | 28 | ||||||||||||||||||||||||||||||||
483840 | 483840 | OK | SEQUOYAH | school | 4020880 | 68-I003 | MULDROW | 402088001967 | 510 | MULDROW MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_6 | 43 | 4 | 7 | 39 | 2 | 0 | 4 | 60 | 39 | 99 | 43 | 4 | 7 | 39 | 2 | 0 | 4 | 60 | 39 | 99 | ||||||||||||||||||||||||||||||||
484083 | 484083 | OK | TEXAS | school | 4013590 | 70-I008 | GUYMON | 401359002108 | 135 | NORTH PARK ES | Elementary | Regular School | No | Middle | 05 | 06 | 2017 | grade_6 | 43 | 5 | 151 | 1 | 10 | 0 | 1 | 103 | 108 | 211 | 43 | 5 | 151 | 1 | 10 | 0 | 1 | 103 | 108 | 211 | ||||||||||||||||||||||||||||||||
484744 | 484744 | OK | TULSA | school | 4000780 | 72-E005 | TULSA | 400078002744 | 975 | KIPP TULSA ACAD. COLLEGE PREP. | Charter | Regular School | Yes | Middle | 05 | 08 | 2017 | grade_6 | 1 | 69 | 2 | 0 | 0 | 0 | 5 | 39 | 38 | 77 | 1 | 69 | 2 | 0 | 0 | 0 | 5 | 39 | 38 | 77 | ||||||||||||||||||||||||||||||||
484760 | 484760 | OK | TULSA | school | 4000792 | 72-E018 | TULSA | 400079202822 | 978 | TULSA HONOR ACADEMY CHARTER | Charter | Regular School | Yes | Middle | 05 | 06 | 2017 | grade_6 | 4 | 7 | 81 | 2 | 0 | 0 | 4 | 54 | 44 | 98 | 4 | 7 | 81 | 2 | 0 | 0 | 4 | 54 | 44 | 98 | ||||||||||||||||||||||||||||||||
484968 | 484968 | OK | TULSA | school | 4015720 | 72-I005 | JENKS | 401572002251 | 125 | JENKS WEST INTERMEDIATE ES | Elementary | Regular School | No | Middle | 05 | 06 | 2017 | grade_6 | 215 | 17 | 37 | 33 | 13 | 0 | 33 | 192 | 156 | 348 | 215 | 17 | 37 | 33 | 13 | 0 | 33 | 192 | 156 | 348 | ||||||||||||||||||||||||||||||||
484970 | 484970 | OK | TULSA | school | 4015720 | 72-I005 | JENKS | 401572002314 | 130 | JENKS EAST INTERMEDIATE ES | Elementary | Regular School | No | Middle | 05 | 06 | 2017 | grade_6 | 248 | 40 | 81 | 16 | 58 | 0 | 36 | 257 | 222 | 479 | 248 | 40 | 81 | 16 | 58 | 0 | 36 | 257 | 222 | 479 | ||||||||||||||||||||||||||||||||
475645 | 475645 | OK | ALFALFA | school | 4007410 | 02-I046 | CHEROKEE | 400741002745 | 510 | CHEROKEE MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 30 | 0 | 3 | 2 | 0 | 0 | 1 | 20 | 16 | 36 | 30 | 0 | 3 | 2 | 0 | 0 | 1 | 20 | 16 | 36 | ||||||||||||||||||||||||||||||||
475839 | 475839 | OK | BECKHAM | school | 4027060 | 05-I031 | SAYRE | 402706002268 | 505 | SAYRE MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 42 | 0 | 10 | 0 | 0 | 0 | 2 | 32 | 22 | 54 | 42 | 0 | 10 | 0 | 0 | 0 | 2 | 32 | 22 | 54 | ||||||||||||||||||||||||||||||||
475882 | 475882 | OK | BLAINE | school | 4031770 | 06-I042 | WATONGA | 403177001759 | 505 | WATONGA MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 29 | 1 | 8 | 10 | 0 | 0 | 4 | 24 | 28 | 52 | 29 | 1 | 8 | 10 | 0 | 0 | 4 | 24 | 28 | 52 | ||||||||||||||||||||||||||||||||
475896 | 475896 | OK | BLAINE | school | 4012570 | 06-I080 | GEARY | 401257000588 | 500 | GEARY MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 10 | 1 | 5 | 12 | 0 | 0 | 0 | 13 | 15 | 28 | 10 | 1 | 5 | 12 | 0 | 0 | 0 | 13 | 15 | 28 | ||||||||||||||||||||||||||||||||
475924 | 475924 | OK | BRYAN | school | 4027640 | 07-I001 | SILO | 402764001471 | 515 | SILO MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 47 | 1 | 1 | 17 | 0 | 0 | 7 | 36 | 37 | 73 | 47 | 1 | 1 | 17 | 0 | 0 | 7 | 36 | 37 | 73 | ||||||||||||||||||||||||||||||||
476049 | 476049 | OK | CADDO | school | 4000032 | 08-I011 | HYDRO-EAKLY | 400003202357 | 505 | HYDRO-EAKLY MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 24 | 1 | 5 | 1 | 0 | 0 | 1 | 17 | 15 | 32 | 24 | 1 | 5 | 1 | 0 | 0 | 1 | 17 | 15 | 32 | ||||||||||||||||||||||||||||||||
476078 | 476078 | OK | CADDO | school | 4003000 | 08-I020 | ANADARKO | 400300002101 | 510 | ANADARKO MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 20 | 1 | 27 | 76 | 0 | 0 | 1 | 65 | 60 | 125 | 20 | 1 | 27 | 76 | 0 | 0 | 1 | 65 | 60 | 125 | ||||||||||||||||||||||||||||||||
476107 | 476107 | OK | CADDO | school | 4005010 | 08-I056 | BOONE-APACHE | 400501005012 | 505 | APACHE MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 15 | 0 | 2 | 14 | 1 | 0 | 8 | 24 | 16 | 40 | 15 | 0 | 2 | 14 | 1 | 0 | 8 | 24 | 16 | 40 | ||||||||||||||||||||||||||||||||
476164 | 476164 | OK | CADDO | school | 4014610 | 08-I161 | HINTON | 401461000096 | 610 | HINTON MS | Junior High | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 43 | 1 | 11 | 7 | 0 | 0 | 1 | 25 | 38 | 63 | 43 | 1 | 11 | 7 | 0 | 0 | 1 | 25 | 38 | 63 | ||||||||||||||||||||||||||||||||
476178 | 476178 | OK | CADDO | school | 4033602 | 08-I167 | FORT COBB-BROXTON | 403360201597 | 505 | FORT COBB-BROXTON MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 12 | 0 | 0 | 5 | 0 | 0 | 4 | 11 | 10 | 21 | 12 | 0 | 0 | 5 | 0 | 0 | 4 | 11 | 10 | 21 | ||||||||||||||||||||||||||||||||
476312 | 476312 | OK | CANADIAN | school | 4033480 | 09-I027 | YUKON | 403348002723 | 520 | YUKON MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 457 | 22 | 88 | 42 | 19 | 0 | 22 | 339 | 311 | 650 | 457 | 22 | 88 | 42 | 19 | 0 | 22 | 339 | 311 | 650 | ||||||||||||||||||||||||||||||||
476445 | 476445 | OK | CARTER | school | 4003180 | 10-I019 | ARDMORE | 400318029636 | 505 | ARDMORE MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 102 | 27 | 35 | 10 | 2 | 1 | 3 | 84 | 96 | 180 | 102 | 27 | 35 | 10 | 2 | 1 | 3 | 84 | 96 | 180 | ||||||||||||||||||||||||||||||||
476473 | 476473 | OK | CARTER | school | 4024240 | 10-I027 | PLAINVIEW | 402424001279 | 505 | PLAINVIEW MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 73 | 4 | 12 | 11 | 9 | 0 | 14 | 72 | 51 | 123 | 73 | 4 | 12 | 11 | 9 | 0 | 14 | 72 | 51 | 123 | ||||||||||||||||||||||||||||||||
476488 | 476488 | OK | CARTER | school | 4018090 | 10-I032 | LONE GROVE | 401809000869 | 505 | LONE GROVE MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 65 | 4 | 8 | 20 | 0 | 0 | 14 | 64 | 47 | 111 | 65 | 4 | 8 | 20 | 0 | 0 | 14 | 64 | 47 | 111 | ||||||||||||||||||||||||||||||||
476516 | 476516 | OK | CARTER | school | 4014130 | 10-I055 | HEALDTON | 401413001863 | 505 | HEALDTON MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 21 | 0 | 3 | 5 | 0 | 0 | 2 | 17 | 14 | 31 | 21 | 0 | 3 | 5 | 0 | 0 | 2 | 17 | 14 | 31 | ||||||||||||||||||||||||||||||||
476544 | 476544 | OK | CARTER | school | 4009910 | 10-I077 | DICKSON | 400991002667 | 510 | DICKSON MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 62 | 2 | 2 | 19 | 0 | 0 | 3 | 49 | 39 | 88 | 62 | 2 | 2 | 19 | 0 | 0 | 3 | 49 | 39 | 88 | ||||||||||||||||||||||||||||||||
476653 | 476653 | OK | CHEROKEE | school | 4015240 | 11-I016 | HULBERT | 401524000101 | 615 | HULBERT JR-SR HS (JR) | Junior High | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 10 | 0 | 1 | 25 | 0 | 0 | 0 | 13 | 23 | 36 | 10 | 0 | 1 | 25 | 0 | 0 | 0 | 13 | 23 | 36 | ||||||||||||||||||||||||||||||||
476680 | 476680 | OK | CHEROKEE | school | 4029380 | 11-I035 | TAHLEQUAH | 402938002401 | 520 | TAHLEQUAH MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 52 | 3 | 43 | 109 | 2 | 0 | 18 | 117 | 110 | 227 | 52 | 3 | 43 | 109 | 2 | 0 | 18 | 117 | 110 | 227 | ||||||||||||||||||||||||||||||||
476758 | 476758 | OK | CHOCTAW | school | 4015210 | 12-I039 | HUGO | 401521002670 | 510 | HUGO MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 29 | 32 | 4 | 23 | 0 | 0 | 1 | 54 | 35 | 89 | 29 | 32 | 4 | 23 | 0 | 0 | 1 | 54 | 35 | 89 | ||||||||||||||||||||||||||||||||
477214 | 477214 | OK | CLEVELAND | school | 4021720 | 14-I029 | NORMAN | 402172001073 | 500 | IRVING MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 123 | 20 | 36 | 16 | 4 | 0 | 41 | 120 | 120 | 240 | 123 | 20 | 36 | 16 | 4 | 0 | 41 | 120 | 120 | 240 | ||||||||||||||||||||||||||||||||
477217 | 477217 | OK | CLEVELAND | school | 4021720 | 14-I029 | NORMAN | 402172002117 | 501 | ALCOTT MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 126 | 17 | 38 | 11 | 5 | 0 | 35 | 141 | 91 | 232 | 126 | 17 | 38 | 11 | 5 | 0 | 35 | 141 | 91 | 232 | ||||||||||||||||||||||||||||||||
477220 | 477220 | OK | CLEVELAND | school | 4021720 | 14-I029 | NORMAN | 402172001078 | 502 | LONGFELLOW MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 157 | 15 | 23 | 12 | 8 | 1 | 31 | 145 | 102 | 247 | 157 | 15 | 23 | 12 | 8 | 1 | 31 | 145 | 102 | 247 | ||||||||||||||||||||||||||||||||
477223 | 477223 | OK | CLEVELAND | school | 4021720 | 14-I029 | NORMAN | 402172001085 | 504 | WHITTIER MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 231 | 11 | 55 | 16 | 10 | 0 | 47 | 199 | 171 | 370 | 231 | 11 | 55 | 16 | 10 | 0 | 47 | 199 | 171 | 370 | ||||||||||||||||||||||||||||||||
477249 | 477249 | OK | CLEVELAND | school | 4021630 | 14-I040 | NOBLE | 402163002370 | 510 | CURTIS INGE MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 153 | 2 | 8 | 30 | 0 | 0 | 4 | 106 | 91 | 197 | 153 | 2 | 8 | 30 | 0 | 0 | 4 | 106 | 91 | 197 | ||||||||||||||||||||||||||||||||
477263 | 477263 | OK | CLEVELAND | school | 4017580 | 14-I057 | LEXINGTON | 401758002678 | 510 | LEXINGTON MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 43 | 1 | 6 | 10 | 0 | 0 | 5 | 33 | 32 | 65 | 43 | 1 | 6 | 10 | 0 | 0 | 5 | 33 | 32 | 65 | ||||||||||||||||||||||||||||||||
477277 | 477277 | OK | CLEVELAND | school | 4017880 | 14-I070 | LITTLE AXE | 401788000103 | 505 | LITTLE AXE MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 74 | 0 | 5 | 12 | 0 | 0 | 10 | 50 | 51 | 101 | 74 | 0 | 5 | 12 | 0 | 0 | 10 | 50 | 51 | 101 | ||||||||||||||||||||||||||||||||
477520 | 477520 | OK | COMANCHE | school | 4017250 | 16-I008 | LAWTON | 401725002364 | 530 | MACARTHUR MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 119 | 48 | 39 | 18 | 5 | 2 | 17 | 136 | 112 | 248 | 119 | 48 | 39 | 18 | 5 | 2 | 17 | 136 | 112 | 248 | ||||||||||||||||||||||||||||||||
477523 | 477523 | OK | COMANCHE | school | 4017250 | 16-I008 | LAWTON | 401725002393 | 535 | CENTRAL MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 105 | 61 | 60 | 20 | 3 | 0 | 22 | 133 | 138 | 271 | 105 | 61 | 60 | 20 | 3 | 0 | 22 | 133 | 138 | 271 | ||||||||||||||||||||||||||||||||
477527 | 477527 | OK | COMANCHE | school | 4017250 | 16-I008 | LAWTON | 401725002404 | 540 | TOMLINSON MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 85 | 60 | 56 | 16 | 2 | 2 | 29 | 129 | 121 | 250 | 85 | 60 | 56 | 16 | 2 | 2 | 29 | 129 | 121 | 250 | ||||||||||||||||||||||||||||||||
477530 | 477530 | OK | COMANCHE | school | 4017250 | 16-I008 | LAWTON | 401725002679 | 545 | EISENHOWER MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 91 | 75 | 33 | 18 | 8 | 1 | 24 | 123 | 127 | 250 | 91 | 75 | 33 | 18 | 8 | 1 | 24 | 123 | 127 | 250 | ||||||||||||||||||||||||||||||||
477599 | 477599 | OK | COTTON | school | 4031470 | 17-I001 | WALTERS | 403147029649 | 505 | WALTERS MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 32 | 0 | 2 | 10 | 0 | 0 | 6 | 27 | 23 | 50 | 32 | 0 | 2 | 10 | 0 | 0 | 6 | 27 | 23 | 50 | ||||||||||||||||||||||||||||||||
477653 | 477653 | OK | CRAIG | school | 4016380 | 18-I006 | KETCHUM | 401638002359 | 505 | KETCHUM MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 13 | 1 | 0 | 18 | 1 | 0 | 0 | 14 | 19 | 33 | 13 | 1 | 0 | 18 | 1 | 0 | 0 | 14 | 19 | 33 | ||||||||||||||||||||||||||||||||
477667 | 477667 | OK | CRAIG | school | 4032190 | 18-I017 | WELCH | 403219001782 | 515 | WELCH MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 14 | 0 | 2 | 9 | 0 | 0 | 0 | 15 | 10 | 25 | 14 | 0 | 2 | 9 | 0 | 0 | 0 | 15 | 10 | 25 | ||||||||||||||||||||||||||||||||
477682 | 477682 | OK | CRAIG | school | 4004830 | 18-I020 | BLUEJACKET | 400483002082 | 505 | BLUEJACKET MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 4 | 0 | 0 | 3 | 1 | 0 | 0 | 4 | 4 | 8 | 4 | 0 | 0 | 3 | 1 | 0 | 0 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||
477696 | 477696 | OK | CRAIG | school | 4031290 | 18-I065 | VINITA | 403129001732 | 510 | EWING HALSELL MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 34 | 1 | 8 | 48 | 0 | 0 | 11 | 65 | 37 | 102 | 34 | 1 | 8 | 48 | 0 | 0 | 11 | 65 | 37 | 102 | ||||||||||||||||||||||||||||||||
477751 | 477751 | OK | CREEK | school | 4005460 | 19-I002 | BRISTOW | 400546002083 | 505 | BRISTOW MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 64 | 7 | 2 | 39 | 1 | 0 | 0 | 51 | 62 | 113 | 64 | 7 | 2 | 39 | 1 | 0 | 0 | 51 | 62 | 113 | ||||||||||||||||||||||||||||||||
477767 | 477767 | OK | CREEK | school | 4018840 | 19-I003 | MANNFORD | 401884000895 | 500 | MANNFORD MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_6 | 84 | 1 | 3 | 17 | 2 | 0 | 4 | 57 | 54 | 111 | 84 | 1 | 3 | 17 | 2 | 0 | 4 | 57 | 54 | 111 | ||||||||||||||||||||||||||||||||
477888 | 477888 | OK | CREEK | school | 4026910 | 19-I033 | SAPULPA | 402691001882 | 505 | SAPULPA MS | Middle | Regular School | No | Middle | 06 | 07 | 2017 | grade_6 | 132 | 15 | 26 | 41 | 1 | 0 | 30 | 122 | 123 | 245 | 132 | 15 | 26 | 41 | 1 | 0 | 30 | 122 | 123 | 245 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "enrollments" ( [state] TEXT, [county] TEXT, [county_state_id] INTEGER, [admin_level] TEXT, [district_nces_id] INTEGER, [district_state_id] TEXT, [district_state_type] TEXT, [district] TEXT, [school_nces_id] INTEGER, [school_state_id] INTEGER, [school] TEXT, [school_state_type] TEXT, [ccd_school_type] TEXT, [ccd_charter_school] TEXT, [ccd_school_lvl] TEXT, [ccd_school_low_grade] TEXT, [ccd_school_high_grade] TEXT, [year] INTEGER, [term] TEXT, [grade] TEXT, [white] TEXT, [black] TEXT, [hispanic] TEXT, [native_american] TEXT, [native_american_alaskan_native] TEXT, [asian] TEXT, [native_hawaiian] TEXT, [asian_pacific_islander] TEXT, [native_hawaiian_pacific_islander] TEXT, [pacific_islander] TEXT, [multiracial] TEXT, [unknown_race] TEXT, [male] TEXT, [female] TEXT, [non_binary] TEXT, [unknown_gender] TEXT, [ell] TEXT, [ell_percent] TEXT, [homeless] TEXT, [homeless_percent] TEXT, [low_income] TEXT, [free_and_reduced] TEXT, [free_and_reduced_percent] TEXT, [disability] TEXT, [section_504] TEXT, [total] TEXT , [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER); CREATE INDEX [idx_enrollments_state_grade] ON [enrollments] ([state], [grade]); CREATE INDEX [idx_enrollments_grade] ON [enrollments] ([grade]); CREATE INDEX [idx_enrollments_year] ON [enrollments] ([year]); CREATE INDEX [idx_enrollments_state_year] ON [enrollments] ([state], [year]); CREATE INDEX [idx_enrollments_school_nces_id] ON [enrollments] ([school_nces_id]); CREATE INDEX [idx_enrollments_district_nces_id] ON [enrollments] ([district_nces_id]);