Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 13,313
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
1943992 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001998 657 ACADEMY OF ARTS AND KNOWLEDGE ELEMENTARY   Regular School Yes Elementary KG 05 2019   grade_2 28 1 1   0 0     1   1   14 18                       32 28 1 1   0 0     1   1   14 18                 32
1943993 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001998 657 ACADEMY OF ARTS AND KNOWLEDGE ELEMENTARY   Regular School Yes Elementary KG 05 2019   grade_3 23 2 5   0 0     1   6   17 20                       37 23 2 5   0 0     1   6   17 20                 37
1943994 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001998 657 ACADEMY OF ARTS AND KNOWLEDGE ELEMENTARY   Regular School Yes Elementary KG 05 2019   grade_4 21 0 8   0 1     0   2   17 15                       32 21 0 8   0 1     0   2   17 15                 32
1943995 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001998 657 ACADEMY OF ARTS AND KNOWLEDGE ELEMENTARY   Regular School Yes Elementary KG 05 2019   grade_5 27 1 2   0 1     0   0   12 19                       31 27 1 2   0 1     0   0   12 19                 31
1943996 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001998 657 ACADEMY OF ARTS AND KNOWLEDGE ELEMENTARY   Regular School Yes Elementary KG 05 2019   kindergarten_full_day 19 2 3   0 2     0   3   14 15                       29 19 2 3   0 2     0   3   14 15                 29
1943997 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001998 657 ACADEMY OF ARTS AND KNOWLEDGE ELEMENTARY   Regular School Yes Elementary KG 05 2019   kindergarten_half_day 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
1943998 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001998 657 ACADEMY OF ARTS AND KNOWLEDGE ELEMENTARY   Regular School Yes Elementary KG 05 2019   pk_12_total 155 9 24   0 5     2   13   94 114                       208 155 9 24   0 5     2   13   94 114                 208
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
1934556 CO     school 803360 880   DENVER COUNTY 1 80336001894 67 ACADEMY OF URBAN LEARNING   Alternative School Yes High 09 12 2019   grade_10 3 5 32   0 0     0   0   25 15                       40 3 5 32   0 0     0   0   25 15                 40
1934557 CO     school 803360 880   DENVER COUNTY 1 80336001894 67 ACADEMY OF URBAN LEARNING   Alternative School Yes High 09 12 2019   grade_11 1 2 24   1 0     0   0   15 13                       28 1 2 24   1 0     0   0   15 13                 28
1934558 CO     school 803360 880   DENVER COUNTY 1 80336001894 67 ACADEMY OF URBAN LEARNING   Alternative School Yes High 09 12 2019   grade_12 2 0 18   0 0     0   0   9 11                       20 2 0 18   0 0     0   0   9 11                 20
1934559 CO     school 803360 880   DENVER COUNTY 1 80336001894 67 ACADEMY OF URBAN LEARNING   Alternative School Yes High 09 12 2019   grade_9 5 3 31   1 0     0   0   30 10                       40 5 3 31   1 0     0   0   30 10                 40
1934560 CO     school 803360 880   DENVER COUNTY 1 80336001894 67 ACADEMY OF URBAN LEARNING   Alternative School Yes High 09 12 2019   pk_12_total 11 10 105   2 0     0   0   79 49                       128 11 10 105   2 0     0   0   79 49                 128
1937789 CO     school 801920 1040   ACADEMY 20 80192006434 110 ACADEMY ONLINE   Regular School No High 09 12 2019   grade_10 32 2 5   0 0     0   1   16 24                       40 32 2 5   0 0     0   1   16 24                 40
1937790 CO     school 801920 1040   ACADEMY 20 80192006434 110 ACADEMY ONLINE   Regular School No High 09 12 2019   grade_11 31 1 4   0 1     0   2   21 18                       39 31 1 4   0 1     0   2   21 18                 39
1937791 CO     school 801920 1040   ACADEMY 20 80192006434 110 ACADEMY ONLINE   Regular School No High 09 12 2019   grade_12 36 2 2   0 0     0   2   26 16                       42 36 2 2   0 0     0   2   26 16                 42
1937792 CO     school 801920 1040   ACADEMY 20 80192006434 110 ACADEMY ONLINE   Regular School No High 09 12 2019   grade_9 34 1 2   0 1     0   2   19 21                       40 34 1 2   0 1     0   2   19 21                 40
1937793 CO     school 801920 1040   ACADEMY 20 80192006434 110 ACADEMY ONLINE   Regular School No High 09 12 2019   pk_12_total 133 6 13   0 2     0   7   82 79                       161 133 6 13   0 2     0   7   82 79                 161
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
1934425 CO     school 803330 870   DELTA COUNTY 50(J) 80333006681 93 ACHIEVE BLENDED LEARNING ACADEMY   Regular School No High 06 12 2019   grade_10 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1934426 CO     school 803330 870   DELTA COUNTY 50(J) 80333006681 93 ACHIEVE BLENDED LEARNING ACADEMY   Regular School No High 06 12 2019   grade_11 8 0 0   0 0     0   0   2 6                       8 8 0 0   0 0     0   0   2 6                 8
1934427 CO     school 803330 870   DELTA COUNTY 50(J) 80333006681 93 ACHIEVE BLENDED LEARNING ACADEMY   Regular School No High 06 12 2019   grade_12 3 0 0   0 0     0   0   0 3                       3 3 0 0   0 0     0   0   0 3                 3
1934428 CO     school 803330 870   DELTA COUNTY 50(J) 80333006681 93 ACHIEVE BLENDED LEARNING ACADEMY   Regular School No High 06 12 2019   pk_12_total 12 0 0   0 0     0   0   3 9                       12 12 0 0   0 0     0   0   3 9                 12
1937290 CO     school 803060 1010   COLORADO SPRINGS 11 80306006428 269 ACHIEVE ONLINE   Alternative School No High 06 12 2019   grade_10 26 3 14   0 1     0   2   23 23                       46 26 3 14   0 1     0   2   23 23                 46
1937291 CO     school 803060 1010   COLORADO SPRINGS 11 80306006428 269 ACHIEVE ONLINE   Alternative School No High 06 12 2019   grade_11 35 2 17   0 0     0   5   27 32                       59 35 2 17   0 0     0   5   27 32                 59
1937292 CO     school 803060 1010   COLORADO SPRINGS 11 80306006428 269 ACHIEVE ONLINE   Alternative School No High 06 12 2019   grade_12 47 4 16   1 0     0   9   35 42                       77 47 4 16   1 0     0   9   35 42                 77
1937293 CO     school 803060 1010   COLORADO SPRINGS 11 80306006428 269 ACHIEVE ONLINE   Alternative School No High 06 12 2019   grade_6 6 0 2   0 0     0   0   7 1                       8 6 0 2   0 0     0   0   7 1                 8
1937294 CO     school 803060 1010   COLORADO SPRINGS 11 80306006428 269 ACHIEVE ONLINE   Alternative School No High 06 12 2019   grade_7 10 1 2   0 0     0   1   11 3                       14 10 1 2   0 0     0   1   11 3                 14
1937295 CO     school 803060 1010   COLORADO SPRINGS 11 80306006428 269 ACHIEVE ONLINE   Alternative School No High 06 12 2019   grade_8 23 0 4   0 0     0   2   17 12                       29 23 0 4   0 0     0   2   17 12                 29
1937296 CO     school 803060 1010   COLORADO SPRINGS 11 80306006428 269 ACHIEVE ONLINE   Alternative School No High 06 12 2019   grade_9 14 0 4   0 1     0   0   10 9                       19 14 0 4   0 1     0   0   10 9                 19
1937297 CO     school 803060 1010   COLORADO SPRINGS 11 80306006428 269 ACHIEVE ONLINE   Alternative School No High 06 12 2019   pk_12_total 161 10 59   1 2     0   19   130 122                       252 161 10 59   1 2     0   19   130 122                 252
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
1931521 CO     school 801950 30   ADAMS COUNTY 14 80195000010 24 ADAMS CITY HIGH SCHOOL   Regular School No High 09 12 2019   grade_10 39 6 425   3 1     0   4   238 240                       478 39 6 425   3 1     0   4   238 240                 478
1931522 CO     school 801950 30   ADAMS COUNTY 14 80195000010 24 ADAMS CITY HIGH SCHOOL   Regular School No High 09 12 2019   grade_11 30 9 360   3 1     0   5   204 204                       408 30 9 360   3 1     0   5   204 204                 408
1931523 CO     school 801950 30   ADAMS COUNTY 14 80195000010 24 ADAMS CITY HIGH SCHOOL   Regular School No High 09 12 2019   grade_12 42 11 293   2 2     0   4   176 178                       354 42 11 293   2 2     0   4   176 178                 354
1931524 CO     school 801950 30   ADAMS COUNTY 14 80195000010 24 ADAMS CITY HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 49 10 452   4 3     1   5   286 238                       524 49 10 452   4 3     1   5   286 238                 524
1931525 CO     school 801950 30   ADAMS COUNTY 14 80195000010 24 ADAMS CITY HIGH SCHOOL   Regular School No High 09 12 2019   pk_12_total 160 36 1530   12 7     1   18   904 860                       1764 160 36 1530   12 7     1   18   904 860                 1764
1931512 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 27 3 227   2 0     1   8   135 133                       268 27 3 227   2 0     1   8   135 133                 268
1931513 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 29 2 234   5 2     0   3   140 135                       275 29 2 234   5 2     0   3   140 135                 275
1931514 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_8 20 6 230   3 0     0   7   143 123                       266 20 6 230   3 0     0   7   143 123                 266
1931515 CO     school 801950 30   ADAMS COUNTY 14 80195000009 20 ADAMS CITY MIDDLE SCHOOL   Regular School No Middle 06 08 2019   pk_12_total 76 11 691   10 2     1   18   418 391                       809 76 11 691   10 2     1   18   418 391                 809
1937446 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 21 13 25   0 1     0   7   33 34                       67 21 13 25   0 1     0   7   33 34                 67
1937447 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 21 18 29   0 0     1   4   38 35                       73 21 18 29   0 0     1   4   38 35                 73
1937448 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_3 17 17 24   0 1     1   7   41 26                       67 17 17 24   0 1     1   7   41 26                 67
1937449 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 22 17 30   2 0     0   1   42 30                       72 22 17 30   2 0     0   1   42 30                 72
1937450 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_5 18 20 34   0 2     0   3   35 42                       77 18 20 34   0 2     0   3   35 42                 77
1937451 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   kindergarten_full_day 28 15 32   1 0     0   3   42 37                       79 28 15 32   1 0     0   3   42 37                 79
1937452 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   pk_12_total 133 105 189   3 5     2   25   247 215                       462 133 105 189   3 5     2   25   247 215                 462
1937453 CO     school 803060 1010   COLORADO SPRINGS 11 80306000239 3890 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   pre_kindergarten 6 5 15   0 1     0   0   16 11                       27 6 5 15   0 1     0   0   16 11                 27
1938856 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_1 30 1 15   1 3     0   4   31 23                       54 30 1 15   1 3     0   4   31 23                 54
1938857 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_2 40 4 16   0 2     0   2   34 30                       64 40 4 16   0 2     0   2   34 30                 64
1938858 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_3 40 1 20   0 2     0   1   33 31                       64 40 1 20   0 2     0   1   33 31                 64
1938859 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_4 27 1 10   0 3     0   4   24 21                       45 27 1 10   0 3     0   4   24 21                 45
1938860 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   grade_5 32 2 12   0 3     0   1   26 24                       50 32 2 12   0 3     0   1   26 24                 50
1938861 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   kindergarten_full_day 23 1 9   0 1     0   0   13 21                       34 23 1 9   0 1     0   0   13 21                 34
1938862 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   kindergarten_half_day 11 0 2   0 1     0   2   9 7                       16 11 0 2   0 1     0   2   9 7                 16
1938863 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   pk_12_total 246 11 93   1 19     0   17   206 181                       387 246 11 93   1 19     0   17   206 181                 387
1938864 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001446 30 ADAMS ELEMENTARY SCHOOL   Regular School No Elementary PK 05 2019   pre_kindergarten 43 1 9   0 4     0   3   36 24                       60 43 1 9   0 4     0   3   36 24                 60
1931126 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006435 70 ADAMS12 FIVE STAR PRESCHOOL   Regular School No Prekindergarten PK PK 2019   pk_12_total 64 4 128   0 14     1   5   117 99                       216 64 4 128   0 14     1   5   117 99                 216
1931127 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006435 70 ADAMS12 FIVE STAR PRESCHOOL   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 64 4 128   0 14     1   5   117 99                       216 64 4 128   0 14     1   5   117 99                 216
1938990 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006587 1451 ADDENBROOKE CLASSICAL ACADEMY   Regular School Yes High 06 12 2019   grade_10 33 0 10   0 1     0   1   22 23                       45 33 0 10   0 1     0   1   22 23                 45
1938991 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006587 1451 ADDENBROOKE CLASSICAL ACADEMY   Regular School Yes High 06 12 2019   grade_11 21 1 4   0 0     0   1   11 16                       27 21 1 4   0 0     0   1   11 16                 27
1938992 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006587 1451 ADDENBROOKE CLASSICAL ACADEMY   Regular School Yes High 06 12 2019   grade_12 16 0 8   0 0     0   1   14 11                       25 16 0 8   0 0     0   1   14 11                 25
1938993 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006587 1451 ADDENBROOKE CLASSICAL ACADEMY   Regular School Yes High 06 12 2019   grade_6 48 1 15   2 2     0   4   42 30                       72 48 1 15   2 2     0   4   42 30                 72
1938994 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006587 1451 ADDENBROOKE CLASSICAL ACADEMY   Regular School Yes High 06 12 2019   grade_7 52 2 22   0 3     0   4   39 44                       83 52 2 22   0 3     0   4   39 44                 83
1938995 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006587 1451 ADDENBROOKE CLASSICAL ACADEMY   Regular School Yes High 06 12 2019   grade_8 54 0 16   0 2     0   4   33 43                       76 54 0 16   0 2     0   4   33 43                 76

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