Data source: Big Local News · About: Big Local

4,915 rows where grade = "grade_6" and state = "CO" sorted by district descending

View and edit SQL

year

grade

  • grade_6 · 4,915
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
1751018 CO     school 800016 3200   Yuma 1 80001601819 9791 Yuma Middle School   Regular School No Middle 05 08 2021   grade_6 29 0 32   0 0     0   0   32 29                       61 29 0 32   0 0     0   0   32 29                 61
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
720557 CO     school 800016 3200   YUMA 1 80001601819 9791 YUMA MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_6 31 0 32   0 0     0   1   32 32                       64 31 0 32   0 0     0   1   32 32                 64
848124 CO     school 800016 3200   YUMA 1 80001601819 9791 YUMA MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_6 27 0 35   0 0     0   0   27 35                       62 27 0 35   0 0     0   0   27 35                 62
1145692 CO     school 800016 3200   YUMA 1 80001601819 9791 YUMA MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_6 35.0 0.0 32.0   0.0 0.0     0.0   0.0   41.0 26.0                       67.0 35 0 32   0 0     0   0   41 26                 67
1906505 CO     school 800016 3200   YUMA 1 80001601819 9791 YUMA MIDDLE SCHOOL   Regular School No Middle 05 08 2018   grade_6 26 1 37   0 0     0   1   29 36                       65 26 1 37   0 0     0   1   29 36                 65
1943878 CO     school 800016 3200   YUMA 1 80001601819 9791 YUMA MIDDLE SCHOOL   Regular School No Middle 05 08 2019   grade_6 38 0 28   0 0     0   0   30 36                       66 38 0 28   0 0     0   0   30 36                 66
1751038 CO     school 800017 3210   Wray RD-2 80001701816 9725 Wray Elementary School   Regular School No Elementary PK 06 2021   grade_6 34 0 19   0 0     0   1   24 30                       54 34 0 19   0 0     0   1   24 30                 54
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
1750428 CO     school 807410 3070   Woodlin R-104 80741001271 9704 Woodlin Undivided High School   Regular School No High 06 12 2021   grade_6 11 0 1   0 0     0   0   7 5                       12 11 0 1   0 0     0   0   7 5                 12
1811555 CO     school 807410 3070   Woodlin R-104 80741001271 9704 Woodlin Undivided High School   Regular School No High 06 12 2020   grade_6 3 0 0   0 0     0   0   0 3                       3 3 0 0   0 0     0   0   0 3                 3
1750336 CO     school 807380 3020   Woodland Park Re-2 80738001268 9694 Woodland Park Middle School   Regular School No Middle 06 08 2021   grade_6 107 0 21   0 2     0   7   67 70                       137 107 0 21   0 2     0   7   67 70                 137
1811463 CO     school 807380 3020   Woodland Park Re-2 80738001268 9694 Woodland Park Middle School   Regular School No Middle 06 08 2020   grade_6 133 2 19   0 0     0   6   93 67                       160 133 2 19   0 0     0   6   93 67                 160
1750551 CO     school 807350 3100   Windsor RE-4 80735006427 7755 Severance Middle School   Regular School No Middle 06 08 2021   grade_6 139 3 50   0 2     0   3   110 87                       197 139 3 50   0 2     0   3   110 87                 197
1750587 CO     school 807350 3100   Windsor RE-4 80735006782 9563 Windsor Charter Academy Middle School   Regular School Yes Middle 06 08 2021   grade_6 101 0 14   1 1     0   7   61 63                       124 101 0 14   1 1     0   7   61 63                 124
1750598 CO     school 807350 3100   Windsor RE-4 80735001265 9670 Windsor Middle School   Regular School No Middle 06 08 2021   grade_6 181 2 38   2 0     0   9   110 122                       232 181 2 38   2 0     0   9   110 122                 232
1750610 CO     school 807350 3100   Windsor RE-4 80735006812 9671 Inspire4 K-12 Online School   Regular School No Other KG 12 2021   grade_6 27 2 7   0 1     1   1   22 17                       39 27 2 7   0 1     1   1   22 17                 39
1811678 CO     school 807350 3100   Windsor RE-4 80735006427 7755 Severance Middle School   Regular School No Middle 06 08 2020   grade_6 155 2 39   0 3     1   6   107 99                       206 155 2 39   0 3     1   6   107 99                 206
1811714 CO     school 807350 3100   Windsor RE-4 80735006782 9563 Windsor Charter Academy Middle School   Regular School Yes Middle 06 08 2020   grade_6 87 1 14   0 3     0   3   55 53                       108 87 1 14   0 3     0   3   55 53                 108
1811726 CO     school 807350 3100   Windsor RE-4 80735001265 9670 Windsor Middle School   Regular School No Middle 06 08 2020   grade_6 207 1 35   0 0     0   6   134 115                       249 207 1 35   0 0     0   6   134 115                 249
1749494 CO     school 807320 2680   Wiley RE-13 Jt 80732001261 9608 Wiley Junior-Senior High School   Regular School No High 06 12 2021   grade_6 13 0 5   0 0     0   0   12 6                       18 13 0 5   0 0     0   0   12 6                 18
1810626 CO     school 807320 2680   Wiley RE-13 Jt 80732001261 9608 Wiley Junior-Senior High School   Regular School No High 06 12 2020   grade_6 7 0 2   0 0     0   0   3 6                       9 7 0 2   0 0     0   0   3 6                 9
1749161 CO     school 807290 2515   Wiggins RE-50(J) 80729001257 9576 Wiggins Elementary School   Regular School No Elementary PK 06 2021   grade_6 33 0 19   0 0     0   3   28 27                       55 33 0 19   0 0     0   3   28 27                 55
1810300 CO     school 807290 2515   Wiggins RE-50(J) 80729001257 9576 Wiggins Elementary School   Regular School No Elementary PK 06 2020   grade_6 40 0 19   0 0     0   1   30 30                       60 40 0 19   0 0     0   1   30 30                 60
1744333 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2021   grade_6 40 10 37   1 2     5   13   59 49                       108 40 10 37   1 2     5   13   59 49                 108
1744346 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2021   grade_6 95 20 70   2 4     2   21   122 92                       214 95 20 70   2 4     2   21   122 92                 214
1744355 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2021   grade_6 4 0 4   0 0     0   1   1 8                       9 4 0 4   0 0     0   1   1 8                 9
1744387 CO     school 806480 990   Widefield 3 80648001125 8178 Sproul Junior High School   Regular School No Middle 06 08 2021   grade_6 91 18 55   2 3     2   17   88 100                       188 91 18 55   2 3     2   17   88 100                 188
1744398 CO     school 806480 990   Widefield 3 80648001126 9294 Watson Junior High School   Regular School No Middle 06 08 2021   grade_6 99 17 49   2 2     1   16   92 94                       186 99 17 49   2 2     1   16   92 94                 186
1805412 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2020   grade_6 55 17 26   0 3     4   17   49 73                       122 55 17 26   0 3     4   17   49 73                 122
1805425 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2020   grade_6 111 13 65   1 3     2   24   120 99                       219 111 13 65   1 3     2   24   120 99                 219
1805434 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2020   grade_6 4 0 3   0 0     0   0   7 0                       7 4 0 3   0 0     0   0   7 0                 7
1805466 CO     school 806480 990   Widefield 3 80648001125 8178 Sproul Junior High School   Regular School No Middle 06 08 2020   grade_6 102 12 73   1 3     4   25   108 112                       220 102 12 73   1 3     4   25   108 112                 220
1805477 CO     school 806480 990   Widefield 3 80648001126 9294 Watson Junior High School   Regular School No Middle 06 08 2020   grade_6 83 21 66   1 3     0   22   96 100                       196 83 21 66   1 3     0   22   96 100                 196
1739089 CO     school 807230 70   Westminster Public Schools 80723001232 1622 Metropolitan Arts Academy   Regular School No Elementary PK 07 2021   grade_6 9 1 30   0 1     0   0   17 24                       41 9 1 30   0 1     0   0   17 24                 41
1739121 CO     school 807230 70   Westminster Public Schools 80723006567 4334 Colorado STEM Academy   Regular School No Elementary PK 08 2021   grade_6 23 0 35   1 1     0   2   41 21                       62 23 0 35   1 1     0   2   41 21                 62
1739132 CO     school 807230 70   Westminster Public Schools 80723006373 4465 Josephine Hodgkins Leadership Academy   Regular School No Elementary PK 07 2021   grade_6 3 1 72   0 2     0   0   37 41                       78 3 1 72   0 2     0   0   37 41                 78
1739142 CO     school 807230 70   Westminster Public Schools 80723001241 5388 Colorado Sports Leadership Academy   Regular School No Elementary KG 08 2021   grade_6 8 0 40   0 0     0   1   28 21                       49 8 0 40   0 0     0   1   28 21                 49
1739155 CO     school 807230 70   Westminster Public Schools 80723006458 7305 Iver C. Ranum Middle School   Regular School No Middle 06 08 2021   grade_6 15 3 94   1 5     0   1   54 65                       119 15 3 94   1 5     0   1   54 65                 119
1739164 CO     school 807230 70   Westminster Public Schools 80723001363 7810 John E. Flynn A Marzano Academy   Regular School No Elementary PK 07 2021   grade_6 5 0 21   0 3     0   0   17 12                       29 5 0 21   0 3     0   0   17 12                 29
1739169 CO     school 807230 70   Westminster Public Schools 80723001244 7812 Shaw Heights Middle School   Regular School No Middle 06 08 2021   grade_6 23 6 101   2 5     0   6   74 69                       143 23 6 101   2 5     0   6   74 69                 143
1739186 CO     school 807230 70   Westminster Public Schools 80723001247 7952 Skyline Vista Elementary School   Regular School No Elementary PK 06 2021   grade_6 2 0 43   0 2     0   1   27 21                       48 2 0 43   0 2     0   1   27 21                 48
1739203 CO     school 807230 70   Westminster Public Schools 80723001249 8798 Tennyson Knolls Preparatory School   Regular School No Elementary PK 08 2021   grade_6 4 0 37   0 5     0   1   21 26                       47 4 0 37   0 5     0   1   21 26                 47
1739214 CO     school 807230 70   Westminster Public Schools 80723006675 9236 Westminster Academy for International Studies   Regular School No Elementary PK 08 2021   grade_6 6 0 25   0 1     0   1   19 14                       33 6 0 25   0 1     0   1   19 14                 33
1800150 CO     school 807230 70   Westminster Public Schools 80723001232 1622 Metropolitan Arts Academy   Regular School No Elementary PK 06 2020   grade_6 5 1 36   1 1     0   0   23 21                       44 5 1 36   1 1     0   0   23 21                 44
1800190 CO     school 807230 70   Westminster Public Schools 80723006567 4334 Colorado STEM Academy   Regular School No Elementary PK 08 2020   grade_6 21 1 46   1 5     0   2   39 37                       76 21 1 46   1 5     0   2   39 37                 76
1800201 CO     school 807230 70   Westminster Public Schools 80723006373 4465 Josephine Hodgkins Leadership Academy   Regular School No Elementary PK 06 2020   grade_6 12 1 60   0 0     1   1   37 38                       75 12 1 60   0 0     1   1   37 38                 75
1800205 CO     school 807230 70   Westminster Public Schools 80723001241 5388 M. Scott Carpenter Middle School   Regular School No Middle 06 08 2020   grade_6 9 2 95   0 2     0   0   59 49                       108 9 2 95   0 2     0   0   59 49                 108
1800217 CO     school 807230 70   Westminster Public Schools 80723006458 7305 Iver C. Ranum Middle School   Regular School No Middle 06 08 2020   grade_6 15 3 139   0 5     0   2   81 83                       164 15 3 139   0 5     0   2   81 83                 164
1800226 CO     school 807230 70   Westminster Public Schools 80723001363 7810 John E. Flynn A Marzano Academy   Regular School No Elementary PK 06 2020   grade_6 5 0 18   0 0     0   1   14 10                       24 5 0 18   0 0     0   1   14 10                 24
1800230 CO     school 807230 70   Westminster Public Schools 80723001244 7812 Shaw Heights Middle School   Regular School No Middle 06 08 2020   grade_6 33 8 125   1 8     0   2   86 91                       177 33 8 125   1 8     0   2   86 91                 177
1800271 CO     school 807230 70   Westminster Public Schools 80723006675 9236 Westminster Academy for International Studies   Regular School No Elementary PK 08 2020   grade_6 2 0 30   0 0     0   0   15 17                       32 2 0 30   0 0     0   0   15 17                 32
1745964 CO     school 805070 1340   West Grand 1-JT 80507000829 9422 West Grand Elementary and Middle School   Regular School No Elementary KG 08 2021   grade_6 24 0 11   0 0     0   2   20 17                       37 24 0 11   0 0     0   2   20 17                 37
1807052 CO     school 805070 1340   West Grand 1-JT 80507000829 9422 West Grand Elementary and Middle School   Regular School No Elementary KG 08 2020   grade_6 18 0 11   1 0     0   0   14 16                       30 18 0 11   1 0     0   0   14 16                 30
1749056 CO     school 805850 2190   West End RE-2 80585001398 6196 Naturita Elementary School   Regular School No Elementary PK 06 2021   grade_6 9 0 2   0 0     0   0   6 5                       11 9 0 2   0 0     0   0   6 5                 11
1810195 CO     school 805850 2190   West End RE-2 80585001398 6196 Naturita Elementary School   Regular School No Elementary PK 06 2020   grade_6 19 0 1   0 0     0   0   10 10                       20 19 0 1   0 0     0   0   10 10                 20
1810213 CO     school 805850 2190   West End RE-2 80585001693 6718 Paradox Valley Charter School   Regular School Yes Other PK 12 2020   grade_6 5 0 0   0 0     0   0   3 2                       5 5 0 0   0 0     0   0   3 2                 5
1749142 CO     school 807140 2505   Weldon Valley RE-20(J) 80714001217 9352 Weldon Valley Elementary School   Regular School No Elementary PK 06 2021   grade_6 16 1 1   0 0     0   0   8 10                       18 16 1 1   0 0     0   0   8 10                 18
1810281 CO     school 807140 2505   Weldon Valley RE-20(J) 80714001217 9352 Weldon Valley Elementary School   Regular School No Elementary PK 06 2020   grade_6 17 0 1   0 0     0   0   6 12                       18 17 0 1   0 0     0   0   6 12                 18
1750916 CO     school 804020 3140   Weld Re-8 Schools 80402000553 3066 Fort Lupton Middle School   Regular School No Middle 06 08 2021   grade_6 27 0 103   0 1     0   3   77 57                       134 27 0 103   0 1     0   3   77 57                 134
1750937 CO     school 804020 3140   Weld Re-8 Schools 80402006606 7219 Kenneth Homyak PK-8   Regular School No Elementary PK 08 2021   grade_6 19 1 11   0 0     0   1   17 15                       32 19 1 11   0 0     0   1   17 15                 32
1812030 CO     school 804020 3140   Weld Re-8 Schools 80402000553 3066 Fort Lupton Middle School   Regular School No Middle 06 08 2020   grade_6 22 0 118   3 0     0   3   71 75                       146 22 0 118   3 0     0   3   71 75                 146
1812051 CO     school 804020 3140   Weld Re-8 Schools 80402006606 7219 Kenneth Homyak PK-8   Regular School No Elementary PK 08 2020   grade_6 14 0 7   0 0     0   1   13 9                       22 14 0 7   0 0     0   1   13 9                 22
1750499 CO     school 804920 3090   Weld County School District RE-3J 80492001760 1299 Cardinal Community Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_6 19 0 2   0 0     0   0   14 7                       21 19 0 2   0 0     0   0   14 7                 21
1750534 CO     school 804920 3090   Weld County School District RE-3J 80492002026 9347 Weld Central Middle School   Regular School No Middle 06 08 2021   grade_6 82 0 71   1 1     0   5   80 80                       160 82 0 71   1 1     0   5   80 80                 160
1811626 CO     school 804920 3090   Weld County School District RE-3J 80492001760 1299 Cardinal Community Academy Charter School   Regular School Yes Elementary KG 08 2020   grade_6 19 0 2   0 0     0   0   13 8                       21 19 0 2   0 0     0   0   13 8                 21
1811661 CO     school 804920 3090   Weld County School District RE-3J 80492002026 9347 Weld Central Middle School   Regular School No Middle 06 08 2020   grade_6 76 1 95   2 3     0   4   102 79                       181 76 1 95   2 3     0   4   102 79                 181
1750449 CO     school 804200 3080   Weld County RE-1 80420000577 4854 North Valley Middle School   Regular School No Middle 06 08 2021   grade_6 29 0 45   0 0     0   2   39 37                       76 29 0 45   0 0     0   2   39 37                 76
1750461 CO     school 804200 3080   Weld County RE-1 80420000579 7058 South Valley Middle School   Regular School No Middle 06 08 2021   grade_6 31 1 33   0 0     0   0   39 26                       65 31 1 33   0 0     0   0   39 26                 65
1811576 CO     school 804200 3080   Weld County RE-1 80420000577 4854 North Valley Middle School   Regular School No Middle 06 08 2020   grade_6 25 1 44   0 1     0   2   39 34                       73 25 1 44   0 1     0   2   39 34                 73
1811588 CO     school 804200 3080   Weld County RE-1 80420000579 7058 South Valley Middle School   Regular School No Middle 06 08 2020   grade_6 24 0 41   0 0     0   2   35 32                       67 24 0 41   0 0     0   2   35 32                 67
1740559 CO     school 807110 230   Walsh RE-1 80711001215 9222 Walsh Elementary School   Regular School No Elementary PK 06 2021   grade_6 10 0 2   0 0     0   1   5 8                       13 10 0 2   0 0     0   1   5 8                 13
1801590 CO     school 807110 230   Walsh RE-1 80711001215 9222 Walsh Elementary School   Regular School No Elementary PK 06 2020   grade_6 10 0 2   0 0     0   1   5 8                       13 10 0 2   0 0     0   1   5 8                 13
720580 CO     school 800017 3210   WRAY RD-2 80001701817 9729 BUCHANAN MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_6 38 0 12   1 0     0   1   29 23                       52 38 0 12   1 0     0   1   29 23                 52
848147 CO     school 800017 3210   WRAY RD-2 80001701817 9729 BUCHANAN MIDDLE SCHOOL   Regular School No 2.0 05 08 2016   grade_6 36 0 14   0 0     1   0   24 27                       51 36 0 14   0 0     1   0   24 27                 51
1145715 CO     school 800017 3210   WRAY RD-2 80001701817 9729 BUCHANAN MIDDLE SCHOOL   Regular School No 2.0 05 08 2015   grade_6 40.0 1.0 14.0   0.0 0.0     0.0   2.0   26.0 31.0                       57.0 40 1 14   0 0     0   2   26 31                 57
1906528 CO     school 800017 3210   WRAY RD-2 80001701817 9729 BUCHANAN MIDDLE SCHOOL   Regular School No Middle 05 08 2018   grade_6 49 0 12   0 0     0   0   20 41                       61 49 0 12   0 0     0   0   20 41                 61
1943901 CO     school 800017 3210   WRAY RD-2 80001701817 9729 BUCHANAN MIDDLE SCHOOL   Regular School No Middle 05 08 2019   grade_6 32 0 18   1 0     0   0   25 26                       51 32 0 18   1 0     0   0   25 26                 51
719983 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No Other 06 12 2017   grade_6 3 0 5   0 0     0   0   5 3                       8 3 0 5   0 0     0   0   5 3                 8
847553 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No 4.0 06 12 2016   grade_6 4 0 0   0 0     0   0   1 3                       4 4 0 0   0 0     0   0   1 3                 4
1145118 CO     school 807410 3070   WOODLIN R-104 80741001270 9700 WOODLIN ELEMENTARY SCHOOL   Regular School No 1.0 PK 06 2015   grade_6 8.0 0.0 1.0   0.0 0.0     0.0   0.0   4.0 5.0                       9.0 8 0 1   0 0     0   0   4 5                 9
1905928 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2018   grade_6 6 0 0   0 0     0   0   3 3                       6 6 0 0   0 0     0   0   3 3                 6
1943303 CO     school 807410 3070   WOODLIN R-104 80741001271 9704 WOODLIN UNDIVIDED HIGH SCHOOL   Regular School No High 06 12 2019   grade_6 8 1 2   0 0     0   0   3 8                       11 8 1 2   0 0     0   0   3 8                 11
719891 CO     school 807380 3020   WOODLAND PARK RE-2 80738001268 9694 WOODLAND PARK MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 155 3 18   1 1     0   7   92 93                       185 155 3 18   1 1     0   7   92 93                 185
847461 CO     school 807380 3020   WOODLAND PARK RE-2 80738001268 9694 WOODLAND PARK MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 156 0 16   1 1     0   7   107 74                       181 156 0 16   1 1     0   7   107 74                 181
1145032 CO     school 807380 3020   WOODLAND PARK RE-2 80738001268 9694 WOODLAND PARK MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 163.0 2.0 16.0   0.0 0.0     0.0   15.0   90.0 106.0                       196.0 163 2 16   0 0     0   15   90 106                 196
1905836 CO     school 807380 3020   WOODLAND PARK RE-2 80738001268 9694 WOODLAND PARK MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_6 159 4 20   1 0     0   7   97 94                       191 159 4 20   1 0     0   7   97 94                 191
1943211 CO     school 807380 3020   WOODLAND PARK RE-2 80738001268 9694 WOODLAND PARK MIDDLE SCHOOL   Regular School No Middle 06 08 2019   grade_6 160 1 19   0 0     0   10   102 88                       190 160 1 19   0 0     0   10   102 88                 190
720110 CO     school 807350 3100   WINDSOR RE-4 80735006427 7755 SEVERANCE MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 132 0 38   0 1     0   3   87 87                       174 132 0 38   0 1     0   3   87 87                 174
720140 CO     school 807350 3100   WINDSOR RE-4 80735006650 9393 WINDSOR CHARTER ACADEMY MIDDLE AND EARLY COLLEGE HIGH SCHOOL   Regular School Yes Other 06 11 2017   grade_6 84 1 10   0 0     0   2   53 44                       97 84 1 10   0 0     0   2   53 44                 97
720153 CO     school 807350 3100   WINDSOR RE-4 80735001265 9670 WINDSOR MIDDLE SCHOOL   Regular School No Middle 06 08 2017   grade_6 152 2 32   3 1     0   6   92 104                       196 152 2 32   3 1     0   6   92 104                 196
847678 CO     school 807350 3100   WINDSOR RE-4 80735006427 7755 SEVERANCE MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 124 0 33   2 1     0   3   77 86                       163 124 0 33   2 1     0   3   77 86                 163
847707 CO     school 807350 3100   WINDSOR RE-4 80735006650 9393 WINDSOR CHARTER ACADEMY MIDDLE AND EARLY COLLEGE HIGH SCHOOL   Regular School Yes 4.0 06 10 2016   grade_6 90 0 7   0 4     1   2   49 55                       104 90 0 7   0 4     1   2   49 55                 104
847720 CO     school 807350 3100   WINDSOR RE-4 80735001265 9670 WINDSOR MIDDLE SCHOOL   Regular School No 2.0 06 08 2016   grade_6 168 1 33   0 2     0   8   123 89                       212 168 1 33   0 2     0   8   123 89                 212
1145248 CO     school 807350 3100   WINDSOR RE-4 80735006427 7755 SEVERANCE MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 132.0 0.0 34.0   0.0 0.0     0.0   3.0   82.0 87.0                       169.0 132 0 34   0 0     0   3   82 87                 169
1145281 CO     school 807350 3100   WINDSOR RE-4 80735001815 9665 WINDSOR CHARTER ACADEMY   Regular School Yes 1.0 KG 08 2015   grade_6 41.0 0.0 5.0   0.0 2.0     0.0   1.0   15.0 34.0                       49.0 41 0 5   0 2     0   1   15 34                 49
1145287 CO     school 807350 3100   WINDSOR RE-4 80735001265 9670 WINDSOR MIDDLE SCHOOL   Regular School No 2.0 06 08 2015   grade_6 162.0 2.0 26.0   1.0 1.0     0.0   4.0   113.0 83.0                       196.0 162 2 26   1 1     0   4   113 83                 196
1906053 CO     school 807350 3100   WINDSOR RE-4 80735006427 7755 SEVERANCE MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_6 131 0 34   0 5     0   5   98 77                       175 131 0 34   0 5     0   5   98 77                 175
1906084 CO     school 807350 3100   WINDSOR RE-4 80735006650 9393 WINDSOR CHARTER ACADEMY MIDDLE AND EARLY COLLEGE HIGH SCHOOL   Regular School Yes High 06 12 2018   grade_6 83 1 14   0 4     0   4   49 57                       106 83 1 14   0 4     0   4   49 57                 106
1906097 CO     school 807350 3100   WINDSOR RE-4 80735001265 9670 WINDSOR MIDDLE SCHOOL   Regular School No Middle 06 08 2018   grade_6 181 0 26   0 3     0   11   128 93                       221 181 0 26   0 3     0   11   128 93                 221

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