Data source: Big Local News · About: Big Local

590 rows where grade = "grade_7", state = "OK" and year = 2017 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2017 · 590

grade

  • grade_7 · 590
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
482095 OK OKLAHOMA   school 4000768 55-E002   OKLAHOMA CITY 400076802306 972 JUSTICE A.W. SEEWORTH ACADEMY Charter Regular School Yes Other 03 12 2017   grade_7 4 7 14 0   0     0   1   16 10                       26 4 7 14 0   0     0   1   16 10                 26
482399 OK OSAGE   school 4023580 57-I002   PAWHUSKA 402358001251 115 PAWHUSKA ES Elementary Regular School No Elementary 03 08 2017   grade_7 21 3 0 36   0     0   2   33 29                       62 21 3 0 36   0     0   2   33 29                 62
484259 OK TULSA   school 4000772 72-G004   SANKOFA MIDDLE SCHL (CHARTER) 400077202769 974 SANKOFA MIDDLE SCHOOL Charter Regular School Yes Elementary 03 08 2017   grade_7 0 10 0 0   0     0   0   5 5                       10 0 10 0 0   0     0   0   5 5                 10
478863 OK HUGHES   school 4014790 32-I035   HOLDENVILLE 401479002673 130 THOMAS IES Elementary Regular School No Elementary 04 08 2017   grade_7 43 2 1 29   0     0   0   32 43                       75 43 2 1 29   0     0   0   32 43                 75
479375 OK KIOWA   school 4027930 38-I004   SNYDER 402793001481 105 SNYDER ES Elementary Regular School No Elementary 04 08 2017   grade_7 19 1 5 0   0     0   2   9 18                       27 19 1 5 0   0     0   2   9 18                 27
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 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
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
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
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 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
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
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
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 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
479295 OK KINGFISHER   school 4014340 37-I016   HENNESSEY 401434001917 110 HENNESSEY UPPER ES Elementary Regular School No Middle 05 08 2017   grade_7 42 1 18 1   0     0   0   29 33                       62 42 1 18 1   0     0   0   29 33                 62
480422 OK MCINTOSH   school 4007350 49-I019   CHECOTAH 400735001859 505 CHECOTAH MS Middle Regular School No Middle 05 08 2017   grade_7 61 4 2 35   0     0   11   59 54                       113 61 4 2 35   0     0   11   59 54                 113
480480 OK MURRAY   school 4009510 50-I010   DAVIS 400951000411 505 DAVIS MS Middle Regular School No Middle 05 08 2017   grade_7 39 2 3 16   0     0   10   38 32                       70 39 2 3 16   0     0   10   38 32                 70
480858 OK OKFUSKEE   school 4000782 54-I054   GRAHAM-DUSTIN 400078200608 105 GRAHAM ES Elementary Regular School No Middle 05 08 2017   grade_7 6 0 1 5   0     1   2   7 8                       15 6 0 1 5   0     1   2   7 8                 15
481063 OK OKLAHOMA   school 4018630 55-I003   LUTHER 401863001949 505 LUTHER MS Middle Regular School No Middle 05 08 2017   grade_7 47 5 8 5   0     0   5   40 30                       70 47 5 8 5   0     0   5   40 30                 70
482129 OK OKLAHOMA   school 4000766 55-E012   OKLAHOMA CITY 400076602408 982 KIPP REACH COLLEGE PREPARATORY Charter Regular School Yes Middle 05 08 2017   grade_7 10 33 15 1   2     0   3   31 33                       64 10 33 15 1   2     0   3   31 33                 64
482283 OK OKMULGEE   school 4003810 56-I004   BEGGS 400381000120 505 BEGGS MS Middle Regular School No Middle 05 08 2017   grade_7 53 7 3 11   0     1   15   45 45                       90 53 7 3 11   0     1   15   45 45                 90
482415 OK OSAGE   school 4027630 57-I011   SHIDLER 402763002689 505 SHIDLER MS Middle Regular School No Middle 05 08 2017   grade_7 7 0 0 4   0     0   2   2 11                       13 7 0 0 4   0     0   2   2 11                 13
482485 OK OSAGE   school 4030048 57-I090   WOODLAND 403004829729 110 WOODLAND UPPER ES Elementary Regular School No Middle 05 08 2017   grade_7 7 0 1 19   0     1   1   16 13                       29 7 0 1 19   0     1   1   16 13                 29
482740 OK PAYNE   school 4009240 60-I067   CUSHING 400924000388 505 CUSHING MS Middle Regular School No Middle 05 08 2017   grade_7 96 4 8 36   0     0   13   87 70                       157 96 4 8 36   0     0   13   87 70                 157
483067 OK PONTOTOC   school 4028800 62-I030   STONEWALL 402880002389 515 MCLISH MS Middle Regular School No Middle 05 08 2017   grade_7 17 1 0 11   0     0   1   13 17                       30 17 1 0 11   0     0   1   13 17                 30
483841 OK SEQUOYAH   school 4020880 68-I003   MULDROW 402088001967 510 MULDROW MS Middle Regular School No Middle 05 08 2017   grade_7 39 1 7 43   2     0   0   45 47                       92 39 1 7 43   2     0   0   45 47                 92
484745 OK TULSA   school 4000780 72-E005   TULSA 400078002744 975 KIPP TULSA ACAD. COLLEGE PREP. Charter Regular School Yes Middle 05 08 2017   grade_7 1 74 4 1   0     0   3   43 40                       83 1 74 4 1   0     0   3   43 40                 83
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 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 OK BLAINE   school 4031770 06-I042   WATONGA 403177001759 505 WATONGA MS Middle Regular School No Middle 06 08 2017   grade_7 28 1 7 3   0     0   8   26 21                       47 28 1 7 3   0     0   8   26 21                 47
475897 OK BLAINE   school 4012570 06-I080   GEARY 401257000588 500 GEARY MS Middle Regular School No Middle 06 08 2017   grade_7 14 0 4 8   0     0   0   10 16                       26 14 0 4 8   0     0   0   10 16                 26
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
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 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
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
476165 OK CADDO   school 4014610 08-I161   HINTON 401461000096 610 HINTON MS Junior High Regular School No Middle 06 08 2017   grade_7 27 0 9 3   0     0   1   18 22                       40 27 0 9 3   0     0   1   18 22                 40
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
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
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 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 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 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 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
476654 OK CHEROKEE   school 4015240 11-I016   HULBERT 401524000101 615 HULBERT JR-SR HS (JR) Junior High Regular School No Middle 06 08 2017   grade_7 7 0 8 20   0     0   0   21 14                       35 7 0 8 20   0     0   0   21 14                 35
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
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
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 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 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 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 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 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 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
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 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 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 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
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 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 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 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 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 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 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
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
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
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
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 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 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 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 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 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 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
478473 OK GARVIN   school 4010860 25-I072   ELMORE CITY-PERNELL 401086002746 605 ELMORE CITY JHS Junior High Regular School No Middle 06 08 2017   grade_7 32 0 2 7   0     0   8   26 23                       49 32 0 2 7   0     0   8   26 23                 49
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 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 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 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 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
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
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
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 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 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
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 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 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 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 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
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 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 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 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 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 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 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 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 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

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