Data source: Big Local News · About: Big Local

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

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
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
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
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

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