Data source: Big Local News · About: Big Local

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

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
2306547 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2019   grade_7 8 0 4 0   0     0   0   9 3                       12 8 0 4 0   0     0   0   9 3                 12
2306561 OK BEAVER   school 4030330 04-I128   TURPIN 403033001688 105 TURPIN ES Elementary Regular School No Elementary PK 08 2019   grade_7 19 0 18 0   0     0   0   17 20                       37 19 0 18 0   0     0   0   17 20                 37
2348174 OK BEAVER   school 4003750 04-I022   BEAVER 400375000115 105 BEAVER ES Elementary Regular School No Elementary PK 08 2018   grade_7 14 0 12 0   0     0   0   18 8                       26 14 0 12 0   0     0   0   18 8                 26
2348188 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2018   grade_7 18 0 1 0   0     0   0   11 8                       19 18 0 1 0   0     0   0   11 8                 19
2348202 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2018   grade_7 9 0 3 0   0     0   0   4 8                       12 9 0 3 0   0     0   0   4 8                 12
2348216 OK BEAVER   school 4030330 04-I128   TURPIN 403033001688 105 TURPIN ES Elementary Regular School No Elementary PK 08 2018   grade_7 12 1 16 0   0     0   0   18 11                       29 12 1 16 0   0     0   0   18 11                 29
3025470 OK BEAVER   school 4003750 04-I022   BEAVER 400375000115 105 BEAVER ES Elementary Regular School No Elementary PK 08 2020   grade_7 15 0 8 0   0     0   0   13 10                       23 15 0 8 0   0     0   0   13 10                 23
3025484 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2020   grade_7 8 0 0 0   0     0   0   4 4                       8 8 0 0 0   0     0   0   4 4                 8
3025498 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2020   grade_7 6 0 3 0   0     0   0   6 3                       9 6 0 3 0   0     0   0   6 3                 9
3025512 OK BEAVER   school 4030330 04-I128   TURPIN 403033001688 105 TURPIN ES Elementary Regular School No Elementary PK 08 2020   grade_7 19 0 20 1   0     0   0   23 17                       40 19 0 20 1   0     0   0   23 17                 40
3324530 OK BEAVER   school 4003750 04-I022   BEAVER 400375000115 105 BEAVER ES Elementary Regular School No Elementary PK 08 2021   grade_7 13 0 6 0   1     0   0   9 11                       20 13 0 6 0   1     0   0   9 11                 20
3324544 OK BEAVER   school 4003510 04-I075   BALKO 400351000089 105 BALKO ES Elementary Regular School No Elementary PK 08 2021   grade_7 4 0 2 1   0     0   1   4 4                       8 4 0 2 1   0     0   1   4 4                 8
3324558 OK BEAVER   school 4011880 04-I123   FORGAN 401188000553 105 FORGAN ES Elementary Regular School No Elementary PK 08 2021   grade_7 4 0 3 0   0     0   0   4 3                       7 4 0 3 0   0     0   0   4 3                 7
3324572 OK BEAVER   school 4030330 04-I128   TURPIN 403033001688 105 TURPIN ES Elementary Regular School No Elementary PK 08 2021   grade_7 12 0 17 0   0     0   0   12 17                       29 12 0 17 0   0     0   0   12 17                 29
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
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
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
2306575 OK BECKHAM   school 4019800 05-I002   MERRITT 401980000940 105 MERRITT ES Elementary Regular School No Elementary PK 08 2019   grade_7 51 2 9 2   1     0   0   35 30                       65 51 2 9 2   1     0   0   35 30                 65
2306592 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074000496 610 ELK CITY MS Junior High Regular School No Middle 07 08 2019   grade_7 81 6 28 3   1     0   11   70 60                       130 81 6 28 3   1     0   11   70 60                 130
2306607 OK BECKHAM   school 4027060 05-I031   SAYRE 402706002268 505 SAYRE MS Middle Regular School No Middle 06 08 2019   grade_7 31 0 5 1   0     0   2   19 20                       39 31 0 5 1   0     0   2   19 20                 39
2306619 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2019   grade_7 11 0 0 0   0     0   1   6 6                       12 11 0 0 0   0     0   1   6 6                 12
2348230 OK BECKHAM   school 4019800 05-I002   MERRITT 401980000940 105 MERRITT ES Elementary Regular School No Elementary PK 08 2018   grade_7 43 0 5 5   0     0   2   29 26                       55 43 0 5 5   0     0   2   29 26                 55
2348248 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074000496 610 ELK CITY MS Junior High Regular School No Middle 07 08 2018   grade_7 113 2 29 5   5     0   13   88 79                       167 113 2 29 5   5     0   13   88 79                 167
2348263 OK BECKHAM   school 4027060 05-I031   SAYRE 402706002268 505 SAYRE MS Middle Regular School No Middle 06 08 2018   grade_7 42 0 9 0   0     0   4   32 23                       55 42 0 9 0   0     0   4   32 23                 55
2348275 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2018   grade_7 12 0 1 1   0     0   0   9 5                       14 12 0 1 1   0     0   0   9 5                 14
3025526 OK BECKHAM   school 4019800 05-I002   MERRITT 401980000940 105 MERRITT ES Elementary Regular School No Elementary PK 08 2020   grade_7 41 0 9 1   0     0   3   29 25                       54 41 0 9 1   0     0   3   29 25                 54
3025543 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074000496 610 ELK CITY MS Junior High Regular School No Middle 07 08 2020   grade_7 119 3 37 4   2     0   9   90 84                       174 119 3 37 4   2     0   9   90 84                 174
3025558 OK BECKHAM   school 4027060 05-I031   SAYRE 402706002268 505 SAYRE MS Middle Regular School No Middle 06 08 2020   grade_7 32 0 5 1   1     0   3   16 26                       42 32 0 5 1   1     0   3   16 26                 42
3025570 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2020   grade_7 19 0 3 0   0     0   2   18 6                       24 19 0 3 0   0     0   2   18 6                 24
3324586 OK BECKHAM   school 4019800 05-I002   MERRITT 401980000940 105 MERRITT ES Elementary Regular School No Elementary PK 08 2021   grade_7 50 1 5 1   0     0   2   29 30                       59 50 1 5 1   0     0   2   29 30                 59
3324603 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074000496 610 ELK CITY MS Junior High Regular School No Middle 07 08 2021   grade_7 98 5 45 7   2     0   17   92 82                       174 98 5 45 7   2     0   17   92 82                 174
3324617 OK BECKHAM   school 4027060 05-I031   SAYRE 402706002268 505 SAYRE MS Middle Regular School No Middle 06 08 2021   grade_7 38 0 6 0   0     0   8   30 22                       52 38 0 6 0   0     0   8   30 22                 52
3324629 OK BECKHAM   school 4011040 05-I051   ERICK 401104000525 105 ERICK ES Elementary Regular School No Elementary PK 08 2021   grade_7 14 0 0 0   0     0   2   9 7                       16 14 0 0 0   0     0   2   9 7                 16
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
2306636 OK BLAINE   school 4022650 06-I009   OKEENE 402265000054 615 OKEENE JR-SR HS (JR) Junior High Regular School No Middle 07 08 2019   grade_7 25 0 3 1   0     0   0   20 9                       29 25 0 3 1   0     0   0   20 9                 29
2306650 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2019   grade_7 26 5 11 7   0     0   10   24 35                       59 26 5 11 7   0     0   10   24 35                 59
2306664 OK BLAINE   school 4012570 06-I080   GEARY 401257000588 500 GEARY MS Middle Regular School No Middle 06 08 2019   grade_7 8 0 8 9   0     0   1   10 16                       26 8 0 8 9   0     0   1   10 16                 26
2306676 OK BLAINE   school 4006480 06-I105   CANTON 400648000253 105 CANTON ES Elementary Regular School No Elementary PK 08 2019   grade_7 14 0 7 8   0     0   1   15 15                       30 14 0 7 8   0     0   1   15 15                 30
2348292 OK BLAINE   school 4022650 06-I009   OKEENE 402265000054 615 OKEENE JR-SR HS (JR) Junior High Regular School No Middle 07 08 2018   grade_7 21 1 5 1   0     0   0   17 11                       28 21 1 5 1   0     0   0   17 11                 28
2348306 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2018   grade_7 30 0 9 11   0     0   3   25 28                       53 30 0 9 11   0     0   3   25 28                 53
2348320 OK BLAINE   school 4012570 06-I080   GEARY 401257000588 500 GEARY MS Middle Regular School No Middle 06 08 2018   grade_7 8 1 4 11   0     0   0   10 14                       24 8 1 4 11   0     0   0   10 14                 24
2348332 OK BLAINE   school 4006480 06-I105   CANTON 400648000253 105 CANTON ES Elementary Regular School No Elementary PK 08 2018   grade_7 15 0 1 5   0     0   0   14 7                       21 15 0 1 5   0     0   0   14 7                 21
3025586 OK BLAINE   school 4022650 06-I009   OKEENE 402265000054 615 OKEENE JR-SR HS (JR) Junior High Regular School No Middle 07 08 2020   grade_7 19 0 5 1   0     0   0   16 9                       25 19 0 5 1   0     0   0   16 9                 25
3025600 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2020   grade_7 27 3 14 7   0     0   7   27 31                       58 27 3 14 7   0     0   7   27 31                 58
3025614 OK BLAINE   school 4012570 06-I080   GEARY 401257000588 500 GEARY MS Middle Regular School No Middle 06 08 2020   grade_7 12 1 3 13   0     0   1   16 14                       30 12 1 3 13   0     0   1   16 14                 30
3025627 OK BLAINE   school 4006480 06-I105   CANTON 400648000253 105 CANTON ES Elementary Regular School No Elementary PK 08 2020   grade_7 12 1 6 6   0     0   1   13 13                       26 12 1 6 6   0     0   1   13 13                 26
3324646 OK BLAINE   school 4022650 06-I009   OKEENE 402265000054 615 OKEENE JR-SR HS (JR) Junior High Regular School No Middle 07 08 2021   grade_7 23 2 10 0   0     0   0   20 15                       35 23 2 10 0   0     0   0   20 15                 35
3324661 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2021   grade_7 23 2 9 9   0     0   8   29 22                       51 23 2 9 9   0     0   8   29 22                 51
3324675 OK BLAINE   school 4012570 06-I080   GEARY 401257000588 500 GEARY MS Middle Regular School No Middle 06 08 2021   grade_7 9 1 3 14   0     0   0   16 11                       27 9 1 3 14   0     0   0   16 11                 27
3324687 OK BLAINE   school 4006480 06-I105   CANTON 400648000253 105 CANTON ES Elementary Regular School No Elementary PK 08 2021   grade_7 11 0 5 6   0     0   2   13 11                       24 11 0 5 6   0     0   2   13 11                 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
2306692 OK BRYAN   school 4027640 07-I001   SILO 402764001471 515 SILO MS Middle Regular School No Middle 06 08 2019   grade_7 51 0 6 17   0     0   5   38 41                       79 51 0 6 17   0     0   5   38 41                 79
2306704 OK BRYAN   school 4033601 07-I002   ROCK CREEK 403360129840 105 ROCK CREEK ES Elementary Regular School No Elementary PK 08 2019   grade_7 17 0 3 13   0     0   2   18 17                       35 17 0 3 13   0     0   2   18 17                 35
2306718 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2019   grade_7 11 0 2 3   0     0   6   10 12                       22 11 0 2 3   0     0   6   10 12                 22
2306734 OK BRYAN   school 4008220 07-I004   COLBERT 400822000343 505 COLBERT MS Middle Regular School No Middle 07 08 2019   grade_7 26 1 7 14   0     0   1   25 24                       49 26 1 7 14   0     0   1   25 24                 49
2306746 OK BRYAN   school 4006150 07-I005   CADDO 400615000237 105 CADDO ES Elementary Regular School No Elementary PK 08 2019   grade_7 21 0 1 10   0     0   4   18 18                       36 21 0 1 10   0     0   4   18 18                 36
2306761 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000123 105 BENNINGTON ES Elementary Regular School No Elementary PK 08 2019   grade_7 13 1 0 8   0     0   0   13 9                       22 13 1 0 8   0     0   0   13 9                 22
2306775 OK BRYAN   school 4006180 07-I048   CALERA 400618000239 105 CALERA ES Elementary Regular School No Elementary PK 08 2019   grade_7 31 0 3 19   0     0   6   35 24                       59 31 0 3 19   0     0   6   35 24                 59
2306795 OK BRYAN   school 4010350 07-I072   DURANT 401035000457 500 DURANT MS Middle Regular School No Middle 07 08 2019   grade_7 121 12 38 54   0     0   18   112 131                       243 121 12 38 54   0     0   18   112 131                 243
2348348 OK BRYAN   school 4027640 07-I001   SILO 402764001471 515 SILO MS Middle Regular School No Middle 06 08 2018   grade_7 51 1 0 15   0     0   5   40 32                       72 51 1 0 15   0     0   5   40 32                 72
2348360 OK BRYAN   school 4033601 07-I002   ROCK CREEK 403360129840 105 ROCK CREEK ES Elementary Regular School No Elementary PK 08 2018   grade_7 20 1 2 14   0     0   0   19 18                       37 20 1 2 14   0     0   0   19 18                 37
2348374 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2018   grade_7 16 0 0 6   0     0   1   13 10                       23 16 0 0 6   0     0   1   13 10                 23
2348390 OK BRYAN   school 4008220 07-I004   COLBERT 400822000343 505 COLBERT MS Middle Regular School No Middle 07 08 2018   grade_7 34 1 6 16   0     0   2   33 26                       59 34 1 6 16   0     0   2   33 26                 59
2348402 OK BRYAN   school 4006150 07-I005   CADDO 400615000237 105 CADDO ES Elementary Regular School No Elementary PK 08 2018   grade_7 22 0 0 12   0     0   1   13 22                       35 22 0 0 12   0     0   1   13 22                 35
2348417 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000123 105 BENNINGTON ES Elementary Regular School No Elementary PK 08 2018   grade_7 15 0 1 15   0     0   0   16 15                       31 15 0 1 15   0     0   0   16 15                 31
2348431 OK BRYAN   school 4006180 07-I048   CALERA 400618000239 105 CALERA ES Elementary Regular School No Elementary PK 08 2018   grade_7 28 1 1 12   0     0   4   25 21                       46 28 1 1 12   0     0   4   25 21                 46
2348451 OK BRYAN   school 4010350 07-I072   DURANT 401035000457 500 DURANT MS Middle Regular School No Middle 07 08 2018   grade_7 136 5 32 56   3     1   18   126 125                       251 136 5 32 56   3     1   18   126 125                 251
3025643 OK BRYAN   school 4027640 07-I001   SILO 402764001471 515 SILO MS Middle Regular School No Middle 06 08 2020   grade_7 47 0 6 19   0     0   7   39 40                       79 47 0 6 19   0     0   7   39 40                 79
3025655 OK BRYAN   school 4033601 07-I002   ROCK CREEK 403360129840 105 ROCK CREEK ES Elementary Regular School No Elementary PK 08 2020   grade_7 21 0 0 8   1     0   3   18 15                       33 21 0 0 8   1     0   3   18 15                 33
3025669 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2020   grade_7 16 0 1 4   0     0   3   13 11                       24 16 0 1 4   0     0   3   13 11                 24
3025685 OK BRYAN   school 4008220 07-I004   COLBERT 400822000343 505 COLBERT MS Middle Regular School No Middle 07 08 2020   grade_7 27 2 8 15   0     0   4   25 31                       56 27 2 8 15   0     0   4   25 31                 56
3025697 OK BRYAN   school 4006150 07-I005   CADDO 400615000237 105 CADDO ES Elementary Regular School No Elementary PK 08 2020   grade_7 17 0 1 13   0     0   7   21 17                       38 17 0 1 13   0     0   7   21 17                 38
3025712 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000123 105 BENNINGTON ES Elementary Regular School No Elementary PK 08 2020   grade_7 13 2 1 17   0     0   0   19 14                       33 13 2 1 17   0     0   0   19 14                 33
3025726 OK BRYAN   school 4006180 07-I048   CALERA 400618000239 105 CALERA ES Elementary Regular School No Elementary PK 08 2020   grade_7 24 0 1 15   1     0   13   26 28                       54 24 0 1 15   1     0   13   26 28                 54
3025746 OK BRYAN   school 4010350 07-I072   DURANT 401035000457 500 DURANT MS Middle Regular School No Middle 07 08 2020   grade_7 119 10 39 55   2     0   23   116 132                       248 119 10 39 55   2     0   23   116 132                 248
3324703 OK BRYAN   school 4027640 07-I001   SILO 402764001471 515 SILO MS Middle Regular School No Middle 06 08 2021   grade_7 41 1 4 15   1     0   10   44 28                       72 41 1 4 15   1     0   10   44 28                 72
3324715 OK BRYAN   school 4033601 07-I002   ROCK CREEK 403360129840 105 ROCK CREEK ES Elementary Regular School No Elementary PK 08 2021   grade_7 18 0 2 3   0     0   3   14 12                       26 18 0 2 3   0     0   3   14 12                 26
3324729 OK BRYAN   school 4002370 07-I003   ACHILLE 400237000001 105 ACHILLE ES Elementary Regular School No Elementary PK 08 2021   grade_7 8 0 1 7   0     0   6   13 9                       22 8 0 1 7   0     0   6   13 9                 22
3324745 OK BRYAN   school 4008220 07-I004   COLBERT 400822000343 505 COLBERT MS Middle Regular School No Middle 07 08 2021   grade_7 20 1 4 14   0     0   6   24 21                       45 20 1 4 14   0     0   6   24 21                 45
3324757 OK BRYAN   school 4006150 07-I005   CADDO 400615000237 105 CADDO ES Elementary Regular School No Elementary PK 08 2021   grade_7 25 0 1 4   0     0   6   18 18                       36 25 0 1 4   0     0   6   18 18                 36
3324772 OK BRYAN   school 4003930 07-I040   BENNINGTON 400393000123 105 BENNINGTON ES Elementary Regular School No Elementary PK 08 2021   grade_7 11 1 0 14   0     0   3   16 13                       29 11 1 0 14   0     0   3   16 13                 29
3324786 OK BRYAN   school 4006180 07-I048   CALERA 400618000239 105 CALERA ES Elementary Regular School No Elementary PK 08 2021   grade_7 27 0 3 20   0     0   15   29 36                       65 27 0 3 20   0     0   15   29 36                 65
3324806 OK BRYAN   school 4010350 07-I072   DURANT 401035000457 500 DURANT MS Middle Regular School No Middle 07 08 2021   grade_7 130 6 46 71   1     0   23   138 139                       277 130 6 46 71   1     0   23   138 139                 277
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

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