Data source: Big Local News · About: Big Local

13,286 rows where state = "CO" and year = 2021 sorted by district_state_id

View and edit SQL

year

  • 2021 · 13,186
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
1738360 CO     school 805550 10   Mapleton 1 80555006671 695 Big Picture College and Career Academy   Regular School No High 09 12 2021   pk_12_total 26 0 78   1 0     0   8   59 54                       113 26 0 78   1 0     0   8   59 54                 113
1738361 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_1 65 4 25   1 0     0   10   59 46                       105 65 4 25   1 0     0   10   59 46                 105
1738362 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_10 228 12 82   5 5     2   14   164 184                       348 228 12 82   5 5     2   14   164 184                 348
1738363 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_11 202 11 85   1 6     1   19   157 168                       325 202 11 85   1 6     1   19   157 168                 325
1738364 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_12 198 12 63   3 4     0   20   121 179                       300 198 12 63   3 4     0   20   121 179                 300
1738365 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_2 59 6 33   1 3     1   9   63 49                       112 59 6 33   1 3     1   9   63 49                 112
1738366 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_3 72 7 32   1 0     0   2   73 41                       114 72 7 32   1 0     0   2   73 41                 114
1738367 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_4 73 3 25   0 3     1   15   63 57                       120 73 3 25   0 3     1   15   63 57                 120
1738368 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_5 81 7 37   3 2     0   13   73 70                       143 81 7 37   3 2     0   13   73 70                 143
1738369 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_6 91 8 36   0 3     0   18   83 73                       156 91 8 36   0 3     0   18   83 73                 156
1738370 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_7 141 16 46   2 3     0   16   128 96                       224 141 16 46   2 3     0   16   128 96                 224
1738371 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_8 138 9 52   2 2     1   12   102 114                       216 138 9 52   2 2     1   12   102 114                 216
1738372 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   grade_9 186 10 67   0 2     0   11   119 157                       276 186 10 67   0 2     0   11   119 157                 276
1738373 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   kindergarten_full_day 55 4 24   0 3     0   7   40 53                       93 55 4 24   0 3     0   7   40 53                 93
1738374 CO     school 805550 10   Mapleton 1 80555006488 1796 Colorado Connections Academy   Regular School No Other KG 12 2021   pk_12_total 1589 109 607   19 36     6   166   1245 1287                       2532 1589 109 607   19 36     6   166   1245 1287                 2532
1738375 CO     school 805550 10   Mapleton 1 80555006808 2768 Preschool on Poze   Regular School No Prekindergarten PK PK 2021   pk_12_total 14 1 113   0 8     0   5   77 64                       141 14 1 113   0 8     0   5   77 64                 141
1738376 CO     school 805550 10   Mapleton 1 80555006808 2768 Preschool on Poze   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 14 1 113   0 8     0   5   77 64                       141 14 1 113   0 8     0   5   77 64                 141
1738377 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2021   grade_4 2 0 44   0 0     0   1   21 26                       47 2 0 44   0 0     0   1   21 26                 47
1738378 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2021   grade_5 2 0 51   1 0     0   0   27 27                       54 2 0 51   1 0     0   0   27 27                 54
1738379 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2021   grade_6 2 2 54   1 0     0   2   34 27                       61 2 2 54   1 0     0   2   34 27                 61
1738380 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2021   grade_7 4 0 64   0 0     0   1   35 34                       69 4 0 64   0 0     0   1   35 34                 69
1738381 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2021   grade_8 3 1 55   0 1     0   1   28 33                       61 3 1 55   0 1     0   1   28 33                 61
1738382 CO     school 805550 10   Mapleton 1 80555006672 3590 Global Intermediate Academy   Regular School No Middle 04 08 2021   pk_12_total 13 3 268   2 1     0   5   145 147                       292 13 3 268   2 1     0   5   145 147                 292
1738383 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2021   grade_1 6 0 47   0 2     0   1   26 30                       56 6 0 47   0 2     0   1   26 30                 56
1738384 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2021   grade_2 2 0 41   0 1     0   0   25 19                       44 2 0 41   0 1     0   0   25 19                 44
1738385 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2021   grade_3 2 1 45   0 0     0   1   25 24                       49 2 1 45   0 0     0   1   25 24                 49
1738386 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2021   kindergarten_full_day 3 0 45   0 0     0   1   25 24                       49 3 0 45   0 0     0   1   25 24                 49
1738387 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2021   pk_12_total 28 3 225   0 4     0   9   139 130                       269 28 3 225   0 4     0   9   139 130                 269
1738388 CO     school 805550 10   Mapleton 1 80555006673 3623 Global Primary Academy   Regular School No Elementary PK 03 2021   pre_kindergarten 15 2 47   0 1     0   6   38 33                       71 15 2 47   0 1     0   6   38 33                 71
1738389 CO     school 805550 10   Mapleton 1 80555006433 6315 North Valley School for Young Adults   Alternative School No High 09 12 2021   grade_12 15 1 58   1 0     0   2   42 35                       77 15 1 58   1 0     0   2   42 35                 77
1738390 CO     school 805550 10   Mapleton 1 80555006433 6315 North Valley School for Young Adults   Alternative School No High 09 12 2021   pk_12_total 15 1 58   1 0     0   2   42 35                       77 15 1 58   1 0     0   2   42 35                 77
1738391 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_1 12 0 28   0 1     0   1   18 24                       42 12 0 28   0 1     0   1   18 24                 42
1738392 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_2 8 0 43   0 0     0   0   22 29                       51 8 0 43   0 0     0   0   22 29                 51
1738393 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_3 8 0 25   0 0     0   0   17 16                       33 8 0 25   0 0     0   0   17 16                 33
1738394 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_4 5 1 33   0 3     0   2   20 24                       44 5 1 33   0 3     0   2   20 24                 44
1738395 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_5 8 0 35   0 0     0   0   22 21                       43 8 0 35   0 0     0   0   22 21                 43
1738396 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_6 7 0 44   1 0     0   0   26 26                       52 7 0 44   1 0     0   0   26 26                 52
1738397 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_7 7 0 57   0 0     0   1   33 32                       65 7 0 57   0 0     0   1   33 32                 65
1738398 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   grade_8 2 0 57   0 0     0   1   27 33                       60 2 0 57   0 0     0   1   27 33                 60
1738399 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   kindergarten_full_day 12 0 31   1 0     0   1   27 18                       45 12 0 31   1 0     0   1   27 18                 45
1738400 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   pk_12_total 95 1 392   2 5     0   10   240 265                       505 95 1 392   2 5     0   10   240 265                 505
1738401 CO     school 805550 10   Mapleton 1 80555006786 8823 Trailside Academy   Regular School No Elementary PK 08 2021   pre_kindergarten 26 0 39   0 1     0   4   28 42                       70 26 0 39   0 1     0   4   28 42                 70
1739227 CO     school 802070 100   Alamosa RE-11J 80207000026 114 Ortega Middle School   Regular School No Middle 06 08 2021   grade_6 43 0 99   0 1     0   3   75 71                       146 43 0 99   0 1     0   3   75 71                 146
1739228 CO     school 802070 100   Alamosa RE-11J 80207000026 114 Ortega Middle School   Regular School No Middle 06 08 2021   grade_7 28 0 92   1 0     1   0   64 58                       122 28 0 92   1 0     1   0   64 58                 122
1739229 CO     school 802070 100   Alamosa RE-11J 80207000026 114 Ortega Middle School   Regular School No Middle 06 08 2021   grade_8 41 0 85   2 3     0   0   65 66                       131 41 0 85   2 3     0   0   65 66                 131
1739230 CO     school 802070 100   Alamosa RE-11J 80207000026 114 Ortega Middle School   Regular School No Middle 06 08 2021   pk_12_total 112 0 276   3 4     1   3   204 195                       399 112 0 276   3 4     1   3   204 195                 399
1739231 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School 3-5   Regular School No Elementary 03 05 2021   grade_3 42 0 89   1 0     0   2   85 49                       134 42 0 89   1 0     0   2   85 49                 134
1739232 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School 3-5   Regular School No Elementary 03 05 2021   grade_4 31 0 107   0 0     2   5   83 62                       145 31 0 107   0 0     2   5   83 62                 145
1739233 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School 3-5   Regular School No Elementary 03 05 2021   grade_5 47 0 106   0 1     0   6   76 84                       160 47 0 106   0 1     0   6   76 84                 160
1739234 CO     school 802070 100   Alamosa RE-11J 80207006459 115 Alamosa Elementary School 3-5   Regular School No Elementary 03 05 2021   pk_12_total 120 0 302   1 1     2   13   244 195                       439 120 0 302   1 1     2   13   244 195                 439
1739235 CO     school 802070 100   Alamosa RE-11J 80207000027 118 Alamosa High School   Regular School No High 09 12 2021   grade_10 41 0 80   2 2     0   1   62 64                       126 41 0 80   2 2     0   1   62 64                 126
1739236 CO     school 802070 100   Alamosa RE-11J 80207000027 118 Alamosa High School   Regular School No High 09 12 2021   grade_11 25 0 54   0 1     1   2   48 35                       83 25 0 54   0 1     1   2   48 35                 83
1739237 CO     school 802070 100   Alamosa RE-11J 80207000027 118 Alamosa High School   Regular School No High 09 12 2021   grade_12 26 2 58   3 1     0   0   51 39                       90 26 2 58   3 1     0   0   51 39                 90
1739238 CO     school 802070 100   Alamosa RE-11J 80207000027 118 Alamosa High School   Regular School No High 09 12 2021   grade_9 43 0 78   0 2     2   3   69 59                       128 43 0 78   0 2     2   3   69 59                 128
1739239 CO     school 802070 100   Alamosa RE-11J 80207000027 118 Alamosa High School   Regular School No High 09 12 2021   pk_12_total 135 2 270   5 6     3   6   230 197                       427 135 2 270   5 6     3   6   230 197                 427
1739240 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_1 17 4 27   0 0     1   1   24 26                       50 17 4 27   0 0     1   1   24 26                 50
1739241 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_10 17 0 28   0 2     0   0   25 22                       47 17 0 28   0 2     0   0   25 22                 47
1739242 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_11 12 0 23   2 1     0   0   15 23                       38 12 0 23   2 1     0   0   15 23                 38
1739243 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_12 8 0 25   0 0     0   0   15 18                       33 8 0 25   0 0     0   0   15 18                 33
1739244 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_2 7 1 26   1 0     0   2   21 16                       37 7 1 26   1 0     0   2   21 16                 37
1739245 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_3 6 0 20   0 0     0   0   15 11                       26 6 0 20   0 0     0   0   15 11                 26
1739246 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_4 7 2 30   5 0     0   1   18 27                       45 7 2 30   5 0     0   1   18 27                 45
1739247 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_5 11 1 20   1 1     0   0   13 21                       34 11 1 20   1 1     0   0   13 21                 34
1739248 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_6 10 0 34   0 1     0   0   16 29                       45 10 0 34   0 1     0   0   16 29                 45
1739249 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_7 9 2 34   2 1     0   2   27 23                       50 9 2 34   2 1     0   2   27 23                 50
1739250 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_8 11 0 27   2 0     0   2   27 15                       42 11 0 27   2 0     0   2   27 15                 42
1739251 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   grade_9 16 1 45   3 1     0   1   34 33                       67 16 1 45   3 1     0   1   34 33                 67
1739252 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   kindergarten_full_day 22 2 14   0 1     0   3   22 20                       42 22 2 14   0 1     0   3   22 20                 42
1739253 CO     school 802070 100   Alamosa RE-11J 80207006792 270 Alamosa Online   Regular School No Other KG 12 2021   pk_12_total 153 13 353   16 8     1   12   272 284                       556 153 13 353   16 8     1   12   272 284                 556
1739254 CO     school 802070 100   Alamosa RE-11J 80207006798 1107 Alamosa Elementary School K-2   Regular School No Elementary KG 02 2021   grade_1 43 0 87   2 0     0   1   70 63                       133 43 0 87   2 0     0   1   70 63                 133
1739255 CO     school 802070 100   Alamosa RE-11J 80207006798 1107 Alamosa Elementary School K-2   Regular School No Elementary KG 02 2021   grade_2 40 0 73   1 0     2   3   56 63                       119 40 0 73   1 0     2   3   56 63                 119
1739256 CO     school 802070 100   Alamosa RE-11J 80207006798 1107 Alamosa Elementary School K-2   Regular School No Elementary KG 02 2021   kindergarten_full_day 51 1 43   2 0     2   4   54 49                       103 51 1 43   2 0     2   4   54 49                 103
1739257 CO     school 802070 100   Alamosa RE-11J 80207006798 1107 Alamosa Elementary School K-2   Regular School No Elementary KG 02 2021   pk_12_total 134 1 203   5 0     4   8   180 175                       355 134 1 203   5 0     4   8   180 175                 355
1744427 CO     school 804080 1000   Fountain 8 80408000096 203 Welte Education Center   Alternative School No High 06 12 2021   grade_10 6 0 7   1 0     0   1   11 4                       15 6 0 7   1 0     0   1   11 4                 15
1744428 CO     school 804080 1000   Fountain 8 80408000096 203 Welte Education Center   Alternative School No High 06 12 2021   grade_11 13 4 12   0 0     0   1   17 13                       30 13 4 12   0 0     0   1   17 13                 30
1744429 CO     school 804080 1000   Fountain 8 80408000096 203 Welte Education Center   Alternative School No High 06 12 2021   grade_12 27 4 16   0 0     2   3   32 20                       52 27 4 16   0 0     2   3   32 20                 52
1744430 CO     school 804080 1000   Fountain 8 80408000096 203 Welte Education Center   Alternative School No High 06 12 2021   grade_9 11 0 3   0 0     0   0   9 5                       14 11 0 3   0 0     0   0   9 5                 14
1744431 CO     school 804080 1000   Fountain 8 80408000096 203 Welte Education Center   Alternative School No High 06 12 2021   pk_12_total 57 8 38   1 0     2   5   69 42                       111 57 8 38   1 0     2   5   69 42                 111
1744432 CO     school 804080 1000   Fountain 8 80408000561 1332 Carson Middle School   Regular School No Middle 06 08 2021   grade_6 99 36 59   3 6     6   24   124 109                       233 99 36 59   3 6     6   24   124 109                 233
1744433 CO     school 804080 1000   Fountain 8 80408000561 1332 Carson Middle School   Regular School No Middle 06 08 2021   grade_7 110 32 50   1 2     5   24   116 108                       224 110 32 50   1 2     5   24   116 108                 224
1744434 CO     school 804080 1000   Fountain 8 80408000561 1332 Carson Middle School   Regular School No Middle 06 08 2021   grade_8 114 23 56   2 5     4   27   115 116                       231 114 23 56   2 5     4   27   115 116                 231
1744435 CO     school 804080 1000   Fountain 8 80408000561 1332 Carson Middle School   Regular School No Middle 06 08 2021   pk_12_total 323 91 165   6 13     15   75   355 333                       688 323 91 165   6 13     15   75   355 333                 688
1744436 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2021   grade_1 32 12 26   0 1     2   8   41 40                       81 32 12 26   0 1     2   8   41 40                 81
1744437 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2021   grade_2 39 10 24   1 1     1   7   35 48                       83 39 10 24   1 1     1   7   35 48                 83
1744438 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2021   grade_3 26 17 19   1 0     0   4   28 39                       67 26 17 19   1 0     0   4   28 39                 67
1744439 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2021   grade_4 13 12 11   2 3     1   6   23 25                       48 13 12 11   2 3     1   6   23 25                 48
1744440 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2021   grade_5 21 7 6   1 1     1   4   22 19                       41 21 7 6   1 1     1   4   22 19                 41
1744441 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2021   kindergarten_full_day 48 8 38   0 3     0   11   48 60                       108 48 8 38   0 3     0   11   48 60                 108
1744442 CO     school 804080 1000   Fountain 8 80408000560 1334 Abrams Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 179 66 124   5 9     5   40   197 231                       428 179 66 124   5 9     5   40   197 231                 428
1744443 CO     school 804080 1000   Fountain 8 80408006805 1941 Conrad Early Learning Center   Regular School No Prekindergarten PK PK 2021   pk_12_total 113 9 64   3 3     2   37   125 106                       231 113 9 64   3 3     2   37   125 106                 231
1744444 CO     school 804080 1000   Fountain 8 80408006805 1941 Conrad Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 113 9 64   3 3     2   37   125 106                       231 113 9 64   3 3     2   37   125 106                 231
1744445 CO     school 804080 1000   Fountain 8 80408006330 3027 Eagleside Elementary School   Regular School No Elementary PK 05 2021   grade_1 53 4 23   0 1     2   15   47 51                       98 53 4 23   0 1     2   15   47 51                 98
1744446 CO     school 804080 1000   Fountain 8 80408006330 3027 Eagleside Elementary School   Regular School No Elementary PK 05 2021   grade_2 45 9 9   2 3     5   20   46 47                       93 45 9 9   2 3     5   20   46 47                 93
1744447 CO     school 804080 1000   Fountain 8 80408006330 3027 Eagleside Elementary School   Regular School No Elementary PK 05 2021   grade_3 47 6 13   2 0     1   12   34 47                       81 47 6 13   2 0     1   12   34 47                 81
1744448 CO     school 804080 1000   Fountain 8 80408006330 3027 Eagleside Elementary School   Regular School No Elementary PK 05 2021   grade_4 52 11 26   0 0     6   15   56 54                       110 52 11 26   0 0     6   15   56 54                 110
1744449 CO     school 804080 1000   Fountain 8 80408006330 3027 Eagleside Elementary School   Regular School No Elementary PK 05 2021   grade_5 53 12 18   1 2     0   11   57 40                       97 53 12 18   1 2     0   11   57 40                 97
1744450 CO     school 804080 1000   Fountain 8 80408006330 3027 Eagleside Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 41 5 19   0 0     2   12   41 38                       79 41 5 19   0 0     2   12   41 38                 79
1744451 CO     school 804080 1000   Fountain 8 80408006330 3027 Eagleside Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 291 47 108   5 6     16   85   281 277                       558 291 47 108   5 6     16   85   281 277                 558
1744452 CO     school 804080 1000   Fountain 8 80408000566 3102 Aragon Elementary School   Regular School No Elementary KG 05 2021   grade_1 32 6 14   1 0     1   6   19 41                       60 32 6 14   1 0     1   6   19 41                 60
1744453 CO     school 804080 1000   Fountain 8 80408000566 3102 Aragon Elementary School   Regular School No Elementary KG 05 2021   grade_2 33 8 13   0 1     0   6   30 31                       61 33 8 13   0 1     0   6   30 31                 61

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