enrollments
Data source: Big Local News · About: Big Local
20,454 rows where state = "CT" and year = 2020 sorted by disability 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2777993 | 2777993 | CT | school | 901260 | 430011 | East Hartford School District | 90126000196 | 431011 | Dr. Thomas S. O'Connell School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 118 | 128 | 245 | 0 | 16 | 0 | 33 | 279 | 261 | 42 | 84 | 540 | 118 | 128 | 245 | 0 | 16 | 0 | 33 | 279 | 261 | 42 | 84 | 540 | |||||||||||||||||||||||||||||
2778305 | 2778305 | CT | school | 902400 | 800011 | Meriden School District | 90240000445 | 800511 | John Barry School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 52 | 69 | 352 | 0 | 13 | 0 | 19 | 255 | 250 | 117 | 84 | 505 | 52 | 69 | 352 | 0 | 13 | 0 | 19 | 255 | 250 | 117 | 84 | 505 | |||||||||||||||||||||||||||||
2778532 | 2778532 | CT | school | 902970 | 990011 | North Branford School District | 90297000621 | 996111 | North Branford High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 458 | 12 | 39 | 0 | 9 | 0 | 6 | 239 | 285 | * | 84 | 524 | 458 | 12 | 39 | 0 | 9 | 0 | 6 | 239 | 285 | 84 | 524 | ||||||||||||||||||||||||||||||
2778609 | 2778609 | CT | school | 903300 | 1100011 | Plainville School District | 90330000703 | 1106111 | Plainville High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 480 | 29 | 118 | * | * | 0 | 34 | 369 | 310 | 23 | 84 | 679 | 480 | 29 | 118 | 0 | 34 | 369 | 310 | 23 | 84 | 679 | |||||||||||||||||||||||||||||||
2778708 | 2778708 | CT | school | 903990 | 1240011 | Seymour School District | 90399000794 | 1245111 | Seymour Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 387 | 24 | 104 | * | 17 | 0 | * | 272 | 272 | 6 | 84 | 544 | 387 | 24 | 104 | 17 | 0 | 272 | 272 | 6 | 84 | 544 | |||||||||||||||||||||||||||||||
2778750 | 2778750 | CT | school | 904230 | 1310011 | Southington School District | 90423000829 | 1311511 | Derynoski Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 437 | 11 | 40 | 0 | 17 | 0 | 25 | 276 | 254 | 9 | 84 | 530 | 437 | 11 | 40 | 0 | 17 | 0 | 25 | 276 | 254 | 9 | 84 | 530 | |||||||||||||||||||||||||||||
2778837 | 2778837 | CT | school | 904470 | 1390011 | Suffield School District | 90447000904 | 1396111 | Suffield High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 668 | 23 | 42 | * | 29 | * | * | 357 | 414 | * | 84 | 771 | 668 | 23 | 42 | 29 | 357 | 414 | 84 | 771 | |||||||||||||||||||||||||||||||||
2778846 | 2778846 | CT | school | 904560 | 1420011 | Tolland School District | 90456000913 | 1420211 | Tolland Intermediate School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 427 | 15 | 33 | 0 | 12 | 0 | 6 | 262 | 231 | 7 | 84 | 493 | 427 | 15 | 33 | 0 | 12 | 0 | 6 | 262 | 231 | 7 | 84 | 493 | |||||||||||||||||||||||||||||
2779165 | 2779165 | 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 | 2020 | pk_12_total | 331 | 65 | 196 | 0 | 16 | 0 | 36 | 494 | 150 | 19 | 84 | 644 | 331 | 65 | 196 | 0 | 16 | 0 | 36 | 494 | 150 | 19 | 84 | 644 | |||||||||||||||||||||||||||||
2778699 | 2778699 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000782 | 1195111 | Albert D. Griswold Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 337 | * | 60 | * | 150 | 0 | 20 | 292 | 291 | 15 | 83 | 583 | 337 | 60 | 150 | 0 | 20 | 292 | 291 | 15 | 83 | 583 | |||||||||||||||||||||||||||||||
2778823 | 2778823 | CT | school | 904440 | 1380011 | Stratford School District | 90444000900 | 1385211 | David Wooster Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 205 | 154 | 197 | 0 | 14 | 0 | 21 | 301 | 290 | 18 | 83 | 591 | 205 | 154 | 197 | 0 | 14 | 0 | 21 | 301 | 290 | 18 | 83 | 591 | |||||||||||||||||||||||||||||
2778907 | 2778907 | CT | school | 904740 | 1480011 | Wallingford School District | 90474000956 | 1486211 | Mark T. Sheehan High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 575 | * | 122 | 0 | 54 | 0 | * | 374 | 402 | 15 | 83 | 776 | 575 | 122 | 0 | 54 | 0 | 374 | 402 | 15 | 83 | 776 | |||||||||||||||||||||||||||||||
2777764 | 2777764 | CT | school | 900270 | 90011 | Bethel School District | 90027000025 | 95111 | Bethel Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 518 | 23 | 184 | 7 | 52 | 0 | 22 | 402 | 404 | 27 | 82 | 806 | 518 | 23 | 184 | 7 | 52 | 0 | 22 | 402 | 404 | 27 | 82 | 806 | |||||||||||||||||||||||||||||
2778010 | 2778010 | CT | school | 901290 | 440011 | East Haven School District | 90129000217 | 445111 | Joseph Melillo Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 272 | 40 | 184 | * | 12 | 0 | * | 257 | 263 | 51 | 82 | 520 | 272 | 40 | 184 | 12 | 0 | 257 | 263 | 51 | 82 | 520 | |||||||||||||||||||||||||||||||
2778304 | 2778304 | CT | school | 902400 | 800011 | Meriden School District | 90240000442 | 800311 | Hanover School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 153 | 18 | 255 | 0 | 6 | 0 | 19 | 227 | 224 | 127 | 82 | 451 | 153 | 18 | 255 | 0 | 6 | 0 | 19 | 227 | 224 | 127 | 82 | 451 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778670 | 2778670 | CT | school | 903539 | 2170012 | Regional School District 17 | 90353901201 | 2175112 | Haddam-Killingworth Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 430 | * | 14 | 0 | * | 0 | 17 | 255 | 221 | * | 82 | 476 | 430 | 14 | 0 | 0 | 17 | 255 | 221 | 82 | 476 | ||||||||||||||||||||||||||||||||
2778867 | 2778867 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000930 | 1445211 | Hillcrest Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 532 | 49 | 97 | * | 63 | * | 14 | 392 | 366 | * | 82 | 758 | 532 | 49 | 97 | 63 | 14 | 392 | 366 | 82 | 758 | ||||||||||||||||||||||||||||||||
2777858 | 2777858 | CT | school | 900510 | 170011 | Bristol School District | 90051000104 | 175211 | Northeast Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 281 | 37 | 106 | 0 | 24 | 0 | 21 | 237 | 232 | 15 | 81 | 469 | 281 | 37 | 106 | 0 | 24 | 0 | 21 | 237 | 232 | 15 | 81 | 469 | |||||||||||||||||||||||||||||
2777917 | 2777917 | CT | school | 900810 | 270011 | Clinton School District | 90081000134 | 276111 | The Morgan School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 484 | * | 83 | * | 18 | * | 7 | 306 | 292 | 19 | 81 | 598 | 484 | 83 | 18 | 7 | 306 | 292 | 19 | 81 | 598 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778691 | 2778691 | CT | school | 903810 | 1180011 | Ridgefield School District | 90381001361 | 1185211 | Scotts Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 450 | 6 | 44 | 0 | 39 | 0 | 19 | 282 | 276 | * | 81 | 558 | 450 | 6 | 44 | 0 | 39 | 0 | 19 | 282 | 276 | 81 | 558 | ||||||||||||||||||||||||||||||
2779095 | 2779095 | CT | school | 905280 | 1660011 | Wolcott School District | 90528001107 | 1666111 | Wolcott High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 610 | 23 | 45 | * | * | 0 | 21 | 355 | 362 | 6 | 81 | 717 | 610 | 23 | 45 | 0 | 21 | 355 | 362 | 6 | 81 | 717 | |||||||||||||||||||||||||||||||
2779162 | 2779162 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201142 | 9001716 | H. C. Wilcox Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2020 | pk_12_total | 345 | 40 | 353 | 0 | * | * | 29 | 450 | 329 | 23 | 81 | 779 | 345 | 40 | 353 | 0 | 29 | 450 | 329 | 23 | 81 | 779 | |||||||||||||||||||||||||||||||
2777793 | 2777793 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000052 | 150311 | Black Rock School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 135 | 74 | 282 | * | 10 | 0 | * | 258 | 247 | 106 | 80 | 505 | 135 | 74 | 282 | 10 | 0 | 258 | 247 | 106 | 80 | 505 | |||||||||||||||||||||||||||||||
2777868 | 2777868 | CT | school | 900570 | 190011 | Brooklyn School District | 90057000113 | 190111 | Brooklyn Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 446 | 14 | 68 | * | * | 0 | 20 | 273 | 290 | 10 | 80 | 563 | 446 | 14 | 68 | 0 | 20 | 273 | 290 | 10 | 80 | 563 | |||||||||||||||||||||||||||||||
2777943 | 2777943 | CT | school | 901020 | 340011 | Danbury School District | 90102001634 | 340111 | DPS Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | pk_12_total | 46 | * | 81 | 0 | 13 | 0 | * | 101 | 54 | 0 | 80 | 155 | 46 | 81 | 0 | 13 | 0 | 101 | 54 | 0 | 80 | 155 | |||||||||||||||||||||||||||||||
2778183 | 2778183 | CT | school | 901920 | 640011 | Hartford School District | 90192000364 | 640811 | M. D. Fox School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | * | 72 | 468 | 0 | 29 | * | 0 | 286 | 297 | 225 | 80 | 583 | 72 | 468 | 0 | 29 | 0 | 286 | 297 | 225 | 80 | 583 | |||||||||||||||||||||||||||||||
2778194 | 2778194 | CT | school | 901920 | 640011 | Hartford School District | 90192000383 | 642011 | Webster Micro Society Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 104 | 279 | 162 | * | 61 | 0 | * | 335 | 300 | 46 | 80 | 635 | 104 | 279 | 162 | 61 | 0 | 335 | 300 | 46 | 80 | 635 | |||||||||||||||||||||||||||||||
2778659 | 2778659 | CT | school | 903537 | 2150012 | Regional School District 15 | 90353700751 | 2155112 | Rochambeau Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 331 | * | 22 | * | 20 | 0 | 12 | 201 | 196 | * | 80 | 397 | 331 | 22 | 20 | 0 | 12 | 201 | 196 | 80 | 397 | ||||||||||||||||||||||||||||||||
2778709 | 2778709 | CT | school | 903990 | 1240011 | Seymour School District | 90399000793 | 1246111 | Seymour High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 472 | 43 | 94 | * | 27 | * | 6 | 305 | 339 | 10 | 80 | 644 | 472 | 43 | 94 | 27 | 6 | 305 | 339 | 10 | 80 | 644 | |||||||||||||||||||||||||||||||
2779101 | 2779101 | CT | school | 900024 | 2790013 | Amistad Academy District | 90002400981 | 2795113 | Amistad Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | * | 684 | 381 | * | 0 | 0 | 20 | 498 | 605 | 111 | 80 | 1103 | 684 | 381 | 0 | 0 | 20 | 498 | 605 | 111 | 80 | 1103 | |||||||||||||||||||||||||||||||
2777886 | 2777886 | CT | school | 2410014 | Capitol Region Education Council | 90070001492 | 2419114 | Soundbridge | Program | 2020 | pk_12_total | 24 | 0 | 6 | 0 | * | * | 0 | 21 | 12 | 0 | 8 | 33 | 24 | 0 | 6 | 0 | 0 | 21 | 12 | 0 | 8 | 33 | |||||||||||||||||||||||||||||||||||||
2777937 | 2777937 | CT | school | 320011 | Coventry School District | 90096001787 | 320111 | Coventry Academy | Public Schools | 2020 | pk_12_total | 14 | 0 | * | 0 | 0 | 0 | * | 12 | 7 | 0 | 8 | 19 | 14 | 0 | 0 | 0 | 0 | 12 | 7 | 0 | 8 | 19 | |||||||||||||||||||||||||||||||||||||
2778023 | 2778023 | CT | school | 470011 | East Windsor School District | 470411 | East Windsor Transition Program | Program | 2020 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | 0 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | ||||||||||||||||||||||||||||||||||||||||
2778199 | 2778199 | CT | school | 640011 | Hartford School District | 640810 | iGOAL Pre-K - Rawson School | Program | 2020 | pk_12_total | * | * | * | 0 | 0 | 0 | 0 | * | * | 0 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | |||||||||||||||||||||||||||||||||||||||||
2778210 | 2778210 | CT | school | 640011 | Hartford School District | 649811 | iGOAL 1 - Moylan School | 2020 | pk_12_total | 0 | * | * | 0 | 0 | 0 | * | * | * | * | 8 | 8 | 0 | 0 | 0 | 0 | 8 | 8 | |||||||||||||||||||||||||||||||||||||||||||
2778269 | 2778269 | CT | school | 720011 | Ledyard School District | 720511 | Ledyard Transition Academy | Program | 2020 | pk_12_total | * | * | 0 | 0 | * | 0 | 0 | * | * | 0 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | |||||||||||||||||||||||||||||||||||||||||
2778296 | 2778296 | CT | school | 770011 | Manchester School District | 90231001717 | 770711 | New Horizons | Program | 2020 | pk_12_total | * | 10 | 8 | * | 0 | 0 | 0 | * | * | 0 | 8 | 24 | 10 | 8 | 0 | 0 | 0 | 0 | 8 | 24 | |||||||||||||||||||||||||||||||||||||||
2778324 | 2778324 | CT | school | 800011 | Meriden School District | 801811 | STARS - HS | Program | 2020 | pk_12_total | * | 0 | * | 0 | * | 0 | 0 | 8 | 0 | * | 8 | 8 | 0 | 0 | 0 | 0 | 8 | 0 | 8 | 8 | ||||||||||||||||||||||||||||||||||||||||
2778345 | 2778345 | CT | school | 830011 | Middletown School District | 90249001793 | 830411 | ICM- Woodrow Wilson Middle School | Program | 2020 | pk_12_total | * | 0 | * | 0 | 0 | 0 | * | * | * | 0 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | ||||||||||||||||||||||||||||||||||||||||
2778369 | 2778369 | CT | school | 840011 | Milford School District | 840411 | Fifth Year Vocational Experience | Program | 2020 | pk_12_total | 6 | * | * | 0 | 0 | 0 | 0 | * | * | * | 8 | 8 | 6 | 0 | 0 | 0 | 0 | 8 | 8 | |||||||||||||||||||||||||||||||||||||||||
2778436 | 2778436 | CT | school | 902760 | 920011 | New Hartford School District | 90276000539 | 920111 | Bakerville Consolidated School | Public Schools | Regular School | No | Elementary | KG | 02 | 2020 | pk_12_total | 98 | 0 | * | 0 | 0 | 0 | * | 52 | 50 | * | 8 | 102 | 98 | 0 | 0 | 0 | 0 | 52 | 50 | 8 | 102 | ||||||||||||||||||||||||||||||||
2778577 | 2778577 | CT | school | 1040011 | Norwich School District | 1040511 | Special Needs Program @ Mahan | Program | 2020 | pk_12_total | * | 0 | * | 0 | * | 0 | 0 | * | * | * | 8 | 8 | 0 | 0 | 0 | 0 | 8 | 8 | ||||||||||||||||||||||||||||||||||||||||||
2778753 | 2778753 | CT | school | 1310011 | Southington School District | 1312311 | Language Based Classroom II | Program | 2020 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | 0 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | ||||||||||||||||||||||||||||||||||||||||
2778759 | 2778759 | CT | school | 1310011 | Southington School District | 90423001786 | 1310411 | Language Based Classroom at Hatton School | Program | 2020 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | 0 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | |||||||||||||||||||||||||||||||||||||||
2778763 | 2778763 | CT | school | 1310011 | Southington School District | 90423001720 | 1311611 | Therapeutic Educational Alternative Model (TEAM) | Program | 2020 | pk_12_total | * | 0 | * | 0 | 0 | 0 | * | * | * | 0 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | ||||||||||||||||||||||||||||||||||||||||
2778802 | 2778802 | CT | school | 1350011 | Stamford School District | 1351311 | PAVE (Post-Secondary Adaptive Vocational Experience) | Program | 2020 | pk_12_total | * | * | * | 0 | 0 | 0 | 0 | * | * | * | 8 | 8 | 0 | 0 | 0 | 0 | 8 | 8 | ||||||||||||||||||||||||||||||||||||||||||
2778898 | 2778898 | CT | school | 1480011 | Wallingford School District | 90474001595 | 1489211 | WISE Intermediate Program | Program | 2020 | pk_12_total | * | 0 | * | 0 | 0 | 0 | 0 | * | * | 0 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | |||||||||||||||||||||||||||||||||||||||
2778903 | 2778903 | CT | school | 1480011 | Wallingford School District | 1481311 | Inspire Middle School | Program | 2020 | pk_12_total | 6 | 0 | * | 0 | * | 0 | 0 | * | * | * | 8 | 8 | 6 | 0 | 0 | 0 | 0 | 8 | 8 | |||||||||||||||||||||||||||||||||||||||||
2778918 | 2778918 | CT | school | 1510011 | Waterbury School District | 1519811 | Maloney Prek | Program | 2020 | pk_12_total | * | * | * | 0 | 0 | 0 | 0 | * | * | 0 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | |||||||||||||||||||||||||||||||||||||||||
2779130 | 2779130 | CT | school | 2050012 | Regional School District 05 | 2050112 | Amity Transition Academy | Program | 2020 | pk_12_total | * | 0 | 0 | 0 | * | 0 | 0 | * | * | 0 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 8 | ||||||||||||||||||||||||||||||||||||||||
2777739 | 2777739 | CT | school | 900070 | 2440014 | Area Cooperative Educational Services | 90007001358 | 2445114 | Thomas Edison Magnet Middle School | Regional Education Service Center Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 144 | 100 | 381 | * | 36 | 0 | * | 342 | 356 | 67 | 79 | 698 | 144 | 100 | 381 | 36 | 0 | 342 | 356 | 67 | 79 | 698 | |||||||||||||||||||||||||||||||
2777761 | 2777761 | CT | school | 900270 | 90011 | Bethel School District | 90027000027 | 90111 | Frank A. Berry School | Public Schools | Regular School | No | Elementary | PK | 03 | 2020 | pk_12_total | 307 | 22 | 113 | * | 52 | 0 | * | 273 | 247 | 51 | 79 | 520 | 307 | 22 | 113 | 52 | 0 | 273 | 247 | 51 | 79 | 520 | |||||||||||||||||||||||||||||||
2777920 | 2777920 | CT | school | 900840 | 280011 | Colchester School District | 90084000136 | 285111 | William J. Johnston Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 434 | * | 39 | * | 16 | 0 | 22 | 259 | 258 | * | 79 | 517 | 434 | 39 | 16 | 0 | 22 | 259 | 258 | 79 | 517 | ||||||||||||||||||||||||||||||||
2778079 | 2778079 | CT | school | 901530 | 510011 | Fairfield School District | 90153000271 | 515111 | Tomlinson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 442 | 21 | 114 | * | 50 | * | 34 | 344 | 319 | 21 | 79 | 663 | 442 | 21 | 114 | 50 | 34 | 344 | 319 | 21 | 79 | 663 | |||||||||||||||||||||||||||||||
2778089 | 2778089 | CT | school | 901560 | 520011 | Farmington School District | 90156001368 | 520511 | West Woods Upper Elementary School | Public Schools | Regular School | No | Middle | 04 | 06 | 2020 | pk_12_total | 363 | 33 | 55 | * | 160 | 0 | * | 313 | 321 | 19 | 79 | 634 | 363 | 33 | 55 | 160 | 0 | 313 | 321 | 19 | 79 | 634 | |||||||||||||||||||||||||||||||
2778244 | 2778244 | CT | school | 902070 | 690011 | Killingly School District | 90207000394 | 690311 | Killingly Memorial School | Public Schools | Regular School | No | Elementary | 02 | 04 | 2020 | pk_12_total | 422 | 6 | 52 | * | 7 | * | 35 | 261 | 266 | 23 | 79 | 527 | 422 | 6 | 52 | 7 | 35 | 261 | 266 | 23 | 79 | 527 | |||||||||||||||||||||||||||||||
2778431 | 2778431 | CT | school | 902730 | 910011 | New Fairfield School District | 90273001195 | 910211 | Meeting House Hill School | Public Schools | Regular School | No | Elementary | 03 | 05 | 2020 | pk_12_total | 338 | 7 | 77 | * | * | 0 | 14 | 221 | 221 | 28 | 79 | 442 | 338 | 7 | 77 | 0 | 14 | 221 | 221 | 28 | 79 | 442 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778090 | 2778090 | CT | school | 901560 | 520011 | Farmington School District | 90156000274 | 525111 | Irving A. Robbins Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 388 | 35 | 65 | * | 172 | 0 | * | 346 | 337 | 8 | 78 | 683 | 388 | 35 | 65 | 172 | 0 | 346 | 337 | 8 | 78 | 683 | |||||||||||||||||||||||||||||||
2778347 | 2778347 | CT | school | 902490 | 830011 | Middletown School District | 90249000459 | 835411 | Woodrow Wilson Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 274 | 149 | 126 | * | 19 | * | 47 | 313 | 305 | 15 | 78 | 618 | 274 | 149 | 126 | 19 | 47 | 313 | 305 | 15 | 78 | 618 | |||||||||||||||||||||||||||||||
2778404 | 2778404 | CT | school | 902670 | 890011 | New Britain School District | 90267000509 | 890311 | Chamberlain Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 54 | 50 | 313 | * | * | 0 | 17 | 230 | 212 | 53 | 78 | 442 | 54 | 50 | 313 | 0 | 17 | 230 | 212 | 53 | 78 | 442 | |||||||||||||||||||||||||||||||
2778484 | 2778484 | CT | school | 902790 | 930011 | New Haven School District | 90279001207 | 936411 | Cooperative High School - Inter-District Magnet | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 89 | 257 | 220 | * | * | 0 | 8 | 188 | 393 | 23 | 78 | 581 | 89 | 257 | 220 | 0 | 8 | 188 | 393 | 23 | 78 | 581 | |||||||||||||||||||||||||||||||
2778524 | 2778524 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2020 | pk_12_total | 474 | * | 38 | * | 20 | 0 | 16 | 283 | 277 | * | 78 | 560 | 474 | 38 | 20 | 0 | 16 | 283 | 277 | 78 | 560 | ||||||||||||||||||||||||||||||||
2778790 | 2778790 | CT | school | 904320 | 1350011 | Stamford School District | 90432000008 | 1351911 | Toquam Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 113 | 76 | 409 | * | 40 | * | 24 | 363 | 303 | 158 | 78 | 666 | 113 | 76 | 409 | 40 | 24 | 363 | 303 | 158 | 78 | 666 | |||||||||||||||||||||||||||||||
2778821 | 2778821 | CT | school | 904440 | 1380011 | Stratford School District | 90444000892 | 1381511 | Stratford Academy - Johnson House | Public Schools | Regular School | No | Elementary | 02 | 06 | 2020 | pk_12_total | 77 | 143 | 204 | 0 | 14 | 0 | 23 | 224 | 237 | 74 | 78 | 461 | 77 | 143 | 204 | 0 | 14 | 0 | 23 | 224 | 237 | 74 | 78 | 461 | |||||||||||||||||||||||||||||
2779028 | 2779028 | CT | school | 905010 | 1570011 | Weston School District | 90501001046 | 1576111 | Weston High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 685 | 14 | 29 | 0 | 35 | 0 | 29 | 421 | 371 | * | 78 | 792 | 685 | 14 | 29 | 0 | 35 | 0 | 29 | 421 | 371 | 78 | 792 | ||||||||||||||||||||||||||||||
2778411 | 2778411 | CT | school | 902670 | 890011 | New Britain School District | 90267000527 | 891511 | Vance Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 61 | 51 | 361 | 0 | * | 0 | * | 260 | 236 | 91 | 77 | 496 | 61 | 51 | 361 | 0 | 0 | 260 | 236 | 91 | 77 | 496 | |||||||||||||||||||||||||||||||
2778447 | 2778447 | CT | school | 902790 | 930011 | New Haven School District | 90279000584 | 933111 | Conte/West Hills Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 59 | 248 | 353 | * | 7 | * | 21 | 350 | 343 | 73 | 77 | 693 | 59 | 248 | 353 | 7 | 21 | 350 | 343 | 73 | 77 | 693 | |||||||||||||||||||||||||||||||
2778449 | 2778449 | CT | school | 930011 | New Haven School District | 932711 | Dr. Reginald Mayo Early Learning Center | Program | 2020 | pk_12_total | 20 | 191 | 92 | * | * | 0 | 14 | 189 | 136 | 0 | 77 | 325 | 20 | 191 | 92 | 0 | 14 | 189 | 136 | 0 | 77 | 325 | ||||||||||||||||||||||||||||||||||||||
2778477 | 2778477 | CT | school | 902790 | 930011 | New Haven School District | 90279001483 | 934211 | Roberto Clemente Leadership Academy for Global Awareness | Public Schools | Regular School | No | Elementary | KG | 08 | 2020 | pk_12_total | 33 | 128 | 275 | 0 | 6 | * | * | 227 | 218 | 124 | 77 | 445 | 33 | 128 | 275 | 0 | 6 | 227 | 218 | 124 | 77 | 445 | |||||||||||||||||||||||||||||||
2778608 | 2778608 | CT | school | 903300 | 1100011 | Plainville School District | 90330000048 | 1105211 | Middle School of Plainville | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 352 | 21 | 121 | * | * | 0 | 26 | 270 | 272 | 26 | 77 | 542 | 352 | 21 | 121 | 0 | 26 | 270 | 272 | 26 | 77 | 542 | |||||||||||||||||||||||||||||||
2778806 | 2778806 | CT | school | 904380 | 1370011 | Stonington School District | 90438000877 | 1375211 | Stonington Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 417 | 7 | 29 | * | * | 0 | 12 | 246 | 222 | * | 77 | 468 | 417 | 7 | 29 | 0 | 12 | 246 | 222 | 77 | 468 | ||||||||||||||||||||||||||||||||
2778824 | 2778824 | CT | school | 904440 | 1380011 | Stratford School District | 90444000888 | 1385311 | Harry B. Flood Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 195 | 107 | 192 | 0 | 12 | 0 | 18 | 253 | 271 | 26 | 77 | 524 | 195 | 107 | 192 | 0 | 12 | 0 | 18 | 253 | 271 | 26 | 77 | 524 | |||||||||||||||||||||||||||||
2778834 | 2778834 | CT | school | 904470 | 1390011 | Suffield School District | 90447000903 | 1390411 | A. Ward Spaulding School | Public Schools | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 373 | 12 | 35 | 0 | 18 | 0 | 16 | 240 | 214 | 24 | 77 | 454 | 373 | 12 | 35 | 0 | 18 | 0 | 16 | 240 | 214 | 24 | 77 | 454 | |||||||||||||||||||||||||||||
2778863 | 2778863 | CT | school | 904620 | 1440011 | Trumbull School District | 90462001469 | 1441011 | Frenchtown Elementary School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 271 | 44 | 124 | * | 42 | 0 | * | 256 | 238 | 49 | 77 | 494 | 271 | 44 | 124 | 42 | 0 | 256 | 238 | 49 | 77 | 494 | |||||||||||||||||||||||||||||||
2778915 | 2778915 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000976 | 1512611 | Gilmartin School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 62 | 104 | 276 | * | 12 | * | 13 | 253 | 220 | 53 | 77 | 473 | 62 | 104 | 276 | 12 | 13 | 253 | 220 | 53 | 77 | 473 | |||||||||||||||||||||||||||||||
2778916 | 2778916 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000977 | 1510711 | H. S. Chase School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 102 | 164 | 350 | 7 | 19 | 0 | 26 | 369 | 299 | 102 | 77 | 668 | 102 | 164 | 350 | 7 | 19 | 0 | 26 | 369 | 299 | 102 | 77 | 668 | |||||||||||||||||||||||||||||
2779093 | 2779093 | CT | school | 905280 | 1660011 | Wolcott School District | 90528001102 | 1665111 | Tyrrell Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 422 | 26 | 44 | 0 | 11 | 0 | 21 | 262 | 262 | 10 | 77 | 524 | 422 | 26 | 44 | 0 | 11 | 0 | 21 | 262 | 262 | 10 | 77 | 524 | |||||||||||||||||||||||||||||
2779104 | 2779104 | CT | school | 900221 | 2970013 | Capital Preparatory Harbor School District | 90022101803 | 2970113 | Capital Preparatory Harbor School | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | * | 539 | 211 | 0 | 0 | 0 | * | 387 | 373 | 50 | 77 | 760 | 539 | 211 | 0 | 0 | 0 | 387 | 373 | 50 | 77 | 760 | |||||||||||||||||||||||||||||||
2777799 | 2777799 | CT | school | 900450 | 150011 | Bridgeport School District | 90045001918 | 153111 | Geraldine Claytor Magnet Academy | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 32 | 178 | 216 | * | * | * | 7 | 218 | 223 | 71 | 76 | 441 | 32 | 178 | 216 | 7 | 218 | 223 | 71 | 76 | 441 | ||||||||||||||||||||||||||||||||
2777898 | 2777898 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001532 | 2415214 | Civic Leadership High School | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 64 | 76 | 184 | * | * | * | 15 | 184 | 164 | 24 | 76 | 348 | 64 | 76 | 184 | 15 | 184 | 164 | 24 | 76 | 348 | ||||||||||||||||||||||||||||||||
2777910 | 2777910 | CT | school | 900750 | 250011 | Cheshire School District | 90075000125 | 255111 | Dodd Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | pk_12_total | 520 | 20 | 34 | * | 59 | 0 | * | 319 | 332 | * | 76 | 651 | 520 | 20 | 34 | 59 | 0 | 319 | 332 | 76 | 651 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2778020 | 2778020 | CT | school | 901350 | 470011 | East Windsor School District | 90135000228 | 470111 | Broad Brook Elementary School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | pk_12_total | 240 | 50 | 109 | 0 | 45 | 0 | 32 | 241 | 235 | 51 | 76 | 476 | 240 | 50 | 109 | 0 | 45 | 0 | 32 | 241 | 235 | 51 | 76 | 476 | |||||||||||||||||||||||||||||
2778450 | 2778450 | CT | school | 902790 | 930011 | New Haven School District | 90279000552 | 934611 | East Rock Community Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 62 | 170 | 189 | * | 26 | * | 7 | 218 | 239 | 80 | 76 | 457 | 62 | 170 | 189 | 26 | 7 | 218 | 239 | 80 | 76 | 457 | |||||||||||||||||||||||||||||||
2778459 | 2778459 | CT | school | 902790 | 930011 | New Haven School District | 90279000568 | 931411 | Nathan Hale School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 217 | 69 | 230 | * | * | 0 | 11 | 269 | 266 | 48 | 76 | 535 | 217 | 69 | 230 | 0 | 11 | 269 | 266 | 48 | 76 | 535 | |||||||||||||||||||||||||||||||
2778555 | 2778555 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000660 | 1031411 | Tracey Magnet School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 69 | 67 | 249 | 0 | 31 | 0 | 19 | 248 | 187 | 121 | 76 | 435 | 69 | 67 | 249 | 0 | 31 | 0 | 19 | 248 | 187 | 121 | 76 | 435 | |||||||||||||||||||||||||||||
2778658 | 2778658 | CT | school | 903537 | 2150012 | Regional School District 15 | 90353700748 | 2155212 | Memorial Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 380 | * | 20 | 0 | 24 | * | 13 | 226 | 221 | * | 76 | 447 | 380 | 20 | 0 | 24 | 13 | 226 | 221 | 76 | 447 | ||||||||||||||||||||||||||||||||
2778738 | 2778738 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000822 | 1320711 | Eli Terry School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 269 | 32 | 57 | * | 81 | 0 | * | 227 | 231 | 24 | 76 | 458 | 269 | 32 | 57 | 81 | 0 | 227 | 231 | 24 | 76 | 458 | |||||||||||||||||||||||||||||||
2778885 | 2778885 | CT | school | 904740 | 1480011 | Wallingford School District | 90474000950 | 1481011 | Cook Hill School | Public Schools | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 236 | * | 78 | * | 19 | 0 | 11 | 199 | 150 | 43 | 76 | 349 | 236 | 78 | 19 | 0 | 11 | 199 | 150 | 43 | 76 | 349 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2778977 | 2778977 | CT | school | 904890 | 1530011 | Watertown School District | 90489001135 | 1530211 | John Trumbull Primary School | Public Schools | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 549 | 19 | 32 | * | 11 | * | 24 | 337 | 302 | 62 | 76 | 639 | 549 | 19 | 32 | 11 | 24 | 337 | 302 | 62 | 76 | 639 | |||||||||||||||||||||||||||||||
2779064 | 2779064 | CT | school | 905190 | 1630011 | Windham School District | 90519001214 | 1630311 | North Windham School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | pk_12_total | 72 | 19 | 348 | * | 9 | 0 | * | 230 | 224 | 174 | 76 | 454 | 72 | 19 | 348 | 9 | 0 | 230 | 224 | 174 | 76 | 454 | |||||||||||||||||||||||||||||||
2778004 | 2778004 | CT | school | 901290 | 440011 | East Haven School District | 90129000214 | 440111 | Deer Run School | Public Schools | Regular School | No | Elementary | PK | 02 | 2020 | pk_12_total | 138 | * | 68 | 0 | 8 | * | 11 | 131 | 103 | 19 | 75 | 234 | 138 | 68 | 0 | 8 | 11 | 131 | 103 | 19 | 75 | 234 | |||||||||||||||||||||||||||||||
2778136 | 2778136 | CT | school | 901770 | 590011 | Groton School District | 90177000312 | 595311 | Carl C. Cutler Middle School | Regular School | No | Middle | 06 | 08 | 2020 | pk_12_total | 311 | 21 | 83 | * | 30 | * | 57 | 214 | 297 | 8 | 75 | 511 | 311 | 21 | 83 | 30 | 57 | 214 | 297 | 8 | 75 | 511 | ||||||||||||||||||||||||||||||||
2778215 | 2778215 | CT | school | 901920 | 640011 | Hartford School District | 90192001478 | 646411 | Classical Magnet School | Public Schools | Regular School | No | High | 06 | 12 | 2020 | pk_12_total | 52 | 184 | 172 | 0 | * | * | 10 | * | 237 | 40 | 75 | 429 | 52 | 184 | 172 | 0 | 10 | 237 | 40 | 75 | 429 | ||||||||||||||||||||||||||||||||
2778220 | 2778220 | CT | school | 901920 | 640011 | Hartford School District | 90192001370 | 646511 | Sport and Medical Sciences Academy | Public Schools | Regular School | No | High | 06 | 12 | 2020 | pk_12_total | 141 | 146 | 302 | * | 32 | 0 | * | 385 | 258 | 80 | 75 | 643 | 141 | 146 | 302 | 32 | 0 | 385 | 258 | 80 | 75 | 643 | |||||||||||||||||||||||||||||||
2778227 | 2778227 | CT | school | 901920 | 640011 | Hartford School District | 90192001479 | 646611 | Pathways Academy of Technology and Design | Public Schools | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 83 | 122 | 172 | 0 | 8 | 0 | 18 | 279 | 124 | 28 | 75 | 403 | 83 | 122 | 172 | 0 | 8 | 0 | 18 | 279 | 124 | 28 | 75 | 403 |
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]);