Data source: Big Local News · About: Big Local

7,625 rows where grade = "grade_2" and state = "CO" sorted by male 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
1894669 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 64 1 132   2 1     0   6   99 107                       206 64 1 132   2 1     0   6   99 107                 206
836428 CO     school   100   ALAMOSA RE-11J   115 ALAMOSA ELEMENTARY SCHOOL             2016   grade_2 41 2 129   2 1     0   1   97 79                       176 41 2 129   2 1     0   1   97 79                 176
840656 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006577 3863 HOPE ONLINE LEARNING ACADEMY ELEMENTARY   Regular School Yes 1.0 KG 05 2016   grade_2 29 24 147   2 1     1   2   97 109                       206 29 24 147   2 1     1   2   97 109                 206
714983 CO     school 803870 1110   FALCON 49 80387002000 7463 ROCKY MOUNTAIN CLASSICAL ACADEMY   Regular School Yes Other KG 12 2017   grade_2 154 5 49   0 2     0   12   94 128                       222 154 5 49   0 2     0   12   94 128                 222
1898935 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006577 3863 HOPE ONLINE LEARNING ACADEMY ELEMENTARY   Regular School Yes Elementary KG 05 2018   grade_2 15 18 134   1 0     1   3   94 78                       172 15 18 134   1 0     1   3   94 78                 172
1938314 CO     school 803870 1110   DISTRICT 49 80387002000 7463 ROCKY MOUNTAIN CLASSICAL ACADEMY   Regular School Yes Other KG 12 2019   grade_2 136 4 27   0 1     3   22   94 99                       193 136 4 27   0 1     3   22   94 99                 193
1747453 CO     school 803480 1520   Durango 9-R 80348006696 1526 Colorado Connections Academy @ Durango   Regular School No Other KG 12 2021   grade_2 109 12 60   2 2     0   11   93 103                       196 109 12 60   2 2     0   11   93 103                 196
848230 CO     school   8001   CHARTER SCHOOL INSTITUTE   654 THE PINNACLE CHARTER SCHOOL ELEMENTARY             2016   grade_2 26 1 148   0 3     0   2   92 88                       180 26 1 148   0 3     0   2   92 88                 180
1937813 CO     school 801920 1040   ACADEMY 20 80192006329 1615 CHINOOK TRAIL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 133 3 19   2 9     0   16   91 91                       182 133 3 19   2 9     0   16   91 91                 182
1751190 CO     school 800020 8001   Charter School Institute 80002006779 1387 Colorado Early Colleges Windsor   Regular School Yes Other KG 12 2021   grade_2 133 0 26   0 2     0   3   90 74                       164 133 0 26   0 2     0   3   90 74                 164
1809507 CO     school 806690 1828   Valley RE-1 80669006339 515 Ayres Elementary School   Regular School No Elementary KG 02 2020   grade_2 102 4 33   2 2     0   6   90 59                       149 102 4 33   2 2     0   6   90 59                 149
1811602 CO     school 803600 3085   Eaton RE-2 80360000474 2448 Eaton Elementary School   Regular School No Elementary PK 02 2020   grade_2 105 2 30   0 0     0   3   90 50                       140 105 2 30   0 0     0   3   90 50                 140
1811704 CO     school 807350 3100   Windsor RE-4 80735001263 8886 Tozer Elementary School   Regular School No Elementary PK 02 2020   grade_2 113 3 40   2 2     0   4   90 74                       164 113 3 40   2 2     0   4   90 74                 164
1133281 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY MONTESSORI SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 5.0 1.0 18.0   1.0 0.0     0.0   2.0   9.0 18.0                       27.0 5 1 18   1 0     0   2   9 18                 27
1136379 CO     school 803000 540   CLEAR CREEK RE-1 80300000218 4212 CARLSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_2 15.0 0.0 4.0   0.0 0.0     0.0   1.0   9.0 11.0                       20.0 15 0 4   0 0     0   1   9 11                 20
1140086 CO     school 803870 1110   FALCON 49 80387006462 2877 FALCON VIRTUAL ACADEMY   Regular School No 4.0 KG 12 2015   grade_2 15.0 0.0 1.0   0.0 0.0     0.0   1.0   9.0 8.0                       17.0 15 0 1   0 0     0   1   9 8                 17
1140698 CO     school 805160 1400   LA VETA RE-2 80516000853 4860 LA VETA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 10.0 0.0 4.0   0.0 0.0     0.0   0.0   9.0 5.0                       14.0 10 0 4   0 0     0   0   9 5                 14
1140857 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006587 1451 ADDENBROOKE CLASSICAL ACADEMY   Regular School Yes 4.0 KG 12 2015   grade_2 8.0 0.0 5.0   0.0 0.0     0.0   0.0   9.0 4.0                       13.0 8 0 5   0 0     0   0   9 4                 13
1141098 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000731 3450 GLENNON HEIGHTS ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2015   grade_2 18.0 2.0 3.0   0.0 0.0     0.0   1.0   9.0 15.0                       24.0 18 2 3   0 0     0   1   9 15                 24
1142360 CO     school 803990 1550   POUDRE R-1 80399000574 3791 LAB ELEMENTARY SCHOOL FOR CREATIVE LEARNING   Regular School No 1.0 KG 06 2015   grade_2 16.0 0.0 0.0   0.0 0.0     0.0   0.0   9.0 7.0                       16.0 16 0 0   0 0     0   0   9 7                 16
1142974 CO     school 802520 1750   BRANSON REORGANIZED 82 80252001728 948 BRANSON SCHOOL ONLINE   Regular School No 4.0 KG 12 2015   grade_2 13.0 0.0 4.0   0.0 0.0     0.0   2.0   9.0 10.0                       19.0 13 0 4   0 0     0   2   9 10                 19
1143575 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309006622 2036 CHILDREN'S KIVA MONTESSORI SCHOOL   Regular School Yes 1.0 KG 08 2015   grade_2 10.0 0.0 0.0   1.0 0.0     0.0   1.0   9.0 3.0                       12.0 10 0 0   1 0     0   1   9 3                 12
1143590 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309000837 5090 LEWIS-ARRIOLA ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 15.0 0.0 0.0   0.0 0.0     0.0   1.0   9.0 7.0                       16.0 15 0 0   0 0     0   1   9 7                 16
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
1144428 CO     school 806120 2690   PUEBLO CITY 60 80612001063 8116 SOUTH PARK ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 5.0 0.0 21.0   0.0 0.0     0.0   0.0   9.0 17.0                       26.0 5 0 21   0 0     0   0   9 17                 26
710060 CO     school 806630 250   SPRINGFIELD RE-4 80663001141 8160 SPRINGFIELD ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 14 0 5   0 0     0   2   9 12                       21 14 0 5   0 0     0   2   9 12                 21
711312 CO     school 803330 870   DELTA COUNTY 50(J) 80333001337 6700 PAONIA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 16 1 5   0 0     0   0   9 13                       22 16 1 5   0 0     0   0   9 13                 22
713851 CO     school 806480 990   WIDEFIELD 3 80648001885 5033 JAMES MADISON CHARTER ACADEMY SCHOOL   Regular School Yes Elementary KG 06 2017   grade_2 10 1 7   0 0     0   2   9 11                       20 10 1 7   0 0     0   2   9 11                 20
717295 CO     school 803990 1550   POUDRE R-1 80399006573 5917 MOUNTAIN SAGE COMMUNITY SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 28 0 1   0 0     0   0   9 20                       29 28 0 1   0 0     0   0   9 20                 29
717323 CO     school 803990 1550   POUDRE R-1 80399006564 7043 PSD OPTIONS SCHOOL   Regular School No Elementary KG 08 2017   grade_2 14 0 2   0 0     1   0   9 8                       17 14 0 2   0 0     1   0   9 8                 17
717705 CO     school 805400 1560   THOMPSON R2-J 80540000940 9055 VAN BUREN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 12 1 5   0 0     0   1   9 10                       19 12 1 5   0 0     0   1   9 10                 19
717946 CO     school 803930 1850   FRENCHMAN RE-3 80393000511 2980 FLEMING ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 16 0 2   0 0     0   0   9 9                       18 16 0 2   0 0     0   0   9 9                 18
718456 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309000837 5090 LEWIS-ARRIOLA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 18 0 1   0 0     0   2   9 12                       21 18 0 1   0 0     0   2   9 12                 21
720524 CO     school 806720 3147   PRAIRIE RE-11 80672001157 7154 PRAIRIE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 15 0 1   0 0     0   0   9 7                       16 15 0 1   0 0     0   0   9 7                 16
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
838679 CO     school 803000 540   CLEAR CREEK RE-1 80300001999 3385 GEORGETOWN COMMUNITY SCHOOL   Regular School Yes 1.0 PK 06 2016   grade_2 15 0 1   0 0     0   0   9 7                       16 15 0 1   0 0     0   0   9 7                 16
838936 CO     school 803330 870   DELTA COUNTY 50(J) 80333001337 6700 PAONIA ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 19 0 1   0 0     0   1   9 12                       21 19 0 1   0 0     0   1   9 12                 21
841209 CO     school 805010 930   KIOWA C-2 80501000824 4724 KIOWA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 11 0 0   0 0     0   0   9 2                       11 11 0 0   0 0     0   0   9 2                 11
844436 CO     school 802260 1450   ARRIBA-FLAGLER C-20 80226000509 2960 FLAGLER PUBLIC SCHOOL   Regular School No 4.0 PK 12 2016   grade_2 13 0 2   0 1     0   0   9 7                       16 13 0 2   0 1     0   0   9 7                 16
845347 CO     school 807260 1590   PRIMERO REORGANIZED 2 80726001256 7160 PRIMERO ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 10 0 7   0 0     0   0   9 8                       17 10 0 7   0 0     0   0   9 8                 17
845535 CO     school 805640 1860   BUFFALO RE-4J 80564000969 5802 MERINO ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 22 0 1   0 0     0   0   9 14                       23 22 0 1   0 0     0   0   9 14                 23
847511 CO     school 805940 3050   OTIS R-3 80594001016 6582 OTIS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 16 0 3   0 0     0   0   9 10                       19 16 0 3   0 0     0   0   9 10                 19
848110 CO     school 804440 3148   PAWNEE RE-12 80444000653 6812 PAWNEE SCHOOL PK-12   Regular School No 4.0 PK 12 2016   grade_2 9 0 1   0 0     0   0   9 1                       10 9 0 1   0 0     0   0   9 1                 10
1740588 CO     school 806630 250   Springfield RE-4 80663001141 8160 Springfield Elementary School   Regular School No Elementary PK 05 2021   grade_2 17 0 2   0 0     0   3   9 13                       22 17 0 2   0 0     0   3   9 13                 22
1741554 CO     school 803000 540   Clear Creek RE-1 80300001999 3385 Georgetown Community School   Regular School Yes Elementary PK 06 2021   grade_2 12 0 0   0 0     0   0   9 3                       12 12 0 0   0 0     0   0   9 3                 12
1741670 CO     school 804140 740   Sierra Grande R-30 80414000572 7880 Sierra Grande K-12 School   Regular School No Other PK 12 2021   grade_2 2 0 11   0 0     0   0   9 4                       13 2 0 11   0 0     0   0   9 4                 13
1743211 CO     school 803420 890   Dolores County RE No.2 80342000435 7764 Seventh Street Elementary School   Regular School No Elementary PK 05 2021   grade_2 16 0 1   0 0     0   1   9 9                       18 16 0 1   0 0     0   1   9 9                 18
1744545 CO     school 803060 1010   Colorado Springs 11 80306000225 1126 Buena Vista Elementary School   Regular School No Elementary PK 05 2021   grade_2 21 0 0   0 0     0   5   9 17                       26 21 0 0   0 0     0   5   9 17                 26
1744748 CO     school 803060 1010   Colorado Springs 11 80306000253 5878 Midland Elementary School   Regular School No Elementary KG 05 2021   grade_2 10 0 9   0 0     0   1   9 11                       20 10 0 9   0 0     0   1   9 11                 20
1746346 CO     school 804800 1420   Jefferson County R-1 80480006695 2189 Doral Academy of Colorado   Regular School Yes Other KG 10 2021   grade_2 16 1 6   0 0     0   0   9 14                       23 16 1 6   0 0     0   0   9 14                 23
1747309 CO     school 803510 1430   Eads RE-1 80351000458 2328 Eads Elementary School   Regular School No Elementary PK 05 2021   grade_2 12 0 0   0 0     0   0   9 3                       12 12 0 0   0 0     0   0   9 3                 12
1747488 CO     school 803480 1520   Durango 9-R 80348000450 3050 Fort Lewis Mesa Elementary School   Regular School No Elementary PK 05 2021   grade_2 14 0 3   0 0     0   1   9 9                       18 14 0 3   0 0     0   1   9 9                 18
1748370 CO     school 806690 1828   Valley RE-1 80669001361 1220 Caliche Elementary School   Regular School No Elementary PK 06 2021   grade_2 15 0 7   0 0     0   0   9 13                       22 15 0 7   0 0     0   0   9 13                 22
1749246 CO     school 802880 2560   Cheraw 31 80288000182 1546 Cheraw School   Regular School No Other PK 12 2021   grade_2 15 0 3   0 0     0   0   9 9                       18 15 0 3   0 0     0   0   9 9                 18
1750076 CO     school 805910 2780   South Routt RE 3 80591001015 8120 South Routt Elementary School   Regular School No Elementary KG 05 2021   grade_2 15 0 0   0 0     0   1   9 7                       16 15 0 0   0 0     0   1   9 7                 16
1750985 CO     school 806720 3147   Prairie RE-11 80672001157 7154 Prairie Elementary School   Regular School No Elementary PK 05 2021   grade_2 15 0 0   0 0     0   0   9 6                       15 15 0 0   0 0     0   0   9 6                 15
1751518 CO     school 800282 9170   Education reEnvisioned BOCES 80028206804 1892 Orton Academy   Regular School No Other KG 12 2021   grade_2 14 0 0   0 0     0   0   9 5                       14 14 0 0   0 0     0   0   9 5                 14
1803696 CO     school 803360 880   Denver County 1 80336000377 5702 McKinley-Thatcher Elementary School   Regular School No Elementary PK 05 2020   grade_2 13 1 8   0 0     0   1   9 14                       23 13 1 8   0 0     0   1   9 14                 23
1806838 CO     school 803120 1160   Cotopaxi RE-3 80312000276 3220 Cotopaxi Elementary School   Regular School No Elementary PK 05 2020   grade_2 16 1 0   0 0     0   0   9 8                       17 16 1 0   0 0     0   0   9 8                 17
1807027 CO     school 804230 1330   Gilpin County RE-1 80423000581 1632 Gilpin County Elementary School   Regular School No Elementary PK 05 2020   grade_2 24 0 2   0 0     0   1   9 18                       27 24 0 2   0 0     0   1   9 18                 27
1808603 CO     school 803480 1520   Durango 9-R 80348000450 3050 Fort Lewis Mesa Elementary School   Regular School No Elementary PK 05 2020   grade_2 12 1 2   0 0     0   1   9 7                       16 12 1 2   0 0     0   1   9 7                 16
1809511 CO     school 806690 1828   Valley RE-1 80669001361 1220 Caliche Elementary School   Regular School No Elementary PK 06 2020   grade_2 11 0 4   0 0     0   0   9 6                       15 11 0 4   0 0     0   0   9 6                 15
1809573 CO     school 806030 1870   Plateau RE-5 80603001022 6834 Peetz Elementary School   Regular School No Elementary PK 06 2020   grade_2 14 0 1   0 0     0   0   9 6                       15 14 0 1   0 0     0   0   9 6                 15
1811213 CO     school 806300 2790   Mountain Valley RE 1 80630001415 6146 Mountain Valley School   Regular School No Other PK 12 2020   grade_2 10 1 2   0 0     0   1   9 5                       14 10 1 2   0 0     0   1   9 5                 14
1812099 CO     school 806720 3147   Prairie RE-11 80672001157 7154 Prairie Elementary School   Regular School No Elementary PK 05 2020   grade_2 16 0 1   0 0     0   0   9 8                       17 16 0 1   0 0     0   0   9 8                 17
1812414 CO     school 800020 8001   Charter School Institute 80002006701 5423 Mountain Village Montessori Charter School   Regular School Yes Elementary PK 05 2020   grade_2 19 0 1   0 0     0   0   9 11                       20 19 0 1   0 0     0   0   9 11                 20
1896960 CO     school 803000 540   CLEAR CREEK RE-1 80300001332 4700 KING-MURPHY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_2 14 0 0   0 0     0   1   9 6                       15 14 0 0   0 0     0   1   9 6                 15
1900377 CO     school 805490 1030   MANITOU SPRINGS 14 80549000948 9010 UTE PASS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_2 13 2 1   0 0     0   0   9 7                       16 13 2 1   0 0     0   0   9 7                 16
1901072 CO     school 803120 1160   COTOPAXI RE-3 80312000276 3220 COTOPAXI ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2018   grade_2 12 1 0   1 0     0   2   9 7                       16 12 1 0   1 0     0   2   9 7                 16
1901284 CO     school 805070 1340   WEST GRAND 1-JT 80507000829 9422 WEST GRAND ELEMENTARY AND MIDDLE SCHOOL   Regular School No Elementary KG 08 2018   grade_2 18 0 9   0 0     0   1   9 19                       28 18 0 9   0 0     0   1   9 19                 28
1901681 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006695 2189 DORAL ACADEMY OF COLORADO   Regular School Yes Elementary KG 08 2018   grade_2 15 1 9   0 0     0   0   9 16                       25 15 1 9   0 0     0   0   9 16                 25
1903532 CO     school 805400 1560   THOMPSON R2-J 80540006558 5121 LEAP SCHOOL   Regular School No Other KG 12 2018   grade_2 19 0 1   0 0     0   0   9 11                       20 19 0 1   0 0     0   0   9 11                 20
1903627 CO     school 805400 1560   THOMPSON R2-J 80540001353 7650 STANSBERRY ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 23 0 7   0 0     0   2   9 23                       32 23 0 7   0 0     0   2   9 23                 32
1906538 CO     school 800018 3220   IDALIA RJ-3 80001801741 4227 IDALIA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2018   grade_2 10 0 6   0 0     0   0   9 7                       16 10 0 6   0 0     0   0   9 7                 16
1933364 CO     school 805580 310   MC CLAVE RE-2 80558000962 5666 MC CLAVE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 16 1 0   0 0     0   0   9 8                       17 16 1 0   0 0     0   0   9 8                 17
1936886 CO     school 806600 940   BIG SANDY 100J 80660001138 7914 SIMLA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 18 0 2   0 0     0   1   9 12                       21 18 0 2   0 0     0   1   9 12                 21
1938823 CO     school 805160 1400   LA VETA RE-2 80516000853 4860 LA VETA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 12 0 5   0 0     0   0   9 8                       17 12 0 5   0 0     0   0   9 8                 17
1939096 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006695 2189 DORAL ACADEMY OF COLORADO   Regular School Yes Elementary KG 08 2019   grade_2 15 0 2   0 0     0   4   9 12                       21 15 0 2   0 0     0   4   9 12                 21
1940110 CO     school 803510 1430   EADS RE-1 80351000458 2328 EADS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 10 0 2   0 0     0   3   9 6                       15 10 0 2   0 0     0   3   9 6                 15
1940659 CO     school 803990 1550   POUDRE R-1 80399006334 7104 POLARIS EXPEDITIONARY LEARNING SCHOOL   Alternative School No Other KG 12 2019   grade_2 16 0 0   0 0     0   1   9 8                       17 16 0 0   0 0     0   1   9 8                 17
1941149 CO     school 802520 1750   BRANSON REORGANIZED 82 80252001728 948 BRANSON SCHOOL ONLINE   Regular School No Other KG 12 2019   grade_2 15 0 4   0 0     0   0   9 10                       19 15 0 4   0 0     0   0   9 10                 19
1942258 CO     school 804560 2630   HAXTUN RE-2J 80456000673 3846 HAXTUN ELEMENTARY SCHOOL   Regular School No Elementary PK 08 2019   grade_2 20 1 4   0 0     0   0   9 16                       25 20 1 4   0 0     0   0   9 16                 25
1943911 CO     school 800018 3220   IDALIA RJ-3 80001801741 4227 IDALIA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 15 0 1   0 0     0   0   9 7                       16 15 0 1   0 0     0   0   9 7                 16
1800735 CO     school 802910 130   Cherry Creek 5 80291006452 6955 Pine Ridge Elementary School   Regular School No Elementary PK 05 2020   grade_2 100 8 19   0 14     0   14   89 66                       155 100 8 19   0 14     0   14   89 66                 155
1134153 CO     school 802070 100   ALAMOSA RE-11J 80207006459 115 ALAMOSA ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 50.0 0.0 116.0   2.0 2.0     0.0   4.0   88.0 86.0                       174.0 50 0 116   2 2     0   4   88 86                 174
842582 CO     school 803870 1110   FALCON 49 80387002000 7463 ROCKY MOUNTAIN CLASSICAL ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_2 133 8 16   1 3     0   20   88 93                       181 133 8 16   1 3     0   20   88 93                 181
709661 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes Elementary KG 08 2017   grade_2 18 46 89   2 3     1   15   87 87                       174 18 46 89   2 3     1   15   87 87                 174
720624 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_2 85 1 31   0 10     0   12   87 52                       139 85 1 31   0 10     0   12   87 52                 139
1944216 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001915 6914 THE PINNACLE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_2 21 3 118   0 3     1   3   87 62                       149 21 3 118   0 3     1   3   87 62                 149
1135012 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes 1.0 KG 08 2015   grade_2 33.0 38.0 80.0   0.0 7.0     1.0   17.0   86.0 90.0                       176.0 33 38 80   0 7     1   17   86 90                 176
836243 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006401 8820 TURNBERRY ELEMENTARY   Regular School No 1.0 PK 05 2016   grade_2 78 6 57   0 6     1   5   86 67                       153 78 6 57   0 6     1   5   86 67                 153
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
1139509 CO     school 803060 1010   COLORADO SPRINGS 11 80306000262 7482 ROOSEVELT EDISON CHARTER SCHOOL   Regular School Yes 1.0 KG 05 2015   grade_2 29.0 10.0 89.0   0.0 3.0     2.0   3.0   83.0 53.0                       136.0 29 10 89   0 3     2   3   83 53                 136
720661 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001926 654 THE PINNACLE CHARTER SCHOOL ELEMENTARY   Regular School Yes Elementary KG 05 2017   grade_2 27 0 119   1 9     0   1   83 74                       157 27 0 119   1 9     0   1   83 74                 157
847701 CO     school 807350 3100   WINDSOR RE-4 80735001263 8886 TOZER ELEMENTARY SCHOOL   Regular School No 1.0 PK 02 2016   grade_2 114 1 24   0 3     0   5   82 65                       147 114 1 24   0 3     0   5   82 65                 147
1145362 CO     school 804410 3120   GREELEY 6 80441001990 54 BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY   Regular School No 1.0 KG 08 2015   grade_2 11.0 8.0 109.0   0.0 1.0     0.0   0.0   81.0 48.0                       129.0 11 8 109   0 1     0   0   81 48                 129
1900434 CO     school 801920 1040   ACADEMY 20 80192006329 1615 CHINOOK TRAIL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2018   grade_2 120 2 20   0 8     0   13   81 82                       163 120 2 20   0 8     0   13   81 82                 163
1906067 CO     school 807350 3100   WINDSOR RE-4 80735006460 8459 RANGE VIEW ELEMENTARY   Regular School No Elementary PK 05 2018   grade_2 119 1 23   0 0     0   1   80 64                       144 119 1 23   0 0     0   1   80 64                 144
1136471 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No 4.0 PK 12 2015   grade_2 1.0 0.0 12.0   0.0 0.0     0.0   0.0   8.0 5.0                       13.0 1 0 12   0 0     0   0   8 5                 13
1138840 CO     school 806600 940   BIG SANDY 100J 80660001138 7914 SIMLA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2015   grade_2 13.0 0.0 0.0   0.0 0.0     0.0   0.0   8.0 5.0                       13.0 13 0 0   0 0     0   0   8 5                 13

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