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
2760909	CT	school		930011	New Haven School District		933411	Benjamin Jepson Head Start	Program						2020	grade_1	0	0
2760910	CT	school	902790	930011	New Haven School District	90279000544	931811	Benjamin Jepson Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1	52	52
2760970	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_1	0	0
2760226	CT	school	900210	70011	Berlin School District	90021000016	76111	Berlin High School	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2760639	CT	school	901920	640011	Hartford School District	90192001192	642811	Betances Learning Lab Magnet School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	60	60
2760681	CT	school	901920	640011	Hartford School District	90192001616	643811	Betances STEM Magnet School	Public Schools	Regular School	No	Middle	05	08	2020	grade_1	0	0
2760228	CT	school	900240	80011	Bethany School District	90024000022	80111	Bethany Community School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_1	51	51
2760233	CT	school	900270	90011	Bethel School District	90027000024	96111	Bethel High School	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2760232	CT	school	900270	90011	Bethel School District	90027000025	95111	Bethel Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_1	0	0
2761117	CT	school	903536	2140012	Regional School District 14	90353600743	2140112	Bethlehem Elementary School	Regional Schools	Regular School	No	Elementary	PK	05	2020	grade_1	38	38
2760950	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_1	0	0
2760802	CT	school	902490	830011	Middletown School District	90249000453	830211	Bielefield School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	56	56
2760290	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_1	0	0
2761313	CT	school	904560	1420011	Tolland School District	90456000948	1420111	Birch Grove Primary School	Public Schools	Regular School	No	Elementary	PK	02	2020	grade_1	131	131
2761036	CT	school	903120	1040011	Norwich School District	90312000663	1040111	Bishop School Early Learning Center	Public Schools	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0	0
2760935	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_1	41	41
2760936	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2020	grade_1	*
2760261	CT	school	900450	150011	Bridgeport School District	90045000052	150311	Black Rock School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1	45	45
2761306	CT	school	904500	1400011	Thomaston School District	90450000906	1400111	Black Rock School	Public Schools	Regular School	No	Elementary	PK	03	2020	grade_1	61	61
2760262	CT	school	900450	150011	Bridgeport School District	90045000053	154011	Blackham School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1	97	97
2761486	CT	school		1560011	West Haven School District		1560711	Blended	Program						2020	grade_1	0	0
2761487	CT	school		1560011	West Haven School District		1560511	Blended (Molloy)	Program						2020	grade_1	0	0
2760243	CT	school	900330	110011	Bloomfield School District	90033000029	116111	Bloomfield High School	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2760245	CT	school	900360	120011	Bolton School District	90036000036	120111	Bolton Center School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1	47	47
2760246	CT	school	900360	120011	Bolton School District	90036000037	126111	Bolton High School	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2760247	CT	school		120011	Bolton School District		120211	Bolton Transition Program	Program						2020	grade_1	0	0
2761570	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_1	79	79
2761107	CT	school	903530	2120012	Regional School District 12	90353000731	2120212	Booth Free School	Regional Schools	Regular School	No	Elementary	KG	05	2020	grade_1	13	13
2761180	CT	school	904050	1260011	Shelton School District	90405000796	1261011	Booth Hill School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	69	69
2761328	CT	school	904620	1440011	Trumbull School District	90462000927	1440111	Booth Hill School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	70	70
2760996	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_1	9	9
2760753	CT	school	902310	770011	Manchester School District	90231000417	770111	Bowers School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_1	60	60
2760439	CT	school	901110	370011	Derby School District	90111000174	370611	Bradley School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	34	34
2761456	CT	school		1550011	West Hartford School District	90492001705	1559311	Braeburn Learning Center	Program						2020	grade_1	*
2761457	CT	school	904920	1550011	West Hartford School District	90492001009	1550211	Braeburn School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	49	49
2761150	CT	school	903810	1180011	Ridgefield School District	90381000525	1180611	Branchville Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	54	54
2760254	CT	school	900420	140011	Branford School District	90042000039	146111	Branford High School	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2760255	CT	school		140011	Branford School District	90042001742	140211	Branford High School Atlas Program	Program						2020	grade_1	0	0
2760257	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_1	38	38
2760640	CT	school	901920	640011	Hartford School District	90192001534	643511	Breakthrough Magnet School, North	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	44	44
2760641	CT	school	901920	640011	Hartford School District	90192001369	643311	Breakthrough Magnet School, South	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1	38	38
2760911	CT	school	902790	930011	New Haven School District	90279001585	932111	Brennan Rogers School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1	31	31
2760912	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2020	grade_1	*
2761614	CT	school		3360015	Unified School District #1	90000300343	3360115	Bridgeport Correctional Center	State Agency Facilities						2020	grade_1	0	0
2760287	CT	school		150011	Bridgeport School District	90045001472	159011	Bridgeport Learning Center	Program						2020	grade_1	7	7
2760291	CT	school	900450	150011	Bridgeport School District	90045001631	151611	Bridgeport Military Academy	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2760221	CT	school		50011	Barkhamsted School District		50211	Bridges at Barkhamsted Elementary School	Program						2020	grade_1	0	0
2761029	CT	school	903090	1030011	Norwalk School District	90309000638	1036211	Brien McMahon High School	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2760327	CT	school	900510	170011	Bristol School District	90051000092	176111	Bristol Central High School	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2760297	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_1	0	0
2760328	CT	school	900510	170011	Bristol School District	90051000093	176211	Bristol Eastern High School	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2760329	CT	school		170011	Bristol School District	90051001746	173311	Bristol Preparatory Academy	Program						2020	grade_1	0	0
2761467	CT	school	904920	1550011	West Hartford School District	90492001419	1555311	Bristow Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_1	0	0
2760488	CT	school	901350	470011	East Windsor School District	90135000228	470111	Broad Brook Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	81	81
2760425	CT	school	901020	340011	Danbury School District	90102000149	345111	Broadview Middle School	Public Schools	Regular School	No	Middle	06	08	2020	grade_1	0	0
2760335	CT	school	900540	180011	Brookfield School District	90054000109	186111	Brookfield High School	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2760336	CT	school	900570	190011	Brooklyn School District	90057000113	190111	Brooklyn Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	95	95
2760337	CT	school	900570	190011	Brooklyn School District	90057000114	195111	Brooklyn Middle School	Public Schools	Regular School	No	Middle	05	08	2020	grade_1	0	0
2761012	CT	school	903090	1030011	Norwalk School District	90309000640	1030211	Brookside Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	65	65
2760888	CT	school		890011	New Britain School District	90267001557	899111	Brookside School	Program						2020	grade_1	0	0
2761086	CT	school	903390	1130011	Portland School District	90339001393	1130511	Brownstone Intermediate School	Public Schools	Regular School	No	Middle	05	06	2020	grade_1	0	0
2760263	CT	school	900450	150011	Bridgeport School District	90045000054	150411	Bryant School	Public Schools	Regular School	No	Elementary	PK	06	2020	grade_1	45	45
2760749	CT	school	902310	770011	Manchester School District	90231000418	770311	Buckley School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	77	77
2761396	CT	school		1510011	Waterbury School District		1514611	Bucks Hill Autism	Program						2020	grade_1	*
2761397	CT	school		1510011	Waterbury School District		1514311	Bucks Hill Bilingual	Program						2020	grade_1	44	44
2761378	CT	school	904830	1510011	Waterbury School District	90483000968	1510511	Bucks Hill School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	61	61
2761458	CT	school	904920	1550011	West Hartford School District	90492001011	1550411	Bugbee School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	63	63
2760692	CT	school	901920	640011	Hartford School District	90192001572	647111	Bulkeley High School	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2761625	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_1	0	0
2761175	CT	school	903990	1240011	Seymour School District	90399000790	1240111	Bungay School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	70	70
2761412	CT	school		1510011	Waterbury School District		1510111	Bunker Hill BDLC	Program						2020	grade_1	0	0
2761379	CT	school	904830	1510011	Waterbury School District	90483000969	1510611	Bunker Hill School	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	83	83
2761297	CT	school	904440	1380011	Stratford School District	90444000885	1386211	Bunnell High School	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2760642	CT	school	901920	640011	Hartford School District	90192000357	640611	Burns Latino Studies Academy	Public Schools	Regular School	No	Elementary	PK	05	2020	grade_1	38	38
2761135	CT	school	903539	2170012	Regional School District 17	90353900757	2170212	Burr District Elementary School	Regional Schools	Regular School	No	Elementary	PK	03	2020	grade_1	68	68
2760535	CT	school	901530	510011	Fairfield School District	90153001378	510211	Burr Elementary School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	63	63
2760668	CT	school	901920	640011	Hartford School District	90192000358	642311	Burr Middle School	Public Schools	Regular School	No	Elementary	KG	08	2020	grade_1	58	58
2760563	CT	school	901620	540011	Glastonbury School District	90162000280	540211	Buttonball Lane School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	84	84
2760965	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_1	86	86
2760891	CT	school		890011	New Britain School District	90267001609	899411	CLIMB	Program						2020	grade_1	0	0
2760211	CT	school		2440014	Area Cooperative Educational Services		2440114	CREATE at Whitney Academy	Program						2020	grade_1	0	0
2760365	CT	school		2410014	Capitol Region Education Council		2411914	CREC Impact Academy	Program						2020	grade_1	0	0
2760828	CT	school	902520	840011	Milford School District	90252000467	840111	Calf Pen Meadow School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	27	27
2760612	CT	school	901800	600011	Guilford School District	90180000330	600411	Calvin Leete School	Public Schools	Regular School	No	Elementary	KG	04	2020	grade_1	38	38
2760338	CT	school	900660	220011	Canterbury School District	90066001188	220211	Canterbury Elementary School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_1	51	51
2760344	CT	school		230011	Canton School District	90069001695	230411	Canton Academy	Program						2020	grade_1	0	0
2760343	CT	school	900690	230011	Canton School District	90069000118	236111	Canton High School	Public Schools	Regular School	No	High	09	12	2020	grade_1	0	0
2760341	CT	school	900690	230011	Canton School District	90069000119	230311	Canton Intermediate School	Public Schools	Regular School	No	Middle	04	06	2020	grade_1	0	0
2760342	CT	school	900690	230011	Canton School District	90069001376	235111	Canton Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_1	0	0
2761572	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_1	71	71
2760643	CT	school	901920	640011	Hartford School District	90192001435	646911	Capital Preparatory Magnet School	Public Schools	Regular School	No	Other	PK	12	2020	grade_1	38	38
2760404	CT	school	900960	320011	Coventry School District	90096000141	325111	Capt. Nathan Hale School	Public Schools	Regular School	No	Middle	06	08	2020	grade_1	0	0
2760476	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_1	35	35
2760604	CT	school	901770	590011	Groton School District	90177000312	595311	Carl C. Cutler Middle School		Regular School	No	Middle	06	08	2020	grade_1	0	0
2760240	CT	school	900330	110011	Bloomfield School District	90033001375	110711	Carmen Arace Intermediate School	Public Schools	Regular School	No	Middle	05	06	2020	grade_1	0	0
2760242	CT	school	900330	110011	Bloomfield School District	90033000034	115211	Carmen Arace Middle School	Public Schools	Regular School	No	Middle	07	08	2020	grade_1	0	0
2761484	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_1	0	0
2761398	CT	school		1510011	Waterbury School District		1511911	Carrington ESC	Program						2020	grade_1	6	6
2761380	CT	school	904830	1510011	Waterbury School District	90483000970	1512711	Carrington School	Public Schools	Regular School	No	Elementary	PK	08	2020	grade_1	46	46
2761037	CT	school		1040011	Norwich School District	90312001745	1040211	Case Street Early Learning Center at DTZ	Program						2020	grade_1	0	0
2760778	CT	school	902400	800011	Meriden School District	90240000440	801111	Casimir Pulaski School	Public Schools	Regular School	No	Elementary	KG	05	2020	grade_1	88	88