enrollments

Data source: Big Local News · About: Big Local

29,176 rows where state = "UT" sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
1364783 1364783 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_12                                                   26                                             26
1364782 1364782 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364781 1364781 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   grade_12                                                   0                                             0
1364780 1364780 UT     school 4900185 5K Charter Wasatch Waldorf Charter School 490018501491 300 Wasatch Waldorf Charter School   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364779 1364779 UT     school 4900024 4B Charter Wasatch Peak Academy 490002401107 100 Wasatch Peak Academy   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364778 1364778 UT     school 4900184 7K Charter Wallace Stegner Academy 490018401489 300 Wallace Stegner Academy   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364777 1364777 UT     school 4900061 81 Charter Walden School of Liberal Arts 490006100991 300 Walden School of Liberal Arts   Regular School Yes Other KG 12 2021   grade_12                                                   34                                             34
1364776 1364776 UT     school 4900160 5I Charter Voyage Academy 490016001442 100 Voyage Academy   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364775 1364775 UT     school 4900141 2G Charter Vista School 490014101296 100 Vista School   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364774 1364774 UT     school 4900133 3F Charter Venture Academy 490013301216 100 Venture Academy   Regular School Yes Other KG 12 2021   grade_12                                                   72                                             72
1364773 1364773 UT     school 4900183 1K Charter Vanguard Academy 490018301475 700 Vanguard Academy   Regular School Yes Other KG 12 2021   grade_12                                                   73                                             73
1364772 1364772 UT     school 4900158 8H Charter Valley Academy 490015801421 100 Valley Academy   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364771 1364771 UT     school 4900130 5F Charter Utah Virtual Academy 490013001196 700 Utah Virtual Academy   Regular School Yes Other KG 12 2021   grade_12                                                   236                                             236
1364770 1364770 UT     school 4900176 2K Charter Utah Military Academy 490017601501 710 Utah Military Academy - Camp Williams   Regular School Yes High 07 12 2021   grade_12                                                   73                                             73
1364769 1364769 UT     school 4900176 2K Charter Utah Military Academy 490017601463 700 Utah Military Academy   Regular School Yes High 07 12 2021   grade_12                                                   75                                             75
1364768 1364768 UT     school 4900166 1I Charter Utah International Charter School 490016601433 700 Utah International Charter School   Regular School Yes High 06 12 2021   grade_12                                                   50                                             50
1364767 1364767 UT     school 4900020 1B Charter Utah County Academy of Science 490002001106 700 Utah County Academy of Science   Regular School Yes High 09 12 2021   grade_12                                                   130                                             130
1364766 1364766 UT     school 4900151 2H Charter Utah Connections Academy 490015101386 101 Utah Connections Academy   Regular School Yes Other KG 12 2021   grade_12                                                   90                                             90
1364765 1364765 UT     school 4900171 9I Charter Utah Career Path High School 490017101460 600 Utah Career Path High School   Regular School Yes High 09 12 2021   grade_12                                                   63                                             63
1364764 1364764 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2021   grade_12                                                   19                                             19
1364763 1364763 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 2021   grade_12                                                   76                                             76
1364762 1364762 UT     school 4900192 7L Charter Treeside Charter School 490019201514 110 Treeside Charter School   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364761 1364761 UT     school 4900016 95 Charter Timpanogos Academy 490001600830 110 Timpanogos Academy   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364760 1364760 UT     school 4900015 94 Charter Thomas Edison 490001501284 110 Thomas Edison - South   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364759 1364759 UT     school 4900015 94 Charter Thomas Edison 490001500820 100 Thomas Edison   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364758 1364758 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 2021   grade_12                                                   0                                             0
1364757 1364757 UT     school 4900179 8J Charter Terra Academy 490017901476 300 Terra Academy   Regular School Yes Other KG 12 2021   grade_12                                                   44                                             44
1364756 1364756 UT     school 4900044 4D Charter Syracuse Arts Academy 490004401494 110 Syracuse Arts Academy - North   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364755 1364755 UT     school 4900044 4D Charter Syracuse Arts Academy 490004401145 100 Syracuse Arts Academy   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364754 1364754 UT     school 4900148 7G Charter Summit Academy High School 490014801396 700 Summit Academy High School   Regular School Yes High 09 12 2021   grade_12                                                   111                                             111
1364753 1364753 UT     school 4900066 A4 Charter Summit Academy 490006601469 300 Summit Academy - Independence   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364752 1364752 UT     school 4900066 A4 Charter Summit Academy 490006600996 100 Summit Academy   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364751 1364751 UT     school 4900066 A4 Charter Summit Academy 490006601499 310 Summit Academy - Bluffdale   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364750 1364750 UT     school 4900037 A9 Charter Success Academy 490003701101 700 Success Academy   Regular School Yes High 09 12 2021   grade_12                                                   37                                             37
1364749 1364749 UT     school 4900037 A9 Charter Success Academy 490003701470 710 Success DSU   Regular School Yes High 10 12 2021   grade_12                                                   83                                             83
1364748 1364748 UT     school 4900188 9K Charter St. George Academy 490018801485 700 St. George Academy   Regular School Yes High 08 12 2021   grade_12                                                   33                                             33
1364747 1364747 UT     school 4900042 3D Charter Spectrum Academy 490004201464 300 Spectrum Academy - Pleasant Grove   Regular School Yes Other KG 12 2021   grade_12                                                   45                                             45
1364746 1364746 UT     school 4900042 3D Charter Spectrum Academy 490004201137 100 Spectrum Academy   Regular School Yes Other KG 12 2021   grade_12                                                   67                                             67
1364745 1364745 UT     school 4900011 89 Charter Soldier Hollow Charter School 490001100587 100 Soldier Hollow Charter School   Regular School Yes Elementary PK 08 2021   grade_12                                                   0                                             0
1364744 1364744 UT     school 4900170 6J Charter Scholar Academy 490017001456 100 Scholar Academy   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364743 1364743 UT     school 4900050 7D Charter Salt Lake School for the Performing Arts 490005001151 700 Salt Lake School for the Performing Arts   Regular School Yes High 09 12 2021   grade_12                                                   53                                             53
1364742 1364742 UT     school 4900123 4F Charter Salt Lake Center for Science Education 490012301208 300 Salt Lake Center for Science Education   Regular School Yes High 06 12 2021   grade_12                                                   47                                             47
1364741 1364741 UT     school 4900018 97 Charter Salt Lake Arts Academy 490001800905 300 Salt Lake Arts Academy   Regular School Yes Middle 05 08 2021   grade_12                                                   0                                             0
1364740 1364740 UT     school 4900178 3K Charter Roots Charter High School 490017801477 700 Roots Charter High School   Regular School Yes High 09 12 2021   grade_12                                                   63                                             63
1364739 1364739 UT     school 4900125 2F Charter Rockwell Charter High School 490012501199 700 Rockwell Charter High School   Regular School Yes High 07 12 2021   grade_12                                                   78                                             78
1364738 1364738 UT     school 4900038 1D Charter Renaissance Academy 490003801128 100 Renaissance Academy   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364737 1364737 UT     school 4900197 8L Charter Real Salt Lake Academy High School 490019701517 700 Real Salt Lake Academy High School   Regular School Yes High 09 12 2021   grade_12                                                   79                                             79
1364736 1364736 UT     school 4900032 7B Charter Reagan Academy 490003201095 100 Reagan Academy   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364735 1364735 UT     school 4900064 A2 Charter Ranches Academy 490006400994 100 Ranches Academy   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364734 1364734 UT     school 4900132 1F Charter Quest Academy 490013201218 100 Quest Academy   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364733 1364733 UT     school 4900124 9E Charter Providence Hall 490012401202 100 Providence Hall   Regular School Yes Other KG 12 2021   grade_12                                                   151                                             151
1364732 1364732 UT     school 4900157 6H Charter Promontory School of Expeditionary Learning 490015701416 100 Promontory School of Expeditionary Learning   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364731 1364731 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_12                                                   29                                             29
1364730 1364730 UT     school 4900052 9C Charter Paradigm High School 490005201153 700 Paradigm High School   Regular School Yes High 07 12 2021   grade_12                                                   72                                             72
1364729 1364729 UT     school 4900159 7H Charter Pacific Heritage Academy 490015901406 100 Pacific Heritage Academy   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364728 1364728 UT     school 4900118 8D Charter Open Classroom 490011801135 240 Open Classroom   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364727 1364727 UT     school 4900058 68 Charter Ogden Preparatory Academy 490005800989 100 Ogden Preparatory Academy   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364726 1364726 UT     school 4900021 1C Charter Odyssey Charter School 490002101092 100 Odyssey Charter School   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364725 1364725 UT     school 4900025 5B Charter North Star Academy 490002501089 100 North Star Academy   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364724 1364724 UT     school 4900068 A6 Charter North Davis Preparatory Academy 490006800998 100 North Davis Preparatory Academy   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364723 1364723 UT     school 4900048 6D Charter Noah Webster Academy 490004801149 100 Noah Webster Academy   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364722 1364722 UT     school 4900063 A1 Charter No. UT. Acad. for Math Engineering & Science 490006301528 705 No. UT. Acad. of Math Engineering & Science - Ogden   Regular School Yes High 10 12 2021   grade_12                                                   108                                             108
1364721 1364721 UT     school 4900063 A1 Charter No. UT. Acad. for Math Engineering & Science 490006300993 700 No. UT. Acad. for Math Engineering & Science   Regular School Yes High 10 12 2021   grade_12                                                   227                                             227
1364720 1364720 UT     school 4900034 9B Charter Navigator Pointe Academy 490003401088 100 Navigator Pointe Academy   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364719 1364719 UT     school 4900051 8C Charter Mountainville Academy 490005101152 100 Mountainville Academy   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364718 1364718 UT     school 4900175 5J Charter Mountain West Montessori Academy 490017501455 300 Mountain West Montessori Academy   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364717 1364717 UT     school 4900203 4M Charter Mountain Sunrise Academy 490020301565 100 Mountain Sunrise Academy   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364716 1364716 UT     school 4900138 9F Charter Mountain Heights Academy 490013801285 600 Mountain Heights Academy   Regular School Yes High 07 12 2021   grade_12                                                   161                                             161
1364715 1364715 UT     school 4900049 7C Charter Monticello Academy 490004901556 105 Monticello Academy West Point   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364714 1364714 UT     school 4900049 7C Charter Monticello Academy 490004901150 100 Monticello Academy   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364713 1364713 UT     school 4900035 A7 Charter Moab Charter School 490003501085 100 Moab Charter School   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364712 1364712 UT     school 4900131 8E Charter Merit College Preparatory Academy 490013101220 700 Merit College Preparatory Academy   Regular School Yes High 07 12 2021   grade_12                                                   62                                             62
1364711 1364711 UT     school 4900144 4G Charter Maria Montessori Academy 490014401374 100 Maria Montessori Academy   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364710 1364710 UT     school 4900165 4I Charter Mana Academy Charter School 490016501439 700 Mana Academy Charter School   Regular School Yes Other KG 12 2021   grade_12                                                   8                                             8
1364709 1364709 UT     school 4900182 9J Charter Lumen Scholar Institute 490018201467 300 Lumen Scholar Institute   Regular School Yes Other KG 12 2021   grade_12                                                   44                                             44
1364708 1364708 UT     school 4900022 2B Charter Lincoln Academy 490002201082 100 Lincoln Academy   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364707 1364707 UT     school 4900045 5C Charter Legacy Preparatory Academy 490004501146 100 Legacy Preparatory Academy   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364706 1364706 UT     school 4900162 3I Charter Leadership Learning Academy 490016201522 110 Leadership Learning Academy - Ogden   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364705 1364705 UT     school 4900162 3I Charter Leadership Learning Academy 490016201438 100 Leadership Learning Academy   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364704 1364704 UT     school 4900196 3L Charter Leadership Academy of Utah 490019601516 700 Leadership Academy of Utah   Regular School Yes High 06 12 2021   grade_12                                                   44                                             44
1364703 1364703 UT     school 4900043 4C Charter Lakeview Academy 490004301144 100 Lakeview Academy   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364702 1364702 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_12                                                   90                                             90
1364701 1364701 UT     school 4900014 93 Charter John Hancock Charter School 490001400811 105 John Hancock Charter School   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364700 1364700 UT     school 4900139 1G Charter Jefferson Academy 490013901289 100 Jefferson Academy   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364699 1364699 UT     school 4900067 A5 Charter Itineris Early College High 490006700997 700 Itineris Early College High   Regular School Yes High 10 12 2021   grade_12                                                   119                                             119
1364698 1364698 UT     school 4900039 2C Charter Intech Collegiate Academy 490003901129 600 Intech Collegiate Academy   Regular School Yes High 07 12 2021   grade_12                                                   33                                             33
1364697 1364697 UT     school 4900194 5L Charter Ignite Entrepreneurship Academy 490019401509 300 Ignite Entrepreneurship Academy   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364696 1364696 UT     school 4900156 5H Charter Highmark Charter School 490015601415 100 Highmark Charter School   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364695 1364695 UT     school 4900137 8F Charter Hawthorn Academy 490013701298 100 Hawthorn Academy   Regular School Yes Other KG 09 2021   grade_12                                                   0                                             0
1364694 1364694 UT     school 4900137 8F Charter Hawthorn Academy 490013701493 110 Hawthorn Academy South Jordan   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364693 1364693 UT     school 4900072 1E Charter Guadalupe School 490007201174 100 Guadalupe School   Regular School Yes Elementary PK 06 2021   grade_12                                                   0                                             0
1364692 1364692 UT     school 4900177 7J Charter Greenwood Charter School 490017701468 100 Greenwood Charter School   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364691 1364691 UT     school 4900147 8G Charter Good Foundations Academy 490014701389 100 Good Foundations Academy   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364690 1364690 UT     school 4900046 5D Charter George Washington Academy 490004601147 100 George Washington Academy   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364689 1364689 UT     school 4900122 7E Charter Gateway Preparatory Academy 490012201214 100 Gateway Preparatory Academy   Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
1364688 1364688 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006201492 105 Freedom Preparatory Academy - Vineyard   Regular School Yes Elementary PK 05 2021   grade_12                                                   0                                             0
1364687 1364687 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006200992 100 Freedom Preparatory Academy   Regular School Yes Other PK 12 2021   grade_12                                                   37                                             37
1364686 1364686 UT     school 4900187 6K Charter Franklin Discovery Academy 490018701488 100 Franklin Discovery Academy   Regular School Yes Elementary KG 06 2021   grade_12                                                   0                                             0
1364685 1364685 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2021   grade_12                                                   94                                             94
1364684 1364684 UT     school 4900136 7F Charter Excelsior Academy 490013601272 100 Excelsior Academy   Regular School Yes Elementary KG 08 2021   grade_12                                                   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]);