Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless ▼ homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1192021 UT     school 4900060 02 District Beaver District 490006001257 100 Beaver Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192054 UT     school 4900120 04 District Cache District 490012001251 600 Cache Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192121 UT     school 4900142 42 District Canyons District 490014201309 800 Special Ed Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192166 UT     school 4900210 07 District Davis District 490021000727 802 Family Enrichment Center   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192263 UT     school 4900330 11 District Grand District 490033001236 801 C R Sundwall Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192297 UT     school 4900360 12 District Granite District 490036001237 610 Headstart Preschool Special Education   Special Education School No Elementary PK KG 2020   k_12_total                                                   0                                             0
1192367 UT     school 4900390 13 District Iron District 490039001240 150 Iron County Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192372 UT     school 4900390 13 District Iron District 490039001238 160 Three Peaks Pre School   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192410 UT     school     District Jordan District     Preschool (Sp Ed)             2020   k_12_total                                                   0                                             0
1192444 UT     school 4900480 16 District Kane District 490048001258 100 Kane Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192453 UT     school 4900510 39 District Logan City District 490051001530 114 Logan Early Childhood Center   Regular School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192456 UT     school 4900510 39 District Logan City District 490051001234 113 Riverside Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192470 UT     school 4900570 18 District Morgan District 490057001260 100 Morgan Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192474 UT     school 4900600 40 District Murray District 490060001248 140 Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192540 UT     school 4900690 21 District North Summit District 490069001254 100 North Summit Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192557 UT     school 4900720 37 District Ogden City District 490072001232 100 Ogden Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192563 UT     school 4900750 22 District Park City District 490075001423 158 Jeremy Ranch Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192566 UT     school 4900750 22 District Park City District 490075001255 150 MPES Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192568 UT     school 4900750 22 District Park City District 490075001409 154 Parley's Park Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192570 UT     school 4900750 22 District Park City District 490075001410 156 Trailside Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192573 UT     school 4900780 23 District Piute District 490078001261 101 Circleville Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192575 UT     school 4900780 23 District Piute District 490078001262 102 Oscarson Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192594 UT     school 4900810 38 District Provo District 490081001233 641 Sunrise Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192603 UT     school 4900840 24 District Rich District 490084001264 150 Rich Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192639 UT     school 4900870 36 District Salt Lake District 490087001230 292 Salt Lake Head Start   Regular School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192666 UT     school 4900930 26 District Sevier District 490093000495 820 Richfield Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192694 UT     school 4901050 30 District Tooele District 490105001246 101 Early Learning Center   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192725 UT     school 4901080 31 District Uintah District 490108001247 810 Uintah Specialized Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192782 UT     school 4901140 33 District Washington District 490114000778 220 Washington Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192793 UT     school 4901200 35 District Weber District 490120001249 179 Canyon View Preschool   Special Education School No Prekindergarten PK PK 2020   k_12_total                                                   0                                             0
1192969 UT     school 4900030 01 District Alpine District 490003001154 299 Alpine Online School   Regular School No Elementary KG 08 2020   kindergarten                                                   11                                             11
1192970 UT     school 4900030 01 District Alpine District 490003000001 104 Alpine School   Regular School No Elementary PK 06 2020   kindergarten                                                   72                                             72
1192971 UT     school 4900030 01 District Alpine District 490003000002 704 American Fork High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1192972 UT     school 4900030 01 District Alpine District 490003000003 404 American Fork Jr High   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1192973 UT     school 4900030 01 District Alpine District 490003000740 105 Aspen School   Regular School No Elementary PK 06 2020   kindergarten                                                   51                                             51
1192974 UT     school 4900030 01 District Alpine District 490003000004 106 Barratt School   Regular School No Elementary PK 06 2020   kindergarten                                                   56                                             56
1192975 UT     school 4900030 01 District Alpine District 490003001545 114 Belmont School   Regular School No Elementary PK 06 2020   kindergarten                                                   110                                             110
1192976 UT     school 4900030 01 District Alpine District 490003001461 115 Black Ridge School   Regular School No Elementary PK 06 2020   kindergarten                                                   144                                             144
1192977 UT     school 4900030 01 District Alpine District 490003000005 107 Bonneville School   Regular School No Elementary PK 06 2020   kindergarten                                                   85                                             85
1192978 UT     school 4900030 01 District Alpine District 490003001547 203 Brookhaven School   Regular School No Elementary PK 06 2020   kindergarten                                                   227                                             227
1192979 UT     school 4900030 01 District Alpine District 490003000819 405 Canyon View Jr High   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1192980 UT     school 4900030 01 District Alpine District 490003000006 108 Cascade School   Regular School No Elementary PK 06 2020   kindergarten                                                   72                                             72
1192981 UT     school 4900030 01 District Alpine District 490003000440 111 Cedar Ridge School   Regular School No Elementary PK 06 2020   kindergarten                                                   86                                             86
1192982 UT     school 4900030 01 District Alpine District 490003001538 721 Cedar Valley High   Regular School No High 09 12 2020   kindergarten                                                   0                                             0
1192983 UT     school 4900030 01 District Alpine District 490003000007 112 Cedar Valley School   Regular School No Elementary KG 06 2020   kindergarten                                                   10                                             10
1192984 UT     school 4900030 01 District Alpine District 490003001573 226 Centennial Elementary   Regular School No Elementary PK 06 2020   kindergarten                                                   119                                             119
1192985 UT     school 4900030 01 District Alpine District 490003000008 116 Central School   Regular School No Elementary PK 06 2020   kindergarten                                                   74                                             74
1192986 UT     school 4900030 01 District Alpine District 490003000009 118 Cherry Hill School   Regular School No Elementary PK 06 2020   kindergarten                                                   94                                             94
1192987 UT     school 4900030 01 District Alpine District 490003000014 840 Dan W. Peterson   Special Education School No Other PK 12 2020   kindergarten                                                   1                                             1
1192988 UT     school 4900030 01 District Alpine District 490003000757 119 Deerfield School   Regular School No Elementary PK 06 2020   kindergarten                                                   67                                             67
1192989 UT     school 4900030 01 District Alpine District 490003001462 183 Dry Creek School   Regular School No Elementary PK 06 2020   kindergarten                                                   158                                             158
1192990 UT     school 4900030 01 District Alpine District 490003001071 121 Eagle Valley School   Regular School No Elementary PK 06 2020   kindergarten                                                   123                                             123
1192991 UT     school 4900030 01 District Alpine District 490003000444 120 Eaglecrest School   Regular School No Elementary PK 06 2020   kindergarten                                                   122                                             122
1192992 UT     school 4900030 01 District Alpine District 490003000593 123 Foothill School   Regular School No Elementary PK 06 2020   kindergarten                                                   67                                             67
1192993 UT     school 4900030 01 District Alpine District 490003000010 124 Forbes School   Regular School No Elementary KG 06 2020   kindergarten                                                   54                                             54
1192994 UT     school 4900030 01 District Alpine District 490003001111 126 Fox Hollow School   Regular School No Elementary PK 06 2020   kindergarten                                                   94                                             94
1192995 UT     school 4900030 01 District Alpine District 490003000908 125 Freedom School   Regular School No Elementary PK 06 2020   kindergarten                                                   113                                             113
1192996 UT     school 4900030 01 District Alpine District 490003001454 417 Frontier Middle School   Regular School No Middle 07 08 2020   kindergarten                                                   0                                             0
1192997 UT     school 4900030 01 District Alpine District 490003000011 128 Geneva School   Regular School No Elementary PK 06 2020   kindergarten                                                   41                                             41
1192998 UT     school 4900030 01 District Alpine District 490003000012 132 Greenwood School   Regular School No Elementary PK 06 2020   kindergarten                                                   121                                             121
1192999 UT     school 4900030 01 District Alpine District 490003000013 136 Grovecrest School   Regular School No Elementary PK 06 2020   kindergarten                                                   89                                             89
1193000 UT     school 4900030 01 District Alpine District 490003001112 138 Harvest School   Regular School No Elementary PK 06 2020   kindergarten                                                   136                                             136
1193001 UT     school 4900030 01 District Alpine District 490003001200 139 Hidden Hollow School   Regular School No Elementary PK 06 2020   kindergarten                                                   147                                             147
1193002 UT     school 4900030 01 District Alpine District 490003000672 140 Highland School   Regular School No Elementary PK 06 2020   kindergarten                                                   66                                             66
1193003 UT     school 4900030 01 District Alpine District 490003001419 808 Horizon School   Special Education School No Other PK 12 2020   kindergarten                                                   2                                             2
1193004 UT     school 4900030 01 District Alpine District 490003001575 450 Lake Mountain Middle   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193005 UT     school 4900030 01 District Alpine District 490003000016 406 Lakeridge Jr High   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193006 UT     school 4900030 01 District Alpine District 490003000228 146 Legacy School   Regular School No Elementary PK 06 2020   kindergarten                                                   90                                             90
1193007 UT     school 4900030 01 District Alpine District 490003000017 708 Lehi High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193008 UT     school 4900030 01 District Alpine District 490003000018 408 Lehi Jr High   Regular School No Middle 07 08 2020   kindergarten                                                   0                                             0
1193009 UT     school 4900030 01 District Alpine District 490003000019 148 Lehi School   Regular School No Elementary PK 06 2020   kindergarten                                                   83                                             83
1193010 UT     school 4900030 01 District Alpine District 490003001574 113 Liberty Hills Elementary   Regular School No Elementary KG 06 2020   kindergarten                                                   84                                             84
1193011 UT     school 4900030 01 District Alpine District 490003000020 156 Lindon School   Regular School No Elementary PK 06 2020   kindergarten                                                   104                                             104
1193012 UT     school 4900030 01 District Alpine District 490003000445 709 Lone Peak High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193013 UT     school 4900030 01 District Alpine District 490003000743 160 Manila School   Regular School No Elementary PK 06 2020   kindergarten                                                   69                                             69
1193014 UT     school 4900030 01 District Alpine District 490003000744 154 Meadow School   Regular School No Elementary PK 06 2020   kindergarten                                                   113                                             113
1193015 UT     school 4900030 01 District Alpine District 490003000696 161 Mount Mahogany School   Regular School No Elementary PK 06 2020   kindergarten                                                   124                                             124
1193016 UT     school 4900030 01 District Alpine District 490003000074 410 Mountain Ridge Jr High   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193017 UT     school 4900030 01 District Alpine District 490003001381 205 Mountain Trails School   Regular School No Elementary PK 06 2020   kindergarten                                                   131                                             131
1193018 UT     school 4900030 01 District Alpine District 490003000706 711 Mountain View High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193019 UT     school 4900030 01 District Alpine District 490003001299 150 North Point School   Regular School No Elementary PK 06 2020   kindergarten                                                   98                                             98
1193020 UT     school 4900030 01 District Alpine District 490003000647 155 Northridge School   Regular School No Elementary PK 06 2020   kindergarten                                                   82                                             82
1193021 UT     school 4900030 01 District Alpine District 490003000075 412 Oak Canyon Jr High   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193022 UT     school 4900030 01 District Alpine District 490003000791 151 Orchard School   Regular School No Elementary PK 06 2020   kindergarten                                                   92                                             92
1193023 UT     school 4900030 01 District Alpine District 490003000021 712 Orem High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193024 UT     school 4900030 01 District Alpine District 490003000022 414 Orem Jr High   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193025 UT     school 4900030 01 District Alpine District 490003000023 157 Orem School   Regular School No Elementary PK 06 2020   kindergarten                                                   109                                             109
1193026 UT     school 4900030 01 District Alpine District 490003000024 716 Pleasant Grove High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193027 UT     school 4900030 01 District Alpine District 490003000025 416 Pleasant Grove Jr High   Regular School No Middle 07 09 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
1193030 UT     school 4900030 01 District Alpine District 490003000907 153 Pony Express School   Regular School No Elementary PK 06 2020   kindergarten                                                   162                                             162
1193031 UT     school 4900030 01 District Alpine District 490003001113 165 Ridgeline School   Regular School No Elementary PK 06 2020   kindergarten                                                   101                                             101
1193032 UT     school 4900030 01 District Alpine District 490003001481 201 River Rock School   Regular School No Elementary PK 06 2020   kindergarten                                                   141                                             141
1193033 UT     school 4900030 01 District Alpine District 490003001405 219 Riverview School   Regular School No Elementary PK 06 2020   kindergarten                                                   92                                             92
1193034 UT     school 4900030 01 District Alpine District 490003000349 162 Rocky Mountain School   Regular School No Elementary PK 06 2020   kindergarten                                                   50                                             50
1193035 UT     school 4900030 01 District Alpine District 490003001320 167 Sage Hills School   Regular School No Elementary PK 06 2020   kindergarten                                                   176                                             176
1193036 UT     school 4900030 01 District Alpine District 490003001099 163 Saratoga Shores School   Regular School No Elementary PK 06 2020   kindergarten                                                   93                                             93
1193037 UT     school 4900030 01 District Alpine District 490003000027 164 Sego Lily School   Regular School No Elementary PK 06 2020   kindergarten                                                   98                                             98
1193038 UT     school 4900030 01 District Alpine District 490003000028 168 Sharon School   Regular School No Elementary PK 06 2020   kindergarten                                                   62                                             62

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