Data source: Big Local News · About: Big Local

92,494 rows where state = "CO" sorted by total

View and edit SQL

grade

year

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
836016 CO     school   30   ADAMS COUNTY 14   22 LESTER R ARNOLD HIGH SCHOOL             2016   grade_9 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
836105 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000729 1021 BRIGHTON HERITAGE ACADEMY   Alternative Education School No 4.0 06 12 2016   grade_8 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
836179 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000148 6294 NORTH ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
836587 CO     school   130   CHERRY CREEK 5   714 BELLEVIEW ELEMENTARY SCHOOL             2016   kindergarten_full_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
836704 CO     school 802910 130   CHERRY CREEK 5 80291000191 2428 EASTRIDGE COMMUNITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
836746 CO     school 802910 130   CHERRY CREEK 5 80291006182 3988 HIGHLINE COMMUNITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 0 0 0   0 0     0   1   0 1                       1 0 0 0   0 0     0   1   0 1                 1
836863 CO     school 802910 130   CHERRY CREEK 5 80291000199 7102 POLTON COMMUNITY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_full_day 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
836893 CO     school 802910 130   CHERRY CREEK 5 80291001514 7476 ROLLING HILLS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   pre_kindergarten 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
837130 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2016   grade_10 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
837132 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2016   grade_2 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 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
837627 CO     school 802700 190   BYERS 32J 80270006548 3362 GREAT PLAINS ACADEMY   Regular School No 4.0 KG 12 2016   grade_1 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
837689 CO     school 806090 240   PRITCHETT RE-3 80609001026 7174 PRITCHETT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_4 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
837721 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_3 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
837724 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_6 0 0 1   0 0     0   0   0 1                       1 0 0 1   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
837733 CO     school 806990 260   VILAS RE-5 80699001206 9090 VILAS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_6 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
837734 CO     school 806990 260   VILAS RE-5 80699001206 9090 VILAS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   kindergarten_full_day 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
837736 CO     school 806990 260   VILAS RE-5 80699001206 9090 VILAS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   pre_kindergarten 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
837739 CO     school 806990 260   VILAS RE-5 80699001207 9100 VILAS UNDIVIDED HIGH SCHOOL   Regular School No 3.0 07 12 2016   grade_12 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
837744 CO     school 802760 270   CAMPO RE-6 80276000169 1248 CAMPO ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_1 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
837752 CO     school 802760 270   CAMPO RE-6 80276000170 1252 CAMPO UNDIVIDED HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_11 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
837757 CO     school 802760 270   CAMPO RE-6 80276000170 1252 CAMPO UNDIVIDED HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_9 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
838081 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No 1.0 PK 04 2016   kindergarten_half_day 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
838202 CO     school   480   BOULDER VALLEY RE 2   441 ASPEN CREEK K-8 SCHOOL             2016   kindergarten_full_day 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
838219 CO     school   480   BOULDER VALLEY RE 2   866 BOULDER EXPLORE             2016   grade_8 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
838235 CO     school   480   BOULDER VALLEY RE 2   919 BOULDER COMMUNITY SCHOOL/INTEGRATED STUDIES             2016   kindergarten_full_day 0 1 0   0 0     0   0   0 1                       1 0 1 0   0 0     0   0   0 1                 1
838247 CO     school   480   BOULDER VALLEY RE 2   930 BOULDER UNIVERSAL             2016   grade_5 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
838248 CO     school   480   BOULDER VALLEY RE 2   930 BOULDER UNIVERSAL             2016   grade_6 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
838289 CO     school 802490 480   BOULDER VALLEY RE 2 80249001376 1725 COAL CREEK ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   kindergarten_full_day 0 0 0   0 0     1   0   0 1                       1 0 0 0   0 0     1   0   0 1                 1
838305 CO     school 802490 480   BOULDER VALLEY RE 2 80249001227 1883 COMMUNITY MONTESSORI SCHOOL   Regular School No 1.0 PK 06 2016   kindergarten_full_day 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
838359 CO     school 802490 480   BOULDER VALLEY RE 2 80249006154 2940 FIRESIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_full_day 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
838368 CO     school 802490 480   BOULDER VALLEY RE 2 80249000115 2970 FLATIRONS ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   kindergarten_full_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
838379 CO     school 802490 480   BOULDER VALLEY RE 2 80249000117 3488 GOLD HILL ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
838387 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No 4.0 06 12 2016   grade_12 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
838388 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No 4.0 06 12 2016   grade_6 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
838398 CO     school 802490 480   BOULDER VALLEY RE 2 80249000118 3882 HEATHERWOOD ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_full_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
838411 CO     school 802490 480   BOULDER VALLEY RE 2 80249000119 4386 JAMESTOWN ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
838414 CO     school 802490 480   BOULDER VALLEY RE 2 80249000119 4386 JAMESTOWN ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_5 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
838484 CO     school 802490 480   BOULDER VALLEY RE 2 80249001573 6000 MONARCH K-8 SCHOOL   Regular School No 1.0 PK 08 2016   kindergarten_full_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
838498 CO     school 802490 480   BOULDER VALLEY RE 2 80249000130 6208 NEDERLAND ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_full_day 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
838736 CO     school 805100 550   NORTH CONEJOS RE-1J 80510006601 6339 NORTH CONEJOS ALTERNATIVE PROGRAM   Alternative Education School No 4.0 KG 12 2016   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
838737 CO     school 805100 550   NORTH CONEJOS RE-1J 80510006601 6339 NORTH CONEJOS ALTERNATIVE PROGRAM   Alternative Education School No 4.0 KG 12 2016   grade_4 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
838742 CO     school 805100 550   NORTH CONEJOS RE-1J 80510006601 6339 NORTH CONEJOS ALTERNATIVE PROGRAM   Alternative Education School No 4.0 KG 12 2016   kindergarten_full_day 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
839002 CO     school   880   DENVER COUNTY 1   418 ASHLEY ELEMENTARY SCHOOL             2016   kindergarten_half_day 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
839319 CO     school 803360 880   DENVER COUNTY 1 80336000336 2258 DOULL ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
839357 CO     school 803360 880   DENVER COUNTY 1 80336000341 2652 ELLIS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
839529 CO     school 803360 880   DENVER COUNTY 1 80336000362 3778 HARRINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 0 1 0   0 0     0   0   1 0                       1 0 1 0   0 0     0   0   1 0                 1
839576 CO     school 803360 880   DENVER COUNTY 1 80336001928 4140 FARRELL B. HOWELL ECE-8 SCHOOL   Regular School No 1.0 PK 08 2016   kindergarten_half_day 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
839623 CO     school 803360 880   DENVER COUNTY 1 80336000369 4498 KAISER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
839714 CO     school 803360 880   DENVER COUNTY 1 80336001380 5578 MARRAMA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 0 0 0   0 1     0   0   1 0                       1 0 0 0   0 1     0   0   1 0                 1
839769 CO     school 803360 880   DENVER COUNTY 1 80336000378 5716 MC MEEN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
839833 CO     school 803360 880   DENVER COUNTY 1 80336000388 6254 NEWLON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
839839 CO     school 803360 880   DENVER COUNTY 1 80336006569 6308 NORTH HIGH SCHOOL ENGAGEMENT CENTER   Alternative Education School No 3.0 09 12 2016   grade_9 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
839896 CO     school 803360 880   DENVER COUNTY 1 80336000390 6676 PALMER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 0 1 0   0 0     0   0   1 0                       1 0 1 0   0 0     0   0   1 0                 1
840094 CO     school 803360 880   DENVER COUNTY 1 80336000410 8222 STECK ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
840111 CO     school 803360 880   DENVER COUNTY 1 80336000412 8242 STEELE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
840135 CO     school 803360 880   DENVER COUNTY 1 80336006518 8453 SWIGERT INTERNATIONAL SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
840250 CO     school 803360 880   DENVER COUNTY 1 80336006332 9623 WILLIAM (BILL) ROBERTS K-8 SCHOOL   Regular School No 1.0 PK 08 2016   kindergarten_half_day 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
840296 CO     school   890   DOLORES COUNTY RE NO.2   50 RICO ELEMENTARY SCHOOL             2016   grade_6 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
840454 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006494 1555 CLOVERLEAF HOME EDUCATION   Alternative Education School No 4.0 KG 12 2016   grade_10 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
840725 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006372 5405 EDCSD: COLORADO CYBER SCHOOL   Regular School No 4.0 KG 12 2016   grade_1 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
840732 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006372 5405 EDCSD: COLORADO CYBER SCHOOL   Regular School No 4.0 KG 12 2016   grade_5 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
841042 CO     school   910   EAGLE COUNTY RE 50   38 BRUSH CREEK ELEMENTARY SCHOOL             2016   kindergarten_half_day 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
841060 CO     school   910   EAGLE COUNTY RE 50   471 AVON ELEMENTARY SCHOOL             2016   kindergarten_half_day 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
841088 CO     school 803540 910   EAGLE COUNTY RE 50 80354000462 2346 EAGLE VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
841153 CO     school 803540 910   EAGLE COUNTY RE 50 80354006533 9701 WORLD ACADEMY   Regular School No 4.0 KG 12 2016   grade_1 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
841157 CO     school 803540 910   EAGLE COUNTY RE 50 80354006533 9701 WORLD ACADEMY   Regular School No 4.0 KG 12 2016   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
841158 CO     school 803540 910   EAGLE COUNTY RE 50 80354006533 9701 WORLD ACADEMY   Regular School No 4.0 KG 12 2016   grade_3 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
841160 CO     school 803540 910   EAGLE COUNTY RE 50 80354006533 9701 WORLD ACADEMY   Regular School No 4.0 KG 12 2016   grade_5 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 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
841258 CO     school   960   AGATE 300   44 AGATE ELEMENTARY SCHOOL             2016   grade_3 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
841324 CO     school 804530 980   HARRISON 2 80453006535 3870 HIGH SCHOOL PREPARATORY ACADEMY   Regular School No 3.0 08 12 2016   grade_9 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
841458 CO     school 806480 990   WIDEFIELD 3 80648001119 4346 TALBOTT ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
841490 CO     school 806480 990   WIDEFIELD 3 80648001123 6952 PINELLO ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   kindergarten_half_day 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
841660 CO     school 803060 1010   COLORADO SPRINGS 11 80306000225 1126 BUENA VISTA ELEMENTARY SCHOOL   Regular School No 1.0 PK 08 2016   grade_6 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
841824 CO     school 803060 1010   COLORADO SPRINGS 11 80306001841 5146 LIFE SKILLS CENTER OF COLORADO SPRINGS   Alternative Education School Yes 3.0 09 12 2016   grade_9 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
841832 CO     school 803060 1010   COLORADO SPRINGS 11 80306000251 5404 MADISON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
841857 CO     school 803060 1010   COLORADO SPRINGS 11 80306001470 5610 MARTINEZ ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
841866 CO     school 803060 1010   COLORADO SPRINGS 11 80306000253 5878 MIDLAND ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   kindergarten_half_day 0 1 0   0 0     0   0   0 1                       1 0 1 0   0 0     0   0   0 1                 1
842630 CO     school 803630 1120   EDISON 54 JT 80363001901 2504 EDISON ACADEMY   Regular School No 4.0 06 12 2016   grade_12 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
842631 CO     school 803630 1120   EDISON 54 JT 80363001901 2504 EDISON ACADEMY   Regular School No 4.0 06 12 2016   pk_12_total 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
842672 CO     school   1140   CANON CITY RE-1   419 CANON ONLINE ACADEMY             2016   grade_8 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
842805 CO     school 804260 1180   ROARING FORK RE-1 80426001596 1006 BRIDGES   Alternative Education School No 3.0 09 12 2016   grade_9 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
842989 CO     school 804320 1350   EAST GRAND 2 80432001780 4277 INDIAN PEAKS CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2016   grade_1 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
842992 CO     school 804320 1350   EAST GRAND 2 80432001780 4277 INDIAN PEAKS CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2016   grade_4 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
843118 CO     school 807050 1410   NORTH PARK R-1 80705001209 6358 NORTH PARK SCHOOL   Regular School No 4.0 PK 12 2016   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
843121 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2016   grade_11 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
843612 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006633 4411 JEFFCO'S 21ST CENTURY VIRTUAL ACADEMY K-6   Regular School No 1.0 KG 06 2016   grade_4 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
843752 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001606 5415 ROCKY MOUNTAIN DEAF SCHOOL   Special Education School Yes 4.0 PK 12 2016   grade_3 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
844007 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000777 7238 RALSTON ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
844122 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006307 8036 SOBESKY ACADEMY   Special Education School No 4.0 KG 12 2016   grade_4 0 0 1   0 0     0   0   1 0                       1 0 0 1   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
845300 CO     school 803810 1570   ESTES PARK R-3 80381006426 2788 ESTES PARK OPTIONS SCHOOL   Alternative Education School No 4.0 KG 12 2016   grade_11 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
845301 CO     school 803810 1570   ESTES PARK R-3 80381006426 2788 ESTES PARK OPTIONS SCHOOL   Alternative Education School No 4.0 KG 12 2016   grade_12 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
845418 CO     school   1750   BRANSON REORGANIZED 82   978 BRANSON SCHOOL             2016   kindergarten_full_day 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
845420 CO     school   1750   BRANSON REORGANIZED 82   978 BRANSON SCHOOL             2016   pre_kindergarten 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
845431 CO     school 804980 1760   KIM REORGANIZED 88 80498000823 4694 KIM UNDIVIDED HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_12 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

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