Data source: Big Local News · About: Big Local

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

View and edit SQL

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
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
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
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
711430 CO     school 803360 880   DENVER COUNTY 1 80336000320 1106 BRYANT WEBSTER DUAL LANGUAGE ECE-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 0 0 49   0 0     0   0   23 26                       49 0 0 49   0 0     0   0   23 26                 49
711649 CO     school 803360 880   DENVER COUNTY 1 80336006516 2188 DENVER CENTER FOR 21ST LEARNING AT WYMAN   Alternative School No Other 06 12 2017   grade_7 0 3 3   0 0     0   0   3 3                       6 0 3 3   0 0     0   0   3 3                 6
711861 CO     school 803360 880   DENVER COUNTY 1 80336001739 3647 MARIE L. GREENWOOD ACADEMY   Regular School No Elementary 01 08 2017   grade_7 0 7 53   1 1     0   1   36 27                       63 0 7 53   1 1     0   1   36 27                 63
711941 CO     school 803360 880   DENVER COUNTY 1 80336001928 4140 FARRELL B. HOWELL ECE-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 0 12 83   0 0     0   2   46 51                       97 0 12 83   0 0     0   2   46 51                 97
712308 CO     school 803360 880   DENVER COUNTY 1 80336001795 7163 P.R.E.P. (POSITIVE REFOCUS EDUCATION PROGRAM)   Alternative School No Other 06 12 2017   grade_7 0 2 1   0 0     0   0   1 2                       3 0 2 1   0 0     0   0   1 2                 3
712608 CO     school 803360 880   DENVER COUNTY 1 80336000426 9548 WHITTIER K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 0 8 10   1 1     0   2   13 9                       22 0 8 10   1 1     0   2   13 9                 22
718935 CO     school 804710 2620   HOLYOKE RE-1J 80471006610 2686 HOLYOKE ALTERNATIVE SCHOOL   Alternative School No High 07 12 2017   grade_7 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
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
710051 CO     school 806090 240   PRITCHETT RE-3 80609001952 7176 PRITCHETT MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
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
711105 CO     school 805100 550   NORTH CONEJOS RE-1J 80510006601 6339 NORTH CONEJOS ALTERNATIVE PROGRAM   Alternative School No Other KG 12 2017   grade_7 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
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
711150 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No Other PK 12 2017   grade_7 1 0 12   0 0     0   0   6 7                       13 1 0 12   0 0     0   0   6 7                 13
711549 CO     school 803360 880   DENVER COUNTY 1 80336006645 1939 COMPASS ACADEMY   Regular School Yes Middle 06 07 2017   grade_7 1 2 114   1 3     0   1   60 62                       122 1 2 114   1 3     0   1   60 62                 122
712217 CO     school 803360 880   DENVER COUNTY 1 80336001869 6350 BRUCE RANDOLPH SCHOOL   Regular School No Other 06 12 2017   grade_7 1 14 109   2 1     0   2   60 69                       129 1 14 109   2 1     0   2   60 69                 129
712421 CO     school 803360 880   DENVER COUNTY 1 80336002012 8085 STRIVE PREP - FEDERAL   Regular School Yes Middle 06 08 2017   grade_7 1 2 118   0 0     0   1   63 59                       122 1 2 118   0 0     0   1   63 59                 122
712454 CO     school 803360 880   DENVER COUNTY 1 80336006491 8145 SUMMIT ACADEMY   Alternative School No Other 06 12 2017   grade_7 1 0 20   0 0     0   0   8 13                       21 1 0 20   0 0     0   0   8 13                 21
712558 CO     school 803360 880   DENVER COUNTY 1 80336006514 8995 VISTA ACADEMY   Alternative School No Other 06 12 2017   grade_7 1 4 10   0 0     0   1   8 8                       16 1 4 10   0 0     0   1   8 8                 16
712659 CO     school 803360 880   DENVER COUNTY 1 80336001637 9739 WYATT ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 1 13 44   0 0     0   1   27 32                       59 1 13 44   0 0     0   1   27 32                 59
715075 CO     school 802790 1140   CANON CITY RE-1 80279006536 419 CANON ONLINE ACADEMY   Regular School No Other 06 12 2017   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
715474 CO     school 807080 1390   HUERFANO RE-1 80708001211 3306 GARDNER ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2017   grade_7 1 0 5   0 0     0   0   2 4                       6 1 0 5   0 0     0   0   2 4                 6
717069 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
717988 CO     school 806030 1870   PLATEAU RE-5 80603001023 6838 PEETZ JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
720411 CO     school 804410 3120   GREELEY 6 80441006638 8467 SALIDA DEL SOL ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 1 0 58   0 0     0   0   31 28                       59 1 0 58   0 0     0   0   31 28                 59
720548 CO     school 804440 3148   PAWNEE RE-12 80444000653 6812 PAWNEE SCHOOL PK-12   Regular School No Other PK 12 2017   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
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
721020 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_7 1 1 3   0 0     0   0   4 1                       5 1 1 3   0 0     0   0   4 1                 5
707991 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No Other 06 12 2017   grade_7 10 0 10   0 0     0   1   17 4                       21 10 0 10   0 0     0   1   17 4                 21
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
710125 CO     school 805250 290   LAS ANIMAS RE-1 80525006679 4279 IMMERSION SCHOOLS SCIENCE TECHNOLOGY ARTS   Regular School No Other 06 12 2017   grade_7 10 1 2   0 0     0   0   1 12                       13 10 1 2   0 0     0   0   1 12                 13
711599 CO     school 803360 880   DENVER COUNTY 1 80336006568 2167 DENVER MONTESSORI JUNIOR/SENIOR HIGH SCHOOL   Regular School No Other 07 10 2017   grade_7 10 2 35   0 1     0   1   22 27                       49 10 2 35   0 1     0   1   22 27                 49
713104 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006372 5405 EDCSD: COLORADO CYBER SCHOOL   Regular School No Other KG 12 2017   grade_7 10 0 1   1 0     0   0   5 7                       12 10 0 1   1 0     0   0   5 7                 12
714005 CO     school 803060 1010   COLORADO SPRINGS 11 80306006428 269 ACHIEVE ONLINE   Regular School No Other 06 12 2017   grade_7 10 0 4   0 0     0   2   8 8                       16 10 0 4   0 0     0   2   8 8                 16
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
719047 CO     school 804680 2670   HOLLY RE-3 80468006405 4069 HOLLY JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2017   grade_7 10 0 14   0 0     0   0   14 10                       24 10 0 14   0 0     0   0   14 10                 24
719649 CO     school 806300 2790   MOUNTAIN VALLEY RE 1 80630001415 6146 MOUNTAIN VALLEY SCHOOL   Regular School No Other PK 12 2017   grade_7 10 0 5   0 0     0   0   8 7                       15 10 0 5   0 0     0   0   8 7                 15
719779 CO     school 804860 2862   JULESBURG RE-1 80486000813 4492 JULESBURG HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 10 0 5   1 1     0   1   12 6                       18 10 0 5   1 1     0   1   12 6                 18
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
714988 CO     school 803870 1110   FALCON 49 80387002000 7463 ROCKY MOUNTAIN CLASSICAL ACADEMY   Regular School Yes Other KG 12 2017   grade_7 100 6 34   0 2     0   14   67 89                       156 100 6 34   0 2     0   14   67 89                 156
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
711242 CO     school 803330 870   DELTA COUNTY 50(J) 80333000296 2160 DELTA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 103 0 59   0 1     0   3   79 87                       166 103 0 59   0 1     0   3   79 87                 166
714906 CO     school 803870 1110   FALCON 49 80387001393 4102 HORIZON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 103 20 69   0 7     1   27   118 109                       227 103 20 69   0 7     1   27   118 109                 227
717937 CO     school 806690 1828   VALLEY RE-1 80669001154 8256 STERLING MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 103 2 29   0 0     0   4   85 53                       138 103 2 29   0 0     0   4   85 53                 138
718061 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000598 900 BOOKCLIFF MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 103 1 72   0 1     0   5   78 104                       182 103 1 72   0 1     0   5   78 104                 182
720300 CO     school 804410 3120   GREELEY 6 80441001696 2850 UNIVERSITY SCHOOLS   Regular School Yes Other KG 12 2017   grade_7 103 2 60   2 1     0   0   84 84                       168 103 2 60   2 1     0   0   84 84                 168
710388 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000908 5286 SUNSET MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 104 0 81   0 1     0   5   97 94                       191 104 0 81   0 1     0   5   97 94                 191
711910 CO     school 803360 880   DENVER COUNTY 1 80336000364 3990 HILL CAMPUS OF ARTS AND SCIENCES   Regular School No Middle 06 08 2017   grade_7 105 51 88   1 11     0   12   120 148                       268 105 51 88   1 11     0   12   120 148                 268
718272 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000619 6562 ORCHARD MESA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 105 2 46   0 1     0   5   90 69                       159 105 2 46   0 1     0   5   90 69                 159
714455 CO     school 805490 1030   MANITOU SPRINGS 14 80549000945 5464 MANITOU SPRINGS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 106 1 6   1 1     0   8   68 55                       123 106 1 6   1 1     0   8   68 55                 123
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
720265 CO     school 804410 3120   GREELEY 6 80441001614 1875 FRONTIER CHARTER ACADEMY   Regular School Yes Other KG 12 2017   grade_7 108 2 18   0 1     0   3   63 69                       132 108 2 18   0 1     0   3   63 69                 132
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
711888 CO     school 803360 880   DENVER COUNTY 1 80336000361 3746 HAMILTON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 109 49 115   0 13     0   21   155 152                       307 109 49 115   0 13     0   21   155 152                 307
718131 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000605 2392 EAST MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 109 2 33   1 2     0   10   78 79                       157 109 2 33   1 2     0   10   78 79                 157
709480 CO     school 803270 170   DEER TRAIL 26J 80327000288 2140 DEER TRAIL JUNIOR-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 11 0 5   0 0     0   0   7 9                       16 11 0 5   0 0     0   0   7 9                 16
711955 CO     school 803360 880   DENVER COUNTY 1 80336006554 4381 DSST: COLLEGE VIEW MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 11 1 134   0 9     1   1   82 75                       157 11 1 134   0 9     1   1   82 75                 157
712044 CO     school 803360 880   DENVER COUNTY 1 80336006442 4795 KUNSMILLER CREATIVE ARTS ACADEMY   Regular School No Other KG 12 2017   grade_7 11 2 124   1 7     0   2   69 78                       147 11 2 124   1 7     0   2   69 78                 147
715463 CO     school 807080 1390   HUERFANO RE-1 80708001845 63 PEAKVIEW SCHOOL   Regular School No Elementary PK 08 2017   grade_7 11 0 25   1 0     0   0   21 16                       37 11 0 25   1 0     0   0   21 16                 37
716875 CO     school 806780 1480   STRATTON R-4 80678000138 8351 STRATTON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 11 0 3   0 0     0   0   8 6                       14 11 0 3   0 0     0   0   8 6                 14
717786 CO     school 807260 1590   PRIMERO REORGANIZED 2 80726001255 7164 PRIMERO JUNIOR-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 11 0 4   0 1     0   0   6 10                       16 11 0 4   0 1     0   0   6 10                 16
717957 CO     school 803930 1850   FRENCHMAN RE-3 80393000512 2988 FLEMING HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 11 0 2   0 1     0   0   8 6                       14 11 0 2   0 1     0   0   8 6                 14
719500 CO     school 803300 2730   DEL NORTE C-7 80330000289 2148 DEL NORTE MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_7 11 0 11   0 0     0   2   14 10                       24 11 0 11   0 0     0   2   14 10                 24
719588 CO     school 806660 2770   STEAMBOAT SPRINGS RE-2 80666001749 6363 NORTH ROUTT CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 11 0 0   0 0     0   0   8 3                       11 11 0 0   0 0     0   0   8 3                 11
719794 CO     school 806000 2865   REVERE SCHOOL DISTRICT 80600001021 7322 REVERE JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 11 0 0   0 0     0   0   5 6                       11 11 0 0   0 0     0   0   5 6                 11
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
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
714305 CO     school 803060 1010   COLORADO SPRINGS 11 80306000263 7523 RUSSELL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 110 16 61   1 2     2   24   100 116                       216 110 16 61   1 2     2   24   100 116                 216
713847 CO     school 806480 990   WIDEFIELD 3 80648001120 4394 JANITELL JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2017   grade_7 111 31 66   2 0     3   24   138 99                       237 111 31 66   2 0     3   24   138 99                 237
716994 CO     school 803480 1520   DURANGO 9-R 80348000452 5888 MILLER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 113 1 23   6 2     0   4   68 81                       149 113 1 23   6 2     0   4   68 81                 149
708549 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006362 7131 PRAIRIE VIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 118 2 120   0 13     2   7   123 139                       262 118 2 120   0 13     2   7   123 139                 262
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
707921 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2017   grade_7 12 0 37   0 1     0   0   23 27                       50 12 0 37   0 1     0   0   23 27                 50
708875 CO     school 806540 123   SHERIDAN 2 80654001135 7837 FORT LOGAN NORTHGATE   Regular School No Elementary 03 08 2017   grade_7 12 2 83   0 2     1   1   48 53                       101 12 2 83   0 2     1   1   48 53                 101
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
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
710071 CO     school 806630 250   SPRINGFIELD RE-4 80663001142 8168 SPRINGFIELD JUNIOR/SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 12 2 1   0 0     0   1   9 7                       16 12 2 1   0 0     0   1   9 7                 16
710109 CO     school 805250 290   LAS ANIMAS RE-1 80525006678 443 AIM GLOBAL   Regular School No Other 06 12 2017   grade_7 12 0 12   0 0     0   0   13 11                       24 12 0 12   0 0     0   0   13 11                 24
710151 CO     school 805580 310   MC CLAVE RE-2 80558000963 5670 MC CLAVE UNDIVIDED HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 12 0 0   0 0     0   0   5 7                       12 12 0 0   0 0     0   0   5 7                 12
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
715185 CO     school 804260 1180   ROARING FORK RE-1 80426001505 429 CARBONDALE COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 12 0 3   0 0     0   0   5 10                       15 12 0 3   0 0     0   0   5 10                 15
718849 CO     school 805970 2580   OURAY R-1 80597001662 6598 OURAY MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 12 0 0   0 0     0   0   8 4                       12 12 0 0   0 0     0   0   8 4                 12
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
719155 CO     school 806120 2690   PUEBLO CITY 60 80612001046 1504 GOODNIGHT ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2017   grade_7 12 1 21   0 0     0   0   19 15                       34 12 1 21   0 0     0   0   19 15                 34
719952 CO     school 805940 3050   OTIS R-3 80594001017 6586 OTIS JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 12 0 1   0 0     0   1   7 7                       14 12 0 1   0 0     0   1   7 7                 14
720229 CO     school 804410 3120   GREELEY 6 80441001990 54 BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY   Regular School No Elementary KG 08 2017   grade_7 12 9 108   0 0     0   0   60 69                       129 12 9 108   0 0     0   0   60 69                 129
717480 CO     school 805400 1560   THOMPSON R2-J 80540000925 510 CONRAD BALL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 120 4 43   2 5     1   6   101 80                       181 120 4 43   2 5     1   6   101 80                 181
718554 CO     school 805790 2180   MONTROSE COUNTY RE-1J 80579000989 6054 COLUMBINE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 120 2 50   2 1     0   5   86 94                       180 120 2 50   2 1     0   5   86 94                 180
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
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
717712 CO     school 805400 1560   THOMPSON R2-J 80540001286 9228 WALT CLARK MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 121 0 27   0 4     0   4   82 74                       156 121 0 27   0 4     0   4   82 74                 156
718384 CO     school 805730 2020   MOFFAT COUNTY RE:NO 1 80573000977 1938 CRAIG MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 121 0 51   2 1     0   3   95 83                       178 121 0 51   2 1     0   3   95 83                 178
715999 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001921 4404 JEFFERSON ACADEMY   Regular School Yes Other KG 12 2017   grade_7 122 1 20   0 8     0   9   75 85                       160 122 1 20   0 8     0   9   75 85                 160
716242 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001317 6090 MOORE MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 122 0 82   1 6     1   7   106 113                       219 122 0 82   1 6     1   7   106 113                 219
716289 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000760 6330 NORTH ARVADA MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 123 1 108   1 8     0   9   135 115                       250 123 1 108   1 8     0   9   135 115                 250
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
717142 CO     school 803990 1550   POUDRE R-1 80399000523 898 BOLTZ MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 124 2 42   1 0     1   3   86 87                       173 124 2 42   1 0     1   3   86 87                 173
712726 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 125 2 16   0 17     0   8   83 85                       168 125 2 16   0 17     0   8   83 85                 168

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