enrollments

Data source: Big Local News · About: Big Local

117,510 rows where state = "TX" sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
1622968 1622968 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000112448 54901003 CROSBYTON DAEP   Alternative School No Middle 08 08 2020   grade_8                                                   <10                                             10
1622969 1622969 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2020   early_education                                                   <10                                             10
1622970 1622970 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   26                                             26
1622971 1622971 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2020   kindergarten                                                   18                                             18
1622972 1622972 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2020   grade_1                                                   19                                             19
1622973 1622973 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2020   grade_2                                                   23                                             23
1622974 1622974 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2020   grade_3                                                   23                                             23
1622975 1622975 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2020   grade_4                                                   <20                                             20
1622976 1622976 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2020   grade_5                                                   26                                             26
1622977 1622977 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2020   grade_6                                                   26                                             26
1622978 1622978 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2020   grade_7                                                   21                                             21
1622979 1622979 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2020   grade_8                                                   30                                             30
1622980 1622980 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2020   grade_9                                                   24                                             24
1622981 1622981 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2020   grade_10                                                   29                                             29
1622982 1622982 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2020   grade_11                                                   28                                             28
1622983 1622983 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2020   grade_12                                                   14                                             14
1622984 1622984 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 09 2020   pre_kindergarten                                                   <10                                             10
1622985 1622985 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 09 2020   grade_5                                                   <10                                             10
1622986 1622986 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 09 2020   grade_6                                                   <10                                             10
1622987 1622987 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 09 2020   grade_9                                                   <10                                             10
1664942 1664942 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2020   pk_12_total <40 <10 131                   80 92                         40 10 131                   80 92                  
1664943 1664943 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000112448 54901003 CROSBYTON DAEP   Alternative School No Middle 08 08 2020   pk_12_total     <10                     <10                             10                     10                  
1664944 1664944 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2020   pk_12_total 37 <10 108               <10   <80 <80                         37 10 108               10   80 80                  
1664945 1664945 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 09 2020   pk_12_total <10 <10 <10                   <10 <10                         10 10 10                   10 10                  
1384032 1384032 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   19                                             19
1384033 1384033 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2021   kindergarten                                                   <40                                             40
1384034 1384034 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2021   grade_1                                                   15                                             15
1384035 1384035 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2021   grade_2                                                   17                                             17
1384036 1384036 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2021   grade_3                                                   20                                             20
1384037 1384037 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2021   grade_4                                                   18                                             18
1384038 1384038 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2021   grade_5                                                   18                                             18
1384039 1384039 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2021   grade_6                                                   <30                                             30
1384040 1384040 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2021   grade_7                                                   <30                                             30
1384041 1384041 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2021   grade_8                                                   24                                             24
1384042 1384042 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2021   grade_9                                                   24                                             24
1384043 1384043 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2021   grade_10                                                   <30                                             30
1384044 1384044 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2021   grade_11                                                   27                                             27
1384045 1384045 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2021   grade_12                                                   <30                                             30
1384046 1384046 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 12 2021   early_education                                                   <10                                             10
1384047 1384047 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 12 2021   kindergarten                                                   <10                                             10
1384048 1384048 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 12 2021   grade_6                                                   <10                                             10
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
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
1384051 1384051 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 12 2021   grade_12                                                   <10                                             10
1425888 1425888 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101146 54901001 CROSBYTON SECONDARY   Regular School No High 06 12 2021   pk_12_total 41 <10 122               <10   84 87                         41 10 122               10   84 87                  
1425889 1425889 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000101145 54901101 CROSBYTON EL   Regular School No Elementary PK 05 2021   pk_12_total <40 <10 <110               <10   <70 <80                         40 10 110               10   70 80                  
1425890 1425890 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 12 2021   pk_12_total <10 <10 <10                   <10 <10                         10 10 10                   10 10                  
1657613 1657613 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   early_education                                                   <10                                             10
1657614 1657614 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1657615 1657615 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   kindergarten                                                   19                                             19
1657616 1657616 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   grade_1                                                   17                                             17
1657617 1657617 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   14                                             14
1657618 1657618 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   grade_3                                                   <10                                             10
1657619 1657619 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   18                                             18
1657620 1657620 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   18                                             18
1657621 1657621 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   grade_6                                                   16                                             16
1657622 1657622 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   grade_7                                                   14                                             14
1657623 1657623 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   grade_8                                                   18                                             18
1657624 1657624 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   grade_9                                                   28                                             28
1657625 1657625 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   grade_10                                                   28                                             28
1657626 1657626 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   grade_11                                                   16                                             16
1657627 1657627 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   grade_12                                                   25                                             25
1665944 1665944 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2020   pk_12_total 125 <10 105               <10   134 112                         125 10 105               10   134 112                  
1418571 1418571 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   early_education                                                   <10                                             10
1418572 1418572 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1418573 1418573 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   kindergarten                                                   <10                                             10
1418574 1418574 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   grade_1                                                   17                                             17
1418575 1418575 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   grade_2                                                   14                                             14
1418576 1418576 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   grade_3                                                   14                                             14
1418577 1418577 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   grade_4                                                   <10                                             10
1418578 1418578 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   grade_5                                                   18                                             18
1418579 1418579 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   grade_6                                                   17                                             17
1418580 1418580 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   18                                             18
1418581 1418581 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   grade_8                                                   16                                             16
1418582 1418582 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   grade_9                                                   20                                             20
1418583 1418583 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   grade_10                                                   28                                             28
1418584 1418584 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   grade_11                                                   31                                             31
1418585 1418585 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   grade_12                                                   23                                             23
1426883 1426883 TX DICKENS COUNTY   school 4800002 63903   SPUR ISD 480000204732 63903001 SPUR SCHOOL   Regular School No Other PK 12 2021   pk_12_total 126 <10 100     <10         <10   131 109                         126 10 100     10         10   131 109                  
1653173 1653173 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   early_education                                                   <10                                             10
1653174 1653174 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   pre_kindergarten                                                   <20                                             20
1653175 1653175 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   kindergarten                                                   21                                             21
1653176 1653176 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   grade_1                                                   27                                             27
1653177 1653177 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   grade_2                                                   27                                             27
1653178 1653178 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   grade_3                                                   16                                             16
1653179 1653179 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   grade_4                                                   30                                             30
1653180 1653180 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   grade_5                                                   15                                             15
1653181 1653181 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   grade_6                                                   23                                             23
1653182 1653182 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   grade_7                                                   17                                             17
1653183 1653183 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   grade_8                                                   27                                             27
1653184 1653184 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   grade_9                                                   19                                             19
1653185 1653185 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   grade_10                                                   22                                             22
1653186 1653186 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   grade_11                                                   25                                             25
1653187 1653187 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   grade_12                                                   16                                             16
1666024 1666024 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2020   pk_12_total 63   237                   175 125                         63   237                   175 125                  
1414141 1414141 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2021   early_education                                                   <10                                             10
1414142 1414142 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2021   pre_kindergarten                                                   19                                             19
1414143 1414143 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2021   kindergarten                                                   18                                             18
1414144 1414144 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2021   grade_1                                                   18                                             18
1414145 1414145 TX EDWARDS COUNTY   school 4800003 69901   ROCKSPRINGS ISD 480000304219 69901001 ROCKSPRINGS K-12   Regular School No Other PK 12 2021   grade_2                                                   23                                             23

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