Data source: Big Local News · About: Big Local

1,973 rows where grade = "grade_6" and state = "NM" sorted by district_state_id descending

View and edit SQL

year

grade

  • grade_6 · 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
2548250 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported Alternative School No High 09 12 2020   grade_6                                                   0                                             0
2548251 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported Alternative School No High 06 12 2020   grade_6                                                   0                                             0
2548252 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported Alternative School No High 06 12 2020   grade_6                                                   0                                             0
2954357 NM     school 3500011 99   JUVENILE JUSTICE 350001100973 4 AZTEC YOUTH ACADEMY State Supported - State Supported Alternative School No High 09 12 2021   grade_6                                                   0                                             0
2954358 NM     school 3500011 99   JUVENILE JUSTICE 350001101108 6 CAMINO NUEVO YOUTH State Supported - State Supported Alternative School No High 06 12 2021   grade_6                                                   0                                             0
2954359 NM     school 3500011 99   JUVENILE JUSTICE 350001100985 3 FOOTHILL HIGH SCHOOL State Supported - State Supported Alternative School No High 06 12 2021   grade_6                                                   0                                             0
2954360 NM     school   99   JUVENILE JUSTICE   0 JUVENILE JUSTICE DISTRICT OFFICE Central Office - Central Office           2021   grade_6                                                   0                                             0
2548559 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported Alternative School No High 06 12 2020   grade_6                                                   0                                             0
2954660 NM     school 3500015 97   SEQUOYAH 350001500971 867 SEQUOYAH State Supported - State Supported Alternative School No High 06 12 2021   grade_6                                                   0                                             0
2547973 NM     school 3500016 95   CHILDRENS PSYC 350001600983 994 CHILDRENS PSYCHIATRY State Supported Alternative School No Other PK 12 2020   grade_6                                                   7                                             7
2954734 NM     school 3500016 95   UNM MIMBRES SCHOOL 350001600983 994 UNM MIMBRES SCHOOL State Supported - State Supported Alternative School No Other PK 12 2021   grade_6                                                   6                                             6
2548419 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_6                                                   2                                             2
2954523 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   grade_6                                                   2                                             2
2548420 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_6                                                   11                                             11
2954524 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   grade_6                                                   8                                             8
2548408 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_6                                                   0                                             0
2548409 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_6                                                   0                                             0
2548410 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_6                                                   0                                             0
2548411 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_6                                                   0                                             0
2548412 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported Alternative School No Secondary 09 11 2020   grade_6                                                   0                                             0
2548413 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported Alternative School No High 08 12 2020   grade_6                                                   0                                             0
2548414 NM     school 3500012 91   NM CORRECTIONS 350001200970 5 ROSWELL CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_6                                                   0                                             0
2548415 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_6                                                   0                                             0
2548416 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported Alternative School No High 08 12 2020   grade_6                                                   0                                             0
2548417 NM     school 3500012 91   NM CORRECTIONS 350001200979 8 WESTERN NM CORRECTIONS State Supported Alternative School No High 08 12 2020   grade_6                                                   0                                             0
2954513 NM     school 3500012 91   NM CORRECTIONS 350001200986 4 CENTRAL NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_6                                                   0                                             0
2954514 NM     school 3500012 91   NM CORRECTIONS 350001200976 7 GUADALUPE COUNTY CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_6                                                   0                                             0
2954515 NM     school 3500012 91   NM CORRECTIONS 350001200974 6 LAE COUNTY CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_6                                                   0                                             0
2954516 NM     school 3500012 91   NM CORRECTIONS 350001201049 10 NORTHEASTERN NM CORRECTIONAL FACILITY State Supported - State Supported Alternative School No High 08 12 2021   grade_6                                                   0                                             0
2954517 NM     school 3500012 91   NM CORRECTIONS 350001200987 3 NORTHWESTERN NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_6                                                   0                                             0
2954518 NM     school 3500012 91   NM CORRECTIONS 350001201152 11 OTERO COUNTY PRISON State Supported - State Supported Alternative School No High 08 12 2021   grade_6                                                   0                                             0
2954519 NM     school 3500012 91   NM CORRECTIONS 350001200977 1 PENITENTIARY OF NM-SANTA FE State Supported - State Supported Alternative School No High 08 12 2021   grade_6                                                   0                                             0
2954520 NM     school 3500012 91   NM CORRECTIONS 350001200982 2 SOUTHERN NM CORRECTIONS State Supported - State Supported Alternative School No High 08 12 2021   grade_6                                                   0                                             0
2954521 NM     school 3500012 91   NM CORRECTIONS 350001201046 9 SPRINGER CORRECTIONAL FACILITY State Supported - State Supported Alternative School No High 08 12 2021   grade_6                                                   0                                             0
2548450 NM     school   9   RATON   998 HOMEBOUND Off-Site           2020   grade_6                                                   0                                             0
2548451 NM     school 3502190 9   RATON 350219000499 80 LONGFELLOW ELEMENTARY Public Regular School No Elementary PK 02 2020   grade_6                                                   0                                             0
2548452 NM     school 3502190 9   RATON 350219000500 136 RATON HIGH Public Regular School No High 07 12 2020   grade_6                                                   0                                             0
2548453 NM     school 3502190 9   RATON 350219000501 135 RATON INTERMEDIATE Public Regular School No Elementary 03 06 2020   grade_6                                                   82                                             82
2954553 NM     school 3502190 9   RATON 350219000499 80 LONGFELLOW ELEMENTARY Public - Elementary School Regular School No Elementary PK 02 2021   grade_6                                                   0                                             0
2954554 NM     school 3502190 9   RATON 350219000500 136 RATON HIGH Public - High School Regular School No High 07 12 2021   grade_6                                                   0                                             0
2954555 NM     school 3502190 9   RATON 350219000501 135 RATON INTERMEDIATE Public - Middle School Regular School No Elementary 03 06 2021   grade_6                                                   76                                             76
2548649 NM     school   89   ZUNI   998 HOMEBOUND Off-Site           2020   grade_6                                                   1                                             1
2548650 NM     school   89   ZUNI   992 MISC PRESCHOOL PROGRAM Off-Site           2020   grade_6                                                   0                                             0
2548651 NM     school   89   ZUNI   997 MISC PRIVATE Private           2020   grade_6                                                   10                                             10
2548652 NM     school 3502800 89   ZUNI 350280001124 166 SHIWI TS'ANA ELEMENTARY Public Regular School No Elementary PK 05 2020   grade_6                                                   0                                             0
2548653 NM     school 3502800 89   ZUNI 350280000677 192 TWIN BUTTES CYBER ACADEMY Public Regular School No High 07 12 2020   grade_6                                                   0                                             0
2548654 NM     school 3502800 89   ZUNI 350280000676 190 ZUNI HIGH Public Regular School No High 09 12 2020   grade_6                                                   0                                             0
2548655 NM     school 3502800 89   ZUNI 350280000678 195 ZUNI MIDDLE Public Regular School No Middle 06 08 2020   grade_6                                                   80                                             80
2954753 NM     school   89   ZUNI   998 HOMEBOUND Off-Site - Central Office           2021   grade_6                                                   1                                             1
2954754 NM     school   89   ZUNI   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   grade_6                                                   0                                             0
2954755 NM     school   89   ZUNI   997 MISC PRIVATE Private - Non-Accredited Private School           2021   grade_6                                                   6                                             6
2954756 NM     school 3502800 89   ZUNI 350280001124 166 SHIWI TS'ANA ELEMENTARY Public - Elementary School Regular School No Elementary PK 05 2021   grade_6                                                   0                                             0
2954757 NM     school 3502800 89   ZUNI 350280000677 192 TWIN BUTTES CYBER ACADEMY Public - High School Regular School No High 07 12 2021   grade_6                                                   0                                             0
2954758 NM     school 3502800 89   ZUNI 350280000676 190 ZUNI HIGH Public - High School Regular School No High 09 12 2021   grade_6                                                   0                                             0
2954759 NM     school 3502800 89   ZUNI 350280000678 195 ZUNI MIDDLE Public - Middle School Regular School No Middle 06 08 2021   grade_6                                                   95                                             95
2548183 NM     school 3501170 88   GRANTS 350117000327 915 BLUEWATER ELEMENTARY Public Regular School No Elementary KG 06 2020   grade_6                                                   16                                             16
2548184 NM     school 3501170 88   GRANTS 350117000328 38 CUBERO ELEMENTARY Public Regular School No Elementary KG 06 2020   grade_6                                                   37                                             37
2548185 NM     school 3501170 88   GRANTS 350117001153 60 GCCS EARLY COLLEGE HIGH SCHOOL Public Regular School No High 09 12 2020   grade_6                                                   0                                             0
2548186 NM     school   88   GRANTS   4 GRANTS HEAD START Off-Site           2020   grade_6                                                   0                                             0
2548187 NM     school 3501170 88   GRANTS 350117000329 55 GRANTS HIGH Public Regular School No High 09 12 2020   grade_6                                                   0                                             0
2548188 NM     school   88   GRANTS   998 HOMEBOUND Off-Site           2020   grade_6                                                   0                                             0
2548189 NM     school 3501170 88   GRANTS 350117000330 57 LAGUNA-ACOMA HIGH Public Regular School No High 09 12 2020   grade_6                                                   0                                             0
2548190 NM     school 3501170 88   GRANTS 350117000665 58 LAGUNA-ACOMA MIDDLE Public Regular School No Middle 07 08 2020   grade_6                                                   0                                             0
2548191 NM     school 3501170 88   GRANTS 350117000331 56 LOS ALAMITOS MIDDLE Public Regular School No Middle 07 08 2020   grade_6                                                   0                                             0
2548192 NM     school 3501170 88   GRANTS 350117000332 99 MESA VIEW ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_6                                                   62                                             62
2548193 NM     school 3501170 88   GRANTS 350117000333 104 MILAN ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_6                                                   67                                             67
2548194 NM     school   88   GRANTS   992 MISC PRESCHOOL PROGRAM Off-Site           2020   grade_6                                                   0                                             0
2548195 NM     school   88   GRANTS   997 MISC PRIVATE Private           2020   grade_6                                                   3                                             3
2548196 NM     school 3501170 88   GRANTS 350117000334 106 MOUNT TAYLOR ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_6                                                   77                                             77
2548197 NM     school 3501170 88   GRANTS 350117000336 152 SAN RAFAEL ELEMENTARY Public Regular School No Elementary KG 06 2020   grade_6                                                   5                                             5
2548198 NM     school 3501170 88   GRANTS 350117000337 155 SEBOYETA ELEMENTARY Public Regular School No Elementary KG 06 2020   grade_6                                                   11                                             11
2954290 NM     school 3501170 88   GRANTS 350117000327 915 BLUEWATER ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   grade_6                                                   11                                             11
2954291 NM     school 3501170 88   GRANTS 350117000328 38 CUBERO ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   grade_6                                                   35                                             35
2954292 NM     school 3501170 88   GRANTS 350117001153 60 GCCS EARLY COLLEGE HIGH SCHOOL Public - High School Regular School No High 09 12 2021   grade_6                                                   0                                             0
2954293 NM     school   88   GRANTS   4 GRANTS HEAD START Off-Site - Prekindergarten           2021   grade_6                                                   0                                             0
2954294 NM     school 3501170 88   GRANTS 350117000329 55 GRANTS HIGH Public - High School Regular School No High 09 12 2021   grade_6                                                   0                                             0
2954295 NM     school   88   GRANTS   998 HOMEBOUND Off-Site - Central Office           2021   grade_6                                                   0                                             0
2954296 NM     school 3501170 88   GRANTS 350117000330 57 LAGUNA-ACOMA HIGH Public - High School Regular School No High 09 12 2021   grade_6                                                   0                                             0
2954297 NM     school 3501170 88   GRANTS 350117000665 58 LAGUNA-ACOMA MIDDLE Public - Middle School Regular School No Middle 07 08 2021   grade_6                                                   0                                             0
2954298 NM     school 3501170 88   GRANTS 350117000331 56 LOS ALAMITOS MIDDLE Public - Middle School Regular School No Middle 07 08 2021   grade_6                                                   0                                             0
2954299 NM     school 3501170 88   GRANTS 350117000332 99 MESA VIEW ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_6                                                   51                                             51
2954300 NM     school 3501170 88   GRANTS 350117000333 104 MILAN ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_6                                                   49                                             49
2954301 NM     school   88   GRANTS   992 MISC PRESCHOOL PROGRAM Off-Site - Prekindergarten           2021   grade_6                                                   0                                             0
2954302 NM     school   88   GRANTS   997 MISC PRIVATE Private - Non-Accredited Private School           2021   grade_6                                                   10                                             10
2954303 NM     school 3501170 88   GRANTS 350117000334 106 MOUNT TAYLOR ELEMENTARY Public - Elementary School Regular School No Elementary PK 06 2021   grade_6                                                   68                                             68
2954304 NM     school 3501170 88   GRANTS 350117000336 152 SAN RAFAEL ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   grade_6                                                   10                                             10
2954305 NM     school 3501170 88   GRANTS 350117000337 155 SEBOYETA ELEMENTARY Public - Elementary School Regular School No Elementary KG 06 2021   grade_6                                                   4                                             4
2547890 NM     school 3500180 87   BELEN 350018000140 26 BELEN HIGH Public Regular School No High 09 12 2020   grade_6                                                   0                                             0
2547891 NM     school 3500180 87   BELEN 350018000848 1 BELEN INFINITY HIGH Public Alternative School No High 09 12 2020   grade_6                                                   0                                             0
2547892 NM     school 3500180 87   BELEN 350018000141 25 BELEN MIDDLE Public Regular School No Middle 07 08 2020   grade_6                                                   0                                             0
2547893 NM     school 3500180 87   BELEN 350018000142 34 CENTRAL ELEMENTARY Public Regular School No Middle 04 06 2020   grade_6                                                   71                                             71
2547894 NM     school 3500180 87   BELEN 350018000143 80 DENNIS CHAVEZ ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_6                                                   56                                             56
2547895 NM     school 3500180 87   BELEN 350018000144 66 GIL SANCHEZ ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_6                                                   48                                             48
2547896 NM     school 3500180 87   BELEN 350018000145 68 JARAMILLO ELEMENTARY Public Regular School No Elementary PK 03 2020   grade_6                                                   0                                             0
2547897 NM     school 3500180 87   BELEN 350018030003 38 LA MERCED ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_6                                                   67                                             67
2547898 NM     school 3500180 87   BELEN 350018000849 3 LA PROMESA ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_6                                                   30                                             30
2547899 NM     school 3500180 87   BELEN 350018000146 45 RIO GRANDE ELEMENTARY Public Regular School No Elementary PK 06 2020   grade_6                                                   27                                             27
2547900 NM     school 3500180 87   BELEN 350018000867 6 THE FAMILY SCHOOL Public Alternative School No Elementary 01 08 2020   grade_6                                                   18                                             18
2954009 NM     school 3500180 87   BELEN 350018000140 26 BELEN HIGH Public - High School Regular School No High 09 12 2021   grade_6                                                   0                                             0
2954010 NM     school 3500180 87   BELEN 350018000848 1 BELEN INFINITY HIGH Public - High School Alternative School No High 09 12 2021   grade_6                                                   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]);