Data source: Big Local News · About: Big Local

13,413 rows where state = "CO" and year = 2019

View and edit SQL

year

  • 2019 · 13,413
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
1930955 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2019   grade_10 27 5 91   2 1     0   2   47 81                       128 27 5 91   2 1     0   2   47 81                 128
1930956 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2019   grade_11 17 2 88   0 1     0   2   54 56                       110 17 2 88   0 1     0   2   54 56                 110
1930957 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2019   grade_12 17 1 59   1 2     1   4   45 40                       85 17 1 59   1 2     1   4   45 40                 85
1930958 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2019   grade_7 21 4 71   1 1     1   4   57 46                       103 21 4 71   1 1     1   4   57 46                 103
1930959 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2019   grade_8 25 5 86   3 2     0   4   58 67                       125 25 5 86   3 2     0   4   58 67                 125
1930960 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2019   grade_9 24 2 88   4 1     0   3   65 57                       122 24 2 88   4 1     0   3   65 57                 122
1930961 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2019   pk_12_total 131 19 483   11 8     2   19   326 347                       673 131 19 483   11 8     2   19   326 347                 673
1930962 CO     school 805550 10   MAPLETON 1 80555001858 212 MAPLETON EARLY COLLEGE HIGH SCHOOL   Regular School No High 09 12 2019   grade_10 10 0 47   1 3     0   0   28 33                       61 10 0 47   1 3     0   0   28 33                 61
1930963 CO     school 805550 10   MAPLETON 1 80555001858 212 MAPLETON EARLY COLLEGE HIGH SCHOOL   Regular School No High 09 12 2019   grade_11 14 1 42   0 3     1   0   33 28                       61 14 1 42   0 3     1   0   33 28                 61
1930964 CO     school 805550 10   MAPLETON 1 80555001858 212 MAPLETON EARLY COLLEGE HIGH SCHOOL   Regular School No High 09 12 2019   grade_12 10 0 39   1 0     0   6   26 30                       56 10 0 39   1 0     0   6   26 30                 56
1930965 CO     school 805550 10   MAPLETON 1 80555001858 212 MAPLETON EARLY COLLEGE HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 15 0 47   0 1     0   2   25 40                       65 15 0 47   0 1     0   2   25 40                 65
1930966 CO     school 805550 10   MAPLETON 1 80555001858 212 MAPLETON EARLY COLLEGE HIGH SCHOOL   Regular School No High 09 12 2019   pk_12_total 49 1 175   2 7     1   8   112 131                       243 49 1 175   2 7     1   8   112 131                 243
1930967 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No High 09 12 2019   grade_10 1 1 47   0 0     0   0   23 26                       49 1 1 47   0 0     0   0   23 26                 49
1930968 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No High 09 12 2019   grade_11 1 0 50   0 1     0   1   27 26                       53 1 0 50   0 1     0   1   27 26                 53
1930969 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No High 09 12 2019   grade_12 3 0 30   0 0     0   0   19 14                       33 3 0 30   0 0     0   0   19 14                 33
1930970 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No High 09 12 2019   grade_9 5 0 77   0 0     0   0   49 33                       82 5 0 77   0 0     0   0   49 33                 82
1930971 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No High 09 12 2019   pk_12_total 10 1 204   0 1     0   1   118 99                       217 10 1 204   0 1     0   1   118 99                 217
1930972 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2019   grade_10 9 2 107   0 2     0   3   63 60                       123 9 2 107   0 2     0   3   63 60                 123
1930973 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2019   grade_11 7 2 85   1 1     0   5   55 46                       101 7 2 85   1 1     0   5   55 46                 101
1930974 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2019   grade_12 12 2 76   2 1     0   2   63 32                       95 12 2 76   2 1     0   2   63 32                 95
1930975 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 14 0 98   0 0     0   4   60 56                       116 14 0 98   0 0     0   4   60 56                 116
1930976 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2019   pk_12_total 42 6 366   3 4     0   14   241 194                       435 42 6 366   3 4     0   14   241 194                 435
1930977 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary KG 08 2019   grade_1 8 0 31   0 0     0   1   17 23                       40 8 0 31   0 0     0   1   17 23                 40
1930978 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary KG 08 2019   grade_2 7 1 31   0 3     0   0   17 25                       42 7 1 31   0 3     0   0   17 25                 42
1930979 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary KG 08 2019   grade_3 2 1 33   0 2     0   0   17 21                       38 2 1 33   0 2     0   0   17 21                 38
1930980 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary KG 08 2019   grade_4 6 2 44   0 0     0   0   26 26                       52 6 2 44   0 0     0   0   26 26                 52
1930981 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary KG 08 2019   grade_5 6 1 44   0 1     0   1   20 33                       53 6 1 44   0 1     0   1   20 33                 53
1930982 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary KG 08 2019   grade_6 2 0 37   0 1     0   1   19 22                       41 2 0 37   0 1     0   1   19 22                 41
1930983 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary KG 08 2019   grade_7 4 4 49   0 1     0   1   25 34                       59 4 4 49   0 1     0   1   25 34                 59
1930984 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary KG 08 2019   grade_8 2 0 45   0 1     0   0   26 22                       48 2 0 45   0 1     0   0   26 22                 48
1930985 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary KG 08 2019   kindergarten_full_day 5 0 27   0 0     0   2   17 17                       34 5 0 27   0 0     0   2   17 17                 34
1930986 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary KG 08 2019   pk_12_total 42 9 341   0 9     0   6   184 223                       407 42 9 341   0 9     0   6   184 223                 407
1930987 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   grade_1 7 1 33   0 0     0   3   25 19                       44 7 1 33   0 0     0   3   25 19                 44
1930988 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   grade_2 10 1 41   0 3     0   0   26 29                       55 10 1 41   0 3     0   0   26 29                 55
1930989 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   grade_3 4 0 34   0 0     0   1   19 20                       39 4 0 34   0 0     0   1   19 20                 39
1930990 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   grade_4 9 1 36   0 1     0   1   28 20                       48 9 1 36   0 1     0   1   28 20                 48
1930991 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   grade_5 7 2 43   0 2     0   3   25 32                       57 7 2 43   0 2     0   3   25 32                 57
1930992 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   grade_6 6 0 45   0 3     0   0   32 22                       54 6 0 45   0 3     0   0   32 22                 54
1930993 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   grade_7 6 1 45   0 0     0   0   29 23                       52 6 1 45   0 0     0   0   29 23                 52
1930994 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   grade_8 8 0 35   0 0     0   1   23 21                       44 8 0 35   0 0     0   1   23 21                 44
1930995 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   kindergarten_full_day 14 1 40   0 4     0   2   32 29                       61 14 1 40   0 4     0   2   32 29                 61
1930996 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   pk_12_total 86 8 395   1 16     0   11   274 243                       517 86 8 395   1 16     0   11   274 243                 517
1930997 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   pre_kindergarten 15 1 43   1 3     0   0   35 28                       63 15 1 43   1 3     0   0   35 28                 63
1930998 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_1 4 0 46   0 1     0   2   31 22                       53 4 0 46   0 1     0   2   31 22                 53
1930999 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_10 4 1 69   0 2     0   5   38 43                       81 4 1 69   0 2     0   5   38 43                 81
1931000 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_11 4 0 64   0 2     0   4   32 42                       74 4 0 64   0 2     0   4   32 42                 74
1931001 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_12 4 0 54   0 3     0   0   28 33                       61 4 0 54   0 3     0   0   28 33                 61
1931002 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_2 5 0 48   0 2     0   2   32 25                       57 5 0 48   0 2     0   2   32 25                 57
1931003 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_3 4 0 47   0 2     0   2   25 30                       55 4 0 47   0 2     0   2   25 30                 55
1931004 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_4 5 1 50   0 1     0   2   29 30                       59 5 1 50   0 1     0   2   29 30                 59
1931005 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_5 6 1 52   0 2     0   0   32 29                       61 6 1 52   0 2     0   0   32 29                 61
1931006 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_6 4 0 51   0 1     0   1   30 27                       57 4 0 51   0 1     0   1   30 27                 57
1931007 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_7 8 1 49   0 2     0   1   33 28                       61 8 1 49   0 2     0   1   33 28                 61
1931008 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_8 6 0 51   1 5     0   0   30 33                       63 6 0 51   1 5     0   0   30 33                 63
1931009 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_9 6 1 67   0 2     0   0   31 45                       76 6 1 67   0 2     0   0   31 45                 76
1931010 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   kindergarten_full_day 8 1 46   0 3     0   0   28 30                       58 8 1 46   0 3     0   0   28 30                 58
1931011 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   pk_12_total 68 6 694   1 28     0   19   399 417                       816 68 6 694   1 28     0   19   399 417                 816
1931012 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2019   grade_1 10 1 31   1 1     0   0   24 20                       44 10 1 31   1 1     0   0   24 20                 44
1931013 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 9 1 25   0 1     0   0   20 16                       36 9 1 25   0 1     0   0   20 16                 36
1931014 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2019   grade_3 7 0 23   0 0     0   1   17 14                       31 7 0 23   0 0     0   1   17 14                 31
1931015 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2019   grade_4 2 0 20   0 0     0   1   10 13                       23 2 0 20   0 0     0   1   10 13                 23
1931016 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2019   grade_5 5 1 20   1 0     0   0   12 15                       27 5 1 20   1 0     0   0   12 15                 27
1931017 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2019   grade_6 2 2 21   0 0     0   1   7 19                       26 2 2 21   0 0     0   1   7 19                 26
1931018 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2019   kindergarten_full_day 8 1 45   0 3     0   1   22 36                       58 8 1 45   0 3     0   1   22 36                 58
1931019 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2019   pk_12_total 72 7 294   4 6     0   4   168 219                       387 72 7 294   4 6     0   4   168 219                 387
1931020 CO     school 805550 10   MAPLETON 1 80555001997 504 WELBY COMMUNITY SCHOOL   Regular School No Elementary PK 06 2019   pre_kindergarten 29 1 109   2 1     0   0   56 86                       142 29 1 109   2 1     0   0   56 86                 142
1931021 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   grade_1 7 1 42   0 0     0   0   28 22                       50 7 1 42   0 0     0   0   28 22                 50
1931022 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   grade_2 9 1 35   0 1     0   0   23 23                       46 9 1 35   0 1     0   0   23 23                 46
1931023 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   grade_3 4 0 50   0 1     0   1   27 29                       56 4 0 50   0 1     0   1   27 29                 56
1931024 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   grade_4 7 0 43   1 1     0   1   28 25                       53 7 0 43   1 1     0   1   28 25                 53
1931025 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   grade_5 1 2 49   0 2     0   0   25 29                       54 1 2 49   0 2     0   0   25 29                 54
1931026 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   grade_6 7 0 49   1 1     0   3   28 33                       61 7 0 49   1 1     0   3   28 33                 61
1931027 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   grade_7 5 3 44   0 2     0   2   25 31                       56 5 3 44   0 2     0   2   25 31                 56
1931028 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   grade_8 3 1 48   0 4     0   1   28 29                       57 3 1 48   0 4     0   1   28 29                 57
1931029 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   kindergarten_full_day 5 0 31   0 1     0   0   15 22                       37 5 0 31   0 1     0   0   15 22                 37
1931030 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   pk_12_total 69 9 442   2 15     0   9   270 276                       546 69 9 442   2 15     0   9   270 276                 546
1931031 CO     school 805550 10   MAPLETON 1 80555002004 505 ACHIEVE ACADEMY   Regular School No Elementary PK 08 2019   pre_kindergarten 21 1 51   0 2     0   1   43 33                       76 21 1 51   0 2     0   1   43 33                 76
1931032 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_1 12 1 31   0 0     2   3   29 20                       49 12 1 31   0 0     2   3   29 20                 49
1931033 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_2 12 1 32   1 1     0   4   24 27                       51 12 1 32   1 1     0   4   24 27                 51
1931034 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_3 17 0 23   1 0     0   2   28 15                       43 17 0 23   1 0     0   2   28 15                 43
1931035 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_4 11 2 37   0 0     1   0   25 26                       51 11 2 37   0 0     1   0   25 26                 51
1931036 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_5 16 1 38   2 2     1   1   34 27                       61 16 1 38   2 2     1   1   34 27                 61
1931037 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_6 13 1 35   1 1     0   3   36 18                       54 13 1 35   1 1     0   3   36 18                 54
1931038 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2019   kindergarten_full_day 20 0 28   0 0     0   0   28 20                       48 20 0 28   0 0     0   0   28 20                 48
1931039 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2019   pk_12_total 112 6 274   5 4     4   13   235 183                       418 112 6 274   5 4     4   13   235 183                 418
1931040 CO     school 805550 10   MAPLETON 1 80555002007 506 EXPLORE ELEMENTARY   Regular School No Elementary PK 06 2019   pre_kindergarten 11 0 50   0 0     0   0   31 30                       61 11 0 50   0 0     0   0   31 30                 61
1931041 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_1 4 1 32   0 0     0   0   12 25                       37 4 1 32   0 0     0   0   12 25                 37
1931042 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_2 6 0 39   0 1     0   2   27 21                       48 6 0 39   0 1     0   2   27 21                 48
1931043 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_3 6 0 31   1 0     0   0   22 16                       38 6 0 31   1 0     0   0   22 16                 38
1931044 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_4 5 1 39   0 0     0   1   20 26                       46 5 1 39   0 0     0   1   20 26                 46
1931045 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_5 3 0 43   0 2     0   1   24 25                       49 3 0 43   0 2     0   1   24 25                 49
1931046 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2019   grade_6 7 0 30   1 0     0   0   18 20                       38 7 0 30   1 0     0   0   18 20                 38
1931047 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2019   kindergarten_full_day 9 0 37   0 1     0   0   33 14                       47 9 0 37   0 1     0   0   33 14                 47
1931048 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2019   pk_12_total 48 3 305   2 5     0   4   185 182                       367 48 3 305   2 5     0   4   185 182                 367
1931049 CO     school 805550 10   MAPLETON 1 80555001932 507 ADVENTURE ELEMENTARY   Regular School No Elementary PK 06 2019   pre_kindergarten 8 1 54   0 1     0   0   29 35                       64 8 1 54   0 1     0   0   29 35                 64
1931050 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2019   grade_1 9 0 42   0 1     0   1   23 30                       53 9 0 42   0 1     0   1   23 30                 53
1931051 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2019   grade_2 7 0 43   0 1     0   0   24 27                       51 7 0 43   0 1     0   0   24 27                 51
1931052 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2019   grade_3 6 1 41   0 2     0   1   24 27                       51 6 1 41   0 2     0   1   24 27                 51
1931053 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2019   grade_4 3 3 41   0 4     0   3   27 27                       54 3 3 41   0 4     0   3   27 27                 54
1931054 CO     school 805550 10   MAPLETON 1 80555002016 509 CLAYTON PARTNERSHIP SCHOOL   Regular School No Elementary KG 08 2019   grade_5 9 3 43   0 1     1   0   32 25                       57 9 3 43   0 1     1   0   32 25                 57

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