Data source: Big Local News · About: Big Local

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

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
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
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
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
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
1934545 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2019   grade_10 10 4 193   0 4     0   2   115 98                       213 10 4 193   0 4     0   2   115 98                 213
1934546 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2019   grade_11 5 10 190   5 10     0   0   112 108                       220 5 10 190   5 10     0   0   112 108                 220
1934547 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2019   grade_12 3 9 194   2 19     0   2   115 114                       229 3 9 194   2 19     0   2   115 114                 229
1934548 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 7 6 266   3 5     0   3   162 128                       290 7 6 266   3 5     0   3   162 128                 290
1934549 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2019   pk_12_total 25 29 843   10 38     0   7   504 448                       952 25 29 843   10 38     0   7   504 448                 952
1935933 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_1 66 1 9   0 2     0   5   33 50                       83 66 1 9   0 2     0   5   33 50                 83
1935934 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_2 63 2 10   0 2     0   4   36 45                       81 63 2 10   0 2     0   4   36 45                 81
1935935 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_3 66 1 10   0 2     0   4   36 47                       83 66 1 10   0 2     0   4   36 47                 83
1935936 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_4 67 2 9   1 1     0   3   39 44                       83 67 2 9   1 1     0   3   39 44                 83
1935937 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_5 67 2 8   0 2     0   3   36 46                       82 67 2 8   0 2     0   3   36 46                 82
1935938 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_6 61 1 11   2 1     0   3   44 35                       79 61 1 11   2 1     0   3   44 35                 79
1935939 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_7 61 0 5   0 1     0   3   28 42                       70 61 0 5   0 1     0   3   28 42                 70
1935940 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   grade_8 63 1 9   0 6     0   2   38 43                       81 63 1 9   0 6     0   2   38 43                 81
1935941 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   kindergarten_full_day 24 2 1   0 1     0   1   20 9                       29 24 2 1   0 1     0   1   20 9                 29
1935942 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   kindergarten_half_day 38 0 2   0 0     0   1   21 20                       41 38 0 2   0 0     0   1   21 20                 41
1935943 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000492 11 ACADEMY CHARTER SCHOOL   Regular School Yes Elementary PK 08 2019   pk_12_total 576 12 74   3 18     0   29   331 381                       712 576 12 74   3 18     0   29   331 381                 712
1935944 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_1 30 0 16   1 11     0   4   34 28                       62 30 0 16   1 11     0   4   34 28                 62
1935945 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_2 29 1 10   1 17     1   7   34 32                       66 29 1 10   1 17     1   7   34 32                 66
1935946 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_3 35 1 12   0 12     0   7   38 29                       67 35 1 12   0 12     0   7   38 29                 67
1935947 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_4 33 0 17   0 12     0   8   36 34                       70 33 0 17   0 12     0   8   36 34                 70
1935948 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_5 41 0 17   1 15     0   9   41 42                       83 41 0 17   1 15     0   9   41 42                 83
1935949 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   grade_6 52 1 14   0 9     0   8   46 38                       84 52 1 14   0 9     0   8   46 38                 84
1935950 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   kindergarten_full_day 19 0 6   0 16     0   6   28 19                       47 19 0 6   0 16     0   6   28 19                 47
1935951 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   kindergarten_half_day 15 0 8   2 9     0   0   13 21                       34 15 0 8   2 9     0   0   13 21                 34
1935952 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   pk_12_total 275 3 114   5 119     1   49   298 268                       566 275 3 114   5 119     1   49   298 268                 566
1935953 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345000436 12 ACRES GREEN ELEMENTARY SCHOOL   Regular School No Elementary PK 06 2019   pre_kindergarten 21 0 14   0 18     0   0   28 25                       53 21 0 14   0 18     0   0   28 25                 53
1931106 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_1 36 0 37   1 4     0   1   40 39                       79 36 0 37   1 4     0   1   40 39                 79
1931107 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 35 1 35   0 3     0   2   40 36                       76 35 1 35   0 3     0   2   40 36                 76
1931108 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_3 37 0 23   0 4     0   4   40 28                       68 37 0 23   0 4     0   4   40 28                 68
1931109 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 34 1 33   1 8     0   4   47 34                       81 34 1 33   1 8     0   4   47 34                 81
1931110 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_5 37 1 31   1 3     0   4   35 42                       77 37 1 31   1 3     0   4   35 42                 77
1931111 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   kindergarten_full_day 18 0 3   0 1     0   2   10 14                       24 18 0 3   0 1     0   2   10 14                 24
1931112 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   kindergarten_half_day 22 0 21   0 3     0   0   27 19                       46 22 0 21   0 3     0   0   27 19                 46
1931113 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001709 14 GLACIER PEAK ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   pk_12_total 219 3 183   3 26     0   17   239 212                       451 219 3 183   3 26     0   17   239 212                 451
1943940 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_1 86 0 33   0 8     0   10   71 66                       137 86 0 33   0 8     0   10   71 66                 137
1943941 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_10 77 0 48   0 12     0   7   65 79                       144 77 0 48   0 12     0   7   65 79                 144
1943942 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_11 60 1 63   0 11     0   2   75 62                       137 60 1 63   0 11     0   2   75 62                 137
1943943 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_12 74 1 43   1 14     0   2   71 64                       135 74 1 43   1 14     0   2   71 64                 135
1943944 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_2 92 1 37   0 6     0   4   75 65                       140 92 1 37   0 6     0   4   75 65                 140
1943945 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_3 86 1 31   0 8     1   12   66 73                       139 86 1 31   0 8     1   12   66 73                 139
1943946 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_4 84 1 37   0 10     0   13   85 60                       145 84 1 37   0 10     0   13   85 60                 145
1943947 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_5 97 1 35   0 8     0   5   75 71                       146 97 1 35   0 8     0   5   75 71                 146
1943948 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_6 95 0 33   0 11     0   7   67 79                       146 95 0 33   0 11     0   7   67 79                 146
1943949 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_7 87 1 42   1 10     0   3   66 78                       144 87 1 42   1 10     0   3   66 78                 144
1943950 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_8 85 1 42   1 17     0   2   79 69                       148 85 1 42   1 17     0   2   79 69                 148
1943951 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   grade_9 77 0 49   1 12     0   3   68 74                       142 77 0 49   1 12     0   3   68 74                 142
1943952 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   kindergarten_full_day 63 1 19   0 12     0   10   46 59                       105 63 1 19   0 12     0   10   46 59                 105
1943953 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   kindergarten_half_day 17 0 7   0 1     0   0   10 15                       25 17 0 7   0 1     0   0   10 15                 25
1943954 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   pk_12_total 1109 9 529   4 144     1   85   947 934                       1881 1109 9 529   4 144     1   85   947 934                 1881
1943955 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2019   pre_kindergarten 29 0 10   0 4     0   5   28 20                       48 29 0 10   0 4     0   5   28 20                 48
1932074 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 57 9 10   0 14     0   9   48 51                       99 57 9 10   0 14     0   9   48 51                 99
1932075 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 64 3 13   0 17     0   6   53 50                       103 64 3 13   0 17     0   6   53 50                 103
1932076 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_3 56 3 13   1 18     0   10   49 52                       101 56 3 13   1 18     0   10   49 52                 101
1932077 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 73 9 16   2 13     0   2   56 59                       115 73 9 16   2 13     0   2   56 59                 115
1932078 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_5 63 3 10   0 18     0   6   55 45                       100 63 3 10   0 18     0   6   55 45                 100
1932079 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   kindergarten_half_day 63 3 8   0 17     0   6   55 42                       97 63 3 8   0 17     0   6   55 42                 97
1932080 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   pk_12_total 406 35 78   3 105     0   42   350 319                       669 406 35 78   3 105     0   42   350 319                 669
1932081 CO     school 802910 130   CHERRY CREEK 5 80291001710 16 FOX HOLLOW ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   pre_kindergarten 30 5 8   0 8     0   3   34 20                       54 30 5 8   0 8     0   3   34 20                 54
1937764 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_1 48 1 7   0 4     0   5   33 32                       65 48 1 7   0 4     0   5   33 32                 65
1937765 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_2 60 2 7   0 3     0   8   34 46                       80 60 2 7   0 3     0   8   34 46                 80
1937766 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_3 60 2 7   0 0     0   3   31 41                       72 60 2 7   0 0     0   3   31 41                 72
1937767 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_4 46 1 7   0 3     0   12   34 35                       69 46 1 7   0 3     0   12   34 35                 69
1937768 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   grade_5 75 1 5   1 4     1   10   47 50                       97 75 1 5   1 4     1   10   47 50                 97
1937769 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   kindergarten_full_day 27 1 5   0 0     0   4   21 16                       37 27 1 5   0 0     0   4   21 16                 37
1937770 CO     school 801920 1040   ACADEMY 20 80192001643 17 ACADEMY ENDEAVOUR ELEMENTARY SCHOOL   Regular School No Elementary KG 05 2019   kindergarten_half_day 10 0 5   0 0     0   1   8 8                       16 10 0 5   0 0     0   1   8 8                 16

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