Data source: Big Local News · About: Big Local

4,213 rows where grade = "grade_8" and state = "CO" sorted by district_state_id descending

View and edit SQL

year

grade

  • grade_8 · 4,213
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
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
848556 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2016   grade_8 3 0 5   0 0     0   0   6 2                       8 3 0 5   0 0     0   0   6 2                 8
1146095 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2015   grade_8 5.0 1.0 11.0   0.0 0.0     0.0   0.0   14.0 3.0                       17.0 5 1 11   0 0     0   0   14 3                 17
1751543 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2021   grade_8 5 1 2   0 1     0   0   9 0                       9 5 1 2   0 1     0   0   9 0                 9
1812624 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2020   grade_8 3 1 7   0 0     0   0   9 2                       11 3 1 7   0 0     0   0   9 2                 11
1906985 CO     school   9999   COLORADO DETENTION CENTERS   No school COLORADO DETENTION CENTERS             2018   grade_8 5 1 6   0 0     0   0   10 2                       12 5 1 6   0 0     0   0   10 2                 12
1944365 CO     school   9999   COLORADO DETENTION CENTER TOTAL   No school COLORADO DETENTION CENTER TOTAL             2019   grade_8 8 2 11   0 0     0   0   16 5                       21 8 2 11   0 0     0   0   16 5                 21
713848 CO     school 806480 990   WIDEFIELD 3 80648001120 4394 JANITELL JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2017   grade_8 118 29 70   1 6     4   22   143 107                       250 118 29 70   1 6     4   22   143 107                 250
713886 CO     school 806480 990   WIDEFIELD 3 80648001125 8178 SPROUL JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2017   grade_8 84 21 74   2 1     4   16   97 105                       202 84 21 74   2 1     4   16   97 105                 202
713897 CO     school 806480 990   WIDEFIELD 3 80648001126 9294 WATSON JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2017   grade_8 107 20 64   3 4     7   29   104 130                       234 107 20 64   3 4     7   29   104 130                 234
841462 CO     school 806480 990   WIDEFIELD 3 80648001120 4394 JANITELL JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2016   grade_8 111 33 71   2 5     3   23   127 121                       248 111 33 71   2 5     3   23   127 121                 248
841501 CO     school 806480 990   WIDEFIELD 3 80648001125 8178 SPROUL JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2016   grade_8 97 18 62   0 0     0   21   108 90                       198 97 18 62   0 0     0   21   108 90                 198
841512 CO     school 806480 990   WIDEFIELD 3 80648001126 9294 WATSON JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2016   grade_8 97 26 59   2 3     4   27   116 102                       218 97 26 59   2 3     4   27   116 102                 218
1139064 CO     school 806480 990   WIDEFIELD 3 80648001120 4394 JANITELL JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2015   grade_8 145.0 32.0 61.0   5.0 5.0     1.0   18.0   135.0 132.0                       267.0 145 32 61   5 5     1   18   135 132                 267
1139103 CO     school 806480 990   WIDEFIELD 3 80648001125 8178 SPROUL JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2015   grade_8 98.0 12.0 63.0   2.0 1.0     4.0   23.0   96.0 107.0                       203.0 98 12 63   2 1     4   23   96 107                 203
1139114 CO     school 806480 990   WIDEFIELD 3 80648001126 9294 WATSON JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2015   grade_8 130.0 21.0 65.0   2.0 7.0     2.0   19.0   131.0 115.0                       246.0 130 21 65   2 7     2   19   131 115                 246
1744335 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2021   grade_8 38 11 26   1 4     3   11   50 44                       94 38 11 26   1 4     3   11   50 44                 94
1744348 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2021   grade_8 83 24 84   0 4     5   34   125 109                       234 83 24 84   0 4     5   34   125 109                 234
1744357 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2021   grade_8 4 0 3   0 0     1   4   11 1                       12 4 0 3   0 0     1   4   11 1                 12
1744389 CO     school 806480 990   Widefield 3 80648001125 8178 Sproul Junior High School   Regular School No Middle 06 08 2021   grade_8 89 14 52   0 4     4   24   93 94                       187 89 14 52   0 4     4   24   93 94                 187
1744400 CO     school 806480 990   Widefield 3 80648001126 9294 Watson Junior High School   Regular School No Middle 06 08 2021   grade_8 69 14 53   0 1     0   21   75 83                       158 69 14 53   0 1     0   21   75 83                 158
1805414 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   grade_8 31 9 15   0 2     3   8   34 34                       68 31 9 15   0 2     3   8   34 34                 68
1805427 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2020   grade_8 130 28 84   1 4     6   36   154 135                       289 130 28 84   1 4     6   36   154 135                 289
1805436 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2020   grade_8 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1805468 CO     school 806480 990   Widefield 3 80648001125 8178 Sproul Junior High School   Regular School No Middle 06 08 2020   grade_8 98 18 70   1 2     1   23   107 106                       213 98 18 70   1 2     1   23   107 106                 213
1805479 CO     school 806480 990   Widefield 3 80648001126 9294 Watson Junior High School   Regular School No Middle 06 08 2020   grade_8 73 18 45   7 2     0   24   89 80                       169 73 18 45   7 2     0   24   89 80                 169
1899757 CO     school 806480 990   WIDEFIELD 3 80648001120 4394 JANITELL JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2018   grade_8 106 28 70   3 1     3   23   140 94                       234 106 28 70   3 1     3   23   140 94                 234
1899796 CO     school 806480 990   WIDEFIELD 3 80648001125 8178 SPROUL JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2018   grade_8 72 13 61   2 1     2   21   99 73                       172 72 13 61   2 1     2   21   99 73                 172
1899807 CO     school 806480 990   WIDEFIELD 3 80648001126 9294 WATSON JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2018   grade_8 118 18 63   3 5     2   26   124 111                       235 118 18 63   3 5     2   26   124 111                 235
1937132 CO     school 806480 990   WIDEFIELD 3 80648001120 4394 JANITELL JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2019   grade_8 110 19 75   1 7     5   26   130 113                       243 110 19 75   1 7     5   26   130 113                 243
1937141 CO     school 806480 990   WIDEFIELD 3 80648001885 5033 JAMES MADISON CHARTER ACADEMY SCHOOL   Regular School Yes Elementary KG 08 2019   grade_8 1 0 4   2 0     0   0   2 5                       7 1 0 4   2 0     0   0   2 5                 7
1937172 CO     school 806480 990   WIDEFIELD 3 80648001125 8178 SPROUL JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2019   grade_8 92 15 54   0 4     3   21   98 91                       189 92 15 54   0 4     3   21   98 91                 189
1937183 CO     school 806480 990   WIDEFIELD 3 80648001126 9294 WATSON JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2019   grade_8 136 19 65   2 2     5   19   123 125                       248 136 19 65   2 2     5   19   123 125                 248
713664 CO     school 804530 980   HARRISON 2 80453006691 369 ATLAS PREPARATORY MIDDLE SCHOOL   Regular School Yes Middle 05 08 2017   grade_8 14 17 93   2 0     1   5   67 65                       132 14 17 93   2 0     1   5   67 65                 132
713680 CO     school 804530 980   HARRISON 2 80453000662 1306 CARMEL MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 20 21 71   0 2     0   4   62 56                       118 20 21 71   0 2     0   4   62 56                 118
713698 CO     school 804530 980   HARRISON 2 80453000666 3522 FOX MEADOW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 53 35 63   1 3     7   19   105 76                       181 53 35 63   1 3     7   19   105 76                 181
713708 CO     school 804530 980   HARRISON 2 80453006535 3870 HIGH SCHOOL PREPARATORY ACADEMY   Regular School No High 08 12 2017   grade_8 5 4 7   0 0     0   2   13 5                       18 5 4 7   0 0     0   2   13 5                 18
713718 CO     school 804530 980   HARRISON 2 80453001964 4379 JAMES IRWIN CHARTER MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   grade_8 45 17 61   1 6     3   7   66 74                       140 45 17 61   1 6     3   7   66 74                 140
713738 CO     school 804530 980   HARRISON 2 80453006663 5763 MOUNTAIN VISTA HOMESCHOOL ACADEMY   Regular School No Other KG 12 2017   grade_8 11 0 5   0 0     0   0   9 7                       16 11 0 5   0 0     0   0   9 7                 16
713756 CO     school 804530 980   HARRISON 2 80453001903 6162 MOUNTAIN VISTA COMMUNITY SCHOOL   Regular School No Elementary PK 08 2017   grade_8 15 11 43   1 2     1   3   40 36                       76 15 11 43   1 2     1   3   40 36                 76
713775 CO     school 804530 980   HARRISON 2 80453000669 6686 PANORAMA MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 33 38 62   1 7     2   7   88 62                       150 33 38 62   1 7     2   7   88 62                 150
841283 CO     school   980   HARRISON 2   469 ATLAS PREPARATORY SCHOOL             2016   grade_8 25 23 106   2 1     1   6   79 85                       164 25 23 106   2 1     1   6   79 85                 164
841295 CO     school 804530 980   HARRISON 2 80453000662 1306 CARMEL MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 26 38 80   3 2     1   8   72 86                       158 26 38 80   3 2     1   8   72 86                 158
841313 CO     school 804530 980   HARRISON 2 80453000666 3522 FOX MEADOW MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 49 22 87   2 6     0   12   88 90                       178 49 22 87   2 6     0   12   88 90                 178
841323 CO     school 804530 980   HARRISON 2 80453006535 3870 HIGH SCHOOL PREPARATORY ACADEMY   Regular School No 3.0 08 12 2016   grade_8 6 4 8   0 0     0   1   10 9                       19 6 4 8   0 0     0   1   10 9                 19
841333 CO     school 804530 980   HARRISON 2 80453001964 4379 JAMES IRWIN CHARTER MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2016   grade_8 58 15 55   2 8     1   4   67 76                       143 58 15 55   2 8     1   4   67 76                 143
841352 CO     school 804530 980   HARRISON 2 80453006663 5763 MOUNTAIN VISTA HOMESCHOOL ACADEMY   Regular School No 4.0 KG 12 2016   grade_8 16 0 3   0 0     0   0   8 11                       19 16 0 3   0 0     0   0   8 11                 19
841370 CO     school 804530 980   HARRISON 2 80453001903 6162 MOUNTAIN VISTA COMMUNITY SCHOOL   Regular School No 1.0 PK 08 2016   grade_8 16 11 42   1 1     2   5   33 45                       78 16 11 42   1 1     2   5   33 45                 78
841389 CO     school 804530 980   HARRISON 2 80453000669 6686 PANORAMA MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 35 22 90   6 7     0   5   92 73                       165 35 22 90   6 7     0   5   92 73                 165
1138899 CO     school 804530 980   HARRISON 2 80453006425 469 ATLAS PREPARATORY SCHOOL   Regular School Yes 4.0 05 10 2015   grade_8 13.0 33.0 85.0   2.0 0.0     0.0   4.0   71.0 66.0                       137.0 13 33 85   2 0     0   4   71 66                 137
1138911 CO     school 804530 980   HARRISON 2 80453000662 1306 CARMEL MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 26.0 36.0 60.0   3.0 3.0     2.0   7.0   67.0 70.0                       137.0 26 36 60   3 3     2   7   67 70                 137
1138929 CO     school 804530 980   HARRISON 2 80453000666 3522 FOX MEADOW MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 31.0 29.0 64.0   3.0 2.0     2.0   10.0   69.0 72.0                       141.0 31 29 64   3 2     2   10   69 72                 141
1138939 CO     school 804530 980   HARRISON 2 80453006535 3870 HIGH SCHOOL PREPARATORY ACADEMY   Regular School No 3.0 08 12 2015   grade_8 3.0 8.0 12.0   0.0 0.0     0.0   0.0   15.0 8.0                       23.0 3 8 12   0 0     0   0   15 8                 23
1138948 CO     school 804530 980   HARRISON 2 80453001964 4379 JAMES IRWIN CHARTER MIDDLE SCHOOL   Regular School Yes 2.0 06 08 2015   grade_8 55.0 13.0 54.0   0.0 10.0     1.0   8.0   67.0 74.0                       141.0 55 13 54   0 10     1   8   67 74                 141
1138972 CO     school 804530 980   HARRISON 2 80453001903 6162 MOUNTAIN VISTA COMMUNITY SCHOOL   Regular School No 1.0 PK 08 2015   grade_8 27.0 15.0 43.0   0.0 1.0     1.0   4.0   34.0 57.0                       91.0 27 15 43   0 1     1   4   34 57                 91
1138991 CO     school 804530 980   HARRISON 2 80453000669 6686 PANORAMA MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 37.0 42.0 74.0   2.0 9.0     2.0   12.0   101.0 77.0                       178.0 37 42 74   2 9     2   12   101 77                 178
1744151 CO     school 804530 980   Harrison 2 80453006691 369 Atlas Preparatory Middle School   Regular School Yes Middle 05 08 2021   grade_8 8 11 139   1 0     1   5   86 79                       165 8 11 139   1 0     1   5   86 79                 165
1744167 CO     school 804530 980   Harrison 2 80453000662 1306 Carmel Middle School   Regular School No Middle 06 08 2021   grade_8 17 26 61   1 2     0   5   60 52                       112 17 26 61   1 2     0   5   60 52                 112
1744185 CO     school 804530 980   Harrison 2 80453000666 3522 Fox Meadow Middle School   Regular School No Middle 06 08 2021   grade_8 45 38 79   2 3     0   20   107 80                       187 45 38 79   2 3     0   20   107 80                 187
1744203 CO     school 804530 980   Harrison 2 80453001964 4379 James Irwin Charter Middle School   Regular School Yes Middle 06 08 2021   grade_8 42 8 75   0 2     1   12   50 90                       140 42 8 75   0 2     1   12   50 90                 140
1744222 CO     school 804530 980   Harrison 2 80453006663 5763 Mountain Vista Homeschool Academy   Regular School No Other KG 12 2021   grade_8 25 0 4   0 0     0   3   15 17                       32 25 0 4   0 0     0   3   15 17                 32
1744244 CO     school 804530 980   Harrison 2 80453001903 6162 Mountain Vista Community School   Regular School No Elementary PK 08 2021   grade_8 20 14 45   0 3     0   5   44 43                       87 20 14 45   0 3     0   5   44 43                 87
1744263 CO     school 804530 980   Harrison 2 80453000669 6686 Panorama Middle School   Regular School No Middle 06 08 2021   grade_8 33 40 117   1 8     2   19   119 101                       220 33 40 117   1 8     2   19   119 101                 220
1805235 CO     school 804530 980   Harrison 2 80453006691 369 Atlas Preparatory Middle School   Regular School Yes Middle 05 08 2020   grade_8 17 9 119   1 2     0   7   77 78                       155 17 9 119   1 2     0   7   77 78                 155
1805251 CO     school 804530 980   Harrison 2 80453000662 1306 Carmel Middle School   Regular School No Middle 06 08 2020   grade_8 22 17 61   1 2     0   12   57 58                       115 22 17 61   1 2     0   12   57 58                 115
1805269 CO     school 804530 980   Harrison 2 80453000666 3522 Fox Meadow Middle School   Regular School No Middle 06 08 2020   grade_8 45 23 94   0 2     2   20   105 81                       186 45 23 94   0 2     2   20   105 81                 186
1805287 CO     school 804530 980   Harrison 2 80453001964 4379 James Irwin Charter Middle School   Regular School Yes Middle 06 08 2020   grade_8 41 13 82   1 4     2   9   76 76                       152 41 13 82   1 4     2   9   76 76                 152
1805306 CO     school 804530 980   Harrison 2 80453006663 5763 Mountain Vista Homeschool Academy   Regular School No Other KG 12 2020   grade_8 22 0 8   1 0     0   1   17 15                       32 22 0 8   1 0     0   1   17 15                 32
1805324 CO     school 804530 980   Harrison 2 80453001903 6162 Mountain Vista Community School   Regular School No Elementary PK 08 2020   grade_8 21 9 53   1 3     0   8   51 44                       95 21 9 53   1 3     0   8   51 44                 95
1805343 CO     school 804530 980   Harrison 2 80453000669 6686 Panorama Middle School   Regular School No Middle 06 08 2020   grade_8 41 39 91   2 3     2   12   110 80                       190 41 39 91   2 3     2   12   110 80                 190
1899577 CO     school 804530 980   HARRISON 2 80453006691 369 ATLAS PREPARATORY MIDDLE SCHOOL   Regular School Yes Middle 05 08 2018   grade_8 15 16 136   0 1     2   6   100 76                       176 15 16 136   0 1     2   6   100 76                 176
1899593 CO     school 804530 980   HARRISON 2 80453000662 1306 CARMEL MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_8 18 11 67   0 4     1   4   64 41                       105 18 11 67   0 4     1   4   64 41                 105
1899611 CO     school 804530 980   HARRISON 2 80453000666 3522 FOX MEADOW MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_8 60 26 89   4 6     3   15   93 110                       203 60 26 89   4 6     3   15   93 110                 203
1899629 CO     school 804530 980   HARRISON 2 80453001964 4379 JAMES IRWIN CHARTER MIDDLE SCHOOL   Regular School Yes Middle 06 08 2018   grade_8 45 15 59   2 12     1   3   63 74                       137 45 15 59   2 12     1   3   63 74                 137
1899648 CO     school 804530 980   HARRISON 2 80453006663 5763 MOUNTAIN VISTA HOMESCHOOL ACADEMY   Regular School No Other KG 12 2018   grade_8 13 0 4   0 0     0   0   7 10                       17 13 0 4   0 0     0   0   7 10                 17
1899666 CO     school 804530 980   HARRISON 2 80453001903 6162 MOUNTAIN VISTA COMMUNITY SCHOOL   Regular School No Elementary PK 08 2018   grade_8 17 13 59   1 2     2   3   60 37                       97 17 13 59   1 2     2   3   60 37                 97
1899685 CO     school 804530 980   HARRISON 2 80453000669 6686 PANORAMA MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_8 28 29 66   1 8     2   9   71 72                       143 28 29 66   1 8     2   9   71 72                 143
1936952 CO     school 804530 980   HARRISON 2 80453006691 369 ATLAS PREPARATORY MIDDLE SCHOOL   Regular School Yes Middle 05 08 2019   grade_8 12 11 117   1 2     1   7   65 86                       151 12 11 117   1 2     1   7   65 86                 151
1936968 CO     school 804530 980   HARRISON 2 80453000662 1306 CARMEL MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_8 24 27 54   0 4     0   13   64 58                       122 24 27 54   0 4     0   13   64 58                 122
1936986 CO     school 804530 980   HARRISON 2 80453000666 3522 FOX MEADOW MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_8 56 32 94   3 2     2   11   112 88                       200 56 32 94   3 2     2   11   112 88                 200
1937004 CO     school 804530 980   HARRISON 2 80453001964 4379 JAMES IRWIN CHARTER MIDDLE SCHOOL   Regular School Yes Middle 06 08 2019   grade_8 61 12 53   2 3     1   12   66 78                       144 61 12 53   2 3     1   12   66 78                 144
1937023 CO     school 804530 980   HARRISON 2 80453006663 5763 MOUNTAIN VISTA HOMESCHOOL ACADEMY   Regular School No Other KG 12 2019   grade_8 18 0 2   0 0     0   0   10 10                       20 18 0 2   0 0     0   0   10 10                 20
1937041 CO     school 804530 980   HARRISON 2 80453001903 6162 MOUNTAIN VISTA COMMUNITY SCHOOL   Regular School No Elementary PK 08 2019   grade_8 15 11 51   0 1     3   4   48 37                       85 15 11 51   0 1     3   4   48 37                 85
1937060 CO     school 804530 980   HARRISON 2 80453000669 6686 PANORAMA MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_8 32 37 90   2 3     0   12   93 83                       176 32 37 90   2 3     0   12   93 83                 176
713654 CO     school 802730 970   CALHAN RJ-1 80273000510 1215 CALHAN MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_8 37 4 2   0 0     0   1   18 26                       44 37 4 2   0 0     0   1   18 26                 44
841271 CO     school 802730 970   CALHAN RJ-1 80273000510 1215 CALHAN MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_8 30 4 4   0 0     0   0   21 17                       38 30 4 4   0 0     0   0   21 17                 38
1138888 CO     school 802730 970   CALHAN RJ-1 80273000510 1215 CALHAN MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_8 30.0 1.0 1.0   0.0 0.0     0.0   0.0   17.0 15.0                       32.0 30 1 1   0 0     0   0   17 15                 32
1744145 CO     school 802730 970   Calhan RJ-1 80273000168 1218 Calhan Secondary School   Regular School No High 06 12 2021   grade_8 26 2 4   0 0     0   0   16 16                       32 26 2 4   0 0     0   0   16 16                 32
1805225 CO     school 802730 970   Calhan RJ-1 80273000510 1215 Calhan Middle School   Regular School No Middle 06 08 2020   grade_8 26 3 8   0 1     0   0   20 18                       38 26 3 8   0 1     0   0   20 18                 38
1899567 CO     school 802730 970   CALHAN RJ-1 80273000510 1215 CALHAN MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_8 25 4 5   0 0     0   1   17 18                       35 25 4 5   0 0     0   1   17 18                 35
1936942 CO     school 802730 970   CALHAN RJ-1 80273000510 1215 CALHAN MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_8 33 0 4   0 1     0   1   24 15                       39 33 0 4   0 1     0   1   24 15                 39
1744129 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2021   grade_8 0 0 2   0 0     0   0   1 1                       2 0 0 2   0 0     0   0   1 1                 2
1805212 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2020   grade_8 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1936929 CO     school 801980 960   AGATE 300 80198000021 48 AGATE JUNIOR SENIOR HIGH SCHOOL   Regular School No High 06 12 2019   grade_8 5 0 0   0 0     0   0   4 1                       5 5 0 0   0 0     0   0   4 1                 5
713636 CO     school 803690 950   ELBERT 200 80369000481 2574 ELBERT JUNIOR-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_8 24 0 3   1 0     0   0   18 10                       28 24 0 3   1 0     0   0   18 10                 28
841255 CO     school 803690 950   ELBERT 200 80369000481 2574 ELBERT JUNIOR-SENIOR HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_8 10 0 1   1 1     0   0   6 7                       13 10 0 1   1 1     0   0   6 7                 13
1138869 CO     school 803690 950   ELBERT 200 80369000481 2574 ELBERT JUNIOR-SENIOR HIGH SCHOOL   Regular School No 4.0 06 12 2015   grade_8 23.0 0.0 0.0   0.0 0.0     0.0   2.0   8.0 17.0                       25.0 23 0 0   0 0     0   2   8 17                 25
1744114 CO     school 803690 950   Elbert 200 80369000481 2574 Elbert Junior-Senior High School   Regular School No High 06 12 2021   grade_8 14 0 2   0 0     0   0   11 5                       16 14 0 2   0 0     0   0   11 5                 16
1805198 CO     school 803690 950   Elbert 200 80369000481 2574 Elbert Junior-Senior High School   Regular School No High 06 12 2020   grade_8 23 0 2   0 0     0   2   14 13                       27 23 0 2   0 0     0   2   14 13                 27
1899549 CO     school 803690 950   ELBERT 200 80369000481 2574 ELBERT JUNIOR-SENIOR HIGH SCHOOL   Regular School No High 06 12 2018   grade_8 23 0 0   0 0     0   0   12 11                       23 23 0 0   0 0     0   0   12 11                 23

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