enrollments
Data source: Big Local News · About: Big Local
4,354 rows where grade = "pk_12_total" and state = "CT" sorted by ccd_school_lvl 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2451954 | 2451954 | CT | school | 901230 | 420011 | East Hampton School District | 90123000188 | 425111 | East Hampton Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 415 | * | 28 | 0 | * | * | 10 | 233 | 232 | * | 58 | 465 | 415 | 28 | 0 | 10 | 233 | 232 | 58 | 465 | |||||||||||||||||||||||||||||||||
2451967 | 2451967 | CT | school | 901260 | 430011 | East Hartford School District | 90126000197 | 435111 | East Hartford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 107 | 321 | 519 | * | 42 | * | 60 | 537 | 514 | 120 | 203 | 1051 | 107 | 321 | 519 | 42 | 60 | 537 | 514 | 120 | 203 | 1051 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451978 | 2451978 | CT | school | 901290 | 440011 | East Haven School District | 90129000217 | 445111 | Joseph Melillo Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 285 | 36 | 166 | * | 18 | 0 | * | 241 | 270 | 41 | 81 | 511 | 285 | 36 | 166 | 18 | 0 | 241 | 270 | 41 | 81 | 511 | |||||||||||||||||||||||||||||||
2451984 | 2451984 | CT | school | 901320 | 450011 | East Lyme School District | 90132000224 | 455111 | East Lyme Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 617 | * | 62 | * | 75 | 0 | 38 | 412 | 391 | 6 | 110 | 803 | 617 | 62 | 75 | 0 | 38 | 412 | 391 | 6 | 110 | 803 | |||||||||||||||||||||||||||||||
2451989 | 2451989 | CT | school | 901350 | 470011 | East Windsor School District | 90135000230 | 475411 | East Windsor Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 180 | 42 | 77 | * | 11 | 0 | * | 162 | 157 | 9 | 63 | 319 | 180 | 42 | 77 | 11 | 0 | 162 | 157 | 9 | 63 | 319 | |||||||||||||||||||||||||||||||
2451998 | 2451998 | CT | school | 901410 | 460011 | Easton School District | 90141000233 | 465111 | Helen Keller Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 281 | * | 21 | * | 18 | 0 | 9 | 156 | 176 | 0 | 40 | 332 | 281 | 21 | 18 | 0 | 9 | 156 | 176 | 0 | 40 | 332 | |||||||||||||||||||||||||||||||
2452008 | 2452008 | CT | school | 901440 | 480011 | Ellington School District | 90144000238 | 485111 | Ellington Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 352 | 20 | * | * | 43 | 0 | 13 | 225 | 213 | * | 56 | 438 | 352 | 20 | 43 | 0 | 13 | 225 | 213 | 56 | 438 | ||||||||||||||||||||||||||||||||
2452029 | 2452029 | CT | school | 901470 | 490011 | Enfield School District | 90147000249 | 495211 | John F. Kennedy Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 791 | 68 | 194 | * | 40 | * | 50 | 598 | 551 | 18 | 167 | 1149 | 791 | 68 | 194 | 40 | 50 | 598 | 551 | 18 | 167 | 1149 | |||||||||||||||||||||||||||||||
2452047 | 2452047 | CT | school | 901530 | 510011 | Fairfield School District | 90153000258 | 515211 | Fairfield Woods Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 697 | 24 | 96 | 0 | 62 | 0 | 31 | 457 | 453 | 10 | 115 | 910 | 697 | 24 | 96 | 0 | 62 | 0 | 31 | 457 | 453 | 10 | 115 | 910 | |||||||||||||||||||||||||||||
2452048 | 2452048 | CT | school | 901530 | 510011 | Fairfield School District | 90153000919 | 515311 | Roger Ludlowe Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 711 | 7 | 55 | 0 | 32 | 0 | 25 | 442 | 388 | * | 99 | 830 | 711 | 7 | 55 | 0 | 32 | 0 | 25 | 442 | 388 | 99 | 830 | ||||||||||||||||||||||||||||||
2452049 | 2452049 | CT | school | 901530 | 510011 | Fairfield School District | 90153000271 | 515111 | Tomlinson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 449 | * | 113 | * | 53 | 0 | 33 | 339 | 323 | 27 | 88 | 662 | 449 | 113 | 53 | 0 | 33 | 339 | 323 | 27 | 88 | 662 | |||||||||||||||||||||||||||||||
2452059 | 2452059 | CT | school | 901560 | 520011 | Farmington School District | 90156001368 | 520511 | West Woods Upper Elementary School | Public Schools | Regular School | No | Middle | 04 | 06 | 2019 | pk_12_total | 373 | 41 | 58 | * | 166 | 0 | * | 346 | 315 | 19 | 81 | 661 | 373 | 41 | 58 | 166 | 0 | 346 | 315 | 19 | 81 | 661 | |||||||||||||||||||||||||||||||
2452060 | 2452060 | CT | school | 901560 | 520011 | Farmington School District | 90156000274 | 525111 | Irving A. Robbins Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 405 | 27 | 54 | 0 | 156 | 0 | 13 | 333 | 322 | 8 | 78 | 655 | 405 | 27 | 54 | 0 | 156 | 0 | 13 | 333 | 322 | 8 | 78 | 655 | |||||||||||||||||||||||||||||
2452071 | 2452071 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000279 | 540811 | Gideon Welles School | Public Schools | Regular School | No | Middle | 06 | 06 | 2019 | pk_12_total | 316 | 13 | 54 | 0 | 54 | 0 | 31 | 223 | 245 | 6 | 44 | 468 | 316 | 13 | 54 | 0 | 54 | 0 | 31 | 223 | 245 | 6 | 44 | 468 | |||||||||||||||||||||||||||||
2452072 | 2452072 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000282 | 545211 | Smith Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 681 | * | 86 | * | 108 | 0 | 45 | * | 495 | * | 112 | 952 | 681 | 86 | 108 | 0 | 45 | 495 | 112 | 952 | |||||||||||||||||||||||||||||||||
2452077 | 2452077 | CT | school | 901680 | 560011 | Granby School District | 90168000291 | 565111 | Granby Memorial Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 354 | 18 | 15 | * | * | 0 | 15 | 196 | 211 | 0 | 66 | 407 | 354 | 18 | 15 | 0 | 15 | 196 | 211 | 0 | 66 | 407 | |||||||||||||||||||||||||||||||
2452090 | 2452090 | CT | school | 901710 | 570011 | Greenwich School District | 90171000295 | 575111 | Central Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 376 | 14 | 122 | 0 | 39 | 0 | 32 | 296 | 287 | 25 | 72 | 583 | 376 | 14 | 122 | 0 | 39 | 0 | 32 | 296 | 287 | 25 | 72 | 583 | |||||||||||||||||||||||||||||
2452091 | 2452091 | CT | school | 901710 | 570011 | Greenwich School District | 90171000298 | 575211 | Eastern Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 613 | 11 | 103 | 0 | 86 | 0 | 32 | 417 | 428 | 8 | 110 | 845 | 613 | 11 | 103 | 0 | 86 | 0 | 32 | 417 | 428 | 8 | 110 | 845 | |||||||||||||||||||||||||||||
2452092 | 2452092 | CT | school | 901710 | 570011 | Greenwich School District | 90171000309 | 575311 | Western Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 280 | 38 | 249 | * | 46 | 0 | * | 323 | 315 | 34 | 93 | 638 | 280 | 38 | 249 | 46 | 0 | 323 | 315 | 34 | 93 | 638 | |||||||||||||||||||||||||||||||
2452097 | 2452097 | CT | school | 901740 | 580011 | Griswold School District | 90174000019 | 585111 | Griswold Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 427 | 17 | 42 | * | * | 0 | 39 | 279 | 257 | * | 89 | 536 | 427 | 17 | 42 | 0 | 39 | 279 | 257 | 89 | 536 | ||||||||||||||||||||||||||||||||
2452106 | 2452106 | CT | school | 901770 | 590011 | Groton School District | 90177000312 | 595311 | Carl C. Cutler Middle School | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 310 | 22 | 85 | * | 26 | * | 44 | * | 266 | 6 | 80 | 494 | 310 | 22 | 85 | 26 | 44 | 266 | 6 | 80 | 494 | |||||||||||||||||||||||||||||||||
2452107 | 2452107 | CT | school | 901770 | 590011 | Groton School District | 90177000326 | 595211 | West Side Middle School | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 211 | 48 | 139 | * | 22 | * | 52 | 264 | 212 | 19 | 94 | 476 | 211 | 48 | 139 | 22 | 52 | 264 | 212 | 19 | 94 | 476 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2452117 | 2452117 | CT | school | 901800 | 600011 | Guilford School District | 90180000331 | 605111 | E. C. Adams Middle School | Public Schools | Regular School | No | Middle | 07 | 09 | 2019 | pk_12_total | 473 | * | 47 | * | 27 | * | 24 | 303 | 276 | * | 62 | 579 | 473 | 47 | 27 | 24 | 303 | 276 | 62 | 579 | |||||||||||||||||||||||||||||||||
2452135 | 2452135 | CT | school | 901860 | 620011 | Hamden School District | 90186000342 | 625211 | Hamden Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 323 | 292 | 181 | 0 | 54 | 0 | 50 | 482 | 418 | 30 | 167 | 900 | 323 | 292 | 181 | 0 | 54 | 0 | 50 | 482 | 418 | 30 | 167 | 900 | |||||||||||||||||||||||||||||
2452182 | 2452182 | CT | school | 901920 | 640011 | Hartford School District | 90192001582 | 644011 | Renzulli Gifted and Talented Academy | Public Schools | Regular School | No | Middle | 04 | 08 | 2019 | pk_12_total | 9 | 53 | 49 | * | * | 0 | 6 | 64 | 59 | * | * | 123 | 9 | 53 | 49 | 0 | 6 | 64 | 59 | 123 | |||||||||||||||||||||||||||||||||
2452183 | 2452183 | CT | school | 901920 | 640011 | Hartford School District | 90192001616 | 643811 | Betances STEM Magnet School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 46 | 78 | 151 | 0 | 23 | * | * | 190 | * | 37 | 47 | 308 | 46 | 78 | 151 | 0 | 23 | 190 | 37 | 47 | 308 | ||||||||||||||||||||||||||||||||
2452186 | 2452186 | CT | school | 901920 | 640011 | Hartford School District | 90192000369 | 641611 | M. L. King, Jr. Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | * | 133 | 43 | 0 | * | 0 | * | 101 | 81 | 18 | 45 | 182 | 133 | 43 | 0 | 0 | 101 | 81 | 18 | 45 | 182 | ||||||||||||||||||||||||||||||||
2452187 | 2452187 | CT | school | 901920 | 640011 | Hartford School District | 90192000371 | 641211 | McDonough Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | * | 35 | 249 | 0 | * | 0 | 0 | 162 | 132 | 92 | 69 | 294 | 35 | 249 | 0 | 0 | 0 | 162 | 132 | 92 | 69 | 294 | |||||||||||||||||||||||||||||||
2452218 | 2452218 | CT | school | 902070 | 690011 | Killingly School District | 90207000393 | 695211 | Killingly Intermediate School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 515 | 15 | 60 | * | 24 | * | 31 | 315 | 333 | 9 | 87 | 648 | 515 | 15 | 60 | 24 | 31 | 315 | 333 | 9 | 87 | 648 | |||||||||||||||||||||||||||||||
2452228 | 2452228 | CT | school | 903450 | 2450014 | Learn | 90345001556 | 2455014 | Dual Language & Arts Magnet Middle School | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 42 | 16 | 65 | 0 | * | * | 21 | 65 | 81 | 17 | 28 | 146 | 42 | 16 | 65 | 0 | 21 | 65 | 81 | 17 | 28 | 146 | ||||||||||||||||||||||||||||||||
2452237 | 2452237 | CT | school | 902130 | 710011 | Lebanon School District | 90213000028 | 715111 | Lebanon Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 257 | * | 20 | * | 7 | * | * | 148 | 151 | * | 50 | 299 | 257 | 20 | 7 | 148 | 151 | 50 | 299 | ||||||||||||||||||||||||||||||||||
2452243 | 2452243 | CT | school | 902160 | 720011 | Ledyard School District | 90216000402 | 725111 | Ledyard Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 257 | 24 | 53 | 18 | * | * | 19 | 206 | 176 | 6 | 75 | 382 | 257 | 24 | 53 | 18 | 19 | 206 | 176 | 6 | 75 | 382 | |||||||||||||||||||||||||||||||
2452248 | 2452248 | CT | school | 902220 | 740011 | Litchfield School District | 90222000407 | 740311 | Litchfield Intermediate School | Public Schools | Regular School | No | Middle | 04 | 06 | 2019 | pk_12_total | 172 | 0 | 10 | 0 | * | 0 | * | 97 | 93 | * | 32 | 190 | 172 | 0 | 10 | 0 | 0 | 97 | 93 | 32 | 190 | ||||||||||||||||||||||||||||||||
2452249 | 2452249 | CT | school | 902220 | 740011 | Litchfield School District | 90222001809 | 746011 | Litchfield Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 122 | 0 | 6 | 0 | * | * | * | 82 | 56 | 0 | 25 | 138 | 122 | 0 | 6 | 0 | 82 | 56 | 0 | 25 | 138 | ||||||||||||||||||||||||||||||||
2452255 | 2452255 | CT | school | 902280 | 760011 | Madison School District | 90228001382 | 760611 | Dr. Robert H. Brown Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 321 | * | 17 | * | 15 | * | 22 | 193 | 187 | * | 54 | 380 | 321 | 17 | 15 | 22 | 193 | 187 | 54 | 380 | |||||||||||||||||||||||||||||||||
2452256 | 2452256 | CT | school | 902280 | 760011 | Madison School District | 90228001480 | 765211 | Walter C. Polson Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 364 | * | 24 | 0 | * | 0 | 21 | 236 | * | * | 64 | 423 | 364 | 24 | 0 | 0 | 21 | 236 | 64 | 423 | |||||||||||||||||||||||||||||||||
2452269 | 2452269 | CT | school | 902310 | 770011 | Manchester School District | 90231001533 | 771711 | Elisabeth M. Bennet Academy | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 289 | 233 | 296 | * | 75 | * | 27 | 467 | 455 | 58 | 136 | 922 | 289 | 233 | 296 | 75 | 27 | 467 | 455 | 58 | 136 | 922 | |||||||||||||||||||||||||||||||
2452271 | 2452271 | CT | school | 902310 | 770011 | Manchester School District | 90231000421 | 775311 | Illing Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 285 | 181 | 243 | 6 | 52 | 0 | 36 | 423 | 380 | 40 | 122 | 803 | 285 | 181 | 243 | 6 | 52 | 0 | 36 | 423 | 380 | 40 | 122 | 803 | |||||||||||||||||||||||||||||
2452280 | 2452280 | CT | school | 902340 | 780011 | Mansfield School District | 90234000433 | 785111 | Mansfield Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 383 | * | 70 | * | 63 | 0 | 24 | 267 | 286 | 11 | 63 | 553 | 383 | 70 | 63 | 0 | 24 | 267 | 286 | 11 | 63 | 553 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452325 | 2452325 | CT | school | 902490 | 830011 | Middletown School District | 90249000456 | 831511 | Keigwin Middle School | Public Schools | Regular School | No | Middle | 06 | 06 | 2019 | pk_12_total | 139 | 75 | 69 | * | * | 0 | 24 | 166 | 157 | 13 | 47 | 323 | 139 | 75 | 69 | 0 | 24 | 166 | 157 | 13 | 47 | 323 | |||||||||||||||||||||||||||||||
2452326 | 2452326 | CT | school | 902490 | 830011 | Middletown School District | 90249000459 | 835411 | Woodrow Wilson Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 285 | 134 | 127 | 0 | * | * | 45 | 289 | 321 | 13 | 81 | 610 | 285 | 134 | 127 | 0 | 45 | 289 | 321 | 13 | 81 | 610 | |||||||||||||||||||||||||||||||
2452342 | 2452342 | CT | school | 902520 | 840011 | Milford School District | 90252000484 | 845111 | East Shore Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 310 | * | 30 | 0 | 27 | 0 | * | 179 | 216 | * | 57 | 395 | 310 | 30 | 0 | 27 | 0 | 179 | 216 | 57 | 395 | ||||||||||||||||||||||||||||||||
2452343 | 2452343 | CT | school | 902520 | 840011 | Milford School District | 90252000468 | 845211 | Harborside Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 332 | 10 | 59 | * | 53 | 0 | * | 256 | 204 | 9 | 66 | 460 | 332 | 10 | 59 | 53 | 0 | 256 | 204 | 9 | 66 | 460 | |||||||||||||||||||||||||||||||
2452344 | 2452344 | CT | school | 902520 | 840011 | Milford School District | 90252000474 | 845311 | West Shore Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 314 | 33 | 65 | * | 44 | * | * | 237 | 225 | 9 | 61 | 462 | 314 | 33 | 65 | 44 | 237 | 225 | 9 | 61 | 462 | ||||||||||||||||||||||||||||||||
2452353 | 2452353 | CT | school | 902550 | 850011 | Monroe School District | 90255000920 | 855211 | Jockey Hollow School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 627 | * | 58 | * | 39 | 0 | 18 | 361 | 395 | * | 101 | 756 | 627 | 58 | 39 | 0 | 18 | 361 | 395 | 101 | 756 | ||||||||||||||||||||||||||||||||
2452360 | 2452360 | CT | school | 902580 | 860011 | Montville School District | 90258000035 | 865111 | Leonard J. Tyl Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 333 | * | 52 | 9 | 34 | * | 64 | 244 | 256 | 8 | 84 | 500 | 333 | 52 | 9 | 34 | 64 | 244 | 256 | 8 | 84 | 500 | |||||||||||||||||||||||||||||||
2452371 | 2452371 | CT | school | 902640 | 880011 | Naugatuck School District | 90264000502 | 880211 | Cross Street Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 204 | 26 | 62 | * | * | 0 | 12 | 159 | 157 | 13 | 51 | 316 | 204 | 26 | 62 | 0 | 12 | 159 | 157 | 13 | 51 | 316 | |||||||||||||||||||||||||||||||
2452372 | 2452372 | CT | school | 902640 | 880011 | Naugatuck School District | 90264000504 | 880411 | Hillside Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 171 | 22 | 112 | * | 6 | * | 15 | 176 | 155 | 25 | 66 | 331 | 171 | 22 | 112 | 6 | 15 | 176 | 155 | 25 | 66 | 331 | |||||||||||||||||||||||||||||||
2452373 | 2452373 | CT | school | 902640 | 880011 | Naugatuck School District | 90264000501 | 885111 | City Hill Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 385 | 55 | 174 | * | * | 0 | 30 | 350 | 318 | 30 | 110 | 668 | 385 | 55 | 174 | 0 | 30 | 350 | 318 | 30 | 110 | 668 | |||||||||||||||||||||||||||||||
2452394 | 2452394 | CT | school | 902670 | 890011 | New Britain School District | 90267001445 | 895411 | House of Arts Letters and Science (HALS) Academy | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 61 | 15 | 58 | 0 | * | 0 | * | 68 | 80 | 0 | * | 148 | 61 | 15 | 58 | 0 | 0 | 68 | 80 | 0 | 148 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452397 | 2452397 | CT | school | 902670 | 890011 | New Britain School District | 90267000522 | 895211 | Slade Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 128 | 118 | 584 | * | * | 0 | 24 | 482 | 384 | 124 | 180 | 866 | 128 | 118 | 584 | 0 | 24 | 482 | 384 | 124 | 180 | 866 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452410 | 2452410 | CT | school | 902730 | 910011 | New Fairfield School District | 90273001224 | 915211 | New Fairfield Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 423 | 11 | 57 | * | * | 0 | 11 | 270 | 242 | 6 | 60 | 512 | 423 | 11 | 57 | 0 | 11 | 270 | 242 | 6 | 60 | 512 | |||||||||||||||||||||||||||||||
2452461 | 2452461 | CT | school | 902790 | 930011 | New Haven School District | 90279000545 | 935511 | Betsy Ross Arts Magnet School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 90 | 187 | 157 | * | 7 | 0 | * | 147 | 301 | 30 | 45 | 448 | 90 | 187 | 157 | 7 | 0 | 147 | 301 | 30 | 45 | 448 | |||||||||||||||||||||||||||||||
2452481 | 2452481 | CT | school | 902820 | 950011 | New London School District | 90282000596 | 955111 | Bennie Dover Jackson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 19 | 45 | 192 | * | * | 0 | 17 | 155 | 122 | 104 | 57 | 277 | 19 | 45 | 192 | 0 | 17 | 155 | 122 | 104 | 57 | 277 | |||||||||||||||||||||||||||||||
2452482 | 2452482 | CT | school | 902820 | 950011 | New London School District | 90282001919 | 951411 | New London Visual and Performing Arts Magnet School | Public Schools | Regular School | No | Middle | 06 | 09 | 2019 | pk_12_total | 55 | 38 | 87 | * | * | 0 | 21 | 92 | 112 | 25 | 46 | 204 | 55 | 38 | 87 | 0 | 21 | 92 | 112 | 25 | 46 | 204 | |||||||||||||||||||||||||||||||
2452488 | 2452488 | CT | school | 902850 | 960011 | New Milford School District | 90285000603 | 965211 | Schaghticoke Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 729 | * | 153 | * | 40 | 0 | 44 | 537 | * | 29 | 150 | 991 | 729 | 153 | 40 | 0 | 44 | 537 | 29 | 150 | 991 | ||||||||||||||||||||||||||||||||
2452495 | 2452495 | CT | school | 902880 | 940011 | Newington School District | 90288001120 | 945311 | John Wallace Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 415 | 41 | 128 | 0 | 52 | 0 | 35 | 334 | 337 | 21 | 82 | 671 | 415 | 41 | 128 | 0 | 52 | 0 | 35 | 334 | 337 | 21 | 82 | 671 | |||||||||||||||||||||||||||||
2452496 | 2452496 | CT | school | 902880 | 940011 | Newington School District | 90288000608 | 945111 | Martin Kellogg Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 360 | 39 | 152 | * | 63 | 0 | * | 319 | 327 | 26 | 88 | 646 | 360 | 39 | 152 | 63 | 0 | 319 | 327 | 26 | 88 | 646 | |||||||||||||||||||||||||||||||
2452503 | 2452503 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 527 | 11 | 44 | 0 | 26 | 0 | 16 | 299 | 325 | * | 95 | 624 | 527 | 11 | 44 | 0 | 26 | 0 | 16 | 299 | 325 | 95 | 624 | ||||||||||||||||||||||||||||||
2452504 | 2452504 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 579 | 16 | 49 | 0 | 22 | 0 | 15 | 337 | 344 | 0 | 88 | 681 | 579 | 16 | 49 | 0 | 22 | 0 | 15 | 337 | 344 | 0 | 88 | 681 | |||||||||||||||||||||||||||||
2452510 | 2452510 | CT | school | 902970 | 990011 | North Branford School District | 90297000622 | 995111 | North Branford Intermediate School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 355 | 15 | 31 | 0 | 14 | 0 | 0 | 226 | 189 | * | 58 | 415 | 355 | 15 | 31 | 0 | 14 | 0 | 0 | 226 | 189 | 58 | 415 | ||||||||||||||||||||||||||||||
2452518 | 2452518 | CT | school | 903030 | 1010011 | North Haven School District | 90303000632 | 1015211 | North Haven Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 570 | 25 | 61 | * | 55 | 0 | * | 380 | 351 | 10 | 94 | 731 | 570 | 25 | 61 | 55 | 0 | 380 | 351 | 10 | 94 | 731 | |||||||||||||||||||||||||||||||
2452536 | 2452536 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000653 | 1035211 | Nathan Hale Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 216 | 103 | 286 | 0 | 28 | 0 | 15 | 331 | 317 | 58 | 107 | 648 | 216 | 103 | 286 | 0 | 28 | 0 | 15 | 331 | 317 | 58 | 107 | 648 | |||||||||||||||||||||||||||||
2452537 | 2452537 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000656 | 1035311 | Ponus Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 103 | 107 | 421 | * | 34 | 0 | * | 330 | 352 | 121 | 94 | 682 | 103 | 107 | 421 | 34 | 0 | 330 | 352 | 121 | 94 | 682 | |||||||||||||||||||||||||||||||
2452538 | 2452538 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000657 | 1035511 | Roton Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 186 | 74 | 261 | 0 | 17 | 0 | 11 | 296 | 253 | 66 | 76 | 549 | 186 | 74 | 261 | 0 | 17 | 0 | 11 | 296 | 253 | 66 | 76 | 549 | |||||||||||||||||||||||||||||
2452539 | 2452539 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000661 | 1035411 | West Rocks Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 166 | 135 | 338 | * | 26 | 0 | * | 349 | 326 | 93 | 110 | 675 | 166 | 135 | 338 | 26 | 0 | 349 | 326 | 93 | 110 | 675 | |||||||||||||||||||||||||||||||
2452557 | 2452557 | CT | school | 903120 | 1040011 | Norwich School District | 90312000670 | 1045111 | Kelly STEAM Magnet Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 182 | 109 | 226 | 0 | * | * | 70 | 316 | 315 | 84 | 78 | 631 | 182 | 109 | 226 | 0 | 70 | 316 | 315 | 84 | 78 | 631 | |||||||||||||||||||||||||||||||
2452559 | 2452559 | CT | school | 903120 | 1040011 | Norwich School District | 90312000674 | 1045211 | Teachers' Memorial Global Studies Magnet Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 102 | 77 | 137 | * | 26 | * | 40 | 191 | 194 | 54 | 99 | 385 | 102 | 77 | 137 | 26 | 40 | 191 | 194 | 54 | 99 | 385 | |||||||||||||||||||||||||||||||
2452563 | 2452563 | CT | school | 903180 | 1060011 | Old Saybrook School District | 90318000007 | 1065211 | Old Saybrook Middle School | Public Schools | Regular School | No | Middle | 04 | 08 | 2019 | pk_12_total | 383 | 0 | 48 | 0 | 15 | * | * | 226 | 232 | 22 | 65 | 458 | 383 | 0 | 48 | 0 | 15 | 226 | 232 | 22 | 65 | 458 | |||||||||||||||||||||||||||||||
2452571 | 2452571 | CT | school | 903240 | 1080011 | Oxford School District | 90324000690 | 1085111 | Oxford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 428 | * | 33 | * | 11 | 0 | * | 233 | 250 | * | 58 | 483 | 428 | 33 | 11 | 0 | 233 | 250 | 58 | 483 | |||||||||||||||||||||||||||||||||
2452578 | 2452578 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000693 | 1095111 | Plainfield Central School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 442 | 32 | 21 | 7 | * | * | * | 249 | 262 | 6 | 79 | 511 | 442 | 32 | 21 | 7 | 249 | 262 | 6 | 79 | 511 | ||||||||||||||||||||||||||||||||
2452583 | 2452583 | CT | school | 903300 | 1100011 | Plainville School District | 90330000048 | 1105211 | Middle School of Plainville | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 358 | * | 103 | * | 19 | 0 | 23 | 269 | 254 | 21 | 71 | 523 | 358 | 103 | 19 | 0 | 23 | 269 | 254 | 21 | 71 | 523 | |||||||||||||||||||||||||||||||
2452588 | 2452588 | CT | school | 903330 | 1110011 | Plymouth School District | 90333000705 | 1115111 | Eli Terry Jr. Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 308 | * | 24 | * | 10 | 0 | 6 | 199 | 155 | 7 | 64 | 354 | 308 | 24 | 10 | 0 | 6 | 199 | 155 | 7 | 64 | 354 | |||||||||||||||||||||||||||||||
2452593 | 2452593 | CT | school | 903390 | 1130011 | Portland School District | 90339001393 | 1130511 | Brownstone Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 162 | * | 27 | 0 | * | 0 | 14 | 107 | 107 | * | 24 | 214 | 162 | 27 | 0 | 0 | 14 | 107 | 107 | 24 | 214 | ||||||||||||||||||||||||||||||||
2452594 | 2452594 | CT | school | 903390 | 1130011 | Portland School District | 90339000713 | 1135111 | Portland Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 157 | * | 27 | 0 | * | 0 | 12 | 105 | 100 | * | 23 | 205 | 157 | 27 | 0 | 0 | 12 | 105 | 100 | 23 | 205 | ||||||||||||||||||||||||||||||||
2452597 | 2452597 | CT | school | 903420 | 1140011 | Preston School District | 90342000717 | 1145111 | Preston Plains School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 113 | * | 11 | * | * | 0 | 8 | 66 | 79 | * | 24 | 145 | 113 | 11 | 0 | 8 | 66 | 79 | 24 | 145 | |||||||||||||||||||||||||||||||||
2452599 | 2452599 | CT | school | 903480 | 1160011 | Putnam School District | 90348000720 | 1165111 | Putnam Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 232 | * | 28 | 0 | * | * | 9 | 150 | 128 | 7 | 53 | 278 | 232 | 28 | 0 | 9 | 150 | 128 | 7 | 53 | 278 | ||||||||||||||||||||||||||||||||
2452603 | 2452603 | CT | school | 903510 | 1170011 | Redding School District | 90351000721 | 1175111 | John Read Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 328 | * | 24 | 0 | * | 0 | 19 | 201 | 188 | * | 60 | 389 | 328 | 24 | 0 | 0 | 19 | 201 | 188 | 60 | 389 | ||||||||||||||||||||||||||||||||
2452614 | 2452614 | CT | school | 903520 | 2100012 | Regional School District 10 | 90352000727 | 2105112 | Har-Bur Middle School | Regional Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 693 | * | 15 | * | 17 | * | * | 387 | 347 | * | 88 | 734 | 693 | 15 | 17 | 387 | 347 | 88 | 734 | ||||||||||||||||||||||||||||||||||
2452623 | 2452623 | CT | school | 903535 | 2130012 | Regional School District 13 | 90353500742 | 2130412 | Middlefield Memorial School | Regional Schools | Regular School | No | Middle | 04 | 06 | 2019 | pk_12_total | 265 | * | 30 | 0 | * | 0 | 11 | 153 | 159 | * | 51 | 312 | 265 | 30 | 0 | 0 | 11 | 153 | 159 | 51 | 312 | ||||||||||||||||||||||||||||||||
2452624 | 2452624 | CT | school | 903535 | 2130012 | Regional School District 13 | 90353500739 | 2135112 | Frank Ward Strong School | Regional Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 234 | 0 | 15 | 0 | * | 0 | * | 126 | 139 | 0 | 50 | 265 | 234 | 0 | 15 | 0 | 0 | 126 | 139 | 0 | 50 | 265 | |||||||||||||||||||||||||||||||
2452629 | 2452629 | CT | school | 903536 | 2140012 | Regional School District 14 | 90353600746 | 2145112 | Woodbury Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 304 | * | 20 | * | 8 | 0 | * | 160 | 177 | * | 63 | 337 | 304 | 20 | 8 | 0 | 160 | 177 | 63 | 337 | |||||||||||||||||||||||||||||||||
2452636 | 2452636 | CT | school | 903537 | 2150012 | Regional School District 15 | 90353700748 | 2155212 | Memorial Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 382 | * | 16 | 0 | 20 | * | 9 | 212 | 226 | 0 | 76 | 438 | 382 | 16 | 0 | 20 | 9 | 212 | 226 | 0 | 76 | 438 | |||||||||||||||||||||||||||||||
2452637 | 2452637 | CT | school | 903537 | 2150012 | Regional School District 15 | 90353700751 | 2155112 | Rochambeau Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 368 | * | 21 | * | 19 | 0 | 10 | 222 | 207 | * | 76 | 429 | 368 | 21 | 19 | 0 | 10 | 222 | 207 | 76 | 429 | ||||||||||||||||||||||||||||||||
2452642 | 2452642 | CT | school | 903538 | 2160012 | Regional School District 16 | 90353800756 | 2165112 | Long River Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 474 | 18 | 37 | * | 6 | 0 | * | 250 | 288 | 7 | 79 | 538 | 474 | 18 | 37 | 6 | 0 | 250 | 288 | 7 | 79 | 538 | |||||||||||||||||||||||||||||||
2452648 | 2452648 | CT | school | 903539 | 2170012 | Regional School District 17 | 90353901201 | 2175112 | Haddam-Killingworth Middle School | Regional Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 615 | * | 18 | 0 | * | 0 | 22 | 358 | 313 | * | 127 | 671 | 615 | 18 | 0 | 0 | 22 | 358 | 313 | 127 | 671 | ||||||||||||||||||||||||||||||||
2452654 | 2452654 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354001123 | 2185112 | Lyme-Old Lyme Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 244 | * | 15 | 0 | 10 | 0 | * | 131 | 147 | * | 39 | 278 | 244 | 15 | 0 | 10 | 0 | 131 | 147 | 39 | 278 | ||||||||||||||||||||||||||||||||
2452667 | 2452667 | CT | school | 903810 | 1180011 | Ridgefield School District | 90381000776 | 1185111 | East Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 535 | 0 | 41 | 0 | 38 | 0 | 27 | 329 | 312 | * | 71 | 641 | 535 | 0 | 41 | 0 | 38 | 0 | 27 | 329 | 312 | 71 | 641 | ||||||||||||||||||||||||||||||
2452668 | 2452668 | CT | school | 903810 | 1180011 | Ridgefield School District | 90381001361 | 1185211 | Scotts Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 441 | 7 | 38 | 0 | 46 | 0 | 20 | 285 | 267 | 0 | 87 | 552 | 441 | 7 | 38 | 0 | 46 | 0 | 20 | 285 | 267 | 0 | 87 | 552 | |||||||||||||||||||||||||||||
2452675 | 2452675 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000782 | 1195111 | Albert D. Griswold Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 359 | 21 | 76 | * | 147 | 0 | * | 312 | 310 | 21 | 72 | 622 | 359 | 21 | 76 | 147 | 0 | 312 | 310 | 21 | 72 | 622 | |||||||||||||||||||||||||||||||
2452683 | 2452683 | CT | school | 903990 | 1240011 | Seymour School District | 90399000794 | 1245111 | Seymour Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 373 | 25 | 99 | * | 19 | 0 | * | 264 | 260 | 7 | 77 | 524 | 373 | 25 | 99 | 19 | 0 | 264 | 260 | 7 | 77 | 524 | |||||||||||||||||||||||||||||||
2452695 | 2452695 | CT | school | 904050 | 1260011 | Shelton School District | 90405001584 | 1261111 | Perry Hill Elementary School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 496 | 44 | 112 | 0 | 49 | * | * | 392 | 337 | 31 | 108 | 729 | 496 | 44 | 112 | 0 | 49 | 392 | 337 | 31 | 108 | 729 | |||||||||||||||||||||||||||||||
2452696 | 2452696 | CT | school | 904050 | 1260011 | Shelton School District | 90405000801 | 1265111 | Intermediate School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 546 | 45 | 105 | * | 40 | * | 32 | 394 | 376 | 22 | 127 | 770 | 546 | 45 | 105 | 40 | 32 | 394 | 376 | 22 | 127 | 770 | |||||||||||||||||||||||||||||||
2452706 | 2452706 | CT | school | 904110 | 1280011 | Simsbury School District | 90411000811 | 1285111 | Henry James Memorial School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 452 | 34 | 54 | 0 | 50 | 0 | 16 | 313 | 293 | * | 82 | 606 | 452 | 34 | 54 | 0 | 50 | 0 | 16 | 313 | 293 | 82 | 606 |
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]);