Data source: Big Local News · About: Big Local

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

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
1744985 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2021   grade_1 40 2 6   0 9     0   8   31 34                       65 40 2 6   0 9     0   8   31 34                 65
1744986 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2021   grade_2 39 3 8   0 12     1   7   31 39                       70 39 3 8   0 12     1   7   31 39                 70
1744987 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2021   grade_3 51 2 11   0 12     1   11   42 46                       88 51 2 11   0 12     1   11   42 46                 88
1744988 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2021   grade_4 51 3 7   0 11     0   9   36 45                       81 51 3 7   0 11     0   9   36 45                 81
1744989 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2021   grade_5 50 2 10   0 12     0   5   40 39                       79 50 2 10   0 12     0   5   40 39                 79
1744990 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 39 2 10   0 6     0   10   34 33                       67 39 2 10   0 6     0   10   34 33                 67
1744991 CO     school 801920 1040   Academy 20 80192001644 19 Academy International Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 270 14 52   0 62     2   50   214 236                       450 270 14 52   0 62     2   50   214 236                 450
1744522 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2021   grade_1 17 0 7   0 0     0   6   12 18                       30 17 0 7   0 0     0   6   12 18                 30
1744523 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2021   grade_2 27 0 7   0 1     0   4   17 22                       39 27 0 7   0 1     0   4   17 22                 39
1744524 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2021   grade_3 29 0 5   0 0     0   2   21 15                       36 29 0 5   0 0     0   2   21 15                 36
1744525 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2021   grade_4 25 0 4   0 0     0   2   18 13                       31 25 0 4   0 0     0   2   18 13                 31
1744526 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2021   grade_5 21 0 8   0 0     0   3   20 12                       32 21 0 8   0 0     0   3   20 12                 32
1744527 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2021   grade_6 25 2 6   1 0     0   2   19 17                       36 25 2 6   1 0     0   2   19 17                 36
1744528 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2021   grade_7 23 1 5   1 0     1   2   16 17                       33 23 1 5   1 0     1   2   16 17                 33
1744529 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2021   grade_8 23 1 2   1 0     0   0   20 7                       27 23 1 2   1 0     0   0   20 7                 27
1744530 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2021   kindergarten_full_day 22 1 6   0 0     0   3   17 15                       32 22 1 6   0 0     0   3   17 15                 32
1744531 CO     school 803060 1010   Colorado Springs 11 80306006456 517 Academy for Advanced and Creative Learning   Regular School Yes Elementary KG 08 2021   pk_12_total 212 5 50   3 1     1   24   160 136                       296 212 5 50   3 1     1   24   160 136                 296
1739978 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2021   grade_1 5 29 60   1 1     0   6   58 44                       102 5 29 60   1 1     0   6   58 44                 102
1739979 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2021   grade_2 9 21 70   1 0     0   4   49 56                       105 9 21 70   1 0     0   4   49 56                 105
1739980 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2021   grade_3 7 23 65   0 1     1   6   45 58                       103 7 23 65   0 1     1   6   45 58                 103
1739981 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2021   grade_4 10 21 62   0 1     1   5   50 50                       100 10 21 62   0 1     1   5   50 50                 100
1739982 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2021   grade_5 6 27 71   2 1     0   4   54 57                       111 6 27 71   2 1     0   4   54 57                 111
1739983 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2021   grade_6 6 25 90   0 1     0   11   70 63                       133 6 25 90   0 1     0   11   70 63                 133
1739984 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2021   grade_7 7 28 67   0 1     0   6   59 50                       109 7 28 67   0 1     0   6   59 50                 109
1739985 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2021   grade_8 5 15 56   1 0     1   5   35 48                       83 5 15 56   1 0     1   5   35 48                 83
1739986 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2021   kindergarten_full_day 6 18 52   0 0     0   6   42 40                       82 6 18 52   0 0     0   6   42 40                 82
1739987 CO     school 802340 180   Adams-Arapahoe 28J 80234006736 126 Academy of Advanced Learning   Regular School Yes Elementary KG 08 2021   pk_12_total 61 207 593   5 6     3   53   462 466                       928 61 207 593   5 6     3   53   462 466                 928
1751147 CO     school 800020 8001   Charter School Institute 80002001998 657 Academy of Arts and Knowledge Elementary   Regular School Yes Elementary KG 05 2021   grade_1 19 0 4   0 0     0   3   12 14                       26 19 0 4   0 0     0   3   12 14                 26
1751148 CO     school 800020 8001   Charter School Institute 80002001998 657 Academy of Arts and Knowledge Elementary   Regular School Yes Elementary KG 05 2021   grade_2 18 2 3   0 1     0   3   12 15                       27 18 2 3   0 1     0   3   12 15                 27
1751149 CO     school 800020 8001   Charter School Institute 80002001998 657 Academy of Arts and Knowledge Elementary   Regular School Yes Elementary KG 05 2021   grade_3 25 2 11   0 1     0   0   15 24                       39 25 2 11   0 1     0   0   15 24                 39
1751150 CO     school 800020 8001   Charter School Institute 80002001998 657 Academy of Arts and Knowledge Elementary   Regular School Yes Elementary KG 05 2021   grade_4 20 1 4   0 0     1   1   15 12                       27 20 1 4   0 0     1   1   15 12                 27
1751151 CO     school 800020 8001   Charter School Institute 80002001998 657 Academy of Arts and Knowledge Elementary   Regular School Yes Elementary KG 05 2021   grade_5 18 1 3   0 1     0   2   14 11                       25 18 1 3   0 1     0   2   14 11                 25
1751152 CO     school 800020 8001   Charter School Institute 80002001998 657 Academy of Arts and Knowledge Elementary   Regular School Yes Elementary KG 05 2021   kindergarten_full_day 28 1 8   0 1     0   3   28 13                       41 28 1 8   0 1     0   3   28 13                 41
1751153 CO     school 800020 8001   Charter School Institute 80002001998 657 Academy of Arts and Knowledge Elementary   Regular School Yes Elementary KG 05 2021   pk_12_total 128 7 33   0 4     1   12   96 89                       185 128 7 33   0 4     1   12   96 89                 185
1751080 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_1 83 1 36   0 12     0   13   74 71                       145 83 1 36   0 12     0   13   74 71                 145
1751081 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_10 70 2 48   0 15     0   4   66 73                       139 70 2 48   0 15     0   4   66 73                 139
1751082 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_11 82 1 46   1 10     0   5   71 74                       145 82 1 46   1 10     0   5   71 74                 145
1751083 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_12 76 0 40   0 13     0   6   57 78                       135 76 0 40   0 13     0   6   57 78                 135
1751084 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_2 86 1 33   0 13     0   9   64 78                       142 86 1 33   0 13     0   9   64 78                 142
1751085 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_3 86 0 41   0 9     0   11   73 74                       147 86 0 41   0 9     0   11   73 74                 147
1751086 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_4 88 2 42   0 9     0   3   85 59                       144 88 2 42   0 9     0   3   85 59                 144
1751087 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_5 88 0 37   1 8     1   12   72 75                       147 88 0 37   1 8     1   12   72 75                 147
1751088 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_6 77 2 40   0 12     0   11   81 61                       142 77 2 40   0 12     0   11   81 61                 142
1751089 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_7 96 1 39   0 11     0   4   75 76                       151 96 1 39   0 11     0   4   75 76                 151
1751090 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_8 90 1 42   1 12     0   5   68 83                       151 90 1 42   1 12     0   5   68 83                 151
1751091 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   grade_9 76 2 49   0 4     0   3   64 70                       134 76 2 49   0 4     0   3   64 70                 134
1751092 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   kindergarten_full_day 76 2 38   1 16     0   8   71 70                       141 76 2 38   1 16     0   8   71 70                 141
1751093 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   pk_12_total 1093 15 535   4 154     1   97   940 959                       1899 1093 15 535   4 154     1   97   940 959                 1899
1751094 CO     school 800020 8001   Charter School Institute 80002000727 15 Academy of Charter Schools   Regular School Yes Other PK 12 2021   pre_kindergarten 19 0 4   0 10     0   3   19 17                       36 19 0 4   0 10     0   3   19 17                 36
1738317 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   grade_1 5 1 33   0 0     0   1   22 18                       40 5 1 33   0 0     0   1   22 18                 40
1738318 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   grade_2 3 1 24   0 2     0   0   12 18                       30 3 1 24   0 2     0   0   12 18                 30
1738319 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   grade_3 5 1 39   0 0     0   2   15 32                       47 5 1 39   0 0     0   2   15 32                 47
1738320 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   grade_4 4 0 31   0 1     0   1   20 17                       37 4 0 31   0 1     0   1   20 17                 37
1738321 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   grade_5 3 0 39   0 2     0   2   21 25                       46 3 0 39   0 2     0   2   21 25                 46
1738322 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   grade_6 9 0 43   0 1     0   2   32 23                       55 9 0 43   0 1     0   2   32 23                 55
1738323 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   grade_7 2 2 58   0 1     0   3   33 33                       66 2 2 58   0 1     0   3   33 33                 66
1738324 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   grade_8 6 0 49   0 1     0   4   31 29                       60 6 0 49   0 1     0   4   31 29                 60
1738325 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   kindergarten_full_day 4 1 33   0 0     0   1   21 18                       39 4 1 33   0 0     0   1   21 18                 39
1738326 CO     school 805550 10   Mapleton 1 80555002004 505 Achieve Academy   Regular School No Elementary PK 08 2021   pk_12_total 41 6 349   0 8     0   16   207 213                       420 41 6 349   0 8     0   16   207 213                 420
1744506 CO     school 803060 1010   Colorado Springs 11 80306006428 269 Achieve Online   Alternative School No High 06 12 2021   grade_10 29 2 24   0 0     0   2   21 36                       57 29 2 24   0 0     0   2   21 36                 57
1744507 CO     school 803060 1010   Colorado Springs 11 80306006428 269 Achieve Online   Alternative School No High 06 12 2021   grade_11 27 5 11   0 3     1   6   27 26                       53 27 5 11   0 3     1   6   27 26                 53
1744508 CO     school 803060 1010   Colorado Springs 11 80306006428 269 Achieve Online   Alternative School No High 06 12 2021   grade_12 47 5 33   0 2     2   7   43 53                       96 47 5 33   0 2     2   7   43 53                 96
1744509 CO     school 803060 1010   Colorado Springs 11 80306006428 269 Achieve Online   Alternative School No High 06 12 2021   grade_6 6 2 5   0 0     0   0   7 6                       13 6 2 5   0 0     0   0   7 6                 13
1744510 CO     school 803060 1010   Colorado Springs 11 80306006428 269 Achieve Online   Alternative School No High 06 12 2021   grade_7 16 1 5   0 0     1   2   13 12                       25 16 1 5   0 0     1   2   13 12                 25
1744511 CO     school 803060 1010   Colorado Springs 11 80306006428 269 Achieve Online   Alternative School No High 06 12 2021   grade_8 12 2 8   1 0     0   1   11 13                       24 12 2 8   1 0     0   1   11 13                 24
1744512 CO     school 803060 1010   Colorado Springs 11 80306006428 269 Achieve Online   Alternative School No High 06 12 2021   grade_9 25 3 10   0 0     0   2   18 22                       40 25 3 10   0 0     0   2   18 22                 40
1744513 CO     school 803060 1010   Colorado Springs 11 80306006428 269 Achieve Online   Alternative School No High 06 12 2021   pk_12_total 162 20 96   1 5     4   20   140 168                       308 162 20 96   1 5     4   20   140 168                 308
1743228 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2021   grade_1 25 0 14   0 10     1   5   25 30                       55 25 0 14   0 10     1   5   25 30                 55
1743229 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2021   grade_2 31 0 10   1 11     0   4   33 24                       57 31 0 10   1 11     0   4   33 24                 57
1743230 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2021   grade_3 20 1 18   0 6     0   5   30 20                       50 20 1 18   0 6     0   5   30 20                 50
1743231 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2021   grade_4 28 0 15   1 4     1   6   26 29                       55 28 0 15   1 4     1   6   26 29                 55
1743232 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2021   grade_5 26 0 12   0 5     0   7   25 25                       50 26 0 12   0 5     0   7   25 25                 50
1743233 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2021   grade_6 23 0 16   0 5     0   6   23 27                       50 23 0 16   0 5     0   6   23 27                 50
1743234 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2021   kindergarten_full_day 27 2 10   0 4     1   4   21 27                       48 27 2 10   0 4     1   4   21 27                 48
1743235 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2021   pk_12_total 193 3 101   4 56     4   37   201 197                       398 193 3 101   4 56     4   37   201 197                 398
1743236 CO     school 803450 900   Douglas County Re 1 80345000436 12 Acres Green Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten 13 0 6   2 11     1   0   18 15                       33 13 0 6   2 11     1   0   18 15                 33
1738795 CO     school 801950 30   Adams County 14 80195000010 24 Adams City High School   Regular School No High 09 12 2021   grade_10 36 10 405   2 2     1   5   235 226                       461 36 10 405   2 2     1   5   235 226                 461
1738796 CO     school 801950 30   Adams County 14 80195000010 24 Adams City High School   Regular School No High 09 12 2021   grade_11 31 3 350   1 3     1   2   208 183                       391 31 3 350   1 3     1   2   208 183                 391
1738797 CO     school 801950 30   Adams County 14 80195000010 24 Adams City High School   Regular School No High 09 12 2021   grade_12 21 3 293   1 0     0   3   152 169                       321 21 3 293   1 0     0   3   152 169                 321
1738798 CO     school 801950 30   Adams County 14 80195000010 24 Adams City High School   Regular School No High 09 12 2021   grade_9 38 9 430   4 1     0   1   255 228                       483 38 9 430   4 1     0   1   255 228                 483
1738799 CO     school 801950 30   Adams County 14 80195000010 24 Adams City High School   Regular School No High 09 12 2021   pk_12_total 126 25 1478   8 6     2   11   850 806                       1656 126 25 1478   8 6     2   11   850 806                 1656
1738786 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2021   grade_6 17 6 194   2 0     1   2   123 99                       222 17 6 194   2 0     1   2   123 99                 222
1738787 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2021   grade_7 22 3 216   1 0     0   3   134 111                       245 22 3 216   1 0     0   3   134 111                 245
1738788 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2021   grade_8 24 0 219   3 0     1   4   122 129                       251 24 0 219   3 0     1   4   122 129                 251
1738789 CO     school 801950 30   Adams County 14 80195000009 20 Adams City Middle School   Regular School No Middle 06 08 2021   pk_12_total 63 9 629   6 0     2   9   379 339                       718 63 9 629   6 0     2   9   379 339                 718
1744658 CO     school 803060 1010   Colorado Springs 11 80306000239 3890 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_1 11 13 28   0 0     0   4   27 29                       56 11 13 28   0 0     0   4   27 29                 56
1744659 CO     school 803060 1010   Colorado Springs 11 80306000239 3890 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_2 15 10 29   2 0     0   6   32 30                       62 15 10 29   2 0     0   6   32 30                 62
1744660 CO     school 803060 1010   Colorado Springs 11 80306000239 3890 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_3 20 11 30   0 1     0   8   32 38                       70 20 11 30   0 1     0   8   32 38                 70
1744661 CO     school 803060 1010   Colorado Springs 11 80306000239 3890 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_4 15 15 27   1 0     0   3   34 27                       61 15 15 27   1 0     0   3   34 27                 61
1744662 CO     school 803060 1010   Colorado Springs 11 80306000239 3890 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_5 13 14 32   2 0     0   7   36 32                       68 13 14 32   2 0     0   7   36 32                 68
1744663 CO     school 803060 1010   Colorado Springs 11 80306000239 3890 Adams Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 16 12 24   2 0     0   2   31 25                       56 16 12 24   2 0     0   2   31 25                 56
1744664 CO     school 803060 1010   Colorado Springs 11 80306000239 3890 Adams Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 101 78 183   7 1     0   31   205 196                       401 101 78 183   7 1     0   31   205 196                 401
1744665 CO     school 803060 1010   Colorado Springs 11 80306000239 3890 Adams Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 11 3 13   0 0     0   1   13 15                       28 11 3 13   0 0     0   1   13 15                 28
1746115 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_1 26 3 13   0 1     0   3   24 22                       46 26 3 13   0 1     0   3   24 22                 46
1746116 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_2 27 1 16   0 3     0   3   25 25                       50 27 1 16   0 3     0   3   25 25                 50
1746117 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_3 19 1 11   0 4     0   5   26 14                       40 19 1 11   0 4     0   5   26 14                 40
1746118 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_4 34 2 16   0 2     0   2   30 26                       56 34 2 16   0 2     0   2   30 26                 56
1746119 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2021   grade_5 31 1 17   0 4     0   1   29 25                       54 31 1 17   0 4     0   1   29 25                 54
1746120 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 31 1 7   1 5     0   2   25 22                       47 31 1 7   1 5     0   2   25 22                 47
1746121 CO     school 804800 1420   Jefferson County R-1 80480001446 30 Adams Elementary School   Regular School No Elementary PK 05 2021   kindergarten_half_day 3 0 0   0 0     0   0   3 0                       3 3 0 0   0 0     0   0   3 0                 3

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