enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
1931103 1931103 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   0 Not a school             2019   grade_11 7 0 4   0 0     0   1   2 10                       12 7 0 4   0 0     0   1   2 10                 12
1931104 1931104 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   0 Not a school             2019   grade_12 19 2 19   0 2     1   0   12 31                       43 19 2 19   0 2     1   0   12 31                 43
1931105 1931105 CO     school   20   ADAMS 12 FIVE STAR SCHOOLS   0 Not a school             2019   pk_12_total 26 2 23   0 2     1   1   14 41                       55 26 2 23   0 2     1   1   14 41                 55
1931587 1931587 CO     school   40   SCHOOL DISTRICT 27J   6 COUNTY JAILS WITH DISTRICT RUN EDUCATION             2019   grade_9 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1931588 1931588 CO     school   40   SCHOOL DISTRICT 27J   6 COUNTY JAILS WITH DISTRICT RUN EDUCATION             2019   pk_12_total 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1931823 1931823 CO     school   70   WESTMINSTER PUBLIC SCHOOLS   0 Not a school             2019   grade_12 2 0 0   1 0     0   0   2 1                       3 2 0 0   1 0     0   0   2 1                 3
1931824 1931824 CO     school   70   WESTMINSTER PUBLIC SCHOOLS   0 Not a school             2019   pk_12_total 2 0 0   1 0     0   0   2 1                       3 2 0 0   1 0     0   0   2 1                 3
1932681 1932681 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_1 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1932682 1932682 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_10 1 0 0   0 0     0   1   1 1                       2 1 0 0   0 0     0   1   1 1                 2
1932683 1932683 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_11 1 1 0   0 0     0   0   1 1                       2 1 1 0   0 0     0   0   1 1                 2
1932684 1932684 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_12 0 1 1   0 0     0   0   1 1                       2 0 1 1   0 0     0   0   1 1                 2
1932685 1932685 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_2 0 0 0   0 1     0   0   0 1                       1 0 0 0   0 1     0   0   0 1                 1
1932686 1932686 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_4 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
1932687 1932687 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_5 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1932688 1932688 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_6 0 0 0   0 1     0   0   0 1                       1 0 0 0   0 1     0   0   0 1                 1
1932689 1932689 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_7 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
1932690 1932690 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_8 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
1932691 1932691 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   grade_9 1 1 2   0 0     0   0   2 2                       4 1 1 2   0 0     0   0   2 2                 4
1932692 1932692 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2019   pk_12_total 6 3 7   0 2     0   2   12 8                       20 6 3 7   0 2     0   2   12 8                 20
1938400 1938400 CO     school   1140   CANON CITY RE-1   0 Not a school             2019   grade_11 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
1938401 1938401 CO     school   1140   CANON CITY RE-1   0 Not a school             2019   grade_12 21 0 6   0 0     0   1   14 14                       28 21 0 6   0 0     0   1   14 14                 28
1938402 1938402 CO     school   1140   CANON CITY RE-1   0 Not a school             2019   pk_12_total 24 0 6   0 0     0   1   15 16                       31 24 0 6   0 0     0   1   15 16                 31
1938853 1938853 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2019   grade_11 2 0 0   0 0     0   1   3 0                       3 2 0 0   0 0     0   1   3 0                 3
1938854 1938854 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2019   grade_12 7 0 4   0 1     0   0   6 6                       12 7 0 4   0 1     0   0   6 6                 12
1938855 1938855 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2019   pk_12_total 9 0 4   0 1     0   1   9 6                       15 9 0 4   0 1     0   1   9 6                 15
1940242 1940242 CO     school   1520   DURANGO 9-R   0 Not a school             2019   grade_12 6 0 3   3 0     0   1   7 6                       13 6 0 3   3 0     0   1   7 6                 13
1940243 1940243 CO     school   1520   DURANGO 9-R   0 Not a school             2019   pk_12_total 6 0 3   3 0     0   1   7 6                       13 6 0 3   3 0     0   1   7 6                 13
1940383 1940383 CO     school   1550   POUDRE R-1   0 Not a school             2019   grade_10 1 0 1   0 0     0   1   2 1                       3 1 0 1   0 0     0   1   2 1                 3
1940384 1940384 CO     school   1550   POUDRE R-1   0 Not a school             2019   grade_11 0 0 2   0 0     0   0   2 0                       2 0 0 2   0 0     0   0   2 0                 2
1940385 1940385 CO     school   1550   POUDRE R-1   0 Not a school             2019   grade_7 0 0 3   0 0     0   0   1 2                       3 0 0 3   0 0     0   0   1 2                 3
1940386 1940386 CO     school   1550   POUDRE R-1   0 Not a school             2019   grade_8 0 1 2   0 0     0   1   3 1                       4 0 1 2   0 0     0   1   3 1                 4
1940387 1940387 CO     school   1550   POUDRE R-1   0 Not a school             2019   grade_9 2 0 1   0 0     0   1   2 2                       4 2 0 1   0 0     0   1   2 2                 4
1940388 1940388 CO     school   1550   POUDRE R-1   0 Not a school             2019   pk_12_total 3 1 9   0 0     0   3   10 6                       16 3 1 9   0 0     0   3   10 6                 16
1942377 1942377 CO     school   2690   PUEBLO CITY 60   0 Not a school             2019   grade_12 9 1 17   2 0     0   0   20 9                       29 9 1 17   2 0     0   0   20 9                 29
1942378 1942378 CO     school   2690   PUEBLO CITY 60   0 Not a school             2019   pk_12_total 9 1 17   2 0     0   0   20 9                       29 9 1 17   2 0     0   0   20 9                 29
1944359 1944359 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_10 20 13 34   1 3     0   2   54 19                       73 20 13 34   1 3     0   2   54 19                 73
1944360 1944360 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_11 27 9 30   0 0     0   3   51 18                       69 27 9 30   0 0     0   3   51 18                 69
1944361 1944361 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_12 32 12 31   0 0     0   3   58 20                       78 32 12 31   0 0     0   3   58 20                 78
1944362 1944362 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_5 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1944363 1944363 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_6 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
1944364 1944364 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_7 2 0 3   0 0     0   0   4 1                       5 2 0 3   0 0     0   0   4 1                 5
1944365 1944365 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_8 8 2 11   0 0     0   0   16 5                       21 8 2 11   0 0     0   0   16 5                 21
1944366 1944366 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_9 6 13 19   1 0     0   0   25 14                       39 6 13 19   1 0     0   0   25 14                 39
1944367 1944367 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   pk_12_total 97 49 129   2 3     0   8   211 77                       288 97 49 129   2 3     0   8   211 77                 288
1930955 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

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