Data source: Big Local News · About: Big Local

2,084 rows where grade = "kindergarten" and state = "UT"

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
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
1193039 UT     school 4900030 01 District Alpine District 490003000029 170 Shelley School   Regular School No Elementary PK 06 2020   kindergarten                                                   121                                             121
1193040 UT     school 4900030 01 District Alpine District 490003001486 785 Skyridge High School   Regular School No High 09 12 2020   kindergarten                                                   0                                             0
1193041 UT     school 4900030 01 District Alpine District 490003000699 172 Snow Springs School   Regular School No Elementary PK 06 2020   kindergarten                                                   143                                             143
1193042 UT     school 4900030 01 District Alpine District 490003001515 202 Springside School   Regular School No Elementary PK 06 2020   kindergarten                                                   160                                             160
1193043 UT     school 4900030 01 District Alpine District 490003000366 730 Summit High   Alternative School No High 08 12 2020   kindergarten                                                   0                                             0
1193044 UT     school 4900030 01 District Alpine District 490003000844 174 Suncrest School   Regular School No Elementary PK 06 2020   kindergarten                                                   65                                             65
1193045 UT     school 4900030 01 District Alpine District 490003001413 256 Thunder Ridge School   Regular School No Elementary PK 06 2020   kindergarten                                                   105                                             105
1193046 UT     school 4900030 01 District Alpine District 490003000909 420 Timberline Middle   Regular School No Middle 07 09 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
1193048 UT     school 4900030 01 District Alpine District 490003001385 258 Traverse Mountain School   Regular School No Elementary PK 06 2020   kindergarten                                                   85                                             85
1193049 UT     school 4900030 01 District Alpine District 490003000031 176 Valley View School   Regular School No Elementary PK 06 2020   kindergarten                                                   59                                             59
1193050 UT     school 4900030 01 District Alpine District 490003000032 177 Vineyard School   Regular School No Elementary PK 06 2020   kindergarten                                                   198                                             198
1193051 UT     school 4900030 01 District Alpine District 490003001387 490 Vista Heights Middle   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193052 UT     school 4900030 01 District Alpine District 490003000704 180 Westfield School   Regular School No Elementary PK 06 2020   kindergarten                                                   55                                             55
1193053 UT     school 4900030 01 District Alpine District 490003001293 789 Westlake High   Regular School No High 10 12 2020   kindergarten                                                   0                                             0
1193054 UT     school 4900030 01 District Alpine District 490003000034 178 Westmore School   Regular School No Elementary PK 06 2020   kindergarten                                                   62                                             62
1193055 UT     school 4900030 01 District Alpine District 490003001109 425 Willowcreek Middle   Regular School No Middle 07 09 2020   kindergarten                                                   0                                             0
1193056 UT     school 4900030 01 District Alpine District 490003000035 182 Windsor School   Regular School No Elementary PK 06 2020   kindergarten                                                   85                                             85
1193057 UT     school 4900060 02 District Beaver District 490006000036 704 Beaver High   Regular School No High 07 12 2020   kindergarten                                                   0                                             0
1193058 UT     school 4900060 02 District Beaver District 490006001257 100 Beaver Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten                                                   0                                             0
1193059 UT     school 4900060 02 District Beaver District 490006000037 104 Belknap School   Regular School No Elementary KG 06 2020   kindergarten                                                   67                                             67
1193060 UT     school 4900060 02 District Beaver District 490006000038 708 Milford High   Regular School No High 07 12 2020   kindergarten                                                   0                                             0
1193061 UT     school 4900060 02 District Beaver District 490006000039 108 Milford School   Regular School No Elementary KG 06 2020   kindergarten                                                   27                                             27
1193062 UT     school 4900060 02 District Beaver District 490006000040 112 Minersville School   Regular School No Elementary KG 06 2020   kindergarten                                                   14                                             14
1193063 UT     school 4900060 02 District Beaver District 490006000912 712 Minersville School   Regular School No Middle 07 08 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
1193065 UT     school 4900090 03 District Box Elder District 490009000044 404 Bear River Middle   Regular School No Secondary 08 09 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
1193067 UT     school 4900090 03 District Box Elder District 490009000047 408 Box Elder Middle   Regular School No Secondary 08 09 2020   kindergarten                                                   0                                             0
1193068 UT     school 4900090 03 District Box Elder District 490009000042 104 Century School   Regular School No Elementary KG 05 2020   kindergarten                                                   80                                             80

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