Data source: Big Local News · About: Big Local

13,286 rows where state = "CO" and year = 2021 sorted by ccd_school_type

View and edit SQL

year

  • 2021 · 13,186
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
1740525 CO     school 802190 220   Archuleta County 50 Jt 80219006806 2269 San Juan Mountain School   Alternative School No High 09 12 2021   grade_12 7 0 8   3 0     0   0   9 9                       18 7 0 8   3 0     0   0   9 9                 18
1740526 CO     school 802190 220   Archuleta County 50 Jt 80219006806 2269 San Juan Mountain School   Alternative School No High 09 12 2021   grade_9 4 0 1   1 0     0   0   5 1                       6 4 0 1   1 0     0   0   5 1                 6
1740527 CO     school 802190 220   Archuleta County 50 Jt 80219006806 2269 San Juan Mountain School   Alternative School No High 09 12 2021   pk_12_total 23 1 12   9 0     0   0   29 16                       45 23 1 12   9 0     0   0   29 16                 45
1740635 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2021   grade_10 79 4 141   1 0     0   2   118 109                       227 79 4 141   1 0     0   2   118 109                 227
1740636 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2021   grade_11 90 18 189   1 1     0   3   142 160                       302 90 18 189   1 1     0   3   142 160                 302
1740637 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2021   grade_12 162 21 399   0 1     3   4   302 288                       590 162 21 399   0 1     3   4   302 288                 590
1740638 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2021   grade_6 31 3 46   1 0     0   1   39 43                       82 31 3 46   1 0     0   1   39 43                 82
1740639 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2021   grade_7 39 4 77   2 0     0   2   74 50                       124 39 4 77   2 0     0   2   74 50                 124
1740640 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2021   grade_8 54 4 101   0 0     0   4   88 75                       163 54 4 101   0 0     0   4   88 75                 163
1740641 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2021   grade_9 85 6 116   1 1     1   3   104 109                       213 85 6 116   1 1     1   3   104 109                 213
1740642 CO     school 805250 290   Las Animas RE-1 80525006678 443 AIM Global   Alternative School No High 06 12 2021   pk_12_total 540 60 1069   6 3     4   19   867 834                       1701 540 60 1069   6 3     4   19   867 834                 1701
1740986 CO     school 805370 470   St Vrain Valley RE1J 80537001374 6498 Olde Columbine High School   Alternative School No High 09 12 2021   grade_10 5 0 2   0 0     0   0   3 4                       7 5 0 2   0 0     0   0   3 4                 7
1740987 CO     school 805370 470   St Vrain Valley RE1J 80537001374 6498 Olde Columbine High School   Alternative School No High 09 12 2021   grade_11 13 1 10   1 1     0   0   14 12                       26 13 1 10   1 1     0   0   14 12                 26
1740988 CO     school 805370 470   St Vrain Valley RE1J 80537001374 6498 Olde Columbine High School   Alternative School No High 09 12 2021   grade_12 17 0 59   0 0     0   2   48 30                       78 17 0 59   0 0     0   2   48 30                 78
1740989 CO     school 805370 470   St Vrain Valley RE1J 80537001374 6498 Olde Columbine High School   Alternative School No High 09 12 2021   pk_12_total 35 1 71   1 1     0   2   65 46                       111 35 1 71   1 1     0   2   65 46                 111
1741031 CO     school 805370 470   St Vrain Valley RE1J 80537006532 7839 St. Vrain Global Online Academy   Alternative School No High 09 12 2021   grade_10 13 0 1   0 0     0   0   4 10                       14 13 0 1   0 0     0   0   4 10                 14
1741032 CO     school 805370 470   St Vrain Valley RE1J 80537006532 7839 St. Vrain Global Online Academy   Alternative School No High 09 12 2021   grade_11 26 0 2   0 0     0   1   16 13                       29 26 0 2   0 0     0   1   16 13                 29
1741033 CO     school 805370 470   St Vrain Valley RE1J 80537006532 7839 St. Vrain Global Online Academy   Alternative School No High 09 12 2021   grade_12 50 0 6   0 1     0   0   28 29                       57 50 0 6   0 1     0   0   28 29                 57
1741034 CO     school 805370 470   St Vrain Valley RE1J 80537006532 7839 St. Vrain Global Online Academy   Alternative School No High 09 12 2021   grade_9 6 0 0   0 0     1   0   3 4                       7 6 0 0   0 0     1   0   3 4                 7
1741035 CO     school 805370 470   St Vrain Valley RE1J 80537006532 7839 St. Vrain Global Online Academy   Alternative School No High 09 12 2021   pk_12_total 95 0 9   0 1     1   1   51 56                       107 95 0 9   0 1     1   1   51 56                 107
1741074 CO     school 802490 480   Boulder Valley Re 2 80249001219 125 Arapahoe Ridge High School   Alternative School No High 09 12 2021   grade_10 3 0 11   0 0     0   3   11 6                       17 3 0 11   0 0     0   3   11 6                 17
1741075 CO     school 802490 480   Boulder Valley Re 2 80249001219 125 Arapahoe Ridge High School   Alternative School No High 09 12 2021   grade_11 19 0 21   0 0     0   0   19 21                       40 19 0 21   0 0     0   0   19 21                 40
1741076 CO     school 802490 480   Boulder Valley Re 2 80249001219 125 Arapahoe Ridge High School   Alternative School No High 09 12 2021   grade_12 34 0 39   1 2     0   2   42 36                       78 34 0 39   1 2     0   2   42 36                 78
1741077 CO     school 802490 480   Boulder Valley Re 2 80249001219 125 Arapahoe Ridge High School   Alternative School No High 09 12 2021   pk_12_total 56 0 71   1 2     0   5   72 63                       135 56 0 71   1 2     0   5   72 63                 135
1741130 CO     school 802490 480   Boulder Valley Re 2 80249001631 934 Boulder Prep Charter High School   Alternative School Yes High 09 12 2021   grade_10 6 0 4   0 0     0   1   8 3                       11 6 0 4   0 0     0   1   8 3                 11
1741131 CO     school 802490 480   Boulder Valley Re 2 80249001631 934 Boulder Prep Charter High School   Alternative School Yes High 09 12 2021   grade_11 20 1 12   0 0     0   3   25 11                       36 20 1 12   0 0     0   3   25 11                 36
1741132 CO     school 802490 480   Boulder Valley Re 2 80249001631 934 Boulder Prep Charter High School   Alternative School Yes High 09 12 2021   grade_12 34 1 10   1 1     0   6   24 29                       53 34 1 10   1 1     0   6   24 29                 53
1741133 CO     school 802490 480   Boulder Valley Re 2 80249001631 934 Boulder Prep Charter High School   Alternative School Yes High 09 12 2021   grade_9 5 0 1   0 0     0   0   4 2                       6 5 0 1   0 0     0   0   4 2                 6
1741134 CO     school 802490 480   Boulder Valley Re 2 80249001631 934 Boulder Prep Charter High School   Alternative School Yes High 09 12 2021   pk_12_total 65 2 27   1 1     0   10   61 45                       106 65 2 27   1 1     0   10   61 45                 106
1741294 CO     school 802490 480   Boulder Valley Re 2 80249002013 4496 Justice High Charter School   Alternative School Yes High 06 12 2021   grade_10 3 1 3   0 0     0   2   6 3                       9 3 1 3   0 0     0   2   6 3                 9
1741295 CO     school 802490 480   Boulder Valley Re 2 80249002013 4496 Justice High Charter School   Alternative School Yes High 06 12 2021   grade_11 4 0 13   0 0     0   1   13 5                       18 4 0 13   0 0     0   1   13 5                 18
1741296 CO     school 802490 480   Boulder Valley Re 2 80249002013 4496 Justice High Charter School   Alternative School Yes High 06 12 2021   grade_12 8 1 38   0 0     0   4   39 12                       51 8 1 38   0 0     0   4   39 12                 51
1741297 CO     school 802490 480   Boulder Valley Re 2 80249002013 4496 Justice High Charter School   Alternative School Yes High 06 12 2021   grade_8 1 0 2   0 0     0   0   1 2                       3 1 0 2   0 0     0   0   1 2                 3
1741298 CO     school 802490 480   Boulder Valley Re 2 80249002013 4496 Justice High Charter School   Alternative School Yes High 06 12 2021   grade_9 4 0 2   0 0     0   0   4 2                       6 4 0 2   0 0     0   0   4 2                 6
1741299 CO     school 802490 480   Boulder Valley Re 2 80249002013 4496 Justice High Charter School   Alternative School Yes High 06 12 2021   pk_12_total 20 2 58   0 0     0   7   63 24                       87 20 2 58   0 0     0   7   63 24                 87
1741389 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2021   grade_1 32 0 3   0 0     0   2   17 20                       37 32 0 3   0 0     0   2   17 20                 37
1741390 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2021   grade_2 29 0 5   0 0     0   5   25 14                       39 29 0 5   0 0     0   5   25 14                 39
1741391 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2021   grade_3 32 0 1   0 2     0   4   21 18                       39 32 0 1   0 2     0   4   21 18                 39
1741392 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2021   grade_4 29 1 4   0 0     0   3   15 22                       37 29 1 4   0 0     0   3   15 22                 37
1741393 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2021   grade_5 32 0 4   1 1     1   2   26 15                       41 32 0 4   1 1     1   2   26 15                 41
1741394 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2021   grade_6 35 0 1   0 0     0   3   20 19                       39 35 0 1   0 0     0   3   20 19                 39
1741395 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2021   grade_7 30 0 5   0 1     0   5   19 22                       41 30 0 5   0 1     0   5   19 22                 41
1741396 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2021   grade_8 32 0 4   0 1     0   2   20 19                       39 32 0 4   0 1     0   2   20 19                 39
1741397 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2021   kindergarten_full_day 29 0 2   0 1     0   4   18 18                       36 29 0 2   0 1     0   4   18 18                 36
1741398 CO     school 802490 480   Boulder Valley Re 2 80249006199 6642 Horizons K-8 School   Alternative School Yes Elementary KG 08 2021   pk_12_total 280 1 29   1 6     1   30   181 167                       348 280 1 29   1 6     1   30   181 167                 348
1741478 CO     school 802640 490   Buena Vista R-31 80264006155 1508 Chaffee County High School   Alternative School No High 07 12 2021   grade_10 7 0 4   0 0     0   0   8 3                       11 7 0 4   0 0     0   0   8 3                 11
1741479 CO     school 802640 490   Buena Vista R-31 80264006155 1508 Chaffee County High School   Alternative School No High 07 12 2021   grade_11 7 0 2   0 0     0   0   7 2                       9 7 0 2   0 0     0   0   7 2                 9
1741480 CO     school 802640 490   Buena Vista R-31 80264006155 1508 Chaffee County High School   Alternative School No High 07 12 2021   grade_12 13 0 2   0 0     0   0   13 2                       15 13 0 2   0 0     0   0   13 2                 15
1741481 CO     school 802640 490   Buena Vista R-31 80264006155 1508 Chaffee County High School   Alternative School No High 07 12 2021   grade_9 3 0 1   0 0     0   0   4 0                       4 3 0 1   0 0     0   0   4 0                 4
1741482 CO     school 802640 490   Buena Vista R-31 80264006155 1508 Chaffee County High School   Alternative School No High 07 12 2021   pk_12_total 30 0 9   0 0     0   0   32 7                       39 30 0 9   0 0     0   0   32 7                 39
1741495 CO     school 806330 500   Salida R-32 80633006413 4085 Horizons Exploratory Academy   Alternative School No High 09 12 2021   grade_10 6 0 1   0 0     0   0   5 2                       7 6 0 1   0 0     0   0   5 2                 7
1741496 CO     school 806330 500   Salida R-32 80633006413 4085 Horizons Exploratory Academy   Alternative School No High 09 12 2021   grade_11 6 0 2   1 0     0   0   1 8                       9 6 0 2   1 0     0   0   1 8                 9
1741497 CO     school 806330 500   Salida R-32 80633006413 4085 Horizons Exploratory Academy   Alternative School No High 09 12 2021   grade_12 4 0 2   0 0     0   2   4 4                       8 4 0 2   0 0     0   2   4 4                 8
1741498 CO     school 806330 500   Salida R-32 80633006413 4085 Horizons Exploratory Academy   Alternative School No High 09 12 2021   grade_9 5 0 0   0 0     0   0   2 3                       5 5 0 0   0 0     0   0   2 3                 5
1741499 CO     school 806330 500   Salida R-32 80633006413 4085 Horizons Exploratory Academy   Alternative School No High 09 12 2021   pk_12_total 21 0 5   1 0     0   2   12 17                       29 21 0 5   1 0     0   2   12 17                 29
1741608 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2021   grade_10 0 0 4   1 0     0   0   2 3                       5 0 0 4   1 0     0   0   2 3                 5
1741609 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2021   grade_11 5 0 8   1 0     0   0   7 7                       14 5 0 8   1 0     0   0   7 7                 14
1741610 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2021   grade_12 5 0 10   0 0     0   0   6 9                       15 5 0 10   0 0     0   0   6 9                 15
1741611 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2021   grade_4 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1741612 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2021   grade_5 0 0 0   1 0     0   0   1 0                       1 0 0 0   1 0     0   0   1 0                 1
1741613 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2021   grade_6 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1741614 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2021   grade_7 1 0 2   0 0     0   0   2 1                       3 1 0 2   0 0     0   0   2 1                 3
1741615 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2021   grade_8 0 0 2   0 0     0   0   2 0                       2 0 0 2   0 0     0   0   2 0                 2
1741616 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2021   grade_9 2 0 3   0 0     0   0   2 3                       5 2 0 3   0 0     0   0   2 3                 5
1741617 CO     school 805100 550   North Conejos RE-1J 80510006601 6339 North Conejos Alternative Program   Alternative School No Other KG 12 2021   pk_12_total 14 0 30   3 0     0   0   23 24                       47 14 0 30   3 0     0   0   23 24                 47
1741733 CO     school 803330 870   Delta County 50(J) 80333002001 2152 Delta Academy of Applied Learning   Alternative School No Middle 05 08 2021   grade_5 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1741734 CO     school 803330 870   Delta County 50(J) 80333002001 2152 Delta Academy of Applied Learning   Alternative School No Middle 05 08 2021   grade_6 7 0 0   0 0     0   0   2 5                       7 7 0 0   0 0     0   0   2 5                 7
1741735 CO     school 803330 870   Delta County 50(J) 80333002001 2152 Delta Academy of Applied Learning   Alternative School No Middle 05 08 2021   grade_7 6 0 1   0 0     0   0   2 5                       7 6 0 1   0 0     0   0   2 5                 7
1741736 CO     school 803330 870   Delta County 50(J) 80333002001 2152 Delta Academy of Applied Learning   Alternative School No Middle 05 08 2021   grade_8 7 0 1   0 0     0   0   6 2                       8 7 0 1   0 0     0   0   6 2                 8
1741737 CO     school 803330 870   Delta County 50(J) 80333002001 2152 Delta Academy of Applied Learning   Alternative School No Middle 05 08 2021   pk_12_total 21 0 2   0 0     0   0   10 13                       23 21 0 2   0 0     0   0   10 13                 23
1741738 CO     school 803330 870   Delta County 50(J) 80333001953 2155 Grand Mesa Choice Academy   Alternative School No High 07 12 2021   grade_10 10 0 5   0 0     0   3   14 4                       18 10 0 5   0 0     0   3   14 4                 18
1741739 CO     school 803330 870   Delta County 50(J) 80333001953 2155 Grand Mesa Choice Academy   Alternative School No High 07 12 2021   grade_11 12 0 12   0 0     0   1   22 3                       25 12 0 12   0 0     0   1   22 3                 25
1741740 CO     school 803330 870   Delta County 50(J) 80333001953 2155 Grand Mesa Choice Academy   Alternative School No High 07 12 2021   grade_12 33 0 5   0 0     0   2   23 17                       40 33 0 5   0 0     0   2   23 17                 40
1741741 CO     school 803330 870   Delta County 50(J) 80333001953 2155 Grand Mesa Choice Academy   Alternative School No High 07 12 2021   grade_8 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
1741742 CO     school 803330 870   Delta County 50(J) 80333001953 2155 Grand Mesa Choice Academy   Alternative School No High 07 12 2021   pk_12_total 57 0 22   0 0     0   6   61 24                       85 57 0 22   0 0     0   6   61 24                 85
1741752 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2021   grade_1 48 0 3   0 0     0   2   22 31                       53 48 0 3   0 0     0   2   22 31                 53
1741753 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2021   grade_10 26 0 9   0 0     0   2   15 22                       37 26 0 9   0 0     0   2   15 22                 37
1741754 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2021   grade_11 31 0 7   0 0     0   4   21 21                       42 31 0 7   0 0     0   4   21 21                 42
1741755 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2021   grade_12 22 0 3   0 0     0   1   14 12                       26 22 0 3   0 0     0   1   14 12                 26
1741756 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2021   grade_2 45 1 3   0 0     0   2   29 22                       51 45 1 3   0 0     0   2   29 22                 51
1741757 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2021   grade_3 45 0 9   0 0     0   4   32 26                       58 45 0 9   0 0     0   4   32 26                 58
1741758 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2021   grade_4 42 2 7   0 1     0   5   34 23                       57 42 2 7   0 1     0   5   34 23                 57
1741759 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2021   grade_5 42 0 9   0 0     0   4   28 27                       55 42 0 9   0 0     0   4   28 27                 55
1741760 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2021   grade_6 37 1 5   0 1     0   1   18 27                       45 37 1 5   0 1     0   1   18 27                 45
1741761 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2021   grade_7 35 0 8   0 0     0   3   21 25                       46 35 0 8   0 0     0   3   21 25                 46
1741762 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2021   grade_8 34 0 7   0 1     1   4   26 21                       47 34 0 7   0 1     1   4   26 21                 47
1741763 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2021   grade_9 29 1 5   0 0     0   2   15 22                       37 29 1 5   0 0     0   2   15 22                 37
1741764 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2021   kindergarten_full_day 26 0 5   0 0     0   2   17 16                       33 26 0 5   0 0     0   2   17 16                 33
1741765 CO     school 803330 870   Delta County 50(J) 80333002024 2166 Vision Charter Academy   Alternative School Yes Other KG 12 2021   pk_12_total 462 5 80   0 3     1   36   292 295                       587 462 5 80   0 3     1   36   292 295                 587
1741833 CO     school 803360 880   Denver County 1 80336001724 40 Ridge View Academy Charter School   Alternative School Yes High 07 12 2021   grade_10 5 2 3   0 1     0   1   12 0                       12 5 2 3   0 1     0   1   12 0                 12
1741834 CO     school 803360 880   Denver County 1 80336001724 40 Ridge View Academy Charter School   Alternative School Yes High 07 12 2021   grade_11 4 1 2   1 0     0   0   8 0                       8 4 1 2   1 0     0   0   8 0                 8
1741835 CO     school 803360 880   Denver County 1 80336001724 40 Ridge View Academy Charter School   Alternative School Yes High 07 12 2021   grade_12 4 5 9   0 0     0   1   19 0                       19 4 5 9   0 0     0   1   19 0                 19
1741836 CO     school 803360 880   Denver County 1 80336001724 40 Ridge View Academy Charter School   Alternative School Yes High 07 12 2021   grade_9 4 3 9   0 0     1   2   19 0                       19 4 3 9   0 0     1   2   19 0                 19
1741837 CO     school 803360 880   Denver County 1 80336001724 40 Ridge View Academy Charter School   Alternative School Yes High 07 12 2021   pk_12_total 17 11 23   1 1     1   4   58 0                       58 17 11 23   1 1     1   4   58 0                 58
1741838 CO     school 803360 880   Denver County 1 80336001894 67 AUL Denver   Alternative School Yes High 09 12 2021   grade_10 3 2 40   0 0     0   0   27 18                       45 3 2 40   0 0     0   0   27 18                 45
1741839 CO     school 803360 880   Denver County 1 80336001894 67 AUL Denver   Alternative School Yes High 09 12 2021   grade_11 3 2 27   3 0     0   2   20 17                       37 3 2 27   3 0     0   2   20 17                 37
1741840 CO     school 803360 880   Denver County 1 80336001894 67 AUL Denver   Alternative School Yes High 09 12 2021   grade_12 1 2 42   0 0     0   0   25 20                       45 1 2 42   0 0     0   0   25 20                 45
1741841 CO     school 803360 880   Denver County 1 80336001894 67 AUL Denver   Alternative School Yes High 09 12 2021   grade_9 1 0 28   3 0     0   1   17 16                       33 1 0 28   3 0     0   1   17 16                 33
1741842 CO     school 803360 880   Denver County 1 80336001894 67 AUL Denver   Alternative School Yes High 09 12 2021   pk_12_total 8 6 137   6 0     0   3   89 71                       160 8 6 137   6 0     0   3   89 71                 160
1741975 CO     school 803360 880   Denver County 1 80336006583 1489 Compassion Road Academy   Alternative School No High 09 12 2021   grade_10 7 4 13   2 2     0   0   13 15                       28 7 4 13   2 2     0   0   13 15                 28

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