enrollments

Data source: Big Local News · About: Big Local

626 rows where grade = "grade_7", state = "CO" and year = 2020 sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 626 ✖

grade ✖

  • grade_7 · 626 ✖
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
1802574 1802574 CO     school 800001 520   Cheyenne County Re-5 80000100215 1612 Cheyenne Wells Junior/High School   Regular School No High 07 12 2020   grade_7 10 0 3   0 0     0   0   8 5                       13 10 0 3   0 0     0   0   8 5                 13
1812588 1812588 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   grade_7 35 1 5   0 2     0   7   30 20                       50 35 1 5   0 2     0   7   30 20                 50
1812133 1812133 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2020   grade_7 37 0 34   0 0     0   0   34 37                       71 37 0 34   0 0     0   0   34 37                 71
1812156 1812156 CO     school 800017 3210   Wray RD-2 80001701817 9729 Buchanan Middle School   Regular School No Middle 05 08 2020   grade_7 33 0 20   1 0     0   0   27 27                       54 33 0 20   1 0     0   0   27 27                 54
1812176 1812176 CO     school 800018 3220   Idalia RJ-3 80001801742 4231 Idalia Junior-Senior High School   Regular School No High 07 12 2020   grade_7 11 0 3   0 0     0   0   7 7                       14 11 0 3   0 0     0   0   7 7                 14
1812189 1812189 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2020   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1812204 1812204 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_7 91 1 36   0 11     0   6   67 78                       145 91 1 36   0 11     0   6   67 78                 145
1812339 1812339 CO     school 800020 8001   Charter School Institute 80002001569 2035 Crown Pointe Charter Academy   Regular School Yes Elementary KG 08 2020   grade_7 15 0 34   0 1     0   0   25 25                       50 15 0 34   0 1     0   0   25 25                 50
1812316 1812316 CO     school 800020 8001   Charter School Institute 80002001912 1791 Colorado Springs Charter Academy   Regular School Yes Elementary KG 08 2020   grade_7 26 1 14   0 0     0   3   21 23                       44 26 1 14   0 0     0   3   21 23                 44
1812502 1812502 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2020   grade_7 21 0 4   0 0     0   0   15 10                       25 21 0 4   0 0     0   0   15 10                 25
1812481 1812481 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2020   grade_7 21 0 146   0 6     2   3   79 99                       178 21 0 146   0 6     2   3   79 99                 178
1812233 1812233 CO     school 800020 8001   Charter School Institute 80002002018 653 Stone Creek School   Regular School Yes Elementary KG 08 2020   grade_7 26 0 9   0 0     0   2   22 15                       37 26 0 9   0 0     0   2   22 15                 37
1812243 1812243 CO     school 800020 8001   Charter School Institute 80002002033 655 High Point Academy   Regular School Yes Elementary PK 08 2020   grade_7 13 18 36   1 4     0   0   39 33                       72 13 18 36   1 4     0   0   39 33                 72
1812265 1812265 CO     school 800020 8001   Charter School Institute 80002006305 1279 Caprock Academy   Regular School Yes Other KG 12 2020   grade_7 67 0 13   0 1     0   0   43 38                       81 67 0 13   0 1     0   0   43 38                 81
1812492 1812492 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2020   grade_7 0 0 37   0 0     0   0   19 18                       37 0 0 37   0 0     0   0   19 18                 37
1812360 1812360 CO     school 800020 8001   Charter School Institute 80002006390 2837 Early College of Arvada   Regular School Yes High 06 12 2020   grade_7 11 3 28   0 3     0   0   21 24                       45 11 3 28   0 3     0   0   21 24                 45
1812536 1812536 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_7 60 1 21   0 4     0   7   47 46                       93 60 1 21   0 4     0   7   47 46                 93
1812433 1812433 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2020   grade_7 57 0 4   0 0     1   0   34 28                       62 57 0 4   0 0     1   0   34 28                 62
1812395 1812395 CO     school 800020 8001   Charter School Institute 80002006503 3439 Global Village Academy - Northglenn   Regular School Yes Elementary KG 08 2020   grade_7 24 1 37   0 1     0   0   26 37                       63 24 1 37   0 1     0   0   26 37                 63
1812347 1812347 CO     school 800020 8001   Charter School Institute 80002006542 2067 Colorado Early College Fort Collins   Regular School Yes High 06 12 2020   grade_7 72 2 23   0 1     0   5   57 46                       103 72 2 23   0 1     0   5   57 46                 103
1812548 1812548 CO     school 800020 8001   Charter School Institute 80002006579 9040 Victory Preparatory Academy Middle State Charter School   Regular School Yes Middle 06 08 2020   grade_7 5 1 70   0 0     0   1   41 36                       77 5 1 70   0 0     0   1   41 36                 77
1812370 1812370 CO     school 800020 8001   Charter School Institute 80002006586 3326 Colorado International Language Academy   Regular School Yes Elementary KG 08 2020   grade_7 4 0 4   0 1     0   0   4 5                       9 4 0 4   0 1     0   0   4 5                 9
1812448 1812448 CO     school 800020 8001   Charter School Institute 80002006589 5851 Mountain Song Community School   Regular School Yes Elementary KG 08 2020   grade_7 24 1 10   1 0     0   4   14 26                       40 24 1 10   1 0     0   4   14 26                 40
1812522 1812522 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2020   grade_7 28 0 13   0 2     0   1   22 22                       44 28 0 13   0 2     0   1   22 22                 44
1812384 1812384 CO     school 800020 8001   Charter School Institute 80002006639 3393 Golden View Classical Academy   Regular School Yes Other KG 12 2020   grade_7 42 1 7   0 2     0   3   33 22                       55 42 1 7   0 2     0   3   33 22                 55
1812512 1812512 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2020   grade_7 9 0 0   0 0     0   0   4 5                       9 9 0 0   0 0     0   0   4 5                 9
1812300 1812300 CO     school 800020 8001   Charter School Institute 80002006708 1505 Colorado Military Academy   Regular School Yes Other KG 12 2020   grade_7 32 7 16   0 0     1   0   39 17                       56 32 7 16   0 0     1   0   39 17                 56
1812427 1812427 CO     school 800020 8001   Charter School Institute 80002006761 5431 Coperni 2   Regular School Yes Elementary KG 07 2020   grade_7 5 1 6   1 0     0   0   4 9                       13 5 1 6   1 0     0   0   4 9                 13
1812216 1812216 CO     school 800020 8001   Charter School Institute 80002006777 149 Colorado Early Colleges Fort Collins West   Regular School Yes Middle 06 08 2020   grade_7 9 0 3   0 0     0   0   6 6                       12 9 0 3   0 0     0   0   6 6                 12
1812288 1812288 CO     school 800020 8001   Charter School Institute 80002006779 1387 Colorado Early Colleges Windsor   Regular School Yes Other KG 12 2020   grade_7 30 0 0   0 0     0   1   14 17                       31 30 0 0   0 0     0   1   14 17                 31
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
1812602 1812602 CO     school 800282 9170   Education reEnvisioned BOCES 80028206764 1501 Colorado Preparatory Academy Middle School   Regular School No Middle 06 08 2020   grade_7 139 11 80   2 3     1   8   113 131                       244 139 11 80   2 3     1   8   113 131                 244
1806083 1806083 CO     school 801920 1040   Academy 20 80192000001 74 Challenger Middle School   Regular School No Middle 06 08 2020   grade_7 176 6 35   0 19     1   23   131 129                       260 176 6 35   0 19     1   23   131 129                 260
1806099 1806099 CO     school 801920 1040   Academy 20 80192000858 209 Aspen Valley Campus   Alternative School No High 07 12 2020   grade_7 13 0 1   0 0     0   1   10 5                       15 13 0 1   0 0     0   1   10 5                 15
1806191 1806191 CO     school 801920 1040   Academy 20 80192001402 2358 Eagleview Middle School   Regular School No Middle 06 08 2020   grade_7 258 7 46   0 10     2   17   155 185                       340 258 7 46   0 10     2   17   155 185                 340
1806328 1806328 CO     school 801920 1040   Academy 20 80192001462 8851 Timberview Middle School   Regular School No Middle 06 08 2020   grade_7 238 13 53   4 5     2   29   187 157                       344 238 13 53   4 5     2   29   187 157                 344
1806241 1806241 CO     school 801920 1040   Academy 20 80192001593 6140 Mountain Ridge Middle School   Regular School No Middle 06 08 2020   grade_7 203 13 75   0 19     2   30   163 179                       342 203 13 75   0 19     2   30   163 179                 342
1806147 1806147 CO     school 801920 1040   Academy 20 80192001931 1629 The Classical Academy Middle School   Regular School Yes Middle 07 08 2020   grade_7 193 3 22   2 10     1   6   132 105                       237 193 3 22   2 10     1   6   132 105                 237
1806314 1806314 CO     school 801920 1040   Academy 20 80192006447 8779 TCA College Pathways   Regular School Yes High 07 12 2020   grade_7 40 3 6   0 0     0   6   29 26                       55 40 3 6   0 0     0   6   29 26                 55
1806161 1806161 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2020   grade_7 20 1 5   0 2     0   2   9 21                       30 20 1 5   0 2     0   2   9 21                 30
1806166 1806166 CO     school 801920 1040   Academy 20 80192006616 1921 Discovery Canyon Campus Middle School   Regular School No Middle 06 08 2020   grade_7 186 8 30   0 12     0   26   134 128                       262 186 8 30   0 12     0   26   134 128                 262
1806258 1806258 CO     school 801920 1040   Academy 20 80192006745 6242 New Summit Charter Academy   Regular School Yes Elementary KG 08 2020   grade_7 31 3 6   0 0     1   0   19 22                       41 31 3 6   0 0     1   0   19 22                 41
1806126 1806126 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_7 27 0 3   0 2     0   2   16 18                       34 27 0 3   0 2     0   2   16 18                 34
1806114 1806114 CO     school 801920 1040   Academy 20 80192006788 1421 Chinook Trail Middle School   Regular School No Middle 06 08 2020   grade_7 80 4 16   0 4     0   13   56 61                       117 80 4 16   0 4     0   13   56 61                 117
1799846 1799846 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2020   grade_7 23 3 221   2 0     1   6   121 135                       256 23 3 221   2 0     1   6   121 135                 256
1799883 1799883 CO     school 801950 30   Adams County 14 80195000015 4516 Kearney Middle School   Regular School No Middle 06 08 2020   grade_7 32 5 236   1 0     1   1   151 125                       276 32 5 236   1 0     1   1   151 125                 276
1805211 1805211 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2020   grade_7 1 0 1   0 0     0   0   1 1                       2 1 0 1   0 0     0   0   1 1                 2
1809413 1809413 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   grade_7 5 0 2   0 0     0   1   3 5                       8 5 0 2   0 0     0   1   3 5                 8
1811486 1811486 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   grade_7 25 0 8   0 0     0   1   21 13                       34 25 0 8   0 0     0   1   21 13                 34
1800285 1800285 CO     school 802070 100   Alamosa RE-11J 80207000026 114 Ortega Middle School   Regular School No Middle 06 08 2020   grade_7 41 0 113   2 2     0   2   83 77                       160 41 0 113   2 2     0   2   83 77                 160
1800304 1800304 CO     school 802070 100   Alamosa RE-11J 80207006508 368 Alamosa Ombudsman School of Excellence   Alternative School No High 06 12 2020   grade_7 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
1802669 1802669 CO     school 802130 580   South Conejos RE-10 80213001464 250 Antonito Middle School   Regular School No Middle 07 08 2020   grade_7 0 0 9   0 0     0   0   4 5                       9 0 0 9   0 0     0   0   4 5                 9
1801569 1801569 CO     school 802190 220   Archuleta County 50 Jt 80219000040 6657 Pagosa Springs Middle School   Regular School No Middle 05 08 2020   grade_7 77 0 59   14 0     0   5   77 78                       155 77 0 59   14 0     0   5   77 78                 155
1811508 1811508 CO     school 802220 3040   Arickaree R-2 80222000042 308 Arickaree Undivided High School   Regular School No High 06 12 2020   grade_7 7 1 2   0 0     0   0   2 8                       10 7 1 2   0 0     0   0   2 8                 10
1808465 1808465 CO     school 802260 1450   Arriba-Flagler C-20 80226000509 2960 Flagler Public School   Regular School No Other PK 12 2020   grade_7 9 0 2   0 0     0   0   6 5                       11 9 0 2   0 0     0   0   6 5                 11
1810547 1810547 CO     school 802280 2640   Aspen 1 80228000046 430 Aspen Middle School   Regular School No Middle 05 08 2020   grade_7 93 3 22   0 3     0   1   62 60                       122 93 3 22   0 3     0   1   62 60                 122
1810535 1810535 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2020   grade_7 15 0 0   1 0     0   0   7 9                       16 15 0 0   1 0     0   0   7 9                 16
1812074 1812074 CO     school 802310 3145   Ault-Highland RE-9 80231001466 3961 Highland Middle School   Regular School No Middle 06 08 2020   grade_7 45 0 40   0 0     2   0   47 40                       87 45 0 40   0 0     2   0   47 40                 87
1801082 1801082 CO     school 802340 180   Adams-Arapahoe 28J 80234000054 464 Aurora Hills Middle School   Regular School No Middle 06 08 2020   grade_7 16 61 154   4 7     4   18   147 117                       264 16 61 154   4 7     4   18   147 117                 264
1801102 1801102 CO     school 802340 180   Adams-Arapahoe 28J 80234000055 914 Boston K-8 School   Regular School No Elementary PK 08 2020   grade_7 3 3 36   0 2     0   1   23 22                       45 3 3 36   0 2     0   1   23 22                 45
1801126 1801126 CO     school 802340 180   Adams-Arapahoe 28J 80234000057 1720 Clyde Miller K-8   Regular School No Elementary PK 08 2020   grade_7 7 5 44   1 2     1   4   31 33                       64 7 5 44   1 2     1   4   31 33                 64
1801160 1801160 CO     school 802340 180   Adams-Arapahoe 28J 80234000060 2384 East Middle School   Regular School No Middle 06 08 2020   grade_7 11 39 246   5 8     2   7   164 154                       318 11 39 246   5 8     2   7   164 154                 318
1801289 1801289 CO     school 802340 180   Adams-Arapahoe 28J 80234000073 6160 Mrachek Middle School   Regular School No Middle 06 08 2020   grade_7 55 70 178   1 14     7   25   177 173                       350 55 70 178   1 14     7   25   177 173                 350
1801304 1801304 CO     school 802340 180   Adams-Arapahoe 28J 80234000074 6310 North Middle School Health Sciences and Technology Campus   Regular School No Middle 06 08 2020   grade_7 9 30 157   0 5     4   5   113 97                       210 9 30 157   0 5     4   5   113 97                 210
1801393 1801393 CO     school 802340 180   Adams-Arapahoe 28J 80234000079 8078 South Middle School   Regular School No Middle 06 08 2020   grade_7 9 59 155   2 4     10   12   129 122                       251 9 59 155   2 4     10   12   129 122                 251
1801483 1801483 CO     school 802340 180   Adams-Arapahoe 28J 80234000082 9396 Aurora West College Preparatory Academy   Regular School No High 06 12 2020   grade_7 9 27 167   1 23     1   5   122 111                       233 9 27 167   1 23     1   5   122 111                 233
1801132 1801132 CO     school 802340 180   Adams-Arapahoe 28J 80234001322 1800 Columbia Middle School   Regular School No Middle 06 08 2020   grade_7 55 49 116   2 7     1   27   136 121                       257 55 49 116   2 7     1   27   136 121                 257
1801351 1801351 CO     school 802340 180   Adams-Arapahoe 28J 80234001674 7232 Aurora Quest K-8   Regular School No Elementary KG 08 2020   grade_7 37 13 21   0 12     1   6   36 54                       90 37 13 21   0 12     1   6   36 54                 90
1801077 1801077 CO     school 802340 180   Adams-Arapahoe 28J 80234001759 458 Aurora Academy Charter School   Regular School Yes Elementary KG 08 2020   grade_7 13 22 20   0 3     0   0   30 28                       58 13 22 20   0 3     0   0   30 28                 58
1801316 1801316 CO     school 802340 180   Adams-Arapahoe 28J 80234001789 6546 Options School   Regular School No Other KG 12 2020   grade_7 62 3 17   0 1     0   2   44 41                       85 62 3 17   0 1     0   2   44 41                 85
1801298 1801298 CO     school 802340 180   Adams-Arapahoe 28J 80234001881 6189 Murphy Creek K-8 School   Regular School No Elementary PK 08 2020   grade_7 35 13 35   0 5     0   9   42 55                       97 35 13 35   0 5     0   9   42 55                 97
1801265 1801265 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2020   grade_7 11 30 46   2 3     0   1   39 54                       93 11 30 46   2 3     0   1   39 54                 93
1801091 1801091 CO     school 802340 180   Adams-Arapahoe 28J 80234002009 465 Aurora Frontier K-8   Regular School No Elementary PK 08 2020   grade_7 17 10 24   0 6     0   3   38 22                       60 17 10 24   0 6     0   3   38 22                 60
1801205 1801205 CO     school 802340 180   Adams-Arapahoe 28J 80234006318 3471 Global Village Academy Aurora   Regular School Yes Elementary KG 08 2020   grade_7 14 18 63   0 1     0   5   55 46                       101 14 18 63   0 1     0   5   55 46                 101
1801421 1801421 CO     school 802340 180   Adams-Arapahoe 28J 80234006322 9056 Vanguard Classical School - West   Regular School Yes Elementary KG 08 2020   grade_7 5 4 35   0 0     0   3   25 22                       47 5 4 35   0 0     0   3   25 22                 47
1801050 1801050 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_7 9 14 22   0 1     1   6   31 22                       53 9 14 22   0 1     1   6   31 22                 53
1801447 1801447 CO     school 802340 180   Adams-Arapahoe 28J 80234006483 9083 Vista Peak P-8 Exploratory   Regular School No Elementary PK 08 2020   grade_7 31 13 68   0 6     0   9   71 56                       127 31 13 68   0 6     0   9   71 56                 127
1801474 1801474 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2020   grade_7 6 19 25   1 1     0   3   26 29                       55 6 19 25   1 1     0   3   26 29                 55
1801179 1801179 CO     school 802340 180   Adams-Arapahoe 28J 80234006644 2673 Edna and John W. Mosley P-8   Regular School No Elementary PK 08 2020   grade_7 14 18 69   3 4     2   4   58 56                       114 14 18 69   3 4     2   4   58 56                 114
1801412 1801412 CO     school 802340 180   Adams-Arapahoe 28J 80234006732 9053 Vega Collegiate Academy   Regular School Yes Elementary KG 07 2020   grade_7 4 6 44   0 7     0   1   27 35                       62 4 6 44   0 7     0   1   27 35                 62
1801036 1801036 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2020   grade_7 6 12 59   1 0     1   6   36 49                       85 6 12 59   1 0     1   6   36 49                 85
1810451 1810451 CO     school 802370 2600   Platte Canyon 1 80237001325 7048 Fitzsimmons Middle School   Regular School No Middle 06 08 2020   grade_7 53 1 8   0 0     0   3   42 23                       65 53 1 8   0 0     0   3   42 23                 65
1808667 1808667 CO     school 802400 1530   Bayfield 10 Jt-R 80240000089 636 Bayfield Middle School   Regular School No Middle 06 08 2020   grade_7 97 0 20   8 2     0   5   68 64                       132 97 0 20   8 2     0   5   68 64                 132
1800114 1800114 CO     school 802430 50   Bennett 29J 80243000093 774 Bennett Middle School   Regular School No Middle 07 08 2020   grade_7 57 3 27   1 0     0   7   53 42                       95 57 3 27   1 0     0   7   53 42                 95
1808512 1808512 CO     school 802460 1490   Bethune R-5 80246000095 842 Bethune Public Schools   Regular School No Other PK 12 2020   grade_7 8 0 5   0 0     0   0   6 7                       13 8 0 5   0 0     0   0   6 7                 13
1802165 1802165 CO     school 802490 480   Boulder Valley Re 2 80249000102 1066 Broomfield Heights Middle School   Regular School No Middle 06 08 2020   grade_7 121 2 37   1 7     0   14   83 99                       182 121 2 37   1 7     0   14   83 99                 182
1802174 1802174 CO     school 802490 480   Boulder Valley Re 2 80249000104 1136 Manhattan Middle School of the Arts and Academics   Regular School No Middle 06 08 2020   grade_7 104 2 33   1 4     0   7   60 91                       151 104 2 33   1 4     0   7   60 91                 151
1802178 1802178 CO     school 802490 480   Boulder Valley Re 2 80249000106 1352 Casey Middle School   Regular School No Middle 06 08 2020   grade_7 108 3 79   0 3     1   6   114 86                       200 108 3 79   0 3     1   6   114 86                 200
1802187 1802187 CO     school 802490 480   Boulder Valley Re 2 80249000108 1390 Centennial Middle School   Regular School No Middle 06 08 2020   grade_7 135 1 44   1 9     0   10   107 93                       200 135 1 44   1 9     0   10   107 93                 200
1802345 1802345 CO     school 802490 480   Boulder Valley Re 2 80249000122 4878 Angevine Middle School   Regular School No Middle 06 08 2020   grade_7 119 5 103   1 8     0   16   122 130                       252 119 5 103   1 8     0   16   122 130                 252
1802356 1802356 CO     school 802490 480   Boulder Valley Re 2 80249000125 5306 Louisville Middle School   Regular School No Middle 06 08 2020   grade_7 189 3 21   1 3     1   16   127 107                       234 189 3 21   1 3     1   16   127 107                 234
1802409 1802409 CO     school 802490 480   Boulder Valley Re 2 80249000131 6212 Nederland Middle-Senior High School   Regular School No High 06 12 2020   grade_7 34 0 3   0 0     1   3   25 16                       41 34 0 3   0 0     1   3   25 16                 41
1802414 1802414 CO     school 802490 480   Boulder Valley Re 2 80249000132 6224 Nevin Platt Middle School   Regular School No Middle 06 08 2020   grade_7 142 2 17   1 3     0   17   86 96                       182 142 2 17   1 3     0   17   86 96                 182
1802466 1802466 CO     school 802490 480   Boulder Valley Re 2 80249000134 8135 Southern Hills Middle School   Regular School No Middle 06 08 2020   grade_7 138 3 12   0 6     1   15   88 87                       175 138 3 12   0 6     1   15   88 87                 175
1802470 1802470 CO     school 802490 480   Boulder Valley Re 2 80249001517 8387 Summit Middle Charter School   Regular School Yes Middle 06 08 2020   grade_7 82 1 3   0 21     0   14   54 67                       121 82 1 3   0 21     0   14   54 67                 121
1802387 1802387 CO     school 802490 480   Boulder Valley Re 2 80249001573 6000 Monarch K-8 School   Regular School No Elementary PK 08 2020   grade_7 108 2 7   0 11     0   3   69 62                       131 108 2 7   0 11     0   3   69 62                 131
1802118 1802118 CO     school 802490 480   Boulder Valley Re 2 80249001758 441 Aspen Creek K-8 School   Regular School No Elementary PK 08 2020   grade_7 103 3 18   1 9     0   4   85 53                       138 103 3 18   1 9     0   4   85 53                 138
1802241 1802241 CO     school 802490 480   Boulder Valley Re 2 80249001771 2589 Eldorado K-8 School   Regular School No Elementary PK 08 2020   grade_7 102 0 8   0 12     1   10   71 62                       133 102 0 8   0 12     1   10   71 62                 133
1802436 1802436 CO     school 802490 480   Boulder Valley Re 2 80249001792 6816 Peak to Peak Charter School   Regular School Yes Other KG 12 2020   grade_7 92 1 16   1 20     2   4   77 59                       136 92 1 16   1 20     2   4   77 59                 136
1802324 1802324 CO     school 802490 480   Boulder Valley Re 2 80249002013 4496 Justice High Charter School   Alternative School Yes High 06 12 2020   grade_7 2 0 2   0 0     0   0   3 1                       4 2 0 2   0 0     0   0   3 1                 4

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