Data source: Big Local News · About: Big Local

2,956 rows where grade = "grade_7" and state = "OK" sorted by native_american 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
3325477 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2021   grade_7 38 3 48 98   2     0   47   101 135                       236 38 3 48 98   2     0   47   101 135                 236
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
2307453 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2019   grade_7 57 0 44 90   0     0   34   109 116                       225 57 0 44 90   0     0   34   109 116                 225
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
475617 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2017   grade_7 1 0 0 9   0     0   0   7 3                       10 1 0 0 9   0     0   0   7 3                 10
475683 OK ATOKA   school 4017040 03-C022   LANE 401704000790 105 LANE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 10 0 2 9   1     0   4   15 11                       26 10 0 2 9   1     0   4   15 11                 26
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
475994 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000123 105 BENNINGTON ES Elementary Regular School No Elementary PK 08 2017   grade_7 17 0 1 9   0     0   1   11 17                       28 17 0 1 9   0     0   1   11 17                 28
476743 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001484 105 SOPER ES Elementary Regular School No Elementary PK 08 2017   grade_7 14 0 0 9   0     0   1   11 13                       24 14 0 0 9   0     0   1   11 13                 24
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
477730 OK CREEK   school 4025080 19-C034   PRETTY WATER 402508001316 105 PRETTY WATER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 18 0 1 9   1     0   2   18 13                       31 18 0 1 9   1     0   2   18 13                 31
477984 OK DELAWARE   school 4017310 21-C014   LEACH 401731000843 105 LEACH PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 4 0 1 9   1     0   0   8 7                       15 4 0 1 9   1     0   0   8 7                 15
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
479706 OK LINCOLN   school 4009450 41-I003   DAVENPORT 400945000405 105 DAVENPORT ES Elementary Regular School No Elementary PK 08 2017   grade_7 20 1 1 9   0     0   1   20 12                       32 20 1 1 9   0     0   1   20 12                 32
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
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
479795 OK LINCOLN   school 4002550 41-I134   AGRA 400255000015 105 AGRA ES Elementary Regular School No Elementary PK 08 2017   grade_7 22 0 2 9   0     0   0   15 18                       33 22 0 2 9   0     0   0   15 18                 33
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
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
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
483079 OK PONTOTOC   school 4026280 62-I037   ROFF 402628001382 105 ROFF ES Elementary Regular School No Elementary PK 08 2017   grade_7 14 0 0 9   0     0   0   12 11                       23 14 0 0 9   0     0   0   12 11                 23
483719 OK SEMINOLE   school 4029040 67-I014   STROTHER 402904001523 105 STROTHER ES Elementary Regular School No Elementary PK 08 2017   grade_7 19 0 0 9   0     2   1   17 14                       31 19 0 0 9   0     2   1   17 14                 31
483778 OK SEQUOYAH   school 4003840 68-C050   BELFONTE 400384000121 105 BELFONTE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 2 0 0 9   1     0   0   4 8                       12 2 0 0 9   1     0   0   4 8                 12
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
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
2306505 OK ATOKA   school 4006420 03-I026   CANEY 400642000250 105 CANEY ES Elementary Regular School No Elementary PK 08 2019   grade_7 3 1 0 9   0     0   2   8 7                       15 3 1 0 9   0     0   2   8 7                 15
2306664 OK BLAINE   school 4012570 06-I080   GEARY 401257000588 500 GEARY MS Middle Regular School No Middle 06 08 2019   grade_7 8 0 8 9   0     0   1   10 16                       26 8 0 8 9   0     0   1   10 16                 26
2307273 OK CARTER   school 4032940 10-I043   WILSON 403294001815 105 WILSON ES Elementary Regular School No Elementary PK 08 2019   grade_7 17 0 0 9   0     0   0   13 13                       26 17 0 0 9   0     0   0   13 13                 26
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
2307515 OK CHOCTAW   school 4027960 12-I004   SOPER 402796001484 105 SOPER ES Elementary Regular School No Elementary PK 08 2019   grade_7 11 0 0 9   1     0   0   9 12                       21 11 0 0 9   1     0   0   9 12                 21
2307812 OK CLEVELAND   school 4020250 14-I002   MOORE 402025001606 685 CENTRAL JHS Junior High Regular School No Middle 07 08 2019   grade_7 149 28 54 9   1     1   77   158 161                       319 149 28 54 9   1     1   77   158 161                 319
2308021 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758002678 510 LEXINGTON MS Middle Regular School No Middle 06 08 2019   grade_7 60 0 4 9   0     0   10   42 41                       83 60 0 4 9   0     0   10   42 41                 83
2309208 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2019   grade_7 37 6 2 9   0     1   1   22 34                       56 37 6 2 9   0     1   1   22 34                 56
2309756 OK JEFFERSON   school 4025860 34-I014   RINGLING 402586001374 610 RINGLING JHS Junior High Regular School No Middle 07 09 2019   grade_7 11 0 2 9   0     0   0   11 11                       22 11 0 2 9   0     0   0   11 11                 22
2310497 OK LINCOLN   school 4024930 41-I103   PRAGUE 402493001312 505 PRAGUE MS Middle Regular School No Middle 06 08 2019   grade_7 64 2 5 9   1     0   17   54 44                       98 64 2 5 9   1     0   17   54 44                 98
2311104 OK MCCURTAIN   school 4003660 48-I071   BATTIEST 400366000112 105 BATTIEST ES Elementary Regular School No Elementary PK 08 2019   grade_7 12 0 0 9   0     0   0   9 12                       21 12 0 0 9   0     0   0   9 12                 21
2311253 OK MUSKOGEE   school 4013950 51-I002   HASKELL 401395000572 505 HASKELL MS Middle Regular School No Middle 06 08 2019   grade_7 30 5 3 9   1     0   1   25 24                       49 30 5 3 9   1     0   1   25 24                 49
2311441 OK NOBLE   school 4023850 52-I001   PERRY 402385002701 605 PERRY JHS Junior High Regular School No Middle 07 08 2019   grade_7 65 0 4 9   0     0   0   43 35                       78 65 0 4 9   0     0   0   43 35                 78
2312797 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001202 530 WEBSTER MS Middle Regular School No Middle 07 08 2019   grade_7 58 59 317 9   3     0   28   252 222                       474 58 59 317 9   3     0   28   252 222                 474
2313352 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2019   grade_7 29 0 0 9   0     0   0   14 24                       38 29 0 0 9   0     0   0   14 24                 38
2313555 OK PITTSBURG   school 4016720 61-C009   KREBS 401672000782 105 KREBS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   grade_7 18 0 3 9   1     0   6   19 18                       37 18 0 3 9   1     0   6   19 18                 37
2313565 OK PITTSBURG   school 4012240 61-C029   FRINK-CHAMBERS 401224000576 105 FRINK-CHAMBERS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2019   grade_7 18 0 0 9   1     0   1   12 17                       29 18 0 0 9   1     0   1   12 17                 29
2313633 OK PITTSBURG   school 4013620 61-I011   HAILEYVILLE 401362000644 105 HAILEYVILLE ES Elementary Regular School No Elementary PK 08 2019   grade_7 8 1 0 9   0     0   0   5 13                       18 8 1 0 9   0     0   0   5 13                 18
2313967 OK POTTAWATOMIE   school 4000802 63-I010   NORTH ROCK CREEK 400080202878 505 NORTH ROCK CREEK MS Middle Regular School No Middle 06 08 2019   grade_7 36 1 7 9   0     0   5   28 30                       58 36 1 7 9   0     0   5   28 30                 58
2314427 OK SEMINOLE   school 4016710 67-I004   KONAWA 401671002360 510 KONAWA MS Middle Regular School No Middle 06 08 2019   grade_7 17 3 3 9   0     0   2   14 20                       34 17 3 3 9   0     0   2   14 20                 34
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
2316061 OK WAGONER   school 4030197 73-I365   PORTER CONSOLIDATED 403019701304 105 PORTER CONSOLIDATED ES Elementary Regular School No Elementary PK 08 2019   grade_7 24 1 0 9   0     0   1   20 15                       35 24 1 0 9   0     0   1   20 15                 35
2348042 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2018   grade_7 2 0 1 9   0     0   0   6 6                       12 2 0 1 9   0     0   0   6 6                 12
2348146 OK ATOKA   school 4030360 03-I019   TUSHKA 403036001690 105 TUSHKA ES Elementary Regular School No Elementary PK 08 2018   grade_7 17 0 0 9   0     0   0   11 15                       26 17 0 0 9   0     0   0   11 15                 26
2348862 OK CARTER   school 4003180 10-I019   ARDMORE 400318029636 505 ARDMORE MS Middle Regular School No Middle 06 08 2018   grade_7 86 25 34 9   3     0   13   82 88                       170 86 25 34 9   3     0   13   82 88                 170
2348974 OK CHEROKEE   school 4018480 11-C010   LOWREY 401848000880 105 LOWREY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2018   grade_7 4 0 1 9   0     0   0   7 7                       14 4 0 1 9   0     0   0   7 7                 14
2350393 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2018   grade_7 0 0 0 9   0     0   0   4 5                       9 0 0 0 9   0     0   0   4 5                 9
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
2351777 OK LATIMER   school 4032790 39-I001   WILBURTON 403279002675 510 WILBURTON MS Middle Regular School No Middle 06 08 2018   grade_7 27 0 6 9   1     0   6   20 29                       49 27 0 6 9   1     0   6   20 29                 49
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
2352016 OK LE FLORE   school 4032730 40-I062   WHITESBORO 403273001807 105 WHITESBORO ES Elementary Regular School No Elementary PK 08 2018   grade_7 4 0 0 9   0     0   1   3 11                       14 4 0 0 9   0     0   1   3 11                 14
2352175 OK LINCOLN   school 4002550 41-I134   AGRA 400255002852 605 AGRA JHS Junior High Regular School No Middle 07 08 2018   grade_7 5 0 1 9   0     0   0   9 6                       15 5 0 1 9   0     0   0   9 6                 15
2352677 OK MCCURTAIN   school 4030870 48-I011   VALLIANT 403087001712 505 VALLIANT MS Middle Regular School No Middle 06 08 2018   grade_7 25 4 1 9   1     0   11   24 27                       51 25 4 1 9   1     0   11   24 27                 51
2352689 OK MCCURTAIN   school 4010440 48-I013   EAGLETOWN 401044000464 105 EAGLETOWN ES Elementary Regular School No Elementary PK 08 2018   grade_7 4 1 1 9   0     0   0   11 4                       15 4 1 1 9   0     0   0   11 4                 15
2352731 OK MCCURTAIN   school 4003660 48-I071   BATTIEST 400366000112 105 BATTIEST ES Elementary Regular School No Elementary PK 08 2018   grade_7 5 0 0 9   0     0   0   8 6                       14 5 0 0 9   0     0   0   8 6                 14
2353070 OK NOBLE   school 4023850 52-I001   PERRY 402385002701 605 PERRY JHS Junior High Regular School No Middle 07 08 2018   grade_7 48 2 7 9   0     0   0   32 34                       66 48 2 7 9   0     0   0   32 34                 66
2353894 OK OKLAHOMA   school 4019950 55-I052   MIDWEST CITY-DEL CITY 401995002671 520 KERR MS Middle Regular School No Middle 06 08 2018   grade_7 46 66 27 9   6     0   23   82 95                       177 46 66 27 9   6     0   23   82 95                 177
2354670 OK OKMULGEE   school 4003810 56-I004   BEGGS 400381000120 505 BEGGS MS Middle Regular School No Middle 05 08 2018   grade_7 39 6 5 9   0     0   14   33 40                       73 39 6 5 9   0     0   14   33 40                 73
2355159 OK PAYNE   school 4033360 60-I103   YALE 403336001839 505 YALE MS Middle Regular School No Middle 06 08 2018   grade_7 17 0 0 9   0     0   1   16 11                       27 17 0 0 9   0     0   1   16 11                 27
2355267 OK PITTSBURG   school 4016650 61-I014   KIOWA 401665000777 105 KIOWA ES Elementary Regular School No Elementary PK 08 2018   grade_7 10 1 1 9   0     0   0   11 10                       21 10 1 1 9   0     0   0   11 10                 21
2356239 OK SEQUOYAH   school 4012390 68-I004   GANS 401239000581 105 GANS ES Elementary Regular School No Elementary PK 08 2018   grade_7 14 0 2 9   0     0   0   12 13                       25 14 0 2 9   0     0   0   12 13                 25
2356255 OK SEQUOYAH   school 4026310 68-I005   ROLAND 402631001386 610 ROLAND JHS Junior High Regular School No Middle 07 09 2018   grade_7 37 3 4 9   0     0   13   38 28                       66 37 3 4 9   0     0   13   38 28                 66
2356336 OK STEPHENS   school 4010290 69-I001   DUNCAN 401029000921 505 DUNCAN MS Middle Regular School No Middle 06 08 2018   grade_7 153 14 25 9   2     1   14   112 106                       218 153 14 25 9   2     1   14   112 106                 218
3025338 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2020   grade_7 2 0 0 9   0     0   0   4 7                       11 2 0 0 9   0     0   0   4 7                 11
3025404 OK ATOKA   school 4017040 03-C022   LANE 401704000790 105 LANE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 7 0 1 9   0     0   5   12 10                       22 7 0 1 9   0     0   5   12 10                 22
3026292 OK CHEROKEE   school 4021900 11-C014   NORWOOD 402190001092 105 NORWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 6 0 1 9   0     0   5   11 10                       21 6 0 1 9   0     0   5   11 10                 21
3026302 OK CHEROKEE   school 4033090 11-C021   WOODALL 403309001819 105 WOODALL PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 6 0 9 9   0     0   7   13 18                       31 6 0 9 9   0     0   7   13 18                 31
3026433 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504002369 515 BOSWELL MS Middle Regular School No Middle 07 08 2020   grade_7 7 0 3 9   0     0   2   12 9                       21 7 0 3 9   0     0   2   12 9                 21
3026921 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002117 501 ALCOTT MS Middle Regular School No Middle 06 08 2020   grade_7 121 20 53 9   2     0   39   127 117                       244 121 20 53 9   2     0   39   127 117                 244
3028281 OK GRADY   school 4005400 26-I095   BRIDGE CREEK 400540001674 505 BRIDGE CREEK MS Middle Regular School No Middle 06 08 2020   grade_7 113 0 13 9   0     0   7   77 65                       142 113 0 13 9   0     0   7   77 65                 142
3028759 OK JOHNSTON   school 4030060 35-I020   TISHOMINGO 403006001574 505 TISHOMINGO MS Middle Regular School No Middle 05 08 2020   grade_7 39 3 3 9   1     0   20   38 37                       75 39 3 3 9   1     0   20   38 37                 75
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
3029283 OK LE FLORE   school 4032970 40-I049   WISTER 403297001817 105 WISTER ES Elementary Regular School No Elementary PK 08 2020   grade_7 23 0 0 9   0     0   6   21 17                       38 23 0 0 9   0     0   6   21 17                 38
3030394 OK NOBLE   school 4023850 52-I001   PERRY 402385002701 605 PERRY JHS Junior High Regular School No Middle 07 08 2020   grade_7 71 2 5 9   1     0   1   50 39                       89 71 2 5 9   1     0   1   50 39                 89
3031053 OK OKLAHOMA   school 4010590 55-I012   EDMOND 401059001326 525 CENTRAL MS Middle Regular School No Middle 06 08 2020   grade_7 213 11 29 9   7     1   25   150 145                       295 213 11 29 9   7     1   25   150 145                 295
3031112 OK OKLAHOMA   school 4032370 55-I041   WESTERN HEIGHTS 403237002244 515 WESTERN HEIGHTS MS Middle Regular School No Middle 07 08 2020   grade_7 50 45 122 9   1     1   27   137 118                       255 50 45 122 9   1     1   27   137 118                 255
3031229 OK OKLAHOMA   school 4019950 55-I052   MIDWEST CITY-DEL CITY 401995002661 510 DEL CREST MS Middle Regular School No Middle 06 08 2020   grade_7 59 67 28 9   1     0   18   98 84                       182 59 67 28 9   1     0   18   98 84                 182
3031523 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001183 523 ROOSEVELT MS Middle Regular School No Middle 05 08 2020   grade_7 10 14 178 9   0     1   10   117 105                       222 10 14 178 9   0     1   10   117 105                 222
3031771 OK OKMULGEE   school 4030450 56-C011   TWIN HILLS 403045001697 105 TWIN HILLS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 12 0 1 9   0     0   3   17 8                       25 12 0 1 9   0     0   3   17 8                 25
3032863 OK PUSHMATAHA   school 4025500 64-I001   RATTAN 402550001363 610 RATTAN JHS Junior High Regular School No Middle 07 08 2020   grade_7 21 0 1 9   0     0   2   16 17                       33 21 0 1 9   0     0   2   16 17                 33
3033474 OK STEPHENS   school 4010290 69-I001   DUNCAN 401029000921 505 DUNCAN MS Middle Regular School No Middle 06 08 2020   grade_7 143 11 34 9   1     0   27   112 113                       225 143 11 34 9   1     0   27   112 113                 225
3034180 OK TULSA   school 4030240 72-I001   TULSA 403024001614 659 EAST CENTRAL JHS Junior High Regular School No Middle 07 08 2020   grade_7 36 79 228 9   17     2   36   225 182                       407 36 79 228 9   17     2   36   225 182                 407
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
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
3324950 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360201597 505 FORT COBB-BROXTON MS Middle Regular School No Middle 06 08 2021   grade_7 7 1 0 9   0     0   4   9 12                       21 7 1 0 9   0     0   4   9 12                 21
3325818 OK CLEVELAND   school 4020250 14-I002   MOORE 402025002214 610 BRINK JHS Junior High Regular School No Middle 07 08 2021   grade_7 151 12 41 9   44     0   68   165 160                       325 151 12 41 9   44     0   68   165 160                 325
3326463 OK CREEK   school 4018240 19-C008   LONE STAR 401824000872 105 LONE STAR PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 59 0 7 9   0     0   11   41 45                       86 59 0 7 9   0     0   11   41 45                 86
3326565 OK CREEK   school 4016500 19-I018   KIEFER 401650002371 505 RONGEY MS Middle Regular School No Middle 07 08 2021   grade_7 39 0 5 9   0     0   10   35 28                       63 39 0 5 9   0     0   10   35 28                 63
3327580 OK HUGHES   school 4032430 32-I005   WETUMKA 403243001796 105 WETUMKA ES Elementary Regular School No Elementary PK 08 2021   grade_7 6 1 2 9   0     0   3   13 8                       21 6 1 2 9   0     0   3   13 8                 21
3328185 OK LE FLORE   school 4014730 40-C014   HODGEN 401473000693 105 HODGEN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 1 0 1 9   0     0   3   4 10                       14 1 0 1 9   0     0   3   4 10                 14
3328219 OK LE FLORE   school 4014160 40-I003   HEAVENER 401416000670 105 HEAVENER ES Elementary Regular School No Elementary PK 08 2021   grade_7 18 0 38 9   0     0   0   25 40                       65 18 0 38 9   0     0   0   25 40                 65
3328235 OK LE FLORE   school 4024630 40-I007   POCOLA 402463001289 505 POCOLA MS Middle Regular School No Middle 06 08 2021   grade_7 46 0 1 9   0     0   11   36 31                       67 46 0 1 9   0     0   11   36 31                 67
3328708 OK MARSHALL   school 4018700 45-I002   MADILL 401870000888 505 MADILL MS Middle Regular School No Middle 06 08 2021   grade_7 35 3 54 9   1     0   13   65 50                       115 35 3 54 9   1     0   13   65 50                 115
3329253 OK MUSKOGEE   school 4013950 51-I002   HASKELL 401395000572 505 HASKELL MS Middle Regular School No Middle 06 08 2021   grade_7 30 6 8 9   0     0   0   29 24                       53 30 6 8 9   0     0   0   29 24                 53
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

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