enrollments
Data source: Big Local News · About: Big Local
2,956 rows where grade = "grade_7" and state = "OK" sorted by black_int
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
478429 | 478429 | OK | GARVIN | school | 4017850 | 25-I009 | LINDSAY | 401785017850 | 505 | LINDSAY MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 61 | 0 | 9 | 17 | 1 | 0 | 2 | 48 | 42 | 90 | 61 | 0 | 9 | 17 | 1 | 0 | 2 | 48 | 42 | 90 | ||||||||||||||||||||||||||||||||
478473 | 478473 | OK | GARVIN | school | 4010860 | 25-I072 | ELMORE CITY-PERNELL | 401086002746 | 605 | ELMORE CITY JHS | Junior High | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 32 | 0 | 2 | 7 | 0 | 0 | 8 | 26 | 23 | 49 | 32 | 0 | 2 | 7 | 0 | 0 | 8 | 26 | 23 | 49 | ||||||||||||||||||||||||||||||||
478496 | 478496 | OK | GRADY | school | 4019890 | 26-C096 | MIDDLEBERG | 401989000949 | 105 | MIDDLEBERG PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 21 | 0 | 0 | 1 | 0 | 0 | 1 | 9 | 14 | 23 | 21 | 0 | 0 | 1 | 0 | 0 | 1 | 9 | 14 | 23 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
478536 | 478536 | OK | GRADY | school | 4020100 | 26-I002 | MINCO | 402010001668 | 505 | MINCO MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 38 | 0 | 4 | 0 | 0 | 0 | 3 | 22 | 23 | 45 | 38 | 0 | 4 | 0 | 0 | 0 | 3 | 22 | 23 | 45 | ||||||||||||||||||||||||||||||||
478562 | 478562 | OK | GRADY | school | 4002670 | 26-I056 | ALEX | 400267000019 | 105 | ALEX ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 22 | 0 | 0 | 6 | 0 | 0 | 1 | 16 | 13 | 29 | 22 | 0 | 0 | 6 | 0 | 0 | 1 | 16 | 13 | 29 | ||||||||||||||||||||||||||||||||
478578 | 478578 | OK | GRADY | school | 4026550 | 26-I068 | RUSH SPRINGS | 402655001391 | 505 | RUSH SPRINGS MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 28 | 0 | 0 | 6 | 1 | 0 | 1 | 20 | 16 | 36 | 28 | 0 | 0 | 6 | 1 | 0 | 1 | 20 | 16 | 36 | ||||||||||||||||||||||||||||||||
478592 | 478592 | OK | GRADY | school | 4005400 | 26-I095 | BRIDGE CREEK | 400540001674 | 505 | BRIDGE CREEK MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 85 | 0 | 4 | 2 | 0 | 0 | 15 | 57 | 49 | 106 | 85 | 0 | 4 | 2 | 0 | 0 | 15 | 57 | 49 | 106 | ||||||||||||||||||||||||||||||||
478619 | 478619 | OK | GRADY | school | 4031080 | 26-I099 | VERDEN | 403108001721 | 105 | VERDEN ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 8 | 0 | 0 | 2 | 0 | 0 | 2 | 4 | 8 | 12 | 8 | 0 | 0 | 2 | 0 | 0 | 2 | 4 | 8 | 12 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
478675 | 478675 | OK | GRANT | school | 4017020 | 27-I095 | DEER CREEK-LAMONT | 401702000788 | 105 | DEER CREEK-LAMONT ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 9 | 0 | 0 | 3 | 1 | 0 | 0 | 8 | 5 | 13 | 9 | 0 | 0 | 3 | 1 | 0 | 0 | 8 | 5 | 13 | ||||||||||||||||||||||||||||||||
478692 | 478692 | OK | GREER | school | 4018780 | 28-I001 | MANGUM | 401878002321 | 510 | MANGUM MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 37 | 0 | 11 | 0 | 0 | 0 | 2 | 25 | 25 | 50 | 37 | 0 | 11 | 0 | 0 | 0 | 2 | 25 | 25 | 50 | ||||||||||||||||||||||||||||||||
478706 | 478706 | OK | GREER | school | 4013290 | 28-I003 | GRANITE | 401329000616 | 105 | GRANITE ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 8 | 0 | 4 | 0 | 0 | 0 | 0 | 6 | 6 | 12 | 8 | 0 | 4 | 0 | 0 | 0 | 0 | 6 | 6 | 12 | ||||||||||||||||||||||||||||||||
478737 | 478737 | OK | HARPER | school | 4017220 | 30-I001 | LAVERNE | 401722000795 | 105 | LAVERNE ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 16 | 0 | 15 | 0 | 0 | 0 | 1 | 21 | 11 | 32 | 16 | 0 | 15 | 0 | 0 | 0 | 1 | 21 | 11 | 32 | ||||||||||||||||||||||||||||||||
478752 | 478752 | OK | HARPER | school | 4005760 | 30-I004 | BUFFALO | 400576000215 | 105 | BUFFALO ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 14 | 0 | 4 | 0 | 0 | 0 | 0 | 6 | 12 | 18 | 14 | 0 | 4 | 0 | 0 | 0 | 0 | 6 | 12 | 18 | ||||||||||||||||||||||||||||||||
478766 | 478766 | OK | HASKELL | school | 4032700 | 31-C010 | WHITEFIELD | 403270001806 | 105 | WHITEFIELD PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 4 | 3 | 7 | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 4 | 3 | 7 | ||||||||||||||||||||||||||||||||
478819 | 478819 | OK | HASKELL | school | 4016350 | 31-I043 | KEOTA | 401635000757 | 105 | KEOTA ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 17 | 0 | 0 | 14 | 0 | 0 | 0 | 18 | 13 | 31 | 17 | 0 | 0 | 14 | 0 | 0 | 0 | 18 | 13 | 31 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
478847 | 478847 | OK | HUGHES | school | 4032430 | 32-I005 | WETUMKA | 403243001796 | 105 | WETUMKA ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 7 | 0 | 1 | 15 | 0 | 0 | 3 | 14 | 12 | 26 | 7 | 0 | 1 | 15 | 0 | 0 | 3 | 14 | 12 | 26 | ||||||||||||||||||||||||||||||||
478875 | 478875 | OK | HUGHES | school | 4006270 | 32-I048 | CALVIN | 400627000243 | 105 | CALVIN ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 6 | 0 | 0 | 4 | 0 | 0 | 1 | 8 | 3 | 11 | 6 | 0 | 0 | 4 | 0 | 0 | 1 | 8 | 3 | 11 | ||||||||||||||||||||||||||||||||
478889 | 478889 | OK | HUGHES | school | 4029100 | 32-I054 | STUART | 402910001530 | 105 | STUART ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 1 | 0 | 2 | 8 | 0 | 0 | 1 | 5 | 7 | 12 | 1 | 0 | 2 | 8 | 0 | 0 | 1 | 5 | 7 | 12 | ||||||||||||||||||||||||||||||||
478905 | 478905 | OK | JACKSON | school | 4021180 | 33-I001 | NAVAJO | 402118001889 | 610 | NAVAJO JHS | Junior High | Regular School | No | Other | 07 | 09 | 2017 | grade_7 | 34 | 0 | 2 | 1 | 1 | 0 | 0 | 18 | 20 | 38 | 34 | 0 | 2 | 1 | 1 | 0 | 0 | 18 | 20 | 38 | ||||||||||||||||||||||||||||||||
478952 | 478952 | OK | JACKSON | school | 4010680 | 33-I025 | ELDORADO | 401068000491 | 105 | ELDORADO ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 4 | 0 | 3 | 0 | 0 | 0 | 1 | 5 | 3 | 8 | 4 | 0 | 3 | 0 | 0 | 0 | 1 | 5 | 3 | 8 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
478994 | 478994 | OK | JEFFERSON | school | 4029760 | 34-C003 | TERRAL | 402976002008 | 105 | TERRAL PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 2 | 0 | 0 | 1 | 0 | 0 | 2 | 4 | 1 | 5 | 2 | 0 | 0 | 1 | 0 | 0 | 2 | 4 | 1 | 5 | ||||||||||||||||||||||||||||||||
479004 | 479004 | OK | JEFFERSON | school | 4026610 | 34-I001 | RYAN | 402661001393 | 105 | RYAN ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 8 | 0 | 2 | 0 | 0 | 0 | 2 | 7 | 5 | 12 | 8 | 0 | 2 | 0 | 0 | 0 | 2 | 7 | 5 | 12 | ||||||||||||||||||||||||||||||||
479020 | 479020 | OK | JEFFERSON | school | 4025860 | 34-I014 | RINGLING | 402586001374 | 610 | RINGLING JHS | Junior High | Regular School | No | Other | 07 | 09 | 2017 | grade_7 | 23 | 0 | 1 | 14 | 0 | 0 | 0 | 17 | 21 | 38 | 23 | 0 | 1 | 14 | 0 | 0 | 0 | 17 | 21 | 38 | ||||||||||||||||||||||||||||||||
479046 | 479046 | OK | JOHNSTON | school | 4018870 | 35-C007 | MANNSVILLE | 401887000896 | 105 | MANNSVILLE PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 7 | 0 | 1 | 0 | 0 | 0 | 1 | 4 | 5 | 9 | 7 | 0 | 1 | 0 | 0 | 0 | 1 | 4 | 5 | 9 | ||||||||||||||||||||||||||||||||
479056 | 479056 | OK | JOHNSTON | school | 4025530 | 35-C010 | RAVIA | 402553001364 | 105 | RAVIA PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 3 | 0 | 1 | 2 | 0 | 0 | 7 | 6 | 7 | 13 | 3 | 0 | 1 | 2 | 0 | 0 | 7 | 6 | 7 | 13 | ||||||||||||||||||||||||||||||||
479066 | 479066 | OK | JOHNSTON | school | 4020040 | 35-I002 | MILL CREEK | 402004000979 | 105 | MILL CREEK ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 3 | 0 | 0 | 5 | 0 | 0 | 0 | 4 | 4 | 8 | 3 | 0 | 0 | 5 | 0 | 0 | 0 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||
479082 | 479082 | OK | JOHNSTON | school | 4030060 | 35-I020 | TISHOMINGO | 403006001574 | 505 | TISHOMINGO MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 33 | 0 | 4 | 14 | 0 | 0 | 12 | 36 | 27 | 63 | 33 | 0 | 4 | 14 | 0 | 0 | 12 | 36 | 27 | 63 | ||||||||||||||||||||||||||||||||
479094 | 479094 | OK | JOHNSTON | school | 4019980 | 35-I029 | MILBURN | 401998000976 | 105 | MILBURN ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 9 | 0 | 2 | 5 | 0 | 0 | 0 | 8 | 8 | 16 | 9 | 0 | 2 | 5 | 0 | 0 | 0 | 8 | 8 | 16 | ||||||||||||||||||||||||||||||||
479109 | 479109 | OK | JOHNSTON | school | 4008310 | 35-I035 | COLEMAN | 400831000347 | 105 | COLEMAN ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 5 | 0 | 0 | 0 | 0 | 0 | 7 | 4 | 8 | 12 | 5 | 0 | 0 | 0 | 0 | 0 | 7 | 4 | 8 | 12 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
479137 | 479137 | OK | KAY | school | 4023700 | 36-C027 | PECKHAM | 402370001257 | 105 | PECKHAM PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 5 | 0 | 0 | 0 | 0 | 0 | 2 | 4 | 3 | 7 | 5 | 0 | 0 | 0 | 0 | 0 | 2 | 4 | 3 | 7 | ||||||||||||||||||||||||||||||||
479157 | 479157 | OK | KAY | school | 4004630 | 36-I045 | BLACKWELL | 400463000152 | 505 | BLACKWELL MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 53 | 0 | 10 | 19 | 0 | 1 | 0 | 48 | 35 | 83 | 53 | 0 | 10 | 19 | 0 | 1 | 0 | 48 | 35 | 83 | ||||||||||||||||||||||||||||||||
479238 | 479238 | OK | KAY | school | 4021540 | 36-I125 | NEWKIRK | 402154001986 | 505 | NEWKIRK MS | Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 41 | 0 | 3 | 21 | 0 | 0 | 0 | 40 | 25 | 65 | 41 | 0 | 3 | 21 | 0 | 0 | 0 | 40 | 25 | 65 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
479350 | 479350 | OK | KIOWA | school | 4018270 | 38-I002 | LONE WOLF | 401827000873 | 105 | LONE WOLF ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 7 | 12 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 5 | 7 | 12 | ||||||||||||||||||||||||||||||||
479364 | 479364 | OK | KIOWA | school | 4029886 | 38-I003 | MOUNTAIN VIEW-GOTEBO | 402988602106 | 110 | MOUNTAIN VIEW-GOTEBO ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 8 | 0 | 3 | 2 | 0 | 0 | 3 | 7 | 9 | 16 | 8 | 0 | 3 | 2 | 0 | 0 | 3 | 7 | 9 | 16 | ||||||||||||||||||||||||||||||||
479408 | 479408 | OK | LATIMER | school | 4025590 | 39-I002 | RED OAK | 402559001365 | 105 | RED OAK ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 10 | 0 | 0 | 5 | 0 | 0 | 0 | 9 | 6 | 15 | 10 | 0 | 0 | 5 | 0 | 0 | 0 | 9 | 6 | 15 | ||||||||||||||||||||||||||||||||
479422 | 479422 | OK | LATIMER | school | 4005820 | 39-I003 | BUFFALO VALLEY | 400582000217 | 105 | BUFFALO VALLEY ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 3 | 0 | 1 | 6 | 0 | 0 | 0 | 9 | 1 | 10 | 3 | 0 | 1 | 6 | 0 | 0 | 0 | 9 | 1 | 10 | ||||||||||||||||||||||||||||||||
479436 | 479436 | OK | LATIMER | school | 4023400 | 39-I004 | PANOLA | 402340001242 | 105 | PANOLA ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 7 | 0 | 0 | 6 | 0 | 0 | 0 | 5 | 8 | 13 | 7 | 0 | 0 | 6 | 0 | 0 | 0 | 5 | 8 | 13 | ||||||||||||||||||||||||||||||||
479450 | 479450 | OK | LE FLORE | school | 4027450 | 40-C004 | SHADY POINT | 402745001450 | 105 | SHADY POINT PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 5 | 0 | 0 | 3 | 0 | 0 | 2 | 4 | 6 | 10 | 5 | 0 | 0 | 3 | 0 | 0 | 2 | 4 | 6 | 10 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
479504 | 479504 | OK | LE FLORE | school | 4014160 | 40-I003 | HEAVENER | 401416000670 | 105 | HEAVENER ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 12 | 0 | 25 | 27 | 0 | 0 | 0 | 33 | 31 | 64 | 12 | 0 | 25 | 27 | 0 | 0 | 0 | 33 | 31 | 64 | ||||||||||||||||||||||||||||||||
479532 | 479532 | OK | LE FLORE | school | 4017280 | 40-I016 | LE FLORE | 401728000840 | 105 | LEFLORE ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 6 | 0 | 1 | 13 | 0 | 0 | 0 | 14 | 6 | 20 | 6 | 0 | 1 | 13 | 0 | 0 | 0 | 14 | 6 | 20 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
479578 | 479578 | OK | LE FLORE | school | 4004950 | 40-I026 | BOKOSHE | 400495000422 | 615 | BOKOSHE JHS | Junior High | Regular School | No | Other | 07 | 09 | 2017 | grade_7 | 9 | 0 | 1 | 3 | 0 | 0 | 0 | 8 | 5 | 13 | 9 | 0 | 1 | 3 | 0 | 0 | 0 | 8 | 5 | 13 | ||||||||||||||||||||||||||||||||
479607 | 479607 | OK | LE FLORE | school | 4032970 | 40-I049 | WISTER | 403297001817 | 105 | WISTER ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 25 | 0 | 3 | 11 | 0 | 0 | 3 | 22 | 20 | 42 | 25 | 0 | 3 | 11 | 0 | 0 | 3 | 22 | 20 | 42 | ||||||||||||||||||||||||||||||||
479623 | 479623 | OK | LE FLORE | school | 4029400 | 40-I052 | TALIHINA | 402940001548 | 610 | TALIHINA JHS | Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 17 | 0 | 1 | 23 | 0 | 0 | 0 | 20 | 21 | 41 | 17 | 0 | 1 | 23 | 0 | 0 | 0 | 20 | 21 | 41 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
479665 | 479665 | OK | LE FLORE | school | 4003210 | 40-I091 | ARKOMA | 400321000075 | 205 | SINGLETON ES | Elementary | Regular School | No | Elementary | PK | 07 | 2017 | grade_7 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||
479681 | 479681 | OK | LINCOLN | school | 4032640 | 41-C005 | WHITE ROCK | 403264001804 | 105 | WHITE ROCK PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 3 | 0 | 0 | 1 | 0 | 0 | 4 | 4 | 4 | 8 | 3 | 0 | 0 | 1 | 0 | 0 | 4 | 4 | 4 | 8 | ||||||||||||||||||||||||||||||||
479723 | 479723 | OK | LINCOLN | school | 4032280 | 41-I004 | WELLSTON | 403228029696 | 505 | WELLSTON MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 27 | 0 | 2 | 5 | 0 | 0 | 0 | 21 | 13 | 34 | 27 | 0 | 2 | 5 | 0 | 0 | 0 | 21 | 13 | 34 | ||||||||||||||||||||||||||||||||
479795 | 479795 | OK | LINCOLN | school | 4002550 | 41-I134 | AGRA | 400255000015 | 105 | AGRA ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 22 | 0 | 2 | 9 | 0 | 0 | 0 | 15 | 18 | 33 | 22 | 0 | 2 | 9 | 0 | 0 | 0 | 15 | 18 | 33 | ||||||||||||||||||||||||||||||||
479840 | 479840 | OK | LOGAN | school | 4020910 | 42-I003 | MULHALL-ORLANDO | 402091001029 | 105 | MULHALL-ORLANDO ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 13 | 0 | 2 | 3 | 0 | 0 | 2 | 9 | 11 | 20 | 13 | 0 | 2 | 3 | 0 | 0 | 2 | 9 | 11 | 20 | ||||||||||||||||||||||||||||||||
479868 | 479868 | OK | LOVE | school | 4013380 | 43-C003 | GREENVILLE | 401338000622 | 105 | GREENVILLE PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 1 | 0 | 5 | 1 | 0 | 0 | 4 | 3 | 8 | 11 | 1 | 0 | 5 | 1 | 0 | 0 | 4 | 3 | 8 | 11 | ||||||||||||||||||||||||||||||||
479880 | 479880 | OK | LOVE | school | 4029850 | 43-I004 | THACKERVILLE | 402985002833 | 505 | THACKERVILLE MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 12 | 0 | 2 | 2 | 1 | 0 | 8 | 17 | 8 | 25 | 12 | 0 | 2 | 2 | 1 | 0 | 8 | 17 | 8 | 25 | ||||||||||||||||||||||||||||||||
479908 | 479908 | OK | LOVE | school | 4018990 | 43-I016 | MARIETTA | 401899000901 | 500 | MARIETTA MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 32 | 0 | 29 | 3 | 0 | 0 | 3 | 34 | 33 | 67 | 32 | 0 | 29 | 3 | 0 | 0 | 3 | 34 | 33 | 67 | ||||||||||||||||||||||||||||||||
479920 | 479920 | OK | MAJOR | school | 4025920 | 44-I001 | RINGWOOD | 402592001375 | 105 | RINGWOOD ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 19 | 0 | 10 | 1 | 0 | 0 | 0 | 14 | 16 | 30 | 19 | 0 | 10 | 1 | 0 | 0 | 0 | 14 | 16 | 30 | ||||||||||||||||||||||||||||||||
479935 | 479935 | OK | MAJOR | school | 4002720 | 44-I004 | ALINE-CLEO | 400272000022 | 105 | ALINE-CLEO ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 5 | 0 | 1 | 0 | 0 | 0 | 2 | 6 | 2 | 8 | 5 | 0 | 1 | 0 | 0 | 0 | 2 | 6 | 2 | 8 | ||||||||||||||||||||||||||||||||
479954 | 479954 | OK | MAJOR | school | 4011280 | 44-I084 | FAIRVIEW | 401128000537 | 510 | CHAMBERLAIN MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 47 | 0 | 1 | 4 | 0 | 0 | 0 | 24 | 28 | 52 | 47 | 0 | 1 | 4 | 0 | 0 | 0 | 24 | 28 | 52 | ||||||||||||||||||||||||||||||||
479998 | 479998 | OK | MARSHALL | school | 4016590 | 45-I003 | KINGSTON | 401659001948 | 505 | KINGSTON MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 35 | 0 | 4 | 45 | 0 | 0 | 8 | 45 | 47 | 92 | 35 | 0 | 4 | 45 | 0 | 0 | 8 | 45 | 47 | 92 | ||||||||||||||||||||||||||||||||
480010 | 480010 | OK | MAYES | school | 4032760 | 46-C035 | WICKLIFFE | 403276001809 | 105 | WICKLIFFE PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 4 | 0 | 0 | 6 | 0 | 0 | 0 | 5 | 5 | 10 | 4 | 0 | 0 | 6 | 0 | 0 | 0 | 5 | 5 | 10 | ||||||||||||||||||||||||||||||||
480020 | 480020 | OK | MAYES | school | 4023190 | 46-C043 | OSAGE | 402319001231 | 105 | OSAGE PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 8 | 0 | 0 | 5 | 0 | 0 | 0 | 6 | 7 | 13 | 8 | 0 | 0 | 5 | 0 | 0 | 0 | 6 | 7 | 13 | ||||||||||||||||||||||||||||||||
480063 | 480063 | OK | MAYES | school | 4002460 | 46-I002 | ADAIR | 400246000010 | 505 | ADAIR MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 31 | 0 | 1 | 38 | 0 | 0 | 1 | 38 | 33 | 71 | 31 | 0 | 1 | 38 | 0 | 0 | 1 | 38 | 33 | 71 | ||||||||||||||||||||||||||||||||
480077 | 480077 | OK | MAYES | school | 4026730 | 46-I016 | SALINA | 402673002005 | 505 | SALINA MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 18 | 0 | 1 | 31 | 0 | 0 | 2 | 28 | 24 | 52 | 18 | 0 | 1 | 31 | 0 | 0 | 2 | 28 | 24 | 52 | ||||||||||||||||||||||||||||||||
480110 | 480110 | OK | MAYES | school | 4007670 | 46-I032 | CHOUTEAU-MAZIE | 400767000319 | 110 | MAZIE ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 3 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 3 | 5 | 3 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||
480119 | 480119 | OK | MAYES | school | 4007670 | 46-I032 | CHOUTEAU-MAZIE | 400767000318 | 505 | CHOUTEAU-MAZIE MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 25 | 0 | 0 | 18 | 0 | 0 | 9 | 29 | 23 | 52 | 25 | 0 | 0 | 18 | 0 | 0 | 9 | 29 | 23 | 52 | ||||||||||||||||||||||||||||||||
480164 | 480164 | OK | MCCLAIN | school | 4031710 | 47-I005 | WASHINGTON | 403171002087 | 510 | WASHINGTON MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 52 | 0 | 5 | 11 | 0 | 0 | 1 | 35 | 34 | 69 | 52 | 0 | 5 | 11 | 0 | 0 | 1 | 35 | 34 | 69 | ||||||||||||||||||||||||||||||||
480178 | 480178 | OK | MCCLAIN | school | 4032010 | 47-I010 | WAYNE | 403201029699 | 505 | WAYNE MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 21 | 0 | 8 | 3 | 0 | 0 | 4 | 21 | 15 | 36 | 21 | 0 | 8 | 3 | 0 | 0 | 4 | 21 | 15 | 36 | ||||||||||||||||||||||||||||||||
480195 | 480195 | OK | MCCLAIN | school | 4025230 | 47-I015 | PURCELL | 402523002239 | 610 | PURCELL JHS | Junior High | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 44 | 0 | 25 | 11 | 1 | 0 | 6 | 44 | 43 | 87 | 44 | 0 | 25 | 11 | 1 | 0 | 6 | 44 | 43 | 87 | ||||||||||||||||||||||||||||||||
480242 | 480242 | OK | MCCURTAIN | school | 4012750 | 48-C023 | GLOVER | 401275000595 | 105 | GLOVER PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 5 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 5 | 7 | 5 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 5 | 7 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
480314 | 480314 | OK | MCCURTAIN | school | 4010440 | 48-I013 | EAGLETOWN | 401044000464 | 105 | EAGLETOWN ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 7 | 0 | 0 | 4 | 0 | 0 | 0 | 8 | 3 | 11 | 7 | 0 | 0 | 4 | 0 | 0 | 0 | 8 | 3 | 11 | ||||||||||||||||||||||||||||||||
480330 | 480330 | OK | MCCURTAIN | school | 4027840 | 48-I014 | SMITHVILLE | 402784001855 | 505 | SMITHVILLE MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 9 | 0 | 0 | 6 | 0 | 0 | 0 | 6 | 9 | 15 | 9 | 0 | 0 | 6 | 0 | 0 | 0 | 6 | 9 | 15 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
480385 | 480385 | OK | MCINTOSH | school | 4026580 | 49-C003 | RYAL | 402658001392 | 105 | RYAL PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 0 | 0 | 2 | 3 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 0 | 2 | 3 | 0 | 0 | 0 | 3 | 2 | 5 | ||||||||||||||||||||||||||||||||
480394 | 480394 | OK | MCINTOSH | school | 4028620 | 49-C016 | STIDHAM | 402862001501 | 105 | STIDHAM PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 4 | 0 | 1 | 7 | 0 | 0 | 1 | 5 | 8 | 13 | 4 | 0 | 1 | 7 | 0 | 0 | 1 | 5 | 8 | 13 | ||||||||||||||||||||||||||||||||
480449 | 480449 | OK | MCINTOSH | school | 4013680 | 49-I064 | HANNA | 401368000649 | 105 | HANNA ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 3 | 0 | 1 | 3 | 0 | 0 | 0 | 4 | 3 | 7 | 3 | 0 | 1 | 3 | 0 | 0 | 0 | 4 | 3 | 7 | ||||||||||||||||||||||||||||||||
480530 | 480530 | OK | MUSKOGEE | school | 4032130 | 51-I006 | WEBBERS FALLS | 403213001779 | 105 | WEBBERS FALLS ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 4 | 0 | 1 | 13 | 0 | 0 | 0 | 7 | 11 | 18 | 4 | 0 | 1 | 13 | 0 | 0 | 0 | 7 | 11 | 18 | ||||||||||||||||||||||||||||||||
480544 | 480544 | OK | MUSKOGEE | school | 4022830 | 51-I008 | OKTAHA | 402283001215 | 110 | OKTAHA ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 14 | 0 | 0 | 30 | 0 | 0 | 2 | 25 | 21 | 46 | 14 | 0 | 0 | 30 | 0 | 0 | 2 | 25 | 21 | 46 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
480664 | 480664 | OK | MUSKOGEE | school | 4031650 | 51-I074 | WARNER | 403165001750 | 105 | WARNER ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 28 | 0 | 1 | 31 | 0 | 0 | 6 | 36 | 30 | 66 | 28 | 0 | 1 | 31 | 0 | 0 | 6 | 36 | 30 | 66 | ||||||||||||||||||||||||||||||||
480678 | 480678 | OK | MUSKOGEE | school | 4024840 | 51-I088 | PORUM | 402484001306 | 105 | PORUM ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 12 | 0 | 0 | 20 | 0 | 0 | 1 | 17 | 16 | 33 | 12 | 0 | 0 | 20 | 0 | 0 | 1 | 17 | 16 | 33 | ||||||||||||||||||||||||||||||||
480695 | 480695 | OK | NOBLE | school | 4023850 | 52-I001 | PERRY | 402385002701 | 605 | PERRY JHS | Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 58 | 0 | 5 | 3 | 1 | 0 | 1 | 31 | 37 | 68 | 58 | 0 | 5 | 3 | 1 | 0 | 1 | 31 | 37 | 68 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
480721 | 480721 | OK | NOBLE | school | 4000020 | 52-I004 | FRONTIER | 400002025620 | 105 | FRONTIER ES | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 12 | 0 | 2 | 16 | 1 | 0 | 0 | 17 | 14 | 31 | 12 | 0 | 2 | 16 | 1 | 0 | 0 | 17 | 14 | 31 | ||||||||||||||||||||||||||||||||
480739 | 480739 | OK | NOBLE | school | 4020340 | 52-I006 | MORRISON | 402034002657 | 510 | MORRISON MS | Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 36 | 0 | 1 | 1 | 0 | 1 | 13 | 29 | 23 | 52 | 36 | 0 | 1 | 1 | 0 | 1 | 13 | 29 | 23 | 52 | ||||||||||||||||||||||||||||||||
480755 | 480755 | OK | NOWATA | school | 4000021 | 53-I003 | OKLAHOMA UNION | 400002102290 | 505 | OKLAHOMA UNION MS | Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 29 | 0 | 2 | 19 | 0 | 0 | 6 | 26 | 30 | 56 | 29 | 0 | 2 | 19 | 0 | 0 | 6 | 26 | 30 | 56 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
480796 | 480796 | OK | OKFUSKEE | school | 4003690 | 54-C029 | BEARDEN | 400369000114 | 105 | BEARDEN PUBLIC SCHOOL | Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 0 | 0 | 0 | 3 | 0 | 0 | 4 | 5 | 2 | 7 | 0 | 0 | 0 | 3 | 0 | 0 | 4 | 5 | 2 | 7 | ||||||||||||||||||||||||||||||||
480850 | 480850 | OK | OKFUSKEE | school | 4032220 | 54-I031 | WELEETKA | 403222001180 | 610 | WELEETKA JHS | Junior High | Regular School | No | Other | 07 | 09 | 2017 | grade_7 | 11 | 0 | 1 | 5 | 0 | 0 | 3 | 13 | 7 | 20 | 11 | 0 | 1 | 5 | 0 | 0 | 3 | 13 | 7 | 20 | ||||||||||||||||||||||||||||||||
480858 | 480858 | OK | OKFUSKEE | school | 4000782 | 54-I054 | GRAHAM-DUSTIN | 400078200608 | 105 | GRAHAM ES | Elementary | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 6 | 0 | 1 | 5 | 0 | 1 | 2 | 7 | 8 | 15 | 6 | 0 | 1 | 5 | 0 | 1 | 2 | 7 | 8 | 15 | ||||||||||||||||||||||||||||||||
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 |
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]);