enrollments

Data source: Big Local News · About: Big Local

2,084 rows where grade = "grade_9" and state = "UT" sorted by district_state_type

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 1,984 ✖
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
1203307 1203307 UT     school 4900066 A4 Charter Summit Academy 490006600996 100 Summit Academy   Regular School Yes Elementary KG 08 2020   grade_9                                                   0                                             0
1203308 1203308 UT     school 4900066 A4 Charter Summit Academy 490006601469 300 Summit Academy - Independence   Regular School Yes Elementary KG 08 2020   grade_9                                                   0                                             0
1203309 1203309 UT     school 4900148 7G Charter Summit Academy High School 490014801396 700 Summit Academy High School   Regular School Yes High 09 12 2020   grade_9                                                   151                                             151
1203310 1203310 UT     school 4900044 4D Charter Syracuse Arts Academy 490004401145 100 Syracuse Arts Academy   Regular School Yes Other KG 09 2020   grade_9                                                   131                                             131
1203311 1203311 UT     school 4900044 4D Charter Syracuse Arts Academy 490004401494 110 Syracuse Arts Academy - North   Regular School Yes Elementary KG 06 2020   grade_9                                                   0                                             0
1203312 1203312 UT     school 4900179 8J Charter Terra Academy 490017901476 300 Terra Academy   Regular School Yes Other KG 12 2020   grade_9                                                   50                                             50
1203313 1203313 UT     school 4900193 2L Charter The Center for Creativity Innovation and Discovery 490019301513 300 The Center for Creativity Innovation and Discovery   Regular School Yes Elementary KG 08 2020   grade_9                                                   0                                             0
1203314 1203314 UT     school 4900015 94 Charter Thomas Edison 490001500820 100 Thomas Edison   Regular School Yes Elementary KG 08 2020   grade_9                                                   0                                             0
1203315 1203315 UT     school 4900015 94 Charter Thomas Edison 490001501284 110 Thomas Edison - South   Regular School Yes Elementary KG 08 2020   grade_9                                                   0                                             0
1203316 1203316 UT     school 4900016 95 Charter Timpanogos Academy 490001600830 110 Timpanogos Academy   Regular School Yes Elementary KG 06 2020   grade_9                                                   0                                             0
1203317 1203317 UT     school 4900192 7L Charter Treeside Charter School 490019201514 110 Treeside Charter School   Regular School Yes Elementary KG 06 2020   grade_9                                                   0                                             0
1203318 1203318 UT     school 4900012 90 Charter Tuacahn High School for the Performing Arts 490001200673 700 Tuacahn High School for the Performing Arts   Regular School Yes High 09 12 2020   grade_9                                                   114                                             114
1203319 1203319 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2020   grade_9                                                   15                                             15
1203320 1203320 UT     school 4900171 9I Charter Utah Career Path High School 490017101460 600 Utah Career Path High School   Regular School Yes High 09 12 2020   grade_9                                                   22                                             22
1203321 1203321 UT     school 4900151 2H Charter Utah Connections Academy 490015101386 101 Utah Connections Academy   Regular School Yes Other KG 12 2020   grade_9                                                   155                                             155
1203322 1203322 UT     school 4900020 1B Charter Utah County Academy of Science 490002001106 700 Utah County Academy of Science   Regular School Yes High 09 12 2020   grade_9                                                   164                                             164
1203323 1203323 UT     school 4900166 1I Charter Utah International Charter School 490016601433 700 Utah International Charter School   Regular School Yes High 07 12 2020   grade_9                                                   50                                             50
1203324 1203324 UT     school 4900176 2K Charter Utah Military Academy 490017601463 700 Utah Military Academy   Regular School Yes High 07 12 2020   grade_9                                                   97                                             97
1203325 1203325 UT     school 4900176 2K Charter Utah Military Academy 490017601501 710 Utah Military Academy - Camp Williams   Regular School Yes High 07 12 2020   grade_9                                                   97                                             97
1203326 1203326 UT     school 4900130 5F Charter Utah Virtual Academy 490013001196 700 Utah Virtual Academy   Regular School Yes Other KG 12 2020   grade_9                                                   269                                             269
1203327 1203327 UT     school 4900158 8H Charter Valley Academy 490015801421 100 Valley Academy   Regular School Yes Elementary KG 08 2020   grade_9                                                   0                                             0
1203328 1203328 UT     school 4900183 1K Charter Vanguard Academy 490018301475 700 Vanguard Academy   Regular School Yes High 07 12 2020   grade_9                                                   83                                             83
1203329 1203329 UT     school 4900133 3F Charter Venture Academy 490013301216 100 Venture Academy   Regular School Yes Other KG 12 2020   grade_9                                                   100                                             100
1203330 1203330 UT     school 4900141 2G Charter Vista School 490014101296 100 Vista School   Regular School Yes Elementary KG 08 2020   grade_9                                                   0                                             0
1203331 1203331 UT     school 4900160 5I Charter Voyage Academy 490016001442 100 Voyage Academy   Regular School Yes Elementary KG 06 2020   grade_9                                                   0                                             0
1203332 1203332 UT     school 4900061 81 Charter Walden School of Liberal Arts 490006100991 300 Walden School of Liberal Arts   Regular School Yes Other KG 12 2020   grade_9                                                   38                                             38
1203333 1203333 UT     school 4900184 7K Charter Wallace Stegner Academy 490018401489 300 Wallace Stegner Academy   Regular School Yes Elementary KG 08 2020   grade_9                                                   0                                             0
1203334 1203334 UT     school 4900024 4B Charter Wasatch Peak Academy 490002401107 100 Wasatch Peak Academy   Regular School Yes Elementary KG 06 2020   grade_9                                                   0                                             0
1203335 1203335 UT     school 4900185 5K Charter Wasatch Waldorf Charter School 490018501491 300 Wasatch Waldorf Charter School   Regular School Yes Elementary KG 08 2020   grade_9                                                   0                                             0
1203336 1203336 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   grade_9                                                   0                                             0
1203337 1203337 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   grade_9                                                   0                                             0
1203338 1203338 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_9                                                   25                                             25
1361508 1361508 UT     school 4900017 83 Charter Academy for Math Engineering & Science 490001700904 700 Academy for Math Engineering & Science   Regular School Yes High 09 12 2021   grade_9                                                   126                                             126
1361509 1361509 UT     school 4900198 1M Charter Advantage Arts Academy 490019801524 100 Advantage Arts Academy   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361510 1361510 UT     school 4900186 8K Charter American Academy of Innovation 490018601483 700 American Academy of Innovation   Regular School Yes High 06 12 2021   grade_9                                                   68                                             68
1361511 1361511 UT     school 4900033 8B Charter American Leadership Academy 490003301056 100 American Leadership Academy   Regular School Yes Other KG 12 2021   grade_9                                                   158                                             158
1361512 1361512 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2021   grade_9                                                   171                                             171
1361513 1361513 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361514 1361514 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361515 1361515 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2021   grade_9                                                   111                                             111
1361516 1361516 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 10 2021   grade_9                                                   26                                             26
1361517 1361517 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Other KG 09 2021   grade_9                                                   0                                             0
1361518 1361518 UT     school 4900174 2J Charter Ascent Academies of Utah 490017401523 330 Ascent Academies of Utah - West Valley   Regular School Yes Other KG 12 2021   grade_9                                                   0                                             0
1361519 1361519 UT     school 4900174 2J Charter Ascent Academies of Utah 490017401453 300 Ascent Academies of Utah Farmington   Regular School Yes Other KG 09 2021   grade_9                                                   52                                             52
1361520 1361520 UT     school 4900174 2J Charter Ascent Academies of Utah 490017401490 320 Ascent Academies of Utah Lehi   Regular School Yes Other KG 09 2021   grade_9                                                   28                                             28
1361521 1361521 UT     school 4900174 2J Charter Ascent Academies of Utah 490017401472 310 Ascent Academies of Utah West Jordan   Regular School Yes Other KG 09 2021   grade_9                                                   71                                             71
1361522 1361522 UT     school 4900181 4K Charter Athenian eAcademy 490018101473 300 Athenian eAcademy   Regular School Yes Other KG 12 2021   grade_9                                                   22                                             22
1361523 1361523 UT     school 4900189 1L Charter Athlos Academy of Utah 490018901503 300 Athlos Academy of Utah   Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
1361524 1361524 UT     school 4900146 3G Charter Bear River Charter School 490014601375 100 Bear River Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
1361525 1361525 UT     school 4900023 3B Charter Beehive Science & Technology Academy 490002301060 700 Beehive Science & Technology Academy   Regular School Yes High 06 12 2021   grade_9                                                   39                                             39
1361526 1361526 UT     school 4900195 6L Charter Bonneville Academy 490019501507 300 Bonneville Academy   Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
1361527 1361527 UT     school 4900202 3M Charter Bridge Elementary School 490020201566 100 Bridge Elementary School   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361528 1361528 UT     school 4900074 3E Charter C.S. Lewis Academy 490007401190 100 C.S. Lewis Academy   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361529 1361529 UT     school 4900143 5G Charter Canyon Grove Academy 490014301376 100 Canyon Grove Academy   Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
1361530 1361530 UT     school 4900071 9D Charter Canyon Rim Academy 490007101178 100 Canyon Rim Academy   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361531 1361531 UT     school 4900040 2D Charter Channing Hall 490004001130 100 Channing Hall   Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
1361532 1361532 UT     school 4900009 87 Charter City Academy 490000900742 700 City Academy   Regular School Yes High 07 12 2021   grade_9                                                   33                                             33
1361533 1361533 UT     school 4900065 A3 Charter Davinci Academy 490006500995 700 Davinci Academy   Regular School Yes Other KG 12 2021   grade_9                                                   95                                             95
1361534 1361534 UT     school 4900169 3J Charter Dixie Montessori Academy 490016901452 100 Dixie Montessori Academy   Regular School Yes Elementary KG 07 2021   grade_9                                                   0                                             0
1361535 1361535 UT     school 4900073 4E Charter Dual Immersion Academy 490007301187 100 Dual Immersion Academy   Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
1361536 1361536 UT     school 4900140 6F Charter Early Light Academy at Daybreak 490014001268 300 Early Light Academy at Daybreak   Regular School Yes Other KG 09 2021   grade_9                                                   89                                             89
1361537 1361537 UT     school 4900036 A8 Charter East Hollywood High 490003601072 700 East Hollywood High   Regular School Yes High 09 12 2021   grade_9                                                   36                                             36
1361538 1361538 UT     school 4900070 5E Charter Edith Bowen Laboratory School 490007001176 108 Edith Bowen Laboratory School   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361539 1361539 UT     school 4900155 3H Charter Endeavor Hall 490015501407 100 Endeavor Hall   Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
1361540 1361540 UT     school 4900041 3C Charter Entheos Academy 490004101136 100 Entheos Academy   Regular School Yes Other KG 09 2021   grade_9                                                   0                                             0
1361541 1361541 UT     school 4900041 3C Charter Entheos Academy 490004101437 110 Entheos Academy Magna   Regular School Yes Other KG 09 2021   grade_9                                                   0                                             0
1361542 1361542 UT     school 4900161 2I Charter Esperanza School 490016101440 100 Esperanza School   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361543 1361543 UT     school 4900136 7F Charter Excelsior Academy 490013601272 100 Excelsior Academy   Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
1361544 1361544 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2021   grade_9                                                   33                                             33
1361545 1361545 UT     school 4900187 6K Charter Franklin Discovery Academy 490018701488 100 Franklin Discovery Academy   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361546 1361546 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006200992 100 Freedom Preparatory Academy   Regular School Yes Other PK 12 2021   grade_9                                                   69                                             69
1361547 1361547 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006201492 105 Freedom Preparatory Academy - Vineyard   Regular School Yes Elementary PK 05 2021   grade_9                                                   0                                             0
1361548 1361548 UT     school 4900122 7E Charter Gateway Preparatory Academy 490012201214 100 Gateway Preparatory Academy   Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
1361549 1361549 UT     school 4900046 5D Charter George Washington Academy 490004601147 100 George Washington Academy   Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
1361550 1361550 UT     school 4900147 8G Charter Good Foundations Academy 490014701389 100 Good Foundations Academy   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361551 1361551 UT     school 4900177 7J Charter Greenwood Charter School 490017701468 100 Greenwood Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
1361552 1361552 UT     school 4900072 1E Charter Guadalupe School 490007201174 100 Guadalupe School   Regular School Yes Elementary PK 06 2021   grade_9                                                   0                                             0
1361553 1361553 UT     school 4900137 8F Charter Hawthorn Academy 490013701493 110 Hawthorn Academy South Jordan   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361554 1361554 UT     school 4900137 8F Charter Hawthorn Academy 490013701298 100 Hawthorn Academy   Regular School Yes Other KG 09 2021   grade_9                                                   80                                             80
1361555 1361555 UT     school 4900156 5H Charter Highmark Charter School 490015601415 100 Highmark Charter School   Regular School Yes Other KG 09 2021   grade_9                                                   98                                             98
1361556 1361556 UT     school 4900194 5L Charter Ignite Entrepreneurship Academy 490019401509 300 Ignite Entrepreneurship Academy   Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
1361557 1361557 UT     school 4900039 2C Charter Intech Collegiate Academy 490003901129 600 Intech Collegiate Academy   Regular School Yes High 07 12 2021   grade_9                                                   42                                             42
1361558 1361558 UT     school 4900067 A5 Charter Itineris Early College High 490006700997 700 Itineris Early College High   Regular School Yes High 10 12 2021   grade_9                                                   0                                             0
1361559 1361559 UT     school 4900139 1G Charter Jefferson Academy 490013901289 100 Jefferson Academy   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361560 1361560 UT     school 4900014 93 Charter John Hancock Charter School 490001400811 105 John Hancock Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
1361561 1361561 UT     school 4900056 2E Charter Karl G. Maeser Preparatory Academy 490005601175 700 Karl G. Maeser Preparatory Academy   Regular School Yes High 07 12 2021   grade_9                                                   133                                             133
1361562 1361562 UT     school 4900043 4C Charter Lakeview Academy 490004301144 100 Lakeview Academy   Regular School Yes Other KG 09 2021   grade_9                                                   68                                             68
1361563 1361563 UT     school 4900196 3L Charter Leadership Academy of Utah 490019601516 700 Leadership Academy of Utah   Regular School Yes High 06 12 2021   grade_9                                                   92                                             92
1361564 1361564 UT     school 4900162 3I Charter Leadership Learning Academy 490016201438 100 Leadership Learning Academy   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361565 1361565 UT     school 4900162 3I Charter Leadership Learning Academy 490016201522 110 Leadership Learning Academy - Ogden   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361566 1361566 UT     school 4900045 5C Charter Legacy Preparatory Academy 490004501146 100 Legacy Preparatory Academy   Regular School Yes Other KG 09 2021   grade_9                                                   88                                             88
1361567 1361567 UT     school 4900022 2B Charter Lincoln Academy 490002201082 100 Lincoln Academy   Regular School Yes Other KG 09 2021   grade_9                                                   88                                             88
1361568 1361568 UT     school 4900182 9J Charter Lumen Scholar Institute 490018201467 300 Lumen Scholar Institute   Regular School Yes Other KG 12 2021   grade_9                                                   58                                             58
1361569 1361569 UT     school 4900165 4I Charter Mana Academy Charter School 490016501439 700 Mana Academy Charter School   Regular School Yes Other KG 12 2021   grade_9                                                   27                                             27
1361570 1361570 UT     school 4900144 4G Charter Maria Montessori Academy 490014401374 100 Maria Montessori Academy   Regular School Yes Other KG 09 2021   grade_9                                                   0                                             0
1361571 1361571 UT     school 4900131 8E Charter Merit College Preparatory Academy 490013101220 700 Merit College Preparatory Academy   Regular School Yes High 07 12 2021   grade_9                                                   86                                             86
1361572 1361572 UT     school 4900035 A7 Charter Moab Charter School 490003501085 100 Moab Charter School   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361573 1361573 UT     school 4900049 7C Charter Monticello Academy 490004901150 100 Monticello Academy   Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
1361574 1361574 UT     school 4900049 7C Charter Monticello Academy 490004901556 105 Monticello Academy West Point   Regular School Yes Elementary KG 06 2021   grade_9                                                   0                                             0
1361575 1361575 UT     school 4900138 9F Charter Mountain Heights Academy 490013801285 600 Mountain Heights Academy   Regular School Yes High 07 12 2021   grade_9                                                   265                                             265

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