Data source: Big Local News · About: Big Local

3,363 rows where grade = "grade_6" and state = "OK" sorted by ccd_school_lvl descending

View and edit SQL

year

grade

  • grade_6 · 3,363
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
482032 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001885 706 CLASSEN HS OF ADVANCED STUDIES High School Regular School No Other 06 12 2017   grade_6 0 2 0 0   1     0   0   2 1                       3 0 2 0 0   1     0   0   2 1                 3
482066 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002276 760 NORTHEAST HS High School Regular School No Other 06 12 2017   grade_6 0 1 0 0   0     0   0   1 0                       1 0 1 0 0   0     0   0   1 0                 1
482094 OK OKLAHOMA   school 4000768 55-E002   OKLAHOMA CITY 400076802306 972 JUSTICE A.W. SEEWORTH ACADEMY Charter Regular School Yes Other 03 12 2017   grade_6 2 9 5 0   0     0   0   11 5                       16 2 9 5 0   0     0   0   11 5                 16
482108 OK OKLAHOMA   school 4000771 55-E005   OKLAHOMA CITY 400077102328 975 DOVE SCIENCE ACADEMY (OKC) Charter Regular School Yes Other 06 12 2017   grade_6 9 8 63 0   3     0   0   36 47                       83 9 8 63 0   3     0   0   36 47                 83
482850 OK PITTSBURG   school 4000795 61-E020   CANADIAN 400079502830 972 CARLTON LANDING ACADEMY CHARTR Charter Regular School Yes Other PK 12 2017   grade_6 2 0 0 1   0     0   0   0 3                       3 2 0 0 1   0     0   0   0 3                 3
484244 OK TULSA   school 4000753 72-G003   DISCOVERY SCHOOLS OF TULSA 400075302694 971 DISCOVERY SCHOOL OF TULSA Charter Regular School Yes Other KG 09 2017   grade_6 21 12 15 2   2     0   2   34 20                       54 21 12 15 2   2     0   2   34 20                 54
484251 OK TULSA   school 4000753 72-G003   DISCOVERY SCHOOLS OF TULSA 400075302312 972 DOVE SCIENCE ACADEMY (TULSA) Charter Regular School Yes Other 06 12 2017   grade_6 11 2 15 1   0     0   2   20 11                       31 11 2 15 1   0     0   2   20 11                 31
475602 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2017   grade_6 12 0 10 34   0     0   2   35 23                       58 12 0 10 34   0     0   2   35 23                 58
475616 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2017   grade_6 1 0 1 8   0     0   0   5 5                       10 1 0 1 8   0     0   0   5 5                 10
475645 OK ALFALFA   school 4007410 02-I046   CHEROKEE 400741002745 510 CHEROKEE MS Middle Regular School No Middle 06 08 2017   grade_6 30 0 3 2   0     0   1   20 16                       36 30 0 3 2   0     0   1   20 16                 36
475821 OK BECKHAM   school 4010740 05-I006   ELK CITY 401074000498 115 GRANDVIEW 5TH/6TH GRADE CTR Elementary Regular School No Middle 05 06 2017   grade_6 106 2 31 7   3     0   13   83 79                       162 106 2 31 7   3     0   13   83 79                 162
475839 OK BECKHAM   school 4027060 05-I031   SAYRE 402706002268 505 SAYRE MS Middle Regular School No Middle 06 08 2017   grade_6 42 0 10 0   0     0   2   32 22                       54 42 0 10 0   0     0   2   32 22                 54
475882 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2017   grade_6 29 1 8 10   0     0   4   24 28                       52 29 1 8 10   0     0   4   24 28                 52
475896 OK BLAINE   school 4012570 06-I080   GEARY 401257000588 500 GEARY MS Middle Regular School No Middle 06 08 2017   grade_6 10 1 5 12   0     0   0   13 15                       28 10 1 5 12   0     0   0   13 15                 28
475924 OK BRYAN   school 4027640 07-I001   SILO 402764001471 515 SILO MS Middle Regular School No Middle 06 08 2017   grade_6 47 1 1 17   0     0   7   36 37                       73 47 1 1 17   0     0   7   36 37                 73
476049 OK CADDO   school 4000032 08-I011   HYDRO-EAKLY 400003202357 505 HYDRO-EAKLY MS Middle Regular School No Middle 06 08 2017   grade_6 24 1 5 1   0     0   1   17 15                       32 24 1 5 1   0     0   1   17 15                 32
476078 OK CADDO   school 4003000 08-I020   ANADARKO 400300002101 510 ANADARKO MS Middle Regular School No Middle 06 08 2017   grade_6 20 1 27 76   0     0   1   65 60                       125 20 1 27 76   0     0   1   65 60                 125
476107 OK CADDO   school 4005010 08-I056   BOONE-APACHE 400501005012 505 APACHE MS Middle Regular School No Middle 06 08 2017   grade_6 15 0 2 14   1     0   8   24 16                       40 15 0 2 14   1     0   8   24 16                 40
476164 OK CADDO   school 4014610 08-I161   HINTON 401461000096 610 HINTON MS Junior High Regular School No Middle 06 08 2017   grade_6 43 1 11 7   0     0   1   25 38                       63 43 1 11 7   0     0   1   25 38                 63
476178 OK CADDO   school 4033602 08-I167   FORT COBB-BROXTON 403360201597 505 FORT COBB-BROXTON MS Middle Regular School No Middle 06 08 2017   grade_6 12 0 0 5   0     0   4   11 10                       21 12 0 0 5   0     0   4   11 10                 21
476261 OK CANADIAN   school 4023970 09-I022   PIEDMONT 402397002759 125 PIEDMONT INTERMEDIATE ES Elementary Regular School No Middle 05 06 2017   grade_6 184 7 20 34   13     1   12   142 129                       271 184 7 20 34   13     1   12   142 129                 271
476312 OK CANADIAN   school 4033480 09-I027   YUKON 403348002723 520 YUKON MS Middle Regular School No Middle 06 08 2017   grade_6 457 22 88 42   19     0   22   339 311                       650 457 22 88 42   19     0   22   339 311                 650
476326 OK CANADIAN   school 4010650 09-I034   EL RENO 401065002103 510 LESLIE F ROBLYER LEARNING CTR Middle Regular School No Middle 05 06 2017   grade_6 87 6 37 16   0     1   15   78 84                       162 87 6 37 16   0     1   15   78 84                 162
476383 OK CANADIAN   school 4021000 09-I069   MUSTANG 402100002767 140 MUSTANG HORIZON IES Elementary Regular School No Middle 05 06 2017   grade_6 248 9 45 21   3     1   25   185 167                       352 248 9 45 21   3     1   25   185 167                 352
476445 OK CARTER   school 4003180 10-I019   ARDMORE 400318029636 505 ARDMORE MS Middle Regular School No Middle 06 08 2017   grade_6 102 27 35 10   2     1   3   84 96                       180 102 27 35 10   2     1   3   84 96                 180
476473 OK CARTER   school 4024240 10-I027   PLAINVIEW 402424001279 505 PLAINVIEW MS Middle Regular School No Middle 06 08 2017   grade_6 73 4 12 11   9     0   14   72 51                       123 73 4 12 11   9     0   14   72 51                 123
476488 OK CARTER   school 4018090 10-I032   LONE GROVE 401809000869 505 LONE GROVE MS Middle Regular School No Middle 06 08 2017   grade_6 65 4 8 20   0     0   14   64 47                       111 65 4 8 20   0     0   14   64 47                 111
476516 OK CARTER   school 4014130 10-I055   HEALDTON 401413001863 505 HEALDTON MS Middle Regular School No Middle 06 08 2017   grade_6 21 0 3 5   0     0   2   17 14                       31 21 0 3 5   0     0   2   17 14                 31
476544 OK CARTER   school 4009910 10-I077   DICKSON 400991002667 510 DICKSON MS Middle Regular School No Middle 06 08 2017   grade_6 62 2 2 19   0     0   3   49 39                       88 62 2 2 19   0     0   3   49 39                 88
476653 OK CHEROKEE   school 4015240 11-I016   HULBERT 401524000101 615 HULBERT JR-SR HS (JR) Junior High Regular School No Middle 06 08 2017   grade_6 10 0 1 25   0     0   0   13 23                       36 10 0 1 25   0     0   0   13 23                 36
476680 OK CHEROKEE   school 4029380 11-I035   TAHLEQUAH 402938002401 520 TAHLEQUAH MS Middle Regular School No Middle 06 08 2017   grade_6 52 3 43 109   2     0   18   117 110                       227 52 3 43 109   2     0   18   117 110                 227
476758 OK CHOCTAW   school 4015210 12-I039   HUGO 401521002670 510 HUGO MS Middle Regular School No Middle 06 08 2017   grade_6 29 32 4 23   0     0   1   54 35                       89 29 32 4 23   0     0   1   54 35                 89
477214 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001073 500 IRVING MS Middle Regular School No Middle 06 08 2017   grade_6 123 20 36 16   4     0   41   120 120                       240 123 20 36 16   4     0   41   120 120                 240
477217 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172002117 501 ALCOTT MS Middle Regular School No Middle 06 08 2017   grade_6 126 17 38 11   5     0   35   141 91                       232 126 17 38 11   5     0   35   141 91                 232
477220 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001078 502 LONGFELLOW MS Middle Regular School No Middle 06 08 2017   grade_6 157 15 23 12   8     1   31   145 102                       247 157 15 23 12   8     1   31   145 102                 247
477223 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001085 504 WHITTIER MS Middle Regular School No Middle 06 08 2017   grade_6 231 11 55 16   10     0   47   199 171                       370 231 11 55 16   10     0   47   199 171                 370
477249 OK CLEVELAND   school 4021630 14-I040   NOBLE 402163002370 510 CURTIS INGE MS Middle Regular School No Middle 06 08 2017   grade_6 153 2 8 30   0     0   4   106 91                       197 153 2 8 30   0     0   4   106 91                 197
477263 OK CLEVELAND   school 4017580 14-I057   LEXINGTON 401758002678 510 LEXINGTON MS Middle Regular School No Middle 06 08 2017   grade_6 43 1 6 10   0     0   5   33 32                       65 43 1 6 10   0     0   5   33 32                 65
477277 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000103 505 LITTLE AXE MS Middle Regular School No Middle 06 08 2017   grade_6 74 0 5 12   0     0   10   50 51                       101 74 0 5 12   0     0   10   50 51                 101
477351 OK COMANCHE   school 4006120 16-I001   CACHE 400612002757 530 CACHE 5TH AND 6TH GRADE MS Middle Regular School No Middle 05 06 2017   grade_6 76 13 17 29   3     1   11   69 81                       150 76 13 17 29   3     1   11   69 81                 150
477520 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002364 530 MACARTHUR MS Middle Regular School No Middle 06 08 2017   grade_6 119 48 39 18   5     2   17   136 112                       248 119 48 39 18   5     2   17   136 112                 248
477523 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002393 535 CENTRAL MS Middle Regular School No Middle 06 08 2017   grade_6 105 61 60 20   3     0   22   133 138                       271 105 61 60 20   3     0   22   133 138                 271
477527 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002404 540 TOMLINSON MS Middle Regular School No Middle 06 08 2017   grade_6 85 60 56 16   2     2   29   129 121                       250 85 60 56 16   2     2   29   129 121                 250
477530 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002679 545 EISENHOWER MS Middle Regular School No Middle 06 08 2017   grade_6 91 75 33 18   8     1   24   123 127                       250 91 75 33 18   8     1   24   123 127                 250
477568 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2017   grade_6 112 7 19 16   0     0   14   78 90                       168 112 7 19 16   0     0   14   78 90                 168
477599 OK COTTON   school 4031470 17-I001   WALTERS 403147029649 505 WALTERS MS Middle Regular School No Middle 06 08 2017   grade_6 32 0 2 10   0     0   6   27 23                       50 32 0 2 10   0     0   6   27 23                 50
477653 OK CRAIG   school 4016380 18-I006   KETCHUM 401638002359 505 KETCHUM MS Middle Regular School No Middle 06 08 2017   grade_6 13 1 0 18   1     0   0   14 19                       33 13 1 0 18   1     0   0   14 19                 33
477667 OK CRAIG   school 4032190 18-I017   WELCH 403219001782 515 WELCH MS Middle Regular School No Middle 06 08 2017   grade_6 14 0 2 9   0     0   0   15 10                       25 14 0 2 9   0     0   0   15 10                 25
477682 OK CRAIG   school 4004830 18-I020   BLUEJACKET 400483002082 505 BLUEJACKET MS Middle Regular School No Middle 06 08 2017   grade_6 4 0 0 3   1     0   0   4 4                       8 4 0 0 3   1     0   0   4 4                 8
477696 OK CRAIG   school 4031290 18-I065   VINITA 403129001732 510 EWING HALSELL MS Middle Regular School No Middle 06 08 2017   grade_6 34 1 8 48   0     0   11   65 37                       102 34 1 8 48   0     0   11   65 37                 102
477751 OK CREEK   school 4005460 19-I002   BRISTOW 400546002083 505 BRISTOW MS Middle Regular School No Middle 06 08 2017   grade_6 64 7 2 39   1     0   0   51 62                       113 64 7 2 39   1     0   0   51 62                 113
477767 OK CREEK   school 4018840 19-I003   MANNFORD 401884000895 500 MANNFORD MS Middle Regular School No Middle 06 08 2017   grade_6 84 1 3 17   2     0   4   57 54                       111 84 1 3 17   2     0   4   57 54                 111
477888 OK CREEK   school 4026910 19-I033   SAPULPA 402691001882 505 SAPULPA MS Middle Regular School No Middle 06 07 2017   grade_6 132 15 26 41   1     0   30   122 123                       245 132 15 26 41   1     0   30   122 123                 245
477946 OK CUSTER   school 4032070 20-I026   WEATHERFORD 403207029848 510 WEATHERFORD MS Middle Regular School No Middle 06 08 2017   grade_6 99 1 30 1   0     0   13   63 81                       144 99 1 30 1   0     0   13   63 81                 144
477961 OK CUSTER   school 4008070 20-I099   CLINTON 400807000338 120 WASHINGTON ES Elementary Regular School No Middle 05 06 2017   grade_6 46 8 87 10   1     0   10   73 89                       162 46 8 87 10   1     0   10   73 89                 162
478014 OK DELAWARE   school 4015690 21-I001   JAY 401569000737 505 JAY MS Middle Regular School No Middle 06 08 2017   grade_6 39 1 15 61   7     0   15   65 73                       138 39 1 15 61   7     0   15   65 73                 138
478045 OK DELAWARE   school 4015990 21-I003   KANSAS 401599002269 505 KANSAS MS Middle Regular School No Middle 06 08 2017   grade_6 19 1 0 45   1     0   1   29 38                       67 19 1 0 45   1     0   1   29 38                 67
478209 OK GARFIELD   school 4021780 24-I042   CHISHOLM 402178002105 505 CHISHOLM MS Middle Regular School No Middle 06 08 2017   grade_6 78 0 5 2   1     0   0   38 48                       86 78 0 5 2   1     0   0   38 48                 86
478324 OK GARFIELD   school 4010920 24-I057   ENID 401092002700 505 EMERSON MS Middle Regular School No Middle 06 08 2017   grade_6 75 4 41 0   1     7   6   72 62                       134 75 4 41 0   1     7   6   72 62                 134
478328 OK GARFIELD   school 4010920 24-I057   ENID 401092002686 510 LONGFELLOW MS Middle Regular School No Middle 06 08 2017   grade_6 61 3 69 3   0     38   17   86 105                       191 61 3 69 3   0     38   17   86 105                 191
478331 OK GARFIELD   school 4010920 24-I057   ENID 401092000510 515 DEWITT WALLER MS Middle Regular School No Middle 06 08 2017   grade_6 171 10 35 7   2     5   27   136 121                       257 171 10 35 7   2     5   27   136 121                 257
478384 OK GARVIN   school 4028980 25-I002   STRATFORD 402898002677 505 STRATFORD MS Middle Regular School No Middle 06 08 2017   grade_6 35 0 1 16   0     0   0   26 26                       52 35 0 1 16   0     0   0   26 26                 52
478428 OK GARVIN   school 4017850 25-I009   LINDSAY 401785017850 505 LINDSAY MS Middle Regular School No Middle 06 08 2017   grade_6 59 0 9 7   0     0   0   38 37                       75 59 0 9 7   0     0   0   38 37                 75
478457 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2017   grade_6 32 5 4 5   0     0   3   34 15                       49 32 5 4 5   0     0   3   34 15                 49
478472 OK GARVIN   school 4010860 25-I072   ELMORE CITY-PERNELL 401086002746 605 ELMORE CITY JHS Junior High Regular School No Middle 06 08 2017   grade_6 29 1 1 9   0     1   2   24 19                       43 29 1 1 9   0     1   2   24 19                 43
478514 OK GRADY   school 4007560 26-I001   CHICKASHA 400756002373 115 LINCOLN ES Elementary Regular School No Middle 05 06 2017   grade_6 94 16 18 22   2     0   18   91 79                       170 94 16 18 22   2     0   18   91 79                 170
478535 OK GRADY   school 4020100 26-I002   MINCO 402010001668 505 MINCO MS Middle Regular School No Middle 06 08 2017   grade_6 28 1 7 0   0     0   5   24 17                       41 28 1 7 0   0     0   5   24 17                 41
478549 OK GRADY   school 4021600 26-I051   NINNEKAH 402160001673 510 NINNEKAH MS Middle Regular School No Middle 06 08 2017   grade_6 31 1 4 2   0     0   1   24 15                       39 31 1 4 2   0     0   1   24 15                 39
478577 OK GRADY   school 4026550 26-I068   RUSH SPRINGS 402655001391 505 RUSH SPRINGS MS Middle Regular School No Middle 06 08 2017   grade_6 31 2 2 5   0     0   0   21 19                       40 31 2 2 5   0     0   0   21 19                 40
478591 OK GRADY   school 4005400 26-I095   BRIDGE CREEK 400540001674 505 BRIDGE CREEK MS Middle Regular School No Middle 06 08 2017   grade_6 88 3 5 9   0     0   12   67 50                       117 88 3 5 9   0     0   12   67 50                 117
478606 OK GRADY   school 4030420 26-I097   TUTTLE 403042001696 505 TUTTLE MS Middle Regular School No Middle 06 08 2017   grade_6 130 0 9 16   1     0   4   93 67                       160 130 0 9 16   1     0   4   93 67                 160
478662 OK GRANT   school 4024720 27-I090   POND CREEK-HUNTER 402472002764 505 POND CREEK-HUNTER MS Middle Regular School No Middle 05 08 2017   grade_6 21 0 0 1   0     0   2   14 10                       24 21 0 0 1   0     0   2   14 10                 24
478691 OK GREER   school 4018780 28-I001   MANGUM 401878002321 510 MANGUM MS Middle Regular School No Middle 05 08 2017   grade_6 40 1 15 0   0     0   4   26 34                       60 40 1 15 0   0     0   4   26 34                 60
478722 OK HARMON   school 4014850 29-I066   HOLLIS 401485000701 510 HOLLIS MS Middle Regular School No Middle 06 08 2017   grade_6 11 2 21 0   0     0   7   16 25                       41 11 2 21 0   0     0   7   16 25                 41
478791 OK HASKELL   school 4028650 31-I020   STIGLER 402865001504 505 STIGLER MS Middle Regular School No Middle 05 08 2017   grade_6 54 0 4 8   0     0   26   46 46                       92 54 0 4 8   0     0   26   46 46                 92
478932 OK JACKSON   school 4002850 33-I018   ALTUS 400285002365 145 ALTUS INTERMEDIATE SCHOOL Elementary Regular School No Middle 05 06 2017   grade_6 89 13 92 4   4     1   17   117 103                       220 89 13 92 4   4     1   17   117 103                 220
479033 OK JEFFERSON   school 4031980 34-I023   WAURIKA 403198002366 510 WAURIKA MS Middle Regular School No Middle 06 08 2017   grade_6 24 0 8 4   0     0   0   17 19                       36 24 0 8 4   0     0   0   17 19                 36
479081 OK JOHNSTON   school 4030060 35-I020   TISHOMINGO 403006001574 505 TISHOMINGO MS Middle Regular School No Middle 05 08 2017   grade_6 30 1 11 13   0     0   24   39 40                       79 30 1 11 13   0     0   24   39 40                 79
479156 OK KAY   school 4004630 36-I045   BLACKWELL 400463000152 505 BLACKWELL MS Middle Regular School No Middle 06 08 2017   grade_6 53 3 7 13   0     0   7   45 38                       83 53 3 7 13   0     0   7   45 38                 83
479207 OK KAY   school 4024690 36-I071   PONCA CITY 402469002124 505 PONCA CITY WEST MS Middle Regular School No Middle 06 07 2017   grade_6 190 15 40 54   1     4   35   188 151                       339 190 15 40 54   1     4   35   188 151                 339
479222 OK KAY   school 4030120 36-I087   TONKAWA 403012002236 505 TONKAWA MS Middle Regular School No Middle 06 08 2017   grade_6 27 3 3 14   0     0   3   21 29                       50 27 3 3 14   0     0   3   21 29                 50
479237 OK KAY   school 4021540 36-I125   NEWKIRK 402154001986 505 NEWKIRK MS Middle Regular School No Middle 05 08 2017   grade_6 37 0 2 14   0     0   1   28 26                       54 37 0 2 14   0     0   1   28 26                 54
479280 OK KINGFISHER   school 4016560 37-I007   KINGFISHER 401656001879 505 KINGFISHER MS Middle Regular School No Middle 05 08 2017   grade_6 57 0 25 8   1     0   7   49 49                       98 57 0 25 8   1     0   7   49 49                 98
479294 OK KINGFISHER   school 4014340 37-I016   HENNESSEY 401434001917 110 HENNESSEY UPPER ES Elementary Regular School No Middle 05 08 2017   grade_6 25 2 21 1   0     0   0   23 26                       49 25 2 21 1   0     0   0   23 26                 49
479309 OK KINGFISHER   school 4006810 37-I089   CASHION 400681002816 505 CASHION MS Middle Regular School No Middle 06 08 2017   grade_6 32 0 1 3   0     0   1   20 17                       37 32 0 1 3   0     0   1   20 17                 37
479337 OK KIOWA   school 4014700 38-I001   HOBART 401470000692 505 HOBART MS Middle Regular School No Middle 06 08 2017   grade_6 28 8 15 2   0     0   2   25 30                       55 28 8 15 2   0     0   2   25 30                 55
479394 OK LATIMER   school 4032790 39-I001   WILBURTON 403279002675 510 WILBURTON MS Middle Regular School No Middle 06 08 2017   grade_6 25 0 5 12   1     0   2   18 27                       45 25 0 5 12   1     0   2   18 27                 45
479491 OK LE FLORE   school 4028200 40-I002   SPIRO 402820001494 505 SPIRO MS Middle Regular School No Middle 06 08 2017   grade_6 47 4 10 21   0     0   9   55 36                       91 47 4 10 21   0     0   9   55 36                 91
479519 OK LE FLORE   school 4024630 40-I007   POCOLA 402463001289 505 POCOLA MS Middle Regular School No Middle 06 08 2017   grade_6 45 0 2 6   0     0   9   30 32                       62 45 0 2 6   0     0   9   30 32                 62
479593 OK LE FLORE   school 4024870 40-I029   POTEAU 402487001309 505 PANSY KIDD MS Middle Regular School No Middle 06 08 2017   grade_6 88 3 18 33   1     0   2   76 69                       145 88 3 18 33   1     0   2   76 69                 145
479722 OK LINCOLN   school 4032280 41-I004   WELLSTON 403228029696 505 WELLSTON MS Middle Regular School No Middle 06 08 2017   grade_6 38 0 0 6   0     0   0   28 16                       44 38 0 0 6   0     0   0   28 16                 44
479736 OK LINCOLN   school 4029070 41-I054   STROUD 402907001529 505 STROUD MS Middle Regular School No Middle 06 08 2017   grade_6 37 1 3 3   0     0   2   18 28                       46 37 1 3 3   0     0   2   18 28                 46
479753 OK LINCOLN   school 4019680 41-I095   MEEKER 401968000939 505 MEEKER MS Middle Regular School No Middle 06 08 2017   grade_6 36 0 2 5   0     0   10   28 25                       53 36 0 2 5   0     0   10   28 25                 53
479768 OK LINCOLN   school 4024930 41-I103   PRAGUE 402493001312 505 PRAGUE MS Middle Regular School No Middle 06 08 2017   grade_6 43 1 5 5   0     0   13   33 34                       67 43 1 5 5   0     0   13   33 34                 67
479827 OK LOGAN   school 4009000 42-I002   CRESCENT 400900000379 515 CRESCENT MS Middle Regular School No Middle 06 08 2017   grade_6 47 2 2 3   0     0   1   26 29                       55 47 2 2 3   0     0   1   26 29                 55
479879 OK LOVE   school 4029850 43-I004   THACKERVILLE 402985002833 505 THACKERVILLE MS Middle Regular School No Middle 06 08 2017   grade_6 16 0 1 3   0     0   5   13 12                       25 16 0 1 3   0     0   5   13 12                 25
479907 OK LOVE   school 4018990 43-I016   MARIETTA 401899000901 500 MARIETTA MS Middle Regular School No Middle 06 08 2017   grade_6 33 1 28 7   0     0   8   35 42                       77 33 1 28 7   0     0   8   35 42                 77
479953 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000537 510 CHAMBERLAIN MS Middle Regular School No Middle 06 08 2017   grade_6 40 0 4 0   0     0   2   27 19                       46 40 0 4 0   0     0   2   27 19                 46
479983 OK MARSHALL   school 4018700 45-I002   MADILL 401870000888 505 MADILL MS Middle Regular School No Middle 06 08 2017   grade_6 46 0 40 15   2     0   13   59 57                       116 46 0 40 15   2     0   13   59 57                 116
479997 OK MARSHALL   school 4016590 45-I003   KINGSTON 401659001948 505 KINGSTON MS Middle Regular School No Middle 06 08 2017   grade_6 36 1 5 38   0     0   6   36 50                       86 36 1 5 38   0     0   6   36 50                 86

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