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 ccd_school_high_grade 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	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
1238002	MD	school	2400060	2	Anne Arundel	240006001746	4102	Carrie Weedon Early Education Center	Regular School	No	Prekindergarten	PK	PK	2020	pk_12_total	36	*	17		*			61	36		17					61
1242617	MD	school	2400480	15	Montgomery	240048001635	587	PEP - Itinerant	Special Education School	No	Prekindergarten	PK	PK	2020	pk_12_total	43	18	16	*	16		*	100	43	18	16		16			100
1243107	MD	school	2400510	16	Prince George's	240051001134	107	Frances Fuchs Early Childhood Center	Special Education School	No	Prekindergarten	PK	PK	2020	pk_12_total	18	120	167	*	14		*	324	18	120	167		14			324
1243860	MD	school	2400510	16	Prince George's	240051001731	1313	Kenmoor Early Childhood Center	Special Education School	No	Prekindergarten	PK	PK	2020	pk_12_total	12	127	141	*	*			288	12	127	141					288
1244040	MD	school	2400510	16	Prince George's	240051001003	1433	Chapel Forge Early Childhood Center	Special Education School	No	Prekindergarten	PK	PK	2020	pk_12_total	14	178	43	*	12		*	254	14	178	43		12			254
1244326	MD	school	2400510	16	Prince George's	240051001053	1822	H. W. Wheatley Early Childhood Center	Special Education School	No	Prekindergarten	PK	PK	2020	pk_12_total	*	244	39		10		*	301		244	39		10			301
1244578	MD	school	2400510	16	Prince George's	240051001476	2300	Prekindergarten Offsites	Regular School	No	Prekindergarten	PK	PK	2020	pk_12_total	*	12	*				*	16		12						16
1237392	MD	school	2400060	2	Anne Arundel	240006000066	1102	Ferndale Early Education Center	Regular School	No	Elementary	PK	KG	2020	pk_12_total	76	33	28	*	*		*	151	76	33	28					151
1237858	MD	school	2400060	2	Anne Arundel	240006000140	3232	West Meade Early Education Center	Regular School	No	Elementary	PK	KG	2020	pk_12_total	123	33	64	*	14		21	256	123	33	64		14		21	256
1238213	MD	school	2400120	3	Baltimore County	240012000012	62	Campfield Early Childhood Center	Regular School	No	Elementary	PK	KG	2020	pk_12_total	27	273	64	*	25		19	410	27	273	64		25		19	410
1245836	MD	school	2400090	30	Baltimore City	240009000265	86	Lakewood Elementary	Regular School	No	Elementary	PK	KG	2020	pk_12_total		73	*				*	83		73						83
1237235	MD	school	2400030	1	Allegany	240003000015	405	Fort Hill High	Regular School	No	High	09	12	2020	pk_12_total	578	38	10		*		44	672	578	38	10				44	672
1237254	MD	school	2400030	1	Allegany	240003000030	601	Center for Career & Technical Education	Career and Technical School	No	High	11	12	2020	pk_12_total	193		*				*	203	193							203
1237267	MD	school	2400030	1	Allegany	240003000001	606	Allegany High	Regular School	No	High	09	12	2020	pk_12_total	631	21	15	*	11		41	721	631	21	15		11		41	721
1237328	MD	school	2400030	1	Allegany	240003001636	2404	Mountain Ridge High School	Regular School	No	High	09	12	2020	pk_12_total	729	17	*	*	*		24	784	729	17					24	784
1237361	MD	school	2400060	2	Anne Arundel	240006000075	1033	Glen Burnie High	Regular School	No	High	09	12	2020	pk_12_total	812	624	420	*	86	*	120	2076	812	624	420		86		120	2076
1237519	MD	school	2400060	2	Anne Arundel	240006090441	1323	North County High	Regular School	No	High	09	12	2020	pk_12_total	1017	593	414	*	119	*	133	2286	1017	593	414		119		133	2286
1237524	MD	school	2400060	2	Anne Arundel	240006000127	2013	Severna Park High	Regular School	No	High	09	12	2020	pk_12_total	1589	77	97	*	81	*	84	1932	1589	77	97		81		84	1932
1237529	MD	school	2400060	2	Anne Arundel	240006000103	2023	Northeast High	Regular School	No	High	09	12	2020	pk_12_total	996	123	133	*	34	*	72	1367	996	123	133		34		72	1367
1237670	MD	school	2400060	2	Anne Arundel	240006000899	2233	Anne Arundel Evening High	Alternative School	No	High	09	12	2020	pk_12_total	150	66	55	*	*		22	296	150	66	55				22	296
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
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
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
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
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
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
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
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
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
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
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
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
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		*	*					*
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
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
1238197	MD	school	2400120	3	Baltimore County	240012001759	55	Southeast EDLP at Dundalk High School	Alternative School	No	High	10	12	2020	pk_12_total	*	10	*				*	18		10						18
1238199	MD	school	2400120	3	Baltimore County	240012001760	56	Central EDLP at Loch Raven High School	Alternative School	No	High	12	12	2020	pk_12_total	*	*						*
1238210	MD	school	2400120	3	Baltimore County	240012000935	58	Home Assignments-Secondary	Alternative School	No	High	07	12	2020	pk_12_total	*	17					*	26		17						26
1238218	MD	school	2400120	3	Baltimore County	240012000436	69	Catonsville Center for Alternative Studies	Alternative School	No	High	09	12	2020	pk_12_total	*	45	*		*		*	55		45						55
1238229	MD	school	2400120	3	Baltimore County	240012000831	72	Rosedale Center	Alternative School	No	High	06	12	2020	pk_12_total	21	36	*				*	65	21	36						65
1238236	MD	school	2400120	3	Baltimore County	240012001649	75	Crossroads Center	Alternative School	No	High	07	12	2020	pk_12_total	58	97	*	*	*		16	183	58	97					16	183
1238241	MD	school	2400120	3	Baltimore County	240012001711	77	BCDC Educational Center	Alternative School	No	High	09	12	2020	pk_12_total	*	24	*					33		24						33
1238296	MD	school	2400120	3	Baltimore County	240012000466	111	Maiden Choice School	Special Education School	No	Other	PK	12	2020	pk_12_total	33	72	*		20		*	137	33	72			20			137
1238341	MD	school	2400120	3	Baltimore County	240012000502	172	Woodlawn High Center for Pre-Eng. Res.	Regular School	No	High	09	12	2020	pk_12_total	41	1277	229	*	82	*	21	1656	41	1277	229		82		21	1656
1238346	MD	school	2400120	3	Baltimore County	240012000355	174	Catonsville High	Regular School	No	High	09	12	2020	pk_12_total	929	462	110	*	223	*	95	1826	929	462	110		223		95	1826
1238351	MD	school	2400120	3	Baltimore County	240012000248	175	Western School of Technology & Env. Science	Career and Technical School	No	High	09	12	2020	pk_12_total	120	515	47	*	183	*	25	892	120	515	47		183		25	892
1238471	MD	school	2400120	3	Baltimore County	240012000432	271	Milford Mill Academy	Regular School	No	High	09	12	2020	pk_12_total	15	1118	68	*	17	*	28	1251	15	1118	68		17		28	1251
1238476	MD	school	2400120	3	Baltimore County	240012000458	272	Randallstown High	Regular School	No	High	09	12	2020	pk_12_total	14	951	44	*	23		15	1048	14	951	44		23		15	1048
1238530	MD	school	2400120	3	Baltimore County	240012000449	371	Pikesville High	Regular School	No	High	09	12	2020	pk_12_total	301	464	76	*	54	*	21	922	301	464	76		54		21	922
1238602	MD	school	2400120	3	Baltimore County	240012001347	452	Owings Mills High	Regular School	No	High	09	12	2020	pk_12_total	77	642	385	*	54	*	25	1189	77	642	385		54		25	1189
1238607	MD	school	2400120	3	Baltimore County	240012000390	472	Franklin High	Regular School	No	High	09	12	2020	pk_12_total	481	667	165	*	109	*	82	1511	481	667	165		109		82	1511
1238612	MD	school	2400120	3	Baltimore County	240012001547	473	New Town High	Regular School	No	High	09	12	2020	pk_12_total	22	1067	31		11		37	1168	22	1067	31		11		37	1168
1238639	MD	school	2400120	3	Baltimore County	240012001432	772	Hereford High	Regular School	No	High	09	12	2020	pk_12_total	1120	31	56		49		39	1295	1120	31	56		49		39	1295
1238724	MD	school	2400120	3	Baltimore County	240012000373	872	Dulaney High	Regular School	No	High	09	12	2020	pk_12_total	979	393	199	*	257	*	79	1914	979	393	199		257		79	1914
1238817	MD	school	2400120	3	Baltimore County	240012000483	922	Ridge Ruxton	Special Education School	No	Other	PK	12	2020	pk_12_total	38	42	15	*	19		*	123	38	42	15		19			123
1238849	MD	school	2400120	3	Baltimore County	240012000487	971	Towson High Law & Public Policy	Regular School	No	High	09	12	2020	pk_12_total	1003	292	88	*	144		89	1619	1003	292	88		144		89	1619
1238854	MD	school	2400120	3	Baltimore County	240012000443	972	Parkville High & Center for Math/Science	Regular School	No	High	09	12	2020	pk_12_total	460	873	492	10	162	*	74	2074	460	873	492	10	162		74	2074
1238859	MD	school	2400120	3	Baltimore County	240012000420	973	Loch Raven High	Regular School	No	High	09	12	2020	pk_12_total	347	379	64	*	39	*	41	874	347	379	64		39		41	874
1238864	MD	school	2400120	3	Baltimore County	240012000230	975	George W. Carver Center for Arts & Technology	Career and Technical School	No	High	09	12	2020	pk_12_total	439	349	58	*	63	*	44	961	439	349	58		63		44	961
1238948	MD	school	2400120	3	Baltimore County	240012000446	1171	Perry Hall High	Regular School	No	High	09	12	2020	pk_12_total	939	591	93	*	255	*	85	1969	939	591	93		255		85	1969
1239008	MD	school	2400120	3	Baltimore County	240012000346	1215	Battle Monument School	Special Education School	No	Other	PK	12	2020	pk_12_total	30	19	*		*		*	63	30	19						63
1239043	MD	school	2400120	3	Baltimore County	240012000444	1272	Patapsco High & Center for Arts	Regular School	No	High	09	12	2020	pk_12_total	820	331	148	15	15	*	104	1434	820	331	148	15	15		104	1434
1239048	MD	school	2400120	3	Baltimore County	240012000377	1273	Dundalk High	Regular School	No	High	09	12	2020	pk_12_total	690	349	593	14	43	*	89	1782	690	349	593	14	43		89	1782
1239109	MD	school	2400120	3	Baltimore County	240012000416	1371	Lansdowne High & Academy of Finance	Regular School	No	High	09	12	2020	pk_12_total	494	329	335	*	110		52	1326	494	329	335		110		52	1326
1239162	MD	school	2400120	3	Baltimore County	240012000438	1473	Overlea High	Regular School	No	High	09	12	2020	pk_12_total	173	665	105	*	28	*	45	1020	173	665	105		28		45	1020
1239341	MD	school	2400120	3	Baltimore County	240012000412	1572	Kenwood High IB and Sports Science	Regular School	No	High	09	12	2020	pk_12_total	648	677	172	10	40	*	100	1649	648	677	172	10	40		100	1649
1239346	MD	school	2400120	3	Baltimore County	240012000477	1573	Sparrows Point High	Regular School	No	High	09	12	2020	pk_12_total	881	79	52	*	10	*	41	1067	881	79	52		10		41	1067
1239351	MD	school	2400120	3	Baltimore County	240012000362	1574	Chesapeake High	Regular School	No	High	09	12	2020	pk_12_total	267	525	102	*	*	*	50	961	267	525	102				50	961
1239356	MD	school	2400120	3	Baltimore County	240012000379	1575	Eastern Technical High School	Career and Technical School	No	High	09	12	2020	pk_12_total	562	235	57	*	257	*	55	1172	562	235	57		257		55	1172
1239381	MD	school	2400150	4	Calvert	240015000611	113	Patuxent High	Regular School	No	High	09	12	2020	pk_12_total	698	186	65	*	24	*	85	1063	698	186	65		24		85	1063
1239417	MD	school	2400150	4	Calvert	240015000509	206	Calvert Country School	Special Education School	No	Other	03	12	2020	pk_12_total	29	*	*	*	*		*	46	29							46
1239446	MD	school	2400150	4	Calvert	240015000508	213	Calvert High	Regular School	No	High	09	12	2020	pk_12_total	737	224	81	*	21	*	93	1161	737	224	81		21		93	1161
1239463	MD	school	2400150	4	Calvert	240015001342	217	Huntingtown High School	Regular School	No	High	09	12	2020	pk_12_total	1085	116	83	*	25		97	1408	1085	116	83		25		97	1408
1239483	MD	school	2400150	4	Calvert	240015000516	314	Northern High	Regular School	No	High	09	12	2020	pk_12_total	1101	163	92	*	28	*	97	1484	1101	163	92		28		97	1484
1239512	MD	school	2400150	4	Calvert	240015001344	500	Calvert County Alternative School	Alternative School	No	High	09	12	2020	pk_12_total	*	*	*					*
1239561	MD	school	2400180	5	Caroline	240018000523	703	North Caroline High School	Regular School	No	High	09	12	2020	pk_12_total	728	111	210	*	11	*	72	1138	728	111	210		11		72	1138
1239566	MD	school	2400180	5	Caroline	240018000518	801	Colonel Richardson High School	Regular School	No	High	09	12	2020	pk_12_total	318	125	33		11		26	513	318	125	33		11		26	513
1239587	MD	school	2400210	6	Carroll	240021000533	202	Francis Scott Key High	Regular School	No	High	09	12	2020	pk_12_total	811	31	39	*	*	*	28	922	811	31	39				28	922
1239651	MD	school	2400210	6	Carroll	240021001394	507	Liberty High	Regular School	No	High	09	12	2020	pk_12_total	861	44	54	*	43	*	33	1044	861	44	54		43		33	1044
1239668	MD	school	2400210	6	Carroll	240021001161	510	Century High	Regular School	No	High	09	12	2020	pk_12_total	945	50	73	*	40	*	27	1139	945	50	73		40		27	1139
1239681	MD	school	2400210	6	Carroll	240021001672	602	Manchester Valley High	Regular School	No	High	09	12	2020	pk_12_total	1169	32	70	*	30		22	1325	1169	32	70		30		22	1325
1239702	MD	school	2400210	6	Carroll	240021001185	704	Winters Mill High	Regular School	No	High	09	12	2020	pk_12_total	792	75	126	*	34	*	48	1079	792	75	126		34		48	1079
1239715	MD	school	2400210	6	Carroll	240021000552	707	Westminster High	Regular School	No	High	09	12	2020	pk_12_total	1289	60	69		48	*	55	1522	1289	60	69		48		55	1522
1239744	MD	school	2400210	6	Carroll	240021000527	712	Carroll Springs School	Special Education School	No	Other	PK	12	2020	pk_12_total	26	*	*		*			33	26							33
1239764	MD	school	2400210	6	Carroll	240021001548	716	Gateway School	Alternative School	No	High	09	12	2020	pk_12_total	54	*	*	*	*		*	66	54							66
1239766	MD	school	2400210	6	Carroll	240021001348	717	Post Secondary Program	Alternative School	No	High	12	12	2020	pk_12_total	41	*	*					44	41							44
1239802	MD	school	2400210	6	Carroll	240021001350	903	Flexible Student Support	Alternative School	No	High	09	12	2020	pk_12_total	19				*		*	22	19							22
1239836	MD	school	2400210	6	Carroll	240021000546	1401	South Carroll High	Regular School	No	High	09	12	2020	pk_12_total	881	18	68	*	22	*	17	1011	881	18	68		22		17	1011
1239849	MD	school	2400240	7	Cecil	240024000558	204	Bohemia Manor High	Regular School	No	High	09	12	2020	pk_12_total	539	39	42	*	*		25	647	539	39	42				25	647
1239866	MD	school	2400240	7	Cecil	240024000568	302	Elkton High	Regular School	No	High	09	12	2020	pk_12_total	480	288	128	*	13	*	91	1005	480	288	128		13		91	1005
1239955	MD	school	2400240	7	Cecil	240024000575	514	North East High	Regular School	No	High	09	12	2020	pk_12_total	840	62	55	*	12		42	1016	840	62	55		12		42	1016
1240000	MD	school	2400240	7	Cecil	240024000577	705	Perryville High	Regular School	No	High	09	12	2020	pk_12_total	661	39	41	*	*	*	50	801	661	39	41				50	801
1240021	MD	school	2400240	7	Cecil	240024090469	905	Rising Sun High	Regular School	No	High	09	12	2020	pk_12_total	990	*	59	*	11		28	1100	990		59		11		28	1100
1240038	MD	school	2400270	8	Charles	240027000596	106	La Plata High School	Regular School	No	High	09	12	2020	pk_12_total	750	225	57	*	33	*	88	1159	750	225	57		33		88	1159
1240043	MD	school	2400270	8	Charles	240027000600	108	Maurice J. McDonough High School	Regular School	No	High	09	12	2020	pk_12_total	287	438	95	*	20	*	60	902	287	438	95		20		60	902
1240084	MD	school	2400270	8	Charles	240027000607	605	Thomas Stone High School	Regular School	No	High	09	12	2020	pk_12_total	161	703	189	*	15	*	54	1128	161	703	189		15		54	1128
1240153	MD	school	2400270	8	Charles	240027000144	619	Westlake High School	Regular School	No	High	09	12	2020	pk_12_total	74	866	91	*	45	*	59	1140	74	866	91		45		59	1140
1240178	MD	school	2400270	8	Charles	240027001416	623	North Point High School	Regular School	No	High	09	12	2020	pk_12_total	295	1112	135	*	114	*	146	1814	295	1112	135		114		146	1814
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
1240251	MD	school	2400270	8	Charles	240027001727	802	St. Charles High School	Regular School	No	High	09	12	2020	pk_12_total	175	1005	90	11	29	*	97	1410	175	1005	90	11	29		97	1410
1240272	MD	school	2400270	8	Charles	240027000597	1002	Henry E. Lackey High School	Regular School	No	High	09	12	2020	pk_12_total	283	563	47	12	20	*	64	990	283	563	47	12	20		64	990