Data source: Big Local News · About: Big Local

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

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
1940404 CO     school 803990 1550   POUDRE R-1 80399001727 477 ZACH ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 66 0 3   0 11     0   2   43 39                       82 66 0 3   0 11     0   2   43 39                 82
1931002 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_2 5 0 48   0 2     0   2   32 25                       57 5 0 48   0 2     0   2   32 25                 57
1933157 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000085 9756 YALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 21 10 31   0 3     0   8   42 31                       73 21 10 31   0 3     0   8   42 31                 73
1935911 CO     school 803360 880   DENVER COUNTY 1 80336001637 9739 WYATT ACADEMY   Regular School Yes Elementary KG 05 2019   grade_2 1 5 29   0 0     0   1   23 13                       36 1 5 29   0 0     0   1   23 13                 36
1943894 CO     school 800017 3210   WRAY RD-2 80001701816 9725 WRAY ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2019   grade_2 34 0 22   0 0     0   0   23 33                       56 34 0 22   0 0     0   0   23 33                 56
1936669 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006666 9397 WORLD COMPASS ACADEMY   Regular School Yes Elementary PK 08 2019   grade_2 69 1 8   0 4     0   4   41 45                       86 69 1 8   0 4     0   4   41 45                 86
1940037 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001807 9427 WOODROW WILSON CHARTER ACADEMY   Regular School Yes Elementary PK 08 2019   grade_2 101 2 16   0 4     0   6   63 66                       129 101 2 16   0 4     0   6   63 66                 129
1938019 CO     school 801920 1040   ACADEMY 20 80192000008 9714 WOODMEN-ROBERTS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 60 1 9   0 5     0   5   39 41                       80 60 1 9   0 5     0   5   39 41                 80
1938356 CO     school 803870 1110   DISTRICT 49 80387001686 9706 WOODMEN HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 60 3 15   1 1     0   7   48 39                       87 60 3 15   1 1     0   7   48 39                 87
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
1931504 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001196 9682 WOODGLEN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 43 1 27   0 1     1   5   36 42                       78 43 1 27   0 1     1   5   36 42                 78
1932044 CO     school 803780 120   ENGLEWOOD 1 80378000497 9620 WM E BISHOP ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2019   grade_2 14 3 21   1 1     0   2   19 23                       42 14 3 21   1 1     0   2   19 23                 42
1940101 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001350 9678 WITT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 20 0 7   0 2     0   2   13 18                       31 20 0 7   0 2     0   2   13 18                 31
1941047 CO     school 805400 1560   THOMPSON R2-J 80540000942 9674 WINONA ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 31 3 16   0 0     0   4   28 26                       54 31 3 16   0 0     0   4   28 26                 54
1943530 CO     school 804410 3120   GREELEY 6 80441001989 53 WINOGRAD K-8 ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2019   grade_2 33 0 44   0 0     0   1   39 39                       78 33 0 44   0 0     0   1   39 39                 78
1941677 CO     school 804350 2000   MESA COUNTY VALLEY 51 80435001347 9673 WINGATE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 46 1 7   0 0     0   5   33 26                       59 46 1 7   0 0     0   5   33 26                 59
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
1937665 CO     school 803060 1010   COLORADO SPRINGS 11 80306000275 9660 WILSON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 22 4 24   0 1     0   3   17 37                       54 22 4 24   0 1     0   3   17 37                 54
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
1940084 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000804 9638 WILMORE DAVIS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 22 2 13   0 0     0   2   21 18                       39 22 2 13   0 0     0   2   21 18                 39
1932509 CO     school 802910 130   CHERRY CREEK 5 80291000208 9624 WILLOW CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 61 4 8   0 16     0   9   57 41                       98 61 4 8   0 16     0   9   57 41                 98
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
1942362 CO     school 807320 2680   WILEY RE-13 JT 80732001260 9604 WILEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 11 1 4   0 0     0   0   8 8                       16 11 1 4   0 0     0   0   8 8                 16
1937110 CO     school 804530 980   HARRISON 2 80453001370 9602 WILDFLOWER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 22 7 45   0 1     0   14   42 47                       89 22 7 45   0 1     0   14   42 47                 89
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
1936680 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001639 9592 WILDCAT MOUNTAIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 60 0 3   1 7     0   2   40 33                       73 60 0 3   1 7     0   2   40 33                 73
1942039 CO     school 807290 2515   WIGGINS RE-50(J) 80729001257 9576 WIGGINS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 30 0 10   0 0     0   0   14 26                       40 30 0 10   0 0     0   0   14 26                 40
1937197 CO     school 806480 990   WIDEFIELD 3 80648001128 9562 WIDEFIELD ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 37 3 17   0 2     0   5   33 31                       64 37 3 17   0 2     0   5   33 31                 64
1934177 CO     school 802490 480   BOULDER VALLEY RE 2 80249000139 9544 WHITTIER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 31 0 14   0 5     0   6   29 27                       56 31 0 14   0 5     0   6   29 27                 56
1935860 CO     school 803360 880   DENVER COUNTY 1 80336000426 9548 WHITTIER ECE-8 SCHOOL   Regular School No Elementary PK 08 2019   grade_2 3 6 8   2 0     1   2   14 8                       22 3 6 8   2 0     1   2   14 8                 22
1933149 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000083 9514 WHEELING ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 14 15 39   1 0     1   6   38 38                       76 14 15 39   1 0     1   6   38 38                 76
1931495 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001195 9494 WESTVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 24 4 30   1 0     0   6   39 26                       65 24 4 30   1 0     0   6   39 26                 65
1940070 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001451 9490 WESTRIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 52 0 12   1 3     0   5   33 40                       73 52 0 12   1 3     0   5   33 40                 73
1940239 CO     school 805190 1510   LAKE COUNTY R-1 80519000859 9486 WESTPARK ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   grade_2 27 1 37   0 0     0   3   41 27                       68 27 1 37   0 0     0   3   41 27                 68
1931943 CO     school 807230 70   WESTMINSTER PUBLIC SCHOOLS 80723006675 9236 WESTMINSTER ACADEMY FOR INTERNATIONAL STUDIES   Regular School No Elementary PK 08 2019   grade_2 3 2 26   0 1     0   1   21 12                       33 3 2 26   0 1     0   1   21 12                 33
1940019 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000801 9412 WESTGATE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 41 2 33   0 2     0   2   38 42                       80 41 2 33   0 2     0   2   38 42                 80
1931479 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006417 9431 WESTGATE CHARTER   Regular School Yes Other KG 12 2019   grade_2 24 1 9   0 1     0   3   19 19                       38 24 1 9   0 1     0   3   19 19                 38
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
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
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
1943752 CO     school 804410 3120   GREELEY 6 80441006504 9611 WEST RIDGE ACADEMY   Regular School Yes Elementary KG 08 2019   grade_2 28 4 17   0 2     1   0   25 27                       52 28 4 17   0 2     1   0   25 27                 52
1940028 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000800 9424 WEST JEFFERSON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 36 0 3   0 0     0   1   29 11                       40 36 0 3   0 0     0   1   29 11                 40
1938703 CO     school 805070 1340   WEST GRAND 1-JT 80507000829 9422 WEST GRAND ELEMENTARY AND MIDDLE SCHOOL   Regular School No Elementary KG 08 2019   grade_2 21 0 9   0 0     0   0   18 12                       30 21 0 9   0 0     0   0   18 12                 30
1937649 CO     school 803060 1010   COLORADO SPRINGS 11 80306006416 9445 WEST ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 26 2 5   1 0     0   1   18 17                       35 26 2 5   1 0     0   1   18 17                 35
1940798 CO     school 803990 1550   POUDRE R-1 80399001440 9380 WERNER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 59 0 7   0 5     0   5   46 30                       76 59 0 7   0 5     0   5   46 30                 76
1942019 CO     school 807140 2505   WELDON VALLEY RE-20(J) 80714001217 9352 WELDON VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 19 0 2   0 0     0   0   11 10                       21 19 0 2   0 0     0   0   11 10                 21
1940011 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000799 9342 WELCHESTER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 28 0 9   1 1     0   4   24 19                       43 28 0 9   1 1     0   4   24 19                 43
1931013 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 9 1 25   0 1     0   0   20 16                       36 9 1 25   0 1     0   0   20 16                 36
1937283 CO     school 804080 1000   FOUNTAIN 8 80408006481 9610 WEIKEL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 46 18 21   0 1     2   10   47 51                       98 46 18 21   0 1     2   10   47 51                 98
1937186 CO     school 806480 990   WIDEFIELD 3 80648001127 9334 WEBSTER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 37 6 25   0 1     2   13   48 36                       84 37 6 25   0 1     2   13   48 36                 84
1940003 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000798 9328 WEBER ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 43 0 17   0 0     0   2   40 22                       62 43 0 17   0 0     0   2   40 22                 62
1942080 CO     school 806270 2530   ROCKY FORD R-2 80627001104 9264 WASHINGTON PRIMARY SCHOOL   Regular School No Elementary PK 02 2019   grade_2 3 1 63   0 0     0   1   24 44                       68 3 1 63   0 0     0   1   24 44                 68
1938457 CO     school 802790 1140   CANON CITY RE-1 80279000176 9248 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 44 0 7   0 1     0   3   24 31                       55 44 0 7   0 1     0   3   24 31                 55
1942341 CO     school 805220 2660   LAMAR RE-2 80522000865 9268 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2019   grade_2 22 0 48   0 0     0   0   38 32                       70 22 0 48   0 0     0   0   38 32                 70
1939984 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000796 9232 WARDER ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 35 0 8   1 0     0   5   24 25                       49 35 0 8   1 0     0   5   24 25                 49
1938655 CO     school 806240 1195   GARFIELD RE-2 80624001358 9231 WAMSLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 20 0 35   0 0     0   2   24 33                       57 20 0 35   0 0     0   2   24 33                 57
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
1932501 CO     school 802910 130   CHERRY CREEK 5 80291000206 9200 WALNUT HILLS COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 27 4 4   1 4     0   6   23 23                       46 27 4 4   1 4     0   6   23 23                 46
1939976 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000794 9154 VIVIAN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 11 2 11   0 2     0   1   17 10                       27 11 2 11   0 2     0   1   17 10                 27
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
1934472 CO     school 803330 870   DELTA COUNTY 50(J) 80333002024 2166 VISION CHARTER ACADEMY   Alternative School Yes Other KG 12 2019   grade_2 23 1 3   0 0     0   4   18 13                       31 23 1 3   0 0     0   4   18 13                 31
1933119 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000081 9140 VIRGINIA COURT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 11 12 46   0 0     0   5   34 40                       74 11 12 46   0 0     0   5   34 40                 74
1942776 CO     school 806150 2700   PUEBLO COUNTY 70 80615001084 9130 VINELAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 20 1 13   0 0     0   4   16 22                       38 20 1 13   0 0     0   4   16 22                 38
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
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
1937164 CO     school 806480 990   WIDEFIELD 3 80648001124 8122 VENETUCCI ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 35 14 26   1 1     0   8   51 34                       85 35 14 26   1 1     0   8   51 34                 85
1933095 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000080 9060 VAUGHN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 4 8 36   1 5     1   0   28 27                       55 4 8 36   1 5     1   0   28 27                 55
1933087 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001294 9059 VASSAR ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 14 16 27   2 4     0   8   33 38                       71 14 16 27   2 4     0   8   33 38                 71
1933077 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006322 9056 VANGUARD CLASSICAL SCHOOL - WEST   Regular School Yes Elementary KG 08 2019   grade_2 7 17 25   0 2     0   2   24 29                       53 7 17 25   0 2     0   2   24 29                 53
1933130 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006611 9189 VANGUARD CLASSICAL SCHOOL - EAST   Regular School Yes Other KG 12 2019   grade_2 13 32 21   0 4     0   0   32 38                       70 13 32 21   0 4     0   0   32 38                 70
1939968 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480000793 9058 VANDERHOOF ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 57 2 12   1 1     0   7   43 37                       80 57 2 12   1 1     0   7   43 37                 80
1941031 CO     school 805400 1560   THOMPSON R2-J 80540000940 9055 VAN BUREN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 12 0 5   0 0     0   2   10 9                       19 12 0 5   0 0     0   2   10 9                 19
1939959 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001056 9052 VAN ARSDALE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 47 1 9   0 1     0   1   34 25                       59 47 1 9   0 1     0   1   34 25                 59
1935825 CO     school 803360 880   DENVER COUNTY 1 80336000421 9050 VALVERDE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 3 1 40   0 0     1   0   20 25                       45 3 1 40   0 0     1   0   20 25                 45
1931094 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2019   grade_2 7 1 33   0 0     0   2   17 26                       43 7 1 33   0 0     0   2   17 26                 43
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
1934585 CO     school 803360 880   DENVER COUNTY 1 80336000420 408 VALDEZ ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 17 0 37   0 0     0   0   30 24                       54 17 0 37   0 0     0   0   30 24                 54
1937756 CO     school 805490 1030   MANITOU SPRINGS 14 80549000948 9010 UTE PASS ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 20 0 2   0 0     0   0   12 10                       22 20 0 2   0 0     0   0   12 10                 22
1939951 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001450 9008 UTE MEADOWS ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 50 0 6   0 5     0   3   32 32                       64 50 0 6   0 5     0   3   32 32                 64
1943172 CO     school 806810 3000   SUMMIT RE-1 80681001564 8993 UPPER BLUE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 21 0 13   0 0     0   6   17 23                       40 21 0 13   0 0     0   6   17 23                 40
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
1935529 CO     school 803360 880   DENVER COUNTY 1 80336001576 6957 UNIVERSITY PREP - STEELE ST.   Regular School Yes Elementary PK 05 2019   grade_2 2 9 44   0 0     0   3   32 26                       58 2 9 44   0 0     0   3   32 26                 58
1935803 CO     school 803360 880   DENVER COUNTY 1 80336006517 8945 UNIVERSITY PREP - ARAPAHOE ST.   Regular School Yes Elementary KG 05 2019   grade_2 2 35 16   0 1     0   3   33 24                       57 2 35 16   0 1     0   3   33 24                 57
1935810 CO     school 803360 880   DENVER COUNTY 1 80336000419 8970 UNIVERSITY PARK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 50 3 11   0 4     0   9   38 39                       77 50 3 11   0 4     0   9   38 39                 77
1934169 CO     school 802490 480   BOULDER VALLEY RE 2 80249000135 8978 UNIVERSITY HILL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 17 1 49   0 0     1   2   43 27                       70 17 1 49   0 0     1   2   43 27                 70
1943745 CO     school 804410 3120   GREELEY 6 80441006552 8975 UNION COLONY ELEMENTARY SCHOOL   Regular School Yes Elementary KG 05 2019   grade_2 31 0 36   0 7     0   2   43 33                       76 31 0 36   0 7     0   2   43 33                 76
1943805 CO     school 804020 3140   WELD COUNTY S/D RE-8 80402001366 8930 TWOMBLY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 19 1 55   0 0     1   1   38 39                       77 19 1 55   0 0     1   1   38 39                 77
1939922 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006466 8793 TWO ROADS CHARTER SCHOOL   Regular School Yes Other PK 12 2019   grade_2 42 1 4   0 0     0   2   28 21                       49 42 1 4   0 0     0   2   28 21                 49
1944258 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006635 8821 TWO RIVERS COMMUNITY SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 19 0 11   0 1     0   1   18 14                       32 19 0 11   0 1     0   1   18 14                 32
1933781 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537001572 8927 TWIN PEAKS CHARTER ACADEMY   Regular School Yes Other KG 12 2019   grade_2 31 2 28   0 3     0   1   30 35                       65 31 2 28   0 3     0   1   30 35                 65
1932619 CO     school 805310 140   LITTLETON 6 80531000891 5574 TWAIN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 35 1 2   0 2     0   3   27 16                       43 35 1 2   0 2     0   3   27 16                 43
1937512 CO     school 803060 1010   COLORADO SPRINGS 11 80306000252 5576 TWAIN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 25 9 25   0 1     1   8   31 38                       69 25 9 25   0 1     1   8   31 38                 69
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
1937103 CO     school 804530 980   HARRISON 2 80453001443 8923 TURMAN ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 12 2 16   0 2     0   4   14 22                       36 12 2 16   0 2     0   4   14 22                 36
1941020 CO     school 805400 1560   THOMPSON R2-J 80540000939 8918 TRUSCOTT ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 14 2 16   0 4     0   1   13 24                       37 14 2 16   0 4     0   1   13 24                 37
1935795 CO     school 803360 880   DENVER COUNTY 1 80336006389 8909 TREVISTA AT HORACE MANN   Regular School No Elementary PK 05 2019   grade_2 0 11 34   0 1     0   0   20 26                       46 0 11 34   0 1     0   0   20 26                 46
1935787 CO     school 803360 880   DENVER COUNTY 1 80336000418 8888 TRAYLOR ACADEMY   Regular School No Elementary PK 05 2019   grade_2 5 2 57   1 1     0   1   34 33                       67 5 2 57   1 1     0   1   34 33                 67
1940772 CO     school 803990 1550   POUDRE R-1 80399000606 9251 TRAUT CORE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 49 2 8   1 11     0   4   36 39                       75 49 2 8   1 11     0   4   36 39                 75
1932486 CO     school 802910 130   CHERRY CREEK 5 80291001330 8887 TRAILS WEST ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 38 5 8   1 2     0   2   33 23                       56 38 5 8   1 2     0   2   33 23                 56
1936659 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345001585 8897 TRAILBLAZER ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 38 0 12   0 1     0   1   25 27                       52 38 0 12   0 1     0   1   25 27                 52

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