enrollments

Data source: Big Local News · About: Big Local

127,680 rows where state = "AZ" sorted by district_state_id descending

✎ 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
565253 565253 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   pre_kindergarten                                                   *                                              
567224 567224 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   kindergarten                                                   125                                             125
569195 569195 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   grade_1                                                   113                                             113
571166 571166 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   grade_2                                                   112                                             112
573137 573137 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   grade_3                                                   125                                             125
575108 575108 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   grade_4                                                   124                                             124
577079 577079 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   grade_5                                                   141                                             141
579050 579050 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   grade_6                                                   *                                              
581021 581021 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   grade_7                                                   *                                              
582992 582992 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   grade_8                                                   *                                              
584963 584963 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   grade_9                                                   *                                              
586934 586934 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   grade_10                                                   *                                              
588905 588905 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   grade_11                                                   *                                              
590876 590876 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   grade_12                                                   *                                              
592847 592847 AZ     school 400967 934316   BASIS Charter Schools, Inc 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2019   pk_12_total 197 23 64   * 421     *   27   384 356     *             23   740 197 23 64     421         27   384 356             23   740
130961 130961 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2020   pre_kindergarten                                                   *                                              
133211 133211 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2020   kindergarten                                                   112                                             112
135461 135461 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2020   grade_1                                                   126                                             126
137711 137711 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2020   grade_2                                                   125                                             125
139961 139961 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2020   grade_3                                                   126                                             126
142211 142211 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2020   grade_4                                                   141                                             141
144461 144461 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2020   grade_5                                                   139                                             139
146711 146711 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2020   grade_6                                                   *                                              
148961 148961 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2020   grade_7                                                   *                                              
151211 151211 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2020   grade_8                                                   *                                              
153461 153461 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2020   grade_9                                                   *                                              
155711 155711 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2020   grade_10                                                   *                                              
157961 157961 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2020   grade_11                                                   *                                              
160211 160211 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2020   grade_12                                                   *                                              
162461 162461 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2020   pk_12_total 198 31 74   * 419         43   366 403     44   *         35   769 198 31 74     419         43   366 403     44       35   769
64392 64392 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   pre_kindergarten                                                   *                                              
66708 66708 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   kindergarten                                                   132                                             132
69024 69024 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   grade_1                                                   139                                             139
71340 71340 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   grade_2                                                   126                                             126
73656 73656 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   grade_3                                                   132                                             132
75972 75972 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   grade_4                                                   151                                             151
78288 78288 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   grade_5                                                   153                                             153
80604 80604 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   grade_6                                                   *                                              
82920 82920 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   grade_7                                                   *                                              
85236 85236 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   grade_8                                                   *                                              
87552 87552 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   grade_9                                                   *                                              
89868 89868 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   grade_10                                                   *                                              
92184 92184 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   grade_11                                                   *                                              
94500 94500 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   grade_12                                                   *                                              
96816 96816 AZ     school 400967 934316   BASIS Charter Schools, Inc. 40096703560 469376 BASIS Phoenix Primary   Regular School Yes Elementary KG 05 2021   pk_12_total 191 25 73   * 486     *   56   421 412     47   *         32   833 191 25 73     486         56   421 412     47       32   833
535629 535629 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   pre_kindergarten                                                   *                                              
537604 537604 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   kindergarten                                                   115                                             115
539579 539579 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   grade_1                                                   126                                             126
541554 541554 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   grade_2                                                   119                                             119
543529 543529 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   grade_3                                                   118                                             118
545504 545504 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   grade_4                                                   104                                             104
547479 547479 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   grade_5                                                   *                                              
549454 549454 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   grade_6                                                   *                                              
551429 551429 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   grade_7                                                   *                                              
553404 553404 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   grade_8                                                   *                                              
555379 555379 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   grade_9                                                   *                                              
557354 557354 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   grade_10                                                   *                                              
559329 559329 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   grade_11                                                   *                                              
561304 561304 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   grade_12                                                   *                                              
563279 563279 AZ     school 400958 92997   BASIS Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2018   pk_12_total 116 40 53   * 339     *   29   292 290     32             16   582 116 40 53     339         29   292 290     32       16   582
565271 565271 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   pre_kindergarten                                                   *                                              
567242 567242 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   kindergarten                                                   126                                             126
569213 569213 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   grade_1                                                   127                                             127
571184 571184 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   grade_2                                                   132                                             132
573155 573155 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   grade_3                                                   127                                             127
575126 575126 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   grade_4                                                   126                                             126
577097 577097 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   grade_5                                                   *                                              
579068 579068 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   grade_6                                                   *                                              
581039 581039 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   grade_7                                                   *                                              
583010 583010 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   grade_8                                                   *                                              
584981 584981 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   grade_9                                                   *                                              
586952 586952 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   grade_10                                                   *                                              
588923 588923 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   grade_11                                                   *                                              
590894 590894 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   grade_12                                                   *                                              
592865 592865 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2019   pk_12_total 141 45 65   * 346     *   38   326 312     23             26   638 141 45 65     346         38   326 312     23       26   638
130949 130949 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2020   pre_kindergarten                                                   *                                              
133199 133199 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2020   kindergarten                                                   116                                             116
135449 135449 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2020   grade_1                                                   127                                             127
137699 137699 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2020   grade_2                                                   128                                             128
139949 139949 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2020   grade_3                                                   135                                             135
142199 142199 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2020   grade_4                                                   124                                             124
144449 144449 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2020   grade_5                                                   *                                              
146699 146699 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2020   grade_6                                                   *                                              
148949 148949 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2020   grade_7                                                   *                                              
151199 151199 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2020   grade_8                                                   *                                              
153449 153449 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2020   grade_9                                                   *                                              
155699 155699 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2020   grade_10                                                   *                                              
157949 157949 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2020   grade_11                                                   *                                              
160199 160199 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2020   grade_12                                                   *                                              
162449 162449 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2020   pk_12_total 137 49 67   * 326         48   316 314     19   *         26   630 137 49 67     326         48   316 314     19       26   630
64380 64380 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2021   pre_kindergarten                                                   *                                              
66696 66696 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2021   kindergarten                                                   128                                             128
69012 69012 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2021   grade_1                                                   129                                             129
71328 71328 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2021   grade_2                                                   129                                             129
73644 73644 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2021   grade_3                                                   128                                             128
75960 75960 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2021   grade_4                                                   125                                             125
78276 78276 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2021   grade_5                                                   *                                              
80592 80592 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2021   grade_6                                                   *                                              
82908 82908 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2021   grade_7                                                   *                                              
85224 85224 AZ     school 400958 92997   BASIS Charter Schools, Inc. 40095803534 93010 BASIS Chandler Primary - North Campus   Regular School Yes Elementary KG 04 2021   grade_8                                                   *                                              

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