enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2540747 2540747 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   pre_kindergarten                                                   0                                             0
2540788 2540788 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public Special Education School No Other PK 12 2020   pre_kindergarten                                                   37                                             37
2541070 2541070 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   85                                             85
2541126 2541126 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public Special Education School No Prekindergarten PK PK 2020   pre_kindergarten                                                   151                                             151
2541186 2541186 NM     school 3501110 43   GALLUP 350111000833 177 EDUCATION DEV CENTER Public Special Education School No Other PK 12 2020   pre_kindergarten                                                   1                                             1
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
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
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
2947028 2947028 NM     school 3500060 1   ALBUQUERQUE 350006001079 611 HIGHLAND AUTISM CENTER Public - Special Education Special Education School No Other PK 12 2021   pre_kindergarten                                                   45                                             45
2947301 2947301 NM     school 3500690 42   DEMING 350069000758 1 MY LITTLE SCHOOL Public - Special Education Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                                                   35                                             35
2947355 2947355 NM     school 3500990 65   FARMINGTON 350099030006 55 FARMINGTON PRESCHOOL ACADEMY EAST Public - Special Education Special Education School No Prekindergarten PK PK 2021   pre_kindergarten                                                   96                                             96
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
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
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
2540696 2540696 NM     school 3500122 516   ABQ SCHOOL OF EXCELLENCE 350012201071 1 ABQ SCHOOL OF EXCELLENCE Charter Regular School Yes Other 01 12 2020   pre_kindergarten                                                   0                                             0
2540697 2540697 NM     school 3500123 517   ABQ SIGN LANGUAGE ACADEMY 350012301066 1 ABQ SIGN LANGUAGE ACADEMY Charter Regular School Yes Other KG 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
2540714 2540714 NM     school 3500060 1   ALBUQUERQUE 350006000017 321 A. MONTOYA ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   49                                             49
2540715 2540715 NM     school 3500060 1   ALBUQUERQUE 350006000893 90 ABQ CHARTER ACADEMY Charter Regular School Yes High 09 12 2020   pre_kindergarten                                                   0                                             0
2540716 2540716 NM     school 3500060 1   ALBUQUERQUE 350006001074 749 ACE LEADERSHIP HIGH SCHOOL Charter Regular School Yes High 09 12 2020   pre_kindergarten                                                   0                                             0
2540717 2540717 NM     school 3500060 1   ALBUQUERQUE 350006000020 206 ADOBE ACRES ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   18                                             18
2540718 2540718 NM     school 3500060 1   ALBUQUERQUE 350006000021 207 ALAMEDA ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   36                                             36
2540719 2540719 NM     school 3500060 1   ALBUQUERQUE 350006000022 210 ALAMOSA ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   15                                             15
2540720 2540720 NM     school 3500060 1   ALBUQUERQUE 350006000024 590 ALBUQUERQUE HIGH Public Regular School No High 09 12 2020   pre_kindergarten                                                   0                                             0
2540721 2540721 NM     school 3500060 1   ALBUQUERQUE 350006000924 116 ALICE KING COMMUNITY SCHOOL Charter Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   0                                             0
2540722 2540722 NM     school 3500060 1   ALBUQUERQUE 350006000025 213 ALVARADO ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2540723 2540723 NM     school 3500060 1   ALBUQUERQUE 350006000026 214 APACHE ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   18                                             18
2540724 2540724 NM     school 3500060 1   ALBUQUERQUE 350006000027 215 ARMIJO ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   18                                             18
2540725 2540725 NM     school 3500060 1   ALBUQUERQUE 350006000028 329 ARROYO DEL OSO ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   0                                             0
2540726 2540726 NM     school 3500060 1   ALBUQUERQUE 350006000029 216 ATRISCO ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   17                                             17
2540727 2540727 NM     school 3500060 1   ALBUQUERQUE 350006001037 576 ATRISCO HERITAGE ACADEMY HS Public Regular School No High 09 12 2020   pre_kindergarten                                                   0                                             0
2540728 2540728 NM     school 3500060 1   ALBUQUERQUE 350006000030 222 BANDELIER ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2540729 2540729 NM     school 3500060 1   ALBUQUERQUE 350006000031 225 BARCELONA ELEMENTARY Public Regular School No Elementary PK 06 2020   pre_kindergarten                                                   18                                             18
2540730 2540730 NM     school 3500060 1   ALBUQUERQUE 350006000032 228 BEL-AIR ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   18                                             18
2540731 2540731 NM     school 3500060 1   ALBUQUERQUE 350006000033 229 BELLEHAVEN ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   18                                             18
2540734 2540734 NM     school 3500060 1   ALBUQUERQUE 350006000035 339 CARLOS REY ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   19                                             19
2540735 2540735 NM     school 3500060 1   ALBUQUERQUE 350006000642 295 CHAMIZA ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2540736 2540736 NM     school 3500060 1   ALBUQUERQUE 350006000036 234 CHAPARRAL ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   75                                             75
2540737 2540737 NM     school 3500060 1   ALBUQUERQUE 350006000037 236 CHELWOOD ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2540739 2540739 NM     school 3500060 1   ALBUQUERQUE 350006000925 118 CHRISTINE DUNCAN HERITAGE ACADEMY Charter Regular School Yes Elementary PK 08 2020   pre_kindergarten                                                   39                                             39
2540740 2540740 NM     school 3500060 1   ALBUQUERQUE 350006000038 580 CIBOLA HIGH Public Regular School No High 09 12 2020   pre_kindergarten                                                   0                                             0
2540741 2540741 NM     school 3500060 1   ALBUQUERQUE 350006001050 780 CIEN AGUAS INTERNATIONAL Charter Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   0                                             0
2540742 2540742 NM     school 3500060 1   ALBUQUERQUE 350006000617 407 CLEVELAND MIDDLE Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2540743 2540743 NM     school 3500060 1   ALBUQUERQUE 350006000040 237 COCHITI ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   48                                             48
2540744 2540744 NM     school 3500060 1   ALBUQUERQUE 350006001100 591 COLLEGE AND CAREER HIGH SCHOOL Public Regular School No High 09 12 2020   pre_kindergarten                                                   0                                             0
2540745 2540745 NM     school 3500060 1   ALBUQUERQUE 350006000041 240 COLLET PARK ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   39                                             39
2540746 2540746 NM     school 3500060 1   ALBUQUERQUE 350006000042 241 COMANCHE ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   18                                             18
2540748 2540748 NM     school 3500060 1   ALBUQUERQUE 350006001081 706 CORAL COMMUNITY CHARTER Charter Regular School Yes Not applicable N N 2020   pre_kindergarten                                                   38                                             38
2540749 2540749 NM     school 3500060 1   ALBUQUERQUE 350006001054 243 CORONADO ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2540750 2540750 NM     school 3500060 1   ALBUQUERQUE 350006000107 351 CORRALES ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2540751 2540751 NM     school 3500060 1   ALBUQUERQUE 350006001028 28 CORRALES INTERNATIONAL Charter Regular School Yes Other KG 12 2020   pre_kindergarten                                                   0                                             0
2540752 2540752 NM     school 3500060 1   ALBUQUERQUE 350006001031 769 COTTONWOOD CLASSICAL PREP Charter Regular School Yes High 06 12 2020   pre_kindergarten                                                   0                                             0
2540754 2540754 NM     school 3500060 1   ALBUQUERQUE 350006000044 514 DEL NORTE HIGH Public Regular School No High 09 12 2020   pre_kindergarten                                                   0                                             0
2540755 2540755 NM     school 3500060 1   ALBUQUERQUE 350006000681 203 DENNIS CHAVEZ ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   67                                             67
2540756 2540756 NM     school 3500060 1   ALBUQUERQUE 350006000764 430 DESERT RIDGE MIDDLE Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2540758 2540758 NM     school 3500060 1   ALBUQUERQUE 350006000853 63 DIGITAL ARTS AND TECHNOLOGY Charter Regular School Yes High 09 12 2020   pre_kindergarten                                                   0                                             0
2540759 2540759 NM     school 3500060 1   ALBUQUERQUE 350006000045 244 DOLORES GONZALES ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   18                                             18
2540760 2540760 NM     school 3500060 1   ALBUQUERQUE 350006000752 350 DOUBLE EAGLE ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   0                                             0
2540761 2540761 NM     school 3500060 1   ALBUQUERQUE 350006000047 249 DURANES ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2540763 2540763 NM     school 3500060 1   ALBUQUERQUE 350006000808 24 EAST MOUNTAIN HIGH SCHOOL Charter Regular School Yes High 09 12 2020   pre_kindergarten                                                   0                                             0
2540764 2540764 NM     school 3500060 1   ALBUQUERQUE 350006000048 252 EAST SAN JOSE ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   19                                             19
2540765 2540765 NM     school 3500060 1   ALBUQUERQUE 350006001099 517 ECADEMY VIRTUAL HIGH SCHOOL Public Regular School No High 09 12 2020   pre_kindergarten                                                   0                                             0
2540766 2540766 NM     school 3500060 1   ALBUQUERQUE 350006000647 219 EDMUND G ROSS ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   18                                             18
2540767 2540767 NM     school 3500060 1   ALBUQUERQUE 350006000896 262 EDWARD GONZALES ELEMENTARY Public Regular School No Elementary 03 05 2020   pre_kindergarten                                                   0                                             0
2540768 2540768 NM     school 3500060 1   ALBUQUERQUE 350006000049 480 EISENHOWER MIDDLE Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2540769 2540769 NM     school 3500060 1   ALBUQUERQUE 350006000854 69 EL CAMINO REAL ACADEMY Charter Regular School Yes Other KG 12 2020   pre_kindergarten                                                   0                                             0
2540770 2540770 NM     school 3500060 1   ALBUQUERQUE 350006000050 515 ELDORADO HIGH Public Regular School No Other PK 12 2020   pre_kindergarten                                                   20                                             20
2540771 2540771 NM     school 3500060 1   ALBUQUERQUE 350006000051 255 EMERSON ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   19                                             19
2540772 2540772 NM     school 3500060 1   ALBUQUERQUE 350006000052 450 ERNIE PYLE MIDDLE Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2540773 2540773 NM     school 3500060 1   ALBUQUERQUE 350006000054 261 EUGENE FIELD ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   18                                             18
2540775 2540775 NM     school 3500060 1   ALBUQUERQUE 350006000056 410 GARFIELD MIDDLE Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2540776 2540776 NM     school 3500060 1   ALBUQUERQUE 350006001114 496 GEORGE I SANCHEZ Public Regular School No Elementary PK 08 2020   pre_kindergarten                                                   0                                             0
2540777 2540777 NM     school 3500060 1   ALBUQUERQUE 350006000726 328 GEORGIA O'KEEFFE ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2540778 2540778 NM     school 3500060 1   ALBUQUERQUE 350006000890 707 GILBERT L SENA CHARTER HS Charter Regular School Yes Not applicable N N 2020   pre_kindergarten                                                   0                                             0
2540779 2540779 NM     school 3500060 1   ALBUQUERQUE 350006001040 30 GORDON BERNELL CHARTER Charter Regular School Yes High 09 12 2020   pre_kindergarten                                                   0                                             0
2540780 2540780 NM     school 3500060 1   ALBUQUERQUE 350006000057 230 GOV BENT ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   17                                             17
2540781 2540781 NM     school 3500060 1   ALBUQUERQUE 350006000058 413 GRANT MIDDLE Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2540782 2540782 NM     school 3500060 1   ALBUQUERQUE 350006000059 267 GRIEGOS ELEMENTARY Public Regular School No Elementary KG 05 2020   pre_kindergarten                                                   0                                             0
2540783 2540783 NM     school 3500060 1   ALBUQUERQUE 350006000060 415 HARRISON MIDDLE Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2540784 2540784 NM     school 3500060 1   ALBUQUERQUE 350006000061 270 HAWTHORNE ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   20                                             20
2540785 2540785 NM     school 3500060 1   ALBUQUERQUE 350006000062 416 HAYES MIDDLE Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2540786 2540786 NM     school 3500060 1   ALBUQUERQUE 350006001098 752 HEALTH LEADERSHIP HIGH SCHOOL Charter Regular School Yes High 09 12 2020   pre_kindergarten                                                   0                                             0
2540787 2540787 NM     school 3500060 1   ALBUQUERQUE 350006001043 395 HELEN CORDERO PRIMARY Public Regular School No Elementary PK 02 2020   pre_kindergarten                                                   54                                             54
2540789 2540789 NM     school 3500060 1   ALBUQUERQUE 350006000063 520 HIGHLAND HIGH Public Regular School No High 09 12 2020   pre_kindergarten                                                   0                                             0
2540790 2540790 NM     school 3500060 1   ALBUQUERQUE 350006000064 273 HODGIN ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   68                                             68
2540792 2540792 NM     school 3500060 1   ALBUQUERQUE 350006000066 418 HOOVER MIDDLE Public Regular School No Middle 06 08 2020   pre_kindergarten                                                   0                                             0
2540793 2540793 NM     school 3500060 1   ALBUQUERQUE 350006000616 221 HUBERT H HUMPHREY ELEMENTARY Public Regular School No Elementary PK 05 2020   pre_kindergarten                                                   0                                             0
2540794 2540794 NM     school 3500060 1   ALBUQUERQUE 350006000067 276 INEZ ELEMENTARY Public Regular School No Elementary PK 05 2020   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]);