Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_9 · 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
1202303 UT     school 4900030 01 District Alpine District 490003000001 104 Alpine School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202306 UT     school 4900030 01 District Alpine District 490003000740 105 Aspen School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202307 UT     school 4900030 01 District Alpine District 490003000004 106 Barratt School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202308 UT     school 4900030 01 District Alpine District 490003001545 114 Belmont School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202309 UT     school 4900030 01 District Alpine District 490003001461 115 Black Ridge School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202310 UT     school 4900030 01 District Alpine District 490003000005 107 Bonneville School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202311 UT     school 4900030 01 District Alpine District 490003001547 203 Brookhaven School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202313 UT     school 4900030 01 District Alpine District 490003000006 108 Cascade School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202314 UT     school 4900030 01 District Alpine District 490003000440 111 Cedar Ridge School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202317 UT     school 4900030 01 District Alpine District 490003001573 226 Centennial Elementary   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202318 UT     school 4900030 01 District Alpine District 490003000008 116 Central School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202319 UT     school 4900030 01 District Alpine District 490003000009 118 Cherry Hill School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202320 UT     school 4900030 01 District Alpine District 490003000014 840 Dan W. Peterson   Special Education School No Other PK 12 2020   grade_9                                                   8                                             8
1202321 UT     school 4900030 01 District Alpine District 490003000757 119 Deerfield School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202322 UT     school 4900030 01 District Alpine District 490003001462 183 Dry Creek School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202323 UT     school 4900030 01 District Alpine District 490003001071 121 Eagle Valley School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202324 UT     school 4900030 01 District Alpine District 490003000444 120 Eaglecrest School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202325 UT     school 4900030 01 District Alpine District 490003000593 123 Foothill School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202327 UT     school 4900030 01 District Alpine District 490003001111 126 Fox Hollow School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202328 UT     school 4900030 01 District Alpine District 490003000908 125 Freedom School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202330 UT     school 4900030 01 District Alpine District 490003000011 128 Geneva School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202331 UT     school 4900030 01 District Alpine District 490003000012 132 Greenwood School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202332 UT     school 4900030 01 District Alpine District 490003000013 136 Grovecrest School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202333 UT     school 4900030 01 District Alpine District 490003001112 138 Harvest School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202334 UT     school 4900030 01 District Alpine District 490003001200 139 Hidden Hollow School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202335 UT     school 4900030 01 District Alpine District 490003000672 140 Highland School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202336 UT     school 4900030 01 District Alpine District 490003001419 808 Horizon School   Special Education School No Other PK 12 2020   grade_9                                                   4                                             4
1202339 UT     school 4900030 01 District Alpine District 490003000228 146 Legacy School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202342 UT     school 4900030 01 District Alpine District 490003000019 148 Lehi School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202344 UT     school 4900030 01 District Alpine District 490003000020 156 Lindon School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202346 UT     school 4900030 01 District Alpine District 490003000743 160 Manila School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202347 UT     school 4900030 01 District Alpine District 490003000744 154 Meadow School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202348 UT     school 4900030 01 District Alpine District 490003000696 161 Mount Mahogany School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202350 UT     school 4900030 01 District Alpine District 490003001381 205 Mountain Trails School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202352 UT     school 4900030 01 District Alpine District 490003001299 150 North Point School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202353 UT     school 4900030 01 District Alpine District 490003000647 155 Northridge School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202355 UT     school 4900030 01 District Alpine District 490003000791 151 Orchard School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202358 UT     school 4900030 01 District Alpine District 490003000023 157 Orem School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202363 UT     school 4900030 01 District Alpine District 490003000907 153 Pony Express School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202364 UT     school 4900030 01 District Alpine District 490003001113 165 Ridgeline School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202365 UT     school 4900030 01 District Alpine District 490003001481 201 River Rock School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202366 UT     school 4900030 01 District Alpine District 490003001405 219 Riverview School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202367 UT     school 4900030 01 District Alpine District 490003000349 162 Rocky Mountain School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202368 UT     school 4900030 01 District Alpine District 490003001320 167 Sage Hills School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202369 UT     school 4900030 01 District Alpine District 490003001099 163 Saratoga Shores School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202370 UT     school 4900030 01 District Alpine District 490003000027 164 Sego Lily School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202371 UT     school 4900030 01 District Alpine District 490003000028 168 Sharon School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202372 UT     school 4900030 01 District Alpine District 490003000029 170 Shelley School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202374 UT     school 4900030 01 District Alpine District 490003000699 172 Snow Springs School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202375 UT     school 4900030 01 District Alpine District 490003001515 202 Springside School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202377 UT     school 4900030 01 District Alpine District 490003000844 174 Suncrest School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202378 UT     school 4900030 01 District Alpine District 490003001413 256 Thunder Ridge School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202381 UT     school 4900030 01 District Alpine District 490003001385 258 Traverse Mountain School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202382 UT     school 4900030 01 District Alpine District 490003000031 176 Valley View School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202383 UT     school 4900030 01 District Alpine District 490003000032 177 Vineyard School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202385 UT     school 4900030 01 District Alpine District 490003000704 180 Westfield School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202387 UT     school 4900030 01 District Alpine District 490003000034 178 Westmore School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202389 UT     school 4900030 01 District Alpine District 490003000035 182 Windsor School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202391 UT     school 4900060 02 District Beaver District 490006001257 100 Beaver Preschool   Special Education School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
1202403 UT     school 4900090 03 District Box Elder District 490009000123 125 Discovery School   Regular School No Elementary PK 05 2020   grade_9                                                   0                                             0
1202404 UT     school 4900090 03 District Box Elder District 490009000051 132 Fielding School   Regular School No Elementary PK 05 2020   grade_9                                                   0                                             0
1202411 UT     school 4900090 03 District Box Elder District 490009000060 164 McKinley School   Regular School No Elementary PK 05 2020   grade_9                                                   0                                             0
1202420 UT     school 4900090 03 District Box Elder District 490009000069 200 Willard School   Regular School No Elementary PK 01 2020   grade_9                                                   0                                             0
1202422 UT     school 4900120 04 District Cache District 490012001392 106 Birch Creek School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202424 UT     school 4900120 04 District Cache District 490012001251 600 Cache Preschool   Special Education School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
1202425 UT     school 4900120 04 District Cache District 490012001064 109 Canyon School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202428 UT     school 4900120 04 District Cache District 490012000139 118 Greenville School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202429 UT     school 4900120 04 District Cache District 490012001379 120 Heritage School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202430 UT     school 4900120 04 District Cache District 490012000076 124 Lewiston School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202432 UT     school 4900120 04 District Cache District 490012000674 132 Millville School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202434 UT     school 4900120 04 District Cache District 490012001227 130 Mountainside School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202435 UT     school 4900120 04 District Cache District 490012000598 140 Nibley School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202437 UT     school 4900120 04 District Cache District 490012000079 144 North Park School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202440 UT     school 4900120 04 District Cache District 490012000082 160 River Heights School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202444 UT     school 4900120 04 District Cache District 490012000085 164 Summit School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202447 UT     school 4900120 04 District Cache District 490012000080 152 White Pine School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202488 UT     school 4900142 42 District Canyons District 490014200321 156 Sandy School   Regular School No Elementary PK 05 2020   grade_9                                                   0                                             0
1202491 UT     school 4900142 42 District Canyons District 490014201309 800 Special Ed Preschool   Special Education School No Prekindergarten PK PK 2020   grade_9                                                   0                                             0
1202497 UT     school 4900150 05 District Carbon District 490015001209 110 Bruin Point School   Regular School No Elementary PK 05 2020   grade_9                                                   0                                             0
1202500 UT     school 4900150 05 District Carbon District 490015000088 801 Castle Valley Center   Special Education School No Other PK 12 2020   grade_9                                                   1                                             1
1202501 UT     school 4900150 05 District Carbon District 490015000821 114 Creekview School   Regular School No Elementary PK 05 2020   grade_9                                                   0                                             0
1202504 UT     school 4900150 05 District Carbon District 490015000097 120 Sally Mauro School   Regular School No Elementary PK 05 2020   grade_9                                                   0                                             0
1202505 UT     school 4900150 05 District Carbon District 490015000098 154 Wellington School   Regular School No Elementary PK 05 2020   grade_9                                                   0                                             0
1202508 UT     school 4900180 06 District Daggett District 490018000102 112 Manila School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202509 UT     school 4900210 07 District Davis District 490021000793 102 Adams School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202510 UT     school 4900210 07 District Davis District 490021000103 104 Adelaide School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202511 UT     school 4900210 07 District Davis District 490021000869 106 Antelope School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202512 UT     school 4900210 07 District Davis District 490021000649 153 Bluff Ridge School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202513 UT     school 4900210 07 District Davis District 490021000104 108 Boulton School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202517 UT     school 4900210 07 District Davis District 490021001221 113 Buffalo Point School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202518 UT     school 4900210 07 District Davis District 490021001511 169 Canyon Creek School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202521 UT     school 4900210 07 District Davis District 490021000110 116 Centerville School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202524 UT     school 4900210 07 District Davis District 490021000113 120 Clinton School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202525 UT     school 4900210 07 District Davis District 490021000748 131 Columbia School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202526 UT     school 4900210 07 District Davis District 490021000676 122 Cook School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202527 UT     school 4900210 07 District Davis District 490021000648 151 Creekside School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202528 UT     school 4900210 07 District Davis District 490021000114 124 Crestview School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202530 UT     school 4900210 07 District Davis District 490021000118 128 Doxey School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202531 UT     school 4900210 07 District Davis District 490021000134 148 Eagle Bay School   Regular School No Elementary PK 06 2020   grade_9                                                   0                                             0
1202532 UT     school 4900210 07 District Davis District 490021000708 129 East Layton School   Regular School No Elementary PK 06 2020   grade_9                                                   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]);