enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
475603 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 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
475646 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
475840 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
475883 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 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
475925 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
475967 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
476035 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 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
476079 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 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 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
476179 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
476262 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 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
476392 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 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
476446 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
476474 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 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
476517 476517 OK CARTER   school 4014130 10-I055   HEALDTON 401413001863 505 HEALDTON MS Middle Regular School No Middle 06 08 2017   grade_7 16 0 5 7   0     0   4   16 16                       32 16 0 5 7   0     0   4   16 16                 32
476545 476545 OK CARTER   school 4009910 10-I077   DICKSON 400991002667 510 DICKSON MS Middle Regular School No Middle 06 08 2017   grade_7 67 2 5 26   0     0   3   56 47                       103 67 2 5 26   0     0   3   56 47                 103
476681 476681 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2017   grade_7 53 5 35 100   3     0   25   107 114                       221 53 5 35 100   3     0   25   107 114                 221
476717 476717 OK CHOCTAW   school 4005040 12-I001   BOSWELL 400504002369 515 BOSWELL MS Middle Regular School No Middle 07 08 2017   grade_7 9 1 4 8   0     0   0   8 14                       22 9 1 4 8   0     0   0   8 14                 22
476759 476759 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002670 510 HUGO MS Middle Regular School No Middle 06 08 2017   grade_7 24 23 4 20   0     0   6   36 41                       77 24 23 4 20   0     0   6   36 41                 77
476774 476774 OK CIMARRON   school 4004860 13-I002   BOISE CITY 400486002779 505 BOISE CITY JHS Middle Regular School No Middle 07 08 2017   grade_7 6 0 7 0   0     0   0   5 8                       13 6 0 7 0   0     0   0   5 8                 13
477215 477215 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001073 500 IRVING MS Middle Regular School No Middle 06 08 2017   grade_7 155 27 27 16   9     1   47   152 130                       282 155 27 27 16   9     1   47   152 130                 282
477218 477218 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002117 501 ALCOTT MS Middle Regular School No Middle 06 08 2017   grade_7 120 12 51 7   3     0   32   123 102                       225 120 12 51 7   3     0   32   123 102                 225
477221 477221 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2017   grade_7 165 17 22 11   4     0   24   119 124                       243 165 17 22 11   4     0   24   119 124                 243
477224 477224 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2017   grade_7 235 18 47 18   23     0   44   185 200                       385 235 18 47 18   23     0   44   185 200                 385
477250 477250 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163002370 510 CURTIS INGE MS Middle Regular School No Middle 06 08 2017   grade_7 153 3 10 38   4     1   6   113 102                       215 153 3 10 38   4     1   6   113 102                 215
477264 477264 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758002678 510 LEXINGTON MS Middle Regular School No Middle 06 08 2017   grade_7 57 0 10 11   1     0   3   44 38                       82 57 0 10 11   1     0   3   44 38                 82
477278 477278 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000103 505 LITTLE AXE MS Middle Regular School No Middle 06 08 2017   grade_7 58 0 7 15   0     0   12   55 37                       92 58 0 7 15   0     0   12   55 37                 92
477302 477302 OK COAL   school 4008130 15-I001   COALGATE 400813001958 505 WALLACE BYRD MS Middle Regular School No Middle 07 08 2017   grade_7 25 0 6 16   0     0   1   26 22                       48 25 0 6 16   0     0   1   26 22                 48
477347 477347 OK COMANCHE   school 4006120 16-I001   CACHE 400612029646 505 CACHE MS Middle Regular School No Middle 07 08 2017   grade_7 80 14 22 28   3     3   7   88 69                       157 80 14 22 28   3     3   7   88 69                 157
477394 477394 OK COMANCHE   school 4012630 16-I004   GERONIMO 401263002732 505 GERONIMO MS Middle Regular School No Middle 07 08 2017   grade_7 9 2 6 3   1     0   2   13 10                       23 9 2 6 3   1     0   2   13 10                 23
477521 477521 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002364 530 MACARTHUR MS Middle Regular School No Middle 06 08 2017   grade_7 115 43 48 17   8     2   28   135 126                       261 115 43 48 17   8     2   28   135 126                 261
477524 477524 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002393 535 CENTRAL MS Middle Regular School No Middle 06 08 2017   grade_7 89 58 59 17   3     2   23   131 120                       251 89 58 59 17   3     2   23   131 120                 251
477528 477528 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002404 540 TOMLINSON MS Middle Regular School No Middle 06 08 2017   grade_7 65 82 50 9   4     0   21   123 108                       231 65 82 50 9   4     0   21   123 108                 231
477531 477531 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002679 545 EISENHOWER MS Middle Regular School No Middle 06 08 2017   grade_7 93 100 52 24   9     1   23   157 145                       302 93 100 52 24   9     1   23   157 145                 302
477569 477569 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2017   grade_7 115 5 29 15   1     1   17   89 94                       183 115 5 29 15   1     1   17   89 94                 183
477600 477600 OK COTTON   school 4031470 17-I001   WALTERS 403147029649 505 WALTERS MS Middle Regular School No Middle 06 08 2017   grade_7 25 0 3 5   0     0   11   23 21                       44 25 0 3 5   0     0   11   23 21                 44
477654 477654 OK CRAIG   school 4016380 18-I006   KETCHUM 401638002359 505 KETCHUM MS Middle Regular School No Middle 06 08 2017   grade_7 17 0 0 19   0     0   0   19 17                       36 17 0 0 19   0     0   0   19 17                 36
477668 477668 OK CRAIG   school 4032190 18-I017   WELCH 403219001782 515 WELCH MS Middle Regular School No Middle 06 08 2017   grade_7 12 0 1 5   0     0   0   7 11                       18 12 0 1 5   0     0   0   7 11                 18
477683 477683 OK CRAIG   school 4004830 18-I020   BLUEJACKET 400483002082 505 BLUEJACKET MS Middle Regular School No Middle 06 08 2017   grade_7 5 0 0 10   0     0   3   9 9                       18 5 0 0 10   0     0   3   9 9                 18
477697 477697 OK CRAIG   school 4031290 18-I065   VINITA 403129001732 510 EWING HALSELL MS Middle Regular School No Middle 06 08 2017   grade_7 48 4 2 43   1     0   16   61 53                       114 48 4 2 43   1     0   16   61 53                 114
477752 477752 OK CREEK   school 4005460 19-I002   BRISTOW 400546002083 505 BRISTOW MS Middle Regular School No Middle 06 08 2017   grade_7 70 9 3 36   0     0   0   62 56                       118 70 9 3 36   0     0   0   62 56                 118
477768 477768 OK CREEK   school 4018840 19-I003   MANNFORD 401884000895 500 MANNFORD MS Middle Regular School No Middle 06 08 2017   grade_7 82 1 2 18   0     0   8   52 59                       111 82 1 2 18   0     0   8   52 59                 111
477810 477810 OK CREEK   school 4016500 19-I018   KIEFER 401650002371 505 RONGEY MS Middle Regular School No Middle 07 08 2017   grade_7 31 1 9 18   0     0   5   35 29                       64 31 1 9 18   0     0   5   35 29                 64
477854 477854 OK CREEK   school 4016170 19-I031   KELLYVILLE 401617000154 505 KELLYVILLE MS Middle Regular School No Middle 07 08 2017   grade_7 46 0 1 17   0     0   16   44 36                       80 46 0 1 17   0     0   16   44 36                 80
477889 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
477904 477904 OK CREEK   school 4010200 19-I039   DRUMRIGHT 401020002709 505 VIRGIL COOPER MS Middle Regular School No Middle 07 08 2017   grade_7 21 1 2 2   0     0   1   16 11                       27 21 1 2 2   0     0   1   16 11                 27
477947 477947 OK CUSTER   school 4032070 20-I026   WEATHERFORD 403207029848 510 WEATHERFORD MS Middle Regular School No Middle 06 08 2017   grade_7 88 1 27 13   2     0   22   77 76                       153 88 1 27 13   2     0   22   77 76                 153
477962 477962 OK CUSTER   school 4008070 20-I099   CLINTON 400807000339 505 CLINTON MS Middle Regular School No Middle 07 08 2017   grade_7 53 5 85 15   2     0   9   82 87                       169 53 5 85 15   2     0   9   82 87                 169
478015 478015 OK DELAWARE   school 4015690 21-I001   JAY 401569000737 505 JAY MS Middle Regular School No Middle 06 08 2017   grade_7 41 0 4 49   4     0   16   65 49                       114 41 0 4 49   4     0   16   65 49                 114
478031 478031 OK DELAWARE   school 4013530 21-I002   GROVE 401353000627 505 GROVE MS Middle Regular School No Middle 07 08 2017   grade_7 101 3 9 62   0     2   1   96 82                       178 101 3 9 62   0     2   1   96 82                 178
478046 478046 OK DELAWARE   school 4015990 21-I003   KANSAS 401599002269 505 KANSAS MS Middle Regular School No Middle 06 08 2017   grade_7 24 1 0 28   0     0   2   25 30                       55 24 1 0 28   0     0   2   25 30                 55
478210 478210 OK GARFIELD   school 4021780 24-I042   CHISHOLM 402178002105 505 CHISHOLM MS Middle Regular School No Middle 06 08 2017   grade_7 68 3 6 0   2     0   0   38 41                       79 68 3 6 0   2     0   0   38 41                 79
478325 478325 OK GARFIELD   school 4010920 24-I057   ENID 401092002700 505 EMERSON MS Middle Regular School No Middle 06 08 2017   grade_7 76 3 50 1   2     9   13   83 71                       154 76 3 50 1   2     9   13   83 71                 154
478329 478329 OK GARFIELD   school 4010920 24-I057   ENID 401092002686 510 LONGFELLOW MS Middle Regular School No Middle 06 08 2017   grade_7 46 11 77 2   1     37   13   94 93                       187 46 11 77 2   1     37   13   94 93                 187
478332 478332 OK GARFIELD   school 4010920 24-I057   ENID 401092000510 515 DEWITT WALLER MS Middle Regular School No Middle 06 08 2017   grade_7 147 9 29 8   8     11   20   124 108                       232 147 9 29 8   8     11   20   124 108                 232
478385 478385 OK GARVIN   school 4028980 25-I002   STRATFORD 402898002677 505 STRATFORD MS Middle Regular School No Middle 06 08 2017   grade_7 32 0 1 13   0     0   1   17 30                       47 32 0 1 13   0     0   1   17 30                 47
478429 478429 OK GARVIN   school 4017850 25-I009   LINDSAY 401785017850 505 LINDSAY MS Middle Regular School No Middle 06 08 2017   grade_7 61 0 9 17   1     0   2   48 42                       90 61 0 9 17   1     0   2   48 42                 90
478458 478458 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2017   grade_7 30 1 1 11   1     0   4   24 24                       48 30 1 1 11   1     0   4   24 24                 48
478519 478519 OK GRADY   school 4007560 26-I001   CHICKASHA 400756002342 510 CHICKASHA MS Middle Regular School No Middle 07 08 2017   grade_7 85 20 22 18   1     0   9   77 78                       155 85 20 22 18   1     0   9   77 78                 155
478536 478536 OK GRADY   school 4020100 26-I002   MINCO 402010001668 505 MINCO MS Middle Regular School No Middle 06 08 2017   grade_7 38 0 4 0   0     0   3   22 23                       45 38 0 4 0   0     0   3   22 23                 45
478550 478550 OK GRADY   school 4021600 26-I051   NINNEKAH 402160001673 510 NINNEKAH MS Middle Regular School No Middle 06 08 2017   grade_7 24 2 0 3   0     0   5   20 14                       34 24 2 0 3   0     0   5   20 14                 34
478578 478578 OK GRADY   school 4026550 26-I068   RUSH SPRINGS 402655001391 505 RUSH SPRINGS MS Middle Regular School No Middle 06 08 2017   grade_7 28 0 0 6   1     0   1   20 16                       36 28 0 0 6   1     0   1   20 16                 36
478592 478592 OK GRADY   school 4005400 26-I095   BRIDGE CREEK 400540001674 505 BRIDGE CREEK MS Middle Regular School No Middle 06 08 2017   grade_7 85 0 4 2   0     0   15   57 49                       106 85 0 4 2   0     0   15   57 49                 106
478607 478607 OK GRADY   school 4030420 26-I097   TUTTLE 403042001696 505 TUTTLE MS Middle Regular School No Middle 06 08 2017   grade_7 122 1 13 17   2     2   13   90 80                       170 122 1 13 17   2     2   13   90 80                 170
478663 478663 OK GRANT   school 4024720 27-I090   POND CREEK-HUNTER 402472002764 505 POND CREEK-HUNTER MS Middle Regular School No Middle 05 08 2017   grade_7 25 0 4 2   0     0   1   10 22                       32 25 0 4 2   0     0   1   10 22                 32
478692 478692 OK GREER   school 4018780 28-I001   MANGUM 401878002321 510 MANGUM MS Middle Regular School No Middle 05 08 2017   grade_7 37 0 11 0   0     0   2   25 25                       50 37 0 11 0   0     0   2   25 25                 50
478723 478723 OK HARMON   school 4014850 29-I066   HOLLIS 401485000701 510 HOLLIS MS Middle Regular School No Middle 06 08 2017   grade_7 15 1 9 1   0     0   5   10 21                       31 15 1 9 1   0     0   5   10 21                 31
478792 478792 OK HASKELL   school 4028650 31-I020   STIGLER 402865001504 505 STIGLER MS Middle Regular School No Middle 05 08 2017   grade_7 50 1 4 9   2     0   33   52 47                       99 50 1 4 9   2     0   33   52 47                 99
479034 479034 OK JEFFERSON   school 4031980 34-I023   WAURIKA 403198002366 510 WAURIKA MS Middle Regular School No Middle 06 08 2017   grade_7 22 1 5 1   0     0   1   13 17                       30 22 1 5 1   0     0   1   13 17                 30
479082 479082 OK JOHNSTON   school 4030060 35-I020   TISHOMINGO 403006001574 505 TISHOMINGO MS Middle Regular School No Middle 05 08 2017   grade_7 33 0 4 14   0     0   12   36 27                       63 33 0 4 14   0     0   12   36 27                 63
479157 479157 OK KAY   school 4004630 36-I045   BLACKWELL 400463000152 505 BLACKWELL MS Middle Regular School No Middle 06 08 2017   grade_7 53 0 10 19   0     1   0   48 35                       83 53 0 10 19   0     1   0   48 35                 83
479208 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
479223 479223 OK KAY   school 4030120 36-I087   TONKAWA 403012002236 505 TONKAWA MS Middle Regular School No Middle 06 08 2017   grade_7 27 1 5 14   0     0   2   25 24                       49 27 1 5 14   0     0   2   25 24                 49
479238 479238 OK KAY   school 4021540 36-I125   NEWKIRK 402154001986 505 NEWKIRK MS Middle Regular School No Middle 05 08 2017   grade_7 41 0 3 21   0     0   0   40 25                       65 41 0 3 21   0     0   0   40 25                 65
479281 479281 OK KINGFISHER   school 4016560 37-I007   KINGFISHER 401656001879 505 KINGFISHER MS Middle Regular School No Middle 05 08 2017   grade_7 59 2 19 6   0     0   11   57 40                       97 59 2 19 6   0     0   11   57 40                 97
479310 479310 OK KINGFISHER   school 4006810 37-I089   CASHION 400681002816 505 CASHION MS Middle Regular School No Middle 06 08 2017   grade_7 35 1 1 2   0     0   2   26 15                       41 35 1 1 2   0     0   2   26 15                 41
479338 479338 OK KIOWA   school 4014700 38-I001   HOBART 401470000692 505 HOBART MS Middle Regular School No Middle 06 08 2017   grade_7 33 6 12 0   1     0   9   27 34                       61 33 6 12 0   1     0   9   27 34                 61
479395 479395 OK LATIMER   school 4032790 39-I001   WILBURTON 403279002675 510 WILBURTON MS Middle Regular School No Middle 06 08 2017   grade_7 25 2 4 24   0     0   2   33 24                       57 25 2 4 24   0     0   2   33 24                 57
479492 479492 OK LE FLORE   school 4028200 40-I002   SPIRO 402820001494 505 SPIRO MS Middle Regular School No Middle 06 08 2017   grade_7 31 5 4 26   2     0   4   32 40                       72 31 5 4 26   2     0   4   32 40                 72
479520 479520 OK LE FLORE   school 4024630 40-I007   POCOLA 402463001289 505 POCOLA MS Middle Regular School No Middle 06 08 2017   grade_7 39 2 2 13   0     0   9   37 28                       65 39 2 2 13   0     0   9   37 28                 65
479563 479563 OK LE FLORE   school 4023370 40-I020   PANAMA 402337001987 505 PANAMA MS Middle Regular School No Middle 07 08 2017   grade_7 29 1 4 18   1     0   0   33 20                       53 29 1 4 18   1     0   0   33 20                 53
479594 479594 OK LE FLORE   school 4024870 40-I029   POTEAU 402487001309 505 PANSY KIDD MS Middle Regular School No Middle 06 08 2017   grade_7 94 4 29 23   3     0   2   84 71                       155 94 4 29 23   3     0   2   84 71                 155
479723 479723 OK LINCOLN   school 4032280 41-I004   WELLSTON 403228029696 505 WELLSTON MS Middle Regular School No Middle 06 08 2017   grade_7 27 0 2 5   0     0   0   21 13                       34 27 0 2 5   0     0   0   21 13                 34
479737 479737 OK LINCOLN   school 4029070 41-I054   STROUD 402907001529 505 STROUD MS Middle Regular School No Middle 06 08 2017   grade_7 43 5 1 3   0     0   7   36 23                       59 43 5 1 3   0     0   7   36 23                 59
479754 479754 OK LINCOLN   school 4019680 41-I095   MEEKER 401968000939 505 MEEKER MS Middle Regular School No Middle 06 08 2017   grade_7 37 1 2 9   0     0   9   28 30                       58 37 1 2 9   0     0   9   28 30                 58
479769 479769 OK LINCOLN   school 4024930 41-I103   PRAGUE 402493001312 505 PRAGUE MS Middle Regular School No Middle 06 08 2017   grade_7 38 2 3 9   0     0   13   37 28                       65 38 2 3 9   0     0   13   37 28                 65
479828 479828 OK LOGAN   school 4009000 42-I002   CRESCENT 400900000379 515 CRESCENT MS Middle Regular School No Middle 06 08 2017   grade_7 29 3 1 4   0     0   0   16 21                       37 29 3 1 4   0     0   0   16 21                 37
479880 479880 OK LOVE   school 4029850 43-I004   THACKERVILLE 402985002833 505 THACKERVILLE MS Middle Regular School No Middle 06 08 2017   grade_7 12 0 2 2   1     0   8   17 8                       25 12 0 2 2   1     0   8   17 8                 25
479908 479908 OK LOVE   school 4018990 43-I016   MARIETTA 401899000901 500 MARIETTA MS Middle Regular School No Middle 06 08 2017   grade_7 32 0 29 3   0     0   3   34 33                       67 32 0 29 3   0     0   3   34 33                 67
479954 479954 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000537 510 CHAMBERLAIN MS Middle Regular School No Middle 06 08 2017   grade_7 47 0 1 4   0     0   0   24 28                       52 47 0 1 4   0     0   0   24 28                 52
479984 479984 OK MARSHALL   school 4018700 45-I002   MADILL 401870000888 505 MADILL MS Middle Regular School No Middle 06 08 2017   grade_7 52 2 51 16   0     0   10   57 74                       131 52 2 51 16   0     0   10   57 74                 131
479998 479998 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659001948 505 KINGSTON MS Middle Regular School No Middle 06 08 2017   grade_7 35 0 4 45   0     0   8   45 47                       92 35 0 4 45   0     0   8   45 47                 92
480063 480063 OK MAYES   school 4002460 46-I002   ADAIR 400246000010 505 ADAIR MS Middle Regular School No Middle 06 08 2017   grade_7 31 0 1 38   0     0   1   38 33                       71 31 0 1 38   0     0   1   38 33                 71

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