enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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 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 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
1738303 1738303 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2021   grade_7 10 2 65   0 3     0   0   44 36                       80 10 2 65   0 3     0   0   44 36                 80
1799360 1799360 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_7 5 1 50   0 1     0   1   28 30                       58 5 1 50   0 1     0   1   28 30                 58
720558 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 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 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 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 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
848472 848472 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001612 9785 YOUTH & FAMILY ACADEMY CHARTER   Alternative Education School Yes 3.0 07 12 2016   grade_7 2 0 7   0 0     0   0   2 7                       9 2 0 7   0 0     0   0   2 7                 9
1146020 1146020 CO     school 800020 8001   CHARTER SCHOOL INSTITUTE 80002001612 9785 YOUTH & FAMILY ACADEMY CHARTER   Alternative Education School Yes 3.0 07 12 2015   grade_7 1.0 0.0 9.0   0.0 0.0     0.0   0.0   5.0 5.0                       10.0 1 0 9   0 0     0   0   5 5                 10
707872 707872 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2017   grade_7 13 0 42   0 2     0   1   26 32                       58 13 0 42   0 2     0   1   26 32                 58
835552 835552 CO     school   10   MAPLETON 1   503 YORK INTERNATIONAL             2016   grade_7 7 0 42   0 2     0   3   29 25                       54 7 0 42   0 2     0   3   29 25                 54
1133275 1133275 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No 4.0 KG 12 2015   grade_7 9.0 1.0 51.0   0.0 1.0     0.0   2.0   31.0 33.0                       64.0 9 1 51   0 1     0   2   31 33                 64
1893735 1893735 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2018   grade_7 8 0 48   1 4     0   2   31 32                       63 8 0 48   1 4     0   2   31 32                 63
1931007 1931007 CO     school 805550 10   MAPLETON 1 80555002017 503 YORK INTERNATIONAL   Regular School No Other KG 12 2019   grade_7 8 1 49   0 2     0   1   33 28                       61 8 1 49   0 2     0   1   33 28                 61
1751045 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
1743886 1743886 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2021   grade_7 23 0 5   0 2     0   4   15 19                       34 23 0 5   0 2     0   4   15 19                 34
1804960 1804960 CO     school 803450 900   Douglas County Re 1 80345006666 9397 World Compass Academy   Regular School Yes Elementary PK 08 2020   grade_7 36 0 9   0 2     0   3   20 30                       50 36 0 9   0 2     0   3   20 30                 50
1744025 1744025 CO     school 803540 910   Eagle County RE 50 80354006533 9701 World Academy   Regular School No Other KG 12 2021   grade_7 3 0 1   0 0     0   0   1 3                       4 3 0 1   0 0     0   0   1 3                 4
1805105 1805105 CO     school 803540 910   Eagle County RE 50 80354006533 9701 World Academy   Regular School No Other KG 12 2020   grade_7 4 0 0   0 0     0   0   1 3                       4 4 0 0   0 0     0   0   1 3                 4
1747247 1747247 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2021   grade_7 37 0 10   0 1     0   6   28 26                       54 37 0 10   0 1     0   6   28 26                 54
1808359 1808359 CO     school 804800 1420   Jefferson County R-1 80480001807 9427 Woodrow Wilson Charter Academy   Regular School Yes Elementary PK 08 2020   grade_7 45 0 9   0 1     0   1   31 25                       56 45 0 9   0 1     0   1   31 25                 56
1750429 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 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 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 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
1750676 1750676 CO     school 804410 3120   Greeley 6 80441001989 53 Winograd K-8 Elementary School   Regular School No Elementary KG 08 2021   grade_7 25 0 50   0 1     0   2   51 27                       78 25 0 50   0 1     0   2   51 27                 78
1811790 1811790 CO     school 804410 3120   Greeley 6 80441001989 53 Winograd K-8 Elementary School   Regular School No Elementary KG 08 2020   grade_7 28 0 40   0 0     0   0   27 41                       68 28 0 40   0 0     0   0   27 41                 68
1750599 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
1811727 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
1750588 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
1811715 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
1743159 1743159 CO     school 803360 880   Denver County 1 80336006332 9623 William (Bill) Roberts ECE-8 School   Regular School No Elementary PK 08 2021   grade_7 56 11 3   0 1     0   6   33 44                       77 56 11 3   0 1     0   6   33 44                 77
1804189 1804189 CO     school 803360 880   Denver County 1 80336006332 9623 William (Bill) Roberts ECE-8 School   Regular School No Elementary PK 08 2020   grade_7 44 7 13   0 0     0   4   40 28                       68 44 7 13   0 0     0   4   40 28                 68
1749495 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 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 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 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
1743148 1743148 CO     school 803360 880   Denver County 1 80336000426 9548 Whittier ECE-8 School   Regular School No Elementary PK 08 2021   grade_7 1 6 12   0 0     0   1   12 8                       20 1 6 12   0 0     0   1   12 8                 20
1804178 1804178 CO     school 803360 880   Denver County 1 80336000426 9548 Whittier ECE-8 School   Regular School No Elementary PK 08 2020   grade_7 0 8 18   0 0     0   3   12 17                       29 0 8 18   0 0     0   3   12 17                 29
1741071 1741071 CO     school 805370 470   St Vrain Valley RE1J 80537006198 9430 Westview Middle School   Regular School No Middle 06 08 2021   grade_7 177 1 41   1 2     0   7   129 100                       229 177 1 41   1 2     0   7   129 100                 229
1802104 1802104 CO     school 805370 470   St Vrain Valley RE1J 80537006198 9430 Westview Middle School   Regular School No Middle 06 08 2020   grade_7 184 1 56   0 2     0   6   133 116                       249 184 1 56   0 2     0   6   133 116                 249
1739215 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
1800272 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
1738767 1738767 CO     school 806900 20   Adams 12 Five Star Schools 80690001194 9444 Westlake Middle School   Regular School No Middle 06 08 2021   grade_7 221 2 86   4 19     0   21   181 172                       353 221 2 86   4 19     0   21   181 172                 353
1799826 1799826 CO     school 806900 20   Adams 12 Five Star Schools 80690001194 9444 Westlake Middle School   Regular School No Middle 06 08 2020   grade_7 213 4 107   3 16     0   16   187 172                       359 213 4 107   3 16     0   16   187 172                 359
1738761 1738761 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2021   grade_7 26 1 10   0 4     0   3   23 21                       44 26 1 10   0 4     0   3   23 21                 44
1799820 1799820 CO     school 806900 20   Adams 12 Five Star Schools 80690006417 9431 Westgate Charter   Regular School Yes Other KG 12 2020   grade_7 35 4 5   0 5     0   1   32 18                       50 35 4 5   0 5     0   1   32 18                 50
1750896 1750896 CO     school 804410 3120   Greeley 6 80441006504 9611 West Ridge Academy   Regular School Yes Elementary KG 08 2021   grade_7 20 0 16   1 0     0   1   11 27                       38 20 0 16   1 0     0   1   11 27                 38
1812010 1812010 CO     school 804410 3120   Greeley 6 80441006504 9611 West Ridge Academy   Regular School Yes Elementary KG 08 2020   grade_7 26 1 16   0 0     1   2   30 16                       46 26 1 16   0 0     1   2   30 16                 46
1739455 1739455 CO     school 802910 130   Cherry Creek 5 80291000207 1568 West Middle School   Regular School No Middle 06 08 2021   grade_7 286 5 48   3 17     1   29   211 178                       389 286 5 48   3 17     1   29   211 178                 389
1744858 1744858 CO     school 803060 1010   Colorado Springs 11 80306000272 9404 West Middle School   Regular School No Middle 06 08 2021   grade_7 49 3 30   0 2     0   5   47 42                       89 49 3 30   0 2     0   5   47 42                 89
1748787 1748787 CO     school 804350 2000   Mesa County Valley 51 80435000629 9406 West Middle School   Regular School No Middle 06 08 2021   grade_7 84 2 30   1 3     0   5   62 63                       125 84 2 30   1 3     0   5   62 63                 125
1800502 1800502 CO     school 802910 130   Cherry Creek 5 80291000207 1568 West Middle School   Regular School No Middle 06 08 2020   grade_7 283 11 50   3 39     1   26   224 189                       413 283 11 50   3 39     1   26   224 189                 413
1805948 1805948 CO     school 803060 1010   Colorado Springs 11 80306000272 9404 West Middle School   Regular School No Middle 06 08 2020   grade_7 39 4 28   0 0     0   4   39 36                       75 39 4 28   0 0     0   4   39 36                 75
1809929 1809929 CO     school 804350 2000   Mesa County Valley 51 80435000629 9406 West Middle School   Regular School No Middle 06 08 2020   grade_7 79 0 27   0 2     0   4   48 64                       112 79 0 27   0 2     0   4   48 64                 112
1743181 1743181 CO     school 803360 880   Denver County 1 80336006547 9702 West Leadership Academy   Regular School No High 06 12 2021   grade_7 2 4 50   0 0     0   1   33 24                       57 2 4 50   0 0     0   1   33 24                 57
1804211 1804211 CO     school 803360 880   Denver County 1 80336006547 9702 West Leadership Academy   Regular School No High 06 12 2020   grade_7 6 9 67   0 0     0   2   40 44                       84 6 9 67   0 0     0   2   40 44                 84
1747253 1747253 CO     school 804800 1420   Jefferson County R-1 80480000795 9428 West Jefferson Middle School   Regular School No Middle 06 08 2021   grade_7 138 0 26   0 0     0   4   92 76                       168 138 0 26   0 0     0   4   92 76                 168
1808366 1808366 CO     school 804800 1420   Jefferson County R-1 80480000795 9428 West Jefferson Middle School   Regular School No Middle 06 08 2020   grade_7 193 0 13   2 5     0   6   119 100                       219 193 0 13   2 5     0   6   119 100                 219
1745965 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 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
1743173 1743173 CO     school 803360 880   Denver County 1 80336006551 9693 West Early College   Regular School No High 06 12 2021   grade_7 5 11 62   1 3     0   0   40 42                       82 5 11 62   1 3     0   0   40 42                 82
1804203 1804203 CO     school 803360 880   Denver County 1 80336006551 9693 West Early College   Regular School No High 06 12 2020   grade_7 5 9 65   2 2     0   2   46 39                       85 5 9 65   2 2     0   2   46 39                 85
1747954 1747954 CO     school 803990 1550   Poudre R-1 80399000551 9374 Wellington Middle School   Regular School No Middle 06 08 2021   grade_7 126 1 26   1 1     0   3   85 73                       158 126 1 26   1 1     0   3   85 73                 158
1809087 1809087 CO     school 803990 1550   Poudre R-1 80399000551 9374 Wellington Middle School   Regular School No Middle 06 08 2020   grade_7 157 2 35   1 0     0   7   104 98                       202 157 2 35   1 0     0   7   104 98                 202
1749149 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 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
1750535 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
1811662 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
1747941 1747941 CO     school 803990 1550   Poudre R-1 80399006162 9330 Webber Middle School   Regular School No Middle 06 08 2021   grade_7 218 2 40   1 1     1   11   143 131                       274 218 2 40   1 1     1   11   143 131                 274
1809074 1809074 CO     school 803990 1550   Poudre R-1 80399006162 9330 Webber Middle School   Regular School No Middle 06 08 2020   grade_7 190 6 53   2 3     0   9   138 125                       263 190 6 53   2 3     0   9   138 125                 263
1747206 1747206 CO     school 804800 1420   Jefferson County R-1 80480002036 9299 Wayne Carle Middle School   Regular School No Middle 06 08 2021   grade_7 142 0 31   0 4     0   5   88 94                       182 142 0 31   0 4     0   5   88 94                 182
1808316 1808316 CO     school 804800 1420   Jefferson County R-1 80480002036 9299 Wayne Carle Middle School   Regular School No Middle 06 08 2020   grade_7 148 2 36   1 4     2   11   94 110                       204 148 2 36   1 4     2   11   94 110                 204
1744399 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
1805478 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
1748173 1748173 CO     school 805400 1560   Thompson R2-J 80540001286 9228 Walt Clark Middle School   Regular School No Middle 06 08 2021   grade_7 104 0 29   1 2     0   6   81 61                       142 104 0 29   1 2     0   6   81 61                 142
1809311 1809311 CO     school 805400 1560   Thompson R2-J 80540001286 9228 Walt Clark Middle School   Regular School No Middle 06 08 2020   grade_7 149 1 17   6 0     0   3   93 83                       176 149 1 17   6 0     0   3   93 83                 176
1740566 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 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
1898573 1898573 CO     school 803360 880   DENVER COUNTY 1 80336006737 9753 WYATT ACADEMY MIDDLE SCHOOL   Regular School Yes Middle 06 08 2018   grade_7 2 8 32   0 0     0   1   21 22                       43 2 8 32   0 0     0   1   21 22                 43
712659 712659 CO     school 803360 880   DENVER COUNTY 1 80336001637 9739 WYATT ACADEMY   Regular School Yes Elementary KG 08 2017   grade_7 1 13 44   0 0     0   1   27 32                       59 1 13 44   0 0     0   1   27 32                 59
840288 840288 CO     school 803360 880   DENVER COUNTY 1 80336001637 9739 WYATT ACADEMY   Regular School Yes 1.0 KG 08 2016   grade_7 0 10 48   0 0     0   1   29 30                       59 0 10 48   0 0     0   1   29 30                 59
1137922 1137922 CO     school 803360 880   DENVER COUNTY 1 80336001637 9739 WYATT ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_7 1.0 16.0 37.0   0.0 0.0     0.0   2.0   27.0 29.0                       56.0 1 16 37   0 0     0   2   27 29                 56
713542 713542 CO     school 803540 910   EAGLE COUNTY RE 50 80354006533 9701 WORLD ACADEMY   Regular School No Other KG 12 2017   grade_7 5 0 0   0 0     0   0   3 2                       5 5 0 0   0 0     0   0   3 2                 5
841162 841162 CO     school 803540 910   EAGLE COUNTY RE 50 80354006533 9701 WORLD ACADEMY   Regular School No 4.0 KG 12 2016   grade_7 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1899456 1899456 CO     school 803540 910   EAGLE COUNTY RE 50 80354006533 9701 WORLD ACADEMY   Regular School No Other KG 12 2018   grade_7 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
1936822 1936822 CO     school 803540 910   EAGLE COUNTY RE 50 80354006533 9701 WORLD ACADEMY   Regular School No Other KG 12 2019   grade_7 1 0 2   0 0     0   0   0 3                       3 1 0 2   0 0     0   0   0 3                 3
1899307 1899307 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006666 9397 WORLD COMPASS ACADEMY   Regular School Yes Elementary PK 07 2018   grade_7 11 0 4   1 0     0   4   7 13                       20 11 0 4   1 0     0   4   7 13                 20
1936674 1936674 CO     school 803450 900   DOUGLAS COUNTY RE 1 80345006666 9397 WORLD COMPASS ACADEMY   Regular School Yes Elementary PK 08 2019   grade_7 39 0 6   0 0     0   1   18 28                       46 39 0 6   0 0     0   1   18 28                 46
716734 716734 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001807 9427 WOODROW WILSON CHARTER ACADEMY   Regular School Yes Elementary PK 08 2017   grade_7 39 1 9   0 1     0   2   27 25                       52 39 1 9   0 1     0   2   27 25                 52
844330 844330 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001807 9427 WOODROW WILSON CHARTER ACADEMY   Regular School Yes 1.0 PK 08 2016   grade_7 42 0 4   1 2     0   1   20 30                       50 42 0 4   1 2     0   1   20 30                 50
1141911 1141911 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001807 9427 WOODROW WILSON CHARTER ACADEMY   Regular School Yes 1.0 PK 08 2015   grade_7 46.0 0.0 7.0   1.0 0.0     0.0   2.0   20.0 36.0                       56.0 46 0 7   1 0     0   2   20 36                 56
1902670 1902670 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001807 9427 WOODROW WILSON CHARTER ACADEMY   Regular School Yes Elementary PK 08 2018   grade_7 43 0 3   0 2     0   3   27 24                       51 43 0 3   0 2     0   3   27 24                 51
1940042 1940042 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480001807 9427 WOODROW WILSON CHARTER ACADEMY   Regular School Yes Elementary PK 08 2019   grade_7 34 0 6   0 0     0   6   25 21                       46 34 0 6   0 0     0   6   25 21                 46
719984 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 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 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 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

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