enrollments
Data source: Big Local News · About: Big Local
1,449 rows where grade = "pk_12_total", state = "CT" and year = 2019 sorted by native_american_alaskan_native
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2451945 | 2451945 | CT | school | 901170 | 400011 | East Granby School District | 90117000180 | 400111 | Allgrove School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 151 | 10 | 9 | * | 11 | * | 6 | 105 | 84 | * | 23 | 189 | 151 | 10 | 9 | 11 | 6 | 105 | 84 | 23 | 189 | ||||||||||||||||||||||||||||||||
2451946 | 2451946 | CT | school | 901170 | 400011 | East Granby School District | 90117000183 | 400211 | R. Dudley Seymour School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 138 | 16 | 15 | * | 17 | 0 | * | 93 | 102 | * | 23 | 195 | 138 | 16 | 15 | 17 | 0 | 93 | 102 | 23 | 195 | ||||||||||||||||||||||||||||||||
2451948 | 2451948 | CT | school | 901170 | 400011 | East Granby School District | 90117000181 | 406111 | East Granby High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 198 | 21 | 20 | * | 16 | 0 | * | 131 | 132 | * | 33 | 263 | 198 | 21 | 20 | 16 | 0 | 131 | 132 | 33 | 263 | ||||||||||||||||||||||||||||||||
2451949 | 2451949 | CT | school | 901200 | 410011 | East Haddam School District | 90120000184 | 410111 | East Haddam Elementary School | Public Schools | Regular School | No | Elementary | PK | 03 | 2019 | pk_12_total | 294 | * | 13 | * | * | 0 | 8 | 166 | 155 | 0 | 45 | 321 | 294 | 13 | 0 | 8 | 166 | 155 | 0 | 45 | 321 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2451951 | 2451951 | CT | school | 901200 | 410011 | East Haddam School District | 90120000185 | 416111 | Nathan Hale-Ray High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 299 | * | 16 | * | * | * | * | 180 | 146 | 0 | 38 | 326 | 299 | 16 | 180 | 146 | 0 | 38 | 326 | ||||||||||||||||||||||||||||||||||
2451953 | 2451953 | CT | school | 901230 | 420011 | East Hampton School District | 90123000186 | 420311 | Center School | Public Schools | Regular School | No | Elementary | 04 | 05 | 2019 | pk_12_total | 242 | * | 16 | * | * | 0 | 11 | 125 | 151 | * | 27 | 276 | 242 | 16 | 0 | 11 | 125 | 151 | 27 | 276 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2451959 | 2451959 | CT | school | 901260 | 430011 | East Hartford School District | 90126000194 | 430611 | Dr. Franklin H. Mayberry School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 21 | 117 | 195 | * | * | 0 | 14 | 177 | 184 | 88 | 57 | 361 | 21 | 117 | 195 | 0 | 14 | 177 | 184 | 88 | 57 | 361 | |||||||||||||||||||||||||||||||
2451962 | 2451962 | CT | school | 901260 | 430011 | East Hartford School District | 90126000201 | 432011 | Governor William Pitkin School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 52 | 90 | 131 | * | 34 | 0 | * | 163 | 161 | 41 | 49 | 324 | 52 | 90 | 131 | 34 | 0 | 163 | 161 | 41 | 49 | 324 | |||||||||||||||||||||||||||||||
2451963 | 2451963 | CT | school | 901260 | 430011 | East Hartford School District | 90126000204 | 430411 | Joseph O. Goodwin School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 54 | 88 | 164 | * | * | 0 | 29 | 174 | 179 | 29 | 52 | 353 | 54 | 88 | 164 | 0 | 29 | 174 | 179 | 29 | 52 | 353 | |||||||||||||||||||||||||||||||
2451965 | 2451965 | CT | school | 901260 | 430011 | East Hartford School District | 90126000208 | 431211 | Silver Lane School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | * | 89 | 144 | * | 0 | 0 | 17 | 126 | 140 | 36 | 39 | 266 | 89 | 144 | 0 | 0 | 17 | 126 | 140 | 36 | 39 | 266 | |||||||||||||||||||||||||||||||
2451966 | 2451966 | CT | school | 430011 | East Hartford School District | 90126000205 | 439011 | Woodland School | Program | 2019 | pk_12_total | 20 | 63 | 82 | * | * | 0 | 9 | 146 | 32 | 11 | * | 178 | 20 | 63 | 82 | 0 | 9 | 146 | 32 | 11 | 178 | ||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2451970 | 2451970 | CT | school | 901260 | 430011 | East Hartford School District | 90126000200 | 436211 | East Hartford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 230 | 624 | 782 | * | 101 | * | 34 | 948 | 829 | 147 | 311 | 1777 | 230 | 624 | 782 | 101 | 34 | 948 | 829 | 147 | 311 | 1777 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451974 | 2451974 | CT | school | 901290 | 440011 | East Haven School District | 90129000218 | 441011 | Grove J. Tuttle School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 148 | 15 | 96 | * | 11 | 0 | * | 153 | 127 | 45 | 26 | 280 | 148 | 15 | 96 | 11 | 0 | 153 | 127 | 45 | 26 | 280 | |||||||||||||||||||||||||||||||
2451977 | 2451977 | CT | school | 901290 | 440011 | East Haven School District | 90129000215 | 441311 | Dominick H. Ferrara School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 111 | 8 | 48 | * | 10 | 0 | * | 86 | 99 | 16 | 34 | 185 | 111 | 8 | 48 | 10 | 0 | 86 | 99 | 16 | 34 | 185 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2451988 | 2451988 | CT | school | 901350 | 470011 | East Windsor School District | 90135000228 | 470111 | Broad Brook Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 236 | 58 | 113 | * | 38 | 0 | * | 240 | 232 | 33 | 75 | 472 | 236 | 58 | 113 | 38 | 0 | 240 | 232 | 33 | 75 | 472 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451992 | 2451992 | CT | school | 2530014 | Eastern Connecticut Regional Educational Service Center (EASTCONN) | 90136001156 | 2539014 | EastConn Special Education | Program | 2019 | pk_12_total | 82 | 6 | 26 | * | 0 | 0 | * | 94 | 26 | * | 120 | 120 | 82 | 6 | 26 | 0 | 0 | 94 | 26 | 120 | 120 | ||||||||||||||||||||||||||||||||||||||
2451993 | 2451993 | CT | school | 901360 | 2530014 | Eastern Connecticut Regional Educational Service Center (EASTCONN) | 90136001507 | 2536014 | Arts at the Capitol Theater Magnet School (ACT) | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 70 | * | 32 | * | 0 | 0 | 9 | 30 | 90 | * | 23 | 120 | 70 | 32 | 0 | 0 | 9 | 30 | 90 | 23 | 120 | ||||||||||||||||||||||||||||||||
2451994 | 2451994 | CT | school | 901360 | 2530014 | Eastern Connecticut Regional Educational Service Center (EASTCONN) | 90136001530 | 2536114 | Quinebaug Middle College | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 128 | 6 | 37 | * | * | 0 | * | 61 | 117 | 0 | 26 | 178 | 128 | 6 | 37 | 0 | 61 | 117 | 0 | 26 | 178 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451999 | 2451999 | CT | school | 2420014 | EdAdvance | 90351200575 | 2428014 | EdAdvance Headstart | Program | 2019 | pk_12_total | 146 | 9 | 40 | * | 6 | 7 | * | 105 | 105 | 0 | 32 | 210 | 146 | 9 | 40 | 6 | 7 | 105 | 105 | 0 | 32 | 210 | |||||||||||||||||||||||||||||||||||||
2452002 | 2452002 | CT | school | 2420014 | EdAdvance | 2420214 | Torrington Alternative Program | 2019 | pk_12_total | 10 | * | * | * | 0 | 0 | * | 11 | 6 | 0 | * | 17 | 10 | 0 | 0 | 11 | 6 | 0 | 17 | ||||||||||||||||||||||||||||||||||||||||||
2452006 | 2452006 | CT | school | 901440 | 480011 | Ellington School District | 90144000239 | 480611 | Windermere School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 389 | 26 | 59 | * | 188 | * | 25 | 359 | 331 | 39 | 91 | 690 | 389 | 26 | 59 | 188 | 25 | 359 | 331 | 39 | 91 | 690 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2452017 | 2452017 | CT | school | 901470 | 490011 | Enfield School District | 90147000247 | 490411 | Hazardville Memorial School | Public Schools | Regular School | No | Elementary | KG | 02 | 2019 | pk_12_total | 244 | 28 | 63 | * | 12 | 0 | * | 187 | 169 | 23 | 48 | 356 | 244 | 28 | 63 | 12 | 0 | 187 | 169 | 23 | 48 | 356 | |||||||||||||||||||||||||||||||
2452027 | 2452027 | CT | school | 901470 | 490011 | Enfield School District | 90147000254 | 491511 | Prudence Crandall School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 265 | 28 | 77 | * | 16 | 0 | * | 213 | 186 | 9 | 62 | 399 | 265 | 28 | 77 | 16 | 0 | 213 | 186 | 9 | 62 | 399 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452030 | 2452030 | CT | school | 901470 | 490011 | Enfield School District | 90147000243 | 496111 | Enfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1073 | 94 | 214 | * | 53 | * | 58 | 756 | 744 | 13 | 226 | 1500 | 1073 | 94 | 214 | 53 | 58 | 756 | 744 | 13 | 226 | 1500 | |||||||||||||||||||||||||||||||
2452034 | 2452034 | CT | school | 901530 | 510011 | Fairfield School District | 90153001378 | 510211 | Burr Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 311 | * | 34 | * | 30 | 0 | 33 | 216 | 206 | 15 | 48 | 422 | 311 | 34 | 30 | 0 | 33 | 216 | 206 | 15 | 48 | 422 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452039 | 2452039 | CT | school | 901530 | 510011 | Fairfield School District | 90153000257 | 510111 | Dwight Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 245 | * | 16 | * | 15 | 0 | 12 | 150 | 148 | * | 32 | 298 | 245 | 16 | 15 | 0 | 12 | 150 | 148 | 32 | 298 | ||||||||||||||||||||||||||||||||
2452043 | 2452043 | CT | school | 901530 | 510011 | Fairfield School District | 90153000263 | 510711 | Mill Hill School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 280 | * | 18 | * | 23 | 0 | 19 | 184 | 162 | * | 51 | 346 | 280 | 18 | 23 | 0 | 19 | 184 | 162 | 51 | 346 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452061 | 2452061 | CT | school | 901560 | 520011 | Farmington School District | 90156000273 | 526111 | Farmington High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 849 | 62 | 73 | * | 243 | 0 | * | 629 | 617 | 14 | 156 | 1246 | 849 | 62 | 73 | 243 | 0 | 629 | 617 | 14 | 156 | 1246 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452067 | 2452067 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000286 | 540611 | Hopewell School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 328 | * | 44 | * | 68 | 0 | 27 | 255 | 222 | * | 22 | 477 | 328 | 44 | 68 | 0 | 27 | 255 | 222 | 22 | 477 | ||||||||||||||||||||||||||||||||
2452070 | 2452070 | CT | school | 540011 | Glastonbury School District | 90162001801 | 540111 | Links Academy | Program | 2019 | pk_12_total | 23 | 0 | 8 | * | 0 | 0 | * | 25 | 8 | * | 33 | 33 | 23 | 0 | 8 | 0 | 0 | 25 | 8 | 33 | 33 | ||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2452073 | 2452073 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000283 | 546111 | Glastonbury High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1470 | 67 | 158 | * | 210 | * | 89 | 978 | 1023 | 11 | 202 | 2001 | 1470 | 67 | 158 | 210 | 89 | 978 | 1023 | 11 | 202 | 2001 | |||||||||||||||||||||||||||||||
2452076 | 2452076 | CT | school | 901680 | 560011 | Granby School District | 90168000293 | 560311 | Wells Road Intermediate School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 345 | 24 | 16 | * | * | 0 | 12 | 190 | 222 | * | 71 | 412 | 345 | 24 | 16 | 0 | 12 | 190 | 222 | 71 | 412 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452078 | 2452078 | CT | school | 901680 | 560011 | Granby School District | 90168000289 | 566111 | Granby Memorial High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 562 | 31 | 27 | * | * | 0 | 25 | 334 | 321 | 0 | 73 | 655 | 562 | 31 | 27 | 0 | 25 | 334 | 321 | 0 | 73 | 655 | |||||||||||||||||||||||||||||||
2452079 | 2452079 | CT | school | 901710 | 570011 | Greenwich School District | 90171000301 | 570511 | Hamilton Avenue School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 102 | 38 | 212 | * | * | 0 | 18 | 200 | 189 | 23 | 59 | 389 | 102 | 38 | 212 | 0 | 18 | 200 | 189 | 23 | 59 | 389 | |||||||||||||||||||||||||||||||
2452080 | 2452080 | CT | school | 901710 | 570011 | Greenwich School District | 90171000305 | 570811 | North Street School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 315 | * | 34 | * | 21 | 0 | 40 | 219 | 198 | 13 | 37 | 417 | 315 | 34 | 21 | 0 | 40 | 219 | 198 | 13 | 37 | 417 | |||||||||||||||||||||||||||||||
2452084 | 2452084 | CT | school | 901710 | 570011 | Greenwich School District | 90171000299 | 570411 | Glenville School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 272 | * | 63 | * | 42 | 0 | 26 | 219 | 192 | 18 | 36 | 411 | 272 | 63 | 42 | 0 | 26 | 219 | 192 | 18 | 36 | 411 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452086 | 2452086 | CT | school | 901710 | 570011 | Greenwich School District | 90171000302 | 570311 | Julian Curtiss School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 150 | * | 106 | * | 25 | 0 | 22 | 168 | 152 | 48 | 34 | 320 | 150 | 106 | 25 | 0 | 22 | 168 | 152 | 48 | 34 | 320 | |||||||||||||||||||||||||||||||
2452087 | 2452087 | CT | school | 901710 | 570011 | Greenwich School District | 90171000303 | 570611 | New Lebanon School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 47 | 9 | 149 | * | 16 | 0 | * | 116 | 113 | 40 | 40 | 229 | 47 | 9 | 149 | 16 | 0 | 116 | 113 | 40 | 40 | 229 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2452099 | 2452099 | CT | school | 901740 | 580011 | Griswold School District | 90174000311 | 586211 | Griswold High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 420 | 12 | 34 | * | 16 | * | 23 | 254 | 266 | * | 96 | 520 | 420 | 12 | 34 | 16 | 23 | 254 | 266 | 96 | 520 | ||||||||||||||||||||||||||||||||
2452100 | 2452100 | CT | school | 901770 | 590011 | Groton School District | 90177001494 | 592011 | Catherine Kolnaski Magnet School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 161 | 39 | 126 | * | 48 | * | 52 | 201 | 229 | 27 | 55 | 430 | 161 | 39 | 126 | 48 | 52 | 201 | 229 | 27 | 55 | 430 | |||||||||||||||||||||||||||||||
2452101 | 2452101 | CT | school | 901770 | 590011 | Groton School District | 90177000314 | 590311 | Claude Chester School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 100 | 30 | 113 | * | 22 | * | 59 | 174 | 160 | 16 | 71 | 334 | 100 | 30 | 113 | 22 | 59 | 174 | 160 | 16 | 71 | 334 | |||||||||||||||||||||||||||||||
2452102 | 2452102 | CT | school | 901770 | 590011 | Groton School District | 90177000321 | 591711 | Mary Morrisson School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 202 | 21 | 91 | * | 36 | * | 31 | 188 | 197 | 18 | 88 | 385 | 202 | 21 | 91 | 36 | 31 | 188 | 197 | 18 | 88 | 385 | |||||||||||||||||||||||||||||||
2452103 | 2452103 | CT | school | 901770 | 590011 | Groton School District | 90177000325 | 590111 | S. B. Butler School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 207 | 13 | 52 | * | 13 | * | 29 | 188 | 130 | * | 88 | 318 | 207 | 13 | 52 | 13 | 29 | 188 | 130 | 88 | 318 | ||||||||||||||||||||||||||||||||
2452104 | 2452104 | CT | school | 901770 | 590011 | Groton School District | 90177000313 | 591811 | Charles Barnum School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 210 | 28 | 80 | * | 12 | * | 35 | 197 | 171 | 6 | 50 | 368 | 210 | 28 | 80 | 12 | 35 | 197 | 171 | 6 | 50 | 368 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2452108 | 2452108 | CT | school | 590011 | Groton School District | 590611 | Apex Academy | Program | 2019 | pk_12_total | 8 | 0 | 6 | * | 0 | 0 | * | 11 | 6 | * | 11 | 17 | 8 | 0 | 6 | 0 | 0 | 11 | 6 | 11 | 17 | |||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452128 | 2452128 | CT | school | 901860 | 620011 | Hamden School District | 90186000346 | 620111 | Shepherd Glen School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 59 | 95 | 61 | * | 65 | 0 | * | 154 | 143 | 51 | 37 | 297 | 59 | 95 | 61 | 65 | 0 | 154 | 143 | 51 | 37 | 297 | |||||||||||||||||||||||||||||||
2452130 | 2452130 | CT | school | 901860 | 620011 | Hamden School District | 90186000349 | 621411 | West Woods School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 182 | 53 | 39 | * | 45 | 0 | * | 179 | 162 | 22 | 36 | 341 | 182 | 53 | 39 | 45 | 0 | 179 | 162 | 22 | 36 | 341 | |||||||||||||||||||||||||||||||
2452139 | 2452139 | CT | school | 901890 | 630011 | Hampton School District | 90189000351 | 630111 | Hampton Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 82 | 0 | * | * | * | 0 | 6 | 51 | 42 | 0 | 17 | 93 | 82 | 0 | 0 | 6 | 51 | 42 | 0 | 17 | 93 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452141 | 2452141 | CT | school | 901920 | 640011 | Hartford School District | 90192001534 | 643511 | Breakthrough Magnet School, North | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 20 | 122 | 65 | * | 63 | * | 21 | 152 | 144 | 9 | 30 | 296 | 20 | 122 | 65 | 63 | 21 | 152 | 144 | 9 | 30 | 296 | |||||||||||||||||||||||||||||||
2452142 | 2452142 | CT | school | 901920 | 640011 | Hartford School District | 90192001369 | 643311 | Breakthrough Magnet School, South | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 59 | 79 | 175 | * | 24 | 0 | * | 179 | 171 | 47 | 53 | 350 | 59 | 79 | 175 | 24 | 0 | 179 | 171 | 47 | 53 | 350 | |||||||||||||||||||||||||||||||
2452143 | 2452143 | CT | school | 901920 | 640011 | Hartford School District | 90192000357 | 640611 | Burns Latino Studies Academy | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 19 | 57 | 380 | * | * | 0 | 0 | 250 | 217 | 205 | 80 | 467 | 19 | 57 | 380 | 0 | 0 | 250 | 217 | 205 | 80 | 467 | |||||||||||||||||||||||||||||||
2452145 | 2452145 | CT | school | 901920 | 640011 | Hartford School District | 90192000360 | 640711 | Dwight-Bellizzi Dual Language Academy | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 24 | 96 | 452 | * | 15 | 0 | * | 299 | 297 | 230 | 77 | 596 | 24 | 96 | 452 | 15 | 0 | 299 | 297 | 230 | 77 | 596 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452150 | 2452150 | CT | school | 901920 | 640011 | Hartford School District | 90192000368 | 641011 | Kennelly School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 22 | 85 | 501 | * | 6 | 7 | * | 322 | 304 | 197 | 112 | 626 | 22 | 85 | 501 | 6 | 7 | 322 | 304 | 197 | 112 | 626 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452155 | 2452155 | CT | school | 901920 | 640011 | Hartford School District | 90192001531 | 643711 | Montessori Magnet at Fisher School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 84 | 152 | 63 | * | 35 | 0 | * | 178 | 174 | 21 | 24 | 352 | 84 | 152 | 63 | 35 | 0 | 178 | 174 | 21 | 24 | 352 | |||||||||||||||||||||||||||||||
2452156 | 2452156 | CT | school | 901920 | 640011 | Hartford School District | 90192000372 | 641411 | Naylor/CCSU Leadership Academy | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 75 | 53 | 369 | * | 20 | * | * | 276 | 245 | 153 | 101 | 521 | 75 | 53 | 369 | 20 | 276 | 245 | 153 | 101 | 521 | ||||||||||||||||||||||||||||||||
2452157 | 2452157 | CT | school | 901920 | 640011 | Hartford School District | 90192000373 | 641511 | Parkville Community School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 20 | 47 | 375 | * | * | * | * | 226 | 225 | 175 | 77 | 451 | 20 | 47 | 375 | 226 | 225 | 175 | 77 | 451 | |||||||||||||||||||||||||||||||||
2452160 | 2452160 | CT | school | 640011 | Hartford School District | 640410 | Pre-K Integrated - Parkville School | Program | 2019 | pk_12_total | * | * | 13 | * | * | 0 | 0 | 11 | 8 | 0 | 11 | 19 | 13 | 0 | 0 | 11 | 8 | 0 | 11 | 19 | ||||||||||||||||||||||||||||||||||||||||
2452162 | 2452162 | CT | school | 901920 | 640011 | Hartford School District | 90192000376 | 641711 | Rawson School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 0 | 268 | 83 | * | 0 | * | 8 | 185 | 177 | 53 | 67 | 362 | 0 | 268 | 83 | 0 | 8 | 185 | 177 | 53 | 67 | 362 | |||||||||||||||||||||||||||||||
2452164 | 2452164 | CT | school | 901920 | 640011 | Hartford School District | 90192000383 | 642011 | Webster Micro Society Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 104 | 281 | 163 | * | 45 | 0 | * | 322 | 300 | 33 | 76 | 622 | 104 | 281 | 163 | 45 | 0 | 322 | 300 | 33 | 76 | 622 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452196 | 2452196 | CT | school | 901920 | 640011 | Hartford School District | 90192001559 | 647511 | HPHS Nursing and Health Sciences Academy | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 11 | 114 | 202 | * | 15 | 0 | * | 102 | 242 | 124 | 58 | 344 | 11 | 114 | 202 | 15 | 0 | 102 | 242 | 124 | 58 | 344 | ||||||||||||||||||||||||||||||||
2452197 | 2452197 | CT | school | 901920 | 640011 | Hartford School District | 90192001552 | 647611 | High School, Inc. | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | * | 81 | 102 | * | 0 | 0 | * | 95 | 95 | 35 | 45 | 190 | 81 | 102 | 0 | 0 | 95 | 95 | 35 | 45 | 190 |
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]);