Data source: Big Local News · About: Big Local

13,207 rows where state = "CO" and year = 2017 sorted by ccd_school_type

View and edit SQL

year

  • 2017 · 13,207
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
707817 CO     school   10   MAPLETON 1   0 Not a school             2017   grade_12 5 0 10   0 0     0   0   10 5                       15 5 0 10   0 0     0   0   10 5                 15
707818 CO     school   10   MAPLETON 1   0 Not a school             2017   pk_12_total 5 0 10   0 0     0   0   10 5                       15 5 0 10   0 0     0   0   10 5                 15
708497 CO     school   40   SCHOOL DISTRICT 27J   4034 ELMWOOD BAPTIST SCHOOL             2017   grade_3 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
708498 CO     school   40   SCHOOL DISTRICT 27J   4034 ELMWOOD BAPTIST SCHOOL             2017   grade_4 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
708499 CO     school   40   SCHOOL DISTRICT 27J   4034 ELMWOOD BAPTIST SCHOOL             2017   pk_12_total 2 0 0   0 0     0   0   0 2                       2 2 0 0   0 0     0   0   0 2                 2
708646 CO     school   70   WESTMINSTER PUBLIC SCHOOLS   0 Not a school             2017   grade_12 1 0 3   0 0     0   0   1 3                       4 1 0 3   0 0     0   0   1 3                 4
708647 CO     school   70   WESTMINSTER PUBLIC SCHOOLS   0 Not a school             2017   pk_12_total 1 0 3   0 0     0   0   1 3                       4 1 0 3   0 0     0   0   1 3                 4
709484 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_10 0 0 0   0 0     0   1   1 0                       1 0 0 0   0 0     0   1   1 0                 1
709485 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_11 1 0 1   0 0     0   0   1 1                       2 1 0 1   0 0     0   0   1 1                 2
709486 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_12 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
709487 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_2 1 2 0   0 0     0   0   2 1                       3 1 2 0   0 0     0   0   2 1                 3
709488 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_3 0 0 2   0 0     0   0   2 0                       2 0 0 2   0 0     0   0   2 0                 2
709489 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_4 0 1 0   0 0     0   0   0 1                       1 0 1 0   0 0     0   0   0 1                 1
709490 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_5 0 0 0   0 0     0   1   0 1                       1 0 0 0   0 0     0   1   0 1                 1
709491 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_6 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
709492 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   grade_8 4 0 0   0 0     0   0   2 2                       4 4 0 0   0 0     0   0   2 2                 4
709493 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2017   pk_12_total 7 3 4   0 0     0   2   9 7                       16 7 3 4   0 0     0   2   9 7                 16
711230 CO     school   870   DELTA COUNTY 50(J)   1980 GREAT BEGINNINGS             2017   pk_12_total 12 0 5   0 0     0   1   8 10                       18 12 0 5   0 0     0   1   8 10                 18
711231 CO     school   870   DELTA COUNTY 50(J)   1980 GREAT BEGINNINGS             2017   pre_kindergarten 12 0 5   0 0     0   1   8 10                       18 12 0 5   0 0     0   1   8 10                 18
711295 CO     school   870   DELTA COUNTY 50(J)   4234 LITTLE SPROUTS             2017   pk_12_total 24 0 5   0 0     0   2   16 15                       31 24 0 5   0 0     0   2   16 15                 31
711296 CO     school   870   DELTA COUNTY 50(J)   4234 LITTLE SPROUTS             2017   pre_kindergarten 24 0 5   0 0     0   2   16 15                       31 24 0 5   0 0     0   2   16 15                 31
715516 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2017   grade_11 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
715517 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2017   grade_12 9 0 0   0 0     0   0   4 5                       9 9 0 0   0 0     0   0   4 5                 9
715518 CO     school   1420   JEFFERSON COUNTY R-1   0 Not a school             2017   pk_12_total 10 0 0   0 0     0   0   4 6                       10 10 0 0   0 0     0   0   4 6                 10
716933 CO     school   1520   DURANGO 9-R   0 Not a school             2017   grade_10 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
716934 CO     school   1520   DURANGO 9-R   0 Not a school             2017   grade_11 1 0 0   1 0     0   0   1 1                       2 1 0 0   1 0     0   0   1 1                 2
716935 CO     school   1520   DURANGO 9-R   0 Not a school             2017   grade_12 11 0 7   4 1     0   1   19 5                       24 11 0 7   4 1     0   1   19 5                 24
716936 CO     school   1520   DURANGO 9-R   0 Not a school             2017   pk_12_total 12 0 8   5 1     0   1   20 7                       27 12 0 8   5 1     0   1   20 7                 27
717066 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_10 2 0 2   0 0     0   0   3 1                       4 2 0 2   0 0     0   0   3 1                 4
717067 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_11 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
717068 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_12 1 0 2   0 0     0   0   2 1                       3 1 0 2   0 0     0   0   2 1                 3
717069 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
717070 CO     school   1550   POUDRE R-1   0 Not a school             2017   grade_9 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
717071 CO     school   1550   POUDRE R-1   0 Not a school             2017   pk_12_total 6 0 5   0 0     0   0   8 3                       11 6 0 5   0 0     0   0   8 3                 11
719075 CO     school   2690   PUEBLO CITY 60   0 Not a school             2017   grade_12 12 2 26   0 1     0   1   19 23                       42 12 2 26   0 1     0   1   19 23                 42
719076 CO     school   2690   PUEBLO CITY 60   0 Not a school             2017   pk_12_total 12 2 26   0 1     0   1   19 23                       42 12 2 26   0 1     0   1   19 23                 42
719496 CO     school   2730   DEL NORTE C-7   0 Not a school             2017   grade_6 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
719497 CO     school   2730   DEL NORTE C-7   0 Not a school             2017   pk_12_total 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
720095 CO     school   3100   WINDSOR RE-4   0 Not a school             2017   grade_11 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
720096 CO     school   3100   WINDSOR RE-4   0 Not a school             2017   pk_12_total 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
721016 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_10 12 3 22   0 0     0   2   31 8                       39 12 3 22   0 0     0   2   31 8                 39
721017 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_11 18 8 22   0 1     0   3   36 16                       52 18 8 22   0 1     0   3   36 16                 52
721018 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_12 14 9 20   1 0     0   0   31 13                       44 14 9 20   1 0     0   0   31 13                 44
721019 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_6 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
721020 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_7 1 1 3   0 0     0   0   4 1                       5 1 1 3   0 0     0   0   4 1                 5
721021 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_8 6 2 8   0 0     0   0   13 3                       16 6 2 8   0 0     0   0   13 3                 16
721022 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   grade_9 10 6 19   1 0     0   0   29 7                       36 10 6 19   1 0     0   0   29 7                 36
721023 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2017   pk_12_total 61 29 95   2 1     0   5   145 48                       193 61 29 95   2 1     0   5   145 48                 193
707988 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No Other 06 12 2017   grade_10 18 0 27   0 0     0   1   30 16                       46 18 0 27   0 0     0   1   30 16                 46
707989 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No Other 06 12 2017   grade_11 60 2 80   2 0     0   0   74 70                       144 60 2 80   2 0     0   0   74 70                 144
707990 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No Other 06 12 2017   grade_12 54 3 45   1 2     0   3   59 49                       108 54 3 45   1 2     0   3   59 49                 108
707991 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No Other 06 12 2017   grade_7 10 0 10   0 0     0   1   17 4                       21 10 0 10   0 0     0   1   17 4                 21
707992 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No Other 06 12 2017   grade_8 7 1 21   0 0     0   0   23 6                       29 7 1 21   0 0     0   0   23 6                 29
707993 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No Other 06 12 2017   grade_9 4 0 5   0 0     0   0   8 1                       9 4 0 5   0 0     0   0   8 1                 9
707994 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690001172 210 VANTAGE POINT   Alternative School No Other 06 12 2017   pk_12_total 153 6 188   3 2     0   5   211 146                       357 153 6 188   3 2     0   5   211 146                 357
708241 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2017   grade_10 4 0 2   0 0     0   0   5 1                       6 4 0 2   0 0     0   0   5 1                 6
708242 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2017   grade_11 14 0 15   0 1     0   1   10 21                       31 14 0 15   0 1     0   1   10 21                 31
708243 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2017   grade_12 147 5 164   6 6     0   2   189 141                       330 147 5 164   6 6     0   2   189 141                 330
708244 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2017   grade_6 2 1 1   0 0     0   0   3 1                       4 2 1 1   0 0     0   0   3 1                 4
708245 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2017   grade_7 2 0 1   0 0     0   0   2 1                       3 2 0 1   0 0     0   0   2 1                 3
708246 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2017   grade_8 6 0 1   0 0     0   0   6 1                       7 6 0 1   0 0     0   0   6 1                 7
708247 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2017   grade_9 3 1 2   0 0     0   0   6 0                       6 3 1 2   0 0     0   0   6 0                 6
708248 CO     school 806900 20   ADAMS 12 FIVE STAR SCHOOLS 80690006550 6956 PATHWAYS FUTURE CENTER   Alternative School No Other KG 12 2017   pk_12_total 178 7 186   6 7     0   3   221 166                       387 178 7 186   6 7     0   3   221 166                 387
708355 CO     school 801950 30   ADAMS COUNTY 14 80195001307 22 LESTER R ARNOLD HIGH SCHOOL   Alternative School No High 09 12 2017   grade_10 2 1 29   0 0     0   0   14 18                       32 2 1 29   0 0     0   0   14 18                 32
708356 CO     school 801950 30   ADAMS COUNTY 14 80195001307 22 LESTER R ARNOLD HIGH SCHOOL   Alternative School No High 09 12 2017   grade_11 6 3 56   1 0     0   2   34 34                       68 6 3 56   1 0     0   2   34 34                 68
708357 CO     school 801950 30   ADAMS COUNTY 14 80195001307 22 LESTER R ARNOLD HIGH SCHOOL   Alternative School No High 09 12 2017   grade_12 12 3 118   1 0     0   1   73 62                       135 12 3 118   1 0     0   1   73 62                 135
708358 CO     school 801950 30   ADAMS COUNTY 14 80195001307 22 LESTER R ARNOLD HIGH SCHOOL   Alternative School No High 09 12 2017   grade_9 0 0 4   0 0     0   0   2 2                       4 0 0 4   0 0     0   0   2 2                 4
708359 CO     school 801950 30   ADAMS COUNTY 14 80195001307 22 LESTER R ARNOLD HIGH SCHOOL   Alternative School No High 09 12 2017   pk_12_total 20 7 207   2 0     0   3   123 116                       239 20 7 207   2 0     0   3   123 116                 239
708445 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000729 1021 BRIGHTON HERITAGE ACADEMY   Alternative School No Other 06 12 2017   grade_10 11 1 19   1 0     0   1   22 11                       33 11 1 19   1 0     0   1   22 11                 33
708446 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000729 1021 BRIGHTON HERITAGE ACADEMY   Alternative School No Other 06 12 2017   grade_11 21 0 30   0 0     0   2   24 29                       53 21 0 30   0 0     0   2   24 29                 53
708447 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000729 1021 BRIGHTON HERITAGE ACADEMY   Alternative School No Other 06 12 2017   grade_12 56 2 54   3 2     0   2   74 45                       119 56 2 54   3 2     0   2   74 45                 119
708448 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000729 1021 BRIGHTON HERITAGE ACADEMY   Alternative School No Other 06 12 2017   grade_8 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
708449 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000729 1021 BRIGHTON HERITAGE ACADEMY   Alternative School No Other 06 12 2017   grade_9 3 0 6   0 0     0   1   7 3                       10 3 0 6   0 0     0   1   7 3                 10
708450 CO     school 802580 40   SCHOOL DISTRICT 27J 80258000729 1021 BRIGHTON HERITAGE ACADEMY   Alternative School No Other 06 12 2017   pk_12_total 91 3 110   4 2     0   6   128 88                       216 91 3 110   4 2     0   6   128 88                 216
708625 CO     school 806750 60   STRASBURG 31J 80675001669 7133 PRAIRIE CREEKS CHARTER SCHOOL   Alternative School Yes High 09 12 2017   grade_11 4 0 0   0 0     0   0   2 2                       4 4 0 0   0 0     0   0   2 2                 4
708626 CO     school 806750 60   STRASBURG 31J 80675001669 7133 PRAIRIE CREEKS CHARTER SCHOOL   Alternative School Yes High 09 12 2017   grade_12 5 0 0   0 0     0   0   4 1                       5 5 0 0   0 0     0   0   4 1                 5
708627 CO     school 806750 60   STRASBURG 31J 80675001669 7133 PRAIRIE CREEKS CHARTER SCHOOL   Alternative School Yes High 09 12 2017   grade_9 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
708628 CO     school 806750 60   STRASBURG 31J 80675001669 7133 PRAIRIE CREEKS CHARTER SCHOOL   Alternative School Yes High 09 12 2017   pk_12_total 10 0 0   0 0     0   0   7 3                       10 10 0 0   0 0     0   0   7 3                 10
708792 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   grade_10 0 0 6   0 0     0   1   3 4                       7 0 0 6   0 0     0   1   3 4                 7
708793 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   grade_11 3 0 8   1 0     0   0   4 8                       12 3 0 8   1 0     0   0   4 8                 12
708794 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   grade_12 5 0 4   0 0     0   0   3 6                       9 5 0 4   0 0     0   0   3 6                 9
708795 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   grade_6 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
708796 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   grade_7 0 0 3   0 0     0   0   2 1                       3 0 0 3   0 0     0   0   2 1                 3
708797 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   grade_8 3 0 4   0 0     0   0   5 2                       7 3 0 4   0 0     0   0   5 2                 7
708798 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   grade_9 1 1 18   0 0     0   0   14 6                       20 1 1 18   0 0     0   0   14 6                 20
708799 CO     school 802070 100   ALAMOSA RE-11J 80207006508 368 ALAMOSA OMBUDSMAN SCHOOL OF EXCELLENCE   Alternative School No Other 06 12 2017   pk_12_total 12 1 44   1 0     0   1   31 28                       59 12 1 44   1 0     0   1   31 28                 59
708816 CO     school 803780 120   ENGLEWOOD 1 80378001310 206 COLORADO'S FINEST HIGH SCHOOL OF CHOICE   Alternative School No High 09 12 2017   grade_10 41 1 27   1 2     1   2   37 38                       75 41 1 27   1 2     1   2   37 38                 75
708817 CO     school 803780 120   ENGLEWOOD 1 80378001310 206 COLORADO'S FINEST HIGH SCHOOL OF CHOICE   Alternative School No High 09 12 2017   grade_11 51 1 20   1 0     0   4   42 35                       77 51 1 20   1 0     0   4   42 35                 77
708818 CO     school 803780 120   ENGLEWOOD 1 80378001310 206 COLORADO'S FINEST HIGH SCHOOL OF CHOICE   Alternative School No High 09 12 2017   grade_12 39 2 25   0 0     0   1   40 27                       67 39 2 25   0 0     0   1   40 27                 67
708819 CO     school 803780 120   ENGLEWOOD 1 80378001310 206 COLORADO'S FINEST HIGH SCHOOL OF CHOICE   Alternative School No High 09 12 2017   grade_9 44 1 28   0 1     0   0   45 29                       74 44 1 28   0 1     0   0   45 29                 74
708820 CO     school 803780 120   ENGLEWOOD 1 80378001310 206 COLORADO'S FINEST HIGH SCHOOL OF CHOICE   Alternative School No High 09 12 2017   pk_12_total 175 5 100   2 3     1   7   164 129                       293 175 5 100   2 3     1   7   164 129                 293
708885 CO     school 806540 123   SHERIDAN 2 80654006565 8123 SOAR ACADEMY   Alternative School No Other 06 12 2017   grade_10 0 0 10   0 0     0   0   5 5                       10 0 0 10   0 0     0   0   5 5                 10
708886 CO     school 806540 123   SHERIDAN 2 80654006565 8123 SOAR ACADEMY   Alternative School No Other 06 12 2017   grade_11 6 2 25   0 0     1   0   21 13                       34 6 2 25   0 0     1   0   21 13                 34
708887 CO     school 806540 123   SHERIDAN 2 80654006565 8123 SOAR ACADEMY   Alternative School No Other 06 12 2017   grade_12 8 0 42   1 0     0   1   28 24                       52 8 0 42   1 0     0   1   28 24                 52
708888 CO     school 806540 123   SHERIDAN 2 80654006565 8123 SOAR ACADEMY   Alternative School No Other 06 12 2017   grade_9 0 0 3   0 0     0   0   2 1                       3 0 0 3   0 0     0   0   2 1                 3
708889 CO     school 806540 123   SHERIDAN 2 80654006565 8123 SOAR ACADEMY   Alternative School No Other 06 12 2017   pk_12_total 14 2 80   1 0     1   1   56 43                       99 14 2 80   1 0     1   1   56 43                 99
709176 CO     school 802910 130   CHERRY CREEK 5 80291006563 6367 OPTIONS SCHOOL   Alternative School No Other KG 12 2017   grade_1 42 1 5   0 0     0   1   20 29                       49 42 1 5   0 0     0   1   20 29                 49
709177 CO     school 802910 130   CHERRY CREEK 5 80291006563 6367 OPTIONS SCHOOL   Alternative School No Other KG 12 2017   grade_10 19 0 2   0 2     0   0   16 7                       23 19 0 2   0 2     0   0   16 7                 23
709178 CO     school 802910 130   CHERRY CREEK 5 80291006563 6367 OPTIONS SCHOOL   Alternative School No Other KG 12 2017   grade_11 13 0 2   0 2     0   2   10 9                       19 13 0 2   0 2     0   2   10 9                 19
709179 CO     school 802910 130   CHERRY CREEK 5 80291006563 6367 OPTIONS SCHOOL   Alternative School No Other KG 12 2017   grade_12 15 0 1   0 0     0   2   9 9                       18 15 0 1   0 0     0   2   9 9                 18

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