Data source: Big Local News · About: Big Local

4,236 rows where grade = "grade_7" and state = "CO"

View and edit SQL

year

grade

  • grade_7 · 4,136
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
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
710178 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006530 71 ASPEN RIDGE PREPARATORY SCHOOL   Regular School Yes Elementary KG 07 2017   grade_7 6 1 3   0 0     0   1   7 4                       11 6 1 3   0 0     0   1   7 4                 11
710191 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006539 120 APEX HOME SCHOOL ENRICHMENT PROGRAM   Regular School No Other KG 12 2017   grade_7 40 0 7   0 2     0   2   29 22                       51 40 0 7   0 2     0   2   29 22                 51
710197 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001886 226 ALTONA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 213 8 26   0 25     1   9   133 149                       282 213 8 26   0 25     1   9   133 149                 282
710245 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001887 1284 CARBON VALLEY ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 4 1 4   0 0     0   0   8 1                       9 4 1 4   0 0     0   0   8 1                 9
710286 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000900 2760 ERIE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 298 3 37   0 9     0   6   165 188                       353 298 3 37   0 9     0   6   165 188                 353
710309 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001890 2964 FLAGSTAFF CHARTER ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 89 0 6   1 5     0   2   47 56                       103 89 0 6   1 5     0   2   47 56                 103
710321 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000901 3192 THUNDER VALLEY PK-8   Regular School No Elementary PK 08 2017   grade_7 45 0 56   0 0     0   3   54 50                       104 45 0 56   0 0     0   3   54 50                 104
710327 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001774 3194 COAL RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 203 0 65   1 3     0   5   155 122                       277 203 0 65   1 3     0   5   155 122                 277
710358 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006388 4333 IMAGINE CHARTER   Regular School Yes Elementary PK 08 2017   grade_7 37 0 6   0 0     0   1   21 23                       44 37 0 6   0 0     0   1   21 23                 44
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
710393 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000910 5288 LONGS PEAK MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_7 44 2 74   1 1     0   0   70 52                       122 44 2 74   1 1     0   0   70 52                 122
710409 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 51 0 9   0 0     0   2   26 36                       62 51 0 9   0 0     0   2   26 36                 62
710428 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000915 5730 MEAD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 131 1 29   1 2     0   2   93 73                       166 131 1 29   1 2     0   2   93 73                 166
710437 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006594 6010 TIMBERLINE PK-8   Regular School No Elementary PK 08 2017   grade_7 9 1 106   1 4     0   2   70 53                       123 9 1 106   1 4     0   2   70 53                 123
710499 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006430 7565 ST. VRAIN COMMUNITY MONTESSORI SCHOOL   Regular School Yes Elementary PK 08 2017   grade_7 13 0 0   0 0     0   0   7 6                       13 13 0 0   0 0     0   0   7 6                 13
710530 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001891 8903 TRAIL RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 86 0 128   3 6     1   2   103 123                       226 86 0 128   3 6     1   2   103 123                 226
710542 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001572 8927 TWIN PEAKS CHARTER ACADEMY   Regular School Yes Other KG 12 2017   grade_7 48 2 42   1 4     0   3   44 56                       100 48 2 42   1 4     0   3   44 56                 100
710549 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006198 9430 WESTVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 180 4 53   0 6     0   7   150 100                       250 180 4 53   0 6     0   7   150 100                 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
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
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 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 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 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
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
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
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
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 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
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
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 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
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
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
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
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
710963 CO     school 802640 490   BUENA VISTA R-31 80264000158 1132 HARRY L MC GINNIS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 66 1 8   0 0     1   0   42 34                       76 66 1 8   0 0     1   0   42 34                 76
710981 CO     school 806330 500   SALIDA R-32 80633006500 1554 CREST ACADEMY   Regular School No Middle 05 08 2017   grade_7 5 0 1   0 0     0   0   2 4                       6 5 0 1   0 0     0   0   2 4                 6
710991 CO     school 806330 500   SALIDA R-32 80633001107 4680 SALIDA MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_7 61 0 11   2 1     0   5   40 40                       80 61 0 11   2 1     0   5   40 40                 80
711020 CO     school 805040 510   KIT CARSON R-1 80504000826 4742 KIT CARSON JUNIOR-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 5 0 2   0 0     0   0   5 2                       7 5 0 2   0 0     0   0   5 2                 7
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
711040 CO     school 803000 540   CLEAR CREEK RE-1 80300006157 1660 CLEAR CREEK MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 50 0 3   3 0     0   5   35 26                       61 50 0 3   3 0     0   5   35 26                 61
711076 CO     school 805100 550   NORTH CONEJOS RE-1J 80510000842 1276 CENTAURI MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 28 2 40   2 0     0   0   38 34                       72 28 2 40   2 0     0   0   38 34                 72
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
711121 CO     school 806390 560   SANFORD 6J 80639001114 7616 SANFORD JUNIOR/SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 19 0 9   0 0     0   1   13 16                       29 19 0 9   0 0     0   1   13 16                 29
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
711165 CO     school 804140 740   SIERRA GRANDE R-30 80414000572 7880 SIERRA GRANDE K-12 SCHOOL   Regular School No Other PK 12 2017   grade_7 3 1 14   0 0     0   0   10 8                       18 3 1 14   0 0     0   0   10 8                 18
711183 CO     school 803210 770   CROWLEY COUNTY RE-1-J 80321000282 2058 CROWLEY COUNTY JUNIOR AND SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 21 3 17   1 0     0   0   18 24                       42 21 3 17   1 0     0   0   18 24                 42
711196 CO     school 807200 860   CUSTER COUNTY SCHOOL DISTRICT C-1 80720001732 2091 CUSTER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 23 1 0   0 0     0   0   12 12                       24 23 1 0   0 0     0   0   12 12                 24
711218 CO     school 803330 870   DELTA COUNTY 50(J) 80333001334 1375 CEDAREDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 53 0 6   1 0     0   3   26 37                       63 53 0 6   1 0     0   3   26 37                 63
711233 CO     school 803330 870   DELTA COUNTY 50(J) 80333002001 2152 DELTA ACADEMY OF APPLIED LEARNING   Alternative School No Middle 05 08 2017   grade_7 2 0 2   0 0     0   1   0 5                       5 2 0 2   0 0     0   1   0 5                 5
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
711259 CO     school 803330 870   DELTA COUNTY 50(J) 80333002024 2166 DELTA VISION SCHOOL   Alternative School Yes Other KG 12 2017   grade_7 27 1 7   0 0     0   1   18 18                       36 27 1 7   0 0     0   1   18 18                 36
711278 CO     school 803330 870   DELTA COUNTY 50(J) 80333000299 4124 HOTCHKISS ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2017   grade_7 41 0 10   0 0     0   0   28 23                       51 41 0 10   0 0     0   0   28 23                 51
711323 CO     school 803330 870   DELTA COUNTY 50(J) 80333000304 6708 PAONIA HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 29 0 8   0 1     0   0   23 15                       38 29 0 8   0 1     0   0   23 15                 38
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
711459 CO     school 803360 880   DENVER COUNTY 1 80336006449 1345 CESAR CHAVEZ ACADEMY DENVER   Regular School Yes Elementary KG 08 2017   grade_7 2 1 32   0 0     0   0   18 17                       35 2 1 32   0 0     0   0   18 17                 35
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
711559 CO     school 803360 880   DENVER COUNTY 1 80336006566 2115 DSST: STAPLETON MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 35 37 54   1 12     0   14   84 69                       153 35 37 54   1 12     0   14   84 69                 153
711570 CO     school 803360 880   DENVER COUNTY 1 80336006453 2125 DENVER GREEN SCHOOL   Regular School No Elementary PK 08 2017   grade_7 18 19 12   0 1     0   2   31 21                       52 18 19 12   0 1     0   2   31 21                 52
711581 CO     school 803360 880   DENVER COUNTY 1 80336006482 2127 DENVER LANGUAGE SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 4 1 8   0 0     0   1   8 6                       14 4 1 8   0 0     0   1   8 6                 14
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
711617 CO     school 803360 880   DENVER COUNTY 1 80336006546 2181 DSST: GREEN VALLEY RANCH MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 6 39 87   1 8     0   5   73 73                       146 6 39 87   1 8     0   5   73 73                 146
711624 CO     school 803360 880   DENVER COUNTY 1 80336001917 2183 DENVER CENTER FOR INTERNATIONAL STUDIES   Regular School No Other 06 12 2017   grade_7 38 5 64   4 2     0   6   47 72                       119 38 5 64   4 2     0   6   47 72                 119
711632 CO     school 803360 880   DENVER COUNTY 1 80336001574 2184 DENVER SCHOOL OF THE ARTS   Regular School No Other 06 12 2017   grade_7 99 5 18   0 4     0   7   54 79                       133 99 5 18   0 4     0   7   54 79                 133
711642 CO     school 803360 880   DENVER COUNTY 1 80336006572 2186 DSST: BYERS MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 71 14 56   1 7     0   8   89 68                       157 71 14 56   1 7     0   8   89 68                 157
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
711672 CO     school 803360 880   DENVER COUNTY 1 80336006528 2209 DCIS AT MONTBELLO   Regular School No Other 06 12 2017   grade_7 2 18 126   0 1     1   1   71 78                       149 2 18 126   0 1     1   1   71 78                 149
711677 CO     school 803360 880   DENVER COUNTY 1 80336006618 2218 DSST: CONSERVATORY GREEN MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 27 36 71   0 7     0   11   87 65                       152 27 36 71   0 7     0   11   87 65                 152
711681 CO     school 803360 880   DENVER COUNTY 1 80336006523 2223 DSST: COLE MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 5 19 123   1 0     1   3   79 73                       152 5 19 123   1 0     1   3   79 73                 152
711685 CO     school 803360 880   DENVER COUNTY 1 80336006624 2227 DENVER DISCOVERY SCHOOL   Regular School No Middle 06 08 2017   grade_7 93 31 29   0 1     1   6   87 74                       161 93 31 29   0 1     1   6   87 74                 161
711829 CO     school 803360 880   DENVER COUNTY 1 80336000357 3600 GRANT BEACON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 18 7 121   2 2     0   5   86 69                       155 18 7 121   2 2     0   5   86 69                 155
711838 CO     school 803360 880   DENVER COUNTY 1 80336001738 3605 GRANT RANCH ECE-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 21 0 44   0 9     0   2   29 47                       76 21 0 44   0 9     0   2   29 47                 76
711844 CO     school 803360 880   DENVER COUNTY 1 80336006473 3639 GIRLS ATHLETIC LEADERSHIP SCHOOL MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 49 5 39   0 3     0   3   0 99                       99 49 5 39   0 3     0   3   0 99                 99
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
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
711905 CO     school 803360 880   DENVER COUNTY 1 80336001835 3987 HIGHLINE ACADEMY SOUTHEAST   Regular School Yes Elementary KG 08 2017   grade_7 40 13 14   0 2     0   2   31 40                       71 40 13 14   0 2     0   2   31 40                 71
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
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
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
711998 CO     school 803360 880   DENVER COUNTY 1 80336006519 4507 KIPP MONTBELLO COLLEGE PREP   Regular School Yes Middle 05 08 2017   grade_7 4 27 84   0 1     0   2   62 56                       118 4 27 84   0 1     0   2   62 56                 118
712006 CO     school 803360 880   DENVER COUNTY 1 80336000370 4656 KEPNER MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 2 3 130   1 3     0   1   76 64                       140 2 3 130   1 3     0   1   76 64                 140
712016 CO     school 803360 880   DENVER COUNTY 1 80336001865 4732 KIPP SUNSHINE PEAK ACADEMY   Regular School Yes Middle 05 08 2017   grade_7 5 1 99   0 0     0   0   50 55                       105 5 1 99   0 0     0   0   50 55                 105
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
712062 CO     school 803360 880   DENVER COUNTY 1 80336006490 5255 LAKE INTERNATIONAL SCHOOL   Regular School No Middle 06 08 2017   grade_7 6 10 88   2 1     0   7   68 46                       114 6 10 88   2 1     0   7   68 46                 114
712090 CO     school 803360 880   DENVER COUNTY 1 80336001406 5605 DR. MARTIN LUTHER KING JR. EARLY COLLEGE   Regular School No Other 06 12 2017   grade_7 6 36 96   1 6     0   3   71 77                       148 6 36 96   1 6     0   3   71 77                 148
712143 CO     school 803360 880   DENVER COUNTY 1 80336000379 5826 MERRILL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 80 14 56   2 6     0   6   99 65                       164 80 14 56   2 6     0   6   99 65                 164
712152 CO     school 803360 880   DENVER COUNTY 1 80336006562 5897 MCAULIFFE INTERNATIONAL SCHOOL   Regular School No Middle 06 08 2017   grade_7 181 27 43   2 10     1   22   135 151                       286 181 27 43   2 10     1   22   135 151                 286
712171 CO     school 803360 880   DENVER COUNTY 1 80336000385 6088 DORA MOORE ECE-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 4 7 11   0 0     0   2   12 12                       24 4 7 11   0 0     0   2   12 12                 24
712177 CO     school 803360 880   DENVER COUNTY 1 80336000386 6098 MOREY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 26 31 25   0 3     1   5   61 30                       91 26 31 25   0 3     1   5   61 30                 91
712192 CO     school 803360 880   DENVER COUNTY 1 80336006520 6239 NOEL COMMUNITY ARTS SCHOOL   Regular School No Other 06 12 2017   grade_7 3 21 39   0 0     0   6   26 43                       69 3 21 39   0 0     0   6   26 43                 69
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
712239 CO     school 803360 880   DENVER COUNTY 1 80336001636 6479 ODYSSEY SCHOOL OF DENVER   Regular School Yes Elementary KG 08 2017   grade_7 15 2 7   0 0     0   3   11 16                       27 15 2 7   0 0     0   3   11 16                 27
712249 CO     school 803360 880   DENVER COUNTY 1 80336001838 6508 OMAR D BLAIR CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 7 33 25   0 5     0   3   47 26                       73 7 33 25   0 5     0   3   47 26                 73
712288 CO     school 803360 880   DENVER COUNTY 1 80336001933 6970 FLORIDA PITT-WALLER ECE-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 9 23 34   0 5     5   2   37 41                       78 9 23 34   0 5     5   2   37 41                 78
712299 CO     school 803360 880   DENVER COUNTY 1 80336006398 7045 PLACE BRIDGE ACADEMY   Regular School No Elementary PK 08 2017   grade_7 14 37 37   0 21     2   1   67 45                       112 14 37 37   0 21     2   1   67 45                 112
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
712386 CO     school 803360 880   DENVER COUNTY 1 80336000403 7942 SKINNER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 73 15 110   2 3     0   6   95 114                       209 73 15 110   2 3     0   6   95 114                 209

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