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 "year" = :p1 order by ccd_school_type 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	multiracial	total	white_int	black_int	hispanic_int	multiracial_int	total_int
1317145	MD	school		16	Prince George's		2217	Incarcerated Youth Center (JACS)						2021	grade_9							*
1317146	MD	school		16	Prince George's		2217	Incarcerated Youth Center (JACS)						2021	grade_10							*
1317147	MD	school		16	Prince George's		2217	Incarcerated Youth Center (JACS)						2021	grade_11							*
1317148	MD	school		16	Prince George's		2217	Incarcerated Youth Center (JACS)						2021	grade_12							*
1317149	MD	school		16	Prince George's		2217	Incarcerated Youth Center (JACS)						2021	pk_12_total		*	*			*	11					11
1310228	MD	school	2400060	2	Anne Arundel	240006000899	2233	Anne Arundel Evening High	Alternative School	No	High	09	12	2021	grade_9							13					13
1310229	MD	school	2400060	2	Anne Arundel	240006000899	2233	Anne Arundel Evening High	Alternative School	No	High	09	12	2021	grade_10							36					36
1310230	MD	school	2400060	2	Anne Arundel	240006000899	2233	Anne Arundel Evening High	Alternative School	No	High	09	12	2021	grade_11							71					71
1310231	MD	school	2400060	2	Anne Arundel	240006000899	2233	Anne Arundel Evening High	Alternative School	No	High	09	12	2021	grade_12							107					107
1310232	MD	school	2400060	2	Anne Arundel	240006000899	2233	Anne Arundel Evening High	Alternative School	No	High	09	12	2021	pk_12_total	106	55	54		*	*	227	106	55	54		227
1310540	MD	school	2400060	2	Anne Arundel	240006001729	4064	Mary Moss at Adams Academy	Alternative School	No	Middle	07	09	2021	grade_7							*
1310541	MD	school	2400060	2	Anne Arundel	240006001729	4064	Mary Moss at Adams Academy	Alternative School	No	Middle	07	09	2021	grade_8							*
1310542	MD	school	2400060	2	Anne Arundel	240006001729	4064	Mary Moss at Adams Academy	Alternative School	No	Middle	07	09	2021	grade_9							30					30
1310543	MD	school	2400060	2	Anne Arundel	240006001729	4064	Mary Moss at Adams Academy	Alternative School	No	Middle	07	09	2021	pk_12_total	10	19	*			*	42	10	19			42
1310747	MD	school	2400120	3	Baltimore County	240012001756	51	Northwest EDLP at Milford Mill Academy	Alternative School	No	High	10	12	2021	grade_10							*
1310748	MD	school	2400120	3	Baltimore County	240012001756	51	Northwest EDLP at Milford Mill Academy	Alternative School	No	High	10	12	2021	grade_12							*
1310749	MD	school	2400120	3	Baltimore County	240012001756	51	Northwest EDLP at Milford Mill Academy	Alternative School	No	High	10	12	2021	pk_12_total		*					*
1310750	MD	school	2400120	3	Baltimore County	240012001751	52	Southwest EDLP at Woodlawn High School	Alternative School	No	High	11	12	2021	grade_11							*
1310751	MD	school	2400120	3	Baltimore County	240012001751	52	Southwest EDLP at Woodlawn High School	Alternative School	No	High	11	12	2021	grade_12							*
1310752	MD	school	2400120	3	Baltimore County	240012001751	52	Southwest EDLP at Woodlawn High School	Alternative School	No	High	11	12	2021	pk_12_total	*	*	*				*
1310753	MD	school	2400120	3	Baltimore County	240012001754	53	Northeast EDLP at Parkville High School	Alternative School	No	High	11	12	2021	grade_11							*
1310754	MD	school	2400120	3	Baltimore County	240012001754	53	Northeast EDLP at Parkville High School	Alternative School	No	High	11	12	2021	grade_12							14					14
1310755	MD	school	2400120	3	Baltimore County	240012001754	53	Northeast EDLP at Parkville High School	Alternative School	No	High	11	12	2021	pk_12_total	*	*	*				15					15
1310756	MD	school	2400120	3	Baltimore County	240012001759	55	Southeast EDLP at Dundalk High School	Alternative School	No	High	10	12	2021	grade_10							*
1310757	MD	school	2400120	3	Baltimore County	240012001759	55	Southeast EDLP at Dundalk High School	Alternative School	No	High	10	12	2021	grade_12							*
1310758	MD	school	2400120	3	Baltimore County	240012001759	55	Southeast EDLP at Dundalk High School	Alternative School	No	High	10	12	2021	pk_12_total	*	*	*				*
1310759	MD	school	2400120	3	Baltimore County	240012001760	56	Central EDLP at Loch Raven High School	Alternative School	No	High	12	12	2021	grade_12							*
1310760	MD	school	2400120	3	Baltimore County	240012001760	56	Central EDLP at Loch Raven High School	Alternative School	No	High	12	12	2021	pk_12_total	*						*
1310761	MD	school	2400120	3	Baltimore County	240012000935	58	Home Assignments-Secondary	Alternative School	No	High	08	12	2021	grade_8							*
1310762	MD	school	2400120	3	Baltimore County	240012000935	58	Home Assignments-Secondary	Alternative School	No	High	08	12	2021	grade_10							*
1310763	MD	school	2400120	3	Baltimore County	240012000935	58	Home Assignments-Secondary	Alternative School	No	High	08	12	2021	grade_11							*
1310764	MD	school	2400120	3	Baltimore County	240012000935	58	Home Assignments-Secondary	Alternative School	No	High	08	12	2021	grade_12							*
1310765	MD	school	2400120	3	Baltimore County	240012000935	58	Home Assignments-Secondary	Alternative School	No	High	08	12	2021	pk_12_total	*	*					12					12
1310769	MD	school	2400120	3	Baltimore County	240012000436	69	Catonsville Center for Alternative Studies	Alternative School	No	High	09	12	2021	grade_9							*
1310770	MD	school	2400120	3	Baltimore County	240012000436	69	Catonsville Center for Alternative Studies	Alternative School	No	High	09	12	2021	grade_10							23					23
1310771	MD	school	2400120	3	Baltimore County	240012000436	69	Catonsville Center for Alternative Studies	Alternative School	No	High	09	12	2021	grade_11							13					13
1310772	MD	school	2400120	3	Baltimore County	240012000436	69	Catonsville Center for Alternative Studies	Alternative School	No	High	09	12	2021	grade_12							10					10
1310773	MD	school	2400120	3	Baltimore County	240012000436	69	Catonsville Center for Alternative Studies	Alternative School	No	High	09	12	2021	pk_12_total	*	41	*		*	*	51		41			51
1310774	MD	school	2400120	3	Baltimore County	240012000777	70	Meadowood Education Center	Alternative School	No	Middle	07	08	2021	grade_7							*
1310775	MD	school	2400120	3	Baltimore County	240012000777	70	Meadowood Education Center	Alternative School	No	Middle	07	08	2021	grade_8							*
1310776	MD	school	2400120	3	Baltimore County	240012000777	70	Meadowood Education Center	Alternative School	No	Middle	07	08	2021	pk_12_total	*	12	*			*	15		12			15
1310777	MD	school	2400120	3	Baltimore County	240012000831	72	Rosedale Center	Alternative School	No	High	07	12	2021	grade_7							*
1310778	MD	school	2400120	3	Baltimore County	240012000831	72	Rosedale Center	Alternative School	No	High	07	12	2021	grade_8							*
1310779	MD	school	2400120	3	Baltimore County	240012000831	72	Rosedale Center	Alternative School	No	High	07	12	2021	grade_9							*
1310780	MD	school	2400120	3	Baltimore County	240012000831	72	Rosedale Center	Alternative School	No	High	07	12	2021	grade_10							*
1310781	MD	school	2400120	3	Baltimore County	240012000831	72	Rosedale Center	Alternative School	No	High	07	12	2021	grade_11							*
1310782	MD	school	2400120	3	Baltimore County	240012000831	72	Rosedale Center	Alternative School	No	High	07	12	2021	grade_12							*
1310783	MD	school	2400120	3	Baltimore County	240012000831	72	Rosedale Center	Alternative School	No	High	07	12	2021	pk_12_total	*	17				*	25		17			25
1310784	MD	school	2400120	3	Baltimore County	240012001649	75	Crossroads Center	Alternative School	No	High	07	12	2021	grade_7							38					38
1310785	MD	school	2400120	3	Baltimore County	240012001649	75	Crossroads Center	Alternative School	No	High	07	12	2021	grade_8							43					43
1310786	MD	school	2400120	3	Baltimore County	240012001649	75	Crossroads Center	Alternative School	No	High	07	12	2021	grade_9							27					27
1310787	MD	school	2400120	3	Baltimore County	240012001649	75	Crossroads Center	Alternative School	No	High	07	12	2021	grade_10							26					26
1310788	MD	school	2400120	3	Baltimore County	240012001649	75	Crossroads Center	Alternative School	No	High	07	12	2021	grade_11							20					20
1310789	MD	school	2400120	3	Baltimore County	240012001649	75	Crossroads Center	Alternative School	No	High	07	12	2021	grade_12							15					15
1310790	MD	school	2400120	3	Baltimore County	240012001649	75	Crossroads Center	Alternative School	No	High	07	12	2021	pk_12_total	63	84	*	*	*	12	169	63	84		12	169
1310791	MD	school	2400120	3	Baltimore County	240012001711	77	BCDC Educational Center	Alternative School	No	High	09	12	2021	grade_9							*
1310792	MD	school	2400120	3	Baltimore County	240012001711	77	BCDC Educational Center	Alternative School	No	High	09	12	2021	grade_10							*
1310793	MD	school	2400120	3	Baltimore County	240012001711	77	BCDC Educational Center	Alternative School	No	High	09	12	2021	grade_11							*
1310794	MD	school	2400120	3	Baltimore County	240012001711	77	BCDC Educational Center	Alternative School	No	High	09	12	2021	grade_12							*
1310795	MD	school	2400120	3	Baltimore County	240012001711	77	BCDC Educational Center	Alternative School	No	High	09	12	2021	pk_12_total	*	19	*				31		19			31
1312308	MD	school	2400210	6	Carroll	240021001548	716	Gateway School	Alternative School	No	High	09	12	2021	grade_9							*
1312309	MD	school	2400210	6	Carroll	240021001548	716	Gateway School	Alternative School	No	High	09	12	2021	grade_10							14					14
1312310	MD	school	2400210	6	Carroll	240021001548	716	Gateway School	Alternative School	No	High	09	12	2021	grade_11							18					18
1312311	MD	school	2400210	6	Carroll	240021001548	716	Gateway School	Alternative School	No	High	09	12	2021	grade_12							12					12
1312312	MD	school	2400210	6	Carroll	240021001548	716	Gateway School	Alternative School	No	High	09	12	2021	pk_12_total	42	*	*	*	*	*	51	42				51
1312313	MD	school	2400210	6	Carroll	240021001348	717	Post Secondary Program	Alternative School	No	High	12	12	2021	grade_12							50					50
1312314	MD	school	2400210	6	Carroll	240021001348	717	Post Secondary Program	Alternative School	No	High	12	12	2021	pk_12_total	40	*	*		*	*	50	40				50
1312315	MD	school	2400210	6	Carroll	240021001349	718	PRIDE School	Alternative School	No	Elementary	01	05	2021	grade_1							*
1312316	MD	school	2400210	6	Carroll	240021001349	718	PRIDE School	Alternative School	No	Elementary	01	05	2021	grade_2							*
1312317	MD	school	2400210	6	Carroll	240021001349	718	PRIDE School	Alternative School	No	Elementary	01	05	2021	grade_5							*
1312318	MD	school	2400210	6	Carroll	240021001349	718	PRIDE School	Alternative School	No	Elementary	01	05	2021	pk_12_total	*	*	*				*
1312319	MD	school	2400210	6	Carroll	240021001694	726	Crossroads Middle School	Alternative School	No	Middle	07	08	2021	grade_7							*
1312320	MD	school	2400210	6	Carroll	240021001694	726	Crossroads Middle School	Alternative School	No	Middle	07	08	2021	grade_8							*
1312321	MD	school	2400210	6	Carroll	240021001694	726	Crossroads Middle School	Alternative School	No	Middle	07	08	2021	pk_12_total	*		*				*
1312346	MD	school	2400210	6	Carroll	240021001350	903	Flexible Student Support	Alternative School	No	High	09	12	2021	grade_9							*
1312347	MD	school	2400210	6	Carroll	240021001350	903	Flexible Student Support	Alternative School	No	High	09	12	2021	grade_10							*
1312348	MD	school	2400210	6	Carroll	240021001350	903	Flexible Student Support	Alternative School	No	High	09	12	2021	grade_11							*
1312349	MD	school	2400210	6	Carroll	240021001350	903	Flexible Student Support	Alternative School	No	High	09	12	2021	grade_12							12					12
1312350	MD	school	2400210	6	Carroll	240021001350	903	Flexible Student Support	Alternative School	No	High	09	12	2021	pk_12_total	28	*					32	28				32
1312771	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	07	12	2021	grade_7							*
1312772	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	07	12	2021	grade_8							*
1312773	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	07	12	2021	grade_9							*
1312774	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	07	12	2021	grade_10							13					13
1312775	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	07	12	2021	grade_11							22					22
1312776	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	07	12	2021	grade_12							21					21
1312777	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	07	12	2021	pk_12_total	22	34	*			*	65	22	34			65
1312928	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	07	12	2021	grade_7							*
1312929	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	07	12	2021	grade_8							*
1312930	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	07	12	2021	grade_9							*
1312931	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	07	12	2021	grade_10							10					10
1312932	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	07	12	2021	grade_11							*
1312933	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	07	12	2021	grade_12							*
1312934	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	07	12	2021	pk_12_total	22	11	*	*		*	44	22	11			44
1313553	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	06	12	2021	grade_6							*
1313554	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	06	12	2021	grade_7							11					11
1313555	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	06	12	2021	grade_8							13					13
1313556	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	06	12	2021	grade_9							36					36
1313557	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	06	12	2021	grade_10							37					37
1313558	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	06	12	2021	grade_11							28					28
1313559	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	06	12	2021	grade_12							15					15
1313560	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	06	12	2021	pk_12_total	79	48	*		*	14	148	79	48		14	148