enrollments
Data source: Big Local News · About: Big Local
20,286 rows where state = "CT" and year = 2019 sorted by ell descending
This data as json, CSV (advanced)
grade ✖
Link | rowid | state | county | county_state_id | admin_level | district_nces_id | district_state_id | district_state_type | district | school_nces_id | school_state_id | school | school_state_type | ccd_school_type | ccd_charter_school | ccd_school_lvl | ccd_school_low_grade | ccd_school_high_grade | year | term | grade | white | black | hispanic | native_american | native_american_alaskan_native | asian | native_hawaiian | asian_pacific_islander | native_hawaiian_pacific_islander | pacific_islander | multiracial | unknown_race | male | female | non_binary | unknown_gender | ell ▲ | ell_percent | homeless | homeless_percent | low_income | free_and_reduced | free_and_reduced_percent | disability | section_504 | total | white_int | black_int | hispanic_int | native_american_int | native_american_alaskan_native_int | asian_int | native_hawaiian_int | asian_pacific_islander_int | native_hawaiian_pacific_islander_int | pacific_islander_int | multiracial_int | unknown_race_int | male_int | female_int | non_binary_int | unknown_gender_int | ell_int | homeless_int | low_income_int | free_and_reduced_int | disability_int | section_504_int | total_int |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2452390 | 2452390 | CT | school | 902670 | 890011 | New Britain School District | 90267000524 | 891311 | Smith Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 82 | 56 | 366 | * | * | 0 | 16 | 276 | 260 | 79 | 73 | 536 | 82 | 56 | 366 | 0 | 16 | 276 | 260 | 79 | 73 | 536 | |||||||||||||||||||||||||||||||
2452532 | 2452532 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000651 | 1032211 | Marvin Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 129 | 56 | 203 | 0 | 17 | 0 | 13 | 217 | 201 | 79 | 47 | 418 | 129 | 56 | 203 | 0 | 17 | 0 | 13 | 217 | 201 | 79 | 47 | 418 | |||||||||||||||||||||||||||||
2452717 | 2452717 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000825 | 1320211 | Pleasant Valley School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 238 | 33 | 42 | 0 | 179 | 0 | 41 | 282 | 251 | 79 | 42 | 533 | 238 | 33 | 42 | 0 | 179 | 0 | 41 | 282 | 251 | 79 | 42 | 533 | |||||||||||||||||||||||||||||
2452185 | 2452185 | CT | school | 901920 | 640011 | Hartford School District | 90192001295 | 645411 | Hartford Magnet Trinity College Academy | Public Schools | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 192 | 272 | 485 | * | 48 | * | 53 | 487 | 570 | 78 | 126 | 1057 | 192 | 272 | 485 | 48 | 53 | 487 | 570 | 78 | 126 | 1057 | |||||||||||||||||||||||||||||||
2451958 | 2451958 | CT | school | 901260 | 430011 | East Hartford School District | 90126000191 | 430911 | Anna E. Norris School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 11 | 69 | 206 | 0 | 10 | 0 | 12 | 173 | 135 | 77 | 60 | 308 | 11 | 69 | 206 | 0 | 10 | 0 | 12 | 173 | 135 | 77 | 60 | 308 | |||||||||||||||||||||||||||||
2452140 | 2452140 | CT | school | 901920 | 640011 | Hartford School District | 90192001192 | 642811 | Betances Learning Lab Magnet School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 48 | 64 | 188 | * | 78 | * | 6 | 194 | 197 | 77 | 50 | 391 | 48 | 64 | 188 | 78 | 6 | 194 | 197 | 77 | 50 | 391 | |||||||||||||||||||||||||||||||
2452391 | 2452391 | CT | school | 902670 | 890011 | New Britain School District | 90267000527 | 891511 | Vance Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 70 | 53 | 313 | * | * | 0 | 21 | 228 | 235 | 77 | 70 | 463 | 70 | 53 | 313 | 0 | 21 | 228 | 235 | 77 | 70 | 463 | |||||||||||||||||||||||||||||||
2452153 | 2452153 | CT | school | 901920 | 640011 | Hartford School District | 90192000381 | 641911 | Milner Middle School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 7 | 126 | 191 | * | 0 | 0 | * | 168 | 161 | 76 | 26 | 329 | 7 | 126 | 191 | 0 | 0 | 168 | 161 | 76 | 26 | 329 | |||||||||||||||||||||||||||||||
2452425 | 2452425 | CT | school | 902790 | 930011 | New Haven School District | 90279000584 | 933111 | Conte/West Hills Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 53 | 267 | 325 | * | 7 | * | * | 327 | 335 | 76 | 70 | 662 | 53 | 267 | 325 | 7 | 327 | 335 | 76 | 70 | 662 | ||||||||||||||||||||||||||||||||
2452760 | 2452760 | CT | school | 904320 | 1350011 | Stamford School District | 90432000860 | 1350611 | Newfield School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 194 | 74 | 206 | 0 | 28 | 0 | 22 | 269 | 255 | 76 | 63 | 524 | 194 | 74 | 206 | 0 | 28 | 0 | 22 | 269 | 255 | 76 | 63 | 524 | |||||||||||||||||||||||||||||
2452830 | 2452830 | CT | school | 904590 | 1430011 | Torrington School District | 90459001211 | 1431311 | Vogel-Wetmore School | Public Schools | Regular School | No | Elementary | KG | 03 | 2019 | pk_12_total | 384 | 19 | 158 | 0 | 16 | 0 | 18 | 314 | 281 | 76 | 107 | 595 | 384 | 19 | 158 | 0 | 16 | 0 | 18 | 314 | 281 | 76 | 107 | 595 | |||||||||||||||||||||||||||||
2452882 | 2452882 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000966 | 1512111 | B. W. Tinker School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 138 | 85 | 273 | 0 | 6 | 0 | 39 | 272 | 269 | 76 | 60 | 541 | 138 | 85 | 273 | 0 | 6 | 0 | 39 | 272 | 269 | 76 | 60 | 541 | |||||||||||||||||||||||||||||
2451718 | 2451718 | CT | school | 900120 | 40011 | Avon School District | 90012010010 | 40411 | Pine Grove School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 367 | 35 | 43 | * | 156 | 0 | * | 297 | 329 | 75 | 55 | 626 | 367 | 35 | 43 | 156 | 0 | 297 | 329 | 75 | 55 | 626 | |||||||||||||||||||||||||||||||
2452479 | 2452479 | CT | school | 902820 | 950011 | New London School District | 90282000594 | 950911 | Nathan Hale Arts Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 124 | 83 | 242 | * | 7 | * | 87 | 223 | 323 | 75 | 76 | 546 | 124 | 83 | 242 | 7 | 87 | 223 | 323 | 75 | 76 | 546 | |||||||||||||||||||||||||||||||
2452549 | 2452549 | CT | school | 903120 | 1040011 | Norwich School District | 90312000668 | 1042011 | Moriarty Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 166 | 66 | 127 | * | * | 0 | 34 | 210 | 203 | 75 | 62 | 413 | 166 | 66 | 127 | 0 | 34 | 210 | 203 | 75 | 62 | 413 | |||||||||||||||||||||||||||||||
2452555 | 2452555 | CT | school | 903120 | 1040011 | Norwich School District | 90312000677 | 1041811 | Veterans' Memorial School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 72 | 57 | 113 | * | 22 | * | 29 | 149 | 149 | 75 | 43 | 298 | 72 | 57 | 113 | 22 | 29 | 149 | 149 | 75 | 43 | 298 | |||||||||||||||||||||||||||||||
2452754 | 2452754 | CT | school | 904320 | 1350011 | Stamford School District | 90432000859 | 1350511 | K. T. Murphy School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 96 | 58 | 242 | 0 | 85 | 0 | 20 | 265 | 236 | 75 | 52 | 501 | 96 | 58 | 242 | 0 | 85 | 0 | 20 | 265 | 236 | 75 | 52 | 501 | |||||||||||||||||||||||||||||
2452910 | 2452910 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000974 | 1511111 | Margaret M. Generali Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 92 | 132 | 288 | * | * | 0 | 33 | 294 | 268 | 75 | 68 | 562 | 92 | 132 | 288 | 0 | 33 | 294 | 268 | 75 | 68 | 562 | |||||||||||||||||||||||||||||||
2451811 | 2451811 | CT | school | 900510 | 170011 | Bristol School District | 90051001624 | 172011 | West Bristol School | Public Schools | Regular School | No | Elementary | KG | 08 | 2019 | pk_12_total | 447 | 52 | 345 | 0 | 20 | 0 | 46 | 452 | 458 | 74 | 157 | 910 | 447 | 52 | 345 | 0 | 20 | 0 | 46 | 452 | 458 | 74 | 157 | 910 | |||||||||||||||||||||||||||||
2452714 | 2452714 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000824 | 1320611 | Orchard Hill School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 301 | 36 | 54 | 0 | 187 | 0 | 38 | 295 | 321 | 74 | 54 | 616 | 301 | 36 | 54 | 0 | 187 | 0 | 38 | 295 | 321 | 74 | 54 | 616 | |||||||||||||||||||||||||||||
2452895 | 2452895 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000987 | 1512211 | Walsh School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 29 | 101 | 252 | * | * | 0 | 18 | 208 | 196 | 74 | 48 | 404 | 29 | 101 | 252 | 0 | 18 | 208 | 196 | 74 | 48 | 404 | |||||||||||||||||||||||||||||||
2452909 | 2452909 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000978 | 1511311 | Hopeville School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 58 | 58 | 214 | * | 0 | 0 | * | 181 | 172 | 74 | 50 | 353 | 58 | 58 | 214 | 0 | 0 | 181 | 172 | 74 | 50 | 353 | |||||||||||||||||||||||||||||||
2451913 | 2451913 | CT | school | 901020 | 340011 | Danbury School District | 90102000151 | 341111 | Great Plain School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 124 | 14 | 125 | 0 | 26 | 0 | 11 | 156 | 144 | 72 | 68 | 300 | 124 | 14 | 125 | 0 | 26 | 0 | 11 | 156 | 144 | 72 | 68 | 300 | |||||||||||||||||||||||||||||
2452147 | 2452147 | CT | school | 901920 | 640011 | Hartford School District | 90192000366 | 640911 | Environmental Sciences Magnet at Hooker School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 117 | 70 | 371 | * | 29 | 0 | * | 312 | 295 | 72 | 62 | 607 | 117 | 70 | 371 | 29 | 0 | 312 | 295 | 72 | 62 | 607 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2453035 | 2453035 | CT | school | 905190 | 1630011 | Windham School District | 90519001640 | 1630411 | Charles H. Barrows STEM Academy | Public Schools | Regular School | No | Elementary | KG | 08 | 2019 | pk_12_total | 278 | 8 | 247 | * | 6 | * | 25 | 289 | 278 | 72 | 70 | 567 | 278 | 8 | 247 | 6 | 25 | 289 | 278 | 72 | 70 | 567 | |||||||||||||||||||||||||||||||
2452188 | 2452188 | CT | school | 901920 | 640011 | Hartford School District | 90192001370 | 646511 | Sport and Medical Sciences Academy | Public Schools | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 150 | 155 | 314 | * | 30 | 0 | * | 407 | 272 | 71 | 73 | 679 | 150 | 155 | 314 | 30 | 0 | 407 | 272 | 71 | 73 | 679 | |||||||||||||||||||||||||||||||
2452223 | 2452223 | CT | school | 903450 | 2450014 | Learn | 90345000079 | 2450114 | Regional Multicultural Magnet School | Regional Education Service Center Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 159 | 70 | 208 | * | 11 | * | 70 | 257 | 263 | 71 | 65 | 520 | 159 | 70 | 208 | 11 | 70 | 257 | 263 | 71 | 65 | 520 | |||||||||||||||||||||||||||||||
2452267 | 2452267 | CT | school | 902310 | 770011 | Manchester School District | 90231000430 | 771311 | Waddell School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 141 | 110 | 122 | * | 96 | * | 9 | 231 | 250 | 71 | 34 | 481 | 141 | 110 | 122 | 96 | 9 | 231 | 250 | 71 | 34 | 481 | |||||||||||||||||||||||||||||||
2452418 | 2452418 | CT | school | 902790 | 930011 | New Haven School District | 90279000542 | 930211 | Barnard Environmental Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 97 | 255 | 169 | 0 | 20 | * | * | 270 | 276 | 71 | 57 | 546 | 97 | 255 | 169 | 0 | 20 | 270 | 276 | 71 | 57 | 546 | |||||||||||||||||||||||||||||||
2452439 | 2452439 | CT | school | 902790 | 930011 | New Haven School District | 90279001387 | 931011 | Ross/Woodward School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 121 | 207 | 300 | 0 | 23 | 0 | 7 | 348 | 310 | 71 | 55 | 658 | 121 | 207 | 300 | 0 | 23 | 0 | 7 | 348 | 310 | 71 | 55 | 658 | |||||||||||||||||||||||||||||
2452454 | 2452454 | CT | school | 902790 | 930011 | New Haven School District | 90279000588 | 933811 | Worthington Hooker School | Public Schools | Regular School | No | Elementary | KG | 08 | 2019 | pk_12_total | 181 | 73 | 59 | * | 129 | 0 | * | 239 | 214 | 71 | 26 | 453 | 181 | 73 | 59 | 129 | 0 | 239 | 214 | 71 | 26 | 453 | |||||||||||||||||||||||||||||||
2453118 | 2453118 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201136 | 9001516 | A. I. Prince Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 32 | 177 | 444 | * | 13 | * | * | 339 | 338 | 71 | 64 | 677 | 32 | 177 | 444 | 13 | 339 | 338 | 71 | 64 | 677 | ||||||||||||||||||||||||||||||||
2451770 | 2451770 | CT | school | 900450 | 150011 | Bridgeport School District | 90045001918 | 153111 | Geraldine Claytor Magnet Academy | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 42 | 187 | 223 | * | * | * | 7 | 233 | 233 | 70 | 71 | 466 | 42 | 187 | 223 | 7 | 233 | 233 | 70 | 71 | 466 | ||||||||||||||||||||||||||||||||
2451802 | 2451802 | CT | school | 900510 | 170011 | Bristol School District | 90051000098 | 170511 | Greene-Hills School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 462 | 68 | 313 | 0 | 45 | * | * | 472 | 446 | 70 | 115 | 918 | 462 | 68 | 313 | 0 | 45 | 472 | 446 | 70 | 115 | 918 | |||||||||||||||||||||||||||||||
2452137 | 2452137 | CT | school | 901860 | 620011 | Hamden School District | 90186000339 | 626111 | Hamden High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 533 | 453 | 284 | 6 | 115 | 0 | 63 | 733 | 721 | 70 | 219 | 1454 | 533 | 453 | 284 | 6 | 115 | 0 | 63 | 733 | 721 | 70 | 219 | 1454 | |||||||||||||||||||||||||||||
2452758 | 2452758 | CT | school | 904320 | 1350011 | Stamford School District | 90432000167 | 1352211 | Hart School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 127 | 81 | 259 | 0 | 108 | 0 | 37 | 305 | 307 | 70 | 59 | 612 | 127 | 81 | 259 | 0 | 108 | 0 | 37 | 305 | 307 | 70 | 59 | 612 | |||||||||||||||||||||||||||||
2451749 | 2451749 | CT | school | 900360 | 120011 | Bolton School District | 90036000036 | 120111 | Bolton Center School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 403 | 31 | 55 | 0 | 10 | 0 | 21 | 245 | 275 | 7 | 50 | 520 | 403 | 31 | 55 | 0 | 10 | 0 | 21 | 245 | 275 | 7 | 50 | 520 | |||||||||||||||||||||||||||||
2451841 | 2451841 | CT | school | 900690 | 230011 | Canton School District | 90069000120 | 230211 | Cherry Brook Primary School | Public Schools | Regular School | No | Elementary | PK | 03 | 2019 | pk_12_total | 376 | 25 | 32 | 0 | * | * | 18 | 225 | 232 | 7 | 47 | 457 | 376 | 25 | 32 | 0 | 18 | 225 | 232 | 7 | 47 | 457 | |||||||||||||||||||||||||||||||
2451911 | 2451911 | CT | school | 900990 | 330011 | Cromwell School District | 90099000145 | 336111 | Cromwell High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 384 | 51 | 42 | * | 39 | 0 | * | 272 | 254 | 7 | 58 | 526 | 384 | 51 | 42 | 39 | 0 | 272 | 254 | 7 | 58 | 526 | |||||||||||||||||||||||||||||||
2451932 | 2451932 | CT | school | 901050 | 350011 | Darien School District | 90105000165 | 350211 | Hindley Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 386 | * | * | 0 | 28 | 0 | 23 | 249 | 211 | 7 | 60 | 460 | 386 | 0 | 28 | 0 | 23 | 249 | 211 | 7 | 60 | 460 | |||||||||||||||||||||||||||||||
2451981 | 2451981 | CT | school | 901320 | 450011 | East Lyme School District | 90132000225 | 450111 | Flanders School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 251 | * | 30 | 0 | 31 | 0 | * | 159 | 175 | 7 | 43 | 334 | 251 | 30 | 0 | 31 | 0 | 159 | 175 | 7 | 43 | 334 | |||||||||||||||||||||||||||||||
2451990 | 2451990 | CT | school | 901350 | 470011 | East Windsor School District | 90135000229 | 476111 | East Windsor High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 174 | 47 | 55 | 0 | * | 0 | * | 168 | 127 | 7 | 64 | 295 | 174 | 47 | 55 | 0 | 0 | 168 | 127 | 7 | 64 | 295 | |||||||||||||||||||||||||||||||
2452005 | 2452005 | CT | school | 901440 | 480011 | Ellington School District | 90144000236 | 480211 | Crystal Lake School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 262 | 17 | 18 | 0 | 15 | 0 | 12 | 162 | 162 | 7 | 46 | 324 | 262 | 17 | 18 | 0 | 15 | 0 | 12 | 162 | 162 | 7 | 46 | 324 | |||||||||||||||||||||||||||||
2452019 | 2452019 | CT | school | 901470 | 490011 | Enfield School District | 90147000248 | 491811 | Henry Barnard School | Public Schools | Regular School | No | Elementary | KG | 02 | 2019 | pk_12_total | 241 | 36 | 65 | 0 | * | * | 22 | 187 | 191 | 7 | 73 | 378 | 241 | 36 | 65 | 0 | 22 | 187 | 191 | 7 | 73 | 378 | |||||||||||||||||||||||||||||||
2452044 | 2452044 | CT | school | 901530 | 510011 | Fairfield School District | 90153000264 | 511611 | North Stratfield School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 282 | 9 | 38 | 0 | 28 | 0 | 20 | 186 | 191 | 7 | 47 | 377 | 282 | 9 | 38 | 0 | 28 | 0 | 20 | 186 | 191 | 7 | 47 | 377 | |||||||||||||||||||||||||||||
2452105 | 2452105 | CT | school | 901770 | 590011 | Groton School District | 90177001488 | 591911 | Northeast Academy Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 307 | * | 44 | 0 | 19 | * | 33 | 206 | 205 | 7 | 47 | 411 | 307 | 44 | 0 | 19 | 33 | 206 | 205 | 7 | 47 | 411 | |||||||||||||||||||||||||||||||
2452236 | 2452236 | CT | school | 902130 | 710011 | Lebanon School District | 90213000395 | 710111 | Lebanon Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 325 | 6 | 22 | * | 6 | * | * | 208 | 158 | 7 | 41 | 366 | 325 | 6 | 22 | 6 | 208 | 158 | 7 | 41 | 366 | ||||||||||||||||||||||||||||||||
2452337 | 2452337 | CT | school | 902520 | 840011 | Milford School District | 90252000481 | 841811 | Orchard Hills School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 261 | 7 | 29 | 0 | 13 | 0 | 11 | 162 | 159 | 7 | 43 | 321 | 261 | 7 | 29 | 0 | 13 | 0 | 11 | 162 | 159 | 7 | 43 | 321 | |||||||||||||||||||||||||||||
2452351 | 2452351 | CT | school | 902550 | 850011 | Monroe School District | 90255000488 | 850511 | Fawn Hollow Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 418 | * | 52 | * | 42 | 0 | 20 | 272 | 276 | 7 | 64 | 548 | 418 | 52 | 42 | 0 | 20 | 272 | 276 | 7 | 64 | 548 | |||||||||||||||||||||||||||||||
2452441 | 2452441 | CT | school | 902790 | 930011 | New Haven School District | 90279000647 | 934911 | West Rock Authors Academy | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 32 | 89 | 42 | * | 6 | 0 | * | 87 | 87 | 7 | 13 | 174 | 32 | 89 | 42 | 6 | 0 | 87 | 87 | 7 | 13 | 174 | |||||||||||||||||||||||||||||||
2452455 | 2452455 | CT | school | 930011 | New Haven School District | 937811 | Clinton Self Contained ID | Program | 2019 | pk_12_total | 0 | * | * | 0 | 0 | 0 | 0 | 6 | 8 | 7 | 14 | 14 | 0 | 0 | 0 | 0 | 0 | 6 | 8 | 7 | 14 | 14 | ||||||||||||||||||||||||||||||||||||||
2452508 | 2452508 | CT | school | 902970 | 990011 | North Branford School District | 90297000620 | 990411 | Jerome Harrison School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 333 | * | 23 | 0 | * | 0 | 0 | 188 | 180 | 7 | 40 | 368 | 333 | 23 | 0 | 0 | 0 | 188 | 180 | 7 | 40 | 368 | |||||||||||||||||||||||||||||||
2452513 | 2452513 | CT | school | 903000 | 1000011 | North Canaan School District | 90300000626 | 1000111 | North Canaan Elementary School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 213 | * | 28 | 0 | * | 0 | 9 | 127 | 128 | 7 | 42 | 255 | 213 | 28 | 0 | 0 | 9 | 127 | 128 | 7 | 42 | 255 | |||||||||||||||||||||||||||||||
2452579 | 2452579 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000695 | 1096111 | Plainfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 565 | 16 | 20 | * | 12 | * | * | 319 | 306 | 7 | 103 | 625 | 565 | 16 | 20 | 12 | 319 | 306 | 7 | 103 | 625 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2452607 | 2452607 | CT | school | 903600 | 2010012 | Regional School District 01 | 90360000766 | 2016112 | Housatonic Valley Regional High School | Regional Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 300 | * | 48 | 0 | * | 0 | 19 | 194 | * | 7 | 53 | 379 | 300 | 48 | 0 | 0 | 19 | 194 | 7 | 53 | 379 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452702 | 2452702 | CT | school | 904110 | 1280011 | Simsbury School District | 90411000810 | 1280111 | Central School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 272 | * | 32 | * | 36 | 0 | 25 | 213 | 164 | 7 | 35 | 377 | 272 | 32 | 36 | 0 | 25 | 213 | 164 | 7 | 35 | 377 | |||||||||||||||||||||||||||||||
2452707 | 2452707 | CT | school | 904110 | 1280011 | Simsbury School District | 90411000813 | 1286111 | Simsbury High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1100 | 69 | 113 | 0 | 89 | * | * | 740 | 652 | 7 | 182 | 1392 | 1100 | 69 | 113 | 0 | 89 | 740 | 652 | 7 | 182 | 1392 | |||||||||||||||||||||||||||||||
2452725 | 2452725 | CT | school | 904230 | 1310011 | Southington School District | 90423000829 | 1311511 | Derynoski Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 437 | 11 | 48 | 0 | 16 | 0 | 23 | 280 | 255 | 7 | 69 | 535 | 437 | 11 | 48 | 0 | 16 | 0 | 23 | 280 | 255 | 7 | 69 | 535 | |||||||||||||||||||||||||||||
2452730 | 2452730 | CT | school | 904230 | 1310011 | Southington School District | 90423000836 | 1310611 | Oshana Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 202 | * | 36 | 0 | 6 | * | 13 | 139 | 126 | 7 | 29 | 265 | 202 | 36 | 0 | 6 | 13 | 139 | 126 | 7 | 29 | 265 | |||||||||||||||||||||||||||||||
2452800 | 2452800 | CT | school | 904440 | 1380011 | Stratford School District | 90444000900 | 1385211 | David Wooster Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 207 | 114 | 177 | 0 | 10 | 0 | 16 | 246 | 278 | 7 | 58 | 524 | 207 | 114 | 177 | 0 | 10 | 0 | 16 | 246 | 278 | 7 | 58 | 524 | |||||||||||||||||||||||||||||
2452948 | 2452948 | CT | school | 904860 | 1520011 | Waterford School District | 90486001001 | 1526111 | Waterford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 643 | 19 | 98 | * | 52 | * | 20 | 432 | * | 7 | 138 | 838 | 643 | 19 | 98 | 52 | 20 | 432 | 7 | 138 | 838 | ||||||||||||||||||||||||||||||||
2453064 | 2453064 | CT | school | 905280 | 1660011 | Wolcott School District | 90528001102 | 1665111 | Tyrrell Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 447 | 26 | 43 | * | * | 0 | 24 | 289 | 263 | 7 | 75 | 552 | 447 | 26 | 43 | 0 | 24 | 289 | 263 | 7 | 75 | 552 | |||||||||||||||||||||||||||||||
2452894 | 2452894 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000986 | 1512011 | Sprague School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 54 | 89 | 330 | 0 | * | 0 | * | 249 | 255 | 69 | 49 | 504 | 54 | 89 | 330 | 0 | 0 | 249 | 255 | 69 | 49 | 504 | |||||||||||||||||||||||||||||||
2452093 | 2452093 | CT | school | 901710 | 570011 | Greenwich School District | 90171000300 | 576111 | Greenwich High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1789 | 78 | 588 | * | 199 | * | 86 | 1401 | * | 68 | 316 | 2746 | 1789 | 78 | 588 | 199 | 86 | 1401 | 68 | 316 | 2746 | ||||||||||||||||||||||||||||||||
2452883 | 2452883 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000969 | 1510611 | Bunker Hill School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 75 | 103 | 258 | * | * | 0 | 19 | 257 | 216 | 68 | 87 | 473 | 75 | 103 | 258 | 0 | 19 | 257 | 216 | 68 | 87 | 473 | |||||||||||||||||||||||||||||||
2452959 | 2452959 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001217 | 1551711 | Smith School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 110 | 49 | 116 | 0 | 67 | 0 | 9 | 182 | 169 | 68 | 26 | 351 | 110 | 49 | 116 | 0 | 67 | 0 | 9 | 182 | 169 | 68 | 26 | 351 | |||||||||||||||||||||||||||||
2452982 | 2452982 | CT | school | 904950 | 1560011 | West Haven School District | 90495001027 | 1560811 | Alma E. Pagels School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 143 | 82 | 98 | * | 24 | 0 | * | 210 | 150 | 68 | 101 | 360 | 143 | 82 | 98 | 24 | 0 | 210 | 150 | 68 | 101 | 360 | |||||||||||||||||||||||||||||||
2452533 | 2452533 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000658 | 1031311 | Rowayton School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 256 | 47 | 155 | * | 9 | * | 20 | 234 | 255 | 67 | 62 | 489 | 256 | 47 | 155 | 9 | 20 | 234 | 255 | 67 | 62 | 489 | |||||||||||||||||||||||||||||||
2452673 | 2452673 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000784 | 1190411 | Myrtle H. Stevens School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 378 | * | 68 | * | 113 | 0 | 26 | 301 | 307 | 67 | 61 | 608 | 378 | 68 | 113 | 0 | 26 | 301 | 307 | 67 | 61 | 608 | |||||||||||||||||||||||||||||||
2451782 | 2451782 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000086 | 153011 | Waltersville School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 34 | 172 | 280 | * | * | 0 | 0 | 257 | 233 | 66 | 94 | 490 | 34 | 172 | 280 | 0 | 0 | 257 | 233 | 66 | 94 | 490 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2452950 | 2452950 | CT | school | 904890 | 1530011 | Watertown School District | 90489001135 | 1530211 | John Trumbull Primary School | Public Schools | Regular School | No | Elementary | PK | 03 | 2019 | pk_12_total | 572 | 19 | 34 | * | * | 0 | 17 | 359 | 297 | 66 | 81 | 656 | 572 | 19 | 34 | 0 | 17 | 359 | 297 | 66 | 81 | 656 | |||||||||||||||||||||||||||||||
2452986 | 2452986 | CT | school | 904950 | 1560011 | West Haven School District | 90495001039 | 1560411 | Seth G. Haley School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 197 | 61 | 95 | * | 13 | 0 | * | 206 | 175 | 65 | 62 | 381 | 197 | 61 | 95 | 13 | 0 | 206 | 175 | 65 | 62 | 381 | |||||||||||||||||||||||||||||||
2452833 | 2452833 | CT | school | 904590 | 1430011 | Torrington School District | 90459000925 | 1435111 | Torrington Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 601 | 42 | 259 | * | 42 | * | 37 | 516 | 469 | 64 | 185 | 985 | 601 | 42 | 259 | 42 | 37 | 516 | 469 | 64 | 185 | 985 | |||||||||||||||||||||||||||||||
2452480 | 2452480 | CT | school | 902820 | 950011 | New London School District | 90282000597 | 950811 | Winthrop STEM Elementary Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 150 | 84 | 191 | * | 10 | * | 78 | 279 | 237 | 62 | 70 | 516 | 150 | 84 | 191 | 10 | 78 | 279 | 237 | 62 | 70 | 516 | |||||||||||||||||||||||||||||||
2452798 | 2452798 | CT | school | 904440 | 1380011 | Stratford School District | 90444000892 | 1381511 | Stratford Academy - Johnson House | Public Schools | Regular School | No | Elementary | 02 | 06 | 2019 | pk_12_total | 81 | 167 | 184 | 0 | * | * | 24 | 224 | 248 | 62 | 65 | 472 | 81 | 167 | 184 | 0 | 24 | 224 | 248 | 62 | 65 | 472 | |||||||||||||||||||||||||||||||
2452834 | 2452834 | CT | school | 904590 | 1430011 | Torrington School District | 90459000924 | 1436111 | Torrington High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 497 | 43 | 241 | * | 43 | * | 25 | 458 | 395 | 62 | 158 | 853 | 497 | 43 | 241 | 43 | 25 | 458 | 395 | 62 | 158 | 853 | |||||||||||||||||||||||||||||||
2452899 | 2452899 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000685 | 1513211 | Woodrow Wilson School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 18 | 109 | 271 | * | * | * | 10 | 231 | 184 | 62 | 53 | 415 | 18 | 109 | 271 | 10 | 231 | 184 | 62 | 53 | 415 | ||||||||||||||||||||||||||||||||
2452154 | 2452154 | CT | school | 901920 | 640011 | Hartford School District | 90192001641 | 640511 | Montessori Magnet at Batchelder School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 85 | 58 | 177 | * | 11 | 0 | * | 163 | 182 | 61 | 36 | 345 | 85 | 58 | 177 | 11 | 0 | 163 | 182 | 61 | 36 | 345 | |||||||||||||||||||||||||||||||
2452466 | 2452466 | CT | school | 902790 | 930011 | New Haven School District | 90279000556 | 936311 | Hill Regional Career High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 59 | 295 | 305 | * | 30 | 0 | * | 295 | 405 | 61 | 70 | 700 | 59 | 295 | 305 | 30 | 0 | 295 | 405 | 61 | 70 | 700 | |||||||||||||||||||||||||||||||
2452808 | 2452808 | CT | school | 904440 | 1380011 | Stratford School District | 90444000897 | 1386111 | Stratford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 367 | 237 | 313 | 0 | 31 | * | * | 503 | 470 | 61 | 106 | 973 | 367 | 237 | 313 | 0 | 31 | 503 | 470 | 61 | 106 | 973 | |||||||||||||||||||||||||||||||
2452891 | 2452891 | CT | school | 904830 | 1510011 | Waterbury School District | 90483001613 | 1513411 | Reed School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 33 | 107 | 318 | * | * | 0 | 17 | 252 | 226 | 61 | 80 | 478 | 33 | 107 | 318 | 0 | 17 | 252 | 226 | 61 | 80 | 478 | |||||||||||||||||||||||||||||||
2452283 | 2452283 | CT | school | 902400 | 800011 | Meriden School District | 90240000443 | 800411 | Israel Putnam School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 142 | 42 | 262 | 0 | 18 | 0 | 25 | 230 | 259 | 60 | 56 | 489 | 142 | 42 | 262 | 0 | 18 | 0 | 25 | 230 | 259 | 60 | 56 | 489 | |||||||||||||||||||||||||||||
2452550 | 2452550 | CT | school | 903120 | 1040011 | Norwich School District | 90312000672 | 1040811 | Samuel Huntington School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 155 | 66 | 84 | 0 | * | * | 50 | 187 | * | 60 | 51 | 372 | 155 | 66 | 84 | 0 | 50 | 187 | 60 | 51 | 372 | ||||||||||||||||||||||||||||||||
2453015 | 2453015 | CT | school | 905070 | 1590011 | Wethersfield School District | 90507001061 | 1590211 | Emerson-Williams School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 285 | 15 | 93 | 0 | 16 | 0 | 23 | 218 | 214 | 60 | 57 | 432 | 285 | 15 | 93 | 0 | 16 | 0 | 23 | 218 | 214 | 60 | 57 | 432 | |||||||||||||||||||||||||||||
2453084 | 2453084 | CT | school | 900219 | 2940013 | Great Oaks Charter School District | 90021901782 | 2940113 | Great Oaks Charter School | Public Charter Schools | Regular School | Yes | Middle | 06 | 10 | 2019 | pk_12_total | 22 | 224 | 209 | * | 0 | * | 7 | 216 | 249 | 60 | 85 | 465 | 22 | 224 | 209 | 0 | 7 | 216 | 249 | 60 | 85 | 465 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2451730 | 2451730 | CT | school | 900210 | 70011 | Berlin School District | 90021000016 | 76111 | Berlin High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 724 | 23 | 93 | 0 | 35 | 0 | 24 | 487 | 412 | 6 | 94 | 899 | 724 | 23 | 93 | 0 | 35 | 0 | 24 | 487 | 412 | 6 | 94 | 899 | |||||||||||||||||||||||||||||
2451904 | 2451904 | CT | school | 900960 | 320011 | Coventry School District | 90096000144 | 320411 | George Hersey Robertson School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 334 | * | 17 | 0 | * | 0 | 10 | 201 | 171 | 6 | 54 | 372 | 334 | 17 | 0 | 0 | 10 | 201 | 171 | 6 | 54 | 372 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451969 | 2451969 | CT | school | 901260 | 430011 | East Hartford School District | 90126001477 | 436311 | Connecticut IB Academy | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 43 | 59 | 48 | * | 35 | 0 | * | 83 | 108 | 6 | * | 191 | 43 | 59 | 48 | 35 | 0 | 83 | 108 | 6 | 191 | ||||||||||||||||||||||||||||||||
2451971 | 2451971 | CT | school | 901260 | 430011 | East Hartford School District | 90126001377 | 436411 | Synergy Alternative Program | Program | Alternative School | No | High | 10 | 12 | 2019 | pk_12_total | * | 28 | 50 | 0 | 0 | 0 | * | 63 | 31 | 6 | 21 | 94 | 28 | 50 | 0 | 0 | 0 | 63 | 31 | 6 | 21 | 94 | |||||||||||||||||||||||||||||||
2451983 | 2451983 | CT | school | 901320 | 450011 | East Lyme School District | 90132000227 | 450211 | Niantic Center School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 146 | * | 11 | 0 | * | 0 | 13 | 88 | 88 | 6 | 23 | 176 | 146 | 11 | 0 | 0 | 13 | 88 | 88 | 6 | 23 | 176 |
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]);