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_type > :p2 or (ccd_school_type = :p2 and rowid > :p1)) order by ccd_school_type, 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	total_int
1240224	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	06	12	2020	grade_7								*
1240225	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	06	12	2020	grade_8								10				10
1240226	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	06	12	2020	grade_9								*
1240227	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	06	12	2020	grade_10								20				20
1240228	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	06	12	2020	grade_11								17				17
1240229	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	06	12	2020	grade_12								31				31
1240230	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	06	12	2020	pk_12_total	25	53	*	*		*	*	88	25	53		88
1240381	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	06	12	2020	grade_6								*
1240382	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	06	12	2020	grade_7								*
1240383	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	06	12	2020	grade_8								*
1240384	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	06	12	2020	grade_9								18				18
1240385	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	06	12	2020	grade_10								*
1240386	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	06	12	2020	grade_11								*
1240387	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	06	12	2020	grade_12								*
1240388	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	06	12	2020	pk_12_total	21	19	*	*			*	56	21	19		56
1241000	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	08	12	2020	grade_8								*
1241001	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	08	12	2020	grade_9								35				35
1241002	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	08	12	2020	grade_10								15				15
1241003	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	08	12	2020	grade_11								11				11
1241004	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	08	12	2020	grade_12								12				12
1241005	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	08	12	2020	pk_12_total	26	37	*		*		*	74	26	37		74
1241219	MD	school	2400420	13	Howard	240042001189	80	Homewood School	Alternative School	No	High	06	12	2020	grade_6								*
1241220	MD	school	2400420	13	Howard	240042001189	80	Homewood School	Alternative School	No	High	06	12	2020	grade_7								*
1241221	MD	school	2400420	13	Howard	240042001189	80	Homewood School	Alternative School	No	High	06	12	2020	grade_8								12				12
1241222	MD	school	2400420	13	Howard	240042001189	80	Homewood School	Alternative School	No	High	06	12	2020	grade_9								34				34
1241223	MD	school	2400420	13	Howard	240042001189	80	Homewood School	Alternative School	No	High	06	12	2020	grade_10								38				38
1241224	MD	school	2400420	13	Howard	240042001189	80	Homewood School	Alternative School	No	High	06	12	2020	grade_11								19				19
1241225	MD	school	2400420	13	Howard	240042001189	80	Homewood School	Alternative School	No	High	06	12	2020	grade_12								13				13
1241226	MD	school	2400420	13	Howard	240042001189	80	Homewood School	Alternative School	No	High	06	12	2020	pk_12_total	30	70	14	*	*		*	122	30	70	14	122
1242023	MD	school	2400480	15	Montgomery	240048001451	239	Alternative Programs	Alternative School	No	High	07	12	2020	grade_7								*
1242024	MD	school	2400480	15	Montgomery	240048001451	239	Alternative Programs	Alternative School	No	High	07	12	2020	grade_8								*
1242025	MD	school	2400480	15	Montgomery	240048001451	239	Alternative Programs	Alternative School	No	High	07	12	2020	grade_9								35				35
1242026	MD	school	2400480	15	Montgomery	240048001451	239	Alternative Programs	Alternative School	No	High	07	12	2020	grade_10								32				32
1242027	MD	school	2400480	15	Montgomery	240048001451	239	Alternative Programs	Alternative School	No	High	07	12	2020	grade_11								27				27
1242028	MD	school	2400480	15	Montgomery	240048001451	239	Alternative Programs	Alternative School	No	High	07	12	2020	grade_12								24				24
1242029	MD	school	2400480	15	Montgomery	240048001451	239	Alternative Programs	Alternative School	No	High	07	12	2020	pk_12_total	10	63	43		*		*	126	10	63	43	126
1243203	MD	school	2400510	16	Prince George's	240051000865	216	Annapolis Road Academy	Alternative School	No	Secondary	09	10	2020	grade_9								94				94
1243204	MD	school	2400510	16	Prince George's	240051000865	216	Annapolis Road Academy	Alternative School	No	Secondary	09	10	2020	grade_10								26				26
1243205	MD	school	2400510	16	Prince George's	240051000865	216	Annapolis Road Academy	Alternative School	No	Secondary	09	10	2020	pk_12_total		66	51				*	120		66	51	120
1243215	MD	school	2400510	16	Prince George's	240051001463	303	Croom High	Alternative School	No	High	11	12	2020	grade_11								*
1243216	MD	school	2400510	16	Prince George's	240051001463	303	Croom High	Alternative School	No	High	11	12	2020	grade_12								58				58
1243217	MD	school	2400510	16	Prince George's	240051001463	303	Croom High	Alternative School	No	High	11	12	2020	pk_12_total		62	*				*	65		62		65
1243294	MD	school	2400510	16	Prince George's	240051001047	608	Green Valley Academy at Edgar Allan Poe	Alternative School	No	Secondary	07	10	2020	grade_7								*
1243295	MD	school	2400510	16	Prince George's	240051001047	608	Green Valley Academy at Edgar Allan Poe	Alternative School	No	Secondary	07	10	2020	grade_8								*
1243296	MD	school	2400510	16	Prince George's	240051001047	608	Green Valley Academy at Edgar Allan Poe	Alternative School	No	Secondary	07	10	2020	grade_9								22				22
1243297	MD	school	2400510	16	Prince George's	240051001047	608	Green Valley Academy at Edgar Allan Poe	Alternative School	No	Secondary	07	10	2020	grade_10								12				12
1243298	MD	school	2400510	16	Prince George's	240051001047	608	Green Valley Academy at Edgar Allan Poe	Alternative School	No	Secondary	07	10	2020	pk_12_total	*	41	*	*			*	50		41		50
1243465	MD	school	2400510	16	Prince George's	240051001424	705	Tall Oaks High	Alternative School	No	High	11	12	2020	grade_11								27				27
1243466	MD	school	2400510	16	Prince George's	240051001424	705	Tall Oaks High	Alternative School	No	High	11	12	2020	grade_12								68				68
1243467	MD	school	2400510	16	Prince George's	240051001424	705	Tall Oaks High	Alternative School	No	High	11	12	2020	pk_12_total	*	63	25	*	*			95		63	25	95
1244558	MD	school	2400510	16	Prince George's	240051001054	2211	Northwestern Evening/Saturday High	Alternative School	No	High	09	12	2020	grade_9								132				132
1244559	MD	school	2400510	16	Prince George's	240051001054	2211	Northwestern Evening/Saturday High	Alternative School	No	High	09	12	2020	grade_10								133				133
1244560	MD	school	2400510	16	Prince George's	240051001054	2211	Northwestern Evening/Saturday High	Alternative School	No	High	09	12	2020	grade_11								96				96
1244561	MD	school	2400510	16	Prince George's	240051001054	2211	Northwestern Evening/Saturday High	Alternative School	No	High	09	12	2020	grade_12								120				120
1244562	MD	school	2400510	16	Prince George's	240051001054	2211	Northwestern Evening/Saturday High	Alternative School	No	High	09	12	2020	pk_12_total	*	64	401	*	*		*	481		64	401	481
1244563	MD	school	2400510	16	Prince George's	240051001062	2213	Crossland Evening/Saturday High	Alternative School	No	High	09	12	2020	grade_9								30				30
1244564	MD	school	2400510	16	Prince George's	240051001062	2213	Crossland Evening/Saturday High	Alternative School	No	High	09	12	2020	grade_10								49				49
1244565	MD	school	2400510	16	Prince George's	240051001062	2213	Crossland Evening/Saturday High	Alternative School	No	High	09	12	2020	grade_11								31				31
1244566	MD	school	2400510	16	Prince George's	240051001062	2213	Crossland Evening/Saturday High	Alternative School	No	High	09	12	2020	grade_12								118				118
1244567	MD	school	2400510	16	Prince George's	240051001062	2213	Crossland Evening/Saturday High	Alternative School	No	High	09	12	2020	pk_12_total	*	185	33	*			*	228		185	33	228
1244575	MD	school	2400510	16	Prince George's	240051001067	2220	Community Based Classrooms	Alternative School	No	High	12	12	2020	grade_12								75				75
1244576	MD	school	2400510	16	Prince George's	240051001067	2220	Community Based Classrooms	Alternative School	No	High	12	12	2020	pk_12_total	*	49	23			*	*	75		49	23	75
1245269	MD	school	2400690	22	Wicomico	240069001088	520	Wicomico County Evening High	Alternative School	No	High	09	12	2020	grade_9								20				20
1245270	MD	school	2400690	22	Wicomico	240069001088	520	Wicomico County Evening High	Alternative School	No	High	09	12	2020	grade_10								23				23
1245271	MD	school	2400690	22	Wicomico	240069001088	520	Wicomico County Evening High	Alternative School	No	High	09	12	2020	grade_11								28				28
1245272	MD	school	2400690	22	Wicomico	240069001088	520	Wicomico County Evening High	Alternative School	No	High	09	12	2020	grade_12								36				36
1245273	MD	school	2400690	22	Wicomico	240069001088	520	Wicomico County Evening High	Alternative School	No	High	09	12	2020	pk_12_total	38	55	10		*		*	107	38	55	10	107
1245980	MD	school	2400090	30	Baltimore City	240009001343	178	Excel Academy at Francis M. Wood High	Alternative School	No	High	08	12	2020	grade_8								*
1245981	MD	school	2400090	30	Baltimore City	240009001343	178	Excel Academy at Francis M. Wood High	Alternative School	No	High	08	12	2020	grade_9								179				179
1245982	MD	school	2400090	30	Baltimore City	240009001343	178	Excel Academy at Francis M. Wood High	Alternative School	No	High	08	12	2020	grade_10								200				200
1245983	MD	school	2400090	30	Baltimore City	240009001343	178	Excel Academy at Francis M. Wood High	Alternative School	No	High	08	12	2020	grade_11								125				125
1245984	MD	school	2400090	30	Baltimore City	240009001343	178	Excel Academy at Francis M. Wood High	Alternative School	No	High	08	12	2020	grade_12								134				134
1245985	MD	school	2400090	30	Baltimore City	240009001343	178	Excel Academy at Francis M. Wood High	Alternative School	No	High	08	12	2020	pk_12_total	*	620	10	*			*	642		620	10	642
1246727	MD	school	2400090	30	Baltimore City	240009000236	413	Achievement Academy at Harbor City High	Alternative School	No	High	09	12	2020	grade_9								133				133
1246728	MD	school	2400090	30	Baltimore City	240009000236	413	Achievement Academy at Harbor City High	Alternative School	No	High	09	12	2020	grade_10								150				150
1246729	MD	school	2400090	30	Baltimore City	240009000236	413	Achievement Academy at Harbor City High	Alternative School	No	High	09	12	2020	grade_11								79				79
1246730	MD	school	2400090	30	Baltimore City	240009000236	413	Achievement Academy at Harbor City High	Alternative School	No	High	09	12	2020	grade_12								71				71
1246731	MD	school	2400090	30	Baltimore City	240009000236	413	Achievement Academy at Harbor City High	Alternative School	No	High	09	12	2020	pk_12_total	*	404	26	*				433		404	26	433
1246808	MD	school	2400090	30	Baltimore City	240009000885	884	Eager Street Academy	Alternative School	No	High	08	12	2020	grade_8								*
1246809	MD	school	2400090	30	Baltimore City	240009000885	884	Eager Street Academy	Alternative School	No	High	08	12	2020	grade_9								19				19
1246810	MD	school	2400090	30	Baltimore City	240009000885	884	Eager Street Academy	Alternative School	No	High	08	12	2020	grade_10								16				16
1246811	MD	school	2400090	30	Baltimore City	240009000885	884	Eager Street Academy	Alternative School	No	High	08	12	2020	grade_11								*
1246812	MD	school	2400090	30	Baltimore City	240009000885	884	Eager Street Academy	Alternative School	No	High	08	12	2020	grade_12								*
1246813	MD	school	2400090	30	Baltimore City	240009000885	884	Eager Street Academy	Alternative School	No	High	08	12	2020	pk_12_total		43	*		*			46		43		46
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