Data source: Big Local News · About: Big Local

2,084 rows where grade = "grade_10" and state = "UT" sorted by district_nces_id descending

View and edit SQL

year

grade

  • grade_10 · 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
1203451 UT     school   03 District Box Elder District   250 Out of State Elementary School             2020   grade_10                                                   0                                             0
1203452 UT     school   03 District Box Elder District   730 Out of State School             2020   grade_10                                                   4                                             4
1203817 UT     school     District Jordan District     Preschool (Sp Ed)             2020   grade_10                                                   0                                             0
1203958 UT     school   37 District Ogden City District   731 Malan's Peak Secondary             2020   grade_10                                                   2                                             2
1204085 UT     school   28 District South Summit District   108 Out of State School             2020   grade_10                                                   0                                             0
1204086 UT     school   28 District South Summit District   708 Out of State School             2020   grade_10                                                   0                                             0
1204197 UT     school 4901200 35 District Weber District 490120000612 100 Bates School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204198 UT     school 4901200 35 District Weber District 490120000613 701 Bonneville High   Regular School No High 10 12 2020   grade_10                                                   498                                             498
1204199 UT     school 4901200 35 District Weber District 490120001484 105 Burch Creek School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204200 UT     school 4901200 35 District Weber District 490120001249 179 Canyon View Preschool   Special Education School No Prekindergarten PK PK 2020   grade_10                                                   0                                             0
1204201 UT     school 4901200 35 District Weber District 490120000703 109 Country View School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204202 UT     school 4901200 35 District Weber District 490120000817 113 Farr West School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204203 UT     school 4901200 35 District Weber District 490120000781 115 Freedom School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204204 UT     school 4901200 35 District Weber District 490120000221 706 Fremont High   Regular School No High 10 12 2020   grade_10                                                   646                                             646
1204205 UT     school 4901200 35 District Weber District 490120000616 111 Green Acres School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204206 UT     school 4901200 35 District Weber District 490120000617 110 H Guy Child School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204207 UT     school 4901200 35 District Weber District 490120000618 112 Hooper School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204208 UT     school 4901200 35 District Weber District 490120001548 750 Horizon Academy   Alternative School No High 08 12 2020   grade_10                                                   8                                             8
1204209 UT     school 4901200 35 District Weber District 490120000619 114 Kanesville School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204210 UT     school 4901200 35 District Weber District 490120000620 116 Lakeview School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204211 UT     school 4901200 35 District Weber District 490120000621 120 Lomond View School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204212 UT     school 4901200 35 District Weber District 490120000573 121 Majestic School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204213 UT     school 4901200 35 District Weber District 490120000818 123 Midland School   Regular School No Elementary PK 06 2020   grade_10                                                   0                                             0
1204214 UT     school 4901200 35 District Weber District 490120000624 124 Municipal School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204215 UT     school 4901200 35 District Weber District 490120000625 402 North Ogden Jr High   Regular School No Middle 07 09 2020   grade_10                                                   0                                             0
1204216 UT     school 4901200 35 District Weber District 490120000626 128 North Ogden School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204217 UT     school 4901200 35 District Weber District 490120000627 132 North Park School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204218 UT     school 4901200 35 District Weber District 490120001546 142 Orchard Springs   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204219 UT     school 4901200 35 District Weber District 490120000967 405 Orion Jr High   Regular School No Middle 07 09 2020   grade_10                                                   0                                             0
1204220 UT     school 4901200 35 District Weber District 490120000630 138 Pioneer School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204221 UT     school 4901200 35 District Weber District 490120000631 140 Plain City School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204222 UT     school 4901200 35 District Weber District 490120000632 144 Riverdale School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204223 UT     school 4901200 35 District Weber District 490120000212 403 Rocky Mountain Jr High   Regular School No Middle 07 09 2020   grade_10                                                   0                                             0
1204224 UT     school 4901200 35 District Weber District 490120000633 148 Roosevelt School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204225 UT     school 4901200 35 District Weber District 490120000634 708 Roy High   Regular School No High 10 12 2020   grade_10                                                   651                                             651
1204226 UT     school 4901200 35 District Weber District 490120000635 404 Roy Jr High   Regular School No Middle 07 09 2020   grade_10                                                   0                                             0
1204227 UT     school 4901200 35 District Weber District 490120000636 152 Roy School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204228 UT     school 4901200 35 District Weber District 490120000637 406 Sand Ridge Jr High   Regular School No Middle 07 09 2020   grade_10                                                   0                                             0
1204229 UT     school 4901200 35 District Weber District 490120001552 141 Silver Ridge Elementary   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204230 UT     school 4901200 35 District Weber District 490120000669 412 Snowcrest Jr High   Regular School No Middle 07 09 2020   grade_10                                                   0                                             0
1204231 UT     school 4901200 35 District Weber District 490120000638 408 South Ogden Jr High   Regular School No Middle 07 09 2020   grade_10                                                   0                                             0
1204232 UT     school 4901200 35 District Weber District 490120000639 410 T.H. Bell Jr High   Regular School No Middle 07 09 2020   grade_10                                                   0                                             0
1204233 UT     school 4901200 35 District Weber District 490120000972 730 Two Rivers High   Alternative School No High 09 12 2020   grade_10                                                   3                                             3
1204234 UT     school 4901200 35 District Weber District 490120000640 154 Uintah School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204235 UT     school 4901200 35 District Weber District 490120000641 156 Valley School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204236 UT     school 4901200 35 District Weber District 490120000642 158 Valley View School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204237 UT     school 4901200 35 District Weber District 490120000643 416 Wahlquist Jr High   Regular School No Middle 07 09 2020   grade_10                                                   0                                             0
1204238 UT     school 4901200 35 District Weber District 490120000644 160 Washington Terrace School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204239 UT     school 4901200 35 District Weber District 490120000645 704 Weber High   Regular School No High 10 12 2020   grade_10                                                   722                                             722
1204240 UT     school 4901200 35 District Weber District 490120001482 725 Weber Innovation High School   Regular School No High 09 12 2020   grade_10                                                   72                                             72
1204241 UT     school 4901200 35 District Weber District 490120001414 199 Weber Online K-6   Regular School No Elementary 02 06 2020   grade_10                                                   0                                             0
1204242 UT     school 4901200 35 District Weber District 490120001108 162 West Haven School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1204243 UT     school 4901200 35 District Weber District 490120000646 164 West Weber School   Regular School No Elementary KG 06 2020   grade_10                                                   0                                             0
1362508 UT     school 4901200 35 District Weber District 490120000612 100 Bates School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362509 UT     school 4901200 35 District Weber District 490120000613 701 Bonneville High   Regular School No High 10 12 2021   grade_10                                                   472                                             472
1362510 UT     school 4901200 35 District Weber District 490120001484 105 Burch Creek School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362511 UT     school 4901200 35 District Weber District 490120001249 179 Canyon View Preschool   Special Education School No Prekindergarten PK PK 2021   grade_10                                                   0                                             0
1362512 UT     school 4901200 35 District Weber District 490120000703 109 Country View School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362513 UT     school 4901200 35 District Weber District 490120000817 113 Farr West School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362514 UT     school 4901200 35 District Weber District 490120000781 115 Freedom School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362515 UT     school 4901200 35 District Weber District 490120000221 706 Fremont High   Regular School No High 10 12 2021   grade_10                                                   740                                             740
1362516 UT     school 4901200 35 District Weber District 490120000616 111 Green Acres School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362517 UT     school 4901200 35 District Weber District 490120000617 110 H Guy Child School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362518 UT     school 4901200 35 District Weber District 490120000618 112 Hooper School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362519 UT     school 4901200 35 District Weber District 490120001548 750 Horizon Academy   Alternative School No High 06 12 2021   grade_10                                                   0                                             0
1362520 UT     school 4901200 35 District Weber District 490120000619 114 Kanesville School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362521 UT     school 4901200 35 District Weber District 490120000620 116 Lakeview School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362522 UT     school 4901200 35 District Weber District 490120000621 120 Lomond View School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362523 UT     school 4901200 35 District Weber District 490120000573 121 Majestic School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362524 UT     school 4901200 35 District Weber District 490120000818 123 Midland School   Regular School No Elementary PK 06 2021   grade_10                                                   0                                             0
1362525 UT     school 4901200 35 District Weber District 490120000624 124 Municipal School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362526 UT     school 4901200 35 District Weber District 490120000625 402 North Ogden Jr High   Regular School No Middle 07 09 2021   grade_10                                                   0                                             0
1362527 UT     school 4901200 35 District Weber District 490120000626 128 North Ogden School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362528 UT     school 4901200 35 District Weber District 490120000627 132 North Park School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362529 UT     school 4901200 35 District Weber District 490120001546 142 Orchard Springs   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362530 UT     school 4901200 35 District Weber District 490120000967 405 Orion Jr High   Regular School No Middle 07 09 2021   grade_10                                                   0                                             0
1362531 UT     school 4901200 35 District Weber District 490120000630 138 Pioneer School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362532 UT     school 4901200 35 District Weber District 490120000631 140 Plain City School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362533 UT     school 4901200 35 District Weber District 490120000632 144 Riverdale School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362534 UT     school 4901200 35 District Weber District 490120000212 403 Rocky Mountain Jr High   Regular School No Middle 07 09 2021   grade_10                                                   0                                             0
1362535 UT     school 4901200 35 District Weber District 490120000633 148 Roosevelt School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362536 UT     school 4901200 35 District Weber District 490120000634 708 Roy High   Regular School No High 10 12 2021   grade_10                                                   608                                             608
1362537 UT     school 4901200 35 District Weber District 490120000635 404 Roy Jr High   Regular School No Middle 07 09 2021   grade_10                                                   0                                             0
1362538 UT     school 4901200 35 District Weber District 490120000636 152 Roy School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362539 UT     school 4901200 35 District Weber District 490120000637 406 Sand Ridge Jr High   Regular School No Middle 07 09 2021   grade_10                                                   0                                             0
1362540 UT     school 4901200 35 District Weber District 490120001552 141 Silver Ridge Elementary   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362541 UT     school 4901200 35 District Weber District 490120000669 412 Snowcrest Jr High   Regular School No Middle 07 09 2021   grade_10                                                   0                                             0
1362542 UT     school 4901200 35 District Weber District 490120000638 408 South Ogden Jr High   Regular School No Middle 07 09 2021   grade_10                                                   0                                             0
1362543 UT     school 4901200 35 District Weber District 490120000639 410 T.H. Bell Jr High   Regular School No Middle 07 09 2021   grade_10                                                   0                                             0
1362544 UT     school 4901200 35 District Weber District 490120000972 730 Two Rivers High   Alternative School No High 07 12 2021   grade_10                                                   2                                             2
1362545 UT     school 4901200 35 District Weber District 490120000640 154 Uintah School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362546 UT     school 4901200 35 District Weber District 490120000641 156 Valley School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362547 UT     school 4901200 35 District Weber District 490120000642 158 Valley View School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362548 UT     school 4901200 35 District Weber District 490120000643 416 Wahlquist Jr High   Regular School No Middle 07 09 2021   grade_10                                                   0                                             0
1362549 UT     school 4901200 35 District Weber District 490120000644 160 Washington Terrace School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362550 UT     school 4901200 35 District Weber District 490120000645 704 Weber High   Regular School No High 10 12 2021   grade_10                                                   723                                             723
1362551 UT     school 4901200 35 District Weber District 490120001482 725 Weber Innovation High School   Regular School No High 09 12 2021   grade_10                                                   87                                             87
1362552 UT     school 4901200 35 District Weber District 490120001414 199 Weber Online K-6   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362553 UT     school 4901200 35 District Weber District 490120001108 162 West Haven School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
1362554 UT     school 4901200 35 District Weber District 490120000646 164 West Weber School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);