Data source: Big Local News · About: Big Local

694 rows where grade = "grade_6", state = "CO" and year = 2021 sorted by district_state_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
1738289 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2021   grade_6 4 1 38   0 1     0   0   23 21                       44 4 1 38   0 1     0   0   23 21                 44
1738302 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2021   grade_6 5 1 75   0 3     0   1   38 47                       85 5 1 75   0 3     0   1   38 47                 85
1738313 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2021   grade_6 3 0 35   0 1     0   1   19 21                       40 3 0 35   0 1     0   1   19 21                 40
1738322 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   grade_6 9 0 43   0 1     0   2   32 23                       55 9 0 43   0 1     0   2   32 23                 55
1738332 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Pk-8   Regular School No Elementary PK 08 2021   grade_6 25 3 81   0 0     2   1   49 63                       112 25 3 81   0 0     2   1   49 63                 112
1738342 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2021   grade_6 8 1 40   0 0     0   1   22 28                       50 8 1 40   0 0     0   1   22 28                 50
1738351 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2021   grade_6 5 3 55   0 4     0   0   31 36                       67 5 3 55   0 4     0   0   31 36                 67
1738369 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_6 91 8 36   0 3     0   18   83 73                       156 91 8 36   0 3     0   18   83 73                 156
1738379 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2021   grade_6 2 2 54   1 0     0   2   34 27                       61 2 2 54   1 0     0   2   34 27                 61
1738396 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_6 7 0 44   1 0     0   0   26 26                       52 7 0 44   1 0     0   0   26 26                 52
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
1744432 CO     school 804080 1000   Fountain 8 80408000561 1332 Carson Middle School   Regular School No Middle 06 08 2021   grade_6 99 36 59   3 6     6   24   124 109                       233 99 36 59   3 6     6   24   124 109                 233
1744459 CO     school 804080 1000   Fountain 8 80408000563 3106 Fountain Middle School   Regular School No Middle 06 08 2021   grade_6 171 30 107   4 4     5   34   187 168                       355 171 30 107   4 4     5   34   187 168                 355
1744509 CO     school 803060 1010   Colorado Springs 11 80306006428 269 Achieve Online   Alternative School No High 06 12 2021   grade_6 6 2 5   0 0     0   0   7 6                       13 6 2 5   0 0     0   0   7 6                 13
1744527 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2021   grade_6 25 2 6   1 0     0   2   19 17                       36 25 2 6   1 0     0   2   19 17                 36
1744639 CO     school 803060 1010   Colorado Springs 11 80306006379 3360 Galileo School of Math and Science   Regular School No Middle 06 08 2021   grade_6 46 24 65   2 2     1   12   90 62                       152 46 24 65   2 2     1   12   90 62                 152
1744648 CO     school 803060 1010   Colorado Springs 11 80306001318 3470 Globe Charter School   Regular School Yes Elementary KG 06 2021   grade_6 9 1 1   0 1     0   2   8 6                       14 9 1 1   0 1     0   2   8 6                 14
1744674 CO     school 803060 1010   Colorado Springs 11 80306000241 4070 Holmes Middle School   Regular School No Middle 06 08 2021   grade_6 113 11 41   2 5     0   10   91 91                       182 113 11 41   2 5     0   10   91 91                 182
1744678 CO     school 803060 1010   Colorado Springs 11 80306000242 4090 Mann Middle School   Regular School No Middle 06 08 2021   grade_6 72 8 49   1 0     0   6   70 66                       136 72 8 49   1 0     0   6   70 66                 136
1744698 CO     school 803060 1010   Colorado Springs 11 80306001683 4424 Jenkins Middle School   Regular School No Middle 06 08 2021   grade_6 160 16 68   2 7     3   22   147 131                       278 160 16 68   2 7     3   22   147 131                 278
1744767 CO     school 803060 1010   Colorado Springs 11 80306000256 6306 North Middle School   Regular School No Middle 06 08 2021   grade_6 100 21 59   2 0     0   11   113 80                       193 100 21 59   2 0     0   11   113 80                 193
1744806 CO     school 803060 1010   Colorado Springs 11 80306000263 7523 Russell Middle School   Regular School No Middle 06 08 2021   grade_6 92 12 60   0 2     2   11   97 82                       179 92 12 60   0 2     2   11   97 82                 179
1744810 CO     school 803060 1010   Colorado Springs 11 80306000234 7556 Sabin Middle School   Regular School No Middle 06 08 2021   grade_6 81 11 87   2 3     0   15   101 98                       199 81 11 87   2 3     0   15   101 98                 199
1744837 CO     school 803060 1010   Colorado Springs 11 80306006421 8457 Jack Swigert Aerospace Academy   Regular School No Middle 06 08 2021   grade_6 39 19 96   1 2     1   13   96 75                       171 39 19 96   1 2     1   13   96 75                 171
1744857 CO     school 803060 1010   Colorado Springs 11 80306000272 9404 West Middle School   Regular School No Middle 06 08 2021   grade_6 48 5 26   0 1     0   3   30 53                       83 48 5 26   0 1     0   3   30 53                 83
1744890 CO     school 802940 1020   Cheyenne Mountain 12 80294001326 1582 The Vanguard School (Elementary)   Regular School Yes Elementary KG 06 2021   grade_6 76 6 35   0 9     1   11   69 69                       138 76 6 35   0 9     1   11   69 69                 138
1744899 CO     school 802940 1020   Cheyenne Mountain 12 80294001391 1586 Cheyenne Mountain Elementary School   Regular School No Elementary KG 06 2021   grade_6 37 2 8   0 1     0   2   24 26                       50 37 2 8   0 1     0   2   24 26                 50
1744915 CO     school 802940 1020   Cheyenne Mountain 12 80294000212 1592 Broadmoor Elementary School   Regular School No Elementary KG 06 2021   grade_6 41 1 5   0 1     1   3   30 22                       52 41 1 5   0 1     1   3   30 22                 52
1744925 CO     school 802940 1020   Cheyenne Mountain 12 80294000210 1604 Skyway Park Elementary School   Regular School No Elementary KG 06 2021   grade_6 32 0 11   0 1     0   8   28 24                       52 32 0 11   0 1     0   8   28 24                 52
1744933 CO     school 802940 1020   Cheyenne Mountain 12 80294001591 3482 Gold Camp Elementary School   Regular School No Elementary KG 06 2021   grade_6 62 1 10   0 0     0   5   43 35                       78 62 1 10   0 0     0   5   43 35                 78
1744941 CO     school 802940 1020   Cheyenne Mountain 12 80294001535 6953 Pinon Valley Elementary School   Regular School No Elementary KG 06 2021   grade_6 23 0 12   0 2     0   2   22 17                       39 23 0 12   0 2     0   2   22 17                 39
1744960 CO     school 805490 1030   Manitou Springs 14 80549000945 5464 Manitou Springs Middle School   Regular School No Middle 06 08 2021   grade_6 53 1 10   1 1     0   2   39 29                       68 53 1 10   1 1     0   2   39 29                 68
1744974 CO     school 805490 1030   Manitou Springs 14 80549000948 9010 Ute Pass Elementary School   Regular School No Elementary PK 06 2021   grade_6 37 2 2   0 0     0   0   18 23                       41 37 2 2   0 0     0   0   18 23                 41
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
1745251 CO     school 803750 1050   Ellicott 22 80375001735 2640 Ellicott Middle School   Regular School No Middle 06 08 2021   grade_6 37 6 32   0 0     0   2   44 33                       77 37 6 32   0 0     0   2   44 33                 77
1745276 CO     school 806060 1060   Peyton 23 Jt 80606001024 6898 Peyton Elementary School   Regular School No Elementary PK 06 2021   grade_6 36 2 4   0 0     0   4   24 22                       46 36 2 4   0 0     0   4   24 22                 46
1745291 CO     school 804500 1070   Hanover 28 80450000661 3758 Hanover Junior-Senior High School   Regular School No High 06 12 2021   grade_6 16 0 1   0 0     0   0   11 6                       17 16 0 1   0 0     0   0   11 6                 17
1745324 CO     school 805820 1080   Lewis-Palmer 38 80582001371 3539 Bear Creek Elementary School   Regular School No Elementary PK 06 2021   grade_6 100 1 16   2 1     0   12   75 57                       132 100 1 16   2 1     0   12   75 57                 132
1745334 CO     school 805820 1080   Lewis-Palmer 38 80582001489 4686 Ray E Kilmer Elementary School   Regular School No Elementary PK 06 2021   grade_6 48 0 7   0 0     0   4   35 24                       59 48 0 7   0 0     0   4   35 24                 59
1745339 CO     school 805820 1080   Lewis-Palmer 38 80582001536 5093 Monument Charter Academy Secondary School   Regular School Yes Middle 06 09 2021   grade_6 95 2 9   0 5     0   7   54 64                       118 95 2 9   0 5     0   7   54 64                 118
1745349 CO     school 805820 1080   Lewis-Palmer 38 80582001004 5096 Lewis-Palmer Elementary School   Regular School No Elementary PK 06 2021   grade_6 61 0 7   0 5     0   7   40 40                       80 61 0 7   0 5     0   7   40 40                 80
1745371 CO     school 805820 1080   Lewis-Palmer 38 80582001397 6682 Palmer Lake Elementary School   Regular School No Elementary PK 06 2021   grade_6 35 1 10   0 0     0   1   26 21                       47 35 1 10   0 0     0   1   26 21                 47
1745380 CO     school 805820 1080   Lewis-Palmer 38 80582001810 7165 Prairie Winds Elementary School   Regular School No Elementary PK 06 2021   grade_6 42 1 7   0 1     0   3   26 28                       54 42 1 7   0 1     0   3   26 28                 54
1739269 CO     school 806420 110   Sangre De Cristo Re-22J 80642001116 7630 Sangre de Cristo Undivided High School   Regular School No High 06 12 2021   grade_6 13 1 12   1 0     0   1   17 11                       28 13 1 12   1 0     0   1   17 11                 28
1745397 CO     school 803870 1110   District 49 80387006778 431 Falcon Homeschool Program   Regular School No Other KG 12 2021   grade_6 29 0 2   0 0     0   1   20 12                       32 29 0 2   0 0     0   1   20 12                 32
1745410 CO     school 803870 1110   District 49 80387006785 448 Rocky Mountain Classical Academy Homeschool   Regular School No Other KG 12 2021   grade_6 43 3 7   1 1     0   3   27 31                       58 43 3 7   1 1     0   3   27 31                 58
1745431 CO     school 803870 1110   District 49 80387002027 555 Banning Lewis Ranch Academy   Regular School Yes Other KG 12 2021   grade_6 71 3 44   0 1     1   22   69 73                       142 71 3 44   0 1     1   22   69 73                 142
1745459 CO     school 803870 1110   District 49 80387006462 2877 Springs Studio for Academic Excellence   Regular School No Other KG 12 2021   grade_6 26 0 5   0 3     0   5   17 22                       39 26 0 5   0 3     0   5   17 22                 39
1745471 CO     school 803870 1110   District 49 80387000506 2906 Falcon Middle School   Regular School No Middle 06 08 2021   grade_6 203 14 52   2 3     1   20   162 133                       295 203 14 52   2 3     1   20   162 133                 295
1745485 CO     school 803870 1110   District 49 80387001393 4102 Horizon Middle School   Regular School No Middle 06 08 2021   grade_6 101 24 93   1 7     1   29   133 123                       256 101 24 93   1 7     1   29   133 123                 256
1745494 CO     school 803870 1110   District 49 80387006386 4251 Grand Peak Academy   Regular School Yes Elementary KG 08 2021   grade_6 43 4 25   0 2     1   5   43 37                       80 43 4 25   0 2     1   5   43 37                 80
1745513 CO     school 803870 1110   District 49 80387006744 5191 Liberty Tree Academy   Regular School Yes Other KG 10 2021   grade_6 53 2 13   1 0     0   6   39 36                       75 53 2 13   1 0     0   6   39 36                 75
1745538 CO     school 803870 1110   District 49 80387006693 6653 Power Technical Early College   Career and Technical School Yes High 06 12 2021   grade_6 31 0 11   2 0     0   2   38 8                       46 31 0 11   2 0     0   2   38 8                 46
1745558 CO     school 803870 1110   District 49 80387001844 6935 Pikes Peak School Expeditionary Learning   Regular School Yes Elementary KG 08 2021   grade_6 37 3 6   0 2     0   3   31 20                       51 37 3 6   0 2     0   3   31 20                 51
1745584 CO     school 803870 1110   District 49 80387002000 7463 Rocky Mountain Classical Academy   Regular School Yes Elementary KG 08 2021   grade_6 64 3 32   1 0     1   10   52 59                       111 64 3 32   1 0     1   10   52 59                 111
1745594 CO     school 803870 1110   District 49 80387001799 7960 Skyview Middle School   Regular School No Middle 06 08 2021   grade_6 189 25 67   2 7     4   34   173 155                       328 189 25 67   2 7     4   34   173 155                 328
1745643 CO     school 803630 1120   Edison 54 JT 80363001278 2526 Edison Junior-Senior High School   Regular School No High 06 12 2021   grade_6 6 0 2   0 0     0   0   4 4                       8 6 0 2   0 0     0   0   4 4                 8
1745659 CO     school 805670 1130   Miami/Yoder 60 JT 80567000972 5854 Miami-Yoder Middle/High School   Regular School No High 06 12 2021   grade_6 15 0 6   0 1     0   0   11 11                       22 15 0 6   0 1     0   0   11 11                 22
1745664 CO     school 802790 1140   Canon City RE-1 80279000171 1262 Canon City Middle School   Regular School No Middle 06 08 2021   grade_6 93 0 17   1 0     0   6   57 60                       117 93 0 17   1 0     0   6   57 60                 117
1745678 CO     school 802790 1140   Canon City RE-1 80279000173 3802 Harrison School   Regular School No Elementary KG 08 2021   grade_6 69 0 24   1 0     1   7   49 53                       102 69 0 24   1 0     1   7   49 53                 102
1745703 CO     school 802790 1140   Canon City RE-1 80279001538 6752 Mount View Core Knowledge Charter School   Regular School Yes Elementary PK 08 2021   grade_6 23 0 5   0 0     0   1   14 15                       29 23 0 5   0 0     0   1   14 15                 29
1745713 CO     school 802790 1140   Canon City RE-1 80279001433 7950 Canon Exploratory School   Regular School No Elementary KG 08 2021   grade_6 17 0 6   0 1     0   2   13 13                       26 17 0 6   0 1     0   2   13 13                 26
1745737 CO     school 803960 1150   Fremont RE-2 80396000515 3224 Fremont Elementary School   Regular School No Elementary PK 06 2021   grade_6 41 1 15   0 0     0   6   24 39                       63 41 1 15   0 0     0   6   24 39                 63
1745746 CO     school 803960 1150   Fremont RE-2 80396000516 6858 Penrose Elementary School   Regular School No Elementary PK 06 2021   grade_6 27 0 4   0 0     0   0   16 15                       31 27 0 4   0 0     0   0   16 15                 31
1745761 CO     school 803120 1160   Cotopaxi RE-3 80312000277 3228 Cotopaxi Junior-Senior High School   Regular School No High 06 12 2021   grade_6 10 0 1   0 0     0   0   4 7                       11 10 0 1   0 0     0   0   4 7                 11
1745771 CO     school 804260 1180   Roaring Fork RE-1 80426001505 429 Carbondale Community Charter School   Regular School Yes Elementary KG 08 2021   grade_6 11 0 5   0 0     0   0   5 11                       16 11 0 5   0 0     0   0   5 11                 16
1745784 CO     school 804260 1180   Roaring Fork RE-1 80426000133 561 Basalt Middle School   Regular School No Middle 05 08 2021   grade_6 38 0 60   0 0     0   0   48 50                       98 38 0 60   0 0     0   0   48 50                 98
1745799 CO     school 804260 1180   Roaring Fork RE-1 80426000586 1296 Carbondale Middle School   Regular School No Middle 05 08 2021   grade_6 37 2 45   0 0     0   2   45 41                       86 37 2 45   0 0     0   2   45 41                 86
1745820 CO     school 804260 1180   Roaring Fork RE-1 80426000587 3464 Glenwood Springs Middle School   Regular School No Middle 06 08 2021   grade_6 61 0 97   0 0     0   2   76 84                       160 61 0 97   0 0     0   2   76 84                 160
1745834 CO     school 804260 1180   Roaring Fork RE-1 80426006715 7298 Riverview School   Regular School No Elementary PK 08 2021   grade_6 10 1 23   0 0     0   1   19 16                       35 10 1 23   0 0     0   1   19 16                 35
1745891 CO     school 806240 1195   Garfield Re-2 80624001096 7356 Rifle Middle School   Regular School No Middle 06 08 2021   grade_6 84 0 107   0 0     0   2   94 99                       193 84 0 107   0 0     0   2   94 99                 193
1745900 CO     school 806240 1195   Garfield Re-2 80624001098 7388 Riverside School   Regular School No Middle 06 08 2021   grade_6 84 1 79   0 1     0   2   91 76                       167 84 1 79   0 1     0   2   91 76                 167
1739284 CO     school 803780 120   Englewood 1 80378000486 1514 Charles Hay World School   Regular School No Elementary KG 06 2021   grade_6 21 0 10   0 0     0   0   19 12                       31 21 0 10   0 0     0   0   19 12                 31
1739292 CO     school 803780 120   Englewood 1 80378000488 1556 Cherrelyn Elementary School   Regular School No Elementary KG 06 2021   grade_6 17 2 8   0 0     0   1   12 16                       28 17 2 8   0 0     0   1   12 16                 28
1739300 CO     school 803780 120   Englewood 1 80378000489 1652 Clayton Elementary School   Regular School No Elementary KG 06 2021   grade_6 18 1 27   0 1     0   1   23 25                       48 18 1 27   0 1     0   1   23 25                 48
1739308 CO     school 803780 120   Englewood 1 80378001772 2750 Englewood Leadership Academy   Regular School No Middle 06 09 2021   grade_6 16 0 6   0 1     0   1   10 14                       24 16 0 6   0 1     0   1   10 14                 24
1739322 CO     school 803780 120   Englewood 1 80378000497 9620 Wm E Bishop Elementary School   Regular School No Elementary KG 06 2021   grade_6 5 1 16   0 1     0   3   16 10                       26 5 1 16   0 1     0   3   16 10                 26
1745934 CO     school 804380 1220   Garfield 16 80438001368 8274 Grand Valley Middle School   Regular School No Middle 06 08 2021   grade_6 43 0 27   0 0     0   1   36 35                       71 43 0 27   0 0     0   1   36 35                 71
1739332 CO     school 806540 123   Sheridan 2 80654001135 7837 Fort Logan Northgate   Regular School No Middle 03 08 2021   grade_6 15 5 73   0 3     0   3   47 52                       99 15 5 73   0 3     0   3   47 52                 99
1739356 CO     school 802910 130   Cherry Creek 5 80291001711 18 Liberty Middle School   Regular School No Middle 06 08 2021   grade_6 185 30 55   1 33     1   19   159 165                       324 185 30 55   1 33     1   19   159 165                 324
1739368 CO     school 802910 130   Cherry Creek 5 80291001878 141 Sky Vista Middle School   Regular School No Middle 06 08 2021   grade_6 131 29 52   0 26     1   37   146 130                       276 131 29 52   0 26     1   37   146 130                 276
1739372 CO     school 802910 130   Cherry Creek 5 80291006770 188 Colorado Skies Academy   Regular School Yes Middle 06 08 2021   grade_6 59 3 20   0 1     0   6   60 29                       89 59 3 20   0 1     0   6   60 29                 89
1739430 CO     school 802910 130   Cherry Creek 5 80291006791 1429 Cherry Creek Elevation   Regular School No High 06 12 2021   grade_6 1 0 0   0 1     0   0   1 1                       2 1 0 0   0 1     0   0   1 1                 2
1739440 CO     school 802910 130   Cherry Creek 5 80291000763 1510 Challenge School   Regular School No Elementary PK 08 2021   grade_6 32 13 12   0 18     0   5   40 40                       80 32 13 12   0 18     0   5   40 40                 80
1739450 CO     school 802910 130   Cherry Creek 5 80291000185 1566 Campus Middle School   Regular School No Middle 06 08 2021   grade_6 256 20 65   2 63     1   37   230 214                       444 256 20 65   2 63     1   37   230 214                 444
1739454 CO     school 802910 130   Cherry Creek 5 80291000207 1568 West Middle School   Regular School No Middle 06 08 2021   grade_6 264 6 45   3 30     0   25   209 164                       373 264 6 45   3 30     0   25   209 164                 373
1739468 CO     school 802910 130   Cherry Creek 5 80291001152 1571 Cherry Creek Charter Academy   Regular School Yes Elementary KG 08 2021   grade_6 37 7 9   0 23     0   2   34 44                       78 37 7 9   0 23     0   2   34 44                 78
1739541 CO     school 802910 130   Cherry Creek 5 80291001672 2897 Falcon Creek Middle School   Regular School No Middle 06 08 2021   grade_6 119 21 57   3 13     1   20   114 120                       234 119 21 57   3 13     1   20   114 120                 234
1739545 CO     school 802910 130   Cherry Creek 5 80291006367 3030 Fox Ridge Middle School   Regular School No Middle 06 08 2021   grade_6 229 29 53   1 30     1   26   187 182                       369 229 29 53   1 30     1   26   187 182                 369
1739589 CO     school 802910 130   Cherry Creek 5 80291001328 4100 Horizon Middle School   Regular School No Middle 06 08 2021   grade_6 113 54 111   2 12     1   27   154 166                       320 113 54 111   2 12     1   27   154 166                 320

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