enrollments
Data source: Big Local News · About: Big Local
20,286 rows where state = "CT" and year = 2019 sorted by hispanic descending
This data as json, CSV (advanced)
grade ✖
Link | rowid | state | county | county_state_id | admin_level | district_nces_id | district_state_id | district_state_type | district | school_nces_id | school_state_id | school | school_state_type | ccd_school_type | ccd_charter_school | ccd_school_lvl | ccd_school_low_grade | ccd_school_high_grade | year | term | grade | white | black | hispanic ▲ | native_american | native_american_alaskan_native | asian | native_hawaiian | asian_pacific_islander | native_hawaiian_pacific_islander | pacific_islander | multiracial | unknown_race | male | female | non_binary | unknown_gender | ell | ell_percent | homeless | homeless_percent | low_income | free_and_reduced | free_and_reduced_percent | disability | section_504 | total | white_int | black_int | hispanic_int | native_american_int | native_american_alaskan_native_int | asian_int | native_hawaiian_int | asian_pacific_islander_int | native_hawaiian_pacific_islander_int | pacific_islander_int | multiracial_int | unknown_race_int | male_int | female_int | non_binary_int | unknown_gender_int | ell_int | homeless_int | low_income_int | free_and_reduced_int | disability_int | section_504_int | total_int |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2452683 | 2452683 | CT | school | 903990 | 1240011 | Seymour School District | 90399000794 | 1245111 | Seymour Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 373 | 25 | 99 | * | 19 | 0 | * | 264 | 260 | 7 | 77 | 524 | 373 | 25 | 99 | 19 | 0 | 264 | 260 | 7 | 77 | 524 | |||||||||||||||||||||||||||||||
2451772 | 2451772 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000066 | 151211 | Hallen School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 30 | 154 | 98 | 0 | * | 0 | * | 163 | 126 | 8 | 70 | 289 | 30 | 154 | 98 | 0 | 0 | 163 | 126 | 8 | 70 | 289 | |||||||||||||||||||||||||||||||
2452948 | 2452948 | CT | school | 904860 | 1520011 | Waterford School District | 90486001001 | 1526111 | Waterford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 643 | 19 | 98 | * | 52 | * | 20 | 432 | * | 7 | 138 | 838 | 643 | 19 | 98 | 52 | 20 | 432 | 7 | 138 | 838 | ||||||||||||||||||||||||||||||||
2452982 | 2452982 | CT | school | 904950 | 1560011 | West Haven School District | 90495001027 | 1560811 | Alma E. Pagels School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 143 | 82 | 98 | * | 24 | 0 | * | 210 | 150 | 68 | 101 | 360 | 143 | 82 | 98 | 24 | 0 | 210 | 150 | 68 | 101 | 360 | |||||||||||||||||||||||||||||||
2451806 | 2451806 | CT | school | 900510 | 170011 | Bristol School District | 90051000096 | 170311 | Edgewood School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 147 | 8 | 97 | 0 | 13 | 0 | 11 | 142 | * | 14 | 32 | 276 | 147 | 8 | 97 | 0 | 13 | 0 | 11 | 142 | 14 | 32 | 276 | ||||||||||||||||||||||||||||||
2451825 | 2451825 | CT | school | 900510 | 170011 | Bristol School District | 90051000104 | 175211 | Northeast Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 318 | 36 | 96 | * | 19 | * | 19 | 245 | 245 | 12 | 82 | 490 | 318 | 36 | 96 | 19 | 19 | 245 | 245 | 12 | 82 | 490 | |||||||||||||||||||||||||||||||
2451974 | 2451974 | CT | school | 901290 | 440011 | East Haven School District | 90129000218 | 441011 | Grove J. Tuttle School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 148 | 15 | 96 | * | 11 | 0 | * | 153 | 127 | 45 | 26 | 280 | 148 | 15 | 96 | 11 | 0 | 153 | 127 | 45 | 26 | 280 | |||||||||||||||||||||||||||||||
2452047 | 2452047 | CT | school | 901530 | 510011 | Fairfield School District | 90153000258 | 515211 | Fairfield Woods Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 697 | 24 | 96 | 0 | 62 | 0 | 31 | 457 | 453 | 10 | 115 | 910 | 697 | 24 | 96 | 0 | 62 | 0 | 31 | 457 | 453 | 10 | 115 | 910 | |||||||||||||||||||||||||||||
2453052 | 2453052 | CT | school | 905220 | 1640011 | Windsor School District | 90522001092 | 1640911 | Oliver Ellsworth School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 116 | 126 | 96 | * | * | 0 | 35 | 213 | 198 | 12 | 75 | 411 | 116 | 126 | 96 | 0 | 35 | 213 | 198 | 12 | 75 | 411 | |||||||||||||||||||||||||||||||
2453140 | 2453140 | CT | school | 900005 | 2190012 | Regional School District 19 | 90000501215 | 2196112 | E. O. Smith High School | Regional Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 783 | * | 96 | 0 | 45 | * | 144 | 533 | 558 | 9 | 135 | 1091 | 783 | 96 | 0 | 45 | 144 | 533 | 558 | 9 | 135 | 1091 | |||||||||||||||||||||||||||||||
2452263 | 2452263 | CT | school | 902310 | 770011 | Manchester School District | 90231000417 | 770111 | Bowers School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 154 | 71 | 95 | 0 | 15 | * | * | 181 | 159 | 19 | 62 | 340 | 154 | 71 | 95 | 0 | 15 | 181 | 159 | 19 | 62 | 340 | |||||||||||||||||||||||||||||||
2452986 | 2452986 | CT | school | 904950 | 1560011 | West Haven School District | 90495001039 | 1560411 | Seth G. Haley School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 197 | 61 | 95 | * | 13 | 0 | * | 206 | 175 | 65 | 62 | 381 | 197 | 61 | 95 | 13 | 0 | 206 | 175 | 65 | 62 | 381 | |||||||||||||||||||||||||||||||
2452473 | 2452473 | CT | school | 902790 | 930011 | New Haven School District | 90279000585 | 936111 | Wilbur Cross High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 179 | 429 | 944 | * | 34 | 0 | * | 805 | 789 | 314 | 254 | 1594 | 179 | 429 | 944 | 34 | 0 | 805 | 789 | 314 | 254 | 1594 | |||||||||||||||||||||||||||||||
2452983 | 2452983 | CT | school | 904950 | 1560011 | West Haven School District | 90495001033 | 1560611 | Edith E. Mackrille School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 122 | 70 | 94 | 0 | 27 | 0 | 9 | 157 | 165 | 46 | 58 | 322 | 122 | 70 | 94 | 0 | 27 | 0 | 9 | 157 | 165 | 46 | 58 | 322 | |||||||||||||||||||||||||||||
2451730 | 2451730 | CT | school | 900210 | 70011 | Berlin School District | 90021000016 | 76111 | Berlin High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 724 | 23 | 93 | 0 | 35 | 0 | 24 | 487 | 412 | 6 | 94 | 899 | 724 | 23 | 93 | 0 | 35 | 0 | 24 | 487 | 412 | 6 | 94 | 899 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2453015 | 2453015 | CT | school | 905070 | 1590011 | Wethersfield School District | 90507001061 | 1590211 | Emerson-Williams School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 285 | 15 | 93 | 0 | 16 | 0 | 23 | 218 | 214 | 60 | 57 | 432 | 285 | 15 | 93 | 0 | 16 | 0 | 23 | 218 | 214 | 60 | 57 | 432 | |||||||||||||||||||||||||||||
2452791 | 2452791 | CT | school | 904440 | 1380011 | Stratford School District | 90444000887 | 1380311 | Chapel School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 189 | 47 | 92 | 0 | 10 | 0 | 6 | 185 | 159 | 21 | 30 | 344 | 189 | 47 | 92 | 0 | 10 | 0 | 6 | 185 | 159 | 21 | 30 | 344 | |||||||||||||||||||||||||||||
2451734 | 2451734 | CT | school | 900270 | 90011 | Bethel School District | 90027000023 | 90411 | Anna H. Rockwell School | Public Schools | Regular School | No | Elementary | KG | 03 | 2019 | pk_12_total | 279 | * | 91 | * | 22 | 0 | 17 | 225 | 204 | 50 | 34 | 429 | 279 | 91 | 22 | 0 | 17 | 225 | 204 | 50 | 34 | 429 | |||||||||||||||||||||||||||||||
2452102 | 2452102 | CT | school | 901770 | 590011 | Groton School District | 90177000321 | 591711 | Mary Morrisson School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 202 | 21 | 91 | * | 36 | * | 31 | 188 | 197 | 18 | 88 | 385 | 202 | 21 | 91 | 36 | 31 | 188 | 197 | 18 | 88 | 385 | |||||||||||||||||||||||||||||||
2452312 | 2452312 | CT | school | 902490 | 830011 | Middletown School District | 90249000461 | 831111 | Snow School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 172 | 60 | 91 | 0 | 18 | 0 | 39 | 211 | 169 | 19 | 72 | 380 | 172 | 60 | 91 | 0 | 18 | 0 | 39 | 211 | 169 | 19 | 72 | 380 | |||||||||||||||||||||||||||||
2452426 | 2452426 | CT | school | 902790 | 930011 | New Haven School District | 90279000551 | 930911 | Davis Academy for Arts & Design Innovation | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 99 | 309 | 91 | * | * | 0 | 10 | 251 | 266 | 8 | 59 | 517 | 99 | 309 | 91 | 0 | 10 | 251 | 266 | 8 | 59 | 517 | |||||||||||||||||||||||||||||||
2452443 | 2452443 | CT | school | 902790 | 930011 | New Haven School District | 90279000586 | 933211 | Wexler/Grant Community School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 10 | 266 | 91 | 0 | 0 | 0 | 6 | 196 | 177 | 18 | 56 | 373 | 10 | 266 | 91 | 0 | 0 | 0 | 6 | 196 | 177 | 18 | 56 | 373 | |||||||||||||||||||||||||||||
2452793 | 2452793 | CT | school | 904440 | 1380011 | Stratford School District | 90444000893 | 1380811 | Lordship School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 91 | 100 | 91 | * | * | 0 | 15 | 152 | 151 | 21 | 39 | 303 | 91 | 100 | 91 | 0 | 15 | 152 | 151 | 21 | 39 | 303 | |||||||||||||||||||||||||||||||
2452491 | 2452491 | CT | school | 902880 | 940011 | Newington School District | 90288000611 | 940611 | Anna Reynolds School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 235 | 29 | 90 | 0 | 42 | 0 | 23 | 197 | 222 | 46 | 56 | 419 | 235 | 29 | 90 | 0 | 42 | 0 | 23 | 197 | 222 | 46 | 56 | 419 | |||||||||||||||||||||||||||||
2452855 | 2452855 | CT | school | 904680 | 1460011 | Vernon School District | 90468000941 | 1460211 | Maple Street School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 92 | 45 | 90 | 0 | * | * | 27 | 135 | 138 | * | 32 | 273 | 92 | 45 | 90 | 0 | 27 | 135 | 138 | 32 | 273 | ||||||||||||||||||||||||||||||||
2452862 | 2452862 | CT | school | 904740 | 1480011 | Wallingford School District | 90474000950 | 1481011 | Cook Hill School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 239 | * | 90 | 0 | 17 | 0 | * | 213 | 149 | 37 | 91 | 362 | 239 | 90 | 0 | 17 | 0 | 213 | 149 | 37 | 91 | 362 | |||||||||||||||||||||||||||||||
2452920 | 2452920 | CT | school | 1510011 | Waterbury School District | 90483001418 | 1519111 | Enlightenment School | Program | 2019 | pk_12_total | 13 | 46 | 90 | 0 | 0 | 0 | 6 | 97 | 58 | 19 | 41 | 155 | 13 | 46 | 90 | 0 | 0 | 0 | 6 | 97 | 58 | 19 | 41 | 155 | |||||||||||||||||||||||||||||||||||
2451901 | 2451901 | CT | school | 2430014 | Cooperative Educational Services | 2430214 | Transition Learning Center | Program | 2019 | pk_12_total | 14 | 6 | 9 | 0 | * | 0 | * | 25 | 7 | 0 | 32 | 32 | 14 | 6 | 9 | 0 | 0 | 25 | 7 | 0 | 32 | 32 | ||||||||||||||||||||||||||||||||||||||
2451945 | 2451945 | CT | school | 901170 | 400011 | East Granby School District | 90117000180 | 400111 | Allgrove School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 151 | 10 | 9 | * | 11 | * | 6 | 105 | 84 | * | 23 | 189 | 151 | 10 | 9 | 11 | 6 | 105 | 84 | 23 | 189 | ||||||||||||||||||||||||||||||||
2452063 | 2452063 | CT | school | 901590 | 530011 | Franklin School District | 90159000278 | 530111 | Franklin Elementary School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 125 | 8 | 9 | 0 | * | 0 | * | 83 | 71 | 0 | 9 | 154 | 125 | 8 | 9 | 0 | 0 | 83 | 71 | 0 | 9 | 154 | |||||||||||||||||||||||||||||||
2452204 | 2452204 | CT | school | 640011 | Hartford School District | 645011 | iGOAL 2 - Weaver High School | 2019 | pk_12_total | 0 | 6 | 9 | 0 | 0 | 0 | 0 | 8 | 7 | * | 15 | 15 | 0 | 6 | 9 | 0 | 0 | 0 | 0 | 8 | 7 | 15 | 15 | ||||||||||||||||||||||||||||||||||||||
2452275 | 2452275 | CT | school | 770011 | Manchester School District | 90231001717 | 770711 | New Horizons | Program | 2019 | pk_12_total | 6 | 8 | 9 | * | * | 0 | 0 | 16 | 9 | 0 | 8 | 25 | 6 | 8 | 9 | 0 | 0 | 16 | 9 | 0 | 8 | 25 | |||||||||||||||||||||||||||||||||||||
2452307 | 2452307 | CT | school | 800011 | Meriden School District | 801811 | STARS - HS | Program | 2019 | pk_12_total | * | * | 9 | 0 | * | 0 | 0 | * | * | 6 | 16 | 16 | 9 | 0 | 0 | 0 | 6 | 16 | 16 | |||||||||||||||||||||||||||||||||||||||||
2452364 | 2452364 | CT | school | 880011 | Naugatuck School District | 90264001591 | 888211 | Central Avenue Preschool | Program | 2019 | pk_12_total | 18 | * | 9 | 0 | 0 | 0 | * | 21 | 9 | 0 | * | 30 | 18 | 9 | 0 | 0 | 0 | 21 | 9 | 0 | 30 | ||||||||||||||||||||||||||||||||||||||
2452396 | 2452396 | CT | school | 890011 | New Britain School District | 891711 | Slade KEY Middle | Program | 2019 | pk_12_total | * | * | 9 | 0 | * | 0 | * | * | * | * | 17 | 17 | 9 | 0 | 0 | 17 | 17 | |||||||||||||||||||||||||||||||||||||||||||
2452420 | 2452420 | CT | school | 930011 | New Haven School District | 933411 | Benjamin Jepson Head Start | Program | 2019 | pk_12_total | 0 | * | 9 | 0 | 0 | 0 | * | 10 | 6 | 0 | 8 | 16 | 0 | 9 | 0 | 0 | 0 | 10 | 6 | 0 | 8 | 16 | ||||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2452609 | 2452609 | CT | school | 903515 | 2060012 | Regional School District 06 | 90351500724 | 2060212 | James Morris School | Regional Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 116 | * | 9 | * | 0 | 0 | * | 72 | * | * | 30 | 132 | 116 | 9 | 0 | 0 | 72 | 30 | 132 | ||||||||||||||||||||||||||||||||||
2452646 | 2452646 | CT | school | 903539 | 2170012 | Regional School District 17 | 90353900758 | 2170112 | Haddam Elementary School | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 156 | * | 9 | 0 | * | 0 | 8 | 95 | 81 | * | 25 | 176 | 156 | 9 | 0 | 0 | 8 | 95 | 81 | 25 | 176 | |||||||||||||||||||||||||||||||||
2453045 | 2453045 | CT | school | 1630011 | Windham School District | 1631211 | Assisted Work Program | Program | 2019 | pk_12_total | * | 0 | 9 | * | 0 | 0 | 0 | * | * | * | 12 | 12 | 0 | 9 | 0 | 0 | 0 | 12 | 12 | |||||||||||||||||||||||||||||||||||||||||
2453135 | 2453135 | CT | school | 900018 | 2720013 | Explorations District | 90001800834 | 2726113 | Explorations | Public Charter Schools | Regular School | Yes | High | 09 | 12 | 2019 | pk_12_total | 75 | * | 9 | 0 | 0 | 0 | * | 35 | 53 | 0 | 27 | 88 | 75 | 9 | 0 | 0 | 0 | 35 | 53 | 0 | 27 | 88 | |||||||||||||||||||||||||||||||
2453021 | 2453021 | CT | school | 905070 | 1590011 | Wethersfield School District | 90507001066 | 1595211 | Silas Deane Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 379 | 23 | 89 | * | 21 | * | 20 | 267 | 268 | 24 | 81 | 535 | 379 | 23 | 89 | 21 | 20 | 267 | 268 | 24 | 81 | 535 | |||||||||||||||||||||||||||||||
2452354 | 2452354 | CT | school | 902550 | 850011 | Monroe School District | 90255000489 | 856111 | Masuk High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 801 | 22 | 88 | 0 | 52 | 0 | 34 | 503 | 494 | 6 | 112 | 997 | 801 | 22 | 88 | 0 | 52 | 0 | 34 | 503 | 494 | 6 | 112 | 997 | |||||||||||||||||||||||||||||
2452492 | 2452492 | CT | school | 902880 | 940011 | Newington School District | 90288000604 | 940211 | Elizabeth Green School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 142 | 12 | 88 | 0 | 25 | 0 | 18 | 151 | 134 | 35 | 54 | 285 | 142 | 12 | 88 | 0 | 25 | 0 | 18 | 151 | 134 | 35 | 54 | 285 | |||||||||||||||||||||||||||||
2453055 | 2453055 | CT | school | 905220 | 1640011 | Windsor School District | 90522001089 | 1640811 | John F. Kennedy School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2019 | pk_12_total | 97 | 135 | 88 | * | * | 0 | 23 | 188 | 177 | 15 | 60 | 365 | 97 | 135 | 88 | 0 | 23 | 188 | 177 | 15 | 60 | 365 | |||||||||||||||||||||||||||||||
2452482 | 2452482 | CT | school | 902820 | 950011 | New London School District | 90282001919 | 951411 | New London Visual and Performing Arts Magnet School | Public Schools | Regular School | No | Middle | 06 | 09 | 2019 | pk_12_total | 55 | 38 | 87 | * | * | 0 | 21 | 92 | 112 | 25 | 46 | 204 | 55 | 38 | 87 | 0 | 21 | 92 | 112 | 25 | 46 | 204 | |||||||||||||||||||||||||||||||
2452677 | 2452677 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000785 | 1196111 | Rocky Hill High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 495 | 36 | 87 | * | 105 | 0 | * | 373 | 368 | 10 | 103 | 741 | 495 | 36 | 87 | 105 | 0 | 373 | 368 | 10 | 103 | 741 | |||||||||||||||||||||||||||||||
2451735 | 2451735 | CT | school | 900270 | 90011 | Bethel School District | 90027001118 | 90511 | Ralph M. T. Johnson School | Public Schools | Regular School | No | Elementary | 04 | 05 | 2019 | pk_12_total | 323 | 15 | 86 | 6 | 32 | 0 | 22 | 261 | 223 | 31 | 62 | 484 | 323 | 15 | 86 | 6 | 32 | 0 | 22 | 261 | 223 | 31 | 62 | 484 | |||||||||||||||||||||||||||||
2452072 | 2452072 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000282 | 545211 | Smith Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 681 | * | 86 | * | 108 | 0 | 45 | * | 495 | * | 112 | 952 | 681 | 86 | 108 | 0 | 45 | 495 | 112 | 952 | |||||||||||||||||||||||||||||||||
2452367 | 2452367 | CT | school | 902640 | 880011 | Naugatuck School District | 90264000506 | 880511 | Hop Brook Elementary School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 161 | 31 | 86 | 0 | 9 | 0 | 27 | 155 | 159 | 51 | 47 | 314 | 161 | 31 | 86 | 0 | 9 | 0 | 27 | 155 | 159 | 51 | 47 | 314 | |||||||||||||||||||||||||||||
2451804 | 2451804 | CT | school | 900510 | 170011 | Bristol School District | 90051000103 | 171711 | Mountain View School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 211 | 15 | 85 | 0 | 21 | 0 | 18 | 166 | 184 | 25 | 46 | 350 | 211 | 15 | 85 | 0 | 21 | 0 | 18 | 166 | 184 | 25 | 46 | 350 | |||||||||||||||||||||||||||||
2452068 | 2452068 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000287 | 540711 | Naubuc School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 201 | 31 | 85 | 0 | 41 | 0 | 37 | 210 | 185 | 37 | 48 | 395 | 201 | 31 | 85 | 0 | 41 | 0 | 37 | 210 | 185 | 37 | 48 | 395 | |||||||||||||||||||||||||||||
2452106 | 2452106 | CT | school | 901770 | 590011 | Groton School District | 90177000312 | 595311 | Carl C. Cutler Middle School | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 310 | 22 | 85 | * | 26 | * | 44 | * | 266 | 6 | 80 | 494 | 310 | 22 | 85 | 26 | 44 | 266 | 6 | 80 | 494 | |||||||||||||||||||||||||||||||||
2452437 | 2452437 | CT | school | 930011 | New Haven School District | 938011 | Lulac | 2019 | pk_12_total | * | 28 | 85 | 0 | 0 | * | 0 | 61 | 56 | 0 | 8 | 117 | 28 | 85 | 0 | 0 | 0 | 61 | 56 | 0 | 8 | 117 | |||||||||||||||||||||||||||||||||||||||
2452970 | 2452970 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001026 | 1551511 | Wolcott School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 176 | 28 | 85 | * | 65 | 0 | * | 176 | 203 | 52 | 45 | 379 | 176 | 28 | 85 | 65 | 0 | 176 | 203 | 52 | 45 | 379 | |||||||||||||||||||||||||||||||
2452202 | 2452202 | CT | school | 901920 | 640011 | Hartford School District | 90192001381 | 646711 | University High School of Science and Engineering | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 109 | 176 | 84 | * | 41 | * | 17 | 282 | 149 | 18 | 41 | 431 | 109 | 176 | 84 | 41 | 17 | 282 | 149 | 18 | 41 | 431 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2451729 | 2451729 | CT | school | 900210 | 70011 | Berlin School District | 90021000017 | 75111 | Catherine M. McGee Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 548 | * | 83 | * | 19 | 0 | 19 | 361 | 324 | 10 | 100 | 685 | 548 | 83 | 19 | 0 | 19 | 361 | 324 | 10 | 100 | 685 | |||||||||||||||||||||||||||||||
2452089 | 2452089 | CT | school | 901710 | 570011 | Greenwich School District | 90171000308 | 571011 | Riverside School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 360 | 0 | 83 | 0 | 25 | 0 | 16 | 264 | 220 | 24 | 30 | 484 | 360 | 0 | 83 | 0 | 25 | 0 | 16 | 264 | 220 | 24 | 30 | 484 | |||||||||||||||||||||||||||||
2452162 | 2452162 | CT | school | 901920 | 640011 | Hartford School District | 90192000376 | 641711 | Rawson School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 0 | 268 | 83 | * | 0 | * | 8 | 185 | 177 | 53 | 67 | 362 | 0 | 268 | 83 | 0 | 8 | 185 | 177 | 53 | 67 | 362 | |||||||||||||||||||||||||||||||
2452436 | 2452436 | CT | school | 902790 | 930011 | New Haven School District | 90279000566 | 932011 | Lincoln-Bassett School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | * | 268 | 83 | 0 | 9 | 0 | * | 210 | 161 | 10 | 70 | 371 | 268 | 83 | 0 | 9 | 0 | 210 | 161 | 10 | 70 | 371 | |||||||||||||||||||||||||||||||
2452505 | 2452505 | CT | school | 902910 | 970011 | Newtown School District | 90291000615 | 976111 | Newtown High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1383 | 18 | 83 | 0 | 69 | 0 | 22 | 811 | * | * | 143 | 1575 | 1383 | 18 | 83 | 0 | 69 | 0 | 22 | 811 | 143 | 1575 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2452841 | 2452841 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000934 | 1440311 | Middlebrook School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 302 | 39 | 83 | 0 | 71 | * | * | 255 | 246 | 46 | 53 | 501 | 302 | 39 | 83 | 0 | 71 | 255 | 246 | 46 | 53 | 501 | |||||||||||||||||||||||||||||||
2452775 | 2452775 | CT | school | 904320 | 1350011 | Stamford School District | 90432000871 | 1356311 | Westhill High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 798 | 324 | 825 | * | 134 | * | 40 | 1060 | 1067 | 395 | 277 | 2127 | 798 | 324 | 825 | 134 | 40 | 1060 | 1067 | 395 | 277 | 2127 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
2451758 | 2451758 | CT | school | 900420 | 140011 | Branford School District | 90042000039 | 146111 | Branford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 622 | 33 | 82 | 0 | 71 | 0 | 20 | 408 | 420 | 17 | 116 | 828 | 622 | 33 | 82 | 0 | 71 | 0 | 20 | 408 | 420 | 17 | 116 | 828 | |||||||||||||||||||||||||||||
2451966 | 2451966 | CT | school | 430011 | East Hartford School District | 90126000205 | 439011 | Woodland School | Program | 2019 | pk_12_total | 20 | 63 | 82 | * | * | 0 | 9 | 146 | 32 | 11 | * | 178 | 20 | 63 | 82 | 0 | 9 | 146 | 32 | 11 | 178 | ||||||||||||||||||||||||||||||||||||||
2452083 | 2452083 | CT | school | 901710 | 570011 | Greenwich School District | 90171000296 | 570211 | Cos Cob School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 258 | * | 82 | 0 | * | 0 | 35 | 211 | 200 | 43 | 36 | 411 | 258 | 82 | 0 | 0 | 35 | 211 | 200 | 43 | 36 | 411 | |||||||||||||||||||||||||||||||
2452118 | 2452118 | CT | school | 901800 | 600011 | Guilford School District | 90180000332 | 606111 | Guilford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 921 | 14 | 82 | 0 | 47 | 0 | 31 | 542 | 553 | * | 125 | 1095 | 921 | 14 | 82 | 0 | 47 | 0 | 31 | 542 | 553 | 125 | 1095 | ||||||||||||||||||||||||||||||
2453105 | 2453105 | CT | school | 905372 | 9020022 | The Gilbert School District | 90537201222 | 9026122 | The Gilbert School | Endowed and Incorporated Academies Schools | Regular School | No | High | 07 | 12 | 2019 | pk_12_total | 348 | 8 | 82 | 0 | 50 | 0 | 23 | 275 | * | 16 | 74 | 511 | 348 | 8 | 82 | 0 | 50 | 0 | 23 | 275 | 16 | 74 | 511 | ||||||||||||||||||||||||||||||
2452314 | 2452314 | CT | school | 902490 | 830011 | Middletown School District | 90249000455 | 830511 | Farm Hill School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 132 | 64 | 81 | 0 | 11 | 0 | 36 | 153 | 171 | 16 | 22 | 324 | 132 | 64 | 81 | 0 | 11 | 0 | 36 | 153 | 171 | 16 | 22 | 324 | |||||||||||||||||||||||||||||
2452684 | 2452684 | CT | school | 903990 | 1240011 | Seymour School District | 90399000793 | 1246111 | Seymour High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 511 | 35 | 81 | * | 26 | 0 | * | 318 | 342 | 9 | 81 | 660 | 511 | 35 | 81 | 26 | 0 | 318 | 342 | 9 | 81 | 660 | |||||||||||||||||||||||||||||||
2452832 | 2452832 | CT | school | 904590 | 1430011 | Torrington School District | 90459000922 | 1430811 | Southwest School | Public Schools | Regular School | No | Elementary | 04 | 05 | 2019 | pk_12_total | 177 | 12 | 81 | 0 | 12 | 0 | 15 | 150 | 147 | 29 | 67 | 297 | 177 | 12 | 81 | 0 | 12 | 0 | 15 | 150 | 147 | 29 | 67 | 297 | |||||||||||||||||||||||||||||
2452960 | 2452960 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001024 | 1551211 | Webster Hill School | Public Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 187 | 25 | 81 | 0 | 38 | 0 | 14 | 160 | 185 | 53 | 42 | 345 | 187 | 25 | 81 | 0 | 38 | 0 | 14 | 160 | 185 | 53 | 42 | 345 | |||||||||||||||||||||||||||||
2453053 | 2453053 | CT | school | 905220 | 1640011 | Windsor School District | 90522001093 | 1640511 | Poquonock Elementary School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 88 | 117 | 81 | 0 | 22 | 0 | 25 | 175 | 158 | 6 | 57 | 333 | 88 | 117 | 81 | 0 | 22 | 0 | 25 | 175 | 158 | 6 | 57 | 333 | |||||||||||||||||||||||||||||
2452104 | 2452104 | CT | school | 901770 | 590011 | Groton School District | 90177000313 | 591811 | Charles Barnum School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 210 | 28 | 80 | * | 12 | * | 35 | 197 | 171 | 6 | 50 | 368 | 210 | 28 | 80 | 12 | 35 | 197 | 171 | 6 | 50 | 368 | |||||||||||||||||||||||||||||||
2452718 | 2452718 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000827 | 1325111 | Timothy Edwards School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 563 | 62 | 80 | 0 | 220 | * | * | 499 | 482 | 14 | 124 | 981 | 563 | 62 | 80 | 0 | 220 | 499 | 482 | 14 | 124 | 981 | |||||||||||||||||||||||||||||||
2451808 | 2451808 | CT | school | 170011 | Bristol School District | 90051001755 | 173011 | South Side Extended Resource | Program | 2019 | pk_12_total | * | 0 | 8 | 0 | 0 | 0 | * | * | * | * | 12 | 12 | 0 | 8 | 0 | 0 | 0 | 12 | 12 | ||||||||||||||||||||||||||||||||||||||||
2451817 | 2451817 | CT | school | 170011 | Bristol School District | 90051001429 | 179011 | Alternative Special Education Program (ASEP) | Program | 2019 | pk_12_total | 8 | * | 8 | 0 | 0 | * | 0 | * | * | * | 20 | 20 | 8 | 8 | 0 | 0 | 0 | 20 | 20 | ||||||||||||||||||||||||||||||||||||||||
2451840 | 2451840 | CT | school | 900660 | 220011 | Canterbury School District | 90066001187 | 225111 | Dr. Helen Baldwin Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | pk_12_total | 167 | * | 8 | 0 | 0 | 0 | * | 93 | 86 | 0 | 22 | 179 | 167 | 8 | 0 | 0 | 0 | 93 | 86 | 0 | 22 | 179 | |||||||||||||||||||||||||||||||
2452070 | 2452070 | CT | school | 540011 | Glastonbury School District | 90162001801 | 540111 | Links Academy | Program | 2019 | pk_12_total | 23 | 0 | 8 | * | 0 | 0 | * | 25 | 8 | * | 33 | 33 | 23 | 0 | 8 | 0 | 0 | 25 | 8 | 33 | 33 | ||||||||||||||||||||||||||||||||||||||
2452094 | 2452094 | CT | school | 570011 | Greenwich School District | 571511 | Windrose | Program | 2019 | pk_12_total | * | * | 8 | 0 | 0 | 0 | 0 | * | * | * | 8 | 20 | 8 | 0 | 0 | 0 | 0 | 8 | 20 | |||||||||||||||||||||||||||||||||||||||||
2452131 | 2452131 | CT | school | 620011 | Hamden School District | 621311 | Church Street IIC | Program | 2019 | pk_12_total | * | 7 | 8 | 0 | * | 0 | 0 | 13 | 7 | * | 20 | 20 | 7 | 8 | 0 | 0 | 0 | 13 | 7 | 20 | 20 | |||||||||||||||||||||||||||||||||||||||
2452276 | 2452276 | CT | school | 770011 | Manchester School District | 90231001599 | 779111 | Manchester Transition Center | Program | 2019 | pk_12_total | * | 6 | 8 | 0 | * | 0 | 0 | 16 | 6 | * | 22 | 22 | 6 | 8 | 0 | 0 | 0 | 16 | 6 | 22 | 22 | ||||||||||||||||||||||||||||||||||||||
2452357 | 2452357 | CT | school | 860011 | Montville School District | 90258001663 | 860311 | Pre School Program | Program | 2019 | pk_12_total | 26 | * | 8 | 0 | * | 0 | 9 | 24 | 22 | 0 | 20 | 46 | 26 | 8 | 0 | 0 | 9 | 24 | 22 | 0 | 20 | 46 | |||||||||||||||||||||||||||||||||||||
2452449 | 2452449 | CT | school | 930011 | New Haven School District | 937211 | Brennan Rogers Self Contained Autism | Program | 2019 | pk_12_total | * | 12 | 8 | 0 | 0 | 0 | * | * | * | 0 | 23 | 23 | 12 | 8 | 0 | 0 | 0 | 0 | 23 | 23 | ||||||||||||||||||||||||||||||||||||||||
2452612 | 2452612 | CT | school | 903520 | 2100012 | Regional School District 10 | 90352000728 | 2100312 | Harwinton Consolidated School | Regional Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 329 | 6 | 8 | * | 0 | 0 | * | 173 | 175 | * | 54 | 348 | 329 | 6 | 8 | 0 | 0 | 173 | 175 | 54 | 348 | ||||||||||||||||||||||||||||||||
2452627 | 2452627 | CT | school | 903536 | 2140012 | Regional School District 14 | 90353600743 | 2140112 | Bethlehem Elementary School | Regional Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 249 | * | 8 | * | * | 0 | 6 | 139 | 129 | * | 39 | 268 | 249 | 8 | 0 | 6 | 139 | 129 | 39 | 268 | |||||||||||||||||||||||||||||||||
2452927 | 2452927 | CT | school | 1510011 | Waterbury School District | 1514411 | Wallace BDLC | Program | 2019 | pk_12_total | * | * | 8 | 0 | 0 | 0 | 0 | * | * | 0 | 14 | 14 | 8 | 0 | 0 | 0 | 0 | 0 | 14 | 14 | ||||||||||||||||||||||||||||||||||||||||
2452969 | 2452969 | CT | school | 1550011 | West Hartford School District | 90492001790 | 1559611 | Wolcott Learning Center | Program | 2019 | pk_12_total | 7 | * | 8 | 0 | * | 0 | * | 13 | 6 | * | 19 | 19 | 7 | 8 | 0 | 0 | 13 | 6 | 19 | 19 | |||||||||||||||||||||||||||||||||||||||
2451887 | 2451887 | CT | school | 900810 | 270011 | Clinton School District | 90081000134 | 276111 | The Morgan School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 477 | * | 79 | * | 15 | * | 6 | 303 | 279 | 19 | 69 | 582 | 477 | 79 | 15 | 6 | 303 | 279 | 19 | 69 | 582 | ||||||||||||||||||||||||||||||||
2452258 | 2452258 | CT | school | 902310 | 770011 | Manchester School District | 90231000418 | 770311 | Buckley School | Public Schools | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 154 | 89 | 79 | * | 41 | 0 | * | 205 | 161 | 27 | 56 | 366 | 154 | 89 | 79 | 41 | 0 | 205 | 161 | 27 | 56 | 366 | |||||||||||||||||||||||||||||||
2452366 | 2452366 | CT | school | 902640 | 880011 | Naugatuck School District | 90264000499 | 880811 | Andrew Avenue School | Public Schools | Regular School | No | Elementary | KG | 04 | 2019 | pk_12_total | 138 | 14 | 79 | 0 | * | 0 | * | 118 | 126 | 35 | 19 | 244 | 138 | 14 | 79 | 0 | 0 | 118 | 126 | 35 | 19 | 244 | |||||||||||||||||||||||||||||||
2453018 | 2453018 | CT | school | 905070 | 1590011 | Wethersfield School District | 90507001060 | 1591011 | Charles Wright School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 213 | 7 | 79 | 0 | 11 | 0 | 18 | 168 | 160 | 87 | 41 | 328 | 213 | 7 | 79 | 0 | 11 | 0 | 18 | 168 | 160 | 87 | 41 | 328 | |||||||||||||||||||||||||||||
2451970 | 2451970 | CT | school | 901260 | 430011 | East Hartford School District | 90126000200 | 436211 | East Hartford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 230 | 624 | 782 | * | 101 | * | 34 | 948 | 829 | 147 | 311 | 1777 | 230 | 624 | 782 | 101 | 34 | 948 | 829 | 147 | 311 | 1777 | |||||||||||||||||||||||||||||||
2452040 | 2452040 | CT | school | 901530 | 510011 | Fairfield School District | 90153000260 | 510411 | Holland Hill School | Public Schools | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 220 | 13 | 78 | 0 | 25 | 0 | 23 | 180 | 179 | 28 | 46 | 359 | 220 | 13 | 78 | 0 | 25 | 0 | 23 | 180 | 179 | 28 | 46 | 359 | |||||||||||||||||||||||||||||
2452244 | 2452244 | CT | school | 902160 | 720011 | Ledyard School District | 90216000401 | 726111 | Ledyard High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 557 | 53 | 78 | * | 26 | * | 29 | 372 | 394 | 6 | 146 | 766 | 557 | 53 | 78 | 26 | 29 | 372 | 394 | 6 | 146 | 766 |
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]);