Data source: Big Local News · About: Big Local

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

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
710051 CO     school 806090 240   PRITCHETT RE-3 80609001952 7176 PRITCHETT MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
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
715075 CO     school 802790 1140   CANON CITY RE-1 80279006536 419 CANON ONLINE ACADEMY   Regular School No Other 06 12 2017   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
717069 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
718935 CO     school 804710 2620   HOLYOKE RE-1J 80471006610 2686 HOLYOKE ALTERNATIVE SCHOOL   Alternative School No High 07 12 2017   grade_7 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
720548 CO     school 804440 3148   PAWNEE RE-12 80444000653 6812 PAWNEE SCHOOL PK-12   Regular School No Other PK 12 2017   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
837136 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2016   grade_7 0 1 0   0 0     0   0   0 1                       1 0 1 0   0 0     0   0   0 1                 1
837725 CO     school 806990 260   VILAS RE-5 80699001805 9085 V.I.L.A.S. ONLINE SCHOOL   Regular School No 1.0 KG 08 2016   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
838739 CO     school 805100 550   NORTH CONEJOS RE-1J 80510006601 6339 NORTH CONEJOS ALTERNATIVE PROGRAM   Alternative Education School No 4.0 KG 12 2016   grade_7 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
841162 CO     school 803540 910   EAGLE COUNTY RE 50 80354006533 9701 WORLD ACADEMY   Regular School No 4.0 KG 12 2016   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
844651 CO     school   1550   POUDRE R-1   0 Not a school             2016   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
845477 CO     school 804890 1810   KARVAL RE-23 80489000815 4506 KARVAL JUNIOR-SENIOR HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
845974 CO     school 805730 2020   MOFFAT COUNTY RE:NO 1 80573000981 5962 MOFFAT COUNTY HIGH SCHOOL   Regular School No 3.0 09 12 2016   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
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
1739974 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_7 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1740631 CO     school 802760 270   Campo RE-6 80276000170 1252 Campo Undivided High School   Regular School No High 06 12 2021   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1745263 CO     school 806060 1060   Peyton 23 Jt 80606006692 6626 Peyton Online Academy   Regular School No Other KG 12 2021   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1746623 CO     school 804800 1420   Jefferson County R-1 80480006306 4798 Connections Learning Center on the Earle Johnson Campus   Alternative School No Middle 06 08 2021   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1746789 CO     school 804800 1420   Jefferson County R-1 80480001607 5994 Montessori Peaks Charter Academy   Regular School Yes Elementary PK 08 2021   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1747833 CO     school 803990 1550   Poudre R-1 80399006564 7043 PSD Options School   Regular School No Elementary KG 08 2021   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1748315 CO     school 804980 1760   Kim Reorganized 88 80498000823 4694 Kim Undivided High School   Regular School No High 06 12 2021   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1802766 CO     school 803330 870   Delta County 50(J) 80333001953 2155 Grand Mesa Choice Academy   Alternative School No High 07 12 2020   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1806393 CO     school 804500 1070   Hanover 28 80450006720 3941 Hanover Online Academy   Regular School No High 06 12 2020   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1807885 CO     school 804800 1420   Jefferson County R-1 80480001607 5994 Montessori Peaks Charter Academy   Regular School Yes Elementary PK 08 2020   grade_7 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
1812189 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2020   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1897224 CO     school 803360 880   DENVER COUNTY 1 80336001724 40 RIDGE VIEW ACADEMY CHARTER SCHOOL   Alternative School Yes High 07 12 2018   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1899837 CO     school 804080 1000   FOUNTAIN 8 80408000096 203 WELTE EDUCATION CENTER   Alternative School No High 06 12 2018   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1903681 CO     school 803810 1570   ESTES PARK R-3 80381006426 2788 ESTES PARK OPTIONS SCHOOL   Alternative School No Other KG 12 2018   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1903856 CO     school   1828   VALLEY RE-1   6 COUNTY JAILS WITH DISTRICT RUN EDUCATION             2018   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1904110 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000611 3350 GATEWAY SCHOOL   Regular School No Other PK 12 2018   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
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
1135451 CO     school 802760 270   CAMPO RE-6 80276000170 1252 CAMPO UNDIVIDED HIGH SCHOOL   Regular School No 4.0 06 12 2015   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0                       1.0 1 0 0   0 0     0   0   0 1                 1
1140276 CO     school 802790 1140   CANON CITY RE-1 80279006536 419 CANON ONLINE ACADEMY   Regular School No 4.0 06 12 2015   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   1.0 0.0                       1.0 1 0 0   0 0     0   0   1 0                 1
1143785 CO     school 805850 2190   WEST END RE-2 80585001693 6718 PARADOX VALLEY CHARTER SCHOOL   Regular School Yes 4.0 PK 12 2015   grade_7 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0                       1.0 0 1 0   0 0     0   0   0 1                 1
1144066 CO     school 804710 2620   HOLYOKE RE-1J 80471006610 2686 HOLYOKE ALTERNATIVE SCHOOL   Alternative Education School No 3.0 07 12 2015   grade_7 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0                       1.0 1 0 0   0 0     0   0   0 1                 1
718370 CO     school 803150 2010   CREEDE SCHOOL DISTRICT 80315000279 1966 CREEDE SCHOOL   Regular School No Other PK 12 2017   grade_7 7 0 2   0 0     0   1   4 6                       10 7 0 2   0 0     0   1   4 6                 10
718790 CO     school 805520 2535   MANZANOLA 3J 80552001375 5506 MANZANOLA JUNIOR-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 2 0 8   0 0     0   0   5 5                       10 2 0 8   0 0     0   0   5 5                 10
719664 CO     school 805700 2800   MOFFAT 2 80570001511 2018 CRESTONE CHARTER SCHOOL   Regular School Yes Other KG 12 2017   grade_7 9 0 0   0 0     0   1   5 5                       10 9 0 0   0 0     0   1   5 5                 10
844951 CO     school 803990 1550   POUDRE R-1 80399006431 7198 PSD GLOBAL ACADEMY   Regular School No 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
845388 CO     school   1620   AGUILAR REORGANIZED 6   66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL             2016   grade_7 1 0 9   0 0     0   0   5 5                       10 1 0 9   0 0     0   0   5 5                 10
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
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
1747317 CO     school 803510 1430   Eads RE-1 80351001277 2332 Eads Middle School   Regular School No Middle 06 08 2021   grade_7 8 0 1   0 0     0   1   6 4                       10 8 0 1   0 0     0   1   6 4                 10
1747396 CO     school 802460 1490   Bethune R-5 80246000095 842 Bethune Public Schools   Regular School No Other PK 12 2021   grade_7 4 0 6   0 0     0   0   3 7                       10 4 0 6   0 0     0   0   3 7                 10
1748070 CO     school 805400 1560   Thompson R2-J 80540006558 5121 LEAP School   Regular School No Other KG 12 2021   grade_7 9 0 1   0 0     0   0   4 6                       10 9 0 1   0 0     0   0   4 6                 10
1750032 CO     school 806660 2770   Steamboat Springs RE-2 80666001749 6363 North Routt Charter School   Regular School Yes Elementary PK 08 2021   grade_7 9 0 1   0 0     0   0   3 7                       10 9 0 1   0 0     0   0   3 7                 10
1751482 CO     school 899300 9050   San Juan BOCES 89930006497 8121 Southwest Colorado eSchool   Regular School No High 06 12 2021   grade_7 9 1 0   0 0     0   0   5 5                       10 9 1 0   0 0     0   0   5 5                 10
1801646 CO     school 806990 260   Vilas RE-5 80699001207 9100 Vilas Undivided High School   Regular School No High 07 12 2020   grade_7 9 0 1   0 0     0   0   8 2                       10 9 0 1   0 0     0   0   8 2                 10
1804234 CO     school 803420 890   Dolores County RE No.2 80342000429 2216 Dove Creek High School   Regular School No High 06 12 2020   grade_7 8 0 2   0 0     0   0   4 6                       10 8 0 2   0 0     0   0   4 6                 10
1807157 CO     school 807080 1390   Huerfano Re-1 80708001211 3306 Gardner Elementary School   Regular School No Elementary PK 08 2020   grade_7 2 1 7   0 0     0   0   3 7                       10 2 1 7   0 0     0   0   3 7                 10
1807669 CO     school 804800 1420   Jefferson County R-1 80480006439 4408 Jeffco Virtual Academy   Alternative School No High 06 12 2020   grade_7 7 0 1   0 0     0   2   5 5                       10 7 0 1   0 0     0   2   5 5                 10
1808432 CO     school 803510 1430   Eads RE-1 80351001277 2332 Eads Middle School   Regular School No Middle 06 08 2020   grade_7 9 0 1   0 0     0   0   5 5                       10 9 0 1   0 0     0   0   5 5                 10
1808585 CO     school 803480 1520   Durango 9-R 80348006614 2097 District 9-R Shared School   Regular School No Other KG 12 2020   grade_7 8 0 2   0 0     0   0   6 4                       10 8 0 2   0 0     0   0   6 4                 10
1811248 CO     school 805700 2800   Moffat 2 80570000974 5958 Moffat Prek-12 School   Regular School No Other PK 12 2020   grade_7 9 0 0   0 0     0   1   6 4                       10 9 0 0   0 0     0   1   6 4                 10
1811289 CO     school 806570 2820   Silverton 1 80657001985 7902 Silverton Middle School   Regular School No Middle 06 08 2020   grade_7 5 0 5   0 0     0   0   6 4                       10 5 0 5   0 0     0   0   6 4                 10
1811508 CO     school 802220 3040   Arickaree R-2 80222000042 308 Arickaree Undivided High School   Regular School No High 06 12 2020   grade_7 7 1 2   0 0     0   0   2 8                       10 7 1 2   0 0     0   0   2 8                 10
1897549 CO     school 803360 880   DENVER COUNTY 1 80336006516 2188 DENVER CENTER FOR 21ST LEARNING AT WYMAN   Alternative School No High 06 12 2018   grade_7 3 0 7   0 0     0   0   4 6                       10 3 0 7   0 0     0   0   4 6                 10
1900968 CO     school 803630 1120   EDISON 54 JT 80363001278 2526 EDISON JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 06 12 2018   grade_7 10 0 0   0 0     0   0   6 4                       10 10 0 0   0 0     0   0   6 4                 10
1902901 CO     school 803480 1520   DURANGO 9-R 80348006614 2097 DISTRICT 9-R SHARED SCHOOL   Regular School No Other KG 12 2018   grade_7 9 0 0   0 0     0   1   4 6                       10 9 0 0   0 0     0   1   4 6                 10
1903761 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000023 66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 07 12 2018   grade_7 3 0 7   0 0     0   0   7 3                       10 3 0 7   0 0     0   0   7 3                 10
1904799 CO     school 805970 2580   OURAY R-1 80597001662 6598 OURAY MIDDLE SCHOOL   Regular School No Middle 07 08 2018   grade_7 8 0 1   0 1     0   0   2 8                       10 8 0 1   0 1     0   0   2 8                 10
1905540 CO     school 806660 2770   STEAMBOAT SPRINGS RE-2 80666001749 6363 NORTH ROUTT CHARTER SCHOOL   Regular School Yes Elementary KG 08 2018   grade_7 9 0 1   0 0     0   0   6 4                       10 9 0 1   0 0     0   0   6 4                 10
1905902 CO     school 805340 3060   LONE STAR 101 80534006376 5238 LONE STAR MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 9 0 1   0 0     0   0   5 5                       10 9 0 1   0 0     0   0   5 5                 10
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
1136550 CO     school 803330 870   DELTA COUNTY 50(J) 80333002001 2152 DELTA ACADEMY OF APPLIED LEARNING   Alternative Education School No 2.0 05 08 2015   grade_7 8.0 0.0 2.0   0.0 0.0     0.0   0.0   6.0 4.0                       10.0 8 0 2   0 0     0   0   6 4                 10
1146020 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001612 9785 YOUTH & FAMILY ACADEMY CHARTER   Alternative Education School Yes 3.0 07 12 2015   grade_7 1.0 0.0 9.0   0.0 0.0     0.0   0.0   5.0 5.0                       10.0 1 0 9   0 0     0   0   5 5                 10
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
717042 CO     school 802400 1530   BAYFIELD 10 JT-R 80240000089 636 BAYFIELD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 77 0 15   2 0     0   6   52 48                       100 77 0 15   2 0     0   6   52 48                 100
837537 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006483 9083 VISTA PEAK P-8 EXPLORATORY   Regular School No 1.0 PK 08 2016   grade_7 38 5 46   1 2     1   7   50 50                       100 38 5 46   1 2     1   7   50 50                 100
1740226 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2021   grade_7 13 42 42   0 1     0   2   54 46                       100 13 42 42   0 1     0   2   54 46                 100
1740824 CO     school 805370 470   St Vrain Valley RE1J 80537001890 2964 Flagstaff Charter Academy   Regular School Yes Elementary PK 08 2021   grade_7 80 2 11   1 4     1   1   47 53                       100 80 2 11   1 4     1   1   47 53                 100
1742195 CO     school 803360 880   Denver County 1 80336006528 2209 DCIS at Montbello   Regular School No High 06 12 2021   grade_7 2 13 77   0 0     6   2   57 43                       100 2 13 77   0 0     6   2   57 43                 100
1743994 CO     school 803540 910   Eagle County RE 50 80354001478 5742 Homestake Peak School   Regular School No Elementary PK 08 2021   grade_7 30 0 67   1 0     0   2   46 54                       100 30 0 67   1 0     0   2   46 54                 100
1802614 CO     school 805100 550   North Conejos RE-1J 80510000842 1276 Centauri Middle School   Regular School No Middle 06 08 2020   grade_7 49 0 50   0 1     0   0   50 50                       100 49 0 50   0 1     0   0   50 50                 100
1895626 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2018   grade_7 19 31 45   0 3     1   1   49 51                       100 19 31 45   0 3     1   1   49 51                 100
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
1140352 CO     school 803960 1150   FREMONT RE-2 80396001595 3226 FREMONT MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 75.0 2.0 18.0   0.0 1.0     0.0   4.0   50.0 50.0                       100.0 75 2 18   0 1     0   4   50 50                 100
1144601 CO     school 806150 2700   PUEBLO COUNTY 70 80615001085 9134 VINELAND MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 55.0 1.0 39.0   0.0 1.0     1.0   3.0   51.0 49.0                       100.0 55 1 39   0 1     1   3   51 49                 100
708875 CO     school 806540 123   SHERIDAN 2 80654001135 7837 FORT LOGAN NORTHGATE   Regular School No Elementary 03 08 2017   grade_7 12 2 83   0 2     1   1   48 53                       101 12 2 83   0 2     1   1   48 53                 101
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
836521 CO     school 806540 123   SHERIDAN 2 80654001135 7837 FORT LOGAN NORTHGATE   Regular School No 1.0 03 08 2016   grade_7 14 5 76   2 2     0   2   56 45                       101 14 5 76   2 2     0   2   56 45                 101
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
1743704 CO     school 803450 900   Douglas County Re 1 80345006690 6719 Parker Performing Arts   Regular School Yes Elementary KG 08 2021   grade_7 68 4 17   2 2     0   8   29 72                       101 68 4 17   2 2     0   8   29 72                 101
1744166 CO     school 804530 980   Harrison 2 80453000662 1306 Carmel Middle School   Regular School No Middle 06 08 2021   grade_7 14 21 54   0 3     0   9   53 48                       101 14 21 54   0 3     0   9   53 48                 101
1745800 CO     school 804260 1180   Roaring Fork RE-1 80426000586 1296 Carbondale Middle School   Regular School No Middle 05 08 2021   grade_7 40 2 57   0 0     0   2   55 46                       101 40 2 57   0 0     0   2   55 46                 101
1750820 CO     school 804410 3120   Greeley 6 80441001483 5660 S. Christa McAuliffe STEM Academy   Regular School No Elementary KG 08 2021   grade_7 35 0 59   0 4     0   3   56 45                       101 35 0 59   0 4     0   3   56 45                 101
1801205 CO     school 802340 180   Adams-Arapahoe 28J 80234006318 3471 Global Village Academy Aurora   Regular School Yes Elementary KG 08 2020   grade_7 14 18 63   0 1     0   5   55 46                       101 14 18 63   0 1     0   5   55 46                 101
1804154 CO     school 803360 880   Denver County 1 80336006479 9390 STRIVE Prep - Lake   Regular School Yes Middle 06 08 2020   grade_7 2 4 92   1 2     0   0   50 51                       101 2 4 92   1 2     0   0   50 51                 101

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