Data source: Big Local News · About: Big Local

7,625 rows where grade = "grade_2" and state = "CO" sorted by white descending

View and edit SQL

year

grade

  • grade_2 · 7,625
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
1135533 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006409 875 BLACK ROCK ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_2 99.0 0.0 14.0   0.0 6.0     0.0   2.0   69.0 52.0                       121.0 99 0 14   0 6     0   2   69 52                 121
1140134 CO     school 803870 1110   FALCON 49 80387001843 5779 MERIDIAN RANCH INTERNATIONAL SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 99.0 5.0 12.0   0.0 2.0     0.0   5.0   67.0 56.0                       123.0 99 5 12   0 2     0   5   67 56                 123
1140187 CO     school 803870 1110   FALCON 49 80387002000 7463 ROCKY MOUNTAIN CLASSICAL ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_2 99.0 3.0 27.0   1.0 0.0     1.0   21.0   78.0 74.0                       152.0 99 3 27   1 0     1   21   78 74                 152
1140228 CO     school 803870 1110   FALCON 49 80387001686 9706 WOODMEN HILLS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 99.0 3.0 19.0   0.0 1.0     0.0   8.0   60.0 70.0                       130.0 99 3 19   0 1     0   8   60 70                 130
1145760 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes 4.0 PK 12 2015   grade_2 99.0 0.0 29.0   0.0 10.0     0.0   4.0   66.0 76.0                       142.0 99 0 29   0 10     0   4   66 76                 142
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
835644 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   59 MERIDIAN ELEMENTARY SCHOOL             2016   grade_2 99 2 14   0 6     0   6   61 66                       127 99 2 14   0 6     0   6   61 66                 127
836560 CO     school   130   CHERRY CREEK 5   243 COYOTE HILLS ELEMENTARY SCHOOL             2016   grade_2 99 1 12   1 11     0   8   71 61                       132 99 1 12   1 11     0   8   71 61                 132
1805975 CO     school 802940 1020   Cheyenne Mountain 12 80294001326 1582 The Vanguard School (Elementary)   Regular School Yes Elementary KG 06 2020   grade_2 99 2 34   1 8     1   15   79 81                       160 99 2 34   1 8     1   15   79 81                 160
1940053 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001549 9429 WEST WOODS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 99 1 1   0 2     0   3   55 51                       106 99 1 1   0 2     0   3   55 51                 106
1138503 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No 1.0 PK 02 2015   grade_2 98.0 1.0 21.0   0.0 2.0     1.0   5.0   68.0 60.0                       128.0 98 1 21   0 2     1   5   68 60                 128
840790 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No 1.0 PK 02 2016   grade_2 98 4 11   1 0     0   6   63 57                       120 98 4 11   1 0     0   6   63 57                 120
848192 CO     school   8001   CHARTER SCHOOL INSTITUTE   15 ACADEMY OF CHARTER SCHOOLS             2016   grade_2 98 2 25   0 8     0   7   71 69                       140 98 2 25   0 8     0   7   71 69                 140
1808739 CO     school 803990 1550   Poudre R-1 80399006380 498 Bethke Elementary School   Regular School No Elementary KG 05 2020   grade_2 98 0 8   1 3     0   5   56 59                       115 98 0 8   1 3     0   5   56 59                 115
1902665 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001807 9427 WOODROW WILSON CHARTER ACADEMY   Regular School Yes Elementary PK 08 2018   grade_2 98 0 18   0 5     0   6   62 65                       127 98 0 18   0 5     0   6   62 65                 127
1905977 CO     school 803600 3085   EATON RE-2 80360000474 2448 EATON ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2018   grade_2 98 0 25   0 0     0   5   68 60                       128 98 0 25   0 0     0   5   68 60                 128
1932658 CO     school 805310 140   LITTLETON 6 80531000893 9600 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 98 1 8   0 1     0   2   54 56                       110 98 1 8   0 1     0   2   54 56                 110
1138002 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006392 265 CLEAR SKY ELEMENTARY   Regular School No 1.0 PK 06 2015   grade_2 97.0 0.0 18.0   1.0 1.0     0.0   6.0   59.0 64.0                       123.0 97 0 18   1 1     0   6   59 64                 123
1138473 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000444 6940 PINE LANE ELEMENTARY   Regular School No 1.0 PK 06 2015   grade_2 97.0 0.0 25.0   0.0 6.0     0.0   2.0   59.0 71.0                       130.0 97 0 25   0 6     0   2   59 71                 130
1145171 CO     school 803600 3085   EATON RE-2 80360000474 2448 EATON ELEMENTARY SCHOOL   Regular School No 1.0 PK 02 2015   grade_2 97.0 0.0 24.0   0.0 0.0     0.0   7.0   65.0 63.0                       128.0 97 0 24   0 0     0   7   65 63                 128
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
717034 CO     school 802400 1530   BAYFIELD 10 JT-R 80240000088 632 BAYFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 97 1 14   1 1     0   6   68 52                       120 97 1 14   1 1     0   6   68 52                 120
837107 CO     school 805310 140   LITTLETON 6 80531000893 9600 WILDER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 97 0 13   0 3     0   3   64 52                       116 97 0 13   0 3     0   3   64 52                 116
1942284 CO     school 802280 2640   ASPEN 1 80228000045 428 ASPEN ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2019   grade_2 97 0 10   1 1     0   1   48 62                       110 97 0 10   1 1     0   1   48 62                 110
1138415 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006152 6152 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No 1.0 PK 02 2015   grade_2 96.0 2.0 16.0   0.0 0.0     0.0   4.0   64.0 54.0                       118.0 96 2 16   0 0     0   4   64 54                 118
1139991 CO     school 805820 1080   LEWIS-PALMER 38 80582001371 3539 BEAR CREEK ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 96.0 1.0 13.0   2.0 0.0     0.0   2.0   61.0 53.0                       114.0 96 1 13   2 0     0   2   61 53                 114
1141906 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001807 9427 WOODROW WILSON CHARTER ACADEMY   Regular School Yes 1.0 PK 08 2015   grade_2 96.0 0.0 10.0   0.0 1.0     0.0   6.0   52.0 61.0                       113.0 96 0 10   0 1     0   6   52 61                 113
842388 CO     school 805820 1080   LEWIS-PALMER 38 80582001371 3539 BEAR CREEK ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 96 2 14   1 1     0   6   69 51                       120 96 2 14   1 1     0   6   69 51                 120
709461 CO     school 805310 140   LITTLETON 6 80531000893 9600 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 95 0 14   0 6     0   3   53 65                       118 95 0 14   0 6     0   3   53 65                 118
847600 CO     school 803600 3085   EATON RE-2 80360000474 2448 EATON ELEMENTARY SCHOOL   Regular School No 1.0 PK 02 2016   grade_2 95 0 35   0 1     0   2   76 57                       133 95 0 35   0 1     0   2   76 57                 133
1895097 CO     school 802910 130   CHERRY CREEK 5 80291006452 6955 PINE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 95 10 14   1 13     1   10   73 71                       144 95 10 14   1 13     1   10   73 71                 144
1903859 CO     school 806690 1828   VALLEY RE-1 80669006339 515 AYRES ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2018   grade_2 95 4 41   0 0     1   4   86 59                       145 95 4 41   0 0     1   4   86 59                 145
1135694 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006531 5181 RED HAWK ELEMENTARY   Regular School No 1.0 PK 05 2015   grade_2 94.0 0.0 14.0   0.0 1.0     0.0   5.0   55.0 59.0                       114.0 94 0 14   0 1     0   5   55 59                 114
1140809 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000701 776 BERGEN MEADOW PRIMARY SCHOOL   Regular School No 1.0 PK 02 2015   grade_2 94.0 1.0 3.0   0.0 1.0     0.0   2.0   52.0 49.0                       101.0 94 1 3   0 1     0   2   52 49                 101
707979 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001733 59 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 94 2 15   1 5     1   4   72 50                       122 94 2 15   1 5     1   4   72 50                 122
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
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
1750475 CO     school 803600 3085   Eaton RE-2 80360000474 2448 Eaton Elementary School   Regular School No Elementary PK 02 2021   grade_2 94 0 30   2 2     0   0   61 67                       128 94 0 30   2 2     0   0   61 67                 128
720030 CO     school 803600 3085   EATON RE-2 80360000474 2448 EATON ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 93 0 22   0 1     0   5   62 59                       121 93 0 22   0 1     0   5   62 59                 121
836852 CO     school 802910 130   CHERRY CREEK 5 80291006452 6955 PINE RIDGE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 93 5 18   1 10     0   5   67 65                       132 93 5 18   1 10     0   5   67 65                 132
844325 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001807 9427 WOODROW WILSON CHARTER ACADEMY   Regular School Yes 1.0 PK 08 2016   grade_2 93 0 13   0 0     0   8   59 55                       114 93 0 13   0 0     0   8   59 55                 114
1742822 CO     school 803360 880   Denver County 1 80336000391 6754 Park Hill School   Regular School No Elementary PK 05 2021   grade_2 93 8 8   0 1     0   4   56 58                       114 93 8 8   0 1     0   4   56 58                 114
1900891 CO     school 803870 1110   FALCON 49 80387001898 7339 RIDGEVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 93 5 23   1 2     1   11   65 71                       136 93 5 23   1 2     1   11   65 71                 136
1901910 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000975 4402 JEFFERSON ACADEMY ELEMENTARY   Regular School Yes Elementary KG 06 2018   grade_2 93 2 7   0 0     0   9   62 49                       111 93 2 7   0 0     0   9   62 49                 111
1140123 CO     school 803870 1110   FALCON 49 80387006386 4251 IMAGINE INDIGO RANCH   Regular School Yes 1.0 KG 08 2015   grade_2 92.0 1.0 21.0   1.0 0.0     0.0   13.0   57.0 71.0                       128.0 92 1 21   1 0     0   13   57 71                 128
1142269 CO     school 803990 1550   POUDRE R-1 80399006380 498 BETHKE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 92.0 1.0 8.0   0.0 3.0     0.0   2.0   47.0 59.0                       106.0 92 1 8   0 3     0   2   47 59                 106
843575 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000975 4402 JEFFERSON ACADEMY ELEMENTARY   Regular School Yes 1.0 KG 06 2016   grade_2 92 2 13   0 2     0   2   48 63                       111 92 2 13   0 2     0   2   48 63                 111
1750577 CO     school 807350 3100   Windsor RE-4 80735001263 8886 Tozer Elementary School   Regular School No Elementary PK 02 2021   grade_2 92 0 34   0 1     0   2   50 79                       129 92 0 34   0 1     0   2   50 79                 129
1803841 CO     school 803360 880   Denver County 1 80336000391 6754 Park Hill School   Regular School No Elementary PK 05 2020   grade_2 92 8 11   1 1     0   10   59 64                       123 92 8 11   1 1     0   10   59 64                 123
1804674 CO     school 803450 900   Douglas County Re 1 80345006472 5607 Sage Canyon Elementary   Regular School No Elementary PK 06 2020   grade_2 92 0 8   0 0     0   5   60 45                       105 92 0 8   0 0     0   5   60 45                 105
1804713 CO     school 803450 900   Douglas County Re 1 80345006588 6019 Aspen View Academy   Regular School Yes Elementary PK 08 2020   grade_2 92 0 11   0 2     0   3   60 48                       108 92 0 11   0 2     0   3   60 48                 108
1896113 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006409 875 BLACK ROCK ELEMENTARY   Regular School No Elementary PK 05 2018   grade_2 92 1 11   0 5     0   6   51 64                       115 92 1 11   0 5     0   6   51 64                 115
1900944 CO     school 803870 1110   FALCON 49 80387001686 9706 WOODMEN HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 92 4 16   0 0     0   10   63 59                       122 92 4 16   0 0     0   10   63 59                 122
1943944 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_2 92 1 37   0 6     0   4   75 65                       140 92 1 37   0 6     0   4   75 65                 140
1134569 CO     school 802910 130   CHERRY CREEK 5 80291006452 6955 PINE RIDGE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 91.0 3.0 19.0   2.0 10.0     0.0   12.0   71.0 66.0                       137.0 91 3 19   2 10     0   12   71 66                 137
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
844687 CO     school   1550   POUDRE R-1   498 BETHKE ELEMENTARY SCHOOL             2016   grade_2 91 1 5   0 1     3   2   56 47                       103 91 1 5   0 1     3   2   56 47                 103
845616 CO     school   2000   MESA COUNTY VALLEY 51   362 RIM ROCK ELEMENTARY SCHOOL             2016   grade_2 91 1 16   0 0     1   0   52 57                       109 91 1 16   0 0     1   0   52 57                 109
1806405 CO     school 805820 1080   Lewis-Palmer 38 80582001371 3539 Bear Creek Elementary School   Regular School No Elementary PK 06 2020   grade_2 91 0 18   1 2     0   7   59 60                       119 91 0 18   1 2     0   7   59 60                 119
1935521 CO     school 803360 880   DENVER COUNTY 1 80336000391 6754 PARK HILL SCHOOL   Regular School No Elementary PK 05 2019   grade_2 91 6 6   1 2     0   4   49 61                       110 91 6 6   1 2     0   4   49 61                 110
1936378 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006472 5607 SAGE CANYON ELEMENTARY   Regular School No Elementary PK 06 2019   grade_2 91 1 9   0 1     1   6   65 44                       109 91 1 9   0 1     1   6   65 44                 109
1940785 CO     school 803990 1550   POUDRE R-1 80399000527 9370 EYESTONE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 91 1 16   0 0     0   1   54 55                       109 91 1 16   0 0     0   1   54 55                 109
1138405 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006588 6019 ASPEN VIEW ACADEMY   Regular School Yes 1.0 PK 07 2015   grade_2 90.0 0.0 9.0   0.0 1.0     0.0   4.0   54.0 50.0                       104.0 90 0 9   0 1     0   4   54 50                 104
1140178 CO     school 803870 1110   FALCON 49 80387001898 7339 RIDGEVIEW ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 90.0 9.0 29.0   1.0 4.0     0.0   13.0   75.0 71.0                       146.0 90 9 29   1 4     0   13   75 71                 146
714921 CO     school 803870 1110   FALCON 49 80387001843 5779 MERIDIAN RANCH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 90 6 10   1 3     0   8   63 55                       118 90 6 10   1 3     0   8   63 55                 118
841019 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001639 9592 WILDCAT MOUNTAIN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 90 0 8   0 10     0   5   58 55                       113 90 0 8   0 10     0   5   58 55                 113
1747242 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2021   grade_2 90 1 13   0 1     0   4   62 47                       109 90 1 13   0 1     0   4   62 47                 109
1935845 CO     school 803360 880   DENVER COUNTY 1 80336001957 9425 WESTERLY CREEK ELEMENTARY   Regular School No Elementary PK 05 2019   grade_2 90 7 14   0 3     0   4   69 49                       118 90 7 14   0 3     0   4   69 49                 118
1133256 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No 1.0 PK 08 2015   grade_2 9.0 0.0 42.0   0.0 1.0     0.0   3.0   37.0 18.0                       55.0 9 0 42   0 1     0   3   37 18                 55
1133493 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001176 2918 FEDERAL HEIGHTS ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 9.0 0.0 93.0   1.0 0.0     0.0   0.0   46.0 57.0                       103.0 9 0 93   1 0     0   0   46 57                 103
1134095 CO     school 807230 70   WESTMINSTER 50 80723001363 7810 FLYNN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 9.0 0.0 28.0   0.0 4.0     0.0   5.0   25.0 21.0                       46.0 9 0 28   0 4     0   5   25 21                 46
1134114 CO     school 807230 70   WESTMINSTER 50 80723001247 7952 SKYLINE VISTA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 9.0 0.0 42.0   0.0 3.0     0.0   0.0   29.0 25.0                       54.0 9 0 42   0 3     0   0   29 25                 54
1134983 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000061 2618 ELKHART ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 9.0 21.0 93.0   2.0 4.0     1.0   4.0   73.0 61.0                       134.0 9 21 93   2 4     1   4   73 61                 134
1135589 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001373 1844 COLUMBINE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 9.0 0.0 48.0   0.0 0.0     0.0   0.0   30.0 27.0                       57.0 9 0 48   0 0     0   0   30 27                 57
1135816 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000921 7464 ROCKY MOUNTAIN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 9.0 1.0 51.0   0.0 0.0     0.0   0.0   35.0 26.0                       61.0 9 1 51   0 0     0   0   35 26                 61
1137146 CO     school 803360 880   DENVER COUNTY 1 80336001776 3641 GREEN VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 9.0 40.0 52.0   2.0 2.0     0.0   6.0   62.0 49.0                       111.0 9 40 52   2 2     0   6   62 49                 111
1138732 CO     school 803540 910   EAGLE COUNTY RE 50 80354006366 4838 JUNE CREEK ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 9.0 2.0 38.0   3.0 0.0     0.0   0.0   20.0 32.0                       52.0 9 2 38   3 0     0   0   20 32                 52
1143098 CO     school 803930 1850   FRENCHMAN RE-3 80393000511 2980 FLEMING ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 9.0 1.0 0.0   0.0 0.0     0.0   1.0   5.0 6.0                       11.0 9 1 0   0 0     0   1   5 6                 11
1144182 CO     school 804680 2670   HOLLY RE-3 80468000682 7794 HOLLY ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 9.0 0.0 6.0   0.0 0.0     0.0   0.0   9.0 6.0                       15.0 9 0 6   0 0     0   0   9 6                 15
1144314 CO     school 806120 2690   PUEBLO CITY 60 80612001041 2438 EVA R BACA ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 9.0 1.0 42.0   0.0 0.0     0.0   2.0   23.0 31.0                       54.0 9 1 42   0 0     0   2   23 31                 54
1144395 CO     school 806120 2690   PUEBLO CITY 60 80612001060 6770 PARK VIEW ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 9.0 2.0 62.0   0.0 0.0     0.0   0.0   36.0 37.0                       73.0 9 2 62   0 0     0   0   36 37                 73
1144812 CO     school 805700 2800   MOFFAT 2 80570000974 5958 MOFFAT PREK-12 SCHOOL   Regular School No 4.0 PK 12 2015   grade_2 9.0 0.0 0.0   0.0 0.0     0.0   0.0   3.0 6.0                       9.0 9 0 0   0 0     0   0   3 6                 9
707853 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_2 9 1 39   0 2     0   0   27 24                       51 9 1 39   0 2     0   0   27 24                 51
707957 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2017   grade_2 9 0 45   0 0     0   0   24 30                       54 9 0 45   0 0     0   0   24 30                 54
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
708166 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001182 5706 MC ELWAIN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 9 2 51   0 0     0   1   32 31                       63 9 2 51   0 0     0   1   32 31                 63
708860 CO     school 803780 120   ENGLEWOOD 1 80378000497 9620 WM E BISHOP ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_2 9 0 13   0 2     1   4   15 14                       29 9 0 13   0 2     1   4   15 14                 29
709905 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000081 9140 VIRGINIA COURT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 9 10 59   0 1     0   3   48 34                       82 9 10 59   0 1     0   3   48 34                 82
712158 CO     school 803360 880   DENVER COUNTY 1 80336000384 6002 MONTCLAIR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 9 31 21   3 1     0   5   43 27                       70 9 31 21   3 1     0   5   43 27                 70
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
713690 CO     school 804530 980   HARRISON 2 80453000665 3392 GIBERSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 9 12 45   0 0     0   2   38 30                       68 9 12 45   0 0     0   2   38 30                 68
716563 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000785 8248 EMORY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 9 3 79   0 1     0   2   39 55                       94 9 3 79   0 1     0   2   39 55                 94
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
717869 CO     school 804740 1780   GENOA-HUGO C113 80474000686 4162 GENOA-HUGO SCHOOL   Regular School No Other PK 12 2017   grade_2 9 0 0   0 0     0   0   6 3                       9 9 0 0   0 0     0   0   6 3                 9
717977 CO     school 806030 1870   PLATEAU RE-5 80603001022 6834 PEETZ ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 9 0 0   0 0     0   0   4 5                       9 9 0 0   0 0     0   0   4 5                 9
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
718463 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309000838 5436 MANAUGH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 9 0 13   27 0     0   0   29 20                       49 9 0 13   27 0     0   0   29 20                 49
720324 CO     school 804410 3120   GREELEY 6 80441001291 4356 JACKSON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 9 1 63   1 5     0   1   36 44                       80 9 1 63   1 5     0   1   36 44                 80
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

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