enrollments

Data source: Big Local News · About: Big Local

4,760 rows where grade = "grade_7" and state = "TX" sorted by ccd_school_low_grade descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 4,760 ✖
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
1374362 1374362 TX HILL COUNTY   school 4807380 109901   ABBOTT ISD 480738000006 109901001 ABBOTT SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   16                                             16
1374570 1374570 TX HARRIS COUNTY   school 4800032 101810   ACADEMY OF ACCELERATED LEARNING IN 480003208585 101810002 ACADEMY OF ACCELERATED LEARNING   Alternative School Yes Elementary PK 07 2021   grade_7                                                   36                                             36
1374579 1374579 TX DALLAS COUNTY   school 4800090 57810   ACADEMY OF DALLAS 480009008161 57810101 ACADEMY OF DALLAS   Regular School Yes Elementary PK 08 2021   grade_7                                                   32                                             32
1374589 1374589 TX HARRIS COUNTY   school 4800192 101849   ACCELERATED INTERMEDIATE ACADEMY 480019210716 101849101 ACCELERATED INTERDISCIPLINARY ACAD   Regular School Yes Elementary PK 07 2021   grade_7                                                   13                                             13
1374598 1374598 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   15                                             15
1374612 1374612 TX DALLAS COUNTY   school 4800041 57806   ADVANTAGE ACADEMY 480004108501 57806101 ADVANTAGE ACADEMY   Regular School Yes Other PK 12 2021   grade_7                                                   133                                             133
1374869 1374869 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000075 101902108 LANE SCHOOL   Special Education School No Other PK 12 2021   grade_7                                                   <10                                             10
1375306 1375306 TX HARRIS COUNTY   school 4800035 101815   ALIEF MONTESSORI COMMUNITY SCHOOL 480003507914 101815101 ALIEF MONTESSORI COMMUNITY SCHOOL   Regular School Yes Elementary PK 08 2021   grade_7                                                   10                                             10
1376046 1376046 TX GALVESTON COUNTY   school 4800284 84804   AMBASSADORS PREPARATORY ACADEMY 480028411566 84804101 AMBASSADORS PREPARATORY ACADEMY   Regular School Yes Elementary PK 08 2021   grade_7                                                   16                                             16
1376057 1376057 TX LAMB COUNTY   school 4808160 140901   AMHERST ISD 480816000188 140901001 AMHERST SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1376071 1376071 TX HARRIS COUNTY   school 4800113 101819   AMIGOS POR VIDA-FRIENDS FOR LIFE P 480011308237 101819001 AMIGOS POR VIDA-FRIENDS FOR LIFE C   Regular School Yes Elementary PK 08 2021   grade_7                                                   59                                             59
1376261 1376261 TX HOCKLEY COUNTY   school 4808460 110901   ANTON ISD 480846000214 110901001 ANTON SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   19                                             19
1376291 1376291 TX HILL COUNTY   school 4808520 109912   AQUILLA ISD 480852000218 109912001 AQUILLA SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   25                                             25
1377695 1377695 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2021   grade_7                                                   <10                                             10
1377845 1377845 TX ELLIS COUNTY   school 4809030 70901   AVALON ISD 480903000374 70901001 AVALON SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   25                                             25
1377873 1377873 TX CASS COUNTY   school 4809090 34902   AVINGER ISD 480909000378 34902001 AVINGER SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1377989 1377989 TX REEVES COUNTY   school 4809330 195902   BALMORHEA ISD 480933000392 195902001 BALMORHEA SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   22                                             22
1378082 1378082 TX BELL COUNTY   school 4809540 14902   BARTLETT ISD 480954000406 14902001 BARTLETT SCHOOLS   Regular School No Other PK 12 2021   grade_7                                                   41                                             41
1378401 1378401 TX CLAY COUNTY   school 4809750 39904   BELLEVUE ISD 480975000446 39904001 BELLEVUE SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   10                                             10
1378560 1378560 TX KNOX COUNTY   school 4809980 138904   BENJAMIN ISD 480998000468 138904001 BENJAMIN SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   14                                             14
1378592 1378592 TX BEXAR COUNTY   school 4800077 15809   BEXAR COUNTY ACADEMY 480007708105 15809101 BEXAR COUNTY ACADEMY   Regular School Yes Elementary PK 08 2021   grade_7                                                   19                                             19
1378617 1378617 TX POLK COUNTY   school 4810170 187901   BIG SANDY ISD 481017000472 187901001 BIG SANDY SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   35                                             35
1378899 1378899 TX NOLAN COUNTY   school 4800005 177903   BLACKWELL CISD 480000500513 177903001 BLACKWELL SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   14                                             14
1378943 1378943 TX BROWN COUNTY   school 4810380 25904   BLANKET ISD 481038005661 25904001 BLANKET SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   10                                             10
1378960 1378960 TX CASS COUNTY   school 4810440 34909   BLOOMBURG ISD 481044000523 34909001 BLOOMBURG SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   16                                             16
1379024 1379024 TX ERATH COUNTY   school 4810620 72904   BLUFF DALE ISD 481062000532 72904101 BLUFF DALE EL   Regular School No Other PK 12 2021   grade_7                                                   <20                                             20
1379038 1379038 TX HILL COUNTY   school 4810650 109913   BLUM ISD 481065000534 109913001 BLUM ISD   Regular School No Other PK 12 2021   grade_7                                                   25                                             25
1379205 1379205 TX BORDEN COUNTY   school 4810860 17901   BORDEN COUNTY ISD 481086000552 17901001 BORDEN COUNTY SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   19                                             19
1379370 1379370 TX BRAZOS COUNTY   school 4800086 21803   BRAZOS SCHOOL FOR INQUIRY & CREATI 480008608128 21803001 BRAZOS SCHOOL FOR INQUIRY AND CREA   Regular School Yes Elementary PK 08 2021   grade_7                                                   11                                             11
1379587 1379587 TX COKE COUNTY   school 4811490 41901   BRONTE ISD 481149000623 41901001 BRONTE ISD   Regular School No Other PK 12 2021   grade_7                                                   21                                             21
1379615 1379615 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155000627 25908001 BROOKESMITH SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   16                                             16
1379649 1379649 TX BEXAR COUNTY   school 4800268 15830   BROOKS ACADEMIES OF TEXAS 480026811128 15830001 BROOKS ACADEMY OF SCIENCE AND ENGI   Regular School Yes Other PK 12 2021   grade_7                                                   130                                             130
1379663 1379663 TX BEXAR COUNTY   school 4800268 15830   BROOKS ACADEMIES OF TEXAS 480026813064 15830101 BROOKS COLLEGIATE ACADEMY   Regular School Yes Other PK 12 2021   grade_7                                                   173                                             173
1380235 1380235 TX JACK COUNTY   school 4811820 119901   BRYSON ISD 481182000695 119901001 BRYSON SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   16                                             16
1380249 1380249 TX MILAM COUNTY   school 4811850 166907   BUCKHOLTS ISD 481185000697 166907001 BUCKHOLTS SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   15                                             15
1380263 1380263 TX PECOS COUNTY   school 4811910 186901   BUENA VISTA ISD 481191000699 186901001 BUENA VISTA SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   21                                             21
1380351 1380351 TX NEWTON COUNTY   school 4812150 176901   BURKEVILLE ISD 481215000713 176901001 BURKEVILLE SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   18                                             18
1380544 1380544 TX HILL COUNTY   school 4812360 109902   BYNUM ISD 481236000730 109902001 BYNUM SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   20                                             20
1380647 1380647 TX CALHOUN COUNTY   school 4812480 29901   CALHOUN COUNTY ISD 481248000751 29901107 SEADRIFT SCHOOL   Regular School No Elementary PK 08 2021   grade_7                                                   31                                             31
1380678 1380678 TX ROBERTSON COUNTY   school 4812540 198902   CALVERT ISD 481254000756 198902101 CALVERT SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   10                                             10
1380894 1380894 TX RUSK COUNTY   school 4812870 201913   CARLISLE ISD 481287000783 201913001 CARLISLE SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   58                                             58
1381339 1381339 TX TRAVIS COUNTY   school 4800232 227817   CEDARS INTERNATIONAL ACADEMY 480023209075 227817101 CEDARS INTERNATIONAL ACADEMY   Regular School Yes Elementary PK 08 2021   grade_7                                                   34                                             34
1381432 1381432 TX TRINITY COUNTY   school 4813380 228904   CENTERVILLE ISD 481338000839 228904001 CENTERVILLE H S   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1381542 1381542 TX HARTLEY COUNTY   school 4813620 103901   CHANNING ISD 481362000857 103901001 CHANNING SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   13                                             13
1381569 1381569 TX TARRANT COUNTY   school 4801407 220815   CHAPEL HILL ACADEMY 480140712082 220815101 CHAPEL HILL ACADEMY   Regular School Yes Elementary PK 08 2021   grade_7                                                   57                                             57
1381628 1381628 TX SAN SABA COUNTY   school 4813740 206903   CHEROKEE ISD 481374000866 206903001 CHEROKEE SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1381686 1381686 TX HARDEMAN COUNTY   school 4813890 99902   CHILLICOTHE ISD 481389000876 99902001 CHILLICOTHE SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   16                                             16
1381700 1381700 TX FALLS COUNTY   school 4813920 73901   CHILTON ISD 481392000879 73901001 CHILTON SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   45                                             45
1381732 1381732 TX NACOGDOCHES COUNTY   school 4813980 174901   CHIRENO ISD 481398000883 174901101 CHIRENO EL   Regular School No Elementary PK 08 2021   grade_7                                                   35                                             35
1381816 1381816 TX DALLAS COUNTY   school 4800288 57841   CITYSCAPE SCHOOLS 480028811555 57841001 EAST GRAND PREPARATORY ACADEMY   Regular School Yes Elementary PK 08 2021   grade_7                                                   61                                             61
1381855 1381855 TX ARMSTRONG COUNTY   school 4814250 6902   CLAUDE ISD 481425000900 6902001 CLAUDE SCHOOLS   Regular School No Other PK 12 2021   grade_7                                                   22                                             22
1382529 1382529 TX MITCHELL COUNTY   school 4814640 168901   COLORADO ISD 481464013409 168901100 COLORADO EL AND MIDDLE   Regular School No Elementary PK 08 2021   grade_7                                                   79                                             79
1382845 1382845 TX HOPKINS COUNTY   school 4814880 112908   COMO-PICKTON CISD 481488000989 112908001 COMO-PICKTON SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   62                                             62
1383819 1383819 TX HALE COUNTY   school 4815360 95902   COTTON CENTER ISD 481536001112 95902001 COTTON CENTER SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1383864 1383864 TX HILL COUNTY   school 4815480 109903   COVINGTON ISD 481548001121 109903001 COVINGTON SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   29                                             29
1383947 1383947 TX BOSQUE COUNTY   school 4815570 18908   CRANFILLS GAP ISD 481557001129 18908001 CRANFILLS GAP SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   14                                             14
1384049 1384049 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 12 2021   grade_7                                                   <10                                             10
1384094 1384094 TX FOARD COUNTY   school 4815870 78901   CROWELL ISD 481587001153 78901001 CROWELL SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1384273 1384273 TX CULBERSON COUNTY   school 4815990 55901   CULBERSON COUNTY-ALLAMOORE ISD 481599001171 55901001 VAN HORN SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   33                                             33
1384882 1384882 TX MEDINA COUNTY   school 4816140 163902   D'HANIS ISD 481614001195 163902001 D'HANIS SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   22                                             22
1384941 1384941 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623001350 57905206 ALEX SANGER PREPARATORY SCHOOL   Regular School No Elementary PK 08 2021   grade_7                                                   80                                             80
1385238 1385238 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623007569 57905270 EDUARDO MATA MONTESSORI SCHOOL   Regular School No Elementary PK 08 2021   grade_7                                                   61                                             61
1385354 1385354 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006932 57905134 GEORGE B DEALEY MONTESSORI ACADEMY   Regular School No Elementary PK 08 2021   grade_7                                                   80                                             80
1385432 1385432 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623000465 57905212 HARRY STONE MONTESSORI ACADEMY   Regular School No Elementary PK 08 2021   grade_7                                                   93                                             93
1385524 1385524 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006242 57905263 J P STARKS EL   Regular School No Elementary PK 08 2021   grade_7                                                   26                                             26
1386096 1386096 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623001301 57905173 SIDNEY LANIER EXPRESSIVE ARTS VANG   Regular School No Elementary PK 08 2021   grade_7                                                   89                                             89
1386345 1386345 TX BRAZORIA COUNTY   school 4816260 20910   DAMON ISD 481626001391 20910101 DAMON EL   Regular School No Elementary PK 08 2021   grade_7                                                   11                                             11
1386370 1386370 TX LIPSCOMB COUNTY   school 4816320 148905   DARROUZETT ISD 481632001699 148905101 DARROUZETT SCHOOLS   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1386398 1386398 TX DAWSON COUNTY   school 4816350 58902   DAWSON ISD 481635001399 58902001 DAWSON SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1386649 1386649 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1386993 1386993 TX DALLAS COUNTY   school 4816860 57906   DESOTO ISD 481686013644 57906112 KATHERINE JOHNSON TECHNOLOGY MAGNE   Regular School No Elementary PK 07 2021   grade_7                                                   55                                             55
1387063 1387063 TX FREESTONE COUNTY   school 4816980 81906   DEW ISD 481698001471 81906101 DEW EL   Regular School No Elementary PK 08 2021   grade_7                                                   16                                             16
1387196 1387196 TX LEE COUNTY   school 4817130 144903   DIME BOX ISD 481713001486 144903001 DIME BOX SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   12                                             12
1387232 1387232 TX FANNIN COUNTY   school 4817280 74904   DODD CITY ISD 481728001494 74904001 DODD CITY SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   31                                             31
1387387 1387387 TX NACOGDOCHES COUNTY   school 4817460 174911   DOUGLASS ISD 481746001506 174911001 DOUGLASS SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   50                                             50
1387401 1387401 TX NUECES COUNTY   school 4800025 178801   DR M L GARZA-GONZALEZ CHARTER SCHO 480002507411 178801001 DR M L GARZA-GONZALEZ CHARTER SCHO   Alternative School Yes Elementary PK 08 2021   grade_7                                                   23                                             23
1387411 1387411 TX HARRIS COUNTY   school 4800263 101856   DRAW ACADEMY 480026310720 101856101 DRAW ACADEMY   Alternative School Yes Elementary PK 08 2021   grade_7                                                   65                                             65
1387464 1387464 TX NUECES COUNTY   school 4817550 178905   DRISCOLL ISD 481755008889 178905041 DRISCOLL EL & MIDDLE   Regular School No Elementary PK 08 2021   grade_7                                                   28                                             28
1388512 1388512 TX HIDALGO COUNTY   school 4818180 108904   EDINBURG CISD 481818001636 108904102 BREWSTER EL   Regular School No Elementary PK 08 2021   grade_7                                                   <60                                             60
1388784 1388784 TX DALLAS COUNTY   school 4800186 57833   EDUCATION CENTER INTERNATIONAL ACA 480018611928 57833002 EDUCATION CENTER INTERNATIONAL ACA   Regular School Yes Elementary PK 08 2021   grade_7                                                   25                                             25
1388795 1388795 TX JEFFERSON COUNTY   school 4800221 123805   EHRHART SCHOOL 480022108673 123805001 EHRHART SCHOOL   Regular School Yes Elementary PK 08 2021   grade_7                                                   49                                             49
1389109 1389109 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830001701 71902129 MACARTHUR EL-INT   Regular School No Elementary PK 08 2021   grade_7                                                   139                                             139
1389438 1389438 TX COOKE COUNTY   school 4818600 49906   ERA ISD 481860001744 49906001 ERA SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   34                                             34
1389465 1389465 TX NACOGDOCHES COUNTY   school 4818660 174910   ETOILE ISD 481866001747 174910101 ETOILE EL   Regular School No Elementary PK 08 2021   grade_7                                                   <10                                             10
1389608 1389608 TX HIDALGO COUNTY   school 4801433 108809   EXCELLENCE IN LEADERSHIP ACADEMY 480143312793 108809001 EXCELLENCE IN LEADERSHIP ACADEMY   Regular School Yes Elementary PK 08 2021   grade_7                                                   22                                             22
1389618 1389618 TX SHELBY COUNTY   school 4818840 210906   EXCELSIOR ISD 481884001762 210906101 EXCELSIOR EL   Regular School No Elementary PK 08 2021   grade_7                                                   10                                             10
1389628 1389628 TX LAVACA COUNTY   school 4818890 143906   EZZELL ISD 481889001764 143906101 EZZELL EL   Regular School No Elementary PK 08 2021   grade_7                                                   <10                                             10
1389728 1389728 TX FAYETTE COUNTY   school 4819140 75906   FAYETTEVILLE ISD 481914001784 75906001 FAYETTEVILLE SCHOOLS   Regular School No Other PK 12 2021   grade_7                                                   22                                             22
1389867 1389867 TX LIPSCOMB COUNTY   school 4819500 148902   FOLLETT ISD 481950001806 148902001 FOLLETT SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   13                                             13
1389882 1389882 TX MONTAGUE COUNTY   school 4819530 169910   FORESTBURG ISD 481953001808 169910001 FORESTBURG SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   10                                             10
1390436 1390436 TX WHEELER COUNTY   school 4811400 242906   FORT ELLIOTT CISD 481140000616 242906001 FORT ELLIOTT SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   11                                             11
1390839 1390839 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005717 220905026 JO KELLY SP ED   Alternative School No Other PK 12 2021   grade_7                                                   <10                                             10
1391916 1391916 TX JEFF DAVIS COUNTY   school 4820100 122901   FT DAVIS ISD 482010001962 122901001 FT DAVIS SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   14                                             14
1392145 1392145 TX GALVESTON COUNTY   school 4820280 84902   GALVESTON ISD 482028001997 84902102 CRENSHAW EL AND MIDDLE   Regular School No Elementary PK 08 2021   grade_7                                                   <30                                             30
1392612 1392612 TX PARKER COUNTY   school 4820370 184911   GARNER ISD 482037002054 184911101 GARNER EL   Regular School No Elementary PK 08 2021   grade_7                                                   29                                             29
1392641 1392641 TX PANOLA COUNTY   school 4820460 183904   GARY ISD 482046002058 183904001 GARY SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   33                                             33
1392685 1392685 TX MILAM COUNTY   school 4820520 166902   GAUSE ISD 482052002063 166902101 GAUSE EL   Regular School No Elementary PK 08 2021   grade_7                                                   19                                             19
1392706 1392706 TX HARRIS COUNTY   school 4800020 101804   GEORGE I SANCHEZ CHARTER 480002007304 101804001 GEORGE I SANCHEZ CHARTER   Alternative School Yes Other PK 12 2021   grade_7                                                   89                                             89
1392854 1392854 TX MCLENNAN COUNTY   school 4820610 161925   GHOLSON ISD 482061002073 161925101 GHOLSON SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   21                                             21
1392961 1392961 TX MONTAGUE COUNTY   school 4820970 169906   GOLD BURG ISD 482097002091 169906001 GOLD BURG SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   15                                             15

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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