enrollments

Data source: Big Local News · About: Big Local

4,396 rows where grade = "grade_10" and state = "TX" sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_10 · 4,396 ✖
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 ▼
1374434 1374434 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2021   grade_10                                                   <10                                             10
1374462 1374462 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009497 221901008 JUVENILE DETENTION CENTER   Alternative School No Secondary 07 11 2021   grade_10                                                   <10                                             10
1374486 1374486 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744011037 221901142 OCEANS BEHAVIORAL HEALTH   Alternative School No High 07 12 2021   grade_10                                                   <10                                             10
1374501 1374501 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009062 221901007 TAYLOR COUNTY LEARNING CENTER   Alternative School No Middle 05 10 2021   grade_10                                                   <10                                             10
1374537 1374537 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312248 57814002 DRC CAMPUS   Alternative School Yes Secondary 09 10 2021   grade_10                                                   <10                                             10
1374540 1374540 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312005 57814005 LETOT CAMPUS   Alternative School Yes Secondary 08 11 2021   grade_10                                                   <10                                             10
1374871 1374871 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000075 101902108 LANE SCHOOL   Special Education School No Other PK 12 2021   grade_10                                                   <10                                             10
1375099 1375099 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783008805 101903047 ALIEF ISD J J A E P   Alternative School No Secondary 08 10 2021   grade_10                                                   <10                                             10
1375150 1375150 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011510 101903011 CROSSROADS   Alternative School No High 09 12 2021   grade_10                                                   <10                                             10
1375719 1375719 TX POTTER COUNTY   school 4808130 188901   AMARILLO ISD 480813007086 188901003 AMARILLO AREA CTR FOR ADVANCED LRN   Regular School No High 09 12 2021   grade_10                                                   <10                                             10
1376060 1376060 TX LAMB COUNTY   school 4808160 140901   AMHERST ISD 480816000188 140901001 AMHERST SCHOOL   Regular School No Other PK 12 2021   grade_10                                                   <10                                             10
1376135 1376135 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831007814 20902004 BRAZORIA CO JUVENILE DETENTION   Alternative School No High 06 12 2021   grade_10                                                   <10                                             10
1376179 1376179 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831006642 20902002 STUDENT ALTERNATIVE CTR   Alternative School No High 07 12 2021   grade_10                                                   <10                                             10
1376197 1376197 TX COLLIN COUNTY   school 4808340 43902   ANNA ISD 480834013928 43902005 ANNA ISD DAEP   Alternative School No Secondary 09 11 2021   grade_10                                                   <10                                             10
1376279 1376279 TX TRINITY COUNTY   school 4808490 228905   APPLE SPRINGS ISD 480849000216 228905001 APPLE SPRINGS H S   Regular School No High 07 12 2021   grade_10                                                   <10                                             10
1376853 1376853 TX TARRANT COUNTY   school 4808700 220901   ARLINGTON ISD 480870008024 220901010 TARRANT CO J J A E P   Alternative School No Secondary 08 11 2021   grade_10                                                   <10                                             10
1377083 1377083 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894009076 227901012 ALTERNATIVE LEARNING CENTER   Alternative School No Secondary 07 11 2021   grade_10                                                   <10                                             10
1377106 1377106 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005646 227901250 AUSTIN ST HOSPITAL   Alternative School No High 05 12 2021   grade_10                                                   <10                                             10
1377336 1377336 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894014138 227901023 GRADUATION PREPARATORY ACADEMY   Alternative School No High 09 12 2021   grade_10                                                   <10                                             10
1377456 1377456 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894007137 227901035 LEADERSHIP ACADEMY   Alternative School No High 08 12 2021   grade_10                                                   <10                                             10
1377634 1377634 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894008389 227901032 PHOENIX ACADEMY   Alternative School No High 08 12 2021   grade_10                                                   <10                                             10
1377698 1377698 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2021   grade_10                                                   <10                                             10
1377738 1377738 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894012204 227901027 TRAVIS COUNTY DAY SCHOOL   Alternative School No Secondary 09 11 2021   grade_10                                                   <10                                             10
1377741 1377741 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894009077 227901030 TRAVIS COUNTY JUVENILE DETENTION C   Alternative School No Secondary 08 11 2021   grade_10                                                   <10                                             10
1377834 1377834 TX REFUGIO COUNTY   school 4809000 196901   AUSTWELL-TIVOLI ISD 480900000371 196901001 AUSTWELL-TIVOLI H S   Regular School No High 07 12 2021   grade_10                                                   10                                             10
1377898 1377898 TX MCLENNAN COUNTY   school 4809150 161918   AXTELL ISD 480915006358 161918199 WACO CTR FOR YOUTH   Alternative School No High 06 12 2021   grade_10                                                   10                                             10
1377977 1377977 TX RUNNELS COUNTY   school 4809300 200901   BALLINGER ISD 480930012897 200901005 FAIRVIEW ACCELERATED (DAEP)   Alternative School No High 08 12 2021   grade_10                                                   <10                                             10
1378049 1378049 TX CHAMBERS COUNTY   school 4809450 36902   BARBERS HILL ISD 480945011547 36902005 ALTERNATIVE SCHOOL   Alternative School No Secondary 07 11 2021   grade_10                                                   <10                                             10
1378296 1378296 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967007364 123910011 JEFFERSON CO YOUTH ACAD   Alternative School No Secondary 10 11 2021   grade_10                                                   <10                                             10
1378404 1378404 TX CLAY COUNTY   school 4809750 39904   BELLEVUE ISD 480975000446 39904001 BELLEVUE SCHOOL   Regular School No Other PK 12 2021   grade_10                                                   <10                                             10
1378443 1378443 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986008100 14903006 BELL CO J J A E P   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1378664 1378664 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022711321 193801101 HILL COUNTRY YOUTH RANCH   Alternative School Yes Other KG 12 2021   grade_10                                                   <10                                             10
1378825 1378825 TX TARRANT COUNTY   school 4810230 220902   BIRDVILLE ISD 481023009375 220902009 TARRANT CO J J A E P   Alternative School No Secondary 10 10 2021   grade_10                                                   <10                                             10
1378993 1378993 TX VICTORIA COUNTY   school 4810500 235901   BLOOMINGTON ISD 481050014144 235901002 CROSSROADS CONNECT ACADEMY   Alternative School No High 09 12 2021   grade_10                                                   <10                                             10
1379618 1379618 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155000627 25908001 BROOKESMITH SCHOOL   Regular School No Other PK 12 2021   grade_10                                                   <10                                             10
1379623 1379623 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155013892 25908004 DAVINCI   Alternative School No Secondary 07 11 2021   grade_10                                                   <10                                             10
1379687 1379687 TX TERRY COUNTY   school 4811610 223901   BROWNFIELD ISD 481161012078 223901005 BROWNFIELD EDUCATION CENTER   Alternative School No High 09 12 2021   grade_10                                                   <10                                             10
1379774 1379774 TX CAMERON COUNTY   school 4811680 31901   BROWNSVILLE ISD 481168007541 31901034 CAMERON CO J J A E P   Alternative School No High 08 12 2021   grade_10                                                   <10                                             10
1380074 1380074 TX MCLENNAN COUNTY   school 4811730 161919   BRUCEVILLE-EDDY ISD 481173011401 161919005 AXTELL/BE DAEP   Alternative School No Secondary 08 11 2021   grade_10                                                   <10                                             10
1380077 1380077 TX MCLENNAN COUNTY   school 4811730 161919   BRUCEVILLE-EDDY ISD 481173007994 161919002 AXTELL/BRUCEVILLE-EDDY LEARNING CE   Alternative School No Secondary 09 10 2021   grade_10                                                   <10                                             10
1380120 1380120 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179008456 21902014 BRAZOS CO JUVENILE DETENTION CENTE   Alternative School No Other 04 12 2021   grade_10                                                   <10                                             10
1380123 1380123 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179009145 21902015 BRAZOS COUNTY JJAEP   Alternative School No Secondary 09 10 2021   grade_10                                                   <10                                             10
1380138 1380138 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179007816 21902012 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No High 07 12 2021   grade_10                                                   <10                                             10
1380252 1380252 TX MILAM COUNTY   school 4811850 166907   BUCKHOLTS ISD 481185000697 166907001 BUCKHOLTS SCHOOL   Regular School No Other PK 12 2021   grade_10                                                   <10                                             10
1380322 1380322 TX WICHITA COUNTY   school 4812120 243901   BURKBURNETT ISD 481212007480 243901002 GATEWAY STUDENT SUPPORT CTR   Alternative School No High 09 12 2021   grade_10                                                   <10                                             10
1380475 1380475 TX BURNET COUNTY   school 4812220 27903   BURNET CISD 481222003287 27903003 QUEST H S   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1380593 1380593 TX NUECES COUNTY   school 4812420 178903   CALALLEN ISD 481242009003 178903003 NUECES CO J J A E P   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1380622 1380622 TX CALHOUN COUNTY   school 4812480 29901   CALHOUN COUNTY ISD 481248007199 29901003 HOPE H S   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1381006 1381006 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305007563 57903009 DALLAS COUNTY JJAEP CFB CAMPUS   Alternative School No Secondary 09 11 2021   grade_10                                                   <10                                             10
1381052 1381052 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305005671 57903003 GRIMES EDUCATION CENTER   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1381157 1381157 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305007241 57903005 SALAZAR DISTRICT ALTERNATIVE EDUCA   Alternative School No Secondary 08 11 2021   grade_10                                                   <10                                             10
1381233 1381233 TX TARRANT COUNTY   school 4813170 220917   CASTLEBERRY ISD 481317007121 220917003 REACH H S   Alternative School No High 09 12 2021   grade_10                                                   <10                                             10
1381239 1381239 TX TARRANT COUNTY   school 4813170 220917   CASTLEBERRY ISD 481317007446 220917004 T R U C E LEARNING CTR   Alternative School No High 07 12 2021   grade_10                                                   <10                                             10
1381299 1381299 TX DALLAS COUNTY   school 4813230 57904   CEDAR HILL ISD 481323008182 57904007 JJAEP   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1381393 1381393 TX SHELBY COUNTY   school 4813320 210901   CENTER ISD 481332013661 210901002 ROUGHRIDER ACADEMY   Alternative School No High 09 12 2021   grade_10                                                   <10                                             10
1381412 1381412 TX KERR COUNTY   school 4813350 133901   CENTER POINT ISD 481335013963 133901004 NORTH STAR H S   Alternative School No High 08 12 2021   grade_10                                                   <10                                             10
1381507 1381507 TX HARRIS COUNTY   school 4813590 101905   CHANNELVIEW ISD 481359001144 101905005 ENDEAVOR HS-JOE FRANK CAMPBELL LEA   Alternative School No High 09 12 2021   grade_10                                                   <10                                             10
1381545 1381545 TX HARTLEY COUNTY   school 4813620 103901   CHANNING ISD 481362000857 103901001 CHANNING SCHOOL   Regular School No Other PK 12 2021   grade_10                                                   <10                                             10
1381722 1381722 TX MCLENNAN COUNTY   school 4813960 161920   CHINA SPRING ISD 481396007995 161920002 TAG   Alternative School No High 09 12 2021   grade_10                                                   <10                                             10
1381783 1381783 TX EASTLAND COUNTY   school 4814070 67902   CISCO ISD 481407009215 67902004 CISCO LEARNING CENTER   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1382198 1382198 TX JOHNSON COUNTY   school 4814310 126903   CLEBURNE ISD 481431001614 126903002 TEAM SCH   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1382219 1382219 TX LIBERTY COUNTY   school 4814370 146901   CLEVELAND ISD 481437007381 146901003 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No High 07 12 2021   grade_10                                                   <10                                             10
1382229 1382229 TX LIBERTY COUNTY   school 4814370 146901   CLEVELAND ISD 481437012020 146901004 FREDERICK A DOUGLASS LEARNING ACAD   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1382536 1382536 TX MITCHELL COUNTY   school 4814640 168901   COLORADO ISD 481464010962 168901003 WALLACE ACCELERATED H S   Alternative School No High 09 12 2021   grade_10                                                   <10                                             10
1382561 1382561 TX COLORADO COUNTY   school 4814700 45902   COLUMBUS ISD 481470012678 45902002 COLUMBUS ALTERNATIVE SCHOOL   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1382621 1382621 TX COMAL COUNTY   school 4814730 46902   COMAL ISD 481473012361 46902206 COMAL DISCIPLINE CENTER   Alternative School No High 06 12 2021   grade_10                                                   <10                                             10
1382811 1382811 TX COLLIN COUNTY   school 4814850 43918   COMMUNITY ISD 481485010523 43918003 BRAVES ACADEMY   Alternative School No Secondary 08 11 2021   grade_10                                                   <10                                             10
1382889 1382889 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other KG 12 2021   grade_10                                                   <10                                             10
1383079 1383079 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500017045 170902010 JJAEP   Alternative School No High 08 12 2021   grade_10                                                   <10                                             10
1383085 1383085 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500007998 170902201 JUVENILE DETENTION CTR   Alternative School No High 07 12 2021   grade_10                                                   <10                                             10
1383365 1383365 TX CORYELL COUNTY   school 4815240 50910   COPPERAS COVE ISD 481524007233 50910005 CROSSROADS H S   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1383654 1383654 TX NUECES COUNTY   school 4815270 178904   CORPUS CHRISTI ISD 481527008346 178904012 NUECES CO J J A E P   Alternative School No Secondary 09 11 2021   grade_10                                                   <10                                             10
1383822 1383822 TX HALE COUNTY   school 4815360 95902   COTTON CENTER ISD 481536001112 95902001 COTTON CENTER SCHOOL   Regular School No Other PK 12 2021   grade_10                                                   <10                                             10
1383879 1383879 TX KAUFMAN COUNTY   school 4815510 129901   CRANDALL ISD 481551007370 129901002 CRANDALL COMPASS ACADEMY   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1384050 1384050 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 12 2021   grade_10                                                   <10                                             10
1385028 1385028 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006930 57905029 BARBARA M MANNS H S DAEP   Alternative School No High 09 12 2021   grade_10                                                   <10                                             10
1385667 1385667 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623010565 57905096 JUVENILE JUSTICE AEP   Alternative School No Secondary 08 11 2021   grade_10                                                   <10                                             10
1385845 1385845 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006965 57905030 MAYA ANGELOU H S   Alternative School No Secondary 07 10 2021   grade_10                                                   <10                                             10
1386401 1386401 TX DAWSON COUNTY   school 4816350 58902   DAWSON ISD 481635001399 58902001 DAWSON SCHOOL   Regular School No Other PK 12 2021   grade_10                                                   <10                                             10
1386416 1386416 TX LIBERTY COUNTY   school 4816410 146902   DAYTON ISD 481641011383 146902007 FREDDA NOTTINGHAM ALTERNATIVE EDUC   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1386519 1386519 TX HARRIS COUNTY   school 4816530 101908   DEER PARK ISD 481653011769 101908007 H S POINT   Alternative School No High 09 12 2021   grade_10                                                   <10                                             10
1386652 1386652 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2021   grade_10                                                   <10                                             10
1386689 1386689 TX GRAYSON COUNTY   school 4816710 91903   DENISON ISD 481671007294 91903002 PATHWAYS H S   Alternative School No High 09 12 2021   grade_10                                                   <10                                             10
1386827 1386827 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674007265 61901005 LESTER DAVIS   Alternative School No High 07 12 2021   grade_10                                                   <10                                             10
1387094 1387094 TX ANGELINA COUNTY   school 4817040 3905   DIBOLL ISD 481704007503 3905004 STUBBLEFIELD LRN CTR   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1387113 1387113 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707012520 84901009 DICKINSON CONTINUATION CENTER   Alternative School No High 08 12 2021   grade_10                                                   <10                                             10
1387129 1387129 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707007290 84901012 GALVESTON CO DETENTION CTR   Alternative School No High 07 12 2021   grade_10                                                   <10                                             10
1387199 1387199 TX LEE COUNTY   school 4817130 144903   DIME BOX ISD 481713001486 144903001 DIME BOX SCHOOL   Regular School No Other PK 12 2021   grade_10                                                   <10                                             10
1387304 1387304 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739007961 108902003 HIDALGO CO J J A E P   Alternative School No Secondary 08 11 2021   grade_10                                                   <10                                             10
1387515 1387515 TX MOORE COUNTY   school 4817610 171901   DUMAS ISD 481761017047 171901002 NORTH PLAINS OPPORTUNITY CENTER   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1387587 1387587 TX DALLAS COUNTY   school 4817640 57907   DUNCANVILLE ISD 481764007255 57907007 P A S S LEARNING CTR   Alternative School No Secondary 08 11 2021   grade_10                                                   <10                                             10
1387607 1387607 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770007447 220918003 ALTER DISCIPLINE CAMPUS   Alternative School No High 07 12 2021   grade_10                                                   <10                                             10
1387954 1387954 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785007183 15911004 BEXAR CO J J A E P   Alternative School No Secondary 09 10 2021   grade_10                                                   <10                                             10
1387958 1387958 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785007517 15911005 BEXAR COUNTY LRN CTR   Alternative School No Secondary 07 11 2021   grade_10                                                   <10                                             10
1387962 1387962 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785008449 15911003 EAST CENTRAL CHOICE PROGAM   Alternative School No Secondary 07 11 2021   grade_10                                                   <10                                             10
1388073 1388073 TX ECTOR COUNTY   school 4818000 68901   ECTOR COUNTY ISD 481800001596 68901004 ALTER ED CTR   Alternative School No Secondary 06 11 2021   grade_10                                                   <10                                             10
1388136 1388136 TX ECTOR COUNTY   school 4818000 68901   ECTOR COUNTY ISD 481800016986 68901005 ECTOR CO YOUTH CTR   Alternative School No Secondary 08 11 2021   grade_10                                                   <10                                             10
1388318 1388318 TX HIDALGO COUNTY   school 4818060 108903   EDCOUCH-ELSA ISD 481806013006 108903004 EDCOUCH-ELSA H S ACADEMY   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1388360 1388360 TX CONCHO COUNTY   school 4818070 48901   EDEN CISD 481807014048 48901007 EDEN-FAIRVIEW ACCELERATED   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1388624 1388624 TX HIDALGO COUNTY   school 4818180 108904   EDINBURG CISD 481818007651 108904039 J J A E P   Alternative School No High 07 12 2021   grade_10                                                   <10                                             10

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);