Data source: Big Local News · About: Big Local

33,750 rows where state = "AZ" and year = 2020 sorted by ccd_charter_school descending

View and edit SQL

grade

year

  • 2020 · 33,750
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
130733 AZ     school 400328 79457   A Center for Creative Education 40032802228 79458 Verde Valley Montessori School - A Center for Creative Education   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   *                                              
130734 AZ     school 400797 90199   Academy Del Sol, Inc. 40079702994 90200 Academy Del Sol   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   *                                              
130735 AZ     school 400797 90199   Academy Del Sol, Inc. 40079703230 90770 Academy Del Sol - Hope   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   *                                              
130736 AZ     school 400414 85540   Academy of Building Industries, Inc. 40041402412 85541 Academy of Building Industries   Alternative School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130737 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 2020   pre_kindergarten                                                   *                                              
130738 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 2020   pre_kindergarten                                                   *                                              
130739 AZ     school 400368 79961   Academy of Mathematics and Science, Inc. 40036802037 79094 Academy of Math and Science   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   *                                              
130740 AZ     school 400940 92768   Academy of Mathematics and Science, Inc. 40094003499 92769 Academy of Math and Science Camelback   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   *                                              
130741 AZ     school 400202 78897   Academy of Tucson, Inc. 40020203141 81130 Academy of Tucson Elementary School   Regular School Yes Elementary KG 05 2020   pre_kindergarten                                                   *                                              
130742 AZ     school 400202 78897   Academy of Tucson, Inc. 40020201959 78898 Academy of Tucson High School   Regular School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130743 AZ     school 400202 78897   Academy of Tucson, Inc. 40020202312 79986 Academy of Tucson Middle School   Regular School Yes Middle 05 08 2020   pre_kindergarten                                                   *                                              
130744 AZ     school 400276 79213   Academy with Community Partners Inc 40027601841 10795 Academy with Community Partners   Alternative School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130749 AZ     school 400129 6364   Accelerated Elementary and Secondary Schools 40012901790 5891 Accelerated Learning Laboratory   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   *                                              
130750 AZ     school 400121 4297   Accelerated Learning Center, Inc. 40012101581 5462 Accelerated Learning Center   Alternative School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130751 AZ     school 400122 4325   Acclaim Charter School 40012201585 5496 ACCLAIM Academy   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   *                                              
130752 AZ     school 400320 79437   Acorn Montessori Charter School 40032002227 79438 Acorn Montessori Charter School   Regular School Yes Middle 03 08 2020   pre_kindergarten                                                   *                                              
130753 AZ     school 400320 79437   Acorn Montessori Charter School 40032002576 88180 Acorn Montessori Charter School, Inc. - West   Regular School Yes Elementary KG 02 2020   pre_kindergarten                                                   *                                              
130760 AZ     school 400274 79053   AIBT Non-Profit Charter High School - Phoenix 40027402020 79123 RCB Medical Arts Academy   Alternative School Yes High 07 12 2020   pre_kindergarten                                                   *                                              
130761 AZ     school 400970 449790   AIBT Non-Profit Charter High School, Inc. 40097003546 742847 RCB College Preparatory Academy   Regular School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130764 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 2020   pre_kindergarten                                                   *                                              
130765 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 2020   pre_kindergarten                                                   *                                              
130782 AZ     school 400396 79969   All Aboard Charter School 40039602306 79970 All Aboard Charter School   Regular School Yes Elementary KG 05 2020   pre_kindergarten                                                   *                                              
130783 AZ     school 400111 4347   Allen-Cochran Enterprises, Inc. 40011101594 5521 Center for Educational Excellence   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   *                                              
130787 AZ     school 400218 79215   American Basic Schools LLC 40021801913 78788 Burke Basic School   Regular School Yes Elementary KG 06 2020   pre_kindergarten                                                   *                                              
130788 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 2020   pre_kindergarten                                                   *                                              
130789 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 2020   pre_kindergarten                                                   *                                              
130790 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 2020   pre_kindergarten                                                   *                                              
130791 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 2020   pre_kindergarten                                                   *                                              
130792 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 2020   pre_kindergarten                                                   *                                              
130793 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 2020   pre_kindergarten                                                   *                                              
130794 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 2020   pre_kindergarten                                                   *                                              
130795 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 2020   pre_kindergarten                                                   *                                              
130796 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 2020   pre_kindergarten                                                   *                                              
130797 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 2020   pre_kindergarten                                                   *                                              
130798 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203570 242454 American Leadership Academy Signal Butte K-6   Regular School Yes Elementary KG 06 2020   pre_kindergarten                                                   *                                              
130799 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203365 92348 American Leadership Academy, Anthem K-6   Regular School Yes Elementary KG 06 2020   pre_kindergarten                                                   *                                              
130800 AZ     school 400112 4348   American Leadership Academy, Inc. 40011201595 5522 American Leadership Academy, Gilbert K-6   Regular School Yes Elementary KG 06 2020   pre_kindergarten                                                   *                                              
130801 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203573 509281 American Leadership Academy, Gilbert North K-12   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   *                                              
130802 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203576 865358 American Leadership Academy, Gilbert South K-6   Regular School Yes Elementary KG 06 2020   pre_kindergarten                                                   *                                              
130803 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203475 92885 American Leadership Academy, Ironwood K12   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   *                                              
130804 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203340 91778 American Leadership Academy, Mesa K-6   Regular School Yes Elementary KG 06 2020   pre_kindergarten                                                   *                                              
130805 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203179 90769 American Leadership Academy, Queen Creek K-12   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   *                                              
130806 AZ     school 400112 4348   American Leadership Academy, Inc. 40011203279 91173 American Leadership Academy, San Tan Valley K-6   Regular School Yes Elementary KG 06 2020   pre_kindergarten                                                   *                                              
130807 AZ     school 400329 79461   American Virtual Academy 40032903159 81178 Primavera - Online   Alternative School Yes High 06 12 2020   pre_kindergarten                                                   *                                              
130832 AZ     school 400819 90532   Anthem Preparatory Academy 40081903187 90635 Great Hearts Academies - Anthem Prep   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   *                                              
130839 AZ     school 400318 79426   Aprender Tucson 40031802203 79432 Southside Community School   Regular School Yes Other KG 09 2020   pre_kindergarten                                                   *                                              
130840 AZ     school 400989 92980   ARCHES Academy 40098903642 1000276 ARCHES Academy   Regular School Yes Elementary KG 07 2020   pre_kindergarten                                                   *                                              
130841 AZ     school 400888 92312   Archway Classical Academy Arete 40088803412 92313 Great Hearts Academies - Archway Arete   Regular School Yes Elementary KG 05 2020   pre_kindergarten                                                   *                                              
130842 AZ     school 400834 90917   Archway Classical Academy Chandler 40083403244 90999 Great Hearts Academies - Archway Chandler   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   *                                              
130843 AZ     school 400886 92314   Archway Classical Academy Cicero 40088603407 92315 Great Hearts Academies - Archway Cicero   Regular School Yes Elementary KG 05 2020   pre_kindergarten                                                   *                                              
130844 AZ     school 400866 91878   Archway Classical Academy Glendale 40086603356 91879 Great Hearts Academies - Archway Glendale   Regular School Yes Elementary KG 05 2020   pre_kindergarten                                                   *                                              
130845 AZ     school 400925 92656   Archway Classical Academy Lincoln 40092503464 92708 Great Hearts Academies - Archway Lincoln   Regular School Yes Elementary KG 05 2020   pre_kindergarten                                                   *                                              
130846 AZ     school 400873 91758   Archway Classical Academy North Phoenix 40087303353 91785 Great Hearts Academies - Archway North Phoenix   Regular School Yes Elementary KG 06 2020   pre_kindergarten                                                   *                                              
130847 AZ     school 400841 90857   Archway Classical Academy Scottsdale 40084103259 90994 Great Hearts Academies - Archway Scottsdale   Regular School Yes Elementary KG 05 2020   pre_kindergarten                                                   *                                              
130848 AZ     school 400930 92704   Archway Classical Academy Trivium East 40093003462 92707 Great Hearts Academies - Archway Trivium East   Regular School Yes Elementary KG 05 2020   pre_kindergarten                                                   *                                              
130849 AZ     school 400832 90915   Archway Classical Academy Trivium West 40083203290 91001 Great Hearts Academies - Archway Trivium West   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   *                                              
130850 AZ     school 400833 90916   Archway Classical Academy Veritas 40083303283 91000 Great Hearts Academies - Archway Veritas   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   *                                              
130851 AZ     school 400757 89486   Arete Preparatory Academy 40075702820 89487 Great Hearts Academies - Arete Prep   Regular School Yes High 06 12 2020   pre_kindergarten                                                   *                                              
130852 AZ     school 400969 134379   Arizona Agribusiness & Equine Center INC. 40096903543 156568 Arizona Agribusiness & Equine Center, Inc. - Mesa   Regular School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130853 AZ     school 400106 4331   Arizona Agribusiness & Equine Center, Inc. 40010601892 6344 AAEC - Paradise Valley   Regular School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130854 AZ     school 400417 85816   Arizona Agribusiness & Equine Center, Inc. 40041701588 5503 AAEC - SMCC Campus   Regular School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130855 AZ     school 400828 90779   Arizona Agribusiness & Equine Center, Inc. 40082803199 90780 Arizona Agribusiness & Equine Center - Estrella   Regular School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130856 AZ     school 400838 91131   Arizona Agribusiness & Equine Center, Inc. 40083803243 91132 Arizona Agribusiness & Equine Center, Inc. - Prescott Valley   Regular School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130857 AZ     school 400426 87403   Arizona Agribusiness & Equine Center, Inc. 40042602528 87404 Arizona Agribusiness & Equine Center, Inc. - Red Mountain   Regular School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130858 AZ     school 400913 91958   Arizona Autism Charter Schools, Inc. 40091303455 92598 Arizona Autism Charter School   Special Education School Yes Elementary KG 06 2020   pre_kindergarten                                                   *                                              
130859 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 2020   pre_kindergarten                                                   *                                              
130860 AZ     school 400057 4346   Arizona Call-a-Teen Youth Resources, Inc. 40005700784 5520 City View High School   Alternative School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130861 AZ     school 400361 79947   Arizona Community Development Corporation 40036102299 79950 La Paloma Academy   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   *                                              
130862 AZ     school 400361 79947   Arizona Community Development Corporation 40036103165 81187 La Paloma Academy (Lakeside)   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   *                                              
130863 AZ     school 400361 79947   Arizona Community Development Corporation 40036103312 91805 La Paloma Academy-South   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   *                                              
130864 AZ     school 400427 87407   Arizona Connections Academy Charter School, Inc. 40042703160 81179 Arizona Connections Academy   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   *                                              
130877 AZ     school 400827 90758   Arizona Education Solutions 40082703252 91184 Valiant Academy   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   *                                              
130878 AZ     school 400827 90758   Arizona Education Solutions 40082703309 91246 Valiant Academy   Regular School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130879 AZ     school 400918 92566   Arizona Language Preparatory 40091803426 92567 Arizona Language Preparatory   Regular School Yes Elementary KG 06 2020   pre_kindergarten                                                   *                                              
130880 AZ     school 400415 85749   Arizona Montessori Charter School at Anthem 40041502414 85750 AMCS at Anthem dba Caurus Academy   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   *                                              
130881 AZ     school 400056 4345   Arizona School For The Arts 40005600781 5519 Arizona School For The Arts   Regular School Yes High 05 12 2020   pre_kindergarten                                                   *                                              
130903 AZ     school 400890 92325   ASU Preparatory Academy 40089003367 92326 ASU Preparatory Academy - Phoenix Middle School   Regular School Yes Middle 05 08 2020   pre_kindergarten                                                   *                                              
130904 AZ     school 400946 346763   ASU Preparatory Academy 40094603375 92248 ASU Preparatory Academy - South Phoenix High School   Regular School Yes High 07 12 2020   pre_kindergarten                                                   *                                              
130905 AZ     school 400788 90273   ASU Preparatory Academy 40078802999 90274 ASU Preparatory Academy - South Phoenix Intermediate   Regular School Yes Elementary 03 06 2020   pre_kindergarten                                                   *                                              
130906 AZ     school 400956 92716   ASU Preparatory Academy 40095603505 70692 ASU Preparatory Academy - South Phoenix Primary   Regular School Yes Elementary PK 04 2020   pre_kindergarten                                                   *                                              
130907 AZ     school 400971 631426   ASU Preparatory Academy 40097103567 338609 ASU Preparatory Academy - Tempe   Regular School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130908 AZ     school 400764 89949   ASU Preparatory Academy 40076403051 90271 ASU Preparatory Academy- Phoenix Elementary   Regular School Yes Elementary KG 04 2020   pre_kindergarten                                                   *                                              
130909 AZ     school 400858 91303   ASU Preparatory Academy 40085803286 91304 ASU Preparatory Academy- Phoenix High School   Regular School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130910 AZ     school 400857 91307   ASU Preparatory Academy 40085703260 91308 ASU Preparatory Academy-Polytechnic Elementary   Regular School Yes Elementary KG 04 2020   pre_kindergarten                                                   *                                              
130911 AZ     school 400859 91305   ASU Preparatory Academy 40085903251 91306 ASU Preparatory Academy-Polytechnic High School   Regular School Yes High 08 12 2020   pre_kindergarten                                                   *                                              
130912 AZ     school 400884 92327   ASU Preparatory Academy 40088403264 91323 ASU Preparatory Academy-Polytechnic Middle School   Regular School Yes Middle 05 07 2020   pre_kindergarten                                                   *                                              
130913 AZ     school 400947 92987   ASU Preparatory Academy - Casa Grande 40094703526 635758 ASU Preparatory Academy - Casa Grande HS   Regular School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130914 AZ     school 400965 522074   ASU Preparatory Academy Digital 40096503556 860177 ASU Preparatory Academy Digital   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   *                                              
130927 AZ     school 400394 79929   Avondale Learning dba Precision Academy 40039402323 80006 Precision Academy   Regular School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130928 AZ     school 400785 89869   AZ Compass Schools, Inc. 40078502929 89870 AZ Compass Prep School   Alternative School Yes High 07 12 2020   pre_kindergarten                                                   *                                              
130929 AZ     school 400094 4508   Az-Tec High School 40009401109 6192 AZTEC High School   Alternative School Yes High 09 12 2020   pre_kindergarten                                                   *                                              
130938 AZ     school 400184 79204   Ball Charter Schools (Dobson) 40018401713 10729 Dobson Academy, The - A Ball Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   *                                              
130939 AZ     school 400100 4294   Ball Charter Schools (Hearn) 40010001714 10730 Hearn Academy, The - A Ball Charter School   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   *                                              
130940 AZ     school 400867 90885   Ball Charter Schools (Val Vista) 40086703342 91791 Ball Charter Schools (Val Vista)   Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   *                                              
130947 AZ     school 400897 91339   BASIS Charter Schools, Inc. 40089703376 92030 BASIS Ahwatukee   Regular School Yes Other 04 12 2020   pre_kindergarten                                                   *                                              
130948 AZ     school 400830 90842   BASIS Charter Schools, Inc. 40083003253 91056 BASIS Chandler   Regular School Yes High 05 12 2020   pre_kindergarten                                                   *                                              
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                                                   *                                              
130950 AZ     school 400936 92865   BASIS Charter Schools, Inc. 40093603484 92866 BASIS Chandler Primary- South Campus   Regular School Yes Elementary KG 05 2020   pre_kindergarten                                                   *                                              
130951 AZ     school 400831 90862   BASIS Charter Schools, Inc. 40083103196 90863 BASIS Flagstaff   Regular School Yes Other KG 12 2020   pre_kindergarten                                                   *                                              
130952 AZ     school 400941 92734   BASIS Charter Schools, Inc. 40094103502 92735 BASIS Goodyear   Regular School Yes High 05 12 2020   pre_kindergarten                                                   *                                              

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