Data source: Big Local News · About: Big Local

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

View and edit SQL

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
1661509 TX HIDALGO COUNTY   school 4844960 108913   WESLACO ISD 484496013299 108913118 21ST CENTURY EARLY LEARNING FOUNDA   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   522                                             522
1668509 TX HIDALGO COUNTY   school 4844960 108913   WESLACO ISD 484496013299 108913118 21ST CENTURY EARLY LEARNING FOUNDA   Regular School No Prekindergarten PK PK 2020   pk_12_total <10   <520                   254 268                         10   520                   254 268                  
1422514 TX HIDALGO COUNTY   school 4844960 108913   WESLACO ISD 484496013299 108913118 21ST CENTURY EARLY LEARNING FOUNDA   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   424                                             424
1429451 TX HIDALGO COUNTY   school 4844960 108913   WESLACO ISD 484496013299 108913118 21ST CENTURY EARLY LEARNING FOUNDA   Regular School No Prekindergarten PK PK 2021   pk_12_total <10   <430                   209 215                         10   430                   209 215                  
1626192 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739012205 108902006 3D ACADEMY   Alternative School No High 09 12 2020   grade_9                                                   10                                             10
1626193 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739012205 108902006 3D ACADEMY   Alternative School No High 09 12 2020   grade_10                                                   28                                             28
1626194 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739012205 108902006 3D ACADEMY   Alternative School No High 09 12 2020   grade_11                                                   45                                             45
1626195 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739012205 108902006 3D ACADEMY   Alternative School No High 09 12 2020   grade_12                                                   63                                             63
1668241 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739012205 108902006 3D ACADEMY   Alternative School No High 09 12 2020   pk_12_total   <10 <150                   <80 <80                           10 150                   80 80                  
1387238 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739012205 108902006 3D ACADEMY   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1387239 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739012205 108902006 3D ACADEMY   Alternative School No High 09 12 2021   grade_10                                                   <30                                             30
1387240 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739012205 108902006 3D ACADEMY   Alternative School No High 09 12 2021   grade_11                                                   <40                                             40
1387241 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739012205 108902006 3D ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   64                                             64
1429188 TX HIDALGO COUNTY   school 4817390 108902   DONNA ISD 481739012205 108902006 3D ACADEMY   Alternative School No High 09 12 2021   pk_12_total     127                   68 59                             127                   68 59                  
1621324 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735000001 21901001 A & M CONS H S   Regular School No High 09 12 2020   grade_9                                                   517                                             517
1621325 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735000001 21901001 A & M CONS H S   Regular School No High 09 12 2020   grade_10                                                   493                                             493
1621326 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735000001 21901001 A & M CONS H S   Regular School No High 09 12 2020   grade_11                                                   423                                             423
1621327 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735000001 21901001 A & M CONS H S   Regular School No High 09 12 2020   grade_12                                                   407                                             407
1664148 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735000001 21901001 A & M CONS H S   Regular School No High 09 12 2020   pk_12_total 934 257 441   <10 129 <10       72   932 908                         934 257 441   10 129 10       72   932 908                  
1382396 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735000001 21901001 A & M CONS H S   Regular School No High 09 12 2021   grade_9                                                   528                                             528
1382397 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735000001 21901001 A & M CONS H S   Regular School No High 09 12 2021   grade_10                                                   510                                             510
1382398 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735000001 21901001 A & M CONS H S   Regular School No High 09 12 2021   grade_11                                                   461                                             461
1382399 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735000001 21901001 A & M CONS H S   Regular School No High 09 12 2021   grade_12                                                   398                                             398
1425094 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735000001 21901001 A & M CONS H S   Regular School No High 09 12 2021   pk_12_total 988 256 449   <10 135 <10       60   989 908                         988 256 449   10 135 10       60   989 908                  
1621328 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735008712 21901042 A & M CONSOLIDATED MIDDLE   Regular School No Middle 07 08 2020   grade_7                                                   358                                             358
1621329 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735008712 21901042 A & M CONSOLIDATED MIDDLE   Regular School No Middle 07 08 2020   grade_8                                                   341                                             341
1664153 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735008712 21901042 A & M CONSOLIDATED MIDDLE   Regular School No Middle 07 08 2020   pk_12_total 329 96 210   <10 32         <40   373 326                         329 96 210   10 32         40   373 326                  
1382400 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735008712 21901042 A & M CONSOLIDATED MIDDLE   Regular School No Middle 07 08 2021   grade_7                                                   339                                             339
1382401 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735008712 21901042 A & M CONSOLIDATED MIDDLE   Regular School No Middle 07 08 2021   grade_8                                                   350                                             350
1425099 TX BRAZOS COUNTY   school 4807350 21901   COLLEGE STATION ISD 480735008712 21901042 A & M CONSOLIDATED MIDDLE   Regular School No Middle 07 08 2021   pk_12_total 328 109 196   <10 <30         30   347 342                         328 109 196   10 30         30   347 342                  
1389839 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN COLLEGIATE EL   Regular School Yes Elementary PK 05 2021   early_education                                                   <10                                             10
1389840 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN COLLEGIATE EL   Regular School Yes Elementary PK 05 2021   pre_kindergarten                                                   49                                             49
1389841 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN COLLEGIATE EL   Regular School Yes Elementary PK 05 2021   kindergarten                                                   45                                             45
1389842 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN COLLEGIATE EL   Regular School Yes Elementary PK 05 2021   grade_1                                                   <40                                             40
1389843 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN COLLEGIATE EL   Regular School Yes Elementary PK 05 2021   grade_2                                                   48                                             48
1389844 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN COLLEGIATE EL   Regular School Yes Elementary PK 05 2021   grade_3                                                   50                                             50
1389845 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN COLLEGIATE EL   Regular School Yes Elementary PK 05 2021   grade_4                                                   56                                             56
1389846 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN COLLEGIATE EL   Regular School Yes Elementary PK 05 2021   grade_5                                                   <50                                             50
1427374 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN COLLEGIATE EL   Regular School Yes Elementary PK 05 2021   pk_12_total 37 12 281     <10 <10       <10   179 155                         37 12 281     10 10       10   179 155                  
1628830 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN EL   Regular School No Elementary PK 06 2020   early_education                                                   <10                                             10
1628831 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN EL   Regular School No Elementary PK 06 2020   pre_kindergarten                                                   56                                             56
1628832 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN EL   Regular School No Elementary PK 06 2020   kindergarten                                                   <40                                             40
1628833 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN EL   Regular School No Elementary PK 06 2020   grade_1                                                   46                                             46
1628834 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN EL   Regular School No Elementary PK 06 2020   grade_2                                                   52                                             52
1628835 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN EL   Regular School No Elementary PK 06 2020   grade_3                                                   58                                             58
1628836 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN EL   Regular School No Elementary PK 06 2020   grade_4                                                   45                                             45
1628837 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN EL   Regular School No Elementary PK 06 2020   grade_5                                                   60                                             60
1628838 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN EL   Regular School No Elementary PK 06 2020   grade_6                                                   64                                             64
1666437 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944001801 77901101 A B DUNCAN EL   Regular School No Elementary PK 06 2020   pk_12_total 43 17 355     <10         <10   215 204                         43 17 355     10         10   215 204                  
1645813 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042003424 147903103 A B MCBAY EL   Regular School No Elementary PK 02 2020   early_education                                                   24                                             24
1645814 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042003424 147903103 A B MCBAY EL   Regular School No Elementary PK 02 2020   pre_kindergarten                                                   97                                             97
1645815 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042003424 147903103 A B MCBAY EL   Regular School No Elementary PK 02 2020   kindergarten                                                   144                                             144
1645816 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042003424 147903103 A B MCBAY EL   Regular School No Elementary PK 02 2020   grade_1                                                   129                                             129
1645817 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042003424 147903103 A B MCBAY EL   Regular School No Elementary PK 02 2020   grade_2                                                   136                                             136
1669130 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042003424 147903103 A B MCBAY EL   Regular School No Elementary PK 02 2020   pk_12_total 136 127 247   <10 <10         17   276 254                         136 127 247   10 10         17   276 254                  
1406847 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042003424 147903103 A B MCBAY EL   Regular School No Elementary PK 02 2021   early_education                                                   <10                                             10
1406848 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042003424 147903103 A B MCBAY EL   Regular School No Elementary PK 02 2021   pre_kindergarten                                                   <90                                             90
1406849 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042003424 147903103 A B MCBAY EL   Regular School No Elementary PK 02 2021   kindergarten                                                   138                                             138
1406850 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042003424 147903103 A B MCBAY EL   Regular School No Elementary PK 02 2021   grade_1                                                   144                                             144
1406851 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042003424 147903103 A B MCBAY EL   Regular School No Elementary PK 02 2021   grade_2                                                   128                                             128
1430067 TX LIMESTONE COUNTY   school 4830420 147903   MEXIA ISD 483042003424 147903103 A B MCBAY EL   Regular School No Elementary PK 02 2021   pk_12_total 110 116 253   <10 <10 <10       20   264 243                         110 116 253   10 10 10       20   264 243                  
1615140 TX SAN PATRICIO COUNTY   school 4808580 205901   ARANSAS PASS ISD 480858000225 205901041 A C BLUNT MIDDLE   Regular School No Middle 06 09 2020   grade_6                                                   134                                             134
1615141 TX SAN PATRICIO COUNTY   school 4808580 205901   ARANSAS PASS ISD 480858000225 205901041 A C BLUNT MIDDLE   Regular School No Middle 06 09 2020   grade_7                                                   100                                             100
1615142 TX SAN PATRICIO COUNTY   school 4808580 205901   ARANSAS PASS ISD 480858000225 205901041 A C BLUNT MIDDLE   Regular School No Middle 06 09 2020   grade_8                                                   116                                             116
1670218 TX SAN PATRICIO COUNTY   school 4808580 205901   ARANSAS PASS ISD 480858000225 205901041 A C BLUNT MIDDLE   Regular School No Middle 06 09 2020   pk_12_total 115 <10 <220   <10 <10         <10   <190 <170                         115 10 220   10 10         10   190 170                  
1376313 TX SAN PATRICIO COUNTY   school 4808580 205901   ARANSAS PASS ISD 480858000225 205901041 A C BLUNT MIDDLE   Regular School No Middle 06 08 2021   grade_6                                                   120                                             120
1376314 TX SAN PATRICIO COUNTY   school 4808580 205901   ARANSAS PASS ISD 480858000225 205901041 A C BLUNT MIDDLE   Regular School No Middle 06 08 2021   grade_7                                                   125                                             125
1376315 TX SAN PATRICIO COUNTY   school 4808580 205901   ARANSAS PASS ISD 480858000225 205901041 A C BLUNT MIDDLE   Regular School No Middle 06 08 2021   grade_8                                                   <110                                             110
1431152 TX SAN PATRICIO COUNTY   school 4808580 205901   ARANSAS PASS ISD 480858000225 205901041 A C BLUNT MIDDLE   Regular School No Middle 06 08 2021   pk_12_total 126 11 <210   <10 <10 <10       <10   186 167                         126 11 210   10 10 10       10   186 167                  
1617235 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972000442 13901001 A C JONES H S   Regular School No High 09 12 2020   grade_9                                                   309                                             309
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
1617237 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972000442 13901001 A C JONES H S   Regular School No High 09 12 2020   grade_11                                                   233                                             233
1617238 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972000442 13901001 A C JONES H S   Regular School No High 09 12 2020   grade_12                                                   204                                             204
1663301 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972000442 13901001 A C JONES H S   Regular School No High 09 12 2020   pk_12_total 140 29 773   <10 <10 <10       11   497 465                         140 29 773   10 10 10       11   497 465                  
1378366 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972000442 13901001 A C JONES H S   Regular School No High 09 12 2021   grade_9                                                   271                                             271
1378367 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972000442 13901001 A C JONES H S   Regular School No High 09 12 2021   grade_10                                                   260                                             260
1378368 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972000442 13901001 A C JONES H S   Regular School No High 09 12 2021   grade_11                                                   198                                             198
1378369 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972000442 13901001 A C JONES H S   Regular School No High 09 12 2021   grade_12                                                   197                                             197
1424253 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972000442 13901001 A C JONES H S   Regular School No High 09 12 2021   pk_12_total 130 25 755   <10 <10 <10       <10   469 457                         130 25 755   10 10 10       10   469 457                  
1617239 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972013804 13901004 A C JONES HEALTH PROFESSIONS MAGNE   Regular School No Secondary 09 11 2020   grade_9                                                   23                                             23
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
1617241 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972013804 13901004 A C JONES HEALTH PROFESSIONS MAGNE   Regular School No Secondary 09 11 2020   grade_11                                                   14                                             14
1663302 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972013804 13901004 A C JONES HEALTH PROFESSIONS MAGNE   Regular School No Secondary 09 11 2020   pk_12_total <10 <10 47                   16 42                         10 10 47                   16 42                  
1378370 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972013804 13901004 A C JONES HEALTH PROFESSIONS MAGNE   Regular School No High 09 12 2021   grade_9                                                   26                                             26
1378371 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972013804 13901004 A C JONES HEALTH PROFESSIONS MAGNE   Regular School No High 09 12 2021   grade_10                                                   27                                             27
1378372 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972013804 13901004 A C JONES HEALTH PROFESSIONS MAGNE   Regular School No High 09 12 2021   grade_11                                                   21                                             21
1378373 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972013804 13901004 A C JONES HEALTH PROFESSIONS MAGNE   Regular School No High 09 12 2021   grade_12                                                   11                                             11
1424254 TX BEE COUNTY   school 4809720 13901   BEEVILLE ISD 480972013804 13901004 A C JONES HEALTH PROFESSIONS MAGNE   Regular School No High 09 12 2021   pk_12_total <20 <10 69                   35 50                         20 10 69                   35 50                  
1652065 TX HUNT COUNTY   school 4836240 116908   QUINLAN ISD 483624004074 116908101 A E BUTLER INT   Regular School No Elementary 03 05 2020   grade_3                                                   198                                             198
1652066 TX HUNT COUNTY   school 4836240 116908   QUINLAN ISD 483624004074 116908101 A E BUTLER INT   Regular School No Elementary 03 05 2020   grade_4                                                   179                                             179
1652067 TX HUNT COUNTY   school 4836240 116908   QUINLAN ISD 483624004074 116908101 A E BUTLER INT   Regular School No Elementary 03 05 2020   grade_5                                                   194                                             194
1668652 TX HUNT COUNTY   school 4836240 116908   QUINLAN ISD 483624004074 116908101 A E BUTLER INT   Regular School No Elementary 03 05 2020   pk_12_total 357 <10 182   <10           19   295 276                         357 10 182   10           19   295 276                  
1413050 TX HUNT COUNTY   school 4836240 116908   QUINLAN ISD 483624004074 116908101 A E BUTLER INT   Regular School No Elementary 03 05 2021   grade_3                                                   170                                             170
1413051 TX HUNT COUNTY   school 4836240 116908   QUINLAN ISD 483624004074 116908101 A E BUTLER INT   Regular School No Elementary 03 05 2021   grade_4                                                   203                                             203
1413052 TX HUNT COUNTY   school 4836240 116908   QUINLAN ISD 483624004074 116908101 A E BUTLER INT   Regular School No Elementary 03 05 2021   grade_5                                                   181                                             181
1429594 TX HUNT COUNTY   school 4836240 116908   QUINLAN ISD 483624004074 116908101 A E BUTLER INT   Regular School No Elementary 03 05 2021   pk_12_total 334 <10 198   <10   <10       11   268 286                         334 10 198   10   10       11   268 286                  
1638539 TX JOHNSON COUNTY   school 4824930 126905   JOSHUA ISD 482493006126 126905103 A G ELDER EL   Regular School No Elementary PK 05 2020   early_education                                                   11                                             11
1638540 TX JOHNSON COUNTY   school 4824930 126905   JOSHUA ISD 482493006126 126905103 A G ELDER EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   41                                             41
1638541 TX JOHNSON COUNTY   school 4824930 126905   JOSHUA ISD 482493006126 126905103 A G ELDER EL   Regular School No Elementary PK 05 2020   kindergarten                                                   91                                             91
1638542 TX JOHNSON COUNTY   school 4824930 126905   JOSHUA ISD 482493006126 126905103 A G ELDER EL   Regular School No Elementary PK 05 2020   grade_1                                                   102                                             102

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