enrollments
Data source: Big Local News · About: Big Local
20,286 rows where state = "CT" and year = 2019 sorted by black descending
This data as json, CSV (advanced)
grade ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||
2452110 | 2452110 | CT | school | 901770 | 590011 | Groton School District | 90177000318 | 596111 | Robert E. Fitch High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 574 | 98 | 185 | 17 | 72 | 6 | 84 | 542 | 494 | 20 | 148 | 1036 | 574 | 98 | 185 | 17 | 72 | 6 | 84 | 542 | 494 | 20 | 148 | 1036 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451849 | 2451849 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070000072 | 2410114 | Glastonbury/East Hartford Magnet School | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 116 | 96 | 179 | * | 43 | 0 | * | 233 | 223 | 57 | 68 | 456 | 116 | 96 | 179 | 43 | 0 | 233 | 223 | 57 | 68 | 456 | |||||||||||||||||||||||||||||||
2452145 | 2452145 | CT | school | 901920 | 640011 | Hartford School District | 90192000360 | 640711 | Dwight-Bellizzi Dual Language Academy | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 24 | 96 | 452 | * | 15 | 0 | * | 299 | 297 | 230 | 77 | 596 | 24 | 96 | 452 | 15 | 0 | 299 | 297 | 230 | 77 | 596 | |||||||||||||||||||||||||||||||
2452859 | 2452859 | CT | school | 904680 | 1460011 | Vernon School District | 90468000943 | 1466111 | Rockville High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 560 | 96 | 114 | * | 51 | 0 | * | 433 | 421 | 21 | 149 | 854 | 560 | 96 | 114 | 51 | 0 | 433 | 421 | 21 | 149 | 854 | |||||||||||||||||||||||||||||||
2452128 | 2452128 | CT | school | 901860 | 620011 | Hamden School District | 90186000346 | 620111 | Shepherd Glen School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 59 | 95 | 61 | * | 65 | 0 | * | 154 | 143 | 51 | 37 | 297 | 59 | 95 | 61 | 65 | 0 | 154 | 143 | 51 | 37 | 297 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452030 | 2452030 | CT | school | 901470 | 490011 | Enfield School District | 90147000243 | 496111 | Enfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1073 | 94 | 214 | * | 53 | * | 58 | 756 | 744 | 13 | 226 | 1500 | 1073 | 94 | 214 | 53 | 58 | 756 | 744 | 13 | 226 | 1500 | |||||||||||||||||||||||||||||||
2452198 | 2452198 | CT | school | 901920 | 640011 | Hartford School District | 90192001562 | 647711 | Journalism and Media Academy | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | * | 94 | 70 | 0 | * | 0 | * | 73 | 97 | 17 | 37 | 170 | 94 | 70 | 0 | 0 | 73 | 97 | 17 | 37 | 170 | |||||||||||||||||||||||||||||||||
2452395 | 2452395 | CT | school | 902670 | 890011 | New Britain School District | 90267000518 | 895311 | Pulaski Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 166 | 94 | 573 | * | 22 | 0 | * | 463 | 412 | 174 | 184 | 875 | 166 | 94 | 573 | 22 | 0 | 463 | 412 | 174 | 184 | 875 | |||||||||||||||||||||||||||||||
2452294 | 2452294 | CT | school | 902400 | 800011 | Meriden School District | 90240000447 | 805211 | Lincoln Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 193 | 93 | 436 | * | * | 0 | 23 | 391 | 370 | 132 | 138 | 761 | 193 | 93 | 436 | 0 | 23 | 391 | 370 | 132 | 138 | 761 | |||||||||||||||||||||||||||||||
2452794 | 2452794 | CT | school | 904440 | 1380011 | Stratford School District | 90444000894 | 1380911 | Nichols School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 137 | 93 | 184 | 0 | 11 | 0 | 23 | 239 | 209 | 42 | 38 | 448 | 137 | 93 | 184 | 0 | 11 | 0 | 23 | 239 | 209 | 42 | 38 | 448 | |||||||||||||||||||||||||||||
2451968 | 2451968 | CT | school | 901260 | 430011 | East Hartford School District | 90126001275 | 432411 | Sunset Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 46 | 92 | 152 | * | * | 0 | 18 | 152 | 171 | 9 | 50 | 323 | 46 | 92 | 152 | 0 | 18 | 152 | 171 | 9 | 50 | 323 | |||||||||||||||||||||||||||||||
2452431 | 2452431 | CT | school | 902790 | 930011 | New Haven School District | 90279000559 | 930711 | Hill Central Music Academy | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | * | 92 | 372 | 0 | * | 0 | 0 | 249 | 236 | 195 | 69 | 485 | 92 | 372 | 0 | 0 | 0 | 249 | 236 | 195 | 69 | 485 | |||||||||||||||||||||||||||||||
2452452 | 2452452 | CT | school | 902790 | 930011 | New Haven School District | 90279001612 | 933511 | Quinnipiac Real World Math STEM School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 21 | 91 | 158 | 0 | * | 0 | * | 142 | 137 | 47 | 29 | 279 | 21 | 91 | 158 | 0 | 0 | 142 | 137 | 47 | 29 | 279 | |||||||||||||||||||||||||||||||
2451962 | 2451962 | CT | school | 901260 | 430011 | East Hartford School District | 90126000201 | 432011 | Governor William Pitkin School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 52 | 90 | 131 | * | 34 | 0 | * | 163 | 161 | 41 | 49 | 324 | 52 | 90 | 131 | 34 | 0 | 163 | 161 | 41 | 49 | 324 | |||||||||||||||||||||||||||||||
2452756 | 2452756 | CT | school | 904320 | 1350011 | Stamford School District | 90432000865 | 1350911 | Roxbury School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 170 | 90 | 249 | * | 35 | * | 23 | 299 | 272 | 87 | 87 | 571 | 170 | 90 | 249 | 35 | 23 | 299 | 272 | 87 | 87 | 571 | |||||||||||||||||||||||||||||||
2452889 | 2452889 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000541 | 1513111 | Maloney Interdistrict Magnet School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 214 | 90 | 238 | * | * | 0 | 30 | 271 | 319 | 34 | 56 | 590 | 214 | 90 | 238 | 0 | 30 | 271 | 319 | 34 | 56 | 590 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||||||
2451973 | 2451973 | CT | school | 901290 | 440011 | East Haven School District | 90129001350 | 441811 | Overbrook Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 74 | 9 | 55 | 0 | 9 | 0 | 12 | 69 | 90 | 0 | 7 | 159 | 74 | 9 | 55 | 0 | 9 | 0 | 12 | 69 | 90 | 0 | 7 | 159 | |||||||||||||||||||||||||||||
2451976 | 2451976 | CT | school | 901290 | 440011 | East Haven School District | 90129000605 | 441711 | Carbone School/East Haven Academy | Public Schools | Regular School | No | Elementary | 01 | 08 | 2019 | pk_12_total | 233 | 9 | 56 | 0 | 7 | 0 | 9 | 161 | 153 | 11 | 38 | 314 | 233 | 9 | 56 | 0 | 7 | 0 | 9 | 161 | 153 | 11 | 38 | 314 | |||||||||||||||||||||||||||||
2451982 | 2451982 | CT | school | 901320 | 450011 | East Lyme School District | 90132000226 | 450411 | Lillie B. Haynes School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 217 | 9 | 22 | 0 | 33 | 0 | 17 | 160 | 138 | 11 | 42 | 298 | 217 | 9 | 22 | 0 | 33 | 0 | 17 | 160 | 138 | 11 | 42 | 298 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||
2452041 | 2452041 | CT | school | 901530 | 510011 | Fairfield School District | 90153000261 | 511711 | Jennings School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 222 | 9 | 29 | 0 | 14 | 0 | 21 | 173 | 122 | * | 45 | 295 | 222 | 9 | 29 | 0 | 14 | 0 | 21 | 173 | 122 | 45 | 295 | ||||||||||||||||||||||||||||||
2452044 | 2452044 | CT | school | 901530 | 510011 | Fairfield School District | 90153000264 | 511611 | North Stratfield School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 282 | 9 | 38 | 0 | 28 | 0 | 20 | 186 | 191 | 7 | 47 | 377 | 282 | 9 | 38 | 0 | 28 | 0 | 20 | 186 | 191 | 7 | 47 | 377 | |||||||||||||||||||||||||||||
2452087 | 2452087 | CT | school | 901710 | 570011 | Greenwich School District | 90171000303 | 570611 | New Lebanon School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 47 | 9 | 149 | * | 16 | 0 | * | 116 | 113 | 40 | 40 | 229 | 47 | 9 | 149 | 16 | 0 | 116 | 113 | 40 | 40 | 229 | |||||||||||||||||||||||||||||||
2452125 | 2452125 | CT | school | 620011 | Hamden School District | 621511 | Dunbar Hill IIC | Program | 2019 | pk_12_total | * | 9 | 6 | 0 | * | 0 | 0 | 11 | 8 | 0 | 19 | 19 | 9 | 6 | 0 | 0 | 0 | 11 | 8 | 0 | 19 | 19 | ||||||||||||||||||||||||||||||||||||||
2452132 | 2452132 | CT | school | 620011 | Hamden School District | 620911 | Bear Path IIC | Program | 2019 | pk_12_total | 6 | 9 | * | 0 | 0 | 0 | * | * | * | * | 24 | 24 | 6 | 9 | 0 | 0 | 0 | 24 | 24 | |||||||||||||||||||||||||||||||||||||||||
2452146 | 2452146 | CT | school | 640011 | Hartford School District | 90192001723 | 644111 | Early Childhood Development Center (ECDC) | Program | 2019 | pk_12_total | * | 9 | 32 | 0 | * | 0 | * | 33 | 11 | 0 | * | 44 | 9 | 32 | 0 | 0 | 33 | 11 | 0 | 44 | |||||||||||||||||||||||||||||||||||||||
2452178 | 2452178 | CT | school | 640011 | Hartford School District | 90192001673 | 644411 | iGOAL 1 - Rawson School | Program | 2019 | pk_12_total | 0 | 9 | * | 0 | 0 | 0 | * | * | * | * | 18 | 18 | 0 | 9 | 0 | 0 | 0 | 18 | 18 | ||||||||||||||||||||||||||||||||||||||||
2452274 | 2452274 | CT | school | 770011 | Manchester School District | 90231001769 | 770211 | Manchester High School-Site 2 | Program | 2019 | pk_12_total | 15 | 9 | 17 | 0 | 0 | 0 | 0 | 25 | 16 | * | 18 | 41 | 15 | 9 | 17 | 0 | 0 | 0 | 0 | 25 | 16 | 18 | 41 | ||||||||||||||||||||||||||||||||||||
2452279 | 2452279 | CT | school | 902340 | 780011 | Mansfield School District | 90234000435 | 780511 | Southeast Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 125 | 9 | 22 | * | 24 | 0 | * | 90 | 93 | 11 | 24 | 183 | 125 | 9 | 22 | 24 | 0 | 90 | 93 | 11 | 24 | 183 | |||||||||||||||||||||||||||||||
2452350 | 2452350 | CT | school | 902550 | 850011 | Monroe School District | 90255000490 | 850111 | Monroe Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 314 | 9 | 35 | 0 | * | 0 | * | 191 | 175 | * | 67 | 366 | 314 | 9 | 35 | 0 | 0 | 191 | 175 | 67 | 366 | ||||||||||||||||||||||||||||||||
2452602 | 2452602 | CT | school | 903510 | 1170011 | Redding School District | 90351000722 | 1170111 | Redding Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 384 | 9 | 47 | * | 10 | * | 13 | 236 | 229 | 8 | 90 | 465 | 384 | 9 | 47 | 10 | 13 | 236 | 229 | 8 | 90 | 465 | |||||||||||||||||||||||||||||||
2452674 | 2452674 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000786 | 1190511 | West Hill School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 198 | 9 | 48 | 0 | 487 | 0 | 20 | 371 | 391 | 138 | 76 | 762 | 198 | 9 | 48 | 0 | 487 | 0 | 20 | 371 | 391 | 138 | 76 | 762 | |||||||||||||||||||||||||||||
2452679 | 2452679 | CT | school | 903930 | 1220011 | Salisbury School District | 90393000788 | 1220111 | Salisbury Central School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 231 | 9 | 17 | * | * | 0 | 22 | 137 | 150 | 9 | 29 | 287 | 231 | 9 | 17 | 0 | 22 | 137 | 150 | 9 | 29 | 287 | |||||||||||||||||||||||||||||||
2452732 | 2452732 | CT | school | 904230 | 1310011 | Southington School District | 90423000839 | 1310811 | Strong Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 212 | 9 | 32 | 0 | 8 | 0 | 20 | 140 | 141 | 11 | 33 | 281 | 212 | 9 | 32 | 0 | 8 | 0 | 20 | 140 | 141 | 11 | 33 | 281 | |||||||||||||||||||||||||||||
2452944 | 2452944 | CT | school | 904860 | 1520011 | Waterford School District | 90486001593 | 1520211 | Great Neck Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 247 | 9 | 36 | 0 | 13 | 0 | 11 | 163 | 153 | 20 | 27 | 316 | 247 | 9 | 36 | 0 | 13 | 0 | 11 | 163 | 153 | 20 | 27 | 316 | |||||||||||||||||||||||||||||
2451965 | 2451965 | CT | school | 901260 | 430011 | East Hartford School District | 90126000208 | 431211 | Silver Lane School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | * | 89 | 144 | * | 0 | 0 | 17 | 126 | 140 | 36 | 39 | 266 | 89 | 144 | 0 | 0 | 17 | 126 | 140 | 36 | 39 | 266 | |||||||||||||||||||||||||||||||
2452258 | 2452258 | CT | school | 902310 | 770011 | Manchester School District | 90231000418 | 770311 | Buckley School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 154 | 89 | 79 | * | 41 | 0 | * | 205 | 161 | 27 | 56 | 366 | 154 | 89 | 79 | 41 | 0 | 205 | 161 | 27 | 56 | 366 | |||||||||||||||||||||||||||||||
2452441 | 2452441 | CT | school | 902790 | 930011 | New Haven School District | 90279000647 | 934911 | West Rock Authors Academy | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 32 | 89 | 42 | * | 6 | 0 | * | 87 | 87 | 7 | 13 | 174 | 32 | 89 | 42 | 6 | 0 | 87 | 87 | 7 | 13 | 174 | |||||||||||||||||||||||||||||||
2452894 | 2452894 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000986 | 1512011 | Sprague School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 54 | 89 | 330 | 0 | * | 0 | * | 249 | 255 | 69 | 49 | 504 | 54 | 89 | 330 | 0 | 0 | 249 | 255 | 69 | 49 | 504 | |||||||||||||||||||||||||||||||
2451963 | 2451963 | CT | school | 901260 | 430011 | East Hartford School District | 90126000204 | 430411 | Joseph O. Goodwin School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 54 | 88 | 164 | * | * | 0 | 29 | 174 | 179 | 29 | 52 | 353 | 54 | 88 | 164 | 0 | 29 | 174 | 179 | 29 | 52 | 353 | |||||||||||||||||||||||||||||||
2452887 | 2452887 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000976 | 1512611 | Gilmartin School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 78 | 88 | 275 | * | 11 | * | 17 | 246 | 230 | 45 | 71 | 476 | 78 | 88 | 275 | 11 | 17 | 246 | 230 | 45 | 71 | 476 | |||||||||||||||||||||||||||||||
2452984 | 2452984 | CT | school | 904950 | 1560011 | West Haven School District | 90495001035 | 1560311 | Forest School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 66 | 88 | 197 | * | * | 0 | 28 | 199 | 198 | 128 | 68 | 397 | 66 | 88 | 197 | 0 | 28 | 199 | 198 | 128 | 68 | 397 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452266 | 2452266 | CT | school | 902310 | 770011 | Manchester School District | 90231000429 | 771211 | Verplanck School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 55 | 86 | 107 | * | 16 | 0 | * | 160 | 109 | 32 | 35 | 269 | 55 | 86 | 107 | 16 | 0 | 160 | 109 | 32 | 35 | 269 | |||||||||||||||||||||||||||||||
2452759 | 2452759 | CT | school | 904320 | 1350011 | Stamford School District | 90432000858 | 1351211 | Julia A. Stark School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 195 | 86 | 279 | 0 | * | * | 21 | 326 | 274 | 85 | 73 | 600 | 195 | 86 | 279 | 0 | 21 | 326 | 274 | 85 | 73 | 600 | |||||||||||||||||||||||||||||||
2452787 | 2452787 | CT | school | 904440 | 1380011 | Stratford School District | 90444000889 | 1380411 | Franklin School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 44 | 86 | 164 | 0 | * | * | 16 | 160 | 164 | 40 | 32 | 324 | 44 | 86 | 164 | 0 | 16 | 160 | 164 | 40 | 32 | 324 | |||||||||||||||||||||||||||||||
2451701 | 2451701 | CT | school | 900060 | 20011 | Ansonia School District | 90006001020 | 20811 | Prendergast School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 256 | 85 | 239 | 0 | 15 | 0 | 49 | 338 | 306 | 37 | 120 | 644 | 256 | 85 | 239 | 0 | 15 | 0 | 49 | 338 | 306 | 37 | 120 | 644 | |||||||||||||||||||||||||||||
2452150 | 2452150 | CT | school | 901920 | 640011 | Hartford School District | 90192000368 | 641011 | Kennelly School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 22 | 85 | 501 | * | 6 | 7 | * | 322 | 304 | 197 | 112 | 626 | 22 | 85 | 501 | 6 | 7 | 322 | 304 | 197 | 112 | 626 | |||||||||||||||||||||||||||||||
2452882 | 2452882 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000966 | 1512111 | B. W. Tinker School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 138 | 85 | 273 | 0 | 6 | 0 | 39 | 272 | 269 | 76 | 60 | 541 | 138 | 85 | 273 | 0 | 6 | 0 | 39 | 272 | 269 | 76 | 60 | 541 | |||||||||||||||||||||||||||||
2452892 | 2452892 | CT | school | 904830 | 1510011 | Waterbury School District | 90483001131 | 1513311 | Rotella Interdistrict Magnet School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 232 | 85 | 242 | * | * | 0 | 37 | 318 | 296 | 27 | 51 | 614 | 232 | 85 | 242 | 0 | 37 | 318 | 296 | 27 | 51 | 614 | |||||||||||||||||||||||||||||||
2451786 | 2451786 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000060 | 150711 | Edison School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 25 | 84 | 67 | * | 6 | 0 | * | 100 | 84 | 13 | 35 | 184 | 25 | 84 | 67 | 6 | 0 | 100 | 84 | 13 | 35 | 184 | |||||||||||||||||||||||||||||||
2452127 | 2452127 | CT | school | 901860 | 620011 | Hamden School District | 90186000345 | 621111 | Ridge Hill School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 83 | 84 | 103 | 0 | 24 | 0 | 11 | 149 | 156 | 31 | 28 | 305 | 83 | 84 | 103 | 0 | 24 | 0 | 11 | 149 | 156 | 31 | 28 | 305 | |||||||||||||||||||||||||||||
2452480 | 2452480 | CT | school | 902820 | 950011 | New London School District | 90282000597 | 950811 | Winthrop STEM Elementary Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 150 | 84 | 191 | * | 10 | * | 78 | 279 | 237 | 62 | 70 | 516 | 150 | 84 | 191 | 10 | 78 | 279 | 237 | 62 | 70 | 516 | |||||||||||||||||||||||||||||||
2452720 | 2452720 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000826 | 1326211 | South Windsor High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 826 | 84 | 122 | * | 180 | * | 46 | 675 | 591 | 14 | 190 | 1266 | 826 | 84 | 122 | 180 | 46 | 675 | 591 | 14 | 190 | 1266 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2452479 | 2452479 | CT | school | 902820 | 950011 | New London School District | 90282000594 | 950911 | Nathan Hale Arts Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 124 | 83 | 242 | * | 7 | * | 87 | 223 | 323 | 75 | 76 | 546 | 124 | 83 | 242 | 7 | 87 | 223 | 323 | 75 | 76 | 546 | |||||||||||||||||||||||||||||||
2452753 | 2452753 | CT | school | 904320 | 1350011 | Stamford School District | 90432000852 | 1352011 | Davenport Ridge School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 298 | 83 | 172 | * | 52 | * | 18 | 326 | 300 | 81 | 65 | 626 | 298 | 83 | 172 | 52 | 18 | 326 | 300 | 81 | 65 | 626 | |||||||||||||||||||||||||||||||
2452298 | 2452298 | CT | school | 902400 | 800011 | Meriden School District | 90240001194 | 805411 | Washington Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 259 | 82 | 371 | * | * | 0 | 27 | 393 | 362 | 66 | 139 | 755 | 259 | 82 | 371 | 0 | 27 | 393 | 362 | 66 | 139 | 755 | |||||||||||||||||||||||||||||||
2452982 | 2452982 | CT | school | 904950 | 1560011 | West Haven School District | 90495001027 | 1560811 | Alma E. Pagels School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 143 | 82 | 98 | * | 24 | 0 | * | 210 | 150 | 68 | 101 | 360 | 143 | 82 | 98 | 24 | 0 | 210 | 150 | 68 | 101 | 360 | |||||||||||||||||||||||||||||||
2452197 | 2452197 | CT | school | 901920 | 640011 | Hartford School District | 90192001552 | 647611 | High School, Inc. | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | * | 81 | 102 | * | 0 | 0 | * | 95 | 95 | 35 | 45 | 190 | 81 | 102 | 0 | 0 | 95 | 95 | 35 | 45 | 190 | |||||||||||||||||||||||||||||||||
2452445 | 2452445 | CT | school | 902790 | 930011 | New Haven School District | 90279001509 | 932811 | Barack H. Obama Magnet University School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 11 | 81 | 152 | 0 | 11 | 0 | 12 | 146 | 121 | 105 | 32 | 267 | 11 | 81 | 152 | 0 | 11 | 0 | 12 | 146 | 121 | 105 | 32 | 267 | |||||||||||||||||||||||||||||
2452758 | 2452758 | CT | school | 904320 | 1350011 | Stamford School District | 90432000167 | 1352211 | Hart School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 127 | 81 | 259 | 0 | 108 | 0 | 37 | 305 | 307 | 70 | 59 | 612 | 127 | 81 | 259 | 0 | 108 | 0 | 37 | 305 | 307 | 70 | 59 | 612 | |||||||||||||||||||||||||||||
2452524 | 2452524 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000645 | 1032011 | Fox Run Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 134 | 80 | 157 | * | 23 | 0 | * | 216 | 202 | 46 | 66 | 418 | 134 | 80 | 157 | 23 | 0 | 216 | 202 | 46 | 66 | 418 | |||||||||||||||||||||||||||||||
2452792 | 2452792 | CT | school | 904440 | 1380011 | Stratford School District | 90444000898 | 1381311 | Eli Whitney School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 245 | 80 | 157 | 0 | 18 | 0 | 16 | 284 | 232 | 20 | 51 | 516 | 245 | 80 | 157 | 0 | 18 | 0 | 16 | 284 | 232 | 20 | 51 | 516 | |||||||||||||||||||||||||||||
2451704 | 2451704 | CT | school | 20011 | Ansonia School District | 90006001678 | 20111 | P.A.C.E. (Positive And Creative Education) | Program | 2019 | pk_12_total | * | 8 | 15 | 0 | 0 | 0 | * | 18 | 9 | 0 | * | 27 | 8 | 15 | 0 | 0 | 0 | 18 | 9 | 0 | 27 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
2451716 | 2451716 | CT | school | 900090 | 30011 | Ashford School District | 90009000010 | 30111 | Ashford School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 344 | 8 | 31 | 0 | * | * | 20 | 210 | 199 | 9 | 47 | 409 | 344 | 8 | 31 | 0 | 20 | 210 | 199 | 9 | 47 | 409 | |||||||||||||||||||||||||||||||
2451806 | 2451806 | CT | school | 900510 | 170011 | Bristol School District | 90051000096 | 170311 | Edgewood School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 147 | 8 | 97 | 0 | 13 | 0 | 11 | 142 | * | 14 | 32 | 276 | 147 | 8 | 97 | 0 | 13 | 0 | 11 | 142 | 14 | 32 | 276 | ||||||||||||||||||||||||||||||
2451857 | 2451857 | CT | school | 2410014 | Capitol Region Education Council | 90070001510 | 2419514 | River Street School Birken Campus | Program | 2019 | pk_12_total | 26 | 8 | 12 | 0 | * | 0 | * | 43 | 9 | * | 52 | 52 | 26 | 8 | 12 | 0 | 0 | 43 | 9 | 52 | 52 | ||||||||||||||||||||||||||||||||||||||
2451877 | 2451877 | CT | school | 900750 | 250011 | Cheshire School District | 90075000129 | 250511 | Norton School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 324 | 8 | 25 | 0 | 51 | 0 | 17 | 220 | 205 | * | 37 | 425 | 324 | 8 | 25 | 0 | 51 | 0 | 17 | 220 | 205 | 37 | 425 | ||||||||||||||||||||||||||||||
2451912 | 2451912 | CT | school | 901020 | 340011 | Danbury School District | 90102001634 | 340111 | DPS Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 49 | 8 | 73 | * | 12 | 0 | * | 90 | 60 | 0 | 72 | 150 | 49 | 8 | 73 | 12 | 0 | 90 | 60 | 0 | 72 | 150 | |||||||||||||||||||||||||||||||
2451977 | 2451977 | CT | school | 901290 | 440011 | East Haven School District | 90129000215 | 441311 | Dominick H. Ferrara School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 111 | 8 | 48 | * | 10 | 0 | * | 86 | 99 | 16 | 34 | 185 | 111 | 8 | 48 | 10 | 0 | 86 | 99 | 16 | 34 | 185 | |||||||||||||||||||||||||||||||
2452063 | 2452063 | CT | school | 901590 | 530011 | Franklin School District | 90159000278 | 530111 | Franklin Elementary School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 125 | 8 | 9 | 0 | * | 0 | * | 83 | 71 | 0 | 9 | 154 | 125 | 8 | 9 | 0 | 0 | 83 | 71 | 0 | 9 | 154 | |||||||||||||||||||||||||||||||
2452116 | 2452116 | CT | school | 901800 | 600011 | Guilford School District | 90180000328 | 600711 | A. Baldwin Middle School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 413 | 8 | 40 | 0 | 22 | 0 | 19 | 270 | 232 | 11 | 67 | 502 | 413 | 8 | 40 | 0 | 22 | 0 | 19 | 270 | 232 | 11 | 67 | 502 | |||||||||||||||||||||||||||||
2452275 | 2452275 | CT | school | 770011 | Manchester School District | 90231001717 | 770711 | New Horizons | Program | 2019 | pk_12_total | 6 | 8 | 9 | * | * | 0 | 0 | 16 | 9 | 0 | 8 | 25 | 6 | 8 | 9 | 0 | 0 | 16 | 9 | 0 | 8 | 25 | |||||||||||||||||||||||||||||||||||||
2452286 | 2452286 | CT | school | 800011 | Meriden School District | 802611 | PRIDE | Program | 2019 | pk_12_total | 33 | 8 | 50 | 0 | * | 0 | * | 77 | 22 | 0 | * | 99 | 33 | 8 | 50 | 0 | 0 | 77 | 22 | 0 | 99 | |||||||||||||||||||||||||||||||||||||||
2452405 | 2452405 | CT | school | 902700 | 900011 | New Canaan School District | 90270000532 | 905111 | Saxe Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 1102 | 8 | 72 | * | 105 | * | 42 | 686 | 648 | 9 | 162 | 1334 | 1102 | 8 | 72 | 105 | 42 | 686 | 648 | 9 | 162 | 1334 | |||||||||||||||||||||||||||||||
2452408 | 2452408 | CT | school | 902730 | 910011 | New Fairfield School District | 90273000535 | 910111 | Consolidated School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 392 | 8 | 61 | * | * | * | 18 | 246 | 238 | 36 | 79 | 484 | 392 | 8 | 61 | 18 | 246 | 238 | 36 | 79 | 484 | ||||||||||||||||||||||||||||||||
2452560 | 2452560 | CT | school | 1040011 | Norwich School District | 90312001622 | 1049211 | Virtual Learning Academy | Program | 2019 | pk_12_total | * | 8 | 6 | 0 | 0 | 0 | * | 13 | 6 | 0 | 10 | 19 | 8 | 6 | 0 | 0 | 0 | 13 | 6 | 0 | 10 | 19 | |||||||||||||||||||||||||||||||||||||
2452596 | 2452596 | CT | school | 903420 | 1140011 | Preston School District | 90342001466 | 1140411 | Preston Veterans' Memorial School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 246 | 8 | 22 | 0 | * | * | 7 | 161 | 134 | 6 | 46 | 295 | 246 | 8 | 22 | 0 | 7 | 161 | 134 | 6 | 46 | 295 | |||||||||||||||||||||||||||||||
2452611 | 2452611 | CT | school | 903515 | 2060012 | Regional School District 06 | 90351500725 | 2066112 | Wamogo Regional High School | Regional Schools | Regular School | No | High | 07 | 12 | 2019 | pk_12_total | 471 | 8 | 15 | * | * | * | * | 224 | 285 | * | 93 | 509 | 471 | 8 | 15 | 224 | 285 | 93 | 509 | ||||||||||||||||||||||||||||||||||
2452649 | 2452649 | CT | school | 903539 | 2170012 | Regional School District 17 | 90353900759 | 2176112 | Haddam-Killingworth High School | Regional Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 601 | 8 | 12 | 0 | 14 | 0 | 9 | 333 | 311 | * | 83 | 644 | 601 | 8 | 12 | 0 | 14 | 0 | 9 | 333 | 311 | 83 | 644 | ||||||||||||||||||||||||||||||
2452715 | 2452715 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000821 | 1320111 | Philip R. Smith School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 230 | 8 | 31 | 0 | 107 | 0 | 18 | 199 | 195 | 50 | 29 | 394 | 230 | 8 | 31 | 0 | 107 | 0 | 18 | 199 | 195 | 50 | 29 | 394 | |||||||||||||||||||||||||||||
2452777 | 2452777 | CT | school | 904350 | 1360011 | Sterling School District | 90435001491 | 1360311 | Sterling Community School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 304 | 8 | 20 | * | * | 0 | 21 | 198 | 163 | 0 | 50 | 361 | 304 | 8 | 20 | 0 | 21 | 198 | 163 | 0 | 50 | 361 | |||||||||||||||||||||||||||||||
2452869 | 2452869 | CT | school | 904740 | 1480011 | Wallingford School District | 90474001213 | 1480311 | Parker Farms School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 179 | 8 | 59 | 0 | 12 | * | * | 124 | 142 | 34 | 37 | 266 | 179 | 8 | 59 | 0 | 12 | 124 | 142 | 34 | 37 | 266 | |||||||||||||||||||||||||||||||
2452923 | 2452923 | CT | school | 1510011 | Waterbury School District | 1513711 | North End BDLC | Program | 2019 | pk_12_total | 0 | 8 | 12 | 0 | 0 | 0 | 0 | * | * | * | 20 | 20 | 0 | 8 | 12 | 0 | 0 | 0 | 0 | 20 | 20 | |||||||||||||||||||||||||||||||||||||||
2453035 | 2453035 | CT | school | 905190 | 1630011 | Windham School District | 90519001640 | 1630411 | Charles H. Barrows STEM Academy | Public Schools | Regular School | No | Elementary | KG | 08 | 2019 | pk_12_total | 278 | 8 | 247 | * | 6 | * | 25 | 289 | 278 | 72 | 70 | 567 | 278 | 8 | 247 | 6 | 25 | 289 | 278 | 72 | 70 | 567 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
2451848 | 2451848 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001597 | 2418114 | Discovery Academy | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 166 | 79 | 201 | * | 34 | * | 36 | 266 | 253 | 42 | 56 | 519 | 166 | 79 | 201 | 34 | 36 | 266 | 253 | 42 | 56 | 519 | |||||||||||||||||||||||||||||||
2451864 | 2451864 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001625 | 2415314 | Greater Hartford Academy of the Arts Magnet Middle | Regional Education Service Center Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 86 | 79 | 155 | 0 | * | 0 | * | 88 | 247 | 16 | 88 | 335 | 86 | 79 | 155 | 0 | 0 | 88 | 247 | 16 | 88 | 335 | |||||||||||||||||||||||||||||||
2452142 | 2452142 | CT | school | 901920 | 640011 | Hartford School District | 90192001369 | 643311 | Breakthrough Magnet School, South | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 59 | 79 | 175 | * | 24 | 0 | * | 179 | 171 | 47 | 53 | 350 | 59 | 79 | 175 | 24 | 0 | 179 | 171 | 47 | 53 | 350 | |||||||||||||||||||||||||||||||
2452697 | 2452697 | CT | school | 904050 | 1260011 | Shelton School District | 90405000806 | 1266111 | Shelton High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 983 | 79 | 196 | * | 98 | 0 | * | 717 | * | 18 | 160 | 1401 | 983 | 79 | 196 | 98 | 0 | 717 | 18 | 160 | 1401 |
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]);