Data source: Big Local News · About: Big Local

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

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
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
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
475951 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2017   grade_7 20 1 2 6   0     0   1   19 11                       30 20 1 2 6   0     0   1   19 11                 30
483039 OK PONTOTOC   school 4002430 62-I019   ADA 400243000725 610 ADA JHS Junior High Regular School No Other 07 09 2017   grade_7 80 10 27 60   4     0   13   94 100                       194 80 10 27 60   4     0   13   94 100                 194
480063 OK MAYES   school 4002460 46-I002   ADAIR 400246000010 505 ADAIR MS Middle Regular School No Middle 06 08 2017   grade_7 31 0 1 38   0     0   1   38 33                       71 31 0 1 38   0     0   1   38 33                 71
482578 OK OTTAWA   school 4002520 58-I026   AFTON 400252000013 105 AFTON ES Elementary Regular School No Elementary PK 08 2017   grade_7 15 0 1 13   0     0   0   14 15                       29 15 0 1 13   0     0   0   14 15                 29
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
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
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
478562 OK GRADY   school 4002670 26-I056   ALEX 400267000019 105 ALEX ES Elementary Regular School No Elementary PK 08 2017   grade_7 22 0 0 6   0     0   1   16 13                       29 22 0 0 6   0     0   1   16 13                 29
480622 OK MUSKOGEE   school 4020970 51-I020   MUSKOGEE 402097000599 505 ALICE ROBERTSON JHS Middle Regular School No Middle 07 08 2017   grade_7 86 67 55 63   3     0   62   189 147                       336 86 67 55 63   3     0   62   189 147                 336
479935 OK MAJOR   school 4002720 44-I004   ALINE-CLEO 400272000022 105 ALINE-CLEO ES Elementary Regular School No Elementary PK 08 2017   grade_7 5 0 1 0   0     0   2   6 2                       8 5 0 1 0   0     0   2   6 2                 8
482985 OK PONTOTOC   school 4002760 62-I001   ALLEN 400276000024 105 ALLEN ES Elementary Regular School No Elementary PK 08 2017   grade_7 15 2 2 7   0     1   0   14 13                       27 15 2 2 7   0     1   0   14 13                 27
477740 OK CREEK   school 4002790 19-C035   ALLEN-BOWDEN 400279000027 105 ALLEN-BOWDEN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 14 1 8 8   0     0   1   17 15                       32 14 1 8 8   0     0   1   17 15                 32
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
485462 OK WOODS   school 4002880 76-I001   ALVA 400288000041 505 ALVA MS Middle Regular School No Middle 06 08 2017   grade_7 49 2 8 3   0     0   5   35 32                       67 49 2 8 3   0     0   5   35 32                 67
478635 OK GRADY   school 4002910 26-I128   AMBER-POCASSET 400291000047 615 AMBER-POCASSET JHS Junior High Regular School No Other 07 09 2017   grade_7 29 1 1 1   0     0   5   22 15                       37 29 1 1 1   0     0   5   22 15                 37
476079 OK CADDO   school 4003000 08-I020   ANADARKO 400300002101 510 ANADARKO MS Middle Regular School No Middle 06 08 2017   grade_7 24 4 24 53   0     0   0   56 49                       105 24 4 24 53   0     0   0   56 49                 105
476108 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2017   grade_7 15 0 6 19   0     0   4   21 23                       44 15 0 6 19   0     0   4   21 23                 44
477916 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312000063 105 ARAPAHO-BUTLER ES Elementary Regular School No Elementary PK 08 2017   grade_7 28 0 5 2   0     0   0   19 16                       35 28 0 5 2   0     0   0   19 16                 35
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
479669 OK LE FLORE   school 4003210 40-I091   ARKOMA 400321002798 605 ARKOMA JHS Junior High Regular School No Middle 07 08 2017   grade_7 18 1 1 0   0     0   7   16 11                       27 18 1 1 0   0     0   7   16 11                 27
478151 OK ELLIS   school 4003240 23-I003   ARNETT 400324000077 105 ARNETT ES Elementary Regular School No Elementary PK 08 2017   grade_7 14 0 2 0   0     0   0   8 8                       16 14 0 2 0   0     0   0   8 8                 16
483261 OK POTTAWATOMIE   school 4003300 63-I112   ASHER 400330000082 105 ASHER ES Elementary Regular School No Elementary PK 08 2017   grade_7 16 1 0 4   0     0   0   6 15                       21 16 1 0 4   0     0   0   6 15                 21
480892 OK OKLAHOMA   school 4000783 55-G004   ASTEC CHARTERS 400078302308 971 ASTEC CHARTER MS Charter Regular School Yes Middle 06 08 2017   grade_7 7 6 148 2   4     0   0   86 81                       167 7 6 148 2   4     0   0   86 81                 167
475707 OK ATOKA   school 4003360 03-I015   ATOKA 400336002110 120 ATOKA ES Elementary Regular School No Elementary PK 08 2017   grade_7 35 6 4 11   2     0   12   36 34                       70 35 6 4 11   2     0   12   36 34                 70
482371 OK OSAGE   school 4003450 57-C035   AVANT 400345000088 105 AVANT PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 0 3   0     0   1   3 4                       7 3 0 0 3   0     0   1   3 4                 7
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
476216 OK CANADIAN   school 4003540 09-C031   BANNER 400354000091 105 BANNER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 16 0 1 1   1     0   1   7 13                       20 16 0 1 1   1     0   1   7 13                 20
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
480356 OK MCCURTAIN   school 4003660 48-I071   BATTIEST 400366000112 105 BATTIEST ES Elementary Regular School No Elementary PK 08 2017   grade_7 6 0 0 13   0     0   0   11 8                       19 6 0 0 13   0     0   0   11 8                 19
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
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
482283 OK OKMULGEE   school 4003810 56-I004   BEGGS 400381000120 505 BEGGS MS Middle Regular School No Middle 05 08 2017   grade_7 53 7 3 11   0     1   15   45 45                       90 53 7 3 11   0     1   15   45 45                 90
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
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
481994 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002275 503 BELLE ISLE MS Middle Regular School No Middle 06 08 2017   grade_7 72 22 27 3   17     0   11   73 79                       152 72 22 27 3   17     0   11   73 79                 152
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
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
485127 OK TULSA   school 4004020 72-I010   BERRYHILL 400402000128 510 BERRYHILL MS Middle Regular School No Middle 07 08 2017   grade_7 44 0 7 8   0     0   26   48 37                       85 44 0 7 8   0     0   26   48 37                 85
481551 OK OKLAHOMA   school 4004110 55-I088   BETHANY 400411029723 505 BETHANY MS Middle Regular School No Middle 06 08 2017   grade_7 85 4 17 3   2     0   15   66 60                       126 85 4 17 3   2     0   15   66 60                 126
483168 OK POTTAWATOMIE   school 4004230 63-I003   BETHEL 400423001417 505 BETHEL MS Middle Regular School No Middle 06 08 2017   grade_7 73 1 4 12   1     0   1   43 49                       92 73 1 4 12   1     0   1   43 49                 92
477627 OK COTTON   school 4004350 17-I333   BIG PASTURE 400435000138 105 BIG PASTURE ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 3 2   0     0   1   5 9                       14 8 0 3 2   0     0   1   5 9                 14
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
476191 OK CADDO   school 4033603 08-I168   BINGER-ONEY 403360329845 105 BINGER-ONEY ES Elementary Regular School No Elementary PK 08 2017   grade_7 21 1 0 7   0     0   3   15 17                       32 21 1 0 7   0     0   3   15 17                 32
484941 OK TULSA   school 4004500 72-I004   BIXBY 400450002097 505 BIXBY MS Middle Regular School No Middle 07 08 2017   grade_7 316 7 46 38   5     0   50   236 226                       462 316 7 46 38   5     0   50   236 226                 462
479157 OK KAY   school 4004630 36-I045   BLACKWELL 400463000152 505 BLACKWELL MS Middle Regular School No Middle 06 08 2017   grade_7 53 0 10 19   0     1   0   48 35                       83 53 0 10 19   0     1   0   48 35                 83
478980 OK JACKSON   school 4004650 33-I054   BLAIR 400465000157 105 BLAIR ES Elementary Regular School No Elementary PK 08 2017   grade_7 13 0 8 1   0     0   0   12 10                       22 13 0 8 1   0     0   0   12 10                 22
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
477683 OK CRAIG   school 4004830 18-I020   BLUEJACKET 400483002082 505 BLUEJACKET MS Middle Regular School No Middle 06 08 2017   grade_7 5 0 0 10   0     0   3   9 9                       18 5 0 0 10   0     0   3   9 9                 18
476774 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486002779 505 BOISE CITY JHS Middle Regular School No Middle 07 08 2017   grade_7 6 0 7 0   0     0   0   5 8                       13 6 0 7 0   0     0   0   5 8                 13
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
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
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
482361 OK OSAGE   school 4005160 57-C007   BOWRING 400516000181 105 BOWRING PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 5 0 1 1   0     0   0   5 2                       7 5 0 1 1   0     0   0   5 2                 7
480650 OK MUSKOGEE   school 4005280 51-I046   BRAGGS 400528000185 105 BRAGGS ES Elementary Regular School No Elementary PK 08 2017   grade_7 7 0 0 4   0     0   0   0 11                       11 7 0 0 4   0     0   0   0 11                 11
484031 OK STEPHENS   school 4005340 69-I042   BRAY-DOYLE 400534000189 105 BRAY-DOYLE ES Elementary Regular School No Elementary PK 08 2017   grade_7 23 0 2 3   0     0   7   15 20                       35 23 0 2 3   0     0   7   15 20                 35
478592 OK GRADY   school 4005400 26-I095   BRIDGE CREEK 400540001674 505 BRIDGE CREEK MS Middle Regular School No Middle 06 08 2017   grade_7 85 0 4 2   0     0   15   57 49                       106 85 0 4 2   0     0   15   57 49                 106
476618 OK CHEROKEE   school 4005430 11-C044   BRIGGS 400543000192 105 BRIGGS PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 4 0 6 23   0     0   5   22 16                       38 4 0 6 23   0     0   5   22 16                 38
477051 OK CLEVELAND   school 4020250 14-I002   MOORE 402025002214 610 BRINK JHS Junior High Regular School No Middle 07 08 2017   grade_7 153 12 36 12   39     0   58   162 148                       310 153 12 36 12   39     0   58   162 148                 310
477752 OK CREEK   school 4005460 19-I002   BRISTOW 400546002083 505 BRISTOW MS Middle Regular School No Middle 06 08 2017   grade_7 70 9 3 36   0     0   0   62 56                       118 70 9 3 36   0     0   0   62 56                 118
483768 OK SEQUOYAH   school 4005580 68-C036   BRUSHY 400558000214 105 BRUSHY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 13 0 2 10   0     0   6   13 18                       31 13 0 2 10   0     0   6   13 18                 31
478752 OK HARPER   school 4005760 30-I004   BUFFALO 400576000215 105 BUFFALO ES Elementary Regular School No Elementary PK 08 2017   grade_7 14 0 4 0   0     0   0   6 12                       18 14 0 4 0   0     0   0   6 12                 18
479422 OK LATIMER   school 4005820 39-I003   BUFFALO VALLEY 400582000217 105 BUFFALO VALLEY ES Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 1 6   0     0   0   9 1                       10 3 0 1 6   0     0   0   9 1                 10
475629 OK ALFALFA   school 4005910 02-I001   BURLINGTON 400591000220 105 BURLINGTON ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 2 0   0     0   1   5 6                       11 8 0 2 0   0     0   1   5 6                 11
483733 OK SEMINOLE   school 4006000 67-I015   BUTNER 400600000227 105 BUTNER ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 1 2 5   0     0   2   10 8                       18 8 1 2 5   0     0   2   10 8                 18
483023 OK PONTOTOC   school 4006060 62-I016   BYNG 400606029751 610 BYNG JHS Junior High Regular School No Other 07 09 2017   grade_7 70 5 3 38   1     0   22   57 82                       139 70 5 3 38   1     0   22   57 82                 139
477347 OK COMANCHE   school 4006120 16-I001   CACHE 400612029646 505 CACHE MS Middle Regular School No Middle 07 08 2017   grade_7 80 14 22 28   3     3   7   88 69                       157 80 14 22 28   3     3   7   88 69                 157
475979 OK BRYAN   school 4006150 07-I005   CADDO 400615000237 105 CADDO ES Elementary Regular School No Elementary PK 08 2017   grade_7 30 0 0 12   0     1   3   24 22                       46 30 0 0 12   0     1   3   24 22                 46
476009 OK BRYAN   school 4006180 07-I048   CALERA 400618000239 105 CALERA ES Elementary Regular School No Elementary PK 08 2017   grade_7 27 1 2 12   0     0   2   20 24                       44 27 1 2 12   0     0   2   20 24                 44
476409 OK CANADIAN   school 4006240 09-I076   CALUMET 400624000241 105 CALUMET ES Elementary Regular School No Elementary PK 08 2017   grade_7 16 0 1 4   0     0   2   5 18                       23 16 0 1 4   0     0   2   5 18                 23
478875 OK HUGHES   school 4006270 32-I048   CALVIN 400627000243 105 CALVIN ES Elementary Regular School No Elementary PK 08 2017   grade_7 6 0 0 4   0     0   1   8 3                       11 6 0 0 4   0     0   1   8 3                 11
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
482836 OK PITTSBURG   school 4006390 61-I002   CANADIAN 400639000248 105 CANADIAN ES Elementary Regular School No Elementary PK 08 2017   grade_7 13 0 1 18   0     0   2   18 16                       34 13 0 1 18   0     0   2   18 16                 34
475735 OK ATOKA   school 4006420 03-I026   CANEY 400642000250 105 CANEY ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 1 3   0     0   3   10 5                       15 8 0 1 3   0     0   3   10 5                 15
485331 OK WASHINGTON   school 4025470 74-I018   CANEY VALLEY 402547001358 510 CANEY VALLEY MS Middle Regular School No Middle 06 08 2017   grade_7 25 0 2 22   0     0   1   29 21                       50 25 0 2 22   0     0   1   29 21                 50
475909 OK BLAINE   school 4006480 06-I105   CANTON 400648000253 105 CANTON ES Elementary Regular School No Elementary PK 08 2017   grade_7 15 0 3 6   0     0   0   10 14                       24 15 0 3 6   0     0   0   10 14                 24
485428 OK WASHITA   school 4006510 75-I011   CANUTE 400651000255 105 CANUTE ES Elementary Regular School No Elementary PK 08 2017   grade_7 25 0 5 3   0     0   0   16 17                       33 25 0 5 3   0     0   0   16 17                 33
481491 OK OKLAHOMA   school 4019950 55-I052   MIDWEST CITY-DEL CITY 401995002659 505 CARL ALBERT MS Middle Regular School No Middle 06 08 2017   grade_7 142 61 34 21   4     2   3   137 130                       267 142 61 34 21   4     2   3   137 130                 267
482851 OK PITTSBURG   school 4000795 61-E020   CANADIAN 400079502830 972 CARLTON LANDING ACADEMY CHARTR Charter Regular School Yes Other PK 12 2017   grade_7 2 0 0 0   0     0   0   2 0                       2 2 0 0 0   0     0   0   2 0                 2
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
479781 OK LINCOLN   school 4006690 41-I105   CARNEY 400669000261 105 CARNEY ES Elementary Regular School No Elementary PK 08 2017   grade_7 18 1 0 2   0     0   0   7 14                       21 18 1 0 2   0     0   0   7 14                 21
484661 OK TULSA   school 4030240 72-I001   TULSA 403024001594 515 CARVER MS Middle Regular School No Middle 06 08 2017   grade_7 60 60 36 13   6     0   22   75 122                       197 60 60 36 13   6     0   22   75 122                 197
479310 OK KINGFISHER   school 4006810 37-I089   CASHION 400681002816 505 CASHION MS Middle Regular School No Middle 06 08 2017   grade_7 35 1 1 2   0     0   2   26 15                       41 35 1 1 2   0     0   2   26 15                 41
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
476149 OK CADDO   school 4006960 08-I160   CEMENT 400696000276 105 CEMENT ES Elementary Regular School No Elementary PK 08 2017   grade_7 17 0 2 5   0     0   0   13 11                       24 17 0 2 5   0     0   0   13 11                 24
484897 OK TULSA   school 4005490 72-I003   BROKEN ARROW 400549000200 505 CENTENNIAL MS Middle Regular School No Middle 06 08 2017   grade_7 193 20 71 29   18     1   17   174 175                       349 193 20 71 29   18     1   17   174 175                 349
483897 OK SEQUOYAH   school 4007140 68-I007   CENTRAL 400714000279 105 CENTRAL ES Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 1 21   0     0   11   20 16                       36 3 0 1 21   0     0   11   20 16                 36
484019 OK STEPHENS   school 4007170 69-I034   CENTRAL HIGH 400717002756 600 CENTRAL HIGH JHS Junior High Regular School No Other 07 09 2017   grade_7 20 0 1 2   0     0   2   10 15                       25 20 0 1 2   0     0   2   10 15                 25
477059 OK CLEVELAND   school 4020250 14-I002   MOORE 402025001606 685 CENTRAL JHS Junior High Regular School No Middle 07 08 2017   grade_7 165 19 36 13   5     1   68   170 137                       307 165 19 36 13   5     1   68   170 137                 307
484087 OK TEXAS   school 4013590 70-I008   GUYMON 401359000637 610 CENTRAL JHS Junior High Regular School No Middle 07 08 2017   grade_7 36 7 167 0   8     0   2   110 110                       220 36 7 167 0   8     0   2   110 110                 220
484679 OK TULSA   school 4030240 72-I001   TULSA 403024002731 658 CENTRAL JHS Junior High Regular School No Middle 07 08 2017   grade_7 22 62 12 10   0     5   13   70 54                       124 22 62 12 10   0     5   13   70 54                 124
477524 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002393 535 CENTRAL MS Middle Regular School No Middle 06 08 2017   grade_7 89 58 59 17   3     2   23   131 120                       251 89 58 59 17   3     2   23   131 120                 251
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
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
479954 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000537 510 CHAMBERLAIN MS Middle Regular School No Middle 06 08 2017   grade_7 47 0 1 4   0     0   0   24 28                       52 47 0 1 4   0     0   0   24 28                 52
479694 OK LINCOLN   school 4007290 41-I001   CHANDLER 400729002375 610 CHANDLER JHS Junior High Regular School No Middle 07 08 2017   grade_7 53 3 1 5   0     0   24   43 43                       86 53 3 1 5   0     0   24   43 43                 86
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
480422 OK MCINTOSH   school 4007350 49-I019   CHECOTAH 400735001859 505 CHECOTAH MS Middle Regular School No Middle 05 08 2017   grade_7 61 4 2 35   0     0   11   59 54                       113 61 4 2 35   0     0   11   59 54                 113
483526 OK ROGERS   school 4007380 66-I003   CHELSEA 400738002310 510 CHELSEA MS Middle Regular School No Middle 06 08 2017   grade_7 24 1 0 34   0     0   0   36 23                       59 24 1 0 34   0     0   0   36 23                 59

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