enrollments
Data source: Big Local News · About: Big Local
20,286 rows where state = "CT" and year = 2019 sorted by rowid 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2453143 | 2453143 | CT | school | 2190012 | Regional School District 19 | 2190312 | STAAR Program | Program | 2019 | pk_12_total | 13 | 0 | * | 0 | * | * | * | 10 | 8 | * | 18 | 18 | 13 | 0 | 0 | 10 | 8 | 18 | 18 | |||||||||||||||||||||||||||||||||||||||||
2453142 | 2453142 | CT | school | 2190012 | Regional School District 19 | 2190212 | PM Panthers | 2019 | pk_12_total | 14 | 0 | * | 0 | 0 | 0 | * | * | * | * | 6 | 17 | 14 | 0 | 0 | 0 | 0 | 6 | 17 | ||||||||||||||||||||||||||||||||||||||||||
2453141 | 2453141 | CT | school | 2190012 | Regional School District 19 | 90000501729 | 2190112 | E.O. Smith High School at the Depot Campus | Program | 2019 | pk_12_total | 16 | 0 | * | 0 | 0 | 0 | * | 14 | 6 | 0 | 7 | 20 | 16 | 0 | 0 | 0 | 0 | 14 | 6 | 0 | 7 | 20 | |||||||||||||||||||||||||||||||||||||
2453140 | 2453140 | CT | school | 900005 | 2190012 | Regional School District 19 | 90000501215 | 2196112 | E. O. Smith High School | Regional Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 783 | * | 96 | 0 | 45 | * | 144 | 533 | 558 | 9 | 135 | 1091 | 783 | 96 | 0 | 45 | 144 | 533 | 558 | 9 | 135 | 1091 | |||||||||||||||||||||||||||||||
2453139 | 2453139 | CT | school | 903780 | 2090012 | Regional School District 09 | 90378000773 | 2096112 | Joel Barlow High School | Regional Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 734 | * | 54 | 0 | 33 | * | 45 | 454 | 421 | * | 96 | 875 | 734 | 54 | 0 | 33 | 45 | 454 | 421 | 96 | 875 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2453103 | 2453103 | CT | school | 903570 | 2110012 | Regional School District 11 | 90357000765 | 2116112 | Parish Hill High School | Regional Schools | Regular School | No | High | 07 | 12 | 2019 | pk_12_total | 190 | * | 18 | 0 | 0 | * | 9 | 129 | 96 | * | 39 | 225 | 190 | 18 | 0 | 0 | 9 | 129 | 96 | 39 | 225 | ||||||||||||||||||||||||||||||||
2453102 | 2453102 | CT | school | 903750 | 2080012 | Regional School District 08 | 90375000772 | 2086112 | RHAM High School | Regional Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 887 | 8 | 26 | * | 24 | 0 | * | 477 | 475 | * | 120 | 952 | 887 | 8 | 26 | 24 | 0 | 477 | 475 | 120 | 952 | ||||||||||||||||||||||||||||||||
2453101 | 2453101 | CT | school | 903750 | 2080012 | Regional School District 08 | 90375001210 | 2085112 | RHAM Middle School | Regional Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 444 | * | 23 | 0 | 9 | * | 0 | 261 | 222 | * | 70 | 483 | 444 | 23 | 0 | 9 | 0 | 261 | 222 | 70 | 483 | ||||||||||||||||||||||||||||||||
2453100 | 2453100 | CT | school | 2070012 | Regional School District 07 | 2070112 | Highlander Transition Academy | Program | 2019 | pk_12_total | 12 | 0 | 0 | 0 | 0 | 0 | 0 | * | * | 0 | 12 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 12 | ||||||||||||||||||||||||||||||||||||||
2453099 | 2453099 | CT | school | 2070012 | Regional School District 07 | 90372001402 | 2079312 | STEP | Program | 2019 | pk_12_total | 17 | 0 | 0 | 0 | * | 0 | * | 13 | 7 | 0 | 6 | 20 | 17 | 0 | 0 | 0 | 0 | 13 | 7 | 0 | 6 | 20 | |||||||||||||||||||||||||||||||||||||
2453098 | 2453098 | CT | school | 903720 | 2070012 | Regional School District 07 | 90372000771 | 2076112 | Northwestern Regional High School | Regional Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 657 | 7 | 13 | 0 | * | * | 10 | 326 | 368 | * | 60 | 694 | 657 | 7 | 13 | 0 | 10 | 326 | 368 | 60 | 694 | ||||||||||||||||||||||||||||||||
2453097 | 2453097 | CT | school | 2070012 | Regional School District 07 | 90372001400 | 2079112 | AIM | Program | 2019 | pk_12_total | 17 | * | * | 0 | 0 | 0 | 0 | 10 | 11 | 0 | 21 | 21 | 17 | 0 | 0 | 0 | 0 | 10 | 11 | 0 | 21 | 21 | |||||||||||||||||||||||||||||||||||||
2453096 | 2453096 | CT | school | 903720 | 2070012 | Regional School District 07 | 90372001226 | 2075112 | Northwestern Regional Middle School | Regional Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 264 | 0 | 7 | 0 | * | * | 8 | 134 | 149 | 0 | 47 | 283 | 264 | 0 | 7 | 0 | 8 | 134 | 149 | 0 | 47 | 283 | |||||||||||||||||||||||||||||||
2453095 | 2453095 | CT | school | 2070012 | Regional School District 07 | 90372001401 | 2079212 | Links | Program | 2019 | pk_12_total | 20 | * | * | 0 | 0 | 0 | 0 | 15 | 9 | 0 | 24 | 24 | 20 | 0 | 0 | 0 | 0 | 15 | 9 | 0 | 24 | 24 | |||||||||||||||||||||||||||||||||||||
2453094 | 2453094 | CT | school | 2070012 | Regional School District 07 | 90372001399 | 2079012 | FLEX | Program | 2019 | pk_12_total | 9 | 0 | 0 | 0 | 0 | 0 | 0 | * | * | 0 | 9 | 9 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 9 | |||||||||||||||||||||||||||||||||||||
2453093 | 2453093 | CT | school | 2050012 | Regional School District 05 | 2050112 | Amity Transition Academy | Program | 2019 | pk_12_total | * | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2453092 | 2453092 | CT | school | 903660 | 2050012 | Regional School District 05 | 90366000770 | 2056112 | Amity Regional High School | Regional Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1135 | 48 | 25 | * | 207 | * | 67 | 739 | 752 | 10 | 175 | 1491 | 1135 | 48 | 25 | 207 | 67 | 739 | 752 | 10 | 175 | 1491 | |||||||||||||||||||||||||||||||
2453091 | 2453091 | CT | school | 903660 | 2050012 | Regional School District 05 | 90366000769 | 2055212 | Amity Middle School: Orange | Regional Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 286 | * | * | 0 | 49 | 0 | 11 | 178 | 178 | 0 | 42 | 356 | 286 | 0 | 49 | 0 | 11 | 178 | 178 | 0 | 42 | 356 | |||||||||||||||||||||||||||||||
2453090 | 2453090 | CT | school | 903660 | 2050012 | Regional School District 05 | 90366001114 | 2055112 | Amity Middle School: Bethany | Regional Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 234 | * | * | 0 | 54 | 0 | 15 | 162 | 153 | * | 42 | 315 | 234 | 0 | 54 | 0 | 15 | 162 | 153 | 42 | 315 | ||||||||||||||||||||||||||||||||
2453089 | 2453089 | CT | school | 2040012 | Regional School District 04 | 2040112 | Region 4 Transition Academy | Program | 2019 | pk_12_total | * | 0 | 0 | 0 | 0 | 0 | 0 | * | * | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||
2453088 | 2453088 | CT | school | 903630 | 2040012 | Regional School District 04 | 90363000768 | 2046112 | Valley Regional High School | Regional Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 549 | * | 18 | * | 14 | 0 | 13 | 297 | 302 | * | 82 | 599 | 549 | 18 | 14 | 0 | 13 | 297 | 302 | 82 | 599 | ||||||||||||||||||||||||||||||||
2453087 | 2453087 | CT | school | 903630 | 2040012 | Regional School District 04 | 90363000767 | 2045112 | John Winthrop Middle School | Regional Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 247 | * | 17 | 0 | * | 0 | 12 | 134 | 149 | * | 54 | 283 | 247 | 17 | 0 | 0 | 12 | 134 | 149 | 54 | 283 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2453082 | 2453082 | CT | school | 904020 | 1250011 | Sharon School District | 90402000795 | 1250111 | Sharon Center School | Public Schools | Regular School | No | Elementary | KG | 08 | 2019 | pk_12_total | 98 | 0 | 10 | 0 | * | * | * | 61 | 54 | * | 25 | 115 | 98 | 0 | 10 | 0 | 61 | 54 | 25 | 115 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2453079 | 2453079 | CT | school | 901080 | 360011 | Deep River School District | 90108000173 | 360111 | Deep River Elementary School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 205 | * | 21 | 0 | * | 0 | 10 | 125 | 117 | 9 | 33 | 242 | 205 | 21 | 0 | 0 | 10 | 125 | 117 | 9 | 33 | 242 | |||||||||||||||||||||||||||||||
2453078 | 2453078 | CT | school | 900930 | 310011 | Cornwall School District | 90093000140 | 310111 | Cornwall Consolidated School | Public Schools | Regular School | No | Elementary | KG | 08 | 2019 | pk_12_total | 71 | 0 | 13 | 0 | * | 0 | * | 53 | 38 | * | 11 | 91 | 71 | 0 | 13 | 0 | 0 | 53 | 38 | 11 | 91 | ||||||||||||||||||||||||||||||||
2453077 | 2453077 | CT | school | 900870 | 290011 | Colebrook School District | 90087000138 | 290111 | Colebrook Consolidated School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 79 | * | * | 0 | 0 | 0 | * | 54 | 30 | 0 | 18 | 84 | 79 | 0 | 0 | 0 | 54 | 30 | 0 | 18 | 84 | ||||||||||||||||||||||||||||||||
2453076 | 2453076 | CT | school | 900780 | 260011 | Chester School District | 90078000130 | 260111 | Chester Elementary School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 168 | * | 14 | 0 | * | 0 | 8 | 107 | 87 | * | 28 | 194 | 168 | 14 | 0 | 0 | 8 | 107 | 87 | 28 | 194 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2453074 | 2453074 | CT | school | 900630 | 210011 | Canaan School District | 90063000115 | 210111 | Lee H. Kellogg School | Public Schools | Regular School | No | Elementary | KG | 08 | 2019 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | 33 | 30 | * | 8 | 63 | 0 | 0 | 0 | 0 | 0 | 33 | 30 | 8 | 63 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2453069 | 2453069 | CT | school | 905370 | 1690011 | Woodstock School District | 90537000573 | 1695111 | Woodstock Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 368 | * | 15 | 0 | * | 0 | 17 | 199 | 207 | 0 | 40 | 406 | 368 | 15 | 0 | 0 | 17 | 199 | 207 | 0 | 40 | 406 | |||||||||||||||||||||||||||||||
2453068 | 2453068 | CT | school | 905370 | 1690011 | Woodstock School District | 90537001110 | 1690211 | Woodstock Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 384 | * | 12 | 0 | * | 0 | 26 | 209 | 219 | * | 56 | 428 | 384 | 12 | 0 | 0 | 26 | 209 | 219 | 56 | 428 | ||||||||||||||||||||||||||||||||
2453067 | 2453067 | CT | school | 905310 | 1670011 | Woodbridge School District | 90531001611 | 1670311 | Beecher Road School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 588 | * | 62 | * | 118 | 0 | 38 | 450 | 393 | 20 | 87 | 843 | 588 | 62 | 118 | 0 | 38 | 450 | 393 | 20 | 87 | 843 | |||||||||||||||||||||||||||||||
2453066 | 2453066 | CT | school | 1660011 | Wolcott School District | 90528001772 | 1660411 | Phoenix Program | Program | 2019 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
2453065 | 2453065 | CT | school | 905280 | 1660011 | Wolcott School District | 90528001107 | 1666111 | Wolcott High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 647 | 20 | 37 | 0 | 15 | 0 | 24 | 373 | 370 | * | 78 | 743 | 647 | 20 | 37 | 0 | 15 | 0 | 24 | 373 | 370 | 78 | 743 | ||||||||||||||||||||||||||||||
2453064 | 2453064 | CT | school | 905280 | 1660011 | Wolcott School District | 90528001102 | 1665111 | Tyrrell Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 447 | 26 | 43 | * | * | 0 | 24 | 289 | 263 | 7 | 75 | 552 | 447 | 26 | 43 | 0 | 24 | 289 | 263 | 7 | 75 | 552 | |||||||||||||||||||||||||||||||
2453063 | 2453063 | CT | school | 905280 | 1660011 | Wolcott School District | 90528001106 | 1660511 | Wakelee School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 316 | 8 | 30 | 0 | 7 | 0 | 9 | 187 | 183 | 29 | 39 | 370 | 316 | 8 | 30 | 0 | 7 | 0 | 9 | 187 | 183 | 29 | 39 | 370 | |||||||||||||||||||||||||||||
2453062 | 2453062 | CT | school | 905280 | 1660011 | Wolcott School District | 90528001103 | 1660211 | Frisbie School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 243 | 8 | 26 | 0 | * | 0 | * | 140 | 147 | 10 | 29 | 287 | 243 | 8 | 26 | 0 | 0 | 140 | 147 | 10 | 29 | 287 | |||||||||||||||||||||||||||||||
2453061 | 2453061 | CT | school | 1660011 | Wolcott School District | 90528001783 | 1660311 | ABC Classroom | Program | 2019 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||
2453060 | 2453060 | CT | school | 905280 | 1660011 | Wolcott School District | 90528001105 | 1660611 | Alcott School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 212 | 7 | 38 | 0 | 8 | 0 | 6 | 151 | 120 | 16 | 44 | 271 | 212 | 7 | 38 | 0 | 8 | 0 | 6 | 151 | 120 | 16 | 44 | 271 | |||||||||||||||||||||||||||||
2453059 | 2453059 | CT | school | 1640011 | Windsor School District | 1640211 | Community Based Transition Academy | Program | 2019 | pk_12_total | * | 13 | * | 0 | * | 0 | 0 | 13 | 10 | * | 23 | 23 | 13 | 0 | 0 | 0 | 13 | 10 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||
2453058 | 2453058 | CT | school | 905220 | 1640011 | Windsor School District | 90522001096 | 1646111 | Windsor High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 273 | 552 | 190 | 0 | * | * | 54 | 570 | 540 | 22 | 209 | 1110 | 273 | 552 | 190 | 0 | 54 | 570 | 540 | 22 | 209 | 1110 | |||||||||||||||||||||||||||||||
2453057 | 2453057 | CT | school | 1640011 | Windsor School District | 1640311 | Spark | Program | 2019 | pk_12_total | * | 10 | * | 0 | 0 | 0 | * | * | * | 0 | 17 | 17 | 10 | 0 | 0 | 0 | 0 | 17 | 17 | |||||||||||||||||||||||||||||||||||||||||
2453056 | 2453056 | CT | school | 905220 | 1640011 | Windsor School District | 90522001095 | 1645311 | Sage Park Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 196 | 322 | 122 | 0 | * | * | 54 | 367 | 351 | 26 | 107 | 718 | 196 | 322 | 122 | 0 | 54 | 367 | 351 | 26 | 107 | 718 | |||||||||||||||||||||||||||||||
2453055 | 2453055 | CT | school | 905220 | 1640011 | Windsor School District | 90522001089 | 1640811 | John F. Kennedy School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 97 | 135 | 88 | * | * | 0 | 23 | 188 | 177 | 15 | 60 | 365 | 97 | 135 | 88 | 0 | 23 | 188 | 177 | 15 | 60 | 365 | |||||||||||||||||||||||||||||||
2453054 | 2453054 | CT | school | 905220 | 1640011 | Windsor School District | 90522001087 | 1640111 | Clover Street School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 58 | 144 | 56 | 0 | * | 0 | * | 158 | 122 | * | 43 | 280 | 58 | 144 | 56 | 0 | 0 | 158 | 122 | 43 | 280 | ||||||||||||||||||||||||||||||||
2453053 | 2453053 | CT | school | 905220 | 1640011 | Windsor School District | 90522001093 | 1640511 | Poquonock Elementary School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 88 | 117 | 81 | 0 | 22 | 0 | 25 | 175 | 158 | 6 | 57 | 333 | 88 | 117 | 81 | 0 | 22 | 0 | 25 | 175 | 158 | 6 | 57 | 333 | |||||||||||||||||||||||||||||
2453052 | 2453052 | CT | school | 905220 | 1640011 | Windsor School District | 90522001092 | 1640911 | Oliver Ellsworth School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 116 | 126 | 96 | * | * | 0 | 35 | 213 | 198 | 12 | 75 | 411 | 116 | 126 | 96 | 0 | 35 | 213 | 198 | 12 | 75 | 411 | |||||||||||||||||||||||||||||||
2453051 | 2453051 | CT | school | 1650011 | Windsor Locks School District | 90525001777 | 1650211 | RISE Transition Academy | Program | 2019 | pk_12_total | 11 | * | * | 0 | * | 0 | 0 | 14 | 6 | 0 | 20 | 20 | 11 | 0 | 0 | 0 | 14 | 6 | 0 | 20 | 20 | ||||||||||||||||||||||||||||||||||||||
2453050 | 2453050 | CT | school | 905250 | 1650011 | Windsor Locks School District | 90525001100 | 1656111 | Windsor Locks High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 263 | 47 | 50 | 0 | * | 0 | * | 217 | 191 | 13 | 56 | 408 | 263 | 47 | 50 | 0 | 0 | 217 | 191 | 13 | 56 | 408 | |||||||||||||||||||||||||||||||
2453049 | 2453049 | CT | school | 1650011 | Windsor Locks School District | 90525001709 | 1650611 | Pine Meadow Academy | Program | 2019 | pk_12_total | 27 | * | * | 0 | 0 | 0 | 0 | 24 | 12 | 0 | 21 | 36 | 27 | 0 | 0 | 0 | 0 | 24 | 12 | 0 | 21 | 36 | |||||||||||||||||||||||||||||||||||||
2453048 | 2453048 | CT | school | 905250 | 1650011 | Windsor Locks School District | 90525001101 | 1655111 | Windsor Locks Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 200 | 37 | 62 | 0 | 22 | * | * | 162 | 182 | 10 | 62 | 344 | 200 | 37 | 62 | 0 | 22 | 162 | 182 | 10 | 62 | 344 | |||||||||||||||||||||||||||||||
2453047 | 2453047 | CT | school | 905250 | 1650011 | Windsor Locks School District | 90525001098 | 1650411 | South Elementary School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 175 | 45 | 53 | 0 | 29 | 0 | 23 | 154 | 171 | 28 | 45 | 325 | 175 | 45 | 53 | 0 | 29 | 0 | 23 | 154 | 171 | 28 | 45 | 325 |
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]);