enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 13,286 ✖
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
1738260 1738260 CO     school   10   Mapleton 1   0 Not a school             2021   grade_12 3 0 3   0 0     0   0   5 1                       6 3 0 3   0 0     0   0   5 1                 6
1738261 1738261 CO     school   10   Mapleton 1   0 Not a school             2021   pk_12_total 3 0 3   0 0     0   0   5 1                       6 3 0 3   0 0     0   0   5 1                 6
1744504 1744504 CO     school   1010   Colorado Springs 11   0 Not a school             2021   grade_12 8 0 1   0 0     0   0   3 6                       9 8 0 1   0 0     0   0   3 6                 9
1744505 1744505 CO     school   1010   Colorado Springs 11   0 Not a school             2021   pk_12_total 8 0 1   0 0     0   0   3 6                       9 8 0 1   0 0     0   0   3 6                 9
1746112 1746112 CO     school   1420   Jefferson County R-1   0 Not a school             2021   grade_11 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
1746113 1746113 CO     school   1420   Jefferson County R-1   0 Not a school             2021   grade_12 7 0 2   0 1     0   0   3 7                       10 7 0 2   0 1     0   0   3 7                 10
1746114 1746114 CO     school   1420   Jefferson County R-1   0 Not a school             2021   pk_12_total 7 0 3   0 1     0   0   3 8                       11 7 0 3   0 1     0   0   3 8                 11
1747581 1747581 CO     school   1550   Poudre R-1   0 Not a school             2021   grade_11 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1747582 1747582 CO     school   1550   Poudre R-1   0 Not a school             2021   pk_12_total 1 0 0   0 0     0   0   1 0                       1 1 0 0   0 0     0   0   1 0                 1
1749499 1749499 CO     school   2690   Pueblo City 60   0 Not a school             2021   grade_11 0 0 1   0 0     0   0   0 1                       1 0 0 1   0 0     0   0   0 1                 1
1749500 1749500 CO     school   2690   Pueblo City 60   0 Not a school             2021   grade_12 17 1 18   1 0     0   0   17 20                       37 17 1 18   1 0     0   0   17 20                 37
1749501 1749501 CO     school   2690   Pueblo City 60   0 Not a school             2021   pk_12_total 17 1 19   1 0     0   0   17 21                       38 17 1 19   1 0     0   0   17 21                 38
1739969 1739969 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_11 0 1 0   0 0     0   0   0 1                       1 0 1 0   0 0     0   0   0 1                 1
1739970 1739970 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_12 1 0 1   0 0     0   1   2 1                       3 1 0 1   0 0     0   1   2 1                 3
1739971 1739971 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_3 0 0 3   0 0     0   0   2 1                       3 0 0 3   0 0     0   0   2 1                 3
1739972 1739972 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_4 0 0 0   0 1     0   0   0 1                       1 0 0 0   0 1     0   0   0 1                 1
1739973 1739973 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_6 1 0 1   0 0     0   2   3 1                       4 1 0 1   0 0     0   2   3 1                 4
1739974 1739974 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_7 0 0 1   0 0     0   0   1 0                       1 0 0 1   0 0     0   0   1 0                 1
1739975 1739975 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_8 0 1 3   0 0     0   0   2 2                       4 0 1 3   0 0     0   0   2 2                 4
1739976 1739976 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   grade_9 1 0 0   0 0     0   0   0 1                       1 1 0 0   0 0     0   0   0 1                 1
1739977 1739977 CO     school   180   Adams-Arapahoe 28J   1 Facilities with District Run Education             2021   pk_12_total 3 2 9   0 1     0   3   10 8                       18 3 2 9   0 1     0   3   10 8                 18
1741828 1741828 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2021   grade_10 6 12 189   4 3     0   1   109 106                       215 6 12 189   4 3     0   1   109 106                 215
1741829 1741829 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2021   grade_11 4 1 165   2 4     0   1   93 84                       177 4 1 165   2 4     0   1   93 84                 177
1741830 1741830 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2021   grade_12 9 5 171   0 12     0   1   99 99                       198 9 5 171   0 12     0   1   99 99                 198
1741831 1741831 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2021   grade_9 9 14 342   1 7     0   1   227 147                       374 9 14 342   1 7     0   1   227 147                 374
1741832 1741832 CO     school 803360 880   Denver County 1 80336000305 10 Abraham Lincoln High School   Regular School No High 09 12 2021   pk_12_total 28 32 867   7 26     0   4   528 436                       964 28 32 867   7 26     0   4   528 436                 964
1743218 1743218 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2021   grade_1 71 1 5   1 1     0   6   47 38                       85 71 1 5   1 1     0   6   47 38                 85
1743219 1743219 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2021   grade_2 74 3 5   0 2     0   2   41 45                       86 74 3 5   0 2     0   2   41 45                 86
1743220 1743220 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2021   grade_3 64 1 7   3 3     0   7   39 46                       85 64 1 7   3 3     0   7   39 46                 85
1743221 1743221 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2021   grade_4 64 0 8   1 2     0   5   37 43                       80 64 0 8   1 2     0   5   37 43                 80
1743222 1743222 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2021   grade_5 60 1 9   0 2     0   3   33 42                       75 60 1 9   0 2     0   3   33 42                 75
1743223 1743223 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2021   grade_6 66 0 11   0 2     0   4   33 50                       83 66 0 11   0 2     0   4   33 50                 83
1743224 1743224 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2021   grade_7 62 3 10   0 2     0   4   32 49                       81 62 3 10   0 2     0   4   32 49                 81
1743225 1743225 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2021   grade_8 53 1 10   2 3     0   5   40 34                       74 53 1 10   2 3     0   5   40 34                 74
1743226 1743226 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2021   kindergarten_full_day 72 2 8   0 0     0   6   37 51                       88 72 2 8   0 0     0   6   37 51                 88
1743227 1743227 CO     school 803450 900   Douglas County Re 1 80345000492 11 Academy Charter School   Regular School Yes Elementary PK 08 2021   pk_12_total 586 12 73   7 17     0   42   339 398                       737 586 12 73   7 17     0   42   339 398                 737
1743228 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 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 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 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 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 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 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 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 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
1738402 1738402 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2021   grade_1 28 1 21   0 8     0   6   36 28                       64 28 1 21   0 8     0   6   36 28                 64
1738403 1738403 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2021   grade_2 34 0 28   0 3     0   2   35 32                       67 34 0 28   0 3     0   2   35 32                 67
1738404 1738404 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2021   grade_3 34 1 38   0 5     0   2   42 38                       80 34 1 38   0 5     0   2   42 38                 80
1738405 1738405 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2021   grade_4 32 2 33   0 3     0   2   37 35                       72 32 2 33   0 3     0   2   37 35                 72
1738406 1738406 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2021   grade_5 30 2 19   0 2     0   4   30 27                       57 30 2 19   0 2     0   4   30 27                 57
1738407 1738407 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2021   kindergarten_full_day 27 2 23   0 1     0   0   29 24                       53 27 2 23   0 1     0   0   29 24                 53
1738408 1738408 CO     school 806900 20   Adams 12 Five Star Schools 80690001709 14 Glacier Peak Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 185 8 162   0 22     0   16   209 184                       393 185 8 162   0 22     0   16   209 184                 393
1751080 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
1739348 1739348 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2021   grade_1 43 9 20   0 12     0   6   47 43                       90 43 9 20   0 12     0   6   47 43                 90
1739349 1739349 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2021   grade_2 52 8 7   0 11     0   2   42 38                       80 52 8 7   0 11     0   2   42 38                 80
1739350 1739350 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2021   grade_3 53 8 10   0 16     0   10   50 47                       97 53 8 10   0 16     0   10   50 47                 97
1739351 1739351 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2021   grade_4 50 1 16   0 12     0   6   38 47                       85 50 1 16   0 12     0   6   38 47                 85
1739352 1739352 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2021   grade_5 52 3 16   1 15     0   9   46 50                       96 52 3 16   1 15     0   9   46 50                 96
1739353 1739353 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2021   kindergarten_full_day 50 2 8   0 4     0   10   46 28                       74 50 2 8   0 4     0   10   46 28                 74
1739354 1739354 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2021   pk_12_total 331 37 92   1 75     0   47   301 282                       583 331 37 92   1 75     0   47   301 282                 583
1739355 1739355 CO     school 802910 130   Cherry Creek 5 80291001710 16 Fox Hollow Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten 31 6 15   0 5     0   4   32 29                       61 31 6 15   0 5     0   4   32 29                 61
1744978 1744978 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2021   grade_1 40 0 12   1 2     0   4   32 27                       59 40 0 12   1 2     0   4   32 27                 59
1744979 1744979 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2021   grade_2 41 1 8   0 1     0   4   29 26                       55 41 1 8   0 1     0   4   29 26                 55
1744980 1744980 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2021   grade_3 54 2 9   0 4     0   7   39 37                       76 54 2 9   0 4     0   7   39 37                 76
1744981 1744981 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2021   grade_4 48 2 9   0 3     0   8   32 38                       70 48 2 9   0 3     0   8   32 38                 70
1744982 1744982 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2021   grade_5 54 3 8   0 0     0   3   28 40                       68 54 3 8   0 0     0   3   28 40                 68
1744983 1744983 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2021   kindergarten_full_day 41 1 7   0 3     0   3   21 34                       55 41 1 7   0 3     0   3   21 34                 55
1744984 1744984 CO     school 801920 1040   Academy 20 80192001643 17 Academy Endeavour Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 278 9 53   1 13     0   29   181 202                       383 278 9 53   1 13     0   29   181 202                 383
1739356 1739356 CO     school 802910 130   Cherry Creek 5 80291001711 18 Liberty Middle School   Regular School No Middle 06 08 2021   grade_6 185 30 55   1 33     1   19   159 165                       324 185 30 55   1 33     1   19   159 165                 324
1739357 1739357 CO     school 802910 130   Cherry Creek 5 80291001711 18 Liberty Middle School   Regular School No Middle 06 08 2021   grade_7 178 34 61   1 35     1   33   189 154                       343 178 34 61   1 35     1   33   189 154                 343
1739358 1739358 CO     school 802910 130   Cherry Creek 5 80291001711 18 Liberty Middle School   Regular School No Middle 06 08 2021   grade_8 192 22 60   3 46     1   32   181 175                       356 192 22 60   3 46     1   32   181 175                 356
1739359 1739359 CO     school 802910 130   Cherry Creek 5 80291001711 18 Liberty Middle School   Regular School No Middle 06 08 2021   pk_12_total 555 86 176   5 114     3   84   529 494                       1023 555 86 176   5 114     3   84   529 494                 1023
1744985 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 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 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 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 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 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 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
1738786 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 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 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 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
1738790 1738790 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2021   grade_10 0 0 12   0 0     0   0   6 6                       12 0 0 12   0 0     0   0   6 6                 12
1738791 1738791 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2021   grade_11 9 1 48   1 0     0   1   30 30                       60 9 1 48   1 0     0   1   30 30                 60
1738792 1738792 CO     school 801950 30   Adams County 14 80195001307 22 Lester R Arnold High School   Alternative School No High 09 12 2021   grade_12 12 1 89   0 0     0   1   64 39                       103 12 1 89   0 0     0   1   64 39                 103

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