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
2451059	CT	school	902970	990011	North Branford School District	90297000620	990411	Jerome Harrison School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_12	0	0
2451060	CT	school	902970	990011	North Branford School District	90297000623	990611	Totoket Valley Elementary School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_12	0	0
2451061	CT	school	902970	990011	North Branford School District	90297000622	995111	North Branford Intermediate School	Public Schools	Regular School	No	Middle	06	08	2019	grade_12	0	0
2451062	CT	school	902970	990011	North Branford School District	90297000621	996111	North Branford High School	Public Schools	Regular School	No	High	09	12	2019	grade_12	132	132
2451063	CT	school		990011	North Branford School District	90297001621	999011	School to Work Program	Program						2019	grade_12	*
2451058	CT	school	902940	980011	Norfolk School District	90294000618	980111	Botelle Elementary School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_12	0	0
2451049	CT	school		970011	Newtown School District	90291001391	978011	Newtown Preschool	Program						2019	grade_12	0	0
2451050	CT	school	902910	970011	Newtown School District	90291000613	970111	Hawley Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_12	0	0
2451051	CT	school	902910	970011	Newtown School District	90291001121	970411	Head O'Meadow Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_12	0	0
2451052	CT	school	902910	970011	Newtown School District	90291000614	970311	Middle Gate Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_12	0	0
2451053	CT	school	902910	970011	Newtown School District	90291000617	970211	Sandy Hook Elementary School	Public Schools	Regular School	No	Elementary	KG	04	2019	grade_12	0	0
2451054	CT	school	902910	970011	Newtown School District	90291001487	970511	Reed Intermediate School	Public Schools	Regular School	No	Middle	05	06	2019	grade_12	0	0
2451055	CT	school	902910	970011	Newtown School District	90291000616	975111	Newtown Middle School	Public Schools	Regular School	No	Middle	07	08	2019	grade_12	0	0
2451056	CT	school	902910	970011	Newtown School District	90291000615	976111	Newtown High School	Public Schools	Regular School	No	High	09	12	2019	grade_12	407	407
2451057	CT	school		970011	Newtown School District		970611	Newtown Community Partnership	Program						2019	grade_12	15	15
2451036	CT	school	902850	960011	New Milford School District	90285000599	960511	Hill And Plain School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_12	0	0
2451037	CT	school	902850	960011	New Milford School District	90285001168	960811	Northville Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_12	0	0
2451038	CT	school	902850	960011	New Milford School District	90285001372	960911	Sarah Noble Intermediate School	Public Schools	Regular School	No	Elementary	03	05	2019	grade_12	0	0
2451039	CT	school	902850	960011	New Milford School District	90285000603	965211	Schaghticoke Middle School	Public Schools	Regular School	No	Middle	06	08	2019	grade_12	0	0
2451040	CT	school	902850	960011	New Milford School District	90285000602	966111	New Milford High School	Public Schools	Regular School	No	High	09	12	2019	grade_12	287	287
2451041	CT	school		960011	New Milford School District	90285001577	969011	Litchfield Hills Transition Center	Program						2019	grade_12	10	10
2451027	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_12	0	0
2451028	CT	school	902820	950011	New London School District	90282001685	950611	Harbor Elementary School	Public Schools	Regular School	No	Elementary	PK	05	2019	grade_12	0	0
2451029	CT	school		950011	New London School District		950711	Pre-Kindergarten at Winthrop	Program						2019	grade_12	0	0
2451030	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_12	0	0
2451031	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_12	0	0
2451032	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_12	0	0
2451033	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_12	0	0
2451034	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_12	76	76
2451035	CT	school	902820	950011	New London School District	90282000595	956111	New London High School	Public Schools	Regular School	No	High	09	12	2019	grade_12	168	168
2451042	CT	school	902880	940011	Newington School District	90288000611	940611	Anna Reynolds School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_12	0	0
2451043	CT	school	902880	940011	Newington School District	90288000604	940211	Elizabeth Green School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_12	0	0
2451044	CT	school	902880	940011	Newington School District	90288000606	940811	John Paterson School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_12	0	0
2451045	CT	school	902880	940011	Newington School District	90288000612	940711	Ruth Chaffee School	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_12	0	0
2451046	CT	school	902880	940011	Newington School District	90288001120	945311	John Wallace Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_12	0	0
2451047	CT	school	902880	940011	Newington School District	90288000608	945111	Martin Kellogg Middle School	Public Schools	Regular School	No	Middle	05	08	2019	grade_12	0	0
2451048	CT	school	902880	940011	Newington School District	90288000610	946111	Newington High School	Public Schools	Regular School	No	High	09	12	2019	grade_12	331	331
2450967	CT	school	902790	930011	New Haven School District	90279000568	931411	Nathan Hale School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
2450968	CT	school	902790	930011	New Haven School District	90279000580	931511	Augusta Lewis Troup School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
2450969	CT	school	902790	930011	New Haven School District	90279000542	930211	Barnard Environmental Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
2450970	CT	school	902790	930011	New Haven School District	90279000543	930311	Beecher School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
2450971	CT	school		930011	New Haven School District		933411	Benjamin Jepson Head Start	Program						2019	grade_12	0	0
2450972	CT	school	902790	930011	New Haven School District	90279000544	931811	Benjamin Jepson Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
2450973	CT	school	902790	930011	New Haven School District	90279001585	932111	Brennan Rogers School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
2450974	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_12	0	0
2450975	CT	school	902790	930011	New Haven School District	90279000549	934111	Columbus Family Academy	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
2450976	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_12	0	0
2450977	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_12	0	0
2450978	CT	school		930011	New Haven School District		932711	Dr. Reginald Mayo Early Learning Center	Program						2019	grade_12	0	0
2450979	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_12	0	0
2450980	CT	school		930011	New Haven School District		937511	East Rock Self Contained MD	Program						2019	grade_12	0	0
2450981	CT	school	902790	930011	New Haven School District	90279000554	931611	Fair Haven School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
2450982	CT	school	902790	930011	New Haven School District	90279000559	930711	Hill Central Music Academy	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
2450983	CT	school	902790	930011	New Haven School District	90279001443	931311	John C. Daniels	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
2450984	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_12	0	0
2450985	CT	school	902790	930011	New Haven School District	90279001388	933011	King/Robinson Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
2450986	CT	school		930011	New Haven School District		930510	Lincoln Bassett Integrated PK	Program						2019	grade_12	0	0
2450987	CT	school	902790	930011	New Haven School District	90279000566	932011	Lincoln-Bassett School	Public Schools	Regular School	No	Elementary	PK	06	2019	grade_12	0	0
2450988	CT	school		930011	New Haven School District		938011	Lulac							2019	grade_12	0	0
2450989	CT	school	902790	930011	New Haven School District	90279001564	931911	Mauro-Sheridan Magnet School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
2450990	CT	school	902790	930011	New Haven School District	90279001387	931011	Ross/Woodward School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
2450991	CT	school	902790	930011	New Haven School District	90279000581	932911	Truman School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
2450992	CT	school	902790	930011	New Haven School District	90279000647	934911	West Rock Authors Academy	Public Schools	Regular School	No	Elementary	PK	04	2019	grade_12	0	0
2450993	CT	school		930011	New Haven School District		930410	West Rock Integrated PK	Program						2019	grade_12	0	0
2450994	CT	school	902790	930011	New Haven School District	90279000586	933211	Wexler/Grant Community School	Public Schools	Regular School	No	Elementary	PK	08	2019	grade_12	0	0
2450995	CT	school	902790	930011	New Haven School District	90279000553	931211	Edgewood School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_12	0	0
2450996	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_12	0	0
2450997	CT	school		930011	New Haven School District		937611	Barack H. Obama Self Contained Autism	Program						2019	grade_12	0	0
2450998	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_12	0	0
2450999	CT	school		930011	New Haven School District		937911	Bishop Woods Self Contained Autism	Program						2019	grade_12	0	0
2451000	CT	school		930011	New Haven School District		937211	Brennan Rogers Self Contained Autism	Program						2019	grade_12	0	0
2451001	CT	school	902790	930011	New Haven School District	90279000550	930611	Clinton Avenue School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_12	0	0
2451002	CT	school		930011	New Haven School District		930310	Lincoln Bassett Self Contained	Program						2019	grade_12	0	0
2451003	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_12	0	0
2451004	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_12	0	0
2451005	CT	school	902790	930011	New Haven School District	90279000588	933811	Worthington Hooker School	Public Schools	Regular School	No	Elementary	KG	08	2019	grade_12	0	0
2451006	CT	school		930011	New Haven School District		937811	Clinton Self Contained ID	Program						2019	grade_12	0	0
2451007	CT	school		930011	New Haven School District		938711	Fair Haven Self Contained ID	Program						2019	grade_12	0	0
2451008	CT	school		930011	New Haven School District		937711	Nathan Hale Self Contained ID	Program						2019	grade_12	0	0
2451009	CT	school		930011	New Haven School District		938411	West Rock Self Contained Autism	Program						2019	grade_12	0	0
2451010	CT	school		930011	New Haven School District		938611	Wexler Grant Self Contained	Program						2019	grade_12	0	0
2451011	CT	school		930011	New Haven School District		937411	Celentano Self Contained ID	Program						2019	grade_12	0	0
2451012	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_12	0	0
2451013	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_12	73	73
2451014	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_12	136	136
2451015	CT	school		930011	New Haven School District		930110	Gateway to College Program	Program						2019	grade_12	15	15
2451016	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_12	46	46
2451017	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_12	185	185
2451018	CT	school	902790	930011	New Haven School District	90279000563	936211	James Hillhouse High School	Public Schools	Regular School	No	High	09	12	2019	grade_12	181	181
2451019	CT	school		930011	New Haven School District		930210	James Hillhouse Self Contained MD	Program						2019	grade_12	*
2451020	CT	school	902790	930011	New Haven School District	90279001485	936011	Metropolitan Business Academy	Public Schools	Regular School	No	High	09	12	2019	grade_12	97	97
2451021	CT	school	902790	930011	New Haven School District	90279000547	937011	New Haven Academy	Public Schools	Regular School	No	High	09	12	2019	grade_12	55	55
2451022	CT	school		930011	New Haven School District	90279001550	939111	Riverside Education Academy	Program						2019	grade_12	28	28
2451023	CT	school	902790	930011	New Haven School District	90279001216	936711	Sound School	Public Schools	Regular School	No	High	09	12	2019	grade_12	73	73
2451024	CT	school	902790	930011	New Haven School District	90279000585	936111	Wilbur Cross High School	Public Schools	Regular School	No	High	09	12	2019	grade_12	383	383
2451025	CT	school		930011	New Haven School District		938511	Wilbur Cross Self Contained MD	Program						2019	grade_12	7	7
2451026	CT	school		930011	New Haven School District		937311	Off-Campus Classroom Program (OCC)	Program						2019	grade_12	50	50
2450964	CT	school	902760	920011	New Hartford School District	90276000540	920211	New Hartford Elementary School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_12	0	0
2450965	CT	school	902760	920011	New Hartford School District	90276000539	920111	Bakerville Consolidated School	Public Schools	Regular School	No	Elementary	KG	02	2019	grade_12	0	0
2450966	CT	school	902760	920011	New Hartford School District	90276000538	920311	Ann Antolini School	Public Schools	Regular School	No	Elementary	03	06	2019	grade_12	0	0
2450959	CT	school	902730	910011	New Fairfield School District	90273000535	910111	Consolidated School	Public Schools	Regular School	No	Elementary	PK	02	2019	grade_12	0	0