Data source: Big Local News · About: Big Local

595 rows where grade = "grade_7", state = "OK" and year = 2021 sorted by total

View and edit SQL

year

  • 2021 · 595

grade

  • grade_7 · 595
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
3325995 OK CLEVELAND   school 4021720 14-I029   NORMAN 402172001082 705 NORMAN HS High School Regular School No High 09 12 2021   grade_7 0 1 0 0   0     0   0   1 0                       1 0 1 0 0   0     0   0   1 0                 1
3326395 OK CRAIG   school 4032610 18-C001   WHITE OAK 403261001802 105 WHITE OAK PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 0 0 0 0   0     0   1   1 0                       1 0 0 0 0   0     0   1   1 0                 1
3324454 OK ATOKA   school 4013830 03-C021   HARMONY 401383000653 105 HARMONY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 8 0 0 1   0     0   1   5 5                       10 8 0 0 1   0     0   1   5 5                 10
3326435 OK CRAIG   school 4004830 18-I020   BLUEJACKET 400483002082 505 BLUEJACKET MS Middle Regular School No Middle 06 08 2021   grade_7 4 0 0 5   0     0   1   3 7                       10 4 0 0 5   0     0   1   3 7                 10
3326736 OK DELAWARE   school 4017310 21-C014   LEACH 401731000843 105 LEACH PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 3 1 0 5   0     0   1   4 6                       10 3 1 0 5   0     0   1   4 6                 10
3326746 OK DELAWARE   school 4016320 21-C030   KENWOOD 401632000756 105 KENWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 0 0 2 8   0     0   0   5 5                       10 0 0 2 8   0     0   0   5 5                 10
3327784 OK JOHNSTON   school 4020040 35-I002   MILL CREEK 402004000979 105 MILL CREEK ES Elementary Regular School No Elementary PK 08 2021   grade_7 7 0 0 2   0     0   1   5 5                       10 7 0 0 2   0     0   1   5 5                 10
3328175 OK LE FLORE   school 4020190 40-C011   MONROE 402019000987 105 MONROE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 6 0 1 2   0     0   1   3 7                       10 6 0 1 2   0     0   1   3 7                 10
3328734 OK MAYES   school 4032760 46-C035   WICKLIFFE 403276001809 105 WICKLIFFE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 0 0 0 7   0     0   3   6 4                       10 0 0 0 7   0     0   3   6 4                 10
3329239 OK MUSKOGEE   school 4000076 51-H000   OKLAHOMA SCHOOL FOR THE BLIND 400007602916 505 OKLAHOMA SCHL FOR THE BLIND MS Middle Special Education School No Middle 06 08 2021   grade_7 6 0 2 2   0     0   0   4 6                       10 6 0 2 2   0     0   0   4 6                 10
3330312 OK OKLAHOMA   school 4004110 55-I088   BETHANY 400411029722 110 CHILDREN'S CTR Elementary Regular School No Elementary PK 08 2021   grade_7 2 4 0 4   0     0   0   5 5                       10 2 4 0 4   0     0   0   5 5                 10
3331927 OK ROGER MILLS   school 4025800 65-I006   REYDON 402580001370 105 REYDON ES Elementary Regular School No Elementary PK 08 2021   grade_7 10 0 0 0   0     0   0   7 3                       10 10 0 0 0   0     0   0   7 3                 10
3331955 OK ROGER MILLS   school 4029310 65-I015   SWEETWATER 402931001538 105 SWEETWATER ES Elementary Regular School No Elementary PK 08 2021   grade_7 8 0 0 0   0     0   2   7 3                       10 8 0 0 0   0     0   2   7 3                 10
3325283 OK CARTER   school 4018090 10-I032   LONE GROVE 401809000869 505 LONE GROVE MS Middle Regular School No Middle 06 08 2021   grade_7 64 2 11 16   0     0   7   56 44                       100 64 2 11 16   0     0   7   56 44                 100
3326042 OK CLEVELAND   school 4017880 14-I070   LITTLE AXE 401788000103 505 LITTLE AXE MS Middle Regular School No Middle 06 08 2021   grade_7 52 2 17 10   0     1   19   52 49                       101 52 2 17 10   0     1   19   52 49                 101
3333823 OK WASHINGTON   school 4009810 74-I007   DEWEY 400981001910 510 DEWEY MS Middle Regular School No Middle 06 08 2021   grade_7 53 3 13 27   0     0   5   55 46                       101 53 3 13 27   0     0   5   55 46                 101
3327183 OK GARVIN   school 4023550 25-I018   PAULS VALLEY 402355002372 610 PAULS VALLEY JHS Junior High Regular School No Middle 07 09 2021   grade_7 54 7 19 19   0     1   3   55 48                       103 54 7 19 19   0     1   3   55 48                 103
3330563 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002894 545 STAR SPENCER MS Middle Regular School No Middle 07 08 2021   grade_7 10 66 12 2   0     0   15   53 52                       105 10 66 12 2   0     0   15   53 52                 105
3329643 OK OKLAHOMA   school 4000800 55-G008   EPIC BLENDED LEARNING CHARTER 400080002867 950 EPIC BLENDED CHARTER OKC MS Charter Regular School Yes Middle 06 08 2021   grade_7 451 217 187 19   2     0   180   532 524                       1056 451 217 187 19   2     0   180   532 524                 1056
3328815 OK MAYES   school 4018000 46-I017   LOCUST GROVE 401800000868 505 LOCUST GROVE MS Middle Regular School No Middle 06 08 2021   grade_7 39 0 1 44   1     0   21   56 50                       106 39 0 1 44   1     0   21   56 50                 106
3329092 OK MCCURTAIN   school 4005520 48-I074   BROKEN BOW 400552000211 505 RECTOR JOHNSON MS Middle Regular School No Middle 06 08 2021   grade_7 45 13 8 32   0     6   2   56 50                       106 45 13 8 32   0     6   2   56 50                 106
3331682 OK POTTAWATOMIE   school 4004230 63-I003   BETHEL 400423001417 505 BETHEL MS Middle Regular School No Middle 06 08 2021   grade_7 78 1 5 12   0     0   12   53 55                       108 78 1 5 12   0     0   12   53 55                 108
3332120 OK ROGERS   school 4031110 66-I008   VERDIGRIS 403111002277 615 VERDIGRIS JHS Junior High Regular School No Middle 07 09 2021   grade_7 57 1 7 21   1     0   22   70 39                       109 57 1 7 21   1     0   22   70 39                 109
3326124 OK COMANCHE   school 4015420 16-I002   INDIAHOMA 401542000729 105 INDIAHOMA ES Elementary Regular School No Elementary PK 08 2021   grade_7 6 0 0 5   0     0   0   9 2                       11 6 0 0 5   0     0   0   9 2                 11
3326367 OK COTTON   school 4029640 17-I101   TEMPLE 402964001557 105 TEMPLE ES Elementary Regular School No Elementary PK 08 2021   grade_7 9 1 1 0   0     0   0   7 4                       11 9 1 1 0   0     0   0   7 4                 11
3326726 OK DELAWARE   school 4008010 21-C006   CLEORA 400801000330 105 CLEORA PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 7 0 1 3   0     0   0   4 7                       11 7 0 1 3   0     0   0   4 7                 11
3327497 OK HASKELL   school 4032700 31-C010   WHITEFIELD 403270001806 105 WHITEFIELD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 8 0 1 2   0     0   0   6 5                       11 8 0 1 2   0     0   0   6 5                 11
3327507 OK HASKELL   school 4016620 31-I013   KINTA 401662000775 105 KINTA ES Elementary Regular School No Elementary PK 08 2021   grade_7 5 1 0 5   0     0   0   6 5                       11 5 1 0 5   0     0   0   6 5                 11
3328195 OK LE FLORE   school 4011400 40-C039   FANSHAWE 401140000541 105 FANSHAWE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 1 0 2 6   0     0   2   3 8                       11 1 0 2 6   0     0   2   3 8                 11
3328247 OK LE FLORE   school 4017280 40-I016   LE FLORE 401728000840 105 LEFLORE ES Elementary Regular School No Elementary PK 08 2021   grade_7 5 0 0 6   0     0   0   5 6                       11 5 0 0 6   0     0   0   5 6                 11
3329520 OK OKFUSKEE   school 4003690 54-C029   BEARDEN 400369000114 105 BEARDEN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 4 0 1 4   0     0   2   8 3                       11 4 0 1 4   0     0   2   8 3                 11
3330575 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002910 590 PUTNAM HEIGHTS ACADEMY MS Middle Regular School No Middle 05 08 2021   grade_7 2 4 4 1   0     0   0   9 2                       11 2 4 4 1   0     0   0   9 2                 11
3331346 OK PITTSBURG   school 4014100 61-C088   HAYWOOD 401410000665 105 HAYWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 3 0 0 6   0     0   2   3 8                       11 3 0 0 6   0     0   2   3 8                 11
3331899 OK PUSHMATAHA   school 4020640 64-I022   MOYERS 402064002091 105 MOYERS ES Elementary Regular School No Elementary PK 08 2021   grade_7 4 0 1 6   0     0   0   7 4                       11 4 0 1 6   0     0   0   7 4                 11
3331654 OK POTTAWATOMIE   school 4019560 63-I001   MCLOUD 401956000933 610 MCLOUD JHS Junior High Regular School No Middle 07 08 2021   grade_7 61 0 13 19   1     0   16   56 54                       110 61 0 13 19   1     0   16   56 54                 110
3333212 OK TULSA   school 4000792 72-E018   TULSA 400079202822 978 TULSA HONOR ACADEMY CHARTER Charter Regular School Yes Middle 05 08 2021   grade_7 8 0 98 0   3     0   2   56 55                       111 8 0 98 0   3     0   2   56 55                 111
3333116 OK TULSA   school 4030240 72-I001   TULSA 403024002920 518 CENTRAL MS Middle Regular School No Middle 06 08 2021   grade_7 20 65 6 8   0     0   13   70 42                       112 20 65 6 8   0     0   13   70 42                 112
3325268 OK CARTER   school 4024240 10-I027   PLAINVIEW 402424001279 505 PLAINVIEW MS Middle Regular School No Middle 06 08 2021   grade_7 65 2 19 8   9     0   10   55 58                       113 65 2 19 8   9     0   10   55 58                 113
3324848 OK CADDO   school 4003000 08-I020   ANADARKO 400300002101 510 ANADARKO MS Middle Regular School No Middle 06 08 2021   grade_7 22 3 19 70   0     0   0   54 60                       114 22 3 19 70   0     0   0   54 60                 114
3329670 OK OKLAHOMA   school 4000799 55-G009   DOVE SCHOOLS OF OKC 400079902856 950 DOVE SCIENCE ACADEMY MS Charter Regular School Yes Middle 06 08 2021   grade_7 11 24 70 1   5     0   3   65 49                       114 11 24 70 1   5     0   3   65 49                 114
3330648 OK OKLAHOMA   school 4000781 55-E001   OKLAHOMA CITY 400078102305 971 INDEPENDENCE CHARTER MS Charter Regular School Yes Middle 06 08 2021   grade_7 23 43 25 1   4     1   17   60 54                       114 23 43 25 1   4     1   17   60 54                 114
3331276 OK PAYNE   school 4009240 60-I067   CUSHING 400924000388 505 CUSHING MS Middle Regular School No Middle 05 08 2021   grade_7 75 0 8 13   0     0   18   62 52                       114 75 0 8 13   0     0   18   62 52                 114
3328708 OK MARSHALL   school 4018700 45-I002   MADILL 401870000888 505 MADILL MS Middle Regular School No Middle 06 08 2021   grade_7 35 3 54 9   1     0   13   65 50                       115 35 3 54 9   1     0   13   65 50                 115
3327325 OK GRADY   school 4005400 26-I095   BRIDGE CREEK 400540001674 505 BRIDGE CREEK MS Middle Regular School No Middle 06 08 2021   grade_7 89 0 9 5   0     0   15   66 52                       118 89 0 9 5   0     0   15   66 52                 118
3330317 OK OKLAHOMA   school 4004110 55-I088   BETHANY 400411029723 505 BETHANY MS Middle Regular School No Middle 06 08 2021   grade_7 72 1 28 6   1     0   10   57 61                       118 72 1 28 6   1     0   10   57 61                 118
3333119 OK TULSA   school 4030240 72-I001   TULSA 403024001601 530 DANIEL WEBSTER MS Middle Regular School No Middle 06 08 2021   grade_7 42 30 21 8   1     4   12   66 52                       118 42 30 21 8   1     4   12   66 52                 118
3333193 OK TULSA   school 4000780 72-E005   TULSA 400078002744 975 KIPP TULSA ACAD. COLLEGE PREP. Charter Regular School Yes Middle 05 08 2021   grade_7 4 83 21 3   0     0   7   67 51                       118 4 83 21 3   0     0   7   67 51                 118
3324399 OK ADAIR   school 4006930 01-I030   CAVE SPRINGS 400693002823 505 CAVE SPRINGS MS Middle Regular School No Middle 05 08 2021   grade_7 0 0 0 12   0     0   0   7 5                       12 0 0 0 12   0     0   0   7 5                 12
3325351 OK CHEROKEE   school 4018480 11-C010   LOWREY 401848000880 105 LOWREY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 4 0 0 8   0     0   0   9 3                       12 4 0 0 8   0     0   0   9 3                 12
3325491 OK CHEROKEE   school 4000755 11-T001   CHEROKEE IMMERSION CHARTER SCH 400075502720 971 CHEROKEE IMMERSION CHARTER SCH Charter Regular School Yes Elementary PK 08 2021   grade_7 0 0 0 12   0     0   0   7 5                       12 0 0 0 12   0     0   0   7 5                 12
3327765 OK JOHNSTON   school 4018870 35-C007   MANNSVILLE 401887000896 105 MANNSVILLE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 8 0 1 0   0     0   3   7 5                       12 8 0 1 0   0     0   3   7 5                 12
3328261 OK LE FLORE   school 4006330 40-I017   CAMERON 400633000246 105 CAMERON ES Elementary Regular School No Elementary PK 08 2021   grade_7 2 0 2 3   0     0   5   9 3                       12 2 0 2 3   0     0   5   9 3                 12
3331336 OK PITTSBURG   school 4029520 61-C056   TANNEHILL 402952001551 105 TANNEHILL PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 4 0 3 5   0     0   0   4 8                       12 4 0 3 5   0     0   0   4 8                 12
3332254 OK SEMINOLE   school 4006000 67-I015   BUTNER 400600000227 105 BUTNER ES Elementary Regular School No Elementary PK 08 2021   grade_7 8 0 0 2   0     0   2   2 10                       12 8 0 0 2   0     0   2   2 10                 12
3329201 OK MURRAY   school 4029160 50-I001   SULPHUR 402916002703 510 SULPHUR MS Middle Regular School No Middle 06 08 2021   grade_7 61 0 13 35   1     0   11   69 52                       121 61 0 13 35   1     0   11   69 52                 121
3329267 OK MUSKOGEE   school 4011970 51-I003   FORT GIBSON 401197000559 505 FORT GIBSON MS Middle Regular School No Middle 06 08 2021   grade_7 51 4 2 62   1     0   1   58 63                       121 51 4 2 62   1     0   1   58 63                 121
3333605 OK TULSA   school 4030600 72-I009   UNION 403060001461 510 UNION 6TH-7TH GRADE CTR Middle Regular School No Middle 06 07 2021   grade_7 308 177 495 45   73     3   122   605 618                       1223 308 177 495 45   73     3   122   605 618                 1223
3327063 OK GARFIELD   school 4010920 24-I057   ENID 401092002700 505 EMERSON MS Middle Regular School No Middle 06 08 2021   grade_7 58 2 41 1   1     11   10   60 64                       124 58 2 41 1   1     11   10   60 64                 124
3330568 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002897 550 WHEELER MS Middle Regular School No Middle 05 08 2021   grade_7 3 6 108 3   1     0   3   64 60                       124 3 6 108 3   1     0   3   64 60                 124
3331262 OK PAYNE   school 4023800 60-I056   PERKINS-TRYON 402380002379 510 PERKINS-TRYON MS Middle Regular School No Middle 06 08 2021   grade_7 92 5 5 21   1     0   0   69 55                       124 92 5 5 21   1     0   0   69 55                 124
3332144 OK SEMINOLE   school 4027300 67-I001   SEMINOLE 402730001441 505 SEMINOLE MS Middle Regular School No Middle 07 08 2021   grade_7 61 5 6 18   0     0   34   62 62                       124 61 5 6 18   0     0   34   62 62                 124
3326506 OK CREEK   school 4005460 19-I002   BRISTOW 400546002083 505 BRISTOW MS Middle Regular School No Middle 06 08 2021   grade_7 67 9 6 37   1     1   4   66 59                       125 67 9 6 37   1     1   4   66 59                 125
3326522 OK CREEK   school 4018840 19-I003   MANNFORD 401884000895 500 MANNFORD MS Middle Regular School No Middle 06 08 2021   grade_7 101 1 5 13   0     0   9   61 68                       129 101 1 5 13   0     0   9   61 68                 129
3332035 OK ROGERS   school 4006870 66-I002   CATOOSA 400687000811 510 WELLS MS Middle Regular School No Middle 06 08 2021   grade_7 57 1 31 14   3     0   23   69 60                       129 57 1 31 14   3     0   23   69 60                 129
3324474 OK ATOKA   school 4029010 03-I007   STRINGTOWN 402901001521 105 STRINGTOWN ES Elementary Regular School No Elementary PK 08 2021   grade_7 4 0 1 6   0     0   2   6 7                       13 4 0 1 6   0     0   2   6 7                 13
3324905 OK CADDO   school 4013080 08-I086   GRACEMONT 401308000606 105 GRACEMONT ES Elementary Regular School No Elementary PK 08 2021   grade_7 8 0 1 3   0     0   1   10 3                       13 8 0 1 3   0     0   1   10 3                 13
3325006 OK CANADIAN   school 4018900 09-C162   MAPLE 401890000897 105 MAPLE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 11 0 2 0   0     0   0   6 7                       13 11 0 2 0   0     0   0   6 7                 13
3326755 OK DELAWARE   school 4020430 21-C034   MOSELEY 402043001012 105 MOSELEY PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 4 0 4 5   0     0   0   9 4                       13 4 0 4 5   0     0   0   9 4                 13
3326893 OK ELLIS   school 4003240 23-I003   ARNETT 400324000077 105 ARNETT ES Elementary Regular School No Elementary PK 08 2021   grade_7 10 0 3 0   0     0   0   7 6                       13 10 0 3 0   0     0   0   7 6                 13
3328692 OK MAJOR   school 4007710 44-I092   CIMARRON 400771000508 105 CIMARRON ES Elementary Regular School No Elementary PK 08 2021   grade_7 12 0 0 1   0     0   0   6 7                       13 12 0 0 1   0     0   0   6 7                 13
3328940 OK MCCURTAIN   school 4011850 48-C001   FOREST GROVE 401185000552 105 FOREST GROVE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 9 1 1 2   0     0   0   6 7                       13 9 1 1 2   0     0   0   6 7                 13
3329376 OK MUSKOGEE   school 4005280 51-I046   BRAGGS 400528000185 105 BRAGGS ES Elementary Regular School No Elementary PK 08 2021   grade_7 8 0 0 4   0     0   1   6 7                       13 8 0 0 4   0     0   1   6 7                 13
3334041 OK WOODWARD   school 4021030 77-I003   SHARON-MUTUAL 402103001049 105 SHARON-MUTUAL ES Elementary Regular School No Elementary PK 08 2021   grade_7 12 0 0 1   0     0   0   4 9                       13 12 0 0 1   0     0   0   4 9                 13
3332331 OK SEQUOYAH   school 4026790 68-I001   SALLISAW 402679001403 510 SALLISAW MS Middle Regular School No Middle 06 08 2021   grade_7 51 1 13 45   2     0   19   70 61                       131 51 1 13 45   2     0   19   70 61                 131
3326767 OK DELAWARE   school 4015690 21-I001   JAY 401569000737 505 JAY MS Middle Regular School No Middle 06 08 2021   grade_7 35 1 23 43   3     0   27   80 52                       132 35 1 23 43   3     0   27   80 52                 132
3331172 OK PAWNEE   school 4008040 59-I006   CLEVELAND 400804000333 505 CLEVELAND MS Middle Regular School No Middle 06 08 2021   grade_7 90 2 8 26   0     1   5   71 61                       132 90 2 8 26   0     1   5   71 61                 132
3330747 OK OKLAHOMA   school 4000786 55-Z003   OKLAHOMA CONNECTIONS ACADEMY 400078602800 971 OKLAHOMA CONNECTIONS ACAD MS Charter (Virtual) Regular School Yes Middle 06 08 2021   grade_7 79 8 16 9   1     2   19   67 67                       134 79 8 16 9   1     2   19   67 67                 134
3331554 OK PONTOTOC   school 4006060 62-I016   BYNG 400606029751 610 BYNG JHS Junior High Regular School No Middle 07 09 2021   grade_7 53 2 7 44   1     0   28   68 67                       135 53 2 7 44   1     0   28   68 67                 135
3327255 OK GRADY   school 4007560 26-I001   CHICKASHA 400756002342 510 CHICKASHA MS Middle Regular School No Middle 07 08 2021   grade_7 87 7 16 17   2     0   7   69 67                       136 87 7 16 17   2     0   7   69 67                 136
3330524 OK OKLAHOMA   school 4022770 55-I089   OKLAHOMA CITY 402277002275 503 BELLE ISLE MS Middle Regular School No Middle 05 08 2021   grade_7 62 21 33 3   11     0   6   85 51                       136 62 21 33 3   11     0   6   85 51                 136
3328306 OK LE FLORE   school 4024870 40-I029   POTEAU 402487002915 510 7TH AND 8TH GRADE ACADEMIC CTR Middle Regular School No Middle 07 08 2021   grade_7 54 0 37 36   0     0   10   72 65                       137 54 0 37 36   0     0   10   72 65                 137
3325361 OK CHEROKEE   school 4021900 11-C014   NORWOOD 402190001092 105 NORWOOD PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 3 3 0 4   0     0   4   10 4                       14 3 3 0 4   0     0   4   10 4                 14
3326548 OK CREEK   school 4022860 19-I017   OLIVE 402286001217 105 OLIVE ES Elementary Regular School No Elementary PK 08 2021   grade_7 11 0 0 1   0     0   2   13 1                       14 11 0 0 1   0     0   2   13 1                 14
3326879 OK ELLIS   school 4011430 23-I002   FARGO 401143000542 105 FARGO ES Elementary Regular School No Elementary PK 08 2021   grade_7 10 0 2 1   0     0   1   5 9                       14 10 0 2 1   0     0   1   5 9                 14
3327135 OK GARVIN   school 4023430 25-I005   PAOLI 402343001244 105 PAOLI ES Elementary Regular School No Elementary PK 08 2021   grade_7 7 2 0 4   0     0   1   6 8                       14 7 2 0 4   0     0   1   6 8                 14
3327775 OK JOHNSTON   school 4025530 35-C010   RAVIA 402553001364 105 RAVIA PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 5 0 2 2   0     0   5   6 8                       14 5 0 2 2   0     0   5   6 8                 14
3328185 OK LE FLORE   school 4014730 40-C014   HODGEN 401473000693 105 HODGEN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 1 0 1 9   0     0   3   4 10                       14 1 0 1 9   0     0   3   4 10                 14
3328487 OK LINCOLN   school 4006690 41-I105   CARNEY 400669000261 105 CARNEY ES Elementary Regular School No Elementary PK 08 2021   grade_7 11 0 0 2   0     0   1   9 5                       14 11 0 0 2   0     0   1   9 5                 14
3331708 OK POTTAWATOMIE   school 4010500 63-I005   EARLSBORO 401050000469 105 EARLSBORO ES Elementary Regular School No Elementary PK 08 2021   grade_7 8 0 0 3   0     0   3   9 5                       14 8 0 0 3   0     0   3   9 5                 14
3332170 OK SEMINOLE   school 4005130 67-I003   BOWLEGS 400513000179 105 BOWLEGS ES Elementary Regular School No Elementary PK 08 2021   grade_7 7 0 0 4   0     0   3   8 6                       14 7 0 0 4   0     0   3   8 6                 14
3332692 OK TILLMAN   school 4030030 71-I008   TIPTON 403003001570 115 TIPTON ES Elementary Regular School No Elementary PK 08 2021   grade_7 4 2 6 2   0     0   0   7 7                       14 4 2 6 2   0     0   0   7 7                 14
3333144 OK TULSA   school 4030240 72-I001   TULSA 403024029767 667 TULSA MET JHS Junior High Regular School No Middle 07 08 2021   grade_7 3 1 10 0   0     0   0   6 8                       14 3 1 10 0   0     0   0   6 8                 14
3332063 OK ROGERS   school 4023040 66-I004   OOLOGAH-TALALA 402304001229 505 OOLOGAH-TALALA MS Middle Regular School No Middle 06 08 2021   grade_7 72 0 11 29   5     1   22   73 67                       140 72 0 11 29   5     1   22   73 67                 140
3326714 OK CUSTER   school 4008070 20-I099   CLINTON 400807000339 505 CLINTON MS Middle Regular School No Middle 07 08 2021   grade_7 42 2 71 12   0     0   16   79 64                       143 42 2 71 12   0     0   16   79 64                 143
3328928 OK MCCLAIN   school 4004680 47-I029   BLANCHARD 400468002240 510 BLANCHARD MS Middle Regular School No Middle 06 08 2021   grade_7 98 0 13 16   0     0   16   70 73                       143 98 0 13 16   0     0   16   70 73                 143
3333781 OK WAGONER   school 4031350 73-I019   WAGONER 403135001536 505 WAGONER MS Middle Regular School No Middle 06 08 2021   grade_7 69 8 6 25   0     0   40   57 91                       148 69 8 6 25   0     0   40   57 91                 148
3331738 OK POTTAWATOMIE   school 4029610 63-I092   TECUMSEH 402961001556 505 TECUMSEH MS Middle Regular School No Middle 06 08 2021   grade_7 89 2 14 20   0     0   24   75 74                       149 89 2 14 20   0     0   24   75 74                 149
3333379 OK TULSA   school 4005490 72-I003   BROKEN ARROW 400549029807 520 CHILDERS MS Middle Regular School No Middle 06 08 2021   grade_7 100 5 19 9   1     1   14   73 76                       149 100 5 19 9   1     1   14   73 76                 149
3324325 OK ADAIR   school 4026250 01-C024   ROCKY MOUNTAIN 402625001381 105 ROCKY MOUNTAIN PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 1 0 0 8   0     0   6   8 7                       15 1 0 0 8   0     0   6   8 7                 15
3324976 OK CANADIAN   school 4026010 09-C029   RIVERSIDE 402601001379 105 RIVERSIDE PUBLIC SCHOOL Elementary Regular School No Elementary PK 08 2021   grade_7 9 0 5 0   0     0   1   9 6                       15 9 0 5 0   0     0   1   9 6                 15

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