Data source: Big Local News · About: Big Local

694 rows where grade = "grade_6", state = "CO" and year = 2021 sorted by district_nces_id

View and edit SQL

year

  • 2021 · 694

grade

  • grade_6 · 694
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
1741539 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2021   grade_6 12 0 1   0 0     0   0   7 6                       13 12 0 1   0 0     0   0   7 6                 13
1751494 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2021   grade_6 40 4 4   0 1     0   3   29 23                       52 40 4 4   0 1     0   3   29 23                 52
1751018 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2021   grade_6 29 0 32   0 0     0   0   32 29                       61 29 0 32   0 0     0   0   32 29                 61
1751038 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 06 2021   grade_6 34 0 19   0 0     0   1   24 30                       54 34 0 19   0 0     0   1   24 30                 54
1751054 CO     school 800018 3220   Idalia RJ-3 80001801741 4227 Idalia Elementary School   Regular School No Elementary PK 06 2021   grade_6 12 0 5   0 0     0   0   6 11                       17 12 0 5   0 0     0   0   6 11                 17
1751073 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2021   grade_6 8 0 1   0 0     0   0   6 3                       9 8 0 1   0 0     0   0   6 3                 9
1751088 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_6 77 2 40   0 12     0   11   81 61                       142 77 2 40   0 12     0   11   81 61                 142
1751108 CO     school 800020 8001   Charter School Institute 80002006760 79 Ascent Classical Academy   Regular School Yes Other KG 12 2021   grade_6 51 0 3   2 2     0   1   31 28                       59 51 0 3   2 2     0   1   31 28                 59
1751114 CO     school 800020 8001   Charter School Institute 80002006777 149 Colorado Early Colleges Fort Collins West   Regular School Yes Middle 06 08 2021   grade_6 120 0 18   1 6     1   4   83 67                       150 120 0 18   1 6     1   4   83 67                 150
1751123 CO     school 800020 8001   Charter School Institute 80002006768 493 Axis International Academy   Regular School Yes Elementary PK 08 2021   grade_6 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
1751131 CO     school 800020 8001   Charter School Institute 80002002018 653 Stone Creek School   Regular School Yes Elementary KG 08 2021   grade_6 30 0 15   0 1     0   2   22 26                       48 30 0 15   0 1     0   2   22 26                 48
1751141 CO     school 800020 8001   Charter School Institute 80002002033 655 High Point Academy   Regular School Yes Elementary PK 08 2021   grade_6 8 27 33   1 3     0   0   43 29                       72 8 27 33   1 3     0   0   43 29                 72
1751159 CO     school 800020 8001   Charter School Institute 80002006796 1005 Ascent Classical Academy Northern Colorado   Regular School Yes Elementary KG 06 2021   grade_6 17 1 0   0 0     0   1   8 11                       19 17 1 0   0 0     0   1   8 11                 19
1751170 CO     school 800020 8001   Charter School Institute 80002006305 1279 Caprock Academy   Regular School Yes Other KG 12 2021   grade_6 67 1 5   0 2     0   5   41 39                       80 67 1 5   0 2     0   5   41 39                 80
1751182 CO     school 800020 8001   Charter School Institute 80002006784 1371 Coperni 3   Regular School Yes Elementary KG 07 2021   grade_6 18 4 10   0 0     1   1   23 11                       34 18 4 10   0 0     1   1   23 11                 34
1751194 CO     school 800020 8001   Charter School Institute 80002006779 1387 Colorado Early Colleges Windsor   Regular School Yes Other KG 12 2021   grade_6 38 0 6   0 0     0   5   26 23                       49 38 0 6   0 0     0   5   26 23                 49
1751207 CO     school 800020 8001   Charter School Institute 80002006708 1505 Colorado Military Academy   Regular School Yes Other KG 11 2021   grade_6 47 4 22   3 2     0   6   54 30                       84 47 4 22   3 2     0   6   54 30                 84
1751223 CO     school 800020 8001   Charter School Institute 80002001912 1791 Colorado Springs Charter Academy   Regular School Yes Elementary KG 08 2021   grade_6 24 1 13   0 0     0   6   20 24                       44 24 1 13   0 0     0   6   20 24                 44
1751245 CO     school 800020 8001   Charter School Institute 80002001569 2035 Crown Pointe Charter Academy   Regular School Yes Elementary KG 08 2021   grade_6 14 0 32   0 4     0   1   28 23                       51 14 0 32   0 4     0   1   28 23                 51
1751253 CO     school 800020 8001   Charter School Institute 80002006542 2067 Colorado Early College Fort Collins   Regular School Yes High 06 12 2021   grade_6 34 2 13   0 1     0   3   26 27                       53 34 2 13   0 1     0   3   26 27                 53
1751266 CO     school 800020 8001   Charter School Institute 80002006390 2837 Early College of Arvada   Regular School Yes High 06 12 2021   grade_6 6 0 5   0 0     1   0   6 6                       12 6 0 5   0 0     1   0   6 6                 12
1751276 CO     school 800020 8001   Charter School Institute 80002006586 3326 Colorado International Language Academy   Regular School Yes Elementary KG 06 2021   grade_6 4 0 0   0 0     0   0   3 1                       4 4 0 0   0 0     0   0   3 1                 4
1751287 CO     school 800020 8001   Charter School Institute 80002006639 3393 Golden View Classical Academy   Regular School Yes Other KG 12 2021   grade_6 51 1 5   0 2     0   3   28 34                       62 51 1 5   0 2     0   3   28 34                 62
1751299 CO     school 800020 8001   Charter School Institute 80002006503 3439 Global Village Academy - Northglenn   Regular School Yes Elementary KG 08 2021   grade_6 29 1 48   0 0     2   0   33 47                       80 29 1 48   0 0     2   0   33 47                 80
1751331 CO     school 800020 8001   Charter School Institute 80002006761 5431 Coperni 2   Regular School Yes Elementary KG 08 2021   grade_6 9 1 6   0 0     0   0   9 7                       16 9 1 6   0 0     0   0   9 7                 16
1751338 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2021   grade_6 49 0 14   1 1     0   2   34 33                       67 49 0 14   1 1     0   2   34 33                 67
1751354 CO     school 800020 8001   Charter School Institute 80002006589 5851 Mountain Song Community School   Regular School Yes Elementary KG 08 2021   grade_6 16 1 15   0 0     0   2   19 15                       34 16 1 15   0 0     0   2   19 15                 34
1751365 CO     school 800020 8001   Charter School Institute 80002006602 5957 Montessori del Mundo Charter School   Regular School Yes Elementary PK 06 2021   grade_6 1 0 16   0 0     0   0   8 9                       17 1 0 16   0 0     0   0   8 9                 17
1751387 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2021   grade_6 20 2 156   1 9     0   1   108 81                       189 20 2 156   1 9     0   1   108 81                 189
1751398 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2021   grade_6 2 0 28   0 0     0   0   18 12                       30 2 0 28   0 0     0   0   18 12                 30
1751408 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2021   grade_6 19 0 9   0 0     0   2   13 17                       30 19 0 9   0 0     0   2   13 17                 30
1751418 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2021   grade_6 7 0 0   0 0     0   0   2 5                       7 7 0 0   0 0     0   0   2 5                 7
1751428 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2021   grade_6 31 1 15   0 1     0   1   26 23                       49 31 1 15   0 1     0   1   26 23                 49
1751442 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2021   grade_6 66 0 19   1 2     0   9   50 47                       97 66 0 19   1 2     0   9   50 47                 97
1751454 CO     school 800020 8001   Charter School Institute 80002006579 9040 Victory Preparatory Academy Middle State Charter School   Regular School Yes Middle 06 08 2021   grade_6 2 1 61   0 0     0   0   31 33                       64 2 1 61   0 0     0   0   31 33                 64
1751466 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_6 4 1 3   0 2     0   1   7 4                       11 4 1 3   0 2     0   1   7 4                 11
1751507 CO     school 800282 9170   Education reEnvisioned BOCES 80028206764 1501 Colorado Preparatory Academy Middle School   Regular School No Middle 06 08 2021   grade_6 207 26 111   0 0     1   26   192 179                       371 207 26 111   0 0     1   26   192 179                 371
1751522 CO     school 800282 9170   Education reEnvisioned BOCES 80028206804 1892 Orton Academy   Regular School No Other KG 12 2021   grade_6 25 6 4   0 1     0   0   22 14                       36 25 6 4   0 1     0   0   22 14                 36
1744992 CO     school 801920 1040   Academy 20 80192000001 74 Challenger Middle School   Regular School No Middle 06 08 2021   grade_6 127 6 18   1 16     3   19   113 77                       190 127 6 18   1 16     3   19   113 77                 190
1745023 CO     school 801920 1040   Academy 20 80192006788 1421 Chinook Trail Middle School   Regular School No Middle 06 08 2021   grade_6 217 14 45   0 18     2   26   157 165                       322 217 14 45   0 18     2   26   157 165                 322
1745035 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2021   grade_6 42 0 6   1 1     0   2   26 26                       52 42 0 6   1 1     0   2   26 26                 52
1745053 CO     school 801920 1040   Academy 20 80192001592 1627 The Classical Academy Charter   Regular School Yes Elementary KG 06 2021   grade_6 218 5 23   1 7     0   14   132 136                       268 218 5 23   1 7     0   14   132 136                 268
1745069 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2021   grade_6 14 1 2   0 1     0   1   7 12                       19 14 1 2   0 1     0   1   7 12                 19
1745074 CO     school 801920 1040   Academy 20 80192006616 1921 Discovery Canyon Campus Middle School   Regular School No Middle 06 08 2021   grade_6 157 10 26   1 17     0   20   124 107                       231 157 10 26   1 17     0   20   124 107                 231
1745098 CO     school 801920 1040   Academy 20 80192001402 2358 Eagleview Middle School   Regular School No Middle 06 08 2021   grade_6 226 5 45   0 7     0   20   162 141                       303 226 5 45   0 7     0   20   162 141                 303
1745146 CO     school 801920 1040   Academy 20 80192001593 6140 Mountain Ridge Middle School   Regular School No Middle 06 08 2021   grade_6 140 12 54   0 13     1   25   115 130                       245 140 12 54   0 13     1   25   115 130                 245
1745163 CO     school 801920 1040   Academy 20 80192006745 6242 New Summit Charter Academy   Regular School Yes Elementary KG 08 2021   grade_6 41 4 5   0 1     1   2   29 25                       54 41 4 5   0 1     1   2   29 25                 54
1745231 CO     school 801920 1040   Academy 20 80192001462 8851 Timberview Middle School   Regular School No Middle 06 08 2021   grade_6 156 9 54   0 5     1   29   131 123                       254 156 9 54   0 5     1   29   131 123                 254
1738786 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2021   grade_6 17 6 194   2 0     1   2   123 99                       222 17 6 194   2 0     1   2   123 99                 222
1738823 CO     school 801950 30   Adams County 14 80195000015 4516 Kearney Middle School   Regular School No Middle 06 08 2021   grade_6 22 5 194   4 0     0   2   110 117                       227 22 5 194   4 0     0   2   110 117                 227
1744127 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2021   grade_6 2 0 1   0 0     0   0   1 2                       3 2 0 1   0 0     0   0   1 2                 3
1748271 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2021   grade_6 1 0 2   0 0     0   0   2 1                       3 1 0 2   0 0     0   0   2 1                 3
1750358 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2021   grade_6 23 0 9   0 1     0   1   17 17                       34 23 0 9   0 1     0   1   17 17                 34
1739227 CO     school 802070 100   Alamosa RE-11J 80207000026 114 Ortega Middle School   Regular School No Middle 06 08 2021   grade_6 43 0 99   0 1     0   3   75 71                       146 43 0 99   0 1     0   3   75 71                 146
1739248 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_6 10 0 34   0 1     0   0   16 29                       45 10 0 34   0 1     0   0   16 29                 45
1741639 CO     school 802130 580   South Conejos RE-10 80213000033 248 Guadalupe Elementary School   Regular School No Elementary PK 06 2021   grade_6 0 0 9   0 0     0   0   6 3                       9 0 0 9   0 0     0   0   6 3                 9
1740536 CO     school 802190 220   Archuleta County 50 Jt 80219000040 6657 Pagosa Springs Middle School   Regular School No Middle 05 08 2021   grade_6 48 0 53   13 0     0   4   62 56                       118 48 0 53   13 0     0   4   62 56                 118
1740550 CO     school 802190 220   Archuleta County 50 Jt 80219006717 6679 Pagosa Peak Open School   Regular School Yes Elementary KG 07 2021   grade_6 5 0 2   0 0     0   0   2 5                       7 5 0 2   0 0     0   0   2 5                 7
1750380 CO     school 802220 3040   Arickaree R-2 80222000042 308 Arickaree Undivided High School   Regular School No High 06 12 2021   grade_6 2 0 6   0 0     0   0   6 2                       8 2 0 6   0 0     0   0   6 2                 8
1747348 CO     school 802260 1450   Arriba-Flagler C-20 80226000509 2960 Flagler Public School   Regular School No Other PK 12 2021   grade_6 8 0 0   0 0     0   0   3 5                       8 8 0 0   0 0     0   0   3 5                 8
1749402 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2021   grade_6 13 0 1   0 0     0   1   8 7                       15 13 0 1   0 0     0   1   8 7                 15
1749414 CO     school 802280 2640   Aspen 1 80228000046 430 Aspen Middle School   Regular School No Middle 05 08 2021   grade_6 104 0 17   0 2     1   1   68 57                       125 104 0 17   0 2     1   1   68 57                 125
1750959 CO     school 802310 3145   Ault-Highland RE-9 80231001466 3961 Highland Middle School   Regular School No Middle 06 08 2021   grade_6 50 0 22   1 0     0   1   36 38                       74 50 0 22   1 0     0   1   36 38                 74
1739983 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2021   grade_6 6 25 90   0 1     0   11   70 63                       133 6 25 90   0 1     0   11   70 63                 133
1739988 CO     school 802340 180   Adams-Arapahoe 28J 80234006787 127 Aurora Science & Tech Middle School   Regular School Yes Middle 06 07 2021   grade_6 20 25 104   0 2     0   13   90 74                       164 20 25 104   0 2     0   13   90 74                 164
1739998 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2021   grade_6 14 13 13   1 0     0   1   21 21                       42 14 13 13   1 0     0   1   21 21                 42
1740025 CO     school 802340 180   Adams-Arapahoe 28J 80234001759 458 Aurora Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_6 12 19 30   0 0     0   1   31 31                       62 12 19 30   0 0     0   1   31 31                 62
1740030 CO     school 802340 180   Adams-Arapahoe 28J 80234000054 464 Aurora Hills Middle School   Regular School No Middle 06 08 2021   grade_6 18 46 144   0 9     4   7   126 102                       228 18 46 144   0 9     4   7   126 102                 228
1740039 CO     school 802340 180   Adams-Arapahoe 28J 80234002009 465 Aurora Frontier K-8   Regular School No Elementary PK 08 2021   grade_6 32 10 23   1 15     0   4   47 38                       85 32 10 23   1 15     0   4   47 38                 85
1740050 CO     school 802340 180   Adams-Arapahoe 28J 80234000055 914 Boston K-8 School   Regular School No Elementary PK 08 2021   grade_6 4 3 32   1 1     0   1   16 26                       42 4 3 32   1 1     0   1   16 26                 42
1740074 CO     school 802340 180   Adams-Arapahoe 28J 80234000057 1720 Clyde Miller K-8   Regular School No Elementary PK 08 2021   grade_6 3 6 51   0 0     0   6   34 32                       66 3 6 51   0 0     0   6   34 32                 66
1740080 CO     school 802340 180   Adams-Arapahoe 28J 80234001322 1800 Columbia Middle School   Regular School No Middle 06 08 2021   grade_6 60 42 111   1 7     1   24   131 115                       246 60 42 111   1 7     1   24   131 115                 246
1740089 CO     school 802340 180   Adams-Arapahoe 28J 80234006803 1851 Harmony Ridge P-8   Regular School No Elementary PK 08 2021   grade_6 9 6 43   0 0     0   1   32 27                       59 9 6 43   0 0     0   1   32 27                 59
1740119 CO     school 802340 180   Adams-Arapahoe 28J 80234000060 2384 East Middle School   Regular School No Middle 06 08 2021   grade_6 15 33 221   3 5     1   13   160 131                       291 15 33 221   3 5     1   13   160 131                 291
1740139 CO     school 802340 180   Adams-Arapahoe 28J 80234006644 2673 Edna and John W. Mosley P-8   Regular School No Elementary PK 08 2021   grade_6 12 15 69   0 3     1   4   58 46                       104 12 15 69   0 3     1   4   58 46                 104
1740165 CO     school 802340 180   Adams-Arapahoe 28J 80234006318 3471 Global Village Academy Aurora   Regular School Yes Elementary KG 08 2021   grade_6 3 24 59   0 1     2   7   53 43                       96 3 24 59   0 1     2   7   53 43                 96
1740225 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2021   grade_6 9 38 45   0 0     0   1   50 43                       93 9 38 45   0 0     0   1   50 43                 93
1740249 CO     school 802340 180   Adams-Arapahoe 28J 80234000073 6160 Mrachek Middle School   Regular School No Middle 06 08 2021   grade_6 46 61 162   0 16     6   18   177 132                       309 46 61 162   0 16     6   18   177 132                 309
1740258 CO     school 802340 180   Adams-Arapahoe 28J 80234001881 6189 Murphy Creek K-8 School   Regular School No Elementary PK 08 2021   grade_6 31 9 21   0 2     0   5   35 33                       68 31 9 21   0 2     0   5   35 33                 68
1740264 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_6 8 31 128   0 9     2   4   89 93                       182 8 31 128   0 9     2   4   89 93                 182
1740276 CO     school 802340 180   Adams-Arapahoe 28J 80234001789 6546 Options School   Regular School No Other KG 12 2021   grade_6 60 3 19   0 1     0   6   43 46                       89 60 3 19   0 1     0   6   43 46                 89
1740311 CO     school 802340 180   Adams-Arapahoe 28J 80234001674 7232 Aurora Quest K-8   Regular School No Elementary KG 08 2021   grade_6 42 13 20   0 11     1   4   37 54                       91 42 13 20   0 11     1   4   37 54                 91
1740353 CO     school 802340 180   Adams-Arapahoe 28J 80234000079 8078 South Middle School   Regular School No Middle 06 08 2021   grade_6 18 43 175   0 3     2   10   127 124                       251 18 43 175   0 3     2   10   127 124                 251
1740373 CO     school 802340 180   Adams-Arapahoe 28J 80234006732 9053 Vega Collegiate Academy   Regular School Yes Elementary KG 08 2021   grade_6 0 5 27   0 5     1   0   20 18                       38 0 5 27   0 5     1   0   20 18                 38
1740383 CO     school 802340 180   Adams-Arapahoe 28J 80234006322 9056 Vanguard Classical School - West   Regular School Yes Elementary KG 08 2021   grade_6 2 6 24   0 0     0   1   11 22                       33 2 6 24   0 0     0   1   11 22                 33
1740409 CO     school 802340 180   Adams-Arapahoe 28J 80234006483 9083 Vista Peak P-8 Exploratory   Regular School No Elementary PK 08 2021   grade_6 33 8 34   0 5     0   13   51 42                       93 33 8 34   0 5     0   13   51 42                 93
1740436 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2021   grade_6 11 34 36   0 2     0   3   39 47                       86 11 34 36   0 2     0   3   39 47                 86
1740445 CO     school 802340 180   Adams-Arapahoe 28J 80234000082 9396 Aurora West College Preparatory Academy   Regular School No High 06 12 2021   grade_6 8 31 157   0 18     1   7   111 111                       222 8 31 157   0 18     1   7   111 111                 222
1749319 CO     school 802370 2600   Platte Canyon 1 80237001325 7048 Fitzsimmons Middle School   Regular School No Middle 06 08 2021   grade_6 50 0 7   0 0     0   3   37 23                       60 50 0 7   0 0     0   3   37 23                 60
1747551 CO     school 802400 1530   Bayfield 10 Jt-R 80240000089 636 Bayfield Middle School   Regular School No Middle 06 08 2021   grade_6 89 1 16   2 0     0   5   61 52                       113 89 1 16   2 0     0   5   61 52                 113
1739044 CO     school 802430 50   Bennett 29J 80243006789 562 Bennett Intermediate School   Regular School No Middle 04 06 2021   grade_6 51 3 33   0 0     0   9   56 40                       96 51 3 33   0 0     0   9   56 40                 96
1747395 CO     school 802460 1490   Bethune R-5 80246000095 842 Bethune Public Schools   Regular School No Other PK 12 2021   grade_6 3 1 4   0 0     0   0   6 2                       8 3 1 4   0 0     0   0   6 2                 8
1741083 CO     school 802490 480   Boulder Valley Re 2 80249001758 441 Aspen Creek K-8 School   Regular School No Elementary PK 08 2021   grade_6 82 2 17   0 11     0   6   59 59                       118 82 2 17   0 11     0   6   59 59                 118
1741124 CO     school 802490 480   Boulder Valley Re 2 80249006463 930 Boulder Universal   Regular School No Other KG 12 2021   grade_6 57 2 11   0 5     0   4   48 31                       79 57 2 11   0 5     0   4   48 31                 79
1741135 CO     school 802490 480   Boulder Valley Re 2 80249000102 1066 Broomfield Heights Middle School   Regular School No Middle 06 08 2021   grade_6 108 2 47   1 4     1   8   96 75                       171 108 2 47   1 4     1   8   96 75                 171
1741144 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_6 72 2 33   1 3     0   9   59 61                       120 72 2 33   1 3     0   9   59 61                 120
1741148 CO     school 802490 480   Boulder Valley Re 2 80249000106 1352 Casey Middle School   Regular School No Middle 06 08 2021   grade_6 82 0 69   1 1     1   6   77 83                       160 82 0 69   1 1     1   6   77 83                 160
1741157 CO     school 802490 480   Boulder Valley Re 2 80249000108 1390 Centennial Middle School   Regular School No Middle 06 08 2021   grade_6 105 0 51   0 3     0   9   90 78                       168 105 0 51   0 3     0   9   90 78                 168
1741211 CO     school 802490 480   Boulder Valley Re 2 80249001771 2589 Eldorado K-8 School   Regular School No Elementary PK 08 2021   grade_6 92 1 9   1 6     0   11   61 59                       120 92 1 9   1 6     0   11   61 59                 120
1741222 CO     school 802490 480   Boulder Valley Re 2 80249006716 2639 Meadowlark School   Regular School No Elementary PK 08 2021   grade_6 51 0 8   0 3     0   4   37 29                       66 51 0 8   0 3     0   4   37 29                 66

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