enrollments

Data source: Big Local News · About: Big Local

995 rows where grade = "grade_3", state = "NM" and year = 2020 sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 995 ✖

grade ✖

  • grade_3 · 995 ✖
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
2545646 2545646 NM     school 3500001 26   VAUGHN 350000100607 168 VAUGHN ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_3                                                   8                                             8
2545647 2545647 NM     school 3500001 26   VAUGHN 350000100608 169 VAUGHN HIGH Public Regular School No High 07 12 2020   grade_3                                                   0                                             0
2545472 2545472 NM     school 3500010 83   RIO RANCHO 350001001034 21 CIELO AZUL ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   131                                             131
2545473 2545473 NM     school 3500010 83   RIO RANCHO 350001001024 11 CLEVELAND HIGH SCHOOL Public Regular School No High 09 12 2020   grade_3                                                   0                                             0
2545474 2545474 NM     school 3500010 83   RIO RANCHO 350001000750 50 COLINAS DEL NORTE ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   138                                             138
2545475 2545475 NM     school 3500010 83   RIO RANCHO 350001000761 1 EAGLE RIDGE MIDDLE Public Regular School No Middle 06 08 2020   grade_3                                                   0                                             0
2545476 2545476 NM     school 3500010 83   RIO RANCHO 350001030011 100 ENCHANTED HILLS ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   122                                             122
2545477 2545477 NM     school 3500010 83   RIO RANCHO 350001000736 372 ERNEST STAPLETON ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   149                                             149
2545478 2545478 NM     school 3500010 83   RIO RANCHO 350001000805 13 INDEPENDENCE HIGH SCHOOL Public Alternative School No High 09 12 2020   grade_3                                                   0                                             0
2545479 2545479 NM     school 3500010 83   RIO RANCHO 350001000682 481 LINCOLN MIDDLE Public Regular School No Middle 06 08 2020   grade_3                                                   0                                             0
2545480 2545480 NM     school 3500010 83   RIO RANCHO 350001000952 12 MAGGIE CORDOVA ELEMENTARY SCHOOL Public Regular School No Elementary KG 05 2020   grade_3                                                   143                                             143
2545481 2545481 NM     school 3500010 83   RIO RANCHO 350001000710 375 MARTIN KING JR ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   144                                             144
2545483 2545483 NM     school 3500010 83   RIO RANCHO 350001000739 105 MOUNTAIN VIEW MIDDLE Public Regular School No Middle 06 08 2020   grade_3                                                   0                                             0
2545484 2545484 NM     school 3500010 83   RIO RANCHO 350001000650 319 PUESTA DEL SOL ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   128                                             128
2545485 2545485 NM     school 3500010 83   RIO RANCHO 350001000954 18 RIO RANCHO CYBER ACADEMY Public Alternative School No High 06 12 2020   grade_3                                                   0                                             0
2545486 2545486 NM     school 3500010 83   RIO RANCHO 350001000101 340 RIO RANCHO ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   92                                             92
2545487 2545487 NM     school 3500010 83   RIO RANCHO 350001000779 6 RIO RANCHO HIGH Public Regular School No High 09 12 2020   grade_3                                                   0                                             0
2545488 2545488 NM     school 3500010 83   RIO RANCHO 350001000865 16 RIO RANCHO MIDDLE SCHOOL Public Regular School No Middle 06 08 2020   grade_3                                                   0                                             0
2545489 2545489 NM     school 3500010 83   RIO RANCHO 350001001039 20 SANDIA VISTA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   104                                             104
2545490 2545490 NM     school 3500010 83   RIO RANCHO 350001000953 17 SHINING STARS PRESCHOOL Public Special Education School No Prekindergarten PK PK 2020   grade_3                                                   0                                             0
2545491 2545491 NM     school 3500010 83   RIO RANCHO 350001000864 15 VISTA GRANDE ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   133                                             133
2545265 2545265 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported Alternative School No High 09 12 2020   grade_3                                                   0                                             0
2545266 2545266 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported Alternative School No High 06 12 2020   grade_3                                                   0                                             0
2545267 2545267 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported Alternative School No High 06 12 2020   grade_3                                                   0                                             0
2545423 2545423 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545424 2545424 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545425 2545425 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545426 2545426 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545427 2545427 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported Alternative School No Secondary 09 11 2020   grade_3                                                   0                                             0
2545428 2545428 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545429 2545429 NM     school 3500012 91   NM CORRECTIONS 350001200970 5 ROSWELL CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545430 2545430 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545431 2545431 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545432 2545432 NM     school 3500012 91   NM CORRECTIONS 350001200979 8 WESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_3                                                   0                                             0
2545434 2545434 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   grade_3                                                   2                                             2
2545435 2545435 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   grade_3                                                   11                                             11
2545574 2545574 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_3                                                   0                                             0
2544988 2544988 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_3                                                   0                                             0
2544678 2544678 NM     school 3500030 46   ALAMOGORDO 350003000799 4 ACADEMY DEL SOL ALT. Public Alternative School No High 10 12 2020   grade_3                                                   0                                             0
2544679 2544679 NM     school 3500030 46   ALAMOGORDO 350003000001 15 ALAMOGORDO HIGH Public Regular School No High 09 12 2020   grade_3                                                   0                                             0
2544680 2544680 NM     school 3500030 46   ALAMOGORDO 350003000002 28 BUENA VISTA ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   31                                             31
2544681 2544681 NM     school 3500030 46   ALAMOGORDO 350003000003 33 CHAPARRAL MIDDLE Public Regular School No Middle 06 08 2020   grade_3                                                   0                                             0
2544682 2544682 NM     school 3500030 46   ALAMOGORDO 350003000012 144 DESERT STAR ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   90                                             90
2544683 2544683 NM     school 3500030 46   ALAMOGORDO 350003000005 57 HIGH ROLLS MOUNTAIN PARK ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   4                                             4
2544684 2544684 NM     school 3500030 46   ALAMOGORDO 350003000006 58 HOLLOMAN ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   61                                             61
2544685 2544685 NM     school 3500030 46   ALAMOGORDO 350003000007 37 HOLLOMAN MIDDLE Public Regular School No Middle 06 08 2020   grade_3                                                   0                                             0
2544687 2544687 NM     school 3500030 46   ALAMOGORDO 350003000008 72 LA LUZ ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   39                                             39
2544689 2544689 NM     school 3500030 46   ALAMOGORDO 350003000798 3 MOUNTAIN VIEW MIDDLE Public Regular School No Middle 06 08 2020   grade_3                                                   0                                             0
2544690 2544690 NM     school 3500030 46   ALAMOGORDO 350003000010 114 NORTH ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   33                                             33
2544691 2544691 NM     school 3500030 46   ALAMOGORDO 350003000013 150 SIERRA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   62                                             62
2544692 2544692 NM     school 3500030 46   ALAMOGORDO 350003000004 56 SUNSET HILLS ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   77                                             77
2544693 2544693 NM     school 3500030 46   ALAMOGORDO 350003000016 181 YUCCA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   48                                             48
2544694 2544694 NM     school 3500060 1   ALBUQUERQUE 350006000017 321 A. MONTOYA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   63                                             63
2544695 2544695 NM     school 3500060 1   ALBUQUERQUE 350006000893 90 ABQ CHARTER ACADEMY Charter Regular School Yes High 09 12 2020   grade_3                                                   0                                             0
2544696 2544696 NM     school 3500060 1   ALBUQUERQUE 350006001074 749 ACE LEADERSHIP HIGH SCHOOL Charter Regular School Yes High 09 12 2020   grade_3                                                   0                                             0
2544697 2544697 NM     school 3500060 1   ALBUQUERQUE 350006000020 206 ADOBE ACRES ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   75                                             75
2544698 2544698 NM     school 3500060 1   ALBUQUERQUE 350006000021 207 ALAMEDA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   32                                             32
2544699 2544699 NM     school 3500060 1   ALBUQUERQUE 350006000022 210 ALAMOSA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   66                                             66
2544700 2544700 NM     school 3500060 1   ALBUQUERQUE 350006000024 590 ALBUQUERQUE HIGH Public Regular School No High 09 12 2020   grade_3                                                   0                                             0
2544701 2544701 NM     school 3500060 1   ALBUQUERQUE 350006000924 116 ALICE KING COMMUNITY SCHOOL Charter Regular School Yes Elementary KG 08 2020   grade_3                                                   63                                             63
2544702 2544702 NM     school 3500060 1   ALBUQUERQUE 350006000025 213 ALVARADO ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   50                                             50
2544703 2544703 NM     school 3500060 1   ALBUQUERQUE 350006000026 214 APACHE ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   47                                             47
2544704 2544704 NM     school 3500060 1   ALBUQUERQUE 350006000027 215 ARMIJO ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   36                                             36
2544705 2544705 NM     school 3500060 1   ALBUQUERQUE 350006000028 329 ARROYO DEL OSO ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   56                                             56
2544706 2544706 NM     school 3500060 1   ALBUQUERQUE 350006000029 216 ATRISCO ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   36                                             36
2544707 2544707 NM     school 3500060 1   ALBUQUERQUE 350006001037 576 ATRISCO HERITAGE ACADEMY HS Public Regular School No High 09 12 2020   grade_3                                                   0                                             0
2544708 2544708 NM     school 3500060 1   ALBUQUERQUE 350006000030 222 BANDELIER ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   77                                             77
2544709 2544709 NM     school 3500060 1   ALBUQUERQUE 350006000031 225 BARCELONA ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_3                                                   61                                             61
2544710 2544710 NM     school 3500060 1   ALBUQUERQUE 350006000032 228 BEL-AIR ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   59                                             59
2544711 2544711 NM     school 3500060 1   ALBUQUERQUE 350006000033 229 BELLEHAVEN ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   43                                             43
2544714 2544714 NM     school 3500060 1   ALBUQUERQUE 350006000035 339 CARLOS REY ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   102                                             102
2544715 2544715 NM     school 3500060 1   ALBUQUERQUE 350006000642 295 CHAMIZA ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   71                                             71
2544716 2544716 NM     school 3500060 1   ALBUQUERQUE 350006000036 234 CHAPARRAL ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   116                                             116
2544717 2544717 NM     school 3500060 1   ALBUQUERQUE 350006000037 236 CHELWOOD ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   70                                             70
2544719 2544719 NM     school 3500060 1   ALBUQUERQUE 350006000925 118 CHRISTINE DUNCAN HERITAGE ACADEMY Charter Regular School Yes Elementary PK 08 2020   grade_3                                                   38                                             38
2544720 2544720 NM     school 3500060 1   ALBUQUERQUE 350006000038 580 CIBOLA HIGH Public Regular School No High 09 12 2020   grade_3                                                   0                                             0
2544721 2544721 NM     school 3500060 1   ALBUQUERQUE 350006001050 780 CIEN AGUAS INTERNATIONAL Charter Regular School Yes Elementary KG 08 2020   grade_3                                                   48                                             48
2544722 2544722 NM     school 3500060 1   ALBUQUERQUE 350006000617 407 CLEVELAND MIDDLE Public Regular School No Middle 06 08 2020   grade_3                                                   0                                             0
2544723 2544723 NM     school 3500060 1   ALBUQUERQUE 350006000040 237 COCHITI ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   39                                             39
2544724 2544724 NM     school 3500060 1   ALBUQUERQUE 350006001100 591 COLLEGE AND CAREER HIGH SCHOOL Public Regular School No High 09 12 2020   grade_3                                                   0                                             0
2544725 2544725 NM     school 3500060 1   ALBUQUERQUE 350006000041 240 COLLET PARK ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   61                                             61
2544726 2544726 NM     school 3500060 1   ALBUQUERQUE 350006000042 241 COMANCHE ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   62                                             62
2544727 2544727 NM     school 3500060 1   ALBUQUERQUE 350006000709 35 CONTINUATION SCHOOL Public Special Education School No Other PK 12 2020   grade_3                                                   0                                             0
2544728 2544728 NM     school 3500060 1   ALBUQUERQUE 350006001081 706 CORAL COMMUNITY CHARTER Charter Regular School Yes Not applicable N N 2020   grade_3                                                   38                                             38
2544729 2544729 NM     school 3500060 1   ALBUQUERQUE 350006001054 243 CORONADO ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   45                                             45
2544730 2544730 NM     school 3500060 1   ALBUQUERQUE 350006000107 351 CORRALES ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   56                                             56
2544731 2544731 NM     school 3500060 1   ALBUQUERQUE 350006001028 28 CORRALES INTERNATIONAL Charter Regular School Yes Other KG 12 2020   grade_3                                                   23                                             23
2544732 2544732 NM     school 3500060 1   ALBUQUERQUE 350006001031 769 COTTONWOOD CLASSICAL PREP Charter Regular School Yes High 06 12 2020   grade_3                                                   0                                             0
2544733 2544733 NM     school 3500060 1   ALBUQUERQUE 350006001133 952 COYOTE WILLOW FAMILY SCHOOL Public Alternative School No Elementary KG 08 2020   grade_3                                                   30                                             30
2544734 2544734 NM     school 3500060 1   ALBUQUERQUE 350006000044 514 DEL NORTE HIGH Public Regular School No High 09 12 2020   grade_3                                                   0                                             0
2544735 2544735 NM     school 3500060 1   ALBUQUERQUE 350006000681 203 DENNIS CHAVEZ ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   95                                             95
2544736 2544736 NM     school 3500060 1   ALBUQUERQUE 350006000764 430 DESERT RIDGE MIDDLE Public Regular School No Middle 06 08 2020   grade_3                                                   0                                             0
2544737 2544737 NM     school 3500060 1   ALBUQUERQUE 350006000273 900 DESERT WILLOW FAMILY SCHOOL Public Alternative School No Elementary KG 08 2020   grade_3                                                   28                                             28
2544738 2544738 NM     school 3500060 1   ALBUQUERQUE 350006000853 63 DIGITAL ARTS AND TECHNOLOGY Charter Regular School Yes High 09 12 2020   grade_3                                                   0                                             0
2544739 2544739 NM     school 3500060 1   ALBUQUERQUE 350006000045 244 DOLORES GONZALES ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   57                                             57
2544740 2544740 NM     school 3500060 1   ALBUQUERQUE 350006000752 350 DOUBLE EAGLE ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   98                                             98
2544741 2544741 NM     school 3500060 1   ALBUQUERQUE 350006000047 249 DURANES ELEMENTARY Public Regular School No Elementary KG 05 2020   grade_3                                                   33                                             33
2544742 2544742 NM     school 3500060 1   ALBUQUERQUE 350006000916 593 EARLY COLLEGE ACADEMY Public Alternative School No High 09 12 2020   grade_3                                                   0                                             0
2544743 2544743 NM     school 3500060 1   ALBUQUERQUE 350006000808 24 EAST MOUNTAIN HIGH SCHOOL Charter Regular School Yes High 09 12 2020   grade_3                                                   0                                             0
2544744 2544744 NM     school 3500060 1   ALBUQUERQUE 350006000048 252 EAST SAN JOSE ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_3                                                   60                                             60

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