schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 53 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 and rowid > :p3 order by 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	total	total_int
1317554	MD	school	2400660	21	Washington	240066001288	301	South Hagerstown High	Regular School	No	High	09	12	2021	grade_9	467	467
1317599	MD	school	2400660	21	Washington	240066001260	403	Clear Spring High	Regular School	No	High	09	12	2021	grade_9	127	127
1317607	MD	school	2400660	21	Washington	240066001270	501	Hancock Middle Senior High	Regular School	No	High	06	12	2021	grade_9	43	43
1317620	MD	school	2400660	21	Washington	240066001256	601	Boonsboro High	Regular School	No	High	09	12	2021	grade_9	233	233
1317637	MD	school	2400660	21	Washington	240066001285	701	Smithsburg High	Regular School	No	High	09	12	2021	grade_9	204	204
1317740	MD	school	2400660	21	Washington	240066001275	2101	North Hagerstown High	Regular School	No	High	09	12	2021	grade_9	392	392
1317771	MD	school	2400660	21	Washington	240066001289	2505	Marshall Street School	Special Education School	No	Other	PK	12	2021	grade_9	*
1317803	MD	school	2400690	22	Wicomico	240069001306	102	Mardela Middle & High	Regular School	No	High	06	12	2021	grade_9	102	102
1317830	MD	school	2400690	22	Wicomico	240069001320	513	Wicomico High	Regular School	No	High	09	12	2021	grade_9	307	307
1317845	MD	school	2400690	22	Wicomico	240069001088	520	Wicomico County Evening High	Alternative School	No	High	09	12	2021	grade_9	11	11
1317898	MD	school	2400690	22	Wicomico	240069001305	1307	James M. Bennett High	Regular School	No	High	09	12	2021	grade_9	351	351
1317907	MD	school	2400690	22	Wicomico	240069001309	1309	Parkside High	Regular School	No	High	09	12	2021	grade_9	285	285
1317942	MD	school	2400720	23	Worcester	240072001330	107	Pocomoke High	Regular School	No	High	09	12	2021	grade_9	79	79
1317959	MD	school	2400720	23	Worcester	240072001334	207	Snow Hill High	Regular School	No	High	09	12	2021	grade_9	80	80
1317973	MD	school	2400720	23	Worcester	240072001335	310	Stephen Decatur High	Regular School	No	High	09	12	2021	grade_9	341	341
1317998	MD	school	2400720	23	Worcester	240072001326	401	Cedar Chapel Special School	Special Education School	No	Other	PK	12	2021	grade_9	*
1318544	MD	school	2400090	30	Baltimore City	240009001343	178	Excel Academy at Francis M. Wood High	Alternative School	No	High	09	12	2021	grade_9	176	176
1318832	MD	school	2400090	30	Baltimore City	240009000157	239	Benjamin Franklin High School at Masonville Cove	Regular School	No	High	09	12	2021	grade_9	284	284
1318991	MD	school	2400090	30	Baltimore City	240009000336	301	William S. Baer School	Special Education School	No	Other	PK	12	2021	grade_9	10	10
1318997	MD	school	2400090	30	Baltimore City	240009000176	307	Claremont School	Special Education School	No	High	07	12	2021	grade_9	10	10
1319046	MD	school	2400090	30	Baltimore City	240009001302	325	ConneXions: A Community Based Arts School	Regular School	Yes	High	06	12	2021	grade_9	109	109
1319090	MD	school	2400090	30	Baltimore City	240009001632	333	Independence School Local I	Regular School	Yes	High	09	12	2021	grade_9	55	55
1319118	MD	school	2400090	30	Baltimore City	240009001663	341	The Reach! Partnership School	Regular School	No	High	09	12	2021	grade_9	255	255
1319126	MD	school	2400090	30	Baltimore City	240009001662	345	Joseph C. Briscoe Academy	Special Education School	No	High	06	12	2021	grade_9	*
1319154	MD	school	2400090	30	Baltimore City	240009001682	348	Baltimore Leadership School for Young Women	Regular School	Yes	High	06	12	2021	grade_9	75	75
1319159	MD	school	2400090	30	Baltimore City	240009001735	362	Bard High School Early College	Regular School	No	High	09	12	2021	grade_9	112	112
1319167	MD	school	2400090	30	Baltimore City	240009001675	364	Bluford Drew Jemison STEM Academy West	Regular School	No	High	06	12	2021	grade_9	72	72
1319209	MD	school	2400090	30	Baltimore City	240009001690	376	City Neighbors High	Regular School	Yes	High	09	12	2021	grade_9	116	116
1319217	MD	school	2400090	30	Baltimore City	240009001691	377	Green Street Academy	Regular School	Yes	High	06	12	2021	grade_9	128	128
1319225	MD	school	2400090	30	Baltimore City	240009001703	382	Baltimore Design School	Regular School	No	High	06	12	2021	grade_9	86	86
1319242	MD	school	2400090	30	Baltimore City	240009000194	400	Edmondson-Westside High	Career and Technical School	No	High	09	12	2021	grade_9	269	269
1319247	MD	school	2400090	30	Baltimore City	240009000151	403	Baltimore Polytechnic Institute	Regular School	No	High	09	12	2021	grade_9	413	413
1319252	MD	school	2400090	30	Baltimore City	240009000297	405	Patterson High	Career and Technical School	No	High	09	12	2021	grade_9	362	362
1319257	MD	school	2400090	30	Baltimore City	240009000203	406	Forest Park High	Regular School	No	High	09	12	2021	grade_9	249	249
1319262	MD	school	2400090	30	Baltimore City	240009000330	407	Western High	Regular School	No	High	09	12	2021	grade_9	351	351
1319267	MD	school	2400090	30	Baltimore City	240009000280	410	Mergenthaler Vocational-Technical High	Career and Technical School	No	High	09	12	2021	grade_9	584	584
1319272	MD	school	2400090	30	Baltimore City	240009000236	413	Achievement Academy at Harbor City High	Alternative School	No	High	09	12	2021	grade_9	107	107
1319277	MD	school	2400090	30	Baltimore City	240009000298	414	Paul Laurence Dunbar High	Regular School	No	High	09	12	2021	grade_9	261	261
1319282	MD	school	2400090	30	Baltimore City	240009001391	415	Baltimore School for the Arts	Regular School	No	High	09	12	2021	grade_9	103	103
1319287	MD	school	2400090	30	Baltimore City	240009001313	416	Digital Harbor High School	Career and Technical School	No	High	09	12	2021	grade_9	582	582
1319292	MD	school	2400090	30	Baltimore City	240009001331	419	Reginald F. Lewis High	Regular School	No	High	09	12	2021	grade_9	232	232
1319300	MD	school	2400090	30	Baltimore City	240009001339	421	National Academy Foundation	Regular School	No	High	06	12	2021	grade_9	233	233
1319305	MD	school	2400090	30	Baltimore City	240009001559	422	New Era Academy	Regular School	No	High	09	12	2021	grade_9	142	142
1319313	MD	school	2400090	30	Baltimore City	240009001381	427	Academy for College and Career Exploration	Regular School	No	High	06	12	2021	grade_9	214	214
1319318	MD	school	2400090	30	Baltimore City	240009001385	429	Vivien T. Thomas Medical Arts Academy	Career and Technical School	No	High	09	12	2021	grade_9	175	175
1319323	MD	school	2400090	30	Baltimore City	240009001387	430	Augusta Fells Savage Institute of Visual Arts	Regular School	No	High	09	12	2021	grade_9	146	146
1319328	MD	school	2400090	30	Baltimore City	240009001530	432	Coppin Academy	Regular School	Yes	High	09	12	2021	grade_9	120	120
1319333	MD	school	2400090	30	Baltimore City	240009001531	433	Renaissance Academy	Regular School	No	High	09	12	2021	grade_9	122	122
1319338	MD	school	2400090	30	Baltimore City	240009000209	450	Frederick Douglass High	Regular School	No	High	09	12	2021	grade_9	301	301
1319343	MD	school	2400090	30	Baltimore City	240009000168	454	Carver Vocational-Technical High	Career and Technical School	No	High	09	12	2021	grade_9	353	353
1319348	MD	school	2400090	30	Baltimore City	240009000150	480	Baltimore City College	Regular School	No	High	09	12	2021	grade_9	412	412
1319353	MD	school	2400090	30	Baltimore City	240009000885	884	Eager Street Academy	Alternative School	No	High	09	12	2021	grade_9	12	12
1319361	MD	school	2400027	32	SEED	240002701669	1000	The Seed School of Maryland	Regular School	No	High	06	12	2021	grade_9	93	93