Data source: Big Local News · About: Big Local

690 rows where grade = "grade_6", state = "CO" and year = 2020 sorted by district_state_id

View and edit SQL

year

  • 2020 · 690

grade

  • grade_6 · 690
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
1799335 CO     school 805550 10   Mapleton 1 80555002021 501 Monterey Community School   Regular School No Elementary KG 08 2020   grade_6 6 0 52   0 1     0   1   20 40                       60 6 0 52   0 1     0   1   20 40                 60
1799345 CO     school 805550 10   Mapleton 1 80555002031 502 Meadow Community School   Regular School No Elementary PK 08 2020   grade_6 7 2 46   0 3     0   2   24 36                       60 7 2 46   0 3     0   2   24 36                 60
1799359 CO     school 805550 10   Mapleton 1 80555002017 503 York International   Regular School No Other KG 12 2020   grade_6 6 2 50   0 2     0   0   32 28                       60 6 2 50   0 2     0   0   32 28                 60
1799370 CO     school 805550 10   Mapleton 1 80555001997 504 Welby Community School   Regular School No Elementary PK 06 2020   grade_6 4 0 22   1 1     0   0   11 17                       28 4 0 22   1 1     0   0   11 17                 28
1799379 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2020   grade_6 1 2 47   0 2     0   3   26 29                       55 1 2 47   0 2     0   3   26 29                 55
1799390 CO     school 805550 10   Mapleton 1 80555002007 506 Explore Elementary   Regular School No Elementary PK 06 2020   grade_6 16 1 39   2 1     1   0   28 32                       60 16 1 39   2 1     1   0   28 32                 60
1799399 CO     school 805550 10   Mapleton 1 80555001932 507 Adventure Elementary   Regular School No Elementary PK 06 2020   grade_6 4 0 52   1 1     0   1   29 30                       59 4 0 52   1 1     0   1   29 30                 59
1799408 CO     school 805550 10   Mapleton 1 80555002016 509 Clayton Partnership School   Regular School No Elementary KG 08 2020   grade_6 8 3 44   0 1     0   0   30 26                       56 8 3 44   0 1     0   0   30 26                 56
1799426 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2020   grade_6 99 12 37   1 2     0   4   88 67                       155 99 12 37   1 2     0   4   88 67                 155
1799434 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2020   grade_6 4 0 53   0 0     0   1   27 31                       58 4 0 53   0 0     0   1   27 31                 58
1799451 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2020   grade_6 10 0 48   0 0     0   1   27 32                       59 10 0 48   0 0     0   1   27 32                 59
1800284 CO     school 802070 100   Alamosa RE-11J 80207000026 114 Ortega Middle School   Regular School No Middle 06 08 2020   grade_6 48 3 124   2 1     1   1   91 89                       180 48 3 124   2 1     1   1   91 89                 180
1800303 CO     school 802070 100   Alamosa RE-11J 80207006508 368 Alamosa Ombudsman School of Excellence   Alternative School No High 06 12 2020   grade_6 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1805512 CO     school 804080 1000   Fountain 8 80408000561 1332 Carson Middle School   Regular School No Middle 06 08 2020   grade_6 131 39 58   4 6     9   28   139 136                       275 131 39 58   4 6     9   28   139 136                 275
1805538 CO     school 804080 1000   Fountain 8 80408000563 3106 Fountain Middle School   Regular School No Middle 06 08 2020   grade_6 199 38 87   4 6     11   42   197 190                       387 199 38 87   4 6     11   42   197 190                 387
1805588 CO     school 803060 1010   Colorado Springs 11 80306006428 269 Achieve Online   Alternative School No High 06 12 2020   grade_6 5 0 0   0 0     0   0   4 1                       5 5 0 0   0 0     0   0   4 1                 5
1805607 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2020   grade_6 25 1 6   1 0     1   2   16 20                       36 25 1 6   1 0     1   2   16 20                 36
1805630 CO     school 803060 1010   Colorado Springs 11 80306000225 1126 Buena Vista Elementary School   Regular School No Elementary PK 08 2020   grade_6 1 1 0   0 0     0   0   0 2                       2 1 1 0   0 0     0   0   0 2                 2
1805723 CO     school 803060 1010   Colorado Springs 11 80306006379 3360 Galileo School of Math and Science   Regular School No Middle 06 08 2020   grade_6 55 23 71   0 2     1   9   72 89                       161 55 23 71   0 2     1   9   72 89                 161
1805732 CO     school 803060 1010   Colorado Springs 11 80306001318 3470 Globe Charter School   Regular School Yes Elementary KG 06 2020   grade_6 9 0 4   0 0     0   2   8 7                       15 9 0 4   0 0     0   2   8 7                 15
1805759 CO     school 803060 1010   Colorado Springs 11 80306000241 4070 Holmes Middle School   Regular School No Middle 06 08 2020   grade_6 140 12 39   1 4     0   16   118 94                       212 140 12 39   1 4     0   16   118 94                 212
1805763 CO     school 803060 1010   Colorado Springs 11 80306000242 4090 Mann Middle School   Regular School No Middle 06 08 2020   grade_6 74 9 40   2 2     0   16   71 72                       143 74 9 40   2 2     0   16   71 72                 143
1805784 CO     school 803060 1010   Colorado Springs 11 80306001683 4424 Jenkins Middle School   Regular School No Middle 06 08 2020   grade_6 168 23 52   0 3     1   27   146 128                       274 168 23 52   0 3     1   27   146 128                 274
1805856 CO     school 803060 1010   Colorado Springs 11 80306000256 6306 North Middle School   Regular School No Middle 06 08 2020   grade_6 89 21 79   1 5     0   20   89 126                       215 89 21 79   1 5     0   20   89 126                 215
1805895 CO     school 803060 1010   Colorado Springs 11 80306000263 7523 Russell Middle School   Regular School No Middle 06 08 2020   grade_6 104 19 62   0 5     1   13   105 99                       204 104 19 62   0 5     1   13   105 99                 204
1805899 CO     school 803060 1010   Colorado Springs 11 80306000234 7556 Sabin Middle School   Regular School No Middle 06 08 2020   grade_6 125 17 99   0 4     1   32   148 130                       278 125 17 99   0 4     1   32   148 130                 278
1805927 CO     school 803060 1010   Colorado Springs 11 80306006421 8457 Jack Swigert Aerospace Academy   Regular School No Middle 06 08 2020   grade_6 58 18 89   1 6     1   22   104 91                       195 58 18 89   1 6     1   22   104 91                 195
1805947 CO     school 803060 1010   Colorado Springs 11 80306000272 9404 West Middle School   Regular School No Middle 06 08 2020   grade_6 57 2 27   2 2     0   6   53 43                       96 57 2 27   2 2     0   6   53 43                 96
1805979 CO     school 802940 1020   Cheyenne Mountain 12 80294001326 1582 The Vanguard School (Elementary)   Regular School Yes Elementary KG 06 2020   grade_6 58 2 28   0 11     1   9   49 60                       109 58 2 28   0 11     1   9   49 60                 109
1805988 CO     school 802940 1020   Cheyenne Mountain 12 80294001391 1586 Cheyenne Mountain Elementary School   Regular School No Elementary KG 06 2020   grade_6 39 1 4   0 3     0   3   20 30                       50 39 1 4   0 3     0   3   20 30                 50
1806004 CO     school 802940 1020   Cheyenne Mountain 12 80294000212 1592 Broadmoor Elementary School   Regular School No Elementary KG 06 2020   grade_6 38 0 4   0 3     1   3   22 27                       49 38 0 4   0 3     1   3   22 27                 49
1806014 CO     school 802940 1020   Cheyenne Mountain 12 80294000210 1604 Skyway Park Elementary School   Regular School No Elementary KG 06 2020   grade_6 27 1 14   0 0     0   3   22 23                       45 27 1 14   0 0     0   3   22 23                 45
1806022 CO     school 802940 1020   Cheyenne Mountain 12 80294001591 3482 Gold Camp Elementary School   Regular School No Elementary KG 06 2020   grade_6 58 2 10   0 3     0   2   34 41                       75 58 2 10   0 3     0   2   34 41                 75
1806030 CO     school 802940 1020   Cheyenne Mountain 12 80294001535 6953 Pinon Valley Elementary School   Regular School No Elementary KG 06 2020   grade_6 36 0 4   0 4     0   3   27 20                       47 36 0 4   0 4     0   3   27 20                 47
1806049 CO     school 805490 1030   Manitou Springs 14 80549000945 5464 Manitou Springs Middle School   Regular School No Middle 06 08 2020   grade_6 68 1 10   0 1     0   6   43 43                       86 68 1 10   0 1     0   6   43 43                 86
1806063 CO     school 805490 1030   Manitou Springs 14 80549000948 9010 Ute Pass Elementary School   Regular School No Elementary PK 06 2020   grade_6 16 0 4   0 0     0   2   12 10                       22 16 0 4   0 0     0   2   12 10                 22
1806082 CO     school 801920 1040   Academy 20 80192000001 74 Challenger Middle School   Regular School No Middle 06 08 2020   grade_6 139 3 24   2 14     1   18   108 93                       201 139 3 24   2 14     1   18   108 93                 201
1806113 CO     school 801920 1040   Academy 20 80192006788 1421 Chinook Trail Middle School   Regular School No Middle 06 08 2020   grade_6 199 7 35   1 28     0   26   150 146                       296 199 7 35   1 28     0   26   150 146                 296
1806125 CO     school 801920 1040   Academy 20 80192006775 1511 Home School Academy   Regular School No Other KG 12 2020   grade_6 43 2 7   0 0     0   4   28 28                       56 43 2 7   0 0     0   4   28 28                 56
1806144 CO     school 801920 1040   Academy 20 80192001592 1627 The Classical Academy Charter   Regular School Yes Elementary KG 06 2020   grade_6 207 8 29   0 8     1   17   131 139                       270 207 8 29   0 8     1   17   131 139                 270
1806160 CO     school 801920 1040   Academy 20 80192006478 1901 Journey K8   Regular School No Elementary KG 08 2020   grade_6 18 0 5   0 0     0   3   13 13                       26 18 0 5   0 0     0   3   13 13                 26
1806165 CO     school 801920 1040   Academy 20 80192006616 1921 Discovery Canyon Campus Middle School   Regular School No Middle 06 08 2020   grade_6 175 12 32   0 13     0   17   122 127                       249 175 12 32   0 13     0   17   122 127                 249
1806190 CO     school 801920 1040   Academy 20 80192001402 2358 Eagleview Middle School   Regular School No Middle 06 08 2020   grade_6 231 11 57   2 8     1   25   161 174                       335 231 11 57   2 8     1   25   161 174                 335
1806240 CO     school 801920 1040   Academy 20 80192001593 6140 Mountain Ridge Middle School   Regular School No Middle 06 08 2020   grade_6 192 9 56   0 12     3   17   146 143                       289 192 9 56   0 12     3   17   146 143                 289
1806257 CO     school 801920 1040   Academy 20 80192006745 6242 New Summit Charter Academy   Regular School Yes Elementary KG 08 2020   grade_6 48 4 9   0 2     0   4   28 39                       67 48 4 9   0 2     0   4   28 39                 67
1806327 CO     school 801920 1040   Academy 20 80192001462 8851 Timberview Middle School   Regular School No Middle 06 08 2020   grade_6 228 7 60   3 7     0   24   167 162                       329 228 7 60   3 7     0   24   167 162                 329
1806348 CO     school 803750 1050   Ellicott 22 80375001735 2640 Ellicott Middle School   Regular School No Middle 06 08 2020   grade_6 45 3 23   2 0     0   3   47 29                       76 45 3 23   2 0     0   3   47 29                 76
1806361 CO     school 806060 1060   Peyton 23 Jt 80606006692 6626 Peyton Online Academy   Regular School No High 05 12 2020   grade_6 3 0 0   0 0     0   0   1 2                       3 3 0 0   0 0     0   0   1 2                 3
1806371 CO     school 806060 1060   Peyton 23 Jt 80606001024 6898 Peyton Elementary School   Regular School No Elementary PK 06 2020   grade_6 39 2 7   0 0     0   2   25 25                       50 39 2 7   0 0     0   2   25 25                 50
1806386 CO     school 804500 1070   Hanover 28 80450000661 3758 Hanover Junior-Senior High School   Regular School No High 06 12 2020   grade_6 15 1 8   1 0     0   0   13 12                       25 15 1 8   1 0     0   0   13 12                 25
1806409 CO     school 805820 1080   Lewis-Palmer 38 80582001371 3539 Bear Creek Elementary School   Regular School No Elementary PK 06 2020   grade_6 130 6 16   1 2     0   11   98 68                       166 130 6 16   1 2     0   11   98 68                 166
1806419 CO     school 805820 1080   Lewis-Palmer 38 80582001489 4686 Ray E Kilmer Elementary School   Regular School No Elementary PK 06 2020   grade_6 47 0 8   0 1     0   2   36 22                       58 47 0 8   0 1     0   2   36 22                 58
1806429 CO     school 805820 1080   Lewis-Palmer 38 80582001536 5093 Monument Charter Academy   Regular School Yes Elementary PK 08 2020   grade_6 84 1 9   0 3     0   7   53 51                       104 84 1 9   0 3     0   7   53 51                 104
1806441 CO     school 805820 1080   Lewis-Palmer 38 80582001004 5096 Lewis-Palmer Elementary School   Regular School No Elementary PK 06 2020   grade_6 62 0 4   0 1     0   2   37 32                       69 62 0 4   0 1     0   2   37 32                 69
1806464 CO     school 805820 1080   Lewis-Palmer 38 80582001397 6682 Palmer Lake Elementary School   Regular School No Elementary PK 06 2020   grade_6 45 0 6   0 2     0   5   37 21                       58 45 0 6   0 2     0   5   37 21                 58
1806474 CO     school 805820 1080   Lewis-Palmer 38 80582001810 7165 Prairie Winds Elementary School   Regular School No Elementary PK 06 2020   grade_6 43 0 10   0 1     0   3   25 32                       57 43 0 10   0 1     0   3   25 32                 57
1800319 CO     school 806420 110   Sangre De Cristo Re-22J 80642001116 7630 Sangre de Cristo Undivided High School   Regular School No High 06 12 2020   grade_6 19 0 7   3 0     0   0   18 11                       29 19 0 7   3 0     0   0   18 11                 29
1806490 CO     school 803870 1110   District 49 80387006778 431 Falcon Homeschool Program   Regular School No Other KG 12 2020   grade_6 33 1 7   0 0     0   2   27 16                       43 33 1 7   0 0     0   2   27 16                 43
1806503 CO     school 803870 1110   District 49 80387006785 448 Rocky Mountain Classical Academy Homeschool   Regular School No Other KG 12 2020   grade_6 28 0 4   0 0     0   2   20 14                       34 28 0 4   0 0     0   2   20 14                 34
1806516 CO     school 803870 1110   District 49 80387002027 555 Banning Lewis Ranch Academy   Regular School Yes Other KG 11 2020   grade_6 90 9 39   0 5     0   10   83 70                       153 90 9 39   0 5     0   10   83 70                 153
1806545 CO     school 803870 1110   District 49 80387006462 2877 Springs Studio for Academic Excellence   Regular School No Other KG 12 2020   grade_6 19 1 6   0 0     1   3   15 15                       30 19 1 6   0 0     1   3   15 15                 30
1806557 CO     school 803870 1110   District 49 80387000506 2906 Falcon Middle School   Regular School No Middle 06 08 2020   grade_6 196 10 66   1 8     0   38   162 157                       319 196 10 66   1 8     0   38   162 157                 319
1806571 CO     school 803870 1110   District 49 80387001393 4102 Horizon Middle School   Regular School No Middle 06 08 2020   grade_6 131 14 84   1 6     0   30   124 142                       266 131 14 84   1 6     0   30   124 142                 266
1806580 CO     school 803870 1110   District 49 80387006386 4251 Grand Peak Academy   Regular School Yes Elementary KG 08 2020   grade_6 41 1 16   0 2     0   4   30 34                       64 41 1 16   0 2     0   4   30 34                 64
1806598 CO     school 803870 1110   District 49 80387006744 5191 Liberty Tree Academy   Regular School Yes Other KG 09 2020   grade_6 47 0 6   0 1     0   1   24 31                       55 47 0 6   0 1     0   1   24 31                 55
1806623 CO     school 803870 1110   District 49 80387006693 6653 Power Technical Early College   Career and Technical School Yes High 06 12 2020   grade_6 39 1 12   0 0     0   6   48 10                       58 39 1 12   0 0     0   6   48 10                 58
1806643 CO     school 803870 1110   District 49 80387001844 6935 Pikes Peak School Expeditionary Learning   Regular School Yes Elementary KG 08 2020   grade_6 38 2 3   0 0     1   4   27 21                       48 38 2 3   0 0     1   4   27 21                 48
1806669 CO     school 803870 1110   District 49 80387002000 7463 Rocky Mountain Classical Academy   Regular School Yes Elementary KG 08 2020   grade_6 75 4 21   1 1     0   9   63 48                       111 75 4 21   1 1     0   9   63 48                 111
1806679 CO     school 803870 1110   District 49 80387001799 7960 Skyview Middle School   Regular School No Middle 06 08 2020   grade_6 183 17 84   3 18     0   42   185 162                       347 183 17 84   3 18     0   42   185 162                 347
1806728 CO     school 803630 1120   Edison 54 JT 80363001278 2526 Edison Junior-Senior High School   Regular School No High 06 12 2020   grade_6 8 0 0   0 0     0   0   5 3                       8 8 0 0   0 0     0   0   5 3                 8
1806744 CO     school 805670 1130   Miami/Yoder 60 JT 80567000972 5854 Miami-Yoder Middle/High School   Regular School No High 06 12 2020   grade_6 15 1 8   0 0     0   0   8 16                       24 15 1 8   0 0     0   0   8 16                 24
1806752 CO     school 802790 1140   Canon City RE-1 80279000171 1262 Canon City Middle School   Regular School No Middle 06 08 2020   grade_6 91 1 17   0 1     0   9   55 64                       119 91 1 17   0 1     0   9   55 64                 119
1806766 CO     school 802790 1140   Canon City RE-1 80279000173 3802 Harrison School   Regular School No Elementary KG 08 2020   grade_6 66 0 10   1 0     1   1   43 36                       79 66 0 10   1 0     1   1   43 36                 79
1806790 CO     school 802790 1140   Canon City RE-1 80279001538 6752 Mount View Core Knowledge Charter School   Regular School Yes Elementary PK 08 2020   grade_6 24 0 3   0 1     0   2   18 12                       30 24 0 3   0 1     0   2   18 12                 30
1806800 CO     school 802790 1140   Canon City RE-1 80279001433 7950 Canon Exploratory School   Regular School No Elementary KG 08 2020   grade_6 25 0 4   0 0     0   0   22 7                       29 25 0 4   0 0     0   0   22 7                 29
1806824 CO     school 803960 1150   Fremont RE-2 80396000515 3224 Fremont Elementary School   Regular School No Elementary PK 06 2020   grade_6 61 2 12   0 0     0   4   45 34                       79 61 2 12   0 0     0   4   45 34                 79
1806833 CO     school 803960 1150   Fremont RE-2 80396000516 6858 Penrose Elementary School   Regular School No Elementary PK 06 2020   grade_6 31 0 7   0 0     0   3   23 18                       41 31 0 7   0 0     0   3   23 18                 41
1806848 CO     school 803120 1160   Cotopaxi RE-3 80312000277 3228 Cotopaxi Junior-Senior High School   Regular School No High 06 12 2020   grade_6 16 0 3   0 0     0   0   6 13                       19 16 0 3   0 0     0   0   6 13                 19
1806858 CO     school 804260 1180   Roaring Fork RE-1 80426001505 429 Carbondale Community Charter School   Regular School Yes Elementary KG 08 2020   grade_6 15 0 1   0 0     0   0   8 8                       16 15 0 1   0 0     0   0   8 8                 16
1806871 CO     school 804260 1180   Roaring Fork RE-1 80426000133 561 Basalt Middle School   Regular School No Middle 05 08 2020   grade_6 47 0 76   0 1     0   5   61 68                       129 47 0 76   0 1     0   5   61 68                 129
1806885 CO     school 804260 1180   Roaring Fork RE-1 80426000586 1296 Carbondale Middle School   Regular School No Middle 05 08 2020   grade_6 36 1 60   0 0     0   3   51 49                       100 36 1 60   0 0     0   3   51 49                 100
1806905 CO     school 804260 1180   Roaring Fork RE-1 80426000587 3464 Glenwood Springs Middle School   Regular School No Middle 06 08 2020   grade_6 59 0 84   1 1     0   2   71 76                       147 59 0 84   1 1     0   2   71 76                 147
1806919 CO     school 804260 1180   Roaring Fork RE-1 80426006715 7298 Riverview School   Regular School No Elementary PK 08 2020   grade_6 8 0 23   0 0     0   0   16 15                       31 8 0 23   0 0     0   0   16 15                 31
1806978 CO     school 806240 1195   Garfield Re-2 80624001096 7356 Rifle Middle School   Regular School No Middle 06 08 2020   grade_6 97 0 107   1 2     1   5   104 109                       213 97 0 107   1 2     1   5   104 109                 213
1806987 CO     school 806240 1195   Garfield Re-2 80624001098 7388 Riverside School   Regular School No Middle 06 08 2020   grade_6 80 1 69   1 0     0   5   80 76                       156 80 1 69   1 0     0   5   80 76                 156
1800334 CO     school 803780 120   Englewood 1 80378000486 1514 Charles Hay World School   Regular School No Elementary KG 06 2020   grade_6 15 2 6   0 0     0   2   15 10                       25 15 2 6   0 0     0   2   15 10                 25
1800342 CO     school 803780 120   Englewood 1 80378000488 1556 Cherrelyn Elementary School   Regular School No Elementary KG 06 2020   grade_6 14 0 14   0 0     0   2   11 19                       30 14 0 14   0 0     0   2   11 19                 30
1800350 CO     school 803780 120   Englewood 1 80378000489 1652 Clayton Elementary School   Regular School No Elementary KG 06 2020   grade_6 17 2 30   0 1     0   3   28 25                       53 17 2 30   0 1     0   3   28 25                 53
1800358 CO     school 803780 120   Englewood 1 80378001772 2750 Englewood Leadership Academy   Regular School No Middle 06 09 2020   grade_6 20 1 9   0 1     1   0   16 16                       32 20 1 9   0 1     1   0   16 16                 32
1800372 CO     school 803780 120   Englewood 1 80378000497 9620 Wm E Bishop Elementary School   Regular School No Elementary KG 06 2020   grade_6 4 0 16   0 0     0   1   10 11                       21 4 0 16   0 0     0   1   10 11                 21
1807022 CO     school 804380 1220   Garfield 16 80438001368 8274 Grand Valley Middle School   Regular School No Middle 06 08 2020   grade_6 67 0 39   0 0     1   5   55 57                       112 67 0 39   0 0     1   5   55 57                 112
1800382 CO     school 806540 123   Sheridan 2 80654001135 7837 Fort Logan Northgate   Regular School No Middle 03 08 2020   grade_6 11 6 79   3 2     0   3   51 53                       104 11 6 79   3 2     0   3   51 53                 104
1800406 CO     school 802910 130   Cherry Creek 5 80291001711 18 Liberty Middle School   Regular School No Middle 06 08 2020   grade_6 170 33 63   1 38     0   29   186 148                       334 170 33 63   1 38     0   29   186 148                 334
1800418 CO     school 802910 130   Cherry Creek 5 80291001878 141 Sky Vista Middle School   Regular School No Middle 06 08 2020   grade_6 151 47 57   0 29     0   40   164 160                       324 151 47 57   0 29     0   40   164 160                 324
1800422 CO     school 802910 130   Cherry Creek 5 80291006770 188 Colorado Skies Academy   Regular School Yes Middle 06 08 2020   grade_6 36 5 4   0 4     0   2   33 18                       51 36 5 4   0 4     0   2   33 18                 51
1800487 CO     school 802910 130   Cherry Creek 5 80291000763 1510 Challenge School   Regular School No Elementary PK 08 2020   grade_6 27 14 7   1 17     0   8   37 37                       74 27 14 7   1 17     0   8   37 37                 74
1800497 CO     school 802910 130   Cherry Creek 5 80291000185 1566 Campus Middle School   Regular School No Middle 06 08 2020   grade_6 304 16 65   3 77     1   42   243 265                       508 304 16 65   3 77     1   42   243 265                 508
1800501 CO     school 802910 130   Cherry Creek 5 80291000207 1568 West Middle School   Regular School No Middle 06 08 2020   grade_6 283 9 52   3 19     1   27   209 185                       394 283 9 52   3 19     1   27   209 185                 394
1800515 CO     school 802910 130   Cherry Creek 5 80291001152 1571 Cherry Creek Charter Academy   Regular School Yes Elementary KG 08 2020   grade_6 25 3 6   0 16     0   2   27 25                       52 25 3 6   0 16     0   2   27 25                 52
1800588 CO     school 802910 130   Cherry Creek 5 80291001672 2897 Falcon Creek Middle School   Regular School No Middle 06 08 2020   grade_6 168 24 54   5 26     1   31   160 149                       309 168 24 54   5 26     1   31   160 149                 309

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