enrollments
Data source: Big Local News · About: Big Local
1,449 rows where grade = "pk_12_total", state = "CT" and year = 2019 sorted by district_state_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||
2451698 | 2451698 | CT | school | 900030 | 10011 | Andover School District | 90003010001 | 10111 | Andover Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 164 | * | 17 | 0 | 0 | 0 | * | 101 | 90 | * | 12 | 191 | 164 | 17 | 0 | 0 | 0 | 101 | 90 | 12 | 191 | ||||||||||||||||||||||||||||||||
2452514 | 2452514 | CT | school | 903030 | 1010011 | North Haven School District | 90303000627 | 1010811 | Clintonville Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 275 | 13 | 28 | * | 11 | 0 | * | 174 | 160 | 8 | 18 | 334 | 275 | 13 | 28 | 11 | 0 | 174 | 160 | 8 | 18 | 334 | |||||||||||||||||||||||||||||||
2452515 | 2452515 | CT | school | 903030 | 1010011 | North Haven School District | 90303000628 | 1010711 | Green Acres Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 272 | 19 | 31 | 0 | 43 | 0 | 15 | 184 | 196 | 31 | 53 | 380 | 272 | 19 | 31 | 0 | 43 | 0 | 15 | 184 | 196 | 31 | 53 | 380 | |||||||||||||||||||||||||||||
2452516 | 2452516 | CT | school | 903030 | 1010011 | North Haven School District | 90303000630 | 1010211 | Montowese Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 208 | * | 28 | * | 19 | 0 | 6 | 142 | 124 | 11 | 28 | 266 | 208 | 28 | 19 | 0 | 6 | 142 | 124 | 11 | 28 | 266 | |||||||||||||||||||||||||||||||
2452517 | 2452517 | CT | school | 903030 | 1010011 | North Haven School District | 90303000633 | 1010311 | Ridge Road Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 297 | 18 | 36 | 0 | 26 | * | * | 193 | 195 | 12 | 41 | 388 | 297 | 18 | 36 | 0 | 26 | 193 | 195 | 12 | 41 | 388 | |||||||||||||||||||||||||||||||
2452518 | 2452518 | CT | school | 903030 | 1010011 | North Haven School District | 90303000632 | 1015211 | North Haven Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 570 | 25 | 61 | * | 55 | 0 | * | 380 | 351 | 10 | 94 | 731 | 570 | 25 | 61 | 55 | 0 | 380 | 351 | 10 | 94 | 731 | |||||||||||||||||||||||||||||||
2452519 | 2452519 | CT | school | 903030 | 1010011 | North Haven School District | 90303000631 | 1016111 | North Haven High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 827 | 38 | 73 | * | 64 | * | 29 | 528 | 506 | 11 | 117 | 1034 | 827 | 38 | 73 | 64 | 29 | 528 | 506 | 11 | 117 | 1034 | |||||||||||||||||||||||||||||||
2452520 | 2452520 | CT | school | 1010011 | North Haven School District | 90303001733 | 1010111 | North Haven Transition Partnership | Program | 2019 | pk_12_total | * | 0 | * | 0 | * | 0 | 0 | * | * | 0 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | ||||||||||||||||||||||||||||||||||||||||
2452521 | 2452521 | CT | school | 903060 | 1020011 | North Stonington School District | 90306000634 | 1020111 | North Stonington Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 325 | 6 | 20 | * | 10 | * | * | 188 | 181 | 0 | 42 | 369 | 325 | 6 | 20 | 10 | 188 | 181 | 0 | 42 | 369 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2452523 | 2452523 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000640 | 1030211 | Brookside Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 39 | 47 | 309 | 0 | 18 | * | * | 234 | 190 | 117 | 59 | 424 | 39 | 47 | 309 | 0 | 18 | 234 | 190 | 117 | 59 | 424 | |||||||||||||||||||||||||||||||
2452524 | 2452524 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000645 | 1032011 | Fox Run Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 134 | 80 | 157 | * | 23 | 0 | * | 216 | 202 | 46 | 66 | 418 | 134 | 80 | 157 | 23 | 0 | 216 | 202 | 46 | 66 | 418 | |||||||||||||||||||||||||||||||
2452525 | 2452525 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000652 | 1032111 | Naramake Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 122 | 47 | 164 | 0 | 15 | * | * | 181 | 182 | 47 | 42 | 363 | 122 | 47 | 164 | 0 | 15 | 181 | 182 | 47 | 42 | 363 | |||||||||||||||||||||||||||||||
2452526 | 2452526 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001914 | 1030111 | Norwalk Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 74 | 14 | 54 | 0 | 15 | 0 | 6 | 100 | 63 | 0 | 104 | 163 | 74 | 14 | 54 | 0 | 15 | 0 | 6 | 100 | 63 | 0 | 104 | 163 | |||||||||||||||||||||||||||||
2452527 | 2452527 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000660 | 1031411 | Tracey Magnet School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 62 | 70 | 232 | 0 | 34 | 0 | 17 | 228 | 187 | 105 | 68 | 415 | 62 | 70 | 232 | 0 | 34 | 0 | 17 | 228 | 187 | 105 | 68 | 415 | |||||||||||||||||||||||||||||
2452528 | 2452528 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000648 | 1030711 | Jefferson Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 46 | 77 | 319 | * | 55 | * | 16 | 302 | 213 | 134 | 55 | 515 | 46 | 77 | 319 | 55 | 16 | 302 | 213 | 134 | 55 | 515 | |||||||||||||||||||||||||||||||
2452529 | 2452529 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000642 | 1030311 | Columbus Magnet School | Public Schools | Regular School | No | Elementary | KG | 07 | 2019 | pk_12_total | 136 | 77 | 106 | * | 14 | * | 14 | 182 | 169 | 37 | 46 | 351 | 136 | 77 | 106 | 14 | 14 | 182 | 169 | 37 | 46 | 351 | |||||||||||||||||||||||||||||||
2452530 | 2452530 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000643 | 1030411 | Cranbury Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 215 | 45 | 131 | 0 | 26 | * | * | 212 | 218 | 52 | 65 | 430 | 215 | 45 | 131 | 0 | 26 | 212 | 218 | 52 | 65 | 430 | |||||||||||||||||||||||||||||||
2452531 | 2452531 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000649 | 1030811 | Kendall Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 56 | 69 | 323 | 0 | 25 | 0 | 11 | 235 | 249 | 168 | 43 | 484 | 56 | 69 | 323 | 0 | 25 | 0 | 11 | 235 | 249 | 168 | 43 | 484 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452534 | 2452534 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000659 | 1032311 | Silvermine Dual Language Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 57 | 50 | 364 | 0 | * | * | 12 | 262 | 231 | 154 | 56 | 493 | 57 | 50 | 364 | 0 | 12 | 262 | 231 | 154 | 56 | 493 | |||||||||||||||||||||||||||||||
2452535 | 2452535 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000662 | 1032411 | Wolfpit School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 118 | 45 | 124 | 0 | 21 | 0 | 15 | 173 | 150 | 53 | 44 | 323 | 118 | 45 | 124 | 0 | 21 | 0 | 15 | 173 | 150 | 53 | 44 | 323 | |||||||||||||||||||||||||||||
2452536 | 2452536 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000653 | 1035211 | Nathan Hale Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 216 | 103 | 286 | 0 | 28 | 0 | 15 | 331 | 317 | 58 | 107 | 648 | 216 | 103 | 286 | 0 | 28 | 0 | 15 | 331 | 317 | 58 | 107 | 648 | |||||||||||||||||||||||||||||
2452537 | 2452537 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000656 | 1035311 | Ponus Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 103 | 107 | 421 | * | 34 | 0 | * | 330 | 352 | 121 | 94 | 682 | 103 | 107 | 421 | 34 | 0 | 330 | 352 | 121 | 94 | 682 | |||||||||||||||||||||||||||||||
2452538 | 2452538 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000657 | 1035511 | Roton Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 186 | 74 | 261 | 0 | 17 | 0 | 11 | 296 | 253 | 66 | 76 | 549 | 186 | 74 | 261 | 0 | 17 | 0 | 11 | 296 | 253 | 66 | 76 | 549 | |||||||||||||||||||||||||||||
2452539 | 2452539 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000661 | 1035411 | West Rocks Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 166 | 135 | 338 | * | 26 | 0 | * | 349 | 326 | 93 | 110 | 675 | 166 | 135 | 338 | 26 | 0 | 349 | 326 | 93 | 110 | 675 | |||||||||||||||||||||||||||||||
2452540 | 2452540 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000638 | 1036211 | Brien McMahon High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 363 | 300 | 823 | 0 | 51 | 0 | 25 | 807 | * | 213 | 208 | 1562 | 363 | 300 | 823 | 0 | 51 | 0 | 25 | 807 | 213 | 208 | 1562 | ||||||||||||||||||||||||||||||
2452541 | 2452541 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001917 | 1030511 | Center for Global Studies | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 112 | 49 | 84 | 0 | * | 0 | * | 84 | 197 | * | 10 | 281 | 112 | 49 | 84 | 0 | 0 | 84 | 197 | 10 | 281 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452543 | 2452543 | CT | school | 1030011 | Norwalk School District | 1030611 | Norwalk 18-21 Project SEARCH | Program | 2019 | pk_12_total | 7 | * | * | 0 | 0 | 0 | 0 | 10 | 7 | * | 17 | 17 | 7 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | 17 | |||||||||||||||||||||||||||||||||||||||
2452544 | 2452544 | CT | school | 903120 | 1040011 | Norwich School District | 90312000663 | 1040111 | Bishop School Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 61 | 33 | 54 | * | 15 | 0 | * | 90 | 85 | 0 | 74 | 175 | 61 | 33 | 54 | 15 | 0 | 90 | 85 | 0 | 74 | 175 | |||||||||||||||||||||||||||||||
2452545 | 2452545 | CT | school | 1040011 | Norwich School District | 90312001745 | 1040211 | Case Street Early Learning Center at DTZ | Program | 2019 | pk_12_total | 10 | 18 | 18 | * | * | * | 9 | 25 | 35 | 0 | * | 60 | 10 | 18 | 18 | 9 | 25 | 35 | 0 | 60 | |||||||||||||||||||||||||||||||||||||||
2452546 | 2452546 | CT | school | 1040011 | Norwich School District | 1040511 | Special Needs Program @ Mahan | Program | 2019 | pk_12_total | * | * | 6 | 0 | * | 0 | * | 6 | 6 | * | 12 | 12 | 6 | 0 | 0 | 6 | 6 | 12 | 12 | |||||||||||||||||||||||||||||||||||||||||
2452547 | 2452547 | CT | school | 903120 | 1040011 | Norwich School District | 90312000675 | 1041711 | Thomas W. Mahan School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 67 | 40 | 45 | 0 | 67 | 0 | 17 | 117 | 119 | 47 | 28 | 236 | 67 | 40 | 45 | 0 | 67 | 0 | 17 | 117 | 119 | 47 | 28 | 236 | |||||||||||||||||||||||||||||
2452548 | 2452548 | CT | school | 903120 | 1040011 | Norwich School District | 90312000667 | 1041411 | John B. Stanton School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 68 | 57 | 136 | * | 23 | * | 32 | 172 | 147 | 83 | 46 | 319 | 68 | 57 | 136 | 23 | 32 | 172 | 147 | 83 | 46 | 319 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2452551 | 2452551 | CT | school | 1040011 | Norwich School District | 1040911 | Stanton Special Learning Center | Program | 2019 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 6 | 6 | ||||||||||||||||||||||||||||||||||||||
2452552 | 2452552 | CT | school | 1040011 | Norwich School District | 1040411 | Strive Autism Program @ Huntington | Program | 2019 | pk_12_total | 7 | * | 6 | 0 | * | 0 | * | * | * | 8 | 21 | 21 | 7 | 6 | 0 | 0 | 8 | 21 | 21 | |||||||||||||||||||||||||||||||||||||||||
2452553 | 2452553 | CT | school | 1040011 | Norwich School District | 1041211 | Strive Program @ Stanton | Program | 2019 | pk_12_total | * | * | * | 0 | 0 | 0 | 0 | * | * | * | 6 | 6 | 0 | 0 | 0 | 0 | 6 | 6 | ||||||||||||||||||||||||||||||||||||||||||
2452554 | 2452554 | CT | school | 903120 | 1040011 | Norwich School District | 90312000676 | 1041911 | Uncas Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 51 | 70 | 111 | 0 | * | * | 19 | 131 | 135 | 82 | 34 | 266 | 51 | 70 | 111 | 0 | 19 | 131 | 135 | 82 | 34 | 266 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452556 | 2452556 | CT | school | 903120 | 1040011 | Norwich School District | 90312000678 | 1041511 | Wequonnoc Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 71 | 43 | 103 | * | * | * | 37 | 139 | 120 | 52 | 37 | 259 | 71 | 43 | 103 | 37 | 139 | 120 | 52 | 37 | 259 | ||||||||||||||||||||||||||||||||
2452557 | 2452557 | CT | school | 903120 | 1040011 | Norwich School District | 90312000670 | 1045111 | Kelly STEAM Magnet Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 182 | 109 | 226 | 0 | * | * | 70 | 316 | 315 | 84 | 78 | 631 | 182 | 109 | 226 | 0 | 70 | 316 | 315 | 84 | 78 | 631 | |||||||||||||||||||||||||||||||
2452558 | 2452558 | CT | school | 1040011 | Norwich School District | 1041111 | Strive Program @ Kelly | Program | 2019 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | * | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | |||||||||||||||||||||||||||||||||||||||||
2452559 | 2452559 | CT | school | 903120 | 1040011 | Norwich School District | 90312000674 | 1045211 | Teachers' Memorial Global Studies Magnet Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 102 | 77 | 137 | * | 26 | * | 40 | 191 | 194 | 54 | 99 | 385 | 102 | 77 | 137 | 26 | 40 | 191 | 194 | 54 | 99 | 385 | |||||||||||||||||||||||||||||||
2452560 | 2452560 | CT | school | 1040011 | Norwich School District | 90312001622 | 1049211 | Virtual Learning Academy | Program | 2019 | pk_12_total | * | 8 | 6 | 0 | 0 | 0 | * | 13 | 6 | 0 | 10 | 19 | 8 | 6 | 0 | 0 | 0 | 13 | 6 | 0 | 10 | 19 | |||||||||||||||||||||||||||||||||||||
2452561 | 2452561 | CT | school | 1040011 | Norwich School District | 1041011 | Transition Academy | Program | 2019 | pk_12_total | 16 | * | * | 0 | * | 0 | * | 14 | 9 | * | 23 | 23 | 16 | 0 | 0 | 14 | 9 | 23 | 23 | |||||||||||||||||||||||||||||||||||||||||
2452562 | 2452562 | CT | school | 903180 | 1060011 | Old Saybrook School District | 90318000681 | 1060211 | Kathleen E. Goodwin School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 238 | * | 49 | 0 | 10 | * | 16 | 164 | 153 | 31 | 33 | 317 | 238 | 49 | 0 | 10 | 16 | 164 | 153 | 31 | 33 | 317 | |||||||||||||||||||||||||||||||
2452563 | 2452563 | CT | school | 903180 | 1060011 | Old Saybrook School District | 90318000007 | 1065211 | Old Saybrook Middle School | Public Schools | Regular School | No | Middle | 04 | 08 | 2019 | pk_12_total | 383 | 0 | 48 | 0 | 15 | * | * | 226 | 232 | 22 | 65 | 458 | 383 | 0 | 48 | 0 | 15 | 226 | 232 | 22 | 65 | 458 | |||||||||||||||||||||||||||||||
2452564 | 2452564 | CT | school | 903180 | 1060011 | Old Saybrook School District | 90318000684 | 1066111 | Old Saybrook Senior High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 362 | 11 | 32 | 0 | 20 | 0 | 12 | 210 | 227 | 6 | 57 | 437 | 362 | 11 | 32 | 0 | 20 | 0 | 12 | 210 | 227 | 6 | 57 | 437 | |||||||||||||||||||||||||||||
2452565 | 2452565 | CT | school | 903210 | 1070011 | Orange School District | 90321001225 | 1070211 | Mary L. Tracy School | Public Schools | Regular School | No | Elementary | PK | KG | 2019 | pk_12_total | 143 | * | 14 | 0 | 22 | 0 | * | 86 | 105 | 9 | 25 | 191 | 143 | 14 | 0 | 22 | 0 | 86 | 105 | 9 | 25 | 191 | |||||||||||||||||||||||||||||||
2452566 | 2452566 | CT | school | 903210 | 1070011 | Orange School District | 90321000687 | 1070511 | Peck Place School | Public Schools | Regular School | No | Elementary | 01 | 06 | 2019 | pk_12_total | 255 | * | 14 | 0 | 48 | * | 16 | 183 | 157 | 15 | 22 | 340 | 255 | 14 | 0 | 48 | 16 | 183 | 157 | 15 | 22 | 340 | |||||||||||||||||||||||||||||||
2452567 | 2452567 | CT | school | 903210 | 1070011 | Orange School District | 90321000688 | 1070311 | Race Brook School | Public Schools | Regular School | No | Elementary | 01 | 06 | 2019 | pk_12_total | 243 | * | 31 | * | 53 | 0 | 18 | 196 | 160 | 27 | 29 | 356 | 243 | 31 | 53 | 0 | 18 | 196 | 160 | 27 | 29 | 356 | |||||||||||||||||||||||||||||||
2452568 | 2452568 | CT | school | 903210 | 1070011 | Orange School District | 90321000689 | 1070411 | Turkey Hill School | Public Schools | Regular School | No | Elementary | 01 | 06 | 2019 | pk_12_total | 231 | 0 | 16 | * | 36 | 0 | * | 152 | 141 | 13 | 26 | 293 | 231 | 0 | 16 | 36 | 0 | 152 | 141 | 13 | 26 | 293 | |||||||||||||||||||||||||||||||
2452569 | 2452569 | CT | school | 903240 | 1080011 | Oxford School District | 90324000002 | 1080311 | Quaker Farms School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 313 | * | 34 | * | 10 | * | * | 201 | 164 | 10 | 40 | 365 | 313 | 34 | 10 | 201 | 164 | 10 | 40 | 365 | |||||||||||||||||||||||||||||||||
2452570 | 2452570 | CT | school | 903240 | 1080011 | Oxford School District | 90324000691 | 1080111 | Oxford Center School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 327 | * | 40 | 0 | * | 0 | 10 | 196 | 190 | 14 | 42 | 386 | 327 | 40 | 0 | 0 | 10 | 196 | 190 | 14 | 42 | 386 | |||||||||||||||||||||||||||||||
2452571 | 2452571 | CT | school | 903240 | 1080011 | Oxford School District | 90324000690 | 1085111 | Oxford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 428 | * | 33 | * | 11 | 0 | * | 233 | 250 | * | 58 | 483 | 428 | 33 | 11 | 0 | 233 | 250 | 58 | 483 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2452573 | 2452573 | CT | school | 1080011 | Oxford School District | 1080411 | Connections Alternative Learning Center | Program | 2019 | pk_12_total | 6 | 0 | 0 | 0 | 0 | 0 | 0 | * | * | 0 | * | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | |||||||||||||||||||||||||||||||||||||||
2452574 | 2452574 | CT | school | 1090011 | Plainfield School District | 90327001586 | 1098011 | Early Childhood Center | Program | 2019 | pk_12_total | 11 | * | * | 0 | * | 0 | * | 11 | 7 | 0 | 0 | 18 | 11 | 0 | 0 | 11 | 7 | 0 | 0 | 18 | |||||||||||||||||||||||||||||||||||||||
2452575 | 2452575 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000047 | 1090411 | Shepard Hill Elementary School | Public Schools | Regular School | No | Elementary | PK | 03 | 2019 | pk_12_total | 334 | 14 | 44 | * | 13 | * | 6 | 224 | 196 | 14 | 81 | 420 | 334 | 14 | 44 | 13 | 6 | 224 | 196 | 14 | 81 | 420 | |||||||||||||||||||||||||||||||
2452576 | 2452576 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000692 | 1090111 | Moosup Elementary School | Public Schools | Regular School | No | Elementary | KG | 03 | 2019 | pk_12_total | 259 | 10 | 23 | 0 | * | * | * | 139 | 162 | * | 29 | 301 | 259 | 10 | 23 | 0 | 139 | 162 | 29 | 301 | |||||||||||||||||||||||||||||||||
2452577 | 2452577 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000696 | 1090311 | Plainfield Memorial School | Public Schools | Regular School | No | Elementary | 04 | 05 | 2019 | pk_12_total | 273 | 12 | 16 | * | 6 | * | * | 155 | 159 | 9 | 45 | 314 | 273 | 12 | 16 | 6 | 155 | 159 | 9 | 45 | 314 | ||||||||||||||||||||||||||||||||
2452578 | 2452578 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000693 | 1095111 | Plainfield Central School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 442 | 32 | 21 | 7 | * | * | * | 249 | 262 | 6 | 79 | 511 | 442 | 32 | 21 | 7 | 249 | 262 | 6 | 79 | 511 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2452580 | 2452580 | CT | school | 903300 | 1100011 | Plainville School District | 90330000699 | 1100411 | Frank T. Wheeler School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 210 | 15 | 64 | * | * | 0 | 13 | 168 | 143 | 47 | 37 | 311 | 210 | 15 | 64 | 0 | 13 | 168 | 143 | 47 | 37 | 311 | |||||||||||||||||||||||||||||||
2452581 | 2452581 | CT | school | 903300 | 1100011 | Plainville School District | 90330000701 | 1100211 | Linden Street School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 261 | 21 | 93 | 0 | 12 | 0 | 16 | 195 | 208 | 57 | 49 | 403 | 261 | 21 | 93 | 0 | 12 | 0 | 16 | 195 | 208 | 57 | 49 | 403 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452583 | 2452583 | CT | school | 903300 | 1100011 | Plainville School District | 90330000048 | 1105211 | Middle School of Plainville | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 358 | * | 103 | * | 19 | 0 | 23 | 269 | 254 | 21 | 71 | 523 | 358 | 103 | 19 | 0 | 23 | 269 | 254 | 21 | 71 | 523 | |||||||||||||||||||||||||||||||
2452584 | 2452584 | CT | school | 903300 | 1100011 | Plainville School District | 90330000703 | 1106111 | Plainville High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 504 | 36 | 121 | * | * | 0 | 24 | 371 | 330 | 18 | 77 | 701 | 504 | 36 | 121 | 0 | 24 | 371 | 330 | 18 | 77 | 701 | |||||||||||||||||||||||||||||||
2452585 | 2452585 | CT | school | 1100011 | Plainville School District | 1100111 | Plainville Transition Program | Program | 2019 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | ||||||||||||||||||||||||||||||||||||||||
2451740 | 2451740 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001565 | 110811 | Wintonbury Early Childhood Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 115 | 120 | 37 | * | 25 | 0 | * | 170 | 149 | 0 | 44 | 319 | 115 | 120 | 37 | 25 | 0 | 170 | 149 | 0 | 44 | 319 | |||||||||||||||||||||||||||||||
2451741 | 2451741 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000032 | 110611 | Laurel School | Public Schools | Regular School | No | Elementary | KG | 02 | 2019 | pk_12_total | 19 | 273 | 28 | * | * | 0 | 22 | 167 | 187 | 21 | 46 | 354 | 19 | 273 | 28 | 0 | 22 | 167 | 187 | 21 | 46 | 354 | |||||||||||||||||||||||||||||||
2451742 | 2451742 | CT | school | 110011 | Bloomfield School District | 110111 | Steps to Success | Program | 2019 | pk_12_total | * | * | 0 | 0 | 0 | 0 | * | 7 | 0 | 0 | 7 | 7 | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 7 | 7 | |||||||||||||||||||||||||||||||||||||||
2451743 | 2451743 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000033 | 110511 | Metacomet School | Public Schools | Regular School | No | Elementary | 03 | 04 | 2019 | pk_12_total | 8 | 213 | 28 | * | * | 0 | 10 | 129 | 134 | 8 | 45 | 263 | 8 | 213 | 28 | 0 | 10 | 129 | 134 | 8 | 45 | 263 | |||||||||||||||||||||||||||||||
2451744 | 2451744 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001375 | 110711 | Carmen Arace Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 8 | 207 | 23 | 0 | * | * | 6 | 123 | 123 | * | 45 | 246 | 8 | 207 | 23 | 0 | 6 | 123 | 123 | 45 | 246 | ||||||||||||||||||||||||||||||||
2451745 | 2451745 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001615 | 116311 | Global Experience Magnet School | Public Schools | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 44 | 107 | 39 | * | * | 0 | 11 | 77 | 127 | 12 | 33 | 204 | 44 | 107 | 39 | 0 | 11 | 77 | 127 | 12 | 33 | 204 | |||||||||||||||||||||||||||||||
2451746 | 2451746 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000034 | 115211 | Carmen Arace Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 8 | 173 | 25 | * | * | 0 | 13 | 127 | 96 | * | 45 | 223 | 8 | 173 | 25 | 0 | 13 | 127 | 96 | 45 | 223 | ||||||||||||||||||||||||||||||||
2451747 | 2451747 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000029 | 116111 | Bloomfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 13 | 456 | 56 | * | * | 0 | 17 | 287 | 260 | 14 | 97 | 547 | 13 | 456 | 56 | 0 | 17 | 287 | 260 | 14 | 97 | 547 | |||||||||||||||||||||||||||||||
2451748 | 2451748 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001619 | 116411 | Learning Academy at Bloomfield | Alternative School | No | High | 09 | 12 | 2019 | pk_12_total | 0 | * | * | 0 | 0 | 0 | 0 | * | * | 0 | * | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | |||||||||||||||||||||||||||||||||||
2452586 | 2452586 | CT | school | 903330 | 1110011 | Plymouth School District | 90333000706 | 1110211 | Plymouth Center School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 270 | * | 34 | 0 | 0 | 0 | * | 158 | 156 | * | 56 | 314 | 270 | 34 | 0 | 0 | 0 | 158 | 156 | 56 | 314 | ||||||||||||||||||||||||||||||||
2452587 | 2452587 | CT | school | 903330 | 1110011 | Plymouth School District | 90333001521 | 1110411 | Harry S. Fisher Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 261 | * | 51 | 0 | * | 0 | 18 | 180 | 157 | 8 | 58 | 337 | 261 | 51 | 0 | 0 | 18 | 180 | 157 | 8 | 58 | 337 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452589 | 2452589 | CT | school | 903330 | 1110011 | Plymouth School District | 90333001199 | 1116111 | Terryville High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 356 | * | 34 | 0 | * | 0 | 12 | 211 | 203 | * | 61 | 414 | 356 | 34 | 0 | 0 | 12 | 211 | 203 | 61 | 414 | ||||||||||||||||||||||||||||||||
2452590 | 2452590 | CT | school | 903360 | 1120011 | Pomfret School District | 90336000709 | 1120111 | Pomfret Community School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 338 | * | 19 | 0 | 15 | * | * | 208 | 171 | * | 38 | 379 | 338 | 19 | 0 | 15 | 208 | 171 | 38 | 379 | |||||||||||||||||||||||||||||||||
2452591 | 2452591 | CT | school | 903390 | 1130011 | Portland School District | 90339000714 | 1130211 | Valley View School | Public Schools | Regular School | No | Elementary | PK | 01 | 2019 | pk_12_total | 159 | * | 34 | 0 | * | 0 | 14 | 115 | 96 | 12 | 27 | 211 | 159 | 34 | 0 | 0 | 14 | 115 | 96 | 12 | 27 | 211 | |||||||||||||||||||||||||||||||
2452592 | 2452592 | CT | school | 903390 | 1130011 | Portland School District | 90339000711 | 1130411 | Gildersleeve School | Public Schools | Regular School | No | Elementary | 02 | 04 | 2019 | pk_12_total | 215 | * | 47 | 0 | * | 0 | 20 | 153 | * | 13 | 35 | 293 | 215 | 47 | 0 | 0 | 20 | 153 | 13 | 35 | 293 | ||||||||||||||||||||||||||||||||
2452593 | 2452593 | CT | school | 903390 | 1130011 | Portland School District | 90339001393 | 1130511 | Brownstone Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 162 | * | 27 | 0 | * | 0 | 14 | 107 | 107 | * | 24 | 214 | 162 | 27 | 0 | 0 | 14 | 107 | 107 | 24 | 214 | ||||||||||||||||||||||||||||||||
2452594 | 2452594 | CT | school | 903390 | 1130011 | Portland School District | 90339000713 | 1135111 | Portland Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 157 | * | 27 | 0 | * | 0 | 12 | 105 | 100 | * | 23 | 205 | 157 | 27 | 0 | 0 | 12 | 105 | 100 | 23 | 205 | ||||||||||||||||||||||||||||||||
2452595 | 2452595 | CT | school | 903390 | 1130011 | Portland School District | 90339000712 | 1136111 | Portland High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 315 | 16 | 35 | * | * | 0 | 19 | 199 | 192 | 0 | 41 | 391 | 315 | 16 | 35 | 0 | 19 | 199 | 192 | 0 | 41 | 391 | |||||||||||||||||||||||||||||||
2452596 | 2452596 | CT | school | 903420 | 1140011 | Preston School District | 90342001466 | 1140411 | Preston Veterans' Memorial School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 246 | 8 | 22 | 0 | * | * | 7 | 161 | 134 | 6 | 46 | 295 | 246 | 8 | 22 | 0 | 7 | 161 | 134 | 6 | 46 | 295 | |||||||||||||||||||||||||||||||
2452597 | 2452597 | CT | school | 903420 | 1140011 | Preston School District | 90342000717 | 1145111 | Preston Plains School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 113 | * | 11 | * | * | 0 | 8 | 66 | 79 | * | 24 | 145 | 113 | 11 | 0 | 8 | 66 | 79 | 24 | 145 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2452600 | 2452600 | CT | school | 903480 | 1160011 | Putnam School District | 90348000719 | 1166111 | Putnam High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 221 | 7 | 31 | 0 | * | * | 12 | 122 | 152 | 8 | 45 | 274 | 221 | 7 | 31 | 0 | 12 | 122 | 152 | 8 | 45 | 274 | |||||||||||||||||||||||||||||||
2452601 | 2452601 | CT | school | 1160011 | Putnam School District | 90348001518 | 1169011 | Helping Hands | Program | 2019 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | |||||||||||||||||||||||||||||||||||||||
2452602 | 2452602 | CT | school | 903510 | 1170011 | Redding School District | 90351000722 | 1170111 | Redding Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 384 | 9 | 47 | * | 10 | * | 13 | 236 | 229 | 8 | 90 | 465 | 384 | 9 | 47 | 10 | 13 | 236 | 229 | 8 | 90 | 465 |
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]);