Data source: Big Local News · About: Big Local

1,082 rows where grade = "grade_2", state = "CO" and year = 2017 sorted by total

View and edit SQL

year

  • 2017 · 1,082

grade

  • grade_2 · 1,082
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
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
713538 CO     school 803540 910   EAGLE COUNTY RE 50 80354006533 9701 WORLD ACADEMY   Regular School No Other KG 12 2017   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
716523 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006307 8036 SOBESKY ACADEMY   Special Education School No Other KG 12 2017   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
718157 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000611 3350 GATEWAY SCHOOL   Regular School No Other PK 12 2017   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
719349 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Regular School No Other KG 12 2017   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
720285 CO     school 804410 3120   GREELEY 6 80441006505 2825 ENGAGE ONLINE ACADEMY   Regular School No Other KG 12 2017   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
717383 CO     school 803990 1550   POUDRE R-1 80399000543 7290 RED FEATHER LAKES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 9 0 1   0 0     0   0   5 5                       10 9 0 1   0 0     0   0   5 5                 10
720883 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006651 8061 SALIDA MONTESSORI CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_2 10 0 0   0 0     0   0   4 6                       10 10 0 0   0 0     0   0   4 6                 10
720945 CO     school 800023 9000   COLORADO SCHOOL FOR THE DEAF AND BLIND 80002306410 1924 COLORADO SCHOOL FOR THE DEAF AND BLIND   Special Education School No Other PK 12 2017   grade_2 4 1 4   1 0     0   0   5 5                       10 4 1 4   1 0     0   0   5 5                 10
708228 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006507 6802 PROSPECT RIDGE ACADEMY   Regular School Yes Other KG 11 2017   grade_2 77 1 9   0 6     0   7   53 47                       100 77 1 9   0 6     0   7   53 47                 100
709856 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001324 8858 TOLLGATE ELEMENTARY SCHOOL OF EXPEDITIONARY LEARNING   Regular School No Elementary KG 05 2017   grade_2 15 22 51   0 4     2   6   52 48                       100 15 22 51   0 4     2   6   52 48                 100
710156 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001830 60 LEGACY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 71 2 22   1 3     0   1   59 41                       100 71 2 22   1 3     0   1   59 41                 100
710304 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001890 2964 FLAGSTAFF CHARTER ACADEMY   Regular School Yes Elementary PK 08 2017   grade_2 74 0 13   0 10     0   3   48 52                       100 74 0 13   0 10     0   3   48 52                 100
711880 CO     school 803360 880   DENVER COUNTY 1 80336000359 3704 GUST ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 12 3 82   0 3     0   0   45 55                       100 12 3 82   0 3     0   0   45 55                 100
712020 CO     school 803360 880   DENVER COUNTY 1 80336000371 4762 KNAPP ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 6 3 89   1 1     0   0   58 42                       100 6 3 89   1 1     0   0   58 42                 100
713900 CO     school 806480 990   WIDEFIELD 3 80648001127 9334 WEBSTER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 51 7 27   1 0     1   13   54 46                       100 51 7 27   1 0     1   13   54 46                 100
713994 CO     school 804080 1000   FOUNTAIN 8 80408006481 9610 WEIKEL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 44 16 28   0 1     1   10   47 53                       100 44 16 28   0 1     1   10   47 53                 100
719139 CO     school 806120 2690   PUEBLO CITY 60 80612001730 1488 CHAVEZ/HUERTA K-12 PREPARATORY ACADEMY   Regular School Yes Other KG 12 2017   grade_2 13 2 85   0 0     0   0   52 48                       100 13 2 85   0 0     0   0   52 48                 100
708188 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001362 6150 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 70 0 17   1 7     0   6   49 52                       101 70 0 17   1 7     0   6   49 52                 101
708273 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006303 8225 STELLAR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 50 1 38   1 3     0   8   55 46                       101 50 1 38   1 3     0   8   55 46                 101
708951 CO     school 802910 130   CHERRY CREEK 5 80291001831 1273 CANYON CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 67 2 21   0 4     0   7   55 46                       101 67 2 21   0 4     0   7   55 46                 101
710365 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006531 5181 RED HAWK ELEMENTARY   Regular School No Elementary PK 05 2017   grade_2 79 0 10   0 7     0   5   57 44                       101 79 0 10   0 7     0   5   57 44                 101
712948 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006337 2952 MAMMOTH HEIGHTS ELEMENTARY   Regular School No Elementary PK 06 2017   grade_2 75 1 16   1 1     0   7   52 49                       101 75 1 16   1 1     0   7   52 49                 101
714672 CO     school 801920 1040   ACADEMY 20 80192006336 7247 RANCH CREEK ELEMENTARY   Regular School No Elementary PK 05 2017   grade_2 74 5 13   0 6     0   3   43 58                       101 74 5 13   0 6     0   3   43 58                 101
707996 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 48 2 43   0 4     0   5   53 49                       102 48 2 43   0 4     0   5   53 49                 102
709831 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001432 7865 SIDE CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 25 25 38   0 6     0   8   39 63                       102 25 25 38   0 6     0   8   39 63                 102
711789 CO     school 803360 880   DENVER COUNTY 1 80336001864 3340 LENA ARCHULETA ELEMENTARY SCHOOL   Regular School No Elementary 01 05 2017   grade_2 3 8 86   0 2     0   3   47 55                       102 3 8 86   0 2     0   3   47 55                 102
708944 CO     school 802910 130   CHERRY CREEK 5 80291006301 1155 BUFFALO TRAIL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 58 12 16   0 8     2   7   53 50                       103 58 12 16   0 8     2   7   53 50                 103
709269 CO     school 802910 130   CHERRY CREEK 5 80291001378 8394 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 50 11 28   2 3     1   8   56 47                       103 50 11 28   2 3     1   8   56 47                 103
710201 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006409 875 BLACK ROCK ELEMENTARY   Regular School No Elementary PK 05 2017   grade_2 86 0 11   0 2     0   4   46 57                       103 86 0 11   0 2     0   4   46 57                 103
713178 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006455 6365 SKYVIEW ACADEMY   Regular School Yes Other PK 12 2017   grade_2 63 0 9   0 26     0   5   42 61                       103 63 0 9   0 26     0   5   42 61                 103
714481 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 73 2 7   0 12     0   9   51 52                       103 73 2 7   0 12     0   9   51 52                 103
720406 CO     school 804410 3120   GREELEY 6 80441006638 8467 SALIDA DEL SOL ACADEMY   Regular School Yes Elementary KG 08 2017   grade_2 5 0 98   0 0     0   0   55 48                       103 5 0 98   0 0     0   0   55 48                 103
708040 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001305 1914 COTTON CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 67 1 21   1 7     0   7   57 47                       104 67 1 21   1 7     0   7   57 47                 104
709139 CO     school 802910 130   CHERRY CREEK 5 80291006544 4448 BLACK FOREST HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 75 6 9   1 5     0   8   59 45                       104 75 6 9   1 5     0   8   59 45                 104
710316 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000901 3192 THUNDER VALLEY PK-8   Regular School No Elementary PK 08 2017   grade_2 45 0 53   0 3     0   3   56 48                       104 45 0 53   0 3     0   3   56 48                 104
712244 CO     school 803360 880   DENVER COUNTY 1 80336001838 6508 OMAR D BLAIR CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 9 46 33   0 10     2   4   48 56                       104 9 46 33   0 10     2   4   48 56                 104
712706 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006492 135 BEN FRANKLIN ACADEMY   Regular School Yes Elementary PK 08 2017   grade_2 77 2 10   0 5     0   10   56 48                       104 77 2 10   0 5     0   10   56 48                 104
713150 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006588 6019 ASPEN VIEW ACADEMY   Regular School Yes Elementary PK 08 2017   grade_2 83 0 12   1 3     0   5   51 53                       104 83 0 12   1 3     0   5   51 53                 104
719038 CO     school 805220 2660   LAMAR RE-2 80522000865 9268 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   grade_2 29 0 72   1 0     0   2   62 42                       104 29 0 72   1 0     0   2   62 42                 104
720146 CO     school 807350 3100   WINDSOR RE-4 80735001815 9665 WINDSOR CHARTER ACADEMY ELEMENTARY SCHOOL   Regular School Yes Elementary KG 05 2017   grade_2 91 0 8   0 0     0   5   49 55                       104 91 0 8   0 0     0   5   49 55                 104
708921 CO     school 802910 130   CHERRY CREEK 5 80291000183 348 ARROWHEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 49 12 31   1 2     1   9   45 60                       105 49 12 31   1 2     1   9   45 60                 105
710232 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006397 1245 CENTENNIAL ELEMENTARY   Regular School No Elementary PK 05 2017   grade_2 64 2 34   1 0     0   4   59 46                       105 64 2 34   1 0     0   4   59 46                 105
713832 CO     school 806480 990   WIDEFIELD 3 80648001458 3234 FRENCH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 50 12 31   0 2     2   8   44 61                       105 50 12 31   0 2     2   8   44 61                 105
720124 CO     school 807350 3100   WINDSOR RE-4 80735006460 8459 RANGE VIEW ELEMENTARY   Regular School No Elementary PK 05 2017   grade_2 85 2 11   0 1     0   6   61 44                       105 85 2 11   0 1     0   6   61 44                 105
708564 CO     school 802580 40   SCHOOL DISTRICT 27J 80258001822 8032 JOHN W THIMMIG ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 55 1 42   0 6     0   2   52 54                       106 55 1 42   0 6     0   2   52 54                 106
708891 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 69 8 12   1 11     0   5   49 57                       106 69 8 12   1 11     0   5   49 57                 106
712267 CO     school 803360 880   DENVER COUNTY 1 80336000391 6754 PARK HILL SCHOOL   Regular School No Elementary PK 05 2017   grade_2 67 14 20   1 0     0   4   52 54                       106 67 14 20   1 0     0   4   52 54                 106
708914 CO     school 802910 130   CHERRY CREEK 5 80291002032 243 COYOTE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 66 7 13   0 13     1   7   54 53                       107 66 7 13   0 13     1   7   54 53                 107
709098 CO     school 802910 130   CHERRY CREEK 5 80291000194 4062 HOLLY HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 28 17 43   4 4     0   11   53 54                       107 28 17 43   4 4     0   11   53 54                 107
709407 CO     school 805310 140   LITTLETON 6 80531001300 5236 LOIS LENSKI ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 87 1 7   0 3     0   9   55 52                       107 87 1 7   0 3     0   9   55 52                 107
713889 CO     school 806480 990   WIDEFIELD 3 80648001418 8392 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 59 11 26   0 3     1   7   52 55                       107 59 11 26   0 3     1   7   52 55                 107
714638 CO     school 801920 1040   ACADEMY 20 80192000005 6158 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 77 4 15   0 4     0   7   51 56                       107 77 4 15   0 4     0   7   51 56                 107
708937 CO     school 802910 130   CHERRY CREEK 5 80291000184 714 BELLEVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 51 2 13   0 35     0   7   57 51                       108 51 2 13   0 35     0   7   57 51                 108
710795 CO     school 802490 480   BOULDER VALLEY RE 2 80249000121 4874 LAFAYETTE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 75 0 20   0 5     0   8   59 49                       108 75 0 20   0 5     0   8   59 49                 108
714910 CO     school 803870 1110   FALCON 49 80387006386 4251 IMAGINE CLASSICAL ACADEMY   Regular School Yes Elementary KG 08 2017   grade_2 66 1 28   0 2     1   10   60 48                       108 66 1 28   0 2     1   10   60 48                 108
708383 CO     school 801950 30   ADAMS COUNTY 14 80195000013 2308 DUPONT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 11 1 93   1 0     0   3   62 47                       109 11 1 93   1 0     0   3   62 47                 109
708599 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006326 9426 WEST RIDGE ELEMENTARY   Regular School No Elementary PK 05 2017   grade_2 65 0 30   0 12     0   2   45 64                       109 65 0 30   0 12     0   2   45 64                 109
713943 CO     school 804080 1000   FOUNTAIN 8 80408006330 3027 EAGLESIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 56 7 31   1 2     1   11   58 51                       109 56 7 31   1 2     1   11   58 51                 109
714862 CO     school 803870 1110   FALCON 49 80387000504 1618 EVANS INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 47 10 28   0 2     0   22   46 63                       109 47 10 28   0 2     0   22   46 63                 109
719593 CO     school 806660 2770   STEAMBOAT SPRINGS RE-2 80666001145 8208 SODA CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 83 2 19   0 1     1   3   58 51                       109 83 2 19   0 1     1   3   58 51                 109
709469 CO     school 803270 170   DEER TRAIL 26J 80327000287 2136 DEER TRAIL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 7 0 3   0 0     0   1   10 1                       11 7 0 3   0 0     0   1   10 1                 11
715164 CO     school 803120 1160   COTOPAXI RE-3 80312000276 3220 COTOPAXI ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 11 0 0   0 0     0   0   4 7                       11 11 0 0   0 0     0   0   4 7                 11
716840 CO     school 802260 1450   ARRIBA-FLAGLER C-20 80226000509 2960 FLAGLER PUBLIC SCHOOL   Regular School No Other PK 12 2017   grade_2 8 0 3   0 0     0   0   7 4                       11 8 0 3   0 0     0   0   7 4                 11
716947 CO     school 803480 1520   DURANGO 9-R 80348006696 1526 COLORADO CONNECTIONS ACADEMY @ DURANGO   Regular School No Other KG 10 2017   grade_2 6 0 3   0 1     0   1   8 3                       11 6 0 3   0 1     0   1   8 3                 11
717993 CO     school 803240 1980   DE BEQUE 49JT 80324000285 2122 DE BEQUE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 9 0 1   0 1     0   0   8 3                       11 9 0 1   0 1     0   0   8 3                 11
719328 CO     school 806150 2700   PUEBLO COUNTY 70 80615001071 852 BEULAH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 10 0 1   0 0     0   0   5 6                       11 10 0 1   0 0     0   0   5 6                 11
719583 CO     school 806660 2770   STEAMBOAT SPRINGS RE-2 80666001749 6363 NORTH ROUTT CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 11 0 0   0 0     0   0   5 6                       11 11 0 0   0 0     0   0   5 6                 11
720508 CO     school 802550 3146   BRIGGSDALE RE-10 80255000142 1008 BRIGGSDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 9 0 2   0 0     0   0   6 5                       11 9 0 2   0 0     0   0   6 5                 11
720609 CO     school 800019 3230   LIBERTY J-4 80001901744 5123 LIBERTY SCHOOL   Career and Technical School No Other PK 12 2017   grade_2 9 0 2   0 0     0   0   6 5                       11 9 0 2   0 0     0   0   6 5                 11
720814 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006701 5423 MOUNTAIN VILLAGE MONTESSORI CHARTER SCHOOL   Regular School Yes Elementary PK 06 2017   grade_2 11 0 0   0 0     0   0   9 2                       11 11 0 0   0 0     0   0   9 2                 11
709324 CO     school 805310 140   LITTLETON 6 80531000878 752 FRANKLIN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 86 0 14   1 3     0   6   60 50                       110 86 0 14   1 3     0   6   60 50                 110
709281 CO     school 802910 130   CHERRY CREEK 5 80291001405 8850 TIMBERLINE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 71 10 16   1 7     0   6   57 54                       111 71 10 16   1 7     0   6   57 54                 111
709593 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000058 1948 CRAWFORD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 8 15 58   1 28     0   1   60 51                       111 8 15 58   1 28     0   1   60 51                 111
710011 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000038 6652 PAGOSA SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   grade_2 49 0 58   3 0     0   1   64 47                       111 49 0 58   3 0     0   1   64 47                 111
715190 CO     school 804260 1180   ROARING FORK RE-1 80426000582 560 BASALT ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 45 0 63   0 2     0   1   55 56                       111 45 0 63   0 2     0   1   55 56                 111
715982 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000975 4402 JEFFERSON ACADEMY ELEMENTARY   Regular School Yes Elementary KG 06 2017   grade_2 78 2 17   1 6     0   7   56 55                       111 78 2 17   1 6     0   7   56 55                 111
718043 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435002030 362 RIM ROCK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 94 0 13   0 1     0   3   55 56                       111 94 0 13   0 1     0   3   55 56                 111
708907 CO     school 802910 130   CHERRY CREEK 5 80291001670 242 ANTELOPE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 67 12 22   0 7     0   4   60 52                       112 67 12 22   0 7     0   4   60 52                 112
712294 CO     school 803360 880   DENVER COUNTY 1 80336006398 7045 PLACE BRIDGE ACADEMY   Regular School No Elementary PK 08 2017   grade_2 17 37 30   0 25     0   3   58 54                       112 17 37 30   0 25     0   3   58 54                 112
715621 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006164 950 BRADFORD PRIMARY SCHOOL   Regular School No Elementary KG 03 2017   grade_2 100 0 5   0 2     0   5   58 54                       112 100 0 5   0 2     0   5   58 54                 112
716745 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001549 9429 WEST WOODS ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_2 94 0 8   0 7     0   3   50 62                       112 94 0 8   0 7     0   3   50 62                 112
717087 CO     school 803990 1550   POUDRE R-1 80399001727 477 ZACH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 84 2 7   0 9     0   10   68 44                       112 84 2 7   0 9     0   10   68 44                 112
709771 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001789 6546 OPTIONS SCHOOL   Regular School No Other KG 12 2017   grade_2 79 1 24   0 1     0   8   60 53                       113 79 1 24   0 1     0   8   60 53                 113
711848 CO     school 803360 880   DENVER COUNTY 1 80336001776 3641 GREEN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 14 24 63   1 6     1   4   60 53                       113 14 24 63   1 6     1   4   60 53                 113
713161 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 87 1 12   0 2     0   11   54 59                       113 87 1 12   0 2     0   11   54 59                 113
713260 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 88 0 21   0 1     0   3   66 47                       113 88 0 21   0 1     0   3   66 47                 113
713987 CO     school 804080 1000   FOUNTAIN 8 80408000565 6338 PATRIOT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 50 14 35   1 1     4   8   54 59                       113 50 14 35   1 1     4   8   54 59                 113
709024 CO     school 802910 130   CHERRY CREEK 5 80291001404 1970 CREEKSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 79 8 8   0 10     0   9   50 64                       114 79 8 8   0 10     0   9   50 64                 114
709628 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006644 2673 EDNA AND JOHN W. MOSLEY P-8   Regular School No Elementary PK 08 2017   grade_2 19 19 60   1 3     3   9   62 52                       114 19 19 60   1 3     3   9   62 52                 114
712117 CO     school 803360 880   DENVER COUNTY 1 80336001276 5685 MCGLONE ACADEMY   Regular School No Elementary PK 06 2017   grade_2 3 19 90   1 0     1   0   56 58                       114 3 19 90   1 0     1   0   56 58                 114
712614 CO     school 803360 880   DENVER COUNTY 1 80336006332 9623 WILLIAM (BILL) ROBERTS K-8 SCHOOL   Regular School No Elementary PK 08 2017   grade_2 80 5 19   0 4     0   6   57 57                       114 80 5 19   0 4     0   6   57 57                 114
713193 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001339 6406 NORTHRIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 80 1 17   1 10     0   5   60 54                       114 80 1 17   1 10     0   5   60 54                 114
713230 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000444 6940 PINE LANE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_2 88 1 17   1 2     0   5   56 58                       114 88 1 17   1 2     0   5   56 58                 114
716190 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001923 5758 MEIKLEJOHN ELEMENTARY   Regular School No Elementary PK 06 2017   grade_2 97 2 11   0 2     0   2   57 57                       114 97 2 11   0 2     0   2   57 57                 114
714380 CO     school 802940 1020   CHEYENNE MOUNTAIN 12 80294001326 1582 THE VANGUARD SCHOOL (ELEMENTARY)   Regular School Yes Elementary KG 06 2017   grade_2 71 7 24   1 6     0   6   62 53                       115 71 7 24   1 6     0   6   62 53                 115
718980 CO     school 802280 2640   ASPEN 1 80228000045 428 ASPEN ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 99 0 12   0 2     1   1   56 59                       115 99 0 12   0 2     1   1   56 59                 115
720133 CO     school 807350 3100   WINDSOR RE-4 80735001263 8886 TOZER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 87 2 20   1 2     0   3   51 64                       115 87 2 20   1 2     0   3   51 64                 115
720295 CO     school 804410 3120   GREELEY 6 80441001696 2850 UNIVERSITY SCHOOLS   Regular School Yes Other KG 12 2017   grade_2 73 1 38   0 2     0   1   56 59                       115 73 1 38   0 2     0   1   56 59                 115
709017 CO     school 802910 130   CHERRY CREEK 5 80291000188 1916 COTTONWOOD CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 82 1 10   1 15     1   6   66 50                       116 82 1 10   1 15     1   6   66 50                 116

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