Data source: Big Local News · About: Big Local

586 rows where grade = "grade_7", state = "CO" and year = 2016 sorted by rowid descending

View and edit SQL

year

  • 2016 · 586

grade

  • grade_7 · 586
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
848555 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2016   grade_7 4 0 3   0 0     0   0   5 2                       7 4 0 3   0 0     0   0   5 2                 7
848536 CO     school 800282 9170   COLORADO DIGITAL BOCES 80028206600 1550 COLORADO PREP ACADEMY   Regular School No 4.0 KG 12 2016   grade_7 106 14 32   2 1     1   5   67 94                       161 106 14 32   2 1     1   5   67 94                 161
848517 CO     school 800004 9130   EXPEDITIONARY BOCES 80000400709 2840 ROCKY MOUNTAIN SCHOOL OF EXPEDITIONARY LEARNING   Regular School No 4.0 KG 12 2016   grade_7 34 1 9   0 2     0   4   34 16                       50 34 1 9   0 2     0   4   34 16                 50
848504 CO     school 899300 9050   SAN JUAN BOCES 89930006497 8121 SOUTHWEST COLORADO E-SCHOOL   Regular School No 4.0 06 12 2016   grade_7 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
848485 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 COLORADO SCHOOL FOR THE DEAF AND BLIND   Special Education School No 4.0 PK 12 2016   grade_7 4 0 4   0 0     0   0   5 3                       8 4 0 4   0 0     0   0   5 3                 8
848472 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001612 9785 YOUTH & FAMILY ACADEMY CHARTER   Alternative Education School Yes 3.0 07 12 2016   grade_7 2 0 7   0 0     0   0   2 7                       9 2 0 7   0 0     0   0   2 7                 9
848466 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006579 9040 VICTORY PREPARATORY ACADEMY MIDDLE STATE CHARTER SCHOOL   Regular School Yes 2.0 06 08 2016   grade_7 9 1 76   0 0     0   0   39 47                       86 9 1 76   0 0     0   0   39 47                 86
848456 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006338 8929 PIKES PEAK PREP   Regular School Yes 4.0 KG 12 2016   grade_7 21 5 6   0 0     1   0   15 18                       33 21 5 6   0 0     1   0   15 18                 33
848443 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes 4.0 06 12 2016   grade_7 63 1 25   0 0     0   4   47 46                       93 63 1 25   0 0     0   4   47 46                 93
848434 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006635 8821 TWO RIVERS COMMUNITY SCHOOL   Regular School Yes 1.0 KG 08 2016   grade_7 17 1 6   0 0     0   0   10 14                       24 17 1 6   0 0     0   0   10 14                 24
848423 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006651 8061 SALIDA MONTESSORI CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2016   grade_7 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
848412 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001913 7512 ROSS MONTESSORI SCHOOL   Regular School Yes 1.0 KG 08 2016   grade_7 16 0 2   0 0     0   0   3 15                       18 16 0 2   0 0     0   0   3 15                 18
848402 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006320 7278 RICARDO FLORES MAGON ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_7 0 0 34   0 0     0   0   19 15                       34 0 0 34   0 0     0   0   19 15                 34
848388 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002002010 6913 THE PINNACLE CHARTER SCHOOL MIDDLE   Regular School Yes 2.0 06 08 2016   grade_7 33 0 137   1 6     0   0   73 104                       177 33 0 137   1 6     0   0   73 104                 177
848367 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006589 5851 MOUNTAIN SONG COMMUNITY SCHOOL   Regular School Yes 1.0 KG 07 2016   grade_7 20 0 4   0 0     0   1   12 13                       25 20 0 4   0 0     0   1   12 13                 25
848358 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2016   grade_7 57 0 3   0 0     0   0   33 27                       60 57 0 3   0 0     0   0   33 27                 60
848339 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006596 3399 GLOBAL VILLAGE ACADEMY - FORT COLLINS   Regular School Yes 1.0 KG 07 2016   grade_7 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
848330 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006586 3326 GLOBAL VILLAGE ACADEMY - COLORADO SPRINGS   Regular School Yes 1.0 KG 07 2016   grade_7 3 3 6   0 2     0   5   8 11                       19 3 3 6   0 2     0   5   8 11                 19
848320 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006390 2837 EARLY COLLEGE OF ARVADA   Regular School Yes 4.0 06 12 2016   grade_7 19 0 34   0 8     0   1   26 36                       62 19 0 34   0 8     0   1   26 36                 62
848307 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006542 2067 COLORADO EARLY COLLEGE FORT COLLINS   Regular School Yes 4.0 06 12 2016   grade_7 48 2 4   0 0     0   0   28 26                       54 48 2 4   0 0     0   0   28 26                 54
848299 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001569 2035 CROWN POINTE CHARTER ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_7 21 1 25   0 3     1   1   29 23                       52 21 1 25   0 3     1   1   29 23                 52
848275 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001912 1791 COLORADO SPRINGS CHARTER ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_7 34 1 7   0 0     0   3   18 27                       45 34 1 7   0 0     0   3   18 27                 45
848263 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006305 1279 CAPROCK ACADEMY   Regular School Yes 4.0 KG 12 2016   grade_7 57 1 10   0 1     0   3   39 33                       72 57 1 10   0 1     0   3   39 33                 72
848242 CO     school   8001   CHARTER SCHOOL INSTITUTE   655 HIGH POINT ACADEMY             2016   grade_7 14 20 20   2 2     0   4   22 40                       62 14 20 20   2 2     0   4   22 40                 62
848224 CO     school   8001   CHARTER SCHOOL INSTITUTE   653 STONE CREEK SCHOOL             2016   grade_7 16 0 7   0 0     0   1   15 9                       24 16 0 7   0 0     0   1   15 9                 24
848209 CO     school   8001   CHARTER SCHOOL INSTITUTE   35 FRONTIER CHARTER ACADEMY             2016   grade_7 3 0 0   0 0     0   0   3 0                       3 3 0 0   0 0     0   0   3 0                 3
848197 CO     school   8001   CHARTER SCHOOL INSTITUTE   15 ACADEMY OF CHARTER SCHOOLS             2016   grade_7 77 2 48   0 14     0   3   69 75                       144 77 2 48   0 14     0   3   69 75                 144
848184 CO     school 800019 3230   LIBERTY J-4 80001901744 5123 LIBERTY JUNIOR-SENIOR HIGH SCHOOL   Vocational Education School No 4.0 06 12 2016   grade_7 11 0 0   0 0     0   0   7 4                       11 11 0 0   0 0     0   0   7 4                 11
848168 CO     school 800018 3220   IDALIA RJ-3 80001801742 4231 IDALIA JUNIOR-SENIOR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 9 0 3   1 0     0   0   5 8                       13 9 0 3   1 0     0   0   5 8                 13
848148 CO     school 800017 3210   WRAY RD-2 80001701817 9729 BUCHANAN MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_7 34 2 17   0 0     0   2   29 26                       55 34 2 17   0 0     0   2   29 26                 55
848125 CO     school 800016 3200   YUMA 1 80001601819 9791 YUMA MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_7 40 0 33   0 0     0   0   45 28                       73 40 0 33   0 0     0   0   45 28                 73
848115 CO     school 804440 3148   PAWNEE RE-12 80444000653 6812 PAWNEE SCHOOL PK-12   Regular School No 4.0 PK 12 2016   grade_7 4 0 1   0 0     0   0   4 1                       5 4 0 1   0 0     0   0   4 1                 5
848102 CO     school 806720 3147   PRAIRIE RE-11 80672001158 7156 PRAIRIE JUNIOR-SENIOR HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_7 15 0 0   0 0     0   0   8 7                       15 15 0 0   0 0     0   0   8 7                 15
848086 CO     school 802550 3146   BRIGGSDALE RE-10 80255000143 1012 BRIGGSDALE UNDIVIDED HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_7 7 0 2   0 1     0   0   5 5                       10 7 0 2   0 1     0   0   5 5                 10
848066 CO     school 802310 3145   AULT-HIGHLAND RE-9 80231001466 3961 HIGHLAND MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 48 0 25   0 0     0   1   41 33                       74 48 0 25   0 0     0   1   41 33                 74
848046 CO     school 804020 3140   WELD COUNTY S/D RE-8 80402006606 7219 QUEST ACADEMY AT DACONO   Regular School No 1.0 KG 08 2016   grade_7 4 0 11   0 0     0   0   9 6                       15 4 0 11   0 0     0   0   9 6                 15
848024 CO     school 804020 3140   WELD COUNTY S/D RE-8 80402000553 3066 FORT LUPTON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 35 0 125   0 0     0   0   82 78                       160 35 0 125   0 0     0   0   82 78                 160
848020 CO     school 804950 3130   PLATTE VALLEY RE-7 80495001697 7054 PLATTE VALLEY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 63 0 27   0 1     0   0   43 48                       91 63 0 27   0 1     0   0   43 48                 91
848003 CO     school 804410 3120   GREELEY 6 80441006504 9611 WEST RIDGE ACADEMY   Regular School Yes 4.0 KG 09 2016   grade_7 11 0 14   0 0     0   1   9 17                       26 11 0 14   0 0     0   1   9 17                 26
847986 CO     school 804410 3120   GREELEY 6 80441001615 8965 UNION COLONY PREPARATORY SCHOOL   Regular School Yes 4.0 06 12 2016   grade_7 45 2 41   0 1     2   0   44 47                       91 45 2 41   0 1     2   0   44 47                 91
847978 CO     school 804410 3120   GREELEY 6 80441006638 8467 SALIDA DEL SOL ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_7 1 0 60   0 0     0   0   22 39                       61 1 0 60   0 0     0   0   22 39                 61
847904 CO     school 804410 3120   GREELEY 6 80441000645 4438 PRAIRIE HEIGHTS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 60 6 171   3 15     0   1   128 128                       256 60 6 171   3 15     0   1   128 128                 256
847888 CO     school 804410 3120   GREELEY 6 80441000642 3880 HEATH MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 54 7 183   0 2     1   1   120 128                       248 54 7 183   0 2     1   1   120 128                 248
847874 CO     school 804410 3120   GREELEY 6 80441000639 3162 FRANKLIN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 25 2 204   3 4     0   2   121 119                       240 25 2 204   3 4     0   2   121 119                 240
847868 CO     school 804410 3120   GREELEY 6 80441001696 2850 UNIVERSITY SCHOOLS   Regular School Yes 4.0 KG 12 2016   grade_7 95 1 65   0 3     1   2   81 86                       167 95 1 65   0 3     1   2   81 86                 167
847855 CO     school 804410 3120   GREELEY 6 80441006505 2825 ENGAGE ONLINE ACADEMY   Regular School No 4.0 KG 12 2016   grade_7 5 0 6   0 0     0   0   7 4                       11 5 0 6   0 0     0   0   7 4                 11
847834 CO     school 804410 3120   GREELEY 6 80441001614 1875 FRONTIER CHARTER ACADEMY   Regular School Yes 4.0 KG 12 2016   grade_7 97 1 27   0 2     0   0   58 69                       127 97 1 27   0 2     0   0   58 69                 127
847820 CO     school 804410 3120   GREELEY 6 80441000637 1500 CHAPPELOW K-8 MAGNET SCHOOL   Regular School No 1.0 PK 08 2016   grade_7 49 1 47   0 0     0   4   47 54                       101 49 1 47   0 0     0   4   47 54                 101
847804 CO     school   3120   GREELEY 6   988 BRENTWOOD MIDDLE SCHOOL             2016   grade_7 36 0 76   0 0     0   3   67 48                       115 36 0 76   0 0     0   3   67 48                 115
847799 CO     school   3120   GREELEY 6   54 BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY             2016   grade_7 18 11 95   0 1     0   0   67 58                       125 18 11 95   0 1     0   0   67 58                 125
847788 CO     school   3120   GREELEY 6   53 WINOGRAD K-8 ELEMENTARY SCHOOL             2016   grade_7 37 1 41   0 1     0   3   36 47                       83 37 1 41   0 1     0   3   36 47                 83
847759 CO     school 804830 3110   JOHNSTOWN-MILLIKEN RE-5J 80483000809 5902 MILLIKEN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 156 3 68   1 2     0   0   118 112                       230 156 3 68   1 2     0   0   118 112                 230
847735 CO     school 804830 3110   JOHNSTOWN-MILLIKEN RE-5J 80483002029 4785 KNOWLEDGE QUEST ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_7 28 0 9   0 2     0   1   21 19                       40 28 0 9   0 2     0   1   21 19                 40
847721 CO     school 807350 3100   WINDSOR RE-4 80735001265 9670 WINDSOR MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 165 2 27   1 1     0   3   106 93                       199 165 2 27   1 1     0   3   106 93                 199
847708 CO     school 807350 3100   WINDSOR RE-4 80735006650 9393 WINDSOR CHARTER ACADEMY MIDDLE AND EARLY COLLEGE HIGH SCHOOL   Regular School Yes 4.0 06 10 2016   grade_7 56 0 8   0 2     0   1   29 38                       67 56 0 8   0 2     0   1   29 38                 67
847679 CO     school 807350 3100   WINDSOR RE-4 80735006427 7755 SEVERANCE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 137 0 31   0 0     0   4   78 94                       172 137 0 31   0 0     0   4   78 94                 172
847662 CO     school 804920 3090   WELD COUNTY SCHOOL DISTRICT RE-3J 80492002026 9347 WELD CENTRAL MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 80 0 75   1 1     0   4   78 83                       161 80 0 75   1 1     0   4   78 83                 161
847625 CO     school 804920 3090   WELD COUNTY SCHOOL DISTRICT RE-3J 80492001760 1299 CARDINAL COMMUNITY ACADEMY CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2016   grade_7 12 0 0   0 1     0   0   9 4                       13 12 0 0   0 1     0   0   9 4                 13
847604 CO     school 803600 3085   EATON RE-2 80360000475 2452 EATON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 111 1 31   1 0     0   0   76 68                       144 111 1 31   1 0     0   0   76 68                 144
847587 CO     school 804200 3080   WELD COUNTY RE-1 80420000579 7058 SOUTH VALLEY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 22 2 37   0 0     0   0   29 32                       61 22 2 37   0 0     0   0   29 32                 61
847575 CO     school 804200 3080   WELD COUNTY RE-1 80420000577 4854 NORTH VALLEY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 28 0 41   0 0     0   3   38 34                       72 28 0 41   0 0     0   3   38 34                 72
847554 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_7 10 0 1   0 0     0   0   5 6                       11 10 0 1   0 0     0   0   5 6                 11
847527 CO     school 805340 3060   LONE STAR 101 80534006376 5238 LONE STAR MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 16 0 0   0 0     0   0   6 10                       16 16 0 0   0 0     0   0   6 10                 16
847522 CO     school 805940 3050   OTIS R-3 80594001017 6586 OTIS JUNIOR-SENIOR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 19 1 0   0 0     0   1   8 13                       21 19 1 0   0 0     0   1   8 13                 21
847506 CO     school   3040   ARICKAREE R-2   308 ARICKAREE UNDIVIDED HIGH SCHOOL             2016   grade_7 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
847484 CO     school   3030   AKRON R-1   86 AKRON ELEMENTARY SCHOOL             2016   grade_7 20 0 5   0 0     0   1   15 11                       26 20 0 5   0 0     0   1   15 11                 26
847462 CO     school 807380 3020   WOODLAND PARK RE-2 80738001268 9694 WOODLAND PARK MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 174 3 13   0 0     0   16   100 106                       206 174 3 13   0 0     0   16   100 106                 206
847432 CO     school 803180 3010   CRIPPLE CREEK-VICTOR RE-1 80318000281 2024 CRIPPLE CREEK-VICTOR JUNIOR-SENIOR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 16 0 4   0 0     0   0   11 9                       20 16 0 4   0 0     0   0   11 9                 20
847405 CO     school 806810 3000   SUMMIT RE-1 80681001400 8377 SUMMIT MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 153 1 69   1 1     0   8   142 91                       233 153 1 69   1 1     0   8   142 91                 233
847364 CO     school 806000 2865   REVERE SCHOOL DISTRICT 80600001021 7322 REVERE JUNIOR-SENIOR HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 6 0 0   1 0     0   0   2 5                       7 6 0 0   1 0     0   0   2 5                 7
847349 CO     school 804860 2862   JULESBURG RE-1 80486000813 4492 JULESBURG HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_7 10 0 7   0 0     0   1   8 10                       18 10 0 7   0 0     0   1   8 10                 18
847333 CO     school 804860 2862   JULESBURG RE-1 80486006387 4369 INSIGHT SCHOOL OF COLORADO AT JULESBURG   Alternative Education School No 4.0 06 12 2016   grade_7 35 1 11   1 0     0   1   30 19                       49 35 1 11   1 0     0   1   30 19                 49
847323 CO     school 805880 2840   NORWOOD R-2J 80588001012 6422 NORWOOD PUBLIC SCHOOLS   Regular School No 4.0 PK 12 2016   grade_7 12 0 1   1 0     0   0   5 9                       14 12 0 1   1 0     0   0   5 9                 14
847306 CO     school 806870 2830   TELLURIDE R-1 80687001304 8790 TELLURIDE MIDDLE SCHOOL   Regular School No 2.0 07 08 2016   grade_7 48 1 5   0 1     0   1   29 27                       56 48 1 5   0 1     0   1   29 27                 56
847289 CO     school 806570 2820   SILVERTON 1 80657001985 7902 SILVERTON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 4 0 2   0 0     0   0   3 3                       6 4 0 2   0 0     0   0   3 3                 6
847272 CO     school 802850 2810   CENTER 26 JT 80285000178 1416 SKOGLUND MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 3 0 41   1 0     0   0   24 21                       45 3 0 41   1 0     0   0   24 21                 45
847247 CO     school 805700 2800   MOFFAT 2 80570000974 5958 MOFFAT PREK-12 SCHOOL   Regular School No 4.0 PK 12 2016   grade_7 6 0 1   0 0     0   1   3 5                       8 6 0 1   0 0     0   1   3 5                 8
847233 CO     school 805700 2800   MOFFAT 2 80570001511 2018 CRESTONE CHARTER SCHOOL   Regular School Yes 4.0 KG 12 2016   grade_7 8 0 2   0 0     0   0   3 7                       10 8 0 2   0 0     0   0   3 7                 10
847216 CO     school 806300 2790   MOUNTAIN VALLEY RE 1 80630001561 6144 MOUNTAIN VALLEY MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 9 0 2   0 0     0   0   3 8                       11 9 0 2   0 0     0   0   3 8                 11
847190 CO     school 805910 2780   SOUTH ROUTT RE 3 80591001013 8048 SOROCO MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 22 0 0   0 0     0   0   15 7                       22 22 0 0   0 0     0   0   15 7                 22
847167 CO     school 806660 2770   STEAMBOAT SPRINGS RE-2 80666001146 8210 STEAMBOAT SPRINGS MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 182 0 22   0 4     2   4   106 108                       214 182 0 22   0 4     2   4   106 108                 214
847155 CO     school 806660 2770   STEAMBOAT SPRINGS RE-2 80666001749 6363 NORTH ROUTT CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2016   grade_7 7 0 0   0 0     0   0   4 3                       7 7 0 0   0 0     0   0   4 3                 7
847139 CO     school 804590 2760   HAYDEN RE-1 80459000676 3860 HAYDEN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 28 1 6   0 1     0   0   23 13                       36 28 1 6   0 1     0   0   23 13                 36
847126 CO     school 806450 2750   SARGENT RE-33J 80645002015 7668 SARGENT JUNIOR HIGH SCHOOL   Regular School No 2.0 07 08 2016   grade_7 24 0 14   2 0     0   2   29 13                       42 24 0 14   2 0     0   2   29 13                 42
847109 CO     school 805760 2740   MONTE VISTA C-8 80576001560 6520 MONTE VISTA ON-LINE ACADEMY   Alternative Education School No 4.0 04 12 2016   grade_7 6 0 1   0 0     0   0   3 4                       7 6 0 1   0 0     0   0   3 4                 7
847095 CO     school 805760 2740   MONTE VISTA C-8 80576000986 6044 MONTE VISTA MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 11 0 68   3 0     0   1   49 34                       83 11 0 68   3 0     0   1   49 34                 83
847066 CO     school 803300 2730   DEL NORTE C-7 80330000289 2148 DEL NORTE MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_7 11 0 17   0 0     0   0   12 16                       28 11 0 17   0 0     0   0   12 16                 28
847060 CO     school 806180 2720   RANGELY RE-4 80618001088 7276 RANGELY JUNIOR/SENIOR HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_7 32 0 4   0 0     1   0   20 17                       37 32 0 4   0 0     1   0   20 17                 37
847040 CO     school 805610 2710   MEEKER RE1 80561000966 5754 BARONE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 37 0 7   0 0     0   0   25 19                       44 37 0 7   0 0     0   0   25 19                 44
847028 CO     school 806150 2700   PUEBLO COUNTY 70 80615001085 9134 VINELAND MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 55 1 47   0 0     0   5   47 61                       108 55 1 47   0 0     0   5   47 61                 108
847016 CO     school 806150 2700   PUEBLO COUNTY 70 80615000632 8810 THE CONNECT CHARTER SCHOOL   Regular School Yes 2.0 06 08 2016   grade_7 57 0 24   0 3     0   2   29 57                       86 57 0 24   0 3     0   2   29 57                 86
847011 CO     school 806150 2700   PUEBLO COUNTY 70 80615001559 8420 SWALLOWS CHARTER ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_7 34 0 10   1 1     0   2   19 29                       48 34 0 10   1 1     0   2   19 29                 48
846976 CO     school 806150 2700   PUEBLO COUNTY 70 80615001074 7532 CRAVER MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 32 0 16   0 0     0   6   26 28                       54 32 0 16   0 0     0   6   26 28                 54
846959 CO     school 806150 2700   PUEBLO COUNTY 70 80615001357 7212 LIBERTY POINT INTERNATIONAL SCHOOL   Regular School No 2.0 06 08 2016   grade_7 93 2 56   2 1     0   6   93 67                       160 93 2 56   2 1     0   6   93 67                 160
846934 CO     school 806150 2700   PUEBLO COUNTY 70 80615001078 7086 PLEASANT VIEW MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 60 0 72   1 0     0   7   65 75                       140 60 0 72   1 0     0   7   65 75                 140
846921 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Regular School No 4.0 KG 12 2016   grade_7 5 0 2   0 0     0   0   3 4                       7 5 0 2   0 0     0   0   3 4                 7
846904 CO     school   2700   PUEBLO COUNTY 70   856 BEULAH MIDDLE SCHOOL             2016   grade_7 12 0 3   0 0     0   0   5 10                       15 12 0 3   0 0     0   0   5 10                 15
846877 CO     school   2700   PUEBLO COUNTY 70   25 SKY VIEW MIDDLE SCHOOL             2016   grade_7 125 2 78   1 1     0   16   104 119                       223 125 2 78   1 1     0   16   104 119                 223
846873 CO     school 806120 2690   PUEBLO CITY 60 80612001067 9188 W H HEATON MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 47 6 188   3 2     0   1   119 128                       247 47 6 188   3 2     0   1   119 128                 247
846840 CO     school 806120 2690   PUEBLO CITY 60 80612001061 7481 RONCALLI STEM ACADEMY   Regular School No 2.0 06 08 2016   grade_7 27 2 113   1 0     0   2   75 70                       145 27 2 113   1 0     0   2   75 70                 145

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