enrollments

Data source: Big Local News · About: Big Local

2,217 rows where grade = "grade_10", state = "TX" and year = 2020 sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,217 ✖

grade ✖

  • grade_10 · 2,217 ✖
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
1620172 1620172 TX ANDERSON COUNTY   school 4813200 1902   CAYUGA ISD 481320000821 1902001 CAYUGA H S   Regular School No High 09 12 2020   grade_10                                                   45                                             45
1628362 1628362 TX ANDERSON COUNTY   school 4818390 1903   ELKHART ISD 481839001732 1903001 ELKHART H S   Regular School No High 09 12 2020   grade_10                                                   98                                             98
1630356 1630356 TX ANDERSON COUNTY   school 4819770 1904   FRANKSTON ISD 481977001939 1904001 FRANKSTON H S   Regular School No High 09 12 2020   grade_10                                                   56                                             56
1647090 1647090 TX ANDERSON COUNTY   school 4832250 1906   NECHES ISD 483225003575 1906002 NECHES H S   Regular School No High 09 12 2020   grade_10                                                   26                                             26
1649472 1649472 TX ANDERSON COUNTY   school 4834050 1907   PALESTINE ISD 483405003788 1907001 PALESTINE H S   Regular School No High 09 12 2020   grade_10                                                   265                                             265
1661782 1661782 TX ANDERSON COUNTY   school 4843290 1908   WESTWOOD ISD 484329004915 1908002 WESTWOOD H S   Regular School No High 09 12 2020   grade_10                                                   125                                             125
1656195 1656195 TX ANDERSON COUNTY   school 4840500 1909   SLOCUM ISD 484050004585 1909001 SLOCUM H S   Regular School No High 09 12 2020   grade_10                                                   34                                             34
1614936 1614936 TX ANDREWS COUNTY   school 4808280 2901   ANDREWS ISD 480828000194 2901001 ANDREWS H S   Regular School No High 09 12 2020   grade_10                                                   302                                             302
1614932 1614932 TX ANDREWS COUNTY   school 4808280 2901   ANDREWS ISD 480828007502 2901002 ANDREWS EDUCATION CENTER   Alternative School No High 09 12 2020   grade_10                                                   13                                             13
1650739 1650739 TX ANGELINA COUNTY   school 4800074 3801   PINEYWOODS COMMUNITY ACADEMY 480007408093 3801001 PINEYWOODS COMMUNITY ACADEMY H S   Regular School Yes High 09 12 2020   grade_10                                                   72                                             72
1636592 1636592 TX ANGELINA COUNTY   school 4823790 3902   HUDSON ISD 482379002631 3902001 HUDSON H S   Regular School No High 09 12 2020   grade_10                                                   223                                             223
1644004 1644004 TX ANGELINA COUNTY   school 4828550 3903   LUFKIN ISD 482855007762 3903001 LUFKIN H S   Regular School No High 09 12 2020   grade_10                                                   598                                             598
1644019 1644019 TX ANGELINA COUNTY   school 4828550 3903   LUFKIN ISD 482855007163 3903004 STUBBLEFIELD LRN CTR   Alternative School No High 09 12 2020   grade_10                                                   <10                                             10
1636954 1636954 TX ANGELINA COUNTY   school 4824000 3904   HUNTINGTON ISD 482400002654 3904001 HUNTINGTON H S   Regular School No High 09 12 2020   grade_10                                                   138                                             138
1626028 1626028 TX ANGELINA COUNTY   school 4817040 3905   DIBOLL ISD 481704001475 3905001 DIBOLL H S   Regular School No High 09 12 2020   grade_10                                                   124                                             124
1626042 1626042 TX ANGELINA COUNTY   school 4817040 3905   DIBOLL ISD 481704007503 3905004 STUBBLEFIELD LRN CTR   Alternative School No High 10 12 2020   grade_10                                                   <10                                             10
1663118 1663118 TX ANGELINA COUNTY   school 4846740 3906   ZAVALLA ISD 484674005354 3906001 ZAVALLA H S   Regular School No High 06 12 2020   grade_10                                                   21                                             21
1620386 1620386 TX ANGELINA COUNTY   school 4813500 3907   CENTRAL ISD 481350000846 3907001 CENTRAL H S   Regular School No High 09 12 2020   grade_10                                                   100                                             100
1615134 1615134 TX ARANSAS COUNTY   school 4808550 4901   ARANSAS COUNTY ISD 480855000222 4901001 ROCKPORT-FULTON H S   Regular School No High 09 12 2020   grade_10                                                   257                                             257
1615168 1615168 TX ARCHER COUNTY   school 4808610 5901   ARCHER CITY ISD 480861000229 5901001 ARCHER CITY H S   Regular School No High 07 12 2020   grade_10                                                   56                                             56
1634667 1634667 TX ARCHER COUNTY   school 4823400 5902   HOLLIDAY ISD 482340002375 5902001 HOLLIDAY H S   Regular School No High 09 12 2020   grade_10                                                   80                                             80
1662273 1662273 TX ARCHER COUNTY   school 4846080 5904   WINDTHORST ISD 484608005265 5904001 WINDTHORST H S   Regular School No High 09 12 2020   grade_10                                                   29                                             29
1620784 1620784 TX ARMSTRONG COUNTY   school 4814250 6902   CLAUDE ISD 481425000900 6902001 CLAUDE SCHOOLS   Regular School No Other PK 12 2020   grade_10                                                   21                                             21
1620540 1620540 TX ATASCOSA COUNTY   school 4813710 7901   CHARLOTTE ISD 481371000863 7901001 CHARLOTTE H S   Regular School No High 09 12 2020   grade_10                                                   37                                             37
1638612 1638612 TX ATASCOSA COUNTY   school 4824960 7902   JOURDANTON ISD 482496002785 7902001 JOURDANTON H S   Regular School No High 09 12 2020   grade_10                                                   119                                             119
1638598 1638598 TX ATASCOSA COUNTY   school 4824960 7902   JOURDANTON ISD 482496007778 7902005 ATASCOSA COUNTY JUVENILE JUSTICE C   Alternative School No Secondary 07 11 2020   grade_10                                                   <10                                             10
1638602 1638602 TX ATASCOSA COUNTY   school 4824960 7902   JOURDANTON ISD 482496012836 7902006 JOURDANTON DAEP   Alternative School No High 06 12 2020   grade_10                                                   <10                                             10
1644085 1644085 TX ATASCOSA COUNTY   school 4828650 7904   LYTLE ISD 482865003246 7904001 LYTLE H S   Regular School No High 09 12 2020   grade_10                                                   136                                             136
1651248 1651248 TX ATASCOSA COUNTY   school 4835190 7905   PLEASANTON ISD 483519003984 7905001 PLEASANTON H S   Regular School No High 09 12 2020   grade_10                                                   270                                             270
1651251 1651251 TX ATASCOSA COUNTY   school 4835190 7905   PLEASANTON ISD 483519011945 7905005 PLEASANTON ISD SCHOOL OF CHOICE   Alternative School No High 10 12 2020   grade_10                                                   <10                                             10
1651490 1651490 TX ATASCOSA COUNTY   school 4835520 7906   POTEET ISD 483552004029 7906001 POTEET H S   Regular School No High 09 12 2020   grade_10                                                   109                                             109
1617291 1617291 TX AUSTIN COUNTY   school 4809810 8901   BELLVILLE ISD 480981000449 8901001 BELLVILLE H S   Regular School No High 09 12 2020   grade_10                                                   177                                             177
1655615 1655615 TX AUSTIN COUNTY   school 4839630 8902   SEALY ISD 483963004502 8902001 SEALY H S   Regular School No High 09 12 2020   grade_10                                                   214                                             214
1618201 1618201 TX AUSTIN COUNTY   school 4844470 8903   BRAZOS ISD 484447005075 8903001 BRAZOS H S   Regular School No High 09 12 2020   grade_10                                                   58                                             58
1618211 1618211 TX AUSTIN COUNTY   school 4844470 8903   BRAZOS ISD 484447013001 8903103 PRAIRIE HARBOR ALTERNATIVE SCHOOL   Alternative School No High 06 12 2020   grade_10                                                   <10                                             10
1646860 1646860 TX BAILEY COUNTY   school 4831890 9901   MULESHOE ISD 483189003547 9901001 MULESHOE H S   Regular School No High 09 12 2020   grade_10                                                   86                                             86
1646864 1646864 TX BAILEY COUNTY   school 4831890 9901   MULESHOE ISD 483189008094 9901002 P E P   Alternative School No High 09 12 2020   grade_10                                                   <10                                             10
1645332 1645332 TX BANDERA COUNTY   school 4830030 10901   MEDINA ISD 483003003372 10901001 MEDINA SCHOOL   Regular School No Other PK 12 2020   grade_10                                                   23                                             23
1616872 1616872 TX BANDERA COUNTY   school 4809360 10902   BANDERA ISD 480936000395 10902001 BANDERA H S   Regular School No High 09 12 2020   grade_10                                                   186                                             186
1616978 1616978 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957000409 11901001 BASTROP H S   Regular School No High 09 12 2020   grade_10                                                   361                                             361
1617000 1617000 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957012272 11901002 CEDAR CREEK H S   Regular School No High 09 12 2020   grade_10                                                   424                                             424
1617008 1617008 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957013111 11901005 COLORADO RIVER COLLEGIATE ACADEMY   Regular School No High 09 12 2020   grade_10                                                   53                                             53
1617019 1617019 TX BASTROP COUNTY   school 4809570 11901   BASTROP ISD 480957021082 11901022 GENESIS H S   Alternative School No High 09 12 2020   grade_10                                                   <20                                             20
1628340 1628340 TX BASTROP COUNTY   school 4818360 11902   ELGIN ISD 481836001728 11902001 ELGIN H S   Regular School No High 09 12 2020   grade_10                                                   336                                             336
1628323 1628323 TX BASTROP COUNTY   school 4818360 11902   ELGIN ISD 481836010392 11902003 BASTROP COUNTY JUVENILE BOOT CAMP   Alternative School No Secondary 07 10 2020   grade_10                                                   <10                                             10
1628353 1628353 TX BASTROP COUNTY   school 4818360 11902   ELGIN ISD 481836008426 11902004 PHOENIX H S   Alternative School No High 09 12 2020   grade_10                                                   <10                                             10
1656218 1656218 TX BASTROP COUNTY   school 4840550 11904   SMITHVILLE ISD 484055004590 11904002 SMITHVILLE H S   Regular School No High 09 12 2020   grade_10                                                   145                                             145
1645064 1645064 TX BASTROP COUNTY   school 4829760 11905   MCDADE ISD 482976013256 11905001 MCDADE H S   Regular School No High 07 12 2020   grade_10                                                   17                                             17
1645067 1645067 TX BASTROP COUNTY   school 4829760 11905   MCDADE ISD 482976013948 11905011 MCDADE JJAEP   Alternative School No Secondary 10 10 2020   grade_10                                                   <10                                             10
1655754 1655754 TX BAYLOR COUNTY   school 4839780 12901   SEYMOUR ISD 483978004520 12901001 SEYMOUR H S   Regular School No High 09 12 2020   grade_10                                                   36                                             36
1617236 1617236 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972000442 13901001 A C JONES H S   Regular School No High 09 12 2020   grade_10                                                   216                                             216
1617240 1617240 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972013804 13901004 A C JONES HEALTH PROFESSIONS MAGNE   Regular School No Secondary 09 11 2020   grade_10                                                   21                                             21
1650239 1650239 TX BEE COUNTY   school 4834770 13903   PETTUS ISD 483477003899 13903001 PETTUS SECONDARY   Regular School No High 06 12 2020   grade_10                                                   28                                             28
1656156 1656156 TX BEE COUNTY   school 4840410 13905   SKIDMORE-TYNAN ISD 484041004576 13905001 SKIDMORE-TYNAN H S   Regular School No High 09 12 2020   grade_10                                                   67                                             67
1652447 1652447 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007508097 14801001 RICHARD MILBURN ALTER H S (KILLEEN   Alternative School Yes High 09 12 2020   grade_10                                                   48                                             48
1652439 1652439 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007509647 14801002 RICHARD MILBURN ACADEMY ODESSA   Alternative School Yes High 09 12 2020   grade_10                                                   141                                             141
1652431 1652431 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007508324 14801004 RICHARD MILBURN ACADEMY LUBBOCK   Alternative School Yes High 09 12 2020   grade_10                                                   50                                             50
1652427 1652427 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007513173 14801005 RICHARD MILBURN ACADEMY HOUSTON (S   Alternative School Yes High 09 12 2020   grade_10                                                   52                                             52
1652423 1652423 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007509507 14801006 RICHARD MILBURN ACADEMY FORT WORTH   Alternative School Yes High 09 12 2020   grade_10                                                   37                                             37
1652419 1652419 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007508344 14801007 RICHARD MILBURN ACADEMY CORPUS CHR   Alternative School Yes High 09 12 2020   grade_10                                                   85                                             85
1652415 1652415 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007509009 14801008 RICHARD MILBURN ACADEMY AMARILLO   Alternative School Yes High 09 12 2020   grade_10                                                   51                                             51
1652443 1652443 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007513435 14801009 RICHARD MILBURN ACADEMY PASADENA   Alternative School Yes High 09 12 2020   grade_10                                                   44                                             44
1652435 1652435 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007513433 14801010 RICHARD MILBURN ACADEMY MIDLAND SO   Alternative School Yes High 09 12 2020   grade_10                                                   52                                             52
1651850 1651850 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007613035 14803003 COVE CHARTER ACADEMY   Regular School Yes Other PK 12 2020   grade_10                                                   17                                             17
1651837 1651837 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007612994 14803004 CEDAR PARK CHARTER ACADEMY   Regular School Yes Other PK 12 2020   grade_10                                                   <10                                             10
1651874 1651874 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007608098 14803101 TEMPLE CHARTER ACADEMY   Alternative School Yes Other PK 12 2020   grade_10                                                   14                                             14
1649380 1649380 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023511986 14804002 NEW HORIZONS   Alternative School Yes Other 02 12 2020   grade_10                                                   <10                                             10
1649359 1649359 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023512289 14804005 GATEWAY TECH H S   Alternative School Yes High 09 12 2020   grade_10                                                   19                                             19
1649355 1649355 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023512294 14804006 GATEWAY COLLEGE PREPARATORY SCHOOL   Regular School Yes Other KG 12 2020   grade_10                                                   104                                             104
1613354 1613354 TX BELL COUNTY   school 4807470 14901   ACADEMY ISD 480747000040 14901001 ACADEMY H S   Regular School No High 09 12 2020   grade_10                                                   108                                             108
1616955 1616955 TX BELL COUNTY   school 4809540 14902   BARTLETT ISD 480954000406 14902001 BARTLETT SCHOOLS   Regular School No Other PK 12 2020   grade_10                                                   22                                             22
1617317 1617317 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986000454 14903001 BELTON H S   Regular School No High 09 12 2020   grade_10                                                   790                                             790
1617321 1617321 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986008099 14903005 BELTON NEW TECH H S AT WASKOW   Regular School No High 09 12 2020   grade_10                                                   126                                             126
1617312 1617312 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986008100 14903006 BELL CO J J A E P   Alternative School No Secondary 09 11 2020   grade_10                                                   <10                                             10
1634652 1634652 TX BELL COUNTY   school 4823370 14905   HOLLAND ISD 482337002373 14905001 HOLLAND H S   Regular School No High 09 12 2020   grade_10                                                   53                                             53
1639950 1639950 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002871 14906001 KILLEEN H S   Regular School No High 09 12 2020   grade_10                                                   566                                             566
1639850 1639850 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002866 14906002 C E ELLISON H S   Regular School No High 09 12 2020   grade_10                                                   682                                             682
1639902 1639902 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566006281 14906004 GATEWAY H S   Alternative School No High 09 12 2020   grade_10                                                   40                                             40
1640025 1640025 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566021001 14906006 PATHWAYS ACADEMIC CAMPUS   Alternative School No High 09 12 2020   grade_10                                                   <50                                             50
1639916 1639916 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566008695 14906007 HARKER HEIGHTS H S   Regular School No High 09 12 2020   grade_10                                                   620                                             620
1640061 1640061 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566008696 14906008 ROBERT M SHOEMAKER H S   Regular School No High 09 12 2020   grade_10                                                   546                                             546
1639954 1639954 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566013234 14906013 KILLEEN ISD EARLY COLLEGE H S   Regular School No High 09 12 2020   grade_10                                                   251                                             251
1639820 1639820 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002861 14906022 ADVENTHEALTH SCHOOL   Alternative School No Other 01 12 2020   grade_10                                                   <10                                             10
1653329 1653329 TX BELL COUNTY   school 4837710 14907   ROGERS ISD 483771004225 14907001 ROGERS H S   Regular School No High 09 12 2020   grade_10                                                   79                                             79
1653319 1653319 TX BELL COUNTY   school 4837710 14907   ROGERS ISD 483771012091 14907043 BELL COUNTY DAEP   Alternative School No High 09 12 2020   grade_10                                                   <10                                             10
1653985 1653985 TX BELL COUNTY   school 4838580 14908   SALADO ISD 483858004288 14908001 SALADO H S   Regular School No High 09 12 2020   grade_10                                                   146                                             146
1653983 1653983 TX BELL COUNTY   school 4838580 14908   SALADO ISD 483858010411 14908005 BELL COUNTY DAEP   Alternative School No Secondary 10 10 2020   grade_10                                                   <10                                             10
1658139 1658139 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233004827 14909002 TEMPLE H S   Regular School No High 09 12 2020   grade_10                                                   542                                             542
1658163 1658163 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233008430 14909005 WHEATLEY ALTERNATIVE EDUCATION CEN   Alternative School No High 06 12 2020   grade_10                                                   10                                             10
1658095 1658095 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233012581 14909008 FRED W EDWARDS ACADEMY AEC   Alternative School No High 09 12 2020   grade_10                                                   38                                             38
1659420 1659420 TX BELL COUNTY   school 4843260 14910   TROY ISD 484326004913 14910001 TROY H S   Regular School No High 09 12 2020   grade_10                                                   112                                             112
1651338 1651338 TX BEXAR COUNTY   school 4800004 15801   POR VIDA ACADEMY 480000407173 15801001 POR VIDA ACADEMY CHARTER H S   Alternative School Yes High 09 12 2020   grade_10                                                   34                                             34
1651334 1651334 TX BEXAR COUNTY   school 4800004 15801   POR VIDA ACADEMY 480000409116 15801002 CORPUS CHRISTI COLLEGE PREP H S   Alternative School Yes High 09 12 2020   grade_10                                                   <10                                             10
1651330 1651330 TX BEXAR COUNTY   school 4800004 15801   POR VIDA ACADEMY 480000409460 15801003 CESAR E CHAVEZ ACADEMY   Alternative School Yes High 09 12 2020   grade_10                                                   <10                                             10
1631703 1631703 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001407174 15802001 GEORGE GERVIN ACADEMY   Alternative School Yes Other PK 12 2020   grade_10                                                   29                                             29
1631710 1631710 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001410415 15802004 RUTH JONES MCCLENDON MIDDLE   Alternative School Yes High 06 12 2020   grade_10                                                   <10                                             10
1647407 1647407 TX BEXAR COUNTY   school 4800061 15805   NEW FRONTIERS PUBLIC SCHOOLS INC 480006113123 15805001 FRANK L MADLA EARLY COLLEGE H S   Regular School Yes High 09 12 2020   grade_10                                                   37                                             37
1655458 1655458 TX BEXAR COUNTY   school 4800062 15806   SCHOOL OF EXCELLENCE IN EDUCATION 480006212237 15806003 MILTON B LEE ACADEMY OF SCIENCE &   Regular School Yes High 09 12 2020   grade_10                                                   19                                             19
1656960 1656960 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006308433 15807002 SOUTHWEST PREPARATORY SOUTHEAST CA   Alternative School Yes Other PK 12 2020   grade_10                                                   10                                             10
1656946 1656946 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006309118 15807004 SOUTHWEST PREPARATORY SCHOOL-NORTH   Alternative School Yes Other 03 12 2020   grade_10                                                   36                                             36

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]);