Data source: Big Local News · About: Big Local

3,382 rows where grade = "grade_9" and state = "CO" sorted by school_state_id

View and edit SQL

year

grade

  • grade_9 · 3,382
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
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
844652 CO     school   1550   POUDRE R-1   0 Not a school             2016   grade_9 0 0 1   0 0     0   1   1 1                       2 0 0 1   0 0     0   1   1 1                 2
1142235 CO     school   1550   POUDRE R-1   0 Not a school             2015   grade_9 0.0 0.0 2.0   0.0 0.0     0.0   0.0   2.0 0.0                       2.0 0 0 2   0 0     0   0   2 0                 2
1808700 CO     school   1550   Poudre R-1   0 Not a school             2020   grade_9 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1903015 CO     school   1550   POUDRE R-1   0 Not a school             2018   grade_9 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
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
837138 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2016   grade_9 1 0 2   0 0     0   1   3 1                       4 1 0 2   0 0     0   1   3 1                 4
1134854 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2015   grade_9 0.0 1.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0                       1.0 0 1 0   0 0     0   0   0 1                 1
1739976 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_9 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1895384 CO     school   180   ADAMS-ARAPAHOE 28J   1 FACILITIES WITH DISTRICT RUN EDUCATION             2018   grade_9 0 1 0   0 0     0   1   1 1                       2 0 1 0   0 0     0   1   1 1                 2
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
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
711330 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 11 10 276   3 6     0   2   182 126                       308 11 10 276   3 6     0   2   182 126                 308
838954 CO     school   880   DENVER COUNTY 1   10 ABRAHAM LINCOLN HIGH SCHOOL             2016   grade_9 11 13 366   7 14     0   3   235 179                       414 11 13 366   7 14     0   3   235 179                 414
1136639 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 22.0 14.0 429.0   9.0 15.0     0.0   3.0   293.0 199.0                       492.0 22 14 429   9 15     0   3   293 199                 492
1741831 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2021   grade_9 9 14 342   1 7     0   1   227 147                       374 9 14 342   1 7     0   1   227 147                 374
1802858 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2020   grade_9 9 20 302   4 7     0   2   202 142                       344 9 20 302   4 7     0   2   202 142                 344
1897219 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 13 6 241   1 4     0   3   149 119                       268 13 6 241   1 4     0   3   149 119                 268
1934548 CO     school 803360 880   DENVER COUNTY 1 80336000305 10 ABRAHAM LINCOLN HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 7 6 266   3 5     0   3   162 128                       290 7 6 266   3 5     0   3   162 128                 290
720631 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2017   grade_9 66 1 60   0 13     0   2   71 71                       142 66 1 60   0 13     0   2   71 71                 142
848199 CO     school   8001   CHARTER SCHOOL INSTITUTE   15 ACADEMY OF CHARTER SCHOOLS             2016   grade_9 79 3 46   2 13     0   1   74 70                       144 79 3 46   2 13     0   1   74 70                 144
1145767 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes 4.0 PK 12 2015   grade_9 86.0 3.0 43.0   0.0 9.0     0.0   4.0   68.0 77.0                       145.0 86 3 43   0 9     0   4   68 77                 145
1751091 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_9 76 2 49   0 4     0   3   64 70                       134 76 2 49   0 4     0   3   64 70                 134
1812206 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_9 76 2 48   0 15     0   3   73 71                       144 76 2 48   0 15     0   3   73 71                 144
1906579 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002000727 15 ACADEMY OF CHARTER SCHOOLS   Regular School Yes Other PK 12 2018   grade_9 72 0 54   0 9     0   4   62 77                       139 72 0 54   0 9     0   4   62 77                 139
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
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
836016 CO     school   30   ADAMS COUNTY 14   22 LESTER R ARNOLD HIGH SCHOOL             2016   grade_9 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
1738793 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2021   grade_9 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1799852 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2020   grade_9 0 0 5   0 0     0   0   3 2                       5 0 0 5   0 0     0   0   3 2                 5
1894229 CO     school 801950 30   ADAMS COUNTY 14 80195001307 22 LESTER R ARNOLD HIGH SCHOOL   Alternative School No High 09 12 2018   grade_9 1 1 7   0 0     0   0   5 4                       9 1 1 7   0 0     0   0   5 4                 9
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
708363 CO     school 801950 30   ADAMS COUNTY 14 80195000010 24 ADAMS CITY HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 60 11 456   2 3     0   6   262 276                       538 60 11 456   2 3     0   6   262 276                 538
836021 CO     school   30   ADAMS COUNTY 14   24 ADAMS CITY HIGH SCHOOL             2016   grade_9 67 16 428   5 1     1   5   269 254                       523 67 16 428   5 1     1   5   269 254                 523
1133736 CO     school 801950 30   ADAMS COUNTY 14 80195000010 24 ADAMS CITY HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 58.0 14.0 454.0   5.0 1.0     0.0   4.0   269.0 267.0                       536.0 58 14 454   5 1     0   4   269 267                 536
1738798 CO     school 801950 30   Adams County 14 80195000010 24 Adams City High School   Regular School No High 09 12 2021   grade_9 38 9 430   4 1     0   1   255 228                       483 38 9 430   4 1     0   1   255 228                 483
1799857 CO     school 801950 30   Adams County 14 80195000010 24 Adams City High School   Regular School No High 09 12 2020   grade_9 47 11 437   2 2     1   7   263 244                       507 47 11 437   2 2     1   7   263 244                 507
1894234 CO     school 801950 30   ADAMS COUNTY 14 80195000010 24 ADAMS CITY HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 59 9 476   4 1     0   5   287 267                       554 59 9 476   4 1     0   5   287 267                 554
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
715532 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006163 33 MC LAIN HIGH SCHOOL   Alternative School No High 07 12 2017   grade_9 11 0 2   0 0     0   2   9 6                       15 11 0 2   0 0     0   2   9 6                 15
843137 CO     school   1420   JEFFERSON COUNTY R-1   33 MC LAIN HIGH SCHOOL             2016   grade_9 11 0 0   3 0     0   0   8 6                       14 11 0 0   3 0     0   0   8 6                 14
1140743 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006163 33 MC LAIN HIGH SCHOOL   Alternative Education School No 3.0 07 12 2015   grade_9 6.0 0.0 4.0   0.0 0.0     0.0   0.0   6.0 4.0                       10.0 6 0 4   0 0     0   0   6 4                 10
1746127 CO     school 804800 1420   Jefferson County R-1 80480006163 33 McLain Community High School   Alternative School No High 07 12 2021   grade_9 5 0 4   0 0     0   0   6 3                       9 5 0 4   0 0     0   0   6 3                 9
1807212 CO     school 804800 1420   Jefferson County R-1 80480006163 33 McLain Community High School   Alternative School No High 07 12 2020   grade_9 2 0 7   0 0     0   0   7 2                       9 2 0 7   0 0     0   0   7 2                 9
1901450 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006163 33 MC LAIN HIGH SCHOOL   Alternative School No High 07 12 2018   grade_9 6 0 4   0 1     0   0   7 4                       11 6 0 4   0 1     0   0   7 4                 11
1938868 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006163 33 MCLAIN COMMUNITY HIGH SCHOOL   Alternative School No High 07 12 2019   grade_9 24 0 13   0 0     0   3   25 15                       40 24 0 13   0 0     0   3   25 15                 40
711335 CO     school 803360 880   DENVER COUNTY 1 80336001724 40 RIDGE VIEW ACADEMY CHARTER SCHOOL   Alternative School Yes High 09 12 2017   grade_9 24 11 45   1 0     0   3   84 0                       84 24 11 45   1 0     0   3   84 0                 84
838959 CO     school   880   DENVER COUNTY 1   40 RIDGE VIEW ACADEMY CHARTER SCHOOL             2016   grade_9 34 17 35   1 1     0   1   89 0                       89 34 17 35   1 1     0   1   89 0                 89
1136644 CO     school 803360 880   DENVER COUNTY 1 80336001724 40 RIDGE VIEW ACADEMY CHARTER SCHOOL   Alternative Education School Yes 3.0 09 12 2015   grade_9 25.0 19.0 48.0   2.0 0.0     0.0   0.0   84.0 10.0                       94.0 25 19 48   2 0     0   0   84 10                 94
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
1802864 CO     school 803360 880   Denver County 1 80336001724 40 Ridge View Academy Charter School   Alternative School Yes High 07 12 2020   grade_9 15 6 24   0 0     0   1   46 0                       46 15 6 24   0 0     0   1   46 0                 46
1897226 CO     school 803360 880   DENVER COUNTY 1 80336001724 40 RIDGE VIEW ACADEMY CHARTER SCHOOL   Alternative School Yes High 07 12 2018   grade_9 24 18 37   1 1     0   10   91 0                       91 24 18 37   1 1     0   10   91 0                 91
1934554 CO     school 803360 880   DENVER COUNTY 1 80336001724 40 RIDGE VIEW ACADEMY CHARTER SCHOOL   Alternative School Yes High 07 12 2019   grade_9 20 10 25   0 0     0   4   59 0                       59 20 10 25   0 0     0   4   59 0                 59
1744130 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2021   grade_9 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1805213 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2020   grade_9 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
1936930 CO     school 801980 960   AGATE 300 80198000021 48 AGATE JUNIOR SENIOR HIGH SCHOOL   Regular School No High 06 12 2019   grade_9 5 0 0   0 0     0   0   0 5                       5 5 0 0   0 0     0   0   0 5                 5
719686 CO     school 802850 2810   CENTER 26 JT 80285002008 51 THE ACADEMIC RECOVERY CENTER OF SAN LUIS VALLEY   Alternative School No High 09 12 2017   grade_9 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
847256 CO     school   2810   CENTER 26 JT   51 THE ACADEMIC RECOVERY CENTER OF SAN LUIS VALLEY             2016   grade_9 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1144826 CO     school 802850 2810   CENTER 26 JT 80285002008 51 THE ACADEMIC RECOVERY CENTER OF SAN LUIS VALLEY   Alternative Education School No 3.0 09 12 2015   grade_9 1.0 0.0 3.0   0.0 0.0     0.0   0.0   2.0 2.0                       4.0 1 0 3   0 0     0   0   2 2                 4
1750129 CO     school 802850 2810   Center 26 JT 80285002008 51 The Academic Recovery Center of San Luis Valley   Alternative School No High 09 12 2021   grade_9 0 0 2   0 0     0   0   1 1                       2 0 0 2   0 0     0   0   1 1                 2
1943006 CO     school 802850 2810   CENTER 26 JT 80285002008 51 THE ACADEMIC RECOVERY CENTER OF SAN LUIS VALLEY   Alternative School No High 09 12 2019   grade_9 0 0 2   0 0     0   0   1 1                       2 0 0 2   0 0     0   0   1 1                 2
715259 CO     school 806240 1195   GARFIELD RE-2 80624001906 65 COAL RIDGE HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 77 0 64   0 1     0   1   80 63                       143 77 0 64   0 1     0   1   80 63                 143
842855 CO     school   1195   GARFIELD RE-2   65 COAL RIDGE HIGH SCHOOL             2016   grade_9 74 0 58   1 1     0   5   75 64                       139 74 0 58   1 1     0   5   75 64                 139
1140459 CO     school 806240 1195   GARFIELD RE-2 80624001906 65 COAL RIDGE HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 89.0 2.0 69.0   0.0 0.0     0.0   4.0   89.0 75.0                       164.0 89 2 69   0 0     0   4   89 75                 164
1745856 CO     school 806240 1195   Garfield Re-2 80624001906 65 Coal Ridge High School   Regular School No High 09 12 2021   grade_9 69 1 69   0 0     0   2   71 70                       141 69 1 69   0 0     0   2   71 70                 141
1806943 CO     school 806240 1195   Garfield Re-2 80624001906 65 Coal Ridge High School   Regular School No High 09 12 2020   grade_9 66 0 70   0 0     0   5   63 78                       141 66 0 70   0 0     0   5   63 78                 141
1901179 CO     school 806240 1195   GARFIELD RE-2 80624001906 65 COAL RIDGE HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 91 0 62   0 1     0   2   90 66                       156 91 0 62   0 1     0   2   90 66                 156
1938594 CO     school 806240 1195   GARFIELD RE-2 80624001906 65 COAL RIDGE HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 70 1 74   0 1     0   3   80 69                       149 70 1 74   0 1     0   3   80 69                 149
717818 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000023 66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 07 12 2017   grade_9 3 0 5   0 0     0   0   6 2                       8 3 0 5   0 0     0   0   6 2                 8
845390 CO     school   1620   AGUILAR REORGANIZED 6   66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL             2016   grade_9 3 0 5   0 0     0   0   4 4                       8 3 0 5   0 0     0   0   4 4                 8
1142968 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000023 66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_9 4.0 0.0 8.0   0.0 0.0     0.0   0.0   6.0 6.0                       12.0 4 0 8   0 0     0   0   6 6                 12
1748274 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2021   grade_9 6 0 3   0 0     0   0   6 3                       9 6 0 3   0 0     0   0   6 3                 9
1809415 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   grade_9 2 0 7   0 0     0   0   5 4                       9 2 0 7   0 0     0   0   5 4                 9
1903763 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000023 66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 07 12 2018   grade_9 1 0 5   0 0     0   0   3 3                       6 1 0 5   0 0     0   0   3 3                 6
1941143 CO     school 802010 1620   AGUILAR REORGANIZED 6 80201000023 66 AGUILAR JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 06 12 2019   grade_9 2 0 3   0 0     0   0   2 3                       5 2 0 3   0 0     0   0   2 3                 5
711340 CO     school 803360 880   DENVER COUNTY 1 80336001894 67 ACADEMY OF URBAN LEARNING   Regular School Yes High 09 12 2017   grade_9 0 0 24   1 0     0   0   16 9                       25 0 0 24   1 0     0   0   16 9                 25
838964 CO     school   880   DENVER COUNTY 1   67 ACADEMY OF URBAN LEARNING             2016   grade_9 0 2 18   1 0     0   0   15 6                       21 0 2 18   1 0     0   0   15 6                 21
1136649 CO     school 803360 880   DENVER COUNTY 1 80336001894 67 ACADEMY OF URBAN LEARNING   Regular School Yes 3.0 09 12 2015   grade_9 1.0 2.0 10.0   0.0 0.0     0.0   0.0   7.0 6.0                       13.0 1 2 10   0 0     0   0   7 6                 13
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
1802869 CO     school 803360 880   Denver County 1 80336001894 67 Academy of Urban Learning   Alternative School Yes High 09 12 2020   grade_9 5 3 32   0 0     0   0   25 15                       40 5 3 32   0 0     0   0   25 15                 40
1897231 CO     school 803360 880   DENVER COUNTY 1 80336001894 67 ACADEMY OF URBAN LEARNING   Regular School Yes High 09 12 2018   grade_9 3 1 27   0 0     0   0   21 10                       31 3 1 27   0 0     0   0   21 10                 31
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
720648 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006418 75 ANIMAS HIGH SCHOOL   Regular School Yes High 09 12 2017   grade_9 61 0 9   3 0     0   2   34 41                       75 61 0 9   3 0     0   2   34 41                 75
848216 CO     school   8001   CHARTER SCHOOL INSTITUTE   75 ANIMAS HIGH SCHOOL             2016   grade_9 79 0 3   1 0     0   0   41 42                       83 79 0 3   1 0     0   0   41 42                 83
1145784 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006418 75 ANIMAS HIGH SCHOOL   Regular School Yes 3.0 09 12 2015   grade_9 89.0 0.0 4.0   1.0 0.0     0.0   0.0   43.0 51.0                       94.0 89 0 4   1 0     0   0   43 51                 94
1751098 CO     school 800020 8001   Charter School Institute 80002006418 75 Animas High School   Regular School Yes High 09 12 2021   grade_9 38 0 2   3 2     0   4   27 22                       49 38 0 2   3 2     0   4   27 22                 49
1812213 CO     school 800020 8001   Charter School Institute 80002006418 75 Animas High School   Regular School Yes High 09 12 2020   grade_9 29 0 4   1 0     0   1   18 17                       35 29 0 4   1 0     0   1   18 17                 35
1906597 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006418 75 ANIMAS HIGH SCHOOL   Regular School Yes High 09 12 2018   grade_9 54 0 6   2 1     1   1   43 22                       65 54 0 6   2 1     1   1   43 22                 65
1943968 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006418 75 ANIMAS HIGH SCHOOL   Regular School Yes High 09 12 2019   grade_9 31 0 12   0 0     0   1   25 19                       44 31 0 12   0 0     0   1   25 19                 44
714495 CO     school 801920 1040   ACADEMY 20 80192000002 76 AIR ACADEMY HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 248 7 39   1 14     1   19   158 171                       329 248 7 39   1 14     1   19   158 171                 329
842110 CO     school   1040   ACADEMY 20   76 AIR ACADEMY HIGH SCHOOL             2016   grade_9 257 9 41   2 5     2   26   165 177                       342 257 9 41   2 5     2   26   165 177                 342
1139724 CO     school 801920 1040   ACADEMY 20 80192000002 76 AIR ACADEMY HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 218.0 11.0 35.0   4.0 5.0     0.0   21.0   157.0 137.0                       294.0 218 11 35   4 5     0   21   157 137                 294
1744999 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2021   grade_9 238 13 54   4 6     0   21   160 176                       336 238 13 54   4 6     0   21   160 176                 336
1806089 CO     school 801920 1040   Academy 20 80192000002 76 Air Academy High School   Regular School No High 09 12 2020   grade_9 263 15 49   1 18     0   20   189 177                       366 263 15 49   1 18     0   20   189 177                 366
1900408 CO     school 801920 1040   ACADEMY 20 80192000002 76 AIR ACADEMY HIGH SCHOOL   Regular School No High 09 12 2018   grade_9 261 13 50   1 7     1   22   174 181                       355 261 13 50   1 7     1   22   174 181                 355
1937787 CO     school 801920 1040   ACADEMY 20 80192000002 76 AIR ACADEMY HIGH SCHOOL   Regular School No High 09 12 2019   grade_9 239 10 47   1 15     0   25   173 164                       337 239 10 47   1 15     0   25   173 164                 337
1751111 CO     school 800020 8001   Charter School Institute 80002006760 79 Ascent Classical Academy   Regular School Yes Other KG 12 2021   grade_9 23 0 1   0 2     0   0   13 13                       26 23 0 1   0 2     0   0   13 13                 26
1804276 CO     school 803450 900   Douglas County Re 1 80345006760 79 Ascent Classical Academy   Regular School Yes Other KG 11 2020   grade_9 34 0 4   0 0     0   0   21 17                       38 34 0 4   0 0     0   0   21 17                 38
1935963 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006760 79 ASCENT CLASSICAL ACADEMY   Regular School Yes Other KG 10 2019   grade_9 8 0 2   0 1     0   1   8 4                       12 8 0 2   0 1     0   1   8 4                 12
719922 CO     school 802040 3030   AKRON R-1 80204000025 90 AKRON HIGH SCHOOL   Regular School No High 09 12 2017   grade_9 12 0 2   0 0     0   1   7 8                       15 12 0 2   0 0     0   1   7 8                 15

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