enrollments

Data source: Big Local News · About: Big Local

591 rows where grade = "grade_7", state = "CO" and year = 2017 sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 591 ✖

grade ✖

  • grade_7 · 591 ✖
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
711036 711036 CO     school 800001 520   CHEYENNE COUNTY RE-5 80000100215 1612 CHEYENNE WELLS JUNIOR/HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 12 0 3   0 0     0   0   10 5                       15 12 0 3   0 0     0   0   10 5                 15
720981 720981 CO     school 800004 9130   EXPEDITIONARY BOCES 80000400709 2840 ROCKY MOUNTAIN SCHOOL OF EXPEDITIONARY LEARNING   Regular School No Other KG 12 2017   grade_7 41 1 3   0 2     0   2   23 26                       49 41 1 3   0 2     0   2   23 26                 49
720558 720558 CO     school 800016 3200   YUMA 1 80001601819 9791 YUMA MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_7 23 1 36   0 0     0   0   28 32                       60 23 1 36   0 0     0   0   28 32                 60
720581 720581 CO     school 800017 3210   WRAY RD-2 80001701817 9729 BUCHANAN MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_7 34 0 16   0 0     0   0   25 25                       50 34 0 16   0 0     0   0   25 25                 50
720601 720601 CO     school 800018 3220   IDALIA RJ-3 80001801742 4231 IDALIA JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 11 0 7   1 0     0   0   9 10                       19 11 0 7   1 0     0   0   9 10                 19
720614 720614 CO     school 800019 3230   LIBERTY J-4 80001901744 5123 LIBERTY SCHOOL   Career and Technical School No Other PK 12 2017   grade_7 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
720629 720629 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_7 89 0 40   1 12     0   6   66 82                       148 89 0 40   1 12     0   6   66 82                 148
720731 720731 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001569 2035 CROWN POINTE CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 10 1 39   0 1     0   0   25 26                       51 10 1 39   0 1     0   0   25 26                 51
720641 720641 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 3 1 0   0 0     0   0   1 3                       4 3 1 0   0 0     0   0   1 3                 4
720795 720795 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001780 4277 INDIAN PEAKS CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 5 0 0   0 0     0   0   2 3                       5 5 0 0   0 0     0   0   2 3                 5
720707 720707 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001912 1791 COLORADO SPRINGS CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 27 4 15   0 1     0   1   26 22                       48 27 4 15   0 1     0   1   26 22                 48
720878 720878 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001913 7512 ROSS MONTESSORI SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 15 0 7   0 0     0   1   12 11                       23 15 0 7   0 0     0   1   12 11                 23
720854 720854 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002002010 6913 THE PINNACLE CHARTER SCHOOL MIDDLE   Regular School Yes Middle 06 08 2017   grade_7 28 2 129   3 7     0   0   85 84                       169 28 2 129   3 7     0   0   85 84                 169
720656 720656 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002002018 653 STONE CREEK SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 25 0 10   0 0     0   2   14 23                       37 25 0 10   0 0     0   2   14 23                 37
720673 720673 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002002033 655 HIGH POINT ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 16 32 28   2 0     0   1   35 44                       79 16 32 28   2 0     0   1   35 44                 79
720695 720695 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006305 1279 CAPROCK ACADEMY   Regular School Yes Other KG 12 2017   grade_7 46 3 3   0 3     0   1   30 26                       56 46 3 3   0 3     0   1   30 26                 56
720868 720868 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006320 7278 RICARDO FLORES MAGON ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 0 0 34   0 0     0   0   22 12                       34 0 0 34   0 0     0   0   22 12                 34
720921 720921 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006338 8929 PIKES PEAK PREP   Regular School Yes Other KG 12 2017   grade_7 18 2 7   0 0     0   0   11 16                       27 18 2 7   0 0     0   0   11 16                 27
720752 720752 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006390 2837 EARLY COLLEGE OF ARVADA   Regular School Yes Other 06 12 2017   grade_7 22 0 29   0 10     0   1   34 28                       62 22 0 29   0 10     0   1   34 28                 62
720908 720908 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other 06 12 2017   grade_7 69 2 18   0 2     0   4   47 48                       95 69 2 18   0 2     0   4   47 48                 95
720822 720822 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 60 0 3   0 0     0   0   39 24                       63 60 0 3   0 0     0   0   39 24                 63
720783 720783 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006503 3439 GLOBAL VILLAGE ACADEMY - NORTHGLENN   Regular School Yes Elementary KG 08 2017   grade_7 18 5 34   1 1     0   0   30 29                       59 18 5 34   1 1     0   0   30 29                 59
720739 720739 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006542 2067 COLORADO EARLY COLLEGE FORT COLLINS   Regular School Yes Other 06 12 2017   grade_7 51 2 11   0 2     0   1   29 38                       67 51 2 11   0 2     0   1   29 38                 67
720932 720932 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006579 9040 VICTORY PREPARATORY ACADEMY MIDDLE STATE CHARTER SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 1 0 66   0 0     0   0   29 38                       67 1 0 66   0 0     0   0   29 38                 67
720762 720762 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006586 3326 GLOBAL VILLAGE ACADEMY - COLORADO SPRINGS   Regular School Yes Elementary KG 08 2017   grade_7 6 3 3   0 1     1   1   4 11                       15 6 3 3   0 1     1   1   4 11                 15
720831 720831 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006589 5851 MOUNTAIN SONG COMMUNITY SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 18 0 4   0 1     0   1   12 12                       24 18 0 4   0 1     0   1   12 12                 24
720772 720772 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006596 3399 GLOBAL VILLAGE ACADEMY - FORT COLLINS   Regular School Yes Elementary KG 08 2017   grade_7 8 0 1   0 0     0   0   4 5                       9 8 0 1   0 0     0   0   4 5                 9
720899 720899 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006635 8821 TWO RIVERS COMMUNITY SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 19 1 5   0 1     0   0   10 16                       26 19 1 5   0 1     0   0   10 16                 26
720888 720888 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006651 8061 SALIDA MONTESSORI CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_7 11 0 0   0 0     0   1   6 6                       12 11 0 0   0 0     0   1   6 6                 12
720950 720950 CO     school 800023 9000   COLORADO SCHOOL FOR THE DEAF AND BLIND 80002306410 1924 COLORADO SCHOOL FOR THE DEAF AND BLIND   Special Education School No Other PK 12 2017   grade_7 8 1 4   0 1     0   0   8 6                       14 8 1 4   0 1     0   0   8 6                 14
720995 720995 CO     school 800282 9170   COLORADO DIGITAL BOCES 80028206600 1550 COLORADO PREP ACADEMY   Regular School No Other KG 12 2017   grade_7 108 6 18   4 1     0   11   77 71                       148 108 6 18   4 1     0   11   77 71                 148
714489 714489 CO     school 801920 1040   ACADEMY 20 80192000001 74 CHALLENGER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 224 7 30   1 19     2   20   157 146                       303 224 7 30   1 19     2   20   157 146                 303
714505 714505 CO     school 801920 1040   ACADEMY 20 80192000858 209 ASPEN VALLEY CAMPUS   Alternative School No High 07 12 2017   grade_7 22 0 2   0 0     0   2   18 8                       26 22 0 2   0 0     0   2   18 8                 26
714581 714581 CO     school 801920 1040   ACADEMY 20 80192001402 2358 EAGLEVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 230 9 41   0 9     0   25   148 166                       314 230 9 41   0 9     0   25   148 166                 314
714705 714705 CO     school 801920 1040   ACADEMY 20 80192001462 8851 TIMBERVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 258 13 58   2 8     3   23   189 176                       365 258 13 58   2 8     3   23   189 176                 365
714634 714634 CO     school 801920 1040   ACADEMY 20 80192001593 6140 MOUNTAIN RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 238 10 61   2 21     0   18   169 181                       350 238 10 61   2 21     0   18   169 181                 350
714536 714536 CO     school 801920 1040   ACADEMY 20 80192001931 1629 THE CLASSICAL ACADEMY MIDDLE SCHOOL   Regular School Yes Middle 07 08 2017   grade_7 201 1 23   1 7     2   12   123 124                       247 201 1 23   1 7     2   12   123 124                 247
714691 714691 CO     school 801920 1040   ACADEMY 20 80192006447 8779 TCA COLLEGE PATHWAYS   Regular School Yes High 07 12 2017   grade_7 43 2 5   0 2     0   3   29 26                       55 43 2 5   0 2     0   3   29 26                 55
714550 714550 CO     school 801920 1040   ACADEMY 20 80192006478 1901 ACADEMY CALVERT K-8 ONLINE SCHOOL   Regular School No Elementary KG 08 2017   grade_7 13 1 0   0 0     0   1   5 10                       15 13 1 0   0 0     0   1   5 10                 15
714555 714555 CO     school 801920 1040   ACADEMY 20 80192006616 1921 DISCOVERY CANYON CAMPUS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 269 12 49   1 22     0   26   187 192                       379 269 12 49   1 22     0   26   187 192                 379
708352 708352 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 36 6 224   1 3     1   5   150 126                       276 36 6 224   1 3     1   5   150 126                 276
708390 708390 CO     school 801950 30   ADAMS COUNTY 14 80195000015 4516 KEARNEY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 30 13 216   2 0     0   1   139 123                       262 30 13 216   2 0     0   1   139 123                 262
717816 717816 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000023 66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 3 0 4   0 0     0   0   3 4                       7 3 0 4   0 0     0   0   3 4                 7
719914 719914 CO     school 802040 3030   AKRON R-1 80204000024 86 AKRON ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2017   grade_7 26 0 4   0 3     0   0   18 15                       33 26 0 4   0 3     0   0   18 15                 33
708777 708777 CO     school 802070 100   ALAMOSA RE-11J 80207000026 114 ORTEGA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 61 1 112   3 1     0   5   94 89                       183 61 1 112   3 1     0   5   94 89                 183
708796 708796 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   grade_7 0 0 3   0 0     0   0   2 1                       3 0 0 3   0 0     0   0   2 1                 3
711133 711133 CO     school 802130 580   SOUTH CONEJOS RE-10 80213001464 250 ANTONITO MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 1 0 17   0 0     0   1   6 13                       19 1 0 17   0 0     0   1   6 13                 19
710019 710019 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000040 6657 PAGOSA SPRINGS MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_7 108 1 11   15 1     1   4   74 67                       141 108 1 11   15 1     1   4   74 67                 141
719936 719936 CO     school 802220 3040   ARICKAREE R-2 80222000042 308 ARICKAREE UNDIVIDED HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 7 0 1   0 0     0   0   5 3                       8 7 0 1   0 0     0   0   5 3                 8
716845 716845 CO     school 802260 1450   ARRIBA-FLAGLER C-20 80226000509 2960 FLAGLER PUBLIC SCHOOL   Regular School No Other PK 12 2017   grade_7 10 0 1   0 0     0   0   7 4                       11 10 0 1   0 0     0   0   7 4                 11
718988 718988 CO     school 802280 2640   ASPEN 1 80228000046 430 ASPEN MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_7 96 4 10   0 4     0   1   57 58                       115 96 4 10   0 4     0   1   57 58                 115
718975 718975 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_7 12 0 0   0 0     0   0   7 5                       12 12 0 0   0 0     0   0   7 5                 12
720499 720499 CO     school 802310 3145   AULT-HIGHLAND RE-9 80231001466 3961 HIGHLAND MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 54 0 18   0 1     0   0   39 34                       73 54 0 18   0 1     0   0   39 34                 73
709539 709539 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000054 464 AURORA HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 31 66 168   2 13     2   12   147 147                       294 31 66 168   2 13     2   12   147 147                 294
709559 709559 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000055 914 BOSTON K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 0 6 28   0 4     0   0   20 18                       38 0 6 28   0 4     0   0   20 18                 38
709583 709583 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000057 1720 CLYDE MILLER K-8   Regular School No Elementary PK 08 2017   grade_7 7 8 42   0 0     0   5   35 27                       62 7 8 42   0 0     0   5   35 27                 62
709617 709617 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000060 2384 EAST MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 19 43 232   1 11     4   16   179 147                       326 19 43 232   1 11     4   16   179 147                 326
709749 709749 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000073 6160 MRACHEK MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 56 61 130   1 10     1   16   150 125                       275 56 61 130   1 10     1   16   150 125                 275
709764 709764 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000074 6310 NORTH MIDDLE SCHOOL HEALTH SCIENCES AND TECHNOLOGY CAMPUS   Regular School No Middle 06 08 2017   grade_7 18 34 196   2 9     3   7   139 130                       269 18 34 196   2 9     3   7   139 130                 269
709847 709847 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000079 8078 SOUTH MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 14 39 157   0 9     6   7   129 103                       232 14 39 157   0 9     6   7   129 103                 232
709930 709930 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000082 9396 AURORA WEST COLLEGE PREPARATORY ACADEMY   Regular School No Other 06 12 2017   grade_7 14 37 205   3 36     0   1   165 131                       296 14 37 205   3 36     0   1   165 131                 296
709589 709589 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001322 1800 COLUMBIA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 71 46 117   4 10     1   21   150 120                       270 71 46 117   4 10     1   21   150 120                 270
709811 709811 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001674 7232 AURORA QUEST K-8   Regular School No Elementary KG 08 2017   grade_7 47 8 21   3 11     1   4   43 52                       95 47 8 21   3 11     1   4   43 52                 95
709534 709534 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 13 10 19   1 0     0   2   21 24                       45 13 10 19   1 0     0   2   21 24                 45
709776 709776 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001789 6546 OPTIONS SCHOOL   Regular School No Other KG 12 2017   grade_7 63 4 6   0 2     0   4   37 42                       79 63 4 6   0 2     0   4   37 42                 79
709758 709758 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001881 6189 MURPHY CREEK K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 23 16 21   2 2     0   5   41 28                       69 23 16 21   2 2     0   5   41 28                 69
709725 709725 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2017   grade_7 12 23 39   1 5     0   0   46 34                       80 12 23 39   1 5     0   0   46 34                 80
709548 709548 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234002009 465 AURORA FRONTIER K-8   Regular School No Elementary PK 08 2017   grade_7 22 16 18   0 14     0   4   41 33                       74 22 16 18   0 14     0   4   41 33                 74
709666 709666 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes Elementary KG 08 2017   grade_7 9 15 66   0 0     0   0   38 52                       90 9 15 66   0 0     0   0   38 52                 90
709868 709868 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006322 9056 VANGUARD CLASSICAL SCHOOL - WEST   Regular School Yes Elementary KG 08 2017   grade_7 10 12 26   0 0     0   1   29 20                       49 10 12 26   0 0     0   1   29 20                 49
709502 709502 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006399 213 AXL ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 12 13 24   0 1     0   0   24 26                       50 12 13 24   0 1     0   0   24 26                 50
709894 709894 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006483 9083 VISTA PEAK P-8 EXPLORATORY   Regular School No Elementary PK 08 2017   grade_7 19 19 44   3 2     0   4   51 40                       91 19 19 44   3 2     0   4   51 40                 91
709921 709921 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes Other KG 12 2017   grade_7 13 23 29   1 1     1   2   20 50                       70 13 23 29   1 1     1   2   20 50                 70
709633 709633 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006644 2673 EDNA AND JOHN W. MOSLEY P-8   Regular School No Elementary PK 08 2017   grade_7 17 15 49   2 1     5   3   49 43                       92 17 15 49   2 1     5   3   49 43                 92
718890 718890 CO     school 802370 2600   PLATTE CANYON 1 80237001325 7048 FITZSIMMONS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 63 0 11   1 0     0   7   37 45                       82 63 0 11   1 0     0   7   37 45                 82
717042 717042 CO     school 802400 1530   BAYFIELD 10 JT-R 80240000089 636 BAYFIELD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 77 0 15   2 0     0   6   52 48                       100 77 0 15   2 0     0   6   52 48                 100
708617 708617 CO     school 802430 50   BENNETT 29J 80243000093 774 BENNETT MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 52 0 19   1 0     0   4   36 40                       76 52 0 19   1 0     0   4   36 40                 76
716892 716892 CO     school 802460 1490   BETHUNE R-5 80246000095 842 BETHUNE PUBLIC SCHOOLS   Regular School No Other PK 12 2017   grade_7 9 0 2   0 0     0   0   7 4                       11 9 0 2   0 0     0   0   7 4                 11
710620 710620 CO     school 802490 480   BOULDER VALLEY RE 2 80249000102 1066 BROOMFIELD HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 121 1 50   1 5     1   4   91 92                       183 121 1 50   1 5     1   4   91 92                 183
710629 710629 CO     school 802490 480   BOULDER VALLEY RE 2 80249000104 1136 MANHATTAN MIDDLE SCHOOL OF THE ARTS AND ACADEMICS   Regular School No Middle 06 08 2017   grade_7 96 2 31   1 6     0   8   71 73                       144 96 2 31   1 6     0   8   71 73                 144
710633 710633 CO     school 802490 480   BOULDER VALLEY RE 2 80249000106 1352 CASEY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 121 3 85   2 6     0   9   120 106                       226 121 3 85   2 6     0   9   120 106                 226
710642 710642 CO     school 802490 480   BOULDER VALLEY RE 2 80249000108 1390 CENTENNIAL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 148 0 48   2 9     0   4   107 104                       211 148 0 48   2 9     0   4   107 104                 211
710804 710804 CO     school 802490 480   BOULDER VALLEY RE 2 80249000122 4878 ANGEVINE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 118 5 92   1 8     0   10   133 101                       234 118 5 92   1 8     0   10   133 101                 234
710816 710816 CO     school 802490 480   BOULDER VALLEY RE 2 80249000125 5306 LOUISVILLE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 170 2 28   1 6     0   8   107 108                       215 170 2 28   1 6     0   8   107 108                 215
710869 710869 CO     school 802490 480   BOULDER VALLEY RE 2 80249000131 6212 NEDERLAND MIDDLE-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 37 1 1   0 3     0   1   17 26                       43 37 1 1   0 3     0   1   17 26                 43
710874 710874 CO     school 802490 480   BOULDER VALLEY RE 2 80249000132 6224 NEVIN PLATT MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 161 1 20   0 7     0   20   112 97                       209 161 1 20   0 7     0   20   112 97                 209
710928 710928 CO     school 802490 480   BOULDER VALLEY RE 2 80249000134 8135 SOUTHERN HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 145 2 10   2 16     0   13   104 84                       188 145 2 10   2 16     0   13   104 84                 188
710750 710750 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No Other 06 12 2017   grade_7 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
710932 710932 CO     school 802490 480   BOULDER VALLEY RE 2 80249001517 8387 SUMMIT MIDDLE CHARTER SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 77 0 8   0 24     0   10   74 45                       119 77 0 8   0 24     0   10   74 45                 119
710847 710847 CO     school 802490 480   BOULDER VALLEY RE 2 80249001573 6000 MONARCH K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 126 2 10   1 9     0   11   72 87                       159 126 2 10   1 9     0   11   72 87                 159
710563 710563 CO     school 802490 480   BOULDER VALLEY RE 2 80249001758 441 ASPEN CREEK K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 124 2 16   1 6     0   9   76 82                       158 124 2 16   1 6     0   9   76 82                 158
710699 710699 CO     school 802490 480   BOULDER VALLEY RE 2 80249001771 2589 ELDORADO K-8 SCHOOL   Regular School No Elementary KG 08 2017   grade_7 126 1 7   0 15     0   10   85 74                       159 126 1 7   0 15     0   10   85 74                 159
710897 710897 CO     school 802490 480   BOULDER VALLEY RE 2 80249001792 6816 PEAK TO PEAK CHARTER SCHOOL   Regular School Yes Other KG 12 2017   grade_7 103 0 8   0 17     0   7   61 74                       135 103 0 8   0 17     0   7   61 74                 135
710781 710781 CO     school 802490 480   BOULDER VALLEY RE 2 80249002013 4496 JUSTICE HIGH CHARTER SCHOOL   Alternative School Yes Other 06 12 2017   grade_7 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
710883 710883 CO     school 802490 480   BOULDER VALLEY RE 2 80249006199 6642 HORIZONS K-8 SCHOOL   Alternative School Yes Elementary KG 08 2017   grade_7 34 0 2   0 1     0   2   21 18                       39 34 0 2   0 1     0   2   21 18                 39
710610 710610 CO     school 802490 480   BOULDER VALLEY RE 2 80249006463 930 BOULDER UNIVERSAL   Regular School No Other KG 12 2017   grade_7 7 0 0   0 0     0   0   3 4                       7 7 0 0   0 0     0   0   3 4                 7
717843 717843 CO     school 802520 1750   BRANSON REORGANIZED 82 80252000141 978 BRANSON SCHOOL   Regular School No Other PK 12 2017   grade_7 2 0 2   0 0     0   2   4 2                       6 2 0 2   0 0     0   2   4 2                 6
717829 717829 CO     school 802520 1750   BRANSON REORGANIZED 82 80252001728 948 BRANSON SCHOOL ONLINE   Regular School No Other KG 12 2017   grade_7 40 2 5   0 0     0   0   18 29                       47 40 2 5   0 0     0   0   18 29                 47
720519 720519 CO     school 802550 3146   BRIGGSDALE RE-10 80255000143 1012 BRIGGSDALE UNDIVIDED HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 13 0 1   0 0     0   0   5 9                       14 13 0 1   0 0     0   0   5 9                 14
708595 708595 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000152 9230 VIKAN MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 58 3 130   0 1     0   2   107 87                       194 58 3 130   0 1     0   2   107 87                 194

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