enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
1192623 1192623 UT     school 4900870 36 District Salt Lake District 490087000732 750 Horizonte Instruction & Training Center   Alternative School No High 10 12 2020   k_12_total 55.0 11.0 166.0 3.0   3.0       14.0 6.0   137.0 121.0     56.0   32.0   236.0     64.0   258 55 11 166 3   3       14 6   137 121     56 32 236   64   258
1192658 1192658 UT     school 4900930 26 District Sevier District 490093000900 716 Cedar Ridge High   Alternative School No High 07 12 2020   k_12_total 36.0 0.0 4.0 1.0   0.0       0.0 0.0   26.0 15.0     2.0   1.0   26.0     7.0   41 36 0 4 1   0       0 0   26 15     2 1 26   7   41
1192690 1192690 UT     school 4901050 30 District Tooele District 490105000698 740 Blue Peak High   Alternative School No Other KG 12 2020   k_12_total 3082.0 25.0 179.0 17.0   18.0       16.0 95.0   1809.0 1622.0     7.0   31.0   436.0     122.0   3432 3082 25 179 17   18       16 95   1809 1622     7 31 436   122   3432
1192715 1192715 UT     school 4901080 31 District Uintah District 490108001302 750 Ashley Valley Education Ctr.   Alternative School No High 09 12 2020   k_12_total 117.0 1.0 9.0 2.0   0.0       0.0 2.0   57.0 74.0     2.0   0.0   41.0     3.0   131 117 1 9 2   0       0 2   57 74     2 0 41   3   131
1192762 1192762 UT     school 4901140 33 District Washington District 490114000881 718 Millcreek High   Alternative School No High 09 12 2020   k_12_total 81.0 1.0 25.0 9.0   0.0       4.0 3.0   56.0 67.0     8.0   12.0   55.0     31.0   123 81 1 25 9   0       4 3   56 67     8 12 55   31   123
1192801 1192801 UT     school 4901200 35 District Weber District 490120001548 750 Horizon Academy   Alternative School No High 08 12 2020   k_12_total 44.0 3.0 31.0 1.0   1.0       0.0 6.0   59.0 27.0     7.0   3.0   53.0     3.0   86 44 3 31 1   1       0 6   59 27     7 3 53   3   86
1192826 1192826 UT     school 4901200 35 District Weber District 490120000972 730 Two Rivers High   Alternative School No High 09 12 2020   k_12_total 126.0 3.0 38.0 4.0   0.0       0.0 2.0   95.0 78.0     7.0   7.0   73.0     25.0   173 126 3 38 4   0       0 2   95 78     7 7 73   25   173
1192872 1192872 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2020   k_12_total 166.0 2.0 78.0 5.0   0.0       1.0 8.0   135.0 125.0     6.0   2.0   133.0     56.0   260 166 2 78 5   0       1 8   135 125     6 2 133   56   260
1192949 1192949 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2020   k_12_total 7.0 0.0 5.0 55.0   0.0       0.0 8.0   38.0 37.0     0.0   0.0   37.0     8.0   75 7 0 5 55   0       0 8   38 37     0 0 37   8   75
1193028 1193028 UT     school 4900030 01 District Alpine District 490003001435 782 Polaris High School   Alternative School No High 09 12 2020   kindergarten                                                   0                                             0
1193043 1193043 UT     school 4900030 01 District Alpine District 490003000366 730 Summit High   Alternative School No High 08 12 2020   kindergarten                                                   0                                             0
1193069 1193069 UT     school 4900090 03 District Box Elder District 490009000707 778 Sunrise High School   Alternative School No High 07 12 2020   kindergarten                                                   0                                             0
1193090 1193090 UT     school 4900120 04 District Cache District 490012000041 710 Cache Alternative High   Alternative School No High 08 12 2020   kindergarten                                                   0                                             0
1193130 1193130 UT     school 4900142 42 District Canyons District 490014201504 750 Diamond Ridge High School   Alternative School No High 10 12 2020   kindergarten                                                   0                                             0
1193227 1193227 UT     school 4900210 07 District Davis District 490021000823 730 Mountain High   Alternative School No High 10 12 2020   kindergarten                                                   0                                             0
1193240 1193240 UT     school 4900210 07 District Davis District 490021000306 733 Renaissance Academy   Alternative School No Other 01 12 2020   kindergarten                                                   0                                             0
1193329 1193329 UT     school 4900360 12 District Granite District 490036000220 740 Granite Connection High   Alternative School No Other KG 12 2020   kindergarten                                                   1                                             1
1193393 1193393 UT     school 4900360 12 District Granite District 490036001399 501 Youth Educational Support School   Alternative School No Other 01 12 2020   kindergarten                                                   0                                             0
1193408 1193408 UT     school 4900390 13 District Iron District 490039000872 750 Southwest Educational Academy   Alternative School No High 08 12 2020   kindergarten                                                   0                                             0
1193463 1193463 UT     school 4900420 14 District Jordan District 490042000329 716 Valley High School   Alternative School No High 10 12 2020   kindergarten                                                   0                                             0
1193535 1193535 UT     school 4900630 19 District Nebo District 490063000387 720 Landmark High   Alternative School No High 07 12 2020   kindergarten                                                   0                                             0
1193573 1193573 UT     school 4900660 20 District North Sanpete District 490066001431 801 Pleasant Creek School   Alternative School No High 08 12 2020   kindergarten                                                   0                                             0
1193581 1193581 UT     school 4900720 37 District Ogden City District 490072001265 729 George Washington High   Alternative School No High 10 12 2020   kindergarten                                                   0                                             0
1193621 1193621 UT     school 4900810 38 District Provo District 490081000836 730 Independence High   Alternative School No High 09 12 2020   kindergarten                                                   0                                             0
1193629 1193629 UT     school 4900810 38 District Provo District 490081000858 555 Slate Canyon   Alternative School No High 10 12 2020   kindergarten                                                   0                                             0
1193660 1193660 UT     school 4900870 36 District Salt Lake District 490087000732 750 Horizonte Instruction & Training Center   Alternative School No High 10 12 2020   kindergarten                                                   0                                             0
1193695 1193695 UT     school 4900930 26 District Sevier District 490093000900 716 Cedar Ridge High   Alternative School No High 07 12 2020   kindergarten                                                   0                                             0
1193727 1193727 UT     school 4901050 30 District Tooele District 490105000698 740 Blue Peak High   Alternative School No Other KG 12 2020   kindergarten                                                   420                                             420
1193752 1193752 UT     school 4901080 31 District Uintah District 490108001302 750 Ashley Valley Education Ctr.   Alternative School No High 09 12 2020   kindergarten                                                   0                                             0
1193799 1193799 UT     school 4901140 33 District Washington District 490114000881 718 Millcreek High   Alternative School No High 09 12 2020   kindergarten                                                   0                                             0
1193838 1193838 UT     school 4901200 35 District Weber District 490120001548 750 Horizon Academy   Alternative School No High 08 12 2020   kindergarten                                                   0                                             0
1193863 1193863 UT     school 4901200 35 District Weber District 490120000972 730 Two Rivers High   Alternative School No High 09 12 2020   kindergarten                                                   0                                             0
1193909 1193909 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2020   kindergarten                                                   0                                             0
1193986 1193986 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2020   kindergarten                                                   0                                             0
1194065 1194065 UT     school 4900030 01 District Alpine District 490003001435 782 Polaris High School   Alternative School No High 09 12 2020   grade_1                                                   0                                             0
1194080 1194080 UT     school 4900030 01 District Alpine District 490003000366 730 Summit High   Alternative School No High 08 12 2020   grade_1                                                   0                                             0
1194106 1194106 UT     school 4900090 03 District Box Elder District 490009000707 778 Sunrise High School   Alternative School No High 07 12 2020   grade_1                                                   0                                             0
1194127 1194127 UT     school 4900120 04 District Cache District 490012000041 710 Cache Alternative High   Alternative School No High 08 12 2020   grade_1                                                   0                                             0
1194167 1194167 UT     school 4900142 42 District Canyons District 490014201504 750 Diamond Ridge High School   Alternative School No High 10 12 2020   grade_1                                                   0                                             0
1194264 1194264 UT     school 4900210 07 District Davis District 490021000823 730 Mountain High   Alternative School No High 10 12 2020   grade_1                                                   0                                             0
1194277 1194277 UT     school 4900210 07 District Davis District 490021000306 733 Renaissance Academy   Alternative School No Other 01 12 2020   grade_1                                                   1                                             1
1194366 1194366 UT     school 4900360 12 District Granite District 490036000220 740 Granite Connection High   Alternative School No Other KG 12 2020   grade_1                                                   3                                             3
1194430 1194430 UT     school 4900360 12 District Granite District 490036001399 501 Youth Educational Support School   Alternative School No Other 01 12 2020   grade_1                                                   0                                             0
1194445 1194445 UT     school 4900390 13 District Iron District 490039000872 750 Southwest Educational Academy   Alternative School No High 08 12 2020   grade_1                                                   0                                             0
1194500 1194500 UT     school 4900420 14 District Jordan District 490042000329 716 Valley High School   Alternative School No High 10 12 2020   grade_1                                                   0                                             0
1194572 1194572 UT     school 4900630 19 District Nebo District 490063000387 720 Landmark High   Alternative School No High 07 12 2020   grade_1                                                   0                                             0
1194610 1194610 UT     school 4900660 20 District North Sanpete District 490066001431 801 Pleasant Creek School   Alternative School No High 08 12 2020   grade_1                                                   0                                             0
1194618 1194618 UT     school 4900720 37 District Ogden City District 490072001265 729 George Washington High   Alternative School No High 10 12 2020   grade_1                                                   0                                             0
1194658 1194658 UT     school 4900810 38 District Provo District 490081000836 730 Independence High   Alternative School No High 09 12 2020   grade_1                                                   0                                             0
1194666 1194666 UT     school 4900810 38 District Provo District 490081000858 555 Slate Canyon   Alternative School No High 10 12 2020   grade_1                                                   0                                             0
1194697 1194697 UT     school 4900870 36 District Salt Lake District 490087000732 750 Horizonte Instruction & Training Center   Alternative School No High 10 12 2020   grade_1                                                   0                                             0
1194732 1194732 UT     school 4900930 26 District Sevier District 490093000900 716 Cedar Ridge High   Alternative School No High 07 12 2020   grade_1                                                   0                                             0
1194764 1194764 UT     school 4901050 30 District Tooele District 490105000698 740 Blue Peak High   Alternative School No Other KG 12 2020   grade_1                                                   354                                             354
1194789 1194789 UT     school 4901080 31 District Uintah District 490108001302 750 Ashley Valley Education Ctr.   Alternative School No High 09 12 2020   grade_1                                                   0                                             0
1194836 1194836 UT     school 4901140 33 District Washington District 490114000881 718 Millcreek High   Alternative School No High 09 12 2020   grade_1                                                   0                                             0
1194875 1194875 UT     school 4901200 35 District Weber District 490120001548 750 Horizon Academy   Alternative School No High 08 12 2020   grade_1                                                   0                                             0
1194900 1194900 UT     school 4901200 35 District Weber District 490120000972 730 Two Rivers High   Alternative School No High 09 12 2020   grade_1                                                   0                                             0
1194946 1194946 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2020   grade_1                                                   0                                             0
1195023 1195023 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2020   grade_1                                                   0                                             0
1195102 1195102 UT     school 4900030 01 District Alpine District 490003001435 782 Polaris High School   Alternative School No High 09 12 2020   grade_2                                                   0                                             0
1195117 1195117 UT     school 4900030 01 District Alpine District 490003000366 730 Summit High   Alternative School No High 08 12 2020   grade_2                                                   0                                             0
1195143 1195143 UT     school 4900090 03 District Box Elder District 490009000707 778 Sunrise High School   Alternative School No High 07 12 2020   grade_2                                                   0                                             0
1195164 1195164 UT     school 4900120 04 District Cache District 490012000041 710 Cache Alternative High   Alternative School No High 08 12 2020   grade_2                                                   0                                             0
1195204 1195204 UT     school 4900142 42 District Canyons District 490014201504 750 Diamond Ridge High School   Alternative School No High 10 12 2020   grade_2                                                   0                                             0
1195301 1195301 UT     school 4900210 07 District Davis District 490021000823 730 Mountain High   Alternative School No High 10 12 2020   grade_2                                                   0                                             0
1195314 1195314 UT     school 4900210 07 District Davis District 490021000306 733 Renaissance Academy   Alternative School No Other 01 12 2020   grade_2                                                   0                                             0
1195403 1195403 UT     school 4900360 12 District Granite District 490036000220 740 Granite Connection High   Alternative School No Other KG 12 2020   grade_2                                                   5                                             5
1195467 1195467 UT     school 4900360 12 District Granite District 490036001399 501 Youth Educational Support School   Alternative School No Other 01 12 2020   grade_2                                                   0                                             0
1195482 1195482 UT     school 4900390 13 District Iron District 490039000872 750 Southwest Educational Academy   Alternative School No High 08 12 2020   grade_2                                                   0                                             0
1195537 1195537 UT     school 4900420 14 District Jordan District 490042000329 716 Valley High School   Alternative School No High 10 12 2020   grade_2                                                   0                                             0
1195609 1195609 UT     school 4900630 19 District Nebo District 490063000387 720 Landmark High   Alternative School No High 07 12 2020   grade_2                                                   0                                             0
1195647 1195647 UT     school 4900660 20 District North Sanpete District 490066001431 801 Pleasant Creek School   Alternative School No High 08 12 2020   grade_2                                                   0                                             0
1195655 1195655 UT     school 4900720 37 District Ogden City District 490072001265 729 George Washington High   Alternative School No High 10 12 2020   grade_2                                                   0                                             0
1195695 1195695 UT     school 4900810 38 District Provo District 490081000836 730 Independence High   Alternative School No High 09 12 2020   grade_2                                                   0                                             0
1195703 1195703 UT     school 4900810 38 District Provo District 490081000858 555 Slate Canyon   Alternative School No High 10 12 2020   grade_2                                                   0                                             0
1195734 1195734 UT     school 4900870 36 District Salt Lake District 490087000732 750 Horizonte Instruction & Training Center   Alternative School No High 10 12 2020   grade_2                                                   0                                             0
1195769 1195769 UT     school 4900930 26 District Sevier District 490093000900 716 Cedar Ridge High   Alternative School No High 07 12 2020   grade_2                                                   0                                             0
1195801 1195801 UT     school 4901050 30 District Tooele District 490105000698 740 Blue Peak High   Alternative School No Other KG 12 2020   grade_2                                                   318                                             318
1195826 1195826 UT     school 4901080 31 District Uintah District 490108001302 750 Ashley Valley Education Ctr.   Alternative School No High 09 12 2020   grade_2                                                   0                                             0
1195873 1195873 UT     school 4901140 33 District Washington District 490114000881 718 Millcreek High   Alternative School No High 09 12 2020   grade_2                                                   0                                             0
1195912 1195912 UT     school 4901200 35 District Weber District 490120001548 750 Horizon Academy   Alternative School No High 08 12 2020   grade_2                                                   0                                             0
1195937 1195937 UT     school 4901200 35 District Weber District 490120000972 730 Two Rivers High   Alternative School No High 09 12 2020   grade_2                                                   0                                             0
1195983 1195983 UT     school 4900019 98 Charter Fast Forward High 490001900906 700 Fast Forward High   Alternative School Yes High 09 12 2020   grade_2                                                   0                                             0
1196060 1196060 UT     school 4900013 92 Charter Uintah River High 490001300671 700 Uintah River High   Alternative School Yes High 09 12 2020   grade_2                                                   0                                             0
1196139 1196139 UT     school 4900030 01 District Alpine District 490003001435 782 Polaris High School   Alternative School No High 09 12 2020   grade_3                                                   0                                             0
1196154 1196154 UT     school 4900030 01 District Alpine District 490003000366 730 Summit High   Alternative School No High 08 12 2020   grade_3                                                   0                                             0
1196180 1196180 UT     school 4900090 03 District Box Elder District 490009000707 778 Sunrise High School   Alternative School No High 07 12 2020   grade_3                                                   0                                             0
1196201 1196201 UT     school 4900120 04 District Cache District 490012000041 710 Cache Alternative High   Alternative School No High 08 12 2020   grade_3                                                   0                                             0
1196241 1196241 UT     school 4900142 42 District Canyons District 490014201504 750 Diamond Ridge High School   Alternative School No High 10 12 2020   grade_3                                                   0                                             0
1196338 1196338 UT     school 4900210 07 District Davis District 490021000823 730 Mountain High   Alternative School No High 10 12 2020   grade_3                                                   0                                             0
1196351 1196351 UT     school 4900210 07 District Davis District 490021000306 733 Renaissance Academy   Alternative School No Other 01 12 2020   grade_3                                                   1                                             1
1196440 1196440 UT     school 4900360 12 District Granite District 490036000220 740 Granite Connection High   Alternative School No Other KG 12 2020   grade_3                                                   7                                             7
1196504 1196504 UT     school 4900360 12 District Granite District 490036001399 501 Youth Educational Support School   Alternative School No Other 01 12 2020   grade_3                                                   0                                             0
1196519 1196519 UT     school 4900390 13 District Iron District 490039000872 750 Southwest Educational Academy   Alternative School No High 08 12 2020   grade_3                                                   0                                             0
1196574 1196574 UT     school 4900420 14 District Jordan District 490042000329 716 Valley High School   Alternative School No High 10 12 2020   grade_3                                                   0                                             0
1196646 1196646 UT     school 4900630 19 District Nebo District 490063000387 720 Landmark High   Alternative School No High 07 12 2020   grade_3                                                   0                                             0
1196684 1196684 UT     school 4900660 20 District North Sanpete District 490066001431 801 Pleasant Creek School   Alternative School No High 08 12 2020   grade_3                                                   0                                             0
1196692 1196692 UT     school 4900720 37 District Ogden City District 490072001265 729 George Washington High   Alternative School No High 10 12 2020   grade_3                                                   0                                             0
1196732 1196732 UT     school 4900810 38 District Provo District 490081000836 730 Independence High   Alternative School No High 09 12 2020   grade_3                                                   0                                             0
1196740 1196740 UT     school 4900810 38 District Provo District 490081000858 555 Slate Canyon   Alternative School No High 10 12 2020   grade_3                                                   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]);