Data source: Big Local News · About: Big Local

4,236 rows where grade = "grade_7" and state = "CO" sorted by district descending

View and edit SQL

year

grade

  • grade_7 · 4,236
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
1751019 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2021   grade_7 25 0 44   0 0     0   0   31 38                       69 25 0 44   0 0     0   0   31 38                 69
1812133 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2020   grade_7 37 0 34   0 0     0   0   34 37                       71 37 0 34   0 0     0   0   34 37                 71
720558 CO     school 800016 3200   YUMA 1 80001601819 9791 YUMA MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_7 23 1 36   0 0     0   0   28 32                       60 23 1 36   0 0     0   0   28 32                 60
848125 CO     school 800016 3200   YUMA 1 80001601819 9791 YUMA MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_7 40 0 33   0 0     0   0   45 28                       73 40 0 33   0 0     0   0   45 28                 73
1145693 CO     school 800016 3200   YUMA 1 80001601819 9791 YUMA MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 15.0 0.0 30.0   0.0 0.0     0.0   0.0   23.0 22.0                       45.0 15 0 30   0 0     0   0   23 22                 45
1906506 CO     school 800016 3200   YUMA 1 80001601819 9791 YUMA MIDDLE SCHOOL   Regular School No Middle 05 08 2018   grade_7 27 0 29   0 0     0   1   31 26                       57 27 0 29   0 0     0   1   31 26                 57
1943879 CO     school 800016 3200   YUMA 1 80001601819 9791 YUMA MIDDLE SCHOOL   Regular School No Middle 05 08 2019   grade_7 31 0 36   0 0     0   1   32 36                       68 31 0 36   0 0     0   1   32 36                 68
1751045 CO     school 800017 3210   Wray RD-2 80001701818 9733 Wray Junior Senior High School   Regular School No High 07 12 2021   grade_7 33 0 15   0 0     0   0   22 26                       48 33 0 15   0 0     0   0   22 26                 48
1812156 CO     school 800017 3210   Wray RD-2 80001701817 9729 Buchanan Middle School   Regular School No Middle 05 08 2020   grade_7 33 0 20   1 0     0   0   27 27                       54 33 0 20   1 0     0   0   27 27                 54
1750429 CO     school 807410 3070   Woodlin R-104 80741001271 9704 Woodlin Undivided High School   Regular School No High 06 12 2021   grade_7 5 0 0   0 0     0   0   0 5                       5 5 0 0   0 0     0   0   0 5                 5
1811556 CO     school 807410 3070   Woodlin R-104 80741001271 9704 Woodlin Undivided High School   Regular School No High 06 12 2020   grade_7 7 0 1   0 0     0   0   3 5                       8 7 0 1   0 0     0   0   3 5                 8
1750337 CO     school 807380 3020   Woodland Park Re-2 80738001268 9694 Woodland Park Middle School   Regular School No Middle 06 08 2021   grade_7 129 1 17   0 0     0   4   87 64                       151 129 1 17   0 0     0   4   87 64                 151
1811464 CO     school 807380 3020   Woodland Park Re-2 80738001268 9694 Woodland Park Middle School   Regular School No Middle 06 08 2020   grade_7 159 1 21   0 0     0   11   104 88                       192 159 1 21   0 0     0   11   104 88                 192
1750552 CO     school 807350 3100   Windsor RE-4 80735006427 7755 Severance Middle School   Regular School No Middle 06 08 2021   grade_7 139 3 39   2 1     1   5   103 87                       190 139 3 39   2 1     1   5   103 87                 190
1750588 CO     school 807350 3100   Windsor RE-4 80735006782 9563 Windsor Charter Academy Middle School   Regular School Yes Middle 06 08 2021   grade_7 94 1 14   0 2     0   3   60 54                       114 94 1 14   0 2     0   3   60 54                 114
1750599 CO     school 807350 3100   Windsor RE-4 80735001265 9670 Windsor Middle School   Regular School No Middle 06 08 2021   grade_7 190 1 29   0 0     0   7   120 107                       227 190 1 29   0 0     0   7   120 107                 227
1750611 CO     school 807350 3100   Windsor RE-4 80735006812 9671 Inspire4 K-12 Online School   Regular School No Other KG 12 2021   grade_7 36 0 19   0 2     0   0   28 29                       57 36 0 19   0 2     0   0   28 29                 57
1811679 CO     school 807350 3100   Windsor RE-4 80735006427 7755 Severance Middle School   Regular School No Middle 06 08 2020   grade_7 162 2 51   0 2     0   5   120 102                       222 162 2 51   0 2     0   5   120 102                 222
1811715 CO     school 807350 3100   Windsor RE-4 80735006782 9563 Windsor Charter Academy Middle School   Regular School Yes Middle 06 08 2020   grade_7 102 1 22   0 3     0   6   70 64                       134 102 1 22   0 3     0   6   70 64                 134
1811727 CO     school 807350 3100   Windsor RE-4 80735001265 9670 Windsor Middle School   Regular School No Middle 06 08 2020   grade_7 189 2 35   0 1     0   4   113 118                       231 189 2 35   0 1     0   4   113 118                 231
1749495 CO     school 807320 2680   Wiley RE-13 Jt 80732001261 9608 Wiley Junior-Senior High School   Regular School No High 06 12 2021   grade_7 10 0 3   0 0     0   1   6 8                       14 10 0 3   0 0     0   1   6 8                 14
1810627 CO     school 807320 2680   Wiley RE-13 Jt 80732001261 9608 Wiley Junior-Senior High School   Regular School No High 06 12 2020   grade_7 17 0 4   0 0     0   0   12 9                       21 17 0 4   0 0     0   0   12 9                 21
1749153 CO     school 807290 2515   Wiggins RE-50(J) 80729006394 9263 Wiggins Middle School   Regular School No Middle 07 08 2021   grade_7 38 0 20   0 0     0   2   28 32                       60 38 0 20   0 0     0   2   28 32                 60
1810292 CO     school 807290 2515   Wiggins RE-50(J) 80729006394 9263 Wiggins Middle School   Regular School No Middle 07 08 2020   grade_7 36 1 15   0 0     0   3   27 28                       55 36 1 15   0 0     0   3   27 28                 55
1744334 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2021   grade_7 48 18 25   0 3     3   12   47 62                       109 48 18 25   0 3     3   12   47 62                 109
1744347 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2021   grade_7 106 15 63   1 3     4   24   112 104                       216 106 15 63   1 3     4   24   112 104                 216
1744356 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2021   grade_7 3 0 4   0 0     0   1   7 1                       8 3 0 4   0 0     0   1   7 1                 8
1744388 CO     school 806480 990   Widefield 3 80648001125 8178 Sproul Junior High School   Regular School No Middle 06 08 2021   grade_7 94 14 70   1 4     3   19   105 100                       205 94 14 70   1 4     3   19   105 100                 205
1744399 CO     school 806480 990   Widefield 3 80648001126 9294 Watson Junior High School   Regular School No Middle 06 08 2021   grade_7 82 18 61   1 3     0   22   94 93                       187 82 18 61   1 3     0   22   94 93                 187
1805413 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   grade_7 42 10 27   2 3     4   8   52 44                       96 42 10 27   2 3     4   8   52 44                 96
1805426 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2020   grade_7 86 25 83   0 1     3   34   124 108                       232 86 25 83   0 1     3   34   124 108                 232
1805435 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2020   grade_7 4 1 5   0 0     1   2   11 2                       13 4 1 5   0 0     1   2   11 2                 13
1805467 CO     school 806480 990   Widefield 3 80648001125 8178 Sproul Junior High School   Regular School No Middle 06 08 2020   grade_7 89 16 53   0 4     4   28   100 94                       194 89 16 53   0 4     4   28   100 94                 194
1805478 CO     school 806480 990   Widefield 3 80648001126 9294 Watson Junior High School   Regular School No Middle 06 08 2020   grade_7 83 23 60   0 0     1   28   90 105                       195 83 23 60   0 0     1   28   90 105                 195
1739090 CO     school 807230 70   Westminster Public Schools 80723001232 1622 Metropolitan Arts Academy   Regular School No Elementary PK 07 2021   grade_7 4 1 27   0 0     0   0   18 14                       32 4 1 27   0 0     0   0   18 14                 32
1739122 CO     school 807230 70   Westminster Public Schools 80723006567 4334 Colorado STEM Academy   Regular School No Elementary PK 08 2021   grade_7 21 1 42   1 5     0   2   36 36                       72 21 1 42   1 5     0   2   36 36                 72
1739133 CO     school 807230 70   Westminster Public Schools 80723006373 4465 Josephine Hodgkins Leadership Academy   Regular School No Elementary PK 07 2021   grade_7 8 1 61   0 0     1   0   37 34                       71 8 1 61   0 0     1   0   37 34                 71
1739143 CO     school 807230 70   Westminster Public Schools 80723001241 5388 Colorado Sports Leadership Academy   Regular School No Elementary KG 08 2021   grade_7 8 0 86   0 1     0   0   50 45                       95 8 0 86   0 1     0   0   50 45                 95
1739156 CO     school 807230 70   Westminster Public Schools 80723006458 7305 Iver C. Ranum Middle School   Regular School No Middle 06 08 2021   grade_7 15 1 126   0 5     0   3   78 72                       150 15 1 126   0 5     0   3   78 72                 150
1739165 CO     school 807230 70   Westminster Public Schools 80723001363 7810 John E. Flynn A Marzano Academy   Regular School No Elementary PK 07 2021   grade_7 2 0 13   0 0     0   0   9 6                       15 2 0 13   0 0     0   0   9 6                 15
1739170 CO     school 807230 70   Westminster Public Schools 80723001244 7812 Shaw Heights Middle School   Regular School No Middle 06 08 2021   grade_7 26 7 132   2 8     0   4   95 84                       179 26 7 132   2 8     0   4   95 84                 179
1739204 CO     school 807230 70   Westminster Public Schools 80723001249 8798 Tennyson Knolls Preparatory School   Regular School No Elementary PK 08 2021   grade_7 2 0 19   0 2     0   0   14 9                       23 2 0 19   0 2     0   0   14 9                 23
1739215 CO     school 807230 70   Westminster Public Schools 80723006675 9236 Westminster Academy for International Studies   Regular School No Elementary PK 08 2021   grade_7 2 0 29   0 0     0   0   13 18                       31 2 0 29   0 0     0   0   13 18                 31
1800191 CO     school 807230 70   Westminster Public Schools 80723006567 4334 Colorado STEM Academy   Regular School No Elementary PK 08 2020   grade_7 17 1 35   1 1     0   2   31 26                       57 17 1 35   1 1     0   2   31 26                 57
1800206 CO     school 807230 70   Westminster Public Schools 80723001241 5388 M. Scott Carpenter Middle School   Regular School No Middle 06 08 2020   grade_7 9 2 130   0 1     2   2   84 62                       146 9 2 130   0 1     2   2   84 62                 146
1800218 CO     school 807230 70   Westminster Public Schools 80723006458 7305 Iver C. Ranum Middle School   Regular School No Middle 06 08 2020   grade_7 15 3 185   2 5     2   6   118 100                       218 15 3 185   2 5     2   6   118 100                 218
1800231 CO     school 807230 70   Westminster Public Schools 80723001244 7812 Shaw Heights Middle School   Regular School No Middle 06 08 2020   grade_7 32 10 128   2 12     0   7   99 92                       191 32 10 128   2 12     0   7   99 92                 191
1800272 CO     school 807230 70   Westminster Public Schools 80723006675 9236 Westminster Academy for International Studies   Regular School No Elementary PK 08 2020   grade_7 2 0 17   0 2     0   0   12 9                       21 2 0 17   0 2     0   0   12 9                 21
1745965 CO     school 805070 1340   West Grand 1-JT 80507000829 9422 West Grand Elementary and Middle School   Regular School No Elementary KG 08 2021   grade_7 18 0 9   1 0     0   0   10 18                       28 18 0 9   1 0     0   0   10 18                 28
1807053 CO     school 805070 1340   West Grand 1-JT 80507000829 9422 West Grand Elementary and Middle School   Regular School No Elementary KG 08 2020   grade_7 32 0 11   0 0     0   1   23 21                       44 32 0 11   0 0     0   1   23 21                 44
1749060 CO     school 805850 2190   West End RE-2 80585006727 6307 Nucla Middle School   Regular School No Middle 07 08 2021   grade_7 20 0 1   0 0     0   0   13 8                       21 20 0 1   0 0     0   0   13 8                 21
1749074 CO     school 805850 2190   West End RE-2 80585001693 6718 Paradox Valley Charter School   Regular School Yes Other PK 12 2021   grade_7 5 0 0   0 0     0   0   3 2                       5 5 0 0   0 0     0   0   3 2                 5
1810199 CO     school 805850 2190   West End RE-2 80585006727 6307 Nucla Middle School   Regular School No Middle 07 08 2020   grade_7 10 1 1   0 0     0   1   7 6                       13 10 1 1   0 0     0   1   7 6                 13
1749149 CO     school 807140 2505   Weldon Valley RE-20(J) 80714001218 9360 Weldon Valley Jr/Sr High School   Regular School No High 07 12 2021   grade_7 19 0 1   0 0     0   0   9 11                       20 19 0 1   0 0     0   0   9 11                 20
1810288 CO     school 807140 2505   Weldon Valley RE-20(J) 80714001218 9360 Weldon Valley Jr/Sr High School   Regular School No High 07 12 2020   grade_7 15 1 0   0 0     0   0   8 8                       16 15 1 0   0 0     0   0   8 8                 16
1750917 CO     school 804020 3140   Weld Re-8 Schools 80402000553 3066 Fort Lupton Middle School   Regular School No Middle 06 08 2021   grade_7 26 0 116   1 0     0   3   73 73                       146 26 0 116   1 0     0   3   73 73                 146
1750938 CO     school 804020 3140   Weld Re-8 Schools 80402006606 7219 Kenneth Homyak PK-8   Regular School No Elementary PK 08 2021   grade_7 9 0 7   0 0     0   1   8 9                       17 9 0 7   0 0     0   1   8 9                 17
1812031 CO     school 804020 3140   Weld Re-8 Schools 80402000553 3066 Fort Lupton Middle School   Regular School No Middle 06 08 2020   grade_7 25 1 142   0 0     0   1   99 70                       169 25 1 142   0 0     0   1   99 70                 169
1812052 CO     school 804020 3140   Weld Re-8 Schools 80402006606 7219 Kenneth Homyak PK-8   Regular School No Elementary PK 08 2020   grade_7 12 0 7   0 0     0   0   10 9                       19 12 0 7   0 0     0   0   10 9                 19
1750500 CO     school 804920 3090   Weld County School District RE-3J 80492001760 1299 Cardinal Community Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_7 18 0 2   0 0     0   0   13 7                       20 18 0 2   0 0     0   0   13 7                 20
1750535 CO     school 804920 3090   Weld County School District RE-3J 80492002026 9347 Weld Central Middle School   Regular School No Middle 06 08 2021   grade_7 81 1 99   2 0     0   2   103 82                       185 81 1 99   2 0     0   2   103 82                 185
1811627 CO     school 804920 3090   Weld County School District RE-3J 80492001760 1299 Cardinal Community Academy Charter School   Regular School Yes Elementary KG 08 2020   grade_7 17 0 2   0 0     0   1   14 6                       20 17 0 2   0 0     0   1   14 6                 20
1811662 CO     school 804920 3090   Weld County School District RE-3J 80492002026 9347 Weld Central Middle School   Regular School No Middle 06 08 2020   grade_7 82 2 96   0 2     0   2   99 85                       184 82 2 96   0 2     0   2   99 85                 184
1750450 CO     school 804200 3080   Weld County RE-1 80420000577 4854 North Valley Middle School   Regular School No Middle 06 08 2021   grade_7 23 0 45   0 1     0   2   38 33                       71 23 0 45   0 1     0   2   38 33                 71
1750462 CO     school 804200 3080   Weld County RE-1 80420000579 7058 South Valley Middle School   Regular School No Middle 06 08 2021   grade_7 21 0 41   0 0     0   2   27 37                       64 21 0 41   0 0     0   2   27 37                 64
1811577 CO     school 804200 3080   Weld County RE-1 80420000577 4854 North Valley Middle School   Regular School No Middle 06 08 2020   grade_7 30 0 42   1 0     0   0   42 31                       73 30 0 42   1 0     0   0   42 31                 73
1811589 CO     school 804200 3080   Weld County RE-1 80420000579 7058 South Valley Middle School   Regular School No Middle 06 08 2020   grade_7 29 0 43   0 0     0   1   32 41                       73 29 0 43   0 0     0   1   32 41                 73
1740566 CO     school 807110 230   Walsh RE-1 80711001216 9226 Walsh High School   Regular School No High 07 12 2021   grade_7 10 0 2   0 0     0   1   5 8                       13 10 0 2   0 0     0   1   5 8                 13
1801597 CO     school 807110 230   Walsh RE-1 80711001216 9226 Walsh High School   Regular School No High 07 12 2020   grade_7 5 0 4   0 0     0   0   4 5                       9 5 0 4   0 0     0   0   4 5                 9
720581 CO     school 800017 3210   WRAY RD-2 80001701817 9729 BUCHANAN MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_7 34 0 16   0 0     0   0   25 25                       50 34 0 16   0 0     0   0   25 25                 50
848148 CO     school 800017 3210   WRAY RD-2 80001701817 9729 BUCHANAN MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_7 34 2 17   0 0     0   2   29 26                       55 34 2 17   0 0     0   2   29 26                 55
1145716 CO     school 800017 3210   WRAY RD-2 80001701817 9729 BUCHANAN MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_7 26.0 0.0 12.0   0.0 0.0     0.0   1.0   25.0 14.0                       39.0 26 0 12   0 0     0   1   25 14                 39
1906529 CO     school 800017 3210   WRAY RD-2 80001701817 9729 BUCHANAN MIDDLE SCHOOL   Regular School No Middle 05 08 2018   grade_7 40 0 12   1 0     0   1   32 22                       54 40 0 12   1 0     0   1   32 22                 54
1943902 CO     school 800017 3210   WRAY RD-2 80001701817 9729 BUCHANAN MIDDLE SCHOOL   Regular School No Middle 05 08 2019   grade_7 50 0 11   0 0     0   0   23 38                       61 50 0 11   0 0     0   0   23 38                 61
719984 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 6 0 1   0 0     0   0   2 5                       7 6 0 1   0 0     0   0   2 5                 7
847554 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_7 10 0 1   0 0     0   0   5 6                       11 10 0 1   0 0     0   0   5 6                 11
1145125 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No 3.0 07 12 2015   grade_7 5.0 0.0 0.0   0.0 0.0     0.0   0.0   2.0 3.0                       5.0 5 0 0   0 0     0   0   2 3                 5
1905929 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2018   grade_7 4 0 3   0 0     0   0   3 4                       7 4 0 3   0 0     0   0   3 4                 7
1943304 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2019   grade_7 5 0 1   0 0     0   0   4 2                       6 5 0 1   0 0     0   0   4 2                 6
719892 CO     school 807380 3020   WOODLAND PARK RE-2 80738001268 9694 WOODLAND PARK MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 159 0 21   1 0     0   11   117 75                       192 159 0 21   1 0     0   11   117 75                 192
847462 CO     school 807380 3020   WOODLAND PARK RE-2 80738001268 9694 WOODLAND PARK MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 174 3 13   0 0     0   16   100 106                       206 174 3 13   0 0     0   16   100 106                 206
1145033 CO     school 807380 3020   WOODLAND PARK RE-2 80738001268 9694 WOODLAND PARK MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 164.0 3.0 16.0   0.0 3.0     0.0   6.0   112.0 80.0                       192.0 164 3 16   0 3     0   6   112 80                 192
1905837 CO     school 807380 3020   WOODLAND PARK RE-2 80738001268 9694 WOODLAND PARK MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 164 3 19   1 1     0   7   103 92                       195 164 3 19   1 1     0   7   103 92                 195
1943212 CO     school 807380 3020   WOODLAND PARK RE-2 80738001268 9694 WOODLAND PARK MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 143 4 17   1 0     0   7   89 83                       172 143 4 17   1 0     0   7   89 83                 172
720111 CO     school 807350 3100   WINDSOR RE-4 80735006427 7755 SEVERANCE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 127 0 34   2 1     0   2   75 91                       166 127 0 34   2 1     0   2   75 91                 166
720141 CO     school 807350 3100   WINDSOR RE-4 80735006650 9393 WINDSOR CHARTER ACADEMY MIDDLE AND EARLY COLLEGE HIGH SCHOOL   Regular School Yes Other 06 11 2017   grade_7 94 0 7   0 4     0   2   47 60                       107 94 0 7   0 4     0   2   47 60                 107
720154 CO     school 807350 3100   WINDSOR RE-4 80735001265 9670 WINDSOR MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_7 182 1 38   0 3     0   9   132 101                       233 182 1 38   0 3     0   9   132 101                 233
847679 CO     school 807350 3100   WINDSOR RE-4 80735006427 7755 SEVERANCE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 137 0 31   0 0     0   4   78 94                       172 137 0 31   0 0     0   4   78 94                 172
847708 CO     school 807350 3100   WINDSOR RE-4 80735006650 9393 WINDSOR CHARTER ACADEMY MIDDLE AND EARLY COLLEGE HIGH SCHOOL   Regular School Yes 4.0 06 10 2016   grade_7 56 0 8   0 2     0   1   29 38                       67 56 0 8   0 2     0   1   29 38                 67
847721 CO     school 807350 3100   WINDSOR RE-4 80735001265 9670 WINDSOR MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_7 165 2 27   1 1     0   3   106 93                       199 165 2 27   1 1     0   3   106 93                 199
1145249 CO     school 807350 3100   WINDSOR RE-4 80735006427 7755 SEVERANCE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 125.0 0.0 23.0   1.0 2.0     0.0   4.0   88.0 67.0                       155.0 125 0 23   1 2     0   4   88 67                 155
1145282 CO     school 807350 3100   WINDSOR RE-4 80735001815 9665 WINDSOR CHARTER ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_7 36.0 0.0 3.0   0.0 3.0     0.0   4.0   12.0 34.0                       46.0 36 0 3   0 3     0   4   12 34                 46
1145288 CO     school 807350 3100   WINDSOR RE-4 80735001265 9670 WINDSOR MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_7 181.0 0.0 30.0   0.0 3.0     0.0   4.0   112.0 106.0                       218.0 181 0 30   0 3     0   4   112 106                 218
1906054 CO     school 807350 3100   WINDSOR RE-4 80735006427 7755 SEVERANCE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 144 0 41   0 1     0   2   94 94                       188 144 0 41   0 1     0   2   94 94                 188
1906085 CO     school 807350 3100   WINDSOR RE-4 80735006650 9393 WINDSOR CHARTER ACADEMY MIDDLE AND EARLY COLLEGE HIGH SCHOOL   Regular School Yes High 06 12 2018   grade_7 83 0 7   0 0     0   2   43 49                       92 83 0 7   0 0     0   2   43 49                 92
1906098 CO     school 807350 3100   WINDSOR RE-4 80735001265 9670 WINDSOR MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_7 153 3 36   2 1     0   5   101 99                       200 153 3 36   2 1     0   5   101 99                 200
1943427 CO     school 807350 3100   WINDSOR RE-4 80735006427 7755 SEVERANCE MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 151 1 42   0 5     0   5   117 87                       204 151 1 42   0 5     0   5   117 87                 204
1943458 CO     school 807350 3100   WINDSOR RE-4 80735006650 9393 WINDSOR CHARTER ACADEMY MIDDLE AND EARLY COLLEGE HIGH SCHOOL   Regular School Yes High 06 12 2019   grade_7 83 1 15   0 4     0   4   51 56                       107 83 1 15   0 4     0   4   51 56                 107
1943471 CO     school 807350 3100   WINDSOR RE-4 80735001265 9670 WINDSOR MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_7 191 0 29   0 3     0   9   135 97                       232 191 0 29   0 3     0   9   135 97                 232
719071 CO     school 807320 2680   WILEY RE-13 JT 80732001261 9608 WILEY JUNIOR-SENIOR HIGH SCHOOL   Regular School No Other 06 12 2017   grade_7 14 0 6   0 0     0   0   6 14                       20 14 0 6   0 0     0   0   6 14                 20

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