Data source: Big Local News · About: Big Local

2,956 rows where grade = "grade_7" and state = "OK"

View and edit SQL

year

grade

  • grade_7 · 2,856
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
477221 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2017   grade_7 165 17 22 11   4     0   24   119 124                       243 165 17 22 11   4     0   24   119 124                 243
477224 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2017   grade_7 235 18 47 18   23     0   44   185 200                       385 235 18 47 18   23     0   44   185 200                 385
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
477250 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163002370 510 CURTIS INGE MS Middle Regular School No Middle 06 08 2017   grade_7 153 3 10 38   4     1   6   113 102                       215 153 3 10 38   4     1   6   113 102                 215
477264 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758002678 510 LEXINGTON MS Middle Regular School No Middle 06 08 2017   grade_7 57 0 10 11   1     0   3   44 38                       82 57 0 10 11   1     0   3   44 38                 82
477278 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000103 505 LITTLE AXE MS Middle Regular School No Middle 06 08 2017   grade_7 58 0 7 15   0     0   12   55 37                       92 58 0 7 15   0     0   12   55 37                 92
477290 OK COAL   school 4008730 15-C004   COTTONWOOD 400873000369 105 COTTONWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 4 1 1 7   0     0   7   12 8                       20 4 1 1 7   0     0   7   12 8                 20
477302 OK COAL   school 4008130 15-I001   COALGATE 400813001958 505 WALLACE BYRD MS Middle Regular School No Middle 07 08 2017   grade_7 25 0 6 16   0     0   1   26 22                       48 25 0 6 16   0     0   1   26 22                 48
477315 OK COAL   school 4030270 15-I002   TUPELO 403027001683 105 TUPELO ES Elementary Regular School No Elementary PK 08 2017   grade_7 17 0 1 8   0     0   3   14 15                       29 17 0 1 8   0     0   3   14 15                 29
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
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
477378 OK COMANCHE   school 4028590 16-I003   STERLING 402859001498 105 STERLING ES Elementary Regular School No Elementary PK 08 2017   grade_7 18 0 2 3   0     0   5   13 15                       28 18 0 2 3   0     0   5   13 15                 28
477394 OK COMANCHE   school 4012630 16-I004   GERONIMO 401263002732 505 GERONIMO MS Middle Regular School No Middle 07 08 2017   grade_7 9 2 6 3   1     0   2   13 10                       23 9 2 6 3   1     0   2   13 10                 23
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
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
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
477531 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002679 545 EISENHOWER MS Middle Regular School No Middle 06 08 2017   grade_7 93 100 52 24   9     1   23   157 145                       302 93 100 52 24   9     1   23   157 145                 302
477554 OK COMANCHE   school 4011700 16-I009   FLETCHER 401170000550 615 FLETCHER JHS Junior High Regular School No Middle 07 08 2017   grade_7 24 1 6 2   0     0   3   13 23                       36 24 1 6 2   0     0   3   13 23                 36
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
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
477600 OK COTTON   school 4031470 17-I001   WALTERS 403147029649 505 WALTERS MS Middle Regular School No Middle 06 08 2017   grade_7 25 0 3 5   0     0   11   23 21                       44 25 0 3 5   0     0   11   23 21                 44
477613 OK COTTON   school 4029640 17-I101   TEMPLE 402964001557 105 TEMPLE ES Elementary Regular School No Elementary PK 08 2017   grade_7 6 3 1 1   0     0   1   5 7                       12 6 3 1 1   0     0   1   5 7                 12
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
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
477654 OK CRAIG   school 4016380 18-I006   KETCHUM 401638002359 505 KETCHUM MS Middle Regular School No Middle 06 08 2017   grade_7 17 0 0 19   0     0   0   19 17                       36 17 0 0 19   0     0   0   19 17                 36
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
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
477697 OK CRAIG   school 4031290 18-I065   VINITA 403129001732 510 EWING HALSELL MS Middle Regular School No Middle 06 08 2017   grade_7 48 4 2 43   1     0   16   61 53                       114 48 4 2 43   1     0   16   61 53                 114
477710 OK CREEK   school 4018240 19-C008   LONE STAR 401824000872 105 LONE STAR PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 34 3 3 18   0     0   4   31 31                       62 34 3 3 18   0     0   4   31 31                 62
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
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
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
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
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
477780 OK CREEK   school 4020550 19-I005   MOUNDS 402055001018 105 MOUNDS ES Elementary Regular School No Elementary PK 08 2017   grade_7 29 0 1 7   0     0   1   24 14                       38 29 0 1 7   0     0   1   24 14                 38
477794 OK CREEK   school 4022860 19-I017   OLIVE 402286001217 105 OLIVE ES Elementary Regular School No Elementary PK 08 2017   grade_7 23 0 1 5   1     0   0   12 18                       30 23 0 1 5   1     0   0   12 18                 30
477810 OK CREEK   school 4016500 19-I018   KIEFER 401650002371 505 RONGEY MS Middle Regular School No Middle 07 08 2017   grade_7 31 1 9 18   0     0   5   35 29                       64 31 1 9 18   0     0   5   35 29                 64
477824 OK CREEK   school 4022560 19-I020   OILTON 402256001102 105 J. F. KENNEDY ES Elementary Regular School No Elementary PK 08 2017   grade_7 9 0 0 7   0     0   1   9 8                       17 9 0 0 7   0     0   1   9 8                 17
477838 OK CREEK   school 4009750 19-I021   DEPEW 400975000418 105 DEPEW ES Elementary Regular School No Elementary PK 08 2017   grade_7 18 0 0 5   0     0   1   12 12                       24 18 0 0 5   0     0   1   12 12                 24
477854 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000154 505 KELLYVILLE MS Middle Regular School No Middle 07 08 2017   grade_7 46 0 1 17   0     0   16   44 36                       80 46 0 1 17   0     0   16   44 36                 80
477889 OK CREEK   school 4026910 19-I033   SAPULPA 402691001882 505 SAPULPA MS Middle Regular School No Middle 06 07 2017   grade_7 152 6 21 42   0     0   48   128 141                       269 152 6 21 42   0     0   48   128 141                 269
477904 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020002709 505 VIRGIL COOPER MS Middle Regular School No Middle 07 08 2017   grade_7 21 1 2 2   0     0   1   16 11                       27 21 1 2 2   0     0   1   16 11                 27
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
477932 OK CUSTER   school 4000015 20-I007   THOMAS-FAY-CUSTER UNIFIED DIST 400001501641 615 THOMAS-FAY-CUSTER UNIFIED JHS Junior High Regular School No Other 07 09 2017   grade_7 27 0 9 3   0     0   0   18 21                       39 27 0 9 3   0     0   0   18 21                 39
477947 OK CUSTER   school 4032070 20-I026   WEATHERFORD 403207029848 510 WEATHERFORD MS Middle Regular School No Middle 06 08 2017   grade_7 88 1 27 13   2     0   22   77 76                       153 88 1 27 13   2     0   22   77 76                 153
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
477974 OK DELAWARE   school 4008010 21-C006   CLEORA 400801000330 105 CLEORA PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 5 0 0 6   0     0   0   3 8                       11 5 0 0 6   0     0   0   3 8                 11
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
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
478003 OK DELAWARE   school 4020430 21-C034   MOSELEY 402043001012 105 MOSELEY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 7 3 0 10   0     0   0   12 8                       20 7 3 0 10   0     0   0   12 8                 20
478015 OK DELAWARE   school 4015690 21-I001   JAY 401569000737 505 JAY MS Middle Regular School No Middle 06 08 2017   grade_7 41 0 4 49   4     0   16   65 49                       114 41 0 4 49   4     0   16   65 49                 114
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
478046 OK DELAWARE   school 4015990 21-I003   KANSAS 401599002269 505 KANSAS MS Middle Regular School No Middle 06 08 2017   grade_7 24 1 0 28   0     0   2   25 30                       55 24 1 0 28   0     0   2   25 30                 55
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
478077 OK DELAWARE   school 4022410 21-I005   OAKS-MISSION 402241001099 105 OAKS-MISSION ES Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 2 14   2     0   0   10 11                       21 3 0 2 14   2     0   0   10 11                 21
478093 OK DEWEY   school 4031170 22-I005   VICI 403117001727 105 VICI ES Elementary Regular School No Elementary PK 08 2017   grade_7 17 0 3 0   0     0   2   14 8                       22 17 0 3 0   0     0   2   14 8                 22
478110 OK DEWEY   school 4027240 22-I008   SEILING 402724001438 615 SEILING JR-SR HS (JR) Junior High Regular School No Other 07 09 2017   grade_7 23 0 2 2   0     0   3   14 16                       30 23 0 2 2   0     0   3   14 16                 30
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
478137 OK ELLIS   school 4011430 23-I002   FARGO 401143000542 105 FARGO ES Elementary Regular School No Elementary PK 08 2017   grade_7 9 0 2 2   0     0   0   5 8                       13 9 0 2 2   0     0   0   5 8                 13
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
478165 OK ELLIS   school 4027540 23-I042   SHATTUCK 402754001452 105 SHATTUCK ES Elementary Regular School No Elementary PK 08 2017   grade_7 28 1 7 1   1     0   1   19 20                       39 28 1 7 1   1     0   1   19 20                 39
478179 OK GARFIELD   school 4031950 24-I001   WAUKOMIS 403195001763 105 WAUKOMIS ES Elementary Regular School No Elementary PK 08 2017   grade_7 22 0 5 0   0     0   3   16 14                       30 22 0 5 0   0     0   3   16 14                 30
478194 OK GARFIELD   school 4016740 24-I018   KREMLIN-HILLSDALE 401674000784 105 KREMLIN-HILLSDALE ES Elementary Regular School No Elementary PK 08 2017   grade_7 20 0 1 1   0     0   0   13 9                       22 20 0 1 1   0     0   0   13 9                 22
478210 OK GARFIELD   school 4021780 24-I042   CHISHOLM 402178002105 505 CHISHOLM MS Middle Regular School No Middle 06 08 2017   grade_7 68 3 6 0   2     0   0   38 41                       79 68 3 6 0   2     0   0   38 41                 79
478222 OK GARFIELD   school 4012420 24-I047   GARBER 401242000583 105 GARBER ES Elementary Regular School No Elementary PK 08 2017   grade_7 21 1 1 1   0     0   0   13 11                       24 21 1 1 1   0     0   0   13 11                 24
478240 OK GARFIELD   school 4024510 24-I056   PIONEER-PLEASANT VALE 402451029667 610 PIONEER-PLEASANT VALE JHS Junior High Regular School No Middle 07 08 2017   grade_7 31 1 9 3   0     0   0   25 19                       44 31 1 9 3   0     0   0   25 19                 44
478325 OK GARFIELD   school 4010920 24-I057   ENID 401092002700 505 EMERSON MS Middle Regular School No Middle 06 08 2017   grade_7 76 3 50 1   2     9   13   83 71                       154 76 3 50 1   2     9   13   83 71                 154
478329 OK GARFIELD   school 4010920 24-I057   ENID 401092002686 510 LONGFELLOW MS Middle Regular School No Middle 06 08 2017   grade_7 46 11 77 2   1     37   13   94 93                       187 46 11 77 2   1     37   13   94 93                 187
478332 OK GARFIELD   school 4010920 24-I057   ENID 401092000510 515 DEWITT WALLER MS Middle Regular School No Middle 06 08 2017   grade_7 147 9 29 8   8     11   20   124 108                       232 147 9 29 8   8     11   20   124 108                 232
478345 OK GARFIELD   school 4010170 24-I085   DRUMMOND 401017000438 105 DRUMMOND ES Elementary Regular School No Elementary PK 08 2017   grade_7 24 0 3 0   1     0   0   10 18                       28 24 0 3 0   1     0   0   10 18                 28
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
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
478385 OK GARVIN   school 4028980 25-I002   STRATFORD 402898002677 505 STRATFORD MS Middle Regular School No Middle 06 08 2017   grade_7 32 0 1 13   0     0   1   17 30                       47 32 0 1 13   0     0   1   17 30                 47
478397 OK GARVIN   school 4023430 25-I005   PAOLI 402343001244 105 PAOLI ES Elementary Regular School No Elementary PK 08 2017   grade_7 7 0 1 5   0     0   3   8 8                       16 7 0 1 5   0     0   3   8 8                 16
478412 OK GARVIN   school 4019380 25-I007   MAYSVILLE 401938000913 105 MAYSVILLE ES Elementary Regular School No Elementary PK 08 2017   grade_7 17 1 2 4   0     0   1   6 19                       25 17 1 2 4   0     0   1   6 19                 25
478429 OK GARVIN   school 4017850 25-I009   LINDSAY 401785017850 505 LINDSAY MS Middle Regular School No Middle 06 08 2017   grade_7 61 0 9 17   1     0   2   48 42                       90 61 0 9 17   1     0   2   48 42                 90
478444 OK GARVIN   school 4023550 25-I018   PAULS VALLEY 402355002372 610 PAULS VALLEY JHS Junior High Regular School No Other 07 09 2017   grade_7 33 7 16 12   1     0   0   34 35                       69 33 7 16 12   1     0   0   34 35                 69
478458 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2017   grade_7 30 1 1 11   1     0   4   24 24                       48 30 1 1 11   1     0   4   24 24                 48
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
478485 OK GRADY   school 4012210 26-C037   FRIEND 401221000575 105 FRIEND PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 13 1 2 0   0     0   3   8 11                       19 13 1 2 0   0     0   3   8 11                 19
478496 OK GRADY   school 4019890 26-C096   MIDDLEBERG 401989000949 105 MIDDLEBERG PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 21 0 0 1   0     0   1   9 14                       23 21 0 0 1   0     0   1   9 14                 23
478506 OK GRADY   school 4024150 26-C131   PIONEER 402415001274 105 PIONEER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 22 0 1 3   0     0   0   13 13                       26 22 0 1 3   0     0   0   13 13                 26
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
478536 OK GRADY   school 4020100 26-I002   MINCO 402010001668 505 MINCO MS Middle Regular School No Middle 06 08 2017   grade_7 38 0 4 0   0     0   3   22 23                       45 38 0 4 0   0     0   3   22 23                 45
478550 OK GRADY   school 4021600 26-I051   NINNEKAH 402160001673 510 NINNEKAH MS Middle Regular School No Middle 06 08 2017   grade_7 24 2 0 3   0     0   5   20 14                       34 24 2 0 3   0     0   5   20 14                 34
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
478578 OK GRADY   school 4026550 26-I068   RUSH SPRINGS 402655001391 505 RUSH SPRINGS MS Middle Regular School No Middle 06 08 2017   grade_7 28 0 0 6   1     0   1   20 16                       36 28 0 0 6   1     0   1   20 16                 36
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
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
478619 OK GRADY   school 4031080 26-I099   VERDEN 403108001721 105 VERDEN ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 0 2   0     0   2   4 8                       12 8 0 0 2   0     0   2   4 8                 12
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
478647 OK GRANT   school 4019620 27-I054   MEDFORD 401962000934 105 MEDFORD ES Elementary Regular School No Elementary PK 08 2017   grade_7 15 0 2 1   0     0   1   13 6                       19 15 0 2 1   0     0   1   13 6                 19
478663 OK GRANT   school 4024720 27-I090   POND CREEK-HUNTER 402472002764 505 POND CREEK-HUNTER MS Middle Regular School No Middle 05 08 2017   grade_7 25 0 4 2   0     0   1   10 22                       32 25 0 4 2   0     0   1   10 22                 32
478675 OK GRANT   school 4017020 27-I095   DEER CREEK-LAMONT 401702000788 105 DEER CREEK-LAMONT ES Elementary Regular School No Elementary PK 08 2017   grade_7 9 0 0 3   1     0   0   8 5                       13 9 0 0 3   1     0   0   8 5                 13
478692 OK GREER   school 4018780 28-I001   MANGUM 401878002321 510 MANGUM MS Middle Regular School No Middle 05 08 2017   grade_7 37 0 11 0   0     0   2   25 25                       50 37 0 11 0   0     0   2   25 25                 50
478706 OK GREER   school 4013290 28-I003   GRANITE 401329000616 105 GRANITE ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 4 0   0     0   0   6 6                       12 8 0 4 0   0     0   0   6 6                 12
478723 OK HARMON   school 4014850 29-I066   HOLLIS 401485000701 510 HOLLIS MS Middle Regular School No Middle 06 08 2017   grade_7 15 1 9 1   0     0   5   10 21                       31 15 1 9 1   0     0   5   10 21                 31
478737 OK HARPER   school 4017220 30-I001   LAVERNE 401722000795 105 LAVERNE ES Elementary Regular School No Elementary PK 08 2017   grade_7 16 0 15 0   0     0   1   21 11                       32 16 0 15 0   0     0   1   21 11                 32
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
478766 OK HASKELL   school 4032700 31-C010   WHITEFIELD 403270001806 105 WHITEFIELD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 5 0 1 1   0     0   0   4 3                       7 5 0 1 1   0     0   0   4 3                 7

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