enrollments
Data source: Big Local News · About: Big Local
1,461 rows where grade = "grade_2", state = "CT" and year = 2020 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2763049 | 2763049 | CT | school | 900219 | 2940013 | Great Oaks Charter School District | 90021901782 | 2940113 | Great Oaks Charter School | Public Charter Schools | Regular School | Yes | Secondary | 06 | 11 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761697 | 2761697 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001565 | 110811 | Wintonbury Early Childhood Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761719 | 2761719 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000085 | 154411 | A.B. Skane Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761758 | 2761758 | CT | school | 900510 | 170011 | Bristol School District | 90051001774 | 170411 | Bristol Early Childhood Center-BECC | Public Schools | Special Education School | No | Prekindergarten | PK | PK | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761872 | 2761872 | CT | school | 901020 | 340011 | Danbury School District | 90102001634 | 340111 | DPS Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761899 | 2761899 | CT | school | 901110 | 370011 | Derby School District | 90111001806 | 370111 | Little Raiders University | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762109 | 2762109 | CT | school | 901920 | 640011 | Hartford School District | 90192001643 | 641311 | Hartford PreKindergarten Magnet School | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762478 | 2762478 | CT | school | 903090 | 1030011 | Norwalk School District | 90309001914 | 1030111 | Norwalk Early Childhood Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762497 | 2762497 | CT | school | 903120 | 1040011 | Norwich School District | 90312000663 | 1040111 | Bishop School Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762602 | 2762602 | CT | school | 903540 | 2180012 | Regional School District 18 | 90354000761 | 2180312 | Center School | Regional Schools | Special Education School | No | Prekindergarten | PK | PK | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762677 | 2762677 | 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 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762104 | 2762104 | CT | school | 901920 | 640011 | Hartford School District | 90192001435 | 646911 | Capital Preparatory Magnet School | Public Schools | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 39 | 39 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762111 | 2762111 | CT | school | 901920 | 640011 | Hartford School District | 90192000370 | 641111 | Kinsella Magnet School of Performing Arts | Public Schools | Regular School | No | Other | PK | 12 | 2020 | grade_2 | 43 | 43 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762130 | 2762130 | CT | school | 901920 | 640011 | Hartford School District | 90192001535 | 643611 | Global Communications Academy | Public Schools | Regular School | No | Other | KG | 12 | 2020 | grade_2 | 57 | 57 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762167 | 2762167 | CT | school | 900207 | 2860013 | Highville Charter School District | 90020700907 | 2860113 | Highville Charter School | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2020 | grade_2 | 35 | 35 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762169 | 2762169 | CT | school | 900007 | 2610013 | Jumoke Academy District | 90000700747 | 2610113 | Jumoke Academy | Public Charter Schools | Regular School | Yes | Other | PK | 12 | 2020 | grade_2 | 67 | 67 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2763028 | 2763028 | CT | school | 900208 | 2850013 | Achievement First Bridgeport Academy District | 90020801493 | 2850113 | Achievement First Bridgeport Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | grade_2 | 95 | 95 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2763029 | 2763029 | CT | school | 900212 | 2880013 | Achievement First Hartford Academy District | 90021201528 | 2880113 | Achievement First Hartford Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | grade_2 | 89 | 89 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2763030 | 2763030 | CT | school | 900024 | 2790013 | Amistad Academy District | 90002400981 | 2795113 | Amistad Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | grade_2 | 96 | 96 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2763033 | 2763033 | 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 | grade_2 | 72 | 72 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2763044 | 2763044 | CT | school | 900214 | 2890013 | Elm City College Preparatory School District | 90021401548 | 2890113 | Elm City College Preparatory School | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | grade_2 | 67 | 67 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761658 | 2761658 | CT | school | 900060 | 20011 | Ansonia School District | 90006010008 | 25111 | Ansonia Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761668 | 2761668 | 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 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761677 | 2761677 | CT | school | 900120 | 40011 | Avon School District | 90012001367 | 40511 | Thompson Brook School | Public Schools | Regular School | No | Middle | 05 | 06 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761678 | 2761678 | CT | school | 900120 | 40011 | Avon School District | 90012000012 | 45111 | Avon Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761686 | 2761686 | CT | school | 900210 | 70011 | Berlin School District | 90021000017 | 75111 | Catherine M. McGee Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761693 | 2761693 | CT | school | 900270 | 90011 | Bethel School District | 90027000025 | 95111 | Bethel Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761701 | 2761701 | CT | school | 900330 | 110011 | Bloomfield School District | 90033001375 | 110711 | Carmen Arace Intermediate School | Public Schools | Regular School | No | Middle | 05 | 06 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761703 | 2761703 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000034 | 115211 | Carmen Arace Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761714 | 2761714 | CT | school | 900420 | 140011 | Branford School District | 90042000041 | 145111 | Francis Walsh Intermediate School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761779 | 2761779 | CT | school | 900510 | 170011 | Bristol School District | 90051000089 | 175111 | Chippens Hill Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761787 | 2761787 | CT | school | 900510 | 170011 | Bristol School District | 90051000104 | 175211 | Northeast Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761795 | 2761795 | CT | school | 900540 | 180011 | Brookfield School District | 90054000112 | 185311 | Whisconier Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761798 | 2761798 | CT | school | 900570 | 190011 | Brooklyn School District | 90057000114 | 195111 | Brooklyn Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761800 | 2761800 | CT | school | 900660 | 220011 | Canterbury School District | 90066001187 | 225111 | Dr. Helen Baldwin Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761802 | 2761802 | CT | school | 900690 | 230011 | Canton School District | 90069000119 | 230311 | Canton Intermediate School | Public Schools | Regular School | No | Middle | 04 | 06 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761803 | 2761803 | CT | school | 900690 | 230011 | Canton School District | 90069001376 | 235111 | Canton Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761822 | 2761822 | 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 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761824 | 2761824 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001364 | 2415014 | Two Rivers Magnet Middle School | Regional Education Service Center Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761839 | 2761839 | CT | school | 900750 | 250011 | Cheshire School District | 90075000125 | 255111 | Dodd Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761845 | 2761845 | CT | school | 900810 | 270011 | Clinton School District | 90081000133 | 275111 | Jared Eliot School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761849 | 2761849 | CT | school | 900840 | 280011 | Colchester School District | 90084000136 | 285111 | William J. Johnston Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761865 | 2761865 | CT | school | 900960 | 320011 | Coventry School District | 90096000141 | 325111 | Capt. Nathan Hale School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761870 | 2761870 | CT | school | 900990 | 330011 | Cromwell School District | 90099000147 | 335111 | Cromwell Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761886 | 2761886 | CT | school | 901020 | 340011 | Danbury School District | 90102000149 | 345111 | Broadview Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761887 | 2761887 | CT | school | 901020 | 340011 | Danbury School District | 90102000160 | 345211 | Rogers Park Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761888 | 2761888 | CT | school | 901020 | 340011 | Danbury School District | 90102001691 | 340311 | Westside Middle School Academy | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761897 | 2761897 | CT | school | 901050 | 350011 | Darien School District | 90105000169 | 355111 | Middlesex Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761902 | 2761902 | CT | school | 901110 | 370011 | Derby School District | 90111001578 | 375011 | Derby Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761908 | 2761908 | CT | school | 901170 | 400011 | East Granby School District | 90117000182 | 405111 | East Granby Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761911 | 2761911 | CT | school | 901200 | 410011 | East Haddam School District | 90120000198 | 415111 | Nathan Hale-Ray Middle School | Public Schools | Regular School | No | Middle | 04 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761915 | 2761915 | CT | school | 901230 | 420011 | East Hampton School District | 90123000188 | 425111 | East Hampton Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761928 | 2761928 | CT | school | 901260 | 430011 | East Hartford School District | 90126000197 | 435111 | East Hartford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761929 | 2761929 | CT | school | 901260 | 430011 | East Hartford School District | 90126001275 | 432411 | Sunset Ridge Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761939 | 2761939 | CT | school | 901290 | 440011 | East Haven School District | 90129000217 | 445111 | Joseph Melillo Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761945 | 2761945 | CT | school | 901320 | 450011 | East Lyme School District | 90132000224 | 455111 | East Lyme Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761950 | 2761950 | CT | school | 901350 | 470011 | East Windsor School District | 90135000230 | 475411 | East Windsor Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761955 | 2761955 | CT | school | 901410 | 460011 | Easton School District | 90141000233 | 465111 | Helen Keller Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761965 | 2761965 | CT | school | 901440 | 480011 | Ellington School District | 90144000238 | 485111 | Ellington Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2761987 | 2761987 | CT | school | 901470 | 490011 | Enfield School District | 90147000249 | 495211 | John F. Kennedy Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762006 | 2762006 | CT | school | 901530 | 510011 | Fairfield School District | 90153000258 | 515211 | Fairfield Woods Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762007 | 2762007 | CT | school | 901530 | 510011 | Fairfield School District | 90153000919 | 515311 | Roger Ludlowe Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762008 | 2762008 | CT | school | 901530 | 510011 | Fairfield School District | 90153000271 | 515111 | Tomlinson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762018 | 2762018 | CT | school | 901560 | 520011 | Farmington School District | 90156001368 | 520511 | West Woods Upper Elementary School | Public Schools | Regular School | No | Middle | 04 | 06 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762019 | 2762019 | CT | school | 901560 | 520011 | Farmington School District | 90156000274 | 525111 | Irving A. Robbins Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762030 | 2762030 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000279 | 540811 | Gideon Welles School | Public Schools | Regular School | No | Middle | 06 | 06 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762031 | 2762031 | CT | school | 901620 | 540011 | Glastonbury School District | 90162000282 | 545211 | Smith Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762036 | 2762036 | CT | school | 901680 | 560011 | Granby School District | 90168000291 | 565111 | Granby Memorial Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762049 | 2762049 | CT | school | 901710 | 570011 | Greenwich School District | 90171000295 | 575111 | Central Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762050 | 2762050 | CT | school | 901710 | 570011 | Greenwich School District | 90171000298 | 575211 | Eastern Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762051 | 2762051 | CT | school | 901710 | 570011 | Greenwich School District | 90171000309 | 575311 | Western Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762056 | 2762056 | CT | school | 901740 | 580011 | Griswold School District | 90174000019 | 585111 | Griswold Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762065 | 2762065 | CT | school | 901770 | 590011 | Groton School District | 90177000312 | 595311 | Carl C. Cutler Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2762066 | 2762066 | CT | school | 901770 | 590011 | Groton School District | 90177000326 | 595211 | West Side Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2762075 | 2762075 | CT | school | 901800 | 600011 | Guilford School District | 90180000328 | 600711 | A. Baldwin Middle School | Public Schools | Regular School | No | Middle | 05 | 06 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762076 | 2762076 | CT | school | 901800 | 600011 | Guilford School District | 90180000331 | 605111 | E. C. Adams Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762095 | 2762095 | CT | school | 901860 | 620011 | Hamden School District | 90186000342 | 625211 | Hamden Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762141 | 2762141 | CT | school | 901920 | 640011 | Hartford School District | 90192001582 | 644011 | Renzulli Gifted and Talented Academy | Public Schools | Regular School | No | Middle | 04 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762142 | 2762142 | CT | school | 901920 | 640011 | Hartford School District | 90192001616 | 643811 | Betances STEM Magnet School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762146 | 2762146 | CT | school | 901920 | 640011 | Hartford School District | 90192000369 | 641611 | M. L. King, Jr. Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762147 | 2762147 | CT | school | 901920 | 640011 | Hartford School District | 90192000371 | 641211 | McDonough Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762148 | 2762148 | CT | school | 901920 | 640011 | Hartford School District | 90192000381 | 641911 | Milner Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762174 | 2762174 | CT | school | 902070 | 690011 | Killingly School District | 90207000393 | 695211 | Killingly Intermediate School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762182 | 2762182 | CT | school | 903450 | 2450014 | Learn | 90345001556 | 2455014 | Dual Language & Arts Magnet Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2762191 | 2762191 | CT | school | 902130 | 710011 | Lebanon School District | 90213000028 | 715111 | Lebanon Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762196 | 2762196 | CT | school | 902160 | 720011 | Ledyard School District | 90216000402 | 725111 | Ledyard Middle School | Public Schools | Regular School | No | Middle | 06 | 10 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762201 | 2762201 | CT | school | 902220 | 740011 | Litchfield School District | 90222000407 | 740311 | Litchfield Intermediate School | Public Schools | Regular School | No | Middle | 04 | 06 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762202 | 2762202 | CT | school | 902220 | 740011 | Litchfield School District | 90222001809 | 746011 | Litchfield Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762208 | 2762208 | CT | school | 902280 | 760011 | Madison School District | 90228001480 | 765211 | Walter C. Polson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762219 | 2762219 | CT | school | 902310 | 770011 | Manchester School District | 90231001533 | 771711 | Elisabeth M. Bennet Academy | Public Schools | Regular School | No | Middle | 05 | 06 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762221 | 2762221 | CT | school | 902310 | 770011 | Manchester School District | 90231000421 | 775311 | Illing Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762230 | 2762230 | CT | school | 902340 | 780011 | Mansfield School District | 90234000433 | 785111 | Mansfield Middle School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762244 | 2762244 | CT | school | 902400 | 800011 | Meriden School District | 90240000447 | 805211 | Lincoln Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762249 | 2762249 | CT | school | 902400 | 800011 | Meriden School District | 90240001194 | 805411 | Washington Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762275 | 2762275 | CT | school | 902490 | 830011 | Middletown School District | 90249000456 | 831511 | Keigwin Middle School | Public Schools | Regular School | No | Middle | 06 | 06 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762276 | 2762276 | CT | school | 902490 | 830011 | Middletown School District | 90249000459 | 835411 | Woodrow Wilson Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762292 | 2762292 | CT | school | 902520 | 840011 | Milford School District | 90252000484 | 845111 | East Shore Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762293 | 2762293 | CT | school | 902520 | 840011 | Milford School District | 90252000468 | 845211 | Harborside Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762294 | 2762294 | CT | school | 902520 | 840011 | Milford School District | 90252000474 | 845311 | West Shore Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2762303 | 2762303 | CT | school | 902550 | 850011 | Monroe School District | 90255000920 | 855211 | Jockey Hollow School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_2 | 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]);