enrollments
Data source: Big Local News · About: Big Local
1,444 rows where grade = "pk_12_total", state = "CT" and year = 2021 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2758090 | 2758090 | CT | school | 903000 | 1000011 | North Canaan School District | 90300000626 | 1000111 | North Canaan Elementary School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 204 | * | 32 | 0 | * | 0 | 9 | 125 | 123 | 8 | 40 | 248 | 204 | 32 | 0 | 0 | 9 | 125 | 123 | 8 | 40 | 248 | |||||||||||||||||||||||||||||||
2757288 | 2757288 | CT | school | 900030 | 10011 | Andover School District | 90003010001 | 10111 | Andover Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 141 | * | 22 | 0 | 0 | 0 | * | 86 | 87 | * | 22 | 173 | 141 | 22 | 0 | 0 | 0 | 86 | 87 | 22 | 173 | ||||||||||||||||||||||||||||||||
2758091 | 2758091 | CT | school | 903030 | 1010011 | North Haven School District | 90303000628 | 1010711 | Green Acres Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 261 | 22 | 45 | 0 | 39 | 0 | 13 | 179 | 201 | 36 | 53 | 380 | 261 | 22 | 45 | 0 | 39 | 0 | 13 | 179 | 201 | 36 | 53 | 380 | |||||||||||||||||||||||||||||
2758092 | 2758092 | CT | school | 903030 | 1010011 | North Haven School District | 90303000633 | 1010311 | Ridge Road Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 258 | 31 | 41 | * | 27 | 0 | * | 192 | 187 | 13 | 47 | 379 | 258 | 31 | 41 | 27 | 0 | 192 | 187 | 13 | 47 | 379 | |||||||||||||||||||||||||||||||
2758093 | 2758093 | CT | school | 903030 | 1010011 | North Haven School District | 90303000627 | 1010811 | Clintonville Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 265 | 15 | 36 | * | 9 | 0 | * | 178 | 157 | 11 | 16 | 335 | 265 | 15 | 36 | 9 | 0 | 178 | 157 | 11 | 16 | 335 | |||||||||||||||||||||||||||||||
2758094 | 2758094 | CT | school | 903030 | 1010011 | North Haven School District | 90303000630 | 1010211 | Montowese Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 200 | * | 28 | * | 30 | 0 | 13 | 149 | 128 | 20 | 34 | 277 | 200 | 28 | 30 | 0 | 13 | 149 | 128 | 20 | 34 | 277 | |||||||||||||||||||||||||||||||
2758095 | 2758095 | CT | school | 903030 | 1010011 | North Haven School District | 90303000632 | 1015211 | North Haven Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 551 | 26 | 72 | 0 | 57 | 0 | 33 | 369 | 370 | 16 | 95 | 739 | 551 | 26 | 72 | 0 | 57 | 0 | 33 | 369 | 370 | 16 | 95 | 739 | |||||||||||||||||||||||||||||
2758096 | 2758096 | CT | school | 903030 | 1010011 | North Haven School District | 90303000631 | 1016111 | North Haven High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 723 | 40 | 87 | 0 | 68 | 0 | 31 | 485 | 464 | 11 | 113 | 949 | 723 | 40 | 87 | 0 | 68 | 0 | 31 | 485 | 464 | 11 | 113 | 949 | |||||||||||||||||||||||||||||
2758097 | 2758097 | CT | school | 1010011 | North Haven School District | 90303001733 | 1010111 | North Haven Transition Partnership | Program | 2021 | pk_12_total | 7 | * | * | 0 | * | 0 | 0 | * | * | 0 | 10 | 10 | 7 | 0 | 0 | 0 | 0 | 10 | 10 | ||||||||||||||||||||||||||||||||||||||||
2758098 | 2758098 | CT | school | 903060 | 1020011 | North Stonington School District | 90306000634 | 1020111 | North Stonington Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 338 | 11 | 22 | * | 7 | * | 0 | 194 | 190 | 0 | 42 | 384 | 338 | 11 | 22 | 7 | 0 | 194 | 190 | 0 | 42 | 384 | |||||||||||||||||||||||||||||||
2758099 | 2758099 | CT | school | 903060 | 1020011 | North Stonington School District | 90306000635 | 1026111 | Wheeler High School | Public Schools | Regular School | No | High | 07 | 12 | 2021 | pk_12_total | 275 | * | 15 | * | * | 0 | 15 | 162 | 156 | 0 | 25 | 318 | 275 | 15 | 0 | 15 | 162 | 156 | 0 | 25 | 318 | ||||||||||||||||||||||||||||||||
2758100 | 2758100 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000640 | 1030211 | Brookside Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 47 | 57 | 291 | 0 | * | * | 17 | 226 | 199 | 110 | 57 | 425 | 47 | 57 | 291 | 0 | 17 | 226 | 199 | 110 | 57 | 425 | |||||||||||||||||||||||||||||||
2758101 | 2758101 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000645 | 1032011 | Fox Run Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 96 | 74 | 158 | 0 | 20 | * | * | 182 | 187 | 54 | 48 | 369 | 96 | 74 | 158 | 0 | 20 | 182 | 187 | 54 | 48 | 369 | |||||||||||||||||||||||||||||||
2758102 | 2758102 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000648 | 1030711 | Jefferson Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 26 | 77 | 284 | * | 41 | 0 | * | 257 | 188 | 105 | 47 | 445 | 26 | 77 | 284 | 41 | 0 | 257 | 188 | 105 | 47 | 445 | |||||||||||||||||||||||||||||||
2758103 | 2758103 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000649 | 1030811 | Kendall Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 35 | 62 | 338 | 0 | 22 | 0 | 15 | 237 | 235 | 169 | 58 | 472 | 35 | 62 | 338 | 0 | 22 | 0 | 15 | 237 | 235 | 169 | 58 | 472 | |||||||||||||||||||||||||||||
2758104 | 2758104 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000652 | 1032111 | Naramake Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 121 | 42 | 165 | 0 | 11 | 0 | 17 | 182 | 174 | 46 | 49 | 356 | 121 | 42 | 165 | 0 | 11 | 0 | 17 | 182 | 174 | 46 | 49 | 356 | |||||||||||||||||||||||||||||
2758105 | 2758105 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001914 | 1030111 | Norwalk Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 38 | 16 | 59 | 0 | * | 0 | * | 78 | 47 | 0 | 82 | 125 | 38 | 16 | 59 | 0 | 0 | 78 | 47 | 0 | 82 | 125 | |||||||||||||||||||||||||||||||
2758106 | 2758106 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000642 | 1030311 | Columbus Magnet School | Public Schools | Regular School | No | Elementary | KG | 08 | 2021 | pk_12_total | 119 | 52 | 99 | * | 21 | * | 16 | 161 | 151 | 30 | 39 | 312 | 119 | 52 | 99 | 21 | 16 | 161 | 151 | 30 | 39 | 312 | |||||||||||||||||||||||||||||||
2758107 | 2758107 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000643 | 1030411 | Cranbury Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 186 | 43 | 153 | 0 | 31 | * | * | 218 | 215 | 69 | 54 | 433 | 186 | 43 | 153 | 0 | 31 | 218 | 215 | 69 | 54 | 433 | |||||||||||||||||||||||||||||||
2758108 | 2758108 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000651 | 1032211 | Marvin Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 105 | 47 | 214 | 0 | 18 | 0 | 15 | 202 | 197 | 93 | 55 | 399 | 105 | 47 | 214 | 0 | 18 | 0 | 15 | 202 | 197 | 93 | 55 | 399 | |||||||||||||||||||||||||||||
2758109 | 2758109 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000658 | 1031311 | Rowayton School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 251 | 41 | 159 | 0 | * | * | 25 | 243 | 240 | 60 | 49 | 483 | 251 | 41 | 159 | 0 | 25 | 243 | 240 | 60 | 49 | 483 | |||||||||||||||||||||||||||||||
2758110 | 2758110 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000659 | 1032311 | Silvermine Dual Language Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 44 | 35 | 365 | 0 | 8 | 0 | 14 | 240 | 226 | 159 | 47 | 466 | 44 | 35 | 365 | 0 | 8 | 0 | 14 | 240 | 226 | 159 | 47 | 466 | |||||||||||||||||||||||||||||
2758111 | 2758111 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000660 | 1031411 | Tracey Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 70 | 69 | 277 | 0 | 21 | 0 | 16 | 247 | 206 | 132 | 75 | 453 | 70 | 69 | 277 | 0 | 21 | 0 | 16 | 247 | 206 | 132 | 75 | 453 | |||||||||||||||||||||||||||||
2758112 | 2758112 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000662 | 1032411 | Wolfpit School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 105 | 48 | 116 | * | * | 0 | 20 | 157 | 146 | 52 | 44 | 303 | 105 | 48 | 116 | 0 | 20 | 157 | 146 | 52 | 44 | 303 | |||||||||||||||||||||||||||||||
2758113 | 2758113 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000653 | 1035211 | Nathan Hale Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 178 | 81 | 294 | 0 | 31 | 0 | 11 | 317 | 278 | 67 | 100 | 595 | 178 | 81 | 294 | 0 | 31 | 0 | 11 | 317 | 278 | 67 | 100 | 595 | |||||||||||||||||||||||||||||
2758114 | 2758114 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000656 | 1035311 | Ponus Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 89 | 117 | 395 | * | 38 | 0 | * | 358 | * | 105 | 112 | 656 | 89 | 117 | 395 | 38 | 0 | 358 | 105 | 112 | 656 | ||||||||||||||||||||||||||||||||
2758115 | 2758115 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000657 | 1035511 | Roton Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 189 | 64 | 299 | 0 | 23 | * | * | 308 | 284 | 62 | 91 | 592 | 189 | 64 | 299 | 0 | 23 | 308 | 284 | 62 | 91 | 592 | |||||||||||||||||||||||||||||||
2758116 | 2758116 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000661 | 1035411 | West Rocks Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 172 | 124 | 401 | * | 30 | * | * | 386 | 349 | 114 | 123 | 735 | 172 | 124 | 401 | 30 | 386 | 349 | 114 | 123 | 735 | ||||||||||||||||||||||||||||||||
2758117 | 2758117 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000638 | 1036211 | Brien McMahon High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 401 | 258 | 960 | * | 56 | 0 | * | 860 | 850 | 263 | 211 | 1710 | 401 | 258 | 960 | 56 | 0 | 860 | 850 | 263 | 211 | 1710 | |||||||||||||||||||||||||||||||
2758118 | 2758118 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001917 | 1030511 | Center for Global Studies | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 114 | 38 | 89 | 0 | 27 | 0 | 8 | 89 | 187 | * | 14 | 276 | 114 | 38 | 89 | 0 | 27 | 0 | 8 | 89 | 187 | 14 | 276 | ||||||||||||||||||||||||||||||
2758119 | 2758119 | CT | school | 1030011 | Norwalk School District | 1031011 | Norwalk Alternative Opportunity Program | Program | 2021 | pk_12_total | 0 | * | 0 | 0 | 0 | 0 | 0 | * | * | 0 | 0 | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||
2758120 | 2758120 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000655 | 1036111 | Norwalk High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 390 | 241 | 767 | * | 38 | 0 | * | 777 | 689 | 251 | 235 | 1466 | 390 | 241 | 767 | 38 | 0 | 777 | 689 | 251 | 235 | 1466 | |||||||||||||||||||||||||||||||
2758121 | 2758121 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001923 | 1030911 | P-TECH Norwalk | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 107 | 81 | 174 | * | 30 | * | * | 215 | * | 16 | 19 | 399 | 107 | 81 | 174 | 30 | 215 | 16 | 19 | 399 | |||||||||||||||||||||||||||||||||
2758122 | 2758122 | CT | school | 1030011 | Norwalk School District | 1031111 | Norwalk 18-21 Next Steps (NNS) | Program | 2021 | pk_12_total | 9 | 11 | * | 0 | * | 0 | 0 | 15 | 12 | * | 27 | 27 | 9 | 11 | 0 | 0 | 0 | 15 | 12 | 27 | 27 | |||||||||||||||||||||||||||||||||||||||
2758123 | 2758123 | CT | school | 1030011 | Norwalk School District | 1030611 | Norwalk 18-21 Project SEARCH | Program | 2021 | pk_12_total | 6 | * | * | 0 | 0 | 0 | 0 | * | * | * | 12 | 12 | 6 | 0 | 0 | 0 | 0 | 12 | 12 | |||||||||||||||||||||||||||||||||||||||||
2758124 | 2758124 | CT | school | 903120 | 1040011 | Norwich School District | 90312000663 | 1040111 | Bishop School Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 34 | 25 | 36 | * | * | 0 | 12 | 73 | 40 | 0 | 64 | 113 | 34 | 25 | 36 | 0 | 12 | 73 | 40 | 0 | 64 | 113 | |||||||||||||||||||||||||||||||
2758125 | 2758125 | CT | school | 1040011 | Norwich School District | 90312001745 | 1040211 | Case Street Early Learning Center at DTZ | Program | 2021 | pk_12_total | * | 10 | 11 | 0 | * | 0 | * | 11 | 17 | 0 | 0 | 28 | 10 | 11 | 0 | 0 | 11 | 17 | 0 | 0 | 28 | ||||||||||||||||||||||||||||||||||||||
2758126 | 2758126 | CT | school | 903120 | 1040011 | Norwich School District | 90312000675 | 1041711 | Thomas W. Mahan School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 73 | 35 | 52 | 0 | 66 | 0 | 12 | 131 | 107 | 52 | 34 | 238 | 73 | 35 | 52 | 0 | 66 | 0 | 12 | 131 | 107 | 52 | 34 | 238 | |||||||||||||||||||||||||||||
2758127 | 2758127 | CT | school | 903120 | 1040011 | Norwich School District | 90312000667 | 1041411 | John B. Stanton School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 70 | 59 | 125 | * | 25 | * | 32 | 154 | 162 | 94 | 59 | 316 | 70 | 59 | 125 | 25 | 32 | 154 | 162 | 94 | 59 | 316 | |||||||||||||||||||||||||||||||
2758128 | 2758128 | CT | school | 903120 | 1040011 | Norwich School District | 90312000668 | 1042011 | Moriarty Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 151 | 64 | 152 | * | * | 0 | 45 | 206 | 219 | 71 | 53 | 425 | 151 | 64 | 152 | 0 | 45 | 206 | 219 | 71 | 53 | 425 | |||||||||||||||||||||||||||||||
2758129 | 2758129 | CT | school | 903120 | 1040011 | Norwich School District | 90312000672 | 1040811 | Samuel Huntington School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 99 | 41 | 85 | 0 | * | * | 49 | 158 | 139 | 42 | 30 | 297 | 99 | 41 | 85 | 0 | 49 | 158 | 139 | 42 | 30 | 297 | |||||||||||||||||||||||||||||||
2758130 | 2758130 | CT | school | 1040011 | Norwich School District | 1040411 | Strive Autism Program @ Huntington | Program | 2021 | pk_12_total | * | * | 6 | 0 | 0 | 0 | 0 | * | * | * | 12 | 12 | 6 | 0 | 0 | 0 | 0 | 12 | 12 | |||||||||||||||||||||||||||||||||||||||||
2758131 | 2758131 | CT | school | 1040011 | Norwich School District | 1041211 | Strive Program @ Stanton | Program | 2021 | pk_12_total | * | * | * | 0 | 0 | 0 | * | * | * | * | 7 | 7 | 0 | 0 | 0 | 7 | 7 | |||||||||||||||||||||||||||||||||||||||||||
2758132 | 2758132 | CT | school | 903120 | 1040011 | Norwich School District | 90312000676 | 1041911 | Uncas Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 55 | 62 | 103 | 0 | * | * | 19 | 134 | 117 | 73 | 37 | 251 | 55 | 62 | 103 | 0 | 19 | 134 | 117 | 73 | 37 | 251 | |||||||||||||||||||||||||||||||
2758133 | 2758133 | CT | school | 903120 | 1040011 | Norwich School District | 90312000677 | 1041811 | Veterans' Memorial School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 57 | 46 | 78 | 0 | * | * | 20 | 118 | 104 | 51 | 28 | 222 | 57 | 46 | 78 | 0 | 20 | 118 | 104 | 51 | 28 | 222 | |||||||||||||||||||||||||||||||
2758134 | 2758134 | CT | school | 903120 | 1040011 | Norwich School District | 90312000678 | 1041511 | Wequonnoc Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 69 | 54 | 107 | * | * | * | 35 | 134 | 137 | 48 | 37 | 271 | 69 | 54 | 107 | 35 | 134 | 137 | 48 | 37 | 271 | ||||||||||||||||||||||||||||||||
2758135 | 2758135 | CT | school | 1040011 | Norwich School District | 1040511 | Special Needs Program @ Mahan | Program | 2021 | pk_12_total | * | 0 | * | 0 | * | 0 | 0 | * | * | * | 7 | 7 | 0 | 0 | 0 | 0 | 7 | 7 | ||||||||||||||||||||||||||||||||||||||||||
2758136 | 2758136 | CT | school | 903120 | 1040011 | Norwich School District | 90312000670 | 1045111 | Kelly STEAM Magnet Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 182 | 119 | 246 | * | 35 | * | 72 | 340 | 316 | 92 | 87 | 656 | 182 | 119 | 246 | 35 | 72 | 340 | 316 | 92 | 87 | 656 | |||||||||||||||||||||||||||||||
2758137 | 2758137 | CT | school | 1040011 | Norwich School District | 1041111 | Strive Program @ Kelly | Program | 2021 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | * | 9 | 9 | 0 | 0 | 0 | 0 | 0 | 9 | 9 | |||||||||||||||||||||||||||||||||||||||||
2758138 | 2758138 | CT | school | 903120 | 1040011 | Norwich School District | 90312000674 | 1045211 | Teachers' Memorial Global Studies Magnet Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 109 | 66 | 151 | * | 26 | * | 48 | 206 | 201 | 71 | 95 | 407 | 109 | 66 | 151 | 26 | 48 | 206 | 201 | 71 | 95 | 407 | |||||||||||||||||||||||||||||||
2758139 | 2758139 | CT | school | 1040011 | Norwich School District | 90312001622 | 1049211 | Virtual Learning Academy | Program | 2021 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||
2758140 | 2758140 | CT | school | 1040011 | Norwich School District | 1041011 | Transition Academy | Program | 2021 | pk_12_total | 15 | 7 | * | 0 | * | 0 | * | 21 | 10 | 7 | * | 31 | 15 | 7 | 0 | 0 | 21 | 10 | 7 | 31 | ||||||||||||||||||||||||||||||||||||||||
2758141 | 2758141 | CT | school | 903180 | 1060011 | Old Saybrook School District | 90318000681 | 1060211 | Kathleen E. Goodwin School | Public Schools | Regular School | No | Elementary | PK | 06 | 2021 | pk_12_total | 269 | * | 65 | 0 | 13 | * | 14 | 194 | 170 | 43 | 49 | 364 | 269 | 65 | 0 | 13 | 14 | 194 | 170 | 43 | 49 | 364 | |||||||||||||||||||||||||||||||
2758142 | 2758142 | CT | school | 903180 | 1060011 | Old Saybrook School District | 90318000007 | 1065211 | Old Saybrook Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2021 | pk_12_total | 267 | * | 41 | 0 | 11 | * | 9 | 159 | 171 | 17 | 56 | 330 | 267 | 41 | 0 | 11 | 9 | 159 | 171 | 17 | 56 | 330 | |||||||||||||||||||||||||||||||
2758143 | 2758143 | CT | school | 903180 | 1060011 | Old Saybrook School District | 90318000684 | 1066111 | Old Saybrook Senior High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 308 | 6 | 37 | 0 | 16 | 0 | 9 | 190 | 186 | 9 | 49 | 376 | 308 | 6 | 37 | 0 | 16 | 0 | 9 | 190 | 186 | 9 | 49 | 376 | |||||||||||||||||||||||||||||
2758144 | 2758144 | CT | school | 903210 | 1070011 | Orange School District | 90321001225 | 1070211 | Mary L. Tracy School | Public Schools | Regular School | No | Elementary | PK | KG | 2021 | pk_12_total | 158 | * | 16 | 0 | 23 | 0 | * | 111 | 99 | 10 | 33 | 210 | 158 | 16 | 0 | 23 | 0 | 111 | 99 | 10 | 33 | 210 | |||||||||||||||||||||||||||||||
2758145 | 2758145 | CT | school | 903210 | 1070011 | Orange School District | 90321000687 | 1070511 | Peck Place School | Public Schools | Regular School | No | Elementary | 01 | 06 | 2021 | pk_12_total | 242 | * | 24 | 0 | 49 | * | 19 | 186 | 157 | 17 | 30 | 343 | 242 | 24 | 0 | 49 | 19 | 186 | 157 | 17 | 30 | 343 | |||||||||||||||||||||||||||||||
2758146 | 2758146 | CT | school | 903210 | 1070011 | Orange School District | 90321000688 | 1070311 | Race Brook School | Public Schools | Regular School | No | Elementary | 01 | 06 | 2021 | pk_12_total | 270 | * | 33 | * | 52 | 0 | 11 | 194 | 183 | 22 | 26 | 377 | 270 | 33 | 52 | 0 | 11 | 194 | 183 | 22 | 26 | 377 | |||||||||||||||||||||||||||||||
2758147 | 2758147 | CT | school | 903210 | 1070011 | Orange School District | 90321000689 | 1070411 | Turkey Hill School | Public Schools | Regular School | No | Elementary | 01 | 06 | 2021 | pk_12_total | 236 | * | * | 0 | 33 | 0 | 17 | 151 | 151 | 14 | 29 | 302 | 236 | 0 | 33 | 0 | 17 | 151 | 151 | 14 | 29 | 302 | |||||||||||||||||||||||||||||||
2758148 | 2758148 | CT | school | 903240 | 1080011 | Oxford School District | 90324000002 | 1080311 | Quaker Farms School | Public Schools | Regular School | No | Elementary | PK | 02 | 2021 | pk_12_total | 262 | * | 29 | * | 7 | * | * | 163 | 142 | 12 | 35 | 305 | 262 | 29 | 7 | 163 | 142 | 12 | 35 | 305 | |||||||||||||||||||||||||||||||||
2758149 | 2758149 | CT | school | 903240 | 1080011 | Oxford School District | 90324000691 | 1080111 | Oxford Center School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2021 | pk_12_total | 304 | * | 32 | * | 9 | 0 | * | 193 | 160 | 11 | 45 | 353 | 304 | 32 | 9 | 0 | 193 | 160 | 11 | 45 | 353 | ||||||||||||||||||||||||||||||||
2758150 | 2758150 | CT | school | 903240 | 1080011 | Oxford School District | 90324000690 | 1085111 | Oxford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 352 | 8 | 41 | 0 | 8 | 0 | 7 | 195 | 221 | 9 | 59 | 416 | 352 | 8 | 41 | 0 | 8 | 0 | 7 | 195 | 221 | 9 | 59 | 416 | |||||||||||||||||||||||||||||
2758151 | 2758151 | CT | school | 903240 | 1080011 | Oxford School District | 90324001504 | 1086011 | Oxford High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 460 | * | 30 | * | 15 | 0 | 7 | 241 | 280 | 7 | 38 | 521 | 460 | 30 | 15 | 0 | 7 | 241 | 280 | 7 | 38 | 521 | |||||||||||||||||||||||||||||||
2758152 | 2758152 | CT | school | 1080011 | Oxford School District | 1080411 | Connections Alternative Learning Center | Program | 2021 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | 0 | * | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | |||||||||||||||||||||||||||||||||||||||||
2758153 | 2758153 | CT | school | 1080011 | Oxford School District | 1080511 | Community Explorations | Program | 2021 | pk_12_total | * | 0 | 0 | 0 | 0 | 0 | 0 | * | * | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||
2758154 | 2758154 | CT | school | 1090011 | Plainfield School District | 90327001586 | 1098011 | Early Childhood Center | Program | 2021 | pk_12_total | 78 | * | * | 0 | * | 0 | * | 42 | 47 | 0 | 32 | 89 | 78 | 0 | 0 | 42 | 47 | 0 | 32 | 89 | |||||||||||||||||||||||||||||||||||||||
2758155 | 2758155 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000692 | 1090111 | Moosup Elementary School | Public Schools | Regular School | No | Elementary | KG | 03 | 2021 | pk_12_total | 256 | 8 | 22 | * | * | * | 9 | 143 | 157 | * | 42 | 300 | 256 | 8 | 22 | 9 | 143 | 157 | 42 | 300 | |||||||||||||||||||||||||||||||||
2758156 | 2758156 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000047 | 1090411 | Shepard Hill Elementary School | Public Schools | Regular School | No | Elementary | KG | 03 | 2021 | pk_12_total | 229 | 9 | 27 | * | 10 | * | * | 156 | 131 | 8 | 50 | 287 | 229 | 9 | 27 | 10 | 156 | 131 | 8 | 50 | 287 | ||||||||||||||||||||||||||||||||
2758157 | 2758157 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000696 | 1090311 | Plainfield Memorial School | Public Schools | Regular School | No | Elementary | 04 | 05 | 2021 | pk_12_total | 234 | 15 | 27 | * | * | * | * | 145 | 142 | 14 | 42 | 287 | 234 | 15 | 27 | 145 | 142 | 14 | 42 | 287 | |||||||||||||||||||||||||||||||||
2758158 | 2758158 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000693 | 1095111 | Plainfield Central School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 402 | 26 | 26 | 7 | 10 | * | * | 240 | 239 | 9 | 74 | 479 | 402 | 26 | 26 | 7 | 10 | 240 | 239 | 9 | 74 | 479 | |||||||||||||||||||||||||||||||
2758159 | 2758159 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000695 | 1096111 | Plainfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 488 | 25 | 27 | * | * | * | * | 265 | 288 | * | 102 | 553 | 488 | 25 | 27 | 265 | 288 | 102 | 553 | ||||||||||||||||||||||||||||||||||
2758160 | 2758160 | CT | school | 903300 | 1100011 | Plainville School District | 90330000699 | 1100411 | Frank T. Wheeler School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 207 | 15 | 78 | * | * | 0 | 20 | 183 | 146 | 41 | 59 | 329 | 207 | 15 | 78 | 0 | 20 | 183 | 146 | 41 | 59 | 329 | |||||||||||||||||||||||||||||||
2758161 | 2758161 | CT | school | 903300 | 1100011 | Plainville School District | 90330000701 | 1100211 | Linden Street School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 212 | 14 | 93 | 0 | 8 | 0 | 15 | 181 | 161 | 55 | 43 | 342 | 212 | 14 | 93 | 0 | 8 | 0 | 15 | 181 | 161 | 55 | 43 | 342 | |||||||||||||||||||||||||||||
2758162 | 2758162 | CT | school | 903300 | 1100011 | Plainville School District | 90330000702 | 1100511 | Louis Toffolon School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 262 | 22 | 62 | 0 | * | * | 15 | 185 | 185 | 21 | 45 | 370 | 262 | 22 | 62 | 0 | 15 | 185 | 185 | 21 | 45 | 370 | |||||||||||||||||||||||||||||||
2758163 | 2758163 | CT | school | 903300 | 1100011 | Plainville School District | 90330000048 | 1105211 | Middle School of Plainville | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 341 | 28 | 121 | * | * | 0 | 24 | 266 | 265 | 31 | 63 | 531 | 341 | 28 | 121 | 0 | 24 | 266 | 265 | 31 | 63 | 531 | |||||||||||||||||||||||||||||||
2758164 | 2758164 | CT | school | 903300 | 1100011 | Plainville School District | 90330000703 | 1106111 | Plainville High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 454 | 31 | 137 | * | * | 0 | 28 | 368 | 305 | 27 | 92 | 673 | 454 | 31 | 137 | 0 | 28 | 368 | 305 | 27 | 92 | 673 | |||||||||||||||||||||||||||||||
2758165 | 2758165 | CT | school | 1100011 | Plainville School District | 1100111 | Plainville Transition Program | Program | 2021 | pk_12_total | * | * | 0 | 0 | 0 | 0 | 0 | * | * | 0 | * | * | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||
2757321 | 2757321 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001565 | 110811 | Wintonbury Early Childhood Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2021 | pk_12_total | 106 | 113 | 37 | 0 | 35 | 0 | 18 | 139 | 170 | 0 | 37 | 309 | 106 | 113 | 37 | 0 | 35 | 0 | 18 | 139 | 170 | 0 | 37 | 309 | |||||||||||||||||||||||||||||
2757322 | 2757322 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000032 | 110611 | Laurel School | Public Schools | Regular School | No | Elementary | KG | 02 | 2021 | pk_12_total | * | 243 | 44 | 0 | * | 0 | 16 | 165 | 154 | 9 | 46 | 319 | 243 | 44 | 0 | 0 | 16 | 165 | 154 | 9 | 46 | 319 | |||||||||||||||||||||||||||||||
2757323 | 2757323 | CT | school | 110011 | Bloomfield School District | 110111 | Steps to Success | Program | 2021 | pk_12_total | 0 | * | * | 0 | 0 | 0 | 0 | * | * | * | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 15 | 15 | |||||||||||||||||||||||||||||||||||||||||
2757324 | 2757324 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000033 | 110511 | Metacomet School | Public Schools | Regular School | No | Elementary | 03 | 04 | 2021 | pk_12_total | * | 172 | 23 | * | * | 0 | 8 | 119 | 95 | 16 | 38 | 214 | 172 | 23 | 0 | 8 | 119 | 95 | 16 | 38 | 214 | ||||||||||||||||||||||||||||||||
2757325 | 2757325 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001375 | 110711 | Carmen Arace Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2021 | pk_12_total | 6 | 186 | 29 | * | * | 0 | 9 | 120 | 114 | 10 | 41 | 234 | 6 | 186 | 29 | 0 | 9 | 120 | 114 | 10 | 41 | 234 | |||||||||||||||||||||||||||||||
2757326 | 2757326 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001615 | 116311 | Global Experience Magnet School | Public Schools | Regular School | No | High | 06 | 12 | 2021 | pk_12_total | 30 | 79 | 68 | * | * | 0 | 13 | 86 | 106 | 18 | 36 | 192 | 30 | 79 | 68 | 0 | 13 | 86 | 106 | 18 | 36 | 192 | |||||||||||||||||||||||||||||||
2757327 | 2757327 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000034 | 115211 | Carmen Arace Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 7 | 224 | 29 | * | * | 0 | 8 | 133 | 137 | 7 | 61 | 270 | 7 | 224 | 29 | 0 | 8 | 133 | 137 | 7 | 61 | 270 | |||||||||||||||||||||||||||||||
2757328 | 2757328 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000029 | 116111 | Bloomfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 10 | 422 | 58 | * | * | 0 | 10 | 267 | 239 | 13 | 101 | 506 | 10 | 422 | 58 | 0 | 10 | 267 | 239 | 13 | 101 | 506 | |||||||||||||||||||||||||||||||
2758166 | 2758166 | CT | school | 903330 | 1110011 | Plymouth School District | 90333000706 | 1110211 | Plymouth Center School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 247 | * | 37 | 0 | * | 0 | 13 | 154 | 148 | 8 | 55 | 302 | 247 | 37 | 0 | 0 | 13 | 154 | 148 | 8 | 55 | 302 | |||||||||||||||||||||||||||||||
2758167 | 2758167 | CT | school | 903330 | 1110011 | Plymouth School District | 90333001521 | 1110411 | Harry S. Fisher Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2021 | pk_12_total | 216 | * | 43 | 0 | * | 0 | 24 | 162 | 129 | 8 | 57 | 291 | 216 | 43 | 0 | 0 | 24 | 162 | 129 | 8 | 57 | 291 | |||||||||||||||||||||||||||||||
2758168 | 2758168 | CT | school | 903330 | 1110011 | Plymouth School District | 90333000705 | 1115111 | Eli Terry Jr. Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 259 | * | 42 | * | * | 0 | 10 | 160 | 154 | * | 61 | 314 | 259 | 42 | 0 | 10 | 160 | 154 | 61 | 314 | |||||||||||||||||||||||||||||||||
2758169 | 2758169 | CT | school | 903330 | 1110011 | Plymouth School District | 90333001199 | 1116111 | Terryville High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 317 | * | 35 | * | 12 | 0 | 11 | 204 | * | 6 | 58 | 382 | 317 | 35 | 12 | 0 | 11 | 204 | 6 | 58 | 382 | ||||||||||||||||||||||||||||||||
2758170 | 2758170 | CT | school | 903360 | 1120011 | Pomfret School District | 90336000709 | 1120111 | Pomfret Community School | Public Schools | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 319 | * | * | 0 | 7 | * | 0 | 182 | 154 | 0 | 38 | 336 | 319 | 0 | 7 | 0 | 182 | 154 | 0 | 38 | 336 | ||||||||||||||||||||||||||||||||
2758171 | 2758171 | CT | school | 903390 | 1130011 | Portland School District | 90339000714 | 1130211 | Valley View School | Public Schools | Regular School | No | Elementary | PK | 01 | 2021 | pk_12_total | 153 | * | 37 | 0 | * | 0 | 19 | 111 | * | 10 | 41 | 218 | 153 | 37 | 0 | 0 | 19 | 111 | 10 | 41 | 218 | ||||||||||||||||||||||||||||||||
2758172 | 2758172 | CT | school | 903390 | 1130011 | Portland School District | 90339000711 | 1130411 | Gildersleeve School | Public Schools | Regular School | No | Elementary | 02 | 04 | 2021 | pk_12_total | 203 | 6 | 60 | 0 | 8 | 0 | 15 | 159 | 133 | 26 | 36 | 292 | 203 | 6 | 60 | 0 | 8 | 0 | 15 | 159 | 133 | 26 | 36 | 292 | |||||||||||||||||||||||||||||
2758173 | 2758173 | CT | school | 903390 | 1130011 | Portland School District | 90339001393 | 1130511 | Brownstone Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2021 | pk_12_total | 146 | * | 30 | 0 | * | 0 | 9 | 104 | * | * | 38 | 196 | 146 | 30 | 0 | 0 | 9 | 104 | 38 | 196 | |||||||||||||||||||||||||||||||||
2758174 | 2758174 | CT | school | 903390 | 1130011 | Portland School District | 90339000713 | 1135111 | Portland Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2021 | pk_12_total | 160 | * | 31 | 0 | * | 0 | 13 | 108 | 106 | * | 29 | 214 | 160 | 31 | 0 | 0 | 13 | 108 | 106 | 29 | 214 | ||||||||||||||||||||||||||||||||
2758175 | 2758175 | CT | school | 903390 | 1130011 | Portland School District | 90339000712 | 1136111 | Portland High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 280 | * | 37 | 0 | * | 0 | 16 | 172 | 176 | * | 40 | 348 | 280 | 37 | 0 | 0 | 16 | 172 | 176 | 40 | 348 | ||||||||||||||||||||||||||||||||
2758176 | 2758176 | CT | school | 903420 | 1140011 | Preston School District | 90342001466 | 1140411 | Preston Veterans' Memorial School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 219 | * | 21 | 0 | 7 | * | 9 | 136 | 126 | * | 38 | 262 | 219 | 21 | 0 | 7 | 9 | 136 | 126 | 38 | 262 | ||||||||||||||||||||||||||||||||
2758177 | 2758177 | CT | school | 903420 | 1140011 | Preston School District | 90342000717 | 1145111 | Preston Plains School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 115 | * | 7 | 0 | * | * | 8 | 69 | 69 | * | 25 | 138 | 115 | 7 | 0 | 8 | 69 | 69 | 25 | 138 | |||||||||||||||||||||||||||||||||
2758178 | 2758178 | CT | school | 903480 | 1160011 | Putnam School District | 90348000718 | 1160311 | Putnam Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 415 | 10 | 97 | * | 7 | * | 39 | 298 | 273 | 27 | 107 | 571 | 415 | 10 | 97 | 7 | 39 | 298 | 273 | 27 | 107 | 571 | |||||||||||||||||||||||||||||||
2758179 | 2758179 | CT | school | 903480 | 1160011 | Putnam School District | 90348000720 | 1165111 | Putnam Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 226 | * | 29 | 0 | * | 0 | 7 | 142 | 125 | 7 | 58 | 267 | 226 | 29 | 0 | 0 | 7 | 142 | 125 | 7 | 58 | 267 | |||||||||||||||||||||||||||||||
2758180 | 2758180 | CT | school | 903480 | 1160011 | Putnam School District | 90348000719 | 1166111 | Putnam High School | Public Schools | Regular School | No | High | 09 | 12 | 2021 | pk_12_total | 200 | * | 36 | 0 | * | * | 10 | 120 | 134 | 6 | 53 | 254 | 200 | 36 | 0 | 10 | 120 | 134 | 6 | 53 | 254 |
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]);