enrollments

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

This data as json, CSV (advanced)

year ✖

  • 2017 · 13,207 ✖
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
707817 707817 CO     school   10   MAPLETON 1   0 Not a school             2017   grade_12 5 0 10   0 0     0   0   10 5                       15 5 0 10   0 0     0   0   10 5                 15
707818 707818 CO     school   10   MAPLETON 1   0 Not a school             2017   pk_12_total 5 0 10   0 0     0   0   10 5                       15 5 0 10   0 0     0   0   10 5                 15
708497 708497 CO     school   40   SCHOOL DISTRICT 27J   4034 ELMWOOD BAPTIST SCHOOL             2017   grade_3 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
708498 708498 CO     school   40   SCHOOL DISTRICT 27J   4034 ELMWOOD BAPTIST SCHOOL             2017   grade_4 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
708499 708499 CO     school   40   SCHOOL DISTRICT 27J   4034 ELMWOOD BAPTIST SCHOOL             2017   pk_12_total 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
708646 708646 CO     school   70   WESTMINSTER PUBLIC SCHOOLS   0 Not a school             2017   grade_12 1 0 3   0 0     0   0   1 3                       4 1 0 3   0 0     0   0   1 3                 4
708647 708647 CO     school   70   WESTMINSTER PUBLIC SCHOOLS   0 Not a school             2017   pk_12_total 1 0 3   0 0     0   0   1 3                       4 1 0 3   0 0     0   0   1 3                 4
709484 709484 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_10 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
709485 709485 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_11 1 0 1   0 0     0   0   1 1                       2 1 0 1   0 0     0   0   1 1                 2
709486 709486 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_12 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
709487 709487 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_2 1 2 0   0 0     0   0   2 1                       3 1 2 0   0 0     0   0   2 1                 3
709488 709488 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_3 0 0 2   0 0     0   0   2 0                       2 0 0 2   0 0     0   0   2 0                 2
709489 709489 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_4 0 1 0   0 0     0   0   0 1                       1 0 1 0   0 0     0   0   0 1                 1
709490 709490 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_5 0 0 0   0 0     0   1   0 1                       1 0 0 0   0 0     0   1   0 1                 1
709491 709491 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_6 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
709492 709492 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_8 4 0 0   0 0     0   0   2 2                       4 4 0 0   0 0     0   0   2 2                 4
709493 709493 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   pk_12_total 7 3 4   0 0     0   2   9 7                       16 7 3 4   0 0     0   2   9 7                 16
711230 711230 CO     school   870   DELTA COUNTY 50(J)   1980 GREAT BEGINNINGS             2017   pk_12_total 12 0 5   0 0     0   1   8 10                       18 12 0 5   0 0     0   1   8 10                 18
711231 711231 CO     school   870   DELTA COUNTY 50(J)   1980 GREAT BEGINNINGS             2017   pre_kindergarten 12 0 5   0 0     0   1   8 10                       18 12 0 5   0 0     0   1   8 10                 18
711295 711295 CO     school   870   DELTA COUNTY 50(J)   4234 LITTLE SPROUTS             2017   pk_12_total 24 0 5   0 0     0   2   16 15                       31 24 0 5   0 0     0   2   16 15                 31
711296 711296 CO     school   870   DELTA COUNTY 50(J)   4234 LITTLE SPROUTS             2017   pre_kindergarten 24 0 5   0 0     0   2   16 15                       31 24 0 5   0 0     0   2   16 15                 31
715516 715516 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2017   grade_11 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
715517 715517 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2017   grade_12 9 0 0   0 0     0   0   4 5                       9 9 0 0   0 0     0   0   4 5                 9
715518 715518 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2017   pk_12_total 10 0 0   0 0     0   0   4 6                       10 10 0 0   0 0     0   0   4 6                 10
716933 716933 CO     school   1520   DURANGO 9-R   0 Not a school             2017   grade_10 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
716934 716934 CO     school   1520   DURANGO 9-R   0 Not a school             2017   grade_11 1 0 0   1 0     0   0   1 1                       2 1 0 0   1 0     0   0   1 1                 2
716935 716935 CO     school   1520   DURANGO 9-R   0 Not a school             2017   grade_12 11 0 7   4 1     0   1   19 5                       24 11 0 7   4 1     0   1   19 5                 24
716936 716936 CO     school   1520   DURANGO 9-R   0 Not a school             2017   pk_12_total 12 0 8   5 1     0   1   20 7                       27 12 0 8   5 1     0   1   20 7                 27
717066 717066 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_10 2 0 2   0 0     0   0   3 1                       4 2 0 2   0 0     0   0   3 1                 4
717067 717067 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_11 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
717068 717068 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_12 1 0 2   0 0     0   0   2 1                       3 1 0 2   0 0     0   0   2 1                 3
717069 717069 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
717070 717070 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_9 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
717071 717071 CO     school   1550   POUDRE R-1   0 Not a school             2017   pk_12_total 6 0 5   0 0     0   0   8 3                       11 6 0 5   0 0     0   0   8 3                 11
719075 719075 CO     school   2690   PUEBLO CITY 60   0 Not a school             2017   grade_12 12 2 26   0 1     0   1   19 23                       42 12 2 26   0 1     0   1   19 23                 42
719076 719076 CO     school   2690   PUEBLO CITY 60   0 Not a school             2017   pk_12_total 12 2 26   0 1     0   1   19 23                       42 12 2 26   0 1     0   1   19 23                 42
719496 719496 CO     school   2730   DEL NORTE C-7   0 Not a school             2017   grade_6 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
719497 719497 CO     school   2730   DEL NORTE C-7   0 Not a school             2017   pk_12_total 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
720095 720095 CO     school   3100   WINDSOR RE-4   0 Not a school             2017   grade_11 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
720096 720096 CO     school   3100   WINDSOR RE-4   0 Not a school             2017   pk_12_total 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
721016 721016 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_10 12 3 22   0 0     0   2   31 8                       39 12 3 22   0 0     0   2   31 8                 39
721017 721017 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_11 18 8 22   0 1     0   3   36 16                       52 18 8 22   0 1     0   3   36 16                 52
721018 721018 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_12 14 9 20   1 0     0   0   31 13                       44 14 9 20   1 0     0   0   31 13                 44
721019 721019 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_6 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
721020 721020 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_7 1 1 3   0 0     0   0   4 1                       5 1 1 3   0 0     0   0   4 1                 5
721021 721021 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_8 6 2 8   0 0     0   0   13 3                       16 6 2 8   0 0     0   0   13 3                 16
721022 721022 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_9 10 6 19   1 0     0   0   29 7                       36 10 6 19   1 0     0   0   29 7                 36
721023 721023 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   pk_12_total 61 29 95   2 1     0   5   145 48                       193 61 29 95   2 1     0   5   145 48                 193
707819 707819 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2017   grade_10 24 2 85   3 1     1   4   71 49                       120 24 2 85   3 1     1   4   71 49                 120
707820 707820 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2017   grade_11 19 7 58   1 0     0   1   32 54                       86 19 7 58   1 0     0   1   32 54                 86
707821 707821 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2017   grade_12 12 0 50   0 0     0   1   44 19                       63 12 0 50   0 0     0   1   44 19                 63
707822 707822 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2017   grade_7 28 1 78   2 1     0   2   58 54                       112 28 1 78   2 1     0   2   58 54                 112
707823 707823 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2017   grade_8 28 2 88   1 2     0   3   50 74                       124 28 2 88   1 2     0   3   50 74                 124
707824 707824 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2017   grade_9 34 1 94   0 1     0   3   69 64                       133 34 1 94   0 1     0   3   69 64                 133
707825 707825 CO     school 805550 10   MAPLETON 1 80555001857 187 MAPLETON EXPEDITIONARY SCHOOL OF THE ARTS   Regular School No High 07 12 2017   pk_12_total 145 13 453   7 5     1   14   324 314                       638 145 13 453   7 5     1   14   324 314                 638
707826 707826 CO     school 805550 10   MAPLETON 1 80555001858 212 MAPLETON EARLY COLLEGE HIGH SCHOOL   Regular School No High 09 12 2017   grade_10 14 0 47   0 0     0   5   32 34                       66 14 0 47   0 0     0   5   32 34                 66
707827 707827 CO     school 805550 10   MAPLETON 1 80555001858 212 MAPLETON EARLY COLLEGE HIGH SCHOOL   Regular School No High 09 12 2017   grade_11 11 2 45   1 0     0   2   32 29                       61 11 2 45   1 0     0   2   32 29                 61
707828 707828 CO     school 805550 10   MAPLETON 1 80555001858 212 MAPLETON EARLY COLLEGE HIGH SCHOOL   Regular School No High 09 12 2017   grade_12 16 0 40   0 1     0   1   26 32                       58 16 0 40   0 1     0   1   26 32                 58
707829 707829 CO     school 805550 10   MAPLETON 1 80555001858 212 MAPLETON EARLY COLLEGE HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 14 2 39   1 3     1   0   31 29                       60 14 2 39   1 3     1   0   31 29                 60
707830 707830 CO     school 805550 10   MAPLETON 1 80555001858 212 MAPLETON EARLY COLLEGE HIGH SCHOOL   Regular School No High 09 12 2017   pk_12_total 55 4 171   2 4     1   8   121 124                       245 55 4 171   2 4     1   8   121 124                 245
707831 707831 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No High 09 12 2017   grade_10 6 0 49   0 0     0   0   27 28                       55 6 0 49   0 0     0   0   27 28                 55
707832 707832 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No High 09 12 2017   grade_11 1 1 33   0 1     0   0   19 17                       36 1 1 33   0 1     0   0   19 17                 36
707833 707833 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No High 09 12 2017   grade_12 2 0 35   0 0     0   1   22 16                       38 2 0 35   0 0     0   1   22 16                 38
707834 707834 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No High 09 12 2017   grade_9 4 0 65   0 1     0   0   37 33                       70 4 0 65   0 1     0   0   37 33                 70
707835 707835 CO     school 805550 10   MAPLETON 1 80555001860 263 GLOBAL LEADERSHIP ACADEMY   Regular School No High 09 12 2017   pk_12_total 13 1 182   0 2     0   1   105 94                       199 13 1 182   0 2     0   1   105 94                 199
707836 707836 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2017   grade_10 17 1 95   3 1     0   3   76 44                       120 17 1 95   3 1     0   3   76 44                 120
707837 707837 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2017   grade_11 22 5 64   2 2     1   3   57 42                       99 22 5 64   2 2     1   3   57 42                 99
707838 707838 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2017   grade_12 4 5 70   1 4     1   2   47 40                       87 4 5 70   1 4     1   2   47 40                 87
707839 707839 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 10 6 106   2 1     0   4   80 49                       129 10 6 106   2 1     0   4   80 49                 129
707840 707840 CO     school 805550 10   MAPLETON 1 80555001872 309 ACADEMY HIGH SCHOOL   Regular School No High 09 12 2017   pk_12_total 53 17 335   8 8     2   12   260 175                       435 53 17 335   8 8     2   12   260 175                 435
707841 707841 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_1 5 1 33   0 1     0   0   17 23                       40 5 1 33   0 1     0   0   17 23                 40
707842 707842 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_2 3 0 45   0 0     0   0   25 23                       48 3 0 45   0 0     0   0   25 23                 48
707843 707843 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_3 4 1 42   0 1     0   1   24 25                       49 4 1 42   0 1     0   1   24 25                 49
707844 707844 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_4 5 1 34   0 0     0   1   13 28                       41 5 1 34   0 0     0   1   13 28                 41
707845 707845 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_5 4 1 43   0 1     0   0   26 23                       49 4 1 43   0 1     0   0   26 23                 49
707846 707846 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_6 5 1 50   0 1     0   0   35 22                       57 5 1 50   0 1     0   0   35 22                 57
707847 707847 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_7 7 0 44   0 0     0   1   23 29                       52 7 0 44   0 0     0   1   23 29                 52
707848 707848 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_8 5 1 42   0 0     0   1   25 24                       49 5 1 42   0 0     0   1   25 24                 49
707849 707849 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   kindergarten_full_day 5 2 30   0 2     0   0   19 20                       39 5 2 30   0 2     0   0   19 20                 39
707850 707850 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   pk_12_total 53 9 412   0 6     0   4   242 242                       484 53 9 412   0 6     0   4   242 242                 484
707851 707851 CO     school 805550 10   MAPLETON 1 80555002021 501 MONTEREY COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   pre_kindergarten 10 1 49   0 0     0   0   35 25                       60 10 1 49   0 0     0   0   35 25                 60
707852 707852 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_1 14 1 37   0 0     0   1   29 24                       53 14 1 37   0 0     0   1   29 24                 53
707853 707853 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_2 9 1 39   0 2     0   0   27 24                       51 9 1 39   0 2     0   0   27 24                 51
707854 707854 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_3 7 1 39   0 3     0   3   21 32                       53 7 1 39   0 3     0   3   21 32                 53
707855 707855 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_4 8 0 44   0 2     0   0   32 22                       54 8 0 44   0 2     0   0   32 22                 54
707856 707856 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_5 4 1 36   1 0     0   0   23 19                       42 4 1 36   1 0     0   0   23 19                 42
707857 707857 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_6 8 1 39   0 0     0   1   17 32                       49 8 1 39   0 0     0   1   17 32                 49
707858 707858 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_7 7 1 33   2 2     0   0   20 25                       45 7 1 33   2 2     0   0   20 25                 45
707859 707859 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_8 9 2 40   2 0     0   0   23 30                       53 9 2 40   2 0     0   0   23 30                 53
707860 707860 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   kindergarten_full_day 7 0 39   1 3     0   0   23 27                       50 7 0 39   1 3     0   0   23 27                 50
707861 707861 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   pk_12_total 88 11 385   6 15     0   5   248 262                       510 88 11 385   6 15     0   5   248 262                 510
707862 707862 CO     school 805550 10   MAPLETON 1 80555002031 502 MEADOW COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   pre_kindergarten 15 3 39   0 3     0   0   33 27                       60 15 3 39   0 3     0   0   33 27                 60
707863 707863 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_1 9 0 44   0 2     0   2   24 33                       57 9 0 44   0 2     0   2   24 33                 57
707864 707864 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_10 12 0 66   0 3     0   0   45 36                       81 12 0 66   0 3     0   0   45 36                 81
707865 707865 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_11 4 0 33   0 0     0   1   14 24                       38 4 0 33   0 0     0   1   14 24                 38
707866 707866 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_12 10 0 37   0 1     0   2   26 24                       50 10 0 37   0 1     0   2   26 24                 50
707867 707867 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_2 6 1 44   0 2     0   1   27 27                       54 6 1 44   0 2     0   1   27 27                 54
707868 707868 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_3 4 1 47   0 2     0   0   29 25                       54 4 1 47   0 2     0   0   29 25                 54
707869 707869 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_4 8 1 43   0 2     0   2   27 29                       56 8 1 43   0 2     0   2   27 29                 56
707870 707870 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_5 12 0 35   0 4     0   1   30 22                       52 12 0 35   0 4     0   1   30 22                 52

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