enrollments
Data source: Big Local News · About: Big Local
20,286 rows where state = "CT" and year = 2019 sorted by male 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2452908 | 2452908 | CT | school | 1510011 | Waterbury School District | 1514211 | Hopeville Bilingual | Program | 2019 | pk_12_total | 0 | 0 | 127 | 0 | 0 | 0 | 0 | 67 | 60 | 127 | 17 | 127 | 0 | 0 | 127 | 0 | 0 | 0 | 0 | 67 | 60 | 127 | 17 | 127 | ||||||||||||||||||||||||||||||||||||
2452036 | 2452036 | CT | school | 510011 | Fairfield School District | 90153000989 | 518011 | Early Childhood Center(0518011) | Program | 2019 | pk_12_total | 80 | * | 15 | 0 | * | 0 | * | 66 | 42 | 0 | 83 | 108 | 80 | 15 | 0 | 0 | 66 | 42 | 0 | 83 | 108 | ||||||||||||||||||||||||||||||||||||||
2452215 | 2452215 | CT | school | 690011 | Killingly School District | 90207000083 | 698011 | Goodyear Early Childhood Center | Program | 2019 | pk_12_total | 94 | * | 7 | 0 | * | 0 | 12 | 66 | 52 | 0 | 34 | 118 | 94 | 7 | 0 | 0 | 12 | 66 | 52 | 0 | 34 | 118 | |||||||||||||||||||||||||||||||||||||
2452597 | 2452597 | CT | school | 903420 | 1140011 | Preston School District | 90342000717 | 1145111 | Preston Plains School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 113 | * | 11 | * | * | 0 | 8 | 66 | 79 | * | 24 | 145 | 113 | 11 | 0 | 8 | 66 | 79 | 24 | 145 | |||||||||||||||||||||||||||||||||
2452228 | 2452228 | CT | school | 903450 | 2450014 | Learn | 90345001556 | 2455014 | Dual Language & Arts Magnet Middle School | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 42 | 16 | 65 | 0 | * | * | 21 | 65 | 81 | 17 | 28 | 146 | 42 | 16 | 65 | 0 | 21 | 65 | 81 | 17 | 28 | 146 | ||||||||||||||||||||||||||||||||
2452406 | 2452406 | CT | school | 902700 | 900011 | New Canaan School District | 90270000531 | 906111 | New Canaan High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1096 | 23 | 53 | * | 77 | * | 32 | 647 | 637 | * | 167 | 1284 | 1096 | 23 | 53 | 77 | 32 | 647 | 637 | 167 | 1284 | ||||||||||||||||||||||||||||||||
2452329 | 2452329 | CT | school | 902490 | 830011 | Middletown School District | 90249000465 | 836211 | Middletown High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 681 | 283 | 221 | * | * | 0 | 64 | 640 | 672 | 27 | 150 | 1312 | 681 | 283 | 221 | 0 | 64 | 640 | 672 | 27 | 150 | 1312 | |||||||||||||||||||||||||||||||
2451785 | 2451785 | CT | school | 150011 | Bridgeport School District | 90045001472 | 159011 | Bridgeport Learning Center | Program | 2019 | pk_12_total | * | 37 | 32 | 0 | * | 0 | 0 | 64 | 9 | * | * | 73 | 37 | 32 | 0 | 0 | 0 | 64 | 9 | 73 | |||||||||||||||||||||||||||||||||||||||
2452182 | 2452182 | CT | school | 901920 | 640011 | Hartford School District | 90192001582 | 644011 | Renzulli Gifted and Talented Academy | Public Schools | Regular School | No | Middle | 04 | 08 | 2019 | pk_12_total | 9 | 53 | 49 | * | * | 0 | 6 | 64 | 59 | * | * | 123 | 9 | 53 | 49 | 0 | 6 | 64 | 59 | 123 | |||||||||||||||||||||||||||||||||
2452935 | 2452935 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000971 | 1516211 | Crosby High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 172 | 306 | 645 | * | 13 | * | 18 | 637 | 525 | 188 | 311 | 1162 | 172 | 306 | 645 | 13 | 18 | 637 | 525 | 188 | 311 | 1162 | |||||||||||||||||||||||||||||||
2452936 | 2452936 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000979 | 1516411 | John F. Kennedy High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 246 | 250 | 692 | 11 | 21 | 0 | 24 | 635 | 609 | 223 | 259 | 1244 | 246 | 250 | 692 | 11 | 21 | 0 | 24 | 635 | 609 | 223 | 259 | 1244 | |||||||||||||||||||||||||||||
2452638 | 2452638 | CT | school | 903537 | 2150012 | Regional School District 15 | 90353700749 | 2156212 | Pomperaug Regional High School | Regional Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1018 | 17 | 75 | * | 69 | * | 19 | 632 | 575 | 6 | 196 | 1207 | 1018 | 17 | 75 | 69 | 19 | 632 | 575 | 6 | 196 | 1207 | |||||||||||||||||||||||||||||||
2453029 | 2453029 | CT | school | 905130 | 1610011 | Wilton School District | 90513001076 | 1616111 | Wilton High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 1004 | * | 73 | * | 106 | 0 | 58 | 630 | 633 | * | 174 | 1263 | 1004 | 73 | 106 | 0 | 58 | 630 | 633 | 174 | 1263 | ||||||||||||||||||||||||||||||||
2451971 | 2451971 | CT | school | 901260 | 430011 | East Hartford School District | 90126001377 | 436411 | Synergy Alternative Program | Program | Alternative School | No | High | 10 | 12 | 2019 | pk_12_total | * | 28 | 50 | 0 | 0 | 0 | * | 63 | 31 | 6 | 21 | 94 | 28 | 50 | 0 | 0 | 0 | 63 | 31 | 6 | 21 | 94 | |||||||||||||||||||||||||||||||
2452616 | 2452616 | CT | school | 903530 | 2120012 | Regional School District 12 | 90353000735 | 2120412 | Washington Primary School | Regional Schools | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 123 | * | 13 | 0 | * | 0 | * | 63 | 77 | * | 12 | 140 | 123 | 13 | 0 | 0 | 63 | 77 | 12 | 140 | |||||||||||||||||||||||||||||||||
2452061 | 2452061 | CT | school | 901560 | 520011 | Farmington School District | 90156000273 | 526111 | Farmington High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 849 | 62 | 73 | * | 243 | 0 | * | 629 | 617 | 14 | 156 | 1246 | 849 | 62 | 73 | 243 | 0 | 629 | 617 | 14 | 156 | 1246 | |||||||||||||||||||||||||||||||
2451800 | 2451800 | CT | school | 900510 | 170011 | Bristol School District | 90051001774 | 170411 | Bristol Early Childhood Center-BECC | Public Schools | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 66 | * | 29 | 0 | * | 0 | 8 | 62 | 45 | 0 | 65 | 107 | 66 | 29 | 0 | 0 | 8 | 62 | 45 | 0 | 65 | 107 | |||||||||||||||||||||||||||||||
2451994 | 2451994 | CT | school | 901360 | 2530014 | Eastern Connecticut Regional Educational Service Center (EASTCONN) | 90136001530 | 2536114 | Quinebaug Middle College | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 128 | 6 | 37 | * | * | 0 | * | 61 | 117 | 0 | 26 | 178 | 128 | 6 | 37 | 0 | 61 | 117 | 0 | 26 | 178 | ||||||||||||||||||||||||||||||||
2452054 | 2452054 | CT | school | 520011 | Farmington School District | 90156001441 | 528011 | Farmington Collaborative PK | Program | 2019 | pk_12_total | 69 | 6 | 13 | 0 | 14 | 0 | 7 | 61 | 48 | 0 | 30 | 109 | 69 | 6 | 13 | 0 | 14 | 0 | 7 | 61 | 48 | 0 | 30 | 109 | |||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||
2453082 | 2453082 | CT | school | 904020 | 1250011 | Sharon School District | 90402000795 | 1250111 | Sharon Center School | Public Schools | Regular School | No | Elementary | KG | 08 | 2019 | pk_12_total | 98 | 0 | 10 | 0 | * | * | * | 61 | 54 | * | 25 | 115 | 98 | 0 | 10 | 0 | 61 | 54 | 25 | 115 | |||||||||||||||||||||||||||||||||
2451765 | 2451765 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000053 | 154011 | Blackham School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 221 | 293 | 487 | * | 41 | * | 13 | 606 | 461 | 237 | 151 | 1067 | 221 | 293 | 487 | 41 | 13 | 606 | 461 | 237 | 151 | 1067 | |||||||||||||||||||||||||||||||
2451814 | 2451814 | CT | school | 170011 | Bristol School District | 90051001688 | 172611 | Ivy Drive GOAL | Program | 2019 | pk_12_total | * | * | * | 0 | 0 | 0 | 0 | 6 | 0 | * | 6 | 6 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 6 | |||||||||||||||||||||||||||||||||||||||
2451893 | 2451893 | CT | school | 280011 | Colchester School District | 280511 | Bacon Academy Alternative Education | Program | 2019 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | 6 | * | 0 | * | 10 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 10 | ||||||||||||||||||||||||||||||||||||||||
2452032 | 2452032 | CT | school | 490011 | Enfield School District | 90147001523 | 499011 | Enfield Transitional Learning Academy | Program | 2019 | pk_12_total | * | * | 0 | 0 | 0 | 0 | 0 | 6 | 6 | 0 | 12 | 12 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | 0 | 12 | 12 | |||||||||||||||||||||||||||||||||||||
2452455 | 2452455 | CT | school | 930011 | New Haven School District | 937811 | Clinton Self Contained ID | Program | 2019 | pk_12_total | 0 | * | * | 0 | 0 | 0 | 0 | 6 | 8 | 7 | 14 | 14 | 0 | 0 | 0 | 0 | 0 | 6 | 8 | 7 | 14 | 14 | ||||||||||||||||||||||||||||||||||||||
2452546 | 2452546 | CT | school | 1040011 | Norwich School District | 1040511 | Special Needs Program @ Mahan | Program | 2019 | pk_12_total | * | * | 6 | 0 | * | 0 | * | 6 | 6 | * | 12 | 12 | 6 | 0 | 0 | 6 | 6 | 12 | 12 | |||||||||||||||||||||||||||||||||||||||||
2452551 | 2452551 | CT | school | 1040011 | Norwich School District | 1040911 | Stanton Special Learning Center | Program | 2019 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 6 | 6 | ||||||||||||||||||||||||||||||||||||||
2452666 | 2452666 | CT | school | 1180011 | Ridgefield School District | 1181111 | District Program SRMS | Program | 2019 | pk_12_total | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 6 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 6 | 6 | ||||||||||||||||||||||||||||||||||||
2452694 | 2452694 | CT | school | 1260011 | Shelton School District | 1260211 | Alternative Learning Center 1 | Program | 2019 | pk_12_total | * | * | * | 0 | 0 | 0 | 0 | 6 | 0 | * | 6 | 6 | 0 | 0 | 0 | 0 | 6 | 0 | 6 | 6 | ||||||||||||||||||||||||||||||||||||||||
2452799 | 2452799 | CT | school | 1380011 | Stratford School District | 1382711 | ALL Class Room - Second Hill Lane | Program | 2019 | pk_12_total | * | * | * | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 6 | 6 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 6 | 6 | |||||||||||||||||||||||||||||||||||||||
2452876 | 2452876 | CT | school | 1480011 | Wallingford School District | 1481311 | Inspire Middle School | Program | 2019 | pk_12_total | 9 | 0 | * | 0 | * | 0 | 0 | 6 | 7 | * | 13 | 13 | 9 | 0 | 0 | 0 | 0 | 6 | 7 | 13 | 13 | |||||||||||||||||||||||||||||||||||||||
2451797 | 2451797 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000067 | 156311 | Warren Harding High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 67 | 403 | 597 | * | * | * | 7 | 598 | 484 | 319 | 229 | 1082 | 67 | 403 | 597 | 7 | 598 | 484 | 319 | 229 | 1082 | ||||||||||||||||||||||||||||||||
2452029 | 2452029 | CT | school | 901470 | 490011 | Enfield School District | 90147000249 | 495211 | John F. Kennedy Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 791 | 68 | 194 | * | 40 | * | 50 | 598 | 551 | 18 | 167 | 1149 | 791 | 68 | 194 | 40 | 50 | 598 | 551 | 18 | 167 | 1149 | |||||||||||||||||||||||||||||||
2451828 | 2451828 | CT | school | 900510 | 170011 | Bristol School District | 90051000092 | 176111 | Bristol Central High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 679 | 77 | 315 | * | * | 0 | 42 | 596 | 557 | 30 | 219 | 1153 | 679 | 77 | 315 | 0 | 42 | 596 | 557 | 30 | 219 | 1153 | |||||||||||||||||||||||||||||||
2451767 | 2451767 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000070 | 151411 | Cesar Batalla School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 90 | 210 | 730 | 8 | 25 | * | * | 585 | 487 | 478 | 155 | 1072 | 90 | 210 | 730 | 8 | 25 | 585 | 487 | 478 | 155 | 1072 | |||||||||||||||||||||||||||||||
2451699 | 2451699 | CT | school | 20011 | Ansonia School District | 20911 | Ansonia Public Schools Pre-K Program | Program | 2019 | pk_12_total | 27 | 16 | 43 | 0 | * | 0 | * | 58 | 36 | 0 | 18 | 94 | 27 | 16 | 43 | 0 | 0 | 58 | 36 | 0 | 18 | 94 | ||||||||||||||||||||||||||||||||||||||
2452301 | 2452301 | CT | school | 902400 | 800011 | Meriden School District | 90240000441 | 806111 | Francis T. Maloney High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 355 | 119 | 575 | 0 | 43 | 0 | 42 | 579 | 555 | 166 | 177 | 1134 | 355 | 119 | 575 | 0 | 43 | 0 | 42 | 579 | 555 | 166 | 177 | 1134 | |||||||||||||||||||||||||||||
2453058 | 2453058 | CT | school | 905220 | 1640011 | Windsor School District | 90522001096 | 1646111 | Windsor High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 273 | 552 | 190 | 0 | * | * | 54 | 570 | 540 | 22 | 209 | 1110 | 273 | 552 | 190 | 0 | 54 | 570 | 540 | 22 | 209 | 1110 | |||||||||||||||||||||||||||||||
2452015 | 2452015 | CT | school | 490011 | Enfield School District | 90147000207 | 498011 | Head Start Program | Program | 2019 | pk_12_total | 59 | 6 | 34 | 0 | * | 0 | * | 56 | 48 | 0 | 14 | 104 | 59 | 6 | 34 | 0 | 0 | 56 | 48 | 0 | 14 | 104 | |||||||||||||||||||||||||||||||||||||
2452257 | 2452257 | CT | school | 902280 | 760011 | Madison School District | 90228000411 | 766111 | Daniel Hand High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 937 | * | 49 | * | 45 | 0 | 33 | 557 | * | 0 | 114 | 1072 | 937 | 49 | 45 | 0 | 33 | 557 | 0 | 114 | 1072 | ||||||||||||||||||||||||||||||||
2451937 | 2451937 | CT | school | 901050 | 350011 | Darien School District | 90105000169 | 355111 | Middlesex Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 947 | * | 61 | * | 57 | 0 | 27 | 552 | 549 | * | 152 | 1101 | 947 | 61 | 57 | 0 | 27 | 552 | 549 | 152 | 1101 | ||||||||||||||||||||||||||||||||
2452940 | 2452940 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000992 | 1516311 | Wilby High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 100 | 284 | 590 | * | * | 0 | 19 | 545 | 457 | 177 | 239 | 1002 | 100 | 284 | 590 | 0 | 19 | 545 | 457 | 177 | 239 | 1002 | |||||||||||||||||||||||||||||||
2453145 | 2453145 | CT | school | 905373 | 9030022 | The Woodstock Academy District | 90537311223 | 9036122 | The Woodstock Academy | Endowed and Incorporated Academies Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 925 | * | 26 | * | 124 | 0 | 11 | 545 | 553 | 0 | 74 | 1098 | 925 | 26 | 124 | 0 | 11 | 545 | 553 | 0 | 74 | 1098 | |||||||||||||||||||||||||||||||
2452921 | 2452921 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000983 | 1515111 | Michael F. Wallace Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 143 | 248 | 599 | 10 | 22 | 0 | 30 | 543 | 509 | 122 | 199 | 1052 | 143 | 248 | 599 | 10 | 22 | 0 | 30 | 543 | 509 | 122 | 199 | 1052 | |||||||||||||||||||||||||||||
2451862 | 2451862 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001513 | 2415114 | Academy of Aerospace and Engineering | Regional Education Service Center Schools | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 166 | 229 | 286 | * | 75 | * | 27 | 542 | 244 | 33 | 108 | 786 | 166 | 229 | 286 | 75 | 27 | 542 | 244 | 33 | 108 | 786 | |||||||||||||||||||||||||||||||
2452110 | 2452110 | CT | school | 901770 | 590011 | Groton School District | 90177000318 | 596111 | Robert E. Fitch High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 574 | 98 | 185 | 17 | 72 | 6 | 84 | 542 | 494 | 20 | 148 | 1036 | 574 | 98 | 185 | 17 | 72 | 6 | 84 | 542 | 494 | 20 | 148 | 1036 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
2451712 | 2451712 | CT | school | 2440014 | Area Cooperative Educational Services | 90007001502 | 2449214 | Whitney Academy | Program | 2019 | pk_12_total | 27 | 19 | 22 | 0 | * | 0 | * | 54 | 17 | 0 | 71 | 71 | 27 | 19 | 22 | 0 | 0 | 54 | 17 | 0 | 71 | 71 | |||||||||||||||||||||||||||||||||||||
2452507 | 2452507 | CT | school | 902940 | 980011 | Norfolk School District | 90294000618 | 980111 | Botelle Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 82 | 0 | * | 0 | 0 | 0 | * | 54 | 41 | * | 18 | 95 | 82 | 0 | 0 | 0 | 0 | 54 | 41 | 18 | 95 | ||||||||||||||||||||||||||||||||
2453077 | 2453077 | CT | school | 900870 | 290011 | Colebrook School District | 90087000138 | 290111 | Colebrook Consolidated School | Public Schools | Regular School | No | Elementary | KG | 06 | 2019 | pk_12_total | 79 | * | * | 0 | 0 | 0 | * | 54 | 30 | 0 | 18 | 84 | 79 | 0 | 0 | 0 | 54 | 30 | 0 | 18 | 84 | ||||||||||||||||||||||||||||||||
2451829 | 2451829 | CT | school | 900510 | 170011 | Bristol School District | 90051000093 | 176211 | Bristol Eastern High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 701 | 74 | 227 | * | 28 | * | 31 | 539 | 526 | 22 | 220 | 1065 | 701 | 74 | 227 | 28 | 31 | 539 | 526 | 22 | 220 | 1065 | |||||||||||||||||||||||||||||||
2451967 | 2451967 | CT | school | 901260 | 430011 | East Hartford School District | 90126000197 | 435111 | East Hartford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 107 | 321 | 519 | * | 42 | * | 60 | 537 | 514 | 120 | 203 | 1051 | 107 | 321 | 519 | 42 | 60 | 537 | 514 | 120 | 203 | 1051 | |||||||||||||||||||||||||||||||
2452488 | 2452488 | CT | school | 902850 | 960011 | New Milford School District | 90285000603 | 965211 | Schaghticoke Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 729 | * | 153 | * | 40 | 0 | 44 | 537 | * | 29 | 150 | 991 | 729 | 153 | 40 | 0 | 44 | 537 | 29 | 150 | 991 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2451792 | 2451792 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000050 | 156111 | Bassick High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 55 | 332 | 477 | * | 14 | 0 | * | 530 | 354 | 194 | 233 | 884 | 55 | 332 | 477 | 14 | 0 | 530 | 354 | 194 | 233 | 884 | |||||||||||||||||||||||||||||||
2452413 | 2452413 | CT | school | 902760 | 920011 | New Hartford School District | 90276000540 | 920211 | New Hartford Elementary School | Public Schools | Regular School | No | Elementary | PK | 02 | 2019 | pk_12_total | 85 | * | * | 0 | * | 0 | * | 53 | 43 | * | 10 | 96 | 85 | 0 | 0 | 53 | 43 | 10 | 96 | ||||||||||||||||||||||||||||||||||
2453078 | 2453078 | CT | school | 900930 | 310011 | Cornwall School District | 90093000140 | 310111 | Cornwall Consolidated School | Public Schools | Regular School | No | Elementary | KG | 08 | 2019 | pk_12_total | 71 | 0 | 13 | 0 | * | 0 | * | 53 | 38 | * | 11 | 91 | 71 | 0 | 13 | 0 | 0 | 53 | 38 | 11 | 91 | ||||||||||||||||||||||||||||||||
2452519 | 2452519 | CT | school | 903030 | 1010011 | North Haven School District | 90303000631 | 1016111 | North Haven High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 827 | 38 | 73 | * | 64 | * | 29 | 528 | 506 | 11 | 117 | 1034 | 827 | 38 | 73 | 64 | 29 | 528 | 506 | 11 | 117 | 1034 | |||||||||||||||||||||||||||||||
2452723 | 2452723 | CT | school | 904230 | 1310011 | Southington School District | 90423001808 | 1312011 | Southington Public Schools Preschool Program at Hatton School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 56 | * | 7 | 0 | * | 0 | * | 52 | 18 | 0 | 46 | 70 | 56 | 7 | 0 | 0 | 52 | 18 | 0 | 46 | 70 | ||||||||||||||||||||||||||||||||
2453071 | 2453071 | CT | school | 900212 | 2880013 | Achievement First Hartford Academy District | 90021201528 | 2880113 | Achievement First Hartford Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | * | 782 | 304 | * | * | * | 15 | 519 | 593 | 52 | 115 | 1112 | 782 | 304 | 15 | 519 | 593 | 52 | 115 | 1112 | |||||||||||||||||||||||||||||||||
2452805 | 2452805 | CT | school | 904440 | 1380011 | Stratford School District | 90444000885 | 1386211 | Bunnell High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 444 | 256 | 296 | 0 | 29 | 0 | 21 | 516 | 530 | 13 | 121 | 1046 | 444 | 256 | 296 | 0 | 29 | 0 | 21 | 516 | 530 | 13 | 121 | 1046 | |||||||||||||||||||||||||||||
2452833 | 2452833 | CT | school | 904590 | 1430011 | Torrington School District | 90459000925 | 1435111 | Torrington Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 601 | 42 | 259 | * | 42 | * | 37 | 516 | 469 | 64 | 185 | 985 | 601 | 42 | 259 | 42 | 37 | 516 | 469 | 64 | 185 | 985 | |||||||||||||||||||||||||||||||
2453131 | 2453131 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201149 | 9002616 | Platt Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 322 | 111 | 325 | * | * | 0 | 35 | 514 | 294 | 19 | 95 | 808 | 322 | 111 | 325 | 0 | 35 | 514 | 294 | 19 | 95 | 808 | |||||||||||||||||||||||||||||||
2453070 | 2453070 | CT | school | 900208 | 2850013 | Achievement First Bridgeport Academy District | 90020801493 | 2850113 | Achievement First Bridgeport Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | 13 | 584 | 480 | * | 9 | * | * | 512 | 581 | 131 | 97 | 1093 | 13 | 584 | 480 | 9 | 512 | 581 | 131 | 97 | 1093 | ||||||||||||||||||||||||||||||||
2452989 | 2452989 | CT | school | 904950 | 1560011 | West Haven School District | 90495001037 | 1565311 | Carrigan 5/6 Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 281 | 211 | 357 | * | 30 | * | 36 | 510 | 408 | 91 | 145 | 918 | 281 | 211 | 357 | 30 | 36 | 510 | 408 | 91 | 145 | 918 | |||||||||||||||||||||||||||||||
2452139 | 2452139 | CT | school | 901890 | 630011 | Hampton School District | 90189000351 | 630111 | Hampton Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 82 | 0 | * | * | * | 0 | 6 | 51 | 42 | 0 | 17 | 93 | 82 | 0 | 0 | 6 | 51 | 42 | 0 | 17 | 93 | ||||||||||||||||||||||||||||||||
2453072 | 2453072 | CT | school | 900024 | 2790013 | Amistad Academy District | 90002400981 | 2795113 | Amistad Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | 19 | 681 | 360 | * | * | 0 | 21 | 509 | 574 | 118 | 71 | 1083 | 19 | 681 | 360 | 0 | 21 | 509 | 574 | 118 | 71 | 1083 | |||||||||||||||||||||||||||||||
2452467 | 2452467 | CT | school | 902790 | 930011 | New Haven School District | 90279000563 | 936211 | James Hillhouse High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 46 | 597 | 289 | * | 8 | * | * | 507 | 439 | 156 | 192 | 946 | 46 | 597 | 289 | 8 | 507 | 439 | 156 | 192 | 946 | ||||||||||||||||||||||||||||||||
2451986 | 2451986 | CT | school | 901320 | 450011 | East Lyme School District | 90132000223 | 456111 | East Lyme High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 750 | 23 | 74 | * | 96 | * | 53 | 506 | 496 | * | 132 | 1002 | 750 | 23 | 74 | 96 | 53 | 506 | 496 | 132 | 1002 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2452808 | 2452808 | CT | school | 904440 | 1380011 | Stratford School District | 90444000897 | 1386111 | Stratford High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 367 | 237 | 313 | 0 | 31 | * | * | 503 | 470 | 61 | 106 | 973 | 367 | 237 | 313 | 0 | 31 | 503 | 470 | 61 | 106 | 973 | |||||||||||||||||||||||||||||||
2452879 | 2452879 | CT | school | 904740 | 1480011 | Wallingford School District | 90474000955 | 1486111 | Lyman Hall High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 795 | 33 | 198 | 0 | 39 | * | * | 502 | 572 | 24 | 164 | 1074 | 795 | 33 | 198 | 0 | 39 | 502 | 572 | 24 | 164 | 1074 | |||||||||||||||||||||||||||||||
2452414 | 2452414 | CT | school | 902760 | 920011 | New Hartford School District | 90276000539 | 920111 | Bakerville Consolidated School | Public Schools | Regular School | No | Elementary | KG | 02 | 2019 | pk_12_total | 87 | 0 | * | 0 | 0 | 0 | * | 50 | 40 | 0 | 6 | 90 | 87 | 0 | 0 | 0 | 0 | 50 | 40 | 0 | 6 | 90 | |||||||||||||||||||||||||||||||
2452782 | 2452782 | CT | school | 904380 | 1370011 | Stonington School District | 90438000882 | 1370411 | West Broad Street School | Regular School | No | Elementary | 03 | 04 | 2019 | pk_12_total | 90 | * | 6 | * | * | 0 | 10 | 50 | 61 | * | 20 | 111 | 90 | 6 | 0 | 10 | 50 | 61 | 20 | 111 | ||||||||||||||||||||||||||||||||||
2451927 | 2451927 | CT | school | 901020 | 340011 | Danbury School District | 90102000160 | 345211 | Rogers Park Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 253 | 68 | 579 | 0 | 53 | * | * | 499 | 480 | 267 | 139 | 979 | 253 | 68 | 579 | 0 | 53 | 499 | 480 | 267 | 139 | 979 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2452918 | 2452918 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000991 | 1515211 | West Side Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 165 | 220 | 535 | 10 | 17 | 0 | 31 | 497 | 481 | 109 | 186 | 978 | 165 | 220 | 535 | 10 | 17 | 0 | 31 | 497 | 481 | 109 | 186 | 978 | |||||||||||||||||||||||||||||
2451722 | 2451722 | CT | school | 900120 | 40011 | Avon School District | 90012000011 | 46111 | Avon High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 679 | 40 | 55 | * | 142 | 0 | * | 492 | 459 | * | 110 | 951 | 679 | 40 | 55 | 142 | 0 | 492 | 459 | 110 | 951 | ||||||||||||||||||||||||||||||||
2451929 | 2451929 | CT | school | 901020 | 340011 | Danbury School District | 90102001129 | 346211 | Alternative Center For Excellence | Program | Alternative School | No | Not reported | M | M | 2019 | pk_12_total | 30 | 10 | 44 | * | * | 0 | * | 49 | 42 | 6 | 16 | 91 | 30 | 10 | 44 | 0 | 49 | 42 | 6 | 16 | 91 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2452185 | 2452185 | CT | school | 901920 | 640011 | Hartford School District | 90192001295 | 645411 | Hartford Magnet Trinity College Academy | Public Schools | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 192 | 272 | 485 | * | 48 | * | 53 | 487 | 570 | 78 | 126 | 1057 | 192 | 272 | 485 | 48 | 53 | 487 | 570 | 78 | 126 | 1057 | |||||||||||||||||||||||||||||||
2453127 | 2453127 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201145 | 9001616 | Howell Cheney Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 342 | 70 | 169 | 0 | 18 | 0 | 32 | 486 | 145 | 14 | 62 | 631 | 342 | 70 | 169 | 0 | 18 | 0 | 32 | 486 | 145 | 14 | 62 | 631 | |||||||||||||||||||||||||||||
2451737 | 2451737 | CT | school | 900270 | 90011 | Bethel School District | 90027000024 | 96111 | Bethel High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 621 | 31 | 162 | * | 70 | * | 16 | 485 | 419 | 30 | 114 | 904 | 621 | 31 | 162 | 70 | 16 | 485 | 419 | 30 | 114 | 904 | |||||||||||||||||||||||||||||||
2452135 | 2452135 | CT | school | 901860 | 620011 | Hamden School District | 90186000342 | 625211 | Hamden Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 323 | 292 | 181 | 0 | 54 | 0 | 50 | 482 | 418 | 30 | 167 | 900 | 323 | 292 | 181 | 0 | 54 | 0 | 50 | 482 | 418 | 30 | 167 | 900 | |||||||||||||||||||||||||||||
2452397 | 2452397 | CT | school | 902670 | 890011 | New Britain School District | 90267000522 | 895211 | Slade Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 128 | 118 | 584 | * | * | 0 | 24 | 482 | 384 | 124 | 180 | 866 | 128 | 118 | 584 | 0 | 24 | 482 | 384 | 124 | 180 | 866 | |||||||||||||||||||||||||||||||
2451926 | 2451926 | CT | school | 901020 | 340011 | Danbury School District | 90102000149 | 345111 | Broadview Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 331 | 72 | 479 | * | 56 | 0 | * | 480 | 497 | 130 | 170 | 977 | 331 | 72 | 479 | 56 | 0 | 480 | 497 | 130 | 170 | 977 | |||||||||||||||||||||||||||||||
2452013 | 2452013 | CT | school | 901470 | 490011 | Enfield School District | 90147001915 | 492211 | EPS Integrated Pre-Kindergarten | Program | Special Education School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 62 | * | * | 0 | * | 0 | * | 48 | 26 | 0 | 46 | 74 | 62 | 0 | 0 | 48 | 26 | 0 | 46 | 74 | |||||||||||||||||||||||||||||||||
2452716 | 2452716 | CT | school | 1320011 | South Windsor School District | 1320511 | Preschool Outreach Program | Program | 2019 | pk_12_total | 47 | * | 11 | 0 | 15 | 0 | * | 48 | 38 | 0 | 50 | 86 | 47 | 11 | 0 | 15 | 0 | 48 | 38 | 0 | 50 | 86 | ||||||||||||||||||||||||||||||||||||||
2453102 | 2453102 | CT | school | 903750 | 2080012 | Regional School District 08 | 90375000772 | 2086112 | RHAM High School | Regional Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 887 | 8 | 26 | * | 24 | 0 | * | 477 | 475 | * | 120 | 952 | 887 | 8 | 26 | 24 | 0 | 477 | 475 | 120 | 952 | ||||||||||||||||||||||||||||||||
2451979 | 2451979 | CT | school | 901290 | 440011 | East Haven School District | 90129000216 | 446111 | East Haven High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 567 | 30 | 239 | 0 | 47 | * | * | 473 | 424 | 81 | 124 | 897 | 567 | 30 | 239 | 0 | 47 | 473 | 424 | 81 | 124 | 897 | |||||||||||||||||||||||||||||||
2451802 | 2451802 | CT | school | 900510 | 170011 | Bristol School District | 90051000098 | 170511 | Greene-Hills School | Public Schools | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 462 | 68 | 313 | 0 | 45 | * | * | 472 | 446 | 70 | 115 | 918 | 462 | 68 | 313 | 0 | 45 | 472 | 446 | 70 | 115 | 918 | |||||||||||||||||||||||||||||||
2453027 | 2453027 | CT | school | 905130 | 1610011 | Wilton School District | 90513001073 | 1615211 | Middlebrook School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 770 | * | 66 | * | 104 | 0 | 54 | 471 | 532 | * | 138 | 1003 | 770 | 66 | 104 | 0 | 54 | 471 | 532 | 138 | 1003 | ||||||||||||||||||||||||||||||||
2453125 | 2453125 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201143 | 9001316 | H. H. Ellis Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2019 | pk_12_total | 590 | * | 39 | * | 6 | 0 | 16 | 469 | 188 | * | 58 | 657 | 590 | 39 | 6 | 0 | 16 | 469 | 188 | 58 | 657 | ||||||||||||||||||||||||||||||||
2452269 | 2452269 | CT | school | 902310 | 770011 | Manchester School District | 90231001533 | 771711 | Elisabeth M. Bennet Academy | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | pk_12_total | 289 | 233 | 296 | * | 75 | * | 27 | 467 | 455 | 58 | 136 | 922 | 289 | 233 | 296 | 75 | 27 | 467 | 455 | 58 | 136 | 922 | |||||||||||||||||||||||||||||||
2452974 | 2452974 | CT | school | 904920 | 1550011 | West Hartford School District | 90492001017 | 1555111 | King Philip Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 533 | 75 | 153 | 0 | 87 | * | * | 467 | 436 | 38 | 121 | 903 | 533 | 75 | 153 | 0 | 87 | 467 | 436 | 38 | 121 | 903 | |||||||||||||||||||||||||||||||
2452990 | 2452990 | CT | school | 904950 | 1560011 | West Haven School District | 90495001036 | 1565111 | Harry M. Bailey Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 315 | 234 | 352 | * | 26 | * | 29 | 466 | 494 | 87 | 144 | 960 | 315 | 234 | 352 | 26 | 29 | 466 | 494 | 87 | 144 | 960 | |||||||||||||||||||||||||||||||
2452395 | 2452395 | CT | school | 902670 | 890011 | New Britain School District | 90267000518 | 895311 | Pulaski Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 166 | 94 | 573 | * | 22 | 0 | * | 463 | 412 | 174 | 184 | 875 | 166 | 94 | 573 | 22 | 0 | 463 | 412 | 174 | 184 | 875 | |||||||||||||||||||||||||||||||
2452925 | 2452925 | CT | school | 904830 | 1510011 | Waterbury School District | 90483001115 | 1515311 | North End Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 83 | 234 | 576 | * | * | 0 | 24 | 463 | 465 | 86 | 182 | 928 | 83 | 234 | 576 | 0 | 24 | 463 | 465 | 86 | 182 | 928 | |||||||||||||||||||||||||||||||
2452302 | 2452302 | CT | school | 902400 | 800011 | Meriden School District | 90240000449 | 806211 | Orville H. Platt High School | Public Schools | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 244 | 111 | 524 | * | * | 0 | 33 | 462 | 469 | 110 | 148 | 931 | 244 | 111 | 524 | 0 | 33 | 462 | 469 | 110 | 148 | 931 |
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]);