enrollments

Data source: Big Local News · About: Big Local

1,973 rows where grade = "kindergarten_full_day" and state = "NM" sorted by total_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • kindergarten_full_day · 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 ▲
2541963 2541963 NM     school 3500300 20   CARLSBAD 350030000166 47 EARLY CHILDHOOD EDUCATION CENTER Public Regular School No Elementary PK KG 2020   kindergarten_full_day                                                   590                                             590
2948186 2948186 NM     school 3500300 20   CARLSBAD 350030000166 47 EARLY CHILDHOOD EDUCATION CENTER Public - Elementary School Regular School No Elementary PK KG 2021   kindergarten_full_day                                                   494                                             494
2948126 2948126 NM     school 3500120 22   ARTESIA 350012000620 54 GRAND HEIGHTS EARLY CHILDHOOD Public - Elementary School Regular School No Elementary PK KG 2021   kindergarten_full_day                                                   321                                             321
2541905 2541905 NM     school 3500120 22   ARTESIA 350012000620 54 GRAND HEIGHTS EARLY CHILDHOOD Public Regular School No Elementary PK KG 2020   kindergarten_full_day                                                   290                                             290
2542388 2542388 NM     school 3501740 31   LOVINGTON 350174000447 78 LLANO ELEMENTARY Public Regular School No Elementary PK KG 2020   kindergarten_full_day                                                   252                                             252
2948595 2948595 NM     school 3501740 31   LOVINGTON 350174000447 78 LLANO ELEMENTARY Public - Elementary School Regular School No Elementary PK KG 2021   kindergarten_full_day                                                   237                                             237
2948399 2948399 NM     school 3501110 43   GALLUP 350111000308 77 LINCOLN ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   kindergarten_full_day                                                   209                                             209
2947983 2947983 NM     school 3500060 1   ALBUQUERQUE 350006001099 517 ECADEMY Public - High School Regular School No Other KG 12 2021   kindergarten_full_day                                                   188                                             188
2542464 2542464 NM     school 3502100 57   PORTALES 350210000485 28 BROWN EARLY CHILDHOOD CENTER Public Regular School No Elementary PK KG 2020   kindergarten_full_day                                                   187                                             187
2541945 2541945 NM     school 3500240 66   BLOOMFIELD 350024000609 30 BLOOMFIELD EARLY CHILDHOOD CENTER Public Regular School No Elementary PK KG 2020   kindergarten_full_day                                                   169                                             169
2948670 2948670 NM     school 3502100 57   PORTALES 350210000485 28 BROWN EARLY CHILDHOOD CENTER Public - Elementary School Regular School No Elementary PK KG 2021   kindergarten_full_day                                                   165                                             165
2542539 2542539 NM     school 3502310 36   RUIDOSO 350231000464 145 SIERRA VISTA PRIMARY Public Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   158                                             158
2542496 2542496 NM     school 3500010 83   RIO RANCHO 350001000710 375 MARTIN KING JR ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   157                                             157
2542495 2542495 NM     school 3500010 83   RIO RANCHO 350001000952 12 MAGGIE CORDOVA ELEMENTARY SCHOOL Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   149                                             149
2542600 2542600 NM     school 3502430 23   SILVER CITY 350243000565 155 SIXTH STREET ELEMENTARY Public Regular School No Elementary KG KG 2020   kindergarten_full_day                                                   146                                             146
2948005 2948005 NM     school 3500060 1   ALBUQUERQUE 350006001043 395 HELEN CORDERO PRIMARY Public - Elementary School Regular School No Elementary PK 02 2021   kindergarten_full_day                                                   139                                             139
2948166 2948166 NM     school 3500240 66   BLOOMFIELD 350024000609 30 BLOOMFIELD EARLY CHILDHOOD CENTER Public - Elementary School Regular School No Elementary PK KG 2021   kindergarten_full_day                                                   138                                             138
2948192 2948192 NM     school 3500300 20   CARLSBAD 350030001127 5 PECOS CONNECTIONS ACADEMY Charter - High School Regular School Yes Other KG 12 2021   kindergarten_full_day                                                   136                                             136
2948504 2948504 NM     school 3501500 17   LAS CRUCES 350150000794 6 CESAR CHAVEZ ELEMENTARY Public - Elementary School Regular School No Elementary PK 02 2021   kindergarten_full_day                                                   136                                             136
2541782 2541782 NM     school 3500060 1   ALBUQUERQUE 350006001043 395 HELEN CORDERO PRIMARY Public Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   133                                             133
2541869 2541869 NM     school 3500060 1   ALBUQUERQUE 350006001018 389 TIERRA ANTIGUA ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   129                                             129
2542487 2542487 NM     school 3500010 83   RIO RANCHO 350001001034 21 CIELO AZUL ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   126                                             126
2948697 2948697 NM     school 3500010 83   RIO RANCHO 350001000736 372 ERNEST STAPLETON ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   kindergarten_full_day                                                   126                                             126
2948743 2948743 NM     school 3502310 36   RUIDOSO 350231000464 145 SIERRA VISTA PRIMARY Public - Elementary School Regular School No Elementary PK 02 2021   kindergarten_full_day                                                   126                                             126
2542492 2542492 NM     school 3500010 83   RIO RANCHO 350001000736 372 ERNEST STAPLETON ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   122                                             122
2948804 2948804 NM     school 3502430 23   SILVER CITY 350243000565 155 SIXTH STREET ELEMENTARY Public - Elementary School Regular School No Elementary KG KG 2021   kindergarten_full_day                                                   122                                             122
2542459 2542459 NM     school 3502070 72   POJOAQUE 350207000482 123 PABLO ROYBAL ELEMENTARY Public Regular School No Elementary PK 03 2020   kindergarten_full_day                                                   120                                             120
2542499 2542499 NM     school 3500010 83   RIO RANCHO 350001000650 319 PUESTA DEL SOL ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   120                                             120
2542238 2542238 NM     school 3501260 33   HOBBS 350126000357 172 BOOKER T. WASHINGTON ELEMENTARY Public Regular School No Elementary PK 04 2020   kindergarten_full_day                                                   117                                             117
2541858 2541858 NM     school 3500060 1   ALBUQUERQUE 350006000824 265 SEVEN BAR ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   116                                             116
2542305 2542305 NM     school 3501500 17   LAS CRUCES 350150000702 53 HIGHLAND ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   116                                             116
2948515 2948515 NM     school 3501500 17   LAS CRUCES 350150000702 53 HIGHLAND ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   kindergarten_full_day                                                   116                                             116
2542294 2542294 NM     school 3501500 17   LAS CRUCES 350150000794 6 CESAR CHAVEZ ELEMENTARY Public Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   115                                             115
2541772 2541772 NM     school 3500060 1   ALBUQUERQUE 350006000726 328 GEORGIA O'KEEFFE ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   114                                             114
2948706 2948706 NM     school 3500010 83   RIO RANCHO 350001000650 319 PUESTA DEL SOL ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   kindergarten_full_day                                                   113                                             113
2541855 2541855 NM     school 3500060 1   ALBUQUERQUE 350006000105 348 SANDIA BASE ELEMENTARY Public Regular School No Elementary KG 06 2020   kindergarten_full_day                                                   111                                             111
2541879 2541879 NM     school 3500060 1   ALBUQUERQUE 350006000897 264 VENTANA RANCH ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   111                                             111
2542504 2542504 NM     school 3500010 83   RIO RANCHO 350001001039 20 SANDIA VISTA ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   110                                             110
2542491 2542491 NM     school 3500010 83   RIO RANCHO 350001030011 100 ENCHANTED HILLS ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   109                                             109
2541840 2541840 NM     school 3500060 1   ALBUQUERQUE 350006000964 268 NORTH STAR ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   107                                             107
2541852 2541852 NM     school 3500060 1   ALBUQUERQUE 350006001033 392 RUDOLFO ANAYA ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   107                                             107
2948711 2948711 NM     school 3500010 83   RIO RANCHO 350001001039 20 SANDIA VISTA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   kindergarten_full_day                                                   106                                             106
2541943 2541943 NM     school 3500210 61   BERNALILLO 350021000728 140 WD CARROLL ELEMENTARY Public Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   105                                             105
2541864 2541864 NM     school 3500060 1   ALBUQUERQUE 350006000725 280 SUSIE RAYOS MARMON ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   104                                             104
2542297 2542297 NM     school 3501500 17   LAS CRUCES 350150000649 45 DESERT HILLS ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   104                                             104
2541816 2541816 NM     school 3500060 1   ALBUQUERQUE 350006000895 260 MANZANO MESA ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   103                                             103
2541863 2541863 NM     school 3500060 1   ALBUQUERQUE 350006001036 393 SUNSET VIEW ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   102                                             102
2542501 2542501 NM     school 3500010 83   RIO RANCHO 350001000101 340 RIO RANCHO ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   102                                             102
2542327 2542327 NM     school 3501500 17   LAS CRUCES 350150000959 7 SONOMA ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   101                                             101
2542489 2542489 NM     school 3500010 83   RIO RANCHO 350001000750 50 COLINAS DEL NORTE ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   101                                             101
2948703 2948703 NM     school 3500010 83   RIO RANCHO 350001000710 375 MARTIN KING JR ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   kindergarten_full_day                                                   101                                             101
2948874 2948874 NM     school 3501560 68   WEST LAS VEGAS 350156000408 12 LUIS E. ARMIJO ELEMENTARY Public - Elementary School Regular School No Elementary PK 01 2021   kindergarten_full_day                                                   101                                             101
2542322 2542322 NM     school 3501500 17   LAS CRUCES 350150001062 14 MONTE VISTA ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   100                                             100
2948039 2948039 NM     school 3500060 1   ALBUQUERQUE 350006000895 260 MANZANO MESA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   kindergarten_full_day                                                   100                                             100
2948531 2948531 NM     school 3501500 17   LAS CRUCES 350150001062 14 MONTE VISTA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   kindergarten_full_day                                                   99                                             99
2541732 2541732 NM     school 3500060 1   ALBUQUERQUE 350006000037 236 CHELWOOD ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   98                                             98
2542682 2542682 NM     school 3502800 89   ZUNI 350280001124 166 SHIWI TS'ANA ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   98                                             98
2948092 2948092 NM     school 3500060 1   ALBUQUERQUE 350006001018 389 TIERRA ANTIGUA ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   kindergarten_full_day                                                   98                                             98
2541915 2541915 NM     school 3500150 64   AZTEC 350015000139 136 LYDIA RIPPEY ELEMENTARY Public Regular School No Elementary PK 03 2020   kindergarten_full_day                                                   97                                             97
2542119 2542119 NM     school 3500990 65   FARMINGTON 350099000693 38 ESPERANZA ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   97                                             97
2948713 2948713 NM     school 3500010 83   RIO RANCHO 350001000864 15 VISTA GRANDE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   kindergarten_full_day                                                   97                                             97
2541860 2541860 NM     school 3500060 1   ALBUQUERQUE 350006000109 356 SIERRA VISTA ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   96                                             96
2542128 2542128 NM     school 3500990 65   FARMINGTON 350099000289 100 MCKINLEY ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   96                                             96
2948536 2948536 NM     school 3501500 17   LAS CRUCES 350150000959 7 SONOMA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   kindergarten_full_day                                                   96                                             96
2948696 2948696 NM     school 3500010 83   RIO RANCHO 350001030011 100 ENCHANTED HILLS ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   kindergarten_full_day                                                   96                                             96
2541916 2541916 NM     school 3500150 64   AZTEC 350015000137 99 MCCOY AVENUE ELEMENTARY Public Regular School No Elementary PK 03 2020   kindergarten_full_day                                                   95                                             95
2542126 2542126 NM     school 3500990 65   FARMINGTON 350099000287 73 LADERA DEL NORTE ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   95                                             95
2542180 2542180 NM     school 3501110 43   GALLUP 350111001137 174 DEL NORTE ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   94                                             94
2541699 2541699 NM     school 3500030 46   ALAMOGORDO 350003000006 58 HOLLOMAN ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   93                                             93
2542132 2542132 NM     school 3500990 65   FARMINGTON 350099000291 118 NORTHEAST ELEMENTARY Public Regular School No Elementary KG 06 2020   kindergarten_full_day                                                   93                                             93
2948087 2948087 NM     school 3500060 1   ALBUQUERQUE 350006000725 280 SUSIE RAYOS MARMON ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   kindergarten_full_day                                                   93                                             93
2541845 2541845 NM     school 3500060 1   ALBUQUERQUE 350006000039 317 PETROGLYPH ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   92                                             92
2542338 2542338 NM     school 3501530 69   LAS VEGAS CITY 350153000863 3 LVCS EARLY CHILDHOOD Public Regular School No Elementary PK KG 2020   kindergarten_full_day                                                   92                                             92
2948665 2948665 NM     school 3502070 72   POJOAQUE 350207000482 123 PABLO ROYBAL ELEMENTARY Public - Elementary School Regular School No Elementary PK 03 2021   kindergarten_full_day                                                   92                                             92
2541750 2541750 NM     school 3500060 1   ALBUQUERQUE 350006000681 203 DENNIS CHAVEZ ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   91                                             91
2541755 2541755 NM     school 3500060 1   ALBUQUERQUE 350006000752 350 DOUBLE EAGLE ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   90                                             90
2542329 2542329 NM     school 3501500 17   LAS CRUCES 350150030009 145 TOMBAUGH ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   90                                             90
2542531 2542531 NM     school 3502250 4   ROSWELL 350225000524 161 VALLEY VIEW ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   90                                             90
2541843 2541843 NM     school 3500060 1   ALBUQUERQUE 350006000782 275 PAINTED SKY ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   89                                             89
2948692 2948692 NM     school 3500010 83   RIO RANCHO 350001001034 21 CIELO AZUL ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   kindergarten_full_day                                                   89                                             89
2541837 2541837 NM     school 3500060 1   ALBUQUERQUE 350006001072 768 NEW MEXICO INTERNATIONAL SCHOOL Charter Regular School Yes Elementary KG 08 2020   kindergarten_full_day                                                   88                                             88
2541729 2541729 NM     school 3500060 1   ALBUQUERQUE 350006000035 339 CARLOS REY ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   87                                             87
2542034 2542034 NM     school 3500570 12   CLOVIS 350057000219 122 PARKVIEW ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   87                                             87
2542129 2542129 NM     school 3500990 65   FARMINGTON 350099000290 106 MESA VERDE ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   87                                             87
2542118 2542118 NM     school 3500990 65   FARMINGTON 350099000283 37 COUNTRY CLUB ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   86                                             86
2541797 2541797 NM     school 3500060 1   ALBUQUERQUE 350006000070 217 JOHN BAKER ELEMENTARY Public Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   85                                             85
2542204 2542204 NM     school 3501110 43   GALLUP 350111000797 91 TOBE TURPEN ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   85                                             85
2948136 2948136 NM     school 3500150 64   AZTEC 350015000139 136 LYDIA RIPPEY ELEMENTARY Public - Elementary School Regular School No Elementary PK 03 2021   kindergarten_full_day                                                   85                                             85
2948340 2948340 NM     school 3500990 65   FARMINGTON 350099000289 100 MCKINLEY ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   kindergarten_full_day                                                   85                                             85
2948538 2948538 NM     school 3501500 17   LAS CRUCES 350150030009 145 TOMBAUGH ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   kindergarten_full_day                                                   85                                             85
2948694 2948694 NM     school 3500010 83   RIO RANCHO 350001000750 50 COLINAS DEL NORTE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   kindergarten_full_day                                                   85                                             85
2948702 2948702 NM     school 3500010 83   RIO RANCHO 350001000952 12 MAGGIE CORDOVA ELEMENTARY SCHOOL Public - Elementary School Regular School No Elementary KG 05 2021   kindergarten_full_day                                                   85                                             85
2542053 2542053 NM     school 3500690 42   DEMING 350069000941 5 BATAAN ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   84                                             84
2542669 2542669 NM     school 3501560 68   WEST LAS VEGAS 350156000408 12 LUIS E. ARMIJO ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   84                                             84
2541788 2541788 NM     school 3500060 1   ALBUQUERQUE 350006000616 221 HUBERT H HUMPHREY ELEMENTARY Public Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   83                                             83
2947973 2947973 NM     school 3500060 1   ALBUQUERQUE 350006000681 203 DENNIS CHAVEZ ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   kindergarten_full_day                                                   83                                             83
2947954 2947954 NM     school 3500060 1   ALBUQUERQUE 350006000035 339 CARLOS REY ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   kindergarten_full_day                                                   82                                             82
2948164 2948164 NM     school 3500210 61   BERNALILLO 350021000728 140 WD CARROLL ELEMENTARY Public - Elementary School Regular School No Elementary PK 02 2021   kindergarten_full_day                                                   82                                             82
2948343 2948343 NM     school 3500990 65   FARMINGTON 350099000291 118 NORTHEAST ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   kindergarten_full_day                                                   82                                             82
2948708 2948708 NM     school 3500010 83   RIO RANCHO 350001000101 340 RIO RANCHO ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   kindergarten_full_day                                                   82                                             82

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