Data source: Big Local News · About: Big Local

4,669 rows where grade = "grade_2", state = "TX" and year = 2021 sorted by ccd_school_type

View and edit SQL

year

  • 2021 · 4,669

grade

  • grade_2 · 4,669
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
1374565 TX HARRIS COUNTY   school 4800032 101810   ACADEMY OF ACCELERATED LEARNING IN 480003208585 101810002 ACADEMY OF ACCELERATED LEARNING   Alternative School Yes Elementary PK 07 2021   grade_2                                                   106                                             106
1377690 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2021   grade_2                                                   <10                                             10
1378643 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022709011 193801001 BIG SPRINGS CHARTER SCHOOL   Alternative School Yes Other KG 12 2021   grade_2                                                   <10                                             10
1378656 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022711321 193801101 HILL COUNTRY YOUTH RANCH   Alternative School Yes Other KG 12 2021   grade_2                                                   <10                                             10
1379343 TX SOMERVELL COUNTY   school 4800214 213801   BRAZOS RIVER CHARTER SCHOOL 480021408907 213801001 BRAZOS RIVER CHARTER SCHOOL   Alternative School Yes Other KG 12 2021   grade_2                                                   <10                                             10
1381058 TX DALLAS COUNTY   school 4813050 57903   CARROLLTON-FARMERS BRANCH ISD 481305005854 57903117 HUIE SPECIAL EDUC CTR   Alternative School No Other PK 12 2021   grade_2                                                   <10                                             10
1384282 TX SMITH COUNTY   school 4800034 212801   CUMBERLAND ACADEMY 480003408020 212801101 CUMBERLAND ACADEMY   Alternative School Yes Elementary PK 05 2021   grade_2                                                   102                                             102
1387396 TX NUECES COUNTY   school 4800025 178801   DR M L GARZA-GONZALEZ CHARTER SCHO 480002507411 178801001 DR M L GARZA-GONZALEZ CHARTER SCHO   Alternative School Yes Elementary PK 08 2021   grade_2                                                   24                                             24
1387406 TX HARRIS COUNTY   school 4800263 101856   DRAW ACADEMY 480026310720 101856101 DRAW ACADEMY   Alternative School Yes Elementary PK 08 2021   grade_2                                                   70                                             70
1390480 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970002185 220905101 ALICE CARLSON APPLIED LRN CTR   Alternative School No Elementary KG 05 2021   grade_2                                                   63                                             63
1390612 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021056 220905210 CHILDREN'S MEDICAL CTR   Alternative School No Other KG 12 2021   grade_2                                                   <10                                             10
1390834 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005717 220905026 JO KELLY SP ED   Alternative School No Other PK 12 2021   grade_2                                                   <10                                             10
1392690 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001407174 15802001 GEORGE GERVIN ACADEMY   Alternative School Yes Other PK 12 2021   grade_2                                                   97                                             97
1395444 TX BEXAR COUNTY   school 4800080 15815   HERITAGE ACADEMY 480008008108 15815001 HERITAGE ACADEMY OF WINDCREST   Alternative School Yes Elementary PK 05 2021   grade_2                                                   20                                             20
1396068 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364006270 101912013 COMMUNITY SERVICES-SEC   Alternative School No Other 01 12 2021   grade_2                                                   <10                                             10
1398868 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2021   grade_2                                                   <10                                             10
1399458 TX DALLAS COUNTY   school 4800098 57819   JEAN MASSIEU ACADEMY 480009808169 57819001 JEAN MASSIEU ACADEMY   Alternative School Yes Other PK 12 2021   grade_2                                                   14                                             14
1400835 TX HAYS COUNTY   school 4801447 105803   KI CHARTER ACADEMY 480144713122 105803001 KI CHARTER ACADEMY   Alternative School Yes Other 01 12 2021   grade_2                                                   <10                                             10
1400869 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002861 14906022 ADVENTHEALTH SCHOOL   Alternative School No Other 02 12 2021   grade_2                                                   <10                                             10
1400947 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566009455 14906100 EL ALTER LEARNING CENTER   Alternative School No Elementary 01 05 2021   grade_2                                                   <10                                             10
1403702 TX DENTON COUNTY   school 4827300 61902   LEWISVILLE ISD 482730006744 61902005 LEARNING CTR   Alternative School No Other 01 12 2021   grade_2                                                   <10                                             10
1405061 TX ANGELINA COUNTY   school 4828550 3903   LUFKIN ISD 482855007776 3903141 SPECIAL SERVICES   Alternative School No Elementary PK 02 2021   grade_2                                                   <10                                             10
1406329 TX KENDALL COUNTY   school 4801404 130801   MEADOWLAND CHARTER DISTRICT 480140412137 130801001 OAKS ACADEMY   Alternative School Yes Other 01 11 2021   grade_2                                                   <10                                             10
1406902 TX MIDLAND COUNTY   school 4800148 165802   MIDLAND ACADEMY CHARTER SCHOOL 480014808336 165802101 MIDLAND ACADEMY CHARTER SCHOOL   Alternative School Yes Elementary PK 08 2021   grade_2                                                   46                                             46
1408334 TX MONTGOMERY COUNTY   school 4832400 170908   NEW CANEY ISD 483240007079 170908002 THE LEARNING CTR   Alternative School No Other 02 12 2021   grade_2                                                   <10                                             10
1408391 TX BEXAR COUNTY   school 4800061 15805   NEW FRONTIERS PUBLIC SCHOOLS INC 480006111122 15805041 FRANK L MADLA ACCELERATED COLLEGIA   Alternative School Yes Elementary PK 08 2021   grade_2                                                   28                                             28
1408599 TX BEXAR COUNTY   school 4832940 15910   NORTH EAST ISD 483294011135 15910160 ALTERNATIVE EL   Alternative School No Elementary 01 02 2021   grade_2                                                   <10                                             10
1409443 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312003715 15915004 HOLMGREEN CENTER   Alternative School No Other PK 12 2021   grade_2                                                   <10                                             10
1409762 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312002944 15915013 REDDIX CENTER   Alternative School No Other PK 12 2021   grade_2                                                   <10                                             10
1410357 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023511986 14804002 NEW HORIZONS   Alternative School Yes Other 01 11 2021   grade_2                                                   <10                                             10
1410435 TX CONCHO COUNTY   school 4833980 48903   PAINT ROCK ISD 483398009184 48903190 WALL SPECIAL PROGRAMS   Alternative School No Elementary 01 07 2021   grade_2                                                   <10                                             10
1411114 TX DALLAS COUNTY   school 4800029 57802   PEGASUS SCHOOL OF LIBERAL ARTS AND 480002907561 57802001 PEGASUS CHARTER H S   Alternative School Yes Other KG 12 2021   grade_2                                                   33                                             33
1412832 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007608098 14803101 TEMPLE CHARTER ACADEMY   Alternative School Yes Other PK 12 2021   grade_2                                                   23                                             23
1415297 TX BEXAR COUNTY   school 4838730 15907   SAN ANTONIO ISD 483873000289 15907201 CHILDREN'S SHELTER OF SA   Alternative School No Elementary PK 05 2021   grade_2                                                   <10                                             10
1417882 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006307795 15807001 SOUTHWEST PREPARATORY SCHOOL   Alternative School Yes Elementary PK 05 2021   grade_2                                                   <20                                             20
1417899 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006308433 15807002 SOUTHWEST PREPARATORY SOUTHEAST CA   Alternative School Yes Other PK 12 2021   grade_2                                                   13                                             13
1417919 TX HARRIS COUNTY   school 4800125 101838   SOUTHWEST SCHOOL 480012508252 101838004 PHOENIX SCHOOL AT SOUTHWEST SCHOOL   Alternative School Yes Other KG 12 2021   grade_2                                                   <10                                             10
1417933 TX HARRIS COUNTY   school 4800125 101838   SOUTHWEST SCHOOL 480012511235 101838102 SOUTHWEST SCHOOLS BISSONNET EL CAM   Alternative School Yes Elementary PK 05 2021   grade_2                                                   69                                             69
1419380 TX TAYLOR COUNTY   school 4800163 221801   TEXAS COLLEGE PREPARATORY ACADEMIE 480016311503 221801011 AMARILLO COLLEGIATE ACADEMY   Alternative School Yes Other KG 12 2021   grade_2                                                   39                                             39
1419422 TX TAYLOR COUNTY   school 4800163 221801   TEXAS COLLEGE PREPARATORY ACADEMIE 480016311553 221801014 COPPELL CLASSICAL ACADEMY   Alternative School Yes Elementary KG 05 2021   grade_2                                                   53                                             53
1419765 TX HAYS COUNTY   school 4800194 105802   TEXAS PREPARATORY SCHOOL 480019408645 105802041 TEXAS PREPARATORY SCHOOL   Alternative School Yes Elementary KG 06 2021   grade_2                                                   <20                                             20
1419786 TX MONTGOMERY COUNTY   school 4800151 170801   TEXAS SERENITY ACADEMY 480015111306 170801003 TEXAS SERENITY ACADEMY   Alternative School Yes Elementary KG 08 2021   grade_2                                                   34                                             34
1421040 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007111351 227806029 DEPELCHIN-RICHMOND   Alternative School Yes Elementary 02 07 2021   grade_2                                                   <10                                             10
1421045 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007109072 227806015 GEORGE M KOZMETSKY SCHOOL   Alternative School Yes Elementary 02 02 2021   grade_2                                                   <10                                             10
1421050 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007112104 227806032 HELPING HAND   Alternative School Yes Elementary 02 07 2021   grade_2                                                   <10                                             10
1421917 TX MCLENNAN COUNTY   school 4800024 161801   WACO CHARTER SCHOOL 480002407392 161801101 WACO CHARTER SCHOOL   Alternative School Yes Elementary PK 05 2021   grade_2                                                   32                                             32
1422254 TX ELLIS COUNTY   school 4800105 70801   WAXAHACHIE FAITH FAMILY ACADEMY 480010512070 70801041 FAITH FAMILY MASTER ACADEMY   Alternative School Yes Elementary PK 08 2021   grade_2                                                   33                                             33
1422264 TX ELLIS COUNTY   school 4800105 70801   WAXAHACHIE FAITH FAMILY ACADEMY 480010513356 70801002 OAK CLIFF FAITH FAMILY ACADEMY   Alternative School Yes Other PK 12 2021   grade_2                                                   152                                             152
1423695 TX EL PASO COUNTY   school 4846680 71905   YSLETA ISD 484668006994 71905138 ALICIA R CHACON INTERNATIONAL   Alternative School No Elementary KG 08 2021   grade_2                                                   85                                             85
1374324 TX DALLAS COUNTY   school 4800095 57816   A W BROWN LEADERSHIP ACADEMY 480009510550 57816102 GENESIS CAMPUS PRE-K THRU 5   Regular School Yes Elementary PK 05 2021   grade_2                                                   76                                             76
1374330 TX DALLAS COUNTY   school 4800095 57816   A W BROWN LEADERSHIP ACADEMY 480009508166 57816101 QUEST CAMPUS PRE-K THRU 8   Regular School Yes Elementary KG 08 2021   grade_2                                                   48                                             48
1374340 TX DALLAS COUNTY   school 4800203 57829   A+ ACADEMY 480020308758 57829001 A+ ACADEMY EL   Regular School Yes Elementary PK 06 2021   grade_2                                                   99                                             99
1374357 TX HILL COUNTY   school 4807380 109901   ABBOTT ISD 480738000006 109901001 ABBOTT SCHOOL   Regular School No Other PK 12 2021   grade_2                                                   18                                             18
1374372 TX HALE COUNTY   school 4807410 95901   ABERNATHY ISD 480741000007 95901101 ABERNATHY EL   Regular School No Elementary PK 05 2021   grade_2                                                   59                                             59
1374394 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000012 221901102 AUSTIN EL   Regular School No Elementary PK 05 2021   grade_2                                                   109                                             109
1374401 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744002371 221901153 BASSETTI EL   Regular School No Elementary PK 05 2021   grade_2                                                   97                                             97
1374408 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000013 221901103 BONHAM EL   Regular School No Elementary PK 05 2021   grade_2                                                   91                                             91
1374415 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000014 221901104 BOWIE EL   Regular School No Elementary PK 05 2021   grade_2                                                   86                                             86
1374441 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000018 221901108 DYESS EL   Regular School No Elementary PK 05 2021   grade_2                                                   <70                                             70
1374448 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000022 221901112 JACKSON EL   Regular School No Elementary PK 05 2021   grade_2                                                   84                                             84
1374455 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000024 221901113 JOHNSTON EL   Regular School No Elementary PK 05 2021   grade_2                                                   106                                             106
1374466 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000026 221901116 LEE EL   Regular School No Elementary PK 05 2021   grade_2                                                   61                                             61
1374480 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744012705 221901155 MARTINEZ EL   Regular School No Elementary KG 05 2021   grade_2                                                   62                                             62
1374489 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744002354 221901152 ORTIZ EL   Regular School No Elementary KG 05 2021   grade_2                                                   86                                             86
1374495 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000033 221901120 REAGAN EL   Regular School No Elementary KG 05 2021   grade_2                                                   <50                                             50
1374504 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744000035 221901121 TAYLOR EL   Regular School No Elementary KG 05 2021   grade_2                                                   102                                             102
1374511 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744002241 221901151 THOMAS EL   Regular School No Elementary PK 05 2021   grade_2                                                   61                                             61
1374517 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744002238 221901150 WARD EL   Regular School No Elementary KG 05 2021   grade_2                                                   78                                             78
1374551 TX BELL COUNTY   school 4807470 14901   ACADEMY ISD 480747013381 14901102 ACADEMY EL   Regular School No Elementary PK 02 2021   grade_2                                                   135                                             135
1374574 TX DALLAS COUNTY   school 4800090 57810   ACADEMY OF DALLAS 480009008161 57810101 ACADEMY OF DALLAS   Regular School Yes Elementary PK 08 2021   grade_2                                                   28                                             28
1374584 TX HARRIS COUNTY   school 4800192 101849   ACCELERATED INTERMEDIATE ACADEMY 480019210716 101849101 ACCELERATED INTERDISCIPLINARY ACAD   Regular School Yes Elementary PK 07 2021   grade_2                                                   23                                             23
1374593 TX OLDHAM COUNTY   school 4807500 180903   ADRIAN ISD 480750000042 180903001 ADRIAN SCHOOL   Regular School No Other PK 12 2021   grade_2                                                   <10                                             10
1374607 TX DALLAS COUNTY   school 4800041 57806   ADVANTAGE ACADEMY 480004108501 57806101 ADVANTAGE ACADEMY   Regular School Yes Other PK 12 2021   grade_2                                                   104                                             104
1374621 TX NUECES COUNTY   school 4807530 178901   AGUA DULCE ISD 480753000043 178901101 AGUA DULCE EL   Regular School No Elementary PK 08 2021   grade_2                                                   24                                             24
1374640 TX BEXAR COUNTY   school 4807590 15901   ALAMO HEIGHTS ISD 480759000047 15901101 CAMBRIDGE EL   Regular School No Elementary 01 05 2021   grade_2                                                   146                                             146
1374648 TX BEXAR COUNTY   school 4807590 15901   ALAMO HEIGHTS ISD 480759000050 15901104 WOODRIDGE EL   Regular School No Elementary 01 05 2021   grade_2                                                   160                                             160
1374656 TX WOOD COUNTY   school 4807650 250906   ALBA-GOLDEN ISD 480765000052 250906101 ALBA-GOLDEN EL   Regular School No Elementary PK 05 2021   grade_2                                                   66                                             66
1374677 TX SHACKELFORD COUNTY   school 4807680 209901   ALBANY ISD 480768000055 209901101 NANCY SMITH EL   Regular School No Elementary PK 06 2021   grade_2                                                   37                                             37
1374690 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000059 101902101 ANDERSON ACADEMY   Regular School No Elementary 01 04 2021   grade_2                                                   215                                             215
1374696 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771006639 101902126 BLACK EL   Regular School No Elementary 01 05 2021   grade_2                                                   104                                             104
1374705 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771009528 101902131 BUSSEY EL   Regular School No Elementary 01 05 2021   grade_2                                                   98                                             98
1374710 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771021292 101902128 CALVERT EL   Regular School No Elementary 01 05 2021   grade_2                                                   63                                             63
1374715 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771013787 101902141 CARAWAY EL   Regular School No Elementary 01 05 2021   grade_2                                                   126                                             126
1374720 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000061 101902122 CARMICHAEL EL   Regular School No Elementary 01 05 2021   grade_2                                                   91                                             91
1374725 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000062 101902103 CARROLL EL   Regular School No Elementary 01 05 2021   grade_2                                                   158                                             158
1374730 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771007919 101902107 CARTER ACADEMY   Regular School No Elementary 01 05 2021   grade_2                                                   107                                             107
1374739 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771005634 101902123 CONLEY EL   Regular School No Elementary 01 05 2021   grade_2                                                   66                                             66
1374744 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771012216 101902136 CYPRESSWOOD EL   Regular School No Elementary 01 05 2021   grade_2                                                   151                                             151
1374758 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771006204 101902124 DUNN EL   Regular School No Elementary 01 05 2021   grade_2                                                   93                                             93
1374763 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771013688 101902137 ECKERT EL   Regular School No Elementary 01 05 2021   grade_2                                                   125                                             125
1374772 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000067 101902121 ERMEL EL   Regular School No Elementary 01 05 2021   grade_2                                                   69                                             69
1374777 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771013771 101902138 ESCAMILLA EL   Regular School No Elementary 01 05 2021   grade_2                                                   156                                             156
1374782 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000069 101902105 FRANCIS EL   Regular School No Elementary 01 05 2021   grade_2                                                   159                                             159
1374793 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000071 101902106 GOODMAN EL   Regular School No Elementary 01 05 2021   grade_2                                                   110                                             110
1374801 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771006638 101902125 GRAY EL   Regular School No Elementary 01 05 2021   grade_2                                                   95                                             95
1374806 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771012174 101902135 GREENSPOINT EL   Regular School No Elementary 01 05 2021   grade_2                                                   156                                             156
1374822 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771008260 101902129 HARRIS EL   Regular School No Elementary 01 05 2021   grade_2                                                   112                                             112
1374828 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771013675 101902144 HILL EL   Regular School No Elementary 01 05 2021   grade_2                                                   87                                             87
1374841 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000074 101902116 JOHNSON EL   Regular School No Elementary 01 05 2021   grade_2                                                   134                                             134
1374849 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771011899 101902134 JONES EL   Regular School No Elementary 01 05 2021   grade_2                                                   155                                             155

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