Data source: Big Local News · About: Big Local

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

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
710334 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000902 3196 FREDERICK SENIOR HIGH SCHOOL   Regular School No High 09 12 2017   pk_12_total 652 5 312   11 10     0   6   524 472                       996 652 5 312   11 10     0   6   524 472                 996
709636 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006644 2673 EDNA AND JOHN W. MOSLEY P-8   Regular School No Elementary PK 08 2017   pk_12_total 206 151 513   13 23     31   57   530 464                       994 206 151 513   13 23     31   57   530 464                 994
714197 CO     school 803060 1010   COLORADO SPRINGS 11 80306001683 4424 JENKINS MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 651 48 195   4 23     6   66   500 493                       993 651 48 195   4 23     6   66   500 493                 993
712212 CO     school 803360 880   DENVER COUNTY 1 80336000389 6314 NORTH HIGH SCHOOL   Regular School No High 09 12 2017   pk_12_total 99 80 771   11 8     0   22   533 458                       991 99 80 771   11 8     0   22   533 458                 991
707837 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2017   grade_11 22 5 64   2 2     1   3   57 42                       99 22 5 64   2 2     1   3   57 42                 99
708020 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690000728 1519 STARGATE CHARTER SCHOOL   Regular School Yes Other KG 10 2017   grade_2 57 1 11   1 21     0   8   51 48                       99 57 1 11   1 21     0   8   51 48                 99
708022 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690000728 1519 STARGATE CHARTER SCHOOL   Regular School Yes Other KG 10 2017   grade_4 59 0 10   1 20     0   9   46 53                       99 59 0 10   1 20     0   9   46 53                 99
708066 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001175 2410 TARVER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 65 2 24   0 6     0   2   55 44                       99 65 2 24   0 6     0   2   55 44                 99
708081 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001401 2578 SKYVIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_3 54 2 34   0 4     0   5   55 44                       99 54 2 34   0 4     0   5   55 44                 99
708294 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006561 8310 STEM LAUNCH   Regular School No Elementary KG 08 2017   grade_5 28 0 64   2 5     0   0   56 43                       99 28 0 64   2 5     0   0   56 43                 99
708869 CO     school 806540 123   SHERIDAN 2 80654001132 3054 ALICE TERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   kindergarten_full_day 16 2 76   1 1     0   3   52 47                       99 16 2 76   1 1     0   3   52 47                 99
708889 CO     school 806540 123   SHERIDAN 2 80654006565 8123 SOAR ACADEMY   Alternative School No Other 06 12 2017   pk_12_total 14 2 80   1 0     1   1   56 43                       99 14 2 80   1 0     1   1   56 43                 99
708997 CO     school 802910 130   CHERRY CREEK 5 80291001273 1572 HIGH PLAINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 58 5 17   0 11     0   8   48 51                       99 58 5 17   0 11     0   8   48 51                 99
709138 CO     school 802910 130   CHERRY CREEK 5 80291006544 4448 BLACK FOREST HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 72 3 13   3 4     0   4   48 51                       99 72 3 13   3 4     0   4   48 51                 99
709164 CO     school 802910 130   CHERRY CREEK 5 80291000198 5934 MISSION VIEJO ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 54 13 23   2 1     0   6   44 55                       99 54 13 23   2 1     0   6   44 55                 99
709202 CO     school 802910 130   CHERRY CREEK 5 80291006183 6820 PEAKVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 65 12 15   0 4     0   3   51 48                       99 65 12 15   0 4     0   3   51 48                 99
709216 CO     school 802910 130   CHERRY CREEK 5 80291000199 7102 POLTON COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 42 17 23   0 4     0   13   45 54                       99 42 17 23   0 4     0   13   45 54                 99
709331 CO     school 805310 140   LITTLETON 6 80531000874 1382 CENTENNIAL ACADEMY OF FINE ARTS EDUCATION   Regular School No Elementary KG 05 2017   grade_2 54 1 36   0 2     0   6   54 45                       99 54 1 36   0 2     0   6   54 45                 99
709409 CO     school 805310 140   LITTLETON 6 80531001300 5236 LOIS LENSKI ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 80 3 7   0 2     0   7   58 41                       99 80 3 7   0 2     0   7   58 41                 99
709623 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000061 2618 ELKHART ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 3 11 78   1 2     0   4   52 47                       99 3 11 78   1 2     0   4   52 47                 99
710023 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000039 6658 PAGOSA SPRINGS HIGH SCHOOL   Regular School No High 09 12 2017   grade_11 69 0 23   4 3     0   0   57 42                       99 69 0 23   4 3     0   0   57 42                 99
710212 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006381 878 BLUE MOUNTAIN ELEMENTARY   Regular School No Elementary PK 05 2017   grade_4 77 1 9   1 8     0   3   44 55                       99 77 1 9   1 8     0   3   44 55                 99
710671 CO     school 802490 480   BOULDER VALLEY RE 2 80249000110 1996 CREST VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_3 67 2 19   1 4     0   6   52 47                       99 67 2 19   1 4     0   6   52 47                 99
710796 CO     school 802490 480   BOULDER VALLEY RE 2 80249000121 4874 LAFAYETTE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 71 0 14   1 6     0   7   48 51                       99 71 0 14   1 6     0   7   48 51                 99
711611 CO     school 803360 880   DENVER COUNTY 1 80336001522 2174 DENISON MONTESSORI SCHOOL   Regular School No Elementary PK 06 2017   pre_kindergarten 32 0 56   2 6     0   3   47 52                       99 32 0 56   2 6     0   3   47 52                 99
711844 CO     school 803360 880   DENVER COUNTY 1 80336006473 3639 GIRLS ATHLETIC LEADERSHIP SCHOOL MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 49 5 39   0 3     0   3   0 99                       99 49 5 39   0 3     0   3   0 99                 99
712010 CO     school 803360 880   DENVER COUNTY 1 80336006448 4730 KIPP DENVER COLLEGIATE HIGH SCHOOL   Regular School Yes High 09 12 2017   grade_11 1 0 97   0 1     0   0   48 51                       99 1 0 97   0 1     0   0   48 51                 99
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
712194 CO     school 803360 880   DENVER COUNTY 1 80336006520 6239 NOEL COMMUNITY ARTS SCHOOL   Regular School No Other 06 12 2017   grade_9 6 29 61   0 1     1   1   44 55                       99 6 29 61   0 1     1   1   44 55                 99
712271 CO     school 803360 880   DENVER COUNTY 1 80336000391 6754 PARK HILL SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 83 6 4   0 2     0   4   44 55                       99 83 6 4   0 2     0   4   44 55                 99
712570 CO     school 803360 880   DENVER COUNTY 1 80336006457 9336 STRIVE PREP - SUNNYSIDE   Regular School Yes Middle 06 08 2017   grade_6 1 3 95   0 0     0   0   52 47                       99 1 3 95   0 0     0   0   52 47                 99
712637 CO     school 803360 880   DENVER COUNTY 1 80336006547 9702 WEST LEADERSHIP ACADEMY   Regular School No Other 06 12 2017   grade_10 2 2 95   0 0     0   0   51 48                       99 2 2 95   0 0     0   0   51 48                 99
712699 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_5 52 4 16   0 18     0   9   47 52                       99 52 4 16   0 18     0   9   47 52                 99
713288 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001900 7297 REDSTONE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_4 65 0 14   1 10     1   8   41 58                       99 65 0 14   1 10     1   8   41 58                 99
714115 CO     school 803060 1010   COLORADO SPRINGS 11 80306000232 2528 NIKOLA TESLA EDUCATION OPPORTUNITY CENTER   Alternative School No Other 06 12 2017   grade_12 44 8 38   1 0     0   8   58 41                       99 44 8 38   1 0     0   8   58 41                 99
714798 CO     school 805820 1080   LEWIS-PALMER 38 80582001536 5093 MONUMENT CHARTER ACADEMY   Regular School Yes Elementary PK 08 2017   grade_2 81 2 10   0 3     0   3   49 50                       99 81 2 10   0 3     0   3   49 50                 99
714800 CO     school 805820 1080   LEWIS-PALMER 38 80582001536 5093 MONUMENT CHARTER ACADEMY   Regular School Yes Elementary PK 08 2017   grade_4 79 1 11   0 1     0   7   47 52                       99 79 1 11   0 1     0   7   47 52                 99
714932 CO     school 803870 1110   FALCON 49 80387002035 6483 ODYSSEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 62 7 19   0 4     1   6   57 42                       99 62 7 19   0 4     1   6   57 42                 99
714967 CO     school 803870 1110   FALCON 49 80387001537 7317 REMINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 52 6 24   0 5     0   12   51 48                       99 52 6 24   0 5     0   12   51 48                 99
715005 CO     school 803870 1110   FALCON 49 80387001899 8010 SPRINGS RANCH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 59 7 20   0 4     0   9   49 50                       99 59 7 20   0 4     0   9   49 50                 99
715094 CO     school 802790 1140   CANON CITY RE-1 80279000173 3802 HARRISON SCHOOL   Regular School No Elementary KG 08 2017   grade_7 77 0 22   0 0     0   0   47 52                       99 77 0 22   0 0     0   0   47 52                 99
715280 CO     school 806240 1195   GARFIELD RE-2 80624001967 3967 HIGHLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_4 37 0 60   1 0     0   1   48 51                       99 37 0 60   1 0     0   1   48 51                 99
715374 CO     school 804320 1350   EAST GRAND 2 80432001343 2376 EAST GRAND MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 76 3 17   0 1     1   1   50 49                       99 76 3 17   0 1     1   1   50 49                 99
715396 CO     school 804320 1350   EAST GRAND 2 80432000596 5864 MIDDLE PARK HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 81 1 16   0 0     1   0   60 39                       99 81 1 16   0 0     1   0   60 39                 99
716733 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001807 9427 WOODROW WILSON CHARTER ACADEMY   Regular School Yes Elementary PK 08 2017   grade_6 85 0 8   0 1     0   5   40 59                       99 85 0 8   0 1     0   5   40 59                 99
717744 CO     school 803810 1570   ESTES PARK R-3 80381000498 2790 ESTES PARK K-5 SCHOOL   Regular School No Elementary PK 05 2017   grade_5 60 3 33   0 3     0   0   53 46                       99 60 3 33   0 3     0   0   53 46                 99
718654 CO     school 802610 2395   BRUSH RE-2(J) 80261000153 1094 BRUSH MIDDLE SCHOOL   Regular School No Middle 07 08 2017   grade_8 49 0 48   0 0     0   2   44 55                       99 49 0 48   0 0     0   2   44 55                 99
718727 CO     school 807140 2505   WELDON VALLEY RE-20(J) 80714001218 9360 WELDON VALLEY JR/SR HIGH SCHOOL   Regular School No High 07 12 2017   pk_12_total 82 0 16   0 1     0   0   45 54                       99 82 0 16   0 1     0   0   45 54                 99
718751 CO     school 805130 2520   EAST OTERO R-1 80513001975 4843 LA JUNTA PRIMARY SCHOOL   Regular School No Elementary KG 02 2017   grade_2 24 0 71   1 0     1   2   54 45                       99 24 0 71   1 0     1   2   54 45                 99
719188 CO     school 806120 2690   PUEBLO CITY 60 80612006378 2620 FOUNTAIN INTERNATIONAL MAGNET SCHOOL   Regular School No Elementary PK 03 2017   grade_2 39 0 55   0 3     0   2   49 50                       99 39 0 55   0 3     0   2   49 50                 99
719190 CO     school 806120 2690   PUEBLO CITY 60 80612006378 2620 FOUNTAIN INTERNATIONAL MAGNET SCHOOL   Regular School No Elementary PK 03 2017   kindergarten_full_day 42 0 56   1 0     0   0   45 54                       99 42 0 56   1 0     0   0   45 54                 99
719591 CO     school 806660 2770   STEAMBOAT SPRINGS RE-2 80666001749 6363 NORTH ROUTT CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   pk_12_total 94 0 3   1 0     0   1   54 45                       99 94 0 3   1 0     0   1   54 45                 99
719955 CO     school 805940 3050   OTIS R-3 80594001017 6586 OTIS JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   pk_12_total 83 3 8   0 1     0   4   51 48                       99 83 3 8   0 1     0   4   51 48                 99
720147 CO     school 807350 3100   WINDSOR RE-4 80735001815 9665 WINDSOR CHARTER ACADEMY ELEMENTARY SCHOOL   Regular School Yes Elementary KG 05 2017   grade_3 79 1 12   0 2     0   5   50 49                       99 79 1 12   0 2     0   5   50 49                 99
720223 CO     school 804410 3120   GREELEY 6 80441001990 54 BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY   Regular School No Elementary KG 08 2017   grade_1 11 7 78   1 1     0   1   57 42                       99 11 7 78   1 1     0   1   57 42                 99
720272 CO     school 804410 3120   GREELEY 6 80441001482 2222 DOS RIOS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 27 1 66   0 2     0   3   51 48                       99 27 1 66   0 2     0   3   51 48                 99
720357 CO     school 804410 3120   GREELEY 6 80441001483 5660 S. CHRISTA MCAULIFFE STEM ACADEMY   Regular School No Elementary KG 06 2017   grade_3 41 0 50   0 4     0   4   59 40                       99 41 0 50   0 4     0   4   59 40                 99
720374 CO     school 804410 3120   GREELEY 6 80441001312 5985 MONFORT ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_4 52 1 41   0 3     0   2   49 50                       99 52 1 41   0 3     0   2   49 50                 99
720852 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006661 6266 NEW LEGACY CHARTER SCHOOL   Regular School Yes High 09 12 2017   pk_12_total 6 15 73   0 2     1   2   18 81                       99 6 15 73   0 2     1   2   18 81                 99
720998 CO     school 800282 9170   COLORADO DIGITAL BOCES 80028206600 1550 COLORADO PREP ACADEMY   Regular School No Other KG 12 2017   kindergarten_half_day 62 5 17   1 0     1   13   51 48                       99 62 5 17   1 0     1   13   51 48                 99
714583 CO     school 801920 1040   ACADEMY 20 80192001402 2358 EAGLEVIEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 706 35 143   4 28     1   69   478 508                       986 706 35 143   4 28     1   69   478 508                 986
710440 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006594 6010 TIMBERLINE PK-8   Regular School No Elementary PK 08 2017   pk_12_total 116 8 831   9 8     5   7   514 470                       984 116 8 831   9 8     5   7   514 470                 984
713215 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000443 6772 SAGEWOOD MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 756 5 133   7 24     2   53   530 450                       980 756 5 133   7 24     2   53   530 450                 980
714894 CO     school 803870 1110   FALCON 49 80387000506 2906 FALCON MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 701 46 150   3 18     3   59   520 460                       980 701 46 150   3 18     3   59   520 460                 980
720666 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001926 654 THE PINNACLE CHARTER SCHOOL ELEMENTARY   Regular School Yes Elementary KG 05 2017   pk_12_total 173 5 751   3 38     0   10   494 486                       980 173 5 751   3 38     0   10   494 486                 980
708032 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001174 1878 CORONADO HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 9 0 88   0 0     0   1   57 41                       98 9 0 88   0 0     0   1   57 41                 98
708050 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001668 1937 COYOTE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 77 2 7   0 6     0   6   51 47                       98 77 2 7   0 6     0   6   51 47                 98
708057 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001622 2361 EAGLEVIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_3 59 2 26   1 7     1   2   42 56                       98 59 2 26   1 7     1   2   42 56                 98
708227 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006507 6802 PROSPECT RIDGE ACADEMY   Regular School Yes Other KG 11 2017   grade_11 74 1 13   0 5     0   5   53 45                       98 74 1 13   0 5     0   5   53 45                 98
708257 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690002028 7795 SILVER CREEK ELEMENTARY   Regular School No Elementary KG 05 2017   grade_1 76 1 16   2 1     0   2   54 44                       98 76 1 16   2 1     0   2   54 44                 98
708696 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006373 4465 JOSEPHINE HODGKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 10 0 85   0 3     0   0   50 48                       98 10 0 85   0 3     0   0   50 48                 98
708874 CO     school 806540 123   SHERIDAN 2 80654001135 7837 FORT LOGAN NORTHGATE   Regular School No Elementary 03 08 2017   grade_6 13 2 77   0 1     0   5   46 52                       98 13 2 77   0 1     0   5   46 52                 98
708908 CO     school 802910 130   CHERRY CREEK 5 80291001670 242 ANTELOPE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 56 7 19   1 5     1   9   42 56                       98 56 7 19   1 5     1   9   42 56                 98
708911 CO     school 802910 130   CHERRY CREEK 5 80291001670 242 ANTELOPE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 57 8 19   0 5     1   8   52 46                       98 57 8 19   0 5     1   8   52 46                 98
708936 CO     school 802910 130   CHERRY CREEK 5 80291000184 714 BELLEVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 55 3 9   0 23     0   8   49 49                       98 55 3 9   0 23     0   8   49 49                 98
708953 CO     school 802910 130   CHERRY CREEK 5 80291001831 1273 CANYON CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 47 6 33   0 5     0   7   53 45                       98 47 6 33   0 5     0   7   53 45                 98
709091 CO     school 802910 130   CHERRY CREEK 5 80291006182 3988 HIGHLINE COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 15 17 60   0 1     0   5   46 52                       98 15 17 60   0 1     0   5   46 52                 98
709100 CO     school 802910 130   CHERRY CREEK 5 80291000194 4062 HOLLY HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 30 9 48   1 6     0   4   59 39                       98 30 9 48   1 6     0   4   59 39                 98
709101 CO     school 802910 130   CHERRY CREEK 5 80291000194 4062 HOLLY HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 15 17 59   2 3     0   2   47 51                       98 15 17 59   2 3     0   2   47 51                 98
709234 CO     school 802910 130   CHERRY CREEK 5 80291001880 7277 RED HAWK RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 48 5 26   2 9     0   8   52 46                       98 48 5 26   2 9     0   8   52 46                 98
709595 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000058 1948 CRAWFORD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 5 13 55   1 22     0   2   51 47                       98 5 13 55   1 22     0   2   51 47                 98
709625 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000061 2618 ELKHART ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_full_day 7 18 64   0 5     1   3   43 55                       98 7 18 64   0 5     1   3   43 55                 98
709755 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001881 6189 MURPHY CREEK K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_4 37 16 35   0 3     1   6   43 55                       98 37 16 35   0 3     1   6   43 55                 98
709824 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000077 7558 SABLE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 7 17 61   1 8     2   2   46 52                       98 7 17 61   1 8     2   2   46 52                 98
709832 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001432 7865 SIDE CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 16 22 43   0 8     0   9   52 46                       98 16 22 43   0 8     0   9   52 46                 98
709855 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001324 8858 TOLLGATE ELEMENTARY SCHOOL OF EXPEDITIONARY LEARNING   Regular School No Elementary KG 05 2017   grade_1 16 19 56   1 2     1   3   50 48                       98 16 19 56   1 2     1   3   50 48                 98
709857 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001324 8858 TOLLGATE ELEMENTARY SCHOOL OF EXPEDITIONARY LEARNING   Regular School No Elementary KG 05 2017   grade_3 15 22 51   1 5     0   4   55 43                       98 15 22 51   1 5     0   4   55 43                 98
709893 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006483 9083 VISTA PEAK P-8 EXPLORATORY   Regular School No Elementary PK 08 2017   grade_6 30 10 47   1 3     0   7   47 51                       98 30 10 47   1 3     0   7   47 51                 98
709907 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000081 9140 VIRGINIA COURT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 9 18 66   1 1     0   3   64 34                       98 9 18 66   1 1     0   3   64 34                 98
709975 CO     school 802700 190   BYERS 32J 80270006605 2356 ELEVATE ACADEMY   Regular School Yes Other KG 12 2017   grade_2 7 12 72   7 0     0   0   50 48                       98 7 12 72   7 0     0   0   50 48                 98
709978 CO     school 802700 190   BYERS 32J 80270006605 2356 ELEVATE ACADEMY   Regular School Yes Other KG 12 2017   grade_5 12 14 68   3 1     0   0   63 35                       98 12 14 68   3 1     0   0   63 35                 98
710210 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006381 878 BLUE MOUNTAIN ELEMENTARY   Regular School No Elementary PK 05 2017   grade_2 72 0 4   0 16     1   5   59 39                       98 72 0 4   0 16     1   5   59 39                 98
710231 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006397 1245 CENTENNIAL ELEMENTARY   Regular School No Elementary PK 05 2017   grade_1 63 0 30   1 1     0   3   47 51                       98 63 0 30   1 1     0   3   47 51                 98
710315 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000901 3192 THUNDER VALLEY PK-8   Regular School No Elementary PK 08 2017   grade_1 45 1 50   0 0     0   2   53 45                       98 45 1 50   0 0     0   2   53 45                 98
710317 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000901 3192 THUNDER VALLEY PK-8   Regular School No Elementary PK 08 2017   grade_3 38 0 57   0 1     0   2   47 51                       98 38 0 57   0 1     0   2   47 51                 98
711415 CO     school 803360 880   DENVER COUNTY 1 80336000319 1076 BROWN INTERNATIONAL ACADEMY   Regular School No Elementary PK 05 2017   grade_2 60 3 30   1 1     0   3   48 50                       98 60 3 30   1 1     0   3   48 50                 98
711669 CO     school 803360 880   DENVER COUNTY 1 80336006528 2209 DCIS AT MONTBELLO   Regular School No Other 06 12 2017   grade_11 3 15 80   0 0     0   0   51 47                       98 3 15 80   0 0     0   0   51 47                 98
711788 CO     school 803360 880   DENVER COUNTY 1 80336001864 3340 LENA ARCHULETA ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2017   grade_1 5 7 80   1 4     0   1   52 46                       98 5 7 80   1 4     0   1   52 46                 98
711847 CO     school 803360 880   DENVER COUNTY 1 80336001776 3641 GREEN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 16 16 53   0 6     1   6   48 50                       98 16 16 53   0 6     1   6   48 50                 98
711996 CO     school 803360 880   DENVER COUNTY 1 80336006519 4507 KIPP MONTBELLO COLLEGE PREP   Regular School Yes Middle 05 08 2017   grade_5 2 16 79   0 0     0   1   48 50                       98 2 16 79   0 0     0   1   48 50                 98

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