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 school_state_id 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	total	total_int
1244944	MD	school	2400660	21	Washington	240066001674	40	Barbara Ingram School for the Arts	Regular School	No	High	09	12	2020	grade_12	72	72
1238184	MD	school	2400120	3	Baltimore County	240012001756	51	Northwest EDLP at Milford Mill Academy	Alternative School	No	High	11	12	2020	grade_12	*
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
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
1238196	MD	school	2400120	3	Baltimore County	240012001759	55	Southeast EDLP at Dundalk High School	Alternative School	No	High	10	12	2020	grade_12	11	11
1238198	MD	school	2400120	3	Baltimore County	240012001760	56	Central EDLP at Loch Raven High School	Alternative School	No	High	12	12	2020	grade_12	*
1238209	MD	school	2400120	3	Baltimore County	240012000935	58	Home Assignments-Secondary	Alternative School	No	High	07	12	2020	grade_12	*
1238217	MD	school	2400120	3	Baltimore County	240012000436	69	Catonsville Center for Alternative Studies	Alternative School	No	High	09	12	2020	grade_12	14	14
1238228	MD	school	2400120	3	Baltimore County	240012000831	72	Rosedale Center	Alternative School	No	High	06	12	2020	grade_12	*
1238235	MD	school	2400120	3	Baltimore County	240012001649	75	Crossroads Center	Alternative School	No	High	07	12	2020	grade_12	*
1238240	MD	school	2400120	3	Baltimore County	240012001711	77	BCDC Educational Center	Alternative School	No	High	09	12	2020	grade_12	*
1241225	MD	school	2400420	13	Howard	240042001189	80	Homewood School	Alternative School	No	High	06	12	2020	grade_12	13	13
1244887	MD	school	2400630	20	Talbot	240063001242	101	Easton High	Regular School	No	High	09	12	2020	grade_12	257	257
1243085	MD	school	2400510	16	Prince George's	240051001059	102	High Point High	Regular School	No	High	09	12	2020	grade_12	569	569
1244840	MD	school	2400570	19	Somerset	240057001213	102	Washington Academy and High School	Regular School	No	High	08	12	2020	grade_12	91	91
1245230	MD	school	2400690	22	Wicomico	240069001306	102	Mardela Middle & High	Regular School	No	High	06	12	2020	grade_12	84	84
1241769	MD	school	2400480	15	Montgomery	240048000918	104	Seneca Valley High	Regular School	No	High	09	12	2020	grade_12	249	249
1240037	MD	school	2400270	8	Charles	240027000596	106	La Plata High School	Regular School	No	High	09	12	2020	grade_12	271	271
1245369	MD	school	2400720	23	Worcester	240072001330	107	Pocomoke High	Regular School	No	High	09	12	2020	grade_12	92	92
1240042	MD	school	2400270	8	Charles	240027000600	108	Maurice J. McDonough High School	Regular School	No	High	09	12	2020	grade_12	188	188
1243120	MD	school	2400510	16	Prince George's	240051001354	108	James E. Duckworth Regional Center	Special Education School	No	Other	KG	12	2020	grade_12	*
1238295	MD	school	2400120	3	Baltimore County	240012000466	111	Maiden Choice School	Special Education School	No	Other	PK	12	2020	grade_12	20	20
1239380	MD	school	2400150	4	Calvert	240015000611	113	Patuxent High	Regular School	No	High	09	12	2020	grade_12	273	273
1241826	MD	school	2400480	15	Montgomery	240048001509	125	Quince Orchard High	Regular School	No	High	09	12	2020	grade_12	486	486
1241831	MD	school	2400480	15	Montgomery	240048000897	152	Poolesville High	Regular School	No	High	09	12	2020	grade_12	274	274
1238340	MD	school	2400120	3	Baltimore County	240012000502	172	Woodlawn High Center for Pre-Eng. Res.	Regular School	No	High	09	12	2020	grade_12	372	372
1238345	MD	school	2400120	3	Baltimore County	240012000355	174	Catonsville High	Regular School	No	High	09	12	2020	grade_12	411	411
1238350	MD	school	2400120	3	Baltimore County	240012000248	175	Western School of Technology & Env. Science	Career and Technical School	No	High	09	12	2020	grade_12	210	210
1240943	MD	school	2400390	12	Harford	240039000690	176	Edgewood High	Regular School	No	High	09	12	2020	grade_12	323	323
1245978	MD	school	2400090	30	Baltimore City	240009000219	177	George W. F. McMechen High	Special Education School	No	High	09	12	2020	grade_12	24	24
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
1240952	MD	school	2400390	12	Harford	240039000705	181	Joppatowne High	Regular School	No	High	09	12	2020	grade_12	156	156
1240961	MD	school	2400390	12	Harford	240039001638	187	Patterson Mill High School	Regular School	No	High	09	12	2020	grade_12	201	201
1241876	MD	school	2400480	15	Montgomery	240048000902	201	Richard Montgomery High	Regular School	No	High	09	12	2020	grade_12	623	623
1239586	MD	school	2400210	6	Carroll	240021000533	202	Francis Scott Key High	Regular School	No	High	09	12	2020	grade_12	245	245
1244907	MD	school	2400630	20	Talbot	240063001248	202	St. Michaels Middle/High School	Regular School	No	High	06	12	2020	grade_12	52	52
1241298	MD	school	2400420	13	Howard	240042000738	203	Howard High	Regular School	No	High	09	12	2020	grade_12	492	492
1239848	MD	school	2400240	7	Cecil	240024000558	204	Bohemia Manor High	Regular School	No	High	09	12	2020	grade_12	157	157
1244977	MD	school	2400660	21	Washington	240066001295	204	Williamsport High	Regular School	No	High	09	12	2020	grade_12	183	183
1239416	MD	school	2400150	4	Calvert	240015000509	206	Calvert Country School	Special Education School	No	Other	03	12	2020	grade_12	10	10
1240284	MD	school	2400300	9	Dorchester	240030000618	207	North Dorchester High School	Regular School	No	High	09	12	2020	grade_12	102	102
1241310	MD	school	2400420	13	Howard	240042000743	207	Mount Hebron High	Regular School	No	High	09	12	2020	grade_12	415	415
1245386	MD	school	2400720	23	Worcester	240072001334	207	Snow Hill High	Regular School	No	High	09	12	2020	grade_12	67	67
1240387	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	06	12	2020	grade_12	*
1243166	MD	school	2400510	16	Prince George's	240051000987	208	Bladensburg High	Regular School	No	High	09	12	2020	grade_12	404	404
1240392	MD	school	2400330	10	Frederick	240033000632	209	Frederick High	Regular School	No	High	09	12	2020	grade_12	379	379
1239445	MD	school	2400150	4	Calvert	240015000508	213	Calvert High	Regular School	No	High	09	12	2020	grade_12	313	313
1240409	MD	school	2400330	10	Frederick	240033000634	213	Gov. Thomas Johnson High	Regular School	No	High	09	12	2020	grade_12	422	422
1241345	MD	school	2400420	13	Howard	240042000722	214	Centennial High	Regular School	No	High	09	12	2020	grade_12	410	410
1239462	MD	school	2400150	4	Calvert	240015001342	217	Huntingtown High School	Regular School	No	High	09	12	2020	grade_12	355	355
1241986	MD	school	2400480	15	Montgomery	240048000912	230	Rockville High	Regular School	No	High	09	12	2020	grade_12	366	366
1242002	MD	school	2400480	15	Montgomery	240048000934	234	Thomas S. Wootton High	Regular School	No	High	09	12	2020	grade_12	541	541
1242028	MD	school	2400480	15	Montgomery	240048001451	239	Alternative Programs	Alternative School	No	High	07	12	2020	grade_12	24	24
1246273	MD	school	2400090	30	Baltimore City	240009000157	239	Benjamin Franklin High School at Masonville Cove	Regular School	No	High	09	12	2020	grade_12	92	92
1242056	MD	school	2400480	15	Montgomery	240048001040	246	Northwest High	Regular School	No	High	09	12	2020	grade_12	523	523
1242069	MD	school	2400480	15	Montgomery	240048001541	249	Clarksburg High	Regular School	No	High	09	12	2020	grade_12	575	575
1240998	MD	school	2400390	12	Harford	240039000679	270	Aberdeen High	Regular School	No	High	09	12	2020	grade_12	331	331
1238470	MD	school	2400120	3	Baltimore County	240012000432	271	Milford Mill Academy	Regular School	No	High	09	12	2020	grade_12	281	281
1238475	MD	school	2400120	3	Baltimore County	240012000458	272	Randallstown High	Regular School	No	High	09	12	2020	grade_12	238	238
1241004	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	08	12	2020	grade_12	12	12
1241714	MD	school	2400450	14	Kent	240045000768	301	Kent County High	Regular School	No	High	09	12	2020	grade_12	121	121
1244601	MD	school	2400540	17	Queen Anne's	240054001195	301	Queen Anne's County High School	Regular School	No	High	09	12	2020	grade_12	286	286
1244982	MD	school	2400660	21	Washington	240066001288	301	South Hagerstown High	Regular School	No	High	09	12	2020	grade_12	268	268
1246443	MD	school	2400090	30	Baltimore City	240009000336	301	William S. Baer School	Special Education School	No	Other	PK	12	2020	grade_12	12	12
1239865	MD	school	2400240	7	Cecil	240024000568	302	Elkton High	Regular School	No	High	09	12	2020	grade_12	229	229
1243216	MD	school	2400510	16	Prince George's	240051001463	303	Croom High	Alternative School	No	High	11	12	2020	grade_12	58	58
1244693	MD	school	2400600	18	Saint Mary's	240060001218	303	Chopticon High	Regular School	No	High	09	12	2020	grade_12	375	375
1241009	MD	school	2400390	12	Harford	240039000694	304	Harford Technical High	Career and Technical School	No	High	09	12	2020	grade_12	234	234
1244997	MD	school	2400660	21	Washington	240066000308	305	Washington County Technical High	Career and Technical School	No	High	11	12	2020	grade_12	304	304
1244702	MD	school	2400600	18	Saint Mary's	240060001356	306	Leonardtown High	Regular School	No	High	09	12	2020	grade_12	487	487
1246449	MD	school	2400090	30	Baltimore City	240009000176	307	Claremont School	Special Education School	No	High	08	12	2020	grade_12	28	28
1241414	MD	school	2400420	13	Howard	240042001437	308	Marriotts Ridge High	Regular School	No	High	09	12	2020	grade_12	359	359
1245400	MD	school	2400720	23	Worcester	240072001335	310	Stephen Decatur High	Regular School	No	High	09	12	2020	grade_12	296	296
1240472	MD	school	2400330	10	Frederick	240033000641	313	Middletown High	Regular School	No	High	09	12	2020	grade_12	263	263
1239482	MD	school	2400150	4	Calvert	240015000516	314	Northern High	Regular School	No	High	09	12	2020	grade_12	354	354
1242154	MD	school	2400480	15	Montgomery	240048000890	315	Paint Branch High	Regular School	No	High	09	12	2020	grade_12	433	433
1242166	MD	school	2400480	15	Montgomery	240048001044	321	James Hubert Blake High	Regular School	No	High	09	12	2020	grade_12	431	431
1246498	MD	school	2400090	30	Baltimore City	240009001302	325	ConneXions: A Community Based Arts School	Regular School	Yes	High	06	12	2020	grade_12	59	59
1246542	MD	school	2400090	30	Baltimore City	240009001632	333	Independence School Local I	Regular School	Yes	High	09	12	2020	grade_12	20	20
1246571	MD	school	2400090	30	Baltimore City	240009001663	341	The Reach! Partnership School	Regular School	No	High	09	12	2020	grade_12	118	118
1246579	MD	school	2400090	30	Baltimore City	240009001662	345	Joseph C. Briscoe Academy	Special Education School	No	High	06	12	2020	grade_12	10	10
1246607	MD	school	2400090	30	Baltimore City	240009001682	348	Baltimore Leadership School for Young Women	Regular School	Yes	High	06	12	2020	grade_12	51	51
1246615	MD	school	2400090	30	Baltimore City	240009001678	349	N.A.C.A. Freedom and Democracy Academy II	Regular School	No	High	06	12	2020	grade_12	31	31
1246620	MD	school	2400090	30	Baltimore City	240009001735	362	Bard High School Early College	Regular School	No	High	09	12	2020	grade_12	104	104
1246628	MD	school	2400090	30	Baltimore City	240009001675	364	Bluford Drew Jemison STEM Academy West	Regular School	No	High	06	12	2020	grade_12	20	20
1238529	MD	school	2400120	3	Baltimore County	240012000449	371	Pikesville High	Regular School	No	High	09	12	2020	grade_12	214	214
1241098	MD	school	2400390	12	Harford	240039000683	373	Bel Air High	Regular School	No	High	09	12	2020	grade_12	388	388
1246669	MD	school	2400090	30	Baltimore City	240009001690	376	City Neighbors High	Regular School	Yes	High	09	12	2020	grade_12	95	95
1246677	MD	school	2400090	30	Baltimore City	240009001691	377	Green Street Academy	Regular School	Yes	High	06	12	2020	grade_12	109	109
1241107	MD	school	2400390	12	Harford	240039000691	382	Fallston High	Regular School	No	High	09	12	2020	grade_12	253	253
1246685	MD	school	2400090	30	Baltimore City	240009001703	382	Baltimore Design School	Regular School	No	High	06	12	2020	grade_12	74	74
1241112	MD	school	2400390	12	Harford	240039001380	385	C. Milton Wright High	Regular School	No	High	09	12	2020	grade_12	373	373
1241131	MD	school	2400390	12	Harford	240039000703	391	John Archer School	Special Education School	No	Other	PK	12	2020	grade_12	49	49
1246700	MD	school	2400090	30	Baltimore City	240009000194	400	Edmondson-Westside High	Career and Technical School	No	High	09	12	2020	grade_12	220	220
1245425	MD	school	2400720	23	Worcester	240072001326	401	Cedar Chapel Special School	Special Education School	No	Other	PK	12	2020	grade_12	15	15
1245027	MD	school	2400660	21	Washington	240066001260	403	Clear Spring High	Regular School	No	High	09	12	2020	grade_12	85	85
1246705	MD	school	2400090	30	Baltimore City	240009000151	403	Baltimore Polytechnic Institute	Regular School	No	High	09	12	2020	grade_12	376	376
1241419	MD	school	2400420	13	Howard	240042000731	404	Glenelg High	Regular School	No	High	09	12	2020	grade_12	307	307
1237234	MD	school	2400030	1	Allegany	240003000015	405	Fort Hill High	Regular School	No	High	09	12	2020	grade_12	170	170
1244632	MD	school	2400540	17	Queen Anne's	240054001076	405	Kent Island High School	Regular School	No	High	09	12	2020	grade_12	328	328
1246710	MD	school	2400090	30	Baltimore City	240009000297	405	Patterson High	Career and Technical School	No	High	09	12	2020	grade_12	192	192