Data source: Big Local News · About: Big Local

92,494 rows where state = "CO" sorted by school_nces_id

View and edit SQL

grade

year

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
1812539 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   kindergarten_full_day 13 0 7   0 1     0   3   13 11                       24 13 0 7   0 1     0   3   13 11                 24
1812540 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   kindergarten_half_day 24 0 5   0 1     0   3   17 16                       33 24 0 5   0 1     0   3   17 16                 33
1812541 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   pk_12_total 573 11 189   2 22     0   70   414 453                       867 573 11 189   2 22     0   70   414 453                 867
1906883 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes High 06 12 2018   grade_10 30 0 7   0 5     0   9   18 33                       51 30 0 7   0 5     0   9   18 33                 51
1906884 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes High 06 12 2018   grade_11 35 0 7   0 0     1   2   18 27                       45 35 0 7   0 0     1   2   18 27                 45
1906885 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes High 06 12 2018   grade_12 30 1 5   0 0     0   0   11 25                       36 30 1 5   0 0     0   0   11 25                 36
1906886 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes High 06 12 2018   grade_6 65 3 22   0 2     0   5   47 50                       97 65 3 22   0 2     0   5   47 50                 97
1906887 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes High 06 12 2018   grade_7 69 0 13   0 3     0   8   46 47                       93 69 0 13   0 3     0   8   46 47                 93
1906888 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes High 06 12 2018   grade_8 59 1 18   0 2     0   4   42 42                       84 59 1 18   0 2     0   4   42 42                 84
1906889 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes High 06 12 2018   grade_9 49 1 22   0 0     0   3   38 37                       75 49 1 22   0 0     0   3   38 37                 75
1906890 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes High 06 12 2018   pk_12_total 337 6 94   0 12     1   31   220 261                       481 337 6 94   0 12     1   31   220 261                 481
1944267 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_1 33 0 15   0 0     0   4   26 26                       52 33 0 15   0 0     0   4   26 26                 52
1944268 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_10 45 2 17   0 0     0   4   36 32                       68 45 2 17   0 0     0   4   36 32                 68
1944269 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_11 27 0 7   0 4     0   8   17 29                       46 27 0 7   0 4     0   8   17 29                 46
1944270 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_12 33 0 6   0 0     1   2   18 24                       42 33 0 6   0 0     1   2   18 24                 42
1944271 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_2 38 0 11   0 2     0   3   23 31                       54 38 0 11   0 2     0   3   23 31                 54
1944272 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_3 37 1 13   0 0     0   3   20 34                       54 37 1 13   0 0     0   3   20 34                 54
1944273 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_4 32 1 10   0 3     0   7   31 22                       53 32 1 10   0 3     0   7   31 22                 53
1944274 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_5 38 3 9   0 2     0   2   26 28                       54 38 3 9   0 2     0   2   26 28                 54
1944275 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_6 64 0 24   0 4     0   8   50 50                       100 64 0 24   0 4     0   8   50 50                 100
1944276 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_7 62 3 23   0 2     0   3   46 47                       93 62 3 23   0 2     0   3   46 47                 93
1944277 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_8 64 0 11   0 3     0   8   42 44                       86 64 0 11   0 3     0   8   42 44                 86
1944278 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   grade_9 51 0 12   0 2     0   3   30 38                       68 51 0 12   0 2     0   3   30 38                 68
1944279 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   kindergarten_full_day 15 0 5   0 0     0   4   14 10                       24 15 0 5   0 0     0   4   14 10                 24
1944280 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   kindergarten_half_day 17 1 8   1 1     0   1   10 19                       29 17 1 8   1 1     0   1   10 19                 29
1944281 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006437 8825 THOMAS MACLAREN STATE CHARTER SCHOOL   Regular School Yes Other KG 12 2019   pk_12_total 556 11 171   1 23     1   60   389 434                       823 556 11 171   1 23     1   60   389 434                 823
1145854 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006467 1877 COLORADO PROVOST ACADEMY   Regular School Yes 3.0 09 12 2015   grade_10 55.0 3.0 29.0   0.0 2.0     1.0   2.0   42.0 50.0                       92.0 55 3 29   0 2     1   2   42 50                 92
1145855 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006467 1877 COLORADO PROVOST ACADEMY   Regular School Yes 3.0 09 12 2015   grade_11 57.0 6.0 28.0   4.0 1.0     0.0   1.0   38.0 59.0                       97.0 57 6 28   4 1     0   1   38 59                 97
1145856 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006467 1877 COLORADO PROVOST ACADEMY   Regular School Yes 3.0 09 12 2015   grade_12 40.0 8.0 15.0   1.0 1.0     0.0   1.0   29.0 37.0                       66.0 40 8 15   1 1     0   1   29 37                 66
1145857 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006467 1877 COLORADO PROVOST ACADEMY   Regular School Yes 3.0 09 12 2015   grade_9 49.0 5.0 28.0   2.0 4.0     0.0   2.0   47.0 43.0                       90.0 49 5 28   2 4     0   2   47 43                 90
1145858 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006467 1877 COLORADO PROVOST ACADEMY   Regular School Yes 3.0 09 12 2015   pk_12_total 201.0 22.0 100.0   7.0 8.0     1.0   6.0   156.0 189.0                       345.0 201 22 100   7 8     1   6   156 189                 345
1145867 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006478 1901 COLORADO CALVERT ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_1 17.0 0.0 5.0   1.0 0.0     0.0   0.0   13.0 10.0                       23.0 17 0 5   1 0     0   0   13 10                 23
1145868 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006478 1901 COLORADO CALVERT ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_2 22.0 1.0 0.0   0.0 1.0     0.0   0.0   13.0 11.0                       24.0 22 1 0   0 1     0   0   13 11                 24
1145869 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006478 1901 COLORADO CALVERT ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_3 17.0 0.0 1.0   0.0 0.0     0.0   0.0   9.0 9.0                       18.0 17 0 1   0 0     0   0   9 9                 18
1145870 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006478 1901 COLORADO CALVERT ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_4 19.0 0.0 1.0   0.0 2.0     0.0   0.0   10.0 12.0                       22.0 19 0 1   0 2     0   0   10 12                 22
1145871 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006478 1901 COLORADO CALVERT ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_5 18.0 0.0 2.0   0.0 1.0     0.0   0.0   6.0 15.0                       21.0 18 0 2   0 1     0   0   6 15                 21
1145872 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006478 1901 COLORADO CALVERT ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_6 14.0 0.0 0.0   0.0 0.0     0.0   0.0   11.0 3.0                       14.0 14 0 0   0 0     0   0   11 3                 14
1145873 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006478 1901 COLORADO CALVERT ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_7 16.0 0.0 2.0   0.0 1.0     0.0   1.0   15.0 5.0                       20.0 16 0 2   0 1     0   1   15 5                 20
1145874 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006478 1901 COLORADO CALVERT ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_8 14.0 0.0 2.0   0.0 1.0     0.0   0.0   7.0 10.0                       17.0 14 0 2   0 1     0   0   7 10                 17
1145875 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006478 1901 COLORADO CALVERT ACADEMY   Regular School Yes 1.0 KG 08 2015   kindergarten_half_day 19.0 2.0 1.0   0.0 0.0     0.0   0.0   10.0 12.0                       22.0 19 2 1   0 0     0   0   10 12                 22
1145876 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006478 1901 COLORADO CALVERT ACADEMY   Regular School Yes 1.0 KG 08 2015   pk_12_total 156.0 3.0 14.0   1.0 6.0     0.0   1.0   94.0 87.0                       181.0 156 3 14   1 6     0   1   94 87                 181
720805 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative School Yes High 09 12 2017   grade_10 2 1 32   0 0     0   0   15 20                       35 2 1 32   0 0     0   0   15 20                 35
720806 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative School Yes High 09 12 2017   grade_11 11 0 90   0 1     0   0   45 57                       102 11 0 90   0 1     0   0   45 57                 102
720807 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative School Yes High 09 12 2017   grade_12 16 0 200   0 1     0   0   117 100                       217 16 0 200   0 1     0   0   117 100                 217
720808 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative School Yes High 09 12 2017   grade_9 0 0 7   0 0     0   0   5 2                       7 0 0 7   0 0     0   0   5 2                 7
720809 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative School Yes High 09 12 2017   pk_12_total 29 1 329   0 2     0   0   182 179                       361 29 1 329   0 2     0   0   182 179                 361
848352 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative Education School Yes 3.0 09 12 2016   grade_10 9 1 58   0 1     0   0   20 49                       69 9 1 58   0 1     0   0   20 49                 69
848353 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative Education School Yes 3.0 09 12 2016   grade_11 11 0 110   0 2     0   0   64 59                       123 11 0 110   0 2     0   0   64 59                 123
848354 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative Education School Yes 3.0 09 12 2016   grade_12 14 0 186   0 1     0   0   111 90                       201 14 0 186   0 1     0   0   111 90                 201
848355 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative Education School Yes 3.0 09 12 2016   grade_9 3 0 13   0 0     0   0   8 8                       16 3 0 13   0 0     0   0   8 8                 16
848356 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative Education School Yes 3.0 09 12 2016   pk_12_total 37 1 367   0 4     0   0   203 206                       409 37 1 367   0 4     0   0   203 206                 409
1145919 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative Education School Yes 3.0 09 12 2015   grade_10 5.0 1.0 67.0   0.0 0.0     0.0   0.0   29.0 44.0                       73.0 5 1 67   0 0     0   0   29 44                 73
1145920 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative Education School Yes 3.0 09 12 2015   grade_11 4.0 0.0 76.0   0.0 1.0     0.0   0.0   40.0 41.0                       81.0 4 0 76   0 1     0   0   40 41                 81
1145921 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative Education School Yes 3.0 09 12 2015   grade_12 13.0 0.0 208.0   0.0 1.0     1.0   0.0   113.0 110.0                       223.0 13 0 208   0 1     1   0   113 110                 223
1145922 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative Education School Yes 3.0 09 12 2015   grade_9 1.0 0.0 29.0   0.0 1.0     0.0   0.0   19.0 12.0                       31.0 1 0 29   0 1     0   0   19 12                 31
1145923 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative Education School Yes 3.0 09 12 2015   pk_12_total 23.0 1.0 380.0   0.0 3.0     1.0   0.0   201.0 207.0                       408.0 23 1 380   0 3     1   0   201 207                 408
1906771 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative School Yes High 09 12 2018   grade_10 4 1 54   0 0     0   0   28 31                       59 4 1 54   0 0     0   0   28 31                 59
1906772 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative School Yes High 09 12 2018   grade_11 4 1 65   0 1     0   1   36 36                       72 4 1 65   0 1     0   1   36 36                 72
1906773 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative School Yes High 09 12 2018   grade_12 16 1 172   0 2     0   1   96 96                       192 16 1 172   0 2     0   1   96 96                 192
1906774 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative School Yes High 09 12 2018   grade_9 0 0 7   0 0     0   0   5 2                       7 0 0 7   0 0     0   0   5 2                 7
1906775 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006480 4699 NEW AMERICA SCHOOL - THORNTON   Alternative School Yes High 09 12 2018   pk_12_total 24 3 298   0 3     0   2   165 165                       330 24 3 298   0 3     0   2   165 165                 330
720821 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_6 58 0 9   1 1     0   0   36 33                       69 58 0 9   1 1     0   0   36 33                 69
720822 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_7 60 0 3   0 0     0   0   39 24                       63 60 0 3   0 0     0   0   39 24                 63
720823 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_8 58 0 5   0 0     0   0   31 32                       63 58 0 5   0 0     0   0   31 32                 63
720824 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   pk_12_total 176 0 17   1 1     0   0   106 89                       195 176 0 17   1 1     0   0   106 89                 195
848357 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2016   grade_6 57 0 2   1 0     0   0   39 21                       60 57 0 2   1 0     0   0   39 21                 60
848358 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2016   grade_7 57 0 3   0 0     0   0   33 27                       60 57 0 3   0 0     0   0   33 27                 60
848359 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2016   grade_8 53 0 5   1 1     0   0   28 32                       60 53 0 5   1 1     0   0   28 32                 60
848360 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2016   pk_12_total 167 0 10   2 1     0   0   100 80                       180 167 0 10   2 1     0   0   100 80                 180
1145924 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2015   grade_6 55.0 0.0 4.0   0.0 0.0     0.0   1.0   34.0 26.0                       60.0 55 0 4   0 0     0   1   34 26                 60
1145925 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2015   grade_7 53.0 0.0 6.0   1.0 1.0     0.0   0.0   27.0 34.0                       61.0 53 0 6   1 1     0   0   27 34                 61
1145926 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2015   grade_8 49.0 0.0 5.0   1.0 0.0     0.0   0.0   25.0 30.0                       55.0 49 0 5   1 0     0   0   25 30                 55
1145927 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2015   pk_12_total 157.0 0.0 15.0   2.0 1.0     0.0   1.0   86.0 90.0                       176.0 157 0 15   2 1     0   1   86 90                 176
1751336 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2021   grade_4 29 1 3   0 0     0   0   18 15                       33 29 1 3   0 0     0   0   18 15                 33
1751337 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2021   grade_5 29 0 3   0 0     0   0   16 16                       32 29 0 3   0 0     0   0   16 16                 32
1751338 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2021   grade_6 49 0 14   1 1     0   2   34 33                       67 49 0 14   1 1     0   2   34 33                 67
1751339 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2021   grade_7 54 0 4   1 1     0   1   31 30                       61 54 0 4   1 1     0   1   31 30                 61
1751340 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2021   grade_8 54 0 5   0 0     1   0   32 28                       60 54 0 5   0 0     1   0   32 28                 60
1751341 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2021   pk_12_total 215 1 29   2 2     1   3   131 122                       253 215 1 29   2 2     1   3   131 122                 253
1812430 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2020   grade_4 27 0 3   0 0     0   0   15 15                       30 27 0 3   0 0     0   0   15 15                 30
1812431 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2020   grade_5 25 0 6   1 1     0   0   16 17                       33 25 0 6   1 1     0   0   16 17                 33
1812432 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2020   grade_6 54 0 3   1 1     0   1   31 29                       60 54 0 3   1 1     0   1   31 29                 60
1812433 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2020   grade_7 57 0 4   0 0     1   0   34 28                       62 57 0 4   0 0     1   0   34 28                 62
1812434 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2020   grade_8 50 0 6   2 0     0   2   30 30                       60 50 0 6   2 0     0   2   30 30                 60
1812435 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2020   pk_12_total 213 0 22   4 2     1   3   126 119                       245 213 0 22   4 2     1   3   126 119                 245
1906790 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 04 08 2018   grade_4 29 0 1   1 1     0   0   18 14                       32 29 0 1   1 1     0   0   18 14                 32
1906791 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 04 08 2018   grade_5 29 0 1   0 0     1   0   16 15                       31 29 0 1   0 0     1   0   16 15                 31
1906792 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 04 08 2018   grade_6 54 0 5   2 0     0   3   32 32                       64 54 0 5   2 0     0   3   32 32                 64
1906793 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 04 08 2018   grade_7 54 0 9   1 1     0   0   36 29                       65 54 0 9   1 1     0   0   36 29                 65
1906794 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 04 08 2018   grade_8 58 0 3   0 0     0   1   38 24                       62 58 0 3   0 0     0   1   38 24                 62
1906795 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 04 08 2018   pk_12_total 224 0 19   4 2     1   4   140 114                       254 224 0 19   4 2     1   4   140 114                 254
1944168 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 04 08 2019   grade_4 26 0 3   1 1     0   0   17 14                       31 26 0 3   1 1     0   0   17 14                 31
1944169 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 04 08 2019   grade_5 30 0 1   1 1     0   0   19 14                       33 30 0 1   1 1     0   0   19 14                 33
1944170 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 04 08 2019   grade_6 59 0 2   0 0     1   0   33 29                       62 59 0 2   0 0     1   0   33 29                 62
1944171 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 04 08 2019   grade_7 56 0 3   2 0     0   1   31 31                       62 56 0 3   2 0     0   1   31 31                 62
1944172 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 04 08 2019   grade_8 55 0 6   1 1     0   0   32 31                       63 55 0 6   1 1     0   0   32 31                 63
1944173 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006502 5453 MOUNTAIN MIDDLE SCHOOL   Regular School Yes Middle 04 08 2019   pk_12_total 226 0 15   5 3     1   1   132 119                       251 226 0 15   5 3     1   1   132 119                 251
720777 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006503 3439 GLOBAL VILLAGE ACADEMY - NORTHGLENN   Regular School Yes Elementary KG 08 2017   grade_1 75 5 80   0 5     0   1   68 98                       166 75 5 80   0 5     0   1   68 98                 166
720778 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006503 3439 GLOBAL VILLAGE ACADEMY - NORTHGLENN   Regular School Yes Elementary KG 08 2017   grade_2 79 1 65   0 5     4   0   66 88                       154 79 1 65   0 5     4   0   66 88                 154
720779 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002006503 3439 GLOBAL VILLAGE ACADEMY - NORTHGLENN   Regular School Yes Elementary KG 08 2017   grade_3 68 4 71   0 4     0   1   59 89                       148 68 4 71   0 4     0   1   59 89                 148

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