enrollments
Data source: Big Local News · About: Big Local
1,449 rows where grade = "pk_12_total", state = "CT" and year = 2019 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2451740 | 2451740 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001565 | 110811 | Wintonbury Early Childhood Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 115 | 120 | 37 | * | 25 | 0 | * | 170 | 149 | 0 | 44 | 319 | 115 | 120 | 37 | 25 | 0 | 170 | 149 | 0 | 44 | 319 | |||||||||||||||||||||||||||||||
2451761 | 2451761 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000085 | 154411 | A.B. Skane Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 41 | 63 | 107 | 0 | * | 0 | * | 145 | 81 | 0 | 127 | 226 | 41 | 63 | 107 | 0 | 0 | 145 | 81 | 0 | 127 | 226 | |||||||||||||||||||||||||||||||
2451800 | 2451800 | CT | school | 900510 | 170011 | Bristol School District | 90051001774 | 170411 | Bristol Early Childhood Center-BECC | Public Schools | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 66 | * | 29 | 0 | * | 0 | 8 | 62 | 45 | 0 | 65 | 107 | 66 | 29 | 0 | 0 | 8 | 62 | 45 | 0 | 65 | 107 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451939 | 2451939 | CT | school | 901110 | 370011 | Derby School District | 90111001806 | 370111 | Little Raiders University | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 16 | 10 | 13 | 0 | 0 | * | * | 31 | 13 | 0 | 15 | 44 | 16 | 10 | 13 | 0 | 0 | 31 | 13 | 0 | 15 | 44 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2452013 | 2452013 | CT | school | 901470 | 490011 | Enfield School District | 90147001915 | 492211 | EPS Integrated Pre-Kindergarten | Program | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 62 | * | * | 0 | * | 0 | * | 48 | 26 | 0 | 46 | 74 | 62 | 0 | 0 | 48 | 26 | 0 | 46 | 74 | |||||||||||||||||||||||||||||||||
2452014 | 2452014 | CT | school | 901470 | 490011 | Enfield School District | 90147001810 | 491011 | EPS PK STEAM Academy | Program | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 31 | 17 | 14 | 0 | * | 0 | * | 39 | 29 | 0 | 10 | 68 | 31 | 17 | 14 | 0 | 0 | 39 | 29 | 0 | 10 | 68 | |||||||||||||||||||||||||||||||
2452149 | 2452149 | CT | school | 901920 | 640011 | Hartford School District | 90192001643 | 641311 | Hartford PreKindergarten Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 12 | 50 | 23 | * | 57 | 0 | * | 71 | 80 | 0 | 6 | 151 | 12 | 50 | 23 | 57 | 0 | 71 | 80 | 0 | 6 | 151 | |||||||||||||||||||||||||||||||
2452526 | 2452526 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001914 | 1030111 | Norwalk Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 74 | 14 | 54 | 0 | 15 | 0 | 6 | 100 | 63 | 0 | 104 | 163 | 74 | 14 | 54 | 0 | 15 | 0 | 6 | 100 | 63 | 0 | 104 | 163 | |||||||||||||||||||||||||||||
2452544 | 2452544 | CT | school | 903120 | 1040011 | Norwich School District | 90312000663 | 1040111 | Bishop School Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 61 | 33 | 54 | * | 15 | 0 | * | 90 | 85 | 0 | 74 | 175 | 61 | 33 | 54 | 15 | 0 | 90 | 85 | 0 | 74 | 175 | |||||||||||||||||||||||||||||||
2452651 | 2452651 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354000761 | 2180312 | Center School | Regional Schools | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 40 | * | * | 0 | 0 | 0 | * | 26 | 23 | 0 | 13 | 49 | 40 | 0 | 0 | 0 | 26 | 23 | 0 | 13 | 49 | ||||||||||||||||||||||||||||||||
2452722 | 2452722 | CT | school | 904230 | 1310011 | Southington School District | 90423001804 | 1312111 | Southington Public Schools Preschool Program | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | * | * | 0 | 0 | 0 | 0 | 0 | 9 | 10 | 0 | 11 | 19 | 0 | 0 | 0 | 0 | 0 | 9 | 10 | 0 | 11 | 19 | |||||||||||||||||||||||||||||||
2452723 | 2452723 | CT | school | 904230 | 1310011 | Southington School District | 90423001808 | 1312011 | Southington Public Schools Preschool Program at Hatton School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 56 | * | 7 | 0 | * | 0 | * | 52 | 18 | 0 | 46 | 70 | 56 | 7 | 0 | 0 | 52 | 18 | 0 | 46 | 70 | ||||||||||||||||||||||||||||||||
2452778 | 2452778 | CT | school | 904380 | 1370011 | Stonington School District | 90438001637 | 1370111 | Stonington BOE Pre-School | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 22 | 0 | * | 0 | * | 0 | 0 | 15 | 11 | 0 | 16 | 26 | 22 | 0 | 0 | 0 | 0 | 15 | 11 | 0 | 16 | 26 | ||||||||||||||||||||||||||||||||
2452779 | 2452779 | CT | school | 904380 | 1370011 | Stonington School District | 90438001635 | 1370211 | Stonington HS PreK | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 22 | 0 | * | 0 | 0 | 0 | * | 17 | 9 | 0 | 17 | 26 | 22 | 0 | 0 | 0 | 0 | 17 | 9 | 0 | 17 | 26 | ||||||||||||||||||||||||||||||||
2452144 | 2452144 | CT | school | 901920 | 640011 | Hartford School District | 90192001435 | 646911 | Capital Preparatory Magnet School | Public Schools | Regular School | No | Other | PK | 12 | 2019 | pk_12_total | 43 | 323 | 121 | 0 | 11 | 0 | 25 | 263 | 260 | 29 | 62 | 523 | 43 | 323 | 121 | 0 | 11 | 0 | 25 | 263 | 260 | 29 | 62 | 523 | |||||||||||||||||||||||||||||
2452151 | 2452151 | CT | school | 901920 | 640011 | Hartford School District | 90192000370 | 641111 | Kinsella Magnet School of Performing Arts | Public Schools | Regular School | No | Other | PK | 12 | 2019 | pk_12_total | 177 | 179 | 403 | * | * | 0 | 45 | 312 | 521 | 72 | 139 | 833 | 177 | 179 | 403 | 0 | 45 | 312 | 521 | 72 | 139 | 833 | |||||||||||||||||||||||||||||||
2452171 | 2452171 | CT | school | 901920 | 640011 | Hartford School District | 90192001535 | 643611 | Global Communications Academy | Public Schools | Regular School | No | Other | KG | 12 | 2019 | pk_12_total | * | 345 | 238 | 0 | * | 0 | 8 | 284 | 315 | 88 | 97 | 599 | 345 | 238 | 0 | 0 | 8 | 284 | 315 | 88 | 97 | 599 | |||||||||||||||||||||||||||||||
2452211 | 2452211 | CT | school | 900207 | 2860013 | Highville Charter School District | 90020700907 | 2860113 | Highville Charter School | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2019 | pk_12_total | * | 477 | 17 | 0 | 0 | 0 | * | 227 | 275 | 0 | 26 | 502 | 477 | 17 | 0 | 0 | 0 | 227 | 275 | 0 | 26 | 502 | |||||||||||||||||||||||||||||||
2452213 | 2452213 | CT | school | 900007 | 2610013 | Jumoke Academy District | 90000700747 | 2610113 | Jumoke Academy | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2019 | pk_12_total | * | 666 | 38 | 0 | * | 0 | * | 336 | 381 | 0 | 42 | 717 | 666 | 38 | 0 | 0 | 336 | 381 | 0 | 42 | 717 | ||||||||||||||||||||||||||||||||
2452744 | 2452744 | CT | school | 904260 | 1330011 | Sprague School District | 90426000842 | 1330111 | Sayles School | Public Schools | Regular School | No | Other | PK | 12 | 2019 | pk_12_total | 217 | 6 | 47 | * | * | * | 35 | 178 | 135 | * | 50 | 313 | 217 | 6 | 47 | 35 | 178 | 135 | 50 | 313 | |||||||||||||||||||||||||||||||||
2453070 | 2453070 | CT | school | 900208 | 2850013 | Achievement First Bridgeport Academy District | 90020801493 | 2850113 | Achievement First Bridgeport Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | 13 | 584 | 480 | * | 9 | * | * | 512 | 581 | 131 | 97 | 1093 | 13 | 584 | 480 | 9 | 512 | 581 | 131 | 97 | 1093 | ||||||||||||||||||||||||||||||||
2453071 | 2453071 | CT | school | 900212 | 2880013 | Achievement First Hartford Academy District | 90021201528 | 2880113 | Achievement First Hartford Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | * | 782 | 304 | * | * | * | 15 | 519 | 593 | 52 | 115 | 1112 | 782 | 304 | 15 | 519 | 593 | 52 | 115 | 1112 | |||||||||||||||||||||||||||||||||
2453072 | 2453072 | CT | school | 900024 | 2790013 | Amistad Academy District | 90002400981 | 2795113 | Amistad Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | 19 | 681 | 360 | * | * | 0 | 21 | 509 | 574 | 118 | 71 | 1083 | 19 | 681 | 360 | 0 | 21 | 509 | 574 | 118 | 71 | 1083 | |||||||||||||||||||||||||||||||
2453075 | 2453075 | CT | school | 900221 | 2970013 | Capital Preparatory Harbor School District | 90022101803 | 2970113 | Capital Preparatory Harbor School | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | * | 463 | 167 | * | 0 | 0 | * | 323 | 311 | * | 71 | 634 | 463 | 167 | 0 | 0 | 323 | 311 | 71 | 634 | |||||||||||||||||||||||||||||||||
2453080 | 2453080 | CT | school | 900214 | 2890013 | Elm City College Preparatory School District | 90021401548 | 2890113 | Elm City College Preparatory School | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | 15 | 529 | 197 | * | * | 0 | 12 | 371 | 385 | 41 | 60 | 756 | 15 | 529 | 197 | 0 | 12 | 371 | 385 | 41 | 60 | 756 | |||||||||||||||||||||||||||||||
2451929 | 2451929 | CT | school | 901020 | 340011 | Danbury School District | 90102001129 | 346211 | Alternative Center For Excellence | Program | Alternative School | No | Not reported | M | M | 2019 | pk_12_total | 30 | 10 | 44 | * | * | 0 | * | 49 | 42 | 6 | 16 | 91 | 30 | 10 | 44 | 0 | 49 | 42 | 6 | 16 | 91 | ||||||||||||||||||||||||||||||||
2451702 | 2451702 | CT | school | 900060 | 20011 | Ansonia School District | 90006010008 | 25111 | Ansonia Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 121 | 64 | 130 | 0 | * | * | 13 | 173 | 162 | 12 | 72 | 335 | 121 | 64 | 130 | 0 | 13 | 173 | 162 | 12 | 72 | 335 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451720 | 2451720 | CT | school | 900120 | 40011 | Avon School District | 90012001367 | 40511 | Thompson Brook School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 309 | 28 | 44 | * | 104 | 0 | * | 243 | 266 | 9 | 49 | 509 | 309 | 28 | 44 | 104 | 0 | 243 | 266 | 9 | 49 | 509 | |||||||||||||||||||||||||||||||
2451721 | 2451721 | CT | school | 900120 | 40011 | Avon School District | 90012000012 | 45111 | Avon Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 339 | 21 | 34 | 0 | 96 | 0 | 21 | 251 | 260 | 6 | 48 | 511 | 339 | 21 | 34 | 0 | 96 | 0 | 21 | 251 | 260 | 6 | 48 | 511 | |||||||||||||||||||||||||||||
2451729 | 2451729 | CT | school | 900210 | 70011 | Berlin School District | 90021000017 | 75111 | Catherine M. McGee Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 548 | * | 83 | * | 19 | 0 | 19 | 361 | 324 | 10 | 100 | 685 | 548 | 83 | 19 | 0 | 19 | 361 | 324 | 10 | 100 | 685 | |||||||||||||||||||||||||||||||
2451736 | 2451736 | CT | school | 900270 | 90011 | Bethel School District | 90027000025 | 95111 | Bethel Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 501 | 21 | 162 | * | 46 | * | 11 | 372 | 373 | 28 | 84 | 745 | 501 | 21 | 162 | 46 | 11 | 372 | 373 | 28 | 84 | 745 | |||||||||||||||||||||||||||||||
2451744 | 2451744 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001375 | 110711 | Carmen Arace Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 8 | 207 | 23 | 0 | * | * | 6 | 123 | 123 | * | 45 | 246 | 8 | 207 | 23 | 0 | 6 | 123 | 123 | 45 | 246 | ||||||||||||||||||||||||||||||||
2451746 | 2451746 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000034 | 115211 | Carmen Arace Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 8 | 173 | 25 | * | * | 0 | 13 | 127 | 96 | * | 45 | 223 | 8 | 173 | 25 | 0 | 13 | 127 | 96 | 45 | 223 | ||||||||||||||||||||||||||||||||
2451757 | 2451757 | CT | school | 900420 | 140011 | Branford School District | 90042000041 | 145111 | Francis Walsh Intermediate School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 640 | 35 | 102 | * | 65 | 0 | * | 447 | 424 | 23 | 103 | 871 | 640 | 35 | 102 | 65 | 0 | 447 | 424 | 23 | 103 | 871 | |||||||||||||||||||||||||||||||
2451819 | 2451819 | CT | school | 900510 | 170011 | Bristol School District | 90051000089 | 175111 | Chippens Hill Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 392 | 57 | 234 | * | 26 | * | 28 | 363 | 376 | 35 | 111 | 739 | 392 | 57 | 234 | 26 | 28 | 363 | 376 | 35 | 111 | 739 | |||||||||||||||||||||||||||||||
2451825 | 2451825 | CT | school | 900510 | 170011 | Bristol School District | 90051000104 | 175211 | Northeast Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 318 | 36 | 96 | * | 19 | * | 19 | 245 | 245 | 12 | 82 | 490 | 318 | 36 | 96 | 19 | 19 | 245 | 245 | 12 | 82 | 490 | |||||||||||||||||||||||||||||||
2451835 | 2451835 | CT | school | 900540 | 180011 | Brookfield School District | 90054000112 | 185311 | Whisconier Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 641 | 26 | 104 | * | 70 | * | 7 | 432 | 422 | 26 | 133 | 854 | 641 | 26 | 104 | 70 | 7 | 432 | 422 | 26 | 133 | 854 | |||||||||||||||||||||||||||||||
2451838 | 2451838 | CT | school | 900570 | 190011 | Brooklyn School District | 90057000114 | 195111 | Brooklyn Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 301 | * | 33 | * | 9 | * | 12 | 185 | 177 | * | 54 | 362 | 301 | 33 | 9 | 12 | 185 | 177 | 54 | 362 | |||||||||||||||||||||||||||||||||
2451840 | 2451840 | CT | school | 900660 | 220011 | Canterbury School District | 90066001187 | 225111 | Dr. Helen Baldwin Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 167 | * | 8 | 0 | 0 | 0 | * | 93 | 86 | 0 | 22 | 179 | 167 | 8 | 0 | 0 | 0 | 93 | 86 | 0 | 22 | 179 | |||||||||||||||||||||||||||||||
2451842 | 2451842 | CT | school | 900690 | 230011 | Canton School District | 90069000119 | 230311 | Canton Intermediate School | Public Schools | Regular School | No | Middle | 04 | 06 | 2019 | pk_12_total | 281 | 31 | 24 | 0 | 10 | * | * | 176 | 176 | * | 40 | 352 | 281 | 31 | 24 | 0 | 10 | 176 | 176 | 40 | 352 | ||||||||||||||||||||||||||||||||
2451843 | 2451843 | CT | school | 900690 | 230011 | Canton School District | 90069001376 | 235111 | Canton Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 204 | 14 | 25 | 0 | * | 0 | * | 131 | 124 | * | 34 | 255 | 204 | 14 | 25 | 0 | 0 | 131 | 124 | 34 | 255 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451866 | 2451866 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001364 | 2415014 | Two Rivers Magnet Middle School | Regional Education Service Center Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 142 | 183 | 272 | * | * | 0 | 39 | 389 | 277 | 43 | 122 | 666 | 142 | 183 | 272 | 0 | 39 | 389 | 277 | 43 | 122 | 666 | |||||||||||||||||||||||||||||||
2451879 | 2451879 | CT | school | 900750 | 250011 | Cheshire School District | 90075000125 | 255111 | Dodd Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 548 | 21 | 40 | 0 | 61 | 0 | 12 | 326 | 356 | * | 79 | 682 | 548 | 21 | 40 | 0 | 61 | 0 | 12 | 326 | 356 | 79 | 682 | ||||||||||||||||||||||||||||||
2451886 | 2451886 | CT | school | 900810 | 270011 | Clinton School District | 90081000133 | 275111 | Jared Eliot School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 349 | * | 62 | * | 18 | 0 | 6 | 223 | 215 | 16 | 77 | 438 | 349 | 62 | 18 | 0 | 6 | 223 | 215 | 16 | 77 | 438 | |||||||||||||||||||||||||||||||
2451890 | 2451890 | CT | school | 900840 | 280011 | Colchester School District | 90084000136 | 285111 | William J. Johnston Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 440 | 7 | 36 | * | 16 | * | 19 | 251 | 269 | * | 87 | 520 | 440 | 7 | 36 | 16 | 19 | 251 | 269 | 87 | 520 | ||||||||||||||||||||||||||||||||
2451905 | 2451905 | CT | school | 900960 | 320011 | Coventry School District | 90096000141 | 325111 | Capt. Nathan Hale School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 326 | * | 24 | * | * | 0 | 6 | 170 | 193 | 0 | 49 | 363 | 326 | 24 | 0 | 6 | 170 | 193 | 0 | 49 | 363 | ||||||||||||||||||||||||||||||||
2451910 | 2451910 | CT | school | 900990 | 330011 | Cromwell School District | 90099000147 | 335111 | Cromwell Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 339 | 41 | 43 | 0 | 43 | * | * | 257 | 220 | 10 | 41 | 477 | 339 | 41 | 43 | 0 | 43 | 257 | 220 | 10 | 41 | 477 | |||||||||||||||||||||||||||||||
2451926 | 2451926 | CT | school | 901020 | 340011 | Danbury School District | 90102000149 | 345111 | Broadview Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 331 | 72 | 479 | * | 56 | 0 | * | 480 | 497 | 130 | 170 | 977 | 331 | 72 | 479 | 56 | 0 | 480 | 497 | 130 | 170 | 977 | |||||||||||||||||||||||||||||||
2451927 | 2451927 | CT | school | 901020 | 340011 | Danbury School District | 90102000160 | 345211 | Rogers Park Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 253 | 68 | 579 | 0 | 53 | * | * | 499 | 480 | 267 | 139 | 979 | 253 | 68 | 579 | 0 | 53 | 499 | 480 | 267 | 139 | 979 | |||||||||||||||||||||||||||||||
2451928 | 2451928 | CT | school | 901020 | 340011 | Danbury School District | 90102001691 | 340311 | Westside Middle School Academy | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 283 | 40 | 242 | * | 53 | 0 | * | 329 | 310 | 42 | 52 | 639 | 283 | 40 | 242 | 53 | 0 | 329 | 310 | 42 | 52 | 639 | |||||||||||||||||||||||||||||||
2451937 | 2451937 | CT | school | 901050 | 350011 | Darien School District | 90105000169 | 355111 | Middlesex Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 947 | * | 61 | * | 57 | 0 | 27 | 552 | 549 | * | 152 | 1101 | 947 | 61 | 57 | 0 | 27 | 552 | 549 | 152 | 1101 | ||||||||||||||||||||||||||||||||
2451942 | 2451942 | CT | school | 901110 | 370011 | Derby School District | 90111001578 | 375011 | Derby Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 147 | 56 | 109 | 0 | * | * | 18 | 167 | 174 | 6 | 69 | 341 | 147 | 56 | 109 | 0 | 18 | 167 | 174 | 6 | 69 | 341 | |||||||||||||||||||||||||||||||
2451947 | 2451947 | CT | school | 901170 | 400011 | East Granby School District | 90117000182 | 405111 | East Granby Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 155 | 16 | * | 0 | 16 | 0 | * | 107 | 94 | 0 | 29 | 201 | 155 | 16 | 0 | 16 | 0 | 107 | 94 | 0 | 29 | 201 | |||||||||||||||||||||||||||||||
2451950 | 2451950 | CT | school | 901200 | 410011 | East Haddam School District | 90120000198 | 415111 | Nathan Hale-Ray Middle School | Public Schools | Regular School | No | Middle | 04 | 08 | 2019 | pk_12_total | 327 | * | 16 | * | 6 | 0 | * | 188 | 172 | 0 | 51 | 360 | 327 | 16 | 6 | 0 | 188 | 172 | 0 | 51 | 360 | ||||||||||||||||||||||||||||||||
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 |
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]);