enrollments

Data source: Big Local News · About: Big Local

14,670 rows where state = "NM" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 14,570 ✖
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
2947036 2947036 NM     school 3500060 1   ALBUQUERQUE 350006000068 420 JACKSON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947037 2947037 NM     school 3500060 1   ALBUQUERQUE 350006000825 490 JAMES MONROE MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947038 2947038 NM     school 3500060 1   ALBUQUERQUE 350006000053 258 JANET KAHN FINE ARTS ACADEMY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   16                                             16
2947039 2947039 NM     school 3500060 1   ALBUQUERQUE 350006000069 425 JEFFERSON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947040 2947040 NM     school 3500060 1   ALBUQUERQUE 350006000812 445 JIMMY CARTER MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947041 2947041 NM     school 3500060 1   ALBUQUERQUE 350006000019 405 JOHN ADAMS MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947042 2947042 NM     school 3500060 1   ALBUQUERQUE 350006000070 217 JOHN BAKER ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947043 2947043 NM     school 3500060 1   ALBUQUERQUE 350006000071 427 KENNEDY MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947044 2947044 NM     school 3500060 1   ALBUQUERQUE 350006000072 279 KIRTLAND ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   53                                             53
2947045 2947045 NM     school 3500060 1   ALBUQUERQUE 350006000073 231 KIT CARSON ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pre_kindergarten                                                   30                                             30
2947046 2947046 NM     school 3500060 1   ALBUQUERQUE 350006000065 485 L.B. JOHNSON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947047 2947047 NM     school 3500060 1   ALBUQUERQUE 350006000875 61 LA ACADEMIA DE ESPERANZA Charter - High School Regular School Yes High 06 12 2021   pre_kindergarten                                                   0                                             0
2947048 2947048 NM     school 3500060 1   ALBUQUERQUE 350006000698 525 LA CUEVA HIGH Public - High School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
2947049 2947049 NM     school 3500060 1   ALBUQUERQUE 350006000074 282 LA LUZ ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947050 2947050 NM     school 3500060 1   ALBUQUERQUE 350006000075 285 LA MESA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   14                                             14
2947051 2947051 NM     school 3500060 1   ALBUQUERQUE 350006000077 288 LAVALAND ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   25                                             25
2947052 2947052 NM     school 3500060 1   ALBUQUERQUE 350006000043 373 LEW WALLACE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947053 2947053 NM     school 3500060 1   ALBUQUERQUE 350006000078 291 LONGFELLOW ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947054 2947054 NM     school 3500060 1   ALBUQUERQUE 350006000079 297 LOS PADILLAS ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pre_kindergarten                                                   23                                             23
2947055 2947055 NM     school 3500060 1   ALBUQUERQUE 350006000852 17 LOS PUENTES CHARTER Charter - High School Regular School Yes High 07 12 2021   pre_kindergarten                                                   0                                             0
2947056 2947056 NM     school 3500060 1   ALBUQUERQUE 350006000099 336 LOS RANCHOS ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   17                                             17
2947057 2947057 NM     school 3500060 1   ALBUQUERQUE 350006000080 300 LOWELL ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   0                                             0
2947058 2947058 NM     school 3500060 1   ALBUQUERQUE 350006000046 303 MACARTHUR ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   18                                             18
2947059 2947059 NM     school 3500060 1   ALBUQUERQUE 350006000081 435 MADISON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947060 2947060 NM     school 3500060 1   ALBUQUERQUE 350006000082 530 MANZANO HIGH Public - High School Regular School No Other PK 12 2021   pre_kindergarten                                                   16                                             16
2947061 2947061 NM     school 3500060 1   ALBUQUERQUE 350006000895 260 MANZANO MESA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   31                                             31
2947062 2947062 NM     school 3500060 1   ALBUQUERQUE 350006000683 365 MARIE M HUGHES ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   0                                             0
2947063 2947063 NM     school 3500060 1   ALBUQUERQUE 350006000821 39 MARK ARMIJO ACADEMY Charter - High School Regular School Yes High 09 12 2021   pre_kindergarten                                                   0                                             0
2947064 2947064 NM     school 3500060 1   ALBUQUERQUE 350006000083 364 MARK TWAIN ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   38                                             38
2947065 2947065 NM     school 3500060 1   ALBUQUERQUE 350006000692 250 MARYANN BINFORD ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   17                                             17
2947066 2947066 NM     school 3500060 1   ALBUQUERQUE 350006000084 305 MATHESON PARK ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   16                                             16
2947067 2947067 NM     school 3500060 1   ALBUQUERQUE 350006000085 307 MCCOLLUM ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   28                                             28
2947068 2947068 NM     school 3500060 1   ALBUQUERQUE 350006000615 440 MCKINLEY MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947069 2947069 NM     school   1   ALBUQUERQUE   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   pre_kindergarten                                                   78                                             78
2947070 2947070 NM     school   1   ALBUQUERQUE   997 MISC PRIVATE Private - Non-Accredited Private School           2021   pre_kindergarten                                                   0                                             0
2947071 2947071 NM     school 3500060 1   ALBUQUERQUE 350006000087 309 MISSION AVENUE ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   16                                             16
2947072 2947072 NM     school 3500060 1   ALBUQUERQUE 350006000088 310 MITCHELL ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947073 2947073 NM     school 3500060 1   ALBUQUERQUE 350006000089 312 MONTE VISTA ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947074 2947074 NM     school 3500060 1   ALBUQUERQUE 350006000894 95 MONTESSORI OF THE RIO GRANDE Charter - Elementary School Regular School Yes Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947075 2947075 NM     school 3500060 1   ALBUQUERQUE 350006000090 315 MONTEZUMA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   0                                             0
2947076 2947076 NM     school 3500060 1   ALBUQUERQUE 350006000920 98 MOUNTAIN MAHOGANY COMMUNITY SCHOOL Charter - Elementary School Regular School Yes Elementary KG 08 2021   pre_kindergarten                                                   0                                             0
2947077 2947077 NM     school 3500060 1   ALBUQUERQUE 350006000092 324 MOUNTAIN VIEW ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   16                                             16
2947078 2947078 NM     school 3500060 1   ALBUQUERQUE 350006000918 6 NATIVE AMERICAN COMMUNITY ACADEMY Charter - High School Regular School Yes Other KG 12 2021   pre_kindergarten                                                   0                                             0
2947079 2947079 NM     school 3500060 1   ALBUQUERQUE 350006000093 327 NAVAJO ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   12                                             12
2947080 2947080 NM     school 3500060 1   ALBUQUERQUE 350006001045 708 NEW AMERICA SCHOOL Charter - High School Regular School Yes High 09 12 2021   pre_kindergarten                                                   0                                             0
2947081 2947081 NM     school 3500060 1   ALBUQUERQUE 350006000123 549 NEW FUTURES HIGH SCHOOL Public - High School Alternative School No High 07 12 2021   pre_kindergarten                                                   0                                             0
2947082 2947082 NM     school 3500060 1   ALBUQUERQUE 350006001072 768 NEW MEXICO INTERNATIONAL SCHOOL Charter - Elementary School Regular School Yes Elementary KG 08 2021   pre_kindergarten                                                   0                                             0
2947083 2947083 NM     school 3500060 1   ALBUQUERQUE 350006001075 516 NEX GEN ACADEMY Public - High School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
2947084 2947084 NM     school   1   ALBUQUERQUE   983 NMSVH PRESCHOOL Off-Site - Special Education           2021   pre_kindergarten                                                   29                                             29
2947085 2947085 NM     school 3500060 1   ALBUQUERQUE 350006000964 268 NORTH STAR ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947086 2947086 NM     school 3500060 1   ALBUQUERQUE 350006000095 227 ONATE ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   0                                             0
2947087 2947087 NM     school 3500060 1   ALBUQUERQUE 350006000096 332 OSUNA ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947088 2947088 NM     school 3500060 1   ALBUQUERQUE 350006000782 275 PAINTED SKY ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   18                                             18
2947089 2947089 NM     school 3500060 1   ALBUQUERQUE 350006000097 333 PAJARITO ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   pre_kindergarten                                                   62                                             62
2947090 2947090 NM     school 3500060 1   ALBUQUERQUE 350006000039 317 PETROGLYPH ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   85                                             85
2947091 2947091 NM     school 3500060 1   ALBUQUERQUE 350006000098 448 POLK MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947092 2947092 NM     school 3500060 1   ALBUQUERQUE 350006000822 47 PUBLIC ACADEMY FOR PERFORMING ARTS Charter - High School Regular School Yes High 06 12 2021   pre_kindergarten                                                   0                                             0
2947093 2947093 NM     school 3500060 1   ALBUQUERQUE 350006000094 330 REGINALD CHAVEZ ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947094 2947094 NM     school 3500060 1   ALBUQUERQUE 350006000100 540 RIO GRANDE HIGH Public - High School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
2947095 2947095 NM     school 3500060 1   ALBUQUERQUE 350006000823 51 ROBERT F. KENNEDY CHARTER Charter - High School Regular School Yes High 06 12 2021   pre_kindergarten                                                   0                                             0
2947096 2947096 NM     school 3500060 1   ALBUQUERQUE 350006000102 452 ROOSEVELT MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947097 2947097 NM     school 3500060 1   ALBUQUERQUE 350006001033 392 RUDOLFO ANAYA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   43                                             43
2947098 2947098 NM     school 3500060 1   ALBUQUERQUE 350006000103 360 S. Y. JACKSON ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947099 2947099 NM     school 3500060 1   ALBUQUERQUE 350006000104 345 SAN ANTONITO ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947100 2947100 NM     school 3500060 1   ALBUQUERQUE 350006000105 348 SANDIA BASE ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   pre_kindergarten                                                   0                                             0
2947101 2947101 NM     school 3500060 1   ALBUQUERQUE 350006000106 550 SANDIA HIGH Public - High School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
2947102 2947102 NM     school 3500060 1   ALBUQUERQUE 350006000108 597 SCHOOL ON WHEELS HIGH SCHOOL Public - High School Alternative School No High 09 12 2021   pre_kindergarten                                                   0                                             0
2947103 2947103 NM     school 3500060 1   ALBUQUERQUE 350006000824 265 SEVEN BAR ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947104 2947104 NM     school 3500060 1   ALBUQUERQUE 350006001117 750 SIEMBRA LEADERSHIP HIGH SCHOOL Charter - High School Regular School Yes High 09 12 2021   pre_kindergarten                                                   0                                             0
2947105 2947105 NM     school 3500060 1   ALBUQUERQUE 350006000109 356 SIERRA VISTA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   37                                             37
2947106 2947106 NM     school 3500060 1   ALBUQUERQUE 350006000110 357 SOMBRA DEL MONTE ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   0                                             0
2947107 2947107 NM     school 3500060 1   ALBUQUERQUE 350006000809 25 SOUTH VALLEY ACADEMY Charter - High School Regular School Yes High 06 12 2021   pre_kindergarten                                                   0                                             0
2947108 2947108 NM     school 3500060 1   ALBUQUERQUE 350006001036 393 SUNSET VIEW ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947109 2947109 NM     school 3500060 1   ALBUQUERQUE 350006000725 280 SUSIE RAYOS MARMON ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   15                                             15
2947110 2947110 NM     school 3500060 1   ALBUQUERQUE 350006000111 455 TAFT MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947111 2947111 NM     school 3500060 1   ALBUQUERQUE 350006000112 457 TAYLOR MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947112 2947112 NM     school 3500060 1   ALBUQUERQUE 350006001112 753 TECHNOLOGY LEADERSHIP HIGH SCHOOL Charter - High School Regular School Yes High 09 12 2021   pre_kindergarten                                                   0                                             0
2947113 2947113 NM     school 3500060 1   ALBUQUERQUE 350006001026 16 THE ALB TALENT DEVELOPMENT CHARTER Charter - High School Regular School Yes High 09 12 2021   pre_kindergarten                                                   0                                             0
2947114 2947114 NM     school 3500060 1   ALBUQUERQUE 350006001018 389 TIERRA ANTIGUA ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947115 2947115 NM     school 3500060 1   ALBUQUERQUE 350006000113 363 TOMASITA ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   1                                             1
2947116 2947116 NM     school 3500060 1   ALBUQUERQUE 350006001047 492 TONY HILLERMAN MIDDLE SCHOOL Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947117 2947117 NM     school   1   ALBUQUERQUE   40 TRANSITION SERVICES Off-Site - Special Education           2021   pre_kindergarten                                                   0                                             0
2947118 2947118 NM     school 3500060 1   ALBUQUERQUE 350006001142 497 TRES VOLCANES COMMUNITY COLLABORATIVE SCHOOL Public - Elementary School Regular School No Elementary KG 08 2021   pre_kindergarten                                                   0                                             0
2947119 2947119 NM     school 3500060 1   ALBUQUERQUE 350006000114 475 TRUMAN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947120 2947120 NM     school 3500060 1   ALBUQUERQUE 350006000115 370 VALLE VISTA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   88                                             88
2947121 2947121 NM     school 3500060 1   ALBUQUERQUE 350006000116 560 VALLEY HIGH Public - High School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
2947122 2947122 NM     school 3500060 1   ALBUQUERQUE 350006000117 460 VAN BUREN MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947123 2947123 NM     school 3500060 1   ALBUQUERQUE 350006000897 264 VENTANA RANCH ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   35                                             35
2947124 2947124 NM     school 3500060 1   ALBUQUERQUE 350006000966 575 VOLCANO VISTA HIGH Public - High School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
2947125 2947125 NM     school 3500060 1   ALBUQUERQUE 350006000118 465 WASHINGTON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947126 2947126 NM     school 3500060 1   ALBUQUERQUE 350006000119 570 WEST MESA HIGH Public - High School Regular School No High 09 12 2021   pre_kindergarten                                                   0                                             0
2947127 2947127 NM     school 3500060 1   ALBUQUERQUE 350006000120 376 WHERRY ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   9                                             9
2947128 2947128 NM     school 3500060 1   ALBUQUERQUE 350006000121 379 WHITTIER ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   18                                             18
2947129 2947129 NM     school 3500060 1   ALBUQUERQUE 350006001087 782 WILLIAM W & JOSEPHINE DORN CHARTER COMMUNITY SCHOOL Charter - Elementary School Regular School Yes Elementary KG 05 2021   pre_kindergarten                                                   0                                             0
2947130 2947130 NM     school 3500060 1   ALBUQUERQUE 350006000122 470 WILSON MIDDLE Public - Middle School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
2947131 2947131 NM     school 3500060 1   ALBUQUERQUE 350006000124 385 ZIA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   pre_kindergarten                                                   0                                             0
2947132 2947132 NM     school 3500060 1   ALBUQUERQUE 350006000125 388 ZUNI ELEMENTARY Public - Elementary School Regular School No Elementary KG 05 2021   pre_kindergarten                                                   19                                             19
2947133 2947133 NM     school 3500134 528   ALBUQUERQUE BILINGUAL ACADEMY 350013400923 1 ALBUQUERQUE BILINGUAL ACADEMY Charter - Elementary School Regular School Yes Elementary PK 08 2021   pre_kindergarten                                                   17                                             17
2947134 2947134 NM     school 3500181 574   ALBUQUERQUE COLLEGIATE CHARTER SCHOOL 350018101134 1 ALBUQUERQUE COLLEGIATE CHARTER SCHOOL Charter - Elementary School Regular School Yes Elementary KG 03 2021   pre_kindergarten                                                   0                                             0
2947135 2947135 NM     school 3500130 524   ALBUQUERQUE INSTITUTE OF MATH & SCIENCE 350013000921 1 ALBUQUERQUE INSTITUTE OF MATH & SCIENCE Charter - High School Regular School Yes High 06 12 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]);