enrollments
Data source: Big Local News · About: Big Local
20,286 rows where state = "CT" and year = 2019 sorted by asian 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2453028 | 2453028 | CT | school | 905130 | 1610011 | Wilton School District | 90513001071 | 1610711 | Cider Mill School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 648 | * | * | 0 | 99 | 0 | 56 | 449 | 409 | * | 120 | 858 | 648 | 0 | 99 | 0 | 56 | 449 | 409 | 120 | 858 | ||||||||||||||||||||||||||||||||
2452697 | 2452697 | CT | school | 904050 | 1260011 | Shelton School District | 90405000806 | 1266111 | Shelton High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 983 | 79 | 196 | * | 98 | 0 | * | 717 | * | 18 | 160 | 1401 | 983 | 79 | 196 | 98 | 0 | 717 | 18 | 160 | 1401 | ||||||||||||||||||||||||||||||||
2452751 | 2452751 | CT | school | 900220 | 2960013 | Stamford Charter School for Excellence District | 90022001807 | 2960113 | Stamford Charter School for Excellence | Public Charter Schools | Regular School | Yes | Elementary | PK | 04 | 2019 | pk_12_total | * | 163 | 72 | * | 97 | * | * | 161 | 178 | 12 | 20 | 339 | 163 | 72 | 97 | 161 | 178 | 12 | 20 | 339 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2451986 | 2451986 | CT | school | 901320 | 450011 | East Lyme School District | 90132000223 | 456111 | East Lyme High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 750 | 23 | 74 | * | 96 | * | 53 | 506 | 496 | * | 132 | 1002 | 750 | 23 | 74 | 96 | 53 | 506 | 496 | 132 | 1002 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452088 | 2452088 | CT | school | 901710 | 570011 | Greenwich School District | 90171000304 | 570711 | North Mianus School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 293 | * | 75 | 0 | 95 | 0 | * | 263 | 229 | 25 | 40 | 492 | 293 | 75 | 0 | 95 | 0 | 263 | 229 | 25 | 40 | 492 | |||||||||||||||||||||||||||||||
2452050 | 2452050 | CT | school | 901530 | 510011 | Fairfield School District | 90153001379 | 516011 | Fairfield Ludlowe High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1243 | * | 130 | * | 94 | 0 | 45 | 751 | 782 | 10 | 171 | 1533 | 1243 | 130 | 94 | 0 | 45 | 751 | 782 | 10 | 171 | 1533 | |||||||||||||||||||||||||||||||
2451719 | 2451719 | CT | school | 900120 | 40011 | Avon School District | 90012000013 | 40311 | Roaring Brook School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 319 | 24 | 27 | * | 93 | 0 | * | 252 | 231 | 15 | 38 | 483 | 319 | 24 | 27 | 93 | 0 | 252 | 231 | 15 | 38 | 483 | |||||||||||||||||||||||||||||||
2452975 | 2452975 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001021 | 1555211 | Sedgwick Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 489 | 75 | 201 | * | 92 | * | 27 | 421 | 466 | 34 | 108 | 887 | 489 | 75 | 201 | 92 | 27 | 421 | 466 | 34 | 108 | 887 | |||||||||||||||||||||||||||||||
2452051 | 2452051 | CT | school | 901530 | 510011 | Fairfield School District | 90153000256 | 516211 | Fairfield Warde High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1056 | * | 225 | * | 90 | 0 | 60 | 748 | 731 | 43 | 191 | 1479 | 1056 | 225 | 90 | 0 | 60 | 748 | 731 | 43 | 191 | 1479 | |||||||||||||||||||||||||||||||
2452085 | 2452085 | CT | school | 901710 | 570011 | Greenwich School District | 90171001288 | 571311 | International School At Dundee | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 184 | * | 52 | * | 90 | 0 | 37 | 189 | 180 | 24 | 29 | 369 | 184 | 52 | 90 | 0 | 37 | 189 | 180 | 24 | 29 | 369 | |||||||||||||||||||||||||||||||
2452341 | 2452341 | CT | school | 902520 | 840011 | Milford School District | 90252000478 | 840711 | Meadowside School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 133 | * | 32 | 0 | 90 | 0 | * | 117 | 149 | 45 | 29 | 266 | 133 | 32 | 0 | 90 | 0 | 117 | 149 | 45 | 29 | 266 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2451888 | 2451888 | CT | school | 900840 | 280011 | Colchester School District | 90084001444 | 280411 | Colchester Elementary School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 456 | 6 | 38 | 0 | 9 | 0 | 24 | 268 | 265 | * | 109 | 533 | 456 | 6 | 38 | 0 | 9 | 0 | 24 | 268 | 265 | 109 | 533 | ||||||||||||||||||||||||||||||
2451972 | 2451972 | CT | school | 901290 | 440011 | East Haven School District | 90129000214 | 440111 | Deer Run School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 139 | 11 | 61 | * | 9 | * | 9 | 128 | 103 | 18 | 68 | 231 | 139 | 11 | 61 | 9 | 9 | 128 | 103 | 18 | 68 | 231 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2452024 | 2452024 | CT | school | 901470 | 490011 | Enfield School District | 90147000241 | 491311 | Edgar H. Parkman School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 238 | 15 | 53 | 0 | 9 | 0 | 15 | 161 | 169 | 11 | 55 | 330 | 238 | 15 | 53 | 0 | 9 | 0 | 15 | 161 | 169 | 11 | 55 | 330 | |||||||||||||||||||||||||||||
2452038 | 2452038 | CT | school | 901530 | 510011 | Fairfield School District | 90153000269 | 511311 | Sherman School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 378 | * | 29 | * | 9 | 0 | 25 | 214 | 233 | 8 | 48 | 447 | 378 | 29 | 9 | 0 | 25 | 214 | 233 | 8 | 48 | 447 | |||||||||||||||||||||||||||||||
2452120 | 2452120 | CT | school | 901860 | 620011 | Hamden School District | 90186000337 | 620211 | Church Street School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 29 | 120 | 108 | * | 9 | * | 15 | 134 | 149 | 34 | 33 | 283 | 29 | 120 | 108 | 9 | 15 | 134 | 149 | 34 | 33 | 283 | |||||||||||||||||||||||||||||||
2452232 | 2452232 | CT | school | 903450 | 2450014 | Learn | 90345001606 | 2456114 | Marine Science Magnet High School | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 203 | * | 31 | * | 9 | 0 | 20 | 123 | 148 | * | 32 | 271 | 203 | 31 | 9 | 0 | 20 | 123 | 148 | 32 | 271 | ||||||||||||||||||||||||||||||||
2452285 | 2452285 | CT | school | 902400 | 800011 | Meriden School District | 90240000448 | 800711 | Nathan Hale School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 159 | 67 | 339 | 0 | 9 | 0 | 22 | 317 | 279 | 95 | 80 | 596 | 159 | 67 | 339 | 0 | 9 | 0 | 22 | 317 | 279 | 95 | 80 | 596 | |||||||||||||||||||||||||||||
2452289 | 2452289 | CT | school | 902400 | 800011 | Meriden School District | 90240000451 | 801011 | Thomas Hooker School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 167 | 23 | 192 | 0 | 9 | 0 | 14 | 190 | 215 | 118 | 54 | 405 | 167 | 23 | 192 | 0 | 9 | 0 | 14 | 190 | 215 | 118 | 54 | 405 | |||||||||||||||||||||||||||||
2452367 | 2452367 | CT | school | 902640 | 880011 | Naugatuck School District | 90264000506 | 880511 | Hop Brook Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 161 | 31 | 86 | 0 | 9 | 0 | 27 | 155 | 159 | 51 | 47 | 314 | 161 | 31 | 86 | 0 | 9 | 0 | 27 | 155 | 159 | 51 | 47 | 314 | |||||||||||||||||||||||||||||
2452377 | 2452377 | CT | school | 902670 | 890011 | New Britain School District | 90267000510 | 891111 | DiLoreto Elementary & Middle School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 107 | 69 | 641 | 0 | 9 | 0 | 19 | 403 | 442 | 114 | 121 | 845 | 107 | 69 | 641 | 0 | 9 | 0 | 19 | 403 | 442 | 114 | 121 | 845 | |||||||||||||||||||||||||||||
2452378 | 2452378 | CT | school | 902670 | 890011 | New Britain School District | 90267000512 | 890511 | Gaffney Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 84 | 39 | 281 | 0 | 9 | 0 | 21 | 207 | 227 | 55 | 83 | 434 | 84 | 39 | 281 | 0 | 9 | 0 | 21 | 207 | 227 | 55 | 83 | 434 | |||||||||||||||||||||||||||||
2452436 | 2452436 | CT | school | 902790 | 930011 | New Haven School District | 90279000566 | 932011 | Lincoln-Bassett School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | * | 268 | 83 | 0 | 9 | 0 | * | 210 | 161 | 10 | 70 | 371 | 268 | 83 | 0 | 9 | 0 | 210 | 161 | 10 | 70 | 371 | |||||||||||||||||||||||||||||||
2452438 | 2452438 | CT | school | 902790 | 930011 | New Haven School District | 90279001564 | 931911 | Mauro-Sheridan Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 98 | 274 | 157 | * | 9 | 0 | * | 289 | 259 | 53 | 74 | 548 | 98 | 274 | 157 | 9 | 0 | 289 | 259 | 53 | 74 | 548 | |||||||||||||||||||||||||||||||
2452453 | 2452453 | CT | school | 902790 | 930011 | New Haven School District | 90279001483 | 934211 | Roberto Clemente Leadership Academy for Global Awareness | Public Schools | Regular School | No | Elementary | KG | 08 | 2019 | pk_12_total | 41 | 144 | 278 | 0 | 9 | * | * | 246 | 229 | 123 | 74 | 475 | 41 | 144 | 278 | 0 | 9 | 246 | 229 | 123 | 74 | 475 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452572 | 2452572 | CT | school | 903240 | 1080011 | Oxford School District | 90324001504 | 1086011 | Oxford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 485 | 10 | 32 | 0 | 9 | 0 | 13 | 259 | 290 | 6 | 51 | 549 | 485 | 10 | 32 | 0 | 9 | 0 | 13 | 259 | 290 | 6 | 51 | 549 | |||||||||||||||||||||||||||||
2452613 | 2452613 | CT | school | 903520 | 2100012 | Regional School District 10 | 90352000729 | 2100212 | Lake Garda Elementary School | Regional Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 384 | * | 16 | * | 9 | 0 | 6 | 231 | 190 | 23 | 48 | 421 | 384 | 16 | 9 | 0 | 6 | 231 | 190 | 23 | 48 | 421 | |||||||||||||||||||||||||||||||
2452655 | 2452655 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354000763 | 2186112 | Lyme-Old Lyme High School | Regional Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 427 | * | 24 | * | 9 | 0 | 7 | 236 | 235 | * | 36 | 471 | 427 | 24 | 9 | 0 | 7 | 236 | 235 | 36 | 471 | ||||||||||||||||||||||||||||||||
2452966 | 2452966 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001018 | 1550911 | Morley School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 215 | 15 | 41 | 0 | 9 | 0 | 17 | 146 | 151 | 12 | 27 | 297 | 215 | 15 | 41 | 0 | 9 | 0 | 17 | 146 | 151 | 12 | 27 | 297 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2453101 | 2453101 | CT | school | 903750 | 2080012 | Regional School District 08 | 90375001210 | 2085112 | RHAM Middle School | Regional Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 444 | * | 23 | 0 | 9 | * | 0 | 261 | 222 | * | 70 | 483 | 444 | 23 | 0 | 9 | 0 | 261 | 222 | 70 | 483 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452770 | 2452770 | CT | school | 904320 | 1350011 | Stamford School District | 90432000009 | 1355711 | Scofield Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 224 | 74 | 251 | 0 | 89 | 0 | 8 | 325 | 321 | 24 | 41 | 646 | 224 | 74 | 251 | 0 | 89 | 0 | 8 | 325 | 321 | 24 | 41 | 646 | |||||||||||||||||||||||||||||
2451850 | 2451850 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001511 | 2410414 | International Magnet School for Global Citizenship | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 69 | 155 | 140 | 0 | 88 | 0 | 25 | 240 | 237 | 32 | 50 | 477 | 69 | 155 | 140 | 0 | 88 | 0 | 25 | 240 | 237 | 32 | 50 | 477 | |||||||||||||||||||||||||||||
2452065 | 2452065 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000280 | 540211 | Buttonball Lane School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 301 | * | 50 | * | 87 | 0 | 31 | 248 | 235 | 34 | 44 | 483 | 301 | 50 | 87 | 0 | 31 | 248 | 235 | 34 | 44 | 483 | |||||||||||||||||||||||||||||||
2452974 | 2452974 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001017 | 1555111 | King Philip Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 533 | 75 | 153 | 0 | 87 | * | * | 467 | 436 | 38 | 121 | 903 | 533 | 75 | 153 | 0 | 87 | 467 | 436 | 38 | 121 | 903 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2451846 | 2451846 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001629 | 2410714 | Academy of Aerospace and Engineering Elementary | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 121 | 124 | 150 | * | 85 | * | 19 | 263 | 238 | 86 | 68 | 501 | 121 | 124 | 150 | 85 | 19 | 263 | 238 | 86 | 68 | 501 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2451875 | 2451875 | CT | school | 900750 | 250011 | Cheshire School District | 90075000127 | 250411 | Highland School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 573 | 19 | 48 | * | 84 | 0 | * | 388 | 355 | 17 | 88 | 743 | 573 | 19 | 48 | 84 | 0 | 388 | 355 | 17 | 88 | 743 | |||||||||||||||||||||||||||||||
2453026 | 2453026 | CT | school | 905130 | 1610011 | Wilton School District | 90513001075 | 1610511 | Miller-Driscoll School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 590 | 6 | 56 | 0 | 84 | 0 | 55 | 395 | 396 | 15 | 94 | 791 | 590 | 6 | 56 | 0 | 84 | 0 | 55 | 395 | 396 | 15 | 94 | 791 | |||||||||||||||||||||||||||||
2452057 | 2452057 | CT | school | 901560 | 520011 | Farmington School District | 90156000275 | 520211 | Noah Wallace School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 205 | 19 | 31 | 0 | 82 | 0 | 17 | 176 | 178 | 27 | 28 | 354 | 205 | 19 | 31 | 0 | 82 | 0 | 17 | 176 | 178 | 27 | 28 | 354 | |||||||||||||||||||||||||||||
2452741 | 2452741 | CT | school | 904230 | 1310011 | Southington School District | 90423000838 | 1316211 | Southington High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1620 | * | 153 | 0 | 82 | * | 71 | 962 | 1008 | 12 | 233 | 1970 | 1620 | 153 | 0 | 82 | 71 | 962 | 1008 | 12 | 233 | 1970 | |||||||||||||||||||||||||||||||
2452766 | 2452766 | CT | school | 904320 | 1350011 | Stamford School District | 90432000872 | 1351411 | Westover School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 167 | 158 | 251 | 0 | 82 | 0 | 27 | 346 | 339 | 51 | 70 | 685 | 167 | 158 | 251 | 0 | 82 | 0 | 27 | 346 | 339 | 51 | 70 | 685 | |||||||||||||||||||||||||||||
2452764 | 2452764 | CT | school | 904320 | 1350011 | Stamford School District | 90432001916 | 1350711 | Strawberry Hill an ext. of Rogers International | Public Schools | Regular School | No | Elementary | KG | 03 | 2019 | pk_12_total | 142 | 59 | 121 | * | 81 | 0 | * | 210 | 226 | 16 | 32 | 436 | 142 | 59 | 121 | 81 | 0 | 210 | 226 | 16 | 32 | 436 | |||||||||||||||||||||||||||||||
2452844 | 2452844 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000933 | 1445111 | Madison Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 587 | 45 | 100 | 0 | 80 | * | * | 454 | 379 | 6 | 110 | 833 | 587 | 45 | 100 | 0 | 80 | 454 | 379 | 6 | 110 | 833 | |||||||||||||||||||||||||||||||
2451773 | 2451773 | CT | school | 900450 | 150011 | Bridgeport School District | 90045001163 | 154511 | High Horizons Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 81 | 192 | 167 | * | 8 | 0 | * | 206 | 248 | 11 | 45 | 454 | 81 | 192 | 167 | 8 | 0 | 206 | 248 | 11 | 45 | 454 | |||||||||||||||||||||||||||||||
2451803 | 2451803 | CT | school | 900510 | 170011 | Bristol School District | 90051000099 | 171911 | Ivy Drive School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 236 | 36 | 75 | 0 | 8 | 0 | 21 | 189 | 187 | 14 | 67 | 376 | 236 | 36 | 75 | 0 | 8 | 0 | 21 | 189 | 187 | 14 | 67 | 376 | |||||||||||||||||||||||||||||
2451960 | 2451960 | CT | school | 901260 | 430011 | East Hartford School District | 90126000195 | 432211 | Dr. John A. Langford School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 31 | 109 | 199 | 0 | 8 | 0 | 6 | 209 | 144 | 87 | 65 | 353 | 31 | 109 | 199 | 0 | 8 | 0 | 6 | 209 | 144 | 87 | 65 | 353 | |||||||||||||||||||||||||||||
2452020 | 2452020 | CT | school | 901470 | 490011 | Enfield School District | 90147000242 | 491611 | Eli Whitney School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 249 | 25 | 57 | 0 | 8 | 0 | 12 | 178 | 173 | 15 | 57 | 351 | 249 | 25 | 57 | 0 | 8 | 0 | 12 | 178 | 173 | 15 | 57 | 351 | |||||||||||||||||||||||||||||
2452075 | 2452075 | CT | school | 901680 | 560011 | Granby School District | 90168000290 | 560411 | Kelly Lane Primary School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 339 | 24 | 16 | 0 | 8 | 0 | 10 | 212 | 185 | * | 50 | 397 | 339 | 24 | 16 | 0 | 8 | 0 | 10 | 212 | 185 | 50 | 397 | ||||||||||||||||||||||||||||||
2452096 | 2452096 | CT | school | 901740 | 580011 | Griswold School District | 90174000310 | 580311 | Griswold Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 539 | 18 | 73 | * | 8 | * | 51 | 353 | 342 | 10 | 110 | 695 | 539 | 18 | 73 | 8 | 51 | 353 | 342 | 10 | 110 | 695 | |||||||||||||||||||||||||||||||
2452320 | 2452320 | CT | school | 902490 | 830011 | Middletown School District | 90249000464 | 831411 | Wesley School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 134 | 44 | 36 | 0 | 8 | 0 | 19 | 125 | 116 | * | 27 | 241 | 134 | 44 | 36 | 0 | 8 | 0 | 19 | 125 | 116 | 27 | 241 | ||||||||||||||||||||||||||||||
2452358 | 2452358 | CT | school | 902580 | 860011 | Montville School District | 90258000492 | 860711 | Dr. Charles E. Murphy School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 190 | * | 37 | * | 8 | 0 | 47 | 155 | 135 | 11 | 42 | 290 | 190 | 37 | 8 | 0 | 47 | 155 | 135 | 11 | 42 | 290 | |||||||||||||||||||||||||||||||
2452467 | 2452467 | CT | school | 902790 | 930011 | New Haven School District | 90279000563 | 936211 | James Hillhouse High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 46 | 597 | 289 | * | 8 | * | * | 507 | 439 | 156 | 192 | 946 | 46 | 597 | 289 | 8 | 507 | 439 | 156 | 192 | 946 | ||||||||||||||||||||||||||||||||
2452499 | 2452499 | CT | school | 902910 | 970011 | Newtown School District | 90291000613 | 970111 | Hawley Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 270 | * | 26 | 0 | 8 | 0 | * | 154 | 156 | * | 50 | 310 | 270 | 26 | 0 | 8 | 0 | 154 | 156 | 50 | 310 | ||||||||||||||||||||||||||||||||
2452501 | 2452501 | CT | school | 902910 | 970011 | Newtown School District | 90291000614 | 970311 | Middle Gate Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 296 | * | 41 | * | 8 | 0 | 10 | 187 | 174 | * | 43 | 361 | 296 | 41 | 8 | 0 | 10 | 187 | 174 | 43 | 361 | ||||||||||||||||||||||||||||||||
2452582 | 2452582 | CT | school | 903300 | 1100011 | Plainville School District | 90330000702 | 1100511 | Louis Toffolon School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 296 | 19 | 54 | * | 8 | * | 14 | 203 | 190 | 27 | 55 | 393 | 296 | 19 | 54 | 8 | 14 | 203 | 190 | 27 | 55 | 393 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2452732 | 2452732 | CT | school | 904230 | 1310011 | Southington School District | 90423000839 | 1310811 | Strong Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 212 | 9 | 32 | 0 | 8 | 0 | 20 | 140 | 141 | 11 | 33 | 281 | 212 | 9 | 32 | 0 | 8 | 0 | 20 | 140 | 141 | 11 | 33 | 281 | |||||||||||||||||||||||||||||
2453060 | 2453060 | CT | school | 905280 | 1660011 | Wolcott School District | 90528001105 | 1660611 | Alcott School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 212 | 7 | 38 | 0 | 8 | 0 | 6 | 151 | 120 | 16 | 44 | 271 | 212 | 7 | 38 | 0 | 8 | 0 | 6 | 151 | 120 | 16 | 44 | 271 | |||||||||||||||||||||||||||||
2453126 | 2453126 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201144 | 9001216 | Henry Abbott Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 300 | 25 | 320 | 0 | 8 | 0 | 19 | 385 | 287 | 29 | 71 | 672 | 300 | 25 | 320 | 0 | 8 | 0 | 19 | 385 | 287 | 29 | 71 | 672 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452406 | 2452406 | CT | school | 902700 | 900011 | New Canaan School District | 90270000531 | 906111 | New Canaan High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1096 | 23 | 53 | * | 77 | * | 32 | 647 | 637 | * | 167 | 1284 | 1096 | 23 | 53 | 77 | 32 | 647 | 637 | 167 | 1284 | ||||||||||||||||||||||||||||||||
2451862 | 2451862 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001513 | 2415114 | Academy of Aerospace and Engineering | Regional Education Service Center Schools | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 166 | 229 | 286 | * | 75 | * | 27 | 542 | 244 | 33 | 108 | 786 | 166 | 229 | 286 | 75 | 27 | 542 | 244 | 33 | 108 | 786 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452542 | 2452542 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000655 | 1036111 | Norwalk High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 554 | 330 | 740 | * | 74 | * | 22 | 912 | 810 | 184 | 213 | 1722 | 554 | 330 | 740 | 74 | 22 | 912 | 810 | 184 | 213 | 1722 | |||||||||||||||||||||||||||||||
2452110 | 2452110 | CT | school | 901770 | 590011 | Groton School District | 90177000318 | 596111 | Robert E. Fitch High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 574 | 98 | 185 | 17 | 72 | 6 | 84 | 542 | 494 | 20 | 148 | 1036 | 574 | 98 | 185 | 17 | 72 | 6 | 84 | 542 | 494 | 20 | 148 | 1036 | |||||||||||||||||||||||||||||
2451758 | 2451758 | CT | school | 900420 | 140011 | Branford School District | 90042000039 | 146111 | Branford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 622 | 33 | 82 | 0 | 71 | 0 | 20 | 408 | 420 | 17 | 116 | 828 | 622 | 33 | 82 | 0 | 71 | 0 | 20 | 408 | 420 | 17 | 116 | 828 | |||||||||||||||||||||||||||||
2452841 | 2452841 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000934 | 1440311 | Middlebrook School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 302 | 39 | 83 | 0 | 71 | * | * | 255 | 246 | 46 | 53 | 501 | 302 | 39 | 83 | 0 | 71 | 255 | 246 | 46 | 53 | 501 | |||||||||||||||||||||||||||||||
2451737 | 2451737 | CT | school | 900270 | 90011 | Bethel School District | 90027000024 | 96111 | Bethel High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 621 | 31 | 162 | * | 70 | * | 16 | 485 | 419 | 30 | 114 | 904 | 621 | 31 | 162 | 70 | 16 | 485 | 419 | 30 | 114 | 904 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451938 | 2451938 | CT | school | 901050 | 350011 | Darien School District | 90105000164 | 356111 | Darien High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1238 | 20 | 73 | * | 70 | 0 | * | 726 | * | * | 244 | 1418 | 1238 | 20 | 73 | 70 | 0 | 726 | 244 | 1418 | |||||||||||||||||||||||||||||||||
2452399 | 2452399 | CT | school | 902670 | 890011 | New Britain School District | 90267000521 | 896111 | New Britain High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 402 | 299 | 1385 | * | 70 | 0 | * | 1158 | 1050 | 390 | 502 | 2208 | 402 | 299 | 1385 | 70 | 0 | 1158 | 1050 | 390 | 502 | 2208 | |||||||||||||||||||||||||||||||
2452994 | 2452994 | CT | school | 904950 | 1560011 | West Haven School District | 90495001041 | 1566111 | West Haven High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 462 | 362 | 520 | * | 70 | * | 57 | 749 | 727 | 122 | 202 | 1476 | 462 | 362 | 520 | 70 | 57 | 749 | 727 | 122 | 202 | 1476 | |||||||||||||||||||||||||||||||
2451750 | 2451750 | CT | school | 900360 | 120011 | Bolton School District | 90036000037 | 126111 | Bolton High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 210 | 16 | 21 | 0 | 7 | 0 | 7 | 141 | * | 0 | 39 | 261 | 210 | 16 | 21 | 0 | 7 | 0 | 7 | 141 | 0 | 39 | 261 | ||||||||||||||||||||||||||||||
2451885 | 2451885 | CT | school | 900810 | 270011 | Clinton School District | 90081000131 | 270111 | Abraham Pierson School | Regular School | No | Elementary | 04 | 05 | 2019 | pk_12_total | 187 | * | 48 | * | 7 | 0 | 6 | 130 | 121 | 24 | 36 | 251 | 187 | 48 | 7 | 0 | 6 | 130 | 121 | 24 | 36 | 251 | ||||||||||||||||||||||||||||||||
2451955 | 2451955 | CT | school | 901230 | 420011 | East Hampton School District | 90123000187 | 426111 | East Hampton High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 455 | 6 | 24 | * | 7 | * | 6 | 261 | 239 | * | 39 | 500 | 455 | 6 | 24 | 7 | 6 | 261 | 239 | 39 | 500 | ||||||||||||||||||||||||||||||||
2451976 | 2451976 | CT | school | 901290 | 440011 | East Haven School District | 90129000605 | 441711 | Carbone School/East Haven Academy | Public Schools | Regular School | No | Elementary | 01 | 08 | 2019 | pk_12_total | 233 | 9 | 56 | 0 | 7 | 0 | 9 | 161 | 153 | 11 | 38 | 314 | 233 | 9 | 56 | 0 | 7 | 0 | 9 | 161 | 153 | 11 | 38 | 314 | |||||||||||||||||||||||||||||
2452115 | 2452115 | CT | school | 901800 | 600011 | Guilford School District | 90180000334 | 600311 | Melissa Jones School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 248 | * | 16 | 0 | 7 | * | 15 | 143 | 148 | 6 | 27 | 291 | 248 | 16 | 0 | 7 | 15 | 143 | 148 | 6 | 27 | 291 | |||||||||||||||||||||||||||||||
2452214 | 2452214 | CT | school | 902040 | 680011 | Kent School District | 90204000389 | 680111 | Kent Center School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 177 | 0 | 19 | 0 | 7 | 0 | 10 | 111 | 102 | * | 17 | 213 | 177 | 0 | 19 | 0 | 7 | 0 | 10 | 111 | 102 | 17 | 213 | ||||||||||||||||||||||||||||||
2452217 | 2452217 | CT | school | 902070 | 690011 | Killingly School District | 90207000394 | 690311 | Killingly Memorial School | Public Schools | Regular School | No | Elementary | 02 | 04 | 2019 | pk_12_total | 403 | * | 43 | * | 7 | 0 | 29 | 249 | 244 | 20 | 64 | 493 | 403 | 43 | 7 | 0 | 29 | 249 | 244 | 20 | 64 | 493 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
2452247 | 2452247 | CT | school | 902220 | 740011 | Litchfield School District | 90222000405 | 740211 | Center School | Public Schools | Regular School | No | Elementary | PK | 03 | 2019 | pk_12_total | 258 | * | 13 | 0 | 7 | * | * | 144 | 141 | 0 | 40 | 285 | 258 | 13 | 0 | 7 | 144 | 141 | 0 | 40 | 285 | ||||||||||||||||||||||||||||||||
2452260 | 2452260 | CT | school | 770011 | Manchester School District | 770811 | Manchester Preschool - Site 2 | Program | 2019 | pk_12_total | 19 | * | * | 0 | 7 | 0 | 0 | 24 | 10 | 0 | 19 | 34 | 19 | 0 | 7 | 0 | 0 | 24 | 10 | 0 | 19 | 34 | ||||||||||||||||||||||||||||||||||||||
2452287 | 2452287 | CT | school | 902400 | 800011 | Meriden School District | 90240000450 | 800811 | Roger Sherman School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 98 | 37 | 321 | * | 7 | * | 22 | 250 | 237 | 99 | 80 | 487 | 98 | 37 | 321 | 7 | 22 | 250 | 237 | 99 | 80 | 487 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452522 | 2452522 | CT | school | 903060 | 1020011 | North Stonington School District | 90306000635 | 1026111 | Wheeler High School | Public Schools | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 311 | * | 9 | * | 7 | * | 18 | 199 | 156 | 0 | 29 | 355 | 311 | 9 | 7 | 18 | 199 | 156 | 0 | 29 | 355 | ||||||||||||||||||||||||||||||||
2452598 | 2452598 | CT | school | 903480 | 1160011 | Putnam School District | 90348000718 | 1160311 | Putnam Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 506 | 16 | 83 | 0 | 7 | 0 | 31 | 331 | 312 | 29 | 104 | 643 | 506 | 16 | 83 | 0 | 7 | 0 | 31 | 331 | 312 | 29 | 104 | 643 | |||||||||||||||||||||||||||||
2452678 | 2452678 | CT | school | 903900 | 1210011 | Salem School District | 90390000787 | 1210111 | Salem Elementary School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 350 | 10 | 24 | 7 | 7 | 0 | 15 | * | 216 | * | 59 | 413 | 350 | 10 | 24 | 7 | 7 | 0 | 15 | 216 | 59 | 413 | |||||||||||||||||||||||||||||||
2452700 | 2452700 | CT | school | 900016 | 2700013 | Side By Side Charter School District | 90001600823 | 2700113 | Side By Side Charter School | Public Charter Schools | Regular School | Yes | Elementary | PK | 08 | 2019 | pk_12_total | 30 | 65 | 119 | 0 | 7 | 0 | 15 | 115 | 121 | 22 | 25 | 236 | 30 | 65 | 119 | 0 | 7 | 0 | 15 | 115 | 121 | 22 | 25 | 236 | |||||||||||||||||||||||||||||
2452727 | 2452727 | CT | school | 904230 | 1310011 | Southington School District | 90423000831 | 1310211 | Hatton Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 263 | * | 27 | * | 7 | 0 | 16 | 163 | 158 | 9 | 43 | 321 | 263 | 27 | 7 | 0 | 16 | 163 | 158 | 9 | 43 | 321 |
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]);