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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2769380 | 2769380 | CT | school | 901800 | 600011 | Guilford School District | 90180000328 | 600711 | A. Baldwin Middle School | Public Schools | Regular School | No | Middle | 05 | 06 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770390 | 2770390 | CT | school | 900002 | 9000016 | Connecticut Technical Education and Career System | 90000201136 | 9001516 | A. I. Prince Technical High School | CT Technical Education and Career Schools | Career and Technical School | No | High | 09 | 12 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769377 | 2769377 | CT | school | 901800 | 600011 | Guilford School District | 90180000329 | 600611 | A. W. Cox School | Public Schools | Regular School | No | Elementary | KG | 04 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770068 | 2770068 | CT | school | 904470 | 1390011 | Suffield School District | 90447000903 | 1390411 | A. Ward Spaulding School | Public Schools | Regular School | No | Elementary | PK | 02 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769024 | 2769024 | CT | school | 900450 | 150011 | Bridgeport School District | 90045000085 | 154411 | A.B. Skane Center | Public Schools | Regular School | No | Prekindergarten | PK | PK | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770133 | 2770133 | CT | school | 1480011 | Wallingford School District | 1489011 | A.R.T.S. Academy | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770274 | 2770274 | CT | school | 1590011 | Wethersfield School District | 1590411 | ABA | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770047 | 2770047 | CT | school | 1380011 | Stratford School District | 90444001734 | 1380611 | ABA - K-6 | Program | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770324 | 2770324 | CT | school | 1660011 | Wolcott School District | 90528001783 | 1660311 | ABC Classroom | Program | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769096 | 2769096 | CT | school | 170011 | Bristol School District | 170211 | ACCESS | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769265 | 2769265 | CT | school | 2420014 | EdAdvance | 2420414 | ACCESS-South Expelled Student | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2768969 | 2768969 | CT | school | 2440014 | Area Cooperative Educational Services | 2440214 | ACES Mill Elementary School | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2768971 | 2768971 | CT | school | 2440014 | Area Cooperative Educational Services | 2440414 | ACES at Mead Elementary School | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770368 | 2770368 | CT | school | 2070012 | Regional School District 07 | 90372001400 | 2079112 | AIM | Program | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770056 | 2770056 | CT | school | 1380011 | Stratford School District | 1382711 | ALL Class Room - Second Hill Lane | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770061 | 2770061 | CT | school | 1380011 | Stratford School District | 90444001701 | 1380511 | ALPHA | Program | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770249 | 2770249 | CT | school | 1560011 | West Haven School District | 1561111 | ASD Lab | 2020 | grade_7 | * | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769253 | 2769253 | CT | school | 450011 | East Lyme School District | 90132001730 | 450511 | Abilities in Motion (AIM) Program | Program | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769125 | 2769125 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001513 | 2415114 | Academy of Aerospace and Engineering | Regional Education Service Center Schools | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 116 | 116 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769111 | 2769111 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001629 | 2410714 | Academy of Aerospace and Engineering Elementary | Regional Education Service Center Schools | Regular School | No | Elementary | PK | 05 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769126 | 2769126 | CT | school | 900700 | 2410014 | Capitol Region Education Council | 90070001592 | 2416514 | Academy of Science and Innovation | Regional Education Service Center Schools | Regular School | No | High | 06 | 12 | 2020 | grade_7 | 118 | 118 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769022 | 2769022 | CT | school | 140011 | Branford School District | 140311 | Access Transition Program | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769998 | 2769998 | CT | school | 1310011 | Southington School District | 90423001694 | 1311711 | Achieve | Program | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2770333 | 2770333 | 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_7 | 96 | 96 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770334 | 2770334 | 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_7 | 113 | 113 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769054 | 2769054 | CT | school | 900450 | 150011 | Bridgeport School District | 90045001639 | 150811 | Aerospace/Hydrospace, Engineering and Physical Sciences Magnet High School | Public Schools | Regular School | No | High | 09 | 12 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770217 | 2770217 | CT | school | 904920 | 1550011 | West Hartford School District | 90492000004 | 1551611 | Aiken School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769933 | 2769933 | CT | school | 903840 | 1190011 | Rocky Hill School District | 90384000782 | 1195111 | Albert D. Griswold Middle School | Public Schools | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 181 | 181 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770323 | 2770323 | CT | school | 905280 | 1660011 | Wolcott School District | 90528001105 | 1660611 | Alcott School | Public Schools | Regular School | No | Elementary | PK | 05 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770278 | 2770278 | CT | school | 905070 | 1590011 | Wethersfield School District | 90507001059 | 1590811 | Alfred W. Hanmer School | Public Schools | Regular School | No | Elementary | KG | 06 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2769387 | 2769387 | CT | school | 620011 | Hamden School District | 620711 | Alice Peck IIC | Program | 2020 | grade_7 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769383 | 2769383 | CT | school | 620011 | Hamden School District | 90186001433 | 628011 | Alice Peck Learning Center | Program | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2769211 | 2769211 | CT | school | 901170 | 400011 | East Granby School District | 90117000180 | 400111 | Allgrove School | Public Schools | Regular School | No | Elementary | PK | 02 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2770243 | 2770243 | CT | school | 904950 | 1560011 | West Haven School District | 90495001027 | 1560811 | Alma E. Pagels School | Public Schools | Regular School | No | Elementary | PK | 04 | 2020 | grade_7 | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||
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 |
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]);