Data source: Big Local News · About: Big Local

634 rows where grade = "grade_7", state = "CO" and year = 2021 sorted by district_state_id

View and edit SQL

year

  • 2021 · 634

grade

  • grade_7 · 634
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
1738265 CO     school 805550 10   Mapleton 1 80555001857 187 Mapleton Expeditionary School of the Arts   Regular School No High 07 12 2021   grade_7 9 0 64   0 2     0   3   28 50                       78 9 0 64   0 2     0   3   28 50                 78
1738290 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2021   grade_7 6 2 39   0 2     0   2   20 31                       51 6 2 39   0 2     0   2   20 31                 51
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
1738323 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   grade_7 2 2 58   0 1     0   3   33 33                       66 2 2 58   0 1     0   3   33 33                 66
1738333 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Pk-8   Regular School No Elementary PK 08 2021   grade_7 0 0 12   2 1     0   0   7 8                       15 0 0 12   2 1     0   0   7 8                 15
1738352 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2021   grade_7 9 3 56   0 1     0   0   37 32                       69 9 3 56   0 1     0   0   37 32                 69
1738370 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_7 141 16 46   2 3     0   16   128 96                       224 141 16 46   2 3     0   16   128 96                 224
1738380 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2021   grade_7 4 0 64   0 0     0   1   35 34                       69 4 0 64   0 0     0   1   35 34                 69
1738397 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_7 7 0 57   0 0     0   1   33 32                       65 7 0 57   0 0     0   1   33 32                 65
1739228 CO     school 802070 100   Alamosa RE-11J 80207000026 114 Ortega Middle School   Regular School No Middle 06 08 2021   grade_7 28 0 92   1 0     1   0   64 58                       122 28 0 92   1 0     1   0   64 58                 122
1739249 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_7 9 2 34   2 1     0   2   27 23                       50 9 2 34   2 1     0   2   27 23                 50
1744433 CO     school 804080 1000   Fountain 8 80408000561 1332 Carson Middle School   Regular School No Middle 06 08 2021   grade_7 110 32 50   1 2     5   24   116 108                       224 110 32 50   1 2     5   24   116 108                 224
1744460 CO     school 804080 1000   Fountain 8 80408000563 3106 Fountain Middle School   Regular School No Middle 06 08 2021   grade_7 183 31 86   5 7     10   47   187 182                       369 183 31 86   5 7     10   47   187 182                 369
1744510 CO     school 803060 1010   Colorado Springs 11 80306006428 269 Achieve Online   Alternative School No High 06 12 2021   grade_7 16 1 5   0 0     1   2   13 12                       25 16 1 5   0 0     1   2   13 12                 25
1744528 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2021   grade_7 23 1 5   1 0     1   2   16 17                       33 23 1 5   1 0     1   2   16 17                 33
1744619 CO     school 803060 1010   Colorado Springs 11 80306000232 2528 Nikola Tesla Education Opportunity Center   Alternative School No High 06 12 2021   grade_7 1 0 2   0 0     0   0   2 1                       3 1 0 2   0 0     0   0   2 1                 3
1744640 CO     school 803060 1010   Colorado Springs 11 80306006379 3360 Galileo School of Math and Science   Regular School No Middle 06 08 2021   grade_7 47 22 57   0 2     1   7   66 70                       136 47 22 57   0 2     1   7   66 70                 136
1744675 CO     school 803060 1010   Colorado Springs 11 80306000241 4070 Holmes Middle School   Regular School No Middle 06 08 2021   grade_7 124 9 43   0 4     0   19   122 77                       199 124 9 43   0 4     0   19   122 77                 199
1744679 CO     school 803060 1010   Colorado Springs 11 80306000242 4090 Mann Middle School   Regular School No Middle 06 08 2021   grade_7 70 8 34   1 1     0   14   65 63                       128 70 8 34   1 1     0   14   65 63                 128
1744699 CO     school 803060 1010   Colorado Springs 11 80306001683 4424 Jenkins Middle School   Regular School No Middle 06 08 2021   grade_7 162 27 56   0 2     1   29   152 125                       277 162 27 56   0 2     1   29   152 125                 277
1744768 CO     school 803060 1010   Colorado Springs 11 80306000256 6306 North Middle School   Regular School No Middle 06 08 2021   grade_7 79 18 75   2 5     0   22   80 121                       201 79 18 75   2 5     0   22   80 121                 201
1744807 CO     school 803060 1010   Colorado Springs 11 80306000263 7523 Russell Middle School   Regular School No Middle 06 08 2021   grade_7 95 17 61   0 4     1   13   99 92                       191 95 17 61   0 4     1   13   99 92                 191
1744811 CO     school 803060 1010   Colorado Springs 11 80306000234 7556 Sabin Middle School   Regular School No Middle 06 08 2021   grade_7 111 16 99   0 6     1   28   147 114                       261 111 16 99   0 6     1   28   147 114                 261
1744838 CO     school 803060 1010   Colorado Springs 11 80306006421 8457 Jack Swigert Aerospace Academy   Regular School No Middle 06 08 2021   grade_7 49 18 88   1 8     1   15   97 83                       180 49 18 88   1 8     1   15   97 83                 180
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
1744902 CO     school 802940 1020   Cheyenne Mountain 12 80294000209 1588 Cheyenne Mountain Junior High School   Regular School No Middle 07 08 2021   grade_7 209 3 43   0 13     2   15   139 146                       285 209 3 43   0 13     2   15   139 146                 285
1744944 CO     school 802940 1020   Cheyenne Mountain 12 80294006402 9051 The Vanguard School (Middle)   Regular School Yes Middle 07 08 2021   grade_7 66 2 32   0 10     0   11   54 67                       121 66 2 32   0 10     0   11   54 67                 121
1744961 CO     school 805490 1030   Manitou Springs 14 80549000945 5464 Manitou Springs Middle School   Regular School No Middle 06 08 2021   grade_7 80 1 9   0 0     0   7   43 54                       97 80 1 9   0 0     0   7   43 54                 97
1744993 CO     school 801920 1040   Academy 20 80192000001 74 Challenger Middle School   Regular School No Middle 06 08 2021   grade_7 137 3 28   2 13     0   19   107 95                       202 137 3 28   2 13     0   19   107 95                 202
1745009 CO     school 801920 1040   Academy 20 80192000858 209 Aspen Valley Campus   Alternative School No High 07 12 2021   grade_7 8 0 0   0 0     0   1   7 2                       9 8 0 0   0 0     0   1   7 2                 9
1745024 CO     school 801920 1040   Academy 20 80192006788 1421 Chinook Trail Middle School   Regular School No Middle 06 08 2021   grade_7 199 5 38   1 26     0   26   152 143                       295 199 5 38   1 26     0   26   152 143                 295
1745036 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2021   grade_7 24 3 3   0 0     0   1   16 15                       31 24 3 3   0 0     0   1   16 15                 31
1745056 CO     school 801920 1040   Academy 20 80192001931 1629 The Classical Academy Middle School   Regular School Yes Middle 07 08 2021   grade_7 161 7 23   0 6     1   14   101 111                       212 161 7 23   0 6     1   14   101 111                 212
1745070 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2021   grade_7 18 0 3   0 0     0   0   9 12                       21 18 0 3   0 0     0   0   9 12                 21
1745075 CO     school 801920 1040   Academy 20 80192006616 1921 Discovery Canyon Campus Middle School   Regular School No Middle 06 08 2021   grade_7 176 12 32   0 15     1   14   122 128                       250 176 12 32   0 15     1   14   122 128                 250
1745099 CO     school 801920 1040   Academy 20 80192001402 2358 Eagleview Middle School   Regular School No Middle 06 08 2021   grade_7 224 10 54   1 7     0   25   151 170                       321 224 10 54   1 7     0   25   151 170                 321
1745147 CO     school 801920 1040   Academy 20 80192001593 6140 Mountain Ridge Middle School   Regular School No Middle 06 08 2021   grade_7 185 9 60   0 13     3   20   141 149                       290 185 9 60   0 13     3   20   141 149                 290
1745164 CO     school 801920 1040   Academy 20 80192006745 6242 New Summit Charter Academy   Regular School Yes Elementary KG 08 2021   grade_7 35 2 4   0 3     0   2   22 24                       46 35 2 4   0 3     0   2   22 24                 46
1745219 CO     school 801920 1040   Academy 20 80192006447 8779 TCA College Pathways   Regular School Yes High 07 12 2021   grade_7 42 2 5   0 2     0   5   32 24                       56 42 2 5   0 2     0   5   32 24                 56
1745232 CO     school 801920 1040   Academy 20 80192001462 8851 Timberview Middle School   Regular School No Middle 06 08 2021   grade_7 228 9 56   1 6     0   25   164 161                       325 228 9 56   1 6     0   25   164 161                 325
1745252 CO     school 803750 1050   Ellicott 22 80375001735 2640 Ellicott Middle School   Regular School No Middle 06 08 2021   grade_7 42 1 24   2 0     0   4   40 33                       73 42 1 24   2 0     0   4   40 33                 73
1745263 CO     school 806060 1060   Peyton 23 Jt 80606006692 6626 Peyton Online Academy   Regular School No Other KG 12 2021   grade_7 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1745280 CO     school 806060 1060   Peyton 23 Jt 80606001399 6900 Peyton Junior High School   Regular School No Middle 07 08 2021   grade_7 40 2 7   0 0     0   2   28 23                       51 40 2 7   0 0     0   2   28 23                 51
1745292 CO     school 804500 1070   Hanover 28 80450000661 3758 Hanover Junior-Senior High School   Regular School No High 06 12 2021   grade_7 24 2 1   0 0     0   0   13 14                       27 24 2 1   0 0     0   0   13 14                 27
1745299 CO     school 804500 1070   Hanover 28 80450006720 3941 Hanover Online Academy   Regular School No High 06 12 2021   grade_7 2 0 0   0 0     0   0   1 1                       2 2 0 0   0 0     0   0   1 1                 2
1745340 CO     school 805820 1080   Lewis-Palmer 38 80582001536 5093 Monument Charter Academy Secondary School   Regular School Yes Middle 06 09 2021   grade_7 103 2 11   1 2     0   10   70 59                       129 103 2 11   1 2     0   10   70 59                 129
1745353 CO     school 805820 1080   Lewis-Palmer 38 80582001002 5098 Lewis-Palmer Middle School   Regular School No Middle 07 08 2021   grade_7 302 8 39   1 7     0   22   208 171                       379 302 8 39   1 7     0   22   208 171                 379
1739270 CO     school 806420 110   Sangre De Cristo Re-22J 80642001116 7630 Sangre de Cristo Undivided High School   Regular School No High 06 12 2021   grade_7 13 0 5   2 0     0   0   13 7                       20 13 0 5   2 0     0   0   13 7                 20
1745398 CO     school 803870 1110   District 49 80387006778 431 Falcon Homeschool Program   Regular School No Other KG 12 2021   grade_7 51 1 8   0 0     0   6   42 24                       66 51 1 8   0 0     0   6   42 24                 66
1745411 CO     school 803870 1110   District 49 80387006785 448 Rocky Mountain Classical Academy Homeschool   Regular School No Other KG 12 2021   grade_7 26 1 3   0 1     0   1   15 17                       32 26 1 3   0 1     0   1   15 17                 32
1745432 CO     school 803870 1110   District 49 80387002027 555 Banning Lewis Ranch Academy   Regular School Yes Other KG 12 2021   grade_7 77 9 39   1 5     0   11   69 73                       142 77 9 39   1 5     0   11   69 73                 142
1745460 CO     school 803870 1110   District 49 80387006462 2877 Springs Studio for Academic Excellence   Regular School No Other KG 12 2021   grade_7 29 1 9   1 0     0   5   22 23                       45 29 1 9   1 0     0   5   22 23                 45
1745472 CO     school 803870 1110   District 49 80387000506 2906 Falcon Middle School   Regular School No Middle 06 08 2021   grade_7 173 14 67   2 9     0   30   159 136                       295 173 14 67   2 9     0   30   159 136                 295
1745486 CO     school 803870 1110   District 49 80387001393 4102 Horizon Middle School   Regular School No Middle 06 08 2021   grade_7 121 17 74   0 6     0   33   113 138                       251 121 17 74   0 6     0   33   113 138                 251
1745495 CO     school 803870 1110   District 49 80387006386 4251 Grand Peak Academy   Regular School Yes Elementary KG 08 2021   grade_7 35 0 18   0 2     0   2   29 28                       57 35 0 18   0 2     0   2   29 28                 57
1745514 CO     school 803870 1110   District 49 80387006744 5191 Liberty Tree Academy   Regular School Yes Other KG 10 2021   grade_7 46 0 8   0 0     0   3   30 27                       57 46 0 8   0 0     0   3   30 27                 57
1745539 CO     school 803870 1110   District 49 80387006693 6653 Power Technical Early College   Career and Technical School Yes High 06 12 2021   grade_7 32 1 11   0 0     0   5   40 9                       49 32 1 11   0 0     0   5   40 9                 49
1745559 CO     school 803870 1110   District 49 80387001844 6935 Pikes Peak School Expeditionary Learning   Regular School Yes Elementary KG 08 2021   grade_7 37 1 6   0 0     0   4   24 24                       48 37 1 6   0 0     0   4   24 24                 48
1745585 CO     school 803870 1110   District 49 80387002000 7463 Rocky Mountain Classical Academy   Regular School Yes Elementary KG 08 2021   grade_7 75 3 19   2 1     0   10   57 53                       110 75 3 19   2 1     0   10   57 53                 110
1745595 CO     school 803870 1110   District 49 80387001799 7960 Skyview Middle School   Regular School No Middle 06 08 2021   grade_7 179 21 79   2 18     0   38   170 167                       337 179 21 79   2 18     0   38   170 167                 337
1745644 CO     school 803630 1120   Edison 54 JT 80363001278 2526 Edison Junior-Senior High School   Regular School No High 06 12 2021   grade_7 8 0 0   0 0     0   0   5 3                       8 8 0 0   0 0     0   0   5 3                 8
1745660 CO     school 805670 1130   Miami/Yoder 60 JT 80567000972 5854 Miami-Yoder Middle/High School   Regular School No High 06 12 2021   grade_7 11 0 6   0 0     0   0   6 11                       17 11 0 6   0 0     0   0   6 11                 17
1745665 CO     school 802790 1140   Canon City RE-1 80279000171 1262 Canon City Middle School   Regular School No Middle 06 08 2021   grade_7 92 0 20   0 1     0   7   54 66                       120 92 0 20   0 1     0   7   54 66                 120
1745679 CO     school 802790 1140   Canon City RE-1 80279000173 3802 Harrison School   Regular School No Elementary KG 08 2021   grade_7 51 1 9   0 0     1   2   33 31                       64 51 1 9   0 0     1   2   33 31                 64
1745704 CO     school 802790 1140   Canon City RE-1 80279001538 6752 Mount View Core Knowledge Charter School   Regular School Yes Elementary PK 08 2021   grade_7 19 0 5   0 1     0   2   17 10                       27 19 0 5   0 1     0   2   17 10                 27
1745714 CO     school 802790 1140   Canon City RE-1 80279001433 7950 Canon Exploratory School   Regular School No Elementary KG 08 2021   grade_7 20 0 2   0 0     0   0   16 6                       22 20 0 2   0 0     0   0   16 6                 22
1745728 CO     school 803960 1150   Fremont RE-2 80396000514 3002 Florence Jr./Sr. High School   Regular School No High 07 12 2021   grade_7 94 0 17   1 0     0   6   59 59                       118 94 0 17   1 0     0   6   59 59                 118
1745762 CO     school 803120 1160   Cotopaxi RE-3 80312000277 3228 Cotopaxi Junior-Senior High School   Regular School No High 06 12 2021   grade_7 15 0 1   0 0     0   0   5 11                       16 15 0 1   0 0     0   0   5 11                 16
1745772 CO     school 804260 1180   Roaring Fork RE-1 80426001505 429 Carbondale Community Charter School   Regular School Yes Elementary KG 08 2021   grade_7 13 0 1   0 0     0   0   6 8                       14 13 0 1   0 0     0   0   6 8                 14
1745785 CO     school 804260 1180   Roaring Fork RE-1 80426000133 561 Basalt Middle School   Regular School No Middle 05 08 2021   grade_7 41 0 76   0 0     0   5   57 65                       122 41 0 76   0 0     0   5   57 65                 122
1745800 CO     school 804260 1180   Roaring Fork RE-1 80426000586 1296 Carbondale Middle School   Regular School No Middle 05 08 2021   grade_7 40 2 57   0 0     0   2   55 46                       101 40 2 57   0 0     0   2   55 46                 101
1745821 CO     school 804260 1180   Roaring Fork RE-1 80426000587 3464 Glenwood Springs Middle School   Regular School No Middle 06 08 2021   grade_7 47 0 82   1 1     0   4   64 71                       135 47 0 82   1 1     0   4   64 71                 135
1745835 CO     school 804260 1180   Roaring Fork RE-1 80426006715 7298 Riverview School   Regular School No Elementary PK 08 2021   grade_7 4 0 24   0 0     0   0   15 13                       28 4 0 24   0 0     0   0   15 13                 28
1745892 CO     school 806240 1195   Garfield Re-2 80624001096 7356 Rifle Middle School   Regular School No Middle 06 08 2021   grade_7 83 0 110   1 2     1   5   107 95                       202 83 0 110   1 2     1   5   107 95                 202
1745901 CO     school 806240 1195   Garfield Re-2 80624001098 7388 Riverside School   Regular School No Middle 06 08 2021   grade_7 77 1 75   1 0     0   3   80 77                       157 77 1 75   1 0     0   3   80 77                 157
1739309 CO     school 803780 120   Englewood 1 80378001772 2750 Englewood Leadership Academy   Regular School No Middle 06 09 2021   grade_7 18 1 7   0 1     1   0   14 14                       28 18 1 7   0 1     1   0   14 14                 28
1739312 CO     school 803780 120   Englewood 1 80378006331 2752 Englewood Middle School   Regular School No Middle 07 08 2021   grade_7 54 5 55   0 1     0   5   57 63                       120 54 5 55   0 1     0   5   57 63                 120
1745935 CO     school 804380 1220   Garfield 16 80438001368 8274 Grand Valley Middle School   Regular School No Middle 06 08 2021   grade_7 51 0 38   0 0     1   4   42 52                       94 51 0 38   0 0     1   4   42 52                 94
1739333 CO     school 806540 123   Sheridan 2 80654001135 7837 Fort Logan Northgate   Regular School No Middle 03 08 2021   grade_7 10 7 80   2 2     0   2   48 55                       103 10 7 80   2 2     0   2   48 55                 103
1739357 CO     school 802910 130   Cherry Creek 5 80291001711 18 Liberty Middle School   Regular School No Middle 06 08 2021   grade_7 178 34 61   1 35     1   33   189 154                       343 178 34 61   1 35     1   33   189 154                 343
1739369 CO     school 802910 130   Cherry Creek 5 80291001878 141 Sky Vista Middle School   Regular School No Middle 06 08 2021   grade_7 146 49 57   0 28     0   41   165 156                       321 146 49 57   0 28     0   41   165 156                 321
1739373 CO     school 802910 130   Cherry Creek 5 80291006770 188 Colorado Skies Academy   Regular School Yes Middle 06 08 2021   grade_7 64 3 8   0 5     0   5   65 20                       85 64 3 8   0 5     0   5   65 20                 85
1739431 CO     school 802910 130   Cherry Creek 5 80291006791 1429 Cherry Creek Elevation   Regular School No High 06 12 2021   grade_7 3 1 0   0 0     0   0   3 1                       4 3 1 0   0 0     0   0   3 1                 4
1739441 CO     school 802910 130   Cherry Creek 5 80291000763 1510 Challenge School   Regular School No Elementary PK 08 2021   grade_7 27 15 6   1 15     1   7   35 37                       72 27 15 6   1 15     1   7   35 37                 72
1739451 CO     school 802910 130   Cherry Creek 5 80291000185 1566 Campus Middle School   Regular School No Middle 06 08 2021   grade_7 292 18 61   2 74     1   37   231 254                       485 292 18 61   2 74     1   37   231 254                 485
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
1739469 CO     school 802910 130   Cherry Creek 5 80291001152 1571 Cherry Creek Charter Academy   Regular School Yes Elementary KG 08 2021   grade_7 22 6 5   0 16     0   3   28 24                       52 22 6 5   0 16     0   3   28 24                 52
1739542 CO     school 802910 130   Cherry Creek 5 80291001672 2897 Falcon Creek Middle School   Regular School No Middle 06 08 2021   grade_7 160 27 58   5 25     1   27   153 150                       303 160 27 58   5 25     1   27   153 150                 303
1739546 CO     school 802910 130   Cherry Creek 5 80291006367 3030 Fox Ridge Middle School   Regular School No Middle 06 08 2021   grade_7 235 16 57   5 33     1   32   201 178                       379 235 16 57   5 33     1   32   201 178                 379
1739590 CO     school 802910 130   Cherry Creek 5 80291001328 4100 Horizon Middle School   Regular School No Middle 06 08 2021   grade_7 103 54 116   2 13     1   20   173 136                       309 103 54 116   2 13     1   20   173 136                 309
1739599 CO     school 802910 130   Cherry Creek 5 80291006676 4189 Heritage Heights Academy   Regular School Yes Elementary KG 08 2021   grade_7 9 5 6   0 4     0   0   11 13                       24 9 5 6   0 4     0   0   11 13                 24
1739631 CO     school 802910 130   Cherry Creek 5 80291000197 4975 Laredo Middle School   Regular School No Middle 06 08 2021   grade_7 129 62 97   5 25     0   29   177 170                       347 129 62 97   5 25     0   29   177 170                 347
1739667 CO     school 802910 130   Cherry Creek 5 80291006563 6367 Options School   Alternative School No Other KG 12 2021   grade_7 40 0 8   0 2     0   7   26 31                       57 40 0 8   0 2     0   7   26 31                 57
1739710 CO     school 802910 130   Cherry Creek 5 80291000201 7158 Prairie Middle School   Regular School No Middle 06 08 2021   grade_7 97 130 187   2 24     3   44   243 244                       487 97 130 187   2 24     3   44   243 244                 487
1739729 CO     school 802910 130   Cherry Creek 5 80291006728 7514 Infinity Middle School   Regular School No Middle 06 08 2021   grade_7 169 19 36   0 25     0   25   137 137                       274 169 19 36   0 25     0   25   137 137                 274
1739762 CO     school 802910 130   Cherry Creek 5 80291000034 8848 Thunder Ridge Middle School   Regular School No Middle 06 08 2021   grade_7 195 40 96   2 25     2   29   194 195                       389 195 40 96   2 25     2   29   194 195                 389
1745950 CO     school 804230 1330   Gilpin County RE-1 80423001298 1634 Gilpin County Undivided High School   Regular School No High 06 12 2021   grade_7 31 0 6   0 0     0   2   16 23                       39 31 0 6   0 0     0   2   16 23                 39
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
1745970 CO     school 804320 1350   East Grand 2 80432001343 2376 East Grand Middle School   Regular School No Middle 06 08 2021   grade_7 87 1 17   2 0     0   3   65 45                       110 87 1 17   2 0     0   3   65 45                 110
1746005 CO     school 804470 1360   Gunnison Watershed RE1J 80447000655 2006 Crested Butte Secondary School   Regular School No High 06 12 2021   grade_7 71 0 2   0 1     0   2   41 35                       76 71 0 2   0 1     0   2   41 35                 76

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