Data source: Big Local News · About: Big Local

2,084 rows where grade = "kindergarten" and state = "UT" sorted by ccd_school_high_grade descending

View and edit SQL

year

grade

  • kindergarten · 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
1193058 UT     school 4900060 02 District Beaver District 490006001257 100 Beaver Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193091 UT     school 4900120 04 District Cache District 490012001251 600 Cache Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193158 UT     school 4900142 42 District Canyons District 490014201309 800 Special Ed Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193203 UT     school 4900210 07 District Davis District 490021000727 802 Family Enrichment Center   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193300 UT     school 4900330 11 District Grand District 490033001236 801 C R Sundwall Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193404 UT     school 4900390 13 District Iron District 490039001240 150 Iron County Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193409 UT     school 4900390 13 District Iron District 490039001238 160 Three Peaks Pre School   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193481 UT     school 4900480 16 District Kane District 490048001258 100 Kane Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193490 UT     school 4900510 39 District Logan City District 490051001530 114 Logan Early Childhood Center   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193493 UT     school 4900510 39 District Logan City District 490051001234 113 Riverside Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193507 UT     school 4900570 18 District Morgan District 490057001260 100 Morgan Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193511 UT     school 4900600 40 District Murray District 490060001248 140 Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193577 UT     school 4900690 21 District North Summit District 490069001254 100 North Summit Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193594 UT     school 4900720 37 District Ogden City District 490072001232 100 Ogden Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193600 UT     school 4900750 22 District Park City District 490075001423 158 Jeremy Ranch Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193603 UT     school 4900750 22 District Park City District 490075001255 150 MPES Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193605 UT     school 4900750 22 District Park City District 490075001409 154 Parley's Park Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193607 UT     school 4900750 22 District Park City District 490075001410 156 Trailside Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193610 UT     school 4900780 23 District Piute District 490078001261 101 Circleville Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193612 UT     school 4900780 23 District Piute District 490078001262 102 Oscarson Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193631 UT     school 4900810 38 District Provo District 490081001233 641 Sunrise Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193640 UT     school 4900840 24 District Rich District 490084001264 150 Rich Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193676 UT     school 4900870 36 District Salt Lake District 490087001230 292 Salt Lake Head Start   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193703 UT     school 4900930 26 District Sevier District 490093000495 820 Richfield Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193731 UT     school 4901050 30 District Tooele District 490105001246 101 Early Learning Center   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193762 UT     school 4901080 31 District Uintah District 490108001247 810 Uintah Specialized Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193819 UT     school 4901140 33 District Washington District 490114000778 220 Washington Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193830 UT     school 4901200 35 District Weber District 490120001249 179 Canyon View Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1351263 UT     school 4900060 02 District Beaver District 490006001257 100 Beaver Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351293 UT     school 4900120 04 District Cache District 490012001251 600 Cache Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351360 UT     school 4900142 42 District Canyons District 490014201309 800 Special Ed Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351407 UT     school 4900210 07 District Davis District 490021000727 802 Family Enrichment Center   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351504 UT     school 4900330 11 District Grand District 490033001236 801 C R Sundwall Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351606 UT     school 4900390 13 District Iron District 490039001240 150 Iron County Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351612 UT     school 4900390 13 District Iron District 490039001238 160 Three Peaks Pre School   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351652 UT     school 4900420 14 District Jordan District 490042001243 800 Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351686 UT     school 4900480 16 District Kane District 490048001258 100 Kane Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351696 UT     school 4900510 39 District Logan City District 490051001530 114 Logan Early Childhood Center   Regular School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351699 UT     school 4900510 39 District Logan City District 490051001234 113 Riverside Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351713 UT     school 4900570 18 District Morgan District 490057001260 100 Morgan Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351716 UT     school 4900570 18 District Morgan District 490057001567 101 Mountain Green Preschool   Regular School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351718 UT     school 4900600 40 District Murray District 490060001248 140 Early Childhood Center   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351785 UT     school 4900690 21 District North Summit District 490069001254 100 North Summit Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351811 UT     school 4900750 22 District Park City District 490075001423 158 Jeremy Ranch Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351814 UT     school 4900750 22 District Park City District 490075001255 150 MPES Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351816 UT     school 4900750 22 District Park City District 490075001409 154 Parley's Park Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351818 UT     school 4900750 22 District Park City District 490075001410 156 Trailside Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351821 UT     school 4900780 23 District Piute District 490078001261 101 Circleville Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351823 UT     school 4900780 23 District Piute District 490078001262 102 Oscarson Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351842 UT     school 4900810 38 District Provo District 490081001233 641 Sunrise Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351851 UT     school 4900840 24 District Rich District 490084001264 150 Rich Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351887 UT     school 4900870 36 District Salt Lake District 490087001230 292 Salt Lake Head Start   Regular School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351914 UT     school 4900930 26 District Sevier District 490093000495 820 Richfield Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351940 UT     school 4901050 30 District Tooele District 490105001246 101 Early Learning Center   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1351971 UT     school 4901080 31 District Uintah District 490108001247 810 Uintah Specialized Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1352030 UT     school 4901140 33 District Washington District 490114000778 220 Washington Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1352041 UT     school 4901200 35 District Weber District 490120001249 179 Canyon View Preschool   Special Education School No Prekindergarten PK PK 2021   kindergarten                                                   0                                             0
1193543 UT     school 4900630 19 District Nebo District 490063001563 345 Mt. Nebo Middle   Regular School No Not reported M M 2020   kindergarten                                                   0                                             0
1193334 UT     school 4900360 12 District Granite District 490036001237 610 Headstart Preschool Special Education   Special Education School No Elementary PK KG 2020   kindergarten                                                   0                                             0
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
1351537 UT     school 4900360 12 District Granite District 490036001237 610 Headstart Preschool Special Education   Special Education School No Elementary PK KG 2021   kindergarten                                                   0                                             0
1351804 UT     school 4900720 37 District Ogden City District 490072001232 100 Ogden Preschool   Special Education School No Elementary PK KG 2021   kindergarten                                                   0                                             0
1352217 UT     school 4900167 7I Charter Weber State University Charter Academy 490016701447 100 Weber State University Charter Academy   Regular School Yes Elementary KG KG 2021   kindergarten                                                   32                                             32
1192971 UT     school 4900030 01 District Alpine District 490003000002 704 American Fork High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1192982 UT     school 4900030 01 District Alpine District 490003001538 721 Cedar Valley High   Regular School No High 09 12 2020   kindergarten                                                   0                                             0
1192987 UT     school 4900030 01 District Alpine District 490003000014 840 Dan W. Peterson   Special Education School No Other PK 12 2020   kindergarten                                                   1                                             1
1193003 UT     school 4900030 01 District Alpine District 490003001419 808 Horizon School   Special Education School No Other PK 12 2020   kindergarten                                                   2                                             2
1193007 UT     school 4900030 01 District Alpine District 490003000017 708 Lehi High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193012 UT     school 4900030 01 District Alpine District 490003000445 709 Lone Peak High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193018 UT     school 4900030 01 District Alpine District 490003000706 711 Mountain View High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193023 UT     school 4900030 01 District Alpine District 490003000021 712 Orem High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193026 UT     school 4900030 01 District Alpine District 490003000024 716 Pleasant Grove High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193028 UT     school 4900030 01 District Alpine District 490003001435 782 Polaris High School   Alternative School No High 09 12 2020   kindergarten                                                   0                                             0
1193029 UT     school 4900030 01 District Alpine District 490003001553 783 Polaris West High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193040 UT     school 4900030 01 District Alpine District 490003001486 785 Skyridge High School   Regular School No High 09 12 2020   kindergarten                                                   0                                             0
1193043 UT     school 4900030 01 District Alpine District 490003000366 730 Summit High   Alternative School No High 08 12 2020   kindergarten                                                   0                                             0
1193047 UT     school 4900030 01 District Alpine District 490003000362 718 Timpanogos High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193053 UT     school 4900030 01 District Alpine District 490003001293 789 Westlake High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193057 UT     school 4900060 02 District Beaver District 490006000036 704 Beaver High   Regular School No High 07 12 2020   kindergarten                                                   0                                             0
1193060 UT     school 4900060 02 District Beaver District 490006000038 708 Milford High   Regular School No High 07 12 2020   kindergarten                                                   0                                             0
1193064 UT     school 4900090 03 District Box Elder District 490009000043 704 Bear River High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193066 UT     school 4900090 03 District Box Elder District 490009000046 708 Box Elder High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193069 UT     school 4900090 03 District Box Elder District 490009000707 778 Sunrise High School   Alternative School No High 07 12 2020   kindergarten                                                   0                                             0
1193090 UT     school 4900120 04 District Cache District 490012000041 710 Cache Alternative High   Alternative School No High 08 12 2020   kindergarten                                                   0                                             0
1193094 UT     school 4900120 04 District Cache District 490012001512 703 Green Canyon High School   Regular School No High 09 12 2020   kindergarten                                                   0                                             0
1193100 UT     school 4900120 04 District Cache District 490012000792 702 Mountain Crest High   Regular School No High 09 12 2020   kindergarten                                                   0                                             0
1193106 UT     school 4900120 04 District Cache District 490012001487 705 Ridgeline High School   Regular School No High 09 12 2020   kindergarten                                                   0                                             0
1193108 UT     school 4900120 04 District Cache District 490012000083 706 Sky View High   Regular School No High 09 12 2020   kindergarten                                                   0                                             0
1193116 UT     school 4900142 42 District Canyons District 490014200659 702 Alta High   Regular School No High 09 12 2020   kindergarten                                                   0                                             0
1193121 UT     school 4900142 42 District Canyons District 490014200291 705 Brighton High   Regular School No High 09 12 2020   kindergarten                                                   0                                             0
1193126 UT     school 4900142 42 District Canyons District 490014201384 840 Canyons Transition Academy   Special Education School No High 12 12 2020   kindergarten                                                   0                                             0
1193128 UT     school 4900142 42 District Canyons District 490014201428 711 Corner Canyon High   Regular School No High 09 12 2020   kindergarten                                                   0                                             0
1193130 UT     school 4900142 42 District Canyons District 490014201504 750 Diamond Ridge High School   Alternative School No High 10 12 2020   kindergarten                                                   0                                             0
1193137 UT     school 4900142 42 District Canyons District 490014201368 950 Entrada   Regular School No Other 03 12 2020   kindergarten                                                   0                                             0
1193140 UT     school 4900142 42 District Canyons District 490014200305 706 Hillcrest High   Regular School No High 09 12 2020   kindergarten                                                   0                                             0
1193142 UT     school 4900142 42 District Canyons District 490014200307 708 Jordan High   Regular School No High 09 12 2020   kindergarten                                                   0                                             0
1193143 UT     school 4900142 42 District Canyons District 490014200309 810 Jordan Valley School   Special Education School No Other KG 12 2020   kindergarten                                                   3                                             3
1193157 UT     school 4900142 42 District Canyons District 490014200950 712 South Park Academy   Special Education School No High 11 12 2020   kindergarten                                                   0                                             0
1193165 UT     school 4900150 05 District Carbon District 490015000089 704 Carbon High   Regular School No High 09 12 2020   kindergarten                                                   0                                             0
1193167 UT     school 4900150 05 District Carbon District 490015000088 801 Castle Valley Center   Special Education School No Other PK 12 2020   kindergarten                                                   15                                             15

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