Data source: Big Local News · About: Big Local

11,843 rows where state = "OK" and year = 2019 sorted by school_state_type descending

View and edit SQL

year

  • 2019 · 11,843
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
2306371 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2019   grade_5 4 0 13 53   0     0   1   38 33                       71 4 0 13 53   0     0   1   38 33                 71
2306372 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2019   grade_6 12 0 19 31   0     0   0   34 28                       62 12 0 19 31   0     0   0   34 28                 62
2306373 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2019   grade_7 7 0 14 35   0     0   0   28 28                       56 7 0 14 35   0     0   0   28 28                 56
2306374 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2019   grade_8 11 0 14 45   0     0   2   46 26                       72 11 0 14 45   0     0   2   46 26                 72
2306385 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2019   grade_5 0 0 0 9   0     0   0   7 2                       9 0 0 0 9   0     0   0   7 2                 9
2306386 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2019   grade_6 5 0 0 10   0     0   0   7 8                       15 5 0 0 10   0     0   0   7 8                 15
2306387 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2019   grade_7 0 0 0 1   0     0   0   1 0                       1 0 0 0 1   0     0   0   1 0                 1
2306388 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2019   grade_8 1 0 1 8   0     0   0   3 7                       10 1 0 1 8   0     0   0   3 7                 10
2306416 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741002745 510 CHEROKEE MS Middle Regular School No Middle 06 08 2019   grade_6 21 1 4 0   0     0   2   12 16                       28 21 1 4 0   0     0   2   12 16                 28
2306417 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741002745 510 CHEROKEE MS Middle Regular School No Middle 06 08 2019   grade_7 15 1 4 0   0     0   2   8 14                       22 15 1 4 0   0     0   2   8 14                 22
2306418 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741002745 510 CHEROKEE MS Middle Regular School No Middle 06 08 2019   grade_8 29 0 4 1   0     0   1   18 17                       35 29 0 4 1   0     0   1   18 17                 35
2306606 OK BECKHAM   school 4027060 05-I031   SAYRE 402706002268 505 SAYRE MS Middle Regular School No Middle 06 08 2019   grade_6 38 0 5 1   1     0   4   20 29                       49 38 0 5 1   1     0   4   20 29                 49
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
2306608 OK BECKHAM   school 4027060 05-I031   SAYRE 402706002268 505 SAYRE MS Middle Regular School No Middle 06 08 2019   grade_8 34 0 8 1   0     0   3   27 19                       46 34 0 8 1   0     0   3   27 19                 46
2306649 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2019   grade_6 27 3 13 8   0     0   11   27 35                       62 27 3 13 8   0     0   11   27 35                 62
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
2306651 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2019   grade_8 27 0 10 9   0     0   3   22 27                       49 27 0 10 9   0     0   3   22 27                 49
2306663 OK BLAINE   school 4012570 06-I080   GEARY 401257000588 500 GEARY MS Middle Regular School No Middle 06 08 2019   grade_6 11 1 5 13   0     0   1   19 12                       31 11 1 5 13   0     0   1   19 12                 31
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
2306665 OK BLAINE   school 4012570 06-I080   GEARY 401257000588 500 GEARY MS Middle Regular School No Middle 06 08 2019   grade_8 8 1 5 10   0     0   0   11 13                       24 8 1 5 10   0     0   0   11 13                 24
2306691 OK BRYAN   school 4027640 07-I001   SILO 402764001471 515 SILO MS Middle Regular School No Middle 06 08 2019   grade_6 48 0 5 17   0     0   4   37 37                       74 48 0 5 17   0     0   4   37 37                 74
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
2306693 OK BRYAN   school 4027640 07-I001   SILO 402764001471 515 SILO MS Middle Regular School No Middle 06 08 2019   grade_8 59 1 0 16   0     0   6   45 37                       82 59 1 0 16   0     0   6   45 37                 82
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
2306735 OK BRYAN   school 4008220 07-I004   COLBERT 400822000343 505 COLBERT MS Middle Regular School No Middle 07 08 2019   grade_8 31 1 7 13   0     0   1   28 25                       53 31 1 7 13   0     0   1   28 25                 53
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
2306796 OK BRYAN   school 4010350 07-I072   DURANT 401035000457 500 DURANT MS Middle Regular School No Middle 07 08 2019   grade_8 136 4 30 51   2     1   18   115 127                       242 136 4 30 51   2     1   18   115 127                 242
2306810 OK CADDO   school 4000032 08-I011   HYDRO-EAKLY 400003202357 505 HYDRO-EAKLY MS Middle Regular School No Middle 06 08 2019   grade_6 24 0 8 3   0     0   0   15 20                       35 24 0 8 3   0     0   0   15 20                 35
2306811 OK CADDO   school 4000032 08-I011   HYDRO-EAKLY 400003202357 505 HYDRO-EAKLY MS Middle Regular School No Middle 06 08 2019   grade_7 15 1 8 0   0     0   1   15 10                       25 15 1 8 0   0     0   1   15 10                 25
2306812 OK CADDO   school 4000032 08-I011   HYDRO-EAKLY 400003202357 505 HYDRO-EAKLY MS Middle Regular School No Middle 06 08 2019   grade_8 22 2 4 0   0     0   2   15 15                       30 22 2 4 0   0     0   2   15 15                 30
2306839 OK CADDO   school 4003000 08-I020   ANADARKO 400300002101 510 ANADARKO MS Middle Regular School No Middle 06 08 2019   grade_6 15 6 14 76   3     0   0   56 58                       114 15 6 14 76   3     0   0   56 58                 114
2306840 OK CADDO   school 4003000 08-I020   ANADARKO 400300002101 510 ANADARKO MS Middle Regular School No Middle 06 08 2019   grade_7 18 3 20 75   1     0   0   54 63                       117 18 3 20 75   1     0   0   54 63                 117
2306841 OK CADDO   school 4003000 08-I020   ANADARKO 400300002101 510 ANADARKO MS Middle Regular School No Middle 06 08 2019   grade_8 17 3 23 59   0     0   0   47 55                       102 17 3 23 59   0     0   0   47 55                 102
2306853 OK CADDO   school 4006630 08-I033   CARNEGIE 400663002676 510 CARNEGIE MS Middle Regular School No Middle 06 08 2019   grade_6 9 0 2 15   0     0   8   19 15                       34 9 0 2 15   0     0   8   19 15                 34
2306854 OK CADDO   school 4006630 08-I033   CARNEGIE 400663002676 510 CARNEGIE MS Middle Regular School No Middle 06 08 2019   grade_7 13 0 4 13   0     0   5   17 18                       35 13 0 4 13   0     0   5   17 18                 35
2306855 OK CADDO   school 4006630 08-I033   CARNEGIE 400663002676 510 CARNEGIE MS Middle Regular School No Middle 06 08 2019   grade_8 20 0 7 14   1     0   3   31 14                       45 20 0 7 14   1     0   3   31 14                 45
2306868 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2019   grade_6 12 0 4 8   0     0   3   17 10                       27 12 0 4 8   0     0   3   17 10                 27
2306869 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2019   grade_7 17 0 3 13   0     0   3   16 20                       36 17 0 3 13   0     0   3   16 20                 36
2306870 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2019   grade_8 17 0 4 11   0     0   9   21 20                       41 17 0 4 11   0     0   9   21 20                 41
2306871 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2019   out_of_home_placement 1 0 0 0   0     0   0   0 1                       1 1 0 0 0   0     0   0   0 1                 1
2306940 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360201597 505 FORT COBB-BROXTON MS Middle Regular School No Middle 06 08 2019   grade_6 13 1 2 6   0     0   4   11 15                       26 13 1 2 6   0     0   4   11 15                 26
2306941 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360201597 505 FORT COBB-BROXTON MS Middle Regular School No Middle 06 08 2019   grade_7 17 0 2 4   0     0   2   14 11                       25 17 0 2 4   0     0   2   14 11                 25
2306942 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360201597 505 FORT COBB-BROXTON MS Middle Regular School No Middle 06 08 2019   grade_8 12 0 0 4   0     0   4   11 9                       20 12 0 0 4   0     0   4   11 9                 20
2307024 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001273 510 PIEDMONT MS Middle Regular School No Middle 07 08 2019   grade_7 221 13 32 25   10     1   20   158 164                       322 221 13 32 25   10     1   20   158 164                 322
2307025 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397001273 510 PIEDMONT MS Middle Regular School No Middle 07 08 2019   grade_8 206 13 20 34   16     1   12   149 153                       302 206 13 20 34   16     1   12   149 153                 302
2307074 OK CANADIAN   school 4033480 09-I027   YUKON 403348002723 520 YUKON MS Middle Regular School No Middle 06 08 2019   grade_6 460 20 119 30   16     1   52   354 344                       698 460 20 119 30   16     1   52   354 344                 698
2307075 OK CANADIAN   school 4033480 09-I027   YUKON 403348002723 520 YUKON MS Middle Regular School No Middle 06 08 2019   grade_7 440 24 101 28   19     1   44   338 319                       657 440 24 101 28   19     1   44   338 319                 657
2307076 OK CANADIAN   school 4033480 09-I027   YUKON 403348002723 520 YUKON MS Middle Regular School No Middle 06 08 2019   grade_8 464 23 95 41   18     0   29   346 324                       670 464 23 95 41   18     0   29   346 324                 670
2307087 OK CANADIAN   school 4010650 09-I034   EL RENO 401065002103 510 LESLIE F ROBLYER LEARNING CTR Middle Regular School No Middle 05 06 2019   grade_5 100 6 63 24   0     0   16   111 98                       209 100 6 63 24   0     0   16   111 98                 209
2307088 OK CANADIAN   school 4010650 09-I034   EL RENO 401065002103 510 LESLIE F ROBLYER LEARNING CTR Middle Regular School No Middle 05 06 2019   grade_6 105 9 49 23   0     0   18   105 99                       204 105 9 49 23   0     0   18   105 99                 204
2307166 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001047 505 MUSTANG MS Middle Regular School No Middle 07 08 2019   grade_7 276 18 59 23   6     1   29   209 203                       412 276 18 59 23   6     1   29   209 203                 412
2307167 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001047 505 MUSTANG MS Middle Regular School No Middle 07 08 2019   grade_8 254 10 61 21   8     1   22   211 166                       377 254 10 61 21   8     1   22   211 166                 377
2307168 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001969 510 MUSTANG NORTH MS Middle Regular School No Middle 07 08 2019   grade_7 304 30 66 22   30     1   47   248 252                       500 304 30 66 22   30     1   47   248 252                 500
2307169 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100001969 510 MUSTANG NORTH MS Middle Regular School No Middle 07 08 2019   grade_8 275 21 73 27   34     4   47   251 230                       481 275 21 73 27   34     4   47   251 230                 481
2307217 OK CARTER   school 4003180 10-I019   ARDMORE 400318029636 505 ARDMORE MS Middle Regular School No Middle 06 08 2019   grade_6 101 28 33 18   1     0   30   109 102                       211 101 28 33 18   1     0   30   109 102                 211
2307218 OK CARTER   school 4003180 10-I019   ARDMORE 400318029636 505 ARDMORE MS Middle Regular School No Middle 06 08 2019   grade_7 75 29 44 20   0     0   22   91 99                       190 75 29 44 20   0     0   22   91 99                 190
2307219 OK CARTER   school 4003180 10-I019   ARDMORE 400318029636 505 ARDMORE MS Middle Regular School No Middle 06 08 2019   grade_8 93 31 36 10   6     0   17   87 106                       193 93 31 36 10   6     0   17   87 106                 193
2307245 OK CARTER   school 4024240 10-I027   PLAINVIEW 402424001279 505 PLAINVIEW MS Middle Regular School No Middle 06 08 2019   grade_6 75 2 8 15   2     0   13   58 57                       115 75 2 8 15   2     0   13   58 57                 115
2307246 OK CARTER   school 4024240 10-I027   PLAINVIEW 402424001279 505 PLAINVIEW MS Middle Regular School No Middle 06 08 2019   grade_7 65 0 13 11   7     0   17   59 54                       113 65 0 13 11   7     0   17   59 54                 113
2307247 OK CARTER   school 4024240 10-I027   PLAINVIEW 402424001279 505 PLAINVIEW MS Middle Regular School No Middle 06 08 2019   grade_8 78 3 13 9   7     0   18   69 59                       128 78 3 13 9   7     0   18   69 59                 128
2307260 OK CARTER   school 4018090 10-I032   LONE GROVE 401809000869 505 LONE GROVE MS Middle Regular School No Middle 06 08 2019   grade_6 73 1 12 29   2     0   10   68 59                       127 73 1 12 29   2     0   10   68 59                 127
2307261 OK CARTER   school 4018090 10-I032   LONE GROVE 401809000869 505 LONE GROVE MS Middle Regular School No Middle 06 08 2019   grade_7 75 3 11 18   0     0   13   56 64                       120 75 3 11 18   0     0   13   56 64                 120
2307262 OK CARTER   school 4018090 10-I032   LONE GROVE 401809000869 505 LONE GROVE MS Middle Regular School No Middle 06 08 2019   grade_8 63 5 8 22   0     0   12   59 51                       110 63 5 8 22   0     0   12   59 51                 110
2307288 OK CARTER   school 4014130 10-I055   HEALDTON 401413001863 505 HEALDTON MS Middle Regular School No Middle 06 08 2019   grade_6 31 0 4 2   1     0   4   21 21                       42 31 0 4 2   1     0   4   21 21                 42
2307289 OK CARTER   school 4014130 10-I055   HEALDTON 401413001863 505 HEALDTON MS Middle Regular School No Middle 06 08 2019   grade_7 25 0 2 2   0     0   7   21 15                       36 25 0 2 2   0     0   7   21 15                 36
2307290 OK CARTER   school 4014130 10-I055   HEALDTON 401413001863 505 HEALDTON MS Middle Regular School No Middle 06 08 2019   grade_8 16 0 4 0   1     0   6   17 10                       27 16 0 4 0   1     0   6   17 10                 27
2307316 OK CARTER   school 4009910 10-I077   DICKSON 400991002667 510 DICKSON MS Middle Regular School No Middle 06 08 2019   grade_6 48 2 14 18   1     0   25   58 50                       108 48 2 14 18   1     0   25   58 50                 108
2307317 OK CARTER   school 4009910 10-I077   DICKSON 400991002667 510 DICKSON MS Middle Regular School No Middle 06 08 2019   grade_7 54 0 5 18   1     0   16   47 47                       94 54 0 5 18   1     0   16   47 47                 94
2307318 OK CARTER   school 4009910 10-I077   DICKSON 400991002667 510 DICKSON MS Middle Regular School No Middle 06 08 2019   grade_8 54 2 4 18   0     0   3   41 40                       81 54 2 4 18   0     0   3   41 40                 81
2307425 OK CHEROKEE   school 4015240 11-I016   HULBERT 401524000101 505 HULBERT MS Middle Regular School No Middle 06 08 2019   grade_6 8 0 5 25   0     0   4   22 20                       42 8 0 5 25   0     0   4   22 20                 42
2307426 OK CHEROKEE   school 4015240 11-I016   HULBERT 401524000101 505 HULBERT MS Middle Regular School No Middle 06 08 2019   grade_7 8 0 4 27   0     0   1   21 19                       40 8 0 4 27   0     0   1   21 19                 40
2307427 OK CHEROKEE   school 4015240 11-I016   HULBERT 401524000101 505 HULBERT MS Middle Regular School No Middle 06 08 2019   grade_8 12 0 2 24   0     0   0   15 23                       38 12 0 2 24   0     0   0   15 23                 38
2307452 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2019   grade_6 61 2 52 70   2     0   43   114 116                       230 61 2 52 70   2     0   43   114 116                 230
2307453 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2019   grade_7 57 0 44 90   0     0   34   109 116                       225 57 0 44 90   0     0   34   109 116                 225
2307454 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2019   grade_8 54 1 37 106   2     0   25   106 119                       225 54 1 37 106   2     0   25   106 119                 225
2307455 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2019   out_of_home_placement 1 0 0 1   0     0   1   2 1                       3 1 0 0 1   0     0   1   2 1                 3
2307489 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504002369 515 BOSWELL MS Middle Regular School No Middle 07 08 2019   grade_7 9 1 1 9   0     0   3   16 7                       23 9 1 1 9   0     0   3   16 7                 23
2307490 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504002369 515 BOSWELL MS Middle Regular School No Middle 07 08 2019   grade_8 12 3 2 10   0     0   6   21 12                       33 12 3 2 10   0     0   6   21 12                 33
2307530 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002670 510 HUGO MS Middle Regular School No Middle 06 08 2019   grade_6 30 22 8 22   1     0   10   39 54                       93 30 22 8 22   1     0   10   39 54                 93
2307531 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002670 510 HUGO MS Middle Regular School No Middle 06 08 2019   grade_7 45 22 4 14   1     0   5   49 42                       91 45 22 4 14   1     0   5   49 42                 91
2307532 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002670 510 HUGO MS Middle Regular School No Middle 06 08 2019   grade_8 27 30 4 24   1     0   3   53 36                       89 27 30 4 24   1     0   3   53 36                 89
2307545 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486002779 505 BOISE CITY JHS Middle Regular School No Middle 07 08 2019   grade_7 8 0 7 0   0     0   0   10 5                       15 8 0 7 0   0     0   0   10 5                 15
2307546 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486002779 505 BOISE CITY JHS Middle Regular School No Middle 07 08 2019   grade_8 9 0 10 0   0     0   0   13 6                       19 9 0 10 0   0     0   0   13 6                 19
2307972 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001073 500 IRVING MS Middle Regular School No Middle 06 08 2019   grade_6 168 33 27 14   15     1   53   158 153                       311 168 33 27 14   15     1   53   158 153                 311
2307973 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001073 500 IRVING MS Middle Regular School No Middle 06 08 2019   grade_7 120 38 35 8   7     2   42   141 111                       252 120 38 35 8   7     2   42   141 111                 252
2307974 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001073 500 IRVING MS Middle Regular School No Middle 06 08 2019   grade_8 109 23 28 17   4     0   41   112 110                       222 109 23 28 17   4     0   41   112 110                 222
2307975 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002117 501 ALCOTT MS Middle Regular School No Middle 06 08 2019   grade_6 121 17 53 8   6     0   38   128 115                       243 121 17 53 8   6     0   38   128 115                 243
2307976 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002117 501 ALCOTT MS Middle Regular School No Middle 06 08 2019   grade_7 137 6 59 10   2     0   32   122 124                       246 137 6 59 10   2     0   32   122 124                 246
2307977 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002117 501 ALCOTT MS Middle Regular School No Middle 06 08 2019   grade_8 130 17 43 9   4     0   37   147 93                       240 130 17 43 9   4     0   37   147 93                 240
2307978 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2019   grade_6 152 18 29 16   3     1   39   141 117                       258 152 18 29 16   3     1   39   141 117                 258
2307979 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2019   grade_7 160 12 33 8   6     0   30   150 99                       249 160 12 33 8   6     0   30   150 99                 249
2307980 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2019   grade_8 167 10 24 18   6     1   27   131 122                       253 167 10 24 18   6     1   27   131 122                 253
2307981 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2019   grade_6 256 24 49 7   17     0   44   208 189                       397 256 24 49 7   17     0   44   208 189                 397
2307982 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2019   grade_7 240 11 57 14   15     0   63   218 182                       400 240 11 57 14   15     0   63   218 182                 400
2307983 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2019   grade_8 222 9 62 14   12     0   42   209 152                       361 222 9 62 14   12     0   42   209 152                 361
2308006 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163002370 510 CURTIS INGE MS Middle Regular School No Middle 06 08 2019   grade_6 127 9 15 33   2     0   10   101 95                       196 127 9 15 33   2     0   10   101 95                 196
2308007 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163002370 510 CURTIS INGE MS Middle Regular School No Middle 06 08 2019   grade_7 155 6 17 35   0     0   7   114 106                       220 155 6 17 35   0     0   7   114 106                 220
2308008 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163002370 510 CURTIS INGE MS Middle Regular School No Middle 06 08 2019   grade_8 139 2 7 30   0     0   6   96 88                       184 139 2 7 30   0     0   6   96 88                 184
2308020 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758002678 510 LEXINGTON MS Middle Regular School No Middle 06 08 2019   grade_6 58 0 13 5   0     0   16   49 43                       92 58 0 13 5   0     0   16   49 43                 92
2308021 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758002678 510 LEXINGTON MS Middle Regular School No Middle 06 08 2019   grade_7 60 0 4 9   0     0   10   42 41                       83 60 0 4 9   0     0   10   42 41                 83

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