Data source: Big Local News · About: Big Local

1,104 rows where grade = "grade_2", state = "CO" and year = 2019 sorted by hispanic

View and edit SQL

year

  • 2019 · 1,104

grade

  • grade_2 · 1,104
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
1931985 CO     school 806420 110   SANGRE DE CRISTO RE-22J 80642001115 7626 SANGRE DE CRISTO ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 21 0 0   0 0     0   0   11 10                       21 21 0 0   0 0     0   0   11 10                 21
1932685 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_2 0 0 0   0 1     0   0   0 1                       1 0 0 0   0 1     0   0   0 1                 1
1933218 CO     school 802700 190   BYERS 32J 80270006749 8994 VALIANT ACADEMY ELEMENTARY SCHOOL   Regular School Yes Elementary PK 05 2019   grade_2 5 1 0   0 0     0   0   3 3                       6 5 1 0   0 0     0   0   3 3                 6
1933246 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219006717 6679 PAGOSA PEAK OPEN SCHOOL   Regular School Yes Elementary KG 05 2019   grade_2 7 0 0   0 1     0   1   5 4                       9 7 0 0   0 1     0   1   5 4                 9
1933302 CO     school 806990 260   VILAS RE-5 80699001206 9090 VILAS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1933316 CO     school 802760 270   CAMPO RE-6 80276000169 1248 CAMPO ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 2 0 0   0 0     0   1   2 1                       3 2 0 0   0 0     0   1   2 1                 3
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
1933983 CO     school 802490 480   BOULDER VALLEY RE 2 80249000117 3488 GOLD HILL ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 5 0 0   0 0     0   0   4 1                       5 5 0 0   0 0     0   0   4 1                 5
1934269 CO     school 803000 540   CLEAR CREEK RE-1 80300001999 3385 GEORGETOWN COMMUNITY SCHOOL   Regular School Yes Elementary PK 06 2019   grade_2 10 0 0   0 0     0   1   10 1                       11 10 0 0   0 0     0   1   10 1                 11
1934292 CO     school 803000 540   CLEAR CREEK RE-1 80300001332 4700 KING-MURPHY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 17 0 0   0 0     0   0   5 12                       17 17 0 0   0 0     0   0   5 12                 17
1934522 CO     school 803330 870   DELTA COUNTY 50(J) 80333006667 6295 NORTH FORK SCHOOL OF INTEGRATED STUDIES   Regular School No Elementary KG 06 2019   grade_2 9 0 0   0 0     0   0   5 4                       9 9 0 0   0 0     0   0   5 4                 9
1935488 CO     school 803360 880   DENVER COUNTY 1 80336001636 6479 ODYSSEY SCHOOL OF DENVER   Regular School Yes Elementary KG 08 2019   grade_2 16 2 0   1 2     0   3   13 11                       24 16 2 0   1 2     0   3   13 11                 24
1935926 CO     school 803420 890   DOLORES COUNTY RE NO.2 80342000435 7764 SEVENTH STREET ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 15 0 0   0 0     0   1   12 4                       16 15 0 0   0 0     0   1   12 4                 16
1936086 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006494 1555 CLOVERLEAF HOME EDUCATION   Alternative School No Other KG 12 2019   grade_2 35 0 0   0 0     0   4   17 22                       39 35 0 0   0 0     0   4   17 22                 39
1936903 CO     school 803690 950   ELBERT 200 80369000480 2570 ELBERT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 14 0 0   0 0     0   0   4 10                       14 14 0 0   0 0     0   0   4 10                 14
1938784 CO     school 804620 1380   HINSDALE COUNTY RE 1 80462001969 4899 LAKE CITY COMMUNITY SCHOOL   Regular School No Other PK 12 2019   grade_2 5 0 0   0 0     0   1   4 2                       6 5 0 0   0 0     0   1   4 2                 6
1939004 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000704 1730 COAL CREEK CANYON K-8 ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2019   grade_2 16 0 0   0 0     0   0   11 5                       16 16 0 0   0 0     0   0   11 5                 16
1939731 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001812 7462 ROCKY MOUNTAIN ACADEMY OF EVERGREEN   Regular School Yes Elementary KG 08 2019   grade_2 19 0 0   0 1     0   0   10 10                       20 19 0 0   0 1     0   0   10 10                 20
1940127 CO     school 806930 1440   PLAINVIEW RE-2 80693001198 6992 PLAINVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1940267 CO     school 803480 1520   DURANGO 9-R 80348006614 2097 DISTRICT 9-R SHARED SCHOOL   Regular School No Other KG 12 2019   grade_2 18 0 0   1 0     0   1   13 7                       20 18 0 0   1 0     0   1   13 7                 20
1940593 CO     school 803990 1550   POUDRE R-1 80399000537 5234 LIVERMORE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 8 0 0   0 0     0   0   4 4                       8 8 0 0   0 0     0   0   4 4                 8
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
1940689 CO     school 803990 1550   POUDRE R-1 80399006431 7198 PSD GLOBAL ACADEMY   Regular School No Other KG 12 2019   grade_2 11 0 0   0 1     0   2   10 4                       14 11 0 0   0 1     0   2   10 4                 14
1940747 CO     school 803990 1550   POUDRE R-1 80399000546 8318 STOVE PRAIRIE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 8 0 0   0 0     0   0   3 5                       8 8 0 0   0 0     0   0   3 5                 8
1941055 CO     school 803810 1570   ESTES PARK R-3 80381006426 2788 ESTES PARK OPTIONS SCHOOL   Alternative School No Other KG 12 2019   grade_2 7 0 0   0 0     0   0   4 3                       7 7 0 0   0 0     0   0   4 3                 7
1941163 CO     school 802520 1750   BRANSON REORGANIZED 82 80252000141 978 BRANSON SCHOOL   Regular School No Other PK 12 2019   grade_2 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
1941173 CO     school 804980 1760   KIM REORGANIZED 88 80498000822 4690 KIM ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1941219 CO     school 804890 1810   KARVAL RE-23 80489000814 4502 KARVAL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1941301 CO     school 806030 1870   PLATEAU RE-5 80603001022 6834 PEETZ ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 10 0 0   0 0     0   0   4 6                       10 10 0 0   0 0     0   0   4 6                 10
1941337 CO     school 803030 1990   PLATEAU VALLEY 50 80303000219 7024 PLATEAU VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 23 0 0   0 0     0   1   11 13                       24 23 0 0   0 0     0   1   11 13                 24
1941481 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435000611 3350 GATEWAY SCHOOL   Regular School No Other PK 12 2019   grade_2 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
1941504 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435006498 3604 GRAND RIVER ACADEMY   Regular School No Other KG 12 2019   grade_2 3 0 0   0 0     0   0   3 0                       3 3 0 0   0 0     0   0   3 0                 3
1941713 CO     school 805730 2020   MOFFAT COUNTY RE:NO 1 80573000980 5656 MAYBELL SCHOOL   Regular School No Elementary KG 06 2019   grade_2 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
1941929 CO     school 805850 2190   WEST END RE-2 80585001398 6196 NATURITA ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 13 0 0   1 0     0   0   7 7                       14 13 0 0   1 0     0   0   7 7                 14
1941948 CO     school 805850 2190   WEST END RE-2 80585001693 6718 PARADOX VALLEY CHARTER SCHOOL   Regular School Yes Other PK 12 2019   grade_2 4 0 0   0 0     0   0   3 1                       4 4 0 0   0 0     0   0   3 1                 4
1942197 CO     school 803840 2610   PARK COUNTY RE-2 80384001695 3681 GUFFEY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1942904 CO     school 806660 2770   STEAMBOAT SPRINGS RE-2 80666001749 6363 NORTH ROUTT CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 8 0 0   0 0     0   0   4 4                       8 8 0 0   0 0     0   0   4 4                 8
1942963 CO     school 806300 2790   MOUNTAIN VALLEY RE 1 80630001415 6146 MOUNTAIN VALLEY SCHOOL   Regular School No Other PK 12 2019   grade_2 10 0 0   0 0     0   0   5 5                       10 10 0 0   0 0     0   0   5 5                 10
1942992 CO     school 805700 2800   MOFFAT 2 80570000974 5958 MOFFAT PREK-12 SCHOOL   Regular School No Other PK 12 2019   grade_2 8 1 0   0 0     0   0   6 3                       9 8 1 0   0 0     0   0   6 3                 9
1943261 CO     school 805940 3050   OTIS R-3 80594001016 6582 OTIS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 13 0 0   0 0     0   0   8 5                       13 13 0 0   0 0     0   0   8 5                 13
1943293 CO     school 807410 3070   WOODLIN R-104 80741001270 9700 WOODLIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 8 0 0   0 0     0   0   5 3                       8 8 0 0   0 0     0   0   5 3                 8
1943846 CO     school 806720 3147   PRAIRIE RE-11 80672001157 7154 PRAIRIE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 16 0 0   0 0     0   0   8 8                       16 16 0 0   0 0     0   0   8 8                 16
1943865 CO     school 804440 3148   PAWNEE RE-12 80444000653 6812 PAWNEE SCHOOL PK-12   Regular School No Other PK 12 2019   grade_2 6 0 0   0 0     0   0   1 5                       6 6 0 0   0 0     0   0   1 5                 6
1943957 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001720 35 FRONTIER CHARTER ACADEMY   Regular School Yes Elementary KG 08 2019   grade_2 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1944129 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001780 4277 INDIAN PEAKS CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1944175 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006706 5845 MONUMENT VIEW MONTESSORI CHARTER SCHOOL   Regular School Yes Elementary PK 04 2019   grade_2 3 0 0   0 0     0   1   2 2                       4 3 0 0   0 0     0   1   2 2                 4
1944248 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006651 8061 SALIDA MONTESSORI CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_2 10 1 0   0 0     0   0   3 8                       11 10 1 0   0 0     0   0   3 8                 11
1933253 CO     school 807110 230   WALSH RE-1 80711001215 9222 WALSH ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 7 0 1   0 0     0   2   5 5                       10 7 0 1   0 0     0   2   5 5                 10
1933269 CO     school 806090 240   PRITCHETT RE-3 80609001026 7174 PRITCHETT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1933726 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006430 7565 ST. VRAIN COMMUNITY MONTESSORI SCHOOL   Regular School Yes Elementary PK 08 2019   grade_2 31 0 1   0 0     0   1   22 11                       33 31 0 1   0 0     0   1   22 11                 33
1933969 CO     school 802490 480   BOULDER VALLEY RE 2 80249000115 2970 FLATIRONS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 25 0 1   0 0     0   1   17 10                       27 25 0 1   0 0     0   1   17 10                 27
1933997 CO     school 802490 480   BOULDER VALLEY RE 2 80249001243 3940 HIGH PEAKS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 37 0 1   0 4     0   6   27 21                       48 37 0 1   0 4     0   6   27 21                 48
1934004 CO     school 802490 480   BOULDER VALLEY RE 2 80249000119 4386 JAMESTOWN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 2 0 1   0 0     0   1   1 3                       4 2 0 1   0 0     0   1   1 3                 4
1934234 CO     school 805040 510   KIT CARSON R-1 80504000827 4738 KIT CARSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 2 0 1   0 0     0   0   1 2                       3 2 0 1   0 0     0   0   1 2                 3
1934250 CO     school 800001 520   CHEYENNE COUNTY RE-5 80000100214 1608 CHEYENNE WELLS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 15 0 1   0 0     0   0   5 11                       16 15 0 1   0 0     0   0   5 11                 16
1936097 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000439 1578 CHERRY VALLEY ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_2 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
1936919 CO     school 801980 960   AGATE 300 80198000020 44 AGATE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 3 0 1   0 0     0   0   2 2                       4 3 0 1   0 0     0   0   2 2                 4
1937681 CO     school 802940 1020   CHEYENNE MOUNTAIN 12 80294001391 1586 CHEYENNE MOUNTAIN ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_2 39 3 1   0 0     0   3   19 27                       46 39 3 1   0 0     0   3   19 27                 46
1938241 CO     school 803870 1110   DISTRICT 49 80387006744 5191 LIBERTY TREE ACADEMY   Regular School Yes Elementary KG 08 2019   grade_2 39 0 1   0 0     0   2   23 19                       42 39 0 1   0 0     0   2   23 19                 42
1938364 CO     school 803630 1120   EDISON 54 JT 80363000478 2514 EDISON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 9 0 1   0 0     0   0   3 7                       10 9 0 1   0 0     0   0   3 7                 10
1938771 CO     school 804470 1360   GUNNISON WATERSHED RE1J 80447001507 5577 MARBLE CHARTER SCHOOL   Regular School Yes Other KG 10 2019   grade_2 4 0 1   0 0     0   0   2 3                       5 4 0 1   0 0     0   0   2 3                 5
1939059 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001766 1880 COMPASS MONTESSORI - GOLDEN CHARTER SCHOOL   Regular School Yes Other PK 12 2019   grade_2 15 0 1   0 0     0   2   10 8                       18 15 0 1   0 0     0   2   10 8                 18
1939218 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001920 3201 FREE HORIZON MONTESSORI   Regular School No Elementary PK 08 2019   grade_2 43 1 1   0 0     0   1   31 15                       46 43 1 1   0 0     0   1   31 15                 46
1940053 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001549 9429 WEST WOODS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 99 1 1   0 2     0   3   55 51                       106 99 1 1   0 2     0   3   55 51                 106
1940092 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000805 9648 WILMOT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 46 1 1   0 0     0   2   27 23                       50 46 1 1   0 0     0   2   27 23                 50
1940146 CO     school 802260 1450   ARRIBA-FLAGLER C-20 80226000509 2960 FLAGLER PUBLIC SCHOOL   Regular School No Other PK 12 2019   grade_2 10 0 1   0 0     0   0   0 11                       11 10 0 1   0 0     0   0   0 11                 11
1940500 CO     school 803990 1550   POUDRE R-1 80399006613 3242 FORT COLLINS MONTESSORI SCHOOL   Regular School Yes Elementary PK 06 2019   grade_2 15 0 1   0 1     0   0   10 7                       17 15 0 1   0 1     0   0   10 7                 17
1940709 CO     school 803990 1550   POUDRE R-1 80399000543 7290 RED FEATHER LAKES ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 7 0 1   0 0     0   1   5 4                       9 7 0 1   0 0     0   1   5 4                 9
1940913 CO     school 805400 1560   THOMPSON R2-J 80540006558 5121 LEAP SCHOOL   Regular School No Other KG 12 2019   grade_2 25 0 1   0 0     0   1   16 11                       27 25 0 1   0 0     0   1   16 11                 27
1941192 CO     school 804740 1780   GENOA-HUGO C113 80474000686 4162 GENOA-HUGO SCHOOL   Regular School No Other PK 12 2019   grade_2 13 0 1   0 0     0   0   8 6                       14 13 0 1   0 0     0   0   8 6                 14
1941270 CO     school 803930 1850   FRENCHMAN RE-3 80393000511 2980 FLEMING ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 10 0 1   0 0     0   0   6 5                       11 10 0 1   0 0     0   0   6 5                 11
1941689 CO     school 803150 2010   CREEDE SCHOOL DISTRICT 80315000279 1966 CREEDE SCHOOL   Regular School No Other PK 12 2019   grade_2 9 0 1   0 0     0   0   4 6                       10 9 0 1   0 0     0   0   4 6                 10
1941796 CO     school 803090 2035   MONTEZUMA-CORTEZ RE-1 80309000841 7082 PLEASANT VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 3 0 1   0 0     0   0   3 1                       4 3 0 1   0 0     0   0   3 1                 4
1942146 CO     school 805970 2580   OURAY R-1 80597001018 6596 OURAY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 12 0 1   0 0     0   0   7 6                       13 12 0 1   0 0     0   0   7 6                 13
1942208 CO     school 803840 2610   PARK COUNTY RE-2 80384000501 4908 LAKE GEORGE CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_2 8 0 1   1 0     0   4   5 9                       14 8 0 1   1 0     0   4   5 9                 14
1942274 CO     school 802280 2640   ASPEN 1 80228001703 42 ASPEN COMMUNITY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_2 13 0 1   0 0     1   0   8 7                       15 13 0 1   0 0     1   0   8 7                 15
1942663 CO     school 806150 2700   PUEBLO COUNTY 70 80615006496 5990 70 ONLINE   Alternative School No Other KG 12 2019   grade_2 2 0 1   0 0     0   1   2 2                       4 2 0 1   0 0     0   1   2 2                 4
1942978 CO     school 805700 2800   MOFFAT 2 80570001511 2018 CRESTONE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_2 4 0 1   0 1     0   0   3 3                       6 4 0 1   0 1     0   0   3 3                 6
1943031 CO     school 806570 2820   SILVERTON 1 80657001136 7900 SILVERTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 5 0 1   0 0     0   0   4 2                       6 5 0 1   0 0     0   0   4 2                 6
1943069 CO     school 805880 2840   NORWOOD R-2J 80588001012 6422 NORWOOD PUBLIC SCHOOLS   Regular School No Other PK 12 2019   grade_2 14 0 1   0 0     0   0   7 8                       15 14 0 1   0 0     0   0   7 8                 15
1943102 CO     school 806000 2865   REVERE SCHOOL DISTRICT 80600001020 7050 REVERE ELEMENTARY   Regular School No Elementary KG 06 2019   grade_2 6 0 1   1 0     0   0   6 2                       8 6 0 1   1 0     0   0   6 2                 8
1943830 CO     school 802550 3146   BRIGGSDALE RE-10 80255000142 1008 BRIGGSDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 11 0 1   0 0     0   0   5 7                       12 11 0 1   0 0     0   0   5 7                 12
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
1943930 CO     school 800019 3230   LIBERTY J-4 80001901744 5123 LIBERTY SCHOOL   Career and Technical School No Other PK 12 2019   grade_2 7 0 1   0 0     0   0   5 3                       8 7 0 1   0 0     0   0   5 3                 8
1943992 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001998 657 ACADEMY OF ARTS AND KNOWLEDGE ELEMENTARY   Regular School Yes Elementary KG 05 2019   grade_2 28 1 1   0 0     1   1   14 18                       32 28 1 1   0 0     1   1   14 18                 32
1944151 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006701 5423 MOUNTAIN VILLAGE MONTESSORI CHARTER SCHOOL   Regular School Yes Elementary PK 06 2019   grade_2 27 0 1   0 1     0   0   17 12                       29 27 0 1   0 1     0   0   17 12                 29
1944323 CO     school 800004 9130   EXPEDITIONARY BOCES 80000400709 2840 ROCKY MOUNTAIN SCHOOL OF EXPEDITIONARY LEARNING   Regular School No Other KG 12 2019   grade_2 18 2 1   0 0     0   5   13 13                       26 18 2 1   0 0     0   5   13 13                 26
1931414 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006375 8211 THE STUDIO SCHOOL   Regular School No Elementary KG 05 2019   grade_2 36 1 10   1 1     0   5   20 34                       54 36 1 10   1 1     0   5   20 34                 54
1931807 CO     school 806750 60   STRASBURG 31J 80675001159 8328 STRASBURG ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 58 1 10   0 2     0   1   43 29                       72 58 1 10   0 2     0   1   43 29                 72
1932458 CO     school 802910 130   CHERRY CREEK 5 80291001468 8380 SUMMIT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 23 5 10   0 2     0   4   21 23                       44 23 5 10   0 2     0   4   21 23                 44
1932611 CO     school 805310 140   LITTLETON 6 80531000883 5572 HOPKINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 37 0 10   0 1     0   1   21 28                       49 37 0 10   0 1     0   1   21 28                 49
1932650 CO     school 805310 140   LITTLETON 6 80531000890 8064 MOODY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 34 0 10   0 1     0   2   26 21                       47 34 0 10   0 1     0   2   26 21                 47
1933011 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001674 7232 AURORA QUEST K-8   Regular School No Elementary KG 08 2019   grade_2 24 11 10   0 7     0   3   25 30                       55 24 11 10   0 7     0   3   25 30                 55
1933610 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000907 5284 LONGMONT ESTATES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 31 0 10   1 2     0   1   24 21                       45 31 0 10   1 2     0   1   24 21                 45
1933896 CO     school 802490 480   BOULDER VALLEY RE 2 80249001227 1883 COMMUNITY MONTESSORI SCHOOL   Regular School No Elementary PK 06 2019   grade_2 26 3 10   0 3     0   2   23 21                       44 26 3 10   0 3     0   2   23 21                 44
1933919 CO     school 802490 480   BOULDER VALLEY RE 2 80249000112 2552 EISENHOWER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 54 0 10   0 2     0   6   36 36                       72 54 0 10   0 2     0   6   36 36                 72
1933937 CO     school 802490 480   BOULDER VALLEY RE 2 80249006716 2639 MEADOWLARK SCHOOL   Regular School No Elementary PK 08 2019   grade_2 54 0 10   0 3     0   8   41 34                       75 54 0 10   0 3     0   8   41 34                 75
1934048 CO     school 802490 480   BOULDER VALLEY RE 2 80249000128 5606 CREEKSIDE ELEMENTARY SCHOOL AT MARTIN PARK   Regular School No Elementary PK 05 2019   grade_2 26 0 10   1 5     0   5   26 21                       47 26 0 10   1 5     0   5   26 21                 47
1934070 CO     school 802490 480   BOULDER VALLEY RE 2 80249001573 6000 MONARCH K-8 SCHOOL   Regular School No Elementary PK 08 2019   grade_2 34 1 10   0 16     0   3   29 35                       64 34 1 10   0 16     0   3   29 35                 64
1935650 CO     school 803360 880   DENVER COUNTY 1 80336001524 7972 SLAVENS K-8 SCHOOL   Regular School No Elementary KG 08 2019   grade_2 56 2 10   0 2     0   14   40 44                       84 56 2 10   0 2     0   14   40 44                 84

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