enrollments
Data source: Big Local News · About: Big Local
4,354 rows where grade = "pk_12_total" and state = "CT" sorted by ccd_school_high_grade descending
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2451740 | 2451740 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001565 | 110811 | Wintonbury Early Childhood Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 115 | 120 | 37 | * | 25 | 0 | * | 170 | 149 | 0 | 44 | 319 | 115 | 120 | 37 | 25 | 0 | 170 | 149 | 0 | 44 | 319 | |||||||||||||||||||||||||||||||
2451761 | 2451761 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000085 | 154411 | A.B. Skane Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 41 | 63 | 107 | 0 | * | 0 | * | 145 | 81 | 0 | 127 | 226 | 41 | 63 | 107 | 0 | 0 | 145 | 81 | 0 | 127 | 226 | |||||||||||||||||||||||||||||||
2451800 | 2451800 | CT | school | 900510 | 170011 | Bristol School District | 90051001774 | 170411 | Bristol Early Childhood Center-BECC | Public Schools | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 66 | * | 29 | 0 | * | 0 | 8 | 62 | 45 | 0 | 65 | 107 | 66 | 29 | 0 | 0 | 8 | 62 | 45 | 0 | 65 | 107 | |||||||||||||||||||||||||||||||
2451912 | 2451912 | CT | school | 901020 | 340011 | Danbury School District | 90102001634 | 340111 | DPS Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 49 | 8 | 73 | * | 12 | 0 | * | 90 | 60 | 0 | 72 | 150 | 49 | 8 | 73 | 12 | 0 | 90 | 60 | 0 | 72 | 150 | |||||||||||||||||||||||||||||||
2451939 | 2451939 | CT | school | 901110 | 370011 | Derby School District | 90111001806 | 370111 | Little Raiders University | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 16 | 10 | 13 | 0 | 0 | * | * | 31 | 13 | 0 | 15 | 44 | 16 | 10 | 13 | 0 | 0 | 31 | 13 | 0 | 15 | 44 | |||||||||||||||||||||||||||||||
2451973 | 2451973 | CT | school | 901290 | 440011 | East Haven School District | 90129001350 | 441811 | Overbrook Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 74 | 9 | 55 | 0 | 9 | 0 | 12 | 69 | 90 | 0 | 7 | 159 | 74 | 9 | 55 | 0 | 9 | 0 | 12 | 69 | 90 | 0 | 7 | 159 | |||||||||||||||||||||||||||||
2452013 | 2452013 | CT | school | 901470 | 490011 | Enfield School District | 90147001915 | 492211 | EPS Integrated Pre-Kindergarten | Program | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 62 | * | * | 0 | * | 0 | * | 48 | 26 | 0 | 46 | 74 | 62 | 0 | 0 | 48 | 26 | 0 | 46 | 74 | |||||||||||||||||||||||||||||||||
2452014 | 2452014 | CT | school | 901470 | 490011 | Enfield School District | 90147001810 | 491011 | EPS PK STEAM Academy | Program | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 31 | 17 | 14 | 0 | * | 0 | * | 39 | 29 | 0 | 10 | 68 | 31 | 17 | 14 | 0 | 0 | 39 | 29 | 0 | 10 | 68 | |||||||||||||||||||||||||||||||
2452149 | 2452149 | CT | school | 901920 | 640011 | Hartford School District | 90192001643 | 641311 | Hartford PreKindergarten Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 12 | 50 | 23 | * | 57 | 0 | * | 71 | 80 | 0 | 6 | 151 | 12 | 50 | 23 | 57 | 0 | 71 | 80 | 0 | 6 | 151 | |||||||||||||||||||||||||||||||
2452526 | 2452526 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001914 | 1030111 | Norwalk Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 74 | 14 | 54 | 0 | 15 | 0 | 6 | 100 | 63 | 0 | 104 | 163 | 74 | 14 | 54 | 0 | 15 | 0 | 6 | 100 | 63 | 0 | 104 | 163 | |||||||||||||||||||||||||||||
2452544 | 2452544 | CT | school | 903120 | 1040011 | Norwich School District | 90312000663 | 1040111 | Bishop School Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 61 | 33 | 54 | * | 15 | 0 | * | 90 | 85 | 0 | 74 | 175 | 61 | 33 | 54 | 15 | 0 | 90 | 85 | 0 | 74 | 175 | |||||||||||||||||||||||||||||||
2452651 | 2452651 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354000761 | 2180312 | Center School | Regional Schools | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 40 | * | * | 0 | 0 | 0 | * | 26 | 23 | 0 | 13 | 49 | 40 | 0 | 0 | 0 | 26 | 23 | 0 | 13 | 49 | ||||||||||||||||||||||||||||||||
2452722 | 2452722 | CT | school | 904230 | 1310011 | Southington School District | 90423001804 | 1312111 | Southington Public Schools Preschool Program | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | * | * | 0 | 0 | 0 | 0 | 0 | 9 | 10 | 0 | 11 | 19 | 0 | 0 | 0 | 0 | 0 | 9 | 10 | 0 | 11 | 19 | |||||||||||||||||||||||||||||||
2452723 | 2452723 | CT | school | 904230 | 1310011 | Southington School District | 90423001808 | 1312011 | Southington Public Schools Preschool Program at Hatton School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 56 | * | 7 | 0 | * | 0 | * | 52 | 18 | 0 | 46 | 70 | 56 | 7 | 0 | 0 | 52 | 18 | 0 | 46 | 70 | ||||||||||||||||||||||||||||||||
2452778 | 2452778 | CT | school | 904380 | 1370011 | Stonington School District | 90438001637 | 1370111 | Stonington BOE Pre-School | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 22 | 0 | * | 0 | * | 0 | 0 | 15 | 11 | 0 | 16 | 26 | 22 | 0 | 0 | 0 | 0 | 15 | 11 | 0 | 16 | 26 | ||||||||||||||||||||||||||||||||
2452779 | 2452779 | CT | school | 904380 | 1370011 | Stonington School District | 90438001635 | 1370211 | Stonington HS PreK | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 22 | 0 | * | 0 | 0 | 0 | * | 17 | 9 | 0 | 17 | 26 | 22 | 0 | 0 | 0 | 0 | 17 | 9 | 0 | 17 | 26 | ||||||||||||||||||||||||||||||||
2757321 | 2757321 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001565 | 110811 | Wintonbury Early Childhood Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 106 | 113 | 37 | 0 | 35 | 0 | 18 | 139 | 170 | 0 | 37 | 309 | 106 | 113 | 37 | 0 | 35 | 0 | 18 | 139 | 170 | 0 | 37 | 309 | |||||||||||||||||||||||||||||
2757342 | 2757342 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000085 | 154411 | A.B. Skane Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 20 | 58 | 117 | * | 6 | 0 | * | 125 | 80 | 0 | 126 | 205 | 20 | 58 | 117 | 6 | 0 | 125 | 80 | 0 | 126 | 205 | |||||||||||||||||||||||||||||||
2757381 | 2757381 | CT | school | 900510 | 170011 | Bristol School District | 90051001774 | 170411 | Bristol Early Childhood Center-BECC | Public Schools | Special Education School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 46 | * | 38 | 0 | * | 0 | 10 | 63 | 33 | 0 | 71 | 96 | 46 | 38 | 0 | 0 | 10 | 63 | 33 | 0 | 71 | 96 | |||||||||||||||||||||||||||||||
2757494 | 2757494 | CT | school | 901020 | 340011 | Danbury School District | 90102001634 | 340111 | DPS Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 31 | 12 | 80 | 0 | * | 0 | * | 80 | 54 | 0 | 97 | 134 | 31 | 12 | 80 | 0 | 0 | 80 | 54 | 0 | 97 | 134 | |||||||||||||||||||||||||||||||
2757521 | 2757521 | CT | school | 901110 | 370011 | Derby School District | 90111001806 | 370111 | Little Raiders University | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 18 | * | 16 | 0 | * | 0 | * | 25 | 18 | 0 | 18 | 43 | 18 | 16 | 0 | 0 | 25 | 18 | 0 | 18 | 43 | ||||||||||||||||||||||||||||||||
2757556 | 2757556 | CT | school | 901290 | 440011 | East Haven School District | 90129001350 | 441811 | Overbrook Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 55 | * | 36 | 0 | 7 | 0 | * | 56 | 51 | 0 | * | 107 | 55 | 36 | 0 | 7 | 0 | 56 | 51 | 0 | 107 | ||||||||||||||||||||||||||||||||
2757737 | 2757737 | CT | school | 901920 | 640011 | Hartford School District | 90192001643 | 641311 | Hartford PreKindergarten Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 12 | 64 | 37 | * | 55 | 0 | * | 82 | 98 | 0 | 10 | 180 | 12 | 64 | 37 | 55 | 0 | 82 | 98 | 0 | 10 | 180 | |||||||||||||||||||||||||||||||
2758105 | 2758105 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001914 | 1030111 | Norwalk Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 38 | 16 | 59 | 0 | * | 0 | * | 78 | 47 | 0 | 82 | 125 | 38 | 16 | 59 | 0 | 0 | 78 | 47 | 0 | 82 | 125 | |||||||||||||||||||||||||||||||
2758124 | 2758124 | CT | school | 903120 | 1040011 | Norwich School District | 90312000663 | 1040111 | Bishop School Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 34 | 25 | 36 | * | * | 0 | 12 | 73 | 40 | 0 | 64 | 113 | 34 | 25 | 36 | 0 | 12 | 73 | 40 | 0 | 64 | 113 | |||||||||||||||||||||||||||||||
2758226 | 2758226 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354000761 | 2180312 | Center School | Regional Schools | Special Education School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 85 | * | * | 0 | * | 0 | * | 52 | 43 | 0 | 17 | 95 | 85 | 0 | 0 | 52 | 43 | 0 | 17 | 95 | |||||||||||||||||||||||||||||||||
2758301 | 2758301 | CT | school | 904230 | 1310011 | Southington School District | 90423001808 | 1312011 | Southington Public Schools Preschool Program at Hatton School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 30 | 0 | * | 0 | * | 0 | * | 23 | 15 | 0 | 25 | 38 | 30 | 0 | 0 | 0 | 23 | 15 | 0 | 25 | 38 | ||||||||||||||||||||||||||||||||
2777768 | 2777768 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001565 | 110811 | Wintonbury Early Childhood Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 107 | 110 | 38 | * | 33 | 0 | * | 159 | 155 | 0 | 49 | 314 | 107 | 110 | 38 | 33 | 0 | 159 | 155 | 0 | 49 | 314 | |||||||||||||||||||||||||||||||
2777790 | 2777790 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000085 | 154411 | A.B. Skane Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 36 | 46 | 121 | 0 | * | 0 | * | 141 | 69 | 0 | 137 | 210 | 36 | 46 | 121 | 0 | 0 | 141 | 69 | 0 | 137 | 210 | |||||||||||||||||||||||||||||||
2777829 | 2777829 | CT | school | 900510 | 170011 | Bristol School District | 90051001774 | 170411 | Bristol Early Childhood Center-BECC | Public Schools | Special Education School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 68 | 0 | 31 | 0 | * | 0 | * | 75 | 38 | 0 | 70 | 113 | 68 | 0 | 31 | 0 | 0 | 75 | 38 | 0 | 70 | 113 | |||||||||||||||||||||||||||||||
2777943 | 2777943 | CT | school | 901020 | 340011 | Danbury School District | 90102001634 | 340111 | DPS Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 46 | * | 81 | 0 | 13 | 0 | * | 101 | 54 | 0 | 80 | 155 | 46 | 81 | 0 | 13 | 0 | 101 | 54 | 0 | 80 | 155 | |||||||||||||||||||||||||||||||
2777970 | 2777970 | CT | school | 901110 | 370011 | Derby School District | 90111001806 | 370111 | Little Raiders University | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 21 | 6 | 15 | 0 | 0 | 0 | 7 | 24 | 25 | 0 | 19 | 49 | 21 | 6 | 15 | 0 | 0 | 0 | 7 | 24 | 25 | 0 | 19 | 49 | |||||||||||||||||||||||||||||
2778180 | 2778180 | CT | school | 901920 | 640011 | Hartford School District | 90192001643 | 641311 | Hartford PreKindergarten Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 18 | 56 | 26 | * | 56 | 0 | * | 76 | 85 | 0 | 9 | 161 | 18 | 56 | 26 | 56 | 0 | 76 | 85 | 0 | 9 | 161 | |||||||||||||||||||||||||||||||
2778549 | 2778549 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001914 | 1030111 | Norwalk Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 53 | 15 | 67 | * | 12 | 0 | * | 84 | 71 | 0 | 92 | 155 | 53 | 15 | 67 | 12 | 0 | 84 | 71 | 0 | 92 | 155 | |||||||||||||||||||||||||||||||
2778568 | 2778568 | CT | school | 903120 | 1040011 | Norwich School District | 90312000663 | 1040111 | Bishop School Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 54 | 34 | 66 | * | 10 | * | 12 | 97 | 81 | 0 | 61 | 178 | 54 | 34 | 66 | 10 | 12 | 97 | 81 | 0 | 61 | 178 | |||||||||||||||||||||||||||||||
2778673 | 2778673 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354000761 | 2180312 | Center School | Regional Schools | Special Education School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | 37 | 34 | 0 | 12 | 71 | 0 | 0 | 0 | 0 | 0 | 37 | 34 | 0 | 12 | 71 | |||||||||||||||||||||||||||||||
2778748 | 2778748 | CT | school | 904230 | 1310011 | Southington School District | 90423001808 | 1312011 | Southington Public Schools Preschool Program at Hatton School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 63 | 0 | 7 | 0 | * | 0 | * | 50 | 27 | 0 | 52 | 77 | 63 | 0 | 7 | 0 | 0 | 50 | 27 | 0 | 52 | 77 | |||||||||||||||||||||||||||||||
2451929 | 2451929 | CT | school | 901020 | 340011 | Danbury School District | 90102001129 | 346211 | Alternative Center For Excellence | Program | Alternative School | No | Not reported | M | M | 2019 | pk_12_total | 30 | 10 | 44 | * | * | 0 | * | 49 | 42 | 6 | 16 | 91 | 30 | 10 | 44 | 0 | 49 | 42 | 6 | 16 | 91 | ||||||||||||||||||||||||||||||||
2451874 | 2451874 | CT | school | 900750 | 250011 | Cheshire School District | 90075011188 | 250211 | Darcey School | Public Schools | Regular School | No | Elementary | PK | KG | 2019 | pk_12_total | 133 | * | 16 | 0 | 16 | 0 | * | 104 | 74 | * | 40 | 178 | 133 | 16 | 0 | 16 | 0 | 104 | 74 | 40 | 178 | ||||||||||||||||||||||||||||||||
2452222 | 2452222 | CT | school | 903450 | 2450014 | Learn | 90345001430 | 2450214 | The Friendship School | Regional Education Service Center Schools | Regular School | No | Elementary | PK | KG | 2019 | pk_12_total | 184 | 55 | 197 | * | 14 | * | 49 | 262 | 241 | 24 | 47 | 503 | 184 | 55 | 197 | 14 | 49 | 262 | 241 | 24 | 47 | 503 | |||||||||||||||||||||||||||||||
2452565 | 2452565 | CT | school | 903210 | 1070011 | Orange School District | 90321001225 | 1070211 | Mary L. Tracy School | Public Schools | Regular School | No | Elementary | PK | KG | 2019 | pk_12_total | 143 | * | 14 | 0 | 22 | 0 | * | 86 | 105 | 9 | 25 | 191 | 143 | 14 | 0 | 22 | 0 | 86 | 105 | 9 | 25 | 191 | |||||||||||||||||||||||||||||||
2757453 | 2757453 | CT | school | 900750 | 250011 | Cheshire School District | 90075011188 | 250211 | Darcey School | Public Schools | Regular School | No | Elementary | PK | KG | 2021 | pk_12_total | 118 | * | 18 | 0 | * | 0 | 11 | 82 | 74 | * | 45 | 156 | 118 | 18 | 0 | 0 | 11 | 82 | 74 | 45 | 156 | ||||||||||||||||||||||||||||||||
2757805 | 2757805 | CT | school | 903450 | 2450014 | Learn | 90345001430 | 2450214 | The Friendship School | Regional Education Service Center Schools | Regular School | No | Elementary | PK | KG | 2021 | pk_12_total | 158 | 43 | 172 | * | * | 0 | 57 | 242 | 209 | 19 | 48 | 451 | 158 | 43 | 172 | 0 | 57 | 242 | 209 | 19 | 48 | 451 | |||||||||||||||||||||||||||||||
2758144 | 2758144 | CT | school | 903210 | 1070011 | Orange School District | 90321001225 | 1070211 | Mary L. Tracy School | Public Schools | Regular School | No | Elementary | PK | KG | 2021 | pk_12_total | 158 | * | 16 | 0 | 23 | 0 | * | 111 | 99 | 10 | 33 | 210 | 158 | 16 | 0 | 23 | 0 | 111 | 99 | 10 | 33 | 210 | |||||||||||||||||||||||||||||||
2777903 | 2777903 | CT | school | 900750 | 250011 | Cheshire School District | 90075011188 | 250211 | Darcey School | Public Schools | Regular School | No | Elementary | PK | KG | 2020 | pk_12_total | 138 | * | * | 0 | 14 | 0 | 16 | 114 | 71 | * | 50 | 185 | 138 | 0 | 14 | 0 | 16 | 114 | 71 | 50 | 185 | ||||||||||||||||||||||||||||||||
2778005 | 2778005 | CT | school | 901290 | 440011 | East Haven School District | 90129001350 | 441811 | Overbrook Early Learning Center | Public Schools | Regular School | No | Elementary | PK | KG | 2020 | pk_12_total | 99 | * | 56 | 0 | 9 | 0 | * | 80 | 95 | 0 | * | 175 | 99 | 56 | 0 | 9 | 0 | 80 | 95 | 0 | 175 | ||||||||||||||||||||||||||||||||
2778249 | 2778249 | CT | school | 903450 | 2450014 | Learn | 90345001430 | 2450214 | The Friendship School | Regional Education Service Center Schools | Regular School | No | Elementary | PK | KG | 2020 | pk_12_total | 184 | 54 | 192 | 0 | * | * | 55 | 263 | 240 | 23 | 51 | 503 | 184 | 54 | 192 | 0 | 55 | 263 | 240 | 23 | 51 | 503 | |||||||||||||||||||||||||||||||
2778589 | 2778589 | CT | school | 903210 | 1070011 | Orange School District | 90321001225 | 1070211 | Mary L. Tracy School | Public Schools | Regular School | No | Elementary | PK | KG | 2020 | pk_12_total | 175 | * | 17 | 0 | 28 | 0 | * | 130 | 106 | 11 | 32 | 236 | 175 | 17 | 0 | 28 | 0 | 130 | 106 | 11 | 32 | 236 | |||||||||||||||||||||||||||||||
2451703 | 2451703 | CT | school | 900060 | 20011 | Ansonia School District | 90006010002 | 26111 | Ansonia High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 228 | 116 | 185 | * | * | 10 | 15 | 302 | 263 | 19 | 126 | 565 | 228 | 116 | 185 | 10 | 15 | 302 | 263 | 19 | 126 | 565 | |||||||||||||||||||||||||||||||
2451722 | 2451722 | CT | school | 900120 | 40011 | Avon School District | 90012000011 | 46111 | Avon High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 679 | 40 | 55 | * | 142 | 0 | * | 492 | 459 | * | 110 | 951 | 679 | 40 | 55 | 142 | 0 | 492 | 459 | 110 | 951 | ||||||||||||||||||||||||||||||||
2451730 | 2451730 | CT | school | 900210 | 70011 | Berlin School District | 90021000016 | 76111 | Berlin High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 724 | 23 | 93 | 0 | 35 | 0 | 24 | 487 | 412 | 6 | 94 | 899 | 724 | 23 | 93 | 0 | 35 | 0 | 24 | 487 | 412 | 6 | 94 | 899 | |||||||||||||||||||||||||||||
2451737 | 2451737 | CT | school | 900270 | 90011 | Bethel School District | 90027000024 | 96111 | Bethel High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 621 | 31 | 162 | * | 70 | * | 16 | 485 | 419 | 30 | 114 | 904 | 621 | 31 | 162 | 70 | 16 | 485 | 419 | 30 | 114 | 904 | |||||||||||||||||||||||||||||||
2451745 | 2451745 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001615 | 116311 | Global Experience Magnet School | Public Schools | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 44 | 107 | 39 | * | * | 0 | 11 | 77 | 127 | 12 | 33 | 204 | 44 | 107 | 39 | 0 | 11 | 77 | 127 | 12 | 33 | 204 | |||||||||||||||||||||||||||||||
2451747 | 2451747 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000029 | 116111 | Bloomfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 13 | 456 | 56 | * | * | 0 | 17 | 287 | 260 | 14 | 97 | 547 | 13 | 456 | 56 | 0 | 17 | 287 | 260 | 14 | 97 | 547 | |||||||||||||||||||||||||||||||
2451748 | 2451748 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001619 | 116411 | Learning Academy at Bloomfield | Alternative School | No | High | 09 | 12 | 2019 | pk_12_total | 0 | * | * | 0 | 0 | 0 | 0 | * | * | 0 | * | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | |||||||||||||||||||||||||||||||||||
2451750 | 2451750 | CT | school | 900360 | 120011 | Bolton School District | 90036000037 | 126111 | Bolton High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 210 | 16 | 21 | 0 | 7 | 0 | 7 | 141 | * | 0 | 39 | 261 | 210 | 16 | 21 | 0 | 7 | 0 | 7 | 141 | 0 | 39 | 261 | ||||||||||||||||||||||||||||||
2451758 | 2451758 | CT | school | 900420 | 140011 | Branford School District | 90042000039 | 146111 | Branford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 622 | 33 | 82 | 0 | 71 | 0 | 20 | 408 | 420 | 17 | 116 | 828 | 622 | 33 | 82 | 0 | 71 | 0 | 20 | 408 | 420 | 17 | 116 | 828 | |||||||||||||||||||||||||||||
2451791 | 2451791 | CT | school | 900450 | 150011 | Bridgeport School District | 90045001639 | 150811 | Aerospace/Hydrospace, Engineering and Physical Sciences Magnet High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 95 | 150 | 173 | * | 26 | * | * | 294 | 155 | 15 | 45 | 449 | 95 | 150 | 173 | 26 | 294 | 155 | 15 | 45 | 449 | ||||||||||||||||||||||||||||||||
2451792 | 2451792 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000050 | 156111 | Bassick High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 55 | 332 | 477 | * | 14 | 0 | * | 530 | 354 | 194 | 233 | 884 | 55 | 332 | 477 | 14 | 0 | 530 | 354 | 194 | 233 | 884 | |||||||||||||||||||||||||||||||
2451793 | 2451793 | CT | school | 900450 | 150011 | Bridgeport School District | 90045001636 | 150611 | Biotechnology, Research & Zoological Studies Magnet High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 103 | 146 | 185 | 0 | 30 | * | * | 120 | 347 | 15 | 24 | 467 | 103 | 146 | 185 | 0 | 30 | 120 | 347 | 15 | 24 | 467 | |||||||||||||||||||||||||||||||
2451794 | 2451794 | CT | school | 900450 | 150011 | Bridgeport School District | 90045001631 | 151611 | Bridgeport Military Academy | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 26 | 75 | 192 | * | 0 | 0 | * | 152 | 145 | 42 | 59 | 297 | 26 | 75 | 192 | 0 | 0 | 152 | 145 | 42 | 59 | 297 | |||||||||||||||||||||||||||||||
2451795 | 2451795 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000056 | 156211 | Central High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 211 | 591 | 639 | 13 | 44 | * | * | 741 | 774 | 205 | 258 | 1515 | 211 | 591 | 639 | 13 | 44 | 741 | 774 | 205 | 258 | 1515 | |||||||||||||||||||||||||||||||
2451796 | 2451796 | CT | school | 900450 | 150011 | Bridgeport School District | 90045001633 | 151511 | Information Technology & Software Engineering Magnet High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 87 | 143 | 205 | * | 27 | 0 | * | 320 | 155 | 14 | 37 | 475 | 87 | 143 | 205 | 27 | 0 | 320 | 155 | 14 | 37 | 475 | |||||||||||||||||||||||||||||||
2451797 | 2451797 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000067 | 156311 | Warren Harding High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 67 | 403 | 597 | * | * | * | 7 | 598 | 484 | 319 | 229 | 1082 | 67 | 403 | 597 | 7 | 598 | 484 | 319 | 229 | 1082 | ||||||||||||||||||||||||||||||||
2451828 | 2451828 | CT | school | 900510 | 170011 | Bristol School District | 90051000092 | 176111 | Bristol Central High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 679 | 77 | 315 | * | * | 0 | 42 | 596 | 557 | 30 | 219 | 1153 | 679 | 77 | 315 | 0 | 42 | 596 | 557 | 30 | 219 | 1153 | |||||||||||||||||||||||||||||||
2451829 | 2451829 | CT | school | 900510 | 170011 | Bristol School District | 90051000093 | 176211 | Bristol Eastern High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 701 | 74 | 227 | * | 28 | * | 31 | 539 | 526 | 22 | 220 | 1065 | 701 | 74 | 227 | 28 | 31 | 539 | 526 | 22 | 220 | 1065 | |||||||||||||||||||||||||||||||
2451836 | 2451836 | CT | school | 900540 | 180011 | Brookfield School District | 90054000109 | 186111 | Brookfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 680 | 20 | 110 | 0 | 65 | * | * | 442 | 438 | 15 | 133 | 880 | 680 | 20 | 110 | 0 | 65 | 442 | 438 | 15 | 133 | 880 | |||||||||||||||||||||||||||||||
2451844 | 2451844 | CT | school | 900690 | 230011 | Canton School District | 90069000118 | 236111 | Canton High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 411 | 26 | 25 | 0 | * | 0 | * | 239 | 244 | 0 | 68 | 483 | 411 | 26 | 25 | 0 | 0 | 239 | 244 | 0 | 68 | 483 | |||||||||||||||||||||||||||||||
2451862 | 2451862 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001513 | 2415114 | Academy of Aerospace and Engineering | Regional Education Service Center Schools | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 166 | 229 | 286 | * | 75 | * | 27 | 542 | 244 | 33 | 108 | 786 | 166 | 229 | 286 | 75 | 27 | 542 | 244 | 33 | 108 | 786 | |||||||||||||||||||||||||||||||
2451863 | 2451863 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001592 | 2416514 | Academy of Science and Innovation | Regional Education Service Center Schools | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 165 | 203 | 362 | * | 38 | * | 27 | 378 | 423 | 36 | 116 | 801 | 165 | 203 | 362 | 38 | 27 | 378 | 423 | 36 | 116 | 801 | |||||||||||||||||||||||||||||||
2451865 | 2451865 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070000880 | 2416114 | Metropolitan Learning Center for Global and International Studies | Regional Education Service Center Schools | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 137 | 337 | 159 | * | 28 | * | 46 | 314 | 396 | 14 | 104 | 710 | 137 | 337 | 159 | 28 | 46 | 314 | 396 | 14 | 104 | 710 | |||||||||||||||||||||||||||||||
2451868 | 2451868 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001532 | 2415214 | Civic Leadership High School | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 68 | 63 | 189 | 0 | * | * | 16 | 186 | 158 | 23 | 67 | 344 | 68 | 63 | 189 | 0 | 16 | 186 | 158 | 23 | 67 | 344 | |||||||||||||||||||||||||||||||
2451869 | 2451869 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001497 | 2416414 | Greater Hartford Academy of the Arts High School - Full Day | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 116 | 125 | 177 | 0 | * | 0 | * | 130 | 312 | 13 | 63 | 442 | 116 | 125 | 177 | 0 | 0 | 130 | 312 | 13 | 63 | 442 | |||||||||||||||||||||||||||||||
2451880 | 2451880 | CT | school | 900750 | 250011 | Cheshire School District | 90075000123 | 256111 | Cheshire High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1177 | 33 | 68 | * | 156 | 0 | * | 716 | 734 | 11 | 160 | 1450 | 1177 | 33 | 68 | 156 | 0 | 716 | 734 | 11 | 160 | 1450 | |||||||||||||||||||||||||||||||
2451887 | 2451887 | CT | school | 900810 | 270011 | Clinton School District | 90081000134 | 276111 | The Morgan School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 477 | * | 79 | * | 15 | * | 6 | 303 | 279 | 19 | 69 | 582 | 477 | 79 | 15 | 6 | 303 | 279 | 19 | 69 | 582 | ||||||||||||||||||||||||||||||||
2451891 | 2451891 | CT | school | 900840 | 280011 | Colchester School District | 90084000135 | 286111 | Bacon Academy | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 651 | * | 47 | * | 19 | 0 | 26 | 382 | 377 | * | 104 | 759 | 651 | 47 | 19 | 0 | 26 | 382 | 377 | 104 | 759 | ||||||||||||||||||||||||||||||||
2451907 | 2451907 | CT | school | 900960 | 320011 | Coventry School District | 90096000143 | 326111 | Coventry High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 389 | * | 19 | * | 6 | 0 | 23 | 210 | 230 | 0 | 50 | 440 | 389 | 19 | 6 | 0 | 23 | 210 | 230 | 0 | 50 | 440 | |||||||||||||||||||||||||||||||
2451911 | 2451911 | CT | school | 900990 | 330011 | Cromwell School District | 90099000145 | 336111 | Cromwell High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 384 | 51 | 42 | * | 39 | 0 | * | 272 | 254 | 7 | 58 | 526 | 384 | 51 | 42 | 39 | 0 | 272 | 254 | 7 | 58 | 526 | |||||||||||||||||||||||||||||||
2451930 | 2451930 | CT | school | 901020 | 340011 | Danbury School District | 90102000150 | 346111 | Danbury High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1078 | 251 | 1445 | * | 225 | * | 81 | 1612 | 1474 | 434 | 425 | 3086 | 1078 | 251 | 1445 | 225 | 81 | 1612 | 1474 | 434 | 425 | 3086 | |||||||||||||||||||||||||||||||
2451938 | 2451938 | CT | school | 901050 | 350011 | Darien School District | 90105000164 | 356111 | Darien High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1238 | 20 | 73 | * | 70 | 0 | * | 726 | * | * | 244 | 1418 | 1238 | 20 | 73 | 70 | 0 | 726 | 244 | 1418 | |||||||||||||||||||||||||||||||||
2451944 | 2451944 | CT | school | 901110 | 370011 | Derby School District | 90111000175 | 376111 | Derby High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 150 | 64 | 101 | * | * | * | 10 | 179 | 151 | 10 | 46 | 330 | 150 | 64 | 101 | 10 | 179 | 151 | 10 | 46 | 330 | ||||||||||||||||||||||||||||||||
2451948 | 2451948 | CT | school | 901170 | 400011 | East Granby School District | 90117000181 | 406111 | East Granby High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 198 | 21 | 20 | * | 16 | 0 | * | 131 | 132 | * | 33 | 263 | 198 | 21 | 20 | 16 | 0 | 131 | 132 | 33 | 263 | ||||||||||||||||||||||||||||||||
2451951 | 2451951 | CT | school | 901200 | 410011 | East Haddam School District | 90120000185 | 416111 | Nathan Hale-Ray High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 299 | * | 16 | * | * | * | * | 180 | 146 | 0 | 38 | 326 | 299 | 16 | 180 | 146 | 0 | 38 | 326 | ||||||||||||||||||||||||||||||||||
2451955 | 2451955 | CT | school | 901230 | 420011 | East Hampton School District | 90123000187 | 426111 | East Hampton High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 455 | 6 | 24 | * | 7 | * | 6 | 261 | 239 | * | 39 | 500 | 455 | 6 | 24 | 7 | 6 | 261 | 239 | 39 | 500 | ||||||||||||||||||||||||||||||||
2451969 | 2451969 | CT | school | 901260 | 430011 | East Hartford School District | 90126001477 | 436311 | Connecticut IB Academy | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 43 | 59 | 48 | * | 35 | 0 | * | 83 | 108 | 6 | * | 191 | 43 | 59 | 48 | 35 | 0 | 83 | 108 | 6 | 191 | ||||||||||||||||||||||||||||||||
2451970 | 2451970 | CT | school | 901260 | 430011 | East Hartford School District | 90126000200 | 436211 | East Hartford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 230 | 624 | 782 | * | 101 | * | 34 | 948 | 829 | 147 | 311 | 1777 | 230 | 624 | 782 | 101 | 34 | 948 | 829 | 147 | 311 | 1777 | |||||||||||||||||||||||||||||||
2451971 | 2451971 | CT | school | 901260 | 430011 | East Hartford School District | 90126001377 | 436411 | Synergy Alternative Program | Program | Alternative School | No | High | 10 | 12 | 2019 | pk_12_total | * | 28 | 50 | 0 | 0 | 0 | * | 63 | 31 | 6 | 21 | 94 | 28 | 50 | 0 | 0 | 0 | 63 | 31 | 6 | 21 | 94 | |||||||||||||||||||||||||||||||
2451979 | 2451979 | CT | school | 901290 | 440011 | East Haven School District | 90129000216 | 446111 | East Haven High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 567 | 30 | 239 | 0 | 47 | * | * | 473 | 424 | 81 | 124 | 897 | 567 | 30 | 239 | 0 | 47 | 473 | 424 | 81 | 124 | 897 | |||||||||||||||||||||||||||||||
2451986 | 2451986 | CT | school | 901320 | 450011 | East Lyme School District | 90132000223 | 456111 | East Lyme High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 750 | 23 | 74 | * | 96 | * | 53 | 506 | 496 | * | 132 | 1002 | 750 | 23 | 74 | 96 | 53 | 506 | 496 | 132 | 1002 | ||||||||||||||||||||||||||||||||
2451990 | 2451990 | CT | school | 901350 | 470011 | East Windsor School District | 90135000229 | 476111 | East Windsor High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 174 | 47 | 55 | 0 | * | 0 | * | 168 | 127 | 7 | 64 | 295 | 174 | 47 | 55 | 0 | 0 | 168 | 127 | 7 | 64 | 295 | |||||||||||||||||||||||||||||||
2451993 | 2451993 | CT | school | 901360 | 2530014 | Eastern Connecticut Regional Educational Service Center (EASTCONN) | 90136001507 | 2536014 | Arts at the Capitol Theater Magnet School (ACT) | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 70 | * | 32 | * | 0 | 0 | 9 | 30 | 90 | * | 23 | 120 | 70 | 32 | 0 | 0 | 9 | 30 | 90 | 23 | 120 | ||||||||||||||||||||||||||||||||
2451994 | 2451994 | CT | school | 901360 | 2530014 | Eastern Connecticut Regional Educational Service Center (EASTCONN) | 90136001530 | 2536114 | Quinebaug Middle College | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 128 | 6 | 37 | * | * | 0 | * | 61 | 117 | 0 | 26 | 178 | 128 | 6 | 37 | 0 | 61 | 117 | 0 | 26 | 178 | ||||||||||||||||||||||||||||||||
2452009 | 2452009 | CT | school | 901440 | 480011 | Ellington School District | 90144000237 | 486111 | Ellington High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 666 | 27 | 35 | 0 | 50 | 0 | 20 | 403 | 395 | * | 102 | 798 | 666 | 27 | 35 | 0 | 50 | 0 | 20 | 403 | 395 | 102 | 798 | ||||||||||||||||||||||||||||||
2452030 | 2452030 | CT | school | 901470 | 490011 | Enfield School District | 90147000243 | 496111 | Enfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1073 | 94 | 214 | * | 53 | * | 58 | 756 | 744 | 13 | 226 | 1500 | 1073 | 94 | 214 | 53 | 58 | 756 | 744 | 13 | 226 | 1500 | |||||||||||||||||||||||||||||||
2452050 | 2452050 | CT | school | 901530 | 510011 | Fairfield School District | 90153001379 | 516011 | Fairfield Ludlowe High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1243 | * | 130 | * | 94 | 0 | 45 | 751 | 782 | 10 | 171 | 1533 | 1243 | 130 | 94 | 0 | 45 | 751 | 782 | 10 | 171 | 1533 | |||||||||||||||||||||||||||||||
2452051 | 2452051 | CT | school | 901530 | 510011 | Fairfield School District | 90153000256 | 516211 | Fairfield Warde High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1056 | * | 225 | * | 90 | 0 | 60 | 748 | 731 | 43 | 191 | 1479 | 1056 | 225 | 90 | 0 | 60 | 748 | 731 | 43 | 191 | 1479 | |||||||||||||||||||||||||||||||
2452061 | 2452061 | CT | school | 901560 | 520011 | Farmington School District | 90156000273 | 526111 | Farmington High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 849 | 62 | 73 | * | 243 | 0 | * | 629 | 617 | 14 | 156 | 1246 | 849 | 62 | 73 | 243 | 0 | 629 | 617 | 14 | 156 | 1246 | |||||||||||||||||||||||||||||||
2452073 | 2452073 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000283 | 546111 | Glastonbury High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1470 | 67 | 158 | * | 210 | * | 89 | 978 | 1023 | 11 | 202 | 2001 | 1470 | 67 | 158 | 210 | 89 | 978 | 1023 | 11 | 202 | 2001 | |||||||||||||||||||||||||||||||
2452078 | 2452078 | CT | school | 901680 | 560011 | Granby School District | 90168000289 | 566111 | Granby Memorial High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 562 | 31 | 27 | * | * | 0 | 25 | 334 | 321 | 0 | 73 | 655 | 562 | 31 | 27 | 0 | 25 | 334 | 321 | 0 | 73 | 655 | |||||||||||||||||||||||||||||||
2452093 | 2452093 | CT | school | 901710 | 570011 | Greenwich School District | 90171000300 | 576111 | Greenwich High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1789 | 78 | 588 | * | 199 | * | 86 | 1401 | * | 68 | 316 | 2746 | 1789 | 78 | 588 | 199 | 86 | 1401 | 68 | 316 | 2746 |
Advanced export
JSON shape: default, array, newline-delimited
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]);