Data source: Big Local News · About: Big Local

2,956 rows where grade = "grade_7" and state = "OK" sorted by multiracial 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
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
3333695 OK TULSA   school 4023280 72-I011   OWASSO 402328001236 510 OWASSO 7TH GRADE CTR Middle Regular School No Middle 07 07 2021   grade_7 388 39 76 60   37     2   91   356 337                       693 388 39 76 60   37     2   91   356 337                 693
477962 OK CUSTER   school 4008070 20-I099   CLINTON 400807000339 505 CLINTON MS Middle Regular School No Middle 07 08 2017   grade_7 53 5 85 15   2     0   9   82 87                       169 53 5 85 15   2     0   9   82 87                 169
478519 OK GRADY   school 4007560 26-I001   CHICKASHA 400756002342 510 CHICKASHA MS Middle Regular School No Middle 07 08 2017   grade_7 85 20 22 18   1     0   9   77 78                       155 85 20 22 18   1     0   9   77 78                 155
479338 OK KIOWA   school 4014700 38-I001   HOBART 401470000692 505 HOBART MS Middle Regular School No Middle 06 08 2017   grade_7 33 6 12 0   1     0   9   27 34                       61 33 6 12 0   1     0   9   27 34                 61
479520 OK LE FLORE   school 4024630 40-I007   POCOLA 402463001289 505 POCOLA MS Middle Regular School No Middle 06 08 2017   grade_7 39 2 2 13   0     0   9   37 28                       65 39 2 2 13   0     0   9   37 28                 65
479754 OK LINCOLN   school 4019680 41-I095   MEEKER 401968000939 505 MEEKER MS Middle Regular School No Middle 06 08 2017   grade_7 37 1 2 9   0     0   9   28 30                       58 37 1 2 9   0     0   9   28 30                 58
480119 OK MAYES   school 4007670 46-I032   CHOUTEAU-MAZIE 400767000318 505 CHOUTEAU-MAZIE MS Middle Regular School No Middle 06 08 2017   grade_7 25 0 0 18   0     0   9   29 23                       52 25 0 0 18   0     0   9   29 23                 52
481320 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059001326 525 CENTRAL MS Middle Regular School No Middle 06 08 2017   grade_7 124 12 35 1   4     0   9   103 82                       185 124 12 35 1   4     0   9   103 82                 185
481344 OK OKLAHOMA   school 4020080 55-I037   MILLWOOD 402008000981 105 MILLWOOD ES Elementary Regular School No Elementary PK 08 2017   grade_7 1 57 2 0   1     0   9   43 27                       70 1 57 2 0   1     0   9   43 27                 70
482269 OK OKMULGEE   school 4020310 56-I003   MORRIS 402031001009 505 MORRIS MS Middle Regular School No Middle 06 08 2017   grade_7 36 2 4 31   1     0   9   47 36                       83 36 2 4 31   1     0   9   47 36                 83
2308035 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000103 505 LITTLE AXE MS Middle Regular School No Middle 06 08 2019   grade_7 58 1 6 14   0     0   9   53 35                       88 58 1 6 14   0     0   9   53 35                 88
2308569 OK CREEK   school 4016500 19-I018   KIEFER 401650002371 505 RONGEY MS Middle Regular School No Middle 07 08 2019   grade_7 39 0 6 15   0     0   9   23 46                       69 39 0 6 15   0     0   9   23 46                 69
2308614 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000154 505 KELLYVILLE MS Middle Regular School No Middle 07 08 2019   grade_7 33 2 5 15   0     0   9   30 34                       64 33 2 5 15   0     0   9   30 34                 64
2311050 OK MCCURTAIN   school 4030870 48-I011   VALLIANT 403087001712 505 VALLIANT MS Middle Regular School No Middle 06 08 2019   grade_7 26 3 0 11   0     0   9   29 20                       49 26 3 0 11   0     0   9   29 20                 49
2311170 OK MCINTOSH   school 4007350 49-I019   CHECOTAH 400735001859 505 CHECOTAH MS Middle Regular School No Middle 05 08 2019   grade_7 46 2 1 34   0     0   9   50 42                       92 46 2 1 34   0     0   9   50 42                 92
2311843 OK OKLAHOMA   school 4018630 55-I003   LUTHER 401863001949 505 LUTHER MS Middle Regular School No Middle 05 08 2019   grade_7 47 4 9 7   0     0   9   41 35                       76 47 4 9 7   0     0   9   41 35                 76
2311938 OK OKLAHOMA   school 4013890 55-I007   HARRAH 401389000656 505 HARRAH MS Middle Regular School No Middle 06 08 2019   grade_7 113 1 10 27   1     0   9   88 73                       161 113 1 10 27   1     0   9   88 73                 161
2313154 OK OSAGE   school 4003010 57-C052   ANDERSON 400301000056 105 ANDERSON PUBLIC SCHOOL Elementary Regular School No Elementary PK 07 2019   grade_7 16 0 0 2   0     0   9   10 17                       27 16 0 0 2   0     0   9   10 17                 27
2313428 OK PAYNE   school 4025950 60-I003   RIPLEY 402595001377 105 RIPLEY ES Elementary Regular School No Elementary PK 08 2019   grade_7 15 0 1 11   0     0   9   19 17                       36 15 0 1 11   0     0   9   19 17                 36
2314317 OK ROGERS   school 4015480 66-I005   INOLA 401548000734 515 INOLA MS Middle Regular School No Middle 06 08 2019   grade_7 60 2 3 37   8     0   9   53 66                       119 60 2 3 37   8     0   9   53 66                 119
2314332 OK ROGERS   school 4027390 66-I006   SEQUOYAH 402739002706 510 SEQUOYAH MS Middle Regular School No Middle 06 08 2019   grade_7 45 1 5 32   0     0   9   49 43                       92 45 1 5 32   0     0   9   49 43                 92
2314509 OK SEQUOYAH   school 4017700 68-C001   LIBERTY 401770000857 105 LIBERTY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   grade_7 13 0 0 4   0     0   9   11 15                       26 13 0 0 4   0     0   9   11 15                 26
2314740 OK STEPHENS   school 4019080 69-I003   MARLOW 401908000906 505 MARLOW MS Middle Regular School No Middle 06 08 2019   grade_7 78 3 7 9   1     0   9   59 48                       107 78 3 7 9   1     0   9   59 48                 107
2316283 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318029852 505 WOODWARD MS SOUTH CAMPUS Middle Regular School No Middle 07 08 2019   grade_7 132 5 43 7   3     1   9   86 114                       200 132 5 43 7   3     1   9   86 114                 200
2348524 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2018   grade_7 16 0 2 17   0     0   9   24 20                       44 16 0 2 17   0     0   9   24 20                 44
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
2352373 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659001948 505 KINGSTON MS Middle Regular School No Middle 06 08 2018   grade_7 38 1 4 34   0     0   9   36 50                       86 38 1 4 34   0     0   9   36 50                 86
2354598 OK OKLAHOMA   school 4000786 55-Z003   OKLAHOMA CONNECTIONS ACADEMY 400078602800 971 OKLAHOMA CONNECTIONS ACAD MS Charter (Virtual) Regular School Yes Middle 06 08 2018   grade_7 74 5 12 5   1     0   9   58 48                       106 74 5 12 5   1     0   9   58 48                 106
2355023 OK PAWNEE   school 4008040 59-I006   CLEVELAND 400804000333 505 CLEVELAND MS Middle Regular School No Middle 06 08 2018   grade_7 75 1 5 19   1     0   9   53 57                       110 75 1 5 19   1     0   9   53 57                 110
2355483 OK POTTAWATOMIE   school 4021840 63-C010   NORTH ROCK CREEK 402184001090 105 NORTH ROCK CREEK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2018   grade_7 32 1 4 16   0     0   9   31 31                       62 32 1 4 16   0     0   9   31 31                 62
2356364 OK STEPHENS   school 4019080 69-I003   MARLOW 401908000906 505 MARLOW MS Middle Regular School No Middle 06 08 2018   grade_7 69 3 3 6   2     0   9   48 44                       92 69 3 3 6   2     0   9   48 44                 92
2357060 OK TULSA   school 4030240 72-I001   TULSA 403024002737 662 MCLAIN JHS Junior High Regular School No Middle 07 08 2018   grade_7 13 39 21 7   1     2   9   44 48                       92 13 39 21 7   1     2   9   44 48                 92
3025543 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074000496 610 ELK CITY MS Junior High Regular School No Middle 07 08 2020   grade_7 119 3 37 4   2     0   9   90 84                       174 119 3 37 4   2     0   9   90 84                 174
3026214 OK CARTER   school 4018090 10-I032   LONE GROVE 401809000869 505 LONE GROVE MS Middle Regular School No Middle 06 08 2020   grade_7 70 2 9 24   1     1   9   60 56                       116 70 2 9 24   1     1   9   60 56                 116
3028225 OK GRADY   school 4020100 26-I002   MINCO 402010001668 505 MINCO MS Middle Regular School No Middle 06 08 2020   grade_7 31 0 3 0   0     0   9   17 26                       43 31 0 3 0   0     0   9   17 26                 43
3029428 OK LINCOLN   school 4019680 41-I095   MEEKER 401968000939 505 MEEKER MS Middle Regular School No Middle 06 08 2020   grade_7 33 1 2 6   0     0   9   28 23                       51 33 1 2 6   0     0   9   28 23                 51
3029601 OK LOVE   school 4018990 43-I016   MARIETTA 401899000901 500 MARIETTA MS Middle Regular School No Middle 06 08 2020   grade_7 40 0 29 8   0     0   9   43 43                       86 40 0 29 8   0     0   9   43 43                 86
3029809 OK MAYES   school 4007670 46-I032   CHOUTEAU-MAZIE 400767000318 505 CHOUTEAU-MAZIE MS Middle Regular School No Middle 05 08 2020   grade_7 27 1 2 16   0     1   9   29 27                       56 27 1 2 16   0     1   9   29 27                 56
3029882 OK MCCLAIN   school 4025230 47-I015   PURCELL 402523002239 610 PURCELL JHS Junior High Regular School No Middle 06 08 2020   grade_7 60 0 28 17   0     0   9   58 56                       114 60 0 28 17   0     0   9   58 56                 114
3032688 OK POTTAWATOMIE   school 4004230 63-I003   BETHEL 400423001417 505 BETHEL MS Middle Regular School No Middle 06 08 2020   grade_7 63 0 4 14   0     0   9   43 47                       90 63 0 4 14   0     0   9   43 47                 90
3033162 OK SEMINOLE   school 4032460 67-I002   WEWOKA 403246002762 510 WEWOKA MS Middle Regular School No Middle 06 08 2020   grade_7 18 8 4 7   0     0   9   24 22                       46 18 8 4 7   0     0   9   24 22                 46
3033516 OK STEPHENS   school 4031020 69-I015   VELMA-ALMA 403102001455 505 VELMA-ALMA MS Middle Regular School No Middle 06 08 2020   grade_7 19 0 4 2   0     0   9   17 17                       34 19 0 4 2   0     0   9   17 17                 34
3033761 OK TULSA   school 4000753 72-G003   DOVE SCHOOLS OF TULSA 400075302890 930 DOVE SCIENCE ACADEMY TULSA Charter Regular School Yes Elementary PK 08 2020   grade_7 15 4 71 1   1     0   9   54 47                       101 15 4 71 1   1     0   9   54 47                 101
3325976 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002714 170 DIMENSIONS ACADEMY Elementary Regular School No Elementary KG 08 2021   grade_7 33 7 5 2   4     0   9   28 32                       60 33 7 5 2   4     0   9   28 32                 60
3326355 OK COTTON   school 4031470 17-I001   WALTERS 403147029649 505 WALTERS MS Middle Regular School No Middle 06 08 2021   grade_7 26 0 8 3   0     0   9   19 27                       46 26 0 8 3   0     0   9   19 27                 46
3326522 OK CREEK   school 4018840 19-I003   MANNFORD 401884000895 500 MANNFORD MS Middle Regular School No Middle 06 08 2021   grade_7 101 1 5 13   0     0   9   61 68                       129 101 1 5 13   0     0   9   61 68                 129
3327197 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2021   grade_7 29 2 7 5   0     0   9   33 19                       52 29 2 7 5   0     0   9   33 19                 52
3329935 OK OKLAHOMA   school 4015840 55-I009   JONES 401584000745 505 JONES MS Middle Regular School No Middle 06 08 2021   grade_7 56 0 10 8   0     0   9   36 47                       83 56 0 10 8   0     0   9   36 47                 83
3330934 OK OSAGE   school 4003010 57-C052   ANDERSON 400301000056 105 ANDERSON PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 16 0 1 4   0     0   9   15 15                       30 16 0 1 4   0     0   9   15 15                 30
3331194 OK PAYNE   school 4025950 60-I003   RIPLEY 402595001377 105 RIPLEY ES Elementary Regular School No Elementary PK 08 2021   grade_7 15 0 2 16   0     0   9   16 26                       42 15 0 2 16   0     0   9   16 26                 42
3331723 OK POTTAWATOMIE   school 4000802 63-I010   NORTH ROCK CREEK 400080202878 505 NORTH ROCK CREEK MS Middle Regular School No Middle 07 08 2021   grade_7 47 1 3 16   0     1   9   35 42                       77 47 1 3 16   0     1   9   35 42                 77
3332091 OK ROGERS   school 4027390 66-I006   SEQUOYAH 402739002706 510 SEQUOYAH MS Middle Regular School No Middle 06 08 2021   grade_7 51 0 7 24   2     0   9   46 47                       93 51 0 7 24   2     0   9   46 47                 93
3332511 OK STEPHENS   school 4031020 69-I015   VELMA-ALMA 403102001455 505 VELMA-ALMA MS Middle Regular School No Middle 06 08 2021   grade_7 32 0 3 3   0     0   9   21 26                       47 32 0 3 3   0     0   9   21 26                 47
2315737 OK TULSA   school 4015720 72-I005   JENKS 401572000740 505 JENKS MS Middle Regular School No Middle 07 08 2019   grade_7 496 82 122 45   113     2   87   458 489                       947 496 82 122 45   113     2   87   458 489                 947
3026750 OK CLEVELAND   school 4020250 14-I002   MOORE 402025000993 650 HIGHLAND EAST JHS Junior High Regular School No Middle 07 08 2020   grade_7 233 31 48 14   6     0   85   219 198                       417 233 31 48 14   6     0   85   219 198                 417
2315964 OK TULSA   school 4023280 72-I011   OWASSO 402328001236 510 OWASSO 7TH GRADE CTR Middle Regular School No Middle 07 07 2019   grade_7 405 40 73 70   26     1   84   366 333                       699 405 40 73 70   26     1   84   366 333                 699
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
3325820 OK CLEVELAND   school 4020250 14-I002   MOORE 402025000993 650 HIGHLAND EAST JHS Junior High Regular School No Middle 07 08 2021   grade_7 189 13 44 12   9     0   80   165 182                       347 189 13 44 12   9     0   80   165 182                 347
475883 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2017   grade_7 28 1 7 3   0     0   8   26 21                       47 28 1 7 3   0     0   8   26 21                 47
476423 OK CARTER   school 4033540 10-C072   ZANEIS 403354001852 105 ZANEIS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 10 0 6 3   0     0   8   14 13                       27 10 0 6 3   0     0   8   14 13                 27
477768 OK CREEK   school 4018840 19-I003   MANNFORD 401884000895 500 MANNFORD MS Middle Regular School No Middle 06 08 2017   grade_7 82 1 2 18   0     0   8   52 59                       111 82 1 2 18   0     0   8   52 59                 111
478473 OK GARVIN   school 4010860 25-I072   ELMORE CITY-PERNELL 401086002746 605 ELMORE CITY JHS Junior High Regular School No Middle 06 08 2017   grade_7 32 0 2 7   0     0   8   26 23                       49 32 0 2 7   0     0   8   26 23                 49
479880 OK LOVE   school 4029850 43-I004   THACKERVILLE 402985002833 505 THACKERVILLE MS Middle Regular School No Middle 06 08 2017   grade_7 12 0 2 2   1     0   8   17 8                       25 12 0 2 2   1     0   8   17 8                 25
479998 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659001948 505 KINGSTON MS Middle Regular School No Middle 06 08 2017   grade_7 35 0 4 45   0     0   8   45 47                       92 35 0 4 45   0     0   8   45 47                 92
482021 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002394 535 JOHN MARSHALL MS Middle Regular School No Middle 07 08 2017   grade_7 15 82 16 2   2     0   8   64 61                       125 15 82 16 2   2     0   8   64 61                 125
482295 OK OKMULGEE   school 4025050 56-I005   PRESTON 402505001314 110 PRESTON ES Elementary Regular School No Elementary PK 08 2017   grade_7 12 7 1 13   0     0   8   17 24                       41 12 7 1 13   0     0   8   17 24                 41
484689 OK TULSA   school 4030240 72-I001   TULSA 403024002733 664 WILL ROGERS COLLEGE JHS Junior High Regular School No Middle 07 08 2017   grade_7 32 35 179 9   1     0   8   124 140                       264 32 35 179 9   1     0   8   124 140                 264
485014 OK TULSA   school 4028170 72-I008   SPERRY 402817001491 505 SPERRY MS Middle Regular School No Middle 06 08 2017   grade_7 45 2 2 16   1     0   8   35 39                       74 45 2 2 16   1     0   8   35 39                 74
2307390 OK CHEROKEE   school 4005430 11-C044   BRIGGS 400543000192 105 BRIGGS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   grade_7 5 0 5 35   0     0   8   26 27                       53 5 0 5 35   0     0   8   26 27                 53
2308071 OK COAL   school 4030270 15-I002   TUPELO 403027001683 105 TUPELO ES Elementary Regular School No Elementary PK 08 2019   grade_7 6 0 1 7   1     0   8   13 10                       23 6 0 1 7   1     0   8   13 10                 23
2310070 OK KIOWA   school 4014700 38-I001   HOBART 401470000692 505 HOBART MS Middle Regular School No Middle 06 08 2019   grade_7 18 8 11 2   0     0   8   25 22                       47 18 8 11 2   0     0   8   25 22                 47
2310131 OK LATIMER   school 4032790 39-I001   WILBURTON 403279002675 510 WILBURTON MS Middle Regular School No Middle 06 08 2019   grade_7 23 1 4 13   0     0   8   18 31                       49 23 1 4 13   0     0   8   18 31                 49
2311154 OK MCINTOSH   school 4011160 49-I001   EUFAULA 401116002346 505 EUFAULA MS Middle Regular School No Middle 06 08 2019   grade_7 42 3 5 44   1     0   8   49 54                       103 42 3 5 44   1     0   8   49 54                 103
2311214 OK MURRAY   school 4029160 50-I001   SULPHUR 402916002703 510 SULPHUR MS Middle Regular School No Middle 06 08 2019   grade_7 79 2 10 24   3     0   8   64 62                       126 79 2 10 24   3     0   8   64 62                 126
2312781 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001150 518 JEFFERSON MS Middle Regular School No Middle 07 08 2019   grade_7 34 43 328 12   2     2   8   222 207                       429 34 43 328 12   2     2   8   222 207                 429
2312787 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001182 522 ROGERS MS Middle Regular School No Middle 06 08 2019   grade_7 11 61 14 3   0     0   8   59 38                       97 11 61 14 3   0     0   8   59 38                 97
2313002 OK OKMULGEE   school 4030450 56-C011   TWIN HILLS 403045001697 105 TWIN HILLS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   grade_7 17 0 0 10   0     0   8   15 20                       35 17 0 0 10   0     0   8   15 20                 35
2313056 OK OKMULGEE   school 4003810 56-I004   BEGGS 400381000120 505 BEGGS MS Middle Regular School No Middle 05 08 2019   grade_7 43 4 6 13   0     0   8   39 35                       74 43 4 6 13   0     0   8   39 35                 74
2313204 OK OSAGE   school 4003570 57-I029   BARNSDALL 400357000093 615 BARNSDALL JHS Junior High Regular School No Middle 07 08 2019   grade_7 17 0 1 0   0     0   8   13 13                       26 17 0 1 0   0     0   8   13 13                 26
2313837 OK PONTOTOC   school 4028800 62-I030   STONEWALL 402880002389 515 MCLISH MS Middle Regular School No Middle 05 08 2019   grade_7 10 0 0 11   0     0   8   21 8                       29 10 0 0 11   0     0   8   21 8                 29
2314274 OK ROGERS   school 4006870 66-I002   CATOOSA 400687000811 510 WELLS MS Middle Regular School No Middle 06 08 2019   grade_7 83 3 23 35   7     1   8   87 73                       160 83 3 23 35   7     1   8   87 73                 160
2314660 OK SEQUOYAH   school 4007140 68-I007   CENTRAL 400714000279 105 CENTRAL ES Elementary Regular School No Elementary PK 08 2019   grade_7 8 1 3 11   0     0   8   14 17                       31 8 1 3 11   0     0   8   14 17                 31
2348933 OK CARTER   school 4014130 10-I055   HEALDTON 401413001863 505 HEALDTON MS Middle Regular School No Middle 06 08 2018   grade_7 19 0 3 0   1     0   8   18 13                       31 19 0 3 0   1     0   8   18 13                 31
2351874 OK LE FLORE   school 4028200 40-I002   SPIRO 402820001494 505 SPIRO MS Middle Regular School No Middle 06 08 2018   grade_7 39 5 8 21   0     0   8   47 34                       81 39 5 8 21   0     0   8   47 34                 81
2351902 OK LE FLORE   school 4024630 40-I007   POCOLA 402463001289 505 POCOLA MS Middle Regular School No Middle 06 08 2018   grade_7 37 1 2 9   1     0   8   26 32                       58 37 1 2 9   1     0   8   26 32                 58
2352570 OK MCCLAIN   school 4025230 47-I015   PURCELL 402523002239 610 PURCELL JHS Junior High Regular School No Middle 06 08 2018   grade_7 49 0 17 8   0     0   8   43 39                       82 49 0 17 8   0     0   8   43 39                 82
2354413 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001196 525 TAFT MS Middle Regular School No Middle 06 08 2018   grade_7 44 38 121 8   9     0   8   121 107                       228 44 38 121 8   9     0   8   121 107                 228
2355900 OK ROGERS   school 4006870 66-I002   CATOOSA 400687000811 510 WELLS MS Middle Regular School No Middle 06 08 2018   grade_7 74 4 18 22   3     1   8   60 70                       130 74 4 18 22   3     1   8   60 70                 130
2355957 OK ROGERS   school 4027390 66-I006   SEQUOYAH 402739002706 510 SEQUOYAH MS Middle Regular School No Middle 06 08 2018   grade_7 42 1 1 26   1     0   8   39 40                       79 42 1 1 26   1     0   8   39 40                 79
2356133 OK SEQUOYAH   school 4017700 68-C001   LIBERTY 401770000857 105 LIBERTY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2018   grade_7 11 0 1 2   0     0   8   11 11                       22 11 0 1 2   0     0   8   11 11                 22
2357054 OK TULSA   school 4030240 72-I001   TULSA 403024002731 658 CENTRAL JHS Junior High Regular School No Middle 07 08 2018   grade_7 18 40 9 3   0     0   8   43 35                       78 18 40 9 3   0     0   8   43 35                 78
3025803 OK CADDO   school 4006630 08-I033   CARNEGIE 400663002676 510 CARNEGIE MS Middle Regular School No Middle 06 08 2020   grade_7 11 0 5 13   0     0   8   18 19                       37 11 0 5 13   0     0   8   18 19                 37
3026333 OK CHEROKEE   school 4013230 11-C034   GRAND VIEW 401323000614 105 GRAND VIEW PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 13 0 7 30   0     0   8   30 28                       58 13 0 7 30   0     0   8   30 28                 58
3028021 OK GARFIELD   school 4010920 24-I057   ENID 401092002686 510 LONGFELLOW MS Middle Regular School No Middle 06 08 2020   grade_7 37 8 84 2   1     36   8   82 94                       176 37 8 84 2   1     36   8   82 94                 176
3029200 OK LE FLORE   school 4024630 40-I007   POCOLA 402463001289 505 POCOLA MS Middle Regular School No Middle 06 08 2020   grade_7 30 1 2 9   1     0   8   26 25                       51 30 1 2 9   1     0   8   26 25                 51
3029978 OK MCCURTAIN   school 4014080 48-I006   HAWORTH 401408000664 510 HAWORTH MS Middle Regular School No Middle 06 08 2020   grade_7 22 9 3 8   0     0   8   27 23                       50 22 9 3 8   0     0   8   27 23                 50
3032050 OK OTTAWA   school 4033240 58-I001   WYANDOTTE 403324002361 505 WYANDOTTE MS Middle Regular School No Middle 06 08 2020   grade_7 37 0 1 15   1     0   8   33 29                       62 37 0 1 15   1     0   8   33 29                 62
3324617 OK BECKHAM   school 4027060 05-I031   SAYRE 402706002268 505 SAYRE MS Middle Regular School No Middle 06 08 2021   grade_7 38 0 6 0   0     0   8   30 22                       52 38 0 6 0   0     0   8   30 22                 52
3324661 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2021   grade_7 23 2 9 9   0     0   8   29 22                       51 23 2 9 9   0     0   8   29 22                 51

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