schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 101 rows (hide)

select 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 from enrollments where "grade" = :p0 and "state" = :p1 and "year" = :p2 and (school > :p4 or (school = :p4 and rowid > :p3)) order by school, rowid limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_nces_id	district_state_id	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	grade	total	total_int
2771136	CT	school		930011	New Haven School District		933411	Benjamin Jepson Head Start	Program						2020	grade_8	0	0
2771137	CT	school	902790	930011	New Haven School District	90279000544	931811	Benjamin Jepson Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_8	52	52
2771197	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_8	90	90
2770453	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770866	CT	school	901920	640011	Hartford School District	90192001192	642811	Betances Learning Lab Magnet School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_8	0	0
2770908	CT	school	901920	640011	Hartford School District	90192001616	643811	Betances STEM Magnet School	Public Schools	Regular School	No	Middle	05	08	2020	grade_8	70	70
2770455	CT	school	900240	80011	Bethany School District	90024000022	80111	Bethany Community School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_8	0	0
2770460	CT	school	900270	90011	Bethel School District	90027000024	96111	Bethel High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770459	CT	school	900270	90011	Bethel School District	90027000025	95111	Bethel Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_8	254	254
2771344	CT	school	903536	2140012	Regional School District 14	90353600743	2140112	Bethlehem Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
2771177	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_8	123	123
2771029	CT	school	902490	830011	Middletown School District	90249000453	830211	Bielefield School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_8	0	0
2770517	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_8	0	0
2771540	CT	school	904560	1420011	Tolland School District	90456000948	1420111	Birch Grove Primary School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_8	0	0
2771263	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0	0
2771162	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_8	53	53
2771163	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2020	grade_8	0	0
2770488	CT	school	900450	150011	Bridgeport School District	90045000052	150311	Black Rock School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_8	51	51
2771533	CT	school	904500	1400011	Thomaston School District	90450000906	1400111	Black Rock School	Public Schools	Regular School	No	Elementary	PK	03	2020	grade_8	0	0
2770489	CT	school	900450	150011	Bridgeport School District	90045000053	154011	Blackham School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_8	166	166
2771713	CT	school		1560011	West Haven School District		1560711	Blended	Program						2020	grade_8	0	0
2771714	CT	school		1560011	West Haven School District		1560511	Blended (Molloy)	Program						2020	grade_8	0	0
2770470	CT	school	900330	110011	Bloomfield School District	90033000029	116111	Bloomfield High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770472	CT	school	900360	120011	Bolton School District	90036000036	120111	Bolton Center School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_8	61	61
2770473	CT	school	900360	120011	Bolton School District	90036000037	126111	Bolton High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770474	CT	school		120011	Bolton School District		120211	Bolton Transition Program	Program						2020	grade_8	0	0
2771797	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_8	0	0
2771334	CT	school	903530	2120012	Regional School District 12	90353000731	2120212	Booth Free School	Regional Schools	Regular School	No	Elementary	KG	05	2020	grade_8	0	0
2771407	CT	school	904050	1260011	Shelton School District	90405000796	1261011	Booth Hill School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_8	0	0
2771555	CT	school	904620	1440011	Trumbull School District	90462000927	1440111	Booth Hill School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_8	0	0
2771223	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_8	0	0
2770980	CT	school	902310	770011	Manchester School District	90231000417	770111	Bowers School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_8	0	0
2770666	CT	school	901110	370011	Derby School District	90111000174	370611	Bradley School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_8	0	0
2771683	CT	school		1550011	West Hartford School District	90492001705	1559311	Braeburn Learning Center	Program						2020	grade_8	0	0
2771684	CT	school	904920	1550011	West Hartford School District	90492001009	1550211	Braeburn School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_8	0	0
2771377	CT	school	903810	1180011	Ridgefield School District	90381000525	1180611	Branchville Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_8	0	0
2770481	CT	school	900420	140011	Branford School District	90042000039	146111	Branford High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770482	CT	school		140011	Branford School District	90042001742	140211	Branford High School Atlas Program	Program						2020	grade_8	0	0
2770484	CT	school	900215	2900013	Brass City Charter School District	90021501644	2900113	Brass City Charter School	Public Charter Schools	Regular School	Yes	Elementary	PK	07	2020	grade_8	0	0
2770867	CT	school	901920	640011	Hartford School District	90192001534	643511	Breakthrough Magnet School, North	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
2770868	CT	school	901920	640011	Hartford School District	90192001369	643311	Breakthrough Magnet School, South	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_8	33	33
2771138	CT	school	902790	930011	New Haven School District	90279001585	932111	Brennan Rogers School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_8	47	47
2771139	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2020	grade_8	*
2771841	CT	school		3360015	Unified School District #1	90000300343	3360115	Bridgeport Correctional Center	State Agency Facilities						2020	grade_8	0	0
2770514	CT	school		150011	Bridgeport School District	90045001472	159011	Bridgeport Learning Center	Program						2020	grade_8	7	7
2770518	CT	school	900450	150011	Bridgeport School District	90045001631	151611	Bridgeport Military Academy	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770448	CT	school		50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program						2020	grade_8	0	0
2771256	CT	school	903090	1030011	Norwalk School District	90309000638	1036211	Brien McMahon High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770554	CT	school	900510	170011	Bristol School District	90051000092	176111	Bristol Central High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770524	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_8	0	0
2770555	CT	school	900510	170011	Bristol School District	90051000093	176211	Bristol Eastern High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770556	CT	school		170011	Bristol School District	90051001746	173311	Bristol Preparatory Academy	Program						2020	grade_8	0	0
2771694	CT	school	904920	1550011	West Hartford School District	90492001419	1555311	Bristow Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_8	138	138
2770715	CT	school	901350	470011	East Windsor School District	90135000228	470111	Broad Brook Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_8	0	0
2770652	CT	school	901020	340011	Danbury School District	90102000149	345111	Broadview Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_8	326	326
2770562	CT	school	900540	180011	Brookfield School District	90054000109	186111	Brookfield High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770563	CT	school	900570	190011	Brooklyn School District	90057000113	190111	Brooklyn Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_8	0	0
2770564	CT	school	900570	190011	Brooklyn School District	90057000114	195111	Brooklyn Middle School	Public Schools	Regular School	No	Middle	05	08	2020	grade_8	89	89
2771239	CT	school	903090	1030011	Norwalk School District	90309000640	1030211	Brookside Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
2771115	CT	school		890011	New Britain School District	90267001557	899111	Brookside School	Program						2020	grade_8	*
2771313	CT	school	903390	1130011	Portland School District	90339001393	1130511	Brownstone Intermediate School	Public Schools	Regular School	No	Middle	05	06	2020	grade_8	0	0
2770490	CT	school	900450	150011	Bridgeport School District	90045000054	150411	Bryant School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_8	0	0
2770976	CT	school	902310	770011	Manchester School District	90231000418	770311	Buckley School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_8	0	0
2771623	CT	school		1510011	Waterbury School District		1514611	Bucks Hill Autism	Program						2020	grade_8	0	0
2771624	CT	school		1510011	Waterbury School District		1514311	Bucks Hill Bilingual	Program						2020	grade_8	0	0
2771605	CT	school	904830	1510011	Waterbury School District	90483000968	1510511	Bucks Hill School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
2771685	CT	school	904920	1550011	West Hartford School District	90492001011	1550411	Bugbee School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_8	0	0
2770919	CT	school	901920	640011	Hartford School District	90192001572	647111	Bulkeley High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2771852	CT	school	900002	9000016	Connecticut Technical Education and Career System	90000201137	9001116	Bullard-Havens Technical High School	CT Technical Education and Career Schools	Career and Technical School	No	High	09	12	2020	grade_8	0	0
2771402	CT	school	903990	1240011	Seymour School District	90399000790	1240111	Bungay School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_8	0	0
2771639	CT	school		1510011	Waterbury School District		1510111	Bunker Hill BDLC	Program						2020	grade_8	0	0
2771606	CT	school	904830	1510011	Waterbury School District	90483000969	1510611	Bunker Hill School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
2771524	CT	school	904440	1380011	Stratford School District	90444000885	1386211	Bunnell High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770869	CT	school	901920	640011	Hartford School District	90192000357	640611	Burns Latino Studies Academy	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
2771362	CT	school	903539	2170012	Regional School District 17	90353900757	2170212	Burr District Elementary School	Regional Schools	Regular School	No	Elementary	PK	03	2020	grade_8	0	0
2770762	CT	school	901530	510011	Fairfield School District	90153001378	510211	Burr Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_8	0	0
2770895	CT	school	901920	640011	Hartford School District	90192000358	642311	Burr Middle School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_8	74	74
2770790	CT	school	901620	540011	Glastonbury School District	90162000280	540211	Buttonball Lane School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_8	0	0
2771192	CT	school	902820	950011	New London School District	90282000591	950311	C.B. Jennings International Elementary Magnet	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_8	0	0
2771118	CT	school		890011	New Britain School District	90267001609	899411	CLIMB	Program						2020	grade_8	0	0
2770438	CT	school		2440014	Area Cooperative Educational Services		2440114	CREATE at Whitney Academy	Program						2020	grade_8	0	0
2770592	CT	school		2410014	Capitol Region Education Council		2411914	CREC Impact Academy	Program						2020	grade_8	0	0
2771055	CT	school	902520	840011	Milford School District	90252000467	840111	Calf Pen Meadow School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_8	0	0
2770839	CT	school	901800	600011	Guilford School District	90180000330	600411	Calvin Leete School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_8	0	0
2770565	CT	school	900660	220011	Canterbury School District	90066001188	220211	Canterbury Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_8	0	0
2770571	CT	school		230011	Canton School District	90069001695	230411	Canton Academy	Program						2020	grade_8	0	0
2770570	CT	school	900690	230011	Canton School District	90069000118	236111	Canton High School	Public Schools	Regular School	No	High	09	12	2020	grade_8	0	0
2770568	CT	school	900690	230011	Canton School District	90069000119	230311	Canton Intermediate School	Public Schools	Regular School	No	Middle	04	06	2020	grade_8	0	0
2770569	CT	school	900690	230011	Canton School District	90069001376	235111	Canton Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_8	127	127
2771799	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_8	53	53
2770870	CT	school	901920	640011	Hartford School District	90192001435	646911	Capital Preparatory Magnet School	Public Schools	Regular School	No	Other	PK	12	2020	grade_8	42	42
2770631	CT	school	900960	320011	Coventry School District	90096000141	325111	Capt. Nathan Hale School	Public Schools	Regular School	No	Middle	06	08	2020	grade_8	133	133
2770703	CT	school	901290	440011	East Haven School District	90129000605	441711	Carbone School/East Haven Academy	Public Schools	Regular School	No	Elementary	01	08	2020	grade_8	34	34
2770831	CT	school	901770	590011	Groton School District	90177000312	595311	Carl C. Cutler Middle School		Regular School	No	Middle	06	08	2020	grade_8	168	168
2770467	CT	school	900330	110011	Bloomfield School District	90033001375	110711	Carmen Arace Intermediate School	Public Schools	Regular School	No	Middle	05	06	2020	grade_8	0	0
2770469	CT	school	900330	110011	Bloomfield School District	90033000034	115211	Carmen Arace Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_8	112	112
2771711	CT	school	904950	1560011	West Haven School District	90495001037	1565311	Carrigan 5/6 Intermediate School	Public Schools	Regular School	No	Middle	05	06	2020	grade_8	0	0
2771625	CT	school		1510011	Waterbury School District		1511911	Carrington ESC	Program						2020	grade_8	*
2771607	CT	school	904830	1510011	Waterbury School District	90483000970	1512711	Carrington School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_8	55	55
2771264	CT	school		1040011	Norwich School District	90312001745	1040211	Case Street Early Learning Center at DTZ	Program						2020	grade_8	0	0
2771005	CT	school	902400	800011	Meriden School District	90240000440	801111	Casimir Pulaski School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_8	0	0