enrollments

Data source: Big Local News · About: Big Local

2,084 rows where grade = "grade_7" and state = "UT" sorted by district_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 2,084 ✖
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
1201230 1201230 UT     school 4900037 A9 Charter Success Academy 490003701470 710 Success DSU   Regular School Yes High 10 12 2020   grade_7                                                   0                                             0
1201231 1201231 UT     school 4900037 A9 Charter Success Academy 490003701101 700 Success Academy   Regular School Yes High 09 12 2020   grade_7                                                   0                                             0
1359514 1359514 UT     school 4900037 A9 Charter Success Academy 490003701470 710 Success DSU   Regular School Yes High 10 12 2021   grade_7                                                   0                                             0
1359515 1359515 UT     school 4900037 A9 Charter Success Academy 490003701101 700 Success Academy   Regular School Yes High 09 12 2021   grade_7                                                   0                                             0
1201161 1201161 UT     school 4900036 A8 Charter East Hollywood High 490003601072 700 East Hollywood High   Regular School Yes High 09 12 2020   grade_7                                                   0                                             0
1359443 1359443 UT     school 4900036 A8 Charter East Hollywood High 490003601072 700 East Hollywood High   Regular School Yes High 09 12 2021   grade_7                                                   0                                             0
1201196 1201196 UT     school 4900035 A7 Charter Moab Charter School 490003501085 100 Moab Charter School   Regular School Yes Elementary KG 06 2020   grade_7                                                   0                                             0
1359478 1359478 UT     school 4900035 A7 Charter Moab Charter School 490003501085 100 Moab Charter School   Regular School Yes Elementary KG 06 2021   grade_7                                                   0                                             0
1201205 1201205 UT     school 4900068 A6 Charter North Davis Preparatory Academy 490006800998 100 North Davis Preparatory Academy   Regular School Yes Other KG 09 2020   grade_7                                                   96                                             96
1359489 1359489 UT     school 4900068 A6 Charter North Davis Preparatory Academy 490006800998 100 North Davis Preparatory Academy   Regular School Yes Other KG 09 2021   grade_7                                                   92                                             92
1201182 1201182 UT     school 4900067 A5 Charter Itineris Early College High 490006700997 700 Itineris Early College High   Regular School Yes High 10 12 2020   grade_7                                                   0                                             0
1359464 1359464 UT     school 4900067 A5 Charter Itineris Early College High 490006700997 700 Itineris Early College High   Regular School Yes High 10 12 2021   grade_7                                                   0                                             0
1201232 1201232 UT     school 4900066 A4 Charter Summit Academy 490006601499 310 Summit Academy - Bluffdale   Regular School Yes Elementary KG 06 2020   grade_7                                                   0                                             0
1201233 1201233 UT     school 4900066 A4 Charter Summit Academy 490006600996 100 Summit Academy   Regular School Yes Elementary KG 08 2020   grade_7                                                   107                                             107
1201234 1201234 UT     school 4900066 A4 Charter Summit Academy 490006601469 300 Summit Academy - Independence   Regular School Yes Elementary KG 08 2020   grade_7                                                   134                                             134
1359516 1359516 UT     school 4900066 A4 Charter Summit Academy 490006601499 310 Summit Academy - Bluffdale   Regular School Yes Elementary KG 06 2021   grade_7                                                   0                                             0
1359517 1359517 UT     school 4900066 A4 Charter Summit Academy 490006600996 100 Summit Academy   Regular School Yes Elementary KG 08 2021   grade_7                                                   81                                             81
1359518 1359518 UT     school 4900066 A4 Charter Summit Academy 490006601469 300 Summit Academy - Independence   Regular School Yes Elementary KG 08 2021   grade_7                                                   119                                             119
1201157 1201157 UT     school 4900065 A3 Charter Davinci Academy 490006500995 700 Davinci Academy   Regular School Yes Other KG 12 2020   grade_7                                                   97                                             97
1359439 1359439 UT     school 4900065 A3 Charter Davinci Academy 490006500995 700 Davinci Academy   Regular School Yes Other KG 12 2021   grade_7                                                   124                                             124
1201216 1201216 UT     school 4900064 A2 Charter Ranches Academy 490006400994 100 Ranches Academy   Regular School Yes Elementary KG 06 2020   grade_7                                                   0                                             0
1359500 1359500 UT     school 4900064 A2 Charter Ranches Academy 490006400994 100 Ranches Academy   Regular School Yes Elementary KG 06 2021   grade_7                                                   0                                             0
1201202 1201202 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   grade_7                                                   0                                             0
1201203 1201203 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   grade_7                                                   0                                             0
1359486 1359486 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_7                                                   0                                             0
1359487 1359487 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_7                                                   0                                             0
1201154 1201154 UT     school 4900199 9L Charter Capstone Classical Academy 490019901527 300 Capstone Classical Academy   Regular School Yes High 06 12 2020   grade_7                                                   38                                             38
1201229 1201229 UT     school 4900188 9K Charter St. George Academy 490018801485 700 St. George Academy   Regular School Yes High 08 12 2020   grade_7                                                   0                                             0
1359513 1359513 UT     school 4900188 9K Charter St. George Academy 490018801485 700 St. George Academy   Regular School Yes High 08 12 2021   grade_7                                                   0                                             0
1201192 1201192 UT     school 4900182 9J Charter Lumen Scholar Institute 490018201467 300 Lumen Scholar Institute   Regular School Yes Other KG 12 2020   grade_7                                                   27                                             27
1359474 1359474 UT     school 4900182 9J Charter Lumen Scholar Institute 490018201467 300 Lumen Scholar Institute   Regular School Yes Other KG 12 2021   grade_7                                                   53                                             53
1201246 1201246 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_7                                                   0                                             0
1359530 1359530 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_7                                                   0                                             0
1201198 1201198 UT     school 4900138 9F Charter Mountain Heights Academy 490013801285 600 Mountain Heights Academy   Regular School Yes High 07 12 2020   grade_7                                                   64                                             64
1359481 1359481 UT     school 4900138 9F Charter Mountain Heights Academy 490013801285 600 Mountain Heights Academy   Regular School Yes High 07 12 2021   grade_7                                                   155                                             155
1201214 1201214 UT     school 4900124 9E Charter Providence Hall 490012401202 100 Providence Hall   Regular School Yes Other KG 12 2020   grade_7                                                   212                                             212
1359498 1359498 UT     school 4900124 9E Charter Providence Hall 490012401202 100 Providence Hall   Regular School Yes Other KG 12 2021   grade_7                                                   195                                             195
1201153 1201153 UT     school 4900071 9D Charter Canyon Rim Academy 490007101178 100 Canyon Rim Academy   Regular School Yes Elementary KG 06 2020   grade_7                                                   0                                             0
1359436 1359436 UT     school 4900071 9D Charter Canyon Rim Academy 490007101178 100 Canyon Rim Academy   Regular School Yes Elementary KG 06 2021   grade_7                                                   0                                             0
1201211 1201211 UT     school 4900052 9C Charter Paradigm High School 490005201153 700 Paradigm High School   Regular School Yes High 07 12 2020   grade_7                                                   44                                             44
1359495 1359495 UT     school 4900052 9C Charter Paradigm High School 490005201153 700 Paradigm High School   Regular School Yes High 07 12 2021   grade_7                                                   28                                             28
1201201 1201201 UT     school 4900034 9B Charter Navigator Pointe Academy 490003401088 100 Navigator Pointe Academy   Regular School Yes Other KG 09 2020   grade_7                                                   39                                             39
1359485 1359485 UT     school 4900034 9B Charter Navigator Pointe Academy 490003401088 100 Navigator Pointe Academy   Regular School Yes Other KG 09 2021   grade_7                                                   26                                             26
1201168 1201168 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2020   grade_7                                                   0                                             0
1359450 1359450 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2021   grade_7                                                   0                                             0
1201222 1201222 UT     school 4900018 97 Charter Salt Lake Arts Academy 490001800905 300 Salt Lake Arts Academy   Regular School Yes Middle 05 08 2020   grade_7                                                   101                                             101
1359506 1359506 UT     school 4900018 97 Charter Salt Lake Arts Academy 490001800905 300 Salt Lake Arts Academy   Regular School Yes Middle 05 08 2021   grade_7                                                   102                                             102
1201242 1201242 UT     school 4900016 95 Charter Timpanogos Academy 490001600830 110 Timpanogos Academy   Regular School Yes Elementary KG 06 2020   grade_7                                                   0                                             0
1359526 1359526 UT     school 4900016 95 Charter Timpanogos Academy 490001600830 110 Timpanogos Academy   Regular School Yes Elementary KG 06 2021   grade_7                                                   0                                             0
1201240 1201240 UT     school 4900015 94 Charter Thomas Edison 490001500820 100 Thomas Edison   Regular School Yes Elementary KG 08 2020   grade_7                                                   61                                             61
1201241 1201241 UT     school 4900015 94 Charter Thomas Edison 490001501284 110 Thomas Edison - South   Regular School Yes Elementary KG 08 2020   grade_7                                                   75                                             75
1359524 1359524 UT     school 4900015 94 Charter Thomas Edison 490001500820 100 Thomas Edison   Regular School Yes Elementary KG 08 2021   grade_7                                                   59                                             59
1359525 1359525 UT     school 4900015 94 Charter Thomas Edison 490001501284 110 Thomas Edison - South   Regular School Yes Elementary KG 08 2021   grade_7                                                   78                                             78
1201184 1201184 UT     school 4900014 93 Charter John Hancock Charter School 490001400811 105 John Hancock Charter School   Regular School Yes Elementary KG 06 2020   grade_7                                                   0                                             0
1359466 1359466 UT     school 4900014 93 Charter John Hancock Charter School 490001400811 105 John Hancock Charter School   Regular School Yes Elementary KG 08 2021   grade_7                                                   12                                             12
1201245 1201245 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2020   grade_7                                                   0                                             0
1359529 1359529 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2021   grade_7                                                   0                                             0
1201244 1201244 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_7                                                   0                                             0
1359528 1359528 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_7                                                   0                                             0
1201218 1201218 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   grade_7                                                   0                                             0
1359502 1359502 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_7                                                   0                                             0
1201134 1201134 UT     school 4900186 8K Charter American Academy of Innovation 490018601483 700 American Academy of Innovation   Regular School Yes High 06 12 2020   grade_7                                                   52                                             52
1359416 1359416 UT     school 4900186 8K Charter American Academy of Innovation 490018601483 700 American Academy of Innovation   Regular School Yes High 06 12 2021   grade_7                                                   67                                             67
1201238 1201238 UT     school 4900179 8J Charter Terra Academy 490017901476 300 Terra Academy   Regular School Yes Other KG 12 2020   grade_7                                                   50                                             50
1359522 1359522 UT     school 4900179 8J Charter Terra Academy 490017901476 300 Terra Academy   Regular School Yes Other KG 12 2021   grade_7                                                   50                                             50
1201264 1201264 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_7                                                   0                                             0
1359548 1359548 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_7                                                   0                                             0
1201253 1201253 UT     school 4900158 8H Charter Valley Academy 490015801421 100 Valley Academy   Regular School Yes Elementary KG 08 2020   grade_7                                                   31                                             31
1359537 1359537 UT     school 4900158 8H Charter Valley Academy 490015801421 100 Valley Academy   Regular School Yes Elementary KG 08 2021   grade_7                                                   43                                             43
1201174 1201174 UT     school 4900147 8G Charter Good Foundations Academy 490014701389 100 Good Foundations Academy   Regular School Yes Elementary KG 06 2020   grade_7                                                   0                                             0
1359456 1359456 UT     school 4900147 8G Charter Good Foundations Academy 490014701389 100 Good Foundations Academy   Regular School Yes Elementary KG 06 2021   grade_7                                                   0                                             0
1201177 1201177 UT     school 4900137 8F Charter Hawthorn Academy 490013701493 110 Hawthorn Academy South Jordan   Regular School Yes Elementary KG 06 2020   grade_7                                                   0                                             0
1201178 1201178 UT     school 4900137 8F Charter Hawthorn Academy 490013701298 100 Hawthorn Academy   Regular School Yes Other KG 09 2020   grade_7                                                   99                                             99
1359459 1359459 UT     school 4900137 8F Charter Hawthorn Academy 490013701493 110 Hawthorn Academy South Jordan   Regular School Yes Elementary KG 06 2021   grade_7                                                   0                                             0
1359460 1359460 UT     school 4900137 8F Charter Hawthorn Academy 490013701298 100 Hawthorn Academy   Regular School Yes Other KG 09 2021   grade_7                                                   103                                             103
1201195 1201195 UT     school 4900131 8E Charter Merit College Preparatory Academy 490013101220 700 Merit College Preparatory Academy   Regular School Yes High 07 12 2020   grade_7                                                   67                                             67
1359477 1359477 UT     school 4900131 8E Charter Merit College Preparatory Academy 490013101220 700 Merit College Preparatory Academy   Regular School Yes High 07 12 2021   grade_7                                                   58                                             58
1201209 1201209 UT     school 4900118 8D Charter Open Classroom 490011801135 240 Open Classroom   Regular School Yes Elementary KG 08 2020   grade_7                                                   26                                             26
1359493 1359493 UT     school 4900118 8D Charter Open Classroom 490011801135 240 Open Classroom   Regular School Yes Elementary KG 08 2021   grade_7                                                   35                                             35
1201200 1201200 UT     school 4900051 8C Charter Mountainville Academy 490005101152 100 Mountainville Academy   Regular School Yes Other KG 09 2020   grade_7                                                   39                                             39
1359484 1359484 UT     school 4900051 8C Charter Mountainville Academy 490005101152 100 Mountainville Academy   Regular School Yes Other KG 09 2021   grade_7                                                   38                                             38
1201135 1201135 UT     school 4900033 8B Charter American Leadership Academy 490003301056 100 American Leadership Academy   Regular School Yes Other KG 12 2020   grade_7                                                   143                                             143
1359417 1359417 UT     school 4900033 8B Charter American Leadership Academy 490003301056 100 American Leadership Academy   Regular School Yes Other KG 12 2021   grade_7                                                   136                                             136
1201226 1201226 UT     school 4900011 89 Charter Soldier Hollow Charter School 490001100587 100 Soldier Hollow Charter School   Regular School Yes Elementary KG 08 2020   grade_7                                                   27                                             27
1359510 1359510 UT     school 4900011 89 Charter Soldier Hollow Charter School 490001100587 100 Soldier Hollow Charter School   Regular School Yes Elementary PK 08 2021   grade_7                                                   30                                             30
1201156 1201156 UT     school 4900009 87 Charter City Academy 490000900742 700 City Academy   Regular School Yes High 07 12 2020   grade_7                                                   16                                             16
1359438 1359438 UT     school 4900009 87 Charter City Academy 490000900742 700 City Academy   Regular School Yes High 07 12 2021   grade_7                                                   18                                             18
1201212 1201212 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   grade_7                                                   46                                             46
1359496 1359496 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_7                                                   37                                             37
1201133 1201133 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_7                                                   0                                             0
1359414 1359414 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_7                                                   0                                             0
1201170 1201170 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006200992 100 Freedom Preparatory Academy   Regular School Yes Other KG 12 2020   grade_7                                                   160                                             160
1201171 1201171 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006201492 105 Freedom Preparatory Academy - Vineyard   Regular School Yes Elementary KG 05 2020   grade_7                                                   0                                             0
1359452 1359452 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006200992 100 Freedom Preparatory Academy   Regular School Yes Other PK 12 2021   grade_7                                                   182                                             182
1359453 1359453 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006201492 105 Freedom Preparatory Academy - Vineyard   Regular School Yes Elementary PK 05 2021   grade_7                                                   0                                             0
1201258 1201258 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_7                                                   30                                             30
1359542 1359542 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_7                                                   33                                             33
1201243 1201243 UT     school 4900192 7L Charter Treeside Charter School 490019201514 110 Treeside Charter School   Regular School Yes Elementary KG 06 2020   grade_7                                                   0                                             0
1359527 1359527 UT     school 4900192 7L Charter Treeside Charter School 490019201514 110 Treeside Charter School   Regular School Yes Elementary KG 06 2021   grade_7                                                   0                                             0
1201259 1201259 UT     school 4900184 7K Charter Wallace Stegner Academy 490018401489 300 Wallace Stegner Academy   Regular School Yes Elementary KG 08 2020   grade_7                                                   68                                             68

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