Data source: Big Local News · About: Big Local

92,494 rows where state = "CO" sorted by district_state_id descending

View and edit SQL

grade

year

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
1139093 CO     school 806480 990   WIDEFIELD 3 80648001124 8122 VENETUCCI ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_1 37.0 8.0 20.0   0.0 1.0     0.0   16.0   44.0 38.0                       82.0 37 8 20   0 1     0   16   44 38                 82
1139094 CO     school 806480 990   WIDEFIELD 3 80648001124 8122 VENETUCCI ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 27.0 10.0 25.0   0.0 0.0     3.0   7.0   38.0 34.0                       72.0 27 10 25   0 0     3   7   38 34                 72
1139095 CO     school 806480 990   WIDEFIELD 3 80648001124 8122 VENETUCCI ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_3 29.0 6.0 30.0   0.0 1.0     0.0   5.0   37.0 34.0                       71.0 29 6 30   0 1     0   5   37 34                 71
1139096 CO     school 806480 990   WIDEFIELD 3 80648001124 8122 VENETUCCI ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_4 29.0 5.0 23.0   1.0 1.0     2.0   7.0   27.0 41.0                       68.0 29 5 23   1 1     2   7   27 41                 68
1139097 CO     school 806480 990   WIDEFIELD 3 80648001124 8122 VENETUCCI ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_5 40.0 6.0 22.0   1.0 3.0     0.0   11.0   45.0 38.0                       83.0 40 6 22   1 3     0   11   45 38                 83
1139098 CO     school 806480 990   WIDEFIELD 3 80648001124 8122 VENETUCCI ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   kindergarten_full_day 34.0 10.0 19.0   1.0 3.0     2.0   5.0   44.0 30.0                       74.0 34 10 19   1 3     2   5   44 30                 74
1139099 CO     school 806480 990   WIDEFIELD 3 80648001124 8122 VENETUCCI ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   kindergarten_half_day 1.0 0.0 0.0   0.0 0.0     0.0   0.0   0.0 1.0                       1.0 1 0 0   0 0     0   0   0 1                 1
1139100 CO     school 806480 990   WIDEFIELD 3 80648001124 8122 VENETUCCI ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   pk_12_total 197.0 45.0 139.0   3.0 9.0     7.0   51.0   235.0 216.0                       451.0 197 45 139   3 9     7   51   235 216                 451
1139101 CO     school 806480 990   WIDEFIELD 3 80648001125 8178 SPROUL JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2015   grade_6 84.0 19.0 68.0   1.0 1.0     7.0   12.0   95.0 97.0                       192.0 84 19 68   1 1     7   12   95 97                 192
1139102 CO     school 806480 990   WIDEFIELD 3 80648001125 8178 SPROUL JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2015   grade_7 97.0 19.0 57.0   0.0 0.0     0.0   18.0   101.0 90.0                       191.0 97 19 57   0 0     0   18   101 90                 191
1139103 CO     school 806480 990   WIDEFIELD 3 80648001125 8178 SPROUL JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2015   grade_8 98.0 12.0 63.0   2.0 1.0     4.0   23.0   96.0 107.0                       203.0 98 12 63   2 1     4   23   96 107                 203
1139104 CO     school 806480 990   WIDEFIELD 3 80648001125 8178 SPROUL JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2015   pk_12_total 279.0 50.0 188.0   3.0 2.0     11.0   53.0   292.0 294.0                       586.0 279 50 188   3 2     11   53   292 294                 586
1139105 CO     school 806480 990   WIDEFIELD 3 80648001418 8392 SUNRISE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_1 55.0 6.0 21.0   0.0 3.0     1.0   15.0   52.0 49.0                       101.0 55 6 21   0 3     1   15   52 49                 101
1139106 CO     school 806480 990   WIDEFIELD 3 80648001418 8392 SUNRISE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 56.0 7.0 28.0   0.0 2.0     1.0   12.0   57.0 49.0                       106.0 56 7 28   0 2     1   12   57 49                 106
1139107 CO     school 806480 990   WIDEFIELD 3 80648001418 8392 SUNRISE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_3 51.0 14.0 27.0   1.0 3.0     3.0   14.0   54.0 59.0                       113.0 51 14 27   1 3     3   14   54 59                 113
1139108 CO     school 806480 990   WIDEFIELD 3 80648001418 8392 SUNRISE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_4 59.0 11.0 26.0   0.0 4.0     2.0   10.0   56.0 56.0                       112.0 59 11 26   0 4     2   10   56 56                 112
1139109 CO     school 806480 990   WIDEFIELD 3 80648001418 8392 SUNRISE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_5 55.0 8.0 24.0   0.0 0.0     1.0   15.0   54.0 49.0                       103.0 55 8 24   0 0     1   15   54 49                 103
1139110 CO     school 806480 990   WIDEFIELD 3 80648001418 8392 SUNRISE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   kindergarten_full_day 43.0 9.0 19.0   0.0 2.0     0.0   8.0   49.0 32.0                       81.0 43 9 19   0 2     0   8   49 32                 81
1139111 CO     school 806480 990   WIDEFIELD 3 80648001418 8392 SUNRISE ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   pk_12_total 319.0 55.0 145.0   1.0 14.0     8.0   74.0   322.0 294.0                       616.0 319 55 145   1 14     8   74   322 294                 616
1139112 CO     school 806480 990   WIDEFIELD 3 80648001126 9294 WATSON JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2015   grade_6 116.0 18.0 67.0   1.0 4.0     5.0   19.0   104.0 126.0                       230.0 116 18 67   1 4     5   19   104 126                 230
1139113 CO     school 806480 990   WIDEFIELD 3 80648001126 9294 WATSON JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2015   grade_7 107.0 27.0 50.0   3.0 3.0     2.0   22.0   113.0 101.0                       214.0 107 27 50   3 3     2   22   113 101                 214
1139114 CO     school 806480 990   WIDEFIELD 3 80648001126 9294 WATSON JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2015   grade_8 130.0 21.0 65.0   2.0 7.0     2.0   19.0   131.0 115.0                       246.0 130 21 65   2 7     2   19   131 115                 246
1139115 CO     school 806480 990   WIDEFIELD 3 80648001126 9294 WATSON JUNIOR HIGH SCHOOL   Regular School No 2.0 06 08 2015   pk_12_total 353.0 66.0 182.0   6.0 14.0     9.0   60.0   348.0 342.0                       690.0 353 66 182   6 14     9   60   348 342                 690
1139116 CO     school 806480 990   WIDEFIELD 3 80648001127 9334 WEBSTER ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_1 51.0 6.0 32.0   0.0 3.0     1.0   15.0   59.0 49.0                       108.0 51 6 32   0 3     1   15   59 49                 108
1139117 CO     school 806480 990   WIDEFIELD 3 80648001127 9334 WEBSTER ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 43.0 14.0 33.0   0.0 0.0     4.0   13.0   61.0 46.0                       107.0 43 14 33   0 0     4   13   61 46                 107
1139118 CO     school 806480 990   WIDEFIELD 3 80648001127 9334 WEBSTER ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_3 59.0 9.0 26.0   0.0 2.0     3.0   11.0   60.0 50.0                       110.0 59 9 26   0 2     3   11   60 50                 110
1139119 CO     school 806480 990   WIDEFIELD 3 80648001127 9334 WEBSTER ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_4 70.0 6.0 37.0   0.0 1.0     2.0   10.0   62.0 64.0                       126.0 70 6 37   0 1     2   10   62 64                 126
1139120 CO     school 806480 990   WIDEFIELD 3 80648001127 9334 WEBSTER ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_5 50.0 7.0 29.0   0.0 0.0     4.0   10.0   52.0 48.0                       100.0 50 7 29   0 0     4   10   52 48                 100
1139121 CO     school 806480 990   WIDEFIELD 3 80648001127 9334 WEBSTER ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   kindergarten_full_day 52.0 6.0 32.0   0.0 0.0     1.0   10.0   50.0 51.0                       101.0 52 6 32   0 0     1   10   50 51                 101
1139122 CO     school 806480 990   WIDEFIELD 3 80648001127 9334 WEBSTER ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   pk_12_total 325.0 48.0 189.0   0.0 6.0     15.0   69.0   344.0 308.0                       652.0 325 48 189   0 6     15   69   344 308                 652
1139123 CO     school 806480 990   WIDEFIELD 3 80648000051 9560 DISCOVERY HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_10 5.0 0.0 5.0   0.0 0.0     0.0   0.0   5.0 5.0                       10.0 5 0 5   0 0     0   0   5 5                 10
1139124 CO     school 806480 990   WIDEFIELD 3 80648000051 9560 DISCOVERY HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_11 7.0 2.0 6.0   0.0 0.0     1.0   2.0   10.0 8.0                       18.0 7 2 6   0 0     1   2   10 8                 18
1139125 CO     school 806480 990   WIDEFIELD 3 80648000051 9560 DISCOVERY HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_12 22.0 1.0 10.0   0.0 0.0     1.0   1.0   20.0 15.0                       35.0 22 1 10   0 0     1   1   20 15                 35
1139126 CO     school 806480 990   WIDEFIELD 3 80648000051 9560 DISCOVERY HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   grade_9 0.0 0.0 0.0   0.0 0.0     0.0   1.0   1.0 0.0                       1.0 0 0 0   0 0     0   1   1 0                 1
1139127 CO     school 806480 990   WIDEFIELD 3 80648000051 9560 DISCOVERY HIGH SCHOOL   Alternative Education School No 3.0 09 12 2015   pk_12_total 34.0 3.0 21.0   0.0 0.0     2.0   4.0   36.0 28.0                       64.0 34 3 21   0 0     2   4   36 28                 64
1139128 CO     school 806480 990   WIDEFIELD 3 80648001128 9562 WIDEFIELD ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_1 44.0 4.0 18.0   1.0 1.0     0.0   8.0   32.0 44.0                       76.0 44 4 18   1 1     0   8   32 44                 76
1139129 CO     school 806480 990   WIDEFIELD 3 80648001128 9562 WIDEFIELD ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_2 49.0 5.0 15.0   0.0 0.0     0.0   7.0   43.0 33.0                       76.0 49 5 15   0 0     0   7   43 33                 76
1139130 CO     school 806480 990   WIDEFIELD 3 80648001128 9562 WIDEFIELD ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_3 44.0 2.0 20.0   0.0 0.0     1.0   10.0   36.0 41.0                       77.0 44 2 20   0 0     1   10   36 41                 77
1139131 CO     school 806480 990   WIDEFIELD 3 80648001128 9562 WIDEFIELD ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_4 39.0 5.0 18.0   1.0 1.0     1.0   2.0   36.0 31.0                       67.0 39 5 18   1 1     1   2   36 31                 67
1139132 CO     school 806480 990   WIDEFIELD 3 80648001128 9562 WIDEFIELD ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   grade_5 38.0 6.0 15.0   0.0 1.0     1.0   3.0   35.0 29.0                       64.0 38 6 15   0 1     1   3   35 29                 64
1139133 CO     school 806480 990   WIDEFIELD 3 80648001128 9562 WIDEFIELD ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   kindergarten_full_day 48.0 1.0 13.0   0.0 0.0     0.0   2.0   30.0 34.0                       64.0 48 1 13   0 0     0   2   30 34                 64
1139134 CO     school 806480 990   WIDEFIELD 3 80648001128 9562 WIDEFIELD ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   kindergarten_half_day 0.0 0.0 1.0   0.0 0.0     0.0   0.0   1.0 0.0                       1.0 0 0 1   0 0     0   0   1 0                 1
1139135 CO     school 806480 990   WIDEFIELD 3 80648001128 9562 WIDEFIELD ELEMENTARY SCHOOL   Regular School No 1.0 KG 05 2015   pk_12_total 262.0 23.0 100.0   2.0 3.0     3.0   32.0   213.0 212.0                       425.0 262 23 100   2 3     3   32   213 212                 425
1139136 CO     school 806480 990   WIDEFIELD 3 80648001129 9566 WIDEFIELD HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_10 178.0 29.0 77.0   2.0 4.0     7.0   25.0   152.0 170.0                       322.0 178 29 77   2 4     7   25   152 170                 322
1139137 CO     school 806480 990   WIDEFIELD 3 80648001129 9566 WIDEFIELD HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_11 149.0 29.0 74.0   5.0 5.0     1.0   25.0   134.0 154.0                       288.0 149 29 74   5 5     1   25   134 154                 288
1139138 CO     school 806480 990   WIDEFIELD 3 80648001129 9566 WIDEFIELD HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_12 159.0 41.0 80.0   4.0 12.0     5.0   14.0   163.0 152.0                       315.0 159 41 80   4 12     5   14   163 152                 315
1139139 CO     school 806480 990   WIDEFIELD 3 80648001129 9566 WIDEFIELD HIGH SCHOOL   Regular School No 3.0 09 12 2015   grade_9 162.0 38.0 91.0   3.0 2.0     5.0   32.0   180.0 153.0                       333.0 162 38 91   3 2     5   32   180 153                 333
1139140 CO     school 806480 990   WIDEFIELD 3 80648001129 9566 WIDEFIELD HIGH SCHOOL   Regular School No 3.0 09 12 2015   pk_12_total 648.0 137.0 322.0   14.0 23.0     18.0   96.0   629.0 629.0                       1258.0 648 137 322   14 23     18   96   629 629                 1258
1139141 CO     school 806480 990   WIDEFIELD 3 80648001359 9656 WIDEFIELD DISTRICT 3 PRESCHOOL   Regular School No 1.0 PK PK 2015   pk_12_total 275.0 28.0 102.0   0.0 2.0     1.0   36.0   231.0 213.0                       444.0 275 28 102   0 2     1   36   231 213                 444
1139142 CO     school 806480 990   WIDEFIELD 3 80648001359 9656 WIDEFIELD DISTRICT 3 PRESCHOOL   Regular School No 1.0 PK PK 2015   pre_kindergarten 275.0 28.0 102.0   0.0 2.0     1.0   36.0   231.0 213.0                       444.0 275 28 102   0 2     1   36   231 213                 444
1744321 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2021   grade_1 49 7 30   0 2     3   15   48 58                       106 49 7 30   0 2     3   15   48 58                 106
1744322 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2021   grade_2 43 9 24   0 2     1   15   48 46                       94 43 9 24   0 2     1   15   48 46                 94
1744323 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2021   grade_3 51 9 29   0 2     0   13   53 51                       104 51 9 29   0 2     0   13   53 51                 104
1744324 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2021   grade_4 40 8 34   1 1     1   9   50 44                       94 40 8 34   1 1     1   9   50 44                 94
1744325 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2021   grade_5 36 8 41   3 2     1   10   43 58                       101 36 8 41   3 2     1   10   43 58                 101
1744326 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2021   kindergarten_full_day 43 10 31   0 1     0   6   51 40                       91 43 10 31   0 1     0   6   51 40                 91
1744327 CO     school 806480 990   Widefield 3 80648001458 3234 French Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 262 51 189   4 10     6   68   293 297                       590 262 51 189   4 10     6   68   293 297                 590
1744328 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2021   grade_1 55 13 34   2 0     2   12   70 48                       118 55 13 34   2 0     2   12   70 48                 118
1744329 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2021   grade_2 51 14 32   2 2     0   13   61 53                       114 51 14 32   2 2     0   13   61 53                 114
1744330 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2021   grade_3 48 11 34   0 0     4   12   61 48                       109 48 11 34   0 0     4   12   61 48                 109
1744331 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2021   grade_4 44 10 24   1 3     2   6   47 43                       90 44 10 24   1 3     2   6   47 43                 90
1744332 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2021   grade_5 46 12 49   0 0     1   17   55 70                       125 46 12 49   0 0     1   17   55 70                 125
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
1744334 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2021   grade_7 48 18 25   0 3     3   12   47 62                       109 48 18 25   0 3     3   12   47 62                 109
1744335 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2021   grade_8 38 11 26   1 4     3   11   50 44                       94 38 11 26   1 4     3   11   50 44                 94
1744336 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2021   kindergarten_full_day 52 14 27   0 4     1   8   47 59                       106 52 14 27   0 4     1   8   47 59                 106
1744337 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2021   kindergarten_half_day 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1744338 CO     school 806480 990   Widefield 3 80648006772 3692 Grand Mountain School   Regular School No Elementary PK 08 2021   pk_12_total 422 113 289   7 18     21   104   498 476                       974 422 113 289   7 18     21   104   498 476                 974
1744339 CO     school 806480 990   Widefield 3 80648001119 4346 Talbott STEAM Innovation School   Regular School No Elementary KG 05 2021   grade_1 41 4 15   0 0     1   4   35 30                       65 41 4 15   0 0     1   4   35 30                 65
1744340 CO     school 806480 990   Widefield 3 80648001119 4346 Talbott STEAM Innovation School   Regular School No Elementary KG 05 2021   grade_2 28 5 15   0 0     0   2   25 25                       50 28 5 15   0 0     0   2   25 25                 50
1744341 CO     school 806480 990   Widefield 3 80648001119 4346 Talbott STEAM Innovation School   Regular School No Elementary KG 05 2021   grade_3 42 4 19   0 1     1   6   40 33                       73 42 4 19   0 1     1   6   40 33                 73
1744342 CO     school 806480 990   Widefield 3 80648001119 4346 Talbott STEAM Innovation School   Regular School No Elementary KG 05 2021   grade_4 36 5 15   0 1     0   4   38 23                       61 36 5 15   0 1     0   4   38 23                 61
1744343 CO     school 806480 990   Widefield 3 80648001119 4346 Talbott STEAM Innovation School   Regular School No Elementary KG 05 2021   grade_5 27 4 9   0 1     0   5   17 29                       46 27 4 9   0 1     0   5   17 29                 46
1744344 CO     school 806480 990   Widefield 3 80648001119 4346 Talbott STEAM Innovation School   Regular School No Elementary KG 05 2021   kindergarten_full_day 32 3 12   0 1     1   3   29 23                       52 32 3 12   0 1     1   3   29 23                 52
1744345 CO     school 806480 990   Widefield 3 80648001119 4346 Talbott STEAM Innovation School   Regular School No Elementary KG 05 2021   pk_12_total 206 25 85   0 4     3   24   184 163                       347 206 25 85   0 4     3   24   184 163                 347
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
1744347 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2021   grade_7 106 15 63   1 3     4   24   112 104                       216 106 15 63   1 3     4   24   112 104                 216
1744348 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2021   grade_8 83 24 84   0 4     5   34   125 109                       234 83 24 84   0 4     5   34   125 109                 234
1744349 CO     school 806480 990   Widefield 3 80648001120 4394 Janitell Junior High School   Regular School No Middle 06 08 2021   pk_12_total 284 59 217   3 11     11   79   359 305                       664 284 59 217   3 11     11   79   359 305                 664
1744350 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2021   grade_1 2 0 3   0 0     0   3   3 5                       8 2 0 3   0 0     0   3   3 5                 8
1744351 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2021   grade_2 4 1 6   0 0     2   2   6 9                       15 4 1 6   0 0     2   2   6 9                 15
1744352 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2021   grade_3 6 1 1   0 0     0   4   7 5                       12 6 1 1   0 0     0   4   7 5                 12
1744353 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2021   grade_4 9 1 3   0 0     0   2   6 9                       15 9 1 3   0 0     0   2   6 9                 15
1744354 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2021   grade_5 1 0 2   0 0     0   1   2 2                       4 1 0 2   0 0     0   1   2 2                 4
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
1744356 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2021   grade_7 3 0 4   0 0     0   1   7 1                       8 3 0 4   0 0     0   1   7 1                 8
1744357 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2021   grade_8 4 0 3   0 0     1   4   11 1                       12 4 0 3   0 0     1   4   11 1                 12
1744358 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2021   kindergarten_full_day 4 2 4   0 0     0   1   5 6                       11 4 2 4   0 0     0   1   5 6                 11
1744359 CO     school 806480 990   Widefield 3 80648001885 5033 James Madison Charter Academy School   Regular School Yes Elementary KG 08 2021   pk_12_total 37 5 30   0 0     3   19   48 46                       94 37 5 30   0 0     3   19   48 46                 94
1744360 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2021   grade_1 37 5 22   0 2     0   10   34 42                       76 37 5 22   0 2     0   10   34 42                 76
1744361 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2021   grade_2 31 4 22   0 1     2   14   40 34                       74 31 4 22   0 1     2   14   40 34                 74
1744362 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2021   grade_3 35 3 18   0 0     0   7   38 25                       63 35 3 18   0 0     0   7   38 25                 63
1744363 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2021   grade_4 35 9 19   0 1     0   9   33 40                       73 35 9 19   0 1     0   9   33 40                 73
1744364 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2021   grade_5 43 2 20   0 0     0   6   44 27                       71 43 2 20   0 0     0   6   44 27                 71
1744365 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2021   kindergarten_full_day 41 4 25   0 2     0   10   42 40                       82 41 4 25   0 2     0   10   42 40                 82
1744366 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2021   kindergarten_half_day 0 0 0   0 0     0   1   0 1                       1 0 0 0   0 0     0   1   0 1                 1
1744367 CO     school 806480 990   Widefield 3 80648001121 5602 Martin Luther King Jr Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 222 27 126   0 6     2   57   231 209                       440 222 27 126   0 6     2   57   231 209                 440
1744368 CO     school 806480 990   Widefield 3 80648001588 5841 Mesa Ridge High School   Regular School No High 09 12 2021   grade_10 169 26 106   3 5     4   34   175 172                       347 169 26 106   3 5     4   34   175 172                 347
1744369 CO     school 806480 990   Widefield 3 80648001588 5841 Mesa Ridge High School   Regular School No High 09 12 2021   grade_11 126 27 98   2 4     4   28   171 118                       289 126 27 98   2 4     4   28   171 118                 289
1744370 CO     school 806480 990   Widefield 3 80648001588 5841 Mesa Ridge High School   Regular School No High 09 12 2021   grade_12 149 37 82   3 9     6   26   171 141                       312 149 37 82   3 9     6   26   171 141                 312

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