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 "state" = :p0 and (ccd_school_high_grade < :p2 or ccd_school_high_grade is null or (ccd_school_high_grade = :p2 and rowid > :p1)) order by ccd_school_high_grade 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	ccd_school_type	ccd_charter_school	ccd_school_lvl	ccd_school_low_grade	ccd_school_high_grade	year	grade	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	total	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	total_int
1237679	MD	school	2400060	2	Anne Arundel	240006000058	2273	Chesapeake High	Regular School	No	High	09	12	2020	pk_12_total	1161	57	82	*	26	*	54	1388	1161	57	82		26		54	1388
1237687	MD	school	2400060	2	Anne Arundel	240006001402	2363	Broadneck High	Regular School	No	High	09	12	2020	grade_9								557								557
1237688	MD	school	2400060	2	Anne Arundel	240006001402	2363	Broadneck High	Regular School	No	High	09	12	2020	grade_10								599								599
1237689	MD	school	2400060	2	Anne Arundel	240006001402	2363	Broadneck High	Regular School	No	High	09	12	2020	grade_11								541								541
1237690	MD	school	2400060	2	Anne Arundel	240006001402	2363	Broadneck High	Regular School	No	High	09	12	2020	grade_12								524								524
1237691	MD	school	2400060	2	Anne Arundel	240006001402	2363	Broadneck High	Regular School	No	High	09	12	2020	pk_12_total	1635	170	212	10	60	*	130	2221	1635	170	212	10	60		130	2221
1237714	MD	school	2400060	2	Anne Arundel	240006000040	3013	Arundel High	Regular School	No	High	09	12	2020	grade_9								594								594
1237715	MD	school	2400060	2	Anne Arundel	240006000040	3013	Arundel High	Regular School	No	High	09	12	2020	grade_10								563								563
1237716	MD	school	2400060	2	Anne Arundel	240006000040	3013	Arundel High	Regular School	No	High	09	12	2020	grade_11								521								521
1237717	MD	school	2400060	2	Anne Arundel	240006000040	3013	Arundel High	Regular School	No	High	09	12	2020	grade_12								522								522
1237718	MD	school	2400060	2	Anne Arundel	240006000040	3013	Arundel High	Regular School	No	High	09	12	2020	pk_12_total	1089	595	177	*	127	12	198	2200	1089	595	177		127	12	198	2200
1237885	MD	school	2400060	2	Anne Arundel	240006000099	3323	Meade High	Regular School	No	High	09	12	2020	grade_9								598								598
1237886	MD	school	2400060	2	Anne Arundel	240006000099	3323	Meade High	Regular School	No	High	09	12	2020	grade_10								541								541
1237887	MD	school	2400060	2	Anne Arundel	240006000099	3323	Meade High	Regular School	No	High	09	12	2020	grade_11								458								458
1237888	MD	school	2400060	2	Anne Arundel	240006000099	3323	Meade High	Regular School	No	High	09	12	2020	grade_12								432								432
1237889	MD	school	2400060	2	Anne Arundel	240006000099	3323	Meade High	Regular School	No	High	09	12	2020	pk_12_total	259	1021	508	*	103	*	129	2029	259	1021	508		103		129	2029
1237898	MD	school	2400060	2	Anne Arundel	240006000109	3353	Old Mill High	Regular School	No	High	09	12	2020	grade_9								599								599
1237899	MD	school	2400060	2	Anne Arundel	240006000109	3353	Old Mill High	Regular School	No	High	09	12	2020	grade_10								569								569
1237900	MD	school	2400060	2	Anne Arundel	240006000109	3353	Old Mill High	Regular School	No	High	09	12	2020	grade_11								598								598
1237901	MD	school	2400060	2	Anne Arundel	240006000109	3353	Old Mill High	Regular School	No	High	09	12	2020	grade_12								515								515
1237902	MD	school	2400060	2	Anne Arundel	240006000109	3353	Old Mill High	Regular School	No	High	09	12	2020	pk_12_total	892	821	311	*	104	10	139	2281	892	821	311		104	10	139	2281
1237934	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2020	pre_kindergarten								38								38
1237935	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2020	kindergarten								17								17
1237936	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2020	grade_1								12								12
1237937	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2020	grade_2								*
1237938	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2020	grade_3								*
1237939	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2020	grade_4								*
1237940	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2020	grade_5								*
1237941	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2020	grade_6								14								14
1237942	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2020	grade_7								*
1237943	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2020	grade_8								*
1237944	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2020	grade_9								*
1237945	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2020	grade_10								*
1237946	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2020	grade_11								11								11
1237947	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2020	grade_12								*
1237948	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2020	pk_12_total	51	63	19		*		*	143	51	63	19					143
1237953	MD	school	2400060	2	Anne Arundel	240006000037	4013	Annapolis High	Regular School	No	High	09	12	2020	grade_9								625								625
1237954	MD	school	2400060	2	Anne Arundel	240006000037	4013	Annapolis High	Regular School	No	High	09	12	2020	grade_10								552								552
1237955	MD	school	2400060	2	Anne Arundel	240006000037	4013	Annapolis High	Regular School	No	High	09	12	2020	grade_11								461								461
1237956	MD	school	2400060	2	Anne Arundel	240006000037	4013	Annapolis High	Regular School	No	High	09	12	2020	grade_12								465								465
1237957	MD	school	2400060	2	Anne Arundel	240006000037	4013	Annapolis High	Regular School	No	High	09	12	2020	pk_12_total	635	560	790	*	50	*	62	2103	635	560	790		50		62	2103
1237958	MD	school	2400060	2	Anne Arundel	240006000132	4023	Southern High	Regular School	No	High	09	12	2020	grade_9								253								253
1237959	MD	school	2400060	2	Anne Arundel	240006000132	4023	Southern High	Regular School	No	High	09	12	2020	grade_10								268								268
1237960	MD	school	2400060	2	Anne Arundel	240006000132	4023	Southern High	Regular School	No	High	09	12	2020	grade_11								236								236
1237961	MD	school	2400060	2	Anne Arundel	240006000132	4023	Southern High	Regular School	No	High	09	12	2020	grade_12								239								239
1237962	MD	school	2400060	2	Anne Arundel	240006000132	4023	Southern High	Regular School	No	High	09	12	2020	pk_12_total	729	75	132	*	*	*	51	996	729	75	132				51	996
1237979	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	KG	12	2020	kindergarten								*
1237980	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	KG	12	2020	grade_1								*
1237981	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	KG	12	2020	grade_2								17								17
1237982	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	KG	12	2020	grade_3								25								25
1237983	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	KG	12	2020	grade_4								23								23
1237984	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	KG	12	2020	grade_5								25								25
1237985	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	KG	12	2020	grade_6								25								25
1237986	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	KG	12	2020	grade_7								35								35
1237987	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	KG	12	2020	grade_8								27								27
1237988	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	KG	12	2020	grade_9								31								31
1237989	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	KG	12	2020	grade_10								73								73
1237990	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	KG	12	2020	grade_11								29								29
1237991	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	KG	12	2020	grade_12								25								25
1237992	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	KG	12	2020	pk_12_total	131	164	27	*			22	347	131	164	27				22	347
1238128	MD	school	2400060	2	Anne Arundel	240006000055	4293	South River High	Regular School	No	High	09	12	2020	grade_9								616								616
1238129	MD	school	2400060	2	Anne Arundel	240006000055	4293	South River High	Regular School	No	High	09	12	2020	grade_10								566								566
1238130	MD	school	2400060	2	Anne Arundel	240006000055	4293	South River High	Regular School	No	High	09	12	2020	grade_11								522								522
1238131	MD	school	2400060	2	Anne Arundel	240006000055	4293	South River High	Regular School	No	High	09	12	2020	grade_12								520								520
1238132	MD	school	2400060	2	Anne Arundel	240006000055	4293	South River High	Regular School	No	High	09	12	2020	pk_12_total	1673	123	216	*	96	*	111	2224	1673	123	216		96		111	2224
1238133	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2020	pre_kindergarten								73								73
1238134	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2020	kindergarten								*
1238135	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2020	grade_1								*
1238136	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2020	grade_2								*
1238137	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2020	grade_3								10								10
1238138	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2020	grade_4								*
1238139	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2020	grade_5								*
1238140	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2020	grade_6								*
1238141	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2020	grade_7								*
1238142	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2020	grade_8								*
1238143	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2020	grade_9								*
1238144	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2020	grade_10								*
1238145	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2020	grade_11								15								15
1238146	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2020	grade_12								*
1238147	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2020	pk_12_total	80	32	23		*		*	148	80	32	23					148
1238165	MD	school	2400060	2	Anne Arundel	240006001401	6223	Chesapeake Science Point	Regular School	Yes	High	06	12	2020	grade_6								80								80
1238166	MD	school	2400060	2	Anne Arundel	240006001401	6223	Chesapeake Science Point	Regular School	Yes	High	06	12	2020	grade_7								76								76
1238167	MD	school	2400060	2	Anne Arundel	240006001401	6223	Chesapeake Science Point	Regular School	Yes	High	06	12	2020	grade_8								76								76
1238168	MD	school	2400060	2	Anne Arundel	240006001401	6223	Chesapeake Science Point	Regular School	Yes	High	06	12	2020	grade_9								68								68
1238169	MD	school	2400060	2	Anne Arundel	240006001401	6223	Chesapeake Science Point	Regular School	Yes	High	06	12	2020	grade_10								61								61
1238170	MD	school	2400060	2	Anne Arundel	240006001401	6223	Chesapeake Science Point	Regular School	Yes	High	06	12	2020	grade_11								54								54
1238171	MD	school	2400060	2	Anne Arundel	240006001401	6223	Chesapeake Science Point	Regular School	Yes	High	06	12	2020	grade_12								49								49
1238172	MD	school	2400060	2	Anne Arundel	240006001401	6223	Chesapeake Science Point	Regular School	Yes	High	06	12	2020	pk_12_total	132	178	45	*	72	*	34	464	132	178	45		72		34	464
1238183	MD	school	2400120	3	Baltimore County	240012001756	51	Northwest EDLP at Milford Mill Academy	Alternative School	No	High	11	12	2020	grade_11								*
1238184	MD	school	2400120	3	Baltimore County	240012001756	51	Northwest EDLP at Milford Mill Academy	Alternative School	No	High	11	12	2020	grade_12								*
1238185	MD	school	2400120	3	Baltimore County	240012001756	51	Northwest EDLP at Milford Mill Academy	Alternative School	No	High	11	12	2020	pk_12_total		*	*					*
1238186	MD	school	2400120	3	Baltimore County	240012001751	52	Southwest EDLP at Woodlawn High School	Alternative School	No	High	09	12	2020	grade_9								*
1238187	MD	school	2400120	3	Baltimore County	240012001751	52	Southwest EDLP at Woodlawn High School	Alternative School	No	High	09	12	2020	grade_11								*
1238188	MD	school	2400120	3	Baltimore County	240012001751	52	Southwest EDLP at Woodlawn High School	Alternative School	No	High	09	12	2020	grade_12								10								10
1238189	MD	school	2400120	3	Baltimore County	240012001751	52	Southwest EDLP at Woodlawn High School	Alternative School	No	High	09	12	2020	pk_12_total	*	*	*		*		*	14								14
1238190	MD	school	2400120	3	Baltimore County	240012001754	53	Northeast EDLP at Parkville High School	Alternative School	No	High	10	12	2020	grade_10								*
1238191	MD	school	2400120	3	Baltimore County	240012001754	53	Northeast EDLP at Parkville High School	Alternative School	No	High	10	12	2020	grade_11								*
1238192	MD	school	2400120	3	Baltimore County	240012001754	53	Northeast EDLP at Parkville High School	Alternative School	No	High	10	12	2020	grade_12								16								16
1238193	MD	school	2400120	3	Baltimore County	240012001754	53	Northeast EDLP at Parkville High School	Alternative School	No	High	10	12	2020	pk_12_total	*	*	*					18								18
1238194	MD	school	2400120	3	Baltimore County	240012001759	55	Southeast EDLP at Dundalk High School	Alternative School	No	High	10	12	2020	grade_10								*
1238195	MD	school	2400120	3	Baltimore County	240012001759	55	Southeast EDLP at Dundalk High School	Alternative School	No	High	10	12	2020	grade_11								*