enrollments
Data source: Big Local News · About: Big Local
595 rows where grade = "grade_7", state = "OK" and year = 2021 sorted by district_nces_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3333385 | 3333385 | OK | TULSA | school | 4005490 | 72-I003 | BROKEN ARROW | 400549002770 | 530 | ONETA RIDGE MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 134 | 6 | 32 | 17 | 10 | 0 | 13 | 105 | 107 | 212 | 134 | 6 | 32 | 17 | 10 | 0 | 13 | 105 | 107 | 212 | ||||||||||||||||||||||||||||||||
3329092 | 3329092 | OK | MCCURTAIN | school | 4005520 | 48-I074 | BROKEN BOW | 400552000211 | 505 | RECTOR JOHNSON MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 45 | 13 | 8 | 32 | 0 | 6 | 2 | 56 | 50 | 106 | 45 | 13 | 8 | 32 | 0 | 6 | 2 | 56 | 50 | 106 | ||||||||||||||||||||||||||||||||
3332289 | 3332289 | OK | SEQUOYAH | school | 4005580 | 68-C036 | BRUSHY | 400558000214 | 105 | BRUSHY PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 7 | 0 | 1 | 9 | 0 | 0 | 2 | 9 | 10 | 19 | 7 | 0 | 1 | 9 | 0 | 0 | 2 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||
3327483 | 3327483 | OK | HARPER | school | 4005760 | 30-I004 | BUFFALO | 400576000215 | 105 | BUFFALO ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 9 | 0 | 18 | 0 | 0 | 0 | 1 | 10 | 18 | 28 | 9 | 0 | 18 | 0 | 0 | 0 | 1 | 10 | 18 | 28 | ||||||||||||||||||||||||||||||||
3328151 | 3328151 | OK | LATIMER | school | 4005820 | 39-I003 | BUFFALO VALLEY | 400582000217 | 105 | BUFFALO VALLEY ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 4 | 0 | 1 | 3 | 0 | 0 | 1 | 5 | 4 | 9 | 4 | 0 | 1 | 3 | 0 | 0 | 1 | 5 | 4 | 9 | ||||||||||||||||||||||||||||||||
3324411 | 3324411 | OK | ALFALFA | school | 4005910 | 02-I001 | BURLINGTON | 400591000220 | 105 | BURLINGTON ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 5 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 6 | 7 | 5 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 6 | 7 | ||||||||||||||||||||||||||||||||
3332254 | 3332254 | OK | SEMINOLE | school | 4006000 | 67-I015 | BUTNER | 400600000227 | 105 | BUTNER ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 8 | 0 | 0 | 2 | 0 | 0 | 2 | 2 | 10 | 12 | 8 | 0 | 0 | 2 | 0 | 0 | 2 | 2 | 10 | 12 | ||||||||||||||||||||||||||||||||
3331554 | 3331554 | OK | PONTOTOC | school | 4006060 | 62-I016 | BYNG | 400606029751 | 610 | BYNG JHS | Junior High | Regular School | No | Middle | 07 | 09 | 2021 | grade_7 | 53 | 2 | 7 | 44 | 1 | 0 | 28 | 68 | 67 | 135 | 53 | 2 | 7 | 44 | 1 | 0 | 28 | 68 | 67 | 135 | ||||||||||||||||||||||||||||||||
3326110 | 3326110 | OK | COMANCHE | school | 4006120 | 16-I001 | CACHE | 400612029646 | 505 | CACHE MS | Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 88 | 12 | 25 | 14 | 5 | 1 | 29 | 89 | 85 | 174 | 88 | 12 | 25 | 14 | 5 | 1 | 29 | 89 | 85 | 174 | ||||||||||||||||||||||||||||||||
3324757 | 3324757 | OK | BRYAN | school | 4006150 | 07-I005 | CADDO | 400615000237 | 105 | CADDO ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 25 | 0 | 1 | 4 | 0 | 0 | 6 | 18 | 18 | 36 | 25 | 0 | 1 | 4 | 0 | 0 | 6 | 18 | 18 | 36 | ||||||||||||||||||||||||||||||||
3324786 | 3324786 | OK | BRYAN | school | 4006180 | 07-I048 | CALERA | 400618000239 | 105 | CALERA ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 27 | 0 | 3 | 20 | 0 | 0 | 15 | 29 | 36 | 65 | 27 | 0 | 3 | 20 | 0 | 0 | 15 | 29 | 36 | 65 | ||||||||||||||||||||||||||||||||
3325199 | 3325199 | OK | CANADIAN | school | 4006240 | 09-I076 | CALUMET | 400624000241 | 105 | CALUMET ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 14 | 0 | 5 | 2 | 0 | 0 | 0 | 9 | 12 | 21 | 14 | 0 | 5 | 2 | 0 | 0 | 0 | 9 | 12 | 21 | ||||||||||||||||||||||||||||||||
3327608 | 3327608 | OK | HUGHES | school | 4006270 | 32-I048 | CALVIN | 400627000243 | 105 | CALVIN ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 13 | 2 | 0 | 2 | 0 | 0 | 0 | 6 | 11 | 17 | 13 | 2 | 0 | 2 | 0 | 0 | 0 | 6 | 11 | 17 | ||||||||||||||||||||||||||||||||
3328261 | 3328261 | OK | LE FLORE | school | 4006330 | 40-I017 | CAMERON | 400633000246 | 105 | CAMERON ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 2 | 0 | 2 | 3 | 0 | 0 | 5 | 9 | 3 | 12 | 2 | 0 | 2 | 3 | 0 | 0 | 5 | 9 | 3 | 12 | ||||||||||||||||||||||||||||||||
3331371 | 3331371 | OK | PITTSBURG | school | 4006390 | 61-I002 | CANADIAN | 400639000248 | 105 | CANADIAN ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 10 | 1 | 1 | 10 | 1 | 0 | 0 | 8 | 15 | 23 | 10 | 1 | 1 | 10 | 1 | 0 | 0 | 8 | 15 | 23 | ||||||||||||||||||||||||||||||||
3324516 | 3324516 | OK | ATOKA | school | 4006420 | 03-I026 | CANEY | 400642000250 | 105 | CANEY ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 7 | 0 | 2 | 7 | 0 | 0 | 1 | 9 | 8 | 17 | 7 | 0 | 2 | 7 | 0 | 0 | 1 | 9 | 8 | 17 | ||||||||||||||||||||||||||||||||
3324687 | 3324687 | OK | BLAINE | school | 4006480 | 06-I105 | CANTON | 400648000253 | 105 | CANTON ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 11 | 0 | 5 | 6 | 0 | 0 | 2 | 13 | 11 | 24 | 11 | 0 | 5 | 6 | 0 | 0 | 2 | 13 | 11 | 24 | ||||||||||||||||||||||||||||||||
3333933 | 3333933 | OK | WASHITA | school | 4006510 | 75-I011 | CANUTE | 400651000255 | 105 | CANUTE ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 27 | 0 | 2 | 0 | 0 | 0 | 1 | 20 | 10 | 30 | 27 | 0 | 2 | 0 | 0 | 0 | 1 | 20 | 10 | 30 | ||||||||||||||||||||||||||||||||
3324862 | 3324862 | OK | CADDO | school | 4006630 | 08-I033 | CARNEGIE | 400663002676 | 510 | CARNEGIE MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 15 | 0 | 8 | 9 | 0 | 0 | 8 | 22 | 18 | 40 | 15 | 0 | 8 | 9 | 0 | 0 | 8 | 22 | 18 | 40 | ||||||||||||||||||||||||||||||||
3328487 | 3328487 | OK | LINCOLN | school | 4006690 | 41-I105 | CARNEY | 400669000261 | 105 | CARNEY ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 11 | 0 | 0 | 2 | 0 | 0 | 1 | 9 | 5 | 14 | 11 | 0 | 0 | 2 | 0 | 0 | 1 | 9 | 5 | 14 | ||||||||||||||||||||||||||||||||
3328025 | 3328025 | OK | KINGFISHER | school | 4006810 | 37-I089 | CASHION | 400681002816 | 505 | CASHION MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 31 | 0 | 3 | 3 | 0 | 0 | 3 | 24 | 16 | 40 | 31 | 0 | 3 | 3 | 0 | 0 | 3 | 24 | 16 | 40 | ||||||||||||||||||||||||||||||||
3329560 | 3329560 | OK | OKFUSKEE | school | 4006850 | 54-I026 | OKEMAH | 400685001901 | 505 | OKEMAH MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 17 | 2 | 3 | 18 | 0 | 0 | 3 | 23 | 20 | 43 | 17 | 2 | 3 | 18 | 0 | 0 | 3 | 23 | 20 | 43 | ||||||||||||||||||||||||||||||||
3332035 | 3332035 | OK | ROGERS | school | 4006870 | 66-I002 | CATOOSA | 400687000811 | 510 | WELLS MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 57 | 1 | 31 | 14 | 3 | 0 | 23 | 69 | 60 | 129 | 57 | 1 | 31 | 14 | 3 | 0 | 23 | 69 | 60 | 129 | ||||||||||||||||||||||||||||||||
3324399 | 3324399 | OK | ADAIR | school | 4006930 | 01-I030 | CAVE SPRINGS | 400693002823 | 505 | CAVE SPRINGS MS | Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 7 | 5 | 12 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 7 | 5 | 12 | ||||||||||||||||||||||||||||||||
3324920 | 3324920 | OK | CADDO | school | 4006960 | 08-I160 | CEMENT | 400696000276 | 105 | CEMENT ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 20 | 0 | 1 | 2 | 0 | 0 | 0 | 7 | 16 | 23 | 20 | 0 | 1 | 2 | 0 | 0 | 0 | 7 | 16 | 23 | ||||||||||||||||||||||||||||||||
3332418 | 3332418 | OK | SEQUOYAH | school | 4007140 | 68-I007 | CENTRAL | 400714000279 | 105 | CENTRAL ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 3 | 0 | 8 | 13 | 0 | 0 | 4 | 18 | 10 | 28 | 3 | 0 | 8 | 13 | 0 | 0 | 4 | 18 | 10 | 28 | ||||||||||||||||||||||||||||||||
3332539 | 3332539 | OK | STEPHENS | school | 4007170 | 69-I034 | CENTRAL HIGH | 400717002756 | 600 | CENTRAL HIGH JHS | Junior High | Regular School | No | Middle | 07 | 09 | 2021 | grade_7 | 18 | 0 | 4 | 1 | 0 | 0 | 3 | 17 | 9 | 26 | 18 | 0 | 4 | 1 | 0 | 0 | 3 | 17 | 9 | 26 | ||||||||||||||||||||||||||||||||
3328402 | 3328402 | OK | LINCOLN | school | 4007290 | 41-I001 | CHANDLER | 400729002375 | 610 | CHANDLER JHS | Junior High | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 53 | 0 | 5 | 4 | 0 | 0 | 20 | 37 | 45 | 82 | 53 | 0 | 5 | 4 | 0 | 0 | 20 | 37 | 45 | 82 | ||||||||||||||||||||||||||||||||
3326337 | 3326337 | OK | COMANCHE | school | 4007320 | 16-I132 | CHATTANOOGA | 400732000286 | 105 | CHATTANOOGA ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 20 | 0 | 0 | 2 | 0 | 0 | 2 | 10 | 14 | 24 | 20 | 0 | 0 | 2 | 0 | 0 | 2 | 10 | 14 | 24 | ||||||||||||||||||||||||||||||||
3329142 | 3329142 | OK | MCINTOSH | school | 4007350 | 49-I019 | CHECOTAH | 400735001859 | 505 | CHECOTAH MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 38 | 2 | 2 | 34 | 0 | 0 | 8 | 46 | 38 | 84 | 38 | 2 | 2 | 34 | 0 | 0 | 8 | 46 | 38 | 84 | ||||||||||||||||||||||||||||||||
3332049 | 3332049 | OK | ROGERS | school | 4007380 | 66-I003 | CHELSEA | 400738002310 | 510 | CHELSEA MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 19 | 0 | 3 | 32 | 1 | 2 | 3 | 30 | 30 | 60 | 19 | 0 | 3 | 32 | 1 | 2 | 3 | 30 | 30 | 60 | ||||||||||||||||||||||||||||||||
3324428 | 3324428 | OK | ALFALFA | school | 4007410 | 02-I046 | CHEROKEE | 400741002745 | 510 | CHEROKEE MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 22 | 0 | 8 | 0 | 0 | 0 | 0 | 14 | 16 | 30 | 22 | 0 | 8 | 0 | 0 | 0 | 0 | 14 | 16 | 30 | ||||||||||||||||||||||||||||||||
3331941 | 3331941 | OK | ROGER MILLS | school | 4007500 | 65-I007 | CHEYENNE | 400750000299 | 105 | CHEYENNE ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 14 | 0 | 3 | 0 | 0 | 0 | 3 | 13 | 7 | 20 | 14 | 0 | 3 | 0 | 0 | 0 | 3 | 13 | 7 | 20 | ||||||||||||||||||||||||||||||||
3327255 | 3327255 | OK | GRADY | school | 4007560 | 26-I001 | CHICKASHA | 400756002342 | 510 | CHICKASHA MS | Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 87 | 7 | 16 | 17 | 2 | 0 | 7 | 69 | 67 | 136 | 87 | 7 | 16 | 17 | 2 | 0 | 7 | 69 | 67 | 136 | ||||||||||||||||||||||||||||||||
3329871 | 3329871 | OK | OKLAHOMA | school | 4007620 | 55-I004 | CHOCTAW-NICOMA PARK | 400762002691 | 515 | NICOMA PARK MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 152 | 27 | 21 | 9 | 5 | 0 | 33 | 131 | 116 | 247 | 152 | 27 | 21 | 9 | 5 | 0 | 33 | 131 | 116 | 247 | ||||||||||||||||||||||||||||||||
3329874 | 3329874 | OK | OKLAHOMA | school | 4007620 | 55-I004 | CHOCTAW-NICOMA PARK | 400762002698 | 520 | CHOCTAW MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 141 | 7 | 12 | 7 | 3 | 0 | 34 | 108 | 96 | 204 | 141 | 7 | 12 | 7 | 3 | 0 | 34 | 108 | 96 | 204 | ||||||||||||||||||||||||||||||||
3328831 | 3328831 | OK | MAYES | school | 4007670 | 46-I032 | CHOUTEAU-MAZIE | 400767000319 | 110 | MAZIE ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 8 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 3 | 9 | 8 | 0 | 1 | 0 | 0 | 0 | 0 | 6 | 3 | 9 | ||||||||||||||||||||||||||||||||
3328841 | 3328841 | OK | MAYES | school | 4007670 | 46-I032 | CHOUTEAU-MAZIE | 400767000318 | 505 | CHOUTEAU-MAZIE MS | Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 29 | 0 | 5 | 10 | 0 | 0 | 18 | 33 | 29 | 62 | 29 | 0 | 5 | 10 | 0 | 0 | 18 | 33 | 29 | 62 | ||||||||||||||||||||||||||||||||
3328692 | 3328692 | OK | MAJOR | school | 4007710 | 44-I092 | CIMARRON | 400771000508 | 105 | CIMARRON ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 12 | 0 | 0 | 1 | 0 | 0 | 0 | 6 | 7 | 13 | 12 | 0 | 0 | 1 | 0 | 0 | 0 | 6 | 7 | 13 | ||||||||||||||||||||||||||||||||
3332019 | 3332019 | OK | ROGERS | school | 4007740 | 66-I001 | CLAREMORE | 400774002197 | 610 | WILL ROGERS JHS | Junior High | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 128 | 5 | 36 | 62 | 2 | 0 | 39 | 130 | 142 | 272 | 128 | 5 | 36 | 62 | 2 | 0 | 39 | 130 | 142 | 272 | ||||||||||||||||||||||||||||||||
3331871 | 3331871 | OK | PUSHMATAHA | school | 4007800 | 64-I010 | CLAYTON | 400780000327 | 105 | CRAIN ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 10 | 0 | 0 | 5 | 0 | 0 | 0 | 8 | 7 | 15 | 10 | 0 | 0 | 5 | 0 | 0 | 0 | 8 | 7 | 15 | ||||||||||||||||||||||||||||||||
3326726 | 3326726 | OK | DELAWARE | school | 4008010 | 21-C006 | CLEORA | 400801000330 | 105 | CLEORA PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 7 | 0 | 1 | 3 | 0 | 0 | 0 | 4 | 7 | 11 | 7 | 0 | 1 | 3 | 0 | 0 | 0 | 4 | 7 | 11 | ||||||||||||||||||||||||||||||||
3331172 | 3331172 | OK | PAWNEE | school | 4008040 | 59-I006 | CLEVELAND | 400804000333 | 505 | CLEVELAND MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 90 | 2 | 8 | 26 | 0 | 1 | 5 | 71 | 61 | 132 | 90 | 2 | 8 | 26 | 0 | 1 | 5 | 71 | 61 | 132 | ||||||||||||||||||||||||||||||||
3326714 | 3326714 | OK | CUSTER | school | 4008070 | 20-I099 | CLINTON | 400807000339 | 505 | CLINTON MS | Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 42 | 2 | 71 | 12 | 0 | 0 | 16 | 79 | 64 | 143 | 42 | 2 | 71 | 12 | 0 | 0 | 16 | 79 | 64 | 143 | ||||||||||||||||||||||||||||||||
3326066 | 3326066 | OK | COAL | school | 4008130 | 15-I001 | COALGATE | 400813001958 | 505 | WALLACE BYRD MS | Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 24 | 0 | 3 | 14 | 0 | 0 | 6 | 22 | 25 | 47 | 24 | 0 | 3 | 14 | 0 | 0 | 6 | 22 | 25 | 47 | ||||||||||||||||||||||||||||||||
3324745 | 3324745 | OK | BRYAN | school | 4008220 | 07-I004 | COLBERT | 400822000343 | 505 | COLBERT MS | Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 20 | 1 | 4 | 14 | 0 | 0 | 6 | 24 | 21 | 45 | 20 | 1 | 4 | 14 | 0 | 0 | 6 | 24 | 21 | 45 | ||||||||||||||||||||||||||||||||
3326807 | 3326807 | OK | DELAWARE | school | 4008250 | 21-I004 | COLCORD | 400825000345 | 105 | COLCORD ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 20 | 1 | 1 | 23 | 2 | 1 | 5 | 26 | 27 | 53 | 20 | 1 | 1 | 23 | 2 | 1 | 5 | 26 | 27 | 53 | ||||||||||||||||||||||||||||||||
3327826 | 3327826 | OK | JOHNSTON | school | 4008310 | 35-I035 | COLEMAN | 400831000347 | 105 | COLEMAN ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 5 | 0 | 0 | 6 | 0 | 0 | 5 | 6 | 10 | 16 | 5 | 0 | 0 | 6 | 0 | 0 | 5 | 6 | 10 | 16 | ||||||||||||||||||||||||||||||||
3333475 | 3333475 | OK | TULSA | school | 4008370 | 72-I006 | COLLINSVILLE | 400837000350 | 500 | COLLINSVILLE MS | Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 122 | 1 | 17 | 36 | 8 | 0 | 35 | 108 | 111 | 219 | 122 | 1 | 17 | 36 | 8 | 0 | 35 | 108 | 111 | 219 | ||||||||||||||||||||||||||||||||
3332483 | 3332483 | OK | STEPHENS | school | 4008460 | 69-I002 | COMANCHE | 400846002279 | 510 | COMANCHE MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 53 | 0 | 4 | 3 | 0 | 0 | 8 | 31 | 37 | 68 | 53 | 0 | 4 | 3 | 0 | 0 | 8 | 31 | 37 | 68 | ||||||||||||||||||||||||||||||||
3331088 | 3331088 | OK | OTTAWA | school | 4008490 | 58-I018 | COMMERCE | 400849000360 | 505 | COMMERCE MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 34 | 0 | 16 | 27 | 1 | 0 | 6 | 37 | 47 | 84 | 34 | 0 | 16 | 27 | 1 | 0 | 6 | 37 | 47 | 84 | ||||||||||||||||||||||||||||||||
3333807 | 3333807 | OK | WASHINGTON | school | 4008610 | 74-I004 | COPAN | 400861000362 | 105 | COPAN ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 7 | 0 | 0 | 4 | 0 | 0 | 6 | 11 | 6 | 17 | 7 | 0 | 0 | 4 | 0 | 0 | 6 | 11 | 6 | 17 | ||||||||||||||||||||||||||||||||
3333950 | 3333950 | OK | WASHITA | school | 4008640 | 75-I078 | CORDELL | 400864000365 | 610 | CORDELL JHS | Junior High | Regular School | No | Middle | 07 | 09 | 2021 | grade_7 | 35 | 1 | 7 | 2 | 0 | 0 | 4 | 18 | 31 | 49 | 35 | 1 | 7 | 2 | 0 | 0 | 4 | 18 | 31 | 49 | ||||||||||||||||||||||||||||||||
3326054 | 3326054 | OK | COAL | school | 4008730 | 15-C004 | COTTONWOOD | 400873000369 | 105 | COTTONWOOD PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 3 | 0 | 0 | 1 | 0 | 0 | 3 | 3 | 4 | 7 | 3 | 0 | 0 | 1 | 0 | 0 | 3 | 3 | 4 | 7 | ||||||||||||||||||||||||||||||||
3327097 | 3327097 | OK | GARFIELD | school | 4008790 | 24-I094 | COVINGTON-DOUGLAS | 400879000370 | 105 | COVINGTON-DOUGLAS ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 13 | 0 | 3 | 0 | 0 | 0 | 2 | 9 | 9 | 18 | 13 | 0 | 3 | 0 | 0 | 0 | 2 | 9 | 9 | 18 | ||||||||||||||||||||||||||||||||
3333766 | 3333766 | OK | WAGONER | school | 4008850 | 73-I017 | COWETA | 400885000374 | 610 | DONALD P SLOAT JHS | Junior High | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 131 | 14 | 19 | 56 | 4 | 2 | 8 | 115 | 119 | 234 | 131 | 14 | 19 | 56 | 4 | 2 | 8 | 115 | 119 | 234 | ||||||||||||||||||||||||||||||||
3328579 | 3328579 | OK | LOGAN | school | 4008940 | 42-I014 | COYLE | 400894000375 | 105 | COYLE ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 11 | 5 | 1 | 2 | 0 | 0 | 2 | 15 | 6 | 21 | 11 | 5 | 1 | 2 | 0 | 0 | 2 | 15 | 6 | 21 | ||||||||||||||||||||||||||||||||
3328553 | 3328553 | OK | LOGAN | school | 4009000 | 42-I002 | CRESCENT | 400900000379 | 515 | CRESCENT MS | Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 25 | 4 | 2 | 4 | 0 | 0 | 0 | 16 | 19 | 35 | 25 | 4 | 2 | 4 | 0 | 0 | 0 | 16 | 19 | 35 | ||||||||||||||||||||||||||||||||
3330294 | 3330294 | OK | OKLAHOMA | school | 4009060 | 55-I053 | CROOKED OAK | 400906000382 | 505 | CROOKED OAK MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 9 | 7 | 65 | 4 | 0 | 0 | 2 | 43 | 44 | 87 | 9 | 7 | 65 | 4 | 0 | 0 | 2 | 43 | 44 | 87 | ||||||||||||||||||||||||||||||||
3331451 | 3331451 | OK | PITTSBURG | school | 4009090 | 61-I028 | CROWDER | 400909000384 | 105 | CROWDER ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 16 | 0 | 0 | 13 | 0 | 0 | 1 | 12 | 18 | 30 | 16 | 0 | 0 | 13 | 0 | 0 | 1 | 12 | 18 | 30 | ||||||||||||||||||||||||||||||||
3329610 | 3329610 | OK | OKLAHOMA | school | 4009150 | 55-C074 | CRUTCHO | 400915000386 | 105 | CRUTCHO PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 6 | 10 | 3 | 0 | 0 | 0 | 0 | 13 | 6 | 19 | 6 | 10 | 3 | 0 | 0 | 0 | 0 | 13 | 6 | 19 | ||||||||||||||||||||||||||||||||
3331276 | 3331276 | OK | PAYNE | school | 4009240 | 60-I067 | CUSHING | 400924000388 | 505 | CUSHING MS | Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 75 | 0 | 8 | 13 | 0 | 0 | 18 | 62 | 52 | 114 | 75 | 0 | 8 | 13 | 0 | 0 | 18 | 62 | 52 | 114 | ||||||||||||||||||||||||||||||||
3324893 | 3324893 | OK | CADDO | school | 4009300 | 08-I064 | CYRIL | 400930002776 | 610 | CYRIL JHS | Junior High | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 19 | 1 | 0 | 3 | 0 | 1 | 2 | 11 | 15 | 26 | 19 | 1 | 0 | 3 | 0 | 1 | 2 | 11 | 15 | 26 | ||||||||||||||||||||||||||||||||
3324345 | 3324345 | OK | ADAIR | school | 4009360 | 01-C029 | DAHLONEGAH | 400936000401 | 105 | DAHLONEGAH PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 2 | 0 | 0 | 16 | 0 | 0 | 0 | 6 | 12 | 18 | 2 | 0 | 0 | 16 | 0 | 0 | 0 | 6 | 12 | 18 | ||||||||||||||||||||||||||||||||
3331668 | 3331668 | OK | POTTAWATOMIE | school | 4009390 | 63-I002 | DALE | 400939002681 | 510 | DALE MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 48 | 1 | 2 | 17 | 0 | 0 | 3 | 40 | 31 | 71 | 48 | 1 | 2 | 17 | 0 | 0 | 3 | 40 | 31 | 71 | ||||||||||||||||||||||||||||||||
3324996 | 3324996 | OK | CANADIAN | school | 4009420 | 09-C070 | DARLINGTON | 400942000404 | 105 | DARLINGTON PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 0 | 1 | 4 | 13 | 0 | 0 | 1 | 10 | 9 | 19 | 0 | 1 | 4 | 13 | 0 | 0 | 1 | 10 | 9 | 19 | ||||||||||||||||||||||||||||||||
3328414 | 3328414 | OK | LINCOLN | school | 4009450 | 41-I003 | DAVENPORT | 400945000405 | 105 | DAVENPORT ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 15 | 1 | 2 | 2 | 0 | 0 | 0 | 9 | 11 | 20 | 15 | 1 | 2 | 2 | 0 | 0 | 0 | 9 | 11 | 20 | ||||||||||||||||||||||||||||||||
3329215 | 3329215 | OK | MURRAY | school | 4009510 | 50-I010 | DAVIS | 400951000411 | 505 | DAVIS MS | Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 36 | 1 | 0 | 21 | 0 | 0 | 1 | 24 | 35 | 59 | 36 | 1 | 0 | 21 | 0 | 0 | 1 | 24 | 35 | 59 | ||||||||||||||||||||||||||||||||
3329907 | 3329907 | OK | OKLAHOMA | school | 4009570 | 55-I006 | DEER CREEK | 400957000414 | 505 | DEER CREEK MS | Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 311 | 41 | 50 | 31 | 43 | 1 | 24 | 258 | 243 | 501 | 311 | 41 | 50 | 31 | 43 | 1 | 24 | 258 | 243 | 501 | ||||||||||||||||||||||||||||||||
3328970 | 3328970 | OK | MCCURTAIN | school | 4009720 | 48-C037 | DENISON | 400972000417 | 105 | DENISON PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 11 | 1 | 1 | 2 | 1 | 0 | 5 | 10 | 11 | 21 | 11 | 1 | 1 | 2 | 1 | 0 | 5 | 10 | 11 | 21 | ||||||||||||||||||||||||||||||||
3326591 | 3326591 | OK | CREEK | school | 4009750 | 19-I021 | DEPEW | 400975000418 | 105 | DEPEW ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 18 | 0 | 1 | 4 | 0 | 0 | 2 | 15 | 10 | 25 | 18 | 0 | 1 | 4 | 0 | 0 | 2 | 15 | 10 | 25 | ||||||||||||||||||||||||||||||||
3330892 | 3330892 | OK | OKMULGEE | school | 4009780 | 56-I008 | DEWAR | 400978002785 | 515 | DEWAR MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 9 | 0 | 0 | 11 | 0 | 0 | 1 | 12 | 9 | 21 | 9 | 0 | 0 | 11 | 0 | 0 | 1 | 12 | 9 | 21 | ||||||||||||||||||||||||||||||||
3333823 | 3333823 | OK | WASHINGTON | school | 4009810 | 74-I007 | DEWEY | 400981001910 | 510 | DEWEY MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 53 | 3 | 13 | 27 | 0 | 0 | 5 | 55 | 46 | 101 | 53 | 3 | 13 | 27 | 0 | 0 | 5 | 55 | 46 | 101 | ||||||||||||||||||||||||||||||||
3328869 | 3328869 | OK | MCCLAIN | school | 4009870 | 47-I002 | DIBBLE | 400987002409 | 515 | DIBBLE MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 28 | 1 | 5 | 4 | 0 | 0 | 11 | 29 | 20 | 49 | 28 | 1 | 5 | 4 | 0 | 0 | 11 | 29 | 20 | 49 | ||||||||||||||||||||||||||||||||
3325339 | 3325339 | OK | CARTER | school | 4009910 | 10-I077 | DICKSON | 400991002667 | 510 | DICKSON MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 59 | 0 | 3 | 17 | 0 | 0 | 13 | 50 | 42 | 92 | 59 | 0 | 3 | 17 | 0 | 0 | 13 | 50 | 42 | 92 | ||||||||||||||||||||||||||||||||
3327967 | 3327967 | OK | KINGFISHER | school | 4010050 | 37-I002 | DOVER | 401005000436 | 105 | DOVER ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 4 | 0 | 3 | 0 | 0 | 0 | 1 | 5 | 3 | 8 | 4 | 0 | 3 | 0 | 0 | 0 | 1 | 5 | 3 | 8 | ||||||||||||||||||||||||||||||||
3327083 | 3327083 | OK | GARFIELD | school | 4010170 | 24-I085 | DRUMMOND | 401017000438 | 105 | DRUMMOND ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 26 | 1 | 3 | 2 | 0 | 0 | 1 | 15 | 18 | 33 | 26 | 1 | 3 | 2 | 0 | 0 | 1 | 15 | 18 | 33 | ||||||||||||||||||||||||||||||||
3326656 | 3326656 | OK | CREEK | school | 4010200 | 19-I039 | DRUMRIGHT | 401020002709 | 505 | VIRGIL COOPER MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 28 | 0 | 1 | 4 | 0 | 0 | 6 | 18 | 21 | 39 | 28 | 0 | 1 | 4 | 0 | 0 | 6 | 18 | 21 | 39 | ||||||||||||||||||||||||||||||||
3327650 | 3327650 | OK | JACKSON | school | 4010260 | 33-I014 | DUKE | 401026000444 | 105 | DUKE ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 6 | 1 | 0 | 1 | 0 | 0 | 0 | 4 | 4 | 8 | 6 | 1 | 0 | 1 | 0 | 0 | 0 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||
3332469 | 3332469 | OK | STEPHENS | school | 4010290 | 69-I001 | DUNCAN | 401029000921 | 505 | DUNCAN MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 148 | 10 | 49 | 9 | 2 | 0 | 23 | 125 | 116 | 241 | 148 | 10 | 49 | 9 | 2 | 0 | 23 | 125 | 116 | 241 | ||||||||||||||||||||||||||||||||
3324806 | 3324806 | OK | BRYAN | school | 4010350 | 07-I072 | DURANT | 401035000457 | 500 | DURANT MS | Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 130 | 6 | 46 | 71 | 1 | 0 | 23 | 138 | 139 | 277 | 130 | 6 | 46 | 71 | 1 | 0 | 23 | 138 | 139 | 277 | ||||||||||||||||||||||||||||||||
3329034 | 3329034 | OK | MCCURTAIN | school | 4010440 | 48-I013 | EAGLETOWN | 401044000464 | 105 | EAGLETOWN ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 4 | 0 | 0 | 3 | 0 | 0 | 1 | 5 | 3 | 8 | 4 | 0 | 0 | 3 | 0 | 0 | 1 | 5 | 3 | 8 | ||||||||||||||||||||||||||||||||
3331708 | 3331708 | OK | POTTAWATOMIE | school | 4010500 | 63-I005 | EARLSBORO | 401050000469 | 105 | EARLSBORO ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 8 | 0 | 0 | 3 | 0 | 0 | 3 | 9 | 5 | 14 | 8 | 0 | 0 | 3 | 0 | 0 | 3 | 9 | 5 | 14 | ||||||||||||||||||||||||||||||||
3324305 | 3324305 | OK | ADAIR | school | 4010560 | 01-C019 | PEAVINE | 401056000470 | 105 | PEAVINE PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 3 | 0 | 1 | 3 | 1 | 0 | 0 | 2 | 6 | 8 | 3 | 0 | 1 | 3 | 1 | 0 | 0 | 2 | 6 | 8 | ||||||||||||||||||||||||||||||||
3330076 | 3330076 | OK | OKLAHOMA | school | 4010590 | 55-I012 | EDMOND | 401059000475 | 505 | CIMARRON MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 149 | 27 | 33 | 4 | 3 | 2 | 20 | 115 | 123 | 238 | 149 | 27 | 33 | 4 | 3 | 2 | 20 | 115 | 123 | 238 | ||||||||||||||||||||||||||||||||
3330080 | 3330080 | OK | OKLAHOMA | school | 4010590 | 55-I012 | EDMOND | 401059002303 | 510 | CHEYENNE MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 198 | 26 | 30 | 7 | 11 | 1 | 32 | 152 | 153 | 305 | 198 | 26 | 30 | 7 | 11 | 1 | 32 | 152 | 153 | 305 | ||||||||||||||||||||||||||||||||
3330084 | 3330084 | OK | OKLAHOMA | school | 4010590 | 55-I012 | EDMOND | 401059000481 | 515 | SEQUOYAH MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 210 | 25 | 36 | 5 | 5 | 0 | 31 | 158 | 154 | 312 | 210 | 25 | 36 | 5 | 5 | 0 | 31 | 158 | 154 | 312 | ||||||||||||||||||||||||||||||||
3330087 | 3330087 | OK | OKLAHOMA | school | 4010590 | 55-I012 | EDMOND | 401059029716 | 520 | SUMMIT MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 119 | 72 | 36 | 4 | 27 | 4 | 40 | 154 | 148 | 302 | 119 | 72 | 36 | 4 | 27 | 4 | 40 | 154 | 148 | 302 | ||||||||||||||||||||||||||||||||
3330091 | 3330091 | OK | OKLAHOMA | school | 4010590 | 55-I012 | EDMOND | 401059001326 | 525 | CENTRAL MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 209 | 12 | 41 | 9 | 5 | 0 | 27 | 153 | 150 | 303 | 209 | 12 | 41 | 9 | 5 | 0 | 27 | 153 | 150 | 303 | ||||||||||||||||||||||||||||||||
3330094 | 3330094 | OK | OKLAHOMA | school | 4010590 | 55-I012 | EDMOND | 401059002835 | 530 | HEARTLAND MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 225 | 55 | 41 | 6 | 22 | 0 | 41 | 195 | 195 | 390 | 225 | 55 | 41 | 6 | 22 | 0 | 41 | 195 | 195 | 390 | ||||||||||||||||||||||||||||||||
3325103 | 3325103 | OK | CANADIAN | school | 4010650 | 09-I034 | EL RENO | 401065000485 | 610 | ETTA DALE JHS | Junior High | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 96 | 6 | 62 | 26 | 1 | 0 | 19 | 104 | 106 | 210 | 96 | 6 | 62 | 26 | 1 | 0 | 19 | 104 | 106 | 210 | ||||||||||||||||||||||||||||||||
3326323 | 3326323 | OK | COMANCHE | school | 4010710 | 16-I016 | ELGIN | 401071001980 | 505 | ELGIN MS | Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 112 | 8 | 41 | 17 | 0 | 2 | 18 | 96 | 102 | 198 | 112 | 8 | 41 | 17 | 0 | 2 | 18 | 96 | 102 | 198 | ||||||||||||||||||||||||||||||||
3324603 | 3324603 | OK | BECKHAM | school | 4010740 | 05-I006 | ELK CITY | 401074000496 | 610 | ELK CITY MS | Junior High | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 98 | 5 | 45 | 7 | 2 | 0 | 17 | 92 | 82 | 174 | 98 | 5 | 45 | 7 | 2 | 0 | 17 | 92 | 82 | 174 | ||||||||||||||||||||||||||||||||
3327211 | 3327211 | OK | GARVIN | school | 4010860 | 25-I072 | ELMORE CITY-PERNELL | 401086002746 | 605 | ELMORE CITY JHS | Junior High | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 32 | 0 | 2 | 7 | 0 | 0 | 3 | 27 | 17 | 44 | 32 | 0 | 2 | 7 | 0 | 0 | 3 | 27 | 17 | 44 | ||||||||||||||||||||||||||||||||
3332525 | 3332525 | OK | STEPHENS | school | 4010890 | 69-I021 | EMPIRE | 401089002718 | 505 | EMPIRE MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 30 | 0 | 4 | 5 | 0 | 0 | 4 | 15 | 28 | 43 | 30 | 0 | 4 | 5 | 0 | 0 | 4 | 15 | 28 | 43 | ||||||||||||||||||||||||||||||||
3327063 | 3327063 | OK | GARFIELD | school | 4010920 | 24-I057 | ENID | 401092002700 | 505 | EMERSON MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 58 | 2 | 41 | 1 | 1 | 11 | 10 | 60 | 64 | 124 | 58 | 2 | 41 | 1 | 1 | 11 | 10 | 60 | 64 | 124 | ||||||||||||||||||||||||||||||||
3327067 | 3327067 | OK | GARFIELD | school | 4010920 | 24-I057 | ENID | 401092002686 | 510 | LONGFELLOW MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 43 | 4 | 75 | 6 | 1 | 43 | 13 | 91 | 94 | 185 | 43 | 4 | 75 | 6 | 1 | 43 | 13 | 91 | 94 | 185 | ||||||||||||||||||||||||||||||||
3327070 | 3327070 | OK | GARFIELD | school | 4010920 | 24-I057 | ENID | 401092000510 | 515 | DEWITT WALLER MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 150 | 8 | 39 | 4 | 5 | 10 | 21 | 125 | 112 | 237 | 150 | 8 | 39 | 4 | 5 | 10 | 21 | 125 | 112 | 237 | ||||||||||||||||||||||||||||||||
3324629 | 3324629 | OK | BECKHAM | school | 4011040 | 05-I051 | ERICK | 401104000525 | 105 | ERICK ES | Elementary | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 14 | 0 | 0 | 0 | 0 | 0 | 2 | 9 | 7 | 16 | 14 | 0 | 0 | 0 | 0 | 0 | 2 | 9 | 7 | 16 | ||||||||||||||||||||||||||||||||
3329126 | 3329126 | OK | MCINTOSH | school | 4011160 | 49-I001 | EUFAULA | 401116002346 | 505 | EUFAULA MS | Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 40 | 2 | 2 | 33 | 0 | 0 | 10 | 48 | 39 | 87 | 40 | 2 | 2 | 33 | 0 | 0 | 10 | 48 | 39 | 87 |
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]);