Data source: Big Local News · About: Big Local

4,138 rows where grade = "grade_5" and state = "OK" sorted by school_state_type descending

View and edit SQL

year

grade

  • grade_5 · 4,138
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
475601 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2017   grade_5 6 0 12 33   0     0   0   25 26                       51 6 0 12 33   0     0   0   25 26                 51
475615 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2017   grade_5 0 0 0 4   0     0   0   3 1                       4 0 0 0 4   0     0   0   3 1                 4
476325 OK CANADIAN   school 4010650 09-I034   EL RENO 401065002103 510 LESLIE F ROBLYER LEARNING CTR Middle Regular School No Middle 05 06 2017   grade_5 81 8 55 26   0     0   16   92 94                       186 81 8 55 26   0     0   16   92 94                 186
477350 OK COMANCHE   school 4006120 16-I001   CACHE 400612002757 530 CACHE 5TH AND 6TH GRADE MS Middle Regular School No Middle 05 06 2017   grade_5 62 14 15 32   3     0   13   55 84                       139 62 14 15 32   3     0   13   55 84                 139
477567 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2017   grade_5 97 4 25 18   1     2   17   88 76                       164 97 4 25 18   1     2   17   88 76                 164
478456 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2017   grade_5 39 7 3 8   0     1   0   22 36                       58 39 7 3 8   0     1   0   22 36                 58
478661 OK GRANT   school 4024720 27-I090   POND CREEK-HUNTER 402472002764 505 POND CREEK-HUNTER MS Middle Regular School No Middle 05 08 2017   grade_5 19 0 1 0   0     0   2   13 9                       22 19 0 1 0   0     0   2   13 9                 22
478690 OK GREER   school 4018780 28-I001   MANGUM 401878002321 510 MANGUM MS Middle Regular School No Middle 05 08 2017   grade_5 25 0 10 0   0     0   2   22 15                       37 25 0 10 0   0     0   2   22 15                 37
478790 OK HASKELL   school 4028650 31-I020   STIGLER 402865001504 505 STIGLER MS Middle Regular School No Middle 05 08 2017   grade_5 61 0 8 12   0     0   23   49 55                       104 61 0 8 12   0     0   23   49 55                 104
479080 OK JOHNSTON   school 4030060 35-I020   TISHOMINGO 403006001574 505 TISHOMINGO MS Middle Regular School No Middle 05 08 2017   grade_5 34 1 7 14   1     0   12   29 40                       69 34 1 7 14   1     0   12   29 40                 69
479236 OK KAY   school 4021540 36-I125   NEWKIRK 402154001986 505 NEWKIRK MS Middle Regular School No Middle 05 08 2017   grade_5 40 1 1 13   0     0   0   32 23                       55 40 1 1 13   0     0   0   32 23                 55
479279 OK KINGFISHER   school 4016560 37-I007   KINGFISHER 401656001879 505 KINGFISHER MS Middle Regular School No Middle 05 08 2017   grade_5 64 0 26 6   1     0   11   53 55                       108 64 0 26 6   1     0   11   53 55                 108
480420 OK MCINTOSH   school 4007350 49-I019   CHECOTAH 400735001859 505 CHECOTAH MS Middle Regular School No Middle 05 08 2017   grade_5 48 2 1 34   1     0   9   48 47                       95 48 2 1 34   1     0   9   48 47                 95
480478 OK MURRAY   school 4009510 50-I010   DAVIS 400951000411 505 DAVIS MS Middle Regular School No Middle 05 08 2017   grade_5 50 0 2 18   0     0   6   46 30                       76 50 0 2 18   0     0   6   46 30                 76
481061 OK OKLAHOMA   school 4018630 55-I003   LUTHER 401863001949 505 LUTHER MS Middle Regular School No Middle 05 08 2017   grade_5 41 3 8 6   0     0   10   38 30                       68 41 3 8 6   0     0   10   38 30                 68
482281 OK OKMULGEE   school 4003810 56-I004   BEGGS 400381000120 505 BEGGS MS Middle Regular School No Middle 05 08 2017   grade_5 47 4 5 16   0     0   9   49 32                       81 47 4 5 16   0     0   9   49 32                 81
482413 OK OSAGE   school 4027630 57-I011   SHIDLER 402763002689 505 SHIDLER MS Middle Regular School No Middle 05 08 2017   grade_5 11 1 2 8   1     0   0   9 14                       23 11 1 2 8   1     0   0   9 14                 23
482738 OK PAYNE   school 4009240 60-I067   CUSHING 400924000388 505 CUSHING MS Middle Regular School No Middle 05 08 2017   grade_5 86 1 9 15   1     0   25   74 63                       137 86 1 9 15   1     0   25   74 63                 137
483065 OK PONTOTOC   school 4028800 62-I030   STONEWALL 402880002389 515 MCLISH MS Middle Regular School No Middle 05 08 2017   grade_5 16 0 0 14   0     0   6   22 14                       36 16 0 0 14   0     0   6   22 14                 36
483839 OK SEQUOYAH   school 4020880 68-I003   MULDROW 402088001967 510 MULDROW MS Middle Regular School No Middle 05 08 2017   grade_5 43 2 7 44   2     0   6   49 55                       104 43 2 7 44   2     0   6   49 55                 104
2306371 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2019   grade_5 4 0 13 53   0     0   1   38 33                       71 4 0 13 53   0     0   1   38 33                 71
2306385 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2019   grade_5 0 0 0 9   0     0   0   7 2                       9 0 0 0 9   0     0   0   7 2                 9
2307087 OK CANADIAN   school 4010650 09-I034   EL RENO 401065002103 510 LESLIE F ROBLYER LEARNING CTR Middle Regular School No Middle 05 06 2019   grade_5 100 6 63 24   0     0   16   111 98                       209 100 6 63 24   0     0   16   111 98                 209
2308105 OK COMANCHE   school 4006120 16-I001   CACHE 400612002757 530 CACHE 5TH AND 6TH GRADE MS Middle Regular School No Middle 05 06 2019   grade_5 75 15 23 18   4     0   13   70 78                       148 75 15 23 18   4     0   13   70 78                 148
2308326 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2019   grade_5 98 6 28 20   1     1   10   87 77                       164 98 6 28 20   1     1   10   87 77                 164
2309206 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2019   grade_5 31 3 8 7   0     1   2   33 19                       52 31 3 8 7   0     1   2   33 19                 52
2309407 OK GRANT   school 4024720 27-I090   POND CREEK-HUNTER 402472002764 505 POND CREEK-HUNTER MS Middle Regular School No Middle 05 08 2019   grade_5 24 0 1 0   0     0   1   10 16                       26 24 0 1 0   0     0   1   10 16                 26
2309436 OK GREER   school 4018780 28-I001   MANGUM 401878002321 510 MANGUM MS Middle Regular School No Middle 05 08 2019   grade_5 34 0 7 0   0     0   3   19 25                       44 34 0 7 0   0     0   3   19 25                 44
2309536 OK HASKELL   school 4028650 31-I020   STIGLER 402865001504 505 STIGLER MS Middle Regular School No Middle 05 08 2019   grade_5 38 1 10 23   0     0   12   47 37                       84 38 1 10 23   0     0   12   47 37                 84
2309815 OK JOHNSTON   school 4030060 35-I020   TISHOMINGO 403006001574 505 TISHOMINGO MS Middle Regular School No Middle 05 08 2019   grade_5 40 3 2 17   0     0   12   36 38                       74 40 3 2 17   0     0   12   36 38                 74
2309969 OK KAY   school 4021540 36-I125   NEWKIRK 402154001986 505 NEWKIRK MS Middle Regular School No Middle 05 08 2019   grade_5 27 0 4 18   0     0   0   25 24                       49 27 0 4 18   0     0   0   25 24                 49
2310011 OK KINGFISHER   school 4016560 37-I007   KINGFISHER 401656001879 505 KINGFISHER MS Middle Regular School No Middle 05 08 2019   grade_5 65 0 20 3   0     0   18   49 57                       106 65 0 20 3   0     0   18   49 57                 106
2311168 OK MCINTOSH   school 4007350 49-I019   CHECOTAH 400735001859 505 CHECOTAH MS Middle Regular School No Middle 05 08 2019   grade_5 47 2 2 37   0     0   9   51 46                       97 47 2 2 37   0     0   9   51 46                 97
2311227 OK MURRAY   school 4009510 50-I010   DAVIS 400951000411 505 DAVIS MS Middle Regular School No Middle 05 08 2019   grade_5 40 2 0 23   0     0   3   32 36                       68 40 2 0 23   0     0   3   32 36                 68
2311841 OK OKLAHOMA   school 4018630 55-I003   LUTHER 401863001949 505 LUTHER MS Middle Regular School No Middle 05 08 2019   grade_5 39 4 6 4   0     0   5   27 31                       58 39 4 6 4   0     0   5   27 31                 58
2313054 OK OKMULGEE   school 4003810 56-I004   BEGGS 400381000120 505 BEGGS MS Middle Regular School No Middle 05 08 2019   grade_5 48 3 4 10   0     0   19   42 42                       84 48 3 4 10   0     0   19   42 42                 84
2313513 OK PAYNE   school 4009240 60-I067   CUSHING 400924000388 505 CUSHING MS Middle Regular School No Middle 05 08 2019   grade_5 88 0 12 17   1     0   20   78 60                       138 88 0 12 17   1     0   20   78 60                 138
2313835 OK PONTOTOC   school 4028800 62-I030   STONEWALL 402880002389 515 MCLISH MS Middle Regular School No Middle 05 08 2019   grade_5 15 1 2 9   0     0   7   20 14                       34 15 1 2 9   0     0   7   20 14                 34
2314601 OK SEQUOYAH   school 4020880 68-I003   MULDROW 402088001967 510 MULDROW MS Middle Regular School No Middle 05 08 2019   grade_5 40 3 4 35   1     0   0   45 38                       83 40 3 4 35   1     0   0   45 38                 83
2316286 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318002841 510 WOODWARD MS NORTH CAMPUS Middle Regular School No Middle 05 06 2019   grade_5 128 1 52 4   3     0   3   109 82                       191 128 1 52 4   3     0   3   109 82                 191
2348026 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2018   grade_5 15 0 19 34   0     0   0   34 34                       68 15 0 19 34   0     0   0   34 34                 68
2348040 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2018   grade_5 5 0 0 8   0     0   0   5 8                       13 5 0 0 8   0     0   0   5 8                 13
2348743 OK CANADIAN   school 4010650 09-I034   EL RENO 401065002103 510 LESLIE F ROBLYER LEARNING CTR Middle Regular School No Middle 05 06 2018   grade_5 101 9 44 24   0     0   18   101 95                       196 101 9 44 24   0     0   18   101 95                 196
2349746 OK COMANCHE   school 4006120 16-I001   CACHE 400612002757 530 CACHE 5TH AND 6TH GRADE MS Middle Regular School No Middle 05 06 2018   grade_5 71 12 19 31   1     1   15   94 56                       150 71 12 19 31   1     1   15   94 56                 150
2349963 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2018   grade_5 103 3 26 18   0     1   13   99 65                       164 103 3 26 18   0     1   13   99 65                 164
2350852 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2018   grade_5 33 2 2 8   0     0   4   27 22                       49 33 2 2 8   0     0   4   27 22                 49
2351054 OK GRANT   school 4024720 27-I090   POND CREEK-HUNTER 402472002764 505 POND CREEK-HUNTER MS Middle Regular School No Middle 05 08 2018   grade_5 25 0 2 1   0     0   4   11 21                       32 25 0 2 1   0     0   4   11 21                 32
2351084 OK GREER   school 4018780 28-I001   MANGUM 401878002321 510 MANGUM MS Middle Regular School No Middle 05 08 2018   grade_5 33 2 16 0   0     0   5   23 33                       56 33 2 16 0   0     0   5   23 33                 56
2351184 OK HASKELL   school 4028650 31-I020   STIGLER 402865001504 505 STIGLER MS Middle Regular School No Middle 05 08 2018   grade_5 55 0 7 18   1     0   19   62 38                       100 55 0 7 18   1     0   19   62 38                 100
2351462 OK JOHNSTON   school 4030060 35-I020   TISHOMINGO 403006001574 505 TISHOMINGO MS Middle Regular School No Middle 05 08 2018   grade_5 40 0 4 13   0     1   14   39 33                       72 40 0 4 13   0     1   14   39 33                 72
2351617 OK KAY   school 4021540 36-I125   NEWKIRK 402154001986 505 NEWKIRK MS Middle Regular School No Middle 05 08 2018   grade_5 48 1 3 20   0     0   0   31 41                       72 48 1 3 20   0     0   0   31 41                 72
2351659 OK KINGFISHER   school 4016560 37-I007   KINGFISHER 401656001879 505 KINGFISHER MS Middle Regular School No Middle 05 08 2018   grade_5 69 0 19 4   0     0   16   63 45                       108 69 0 19 4   0     0   16   63 45                 108
2352795 OK MCINTOSH   school 4007350 49-I019   CHECOTAH 400735001859 505 CHECOTAH MS Middle Regular School No Middle 05 08 2018   grade_5 48 3 4 41   1     0   10   51 56                       107 48 3 4 41   1     0   10   51 56                 107
2352857 OK MURRAY   school 4009510 50-I010   DAVIS 400951000411 505 DAVIS MS Middle Regular School No Middle 05 08 2018   grade_5 47 0 3 25   0     0   7   40 42                       82 47 0 3 25   0     0   7   40 42                 82
2353462 OK OKLAHOMA   school 4018630 55-I003   LUTHER 401863001949 505 LUTHER MS Middle Regular School No Middle 05 08 2018   grade_5 50 5 3 3   0     0   1   33 29                       62 50 5 3 3   0     0   1   33 29                 62
2354668 OK OKMULGEE   school 4003810 56-I004   BEGGS 400381000120 505 BEGGS MS Middle Regular School No Middle 05 08 2018   grade_5 37 4 7 11   0     0   11   34 36                       70 37 4 7 11   0     0   11   34 36                 70
2355128 OK PAYNE   school 4009240 60-I067   CUSHING 400924000388 505 CUSHING MS Middle Regular School No Middle 05 08 2018   grade_5 88 3 11 22   1     0   25   76 74                       150 88 3 11 22   1     0   25   76 74                 150
2355455 OK PONTOTOC   school 4028800 62-I030   STONEWALL 402880002389 515 MCLISH MS Middle Regular School No Middle 05 08 2018   grade_5 30 0 3 7   0     0   9   27 22                       49 30 0 3 7   0     0   9   27 22                 49
2356225 OK SEQUOYAH   school 4020880 68-I003   MULDROW 402088001967 510 MULDROW MS Middle Regular School No Middle 05 08 2018   grade_5 50 3 6 35   1     0   0   48 47                       95 50 3 6 35   1     0   0   48 47                 95
2357897 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318002841 510 WOODWARD MS NORTH CAMPUS Middle Regular School No Middle 05 06 2018   grade_5 133 1 55 11   2     0   3   117 88                       205 133 1 55 11   2     0   3   117 88                 205
3025322 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2020   grade_5 11 0 25 43   0     0   1   40 40                       80 11 0 25 43   0     0   1   40 40                 80
3025336 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2020   grade_5 1 0 0 10   0     0   0   6 5                       11 1 0 0 10   0     0   0   6 5                 11
3026033 OK CANADIAN   school 4010650 09-I034   EL RENO 401065002103 510 LESLIE F ROBLYER LEARNING CTR Middle Regular School No Middle 05 06 2020   grade_5 107 8 49 24   0     0   17   115 90                       205 107 8 49 24   0     0   17   115 90                 205
3027049 OK COMANCHE   school 4006120 16-I001   CACHE 400612002757 530 CACHE 5TH AND 6TH GRADE MS Middle Regular School No Middle 05 06 2020   grade_5 71 10 21 26   1     0   15   80 64                       144 71 10 21 26   1     0   15   80 64                 144
3027269 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2020   grade_5 113 8 32 9   2     1   29   115 79                       194 113 8 32 9   2     1   29   115 79                 194
3027873 OK GARFIELD   school 4031950 24-I001   WAUKOMIS 403195002902 515 WAUKOMIS MS Middle Regular School No Middle 05 08 2020   grade_5 19 0 1 3   0     0   0   12 11                       23 19 0 1 3   0     0   0   12 11                 23
3028150 OK GARVIN   school 4033300 25-I038   WYNNEWOOD 403330001835 500 WYNNEWOOD MS Middle Regular School No Middle 05 08 2020   grade_5 36 4 5 4   0     0   7   33 23                       56 36 4 5 4   0     0   7   33 23                 56
3028351 OK GRANT   school 4024720 27-I090   POND CREEK-HUNTER 402472002764 505 POND CREEK-HUNTER MS Middle Regular School No Middle 05 08 2020   grade_5 22 0 2 0   0     0   3   14 13                       27 22 0 2 0   0     0   3   14 13                 27
3028380 OK GREER   school 4018780 28-I001   MANGUM 401878002321 510 MANGUM MS Middle Regular School No Middle 05 08 2020   grade_5 33 0 8 1   0     0   2   24 20                       44 33 0 8 1   0     0   2   24 20                 44
3028480 OK HASKELL   school 4028650 31-I020   STIGLER 402865001504 505 STIGLER MS Middle Regular School No Middle 05 08 2020   grade_5 50 0 8 34   2     0   7   50 51                       101 50 0 8 34   2     0   7   50 51                 101
3028757 OK JOHNSTON   school 4030060 35-I020   TISHOMINGO 403006001574 505 TISHOMINGO MS Middle Regular School No Middle 05 08 2020   grade_5 37 1 3 13   0     0   16   40 30                       70 37 1 3 13   0     0   16   40 30                 70
3028955 OK KINGFISHER   school 4016560 37-I007   KINGFISHER 401656001879 505 KINGFISHER MS Middle Regular School No Middle 05 08 2020   grade_5 73 1 31 4   0     0   17   64 62                       126 73 1 31 4   0     0   17   64 62                 126
3029807 OK MAYES   school 4007670 46-I032   CHOUTEAU-MAZIE 400767000318 505 CHOUTEAU-MAZIE MS Middle Regular School No Middle 05 08 2020   grade_5 22 0 4 9   0     0   11   23 23                       46 22 0 4 9   0     0   11   23 23                 46
3030181 OK MURRAY   school 4009510 50-I010   DAVIS 400951000411 505 DAVIS MS Middle Regular School No Middle 05 08 2020   grade_5 42 5 8 16   1     0   2   36 38                       74 42 5 8 16   1     0   2   36 38                 74
3030788 OK OKLAHOMA   school 4018630 55-I003   LUTHER 401863001949 505 LUTHER MS Middle Regular School No Middle 05 08 2020   grade_5 44 6 4 3   0     0   5   27 35                       62 44 6 4 3   0     0   5   27 35                 62
3031496 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002885 501 CAPITOL HILL MS Middle Regular School No Middle 05 08 2020   grade_5 11 13 213 4   1     2   2   130 116                       246 11 13 213 4   1     2   2   130 116                 246
3031500 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002275 503 BELLE ISLE MS Middle Regular School No Middle 05 08 2020   grade_5 71 21 48 2   5     0   7   79 75                       154 71 21 48 2   5     0   7   79 75                 154
3031504 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001877 508 CLASSEN MS OF ADVANCED STUDIES Middle Regular School No Middle 05 08 2020   grade_5 50 32 76 1   23     1   20   81 122                       203 50 32 76 1   23     1   20   81 122                 203
3031512 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001150 518 JEFFERSON MS Middle Regular School No Middle 05 08 2020   grade_5 24 40 160 8   2     2   16   128 124                       252 24 40 160 8   2     2   16   128 124                 252
3031516 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002912 519 MOON MS Middle Regular School No Middle 05 08 2020   grade_5 12 144 35 7   3     0   18   112 107                       219 12 144 35 7   3     0   18   112 107                 219
3031521 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001183 523 ROOSEVELT MS Middle Regular School No Middle 05 08 2020   grade_5 14 17 188 6   0     0   9   111 123                       234 14 17 188 6   0     0   9   111 123                 234
3031525 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002891 524 MARY GOLDA ROSS MS Middle Regular School No Middle 05 08 2020   grade_5 14 20 215 9   1     0   8   144 123                       267 14 20 215 9   1     0   8   144 123                 267
3031529 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001196 525 TAFT MS Middle Regular School No Middle 05 08 2020   grade_5 34 28 264 10   3     0   12   179 172                       351 34 28 264 10   3     0   12   179 172                 351
3031534 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277001202 530 WEBSTER MS Middle Regular School No Middle 05 08 2020   grade_5 25 60 120 9   3     0   22   114 125                       239 25 60 120 9   3     0   22   114 125                 239
3031538 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002394 535 JOHN MARSHALL MS Middle Regular School No Middle 05 08 2020   grade_5 22 92 71 5   4     2   16   108 104                       212 22 92 71 5   4     2   16   108 104                 212
3031545 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002897 550 WHEELER MS Middle Regular School No Middle 05 08 2020   grade_5 12 11 140 5   0     0   3   90 81                       171 12 11 140 5   0     0   3   90 81                 171
3031549 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002893 570 SOUTHEAST MS Middle Regular School No Middle 05 08 2020   grade_5 10 4 197 2   3     0   3   107 112                       219 10 4 197 2   3     0   3   107 112                 219
3031553 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002910 590 PUTNAM HEIGHTS ACADEMY MS Middle Regular School No Middle 05 08 2020   grade_5 1 1 2 1   0     0   0   5 0                       5 1 1 2 1   0     0   0   5 0                 5
3031824 OK OKMULGEE   school 4003810 56-I004   BEGGS 400381000120 505 BEGGS MS Middle Regular School No Middle 05 08 2020   grade_5 41 9 4 10   0     0   13   39 38                       77 41 9 4 10   0     0   13   39 38                 77
3032279 OK PAYNE   school 4009240 60-I067   CUSHING 400924000388 505 CUSHING MS Middle Regular School No Middle 05 08 2020   grade_5 78 2 10 13   1     0   17   67 54                       121 78 2 10 13   1     0   17   67 54                 121
3032600 OK PONTOTOC   school 4028800 62-I030   STONEWALL 402880002389 515 MCLISH MS Middle Regular School No Middle 05 08 2020   grade_5 19 1 0 7   0     0   6   21 12                       33 19 1 0 7   0     0   6   21 12                 33
3032730 OK POTTAWATOMIE   school 4000802 63-I010   NORTH ROCK CREEK 400080202908 510 NORTH ROCK CREEK INTERMEDIATE Middle Regular School No Middle 05 06 2020   grade_5 44 5 7 18   0     0   11   32 53                       85 44 5 7 18   0     0   11   32 53                 85
3033363 OK SEQUOYAH   school 4020880 68-I003   MULDROW 402088001967 510 MULDROW MS Middle Regular School No Middle 05 08 2020   grade_5 38 1 10 44   2     0   0   47 48                       95 38 1 10 44   2     0   0   47 48                 95
3034745 OK TULSA   school 4012720 72-I013   GLENPOOL 401272002892 510 GLENPOOL INTERMEDIATE SCHOOL Middle Regular School No Middle 05 06 2020   grade_5 84 6 16 43   15     1   53   126 92                       218 84 6 16 43   15     1   53   126 92                 218
3035053 OK WOODWARD   school 4033180 77-I001   WOODWARD 403318002841 510 WOODWARD MS NORTH CAMPUS Middle Regular School No Middle 05 06 2020   grade_5 138 2 48 11   2     0   2   106 97                       203 138 2 48 11   2     0   2   106 97                 203
3324383 OK ADAIR   school 4028710 01-I025   STILWELL 402871001513 505 STILWELL MS Middle Regular School No Middle 05 08 2021   grade_5 9 0 12 30   0     0   2   21 32                       53 9 0 12 30   0     0   2   21 32                 53
3324397 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2021   grade_5 1 0 0 2   0     0   0   2 1                       3 1 0 0 2   0     0   0   2 1                 3
3325101 OK CANADIAN   school 4010650 09-I034   EL RENO 401065002103 510 LESLIE F ROBLYER LEARNING CTR Middle Regular School No Middle 05 06 2021   grade_5 87 13 58 20   0     0   19   103 94                       197 87 13 58 20   0     0   19   103 94                 197
3326108 OK COMANCHE   school 4006120 16-I001   CACHE 400612029646 505 CACHE MS Middle Regular School No Middle 05 08 2021   grade_5 61 8 22 7   0     1   36   70 65                       135 61 8 22 7   0     1   36   70 65                 135
3326321 OK COMANCHE   school 4010710 16-I016   ELGIN 401071001980 505 ELGIN MS Middle Regular School No Middle 05 08 2021   grade_5 102 5 27 15   1     1   15   78 88                       166 102 5 27 15   1     1   15   78 88                 166

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