Data source: Big Local News · About: Big Local

588 rows where grade = "grade_7", state = "OK" and year = 2019 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2019 · 588

grade

  • grade_7 · 588
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
2310109 OK KIOWA   school 4027930 38-I004   SNYDER 402793001481 105 SNYDER ES Elementary Regular School No Middle 03 08 2019   grade_7 24 1 8 2   0     1   1   14 23                       37 24 1 8 2   0     1   1   14 23                 37
2312884 OK OKLAHOMA   school 4000768 55-E002   OKLAHOMA CITY 400076802306 972 JUSTICE AW SEEWORTH ACADEMY ES Charter Regular School Yes Middle 03 08 2019   grade_7 3 12 5 1   0     0   1   11 11                       22 3 12 5 1   0     0   1   11 11                 22
2309610 OK HUGHES   school 4014790 32-I035   HOLDENVILLE 401479002673 130 THOMAS IES Elementary Regular School No Middle 04 08 2019   grade_7 34 5 5 29   0     0   0   45 28                       73 34 5 5 29   0     0   0   45 28                 73
2315514 OK TULSA   school 4000793 72-E019   TULSA 400079302818 979 COLLEGIATE HALL CHARTER SCHOOL Charter Regular School Yes Middle 04 08 2019   grade_7 12 19 17 3   1     2   3   31 26                       57 12 19 17 3   1     2   3   31 26                 57
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
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
2306927 OK CADDO   school 4014610 08-I161   HINTON 401461000096 610 HINTON MS Junior High Regular School No Middle 05 08 2019   grade_7 34 0 10 4   0     0   2   27 23                       50 34 0 10 4   0     0   2   27 23                 50
2308328 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2019   grade_7 102 5 30 23   2     1   17   90 90                       180 102 5 30 23   2     1   17   90 90                 180
2309208 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2019   grade_7 37 6 2 9   0     1   1   22 34                       56 37 6 2 9   0     1   1   22 34                 56
2309409 OK GRANT   school 4024720 27-I090   POND CREEK-HUNTER 402472002764 505 POND CREEK-HUNTER MS Middle Regular School No Middle 05 08 2019   grade_7 15 0 1 1   0     0   1   8 10                       18 15 0 1 1   0     0   1   8 10                 18
2309438 OK GREER   school 4018780 28-I001   MANGUM 401878002321 510 MANGUM MS Middle Regular School No Middle 05 08 2019   grade_7 24 1 9 0   0     0   3   19 18                       37 24 1 9 0   0     0   3   19 18                 37
2309538 OK HASKELL   school 4028650 31-I020   STIGLER 402865001504 505 STIGLER MS Middle Regular School No Middle 05 08 2019   grade_7 62 0 9 13   0     0   23   49 58                       107 62 0 9 13   0     0   23   49 58                 107
2309817 OK JOHNSTON   school 4030060 35-I020   TISHOMINGO 403006001574 505 TISHOMINGO MS Middle Regular School No Middle 05 08 2019   grade_7 25 1 6 14   1     0   12   24 35                       59 25 1 6 14   1     0   12   24 35                 59
2309971 OK KAY   school 4021540 36-I125   NEWKIRK 402154001986 505 NEWKIRK MS Middle Regular School No Middle 05 08 2019   grade_7 45 0 2 21   0     0   0   34 34                       68 45 0 2 21   0     0   0   34 34                 68
2310013 OK KINGFISHER   school 4016560 37-I007   KINGFISHER 401656001879 505 KINGFISHER MS Middle Regular School No Middle 05 08 2019   grade_7 73 0 28 5   1     0   12   59 60                       119 73 0 28 5   1     0   12   59 60                 119
2310027 OK KINGFISHER   school 4014340 37-I016   HENNESSEY 401434001917 110 HENNESSEY UPPER ES Elementary Regular School No Middle 05 08 2019   grade_7 36 0 32 1   0     0   0   34 35                       69 36 0 32 1   0     0   0   34 35                 69
2311170 OK MCINTOSH   school 4007350 49-I019   CHECOTAH 400735001859 505 CHECOTAH MS Middle Regular School No Middle 05 08 2019   grade_7 46 2 1 34   0     0   9   50 42                       92 46 2 1 34   0     0   9   50 42                 92
2311229 OK MURRAY   school 4009510 50-I010   DAVIS 400951000411 505 DAVIS MS Middle Regular School No Middle 05 08 2019   grade_7 47 0 5 17   0     0   5   42 32                       74 47 0 5 17   0     0   5   42 32                 74
2311600 OK OKFUSKEE   school 4000782 54-I054   GRAHAM-DUSTIN 400078200608 105 GRAHAM ES Elementary Regular School No Middle 05 08 2019   grade_7 5 0 1 3   0     0   3   6 6                       12 5 0 1 3   0     0   3   6 6                 12
2311843 OK OKLAHOMA   school 4018630 55-I003   LUTHER 401863001949 505 LUTHER MS Middle Regular School No Middle 05 08 2019   grade_7 47 4 9 7   0     0   9   41 35                       76 47 4 9 7   0     0   9   41 35                 76
2312911 OK OKLAHOMA   school 4000766 55-E012   OKLAHOMA CITY 400076602408 982 KIPP REACH COLLEGE PREPARATORY Charter Regular School Yes Middle 05 08 2019   grade_7 9 46 11 0   1     0   1   27 41                       68 9 46 11 0   1     0   1   27 41                 68
2313014 OK OKMULGEE   school 4022800 56-I001   OKMULGEE 402280001211 145 DUNBAR INTERMEDIATE ES Elementary Regular School No Middle 05 08 2019   grade_7 25 20 4 44   1     0   0   47 47                       94 25 20 4 44   1     0   0   47 47                 94
2313056 OK OKMULGEE   school 4003810 56-I004   BEGGS 400381000120 505 BEGGS MS Middle Regular School No Middle 05 08 2019   grade_7 43 4 6 13   0     0   8   39 35                       74 43 4 6 13   0     0   8   39 35                 74
2313260 OK OSAGE   school 4030048 57-I090   WOODLAND 403004829729 110 WOODLAND UPPER ES Elementary Regular School No Middle 05 08 2019   grade_7 12 0 1 18   0     0   0   10 21                       31 12 0 1 18   0     0   0   10 21                 31
2313515 OK PAYNE   school 4009240 60-I067   CUSHING 400924000388 505 CUSHING MS Middle Regular School No Middle 05 08 2019   grade_7 84 2 9 12   1     0   22   70 60                       130 84 2 9 12   1     0   22   70 60                 130
2313837 OK PONTOTOC   school 4028800 62-I030   STONEWALL 402880002389 515 MCLISH MS Middle Regular School No Middle 05 08 2019   grade_7 10 0 0 11   0     0   8   21 8                       29 10 0 0 11   0     0   8   21 8                 29
2314603 OK SEQUOYAH   school 4020880 68-I003   MULDROW 402088001967 510 MULDROW MS Middle Regular School No Middle 05 08 2019   grade_7 45 2 5 52   2     0   0   52 54                       106 45 2 5 52   2     0   0   52 54                 106
2315491 OK TULSA   school 4000780 72-E005   TULSA 400078002744 975 KIPP TULSA ACAD. COLLEGE PREP. Charter Regular School Yes Middle 05 08 2019   grade_7 4 81 12 0   0     1   2   43 57                       100 4 81 12 0   0     1   2   43 57                 100
2315509 OK TULSA   school 4000792 72-E018   TULSA 400079202822 978 TULSA HONOR ACADEMY CHARTER Charter Regular School Yes Middle 05 08 2019   grade_7 11 8 84 0   1     0   2   46 60                       106 11 8 84 0   1     0   2   46 60                 106
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2308035 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000103 505 LITTLE AXE MS Middle Regular School No Middle 06 08 2019   grade_7 58 1 6 14   0     0   9   53 35                       88 58 1 6 14   0     0   9   53 35                 88
2308277 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002364 530 MACARTHUR MS Middle Regular School No Middle 06 08 2019   grade_7 105 56 48 7   5     2   31   125 129                       254 105 56 48 7   5     2   31   125 129                 254
2308281 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002393 535 CENTRAL MS Middle Regular School No Middle 06 08 2019   grade_7 77 46 49 11   0     5   27   120 95                       215 77 46 49 11   0     5   27   120 95                 215
2308285 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002404 540 TOMLINSON MS Middle Regular School No Middle 06 08 2019   grade_7 63 50 44 17   5     0   28   105 102                       207 63 50 44 17   5     0   28   105 102                 207
2308288 OK COMANCHE   school 4017250 16-I008   LAWTON 401725002679 545 EISENHOWER MS Middle Regular School No Middle 06 08 2019   grade_7 108 68 59 20   6     6   40   153 154                       307 108 68 59 20   6     6   40   153 154                 307
2308358 OK COTTON   school 4031470 17-I001   WALTERS 403147029649 505 WALTERS MS Middle Regular School No Middle 06 08 2019   grade_7 30 1 3 8   0     1   7   23 27                       50 30 1 3 8   0     1   7   23 27                 50
2308410 OK CRAIG   school 4016380 18-I006   KETCHUM 401638002359 505 KETCHUM MS Middle Regular School No Middle 06 08 2019   grade_7 20 0 1 12   0     0   4   18 19                       37 20 0 1 12   0     0   4   18 19                 37
2308424 OK CRAIG   school 4032190 18-I017   WELCH 403219001782 515 WELCH MS Middle Regular School No Middle 06 08 2019   grade_7 14 0 2 10   0     0   0   9 17                       26 14 0 2 10   0     0   0   9 17                 26
2308439 OK CRAIG   school 4004830 18-I020   BLUEJACKET 400483002082 505 BLUEJACKET MS Middle Regular School No Middle 06 08 2019   grade_7 7 0 0 5   0     0   1   7 6                       13 7 0 0 5   0     0   1   7 6                 13
2308453 OK CRAIG   school 4031290 18-I065   VINITA 403129001732 510 EWING HALSELL MS Middle Regular School No Middle 06 08 2019   grade_7 47 2 3 31   1     0   15   45 54                       99 47 2 3 31   1     0   15   45 54                 99
2308510 OK CREEK   school 4005460 19-I002   BRISTOW 400546002083 505 BRISTOW MS Middle Regular School No Middle 06 08 2019   grade_7 72 10 4 34   2     0   0   59 63                       122 72 10 4 34   2     0   0   59 63                 122
2308526 OK CREEK   school 4018840 19-I003   MANNFORD 401884000895 500 MANNFORD MS Middle Regular School No Middle 06 08 2019   grade_7 79 1 4 12   1     0   10   55 52                       107 79 1 4 12   1     0   10   55 52                 107
2308649 OK CREEK   school 4026910 19-I033   SAPULPA 402691001882 505 SAPULPA MS Middle Regular School No Middle 06 07 2019   grade_7 138 10 24 38   2     0   38   131 119                       250 138 10 24 38   2     0   38   131 119                 250
2308706 OK CUSTER   school 4032070 20-I026   WEATHERFORD 403207029848 510 WEATHERFORD MS Middle Regular School No Middle 06 08 2019   grade_7 107 0 28 6   0     0   17   79 79                       158 107 0 28 6   0     0   17   79 79                 158
2308775 OK DELAWARE   school 4015690 21-I001   JAY 401569000737 505 JAY MS Middle Regular School No Middle 06 08 2019   grade_7 31 1 19 47   4     0   20   75 47                       122 31 1 19 47   4     0   20   75 47                 122
2308804 OK DELAWARE   school 4015990 21-I003   KANSAS 401599002269 505 KANSAS MS Middle Regular School No Middle 06 08 2019   grade_7 21 0 3 39   0     0   3   37 29                       66 21 0 3 39   0     0   3   37 29                 66
2308959 OK GARFIELD   school 4021780 24-I042   CHISHOLM 402178002105 505 CHISHOLM MS Middle Regular School No Middle 06 08 2019   grade_7 92 1 9 1   2     0   0   56 49                       105 92 1 9 1   2     0   0   56 49                 105
2309075 OK GARFIELD   school 4010920 24-I057   ENID 401092002700 505 EMERSON MS Middle Regular School No Middle 06 08 2019   grade_7 61 1 37 3   2     13   13   63 67                       130 61 1 37 3   2     13   13   63 67                 130
2309079 OK GARFIELD   school 4010920 24-I057   ENID 401092002686 510 LONGFELLOW MS Middle Regular School No Middle 06 08 2019   grade_7 45 10 79 4   0     43   11   88 104                       192 45 10 79 4   0     43   11   88 104                 192
2309082 OK GARFIELD   school 4010920 24-I057   ENID 401092000510 515 DEWITT WALLER MS Middle Regular School No Middle 06 08 2019   grade_7 161 7 38 4   6     15   24   143 112                       255 161 7 38 4   6     15   24   143 112                 255
2309136 OK GARVIN   school 4028980 25-I002   STRATFORD 402898002677 505 STRATFORD MS Middle Regular School No Middle 06 08 2019   grade_7 29 0 2 14   1     0   0   24 22                       46 29 0 2 14   1     0   0   24 22                 46
2309180 OK GARVIN   school 4017850 25-I009   LINDSAY 401785017850 505 LINDSAY MS Middle Regular School No Middle 06 08 2019   grade_7 64 0 6 21   0     0   1   47 45                       92 64 0 6 21   0     0   1   47 45                 92
2309222 OK GARVIN   school 4010860 25-I072   ELMORE CITY-PERNELL 401086002746 605 ELMORE CITY JHS Junior High Regular School No Middle 06 08 2019   grade_7 36 0 3 8   0     0   1   28 20                       48 36 0 3 8   0     0   1   28 20                 48
2309281 OK GRADY   school 4020100 26-I002   MINCO 402010001668 505 MINCO MS Middle Regular School No Middle 06 08 2019   grade_7 38 0 4 2   0     0   10   26 28                       54 38 0 4 2   0     0   10   26 28                 54
2309295 OK GRADY   school 4021600 26-I051   NINNEKAH 402160001673 510 NINNEKAH MS Middle Regular School No Middle 06 08 2019   grade_7 25 0 3 3   0     0   3   16 18                       34 25 0 3 3   0     0   3   16 18                 34
2309323 OK GRADY   school 4026550 26-I068   RUSH SPRINGS 402655001391 505 RUSH SPRINGS MS Middle Regular School No Middle 06 08 2019   grade_7 30 1 0 10   0     0   1   25 17                       42 30 1 0 10   0     0   1   25 17                 42
2309337 OK GRADY   school 4005400 26-I095   BRIDGE CREEK 400540001674 505 BRIDGE CREEK MS Middle Regular School No Middle 06 08 2019   grade_7 96 0 16 3   0     0   11   70 56                       126 96 0 16 3   0     0   11   70 56                 126
2309352 OK GRADY   school 4030420 26-I097   TUTTLE 403042001696 505 TUTTLE MS Middle Regular School No Middle 06 08 2019   grade_7 108 2 11 6   2     1   10   79 61                       140 108 2 11 6   2     1   10   79 61                 140
2309468 OK HARMON   school 4014850 29-I066   HOLLIS 401485000701 510 HOLLIS MS Middle Regular School No Middle 06 08 2019   grade_7 16 1 19 1   0     0   3   23 17                       40 16 1 19 1   0     0   3   23 17                 40
2309770 OK JEFFERSON   school 4031980 34-I023   WAURIKA 403198002366 510 WAURIKA MS Middle Regular School No Middle 06 08 2019   grade_7 21 0 6 4   0     0   2   17 16                       33 21 0 6 4   0     0   2   17 16                 33
2309892 OK KAY   school 4004630 36-I045   BLACKWELL 400463000152 505 BLACKWELL MS Middle Regular School No Middle 06 08 2019   grade_7 54 0 10 15   0     0   0   41 38                       79 54 0 10 15   0     0   0   41 38                 79
2309943 OK KAY   school 4024690 36-I071   PONCA CITY 402469002124 505 PONCA CITY WEST MS Middle Regular School No Middle 06 07 2019   grade_7 189 14 35 62   1     7   58   196 170                       366 189 14 35 62   1     7   58   196 170                 366
2309957 OK KAY   school 4030120 36-I087   TONKAWA 403012002236 505 TONKAWA MS Middle Regular School No Middle 06 08 2019   grade_7 31 0 5 16   0     0   0   24 28                       52 31 0 5 16   0     0   0   24 28                 52
2310042 OK KINGFISHER   school 4006810 37-I089   CASHION 400681002816 505 CASHION MS Middle Regular School No Middle 06 08 2019   grade_7 41 0 1 5   0     0   0   22 25                       47 41 0 1 5   0     0   0   22 25                 47
2310070 OK KIOWA   school 4014700 38-I001   HOBART 401470000692 505 HOBART MS Middle Regular School No Middle 06 08 2019   grade_7 18 8 11 2   0     0   8   25 22                       47 18 8 11 2   0     0   8   25 22                 47
2310131 OK LATIMER   school 4032790 39-I001   WILBURTON 403279002675 510 WILBURTON MS Middle Regular School No Middle 06 08 2019   grade_7 23 1 4 13   0     0   8   18 31                       49 23 1 4 13   0     0   8   18 31                 49
2310228 OK LE FLORE   school 4028200 40-I002   SPIRO 402820001494 505 SPIRO MS Middle Regular School No Middle 06 08 2019   grade_7 41 2 3 21   1     0   4   46 26                       72 41 2 3 21   1     0   4   46 26                 72
2310256 OK LE FLORE   school 4024630 40-I007   POCOLA 402463001289 505 POCOLA MS Middle Regular School No Middle 06 08 2019   grade_7 34 0 2 7   1     0   7   25 26                       51 34 0 2 7   1     0   7   25 26                 51
2310327 OK LE FLORE   school 4024870 40-I029   POTEAU 402487001309 505 PANSY KIDD MS Middle Regular School No Middle 06 08 2019   grade_7 83 1 36 39   1     0   16   97 79                       176 83 1 36 39   1     0   16   97 79                 176
2310452 OK LINCOLN   school 4032280 41-I004   WELLSTON 403228029696 505 WELLSTON MS Middle Regular School No Middle 06 08 2019   grade_7 38 0 0 5   0     0   0   23 20                       43 38 0 0 5   0     0   0   23 20                 43
2310467 OK LINCOLN   school 4029070 41-I054   STROUD 402907001529 505 STROUD MS Middle Regular School No Middle 06 08 2019   grade_7 34 1 2 6   0     0   2   20 25                       45 34 1 2 6   0     0   2   20 25                 45
2310483 OK LINCOLN   school 4019680 41-I095   MEEKER 401968000939 505 MEEKER MS Middle Regular School No Middle 06 08 2019   grade_7 31 0 4 2   0     0   10   29 18                       47 31 0 4 2   0     0   10   29 18                 47
2310497 OK LINCOLN   school 4024930 41-I103   PRAGUE 402493001312 505 PRAGUE MS Middle Regular School No Middle 06 08 2019   grade_7 64 2 5 9   1     0   17   54 44                       98 64 2 5 9   1     0   17   54 44                 98
2310628 OK LOVE   school 4029850 43-I004   THACKERVILLE 402985002833 505 THACKERVILLE MS Middle Regular School No Middle 06 08 2019   grade_7 13 0 2 2   0     0   3   8 12                       20 13 0 2 2   0     0   3   8 12                 20
2310656 OK LOVE   school 4018990 43-I016   MARIETTA 401899000901 500 MARIETTA MS Middle Regular School No Middle 06 08 2019   grade_7 29 3 30 2   0     0   5   34 35                       69 29 3 30 2   0     0   5   34 35                 69
2310702 OK MAJOR   school 4011280 44-I084   FAIRVIEW 401128000537 510 CHAMBERLAIN MS Middle Regular School No Middle 06 08 2019   grade_7 48 0 6 3   0     0   2   34 25                       59 48 0 6 3   0     0   2   34 25                 59

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