Data source: Big Local News · About: Big Local

7,227 rows where grade = "pre_kindergarten" and state = "TX" sorted by school_state_id

View and edit SQL

year

grade

  • pre_kindergarten · 7,127
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
1412791 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007612994 14803004 CEDAR PARK CHARTER ACADEMY   Regular School Yes Other PK 12 2021   pre_kindergarten                                                   <10                                             10
1651826 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007612994 14803004 CEDAR PARK CHARTER ACADEMY   Regular School Yes Other PK 12 2020   pre_kindergarten                                                   18                                             18
1412829 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007608098 14803101 TEMPLE CHARTER ACADEMY   Alternative School Yes Other PK 12 2021   pre_kindergarten                                                   37                                             37
1651863 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007608098 14803101 TEMPLE CHARTER ACADEMY   Alternative School Yes Other PK 12 2020   pre_kindergarten                                                   23                                             23
1374548 TX BELL COUNTY   school 4807470 14901   ACADEMY ISD 480747013381 14901102 ACADEMY EL   Regular School No Elementary PK 02 2021   pre_kindergarten                                                   24                                             24
1613349 TX BELL COUNTY   school 4807470 14901   ACADEMY ISD 480747013381 14901102 ACADEMY EL   Regular School No Elementary PK 02 2020   pre_kindergarten                                                   <50                                             50
1378074 TX BELL COUNTY   school 4809540 14902   BARTLETT ISD 480954000406 14902001 BARTLETT SCHOOLS   Regular School No Other PK 12 2021   pre_kindergarten                                                   25                                             25
1616944 TX BELL COUNTY   school 4809540 14902   BARTLETT ISD 480954000406 14902001 BARTLETT SCHOOLS   Regular School No Other PK 12 2020   pre_kindergarten                                                   34                                             34
1378445 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986013112 14903119 BELTON EARLY CHILDHOOD SCHOOL   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   304                                             304
1617315 TX BELL COUNTY   school 4809860 14903   BELTON ISD 480986013112 14903119 BELTON EARLY CHILDHOOD SCHOOL   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   416                                             416
1395650 TX BELL COUNTY   school 4823370 14905   HOLLAND ISD 482337002372 14905101 HOLLAND EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <40                                             40
1634644 TX BELL COUNTY   school 4823370 14905   HOLLAND ISD 482337002372 14905101 HOLLAND EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   33                                             33
1400928 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002864 14906102 CLIFTON PARK EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <40                                             40
1639878 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002864 14906102 CLIFTON PARK EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <60                                             60
1400958 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002869 14906105 HARKER HEIGHTS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <70                                             70
1639908 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002869 14906105 HARKER HEIGHTS EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   95                                             95
1401031 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002874 14906108 MEADOWS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   99                                             99
1639983 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002874 14906108 MEADOWS EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   122                                             122
1401077 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002877 14906109 PEEBLES EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   65                                             65
1640028 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002877 14906109 PEEBLES EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   108                                             108
1401084 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002878 14906110 PERSHING PARK EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   69                                             69
1640035 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002878 14906110 PERSHING PARK EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   98                                             98
1401134 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002881 14906111 SUGAR LOAF EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   40                                             40
1640084 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002881 14906111 SUGAR LOAF EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   44                                             44
1401168 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002882 14906112 WEST WARD EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   47                                             47
1640118 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002882 14906112 WEST WARD EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   64                                             64
1400885 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002862 14906113 BELLAIRE EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   45                                             45
1639834 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002862 14906113 BELLAIRE EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   50                                             50
1401057 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002876 14906115 NOLANVILLE EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <50                                             50
1640008 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002876 14906115 NOLANVILLE EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   68                                             68
1400915 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002863 14906116 CLARKE EL   Regular School No Elementary PK 03 2021   pre_kindergarten                                                   166                                             166
1639864 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002863 14906116 CLARKE EL   Regular School No Elementary PK 03 2020   pre_kindergarten                                                   162                                             162
1400969 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566006282 14906119 HAY BRANCH EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   66                                             66
1639919 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566006282 14906119 HAY BRANCH EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   83                                             83
1401175 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566006283 14906120 WILLOW SPRINGS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   92                                             92
1640126 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566006283 14906120 WILLOW SPRINGS EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <130                                             130
1401046 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566006574 14906121 MOUNTAIN VIEW EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <60                                             60
1639998 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566006574 14906121 MOUNTAIN VIEW EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   96                                             96
1401095 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566006733 14906122 REECES CREEK EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <100                                             100
1640045 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566006733 14906122 REECES CREEK EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   116                                             116
1400920 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566021004 14906123 CLEAR CREEK EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   136                                             136
1639870 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566021004 14906123 CLEAR CREEK EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   181                                             181
1400905 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002912 14906124 CEDAR VALLEY EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <60                                             60
1639854 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002912 14906124 CEDAR VALLEY EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <70                                             70
1400893 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002913 14906125 BROOKHAVEN EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   55                                             55
1639842 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002913 14906125 BROOKHAVEN EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   75                                             75
1401161 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566015929 14906126 VENABLE VILLAGE EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   99                                             99
1640111 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566015929 14906126 VENABLE VILLAGE EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   133                                             133
1401150 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566007785 14906127 TRIMMIER EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   65                                             65
1640100 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566007785 14906127 TRIMMIER EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   93                                             93
1401038 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566007786 14906128 MONTAGUE VILLAGE EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   116                                             116
1639990 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566007786 14906128 MONTAGUE VILLAGE EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   153                                             153
1401024 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566008428 14906129 MAXDALE EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   66                                             66
1639976 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566008428 14906129 MAXDALE EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   84                                             84
1400992 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566009456 14906130 IRA CROSS JR EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   53                                             53
1639942 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566009456 14906130 IRA CROSS JR EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   106                                             106
1400985 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566009457 14906131 IDUMA EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <60                                             60
1639934 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566009457 14906131 IDUMA EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   104                                             104
1401065 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566010404 14906132 OVETA CULP HOBBY EL   Regular School No Elementary PK 03 2021   pre_kindergarten                                                   182                                             182
1640016 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566010404 14906132 OVETA CULP HOBBY EL   Regular School No Elementary PK 03 2020   pre_kindergarten                                                   269                                             269
1401142 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566010405 14906133 TIMBER RIDGE EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   74                                             74
1640092 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566010405 14906133 TIMBER RIDGE EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <100                                             100
1401118 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566010407 14906135 SAEGERT EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <80                                             80
1640068 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566010407 14906135 SAEGERT EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <110                                             110
1401126 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566010408 14906136 SKIPCHA EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <100                                             100
1640076 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566010408 14906136 SKIPCHA EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <100                                             100
1401103 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566012047 14906137 RICHARD E CAVAZOS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <50                                             50
1640053 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566012047 14906137 RICHARD E CAVAZOS EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <90                                             90
1400977 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566012378 14906138 HAYNES EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1639927 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566012378 14906138 HAYNES EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <110                                             110
1400936 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566012780 14906139 DR JOSEPH A FOWLER EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <100                                             100
1639886 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566012780 14906139 DR JOSEPH A FOWLER EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <150                                             150
1400875 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566013235 14906140 ALICE W DOUSE EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <90                                             90
1639824 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566013235 14906140 ALICE W DOUSE EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <140                                             140
1401016 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566013633 14906141 MAUDE MOORE WOOD EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   82                                             82
1639968 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566013633 14906141 MAUDE MOORE WOOD EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   93                                             93
1414304 TX BELL COUNTY   school 4837710 14907   ROGERS ISD 483771004224 14907102 ROGERS EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <30                                             30
1653321 TX BELL COUNTY   school 4837710 14907   ROGERS ISD 483771004224 14907102 ROGERS EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   27                                             27
1414983 TX BELL COUNTY   school 4838580 14908   SALADO ISD 483858013806 14908102 THOMAS ARNOLD EL   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   <70                                             70
1653992 TX BELL COUNTY   school 4838580 14908   SALADO ISD 483858013806 14908102 THOMAS ARNOLD EL   Regular School No Elementary PK 05 2020   pre_kindergarten                                                   <80                                             80
1419070 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233004815 14909101 MERIDITH-DUNBAR EARLY CHILDHOOD AC   Regular School No Prekindergarten PK PK 2021   pre_kindergarten                                                   343                                             343
1658122 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233004815 14909101 MERIDITH-DUNBAR EARLY CHILDHOOD AC   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   <460                                             460
1420398 TX BELL COUNTY   school 4843260 14910   TROY ISD 484326008431 14910103 EDNA BIGHAM MAYS EL   Regular School No Elementary PK 01 2021   pre_kindergarten                                                   <70                                             70
1659409 TX BELL COUNTY   school 4843260 14910   TROY ISD 484326008431 14910103 EDNA BIGHAM MAYS EL   Regular School No Elementary PK 01 2020   pre_kindergarten                                                   <60                                             60
1392687 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001407174 15802001 GEORGE GERVIN ACADEMY   Alternative School Yes Other PK 12 2021   pre_kindergarten                                                   222                                             222
1631695 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001407174 15802001 GEORGE GERVIN ACADEMY   Alternative School Yes Other PK 12 2020   pre_kindergarten                                                   315                                             315
1408388 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   pre_kindergarten                                                   14                                             14
1647396 TX BEXAR COUNTY   school 4800061 15805   NEW FRONTIERS PUBLIC SCHOOLS INC 480006111122 15805041 FRANK L MADLA ACCELERATED COLLEGIA   Alternative School Yes Elementary PK 08 2020   pre_kindergarten                                                   63                                             63
1416412 TX BEXAR COUNTY   school 4800062 15806   SCHOOL OF EXCELLENCE IN EDUCATION 480006207794 15806101 DR HARMON W KELLEY EL   Regular School Yes Elementary PK 06 2021   pre_kindergarten                                                   <10                                             10
1655447 TX BEXAR COUNTY   school 4800062 15806   SCHOOL OF EXCELLENCE IN EDUCATION 480006207794 15806101 DR HARMON W KELLEY EL   Regular School Yes Elementary PK 06 2020   pre_kindergarten                                                   28                                             28
1416404 TX BEXAR COUNTY   school 4800062 15806   SCHOOL OF EXCELLENCE IN EDUCATION 480006211404 15806106 DR DAVID C WALKER EL   Regular School Yes Elementary PK 06 2021   pre_kindergarten                                                   <20                                             20
1655439 TX BEXAR COUNTY   school 4800062 15806   SCHOOL OF EXCELLENCE IN EDUCATION 480006211404 15806106 DR DAVID C WALKER EL   Regular School Yes Elementary PK 06 2020   pre_kindergarten                                                   19                                             19
1417879 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006307795 15807001 SOUTHWEST PREPARATORY SCHOOL   Alternative School Yes Elementary PK 05 2021   pre_kindergarten                                                   <10                                             10
1656932 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006307795 15807001 SOUTHWEST PREPARATORY SCHOOL   Alternative School Yes Elementary PK 05 2020   pre_kindergarten                                                   18                                             18
1417896 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006308433 15807002 SOUTHWEST PREPARATORY SOUTHEAST CA   Alternative School Yes Other PK 12 2021   pre_kindergarten                                                   12                                             12
1656949 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006308433 15807002 SOUTHWEST PREPARATORY SOUTHEAST CA   Alternative School Yes Other PK 12 2020   pre_kindergarten                                                   12                                             12
1417875 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006313011 15807101 SOUTHWEST PREP NORTHWEST EL   Regular School Yes Elementary PK 02 2021   pre_kindergarten                                                   <10                                             10
1656928 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006313011 15807101 SOUTHWEST PREP NORTHWEST EL   Regular School Yes Elementary PK 02 2020   pre_kindergarten                                                   <10                                             10
1417864 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006313468 15807102 SEGUIN EL   Regular School Yes Other PK 09 2021   pre_kindergarten                                                   24                                             24
1656918 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006313468 15807102 SEGUIN EL   Regular School Yes Elementary PK 08 2020   pre_kindergarten                                                   38                                             38

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