Data source: Big Local News · About: Big Local

4,098 rows where grade = "grade_12" and state = "TX" sorted by school_state_id

View and edit SQL

year

grade

  • grade_12 · 3,998
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
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
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
1411218 TX BEE COUNTY   school 4834770 13903   PETTUS ISD 483477003899 13903001 PETTUS SECONDARY   Regular School No High 06 12 2021   grade_12                                                   23                                             23
1650241 TX BEE COUNTY   school 4834770 13903   PETTUS ISD 483477003899 13903001 PETTUS SECONDARY   Regular School No High 06 12 2020   grade_12                                                   32                                             32
1417122 TX BEE COUNTY   school 4840410 13905   SKIDMORE-TYNAN ISD 484041004576 13905001 SKIDMORE-TYNAN H S   Regular School No High 09 12 2021   grade_12                                                   56                                             56
1656158 TX BEE COUNTY   school 4840410 13905   SKIDMORE-TYNAN ISD 484041004576 13905001 SKIDMORE-TYNAN H S   Regular School No High 09 12 2020   grade_12                                                   63                                             63
1413435 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007508097 14801001 RICHARD MILBURN ALTER H S (KILLEEN   Alternative School Yes High 09 12 2021   grade_12                                                   33                                             33
1652449 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007508097 14801001 RICHARD MILBURN ALTER H S (KILLEEN   Alternative School Yes High 09 12 2020   grade_12                                                   50                                             50
1413427 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007509647 14801002 RICHARD MILBURN ACADEMY ODESSA   Alternative School Yes High 09 12 2021   grade_12                                                   103                                             103
1652441 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007509647 14801002 RICHARD MILBURN ACADEMY ODESSA   Alternative School Yes High 09 12 2020   grade_12                                                   116                                             116
1413419 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007508324 14801004 RICHARD MILBURN ACADEMY LUBBOCK   Alternative School Yes High 09 12 2021   grade_12                                                   25                                             25
1652433 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007508324 14801004 RICHARD MILBURN ACADEMY LUBBOCK   Alternative School Yes High 09 12 2020   grade_12                                                   37                                             37
1413415 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007513173 14801005 RICHARD MILBURN ACADEMY HOUSTON (S   Alternative School Yes High 09 12 2021   grade_12                                                   75                                             75
1652429 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007513173 14801005 RICHARD MILBURN ACADEMY HOUSTON (S   Alternative School Yes High 09 12 2020   grade_12                                                   77                                             77
1413411 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007509507 14801006 RICHARD MILBURN ACADEMY FORT WORTH   Alternative School Yes High 09 12 2021   grade_12                                                   47                                             47
1652425 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007509507 14801006 RICHARD MILBURN ACADEMY FORT WORTH   Alternative School Yes High 09 12 2020   grade_12                                                   43                                             43
1413407 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007508344 14801007 RICHARD MILBURN ACADEMY CORPUS CHR   Alternative School Yes High 09 12 2021   grade_12                                                   47                                             47
1652421 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007508344 14801007 RICHARD MILBURN ACADEMY CORPUS CHR   Alternative School Yes High 09 12 2020   grade_12                                                   67                                             67
1413403 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007509009 14801008 RICHARD MILBURN ACADEMY AMARILLO   Alternative School Yes High 09 12 2021   grade_12                                                   34                                             34
1652417 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007509009 14801008 RICHARD MILBURN ACADEMY AMARILLO   Alternative School Yes High 09 12 2020   grade_12                                                   41                                             41
1413431 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007513435 14801009 RICHARD MILBURN ACADEMY PASADENA   Alternative School Yes High 09 12 2021   grade_12                                                   45                                             45
1652445 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007513435 14801009 RICHARD MILBURN ACADEMY PASADENA   Alternative School Yes High 09 12 2020   grade_12                                                   42                                             42
1413423 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007513433 14801010 RICHARD MILBURN ACADEMY MIDLAND SO   Alternative School Yes High 09 12 2021   grade_12                                                   29                                             29
1652437 TX BELL COUNTY   school 4800075 14801   RICHARD MILBURN ALTER HIGH SCHOOL 480007513433 14801010 RICHARD MILBURN ACADEMY MIDLAND SO   Alternative School Yes High 09 12 2020   grade_12                                                   29                                             29
1412818 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007613035 14803003 COVE CHARTER ACADEMY   Regular School Yes Other PK 12 2021   grade_12                                                   10                                             10
1651852 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007613035 14803003 COVE CHARTER ACADEMY   Regular School Yes Other PK 12 2020   grade_12                                                   <10                                             10
1412804 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007612994 14803004 CEDAR PARK CHARTER ACADEMY   Regular School Yes Other PK 12 2021   grade_12                                                   <10                                             10
1412842 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007608098 14803101 TEMPLE CHARTER ACADEMY   Alternative School Yes Other PK 12 2021   grade_12                                                   <10                                             10
1651876 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007608098 14803101 TEMPLE CHARTER ACADEMY   Alternative School Yes Other PK 12 2020   grade_12                                                   <10                                             10
1410344 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023512289 14804005 GATEWAY TECH H S   Alternative School Yes High 09 12 2021   grade_12                                                   <10                                             10
1649361 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023512289 14804005 GATEWAY TECH H S   Alternative School Yes High 09 12 2020   grade_12                                                   14                                             14
1410340 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023512294 14804006 GATEWAY COLLEGE PREPARATORY SCHOOL   Regular School Yes Other KG 12 2021   grade_12                                                   <80                                             80
1649357 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023512294 14804006 GATEWAY COLLEGE PREPARATORY SCHOOL   Regular School Yes Other KG 12 2020   grade_12                                                   55                                             55
1374555 TX BELL COUNTY   school 4807470 14901   ACADEMY ISD 480747000040 14901001 ACADEMY H S   Regular School No High 09 12 2021   grade_12                                                   123                                             123
1613356 TX BELL COUNTY   school 4807470 14901   ACADEMY ISD 480747000040 14901001 ACADEMY H S   Regular School No High 09 12 2020   grade_12                                                   111                                             111
1378087 TX BELL COUNTY   school 4809540 14902   BARTLETT ISD 480954000406 14902001 BARTLETT SCHOOLS   Regular School No Other PK 12 2021   grade_12                                                   24                                             24
1616957 TX BELL COUNTY   school 4809540 14902   BARTLETT ISD 480954000406 14902001 BARTLETT SCHOOLS   Regular School No Other PK 12 2020   grade_12                                                   21                                             21
1378449 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986000454 14903001 BELTON H S   Regular School No High 09 12 2021   grade_12                                                   849                                             849
1617319 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986000454 14903001 BELTON H S   Regular School No High 09 12 2020   grade_12                                                   679                                             679
1617323 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986008099 14903005 BELTON NEW TECH H S AT WASKOW   Regular School No High 09 12 2020   grade_12                                                   117                                             117
1395660 TX BELL COUNTY   school 4823370 14905   HOLLAND ISD 482337002373 14905001 HOLLAND H S   Regular School No High 09 12 2021   grade_12                                                   54                                             54
1634654 TX BELL COUNTY   school 4823370 14905   HOLLAND ISD 482337002373 14905001 HOLLAND H S   Regular School No High 09 12 2020   grade_12                                                   55                                             55
1401002 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002871 14906001 KILLEEN H S   Regular School No High 09 12 2021   grade_12                                                   476                                             476
1639952 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002871 14906001 KILLEEN H S   Regular School No High 09 12 2020   grade_12                                                   441                                             441
1400903 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002866 14906002 C E ELLISON H S   Regular School No High 09 12 2021   grade_12                                                   551                                             551
1639852 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002866 14906002 C E ELLISON H S   Regular School No High 09 12 2020   grade_12                                                   595                                             595
1400953 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566006281 14906004 GATEWAY H S   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1639904 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566006281 14906004 GATEWAY H S   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1401076 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566021001 14906006 PATHWAYS ACADEMIC CAMPUS   Alternative School No High 09 12 2021   grade_12                                                   <200                                             200
1640027 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566021001 14906006 PATHWAYS ACADEMIC CAMPUS   Alternative School No High 09 12 2020   grade_12                                                   132                                             132
1400968 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566008695 14906007 HARKER HEIGHTS H S   Regular School No High 09 12 2021   grade_12                                                   608                                             608
1639918 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566008695 14906007 HARKER HEIGHTS H S   Regular School No High 09 12 2020   grade_12                                                   604                                             604
1401113 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566008696 14906008 ROBERT M SHOEMAKER H S   Regular School No High 09 12 2021   grade_12                                                   451                                             451
1640063 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566008696 14906008 ROBERT M SHOEMAKER H S   Regular School No High 09 12 2020   grade_12                                                   455                                             455
1401006 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566013234 14906013 KILLEEN ISD EARLY COLLEGE H S   Regular School No High 09 12 2021   grade_12                                                   260                                             260
1639956 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566013234 14906013 KILLEEN ISD EARLY COLLEGE H S   Regular School No High 09 12 2020   grade_12                                                   229                                             229
1639822 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002861 14906022 ADVENTHEALTH SCHOOL   Alternative School No Other 01 12 2020   grade_12                                                   <10                                             10
1414314 TX BELL COUNTY   school 4837710 14907   ROGERS ISD 483771004225 14907001 ROGERS H S   Regular School No High 09 12 2021   grade_12                                                   64                                             64
1653331 TX BELL COUNTY   school 4837710 14907   ROGERS ISD 483771004225 14907001 ROGERS H S   Regular School No High 09 12 2020   grade_12                                                   60                                             60
1653320 TX BELL COUNTY   school 4837710 14907   ROGERS ISD 483771012091 14907043 BELL COUNTY DAEP   Alternative School No High 09 12 2020   grade_12                                                   <10                                             10
1414978 TX BELL COUNTY   school 4838580 14908   SALADO ISD 483858004288 14908001 SALADO H S   Regular School No High 09 12 2021   grade_12                                                   <170                                             170
1653987 TX BELL COUNTY   school 4838580 14908   SALADO ISD 483858004288 14908001 SALADO H S   Regular School No High 09 12 2020   grade_12                                                   144                                             144
1414974 TX BELL COUNTY   school 4838580 14908   SALADO ISD 483858010411 14908005 BELL COUNTY DAEP   Alternative School No High 10 12 2021   grade_12                                                   <10                                             10
1419089 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233004827 14909002 TEMPLE H S   Regular School No High 09 12 2021   grade_12                                                   474                                             474
1658141 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233004827 14909002 TEMPLE H S   Regular School No High 09 12 2020   grade_12                                                   472                                             472
1658165 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233008430 14909005 WHEATLEY ALTERNATIVE EDUCATION CEN   Alternative School No High 06 12 2020   grade_12                                                   <10                                             10
1658083 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233008697 14909006 BELL CO J J A E P   Alternative School No High 08 12 2020   grade_12                                                   <10                                             10
1419046 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233012581 14909008 FRED W EDWARDS ACADEMY AEC   Alternative School No High 09 12 2021   grade_12                                                   24                                             24
1658097 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233012581 14909008 FRED W EDWARDS ACADEMY AEC   Alternative School No High 09 12 2020   grade_12                                                   25                                             25
1420411 TX BELL COUNTY   school 4843260 14910   TROY ISD 484326004913 14910001 TROY H S   Regular School No High 09 12 2021   grade_12                                                   102                                             102
1659422 TX BELL COUNTY   school 4843260 14910   TROY ISD 484326004913 14910001 TROY H S   Regular School No High 09 12 2020   grade_12                                                   107                                             107
1412309 TX BEXAR COUNTY   school 4800004 15801   POR VIDA ACADEMY 480000407173 15801001 POR VIDA ACADEMY CHARTER H S   Alternative School Yes High 09 12 2021   grade_12                                                   17                                             17
1651340 TX BEXAR COUNTY   school 4800004 15801   POR VIDA ACADEMY 480000407173 15801001 POR VIDA ACADEMY CHARTER H S   Alternative School Yes High 09 12 2020   grade_12                                                   12                                             12
1412313 TX BEXAR COUNTY   school 4800004 15801   POR VIDA ACADEMY 480000409116 15801002 POR VIDA ACADEMY CORPUS CHRISTI   Alternative School Yes High 09 12 2021   grade_12                                                   22                                             22
1651336 TX BEXAR COUNTY   school 4800004 15801   POR VIDA ACADEMY 480000409116 15801002 CORPUS CHRISTI COLLEGE PREP H S   Alternative School Yes High 09 12 2020   grade_12                                                   12                                             12
1651332 TX BEXAR COUNTY   school 4800004 15801   POR VIDA ACADEMY 480000409460 15801003 CESAR E CHAVEZ ACADEMY   Alternative School Yes High 09 12 2020   grade_12                                                   21                                             21
1392697 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001407174 15802001 GEORGE GERVIN ACADEMY   Alternative School Yes Other PK 12 2021   grade_12                                                   <10                                             10
1631705 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001407174 15802001 GEORGE GERVIN ACADEMY   Alternative School Yes Other PK 12 2020   grade_12                                                   11                                             11
1392703 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001410415 15802004 RUTH JONES MCCLENDON MIDDLE   Alternative School Yes High 06 12 2021   grade_12                                                   <10                                             10
1631712 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001410415 15802004 RUTH JONES MCCLENDON MIDDLE   Alternative School Yes High 06 12 2020   grade_12                                                   <10                                             10
1408401 TX BEXAR COUNTY   school 4800061 15805   NEW FRONTIERS PUBLIC SCHOOLS INC 480006113123 15805001 FRANK L MADLA EARLY COLLEGE H S   Regular School Yes High 09 12 2021   grade_12                                                   43                                             43
1647409 TX BEXAR COUNTY   school 4800061 15805   NEW FRONTIERS PUBLIC SCHOOLS INC 480006113123 15805001 FRANK L MADLA EARLY COLLEGE H S   Regular School Yes High 09 12 2020   grade_12                                                   63                                             63
1416425 TX BEXAR COUNTY   school 4800062 15806   SCHOOL OF EXCELLENCE IN EDUCATION 480006212237 15806003 MILTON B LEE ACADEMY OF SCIENCE &   Regular School Yes High 09 12 2021   grade_12                                                   30                                             30
1655460 TX BEXAR COUNTY   school 4800062 15806   SCHOOL OF EXCELLENCE IN EDUCATION 480006212237 15806003 MILTON B LEE ACADEMY OF SCIENCE &   Regular School Yes High 09 12 2020   grade_12                                                   21                                             21
1417909 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006308433 15807002 SOUTHWEST PREPARATORY SOUTHEAST CA   Alternative School Yes Other PK 12 2021   grade_12                                                   11                                             11
1656962 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006308433 15807002 SOUTHWEST PREPARATORY SOUTHEAST CA   Alternative School Yes Other PK 12 2020   grade_12                                                   14                                             14
1417895 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006309118 15807004 SOUTHWEST PREPARATORY SCHOOL-NORTH   Alternative School Yes Other 03 12 2021   grade_12                                                   61                                             61
1656948 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006309118 15807004 SOUTHWEST PREPARATORY SCHOOL-NORTH   Alternative School Yes Other 03 12 2020   grade_12                                                   21                                             21
1417863 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006310419 15807005 NEW DIRECTIONS   Alternative School Yes High 06 12 2021   grade_12                                                   10                                             10
1656917 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006310419 15807005 NEW DIRECTIONS   Alternative School Yes High 06 12 2020   grade_12                                                   16                                             16
1637831 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005307796 15808001 JHW INSPIRE ACADEMY - AFTON OAKS   Alternative School Yes High 06 12 2020   grade_12                                                   <10                                             10
1398865 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005309121 15808003 JHW INSPIRE ACADEMY - HAYS COUNTY   Alternative School Yes High 07 12 2021   grade_12                                                   <10                                             10
1398884 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005312039 15808007 JHW INSPIRE ACADEMY - ROCKDALE   Alternative School Yes High 06 12 2021   grade_12                                                   <10                                             10
1637865 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005312039 15808007 JHW INSPIRE ACADEMY - ROCKDALE   Alternative School Yes High 05 12 2020   grade_12                                                   <10                                             10
1398856 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313163 15808009 ANNE FRANK INSPIRE ACADEMY   Regular School Yes Other KG 12 2021   grade_12                                                   40                                             40
1637824 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313163 15808009 ANNE FRANK INSPIRE ACADEMY   Regular School Yes Other KG 12 2020   grade_12                                                   17                                             17
1637857 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313204 15808010 JHW INSPIRE ACADEMY - MERIDELL   Alternative School Yes High 06 12 2020   grade_12                                                   <10                                             10
1637873 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313326 15808011 JHW INSPIRE ACADEMY - WILLIAMS HOU   Alternative School Yes High 05 12 2020   grade_12                                                   <10                                             10
1398877 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2021   grade_12                                                   <10                                             10
1412430 TX BEXAR COUNTY   school 4800059 15814   POSITIVE SOLUTIONS CHARTER SCHOOL 480005907798 15814001 POSITIVE SOLUTIONS CHARTER   Alternative School Yes High 09 12 2021   grade_12                                                   13                                             13

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