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 order by district_state_id desc 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
2449610	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_11	0	0
2449611	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_11	0	0
2449612	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_11	0	0
2449613	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	138	138
2449614	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_11	0	0
2449609	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_11	0	0
2449600	CT	school		970011	Newtown School District	90291001391	978011	Newtown Preschool	Program						2019	grade_11	0	0
2449601	CT	school	902910	970011	Newtown School District	90291000613	970111	Hawley Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_11	0	0
2449602	CT	school	902910	970011	Newtown School District	90291001121	970411	Head O'Meadow Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_11	0	0
2449603	CT	school	902910	970011	Newtown School District	90291000614	970311	Middle Gate Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_11	0	0
2449604	CT	school	902910	970011	Newtown School District	90291000617	970211	Sandy Hook Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_11	0	0
2449605	CT	school	902910	970011	Newtown School District	90291001487	970511	Reed Intermediate School	Public Schools	Regular School	No	Middle	05	06	2019	grade_11	0	0
2449606	CT	school	902910	970011	Newtown School District	90291000616	975111	Newtown Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_11	0	0
2449607	CT	school	902910	970011	Newtown School District	90291000615	976111	Newtown High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	426	426
2449608	CT	school		970011	Newtown School District		970611	Newtown Community Partnership	Program						2019	grade_11	0	0
2449587	CT	school	902850	960011	New Milford School District	90285000599	960511	Hill And Plain School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_11	0	0
2449588	CT	school	902850	960011	New Milford School District	90285001168	960811	Northville Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_11	0	0
2449589	CT	school	902850	960011	New Milford School District	90285001372	960911	Sarah Noble Intermediate School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_11	0	0
2449590	CT	school	902850	960011	New Milford School District	90285000603	965211	Schaghticoke Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_11	0	0
2449591	CT	school	902850	960011	New Milford School District	90285000602	966111	New Milford High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	349	349
2449592	CT	school		960011	New Milford School District	90285001577	969011	Litchfield Hills Transition Center	Program						2019	grade_11	0	0
2449578	CT	school	902820	950011	New London School District	90282000591	950311	C.B. Jennings International Elementary Magnet	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2449579	CT	school	902820	950011	New London School District	90282001685	950611	Harbor Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_11	0	0
2449580	CT	school		950011	New London School District		950711	Pre-Kindergarten at Winthrop	Program						2019	grade_11	0	0
2449581	CT	school	902820	950011	New London School District	90282000594	950911	Nathan Hale Arts Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_11	0	0
2449582	CT	school	902820	950011	New London School District	90282000597	950811	Winthrop STEM Elementary Magnet School	Public Schools	Regular School	No	Elementary	KG	05	2019	grade_11	0	0
2449583	CT	school	902820	950011	New London School District	90282000596	955111	Bennie Dover Jackson Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_11	0	0
2449584	CT	school	902820	950011	New London School District	90282001919	951411	New London Visual and Performing Arts Magnet School	Public Schools	Regular School	No	Middle	06	09	2019	grade_11	0	0
2449585	CT	school	902820	950011	New London School District	90282001913	951311	Science and Technology Magnet School of Southeastern Connecticut	Public Schools	Regular School	No	High	06	12	2019	grade_11	79	79
2449586	CT	school	902820	950011	New London School District	90282000595	956111	New London High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	150	150
2449593	CT	school	902880	940011	Newington School District	90288000611	940611	Anna Reynolds School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_11	0	0
2449594	CT	school	902880	940011	Newington School District	90288000604	940211	Elizabeth Green School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_11	0	0
2449595	CT	school	902880	940011	Newington School District	90288000606	940811	John Paterson School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_11	0	0
2449596	CT	school	902880	940011	Newington School District	90288000612	940711	Ruth Chaffee School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_11	0	0
2449597	CT	school	902880	940011	Newington School District	90288001120	945311	John Wallace Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_11	0	0
2449598	CT	school	902880	940011	Newington School District	90288000608	945111	Martin Kellogg Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_11	0	0
2449599	CT	school	902880	940011	Newington School District	90288000610	946111	Newington High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	315	315
2449518	CT	school	902790	930011	New Haven School District	90279000568	931411	Nathan Hale School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2449519	CT	school	902790	930011	New Haven School District	90279000580	931511	Augusta Lewis Troup School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2449520	CT	school	902790	930011	New Haven School District	90279000542	930211	Barnard Environmental Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2449521	CT	school	902790	930011	New Haven School District	90279000543	930311	Beecher School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2449522	CT	school		930011	New Haven School District		933411	Benjamin Jepson Head Start	Program						2019	grade_11	0	0
2449523	CT	school	902790	930011	New Haven School District	90279000544	931811	Benjamin Jepson Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2449524	CT	school	902790	930011	New Haven School District	90279001585	932111	Brennan Rogers School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2449525	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_11	0	0
2449526	CT	school	902790	930011	New Haven School District	90279000549	934111	Columbus Family Academy	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2449527	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_11	0	0
2449528	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_11	0	0
2449529	CT	school		930011	New Haven School District		932711	Dr. Reginald Mayo Early Learning Center	Program						2019	grade_11	0	0
2449530	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_11	0	0
2449531	CT	school		930011	New Haven School District		937511	East Rock Self Contained MD	Program						2019	grade_11	0	0
2449532	CT	school	902790	930011	New Haven School District	90279000554	931611	Fair Haven School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2449533	CT	school	902790	930011	New Haven School District	90279000559	930711	Hill Central Music Academy	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2449534	CT	school	902790	930011	New Haven School District	90279001443	931311	John C. Daniels	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2449535	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_11	0	0
2449536	CT	school	902790	930011	New Haven School District	90279001388	933011	King/Robinson Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2449537	CT	school		930011	New Haven School District		930510	Lincoln Bassett Integrated PK	Program						2019	grade_11	0	0
2449538	CT	school	902790	930011	New Haven School District	90279000566	932011	Lincoln-Bassett School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_11	0	0
2449539	CT	school		930011	New Haven School District		938011	Lulac							2019	grade_11	0	0
2449540	CT	school	902790	930011	New Haven School District	90279001564	931911	Mauro-Sheridan Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2449541	CT	school	902790	930011	New Haven School District	90279001387	931011	Ross/Woodward School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2449542	CT	school	902790	930011	New Haven School District	90279000581	932911	Truman School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2449543	CT	school	902790	930011	New Haven School District	90279000647	934911	West Rock Authors Academy	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_11	0	0
2449544	CT	school		930011	New Haven School District		930410	West Rock Integrated PK	Program						2019	grade_11	0	0
2449545	CT	school	902790	930011	New Haven School District	90279000586	933211	Wexler/Grant Community School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_11	0	0
2449546	CT	school	902790	930011	New Haven School District	90279000553	931211	Edgewood School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_11	0	0
2449547	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_11	0	0
2449548	CT	school		930011	New Haven School District		937611	Barack H. Obama Self Contained Autism	Program						2019	grade_11	0	0
2449549	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_11	0	0
2449550	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2019	grade_11	0	0
2449551	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2019	grade_11	0	0
2449552	CT	school	902790	930011	New Haven School District	90279000550	930611	Clinton Avenue School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_11	0	0
2449553	CT	school		930011	New Haven School District		930310	Lincoln Bassett Self Contained	Program						2019	grade_11	0	0
2449554	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_11	0	0
2449555	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_11	0	0
2449556	CT	school	902790	930011	New Haven School District	90279000588	933811	Worthington Hooker School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_11	0	0
2449557	CT	school		930011	New Haven School District		937811	Clinton Self Contained ID	Program						2019	grade_11	0	0
2449558	CT	school		930011	New Haven School District		938711	Fair Haven Self Contained ID	Program						2019	grade_11	0	0
2449559	CT	school		930011	New Haven School District		937711	Nathan Hale Self Contained ID	Program						2019	grade_11	0	0
2449560	CT	school		930011	New Haven School District		938411	West Rock Self Contained Autism	Program						2019	grade_11	0	0
2449561	CT	school		930011	New Haven School District		938611	Wexler Grant Self Contained	Program						2019	grade_11	0	0
2449562	CT	school		930011	New Haven School District		937411	Celentano Self Contained ID	Program						2019	grade_11	0	0
2449563	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_11	0	0
2449564	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_11	87	87
2449565	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_11	168	168
2449566	CT	school		930011	New Haven School District		930110	Gateway to College Program	Program						2019	grade_11	16	16
2449567	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_11	63	63
2449568	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_11	157	157
2449569	CT	school	902790	930011	New Haven School District	90279000563	936211	James Hillhouse High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	196	196
2449570	CT	school		930011	New Haven School District		930210	James Hillhouse Self Contained MD	Program						2019	grade_11	*
2449571	CT	school	902790	930011	New Haven School District	90279001485	936011	Metropolitan Business Academy	Public Schools	Regular School	No	High	09	12	2019	grade_11	104	104
2449572	CT	school	902790	930011	New Haven School District	90279000547	937011	New Haven Academy	Public Schools	Regular School	No	High	09	12	2019	grade_11	69	69
2449573	CT	school		930011	New Haven School District	90279001550	939111	Riverside Education Academy	Program						2019	grade_11	40	40
2449574	CT	school	902790	930011	New Haven School District	90279001216	936711	Sound School	Public Schools	Regular School	No	High	09	12	2019	grade_11	86	86
2449575	CT	school	902790	930011	New Haven School District	90279000585	936111	Wilbur Cross High School	Public Schools	Regular School	No	High	09	12	2019	grade_11	337	337
2449576	CT	school		930011	New Haven School District		938511	Wilbur Cross Self Contained MD	Program						2019	grade_11	*
2449577	CT	school		930011	New Haven School District		937311	Off-Campus Classroom Program (OCC)	Program						2019	grade_11	0	0
2449515	CT	school	902760	920011	New Hartford School District	90276000540	920211	New Hartford Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_11	0	0
2449516	CT	school	902760	920011	New Hartford School District	90276000539	920111	Bakerville Consolidated School	Public Schools	Regular School	No	Elementary	KG	02	2019	grade_11	0	0
2449517	CT	school	902760	920011	New Hartford School District	90276000538	920311	Ann Antolini School	Public Schools	Regular School	No	Elementary	03	06	2019	grade_11	0	0
2449510	CT	school	902730	910011	New Fairfield School District	90273000535	910111	Consolidated School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_11	0	0