Data source: Big Local News · About: Big Local

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

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
707871 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_6 8 1 40   1 5     0   2   29 28                       57 8 1 40   1 5     0   2   29 28                 57
707872 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_7 13 0 42   0 2     0   1   26 32                       58 13 0 42   0 2     0   1   26 32                 58
707873 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_8 7 1 43   0 1     0   4   29 27                       56 7 1 43   0 1     0   4   29 27                 56
707874 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_9 7 1 78   0 2     0   3   45 46                       91 7 1 78   0 2     0   3   45 46                 91
707875 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   kindergarten_full_day 8 0 41   0 1     0   3   26 27                       53 8 0 41   0 1     0   3   26 27                 53
707876 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   pk_12_total 108 6 593   1 27     0   22   377 380                       757 108 6 593   1 27     0   22   377 380                 757
707877 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2017   grade_1 7 0 19   0 1     0   0   16 11                       27 7 0 19   0 1     0   0   16 11                 27
707878 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2017   grade_2 5 0 20   0 0     0   1   11 15                       26 5 0 20   0 0     0   1   11 15                 26
707879 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2017   grade_3 4 0 22   1 0     0   0   11 16                       27 4 0 22   1 0     0   0   11 16                 27
707880 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2017   grade_4 3 1 17   0 0     0   1   8 14                       22 3 1 17   0 0     0   1   8 14                 22
707881 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2017   grade_5 3 0 18   0 0     0   0   10 11                       21 3 0 18   0 0     0   0   10 11                 21
707882 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2017   grade_6 6 0 17   1 1     0   0   10 15                       25 6 0 17   1 1     0   0   10 15                 25
707883 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2017   kindergarten_full_day 6 0 29   0 1     1   0   19 18                       37 6 0 29   0 1     1   0   19 18                 37
707884 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2017   pk_12_total 45 2 193   2 8     1   2   121 132                       253 45 2 193   2 8     1   2   121 132                 253
707885 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2017   pre_kindergarten 11 1 51   0 5     0   0   36 32                       68 11 1 51   0 5     0   0   36 32                 68
707886 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   grade_1 4 0 46   0 2     0   0   31 21                       52 4 0 46   0 2     0   0   31 21                 52
707887 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   grade_2 12 1 42   0 1     0   0   28 28                       56 12 1 42   0 1     0   0   28 28                 56
707888 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   grade_3 5 1 54   0 2     0   0   27 35                       62 5 1 54   0 2     0   0   27 35                 62
707889 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   grade_4 8 1 39   0 2     0   3   23 30                       53 8 1 39   0 2     0   3   23 30                 53
707890 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   grade_5 12 2 40   0 3     0   1   28 30                       58 12 2 40   0 3     0   1   28 30                 58
707891 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   grade_6 5 0 46   0 5     0   1   31 26                       57 5 0 46   0 5     0   1   31 26                 57
707892 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   grade_7 8 1 44   0 1     0   1   31 24                       55 8 1 44   0 1     0   1   31 24                 55
707893 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   grade_8 2 0 51   0 1     0   0   24 30                       54 2 0 51   0 1     0   0   24 30                 54
707894 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   kindergarten_full_day 9 0 29   0 2     0   0   17 23                       40 9 0 29   0 2     0   0   17 23                 40
707895 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   pk_12_total 97 7 434   0 20     0   6   286 278                       564 97 7 434   0 20     0   6   286 278                 564
707896 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2017   pre_kindergarten 32 1 43   0 1     0   0   46 31                       77 32 1 43   0 1     0   0   46 31                 77
707897 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_1 16 1 27   1 0     0   0   24 21                       45 16 1 27   1 0     0   0   24 21                 45
707898 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_2 11 1 30   0 0     1   1   24 20                       44 11 1 30   0 0     1   1   24 20                 44
707899 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_3 20 1 32   1 2     1   1   30 28                       58 20 1 32   1 2     1   1   30 28                 58
707900 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_4 12 1 32   2 0     0   3   32 18                       50 12 1 32   2 0     0   3   32 18                 50
707901 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_5 17 1 24   1 1     1   1   27 19                       46 17 1 24   1 1     1   1   27 19                 46
707902 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_6 12 2 35   1 1     0   2   27 26                       53 12 2 35   1 1     0   2   27 26                 53
707903 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2017   kindergarten_full_day 21 1 32   1 1     1   3   33 27                       60 21 1 32   1 1     1   3   33 27                 60
707904 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2017   pk_12_total 120 8 263   7 6     4   11   236 183                       419 120 8 263   7 6     4   11   236 183                 419
707905 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2017   pre_kindergarten 11 0 51   0 1     0   0   39 24                       63 11 0 51   0 1     0   0   39 24                 63
707906 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2017   grade_1 11 0 43   1 1     0   2   38 20                       58 11 0 43   1 1     0   2   38 20                 58
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
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

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