Data source: Big Local News · About: Big Local

92,494 rows where state = "CO"

View and edit SQL

grade

year

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
707917 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2017   grade_3 8 3 43   0 2     1   1   33 25                       58 8 3 43   0 2     1   1   33 25                 58
707918 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2017   grade_4 9 0 37   0 1     0   1   28 20                       48 9 0 37   0 1     0   1   28 20                 48
707919 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2017   grade_5 8 0 40   0 5     0   1   29 25                       54 8 0 40   0 5     0   1   29 25                 54
707920 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2017   grade_6 11 0 39   0 2     0   1   27 26                       53 11 0 39   0 2     0   1   27 26                 53
707921 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2017   grade_7 12 0 37   0 1     0   0   23 27                       50 12 0 37   0 1     0   0   23 27                 50
707922 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2017   grade_8 10 0 39   0 5     0   3   30 27                       57 10 0 39   0 5     0   3   30 27                 57
707923 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2017   kindergarten_full_day 7 1 30   0 1     0   2   13 28                       41 7 1 30   0 1     0   2   13 28                 41
707924 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2017   pk_12_total 82 7 334   0 22     1   13   230 229                       459 82 7 334   0 22     1   13   230 229                 459
707925 CO     school 805550 10   MAPLETON 1 80555006671 695 BIG PICTURE COLLEGE AND CAREER ACADEMY   Regular School No Other 09 10 2017   grade_10 10 0 24   1 0     0   1   23 13                       36 10 0 24   1 0     0   1   23 13                 36
707926 CO     school 805550 10   MAPLETON 1 80555006671 695 BIG PICTURE COLLEGE AND CAREER ACADEMY   Regular School No Other 09 10 2017   grade_9 8 0 42   0 1     0   5   20 36                       56 8 0 42   0 1     0   5   20 36                 56
707927 CO     school 805550 10   MAPLETON 1 80555006671 695 BIG PICTURE COLLEGE AND CAREER ACADEMY   Regular School No Other 09 10 2017   pk_12_total 18 0 66   1 1     0   6   43 49                       92 18 0 66   1 1     0   6   43 49                 92
707928 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_1 42 4 16   2 0     0   4   42 26                       68 42 4 16   2 0     0   4   42 26                 68
707929 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_10 187 14 79   2 5     1   28   139 177                       316 187 14 79   2 5     1   28   139 177                 316
707930 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_11 188 6 50   2 5     3   23   102 175                       277 188 6 50   2 5     3   23   102 175                 277
707931 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_12 184 10 44   2 0     3   14   97 160                       257 184 10 44   2 0     3   14   97 160                 257
707932 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_2 46 2 20   0 2     0   10   48 32                       80 46 2 20   0 2     0   10   48 32                 80
707933 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_3 64 6 17   0 1     0   6   56 38                       94 64 6 17   0 1     0   6   56 38                 94
707934 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_4 65 4 25   0 2     2   9   55 52                       107 65 4 25   0 2     2   9   55 52                 107
707935 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_5 85 9 21   1 0     0   7   52 71                       123 85 9 21   1 0     0   7   52 71                 123
707936 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_6 101 7 27   0 5     3   13   72 84                       156 101 7 27   0 5     3   13   72 84                 156
707937 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_7 149 13 46   3 2     1   14   127 101                       228 149 13 46   3 2     1   14   127 101                 228
707938 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_8 206 8 64   2 8     1   14   149 154                       303 206 8 64   2 8     1   14   149 154                 303
707939 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   grade_9 223 11 77   4 4     3   22   167 177                       344 223 11 77   4 4     3   22   167 177                 344
707940 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   kindergarten_full_day 49 3 10   0 1     2   8   40 33                       73 49 3 10   0 1     2   8   40 33                 73
707941 CO     school 805550 10   MAPLETON 1 80555006488 1796 COLORADO CONNECTIONS ACADEMY   Regular School No Other KG 12 2017   pk_12_total 1589 97 496   18 35     19   172   1146 1280                       2426 1589 97 496   18 35     19   172   1146 1280                 2426
707942 CO     school 805550 10   MAPLETON 1 80555006672 3590 GLOBAL INTERMEDIATE ACADEMY   Regular School No Elementary 04 08 2017   grade_4 3 1 42   0 1     0   0   22 25                       47 3 1 42   0 1     0   0   22 25                 47
707943 CO     school 805550 10   MAPLETON 1 80555006672 3590 GLOBAL INTERMEDIATE ACADEMY   Regular School No Elementary 04 08 2017   grade_5 0 1 23   0 0     0   0   13 11                       24 0 1 23   0 0     0   0   13 11                 24
707944 CO     school 805550 10   MAPLETON 1 80555006672 3590 GLOBAL INTERMEDIATE ACADEMY   Regular School No Elementary 04 08 2017   grade_6 1 1 28   0 0     0   0   15 15                       30 1 1 28   0 0     0   0   15 15                 30
707945 CO     school 805550 10   MAPLETON 1 80555006672 3590 GLOBAL INTERMEDIATE ACADEMY   Regular School No Elementary 04 08 2017   grade_7 2 0 42   0 0     0   0   22 22                       44 2 0 42   0 0     0   0   22 22                 44
707946 CO     school 805550 10   MAPLETON 1 80555006672 3590 GLOBAL INTERMEDIATE ACADEMY   Regular School No Elementary 04 08 2017   grade_8 5 1 44   0 0     0   0   23 27                       50 5 1 44   0 0     0   0   23 27                 50
707947 CO     school 805550 10   MAPLETON 1 80555006672 3590 GLOBAL INTERMEDIATE ACADEMY   Regular School No Elementary 04 08 2017   pk_12_total 11 4 179   0 1     0   0   95 100                       195 11 4 179   0 1     0   0   95 100                 195
707948 CO     school 805550 10   MAPLETON 1 80555006673 3623 GLOBAL PRIMARY ACADEMY   Regular School No Elementary PK 03 2017   grade_1 3 0 38   0 0     0   0   19 22                       41 3 0 38   0 0     0   0   19 22                 41
707949 CO     school 805550 10   MAPLETON 1 80555006673 3623 GLOBAL PRIMARY ACADEMY   Regular School No Elementary PK 03 2017   grade_2 2 0 49   1 0     0   1   30 23                       53 2 0 49   1 0     0   1   30 23                 53
707950 CO     school 805550 10   MAPLETON 1 80555006673 3623 GLOBAL PRIMARY ACADEMY   Regular School No Elementary PK 03 2017   grade_3 4 0 42   0 0     0   0   24 22                       46 4 0 42   0 0     0   0   24 22                 46
707951 CO     school 805550 10   MAPLETON 1 80555006673 3623 GLOBAL PRIMARY ACADEMY   Regular School No Elementary PK 03 2017   kindergarten_full_day 3 0 33   0 0     0   0   20 16                       36 3 0 33   0 0     0   0   20 16                 36
707952 CO     school 805550 10   MAPLETON 1 80555006673 3623 GLOBAL PRIMARY ACADEMY   Regular School No Elementary PK 03 2017   pk_12_total 18 0 205   1 2     0   1   118 109                       227 18 0 205   1 2     0   1   118 109                 227
707953 CO     school 805550 10   MAPLETON 1 80555006673 3623 GLOBAL PRIMARY ACADEMY   Regular School No Elementary PK 03 2017   pre_kindergarten 6 0 43   0 2     0   0   25 26                       51 6 0 43   0 2     0   0   25 26                 51
707954 CO     school 805550 10   MAPLETON 1 80555006433 6315 NORTH VALLEY SCHOOL FOR YOUNG ADULTS   Regular School No High 09 12 2017   grade_12 12 0 43   2 0     0   1   34 24                       58 12 0 43   2 0     0   1   34 24                 58
707955 CO     school 805550 10   MAPLETON 1 80555006433 6315 NORTH VALLEY SCHOOL FOR YOUNG ADULTS   Regular School No High 09 12 2017   pk_12_total 12 0 43   2 0     0   1   34 24                       58 12 0 43   2 0     0   1   34 24                 58
707956 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2017   grade_1 5 0 33   0 0     0   0   18 20                       38 5 0 33   0 0     0   0   18 20                 38
707957 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2017   grade_2 9 0 45   0 0     0   0   24 30                       54 9 0 45   0 0     0   0   24 30                 54
707958 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2017   grade_3 6 0 36   0 0     0   1   24 19                       43 6 0 36   0 0     0   1   24 19                 43
707959 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2017   grade_4 5 0 37   0 0     0   2   21 23                       44 5 0 37   0 0     0   2   21 23                 44
707960 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2017   grade_5 5 0 42   1 0     0   1   26 23                       49 5 0 42   1 0     0   1   26 23                 49
707961 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2017   grade_6 7 1 51   0 0     0   1   32 28                       60 7 1 51   0 0     0   1   32 28                 60
707962 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2017   grade_7 5 0 51   0 0     0   2   27 31                       58 5 0 51   0 0     0   2   27 31                 58
707963 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2017   grade_8 2 1 52   1 0     0   2   21 37                       58 2 1 52   1 0     0   2   21 37                 58
707964 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2017   kindergarten_full_day 6 1 25   0 1     0   1   15 19                       34 6 1 25   0 1     0   1   15 19                 34
707965 CO     school 805550 10   MAPLETON 1 80555000959 9036 VALLEY VIEW K-8   Regular School No Elementary KG 08 2017   pk_12_total 50 3 372   2 1     0   10   208 230                       438 50 3 372   2 1     0   10   208 230                 438
707966 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 39 1 26   0 2     0   2   40 30                       70 39 1 26   0 2     0   2   40 30                 70
707967 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 35 0 29   1 5     1   4   44 31                       75 35 0 29   1 5     1   4   44 31                 75
707968 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_3 45 4 30   1 2     0   5   45 42                       87 45 4 30   1 2     0   5   45 42                 87
707969 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 58 3 28   0 2     0   5   61 35                       96 58 3 28   0 2     0   5   61 35                 96
707970 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_5 45 0 41   0 0     0   1   42 45                       87 45 0 41   0 0     0   1   42 45                 87
707971 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_full_day 15 0 9   0 0     0   2   14 12                       26 15 0 9   0 0     0   2   14 12                 26
707972 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_half_day 19 1 26   0 1     0   1   25 23                       48 19 1 26   0 1     0   1   25 23                 48
707973 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   pk_12_total 256 9 189   2 12     1   20   271 218                       489 256 9 189   2 12     1   20   271 218                 489
707974 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001726 57 ROCKY TOP MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 297 8 80   2 20     0   14   208 213                       421 297 8 80   2 20     0   14   208 213                 421
707975 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001726 57 ROCKY TOP MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 353 8 94   2 24     0   10   265 226                       491 353 8 94   2 24     0   10   265 226                 491
707976 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001726 57 ROCKY TOP MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 308 4 74   0 29     0   11   219 207                       426 308 4 74   0 29     0   11   219 207                 426
707977 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001726 57 ROCKY TOP MIDDLE SCHOOL   Regular School No Middle 06 08 2017   pk_12_total 958 20 248   4 73     0   35   692 646                       1338 958 20 248   4 73     0   35   692 646                 1338
707978 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001733 59 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 96 5 13   0 3     0   5   62 60                       122 96 5 13   0 3     0   5   62 60                 122
707979 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001733 59 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 94 2 15   1 5     1   4   72 50                       122 94 2 15   1 5     1   4   72 50                 122
707980 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001733 59 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_3 108 2 17   0 7     1   6   71 70                       141 108 2 17   0 7     1   6   71 70                 141
707981 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001733 59 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 97 3 14   1 13     1   5   62 72                       134 97 3 14   1 13     1   5   62 72                 134
707982 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001733 59 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_5 124 1 13   0 4     0   4   86 60                       146 124 1 13   0 4     0   4   86 60                 146
707983 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001733 59 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_full_day 74 0 11   0 5     0   4   47 47                       94 74 0 11   0 5     0   4   47 47                 94
707984 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001733 59 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_half_day 19 0 4   0 0     0   0   14 9                       23 19 0 4   0 0     0   0   14 9                 23
707985 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001733 59 MERIDIAN ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   pk_12_total 612 13 87   2 37     3   28   414 368                       782 612 13 87   2 37     3   28   414 368                 782
707986 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006435 70 ADAMS12 FIVE STAR PRESCHOOL   Regular School No Elementary PK PK 2017   pk_12_total 85 11 198   2 14     1   8   184 135                       319 85 11 198   2 14     1   8   184 135                 319
707987 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006435 70 ADAMS12 FIVE STAR PRESCHOOL   Regular School No Elementary PK PK 2017   pre_kindergarten 85 11 198   2 14     1   8   184 135                       319 85 11 198   2 14     1   8   184 135                 319
707988 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No Other 06 12 2017   grade_10 18 0 27   0 0     0   1   30 16                       46 18 0 27   0 0     0   1   30 16                 46
707989 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No Other 06 12 2017   grade_11 60 2 80   2 0     0   0   74 70                       144 60 2 80   2 0     0   0   74 70                 144
707990 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No Other 06 12 2017   grade_12 54 3 45   1 2     0   3   59 49                       108 54 3 45   1 2     0   3   59 49                 108
707991 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No Other 06 12 2017   grade_7 10 0 10   0 0     0   1   17 4                       21 10 0 10   0 0     0   1   17 4                 21
707992 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No Other 06 12 2017   grade_8 7 1 21   0 0     0   0   23 6                       29 7 1 21   0 0     0   0   23 6                 29
707993 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No Other 06 12 2017   grade_9 4 0 5   0 0     0   0   8 1                       9 4 0 5   0 0     0   0   8 1                 9
707994 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No Other 06 12 2017   pk_12_total 153 6 188   3 2     0   5   211 146                       357 153 6 188   3 2     0   5   211 146                 357
707995 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 67 2 30   1 1     1   5   49 58                       107 67 2 30   1 1     1   5   49 58                 107
707996 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 48 2 43   0 4     0   5   53 49                       102 48 2 43   0 4     0   5   53 49                 102
707997 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_3 66 2 32   0 4     0   2   58 48                       106 66 2 32   0 4     0   2   58 48                 106
707998 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 65 2 28   0 5     0   10   54 56                       110 65 2 28   0 5     0   10   54 56                 110
707999 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_5 72 1 31   0 4     0   3   63 48                       111 72 1 31   0 4     0   3   63 48                 111
708000 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_full_day 20 0 3   0 1     0   0   16 8                       24 20 0 3   0 1     0   0   16 8                 24
708001 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_half_day 28 0 31   0 3     0   2   37 27                       64 28 0 31   0 3     0   2   37 27                 64
708002 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001619 301 ARAPAHOE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   pk_12_total 366 9 198   1 22     1   27   330 294                       624 366 9 198   1 22     1   27   330 294                 624
708003 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690000382 1020 BRIGHT HORIZONS PRE-KINDERGARTEN SCHOOL   Regular School No Elementary PK PK 2017   pk_12_total 32 1 3   0 0     0   0   16 20                       36 32 1 3   0 0     0   0   16 20                 36
708004 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690000382 1020 BRIGHT HORIZONS PRE-KINDERGARTEN SCHOOL   Regular School No Elementary PK PK 2017   pre_kindergarten 32 1 3   0 0     0   0   16 20                       36 32 1 3   0 0     0   0   16 20                 36
708005 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001173 1388 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 19 0 28   0 3     0   1   25 26                       51 19 0 28   0 3     0   1   25 26                 51
708006 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001173 1388 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 34 0 29   0 1     0   4   28 40                       68 34 0 29   0 1     0   4   28 40                 68
708007 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001173 1388 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 36 1 48   2 1     0   1   45 44                       89 36 1 48   2 1     0   1   45 44                 89
708008 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001173 1388 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 30 2 36   1 4     0   1   39 35                       74 30 2 36   1 4     0   1   39 35                 74
708009 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001173 1388 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 32 0 40   0 3     0   0   39 36                       75 32 0 40   0 3     0   0   39 36                 75
708010 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001173 1388 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 17 0 29   0 2     0   1   16 33                       49 17 0 29   0 2     0   1   16 33                 49
708011 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001173 1388 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_half_day 10 0 7   0 2     0   1   10 10                       20 10 0 7   0 2     0   1   10 10                 20
708012 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001173 1388 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 215 3 259   4 26     0   13   258 262                       520 215 3 259   4 26     0   13   258 262                 520
708013 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001173 1388 CENTENNIAL ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 37 0 42   1 10     0   4   56 38                       94 37 0 42   1 10     0   4   56 38                 94
708014 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001620 1480 CENTURY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 212 4 87   5 11     3   12   172 162                       334 212 4 87   5 11     3   12   172 162                 334
708015 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001620 1480 CENTURY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 208 6 92   4 15     0   8   156 177                       333 208 6 92   4 15     0   8   156 177                 333
708016 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001620 1480 CENTURY MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 216 14 102   4 15     0   3   175 179                       354 216 14 102   4 15     0   3   175 179                 354

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