Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2017 · 13,207
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
707943 CO     school 805550 10   MAPLETON 1 80555006672 3590 GLOBAL INTERMEDIATE ACADEMY   Regular School No Elementary 04 08 2017   grade_5 0 1 23   0 0     0   0   13 11                       24 0 1 23   0 0     0   0   13 11                 24
708171 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001182 5706 MC ELWAIN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_half_day 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
708358 CO     school 801950 30   ADAMS COUNTY 14 80195001307 22 LESTER R ARNOLD HIGH SCHOOL   Alternative School No High 09 12 2017   grade_9 0 0 4   0 0     0   0   2 2                       4 0 0 4   0 0     0   0   2 2                 4
708448 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000729 1021 BRIGHTON HERITAGE ACADEMY   Alternative School No Other 06 12 2017   grade_8 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
708683 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723001877 3931 HIDDEN LAKE HIGH SCHOOL   Career and Technical School No High 09 12 2017   grade_9 0 0 3   0 0     0   1   1 3                       4 0 0 3   0 0     0   1   1 3                 4
708792 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   grade_10 0 0 6   0 0     0   1   3 4                       7 0 0 6   0 0     0   1   3 4                 7
708795 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   grade_6 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
708796 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   grade_7 0 0 3   0 0     0   0   2 1                       3 0 0 3   0 0     0   0   2 1                 3
708885 CO     school 806540 123   SHERIDAN 2 80654006565 8123 SOAR ACADEMY   Alternative School No Other 06 12 2017   grade_10 0 0 10   0 0     0   0   5 5                       10 0 0 10   0 0     0   0   5 5                 10
708888 CO     school 806540 123   SHERIDAN 2 80654006565 8123 SOAR ACADEMY   Alternative School No Other 06 12 2017   grade_9 0 0 3   0 0     0   0   2 1                       3 0 0 3   0 0     0   0   2 1                 3
709484 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_10 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
709486 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_12 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
709488 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_3 0 0 2   0 0     0   0   2 0                       2 0 0 2   0 0     0   0   2 0                 2
709489 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_4 0 1 0   0 0     0   0   0 1                       1 0 1 0   0 0     0   0   0 1                 1
709490 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_5 0 0 0   0 0     0   1   0 1                       1 0 0 0   0 0     0   1   0 1                 1
709556 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000055 914 BOSTON K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_4 0 7 31   0 6     0   4   18 30                       48 0 7 31   0 6     0   4   18 30                 48
709559 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000055 914 BOSTON K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 0 6 28   0 4     0   0   20 18                       38 0 6 28   0 4     0   0   20 18                 38
709560 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000055 914 BOSTON K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_8 0 5 20   0 9     0   1   18 17                       35 0 5 20   0 9     0   1   18 17                 35
709563 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000055 914 BOSTON K-8 SCHOOL   Regular School No Elementary PK 08 2017   pre_kindergarten 0 3 23   0 4     0   0   10 20                       30 0 3 23   0 4     0   0   10 20                 30
709643 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006424 2998 FLETCHER COMMUNITY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 0 10 45   0 1     0   0   27 29                       56 0 10 45   0 1     0   0   27 29                 56
709644 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006424 2998 FLETCHER COMMUNITY SCHOOL   Regular School No Elementary KG 05 2017   grade_5 0 14 44   2 2     0   0   32 30                       62 0 14 44   2 2     0   0   32 30                 62
709654 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000062 3272 FULTON ACADEMY OF EXCELLENCE   Regular School No Elementary PK 05 2017   pre_kindergarten 0 3 20   0 3     0   0   15 11                       26 0 3 20   0 3     0   0   15 11                 26
709804 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001927 6869 PEORIA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 0 3 20   0 0     0   2   10 15                       25 0 3 20   0 0     0   2   10 15                 25
709829 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000077 7558 SABLE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 0 8 18   0 2     0   2   16 14                       30 0 8 18   0 2     0   2   16 14                 30
710090 CO     school 802760 270   CAMPO RE-6 80276000169 1248 CAMPO ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
710227 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006680 1221 ST. VRAIN VALLEY P-TECH SCHOOL   Regular School No High 09 12 2017   grade_10 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
710228 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006680 1221 ST. VRAIN VALLEY P-TECH SCHOOL   Regular School No High 09 12 2017   grade_11 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
710260 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001373 1844 COLUMBINE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 0 0 45   0 0     1   2   20 28                       48 0 0 45   0 0     1   2   20 28                 48
710346 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000904 4278 INDIAN PEAKS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 0 0 49   0 0     0   0   26 23                       49 0 0 49   0 0     0   0   26 23                 49
710347 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000904 4278 INDIAN PEAKS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 0 0 51   0 0     0   0   29 22                       51 0 0 51   0 0     0   0   29 22                 51
710349 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000904 4278 INDIAN PEAKS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 0 0 39   0 0     0   0   24 15                       39 0 0 39   0 0     0   0   24 15                 39
710650 CO     school 802490 480   BOULDER VALLEY RE 2 80249001376 1725 COAL CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_full_day 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
710721 CO     school 802490 480   BOULDER VALLEY RE 2 80249006154 2940 FIRESIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 0 0 2   0 0     0   0   2 0                       2 0 0 2   0 0     0   0   2 0                 2
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
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
710915 CO     school 802490 480   BOULDER VALLEY RE 2 80249001365 7528 RYAN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
711012 CO     school 805040 510   KIT CARSON R-1 80504000827 4738 KIT CARSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
711104 CO     school 805100 550   NORTH CONEJOS RE-1J 80510006601 6339 NORTH CONEJOS ALTERNATIVE PROGRAM   Alternative School No Other KG 12 2017   grade_6 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
711136 CO     school 802130 580   SOUTH CONEJOS RE-10 80213000035 252 ANTONITO HIGH SCHOOL   Regular School No High 09 12 2017   grade_10 0 0 12   0 0     0   0   7 5                       12 0 0 12   0 0     0   0   7 5                 12
711137 CO     school 802130 580   SOUTH CONEJOS RE-10 80213000035 252 ANTONITO HIGH SCHOOL   Regular School No High 09 12 2017   grade_11 0 0 22   1 0     0   0   11 12                       23 0 0 22   1 0     0   0   11 12                 23
711138 CO     school 802130 580   SOUTH CONEJOS RE-10 80213000035 252 ANTONITO HIGH SCHOOL   Regular School No High 09 12 2017   grade_12 0 0 8   0 0     0   0   5 3                       8 0 0 8   0 0     0   0   5 3                 8
711139 CO     school 802130 580   SOUTH CONEJOS RE-10 80213000035 252 ANTONITO HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 0 0 15   0 0     0   0   5 10                       15 0 0 15   0 0     0   0   5 10                 15
711140 CO     school 802130 580   SOUTH CONEJOS RE-10 80213000035 252 ANTONITO HIGH SCHOOL   Regular School No High 09 12 2017   pk_12_total 0 0 57   1 0     0   0   28 30                       58 0 0 57   1 0     0   0   28 30                 58
711141 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No Other PK 12 2017   grade_1 0 0 15   0 0     0   0   8 7                       15 0 0 15   0 0     0   0   8 7                 15
711144 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No Other PK 12 2017   grade_12 0 0 9   0 0     0   0   6 3                       9 0 0 9   0 0     0   0   6 3                 9
711145 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No Other PK 12 2017   grade_2 0 0 12   0 0     0   0   6 6                       12 0 0 12   0 0     0   0   6 6                 12
711146 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No Other PK 12 2017   grade_3 0 0 15   0 0     0   0   6 9                       15 0 0 15   0 0     0   0   6 9                 15
711147 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No Other PK 12 2017   grade_4 0 0 10   0 0     0   0   7 3                       10 0 0 10   0 0     0   0   7 3                 10
711148 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No Other PK 12 2017   grade_5 0 0 20   0 0     0   0   8 12                       20 0 0 20   0 0     0   0   8 12                 20
711153 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No Other PK 12 2017   kindergarten_full_day 0 0 15   0 0     0   0   10 5                       15 0 0 15   0 0     0   0   10 5                 15
711155 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No Other PK 12 2017   pre_kindergarten 0 0 16   0 0     0   0   9 7                       16 0 0 16   0 0     0   0   9 7                 16
711170 CO     school 804140 740   SIERRA GRANDE R-30 80414000572 7880 SIERRA GRANDE K-12 SCHOOL   Regular School No Other PK 12 2017   pre_kindergarten 0 0 4   0 0     0   0   1 3                       4 0 0 4   0 0     0   0   1 3                 4
711174 CO     school 803210 770   CROWLEY COUNTY RE-1-J 80321000283 2050 CROWLEY COUNTY PRIMARY   Regular School No Elementary KG 03 2017   kindergarten_full_day 0 0 31   0 0     0   0   23 8                       31 0 0 31   0 0     0   0   23 8                 31
711339 CO     school 803360 880   DENVER COUNTY 1 80336001894 67 ACADEMY OF URBAN LEARNING   Regular School Yes High 09 12 2017   grade_12 0 3 27   1 0     0   0   16 15                       31 0 3 27   1 0     0   0   16 15                 31
711340 CO     school 803360 880   DENVER COUNTY 1 80336001894 67 ACADEMY OF URBAN LEARNING   Regular School Yes High 09 12 2017   grade_9 0 0 24   1 0     0   0   16 9                       25 0 0 24   1 0     0   0   16 9                 25
711403 CO     school 803360 880   DENVER COUNTY 1 80336000317 964 BRADLEY INTERNATIONAL SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
711428 CO     school 803360 880   DENVER COUNTY 1 80336000320 1106 BRYANT WEBSTER DUAL LANGUAGE ECE-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_5 0 0 40   1 0     0   0   17 24                       41 0 0 40   1 0     0   0   17 24                 41
711430 CO     school 803360 880   DENVER COUNTY 1 80336000320 1106 BRYANT WEBSTER DUAL LANGUAGE ECE-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 0 0 49   0 0     0   0   23 26                       49 0 0 49   0 0     0   0   23 26                 49
711456 CO     school 803360 880   DENVER COUNTY 1 80336006449 1345 CESAR CHAVEZ ACADEMY DENVER   Regular School Yes Elementary KG 08 2017   grade_4 0 0 34   0 0     1   0   24 11                       35 0 0 34   0 0     1   0   24 11                 35
711461 CO     school 803360 880   DENVER COUNTY 1 80336006449 1345 CESAR CHAVEZ ACADEMY DENVER   Regular School Yes Elementary KG 08 2017   kindergarten_full_day 0 0 28   0 0     0   0   15 13                       28 0 0 28   0 0     0   0   15 13                 28
711477 CO     school 803360 880   DENVER COUNTY 1 80336000325 1528 CHELTENHAM ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 0 7 35   1 0     0   2   19 26                       45 0 7 35   1 0     0   2   19 26                 45
711484 CO     school 803360 880   DENVER COUNTY 1 80336000325 1528 CHELTENHAM ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 0 7 51   0 1     1   0   30 30                       60 0 7 51   0 1     1   0   30 30                 60
711524 CO     school 803360 880   DENVER COUNTY 1 80336000330 1846 COLUMBINE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 0 12 25   0 0     0   1   21 17                       38 0 12 25   0 0     0   1   21 17                 38
711531 CO     school 803360 880   DENVER COUNTY 1 80336001764 1866 ACE COMMUNITY CHALLENGE SCHOOL   Alternative School Yes Other 08 10 2017   grade_8 0 1 13   0 0     0   0   10 4                       14 0 1 13   0 0     0   0   10 4                 14
711532 CO     school 803360 880   DENVER COUNTY 1 80336001764 1866 ACE COMMUNITY CHALLENGE SCHOOL   Alternative School Yes Other 08 10 2017   grade_9 0 2 42   2 0     0   1   29 18                       47 0 2 42   2 0     0   1   29 18                 47
711544 CO     school 803360 880   DENVER COUNTY 1 80336000332 1928 COWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 0 1 63   0 0     0   1   32 33                       65 0 1 63   0 0     0   1   32 33                 65
711649 CO     school 803360 880   DENVER COUNTY 1 80336006516 2188 DENVER CENTER FOR 21ST LEARNING AT WYMAN   Alternative School No Other 06 12 2017   grade_7 0 3 3   0 0     0   0   3 3                       6 0 3 3   0 0     0   0   3 3                 6
711749 CO     school 803360 880   DENVER COUNTY 1 80336006441 2755 VENTURE PREP HIGH SCHOOL   Regular School Yes High 09 12 2017   grade_9 0 13 14   0 0     0   1   13 15                       28 0 13 14   0 0     0   1   13 15                 28
711757 CO     school 803360 880   DENVER COUNTY 1 80336000347 2880 FAIRVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 0 11 15   0 3     0   0   11 18                       29 0 11 15   0 3     0   0   11 18                 29
711764 CO     school 803360 880   DENVER COUNTY 1 80336006685 2919 SANDRA TODD-WILLIAMS ACADEMY   Regular School No Elementary PK PK 2017   kindergarten_full_day 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
711767 CO     school 803360 880   DENVER COUNTY 1 80336001575 3000 FLORENCE CRITTENTON HIGH SCHOOL   Alternative School No High 09 12 2017   grade_10 0 2 33   0 0     0   0   0 35                       35 0 2 33   0 0     0   0   0 35                 35
711800 CO     school 803360 880   DENVER COUNTY 1 80336000353 3426 GILPIN MONTESSORI PUBLIC SCHOOL   Regular School No Elementary PK 06 2017   grade_2 0 9 8   1 0     0   2   12 8                       20 0 9 8   1 0     0   2   12 8                 20
711801 CO     school 803360 880   DENVER COUNTY 1 80336000353 3426 GILPIN MONTESSORI PUBLIC SCHOOL   Regular School No Elementary PK 06 2017   grade_3 0 8 13   0 0     0   0   13 8                       21 0 8 13   0 0     0   0   13 8                 21
711857 CO     school 803360 880   DENVER COUNTY 1 80336001739 3647 MARIE L. GREENWOOD ACADEMY   Regular School No Elementary 01 08 2017   grade_3 0 12 78   0 1     0   1   53 39                       92 0 12 78   0 1     0   1   53 39                 92
711861 CO     school 803360 880   DENVER COUNTY 1 80336001739 3647 MARIE L. GREENWOOD ACADEMY   Regular School No Elementary 01 08 2017   grade_7 0 7 53   1 1     0   1   36 27                       63 0 7 53   1 1     0   1   36 27                 63
711868 CO     school 803360 880   DENVER COUNTY 1 80336006477 3655 GREENLEE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 0 14 22   2 0     0   2   26 14                       40 0 14 22   2 0     0   2   26 14                 40
711891 CO     school 803360 880   DENVER COUNTY 1 80336000362 3778 INTERNATIONAL ACADEMY OF DENVER AT HARRINGTON   Regular School No Elementary PK 05 2017   grade_1 0 9 23   0 0     0   2   15 19                       34 0 9 23   0 0     0   2   15 19                 34
711892 CO     school 803360 880   DENVER COUNTY 1 80336000362 3778 INTERNATIONAL ACADEMY OF DENVER AT HARRINGTON   Regular School No Elementary PK 05 2017   grade_2 0 5 46   1 0     0   0   27 25                       52 0 5 46   1 0     0   0   27 25                 52
711893 CO     school 803360 880   DENVER COUNTY 1 80336000362 3778 INTERNATIONAL ACADEMY OF DENVER AT HARRINGTON   Regular School No Elementary PK 05 2017   grade_3 0 6 45   1 0     0   2   29 25                       54 0 6 45   1 0     0   2   29 25                 54
711939 CO     school 803360 880   DENVER COUNTY 1 80336001928 4140 FARRELL B. HOWELL ECE-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_5 0 18 67   0 0     0   0   44 41                       85 0 18 67   0 0     0   0   44 41                 85
711941 CO     school 803360 880   DENVER COUNTY 1 80336001928 4140 FARRELL B. HOWELL ECE-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_7 0 12 83   0 0     0   2   46 51                       97 0 12 83   0 0     0   2   46 51                 97
711942 CO     school 803360 880   DENVER COUNTY 1 80336001928 4140 FARRELL B. HOWELL ECE-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_8 0 16 72   0 0     0   1   48 41                       89 0 16 72   0 0     0   1   48 41                 89
711943 CO     school 803360 880   DENVER COUNTY 1 80336001928 4140 FARRELL B. HOWELL ECE-8 SCHOOL   Regular School No Elementary PK 08 2017   kindergarten_full_day 0 12 51   0 0     0   2   31 34                       65 0 12 51   0 0     0   2   31 34                 65
711945 CO     school 803360 880   DENVER COUNTY 1 80336001928 4140 FARRELL B. HOWELL ECE-8 SCHOOL   Regular School No Elementary PK 08 2017   pre_kindergarten 0 11 50   0 1     0   1   23 40                       63 0 11 50   0 1     0   1   23 40                 63
712011 CO     school 803360 880   DENVER COUNTY 1 80336006448 4730 KIPP DENVER COLLEGIATE HIGH SCHOOL   Regular School Yes High 09 12 2017   grade_12 0 2 77   0 1     0   0   41 39                       80 0 2 77   0 1     0   0   41 39                 80
712015 CO     school 803360 880   DENVER COUNTY 1 80336001865 4732 KIPP SUNSHINE PEAK ACADEMY   Regular School Yes Middle 05 08 2017   grade_6 0 0 99   0 0     0   0   55 44                       99 0 0 99   0 0     0   0   55 44                 99
712017 CO     school 803360 880   DENVER COUNTY 1 80336001865 4732 KIPP SUNSHINE PEAK ACADEMY   Regular School Yes Middle 05 08 2017   grade_8 0 1 94   0 4     1   0   56 44                       100 0 1 94   0 4     1   0   56 44                 100
712027 CO     school 803360 880   DENVER COUNTY 1 80336000372 4782 HALLETT FUNDAMENTAL ACADEMY   Regular School No Elementary PK 05 2017   grade_1 0 27 2   0 1     0   5   20 15                       35 0 27 2   0 1     0   5   20 15                 35
712031 CO     school 803360 880   DENVER COUNTY 1 80336000372 4782 HALLETT FUNDAMENTAL ACADEMY   Regular School No Elementary PK 05 2017   grade_5 0 36 2   0 0     0   4   24 18                       42 0 36 2   0 0     0   4   24 18                 42
712032 CO     school 803360 880   DENVER COUNTY 1 80336000372 4782 HALLETT FUNDAMENTAL ACADEMY   Regular School No Elementary PK 05 2017   kindergarten_full_day 0 30 4   0 0     0   2   19 17                       36 0 30 4   0 0     0   2   19 17                 36
712050 CO     school 803360 880   DENVER COUNTY 1 80336006669 5044 LEGACY OPTIONS HIGH SCHOOL   Alternative School No Other 09 10 2017   grade_9 0 6 14   1 0     0   2   14 9                       23 0 6 14   1 0     0   2   14 9                 23
712089 CO     school 803360 880   DENVER COUNTY 1 80336001406 5605 DR. MARTIN LUTHER KING JR. EARLY COLLEGE   Regular School No Other 06 12 2017   grade_6 0 30 80   0 6     2   4   61 61                       122 0 30 80   0 6     2   4   61 61                 122
712097 CO     school 803360 880   DENVER COUNTY 1 80336006445 5608 MATHEMATICS AND SCIENCE LEADERSHIP ACADEMY   Regular School No Elementary KG 05 2017   grade_4 0 0 45   1 0     0   0   28 18                       46 0 0 45   1 0     0   0   28 18                 46
712098 CO     school 803360 880   DENVER COUNTY 1 80336006445 5608 MATHEMATICS AND SCIENCE LEADERSHIP ACADEMY   Regular School No Elementary KG 05 2017   grade_5 0 0 24   0 0     0   0   11 13                       24 0 0 24   0 0     0   0   11 13                 24
712099 CO     school 803360 880   DENVER COUNTY 1 80336006445 5608 MATHEMATICS AND SCIENCE LEADERSHIP ACADEMY   Regular School No Elementary KG 05 2017   kindergarten_full_day 0 2 24   0 0     0   0   10 16                       26 0 2 24   0 0     0   0   10 16                 26
712187 CO     school 803360 880   DENVER COUNTY 1 80336000387 6188 MUNROE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 0 1 30   1 0     0   0   15 17                       32 0 1 30   1 0     0   0   15 17                 32
712198 CO     school 803360 880   DENVER COUNTY 1 80336000388 6254 NEWLON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 0 2 80   0 0     0   0   42 40                       82 0 2 80   0 0     0   0   42 40                 82
712204 CO     school 803360 880   DENVER COUNTY 1 80336006569 6308 NORTH HIGH SCHOOL ENGAGEMENT CENTER   Alternative School No High 09 12 2017   grade_10 0 2 3   2 0     0   1   4 4                       8 0 2 3   2 0     0   1   4 4                 8
712213 CO     school 803360 880   DENVER COUNTY 1 80336001869 6350 BRUCE RANDOLPH SCHOOL   Regular School No Other 06 12 2017   grade_10 0 6 85   0 0     0   0   42 49                       91 0 6 85   0 0     0   0   42 49                 91
712214 CO     school 803360 880   DENVER COUNTY 1 80336001869 6350 BRUCE RANDOLPH SCHOOL   Regular School No Other 06 12 2017   grade_11 0 5 92   0 0     0   0   47 50                       97 0 5 92   0 0     0   0   47 50                 97

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