enrollments
Data source: Big Local News · About: Big Local
1,461 rows where grade = "pk_12_total", state = "CT" and year = 2020 sorted by black descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2777728 | 2777728 | CT | school | 900060 | 20011 | Ansonia School District | 90006001020 | 20811 | Prendergast School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 212 | 99 | 261 | 0 | 16 | 0 | 51 | 338 | 301 | 38 | 113 | 639 | 212 | 99 | 261 | 0 | 16 | 0 | 51 | 338 | 301 | 38 | 113 | 639 | |||||||||||||||||||||||||||||
2778256 | 2778256 | CT | school | 903450 | 2450014 | Learn | 90345001581 | 2456014 | Connecticut River Academy at Goodwin University | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 78 | 99 | 270 | * | 17 | * | 15 | 226 | 255 | 39 | 81 | 481 | 78 | 99 | 270 | 17 | 15 | 226 | 255 | 39 | 81 | 481 | |||||||||||||||||||||||||||||||
2778922 | 2778922 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000986 | 1512011 | Sprague School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 45 | 99 | 322 | 0 | * | 0 | * | 246 | 243 | 63 | 44 | 489 | 45 | 99 | 322 | 0 | 0 | 246 | 243 | 63 | 44 | 489 | |||||||||||||||||||||||||||||||
2778181 | 2778181 | CT | school | 901920 | 640011 | Hartford School District | 90192000368 | 641011 | Kennelly School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 26 | 98 | 495 | * | 12 | * | * | 315 | 329 | 204 | 101 | 644 | 26 | 98 | 495 | 12 | 315 | 329 | 204 | 101 | 644 | ||||||||||||||||||||||||||||||||
2778225 | 2778225 | CT | school | 901920 | 640011 | Hartford School District | 90192001403 | 647911 | Great Path Academy at MCC | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 61 | 98 | 144 | 0 | 11 | 0 | 6 | 113 | 207 | 15 | 35 | 320 | 61 | 98 | 144 | 0 | 11 | 0 | 6 | 113 | 207 | 15 | 35 | 320 | |||||||||||||||||||||||||||||
2778882 | 2778882 | CT | school | 904680 | 1460011 | Vernon School District | 90468000943 | 1466111 | Rockville High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 543 | 98 | 132 | * | 42 | 0 | * | 417 | 434 | 15 | 149 | 851 | 543 | 98 | 132 | 42 | 0 | 417 | 434 | 15 | 149 | 851 | |||||||||||||||||||||||||||||||
2778909 | 2778909 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000966 | 1512111 | B. W. Tinker School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 130 | 98 | 276 | 0 | 6 | 0 | 28 | 266 | 272 | 79 | 62 | 538 | 130 | 98 | 276 | 0 | 6 | 0 | 28 | 266 | 272 | 79 | 62 | 538 | |||||||||||||||||||||||||||||
2778200 | 2778200 | CT | school | 901920 | 640011 | Hartford School District | 90192000358 | 642311 | Burr Middle School | Public Schools | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 15 | 97 | 455 | * | 7 | 0 | * | 321 | 258 | 239 | 97 | 579 | 15 | 97 | 455 | 7 | 0 | 321 | 258 | 239 | 97 | 579 | |||||||||||||||||||||||||||||||
2777989 | 2777989 | CT | school | 430011 | East Hartford School District | 430211 | Early Childhood Learning Center at Hockanum School | Program | 2020 | pk_12_total | 42 | 95 | 162 | 0 | 15 | * | * | 176 | 145 | 0 | 86 | 321 | 42 | 95 | 162 | 0 | 15 | 176 | 145 | 0 | 86 | 321 | ||||||||||||||||||||||||||||||||||||||
2778745 | 2778745 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000826 | 1326211 | South Windsor High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 785 | 95 | 110 | 0 | 241 | * | * | 663 | 630 | 14 | 192 | 1293 | 785 | 95 | 110 | 0 | 241 | 663 | 630 | 14 | 192 | 1293 | |||||||||||||||||||||||||||||||
2778818 | 2778818 | CT | school | 904440 | 1380011 | Stratford School District | 90444000894 | 1380911 | Nichols School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 129 | 95 | 213 | * | * | 0 | 31 | 262 | 214 | 44 | 41 | 476 | 129 | 95 | 213 | 0 | 31 | 262 | 214 | 44 | 41 | 476 | |||||||||||||||||||||||||||||||
2778911 | 2778911 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000969 | 1510611 | Bunker Hill School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 66 | 95 | 280 | * | * | 0 | 19 | 267 | 207 | 71 | 76 | 474 | 66 | 95 | 280 | 0 | 19 | 267 | 207 | 71 | 76 | 474 | |||||||||||||||||||||||||||||||
2778000 | 2778000 | CT | school | 901260 | 430011 | East Hartford School District | 90126001275 | 432411 | Sunset Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 41 | 94 | 168 | 0 | 13 | 0 | 17 | 165 | 168 | 8 | 48 | 333 | 41 | 94 | 168 | 0 | 13 | 0 | 17 | 165 | 168 | 8 | 48 | 333 | |||||||||||||||||||||||||||||
2778315 | 2778315 | CT | school | 902400 | 800011 | Meriden School District | 90240000447 | 805211 | Lincoln Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 204 | 94 | 460 | * | * | 0 | 25 | 411 | 388 | 131 | 136 | 799 | 204 | 94 | 460 | 0 | 25 | 411 | 388 | 131 | 136 | 799 | |||||||||||||||||||||||||||||||
2777814 | 2777814 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000065 | 151111 | Hall School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 18 | 93 | 62 | 0 | * | 0 | * | 80 | 100 | 9 | 31 | 180 | 18 | 93 | 62 | 0 | 0 | 80 | 100 | 9 | 31 | 180 | |||||||||||||||||||||||||||||||
2777991 | 2777991 | CT | school | 901260 | 430011 | East Hartford School District | 90126000194 | 430611 | Dr. Franklin H. Mayberry School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 15 | 92 | 188 | 0 | 14 | 0 | 15 | 164 | 160 | 90 | 43 | 324 | 15 | 92 | 188 | 0 | 14 | 0 | 15 | 164 | 160 | 90 | 43 | 324 | |||||||||||||||||||||||||||||
2778040 | 2778040 | CT | school | 900216 | 2910013 | Elm City Montessori School District | 90021601683 | 2910113 | Elm City Montessori School | Public Charter Schools | Regular School | Yes | Elementary | PK | 05 | 2020 | pk_12_total | 68 | 92 | 53 | 0 | * | 0 | * | 114 | 115 | 6 | 13 | 229 | 68 | 92 | 53 | 0 | 0 | 114 | 115 | 6 | 13 | 229 | |||||||||||||||||||||||||||||||
2778963 | 2778963 | CT | school | 904830 | 1510011 | Waterbury School District | 90483001396 | 1516011 | Waterbury Arts Magnet School (High) | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 175 | 92 | 158 | * | * | 0 | 21 | 167 | 288 | 12 | 92 | 455 | 175 | 92 | 158 | 0 | 21 | 167 | 288 | 12 | 92 | 455 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2778810 | 2778810 | CT | school | 904440 | 1380011 | Stratford School District | 90444000889 | 1380411 | Franklin School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 40 | 91 | 180 | 0 | 9 | 0 | 15 | 165 | 170 | 36 | 37 | 335 | 40 | 91 | 180 | 0 | 9 | 0 | 15 | 165 | 170 | 36 | 37 | 335 | |||||||||||||||||||||||||||||
2778817 | 2778817 | CT | school | 904440 | 1380011 | Stratford School District | 90444000893 | 1380811 | Lordship School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 83 | 91 | 96 | 0 | 8 | 0 | 10 | 144 | 144 | 28 | 32 | 288 | 83 | 91 | 96 | 0 | 8 | 0 | 10 | 144 | 144 | 28 | 32 | 288 | |||||||||||||||||||||||||||||
2777754 | 2777754 | CT | school | 900210 | 70011 | Berlin School District | 90021000018 | 70411 | Emma Hart Willard School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 361 | 9 | 55 | 0 | 16 | 0 | 19 | 236 | 224 | 13 | 85 | 460 | 361 | 9 | 55 | 0 | 16 | 0 | 19 | 236 | 224 | 13 | 85 | 460 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2777890 | 2777890 | CT | school | 2410014 | Capitol Region Education Council | 90070001510 | 2419514 | River Street School Birken Campus | Program | 2020 | pk_12_total | 25 | 9 | 10 | 0 | * | 0 | * | 40 | 9 | * | 49 | 49 | 25 | 9 | 10 | 0 | 0 | 40 | 9 | 49 | 49 | ||||||||||||||||||||||||||||||||||||||
2777960 | 2777960 | CT | school | 340011 | Danbury School District | 90102001129 | 346211 | Alternative Center For Excellence | Program | 2020 | pk_12_total | 29 | 9 | 39 | 0 | * | 0 | * | 37 | 48 | * | 20 | 85 | 29 | 9 | 39 | 0 | 0 | 37 | 48 | 20 | 85 | ||||||||||||||||||||||||||||||||||||||
2777966 | 2777966 | CT | school | 901050 | 350011 | Darien School District | 90105000171 | 350511 | Royle Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 335 | 9 | 24 | 0 | 15 | 0 | 18 | 222 | 179 | 15 | 76 | 401 | 335 | 9 | 24 | 0 | 15 | 0 | 18 | 222 | 179 | 15 | 76 | 401 | |||||||||||||||||||||||||||||
2777978 | 2777978 | CT | school | 901170 | 400011 | East Granby School District | 90117000183 | 400211 | R. Dudley Seymour School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 134 | 9 | 17 | * | 12 | * | 7 | 94 | 87 | * | 30 | 181 | 134 | 9 | 17 | 12 | 7 | 94 | 87 | 30 | 181 | ||||||||||||||||||||||||||||||||
2778073 | 2778073 | CT | school | 901530 | 510011 | Fairfield School District | 90153000264 | 511611 | North Stratfield School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 285 | 9 | 30 | 0 | 25 | 0 | 23 | 182 | 190 | * | 47 | 372 | 285 | 9 | 30 | 0 | 25 | 0 | 23 | 182 | 190 | 47 | 372 | ||||||||||||||||||||||||||||||
2778265 | 2778265 | CT | school | 902160 | 720011 | Ledyard School District | 90216000397 | 720211 | Gales Ferry School | Public Schools | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 187 | 9 | 26 | * | 22 | * | 11 | 136 | 122 | * | 39 | 258 | 187 | 9 | 26 | 22 | 11 | 136 | 122 | 39 | 258 | ||||||||||||||||||||||||||||||||
2778432 | 2778432 | CT | school | 902730 | 910011 | New Fairfield School District | 90273001224 | 915211 | New Fairfield Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 446 | 9 | 63 | * | * | 0 | 10 | 277 | 260 | 7 | 59 | 537 | 446 | 9 | 63 | 0 | 10 | 277 | 260 | 7 | 59 | 537 | |||||||||||||||||||||||||||||||
2778469 | 2778469 | CT | school | 930011 | New Haven School District | 937411 | Celentano Self Contained ID | Program | 2020 | pk_12_total | * | 9 | 7 | 0 | 0 | 0 | * | * | * | * | 20 | 20 | 9 | 7 | 0 | 0 | 0 | 20 | 20 | |||||||||||||||||||||||||||||||||||||||||
2778478 | 2778478 | CT | school | 930011 | New Haven School District | 938411 | West Rock Self Contained Autism | Program | 2020 | pk_12_total | * | 9 | * | 0 | 0 | 0 | 0 | * | * | 0 | 12 | 12 | 9 | 0 | 0 | 0 | 0 | 0 | 12 | 12 | ||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2778805 | 2778805 | CT | school | 904380 | 1370011 | Stonington School District | 90438000883 | 1370611 | West Vine Street School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 287 | 9 | 16 | * | * | 0 | 33 | 176 | 178 | * | 63 | 354 | 287 | 9 | 16 | 0 | 33 | 176 | 178 | 63 | 354 | ||||||||||||||||||||||||||||||||
2778855 | 2778855 | CT | school | 904590 | 1430011 | Torrington School District | 90459000917 | 1430211 | Forbes School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 187 | 9 | 111 | 0 | 9 | 0 | 12 | 170 | 158 | 44 | 61 | 328 | 187 | 9 | 111 | 0 | 9 | 0 | 12 | 170 | 158 | 44 | 61 | 328 | |||||||||||||||||||||||||||||
2778971 | 2778971 | CT | school | 904860 | 1520011 | Waterford School District | 90486001593 | 1520211 | Great Neck Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 243 | 9 | 34 | 0 | 16 | 0 | 14 | 154 | 162 | 24 | 38 | 316 | 243 | 9 | 34 | 0 | 16 | 0 | 14 | 154 | 162 | 24 | 38 | 316 | |||||||||||||||||||||||||||||
2779091 | 2779091 | CT | school | 905280 | 1660011 | Wolcott School District | 90528001103 | 1660211 | Frisbie School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 226 | 9 | 26 | 0 | * | 0 | * | 138 | 134 | 17 | 27 | 272 | 226 | 9 | 26 | 0 | 0 | 138 | 134 | 17 | 27 | 272 | |||||||||||||||||||||||||||||||
2779110 | 2779110 | CT | school | 901360 | 2530014 | Eastern Connecticut Regional Educational Service Center (EASTCONN) | 90136001507 | 2536014 | Arts at the Capitol Theater Magnet School (ACT) | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 90 | 9 | 40 | 0 | 0 | 0 | 11 | * | 102 | * | 27 | 150 | 90 | 9 | 40 | 0 | 0 | 0 | 11 | 102 | 27 | 150 | |||||||||||||||||||||||||||||||
2779142 | 2779142 | CT | school | 905372 | 9020022 | The Gilbert School District | 90537201222 | 9026122 | The Gilbert School | Endowed and Incorporated Academies Schools | Regular School | No | High | 07 | 12 | 2020 | pk_12_total | 327 | 9 | 73 | 0 | 36 | 0 | 22 | 253 | * | 13 | 70 | 467 | 327 | 9 | 73 | 0 | 36 | 0 | 22 | 253 | 13 | 70 | 467 | ||||||||||||||||||||||||||||||
2778138 | 2778138 | CT | school | 901770 | 590011 | Groton School District | 90177000318 | 596111 | Robert E. Fitch High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 532 | 89 | 200 | * | 62 | * | 83 | 509 | 472 | 28 | 150 | 981 | 532 | 89 | 200 | 62 | 83 | 509 | 472 | 28 | 150 | 981 | |||||||||||||||||||||||||||||||
2779009 | 2779009 | CT | school | 904950 | 1560011 | West Haven School District | 90495001027 | 1560811 | Alma E. Pagels School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 128 | 89 | 103 | * | 29 | 0 | * | 210 | 157 | 68 | 110 | 367 | 128 | 89 | 103 | 29 | 0 | 210 | 157 | 68 | 110 | 367 | |||||||||||||||||||||||||||||||
2777957 | 2777957 | CT | school | 901020 | 340011 | Danbury School District | 90102000149 | 345111 | Broadview Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 335 | 88 | 484 | * | 45 | 0 | * | 506 | 483 | 154 | 170 | 989 | 335 | 88 | 484 | 45 | 0 | 506 | 483 | 154 | 170 | 989 | |||||||||||||||||||||||||||||||
2777995 | 2777995 | CT | school | 901260 | 430011 | East Hartford School District | 90126000204 | 430411 | Joseph O. Goodwin School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 46 | 88 | 191 | * | * | 0 | 27 | 185 | 194 | 45 | 67 | 379 | 46 | 88 | 191 | 0 | 27 | 185 | 194 | 45 | 67 | 379 | |||||||||||||||||||||||||||||||
2778192 | 2778192 | CT | school | 901920 | 640011 | Hartford School District | 90192000377 | 640111 | SAND School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | * | 88 | 234 | * | * | 0 | * | 180 | 153 | 91 | 58 | 333 | 88 | 234 | 0 | 180 | 153 | 91 | 58 | 333 | |||||||||||||||||||||||||||||||||
2778281 | 2778281 | CT | school | 902310 | 770011 | Manchester School District | 90231000418 | 770311 | Buckley School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 146 | 88 | 91 | * | 45 | 0 | * | 210 | 163 | 22 | 61 | 373 | 146 | 88 | 91 | 45 | 0 | 210 | 163 | 22 | 61 | 373 | |||||||||||||||||||||||||||||||
2778061 | 2778061 | CT | school | 901470 | 490011 | Enfield School District | 90147000243 | 496111 | Enfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1049 | 87 | 237 | * | 63 | * | 64 | 764 | 746 | 17 | 223 | 1510 | 1049 | 87 | 237 | 63 | 64 | 764 | 746 | 17 | 223 | 1510 | |||||||||||||||||||||||||||||||
2778501 | 2778501 | CT | school | 902820 | 950011 | New London School District | 90282000597 | 950811 | Winthrop STEM Elementary Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 136 | 87 | 192 | * | 8 | * | 77 | 275 | 230 | 59 | 72 | 505 | 136 | 87 | 192 | 8 | 77 | 275 | 230 | 59 | 72 | 505 | |||||||||||||||||||||||||||||||
2778783 | 2778783 | CT | school | 904320 | 1350011 | Stamford School District | 90432000860 | 1350611 | Newfield School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 165 | 87 | 263 | 0 | 25 | 0 | 13 | 298 | 255 | 100 | 74 | 553 | 165 | 87 | 263 | 0 | 25 | 0 | 13 | 298 | 255 | 100 | 74 | 553 | |||||||||||||||||||||||||||||
2778465 | 2778465 | CT | school | 902790 | 930011 | New Haven School District | 90279001509 | 932811 | Barack H. Obama Magnet University School | Public Schools | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 11 | 86 | 151 | 0 | 9 | 0 | 10 | 143 | 124 | 101 | 38 | 267 | 11 | 86 | 151 | 0 | 9 | 0 | 10 | 143 | 124 | 101 | 38 | 267 | |||||||||||||||||||||||||||||
2778723 | 2778723 | CT | school | 904050 | 1260011 | Shelton School District | 90405000806 | 1266111 | Shelton High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 946 | 86 | 188 | * | 84 | 0 | * | 696 | * | 22 | 167 | 1357 | 946 | 86 | 188 | 84 | 0 | 696 | 22 | 167 | 1357 | ||||||||||||||||||||||||||||||||
2778917 | 2778917 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000541 | 1513111 | Maloney Interdistrict Magnet School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 200 | 86 | 263 | * | * | 0 | 27 | 267 | 323 | 36 | 52 | 590 | 200 | 86 | 263 | 0 | 27 | 267 | 323 | 36 | 52 | 590 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2777823 | 2777823 | CT | school | 900450 | 150011 | Bridgeport School District | 90045001631 | 151611 | Bridgeport Military Academy | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 30 | 85 | 205 | * | 0 | * | * | 161 | 163 | 49 | 72 | 324 | 30 | 85 | 205 | 0 | 161 | 163 | 49 | 72 | 324 | ||||||||||||||||||||||||||||||||
2777994 | 2777994 | CT | school | 901260 | 430011 | East Hartford School District | 90126000201 | 432011 | Governor William Pitkin School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 52 | 85 | 133 | * | 33 | * | 15 | 158 | 162 | 54 | 56 | 320 | 52 | 85 | 133 | 33 | 15 | 158 | 162 | 54 | 56 | 320 | |||||||||||||||||||||||||||||||
2777997 | 2777997 | CT | school | 901260 | 430011 | East Hartford School District | 90126000208 | 431211 | Silver Lane School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 12 | 85 | 156 | * | * | 0 | 15 | 132 | 138 | 37 | 56 | 270 | 12 | 85 | 156 | 0 | 15 | 132 | 138 | 37 | 56 | 270 | |||||||||||||||||||||||||||||||
2778780 | 2778780 | CT | school | 904320 | 1350011 | Stamford School District | 90432000865 | 1350911 | Roxbury School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 170 | 85 | 286 | 0 | 37 | * | * | 319 | 285 | 99 | 96 | 604 | 170 | 85 | 286 | 0 | 37 | 319 | 285 | 99 | 96 | 604 | |||||||||||||||||||||||||||||||
2778797 | 2778797 | CT | school | 904320 | 1350011 | Stamford School District | 90432000870 | 1355511 | Turn of River School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 203 | 85 | 305 | 0 | 61 | * | * | 374 | 311 | 140 | 98 | 685 | 203 | 85 | 305 | 0 | 61 | 374 | 311 | 140 | 98 | 685 | |||||||||||||||||||||||||||||||
2778920 | 2778920 | CT | school | 904830 | 1510011 | Waterbury School District | 90483001131 | 1513311 | Rotella Interdistrict Magnet School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 210 | 85 | 261 | * | * | 0 | 43 | 306 | 308 | 34 | 46 | 614 | 210 | 85 | 261 | 0 | 43 | 306 | 308 | 34 | 46 | 614 | |||||||||||||||||||||||||||||||
2779001 | 2779001 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001021 | 1555211 | Sedgwick Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 496 | 85 | 207 | * | 95 | * | 33 | 445 | 475 | 49 | 114 | 920 | 496 | 85 | 207 | 95 | 33 | 445 | 475 | 49 | 114 | 920 | |||||||||||||||||||||||||||||||
2779100 | 2779100 | CT | school | 900212 | 2880013 | Achievement First Hartford Academy District | 90021201528 | 2880113 | Achievement First Hartford Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | * | 842 | 299 | 6 | * | * | 15 | 553 | 616 | 70 | 117 | 1169 | 842 | 299 | 6 | 15 | 553 | 616 | 70 | 117 | 1169 | ||||||||||||||||||||||||||||||||
2778123 | 2778123 | CT | school | 901710 | 570011 | Greenwich School District | 90171000300 | 576111 | Greenwich High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1745 | 84 | 626 | * | 194 | * | 92 | 1375 | * | 80 | 339 | 2749 | 1745 | 84 | 626 | 194 | 92 | 1375 | 80 | 339 | 2749 | ||||||||||||||||||||||||||||||||
2778320 | 2778320 | CT | school | 902400 | 800011 | Meriden School District | 90240001194 | 805411 | Washington Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 266 | 84 | 395 | * | 14 | * | 24 | 403 | 384 | 66 | 139 | 787 | 266 | 84 | 395 | 14 | 24 | 403 | 384 | 66 | 139 | 787 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2779155 | 2779155 | CT | school | 900014 | 2680013 | Common Ground High School District | 90001400807 | 2686113 | Common Ground High School | Public Charter Schools | Regular School | Yes | High | 09 | 12 | 2020 | pk_12_total | * | 84 | 90 | 0 | 0 | 0 | * | 131 | * | 11 | 55 | 223 | 84 | 90 | 0 | 0 | 0 | 131 | 11 | 55 | 223 | ||||||||||||||||||||||||||||||||
2778417 | 2778417 | CT | school | 902670 | 890011 | New Britain School District | 90267000518 | 895311 | Pulaski Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 158 | 83 | 613 | * | 23 | 0 | * | 500 | 401 | 184 | 194 | 901 | 158 | 83 | 613 | 23 | 0 | 500 | 401 | 184 | 194 | 901 | |||||||||||||||||||||||||||||||
2778816 | 2778816 | CT | school | 904440 | 1380011 | Stratford School District | 90444000898 | 1381311 | Eli Whitney School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 231 | 82 | 154 | 0 | 14 | 0 | 17 | 269 | 229 | 16 | 51 | 498 | 231 | 82 | 154 | 0 | 14 | 0 | 17 | 269 | 229 | 16 | 51 | 498 | |||||||||||||||||||||||||||||
2777813 | 2777813 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000060 | 150711 | Edison School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 20 | 81 | 71 | * | 7 | * | * | 100 | 86 | 11 | 40 | 186 | 20 | 81 | 71 | 7 | 100 | 86 | 11 | 40 | 186 | ||||||||||||||||||||||||||||||||
2777859 | 2777859 | CT | school | 900510 | 170011 | Bristol School District | 90051000092 | 176111 | Bristol Central High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 669 | 81 | 352 | * | * | 0 | 48 | 606 | * | 42 | 225 | 1187 | 669 | 81 | 352 | 0 | 48 | 606 | 42 | 225 | 1187 | ||||||||||||||||||||||||||||||||
2778781 | 2778781 | CT | school | 904320 | 1350011 | Stamford School District | 90432000167 | 1352211 | Hart School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 117 | 81 | 266 | 0 | 95 | 0 | 42 | 309 | 292 | 76 | 65 | 601 | 117 | 81 | 266 | 0 | 95 | 0 | 42 | 309 | 292 | 76 | 65 | 601 | |||||||||||||||||||||||||||||
2779000 | 2779000 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001017 | 1555111 | King Philip Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 517 | 81 | 152 | 0 | 93 | * | * | 459 | 436 | 41 | 121 | 895 | 517 | 81 | 152 | 0 | 93 | 459 | 436 | 41 | 121 | 895 | |||||||||||||||||||||||||||||||
2777893 | 2777893 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001625 | 2415314 | Greater Hartford Academy of the Arts Magnet Middle | Regional Education Service Center Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 63 | 80 | 172 | 0 | * | * | 17 | 81 | 253 | 21 | 78 | 334 | 63 | 80 | 172 | 0 | 17 | 81 | 253 | 21 | 78 | 334 | |||||||||||||||||||||||||||||||
2778518 | 2778518 | CT | school | 902880 | 940011 | Newington School District | 90288000610 | 946111 | Newington High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 786 | 80 | 255 | * | 114 | * | 64 | 694 | 607 | 19 | 150 | 1301 | 786 | 80 | 255 | 114 | 64 | 694 | 607 | 19 | 150 | 1301 | |||||||||||||||||||||||||||||||
2779166 | 2779166 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201672 | 9002116 | J. M. Wright Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2020 | pk_12_total | 68 | 80 | 269 | 0 | * | 0 | * | 246 | 181 | 29 | 59 | 427 | 68 | 80 | 269 | 0 | 0 | 246 | 181 | 29 | 59 | 427 | |||||||||||||||||||||||||||||||
2777967 | 2777967 | CT | school | 901050 | 350011 | Darien School District | 90105000172 | 350611 | Tokeneke Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 386 | 8 | 15 | 0 | 17 | 0 | 20 | 231 | 215 | 17 | 74 | 446 | 386 | 8 | 15 | 0 | 17 | 0 | 20 | 231 | 215 | 17 | 74 | 446 | |||||||||||||||||||||||||||||
2778027 | 2778027 | CT | school | 2420014 | EdAdvance | 90351200575 | 2428014 | EdAdvance Headstart | Program | 2020 | pk_12_total | 100 | 8 | 61 | * | 8 | * | 7 | 88 | 104 | 0 | * | 192 | 100 | 8 | 61 | 8 | 7 | 88 | 104 | 0 | 192 | ||||||||||||||||||||||||||||||||||||||
2778084 | 2778084 | CT | school | 520011 | Farmington School District | 90156001441 | 528011 | Farmington Collaborative PK | Program | 2020 | pk_12_total | 69 | 8 | 15 | 0 | 16 | 0 | 7 | 60 | 55 | 0 | 35 | 115 | 69 | 8 | 15 | 0 | 16 | 0 | 7 | 60 | 55 | 0 | 35 | 115 | |||||||||||||||||||||||||||||||||||
2778160 | 2778160 | CT | school | 620011 | Hamden School District | 621611 | Helen Street IIC | Program | 2020 | pk_12_total | 0 | 8 | 6 | 0 | * | 0 | * | * | * | * | 16 | 16 | 0 | 8 | 6 | 0 | 0 | 16 | 16 | |||||||||||||||||||||||||||||||||||||||||
2778177 | 2778177 | CT | school | 640011 | Hartford School District | 90192001723 | 644111 | Early Childhood Development Center (ECDC) | Program | 2020 | pk_12_total | * | 8 | 8 | 0 | * | 0 | * | * | * | 0 | 19 | 19 | 8 | 8 | 0 | 0 | 0 | 19 | 19 | ||||||||||||||||||||||||||||||||||||||||
2778188 | 2778188 | CT | school | 640011 | Hartford School District | 640510 | Pre-K Integrated - Naylor School | Program | 2020 | pk_12_total | * | 8 | 29 | 0 | * | 0 | 0 | 23 | 18 | 0 | 22 | 41 | 8 | 29 | 0 | 0 | 0 | 23 | 18 | 0 | 22 | 41 | ||||||||||||||||||||||||||||||||||||||
2778298 | 2778298 | CT | school | 902340 | 780011 | Mansfield School District | 90234000432 | 780411 | Annie E. Vinton School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 135 | 8 | 42 | 0 | 30 | 0 | 11 | 110 | 116 | 22 | 36 | 226 | 135 | 8 | 42 | 0 | 30 | 0 | 11 | 110 | 116 | 22 | 36 | 226 | |||||||||||||||||||||||||||||
2778360 | 2778360 | CT | school | 902520 | 840011 | Milford School District | 90252000467 | 840111 | Calf Pen Meadow School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 217 | 8 | 26 | 0 | 8 | 0 | 14 | 142 | 131 | * | 37 | 273 | 217 | 8 | 26 | 0 | 8 | 0 | 14 | 142 | 131 | 37 | 273 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778657 | 2778657 | CT | school | 903537 | 2150012 | Regional School District 15 | 90353700750 | 2150512 | Pomperaug School | Regional Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 305 | 8 | 33 | 0 | 14 | 0 | 11 | 218 | 153 | * | 63 | 371 | 305 | 8 | 33 | 0 | 14 | 0 | 11 | 218 | 153 | 63 | 371 | ||||||||||||||||||||||||||||||
2778663 | 2778663 | CT | school | 903538 | 2160012 | Regional School District 16 | 90353800755 | 2160112 | Laurel Ledge School | Regional Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 220 | 8 | 35 | 0 | 6 | 0 | 10 | 139 | 140 | 10 | 33 | 279 | 220 | 8 | 35 | 0 | 6 | 0 | 10 | 139 | 140 | 10 | 33 | 279 | |||||||||||||||||||||||||||||
2778736 | 2778736 | CT | school | 904140 | 1290011 | Somers School District | 90414000818 | 1295111 | Mabelle B. Avery Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 271 | 8 | 13 | * | 7 | 0 | * | 143 | 161 | * | 45 | 304 | 271 | 8 | 13 | 7 | 0 | 143 | 161 | 45 | 304 | ||||||||||||||||||||||||||||||||
2778757 | 2778757 | CT | school | 904230 | 1310011 | Southington School District | 90423000839 | 1310811 | Strong Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 204 | 8 | 24 | 0 | 9 | 0 | 21 | 130 | 136 | 15 | 29 | 266 | 204 | 8 | 24 | 0 | 9 | 0 | 21 | 130 | 136 | 15 | 29 | 266 | |||||||||||||||||||||||||||||
2778928 | 2778928 | CT | school | 1510011 | Waterbury School District | 1514611 | Bucks Hill Autism | Program | 2020 | pk_12_total | 6 | 8 | 14 | 0 | * | 0 | * | 21 | 10 | * | 31 | 31 | 6 | 8 | 14 | 0 | 0 | 21 | 10 | 31 | 31 | |||||||||||||||||||||||||||||||||||||||
2778979 | 2778979 | CT | school | 904890 | 1530011 | Watertown School District | 90489001005 | 1530411 | Polk School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 239 | 8 | 44 | * | * | 0 | 10 | 184 | 119 | 24 | 49 | 303 | 239 | 8 | 44 | 0 | 10 | 184 | 119 | 24 | 49 | 303 | |||||||||||||||||||||||||||||||
2779045 | 2779045 | CT | school | 905070 | 1590011 | Wethersfield School District | 90507001060 | 1591011 | Charles Wright School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 170 | 8 | 79 | 0 | 13 | 0 | 17 | 143 | 144 | 69 | 38 | 287 | 170 | 8 | 79 | 0 | 13 | 0 | 17 | 143 | 144 | 69 | 38 | 287 | |||||||||||||||||||||||||||||
2779059 | 2779059 | CT | school | 905160 | 1620011 | Winchester School District | 90516001080 | 1625111 | Pearson School | Public Schools | Regular School | No | Elementary | 03 | 06 | 2020 | pk_12_total | 236 | 8 | 39 | 0 | 7 | 0 | 14 | 163 | 141 | 10 | 64 | 304 | 236 | 8 | 39 | 0 | 7 | 0 | 14 | 163 | 141 | 10 | 64 | 304 | |||||||||||||||||||||||||||||
2779172 | 2779172 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201152 | 9002416 | Windham Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2020 | pk_12_total | 264 | 8 | 183 | * | * | 0 | * | 298 | 164 | 22 | 59 | 462 | 264 | 8 | 183 | 0 | 298 | 164 | 22 | 59 | 462 | ||||||||||||||||||||||||||||||||
2778500 | 2778500 | CT | school | 902820 | 950011 | New London School District | 90282000594 | 950911 | Nathan Hale Arts Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 122 | 79 | 235 | * | 6 | * | 92 | 226 | 310 | 61 | 82 | 536 | 122 | 79 | 235 | 6 | 92 | 226 | 310 | 61 | 82 | 536 | |||||||||||||||||||||||||||||||
2778811 | 2778811 | CT | school | 904440 | 1380011 | Stratford School District | 90444000895 | 1381011 | Second Hill Lane School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | pk_12_total | 159 | 79 | 192 | 0 | 18 | 0 | 31 | 248 | 231 | 46 | 102 | 479 | 159 | 79 | 192 | 0 | 18 | 0 | 31 | 248 | 231 | 46 | 102 | 479 | |||||||||||||||||||||||||||||
2778881 | 2778881 | CT | school | 904680 | 1460011 | Vernon School District | 90468000947 | 1465111 | Vernon Center Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 413 | 79 | 141 | * | * | 0 | 47 | 372 | 350 | 19 | 134 | 722 | 413 | 79 | 141 | 0 | 47 | 372 | 350 | 19 | 134 | 722 | |||||||||||||||||||||||||||||||
2778285 | 2778285 | CT | school | 902310 | 770011 | Manchester School District | 90231000417 | 770111 | Bowers School | Public Schools | Regular School | No | Elementary | KG | 04 | 2020 | pk_12_total | 138 | 78 | 101 | 0 | 14 | * | * | 182 | 155 | 22 | 58 | 337 | 138 | 78 | 101 | 0 | 14 | 182 | 155 | 22 | 58 | 337 | |||||||||||||||||||||||||||||||
2778462 | 2778462 | CT | school | 902790 | 930011 | New Haven School District | 90279000647 | 934911 | West Rock Authors Academy | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 40 | 78 | 42 | 0 | * | 0 | * | 89 | 84 | 20 | 17 | 173 | 40 | 78 | 42 | 0 | 0 | 89 | 84 | 20 | 17 | 173 | |||||||||||||||||||||||||||||||
2778782 | 2778782 | CT | school | 904320 | 1350011 | Stamford School District | 90432000858 | 1351211 | Julia A. Stark School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 150 | 78 | 301 | 0 | 21 | 0 | 21 | 293 | 278 | 74 | 58 | 571 | 150 | 78 | 301 | 0 | 21 | 0 | 21 | 293 | 278 | 74 | 58 | 571 | |||||||||||||||||||||||||||||
2778156 | 2778156 | CT | school | 901860 | 620011 | Hamden School District | 90186000345 | 621111 | Ridge Hill School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | pk_12_total | 95 | 77 | 86 | 0 | 27 | 0 | 18 | 138 | 165 | 34 | 29 | 303 | 95 | 77 | 86 | 0 | 27 | 0 | 18 | 138 | 165 | 34 | 29 | 303 |
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]);