Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_3 · 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
1196080 UT     school 4900030 01 District Alpine District 490003001154 299 Alpine Online School   Regular School No Elementary KG 08 2020   grade_3                                                   10                                             10
1196081 UT     school 4900030 01 District Alpine District 490003000001 104 Alpine School   Regular School No Elementary PK 06 2020   grade_3                                                   104                                             104
1196082 UT     school 4900030 01 District Alpine District 490003000002 704 American Fork High   Regular School No High 10 12 2020   grade_3                                                   0                                             0
1196083 UT     school 4900030 01 District Alpine District 490003000003 404 American Fork Jr High   Regular School No Middle 07 09 2020   grade_3                                                   0                                             0
1196084 UT     school 4900030 01 District Alpine District 490003000740 105 Aspen School   Regular School No Elementary PK 06 2020   grade_3                                                   49                                             49
1196085 UT     school 4900030 01 District Alpine District 490003000004 106 Barratt School   Regular School No Elementary PK 06 2020   grade_3                                                   77                                             77
1196086 UT     school 4900030 01 District Alpine District 490003001545 114 Belmont School   Regular School No Elementary PK 06 2020   grade_3                                                   89                                             89
1196087 UT     school 4900030 01 District Alpine District 490003001461 115 Black Ridge School   Regular School No Elementary PK 06 2020   grade_3                                                   161                                             161
1196088 UT     school 4900030 01 District Alpine District 490003000005 107 Bonneville School   Regular School No Elementary PK 06 2020   grade_3                                                   72                                             72
1196089 UT     school 4900030 01 District Alpine District 490003001547 203 Brookhaven School   Regular School No Elementary PK 06 2020   grade_3                                                   183                                             183
1196090 UT     school 4900030 01 District Alpine District 490003000819 405 Canyon View Jr High   Regular School No Middle 07 09 2020   grade_3                                                   0                                             0
1196091 UT     school 4900030 01 District Alpine District 490003000006 108 Cascade School   Regular School No Elementary PK 06 2020   grade_3                                                   120                                             120
1196092 UT     school 4900030 01 District Alpine District 490003000440 111 Cedar Ridge School   Regular School No Elementary PK 06 2020   grade_3                                                   117                                             117
1196093 UT     school 4900030 01 District Alpine District 490003001538 721 Cedar Valley High   Regular School No High 09 12 2020   grade_3                                                   0                                             0
1196094 UT     school 4900030 01 District Alpine District 490003000007 112 Cedar Valley School   Regular School No Elementary KG 06 2020   grade_3                                                   14                                             14
1196095 UT     school 4900030 01 District Alpine District 490003001573 226 Centennial Elementary   Regular School No Elementary PK 06 2020   grade_3                                                   108                                             108
1196096 UT     school 4900030 01 District Alpine District 490003000008 116 Central School   Regular School No Elementary PK 06 2020   grade_3                                                   67                                             67
1196097 UT     school 4900030 01 District Alpine District 490003000009 118 Cherry Hill School   Regular School No Elementary PK 06 2020   grade_3                                                   99                                             99
1196098 UT     school 4900030 01 District Alpine District 490003000014 840 Dan W. Peterson   Special Education School No Other PK 12 2020   grade_3                                                   7                                             7
1196099 UT     school 4900030 01 District Alpine District 490003000757 119 Deerfield School   Regular School No Elementary PK 06 2020   grade_3                                                   91                                             91
1196100 UT     school 4900030 01 District Alpine District 490003001462 183 Dry Creek School   Regular School No Elementary PK 06 2020   grade_3                                                   166                                             166
1196101 UT     school 4900030 01 District Alpine District 490003001071 121 Eagle Valley School   Regular School No Elementary PK 06 2020   grade_3                                                   111                                             111
1196102 UT     school 4900030 01 District Alpine District 490003000444 120 Eaglecrest School   Regular School No Elementary PK 06 2020   grade_3                                                   129                                             129
1196103 UT     school 4900030 01 District Alpine District 490003000593 123 Foothill School   Regular School No Elementary PK 06 2020   grade_3                                                   85                                             85
1196104 UT     school 4900030 01 District Alpine District 490003000010 124 Forbes School   Regular School No Elementary KG 06 2020   grade_3                                                   58                                             58
1196105 UT     school 4900030 01 District Alpine District 490003001111 126 Fox Hollow School   Regular School No Elementary PK 06 2020   grade_3                                                   113                                             113
1196106 UT     school 4900030 01 District Alpine District 490003000908 125 Freedom School   Regular School No Elementary PK 06 2020   grade_3                                                   113                                             113
1196107 UT     school 4900030 01 District Alpine District 490003001454 417 Frontier Middle School   Regular School No Middle 07 08 2020   grade_3                                                   0                                             0
1196108 UT     school 4900030 01 District Alpine District 490003000011 128 Geneva School   Regular School No Elementary PK 06 2020   grade_3                                                   42                                             42
1196109 UT     school 4900030 01 District Alpine District 490003000012 132 Greenwood School   Regular School No Elementary PK 06 2020   grade_3                                                   91                                             91
1196110 UT     school 4900030 01 District Alpine District 490003000013 136 Grovecrest School   Regular School No Elementary PK 06 2020   grade_3                                                   118                                             118
1196111 UT     school 4900030 01 District Alpine District 490003001112 138 Harvest School   Regular School No Elementary PK 06 2020   grade_3                                                   141                                             141
1196112 UT     school 4900030 01 District Alpine District 490003001200 139 Hidden Hollow School   Regular School No Elementary PK 06 2020   grade_3                                                   129                                             129
1196113 UT     school 4900030 01 District Alpine District 490003000672 140 Highland School   Regular School No Elementary PK 06 2020   grade_3                                                   125                                             125
1196114 UT     school 4900030 01 District Alpine District 490003001419 808 Horizon School   Special Education School No Other PK 12 2020   grade_3                                                   1                                             1
1196115 UT     school 4900030 01 District Alpine District 490003001575 450 Lake Mountain Middle   Regular School No Middle 07 09 2020   grade_3                                                   0                                             0
1196116 UT     school 4900030 01 District Alpine District 490003000016 406 Lakeridge Jr High   Regular School No Middle 07 09 2020   grade_3                                                   0                                             0
1196117 UT     school 4900030 01 District Alpine District 490003000228 146 Legacy School   Regular School No Elementary PK 06 2020   grade_3                                                   96                                             96
1196118 UT     school 4900030 01 District Alpine District 490003000017 708 Lehi High   Regular School No High 10 12 2020   grade_3                                                   0                                             0
1196119 UT     school 4900030 01 District Alpine District 490003000018 408 Lehi Jr High   Regular School No Middle 07 08 2020   grade_3                                                   0                                             0
1196120 UT     school 4900030 01 District Alpine District 490003000019 148 Lehi School   Regular School No Elementary PK 06 2020   grade_3                                                   86                                             86
1196121 UT     school 4900030 01 District Alpine District 490003001574 113 Liberty Hills Elementary   Regular School No Elementary KG 06 2020   grade_3                                                   76                                             76
1196122 UT     school 4900030 01 District Alpine District 490003000020 156 Lindon School   Regular School No Elementary PK 06 2020   grade_3                                                   87                                             87
1196123 UT     school 4900030 01 District Alpine District 490003000445 709 Lone Peak High   Regular School No High 10 12 2020   grade_3                                                   0                                             0
1196124 UT     school 4900030 01 District Alpine District 490003000743 160 Manila School   Regular School No Elementary PK 06 2020   grade_3                                                   99                                             99
1196125 UT     school 4900030 01 District Alpine District 490003000744 154 Meadow School   Regular School No Elementary PK 06 2020   grade_3                                                   112                                             112
1196126 UT     school 4900030 01 District Alpine District 490003000696 161 Mount Mahogany School   Regular School No Elementary PK 06 2020   grade_3                                                   122                                             122
1196127 UT     school 4900030 01 District Alpine District 490003000074 410 Mountain Ridge Jr High   Regular School No Middle 07 09 2020   grade_3                                                   0                                             0
1196128 UT     school 4900030 01 District Alpine District 490003001381 205 Mountain Trails School   Regular School No Elementary PK 06 2020   grade_3                                                   111                                             111
1196129 UT     school 4900030 01 District Alpine District 490003000706 711 Mountain View High   Regular School No High 10 12 2020   grade_3                                                   0                                             0
1196130 UT     school 4900030 01 District Alpine District 490003001299 150 North Point School   Regular School No Elementary PK 06 2020   grade_3                                                   89                                             89
1196131 UT     school 4900030 01 District Alpine District 490003000647 155 Northridge School   Regular School No Elementary PK 06 2020   grade_3                                                   114                                             114
1196132 UT     school 4900030 01 District Alpine District 490003000075 412 Oak Canyon Jr High   Regular School No Middle 07 09 2020   grade_3                                                   0                                             0
1196133 UT     school 4900030 01 District Alpine District 490003000791 151 Orchard School   Regular School No Elementary PK 06 2020   grade_3                                                   101                                             101
1196134 UT     school 4900030 01 District Alpine District 490003000021 712 Orem High   Regular School No High 10 12 2020   grade_3                                                   0                                             0
1196135 UT     school 4900030 01 District Alpine District 490003000022 414 Orem Jr High   Regular School No Middle 07 09 2020   grade_3                                                   0                                             0
1196136 UT     school 4900030 01 District Alpine District 490003000023 157 Orem School   Regular School No Elementary PK 06 2020   grade_3                                                   90                                             90
1196137 UT     school 4900030 01 District Alpine District 490003000024 716 Pleasant Grove High   Regular School No High 10 12 2020   grade_3                                                   0                                             0
1196138 UT     school 4900030 01 District Alpine District 490003000025 416 Pleasant Grove Jr High   Regular School No Middle 07 09 2020   grade_3                                                   0                                             0
1196139 UT     school 4900030 01 District Alpine District 490003001435 782 Polaris High School   Alternative School No High 09 12 2020   grade_3                                                   0                                             0
1196140 UT     school 4900030 01 District Alpine District 490003001553 783 Polaris West High   Regular School No High 10 12 2020   grade_3                                                   0                                             0
1196141 UT     school 4900030 01 District Alpine District 490003000907 153 Pony Express School   Regular School No Elementary PK 06 2020   grade_3                                                   142                                             142
1196142 UT     school 4900030 01 District Alpine District 490003001113 165 Ridgeline School   Regular School No Elementary PK 06 2020   grade_3                                                   132                                             132
1196143 UT     school 4900030 01 District Alpine District 490003001481 201 River Rock School   Regular School No Elementary PK 06 2020   grade_3                                                   141                                             141
1196144 UT     school 4900030 01 District Alpine District 490003001405 219 Riverview School   Regular School No Elementary PK 06 2020   grade_3                                                   140                                             140
1196145 UT     school 4900030 01 District Alpine District 490003000349 162 Rocky Mountain School   Regular School No Elementary PK 06 2020   grade_3                                                   101                                             101
1196146 UT     school 4900030 01 District Alpine District 490003001320 167 Sage Hills School   Regular School No Elementary PK 06 2020   grade_3                                                   173                                             173
1196147 UT     school 4900030 01 District Alpine District 490003001099 163 Saratoga Shores School   Regular School No Elementary PK 06 2020   grade_3                                                   121                                             121
1196148 UT     school 4900030 01 District Alpine District 490003000027 164 Sego Lily School   Regular School No Elementary PK 06 2020   grade_3                                                   90                                             90
1196149 UT     school 4900030 01 District Alpine District 490003000028 168 Sharon School   Regular School No Elementary PK 06 2020   grade_3                                                   36                                             36
1196150 UT     school 4900030 01 District Alpine District 490003000029 170 Shelley School   Regular School No Elementary PK 06 2020   grade_3                                                   115                                             115
1196151 UT     school 4900030 01 District Alpine District 490003001486 785 Skyridge High School   Regular School No High 09 12 2020   grade_3                                                   0                                             0
1196152 UT     school 4900030 01 District Alpine District 490003000699 172 Snow Springs School   Regular School No Elementary PK 06 2020   grade_3                                                   127                                             127
1196153 UT     school 4900030 01 District Alpine District 490003001515 202 Springside School   Regular School No Elementary PK 06 2020   grade_3                                                   127                                             127
1196154 UT     school 4900030 01 District Alpine District 490003000366 730 Summit High   Alternative School No High 08 12 2020   grade_3                                                   0                                             0
1196155 UT     school 4900030 01 District Alpine District 490003000844 174 Suncrest School   Regular School No Elementary PK 06 2020   grade_3                                                   44                                             44
1196156 UT     school 4900030 01 District Alpine District 490003001413 256 Thunder Ridge School   Regular School No Elementary PK 06 2020   grade_3                                                   98                                             98
1196157 UT     school 4900030 01 District Alpine District 490003000909 420 Timberline Middle   Regular School No Middle 07 09 2020   grade_3                                                   0                                             0
1196158 UT     school 4900030 01 District Alpine District 490003000362 718 Timpanogos High   Regular School No High 10 12 2020   grade_3                                                   0                                             0
1196159 UT     school 4900030 01 District Alpine District 490003001385 258 Traverse Mountain School   Regular School No Elementary PK 06 2020   grade_3                                                   91                                             91
1196160 UT     school 4900030 01 District Alpine District 490003000031 176 Valley View School   Regular School No Elementary PK 06 2020   grade_3                                                   63                                             63
1196161 UT     school 4900030 01 District Alpine District 490003000032 177 Vineyard School   Regular School No Elementary PK 06 2020   grade_3                                                   159                                             159
1196162 UT     school 4900030 01 District Alpine District 490003001387 490 Vista Heights Middle   Regular School No Middle 07 09 2020   grade_3                                                   0                                             0
1196163 UT     school 4900030 01 District Alpine District 490003000704 180 Westfield School   Regular School No Elementary PK 06 2020   grade_3                                                   86                                             86
1196164 UT     school 4900030 01 District Alpine District 490003001293 789 Westlake High   Regular School No High 10 12 2020   grade_3                                                   0                                             0
1196165 UT     school 4900030 01 District Alpine District 490003000034 178 Westmore School   Regular School No Elementary PK 06 2020   grade_3                                                   71                                             71
1196166 UT     school 4900030 01 District Alpine District 490003001109 425 Willowcreek Middle   Regular School No Middle 07 09 2020   grade_3                                                   0                                             0
1196167 UT     school 4900030 01 District Alpine District 490003000035 182 Windsor School   Regular School No Elementary PK 06 2020   grade_3                                                   77                                             77
1196168 UT     school 4900060 02 District Beaver District 490006000036 704 Beaver High   Regular School No High 07 12 2020   grade_3                                                   0                                             0
1196169 UT     school 4900060 02 District Beaver District 490006001257 100 Beaver Preschool   Special Education School No Prekindergarten PK PK 2020   grade_3                                                   0                                             0
1196170 UT     school 4900060 02 District Beaver District 490006000037 104 Belknap School   Regular School No Elementary KG 06 2020   grade_3                                                   66                                             66
1196171 UT     school 4900060 02 District Beaver District 490006000038 708 Milford High   Regular School No High 07 12 2020   grade_3                                                   0                                             0
1196172 UT     school 4900060 02 District Beaver District 490006000039 108 Milford School   Regular School No Elementary KG 06 2020   grade_3                                                   33                                             33
1196173 UT     school 4900060 02 District Beaver District 490006000040 112 Minersville School   Regular School No Elementary KG 06 2020   grade_3                                                   10                                             10
1196174 UT     school 4900060 02 District Beaver District 490006000912 712 Minersville School   Regular School No Middle 07 08 2020   grade_3                                                   0                                             0
1196175 UT     school 4900090 03 District Box Elder District 490009000043 704 Bear River High   Regular School No High 10 12 2020   grade_3                                                   0                                             0
1196176 UT     school 4900090 03 District Box Elder District 490009000044 404 Bear River Middle   Regular School No Secondary 08 09 2020   grade_3                                                   0                                             0
1196177 UT     school 4900090 03 District Box Elder District 490009000046 708 Box Elder High   Regular School No High 10 12 2020   grade_3                                                   0                                             0
1196178 UT     school 4900090 03 District Box Elder District 490009000047 408 Box Elder Middle   Regular School No Secondary 08 09 2020   grade_3                                                   0                                             0
1196179 UT     school 4900090 03 District Box Elder District 490009000042 104 Century School   Regular School No Elementary KG 05 2020   grade_3                                                   89                                             89

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