enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
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
707872 707872 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_7 13 0 42   0 2     0   1   26 32                       58 13 0 42   0 2     0   1   26 32                 58
712659 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
713542 713542 CO     school 803540 910   EAGLE COUNTY RE 50 80354006533 9701 WORLD ACADEMY   Regular School No Other KG 12 2017   grade_7 5 0 0   0 0     0   0   3 2                       5 5 0 0   0 0     0   0   3 2                 5
716734 716734 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001807 9427 WOODROW WILSON CHARTER ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 39 1 9   0 1     0   2   27 25                       52 39 1 9   0 1     0   2   27 25                 52
719984 719984 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 6 0 1   0 0     0   0   2 5                       7 6 0 1   0 0     0   0   2 5                 7
719892 719892 CO     school 807380 3020   WOODLAND PARK RE-2 80738001268 9694 WOODLAND PARK MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 159 0 21   1 0     0   11   117 75                       192 159 0 21   1 0     0   11   117 75                 192
720219 720219 CO     school 804410 3120   GREELEY 6 80441001989 53 WINOGRAD K-8 ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2017   grade_7 52 0 36   0 0     0   1   43 46                       89 52 0 36   0 0     0   1   43 46                 89
720154 720154 CO     school 807350 3100   WINDSOR RE-4 80735001265 9670 WINDSOR MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 182 1 38   0 3     0   9   132 101                       233 182 1 38   0 3     0   9   132 101                 233
720141 720141 CO     school 807350 3100   WINDSOR RE-4 80735006650 9393 WINDSOR CHARTER ACADEMY MIDDLE AND EARLY COLLEGE HIGH SCHOOL   Regular School Yes Other 06 11 2017   grade_7 94 0 7   0 4     0   2   47 60                       107 94 0 7   0 4     0   2   47 60                 107
712619 712619 CO     school 803360 880   DENVER COUNTY 1 80336006332 9623 WILLIAM (BILL) ROBERTS K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 36 16 9   0 0     0   2   33 30                       63 36 16 9   0 0     0   2   33 30                 63
719071 719071 CO     school 807320 2680   WILEY RE-13 JT 80732001261 9608 WILEY JUNIOR-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 14 0 6   0 0     0   0   6 14                       20 14 0 6   0 0     0   0   6 14                 20
718729 718729 CO     school 807290 2515   WIGGINS RE-50(J) 80729006394 9263 WIGGINS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 34 1 8   0 1     0   1   17 28                       45 34 1 8   0 1     0   1   17 28                 45
712608 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
710549 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
708331 708331 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001194 9444 WESTLAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 256 4 98   0 20     2   10   196 194                       390 256 4 98   0 20     2   10   196 194                 390
708324 708324 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006417 9431 WESTGATE CHARTER   Regular School Yes Other KG 12 2017   grade_7 31 0 7   0 2     0   1   22 19                       41 31 0 7   0 2     0   1   22 19                 41
720436 720436 CO     school 804410 3120   GREELEY 6 80441006504 9611 WEST RIDGE ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 15 1 10   0 1     0   1   12 16                       28 15 1 10   0 1     0   1   12 16                 28
708977 708977 CO     school 802910 130   CHERRY CREEK 5 80291000207 1568 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 296 7 57   2 31     1   12   209 197                       406 296 7 57   2 31     1   12   209 197                 406
714355 714355 CO     school 803060 1010   COLORADO SPRINGS 11 80306000272 9404 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 53 3 25   2 1     1   3   42 46                       88 53 3 25   2 1     1   3   42 46                 88
718343 718343 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000629 9406 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 89 0 26   0 3     2   8   72 56                       128 89 0 26   0 3     2   8   72 56                 128
712641 712641 CO     school 803360 880   DENVER COUNTY 1 80336006547 9702 WEST LEADERSHIP ACADEMY   Regular School No Other 06 12 2017   grade_7 3 7 107   0 5     0   1   61 62                       123 3 7 107   0 5     0   1   61 62                 123
716741 716741 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000795 9428 WEST JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 147 0 9   1 4     0   3   74 90                       164 147 0 9   1 4     0   3   74 90                 164
715369 715369 CO     school 805070 1340   WEST GRAND 1-JT 80507000829 9422 WEST GRAND ELEMENTARY AND MIDDLE SCHOOL   Regular School No Elementary KG 08 2017   grade_7 20 0 12   0 0     0   0   19 13                       32 20 0 12   0 0     0   0   19 13                 32
712633 712633 CO     school 803360 880   DENVER COUNTY 1 80336006551 9693 WEST EARLY COLLEGE   Regular School No Other 06 12 2017   grade_7 5 14 100   4 0     0   1   70 54                       124 5 14 100   4 0     0   1   70 54                 124
717468 717468 CO     school 803990 1550   POUDRE R-1 80399000551 9374 WELLINGTON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 139 3 33   1 1     0   2   98 81                       179 139 3 33   1 1     0   2   98 81                 179
718724 718724 CO     school 807140 2505   WELDON VALLEY RE-20(J) 80714001218 9360 WELDON VALLEY JR/SR HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 18 0 1   0 0     0   0   5 14                       19 18 0 1   0 0     0   0   5 14                 19
720092 720092 CO     school 804920 3090   WELD COUNTY SCHOOL DISTRICT RE-3J 80492002026 9347 WELD CENTRAL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 76 0 73   0 2     0   5   66 90                       156 76 0 73   0 2     0   5   66 90                 156
717455 717455 CO     school 803990 1550   POUDRE R-1 80399006162 9330 WEBBER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 209 5 34   1 5     0   18   141 131                       272 209 5 34   1 5     0   18   141 131                 272
716687 716687 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480002036 9299 WAYNE CARLE MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 157 1 43   3 5     0   10   118 101                       219 157 1 43   3 5     0   10   118 101                 219
713896 713896 CO     school 806480 990   WIDEFIELD 3 80648001126 9294 WATSON JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2017   grade_7 126 15 56   4 5     2   23   119 112                       231 126 15 56   4 5     2   23   119 112                 231
717712 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
710039 710039 CO     school 807110 230   WALSH RE-1 80711001216 9226 WALSH HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 6 0 0   0 0     0   0   3 3                       6 6 0 0   0 0     0   0   3 3                 6
719304 719304 CO     school 806120 2690   PUEBLO CITY 60 80612001067 9188 W H HEATON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 40 5 177   2 2     1   5   128 104                       232 40 5 177   2 2     1   5   128 104                 232
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
712558 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
719460 719460 CO     school 806150 2700   PUEBLO COUNTY 70 80615001085 9134 VINELAND MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 55 1 48   1 1     0   4   57 53                       110 55 1 48   1 1     0   4   57 53                 110
710086 710086 CO     school 806990 260   VILAS RE-5 80699001207 9100 VILAS UNDIVIDED HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 2 0 1   0 0     0   0   0 3                       3 2 0 1   0 0     0   0   0 3                 3
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
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
707991 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 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
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
707962 707962 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2017   grade_7 5 0 51   0 0     0   2   27 31                       58 5 0 51   0 0     0   2   27 31                 58
709994 709994 CO     school 802700 190   BYERS 32J 80270006548 3362 VALIANT ACADEMY   Regular School No Other KG 12 2017   grade_7 20 2 2   0 0     0   0   12 12                       24 20 2 2   0 0     0   0   12 12                 24
713530 713530 CO     school 803540 910   EAGLE COUNTY RE 50 80354006422 9061 VAIL SKI AND SNOWBOARD ACADEMY (VSSA)   Alternative School No Other 05 12 2017   grade_7 26 0 0   0 0     0   2   16 12                       28 26 0 0   0 0     0   2   16 12                 28
720300 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
720419 720419 CO     school 804410 3120   GREELEY 6 80441001615 8965 UNION COLONY PREPARATORY SCHOOL   Regular School Yes Other 06 12 2017   grade_7 27 1 41   0 2     2   3   34 42                       76 27 1 41   0 2     2   3   34 42                 76
716621 716621 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006466 8793 TWO ROADS CHARTER SCHOOL   Regular School Yes Other PK 12 2017   grade_7 50 0 9   0 2     0   3   26 38                       64 50 0 9   0 2     0   3   26 38                 64
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
710542 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
717701 717701 CO     school 805400 1560   THOMPSON R2-J 80540001354 8925 TURNER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 126 1 12   1 1     1   3   73 72                       145 126 1 12   1 1     1   3   73 72                 145
717758 717758 CO     school 806960 1580   TRINIDAD 1 80696001204 1386 TRINIDAD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 19 2 51   1 1     0   0   38 36                       74 19 2 51   1 1     0   0   38 36                 74
710530 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
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
710437 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
710321 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
709277 709277 CO     school 802910 130   CHERRY CREEK 5 80291000034 8848 THUNDER RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 251 43 74   2 38     2   26   227 209                       436 251 43 74   2 38     2   26   227 209                 436
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
714438 714438 CO     school 802940 1020   CHEYENNE MOUNTAIN 12 80294006402 9051 THE VANGUARD SCHOOL (MIDDLE)   Regular School Yes Middle 07 08 2017   grade_7 62 5 26   1 7     1   7   51 58                       109 62 5 26   1 7     1   7   51 58                 109
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
708174 708174 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001183 5814 THE INTERNATIONAL SCHOOL AT THORNTON MIDDLE   Regular School No Middle 06 08 2017   grade_7 39 16 233   4 9     0   4   170 135                       305 39 16 233   4 9     0   4   170 135                 305
719448 719448 CO     school 806150 2700   PUEBLO COUNTY 70 80615000632 8810 THE CONNECT CHARTER SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 60 0 29   0 3     0   4   43 53                       96 60 0 29   0 3     0   4   43 53                 96
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
719731 719731 CO     school 806870 2830   TELLURIDE R-1 80687001304 8790 TELLURIDE MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 69 0 14   0 0     0   0   39 44                       83 69 0 14   0 0     0   0   39 44                 83
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
718836 718836 CO     school 806840 2570   SWINK 33 80684001169 8456 SWINK JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   grade_7 15 2 11   0 1     0   0   17 12                       29 15 2 11   0 1     0   0   17 12                 29
719443 719443 CO     school 806150 2700   PUEBLO COUNTY 70 80615001559 8420 SWALLOWS CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 37 0 12   0 0     0   0   24 25                       49 37 0 12   0 0     0   0   24 25                 49
710388 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
716599 716599 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001054 8381 SUMMIT RIDGE MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 232 3 61   1 12     0   21   159 171                       330 232 3 61   1 12     0   21   159 171                 330
719835 719835 CO     school 806810 3000   SUMMIT RE-1 80681001400 8377 SUMMIT MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 171 1 75   0 4     0   8   139 120                       259 171 1 75   0 4     0   8   139 120                 259
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
712454 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
712580 712580 CO     school 803360 880   DENVER COUNTY 1 80336006444 9389 STRIVE PREP - WESTWOOD   Regular School Yes Middle 06 08 2017   grade_7 2 0 117   0 1     0   0   65 55                       120 2 0 117   0 1     0   0   65 55                 120
712571 712571 CO     school 803360 880   DENVER COUNTY 1 80336006457 9336 STRIVE PREP - SUNNYSIDE   Regular School Yes Middle 06 08 2017   grade_7 4 3 83   1 0     0   1   44 48                       92 4 3 83   1 0     0   1   44 48                 92
712650 712650 CO     school 803360 880   DENVER COUNTY 1 80336006537 9735 STRIVE PREP - MONTBELLO   Regular School Yes Middle 06 08 2017   grade_7 2 12 95   0 0     1   1   50 61                       111 2 12 95   0 0     1   1   50 61                 111
712584 712584 CO     school 803360 880   DENVER COUNTY 1 80336006479 9390 STRIVE PREP - LAKE   Regular School Yes Middle 06 08 2017   grade_7 4 6 114   1 0     0   1   64 62                       126 4 6 114   1 0     0   1   64 62                 126
712646 712646 CO     school 803360 880   DENVER COUNTY 1 80336006556 9730 STRIVE PREP - GVR   Regular School Yes Middle 06 08 2017   grade_7 7 36 72   0 2     2   5   59 65                       124 7 36 72   0 2     2   5   59 65                 124
712421 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
716875 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
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
717937 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
713091 713091 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006493 5259 STEM SCHOOL   Regular School Yes Other KG 12 2017   grade_7 167 0 18   3 38     0   13   166 73                       239 167 0 18   3 38     0   13   166 73                 239
708296 708296 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006561 8310 STEM LAUNCH   Regular School No Elementary KG 08 2017   grade_7 28 3 122   0 5     0   1   87 72                       159 28 3 122   0 5     0   1   87 72                 159
708286 708286 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006468 8275 STEM LAB   Regular School No Elementary KG 08 2017   grade_7 33 0 14   0 2     0   2   36 15                       51 33 0 14   0 2     0   2   36 15                 51
719601 719601 CO     school 806660 2770   STEAMBOAT SPRINGS RE-2 80666001146 8210 STEAMBOAT SPRINGS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 168 0 18   0 4     0   3   91 102                       193 168 0 18   0 4     0   3   91 102                 193
708025 708025 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690000728 1519 STARGATE CHARTER SCHOOL   Regular School Yes Other KG 10 2017   grade_7 79 2 8   0 26     0   7   67 55                       122 79 2 8   0 26     0   7   67 55                 122
710499 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
713885 713885 CO     school 806480 990   WIDEFIELD 3 80648001125 8178 SPROUL JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2017   grade_7 71 14 56   2 0     2   24   97 72                       169 71 14 56   2 0     2   24   97 72                 169
714878 714878 CO     school 803870 1110   FALCON 49 80387006462 2877 SPRINGS STUDIO FOR ACADEMIC EXCELLENCE   Regular School No Other KG 12 2017   grade_7 31 2 7   0 1     0   2   23 20                       43 31 2 7   0 1     0   2   23 20                 43
710071 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
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
720017 720017 CO     school 804200 3080   WELD COUNTY RE-1 80420000579 7058 SOUTH VALLEY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 27 1 40   3 1     0   1   31 42                       73 27 1 40   3 1     0   1   31 42                 73
718915 718915 CO     school 803840 2610   PARK COUNTY RE-2 80384000622 7891 SOUTH PARK MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 24 1 8   0 0     0   2   14 21                       35 24 1 8   0 0     0   2   14 21                 35
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
719623 719623 CO     school 805910 2780   SOUTH ROUTT RE 3 80591001013 8048 SOROCO MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 33 0 2   0 0     0   1   12 24                       36 33 0 2   0 0     0   1   12 24                 36
716528 716528 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006307 8036 SOBESKY ACADEMY   Special Education School No Other KG 12 2017   grade_7 5 0 1   0 0     0   2   5 3                       8 5 0 1   0 0     0   2   5 3                 8
712395 712395 CO     school 803360 880   DENVER COUNTY 1 80336001524 7972 SLAVENS K-8 SCHOOL   Regular School No Elementary KG 08 2017   grade_7 62 3 6   0 1     0   5   43 34                       77 62 3 6   0 1     0   5   43 34                 77
715000 715000 CO     school 803870 1110   FALCON 49 80387001799 7960 SKYVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 238 21 88   4 17     2   37   211 196                       407 238 21 88   4 17     2   37   211 196                 407
713183 713183 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006455 6365 SKYVIEW ACADEMY   Regular School Yes Other PK 12 2017   grade_7 86 0 14   0 15     0   2   52 65                       117 86 0 14   0 15     0   2   52 65                 117

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