Data source: Big Local News · About: Big Local

690 rows where grade = "grade_6", state = "CO" and year = 2020 sorted by district_nces_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
1802567 CO     school 800001 520   Cheyenne County Re-5 80000100214 1608 Cheyenne Wells Elementary School   Regular School No Elementary PK 06 2020   grade_6 13 1 1   0 0     0   0   7 8                       15 13 1 1   0 0     0   0   7 8                 15
1812587 CO     school 800004 9130   Expeditionary BOCES 80000400709 2840 Rocky Mountain School of Expeditionary Learning   Regular School No Other KG 12 2020   grade_6 36 1 8   0 1     0   6   33 19                       52 36 1 8   0 1     0   6   33 19                 52
1812132 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2020   grade_6 25 0 43   0 0     0   0   31 37                       68 25 0 43   0 0     0   0   31 37                 68
1812155 CO     school 800017 3210   Wray RD-2 80001701817 9729 Buchanan Middle School   Regular School No Middle 05 08 2020   grade_6 34 0 15   0 0     0   0   22 27                       49 34 0 15   0 0     0   0   22 27                 49
1812169 CO     school 800018 3220   Idalia RJ-3 80001801741 4227 Idalia Elementary School   Regular School No Elementary PK 06 2020   grade_6 13 0 4   0 0     0   0   6 11                       17 13 0 4   0 0     0   0   6 11                 17
1812188 CO     school 800019 3230   Liberty J-4 80001901744 5123 Liberty School   Career and Technical School No Other PK 12 2020   grade_6 2 0 0   0 0     0   0   2 0                       2 2 0 0   0 0     0   0   2 0                 2
1812203 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2020   grade_6 97 1 36   0 9     0   4   73 74                       147 97 1 36   0 9     0   4   73 74                 147
1812215 CO     school 800020 8001   Charter School Institute 80002006777 149 Colorado Early Colleges Fort Collins West   Regular School Yes Middle 06 08 2020   grade_6 9 0 1   0 0     0   0   4 6                       10 9 0 1   0 0     0   0   4 6                 10
1812232 CO     school 800020 8001   Charter School Institute 80002002018 653 Stone Creek School   Regular School Yes Elementary KG 08 2020   grade_6 24 1 12   0 0     0   1   27 11                       38 24 1 12   0 0     0   1   27 11                 38
1812242 CO     school 800020 8001   Charter School Institute 80002002033 655 High Point Academy   Regular School Yes Elementary PK 08 2020   grade_6 15 23 38   3 2     0   1   42 40                       82 15 23 38   3 2     0   1   42 40                 82
1812264 CO     school 800020 8001   Charter School Institute 80002006305 1279 Caprock Academy   Regular School Yes Other KG 12 2020   grade_6 64 1 9   0 2     0   5   39 42                       81 64 1 9   0 2     0   5   39 42                 81
1812276 CO     school 800020 8001   Charter School Institute 80002006784 1371 Coperni 3   Regular School Yes Elementary KG 06 2020   grade_6 12 5 13   0 1     1   1   17 16                       33 12 5 13   0 1     1   1   17 16                 33
1812287 CO     school 800020 8001   Charter School Institute 80002006779 1387 Colorado Early Colleges Windsor   Regular School Yes Other KG 12 2020   grade_6 22 0 5   0 0     0   3   16 14                       30 22 0 5   0 0     0   3   16 14                 30
1812299 CO     school 800020 8001   Charter School Institute 80002006708 1505 Colorado Military Academy   Regular School Yes Other KG 12 2020   grade_6 28 6 20   0 2     0   4   43 17                       60 28 6 20   0 2     0   4   43 17                 60
1812315 CO     school 800020 8001   Charter School Institute 80002001912 1791 Colorado Springs Charter Academy   Regular School Yes Elementary KG 08 2020   grade_6 31 0 10   0 0     0   3   21 23                       44 31 0 10   0 0     0   3   21 23                 44
1812338 CO     school 800020 8001   Charter School Institute 80002001569 2035 Crown Pointe Charter Academy   Regular School Yes Elementary KG 08 2020   grade_6 21 0 31   0 1     0   2   21 34                       55 21 0 31   0 1     0   2   21 34                 55
1812346 CO     school 800020 8001   Charter School Institute 80002006542 2067 Colorado Early College Fort Collins   Regular School Yes High 06 12 2020   grade_6 42 1 11   0 2     0   1   25 32                       57 42 1 11   0 2     0   1   25 32                 57
1812359 CO     school 800020 8001   Charter School Institute 80002006390 2837 Early College of Arvada   Regular School Yes High 06 12 2020   grade_6 9 0 27   0 3     0   0   18 21                       39 9 0 27   0 3     0   0   18 21                 39
1812369 CO     school 800020 8001   Charter School Institute 80002006586 3326 Colorado International Language Academy   Regular School Yes Elementary KG 08 2020   grade_6 6 0 7   0 0     0   0   3 10                       13 6 0 7   0 0     0   0   3 10                 13
1812383 CO     school 800020 8001   Charter School Institute 80002006639 3393 Golden View Classical Academy   Regular School Yes Other KG 12 2020   grade_6 49 0 5   1 2     0   3   28 32                       60 49 0 5   1 2     0   3   28 32                 60
1812394 CO     school 800020 8001   Charter School Institute 80002006503 3439 Global Village Academy - Northglenn   Regular School Yes Elementary KG 08 2020   grade_6 30 2 42   0 2     0   0   30 46                       76 30 2 42   0 2     0   0   30 46                 76
1812426 CO     school 800020 8001   Charter School Institute 80002006761 5431 Coperni 2   Regular School Yes Elementary KG 07 2020   grade_6 6 6 3   0 0     0   0   3 12                       15 6 6 3   0 0     0   0   3 12                 15
1812432 CO     school 800020 8001   Charter School Institute 80002006502 5453 Mountain Middle School   Regular School Yes Middle 04 08 2020   grade_6 54 0 3   1 1     0   1   31 29                       60 54 0 3   1 1     0   1   31 29                 60
1812447 CO     school 800020 8001   Charter School Institute 80002006589 5851 Mountain Song Community School   Regular School Yes Elementary KG 08 2020   grade_6 24 0 14   1 1     0   4   25 19                       44 24 0 14   1 1     0   4   25 19                 44
1812458 CO     school 800020 8001   Charter School Institute 80002006602 5957 Montessori del Mundo Charter School   Regular School Yes Elementary PK 06 2020   grade_6 1 0 16   0 0     0   0   12 5                       17 1 0 16   0 0     0   0   12 5                 17
1812480 CO     school 800020 8001   Charter School Institute 80002001915 6914 The Pinnacle Charter School   Regular School Yes Other KG 12 2020   grade_6 16 2 160   0 2     0   4   90 94                       184 16 2 160   0 2     0   4   90 94                 184
1812491 CO     school 800020 8001   Charter School Institute 80002006320 7278 Ricardo Flores Magon Academy   Regular School Yes Elementary KG 08 2020   grade_6 0 0 40   0 0     0   0   21 19                       40 0 0 40   0 0     0   0   21 19                 40
1812501 CO     school 800020 8001   Charter School Institute 80002001913 7512 Ross Montessori School   Regular School Yes Elementary KG 08 2020   grade_6 14 0 7   0 0     1   0   10 12                       22 14 0 7   0 0     1   0   10 12                 22
1812511 CO     school 800020 8001   Charter School Institute 80002006651 8061 Salida Montessori Charter School   Regular School Yes Elementary PK 08 2020   grade_6 9 1 0   0 0     0   1   7 4                       11 9 1 0   0 0     0   1   7 4                 11
1812521 CO     school 800020 8001   Charter School Institute 80002006635 8821 Two Rivers Community School   Regular School Yes Elementary KG 08 2020   grade_6 27 1 11   0 1     0   0   20 20                       40 27 1 11   0 1     0   0   20 20                 40
1812535 CO     school 800020 8001   Charter School Institute 80002006437 8825 Thomas MacLaren State Charter School   Regular School Yes Other KG 12 2020   grade_6 63 3 21   1 2     0   9   49 50                       99 63 3 21   1 2     0   9   49 50                 99
1812547 CO     school 800020 8001   Charter School Institute 80002006579 9040 Victory Preparatory Academy Middle State Charter School   Regular School Yes Middle 06 08 2020   grade_6 3 1 61   0 0     0   2   27 40                       67 3 1 61   0 0     0   2   27 40                 67
1812559 CO     school 800023 9000   Colorado School for the Deaf and Blind 80002306410 1924 Colorado School for the Deaf and Blind   Special Education School No Other PK 12 2020   grade_6 4 0 6   0 1     0   1   4 8                       12 4 0 6   0 1     0   1   4 8                 12
1812601 CO     school 800282 9170   Education reEnvisioned BOCES 80028206764 1501 Colorado Preparatory Academy Middle School   Regular School No Middle 06 08 2020   grade_6 94 4 58   4 1     0   13   94 80                       174 94 4 58   4 1     0   13   94 80                 174
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
1799845 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2020   grade_6 20 4 224   2 0     0   2   137 115                       252 20 4 224   2 0     0   2   137 115                 252
1799882 CO     school 801950 30   Adams County 14 80195000015 4516 Kearney Middle School   Regular School No Middle 06 08 2020   grade_6 25 6 219   2 0     0   1   139 114                       253 25 6 219   2 0     0   1   139 114                 253
1805210 CO     school 801980 960   Agate 300 80198000021 48 Agate Junior Senior High School   Regular School No High 06 12 2020   grade_6 3 0 0   0 0     0   0   2 1                       3 3 0 0   0 0     0   0   2 1                 3
1809412 CO     school 802010 1620   Aguilar Reorganized 6 80201000023 66 Aguilar Junior-Senior High School   Regular School No High 06 12 2020   grade_6 2 0 7   0 0     0   0   7 2                       9 2 0 7   0 0     0   0   7 2                 9
1811485 CO     school 802040 3030   Akron R-1 80204000024 86 Akron Elementary School   Regular School No Elementary PK 08 2020   grade_6 19 0 6   1 0     0   0   15 11                       26 19 0 6   1 0     0   0   15 11                 26
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
1802665 CO     school 802130 580   South Conejos RE-10 80213000033 248 Guadalupe Elementary School   Regular School No Elementary PK 06 2020   grade_6 2 0 8   0 0     0   0   7 3                       10 2 0 8   0 0     0   0   7 3                 10
1801568 CO     school 802190 220   Archuleta County 50 Jt 80219000040 6657 Pagosa Springs Middle School   Regular School No Middle 05 08 2020   grade_6 58 1 50   11 3     0   5   65 63                       128 58 1 50   11 3     0   5   65 63                 128
1801582 CO     school 802190 220   Archuleta County 50 Jt 80219006717 6679 Pagosa Peak Open School   Regular School Yes Elementary KG 06 2020   grade_6 8 0 6   1 0     0   0   7 8                       15 8 0 6   1 0     0   0   7 8                 15
1811507 CO     school 802220 3040   Arickaree R-2 80222000042 308 Arickaree Undivided High School   Regular School No High 06 12 2020   grade_6 6 0 4   0 0     0   0   5 5                       10 6 0 4   0 0     0   0   5 5                 10
1808464 CO     school 802260 1450   Arriba-Flagler C-20 80226000509 2960 Flagler Public School   Regular School No Other PK 12 2020   grade_6 14 0 0   0 1     0   0   8 7                       15 14 0 0   0 1     0   0   8 7                 15
1810534 CO     school 802280 2640   Aspen 1 80228001703 42 Aspen Community Charter School   Regular School Yes Elementary PK 08 2020   grade_6 14 0 2   0 0     0   0   9 7                       16 14 0 2   0 0     0   0   9 7                 16
1810546 CO     school 802280 2640   Aspen 1 80228000046 430 Aspen Middle School   Regular School No Middle 05 08 2020   grade_6 92 0 14   0 0     0   2   66 42                       108 92 0 14   0 0     0   2   66 42                 108
1812073 CO     school 802310 3145   Ault-Highland RE-9 80231001466 3961 Highland Middle School   Regular School No Middle 06 08 2020   grade_6 60 0 17   1 0     0   2   45 35                       80 60 0 17   1 0     0   2   45 35                 80
1801027 CO     school 802340 180   Adams-Arapahoe 28J 80234006771 122 Aurora Community School   Regular School Yes Elementary KG 06 2020   grade_6 4 13 20   0 0     0   2   22 17                       39 4 13 20   0 0     0   2   22 17                 39
1801035 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2020   grade_6 5 20 65   0 1     0   6   50 47                       97 5 20 65   0 1     0   6   50 47                 97
1801040 CO     school 802340 180   Adams-Arapahoe 28J 80234006787 127 Aurora Science & Tech Middle School   Regular School Yes Middle 06 06 2020   grade_6 17 21 110   0 4     2   12   93 73                       166 17 21 110   0 4     2   12   93 73                 166
1801049 CO     school 802340 180   Adams-Arapahoe 28J 80234006399 213 AXL Academy   Regular School Yes Elementary PK 08 2020   grade_6 9 19 21   0 0     1   4   32 22                       54 9 19 21   0 0     1   4   32 22                 54
1801076 CO     school 802340 180   Adams-Arapahoe 28J 80234001759 458 Aurora Academy Charter School   Regular School Yes Elementary KG 08 2020   grade_6 11 22 26   0 1     0   4   36 28                       64 11 22 26   0 1     0   4   36 28                 64
1801081 CO     school 802340 180   Adams-Arapahoe 28J 80234000054 464 Aurora Hills Middle School   Regular School No Middle 06 08 2020   grade_6 20 44 145   1 14     4   18   126 120                       246 20 44 145   1 14     4   18   126 120                 246
1801090 CO     school 802340 180   Adams-Arapahoe 28J 80234002009 465 Aurora Frontier K-8   Regular School No Elementary PK 08 2020   grade_6 37 7 40   1 12     0   3   53 47                       100 37 7 40   1 12     0   3   53 47                 100
1801101 CO     school 802340 180   Adams-Arapahoe 28J 80234000055 914 Boston K-8 School   Regular School No Elementary PK 08 2020   grade_6 1 8 31   0 2     0   1   20 23                       43 1 8 31   0 2     0   1   20 23                 43
1801125 CO     school 802340 180   Adams-Arapahoe 28J 80234000057 1720 Clyde Miller K-8   Regular School No Elementary PK 08 2020   grade_6 5 2 43   0 2     1   1   26 28                       54 5 2 43   0 2     1   1   26 28                 54
1801131 CO     school 802340 180   Adams-Arapahoe 28J 80234001322 1800 Columbia Middle School   Regular School No Middle 06 08 2020   grade_6 48 35 114   1 8     0   19   121 104                       225 48 35 114   1 8     0   19   121 104                 225
1801159 CO     school 802340 180   Adams-Arapahoe 28J 80234000060 2384 East Middle School   Regular School No Middle 06 08 2020   grade_6 8 40 211   3 8     2   6   143 135                       278 8 40 211   3 8     2   6   143 135                 278
1801178 CO     school 802340 180   Adams-Arapahoe 28J 80234006644 2673 Edna and John W. Mosley P-8   Regular School No Elementary PK 08 2020   grade_6 11 17 63   1 0     4   7   57 46                       103 11 17 63   1 0     4   7   57 46                 103
1801204 CO     school 802340 180   Adams-Arapahoe 28J 80234006318 3471 Global Village Academy Aurora   Regular School Yes Elementary KG 08 2020   grade_6 2 28 59   0 2     0   5   46 50                       96 2 28 59   0 2     0   5   46 50                 96
1801264 CO     school 802340 180   Adams-Arapahoe 28J 80234001916 5298 Lotus School for Excellence   Regular School Yes Other KG 12 2020   grade_6 15 39 35   0 1     0   2   52 40                       92 15 39 35   0 1     0   2   52 40                 92
1801288 CO     school 802340 180   Adams-Arapahoe 28J 80234000073 6160 Mrachek Middle School   Regular School No Middle 06 08 2020   grade_6 43 67 158   3 11     4   20   167 139                       306 43 67 158   3 11     4   20   167 139                 306
1801297 CO     school 802340 180   Adams-Arapahoe 28J 80234001881 6189 Murphy Creek K-8 School   Regular School No Elementary PK 08 2020   grade_6 26 10 17   1 6     0   8   36 32                       68 26 10 17   1 6     0   8   36 32                 68
1801303 CO     school 802340 180   Adams-Arapahoe 28J 80234000074 6310 North Middle School Health Sciences and Technology Campus   Regular School No Middle 06 08 2020   grade_6 9 32 131   1 8     6   8   115 80                       195 9 32 131   1 8     6   8   115 80                 195
1801315 CO     school 802340 180   Adams-Arapahoe 28J 80234001789 6546 Options School   Regular School No Other KG 12 2020   grade_6 71 2 18   0 1     0   3   45 50                       95 71 2 18   0 1     0   3   45 50                 95
1801350 CO     school 802340 180   Adams-Arapahoe 28J 80234001674 7232 Aurora Quest K-8   Regular School No Elementary KG 08 2020   grade_6 37 8 25   0 13     0   10   52 41                       93 37 8 25   0 13     0   10   52 41                 93
1801392 CO     school 802340 180   Adams-Arapahoe 28J 80234000079 8078 South Middle School   Regular School No Middle 06 08 2020   grade_6 17 32 158   3 5     5   5   112 113                       225 17 32 158   3 5     5   5   112 113                 225
1801411 CO     school 802340 180   Adams-Arapahoe 28J 80234006732 9053 Vega Collegiate Academy   Regular School Yes Elementary KG 07 2020   grade_6 2 5 23   1 5     0   1   21 16                       37 2 5 23   1 5     0   1   21 16                 37
1801420 CO     school 802340 180   Adams-Arapahoe 28J 80234006322 9056 Vanguard Classical School - West   Regular School Yes Elementary KG 08 2020   grade_6 5 14 26   0 0     0   2   16 31                       47 5 14 26   0 0     0   2   16 31                 47
1801446 CO     school 802340 180   Adams-Arapahoe 28J 80234006483 9083 Vista Peak P-8 Exploratory   Regular School No Elementary PK 08 2020   grade_6 38 21 69   2 2     0   12   61 83                       144 38 21 69   2 2     0   12   61 83                 144
1801473 CO     school 802340 180   Adams-Arapahoe 28J 80234006611 9189 Vanguard Classical School - East   Regular School Yes Other KG 12 2020   grade_6 12 15 22   0 2     0   4   16 39                       55 12 15 22   0 2     0   4   16 39                 55
1801482 CO     school 802340 180   Adams-Arapahoe 28J 80234000082 9396 Aurora West College Preparatory Academy   Regular School No High 06 12 2020   grade_6 9 24 160   3 14     2   6   120 98                       218 9 24 160   3 14     2   6   120 98                 218
1810450 CO     school 802370 2600   Platte Canyon 1 80237001325 7048 Fitzsimmons Middle School   Regular School No Middle 06 08 2020   grade_6 53 0 5   0 0     0   4   38 24                       62 53 0 5   0 0     0   4   38 24                 62
1808666 CO     school 802400 1530   Bayfield 10 Jt-R 80240000089 636 Bayfield Middle School   Regular School No Middle 06 08 2020   grade_6 84 0 26   6 1     1   6   70 54                       124 84 0 26   6 1     1   6   70 54                 124
1800105 CO     school 802430 50   Bennett 29J 80243006789 562 Bennett Intermediate School   Regular School No Middle 04 06 2020   grade_6 59 0 31   0 0     0   3   47 46                       93 59 0 31   0 0     0   3   47 46                 93
1808511 CO     school 802460 1490   Bethune R-5 80246000095 842 Bethune Public Schools   Regular School No Other PK 12 2020   grade_6 5 0 3   0 0     0   0   4 4                       8 5 0 3   0 0     0   0   4 4                 8
1802117 CO     school 802490 480   Boulder Valley Re 2 80249001758 441 Aspen Creek K-8 School   Regular School No Elementary PK 08 2020   grade_6 94 4 21   1 4     1   4   61 68                       129 94 4 21   1 4     1   4   61 68                 129
1802154 CO     school 802490 480   Boulder Valley Re 2 80249006463 930 Boulder Universal   Regular School No Other KG 12 2020   grade_6 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1802164 CO     school 802490 480   Boulder Valley Re 2 80249000102 1066 Broomfield Heights Middle School   Regular School No Middle 06 08 2020   grade_6 121 6 57   0 2     0   10   96 100                       196 121 6 57   0 2     0   10   96 100                 196
1802173 CO     school 802490 480   Boulder Valley Re 2 80249000104 1136 Manhattan Middle School of the Arts and Academics   Regular School No Middle 06 08 2020   grade_6 130 3 47   0 4     0   19   97 106                       203 130 3 47   0 4     0   19   97 106                 203
1802177 CO     school 802490 480   Boulder Valley Re 2 80249000106 1352 Casey Middle School   Regular School No Middle 06 08 2020   grade_6 102 2 74   0 3     0   10   94 97                       191 102 2 74   0 3     0   10   94 97                 191
1802186 CO     school 802490 480   Boulder Valley Re 2 80249000108 1390 Centennial Middle School   Regular School No Middle 06 08 2020   grade_6 137 5 52   1 10     0   11   123 93                       216 137 5 52   1 10     0   11   123 93                 216
1802240 CO     school 802490 480   Boulder Valley Re 2 80249001771 2589 Eldorado K-8 School   Regular School No Elementary PK 08 2020   grade_6 117 0 11   0 4     1   12   84 61                       145 117 0 11   0 4     1   12   84 61                 145
1802251 CO     school 802490 480   Boulder Valley Re 2 80249006716 2639 Meadowlark School   Regular School No Elementary PK 08 2020   grade_6 47 0 6   0 5     0   4   34 28                       62 47 0 6   0 5     0   4   34 28                 62
1802323 CO     school 802490 480   Boulder Valley Re 2 80249002013 4496 Justice High Charter School   Alternative School Yes High 06 12 2020   grade_6 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1802344 CO     school 802490 480   Boulder Valley Re 2 80249000122 4878 Angevine Middle School   Regular School No Middle 06 08 2020   grade_6 105 1 82   2 11     0   12   116 97                       213 105 1 82   2 11     0   12   116 97                 213
1802355 CO     school 802490 480   Boulder Valley Re 2 80249000125 5306 Louisville Middle School   Regular School No Middle 06 08 2020   grade_6 161 2 19   0 10     0   8   100 100                       200 161 2 19   0 10     0   8   100 100                 200
1802386 CO     school 802490 480   Boulder Valley Re 2 80249001573 6000 Monarch K-8 School   Regular School No Elementary PK 08 2020   grade_6 79 1 18   0 19     0   6   63 60                       123 79 1 18   0 19     0   6   63 60                 123

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