Data source: Big Local News · About: Big Local

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

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
475553 OK ADAIR   school 4009360 01-C029   DAHLONEGAH 400936000401 105 DAHLONEGAH PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 0 0 1 10   0     0   0   5 6                       11 0 0 1 10   0     0   0   5 6                 11
476695 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2017   grade_7 0 0 0 20   0     0   1   9 12                       21 0 0 0 20   0     0   1   9 12                 21
477994 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 0 0 0 6   0     0   0   5 1                       6 0 0 0 6   0     0   0   5 1                 6
478060 OK DELAWARE   school 4008250 21-I004   COLCORD 400825000345 105 COLCORD ES Elementary Regular School No Elementary PK 08 2017   grade_7 0 0 0 2   0     0   0   2 0                       2 0 0 0 2   0     0   0   2 0                 2
479480 OK LE FLORE   school 4011400 40-C039   FANSHAWE 401140000541 105 FANSHAWE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 0 0 0 2   0     0   0   0 2                       2 0 0 0 2   0     0   0   0 2                 2
480385 OK MCINTOSH   school 4026580 49-C003   RYAL 402658001392 105 RYAL PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 0 0 2 3   0     0   0   3 2                       5 0 0 2 3   0     0   0   3 2                 5
480796 OK OKFUSKEE   school 4003690 54-C029   BEARDEN 400369000114 105 BEARDEN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 0 0 0 3   0     0   4   5 2                       7 0 0 0 3   0     0   4   5 2                 7
480886 OK OKLAHOMA   school 4009150 55-C074   CRUTCHO 400915000386 105 CRUTCHO PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 0 20 1 1   0     0   0   7 15                       22 0 20 1 1   0     0   0   7 15                 22
482033 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001885 706 CLASSEN HS OF ADVANCED STUDIES High School Regular School No Other 06 12 2017   grade_7 0 0 1 0   0     0   0   0 1                       1 0 0 1 0   0     0   0   0 1                 1
482039 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001130 707 DOUGLASS HS High School Regular School No High 07 12 2017   grade_7 0 11 1 0   0     0   2   5 9                       14 0 11 1 0   0     0   2   5 9                 14
482054 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002407 726 JOHN MARSHALL HS High School Regular School No High 07 12 2017   grade_7 0 4 2 0   0     0   1   6 1                       7 0 4 2 0   0     0   1   6 1                 7
483788 OK SEQUOYAH   school 4003840 68-C050   BELFONTE 400384002750 110 BELFONTE BELL ES (ADAIR CNTY) Elementary Regular School No Elementary PK 08 2017   grade_7 0 0 0 3   0     0   0   3 0                       3 0 0 0 3   0     0   0   3 0                 3
484259 OK TULSA   school 4000772 72-G004   SANKOFA MIDDLE SCHL (CHARTER) 400077202769 974 SANKOFA MIDDLE SCHOOL Charter Regular School Yes Elementary 03 08 2017   grade_7 0 10 0 0   0     0   0   5 5                       10 0 10 0 0   0     0   0   5 5                 10
484753 OK TULSA   school 4000769 72-E006   TULSA 400076902742 976 TULSA LEGACY CHARTER SCHL INC Charter Regular School Yes Elementary PK 08 2017   grade_7 0 36 5 0   0     0   1   15 27                       42 0 36 5 0   0     0   1   15 27                 42
475563 OK ADAIR   school 4021870 01-C032   GREASY 402187001091 105 GREASY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 0 10   0     0   0   4 7                       11 1 0 0 10   0     0   0   4 7                 11
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
476135 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000606 105 GRACEMONT ES Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 0 7   0     0   1   4 5                       9 1 0 0 7   0     0   1   4 5                 9
476557 OK CHEROKEE   school 4018480 11-C010   LOWREY 401848000880 105 LOWREY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 1 7   0     0   1   4 6                       10 1 0 1 7   0     0   1   4 6                 10
477210 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002714 170 DIMENSIONS ACADEMY Elementary Regular School No Elementary KG 08 2017   grade_7 1 0 2 0   0     0   1   4 0                       4 1 0 2 0   0     0   1   4 0                 4
477233 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002118 710 NORMAN NORTH HS High School Regular School No High 07 12 2017   grade_7 1 0 0 1   0     0   0   2 0                       2 1 0 0 1   0     0   0   2 0                 2
477642 OK CRAIG   school 4032610 18-C001   WHITE OAK 403261001802 105 WHITE OAK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 0 1   0     0   1   2 1                       3 1 0 0 1   0     0   1   2 1                 3
477720 OK CREEK   school 4013600 19-C012   GYPSY 401360000643 105 GYPSY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 0 0   0     0   1   2 0                       2 1 0 0 0   0     0   1   2 0                 2
478123 OK DEWEY   school 4029430 22-I010   TALOGA 402943001549 105 TALOGA ES Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 0 1   0     0   0   0 2                       2 1 0 0 1   0     0   0   0 2                 2
478889 OK HUGHES   school 4029100 32-I054   STUART 402910001530 105 STUART ES Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 2 8   0     0   1   5 7                       12 1 0 2 8   0     0   1   5 7                 12
479470 OK LE FLORE   school 4014730 40-C014   HODGEN 401473000693 105 HODGEN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 1 1 0 16   0     0   1   10 9                       19 1 1 0 16   0     0   1   10 9                 19
479868 OK LOVE   school 4013380 43-C003   GREENVILLE 401338000622 105 GREENVILLE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 5 1   0     0   4   3 8                       11 1 0 5 1   0     0   4   3 8                 11
480707 OK NOBLE   school 4004360 52-I002   BILLINGS 400436000140 105 BILLINGS ES Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 0 0   0     0   0   0 1                       1 1 0 0 0   0     0   0   0 1                 1
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
482008 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001167 521 NORTHEAST MS Middle Regular School No Middle 06 08 2017   grade_7 1 25 3 2   0     0   3   15 19                       34 1 25 3 2   0     0   3   15 19                 34
482060 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002397 750 OKLAHOMA CENTENNIAL HS High School Regular School No High 07 12 2017   grade_7 1 3 2 1   0     0   1   3 5                       8 1 3 2 1   0     0   1   3 5                 8
482217 OK OKLAHOMA   school 4000790 55-Z005   ABLE CHARTER ABLE LEARNING 400079002811 971 ABLE CHARTER SCHOOL 6TH-8TH Charter (Virtual) Regular School Yes Middle 06 08 2017   grade_7 1 1 0 1   0     0   0   2 1                       3 1 1 0 1   0     0   0   2 1                 3
483303 OK PUSHMATAHA   school 4002580 64-C002   ALBION 400258000017 105 ALBION PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 0 2   0     0   0   2 1                       3 1 0 0 2   0     0   0   2 1                 3
483609 OK SEMINOLE   school 4015900 67-C054   JUSTICE 401590000748 105 JUSTICE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 1 7   0     0   1   5 5                       10 1 0 1 7   0     0   1   5 5                 10
483758 OK SEQUOYAH   school 4018960 68-C035   MARBLE CITY 401896000898 105 MARBLE CITY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 1 0 0 10   0     0   0   8 3                       11 1 0 0 10   0     0   0   8 3                 11
484745 OK TULSA   school 4000780 72-E005   TULSA 400078002744 975 KIPP TULSA ACAD. COLLEGE PREP. Charter Regular School Yes Middle 05 08 2017   grade_7 1 74 4 1   0     0   3   43 40                       83 1 74 4 1   0     0   3   43 40                 83
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
475763 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2017   grade_7 10 0 1 0   0     0   0   5 6                       11 10 0 1 0   0     0   0   5 6                 11
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
477364 OK COMANCHE   school 4015420 16-I002   INDIAHOMA 401542000729 105 INDIAHOMA ES Elementary Regular School No Elementary PK 08 2017   grade_7 10 0 3 7   0     0   0   10 10                       20 10 0 3 7   0     0   0   10 10                 20
478359 OK GARFIELD   school 4008790 24-I094   COVINGTON-DOUGLAS 400879000370 105 COVINGTON-DOUGLAS ES Elementary Regular School No Elementary PK 08 2017   grade_7 10 0 6 0   0     0   7   11 12                       23 10 0 6 0   0     0   7   11 12                 23
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
479408 OK LATIMER   school 4025590 39-I002   RED OAK 402559001365 105 RED OAK ES Elementary Regular School No Elementary PK 08 2017   grade_7 10 0 0 5   0     0   0   9 6                       15 10 0 0 5   0     0   0   9 6                 15
480252 OK MCCURTAIN   school 4009720 48-C037   DENISON 400972000417 105 DENISON PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 10 2 1 2   1     0   0   11 5                       16 10 2 1 2   1     0   0   11 5                 16
480820 OK OKFUSKEE   school 4023340 54-I014   PADEN 402334001237 105 PADEN ES Elementary Regular School No Elementary PK 08 2017   grade_7 10 1 1 5   0     0   0   11 6                       17 10 1 1 5   0     0   0   11 6                 17
482109 OK OKLAHOMA   school 4000771 55-E005   OKLAHOMA CITY 400077102328 975 DOVE SCIENCE ACADEMY (OKC) Charter Regular School Yes Other 06 12 2017   grade_7 10 2 69 0   3     0   0   44 40                       84 10 2 69 0   3     0   0   44 40                 84
482129 OK OKLAHOMA   school 4000766 55-E012   OKLAHOMA CITY 400076602408 982 KIPP REACH COLLEGE PREPARATORY Charter Regular School Yes Middle 05 08 2017   grade_7 10 33 15 1   2     0   3   31 33                       64 10 33 15 1   2     0   3   31 33                 64
483345 OK PUSHMATAHA   school 4007800 64-I010   CLAYTON 400780000327 105 CRAIN ES Elementary Regular School No Elementary PK 08 2017   grade_7 10 0 0 7   0     0   0   7 10                       17 10 0 0 7   0     0   0   7 10                 17
483649 OK SEMINOLE   school 4005130 67-I003   BOWLEGS 400513000179 105 BOWLEGS ES Elementary Regular School No Elementary PK 08 2017   grade_7 10 0 0 6   0     0   1   11 6                       17 10 0 0 6   0     0   1   11 6                 17
483911 OK STEPHENS   school 4013260 69-C082   GRANDVIEW 401326000615 105 GRANDVIEW PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 10 1 1 1   0     0   0   6 7                       13 10 1 1 1   0     0   0   6 7                 13
484245 OK TULSA   school 4000753 72-G003   DISCOVERY SCHOOLS OF TULSA 400075302694 971 DISCOVERY SCHOOL OF TULSA Charter Regular School Yes Other KG 09 2017   grade_7 10 12 18 0   0     0   2   22 20                       42 10 12 18 0   0     0   2   22 20                 42
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
478031 OK DELAWARE   school 4013530 21-I002   GROVE 401353000627 505 GROVE MS Middle Regular School No Middle 07 08 2017   grade_7 101 3 9 62   0     2   1   96 82                       178 101 3 9 62   0     2   1   96 82                 178
480210 OK MCCLAIN   school 4004680 47-I029   BLANCHARD 400468002240 510 BLANCHARD MS Middle Regular School No Middle 06 08 2017   grade_7 104 3 10 33   0     0   0   68 82                       150 104 3 10 33   0     0   0   68 82                 150
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
476446 OK CARTER   school 4003180 10-I019   ARDMORE 400318029636 505 ARDMORE MS Middle Regular School No Middle 06 08 2017   grade_7 109 33 45 25   2     0   7   113 108                       221 109 33 45 25   2     0   7   113 108                 221
484999 OK TULSA   school 4027750 72-I007   SKIATOOK 402775001476 505 NEWMAN MS Middle Regular School No Middle 06 08 2017   grade_7 109 2 8 71   1     0   6   99 98                       197 109 2 8 71   1     0   6   99 98                 197
475852 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 4 0   1     0   2   8 10                       18 11 0 4 0   1     0   2   8 10                 18
476062 OK CADDO   school 4018390 08-I012   LOOKEBA SICKLES 401839000876 105 LOOKEBA-SICKLES ES Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 2 1   0     0   3   9 8                       17 11 0 2 1   0     0   3   9 8                 17
476236 OK CANADIAN   school 4018900 09-C162   MAPLE 401890000897 105 MAPLE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 0 0   0     0   3   5 9                       14 11 0 0 0   0     0   3   5 9                 14
476577 OK CHEROKEE   school 4033090 11-C021   WOODALL 403309001819 105 WOODALL PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 0 27   0     0   6   21 23                       44 11 0 0 27   0     0   6   21 23                 44
477582 OK COMANCHE   school 4007320 16-I132   CHATTANOOGA 400732000286 105 CHATTANOOGA ES Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 1 2   0     0   1   9 6                       15 11 0 1 2   0     0   1   9 6                 15
479350 OK KIOWA   school 4018270 38-I002   LONE WOLF 401827000873 105 LONE WOLF ES Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 1 0   0     0   0   5 7                       12 11 0 1 0   0     0   0   5 7                 12
479546 OK LE FLORE   school 4006330 40-I017   CAMERON 400633000246 105 CAMERON ES Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 5 5   0     0   1   10 12                       22 11 0 5 5   0     0   1   10 12                 22
480850 OK OKFUSKEE   school 4032220 54-I031   WELEETKA 403222001180 610 WELEETKA JHS Junior High Regular School No Other 07 09 2017   grade_7 11 0 1 5   0     0   3   13 7                       20 11 0 1 5   0     0   3   13 7                 20
482229 OK OKMULGEE   school 4030450 56-C011   TWIN HILLS 403045001697 105 TWIN HILLS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 11 1 4 11   0     0   3   15 15                       30 11 1 4 11   0     0   3   15 15                 30
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
482606 OK PAWNEE   school 4015750 59-C002   JENNINGS 401575000741 105 JENNINGS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 1 7   0     0   0   10 9                       19 11 0 1 7   0     0   0   10 9                 19
482876 OK PITTSBURG   school 4016650 61-I014   KIOWA 401665000777 105 KIOWA ES Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 0 11   0     0   0   12 10                       22 11 0 0 11   0     0   0   12 10                 22
483180 OK POTTAWATOMIE   school 4018660 63-I004   MACOMB 401866000884 110 MACOMB ES Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 1 1   0     0   3   9 7                       16 11 0 1 1   0     0   3   9 7                 16
483429 OK ROGER MILLS   school 4029310 65-I015   SWEETWATER 402931001538 105 SWEETWATER ES Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 2 0   0     0   1   7 7                       14 11 0 2 0   0     0   1   7 7                 14
484129 OK TEXAS   school 4030480 70-I053   TYRONE 403048001698 105 TYRONE ES Elementary Regular School No Elementary PK 08 2017   grade_7 11 0 9 1   1     0   0   13 9                       22 11 0 9 1   1     0   0   13 9                 22
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
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
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
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
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
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
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
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
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
475749 OK BEAVER   school 4003750 04-I022   BEAVER 400375000115 105 BEAVER ES Elementary Regular School No Elementary PK 08 2017   grade_7 12 0 8 1   1     0   1   12 11                       23 12 0 8 1   1     0   1   12 11                 23
476093 OK CADDO   school 4006630 08-I033   CARNEGIE 400663002676 510 CARNEGIE MS Middle Regular School No Middle 07 08 2017   grade_7 12 1 4 13   1     0   4   22 13                       35 12 1 4 13   1     0   4   22 13                 35
477668 OK CRAIG   school 4032190 18-I017   WELCH 403219001782 515 WELCH MS Middle Regular School No Middle 06 08 2017   grade_7 12 0 1 5   0     0   0   7 11                       18 12 0 1 5   0     0   0   7 11                 18
478373 OK GARVIN   school 4032670 25-C016   WHITEBEAD 403267001805 105 WHITEBEAD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 12 1 6 2   1     0   3   14 11                       25 12 1 6 2   1     0   3   14 11                 25
479504 OK LE FLORE   school 4014160 40-I003   HEAVENER 401416000670 105 HEAVENER ES Elementary Regular School No Elementary PK 08 2017   grade_7 12 0 25 27   0     0   0   33 31                       64 12 0 25 27   0     0   0   33 31                 64
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
479892 OK LOVE   school 4030300 43-I005   TURNER 403030001686 105 TURNER ES Elementary Regular School No Elementary PK 08 2017   grade_7 12 1 2 4   0     0   0   5 14                       19 12 1 2 4   0     0   0   5 14                 19
480573 OK MUSKOGEE   school 4020970 51-I020   MUSKOGEE 402097001035 120 BENJAMIN FRANKLIN SCI. ACADEMY Elementary Regular School No Elementary PK 08 2017   grade_7 12 19 2 6   0     0   12   24 27                       51 12 19 2 6   0     0   12   24 27                 51
480678 OK MUSKOGEE   school 4024840 51-I088   PORUM 402484001306 105 PORUM ES Elementary Regular School No Elementary PK 08 2017   grade_7 12 0 0 20   0     0   1   17 16                       33 12 0 0 20   0     0   1   17 16                 33
480721 OK NOBLE   school 4000020 52-I004   FRONTIER 400002025620 105 FRONTIER ES Elementary Regular School No Elementary PK 08 2017   grade_7 12 0 2 16   1     0   0   17 14                       31 12 0 2 16   1     0   0   17 14                 31
480806 OK OKFUSKEE   school 4019260 54-I002   MASON 401926000909 105 MASON ES Elementary Regular School No Elementary PK 08 2017   grade_7 12 1 0 7   0     0   7   12 15                       27 12 1 0 7   0     0   7   12 15                 27
482023 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002405 540 OKLAHOMA CENTENNIAL MS Middle Regular School No Middle 07 08 2017   grade_7 12 66 29 1   1     1   5   62 53                       115 12 66 29 1   1     1   5   62 53                 115
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
482339 OK OKMULGEE   school 4009780 56-I008   DEWAR 400978002785 515 DEWAR MS Middle Regular School No Middle 06 08 2017   grade_7 12 2 0 20   0     0   0   17 17                       34 12 2 0 20   0     0   0   17 17                 34
485231 OK WAGONER   school 4022620 73-I001   OKAY 402262001106 105 OKAY ES Elementary Regular School No Elementary PK 08 2017   grade_7 12 0 1 17   0     0   0   13 17                       30 12 0 1 17   0     0   0   13 17                 30
485301 OK WASHINGTON   school 4008610 74-I004   COPAN 400861000362 105 COPAN ES Elementary Regular School No Elementary PK 08 2017   grade_7 12 0 0 4   0     0   2   9 9                       18 12 0 0 4   0     0   2   9 9                 18
485474 OK WOODS   school 4032040 76-I003   WAYNOKA 403204001771 105 WAYNOKA ES Elementary Regular School No Elementary PK 08 2017   grade_7 12 0 2 0   0     0   0   7 7                       14 12 0 2 0   0     0   0   7 7                 14
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
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
485515 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318029852 505 WOODWARD MS Middle Regular School No Middle 06 08 2017   grade_7 123 5 50 14   1     1   0   88 106                       194 123 5 50 14   1     1   0   88 106                 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]);