Data source: Big Local News · About: Big Local

13,207 rows where state = "CO" and year = 2017 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2017 · 13,107
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
718668 CO     school 802610 2395   BRUSH RE-2(J) 80261000156 8832 THOMSON PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   kindergarten_full_day 67 0 55   0 0     0   0   66 56                       122 67 0 55   0 0     0   0   66 56                 122
718669 CO     school 802610 2395   BRUSH RE-2(J) 80261000156 8832 THOMSON PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   pk_12_total 230 1 186   0 0     0   2   219 200                       419 230 1 186   0 0     0   2   219 200                 419
718670 CO     school 802610 2395   BRUSH RE-2(J) 80261000156 8832 THOMSON PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   pre_kindergarten 40 0 30   0 0     0   1   35 36                       71 40 0 30   0 0     0   1   35 36                 71
718750 CO     school 805130 2520   EAST OTERO R-1 80513001975 4843 LA JUNTA PRIMARY SCHOOL   Regular School No Elementary KG 02 2017   grade_1 32 1 66   1 0     0   4   46 58                       104 32 1 66   1 0     0   4   46 58                 104
718751 CO     school 805130 2520   EAST OTERO R-1 80513001975 4843 LA JUNTA PRIMARY SCHOOL   Regular School No Elementary KG 02 2017   grade_2 24 0 71   1 0     1   2   54 45                       99 24 0 71   1 0     1   2   54 45                 99
718752 CO     school 805130 2520   EAST OTERO R-1 80513001975 4843 LA JUNTA PRIMARY SCHOOL   Regular School No Elementary KG 02 2017   kindergarten_full_day 33 2 73   1 0     0   1   45 65                       110 33 2 73   1 0     0   1   45 65                 110
718753 CO     school 805130 2520   EAST OTERO R-1 80513001975 4843 LA JUNTA PRIMARY SCHOOL   Regular School No Elementary KG 02 2017   pk_12_total 89 3 210   3 0     1   7   145 168                       313 89 3 210   3 0     1   7   145 168                 313
718773 CO     school 806270 2530   ROCKY FORD R-2 80627001104 9264 WASHINGTON PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   grade_1 13 0 42   1 0     0   0   25 31                       56 13 0 42   1 0     0   0   25 31                 56
718774 CO     school 806270 2530   ROCKY FORD R-2 80627001104 9264 WASHINGTON PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 12 0 50   0 1     0   0   42 21                       63 12 0 50   0 1     0   0   42 21                 63
718775 CO     school 806270 2530   ROCKY FORD R-2 80627001104 9264 WASHINGTON PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   kindergarten_full_day 18 0 56   0 0     0   1   28 47                       75 18 0 56   0 0     0   1   28 47                 75
718776 CO     school 806270 2530   ROCKY FORD R-2 80627001104 9264 WASHINGTON PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   pk_12_total 52 0 170   1 1     0   2   118 108                       226 52 0 170   1 1     0   2   118 108                 226
718777 CO     school 806270 2530   ROCKY FORD R-2 80627001104 9264 WASHINGTON PRIMARY SCHOOL   Regular School No Elementary PK 02 2017   pre_kindergarten 9 0 22   0 0     0   1   23 9                       32 9 0 22   0 0     0   1   23 9                 32
719037 CO     school 805220 2660   LAMAR RE-2 80522000865 9268 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   grade_1 31 0 60   0 0     0   2   47 46                       93 31 0 60   0 0     0   2   47 46                 93
719038 CO     school 805220 2660   LAMAR RE-2 80522000865 9268 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   grade_2 29 0 72   1 0     0   2   62 42                       104 29 0 72   1 0     0   2   62 42                 104
719039 CO     school 805220 2660   LAMAR RE-2 80522000865 9268 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   kindergarten_full_day 24 1 43   0 0     0   0   37 31                       68 24 1 43   0 0     0   0   37 31                 68
719040 CO     school 805220 2660   LAMAR RE-2 80522000865 9268 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   kindergarten_half_day 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
719041 CO     school 805220 2660   LAMAR RE-2 80522000865 9268 WASHINGTON ELEMENTARY SCHOOL   Regular School No Elementary KG 02 2017   pk_12_total 85 1 175   1 0     0   4   147 119                       266 85 1 175   1 0     0   4   147 119                 266
719739 CO     school 806870 2830   TELLURIDE R-1 80687006699 8811 TELLURIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_1 34 1 12   0 0     0   4   26 25                       51 34 1 12   0 0     0   4   26 25                 51
719740 CO     school 806870 2830   TELLURIDE R-1 80687006699 8811 TELLURIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 56 0 13   0 0     0   3   43 29                       72 56 0 13   0 0     0   3   43 29                 72
719741 CO     school 806870 2830   TELLURIDE R-1 80687006699 8811 TELLURIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   kindergarten_full_day 2 0 8   0 0     0   0   3 7                       10 2 0 8   0 0     0   0   3 7                 10
719742 CO     school 806870 2830   TELLURIDE R-1 80687006699 8811 TELLURIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   kindergarten_half_day 43 0 7   0 0     0   0   29 21                       50 43 0 7   0 0     0   0   29 21                 50
719743 CO     school 806870 2830   TELLURIDE R-1 80687006699 8811 TELLURIDE ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   pk_12_total 135 1 40   0 0     0   7   101 82                       183 135 1 40   0 0     0   7   101 82                 183
720029 CO     school 803600 3085   EATON RE-2 80360000474 2448 EATON ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_1 91 0 28   0 0     0   5   66 58                       124 91 0 28   0 0     0   5   66 58                 124
720030 CO     school 803600 3085   EATON RE-2 80360000474 2448 EATON ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 93 0 22   0 1     0   5   62 59                       121 93 0 22   0 1     0   5   62 59                 121
720031 CO     school 803600 3085   EATON RE-2 80360000474 2448 EATON ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   kindergarten_full_day 74 1 29   0 2     0   5   48 63                       111 74 1 29   0 2     0   5   48 63                 111
720032 CO     school 803600 3085   EATON RE-2 80360000474 2448 EATON ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   pk_12_total 258 1 79   0 3     0   15   176 180                       356 258 1 79   0 3     0   15   176 180                 356
720132 CO     school 807350 3100   WINDSOR RE-4 80735001263 8886 TOZER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_1 104 1 24   0 0     0   3   72 60                       132 104 1 24   0 0     0   3   72 60                 132
720133 CO     school 807350 3100   WINDSOR RE-4 80735001263 8886 TOZER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   grade_2 87 2 20   1 2     0   3   51 64                       115 87 2 20   1 2     0   3   51 64                 115
720134 CO     school 807350 3100   WINDSOR RE-4 80735001263 8886 TOZER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   kindergarten_full_day 54 1 16   0 3     0   1   36 39                       75 54 1 16   0 3     0   1   36 39                 75
720135 CO     school 807350 3100   WINDSOR RE-4 80735001263 8886 TOZER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   kindergarten_half_day 42 0 8   0 0     0   1   27 24                       51 42 0 8   0 0     0   1   27 24                 51
720136 CO     school 807350 3100   WINDSOR RE-4 80735001263 8886 TOZER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   pk_12_total 320 5 87   2 5     0   11   220 210                       430 320 5 87   2 5     0   11   220 210                 430
720137 CO     school 807350 3100   WINDSOR RE-4 80735001263 8886 TOZER ELEMENTARY SCHOOL   Regular School No Elementary PK 02 2017   pre_kindergarten 33 1 19   1 0     0   3   34 23                       57 33 1 19   1 0     0   3   34 23                 57
707948 CO     school 805550 10   MAPLETON 1 80555006673 3623 GLOBAL PRIMARY ACADEMY   Regular School No Elementary PK 03 2017   grade_1 3 0 38   0 0     0   0   19 22                       41 3 0 38   0 0     0   0   19 22                 41
707949 CO     school 805550 10   MAPLETON 1 80555006673 3623 GLOBAL PRIMARY ACADEMY   Regular School No Elementary PK 03 2017   grade_2 2 0 49   1 0     0   1   30 23                       53 2 0 49   1 0     0   1   30 23                 53
707950 CO     school 805550 10   MAPLETON 1 80555006673 3623 GLOBAL PRIMARY ACADEMY   Regular School No Elementary PK 03 2017   grade_3 4 0 42   0 0     0   0   24 22                       46 4 0 42   0 0     0   0   24 22                 46
707951 CO     school 805550 10   MAPLETON 1 80555006673 3623 GLOBAL PRIMARY ACADEMY   Regular School No Elementary PK 03 2017   kindergarten_full_day 3 0 33   0 0     0   0   20 16                       36 3 0 33   0 0     0   0   20 16                 36
707952 CO     school 805550 10   MAPLETON 1 80555006673 3623 GLOBAL PRIMARY ACADEMY   Regular School No Elementary PK 03 2017   pk_12_total 18 0 205   1 2     0   1   118 109                       227 18 0 205   1 2     0   1   118 109                 227
707953 CO     school 805550 10   MAPLETON 1 80555006673 3623 GLOBAL PRIMARY ACADEMY   Regular School No Elementary PK 03 2017   pre_kindergarten 6 0 43   0 2     0   0   25 26                       51 6 0 43   0 2     0   0   25 26                 51
711171 CO     school 803210 770   CROWLEY COUNTY RE-1-J 80321000283 2050 CROWLEY COUNTY PRIMARY   Regular School No Elementary KG 03 2017   grade_1 2 0 30   0 0     0   0   17 15                       32 2 0 30   0 0     0   0   17 15                 32
711172 CO     school 803210 770   CROWLEY COUNTY RE-1-J 80321000283 2050 CROWLEY COUNTY PRIMARY   Regular School No Elementary KG 03 2017   grade_2 1 1 28   0 0     0   0   6 24                       30 1 1 28   0 0     0   0   6 24                 30
711173 CO     school 803210 770   CROWLEY COUNTY RE-1-J 80321000283 2050 CROWLEY COUNTY PRIMARY   Regular School No Elementary KG 03 2017   grade_3 1 2 34   0 0     0   0   18 19                       37 1 2 34   0 0     0   0   18 19                 37
711174 CO     school 803210 770   CROWLEY COUNTY RE-1-J 80321000283 2050 CROWLEY COUNTY PRIMARY   Regular School No Elementary KG 03 2017   kindergarten_full_day 0 0 31   0 0     0   0   23 8                       31 0 0 31   0 0     0   0   23 8                 31
711175 CO     school 803210 770   CROWLEY COUNTY RE-1-J 80321000283 2050 CROWLEY COUNTY PRIMARY   Regular School No Elementary KG 03 2017   pk_12_total 4 3 123   0 0     0   0   64 66                       130 4 3 123   0 0     0   0   64 66                 130
711921 CO     school 803360 880   DENVER COUNTY 1 80336006609 4049 HIGHLINE ACADEMY NORTHEAST   Regular School Yes Elementary PK 03 2017   grade_1 17 22 30   0 5     0   7   36 45                       81 17 22 30   0 5     0   7   36 45                 81
711922 CO     school 803360 880   DENVER COUNTY 1 80336006609 4049 HIGHLINE ACADEMY NORTHEAST   Regular School Yes Elementary PK 03 2017   grade_2 21 17 34   0 2     0   10   43 41                       84 21 17 34   0 2     0   10   43 41                 84
711923 CO     school 803360 880   DENVER COUNTY 1 80336006609 4049 HIGHLINE ACADEMY NORTHEAST   Regular School Yes Elementary PK 03 2017   grade_3 11 14 25   0 2     0   5   39 18                       57 11 14 25   0 2     0   5   39 18                 57
711924 CO     school 803360 880   DENVER COUNTY 1 80336006609 4049 HIGHLINE ACADEMY NORTHEAST   Regular School Yes Elementary PK 03 2017   kindergarten_full_day 17 18 24   0 6     0   7   32 40                       72 17 18 24   0 6     0   7   32 40                 72
711925 CO     school 803360 880   DENVER COUNTY 1 80336006609 4049 HIGHLINE ACADEMY NORTHEAST   Regular School Yes Elementary PK 03 2017   pk_12_total 76 88 130   0 18     0   30   180 162                       342 76 88 130   0 18     0   30   180 162                 342
711926 CO     school 803360 880   DENVER COUNTY 1 80336006609 4049 HIGHLINE ACADEMY NORTHEAST   Regular School Yes Elementary PK 03 2017   pre_kindergarten 10 17 17   0 3     0   1   30 18                       48 10 17 17   0 3     0   1   30 18                 48
712326 CO     school 803360 880   DENVER COUNTY 1 80336006641 7243 REACH CHARTER SCHOOL   Regular School Yes Elementary PK 03 2017   grade_1 20 1 3   2 2     0   2   19 11                       30 20 1 3   2 2     0   2   19 11                 30
712327 CO     school 803360 880   DENVER COUNTY 1 80336006641 7243 REACH CHARTER SCHOOL   Regular School Yes Elementary PK 03 2017   grade_2 3 1 1   0 0     0   0   2 3                       5 3 1 1   0 0     0   0   2 3                 5
712328 CO     school 803360 880   DENVER COUNTY 1 80336006641 7243 REACH CHARTER SCHOOL   Regular School Yes Elementary PK 03 2017   grade_3 4 0 1   0 1     0   2   5 3                       8 4 0 1   0 1     0   2   5 3                 8
712329 CO     school 803360 880   DENVER COUNTY 1 80336006641 7243 REACH CHARTER SCHOOL   Regular School Yes Elementary PK 03 2017   kindergarten_full_day 11 2 1   0 2     0   2   12 6                       18 11 2 1   0 2     0   2   12 6                 18
712330 CO     school 803360 880   DENVER COUNTY 1 80336006641 7243 REACH CHARTER SCHOOL   Regular School Yes Elementary PK 03 2017   pk_12_total 63 6 15   2 5     0   10   60 41                       101 63 6 15   2 5     0   10   60 41                 101
712331 CO     school 803360 880   DENVER COUNTY 1 80336006641 7243 REACH CHARTER SCHOOL   Regular School Yes Elementary PK 03 2017   pre_kindergarten 25 2 9   0 0     0   4   22 18                       40 25 2 9   0 0     0   4   22 18                 40
712490 CO     school 803360 880   DENVER COUNTY 1 80336006627 8401 STRIVE PREP - RUBY HILL   Regular School Yes Elementary KG 03 2017   grade_1 4 1 83   0 2     0   1   37 54                       91 4 1 83   0 2     0   1   37 54                 91
712491 CO     school 803360 880   DENVER COUNTY 1 80336006627 8401 STRIVE PREP - RUBY HILL   Regular School Yes Elementary KG 03 2017   grade_2 1 1 91   0 1     1   0   40 55                       95 1 1 91   0 1     1   0   40 55                 95
712492 CO     school 803360 880   DENVER COUNTY 1 80336006627 8401 STRIVE PREP - RUBY HILL   Regular School Yes Elementary KG 03 2017   grade_3 7 0 85   0 3     0   1   51 45                       96 7 0 85   0 3     0   1   51 45                 96
712493 CO     school 803360 880   DENVER COUNTY 1 80336006627 8401 STRIVE PREP - RUBY HILL   Regular School Yes Elementary KG 03 2017   kindergarten_full_day 6 2 77   0 3     0   0   46 42                       88 6 2 77   0 3     0   0   46 42                 88
712494 CO     school 803360 880   DENVER COUNTY 1 80336006627 8401 STRIVE PREP - RUBY HILL   Regular School Yes Elementary KG 03 2017   pk_12_total 18 4 336   0 9     1   2   174 196                       370 18 4 336   0 9     1   2   174 196                 370
715620 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006164 950 BRADFORD PRIMARY SCHOOL   Regular School No Elementary KG 03 2017   grade_1 96 1 4   0 1     1   3   56 50                       106 96 1 4   0 1     1   3   56 50                 106
715621 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006164 950 BRADFORD PRIMARY SCHOOL   Regular School No Elementary KG 03 2017   grade_2 100 0 5   0 2     0   5   58 54                       112 100 0 5   0 2     0   5   58 54                 112
715622 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006164 950 BRADFORD PRIMARY SCHOOL   Regular School No Elementary KG 03 2017   grade_3 87 1 8   0 2     0   4   47 55                       102 87 1 8   0 2     0   4   47 55                 102
715623 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006164 950 BRADFORD PRIMARY SCHOOL   Regular School No Elementary KG 03 2017   kindergarten_full_day 88 0 6   0 1     0   3   58 40                       98 88 0 6   0 1     0   3   58 40                 98
715624 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006164 950 BRADFORD PRIMARY SCHOOL   Regular School No Elementary KG 03 2017   kindergarten_half_day 17 0 0   0 1     0   0   12 6                       18 17 0 0   0 1     0   0   12 6                 18
715625 CO     school 804800 1420   JEFFERSON COUNTY R-1 80480006164 950 BRADFORD PRIMARY SCHOOL   Regular School No Elementary KG 03 2017   pk_12_total 388 2 23   0 7     1   15   231 205                       436 388 2 23   0 7     1   15   231 205                 436
719187 CO     school 806120 2690   PUEBLO CITY 60 80612006378 2620 FOUNTAIN INTERNATIONAL MAGNET SCHOOL   Regular School No Elementary PK 03 2017   grade_1 39 4 54   1 2     0   0   43 57                       100 39 4 54   1 2     0   0   43 57                 100
719188 CO     school 806120 2690   PUEBLO CITY 60 80612006378 2620 FOUNTAIN INTERNATIONAL MAGNET SCHOOL   Regular School No Elementary PK 03 2017   grade_2 39 0 55   0 3     0   2   49 50                       99 39 0 55   0 3     0   2   49 50                 99
719189 CO     school 806120 2690   PUEBLO CITY 60 80612006378 2620 FOUNTAIN INTERNATIONAL MAGNET SCHOOL   Regular School No Elementary PK 03 2017   grade_3 54 2 45   0 1     0   0   48 54                       102 54 2 45   0 1     0   0   48 54                 102
719190 CO     school 806120 2690   PUEBLO CITY 60 80612006378 2620 FOUNTAIN INTERNATIONAL MAGNET SCHOOL   Regular School No Elementary PK 03 2017   kindergarten_full_day 42 0 56   1 0     0   0   45 54                       99 42 0 56   1 0     0   0   45 54                 99
719191 CO     school 806120 2690   PUEBLO CITY 60 80612006378 2620 FOUNTAIN INTERNATIONAL MAGNET SCHOOL   Regular School No Elementary PK 03 2017   pk_12_total 174 6 210   2 6     0   2   185 215                       400 174 6 210   2 6     0   2   185 215                 400
710010 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000038 6652 PAGOSA SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   grade_1 73 1 42   3 2     0   7   73 55                       128 73 1 42   3 2     0   7   73 55                 128
710011 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000038 6652 PAGOSA SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   grade_2 49 0 58   3 0     0   1   64 47                       111 49 0 58   3 0     0   1   64 47                 111
710012 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000038 6652 PAGOSA SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   grade_3 57 1 53   3 2     0   7   58 65                       123 57 1 53   3 2     0   7   58 65                 123
710013 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000038 6652 PAGOSA SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   grade_4 69 0 58   4 1     0   5   75 62                       137 69 0 58   4 1     0   5   75 62                 137
710014 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000038 6652 PAGOSA SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   kindergarten_full_day 65 3 36   2 2     0   1   61 48                       109 65 3 36   2 2     0   1   61 48                 109
710015 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000038 6652 PAGOSA SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   kindergarten_half_day 7 0 2   0 0     0   0   3 6                       9 7 0 2   0 0     0   0   3 6                 9
710016 CO     school 802190 220   ARCHULETA COUNTY 50 JT 80219000038 6652 PAGOSA SPRINGS ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   pk_12_total 320 5 249   15 7     0   21   334 283                       617 320 5 249   15 7     0   21   334 283                 617
710442 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_1 15 1 34   0 0     0   4   25 29                       54 15 1 34   0 0     0   4   25 29                 54
710443 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 21 1 28   0 0     0   2   24 28                       52 21 1 28   0 0     0   2   24 28                 52
710444 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_3 18 0 32   0 0     0   0   24 26                       50 18 0 32   0 0     0   0   24 26                 50
710445 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_4 19 0 40   0 1     0   2   27 35                       62 19 0 40   0 1     0   2   27 35                 62
710446 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   kindergarten_full_day 28 0 33   1 0     0   2   35 29                       64 28 0 33   1 0     0   2   35 29                 64
710447 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   pk_12_total 133 2 200   2 3     0   14   172 182                       354 133 2 200   2 3     0   14   172 182                 354
710448 CO     school 805370 470   ST VRAIN VALLEY RE 1J 80537000916 6156 MOUNTAIN VIEW ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   pre_kindergarten 32 0 33   1 2     0   4   37 35                       72 32 0 33   1 2     0   4   37 35                 72
710994 CO     school 806330 500   SALIDA R-32 80633001108 5268 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   grade_1 63 0 12   0 0     0   3   43 35                       78 63 0 12   0 0     0   3   43 35                 78
710995 CO     school 806330 500   SALIDA R-32 80633001108 5268 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   grade_2 75 2 14   0 0     0   5   45 51                       96 75 2 14   0 0     0   5   45 51                 96
710996 CO     school 806330 500   SALIDA R-32 80633001108 5268 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   grade_3 77 0 12   0 0     0   4   49 44                       93 77 0 12   0 0     0   4   49 44                 93
710997 CO     school 806330 500   SALIDA R-32 80633001108 5268 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   grade_4 70 1 9   0 0     0   3   40 43                       83 70 1 9   0 0     0   3   40 43                 83
710998 CO     school 806330 500   SALIDA R-32 80633001108 5268 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   kindergarten_full_day 60 1 13   0 1     0   4   40 39                       79 60 1 13   0 1     0   4   40 39                 79
710999 CO     school 806330 500   SALIDA R-32 80633001108 5268 LONGFELLOW ELEMENTARY SCHOOL   Regular School No Elementary KG 04 2017   pk_12_total 345 4 60   0 1     0   19   217 212                       429 345 4 60   0 1     0   19   217 212                 429
715189 CO     school 804260 1180   ROARING FORK RE-1 80426000582 560 BASALT ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_1 41 0 63   0 0     0   4   57 51                       108 41 0 63   0 0     0   4   57 51                 108
715190 CO     school 804260 1180   ROARING FORK RE-1 80426000582 560 BASALT ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_2 45 0 63   0 2     0   1   55 56                       111 45 0 63   0 2     0   1   55 56                 111
715191 CO     school 804260 1180   ROARING FORK RE-1 80426000582 560 BASALT ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_3 43 0 73   1 1     0   3   58 63                       121 43 0 73   1 1     0   3   58 63                 121
715192 CO     school 804260 1180   ROARING FORK RE-1 80426000582 560 BASALT ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_4 51 1 70   0 2     0   0   68 56                       124 51 1 70   0 2     0   0   68 56                 124
715193 CO     school 804260 1180   ROARING FORK RE-1 80426000582 560 BASALT ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   kindergarten_full_day 46 0 60   0 2     0   0   58 50                       108 46 0 60   0 2     0   0   58 50                 108
715194 CO     school 804260 1180   ROARING FORK RE-1 80426000582 560 BASALT ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   kindergarten_half_day 4 0 1   0 0     0   0   2 3                       5 4 0 1   0 0     0   0   2 3                 5
715195 CO     school 804260 1180   ROARING FORK RE-1 80426000582 560 BASALT ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   pk_12_total 243 1 359   2 8     0   8   327 294                       621 243 1 359   2 8     0   8   327 294                 621
715196 CO     school 804260 1180   ROARING FORK RE-1 80426000582 560 BASALT ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   pre_kindergarten 13 0 29   1 1     0   0   29 15                       44 13 0 29   1 1     0   0   29 15                 44
715216 CO     school 804260 1180   ROARING FORK RE-1 80426001540 2063 CRYSTAL RIVER ELEMENTARY SCHOOL   Regular School No Elementary PK 04 2017   grade_1 29 2 53   0 0     0   2   44 42                       86 29 2 53   0 0     0   2   44 42                 86

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