Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2017 · 1,082

grade

  • grade_2 · 1,082
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int ▼ native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
709487 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_2 1 2 0   0 0     0   0   2 1                       3 1 2 0   0 0     0   0   2 1                 3
709989 CO     school 802700 190   BYERS 32J 80270006548 3362 VALIANT ACADEMY   Regular School No Other KG 12 2017   grade_2 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
710044 CO     school 806090 240   PRITCHETT RE-3 80609001026 7174 PRITCHETT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
710090 CO     school 802760 270   CAMPO RE-6 80276000169 1248 CAMPO ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
710140 CO     school 805580 310   MC CLAVE RE-2 80558000962 5666 MC CLAVE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 23 0 0   0 0     0   0   15 8                       23 23 0 0   0 0     0   0   15 8                 23
710726 CO     school 802490 480   BOULDER VALLEY RE 2 80249000115 2970 FLATIRONS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 32 0 0   0 3     0   1   24 12                       36 32 0 0   0 3     0   1   24 12                 36
710741 CO     school 802490 480   BOULDER VALLEY RE 2 80249000117 3488 GOLD HILL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
710771 CO     school 802490 480   BOULDER VALLEY RE 2 80249000119 4386 JAMESTOWN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
711025 CO     school 800001 520   CHEYENNE COUNTY RE-5 80000100214 1608 CHEYENNE WELLS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 13 0 0   0 0     0   0   8 5                       13 13 0 0   0 0     0   0   8 5                 13
711067 CO     school 803000 540   CLEAR CREEK RE-1 80300001332 4700 KING-MURPHY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 12 0 0   0 0     0   0   6 6                       12 12 0 0   0 0     0   0   6 6                 12
711188 CO     school 807200 860   CUSTER COUNTY SCHOOL DISTRICT C-1 80720001226 2088 CUSTER COUNTY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 27 1 0   0 0     0   0   11 17                       28 27 1 0   0 0     0   0   11 17                 28
711305 CO     school 803330 870   DELTA COUNTY 50(J) 80333006667 6295 NORTH FORK SCHOOL OF INTEGRATED STUDIES   Regular School No Elementary KG 05 2017   grade_2 4 0 0   0 0     0   0   3 1                       4 4 0 0   0 0     0   0   3 1                 4
712664 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342001958 50 RICO ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
712835 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000439 1578 CHERRY VALLEY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_2 3 1 0   0 0     0   0   2 2                       4 3 1 0   0 0     0   0   2 2                 4
713453 CO     school 803540 910   EAGLE COUNTY RE 50 80354000851 2340 EAGLE COUNTY CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_2 37 0 0   0 0     0   1   21 17                       38 37 0 0   0 0     0   1   21 17                 38
713538 CO     school 803540 910   EAGLE COUNTY RE 50 80354006533 9701 WORLD ACADEMY   Regular School No Other KG 12 2017   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
713624 CO     school 803690 950   ELBERT 200 80369000480 2570 ELBERT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 14 0 0   0 0     0   0   7 7                       14 14 0 0   0 0     0   0   7 7                 14
714873 CO     school 803870 1110   FALCON 49 80387006462 2877 SPRINGS STUDIO FOR ACADEMIC EXCELLENCE   Regular School No Other KG 12 2017   grade_2 12 0 0   1 1     0   1   10 5                       15 12 0 0   1 1     0   1   10 5                 15
715164 CO     school 803120 1160   COTOPAXI RE-3 80312000276 3220 COTOPAXI ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 11 0 0   0 0     0   0   4 7                       11 11 0 0   0 0     0   0   4 7                 11
715432 CO     school 804470 1360   GUNNISON WATERSHED RE1J 80447001507 5577 MARBLE CHARTER SCHOOL   Regular School Yes Other KG 10 2017   grade_2 3 0 0   0 0     0   0   3 0                       3 3 0 0   0 0     0   0   3 0                 3
715446 CO     school 804620 1380   HINSDALE COUNTY RE 1 80462001969 4899 LAKE CITY COMMUNITY SCHOOL   Regular School No Other PK 12 2017   grade_2 4 0 0   1 0     0   0   5 0                       5 4 0 0   1 0     0   0   5 0                 5
716202 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000756 5892 MILLER SPECIAL EDUCATION   Special Education School No Other PK 12 2017   grade_2 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
716523 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006307 8036 SOBESKY ACADEMY   Special Education School No Other KG 12 2017   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
716821 CO     school 806930 1440   PLAINVIEW RE-2 80693001198 6992 PLAINVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 6 0 0   0 0     0   0   2 4                       6 6 0 0   0 0     0   0   2 4                 6
717270 CO     school 803990 1550   POUDRE R-1 80399000537 5234 LIVERMORE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 4 0 0   0 0     0   0   2 2                       4 4 0 0   0 0     0   0   2 2                 4
717336 CO     school 803990 1550   POUDRE R-1 80399006334 7104 POLARIS EXPEDITIONARY LEARNING SCHOOL   Alternative School No Other KG 12 2017   grade_2 18 0 0   0 0     0   0   7 11                       18 18 0 0   0 0     0   0   7 11                 18
717364 CO     school 803990 1550   POUDRE R-1 80399006431 7198 PSD GLOBAL ACADEMY   Regular School No Other KG 12 2017   grade_2 12 0 0   0 0     0   0   6 6                       12 12 0 0   0 0     0   0   6 6                 12
717421 CO     school 803990 1550   POUDRE R-1 80399000546 8318 STOVE PRAIRIE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
717730 CO     school 803810 1570   ESTES PARK R-3 80381006426 2788 ESTES PARK OPTIONS SCHOOL   Alternative School No Other KG 12 2017   grade_2 6 0 0   0 0     0   0   5 1                       6 6 0 0   0 0     0   0   5 1                 6
717850 CO     school 804980 1760   KIM REORGANIZED 88 80498000822 4690 KIM ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 3 0 0   0 0     0   1   2 2                       4 3 0 0   0 0     0   1   2 2                 4
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
717896 CO     school 804890 1810   KARVAL RE-23 80489000814 4502 KARVAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 4 0 0   0 0     0   0   2 2                       4 4 0 0   0 0     0   0   2 2                 4
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
718157 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000611 3350 GATEWAY SCHOOL   Regular School No Other PK 12 2017   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
718180 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435006498 3604 GRAND RIVER ACADEMY   Regular School No Other KG 12 2017   grade_2 2 0 0   0 0     0   1   2 1                       3 2 0 0   0 0     0   1   2 1                 3
718365 CO     school 803150 2010   CREEDE SCHOOL DISTRICT 80315000279 1966 CREEDE SCHOOL   Regular School No Other PK 12 2017   grade_2 3 0 0   0 0     0   0   0 3                       3 3 0 0   0 0     0   0   0 3                 3
718398 CO     school 805730 2020   MOFFAT COUNTY RE:NO 1 80573000980 5656 MAYBELL SCHOOL   Regular School No Elementary KG 05 2017   grade_2 3 0 0   0 0     0   0   3 0                       3 3 0 0   0 0     0   0   3 0                 3
718841 CO     school 805970 2580   OURAY R-1 80597001018 6596 OURAY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 13 0 0   0 0     0   0   10 3                       13 13 0 0   0 0     0   0   10 3                 13
718894 CO     school 803840 2610   PARK COUNTY RE-2 80384001695 3681 GUFFEY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_2 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
719349 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Regular School No Other KG 12 2017   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
719583 CO     school 806660 2770   STEAMBOAT SPRINGS RE-2 80666001749 6363 NORTH ROUTT CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 11 0 0   0 0     0   0   5 6                       11 11 0 0   0 0     0   0   5 6                 11
719710 CO     school 806570 2820   SILVERTON 1 80657001136 7900 SILVERTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 5 0 0   0 0     0   0   2 3                       5 5 0 0   0 0     0   0   2 3                 5
719941 CO     school 805940 3050   OTIS R-3 80594001016 6582 OTIS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 22 0 0   0 0     0   1   11 12                       23 22 0 0   0 0     0   1   11 12                 23
719973 CO     school 807410 3070   WOODLIN R-104 80741001270 9700 WOODLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 8 1 0   0 0     0   0   5 4                       9 8 1 0   0 0     0   0   5 4                 9
720285 CO     school 804410 3120   GREELEY 6 80441006505 2825 ENGAGE ONLINE ACADEMY   Regular School No Other KG 12 2017   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
720636 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2017   grade_2 9 0 0   0 0     0   0   6 3                       9 9 0 0   0 0     0   0   6 3                 9
720790 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001780 4277 INDIAN PEAKS CHARTER SCHOOL   Regular School Yes Elementary KG 08 2017   grade_2 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
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
720883 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006651 8061 SALIDA MONTESSORI CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_2 10 0 0   0 0     0   0   4 6                       10 10 0 0   0 0     0   0   4 6                 10
710578 CO     school 802490 480   BOULDER VALLEY RE 2 80249006557 866 BOULDER EXPLORE   Regular School No Other KG 12 2017   grade_2 1 0 1   0 0     0   1   1 2                       3 1 0 1   0 0     0   1   1 2                 3
710678 CO     school 802490 480   BOULDER VALLEY RE 2 80249000111 2240 DOUGLASS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 62 0 1   0 2     0   8   39 34                       73 62 0 1   0 2     0   8   39 34                 73
710763 CO     school 802490 480   BOULDER VALLEY RE 2 80249001243 3940 HIGH PEAKS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 34 1 1   0 12     0   2   24 26                       50 34 1 1   0 12     0   2   24 26                 50
711008 CO     school 805040 510   KIT CARSON R-1 80504000827 4738 KIT CARSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 8 0 1   0 0     0   0   5 4                       9 8 0 1   0 0     0   0   5 4                 9
712327 CO     school 803360 880   DENVER COUNTY 1 80336006641 7243 REACH CHARTER SCHOOL   Regular School Yes Elementary PK 03 2017   grade_2 3 1 1   0 0     0   0   2 3                       5 3 1 1   0 0     0   0   2 3                 5
713645 CO     school 802730 970   CALHAN RJ-1 80273000167 1210 CALHAN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 14 4 1   2 0     0   0   14 7                       21 14 4 1   2 0     0   0   14 7                 21
714464 CO     school 805490 1030   MANITOU SPRINGS 14 80549000948 9010 UTE PASS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 19 0 1   0 0     1   0   8 13                       21 19 0 1   0 0     1   0   8 13                 21
714545 CO     school 801920 1040   ACADEMY 20 80192006478 1901 ACADEMY CALVERT K-8 ONLINE SCHOOL   Regular School No Elementary KG 08 2017   grade_2 5 0 1   0 0     0   2   5 3                       8 5 0 1   0 0     0   2   5 3                 8
714745 CO     school 806060 1060   PEYTON 23 JT 80606001024 6898 PEYTON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 32 2 1   0 0     0   2   20 17                       37 32 2 1   0 0     0   2   20 17                 37
715035 CO     school 803630 1120   EDISON 54 JT 80363000478 2514 EDISON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 8 0 1   0 0     0   0   8 1                       9 8 0 1   0 0     0   0   8 1                 9
715670 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000704 1730 COAL CREEK CANYON K-8 ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2017   grade_2 22 0 1   0 0     0   0   7 16                       23 22 0 1   0 0     0   0   7 16                 23
716423 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001812 7462 ROCKY MOUNTAIN ACADEMY OF EVERGREEN   Regular School Yes Elementary PK 08 2017   grade_2 30 0 1   0 0     0   1   16 16                       32 30 0 1   0 0     0   1   16 16                 32
716855 CO     school 806510 1460   HI-PLAINS R-23 80651001130 7746 HI-PLAINS SCHOOL DISTRICT R-23   Regular School No Other PK 12 2017   grade_2 6 0 1   1 0     0   0   3 5                       8 6 0 1   1 0     0   0   3 5                 8
716958 CO     school 803480 1520   DURANGO 9-R 80348006614 2097 DISTRICT 9-R SHARED SCHOOL   Regular School No Other KG 12 2017   grade_2 19 1 1   0 0     0   0   14 7                       21 19 1 1   0 0     0   0   14 7                 21
716981 CO     school 803480 1520   DURANGO 9-R 80348000450 3050 FORT LEWIS MESA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 16 0 1   0 0     0   0   8 9                       17 16 0 1   0 0     0   0   8 9                 17
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
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
717587 CO     school 805400 1560   THOMPSON R2-J 80540006558 5121 LEAP SCHOOL   Regular School No Other KG 12 2017   grade_2 15 0 1   0 0     0   2   7 11                       18 15 0 1   0 0     0   2   7 11                 18
717915 CO     school 806690 1828   VALLEY RE-1 80669001361 1220 CALICHE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 15 0 1   0 0     0   1   10 7                       17 15 0 1   0 0     0   1   10 7                 17
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
718014 CO     school 803030 1990   PLATEAU VALLEY 50 80303000219 7024 PLATEAU VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 11 1 1   1 0     0   0   7 7                       14 11 1 1   1 0     0   0   7 7                 14
718135 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435001552 2724 NEW EMERSON SCHOOL AT COLUMBUS   Regular School No Elementary KG 05 2017   grade_2 23 0 1   0 0     0   1   14 11                       25 23 0 1   0 0     0   1   14 11                 25
718193 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435006581 4439 JUNIPER RIDGE COMMUNITY SCHOOL   Regular School Yes Other KG 09 2017   grade_2 23 0 1   0 0     0   1   10 15                       25 23 0 1   0 0     0   1   10 15                 25
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
718483 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309000841 7082 PLEASANT VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 1 0 1   0 0     0   0   1 1                       2 1 0 1   0 0     0   0   1 1                 2
718566 CO     school 805790 2180   MONTROSE COUNTY RE-1J 80579006499 6262 PEAK VIRTUAL ACADEMY   Regular School No Other KG 12 2017   grade_2 4 0 1   0 0     0   0   3 2                       5 4 0 1   0 0     0   0   3 2                 5
718970 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2017   grade_2 14 0 1   0 0     0   1   8 8                       16 14 0 1   0 0     0   1   8 8                 16
719328 CO     school 806150 2700   PUEBLO COUNTY 70 80615001071 852 BEULAH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 10 0 1   0 0     0   0   5 6                       11 10 0 1   0 0     0   0   5 6                 11
719659 CO     school 805700 2800   MOFFAT 2 80570001511 2018 CRESTONE CHARTER SCHOOL   Regular School Yes Other KG 12 2017   grade_2 5 0 1   0 0     0   0   0 6                       6 5 0 1   0 0     0   0   0 6                 6
719784 CO     school 806000 2865   REVERE SCHOOL DISTRICT 80600001020 7050 REVERE ELEMENTARY   Regular School No Elementary KG 06 2017   grade_2 11 0 1   0 0     0   0   3 9                       12 11 0 1   0 0     0   0   3 9                 12
719807 CO     school 806810 3000   SUMMIT RE-1 80681001166 8372 BRECKENRIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 38 1 1   0 0     0   2   20 22                       42 38 1 1   0 0     0   2   20 22                 42
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
709117 CO     school 802910 130   CHERRY CREEK 5 80291006676 4189 HERITAGE HEIGHTS ACADEMY   Regular School Yes Elementary KG 05 2017   grade_2 17 1 2   0 3     0   1   13 11                       24 17 1 2   0 3     0   1   13 11                 24
710028 CO     school 807110 230   WALSH RE-1 80711001215 9222 WALSH ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 10 0 2   0 0     0   1   4 9                       13 10 0 2   0 0     0   1   4 9                 13
710075 CO     school 806990 260   VILAS RE-5 80699001206 9090 VILAS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 1 0 2   0 0     0   0   3 0                       3 1 0 2   0 0     0   0   3 0                 3
710494 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006430 7565 ST. VRAIN COMMUNITY MONTESSORI SCHOOL   Regular School Yes Elementary PK 08 2017   grade_2 20 1 2   0 0     0   0   15 8                       23 20 1 2   0 0     0   0   15 8                 23
710878 CO     school 802490 480   BOULDER VALLEY RE 2 80249006199 6642 HORIZONS K-8 SCHOOL   Alternative School Yes Elementary KG 08 2017   grade_2 31 0 2   0 1     0   5   18 21                       39 31 0 2   0 1     0   5   18 21                 39
711044 CO     school 803000 540   CLEAR CREEK RE-1 80300001999 3385 GEORGETOWN COMMUNITY SCHOOL   Regular School Yes Elementary PK 06 2017   grade_2 14 0 2   1 0     0   0   11 6                       17 14 0 2   1 0     0   0   11 6                 17
711053 CO     school 803000 540   CLEAR CREEK RE-1 80300000218 4212 CARLSON ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 27 1 2   0 1     0   3   14 20                       34 27 1 2   0 1     0   3   14 20                 34
711873 CO     school 803360 880   DENVER COUNTY 1 80336006559 3698 CREATIVITY CHALLENGE COMMUNITY   Regular School No Elementary KG 05 2017   grade_2 46 1 2   1 1     0   0   29 22                       51 46 1 2   1 1     0   0   29 22                 51
712390 CO     school 803360 880   DENVER COUNTY 1 80336001524 7972 SLAVENS K-8 SCHOOL   Regular School No Elementary KG 08 2017   grade_2 68 0 2   0 1     0   9   39 41                       80 68 0 2   0 1     0   9   39 41                 80
713065 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000441 4980 LARKSPUR ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2017   grade_2 27 1 2   0 1     0   0   16 15                       31 27 1 2   0 1     0   0   16 15                 31
713607 CO     school 806600 940   BIG SANDY 100J 80660001138 7914 SIMLA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 24 0 2   0 0     0   0   13 13                       26 24 0 2   0 0     0   0   13 13                 26
714140 CO     school 803060 1010   COLORADO SPRINGS 11 80306001318 3470 GLOBE CHARTER SCHOOL   Regular School Yes Elementary KG 06 2017   grade_2 16 5 2   0 1     0   2   16 10                       26 16 5 2   0 1     0   2   16 10                 26
714559 CO     school 801920 1040   ACADEMY 20 80192006631 1929 DISCOVERY CANYON CAMPUS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 55 6 2   0 2     1   4   39 31                       70 55 6 2   0 2     1   4   39 31                 70
715399 CO     school 804470 1360   GUNNISON WATERSHED RE1J 80447006629 1447 CRESTED BUTTE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 61 0 2   0 0     0   2   39 26                       65 61 0 2   0 0     0   2   39 26                 65
715485 CO     school 805160 1400   LA VETA RE-2 80516000853 4860 LA VETA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 7 0 2   0 0     0   0   7 2                       9 7 0 2   0 0     0   0   7 2                 9
715504 CO     school 807050 1410   NORTH PARK R-1 80705001209 6358 NORTH PARK SCHOOL   Regular School No Other PK 12 2017   grade_2 7 0 2   0 0     0   0   4 5                       9 7 0 2   0 0     0   0   4 5                 9
715813 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001500 2616 ELK CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 48 0 2   0 0     0   3   26 27                       53 48 0 2   0 0     0   3   26 27                 53
715994 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001921 4404 JEFFERSON ACADEMY   Regular School Yes Other KG 12 2017   grade_2 48 2 2   0 2     0   2   26 30                       56 48 2 2   0 2     0   2   26 30                 56
716152 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001606 5415 ROCKY MOUNTAIN DEAF SCHOOL   Special Education School Yes Other PK 12 2017   grade_2 2 0 2   0 0     0   0   1 3                       4 2 0 2   0 0     0   0   1 3                 4

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