Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_7 · 2,956
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade ▼ year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
3026900 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002702 165 TRUMAN PRIMARY SCHOOL Elementary Regular School No Elementary PK 06 2020   grade_7 1 0 0 0   0     0   0   1 0                       1 1 0 0 0   0     0   0   1 0                 1
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
479208 OK KAY   school 4024690 36-I071   PONCA CITY 402469002124 505 PONCA CITY WEST MS Middle Regular School No Middle 06 07 2017   grade_7 234 15 47 56   1     3   29   206 179                       385 234 15 47 56   1     3   29   206 179                 385
479665 OK LE FLORE   school 4003210 40-I091   ARKOMA 400321000075 205 SINGLETON ES Elementary Regular School No Elementary PK 07 2017   grade_7 3 0 0 0   0     0   0   2 1                       3 3 0 0 0   0     0   0   2 1                 3
482710 OK PAYNE   school 4028680 60-I016   STILLWATER 402868029740 505 STILLWATER MS Middle Regular School No Middle 06 07 2017   grade_7 296 13 46 22   16     0   55   207 241                       448 296 13 46 22   16     0   55   207 241                 448
485112 OK TULSA   school 4030600 72-I009   UNION 403060001461 510 UNION 6TH-7TH GRADE CTR Middle Regular School No Middle 06 07 2017   grade_7 359 174 409 68   90     0   81   591 590                       1181 359 174 409 68   90     0   81   591 590                 1181
485189 OK TULSA   school 4023280 72-I011   OWASSO 402328001236 510 OWASSO 7TH GRADE CTR Middle Regular School No Middle 07 07 2017   grade_7 448 42 66 102   18     1   56   382 351                       733 448 42 66 102   18     1   56   382 351                 733
2307958 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002702 165 TRUMAN PRIMARY SCHOOL Elementary Regular School No Elementary PK 07 2019   grade_7 1 0 1 0   0     0   0   0 2                       2 1 0 1 0   0     0   0   0 2                 2
2308649 OK CREEK   school 4026910 19-I033   SAPULPA 402691001882 505 SAPULPA MS Middle Regular School No Middle 06 07 2019   grade_7 138 10 24 38   2     0   38   131 119                       250 138 10 24 38   2     0   38   131 119                 250
2309943 OK KAY   school 4024690 36-I071   PONCA CITY 402469002124 505 PONCA CITY WEST MS Middle Regular School No Middle 06 07 2019   grade_7 189 14 35 62   1     7   58   196 170                       366 189 14 35 62   1     7   58   196 170                 366
2313154 OK OSAGE   school 4003010 57-C052   ANDERSON 400301000056 105 ANDERSON PUBLIC SCHOOL Elementary Regular School No Elementary PK 07 2019   grade_7 16 0 0 2   0     0   9   10 17                       27 16 0 0 2   0     0   9   10 17                 27
2313483 OK PAYNE   school 4028680 60-I016   STILLWATER 402868029740 505 STILLWATER MS Middle Regular School No Middle 06 07 2019   grade_7 276 16 52 10   14     0   67   209 226                       435 276 16 52 10   14     0   67   209 226                 435
2315879 OK TULSA   school 4030600 72-I009   UNION 403060001461 510 UNION 6TH-7TH GRADE CTR Middle Regular School No Middle 06 07 2019   grade_7 316 189 444 52   66     0   121   620 568                       1188 316 189 444 52   66     0   121   620 568                 1188
2315964 OK TULSA   school 4023280 72-I011   OWASSO 402328001236 510 OWASSO 7TH GRADE CTR Middle Regular School No Middle 07 07 2019   grade_7 405 40 73 70   26     1   84   366 333                       699 405 40 73 70   26     1   84   366 333                 699
2350287 OK CREEK   school 4026910 19-I033   SAPULPA 402691001882 505 SAPULPA MS Middle Regular School No Middle 06 07 2018   grade_7 137 16 22 33   1     0   32   121 120                       241 137 16 22 33   1     0   32   121 120                 241
2351591 OK KAY   school 4024690 36-I071   PONCA CITY 402469002124 505 PONCA CITY WEST MS Middle Regular School No Middle 06 07 2018   grade_7 222 15 37 49   1     4   38   189 177                       366 222 15 37 49   1     4   38   189 177                 366
2354140 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002802 273 JACKSON ES Elementary Regular School No Elementary PK 07 2018   grade_7 1 2 39 1   0     0   0   23 20                       43 1 2 39 1   0     0   0   23 20                 43
2355100 OK PAYNE   school 4028680 60-I016   STILLWATER 402868029740 505 STILLWATER MS Middle Regular School No Middle 06 07 2018   grade_7 265 19 42 19   13     1   51   227 183                       410 265 19 42 19   13     1   51   227 183                 410
2357132 OK TULSA   school 4000792 72-E018   TULSA 400079202822 978 TULSA HONOR ACADEMY CHARTER Charter Regular School Yes Middle 05 07 2018   grade_7 3 4 89 2   0     0   2   55 45                       100 3 4 89 2   0     0   2   55 45                 100
2357136 OK TULSA   school 4000793 72-E019   TULSA 400079302818 979 COLLEGIATE HALL CHARTER SCHOOL Charter Regular School Yes Middle 04 07 2018   grade_7 15 15 9 5   0     2   2   25 23                       48 15 15 9 5   0     2   2   25 23                 48
2357496 OK TULSA   school 4030600 72-I009   UNION 403060001461 510 UNION 6TH-7TH GRADE CTR Middle Regular School No Middle 06 07 2018   grade_7 341 175 378 64   73     4   108   564 579                       1143 341 175 378 64   73     4   108   564 579                 1143
2357573 OK TULSA   school 4023280 72-I011   OWASSO 402328001236 510 OWASSO 7TH GRADE CTR Middle Regular School No Middle 07 07 2018   grade_7 427 39 62 100   14     2   53   342 355                       697 427 39 62 100   14     2   53   342 355                 697
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
3028823 OK KAY   school 4016530 36-C050   KILDARE 401653000769 105 KILDARE PUBLIC SCHOOL Elementary Regular School No Elementary PK 07 2020   grade_7 7 0 1 2   0     0   0   2 8                       10 7 0 1 2   0     0   0   2 8                 10
3028885 OK KAY   school 4024690 36-I071   PONCA CITY 402469002124 505 PONCA CITY WEST MS Middle Regular School No Middle 06 07 2020   grade_7 219 14 37 53   4     7   38   184 188                       372 219 14 37 53   4     7   38   184 188                 372
3030601 OK OKLAHOMA   school 4000787 55-G007   JOHN W REX CHARTER ELEMENTARY 400078702787 987 JOHN W REX CHARTER ELEMENTARY Charter Regular School Yes Elementary PK 07 2020   grade_7 21 21 9 3   0     0   11   36 29                       65 21 21 9 3   0     0   11   36 29                 65
3032249 OK PAYNE   school 4028680 60-I016   STILLWATER 402868029740 505 STILLWATER MS Middle Regular School No Middle 06 07 2020   grade_7 263 20 61 17   17     0   56   224 210                       434 263 20 61 17   17     0   56   224 210                 434
3034636 OK TULSA   school 4030600 72-I009   UNION 403060001461 510 UNION 6TH-7TH GRADE CTR Middle Regular School No Middle 06 07 2020   grade_7 317 174 462 60   77     2   110   591 611                       1202 317 174 462 60   77     2   110   591 611                 1202
3034729 OK TULSA   school 4023280 72-I011   OWASSO 402328001236 510 OWASSO 7TH GRADE CTR Middle Regular School No Middle 07 07 2020   grade_7 430 29 89 75   27     1   72   371 352                       723 430 29 89 75   27     1   72   371 352                 723
3326642 OK CREEK   school 4026910 19-I033   SAPULPA 402691001882 505 SAPULPA MS Middle Regular School No Middle 06 07 2021   grade_7 127 10 24 31   0     0   39   106 125                       231 127 10 24 31   0     0   39   106 125                 231
3327927 OK KAY   school 4024690 36-I071   PONCA CITY 402469002124 505 PONCA CITY WEST MS Middle Regular School No Middle 06 07 2021   grade_7 199 9 44 53   1     10   38   193 161                       354 199 9 44 53   1     10   38   193 161                 354
3330774 OK OKLAHOMA   school 4000806 55-Z007   OKLAHOMA INFO AND TECH SCHOOL 400080602919 950 OKLA INFO AND TECH SCHL MS Charter (Virtual) Regular School Yes Middle 06 07 2021   grade_7 6 3 1 1   0     1   4   8 8                       16 6 3 1 1   0     1   4   8 8                 16
3331247 OK PAYNE   school 4028680 60-I016   STILLWATER 402868029740 505 STILLWATER MS Middle Regular School No Middle 06 07 2021   grade_7 231 17 39 17   15     0   68   198 189                       387 231 17 39 17   15     0   68   198 189                 387
3333605 OK TULSA   school 4030600 72-I009   UNION 403060001461 510 UNION 6TH-7TH GRADE CTR Middle Regular School No Middle 06 07 2021   grade_7 308 177 495 45   73     3   122   605 618                       1223 308 177 495 45   73     3   122   605 618                 1223
3333695 OK TULSA   school 4023280 72-I011   OWASSO 402328001236 510 OWASSO 7TH GRADE CTR Middle Regular School No Middle 07 07 2021   grade_7 388 39 76 60   37     2   91   356 337                       693 388 39 76 60   37     2   91   356 337                 693
475513 OK ADAIR   school 4010560 01-C019   PEAVINE 401056000470 105 PEAVINE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 7 1 0 4   0     0   0   7 5                       12 7 1 0 4   0     0   0   7 5                 12
475523 OK ADAIR   school 4019200 01-C022   MARYETTA 401920000908 105 MARYETTA PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 6 0 3 47   0     0   0   26 30                       56 6 0 3 47   0     0   0   26 30                 56
475533 OK ADAIR   school 4026250 01-C024   ROCKY MOUNTAIN 402625001381 105 ROCKY MOUNTAIN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 2 0 0 13   0     0   0   9 6                       15 2 0 0 13   0     0   0   9 6                 15
475543 OK ADAIR   school 4033600 01-C028   ZION 403360001853 105 ZION PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 0 22   0     0   0   15 10                       25 3 0 0 22   0     0   0   15 10                 25
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
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
475573 OK ADAIR   school 4031860 01-I004   WATTS 403186001761 105 WATTS ES Elementary Regular School No Elementary PK 08 2017   grade_7 6 0 2 7   0     0   7   15 7                       22 6 0 2 7   0     0   7   15 7                 22
475589 OK ADAIR   school 4032400 01-I011   WESTVILLE 403240001795 610 WESTVILLE JHS Junior High Regular School No Middle 07 08 2017   grade_7 23 0 9 44   3     0   7   44 42                       86 23 0 9 44   3     0   7   44 42                 86
475603 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2017   grade_7 16 1 13 36   1     0   0   36 31                       67 16 1 13 36   1     0   0   36 31                 67
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
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
475646 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741002745 510 CHEROKEE MS Middle Regular School No Middle 06 08 2017   grade_7 20 0 3 1   0     0   0   15 9                       24 20 0 3 1   0     0   0   15 9                 24
475658 OK ALFALFA   school 4000013 02-I093   TIMBERLAKE 400001301028 105 TIMBERLAKE ES Elementary Regular School No Elementary PK 08 2017   grade_7 16 0 0 0   0     0   1   14 3                       17 16 0 0 0   0     0   1   14 3                 17
475672 OK ATOKA   school 4013830 03-C021   HARMONY 401383000653 105 HARMONY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 0 8   0     0   0   5 11                       16 8 0 0 8   0     0   0   5 11                 16
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
475693 OK ATOKA   school 4029010 03-I007   STRINGTOWN 402901001521 105 STRINGTOWN ES Elementary Regular School No Elementary PK 08 2017   grade_7 3 0 0 7   0     0   0   3 7                       10 3 0 0 7   0     0   0   3 7                 10
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
475721 OK ATOKA   school 4030360 03-I019   TUSHKA 403036001690 105 TUSHKA ES Elementary Regular School No Elementary PK 08 2017   grade_7 17 0 1 7   0     0   0   10 15                       25 17 0 1 7   0     0   0   10 15                 25
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
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
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
475777 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 0 7 0   0     0   0   9 6                       15 8 0 7 0   0     0   0   9 6                 15
475791 OK BEAVER   school 4030330 04-I128   TURPIN 403033001688 105 TURPIN ES Elementary Regular School No Elementary PK 08 2017   grade_7 18 0 19 0   0     0   1   22 16                       38 18 0 19 0   0     0   1   22 16                 38
475805 OK BECKHAM   school 4019800 05-I002   MERRITT 401980000940 105 MERRITT ES Elementary Regular School No Elementary PK 08 2017   grade_7 45 0 8 4   0     0   1   26 32                       58 45 0 8 4   0     0   1   26 32                 58
475840 OK BECKHAM   school 4027060 05-I031   SAYRE 402706002268 505 SAYRE MS Middle Regular School No Middle 06 08 2017   grade_7 40 2 5 2   0     0   2   22 29                       51 40 2 5 2   0     0   2   22 29                 51
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
475869 OK BLAINE   school 4022650 06-I009   OKEENE 402265000054 615 OKEENE JR-SR HS (JR) Junior High Regular School No Middle 07 08 2017   grade_7 13 0 7 1   0     0   0   9 12                       21 13 0 7 1   0     0   0   9 12                 21
475883 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2017   grade_7 28 1 7 3   0     0   8   26 21                       47 28 1 7 3   0     0   8   26 21                 47
475897 OK BLAINE   school 4012570 06-I080   GEARY 401257000588 500 GEARY MS Middle Regular School No Middle 06 08 2017   grade_7 14 0 4 8   0     0   0   10 16                       26 14 0 4 8   0     0   0   10 16                 26
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
475925 OK BRYAN   school 4027640 07-I001   SILO 402764001471 515 SILO MS Middle Regular School No Middle 06 08 2017   grade_7 31 0 2 6   0     0   5   18 26                       44 31 0 2 6   0     0   5   18 26                 44
475937 OK BRYAN   school 4033601 07-I002   ROCK CREEK 403360129840 105 ROCK CREEK ES Elementary Regular School No Elementary PK 08 2017   grade_7 18 1 1 6   0     0   1   11 16                       27 18 1 1 6   0     0   1   11 16                 27
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
475967 OK BRYAN   school 4008220 07-I004   COLBERT 400822000343 505 COLBERT MS Middle Regular School No Middle 07 08 2017   grade_7 39 2 5 20   0     0   3   33 36                       69 39 2 5 20   0     0   3   33 36                 69
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
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
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
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
476050 OK CADDO   school 4000032 08-I011   HYDRO-EAKLY 400003202357 505 HYDRO-EAKLY MS Middle Regular School No Middle 06 08 2017   grade_7 22 0 9 4   0     0   1   17 19                       36 22 0 9 4   0     0   1   17 19                 36
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
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
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
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
476123 OK CADDO   school 4009300 08-I064   CYRIL 400930002776 610 CYRIL JHS Junior High Regular School No Middle 07 08 2017   grade_7 21 0 1 7   0     0   2   16 15                       31 21 0 1 7   0     0   2   16 15                 31
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
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
476165 OK CADDO   school 4014610 08-I161   HINTON 401461000096 610 HINTON MS Junior High Regular School No Middle 06 08 2017   grade_7 27 0 9 3   0     0   1   18 22                       40 27 0 9 3   0     0   1   18 22                 40
476179 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360201597 505 FORT COBB-BROXTON MS Middle Regular School No Middle 06 08 2017   grade_7 13 0 0 4   0     0   2   9 10                       19 13 0 0 4   0     0   2   9 10                 19
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
476205 OK CANADIAN   school 4026010 09-C029   RIVERSIDE 402601001379 105 RIVERSIDE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 5 0 3 1   0     0   0   6 3                       9 5 0 3 1   0     0   0   6 3                 9
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
476226 OK CANADIAN   school 4009420 09-C070   DARLINGTON 400942000404 105 DARLINGTON PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2017   grade_7 2 0 1 19   0     0   0   11 11                       22 2 0 1 19   0     0   0   11 11                 22
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
476262 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001273 510 PIEDMONT MS Middle Regular School No Middle 07 08 2017   grade_7 192 12 26 30   13     0   5   144 134                       278 192 12 26 30   13     0   5   144 134                 278
476313 OK CANADIAN   school 4033480 09-I027   YUKON 403348002723 520 YUKON MS Middle Regular School No Middle 06 08 2017   grade_7 437 22 95 30   19     1   37   306 335                       641 437 22 95 30   19     1   37   306 335                 641
476327 OK CANADIAN   school 4010650 09-I034   EL RENO 401065000485 610 ETTA DALE JHS Junior High Regular School No Middle 07 08 2017   grade_7 81 5 52 23   0     0   29   105 85                       190 81 5 52 23   0     0   29   105 85                 190
476340 OK CANADIAN   school 4030630 09-I057   UNION CITY 403063001706 105 UNION CITY ES Elementary Regular School No Elementary PK 08 2017   grade_7 16 0 1 0   0     0   7   10 14                       24 16 0 1 0   0     0   7   10 14                 24
476392 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001047 505 MUSTANG MS Middle Regular School No Middle 07 08 2017   grade_7 292 10 39 19   10     1   36   225 182                       407 292 10 39 19   10     1   36   225 182                 407
476395 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001969 510 MUSTANG NORTH MS Middle Regular School No Middle 07 08 2017   grade_7 311 20 51 20   37     0   33   239 233                       472 311 20 51 20   37     0   33   239 233                 472
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
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
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
476458 OK CARTER   school 4028350 10-I021   SPRINGER 402835001495 105 SPRINGER ES Elementary Regular School No Elementary PK 08 2017   grade_7 8 1 2 4   0     0   4   10 9                       19 8 1 2 4   0     0   4   10 9                 19
476474 OK CARTER   school 4024240 10-I027   PLAINVIEW 402424001279 505 PLAINVIEW MS Middle Regular School No Middle 06 08 2017   grade_7 69 2 10 15   2     0   18   60 56                       116 69 2 10 15   2     0   18   60 56                 116
476489 OK CARTER   school 4018090 10-I032   LONE GROVE 401809000869 505 LONE GROVE MS Middle Regular School No Middle 06 08 2017   grade_7 67 2 6 15   0     0   10   57 43                       100 67 2 6 15   0     0   10   57 43                 100

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