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
2775519	CT	school		930011	New Haven School District		933411	Benjamin Jepson Head Start	Program						2020	grade_11	0	0
2775520	CT	school	902790	930011	New Haven School District	90279000544	931811	Benjamin Jepson Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_11	0	0
2775580	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_11	0	0
2774836	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	246	246
2775249	CT	school	901920	640011	Hartford School District	90192001192	642811	Betances Learning Lab Magnet School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_11	0	0
2775291	CT	school	901920	640011	Hartford School District	90192001616	643811	Betances STEM Magnet School	Public Schools	Regular School	No	Middle	05	08	2020	grade_11	0	0
2774838	CT	school	900240	80011	Bethany School District	90024000022	80111	Bethany Community School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_11	0	0
2774843	CT	school	900270	90011	Bethel School District	90027000024	96111	Bethel High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	240	240
2774842	CT	school	900270	90011	Bethel School District	90027000025	95111	Bethel Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775727	CT	school	903536	2140012	Regional School District 14	90353600743	2140112	Bethlehem Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775560	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_11	0	0
2775412	CT	school	902490	830011	Middletown School District	90249000453	830211	Bielefield School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2774900	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_11	103	103
2775923	CT	school	904560	1420011	Tolland School District	90456000948	1420111	Birch Grove Primary School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_11	0	0
2775646	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_11	0	0
2775545	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_11	0	0
2775546	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2020	grade_11	0	0
2774871	CT	school	900450	150011	Bridgeport School District	90045000052	150311	Black Rock School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_11	0	0
2775916	CT	school	904500	1400011	Thomaston School District	90450000906	1400111	Black Rock School	Public Schools	Regular School	No	Elementary	PK	03	2020	grade_11	0	0
2774872	CT	school	900450	150011	Bridgeport School District	90045000053	154011	Blackham School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_11	0	0
2776096	CT	school		1560011	West Haven School District		1560711	Blended	Program						2020	grade_11	*
2776097	CT	school		1560011	West Haven School District		1560511	Blended (Molloy)	Program						2020	grade_11	0	0
2774853	CT	school	900330	110011	Bloomfield School District	90033000029	116111	Bloomfield High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	138	138
2774855	CT	school	900360	120011	Bolton School District	90036000036	120111	Bolton Center School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_11	0	0
2774856	CT	school	900360	120011	Bolton School District	90036000037	126111	Bolton High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	61	61
2774857	CT	school		120011	Bolton School District		120211	Bolton Transition Program	Program						2020	grade_11	0	0
2776180	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_11	0	0
2775717	CT	school	903530	2120012	Regional School District 12	90353000731	2120212	Booth Free School	Regional Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775790	CT	school	904050	1260011	Shelton School District	90405000796	1261011	Booth Hill School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_11	0	0
2775938	CT	school	904620	1440011	Trumbull School District	90462000927	1440111	Booth Hill School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775606	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_11	0	0
2775363	CT	school	902310	770011	Manchester School District	90231000417	770111	Bowers School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_11	0	0
2775049	CT	school	901110	370011	Derby School District	90111000174	370611	Bradley School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2776066	CT	school		1550011	West Hartford School District	90492001705	1559311	Braeburn Learning Center	Program						2020	grade_11	0	0
2776067	CT	school	904920	1550011	West Hartford School District	90492001009	1550211	Braeburn School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775760	CT	school	903810	1180011	Ridgefield School District	90381000525	1180611	Branchville Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2774864	CT	school	900420	140011	Branford School District	90042000039	146111	Branford High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	194	194
2774865	CT	school		140011	Branford School District	90042001742	140211	Branford High School Atlas Program	Program						2020	grade_11	*
2774867	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_11	0	0
2775250	CT	school	901920	640011	Hartford School District	90192001534	643511	Breakthrough Magnet School, North	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775251	CT	school	901920	640011	Hartford School District	90192001369	643311	Breakthrough Magnet School, South	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_11	0	0
2775521	CT	school	902790	930011	New Haven School District	90279001585	932111	Brennan Rogers School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_11	0	0
2775522	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2020	grade_11	0	0
2776224	CT	school		3360015	Unified School District #1	90000300343	3360115	Bridgeport Correctional Center	State Agency Facilities						2020	grade_11	*
2774897	CT	school		150011	Bridgeport School District	90045001472	159011	Bridgeport Learning Center	Program						2020	grade_11	0	0
2774901	CT	school	900450	150011	Bridgeport School District	90045001631	151611	Bridgeport Military Academy	Public Schools	Regular School	No	High	09	12	2020	grade_11	76	76
2774831	CT	school		50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program						2020	grade_11	0	0
2775639	CT	school	903090	1030011	Norwalk School District	90309000638	1036211	Brien McMahon High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	446	446
2774937	CT	school	900510	170011	Bristol School District	90051000092	176111	Bristol Central High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	273	273
2774907	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_11	0	0
2774938	CT	school	900510	170011	Bristol School District	90051000093	176211	Bristol Eastern High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	277	277
2774939	CT	school		170011	Bristol School District	90051001746	173311	Bristol Preparatory Academy	Program						2020	grade_11	20	20
2776077	CT	school	904920	1550011	West Hartford School District	90492001419	1555311	Bristow Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775098	CT	school	901350	470011	East Windsor School District	90135000228	470111	Broad Brook Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_11	0	0
2775035	CT	school	901020	340011	Danbury School District	90102000149	345111	Broadview Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2774945	CT	school	900540	180011	Brookfield School District	90054000109	186111	Brookfield High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	226	226
2774946	CT	school	900570	190011	Brooklyn School District	90057000113	190111	Brooklyn Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_11	0	0
2774947	CT	school	900570	190011	Brooklyn School District	90057000114	195111	Brooklyn Middle School	Public Schools	Regular School	No	Middle	05	08	2020	grade_11	0	0
2775622	CT	school	903090	1030011	Norwalk School District	90309000640	1030211	Brookside Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775498	CT	school		890011	New Britain School District	90267001557	899111	Brookside School	Program						2020	grade_11	6	6
2775696	CT	school	903390	1130011	Portland School District	90339001393	1130511	Brownstone Intermediate School	Public Schools	Regular School	No	Middle	05	06	2020	grade_11	0	0
2774873	CT	school	900450	150011	Bridgeport School District	90045000054	150411	Bryant School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_11	0	0
2775359	CT	school	902310	770011	Manchester School District	90231000418	770311	Buckley School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_11	0	0
2776006	CT	school		1510011	Waterbury School District		1514611	Bucks Hill Autism	Program						2020	grade_11	0	0
2776007	CT	school		1510011	Waterbury School District		1514311	Bucks Hill Bilingual	Program						2020	grade_11	0	0
2775988	CT	school	904830	1510011	Waterbury School District	90483000968	1510511	Bucks Hill School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2776068	CT	school	904920	1550011	West Hartford School District	90492001011	1550411	Bugbee School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775302	CT	school	901920	640011	Hartford School District	90192001572	647111	Bulkeley High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	148	148
2776235	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_11	187	187
2775785	CT	school	903990	1240011	Seymour School District	90399000790	1240111	Bungay School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2776022	CT	school		1510011	Waterbury School District		1510111	Bunker Hill BDLC	Program						2020	grade_11	0	0
2775989	CT	school	904830	1510011	Waterbury School District	90483000969	1510611	Bunker Hill School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775907	CT	school	904440	1380011	Stratford School District	90444000885	1386211	Bunnell High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	248	248
2775252	CT	school	901920	640011	Hartford School District	90192000357	640611	Burns Latino Studies Academy	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_11	0	0
2775745	CT	school	903539	2170012	Regional School District 17	90353900757	2170212	Burr District Elementary School	Regional Schools	Regular School	No	Elementary	PK	03	2020	grade_11	0	0
2775145	CT	school	901530	510011	Fairfield School District	90153001378	510211	Burr Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775278	CT	school	901920	640011	Hartford School District	90192000358	642311	Burr Middle School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_11	0	0
2775173	CT	school	901620	540011	Glastonbury School District	90162000280	540211	Buttonball Lane School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775575	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_11	0	0
2775501	CT	school		890011	New Britain School District	90267001609	899411	CLIMB	Program						2020	grade_11	0	0
2774821	CT	school		2440014	Area Cooperative Educational Services		2440114	CREATE at Whitney Academy	Program						2020	grade_11	0	0
2774975	CT	school		2410014	Capitol Region Education Council		2411914	CREC Impact Academy	Program						2020	grade_11	9	9
2775438	CT	school	902520	840011	Milford School District	90252000467	840111	Calf Pen Meadow School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0
2775222	CT	school	901800	600011	Guilford School District	90180000330	600411	Calvin Leete School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_11	0	0
2774948	CT	school	900660	220011	Canterbury School District	90066001188	220211	Canterbury Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_11	0	0
2774954	CT	school		230011	Canton School District	90069001695	230411	Canton Academy	Program						2020	grade_11	*
2774953	CT	school	900690	230011	Canton School District	90069000118	236111	Canton High School	Public Schools	Regular School	No	High	09	12	2020	grade_11	122	122
2774951	CT	school	900690	230011	Canton School District	90069000119	230311	Canton Intermediate School	Public Schools	Regular School	No	Middle	04	06	2020	grade_11	0	0
2774952	CT	school	900690	230011	Canton School District	90069001376	235111	Canton Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_11	0	0
2776182	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_11	55	55
2775253	CT	school	901920	640011	Hartford School District	90192001435	646911	Capital Preparatory Magnet School	Public Schools	Regular School	No	Other	PK	12	2020	grade_11	44	44
2775014	CT	school	900960	320011	Coventry School District	90096000141	325111	Capt. Nathan Hale School	Public Schools	Regular School	No	Middle	06	08	2020	grade_11	0	0
2775086	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_11	0	0
2775214	CT	school	901770	590011	Groton School District	90177000312	595311	Carl C. Cutler Middle School		Regular School	No	Middle	06	08	2020	grade_11	0	0
2774850	CT	school	900330	110011	Bloomfield School District	90033001375	110711	Carmen Arace Intermediate School	Public Schools	Regular School	No	Middle	05	06	2020	grade_11	0	0
2774852	CT	school	900330	110011	Bloomfield School District	90033000034	115211	Carmen Arace Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_11	0	0
2776094	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_11	0	0
2776008	CT	school		1510011	Waterbury School District		1511911	Carrington ESC	Program						2020	grade_11	0	0
2775990	CT	school	904830	1510011	Waterbury School District	90483000970	1512711	Carrington School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_11	0	0
2775647	CT	school		1040011	Norwich School District	90312001745	1040211	Case Street Early Learning Center at DTZ	Program						2020	grade_11	0	0
2775388	CT	school	902400	800011	Meriden School District	90240000440	801111	Casimir Pulaski School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_11	0	0