Data source: Big Local News · About: Big Local

1,072 rows where grade = "grade_2", state = "CO" and year = 2016 sorted by total_int

View and edit SQL

year

  • 2016 · 972

grade

  • grade_2 · 972
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 ▼
848091 CO     school 806720 3147   PRAIRIE RE-11 80672001157 7154 PRAIRIE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 16 0 1   0 0     0   0   10 7                       17 16 0 1   0 0     0   0   10 7                 17
844918 CO     school 803990 1550   POUDRE R-1 80399006334 7104 POLARIS EXPEDITIONARY LEARNING SCHOOL   Alternative Education School No 4.0 KG 12 2016   grade_2 16 0 1   0 0     0   1   12 6                       18 16 0 1   0 0     0   1   12 6                 18
846380 CO     school 802880 2560   CHERAW 31 80288000182 1546 CHERAW SCHOOL   Regular School No 4.0 PK 12 2016   grade_2 12 0 6   0 0     0   0   11 7                       18 12 0 6   0 0     0   0   11 7                 18
847318 CO     school 805880 2840   NORWOOD R-2J 80588001012 6422 NORWOOD PUBLIC SCHOOLS   Regular School No 4.0 PK 12 2016   grade_2 16 0 2   0 0     0   0   8 10                       18 16 0 2   0 0     0   0   8 10                 18
837671 CO     school 807110 230   WALSH RE-1 80711001215 9222 WALSH ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 15 1 1   1 0     0   1   7 12                       19 15 1 1   1 0     0   1   7 12                 19
838780 CO     school 806360 640   CENTENNIAL R-1 80636001416 1398 CENTENNIAL SCHOOL   Regular School No 4.0 PK 12 2016   grade_2 0 0 19   0 0     0   0   6 13                       19 0 0 19   0 0     0   0   6 13                 19
845488 CO     school 806690 1828   VALLEY RE-1 80669001361 1220 CALICHE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 16 0 3   0 0     0   0   8 11                       19 16 0 3   0 0     0   0   8 11                 19
846577 CO     school   2660   LAMAR RE-2   200 ALTA VISTA CHARTER SCHOOL             2016   grade_2 15 0 4   0 0     0   0   12 7                       19 15 0 4   0 0     0   0   12 7                 19
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
844055 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001036 7701 COLLEGIATE ACADEMY OF COLORADO   Regular School Yes 4.0 KG 12 2016   grade_2 12 0 4   0 0     0   4   7 13                       20 12 0 4   0 0     0   4   7 13                 20
846612 CO     school 804680 2670   HOLLY RE-3 80468000682 7794 HOLLY ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 10 0 10   0 0     0   0   11 9                       20 10 0 10   0 0     0   0   11 9                 20
847201 CO     school 805910 2780   SOUTH ROUTT RE 3 80591001015 8120 SOUTH ROUTT ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 17 0 2   0 0     0   1   11 9                       20 17 0 2   0 0     0   1   11 9                 20
847479 CO     school   3030   AKRON R-1   86 AKRON ELEMENTARY SCHOOL             2016   grade_2 13 0 6   0 0     0   1   12 8                       20 13 0 6   0 0     0   1   12 8                 20
847620 CO     school 804920 3090   WELD COUNTY SCHOOL DISTRICT RE-3J 80492001760 1299 CARDINAL COMMUNITY ACADEMY CHARTER SCHOOL   Regular School Yes 1.0 KG 08 2016   grade_2 17 0 2   1 0     0   0   13 7                       20 17 0 2   1 0     0   0   13 7                 20
848157 CO     school 800018 3220   IDALIA RJ-3 80001801741 4227 IDALIA ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 16 0 2   1 0     0   1   10 10                       20 16 0 2   1 0     0   1   10 10                 20
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
843329 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001766 1880 COMPASS MONTESSORI - GOLDEN CHARTER SCHOOL   Regular School Yes 4.0 PK 12 2016   grade_2 18 0 1   0 0     0   2   14 7                       21 18 0 1   0 0     0   2   14 7                 21
844609 CO     school 803480 1520   DURANGO 9-R 80348000457 8388 SUNNYSIDE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 12 0 6   0 0     0   3   11 10                       21 12 0 6   0 0     0   3   11 10                 21
846025 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309000837 5090 LEWIS-ARRIOLA ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 19 0 1   1 0     0   0   13 8                       21 19 0 1   1 0     0   0   13 8                 21
846424 CO     school 806210 2590   RIDGWAY R-2 80621001089 7342 RIDGWAY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 19 0 1   0 0     0   1   10 11                       21 19 0 1   0 0     0   1   10 11                 21
847114 CO     school 806450 2750   SARGENT RE-33J 80645001117 7660 SARGENT ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 15 0 7   0 0     0   0   11 11                       22 15 0 7   0 0     0   0   11 11                 22
848041 CO     school 804020 3140   WELD COUNTY S/D RE-8 80402006606 7219 QUEST ACADEMY AT DACONO   Regular School No 1.0 KG 08 2016   grade_2 13 0 9   0 0     0   0   11 11                       22 13 0 9   0 0     0   0   11 11                 22
842654 CO     school 805670 1130   MIAMI/YODER 60 JT 80567000971 5850 MIAMI/YODER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 18 0 5   0 0     0   0   11 12                       23 18 0 5   0 0     0   0   11 12                 23
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
845706 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435001552 2724 NEW EMERSON SCHOOL AT COLUMBUS   Regular School No 1.0 KG 05 2016   grade_2 18 0 2   1 2     0   0   12 11                       23 18 0 2   1 2     0   0   12 11                 23
846195 CO     school 805850 2190   WEST END RE-2 80585001398 6196 NATURITA ELEMENTARY & MIDDLE SCHOOL   Regular School No 1.0 PK 08 2016   grade_2 22 0 1   0 0     0   0   10 13                       23 22 0 1   0 0     0   0   10 13                 23
846517 CO     school 804560 2630   HAXTUN RE-2J 80456000673 3846 HAXTUN ELEMENTARY SCHOOL   Regular School No 1.0 PK 08 2016   grade_2 22 0 1   0 0     0   0   13 10                       23 22 0 1   0 0     0   0   13 10                 23
847613 CO     school 803600 3085   EATON RE-2 80360000477 3286 GALETON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 18 0 5   0 0     0   0   13 10                       23 18 0 5   0 0     0   0   13 10                 23
836447 CO     school 806420 110   SANGRE DE CRISTO RE-22J 80642001115 7626 SANGRE DE CRISTO ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 15 0 8   1 0     0   0   18 6                       24 15 0 8   1 0     0   0   18 6                 24
837778 CO     school 805580 310   MC CLAVE RE-2 80558000962 5666 MC CLAVE ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 24 0 0   0 0     0   0   11 13                       24 24 0 0   0 0     0   0   11 13                 24
839431 CO     school 803360 880   DENVER COUNTY 1 80336000353 3426 GILPIN MONTESSORI PUBLIC SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 2 10 11   0 0     0   1   14 10                       24 2 10 11   0 0     0   1   14 10                 24
843512 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000731 3450 GLENNON HEIGHTS ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 14 0 6   0 1     0   3   14 10                       24 14 0 6   0 1     0   3   14 10                 24
848429 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006635 8821 TWO RIVERS COMMUNITY SCHOOL   Regular School Yes 1.0 KG 08 2016   grade_2 12 1 9   0 0     0   2   15 9                       24 12 1 9   0 0     0   2   15 9                 24
838795 CO     school 804140 740   SIERRA GRANDE R-30 80414000572 7880 SIERRA GRANDE K-12 SCHOOL   Regular School No 4.0 KG 12 2016   grade_2 7 0 16   0 0     0   2   15 10                       25 7 0 16   0 0     0   2   15 10                 25
839756 CO     school 803360 880   DENVER COUNTY 1 80336000377 5702 MC KINLEY-THATCHER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 15 0 10   0 0     0   0   11 14                       25 15 0 10   0 0     0   0   11 14                 25
842960 CO     school 805070 1340   WEST GRAND 1-JT 80507000829 9422 WEST GRAND ELEMENTARY AND MIDDLE SCHOOL   Regular School No 1.0 KG 08 2016   grade_2 15 1 8   0 0     0   1   10 15                       25 15 1 8   0 0     0   1   10 15                 25
848512 CO     school 800004 9130   EXPEDITIONARY BOCES 80000400709 2840 ROCKY MOUNTAIN SCHOOL OF EXPEDITIONARY LEARNING   Regular School No 4.0 KG 12 2016   grade_2 21 0 1   0 0     0   3   11 14                       25 21 0 1   0 0     0   3   11 14                 25
839014 CO     school   880   DENVER COUNTY 1   540 BARRETT ELEMENTARY SCHOOL             2016   grade_2 1 14 11   0 0     0   0   19 7                       26 1 14 11   0 0     0   0   19 7                 26
839866 CO     school 803360 880   DENVER COUNTY 1 80336001636 6479 ODYSSEY SCHOOL OF DENVER   Regular School Yes 1.0 KG 08 2016   grade_2 13 2 5   0 1     0   5   12 14                       26 13 2 5   0 1     0   5   12 14                 26
840309 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342000435 7764 SEVENTH STREET ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 26 0 0   0 0     0   0   17 9                       26 26 0 0   0 0     0   0   17 9                 26
841861 CO     school 803060 1010   COLORADO SPRINGS 11 80306000253 5878 MIDLAND ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 15 0 6   0 1     0   4   15 11                       26 15 0 6   0 1     0   4   15 11                 26
843177 CO     school   1420   JEFFERSON COUNTY R-1   491 ADDENBROOKE CLASSICAL GRAMMAR SCHOOL             2016   grade_2 18 1 7   0 0     0   0   7 19                       26 18 1 7   0 0     0   0   7 19                 26
843960 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000773 6848 PENNINGTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 8 1 15   0 1     0   1   12 14                       26 8 1 15   0 1     0   1   12 14                 26
844564 CO     school 803480 1520   DURANGO 9-R 80348000450 3050 FORT LEWIS MESA ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 19 0 6   0 0     0   1   15 11                       26 19 0 6   0 0     0   1   15 11                 26
845366 CO     school 804650 1600   HOEHNE REORGANIZED 3 80465000680 4048 HOEHNE SCHOOLS   Regular School No 4.0 PK 12 2016   grade_2 14 0 12   0 0     0   0   13 13                       26 14 0 12   0 0     0   0   13 13                 26
845587 CO     school 803030 1990   PLATEAU VALLEY 50 80303000219 7024 PLATEAU VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 23 0 1   1 0     0   1   12 14                       26 23 0 1   1 0     0   1   12 14                 26
846392 CO     school 806840 2570   SWINK 33 80684001168 8452 SWINK ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 18 0 8   0 0     0   0   7 19                       26 18 0 8   0 0     0   0   7 19                 26
847130 CO     school 804590 2760   HAYDEN RE-1 80459000675 2522 HAYDEN VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 24 1 1   0 0     0   0   12 14                       26 24 1 1   0 0     0   0   12 14                 26
841346 CO     school 804530 980   HARRISON 2 80453006663 5763 MOUNTAIN VISTA HOMESCHOOL ACADEMY   Regular School No 4.0 KG 12 2016   grade_2 21 0 5   0 0     0   1   14 13                       27 21 0 5   0 0     0   1   14 13                 27
842709 CO     school 802790 1140   CANON CITY RE-1 80279001538 6752 MOUNT VIEW CORE KNOWLEDGE CHARTER SCHOOL   Regular School Yes 1.0 PK 08 2016   grade_2 23 0 3   0 1     0   0   12 15                       27 23 0 3   0 1     0   0   12 15                 27
843898 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006256 6539 JEFFERSON COUNTY OPEN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 17 0 6   1 1     0   2   15 12                       27 17 0 6   1 1     0   2   15 12                 27
844541 CO     school 803480 1520   DURANGO 9-R 80348006614 2097 DISTRICT 9-R SHARED SCHOOL   Regular School No 4.0 KG 12 2016   grade_2 27 0 0   0 0     0   0   12 15                       27 27 0 0   0 0     0   0   12 15                 27
846361 CO     school   2540   FOWLER R-4J   56 FOWLER ELEMENTARY SCHOOL             2016   grade_2 17 0 9   0 0     0   1   13 14                       27 17 0 9   0 0     0   1   13 14                 27
847437 CO     school 803180 3010   CRIPPLE CREEK-VICTOR RE-1 80318000280 9080 CRESSON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 21 0 5   1 0     0   0   15 12                       27 21 0 5   1 0     0   0   15 12                 27
848407 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001913 7512 ROSS MONTESSORI SCHOOL   Regular School Yes 1.0 KG 08 2016   grade_2 22 0 5   0 0     0   0   13 14                       27 22 0 5   0 0     0   0   13 14                 27
837704 CO     school 806630 250   SPRINGFIELD RE-4 80663001141 8160 SPRINGFIELD ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 22 0 4   1 0     0   1   21 7                       28 22 0 4   1 0     0   1   21 7                 28
840699 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000441 4980 LARKSPUR ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 24 1 2   0 0     0   1   14 14                       28 24 1 2   0 0     0   1   14 14                 28
845086 CO     school   1560   THOMPSON R2-J   870 BIG THOMPSON ELEMENTARY SCHOOL             2016   grade_2 25 0 2   0 1     0   0   17 11                       28 25 0 2   0 1     0   0   17 11                 28
845253 CO     school 805400 1560   THOMPSON R2-J 80540001353 7650 STANSBERRY ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 20 0 8   0 0     0   0   20 8                       28 20 0 8   0 0     0   0   20 8                 28
845277 CO     school 805400 1560   THOMPSON R2-J 80540000940 9055 VAN BUREN ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 19 0 8   0 0     0   1   22 6                       28 19 0 8   0 0     0   1   22 6                 28
847998 CO     school 804410 3120   GREELEY 6 80441006504 9611 WEST RIDGE ACADEMY   Regular School Yes 4.0 KG 09 2016   grade_2 23 0 5   0 0     0   0   11 17                       28 23 0 5   0 0     0   0   11 17                 28
838745 CO     school 806390 560   SANFORD 6J 80639001113 7612 SANFORD ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 21 0 8   0 0     0   0   19 10                       29 21 0 8   0 0     0   0   19 10                 29
838822 CO     school 807200 860   CUSTER COUNTY SCHOOL DISTRICT C-1 80720001226 2088 CUSTER COUNTY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 27 0 0   2 0     0   0   20 9                       29 27 0 0   2 0     0   0   20 9                 29
845794 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435006384 5828 MESA VALLEY COMMUNITY SCHOOL   Regular School Yes 4.0 KG 12 2016   grade_2 25 0 4   0 0     0   0   15 14                       29 25 0 4   0 0     0   0   15 14                 29
843283 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000705 1790 COLOROW ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 21 1 7   0 0     0   1   16 14                       30 21 1 7   0 0     0   1   16 14                 30
847559 CO     school 804200 3080   WELD COUNTY RE-1 80420000575 3398 GILCREST ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 7 0 22   0 0     0   1   13 17                       30 7 0 22   0 0     0   1   13 17                 30
836476 CO     school 803780 120   ENGLEWOOD 1 80378000488 1556 CHERRELYN ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 19 0 10   0 0     0   2   16 15                       31 19 0 10   0 0     0   2   16 15                 31
837873 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001887 1284 CARBON VALLEY ACADEMY   Regular School Yes 1.0 PK 08 2016   grade_2 25 0 6   0 0     0   0   14 17                       31 25 0 6   0 0     0   0   14 17                 31
839153 CO     school 803360 880   DENVER COUNTY 1 80336000330 1846 COLUMBINE ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 2 16 12   0 0     0   1   14 17                       31 2 16 12   0 0     0   1   14 17                 31
842752 CO     school 803960 1150   FREMONT RE-2 80396000516 6858 PENROSE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 26 0 3   0 0     0   2   17 14                       31 26 0 3   0 0     0   2   17 14                 31
843159 CO     school   1420   JEFFERSON COUNTY R-1   148 ALLENDALE ELEMENTARY SCHOOL             2016   grade_2 16 0 14   0 0     0   1   14 17                       31 16 0 14   0 0     0   1   14 17                 31
844260 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000794 9154 VIVIAN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 12 1 16   0 2     0   0   11 20                       31 12 1 16   0 2     0   0   11 20                 31
848219 CO     school   8001   CHARTER SCHOOL INSTITUTE   653 STONE CREEK SCHOOL             2016   grade_2 24 1 6   0 0     0   0   22 9                       31 24 1 6   0 0     0   0   22 9                 31
837760 CO     school 805250 290   LAS ANIMAS RE-1 80525000866 1812 LAS ANIMAS ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 17 0 13   0 0     0   2   14 18                       32 17 0 13   0 0     0   2   14 18                 32
841465 CO     school 806480 990   WIDEFIELD 3 80648001885 5033 JAMES MADISON CHARTER ACADEMY SCHOOL   Regular School Yes 1.0 KG 06 2016   grade_2 19 3 5   0 1     1   3   24 8                       32 19 3 5   0 1     1   3   24 8                 32
842702 CO     school 802790 1140   CANON CITY RE-1 80279000175 5704 MCKINLEY ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 25 0 5   0 0     0   2   13 19                       32 25 0 5   0 0     0   2   13 19                 32
843307 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001649 1869 COMPASS MONTESSORI - WHEAT RIDGE CHARTER SCHOOL   Regular School Yes 1.0 PK 06 2016   grade_2 24 0 5   0 0     0   3   14 18                       32 24 0 5   0 0     0   3   14 18                 32
837593 CO     school 802700 190   BYERS 32J 80270000163 1168 BYERS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 25 0 7   1 0     0   0   14 19                       33 25 0 7   1 0     0   0   14 19                 33
838967 CO     school   880   DENVER COUNTY 1   99 ACADEMY 360             2016   grade_2 2 12 14   0 2     0   3   14 19                       33 2 12 14   0 2     0   3   14 19                 33
841656 CO     school 803060 1010   COLORADO SPRINGS 11 80306000225 1126 BUENA VISTA ELEMENTARY SCHOOL   Regular School No 1.0 PK 08 2016   grade_2 25 0 2   1 1     1   3   14 19                       33 25 0 2   1 1     1   3   14 19                 33
841755 CO     school 803060 1010   COLORADO SPRINGS 11 80306001318 3470 GLOBE CHARTER SCHOOL   Regular School Yes 1.0 KG 06 2016   grade_2 24 4 2   0 0     0   3   20 13                       33 24 4 2   0 0     0   3   20 13                 33
846483 CO     school 803840 2610   PARK COUNTY RE-2 80384000502 8114 EDITH TETER ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 29 0 3   0 0     0   1   20 13                       33 29 0 3   0 0     0   1   20 13                 33
843661 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000744 4802 KULLERSTRAND ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 17 0 13   1 1     0   2   18 16                       34 17 0 13   1 1     0   2   18 16                 34
843969 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000774 7078 PLEASANT VIEW ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 16 1 11   3 0     0   3   14 20                       34 16 1 11   3 0     0   3   14 20                 34
845148 CO     school 805400 1560   THOMPSON R2-J 80540001301 5018 LAURENE EDMONDSON ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 21 0 11   0 0     0   2   22 12                       34 21 0 11   0 0     0   2   22 12                 34
845266 CO     school 805400 1560   THOMPSON R2-J 80540000939 8918 TRUSCOTT ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 14 0 17   2 1     0   0   14 20                       34 14 0 17   2 1     0   0   14 20                 34
848451 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006338 8929 PIKES PEAK PREP   Regular School Yes 4.0 KG 12 2016   grade_2 20 5 7   0 1     0   1   20 14                       34 20 5 7   0 1     0   1   20 14                 34
835558 CO     school   10   MAPLETON 1   504 WELBY COMMUNITY SCHOOL             2016   grade_2 6 1 28   0 0     0   0   18 17                       35 6 1 28   0 0     0   0   18 17                 35
838727 CO     school 805100 550   NORTH CONEJOS RE-1J 80510000845 5422 MANASSA ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2016   grade_2 13 1 20   1 0     0   0   16 19                       35 13 1 20   1 0     0   0   16 19                 35
842355 CO     school 806060 1060   PEYTON 23 JT 80606001024 6898 PEYTON ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 24 2 7   0 2     0   0   19 16                       35 24 2 7   0 2     0   0   19 16                 35
842398 CO     school 805820 1080   LEWIS-PALMER 38 80582001489 4686 RAY E KILMER ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 30 0 4   0 1     0   0   23 12                       35 30 0 4   0 1     0   0   23 12                 35
842974 CO     school 804320 1350   EAST GRAND 2 80432000594 3182 FRASER VALLEY ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 33 0 2   0 0     0   0   15 20                       35 33 0 2   0 0     0   0   15 20                 35
843445 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000722 2946 FITZMORRIS ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 19 1 12   0 0     0   3   20 15                       35 19 1 12   0 0     0   3   20 15                 35
847075 CO     school 803300 2730   DEL NORTE C-7 80330000292 8960 UNDERWOOD ELEMENTARY SCHOOL   Regular School No 1.0 KG 04 2016   grade_2 14 0 18   0 0     0   3   13 22                       35 14 0 18   0 0     0   3   13 22                 35
848248 CO     school   8001   CHARTER SCHOOL INSTITUTE   657 T.R. PAUL ACADEMY OF ARTS & KNOWLEDGE             2016   grade_2 26 0 2   1 4     0   2   14 21                       35 26 0 2   1 4     0   2   14 21                 35
836506 CO     school 803780 120   ENGLEWOOD 1 80378000497 9620 WM E BISHOP ELEMENTARY SCHOOL   Regular School No 1.0 KG 06 2016   grade_2 8 0 28   0 0     0   0   14 22                       36 8 0 28   0 0     0   0   14 22                 36
838494 CO     school 802490 480   BOULDER VALLEY RE 2 80249000130 6208 NEDERLAND ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 32 0 2   1 0     0   1   21 15                       36 32 0 2   1 0     0   1   21 15                 36
838881 CO     school 803330 870   DELTA COUNTY 50(J) 80333002024 2166 DELTA VISION SCHOOL   Alternative Education School Yes 4.0 KG 12 2016   grade_2 31 1 3   1 0     0   0   12 24                       36 31 1 3   1 0     0   0   12 24                 36
841418 CO     school 804530 980   HARRISON 2 80453000671 8337 STRATMOOR HILLS ELEMENTARY SCHOOL   Regular School No 1.0 PK 05 2016   grade_2 15 6 11   0 0     0   4   18 18                       36 15 6 11   0 0     0   4   18 18                 36
844187 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000788 8300 STOTT ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2016   grade_2 26 1 8   0 1     0   0   17 19                       36 26 1 8   0 1     0   0   17 19                 36

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