enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 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
1198119 1198119 UT     school 4900037 A9 Charter Success Academy 490003701470 710 Success DSU   Regular School Yes High 10 12 2020   grade_4                                                   0                                             0
1198120 1198120 UT     school 4900037 A9 Charter Success Academy 490003701101 700 Success Academy   Regular School Yes High 09 12 2020   grade_4                                                   0                                             0
1356373 1356373 UT     school 4900037 A9 Charter Success Academy 490003701470 710 Success DSU   Regular School Yes High 10 12 2021   grade_4                                                   0                                             0
1356374 1356374 UT     school 4900037 A9 Charter Success Academy 490003701101 700 Success Academy   Regular School Yes High 09 12 2021   grade_4                                                   0                                             0
1198050 1198050 UT     school 4900036 A8 Charter East Hollywood High 490003601072 700 East Hollywood High   Regular School Yes High 09 12 2020   grade_4                                                   0                                             0
1356302 1356302 UT     school 4900036 A8 Charter East Hollywood High 490003601072 700 East Hollywood High   Regular School Yes High 09 12 2021   grade_4                                                   0                                             0
1198085 1198085 UT     school 4900035 A7 Charter Moab Charter School 490003501085 100 Moab Charter School   Regular School Yes Elementary KG 06 2020   grade_4                                                   8                                             8
1356337 1356337 UT     school 4900035 A7 Charter Moab Charter School 490003501085 100 Moab Charter School   Regular School Yes Elementary KG 06 2021   grade_4                                                   12                                             12
1198094 1198094 UT     school 4900068 A6 Charter North Davis Preparatory Academy 490006800998 100 North Davis Preparatory Academy   Regular School Yes Other KG 09 2020   grade_4                                                   109                                             109
1356348 1356348 UT     school 4900068 A6 Charter North Davis Preparatory Academy 490006800998 100 North Davis Preparatory Academy   Regular School Yes Other KG 09 2021   grade_4                                                   101                                             101
1198071 1198071 UT     school 4900067 A5 Charter Itineris Early College High 490006700997 700 Itineris Early College High   Regular School Yes High 10 12 2020   grade_4                                                   0                                             0
1356323 1356323 UT     school 4900067 A5 Charter Itineris Early College High 490006700997 700 Itineris Early College High   Regular School Yes High 10 12 2021   grade_4                                                   0                                             0
1198121 1198121 UT     school 4900066 A4 Charter Summit Academy 490006601499 310 Summit Academy - Bluffdale   Regular School Yes Elementary KG 06 2020   grade_4                                                   67                                             67
1198122 1198122 UT     school 4900066 A4 Charter Summit Academy 490006600996 100 Summit Academy   Regular School Yes Elementary KG 08 2020   grade_4                                                   116                                             116
1198123 1198123 UT     school 4900066 A4 Charter Summit Academy 490006601469 300 Summit Academy - Independence   Regular School Yes Elementary KG 08 2020   grade_4                                                   108                                             108
1356375 1356375 UT     school 4900066 A4 Charter Summit Academy 490006601499 310 Summit Academy - Bluffdale   Regular School Yes Elementary KG 06 2021   grade_4                                                   53                                             53
1356376 1356376 UT     school 4900066 A4 Charter Summit Academy 490006600996 100 Summit Academy   Regular School Yes Elementary KG 08 2021   grade_4                                                   89                                             89
1356377 1356377 UT     school 4900066 A4 Charter Summit Academy 490006601469 300 Summit Academy - Independence   Regular School Yes Elementary KG 08 2021   grade_4                                                   95                                             95
1198046 1198046 UT     school 4900065 A3 Charter Davinci Academy 490006500995 700 Davinci Academy   Regular School Yes Other KG 12 2020   grade_4                                                   107                                             107
1356298 1356298 UT     school 4900065 A3 Charter Davinci Academy 490006500995 700 Davinci Academy   Regular School Yes Other KG 12 2021   grade_4                                                   106                                             106
1198105 1198105 UT     school 4900064 A2 Charter Ranches Academy 490006400994 100 Ranches Academy   Regular School Yes Elementary KG 06 2020   grade_4                                                   54                                             54
1356359 1356359 UT     school 4900064 A2 Charter Ranches Academy 490006400994 100 Ranches Academy   Regular School Yes Elementary KG 06 2021   grade_4                                                   52                                             52
1198091 1198091 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_4                                                   0                                             0
1198092 1198092 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_4                                                   0                                             0
1356345 1356345 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_4                                                   0                                             0
1356346 1356346 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_4                                                   0                                             0
1198043 1198043 UT     school 4900199 9L Charter Capstone Classical Academy 490019901527 300 Capstone Classical Academy   Regular School Yes High 06 12 2020   grade_4                                                   0                                             0
1198118 1198118 UT     school 4900188 9K Charter St. George Academy 490018801485 700 St. George Academy   Regular School Yes High 08 12 2020   grade_4                                                   0                                             0
1356372 1356372 UT     school 4900188 9K Charter St. George Academy 490018801485 700 St. George Academy   Regular School Yes High 08 12 2021   grade_4                                                   0                                             0
1198081 1198081 UT     school 4900182 9J Charter Lumen Scholar Institute 490018201467 300 Lumen Scholar Institute   Regular School Yes Other KG 12 2020   grade_4                                                   17                                             17
1356333 1356333 UT     school 4900182 9J Charter Lumen Scholar Institute 490018201467 300 Lumen Scholar Institute   Regular School Yes Other KG 12 2021   grade_4                                                   40                                             40
1198135 1198135 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_4                                                   0                                             0
1356389 1356389 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_4                                                   0                                             0
1198087 1198087 UT     school 4900138 9F Charter Mountain Heights Academy 490013801285 600 Mountain Heights Academy   Regular School Yes High 07 12 2020   grade_4                                                   0                                             0
1356340 1356340 UT     school 4900138 9F Charter Mountain Heights Academy 490013801285 600 Mountain Heights Academy   Regular School Yes High 07 12 2021   grade_4                                                   0                                             0
1198103 1198103 UT     school 4900124 9E Charter Providence Hall 490012401202 100 Providence Hall   Regular School Yes Other KG 12 2020   grade_4                                                   131                                             131
1356357 1356357 UT     school 4900124 9E Charter Providence Hall 490012401202 100 Providence Hall   Regular School Yes Other KG 12 2021   grade_4                                                   150                                             150
1198042 1198042 UT     school 4900071 9D Charter Canyon Rim Academy 490007101178 100 Canyon Rim Academy   Regular School Yes Elementary KG 06 2020   grade_4                                                   78                                             78
1356295 1356295 UT     school 4900071 9D Charter Canyon Rim Academy 490007101178 100 Canyon Rim Academy   Regular School Yes Elementary KG 06 2021   grade_4                                                   77                                             77
1198100 1198100 UT     school 4900052 9C Charter Paradigm High School 490005201153 700 Paradigm High School   Regular School Yes High 07 12 2020   grade_4                                                   0                                             0
1356354 1356354 UT     school 4900052 9C Charter Paradigm High School 490005201153 700 Paradigm High School   Regular School Yes High 07 12 2021   grade_4                                                   0                                             0
1198090 1198090 UT     school 4900034 9B Charter Navigator Pointe Academy 490003401088 100 Navigator Pointe Academy   Regular School Yes Other KG 09 2020   grade_4                                                   54                                             54
1356344 1356344 UT     school 4900034 9B Charter Navigator Pointe Academy 490003401088 100 Navigator Pointe Academy   Regular School Yes Other KG 09 2021   grade_4                                                   53                                             53
1198057 1198057 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2020   grade_4                                                   0                                             0
1356309 1356309 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2021   grade_4                                                   0                                             0
1198111 1198111 UT     school 4900018 97 Charter Salt Lake Arts Academy 490001800905 300 Salt Lake Arts Academy   Regular School Yes Middle 05 08 2020   grade_4                                                   0                                             0
1356365 1356365 UT     school 4900018 97 Charter Salt Lake Arts Academy 490001800905 300 Salt Lake Arts Academy   Regular School Yes Middle 05 08 2021   grade_4                                                   0                                             0
1198131 1198131 UT     school 4900016 95 Charter Timpanogos Academy 490001600830 110 Timpanogos Academy   Regular School Yes Elementary KG 06 2020   grade_4                                                   68                                             68
1356385 1356385 UT     school 4900016 95 Charter Timpanogos Academy 490001600830 110 Timpanogos Academy   Regular School Yes Elementary KG 06 2021   grade_4                                                   69                                             69
1198129 1198129 UT     school 4900015 94 Charter Thomas Edison 490001500820 100 Thomas Edison   Regular School Yes Elementary KG 08 2020   grade_4                                                   59                                             59
1198130 1198130 UT     school 4900015 94 Charter Thomas Edison 490001501284 110 Thomas Edison - South   Regular School Yes Elementary KG 08 2020   grade_4                                                   71                                             71
1356383 1356383 UT     school 4900015 94 Charter Thomas Edison 490001500820 100 Thomas Edison   Regular School Yes Elementary KG 08 2021   grade_4                                                   53                                             53
1356384 1356384 UT     school 4900015 94 Charter Thomas Edison 490001501284 110 Thomas Edison - South   Regular School Yes Elementary KG 08 2021   grade_4                                                   70                                             70
1198073 1198073 UT     school 4900014 93 Charter John Hancock Charter School 490001400811 105 John Hancock Charter School   Regular School Yes Elementary KG 06 2020   grade_4                                                   23                                             23
1356325 1356325 UT     school 4900014 93 Charter John Hancock Charter School 490001400811 105 John Hancock Charter School   Regular School Yes Elementary KG 08 2021   grade_4                                                   21                                             21
1198134 1198134 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2020   grade_4                                                   0                                             0
1356388 1356388 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2021   grade_4                                                   0                                             0
1198133 1198133 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_4                                                   0                                             0
1356387 1356387 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_4                                                   0                                             0
1198107 1198107 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_4                                                   0                                             0
1356361 1356361 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_4                                                   0                                             0
1198023 1198023 UT     school 4900186 8K Charter American Academy of Innovation 490018601483 700 American Academy of Innovation   Regular School Yes High 06 12 2020   grade_4                                                   0                                             0
1356275 1356275 UT     school 4900186 8K Charter American Academy of Innovation 490018601483 700 American Academy of Innovation   Regular School Yes High 06 12 2021   grade_4                                                   0                                             0
1198127 1198127 UT     school 4900179 8J Charter Terra Academy 490017901476 300 Terra Academy   Regular School Yes Other KG 12 2020   grade_4                                                   50                                             50
1356381 1356381 UT     school 4900179 8J Charter Terra Academy 490017901476 300 Terra Academy   Regular School Yes Other KG 12 2021   grade_4                                                   50                                             50
1198153 1198153 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2020   grade_4                                                   0                                             0
1356407 1356407 UT     school 4900168 8I Charter Winter Sports School 490016801444 700 Winter Sports School   Regular School Yes High 09 12 2021   grade_4                                                   0                                             0
1198142 1198142 UT     school 4900158 8H Charter Valley Academy 490015801421 100 Valley Academy   Regular School Yes Elementary KG 08 2020   grade_4                                                   60                                             60
1356396 1356396 UT     school 4900158 8H Charter Valley Academy 490015801421 100 Valley Academy   Regular School Yes Elementary KG 08 2021   grade_4                                                   55                                             55
1198063 1198063 UT     school 4900147 8G Charter Good Foundations Academy 490014701389 100 Good Foundations Academy   Regular School Yes Elementary KG 06 2020   grade_4                                                   65                                             65
1356315 1356315 UT     school 4900147 8G Charter Good Foundations Academy 490014701389 100 Good Foundations Academy   Regular School Yes Elementary KG 06 2021   grade_4                                                   62                                             62
1198066 1198066 UT     school 4900137 8F Charter Hawthorn Academy 490013701493 110 Hawthorn Academy South Jordan   Regular School Yes Elementary KG 06 2020   grade_4                                                   90                                             90
1198067 1198067 UT     school 4900137 8F Charter Hawthorn Academy 490013701298 100 Hawthorn Academy   Regular School Yes Other KG 09 2020   grade_4                                                   76                                             76
1356318 1356318 UT     school 4900137 8F Charter Hawthorn Academy 490013701493 110 Hawthorn Academy South Jordan   Regular School Yes Elementary KG 06 2021   grade_4                                                   82                                             82
1356319 1356319 UT     school 4900137 8F Charter Hawthorn Academy 490013701298 100 Hawthorn Academy   Regular School Yes Other KG 09 2021   grade_4                                                   75                                             75
1198084 1198084 UT     school 4900131 8E Charter Merit College Preparatory Academy 490013101220 700 Merit College Preparatory Academy   Regular School Yes High 07 12 2020   grade_4                                                   0                                             0
1356336 1356336 UT     school 4900131 8E Charter Merit College Preparatory Academy 490013101220 700 Merit College Preparatory Academy   Regular School Yes High 07 12 2021   grade_4                                                   0                                             0
1198098 1198098 UT     school 4900118 8D Charter Open Classroom 490011801135 240 Open Classroom   Regular School Yes Elementary KG 08 2020   grade_4                                                   40                                             40
1356352 1356352 UT     school 4900118 8D Charter Open Classroom 490011801135 240 Open Classroom   Regular School Yes Elementary KG 08 2021   grade_4                                                   43                                             43
1198089 1198089 UT     school 4900051 8C Charter Mountainville Academy 490005101152 100 Mountainville Academy   Regular School Yes Other KG 09 2020   grade_4                                                   74                                             74
1356343 1356343 UT     school 4900051 8C Charter Mountainville Academy 490005101152 100 Mountainville Academy   Regular School Yes Other KG 09 2021   grade_4                                                   74                                             74
1198024 1198024 UT     school 4900033 8B Charter American Leadership Academy 490003301056 100 American Leadership Academy   Regular School Yes Other KG 12 2020   grade_4                                                   108                                             108
1356276 1356276 UT     school 4900033 8B Charter American Leadership Academy 490003301056 100 American Leadership Academy   Regular School Yes Other KG 12 2021   grade_4                                                   115                                             115
1198115 1198115 UT     school 4900011 89 Charter Soldier Hollow Charter School 490001100587 100 Soldier Hollow Charter School   Regular School Yes Elementary KG 08 2020   grade_4                                                   43                                             43
1356369 1356369 UT     school 4900011 89 Charter Soldier Hollow Charter School 490001100587 100 Soldier Hollow Charter School   Regular School Yes Elementary PK 08 2021   grade_4                                                   36                                             36
1198045 1198045 UT     school 4900009 87 Charter City Academy 490000900742 700 City Academy   Regular School Yes High 07 12 2020   grade_4                                                   0                                             0
1356297 1356297 UT     school 4900009 87 Charter City Academy 490000900742 700 City Academy   Regular School Yes High 07 12 2021   grade_4                                                   0                                             0
1198101 1198101 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other KG 12 2020   grade_4                                                   28                                             28
1356355 1356355 UT     school 4900008 86 Charter Pinnacle Canyon Academy 490000800629 100 Pinnacle Canyon Academy   Regular School Yes Other PK 12 2021   grade_4                                                   25                                             25
1198022 1198022 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_4                                                   0                                             0
1356273 1356273 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_4                                                   0                                             0
1198059 1198059 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006200992 100 Freedom Preparatory Academy   Regular School Yes Other KG 12 2020   grade_4                                                   111                                             111
1198060 1198060 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006201492 105 Freedom Preparatory Academy - Vineyard   Regular School Yes Elementary KG 05 2020   grade_4                                                   70                                             70
1356311 1356311 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006200992 100 Freedom Preparatory Academy   Regular School Yes Other PK 12 2021   grade_4                                                   118                                             118
1356312 1356312 UT     school 4900062 82 Charter Freedom Preparatory Academy 490006201492 105 Freedom Preparatory Academy - Vineyard   Regular School Yes Elementary PK 05 2021   grade_4                                                   75                                             75
1198147 1198147 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_4                                                   33                                             33
1356401 1356401 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_4                                                   33                                             33
1198132 1198132 UT     school 4900192 7L Charter Treeside Charter School 490019201514 110 Treeside Charter School   Regular School Yes Elementary KG 06 2020   grade_4                                                   65                                             65
1356386 1356386 UT     school 4900192 7L Charter Treeside Charter School 490019201514 110 Treeside Charter School   Regular School Yes Elementary KG 06 2021   grade_4                                                   46                                             46
1198148 1198148 UT     school 4900184 7K Charter Wallace Stegner Academy 490018401489 300 Wallace Stegner Academy   Regular School Yes Elementary KG 08 2020   grade_4                                                   67                                             67

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