Data source: Big Local News · About: Big Local

595 rows where grade = "grade_7", state = "OK" and year = 2021 sorted by district_nces_id

View and edit SQL

year

  • 2021 · 495

grade

  • grade_7 · 495
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);