enrollments

Data source: Big Local News · About: Big Local

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

✎ 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 ▼
1613162 1613162 TX HALE COUNTY   school 4807410 95901   ABERNATHY ISD 480741009626 95901003 ABERNATHY DAEP   Alternative School No High 08 12 2020   grade_11                                                   <10                                             10
1613163 1613163 TX HALE COUNTY   school 4807410 95901   ABERNATHY ISD 480741009626 95901003 ABERNATHY DAEP   Alternative School No High 08 12 2020   grade_12                                                   <10                                             10
1613164 1613164 TX HALE COUNTY   school 4807410 95901   ABERNATHY ISD 480741000007 95901101 ABERNATHY EL   Regular School No Elementary PK 05 2020   early_education                                                   <10                                             10
1613187 1613187 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000012 221901102 AUSTIN EL   Regular School No Elementary PK 05 2020   early_education                                                   <10                                             10
1613194 1613194 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744002371 221901153 BASSETTI EL   Regular School No Elementary PK 05 2020   early_education                                                   <10                                             10
1613201 1613201 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000013 221901103 BONHAM EL   Regular School No Elementary PK 05 2020   early_education                                                   <10                                             10
1613225 1613225 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2020   grade_6                                                   <10                                             10
1613226 1613226 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2020   grade_7                                                   <10                                             10
1613227 1613227 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2020   grade_8                                                   <10                                             10
1613229 1613229 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2020   grade_10                                                   <10                                             10
1613230 1613230 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2020   grade_11                                                   <10                                             10
1613231 1613231 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1613233 1613233 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000018 221901108 DYESS EL   Regular School No Elementary PK 05 2020   early_education                                                   <10                                             10
1613240 1613240 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000022 221901112 JACKSON EL   Regular School No Elementary PK 05 2020   early_education                                                   <10                                             10
1613247 1613247 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000024 221901113 JOHNSTON EL   Regular School No Elementary PK 05 2020   early_education                                                   <10                                             10
1613254 1613254 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009497 221901008 JUVENILE DETENTION CENTER   Alternative School No Secondary 08 11 2020   grade_8                                                   <10                                             10
1613255 1613255 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009497 221901008 JUVENILE DETENTION CENTER   Alternative School No Secondary 08 11 2020   grade_9                                                   <10                                             10
1613256 1613256 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009497 221901008 JUVENILE DETENTION CENTER   Alternative School No Secondary 08 11 2020   grade_10                                                   <10                                             10
1613257 1613257 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009497 221901008 JUVENILE DETENTION CENTER   Alternative School No Secondary 08 11 2020   grade_11                                                   <10                                             10
1613258 1613258 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000026 221901116 LEE EL   Regular School No Elementary PK 05 2020   early_education                                                   <10                                             10
1613279 1613279 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744011037 221901142 OCEANS BEHAVIORAL HEALTH   Alternative School No Secondary 07 11 2020   grade_7                                                   <10                                             10
1613286 1613286 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000033 221901120 REAGAN EL   Regular School No Elementary PK 05 2020   early_education                                                   <10                                             10
1613293 1613293 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009062 221901007 TAYLOR COUNTY LEARNING CENTER   Alternative School No Middle 05 11 2020   grade_5                                                   <10                                             10
1613294 1613294 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009062 221901007 TAYLOR COUNTY LEARNING CENTER   Alternative School No Middle 05 11 2020   grade_6                                                   <10                                             10
1613295 1613295 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009062 221901007 TAYLOR COUNTY LEARNING CENTER   Alternative School No Middle 05 11 2020   grade_7                                                   <10                                             10
1613296 1613296 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009062 221901007 TAYLOR COUNTY LEARNING CENTER   Alternative School No Middle 05 11 2020   grade_8                                                   <10                                             10
1613297 1613297 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009062 221901007 TAYLOR COUNTY LEARNING CENTER   Alternative School No Middle 05 11 2020   grade_9                                                   <10                                             10
1613298 1613298 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009062 221901007 TAYLOR COUNTY LEARNING CENTER   Alternative School No Middle 05 11 2020   grade_11                                                   <10                                             10
1613311 1613311 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744002238 221901150 WARD EL   Regular School No Elementary PK 05 2020   early_education                                                   <10                                             10
1613318 1613318 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007123 221901003 WOODSON CENTER FOR EXCELLENCE   Alternative School No High 08 12 2020   grade_8                                                   <10                                             10
1613323 1613323 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009308164 57814001 DALLAS COUNTY JUVENILE JUSTICE   Alternative School Yes High 06 12 2020   grade_6                                                   <10                                             10
1613329 1613329 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009308164 57814001 DALLAS COUNTY JUVENILE JUSTICE   Alternative School Yes High 06 12 2020   grade_12                                                   <10                                             10
1613330 1613330 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312248 57814002 DRC CAMPUS   Alternative School Yes Secondary 07 11 2020   grade_7                                                   <10                                             10
1613331 1613331 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312248 57814002 DRC CAMPUS   Alternative School Yes Secondary 07 11 2020   grade_8                                                   <10                                             10
1613334 1613334 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312248 57814002 DRC CAMPUS   Alternative School Yes Secondary 07 11 2020   grade_11                                                   <10                                             10
1613335 1613335 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312005 57814005 LETOT CAMPUS   Alternative School Yes High 07 12 2020   grade_7                                                   <10                                             10
1613336 1613336 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312005 57814005 LETOT CAMPUS   Alternative School Yes High 07 12 2020   grade_8                                                   <10                                             10
1613338 1613338 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312005 57814005 LETOT CAMPUS   Alternative School Yes High 07 12 2020   grade_10                                                   <10                                             10
1613339 1613339 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312005 57814005 LETOT CAMPUS   Alternative School Yes High 07 12 2020   grade_11                                                   <10                                             10
1613340 1613340 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312005 57814005 LETOT CAMPUS   Alternative School Yes High 07 12 2020   grade_12                                                   <10                                             10
1613341 1613341 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312112 57814003 MEDLOCK YOUTH VILLAGE   Alternative School Yes High 06 12 2020   grade_6                                                   <10                                             10
1613342 1613342 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312112 57814003 MEDLOCK YOUTH VILLAGE   Alternative School Yes High 06 12 2020   grade_7                                                   <10                                             10
1613346 1613346 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312112 57814003 MEDLOCK YOUTH VILLAGE   Alternative School Yes High 06 12 2020   grade_11                                                   <10                                             10
1613347 1613347 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312112 57814003 MEDLOCK YOUTH VILLAGE   Alternative School Yes High 06 12 2020   grade_12                                                   <10                                             10
1613348 1613348 TX BELL COUNTY   school 4807470 14901   ACADEMY ISD 480747013381 14901102 ACADEMY EL   Regular School No Elementary PK 02 2020   early_education                                                   <10                                             10
1613389 1613389 TX HARRIS COUNTY   school 4800192 101849   ACCELERATED INTERMEDIATE ACADEMY 480019210716 101849101 ACCELERATED INTERDISCIPLINARY ACAD   Regular School Yes Elementary PK 07 2020   grade_7                                                   <10                                             10
1613390 1613390 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2020   pre_kindergarten                                                   <10                                             10
1613391 1613391 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2020   kindergarten                                                   <10                                             10
1613392 1613392 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2020   grade_1                                                   <10                                             10
1613393 1613393 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2020   grade_2                                                   <10                                             10
1613394 1613394 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2020   grade_3                                                   <10                                             10
1613395 1613395 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2020   grade_4                                                   <10                                             10
1613396 1613396 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2020   grade_5                                                   <10                                             10
1613400 1613400 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2020   grade_9                                                   10                                             10
1613401 1613401 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2020   grade_10                                                   10                                             10
1613439 1613439 TX BEXAR COUNTY   school 4807590 15901   ALAMO HEIGHTS ISD 480759007509 15901002 BEXAR CO J J A E P   Alternative School No Secondary 07 10 2020   grade_7                                                   <10                                             10
1613440 1613440 TX BEXAR COUNTY   school 4807590 15901   ALAMO HEIGHTS ISD 480759007509 15901002 BEXAR CO J J A E P   Alternative School No Secondary 07 10 2020   grade_10                                                   <10                                             10
1613454 1613454 TX WOOD COUNTY   school 4807650 250906   ALBA-GOLDEN ISD 480765000052 250906101 ALBA-GOLDEN EL   Regular School No Elementary PK 05 2020   early_education                                                   <10                                             10
1613469 1613469 TX WOOD COUNTY   school 4807650 250906   ALBA-GOLDEN ISD 480765007158 250906002 ALTER SCHOOL   Alternative School No Secondary 09 11 2020   grade_9                                                   <10                                             10
1613470 1613470 TX WOOD COUNTY   school 4807650 250906   ALBA-GOLDEN ISD 480765007158 250906002 ALTER SCHOOL   Alternative School No Secondary 09 11 2020   grade_10                                                   <10                                             10
1613471 1613471 TX WOOD COUNTY   school 4807650 250906   ALBA-GOLDEN ISD 480765007158 250906002 ALTER SCHOOL   Alternative School No Secondary 09 11 2020   grade_11                                                   <10                                             10
1613478 1613478 TX SHACKELFORD COUNTY   school 4807680 209901   ALBANY ISD 480768000055 209901101 NANCY SMITH EL   Regular School No Elementary PK 06 2020   early_education                                                   <10                                             10
1613491 1613491 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771007620 101902099 ALDINE J J A E P   Alternative School No Middle 08 08 2020   grade_8                                                   <10                                             10
1613630 1613630 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771010723 101902098 HIGHPOINT   Alternative School No Middle 06 10 2020   grade_6                                                   <10                                             10
1613631 1613631 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771010723 101902098 HIGHPOINT   Alternative School No Middle 06 10 2020   grade_10                                                   <10                                             10
1613672 1613672 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000075 101902108 LANE SCHOOL   Special Education School No Other PK 12 2020   early_education                                                   10                                             10
1613673 1613673 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000075 101902108 LANE SCHOOL   Special Education School No Other PK 12 2020   grade_4                                                   <10                                             10
1613674 1613674 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000075 101902108 LANE SCHOOL   Special Education School No Other PK 12 2020   grade_6                                                   <10                                             10
1613675 1613675 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000075 101902108 LANE SCHOOL   Special Education School No Other PK 12 2020   grade_8                                                   <10                                             10
1613676 1613676 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000075 101902108 LANE SCHOOL   Special Education School No Other PK 12 2020   grade_9                                                   <10                                             10
1613677 1613677 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000075 101902108 LANE SCHOOL   Special Education School No Other PK 12 2020   grade_10                                                   <10                                             10
1613678 1613678 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000075 101902108 LANE SCHOOL   Special Education School No Other PK 12 2020   grade_11                                                   <10                                             10
1613804 1613804 TX PARKER COUNTY   school 4807780 184907   ALEDO ISD 480778000089 184907001 ALEDO H S   Regular School No High 09 12 2020   grade_9                                                   <10                                             10
1613820 1613820 TX PARKER COUNTY   school 4807780 184907   ALEDO ISD 480778011935 184907104 MCCALL EL   Regular School No Elementary PK 05 2020   early_education                                                   <10                                             10
1613827 1613827 TX PARKER COUNTY   school 4807780 184907   ALEDO ISD 480778008897 184907103 STUARD EL   Regular School No Elementary PK 05 2020   early_education                                                   <10                                             10
1613840 1613840 TX PARKER COUNTY   school 4807780 184907   ALEDO ISD 480778013642 184907105 WALSH EL   Regular School No Elementary PK 05 2020   early_education                                                   <10                                             10
1613856 1613856 TX JIM WELLS COUNTY   school 4807800 125901   ALICE ISD 480780000095 125901101 HILLCREST EL   Regular School No Elementary PK 04 2020   early_education                                                   <10                                             10
1613884 1613884 TX JIM WELLS COUNTY   school 4807800 125901   ALICE ISD 480780000101 125901107 SCHALLERT EL   Regular School No Elementary PK 04 2020   early_education                                                   <10                                             10
1613892 1613892 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783006350 101903199 ADMIN SERVICES   Alternative School No Prekindergarten PK PK 2020   pre_kindergarten                                                   <10                                             10
1613906 1613906 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783008805 101903047 ALIEF ISD J J A E P   Alternative School No Secondary 06 11 2020   grade_6                                                   <10                                             10
1613907 1613907 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783008805 101903047 ALIEF ISD J J A E P   Alternative School No Secondary 06 11 2020   grade_7                                                   <10                                             10
1613908 1613908 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783008805 101903047 ALIEF ISD J J A E P   Alternative School No Secondary 06 11 2020   grade_8                                                   <10                                             10
1613909 1613909 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783008805 101903047 ALIEF ISD J J A E P   Alternative School No Secondary 06 11 2020   grade_9                                                   <10                                             10
1613910 1613910 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783008805 101903047 ALIEF ISD J J A E P   Alternative School No Secondary 06 11 2020   grade_10                                                   <10                                             10
1613911 1613911 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783008805 101903047 ALIEF ISD J J A E P   Alternative School No Secondary 06 11 2020   grade_11                                                   <10                                             10
1613917 1613917 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783008599 101903005 ALIEF LEARNING CTR (6-12)   Alternative School No High 07 12 2020   grade_12                                                   <10                                             10
1613918 1613918 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011491 101903205 ALIEF LEARNING CTR (K-6)   Alternative School No Elementary 01 06 2020   grade_1                                                   <10                                             10
1613919 1613919 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011491 101903205 ALIEF LEARNING CTR (K-6)   Alternative School No Elementary 01 06 2020   grade_2                                                   <10                                             10
1613920 1613920 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011491 101903205 ALIEF LEARNING CTR (K-6)   Alternative School No Elementary 01 06 2020   grade_3                                                   <10                                             10
1613921 1613921 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011491 101903205 ALIEF LEARNING CTR (K-6)   Alternative School No Elementary 01 06 2020   grade_4                                                   <10                                             10
1613922 1613922 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011491 101903205 ALIEF LEARNING CTR (K-6)   Alternative School No Elementary 01 06 2020   grade_5                                                   <10                                             10
1613923 1613923 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011491 101903205 ALIEF LEARNING CTR (K-6)   Alternative School No Elementary 01 06 2020   grade_6                                                   <10                                             10
1613947 1613947 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783000113 101903104 CHAMBERS EL   Regular School No Elementary PK 04 2020   early_education                                                   <10                                             10
1613972 1613972 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011510 101903011 CROSSROADS   Alternative School No High 09 12 2020   grade_11                                                   <10                                             10
1613973 1613973 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783011510 101903011 CROSSROADS   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1614096 1614096 TX HARRIS COUNTY   school 4807830 101903   ALIEF ISD 480783006817 101903117 SNEED EL   Regular School No Elementary PK 04 2020   early_education                                                   <10                                             10
1614126 1614126 TX HARRIS COUNTY   school 4800035 101815   ALIEF MONTESSORI COMMUNITY SCHOOL 480003507914 101815101 ALIEF MONTESSORI COMMUNITY SCHOOL   Regular School Yes Elementary PK 08 2020   grade_8                                                   <10                                             10
1614127 1614127 TX COLLIN COUNTY   school 4807890 43901   ALLEN ISD 480789000117 43901001 ALLEN H S   Regular School No High 09 12 2020   grade_9                                                   <10                                             10
1614131 1614131 TX COLLIN COUNTY   school 4807890 43901   ALLEN ISD 480789000119 43901102 ALTON BOYD EL   Regular School No Elementary PK 06 2020   early_education                                                   <10                                             10
1614139 1614139 TX COLLIN COUNTY   school 4807890 43901   ALLEN ISD 480789006351 43901105 ALVIS C STORY EL   Regular School No Elementary PK 06 2020   early_education                                                   <10                                             10

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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