Data source: Big Local News · About: Big Local

92,494 rows where state = "CO" sorted by ccd_school_low_grade

View and edit SQL

grade

year

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
710112 CO     school 805250 290   LAS ANIMAS RE-1 80525006678 443 AIM GLOBAL   Regular School No Other 06 12 2017   pk_12_total 172 10 345   3 3     0   0   262 271                       533 172 10 345   3 3     0   0   262 271                 533
710121 CO     school 805250 290   LAS ANIMAS RE-1 80525006679 4279 IMMERSION SCHOOLS SCIENCE TECHNOLOGY ARTS   Regular School No Other 06 12 2017   grade_10 17 1 1   0 2     0   0   4 17                       21 17 1 1   0 2     0   0   4 17                 21
710122 CO     school 805250 290   LAS ANIMAS RE-1 80525006679 4279 IMMERSION SCHOOLS SCIENCE TECHNOLOGY ARTS   Regular School No Other 06 12 2017   grade_11 15 1 2   0 0     0   0   3 15                       18 15 1 2   0 0     0   0   3 15                 18
710123 CO     school 805250 290   LAS ANIMAS RE-1 80525006679 4279 IMMERSION SCHOOLS SCIENCE TECHNOLOGY ARTS   Regular School No Other 06 12 2017   grade_12 11 1 0   0 2     0   0   2 12                       14 11 1 0   0 2     0   0   2 12                 14
710124 CO     school 805250 290   LAS ANIMAS RE-1 80525006679 4279 IMMERSION SCHOOLS SCIENCE TECHNOLOGY ARTS   Regular School No Other 06 12 2017   grade_6 8 0 1   0 0     0   0   2 7                       9 8 0 1   0 0     0   0   2 7                 9
710125 CO     school 805250 290   LAS ANIMAS RE-1 80525006679 4279 IMMERSION SCHOOLS SCIENCE TECHNOLOGY ARTS   Regular School No Other 06 12 2017   grade_7 10 1 2   0 0     0   0   1 12                       13 10 1 2   0 0     0   0   1 12                 13
710126 CO     school 805250 290   LAS ANIMAS RE-1 80525006679 4279 IMMERSION SCHOOLS SCIENCE TECHNOLOGY ARTS   Regular School No Other 06 12 2017   grade_8 21 0 0   1 0     0   0   4 18                       22 21 0 0   1 0     0   0   4 18                 22
710127 CO     school 805250 290   LAS ANIMAS RE-1 80525006679 4279 IMMERSION SCHOOLS SCIENCE TECHNOLOGY ARTS   Regular School No Other 06 12 2017   grade_9 15 1 5   0 0     0   0   7 14                       21 15 1 5   0 0     0   0   7 14                 21
710128 CO     school 805250 290   LAS ANIMAS RE-1 80525006679 4279 IMMERSION SCHOOLS SCIENCE TECHNOLOGY ARTS   Regular School No Other 06 12 2017   pk_12_total 97 5 11   1 4     0   0   23 95                       118 97 5 11   1 4     0   0   23 95                 118
710196 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001886 226 ALTONA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 197 0 33   1 31     1   6   144 125                       269 197 0 33   1 31     1   6   144 125                 269
710197 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001886 226 ALTONA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 213 8 26   0 25     1   9   133 149                       282 213 8 26   0 25     1   9   133 149                 282
710198 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001886 226 ALTONA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 197 1 32   0 22     1   8   133 128                       261 197 1 32   0 22     1   8   133 128                 261
710199 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001886 226 ALTONA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 607 9 91   1 78     3   23   410 402                       812 607 9 91   1 78     3   23   410 402                 812
710285 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000900 2760 ERIE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 284 0 38   3 6     0   9   176 164                       340 284 0 38   3 6     0   9   176 164                 340
710286 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000900 2760 ERIE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 298 3 37   0 9     0   6   165 188                       353 298 3 37   0 9     0   6   165 188                 353
710287 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000900 2760 ERIE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 256 2 34   0 13     0   6   162 149                       311 256 2 34   0 13     0   6   162 149                 311
710288 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000900 2760 ERIE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 838 5 109   3 28     0   21   503 501                       1004 838 5 109   3 28     0   21   503 501                 1004
710326 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001774 3194 COAL RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 176 2 76   2 5     1   8   149 121                       270 176 2 76   2 5     1   8   149 121                 270
710327 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001774 3194 COAL RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 203 0 65   1 3     0   5   155 122                       277 203 0 65   1 3     0   5   155 122                 277
710328 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001774 3194 COAL RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 156 4 59   1 2     0   4   119 107                       226 156 4 59   1 2     0   4   119 107                 226
710329 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001774 3194 COAL RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 535 6 200   4 10     1   17   423 350                       773 535 6 200   4 10     1   17   423 350                 773
710387 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000908 5286 SUNSET MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 88 1 70   0 4     1   1   77 88                       165 88 1 70   0 4     1   1   77 88                 165
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
710389 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000908 5286 SUNSET MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 96 1 79   2 8     1   4   107 84                       191 96 1 79   2 8     1   4   107 84                 191
710390 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000908 5286 SUNSET MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 288 2 230   2 13     2   10   281 266                       547 288 2 230   2 13     2   10   281 266                 547
710405 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_10 47 0 3   1 0     0   1   27 25                       52 47 0 3   1 0     0   1   27 25                 52
710406 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_11 64 0 4   1 5     1   4   32 47                       79 64 0 4   1 5     1   4   32 47                 79
710407 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_12 29 0 5   0 0     0   2   21 15                       36 29 0 5   0 0     0   2   21 15                 36
710408 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_6 59 0 5   0 0     0   0   33 31                       64 59 0 5   0 0     0   0   33 31                 64
710409 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 51 0 9   0 0     0   2   26 36                       62 51 0 9   0 0     0   2   26 36                 62
710410 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_8 60 0 7   0 0     0   3   40 30                       70 60 0 7   0 0     0   3   40 30                 70
710411 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_9 40 1 3   0 4     0   0   22 26                       48 40 1 3   0 4     0   0   22 26                 48
710412 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000912 5368 LYONS MIDDLE/SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   pk_12_total 350 1 36   2 9     1   12   201 210                       411 350 1 36   2 9     1   12   201 210                 411
710427 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000915 5730 MEAD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 132 0 15   0 0     0   2   70 79                       149 132 0 15   0 0     0   2   70 79                 149
710428 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000915 5730 MEAD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 131 1 29   1 2     0   2   93 73                       166 131 1 29   1 2     0   2   93 73                 166
710429 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000915 5730 MEAD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 145 1 29   1 4     0   0   87 93                       180 145 1 29   1 4     0   0   87 93                 180
710430 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000915 5730 MEAD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 408 2 73   2 6     0   4   250 245                       495 408 2 73   2 6     0   4   250 245                 495
710529 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001891 8903 TRAIL RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 103 1 118   4 5     0   3   123 111                       234 103 1 118   4 5     0   3   123 111                 234
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
710531 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001891 8903 TRAIL RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 90 2 144   2 8     0   2   133 115                       248 90 2 144   2 8     0   2   133 115                 248
710532 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001891 8903 TRAIL RIDGE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 279 3 390   9 19     1   7   359 349                       708 279 3 390   9 19     1   7   359 349                 708
710548 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006198 9430 WESTVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 190 2 47   1 6     0   8   136 118                       254 190 2 47   1 6     0   8   136 118                 254
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
710550 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006198 9430 WESTVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 175 3 57   2 9     0   6   120 132                       252 175 3 57   2 9     0   6   120 132                 252
710551 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006198 9430 WESTVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 545 9 157   3 21     0   21   406 350                       756 545 9 157   3 21     0   21   406 350                 756
710619 CO     school 802490 480   BOULDER VALLEY RE 2 80249000102 1066 BROOMFIELD HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 111 5 35   1 3     0   6   74 87                       161 111 5 35   1 3     0   6   74 87                 161
710620 CO     school 802490 480   BOULDER VALLEY RE 2 80249000102 1066 BROOMFIELD HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 121 1 50   1 5     1   4   91 92                       183 121 1 50   1 5     1   4   91 92                 183
710621 CO     school 802490 480   BOULDER VALLEY RE 2 80249000102 1066 BROOMFIELD HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 114 2 39   2 9     0   10   93 83                       176 114 2 39   2 9     0   10   93 83                 176
710622 CO     school 802490 480   BOULDER VALLEY RE 2 80249000102 1066 BROOMFIELD HEIGHTS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 346 8 124   4 17     1   20   258 262                       520 346 8 124   4 17     1   20   258 262                 520
710628 CO     school 802490 480   BOULDER VALLEY RE 2 80249000104 1136 MANHATTAN MIDDLE SCHOOL OF THE ARTS AND ACADEMICS   Regular School No Middle 06 08 2017   grade_6 98 2 18   1 8     0   20   63 84                       147 98 2 18   1 8     0   20   63 84                 147
710629 CO     school 802490 480   BOULDER VALLEY RE 2 80249000104 1136 MANHATTAN MIDDLE SCHOOL OF THE ARTS AND ACADEMICS   Regular School No Middle 06 08 2017   grade_7 96 2 31   1 6     0   8   71 73                       144 96 2 31   1 6     0   8   71 73                 144
710630 CO     school 802490 480   BOULDER VALLEY RE 2 80249000104 1136 MANHATTAN MIDDLE SCHOOL OF THE ARTS AND ACADEMICS   Regular School No Middle 06 08 2017   grade_8 108 3 36   2 6     0   12   91 76                       167 108 3 36   2 6     0   12   91 76                 167
710631 CO     school 802490 480   BOULDER VALLEY RE 2 80249000104 1136 MANHATTAN MIDDLE SCHOOL OF THE ARTS AND ACADEMICS   Regular School No Middle 06 08 2017   pk_12_total 302 7 85   4 20     0   40   225 233                       458 302 7 85   4 20     0   40   225 233                 458
710632 CO     school 802490 480   BOULDER VALLEY RE 2 80249000106 1352 CASEY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 102 1 97   0 4     0   6   101 109                       210 102 1 97   0 4     0   6   101 109                 210
710633 CO     school 802490 480   BOULDER VALLEY RE 2 80249000106 1352 CASEY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 121 3 85   2 6     0   9   120 106                       226 121 3 85   2 6     0   9   120 106                 226
710634 CO     school 802490 480   BOULDER VALLEY RE 2 80249000106 1352 CASEY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 122 2 82   0 3     0   7   94 122                       216 122 2 82   0 3     0   7   94 122                 216
710635 CO     school 802490 480   BOULDER VALLEY RE 2 80249000106 1352 CASEY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 345 6 264   2 13     0   22   315 337                       652 345 6 264   2 13     0   22   315 337                 652
710641 CO     school 802490 480   BOULDER VALLEY RE 2 80249000108 1390 CENTENNIAL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 133 1 48   1 6     0   17   109 97                       206 133 1 48   1 6     0   17   109 97                 206
710642 CO     school 802490 480   BOULDER VALLEY RE 2 80249000108 1390 CENTENNIAL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 148 0 48   2 9     0   4   107 104                       211 148 0 48   2 9     0   4   107 104                 211
710643 CO     school 802490 480   BOULDER VALLEY RE 2 80249000108 1390 CENTENNIAL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 136 2 41   0 15     0   17   107 104                       211 136 2 41   0 15     0   17   107 104                 211
710644 CO     school 802490 480   BOULDER VALLEY RE 2 80249000108 1390 CENTENNIAL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 417 3 137   3 30     0   38   323 305                       628 417 3 137   3 30     0   38   323 305                 628
710747 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No Other 06 12 2017   grade_10 2 0 2   0 0     0   0   4 0                       4 2 0 2   0 0     0   0   4 0                 4
710748 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No Other 06 12 2017   grade_11 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
710749 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No Other 06 12 2017   grade_12 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
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
710751 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No Other 06 12 2017   grade_8 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
710752 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No Other 06 12 2017   grade_9 5 0 0   0 0     0   0   3 2                       5 5 0 0   0 0     0   0   3 2                 5
710753 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No Other 06 12 2017   pk_12_total 12 0 4   0 0     0   1   14 3                       17 12 0 4   0 0     0   1   14 3                 17
710777 CO     school 802490 480   BOULDER VALLEY RE 2 80249002013 4496 JUSTICE HIGH CHARTER SCHOOL   Alternative School Yes Other 06 12 2017   grade_10 6 1 9   0 0     0   2   12 6                       18 6 1 9   0 0     0   2   12 6                 18
710778 CO     school 802490 480   BOULDER VALLEY RE 2 80249002013 4496 JUSTICE HIGH CHARTER SCHOOL   Alternative School Yes Other 06 12 2017   grade_11 4 1 14   0 0     0   1   16 4                       20 4 1 14   0 0     0   1   16 4                 20
710779 CO     school 802490 480   BOULDER VALLEY RE 2 80249002013 4496 JUSTICE HIGH CHARTER SCHOOL   Alternative School Yes Other 06 12 2017   grade_12 13 3 23   1 0     0   2   27 15                       42 13 3 23   1 0     0   2   27 15                 42
710780 CO     school 802490 480   BOULDER VALLEY RE 2 80249002013 4496 JUSTICE HIGH CHARTER SCHOOL   Alternative School Yes Other 06 12 2017   grade_6 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
710781 CO     school 802490 480   BOULDER VALLEY RE 2 80249002013 4496 JUSTICE HIGH CHARTER SCHOOL   Alternative School Yes Other 06 12 2017   grade_7 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
710782 CO     school 802490 480   BOULDER VALLEY RE 2 80249002013 4496 JUSTICE HIGH CHARTER SCHOOL   Alternative School Yes Other 06 12 2017   grade_8 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
710783 CO     school 802490 480   BOULDER VALLEY RE 2 80249002013 4496 JUSTICE HIGH CHARTER SCHOOL   Alternative School Yes Other 06 12 2017   grade_9 2 0 1   0 0     0   1   2 2                       4 2 0 1   0 0     0   1   2 2                 4
710784 CO     school 802490 480   BOULDER VALLEY RE 2 80249002013 4496 JUSTICE HIGH CHARTER SCHOOL   Alternative School Yes Other 06 12 2017   pk_12_total 27 5 49   1 0     0   6   59 29                       88 27 5 49   1 0     0   6   59 29                 88
710803 CO     school 802490 480   BOULDER VALLEY RE 2 80249000122 4878 ANGEVINE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 105 1 95   1 5     0   10   116 101                       217 105 1 95   1 5     0   10   116 101                 217
710804 CO     school 802490 480   BOULDER VALLEY RE 2 80249000122 4878 ANGEVINE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 118 5 92   1 8     0   10   133 101                       234 118 5 92   1 8     0   10   133 101                 234
710805 CO     school 802490 480   BOULDER VALLEY RE 2 80249000122 4878 ANGEVINE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 143 2 100   1 10     0   4   156 104                       260 143 2 100   1 10     0   4   156 104                 260
710806 CO     school 802490 480   BOULDER VALLEY RE 2 80249000122 4878 ANGEVINE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 366 8 287   3 23     0   24   405 306                       711 366 8 287   3 23     0   24   405 306                 711
710815 CO     school 802490 480   BOULDER VALLEY RE 2 80249000125 5306 LOUISVILLE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 184 1 24   0 2     0   10   110 111                       221 184 1 24   0 2     0   10   110 111                 221
710816 CO     school 802490 480   BOULDER VALLEY RE 2 80249000125 5306 LOUISVILLE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 170 2 28   1 6     0   8   107 108                       215 170 2 28   1 6     0   8   107 108                 215
710817 CO     school 802490 480   BOULDER VALLEY RE 2 80249000125 5306 LOUISVILLE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 162 3 23   0 4     0   15   111 96                       207 162 3 23   0 4     0   15   111 96                 207
710818 CO     school 802490 480   BOULDER VALLEY RE 2 80249000125 5306 LOUISVILLE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 516 6 75   1 12     0   33   328 315                       643 516 6 75   1 12     0   33   328 315                 643
710865 CO     school 802490 480   BOULDER VALLEY RE 2 80249000131 6212 NEDERLAND MIDDLE-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_10 38 1 3   0 0     0   2   24 20                       44 38 1 3   0 0     0   2   24 20                 44
710866 CO     school 802490 480   BOULDER VALLEY RE 2 80249000131 6212 NEDERLAND MIDDLE-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_11 28 0 3   0 0     0   0   13 18                       31 28 0 3   0 0     0   0   13 18                 31
710867 CO     school 802490 480   BOULDER VALLEY RE 2 80249000131 6212 NEDERLAND MIDDLE-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_12 42 0 2   1 0     0   4   32 17                       49 42 0 2   1 0     0   4   32 17                 49
710868 CO     school 802490 480   BOULDER VALLEY RE 2 80249000131 6212 NEDERLAND MIDDLE-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_6 38 1 3   0 2     0   3   22 25                       47 38 1 3   0 2     0   3   22 25                 47
710869 CO     school 802490 480   BOULDER VALLEY RE 2 80249000131 6212 NEDERLAND MIDDLE-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 37 1 1   0 3     0   1   17 26                       43 37 1 1   0 3     0   1   17 26                 43
710870 CO     school 802490 480   BOULDER VALLEY RE 2 80249000131 6212 NEDERLAND MIDDLE-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_8 42 0 2   0 0     0   2   21 25                       46 42 0 2   0 0     0   2   21 25                 46
710871 CO     school 802490 480   BOULDER VALLEY RE 2 80249000131 6212 NEDERLAND MIDDLE-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_9 26 0 1   0 2     0   1   14 16                       30 26 0 1   0 2     0   1   14 16                 30
710872 CO     school 802490 480   BOULDER VALLEY RE 2 80249000131 6212 NEDERLAND MIDDLE-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   pk_12_total 251 3 15   1 7     0   13   143 147                       290 251 3 15   1 7     0   13   143 147                 290
710873 CO     school 802490 480   BOULDER VALLEY RE 2 80249000132 6224 NEVIN PLATT MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 190 3 21   0 10     0   11   126 109                       235 190 3 21   0 10     0   11   126 109                 235
710874 CO     school 802490 480   BOULDER VALLEY RE 2 80249000132 6224 NEVIN PLATT MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 161 1 20   0 7     0   20   112 97                       209 161 1 20   0 7     0   20   112 97                 209
710875 CO     school 802490 480   BOULDER VALLEY RE 2 80249000132 6224 NEVIN PLATT MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 158 1 19   0 8     1   8   115 80                       195 158 1 19   0 8     1   8   115 80                 195
710876 CO     school 802490 480   BOULDER VALLEY RE 2 80249000132 6224 NEVIN PLATT MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 509 5 60   0 25     1   39   353 286                       639 509 5 60   0 25     1   39   353 286                 639
710927 CO     school 802490 480   BOULDER VALLEY RE 2 80249000134 8135 SOUTHERN HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 139 0 8   0 9     0   10   84 82                       166 139 0 8   0 9     0   10   84 82                 166
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
710929 CO     school 802490 480   BOULDER VALLEY RE 2 80249000134 8135 SOUTHERN HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 160 0 21   0 11     0   13   107 98                       205 160 0 21   0 11     0   13   107 98                 205
710930 CO     school 802490 480   BOULDER VALLEY RE 2 80249000134 8135 SOUTHERN HILLS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 444 2 39   2 36     0   36   295 264                       559 444 2 39   2 36     0   36   295 264                 559

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