Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_2 · 7,525
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
1931378 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006507 6802 PROSPECT RIDGE ACADEMY   Regular School Yes Other KG 12 2019   grade_2 79 1 4   0 8     0   8   47 53                       100 79 1 4   0 8     0   8   47 53                 100
1937082 CO     school 804530 980   HARRISON 2 80453001965 8034 SOARING EAGLES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 36 13 36   2 4     0   9   47 53                       100 36 13 36   2 4     0   9   47 53                 100
1133611 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006507 6802 PROSPECT RIDGE ACADEMY   Regular School Yes 4.0 KG 09 2015   grade_2 85.0 0.0 5.0   0.0 9.0     0.0   1.0   45.0 55.0                       100.0 85 0 5   0 9     0   1   45 55                 100
1134322 CO     school 802910 130   CHERRY CREEK 5 80291001831 1273 CANYON CREEK ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 54.0 11.0 21.0   0.0 8.0     0.0   6.0   58.0 42.0                       100.0 54 11 21   0 8     0   6   58 42                 100
1134381 CO     school 802910 130   CHERRY CREEK 5 80291001297 1614 CIMARRON ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 38.0 23.0 25.0   0.0 1.0     1.0   12.0   59.0 41.0                       100.0 38 23 25   0 1     1   12   59 41                 100
1134822 CO     school 805310 140   LITTLETON 6 80531000893 9600 WILDER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 85.0 0.0 7.0   1.0 3.0     0.0   4.0   43.0 57.0                       100.0 85 0 7   1 3     0   4   43 57                 100
1135230 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000080 9060 VAUGHN ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 5.0 20.0 67.0   2.0 1.0     0.0   5.0   48.0 52.0                       100.0 5 20 67   2 1     0   5   48 52                 100
1136123 CO     school 802490 480   BOULDER VALLEY RE 2 80249000121 4874 LAFAYETTE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 72.0 2.0 9.0   1.0 7.0     1.0   8.0   50.0 50.0                       100.0 72 2 9   1 7     1   8   50 50                 100
1137117 CO     school 803360 880   DENVER COUNTY 1 80336000355 3512 GOLDRICK ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 4.0 3.0 88.0   1.0 4.0     0.0   0.0   52.0 48.0                       100.0 4 3 88   1 4     0   0   52 48                 100
1138366 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006472 5607 SAGE CANYON ELEMENTARY   Regular School No 1.0 PK 06 2015   grade_2 82.0 1.0 13.0   0.0 1.0     0.0   3.0   50.0 50.0                       100.0 82 1 13   0 1     0   3   50 50                 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
835702 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001305 1914 COTTON CREEK ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 69 2 21   0 4     1   4   61 40                       101 69 2 21   0 4     1   4   61 40                 101
836235 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000151 8130 SOUTHEAST ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 41 1 55   1 0     0   3   61 40                       101 41 1 55   1 0     0   3   61 40                 101
837499 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001324 8858 TOLLGATE ELEMENTARY SCHOOL OF EXPEDITIONARY LEARNING   Regular School No 1.0 KG 05 2016   grade_2 12 26 47   1 6     2   7   50 51                       101 12 26 47   1 6     2   7   50 51                 101
837794 CO     school   470   ST VRAIN VALLEY RE 1J   60 LEGACY ELEMENTARY SCHOOL             2016   grade_2 86 0 12   0 1     0   2   57 44                       101 86 0 12   0 1     0   2   57 44                 101
846543 CO     school   2640   ASPEN 1   428 ASPEN ELEMENTARY SCHOOL             2016   grade_2 81 3 14   0 0     1   2   60 41                       101 81 3 14   0 0     1   2   60 41                 101
846812 CO     school 806120 2690   PUEBLO CITY 60 80612001058 6132 MORTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 31 3 63   0 1     1   2   59 42                       101 31 3 63   0 1     1   2   59 42                 101
1750815 CO     school 804410 3120   Greeley 6 80441001483 5660 S. Christa McAuliffe STEM Academy   Regular School No Elementary KG 08 2021   grade_2 47 1 48   0 4     0   1   60 41                       101 47 1 48   0 4     0   1   60 41                 101
1800096 CO     school 802580 40   School District 27J 80258006326 9426 West Ridge Elementary   Regular School No Elementary PK 05 2020   grade_2 58 1 31   0 7     0   4   48 53                       101 58 1 31   0 7     0   4   48 53                 101
1803685 CO     school 803360 880   Denver County 1 80336001276 5685 McGlone Academy   Regular School No Elementary PK 08 2020   grade_2 3 16 70   0 2     9   1   49 52                       101 3 16 70   0 2     9   1   49 52                 101
1804280 CO     school 803450 900   Douglas County Re 1 80345006492 135 Ben Franklin Academy   Regular School Yes Elementary PK 08 2020   grade_2 77 0 12   2 7     0   3   46 55                       101 77 0 12   2 7     0   3   46 55                 101
1804740 CO     school 803450 900   Douglas County Re 1 80345006455 6365 Skyview Academy   Regular School Yes Other PK 12 2020   grade_2 55 2 11   1 23     0   9   51 50                       101 55 2 11   1 23     0   9   51 50                 101
1895112 CO     school 802910 130   CHERRY CREEK 5 80291000200 7116 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 27 23 27   0 5     1   18   58 43                       101 27 23 27   0 5     1   18   58 43                 101
1896565 CO     school 802490 480   BOULDER VALLEY RE 2 80249000110 1996 CREST VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 66 2 23   0 3     0   7   55 46                       101 66 2 23   0 3     0   7   55 46                 101
1897624 CO     school 803360 880   DENVER COUNTY 1 80336000340 2506 EDISON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 70 2 23   0 2     0   4   54 47                       101 70 2 23   0 2     0   4   54 47                 101
1899165 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000445 7096 ROXBOROUGH ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2018   grade_2 80 0 16   0 0     1   4   47 54                       101 80 0 16   0 0     1   4   47 54                 101
1899885 CO     school 804080 1000   FOUNTAIN 8 80408001481 4474 JORDAHL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 56 3 28   0 0     0   14   58 43                       101 56 3 28   0 0     0   14   58 43                 101
1931600 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006549 1013 BRANTNER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 64 1 24   0 8     0   4   45 56                       101 64 1 24   0 8     0   4   45 56                 101
1932136 CO     school 802910 130   CHERRY CREEK 5 80291006301 1155 BUFFALO TRAIL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 51 12 18   0 3     0   17   47 54                       101 51 12 18   0 3     0   17   47 54                 101
1934515 CO     school 803330 870   DELTA COUNTY 50(J) 80333000301 5154 LINCOLN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 64 0 29   1 4     0   3   47 54                       101 64 0 29   1 4     0   3   47 54                 101
1936362 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006493 5259 STEM SCHOOL HIGHLANDS RANCH   Regular School Yes Other KG 12 2019   grade_2 48 1 17   1 27     0   7   58 43                       101 48 1 17   1 27     0   7   58 43                 101
1943540 CO     school 804410 3120   GREELEY 6 80441001990 54 BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY   Regular School No Elementary KG 08 2019   grade_2 10 10 80   0 1     0   0   61 40                       101 10 10 80   0 1     0   0   61 40                 101
1134474 CO     school 802910 130   CHERRY CREEK 5 80291000195 4078 HOMESTEAD ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 70.0 3.0 10.0   2.0 13.0     0.0   3.0   49.0 52.0                       101.0 70 3 10   2 13     0   3   49 52                 101
1136728 CO     school 803360 880   DENVER COUNTY 1 80336000319 1076 BROWN INTERNATIONAL ACADEMY   Regular School No 1.0 PK 05 2015   grade_2 45.0 1.0 48.0   1.0 3.0     0.0   3.0   50.0 51.0                       101.0 45 1 48   1 3     0   3   50 51                 101
1139075 CO     school 806480 990   WIDEFIELD 3 80648001121 5602 MARTIN LUTHER KING JR ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 59.0 7.0 19.0   0.0 0.0     2.0   14.0   49.0 52.0                       101.0 59 7 19   0 0     2   14   49 52                 101
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
1142631 CO     school 803990 1550   POUDRE R-1 80399001440 9380 WERNER ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 78.0 2.0 9.0   0.0 7.0     0.0   5.0   56.0 45.0                       101.0 78 2 9   0 7     0   5   56 45                 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
836672 CO     school 802910 130   CHERRY CREEK 5 80291001404 1970 CREEKSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 60 7 20   1 7     0   7   56 46                       102 60 7 20   1 7     0   7   56 46                 102
836879 CO     school 802910 130   CHERRY CREEK 5 80291001880 7277 RED HAWK RIDGE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 40 9 21   0 17     0   15   53 49                       102 40 9 21   0 17     0   15   53 49                 102
843224 CO     school   1420   JEFFERSON COUNTY R-1   950 BRADFORD PRIMARY SCHOOL             2016   grade_2 87 1 9   0 2     0   3   47 55                       102 87 1 9   0 2     0   3   47 55                 102
843316 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001447 1876 CORONADO ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 86 0 12   0 2     0   2   57 45                       102 86 0 12   0 2     0   2   57 45                 102
844160 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000785 8248 STEIN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 8 2 90   0 0     0   2   57 45                       102 8 2 90   0 0     0   2   57 45                 102
845054 CO     school 803990 1550   POUDRE R-1 80399001440 9380 WERNER ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 82 0 9   0 5     0   6   40 62                       102 82 0 9   0 5     0   6   40 62                 102
1739502 CO     school 802910 130   Cherry Creek 5 80291001404 1970 Creekside Elementary School   Regular School No Elementary PK 05 2021   grade_2 67 5 12   0 14     0   4   51 51                       102 67 5 12   0 14     0   4   51 51                 102
1739722 CO     school 802910 130   Cherry Creek 5 80291001514 7476 Rolling Hills Elementary School   Regular School No Elementary PK 05 2021   grade_2 68 7 10   1 11     0   5   52 50                       102 68 7 10   1 11     0   5   52 50                 102
1743238 CO     school 803450 900   Douglas County Re 1 80345006492 135 Ben Franklin Academy   Regular School Yes Elementary PK 08 2021   grade_2 77 2 14   0 3     0   6   58 44                       102 77 2 14   0 3     0   6   58 44                 102
1744497 CO     school 804080 1000   Fountain 8 80408006481 9610 Weikel Elementary School   Regular School No Elementary PK 05 2021   grade_2 61 4 24   1 3     2   7   44 58                       102 61 4 24   1 3     2   7   44 58                 102
1747150 CO     school 804800 1420   Jefferson County R-1 80480006722 8856 Three Creeks K-8   Regular School No Elementary KG 08 2021   grade_2 76 1 13   1 5     0   6   55 47                       102 76 1 13   1 5     0   6   55 47                 102
1747621 CO     school 803990 1550   Poudre R-1 80399006380 498 Bethke Elementary School   Regular School No Elementary KG 05 2021   grade_2 87 0 7   0 4     0   4   48 54                       102 87 0 7   0 4     0   4   48 54                 102
1805366 CO     school 804530 980   Harrison 2 80453001965 8034 Soaring Eagles Elementary School   Regular School No Elementary PK 05 2020   grade_2 20 15 51   1 3     5   7   51 51                       102 20 15 51   1 3     5   7   51 51                 102
1893908 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001305 1914 COTTON CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 71 1 22   2 3     0   3   47 55                       102 71 1 22   2 3     0   3   47 55                 102
1897744 CO     school 803360 880   DENVER COUNTY 1 80336001776 3641 GREEN VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 13 17 58   1 5     3   5   50 52                       102 13 17 58   1 5     3   5   50 52                 102
1897781 CO     school 803360 880   DENVER COUNTY 1 80336000359 3704 GUST ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 6 2 90   0 4     0   0   48 54                       102 6 2 90   0 4     0   0   48 54                 102
1898500 CO     school 803360 880   DENVER COUNTY 1 80336001957 9425 WESTERLY CREEK ELEMENTARY   Regular School No Elementary PK 05 2018   grade_2 71 4 11   1 5     0   10   39 63                       102 71 4 11   1 5     0   10   39 63                 102
1898648 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006392 265 CLEAR SKY ELEMENTARY   Regular School No Elementary PK 06 2018   grade_2 73 1 25   0 1     0   2   55 47                       102 73 1 25   0 1     0   2   55 47                 102
1899855 CO     school 804080 1000   FOUNTAIN 8 80408006330 3027 EAGLESIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 51 9 24   2 0     2   14   52 50                       102 51 9 24   2 0     2   14   52 50                 102
1903372 CO     school 803990 1550   POUDRE R-1 80399000547 8460 TAVELLI ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 78 0 21   2 0     0   1   62 40                       102 78 0 21   2 0     0   1   62 40                 102
1932087 CO     school 802910 130   CHERRY CREEK 5 80291006750 102 ALTITUDE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 61 7 19   2 7     0   6   49 53                       102 61 7 19   2 7     0   6   49 53                 102
1932416 CO     school 802910 130   CHERRY CREEK 5 80291000200 7116 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 26 28 28   0 3     0   17   55 47                       102 26 28 28   0 3     0   17   55 47                 102
1933663 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006594 6010 TIMBERLINE PK-8   Regular School No Elementary PK 08 2019   grade_2 14 0 87   0 0     0   1   46 56                       102 14 0 87   0 0     0   1   46 56                 102
1937603 CO     school 803060 1010   COLORADO SPRINGS 11 80306001641 7705 SCOTT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 60 6 22   3 0     1   10   57 45                       102 60 6 22   3 0     1   10   57 45                 102
1938295 CO     school 803870 1110   DISTRICT 49 80387001537 7317 REMINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 50 4 32   1 1     0   14   64 38                       102 50 4 32   1 1     0   14   64 38                 102
1941366 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435002030 362 RIM ROCK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 78 1 15   0 0     0   8   40 62                       102 78 1 15   0 0     0   8   40 62                 102
1133417 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001174 1878 CORONADO HILLS ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 14.0 0.0 85.0   0.0 2.0     0.0   1.0   53.0 49.0                       102.0 14 0 85   0 2     0   1   53 49                 102
1134768 CO     school 805310 140   LITTLETON 6 80531001300 5236 LOIS LENSKI ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 84.0 3.0 8.0   0.0 1.0     0.0   6.0   62.0 40.0                       102.0 84 3 8   0 1     0   6   62 40                 102
1135490 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001830 60 LEGACY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 73.0 2.0 19.0   0.0 2.0     0.0   6.0   56.0 46.0                       102.0 73 2 19   0 2     0   6   56 46                 102
1138268 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001875 3241 FRONTIER VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 80.0 2.0 9.0   1.0 2.0     0.0   8.0   54.0 48.0                       102.0 80 2 9   1 2     0   8   54 48                 102
1143883 CO     school 805130 2520   EAST OTERO R-1 80513001975 4843 LA JUNTA PRIMARY SCHOOL   Regular School No 1.0 KG 02 2015   grade_2 29.0 0.0 72.0   1.0 0.0     0.0   0.0   58.0 44.0                       102.0 29 0 72   1 0     0   0   58 44                 102
1145518 CO     school 804410 3120   GREELEY 6 80441000633 6774 MARTINEZ ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 4.0 2.0 92.0   0.0 4.0     0.0   0.0   44.0 58.0                       102.0 4 2 92   0 4     0   0   44 58                 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
836183 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000149 6395 NORTHEAST ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 31 2 66   1 1     0   2   50 53                       103 31 2 66   1 1     0   2   50 53                 103
837474 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001432 7865 SIDE CREEK ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 23 22 41   0 6     0   11   51 52                       103 23 22 41   0 6     0   11   51 52                 103
840224 CO     school 803360 880   DENVER COUNTY 1 80336000424 9496 CASTRO ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 2 2 96   1 2     0   0   49 54                       103 2 2 96   1 2     0   0   49 54                 103
840328 CO     school   900   DOUGLAS COUNTY RE 1   12 ACRES GREEN ELEMENTARY SCHOOL             2016   grade_2 49 1 19   0 23     0   11   58 45                       103 49 1 19   0 23     0   11   58 45                 103
840779 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006588 6019 ASPEN VIEW ACADEMY   Regular School Yes 1.0 PK 08 2016   grade_2 86 0 10   0 2     1   4   56 47                       103 86 0 10   0 2     1   4   56 47                 103
840807 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006455 6365 SKYVIEW ACADEMY   Regular School Yes 4.0 PK 12 2016   grade_2 74 0 3   0 16     0   10   53 50                       103 74 0 3   0 16     0   10   53 50                 103
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
847160 CO     school 806660 2770   STEAMBOAT SPRINGS RE-2 80666001145 8208 SODA CREEK ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 86 2 14   0 0     1   0   43 60                       103 86 2 14   0 0     1   0   43 60                 103
847959 CO     school 804410 3120   GREELEY 6 80441000649 7700 SCOTT ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 25 2 71   0 2     0   3   58 45                       103 25 2 71   0 2     0   3   58 45                 103
1739946 CO     school 805310 140   Littleton 6 80531000893 9600 Wilder Elementary School   Regular School No Elementary PK 05 2021   grade_2 78 1 13   0 7     0   4   46 57                       103 78 1 13   0 7     0   4   46 57                 103
1741042 CO     school 805370 470   St Vrain Valley RE1J 80537006739 8055 Soaring Heights PK-8   Regular School No Elementary PK 08 2021   grade_2 84 2 9   0 6     0   2   57 46                       103 84 2 9   0 6     0   2   57 46                 103
1745320 CO     school 805820 1080   Lewis-Palmer 38 80582001371 3539 Bear Creek Elementary School   Regular School No Elementary PK 06 2021   grade_2 83 3 10   1 1     0   5   56 47                       103 83 3 10   1 1     0   5   56 47                 103
1749176 CO     school 805130 2520   East Otero R-1 80513001975 4843 La Junta Primary School   Regular School No Elementary KG 02 2021   grade_2 29 0 71   0 2     1   0   55 48                       103 29 0 71   0 2     1   0   55 48                 103
1800464 CO     school 802910 130   Cherry Creek 5 80291006301 1155 Buffalo Trail Elementary School   Regular School No Elementary PK 06 2020   grade_2 51 10 19   0 9     0   14   56 47                       103 51 10 19   0 9     0   14   56 47                 103
1801311 CO     school 802340 180   Adams-Arapahoe 28J 80234001789 6546 Options School   Regular School No Other KG 12 2020   grade_2 69 5 19   0 4     0   6   54 49                       103 69 5 19   0 4     0   6   54 49                 103
1804820 CO     school 803450 900   Douglas County Re 1 80345000445 7096 Roxborough Elementary School   Regular School No Elementary PK 02 2020   grade_2 88 0 9   0 2     0   4   53 50                       103 88 0 9   0 2     0   4   53 50                 103
1806245 CO     school 801920 1040   Academy 20 80192000005 6158 Mountain View Elementary School   Regular School No Elementary KG 05 2020   grade_2 75 3 13   0 6     1   5   53 50                       103 75 3 13   0 6     1   5   53 50                 103

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