enrollments
Data source: Big Local News · About: Big Local
1,444 rows where grade = "pk_12_total", state = "CT" and year = 2021 sorted by school
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2757318 | 2757318 | CT | school | 900270 | 90011 | Bethel School District | 90027000024 | 96111 | Bethel High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 628 | 32 | 183 | * | 79 | * | 10 | 485 | 450 | 27 | 129 | 935 | 628 | 32 | 183 | 79 | 10 | 485 | 450 | 27 | 129 | 935 | |||||||||||||||||||||||||||||||
2757317 | 2757317 | CT | school | 900270 | 90011 | Bethel School District | 90027000025 | 95111 | Bethel Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 496 | 28 | 178 | 12 | 53 | 0 | 28 | 413 | 382 | 33 | 94 | 795 | 496 | 28 | 178 | 12 | 53 | 0 | 28 | 413 | 382 | 33 | 94 | 795 | |||||||||||||||||||||||||||||
2758204 | 2758204 | CT | school | 903536 | 2140012 | Regional School District 14 | 90353600743 | 2140112 | Bethlehem Elementary School | Regional Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 242 | * | 18 | * | * | 0 | 11 | 144 | 136 | * | 57 | 280 | 242 | 18 | 0 | 11 | 144 | 136 | 57 | 280 | |||||||||||||||||||||||||||||||||
2758036 | 2758036 | CT | school | 902790 | 930011 | New Haven School District | 90279000545 | 935511 | Betsy Ross Arts Magnet School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | pk_12_total | 53 | 179 | 156 | * | * | 0 | 13 | 141 | 264 | 32 | 50 | 405 | 53 | 179 | 156 | 0 | 13 | 141 | 264 | 32 | 50 | 405 | |||||||||||||||||||||||||||||||
2757887 | 2757887 | CT | school | 902490 | 830011 | Middletown School District | 90249000453 | 830211 | Bielefield School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 89 | 66 | 50 | 0 | 17 | 0 | 33 | 125 | 130 | 9 | 35 | 255 | 89 | 66 | 50 | 0 | 17 | 0 | 33 | 125 | 130 | 9 | 35 | 255 | |||||||||||||||||||||||||||||
2757374 | 2757374 | CT | school | 900450 | 150011 | Bridgeport School District | 90045001636 | 150611 | Biotechnology, Research & Zoological Studies Magnet High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 63 | 123 | 166 | * | 27 | 0 | * | 94 | 288 | 16 | 27 | 382 | 63 | 123 | 166 | 27 | 0 | 94 | 288 | 16 | 27 | 382 | |||||||||||||||||||||||||||||||
2758398 | 2758398 | CT | school | 904560 | 1420011 | Tolland School District | 90456000948 | 1420111 | Birch Grove Primary School | Public Schools | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 367 | * | 43 | * | 13 | 0 | 26 | 250 | 213 | 8 | 53 | 463 | 367 | 43 | 13 | 0 | 26 | 250 | 213 | 8 | 53 | 463 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2758021 | 2758021 | CT | school | 902790 | 930011 | New Haven School District | 90279000546 | 934311 | Bishop Woods Architecture and Design Magnet School | Public Schools | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 34 | 152 | 243 | 0 | 7 | 0 | 8 | 224 | 220 | 67 | 53 | 444 | 34 | 152 | 243 | 0 | 7 | 0 | 8 | 224 | 220 | 67 | 53 | 444 | |||||||||||||||||||||||||||||
2758022 | 2758022 | CT | school | 930011 | New Haven School District | 937911 | Bishop Woods Self Contained Autism | Program | 2021 | pk_12_total | * | * | 7 | 0 | 0 | 0 | 0 | * | * | 0 | 12 | 12 | 7 | 0 | 0 | 0 | 0 | 0 | 12 | 12 | ||||||||||||||||||||||||||||||||||||||||
2757345 | 2757345 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000052 | 150311 | Black Rock School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 119 | 67 | 274 | * | 9 | * | * | 247 | * | 104 | 77 | 474 | 119 | 67 | 274 | 9 | 247 | 104 | 77 | 474 | |||||||||||||||||||||||||||||||||
2758391 | 2758391 | CT | school | 904500 | 1400011 | Thomaston School District | 90450000906 | 1400111 | Black Rock School | Public Schools | Regular School | No | Elementary | PK | 03 | 2021 | pk_12_total | 226 | * | 23 | * | 8 | 0 | * | 132 | 134 | * | 43 | 266 | 226 | 23 | 8 | 0 | 132 | 134 | 43 | 266 | |||||||||||||||||||||||||||||||||
2757346 | 2757346 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000053 | 154011 | Blackham School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 166 | 265 | 543 | 13 | 31 | * | * | 562 | 468 | 260 | 143 | 1030 | 166 | 265 | 543 | 13 | 31 | 562 | 468 | 260 | 143 | 1030 | |||||||||||||||||||||||||||||||
2758565 | 2758565 | CT | school | 1560011 | West Haven School District | 1560711 | Blended | Program | 2021 | pk_12_total | 27 | * | 13 | 0 | 0 | 0 | * | 34 | 16 | * | 11 | 50 | 27 | 13 | 0 | 0 | 0 | 34 | 16 | 11 | 50 | |||||||||||||||||||||||||||||||||||||||
2758566 | 2758566 | CT | school | 1560011 | West Haven School District | 1560511 | Blended (Molloy) | Program | 2021 | pk_12_total | 0 | * | * | 0 | 0 | 0 | 0 | * | * | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2757328 | 2757328 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000029 | 116111 | Bloomfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 10 | 422 | 58 | * | * | 0 | 10 | 267 | 239 | 13 | 101 | 506 | 10 | 422 | 58 | 0 | 10 | 267 | 239 | 13 | 101 | 506 | |||||||||||||||||||||||||||||||
2757329 | 2757329 | CT | school | 900360 | 120011 | Bolton School District | 90036000036 | 120111 | Bolton Center School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 370 | 25 | 54 | 0 | 9 | 0 | 28 | * | 243 | 7 | 56 | 486 | 370 | 25 | 54 | 0 | 9 | 0 | 28 | 243 | 7 | 56 | 486 | ||||||||||||||||||||||||||||||
2757330 | 2757330 | CT | school | 900360 | 120011 | Bolton School District | 90036000037 | 126111 | Bolton High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 207 | 13 | 29 | 0 | 7 | 0 | 6 | 134 | 128 | 0 | 26 | 262 | 207 | 13 | 29 | 0 | 7 | 0 | 6 | 134 | 128 | 0 | 26 | 262 | |||||||||||||||||||||||||||||
2757331 | 2757331 | CT | school | 120011 | Bolton School District | 120211 | Bolton Transition Program | Program | 2021 | pk_12_total | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | * | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
2758659 | 2758659 | CT | school | 900217 | 2950013 | Booker T. Washington Academy District | 90021701750 | 2950113 | Booker T. Washington Academy | Public Charter Schools | Regular School | Yes | Elementary | KG | 07 | 2021 | pk_12_total | * | 403 | 63 | 0 | * | 0 | 10 | 242 | 238 | 22 | 36 | 480 | 403 | 63 | 0 | 0 | 10 | 242 | 238 | 22 | 36 | 480 | |||||||||||||||||||||||||||||||
2758194 | 2758194 | CT | school | 903530 | 2120012 | Regional School District 12 | 90353000731 | 2120212 | Booth Free School | Regional Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 64 | 0 | * | 0 | * | 0 | 6 | 35 | 38 | * | 11 | 73 | 64 | 0 | 0 | 0 | 6 | 35 | 38 | 11 | 73 | ||||||||||||||||||||||||||||||||
2758265 | 2758265 | CT | school | 904050 | 1260011 | Shelton School District | 90405000796 | 1261011 | Booth Hill School | Public Schools | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 217 | 16 | 44 | 0 | 14 | 0 | 7 | 156 | 142 | 37 | 28 | 298 | 217 | 16 | 44 | 0 | 14 | 0 | 7 | 156 | 142 | 37 | 28 | 298 | |||||||||||||||||||||||||||||
2758413 | 2758413 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000927 | 1440111 | Booth Hill School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 323 | 24 | 79 | 0 | 48 | * | * | 254 | 234 | 34 | 58 | 488 | 323 | 24 | 79 | 0 | 48 | 254 | 234 | 34 | 58 | 488 | |||||||||||||||||||||||||||||||
2758084 | 2758084 | CT | school | 902940 | 980011 | Norfolk School District | 90294000618 | 980111 | Botelle Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 68 | 0 | * | 0 | 0 | 0 | * | 42 | 38 | * | 18 | 80 | 68 | 0 | 0 | 0 | 0 | 42 | 38 | 18 | 80 | ||||||||||||||||||||||||||||||||
2757838 | 2757838 | CT | school | 902310 | 770011 | Manchester School District | 90231000417 | 770111 | Bowers School | Public Schools | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 133 | 70 | 103 | 0 | 15 | * | * | 187 | 146 | 24 | 53 | 333 | 133 | 70 | 103 | 0 | 15 | 187 | 146 | 24 | 53 | 333 | |||||||||||||||||||||||||||||||
2757522 | 2757522 | CT | school | 901110 | 370011 | Derby School District | 90111000174 | 370611 | Bradley School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 79 | 49 | 77 | 0 | * | * | 18 | 118 | 113 | 13 | 32 | 231 | 79 | 49 | 77 | 0 | 18 | 118 | 113 | 13 | 32 | 231 | |||||||||||||||||||||||||||||||
2758546 | 2758546 | CT | school | 1550011 | West Hartford School District | 90492001705 | 1559311 | Braeburn Learning Center | Program | 2021 | pk_12_total | 0 | 0 | * | 0 | 0 | 0 | 0 | * | * | * | * | * | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||
2758537 | 2758537 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001009 | 1550211 | Braeburn School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 243 | 23 | 26 | 0 | 24 | 0 | 18 | 173 | 161 | 15 | 41 | 334 | 243 | 23 | 26 | 0 | 24 | 0 | 18 | 173 | 161 | 15 | 41 | 334 | |||||||||||||||||||||||||||||
2758236 | 2758236 | CT | school | 903810 | 1180011 | Ridgefield School District | 90381000525 | 1180611 | Branchville Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 289 | * | 22 | * | 16 | 0 | 10 | 163 | 176 | 6 | 51 | 339 | 289 | 22 | 16 | 0 | 10 | 163 | 176 | 6 | 51 | 339 | |||||||||||||||||||||||||||||||
2757338 | 2757338 | CT | school | 900420 | 140011 | Branford School District | 90042000039 | 146111 | Branford High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 575 | 25 | 95 | * | 63 | 0 | * | 398 | * | 14 | 94 | 780 | 575 | 25 | 95 | 63 | 0 | 398 | 14 | 94 | 780 | ||||||||||||||||||||||||||||||||
2757339 | 2757339 | CT | school | 140011 | Branford School District | 90042001742 | 140211 | Branford High School Atlas Program | Program | 2021 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | 12 | 7 | 0 | * | 19 | 0 | 0 | 0 | 0 | 0 | 12 | 7 | 0 | 19 | ||||||||||||||||||||||||||||||||||||||
2757341 | 2757341 | CT | school | 900215 | 2900013 | Brass City Charter School District | 90021501644 | 2900113 | Brass City Charter School | Public Charter Schools | Regular School | Yes | Elementary | PK | 08 | 2021 | pk_12_total | 31 | 120 | 177 | * | * | 0 | 22 | 173 | 188 | 16 | 34 | 361 | 31 | 120 | 177 | 0 | 22 | 173 | 188 | 16 | 34 | 361 | |||||||||||||||||||||||||||||||
2757730 | 2757730 | CT | school | 901920 | 640011 | Hartford School District | 90192001534 | 643511 | Breakthrough Magnet School, North | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | * | 161 | 66 | 0 | 71 | * | 26 | 187 | 157 | 23 | 34 | 344 | 161 | 66 | 0 | 71 | 26 | 187 | 157 | 23 | 34 | 344 | |||||||||||||||||||||||||||||||
2757731 | 2757731 | CT | school | 901920 | 640011 | Hartford School District | 90192001369 | 643311 | Breakthrough Magnet School, South | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 39 | 79 | 188 | * | * | 0 | 17 | 170 | 171 | 40 | 54 | 341 | 39 | 79 | 188 | 0 | 17 | 170 | 171 | 40 | 54 | 341 | |||||||||||||||||||||||||||||||
2757999 | 2757999 | CT | school | 902790 | 930011 | New Haven School District | 90279001585 | 932111 | Brennan Rogers School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 17 | 203 | 124 | * | * | * | 8 | 181 | 175 | 15 | 65 | 356 | 17 | 203 | 124 | 8 | 181 | 175 | 15 | 65 | 356 | ||||||||||||||||||||||||||||||||
2758023 | 2758023 | CT | school | 930011 | New Haven School District | 937211 | Brennan Rogers Self Contained Autism | Program | 2021 | pk_12_total | * | 13 | 8 | 0 | 0 | 0 | * | * | * | 0 | 24 | 24 | 13 | 8 | 0 | 0 | 0 | 0 | 24 | 24 | ||||||||||||||||||||||||||||||||||||||||
2758702 | 2758702 | CT | school | 3360015 | Unified School District #1 | 90000300343 | 3360115 | Bridgeport Correctional Center | State Agency Facilities | 2021 | pk_12_total | 0 | 0 | * | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
2757371 | 2757371 | CT | school | 150011 | Bridgeport School District | 90045001472 | 159011 | Bridgeport Learning Center | Program | 2021 | pk_12_total | 0 | 37 | * | 0 | * | 0 | 0 | 53 | 8 | 6 | 61 | 61 | 0 | 37 | 0 | 0 | 0 | 53 | 8 | 6 | 61 | 61 | |||||||||||||||||||||||||||||||||||||
2757375 | 2757375 | CT | school | 900450 | 150011 | Bridgeport School District | 90045001631 | 151611 | Bridgeport Military Academy | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 36 | 84 | 214 | * | * | * | * | 167 | 173 | 47 | 84 | 340 | 36 | 84 | 214 | 167 | 173 | 47 | 84 | 340 | |||||||||||||||||||||||||||||||||
2757306 | 2757306 | CT | school | 50011 | Barkhamsted School District | 50211 | Bridges at Barkhamsted Elementary School | Program | 2021 | pk_12_total | * | 0 | 0 | 0 | 0 | 0 | * | * | * | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | ||||||||||||||||||||||||||||||||||||||||
2758117 | 2758117 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000638 | 1036211 | Brien McMahon High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 401 | 258 | 960 | * | 56 | 0 | * | 860 | 850 | 263 | 211 | 1710 | 401 | 258 | 960 | 56 | 0 | 860 | 850 | 263 | 211 | 1710 | |||||||||||||||||||||||||||||||
2757411 | 2757411 | CT | school | 900510 | 170011 | Bristol School District | 90051000092 | 176111 | Bristol Central High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 656 | 77 | 391 | * | * | 0 | 47 | * | 616 | 43 | 235 | 1202 | 656 | 77 | 391 | 0 | 47 | 616 | 43 | 235 | 1202 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2757412 | 2757412 | CT | school | 900510 | 170011 | Bristol School District | 90051000093 | 176211 | Bristol Eastern High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 658 | 86 | 274 | * | 43 | * | 42 | 535 | 573 | 45 | 226 | 1108 | 658 | 86 | 274 | 43 | 42 | 535 | 573 | 45 | 226 | 1108 | |||||||||||||||||||||||||||||||
2757413 | 2757413 | CT | school | 170011 | Bristol School District | 90051001746 | 173311 | Bristol Preparatory Academy | Program | 2021 | pk_12_total | 27 | * | 17 | 0 | 0 | 0 | * | 33 | 14 | 0 | * | 47 | 27 | 17 | 0 | 0 | 0 | 33 | 14 | 0 | 47 | ||||||||||||||||||||||||||||||||||||||
2758548 | 2758548 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001419 | 1555311 | Bristow Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 202 | 28 | 58 | 0 | 40 | 0 | 21 | 180 | 169 | 9 | 55 | 349 | 202 | 28 | 58 | 0 | 40 | 0 | 21 | 180 | 169 | 9 | 55 | 349 | |||||||||||||||||||||||||||||
2757571 | 2757571 | CT | school | 901350 | 470011 | East Windsor School District | 90135000228 | 470111 | Broad Brook Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 233 | 43 | 101 | 0 | 51 | 0 | 39 | 242 | 225 | 56 | 77 | 467 | 233 | 43 | 101 | 0 | 51 | 0 | 39 | 242 | 225 | 56 | 77 | 467 | |||||||||||||||||||||||||||||
2757508 | 2757508 | CT | school | 901020 | 340011 | Danbury School District | 90102000149 | 345111 | Broadview Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 312 | 82 | 534 | * | 59 | 0 | * | 541 | 482 | 177 | 165 | 1023 | 312 | 82 | 534 | 59 | 0 | 541 | 482 | 177 | 165 | 1023 | |||||||||||||||||||||||||||||||
2757419 | 2757419 | CT | school | 900540 | 180011 | Brookfield School District | 90054000109 | 186111 | Brookfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 687 | 22 | 109 | * | 77 | * | * | 458 | 444 | 13 | 138 | 902 | 687 | 22 | 109 | 77 | 458 | 444 | 13 | 138 | 902 | ||||||||||||||||||||||||||||||||
2757420 | 2757420 | CT | school | 900570 | 190011 | Brooklyn School District | 90057000113 | 190111 | Brooklyn Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 378 | 10 | 62 | * | * | 0 | 21 | 240 | 242 | 9 | 78 | 482 | 378 | 10 | 62 | 0 | 21 | 240 | 242 | 9 | 78 | 482 | |||||||||||||||||||||||||||||||
2757421 | 2757421 | CT | school | 900570 | 190011 | Brooklyn School District | 90057000114 | 195111 | Brooklyn Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | pk_12_total | 266 | 6 | 34 | 0 | 7 | 0 | 21 | 172 | 162 | * | 49 | 334 | 266 | 6 | 34 | 0 | 7 | 0 | 21 | 172 | 162 | 49 | 334 | ||||||||||||||||||||||||||||||
2758100 | 2758100 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000640 | 1030211 | Brookside Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 47 | 57 | 291 | 0 | * | * | 17 | 226 | 199 | 110 | 57 | 425 | 47 | 57 | 291 | 0 | 17 | 226 | 199 | 110 | 57 | 425 | |||||||||||||||||||||||||||||||
2757974 | 2757974 | CT | school | 890011 | New Britain School District | 90267001557 | 899111 | Brookside School | Program | 2021 | pk_12_total | * | 6 | 37 | 0 | 0 | 0 | * | 24 | 24 | 13 | 29 | 48 | 6 | 37 | 0 | 0 | 0 | 24 | 24 | 13 | 29 | 48 | |||||||||||||||||||||||||||||||||||||
2758173 | 2758173 | CT | school | 903390 | 1130011 | Portland School District | 90339001393 | 1130511 | Brownstone Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2021 | pk_12_total | 146 | * | 30 | 0 | * | 0 | 9 | 104 | * | * | 38 | 196 | 146 | 30 | 0 | 0 | 9 | 104 | 38 | 196 | |||||||||||||||||||||||||||||||||
2757347 | 2757347 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000054 | 150411 | Bryant School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 40 | 115 | 136 | * | 8 | 0 | * | 157 | 153 | 71 | 64 | 310 | 40 | 115 | 136 | 8 | 0 | 157 | 153 | 71 | 64 | 310 | |||||||||||||||||||||||||||||||
2757834 | 2757834 | CT | school | 902310 | 770011 | Manchester School District | 90231000418 | 770311 | Buckley School | Public Schools | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 133 | 82 | 77 | * | 32 | 0 | * | 182 | 144 | 22 | 46 | 326 | 133 | 82 | 77 | 32 | 0 | 182 | 144 | 22 | 46 | 326 | |||||||||||||||||||||||||||||||
2758477 | 2758477 | CT | school | 1510011 | Waterbury School District | 1514611 | Bucks Hill Autism | Program | 2021 | pk_12_total | 9 | 11 | 20 | 0 | * | 0 | * | 32 | 11 | 11 | 43 | 43 | 9 | 11 | 20 | 0 | 0 | 32 | 11 | 11 | 43 | 43 | ||||||||||||||||||||||||||||||||||||||
2758478 | 2758478 | CT | school | 1510011 | Waterbury School District | 1514311 | Bucks Hill Bilingual | Program | 2021 | pk_12_total | 0 | 0 | 221 | 0 | 0 | 0 | 0 | 133 | 88 | * | 22 | 221 | 0 | 0 | 221 | 0 | 0 | 0 | 0 | 133 | 88 | 22 | 221 | |||||||||||||||||||||||||||||||||||||
2758479 | 2758479 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000968 | 1510511 | Bucks Hill School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 19 | 58 | 220 | 0 | * | 0 | * | 166 | 146 | 46 | 62 | 312 | 19 | 58 | 220 | 0 | 0 | 166 | 146 | 46 | 62 | 312 | |||||||||||||||||||||||||||||||
2758538 | 2758538 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001011 | 1550411 | Bugbee School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 262 | 24 | 31 | * | 24 | 0 | * | 183 | 171 | 15 | 34 | 354 | 262 | 24 | 31 | 24 | 0 | 183 | 171 | 15 | 34 | 354 | |||||||||||||||||||||||||||||||
2757780 | 2757780 | CT | school | 901920 | 640011 | Hartford School District | 90192001572 | 647111 | Bulkeley High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 12 | 158 | 406 | * | 6 | * | 6 | 283 | 309 | 216 | 126 | 592 | 12 | 158 | 406 | 6 | 6 | 283 | 309 | 216 | 126 | 592 | |||||||||||||||||||||||||||||||
2758706 | 2758706 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201137 | 9001116 | Bullard-Havens Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2021 | pk_12_total | 24 | 224 | 544 | * | * | 0 | 24 | 399 | 429 | 85 | 83 | 828 | 24 | 224 | 544 | 0 | 24 | 399 | 429 | 85 | 83 | 828 | |||||||||||||||||||||||||||||||
2758260 | 2758260 | CT | school | 903990 | 1240011 | Seymour School District | 90399000790 | 1240111 | Bungay School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 305 | 23 | 60 | 0 | 22 | 0 | 8 | 219 | 199 | 34 | 55 | 418 | 305 | 23 | 60 | 0 | 22 | 0 | 8 | 219 | 199 | 34 | 55 | 418 | |||||||||||||||||||||||||||||
2758480 | 2758480 | CT | school | 1510011 | Waterbury School District | 1510111 | Bunker Hill BDLC | Program | 2021 | pk_12_total | * | * | 10 | 0 | 0 | 0 | 0 | * | * | * | 20 | 20 | 10 | 0 | 0 | 0 | 0 | 20 | 20 | |||||||||||||||||||||||||||||||||||||||||
2758460 | 2758460 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000969 | 1510611 | Bunker Hill School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 49 | 91 | 274 | * | * | 0 | 25 | 247 | 203 | 69 | 69 | 450 | 49 | 91 | 274 | 0 | 25 | 247 | 203 | 69 | 69 | 450 | |||||||||||||||||||||||||||||||
2758382 | 2758382 | CT | school | 904440 | 1380011 | Stratford School District | 90444000885 | 1386211 | Bunnell High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 393 | 237 | 330 | 0 | 32 | 0 | 30 | 489 | 533 | 24 | 107 | 1022 | 393 | 237 | 330 | 0 | 32 | 0 | 30 | 489 | 533 | 24 | 107 | 1022 | |||||||||||||||||||||||||||||
2757759 | 2757759 | CT | school | 901920 | 640011 | Hartford School District | 90192000357 | 640611 | Burns Latino Studies Academy | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 7 | 29 | 197 | * | 6 | 0 | * | 128 | 113 | 108 | 52 | 241 | 7 | 29 | 197 | 6 | 0 | 128 | 113 | 108 | 52 | 241 | |||||||||||||||||||||||||||||||
2758222 | 2758222 | CT | school | 903539 | 2170012 | Regional School District 17 | 90353900757 | 2170212 | Burr District Elementary School | Regional Schools | Regular School | No | Elementary | KG | 03 | 2021 | pk_12_total | 267 | * | 13 | 0 | * | 0 | 6 | 142 | 153 | * | 38 | 295 | 267 | 13 | 0 | 0 | 6 | 142 | 153 | 38 | 295 | ||||||||||||||||||||||||||||||||
2757625 | 2757625 | CT | school | 901530 | 510011 | Fairfield School District | 90153001378 | 510211 | Burr Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 255 | * | 29 | * | 29 | 0 | 27 | 176 | 174 | 13 | 55 | 350 | 255 | 29 | 29 | 0 | 27 | 176 | 174 | 13 | 55 | 350 | |||||||||||||||||||||||||||||||
2757770 | 2757770 | CT | school | 901920 | 640011 | Hartford School District | 90192000358 | 642311 | Burr Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 8 | 38 | 266 | * | 6 | * | * | 184 | 140 | 120 | 65 | 324 | 8 | 38 | 266 | 6 | 184 | 140 | 120 | 65 | 324 | ||||||||||||||||||||||||||||||||
2757653 | 2757653 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000280 | 540211 | Buttonball Lane School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 276 | 10 | 52 | 0 | 84 | 0 | 27 | 241 | 208 | 33 | 39 | 449 | 276 | 10 | 52 | 0 | 84 | 0 | 27 | 241 | 208 | 33 | 39 | 449 | |||||||||||||||||||||||||||||
2758051 | 2758051 | CT | school | 902820 | 950011 | New London School District | 90282000591 | 950311 | C.B. Jennings International Elementary Magnet | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 34 | 56 | 322 | * | * | 0 | 29 | 223 | 221 | 223 | 50 | 444 | 34 | 56 | 322 | 0 | 29 | 223 | 221 | 223 | 50 | 444 | |||||||||||||||||||||||||||||||
2757977 | 2757977 | CT | school | 890011 | New Britain School District | 90267001609 | 899411 | CLIMB | Program | 2021 | pk_12_total | * | * | 25 | 0 | 0 | 0 | 0 | 21 | 11 | 8 | 32 | 32 | 25 | 0 | 0 | 0 | 0 | 21 | 11 | 8 | 32 | 32 | |||||||||||||||||||||||||||||||||||||
2758658 | 2758658 | CT | school | 2440014 | Area Cooperative Educational Services | 2440114 | CREATE at Whitney Academy | Program | 2021 | pk_12_total | 22 | 19 | 23 | 0 | * | 0 | * | 54 | 13 | * | 67 | 67 | 22 | 19 | 23 | 0 | 0 | 54 | 13 | 67 | 67 | |||||||||||||||||||||||||||||||||||||||
2757448 | 2757448 | CT | school | 2410014 | Capitol Region Education Council | 2411914 | CREC Impact Academy | Program | 2021 | pk_12_total | * | 15 | 24 | 0 | 0 | 0 | * | 27 | 16 | * | * | 43 | 15 | 24 | 0 | 0 | 0 | 27 | 16 | 43 | ||||||||||||||||||||||||||||||||||||||||
2757912 | 2757912 | CT | school | 902520 | 840011 | Milford School District | 90252000467 | 840111 | Calf Pen Meadow School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 195 | 8 | 36 | 0 | 6 | 0 | 13 | 135 | 123 | * | 35 | 258 | 195 | 8 | 36 | 0 | 6 | 0 | 13 | 135 | 123 | 35 | 258 | ||||||||||||||||||||||||||||||
2757701 | 2757701 | CT | school | 901800 | 600011 | Guilford School District | 90180000330 | 600411 | Calvin Leete School | Public Schools | Regular School | No | Elementary | KG | 04 | 2021 | pk_12_total | 192 | * | 15 | 0 | * | 0 | 14 | 117 | 113 | 14 | 21 | 230 | 192 | 15 | 0 | 0 | 14 | 117 | 113 | 14 | 21 | 230 | |||||||||||||||||||||||||||||||
2757422 | 2757422 | CT | school | 900660 | 220011 | Canterbury School District | 90066001188 | 220211 | Canterbury Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2021 | pk_12_total | 222 | * | 16 | * | 0 | 0 | * | 123 | 123 | 0 | 24 | 246 | 222 | 16 | 0 | 0 | 123 | 123 | 0 | 24 | 246 | ||||||||||||||||||||||||||||||||
2757427 | 2757427 | CT | school | 900690 | 230011 | Canton School District | 90069000118 | 236111 | Canton High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 390 | 27 | 40 | * | 16 | 0 | * | 241 | * | * | 68 | 481 | 390 | 27 | 40 | 16 | 0 | 241 | 68 | 481 | |||||||||||||||||||||||||||||||||
2757425 | 2757425 | CT | school | 900690 | 230011 | Canton School District | 90069000119 | 230311 | Canton Intermediate School | Public Schools | Regular School | No | Elementary | 04 | 06 | 2021 | pk_12_total | 279 | 23 | 19 | 0 | * | * | 10 | 169 | 172 | * | 46 | 341 | 279 | 23 | 19 | 0 | 10 | 169 | 172 | 46 | 341 | ||||||||||||||||||||||||||||||||
2757426 | 2757426 | CT | school | 900690 | 230011 | Canton School District | 90069001376 | 235111 | Canton Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 193 | 23 | 16 | 0 | * | 0 | * | 125 | 118 | * | 38 | 243 | 193 | 23 | 16 | 0 | 0 | 125 | 118 | 38 | 243 | ||||||||||||||||||||||||||||||||
2758661 | 2758661 | CT | school | 900221 | 2970013 | Capital Preparatory Harbor School District | 90022101803 | 2970113 | Capital Preparatory Harbor School | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2021 | pk_12_total | 8 | 539 | 231 | * | * | 0 | * | 404 | 381 | 46 | 72 | 785 | 8 | 539 | 231 | 0 | 404 | 381 | 46 | 72 | 785 | ||||||||||||||||||||||||||||||||
2757732 | 2757732 | CT | school | 901920 | 640011 | Hartford School District | 90192001435 | 646911 | Capital Preparatory Magnet School | Public Schools | Regular School | No | Other | PK | 12 | 2021 | pk_12_total | 30 | 426 | 165 | 0 | 11 | 0 | 28 | 337 | 323 | 27 | 94 | 660 | 30 | 426 | 165 | 0 | 11 | 0 | 28 | 337 | 323 | 27 | 94 | 660 | |||||||||||||||||||||||||||||
2757487 | 2757487 | CT | school | 900960 | 320011 | Coventry School District | 90096000141 | 325111 | Capt. Nathan Hale School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 344 | * | 24 | 0 | * | 0 | 9 | 200 | 187 | * | 62 | 387 | 344 | 24 | 0 | 0 | 9 | 200 | 187 | 62 | 387 | ||||||||||||||||||||||||||||||||
2757559 | 2757559 | CT | school | 901290 | 440011 | East Haven School District | 90129000605 | 441711 | Carbone School/East Haven Academy | Public Schools | Regular School | No | Elementary | 01 | 08 | 2021 | pk_12_total | 212 | 11 | 57 | * | * | 0 | 13 | 154 | 149 | 12 | 39 | 303 | 212 | 11 | 57 | 0 | 13 | 154 | 149 | 12 | 39 | 303 | |||||||||||||||||||||||||||||||
2757325 | 2757325 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001375 | 110711 | Carmen Arace Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2021 | pk_12_total | 6 | 186 | 29 | * | * | 0 | 9 | 120 | 114 | 10 | 41 | 234 | 6 | 186 | 29 | 0 | 9 | 120 | 114 | 10 | 41 | 234 | |||||||||||||||||||||||||||||||
2757327 | 2757327 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000034 | 115211 | Carmen Arace Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 7 | 224 | 29 | * | * | 0 | 8 | 133 | 137 | 7 | 61 | 270 | 7 | 224 | 29 | 0 | 8 | 133 | 137 | 7 | 61 | 270 | |||||||||||||||||||||||||||||||
2758563 | 2758563 | CT | school | 904950 | 1560011 | West Haven School District | 90495001037 | 1565311 | Carrigan 5/6 Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2021 | pk_12_total | 233 | 185 | 334 | * | * | 0 | 36 | 428 | 395 | 101 | 139 | 823 | 233 | 185 | 334 | 0 | 36 | 428 | 395 | 101 | 139 | 823 | |||||||||||||||||||||||||||||||
2758481 | 2758481 | CT | school | 1510011 | Waterbury School District | 1511911 | Carrington ESC | Program | 2021 | pk_12_total | * | * | 7 | 0 | * | 0 | 0 | 9 | 8 | * | 17 | 17 | 7 | 0 | 0 | 0 | 9 | 8 | 17 | 17 | ||||||||||||||||||||||||||||||||||||||||
2758461 | 2758461 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000970 | 1512711 | Carrington School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 103 | 101 | 225 | * | * | 0 | 26 | 233 | 236 | 53 | 60 | 469 | 103 | 101 | 225 | 0 | 26 | 233 | 236 | 53 | 60 | 469 | |||||||||||||||||||||||||||||||
2758125 | 2758125 | CT | school | 1040011 | Norwich School District | 90312001745 | 1040211 | Case Street Early Learning Center at DTZ | Program | 2021 | pk_12_total | * | 10 | 11 | 0 | * | 0 | * | 11 | 17 | 0 | 0 | 28 | 10 | 11 | 0 | 0 | 11 | 17 | 0 | 0 | 28 | ||||||||||||||||||||||||||||||||||||||
2757862 | 2757862 | CT | school | 902400 | 800011 | Meriden School District | 90240000440 | 801111 | Casimir Pulaski School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 99 | 64 | 401 | * | * | 0 | 27 | 311 | 289 | 121 | 86 | 600 | 99 | 64 | 401 | 0 | 27 | 311 | 289 | 121 | 86 | 600 | |||||||||||||||||||||||||||||||
2757688 | 2757688 | CT | school | 901770 | 590011 | Groton School District | 90177001494 | 592011 | Catherine Kolnaski Magnet School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 131 | 29 | 107 | * | 45 | * | 64 | 193 | 187 | 28 | 53 | 380 | 131 | 29 | 107 | 45 | 64 | 193 | 187 | 28 | 53 | 380 | |||||||||||||||||||||||||||||||
2757310 | 2757310 | CT | school | 900210 | 70011 | Berlin School District | 90021000017 | 75111 | Catherine M. McGee Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 489 | 18 | 82 | 0 | 24 | 0 | 19 | 315 | 317 | 10 | 115 | 632 | 489 | 18 | 82 | 0 | 24 | 0 | 19 | 315 | 317 | 10 | 115 | 632 | |||||||||||||||||||||||||||||
2758000 | 2758000 | CT | school | 902790 | 930011 | New Haven School District | 90279001484 | 934811 | Celentano BioTech, Health and Medical Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 24 | 186 | 129 | 0 | 11 | 0 | 9 | 164 | 195 | 40 | 56 | 359 | 24 | 186 | 129 | 0 | 11 | 0 | 9 | 164 | 195 | 40 | 56 | 359 | |||||||||||||||||||||||||||||
2758024 | 2758024 | CT | school | 930011 | New Haven School District | 937411 | Celentano Self Contained ID | Program | 2021 | pk_12_total | * | 14 | 8 | 0 | 0 | 0 | * | 19 | 8 | * | 27 | 27 | 14 | 8 | 0 | 0 | 0 | 19 | 8 | 27 | 27 | |||||||||||||||||||||||||||||||||||||||
2757416 | 2757416 | CT | school | 900540 | 180011 | Brookfield School District | 90054000110 | 180311 | Center Elementary School | Public Schools | Regular School | No | Elementary | PK | 01 | 2021 | pk_12_total | 273 | 9 | 25 | * | 27 | 0 | * | 177 | 169 | 15 | 57 | 346 | 273 | 9 | 25 | 27 | 0 | 177 | 169 | 15 | 57 | 346 | |||||||||||||||||||||||||||||||
2758427 | 2758427 | CT | school | 904680 | 1460011 | Vernon School District | 90468000939 | 1461411 | Center Road School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 206 | 40 | 109 | * | 41 | 0 | * | 235 | 201 | 34 | 59 | 436 | 206 | 40 | 109 | 41 | 0 | 235 | 201 | 34 | 59 | 436 | |||||||||||||||||||||||||||||||
2757536 | 2757536 | CT | school | 901230 | 420011 | East Hampton School District | 90123000186 | 420311 | Center School | Public Schools | Regular School | No | Elementary | 04 | 05 | 2021 | pk_12_total | 262 | * | 17 | 0 | * | 0 | 15 | 149 | 152 | * | 55 | 301 | 262 | 17 | 0 | 0 | 15 | 149 | 152 | 55 | 301 | ||||||||||||||||||||||||||||||||
2757593 | 2757593 | CT | school | 901440 | 480011 | Ellington School District | 90144000235 | 480111 | Center School | Public Schools | Regular School | No | Elementary | KG | 06 | 2021 | pk_12_total | 375 | 21 | 32 | 0 | 10 | * | * | 232 | 217 | * | 66 | 449 | 375 | 21 | 32 | 0 | 10 | 232 | 217 | 66 | 449 |
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]);