enrollments

Data source: Big Local News · About: Big Local

4,236 rows where grade = "grade_7" and state = "CO" sorted by ccd_school_type descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 4,236 ✖
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
848184 848184 CO     school 800019 3230   LIBERTY J-4 80001901744 5123 LIBERTY JUNIOR-SENIOR HIGH SCHOOL   Vocational Education School No 4.0 06 12 2016   grade_7 11 0 0   0 0     0   0   7 4                       11 11 0 0   0 0     0   0   7 4                 11
1145752 1145752 CO     school 800019 3230   LIBERTY J-4 80001901744 5123 LIBERTY JUNIOR-SENIOR HIGH SCHOOL   Vocational Education School No 4.0 06 12 2015   grade_7 3.0 0.0 1.0   0.0 0.0     0.0   0.0   2.0 2.0                       4.0 3 0 1   0 0     0   0   2 2                 4
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
716156 716156 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001606 5415 ROCKY MOUNTAIN DEAF SCHOOL   Special Education School Yes Other PK 12 2017   grade_7 5 0 4   0 0     0   0   4 5                       9 5 0 4   0 0     0   0   4 5                 9
716207 716207 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000756 5892 MILLER SPECIAL EDUCATION   Special Education School No Other PK 12 2017   grade_7 2 0 2   0 0     0   1   2 3                       5 2 0 2   0 0     0   1   2 3                 5
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
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
838389 838389 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No 4.0 06 12 2016   grade_7 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
843756 843756 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001606 5415 ROCKY MOUNTAIN DEAF SCHOOL   Special Education School Yes 4.0 PK 12 2016   grade_7 2 0 2   0 0     0   0   4 0                       4 2 0 2   0 0     0   0   4 0                 4
843808 843808 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000756 5892 MILLER SPECIAL EDUCATION   Special Education School No 4.0 PK 12 2016   grade_7 1 0 1   0 1     0   0   3 0                       3 1 0 1   0 1     0   0   3 0                 3
844125 844125 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006307 8036 SOBESKY ACADEMY   Special Education School No 4.0 KG 12 2016   grade_7 4 0 5   0 0     0   0   7 2                       9 4 0 5   0 0     0   0   7 2                 9
848485 848485 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 COLORADO SCHOOL FOR THE DEAF AND BLIND   Special Education School No 4.0 PK 12 2016   grade_7 4 0 4   0 0     0   0   5 3                       8 4 0 4   0 0     0   0   5 3                 8
1136080 1136080 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No 4.0 06 12 2015   grade_7 3.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 0.0                       3.0 3 0 0   0 0     0   0   3 0                 3
1141341 1141341 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001606 5415 ROCKY MOUNTAIN DEAF SCHOOL   Special Education School Yes 4.0 PK 12 2015   grade_7 1.0 0.0 1.0   0.0 1.0     0.0   1.0   1.0 3.0                       4.0 1 0 1   0 1     0   1   1 3                 4
1141393 1141393 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000756 5892 MILLER SPECIAL EDUCATION   Special Education School No 4.0 PK 12 2015   grade_7 4.0 0.0 4.0   0.0 0.0     0.0   0.0   5.0 3.0                       8.0 4 0 4   0 0     0   0   5 3                 8
1141714 1141714 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006307 8036 SOBESKY ACADEMY   Special Education School No 4.0 KG 12 2015   grade_7 5.0 1.0 2.0   0.0 0.0     0.0   1.0   8.0 1.0                       9.0 5 1 2   0 0     0   1   8 1                 9
1146033 1146033 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 COLORADO SCHOOL FOR THE DEAF AND BLIND   Special Education School No 4.0 PK 12 2015   grade_7 8.0 1.0 5.0   0.0 1.0     0.0   1.0   11.0 5.0                       16.0 8 1 5   0 1     0   1   11 5                 16
1746715 1746715 CO     school 804800 1420   Jefferson County R-1 80480001606 5415 Rocky Mountain Deaf School   Special Education School Yes Other PK 12 2021   grade_7 4 0 0   0 2     0   0   3 3                       6 4 0 0   0 2     0   0   3 3                 6
1746761 1746761 CO     school 804800 1420   Jefferson County R-1 80480000756 5892 Miller Special Education   Special Education School No Other PK 12 2021   grade_7 4 0 0   0 0     0   0   3 1                       4 4 0 0   0 0     0   0   3 1                 4
1747051 1747051 CO     school 804800 1420   Jefferson County R-1 80480006307 8036 Sobesky Academy   Special Education School No Other KG 12 2021   grade_7 10 0 6   0 0     0   1   16 1                       17 10 0 6   0 0     0   1   16 1                 17
1751467 1751467 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 2021   grade_7 4 1 5   0 1     0   1   5 7                       12 4 1 5   0 1     0   1   5 7                 12
1807807 1807807 CO     school 804800 1420   Jefferson County R-1 80480001606 5415 Rocky Mountain Deaf School   Special Education School Yes Other PK 12 2020   grade_7 2 0 1   0 0     0   0   3 0                       3 2 0 1   0 0     0   0   3 0                 3
1807856 1807856 CO     school 804800 1420   Jefferson County R-1 80480000756 5892 Miller Special Education   Special Education School No Other PK 12 2020   grade_7 5 0 4   0 0     0   0   3 6                       9 5 0 4   0 0     0   0   3 6                 9
1808160 1808160 CO     school 804800 1420   Jefferson County R-1 80480006307 8036 Sobesky Academy   Special Education School No Other KG 12 2020   grade_7 8 0 0   0 0     0   1   8 1                       9 8 0 0   0 0     0   1   8 1                 9
1812560 1812560 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 2020   grade_7 5 1 8   0 0     0   0   9 5                       14 5 1 8   0 0     0   0   9 5                 14
1902087 1902087 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001606 5415 ROCKY MOUNTAIN DEAF SCHOOL   Special Education School Yes Other PK 12 2018   grade_7 6 1 5   0 3     0   0   7 8                       15 6 1 5   0 3     0   0   7 8                 15
1902138 1902138 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000756 5892 MILLER SPECIAL EDUCATION   Special Education School No Other PK 12 2018   grade_7 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1902459 1902459 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006307 8036 SOBESKY ACADEMY   Special Education School No Other KG 12 2018   grade_7 4 2 3   0 0     0   0   8 1                       9 4 2 3   0 0     0   0   8 1                 9
1906923 1906923 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 2018   grade_7 4 0 4   0 0     0   1   3 6                       9 4 0 4   0 0     0   1   3 6                 9
1939477 1939477 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001606 5415 ROCKY MOUNTAIN DEAF SCHOOL   Special Education School Yes Other PK 12 2019   grade_7 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
1939528 1939528 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000756 5892 MILLER SPECIAL EDUCATION   Special Education School No Other PK 12 2019   grade_7 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
1939840 1939840 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006307 8036 SOBESKY ACADEMY   Special Education School No Other KG 12 2019   grade_7 4 0 5   1 0     0   0   9 1                       10 4 0 5   1 0     0   0   9 1                 10
1944300 1944300 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 2019   grade_7 3 0 4   0 0     0   1   3 5                       8 3 0 4   0 0     0   1   3 5                 8
707822 707822 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2017   grade_7 28 1 78   2 1     0   2   58 54                       112 28 1 78   2 1     0   2   58 54                 112
707847 707847 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_7 7 0 44   0 0     0   1   23 29                       52 7 0 44   0 0     0   1   23 29                 52
707858 707858 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_7 7 1 33   2 2     0   0   20 25                       45 7 1 33   2 2     0   0   20 25                 45
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
707892 707892 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   grade_7 8 1 44   0 1     0   1   31 24                       55 8 1 44   0 1     0   1   31 24                 55
707921 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
707937 707937 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_7 149 13 46   3 2     1   14   127 101                       228 149 13 46   3 2     1   14   127 101                 228
707945 707945 CO     school 805550 10   MAPLETON 1 80555006672 3590 GLOBAL INTERMEDIATE ACADEMY   Regular School No Elementary 04 08 2017   grade_7 2 0 42   0 0     0   0   22 22                       44 2 0 42   0 0     0   0   22 22                 44
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
707975 707975 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001726 57 ROCKY TOP MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 353 8 94   2 24     0   10   265 226                       491 353 8 94   2 24     0   10   265 226                 491
708015 708015 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001620 1480 CENTURY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 208 6 92   4 15     0   8   156 177                       333 208 6 92   4 15     0   8   156 177                 333
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
708136 708136 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001178 4172 HULSTROM OPTIONS K-8 SCHOOL   Regular School No Elementary KG 08 2017   grade_7 47 0 9   0 12     1   3   38 34                       72 47 0 9   0 12     1   3   38 34                 72
708141 708141 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001179 4187 SILVER HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 133 14 168   2 22     0   11   178 172                       350 133 14 168   2 22     0   11   178 172                 350
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
708197 708197 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001186 6342 SHADOW RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 164 6 135   2 19     1   9   161 175                       336 164 6 135   2 19     1   9   161 175                 336
708217 708217 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001187 6398 NORTHGLENN MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 76 2 164   1 6     0   6   157 98                       255 76 2 164   1 6     0   6   157 98                 255
708233 708233 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006507 6802 PROSPECT RIDGE ACADEMY   Regular School Yes Other KG 11 2017   grade_7 92 0 13   0 6     0   1   43 69                       112 92 0 13   0 6     0   1   43 69                 112
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
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
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
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
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
708432 708432 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001948 700 BELLE CREEK CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 24 3 30   0 4     0   2   32 31                       63 24 3 30   0 4     0   2   32 31                 63
708462 708462 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001729 1052 BROMLEY EAST CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_7 78 0 57   0 0     1   4   56 84                       140 78 0 57   0 0     1   4   56 84                 140
708483 708483 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006465 2945 FOUNDATIONS ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 52 1 17   0 1     0   3   32 42                       74 52 1 17   0 1     0   3   32 42                 74
708506 708506 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006325 4950 LANDMARK ACADEMY AT REUNION   Regular School Yes Elementary KG 08 2017   grade_7 42 2 21   0 2     0   4   48 23                       71 42 2 21   0 2     0   4   48 23                 71
708536 708536 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001377 6638 OVERLAND TRAIL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 73 3 118   0 2     1   7   99 105                       204 73 3 118   0 2     1   7   99 105                 204
708540 708540 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006420 6702 OTHO E STUART MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 128 11 89   1 8     0   7   128 116                       244 128 11 89   1 8     0   7   128 116                 244
708549 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
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
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
708638 708638 CO     school 806750 60   STRASBURG 31J 80675001160 8332 HEMPHILL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 56 0 12   1 0     0   1   33 37                       70 56 0 12   1 0     0   1   33 37                 70
708691 708691 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006567 4334 COLORADO STEM ACADEMY   Regular School No Elementary KG 08 2017   grade_7 31 1 28   1 2     1   2   44 22                       66 31 1 28   1 2     1   2   44 22                 66
708704 708704 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001241 5388 M. SCOTT CARPENTER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 19 3 158   0 9     1   4   104 90                       194 19 3 158   0 9     1   4   104 90                 194
708715 708715 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006458 7305 IVER C. RANUM MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 19 3 224   1 7     1   4   136 123                       259 19 3 224   1 7     1   4   136 123                 259
708727 708727 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001244 7812 SHAW HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 54 6 142   4 21     0   3   105 125                       230 54 6 142   4 21     0   3   105 125                 230
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
708812 708812 CO     school 806420 110   SANGRE DE CRISTO RE-22J 80642001116 7630 SANGRE DE CRISTO UNDIVIDED HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 14 2 5   1 0     0   0   10 12                       22 14 2 5   1 0     0   0   10 12                 22
708851 708851 CO     school 803780 120   ENGLEWOOD 1 80378001772 2750 ENGLEWOOD LEADERSHIP ACADEMY   Regular School No Other 06 09 2017   grade_7 21 0 3   0 1     0   1   15 11                       26 21 0 3   0 1     0   1   15 11                 26
708854 708854 CO     school 803780 120   ENGLEWOOD 1 80378006331 2752 ENGLEWOOD MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_7 70 3 75   4 2     0   3   87 70                       157 70 3 75   4 2     0   3   87 70                 157
708875 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
708899 708899 CO     school 802910 130   CHERRY CREEK 5 80291001711 18 LIBERTY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 225 43 47   3 41     1   25   207 178                       385 225 43 47   3 41     1   25   207 178                 385
708903 708903 CO     school 802910 130   CHERRY CREEK 5 80291001878 141 SKY VISTA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 135 40 55   1 25     1   15   136 136                       272 135 40 55   1 25     1   15   136 136                 272
708963 708963 CO     school 802910 130   CHERRY CREEK 5 80291000763 1510 CHALLENGE SCHOOL   Regular School No Elementary PK 08 2017   grade_7 30 8 10   0 17     0   9   34 40                       74 30 8 10   0 17     0   9   34 40                 74
708973 708973 CO     school 802910 130   CHERRY CREEK 5 80291000185 1566 CAMPUS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 314 16 57   2 71     1   21   246 236                       482 314 16 57   2 71     1   21   246 236                 482
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
708991 708991 CO     school 802910 130   CHERRY CREEK 5 80291001152 1571 CHERRY CREEK CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 33 3 3   0 12     0   2   24 29                       53 33 3 3   0 12     0   2   24 29                 53
709063 709063 CO     school 802910 130   CHERRY CREEK 5 80291001672 2897 FALCON CREEK MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 184 23 56   1 28     4   12   159 149                       308 184 23 56   1 28     4   12   159 149                 308
709067 709067 CO     school 802910 130   CHERRY CREEK 5 80291006367 3030 FOX RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 317 33 67   2 31     0   36   251 235                       486 317 33 67   2 31     0   36   251 235                 486
709113 709113 CO     school 802910 130   CHERRY CREEK 5 80291001328 4100 HORIZON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 145 57 88   3 7     0   22   180 142                       322 145 57 88   3 7     0   22   180 142                 322
709149 709149 CO     school 802910 130   CHERRY CREEK 5 80291000197 4975 LAREDO MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 171 58 79   1 31     0   18   182 176                       358 171 58 79   1 31     0   18   182 176                 358
709230 709230 CO     school 802910 130   CHERRY CREEK 5 80291000201 7158 PRAIRIE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 145 161 231   3 26     2   42   328 282                       610 145 161 231   3 26     2   42   328 282                 610
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
709345 709345 CO     school 805310 140   LITTLETON 6 80531000876 2804 EUCLID MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 195 3 43   2 6     0   7   118 138                       256 195 3 43   2 6     0   7   118 138                 256
709356 709356 CO     school 805310 140   LITTLETON 6 80531000879 3472 GODDARD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 130 5 85   1 5     0   13   115 124                       239 130 5 85   1 5     0   13   115 124                 239
709373 709373 CO     school 805310 140   LITTLETON 6 80531000885 4316 NEWTON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 149 6 20   2 8     0   7   96 96                       192 149 6 20   2 8     0   7   96 96                 192
709377 709377 CO     school 805310 140   LITTLETON 6 80531001351 4447 JOHN WESLEY POWELL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 265 5 30   1 10     1   18   167 163                       330 265 5 30   1 10     1   18   167 163                 330
709391 709391 CO     school 805310 140   LITTLETON 6 80531001515 5229 LITTLETON ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 40 1 6   0 5     0   1   29 24                       53 40 1 6   0 5     0   1   29 24                 53
709401 709401 CO     school 805310 140   LITTLETON 6 80531001626 5233 LITTLETON PREP CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_7 39 1 15   1 0     0   1   23 34                       57 39 1 15   1 0     0   1   23 34                 57
709480 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
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
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
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
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
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

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