enrollments
Data source: Big Local News · About: Big Local
4,354 rows where grade = "grade_9" and state = "CT" sorted by ccd_school_lvl 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2446158 | 2446158 | CT | school | 901230 | 420011 | East Hampton School District | 90123000188 | 425111 | East Hampton Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446171 | 2446171 | CT | school | 901260 | 430011 | East Hartford School District | 90126000197 | 435111 | East Hartford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446172 | 2446172 | CT | school | 901260 | 430011 | East Hartford School District | 90126001275 | 432411 | Sunset Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446182 | 2446182 | CT | school | 901290 | 440011 | East Haven School District | 90129000217 | 445111 | Joseph Melillo Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446188 | 2446188 | CT | school | 901320 | 450011 | East Lyme School District | 90132000224 | 455111 | East Lyme Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446193 | 2446193 | CT | school | 901350 | 470011 | East Windsor School District | 90135000230 | 475411 | East Windsor Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446202 | 2446202 | CT | school | 901410 | 460011 | Easton School District | 90141000233 | 465111 | Helen Keller Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446212 | 2446212 | CT | school | 901440 | 480011 | Ellington School District | 90144000238 | 485111 | Ellington Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446233 | 2446233 | CT | school | 901470 | 490011 | Enfield School District | 90147000249 | 495211 | John F. Kennedy Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446251 | 2446251 | CT | school | 901530 | 510011 | Fairfield School District | 90153000258 | 515211 | Fairfield Woods Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446252 | 2446252 | CT | school | 901530 | 510011 | Fairfield School District | 90153000919 | 515311 | Roger Ludlowe Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446253 | 2446253 | CT | school | 901530 | 510011 | Fairfield School District | 90153000271 | 515111 | Tomlinson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446263 | 2446263 | CT | school | 901560 | 520011 | Farmington School District | 90156001368 | 520511 | West Woods Upper Elementary School | Public Schools | Regular School | No | Middle | 04 | 06 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446264 | 2446264 | CT | school | 901560 | 520011 | Farmington School District | 90156000274 | 525111 | Irving A. Robbins Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446275 | 2446275 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000279 | 540811 | Gideon Welles School | Public Schools | Regular School | No | Middle | 06 | 06 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446276 | 2446276 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000282 | 545211 | Smith Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446281 | 2446281 | CT | school | 901680 | 560011 | Granby School District | 90168000291 | 565111 | Granby Memorial Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446294 | 2446294 | CT | school | 901710 | 570011 | Greenwich School District | 90171000295 | 575111 | Central Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446295 | 2446295 | CT | school | 901710 | 570011 | Greenwich School District | 90171000298 | 575211 | Eastern Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446296 | 2446296 | CT | school | 901710 | 570011 | Greenwich School District | 90171000309 | 575311 | Western Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446301 | 2446301 | CT | school | 901740 | 580011 | Griswold School District | 90174000019 | 585111 | Griswold Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446310 | 2446310 | CT | school | 901770 | 590011 | Groton School District | 90177000312 | 595311 | Carl C. Cutler Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2446311 | 2446311 | CT | school | 901770 | 590011 | Groton School District | 90177000326 | 595211 | West Side Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2446320 | 2446320 | CT | school | 901800 | 600011 | Guilford School District | 90180000328 | 600711 | A. Baldwin Middle School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446321 | 2446321 | CT | school | 901800 | 600011 | Guilford School District | 90180000331 | 605111 | E. C. Adams Middle School | Public Schools | Regular School | No | Middle | 07 | 09 | 2019 | grade_9 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2446339 | 2446339 | CT | school | 901860 | 620011 | Hamden School District | 90186000342 | 625211 | Hamden Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446386 | 2446386 | CT | school | 901920 | 640011 | Hartford School District | 90192001582 | 644011 | Renzulli Gifted and Talented Academy | Public Schools | Regular School | No | Middle | 04 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446387 | 2446387 | CT | school | 901920 | 640011 | Hartford School District | 90192001616 | 643811 | Betances STEM Magnet School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446390 | 2446390 | CT | school | 901920 | 640011 | Hartford School District | 90192000369 | 641611 | M. L. King, Jr. Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446391 | 2446391 | CT | school | 901920 | 640011 | Hartford School District | 90192000371 | 641211 | McDonough Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446422 | 2446422 | CT | school | 902070 | 690011 | Killingly School District | 90207000393 | 695211 | Killingly Intermediate School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446432 | 2446432 | CT | school | 903450 | 2450014 | Learn | 90345001556 | 2455014 | Dual Language & Arts Magnet Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2446441 | 2446441 | CT | school | 902130 | 710011 | Lebanon School District | 90213000028 | 715111 | Lebanon Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446447 | 2446447 | CT | school | 902160 | 720011 | Ledyard School District | 90216000402 | 725111 | Ledyard Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446452 | 2446452 | CT | school | 902220 | 740011 | Litchfield School District | 90222000407 | 740311 | Litchfield Intermediate School | Public Schools | Regular School | No | Middle | 04 | 06 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446453 | 2446453 | CT | school | 902220 | 740011 | Litchfield School District | 90222001809 | 746011 | Litchfield Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446459 | 2446459 | CT | school | 902280 | 760011 | Madison School District | 90228001382 | 760611 | Dr. Robert H. Brown Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446460 | 2446460 | CT | school | 902280 | 760011 | Madison School District | 90228001480 | 765211 | Walter C. Polson Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446473 | 2446473 | CT | school | 902310 | 770011 | Manchester School District | 90231001533 | 771711 | Elisabeth M. Bennet Academy | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446475 | 2446475 | CT | school | 902310 | 770011 | Manchester School District | 90231000421 | 775311 | Illing Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446484 | 2446484 | CT | school | 902340 | 780011 | Mansfield School District | 90234000433 | 785111 | Mansfield Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446498 | 2446498 | CT | school | 902400 | 800011 | Meriden School District | 90240000447 | 805211 | Lincoln Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446502 | 2446502 | CT | school | 902400 | 800011 | Meriden School District | 90240001194 | 805411 | Washington Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446529 | 2446529 | CT | school | 902490 | 830011 | Middletown School District | 90249000456 | 831511 | Keigwin Middle School | Public Schools | Regular School | No | Middle | 06 | 06 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446530 | 2446530 | CT | school | 902490 | 830011 | Middletown School District | 90249000459 | 835411 | Woodrow Wilson Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446546 | 2446546 | CT | school | 902520 | 840011 | Milford School District | 90252000484 | 845111 | East Shore Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446547 | 2446547 | CT | school | 902520 | 840011 | Milford School District | 90252000468 | 845211 | Harborside Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446548 | 2446548 | CT | school | 902520 | 840011 | Milford School District | 90252000474 | 845311 | West Shore Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446557 | 2446557 | CT | school | 902550 | 850011 | Monroe School District | 90255000920 | 855211 | Jockey Hollow School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446564 | 2446564 | CT | school | 902580 | 860011 | Montville School District | 90258000035 | 865111 | Leonard J. Tyl Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446575 | 2446575 | CT | school | 902640 | 880011 | Naugatuck School District | 90264000502 | 880211 | Cross Street Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446576 | 2446576 | CT | school | 902640 | 880011 | Naugatuck School District | 90264000504 | 880411 | Hillside Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446577 | 2446577 | CT | school | 902640 | 880011 | Naugatuck School District | 90264000501 | 885111 | City Hill Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446598 | 2446598 | CT | school | 902670 | 890011 | New Britain School District | 90267001445 | 895411 | House of Arts Letters and Science (HALS) Academy | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446599 | 2446599 | CT | school | 902670 | 890011 | New Britain School District | 90267000518 | 895311 | Pulaski Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446601 | 2446601 | CT | school | 902670 | 890011 | New Britain School District | 90267000522 | 895211 | Slade Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446609 | 2446609 | CT | school | 902700 | 900011 | New Canaan School District | 90270000532 | 905111 | Saxe Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446614 | 2446614 | CT | school | 902730 | 910011 | New Fairfield School District | 90273001224 | 915211 | New Fairfield Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446665 | 2446665 | CT | school | 902790 | 930011 | New Haven School District | 90279000545 | 935511 | Betsy Ross Arts Magnet School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446685 | 2446685 | CT | school | 902820 | 950011 | New London School District | 90282000596 | 955111 | Bennie Dover Jackson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446686 | 2446686 | CT | school | 902820 | 950011 | New London School District | 90282001919 | 951411 | New London Visual and Performing Arts Magnet School | Public Schools | Regular School | No | Middle | 06 | 09 | 2019 | grade_9 | 25 | 25 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446692 | 2446692 | CT | school | 902850 | 960011 | New Milford School District | 90285000603 | 965211 | Schaghticoke Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446699 | 2446699 | CT | school | 902880 | 940011 | Newington School District | 90288001120 | 945311 | John Wallace Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446700 | 2446700 | CT | school | 902880 | 940011 | Newington School District | 90288000608 | 945111 | Martin Kellogg Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446707 | 2446707 | CT | school | 902910 | 970011 | Newtown School District | 90291001487 | 970511 | Reed Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446708 | 2446708 | CT | school | 902910 | 970011 | Newtown School District | 90291000616 | 975111 | Newtown Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446714 | 2446714 | CT | school | 902970 | 990011 | North Branford School District | 90297000622 | 995111 | North Branford Intermediate School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446722 | 2446722 | CT | school | 903030 | 1010011 | North Haven School District | 90303000632 | 1015211 | North Haven Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446740 | 2446740 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000653 | 1035211 | Nathan Hale Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446741 | 2446741 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000656 | 1035311 | Ponus Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446742 | 2446742 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000657 | 1035511 | Roton Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446743 | 2446743 | CT | school | 903090 | 1030011 | Norwalk School District | 90309000661 | 1035411 | West Rocks Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446761 | 2446761 | CT | school | 903120 | 1040011 | Norwich School District | 90312000670 | 1045111 | Kelly STEAM Magnet Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446763 | 2446763 | CT | school | 903120 | 1040011 | Norwich School District | 90312000674 | 1045211 | Teachers' Memorial Global Studies Magnet Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446767 | 2446767 | CT | school | 903180 | 1060011 | Old Saybrook School District | 90318000007 | 1065211 | Old Saybrook Middle School | Public Schools | Regular School | No | Middle | 04 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446775 | 2446775 | CT | school | 903240 | 1080011 | Oxford School District | 90324000690 | 1085111 | Oxford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446782 | 2446782 | CT | school | 903270 | 1090011 | Plainfield School District | 90327000693 | 1095111 | Plainfield Central School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446787 | 2446787 | CT | school | 903300 | 1100011 | Plainville School District | 90330000048 | 1105211 | Middle School of Plainville | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446792 | 2446792 | CT | school | 903330 | 1110011 | Plymouth School District | 90333000705 | 1115111 | Eli Terry Jr. Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446797 | 2446797 | CT | school | 903390 | 1130011 | Portland School District | 90339001393 | 1130511 | Brownstone Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446798 | 2446798 | CT | school | 903390 | 1130011 | Portland School District | 90339000713 | 1135111 | Portland Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446801 | 2446801 | CT | school | 903420 | 1140011 | Preston School District | 90342000717 | 1145111 | Preston Plains School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446803 | 2446803 | CT | school | 903480 | 1160011 | Putnam School District | 90348000720 | 1165111 | Putnam Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446807 | 2446807 | CT | school | 903510 | 1170011 | Redding School District | 90351000721 | 1175111 | John Read Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446818 | 2446818 | CT | school | 903520 | 2100012 | Regional School District 10 | 90352000727 | 2105112 | Har-Bur Middle School | Regional Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446827 | 2446827 | CT | school | 903535 | 2130012 | Regional School District 13 | 90353500742 | 2130412 | Middlefield Memorial School | Regional Schools | Regular School | No | Middle | 04 | 06 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446828 | 2446828 | CT | school | 903535 | 2130012 | Regional School District 13 | 90353500739 | 2135112 | Frank Ward Strong School | Regional Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446833 | 2446833 | CT | school | 903536 | 2140012 | Regional School District 14 | 90353600746 | 2145112 | Woodbury Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446840 | 2446840 | CT | school | 903537 | 2150012 | Regional School District 15 | 90353700748 | 2155212 | Memorial Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446841 | 2446841 | CT | school | 903537 | 2150012 | Regional School District 15 | 90353700751 | 2155112 | Rochambeau Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446846 | 2446846 | CT | school | 903538 | 2160012 | Regional School District 16 | 90353800756 | 2165112 | Long River Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446852 | 2446852 | CT | school | 903539 | 2170012 | Regional School District 17 | 90353901201 | 2175112 | Haddam-Killingworth Middle School | Regional Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446858 | 2446858 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354001123 | 2185112 | Lyme-Old Lyme Middle School | Regional Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446871 | 2446871 | CT | school | 903810 | 1180011 | Ridgefield School District | 90381000776 | 1185111 | East Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446872 | 2446872 | CT | school | 903810 | 1180011 | Ridgefield School District | 90381001361 | 1185211 | Scotts Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446879 | 2446879 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000782 | 1195111 | Albert D. Griswold Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446887 | 2446887 | CT | school | 903990 | 1240011 | Seymour School District | 90399000794 | 1245111 | Seymour Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446899 | 2446899 | CT | school | 904050 | 1260011 | Shelton School District | 90405001584 | 1261111 | Perry Hill Elementary School | Public Schools | Regular School | No | Middle | 05 | 06 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446900 | 2446900 | CT | school | 904050 | 1260011 | Shelton School District | 90405000801 | 1265111 | Intermediate School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2446910 | 2446910 | CT | school | 904110 | 1280011 | Simsbury School District | 90411000811 | 1285111 | Henry James Memorial School | Public Schools | Regular School | No | Middle | 07 | 08 | 2019 | grade_9 | 0 | 0 |
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]);