enrollments
Data source: Big Local News · About: Big Local
1,449 rows where grade = "pk_12_total", state = "CT" and year = 2019 sorted by school_state_id 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2453145 | 2453145 | CT | school | 905373 | 9030022 | The Woodstock Academy District | 90537311223 | 9036122 | The Woodstock Academy | Endowed and Incorporated Academies Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 925 | * | 26 | * | 124 | 0 | 11 | 545 | 553 | 0 | 74 | 1098 | 925 | 26 | 124 | 0 | 11 | 545 | 553 | 0 | 74 | 1098 | |||||||||||||||||||||||||||||||
2453105 | 2453105 | CT | school | 905372 | 9020022 | The Gilbert School District | 90537201222 | 9026122 | The Gilbert School | Endowed and Incorporated Academies Schools | Regular School | No | High | 07 | 12 | 2019 | pk_12_total | 348 | 8 | 82 | 0 | 50 | 0 | 23 | 275 | * | 16 | 74 | 511 | 348 | 8 | 82 | 0 | 50 | 0 | 23 | 275 | 16 | 74 | 511 | ||||||||||||||||||||||||||||||
2453136 | 2453136 | CT | school | 905371 | 9010022 | Norwich Free Academy District | 90537101221 | 9016122 | Norwich Free Academy | Endowed and Incorporated Academies Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1123 | 330 | 366 | 22 | 174 | 22 | 197 | 1084 | 1150 | 187 | 247 | 2234 | 1123 | 330 | 366 | 22 | 174 | 22 | 197 | 1084 | 1150 | 187 | 247 | 2234 | |||||||||||||||||||||||||||||
2453137 | 2453137 | CT | school | 905371 | 9010022 | Norwich Free Academy District | 90537101221 | 9010322 | Alternative Pathways to Success | Program | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 7 | * | * | 0 | 0 | 0 | 0 | * | * | * | * | 15 | 7 | 0 | 0 | 0 | 0 | 15 | |||||||||||||||||||||||||||||||||||
2453138 | 2453138 | CT | school | 905371 | 9010022 | Norwich Free Academy District | 90537101221 | 9010222 | Night School | Program | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | * | * | * | 0 | 0 | 0 | 0 | * | * | 0 | * | 7 | 0 | 0 | 0 | 0 | 0 | 7 | |||||||||||||||||||||||||||||||||||
2453122 | 2453122 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201139 | 9002716 | Ella T. Grasso Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 246 | 35 | 162 | * | 7 | * | 34 | 299 | 192 | 17 | 82 | 491 | 246 | 35 | 162 | 7 | 34 | 299 | 192 | 17 | 82 | 491 | |||||||||||||||||||||||||||||||
2453131 | 2453131 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201149 | 9002616 | Platt Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 322 | 111 | 325 | * | * | 0 | 35 | 514 | 294 | 19 | 95 | 808 | 322 | 111 | 325 | 0 | 35 | 514 | 294 | 19 | 95 | 808 | |||||||||||||||||||||||||||||||
2453123 | 2453123 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201141 | 9002516 | Emmett O'Brien Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 350 | 50 | 179 | 0 | * | * | 21 | 349 | 258 | 13 | 75 | 607 | 350 | 50 | 179 | 0 | 21 | 349 | 258 | 13 | 75 | 607 | |||||||||||||||||||||||||||||||
2453134 | 2453134 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201152 | 9002416 | Windham Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 253 | 6 | 181 | * | * | 0 | 6 | 287 | 161 | 21 | 53 | 448 | 253 | 6 | 181 | 0 | 6 | 287 | 161 | 21 | 53 | 448 | |||||||||||||||||||||||||||||||
2453133 | 2453133 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201151 | 9002316 | W. F. Kaynor Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 288 | 97 | 334 | * | 25 | * | 37 | 444 | 343 | 26 | 61 | 787 | 288 | 97 | 334 | 25 | 37 | 444 | 343 | 26 | 61 | 787 | |||||||||||||||||||||||||||||||
2453130 | 2453130 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201148 | 9002216 | Oliver Wolcott Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 524 | 12 | 73 | 0 | * | * | 23 | 399 | 238 | * | 78 | 637 | 524 | 12 | 73 | 0 | 23 | 399 | 238 | 78 | 637 | ||||||||||||||||||||||||||||||||
2453128 | 2453128 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201672 | 9002116 | J. M. Wright Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 83 | 77 | 250 | 0 | * | 0 | * | 235 | 186 | 22 | 53 | 421 | 83 | 77 | 250 | 0 | 0 | 235 | 186 | 22 | 53 | 421 | |||||||||||||||||||||||||||||||
2453129 | 2453129 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201147 | 9002016 | Norwich Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 426 | 43 | 111 | * | * | 0 | 49 | 369 | 272 | 11 | 52 | 641 | 426 | 43 | 111 | 0 | 49 | 369 | 272 | 11 | 52 | 641 | |||||||||||||||||||||||||||||||
2453120 | 2453120 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201138 | 9001916 | E. C. Goodwin Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 179 | 44 | 390 | * | * | 0 | 21 | 369 | * | 33 | 48 | 647 | 179 | 44 | 390 | 0 | 21 | 369 | 33 | 48 | 647 | ||||||||||||||||||||||||||||||||
2453132 | 2453132 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201150 | 9001816 | Vinal Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 280 | 33 | 64 | * | * | * | 27 | 285 | 122 | 6 | 55 | 407 | 280 | 33 | 64 | 27 | 285 | 122 | 6 | 55 | 407 | ||||||||||||||||||||||||||||||||
2453124 | 2453124 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201142 | 9001716 | H. C. Wilcox Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 341 | 45 | 335 | * | * | 0 | 27 | 441 | 322 | 20 | 62 | 763 | 341 | 45 | 335 | 0 | 27 | 441 | 322 | 20 | 62 | 763 | |||||||||||||||||||||||||||||||
2453127 | 2453127 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201145 | 9001616 | Howell Cheney Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 342 | 70 | 169 | 0 | 18 | 0 | 32 | 486 | 145 | 14 | 62 | 631 | 342 | 70 | 169 | 0 | 18 | 0 | 32 | 486 | 145 | 14 | 62 | 631 | |||||||||||||||||||||||||||||
2453118 | 2453118 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201136 | 9001516 | A. I. Prince Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 32 | 177 | 444 | * | 13 | * | * | 339 | 338 | 71 | 64 | 677 | 32 | 177 | 444 | 13 | 339 | 338 | 71 | 64 | 677 | ||||||||||||||||||||||||||||||||
2453121 | 2453121 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201140 | 9001416 | Eli Whitney Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 66 | 215 | 288 | * | 7 | * | 14 | 304 | 289 | 46 | 93 | 593 | 66 | 215 | 288 | 7 | 14 | 304 | 289 | 46 | 93 | 593 | |||||||||||||||||||||||||||||||
2453125 | 2453125 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201143 | 9001316 | H. H. Ellis Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 590 | * | 39 | * | 6 | 0 | 16 | 469 | 188 | * | 58 | 657 | 590 | 39 | 6 | 0 | 16 | 469 | 188 | 58 | 657 | ||||||||||||||||||||||||||||||||
2453126 | 2453126 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201144 | 9001216 | Henry Abbott Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 300 | 25 | 320 | 0 | 8 | 0 | 19 | 385 | 287 | 29 | 71 | 672 | 300 | 25 | 320 | 0 | 8 | 0 | 19 | 385 | 287 | 29 | 71 | 672 | |||||||||||||||||||||||||||||
2453119 | 2453119 | 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 | 2019 | pk_12_total | 30 | 213 | 488 | * | * | 0 | 20 | 362 | 398 | 53 | 35 | 760 | 30 | 213 | 488 | 0 | 20 | 362 | 398 | 53 | 35 | 760 | |||||||||||||||||||||||||||||||
2453107 | 2453107 | CT | school | 3470015 | Unified School District #2 | 90000400479 | 3470315 | Riverview School | State Agency Facilities | 2019 | pk_12_total | 15 | 11 | 17 | 0 | * | 0 | * | 17 | 32 | * | * | 49 | 15 | 11 | 17 | 0 | 0 | 17 | 32 | 49 | |||||||||||||||||||||||||||||||||||||||
2453108 | 2453108 | CT | school | 3470015 | Unified School District #2 | 3470215 | Virtual Academy | Program | 2019 | pk_12_total | 0 | 0 | * | 0 | 0 | 0 | 0 | * | 0 | 0 | 0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
2453106 | 2453106 | CT | school | 3470015 | Unified School District #2 | 90000400475 | 3470115 | Children's Place School | State Agency Facilities | 2019 | pk_12_total | 7 | * | 10 | 0 | 0 | 0 | * | 24 | 0 | * | * | 24 | 7 | 10 | 0 | 0 | 0 | 24 | 0 | 24 | |||||||||||||||||||||||||||||||||||||||
2453146 | 2453146 | CT | school | 3370015 | Department of Mental Health and Addiction Services | 90002701539 | 3370215 | Connecticut Valley Hospital | State Agency Facilities | 2019 | pk_12_total | * | 0 | 0 | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
2453113 | 2453113 | CT | school | 3360015 | Unified School District #1 | 90000301349 | 3362615 | Northern Correctional Institution | State Agency Facilities | 2019 | pk_12_total | 0 | * | * | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
2453110 | 2453110 | CT | school | 3360015 | Unified School District #1 | 90000300849 | 3362515 | York Correctional Institution | State Agency Facilities | 2019 | pk_12_total | * | * | * | 0 | 0 | 0 | 0 | 0 | 12 | 0 | * | 12 | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 12 | |||||||||||||||||||||||||||||||||||||||
2453112 | 2453112 | CT | school | 3360015 | Unified School District #1 | 90000300844 | 3362415 | Corrigan/Radgowski Correctional Institution | State Agency Facilities | 2019 | pk_12_total | * | * | * | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||
2453115 | 2453115 | CT | school | 3360015 | Unified School District #1 | 90000300469 | 3362215 | MacDougall/Walker Correctional Institution | State Agency Facilities | 2019 | pk_12_total | 0 | * | 0 | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
2453116 | 2453116 | CT | school | 3360015 | Unified School District #1 | 90000300436 | 3361515 | Willard/Cybulski Correctional Institution | State Agency Facilities | 2019 | pk_12_total | 0 | 0 | 0 | 0 | 0 | 0 | * | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
2453109 | 2453109 | CT | school | 3360015 | Unified School District #1 | 90000300404 | 3361115 | Manson Youth Institution | State Agency Facilities | 2019 | pk_12_total | * | 61 | 55 | 0 | 0 | 0 | * | 130 | 0 | * | 111 | 130 | 61 | 55 | 0 | 0 | 0 | 130 | 0 | 111 | 130 | ||||||||||||||||||||||||||||||||||||||
2453114 | 2453114 | CT | school | 3360015 | Unified School District #1 | 90000300361 | 3360615 | Hartford Correctional Center | State Agency Facilities | 2019 | pk_12_total | 0 | * | * | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
2453111 | 2453111 | CT | school | 3360015 | Unified School District #1 | 90000300347 | 3360315 | Cheshire Correctional Institution | State Agency Facilities | 2019 | pk_12_total | 0 | * | 0 | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||
2453075 | 2453075 | CT | school | 900221 | 2970013 | Capital Preparatory Harbor School District | 90022101803 | 2970113 | Capital Preparatory Harbor School | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | * | 463 | 167 | * | 0 | 0 | * | 323 | 311 | * | 71 | 634 | 463 | 167 | 0 | 0 | 323 | 311 | 71 | 634 | |||||||||||||||||||||||||||||||||
2452751 | 2452751 | CT | school | 900220 | 2960013 | Stamford Charter School for Excellence District | 90022001807 | 2960113 | Stamford Charter School for Excellence | Public Charter Schools | Regular School | Yes | Elementary | PK | 04 | 2019 | pk_12_total | * | 163 | 72 | * | 97 | * | * | 161 | 178 | 12 | 20 | 339 | 163 | 72 | 97 | 161 | 178 | 12 | 20 | 339 | |||||||||||||||||||||||||||||||||
2453073 | 2453073 | CT | school | 900217 | 2950013 | Booker T. Washington Academy District | 90021701750 | 2950113 | Booker T. Washington Academy | Public Charter Schools | Regular School | Yes | Elementary | KG | 05 | 2019 | pk_12_total | * | 309 | 45 | 0 | 0 | 0 | * | 186 | 174 | 27 | 22 | 360 | 309 | 45 | 0 | 0 | 0 | 186 | 174 | 27 | 22 | 360 | |||||||||||||||||||||||||||||||
2453084 | 2453084 | CT | school | 900219 | 2940013 | Great Oaks Charter School District | 90021901782 | 2940113 | Great Oaks Charter School | Public Charter Schools | Regular School | Yes | Middle | 06 | 10 | 2019 | pk_12_total | 22 | 224 | 209 | * | 0 | * | 7 | 216 | 249 | 60 | 85 | 465 | 22 | 224 | 209 | 0 | 7 | 216 | 249 | 60 | 85 | 465 | |||||||||||||||||||||||||||||||
2452012 | 2452012 | CT | school | 900216 | 2910013 | Elm City Montessori School District | 90021601683 | 2910113 | Elm City Montessori School | Public Charter Schools | Regular School | Yes | Elementary | PK | 04 | 2019 | pk_12_total | 51 | 83 | 52 | 0 | * | 0 | * | 95 | 104 | * | 8 | 199 | 51 | 83 | 52 | 0 | 0 | 95 | 104 | 8 | 199 | ||||||||||||||||||||||||||||||||
2451760 | 2451760 | CT | school | 900215 | 2900013 | Brass City Charter School District | 90021501644 | 2900113 | Brass City Charter School | Public Charter Schools | Regular School | Yes | Elementary | PK | 06 | 2019 | pk_12_total | 24 | 98 | 134 | * | * | 0 | 27 | 134 | 153 | 22 | 21 | 287 | 24 | 98 | 134 | 0 | 27 | 134 | 153 | 22 | 21 | 287 | |||||||||||||||||||||||||||||||
2453080 | 2453080 | CT | school | 900214 | 2890013 | Elm City College Preparatory School District | 90021401548 | 2890113 | Elm City College Preparatory School | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | 15 | 529 | 197 | * | * | 0 | 12 | 371 | 385 | 41 | 60 | 756 | 15 | 529 | 197 | 0 | 12 | 371 | 385 | 41 | 60 | 756 | |||||||||||||||||||||||||||||||
2453071 | 2453071 | CT | school | 900212 | 2880013 | Achievement First Hartford Academy District | 90021201528 | 2880113 | Achievement First Hartford Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | * | 782 | 304 | * | * | * | 15 | 519 | 593 | 52 | 115 | 1112 | 782 | 304 | 15 | 519 | 593 | 52 | 115 | 1112 | |||||||||||||||||||||||||||||||||
2452211 | 2452211 | CT | school | 900207 | 2860013 | Highville Charter School District | 90020700907 | 2860113 | Highville Charter School | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2019 | pk_12_total | * | 477 | 17 | 0 | 0 | 0 | * | 227 | 275 | 0 | 26 | 502 | 477 | 17 | 0 | 0 | 0 | 227 | 275 | 0 | 26 | 502 | |||||||||||||||||||||||||||||||
2453070 | 2453070 | CT | school | 900208 | 2850013 | Achievement First Bridgeport Academy District | 90020801493 | 2850113 | Achievement First Bridgeport Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | 13 | 584 | 480 | * | 9 | * | * | 512 | 581 | 131 | 97 | 1093 | 13 | 584 | 480 | 9 | 512 | 581 | 131 | 97 | 1093 | ||||||||||||||||||||||||||||||||
2453083 | 2453083 | CT | school | 900033 | 2830013 | Park City Prep Charter School District | 90003301449 | 2835113 | Park City Prep Charter School | Public Charter Schools | Regular School | Yes | Middle | 05 | 08 | 2019 | pk_12_total | 15 | 160 | 175 | * | * | * | * | 193 | 167 | 36 | 43 | 360 | 15 | 160 | 175 | 193 | 167 | 36 | 43 | 360 | |||||||||||||||||||||||||||||||||
2453144 | 2453144 | CT | school | 900031 | 2820013 | Stamford Academy District | 90003101405 | 2826013 | Stamford Academy | Regular School | Yes | High | 09 | 12 | 2019 | pk_12_total | 9 | 70 | 66 | 0 | * | 0 | * | 84 | 68 | 9 | 54 | 152 | 9 | 70 | 66 | 0 | 0 | 84 | 68 | 9 | 54 | 152 | ||||||||||||||||||||||||||||||||
2452376 | 2452376 | CT | school | 900028 | 2800013 | New Beginnings Inc Family Academy District | 90002801366 | 2800113 | New Beginnings Inc Family Academy | Public Charter Schools | Regular School | Yes | Elementary | PK | 08 | 2019 | pk_12_total | 10 | 298 | 166 | 0 | * | * | * | 246 | 236 | * | 40 | 482 | 10 | 298 | 166 | 0 | 246 | 236 | 40 | 482 | |||||||||||||||||||||||||||||||||
2453072 | 2453072 | CT | school | 900024 | 2790013 | Amistad Academy District | 90002400981 | 2795113 | Amistad Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | 19 | 681 | 360 | * | * | 0 | 21 | 509 | 574 | 118 | 71 | 1083 | 19 | 681 | 360 | 0 | 21 | 509 | 574 | 118 | 71 | 1083 | |||||||||||||||||||||||||||||||
2453086 | 2453086 | CT | school | 900023 | 2780013 | Trailblazers Academy District | 90002300965 | 2785113 | Trailblazers Academy | Regular School | Yes | Middle | 06 | 08 | 2019 | pk_12_total | * | 63 | 58 | 0 | * | 0 | * | 70 | 57 | 14 | 33 | 127 | 63 | 58 | 0 | 0 | 70 | 57 | 14 | 33 | 127 | |||||||||||||||||||||||||||||||||
2453135 | 2453135 | CT | school | 900018 | 2720013 | Explorations District | 90001800834 | 2726113 | Explorations | Public Charter Schools | Regular School | Yes | High | 09 | 12 | 2019 | pk_12_total | 75 | * | 9 | 0 | 0 | 0 | * | 35 | 53 | 0 | 27 | 88 | 75 | 9 | 0 | 0 | 0 | 35 | 53 | 0 | 27 | 88 | |||||||||||||||||||||||||||||||
2452700 | 2452700 | CT | school | 900016 | 2700013 | Side By Side Charter School District | 90001600823 | 2700113 | Side By Side Charter School | Public Charter Schools | Regular School | Yes | Elementary | PK | 08 | 2019 | pk_12_total | 30 | 65 | 119 | 0 | 7 | 0 | 15 | 115 | 121 | 22 | 25 | 236 | 30 | 65 | 119 | 0 | 7 | 0 | 15 | 115 | 121 | 22 | 25 | 236 | |||||||||||||||||||||||||||||
2453104 | 2453104 | CT | school | 900015 | 2690013 | The Bridge Academy District | 90001500809 | 2696113 | The Bridge Academy | Public Charter Schools | Regular School | Yes | High | 07 | 12 | 2019 | pk_12_total | * | 160 | 113 | * | * | 0 | 0 | 139 | 142 | 8 | 55 | 281 | 160 | 113 | 0 | 0 | 139 | 142 | 8 | 55 | 281 | ||||||||||||||||||||||||||||||||
2453117 | 2453117 | CT | school | 900014 | 2680013 | Common Ground High School District | 90001400807 | 2686113 | Common Ground High School | Public Charter Schools | Regular School | Yes | High | 09 | 12 | 2019 | pk_12_total | 47 | 87 | 74 | 0 | * | 0 | * | 136 | 80 | 12 | 49 | 216 | 47 | 87 | 74 | 0 | 0 | 136 | 80 | 12 | 49 | 216 | |||||||||||||||||||||||||||||||
2453085 | 2453085 | CT | school | 900011 | 2650013 | Interdistrict School for Arts and Comm District | 90001100797 | 2655113 | Interdistrict School For Arts And Communication | Public Charter Schools | Regular School | Yes | Middle | 06 | 08 | 2019 | pk_12_total | 54 | 49 | 160 | * | * | * | * | 133 | 145 | 29 | 38 | 278 | 54 | 49 | 160 | 133 | 145 | 29 | 38 | 278 | |||||||||||||||||||||||||||||||||
2452212 | 2452212 | CT | school | 900010 | 2640013 | Integrated Day Charter School District | 90001000775 | 2640113 | Integrated Day Charter School | Public Charter Schools | Regular School | Yes | Elementary | PK | 08 | 2019 | pk_12_total | 165 | * | 52 | * | 47 | 0 | 39 | 171 | 166 | 31 | 29 | 337 | 165 | 52 | 47 | 0 | 39 | 171 | 166 | 31 | 29 | 337 | |||||||||||||||||||||||||||||||
2453081 | 2453081 | CT | school | 900009 | 2630013 | Odyssey Community School District | 90000900774 | 2635113 | Odyssey Community School | Public Charter Schools | Regular School | Yes | Elementary | KG | 08 | 2019 | pk_12_total | 121 | 66 | 63 | 0 | 54 | 0 | 25 | 177 | 152 | 36 | 28 | 329 | 121 | 66 | 63 | 0 | 54 | 0 | 25 | 177 | 152 | 36 | 28 | 329 | |||||||||||||||||||||||||||||
2452213 | 2452213 | CT | school | 900007 | 2610013 | Jumoke Academy District | 90000700747 | 2610113 | Jumoke Academy | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2019 | pk_12_total | * | 666 | 38 | 0 | * | 0 | * | 336 | 381 | 0 | 42 | 717 | 666 | 38 | 0 | 0 | 336 | 381 | 0 | 42 | 717 | ||||||||||||||||||||||||||||||||
2451992 | 2451992 | CT | school | 2530014 | Eastern Connecticut Regional Educational Service Center (EASTCONN) | 90136001156 | 2539014 | EastConn Special Education | Program | 2019 | pk_12_total | 82 | 6 | 26 | * | 0 | 0 | * | 94 | 26 | * | 120 | 120 | 82 | 6 | 26 | 0 | 0 | 94 | 26 | 120 | 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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2451995 | 2451995 | CT | school | 2530014 | Eastern Connecticut Regional Educational Service Center (EASTCONN) | 2530114 | Regional Transitional Services | Program | 2019 | pk_12_total | * | * | 0 | 0 | 0 | 0 | 0 | * | * | 0 | 11 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 11 | ||||||||||||||||||||||||||||||||||||||||
2452234 | 2452234 | CT | school | 903450 | 2450014 | Learn | 90345001617 | 2456214 | Three Rivers Middle College Magnet School | Regional Education Service Center Schools | Regular School | No | High | 11 | 12 | 2019 | pk_12_total | 42 | * | 14 | * | * | 0 | 7 | 25 | 42 | * | 7 | 67 | 42 | 14 | 0 | 7 | 25 | 42 | 7 | 67 | |||||||||||||||||||||||||||||||||
2452232 | 2452232 | CT | school | 903450 | 2450014 | Learn | 90345001606 | 2456114 | Marine Science Magnet High School | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 203 | * | 31 | * | 9 | 0 | 20 | 123 | 148 | * | 32 | 271 | 203 | 31 | 9 | 0 | 20 | 123 | 148 | 32 | 271 | ||||||||||||||||||||||||||||||||
2452231 | 2452231 | CT | school | 903450 | 2450014 | Learn | 90345001581 | 2456014 | Connecticut River Academy at Goodwin University | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 86 | 97 | 262 | * | 14 | * | 15 | 232 | 244 | 38 | 78 | 476 | 86 | 97 | 262 | 14 | 15 | 232 | 244 | 38 | 78 | 476 | |||||||||||||||||||||||||||||||
2452228 | 2452228 | CT | school | 903450 | 2450014 | Learn | 90345001556 | 2455014 | Dual Language & Arts Magnet Middle School | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 42 | 16 | 65 | 0 | * | * | 21 | 65 | 81 | 17 | 28 | 146 | 42 | 16 | 65 | 0 | 21 | 65 | 81 | 17 | 28 | 146 | ||||||||||||||||||||||||||||||||
2452225 | 2452225 | CT | school | 2450014 | Learn | 2451614 | LEARN SAILS Program | Program | 2019 | pk_12_total | 6 | * | * | 0 | 0 | 0 | * | * | * | 0 | 11 | 11 | 6 | 0 | 0 | 0 | 0 | 11 | 11 | |||||||||||||||||||||||||||||||||||||||||
2452220 | 2452220 | CT | school | 2450014 | Learn | 2451514 | LEARN Integrated Program at TFS | Program | 2019 | pk_12_total | 0 | 0 | * | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
2452226 | 2452226 | CT | school | 2450014 | Learn | 2451414 | LEARN Diagnostic and Wellness Center | Program | 2019 | pk_12_total | * | 0 | 0 | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
2452229 | 2452229 | CT | school | 2450014 | Learn | 2451214 | Learn ABA Program at Center School | 2019 | pk_12_total | * | * | 6 | 0 | * | 0 | * | * | * | * | 15 | 15 | 6 | 0 | 0 | 15 | 15 | ||||||||||||||||||||||||||||||||||||||||||||
2452224 | 2452224 | CT | school | 2450014 | Learn | 90345001680 | 2451114 | Learn Intensive Program | Program | 2019 | pk_12_total | * | * | * | 0 | 0 | 0 | * | * | * | * | 15 | 15 | 0 | 0 | 0 | 15 | 15 | ||||||||||||||||||||||||||||||||||||||||||
2452227 | 2452227 | CT | school | 2450014 | Learn | 2450814 | Learn SAILS Middle School Program | 2019 | pk_12_total | * | * | * | 0 | 0 | 0 | * | 7 | 0 | 0 | 7 | 7 | 0 | 0 | 0 | 7 | 0 | 0 | 7 | 7 | |||||||||||||||||||||||||||||||||||||||||
2452233 | 2452233 | CT | school | 2450014 | Learn | 90345001795 | 2450614 | Learn High School | Program | 2019 | pk_12_total | * | 0 | * | 0 | * | 0 | 0 | * | * | 0 | * | * | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2452230 | 2452230 | CT | school | 2450014 | Learn | 2450514 | Learn Pathways Program | 2019 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||
2452235 | 2452235 | CT | school | 2450014 | Learn | 90345001757 | 2450414 | LEARN Transition Academy | Program | 2019 | pk_12_total | * | 0 | * | 0 | * | 0 | 0 | * | 0 | * | * | * | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2452221 | 2452221 | CT | school | 903450 | 2450014 | Learn | 90345001627 | 2450314 | Riverside Magnet School at Goodwin University | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 109 | 126 | 189 | * | 11 | * | 26 | 230 | 234 | 83 | 50 | 464 | 109 | 126 | 189 | 11 | 26 | 230 | 234 | 83 | 50 | 464 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452223 | 2452223 | CT | school | 903450 | 2450014 | Learn | 90345000079 | 2450114 | Regional Multicultural Magnet School | Regional Education Service Center Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 159 | 70 | 208 | * | 11 | * | 70 | 257 | 263 | 71 | 65 | 520 | 159 | 70 | 208 | 11 | 70 | 257 | 263 | 71 | 65 | 520 | |||||||||||||||||||||||||||||||
2451711 | 2451711 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001588 | 2449614 | Center for Autism Spectrum and Development Disorders | Program | 2019 | pk_12_total | 26 | 8 | * | 0 | * | 0 | * | 30 | 10 | 0 | 40 | 40 | 26 | 8 | 0 | 0 | 30 | 10 | 0 | 40 | 40 | ||||||||||||||||||||||||||||||||||||||
2451706 | 2451706 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001499 | 2449514 | Village School | Program | 2019 | pk_12_total | 54 | 46 | 28 | * | 6 | * | * | 102 | 37 | 0 | 139 | 139 | 54 | 46 | 28 | 6 | 102 | 37 | 0 | 139 | 139 | ||||||||||||||||||||||||||||||||||||||
2451709 | 2451709 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001505 | 2449414 | Mill Academy | Program | 2019 | pk_12_total | 20 | 68 | 40 | 0 | 0 | 0 | 6 | 107 | 27 | * | * | 134 | 20 | 68 | 40 | 0 | 0 | 0 | 6 | 107 | 27 | 134 | |||||||||||||||||||||||||||||||||||||
2451714 | 2451714 | CT | school | 2440014 | Area Cooperative Educational Services | 2449314 | Whitney High School West | 2019 | pk_12_total | 9 | 9 | * | 0 | * | 0 | 0 | * | * | * | 26 | 26 | 9 | 9 | 0 | 0 | 0 | 26 | 26 | ||||||||||||||||||||||||||||||||||||||||||
2451712 | 2451712 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001502 | 2449214 | Whitney Academy | Program | 2019 | pk_12_total | 27 | 19 | 22 | 0 | * | 0 | * | 54 | 17 | 0 | 71 | 71 | 27 | 19 | 22 | 0 | 0 | 54 | 17 | 0 | 71 | 71 | |||||||||||||||||||||||||||||||||||||
2451713 | 2451713 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001490 | 2449114 | Whitney High School North | Program | 2019 | pk_12_total | 13 | 50 | 28 | 0 | 0 | * | * | 70 | 28 | * | 98 | 98 | 13 | 50 | 28 | 0 | 0 | 70 | 28 | 98 | 98 | ||||||||||||||||||||||||||||||||||||||
2451710 | 2451710 | CT | school | 900070 | 2440014 | Area Cooperative Educational Services | 90007001358 | 2445114 | Thomas Edison Magnet Middle School | Regional Education Service Center Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 174 | 94 | 364 | * | 37 | * | 36 | 348 | 361 | 49 | 82 | 709 | 174 | 94 | 364 | 37 | 36 | 348 | 361 | 49 | 82 | 709 | |||||||||||||||||||||||||||||||
2451708 | 2451708 | CT | school | 900070 | 2440014 | Area Cooperative Educational Services | 90007000884 | 2440314 | Wintergreen Interdistrict Magnet School | Regional Education Service Center Schools | Regular School | No | Elementary | KG | 08 | 2019 | pk_12_total | 117 | 272 | 129 | * | 23 | * | 21 | 267 | 297 | 36 | 71 | 564 | 117 | 272 | 129 | 23 | 21 | 267 | 297 | 36 | 71 | 564 | |||||||||||||||||||||||||||||||
2451707 | 2451707 | CT | school | 2440014 | Area Cooperative Educational Services | 2440214 | ACES Mill Elementary School | Program | 2019 | pk_12_total | * | 16 | 14 | 0 | 0 | 0 | * | 33 | 8 | * | 41 | 41 | 16 | 14 | 0 | 0 | 0 | 33 | 8 | 41 | 41 | |||||||||||||||||||||||||||||||||||||||
2451715 | 2451715 | CT | school | 2440014 | Area Cooperative Educational Services | 2440114 | CREATE at Whitney Academy | Program | 2019 | pk_12_total | 20 | * | 18 | 0 | 0 | 0 | * | 39 | 13 | * | 52 | 52 | 20 | 18 | 0 | 0 | 0 | 39 | 13 | 52 | 52 | |||||||||||||||||||||||||||||||||||||||
2451898 | 2451898 | CT | school | 2430014 | Cooperative Educational Services | 90091001573 | 2439414 | Therapeutic Day Program | Program | 2019 | pk_12_total | 77 | 28 | 36 | 0 | * | 0 | * | 123 | 29 | * | 152 | 152 | 77 | 28 | 36 | 0 | 0 | 123 | 29 | 152 | 152 | ||||||||||||||||||||||||||||||||||||||
2451900 | 2451900 | CT | school | 2430014 | Cooperative Educational Services | 90091001555 | 2439314 | RISE Transitional Program | Program | 2019 | pk_12_total | 7 | * | 0 | 0 | 0 | 0 | * | * | * | 0 | 10 | 10 | 7 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | |||||||||||||||||||||||||||||||||||||||
2451899 | 2451899 | CT | school | 2430014 | Cooperative Educational Services | 90091001554 | 2439214 | Developmental Learning Center (DLC) | Program | 2019 | pk_12_total | * | 20 | 20 | 0 | 0 | 0 | * | 42 | 18 | * | 60 | 60 | 20 | 20 | 0 | 0 | 0 | 42 | 18 | 60 | 60 | ||||||||||||||||||||||||||||||||||||||
2451895 | 2451895 | CT | school | 2430014 | Cooperative Educational Services | 90091001561 | 2439114 | Preschool-Primary Learning Center (PLC) | Program | 2019 | pk_12_total | 15 | 11 | 14 | 0 | * | * | * | 38 | 11 | 0 | 49 | 49 | 15 | 11 | 14 | 0 | 38 | 11 | 0 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||
2451896 | 2451896 | CT | school | 2430014 | Cooperative Educational Services | 90091001520 | 2438014 | School Readiness | Program | 2019 | pk_12_total | * | * | 52 | 0 | 0 | 0 | 0 | 41 | 40 | 0 | 7 | 81 | 52 | 0 | 0 | 0 | 0 | 41 | 40 | 0 | 7 | 81 | |||||||||||||||||||||||||||||||||||||
2451901 | 2451901 | CT | school | 2430014 | Cooperative Educational Services | 2430214 | Transition Learning Center | Program | 2019 | pk_12_total | 14 | 6 | 9 | 0 | * | 0 | * | 25 | 7 | 0 | 32 | 32 | 14 | 6 | 9 | 0 | 0 | 25 | 7 | 0 | 32 | 32 | ||||||||||||||||||||||||||||||||||||||
2451897 | 2451897 | CT | school | 900910 | 2430014 | Cooperative Educational Services | 90091000340 | 2430114 | Six-Six Magnet School | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 112 | 109 | 195 | 0 | 23 | 0 | 16 | 222 | 233 | 27 | 44 | 455 | 112 | 109 | 195 | 0 | 23 | 0 | 16 | 222 | 233 | 27 | 44 | 455 | |||||||||||||||||||||||||||||
2452000 | 2452000 | CT | school | 2420014 | EdAdvance | 90351201476 | 2429014 | The ACCESS School at The Danuta M. Thibodeau Education Center | Program | 2019 | pk_12_total | 17 | 0 | 7 | 0 | 0 | 0 | 0 | * | * | 0 | * | 24 | 17 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 24 | ||||||||||||||||||||||||||||||||||||||
2451999 | 2451999 | CT | school | 2420014 | EdAdvance | 90351200575 | 2428014 | EdAdvance Headstart | Program | 2019 | pk_12_total | 146 | 9 | 40 | * | 6 | 7 | * | 105 | 105 | 0 | 32 | 210 | 146 | 9 | 40 | 6 | 7 | 105 | 105 | 0 | 32 | 210 | |||||||||||||||||||||||||||||||||||||
2452003 | 2452003 | CT | school | 2420014 | EdAdvance | 2420414 | ACCESS-South Expelled Student | Program | 2019 | pk_12_total | * | 0 | 0 | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
2452004 | 2452004 | CT | school | 2420014 | EdAdvance | 2420314 | Steps-North Expelled Student | Program | 2019 | pk_12_total | * | * | * | 0 | 0 | 0 | 0 | * | 0 | 0 | 0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||
2452002 | 2452002 | CT | school | 2420014 | EdAdvance | 2420214 | Torrington Alternative Program | 2019 | pk_12_total | 10 | * | * | * | 0 | 0 | * | 11 | 6 | 0 | * | 17 | 10 | 0 | 0 | 11 | 6 | 0 | 17 | ||||||||||||||||||||||||||||||||||||||||||
2452001 | 2452001 | CT | school | 2420014 | EdAdvance | 2420114 | Steps | Program | 2019 | pk_12_total | 14 | * | * | 0 | 0 | 0 | * | 16 | 6 | 0 | 22 | 22 | 14 | 0 | 0 | 0 | 16 | 6 | 0 | 22 | 22 |
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]);