enrollments
Data source: Big Local News · About: Big Local
1,461 rows where grade = "pk_12_total", state = "CT" and year = 2020 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2778534 | 2778534 | CT | school | 903000 | 1000011 | North Canaan School District | 90300000626 | 1000111 | North Canaan Elementary School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 206 | * | 32 | 0 | * | 0 | 12 | 129 | 124 | 9 | 40 | 253 | 206 | 32 | 0 | 0 | 12 | 129 | 124 | 9 | 40 | 253 | |||||||||||||||||||||||||||||||
2777725 | 2777725 | CT | school | 900030 | 10011 | Andover School District | 90003010001 | 10111 | Andover Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 158 | * | 24 | 0 | 0 | 0 | * | 99 | 96 | * | 21 | 195 | 158 | 24 | 0 | 0 | 0 | 99 | 96 | 21 | 195 | ||||||||||||||||||||||||||||||||
2778535 | 2778535 | CT | school | 903030 | 1010011 | North Haven School District | 90303000627 | 1010811 | Clintonville Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 261 | 10 | 40 | * | * | 0 | 15 | 175 | 161 | 11 | 17 | 336 | 261 | 10 | 40 | 0 | 15 | 175 | 161 | 11 | 17 | 336 | |||||||||||||||||||||||||||||||
2778536 | 2778536 | CT | school | 903030 | 1010011 | North Haven School District | 90303000628 | 1010711 | Green Acres Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 285 | 25 | 37 | 0 | 38 | 0 | 16 | 189 | 212 | 35 | 56 | 401 | 285 | 25 | 37 | 0 | 38 | 0 | 16 | 189 | 212 | 35 | 56 | 401 | |||||||||||||||||||||||||||||
2778537 | 2778537 | CT | school | 903030 | 1010011 | North Haven School District | 90303000630 | 1010211 | Montowese Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 212 | * | 24 | * | 23 | 0 | 7 | 145 | 129 | 16 | 32 | 274 | 212 | 24 | 23 | 0 | 7 | 145 | 129 | 16 | 32 | 274 | |||||||||||||||||||||||||||||||
2778538 | 2778538 | CT | school | 903030 | 1010011 | North Haven School District | 90303000633 | 1010311 | Ridge Road Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 276 | 26 | 47 | * | 28 | 0 | * | 195 | 203 | 15 | 42 | 398 | 276 | 26 | 47 | 28 | 0 | 195 | 203 | 15 | 42 | 398 | |||||||||||||||||||||||||||||||
2778539 | 2778539 | CT | school | 903030 | 1010011 | North Haven School District | 90303000632 | 1015211 | North Haven Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 559 | 27 | 67 | 0 | 60 | 0 | 25 | 385 | 353 | 11 | 101 | 738 | 559 | 27 | 67 | 0 | 60 | 0 | 25 | 385 | 353 | 11 | 101 | 738 | |||||||||||||||||||||||||||||
2778540 | 2778540 | CT | school | 903030 | 1010011 | North Haven School District | 90303000631 | 1016111 | North Haven High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 778 | 43 | 85 | * | 63 | 0 | * | 502 | 498 | 12 | 108 | 1000 | 778 | 43 | 85 | 63 | 0 | 502 | 498 | 12 | 108 | 1000 | |||||||||||||||||||||||||||||||
2778541 | 2778541 | CT | school | 1010011 | North Haven School District | 90303001733 | 1010111 | North Haven Transition Partnership | Program | 2020 | pk_12_total | 10 | 0 | * | 0 | * | 0 | 0 | * | * | 0 | 13 | 13 | 10 | 0 | 0 | 0 | 0 | 0 | 13 | 13 | |||||||||||||||||||||||||||||||||||||||
2778542 | 2778542 | CT | school | 903060 | 1020011 | North Stonington School District | 90306000634 | 1020111 | North Stonington Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 377 | 8 | 21 | 6 | 11 | * | * | 217 | 210 | 0 | 42 | 427 | 377 | 8 | 21 | 6 | 11 | 217 | 210 | 0 | 42 | 427 | |||||||||||||||||||||||||||||||
2778543 | 2778543 | CT | school | 903060 | 1020011 | North Stonington School District | 90306000635 | 1026111 | Wheeler High School | Public Schools | Regular School | No | High | 07 | 12 | 2020 | pk_12_total | 269 | * | 12 | * | 6 | * | 18 | 175 | 139 | 0 | 27 | 314 | 269 | 12 | 6 | 18 | 175 | 139 | 0 | 27 | 314 | ||||||||||||||||||||||||||||||||
2778544 | 2778544 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000640 | 1030211 | Brookside Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 44 | 58 | 304 | 0 | * | * | 15 | 227 | 208 | 116 | 63 | 435 | 44 | 58 | 304 | 0 | 15 | 227 | 208 | 116 | 63 | 435 | |||||||||||||||||||||||||||||||
2778545 | 2778545 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000645 | 1032011 | Fox Run Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 117 | 84 | 157 | * | * | 0 | 21 | 198 | 204 | 52 | 56 | 402 | 117 | 84 | 157 | 0 | 21 | 198 | 204 | 52 | 56 | 402 | |||||||||||||||||||||||||||||||
2778546 | 2778546 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000648 | 1030711 | Jefferson Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 32 | 67 | 331 | * | 53 | 0 | * | 293 | 211 | 140 | 55 | 504 | 32 | 67 | 331 | 53 | 0 | 293 | 211 | 140 | 55 | 504 | |||||||||||||||||||||||||||||||
2778547 | 2778547 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000649 | 1030811 | Kendall Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 48 | 75 | 336 | 0 | 25 | 0 | 19 | 246 | 257 | 174 | 52 | 503 | 48 | 75 | 336 | 0 | 25 | 0 | 19 | 246 | 257 | 174 | 52 | 503 | |||||||||||||||||||||||||||||
2778548 | 2778548 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000652 | 1032111 | Naramake Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 129 | 49 | 181 | 0 | 11 | 0 | 17 | 191 | 196 | 63 | 50 | 387 | 129 | 49 | 181 | 0 | 11 | 0 | 17 | 191 | 196 | 63 | 50 | 387 | |||||||||||||||||||||||||||||
2778549 | 2778549 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001914 | 1030111 | Norwalk Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 53 | 15 | 67 | * | 12 | 0 | * | 84 | 71 | 0 | 92 | 155 | 53 | 15 | 67 | 12 | 0 | 84 | 71 | 0 | 92 | 155 | |||||||||||||||||||||||||||||||
2778550 | 2778550 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000642 | 1030311 | Columbus Magnet School | Public Schools | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 137 | 67 | 110 | * | 17 | * | 12 | 179 | 168 | 31 | 46 | 347 | 137 | 67 | 110 | 17 | 12 | 179 | 168 | 31 | 46 | 347 | |||||||||||||||||||||||||||||||
2778551 | 2778551 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000643 | 1030411 | Cranbury Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 198 | 48 | 147 | 0 | 29 | * | * | 219 | 217 | 75 | 67 | 436 | 198 | 48 | 147 | 0 | 29 | 219 | 217 | 75 | 67 | 436 | |||||||||||||||||||||||||||||||
2778552 | 2778552 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000651 | 1032211 | Marvin Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 115 | 51 | 218 | 0 | 24 | 0 | 14 | 221 | 201 | 97 | 57 | 422 | 115 | 51 | 218 | 0 | 24 | 0 | 14 | 221 | 201 | 97 | 57 | 422 | |||||||||||||||||||||||||||||
2778553 | 2778553 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000658 | 1031311 | Rowayton School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 239 | 41 | 173 | * | 9 | * | 27 | 235 | 256 | 61 | 54 | 491 | 239 | 41 | 173 | 9 | 27 | 235 | 256 | 61 | 54 | 491 | |||||||||||||||||||||||||||||||
2778554 | 2778554 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000659 | 1032311 | Silvermine Dual Language Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 51 | 46 | 380 | 0 | * | * | 13 | 265 | 231 | 171 | 55 | 496 | 51 | 46 | 380 | 0 | 13 | 265 | 231 | 171 | 55 | 496 | |||||||||||||||||||||||||||||||
2778555 | 2778555 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000660 | 1031411 | Tracey Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 69 | 67 | 249 | 0 | 31 | 0 | 19 | 248 | 187 | 121 | 76 | 435 | 69 | 67 | 249 | 0 | 31 | 0 | 19 | 248 | 187 | 121 | 76 | 435 | |||||||||||||||||||||||||||||
2778556 | 2778556 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000662 | 1032411 | Wolfpit School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 98 | 45 | 124 | * | 16 | 0 | * | 160 | 140 | 54 | 36 | 300 | 98 | 45 | 124 | 16 | 0 | 160 | 140 | 54 | 36 | 300 | |||||||||||||||||||||||||||||||
2778557 | 2778557 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000653 | 1035211 | Nathan Hale Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 201 | 91 | 293 | 0 | 30 | 0 | 12 | 342 | 285 | 60 | 103 | 627 | 201 | 91 | 293 | 0 | 30 | 0 | 12 | 342 | 285 | 60 | 103 | 627 | |||||||||||||||||||||||||||||
2778558 | 2778558 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000656 | 1035311 | Ponus Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 91 | 109 | 418 | * | 37 | 0 | * | 346 | 325 | 123 | 101 | 671 | 91 | 109 | 418 | 37 | 0 | 346 | 325 | 123 | 101 | 671 | |||||||||||||||||||||||||||||||
2778559 | 2778559 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000657 | 1035511 | Roton Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 193 | 74 | 278 | 0 | 16 | * | * | 317 | 261 | 58 | 86 | 578 | 193 | 74 | 278 | 0 | 16 | 317 | 261 | 58 | 86 | 578 | |||||||||||||||||||||||||||||||
2778560 | 2778560 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000661 | 1035411 | West Rocks Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 166 | 123 | 385 | * | 32 | 0 | * | 368 | 348 | 114 | 100 | 716 | 166 | 123 | 385 | 32 | 0 | 368 | 348 | 114 | 100 | 716 | |||||||||||||||||||||||||||||||
2778561 | 2778561 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000638 | 1036211 | Brien McMahon High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 357 | 272 | 897 | 0 | 56 | 0 | 29 | 820 | 791 | 268 | 209 | 1611 | 357 | 272 | 897 | 0 | 56 | 0 | 29 | 820 | 791 | 268 | 209 | 1611 | |||||||||||||||||||||||||||||
2778562 | 2778562 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001917 | 1030511 | Center for Global Studies | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 120 | 38 | 83 | 0 | 29 | 0 | 7 | 90 | 187 | * | 10 | 277 | 120 | 38 | 83 | 0 | 29 | 0 | 7 | 90 | 187 | 10 | 277 | ||||||||||||||||||||||||||||||
2778563 | 2778563 | CT | school | 1030011 | Norwalk School District | 1031011 | Norwalk Alternative Opportunity Program | Program | 2020 | pk_12_total | * | * | * | 0 | * | 0 | * | * | * | * | * | 8 | 0 | 0 | 8 | |||||||||||||||||||||||||||||||||||||||||||||
2778564 | 2778564 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000655 | 1036111 | Norwalk High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 435 | 244 | 699 | * | 45 | 0 | * | 765 | * | 245 | 232 | 1445 | 435 | 244 | 699 | 45 | 0 | 765 | 245 | 232 | 1445 | ||||||||||||||||||||||||||||||||
2778565 | 2778565 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001923 | 1030911 | P-TECH Norwalk | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 100 | 84 | 157 | * | 27 | * | * | 197 | * | 12 | 21 | 374 | 100 | 84 | 157 | 27 | 197 | 12 | 21 | 374 | |||||||||||||||||||||||||||||||||
2778566 | 2778566 | CT | school | 1030011 | Norwalk School District | 1031111 | Norwalk 18-21 Next Steps (NNS) | Program | 2020 | pk_12_total | * | 7 | * | 0 | 0 | 0 | 0 | 8 | 6 | * | 14 | 14 | 7 | 0 | 0 | 0 | 0 | 8 | 6 | 14 | 14 | |||||||||||||||||||||||||||||||||||||||
2778567 | 2778567 | CT | school | 1030011 | Norwalk School District | 1030611 | Norwalk 18-21 Project SEARCH | Program | 2020 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | * | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | |||||||||||||||||||||||||||||||||||||||||
2778568 | 2778568 | CT | school | 903120 | 1040011 | Norwich School District | 90312000663 | 1040111 | Bishop School Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 54 | 34 | 66 | * | 10 | * | 12 | 97 | 81 | 0 | 61 | 178 | 54 | 34 | 66 | 10 | 12 | 97 | 81 | 0 | 61 | 178 | |||||||||||||||||||||||||||||||
2778569 | 2778569 | CT | school | 1040011 | Norwich School District | 90312001745 | 1040211 | Case Street Early Learning Center at DTZ | Program | 2020 | pk_12_total | * | 23 | 21 | 0 | * | 0 | 9 | 29 | 34 | 0 | * | 63 | 23 | 21 | 0 | 0 | 9 | 29 | 34 | 0 | 63 | ||||||||||||||||||||||||||||||||||||||
2778570 | 2778570 | CT | school | 903120 | 1040011 | Norwich School District | 90312000675 | 1041711 | Thomas W. Mahan School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 77 | 36 | 41 | 0 | 71 | 0 | 17 | 128 | 114 | 53 | 32 | 242 | 77 | 36 | 41 | 0 | 71 | 0 | 17 | 128 | 114 | 53 | 32 | 242 | |||||||||||||||||||||||||||||
2778571 | 2778571 | CT | school | 903120 | 1040011 | Norwich School District | 90312000667 | 1041411 | John B. Stanton School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 63 | 54 | 137 | * | 20 | * | 33 | 158 | 153 | 90 | 54 | 311 | 63 | 54 | 137 | 20 | 33 | 158 | 153 | 90 | 54 | 311 | |||||||||||||||||||||||||||||||
2778572 | 2778572 | CT | school | 903120 | 1040011 | Norwich School District | 90312000668 | 1042011 | Moriarty Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 162 | 56 | 133 | 0 | 19 | 0 | 27 | 196 | 201 | 73 | 53 | 397 | 162 | 56 | 133 | 0 | 19 | 0 | 27 | 196 | 201 | 73 | 53 | 397 | |||||||||||||||||||||||||||||
2778573 | 2778573 | CT | school | 903120 | 1040011 | Norwich School District | 90312000672 | 1040811 | Samuel Huntington School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 144 | 70 | 95 | 0 | * | * | 47 | 190 | * | 53 | 41 | 376 | 144 | 70 | 95 | 0 | 47 | 190 | 53 | 41 | 376 | ||||||||||||||||||||||||||||||||
2778574 | 2778574 | CT | school | 903120 | 1040011 | Norwich School District | 90312000676 | 1041911 | Uncas Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 52 | 63 | 108 | 0 | * | * | 23 | 133 | 125 | 74 | 40 | 258 | 52 | 63 | 108 | 0 | 23 | 133 | 125 | 74 | 40 | 258 | |||||||||||||||||||||||||||||||
2778575 | 2778575 | CT | school | 903120 | 1040011 | Norwich School District | 90312000677 | 1041811 | Veterans' Memorial School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 83 | 57 | 107 | * | 15 | * | 32 | 151 | 147 | 71 | 34 | 298 | 83 | 57 | 107 | 15 | 32 | 151 | 147 | 71 | 34 | 298 | |||||||||||||||||||||||||||||||
2778576 | 2778576 | CT | school | 903120 | 1040011 | Norwich School District | 90312000678 | 1041511 | Wequonnoc Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 67 | 50 | 103 | * | * | * | 38 | 132 | 132 | 53 | 40 | 264 | 67 | 50 | 103 | 38 | 132 | 132 | 53 | 40 | 264 | ||||||||||||||||||||||||||||||||
2778577 | 2778577 | CT | school | 1040011 | Norwich School District | 1040511 | Special Needs Program @ Mahan | Program | 2020 | pk_12_total | * | 0 | * | 0 | * | 0 | 0 | * | * | * | 8 | 8 | 0 | 0 | 0 | 0 | 8 | 8 | ||||||||||||||||||||||||||||||||||||||||||
2778578 | 2778578 | CT | school | 1040011 | Norwich School District | 1040911 | Stanton Special Learning Center | Program | 2020 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||
2778579 | 2778579 | CT | school | 1040011 | Norwich School District | 1040411 | Strive Autism Program @ Huntington | Program | 2020 | pk_12_total | * | * | * | 0 | * | 0 | 0 | * | * | * | 11 | 11 | 0 | 0 | 0 | 11 | 11 | |||||||||||||||||||||||||||||||||||||||||||
2778580 | 2778580 | CT | school | 1040011 | Norwich School District | 1041211 | Strive Program @ Stanton | Program | 2020 | pk_12_total | 0 | * | * | 0 | 0 | 0 | 0 | * | * | * | * | * | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||
2778581 | 2778581 | CT | school | 903120 | 1040011 | Norwich School District | 90312000670 | 1045111 | Kelly STEAM Magnet Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 180 | 115 | 239 | * | 31 | * | 70 | 324 | 314 | 86 | 72 | 638 | 180 | 115 | 239 | 31 | 70 | 324 | 314 | 86 | 72 | 638 | |||||||||||||||||||||||||||||||
2778582 | 2778582 | CT | school | 1040011 | Norwich School District | 1041111 | Strive Program @ Kelly | Program | 2020 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | * | 9 | 9 | 0 | 0 | 0 | 0 | 0 | 9 | 9 | |||||||||||||||||||||||||||||||||||||||||
2778583 | 2778583 | CT | school | 903120 | 1040011 | Norwich School District | 90312000674 | 1045211 | Teachers' Memorial Global Studies Magnet Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 104 | 71 | 143 | * | 25 | * | 44 | 202 | 194 | 66 | 100 | 396 | 104 | 71 | 143 | 25 | 44 | 202 | 194 | 66 | 100 | 396 | |||||||||||||||||||||||||||||||
2778584 | 2778584 | CT | school | 1040011 | Norwich School District | 90312001622 | 1049211 | Virtual Learning Academy | Program | 2020 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | * | * | 7 | 0 | 0 | 0 | 0 | 0 | 7 | |||||||||||||||||||||||||||||||||||||||||
2778585 | 2778585 | CT | school | 1040011 | Norwich School District | 1041011 | Transition Academy | Program | 2020 | pk_12_total | 11 | * | * | 0 | * | 0 | * | 14 | 9 | * | 23 | 23 | 11 | 0 | 0 | 14 | 9 | 23 | 23 | |||||||||||||||||||||||||||||||||||||||||
2778586 | 2778586 | CT | school | 903180 | 1060011 | Old Saybrook School District | 90318000681 | 1060211 | Kathleen E. Goodwin School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 294 | * | 69 | 0 | 12 | * | 16 | 215 | 181 | 41 | 51 | 396 | 294 | 69 | 0 | 12 | 16 | 215 | 181 | 41 | 51 | 396 | |||||||||||||||||||||||||||||||
2778587 | 2778587 | CT | school | 903180 | 1060011 | Old Saybrook School District | 90318000007 | 1065211 | Old Saybrook Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | pk_12_total | 308 | 0 | 40 | 0 | 13 | * | * | 183 | 187 | 14 | 58 | 370 | 308 | 0 | 40 | 0 | 13 | 183 | 187 | 14 | 58 | 370 | |||||||||||||||||||||||||||||||
2778588 | 2778588 | CT | school | 903180 | 1060011 | Old Saybrook School District | 90318000684 | 1066111 | Old Saybrook Senior High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 349 | 9 | 40 | 0 | 18 | 0 | 9 | 214 | 211 | 13 | 61 | 425 | 349 | 9 | 40 | 0 | 18 | 0 | 9 | 214 | 211 | 13 | 61 | 425 | |||||||||||||||||||||||||||||
2778589 | 2778589 | CT | school | 903210 | 1070011 | Orange School District | 90321001225 | 1070211 | Mary L. Tracy School | Public Schools | Regular School | No | Elementary | PK | KG | 2020 | pk_12_total | 175 | * | 17 | 0 | 28 | 0 | * | 130 | 106 | 11 | 32 | 236 | 175 | 17 | 0 | 28 | 0 | 130 | 106 | 11 | 32 | 236 | |||||||||||||||||||||||||||||||
2778590 | 2778590 | CT | school | 903210 | 1070011 | Orange School District | 90321000687 | 1070511 | Peck Place School | Public Schools | Regular School | No | Elementary | 01 | 06 | 2020 | pk_12_total | 241 | * | 20 | 0 | 48 | * | 17 | 175 | 157 | 19 | 27 | 332 | 241 | 20 | 0 | 48 | 17 | 175 | 157 | 19 | 27 | 332 | |||||||||||||||||||||||||||||||
2778591 | 2778591 | CT | school | 903210 | 1070011 | Orange School District | 90321000688 | 1070311 | Race Brook School | Public Schools | Regular School | No | Elementary | 01 | 06 | 2020 | pk_12_total | 247 | * | 31 | * | 61 | 0 | 15 | 189 | 178 | 28 | 26 | 367 | 247 | 31 | 61 | 0 | 15 | 189 | 178 | 28 | 26 | 367 | |||||||||||||||||||||||||||||||
2778592 | 2778592 | CT | school | 903210 | 1070011 | Orange School District | 90321000689 | 1070411 | Turkey Hill School | Public Schools | Regular School | No | Elementary | 01 | 06 | 2020 | pk_12_total | 234 | * | 17 | 0 | 33 | 0 | * | 152 | 147 | 13 | 31 | 299 | 234 | 17 | 0 | 33 | 0 | 152 | 147 | 13 | 31 | 299 | |||||||||||||||||||||||||||||||
2778593 | 2778593 | CT | school | 903240 | 1080011 | Oxford School District | 90324000002 | 1080311 | Quaker Farms School | Public Schools | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 289 | 6 | 36 | * | 13 | * | * | 196 | 153 | 18 | 41 | 349 | 289 | 6 | 36 | 13 | 196 | 153 | 18 | 41 | 349 | ||||||||||||||||||||||||||||||||
2778594 | 2778594 | CT | school | 903240 | 1080011 | Oxford School District | 90324000691 | 1080111 | Oxford Center School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 326 | * | 36 | 0 | * | 0 | 8 | 192 | 188 | 18 | 47 | 380 | 326 | 36 | 0 | 0 | 8 | 192 | 188 | 18 | 47 | 380 | |||||||||||||||||||||||||||||||
2778595 | 2778595 | CT | school | 903240 | 1080011 | Oxford School District | 90324000690 | 1085111 | Oxford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 381 | 7 | 42 | * | 10 | 0 | * | 218 | 228 | 7 | 55 | 446 | 381 | 7 | 42 | 10 | 0 | 218 | 228 | 7 | 55 | 446 | |||||||||||||||||||||||||||||||
2778596 | 2778596 | CT | school | 903240 | 1080011 | Oxford School District | 90324001504 | 1086011 | Oxford High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 460 | * | 35 | * | 11 | 0 | 9 | 244 | 280 | 6 | 41 | 524 | 460 | 35 | 11 | 0 | 9 | 244 | 280 | 6 | 41 | 524 | |||||||||||||||||||||||||||||||
2778597 | 2778597 | CT | school | 1080011 | Oxford School District | 1080411 | Connections Alternative Learning Center | Program | 2020 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | 0 | * | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | |||||||||||||||||||||||||||||||||||||||||
2778598 | 2778598 | CT | school | 1080011 | Oxford School District | 1080511 | Community Explorations | Program | 2020 | pk_12_total | * | 0 | 0 | 0 | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
2778599 | 2778599 | CT | school | 1090011 | Plainfield School District | 90327001586 | 1098011 | Early Childhood Center | Program | 2020 | pk_12_total | 12 | * | * | 0 | * | 0 | * | 7 | 11 | 0 | * | 18 | 12 | 0 | 0 | 7 | 11 | 0 | 18 | ||||||||||||||||||||||||||||||||||||||||
2778600 | 2778600 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000047 | 1090411 | Shepard Hill Elementary School | Public Schools | Regular School | No | Elementary | PK | 03 | 2020 | pk_12_total | 358 | 14 | 36 | * | 8 | * | 10 | 232 | 200 | 9 | 89 | 432 | 358 | 14 | 36 | 8 | 10 | 232 | 200 | 9 | 89 | 432 | |||||||||||||||||||||||||||||||
2778601 | 2778601 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000692 | 1090111 | Moosup Elementary School | Public Schools | Regular School | No | Elementary | KG | 03 | 2020 | pk_12_total | 259 | 13 | 22 | * | * | * | * | 147 | 158 | 6 | 34 | 305 | 259 | 13 | 22 | 147 | 158 | 6 | 34 | 305 | |||||||||||||||||||||||||||||||||
2778602 | 2778602 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000696 | 1090311 | Plainfield Memorial School | Public Schools | Regular School | No | Elementary | 04 | 05 | 2020 | pk_12_total | 247 | 13 | 29 | * | 6 | * | 0 | 144 | 156 | 8 | 42 | 300 | 247 | 13 | 29 | 6 | 0 | 144 | 156 | 8 | 42 | 300 | |||||||||||||||||||||||||||||||
2778603 | 2778603 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000693 | 1095111 | Plainfield Central School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 441 | 27 | 24 | 9 | 6 | * | * | 265 | 252 | 7 | 75 | 517 | 441 | 27 | 24 | 9 | 6 | 265 | 252 | 7 | 75 | 517 | |||||||||||||||||||||||||||||||
2778604 | 2778604 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000695 | 1096111 | Plainfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 526 | 21 | 24 | * | 6 | * | 6 | 285 | 305 | * | 109 | 590 | 526 | 21 | 24 | 6 | 6 | 285 | 305 | 109 | 590 | ||||||||||||||||||||||||||||||||
2778605 | 2778605 | CT | school | 903300 | 1100011 | Plainville School District | 90330000699 | 1100411 | Frank T. Wheeler School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 205 | 16 | 66 | * | * | 0 | 15 | 178 | 131 | 42 | 44 | 309 | 205 | 16 | 66 | 0 | 15 | 178 | 131 | 42 | 44 | 309 | |||||||||||||||||||||||||||||||
2778606 | 2778606 | CT | school | 903300 | 1100011 | Plainville School District | 90330000701 | 1100211 | Linden Street School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 266 | 17 | 105 | 0 | 8 | 0 | 17 | 208 | 205 | 53 | 55 | 413 | 266 | 17 | 105 | 0 | 8 | 0 | 17 | 208 | 205 | 53 | 55 | 413 | |||||||||||||||||||||||||||||
2778607 | 2778607 | CT | school | 903300 | 1100011 | Plainville School District | 90330000702 | 1100511 | Louis Toffolon School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 291 | 22 | 56 | 0 | * | * | 16 | 203 | 194 | 21 | 49 | 397 | 291 | 22 | 56 | 0 | 16 | 203 | 194 | 21 | 49 | 397 | |||||||||||||||||||||||||||||||
2778608 | 2778608 | CT | school | 903300 | 1100011 | Plainville School District | 90330000048 | 1105211 | Middle School of Plainville | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 352 | 21 | 121 | * | * | 0 | 26 | 270 | 272 | 26 | 77 | 542 | 352 | 21 | 121 | 0 | 26 | 270 | 272 | 26 | 77 | 542 | |||||||||||||||||||||||||||||||
2778609 | 2778609 | CT | school | 903300 | 1100011 | Plainville School District | 90330000703 | 1106111 | Plainville High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 480 | 29 | 118 | * | * | 0 | 34 | 369 | 310 | 23 | 84 | 679 | 480 | 29 | 118 | 0 | 34 | 369 | 310 | 23 | 84 | 679 | |||||||||||||||||||||||||||||||
2778610 | 2778610 | CT | school | 1100011 | Plainville School District | 1100111 | Plainville Transition Program | Program | 2020 | pk_12_total | * | * | 0 | 0 | 0 | 0 | 0 | * | * | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2777768 | 2777768 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001565 | 110811 | Wintonbury Early Childhood Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 107 | 110 | 38 | * | 33 | 0 | * | 159 | 155 | 0 | 49 | 314 | 107 | 110 | 38 | 33 | 0 | 159 | 155 | 0 | 49 | 314 | |||||||||||||||||||||||||||||||
2777769 | 2777769 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000032 | 110611 | Laurel School | Public Schools | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 9 | 276 | 44 | * | * | 0 | 14 | 160 | 191 | 14 | 48 | 351 | 9 | 276 | 44 | 0 | 14 | 160 | 191 | 14 | 48 | 351 | |||||||||||||||||||||||||||||||
2777770 | 2777770 | CT | school | 110011 | Bloomfield School District | 110111 | Steps to Success | Program | 2020 | pk_12_total | * | 9 | * | 0 | 0 | 0 | 0 | 11 | 0 | 0 | 11 | 11 | 9 | 0 | 0 | 0 | 0 | 11 | 0 | 0 | 11 | 11 | ||||||||||||||||||||||||||||||||||||||
2777771 | 2777771 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000033 | 110511 | Metacomet School | Public Schools | Regular School | No | Elementary | 03 | 04 | 2020 | pk_12_total | 7 | 197 | 35 | * | * | 0 | 14 | 138 | 119 | 19 | 46 | 257 | 7 | 197 | 35 | 0 | 14 | 138 | 119 | 19 | 46 | 257 | |||||||||||||||||||||||||||||||
2777772 | 2777772 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001375 | 110711 | Carmen Arace Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2020 | pk_12_total | 9 | 191 | 30 | * | * | 0 | 8 | 118 | 123 | * | 56 | 241 | 9 | 191 | 30 | 0 | 8 | 118 | 123 | 56 | 241 | ||||||||||||||||||||||||||||||||
2777773 | 2777773 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001615 | 116311 | Global Experience Magnet School | Public Schools | Regular School | No | High | 06 | 12 | 2020 | pk_12_total | 36 | 85 | 53 | * | * | 0 | 8 | 78 | 107 | 16 | 33 | 185 | 36 | 85 | 53 | 0 | 8 | 78 | 107 | 16 | 33 | 185 | |||||||||||||||||||||||||||||||
2777774 | 2777774 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000034 | 115211 | Carmen Arace Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 7 | 220 | 28 | * | * | 0 | 10 | 134 | 134 | * | 58 | 268 | 7 | 220 | 28 | 0 | 10 | 134 | 134 | 58 | 268 | ||||||||||||||||||||||||||||||||
2777775 | 2777775 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000029 | 116111 | Bloomfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 11 | 460 | 64 | 0 | 6 | 0 | 15 | 287 | 269 | 13 | 98 | 556 | 11 | 460 | 64 | 0 | 6 | 0 | 15 | 287 | 269 | 13 | 98 | 556 | |||||||||||||||||||||||||||||
2777776 | 2777776 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001619 | 116411 | Learning Academy at Bloomfield | Alternative School | No | High | 11 | 12 | 2020 | pk_12_total | 0 | 9 | 0 | 0 | 0 | 0 | 0 | * | * | 0 | * | 9 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | |||||||||||||||||||||||||||||||||
2778611 | 2778611 | CT | school | 903330 | 1110011 | Plymouth School District | 90333000706 | 1110211 | Plymouth Center School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 258 | * | 32 | 0 | * | 0 | 14 | 158 | 149 | * | 50 | 307 | 258 | 32 | 0 | 0 | 14 | 158 | 149 | 50 | 307 | ||||||||||||||||||||||||||||||||
2778612 | 2778612 | CT | school | 903330 | 1110011 | Plymouth School District | 90333001521 | 1110411 | Harry S. Fisher Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 234 | * | 57 | 0 | * | 0 | 20 | 175 | 143 | 8 | 61 | 318 | 234 | 57 | 0 | 0 | 20 | 175 | 143 | 8 | 61 | 318 | |||||||||||||||||||||||||||||||
2778613 | 2778613 | CT | school | 903330 | 1110011 | Plymouth School District | 90333000705 | 1115111 | Eli Terry Jr. Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 300 | * | 41 | * | * | 0 | 9 | 191 | 168 | * | 70 | 359 | 300 | 41 | 0 | 9 | 191 | 168 | 70 | 359 | |||||||||||||||||||||||||||||||||
2778614 | 2778614 | CT | school | 903330 | 1110011 | Plymouth School District | 90333001199 | 1116111 | Terryville High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 313 | 7 | 33 | 0 | 11 | 0 | 10 | 185 | 189 | * | 59 | 374 | 313 | 7 | 33 | 0 | 11 | 0 | 10 | 185 | 189 | 59 | 374 | ||||||||||||||||||||||||||||||
2778615 | 2778615 | CT | school | 903360 | 1120011 | Pomfret School District | 90336000709 | 1120111 | Pomfret Community School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 358 | * | 6 | 0 | 9 | * | * | 209 | 173 | 0 | 36 | 382 | 358 | 6 | 0 | 9 | 209 | 173 | 0 | 36 | 382 | ||||||||||||||||||||||||||||||||
2778616 | 2778616 | CT | school | 903390 | 1130011 | Portland School District | 90339000714 | 1130211 | Valley View School | Public Schools | Regular School | No | Elementary | PK | 01 | 2020 | pk_12_total | 173 | * | 38 | 0 | * | 0 | 14 | 125 | * | 14 | 33 | 232 | 173 | 38 | 0 | 0 | 14 | 125 | 14 | 33 | 232 | ||||||||||||||||||||||||||||||||
2778617 | 2778617 | CT | school | 903390 | 1130011 | Portland School District | 90339000711 | 1130411 | Gildersleeve School | Public Schools | Regular School | No | Elementary | 02 | 04 | 2020 | pk_12_total | 219 | * | 57 | 0 | 8 | * | 11 | 153 | 149 | 20 | 39 | 302 | 219 | 57 | 0 | 8 | 11 | 153 | 149 | 20 | 39 | 302 | |||||||||||||||||||||||||||||||
2778618 | 2778618 | CT | school | 903390 | 1130011 | Portland School District | 90339001393 | 1130511 | Brownstone Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2020 | pk_12_total | 138 | 10 | 29 | 0 | * | * | 13 | 107 | * | * | 30 | 193 | 138 | 10 | 29 | 0 | 13 | 107 | 30 | 193 | |||||||||||||||||||||||||||||||||
2778619 | 2778619 | CT | school | 903390 | 1130011 | Portland School District | 90339000713 | 1135111 | Portland Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 150 | * | 30 | 0 | * | 0 | 10 | 101 | 101 | * | 23 | 202 | 150 | 30 | 0 | 0 | 10 | 101 | 101 | 23 | 202 | ||||||||||||||||||||||||||||||||
2778620 | 2778620 | CT | school | 903390 | 1130011 | Portland School District | 90339000712 | 1136111 | Portland High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 301 | 13 | 32 | * | * | 0 | 19 | 185 | * | * | 47 | 371 | 301 | 13 | 32 | 0 | 19 | 185 | 47 | 371 | |||||||||||||||||||||||||||||||||
2778621 | 2778621 | CT | school | 903420 | 1140011 | Preston School District | 90342001466 | 1140411 | Preston Veterans' Memorial School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 242 | * | 26 | 0 | 6 | * | 7 | 155 | 131 | 10 | 43 | 286 | 242 | 26 | 0 | 6 | 7 | 155 | 131 | 10 | 43 | 286 | |||||||||||||||||||||||||||||||
2778622 | 2778622 | CT | school | 903420 | 1140011 | Preston School District | 90342000717 | 1145111 | Preston Plains School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 122 | * | 7 | * | * | 0 | 9 | 72 | 75 | * | 29 | 147 | 122 | 7 | 0 | 9 | 72 | 75 | 29 | 147 | |||||||||||||||||||||||||||||||||
2778623 | 2778623 | CT | school | 903480 | 1160011 | Putnam School District | 90348000718 | 1160311 | Putnam Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 478 | 12 | 95 | 0 | * | * | 43 | 328 | 307 | 30 | 106 | 635 | 478 | 12 | 95 | 0 | 43 | 328 | 307 | 30 | 106 | 635 |
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]);