enrollments

Data source: Big Local News · About: Big Local

29,176 rows where state = "UT" sorted by district_state_type

✎ 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
1193942 1193942 UT     school 4900034 9B Charter Navigator Pointe Academy 490003401088 100 Navigator Pointe Academy   Regular School Yes Other KG 09 2020   kindergarten                                                   58                                             58
1193943 1193943 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 2020   kindergarten                                                   0                                             0
1193944 1193944 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 2020   kindergarten                                                   0                                             0
1193945 1193945 UT     school 4900048 6D Charter Noah Webster Academy 490004801149 100 Noah Webster Academy   Regular School Yes Elementary KG 06 2020   kindergarten                                                   79                                             79
1193946 1193946 UT     school 4900068 A6 Charter North Davis Preparatory Academy 490006800998 100 North Davis Preparatory Academy   Regular School Yes Other KG 09 2020   kindergarten                                                   100                                             100
1193947 1193947 UT     school 4900025 5B Charter North Star Academy 490002501089 100 North Star Academy   Regular School Yes Other KG 09 2020   kindergarten                                                   50                                             50
1193948 1193948 UT     school 4900021 1C Charter Odyssey Charter School 490002101092 100 Odyssey Charter School   Regular School Yes Elementary KG 06 2020   kindergarten                                                   63                                             63
1193949 1193949 UT     school 4900058 68 Charter Ogden Preparatory Academy 490005800989 100 Ogden Preparatory Academy   Regular School Yes Other KG 09 2020   kindergarten                                                   96                                             96
1193950 1193950 UT     school 4900118 8D Charter Open Classroom 490011801135 240 Open Classroom   Regular School Yes Elementary KG 08 2020   kindergarten                                                   48                                             48
1193951 1193951 UT     school 4900159 7H Charter Pacific Heritage Academy 490015901406 100 Pacific Heritage Academy   Regular School Yes Elementary KG 08 2020   kindergarten                                                   42                                             42
1193952 1193952 UT     school 4900052 9C Charter Paradigm High School 490005201153 700 Paradigm High School   Regular School Yes High 07 12 2020   kindergarten                                                   0                                             0
1193953 1193953 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   kindergarten                                                   23                                             23
1193954 1193954 UT     school 4900157 6H Charter Promontory School of Expeditionary Learning 490015701416 100 Promontory School of Expeditionary Learning   Regular School Yes Elementary KG 08 2020   kindergarten                                                   50                                             50
1193955 1193955 UT     school 4900124 9E Charter Providence Hall 490012401202 100 Providence Hall   Regular School Yes Other KG 12 2020   kindergarten                                                   120                                             120
1193956 1193956 UT     school 4900132 1F Charter Quest Academy 490013201218 100 Quest Academy   Regular School Yes Other KG 09 2020   kindergarten                                                   115                                             115
1193957 1193957 UT     school 4900064 A2 Charter Ranches Academy 490006400994 100 Ranches Academy   Regular School Yes Elementary KG 06 2020   kindergarten                                                   54                                             54
1193958 1193958 UT     school 4900032 7B Charter Reagan Academy 490003201095 100 Reagan Academy   Regular School Yes Elementary KG 08 2020   kindergarten                                                   80                                             80
1193959 1193959 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 2020   kindergarten                                                   0                                             0
1193960 1193960 UT     school 4900038 1D Charter Renaissance Academy 490003801128 100 Renaissance Academy   Regular School Yes Elementary KG 08 2020   kindergarten                                                   92                                             92
1193961 1193961 UT     school 4900125 2F Charter Rockwell Charter High School 490012501199 700 Rockwell Charter High School   Regular School Yes High 07 12 2020   kindergarten                                                   0                                             0
1193962 1193962 UT     school 4900178 3K Charter Roots Charter High School 490017801477 700 Roots Charter High School   Regular School Yes High 09 12 2020   kindergarten                                                   0                                             0
1193963 1193963 UT     school 4900018 97 Charter Salt Lake Arts Academy 490001800905 300 Salt Lake Arts Academy   Regular School Yes Middle 05 08 2020   kindergarten                                                   0                                             0
1193964 1193964 UT     school 4900123 4F Charter Salt Lake Center for Science Education 490012301208 300 Salt Lake Center for Science Education   Regular School Yes High 07 12 2020   kindergarten                                                   0                                             0
1193965 1193965 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 2020   kindergarten                                                   0                                             0
1193966 1193966 UT     school 4900170 6J Charter Scholar Academy 490017001456 100 Scholar Academy   Regular School Yes Elementary KG 08 2020   kindergarten                                                   74                                             74
1193967 1193967 UT     school 4900011 89 Charter Soldier Hollow Charter School 490001100587 100 Soldier Hollow Charter School   Regular School Yes Elementary KG 08 2020   kindergarten                                                   31                                             31
1193968 1193968 UT     school 4900042 3D Charter Spectrum Academy 490004201137 100 Spectrum Academy   Regular School Yes Other KG 12 2020   kindergarten                                                   52                                             52
1193969 1193969 UT     school 4900042 3D Charter Spectrum Academy 490004201464 300 Spectrum Academy - Pleasant Grove   Regular School Yes Other KG 12 2020   kindergarten                                                   42                                             42
1193970 1193970 UT     school 4900188 9K Charter St. George Academy 490018801485 700 St. George Academy   Regular School Yes High 08 12 2020   kindergarten                                                   0                                             0
1193971 1193971 UT     school 4900037 A9 Charter Success Academy 490003701470 710 Success DSU   Regular School Yes High 10 12 2020   kindergarten                                                   0                                             0
1193972 1193972 UT     school 4900037 A9 Charter Success Academy 490003701101 700 Success Academy   Regular School Yes High 09 12 2020   kindergarten                                                   0                                             0
1193973 1193973 UT     school 4900066 A4 Charter Summit Academy 490006601499 310 Summit Academy - Bluffdale   Regular School Yes Elementary KG 06 2020   kindergarten                                                   77                                             77
1193974 1193974 UT     school 4900066 A4 Charter Summit Academy 490006600996 100 Summit Academy   Regular School Yes Elementary KG 08 2020   kindergarten                                                   98                                             98
1193975 1193975 UT     school 4900066 A4 Charter Summit Academy 490006601469 300 Summit Academy - Independence   Regular School Yes Elementary KG 08 2020   kindergarten                                                   90                                             90
1193976 1193976 UT     school 4900148 7G Charter Summit Academy High School 490014801396 700 Summit Academy High School   Regular School Yes High 09 12 2020   kindergarten                                                   0                                             0
1193977 1193977 UT     school 4900044 4D Charter Syracuse Arts Academy 490004401145 100 Syracuse Arts Academy   Regular School Yes Other KG 09 2020   kindergarten                                                   68                                             68
1193978 1193978 UT     school 4900044 4D Charter Syracuse Arts Academy 490004401494 110 Syracuse Arts Academy - North   Regular School Yes Elementary KG 06 2020   kindergarten                                                   109                                             109
1193979 1193979 UT     school 4900179 8J Charter Terra Academy 490017901476 300 Terra Academy   Regular School Yes Other KG 12 2020   kindergarten                                                   50                                             50
1193980 1193980 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   kindergarten                                                   56                                             56
1193981 1193981 UT     school 4900015 94 Charter Thomas Edison 490001500820 100 Thomas Edison   Regular School Yes Elementary KG 08 2020   kindergarten                                                   58                                             58
1193982 1193982 UT     school 4900015 94 Charter Thomas Edison 490001501284 110 Thomas Edison - South   Regular School Yes Elementary KG 08 2020   kindergarten                                                   62                                             62
1193983 1193983 UT     school 4900016 95 Charter Timpanogos Academy 490001600830 110 Timpanogos Academy   Regular School Yes Elementary KG 06 2020   kindergarten                                                   75                                             75
1193984 1193984 UT     school 4900192 7L Charter Treeside Charter School 490019201514 110 Treeside Charter School   Regular School Yes Elementary KG 06 2020   kindergarten                                                   111                                             111
1193985 1193985 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   kindergarten                                                   0                                             0
1193986 1193986 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2020   kindergarten                                                   0                                             0
1193987 1193987 UT     school 4900171 9I Charter Utah Career Path High School 490017101460 600 Utah Career Path High School   Regular School Yes High 09 12 2020   kindergarten                                                   0                                             0
1193988 1193988 UT     school 4900151 2H Charter Utah Connections Academy 490015101386 101 Utah Connections Academy   Regular School Yes Other KG 12 2020   kindergarten                                                   22                                             22
1193989 1193989 UT     school 4900020 1B Charter Utah County Academy of Science 490002001106 700 Utah County Academy of Science   Regular School Yes High 09 12 2020   kindergarten                                                   0                                             0
1193990 1193990 UT     school 4900166 1I Charter Utah International Charter School 490016601433 700 Utah International Charter School   Regular School Yes High 07 12 2020   kindergarten                                                   0                                             0
1193991 1193991 UT     school 4900176 2K Charter Utah Military Academy 490017601463 700 Utah Military Academy   Regular School Yes High 07 12 2020   kindergarten                                                   0                                             0
1193992 1193992 UT     school 4900176 2K Charter Utah Military Academy 490017601501 710 Utah Military Academy - Camp Williams   Regular School Yes High 07 12 2020   kindergarten                                                   0                                             0
1193993 1193993 UT     school 4900130 5F Charter Utah Virtual Academy 490013001196 700 Utah Virtual Academy   Regular School Yes Other KG 12 2020   kindergarten                                                   62                                             62
1193994 1193994 UT     school 4900158 8H Charter Valley Academy 490015801421 100 Valley Academy   Regular School Yes Elementary KG 08 2020   kindergarten                                                   63                                             63
1193995 1193995 UT     school 4900183 1K Charter Vanguard Academy 490018301475 700 Vanguard Academy   Regular School Yes High 07 12 2020   kindergarten                                                   0                                             0
1193996 1193996 UT     school 4900133 3F Charter Venture Academy 490013301216 100 Venture Academy   Regular School Yes Other KG 12 2020   kindergarten                                                   48                                             48
1193997 1193997 UT     school 4900141 2G Charter Vista School 490014101296 100 Vista School   Regular School Yes Elementary KG 08 2020   kindergarten                                                   77                                             77
1193998 1193998 UT     school 4900160 5I Charter Voyage Academy 490016001442 100 Voyage Academy   Regular School Yes Elementary KG 06 2020   kindergarten                                                   73                                             73
1193999 1193999 UT     school 4900061 81 Charter Walden School of Liberal Arts 490006100991 300 Walden School of Liberal Arts   Regular School Yes Other KG 12 2020   kindergarten                                                   34                                             34
1194000 1194000 UT     school 4900184 7K Charter Wallace Stegner Academy 490018401489 300 Wallace Stegner Academy   Regular School Yes Elementary KG 08 2020   kindergarten                                                   85                                             85
1194001 1194001 UT     school 4900024 4B Charter Wasatch Peak Academy 490002401107 100 Wasatch Peak Academy   Regular School Yes Elementary KG 06 2020   kindergarten                                                   48                                             48
1194002 1194002 UT     school 4900185 5K Charter Wasatch Waldorf Charter School 490018501491 300 Wasatch Waldorf Charter School   Regular School Yes Elementary KG 08 2020   kindergarten                                                   65                                             65
1194003 1194003 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2020   kindergarten                                                   33                                             33
1194004 1194004 UT     school 4900145 6G Charter Weilenmann School of Discovery 490014501378 100 Weilenmann School of Discovery   Regular School Yes Elementary KG 08 2020   kindergarten                                                   35                                             35
1194005 1194005 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   kindergarten                                                   0                                             0
1194911 1194911 UT     school 4900017 83 Charter Academy for Math Engineering & Science 490001700904 700 Academy for Math Engineering & Science   Regular School Yes High 09 12 2020   grade_1                                                   0                                             0
1194912 1194912 UT     school 4900186 8K Charter American Academy of Innovation 490018601483 700 American Academy of Innovation   Regular School Yes High 06 12 2020   grade_1                                                   0                                             0
1194913 1194913 UT     school 4900033 8B Charter American Leadership Academy 490003301056 100 American Leadership Academy   Regular School Yes Other KG 12 2020   grade_1                                                   138                                             138
1194914 1194914 UT     school 4900005 74 Charter American Preparatory Academy 490000501404 110 American Preparatory Academy - Accelerated School   Regular School Yes Other KG 12 2020   grade_1                                                   90                                             90
1194915 1194915 UT     school 4900005 74 Charter American Preparatory Academy 490000500801 100 American Preparatory Academy   Regular School Yes Elementary KG 06 2020   grade_1                                                   117                                             117
1194916 1194916 UT     school 4900005 74 Charter American Preparatory Academy 490000501446 130 American Preparatory Academy - Draper #2   Regular School Yes Elementary KG 06 2020   grade_1                                                   168                                             168
1194917 1194917 UT     school 4900005 74 Charter American Preparatory Academy 490000501471 700 American Preparatory Academy - Draper #3   Regular School Yes High 07 12 2020   grade_1                                                   0                                             0
1194918 1194918 UT     school 4900005 74 Charter American Preparatory Academy 490000501520 140 American Preparatory Academy - Salem   Regular School Yes Other KG 09 2020   grade_1                                                   71                                             71
1194919 1194919 UT     school 4900005 74 Charter American Preparatory Academy 490000501372 120 American Preparatory Academy - The School for New Americans   Regular School Yes Elementary KG 06 2020   grade_1                                                   83                                             83
1194920 1194920 UT     school 4900174 2J Charter Ascent Academies of Utah 490017401523 330 Ascent Academies of Utah - West Valley   Regular School Yes Elementary KG 06 2020   grade_1                                                   102                                             102
1194921 1194921 UT     school 4900174 2J Charter Ascent Academies of Utah 490017401453 300 Ascent Academies of Utah Farmington   Regular School Yes Other KG 09 2020   grade_1                                                   43                                             43
1194922 1194922 UT     school 4900174 2J Charter Ascent Academies of Utah 490017401490 320 Ascent Academies of Utah Lehi   Regular School Yes Other KG 09 2020   grade_1                                                   63                                             63
1194923 1194923 UT     school 4900174 2J Charter Ascent Academies of Utah 490017401472 310 Ascent Academies of Utah West Jordan   Regular School Yes Other KG 09 2020   grade_1                                                   84                                             84
1194924 1194924 UT     school 4900181 4K Charter Athenian eAcademy 490018101473 300 Athenian eAcademy   Regular School Yes Other KG 12 2020   grade_1                                                   72                                             72
1194925 1194925 UT     school 4900189 1L Charter Athlos Academy of Utah 490018901503 300 Athlos Academy of Utah   Regular School Yes Elementary KG 08 2020   grade_1                                                   129                                             129
1194926 1194926 UT     school 4900146 3G Charter Bear River Charter School 490014601375 100 Bear River Charter School   Regular School Yes Elementary KG 08 2020   grade_1                                                   20                                             20
1194927 1194927 UT     school 4900023 3B Charter Beehive Science & Technology Academy 490002301060 700 Beehive Science & Technology Academy   Regular School Yes High 06 12 2020   grade_1                                                   0                                             0
1194928 1194928 UT     school 4900195 6L Charter Bonneville Academy 490019501507 300 Bonneville Academy   Regular School Yes Elementary KG 08 2020   grade_1                                                   58                                             58
1194929 1194929 UT     school 4900074 3E Charter C.S. Lewis Academy 490007401190 100 C.S. Lewis Academy   Regular School Yes Elementary KG 06 2020   grade_1                                                   48                                             48
1194930 1194930 UT     school 4900143 5G Charter Canyon Grove Academy 490014301376 100 Canyon Grove Academy   Regular School Yes Elementary KG 08 2020   grade_1                                                   95                                             95
1194931 1194931 UT     school 4900071 9D Charter Canyon Rim Academy 490007101178 100 Canyon Rim Academy   Regular School Yes Elementary KG 06 2020   grade_1                                                   78                                             78
1194932 1194932 UT     school 4900199 9L Charter Capstone Classical Academy 490019901527 300 Capstone Classical Academy   Regular School Yes High 06 12 2020   grade_1                                                   0                                             0
1194933 1194933 UT     school 4900040 2D Charter Channing Hall 490004001130 100 Channing Hall   Regular School Yes Elementary KG 08 2020   grade_1                                                   77                                             77
1194934 1194934 UT     school 4900009 87 Charter City Academy 490000900742 700 City Academy   Regular School Yes High 07 12 2020   grade_1                                                   0                                             0
1194935 1194935 UT     school 4900065 A3 Charter Davinci Academy 490006500995 700 Davinci Academy   Regular School Yes Other KG 12 2020   grade_1                                                   126                                             126
1194936 1194936 UT     school 4900169 3J Charter Dixie Montessori Academy 490016901452 100 Dixie Montessori Academy   Regular School Yes Elementary KG 07 2020   grade_1                                                   45                                             45
1194937 1194937 UT     school 4900073 4E Charter Dual Immersion Academy 490007301187 100 Dual Immersion Academy   Regular School Yes Elementary KG 08 2020   grade_1                                                   53                                             53
1194938 1194938 UT     school 4900140 6F Charter Early Light Academy at Daybreak 490014001268 300 Early Light Academy at Daybreak   Regular School Yes Other KG 09 2020   grade_1                                                   99                                             99
1194939 1194939 UT     school 4900036 A8 Charter East Hollywood High 490003601072 700 East Hollywood High   Regular School Yes High 09 12 2020   grade_1                                                   0                                             0
1194940 1194940 UT     school 4900070 5E Charter Edith Bowen Laboratory School 490007001176 108 Edith Bowen Laboratory School   Regular School Yes Elementary KG 06 2020   grade_1                                                   48                                             48
1194941 1194941 UT     school 4900155 3H Charter Endeavor Hall 490015501407 100 Endeavor Hall   Regular School Yes Elementary KG 06 2020   grade_1                                                   56                                             56
1194942 1194942 UT     school 4900041 3C Charter Entheos Academy 490004101136 100 Entheos Academy   Regular School Yes Elementary KG 08 2020   grade_1                                                   73                                             73
1194943 1194943 UT     school 4900041 3C Charter Entheos Academy 490004101437 110 Entheos Academy Magna   Regular School Yes Elementary KG 08 2020   grade_1                                                   56                                             56
1194944 1194944 UT     school 4900161 2I Charter Esperanza School 490016101440 100 Esperanza School   Regular School Yes Elementary KG 06 2020   grade_1                                                   80                                             80
1194945 1194945 UT     school 4900136 7F Charter Excelsior Academy 490013601272 100 Excelsior Academy   Regular School Yes Elementary KG 08 2020   grade_1                                                   145                                             145
1194946 1194946 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2020   grade_1                                                   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]);