enrollments

Data source: Big Local News · About: Big Local

634 rows where grade = "grade_7", state = "CO" and year = 2021 sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 634 ✖

grade ✖

  • grade_7 · 634 ✖
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
1741546 1741546 CO     school 800001 520   Cheyenne County Re-5 80000100215 1612 Cheyenne Wells Junior/High School   Regular School No High 07 12 2021   grade_7 8 1 2   0 0     0   0   3 8                       11 8 1 2   0 0     0   0   3 8                 11
1751495 1751495 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   grade_7 36 1 7   0 1     0   7   32 20                       52 36 1 7   0 1     0   7   32 20                 52
1751019 1751019 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2021   grade_7 25 0 44   0 0     0   0   31 38                       69 25 0 44   0 0     0   0   31 38                 69
1751045 1751045 CO     school 800017 3210   Wray RD-2 80001701818 9733 Wray Junior Senior High School   Regular School No High 07 12 2021   grade_7 33 0 15   0 0     0   0   22 26                       48 33 0 15   0 0     0   0   22 26                 48
1751061 1751061 CO     school 800018 3220   Idalia RJ-3 80001801742 4231 Idalia Junior-Senior High School   Regular School No High 07 12 2021   grade_7 14 0 3   0 0     0   0   7 10                       17 14 0 3   0 0     0   0   7 10                 17
1751074 1751074 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   grade_7 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
1751089 1751089 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_7 96 1 39   0 11     0   4   75 76                       151 96 1 39   0 11     0   4   75 76                 151
1751246 1751246 CO     school 800020 8001   Charter School Institute 80002001569 2035 Crown Pointe Charter Academy   Regular School Yes Elementary KG 08 2021   grade_7 21 0 32   0 1     0   2   20 36                       56 21 0 32   0 1     0   2   20 36                 56
1751224 1751224 CO     school 800020 8001   Charter School Institute 80002001912 1791 Colorado Springs Charter Academy   Regular School Yes Elementary KG 08 2021   grade_7 28 0 7   0 0     0   3   20 18                       38 28 0 7   0 0     0   3   20 18                 38
1751409 1751409 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2021   grade_7 11 0 6   0 0     1   0   9 9                       18 11 0 6   0 0     1   0   9 9                 18
1751388 1751388 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   grade_7 15 2 161   0 2     0   5   85 100                       185 15 2 161   0 2     0   5   85 100                 185
1751132 1751132 CO     school 800020 8001   Charter School Institute 80002002018 653 Stone Creek School   Regular School Yes Elementary KG 08 2021   grade_7 25 1 12   0 0     0   1   28 11                       39 25 1 12   0 0     0   1   28 11                 39
1751142 1751142 CO     school 800020 8001   Charter School Institute 80002002033 655 High Point Academy   Regular School Yes Elementary PK 08 2021   grade_7 13 18 47   2 2     0   1   46 37                       83 13 18 47   2 2     0   1   46 37                 83
1751171 1751171 CO     school 800020 8001   Charter School Institute 80002006305 1279 Caprock Academy   Regular School Yes Other KG 12 2021   grade_7 65 1 11   0 2     0   4   40 43                       83 65 1 11   0 2     0   4   40 43                 83
1751399 1751399 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2021   grade_7 1 0 38   0 0     0   0   20 19                       39 1 0 38   0 0     0   0   20 19                 39
1751267 1751267 CO     school 800020 8001   Charter School Institute 80002006390 2837 Early College of Arvada   Regular School Yes High 06 12 2021   grade_7 9 1 22   0 2     0   0   18 16                       34 9 1 22   0 2     0   0   18 16                 34
1751443 1751443 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   grade_7 55 2 19   1 3     0   11   46 45                       91 55 2 19   1 3     0   11   46 45                 91
1751339 1751339 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2021   grade_7 54 0 4   1 1     0   1   31 30                       61 54 0 4   1 1     0   1   31 30                 61
1751300 1751300 CO     school 800020 8001   Charter School Institute 80002006503 3439 Global Village Academy - Northglenn   Regular School Yes Elementary KG 08 2021   grade_7 24 1 37   0 2     0   0   23 41                       64 24 1 37   0 2     0   0   23 41                 64
1751254 1751254 CO     school 800020 8001   Charter School Institute 80002006542 2067 Colorado Early College Fort Collins   Regular School Yes High 06 12 2021   grade_7 46 1 12   0 2     0   1   32 30                       62 46 1 12   0 2     0   1   32 30                 62
1751455 1751455 CO     school 800020 8001   Charter School Institute 80002006579 9040 Victory Preparatory Academy Middle State Charter School   Regular School Yes Middle 06 08 2021   grade_7 3 1 60   0 0     0   1   27 38                       65 3 1 60   0 0     0   1   27 38                 65
1751355 1751355 CO     school 800020 8001   Charter School Institute 80002006589 5851 Mountain Song Community School   Regular School Yes Elementary KG 08 2021   grade_7 19 0 11   1 1     0   4   21 15                       36 19 0 11   1 1     0   4   21 15                 36
1751429 1751429 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2021   grade_7 25 0 12   0 1     0   0   20 18                       38 25 0 12   0 1     0   0   20 18                 38
1751288 1751288 CO     school 800020 8001   Charter School Institute 80002006639 3393 Golden View Classical Academy   Regular School Yes Other KG 12 2021   grade_7 53 0 3   0 3     0   2   28 33                       61 53 0 3   0 3     0   2   28 33                 61
1751419 1751419 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2021   grade_7 7 1 0   0 0     0   0   5 3                       8 7 1 0   0 0     0   0   5 3                 8
1751208 1751208 CO     school 800020 8001   Charter School Institute 80002006708 1505 Colorado Military Academy   Regular School Yes Other KG 11 2021   grade_7 33 8 26   0 1     0   3   44 27                       71 33 8 26   0 1     0   3   44 27                 71
1751109 1751109 CO     school 800020 8001   Charter School Institute 80002006760 79 Ascent Classical Academy   Regular School Yes Other KG 12 2021   grade_7 54 1 8   0 3     0   4   40 30                       70 54 1 8   0 3     0   4   40 30                 70
1751332 1751332 CO     school 800020 8001   Charter School Institute 80002006761 5431 Coperni 2   Regular School Yes Elementary KG 08 2021   grade_7 3 5 6   0 0     0   0   7 7                       14 3 5 6   0 0     0   0   7 7                 14
1751115 1751115 CO     school 800020 8001   Charter School Institute 80002006777 149 Colorado Early Colleges Fort Collins West   Regular School Yes Middle 06 08 2021   grade_7 112 0 10   0 3     0   3   80 48                       128 112 0 10   0 3     0   3   80 48                 128
1751195 1751195 CO     school 800020 8001   Charter School Institute 80002006779 1387 Colorado Early Colleges Windsor   Regular School Yes Other KG 12 2021   grade_7 31 0 7   0 0     0   4   19 23                       42 31 0 7   0 0     0   4   19 23                 42
1751183 1751183 CO     school 800020 8001   Charter School Institute 80002006784 1371 Coperni 3   Regular School Yes Elementary KG 07 2021   grade_7 13 5 13   0 1     1   1   18 16                       34 13 5 13   0 1     1   1   18 16                 34
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
1751508 1751508 CO     school 800282 9170   Education reEnvisioned BOCES 80028206764 1501 Colorado Preparatory Academy Middle School   Regular School No Middle 06 08 2021   grade_7 214 15 123   2 2     3   34   212 181                       393 214 15 123   2 2     3   34   212 181                 393
1751523 1751523 CO     school 800282 9170   Education reEnvisioned BOCES 80028206804 1892 Orton Academy   Regular School No Other KG 12 2021   grade_7 8 0 0   0 0     0   0   3 5                       8 8 0 0   0 0     0   0   3 5                 8
1744993 1744993 CO     school 801920 1040   Academy 20 80192000001 74 Challenger Middle School   Regular School No Middle 06 08 2021   grade_7 137 3 28   2 13     0   19   107 95                       202 137 3 28   2 13     0   19   107 95                 202
1745009 1745009 CO     school 801920 1040   Academy 20 80192000858 209 Aspen Valley Campus   Alternative School No High 07 12 2021   grade_7 8 0 0   0 0     0   1   7 2                       9 8 0 0   0 0     0   1   7 2                 9
1745099 1745099 CO     school 801920 1040   Academy 20 80192001402 2358 Eagleview Middle School   Regular School No Middle 06 08 2021   grade_7 224 10 54   1 7     0   25   151 170                       321 224 10 54   1 7     0   25   151 170                 321
1745232 1745232 CO     school 801920 1040   Academy 20 80192001462 8851 Timberview Middle School   Regular School No Middle 06 08 2021   grade_7 228 9 56   1 6     0   25   164 161                       325 228 9 56   1 6     0   25   164 161                 325
1745147 1745147 CO     school 801920 1040   Academy 20 80192001593 6140 Mountain Ridge Middle School   Regular School No Middle 06 08 2021   grade_7 185 9 60   0 13     3   20   141 149                       290 185 9 60   0 13     3   20   141 149                 290
1745056 1745056 CO     school 801920 1040   Academy 20 80192001931 1629 The Classical Academy Middle School   Regular School Yes Middle 07 08 2021   grade_7 161 7 23   0 6     1   14   101 111                       212 161 7 23   0 6     1   14   101 111                 212
1745219 1745219 CO     school 801920 1040   Academy 20 80192006447 8779 TCA College Pathways   Regular School Yes High 07 12 2021   grade_7 42 2 5   0 2     0   5   32 24                       56 42 2 5   0 2     0   5   32 24                 56
1745070 1745070 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2021   grade_7 18 0 3   0 0     0   0   9 12                       21 18 0 3   0 0     0   0   9 12                 21
1745075 1745075 CO     school 801920 1040   Academy 20 80192006616 1921 Discovery Canyon Campus Middle School   Regular School No Middle 06 08 2021   grade_7 176 12 32   0 15     1   14   122 128                       250 176 12 32   0 15     1   14   122 128                 250
1745164 1745164 CO     school 801920 1040   Academy 20 80192006745 6242 New Summit Charter Academy   Regular School Yes Elementary KG 08 2021   grade_7 35 2 4   0 3     0   2   22 24                       46 35 2 4   0 3     0   2   22 24                 46
1745036 1745036 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2021   grade_7 24 3 3   0 0     0   1   16 15                       31 24 3 3   0 0     0   1   16 15                 31
1745024 1745024 CO     school 801920 1040   Academy 20 80192006788 1421 Chinook Trail Middle School   Regular School No Middle 06 08 2021   grade_7 199 5 38   1 26     0   26   152 143                       295 199 5 38   1 26     0   26   152 143                 295
1738787 1738787 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2021   grade_7 22 3 216   1 0     0   3   134 111                       245 22 3 216   1 0     0   3   134 111                 245
1738824 1738824 CO     school 801950 30   Adams County 14 80195000015 4516 Kearney Middle School   Regular School No Middle 06 08 2021   grade_7 26 2 212   1 0     0   1   128 114                       242 26 2 212   1 0     0   1   128 114                 242
1744128 1744128 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2021   grade_7 5 0 0   0 0     0   0   4 1                       5 5 0 0   0 0     0   0   4 1                 5
1748272 1748272 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2021   grade_7 2 0 7   0 0     0   0   7 2                       9 2 0 7   0 0     0   0   7 2                 9
1750359 1750359 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2021   grade_7 17 0 3   1 0     0   0   12 9                       21 17 0 3   1 0     0   0   12 9                 21
1739228 1739228 CO     school 802070 100   Alamosa RE-11J 80207000026 114 Ortega Middle School   Regular School No Middle 06 08 2021   grade_7 28 0 92   1 0     1   0   64 58                       122 28 0 92   1 0     1   0   64 58                 122
1739249 1739249 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_7 9 2 34   2 1     0   2   27 23                       50 9 2 34   2 1     0   2   27 23                 50
1741643 1741643 CO     school 802130 580   South Conejos RE-10 80213001464 250 Antonito Middle School   Regular School No Middle 07 08 2021   grade_7 1 0 12   0 0     0   0   8 5                       13 1 0 12   0 0     0   0   8 5                 13
1740537 1740537 CO     school 802190 220   Archuleta County 50 Jt 80219000040 6657 Pagosa Springs Middle School   Regular School No Middle 05 08 2021   grade_7 53 1 48   8 3     0   7   63 57                       120 53 1 48   8 3     0   7   63 57                 120
1740551 1740551 CO     school 802190 220   Archuleta County 50 Jt 80219006717 6679 Pagosa Peak Open School   Regular School Yes Elementary KG 07 2021   grade_7 8 0 8   2 0     0   0   7 11                       18 8 0 8   2 0     0   0   7 11                 18
1750381 1750381 CO     school 802220 3040   Arickaree R-2 80222000042 308 Arickaree Undivided High School   Regular School No High 06 12 2021   grade_7 3 0 3   0 0     0   0   4 2                       6 3 0 3   0 0     0   0   4 2                 6
1747349 1747349 CO     school 802260 1450   Arriba-Flagler C-20 80226000509 2960 Flagler Public School   Regular School No Other PK 12 2021   grade_7 13 0 0   0 1     0   0   7 7                       14 13 0 0   0 1     0   0   7 7                 14
1749415 1749415 CO     school 802280 2640   Aspen 1 80228000046 430 Aspen Middle School   Regular School No Middle 05 08 2021   grade_7 96 0 16   0 0     0   2   69 45                       114 96 0 16   0 0     0   2   69 45                 114
1749403 1749403 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2021   grade_7 13 0 1   0 0     0   0   8 6                       14 13 0 1   0 0     0   0   8 6                 14
1750960 1750960 CO     school 802310 3145   Ault-Highland RE-9 80231001466 3961 Highland Middle School   Regular School No Middle 06 08 2021   grade_7 55 0 17   0 0     0   4   42 34                       76 55 0 17   0 0     0   4   42 34                 76
1740031 1740031 CO     school 802340 180   Adams-Arapahoe 28J 80234000054 464 Aurora Hills Middle School   Regular School No Middle 06 08 2021   grade_7 19 50 139   1 12     6   14   126 115                       241 19 50 139   1 12     6   14   126 115                 241
1740051 1740051 CO     school 802340 180   Adams-Arapahoe 28J 80234000055 914 Boston K-8 School   Regular School No Elementary PK 08 2021   grade_7 1 9 30   0 2     0   0   21 21                       42 1 9 30   0 2     0   0   21 21                 42
1740075 1740075 CO     school 802340 180   Adams-Arapahoe 28J 80234000057 1720 Clyde Miller K-8   Regular School No Elementary PK 08 2021   grade_7 7 2 40   0 3     1   1   25 29                       54 7 2 40   0 3     1   1   25 29                 54
1740120 1740120 CO     school 802340 180   Adams-Arapahoe 28J 80234000060 2384 East Middle School   Regular School No Middle 06 08 2021   grade_7 6 28 198   3 8     3   6   135 117                       252 6 28 198   3 8     3   6   135 117                 252
1740250 1740250 CO     school 802340 180   Adams-Arapahoe 28J 80234000073 6160 Mrachek Middle School   Regular School No Middle 06 08 2021   grade_7 41 55 150   3 11     5   18   144 139                       283 41 55 150   3 11     5   18   144 139                 283
1740265 1740265 CO     school 802340 180   Adams-Arapahoe 28J 80234000074 6310 North Middle School Health Sciences and Technology Campus   Regular School No Middle 06 08 2021   grade_7 10 27 130   1 8     5   7   112 76                       188 10 27 130   1 8     5   7   112 76                 188
1740354 1740354 CO     school 802340 180   Adams-Arapahoe 28J 80234000079 8078 South Middle School   Regular School No Middle 06 08 2021   grade_7 17 29 155   3 6     4   7   108 113                       221 17 29 155   3 6     4   7   108 113                 221
1740446 1740446 CO     school 802340 180   Adams-Arapahoe 28J 80234000082 9396 Aurora West College Preparatory Academy   Regular School No High 06 12 2021   grade_7 8 22 157   3 15     2   5   114 98                       212 8 22 157   3 15     2   5   114 98                 212
1740081 1740081 CO     school 802340 180   Adams-Arapahoe 28J 80234001322 1800 Columbia Middle School   Regular School No Middle 06 08 2021   grade_7 47 35 111   1 9     0   18   118 103                       221 47 35 111   1 9     0   18   118 103                 221
1740312 1740312 CO     school 802340 180   Adams-Arapahoe 28J 80234001674 7232 Aurora Quest K-8   Regular School No Elementary KG 08 2021   grade_7 31 8 24   0 13     0   11   48 39                       87 31 8 24   0 13     0   11   48 39                 87
1740026 1740026 CO     school 802340 180   Adams-Arapahoe 28J 80234001759 458 Aurora Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_7 11 21 24   0 1     0   3   34 26                       60 11 21 24   0 1     0   3   34 26                 60
1740277 1740277 CO     school 802340 180   Adams-Arapahoe 28J 80234001789 6546 Options School   Regular School No Other KG 12 2021   grade_7 56 1 10   0 1     0   6   36 38                       74 56 1 10   0 1     0   6   36 38                 74
1740259 1740259 CO     school 802340 180   Adams-Arapahoe 28J 80234001881 6189 Murphy Creek K-8 School   Regular School No Elementary PK 08 2021   grade_7 26 9 10   1 6     0   8   30 30                       60 26 9 10   1 6     0   8   30 30                 60
1740226 1740226 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2021   grade_7 13 42 42   0 1     0   2   54 46                       100 13 42 42   0 1     0   2   54 46                 100
1740040 1740040 CO     school 802340 180   Adams-Arapahoe 28J 80234002009 465 Aurora Frontier K-8   Regular School No Elementary PK 08 2021   grade_7 35 9 43   0 13     0   2   55 47                       102 35 9 43   0 13     0   2   55 47                 102
1740166 1740166 CO     school 802340 180   Adams-Arapahoe 28J 80234006318 3471 Global Village Academy Aurora   Regular School Yes Elementary KG 08 2021   grade_7 4 27 55   0 2     0   5   46 47                       93 4 27 55   0 2     0   5   46 47                 93
1740384 1740384 CO     school 802340 180   Adams-Arapahoe 28J 80234006322 9056 Vanguard Classical School - West   Regular School Yes Elementary KG 08 2021   grade_7 4 10 21   0 0     0   2   14 23                       37 4 10 21   0 0     0   2   14 23                 37
1739999 1739999 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2021   grade_7 9 20 16   0 0     1   4   29 21                       50 9 20 16   0 0     1   4   29 21                 50
1740410 1740410 CO     school 802340 180   Adams-Arapahoe 28J 80234006483 9083 Vista Peak P-8 Exploratory   Regular School No Elementary PK 08 2021   grade_7 29 14 42   0 2     0   12   42 57                       99 29 14 42   0 2     0   12   42 57                 99
1740437 1740437 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2021   grade_7 13 17 25   0 2     0   4   22 39                       61 13 17 25   0 2     0   4   22 39                 61
1740140 1740140 CO     school 802340 180   Adams-Arapahoe 28J 80234006644 2673 Edna and John W. Mosley P-8   Regular School No Elementary PK 08 2021   grade_7 12 17 54   1 0     5   3   54 38                       92 12 17 54   1 0     5   3   54 38                 92
1740374 1740374 CO     school 802340 180   Adams-Arapahoe 28J 80234006732 9053 Vega Collegiate Academy   Regular School Yes Elementary KG 08 2021   grade_7 2 4 26   1 5     0   0   23 15                       38 2 4 26   1 5     0   0   23 15                 38
1739984 1739984 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2021   grade_7 7 28 67   0 1     0   6   59 50                       109 7 28 67   0 1     0   6   59 50                 109
1739989 1739989 CO     school 802340 180   Adams-Arapahoe 28J 80234006787 127 Aurora Science & Tech Middle School   Regular School Yes Middle 06 07 2021   grade_7 16 23 115   0 4     2   11   97 74                       171 16 23 115   0 4     2   11   97 74                 171
1740090 1740090 CO     school 802340 180   Adams-Arapahoe 28J 80234006803 1851 Harmony Ridge P-8   Regular School No Elementary PK 08 2021   grade_7 7 9 44   3 0     0   3   31 35                       66 7 9 44   3 0     0   3   31 35                 66
1749320 1749320 CO     school 802370 2600   Platte Canyon 1 80237001325 7048 Fitzsimmons Middle School   Regular School No Middle 06 08 2021   grade_7 52 0 5   0 0     0   2   37 22                       59 52 0 5   0 0     0   2   37 22                 59
1747552 1747552 CO     school 802400 1530   Bayfield 10 Jt-R 80240000089 636 Bayfield Middle School   Regular School No Middle 06 08 2021   grade_7 70 0 23   6 0     1   4   59 45                       104 70 0 23   6 0     1   4   59 45                 104
1739053 1739053 CO     school 802430 50   Bennett 29J 80243000093 774 Bennett Middle School   Regular School No Middle 07 08 2021   grade_7 46 1 43   0 0     0   3   42 51                       93 46 1 43   0 0     0   3   42 51                 93
1747396 1747396 CO     school 802460 1490   Bethune R-5 80246000095 842 Bethune Public Schools   Regular School No Other PK 12 2021   grade_7 4 0 6   0 0     0   0   3 7                       10 4 0 6   0 0     0   0   3 7                 10
1741136 1741136 CO     school 802490 480   Boulder Valley Re 2 80249000102 1066 Broomfield Heights Middle School   Regular School No Middle 06 08 2021   grade_7 112 5 58   0 2     0   9   91 95                       186 112 5 58   0 2     0   9   91 95                 186
1741145 1741145 CO     school 802490 480   Boulder Valley Re 2 80249000104 1136 Manhattan Middle School of the Arts and Academics   Regular School No Middle 06 08 2021   grade_7 120 4 40   0 5     0   17   89 97                       186 120 4 40   0 5     0   17   89 97                 186
1741149 1741149 CO     school 802490 480   Boulder Valley Re 2 80249000106 1352 Casey Middle School   Regular School No Middle 06 08 2021   grade_7 83 3 69   0 1     0   8   82 82                       164 83 3 69   0 1     0   8   82 82                 164
1741158 1741158 CO     school 802490 480   Boulder Valley Re 2 80249000108 1390 Centennial Middle School   Regular School No Middle 06 08 2021   grade_7 118 2 49   1 8     0   12   112 78                       190 118 2 49   1 8     0   12   112 78                 190
1741317 1741317 CO     school 802490 480   Boulder Valley Re 2 80249000122 4878 Angevine Middle School   Regular School No Middle 06 08 2021   grade_7 96 0 74   1 10     0   13   99 95                       194 96 0 74   1 10     0   13   99 95                 194
1741328 1741328 CO     school 802490 480   Boulder Valley Re 2 80249000125 5306 Louisville Middle School   Regular School No Middle 06 08 2021   grade_7 142 2 21   0 10     0   8   86 97                       183 142 2 21   0 10     0   8   86 97                 183
1741381 1741381 CO     school 802490 480   Boulder Valley Re 2 80249000131 6212 Nederland Middle-Senior High School   Regular School No High 06 12 2021   grade_7 29 0 1   1 0     0   0   18 13                       31 29 0 1   1 0     0   0   18 13                 31
1741386 1741386 CO     school 802490 480   Boulder Valley Re 2 80249000132 6224 Nevin Platt Middle School   Regular School No Middle 06 08 2021   grade_7 122 3 14   0 3     0   9   90 61                       151 122 3 14   0 3     0   9   90 61                 151
1741438 1741438 CO     school 802490 480   Boulder Valley Re 2 80249000134 8135 Southern Hills Middle School   Regular School No Middle 06 08 2021   grade_7 115 0 11   0 17     0   12   86 69                       155 115 0 11   0 17     0   12   86 69                 155
1741442 1741442 CO     school 802490 480   Boulder Valley Re 2 80249001517 8387 Summit Middle Charter School   Regular School Yes Middle 06 08 2021   grade_7 81 2 10   0 10     0   15   58 60                       118 81 2 10   0 10     0   15   58 60                 118

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