enrollments
Data source: Big Local News · About: Big Local
1,461 rows where grade = "grade_7", state = "CT" and year = 2020 sorted by school
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2769194 | 2769194 | CT | school | 340011 | Danbury School District | 90102001129 | 346211 | Alternative Center For Excellence | Program | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769209 | 2769209 | CT | school | 370011 | Derby School District | 370211 | Alternative Education Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769978 | 2769978 | CT | school | 904170 | 1320011 | South Windsor School District | 90417000826 | 1320311 | Alternative Education Program | Program | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770240 | 2770240 | CT | school | 1550011 | West Hartford School District | 1550111 | Alternative Educational Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769928 | 2769928 | CT | school | 1180011 | Ridgefield School District | 90381001763 | 1188011 | Alternative High School | Program | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769668 | 2769668 | CT | school | 910011 | New Fairfield School District | 90273001687 | 910311 | Alternative Learning Center | Program | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769951 | 2769951 | CT | school | 1260011 | Shelton School District | 1260211 | Alternative Learning Center 1 | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769952 | 2769952 | CT | school | 1260011 | Shelton School District | 1261311 | Alternative Learning Center 2 | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770409 | 2770409 | CT | school | 905371 | 9010022 | Norwich Free Academy District | 90537101221 | 9010322 | Alternative Pathways to Success | Program | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769912 | 2769912 | CT | school | 2180012 | Regional School District 18 | 2180412 | Alternative Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769080 | 2769080 | CT | school | 170011 | Bristol School District | 90051001429 | 179011 | Alternative Special Education Program (ASEP) | Program | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770335 | 2770335 | CT | school | 900024 | 2790013 | Amistad Academy District | 90002400981 | 2795113 | Amistad Academy | Public Charter Schools | Regular School | Yes | Other | KG | 12 | 2020 | grade_7 | 91 | 91 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770361 | 2770361 | CT | school | 903660 | 2050012 | Regional School District 05 | 90366001114 | 2055112 | Amity Middle School: Bethany | Regional Schools | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 174 | 174 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770362 | 2770362 | CT | school | 903660 | 2050012 | Regional School District 05 | 90366000769 | 2055212 | Amity Middle School: Orange | Regional Schools | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 177 | 177 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770363 | 2770363 | CT | school | 903660 | 2050012 | Regional School District 05 | 90366000770 | 2056112 | Amity Regional High School | Regional Schools | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770364 | 2770364 | CT | school | 2050012 | Regional School District 05 | 2050112 | Amity Transition Academy | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769112 | 2769112 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001623 | 2410614 | Ana Grace Academy of the Arts Elementary School | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 05 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770026 | 2770026 | CT | school | 1350011 | Stamford School District | 90432001744 | 1350411 | Anchor | Program | 2020 | grade_7 | 6 | 6 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2768959 | 2768959 | CT | school | 900030 | 10011 | Andover School District | 90003010001 | 10111 | Andover Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769621 | 2769621 | CT | school | 902640 | 880011 | Naugatuck School District | 90264000499 | 880811 | Andrew Avenue School | Public Schools | Regular School | No | Elementary | KG | 04 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769671 | 2769671 | CT | school | 902760 | 920011 | New Hartford School District | 90276000538 | 920311 | Ann Antolini School | Public Schools | Regular School | No | Elementary | 03 | 06 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769224 | 2769224 | CT | school | 901260 | 430011 | East Hartford School District | 90126000191 | 430911 | Anna E. Norris School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2768996 | 2768996 | CT | school | 900270 | 90011 | Bethel School District | 90027000023 | 90411 | Anna H. Rockwell School | Public Schools | Regular School | No | Elementary | KG | 03 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769746 | 2769746 | CT | school | 902880 | 940011 | Newington School District | 90288000611 | 940611 | Anna Reynolds School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769532 | 2769532 | CT | school | 902340 | 780011 | Mansfield School District | 90234000432 | 780411 | Annie E. Vinton School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2768967 | 2768967 | CT | school | 20011 | Ansonia School District | 21011 | Ansonia 18-21 Transition Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2768964 | 2768964 | CT | school | 900060 | 20011 | Ansonia School District | 90006010002 | 26111 | Ansonia High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2768963 | 2768963 | CT | school | 900060 | 20011 | Ansonia School District | 90006010008 | 25111 | Ansonia Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 185 | 185 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2768960 | 2768960 | CT | school | 20011 | Ansonia School District | 20911 | Ansonia Public Schools Pre-K Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769373 | 2769373 | CT | school | 590011 | Groton School District | 590611 | Apex Academy | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770010 | 2770010 | CT | school | 1350011 | Stamford School District | 90432001703 | 1350111 | Apples PreK | Program | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770344 | 2770344 | CT | school | 901360 | 2530014 | Eastern Connecticut Regional Educational Service Center (EASTCONN) | 90136001507 | 2536014 | Arts at the Capitol Theater Magnet School (ACT) | Regional Education Service Center Schools | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2768978 | 2768978 | CT | school | 900090 | 30011 | Ashford School District | 90009000010 | 30111 | Ashford School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 32 | 32 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770306 | 2770306 | CT | school | 1630011 | Windham School District | 1631211 | Assisted Work Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770307 | 2770307 | CT | school | 1630011 | Windham School District | 1631411 | Assisted Work Program at WHS | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769672 | 2769672 | CT | school | 902790 | 930011 | New Haven School District | 90279000580 | 931511 | Augusta Lewis Troup School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 50 | 50 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770204 | 2770204 | CT | school | 1520011 | Waterford School District | 1521111 | Autism Class | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770210 | 2770210 | CT | school | 1520011 | Waterford School District | 1520311 | Avery Point Transition Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2768979 | 2768979 | CT | school | 40011 | Avon School District | 90012001737 | 40111 | Avon Early Learning Center at Roaring Brook School | Program | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2768984 | 2768984 | CT | school | 900120 | 40011 | Avon School District | 90012000011 | 46111 | Avon High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2768983 | 2768983 | CT | school | 900120 | 40011 | Avon School District | 90012000012 | 45111 | Avon Middle School | Public Schools | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 276 | 276 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770143 | 2770143 | CT | school | 904830 | 1510011 | Waterbury School District | 90483000966 | 1512111 | B. W. Tinker School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770175 | 2770175 | CT | school | 1510011 | Waterbury School District | 1510411 | B.W. Tinker BDLC | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769062 | 2769062 | CT | school | 170011 | Bristol School District | 90051001728 | 172911 | BECC Autism | Program | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770062 | 2770062 | CT | school | 1380011 | Stratford School District | 1380111 | BRIDGES 9-12 | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769155 | 2769155 | CT | school | 900840 | 280011 | Colchester School District | 90084000135 | 286111 | Bacon Academy | Public Schools | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769156 | 2769156 | CT | school | 280011 | Colchester School District | 280511 | Bacon Academy Alternative Education | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769670 | 2769670 | CT | school | 902760 | 920011 | New Hartford School District | 90276000539 | 920111 | Bakerville Consolidated School | Public Schools | Regular School | No | Elementary | KG | 02 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769699 | 2769699 | CT | school | 902790 | 930011 | New Haven School District | 90279001509 | 932811 | Barack H. Obama Magnet University School | Public Schools | Regular School | No | Elementary | KG | 04 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769700 | 2769700 | CT | school | 930011 | New Haven School District | 937611 | Barack H. Obama Self Contained Autism | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2768985 | 2768985 | CT | school | 900150 | 50011 | Barkhamsted School District | 90015000015 | 50111 | Barkhamsted Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769913 | 2769913 | CT | school | 903810 | 1180011 | Ridgefield School District | 90381001467 | 1180811 | Barlow Mountain Elementary School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769673 | 2769673 | CT | school | 902790 | 930011 | New Haven School District | 90279000542 | 930211 | Barnard Environmental Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 54 | 54 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769025 | 2769025 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000049 | 150111 | Barnum School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 45 | 45 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769055 | 2769055 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000050 | 156111 | Bassick High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770292 | 2770292 | CT | school | 905160 | 1620011 | Winchester School District | 90516001077 | 1620411 | Batcheller Early Education Center | Public Schools | Regular School | No | Elementary | PK | 02 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769399 | 2769399 | CT | school | 620011 | Hamden School District | 620911 | Bear Path IIC | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769388 | 2769388 | CT | school | 901860 | 620011 | Hamden School District | 90186000336 | 621211 | Bear Path School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769026 | 2769026 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000051 | 150211 | Beardsley School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770272 | 2770272 | CT | school | 905040 | 1580011 | Westport School District | 90504001048 | 1585111 | Bedford Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 411 | 411 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770330 | 2770330 | CT | school | 905310 | 1670011 | Woodbridge School District | 90531001611 | 1670311 | Beecher Road School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769674 | 2769674 | CT | school | 902790 | 930011 | New Haven School District | 90279000543 | 930311 | Beecher School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 49 | 49 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770134 | 2770134 | CT | school | 1480011 | Wallingford School District | 1481511 | Ben Haven ABC Middle School Program | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770125 | 2770125 | CT | school | 1480011 | Wallingford School District | 1481411 | Ben Haven ABC Primary Program | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770126 | 2770126 | CT | school | 1480011 | Wallingford School District | 1480611 | Benhaven ABC Intermediate Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769537 | 2769537 | CT | school | 902400 | 800011 | Meriden School District | 90240000439 | 800111 | Benjamin Franklin School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769675 | 2769675 | CT | school | 930011 | New Haven School District | 933411 | Benjamin Jepson Head Start | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769676 | 2769676 | CT | school | 902790 | 930011 | New Haven School District | 90279000544 | 931811 | Benjamin Jepson Magnet School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 51 | 51 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769736 | 2769736 | CT | school | 902820 | 950011 | New London School District | 90282000596 | 955111 | Bennie Dover Jackson Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 86 | 86 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2768992 | 2768992 | CT | school | 900210 | 70011 | Berlin School District | 90021000016 | 76111 | Berlin High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769405 | 2769405 | CT | school | 901920 | 640011 | Hartford School District | 90192001192 | 642811 | Betances Learning Lab Magnet School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769447 | 2769447 | CT | school | 901920 | 640011 | Hartford School District | 90192001616 | 643811 | Betances STEM Magnet School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 72 | 72 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2768994 | 2768994 | CT | school | 900240 | 80011 | Bethany School District | 90024000022 | 80111 | Bethany Community School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2768999 | 2768999 | CT | school | 900270 | 90011 | Bethel School District | 90027000024 | 96111 | Bethel High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2768998 | 2768998 | CT | school | 900270 | 90011 | Bethel School District | 90027000025 | 95111 | Bethel Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 283 | 283 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769883 | 2769883 | CT | school | 903536 | 2140012 | Regional School District 14 | 90353600743 | 2140112 | Bethlehem Elementary School | Regional Schools | Regular School | No | Elementary | PK | 05 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769716 | 2769716 | CT | school | 902790 | 930011 | New Haven School District | 90279000545 | 935511 | Betsy Ross Arts Magnet School | Public Schools | Regular School | No | Middle | 05 | 08 | 2020 | grade_7 | 120 | 120 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769568 | 2769568 | CT | school | 902490 | 830011 | Middletown School District | 90249000453 | 830211 | Bielefield School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769056 | 2769056 | CT | school | 900450 | 150011 | Bridgeport School District | 90045001636 | 150611 | Biotechnology, Research & Zoological Studies Magnet High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770079 | 2770079 | CT | school | 904560 | 1420011 | Tolland School District | 90456000948 | 1420111 | Birch Grove Primary School | Public Schools | Regular School | No | Elementary | PK | 02 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769802 | 2769802 | CT | school | 903120 | 1040011 | Norwich School District | 90312000663 | 1040111 | Bishop School Early Learning Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769701 | 2769701 | CT | school | 902790 | 930011 | New Haven School District | 90279000546 | 934311 | Bishop Woods Architecture and Design Magnet School | Public Schools | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 52 | 52 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769702 | 2769702 | CT | school | 930011 | New Haven School District | 937911 | Bishop Woods Self Contained Autism | Program | 2020 | grade_7 | * | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769027 | 2769027 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000052 | 150311 | Black Rock School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 52 | 52 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770072 | 2770072 | CT | school | 904500 | 1400011 | Thomaston School District | 90450000906 | 1400111 | Black Rock School | Public Schools | Regular School | No | Elementary | PK | 03 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769028 | 2769028 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000053 | 154011 | Blackham School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 142 | 142 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770252 | 2770252 | CT | school | 1560011 | West Haven School District | 1560711 | Blended | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770253 | 2770253 | CT | school | 1560011 | West Haven School District | 1560511 | Blended (Molloy) | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769009 | 2769009 | CT | school | 900330 | 110011 | Bloomfield School District | 90033000029 | 116111 | Bloomfield High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769011 | 2769011 | CT | school | 900360 | 120011 | Bolton School District | 90036000036 | 120111 | Bolton Center School | Public Schools | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 61 | 61 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769012 | 2769012 | CT | school | 900360 | 120011 | Bolton School District | 90036000037 | 126111 | Bolton High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769013 | 2769013 | CT | school | 120011 | Bolton School District | 120211 | Bolton Transition Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770336 | 2770336 | CT | school | 900217 | 2950013 | Booker T. Washington Academy District | 90021701750 | 2950113 | Booker T. Washington Academy | Public Charter Schools | Regular School | Yes | Elementary | KG | 06 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769873 | 2769873 | CT | school | 903530 | 2120012 | Regional School District 12 | 90353000731 | 2120212 | Booth Free School | Regional Schools | Regular School | No | Elementary | KG | 05 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769946 | 2769946 | CT | school | 904050 | 1260011 | Shelton School District | 90405000796 | 1261011 | Booth Hill School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770094 | 2770094 | CT | school | 904620 | 1440011 | Trumbull School District | 90462000927 | 1440111 | Booth Hill School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769762 | 2769762 | CT | school | 902940 | 980011 | Norfolk School District | 90294000618 | 980111 | Botelle Elementary School | Public Schools | Regular School | No | Elementary | PK | 06 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769519 | 2769519 | CT | school | 902310 | 770011 | Manchester School District | 90231000417 | 770111 | Bowers School | Public Schools | Regular School | No | Elementary | KG | 04 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769205 | 2769205 | CT | school | 901110 | 370011 | Derby School District | 90111000174 | 370611 | Bradley School | Public Schools | Regular School | No | Elementary | KG | 05 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770222 | 2770222 | CT | school | 1550011 | West Hartford School District | 90492001705 | 1559311 | Braeburn Learning Center | Program | 2020 | grade_7 | 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]);