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 (low_income_int > :p3 or (low_income_int = :p3 and rowid > :p2)) order by low_income_int, 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
1244701	MD	school	2400600	18	Saint Mary's	240060001356	306	Leonardtown High	Regular School	No	High	09	12	2020	grade_11	436	436
1244772	MD	school	2400600	18	Saint Mary's	240060001224	801	Great Mills High	Regular School	No	High	09	12	2020	grade_11	358	358
1244839	MD	school	2400570	19	Somerset	240057001213	102	Washington Academy and High School	Regular School	No	High	08	12	2020	grade_11	98	98
1244854	MD	school	2400570	19	Somerset	240057001201	702	Crisfield Academy and High School	Regular School	No	High	08	12	2020	grade_11	80	80
1244886	MD	school	2400630	20	Talbot	240063001242	101	Easton High	Regular School	No	High	09	12	2020	grade_11	271	271
1244906	MD	school	2400630	20	Talbot	240063001248	202	St. Michaels Middle/High School	Regular School	No	High	06	12	2020	grade_11	64	64
1244943	MD	school	2400660	21	Washington	240066001674	40	Barbara Ingram School for the Arts	Regular School	No	High	09	12	2020	grade_11	71	71
1244976	MD	school	2400660	21	Washington	240066001295	204	Williamsport High	Regular School	No	High	09	12	2020	grade_11	182	182
1244981	MD	school	2400660	21	Washington	240066001288	301	South Hagerstown High	Regular School	No	High	09	12	2020	grade_11	295	295
1244996	MD	school	2400660	21	Washington	240066000308	305	Washington County Technical High	Career and Technical School	No	High	11	12	2020	grade_11	309	309
1245026	MD	school	2400660	21	Washington	240066001260	403	Clear Spring High	Regular School	No	High	09	12	2020	grade_11	126	126
1245034	MD	school	2400660	21	Washington	240066001270	501	Hancock Middle Senior High	Regular School	No	High	06	12	2020	grade_11	30	30
1245047	MD	school	2400660	21	Washington	240066001256	601	Boonsboro High	Regular School	No	High	09	12	2020	grade_11	204	204
1245064	MD	school	2400660	21	Washington	240066001285	701	Smithsburg High	Regular School	No	High	09	12	2020	grade_11	174	174
1245167	MD	school	2400660	21	Washington	240066001275	2101	North Hagerstown High	Regular School	No	High	09	12	2020	grade_11	318	318
1245197	MD	school	2400660	21	Washington	240066001289	2505	Marshall Street School	Special Education School	No	Other	KG	12	2020	grade_11	*
1245229	MD	school	2400690	22	Wicomico	240069001306	102	Mardela Middle & High	Regular School	No	High	06	12	2020	grade_11	81	81
1245256	MD	school	2400690	22	Wicomico	240069001320	513	Wicomico High	Regular School	No	High	09	12	2020	grade_11	265	265
1245271	MD	school	2400690	22	Wicomico	240069001088	520	Wicomico County Evening High	Alternative School	No	High	09	12	2020	grade_11	28	28
1245324	MD	school	2400690	22	Wicomico	240069001305	1307	James M. Bennett High	Regular School	No	High	09	12	2020	grade_11	354	354
1245333	MD	school	2400690	22	Wicomico	240069001309	1309	Parkside High	Regular School	No	High	09	12	2020	grade_11	285	285
1245368	MD	school	2400720	23	Worcester	240072001330	107	Pocomoke High	Regular School	No	High	09	12	2020	grade_11	91	91
1245385	MD	school	2400720	23	Worcester	240072001334	207	Snow Hill High	Regular School	No	High	09	12	2020	grade_11	81	81
1245399	MD	school	2400720	23	Worcester	240072001335	310	Stephen Decatur High	Regular School	No	High	09	12	2020	grade_11	333	333
1245424	MD	school	2400720	23	Worcester	240072001326	401	Cedar Chapel Special School	Special Education School	No	Other	PK	12	2020	grade_11	*
1245977	MD	school	2400090	30	Baltimore City	240009000219	177	George W. F. McMechen High	Special Education School	No	High	09	12	2020	grade_11	*
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
1246272	MD	school	2400090	30	Baltimore City	240009000157	239	Benjamin Franklin High School at Masonville Cove	Regular School	No	High	09	12	2020	grade_11	101	101
1246442	MD	school	2400090	30	Baltimore City	240009000336	301	William S. Baer School	Special Education School	No	Other	PK	12	2020	grade_11	*
1246448	MD	school	2400090	30	Baltimore City	240009000176	307	Claremont School	Special Education School	No	High	08	12	2020	grade_11	*
1246497	MD	school	2400090	30	Baltimore City	240009001302	325	ConneXions: A Community Based Arts School	Regular School	Yes	High	06	12	2020	grade_11	64	64
1246541	MD	school	2400090	30	Baltimore City	240009001632	333	Independence School Local I	Regular School	Yes	High	09	12	2020	grade_11	36	36
1246570	MD	school	2400090	30	Baltimore City	240009001663	341	The Reach! Partnership School	Regular School	No	High	09	12	2020	grade_11	109	109
1246578	MD	school	2400090	30	Baltimore City	240009001662	345	Joseph C. Briscoe Academy	Special Education School	No	High	06	12	2020	grade_11	*
1246606	MD	school	2400090	30	Baltimore City	240009001682	348	Baltimore Leadership School for Young Women	Regular School	Yes	High	06	12	2020	grade_11	48	48
1246614	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_11	26	26
1246619	MD	school	2400090	30	Baltimore City	240009001735	362	Bard High School Early College	Regular School	No	High	09	12	2020	grade_11	106	106
1246627	MD	school	2400090	30	Baltimore City	240009001675	364	Bluford Drew Jemison STEM Academy West	Regular School	No	High	06	12	2020	grade_11	10	10
1246668	MD	school	2400090	30	Baltimore City	240009001690	376	City Neighbors High	Regular School	Yes	High	09	12	2020	grade_11	105	105
1246676	MD	school	2400090	30	Baltimore City	240009001691	377	Green Street Academy	Regular School	Yes	High	06	12	2020	grade_11	113	113
1246684	MD	school	2400090	30	Baltimore City	240009001703	382	Baltimore Design School	Regular School	No	High	06	12	2020	grade_11	66	66
1246699	MD	school	2400090	30	Baltimore City	240009000194	400	Edmondson-Westside High	Career and Technical School	No	High	09	12	2020	grade_11	200	200
1246704	MD	school	2400090	30	Baltimore City	240009000151	403	Baltimore Polytechnic Institute	Regular School	No	High	09	12	2020	grade_11	398	398
1246709	MD	school	2400090	30	Baltimore City	240009000297	405	Patterson High	Career and Technical School	No	High	09	12	2020	grade_11	228	228
1246714	MD	school	2400090	30	Baltimore City	240009000203	406	Forest Park High	Regular School	No	High	09	12	2020	grade_11	108	108
1246719	MD	school	2400090	30	Baltimore City	240009000330	407	Western High	Regular School	No	High	09	12	2020	grade_11	292	292
1246724	MD	school	2400090	30	Baltimore City	240009000280	410	Mergenthaler Vocational-Technical High	Career and Technical School	No	High	09	12	2020	grade_11	355	355
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
1246734	MD	school	2400090	30	Baltimore City	240009000298	414	Paul Laurence Dunbar High	Regular School	No	High	09	12	2020	grade_11	168	168
1246739	MD	school	2400090	30	Baltimore City	240009001391	415	Baltimore School for the Arts	Regular School	No	High	09	12	2020	grade_11	114	114
1246744	MD	school	2400090	30	Baltimore City	240009001313	416	Digital Harbor High School	Career and Technical School	No	High	09	12	2020	grade_11	203	203
1246749	MD	school	2400090	30	Baltimore City	240009001331	419	Reginald F. Lewis High	Regular School	No	High	09	12	2020	grade_11	89	89
1246757	MD	school	2400090	30	Baltimore City	240009001339	421	National Academy Foundation	Regular School	No	High	06	12	2020	grade_11	115	115
1246762	MD	school	2400090	30	Baltimore City	240009001559	422	New Era Academy	Regular School	No	High	09	12	2020	grade_11	54	54
1246770	MD	school	2400090	30	Baltimore City	240009001381	427	Academy for College and Career Exploration	Regular School	No	High	06	12	2020	grade_11	73	73
1246775	MD	school	2400090	30	Baltimore City	240009001385	429	Vivien T. Thomas Medical Arts Academy	Career and Technical School	No	High	09	12	2020	grade_11	61	61
1246780	MD	school	2400090	30	Baltimore City	240009001387	430	Augusta Fells Savage Institute of Visual Arts	Regular School	No	High	09	12	2020	grade_11	66	66
1246785	MD	school	2400090	30	Baltimore City	240009001530	432	Coppin Academy	Regular School	Yes	High	09	12	2020	grade_11	70	70
1246790	MD	school	2400090	30	Baltimore City	240009001531	433	Renaissance Academy	Regular School	No	High	09	12	2020	grade_11	52	52
1246795	MD	school	2400090	30	Baltimore City	240009000209	450	Frederick Douglass High	Regular School	No	High	09	12	2020	grade_11	137	137
1246800	MD	school	2400090	30	Baltimore City	240009000168	454	Carver Vocational-Technical High	Career and Technical School	No	High	09	12	2020	grade_11	179	179
1246805	MD	school	2400090	30	Baltimore City	240009000150	480	Baltimore City College	Regular School	No	High	09	12	2020	grade_11	314	314
1246811	MD	school	2400090	30	Baltimore City	240009000885	884	Eager Street Academy	Alternative School	No	High	08	12	2020	grade_11	*
1246819	MD	school	2400027	32	SEED	240002701669	1000	The Seed School of Maryland	Regular School	No	High	06	12	2020	grade_11	28	28
1309794	MD	school	2400030	1	Allegany	240003000015	405	Fort Hill High	Regular School	No	High	09	12	2021	grade_11	126	126
1309813	MD	school	2400030	1	Allegany	240003000030	601	Center for Career & Technical Education	Career and Technical School	No	High	11	12	2021	grade_11	134	134
1309826	MD	school	2400030	1	Allegany	240003000001	606	Allegany High	Regular School	No	High	09	12	2021	grade_11	182	182
1309887	MD	school	2400030	1	Allegany	240003001636	2404	Mountain Ridge High School	Regular School	No	High	09	12	2021	grade_11	165	165
1309920	MD	school	2400060	2	Anne Arundel	240006000075	1033	Glen Burnie High	Regular School	No	High	09	12	2021	grade_11	486	486
1310074	MD	school	2400060	2	Anne Arundel	240006000094	1274	Marley Glen School	Special Education School	No	Other	PK	12	2021	grade_11	*
1310079	MD	school	2400060	2	Anne Arundel	240006090441	1323	North County High	Regular School	No	High	09	12	2021	grade_11	535	535
1310084	MD	school	2400060	2	Anne Arundel	240006000127	2013	Severna Park High	Regular School	No	High	09	12	2021	grade_11	459	459
1310089	MD	school	2400060	2	Anne Arundel	240006000103	2023	Northeast High	Regular School	No	High	09	12	2021	grade_11	342	342
1310230	MD	school	2400060	2	Anne Arundel	240006000899	2233	Anne Arundel Evening High	Alternative School	No	High	09	12	2021	grade_11	71	71
1310239	MD	school	2400060	2	Anne Arundel	240006000058	2273	Chesapeake High	Regular School	No	High	09	12	2021	grade_11	345	345
1310251	MD	school	2400060	2	Anne Arundel	240006001402	2363	Broadneck High	Regular School	No	High	09	12	2021	grade_11	557	557
1310278	MD	school	2400060	2	Anne Arundel	240006000040	3013	Arundel High	Regular School	No	High	09	12	2021	grade_11	553	553
1310452	MD	school	2400060	2	Anne Arundel	240006000099	3323	Meade High	Regular School	No	High	09	12	2021	grade_11	475	475
1310465	MD	school	2400060	2	Anne Arundel	240006000109	3353	Old Mill High	Regular School	No	High	09	12	2021	grade_11	551	551
1310511	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2021	grade_11	14	14
1310520	MD	school	2400060	2	Anne Arundel	240006000037	4013	Annapolis High	Regular School	No	High	09	12	2021	grade_11	510	510
1310525	MD	school	2400060	2	Anne Arundel	240006000132	4023	Southern High	Regular School	No	High	09	12	2021	grade_11	267	267
1310554	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	01	12	2021	grade_11	63	63
1310694	MD	school	2400060	2	Anne Arundel	240006000055	4293	South River High	Regular School	No	High	09	12	2021	grade_11	563	563
1310709	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2021	grade_11	18	18
1310734	MD	school	2400060	2	Anne Arundel	240006001401	6223	Chesapeake Science Point	Regular School	Yes	High	06	12	2021	grade_11	61	61
1310750	MD	school	2400120	3	Baltimore County	240012001751	52	Southwest EDLP at Woodlawn High School	Alternative School	No	High	11	12	2021	grade_11	*
1310753	MD	school	2400120	3	Baltimore County	240012001754	53	Northeast EDLP at Parkville High School	Alternative School	No	High	11	12	2021	grade_11	*
1310763	MD	school	2400120	3	Baltimore County	240012000935	58	Home Assignments-Secondary	Alternative School	No	High	08	12	2021	grade_11	*
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
1310781	MD	school	2400120	3	Baltimore County	240012000831	72	Rosedale Center	Alternative School	No	High	07	12	2021	grade_11	*
1310788	MD	school	2400120	3	Baltimore County	240012001649	75	Crossroads Center	Alternative School	No	High	07	12	2021	grade_11	20	20
1310793	MD	school	2400120	3	Baltimore County	240012001711	77	BCDC Educational Center	Alternative School	No	High	09	12	2021	grade_11	*
1310848	MD	school	2400120	3	Baltimore County	240012000466	111	Maiden Choice School	Special Education School	No	Other	PK	12	2021	grade_11	*
1310893	MD	school	2400120	3	Baltimore County	240012000502	172	Woodlawn High	Regular School	No	High	09	12	2021	grade_11	401	401
1310898	MD	school	2400120	3	Baltimore County	240012000355	174	Catonsville High	Regular School	No	High	09	12	2021	grade_11	474	474
1310903	MD	school	2400120	3	Baltimore County	240012000248	175	Western School of Technology	Career and Technical School	No	High	09	12	2021	grade_11	226	226
1311024	MD	school	2400120	3	Baltimore County	240012000432	271	Milford Mill Academy	Regular School	No	High	09	12	2021	grade_11	317	317
1311029	MD	school	2400120	3	Baltimore County	240012000458	272	Randallstown High	Regular School	No	High	09	12	2021	grade_11	226	226
1311083	MD	school	2400120	3	Baltimore County	240012000449	371	Pikesville High	Regular School	No	High	09	12	2021	grade_11	217	217
1311155	MD	school	2400120	3	Baltimore County	240012001347	452	Owings Mills High	Regular School	No	High	09	12	2021	grade_11	255	255