Data source: Big Local News · About: Big Local

11,537 rows where state = "OK" and year = 2021 sorted by school_state_type descending

View and edit SQL

year

  • 2021 · 11,537
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
3324383 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2021   grade_5 9 0 12 30   0     0   2   21 32                       53 9 0 12 30   0     0   2   21 32                 53
3324384 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2021   grade_6 14 0 25 44   2     0   1   38 48                       86 14 0 25 44   2     0   1   38 48                 86
3324385 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2021   grade_7 5 0 12 54   0     0   1   37 35                       72 5 0 12 54   0     0   1   37 35                 72
3324386 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2021   grade_8 15 0 18 30   0     0   1   30 34                       64 15 0 18 30   0     0   1   30 34                 64
3324397 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2021   grade_5 1 0 0 2   0     0   0   2 1                       3 1 0 0 2   0     0   0   2 1                 3
3324398 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2021   grade_6 2 0 0 11   0     0   0   8 5                       13 2 0 0 11   0     0   0   8 5                 13
3324399 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2021   grade_7 0 0 0 12   0     0   0   7 5                       12 0 0 0 12   0     0   0   7 5                 12
3324400 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2021   grade_8 1 0 0 9   0     0   0   4 6                       10 1 0 0 9   0     0   0   4 6                 10
3324427 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741002745 510 CHEROKEE MS Middle Regular School No Middle 06 08 2021   grade_6 20 0 5 0   0     0   0   13 12                       25 20 0 5 0   0     0   0   13 12                 25
3324428 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741002745 510 CHEROKEE MS Middle Regular School No Middle 06 08 2021   grade_7 22 0 8 0   0     0   0   14 16                       30 22 0 8 0   0     0   0   14 16                 30
3324429 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741002745 510 CHEROKEE MS Middle Regular School No Middle 06 08 2021   grade_8 22 0 4 0   0     0   2   13 15                       28 22 0 4 0   0     0   2   13 15                 28
3324616 OK BECKHAM   school 4027060 05-I031   SAYRE 402706002268 505 SAYRE MS Middle Regular School No Middle 06 08 2021   grade_6 33 0 9 0   0     0   0   25 17                       42 33 0 9 0   0     0   0   25 17                 42
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
3324618 OK BECKHAM   school 4027060 05-I031   SAYRE 402706002268 505 SAYRE MS Middle Regular School No Middle 06 08 2021   grade_8 25 0 4 1   1     0   2   13 20                       33 25 0 4 1   1     0   2   13 20                 33
3324660 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2021   grade_6 20 1 12 9   0     0   7   33 16                       49 20 1 12 9   0     0   7   33 16                 49
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
3324662 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2021   grade_8 35 3 14 9   0     0   4   32 33                       65 35 3 14 9   0     0   4   32 33                 65
3324674 OK BLAINE   school 4012570 06-I080   GEARY 401257000588 500 GEARY MS Middle Regular School No Middle 06 08 2021   grade_6 14 0 4 8   0     0   1   17 10                       27 14 0 4 8   0     0   1   17 10                 27
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
3324676 OK BLAINE   school 4012570 06-I080   GEARY 401257000588 500 GEARY MS Middle Regular School No Middle 06 08 2021   grade_8 9 1 3 7   0     0   0   11 9                       20 9 1 3 7   0     0   0   11 9                 20
3324702 OK BRYAN   school 4027640 07-I001   SILO 402764001471 515 SILO MS Middle Regular School No Middle 06 08 2021   grade_6 38 0 5 18   0     0   12   36 37                       73 38 0 5 18   0     0   12   36 37                 73
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
3324704 OK BRYAN   school 4027640 07-I001   SILO 402764001471 515 SILO MS Middle Regular School No Middle 06 08 2021   grade_8 35 0 4 18   0     0   10   32 35                       67 35 0 4 18   0     0   10   32 35                 67
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
3324746 OK BRYAN   school 4008220 07-I004   COLBERT 400822000343 505 COLBERT MS Middle Regular School No Middle 07 08 2021   grade_8 25 1 7 14   0     0   2   21 28                       49 25 1 7 14   0     0   2   21 28                 49
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
3324807 OK BRYAN   school 4010350 07-I072   DURANT 401035000457 500 DURANT MS Middle Regular School No Middle 07 08 2021   grade_8 107 11 38 51   2     0   21   109 121                       230 107 11 38 51   2     0   21   109 121                 230
3324819 OK CADDO   school 4000032 08-I011   HYDRO-EAKLY 400003202357 505 HYDRO-EAKLY MS Middle Regular School No Middle 06 08 2021   grade_6 28 1 6 1   0     0   1   18 19                       37 28 1 6 1   0     0   1   18 19                 37
3324820 OK CADDO   school 4000032 08-I011   HYDRO-EAKLY 400003202357 505 HYDRO-EAKLY MS Middle Regular School No Middle 06 08 2021   grade_7 24 0 4 1   0     0   2   12 19                       31 24 0 4 1   0     0   2   12 19                 31
3324821 OK CADDO   school 4000032 08-I011   HYDRO-EAKLY 400003202357 505 HYDRO-EAKLY MS Middle Regular School No Middle 06 08 2021   grade_8 25 0 9 1   0     0   2   16 21                       37 25 0 9 1   0     0   2   16 21                 37
3324847 OK CADDO   school 4003000 08-I020   ANADARKO 400300002101 510 ANADARKO MS Middle Regular School No Middle 06 08 2021   grade_6 16 4 28 74   1     0   0   49 74                       123 16 4 28 74   1     0   0   49 74                 123
3324848 OK CADDO   school 4003000 08-I020   ANADARKO 400300002101 510 ANADARKO MS Middle Regular School No Middle 06 08 2021   grade_7 22 3 19 70   0     0   0   54 60                       114 22 3 19 70   0     0   0   54 60                 114
3324849 OK CADDO   school 4003000 08-I020   ANADARKO 400300002101 510 ANADARKO MS Middle Regular School No Middle 06 08 2021   grade_8 15 6 11 71   3     0   0   48 58                       106 15 6 11 71   3     0   0   48 58                 106
3324861 OK CADDO   school 4006630 08-I033   CARNEGIE 400663002676 510 CARNEGIE MS Middle Regular School No Middle 06 08 2021   grade_6 16 1 8 12   0     0   8   24 21                       45 16 1 8 12   0     0   8   24 21                 45
3324862 OK CADDO   school 4006630 08-I033   CARNEGIE 400663002676 510 CARNEGIE MS Middle Regular School No Middle 06 08 2021   grade_7 15 0 8 9   0     0   8   22 18                       40 15 0 8 9   0     0   8   22 18                 40
3324863 OK CADDO   school 4006630 08-I033   CARNEGIE 400663002676 510 CARNEGIE MS Middle Regular School No Middle 06 08 2021   grade_8 11 0 2 14   0     0   9   19 17                       36 11 0 2 14   0     0   9   19 17                 36
3324876 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2021   grade_6 16 0 7 12   0     0   4   19 20                       39 16 0 7 12   0     0   4   19 20                 39
3324877 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2021   grade_7 16 0 10 15   0     0   4   20 25                       45 16 0 10 15   0     0   4   20 25                 45
3324878 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2021   grade_8 10 0 4 6   0     0   7   17 10                       27 10 0 4 6   0     0   7   17 10                 27
3324879 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2021   out_of_home_placement 0 0 0 1   0     0   0   0 1                       1 0 0 0 1   0     0   0   0 1                 1
3324949 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360201597 505 FORT COBB-BROXTON MS Middle Regular School No Middle 06 08 2021   grade_6 14 0 4 4   0     0   5   19 8                       27 14 0 4 4   0     0   5   19 8                 27
3324950 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360201597 505 FORT COBB-BROXTON MS Middle Regular School No Middle 06 08 2021   grade_7 7 1 0 9   0     0   4   9 12                       21 7 1 0 9   0     0   4   9 12                 21
3324951 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360201597 505 FORT COBB-BROXTON MS Middle Regular School No Middle 06 08 2021   grade_8 11 0 2 6   0     0   3   12 10                       22 11 0 2 6   0     0   3   12 10                 22
3325031 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001273 510 PIEDMONT MS Middle Regular School No Middle 07 08 2021   grade_7 251 11 40 25   17     0   34   205 173                       378 251 11 40 25   17     0   34   205 173                 378
3325032 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001273 510 PIEDMONT MS Middle Regular School No Middle 07 08 2021   grade_8 213 6 36 19   18     0   24   153 163                       316 213 6 36 19   18     0   24   153 163                 316
3325033 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001273 510 PIEDMONT MS Middle Regular School No Middle 07 08 2021   out_of_home_placement 2 0 0 2   0     0   1   3 2                       5 2 0 0 2   0     0   1   3 2                 5
3325089 OK CANADIAN   school 4033480 09-I027   YUKON 403348002723 520 YUKON MS Middle Regular School No Middle 07 08 2021   grade_7 400 32 123 18   15     1   60   334 315                       649 400 32 123 18   15     1   60   334 315                 649
3325090 OK CANADIAN   school 4033480 09-I027   YUKON 403348002723 520 YUKON MS Middle Regular School No Middle 07 08 2021   grade_8 406 18 137 29   18     0   61   331 338                       669 406 18 137 29   18     0   61   331 338                 669
3325101 OK CANADIAN   school 4010650 09-I034   EL RENO 401065002103 510 LESLIE F ROBLYER LEARNING CTR Middle Regular School No Middle 05 06 2021   grade_5 87 13 58 20   0     0   19   103 94                       197 87 13 58 20   0     0   19   103 94                 197
3325102 OK CANADIAN   school 4010650 09-I034   EL RENO 401065002103 510 LESLIE F ROBLYER LEARNING CTR Middle Regular School No Middle 05 06 2021   grade_6 95 8 45 26   0     0   21   117 78                       195 95 8 45 26   0     0   21   117 78                 195
3325181 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001047 505 MUSTANG MS Middle Regular School No Middle 07 08 2021   grade_7 197 4 40 18   4     1   42   151 155                       306 197 4 40 18   4     1   42   151 155                 306
3325182 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001047 505 MUSTANG MS Middle Regular School No Middle 07 08 2021   grade_8 219 9 45 21   3     1   40   150 188                       338 219 9 45 21   3     1   40   150 188                 338
3325183 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001047 505 MUSTANG MS Middle Regular School No Middle 07 08 2021   out_of_home_placement 2 2 1 0   0     0   0   0 5                       5 2 2 1 0   0     0   0   0 5                 5
3325184 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001969 510 MUSTANG NORTH MS Middle Regular School No Middle 07 08 2021   grade_7 160 20 54 11   22     0   32   158 141                       299 160 20 54 11   22     0   32   158 141                 299
3325185 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001969 510 MUSTANG NORTH MS Middle Regular School No Middle 07 08 2021   grade_8 173 25 52 8   36     2   25   158 163                       321 173 25 52 8   36     2   25   158 163                 321
3325186 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100002881 525 MUSTANG CENTRAL MS Middle Regular School No Middle 07 08 2021   grade_7 134 16 38 11   9     0   28   119 117                       236 134 16 38 11   9     0   28   119 117                 236
3325187 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100002881 525 MUSTANG CENTRAL MS Middle Regular School No Middle 07 08 2021   grade_8 145 13 31 16   16     3   35   142 117                       259 145 13 31 16   16     3   35   142 117                 259
3325237 OK CARTER   school 4003180 10-I019   ARDMORE 400318029636 505 ARDMORE MS Middle Regular School No Middle 06 08 2021   grade_6 52 22 29 22   3     0   35   91 72                       163 52 22 29 22   3     0   35   91 72                 163
3325238 OK CARTER   school 4003180 10-I019   ARDMORE 400318029636 505 ARDMORE MS Middle Regular School No Middle 06 08 2021   grade_7 64 35 40 18   4     0   34   92 103                       195 64 35 40 18   4     0   34   92 103                 195
3325239 OK CARTER   school 4003180 10-I019   ARDMORE 400318029636 505 ARDMORE MS Middle Regular School No Middle 06 08 2021   grade_8 75 34 36 17   0     0   31   94 99                       193 75 34 36 17   0     0   31   94 99                 193
3325240 OK CARTER   school 4003180 10-I019   ARDMORE 400318029636 505 ARDMORE MS Middle Regular School No Middle 06 08 2021   out_of_home_placement 2 0 0 0   0     0   0   1 1                       2 2 0 0 0   0     0   0   1 1                 2
3325267 OK CARTER   school 4024240 10-I027   PLAINVIEW 402424001279 505 PLAINVIEW MS Middle Regular School No Middle 06 08 2021   grade_6 67 2 16 16   5     0   11   57 60                       117 67 2 16 16   5     0   11   57 60                 117
3325268 OK CARTER   school 4024240 10-I027   PLAINVIEW 402424001279 505 PLAINVIEW MS Middle Regular School No Middle 06 08 2021   grade_7 65 2 19 8   9     0   10   55 58                       113 65 2 19 8   9     0   10   55 58                 113
3325269 OK CARTER   school 4024240 10-I027   PLAINVIEW 402424001279 505 PLAINVIEW MS Middle Regular School No Middle 06 08 2021   grade_8 79 3 5 9   4     0   16   62 54                       116 79 3 5 9   4     0   16   62 54                 116
3325282 OK CARTER   school 4018090 10-I032   LONE GROVE 401809000869 505 LONE GROVE MS Middle Regular School No Middle 06 08 2021   grade_6 59 1 11 17   0     0   9   40 57                       97 59 1 11 17   0     0   9   40 57                 97
3325283 OK CARTER   school 4018090 10-I032   LONE GROVE 401809000869 505 LONE GROVE MS Middle Regular School No Middle 06 08 2021   grade_7 64 2 11 16   0     0   7   56 44                       100 64 2 11 16   0     0   7   56 44                 100
3325284 OK CARTER   school 4018090 10-I032   LONE GROVE 401809000869 505 LONE GROVE MS Middle Regular School No Middle 06 08 2021   grade_8 68 3 8 21   1     0   8   54 55                       109 68 3 8 21   1     0   8   54 55                 109
3325310 OK CARTER   school 4014130 10-I055   HEALDTON 401413001863 505 HEALDTON MS Middle Regular School No Middle 06 08 2021   grade_6 28 0 6 2   0     0   7   19 24                       43 28 0 6 2   0     0   7   19 24                 43
3325311 OK CARTER   school 4014130 10-I055   HEALDTON 401413001863 505 HEALDTON MS Middle Regular School No Middle 06 08 2021   grade_7 21 0 3 4   0     0   6   18 16                       34 21 0 3 4   0     0   6   18 16                 34
3325312 OK CARTER   school 4014130 10-I055   HEALDTON 401413001863 505 HEALDTON MS Middle Regular School No Middle 06 08 2021   grade_8 30 0 5 2   1     0   4   18 24                       42 30 0 5 2   1     0   4   18 24                 42
3325338 OK CARTER   school 4009910 10-I077   DICKSON 400991002667 510 DICKSON MS Middle Regular School No Middle 06 08 2021   grade_6 70 0 7 16   0     0   14   59 48                       107 70 0 7 16   0     0   14   59 48                 107
3325339 OK CARTER   school 4009910 10-I077   DICKSON 400991002667 510 DICKSON MS Middle Regular School No Middle 06 08 2021   grade_7 59 0 3 17   0     0   13   50 42                       92 59 0 3 17   0     0   13   50 42                 92
3325340 OK CARTER   school 4009910 10-I077   DICKSON 400991002667 510 DICKSON MS Middle Regular School No Middle 06 08 2021   grade_8 40 1 15 17   1     0   17   52 39                       91 40 1 15 17   1     0   17   52 39                 91
3325446 OK CHEROKEE   school 4015240 11-I016   HULBERT 401524000101 505 HULBERT MS Middle Regular School No Middle 06 08 2021   grade_6 11 0 8 16   0     0   2   22 15                       37 11 0 8 16   0     0   2   22 15                 37
3325447 OK CHEROKEE   school 4015240 11-I016   HULBERT 401524000101 505 HULBERT MS Middle Regular School No Middle 06 08 2021   grade_7 14 0 2 22   0     0   3   20 21                       41 14 0 2 22   0     0   3   20 21                 41
3325448 OK CHEROKEE   school 4015240 11-I016   HULBERT 401524000101 505 HULBERT MS Middle Regular School No Middle 06 08 2021   grade_8 6 0 6 27   0     0   4   24 19                       43 6 0 6 27   0     0   4   24 19                 43
3325476 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2021   grade_6 55 0 49 69   6     0   42   117 104                       221 55 0 49 69   6     0   42   117 104                 221
3325477 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2021   grade_7 38 3 48 98   2     0   47   101 135                       236 38 3 48 98   2     0   47   101 135                 236
3325478 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2021   grade_8 57 2 55 75   2     0   40   115 116                       231 57 2 55 75   2     0   40   115 116                 231
3325479 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2021   out_of_home_placement 0 0 0 3   0     0   0   2 1                       3 0 0 0 3   0     0   0   2 1                 3
3325503 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504002369 515 BOSWELL MS Middle Regular School No Middle 07 08 2021   grade_7 9 4 3 6   0     0   0   14 8                       22 9 4 3 6   0     0   0   14 8                 22
3325504 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504002369 515 BOSWELL MS Middle Regular School No Middle 07 08 2021   grade_8 6 0 3 7   0     0   1   11 6                       17 6 0 3 7   0     0   1   11 6                 17
3325544 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002670 510 HUGO MS Middle Regular School No Middle 06 08 2021   grade_6 20 17 4 25   0     0   9   44 31                       75 20 17 4 25   0     0   9   44 31                 75
3325545 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002670 510 HUGO MS Middle Regular School No Middle 06 08 2021   grade_7 24 27 2 18   0     0   17   47 41                       88 24 27 2 18   0     0   17   47 41                 88
3325546 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002670 510 HUGO MS Middle Regular School No Middle 06 08 2021   grade_8 22 17 8 24   1     0   14   34 52                       86 22 17 8 24   1     0   14   34 52                 86
3325559 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486002779 505 BOISE CITY JHS Middle Regular School No Middle 07 08 2021   grade_7 12 0 9 0   0     0   0   13 8                       21 12 0 9 0   0     0   0   13 8                 21
3325560 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486002779 505 BOISE CITY JHS Middle Regular School No Middle 07 08 2021   grade_8 12 0 12 0   0     0   1   11 14                       25 12 0 12 0   0     0   1   11 14                 25
3325980 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001073 500 IRVING MS Middle Regular School No Middle 06 08 2021   grade_6 118 19 49 12   6     0   49   129 124                       253 118 19 49 12   6     0   49   129 124                 253
3325981 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001073 500 IRVING MS Middle Regular School No Middle 06 08 2021   grade_7 143 20 44 7   7     0   38   140 119                       259 143 20 44 7   7     0   38   140 119                 259
3325982 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001073 500 IRVING MS Middle Regular School No Middle 06 08 2021   grade_8 135 34 30 17   13     1   50   141 139                       280 135 34 30 17   13     1   50   141 139                 280
3325983 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002117 501 ALCOTT MS Middle Regular School No Middle 06 08 2021   grade_6 127 12 42 9   4     0   32   125 101                       226 127 12 42 9   4     0   32   125 101                 226
3325984 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002117 501 ALCOTT MS Middle Regular School No Middle 06 08 2021   grade_7 112 9 40 12   1     0   32   107 99                       206 112 9 40 12   1     0   32   107 99                 206
3325985 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002117 501 ALCOTT MS Middle Regular School No Middle 06 08 2021   grade_8 111 21 54 11   2     0   34   121 112                       233 111 21 54 11   2     0   34   121 112                 233
3325986 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2021   grade_6 117 9 30 12   3     0   26   88 109                       197 117 9 30 12   3     0   26   88 109                 197
3325987 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2021   grade_7 113 11 24 11   4     0   27   100 90                       190 113 11 24 11   4     0   27   100 90                 190
3325988 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2021   grade_8 127 16 28 14   4     2   29   123 97                       220 127 16 28 14   4     2   29   123 97                 220
3325989 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2021   grade_6 164 21 52 11   19     0   44   160 151                       311 164 21 52 11   19     0   44   160 151                 311
3325990 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2021   grade_7 176 14 60 12   27     0   44   165 168                       333 176 14 60 12   27     0   44   165 168                 333
3325991 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2021   grade_8 236 21 43 9   17     0   37   173 190                       363 236 21 43 9   17     0   37   173 190                 363
3326013 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163002370 510 CURTIS INGE MS Middle Regular School No Middle 06 08 2021   grade_6 150 3 26 27   1     1   12   107 113                       220 150 3 26 27   1     1   12   107 113                 220

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