enrollments
Data source: Big Local News · About: Big Local
4,354 rows where grade = "pk_12_total" and state = "CT" sorted by ell_int 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2452163 | 2452163 | CT | school | 901920 | 640011 | Hartford School District | 90192000026 | 643011 | Sanchez School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | * | 46 | 373 | 0 | * | 0 | * | 188 | 236 | 198 | 69 | 424 | 46 | 373 | 0 | 0 | 188 | 236 | 198 | 69 | 424 | ||||||||||||||||||||||||||||||||
2777821 | 2777821 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000050 | 156111 | Bassick High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 54 | 312 | 427 | * | 10 | 0 | * | 485 | 323 | 198 | 225 | 808 | 54 | 312 | 427 | 10 | 0 | 485 | 323 | 198 | 225 | 808 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452484 | 2452484 | CT | school | 902820 | 950011 | New London School District | 90282000595 | 956111 | New London High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 51 | 160 | 388 | * | * | * | 49 | 353 | 306 | 196 | 165 | 659 | 51 | 160 | 388 | 49 | 353 | 306 | 196 | 165 | 659 | ||||||||||||||||||||||||||||||||
2779071 | 2779071 | CT | school | 905190 | 1630011 | Windham School District | 90519001086 | 1636111 | Windham High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 106 | 24 | 470 | * | * | 0 | 11 | 359 | 257 | 196 | 150 | 616 | 106 | 24 | 470 | 0 | 11 | 359 | 257 | 196 | 150 | 616 | |||||||||||||||||||||||||||||||
2451919 | 2451919 | CT | school | 901020 | 340011 | Danbury School District | 90102000163 | 341611 | Stadley Rough School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 193 | 34 | 248 | * | 21 | 0 | * | 276 | 238 | 195 | 41 | 514 | 193 | 34 | 248 | 21 | 0 | 276 | 238 | 195 | 41 | 514 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2777947 | 2777947 | CT | school | 901020 | 340011 | Danbury School District | 90102000153 | 341311 | King Street Primary School | Public Schools | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 161 | 18 | 244 | 0 | * | 0 | * | 256 | 188 | 195 | 46 | 444 | 161 | 18 | 244 | 0 | 0 | 256 | 188 | 195 | 46 | 444 | |||||||||||||||||||||||||||||||
2451792 | 2451792 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000050 | 156111 | Bassick High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 55 | 332 | 477 | * | 14 | 0 | * | 530 | 354 | 194 | 233 | 884 | 55 | 332 | 477 | 14 | 0 | 530 | 354 | 194 | 233 | 884 | |||||||||||||||||||||||||||||||
2758725 | 2758725 | CT | school | 905371 | 9010022 | Norwich Free Academy District | 90537101221 | 9016122 | Norwich Free Academy | Endowed and Incorporated Academies Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 1093 | 295 | 399 | 27 | 147 | 19 | 123 | * | 1128 | 194 | 260 | 2103 | 1093 | 295 | 399 | 27 | 147 | 19 | 123 | 1128 | 194 | 260 | 2103 | ||||||||||||||||||||||||||||||
2757503 | 2757503 | CT | school | 901020 | 340011 | Danbury School District | 90102000161 | 341211 | Shelter Rock School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 172 | 27 | 251 | * | 47 | * | 19 | 255 | 263 | 193 | 43 | 518 | 172 | 27 | 251 | 47 | 19 | 255 | 263 | 193 | 43 | 518 | |||||||||||||||||||||||||||||||
2778452 | 2778452 | CT | school | 902790 | 930011 | New Haven School District | 90279000559 | 930711 | Hill Central Music Academy | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | * | 100 | 355 | 0 | * | 0 | 0 | 250 | 225 | 193 | 66 | 475 | 100 | 355 | 0 | 0 | 0 | 250 | 225 | 193 | 66 | 475 | |||||||||||||||||||||||||||||||
2777949 | 2777949 | CT | school | 901020 | 340011 | Danbury School District | 90102000156 | 340611 | Morris Street School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 63 | 11 | 243 | 0 | 8 | 0 | 9 | 156 | 178 | 192 | 38 | 334 | 63 | 11 | 243 | 0 | 8 | 0 | 9 | 156 | 178 | 192 | 38 | 334 | |||||||||||||||||||||||||||||
2778487 | 2778487 | CT | school | 902790 | 930011 | New Haven School District | 90279000563 | 936211 | James Hillhouse High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 47 | 604 | 394 | * | 12 | * | 14 | 568 | 506 | 190 | 224 | 1074 | 47 | 604 | 394 | 12 | 14 | 568 | 506 | 190 | 224 | 1074 | |||||||||||||||||||||||||||||||
2452935 | 2452935 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000971 | 1516211 | Crosby High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 172 | 306 | 645 | * | 13 | * | 18 | 637 | 525 | 188 | 311 | 1162 | 172 | 306 | 645 | 13 | 18 | 637 | 525 | 188 | 311 | 1162 | |||||||||||||||||||||||||||||||
2758617 | 2758617 | CT | school | 905190 | 1630011 | Windham School District | 90519001081 | 1635111 | Windham Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 106 | 21 | 532 | * | * | 0 | 15 | 348 | 330 | 188 | 146 | 678 | 106 | 21 | 532 | 0 | 15 | 348 | 330 | 188 | 146 | 678 | |||||||||||||||||||||||||||||||
2778961 | 2778961 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000971 | 1516211 | Crosby High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 150 | 293 | 654 | 8 | 19 | 0 | 14 | 607 | 531 | 188 | 309 | 1138 | 150 | 293 | 654 | 8 | 19 | 0 | 14 | 607 | 531 | 188 | 309 | 1138 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2777953 | 2777953 | CT | school | 901020 | 340011 | Danbury School District | 90102000162 | 341011 | South Street School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 104 | 29 | 227 | 0 | 22 | 0 | 8 | 195 | 195 | 187 | 31 | 390 | 104 | 29 | 227 | 0 | 22 | 0 | 8 | 195 | 195 | 187 | 31 | 390 | |||||||||||||||||||||||||||||
2451921 | 2451921 | CT | school | 901020 | 340011 | Danbury School District | 90102000153 | 341311 | King Street Primary School | Public Schools | Regular School | No | Elementary | KG | 03 | 2019 | pk_12_total | 156 | 22 | 248 | * | 17 | 0 | * | 247 | 205 | 186 | 48 | 452 | 156 | 22 | 248 | 17 | 0 | 247 | 205 | 186 | 48 | 452 | |||||||||||||||||||||||||||||||
2453042 | 2453042 | CT | school | 905190 | 1630011 | Windham School District | 90519001081 | 1635111 | Windham Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 98 | 26 | 512 | * | * | 0 | 13 | 343 | 311 | 186 | 138 | 654 | 98 | 26 | 512 | 0 | 13 | 343 | 311 | 186 | 138 | 654 | |||||||||||||||||||||||||||||||
2758007 | 2758007 | CT | school | 902790 | 930011 | New Haven School District | 90279000559 | 930711 | Hill Central Music Academy | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 15 | 78 | 324 | * | * | 0 | * | 222 | 199 | 185 | 61 | 421 | 15 | 78 | 324 | 0 | 222 | 199 | 185 | 61 | 421 | ||||||||||||||||||||||||||||||||
2452542 | 2452542 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000655 | 1036111 | Norwalk High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 554 | 330 | 740 | * | 74 | * | 22 | 912 | 810 | 184 | 213 | 1722 | 554 | 330 | 740 | 74 | 22 | 912 | 810 | 184 | 213 | 1722 | |||||||||||||||||||||||||||||||
2778193 | 2778193 | CT | school | 901920 | 640011 | Hartford School District | 90192000026 | 643011 | Sanchez School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | * | 35 | 339 | 0 | 0 | 0 | * | 170 | 211 | 184 | 57 | 381 | 35 | 339 | 0 | 0 | 0 | 170 | 211 | 184 | 57 | 381 | |||||||||||||||||||||||||||||||
2778417 | 2778417 | CT | school | 902670 | 890011 | New Britain School District | 90267000518 | 895311 | Pulaski Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 158 | 83 | 613 | * | 23 | 0 | * | 500 | 401 | 184 | 194 | 901 | 158 | 83 | 613 | 23 | 0 | 500 | 401 | 184 | 194 | 901 | |||||||||||||||||||||||||||||||
2777791 | 2777791 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000049 | 150111 | Barnum School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 51 | 155 | 421 | * | * | 0 | * | 356 | 283 | 182 | 203 | 639 | 51 | 155 | 421 | 0 | 356 | 283 | 182 | 203 | 639 | ||||||||||||||||||||||||||||||||
2451922 | 2451922 | CT | school | 901020 | 340011 | Danbury School District | 90102000156 | 340611 | Morris Street School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 56 | 15 | 235 | 0 | 12 | 0 | 14 | 157 | 175 | 181 | 32 | 332 | 56 | 15 | 235 | 0 | 12 | 0 | 14 | 157 | 175 | 181 | 32 | 332 | |||||||||||||||||||||||||||||
2758618 | 2758618 | CT | school | 905190 | 1630011 | Windham School District | 90519001086 | 1636111 | Windham High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 95 | 32 | 461 | * | * | 0 | 11 | 344 | 260 | 181 | 135 | 604 | 95 | 32 | 461 | 0 | 11 | 344 | 260 | 181 | 135 | 604 | |||||||||||||||||||||||||||||||
2451769 | 2451769 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000058 | 150511 | Columbus School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 87 | 160 | 302 | * | * | 0 | 9 | 294 | 271 | 180 | 56 | 565 | 87 | 160 | 302 | 0 | 9 | 294 | 271 | 180 | 56 | 565 | |||||||||||||||||||||||||||||||
2452450 | 2452450 | CT | school | 902790 | 930011 | New Haven School District | 90279000550 | 930611 | Clinton Avenue School | Public Schools | Regular School | No | Elementary | KG | 08 | 2019 | pk_12_total | * | 75 | 379 | 0 | 0 | 0 | * | 260 | 233 | 180 | 64 | 493 | 75 | 379 | 0 | 0 | 0 | 260 | 233 | 180 | 64 | 493 | |||||||||||||||||||||||||||||||
2757744 | 2757744 | CT | school | 901920 | 640011 | Hartford School District | 90192000373 | 641511 | Parkville Community School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 26 | 31 | 316 | * | * | * | * | 216 | 169 | 180 | 66 | 385 | 26 | 31 | 316 | 216 | 169 | 180 | 66 | 385 | |||||||||||||||||||||||||||||||||
2757550 | 2757550 | CT | school | 901260 | 430011 | East Hartford School District | 90126000197 | 435111 | East Hartford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 96 | 344 | 562 | * | 33 | * | 49 | 590 | 499 | 178 | 249 | 1089 | 96 | 344 | 562 | 33 | 49 | 590 | 499 | 178 | 249 | 1089 | |||||||||||||||||||||||||||||||
2452940 | 2452940 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000992 | 1516311 | Wilby High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 100 | 284 | 590 | * | * | 0 | 19 | 545 | 457 | 177 | 239 | 1002 | 100 | 284 | 590 | 0 | 19 | 545 | 457 | 177 | 239 | 1002 | |||||||||||||||||||||||||||||||
2757508 | 2757508 | CT | school | 901020 | 340011 | Danbury School District | 90102000149 | 345111 | Broadview Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 312 | 82 | 534 | * | 59 | 0 | * | 541 | 482 | 177 | 165 | 1023 | 312 | 82 | 534 | 59 | 0 | 541 | 482 | 177 | 165 | 1023 | |||||||||||||||||||||||||||||||
2778408 | 2778408 | CT | school | 902670 | 890011 | New Britain School District | 90267000523 | 891211 | Smalley Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 70 | 47 | 469 | * | * | 0 | 20 | 311 | 299 | 177 | 104 | 610 | 70 | 47 | 469 | 0 | 20 | 311 | 299 | 177 | 104 | 610 | |||||||||||||||||||||||||||||||
2452157 | 2452157 | CT | school | 901920 | 640011 | Hartford School District | 90192000373 | 641511 | Parkville Community School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 20 | 47 | 375 | * | * | * | * | 226 | 225 | 175 | 77 | 451 | 20 | 47 | 375 | 226 | 225 | 175 | 77 | 451 | |||||||||||||||||||||||||||||||||
2452389 | 2452389 | CT | school | 902670 | 890011 | New Britain School District | 90267000523 | 891211 | Smalley Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 78 | 47 | 514 | 0 | * | 0 | * | 327 | 334 | 174 | 96 | 661 | 78 | 47 | 514 | 0 | 0 | 327 | 334 | 174 | 96 | 661 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778322 | 2778322 | CT | school | 902400 | 800011 | Meriden School District | 90240000441 | 806111 | Francis T. Maloney High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 369 | 127 | 605 | 0 | 53 | 0 | 43 | 604 | 593 | 174 | 186 | 1197 | 369 | 127 | 605 | 0 | 53 | 0 | 43 | 604 | 593 | 174 | 186 | 1197 | |||||||||||||||||||||||||||||
2778547 | 2778547 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000649 | 1030811 | Kendall Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 48 | 75 | 336 | 0 | 25 | 0 | 19 | 246 | 257 | 174 | 52 | 503 | 48 | 75 | 336 | 0 | 25 | 0 | 19 | 246 | 257 | 174 | 52 | 503 | |||||||||||||||||||||||||||||
2779064 | 2779064 | CT | school | 905190 | 1630011 | Windham School District | 90519001214 | 1630311 | North Windham School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 72 | 19 | 348 | * | 9 | 0 | * | 230 | 224 | 174 | 76 | 454 | 72 | 19 | 348 | 9 | 0 | 230 | 224 | 174 | 76 | 454 | |||||||||||||||||||||||||||||||
2779070 | 2779070 | CT | school | 905190 | 1630011 | Windham School District | 90519001081 | 1635111 | Windham Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 99 | 20 | 529 | 0 | 0 | 0 | 10 | 336 | 322 | 174 | 141 | 658 | 99 | 20 | 529 | 0 | 0 | 0 | 10 | 336 | 322 | 174 | 141 | 658 | |||||||||||||||||||||||||||||
2451762 | 2451762 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000049 | 150111 | Barnum School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 57 | 146 | 406 | * | * | 0 | * | 337 | 283 | 171 | 177 | 620 | 57 | 146 | 406 | 0 | 337 | 283 | 171 | 177 | 620 | ||||||||||||||||||||||||||||||||
2758611 | 2758611 | CT | school | 905190 | 1630011 | Windham School District | 90519001214 | 1630311 | North Windham School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 80 | 21 | 322 | * | * | 0 | * | 212 | 219 | 171 | 68 | 431 | 80 | 21 | 322 | 0 | 212 | 219 | 171 | 68 | 431 | ||||||||||||||||||||||||||||||||
2778002 | 2778002 | CT | school | 901260 | 430011 | East Hartford School District | 90126000200 | 436211 | East Hartford High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 212 | 580 | 754 | * | 84 | * | 45 | 868 | 814 | 171 | 294 | 1682 | 212 | 580 | 754 | 84 | 45 | 868 | 814 | 171 | 294 | 1682 | |||||||||||||||||||||||||||||||
2778554 | 2778554 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000659 | 1032311 | Silvermine Dual Language Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 51 | 46 | 380 | 0 | * | * | 13 | 265 | 231 | 171 | 55 | 496 | 51 | 46 | 380 | 0 | 13 | 265 | 231 | 171 | 55 | 496 | |||||||||||||||||||||||||||||||
2452148 | 2452148 | CT | school | 901920 | 640011 | Hartford School District | 90192000636 | 643211 | Expeditionary Learning Academy at Moylan School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 24 | 53 | 470 | 0 | * | 0 | * | 284 | 267 | 170 | 123 | 551 | 24 | 53 | 470 | 0 | 0 | 284 | 267 | 170 | 123 | 551 | |||||||||||||||||||||||||||||||
2758059 | 2758059 | CT | school | 902820 | 950011 | New London School District | 90282000595 | 956111 | New London High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 35 | 103 | 356 | * | * | * | 36 | 311 | 226 | 169 | 131 | 537 | 35 | 103 | 356 | 36 | 311 | 226 | 169 | 131 | 537 | ||||||||||||||||||||||||||||||||
2758103 | 2758103 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000649 | 1030811 | Kendall Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 35 | 62 | 338 | 0 | 22 | 0 | 15 | 237 | 235 | 169 | 58 | 472 | 35 | 62 | 338 | 0 | 22 | 0 | 15 | 237 | 235 | 169 | 58 | 472 | |||||||||||||||||||||||||||||
2778505 | 2778505 | CT | school | 902820 | 950011 | New London School District | 90282000595 | 956111 | New London High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 36 | 128 | 352 | * | * | * | 43 | 317 | 251 | 169 | 141 | 568 | 36 | 128 | 352 | 43 | 317 | 251 | 169 | 141 | 568 | ||||||||||||||||||||||||||||||||
2452531 | 2452531 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000649 | 1030811 | Kendall Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 56 | 69 | 323 | 0 | 25 | 0 | 11 | 235 | 249 | 168 | 43 | 484 | 56 | 69 | 323 | 0 | 25 | 0 | 11 | 235 | 249 | 168 | 43 | 484 | |||||||||||||||||||||||||||||
2777945 | 2777945 | CT | school | 901020 | 340011 | Danbury School District | 90102000152 | 340211 | Hayestown Avenue School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 132 | 31 | 243 | * | 57 | * | 7 | 237 | 236 | 168 | 104 | 473 | 132 | 31 | 243 | 57 | 7 | 237 | 236 | 168 | 104 | 473 | |||||||||||||||||||||||||||||||
2778470 | 2778470 | CT | school | 902790 | 930011 | New Haven School District | 90279000550 | 930611 | Clinton Avenue School | Public Schools | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 31 | 66 | 349 | 0 | * | 0 | * | 236 | 218 | 168 | 67 | 454 | 31 | 66 | 349 | 0 | 0 | 236 | 218 | 168 | 67 | 454 | |||||||||||||||||||||||||||||||
2452166 | 2452166 | CT | school | 901920 | 640011 | Hartford School District | 90192000385 | 642211 | Wish Museum School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | * | 185 | 306 | 0 | * | 0 | * | 254 | 248 | 167 | 129 | 502 | 185 | 306 | 0 | 0 | 254 | 248 | 167 | 129 | 502 | ||||||||||||||||||||||||||||||||
2452301 | 2452301 | CT | school | 902400 | 800011 | Meriden School District | 90240000441 | 806111 | Francis T. Maloney High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 355 | 119 | 575 | 0 | 43 | 0 | 42 | 579 | 555 | 166 | 177 | 1134 | 355 | 119 | 575 | 0 | 43 | 0 | 42 | 579 | 555 | 166 | 177 | 1134 | |||||||||||||||||||||||||||||
2453043 | 2453043 | CT | school | 905190 | 1630011 | Windham School District | 90519001086 | 1636111 | Windham High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 103 | 27 | 414 | * | * | 0 | * | 315 | 239 | 165 | 148 | 554 | 103 | 27 | 414 | 0 | 315 | 239 | 165 | 148 | 554 | ||||||||||||||||||||||||||||||||
2757752 | 2757752 | CT | school | 901920 | 640011 | Hartford School District | 90192000026 | 643011 | Sanchez School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 6 | 35 | 300 | * | * | 0 | * | 154 | 190 | 165 | 49 | 344 | 6 | 35 | 300 | 0 | 154 | 190 | 165 | 49 | 344 | ||||||||||||||||||||||||||||||||
2778218 | 2778218 | CT | school | 901920 | 640011 | Hartford School District | 90192000371 | 641211 | McDonough Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 11 | 38 | 335 | 0 | 7 | 0 | 0 | 207 | 184 | 165 | 87 | 391 | 11 | 38 | 335 | 0 | 7 | 0 | 0 | 207 | 184 | 165 | 87 | 391 | |||||||||||||||||||||||||||||
2758025 | 2758025 | CT | school | 902790 | 930011 | New Haven School District | 90279000550 | 930611 | Clinton Avenue School | Public Schools | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 31 | 52 | 333 | * | 0 | 0 | * | 216 | 211 | 164 | 62 | 427 | 31 | 52 | 333 | 0 | 0 | 216 | 211 | 164 | 62 | 427 | |||||||||||||||||||||||||||||||
2452165 | 2452165 | CT | school | 901920 | 640011 | Hartford School District | 90192000384 | 642111 | West Middle School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | * | 184 | 248 | 0 | 32 | 0 | * | 243 | 237 | 163 | 76 | 480 | 184 | 248 | 0 | 32 | 0 | 243 | 237 | 163 | 76 | 480 | |||||||||||||||||||||||||||||||
2758487 | 2758487 | CT | school | 1510011 | Waterbury School District | 1514211 | Hopeville Bilingual | Program | 2021 | pk_12_total | 0 | 0 | 163 | 0 | 0 | 0 | 0 | 76 | 87 | 163 | 23 | 163 | 0 | 0 | 163 | 0 | 0 | 0 | 0 | 76 | 87 | 163 | 23 | 163 | ||||||||||||||||||||||||||||||||||||
2758008 | 2758008 | CT | school | 902790 | 930011 | New Haven School District | 90279001443 | 931311 | John C. Daniels | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 58 | 69 | 372 | 0 | 8 | 0 | 8 | 262 | 253 | 162 | 52 | 515 | 58 | 69 | 372 | 0 | 8 | 0 | 8 | 262 | 253 | 162 | 52 | 515 | |||||||||||||||||||||||||||||
2777999 | 2777999 | CT | school | 901260 | 430011 | East Hartford School District | 90126000197 | 435111 | East Hartford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 106 | 358 | 564 | * | 39 | * | 60 | 612 | 521 | 162 | 242 | 1133 | 106 | 358 | 564 | 39 | 60 | 612 | 521 | 162 | 242 | 1133 | |||||||||||||||||||||||||||||||
2453037 | 2453037 | CT | school | 905190 | 1630011 | Windham School District | 90519001214 | 1630311 | North Windham School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 72 | 15 | 347 | * | * | 0 | * | 229 | 215 | 160 | 71 | 444 | 72 | 15 | 347 | 0 | 229 | 215 | 160 | 71 | 444 | ||||||||||||||||||||||||||||||||
2758110 | 2758110 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000659 | 1032311 | Silvermine Dual Language Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 44 | 35 | 365 | 0 | 8 | 0 | 14 | 240 | 226 | 159 | 47 | 466 | 44 | 35 | 365 | 0 | 8 | 0 | 14 | 240 | 226 | 159 | 47 | 466 | |||||||||||||||||||||||||||||
2778790 | 2778790 | CT | school | 904320 | 1350011 | Stamford School District | 90432000008 | 1351911 | Toquam Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 113 | 76 | 409 | * | 40 | * | 24 | 363 | 303 | 158 | 78 | 666 | 113 | 76 | 409 | 40 | 24 | 363 | 303 | 158 | 78 | 666 | |||||||||||||||||||||||||||||||
2757496 | 2757496 | CT | school | 901020 | 340011 | Danbury School District | 90102000152 | 340211 | Hayestown Avenue School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 117 | 30 | 249 | * | 54 | 0 | * | 241 | 220 | 157 | 97 | 461 | 117 | 30 | 249 | 54 | 0 | 241 | 220 | 157 | 97 | 461 | |||||||||||||||||||||||||||||||
2778195 | 2778195 | CT | school | 901920 | 640011 | Hartford School District | 90192000384 | 642111 | West Middle School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 11 | 191 | 232 | 0 | 22 | * | * | 246 | 216 | 157 | 87 | 462 | 11 | 191 | 232 | 0 | 22 | 246 | 216 | 157 | 87 | 462 | |||||||||||||||||||||||||||||||
2451914 | 2451914 | CT | school | 901020 | 340011 | Danbury School District | 90102000152 | 340211 | Hayestown Avenue School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 121 | 28 | 253 | * | 53 | 0 | * | 228 | 242 | 156 | 99 | 470 | 121 | 28 | 253 | 53 | 0 | 228 | 242 | 156 | 99 | 470 | |||||||||||||||||||||||||||||||
2452467 | 2452467 | CT | school | 902790 | 930011 | New Haven School District | 90279000563 | 936211 | James Hillhouse High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 46 | 597 | 289 | * | 8 | * | * | 507 | 439 | 156 | 192 | 946 | 46 | 597 | 289 | 8 | 507 | 439 | 156 | 192 | 946 | ||||||||||||||||||||||||||||||||
2778179 | 2778179 | CT | school | 901920 | 640011 | Hartford School District | 90192000636 | 643211 | Expeditionary Learning Academy at Moylan School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 20 | 57 | 422 | * | * | * | 6 | 256 | 254 | 156 | 105 | 510 | 20 | 57 | 422 | 6 | 256 | 254 | 156 | 105 | 510 | ||||||||||||||||||||||||||||||||
2757875 | 2757875 | CT | school | 902400 | 800011 | Meriden School District | 90240000441 | 806111 | Francis T. Maloney High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 354 | 134 | 626 | * | 44 | * | 48 | 602 | 606 | 155 | 187 | 1208 | 354 | 134 | 626 | 44 | 48 | 602 | 606 | 155 | 187 | 1208 | |||||||||||||||||||||||||||||||
2757973 | 2757973 | CT | school | 902670 | 890011 | New Britain School District | 90267000522 | 895211 | Slade Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 107 | 102 | 593 | * | * | 0 | 26 | 447 | 395 | 155 | 184 | 842 | 107 | 102 | 593 | 0 | 26 | 447 | 395 | 155 | 184 | 842 | |||||||||||||||||||||||||||||||
2452534 | 2452534 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000659 | 1032311 | Silvermine Dual Language Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 57 | 50 | 364 | 0 | * | * | 12 | 262 | 231 | 154 | 56 | 493 | 57 | 50 | 364 | 0 | 12 | 262 | 231 | 154 | 56 | 493 | |||||||||||||||||||||||||||||||
2757343 | 2757343 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000049 | 150111 | Barnum School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 43 | 148 | 398 | * | * | 0 | * | 332 | 265 | 154 | 180 | 597 | 43 | 148 | 398 | 0 | 332 | 265 | 154 | 180 | 597 | ||||||||||||||||||||||||||||||||
2777957 | 2777957 | CT | school | 901020 | 340011 | Danbury School District | 90102000149 | 345111 | Broadview Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 335 | 88 | 484 | * | 45 | 0 | * | 506 | 483 | 154 | 170 | 989 | 335 | 88 | 484 | 45 | 0 | 506 | 483 | 154 | 170 | 989 | |||||||||||||||||||||||||||||||
2452156 | 2452156 | CT | school | 901920 | 640011 | Hartford School District | 90192000372 | 641411 | Naylor/CCSU Leadership Academy | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 75 | 53 | 369 | * | 20 | * | * | 276 | 245 | 153 | 101 | 521 | 75 | 53 | 369 | 20 | 276 | 245 | 153 | 101 | 521 | ||||||||||||||||||||||||||||||||
2758482 | 2758482 | CT | school | 1510011 | Waterbury School District | 1514111 | Chase Bilingual | Program | 2021 | pk_12_total | 22 | 0 | 130 | 0 | 0 | 0 | 0 | 89 | 63 | 152 | 13 | 152 | 22 | 0 | 130 | 0 | 0 | 0 | 0 | 89 | 63 | 152 | 13 | 152 | ||||||||||||||||||||||||||||||||||||
2778453 | 2778453 | CT | school | 902790 | 930011 | New Haven School District | 90279001443 | 931311 | John C. Daniels | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 58 | 67 | 377 | 0 | 7 | 0 | 7 | 269 | 247 | 152 | 54 | 516 | 58 | 67 | 377 | 0 | 7 | 0 | 7 | 269 | 247 | 152 | 54 | 516 | |||||||||||||||||||||||||||||
2778935 | 2778935 | CT | school | 1510011 | Waterbury School District | 1514211 | Hopeville Bilingual | Program | 2020 | pk_12_total | 0 | 0 | 151 | 0 | 0 | 0 | 0 | 74 | 77 | 151 | 18 | 151 | 0 | 0 | 151 | 0 | 0 | 0 | 0 | 74 | 77 | 151 | 18 | 151 | ||||||||||||||||||||||||||||||||||||
2779099 | 2779099 | CT | school | 900208 | 2850013 | Achievement First Bridgeport Academy District | 90020801493 | 2850113 | Achievement First Bridgeport Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | 13 | 596 | 487 | * | 6 | * | * | 524 | 586 | 148 | 112 | 1110 | 13 | 596 | 487 | 6 | 524 | 586 | 148 | 112 | 1110 | ||||||||||||||||||||||||||||||||
2451970 | 2451970 | CT | school | 901260 | 430011 | East Hartford School District | 90126000200 | 436211 | East Hartford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 230 | 624 | 782 | * | 101 | * | 34 | 948 | 829 | 147 | 311 | 1777 | 230 | 624 | 782 | 101 | 34 | 948 | 829 | 147 | 311 | 1777 | |||||||||||||||||||||||||||||||
2757962 | 2757962 | CT | school | 902670 | 890011 | New Britain School District | 90267000523 | 891211 | Smalley Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 61 | 44 | 457 | 0 | * | 0 | * | 310 | 281 | 147 | 120 | 591 | 61 | 44 | 457 | 0 | 0 | 310 | 281 | 147 | 120 | 591 | |||||||||||||||||||||||||||||||
2758056 | 2758056 | CT | school | 902820 | 950011 | New London School District | 90282000596 | 955111 | Bennie Dover Jackson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 26 | 55 | 230 | * | * | 0 | 21 | 176 | 161 | 145 | 62 | 337 | 26 | 55 | 230 | 0 | 21 | 176 | 161 | 145 | 62 | 337 | |||||||||||||||||||||||||||||||
2757736 | 2757736 | CT | school | 901920 | 640011 | Hartford School District | 90192000636 | 643211 | Expeditionary Learning Academy at Moylan School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 9 | 34 | 360 | * | 6 | * | * | 212 | 204 | 144 | 87 | 416 | 9 | 34 | 360 | 6 | 212 | 204 | 144 | 87 | 416 | ||||||||||||||||||||||||||||||||
2757498 | 2757498 | CT | school | 901020 | 340011 | Danbury School District | 90102000153 | 341311 | King Street Primary School | Public Schools | Regular School | No | Elementary | KG | 03 | 2021 | pk_12_total | 125 | 17 | 222 | 0 | 15 | 0 | 9 | 237 | 151 | 142 | 38 | 388 | 125 | 17 | 222 | 0 | 15 | 0 | 9 | 237 | 151 | 142 | 38 | 388 | |||||||||||||||||||||||||||||
2758343 | 2758343 | CT | school | 904320 | 1350011 | Stamford School District | 90432000008 | 1351911 | Toquam Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 88 | 61 | 394 | * | 34 | * | 24 | 335 | 269 | 142 | 70 | 604 | 88 | 61 | 394 | 34 | 24 | 335 | 269 | 142 | 70 | 604 | |||||||||||||||||||||||||||||||
2779021 | 2779021 | CT | school | 904950 | 1560011 | West Haven School District | 90495001041 | 1566111 | West Haven High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 452 | 367 | 592 | * | 69 | 0 | * | 775 | 760 | 142 | 198 | 1535 | 452 | 367 | 592 | 69 | 0 | 775 | 760 | 142 | 198 | 1535 | |||||||||||||||||||||||||||||||
2778546 | 2778546 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000648 | 1030711 | Jefferson Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 32 | 67 | 331 | * | 53 | 0 | * | 293 | 211 | 140 | 55 | 504 | 32 | 67 | 331 | 53 | 0 | 293 | 211 | 140 | 55 | 504 | |||||||||||||||||||||||||||||||
2778797 | 2778797 | CT | school | 904320 | 1350011 | Stamford School District | 90432000870 | 1355511 | Turn of River School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 203 | 85 | 305 | 0 | 61 | * | * | 374 | 311 | 140 | 98 | 685 | 203 | 85 | 305 | 0 | 61 | 374 | 311 | 140 | 98 | 685 | |||||||||||||||||||||||||||||||
2778202 | 2778202 | CT | school | 901920 | 640011 | Hartford School District | 90192000372 | 641411 | Naylor/CCSU Leadership Academy | Public Schools | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 56 | 48 | 298 | * | 15 | * | * | 222 | 201 | 139 | 96 | 423 | 56 | 48 | 298 | 15 | 222 | 201 | 139 | 96 | 423 | ||||||||||||||||||||||||||||||||
2452432 | 2452432 | CT | school | 902790 | 930011 | New Haven School District | 90279001443 | 931311 | John C. Daniels | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 58 | 70 | 395 | 0 | 10 | 0 | 7 | 281 | 259 | 138 | 52 | 540 | 58 | 70 | 395 | 0 | 10 | 0 | 7 | 281 | 259 | 138 | 52 | 540 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2757743 | 2757743 | CT | school | 901920 | 640011 | Hartford School District | 90192000372 | 641411 | Naylor/CCSU Leadership Academy | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 42 | 47 | 275 | * | 19 | * | * | 194 | 194 | 138 | 88 | 388 | 42 | 47 | 275 | 19 | 194 | 194 | 138 | 88 | 388 | ||||||||||||||||||||||||||||||||
2757876 | 2757876 | CT | school | 902400 | 800011 | Meriden School District | 90240000449 | 806211 | Orville H. Platt High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 216 | 140 | 606 | * | * | 0 | 24 | 494 | 514 | 138 | 177 | 1008 | 216 | 140 | 606 | 0 | 24 | 494 | 514 | 138 | 177 | 1008 | |||||||||||||||||||||||||||||||
2758494 | 2758494 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000983 | 1515111 | Michael F. Wallace Middle School | Public Schools | Regular School | No | Middle | 04 | 08 | 2021 | pk_12_total | 128 | 284 | 683 | 11 | 19 | 0 | 45 | 602 | 568 | 136 | 205 | 1170 | 128 | 284 | 683 | 11 | 19 | 0 | 45 | 602 | 568 | 136 | 205 | 1170 | |||||||||||||||||||||||||||||
2777810 | 2777810 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000081 | 152611 | Roosevelt School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 56 | 168 | 305 | * | 14 | * | * | 258 | 291 | 136 | 98 | 549 | 56 | 168 | 305 | 14 | 258 | 291 | 136 | 98 | 549 | ||||||||||||||||||||||||||||||||
2778310 | 2778310 | CT | school | 902400 | 800011 | Meriden School District | 90240000440 | 801111 | Casimir Pulaski School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 109 | 59 | 403 | * | * | 0 | 29 | 314 | 296 | 136 | 90 | 610 | 109 | 59 | 403 | 0 | 29 | 314 | 296 | 136 | 90 | 610 | |||||||||||||||||||||||||||||||
2757868 | 2757868 | CT | school | 902400 | 800011 | Meriden School District | 90240000447 | 805211 | Lincoln Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 200 | 83 | 499 | * | * | 0 | 24 | 412 | 410 | 135 | 144 | 822 | 200 | 83 | 499 | 0 | 24 | 412 | 410 | 135 | 144 | 822 | |||||||||||||||||||||||||||||||
2452528 | 2452528 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000648 | 1030711 | Jefferson Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 46 | 77 | 319 | * | 55 | * | 16 | 302 | 213 | 134 | 55 | 515 | 46 | 77 | 319 | 55 | 16 | 302 | 213 | 134 | 55 | 515 |
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]);