Data source: Big Local News · About: Big Local

615 rows where grade = "grade_7", state = "CO" and year = 2019 sorted by total

View and edit SQL

year

  • 2019 · 615

grade

  • grade_7 · 615
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
1931393 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2019   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1932689 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_7 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
1934012 CO     school 802490 480   BOULDER VALLEY RE 2 80249002013 4496 JUSTICE HIGH CHARTER SCHOOL   Alternative School Yes High 06 12 2019   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1934326 CO     school 805100 550   NORTH CONEJOS RE-1J 80510006601 6339 NORTH CONEJOS ALTERNATIVE PROGRAM   Alternative School No Other KG 12 2019   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1934456 CO     school 803330 870   DELTA COUNTY 50(J) 80333001953 2155 GRAND MESA CHOICE ACADEMY   Alternative School No High 07 12 2019   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1936928 CO     school 801980 960   AGATE 300 80198000021 48 AGATE JUNIOR SENIOR HIGH SCHOOL   Regular School No High 06 12 2019   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1938075 CO     school 804500 1070   HANOVER 28 80450006720 3941 HANOVER ONLINE ACADEMY   Regular School No High 06 12 2019   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1941230 CO     school 804890 1810   KARVAL RE-23 80489000815 4506 KARVAL JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 07 12 2019   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1941953 CO     school 805850 2190   WEST END RE-2 80585001693 6718 PARADOX VALLEY CHARTER SCHOOL   Regular School Yes Other PK 12 2019   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1942239 CO     school 804710 2620   HOLYOKE RE-1J 80471006610 2686 HOLYOKE ALTERNATIVE SCHOOL   Alternative School No High 07 12 2019   grade_7 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
1934207 CO     school 806330 500   SALIDA R-32 80633006500 1554 CREST ACADEMY   Regular School No Middle 05 08 2019   grade_7 7 0 3   0 0     0   0   4 6                       10 7 0 3   0 0     0   0   4 6                 10
1939333 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006439 4408 JEFFCO VIRTUAL ACADEMY   Alternative School No High 06 12 2019   grade_7 3 1 2   1 1     0   2   7 3                       10 3 1 2   1 1     0   2   7 3                 10
1939840 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006307 8036 SOBESKY ACADEMY   Special Education School No Other KG 12 2019   grade_7 4 0 5   1 0     0   0   9 1                       10 4 0 5   1 0     0   0   9 1                 10
1944253 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006651 8061 SALIDA MONTESSORI CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_7 8 0 1   0 0     0   1   6 4                       10 8 0 1   0 0     0   1   6 4                 10
1937645 CO     school 803060 1010   COLORADO SPRINGS 11 80306000272 9404 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 63 7 21   1 0     1   7   49 51                       100 63 7 21   1 0     1   7   49 51                 100
1938418 CO     school 802790 1140   CANON CITY RE-1 80279000173 3802 HARRISON SCHOOL   Regular School No Elementary KG 08 2019   grade_7 83 0 12   1 1     0   4   52 49                       101 83 0 12   1 1     0   4   52 49                 101
1940355 CO     school 802400 1530   BAYFIELD 10 JT-R 80240000089 636 BAYFIELD MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 78 1 17   1 2     0   2   52 49                       101 78 1 17   1 2     0   2   52 49                 101
1932059 CO     school 806540 123   SHERIDAN 2 80654001135 7837 FORT LOGAN NORTHGATE   Regular School No Middle 03 08 2019   grade_7 11 2 81   1 5     0   2   52 50                       102 11 2 81   1 5     0   2   52 50                 102
1936476 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006690 6719 PARKER PERFORMING ARTS   Regular School Yes Elementary KG 08 2019   grade_7 80 1 13   0 1     0   7   24 78                       102 80 1 13   0 1     0   7   24 78                 102
1937040 CO     school 804530 980   HARRISON 2 80453001903 6162 MOUNTAIN VISTA COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   grade_7 22 9 59   0 4     0   8   54 48                       102 22 9 59   0 4     0   8   54 48                 102
1941960 CO     school 802610 2395   BRUSH RE-2(J) 80261000153 1094 BRUSH MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 58 3 39   0 1     0   1   49 53                       102 58 3 39   0 1     0   1   49 53                 102
1930958 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2019   grade_7 21 4 71   1 1     1   4   57 46                       103 21 4 71   1 1     1   4   57 46                 103
1935837 CO     school 803360 880   DENVER COUNTY 1 80336006444 9389 STRIVE PREP - WESTWOOD   Regular School Yes Middle 06 08 2019   grade_7 1 3 93   1 4     0   1   57 46                       103 1 3 93   1 4     0   1   57 46                 103
1942291 CO     school 802280 2640   ASPEN 1 80228000046 430 ASPEN MIDDLE SCHOOL   Regular School No Middle 05 08 2019   grade_7 88 2 10   0 3     0   0   50 53                       103 88 2 10   0 3     0   0   50 53                 103
1933543 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000901 3192 THUNDER VALLEY PK-8   Regular School No Elementary PK 08 2019   grade_7 45 0 56   0 0     0   3   46 58                       104 45 0 56   0 0     0   3   46 58                 104
1937730 CO     school 802940 1020   CHEYENNE MOUNTAIN 12 80294006402 9051 THE VANGUARD SCHOOL (MIDDLE)   Regular School Yes Middle 07 08 2019   grade_7 57 4 22   0 13     1   7   49 55                       104 57 4 22   0 13     1   7   49 55                 104
1934912 CO     school 803360 880   DENVER COUNTY 1 80336006624 2227 DENVER DISCOVERY SCHOOL   Regular School No Middle 06 08 2019   grade_7 29 36 34   0 1     0   6   49 57                       106 29 36 34   0 1     0   6   49 57                 106
1935310 CO     school 803360 880   DENVER COUNTY 1 80336006490 5255 LAKE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 9 15 74   5 2     0   2   60 47                       107 9 15 74   5 2     0   2   60 47                 107
1943458 CO     school 807350 3100   WINDSOR RE-4 80735006650 9393 WINDSOR CHARTER ACADEMY MIDDLE AND EARLY COLLEGE HIGH SCHOOL   Regular School Yes High 06 12 2019   grade_7 83 1 15   0 4     0   4   51 56                       107 83 1 15   0 4     0   4   51 56                 107
1933531 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001890 2964 FLAGSTAFF CHARTER ACADEMY   Regular School Yes Elementary PK 08 2019   grade_7 86 1 13   0 5     0   4   60 49                       109 86 1 13   0 5     0   4   60 49                 109
1935841 CO     school 803360 880   DENVER COUNTY 1 80336006479 9390 STRIVE PREP - LAKE   Regular School Yes Middle 06 08 2019   grade_7 1 7 100   0 0     0   1   62 47                       109 1 7 100   0 0     0   1   62 47                 109
1936795 CO     school 803540 910   EAGLE COUNTY RE 50 80354001478 5742 HOMESTAKE PEAK SCHOOL   Regular School No Elementary PK 08 2019   grade_7 40 0 63   3 1     0   2   55 54                       109 40 0 63   3 1     0   2   55 54                 109
1934261 CO     school 800001 520   CHEYENNE COUNTY RE-5 80000100215 1612 CHEYENNE WELLS JUNIOR/HIGH SCHOOL   Regular School No High 07 12 2019   grade_7 8 0 3   0 0     0   0   6 5                       11 8 0 3   0 0     0   0   6 5                 11
1934450 CO     school 803330 870   DELTA COUNTY 50(J) 80333002001 2152 DELTA ACADEMY OF APPLIED LEARNING   Alternative School No Middle 05 08 2019   grade_7 10 0 1   0 0     0   0   8 3                       11 10 0 1   0 0     0   0   8 3                 11
1940151 CO     school 802260 1450   ARRIBA-FLAGLER C-20 80226000509 2960 FLAGLER PUBLIC SCHOOL   Regular School No Other PK 12 2019   grade_7 11 0 0   0 0     0   0   4 7                       11 11 0 0   0 0     0   0   4 7                 11
1940166 CO     school 806510 1460   HI-PLAINS R-23 80651001130 7746 HI-PLAINS SCHOOL DISTRICT R-23   Regular School No Other PK 12 2019   grade_7 8 0 3   0 0     0   0   6 5                       11 8 0 3   0 0     0   0   6 5                 11
1940918 CO     school 805400 1560   THOMPSON R2-J 80540006558 5121 LEAP SCHOOL   Regular School No Other KG 12 2019   grade_7 10 0 0   0 0     0   1   5 6                       11 10 0 0   0 0     0   1   5 6                 11
1941325 CO     school 803240 1980   DE BEQUE 49JT 80324000286 2126 DE BEQUE PK-12 SCHOOL DISTRICT 49JT   Regular School No Other PK 12 2019   grade_7 9 1 1   0 0     0   0   5 6                       11 9 1 1   0 0     0   0   5 6                 11
1942030 CO     school 807140 2505   WELDON VALLEY RE-20(J) 80714001218 9360 WELDON VALLEY JR/SR HIGH SCHOOL   Regular School No High 07 12 2019   grade_7 9 0 2   0 0     0   0   6 5                       11 9 0 2   0 0     0   0   6 5                 11
1942095 CO     school 805520 2535   MANZANOLA 3J 80552001375 5506 MANZANOLA JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 06 12 2019   grade_7 3 0 8   0 0     0   0   4 7                       11 3 0 8   0 0     0   0   4 7                 11
1943652 CO     school 804410 3120   GREELEY 6 80441006461 4425 JEFFERSON JUNIOR/SENIOR HIGH   Alternative School No High 07 12 2019   grade_7 5 0 5   0 1     0   0   10 1                       11 5 0 5   0 1     0   0   10 1                 11
1933767 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006739 8055 SOARING HEIGHTS PK-8   Regular School No Elementary PK 08 2019   grade_7 86 1 19   0 2     1   1   59 51                       110 86 1 19   0 2     1   1   59 51                 110
1935070 CO     school 803360 880   DENVER COUNTY 1 80336006473 3639 GIRLS ATHLETIC LEADERSHIP SCHOOL MIDDLE SCHOOL   Regular School Yes Middle 06 08 2019   grade_7 65 8 28   1 2     0   7   0 111                       111 65 8 28   1 2     0   7   0 111                 111
1938522 CO     school 804260 1180   ROARING FORK RE-1 80426000133 561 BASALT MIDDLE SCHOOL   Regular School No Middle 05 08 2019   grade_7 52 0 56   0 1     0   2   57 54                       111 52 0 56   0 1     0   2   57 54                 111
1934770 CO     school 803360 880   DENVER COUNTY 1 80336006645 1939 COMPASS ACADEMY   Regular School Yes Middle 06 08 2019   grade_7 0 4 106   1 1     0   0   58 54                       112 0 4 106   1 1     0   0   58 54                 112
1935259 CO     school 803360 880   DENVER COUNTY 1 80336001865 4732 KIPP SUNSHINE PEAK ACADEMY   Regular School Yes Middle 05 08 2019   grade_7 0 2 111   0 0     0   0   45 68                       113 0 2 111   0 0     0   0   45 68                 113
1935287 CO     school 803360 880   DENVER COUNTY 1 80336006442 4795 KUNSMILLER CREATIVE ARTS ACADEMY   Regular School No Other KG 12 2019   grade_7 14 0 89   2 6     0   2   60 53                       113 14 0 89   2 6     0   2   60 53                 113
1934075 CO     school 802490 480   BOULDER VALLEY RE 2 80249001573 6000 MONARCH K-8 SCHOOL   Regular School No Elementary PK 08 2019   grade_7 79 1 13   0 12     0   10   49 66                       115 79 1 13   0 12     0   10   49 66                 115
1935679 CO     school 803360 880   DENVER COUNTY 1 80336002012 8085 STRIVE PREP - FEDERAL   Regular School Yes Middle 06 08 2019   grade_7 3 2 108   1 1     0   0   59 56                       115 3 2 108   1 1     0   0   59 56                 115
1936759 CO     school 803540 910   EAGLE COUNTY RE 50 80354001309 2355 EAGLE VALLEY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 79 0 33   1 1     0   2   60 56                       116 79 0 33   1 1     0   2   60 56                 116
1940472 CO     school 803990 1550   POUDRE R-1 80399000524 1190 CACHE LA POUDRE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 97 0 10   0 0     0   9   63 53                       116 97 0 10   0 0     0   9   63 53                 116
1944068 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006542 2067 COLORADO EARLY COLLEGE FORT COLLINS   Regular School Yes High 06 12 2019   grade_7 80 1 25   0 5     0   5   52 64                       116 80 1 25   0 5     0   5   52 64                 116
1936451 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006455 6365 SKYVIEW ACADEMY   Regular School Yes Other PK 12 2019   grade_7 84 1 11   0 14     0   7   57 60                       117 84 1 11   0 14     0   7   57 60                 117
1936967 CO     school 804530 980   HARRISON 2 80453000662 1306 CARMEL MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 24 19 58   2 2     0   13   67 51                       118 24 19 58   2 2     0   13   67 51                 118
1938112 CO     school 805820 1080   LEWIS-PALMER 38 80582001536 5093 MONUMENT CHARTER ACADEMY   Regular School Yes Elementary PK 08 2019   grade_7 99 1 12   1 3     0   2   58 60                       118 99 1 12   1 3     0   2   58 60                 118
1934158 CO     school 802490 480   BOULDER VALLEY RE 2 80249001517 8387 SUMMIT MIDDLE CHARTER SCHOOL   Regular School Yes Middle 06 08 2019   grade_7 73 1 9   0 20     1   15   60 59                       119 73 1 9   0 20     1   15   60 59                 119
1935973 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006492 135 BEN FRANKLIN ACADEMY   Regular School Yes Elementary PK 08 2019   grade_7 96 3 10   0 6     1   3   56 63                       119 96 3 10   0 6     1   3   56 63                 119
1942063 CO     school 805130 2520   EAST OTERO R-1 80513006484 5015 LA JUNTA JR/SR HIGH SCHOOL   Regular School No High 07 12 2019   grade_7 35 1 80   1 1     1   0   64 55                       119 35 1 80   1 1     1   0   64 55                 119
1931131 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No High 06 12 2019   grade_7 3 0 8   0 0     1   0   11 1                       12 3 0 8   0 0     1   0   11 1                 12
1932677 CO     school 803270 170   DEER TRAIL 26J 80327000288 2140 DEER TRAIL JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 06 12 2019   grade_7 10 0 2   0 0     0   0   8 4                       12 10 0 2   0 0     0   0   8 4                 12
1934245 CO     school 805040 510   KIT CARSON R-1 80504000826 4742 KIT CARSON JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 06 12 2019   grade_7 9 0 2   0 1     0   0   3 9                       12 9 0 2   0 1     0   0   3 9                 12
1934355 CO     school 802130 580   SOUTH CONEJOS RE-10 80213001464 250 ANTONITO MIDDLE SCHOOL   Regular School No Middle 07 08 2019   grade_7 1 0 11   0 0     0   0   6 6                       12 1 0 11   0 0     0   0   6 6                 12
1935820 CO     school 803360 880   DENVER COUNTY 1 80336006514 8995 VISTA ACADEMY   Alternative School No High 06 12 2019   grade_7 2 4 6   0 0     0   0   6 6                       12 2 4 6   0 0     0   0   6 6                 12
1936279 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006656 3327 GLOBAL VILLAGE ACADEMY - DOUGLAS COUNTY   Regular School Yes Elementary PK 07 2019   grade_7 5 0 5   0 0     0   2   7 5                       12 5 0 5   0 0     0   2   7 5                 12
1939381 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006306 4798 CONNECTIONS LEARNING CENTER ON THE EARLE JOHNSON CAMPUS   Alternative School No Middle 06 08 2019   grade_7 6 0 6   0 0     0   0   11 1                       12 6 0 6   0 0     0   0   11 1                 12
1942154 CO     school 805970 2580   OURAY R-1 80597001662 6598 OURAY MIDDLE SCHOOL   Regular School No Middle 07 08 2019   grade_7 12 0 0   0 0     0   0   8 4                       12 12 0 0   0 0     0   0   8 4                 12
1942909 CO     school 806660 2770   STEAMBOAT SPRINGS RE-2 80666001749 6363 NORTH ROUTT CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_7 11 0 0   0 1     0   0   2 10                       12 11 0 0   0 1     0   0   2 10                 12
1942968 CO     school 806300 2790   MOUNTAIN VALLEY RE 1 80630001415 6146 MOUNTAIN VALLEY SCHOOL   Regular School No Other PK 12 2019   grade_7 8 0 4   0 0     0   0   6 6                       12 8 0 4   0 0     0   0   6 6                 12
1935428 CO     school 803360 880   DENVER COUNTY 1 80336000386 6098 MOREY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 48 26 27   0 2     0   17   76 44                       120 48 26 27   0 2     0   17   76 44                 120
1933108 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006483 9083 VISTA PEAK P-8 EXPLORATORY   Regular School No Elementary PK 08 2019   grade_7 33 16 59   2 3     0   9   70 52                       122 33 16 59   2 3     0   9   70 52                 122
1934850 CO     school 803360 880   DENVER COUNTY 1 80336001917 2183 DENVER CENTER FOR INTERNATIONAL STUDIES   Regular School No High 06 12 2019   grade_7 19 8 82   5 6     0   2   54 68                       122 19 8 82   5 6     0   2   54 68                 122
1935903 CO     school 803360 880   DENVER COUNTY 1 80336006556 9730 STRIVE PREP - GVR   Regular School Yes Middle 06 08 2019   grade_7 13 24 78   0 3     1   4   54 69                       123 13 24 78   0 3     1   4   54 69                 123
1942326 CO     school 805220 2660   LAMAR RE-2 80522000861 4956 LAMAR MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 56 1 64   2 0     0   1   70 54                       124 56 1 64   2 0     0   1   70 54                 124
1938920 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000696 660 BEAR CREEK K-8 SCHOOL   Regular School No Elementary KG 08 2019   grade_7 61 1 40   2 9     3   9   68 57                       125 61 1 40   2 9     3   9   68 57                 125
1942784 CO     school 806150 2700   PUEBLO COUNTY 70 80615001085 9134 VINELAND MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 55 0 65   1 0     0   4   57 68                       125 55 0 65   1 0     0   4   57 68                 125
1938476 CO     school 803960 1150   FREMONT RE-2 80396001595 3226 FREMONT MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 94 1 21   1 1     0   8   66 60                       126 94 1 21   1 1     0   8   66 60                 126
1938883 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006489 109 ARVADA K-8   Regular School No Elementary KG 08 2019   grade_7 50 2 58   6 3     1   6   77 49                       126 50 2 58   6 3     1   6   77 49                 126
1933333 CO     school 805250 290   LAS ANIMAS RE-1 80525006678 443 AIM GLOBAL   Alternative School No High 06 12 2019   grade_7 43 3 79   0 1     0   1   64 63                       127 43 3 79   0 1     0   1   64 63                 127
1934908 CO     school 803360 880   DENVER COUNTY 1 80336006523 2223 DSST: COLE MIDDLE SCHOOL   Regular School Yes Middle 06 08 2019   grade_7 2 28 95   0 2     0   0   65 62                       127 2 28 95   0 2     0   0   65 62                 127
1935240 CO     school 803360 880   DENVER COUNTY 1 80336006519 4507 KIPP NORTHEAST DENVER MIDDLE SCHOOL   Regular School Yes Middle 05 08 2019   grade_7 5 21 94   0 4     0   3   63 64                       127 5 21 94   0 4     0   3   63 64                 127
1931166 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690000728 1519 STARGATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_7 86 0 14   1 21     0   6   52 76                       128 86 0 14   1 21     0   6   52 76                 128
1934899 CO     school 803360 880   DENVER COUNTY 1 80336006528 2209 DCIS AT MONTBELLO   Regular School No High 06 12 2019   grade_7 1 17 107   0 1     1   1   77 51                       128 1 17 107   0 1     1   1   77 51                 128
1935338 CO     school 803360 880   DENVER COUNTY 1 80336001406 5605 DR. MARTIN LUTHER KING JR. EARLY COLLEGE   Regular School No High 06 12 2019   grade_7 6 37 66   0 13     1   6   72 57                       129 6 37 66   0 13     1   6   72 57                 129
1940118 CO     school 803510 1430   EADS RE-1 80351001277 2332 EADS MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 12 0 1   0 0     0   0   7 6                       13 12 0 1   0 0     0   0   7 6                 13
1941111 CO     school 807260 1590   PRIMERO REORGANIZED 2 80726001255 7164 PRIMERO JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 06 12 2019   grade_7 4 0 8   0 0     0   1   4 9                       13 4 0 8   0 0     0   1   4 9                 13
1942864 CO     school 805760 2740   MONTE VISTA C-8 80576001560 6520 MONTE VISTA ON-LINE ACADEMY   Alternative School No Other 04 12 2019   grade_7 7 0 4   0 0     0   2   4 9                       13 7 0 4   0 0     0   2   4 9                 13
1943074 CO     school 805880 2840   NORWOOD R-2J 80588001012 6422 NORWOOD PUBLIC SCHOOLS   Regular School No Other PK 12 2019   grade_7 12 0 1   0 0     0   0   5 8                       13 12 0 1   0 0     0   0   5 8                 13
1943277 CO     school 805340 3060   LONE STAR 101 80534006376 5238 LONE STAR MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 11 0 2   0 0     0   0   4 9                       13 11 0 2   0 0     0   0   4 9                 13
1943841 CO     school 802550 3146   BRIGGSDALE RE-10 80255000143 1012 BRIGGSDALE UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2019   grade_7 9 0 3   0 1     0   0   8 5                       13 9 0 3   0 1     0   0   8 5                 13
1931383 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006507 6802 PROSPECT RIDGE ACADEMY   Regular School Yes Other KG 12 2019   grade_7 95 0 19   0 8     0   8   55 75                       130 95 0 19   0 8     0   8   55 75                 130
1936837 CO     school 803720 920   ELIZABETH SCHOOL DISTRICT 80372000482 2604 ELIZABETH MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 112 1 13   0 1     0   3   77 53                       130 112 1 13   0 1     0   3   77 53                 130
1943579 CO     school 804410 3120   GREELEY 6 80441001614 1875 FRONTIER CHARTER ACADEMY   Regular School Yes Other KG 12 2019   grade_7 93 0 32   0 1     1   3   57 73                       130 93 0 32   0 1     1   3   57 73                 130
1935249 CO     school 803360 880   DENVER COUNTY 1 80336006686 4513 KEPNER BEACON MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 10 4 111   1 4     0   2   72 60                       132 10 4 111   1 4     0   2   72 60                 132
1939345 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000739 4422 JEFFERSON JUNIOR/SENIOR HIGH SCHOOL   Regular School No High 07 12 2019   grade_7 23 5 98   2 1     0   3   65 67                       132 23 5 98   2 1     0   3   65 67                 132
1942690 CO     school 806150 2700   PUEBLO COUNTY 70 80615001078 7086 PLEASANT VIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 65 1 62   0 0     0   4   69 63                       132 65 1 62   0 0     0   4   69 63                 132
1934124 CO     school 802490 480   BOULDER VALLEY RE 2 80249001792 6816 PEAK TO PEAK CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_7 96 0 7   0 27     0   4   69 65                       134 96 0 7   0 27     0   4   69 65                 134
1934858 CO     school 803360 880   DENVER COUNTY 1 80336001574 2184 DENVER SCHOOL OF THE ARTS   Regular School No High 06 12 2019   grade_7 93 3 21   0 7     0   12   47 89                       136 93 3 21   0 7     0   12   47 89                 136
1941456 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000605 2392 EAST MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 104 1 22   0 4     0   5   86 50                       136 104 1 22   0 4     0   5   86 50                 136
1935469 CO     school 803360 880   DENVER COUNTY 1 80336001869 6350 BRUCE RANDOLPH SCHOOL   Regular School No High 06 12 2019   grade_7 3 10 122   0 0     0   2   77 60                       137 3 10 122   0 0     0   2   77 60                 137
1943545 CO     school 804410 3120   GREELEY 6 80441001990 54 BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY   Regular School No Elementary KG 08 2019   grade_7 10 6 118   0 3     1   0   74 64                       138 10 6 118   0 3     1   0   74 64                 138

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