enrollments
Data source: Big Local News · About: Big Local
1,046 rows where grade = "grade_7", state = "AR" and year = 2019 sorted by white_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
388222 | 388222 | AR | school | 505170 | 901000 | DERMOTT SCHOOL DISTRICT | 50517000239 | 901003 | DERMOTT HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 1.0 | 21.0 | 0.0 | 1.0 | 23.0 | 1 | 21 | 0 | 1 | 23 | ||||||||||||||||||||||||||||||||||||||||||||
389998 | 389998 | AR | school | 513410 | 1705000 | VAN BUREN SCHOOL DISTRICT | 51341001631 | 1705034 | VAN BUREN FRESHMAN ACADEMY | Regular School | No | Secondary | 07 | 11 | 2019 | grade_7 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||
390014 | 390014 | AR | school | 513410 | 1705000 | VAN BUREN SCHOOL DISTRICT | 51341001650 | 1705703 | RIVER VALLEY VIRTUAL ACADEMY | Regular School | Yes | Other | KG | 12 | 2019 | grade_7 | 1.0 | 1.0 | 0.0 | 0.0 | 0.0 | 2.0 | 1 | 1 | 0 | 0 | 0 | 2 | ||||||||||||||||||||||||||||||||||||||||||
390046 | 390046 | AR | school | 505550 | 1802000 | EARLE SCHOOL DISTRICT | 50555000266 | 1802007 | EARLE HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 1.0 | 36.0 | 0.0 | 37.0 | 1 | 36 | 0 | 37 | ||||||||||||||||||||||||||||||||||||||||||||||
390142 | 390142 | AR | school | 508040 | 1803000 | WEST MEMPHIS SCHOOL DISTRICT | 50804000523 | 1803033 | EAST JUNIOR HIGH SCHOOL | Regular School | No | Middle | 07 | 09 | 2019 | grade_7 | 1.0 | 76.0 | 1.0 | 0.0 | 78.0 | 1 | 76 | 1 | 0 | 78 | ||||||||||||||||||||||||||||||||||||||||||||
392030 | 392030 | AR | school | 513080 | 2807000 | GREENE CO. TECH SCHOOL DIST. | 51308000015 | 2807004 | GREENE CTY TECH ELEMENTARY SCHOOL | Regular School | No | Elementary | KG | 07 | 2019 | grade_7 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||
392110 | 392110 | AR | school | 513080 | 2807000 | GREENE CO. TECH SCHOOL DIST. | 51308001546 | 2807011 | GREENE CTY TECH INTERMEDIATE SCHOOL | Regular School | No | Middle | 04 | 07 | 2019 | grade_7 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||
396030 | 396030 | AR | school | 500062 | 5440700 | KIPP DELTA PUBLIC SCHOOLS | 50006201614 | 5440708 | FORREST CITY COLLEGE PREPARATORY SCHOOL | Regular School | Yes | Middle | 05 | 08 | 2019 | grade_7 | 1.0 | 22.0 | 1.0 | 24.0 | 1 | 22 | 1 | 24 | ||||||||||||||||||||||||||||||||||||||||||||||
396430 | 396430 | AR | school | 509750 | 5703000 | MENA SCHOOL DISTRICT | 50975001665 | 5703703 | POLK COUNTY VIRTUAL ACADEMY | Regular School | Yes | Other | KG | 12 | 2019 | grade_7 | 1.0 | 1.0 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
399758 | 399758 | AR | school | 506330 | 6601000 | FORT SMITH SCHOOL DISTRICT | 50633000354 | 6601005 | BELLE POINT ALTERNATIVE CENTER | Alternative School | No | High | 07 | 12 | 2019 | grade_7 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | 3.0 | 1 | 1 | 1 | 0 | 0 | 3 | ||||||||||||||||||||||||||||||||||||||||||
402302 | 402302 | AR | school | 502880 | 7302000 | BEEBE SCHOOL DISTRICT | 50288001456 | 7302703 | BADGER ACADEMY | Alternative School | Yes | High | 07 | 12 | 2019 | grade_7 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 1 | 0 | 0 | 0 | 1 | ||||||||||||||||||||||||||||||||||||||||||||
393166 | 393166 | AR | school | 505410 | 3502000 | DOLLARWAY SCHOOL DISTRICT | 50541000252 | 3502009 | ROBERT F MOREHEAD MIDDLE SCHOO | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 2.0 | 74.0 | 1.0 | 1.0 | 0.0 | 78.0 | 2 | 74 | 1 | 1 | 0 | 78 | ||||||||||||||||||||||||||||||||||||||||||
393246 | 393246 | AR | school | 500026 | 3505000 | PINE BLUFF SCHOOL DISTRICT | 50002601338 | 3505044 | JACK ROBEY MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 2.0 | 254.0 | 3.0 | 1.0 | 1.0 | 1.0 | 262.0 | 2 | 254 | 3 | 1 | 1 | 1 | 262 | ||||||||||||||||||||||||||||||||||||||||
395966 | 395966 | AR | school | 500062 | 5440700 | KIPP DELTA PUBLIC SCHOOLS | 50006200659 | 5440702 | KIPP:DELTA COLLEGE PREP SCHOOL | Regular School | Yes | Middle | 06 | 08 | 2019 | grade_7 | 2.0 | 65.0 | 0.0 | 1.0 | 68.0 | 2 | 65 | 0 | 1 | 68 | ||||||||||||||||||||||||||||||||||||||||||||
396014 | 396014 | AR | school | 500062 | 5440700 | KIPP DELTA PUBLIC SCHOOLS | 50006201595 | 5440706 | KIPP BLYTHEVILLE COLLEGIATE HIGH SCHOOL | Regular School | Yes | High | 07 | 12 | 2019 | grade_7 | 2.0 | 20.0 | 2.0 | 2.0 | 0.0 | 26.0 | 2 | 20 | 2 | 2 | 0 | 26 | ||||||||||||||||||||||||||||||||||||||||||
397470 | 397470 | AR | school | 509000 | 6001000 | LITTLE ROCK SCHOOL DISTRICT | 50900001388 | 6001062 | MABELVALE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 2.0 | 163.0 | 36.0 | 1.0 | 0.0 | 2.0 | 204.0 | 2 | 163 | 36 | 1 | 0 | 2 | 204 | ||||||||||||||||||||||||||||||||||||||||
398750 | 398750 | AR | school | 500413 | 6056700 | CAPITOL CITY LIGHTHOUSE ACADEMY | 50041301615 | 6056703 | CAPITAL CITY LIGHTHOUSE UPPER ACADEMY | Regular School | Yes | Middle | 07 | 08 | 2019 | grade_7 | 2.0 | 15.0 | 0.0 | 17.0 | 2 | 15 | 0 | 17 | ||||||||||||||||||||||||||||||||||||||||||||||
398830 | 398830 | AR | school | 500036 | 6092000 | ARK. SCHOOL FOR THE DEAF | 50003601653 | 6092004 | SCHOOL FOR THE DEAF SCHOOL | Regular School | No | Other | PK | 12 | 2019 | grade_7 | 2.0 | 0.0 | 1.0 | 0.0 | 1.0 | 0.0 | 0.0 | 4.0 | 2 | 0 | 1 | 0 | 1 | 0 | 0 | 4 | ||||||||||||||||||||||||||||||||||||||
398814 | 398814 | AR | school | 500035 | 6091000 | ARK. SCHOOL FOR THE BLIND | 50003501420 | 6091002 | ARK. SCHOOL FOR THE BLIND H.S. | Special Education School | No | High | 07 | 12 | 2019 | grade_7 | 3.0 | 0.0 | 2.0 | 0.0 | 1.0 | 6.0 | 3 | 0 | 2 | 0 | 1 | 6 | ||||||||||||||||||||||||||||||||||||||||||
390174 | 390174 | AR | school | 508040 | 1803000 | WEST MEMPHIS SCHOOL DISTRICT | 50804000532 | 1803035 | WONDER JUNIOR HIGH SCHOOL | Regular School | No | Middle | 07 | 09 | 2019 | grade_7 | 4.0 | 129.0 | 1.0 | 134.0 | 4 | 129 | 1 | 134 | ||||||||||||||||||||||||||||||||||||||||||||||
393886 | 393886 | AR | school | 509360 | 3904000 | LEE COUNTY SCHOOL DISTRICT | 50936000675 | 3904011 | LEE HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 4.0 | 41.0 | 1.0 | 0.0 | 46.0 | 4 | 41 | 1 | 0 | 46 | ||||||||||||||||||||||||||||||||||||||||||||
396542 | 396542 | AR | school | 500405 | 5707000 | COSSATOT RIVER SCHOOL DISTRICT | 50040501620 | 5707024 | UMPIRE K-12 SCHOOL | Regular School | No | Other | KG | 12 | 2019 | grade_7 | 4.0 | 2.0 | 1.0 | 7.0 | 4 | 2 | 1 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||
397566 | 397566 | AR | school | 509000 | 6001000 | LITTLE ROCK SCHOOL DISTRICT | 50900001387 | 6001077 | CLOVERDALE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 4.0 | 100.0 | 56.0 | 0.0 | 1.0 | 161.0 | 4 | 100 | 56 | 0 | 1 | 161 | ||||||||||||||||||||||||||||||||||||||||||
395742 | 395742 | AR | school | 507290 | 5205000 | HARMONY GROVE SCHOOL DISTRICT | 50729001016 | 5205012 | SPARKMAN HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 5.0 | 0.0 | 2.0 | 0.0 | 7.0 | 5 | 0 | 2 | 0 | 7 | ||||||||||||||||||||||||||||||||||||||||||||
399054 | 399054 | AR | school | 506270 | 6201000 | FORREST CITY SCHOOL DISTRICT | 50627000345 | 6201010 | FORREST CITY JR. HIGH | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 5.0 | 112.0 | 4.0 | 0.0 | 1.0 | 2.0 | 124.0 | 5 | 112 | 4 | 0 | 1 | 2 | 124 | ||||||||||||||||||||||||||||||||||||||||
400926 | 400926 | AR | school | 512930 | 7009000 | STRONG-HUTTIG SCHOOL DISTRICT | 51293001663 | 7009050 | STRONG-HUTTIG SCHOOLS | Regular School | No | Other | PK | 12 | 2019 | grade_7 | 5.0 | 14.0 | 1.0 | 0.0 | 20.0 | 5 | 14 | 1 | 0 | 20 | ||||||||||||||||||||||||||||||||||||||||||||
402622 | 402622 | AR | school | 502670 | 7401000 | AUGUSTA SCHOOL DISTRICT | 50267000034 | 7401003 | AUGUSTA HIGH SCHOOL | Regular School | No | High | 06 | 12 | 2019 | grade_7 | 5.0 | 12.0 | 1.0 | 0.0 | 18.0 | 5 | 12 | 1 | 0 | 18 | ||||||||||||||||||||||||||||||||||||||||||||
392670 | 392670 | AR | school | 509780 | 3104000 | MINERAL SPRINGS SCHOOL DIST. | 50978000717 | 3104006 | MINERAL SPRINGS HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 6.0 | 18.0 | 6.0 | 1.0 | 2.0 | 33.0 | 6 | 18 | 6 | 1 | 2 | 33 | ||||||||||||||||||||||||||||||||||||||||||
394574 | 394574 | AR | school | 503750 | 4304000 | CABOT SCHOOL DISTRICT | 50375001019 | 4304703 | ACADEMIC CENTER FOR EXCELLENCE | Alternative School | Yes | High | 07 | 12 | 2019 | grade_7 | 6.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 7.0 | 6 | 0 | 0 | 0 | 0 | 1 | 7 | ||||||||||||||||||||||||||||||||||||||||
395934 | 395934 | AR | school | 509510 | 5404000 | MARVELL SCHOOL DISTRICT | 50951000694 | 5404032 | MARVELL-ELAINE HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 6.0 | 20.0 | 1.0 | 2.0 | 29.0 | 6 | 20 | 1 | 2 | 29 | ||||||||||||||||||||||||||||||||||||||||||||
393854 | 393854 | AR | school | 500061 | 3840700 | IMBODEN CHARTER SCHOOL DISTRICT | 50006100658 | 3840701 | IMBODEN AREA CHARTER SCHOOL | Regular School | Yes | Elementary | KG | 08 | 2019 | grade_7 | 7.0 | 1.0 | 0.0 | 8.0 | 7 | 1 | 0 | 8 | ||||||||||||||||||||||||||||||||||||||||||||||
395262 | 395262 | AR | school | 510950 | 4713000 | OSCEOLA SCHOOL DISTRICT | 51095001555 | 4713705 | OSCEOLA STEM CHARTER | Regular School | Yes | Middle | 05 | 08 | 2019 | grade_7 | 7.0 | 63.0 | 3.0 | 0.0 | 2.0 | 75.0 | 7 | 63 | 3 | 0 | 2 | 75 | ||||||||||||||||||||||||||||||||||||||||||
395326 | 395326 | AR | school | 504350 | 4802000 | CLARENDON SCHOOL DISTRICT | 50435000164 | 4802010 | CLARENDON HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 7.0 | 14.0 | 2.0 | 1.0 | 24.0 | 7 | 14 | 2 | 1 | 24 | ||||||||||||||||||||||||||||||||||||||||||||
397054 | 397054 | AR | school | 509000 | 6001000 | LITTLE ROCK SCHOOL DISTRICT | 50900000608 | 6001007 | DUNBAR MAGNET MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 7.0 | 129.0 | 11.0 | 0.0 | 0.0 | 2.0 | 149.0 | 7 | 129 | 11 | 0 | 0 | 2 | 149 | ||||||||||||||||||||||||||||||||||||||||
402158 | 402158 | AR | school | 500415 | 7241700 | OZARK MONTESSORI ACADEMY SPRINGDALE | 50041501612 | 7241701 | OZARK MONTESSORI ACADEMY SPRINGDALE | Regular School | Yes | Other | KG | 09 | 2019 | grade_7 | 7.0 | 0.0 | 4.0 | 0.0 | 0.0 | 0.0 | 0.0 | 11.0 | 7 | 0 | 4 | 0 | 0 | 0 | 0 | 11 | ||||||||||||||||||||||||||||||||||||||
395294 | 395294 | AR | school | 503630 | 4801000 | BRINKLEY SCHOOL DISTRICT | 50363000112 | 4801003 | BRINKLEY HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 8.0 | 22.0 | 1.0 | 0.0 | 1.0 | 32.0 | 8 | 22 | 1 | 0 | 1 | 32 | ||||||||||||||||||||||||||||||||||||||||||
395886 | 395886 | AR | school | 507680 | 5403000 | HELENA/ W.HELENA SCHOOL DIST. | 50768000476 | 5403019 | CENTRAL HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 8.0 | 79.0 | 1.0 | 1.0 | 89.0 | 8 | 79 | 1 | 1 | 89 | ||||||||||||||||||||||||||||||||||||||||||||
398702 | 398702 | AR | school | 500412 | 6054700 | RESPONSIVE ED SOLUTIONS QUEST MIDDLE SCHOOL OF LITTLE ROCK | 50041201603 | 6054703 | QUEST ACADEMY OF WEST LITTLE ROCK | Regular School | Yes | High | 06 | 12 | 2019 | grade_7 | 8.0 | 7.0 | 5.0 | 0.0 | 1.0 | 1.0 | 22.0 | 8 | 7 | 5 | 0 | 1 | 1 | 22 | ||||||||||||||||||||||||||||||||||||||||
388894 | 388894 | AR | school | 500068 | 1408000 | EMERSON-TAYLOR SCHOOL DISTRICT | 50006800109 | 1408007 | BRADLEY HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 9.0 | 13.0 | 1.0 | 23.0 | 9 | 13 | 1 | 23 | ||||||||||||||||||||||||||||||||||||||||||||||
399662 | 399662 | AR | school | 500076 | 6505000 | OZARK MOUNTAIN SCHOOL DISTRICT | 50007601643 | 6505015 | ST. JOE K-12 SCHOOL | Regular School | No | Other | KG | 12 | 2019 | grade_7 | 9.0 | 0.0 | 0.0 | 9.0 | 9 | 0 | 0 | 9 | ||||||||||||||||||||||||||||||||||||||||||||||
393710 | 393710 | AR | school | 500065 | 3704000 | LAFAYETTE COUNTY SCHOOL DISTRICT | 50006500727 | 3704013 | LAFAYETTE COUNTY HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 10.0 | 25.0 | 2.0 | 0.0 | 2.0 | 39.0 | 10 | 25 | 2 | 0 | 2 | 39 | ||||||||||||||||||||||||||||||||||||||||||
395566 | 395566 | AR | school | 508240 | 5102000 | JASPER SCHOOL DISTRICT | 50824000811 | 5102024 | OARK HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 10.0 | 0.0 | 10.0 | 10 | 0 | 10 | ||||||||||||||||||||||||||||||||||||||||||||||||
388270 | 388270 | AR | school | 508640 | 903000 | LAKESIDE SCHOOL DISTRICT (CHICOT COUNTY) | 50864000577 | 903017 | LAKESIDE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 11.0 | 49.0 | 13.0 | 0.0 | 73.0 | 11 | 49 | 13 | 0 | 73 | ||||||||||||||||||||||||||||||||||||||||||||
395582 | 395582 | AR | school | 500072 | 5106000 | DEER/MT. JUDEA SCHOOL DISTRICT | 50007201621 | 5106003 | DEER K-12 SCHOOL | Regular School | No | Other | PK | 12 | 2019 | grade_7 | 11.0 | 1.0 | 0.0 | 2.0 | 14.0 | 11 | 1 | 0 | 2 | 14 | ||||||||||||||||||||||||||||||||||||||||||||
395598 | 395598 | AR | school | 500072 | 5106000 | DEER/MT. JUDEA SCHOOL DISTRICT | 50007201630 | 5106004 | MT. JUDEA K-12 SCHOOL | Regular School | No | Other | PK | 12 | 2019 | grade_7 | 11.0 | 0.0 | 0.0 | 0.0 | 0.0 | 11.0 | 11 | 0 | 0 | 0 | 0 | 11 | ||||||||||||||||||||||||||||||||||||||||||
391006 | 391006 | AR | school | 507140 | 2304000 | GUY-PERKINS SCHOOL DISTRICT | 50714000434 | 2304022 | GUY-PERKINS HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 12.0 | 4.0 | 2.0 | 0.0 | 0.0 | 18.0 | 12 | 4 | 2 | 0 | 0 | 18 | ||||||||||||||||||||||||||||||||||||||||||
396478 | 396478 | AR | school | 500073 | 5706000 | OUACHITA RIVER SCHOOL DISTRICT | 50007301642 | 5706009 | ODEN SCHOOLS | Regular School | No | Other | KG | 12 | 2019 | grade_7 | 13.0 | 2.0 | 0.0 | 0.0 | 15.0 | 13 | 2 | 0 | 0 | 15 | ||||||||||||||||||||||||||||||||||||||||||||
400638 | 400638 | AR | school | 510200 | 6901000 | MOUNTAIN VIEW SCHOOL DISTRICT | 51020000965 | 6901012 | RURAL SPECIAL HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 13.0 | 2.0 | 15.0 | 13 | 2 | 15 | ||||||||||||||||||||||||||||||||||||||||||||||||
394286 | 394286 | AR | school | 505850 | 4302000 | ENGLAND SCHOOL DISTRICT | 50585000296 | 4302018 | ENGLAND HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 14.0 | 18.0 | 4.0 | 0.0 | 36.0 | 14 | 18 | 4 | 0 | 36 | ||||||||||||||||||||||||||||||||||||||||||||
394670 | 394670 | AR | school | 508130 | 4401000 | HUNTSVILLE SCHOOL DISTRICT | 50813001035 | 4401012 | ST. PAUL HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 14.0 | 1.0 | 1.0 | 0.0 | 16.0 | 14 | 1 | 1 | 0 | 16 | ||||||||||||||||||||||||||||||||||||||||||||
395070 | 395070 | AR | school | 503320 | 4702000 | BLYTHEVILLE SCHOOL DISTRICT | 50332000099 | 4702012 | BLYTHEVILLE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 14.0 | 106.0 | 5.0 | 1.0 | 126.0 | 14 | 106 | 5 | 1 | 126 | ||||||||||||||||||||||||||||||||||||||||||||
398334 | 398334 | AR | school | 500059 | 6040700 | ACADEMICS PLUS CHARTER SCHOOL | 50005901619 | 6040704 | SCOTT CHARTER SCHOOL | Regular School | Yes | Elementary | KG | 08 | 2019 | grade_7 | 14.0 | 10.0 | 2.0 | 0.0 | 0.0 | 26.0 | 14 | 10 | 2 | 0 | 0 | 26 | ||||||||||||||||||||||||||||||||||||||||||
398638 | 398638 | AR | school | 500402 | 6050700 | JACKSONVILLE LIGHTHOUSE CHARTER | 50040201560 | 6050703 | JACKSONVILLE LIGHTHOUSE COLLEGE PREP ACADEMY HIGH | Regular School | Yes | High | 07 | 12 | 2019 | grade_7 | 14.0 | 25.0 | 8.0 | 0.0 | 0.0 | 0.0 | 1.0 | 48.0 | 14 | 25 | 8 | 0 | 0 | 0 | 1 | 48 | ||||||||||||||||||||||||||||||||||||||
390398 | 390398 | AR | school | 506210 | 2002000 | FORDYCE SCHOOL DISTRICT | 50621000335 | 2002007 | FORDYCE HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 15.0 | 30.0 | 3.0 | 0.0 | 48.0 | 15 | 30 | 3 | 0 | 48 | ||||||||||||||||||||||||||||||||||||||||||||
390446 | 390446 | AR | school | 505500 | 2104000 | DUMAS SCHOOL DISTRICT | 50550000261 | 2104020 | DUMAS JUNIOR HIGH SCHOOL | Regular School | No | Middle | 07 | 09 | 2019 | grade_7 | 15.0 | 64.0 | 23.0 | 0.0 | 1.0 | 103.0 | 15 | 64 | 23 | 0 | 1 | 103 | ||||||||||||||||||||||||||||||||||||||||||
398574 | 398574 | AR | school | 500398 | 6047700 | ESTEM HIGH CHARTER | 50039801658 | 6047705 | ESTEM EAST VILLAGE JUNIOR HIGH PUBLIC CHARTER SCHOOL | Regular School | Yes | Middle | 07 | 09 | 2019 | grade_7 | 15.0 | 103.0 | 13.0 | 1.0 | 2.0 | 6.0 | 140.0 | 15 | 103 | 13 | 1 | 2 | 6 | 140 | ||||||||||||||||||||||||||||||||||||||||
399694 | 399694 | AR | school | 500076 | 6505000 | OZARK MOUNTAIN SCHOOL DISTRICT | 50007601645 | 6505017 | BRUNO-PYATT K-12 SCHOOL | Regular School | No | Other | KG | 12 | 2019 | grade_7 | 15.0 | 1.0 | 0.0 | 0.0 | 16.0 | 15 | 1 | 0 | 0 | 16 | ||||||||||||||||||||||||||||||||||||||||||||
400670 | 400670 | AR | school | 510200 | 6901000 | MOUNTAIN VIEW SCHOOL DISTRICT | 51020001087 | 6901016 | TIMBO HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 15.0 | 1.0 | 16.0 | 15 | 1 | 16 | ||||||||||||||||||||||||||||||||||||||||||||||||
402798 | 402798 | AR | school | 500041 | 7509000 | WESTERN YELL CO. SCHOOL DIST. | 50004101315 | 7509033 | WESTERN YELL CO. HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 15.0 | 0.0 | 5.0 | 1.0 | 3.0 | 24.0 | 15 | 0 | 5 | 1 | 3 | 24 | ||||||||||||||||||||||||||||||||||||||||||
392334 | 392334 | AR | school | 507840 | 2903000 | HOPE SCHOOL DISTRICT | 50784000805 | 2903013 | HOPE ACADEMY OF PUBLIC SERVICE | Alternative School | No | Middle | 05 | 09 | 2019 | grade_7 | 16.0 | 18.0 | 21.0 | 0.0 | 0.0 | 1.0 | 56.0 | 16 | 18 | 21 | 0 | 0 | 1 | 56 | ||||||||||||||||||||||||||||||||||||||||
397086 | 397086 | AR | school | 509000 | 6001000 | LITTLE ROCK SCHOOL DISTRICT | 50900000617 | 6001013 | HENDERSON MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 16.0 | 110.0 | 23.0 | 2.0 | 2.0 | 153.0 | 16 | 110 | 23 | 2 | 2 | 153 | ||||||||||||||||||||||||||||||||||||||||||
398654 | 398654 | AR | school | 500402 | 6050700 | JACKSONVILLE LIGHTHOUSE CHARTER | 50040201531 | 6050705 | FLIGHTLINE UPPER ACADEMY | Regular School | Yes | Middle | 05 | 08 | 2019 | grade_7 | 16.0 | 12.0 | 4.0 | 0.0 | 3.0 | 0.0 | 0.0 | 35.0 | 16 | 12 | 4 | 0 | 3 | 0 | 0 | 35 | ||||||||||||||||||||||||||||||||||||||
386878 | 386878 | AR | school | 504980 | 402000 | DECATUR SCHOOL DISTRICT | 50498001602 | 402011 | DECATUR MIDDLE SCHOOL | Regular School | No | Middle | 01 | 08 | 2019 | grade_7 | 17.0 | 1.0 | 17.0 | 0.0 | 1.0 | 0.0 | 36.0 | 17 | 1 | 17 | 0 | 1 | 0 | 36 | ||||||||||||||||||||||||||||||||||||||||
401438 | 401438 | AR | school | 506120 | 7203000 | FAYETTEVILLE SCHOOL DISTRICT | 50612001636 | 7203703 | FAYETTEVILLE VIRTUAL ACADEMY A DISTRICT CONVERSION CHARTER SCHOOL | Regular School | Yes | Other | 04 | 12 | 2019 | grade_7 | 17.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3.0 | 20.0 | 17 | 0 | 0 | 0 | 0 | 3 | 20 | ||||||||||||||||||||||||||||||||||||||||
387934 | 387934 | AR | school | 507710 | 601000 | HERMITAGE SCHOOL DISTRICT | 50771000485 | 601007 | HERMITAGE HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 18.0 | 2.0 | 5.0 | 25.0 | 18 | 2 | 5 | 25 | ||||||||||||||||||||||||||||||||||||||||||||||
397006 | 397006 | AR | school | 509000 | 6001000 | LITTLE ROCK SCHOOL DISTRICT | 50900000621 | 6001003 | MANN MAGNET MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 19.0 | 190.0 | 40.0 | 1.0 | 0.0 | 1.0 | 251.0 | 19 | 190 | 40 | 1 | 0 | 1 | 251 | ||||||||||||||||||||||||||||||||||||||||
399678 | 399678 | AR | school | 500076 | 6505000 | OZARK MOUNTAIN SCHOOL DISTRICT | 50007601646 | 6505016 | WESTERN GROVE K-12 SCHOOL | Regular School | No | Other | KG | 12 | 2019 | grade_7 | 19.0 | 1.0 | 1.0 | 21.0 | 19 | 1 | 1 | 21 | ||||||||||||||||||||||||||||||||||||||||||||||
392254 | 392254 | AR | school | 503300 | 2901000 | BLEVINS SCHOOL DISTRICT | 50330000090 | 2901002 | BLEVINS HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 22.0 | 4.0 | 6.0 | 0.0 | 0.0 | 32.0 | 22 | 4 | 6 | 0 | 0 | 32 | ||||||||||||||||||||||||||||||||||||||||||
394190 | 394190 | AR | school | 512180 | 4204000 | SCRANTON SCHOOL DISTRICT | 51218000981 | 4204019 | SCRANTON HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 22.0 | 0.0 | 1.0 | 0.0 | 23.0 | 22 | 0 | 1 | 0 | 23 | ||||||||||||||||||||||||||||||||||||||||||||
395470 | 395470 | AR | school | 500030 | 5008000 | NEVADA SCHOOL DISTRICT | 50003001405 | 5008014 | NEVADA HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 22.0 | 13.0 | 1.0 | 0.0 | 0.0 | 36.0 | 22 | 13 | 1 | 0 | 0 | 36 | ||||||||||||||||||||||||||||||||||||||||||
395534 | 395534 | AR | school | 508240 | 5102000 | JASPER SCHOOL DISTRICT | 50824000564 | 5102008 | KINGSTON HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 22.0 | 0.0 | 0.0 | 0.0 | 0.0 | 22.0 | 22 | 0 | 0 | 0 | 0 | 22 | ||||||||||||||||||||||||||||||||||||||||||
388398 | 388398 | AR | school | 507110 | 1003000 | GURDON SCHOOL DISTRICT | 50711000431 | 1003017 | CABE MIDDLE SCHOOL | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 23.0 | 14.0 | 11.0 | 1.0 | 0.0 | 2.0 | 51.0 | 23 | 14 | 11 | 1 | 0 | 2 | 51 | ||||||||||||||||||||||||||||||||||||||||
388974 | 388974 | AR | school | 510410 | 1503000 | NEMO VISTA SCHOOL DISTRICT | 51041001493 | 1503018 | NEMO VISTA MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 23.0 | 1.0 | 1.0 | 1.0 | 26.0 | 23 | 1 | 1 | 1 | 26 | ||||||||||||||||||||||||||||||||||||||||||||
392302 | 392302 | AR | school | 507840 | 2903000 | HOPE SCHOOL DISTRICT | 50784000500 | 2903011 | YERGER JUNIOR HIGH SCHOOL | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 24.0 | 54.0 | 45.0 | 1.0 | 1.0 | 125.0 | 24 | 54 | 45 | 1 | 1 | 125 | ||||||||||||||||||||||||||||||||||||||||||
398398 | 398398 | AR | school | 500074 | 6041700 | LISA ACADEMY CHARTER | 50007401473 | 6041705 | LISA ACADEMY NORTH MIDDLE CHARTER SCHOOL | Regular School | Yes | Middle | 06 | 08 | 2019 | grade_7 | 24.0 | 30.0 | 14.0 | 0.0 | 7.0 | 0.0 | 75.0 | 24 | 30 | 14 | 0 | 7 | 0 | 75 | ||||||||||||||||||||||||||||||||||||||||
387902 | 387902 | AR | school | 503420 | 506000 | LEAD HILL SCHOOL DISTRICT | 50342000103 | 506032 | LEAD HILL HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 25.0 | 0.0 | 1.0 | 0.0 | 0.0 | 26.0 | 25 | 0 | 1 | 0 | 0 | 26 | ||||||||||||||||||||||||||||||||||||||||||
388862 | 388862 | AR | school | 500068 | 1408000 | EMERSON-TAYLOR SCHOOL DISTRICT | 50006800292 | 1408002 | EMERSON HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 25.0 | 9.0 | 2.0 | 1.0 | 37.0 | 25 | 9 | 2 | 1 | 37 | ||||||||||||||||||||||||||||||||||||||||||||
401006 | 401006 | AR | school | 512420 | 7104000 | SHIRLEY SCHOOL DISTRICT | 51242001001 | 7104015 | SHIRLEY HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 25.0 | 0.0 | 1.0 | 0.0 | 0.0 | 26.0 | 25 | 0 | 1 | 0 | 0 | 26 | ||||||||||||||||||||||||||||||||||||||||||
389838 | 389838 | AR | school | 510290 | 1704000 | MULBERRY SCHOOL DISTRICT | 51029001454 | 1704018 | PLEASANT VIEW CAMPUS SCHOOL | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 26.0 | 1.0 | 1.0 | 0.0 | 28.0 | 26 | 1 | 1 | 0 | 28 | ||||||||||||||||||||||||||||||||||||||||||||
396094 | 396094 | AR | school | 508490 | 5503000 | KIRBY SCHOOL DISTRICT | 50849000566 | 5503011 | KIRBY HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 26.0 | 4.0 | 2.0 | 32.0 | 26 | 4 | 2 | 32 | ||||||||||||||||||||||||||||||||||||||||||||||
396254 | 396254 | AR | school | 509420 | 5604000 | MARKED TREE SCHOOL DISTRICT | 50942001515 | 5604018 | MARKED TREE MIDDLE SCHOOL | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 26.0 | 7.0 | 1.0 | 34.0 | 26 | 7 | 1 | 34 | ||||||||||||||||||||||||||||||||||||||||||||||
398366 | 398366 | AR | school | 500074 | 6041700 | LISA ACADEMY CHARTER | 50007401030 | 6041702 | LISA ACADEMY | Regular School | Yes | Middle | 07 | 08 | 2019 | grade_7 | 26.0 | 54.0 | 44.0 | 1.0 | 27.0 | 7.0 | 159.0 | 26 | 54 | 44 | 1 | 27 | 7 | 159 | ||||||||||||||||||||||||||||||||||||||||
402702 | 402702 | AR | school | 504890 | 7503000 | DANVILLE SCHOOL DISTRICT | 50489001488 | 7503007 | DANVILLE MIDDLE SCHOOL | Regular School | No | Middle | 05 | 8 | 2019 | grade_7 | 26.0 | 1.0 | 38.0 | 1.0 | 0.0 | 66.0 | 26 | 1 | 38 | 1 | 0 | 66 | ||||||||||||||||||||||||||||||||||||||||||
395630 | 395630 | AR | school | 500032 | 5201000 | BEARDEN SCHOOL DISTRICT | 50003200053 | 5201002 | BEARDEN HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 27.0 | 6.0 | 1.0 | 2.0 | 36.0 | 27 | 6 | 1 | 2 | 36 | ||||||||||||||||||||||||||||||||||||||||||||
400814 | 400814 | AR | school | 508340 | 7003000 | JUNCTION CITY SCHOOL DISTRICT | 50834000558 | 7003028 | JUNCTION CITY HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 27.0 | 27.0 | 1.0 | 0.0 | 1.0 | 56.0 | 27 | 27 | 1 | 0 | 1 | 56 | ||||||||||||||||||||||||||||||||||||||||||
389006 | 389006 | AR | school | 514370 | 1505000 | WONDERVIEW SCHOOL DISTRICT | 51437001170 | 1505026 | WONDERVIEW HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 28.0 | 0.0 | 0.0 | 0.0 | 1.0 | 29.0 | 28 | 0 | 0 | 0 | 1 | 29 | ||||||||||||||||||||||||||||||||||||||||||
392974 | 392974 | AR | school | 503840 | 3301000 | CALICO ROCK SCHOOL DISTRICT | 50384000132 | 3301002 | CALICO ROCK HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 28.0 | 0.0 | 0.0 | 0.0 | 28.0 | 28 | 0 | 0 | 0 | 28 | ||||||||||||||||||||||||||||||||||||||||||||
391454 | 391454 | AR | school | 504860 | 2601000 | CUTTER-MORNING STAR SCH. DIST. | 50486000210 | 2601002 | CUTTER-MORNING STAR HIGH SCH. | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 29.0 | 1.0 | 6.0 | 3.0 | 1.0 | 3.0 | 43.0 | 29 | 1 | 6 | 3 | 1 | 3 | 43 | ||||||||||||||||||||||||||||||||||||||||
393806 | 393806 | AR | school | 500071 | 3809000 | HILLCREST SCHOOL DISTRICT | 50007101010 | 3809023 | HILLCREST HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 29.0 | 1.0 | 0.0 | 30.0 | 29 | 1 | 0 | 30 | ||||||||||||||||||||||||||||||||||||||||||||||
396942 | 396942 | AR | school | 507530 | 5903000 | HAZEN SCHOOL DISTRICT | 50753000464 | 5903011 | HAZEN ELEMENTARY SCHOOL | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 29.0 | 7.0 | 1.0 | 0.0 | 0.0 | 37.0 | 29 | 7 | 1 | 0 | 0 | 37 | ||||||||||||||||||||||||||||||||||||||||||
397534 | 397534 | AR | school | 509000 | 6001000 | LITTLE ROCK SCHOOL DISTRICT | 50900001601 | 6001075 | FOREST HEIGHTS STEM ACADEMY | Regular School | No | Elementary | KG | 08 | 2019 | grade_7 | 29.0 | 60.0 | 11.0 | 1.0 | 4.0 | 1.0 | 106.0 | 29 | 60 | 11 | 1 | 4 | 1 | 106 | ||||||||||||||||||||||||||||||||||||||||
395390 | 395390 | AR | school | 509990 | 4902000 | MOUNT IDA SCHOOL DISTRICT | 50999000733 | 4902007 | MOUNT IDA HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 30.0 | 1.0 | 0.0 | 1.0 | 32.0 | 30 | 1 | 0 | 1 | 32 | ||||||||||||||||||||||||||||||||||||||||||||
387822 | 387822 | AR | school | 510920 | 504000 | OMAHA SCHOOL DISTRICT | 51092000821 | 504023 | OMAHA HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 31.0 | 1.0 | 1.0 | 2.0 | 0.0 | 0.0 | 35.0 | 31 | 1 | 1 | 2 | 0 | 0 | 35 | ||||||||||||||||||||||||||||||||||||||||
386494 | 386494 | AR | school | 510560 | 304000 | NORFORK SCHOOL DISTRICT | 51056000774 | 304022 | NORFORK HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 32.0 | 1.0 | 0.0 | 0.0 | 33.0 | 32 | 1 | 0 | 0 | 33 | ||||||||||||||||||||||||||||||||||||||||||||
391246 | 391246 | AR | school | 504740 | 2403000 | COUNTY LINE SCHOOL DISTRICT | 50474000198 | 2403012 | COUNTY LINE HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 32.0 | 0.0 | 1.0 | 1.0 | 3.0 | 1.0 | 38.0 | 32 | 0 | 1 | 1 | 3 | 1 | 38 | ||||||||||||||||||||||||||||||||||||||||
391422 | 391422 | AR | school | 513560 | 2503000 | VIOLA SCHOOL DISTRICT | 51356001112 | 2503010 | VIOLA HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 32.0 | 1.0 | 33.0 | 32 | 1 | 33 | ||||||||||||||||||||||||||||||||||||||||||||||||
391854 | 391854 | AR | school | 510170 | 2607000 | MOUNTAIN PINE SCHOOL DISTRICT | 51017000746 | 2607047 | MOUNTAIN PINE HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 32.0 | 3.0 | 2.0 | 1.0 | 0.0 | 1.0 | 1.0 | 40.0 | 32 | 3 | 2 | 1 | 0 | 1 | 1 | 40 | ||||||||||||||||||||||||||||||||||||||
395022 | 395022 | AR | school | 502550 | 4701000 | ARMOREL SCHOOL DISTRICT | 50255000027 | 4701002 | ARMOREL HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 32.0 | 2.0 | 1.0 | 1.0 | 36.0 | 32 | 2 | 1 | 1 | 36 | ||||||||||||||||||||||||||||||||||||||||||||
401790 | 401790 | AR | school | 512660 | 7207000 | SPRINGDALE SCHOOL DISTRICT | 51266000233 | 7207054 | J. O. KELLY MIDDLE SCHOOL | Regular School | No | Middle | 06 | 07 | 2019 | grade_7 | 32.0 | 12.0 | 282.0 | 0.0 | 7.0 | 55.0 | 3.0 | 391.0 | 32 | 12 | 282 | 0 | 7 | 55 | 3 | 391 | ||||||||||||||||||||||||||||||||||||||
387662 | 387662 | AR | school | 502280 | 501000 | ALPENA SCHOOL DISTRICT | 50228000007 | 501002 | ALPENA HIGH SCHOOL | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 33.0 | 2.0 | 1.0 | 0.0 | 36.0 | 33 | 2 | 1 | 0 | 36 |
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]);