Data source: Big Local News · About: Big Local

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

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
1931091 CO     school 805550 10   MAPLETON 1 80555006433 6315 NORTH VALLEY SCHOOL FOR YOUNG ADULTS   Alternative School No High 09 12 2019   grade_12 20 0 57   1 1     0   2   47 34                       81 20 0 57   1 1     0   2   47 34                 81
1931092 CO     school 805550 10   MAPLETON 1 80555006433 6315 NORTH VALLEY SCHOOL FOR YOUNG ADULTS   Alternative School No High 09 12 2019   pk_12_total 20 0 57   1 1     0   2   47 34                       81 20 0 57   1 1     0   2   47 34                 81
1931128 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No High 06 12 2019   grade_10 14 2 33   0 0     0   1   31 19                       50 14 2 33   0 0     0   1   31 19                 50
1931129 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No High 06 12 2019   grade_11 36 1 95   2 1     0   2   81 56                       137 36 1 95   2 1     0   2   81 56                 137
1931130 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No High 06 12 2019   grade_12 45 2 61   1 4     0   3   67 49                       116 45 2 61   1 4     0   3   67 49                 116
1931131 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No High 06 12 2019   grade_7 3 0 8   0 0     1   0   11 1                       12 3 0 8   0 0     1   0   11 1                 12
1931132 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No High 06 12 2019   grade_8 9 2 20   0 0     0   0   17 14                       31 9 2 20   0 0     0   0   17 14                 31
1931133 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No High 06 12 2019   grade_9 2 0 1   0 0     0   0   3 0                       3 2 0 1   0 0     0   0   3 0                 3
1931134 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No High 06 12 2019   pk_12_total 109 7 218   3 5     1   6   210 139                       349 109 7 218   3 5     1   6   210 139                 349
1931289 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative School Yes High 09 12 2019   grade_10 2 0 40   0 0     0   0   20 22                       42 2 0 40   0 0     0   0   20 22                 42
1931290 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative School Yes High 09 12 2019   grade_11 6 1 73   0 0     0   0   36 44                       80 6 1 73   0 0     0   0   36 44                 80
1931291 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative School Yes High 09 12 2019   grade_12 14 2 151   0 2     0   1   75 95                       170 14 2 151   0 2     0   1   75 95                 170
1931292 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative School Yes High 09 12 2019   grade_9 2 0 15   0 0     0   0   10 7                       17 2 0 15   0 0     0   0   10 7                 17
1931293 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative School Yes High 09 12 2019   pk_12_total 24 3 279   0 2     0   1   141 168                       309 24 3 279   0 2     0   1   141 168                 309
1931389 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2019   grade_10 3 0 1   0 0     0   0   2 2                       4 3 0 1   0 0     0   0   2 2                 4
1931390 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2019   grade_11 8 1 6   0 0     0   1   10 6                       16 8 1 6   0 0     0   1   10 6                 16
1931391 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2019   grade_12 100 13 177   4 5     0   3   190 112                       302 100 13 177   4 5     0   3   190 112                 302
1931392 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2019   grade_6 1 1 1   0 0     0   0   3 0                       3 1 1 1   0 0     0   0   3 0                 3
1931393 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2019   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1931394 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2019   grade_8 2 2 1   0 0     0   0   5 0                       5 2 2 1   0 0     0   0   5 0                 5
1931395 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2019   grade_9 2 0 3   0 0     0   0   3 2                       5 2 0 3   0 0     0   0   3 2                 5
1931396 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2019   pk_12_total 117 17 189   4 5     0   4   214 122                       336 117 17 189   4 5     0   4   214 122                 336
1931516 CO     school 801950 30   ADAMS COUNTY 14 80195001307 22 LESTER R ARNOLD HIGH SCHOOL   Alternative School No High 09 12 2019   grade_10 8 2 42   0 0     0   2   35 19                       54 8 2 42   0 0     0   2   35 19                 54
1931517 CO     school 801950 30   ADAMS COUNTY 14 80195001307 22 LESTER R ARNOLD HIGH SCHOOL   Alternative School No High 09 12 2019   grade_11 9 2 58   0 0     0   0   34 35                       69 9 2 58   0 0     0   0   34 35                 69
1931518 CO     school 801950 30   ADAMS COUNTY 14 80195001307 22 LESTER R ARNOLD HIGH SCHOOL   Alternative School No High 09 12 2019   grade_12 10 4 130   1 0     0   2   66 81                       147 10 4 130   1 0     0   2   66 81                 147
1931519 CO     school 801950 30   ADAMS COUNTY 14 80195001307 22 LESTER R ARNOLD HIGH SCHOOL   Alternative School No High 09 12 2019   grade_9 1 0 1   0 0     0   0   2 0                       2 1 0 1   0 0     0   0   2 0                 2
1931520 CO     school 801950 30   ADAMS COUNTY 14 80195001307 22 LESTER R ARNOLD HIGH SCHOOL   Alternative School No High 09 12 2019   pk_12_total 28 8 231   1 0     0   4   137 135                       272 28 8 231   1 0     0   4   137 135                 272
1931608 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000729 1021 BRIGHTON HERITAGE ACADEMY   Alternative School No High 06 12 2019   grade_10 10 1 12   1 0     0   0   13 11                       24 10 1 12   1 0     0   0   13 11                 24
1931609 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000729 1021 BRIGHTON HERITAGE ACADEMY   Alternative School No High 06 12 2019   grade_11 18 0 31   0 0     0   2   34 17                       51 18 0 31   0 0     0   2   34 17                 51
1931610 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000729 1021 BRIGHTON HERITAGE ACADEMY   Alternative School No High 06 12 2019   grade_12 52 4 64   1 0     0   2   75 48                       123 52 4 64   1 0     0   2   75 48                 123
1931611 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000729 1021 BRIGHTON HERITAGE ACADEMY   Alternative School No High 06 12 2019   grade_8 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1931612 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000729 1021 BRIGHTON HERITAGE ACADEMY   Alternative School No High 06 12 2019   grade_9 1 0 9   0 0     0   0   9 1                       10 1 0 9   0 0     0   0   9 1                 10
1931613 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000729 1021 BRIGHTON HERITAGE ACADEMY   Alternative School No High 06 12 2019   pk_12_total 82 5 116   2 0     0   4   132 77                       209 82 5 116   2 0     0   4   132 77                 209
1931802 CO     school 806750 60   STRASBURG 31J 80675001669 7133 PRAIRIE CREEK HIGH SCHOOL   Alternative School No High 09 12 2019   grade_11 5 0 1   0 0     0   0   5 1                       6 5 0 1   0 0     0   0   5 1                 6
1931803 CO     school 806750 60   STRASBURG 31J 80675001669 7133 PRAIRIE CREEK HIGH SCHOOL   Alternative School No High 09 12 2019   grade_12 4 0 1   0 0     0   0   4 1                       5 4 0 1   0 0     0   0   4 1                 5
1931804 CO     school 806750 60   STRASBURG 31J 80675001669 7133 PRAIRIE CREEK HIGH SCHOOL   Alternative School No High 09 12 2019   grade_9 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1931805 CO     school 806750 60   STRASBURG 31J 80675001669 7133 PRAIRIE CREEK HIGH SCHOOL   Alternative School No High 09 12 2019   pk_12_total 10 0 2   0 0     0   0   10 2                       12 10 0 2   0 0     0   0   10 2                 12
1931976 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2019   grade_10 0 0 8   0 0     0   0   6 2                       8 0 0 8   0 0     0   0   6 2                 8
1931977 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2019   grade_11 0 0 5   0 0     0   0   4 1                       5 0 0 5   0 0     0   0   4 1                 5
1931978 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2019   grade_12 1 0 5   0 0     0   2   5 3                       8 1 0 5   0 0     0   2   5 3                 8
1931979 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2019   grade_6 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1931980 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2019   grade_7 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
1931981 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2019   grade_8 2 0 8   0 0     0   0   7 3                       10 2 0 8   0 0     0   0   7 3                 10
1931982 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2019   grade_9 2 0 10   1 0     0   0   7 6                       13 2 0 10   1 0     0   0   7 6                 13
1931983 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No High 06 12 2019   pk_12_total 8 0 37   1 0     0   2   32 16                       48 8 0 37   1 0     0   2   32 16                 48
1932000 CO     school 803780 120   ENGLEWOOD 1 80378001310 206 COLORADO'S FINEST HIGH SCHOOL OF CHOICE   Alternative School No High 09 12 2019   grade_10 51 0 22   0 0     0   3   41 35                       76 51 0 22   0 0     0   3   41 35                 76
1932001 CO     school 803780 120   ENGLEWOOD 1 80378001310 206 COLORADO'S FINEST HIGH SCHOOL OF CHOICE   Alternative School No High 09 12 2019   grade_11 57 3 34   1 1     0   6   59 43                       102 57 3 34   1 1     0   6   59 43                 102
1932002 CO     school 803780 120   ENGLEWOOD 1 80378001310 206 COLORADO'S FINEST HIGH SCHOOL OF CHOICE   Alternative School No High 09 12 2019   grade_12 65 4 23   1 0     0   2   48 47                       95 65 4 23   1 0     0   2   48 47                 95
1932003 CO     school 803780 120   ENGLEWOOD 1 80378001310 206 COLORADO'S FINEST HIGH SCHOOL OF CHOICE   Alternative School No High 09 12 2019   grade_9 14 1 12   0 0     0   1   16 12                       28 14 1 12   0 0     0   1   16 12                 28
1932004 CO     school 803780 120   ENGLEWOOD 1 80378001310 206 COLORADO'S FINEST HIGH SCHOOL OF CHOICE   Alternative School No High 09 12 2019   pk_12_total 187 8 91   2 1     0   12   164 137                       301 187 8 91   2 1     0   12   164 137                 301
1932069 CO     school 806540 123   SHERIDAN 2 80654006565 8123 SOAR ACADEMY   Alternative School No High 06 12 2019   grade_10 3 1 12   1 0     0   0   13 4                       17 3 1 12   1 0     0   0   13 4                 17
1932070 CO     school 806540 123   SHERIDAN 2 80654006565 8123 SOAR ACADEMY   Alternative School No High 06 12 2019   grade_11 2 0 21   3 0     0   0   15 11                       26 2 0 21   3 0     0   0   15 11                 26
1932071 CO     school 806540 123   SHERIDAN 2 80654006565 8123 SOAR ACADEMY   Alternative School No High 06 12 2019   grade_12 9 1 40   1 0     0   2   33 20                       53 9 1 40   1 0     0   2   33 20                 53
1932072 CO     school 806540 123   SHERIDAN 2 80654006565 8123 SOAR ACADEMY   Alternative School No High 06 12 2019   grade_9 0 0 6   0 0     0   0   3 3                       6 0 0 6   0 0     0   0   3 3                 6
1932073 CO     school 806540 123   SHERIDAN 2 80654006565 8123 SOAR ACADEMY   Alternative School No High 06 12 2019   pk_12_total 14 2 79   5 0     0   2   64 38                       102 14 2 79   5 0     0   2   64 38                 102
1932250 CO     school 802910 130   CHERRY CREEK 5 80291006649 2653 ENDEAVOR ACADEMY   Alternative School No High 09 12 2019   grade_10 5 0 5   0 0     0   1   3 8                       11 5 0 5   0 0     0   1   3 8                 11

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