enrollments

Data source: Big Local News · About: Big Local

1,973 rows where grade = "pre_kindergarten" and state = "NM" sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pre_kindergarten · 1,973 ✖
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
2541666 2541666 NM     school 3500001 26   VAUGHN 350000100607 168 VAUGHN ELEMENTARY Public Regular School No Elementary PK 06 2020   pre_kindergarten                                                   5                                             5
2541667 2541667 NM     school 3500001 26   VAUGHN 350000100608 169 VAUGHN HIGH Public Regular School No High 07 12 2020   pre_kindergarten                                                   0                                             0
2947889 2947889 NM     school 3500001 26   VAUGHN 350000100607 168 VAUGHN ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pre_kindergarten                                                   6                                             6
2947890 2947890 NM     school 3500001 26   VAUGHN 350000100608 169 VAUGHN HIGH Public - High School Regular School No High 07 12 2021   pre_kindergarten                                                   0                                             0
2541492 2541492 NM     school 3500010 83   RIO RANCHO 350001001034 21 CIELO AZUL ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2541493 2541493 NM     school 3500010 83   RIO RANCHO 350001001024 11 CLEVELAND HIGH SCHOOL Public Regular School No High 09 12 2020   pre_kindergarten                                                   0                                             0
2541494 2541494 NM     school 3500010 83   RIO RANCHO 350001000750 50 COLINAS DEL NORTE ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2541495 2541495 NM     school 3500010 83   RIO RANCHO 350001000761 1 EAGLE RIDGE MIDDLE Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2541496 2541496 NM     school 3500010 83   RIO RANCHO 350001030011 100 ENCHANTED HILLS ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2541497 2541497 NM     school 3500010 83   RIO RANCHO 350001000736 372 ERNEST STAPLETON ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2541498 2541498 NM     school 3500010 83   RIO RANCHO 350001000805 13 INDEPENDENCE HIGH SCHOOL Public Alternative School No High 09 12 2020   pre_kindergarten                                                   0                                             0
2541499 2541499 NM     school 3500010 83   RIO RANCHO 350001000682 481 LINCOLN MIDDLE Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2541500 2541500 NM     school 3500010 83   RIO RANCHO 350001000952 12 MAGGIE CORDOVA ELEMENTARY SCHOOL Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2541501 2541501 NM     school 3500010 83   RIO RANCHO 350001000710 375 MARTIN KING JR ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2541503 2541503 NM     school 3500010 83   RIO RANCHO 350001000739 105 MOUNTAIN VIEW MIDDLE Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2541504 2541504 NM     school 3500010 83   RIO RANCHO 350001000650 319 PUESTA DEL SOL ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2541505 2541505 NM     school 3500010 83   RIO RANCHO 350001000954 18 RIO RANCHO CYBER ACADEMY Public Alternative School No High 06 12 2020   pre_kindergarten                                                   0                                             0
2541506 2541506 NM     school 3500010 83   RIO RANCHO 350001000101 340 RIO RANCHO ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2541507 2541507 NM     school 3500010 83   RIO RANCHO 350001000779 6 RIO RANCHO HIGH Public Regular School No High 09 12 2020   pre_kindergarten                                                   0                                             0
2541508 2541508 NM     school 3500010 83   RIO RANCHO 350001000865 16 RIO RANCHO MIDDLE SCHOOL Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2541509 2541509 NM     school 3500010 83   RIO RANCHO 350001001039 20 SANDIA VISTA ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   0                                             0
2541510 2541510 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   612                                             612
2541511 2541511 NM     school 3500010 83   RIO RANCHO 350001000864 15 VISTA GRANDE ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2947714 2947714 NM     school 3500010 83   RIO RANCHO 350001001034 21 CIELO AZUL ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947715 2947715 NM     school 3500010 83   RIO RANCHO 350001001024 11 CLEVELAND HIGH SCHOOL Public - High School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
2947716 2947716 NM     school 3500010 83   RIO RANCHO 350001000750 50 COLINAS DEL NORTE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947717 2947717 NM     school 3500010 83   RIO RANCHO 350001000761 1 EAGLE RIDGE MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947718 2947718 NM     school 3500010 83   RIO RANCHO 350001030011 100 ENCHANTED HILLS ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947719 2947719 NM     school 3500010 83   RIO RANCHO 350001000736 372 ERNEST STAPLETON ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947721 2947721 NM     school 3500010 83   RIO RANCHO 350001000805 13 INDEPENDENCE HIGH SCHOOL Public - High School Alternative School No High 09 12 2021   pre_kindergarten                                                   0                                             0
2947722 2947722 NM     school 3500010 83   RIO RANCHO 350001001159 25 JOE HARRIS ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947723 2947723 NM     school 3500010 83   RIO RANCHO 350001000682 481 LINCOLN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947724 2947724 NM     school 3500010 83   RIO RANCHO 350001000952 12 MAGGIE CORDOVA ELEMENTARY SCHOOL Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947725 2947725 NM     school 3500010 83   RIO RANCHO 350001000710 375 MARTIN KING JR ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947727 2947727 NM     school 3500010 83   RIO RANCHO 350001000739 105 MOUNTAIN VIEW MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947728 2947728 NM     school 3500010 83   RIO RANCHO 350001000650 319 PUESTA DEL SOL ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947729 2947729 NM     school 3500010 83   RIO RANCHO 350001000954 18 RIO RANCHO CYBER ACADEMY Public - High School Alternative School No High 06 12 2021   pre_kindergarten                                                   0                                             0
2947730 2947730 NM     school 3500010 83   RIO RANCHO 350001000101 340 RIO RANCHO ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947731 2947731 NM     school 3500010 83   RIO RANCHO 350001000779 6 RIO RANCHO HIGH Public - High School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
2947732 2947732 NM     school 3500010 83   RIO RANCHO 350001000865 16 RIO RANCHO MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947733 2947733 NM     school 3500010 83   RIO RANCHO 350001001039 20 SANDIA VISTA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   0                                             0
2947734 2947734 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public - Special Education Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                                                   577                                             577
2947735 2947735 NM     school 3500010 83   RIO RANCHO 350001000864 15 VISTA GRANDE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2541285 2541285 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported Alternative School No High 09 12 2020   pre_kindergarten                                                   0                                             0
2541286 2541286 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported Alternative School No High 06 12 2020   pre_kindergarten                                                   0                                             0
2541287 2541287 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported Alternative School No High 06 12 2020   pre_kindergarten                                                   0                                             0
2947511 2947511 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported - State Supported Alternative School No High 09 12 2021   pre_kindergarten                                                   0                                             0
2947512 2947512 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported - State Supported Alternative School No High 06 12 2021   pre_kindergarten                                                   0                                             0
2947513 2947513 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported - State Supported Alternative School No High 06 12 2021   pre_kindergarten                                                   0                                             0
2541443 2541443 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541444 2541444 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541445 2541445 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541446 2541446 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541447 2541447 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported Alternative School No Secondary 09 11 2020   pre_kindergarten                                                   0                                             0
2541448 2541448 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541449 2541449 NM     school 3500012 91   NM CORRECTIONS 350001200970 5 ROSWELL CORRECTIONS State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541450 2541450 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541451 2541451 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2541452 2541452 NM     school 3500012 91   NM CORRECTIONS 350001200979 8 WESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   pre_kindergarten                                                   0                                             0
2947667 2947667 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   pre_kindergarten                                                   0                                             0
2947668 2947668 NM     school 3500012 91   NM CORRECTIONS 350001200976 7 GUADALUPE COUNTY CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   pre_kindergarten                                                   0                                             0
2947669 2947669 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   pre_kindergarten                                                   0                                             0
2947670 2947670 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported - State Supported Alternative School No High 08 12 2021   pre_kindergarten                                                   0                                             0
2947671 2947671 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   pre_kindergarten                                                   0                                             0
2947672 2947672 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported - State Supported Alternative School No High 08 12 2021   pre_kindergarten                                                   0                                             0
2947673 2947673 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported - State Supported Alternative School No High 08 12 2021   pre_kindergarten                                                   0                                             0
2947674 2947674 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   pre_kindergarten                                                   0                                             0
2947675 2947675 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported - State Supported Alternative School No High 08 12 2021   pre_kindergarten                                                   0                                             0
2541454 2541454 NM     school 3500013 94   NM SCHOOL FOR THE BLIND AND VISUALLY IMP 350001300980 15 NM SCHOOL FOR THE BLIND AND VISUALLY IMPAIRED State Supported Special Education School No Other PK 12 2020   pre_kindergarten                                                   2                                             2
2947677 2947677 NM     school 3500013 94   NM SCHOOL FOR THE BLIND AND VISUALLY IMP 350001300980 15 NM SCHOOL FOR THE BLIND AND VISUALLY IMPAIRED State Supported - State Supported Special Education School No Other PK 12 2021   pre_kindergarten                                                   5                                             5
2541455 2541455 NM     school 3500014 93   NM SCHOOL FOR THE DEAF 350001400972 150 NM SCHOOL FOR THE DEAF State Supported Special Education School No Other PK 12 2020   pre_kindergarten                                                   7                                             7
2947678 2947678 NM     school 3500014 93   NM SCHOOL FOR THE DEAF 350001400972 150 NM SCHOOL FOR THE DEAF State Supported - State Supported Special Education School No Other PK 12 2021   pre_kindergarten                                                   10                                             10
2541594 2541594 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   pre_kindergarten                                                   0                                             0
2947814 2947814 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   pre_kindergarten                                                   0                                             0
2541008 2541008 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   pre_kindergarten                                                   0                                             0
2947888 2947888 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   pre_kindergarten                                                   0                                             0
2540698 2540698 NM     school 3500030 46   ALAMOGORDO 350003000799 4 ACADEMY DEL SOL ALT. Public Alternative School No High 10 12 2020   pre_kindergarten                                                   0                                             0
2540699 2540699 NM     school 3500030 46   ALAMOGORDO 350003000001 15 ALAMOGORDO HIGH Public Regular School No High 09 12 2020   pre_kindergarten                                                   0                                             0
2540700 2540700 NM     school 3500030 46   ALAMOGORDO 350003000002 28 BUENA VISTA ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2540701 2540701 NM     school 3500030 46   ALAMOGORDO 350003000003 33 CHAPARRAL MIDDLE Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2540702 2540702 NM     school 3500030 46   ALAMOGORDO 350003000012 144 DESERT STAR ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   2                                             2
2540703 2540703 NM     school 3500030 46   ALAMOGORDO 350003000005 57 HIGH ROLLS MOUNTAIN PARK ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2540704 2540704 NM     school 3500030 46   ALAMOGORDO 350003000006 58 HOLLOMAN ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   44                                             44
2540705 2540705 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2540707 2540707 NM     school 3500030 46   ALAMOGORDO 350003000008 72 LA LUZ ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2540709 2540709 NM     school 3500030 46   ALAMOGORDO 350003000798 3 MOUNTAIN VIEW MIDDLE Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2540710 2540710 NM     school 3500030 46   ALAMOGORDO 350003000010 114 NORTH ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   106                                             106
2540711 2540711 NM     school 3500030 46   ALAMOGORDO 350003000013 150 SIERRA ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   1                                             1
2540712 2540712 NM     school 3500030 46   ALAMOGORDO 350003000004 56 SUNSET HILLS ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2540713 2540713 NM     school 3500030 46   ALAMOGORDO 350003000016 181 YUCCA ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   35                                             35
2946940 2946940 NM     school 3500030 46   ALAMOGORDO 350003000799 4 ACADEMY DEL SOL ALT. Public - High School Alternative School No High 10 12 2021   pre_kindergarten                                                   0                                             0
2946941 2946941 NM     school 3500030 46   ALAMOGORDO 350003000001 15 ALAMOGORDO HIGH Public - High School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
2946942 2946942 NM     school 3500030 46   ALAMOGORDO 350003000002 28 BUENA VISTA ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2946943 2946943 NM     school 3500030 46   ALAMOGORDO 350003000003 33 CHAPARRAL MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2946944 2946944 NM     school 3500030 46   ALAMOGORDO 350003000012 144 DESERT STAR ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2946945 2946945 NM     school 3500030 46   ALAMOGORDO 350003000005 57 HIGH ROLLS MOUNTAIN PARK ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2946946 2946946 NM     school 3500030 46   ALAMOGORDO 350003000006 58 HOLLOMAN ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   45                                             45
2946947 2946947 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2946948 2946948 NM     school 3500030 46   ALAMOGORDO 350003000008 72 LA LUZ ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2946950 2946950 NM     school 3500030 46   ALAMOGORDO 350003000798 3 MOUNTAIN VIEW MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0

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