Data source: Big Local News · About: Big Local

4,236 rows where grade = "grade_7" and state = "CO" sorted by ccd_charter_school descending

View and edit SQL

year

grade

  • grade_7 · 4,236
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
708025 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690000728 1519 STARGATE CHARTER SCHOOL   Regular School Yes Other KG 10 2017   grade_7 79 2 8   0 26     0   7   67 55                       122 79 2 8   0 26     0   7   67 55                 122
708233 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006507 6802 PROSPECT RIDGE ACADEMY   Regular School Yes Other KG 11 2017   grade_7 92 0 13   0 6     0   1   43 69                       112 92 0 13   0 6     0   1   43 69                 112
708324 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006417 9431 WESTGATE CHARTER   Regular School Yes Other KG 12 2017   grade_7 31 0 7   0 2     0   1   22 19                       41 31 0 7   0 2     0   1   22 19                 41
708432 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001948 700 BELLE CREEK CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 24 3 30   0 4     0   2   32 31                       63 24 3 30   0 4     0   2   32 31                 63
708462 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001729 1052 BROMLEY EAST CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_7 78 0 57   0 0     1   4   56 84                       140 78 0 57   0 0     1   4   56 84                 140
708483 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006465 2945 FOUNDATIONS ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 52 1 17   0 1     0   3   32 42                       74 52 1 17   0 1     0   3   32 42                 74
708506 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006325 4950 LANDMARK ACADEMY AT REUNION   Regular School Yes Elementary KG 08 2017   grade_7 42 2 21   0 2     0   4   48 23                       71 42 2 21   0 2     0   4   48 23                 71
708991 CO     school 802910 130   CHERRY CREEK 5 80291001152 1571 CHERRY CREEK CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 33 3 3   0 12     0   2   24 29                       53 33 3 3   0 12     0   2   24 29                 53
709391 CO     school 805310 140   LITTLETON 6 80531001515 5229 LITTLETON ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 40 1 6   0 5     0   1   29 24                       53 40 1 6   0 5     0   1   29 24                 53
709401 CO     school 805310 140   LITTLETON 6 80531001626 5233 LITTLETON PREP CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_7 39 1 15   1 0     0   1   23 34                       57 39 1 15   1 0     0   1   23 34                 57
709502 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006399 213 AXL ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 12 13 24   0 1     0   0   24 26                       50 12 13 24   0 1     0   0   24 26                 50
709534 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 13 10 19   1 0     0   2   21 24                       45 13 10 19   1 0     0   2   21 24                 45
709666 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes Elementary KG 08 2017   grade_7 9 15 66   0 0     0   0   38 52                       90 9 15 66   0 0     0   0   38 52                 90
709725 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2017   grade_7 12 23 39   1 5     0   0   46 34                       80 12 23 39   1 5     0   0   46 34                 80
709868 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006322 9056 VANGUARD CLASSICAL SCHOOL - WEST   Regular School Yes Elementary KG 08 2017   grade_7 10 12 26   0 0     0   1   29 20                       49 10 12 26   0 0     0   1   29 20                 49
709921 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes Other KG 12 2017   grade_7 13 23 29   1 1     1   2   20 50                       70 13 23 29   1 1     1   2   20 50                 70
709980 CO     school 802700 190   BYERS 32J 80270006605 2356 ELEVATE ACADEMY   Regular School Yes Other KG 12 2017   grade_7 34 7 80   3 0     1   0   69 56                       125 34 7 80   3 0     1   0   69 56                 125
710007 CO     school 802700 190   BYERS 32J 80270006620 6263 COLORADO DIGITAL ACADEMY - MIDDLE   Regular School Yes Middle 07 08 2017   grade_7 86 6 10   1 0     0   0   57 46                       103 86 6 10   1 0     0   0   57 46                 103
710178 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006530 71 ASPEN RIDGE PREPARATORY SCHOOL   Regular School Yes Elementary KG 07 2017   grade_7 6 1 3   0 0     0   1   7 4                       11 6 1 3   0 0     0   1   7 4                 11
710245 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001887 1284 CARBON VALLEY ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 4 1 4   0 0     0   0   8 1                       9 4 1 4   0 0     0   0   8 1                 9
710309 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001890 2964 FLAGSTAFF CHARTER ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 89 0 6   1 5     0   2   47 56                       103 89 0 6   1 5     0   2   47 56                 103
710358 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006388 4333 IMAGINE CHARTER   Regular School Yes Elementary PK 08 2017   grade_7 37 0 6   0 0     0   1   21 23                       44 37 0 6   0 0     0   1   21 23                 44
710499 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006430 7565 ST. VRAIN COMMUNITY MONTESSORI SCHOOL   Regular School Yes Elementary PK 08 2017   grade_7 13 0 0   0 0     0   0   7 6                       13 13 0 0   0 0     0   0   7 6                 13
710542 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001572 8927 TWIN PEAKS CHARTER ACADEMY   Regular School Yes Other KG 12 2017   grade_7 48 2 42   1 4     0   3   44 56                       100 48 2 42   1 4     0   3   44 56                 100
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
710883 CO     school 802490 480   BOULDER VALLEY RE 2 80249006199 6642 HORIZONS K-8 SCHOOL   Alternative School Yes Elementary KG 08 2017   grade_7 34 0 2   0 1     0   2   21 18                       39 34 0 2   0 1     0   2   21 18                 39
710897 CO     school 802490 480   BOULDER VALLEY RE 2 80249001792 6816 PEAK TO PEAK CHARTER SCHOOL   Regular School Yes Other KG 12 2017   grade_7 103 0 8   0 17     0   7   61 74                       135 103 0 8   0 17     0   7   61 74                 135
710932 CO     school 802490 480   BOULDER VALLEY RE 2 80249001517 8387 SUMMIT MIDDLE CHARTER SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 77 0 8   0 24     0   10   74 45                       119 77 0 8   0 24     0   10   74 45                 119
711259 CO     school 803330 870   DELTA COUNTY 50(J) 80333002024 2166 DELTA VISION SCHOOL   Alternative School Yes Other KG 12 2017   grade_7 27 1 7   0 0     0   1   18 18                       36 27 1 7   0 0     0   1   18 18                 36
711459 CO     school 803360 880   DENVER COUNTY 1 80336006449 1345 CESAR CHAVEZ ACADEMY DENVER   Regular School Yes Elementary KG 08 2017   grade_7 2 1 32   0 0     0   0   18 17                       35 2 1 32   0 0     0   0   18 17                 35
711549 CO     school 803360 880   DENVER COUNTY 1 80336006645 1939 COMPASS ACADEMY   Regular School Yes Middle 06 07 2017   grade_7 1 2 114   1 3     0   1   60 62                       122 1 2 114   1 3     0   1   60 62                 122
711559 CO     school 803360 880   DENVER COUNTY 1 80336006566 2115 DSST: STAPLETON MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 35 37 54   1 12     0   14   84 69                       153 35 37 54   1 12     0   14   84 69                 153
711581 CO     school 803360 880   DENVER COUNTY 1 80336006482 2127 DENVER LANGUAGE SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 4 1 8   0 0     0   1   8 6                       14 4 1 8   0 0     0   1   8 6                 14
711617 CO     school 803360 880   DENVER COUNTY 1 80336006546 2181 DSST: GREEN VALLEY RANCH MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 6 39 87   1 8     0   5   73 73                       146 6 39 87   1 8     0   5   73 73                 146
711642 CO     school 803360 880   DENVER COUNTY 1 80336006572 2186 DSST: BYERS MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 71 14 56   1 7     0   8   89 68                       157 71 14 56   1 7     0   8   89 68                 157
711677 CO     school 803360 880   DENVER COUNTY 1 80336006618 2218 DSST: CONSERVATORY GREEN MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 27 36 71   0 7     0   11   87 65                       152 27 36 71   0 7     0   11   87 65                 152
711681 CO     school 803360 880   DENVER COUNTY 1 80336006523 2223 DSST: COLE MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 5 19 123   1 0     1   3   79 73                       152 5 19 123   1 0     1   3   79 73                 152
711844 CO     school 803360 880   DENVER COUNTY 1 80336006473 3639 GIRLS ATHLETIC LEADERSHIP SCHOOL MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 49 5 39   0 3     0   3   0 99                       99 49 5 39   0 3     0   3   0 99                 99
711905 CO     school 803360 880   DENVER COUNTY 1 80336001835 3987 HIGHLINE ACADEMY SOUTHEAST   Regular School Yes Elementary KG 08 2017   grade_7 40 13 14   0 2     0   2   31 40                       71 40 13 14   0 2     0   2   31 40                 71
711955 CO     school 803360 880   DENVER COUNTY 1 80336006554 4381 DSST: COLLEGE VIEW MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 11 1 134   0 9     1   1   82 75                       157 11 1 134   0 9     1   1   82 75                 157
711998 CO     school 803360 880   DENVER COUNTY 1 80336006519 4507 KIPP MONTBELLO COLLEGE PREP   Regular School Yes Middle 05 08 2017   grade_7 4 27 84   0 1     0   2   62 56                       118 4 27 84   0 1     0   2   62 56                 118
712016 CO     school 803360 880   DENVER COUNTY 1 80336001865 4732 KIPP SUNSHINE PEAK ACADEMY   Regular School Yes Middle 05 08 2017   grade_7 5 1 99   0 0     0   0   50 55                       105 5 1 99   0 0     0   0   50 55                 105
712239 CO     school 803360 880   DENVER COUNTY 1 80336001636 6479 ODYSSEY SCHOOL OF DENVER   Regular School Yes Elementary KG 08 2017   grade_7 15 2 7   0 0     0   3   11 16                       27 15 2 7   0 0     0   3   11 16                 27
712249 CO     school 803360 880   DENVER COUNTY 1 80336001838 6508 OMAR D BLAIR CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 7 33 25   0 5     0   3   47 26                       73 7 33 25   0 5     0   3   47 26                 73
712421 CO     school 803360 880   DENVER COUNTY 1 80336002012 8085 STRIVE PREP - FEDERAL   Regular School Yes Middle 06 08 2017   grade_7 1 2 118   0 0     0   1   63 59                       122 1 2 118   0 0     0   1   63 59                 122
712571 CO     school 803360 880   DENVER COUNTY 1 80336006457 9336 STRIVE PREP - SUNNYSIDE   Regular School Yes Middle 06 08 2017   grade_7 4 3 83   1 0     0   1   44 48                       92 4 3 83   1 0     0   1   44 48                 92
712580 CO     school 803360 880   DENVER COUNTY 1 80336006444 9389 STRIVE PREP - WESTWOOD   Regular School Yes Middle 06 08 2017   grade_7 2 0 117   0 1     0   0   65 55                       120 2 0 117   0 1     0   0   65 55                 120
712584 CO     school 803360 880   DENVER COUNTY 1 80336006479 9390 STRIVE PREP - LAKE   Regular School Yes Middle 06 08 2017   grade_7 4 6 114   1 0     0   1   64 62                       126 4 6 114   1 0     0   1   64 62                 126
712646 CO     school 803360 880   DENVER COUNTY 1 80336006556 9730 STRIVE PREP - GVR   Regular School Yes Middle 06 08 2017   grade_7 7 36 72   0 2     2   5   59 65                       124 7 36 72   0 2     2   5   59 65                 124
712650 CO     school 803360 880   DENVER COUNTY 1 80336006537 9735 STRIVE PREP - MONTBELLO   Regular School Yes Middle 06 08 2017   grade_7 2 12 95   0 0     1   1   50 61                       111 2 12 95   0 0     1   1   50 61                 111
712659 CO     school 803360 880   DENVER COUNTY 1 80336001637 9739 WYATT ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 1 13 44   0 0     0   1   27 32                       59 1 13 44   0 0     0   1   27 32                 59
712690 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_7 63 0 10   0 0     0   2   37 38                       75 63 0 10   0 0     0   2   37 38                 75
712711 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006492 135 BEN FRANKLIN ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 53 0 10   0 4     0   2   29 40                       69 53 0 10   0 4     0   2   29 40                 69
712726 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001896 215 AMERICAN ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 125 2 16   0 17     0   8   83 85                       168 125 2 16   0 17     0   8   83 85                 168
712816 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001874 1512 CHALLENGE TO EXCELLENCE CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 40 0 1   1 4     0   1   19 28                       47 40 0 1   1 4     0   1   19 28                 47
712848 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345002011 1579 NORTH STAR ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 47 1 10   0 5     0   5   28 40                       68 47 1 10   0 5     0   5   28 40                 68
712859 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000812 1873 PARKER CORE KNOWLEDGE CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 56 0 6   0 13     0   3   48 30                       78 56 0 6   0 13     0   3   48 30                 78
713018 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006578 3847 HOPE ONLINE LEARNING ACADEMY MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 30 14 144   3 1     1   6   106 93                       199 30 14 144   3 1     1   6   106 93                 199
713091 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006493 5259 STEM SCHOOL   Regular School Yes Other KG 12 2017   grade_7 167 0 18   3 38     0   13   166 73                       239 167 0 18   3 38     0   13   166 73                 239
713144 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001581 5997 DC MONTESSORI CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_7 26 0 3   1 2     0   1   14 19                       33 26 0 3   1 2     0   1   14 19                 33
713155 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006588 6019 ASPEN VIEW ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 79 1 7   0 2     0   5   50 44                       94 79 1 7   0 2     0   5   50 44                 94
713183 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006455 6365 SKYVIEW ACADEMY   Regular School Yes Other PK 12 2017   grade_7 86 0 14   0 15     0   2   52 65                       117 86 0 14   0 15     0   2   52 65                 117
713207 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006690 6719 PARKER PERFORMING ARTS   Regular School Yes Elementary KG 08 2017   grade_7 69 3 21   0 1     0   7   25 76                       101 69 3 21   0 1     0   7   25 76                 101
713254 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001584 7047 PLATTE RIVER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 57 0 7   1 3     0   6   36 38                       74 57 0 7   1 3     0   6   36 38                 74
713458 CO     school 803540 910   EAGLE COUNTY RE 50 80354000851 2340 EAGLE COUNTY CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 35 0 0   0 2     0   2   25 14                       39 35 0 0   0 2     0   2   25 14                 39
713553 CO     school 803720 920   ELIZABETH C-1 80372001586 2572 LEGACY ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 55 0 4   2 0     0   1   28 34                       62 55 0 4   2 0     0   1   28 34                 62
713663 CO     school 804530 980   HARRISON 2 80453006691 369 ATLAS PREPARATORY MIDDLE SCHOOL   Regular School Yes Middle 05 08 2017   grade_7 18 14 123   0 0     2   8   89 76                       165 18 14 123   0 0     2   8   89 76                 165
713717 CO     school 804530 980   HARRISON 2 80453001964 4379 JAMES IRWIN CHARTER MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 49 16 62   2 11     1   1   65 77                       142 49 16 62   2 11     1   1   65 77                 142
714023 CO     school 803060 1010   COLORADO SPRINGS 11 80306006456 517 ACADEMY FOR ADVANCED AND CREATIVE LEARNING   Regular School Yes Elementary KG 08 2017   grade_7 24 0 2   2 0     0   1   13 16                       29 24 0 2   2 0     0   1   13 16                 29
714438 CO     school 802940 1020   CHEYENNE MOUNTAIN 12 80294006402 9051 THE VANGUARD SCHOOL (MIDDLE)   Regular School Yes Middle 07 08 2017   grade_7 62 5 26   1 7     1   7   51 58                       109 62 5 26   1 7     1   7   51 58                 109
714536 CO     school 801920 1040   ACADEMY 20 80192001931 1629 THE CLASSICAL ACADEMY MIDDLE SCHOOL   Regular School Yes Middle 07 08 2017   grade_7 201 1 23   1 7     2   12   123 124                       247 201 1 23   1 7     2   12   123 124                 247
714691 CO     school 801920 1040   ACADEMY 20 80192006447 8779 TCA COLLEGE PATHWAYS   Regular School Yes High 07 12 2017   grade_7 43 2 5   0 2     0   3   29 26                       55 43 2 5   0 2     0   3   29 26                 55
714803 CO     school 805820 1080   LEWIS-PALMER 38 80582001536 5093 MONUMENT CHARTER ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 89 1 13   0 5     0   8   44 72                       116 89 1 13   0 5     0   8   44 72                 116
714857 CO     school 803870 1110   FALCON 49 80387002027 555 BANNING LEWIS RANCH ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 52 5 20   1 2     0   7   47 40                       87 52 5 20   1 2     0   7   47 40                 87
714915 CO     school 803870 1110   FALCON 49 80387006386 4251 IMAGINE CLASSICAL ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 26 5 11   1 3     1   3   24 26                       50 26 5 11   1 3     1   3   24 26                 50
714938 CO     school 803870 1110   FALCON 49 80387006693 6653 POWER TECHNICAL EARLY COLLEGE   Career and Technical School Yes Other 06 10 2017   grade_7 30 1 8   0 0     0   0   33 6                       39 30 1 8   0 0     0   0   33 6                 39
714958 CO     school 803870 1110   FALCON 49 80387001844 6935 PIKES PEAK SCHOOL EXPEDITIONARY LEARNING   Regular School Yes Elementary KG 08 2017   grade_7 36 0 6   0 0     0   3   24 21                       45 36 0 6   0 0     0   3   24 21                 45
714988 CO     school 803870 1110   FALCON 49 80387002000 7463 ROCKY MOUNTAIN CLASSICAL ACADEMY   Regular School Yes Other KG 12 2017   grade_7 100 6 34   0 2     0   14   67 89                       156 100 6 34   0 2     0   14   67 89                 156
715119 CO     school 802790 1140   CANON CITY RE-1 80279001538 6752 MOUNT VIEW CORE KNOWLEDGE CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_7 26 0 2   0 1     0   1   17 13                       30 26 0 2   0 1     0   1   17 13                 30
715185 CO     school 804260 1180   ROARING FORK RE-1 80426001505 429 CARBONDALE COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 12 0 3   0 0     0   0   5 10                       15 12 0 3   0 0     0   0   5 10                 15
715437 CO     school 804470 1360   GUNNISON WATERSHED RE1J 80447001507 5577 MARBLE CHARTER SCHOOL   Regular School Yes Other KG 10 2017   grade_7 4 0 0   0 0     0   0   2 2                       4 4 0 0   0 0     0   0   2 2                 4
715660 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006587 1451 ADDENBROOKE CLASSICAL ACADEMY   Regular School Yes Other 06 12 2017   grade_7 39 0 16   0 2     1   1   24 35                       59 39 0 16   0 2     1   1   24 35                 59
715731 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001766 1880 COMPASS MONTESSORI - GOLDEN CHARTER SCHOOL   Regular School Yes Other PK 12 2017   grade_7 43 0 6   0 0     0   4   26 27                       53 43 0 6   0 0     0   4   26 27                 53
715768 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006695 2189 DORAL ACADEMY OF COLORADO   Regular School Yes Elementary KG 07 2017   grade_7 9 0 4   1 0     0   0   5 9                       14 9 0 4   1 0     0   0   5 9                 14
715826 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001508 2799 EXCEL ACADEMY CHARTER SCHOOL   Regular School Yes Other KG 12 2017   grade_7 37 0 13   0 2     0   2   25 29                       54 37 0 13   0 2     0   2   25 29                 54
715889 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001920 3201 FREE HORIZON MONTESSORI CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_7 16 0 3   0 0     0   0   10 9                       19 16 0 3   0 0     0   0   10 9                 19
715914 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006639 3393 GOLDEN VIEW CLASSICAL ACADEMY   Regular School Yes Other KG 11 2017   grade_7 42 0 9   0 4     0   1   30 26                       56 42 0 9   0 4     0   1   30 26                 56
715999 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001921 4404 JEFFERSON ACADEMY   Regular School Yes Other KG 12 2017   grade_7 122 1 20   0 8     0   9   75 85                       160 122 1 20   0 8     0   9   75 85                 160
716116 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001605 5145 LINCOLN CHARTER ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 40 1 14   0 3     0   5   33 30                       63 40 1 14   0 3     0   5   33 30                 63
716156 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001606 5415 ROCKY MOUNTAIN DEAF SCHOOL   Special Education School Yes Other PK 12 2017   grade_7 5 0 4   0 0     0   0   4 5                       9 5 0 4   0 0     0   0   4 5                 9
716236 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001607 5994 MONTESSORI PEAKS CHARTER ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
716270 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006311 6139 MOUNTAIN PHOENIX COMMUNITY SCHOOL   Regular School Yes Elementary PK 08 2017   grade_7 30 0 3   0 1     0   0   12 22                       34 30 0 3   0 1     0   0   12 22                 34
716428 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001812 7462 ROCKY MOUNTAIN ACADEMY OF EVERGREEN   Regular School Yes Elementary PK 08 2017   grade_7 31 0 3   0 2     0   0   9 27                       36 31 0 3   0 2     0   0   9 27                 36
716460 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001036 7701 COLLEGIATE ACADEMY OF COLORADO   Regular School Yes Other KG 12 2017   grade_7 13 0 5   0 1     0   2   6 15                       21 13 0 5   0 1     0   2   6 15                 21
716621 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006466 8793 TWO ROADS CHARTER SCHOOL   Regular School Yes Other PK 12 2017   grade_7 50 0 9   0 2     0   3   26 38                       64 50 0 9   0 2     0   3   26 38                 64
716734 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001807 9427 WOODROW WILSON CHARTER ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 39 1 9   0 1     0   2   27 25                       52 39 1 9   0 1     0   2   27 25                 52
717081 CO     school 803990 1550   POUDRE R-1 80399001717 146 RIDGEVIEW CLASSICAL CHARTER SCHOOLS   Regular School Yes Other KG 12 2017   grade_7 74 0 16   0 1     0   4   41 54                       95 74 0 16   0 1     0   4   41 54                 95
717250 CO     school 803990 1550   POUDRE R-1 80399001608 5120 LIBERTY COMMON CHARTER SCHOOL   Regular School Yes Other KG 12 2017   grade_7 73 0 8   0 5     0   3   41 48                       89 73 0 8   0 5     0   3   41 48                 89
717300 CO     school 803990 1550   POUDRE R-1 80399006573 5917 MOUNTAIN SAGE COMMUNITY SCHOOL   Regular School Yes Elementary KG 08 2017   grade_7 7 0 0   0 0     0   0   3 4                       7 7 0 0   0 0     0   0   3 4                 7
717613 CO     school 805400 1560   THOMPSON R2-J 80540006534 5235 LOVELAND CLASSICAL SCHOOL   Regular School Yes Other KG 12 2017   grade_7 45 0 5   0 0     0   2   26 26                       52 45 0 5   0 0     0   2   26 26                 52

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