Data source: Big Local News · About: Big Local

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

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
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
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
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
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
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
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
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
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
1938487 CO     school 803120 1160   COTOPAXI RE-3 80312000276 3220 COTOPAXI ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 5 0 5   0 0     0   0   6 4                       10 5 0 5   0 0     0   0   6 4                 10
1940161 CO     school 806510 1460   HI-PLAINS R-23 80651001130 7746 HI-PLAINS SCHOOL DISTRICT R-23   Regular School No Other PK 12 2019   grade_2 8 0 2   0 0     0   0   6 4                       10 8 0 2   0 0     0   0   6 4                 10
1941130 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000022 58 AGUILAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 6 0 4   0 0     0   0   5 5                       10 6 0 4   0 0     0   0   5 5                 10
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
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
1942681 CO     school 806150 2700   PUEBLO COUNTY 70 80615006763 6817 PSAS HOMESCHOOL PROGRAM   Regular School No Elementary KG 08 2019   grade_2 8 0 2   0 0     0   0   6 4                       10 8 0 2   0 0     0   0   6 4                 10
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
1931161 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690000728 1519 STARGATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_2 58 0 11   0 25     0   6   49 51                       100 58 0 11   0 25     0   6   49 51                 100
1931378 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006507 6802 PROSPECT RIDGE ACADEMY   Regular School Yes Other KG 12 2019   grade_2 79 1 4   0 8     0   8   47 53                       100 79 1 4   0 8     0   8   47 53                 100
1937082 CO     school 804530 980   HARRISON 2 80453001965 8034 SOARING EAGLES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 36 13 36   2 4     0   9   47 53                       100 36 13 36   2 4     0   9   47 53                 100
1931600 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006549 1013 BRANTNER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 64 1 24   0 8     0   4   45 56                       101 64 1 24   0 8     0   4   45 56                 101
1932136 CO     school 802910 130   CHERRY CREEK 5 80291006301 1155 BUFFALO TRAIL ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 51 12 18   0 3     0   17   47 54                       101 51 12 18   0 3     0   17   47 54                 101
1934515 CO     school 803330 870   DELTA COUNTY 50(J) 80333000301 5154 LINCOLN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 64 0 29   1 4     0   3   47 54                       101 64 0 29   1 4     0   3   47 54                 101
1936362 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006493 5259 STEM SCHOOL HIGHLANDS RANCH   Regular School Yes Other KG 12 2019   grade_2 48 1 17   1 27     0   7   58 43                       101 48 1 17   1 27     0   7   58 43                 101
1943540 CO     school 804410 3120   GREELEY 6 80441001990 54 BELLA ROMERO ACADEMY OF APPLIED TECHNOLOGY   Regular School No Elementary KG 08 2019   grade_2 10 10 80   0 1     0   0   61 40                       101 10 10 80   0 1     0   0   61 40                 101
1932087 CO     school 802910 130   CHERRY CREEK 5 80291006750 102 ALTITUDE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 61 7 19   2 7     0   6   49 53                       102 61 7 19   2 7     0   6   49 53                 102
1932416 CO     school 802910 130   CHERRY CREEK 5 80291000200 7116 PONDEROSA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 26 28 28   0 3     0   17   55 47                       102 26 28 28   0 3     0   17   55 47                 102
1933663 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006594 6010 TIMBERLINE PK-8   Regular School No Elementary PK 08 2019   grade_2 14 0 87   0 0     0   1   46 56                       102 14 0 87   0 0     0   1   46 56                 102
1937603 CO     school 803060 1010   COLORADO SPRINGS 11 80306001641 7705 SCOTT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 60 6 22   3 0     1   10   57 45                       102 60 6 22   3 0     1   10   57 45                 102
1938295 CO     school 803870 1110   DISTRICT 49 80387001537 7317 REMINGTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 50 4 32   1 1     0   14   64 38                       102 50 4 32   1 1     0   14   64 38                 102
1941366 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435002030 362 RIM ROCK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 78 1 15   0 0     0   8   40 62                       102 78 1 15   0 0     0   8   40 62                 102
1931421 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006303 8225 STELLAR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 43 2 48   1 4     0   5   44 59                       103 43 2 48   1 4     0   5   44 59                 103
1932075 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 64 3 13   0 17     0   6   53 50                       103 64 3 13   0 17     0   6   53 50                 103
1933453 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537006397 1245 CENTENNIAL ELEMENTARY   Regular School No Elementary PK 05 2019   grade_2 65 0 27   1 5     1   4   57 46                       103 65 0 27   1 5     1   4   57 46                 103
1936446 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006455 6365 SKYVIEW ACADEMY   Regular School Yes Other PK 12 2019   grade_2 62 1 9   0 27     0   4   48 55                       103 62 1 9   0 27     0   4   48 55                 103
1937773 CO     school 801920 1040   ACADEMY 20 80192001644 19 ACADEMY INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 62 4 12   0 15     0   10   48 55                       103 62 4 12   0 15     0   10   48 55                 103
1931406 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690002028 7795 SILVER CREEK ELEMENTARY   Regular School No Elementary KG 05 2019   grade_2 63 0 23   0 16     0   2   51 53                       104 63 0 23   0 16     0   2   51 53                 104
1932243 CO     school 802910 130   CHERRY CREEK 5 80291000191 2428 EASTRIDGE COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 18 39 30   1 3     1   12   61 43                       104 18 39 30   1 3     1   12   61 43                 104
1932976 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001789 6546 OPTIONS SCHOOL   Regular School No Other KG 12 2019   grade_2 80 6 14   0 2     0   2   49 55                       104 80 6 14   0 2     0   2   49 55                 104
1935112 CO     school 803360 880   DENVER COUNTY 1 80336000359 3704 GUST ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 8 3 88   0 3     0   2   50 54                       104 8 3 88   0 3     0   2   50 54                 104
1935357 CO     school 803360 880   DENVER COUNTY 1 80336001635 5644 MAXWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 5 15 80   2 0     1   1   43 61                       104 5 15 80   2 0     1   1   43 61                 104
1935611 CO     school 803360 880   DENVER COUNTY 1 80336000398 7554 SABIN WORLD SCHOOL   Regular School No Elementary PK 05 2019   grade_2 20 5 72   0 4     0   3   59 45                       104 20 5 72   0 4     0   3   59 45                 104
1935968 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006492 135 BEN FRANKLIN ACADEMY   Regular School Yes Elementary PK 08 2019   grade_2 80 1 10   1 9     0   3   58 46                       104 80 1 10   1 9     0   3   58 46                 104
1937930 CO     school 801920 1040   ACADEMY 20 80192000005 6158 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 65 2 20   0 9     1   8   60 45                       105 65 2 20   0 9     1   8   60 45                 105
1939307 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000975 4402 JEFFERSON ACADEMY ELEMENTARY   Regular School Yes Elementary KG 06 2019   grade_2 84 0 11   0 4     0   6   52 53                       105 84 0 11   0 4     0   6   52 53                 105
1935146 CO     school 803360 880   DENVER COUNTY 1 80336006603 3991 HIGH TECH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 79 3 7   0 6     0   11   54 52                       106 79 3 7   0 6     0   11   54 52                 106
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
1932106 CO     school 802910 130   CHERRY CREEK 5 80291002032 243 COYOTE HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 71 4 8   1 9     0   14   57 50                       107 71 4 8   1 9     0   14   57 50                 107
1932188 CO     school 802910 130   CHERRY CREEK 5 80291001273 1572 HIGH PLAINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 70 3 16   0 10     1   7   55 52                       107 70 3 16   0 10     1   7   55 52                 107
1940364 CO     school 802400 1530   BAYFIELD 10 JT-R 80240006747 642 BAYFIELD PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   grade_2 79 0 16   3 1     0   8   64 43                       107 79 0 16   3 1     0   8   64 43                 107
1943440 CO     school 807350 3100   WINDSOR RE-4 80735006460 8459 RANGE VIEW ELEMENTARY   Regular School No Elementary PK 05 2019   grade_2 88 1 14   0 1     0   3   53 54                       107 88 1 14   0 1     0   3   53 54                 107
1932099 CO     school 802910 130   CHERRY CREEK 5 80291001670 242 ANTELOPE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 63 8 24   0 5     1   7   59 49                       108 63 8 24   0 5     1   7   59 49                 108
1938513 CO     school 804260 1180   ROARING FORK RE-1 80426000582 560 BASALT ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2019   grade_2 47 0 61   0 0     0   0   61 47                       108 47 0 61   0 0     0   0   61 47                 108
1932209 CO     school 802910 130   CHERRY CREEK 5 80291000188 1916 COTTONWOOD CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 77 1 9   0 20     0   2   51 58                       109 77 1 9   0 20     0   2   51 58                 109
1936378 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006472 5607 SAGE CANYON ELEMENTARY   Regular School No Elementary PK 06 2019   grade_2 91 1 9   0 1     1   6   65 44                       109 91 1 9   0 1     1   6   65 44                 109
1940785 CO     school 803990 1550   POUDRE R-1 80399000527 9370 EYESTONE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 91 1 16   0 0     0   1   54 55                       109 91 1 16   0 0     0   1   54 55                 109
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
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
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
1942084 CO     school 805520 2535   MANZANOLA 3J 80552000949 5498 MANZANOLA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 4 0 6   0 0     0   1   5 6                       11 4 0 6   0 0     0   1   5 6                 11
1943281 CO     school 805340 3060   LONE STAR 101 80534000894 5254 LONE STAR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 9 0 2   0 0     0   0   7 4                       11 9 0 2   0 0     0   0   7 4                 11
1943619 CO     school 804410 3120   GREELEY 6 80441006719 3173 FRED TJARDES SCHOOL OF INNOVATION   Regular School No Elementary KG 08 2019   grade_2 8 0 3   0 0     0   0   2 9                       11 8 0 3   0 0     0   0   2 9                 11
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
1944295 CO     school 800023 9000   COLORADO SCHOOL FOR THE DEAF AND BLIND 80002306410 1924 COLORADO SCHOOL FOR THE DEAF AND BLIND   Special Education School No Other PK 12 2019   grade_2 4 2 4   0 1     0   0   6 5                       11 4 2 4   0 1     0   0   6 5                 11
1931119 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001733 59 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 81 0 13   0 9     0   7   61 49                       110 81 0 13   0 9     0   7   61 49                 110
1932658 CO     school 805310 140   LITTLETON 6 80531000893 9600 WILDER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 98 1 8   0 1     0   2   54 56                       110 98 1 8   0 1     0   2   54 56                 110
1935521 CO     school 803360 880   DENVER COUNTY 1 80336000391 6754 PARK HILL SCHOOL   Regular School No Elementary PK 05 2019   grade_2 91 6 6   1 2     0   4   49 61                       110 91 6 6   1 2     0   4   49 61                 110
1938915 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000696 660 BEAR CREEK K-8 SCHOOL   Regular School No Elementary KG 08 2019   grade_2 46 2 42   3 10     0   7   57 53                       110 46 2 42   3 10     0   7   57 53                 110
1942284 CO     school 802280 2640   ASPEN 1 80228000045 428 ASPEN ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2019   grade_2 97 0 10   1 1     0   1   48 62                       110 97 0 10   1 1     0   1   48 62                 110
1943350 CO     school 803600 3085   EATON RE-2 80360000474 2448 EATON ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2019   grade_2 76 1 28   0 1     1   3   54 56                       110 76 1 28   0 1     1   3   54 56                 110
1943603 CO     school 804410 3120   GREELEY 6 80441001696 2850 UNIVERSITY SCHOOLS   Regular School Yes Other KG 12 2019   grade_2 69 1 36   0 0     1   3   53 57                       110 69 1 36   0 0     1   3   53 57                 110
1937175 CO     school 806480 990   WIDEFIELD 3 80648001418 8392 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 53 11 34   0 1     2   10   59 52                       111 53 11 34   0 1     2   10   59 52                 111
1932521 CO     school 805310 140   LITTLETON 6 80531000878 752 FRANKLIN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 87 0 17   0 2     0   6   57 55                       112 87 0 17   0 2     0   6   57 55                 112
1933103 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006483 9083 VISTA PEAK P-8 EXPLORATORY   Regular School No Elementary PK 08 2019   grade_2 29 17 52   0 5     0   9   62 50                       112 29 17 52   0 5     0   9   62 50                 112
1934799 CO     school 803360 880   DENVER COUNTY 1 80336006482 2127 DENVER LANGUAGE SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 48 7 26   0 10     1   20   53 59                       112 48 7 26   0 10     1   20   53 59                 112
1938186 CO     school 803870 1110   DISTRICT 49 80387000504 1618 EVANS INTERNATIONAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 46 8 41   0 4     0   13   56 56                       112 46 8 41   0 4     0   13   56 56                 112
1938087 CO     school 805820 1080   LEWIS-PALMER 38 80582001371 3539 BEAR CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 87 1 10   0 0     0   15   57 56                       113 87 1 10   0 0     0   15   57 56                 113
1938954 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006164 950 BRADFORD K8 SOUTH   Regular School No Elementary KG 03 2019   grade_2 106 0 4   0 0     0   3   64 49                       113 106 0 4   0 0     0   3   64 49                 113
1932494 CO     school 802910 130   CHERRY CREEK 5 80291000204 9108 VILLAGE EAST COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 24 43 35   1 3     1   7   66 48                       114 24 43 35   1 3     1   7   66 48                 114
1937276 CO     school 804080 1000   FOUNTAIN 8 80408000565 6338 PATRIOT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 71 9 24   0 2     0   8   59 55                       114 71 9 24   0 2     0   8   59 55                 114
1938251 CO     school 803870 1110   DISTRICT 49 80387001843 5779 MERIDIAN RANCH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 73 5 20   0 2     0   14   57 57                       114 73 5 20   0 2     0   14   57 57                 114
1932833 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006644 2673 EDNA AND JOHN W. MOSLEY P-8   Regular School No Elementary PK 08 2019   grade_2 27 14 58   1 7     0   8   54 61                       115 27 14 58   1 7     0   8   54 61                 115
1937580 CO     school 803060 1010   COLORADO SPRINGS 11 80306000262 7482 ROOSEVELT CHARTER ACADEMY   Regular School Yes Elementary KG 05 2019   grade_2 10 6 87   0 1     0   11   54 61                       115 10 6 87   0 1     0   11   54 61                 115
1935871 CO     school 803360 880   DENVER COUNTY 1 80336006332 9623 WILLIAM (BILL) ROBERTS ECE-8 SCHOOL   Regular School No Elementary PK 08 2019   grade_2 82 6 15   0 4     0   9   59 57                       116 82 6 15   0 4     0   9   59 57                 116
1935365 CO     school 803360 880   DENVER COUNTY 1 80336001276 5685 MCGLONE ACADEMY   Regular School No Elementary PK 08 2019   grade_2 3 19 84   0 0     6   5   65 52                       117 3 19 84   0 0     6   5   65 52                 117
1931776 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006326 9426 WEST RIDGE ELEMENTARY   Regular School No Elementary PK 05 2019   grade_2 66 1 34   1 11     0   5   63 55                       118 66 1 34   1 11     0   5   63 55                 118
1933229 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000038 6652 PAGOSA SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2019   grade_2 65 3 40   7 1     0   2   64 54                       118 65 3 40   7 1     0   2   64 54                 118
1935845 CO     school 803360 880   DENVER COUNTY 1 80336001957 9425 WESTERLY CREEK ELEMENTARY   Regular School No Elementary PK 05 2019   grade_2 90 7 14   0 3     0   4   69 49                       118 90 7 14   0 3     0   4   69 49                 118
1943510 CO     school 804830 3110   JOHNSTOWN-MILLIKEN RE-5J 80483001911 6963 PIONEER RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 102 1 8   1 1     2   3   59 59                       118 102 1 8   1 1     2   3   59 59                 118
1944117 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006503 3439 GLOBAL VILLAGE ACADEMY - NORTHGLENN   Regular School Yes Elementary KG 08 2019   grade_2 47 0 66   1 4     0   0   59 59                       118 47 0 66   1 4     0   0   59 59                 118
1934347 CO     school 802130 580   SOUTH CONEJOS RE-10 80213000033 248 GUADALUPE ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_2 0 0 12   0 0     0   0   5 7                       12 0 0 12   0 0     0   0   5 7                 12
1938160 CO     school 803870 1110   DISTRICT 49 80387006725 101 ALLIES   Alternative School No Elementary 02 05 2019   grade_2 10 0 2   0 0     0   0   8 4                       12 10 0 2   0 0     0   0   8 4                 12
1938842 CO     school 807050 1410   NORTH PARK R-1 80705001209 6358 NORTH PARK SCHOOL   Regular School No Other PK 12 2019   grade_2 10 0 2   0 0     0   0   7 5                       12 10 0 2   0 0     0   0   7 5                 12
1941100 CO     school 807260 1590   PRIMERO REORGANIZED 2 80726001256 7160 PRIMERO ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 3 0 8   0 0     0   1   5 7                       12 3 0 8   0 0     0   1   5 7                 12
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
1941973 CO     school 802610 2395   BRUSH RE-2(J) 80261000156 8832 THOMSON PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   grade_2 61 0 59   0 0     0   0   62 58                       120 61 0 59   0 0     0   0   62 58                 120
1942057 CO     school 805130 2520   EAST OTERO R-1 80513001975 4843 LA JUNTA PRIMARY SCHOOL   Regular School No Elementary KG 02 2019   grade_2 35 1 81   1 1     1   0   52 68                       120 35 1 81   1 1     1   0   52 68                 120
1931763 CO     school 802580 40   SCHOOL DISTRICT 27J 80258006401 8820 TURNBERRY ELEMENTARY   Regular School No Elementary PK 05 2019   grade_2 56 8 51   0 2     1   4   67 55                       122 56 8 51   0 2     1   4   67 55                 122
1943463 CO     school 807350 3100   WINDSOR RE-4 80735001815 9665 WINDSOR CHARTER ACADEMY ELEMENTARY SCHOOL   Regular School Yes Elementary KG 05 2019   grade_2 107 0 13   0 0     0   2   67 55                       122 107 0 13   0 0     0   2   67 55                 122
1937145 CO     school 806480 990   WIDEFIELD 3 80648001121 5602 MARTIN LUTHER KING JR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 56 14 42   2 2     1   8   64 61                       125 56 14 42   2 2     1   8   64 61                 125
1932401 CO     school 802910 130   CHERRY CREEK 5 80291006452 6955 PINE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 84 6 13   0 11     0   14   72 56                       128 84 6 13   0 11     0   14   72 56                 128
1932866 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006318 3471 GLOBAL VILLAGE ACADEMY AURORA   Regular School Yes Elementary KG 08 2019   grade_2 20 21 70   0 5     1   12   58 71                       129 20 21 70   0 5     1   12   58 71                 129

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