Data source: Big Local News · About: Big Local

2,956 rows where grade = "grade_7" and state = "OK" sorted by white descending

View and edit SQL

year

grade

  • grade_7 · 2,956
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
475824 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074000496 610 8TH AND 9TH GRADE CTR Junior High Regular School No Other 07 09 2017   grade_7 99 6 30 9   1     0   7   85 67                       152 99 6 30 9   1     0   7   85 67                 152
483977 OK STEPHENS   school 4019080 69-I003   MARLOW 401908000906 505 MARLOW MS Middle Regular School No Middle 06 08 2017   grade_7 99 1 8 12   1     0   2   67 56                       123 99 1 8 12   1     0   2   67 56                 123
3029271 OK LE FLORE   school 4024870 40-I029   POTEAU 402487001309 505 PANSY KIDD MS Middle Regular School No Middle 06 08 2020   grade_7 99 1 39 39   1     0   19   106 92                       198 99 1 39 39   1     0   19   106 92                 198
482725 OK PAYNE   school 4023800 60-I056   PERKINS-TRYON 402380002379 510 PERKINS-TRYON MS Middle Regular School No Middle 06 08 2017   grade_7 98 3 2 17   0     0   0   69 51                       120 98 3 2 17   0     0   0   69 51                 120
2315765 OK TULSA   school 4027750 72-I007   SKIATOOK 402775001476 505 NEWMAN MS Middle Regular School No Middle 06 08 2019   grade_7 98 2 4 40   0     1   31   79 97                       176 98 2 4 40   0     1   31   79 97                 176
3026171 OK CARTER   school 4003180 10-I019   ARDMORE 400318029636 505 ARDMORE MS Middle Regular School No Middle 06 08 2020   grade_7 98 29 34 19   0     0   38   113 105                       218 98 29 34 19   0     0   38   113 105                 218
3028632 OK JACKSON   school 4002850 33-I018   ALTUS 400285000036 625 ALTUS JHS Junior High Regular School No Middle 07 08 2020   grade_7 98 14 100 1   2     2   23   141 99                       240 98 14 100 1   2     2   23   141 99                 240
3030756 OK OKLAHOMA   school 4025290 55-I001   PUTNAM CITY 402529001184 510 JAMES L. CAPPS MS Middle Regular School No Middle 06 08 2020   grade_7 98 78 116 10   16     0   23   155 186                       341 98 78 116 10   16     0   23   155 186                 341
3034504 OK TULSA   school 4008370 72-I006   COLLINSVILLE 400837000350 500 COLLINSVILLE MS Middle Regular School No Middle 07 08 2020   grade_7 98 2 25 37   10     0   32   121 83                       204 98 2 25 37   10     0   32   121 83                 204
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
3326781 OK DELAWARE   school 4013530 21-I002   GROVE 401353000627 505 GROVE MS Middle Regular School No Middle 07 08 2021   grade_7 98 4 8 76   5     0   0   94 97                       191 98 4 8 76   5     0   0   94 97                 191
3328928 OK MCCLAIN   school 4004680 47-I029   BLANCHARD 400468002240 510 BLANCHARD MS Middle Regular School No Middle 06 08 2021   grade_7 98 0 13 16   0     0   16   70 73                       143 98 0 13 16   0     0   16   70 73                 143
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
3030317 OK MUSKOGEE   school 4020970 51-I020   MUSKOGEE 402097000599 505 7TH AND 8TH GRADE ACADEMY Middle Regular School No Middle 07 08 2020   grade_7 97 78 63 54   2     1   96   196 195                       391 97 78 63 54   2     1   96   196 195                 391
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
2308790 OK DELAWARE   school 4013530 21-I002   GROVE 401353000627 505 GROVE MS Middle Regular School No Middle 07 08 2019   grade_7 96 1 9 90   0     1   1   97 101                       198 96 1 9 90   0     1   1   97 101                 198
2309337 OK GRADY   school 4005400 26-I095   BRIDGE CREEK 400540001674 505 BRIDGE CREEK MS Middle Regular School No Middle 06 08 2019   grade_7 96 0 16 3   0     0   11   70 56                       126 96 0 16 3   0     0   11   70 56                 126
2350984 OK GRADY   school 4005400 26-I095   BRIDGE CREEK 400540001674 505 BRIDGE CREEK MS Middle Regular School No Middle 06 08 2018   grade_7 96 1 9 9   0     0   9   64 60                       124 96 1 9 9   0     0   9   64 60                 124
2354585 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 2018   grade_7 96 12 22 18   3     1   21   75 98                       173 96 12 22 18   3     1   21   75 98                 173
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
2315980 OK TULSA   school 4012720 72-I013   GLENPOOL 401272001981 505 GLENPOOL MS Middle Regular School No Middle 06 08 2019   grade_7 95 4 25 33   11     1   40   112 97                       209 95 4 25 33   11     1   40   112 97                 209
479594 OK LE FLORE   school 4024870 40-I029   POTEAU 402487001309 505 PANSY KIDD MS Middle Regular School No Middle 06 08 2017   grade_7 94 4 29 23   3     0   2   84 71                       155 94 4 29 23   3     0   2   84 71                 155
2311368 OK MUSKOGEE   school 4020970 51-I020   MUSKOGEE 402097000599 505 ALICE ROBERTSON JHS Middle Regular School No Middle 07 08 2019   grade_7 94 58 57 51   2     0   70   170 162                       332 94 58 57 51   2     0   70   170 162                 332
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
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
2315424 OK TULSA   school 4030240 72-I001   TULSA 403024002281 573 THOREAU DEMONSTRATION ACADEMY Middle Regular School No Middle 06 08 2019   grade_7 93 38 52 14   2     1   24   98 126                       224 93 38 52 14   2     1   24   98 126                 224
2353556 OK OKLAHOMA   school 4013890 55-I007   HARRAH 401389000656 505 HARRAH MS Middle Regular School No Middle 06 08 2018   grade_7 93 3 7 32   1     1   4   71 70                       141 93 3 7 32   1     1   4   71 70                 141
481159 OK OKLAHOMA   school 4013890 55-I007   HARRAH 401389000656 505 HARRAH MS Middle Regular School No Middle 06 08 2017   grade_7 92 3 10 23   1     0   5   66 68                       134 92 3 10 23   1     0   5   66 68                 134
2308959 OK GARFIELD   school 4021780 24-I042   CHISHOLM 402178002105 505 CHISHOLM MS Middle Regular School No Middle 06 08 2019   grade_7 92 1 9 1   2     0   0   56 49                       105 92 1 9 1   2     0   0   56 49                 105
2310796 OK MAYES   school 4025200 46-I001   PRYOR 402520001323 610 PRYOR JHS Junior High Regular School No Middle 07 09 2019   grade_7 92 1 12 64   1     0   29   94 105                       199 92 1 12 64   1     0   29   94 105                 199
2353293 OK OKLAHOMA   school 4000800 55-G008   EPIC BLENDED LEARNING CHARTER 400080002865 951 EPIC BLENDED CHARTER TULSA MS Charter Regular School Yes Middle 06 08 2018   grade_7 92 18 24 23   4     0   0   72 89                       161 92 18 24 23   4     0   0   72 89                 161
3326284 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002679 545 EISENHOWER MS Middle Regular School No Middle 06 08 2021   grade_7 92 67 64 8   8     5   57   165 136                       301 92 67 64 8   8     5   57   165 136                 301
3331262 OK PAYNE   school 4023800 60-I056   PERKINS-TRYON 402380002379 510 PERKINS-TRYON MS Middle Regular School No Middle 06 08 2021   grade_7 92 5 5 21   1     0   0   69 55                       124 92 5 5 21   1     0   0   69 55                 124
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
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
2350912 OK GRADY   school 4007560 26-I001   CHICKASHA 400756002342 510 CHICKASHA MS Middle Regular School No Middle 07 08 2018   grade_7 91 14 22 18   2     0   19   87 79                       166 91 14 22 18   2     0   19   87 79                 166
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
2352510 OK MCCLAIN   school 4021510 47-I001   NEWCASTLE 402151001058 505 NEWCASTLE MS Middle Regular School No Middle 06 08 2018   grade_7 90 0 24 25   0     0   19   70 88                       158 90 0 24 25   0     0   19   70 88                 158
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
476717 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504002369 515 BOSWELL MS Middle Regular School No Middle 07 08 2017   grade_7 9 1 4 8   0     0   0   8 14                       22 9 1 4 8   0     0   0   8 14                 22
477394 OK COMANCHE   school 4012630 16-I004   GERONIMO 401263002732 505 GERONIMO MS Middle Regular School No Middle 07 08 2017   grade_7 9 2 6 3   1     0   2   13 10                       23 9 2 6 3   1     0   2   13 10                 23
477824 OK CREEK   school 4022560 19-I020   OILTON 402256001102 105 J. F. KENNEDY ES Elementary Regular School No Elementary PK 08 2017   grade_7 9 0 0 7   0     0   1   9 8                       17 9 0 0 7   0     0   1   9 8                 17
478137 OK ELLIS   school 4011430 23-I002   FARGO 401143000542 105 FARGO ES Elementary Regular School No Elementary PK 08 2017   grade_7 9 0 2 2   0     0   0   5 8                       13 9 0 2 2   0     0   0   5 8                 13
478675 OK GRANT   school 4017020 27-I095   DEER CREEK-LAMONT 401702000788 105 DEER CREEK-LAMONT ES Elementary Regular School No Elementary PK 08 2017   grade_7 9 0 0 3   1     0   0   8 5                       13 9 0 0 3   1     0   0   8 5                 13
479094 OK JOHNSTON   school 4019980 35-I029   MILBURN 401998000976 105 MILBURN ES Elementary Regular School No Elementary PK 08 2017   grade_7 9 0 2 5   0     0   0   8 8                       16 9 0 2 5   0     0   0   8 8                 16
479460 OK LE FLORE   school 4020190 40-C011   MONROE 402019000987 105 MONROE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 9 0 2 1   0     0   0   11 1                       12 9 0 2 1   0     0   0   11 1                 12
479578 OK LE FLORE   school 4004950 40-I026   BOKOSHE 400495000422 615 BOKOSHE JHS Junior High Regular School No Other 07 09 2017   grade_7 9 0 1 3   0     0   0   8 5                       13 9 0 1 3   0     0   0   8 5                 13
480330 OK MCCURTAIN   school 4027840 48-I014   SMITHVILLE 402784001855 505 SMITHVILLE MS Middle Regular School No Middle 06 08 2017   grade_7 9 0 0 6   0     0   0   6 9                       15 9 0 0 6   0     0   0   6 9                 15
482862 OK PITTSBURG   school 4013620 61-I011   HAILEYVILLE 401362000644 105 HAILEYVILLE ES Elementary Regular School No Elementary PK 08 2017   grade_7 9 0 0 11   0     0   0   7 13                       20 9 0 0 11   0     0   0   7 13                 20
483884 OK SEQUOYAH   school 4012900 68-I006   GORE 401290002294 115 GORE UPPER ES Elementary Regular School No Middle 06 08 2017   grade_7 9 0 3 20   0     2   0   20 14                       34 9 0 3 20   0     2   0   20 14                 34
484676 OK TULSA   school 4030240 72-I001   TULSA 403024002736 574 TRAICE MS Middle Regular School No Middle 06 08 2017   grade_7 9 9 2 4   0     0   4   17 11                       28 9 9 2 4   0     0   4   17 11                 28
485487 OK WOODS   school 4012180 76-I006   FREEDOM 401218000573 105 FREEDOM ES Elementary Regular School No Elementary PK 08 2017   grade_7 9 0 1 3   0     0   0   5 8                       13 9 0 1 3   0     0   0   5 8                 13
2307195 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 0 5   0     0   5   8 11                       19 9 0 0 5   0     0   5   8 11                 19
2307489 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504002369 515 BOSWELL MS Middle Regular School No Middle 07 08 2019   grade_7 9 1 1 9   0     0   3   16 7                       23 9 1 1 9   0     0   3   16 7                 23
2307584 OK CLEVELAND   school 4026100 14-C016   ROBIN HILL 402610001380 105 ROBIN HILL PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 0 1   0     0   1   6 5                       11 9 0 0 1   0     0   1   6 5                 11
2308733 OK DELAWARE   school 4008010 21-C006   CLEORA 400801000330 105 CLEORA PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 0 8   0     0   0   10 7                       17 9 0 0 8   0     0   0   10 7                 17
2309451 OK GREER   school 4013290 28-I003   GRANITE 401329000616 105 GRANITE ES Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 2 1   0     0   3   10 5                       15 9 0 2 1   0     0   3   10 5                 15
2309740 OK JEFFERSON   school 4026610 34-I001   RYAN 402661001393 105 RYAN ES Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 6 0   0     0   0   7 8                       15 9 0 6 0   0     0   0   7 8                 15
2309871 OK KAY   school 4023700 36-C027   PECKHAM 402370001257 105 PECKHAM PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 1 1   0     0   0   6 5                       11 9 0 1 1   0     0   0   6 5                 11
2310369 OK LE FLORE   school 4032730 40-I062   WHITESBORO 403273001807 105 WHITESBORO ES Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 0 4   0     0   1   7 7                       14 9 0 0 4   0     0   1   7 7                 14
2310509 OK LINCOLN   school 4006690 41-I105   CARNEY 400669000261 105 CARNEY ES Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 2 6   0     0   1   10 8                       18 9 0 2 6   0     0   1   10 8                 18
2310640 OK LOVE   school 4030300 43-I005   TURNER 403030001686 105 TURNER ES Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 3 4   0     0   0   5 11                       16 9 0 3 4   0     0   0   5 11                 16
2310999 OK MCCURTAIN   school 4009720 48-C037   DENISON 400972000417 105 DENISON PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   grade_7 9 1 1 6   1     0   1   9 10                       19 9 1 1 6   1     0   1   9 10                 19
2312911 OK OKLAHOMA   school 4000766 55-E012   OKLAHOMA CITY 400076602408 982 KIPP REACH COLLEGE PREPARATORY Charter Regular School Yes Middle 05 08 2019   grade_7 9 46 11 0   1     0   1   27 41                       68 9 46 11 0   1     0   1   27 41                 68
2313082 OK OKMULGEE   school 4027090 56-I006   SCHULTER 402709001434 105 SCHULTER ES Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 0 6   2     0   0   9 8                       17 9 0 0 6   2     0   0   9 8                 17
2313418 OK PAYNE   school 4022160 60-C104   OAK GROVE 402216001097 105 OAK GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 2 1   0     0   1   5 8                       13 9 0 2 1   0     0   1   5 8                 13
2314439 OK SEMINOLE   school 4021360 67-I006   NEW LIMA 402136001054 110 NEW LIMA ES Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 2 4   0     0   7   12 10                       22 9 0 2 4   0     0   7   12 10                 22
2314453 OK SEMINOLE   school 4030990 67-I007   VARNUM 403099001717 105 VARNUM ES Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 2 11   0     0   1   14 9                       23 9 0 2 11   0     0   1   14 9                 23
2314906 OK TEXAS   school 4012870 70-I060   GOODWELL 401287000597 105 GOODWELL ES Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 9 0   0     0   0   10 8                       18 9 0 9 0   0     0   0   10 8                 18
2314920 OK TEXAS   school 4029820 70-I061   TEXHOMA 402982001562 105 TEXHOMA ES Elementary Regular School No Elementary PK 08 2019   grade_7 9 0 13 1   0     0   0   11 12                       23 9 0 13 1   0     0   0   11 12                 23
2314974 OK TILLMAN   school 4013200 71-I249   GRANDFIELD 401320000612 105 GRANDFIELD ES Elementary Regular School No Elementary PK 08 2019   grade_7 9 1 8 0   0     0   3   8 13                       21 9 1 8 0   0     0   3   8 13                 21
2348054 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000220 105 BURLINGTON ES Elementary Regular School No Elementary PK 08 2018   grade_7 9 0 0 0   0     0   1   5 5                       10 9 0 0 0   0     0   1   5 5                 10
2348098 OK ATOKA   school 4013830 03-C021   HARMONY 401383000653 105 HARMONY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2018   grade_7 9 0 0 6   0     0   4   11 8                       19 9 0 0 6   0     0   4   11 8                 19
2348202 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2018   grade_7 9 0 3 0   0     0   0   4 8                       12 9 0 3 0   0     0   0   4 8                 12
2348478 OK CADDO   school 4018390 08-I012   LOOKEBA SICKLES 401839000876 105 LOOKEBA-SICKLES ES Elementary Regular School No Elementary PK 08 2018   grade_7 9 0 5 1   0     0   2   10 7                       17 9 0 5 1   0     0   2   10 7                 17
2349158 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001484 105 SOPER ES Elementary Regular School No Elementary PK 08 2018   grade_7 9 0 1 17   0     0   0   16 11                       27 9 0 1 17   0     0   0   16 11                 27
2349229 OK CLEVELAND   school 4026100 14-C016   ROBIN HILL 402610001380 105 ROBIN HILL PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2018   grade_7 9 1 2 6   0     0   0   12 6                       18 9 1 2 6   0     0   0   12 6                 18
2349711 OK COAL   school 4030270 15-I002   TUPELO 403027001683 105 TUPELO ES Elementary Regular School No Elementary PK 08 2018   grade_7 9 0 1 7   0     0   1   11 7                       18 9 0 1 7   0     0   1   11 7                 18
2350021 OK COTTON   school 4004350 17-I333   BIG PASTURE 400435000138 105 BIG PASTURE ES Elementary Regular School No Elementary PK 08 2018   grade_7 9 0 4 1   0     0   3   9 8                       17 9 0 4 1   0     0   3   9 8                 17
2351117 OK HARMON   school 4014850 29-I066   HOLLIS 401485000701 510 HOLLIS MS Middle Regular School No Middle 06 08 2018   grade_7 9 4 22 0   1     0   7   18 25                       43 9 4 22 0   1     0   7   18 25                 43
2351270 OK HUGHES   school 4006270 32-I048   CALVIN 400627000243 105 CALVIN ES Elementary Regular School No Elementary PK 08 2018   grade_7 9 0 1 4   0     0   1   7 8                       15 9 0 1 4   0     0   1   7 8                 15
2351645 OK KINGFISHER   school 4022950 37-I003   LOMEGA 402295001223 105 LOMEGA ES Elementary Regular School No Elementary PK 08 2018   grade_7 9 1 4 0   1     0   6   9 12                       21 9 1 4 0   1     0   6   9 12                 21
2351842 OK LE FLORE   school 4020190 40-C011   MONROE 402019000987 105 MONROE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2018   grade_7 9 0 0 1   0     0   0   5 5                       10 9 0 0 1   0     0   0   5 5                 10
2352637 OK MCCURTAIN   school 4014890 48-C072   HOLLY CREEK 401489000702 105 HOLLY CREEK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2018   grade_7 9 0 2 4   0     0   2   6 11                       17 9 0 2 4   0     0   2   6 11                 17
2355582 OK POTTAWATOMIE   school 4010500 63-I005   EARLSBORO 401050000469 105 EARLSBORO ES Elementary Regular School No Elementary PK 08 2018   grade_7 9 2 0 5   0     0   5   9 12                       21 9 2 0 5   0     0   5   9 12                 21
3025772 OK CADDO   school 4018390 08-I012   LOOKEBA SICKLES 401839000876 105 LOOKEBA-SICKLES ES Elementary Regular School No Elementary PK 08 2020   grade_7 9 0 4 0   0     0   1   2 12                       14 9 0 4 0   0     0   1   2 12                 14
3025818 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2020   grade_7 9 0 5 7   0     0   7   19 9                       28 9 0 5 7   0     0   7   19 9                 28
3027015 OK COAL   school 4030270 15-I002   TUPELO 403027001683 105 TUPELO ES Elementary Regular School No Elementary PK 08 2020   grade_7 9 0 0 4   0     0   4   12 5                       17 9 0 0 4   0     0   4   12 5                 17
3027369 OK CRAIG   school 4032190 18-I017   WELCH 403219001782 515 WELCH MS Middle Regular School No Middle 06 08 2020   grade_7 9 0 3 8   0     0   0   10 10                       20 9 0 3 8   0     0   0   10 10                 20
3027526 OK CREEK   school 4022560 19-I020   OILTON 402256001102 105 J. F. KENNEDY ES Elementary Regular School No Elementary PK 08 2020   grade_7 9 0 0 3   0     0   0   9 3                       12 9 0 0 3   0     0   0   9 3                 12
3028538 OK HUGHES   school 4032430 32-I005   WETUMKA 403243001796 105 WETUMKA ES Elementary Regular School No Elementary PK 08 2020   grade_7 9 1 2 17   0     0   1   11 19                       30 9 1 2 17   0     0   1   11 19                 30
3028682 OK JEFFERSON   school 4026610 34-I001   RYAN 402661001393 105 RYAN ES Elementary Regular School No Elementary PK 08 2020   grade_7 9 0 5 3   0     0   2   12 7                       19 9 0 5 3   0     0   2   12 7                 19
3029102 OK LATIMER   school 4005820 39-I003   BUFFALO VALLEY 400582000217 105 BUFFALO VALLEY ES Elementary Regular School No Elementary PK 08 2020   grade_7 9 0 0 0   0     0   0   6 3                       9 9 0 0 0   0     0   0   6 3                 9
3029130 OK LE FLORE   school 4027450 40-C004   SHADY POINT 402745001450 105 SHADY POINT PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 9 0 0 5   0     0   1   3 12                       15 9 0 0 5   0     0   1   3 12                 15
3029313 OK LE FLORE   school 4032730 40-I062   WHITESBORO 403273001807 105 WHITESBORO ES Elementary Regular School No Elementary PK 08 2020   grade_7 9 0 0 4   0     0   0   3 10                       13 9 0 0 4   0     0   0   3 10                 13
3029799 OK MAYES   school 4007670 46-I032   CHOUTEAU-MAZIE 400767000319 110 MAZIE ES Elementary Regular School No Elementary PK 08 2020   grade_7 9 0 0 0   0     0   2   7 4                       11 9 0 0 0   0     0   2   7 4                 11
3030421 OK NOBLE   school 4000020 52-I004   FRONTIER 400002025620 105 FRONTIER ES Elementary Regular School No Elementary PK 08 2020   grade_7 9 0 2 18   0     0   0   18 11                       29 9 0 2 18   0     0   0   18 11                 29
3030479 OK NOWATA   school 4026640 53-I051   SOUTH COFFEYVILLE 402664001395 105 SOUTH COFFEYVILLE ES Elementary Regular School No Elementary PK 08 2020   grade_7 9 0 0 5   0     0   0   9 5                       14 9 0 0 5   0     0   0   9 5                 14
3030589 OK OKLAHOMA   school 4000783 55-G004   ASTEC CHARTERS 400078302308 971 ASTEC CHARTER MS Charter Regular School Yes Middle 06 08 2020   grade_7 9 2 153 3   8     0   1   96 80                       176 9 2 153 3   8     0   1   96 80                 176
3032028 OK OSAGE   school 4030048 57-I090   WOODLAND 403004829729 110 WOODLAND UPPER ES Elementary Regular School No Middle 06 08 2020   grade_7 9 0 1 20   1     0   0   21 10                       31 9 0 1 20   1     0   0   21 10                 31

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