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 (district_state_id < :p3 or district_state_id is null or (district_state_id = :p3 and rowid > :p2)) order by district_state_id desc, 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
2753735	CT	school	902880	940011	Newington School District	90288000604	940211	Elizabeth Green School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_10	0	0
2753736	CT	school	902880	940011	Newington School District	90288000606	940811	John Paterson School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_10	0	0
2753737	CT	school	902880	940011	Newington School District	90288000612	940711	Ruth Chaffee School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_10	0	0
2753738	CT	school	902880	940011	Newington School District	90288001120	945311	John Wallace Middle School	Public Schools	Regular School	No	Middle	05	08	2021	grade_10	0	0
2753739	CT	school	902880	940011	Newington School District	90288000608	945111	Martin Kellogg Middle School	Public Schools	Regular School	No	Middle	05	08	2021	grade_10	0	0
2753740	CT	school	902880	940011	Newington School District	90288000610	946111	Newington High School	Public Schools	Regular School	No	High	09	12	2021	grade_10	321	321
2774129	CT	school	902880	940011	Newington School District	90288000611	940611	Anna Reynolds School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_10	0	0
2774130	CT	school	902880	940011	Newington School District	90288000604	940211	Elizabeth Green School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_10	0	0
2774131	CT	school	902880	940011	Newington School District	90288000606	940811	John Paterson School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_10	0	0
2774132	CT	school	902880	940011	Newington School District	90288000612	940711	Ruth Chaffee School	Public Schools	Regular School	No	Elementary	PK	04	2020	grade_10	0	0
2774133	CT	school	902880	940011	Newington School District	90288001120	945311	John Wallace Middle School	Public Schools	Regular School	No	Middle	05	08	2020	grade_10	0	0
2774134	CT	school	902880	940011	Newington School District	90288000608	945111	Martin Kellogg Middle School	Public Schools	Regular School	No	Middle	05	08	2020	grade_10	0	0
2774135	CT	school	902880	940011	Newington School District	90288000610	946111	Newington High School	Public Schools	Regular School	No	High	09	12	2020	grade_10	322	322
2448069	CT	school	902790	930011	New Haven School District	90279000568	931411	Nathan Hale School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448070	CT	school	902790	930011	New Haven School District	90279000580	931511	Augusta Lewis Troup School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448071	CT	school	902790	930011	New Haven School District	90279000542	930211	Barnard Environmental Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448072	CT	school	902790	930011	New Haven School District	90279000543	930311	Beecher School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448073	CT	school		930011	New Haven School District		933411	Benjamin Jepson Head Start	Program						2019	grade_10	0	0
2448074	CT	school	902790	930011	New Haven School District	90279000544	931811	Benjamin Jepson Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448075	CT	school	902790	930011	New Haven School District	90279001585	932111	Brennan Rogers School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448076	CT	school	902790	930011	New Haven School District	90279001484	934811	Celentano BioTech, Health and Medical Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448077	CT	school	902790	930011	New Haven School District	90279000549	934111	Columbus Family Academy	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448078	CT	school	902790	930011	New Haven School District	90279000584	933111	Conte/West Hills Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448079	CT	school	902790	930011	New Haven School District	90279000551	930911	Davis Academy for Arts & Design Innovation	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448080	CT	school		930011	New Haven School District		932711	Dr. Reginald Mayo Early Learning Center	Program						2019	grade_10	0	0
2448081	CT	school	902790	930011	New Haven School District	90279000552	934611	East Rock Community Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448082	CT	school		930011	New Haven School District		937511	East Rock Self Contained MD	Program						2019	grade_10	0	0
2448083	CT	school	902790	930011	New Haven School District	90279000554	931611	Fair Haven School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448084	CT	school	902790	930011	New Haven School District	90279000559	930711	Hill Central Music Academy	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448085	CT	school	902790	930011	New Haven School District	90279001443	931311	John C. Daniels	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448086	CT	school	902790	930011	New Haven School District	90279001386	930811	John S. Martinez Sea and Sky STEM School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448087	CT	school	902790	930011	New Haven School District	90279001388	933011	King/Robinson Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448088	CT	school		930011	New Haven School District		930510	Lincoln Bassett Integrated PK	Program						2019	grade_10	0	0
2448089	CT	school	902790	930011	New Haven School District	90279000566	932011	Lincoln-Bassett School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_10	0	0
2448090	CT	school		930011	New Haven School District		938011	Lulac							2019	grade_10	0	0
2448091	CT	school	902790	930011	New Haven School District	90279001564	931911	Mauro-Sheridan Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448092	CT	school	902790	930011	New Haven School District	90279001387	931011	Ross/Woodward School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448093	CT	school	902790	930011	New Haven School District	90279000581	932911	Truman School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448094	CT	school	902790	930011	New Haven School District	90279000647	934911	West Rock Authors Academy	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_10	0	0
2448095	CT	school		930011	New Haven School District		930410	West Rock Integrated PK	Program						2019	grade_10	0	0
2448096	CT	school	902790	930011	New Haven School District	90279000586	933211	Wexler/Grant Community School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_10	0	0
2448097	CT	school	902790	930011	New Haven School District	90279000553	931211	Edgewood School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_10	0	0
2448098	CT	school	902790	930011	New Haven School District	90279001509	932811	Barack H. Obama Magnet University School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_10	0	0
2448099	CT	school		930011	New Haven School District		937611	Barack H. Obama Self Contained Autism	Program						2019	grade_10	0	0
2448100	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	2019	grade_10	0	0
2448101	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2019	grade_10	0	0
2448102	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2019	grade_10	0	0
2448103	CT	school	902790	930011	New Haven School District	90279000550	930611	Clinton Avenue School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_10	0	0
2448104	CT	school		930011	New Haven School District		930310	Lincoln Bassett Self Contained	Program						2019	grade_10	0	0
2448105	CT	school	902790	930011	New Haven School District	90279001612	933511	Quinnipiac Real World Math STEM School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_10	0	0
2448106	CT	school	902790	930011	New Haven School District	90279001483	934211	Roberto Clemente Leadership Academy for Global Awareness	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_10	0	0
2448107	CT	school	902790	930011	New Haven School District	90279000588	933811	Worthington Hooker School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_10	0	0
2448108	CT	school		930011	New Haven School District		937811	Clinton Self Contained ID	Program						2019	grade_10	0	0
2448109	CT	school		930011	New Haven School District		938711	Fair Haven Self Contained ID	Program						2019	grade_10	0	0
2448110	CT	school		930011	New Haven School District		937711	Nathan Hale Self Contained ID	Program						2019	grade_10	0	0
2448111	CT	school		930011	New Haven School District		938411	West Rock Self Contained Autism	Program						2019	grade_10	0	0
2448112	CT	school		930011	New Haven School District		938611	Wexler Grant Self Contained	Program						2019	grade_10	0	0
2448113	CT	school		930011	New Haven School District		937411	Celentano Self Contained ID	Program						2019	grade_10	0	0
2448114	CT	school	902790	930011	New Haven School District	90279000545	935511	Betsy Ross Arts Magnet School	Public Schools	Regular School	No	Middle	05	08	2019	grade_10	0	0
2448115	CT	school	902790	930011	New Haven School District	90279001519	931711	Engineering - Science University Magnet School	Public Schools	Regular School	No	High	06	12	2019	grade_10	88	88
2448116	CT	school	902790	930011	New Haven School District	90279001207	936411	Cooperative High School - Inter-District Magnet	Public Schools	Regular School	No	High	09	12	2019	grade_10	162	162
2448117	CT	school		930011	New Haven School District		930110	Gateway to College Program	Program						2019	grade_10	*
2448118	CT	school	902790	930011	New Haven School District	90279000558	936611	High School In The Community	Public Schools	Regular School	No	High	09	12	2019	grade_10	60	60
2448119	CT	school	902790	930011	New Haven School District	90279000556	936311	Hill Regional Career High School	Public Schools	Regular School	No	High	09	12	2019	grade_10	185	185
2448120	CT	school	902790	930011	New Haven School District	90279000563	936211	James Hillhouse High School	Public Schools	Regular School	No	High	09	12	2019	grade_10	257	257
2448121	CT	school		930011	New Haven School District		930210	James Hillhouse Self Contained MD	Program						2019	grade_10	*
2448122	CT	school	902790	930011	New Haven School District	90279001485	936011	Metropolitan Business Academy	Public Schools	Regular School	No	High	09	12	2019	grade_10	118	118
2448123	CT	school	902790	930011	New Haven School District	90279000547	937011	New Haven Academy	Public Schools	Regular School	No	High	09	12	2019	grade_10	89	89
2448124	CT	school		930011	New Haven School District	90279001550	939111	Riverside Education Academy	Program						2019	grade_10	34	34
2448125	CT	school	902790	930011	New Haven School District	90279001216	936711	Sound School	Public Schools	Regular School	No	High	09	12	2019	grade_10	67	67
2448126	CT	school	902790	930011	New Haven School District	90279000585	936111	Wilbur Cross High School	Public Schools	Regular School	No	High	09	12	2019	grade_10	433	433
2448127	CT	school		930011	New Haven School District		938511	Wilbur Cross Self Contained MD	Program						2019	grade_10	*
2448128	CT	school		930011	New Haven School District		937311	Off-Campus Classroom Program (OCC)	Program						2019	grade_10	0	0
2753660	CT	school	902790	930011	New Haven School District	90279000568	931411	Nathan Hale School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753661	CT	school	902790	930011	New Haven School District	90279000580	931511	Augusta Lewis Troup School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753662	CT	school	902790	930011	New Haven School District	90279001509	932811	Barack H. Obama Magnet University School	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_10	0	0
2753663	CT	school	902790	930011	New Haven School District	90279000542	930211	Barnard Environmental Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753664	CT	school	902790	930011	New Haven School District	90279000543	930311	Beecher School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753665	CT	school		930011	New Haven School District		933411	Benjamin Jepson Head Start	Program						2021	grade_10	0	0
2753666	CT	school	902790	930011	New Haven School District	90279000544	931811	Benjamin Jepson Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753667	CT	school	902790	930011	New Haven School District	90279001585	932111	Brennan Rogers School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753668	CT	school	902790	930011	New Haven School District	90279001484	934811	Celentano BioTech, Health and Medical Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753669	CT	school	902790	930011	New Haven School District	90279000549	934111	Columbus Family Academy	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753670	CT	school	902790	930011	New Haven School District	90279000584	933111	Conte/West Hills Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753671	CT	school	902790	930011	New Haven School District	90279000551	930911	Davis Academy for Arts & Design Innovation	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753672	CT	school		930011	New Haven School District		932711	Dr. Reginald Mayo Early Learning Center	Program						2021	grade_10	0	0
2753673	CT	school	902790	930011	New Haven School District	90279000552	934611	East Rock Community Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753674	CT	school	902790	930011	New Haven School District	90279000554	931611	Fair Haven School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753675	CT	school	902790	930011	New Haven School District	90279000559	930711	Hill Central Music Academy	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753676	CT	school	902790	930011	New Haven School District	90279001443	931311	John C. Daniels	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753677	CT	school	902790	930011	New Haven School District	90279001386	930811	John S. Martinez Sea and Sky STEM School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753678	CT	school	902790	930011	New Haven School District	90279001388	933011	King/Robinson Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753679	CT	school		930011	New Haven School District		930510	Lincoln Bassett Integrated PK	Program						2021	grade_10	0	0
2753680	CT	school		930011	New Haven School District		930310	Lincoln Bassett Self Contained	Program						2021	grade_10	0	0
2753681	CT	school	902790	930011	New Haven School District	90279000566	932011	Lincoln-Bassett School	Public Schools	Regular School	No	Elementary	PK	06	2021	grade_10	0	0
2753682	CT	school	902790	930011	New Haven School District	90279001564	931911	Mauro-Sheridan Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753683	CT	school	902790	930011	New Haven School District	90279001387	931011	Ross/Woodward School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753684	CT	school	902790	930011	New Haven School District	90279000581	932911	Truman School	Public Schools	Regular School	No	Elementary	PK	08	2021	grade_10	0	0
2753685	CT	school	902790	930011	New Haven School District	90279000647	934911	West Rock Authors Academy	Public Schools	Regular School	No	Elementary	PK	04	2021	grade_10	0	0
2753686	CT	school		930011	New Haven School District		930410	West Rock Integrated PK	Program						2021	grade_10	0	0
2753687	CT	school	902790	930011	New Haven School District	90279000553	931211	Edgewood School	Public Schools	Regular School	No	Elementary	KG	08	2021	grade_10	0	0