Data source: Big Local News · About: Big Local

13,207 rows where state = "CO" and year = 2017 sorted by ccd_school_lvl

View and edit SQL

year

  • 2017 · 13,107
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
707907 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_2 5 1 41   0 0     0   1   26 22                       48 5 1 41   0 0     0   1   26 22                 48
707908 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_3 6 0 33   0 0     0   1   21 19                       40 6 0 33   0 0     0   1   21 19                 40
707909 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_4 4 1 37   1 0     0   3   25 21                       46 4 1 37   1 0     0   3   25 21                 46
707910 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_5 4 1 37   0 0     0   0   24 18                       42 4 1 37   0 0     0   0   24 18                 42
707911 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_6 5 1 46   2 0     0   2   34 22                       56 5 1 46   2 0     0   2   34 22                 56
707912 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2017   kindergarten_full_day 8 0 46   0 0     0   1   25 30                       55 8 0 46   0 0     0   1   25 30                 55
707913 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2017   pk_12_total 60 6 327   4 1     0   10   222 186                       408 60 6 327   4 1     0   10   222 186                 408
707914 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2017   pre_kindergarten 17 2 44   0 0     0   0   29 34                       63 17 2 44   0 0     0   0   29 34                 63
707915 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2017   grade_1 5 0 39   0 2     0   2   22 26                       48 5 0 39   0 2     0   2   22 26                 48
707916 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2017   grade_2 12 3 30   0 3     0   2   25 25                       50 12 3 30   0 3     0   2   25 25                 50
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
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
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
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
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
708031 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001174 1878 CORONADO HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_1 8 1 72   0 0     0   0   40 41                       81 8 1 72   0 0     0   0   40 41                 81
708032 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001174 1878 CORONADO HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_2 9 0 88   0 0     0   1   57 41                       98 9 0 88   0 0     0   1   57 41                 98
708033 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001174 1878 CORONADO HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_3 16 1 63   0 0     0   1   46 35                       81 16 1 63   0 0     0   1   46 35                 81
708034 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001174 1878 CORONADO HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_4 13 3 88   0 0     0   2   58 48                       106 13 3 88   0 0     0   2   58 48                 106
708035 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001174 1878 CORONADO HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   grade_5 10 0 68   0 0     0   0   41 37                       78 10 0 68   0 0     0   0   41 37                 78
708036 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001174 1878 CORONADO HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   kindergarten_full_day 11 0 74   0 1     0   1   45 42                       87 11 0 74   0 1     0   1   45 42                 87
708037 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001174 1878 CORONADO HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pk_12_total 79 5 500   0 1     0   5   320 270                       590 79 5 500   0 1     0   5   320 270                 590
708038 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001174 1878 CORONADO HILLS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2017   pre_kindergarten 12 0 47   0 0     0   0   33 26                       59 12 0 47   0 0     0   0   33 26                 59
708039 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001305 1914 COTTON CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 65 2 14   2 3     0   4   42 48                       90 65 2 14   2 3     0   4   42 48                 90
708040 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001305 1914 COTTON CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 67 1 21   1 7     0   7   57 47                       104 67 1 21   1 7     0   7   57 47                 104
708041 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001305 1914 COTTON CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_3 63 2 24   0 6     1   4   55 45                       100 63 2 24   0 6     1   4   55 45                 100
708042 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001305 1914 COTTON CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 73 2 19   2 7     1   3   55 52                       107 73 2 19   2 7     1   3   55 52                 107
708043 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001305 1914 COTTON CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_5 73 3 18   1 8     0   2   41 64                       105 73 3 18   1 8     0   2   41 64                 105
708044 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001305 1914 COTTON CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_full_day 36 0 11   0 1     0   5   31 22                       53 36 0 11   0 1     0   5   31 22                 53
708045 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001305 1914 COTTON CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_half_day 25 2 11   0 5     0   2   24 21                       45 25 2 11   0 5     0   2   24 21                 45
708046 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001305 1914 COTTON CREEK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   pk_12_total 402 12 118   6 37     2   27   305 299                       604 402 12 118   6 37     2   27   305 299                 604
708047 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001668 1937 COYOTE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_1 81 1 5   0 4     0   1   43 49                       92 81 1 5   0 4     0   1   43 49                 92
708048 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001668 1937 COYOTE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_2 77 0 3   0 7     0   6   52 41                       93 77 0 3   0 7     0   6   52 41                 93
708049 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001668 1937 COYOTE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_3 90 0 10   0 7     0   2   54 55                       109 90 0 10   0 7     0   2   54 55                 109
708050 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001668 1937 COYOTE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_4 77 2 7   0 6     0   6   51 47                       98 77 2 7   0 6     0   6   51 47                 98
708051 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001668 1937 COYOTE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   grade_5 81 1 7   0 5     0   7   57 44                       101 81 1 7   0 5     0   7   57 44                 101
708052 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001668 1937 COYOTE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_full_day 42 0 4   0 3     0   1   27 23                       50 42 0 4   0 3     0   1   27 23                 50
708053 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001668 1937 COYOTE RIDGE ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2017   kindergarten_half_day 19 0 1   0 4     0   1   12 13                       25 19 0 1   0 4     0   1   12 13                 25

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