enrollments
Data source: Big Local News · About: Big Local
590 rows where grade = "grade_7", state = "OK" and year = 2017 sorted by male
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
478123 | 478123 | OK | DEWEY | school | 4029430 | 22-I010 | TALOGA | 402943001549 | 105 | TALOGA ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 2 | ||||||||||||||||||||||||||||||||
479480 | 479480 | OK | LE FLORE | school | 4011400 | 40-C039 | FANSHAWE | 401140000541 | 105 | FANSHAWE PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | ||||||||||||||||||||||||||||||||
480650 | 480650 | OK | MUSKOGEE | school | 4005280 | 51-I046 | BRAGGS | 400528000185 | 105 | BRAGGS ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 7 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 11 | 11 | 7 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 11 | 11 | ||||||||||||||||||||||||||||||||
480707 | 480707 | OK | NOBLE | school | 4004360 | 52-I002 | BILLINGS | 400436000140 | 105 | BILLINGS ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||
482033 | 482033 | OK | OKLAHOMA | school | 4022770 | 55-I089 | OKLAHOMA CITY | 402277001885 | 706 | CLASSEN HS OF ADVANCED STUDIES | High School | Regular School | No | Other | 06 | 12 | 2017 | grade_7 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ||||||||||||||||||||||||||||||||
476786 | 476786 | OK | CIMARRON | school | 4011580 | 13-I010 | FELT | 401158000547 | 105 | FELT ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 5 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 5 | ||||||||||||||||||||||||||||||||
479250 | 479250 | OK | KINGFISHER | school | 4010050 | 37-I002 | DOVER | 401005000436 | 105 | DOVER ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 4 | 5 | 2 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 4 | 5 | ||||||||||||||||||||||||||||||||
483313 | 483313 | OK | PUSHMATAHA | school | 4030390 | 64-C004 | TUSKAHOMA | 403039001692 | 105 | TUSKAHOMA PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 3 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 4 | 5 | 3 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 4 | 5 | ||||||||||||||||||||||||||||||||
484186 | 484186 | OK | TILLMAN | school | 4009480 | 71-I009 | DAVIDSON | 400948000407 | 105 | DAVIDSON ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||
475721 | 475721 | OK | ATOKA | school | 4030360 | 03-I019 | TUSHKA | 403036001690 | 105 | TUSHKA ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 17 | 0 | 1 | 7 | 0 | 0 | 0 | 10 | 15 | 25 | 17 | 0 | 1 | 7 | 0 | 0 | 0 | 10 | 15 | 25 | ||||||||||||||||||||||||||||||||
475735 | 475735 | OK | ATOKA | school | 4006420 | 03-I026 | CANEY | 400642000250 | 105 | CANEY ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 8 | 0 | 1 | 3 | 0 | 0 | 3 | 10 | 5 | 15 | 8 | 0 | 1 | 3 | 0 | 0 | 3 | 10 | 5 | 15 | ||||||||||||||||||||||||||||||||
475897 | 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 | ||||||||||||||||||||||||||||||||
475909 | 475909 | OK | BLAINE | school | 4006480 | 06-I105 | CANTON | 400648000253 | 105 | CANTON ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 15 | 0 | 3 | 6 | 0 | 0 | 0 | 10 | 14 | 24 | 15 | 0 | 3 | 6 | 0 | 0 | 0 | 10 | 14 | 24 | ||||||||||||||||||||||||||||||||
476340 | 476340 | OK | CANADIAN | school | 4030630 | 09-I057 | UNION CITY | 403063001706 | 105 | UNION CITY ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 16 | 0 | 1 | 0 | 0 | 0 | 7 | 10 | 14 | 24 | 16 | 0 | 1 | 0 | 0 | 0 | 7 | 10 | 14 | 24 | ||||||||||||||||||||||||||||||||
476458 | 476458 | OK | CARTER | school | 4028350 | 10-I021 | SPRINGER | 402835001495 | 105 | SPRINGER ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 8 | 1 | 2 | 4 | 0 | 0 | 4 | 10 | 9 | 19 | 8 | 1 | 2 | 4 | 0 | 0 | 4 | 10 | 9 | 19 | ||||||||||||||||||||||||||||||||
477364 | 477364 | OK | COMANCHE | school | 4015420 | 16-I002 | INDIAHOMA | 401542000729 | 105 | INDIAHOMA ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 10 | 0 | 3 | 7 | 0 | 0 | 0 | 10 | 10 | 20 | 10 | 0 | 3 | 7 | 0 | 0 | 0 | 10 | 10 | 20 | ||||||||||||||||||||||||||||||||
478077 | 478077 | OK | DELAWARE | school | 4022410 | 21-I005 | OAKS-MISSION | 402241001099 | 105 | OAKS-MISSION ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 3 | 0 | 2 | 14 | 2 | 0 | 0 | 10 | 11 | 21 | 3 | 0 | 2 | 14 | 2 | 0 | 0 | 10 | 11 | 21 | ||||||||||||||||||||||||||||||||
478345 | 478345 | OK | GARFIELD | school | 4010170 | 24-I085 | DRUMMOND | 401017000438 | 105 | DRUMMOND ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 24 | 0 | 3 | 0 | 1 | 0 | 0 | 10 | 18 | 28 | 24 | 0 | 3 | 0 | 1 | 0 | 0 | 10 | 18 | 28 | ||||||||||||||||||||||||||||||||
478663 | 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 | ||||||||||||||||||||||||||||||||
478723 | 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 | ||||||||||||||||||||||||||||||||
479324 | 479324 | OK | KINGFISHER | school | 4022590 | 37-I105 | OKARCHE | 402259029687 | 610 | OKARCHE JHS | Junior High | Regular School | No | Other | 07 | 09 | 2017 | grade_7 | 16 | 0 | 1 | 2 | 0 | 0 | 2 | 10 | 11 | 21 | 16 | 0 | 1 | 2 | 0 | 0 | 2 | 10 | 11 | 21 | ||||||||||||||||||||||||||||||||
479470 | 479470 | OK | LE FLORE | school | 4014730 | 40-C014 | HODGEN | 401473000693 | 105 | HODGEN PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 1 | 1 | 0 | 16 | 0 | 0 | 1 | 10 | 9 | 19 | 1 | 1 | 0 | 16 | 0 | 0 | 1 | 10 | 9 | 19 | ||||||||||||||||||||||||||||||||
479546 | 479546 | OK | LE FLORE | school | 4006330 | 40-I017 | CAMERON | 400633000246 | 105 | CAMERON ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 11 | 0 | 5 | 5 | 0 | 0 | 1 | 10 | 12 | 22 | 11 | 0 | 5 | 5 | 0 | 0 | 1 | 10 | 12 | 22 | ||||||||||||||||||||||||||||||||
479637 | 479637 | OK | LE FLORE | school | 4032730 | 40-I062 | WHITESBORO | 403273001807 | 105 | WHITESBORO ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 8 | 0 | 0 | 10 | 0 | 0 | 0 | 10 | 8 | 18 | 8 | 0 | 0 | 10 | 0 | 0 | 0 | 10 | 8 | 18 | ||||||||||||||||||||||||||||||||
480782 | 480782 | OK | NOWATA | school | 4026640 | 53-I051 | SOUTH COFFEYVILLE | 402664001395 | 105 | SOUTH COFFEYVILLE ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 13 | 0 | 0 | 3 | 0 | 1 | 0 | 10 | 7 | 17 | 13 | 0 | 0 | 3 | 0 | 1 | 0 | 10 | 7 | 17 | ||||||||||||||||||||||||||||||||
482606 | 482606 | OK | PAWNEE | school | 4015750 | 59-C002 | JENNINGS | 401575000741 | 105 | JENNINGS PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 11 | 0 | 1 | 7 | 0 | 0 | 0 | 10 | 9 | 19 | 11 | 0 | 1 | 7 | 0 | 0 | 0 | 10 | 9 | 19 | ||||||||||||||||||||||||||||||||
483733 | 483733 | OK | SEMINOLE | school | 4006000 | 67-I015 | BUTNER | 400600000227 | 105 | BUTNER ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 8 | 1 | 2 | 5 | 0 | 0 | 2 | 10 | 8 | 18 | 8 | 1 | 2 | 5 | 0 | 0 | 2 | 10 | 8 | 18 | ||||||||||||||||||||||||||||||||
484019 | 484019 | OK | STEPHENS | school | 4007170 | 69-I034 | CENTRAL HIGH | 400717002756 | 600 | CENTRAL HIGH JHS | Junior High | Regular School | No | Other | 07 | 09 | 2017 | grade_7 | 20 | 0 | 1 | 2 | 0 | 0 | 2 | 10 | 15 | 25 | 20 | 0 | 1 | 2 | 0 | 0 | 2 | 10 | 15 | 25 | ||||||||||||||||||||||||||||||||
485274 | 485274 | OK | WAGONER | school | 4031350 | 73-I019 | WAGONER | 403135001536 | 505 | WAGONER MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 84 | 7 | 6 | 51 | 0 | 0 | 41 | 100 | 89 | 189 | 84 | 7 | 6 | 51 | 0 | 0 | 41 | 100 | 89 | 189 | ||||||||||||||||||||||||||||||||
480049 | 480049 | OK | MAYES | school | 4025200 | 46-I001 | PRYOR | 402520001323 | 610 | PRYOR JHS | Junior High | Regular School | No | Other | 07 | 09 | 2017 | grade_7 | 79 | 4 | 12 | 64 | 1 | 1 | 12 | 102 | 71 | 173 | 79 | 4 | 12 | 64 | 1 | 1 | 12 | 102 | 71 | 173 | ||||||||||||||||||||||||||||||||
484685 | 484685 | OK | TULSA | school | 4030240 | 72-I001 | TULSA | 403024002737 | 662 | MCLAIN JHS | Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 22 | 93 | 46 | 4 | 0 | 1 | 15 | 102 | 79 | 181 | 22 | 93 | 46 | 4 | 0 | 1 | 15 | 102 | 79 | 181 | ||||||||||||||||||||||||||||||||
481320 | 481320 | OK | OKLAHOMA | school | 4010590 | 55-I012 | EDMOND | 401059001326 | 525 | CENTRAL MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 124 | 12 | 35 | 1 | 4 | 0 | 9 | 103 | 82 | 185 | 124 | 12 | 35 | 1 | 4 | 0 | 9 | 103 | 82 | 185 | ||||||||||||||||||||||||||||||||
476327 | 476327 | OK | CANADIAN | school | 4010650 | 09-I034 | EL RENO | 401065000485 | 610 | ETTA DALE JHS | Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 81 | 5 | 52 | 23 | 0 | 0 | 29 | 105 | 85 | 190 | 81 | 5 | 52 | 23 | 0 | 0 | 29 | 105 | 85 | 190 | ||||||||||||||||||||||||||||||||
476681 | 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 | ||||||||||||||||||||||||||||||||
481032 | 481032 | OK | OKLAHOMA | school | 4025290 | 55-I001 | PUTNAM CITY | 402529001195 | 520 | COOPER MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 64 | 88 | 23 | 5 | 11 | 1 | 13 | 107 | 98 | 205 | 64 | 88 | 23 | 5 | 11 | 1 | 13 | 107 | 98 | 205 | ||||||||||||||||||||||||||||||||
482125 | 482125 | OK | OKLAHOMA | school | 4000796 | 55-E021 | OKLAHOMA CITY | 400079602829 | 981 | SANTA FE SOUTH MS | Charter | Regular School | Yes | Middle | 06 | 08 | 2017 | grade_7 | 3 | 2 | 200 | 2 | 0 | 0 | 0 | 109 | 98 | 207 | 3 | 2 | 200 | 2 | 0 | 0 | 0 | 109 | 98 | 207 | ||||||||||||||||||||||||||||||||
475937 | 475937 | OK | BRYAN | school | 4033601 | 07-I002 | ROCK CREEK | 403360129840 | 105 | ROCK CREEK ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 18 | 1 | 1 | 6 | 0 | 0 | 1 | 11 | 16 | 27 | 18 | 1 | 1 | 6 | 0 | 0 | 1 | 11 | 16 | 27 | ||||||||||||||||||||||||||||||||
475994 | 475994 | OK | BRYAN | school | 4003930 | 07-I040 | BENNINGTON | 400393000123 | 105 | BENNINGTON ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 17 | 0 | 1 | 9 | 0 | 0 | 1 | 11 | 17 | 28 | 17 | 0 | 1 | 9 | 0 | 0 | 1 | 11 | 17 | 28 | ||||||||||||||||||||||||||||||||
476226 | 476226 | OK | CANADIAN | school | 4009420 | 09-C070 | DARLINGTON | 400942000404 | 105 | DARLINGTON PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 2 | 0 | 1 | 19 | 0 | 0 | 0 | 11 | 11 | 22 | 2 | 0 | 1 | 19 | 0 | 0 | 0 | 11 | 11 | 22 | ||||||||||||||||||||||||||||||||
476743 | 476743 | OK | CHOCTAW | school | 4027960 | 12-I004 | SOPER | 402796001484 | 105 | SOPER ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 14 | 0 | 0 | 9 | 0 | 0 | 1 | 11 | 13 | 24 | 14 | 0 | 0 | 9 | 0 | 0 | 1 | 11 | 13 | 24 | ||||||||||||||||||||||||||||||||
478359 | 478359 | OK | GARFIELD | school | 4008790 | 24-I094 | COVINGTON-DOUGLAS | 400879000370 | 105 | COVINGTON-DOUGLAS ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 10 | 0 | 6 | 0 | 0 | 0 | 7 | 11 | 12 | 23 | 10 | 0 | 6 | 0 | 0 | 0 | 7 | 11 | 12 | 23 | ||||||||||||||||||||||||||||||||
479460 | 479460 | OK | LE FLORE | school | 4020190 | 40-C011 | MONROE | 402019000987 | 105 | MONROE PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 9 | 0 | 2 | 1 | 0 | 0 | 0 | 11 | 1 | 12 | 9 | 0 | 2 | 1 | 0 | 0 | 0 | 11 | 1 | 12 | ||||||||||||||||||||||||||||||||
479651 | 479651 | OK | LE FLORE | school | 4015120 | 40-I067 | HOWE | 401512000708 | 105 | HOWE ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 19 | 1 | 3 | 14 | 0 | 0 | 2 | 11 | 28 | 39 | 19 | 1 | 3 | 14 | 0 | 0 | 2 | 11 | 28 | 39 | ||||||||||||||||||||||||||||||||
480252 | 480252 | OK | MCCURTAIN | school | 4009720 | 48-C037 | DENISON | 400972000417 | 105 | DENISON PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 10 | 2 | 1 | 2 | 1 | 0 | 0 | 11 | 5 | 16 | 10 | 2 | 1 | 2 | 1 | 0 | 0 | 11 | 5 | 16 | ||||||||||||||||||||||||||||||||
480262 | 480262 | OK | MCCURTAIN | school | 4014890 | 48-C072 | HOLLY CREEK | 401489000702 | 105 | HOLLY CREEK PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 14 | 0 | 3 | 6 | 0 | 0 | 1 | 11 | 13 | 24 | 14 | 0 | 3 | 6 | 0 | 0 | 1 | 11 | 13 | 24 | ||||||||||||||||||||||||||||||||
480356 | 480356 | OK | MCCURTAIN | school | 4003660 | 48-I071 | BATTIEST | 400366000112 | 105 | BATTIEST ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 6 | 0 | 0 | 13 | 0 | 0 | 0 | 11 | 8 | 19 | 6 | 0 | 0 | 13 | 0 | 0 | 0 | 11 | 8 | 19 | ||||||||||||||||||||||||||||||||
480820 | 480820 | OK | OKFUSKEE | school | 4023340 | 54-I014 | PADEN | 402334001237 | 105 | PADEN ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 10 | 1 | 1 | 5 | 0 | 0 | 0 | 11 | 6 | 17 | 10 | 1 | 1 | 5 | 0 | 0 | 0 | 11 | 6 | 17 | ||||||||||||||||||||||||||||||||
482000 | 482000 | OK | OKLAHOMA | school | 4022770 | 55-I089 | OKLAHOMA CITY | 402277002326 | 511 | EMERSON ALTERNATIVE ED. (MS) | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 8 | 7 | 2 | 0 | 0 | 0 | 3 | 11 | 9 | 20 | 8 | 7 | 2 | 0 | 0 | 0 | 3 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||
483194 | 483194 | OK | POTTAWATOMIE | school | 4010500 | 63-I005 | EARLSBORO | 401050000469 | 105 | EARLSBORO ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 13 | 0 | 2 | 3 | 0 | 1 | 2 | 11 | 10 | 21 | 13 | 0 | 2 | 3 | 0 | 1 | 2 | 11 | 10 | 21 | ||||||||||||||||||||||||||||||||
483649 | 483649 | OK | SEMINOLE | school | 4005130 | 67-I003 | BOWLEGS | 400513000179 | 105 | BOWLEGS ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 10 | 0 | 0 | 6 | 0 | 0 | 1 | 11 | 6 | 17 | 10 | 0 | 0 | 6 | 0 | 0 | 1 | 11 | 6 | 17 | ||||||||||||||||||||||||||||||||
484087 | 484087 | OK | TEXAS | school | 4013590 | 70-I008 | GUYMON | 401359000637 | 610 | CENTRAL JHS | Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 36 | 7 | 167 | 0 | 8 | 0 | 2 | 110 | 110 | 220 | 36 | 7 | 167 | 0 | 8 | 0 | 2 | 110 | 110 | 220 | ||||||||||||||||||||||||||||||||
484985 | 484985 | OK | TULSA | school | 4008370 | 72-I006 | COLLINSVILLE | 400837000350 | 500 | COLLINSVILLE MS | Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 119 | 2 | 14 | 39 | 7 | 0 | 33 | 110 | 104 | 214 | 119 | 2 | 14 | 39 | 7 | 0 | 33 | 110 | 104 | 214 | ||||||||||||||||||||||||||||||||
476446 | 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 | ||||||||||||||||||||||||||||||||
477250 | 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 | ||||||||||||||||||||||||||||||||
485385 | 485385 | OK | WASHINGTON | school | 4003630 | 74-I030 | BARTLESVILLE | 400363029825 | 510 | MADISON MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 114 | 6 | 39 | 32 | 8 | 0 | 40 | 113 | 126 | 239 | 114 | 6 | 39 | 32 | 8 | 0 | 40 | 113 | 126 | 239 | ||||||||||||||||||||||||||||||||
484673 | 484673 | OK | TULSA | school | 4030240 | 72-I001 | TULSA | 403024002281 | 573 | THOREAU DEMONSTRATION ACADEMY | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 111 | 32 | 45 | 18 | 5 | 1 | 22 | 115 | 119 | 234 | 111 | 32 | 45 | 18 | 5 | 1 | 22 | 115 | 119 | 234 | ||||||||||||||||||||||||||||||||
481100 | 481100 | OK | OKLAHOMA | school | 4007620 | 55-I004 | CHOCTAW-NICOMA PARK | 400762002691 | 515 | NICOMA PARK MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 126 | 12 | 17 | 12 | 2 | 0 | 27 | 117 | 79 | 196 | 126 | 12 | 17 | 12 | 2 | 0 | 27 | 117 | 79 | 196 | ||||||||||||||||||||||||||||||||
484687 | 484687 | OK | TULSA | school | 4030240 | 72-I001 | TULSA | 403024001591 | 663 | MEMORIAL JHS | Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 40 | 88 | 59 | 8 | 3 | 1 | 13 | 118 | 94 | 212 | 40 | 88 | 59 | 8 | 3 | 1 | 13 | 118 | 94 | 212 | ||||||||||||||||||||||||||||||||
476035 | 476035 | OK | BRYAN | school | 4010350 | 07-I072 | DURANT | 401035000457 | 500 | DURANT MS | Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 115 | 8 | 28 | 56 | 7 | 0 | 26 | 119 | 121 | 240 | 115 | 8 | 28 | 56 | 7 | 0 | 26 | 119 | 121 | 240 | ||||||||||||||||||||||||||||||||
477221 | 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 | ||||||||||||||||||||||||||||||||
475749 | 475749 | OK | BEAVER | school | 4003750 | 04-I022 | BEAVER | 400375000115 | 105 | BEAVER ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 12 | 0 | 8 | 1 | 1 | 0 | 1 | 12 | 11 | 23 | 12 | 0 | 8 | 1 | 1 | 0 | 1 | 12 | 11 | 23 | ||||||||||||||||||||||||||||||||
476529 | 476529 | OK | CARTER | school | 4012060 | 10-I074 | FOX | 401206000562 | 105 | FOX ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 14 | 3 | 0 | 3 | 0 | 0 | 2 | 12 | 10 | 22 | 14 | 3 | 0 | 3 | 0 | 0 | 2 | 12 | 10 | 22 | ||||||||||||||||||||||||||||||||
476597 | 476597 | OK | CHEROKEE | school | 4023730 | 11-C031 | PEGGS | 402373001258 | 105 | PEGGS PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 3 | 0 | 0 | 19 | 0 | 0 | 0 | 12 | 10 | 22 | 3 | 0 | 0 | 19 | 0 | 0 | 0 | 12 | 10 | 22 | ||||||||||||||||||||||||||||||||
477290 | 477290 | OK | COAL | school | 4008730 | 15-C004 | COTTONWOOD | 400873000369 | 105 | COTTONWOOD PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 4 | 1 | 1 | 7 | 0 | 0 | 7 | 12 | 8 | 20 | 4 | 1 | 1 | 7 | 0 | 0 | 7 | 12 | 8 | 20 | ||||||||||||||||||||||||||||||||
477794 | 477794 | OK | CREEK | school | 4022860 | 19-I017 | OLIVE | 402286001217 | 105 | OLIVE ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 23 | 0 | 1 | 5 | 1 | 0 | 0 | 12 | 18 | 30 | 23 | 0 | 1 | 5 | 1 | 0 | 0 | 12 | 18 | 30 | ||||||||||||||||||||||||||||||||
477838 | 477838 | OK | CREEK | school | 4009750 | 19-I021 | DEPEW | 400975000418 | 105 | DEPEW ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 18 | 0 | 0 | 5 | 0 | 0 | 1 | 12 | 12 | 24 | 18 | 0 | 0 | 5 | 0 | 0 | 1 | 12 | 12 | 24 | ||||||||||||||||||||||||||||||||
478003 | 478003 | OK | DELAWARE | school | 4020430 | 21-C034 | MOSELEY | 402043001012 | 105 | MOSELEY PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 7 | 3 | 0 | 10 | 0 | 0 | 0 | 12 | 8 | 20 | 7 | 3 | 0 | 10 | 0 | 0 | 0 | 12 | 8 | 20 | ||||||||||||||||||||||||||||||||
478980 | 478980 | OK | JACKSON | school | 4004650 | 33-I054 | BLAIR | 400465000157 | 105 | BLAIR ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 13 | 0 | 8 | 1 | 0 | 0 | 0 | 12 | 10 | 22 | 13 | 0 | 8 | 1 | 0 | 0 | 0 | 12 | 10 | 22 | ||||||||||||||||||||||||||||||||
479123 | 479123 | OK | JOHNSTON | school | 4031590 | 35-I037 | WAPANUCKA | 403159001748 | 105 | WAPANUCKA ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 13 | 0 | 4 | 7 | 0 | 0 | 0 | 12 | 12 | 24 | 13 | 0 | 4 | 7 | 0 | 0 | 0 | 12 | 12 | 24 | ||||||||||||||||||||||||||||||||
480806 | 480806 | OK | OKFUSKEE | school | 4019260 | 54-I002 | MASON | 401926000909 | 105 | MASON ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 12 | 1 | 0 | 7 | 0 | 0 | 7 | 12 | 15 | 27 | 12 | 1 | 0 | 7 | 0 | 0 | 7 | 12 | 15 | 27 | ||||||||||||||||||||||||||||||||
482876 | 482876 | OK | PITTSBURG | school | 4016650 | 61-I014 | KIOWA | 401665000777 | 105 | KIOWA ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 11 | 0 | 0 | 11 | 0 | 0 | 0 | 12 | 10 | 22 | 11 | 0 | 0 | 11 | 0 | 0 | 0 | 12 | 10 | 22 | ||||||||||||||||||||||||||||||||
483079 | 483079 | OK | PONTOTOC | school | 4026280 | 62-I037 | ROFF | 402628001382 | 105 | ROFF ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 14 | 0 | 0 | 9 | 0 | 0 | 0 | 12 | 11 | 23 | 14 | 0 | 0 | 9 | 0 | 0 | 0 | 12 | 11 | 23 | ||||||||||||||||||||||||||||||||
483415 | 483415 | OK | ROGER MILLS | school | 4007500 | 65-I007 | CHEYENNE | 400750000299 | 105 | CHEYENNE ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 22 | 0 | 2 | 1 | 0 | 0 | 5 | 12 | 18 | 30 | 22 | 0 | 2 | 1 | 0 | 0 | 5 | 12 | 18 | 30 | ||||||||||||||||||||||||||||||||
484143 | 484143 | OK | TEXAS | school | 4012870 | 70-I060 | GOODWELL | 401287000597 | 105 | GOODWELL ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 14 | 0 | 4 | 0 | 1 | 0 | 0 | 12 | 7 | 19 | 14 | 0 | 4 | 0 | 1 | 0 | 0 | 12 | 7 | 19 | ||||||||||||||||||||||||||||||||
483949 | 483949 | OK | STEPHENS | school | 4010290 | 69-I001 | DUNCAN | 401029000921 | 505 | DUNCAN MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 126 | 16 | 60 | 18 | 2 | 0 | 11 | 120 | 113 | 233 | 126 | 16 | 60 | 18 | 2 | 0 | 11 | 120 | 113 | 233 | ||||||||||||||||||||||||||||||||
482192 | 482192 | OK | OKLAHOMA | school | 4000778 | 55-Z002 | OKLAHOMA VIRTUAL CHARTER ACAD | 400077802784 | 971 | OKLA. VIRTUAL CHARTER ACAD MS | Charter (Virtual) | Regular School | Yes | Middle | 06 | 08 | 2017 | grade_7 | 138 | 18 | 26 | 22 | 0 | 1 | 26 | 121 | 110 | 231 | 138 | 18 | 26 | 22 | 0 | 1 | 26 | 121 | 110 | 231 | ||||||||||||||||||||||||||||||||
477061 | 477061 | OK | CLEVELAND | school | 4020250 | 14-I002 | MOORE | 402025002821 | 690 | SOUTHRIDGE JHS | Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 116 | 13 | 27 | 14 | 19 | 0 | 38 | 122 | 105 | 227 | 116 | 13 | 27 | 14 | 19 | 0 | 38 | 122 | 105 | 227 | ||||||||||||||||||||||||||||||||
481038 | 481038 | OK | OKLAHOMA | school | 4025290 | 55-I001 | PUTNAM CITY | 402529001250 | 540 | MAYFIELD MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 48 | 48 | 135 | 10 | 3 | 0 | 12 | 122 | 134 | 256 | 48 | 48 | 135 | 10 | 3 | 0 | 12 | 122 | 134 | 256 | ||||||||||||||||||||||||||||||||
477218 | 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 | ||||||||||||||||||||||||||||||||
477528 | 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 | ||||||||||||||||||||||||||||||||
482971 | 482971 | OK | PITTSBURG | school | 4019440 | 61-I080 | MCALESTER | 401944000924 | 510 | PUTERBAUGH MS | Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 114 | 9 | 27 | 29 | 2 | 0 | 33 | 123 | 91 | 214 | 114 | 9 | 27 | 29 | 2 | 0 | 33 | 123 | 91 | 214 | ||||||||||||||||||||||||||||||||
478332 | 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 | ||||||||||||||||||||||||||||||||
484689 | 484689 | OK | TULSA | school | 4030240 | 72-I001 | TULSA | 403024002733 | 664 | WILL ROGERS COLLEGE JHS | Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 32 | 35 | 179 | 9 | 1 | 0 | 8 | 124 | 140 | 264 | 32 | 35 | 179 | 9 | 1 | 0 | 8 | 124 | 140 | 264 | ||||||||||||||||||||||||||||||||
481041 | 481041 | OK | OKLAHOMA | school | 4025290 | 55-I001 | PUTNAM CITY | 402529001301 | 550 | WESTERN OAKS MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 91 | 53 | 72 | 7 | 3 | 1 | 26 | 125 | 128 | 253 | 91 | 53 | 72 | 7 | 3 | 1 | 26 | 125 | 128 | 253 | ||||||||||||||||||||||||||||||||
484906 | 484906 | OK | TULSA | school | 4005490 | 72-I003 | BROKEN ARROW | 400549002095 | 525 | OLIVER MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 156 | 23 | 25 | 26 | 5 | 1 | 20 | 126 | 130 | 256 | 156 | 23 | 25 | 26 | 5 | 1 | 20 | 126 | 130 | 256 | ||||||||||||||||||||||||||||||||
477889 | 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 | ||||||||||||||||||||||||||||||||
476149 | 476149 | OK | CADDO | school | 4006960 | 08-I160 | CEMENT | 400696000276 | 105 | CEMENT ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 17 | 0 | 2 | 5 | 0 | 0 | 0 | 13 | 11 | 24 | 17 | 0 | 2 | 5 | 0 | 0 | 0 | 13 | 11 | 24 | ||||||||||||||||||||||||||||||||
476501 | 476501 | OK | CARTER | school | 4032940 | 10-I043 | WILSON | 403294001815 | 105 | WILSON ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 13 | 0 | 0 | 14 | 0 | 0 | 0 | 13 | 14 | 27 | 13 | 0 | 0 | 14 | 0 | 0 | 0 | 13 | 14 | 27 | ||||||||||||||||||||||||||||||||
476731 | 476731 | OK | CHOCTAW | school | 4012300 | 12-I002 | FORT TOWSON | 401230002790 | 605 | FORT TOWSON JHS | Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 22 | 1 | 0 | 10 | 0 | 0 | 6 | 13 | 26 | 39 | 22 | 1 | 0 | 10 | 0 | 0 | 6 | 13 | 26 | 39 | ||||||||||||||||||||||||||||||||
477378 | 477378 | OK | COMANCHE | school | 4028590 | 16-I003 | STERLING | 402859001498 | 105 | STERLING ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 18 | 0 | 2 | 3 | 0 | 0 | 5 | 13 | 15 | 28 | 18 | 0 | 2 | 3 | 0 | 0 | 5 | 13 | 15 | 28 | ||||||||||||||||||||||||||||||||
477394 | 477394 | OK | COMANCHE | school | 4012630 | 16-I004 | GERONIMO | 401263002732 | 505 | GERONIMO MS | Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 9 | 2 | 6 | 3 | 1 | 0 | 2 | 13 | 10 | 23 | 9 | 2 | 6 | 3 | 1 | 0 | 2 | 13 | 10 | 23 | ||||||||||||||||||||||||||||||||
477554 | 477554 | OK | COMANCHE | school | 4011700 | 16-I009 | FLETCHER | 401170000550 | 615 | FLETCHER JHS | Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 24 | 1 | 6 | 2 | 0 | 0 | 3 | 13 | 23 | 36 | 24 | 1 | 6 | 2 | 0 | 0 | 3 | 13 | 23 | 36 | ||||||||||||||||||||||||||||||||
478194 | 478194 | OK | GARFIELD | school | 4016740 | 24-I018 | KREMLIN-HILLSDALE | 401674000784 | 105 | KREMLIN-HILLSDALE ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 20 | 0 | 1 | 1 | 0 | 0 | 0 | 13 | 9 | 22 | 20 | 0 | 1 | 1 | 0 | 0 | 0 | 13 | 9 | 22 | ||||||||||||||||||||||||||||||||
478222 | 478222 | OK | GARFIELD | school | 4012420 | 24-I047 | GARBER | 401242000583 | 105 | GARBER ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 21 | 1 | 1 | 1 | 0 | 0 | 0 | 13 | 11 | 24 | 21 | 1 | 1 | 1 | 0 | 0 | 0 | 13 | 11 | 24 | ||||||||||||||||||||||||||||||||
478506 | 478506 | OK | GRADY | school | 4024150 | 26-C131 | PIONEER | 402415001274 | 105 | PIONEER PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 22 | 0 | 1 | 3 | 0 | 0 | 0 | 13 | 13 | 26 | 22 | 0 | 1 | 3 | 0 | 0 | 0 | 13 | 13 | 26 | ||||||||||||||||||||||||||||||||
478647 | 478647 | OK | GRANT | school | 4019620 | 27-I054 | MEDFORD | 401962000934 | 105 | MEDFORD ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 15 | 0 | 2 | 1 | 0 | 0 | 1 | 13 | 6 | 19 | 15 | 0 | 2 | 1 | 0 | 0 | 1 | 13 | 6 | 19 | ||||||||||||||||||||||||||||||||
478833 | 478833 | OK | HUGHES | school | 4020460 | 32-I001 | MOSS | 402046001013 | 105 | MOSS ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 15 | 0 | 3 | 4 | 0 | 0 | 1 | 13 | 10 | 23 | 15 | 0 | 3 | 4 | 0 | 0 | 1 | 13 | 10 | 23 | ||||||||||||||||||||||||||||||||
479034 | 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 | ||||||||||||||||||||||||||||||||
479264 | 479264 | OK | KINGFISHER | school | 4022950 | 37-I003 | LOMEGA | 402295001223 | 105 | LOMEGA ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 10 | 0 | 0 | 1 | 0 | 0 | 14 | 13 | 12 | 25 | 10 | 0 | 0 | 1 | 0 | 0 | 14 | 13 | 12 | 25 | ||||||||||||||||||||||||||||||||
480435 | 480435 | OK | MCINTOSH | school | 4014670 | 49-I027 | MIDWAY | 401467000687 | 105 | MIDWAY ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 15 | 5 | 0 | 4 | 0 | 0 | 1 | 13 | 12 | 25 | 15 | 5 | 0 | 4 | 0 | 0 | 1 | 13 | 12 | 25 |
Advanced export
JSON shape: default, array, newline-delimited
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]);