Data source: Big Local News · About: Big Local

590 rows where grade = "grade_7", state = "OK" and year = 2017 sorted by multiracial_int descending

View and edit SQL

year

  • 2017 · 590

grade

  • grade_7 · 590
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
485112 OK TULSA   school 4030600 72-I009   UNION 403060001461 510 UNION 6TH-7TH GRADE CTR Middle Regular School No Middle 06 07 2017   grade_7 359 174 409 68   90     0   81   591 590                       1181 359 174 409 68   90     0   81   591 590                 1181
477053 OK CLEVELAND   school 4020250 14-I002   MOORE 402025000993 650 HIGHLAND EAST JHS Junior High Regular School No Middle 07 08 2017   grade_7 195 18 54 19   8     0   74   174 194                       368 195 18 54 19   8     0   74   174 194                 368
477059 OK CLEVELAND   school 4020250 14-I002   MOORE 402025001606 685 CENTRAL JHS Junior High Regular School No Middle 07 08 2017   grade_7 165 19 36 13   5     1   68   170 137                       307 165 19 36 13   5     1   68   170 137                 307
484971 OK TULSA   school 4015720 72-I005   JENKS 401572000740 505 JENKS MS Middle Regular School No Middle 07 08 2017   grade_7 485 64 115 74   91     2   67   474 424                       898 485 64 115 74   91     2   67   474 424                 898
480622 OK MUSKOGEE   school 4020970 51-I020   MUSKOGEE 402097000599 505 ALICE ROBERTSON JHS Middle Regular School No Middle 07 08 2017   grade_7 86 67 55 63   3     0   62   189 147                       336 86 67 55 63   3     0   62   189 147                 336
477051 OK CLEVELAND   school 4020250 14-I002   MOORE 402025002214 610 BRINK JHS Junior High Regular School No Middle 07 08 2017   grade_7 153 12 36 12   39     0   58   162 148                       310 153 12 36 12   39     0   58   162 148                 310
485189 OK TULSA   school 4023280 72-I011   OWASSO 402328001236 510 OWASSO 7TH GRADE CTR Middle Regular School No Middle 07 07 2017   grade_7 448 42 66 102   18     1   56   382 351                       733 448 42 66 102   18     1   56   382 351                 733
477057 OK CLEVELAND   school 4020250 14-I002   MOORE 402025001004 680 WEST JHS Junior High Regular School No Middle 07 08 2017   grade_7 127 37 91 18   28     0   55   191 165                       356 127 37 91 18   28     0   55   191 165                 356
482710 OK PAYNE   school 4028680 60-I016   STILLWATER 402868029740 505 STILLWATER MS Middle Regular School No Middle 06 07 2017   grade_7 296 13 46 22   16     0   55   207 241                       448 296 13 46 22   16     0   55   207 241                 448
477055 OK CLEVELAND   school 4020250 14-I002   MOORE 402025002215 655 HIGHLAND WEST JHS Junior High Regular School No Middle 07 08 2017   grade_7 133 14 54 17   7     0   52   132 145                       277 133 14 54 17   7     0   52   132 145                 277
484941 OK TULSA   school 4004500 72-I004   BIXBY 400450002097 505 BIXBY MS Middle Regular School No Middle 07 08 2017   grade_7 316 7 46 38   5     0   50   236 226                       462 316 7 46 38   5     0   50   236 226                 462
477889 OK CREEK   school 4026910 19-I033   SAPULPA 402691001882 505 SAPULPA MS Middle Regular School No Middle 06 07 2017   grade_7 152 6 21 42   0     0   48   128 141                       269 152 6 21 42   0     0   48   128 141                 269
483247 OK POTTAWATOMIE   school 4027570 63-I093   SHAWNEE 402757000728 505 SHAWNEE MS Middle Regular School No Middle 06 08 2017   grade_7 124 15 37 26   1     0   48   130 121                       251 124 15 37 26   1     0   48   130 121                 251
477215 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001073 500 IRVING MS Middle Regular School No Middle 06 08 2017   grade_7 155 27 27 16   9     1   47   152 130                       282 155 27 27 16   9     1   47   152 130                 282
477224 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2017   grade_7 235 18 47 18   23     0   44   185 200                       385 235 18 47 18   23     0   44   185 200                 385
485274 OK WAGONER   school 4031350 73-I019   WAGONER 403135001536 505 WAGONER MS Middle Regular School No Middle 06 08 2017   grade_7 84 7 6 51   0     0   41   100 89                       189 84 7 6 51   0     0   41   100 89                 189
485385 OK WASHINGTON   school 4003630 74-I030   BARTLESVILLE 400363029825 510 MADISON MS Middle Regular School No Middle 06 08 2017   grade_7 114 6 39 32   8     0   40   113 126                       239 114 6 39 32   8     0   40   113 126                 239
477061 OK CLEVELAND   school 4020250 14-I002   MOORE 402025002821 690 SOUTHRIDGE JHS Junior High Regular School No Middle 07 08 2017   grade_7 116 13 27 14   19     0   38   122 105                       227 116 13 27 14   19     0   38   122 105                 227
476313 OK CANADIAN   school 4033480 09-I027   YUKON 403348002723 520 YUKON MS Middle Regular School No Middle 06 08 2017   grade_7 437 22 95 30   19     1   37   306 335                       641 437 22 95 30   19     1   37   306 335                 641
485205 OK TULSA   school 4012720 72-I013   GLENPOOL 401272001981 505 GLENPOOL MS Middle Regular School No Middle 06 08 2017   grade_7 100 5 23 20   5     0   37   96 94                       190 100 5 23 20   5     0   37   96 94                 190
476392 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001047 505 MUSTANG MS Middle Regular School No Middle 07 08 2017   grade_7 292 10 39 19   10     1   36   225 182                       407 292 10 39 19   10     1   36   225 182                 407
479814 OK LOGAN   school 4013560 42-I001   GUTHRIE 401356000634 610 GUTHRIE JHS Junior High Regular School No Middle 07 08 2017   grade_7 172 20 28 9   0     0   36   138 127                       265 172 20 28 9   0     0   36   138 127                 265
476395 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001969 510 MUSTANG NORTH MS Middle Regular School No Middle 07 08 2017   grade_7 311 20 51 20   37     0   33   239 233                       472 311 20 51 20   37     0   33   239 233                 472
478792 OK HASKELL   school 4028650 31-I020   STIGLER 402865001504 505 STIGLER MS Middle Regular School No Middle 05 08 2017   grade_7 50 1 4 9   2     0   33   52 47                       99 50 1 4 9   2     0   33   52 47                 99
482971 OK PITTSBURG   school 4019440 61-I080   MCALESTER 401944000924 510 PUTERBAUGH MS Middle Regular School No Middle 07 08 2017   grade_7 114 9 27 29   2     0   33   123 91                       214 114 9 27 29   2     0   33   123 91                 214
484985 OK TULSA   school 4008370 72-I006   COLLINSVILLE 400837000350 500 COLLINSVILLE MS Middle Regular School No Middle 07 08 2017   grade_7 119 2 14 39   7     0   33   110 104                       214 119 2 14 39   7     0   33   110 104                 214
477218 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002117 501 ALCOTT MS Middle Regular School No Middle 06 08 2017   grade_7 120 12 51 7   3     0   32   123 102                       225 120 12 51 7   3     0   32   123 102                 225
481029 OK OKLAHOMA   school 4025290 55-I001   PUTNAM CITY 402529001184 510 JAMES L. CAPPS MS Middle Regular School No Middle 06 08 2017   grade_7 97 45 120 12   13     0   32   171 148                       319 97 45 120 12   13     0   32   171 148                 319
478940 OK JACKSON   school 4002850 33-I018   ALTUS 400285000036 625 ALTUS JHS Junior High Regular School No Middle 07 08 2017   grade_7 93 13 106 1   3     3   31   137 113                       250 93 13 106 1   3     3   31   137 113                 250
481103 OK OKLAHOMA   school 4007620 55-I004   CHOCTAW-NICOMA PARK 400762002698 520 CHOCTAW MS Middle Regular School No Middle 06 08 2017   grade_7 189 3 15 9   0     0   31   139 108                       247 189 3 15 9   0     0   31   139 108                 247
481316 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059029716 520 SUMMIT MS Middle Regular School No Middle 06 08 2017   grade_7 141 64 32 5   34     1   31   169 139                       308 141 64 32 5   34     1   31   169 139                 308
482565 OK OTTAWA   school 4019860 58-I023   MIAMI 401986000674 505 WILL ROGERS MS Middle Regular School No Middle 06 08 2017   grade_7 78 2 10 30   2     4   30   80 76                       156 78 2 10 30   2     4   30   80 76                 156
476327 OK CANADIAN   school 4010650 09-I034   EL RENO 401065000485 610 ETTA DALE JHS Junior High Regular School No Middle 07 08 2017   grade_7 81 5 52 23   0     0   29   105 85                       190 81 5 52 23   0     0   29   105 85                 190
479208 OK KAY   school 4024690 36-I071   PONCA CITY 402469002124 505 PONCA CITY WEST MS Middle Regular School No Middle 06 07 2017   grade_7 234 15 47 56   1     3   29   206 179                       385 234 15 47 56   1     3   29   206 179                 385
481323 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059002835 530 HEARTLAND MS Middle Regular School No Middle 06 08 2017   grade_7 176 41 35 6   16     1   29   152 152                       304 176 41 35 6   16     1   29   152 152                 304
484667 OK TULSA   school 4030240 72-I001   TULSA 403024001609 537 EDISON PREPARATORY MS Middle Regular School No Middle 06 08 2017   grade_7 128 43 59 19   8     2   29   148 140                       288 128 43 59 19   8     2   29   148 140                 288
477521 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002364 530 MACARTHUR MS Middle Regular School No Middle 06 08 2017   grade_7 115 43 48 17   8     2   28   135 126                       261 115 43 48 17   8     2   28   135 126                 261
481035 OK OKLAHOMA   school 4025290 55-I001   PUTNAM CITY 402529001240 530 HEFNER MS Middle Regular School No Middle 06 08 2017   grade_7 138 107 27 12   20     1   27   164 168                       332 138 107 27 12   20     1   27   164 168                 332
481100 OK OKLAHOMA   school 4007620 55-I004   CHOCTAW-NICOMA PARK 400762002691 515 NICOMA PARK MS Middle Regular School No Middle 06 08 2017   grade_7 126 12 17 12   2     0   27   117 79                       196 126 12 17 12   2     0   27   117 79                 196
485382 OK WASHINGTON   school 4003630 74-I030   BARTLESVILLE 400363029824 505 CENTRAL MS Middle Regular School No Middle 06 08 2017   grade_7 117 11 20 20   3     0   27   91 107                       198 117 11 20 20   3     0   27   91 107                 198
476035 OK BRYAN   school 4010350 07-I072   DURANT 401035000457 500 DURANT MS Middle Regular School No Middle 07 08 2017   grade_7 115 8 28 56   7     0   26   119 121                       240 115 8 28 56   7     0   26   119 121                 240
481041 OK OKLAHOMA   school 4025290 55-I001   PUTNAM CITY 402529001301 550 WESTERN OAKS MS Middle Regular School No Middle 06 08 2017   grade_7 91 53 72 7   3     1   26   125 128                       253 91 53 72 7   3     1   26   125 128                 253
482192 OK OKLAHOMA   school 4000778 55-Z002   OKLAHOMA VIRTUAL CHARTER ACAD 400077802784 971 OKLA. VIRTUAL CHARTER ACAD MS Charter (Virtual) Regular School Yes Middle 06 08 2017   grade_7 138 18 26 22   0     1   26   121 110                       231 138 18 26 22   0     1   26   121 110                 231
484909 OK TULSA   school 4005490 72-I003   BROKEN ARROW 400549002770 530 ONETA RIDGE MS Middle Regular School No Middle 06 08 2017   grade_7 183 7 35 23   11     0   26   150 135                       285 183 7 35 23   11     0   26   150 135                 285
485127 OK TULSA   school 4004020 72-I010   BERRYHILL 400402000128 510 BERRYHILL MS Middle Regular School No Middle 07 08 2017   grade_7 44 0 7 8   0     0   26   48 37                       85 44 0 7 8   0     0   26   48 37                 85
476681 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2017   grade_7 53 5 35 100   3     0   25   107 114                       221 53 5 35 100   3     0   25   107 114                 221
484903 OK TULSA   school 4005490 72-I003   BROKEN ARROW 400549029807 520 CHILDERS MS Middle Regular School No Middle 06 08 2017   grade_7 179 14 19 24   5     0   25   150 116                       266 179 14 19 24   5     0   25   150 116                 266
477221 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2017   grade_7 165 17 22 11   4     0   24   119 124                       243 165 17 22 11   4     0   24   119 124                 243
479694 OK LINCOLN   school 4007290 41-I001   CHANDLER 400729002375 610 CHANDLER JHS Junior High Regular School No Middle 07 08 2017   grade_7 53 3 1 5   0     0   24   43 43                       86 53 3 1 5   0     0   24   43 43                 86
481310 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059002303 510 CHEYENNE MS Middle Regular School No Middle 06 08 2017   grade_7 181 17 23 5   12     1   24   145 118                       263 181 17 23 5   12     1   24   145 118                 263
484683 OK TULSA   school 4030240 72-I001   TULSA 403024001677 661 HALE JHS Junior High Regular School No Middle 07 08 2017   grade_7 72 53 109 20   5     0   24   159 124                       283 72 53 109 20   5     0   24   159 124                 283
484900 OK TULSA   school 4005490 72-I003   BROKEN ARROW 400549000205 510 SEQUOYAH MS Middle Regular School No Middle 06 08 2017   grade_7 108 17 20 12   7     0   24   94 94                       188 108 17 20 12   7     0   24   94 94                 188
477524 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002393 535 CENTRAL MS Middle Regular School No Middle 06 08 2017   grade_7 89 58 59 17   3     2   23   131 120                       251 89 58 59 17   3     2   23   131 120                 251
477531 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002679 545 EISENHOWER MS Middle Regular School No Middle 06 08 2017   grade_7 93 100 52 24   9     1   23   157 145                       302 93 100 52 24   9     1   23   157 145                 302
483492 OK ROGERS   school 4007740 66-I001   CLAREMORE 400774002197 610 WILL ROGERS JHS Junior High Regular School No Middle 06 08 2017   grade_7 155 2 29 93   2     0   23   154 150                       304 155 2 29 93   2     0   23   154 150                 304
477947 OK CUSTER   school 4032070 20-I026   WEATHERFORD 403207029848 510 WEATHERFORD MS Middle Regular School No Middle 06 08 2017   grade_7 88 1 27 13   2     0   22   77 76                       153 88 1 27 13   2     0   22   77 76                 153
483023 OK PONTOTOC   school 4006060 62-I016   BYNG 400606029751 610 BYNG JHS Junior High Regular School No Other 07 09 2017   grade_7 70 5 3 38   1     0   22   57 82                       139 70 5 3 38   1     0   22   57 82                 139
484661 OK TULSA   school 4030240 72-I001   TULSA 403024001594 515 CARVER MS Middle Regular School No Middle 06 08 2017   grade_7 60 60 36 13   6     0   22   75 122                       197 60 60 36 13   6     0   22   75 122                 197
484673 OK TULSA   school 4030240 72-I001   TULSA 403024002281 573 THOREAU DEMONSTRATION ACADEMY Middle Regular School No Middle 06 08 2017   grade_7 111 32 45 18   5     1   22   115 119                       234 111 32 45 18   5     1   22   115 119                 234
477528 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002404 540 TOMLINSON MS Middle Regular School No Middle 06 08 2017   grade_7 65 82 50 9   4     0   21   123 108                       231 65 82 50 9   4     0   21   123 108                 231
478332 OK GARFIELD   school 4010920 24-I057   ENID 401092000510 515 DEWITT WALLER MS Middle Regular School No Middle 06 08 2017   grade_7 147 9 29 8   8     11   20   124 108                       232 147 9 29 8   8     11   20   124 108                 232
483869 OK SEQUOYAH   school 4026310 68-I005   ROLAND 402631001386 610 ROLAND JHS Junior High Regular School No Other 07 09 2017   grade_7 27 3 5 9   0     0   20   34 30                       64 27 3 5 9   0     0   20   34 30                 64
484664 OK TULSA   school 4030240 72-I001   TULSA 403024001601 530 CLINTON MS Middle Regular School No Middle 06 08 2017   grade_7 50 35 25 12   2     1   20   70 75                       145 50 35 25 12   2     1   20   70 75                 145
484906 OK TULSA   school 4005490 72-I003   BROKEN ARROW 400549002095 525 OLIVER MS Middle Regular School No Middle 06 08 2017   grade_7 156 23 25 26   5     1   20   126 130                       256 156 23 25 26   5     1   20   126 130                 256
481313 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059000481 515 SEQUOYAH MS Middle Regular School No Middle 06 08 2017   grade_7 310 28 29 11   12     1   19   213 197                       410 310 28 29 11   12     1   19   213 197                 410
476474 OK CARTER   school 4024240 10-I027   PLAINVIEW 402424001279 505 PLAINVIEW MS Middle Regular School No Middle 06 08 2017   grade_7 69 2 10 15   2     0   18   60 56                       116 69 2 10 15   2     0   18   60 56                 116
482005 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001150 518 JEFFERSON MS Middle Regular School No Middle 07 08 2017   grade_7 36 32 339 20   0     1   18   229 217                       446 36 32 339 20   0     1   18   229 217                 446
477569 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2017   grade_7 115 5 29 15   1     1   17   89 94                       183 115 5 29 15   1     1   17   89 94                 183
481306 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059000475 505 CIMARRON MS Middle Regular School No Middle 06 08 2017   grade_7 183 32 38 7   4     1   17   139 143                       282 183 32 38 7   4     1   17   139 143                 282
481378 OK OKLAHOMA   school 4032370 55-I041   WESTERN HEIGHTS 403237002244 515 WESTERN HEIGHTS MS Middle Regular School No Middle 07 08 2017   grade_7 43 58 114 20   7     3   17   151 111                       262 43 58 114 20   7     3   17   151 111                 262
484897 OK TULSA   school 4005490 72-I003   BROKEN ARROW 400549000200 505 CENTENNIAL MS Middle Regular School No Middle 06 08 2017   grade_7 193 20 71 29   18     1   17   174 175                       349 193 20 71 29   18     1   17   174 175                 349
477697 OK CRAIG   school 4031290 18-I065   VINITA 403129001732 510 EWING HALSELL MS Middle Regular School No Middle 06 08 2017   grade_7 48 4 2 43   1     0   16   61 53                       114 48 4 2 43   1     0   16   61 53                 114
477854 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000154 505 KELLYVILLE MS Middle Regular School No Middle 07 08 2017   grade_7 46 0 1 17   0     0   16   44 36                       80 46 0 1 17   0     0   16   44 36                 80
478015 OK DELAWARE   school 4015690 21-I001   JAY 401569000737 505 JAY MS Middle Regular School No Middle 06 08 2017   grade_7 41 0 4 49   4     0   16   65 49                       114 41 0 4 49   4     0   16   65 49                 114
480466 OK MURRAY   school 4029160 50-I001   SULPHUR 402916002703 510 SULPHUR MS Middle Regular School No Middle 06 08 2017   grade_7 74 1 8 10   2     0   16   63 48                       111 74 1 8 10   2     0   16   63 48                 111
483137 OK POTTAWATOMIE   school 4019560 63-I001   MCLOUD 401956000933 610 MCLOUD JHS Junior High Regular School No Middle 07 08 2017   grade_7 68 1 10 26   0     0   16   53 68                       121 68 1 10 26   0     0   16   53 68                 121
484681 OK TULSA   school 4030240 72-I001   TULSA 403024001614 659 EAST CENTRAL JHS Junior High Regular School No Middle 07 08 2017   grade_7 38 73 183 14   15     0   16   171 168                       339 38 73 183 14   15     0   16   171 168                 339
478592 OK GRADY   school 4005400 26-I095   BRIDGE CREEK 400540001674 505 BRIDGE CREEK MS Middle Regular School No Middle 06 08 2017   grade_7 85 0 4 2   0     0   15   57 49                       106 85 0 4 2   0     0   15   57 49                 106
481501 OK OKLAHOMA   school 4019950 55-I052   MIDWEST CITY-DEL CITY 401995002671 520 KERR MS Middle Regular School No Middle 06 08 2017   grade_7 45 71 21 16   5     0   15   87 86                       173 45 71 21 16   5     0   15   87 86                 173
481504 OK OKLAHOMA   school 4019950 55-I052   MIDWEST CITY-DEL CITY 401995002655 525 MONRONEY MS Middle Regular School No Middle 06 08 2017   grade_7 65 62 28 9   0     1   15   92 88                       180 65 62 28 9   0     1   15   92 88                 180
481551 OK OKLAHOMA   school 4004110 55-I088   BETHANY 400411029723 505 BETHANY MS Middle Regular School No Middle 06 08 2017   grade_7 85 4 17 3   2     0   15   66 60                       126 85 4 17 3   2     0   15   66 60                 126
482086 OK OKLAHOMA   school 4000781 55-E001   OKLAHOMA CITY 400078102305 971 INDEPENDENCE CHARTER MS Charter Regular School Yes Middle 06 08 2017   grade_7 26 49 9 7   6     0   15   51 61                       112 26 49 9 7   6     0   15   51 61                 112
482283 OK OKMULGEE   school 4003810 56-I004   BEGGS 400381000120 505 BEGGS MS Middle Regular School No Middle 05 08 2017   grade_7 53 7 3 11   0     1   15   45 45                       90 53 7 3 11   0     1   15   45 45                 90
484685 OK TULSA   school 4030240 72-I001   TULSA 403024002737 662 MCLAIN JHS Junior High Regular School No Middle 07 08 2017   grade_7 22 93 46 4   0     1   15   102 79                       181 22 93 46 4   0     1   15   102 79                 181
479264 OK KINGFISHER   school 4022950 37-I003   LOMEGA 402295001223 105 LOMEGA ES Elementary Regular School No Elementary PK 08 2017   grade_7 10 0 0 1   0     0   14   13 12                       25 10 0 0 1   0     0   14   13 12                 25
479854 OK LOGAN   school 4008940 42-I014   COYLE 400894000375 105 COYLE ES Elementary Regular School No Elementary PK 08 2017   grade_7 5 4 2 6   0     0   14   15 16                       31 5 4 2 6   0     0   14   15 16                 31
480134 OK MCCLAIN   school 4021510 47-I001   NEWCASTLE 402151001058 505 NEWCASTLE MS Middle Regular School No Middle 06 08 2017   grade_7 91 1 18 26   2     0   14   78 74                       152 91 1 18 26   2     0   14   78 74                 152
482429 OK OSAGE   school 4003570 57-I029   BARNSDALL 400357000093 615 BARNSDALL JHS Junior High Regular School No Middle 07 08 2017   grade_7 11 0 1 0   0     0   14   13 13                       26 11 0 1 0   0     0   14   13 13                 26
482633 OK PAWNEE   school 4008040 59-I006   CLEVELAND 400804000333 505 CLEVELAND MS Middle Regular School No Middle 06 08 2017   grade_7 90 0 7 27   0     0   14   65 73                       138 90 0 7 27   0     0   14   65 73                 138
478325 OK GARFIELD   school 4010920 24-I057   ENID 401092002700 505 EMERSON MS Middle Regular School No Middle 06 08 2017   grade_7 76 3 50 1   2     9   13   83 71                       154 76 3 50 1   2     9   13   83 71                 154
478329 OK GARFIELD   school 4010920 24-I057   ENID 401092002686 510 LONGFELLOW MS Middle Regular School No Middle 06 08 2017   grade_7 46 11 77 2   1     37   13   94 93                       187 46 11 77 2   1     37   13   94 93                 187
478607 OK GRADY   school 4030420 26-I097   TUTTLE 403042001696 505 TUTTLE MS Middle Regular School No Middle 06 08 2017   grade_7 122 1 13 17   2     2   13   90 80                       170 122 1 13 17   2     2   13   90 80                 170
479769 OK LINCOLN   school 4024930 41-I103   PRAGUE 402493001312 505 PRAGUE MS Middle Regular School No Middle 06 08 2017   grade_7 38 2 3 9   0     0   13   37 28                       65 38 2 3 9   0     0   13   37 28                 65
480274 OK MCCURTAIN   school 4015370 48-I005   IDABEL 401537000724 505 IDABEL MS Middle Regular School No Middle 06 08 2017   grade_7 15 18 12 6   1     2   13   35 32                       67 15 18 12 6   1     2   13   35 32                 67
480739 OK NOBLE   school 4020340 52-I006   MORRISON 402034002657 510 MORRISON MS Middle Regular School No Middle 07 08 2017   grade_7 36 0 1 1   0     1   13   29 23                       52 36 0 1 1   0     1   13   29 23                 52
481032 OK OKLAHOMA   school 4025290 55-I001   PUTNAM CITY 402529001195 520 COOPER MS Middle Regular School No Middle 06 08 2017   grade_7 64 88 23 5   11     1   13   107 98                       205 64 88 23 5   11     1   13   107 98                 205
482017 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001196 525 TAFT MS Middle Regular School No Middle 07 08 2017   grade_7 36 53 152 17   7     0   13   144 134                       278 36 53 152 17   7     0   13   144 134                 278
482019 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001202 530 WEBSTER MS Middle Regular School No Middle 07 08 2017   grade_7 66 91 322 17   4     0   13   266 247                       513 66 91 322 17   4     0   13   266 247                 513
482740 OK PAYNE   school 4009240 60-I067   CUSHING 400924000388 505 CUSHING MS Middle Regular School No Middle 05 08 2017   grade_7 96 4 8 36   0     0   13   87 70                       157 96 4 8 36   0     0   13   87 70                 157
483039 OK PONTOTOC   school 4002430 62-I019   ADA 400243000725 610 ADA JHS Junior High Regular School No Other 07 09 2017   grade_7 80 10 27 60   4     0   13   94 100                       194 80 10 27 60   4     0   13   94 100                 194

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