Data source: Big Local News · About: Big Local

13,207 rows where state = "CO" and year = 2017 sorted by hispanic_int

View and edit SQL

year

  • 2017 · 13,107
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
710743 CO     school 802490 480   BOULDER VALLEY RE 2 80249000117 3488 GOLD HILL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 6 0 0   0 0     0   0   3 3                       6 6 0 0   0 0     0   0   3 3                 6
710744 CO     school 802490 480   BOULDER VALLEY RE 2 80249000117 3488 GOLD HILL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_5 3 0 0   0 0     0   0   3 0                       3 3 0 0   0 0     0   0   3 0                 3
710745 CO     school 802490 480   BOULDER VALLEY RE 2 80249000117 3488 GOLD HILL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_half_day 8 0 0   0 0     0   0   5 3                       8 8 0 0   0 0     0   0   5 3                 8
710746 CO     school 802490 480   BOULDER VALLEY RE 2 80249000117 3488 GOLD HILL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   pk_12_total 26 0 0   0 0     0   0   16 10                       26 26 0 0   0 0     0   0   16 10                 26
710748 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No Other 06 12 2017   grade_11 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
710749 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No Other 06 12 2017   grade_12 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
710752 CO     school 802490 480   BOULDER VALLEY RE 2 80249001467 3499 HALCYON SCHOOL (SPECIAL EDUCATION)   Special Education School No Other 06 12 2017   grade_9 5 0 0   0 0     0   0   3 2                       5 5 0 0   0 0     0   0   3 2                 5
710770 CO     school 802490 480   BOULDER VALLEY RE 2 80249000119 4386 JAMESTOWN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 5 0 0   0 0     0   0   3 2                       5 5 0 0   0 0     0   0   3 2                 5
710771 CO     school 802490 480   BOULDER VALLEY RE 2 80249000119 4386 JAMESTOWN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
710772 CO     school 802490 480   BOULDER VALLEY RE 2 80249000119 4386 JAMESTOWN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_3 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
710773 CO     school 802490 480   BOULDER VALLEY RE 2 80249000119 4386 JAMESTOWN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 4 0 0   0 0     0   0   3 1                       4 4 0 0   0 0     0   0   3 1                 4
710774 CO     school 802490 480   BOULDER VALLEY RE 2 80249000119 4386 JAMESTOWN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_5 5 0 0   0 0     0   0   3 2                       5 5 0 0   0 0     0   0   3 2                 5
710775 CO     school 802490 480   BOULDER VALLEY RE 2 80249000119 4386 JAMESTOWN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_half_day 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
710776 CO     school 802490 480   BOULDER VALLEY RE 2 80249000119 4386 JAMESTOWN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   pk_12_total 19 0 0   0 0     0   0   11 8                       19 19 0 0   0 0     0   0   11 8                 19
710782 CO     school 802490 480   BOULDER VALLEY RE 2 80249002013 4496 JUSTICE HIGH CHARTER SCHOOL   Alternative School Yes Other 06 12 2017   grade_8 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
710790 CO     school 802490 480   BOULDER VALLEY RE 2 80249000120 4792 KOHL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
710799 CO     school 802490 480   BOULDER VALLEY RE 2 80249000121 4874 LAFAYETTE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
710885 CO     school 802490 480   BOULDER VALLEY RE 2 80249006199 6642 HORIZONS K-8 SCHOOL   Alternative School Yes Elementary KG 08 2017   kindergarten_full_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
710969 CO     school 802640 490   BUENA VISTA R-31 80264006155 1508 CHAFFEE COUNTY HIGH SCHOOL   Alternative School No High 07 12 2017   grade_9 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
710980 CO     school 806330 500   SALIDA R-32 80633006500 1554 CREST ACADEMY   Regular School No Middle 05 08 2017   grade_6 9 0 0   0 0     0   0   7 2                       9 9 0 0   0 0     0   0   7 2                 9
710982 CO     school 806330 500   SALIDA R-32 80633006500 1554 CREST ACADEMY   Regular School No Middle 05 08 2017   grade_8 3 0 0   0 0     0   1   3 1                       4 3 0 0   0 0     0   1   3 1                 4
710984 CO     school 806330 500   SALIDA R-32 80633006413 4085 HORIZONS EXPLORATORY ACADEMY   Alternative School No High 09 12 2017   grade_10 5 0 0   0 0     0   1   3 3                       6 5 0 0   0 0     0   1   3 3                 6
711013 CO     school 805040 510   KIT CARSON R-1 80504000827 4738 KIT CARSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 4 0 0   0 0     0   1   2 3                       5 4 0 0   0 0     0   1   2 3                 5
711016 CO     school 805040 510   KIT CARSON R-1 80504000826 4742 KIT CARSON JUNIOR-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_10 8 0 0   0 0     0   0   2 6                       8 8 0 0   0 0     0   0   2 6                 8
711017 CO     school 805040 510   KIT CARSON R-1 80504000826 4742 KIT CARSON JUNIOR-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_11 8 1 0   0 0     0   0   6 3                       9 8 1 0   0 0     0   0   6 3                 9
711025 CO     school 800001 520   CHEYENNE COUNTY RE-5 80000100214 1608 CHEYENNE WELLS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 13 0 0   0 0     0   0   8 5                       13 13 0 0   0 0     0   0   8 5                 13
711029 CO     school 800001 520   CHEYENNE COUNTY RE-5 80000100214 1608 CHEYENNE WELLS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_6 13 0 0   0 0     0   0   7 6                       13 13 0 0   0 0     0   0   7 6                 13
711038 CO     school 800001 520   CHEYENNE COUNTY RE-5 80000100215 1612 CHEYENNE WELLS JUNIOR/HIGH SCHOOL   Regular School No High 07 12 2017   grade_9 14 0 0   0 0     0   0   7 7                       14 14 0 0   0 0     0   0   7 7                 14
711043 CO     school 803000 540   CLEAR CREEK RE-1 80300001999 3385 GEORGETOWN COMMUNITY SCHOOL   Regular School Yes Elementary PK 06 2017   grade_1 23 1 0   1 0     0   0   19 6                       25 23 1 0   1 0     0   0   19 6                 25
711052 CO     school 803000 540   CLEAR CREEK RE-1 80300000218 4212 CARLSON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_1 24 0 0   1 0     0   5   16 14                       30 24 0 0   1 0     0   5   16 14                 30
711066 CO     school 803000 540   CLEAR CREEK RE-1 80300001332 4700 KING-MURPHY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_1 15 0 0   0 0     1   1   11 6                       17 15 0 0   0 0     1   1   11 6                 17
711067 CO     school 803000 540   CLEAR CREEK RE-1 80300001332 4700 KING-MURPHY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 12 0 0   0 0     0   0   6 6                       12 12 0 0   0 0     0   0   6 6                 12
711068 CO     school 803000 540   CLEAR CREEK RE-1 80300001332 4700 KING-MURPHY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_3 24 0 0   0 0     0   0   11 13                       24 24 0 0   0 0     0   0   11 13                 24
711071 CO     school 803000 540   CLEAR CREEK RE-1 80300001332 4700 KING-MURPHY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_6 10 0 0   0 0     0   0   7 3                       10 10 0 0   0 0     0   0   7 3                 10
711074 CO     school 803000 540   CLEAR CREEK RE-1 80300001332 4700 KING-MURPHY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   pre_kindergarten 11 0 0   0 0     0   0   9 2                       11 11 0 0   0 0     0   0   9 2                 11
711098 CO     school 805100 550   NORTH CONEJOS RE-1J 80510006601 6339 NORTH CONEJOS ALTERNATIVE PROGRAM   Alternative School No Other KG 12 2017   grade_1 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
711102 CO     school 805100 550   NORTH CONEJOS RE-1J 80510006601 6339 NORTH CONEJOS ALTERNATIVE PROGRAM   Alternative School No Other KG 12 2017   grade_3 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
711103 CO     school 805100 550   NORTH CONEJOS RE-1J 80510006601 6339 NORTH CONEJOS ALTERNATIVE PROGRAM   Alternative School No Other KG 12 2017   grade_5 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
711106 CO     school 805100 550   NORTH CONEJOS RE-1J 80510006601 6339 NORTH CONEJOS ALTERNATIVE PROGRAM   Alternative School No Other KG 12 2017   grade_8 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
711187 CO     school 807200 860   CUSTER COUNTY SCHOOL DISTRICT C-1 80720001226 2088 CUSTER COUNTY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 21 0 0   1 0     0   0   9 13                       22 21 0 0   1 0     0   0   9 13                 22
711188 CO     school 807200 860   CUSTER COUNTY SCHOOL DISTRICT C-1 80720001226 2088 CUSTER COUNTY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 27 1 0   0 0     0   0   11 17                       28 27 1 0   0 0     0   0   11 17                 28
711189 CO     school 807200 860   CUSTER COUNTY SCHOOL DISTRICT C-1 80720001226 2088 CUSTER COUNTY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 29 0 0   1 0     0   0   22 8                       30 29 0 0   1 0     0   0   22 8                 30
711195 CO     school 807200 860   CUSTER COUNTY SCHOOL DISTRICT C-1 80720001732 2091 CUSTER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 22 0 0   0 0     0   1   8 15                       23 22 0 0   0 0     0   1   8 15                 23
711196 CO     school 807200 860   CUSTER COUNTY SCHOOL DISTRICT C-1 80720001732 2091 CUSTER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 23 1 0   0 0     0   0   12 12                       24 23 1 0   0 0     0   0   12 12                 24
711197 CO     school 807200 860   CUSTER COUNTY SCHOOL DISTRICT C-1 80720001732 2091 CUSTER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 28 0 0   0 0     0   1   12 17                       29 28 0 0   0 0     0   1   12 17                 29
711198 CO     school 807200 860   CUSTER COUNTY SCHOOL DISTRICT C-1 80720001732 2091 CUSTER MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 73 1 0   0 0     0   2   32 44                       76 73 1 0   0 0     0   2   32 44                 76
711200 CO     school 807200 860   CUSTER COUNTY SCHOOL DISTRICT C-1 80720001225 2092 CUSTER COUNTY HIGH SCHOOL   Regular School No High 09 12 2017   grade_11 29 0 0   1 0     0   2   14 18                       32 29 0 0   1 0     0   2   14 18                 32
711204 CO     school 803330 870   DELTA COUNTY 50(J) 80333006681 93 ACHIEVE BLENDED LEARNING ACADEMY   Regular School No Other 06 12 2017   grade_10 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
711206 CO     school 803330 870   DELTA COUNTY 50(J) 80333006681 93 ACHIEVE BLENDED LEARNING ACADEMY   Regular School No Other 06 12 2017   grade_6 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
711207 CO     school 803330 870   DELTA COUNTY 50(J) 80333006681 93 ACHIEVE BLENDED LEARNING ACADEMY   Regular School No Other 06 12 2017   grade_8 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
711208 CO     school 803330 870   DELTA COUNTY 50(J) 80333006681 93 ACHIEVE BLENDED LEARNING ACADEMY   Regular School No Other 06 12 2017   grade_9 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
711223 CO     school 803330 870   DELTA COUNTY 50(J) 80333000295 1952 NORTH FORK MONTESSORI @ CRAWFORD   Regular School No Elementary PK 06 2017   grade_3 14 0 0   0 0     0   0   8 6                       14 14 0 0   0 0     0   0   8 6                 14
711232 CO     school 803330 870   DELTA COUNTY 50(J) 80333002001 2152 DELTA ACADEMY OF APPLIED LEARNING   Alternative School No Middle 05 08 2017   grade_6 7 0 0   0 0     0   1   5 3                       8 7 0 0   0 0     0   1   5 3                 8
711305 CO     school 803330 870   DELTA COUNTY 50(J) 80333006667 6295 NORTH FORK SCHOOL OF INTEGRATED STUDIES   Regular School No Elementary KG 05 2017   grade_2 4 0 0   0 0     0   0   3 1                       4 4 0 0   0 0     0   0   3 1                 4
711307 CO     school 803330 870   DELTA COUNTY 50(J) 80333006667 6295 NORTH FORK SCHOOL OF INTEGRATED STUDIES   Regular School No Elementary KG 05 2017   grade_4 9 0 0   0 0     0   1   4 6                       10 9 0 0   0 0     0   1   4 6                 10
711308 CO     school 803330 870   DELTA COUNTY 50(J) 80333006667 6295 NORTH FORK SCHOOL OF INTEGRATED STUDIES   Regular School No Elementary KG 05 2017   grade_5 4 0 0   0 0     0   1   3 2                       5 4 0 0   0 0     0   1   3 2                 5
712139 CO     school 803360 880   DENVER COUNTY 1 80336000378 5716 MC MEEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
712272 CO     school 803360 880   DENVER COUNTY 1 80336000391 6754 PARK HILL SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
712307 CO     school 803360 880   DENVER COUNTY 1 80336001795 7163 P.R.E.P. (POSITIVE REFOCUS EDUCATION PROGRAM)   Alternative School No Other 06 12 2017   grade_6 0 1 0   0 0     0   0   1 0                       1 0 1 0   0 0     0   0   1 0                 1
712356 CO     school 803360 880   DENVER COUNTY 1 80336000398 7554 SABIN WORLD SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
712365 CO     school 803360 880   DENVER COUNTY 1 80336000399 7578 SAMUELS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 1 0 0   0 0     0   1   2 0                       2 1 0 0   0 0     0   1   2 0                 2
712398 CO     school 803360 880   DENVER COUNTY 1 80336001524 7972 SLAVENS K-8 SCHOOL   Regular School No Elementary KG 08 2017   kindergarten_half_day 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
712459 CO     school 803360 880   DENVER COUNTY 1 80336006524 8149 STEPHEN KNIGHT CENTER FOR EARLY EDUCATION   Regular School No Elementary PK KG 2017   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
712510 CO     school 803360 880   DENVER COUNTY 1 80336006518 8453 SWIGERT INTERNATIONAL SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 18 0 0   0 1     0   2   11 10                       21 18 0 0   0 1     0   2   11 10                 21
712663 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342001958 50 RICO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_1 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
712664 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342001958 50 RICO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
712665 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342001958 50 RICO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   kindergarten_full_day 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
712666 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342001958 50 RICO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   pk_12_total 8 0 0   0 0     0   0   2 6                       8 8 0 0   0 0     0   0   2 6                 8
712667 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342001958 50 RICO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   pre_kindergarten 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
712672 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342000429 2216 DOVE CREEK HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 15 0 0   0 0     0   0   11 4                       15 15 0 0   0 0     0   0   11 4                 15
712678 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342000435 7764 SEVENTH STREET ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 19 0 0   0 0     0   1   14 6                       20 19 0 0   0 0     0   1   14 6                 20
712680 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342000435 7764 SEVENTH STREET ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 16 0 0   0 0     0   0   7 9                       16 16 0 0   0 0     0   0   7 9                 16
712683 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342000435 7764 SEVENTH STREET ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 24 0 0   0 0     0   0   12 12                       24 24 0 0   0 0     0   0   12 12                 24
712716 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006218 201 DANIEL C OAKES HIGH SCHOOL--CASTLE ROCK   Alternative School No High 09 12 2017   grade_10 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
712795 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000437 1362 CASTLE ROCK ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   kindergarten_half_day 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
712823 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006494 1555 CLOVERLEAF HOME EDUCATION   Alternative School No Other KG 12 2017   grade_12 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
712831 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006494 1555 CLOVERLEAF HOME EDUCATION   Alternative School No Other KG 12 2017   grade_9 4 0 0   0 0     0   0   1 3                       4 4 0 0   0 0     0   0   1 3                 4
712834 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000439 1578 CHERRY VALLEY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_1 8 0 0   0 0     0   0   4 4                       8 8 0 0   0 0     0   0   4 4                 8
712835 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000439 1578 CHERRY VALLEY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_2 3 1 0   0 0     0   0   2 2                       4 3 1 0   0 0     0   0   2 2                 4
712836 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000439 1578 CHERRY VALLEY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_3 6 1 0   0 0     0   0   5 2                       7 6 1 0   0 0     0   0   5 2                 7
712837 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000439 1578 CHERRY VALLEY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_4 6 2 0   0 0     0   0   3 5                       8 6 2 0   0 0     0   0   3 5                 8
712870 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001897 1899 COPPER MESA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   kindergarten_full_day 22 0 0   0 0     0   1   12 11                       23 22 0 0   0 0     0   1   12 11                 23
712964 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006309 2953 STONE MOUNTAIN ELEMENTARY   Regular School No Elementary PK 06 2017   kindergarten_half_day 13 0 0   1 1     0   0   5 10                       15 13 0 0   1 1     0   0   5 10                 15
712978 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001959 2965 FLAGSTONE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   kindergarten_full_day 22 0 0   0 0     0   2   10 14                       24 22 0 0   0 0     0   2   10 14                 24
712999 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345003172 3172 FRANKTOWN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 31 1 0   1 0     0   0   16 17                       33 31 1 0   1 0     0   0   16 17                 33
713034 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001740 3928 HERITAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   kindergarten_full_day 22 0 0   0 0     0   1   11 12                       23 22 0 0   0 0     0   1   11 12                 23
713101 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006372 5405 EDCSD: COLORADO CYBER SCHOOL   Regular School No Other KG 12 2017   grade_4 5 0 0   0 0     0   0   3 2                       5 5 0 0   0 0     0   0   3 2                 5
713102 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006372 5405 EDCSD: COLORADO CYBER SCHOOL   Regular School No Other KG 12 2017   grade_5 7 0 0   0 0     0   0   2 5                       7 7 0 0   0 0     0   0   2 5                 7
713103 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006372 5405 EDCSD: COLORADO CYBER SCHOOL   Regular School No Other KG 12 2017   grade_6 4 0 0   1 0     0   0   3 2                       5 4 0 0   1 0     0   0   3 2                 5
713105 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006372 5405 EDCSD: COLORADO CYBER SCHOOL   Regular School No Other KG 12 2017   grade_8 9 0 0   0 0     0   1   6 4                       10 9 0 0   0 0     0   1   6 4                 10
713107 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006372 5405 EDCSD: COLORADO CYBER SCHOOL   Regular School No Other KG 12 2017   kindergarten_half_day 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
713115 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006472 5607 SAGE CANYON ELEMENTARY   Regular School No Elementary PK 06 2017   kindergarten_full_day 45 1 0   0 1     1   0   28 20                       48 45 1 0   0 1     1   0   28 20                 48
713453 CO     school 803540 910   EAGLE COUNTY RE 50 80354000851 2340 EAGLE COUNTY CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_2 37 0 0   0 0     0   1   21 17                       38 37 0 0   0 0     0   1   21 17                 38
713458 CO     school 803540 910   EAGLE COUNTY RE 50 80354000851 2340 EAGLE COUNTY CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 35 0 0   0 2     0   2   25 14                       39 35 0 0   0 2     0   2   25 14                 39
713485 CO     school 803540 910   EAGLE COUNTY RE 50 80354006221 2530 EDWARDS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
713502 CO     school 803540 910   EAGLE COUNTY RE 50 80354006366 4838 JUNE CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
713514 CO     school 803540 910   EAGLE COUNTY RE 50 80354001478 5742 HOMESTAKE PEAK SCHOOL   Regular School No Elementary PK 08 2017   kindergarten_half_day 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
713527 CO     school 803540 910   EAGLE COUNTY RE 50 80354006422 9061 VAIL SKI AND SNOWBOARD ACADEMY (VSSA)   Alternative School No Other 05 12 2017   grade_12 21 0 0   0 0     0   0   11 10                       21 21 0 0   0 0     0   0   11 10                 21
713530 CO     school 803540 910   EAGLE COUNTY RE 50 80354006422 9061 VAIL SKI AND SNOWBOARD ACADEMY (VSSA)   Alternative School No Other 05 12 2017   grade_7 26 0 0   0 0     0   2   16 12                       28 26 0 0   0 0     0   2   16 12                 28
713531 CO     school 803540 910   EAGLE COUNTY RE 50 80354006422 9061 VAIL SKI AND SNOWBOARD ACADEMY (VSSA)   Alternative School No Other 05 12 2017   grade_8 18 0 0   0 0     0   0   10 8                       18 18 0 0   0 0     0   0   10 8                 18

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