Data source: Big Local News · About: Big Local

595 rows where grade = "grade_7", state = "OK" and year = 2020

View and edit SQL

year

  • 2020 · 495

grade

  • grade_7 · 495
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
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
3026924 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2020   grade_7 164 18 29 16   3     1   35   151 115                       266 164 18 29 16   3     1   35   151 115                 266
3026927 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2020   grade_7 263 21 54 7   17     0   38   198 202                       400 263 21 54 7   17     0   38   198 202                 400
3026951 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163002370 510 CURTIS INGE MS Middle Regular School No Middle 06 08 2020   grade_7 134 9 17 32   2     0   11   106 99                       205 134 9 17 32   2     0   11   106 99                 205
3026965 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758002678 510 LEXINGTON MS Middle Regular School No Middle 06 08 2020   grade_7 62 1 13 6   0     0   17   55 44                       99 62 1 13 6   0     0   17   55 44                 99
3026979 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000103 505 LITTLE AXE MS Middle Regular School No Middle 06 08 2020   grade_7 51 0 13 12   0     0   19   49 46                       95 51 0 13 12   0     0   19   49 46                 95
3026991 OK COAL   school 4008730 15-C004   COTTONWOOD 400873000369 105 COTTONWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 5 0 0 3   0     0   4   6 6                       12 5 0 0 3   0     0   4   6 6                 12
3027003 OK COAL   school 4008130 15-I001   COALGATE 400813001958 505 WALLACE BYRD MS Middle Regular School No Middle 07 08 2020   grade_7 21 0 2 22   0     0   2   26 21                       47 21 0 2 22   0     0   2   26 21                 47
3027015 OK COAL   school 4030270 15-I002   TUPELO 403027001683 105 TUPELO ES Elementary Regular School No Elementary PK 08 2020   grade_7 9 0 0 4   0     0   4   12 5                       17 9 0 0 4   0     0   4   12 5                 17
3027046 OK COMANCHE   school 4006120 16-I001   CACHE 400612029646 505 CACHE MS Middle Regular School No Middle 07 08 2020   grade_7 82 10 24 29   1     2   20   101 67                       168 82 10 24 29   1     2   20   101 67                 168
3027063 OK COMANCHE   school 4015420 16-I002   INDIAHOMA 401542000729 105 INDIAHOMA ES Elementary Regular School No Elementary PK 08 2020   grade_7 4 0 1 6   0     0   0   6 5                       11 4 0 1 6   0     0   0   6 5                 11
3027077 OK COMANCHE   school 4028590 16-I003   STERLING 402859001498 105 STERLING ES Elementary Regular School No Elementary PK 08 2020   grade_7 25 0 0 2   0     0   0   18 9                       27 25 0 0 2   0     0   0   18 9                 27
3027093 OK COMANCHE   school 4012630 16-I004   GERONIMO 401263002732 505 GERONIMO MS Middle Regular School No Middle 07 08 2020   grade_7 11 1 11 2   0     1   3   11 18                       29 11 1 11 2   0     1   3   11 18                 29
3027221 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002364 530 MACARTHUR MS Middle Regular School No Middle 06 08 2020   grade_7 107 43 35 8   5     4   45   127 120                       247 107 43 35 8   5     4   45   127 120                 247
3027224 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002393 535 CENTRAL MS Middle Regular School No Middle 06 08 2020   grade_7 85 50 57 11   3     2   31   133 106                       239 85 50 57 11   3     2   31   133 106                 239
3027228 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002404 540 TOMLINSON MS Middle Regular School No Middle 06 08 2020   grade_7 69 60 52 15   1     1   40   119 119                       238 69 60 52 15   1     1   40   119 119                 238
3027232 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002679 545 EISENHOWER MS Middle Regular School No Middle 06 08 2020   grade_7 84 91 66 18   6     2   45   163 149                       312 84 91 66 18   6     2   45   163 149                 312
3027257 OK COMANCHE   school 4011700 16-I009   FLETCHER 401170000550 615 FLETCHER JHS Junior High Regular School No Middle 07 08 2020   grade_7 29 0 3 2   0     0   7   19 22                       41 29 0 3 2   0     0   7   19 22                 41
3027271 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2020   grade_7 101 7 22 17   0     1   18   94 72                       166 101 7 22 17   0     1   18   94 72                 166
3027285 OK COMANCHE   school 4007320 16-I132   CHATTANOOGA 400732000286 105 CHATTANOOGA ES Elementary Regular School No Elementary PK 08 2020   grade_7 17 0 1 0   0     0   2   7 13                       20 17 0 1 0   0     0   2   7 13                 20
3027303 OK COTTON   school 4031470 17-I001   WALTERS 403147029649 505 WALTERS MS Middle Regular School No Middle 06 08 2020   grade_7 41 1 6 11   0     0   5   34 30                       64 41 1 6 11   0     0   5   34 30                 64
3027315 OK COTTON   school 4029640 17-I101   TEMPLE 402964001557 105 TEMPLE ES Elementary Regular School No Elementary PK 08 2020   grade_7 7 0 0 1   0     0   1   4 5                       9 7 0 0 1   0     0   1   4 5                 9
3027329 OK COTTON   school 4004350 17-I333   BIG PASTURE 400435000138 105 BIG PASTURE ES Elementary Regular School No Elementary PK 08 2020   grade_7 11 0 2 0   0     0   1   10 4                       14 11 0 2 0   0     0   1   10 4                 14
3027343 OK CRAIG   school 4032610 18-C001   WHITE OAK 403261001802 105 WHITE OAK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 0 0 1 0   0     0   0   1 0                       1 0 0 1 0   0     0   0   1 0                 1
3027355 OK CRAIG   school 4016380 18-I006   KETCHUM 401638002359 505 KETCHUM MS Middle Regular School No Middle 06 08 2020   grade_7 27 0 0 25   0     0   1   33 20                       53 27 0 0 25   0     0   1   33 20                 53
3027369 OK CRAIG   school 4032190 18-I017   WELCH 403219001782 515 WELCH MS Middle Regular School No Middle 06 08 2020   grade_7 9 0 3 8   0     0   0   10 10                       20 9 0 3 8   0     0   0   10 10                 20
3027384 OK CRAIG   school 4004830 18-I020   BLUEJACKET 400483002082 505 BLUEJACKET MS Middle Regular School No Middle 06 08 2020   grade_7 5 0 1 7   0     0   0   6 7                       13 5 0 1 7   0     0   0   6 7                 13
3027398 OK CRAIG   school 4031290 18-I065   VINITA 403129001732 510 EWING HALSELL MS Middle Regular School No Middle 06 08 2020   grade_7 43 1 6 48   0     0   16   55 59                       114 43 1 6 48   0     0   16   55 59                 114
3027412 OK CREEK   school 4018240 19-C008   LONE STAR 401824000872 105 LONE STAR PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 44 1 2 19   0     0   12   41 37                       78 44 1 2 19   0     0   12   41 37                 78
3027422 OK CREEK   school 4013600 19-C012   GYPSY 401360000643 105 GYPSY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 1 0 0 2   0     0   0   2 1                       3 1 0 0 2   0     0   0   2 1                 3
3027432 OK CREEK   school 4025080 19-C034   PRETTY WATER 402508001316 105 PRETTY WATER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 10 0 1 4   0     0   1   4 12                       16 10 0 1 4   0     0   1   4 12                 16
3027442 OK CREEK   school 4002790 19-C035   ALLEN-BOWDEN 400279000027 105 ALLEN-BOWDEN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 22 0 8 8   0     0   2   23 17                       40 22 0 8 8   0     0   2   23 17                 40
3027454 OK CREEK   school 4005460 19-I002   BRISTOW 400546002083 505 BRISTOW MS Middle Regular School No Middle 06 08 2020   grade_7 84 12 5 38   1     0   1   68 73                       141 84 12 5 38   1     0   1   68 73                 141
3027470 OK CREEK   school 4018840 19-I003   MANNFORD 401884000895 500 MANNFORD MS Middle Regular School No Middle 06 08 2020   grade_7 81 1 5 12   0     0   14   56 57                       113 81 1 5 12   0     0   14   56 57                 113
3027482 OK CREEK   school 4020550 19-I005   MOUNDS 402055001018 105 MOUNDS ES Elementary Regular School No Elementary PK 08 2020   grade_7 26 1 2 14   0     0   4   30 17                       47 26 1 2 14   0     0   4   30 17                 47
3027496 OK CREEK   school 4022860 19-I017   OLIVE 402286001217 105 OLIVE ES Elementary Regular School No Elementary PK 08 2020   grade_7 12 0 0 2   0     0   3   13 4                       17 12 0 0 2   0     0   3   13 4                 17
3027513 OK CREEK   school 4016500 19-I018   KIEFER 401650002371 505 RONGEY MS Middle Regular School No Middle 07 08 2020   grade_7 35 0 3 10   0     0   7   22 33                       55 35 0 3 10   0     0   7   22 33                 55
3027526 OK CREEK   school 4022560 19-I020   OILTON 402256001102 105 J. F. KENNEDY ES Elementary Regular School No Elementary PK 08 2020   grade_7 9 0 0 3   0     0   0   9 3                       12 9 0 0 3   0     0   0   9 3                 12
3027540 OK CREEK   school 4009750 19-I021   DEPEW 400975000418 105 DEPEW ES Elementary Regular School No Elementary PK 08 2020   grade_7 21 0 1 3   0     0   2   15 12                       27 21 0 1 3   0     0   2   15 12                 27
3027557 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000154 505 KELLYVILLE MS Middle Regular School No Middle 07 08 2020   grade_7 40 0 4 16   0     0   6   35 31                       66 40 0 4 16   0     0   6   35 31                 66
3027592 OK CREEK   school 4026910 19-I033   SAPULPA 402691001882 505 SAPULPA MS Middle Regular School No Middle 06 07 2020   grade_7 131 9 18 33   0     0   52   122 121                       243 131 9 18 33   0     0   52   122 121                 243
3027606 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020002709 505 VIRGIL COOPER MS Middle Regular School No Middle 06 08 2020   grade_7 22 0 1 3   0     0   14   21 19                       40 22 0 1 3   0     0   14   21 19                 40
3027618 OK CUSTER   school 4003120 20-I005   ARAPAHO-BUTLER 400312000063 105 ARAPAHO-BUTLER ES Elementary Regular School No Elementary PK 08 2020   grade_7 27 0 5 3   0     0   2   18 19                       37 27 0 5 3   0     0   2   18 19                 37
3027634 OK CUSTER   school 4000015 20-I007   THOMAS-FAY-CUSTER UNIFIED DIST 400001501641 615 THOMAS-FAY-CUSTER UNIFIED JHS Junior High Regular School No Middle 07 09 2020   grade_7 26 1 4 3   0     0   0   15 19                       34 26 1 4 3   0     0   0   15 19                 34
3027649 OK CUSTER   school 4032070 20-I026   WEATHERFORD 403207029848 510 WEATHERFORD MS Middle Regular School No Middle 06 08 2020   grade_7 116 2 43 12   2     0   21   97 99                       196 116 2 43 12   2     0   21   97 99                 196
3027664 OK CUSTER   school 4008070 20-I099   CLINTON 400807000339 505 CLINTON MS Middle Regular School No Middle 07 08 2020   grade_7 51 6 78 16   1     0   20   97 75                       172 51 6 78 16   1     0   20   97 75                 172
3027676 OK DELAWARE   school 4008010 21-C006   CLEORA 400801000330 105 CLEORA PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 4 1 0 5   0     0   0   7 3                       10 4 1 0 5   0     0   0   7 3                 10
3027687 OK DELAWARE   school 4017310 21-C014   LEACH 401731000843 105 LEACH PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 0 0 1 5   0     0   0   3 3                       6 0 0 1 5   0     0   0   3 3                 6
3027697 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 0 0 0 11   0     0   1   9 3                       12 0 0 0 11   0     0   1   9 3                 12
3027706 OK DELAWARE   school 4020430 21-C034   MOSELEY 402043001012 105 MOSELEY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 8 0 2 5   0     0   0   8 7                       15 8 0 2 5   0     0   0   8 7                 15
3027718 OK DELAWARE   school 4015690 21-I001   JAY 401569000737 505 JAY MS Middle Regular School No Middle 06 08 2020   grade_7 31 1 13 41   11     0   12   62 47                       109 31 1 13 41   11     0   12   62 47                 109
3027732 OK DELAWARE   school 4013530 21-I002   GROVE 401353000627 505 GROVE MS Middle Regular School No Middle 07 08 2020   grade_7 103 1 12 73   3     1   1   94 100                       194 103 1 12 73   3     1   1   94 100                 194
3027746 OK DELAWARE   school 4015990 21-I003   KANSAS 401599002269 505 KANSAS MS Middle Regular School No Middle 06 08 2020   grade_7 15 0 0 43   1     0   1   34 26                       60 15 0 0 43   1     0   1   34 26                 60
3027758 OK DELAWARE   school 4008250 21-I004   COLCORD 400825000345 105 COLCORD ES Elementary Regular School No Elementary PK 08 2020   grade_7 17 1 3 19   0     0   2   28 14                       42 17 1 3 19   0     0   2   28 14                 42
3027772 OK DELAWARE   school 4022410 21-I005   OAKS-MISSION 402241001099 105 OAKS-MISSION ES Elementary Regular School No Elementary PK 08 2020   grade_7 1 0 2 10   1     0   0   9 5                       14 1 0 2 10   1     0   0   9 5                 14
3027786 OK DEWEY   school 4031170 22-I005   VICI 403117001727 105 VICI ES Elementary Regular School No Elementary PK 08 2020   grade_7 10 0 1 0   0     0   7   10 8                       18 10 0 1 0   0     0   7   10 8                 18
3027803 OK DEWEY   school 4027240 22-I008   SEILING 402724001438 615 SEILING JR-SR HS (JR) Junior High Regular School No Middle 07 09 2020   grade_7 20 0 5 2   0     0   3   11 19                       30 20 0 5 2   0     0   3   11 19                 30
3027817 OK DEWEY   school 4029430 22-I010   TALOGA 402943001549 105 TALOGA ES Elementary Regular School No Elementary PK 08 2020   grade_7 5 0 0 1   0     0   0   4 2                       6 5 0 0 1   0     0   0   4 2                 6
3027831 OK ELLIS   school 4011430 23-I002   FARGO 401143000542 105 FARGO ES Elementary Regular School No Elementary PK 08 2020   grade_7 18 0 3 2   0     0   1   14 10                       24 18 0 3 2   0     0   1   14 10                 24
3027845 OK ELLIS   school 4003240 23-I003   ARNETT 400324000077 105 ARNETT ES Elementary Regular School No Elementary PK 08 2020   grade_7 10 0 2 0   0     0   2   6 8                       14 10 0 2 0   0     0   2   6 8                 14
3027859 OK ELLIS   school 4027540 23-I042   SHATTUCK 402754001452 105 SHATTUCK ES Elementary Regular School No Elementary PK 08 2020   grade_7 30 0 4 0   0     0   1   25 10                       35 30 0 4 0   0     0   1   25 10                 35
3027875 OK GARFIELD   school 4031950 24-I001   WAUKOMIS 403195002902 515 WAUKOMIS MS Middle Regular School No Middle 05 08 2020   grade_7 27 0 2 0   0     0   0   14 15                       29 27 0 2 0   0     0   0   14 15                 29
3027887 OK GARFIELD   school 4016740 24-I018   KREMLIN-HILLSDALE 401674000784 105 KREMLIN-HILLSDALE ES Elementary Regular School No Elementary PK 08 2020   grade_7 20 0 3 0   0     0   0   11 12                       23 20 0 3 0   0     0   0   11 12                 23
3027903 OK GARFIELD   school 4021780 24-I042   CHISHOLM 402178002105 505 CHISHOLM MS Middle Regular School No Middle 06 08 2020   grade_7 80 3 4 5   1     0   1   48 46                       94 80 3 4 5   1     0   1   48 46                 94
3027915 OK GARFIELD   school 4012420 24-I047   GARBER 401242000583 105 GARBER ES Elementary Regular School No Elementary PK 08 2020   grade_7 27 2 2 0   0     0   0   19 12                       31 27 2 2 0   0     0   0   19 12                 31
3027931 OK GARFIELD   school 4024510 24-I056   PIONEER-PLEASANT VALE 402451029667 610 PIONEER-PLEASANT VALE JHS Junior High Regular School No Middle 07 08 2020   grade_7 24 0 5 1   0     0   4   21 13                       34 24 0 5 1   0     0   4   21 13                 34
3028017 OK GARFIELD   school 4010920 24-I057   ENID 401092002700 505 EMERSON MS Middle Regular School No Middle 06 08 2020   grade_7 63 5 48 1   4     11   6   67 71                       138 63 5 48 1   4     11   6   67 71                 138
3028021 OK GARFIELD   school 4010920 24-I057   ENID 401092002686 510 LONGFELLOW MS Middle Regular School No Middle 06 08 2020   grade_7 37 8 84 2   1     36   8   82 94                       176 37 8 84 2   1     36   8   82 94                 176
3028024 OK GARFIELD   school 4010920 24-I057   ENID 401092000510 515 DEWITT WALLER MS Middle Regular School No Middle 06 08 2020   grade_7 178 10 41 6   1     14   12   123 139                       262 178 10 41 6   1     14   12   123 139                 262
3028037 OK GARFIELD   school 4010170 24-I085   DRUMMOND 401017000438 105 DRUMMOND ES Elementary Regular School No Elementary PK 08 2020   grade_7 23 0 7 1   0     0   0   12 19                       31 23 0 7 1   0     0   0   12 19                 31
3028051 OK GARFIELD   school 4008790 24-I094   COVINGTON-DOUGLAS 400879000370 105 COVINGTON-DOUGLAS ES Elementary Regular School No Elementary PK 08 2020   grade_7 11 0 5 0   0     0   6   8 14                       22 11 0 5 0   0     0   6   8 14                 22
3028065 OK GARVIN   school 4032670 25-C016   WHITEBEAD 403267001805 105 WHITEBEAD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 12 0 11 1   0     0   5   16 13                       29 12 0 11 1   0     0   5   16 13                 29
3028078 OK GARVIN   school 4028980 25-I002   STRATFORD 402898002677 505 STRATFORD MS Middle Regular School No Middle 06 08 2020   grade_7 31 0 3 10   0     0   1   26 19                       45 31 0 3 10   0     0   1   26 19                 45
3028090 OK GARVIN   school 4023430 25-I005   PAOLI 402343001244 105 PAOLI ES Elementary Regular School No Elementary PK 08 2020   grade_7 8 0 4 0   0     0   7   11 8                       19 8 0 4 0   0     0   7   11 8                 19
3028106 OK GARVIN   school 4019380 25-I007   MAYSVILLE 401938000913 105 MAYSVILLE ES Elementary Regular School No Elementary PK 08 2020   grade_7 17 0 2 2   0     0   5   12 14                       26 17 0 2 2   0     0   5   12 14                 26
3028123 OK GARVIN   school 4017850 25-I009   LINDSAY 401785017850 505 LINDSAY MS Middle Regular School No Middle 06 08 2020   grade_7 62 0 15 10   0     0   0   43 44                       87 62 0 15 10   0     0   0   43 44                 87
3028138 OK GARVIN   school 4023550 25-I018   PAULS VALLEY 402355002372 610 PAULS VALLEY JHS Junior High Regular School No Middle 07 09 2020   grade_7 53 8 16 12   1     0   3   45 48                       93 53 8 16 12   1     0   3   45 48                 93
3028152 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2020   grade_7 27 4 4 8   0     0   4   25 22                       47 27 4 4 8   0     0   4   25 22                 47
3028166 OK GARVIN   school 4010860 25-I072   ELMORE CITY-PERNELL 401086002746 605 ELMORE CITY JHS Junior High Regular School No Middle 06 08 2020   grade_7 32 2 1 7   0     0   3   24 21                       45 32 2 1 7   0     0   3   24 21                 45
3028179 OK GRADY   school 4012210 26-C037   FRIEND 401221000575 105 FRIEND PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 13 0 7 2   0     0   3   14 11                       25 13 0 7 2   0     0   3   14 11                 25
3028189 OK GRADY   school 4019890 26-C096   MIDDLEBERG 401989000949 105 MIDDLEBERG PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 17 0 1 1   0     0   0   10 9                       19 17 0 1 1   0     0   0   10 9                 19
3028199 OK GRADY   school 4024150 26-C131   PIONEER 402415001274 105 PIONEER PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 25 2 3 0   1     0   0   21 10                       31 25 2 3 0   1     0   0   21 10                 31
3028211 OK GRADY   school 4007560 26-I001   CHICKASHA 400756002342 510 CHICKASHA MS Middle Regular School No Middle 07 08 2020   grade_7 101 9 20 20   0     0   2   69 83                       152 101 9 20 20   0     0   2   69 83                 152
3028225 OK GRADY   school 4020100 26-I002   MINCO 402010001668 505 MINCO MS Middle Regular School No Middle 06 08 2020   grade_7 31 0 3 0   0     0   9   17 26                       43 31 0 3 0   0     0   9   17 26                 43
3028239 OK GRADY   school 4021600 26-I051   NINNEKAH 402160001673 510 NINNEKAH MS Middle Regular School No Middle 06 08 2020   grade_7 27 0 2 0   2     0   4   12 23                       35 27 0 2 0   2     0   4   12 23                 35
3028251 OK GRADY   school 4002670 26-I056   ALEX 400267000019 105 ALEX ES Elementary Regular School No Elementary PK 08 2020   grade_7 15 0 0 0   0     0   1   8 8                       16 15 0 0 0   0     0   1   8 8                 16
3028267 OK GRADY   school 4026550 26-I068   RUSH SPRINGS 402655001391 505 RUSH SPRINGS MS Middle Regular School No Middle 06 08 2020   grade_7 21 1 0 3   0     0   1   15 11                       26 21 1 0 3   0     0   1   15 11                 26
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
3028296 OK GRADY   school 4030420 26-I097   TUTTLE 403042001696 505 TUTTLE MS Middle Regular School No Middle 06 08 2020   grade_7 121 1 14 8   0     1   10   90 65                       155 121 1 14 8   0     1   10   90 65                 155
3028309 OK GRADY   school 4031080 26-I099   VERDEN 403108001721 105 VERDEN ES Elementary Regular School No Elementary PK 08 2020   grade_7 17 0 3 1   0     0   3   13 11                       24 17 0 3 1   0     0   3   13 11                 24
3028325 OK GRADY   school 4002910 26-I128   AMBER-POCASSET 400291000047 615 AMBER-POCASSET JHS Junior High Regular School No Middle 07 09 2020   grade_7 36 2 4 1   0     0   2   24 21                       45 36 2 4 1   0     0   2   24 21                 45
3028337 OK GRANT   school 4019620 27-I054   MEDFORD 401962000934 105 MEDFORD ES Elementary Regular School No Elementary PK 08 2020   grade_7 25 0 1 0   0     0   3   14 15                       29 25 0 1 0   0     0   3   14 15                 29
3028353 OK GRANT   school 4024720 27-I090   POND CREEK-HUNTER 402472002764 505 POND CREEK-HUNTER MS Middle Regular School No Middle 05 08 2020   grade_7 30 1 2 1   0     0   3   16 21                       37 30 1 2 1   0     0   3   16 21                 37
3028365 OK GRANT   school 4017020 27-I095   DEER CREEK-LAMONT 401702000788 105 DEER CREEK-LAMONT ES Elementary Regular School No Elementary PK 08 2020   grade_7 6 0 3 1   0     0   1   4 7                       11 6 0 3 1   0     0   1   4 7                 11
3028382 OK GREER   school 4018780 28-I001   MANGUM 401878002321 510 MANGUM MS Middle Regular School No Middle 05 08 2020   grade_7 35 2 16 0   0     0   5   29 29                       58 35 2 16 0   0     0   5   29 29                 58
3028395 OK GREER   school 4013290 28-I003   GRANITE 401329000616 105 GRANITE ES Elementary Regular School No Elementary PK 08 2020   grade_7 19 0 0 2   0     0   2   15 8                       23 19 0 0 2   0     0   2   15 8                 23
3028412 OK HARMON   school 4014850 29-I066   HOLLIS 401485000701 510 HOLLIS MS Middle Regular School No Middle 06 08 2020   grade_7 11 3 24 1   0     0   2   14 27                       41 11 3 24 1   0     0   2   14 27                 41
3028426 OK HARPER   school 4017220 30-I001   LAVERNE 401722000795 105 LAVERNE ES Elementary Regular School No Elementary PK 08 2020   grade_7 22 1 10 0   0     0   1   20 14                       34 22 1 10 0   0     0   1   20 14                 34
3028441 OK HARPER   school 4005760 30-I004   BUFFALO 400576000215 105 BUFFALO ES Elementary Regular School No Elementary PK 08 2020   grade_7 12 0 9 0   0     0   0   13 8                       21 12 0 9 0   0     0   0   13 8                 21
3028455 OK HASKELL   school 4032700 31-C010   WHITEFIELD 403270001806 105 WHITEFIELD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2020   grade_7 7 0 1 3   0     0   0   5 6                       11 7 0 1 3   0     0   0   5 6                 11

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