enrollments

Data source: Big Local News · About: Big Local

8,512 rows where grade = "grade_1" and state = "AZ" sorted by ccd_charter_school descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 8,512 ✖
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
68806 68806 AZ     school 400998 1000166   A+ Charter Schools 40099803681 1000972 A+ Charter Schools   Regular School Yes High 07 12 2021   grade_1                                                   *                                              
68807 68807 AZ     school 400797 90199   Academy Del Sol, Inc. 40079702994 90200 Academy Del Sol   Regular School Yes Elementary KG 08 2021   grade_1                                                   36                                             36
68808 68808 AZ     school 400797 90199   Academy Del Sol, Inc. 40079703230 90770 Academy Del Sol - Hope   Regular School Yes Elementary KG 08 2021   grade_1                                                   57                                             57
68809 68809 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Alternative School Yes High 09 12 2021   grade_1                                                   *                                              
68810 68810 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103676 1000378 Academy of Math and Science Avondale   Regular School Yes Elementary KG 08 2021   grade_1                                                   138                                             138
68811 68811 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103581 911531 Academy of Math and Science Desert Sky   Regular School Yes Elementary KG 08 2021   grade_1                                                   165                                             165
68812 68812 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103618 1000119 Academy of Math and Science Glendale   Regular School Yes Elementary KG 08 2021   grade_1                                                   197                                             197
68813 68813 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103604 1000118 Academy of Math and Science Peoria Advanced   Regular School Yes Elementary KG 08 2021   grade_1                                                   98                                             98
68814 68814 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103677 1000379 Academy of Math and Science South Mountain   Regular School Yes Elementary KG 08 2021   grade_1                                                   98                                             98
68815 68815 AZ     school 400891 90878   Academy of Mathematics and Science South, Inc. 40089103399 92197 Academy of Mathematics and Science South   Regular School Yes Elementary KG 08 2021   grade_1                                                   58                                             58
68816 68816 AZ     school 400368 79961   Academy of Mathematics and Science, Inc. 40036802037 79094 Academy of Math and Science   Regular School Yes Other KG 12 2021   grade_1                                                   58                                             58
68817 68817 AZ     school 400940 92768   Academy of Mathematics and Science, Inc. 40094003499 92769 Academy of Math and Science Camelback   Regular School Yes Elementary KG 08 2021   grade_1                                                   113                                             113
68818 68818 AZ     school 400202 78897   Academy of Tucson, Inc. 40020203141 81130 Academy of Tucson Elementary School   Regular School Yes Elementary KG 05 2021   grade_1                                                   28                                             28
68819 68819 AZ     school 400202 78897   Academy of Tucson, Inc. 40020201959 78898 Academy of Tucson High School   Regular School Yes High 09 12 2021   grade_1                                                   *                                              
68820 68820 AZ     school 400202 78897   Academy of Tucson, Inc. 40020202312 79986 Academy of Tucson Middle School   Regular School Yes Middle 05 08 2021   grade_1                                                   *                                              
68821 68821 AZ     school 400276 79213   Academy with Community Partners Inc 40027601841 10795 Academy with Community Partners   Alternative School Yes High 09 12 2021   grade_1                                                   *                                              
68825 68825 AZ     school 400129 6364   Accelerated Elementary and Secondary Schools 40012901790 5891 Accelerated Learning Laboratory   Regular School Yes Other KG 12 2021   grade_1                                                   16                                             16
68826 68826 AZ     school 400121 4297   Accelerated Learning Center, Inc. 40012101581 5462 Accelerated Learning Center   Alternative School Yes High 09 12 2021   grade_1                                                   *                                              
68827 68827 AZ     school 400122 4325   Acclaim Charter School 40012201585 5496 ACCLAIM Academy   Regular School Yes Elementary KG 08 2021   grade_1                                                   34                                             34
68828 68828 AZ     school 400320 79437   Acorn Montessori Charter School 40032002227 79438 Acorn Montessori Charter School   Regular School Yes Middle 03 08 2021   grade_1                                                   *                                              
68829 68829 AZ     school 400320 79437   Acorn Montessori Charter School 40032002576 88180 Acorn Montessori Charter School, Inc. - West   Regular School Yes Elementary KG 02 2021   grade_1                                                   66                                             66
68836 68836 AZ     school 400274 79053   AIBT Non-Profit Charter High School - Phoenix 40027402020 79123 Career and College Prep   Alternative School Yes High 07 12 2021   grade_1                                                   *                                              
68837 68837 AZ     school 400970 449790   AIBT Non-Profit Charter High School, Inc. 40097003546 742847 RCB College Preparatory Academy   Regular School Yes High 09 12 2021   grade_1                                                   *                                              
68840 68840 AZ     school 400403 5978   Akimel O Otham Pee Posh Charter School, Inc. 40040301989 10797 Akimel O'Otham Pee Posh (K-2)   Regular School Yes Elementary KG 02 2021   grade_1                                                   *                                              
68841 68841 AZ     school 400404 78966   Akimel O'Otham Pee Posh Charter School, Inc. 40040401993 78967 Akimel O'Otham Pee Posh (3-5)   Regular School Yes Elementary 03 05 2021   grade_1                                                   *                                              
68859 68859 AZ     school 400396 79969   All Aboard Charter School 40039602306 79970 All Aboard Charter School   Regular School Yes Elementary KG 05 2021   grade_1                                                   21                                             21
68860 68860 AZ     school 400111 4347   Allen-Cochran Enterprises, Inc. 40011101594 5521 Center for Educational Excellence   Regular School Yes Elementary KG 08 2021   grade_1                                                   41                                             41
68864 68864 AZ     school 400218 79215   American Basic Schools LLC 40021801913 78788 Burke Basic School   Regular School Yes Elementary KG 06 2021   grade_1                                                   115                                             115
68865 68865 AZ     school 400619 80995   American Charter Schools Foundation d.b.a. Alta Vista High School 40061903097 80996 Alta Vista High School   Alternative School Yes High 09 12 2021   grade_1                                                   *                                              
68866 68866 AZ     school 400357 79883   American Charter Schools Foundation d.b.a. Apache Trail High School 40035701732 6346 Apache Trail High School   Alternative School Yes High 09 12 2021   grade_1                                                   *                                              
68867 68867 AZ     school 400385 79874   American Charter Schools Foundation d.b.a. Crestview College Preparatory High Sc 40038502016 78813 Crestview College Preparatory High School   Alternative School Yes High 07 12 2021   grade_1                                                   *                                              
68868 68868 AZ     school 400384 79872   American Charter Schools Foundation d.b.a. Desert Hills High School 40038401899 78901 Desert Hills High School   Alternative School Yes High 09 12 2021   grade_1                                                   *                                              
68869 68869 AZ     school 400352 79873   American Charter Schools Foundation d.b.a. Estrella High School 40035201898 78900 Estrella High School   Alternative School Yes High 09 12 2021   grade_1                                                   *                                              
68870 68870 AZ     school 400353 79875   American Charter Schools Foundation d.b.a. Peoria Accelerated High School 40035301896 78817 Peoria Accelerated High School   Alternative School Yes High 09 12 2021   grade_1                                                   *                                              
68871 68871 AZ     school 400618 80989   American Charter Schools Foundation d.b.a. South Pointe High School 40061803095 80990 South Pointe High School   Alternative School Yes High 09 12 2021   grade_1                                                   *                                              
68872 68872 AZ     school 400447 88334   American Charter Schools Foundation d.b.a. South Ridge High School 40044702671 88335 South Ridge High School   Regular School Yes High 09 12 2021   grade_1                                                   *                                              
68873 68873 AZ     school 400354 79877   American Charter Schools Foundation d.b.a. Sun Valley High School 40035401733 6347 Sun Valley High School   Alternative School Yes High 09 12 2021   grade_1                                                   *                                              
68874 68874 AZ     school 400355 79879   American Charter Schools Foundation d.b.a. West Phoenix High School 40035501734 6348 West Phoenix High School   Alternative School Yes High 09 12 2021   grade_1                                                   *                                              
68875 68875 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203570 242454 American Leadership Academy Signal Butte K-6   Regular School Yes Elementary KG 06 2021   grade_1                                                   87                                             87
68876 68876 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203365 92348 American Leadership Academy, Anthem K-6   Regular School Yes Elementary KG 06 2021   grade_1                                                   88                                             88
68877 68877 AZ     school 400112 4348   American Leadership Academy, Inc. 40011201595 5522 American Leadership Academy, Gilbert K-6   Regular School Yes Elementary KG 06 2021   grade_1                                                   119                                             119
68878 68878 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203573 509281 American Leadership Academy, Gilbert North K-12   Regular School Yes Other KG 12 2021   grade_1                                                   116                                             116
68879 68879 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203576 865358 American Leadership Academy, Gilbert South K-6   Regular School Yes Elementary KG 06 2021   grade_1                                                   82                                             82
68880 68880 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203475 92885 American Leadership Academy, Ironwood K12   Regular School Yes Other KG 12 2021   grade_1                                                   117                                             117
68881 68881 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203340 91778 American Leadership Academy, Mesa K-6   Regular School Yes Elementary KG 06 2021   grade_1                                                   59                                             59
68882 68882 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203179 90769 American Leadership Academy, Queen Creek K-12   Regular School Yes Other KG 12 2021   grade_1                                                   112                                             112
68883 68883 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203279 91173 American Leadership Academy, San Tan Valley K-6   Regular School Yes Elementary KG 06 2021   grade_1                                                   106                                             106
68884 68884 AZ     school 400329 79461   American Virtual Academy 40032903159 81178 Primavera - Online   Alternative School Yes High 06 12 2021   grade_1                                                   *                                              
68909 68909 AZ     school 400819 90532   Anthem Preparatory Academy 40081903187 90635 Great Hearts Academies - Anthem Prep   Regular School Yes Other KG 12 2021   grade_1                                                   60                                             60
68916 68916 AZ     school 400318 79426   Aprender Tucson 40031802203 79432 Southside Community School   Regular School Yes Other KG 09 2021   grade_1                                                   25                                             25
68917 68917 AZ     school 400989 92980   ARCHES Academy 40098903642 1000276 ARCHES Academy   Regular School Yes Elementary KG 08 2021   grade_1                                                   *                                              
68918 68918 AZ     school 400888 92312   Archway Classical Academy Arete 40088803412 92313 Great Hearts Academies - Archway Arete   Regular School Yes Elementary KG 05 2021   grade_1                                                   88                                             88
68919 68919 AZ     school 400834 90917   Archway Classical Academy Chandler 40083403244 90999 Great Hearts Academies - Archway Chandler   Regular School Yes Other KG 12 2021   grade_1                                                   91                                             91
68920 68920 AZ     school 400886 92314   Archway Classical Academy Cicero 40088603407 92315 Great Hearts Academies - Archway Cicero   Regular School Yes Elementary KG 05 2021   grade_1                                                   89                                             89
68921 68921 AZ     school 400866 91878   Archway Classical Academy Glendale 40086603356 91879 Great Hearts Academies - Archway Glendale   Regular School Yes Elementary KG 05 2021   grade_1                                                   96                                             96
68922 68922 AZ     school 400925 92656   Archway Classical Academy Lincoln 40092503464 92708 Great Hearts Academies - Archway Lincoln   Regular School Yes Elementary KG 05 2021   grade_1                                                   120                                             120
68923 68923 AZ     school 400873 91758   Archway Classical Academy North Phoenix 40087303353 91785 Great Hearts Academies - Archway North Phoenix   Regular School Yes Elementary KG 06 2021   grade_1                                                   122                                             122
68924 68924 AZ     school 400841 90857   Archway Classical Academy Scottsdale 40084103259 90994 Great Hearts Academies - Archway Scottsdale   Regular School Yes Elementary KG 05 2021   grade_1                                                   178                                             178
68925 68925 AZ     school 400930 92704   Archway Classical Academy Trivium East 40093003462 92707 Great Hearts Academies - Archway Trivium East   Regular School Yes Elementary KG 05 2021   grade_1                                                   97                                             97
68926 68926 AZ     school 400832 90915   Archway Classical Academy Trivium West 40083203290 91001 Great Hearts Academies - Archway Trivium West   Regular School Yes Other KG 12 2021   grade_1                                                   93                                             93
68927 68927 AZ     school 400833 90916   Archway Classical Academy Veritas 40083303283 91000 Great Hearts Academies - Archway Veritas   Regular School Yes Other KG 12 2021   grade_1                                                   120                                             120
68928 68928 AZ     school 400757 89486   Arete Preparatory Academy 40075702820 89487 Great Hearts Academies - Arete Prep   Regular School Yes High 06 12 2021   grade_1                                                   *                                              
68929 68929 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes High 09 12 2021   grade_1                                                   *                                              
68930 68930 AZ     school 400106 4331   Arizona Agribusiness & Equine Center, Inc. 40010601892 6344 AAEC - Paradise Valley   Regular School Yes High 09 12 2021   grade_1                                                   *                                              
68931 68931 AZ     school 400417 85816   Arizona Agribusiness & Equine Center, Inc. 40041701588 5503 AAEC - SMCC Campus   Regular School Yes High 09 12 2021   grade_1                                                   *                                              
68932 68932 AZ     school 400828 90779   Arizona Agribusiness & Equine Center, Inc. 40082803199 90780 Arizona Agribusiness & Equine Center - Estrella   Regular School Yes High 09 12 2021   grade_1                                                   *                                              
68933 68933 AZ     school 400838 91131   Arizona Agribusiness & Equine Center, Inc. 40083803243 91132 Arizona Agribusiness & Equine Center, Inc. - Prescott Valley   Regular School Yes High 09 12 2021   grade_1                                                   *                                              
68934 68934 AZ     school 400426 87403   Arizona Agribusiness & Equine Center, Inc. 40042602528 87404 Arizona Agribusiness & Equine Center, Inc. - Red Mountain   Regular School Yes High 09 12 2021   grade_1                                                   *                                              
68935 68935 AZ     school 400913 91958   Arizona Autism Charter Schools, Inc. 40091303455 92598 Arizona Autism Charter School   Special Education School Yes Elementary KG 06 2021   grade_1                                                   28                                             28
68936 68936 AZ     school 400913 91958   Arizona Autism Charter Schools, Inc. 40091303512 92984 Arizona Autism Charter School, Upper School Campus   Special Education School Yes High 05 12 2021   grade_1                                                   *                                              
68937 68937 AZ     school 400057 4346   Arizona Call-a-Teen Youth Resources, Inc. 40005700784 5520 City View High School   Alternative School Yes High 09 12 2021   grade_1                                                   *                                              
68938 68938 AZ     school 400361 79947   Arizona Community Development Corporation 40036102299 79950 La Paloma Academy   Regular School Yes Elementary KG 08 2021   grade_1                                                   82                                             82
68939 68939 AZ     school 400361 79947   Arizona Community Development Corporation 40036103165 81187 La Paloma Academy (Lakeside)   Regular School Yes Elementary KG 08 2021   grade_1                                                   111                                             111
68940 68940 AZ     school 400361 79947   Arizona Community Development Corporation 40036103312 91805 La Paloma Academy-South   Regular School Yes Elementary KG 08 2021   grade_1                                                   49                                             49
68941 68941 AZ     school 400427 87407   Arizona Connections Academy Charter School, Inc. 40042703160 81179 Arizona Connections Academy   Regular School Yes Other KG 12 2021   grade_1                                                   157                                             157
68952 68952 AZ     school 400827 90758   Arizona Education Solutions 40082703252 91184 Astravo Online Academy   Regular School Yes Elementary KG 08 2021   grade_1                                                   80                                             80
68953 68953 AZ     school 400827 90758   Arizona Education Solutions 40082703309 91246 Astravo Online Academy   Regular School Yes High 05 12 2021   grade_1                                                   *                                              
68954 68954 AZ     school 400918 92566   Arizona Language Preparatory 40091803426 92567 Arizona Language Preparatory   Regular School Yes Elementary KG 06 2021   grade_1                                                   12                                             12
68955 68955 AZ     school 400415 85749   Arizona Montessori Charter School at Anthem 40041502414 85750 AMCS at Anthem dba Caurus Academy   Regular School Yes Other KG 12 2021   grade_1                                                   44                                             44
68956 68956 AZ     school 400056 4345   Arizona School For The Arts 40005600781 5519 Arizona School For The Arts   Regular School Yes High 05 12 2021   grade_1                                                   *                                              
68967 68967 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2021   grade_1                                                   *                                              
68968 68968 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 ASU Preparatory Academy - South Phoenix High School   Regular School Yes High 07 12 2021   grade_1                                                   *                                              
68969 68969 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 ASU Preparatory Academy - South Phoenix Intermediate   Regular School Yes Elementary 03 06 2021   grade_1                                                   *                                              
68970 68970 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 ASU Preparatory Academy - South Phoenix Primary   Regular School Yes Elementary PK 04 2021   grade_1                                                   25                                             25
68971 68971 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2021   grade_1                                                   71                                             71
68972 68972 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2021   grade_1                                                   *                                              
68973 68973 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2021   grade_1                                                   101                                             101
68974 68974 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 08 12 2021   grade_1                                                   *                                              
68975 68975 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 07 2021   grade_1                                                   *                                              
68976 68976 AZ     school 400947 92987   ASU Preparatory Academy - Casa Grande 40094703526 635758 ASU Preparatory Academy - Casa Grande HS   Regular School Yes High 09 12 2021   grade_1                                                   *                                              
68977 68977 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes Other KG 12 2021   grade_1                                                   92                                             92
68990 68990 AZ     school 400394 79929   Avondale Learning dba Precision Academy 40039402323 80006 Precision Academy   Regular School Yes High 09 12 2021   grade_1                                                   *                                              
68991 68991 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Alternative School Yes High 07 12 2021   grade_1                                                   *                                              
68992 68992 AZ     school 400094 4508   Az-Tec High School 40009401109 6192 AZTEC High School   Alternative School Yes High 09 12 2021   grade_1                                                   *                                              
69001 69001 AZ     school 400184 79204   Ball Charter Schools (Dobson) 40018401713 10729 Dobson Academy, The - A Ball Charter School   Regular School Yes Elementary KG 08 2021   grade_1                                                   64                                             64
69002 69002 AZ     school 400100 4294   Ball Charter Schools (Hearn) 40010001714 10730 Hearn Academy, The - A Ball Charter School   Regular School Yes Elementary KG 08 2021   grade_1                                                   68                                             68
69003 69003 AZ     school 400867 90885   Ball Charter Schools (Val Vista) 40086703342 91791 Ball Charter Schools (Val Vista)   Regular School Yes Elementary KG 08 2021   grade_1                                                   42                                             42
69010 69010 AZ     school 400897 91339   BASIS Charter Schools, Inc. 40089703376 92030 BASIS Ahwatukee   Regular School Yes Other 04 12 2021   grade_1                                                   *                                              
69011 69011 AZ     school 400830 90842   BASIS Charter Schools, Inc. 40083003253 91056 BASIS Chandler   Regular School Yes High 05 12 2021   grade_1                                                   *                                              
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

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