Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 1,004

grade

  • grade_2 · 1,004
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
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
1932143 CO     school 802910 130   CHERRY CREEK 5 80291001831 1273 CANYON CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 40 10 13   0 7     2   6   39 39                       78 40 10 13   0 7     2   6   39 39                 78
1932150 CO     school 802910 130   CHERRY CREEK 5 80291000763 1510 CHALLENGE SCHOOL   Regular School No Elementary PK 08 2019   grade_2 22 8 3   0 12     1   8   26 28                       54 22 8 3   0 12     1   8   26 28                 54
1932178 CO     school 802910 130   CHERRY CREEK 5 80291001152 1571 CHERRY CREEK CHARTER ACADEMY   Regular School Yes Elementary KG 08 2019   grade_2 39 6 4   0 22     1   6   32 46                       78 39 6 4   0 22     1   6   32 46                 78
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
1932195 CO     school 802910 130   CHERRY CREEK 5 80291000187 1574 CHERRY HILLS VILLAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 79 0 4   0 3     0   4   53 37                       90 79 0 4   0 3     0   4   53 37                 90
1932202 CO     school 802910 130   CHERRY CREEK 5 80291001297 1614 CIMARRON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 29 17 21   0 5     1   14   43 44                       87 29 17 21   0 5     1   14   43 44                 87
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
1932216 CO     school 802910 130   CHERRY CREEK 5 80291001404 1970 CREEKSIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 59 8 13   2 6     0   7   52 43                       95 59 8 13   2 6     0   7   52 43                 95
1932224 CO     school 802910 130   CHERRY CREEK 5 80291001671 2094 DAKOTA VALLEY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 44 7 14   0 7     1   9   46 36                       82 44 7 14   0 7     1   9   46 36                 82
1932231 CO     school 802910 130   CHERRY CREEK 5 80291000190 2292 DRY CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 40 4 11   0 9     0   2   33 33                       66 40 4 11   0 9     0   2   33 33                 66
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
1932268 CO     school 802910 130   CHERRY CREEK 5 80291000192 3648 GREENWOOD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 50 2 6   0 4     0   2   32 32                       64 50 2 6   0 4     0   2   32 32                 64
1932275 CO     school 802910 130   CHERRY CREEK 5 80291000193 3926 HERITAGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 36 0 6   0 13     1   1   23 34                       57 36 0 6   0 13     1   1   23 34                 57
1932282 CO     school 802910 130   CHERRY CREEK 5 80291006182 3988 HIGHLINE COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 10 14 37   1 3     2   2   40 29                       69 10 14 37   1 3     2   2   40 29                 69
1932289 CO     school 802910 130   CHERRY CREEK 5 80291000194 4062 HOLLY HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 28 23 32   2 3     0   7   54 41                       95 28 23 32   2 3     0   7   54 41                 95
1932297 CO     school 802910 130   CHERRY CREEK 5 80291000195 4078 HOMESTEAD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 55 0 13   0 9     0   10   45 42                       87 55 0 13   0 9     0   10   45 42                 87
1932308 CO     school 802910 130   CHERRY CREEK 5 80291006676 4189 HERITAGE HEIGHTS ACADEMY   Regular School Yes Elementary KG 07 2019   grade_2 21 6 7   0 13     0   2   24 25                       49 21 6 7   0 13     0   2   24 25                 49
1932317 CO     school 802910 130   CHERRY CREEK 5 80291000196 4276 INDEPENDENCE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 27 12 24   0 3     0   7   45 28                       73 27 12 24   0 3     0   7   45 28                 73
1932324 CO     school 802910 130   CHERRY CREEK 5 80291001390 4280 INDIAN RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 45 4 12   1 12     1   3   43 35                       78 45 4 12   1 12     1   3   43 35                 78
1932332 CO     school 802910 130   CHERRY CREEK 5 80291006544 4448 BLACK FOREST HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 53 6 13   1 7     0   10   51 39                       90 53 6 13   1 7     0   10   51 39                 90
1932346 CO     school 802910 130   CHERRY CREEK 5 80291001329 5744 MEADOW POINT ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 26 12 34   0 5     0   12   51 38                       89 26 12 34   0 5     0   12   51 38                 89
1932354 CO     school 802910 130   CHERRY CREEK 5 80291000198 5934 MISSION VIEJO ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 40 7 26   1 2     2   5   42 41                       83 40 7 26   1 2     2   5   42 41                 83
1932362 CO     school 802910 130   CHERRY CREEK 5 80291006607 6225 MOUNTAIN VISTA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 52 17 15   0 4     0   7   58 37                       95 52 17 15   0 4     0   7   58 37                 95
1932373 CO     school 802910 130   CHERRY CREEK 5 80291006563 6367 OPTIONS SCHOOL   Alternative School No Other KG 12 2019   grade_2 38 1 11   0 0     0   5   28 27                       55 38 1 11   0 0     0   5   28 27                 55
1932393 CO     school 802910 130   CHERRY CREEK 5 80291006183 6820 PEAKVIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 59 7 16   0 3     0   8   49 44                       93 59 7 16   0 3     0   8   49 44                 93
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
1932408 CO     school 802910 130   CHERRY CREEK 5 80291000199 7102 POLTON COMMUNITY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 24 19 9   0 1     0   15   33 35                       68 24 19 9   0 1     0   15   33 35                 68
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
1932427 CO     school 802910 130   CHERRY CREEK 5 80291001880 7277 RED HAWK RIDGE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 36 11 24   2 13     0   10   53 43                       96 36 11 24   2 13     0   10   53 43                 96
1932435 CO     school 802910 130   CHERRY CREEK 5 80291001514 7476 ROLLING HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 62 5 11   0 9     0   3   46 44                       90 62 5 11   0 9     0   3   46 44                 90
1932445 CO     school 802910 130   CHERRY CREEK 5 80291000202 7559 SAGEBRUSH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 36 8 16   1 3     0   4   23 45                       68 36 8 16   1 3     0   4   23 45                 68
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
1932466 CO     school 802910 130   CHERRY CREEK 5 80291001378 8394 SUNRISE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 32 5 33   0 4     0   8   40 42                       82 32 5 33   0 4     0   8   40 42                 82
1932478 CO     school 802910 130   CHERRY CREEK 5 80291001405 8850 TIMBERLINE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 47 3 17   0 9     0   12   32 56                       88 47 3 17   0 9     0   12   32 56                 88
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
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
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
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
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
1932528 CO     school 805310 140   LITTLETON 6 80531000874 1382 CENTENNIAL ACADEMY OF FINE ARTS EDUCATION   Regular School No Elementary KG 05 2019   grade_2 58 0 25   0 1     0   6   49 41                       90 58 0 25   0 1     0   6   49 41                 90
1932535 CO     school 805310 140   LITTLETON 6 80531000875 2382 EAST ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 8 0 23   0 3     0   1   13 22                       35 8 0 23   0 3     0   1   13 22                 35
1932546 CO     school 805310 140   LITTLETON 6 80531000877 2926 FIELD ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 17 5 20   1 0     0   1   24 20                       44 17 5 20   1 0     0   1   24 20                 44
1932562 CO     school 805310 140   LITTLETON 6 80531000882 3950 HIGHLAND ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 37 1 7   1 0     0   2   30 18                       48 37 1 7   1 0     0   2   30 18                 48
1932583 CO     school 805310 140   LITTLETON 6 80531001515 5229 LITTLETON ACADEMY   Regular School Yes Elementary KG 08 2019   grade_2 43 1 5   0 3     0   1   26 27                       53 43 1 5   0 3     0   1   26 27                 53
1932593 CO     school 805310 140   LITTLETON 6 80531001626 5233 LITTLETON PREP CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_2 51 0 11   0 0     0   4   29 37                       66 51 0 11   0 0     0   4   29 37                 66
1932604 CO     school 805310 140   LITTLETON 6 80531001300 5236 LOIS LENSKI ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 83 1 4   0 2     0   5   47 48                       95 83 1 4   0 2     0   5   47 48                 95
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
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
1932628 CO     school 805310 140   LITTLETON 6 80531000887 6814 PEABODY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 59 0 9   0 2     0   3   47 26                       73 59 0 9   0 2     0   3   47 26                 73
1932636 CO     school 805310 140   LITTLETON 6 80531000888 7518 RUNYON ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 72 1 11   0 0     0   1   40 45                       85 72 1 11   0 0     0   1   40 45                 85
1932643 CO     school 805310 140   LITTLETON 6 80531000889 7606 SANDBURG ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 66 0 4   0 4     0   6   46 34                       80 66 0 4   0 4     0   6   46 34                 80
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
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
1932666 CO     school 803270 170   DEER TRAIL 26J 80327000287 2136 DEER TRAIL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 11 0 5   0 0     0   1   11 6                       17 11 0 5   0 0     0   1   11 6                 17
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
1932694 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006736 126 ACADEMY OF ADVANCED LEARNING   Regular School Yes Elementary KG 08 2019   grade_2 11 24 35   1 2     0   6   37 42                       79 11 24 35   1 2     0   6   37 42                 79
1932706 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006399 213 AXL ACADEMY   Regular School Yes Elementary PK 08 2019   grade_2 9 21 17   1 1     0   2   24 27                       51 9 21 17   1 1     0   2   24 27                 51
1932717 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000052 214 ALTURA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 10 7 60   1 2     0   0   45 35                       80 10 7 60   1 2     0   0   45 35                 80
1932725 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001296 310 ARKANSAS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 18 16 16   0 1     1   5   22 35                       57 18 16 16   0 1     1   5   22 35                 57
1932733 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001759 458 AURORA ACADEMY CHARTER SCHOOL   Regular School Yes Elementary KG 08 2019   grade_2 11 16 17   2 2     0   3   26 25                       51 11 16 17   2 2     0   3   26 25                 51
1932747 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234002009 465 AURORA FRONTIER K-8   Regular School No Elementary PK 08 2019   grade_2 19 4 13   0 18     0   3   29 28                       57 19 4 13   0 18     0   3   29 28                 57
1932758 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000055 914 BOSTON K-8 SCHOOL   Regular School No Elementary PK 08 2019   grade_2 0 4 32   0 4     0   1   19 22                       41 0 4 32   0 4     0   1   19 22                 41
1932774 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001388 1470 CENTURY ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 9 12 9   0 2     0   2   21 13                       34 9 12 9   0 2     0   2   21 13                 34
1932782 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000057 1720 CLYDE MILLER K-8   Regular School No Elementary PK 08 2019   grade_2 2 7 41   0 1     0   1   29 23                       52 2 7 41   0 1     0   1   29 23                 52
1932797 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000058 1948 CRAWFORD ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 5 15 48   1 25     0   0   50 44                       94 5 15 48   1 25     0   0   50 44                 94
1932805 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001295 2095 DALTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 22 6 26   0 2     0   3   32 27                       59 22 6 26   0 2     0   3   32 27                 59
1932813 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000059 2114 DARTMOUTH ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 18 10 18   0 1     0   2   24 25                       49 18 10 18   0 1     0   2   24 25                 49
1932825 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000061 2618 ELKHART ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 6 15 63   0 4     1   0   42 47                       89 6 15 63   0 4     1   0   42 47                 89
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
1932846 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006424 2998 FLETCHER COMMUNITY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 0 2 3   0 0     0   1   5 1                       6 0 2 3   0 0     0   1   5 1                 6
1932853 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000062 3272 FULTON ACADEMY OF EXCELLENCE   Regular School No Elementary PK 05 2019   grade_2 1 9 48   0 5     1   3   35 32                       67 1 9 48   0 5     1   3   35 32                 67
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
1932881 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001323 4270 IOWA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 20 9 37   0 0     1   4   41 30                       71 20 9 37   0 0     1   4   41 30                 71
1932891 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000066 4426 JEWELL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 15 20 26   1 0     0   4   28 38                       66 15 20 26   1 0     0   4   28 38                 66
1932899 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000067 4646 KENTON ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 4 7 58   0 9     0   2   46 34                       80 4 7 58   0 9     0   2   46 34                 80
1932907 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000068 4970 LANSING ELEMENTARY COMMUNITY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 1 14 25   0 3     0   2   27 18                       45 1 14 25   0 3     0   2   27 18                 45
1932915 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000069 4973 LAREDO ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 9 7 45   0 2     0   1   32 32                       64 9 7 45   0 2     0   1   32 32                 64
1932925 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001916 5298 LOTUS SCHOOL FOR EXCELLENCE   Regular School Yes Other KG 12 2019   grade_2 10 40 24   0 0     0   1   36 39                       75 10 40 24   0 0     0   1   36 39                 75
1932936 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000070 5361 LYN KNOLL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 6 4 23   0 0     1   4   16 22                       38 6 4 23   0 0     1   4   16 22                 38
1932946 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000072 6068 MONTVIEW MATH & HEALTH SCIENCES ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 6 9 44   0 2     0   2   30 33                       63 6 9 44   0 2     0   2   30 33                 63
1932958 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001881 6189 MURPHY CREEK K-8 SCHOOL   Regular School No Elementary PK 08 2019   grade_2 28 10 17   1 3     0   10   29 40                       69 28 10 17   1 3     0   10   29 40                 69
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
1932987 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000075 6728 PARIS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 0 7 34   0 2     0   1   21 23                       44 0 7 34   0 2     0   1   21 23                 44
1932995 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000076 6758 PARK LANE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 3 8 35   0 1     2   2   25 26                       51 3 8 35   0 1     2   2   25 26                 51
1933003 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001927 6869 PEORIA ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 2 9 47   0 5     0   1   32 32                       64 2 9 47   0 5     0   1   32 32                 64
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
1933021 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234006677 7233 ROCKY MOUNTAIN PREP - FLETCHER CAMPUS   Regular School Yes Elementary PK 03 2019   grade_2 4 10 55   2 2     0   1   37 37                       74 4 10 55   2 2     0   1   37 37                 74
1933032 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000077 7558 SABLE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 5 15 42   2 5     0   1   31 39                       70 5 15 42   2 5     0   1   31 39                 70
1933040 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001432 7865 SIDE CREEK ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 13 11 33   0 7     0   10   38 36                       74 13 11 33   0 7     0   10   38 36                 74
1933048 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234000078 7932 SIXTH AVENUE ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 4 13 37   0 1     6   5   35 31                       66 4 13 37   0 1     6   5   35 31                 66
1933065 CO     school 802340 180   ADAMS-ARAPAHOE 28J 80234001324 8858 TOLLGATE ELEMENTARY SCHOOL OF EXPEDITIONARY LEARNING   Regular School No Elementary KG 05 2019   grade_2 14 19 46   0 2     2   6   45 44                       89 14 19 46   0 2     2   6   45 44                 89
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
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
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
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
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
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
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
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

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