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	white	black	hispanic	native_american_alaskan_native	asian	native_hawaiian_pacific_islander	multiracial	total	white_int	black_int	hispanic_int	asian_int	multiracial_int	total_int
1318024	MD	school	2400090	30	Baltimore City	240009000319	4	Steuart Hill Academic Academy	Regular School	No	Elementary	PK	05	2021	pk_12_total	13	163	*		*		*	187	13	163				187
1318032	MD	school	2400090	30	Baltimore City	240009000169	7	Cecil Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	341	*			*	*	354		341				354
1318043	MD	school	2400090	30	Baltimore City	240009000175	8	City Springs Elementary/Middle	Regular School	Yes	Elementary	PK	08	2021	pk_12_total	10	594	24	*			*	633	10	594	24			633
1318054	MD	school	2400090	30	Baltimore City	240009000253	10	James McHenry Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	24	601	31		*		11	670	24	601	31		11	670
1318062	MD	school	2400090	30	Baltimore City	240009000196	11	Eutaw-Marshburn Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	243	*	*				248		243				248
1318073	MD	school	2400090	30	Baltimore City	240009000264	12	Lakeland Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	37	288	642	*	*		10	984	37	288	642		10	984
1318084	MD	school	2400090	30	Baltimore City	240009000320	13	Tench Tilghman Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	*	319	48				*	371		319	48			371
1318088	MD	school	2400090	30	Baltimore City	240009000571	15	Stadium School	Regular School	No	Middle	06	08	2021	pk_12_total	*	471	20			*	*	500		471	20			500
1318096	MD	school	2400090	30	Baltimore City	240009000258	16	Johnston Square Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	263	*				*	273		263				273
1318104	MD	school	2400090	30	Baltimore City	240009000246	21	Hilton Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	313	*					328		313				328
1318112	MD	school	2400090	30	Baltimore City	240009000220	22	George Washington Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	10	153	13			*	*	184	10	153	13			184
1318120	MD	school	2400090	30	Baltimore City	240009000215	23	Wolfe Street Academy	Regular School	Yes	Elementary	PK	05	2021	pk_12_total	16	30	214	*	*			265	16	30	214			265
1318131	MD	school	2400090	30	Baltimore City	240009000180	27	Commodore John Rodgers Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	54	496	303	*	*		*	871	54	496	303			871
1318142	MD	school	2400090	30	Baltimore City	240009000335	28	Sandtown-Winchester Achievement Academy	Regular School	No	Elementary	PK	08	2021	pk_12_total	*	386	*		*		*	400		386				400
1318150	MD	school	2400090	30	Baltimore City	240009000278	29	Matthew A. Henson Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	257	*	*	*		*	268		257				268
1318158	MD	school	2400090	30	Baltimore City	240009000153	34	Charles Carroll Barrister Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	52	131	143	*	*			336	52	131	143			336
1318169	MD	school	2400090	30	Baltimore City	240009000239	35	Harlem Park Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total		275	*	*			*	282		275				282
1318177	MD	school	2400090	30	Baltimore City	240009001153	37	Harford Heights Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	385	*				*	397		385				397
1318185	MD	school	2400090	30	Baltimore City	240009000184	39	Dallas F. Nicholas, Sr., Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total		190	16	*	*	*	*	217		190	16			217
1317520	MD	school	2400660	21	Washington	240066001674	40	Barbara Ingram School for the Arts	Regular School	No	High	09	12	2021	pk_12_total	240	35	24		14		20	333	240	35	24	14	20	333
1318196	MD	school	2400090	30	Baltimore City	240009000281	44	Montebello Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	*	475	*		*		*	486		475				486
1318204	MD	school	2400090	30	Baltimore City	240009000201	45	Federal Hill Preparatory Academy	Regular School	No	Elementary	PK	05	2021	pk_12_total	102	192	26		*	*	16	345	102	192	26		16	345
1318215	MD	school	2400090	30	Baltimore City	240009000234	47	Hampstead Hill Academy	Regular School	Yes	Elementary	PK	08	2021	pk_12_total	331	142	325	*	12	*	39	855	331	142	325	12	39	855
1318223	MD	school	2400090	30	Baltimore City	240009000143	50	Abbottston Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	334	18				*	365		334	18			365
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		*						*
1314300	MD	school	2400480	15	Montgomery	240048000864	51	Laytonsville Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	138	67	106		29	*	27	369	138	67	106	29	27	369
1318234	MD	school	2400090	30	Baltimore City	240009000329	51	Waverly Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	*	544	22	*	*	*	*	589		544	22			589
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	*	*	*					*
1310755	MD	school	2400120	3	Baltimore County	240012001754	53	Northeast EDLP at Parkville High School	Alternative School	No	High	11	12	2021	pk_12_total	*	*	*					15						15
1318245	MD	school	2400090	30	Baltimore City	240009000276	53	Margaret Brent Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	27	161	93	*		*	*	294	27	161	93			294
1318256	MD	school	2400090	30	Baltimore City	240009000152	54	Barclay Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	*	345	64	*	*	*	*	425		345	64			425
1310758	MD	school	2400120	3	Baltimore County	240012001759	55	Southeast EDLP at Dundalk High School	Alternative School	No	High	10	12	2021	pk_12_total	*	*	*					*
1318267	MD	school	2400090	30	Baltimore City	240009000233	55	Hampden Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	204	193	20	*	12	*	26	459	204	193	20	12	26	459
1310760	MD	school	2400120	3	Baltimore County	240012001760	56	Central EDLP at Loch Raven High School	Alternative School	No	High	12	12	2021	pk_12_total	*							*
1310765	MD	school	2400120	3	Baltimore County	240012000935	58	Home Assignments-Secondary	Alternative School	No	High	08	12	2021	pk_12_total	*	*						12						12
1318278	MD	school	2400090	30	Baltimore City	240009000149	58	Dr. Nathan A. Pitts-Ashburton Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	*	323	17	*	*		*	349		323	17			349
1318286	MD	school	2400090	30	Baltimore City	240009000229	60	Gwynns Falls Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	284	*					286		284				286
1318294	MD	school	2400090	30	Baltimore City	240009000256	61	Dorothy I. Height Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	324	*	*				339		324				339
1310768	MD	school	2400120	3	Baltimore County	240012000012	62	Campfield Early Childhood Center	Regular School	No	Elementary	PK	KG	2021	pk_12_total	24	235	36	*	22		15	333	24	235	36	22	15	333
1318302	MD	school	2400090	30	Baltimore City	240009000192	62	Edgecombe Circle Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	278	11		*	*	*	300		278	11			300
1318313	MD	school	2400090	30	Baltimore City	240009000307	63	Rosemont Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total		341	*		*		*	351		341				351
1318321	MD	school	2400090	30	Baltimore City	240009000270	64	Liberty Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	406	16			*	*	428		406	16			428
1318332	MD	school	2400090	30	Baltimore City	240009000285	66	Mount Royal Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	77	660	26	*	*	*	*	781	77	660	26			781
1318340	MD	school	2400090	30	Baltimore City	240009000193	67	Edgewood Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	169	*				*	178		169				178
1310773	MD	school	2400120	3	Baltimore County	240012000436	69	Catonsville Center for Alternative Studies	Alternative School	No	High	09	12	2021	pk_12_total	*	41	*		*		*	51		41				51
1310776	MD	school	2400120	3	Baltimore County	240012000777	70	Meadowood Education Center	Alternative School	No	Middle	07	08	2021	pk_12_total	*	12	*				*	15		12				15
1310783	MD	school	2400120	3	Baltimore County	240012000831	72	Rosedale Center	Alternative School	No	High	07	12	2021	pk_12_total	*	17					*	25		17				25
1310790	MD	school	2400120	3	Baltimore County	240012001649	75	Crossroads Center	Alternative School	No	High	07	12	2021	pk_12_total	63	84	*	*	*		12	169	63	84			12	169
1318347	MD	school	2400090	30	Baltimore City	240009000164	75	Calverton Elementary/Middle	Regular School	No	Middle	03	08	2021	pk_12_total	*	326	17		*		*	359		326	17			359
1318358	MD	school	2400090	30	Baltimore City	240009000205	76	Francis Scott Key Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	229	237	74	*	*	*	22	575	229	237	74		22	575
1310795	MD	school	2400120	3	Baltimore County	240012001711	77	BCDC Educational Center	Alternative School	No	High	09	12	2021	pk_12_total	*	19	*					31		19				31
1313781	MD	school	2400420	13	Howard	240042001189	80	Homewood School	Alternative School	No	High	07	12	2021	pk_12_total	36	64	12		*		*	120	36	64	12			120
1318369	MD	school	2400090	30	Baltimore City	240009000602	81	North Bend Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	10	446	28	*		*	*	491	10	446	28			491
1318377	MD	school	2400090	30	Baltimore City	240009000334	83	William Paca Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	213	215	*	*	*	*	445		213	215			445
1318388	MD	school	2400090	30	Baltimore City	240009000323	84	Thomas Johnson Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	354	86	47		*	*	25	516	354	86	47		25	516
1318398	MD	school	2400090	30	Baltimore City	240009000204	85	Fort Worthington Elementary/Middle	Regular School	No	Elementary	KG	08	2021	pk_12_total	10	656	55	*	*		*	736	10	656	55			736
1318401	MD	school	2400090	30	Baltimore City	240009000265	86	Lakewood Elementary	Regular School	No	Elementary	PK	KG	2021	pk_12_total	*	51	*		*		*	63		51				63
1318412	MD	school	2400090	30	Baltimore City	240009000337	87	Windsor Hills Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	*	215	13		*	*		237		215	13			237
1318423	MD	school	2400090	30	Baltimore City	240009000273	88	Wildwood Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	*	713	15			*	*	734		713	15			734
1318434	MD	school	2400090	30	Baltimore City	240009000208	95	Franklin Square Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	*	316	*	*	*		*	336		316				336
1318445	MD	school	2400090	30	Baltimore City	240009000179	97	Collington Square Elementary/Middle	Regular School	No	Elementary	PK	08	2021	pk_12_total	*	308	*	*	*	*	*	326		308				326
1314308	MD	school	2400480	15	Montgomery	240048001494	100	Clopper Mill Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	35	161	215	*	44		21	478	35	161	215	44	21	478
1310803	MD	school	2400120	3	Baltimore County	240012000353	101	Catonsville Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	301	94	50		140	*	52	638	301	94	50	140	52	638
1311920	MD	school	2400150	4	Calvert	240015000504	101	Patuxent Appeal Elementary Campus	Regular School	No	Elementary	PK	05	2021	pk_12_total	394	118	52		*	*	99	667	394	118	52		99	667
1313789	MD	school	2400420	13	Howard	240042000728	101	Elkridge Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	295	244	56	*	167	*	55	819	295	244	56	167	55	819
1314316	MD	school	2400480	15	Montgomery	240048000804	101	Clarksburg Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	90	190	115	*	242	*	51	690	90	190	115	242	51	690
1317161	MD	school	2400540	17	Queen Anne's	240054001198	101	Sudlersville Middle School	Regular School	No	Middle	05	08	2021	pk_12_total	303	30	77	*	*		27	443	303	30	77		27	443
1317235	MD	school	2400600	18	Saint Mary's	240060001237	101	Spring Ridge Middle	Regular School	No	Middle	06	08	2021	pk_12_total	417	366	128	*	33	*	118	1067	417	366	128	33	118	1067
1317463	MD	school	2400630	20	Talbot	240063001242	101	Easton High	Regular School	No	High	09	12	2021	pk_12_total	655	160	263	*	29	*	61	1170	655	160	263	29	61	1170
1317528	MD	school	2400660	21	Washington	240066001284	101	Sharpsburg Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	296	*	*				*	308	296					308
1310811	MD	school	2400120	3	Baltimore County	240012000936	102	Westchester Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	415	71	55	*	93		31	668	415	71	55	93	31	668
1314324	MD	school	2400480	15	Montgomery	240048000843	102	Germantown Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	47	110	75	*	50	*	16	301	47	110	75	50	16	301
1315666	MD	school	2400510	16	Prince George's	240051001059	102	High Point High	Regular School	No	High	09	12	2021	pk_12_total	50	449	2042	*	71	*	12	2634	50	449	2042	71	12	2634
1317419	MD	school	2400570	19	Somerset	240057001213	102	Washington Academy and High School	Regular School	No	High	08	12	2021	pk_12_total	191	308	43		*	*	37	589	191	308	43		37	589
1317807	MD	school	2400690	22	Wicomico	240069001306	102	Mardela Middle & High	Regular School	No	High	06	12	2021	pk_12_total	515	74	26	*	*		53	674	515	74	26		53	674
1317941	MD	school	2400720	23	Worcester	240072001328	102	Pocomoke Elementary	Regular School	No	Elementary	PK	03	2021	pk_12_total	173	178	41	*	*		21	416	173	178	41		21	416
1310819	MD	school	2400120	3	Baltimore County	240012000495	103	Westowne Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	226	241	50	*	87	*	50	659	226	241	50	87	50	659
1312128	MD	school	2400210	6	Carroll	240021000548	103	Taneytown Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	298	20	34	*	*	*	14	374	298	20	34		14	374
1313797	MD	school	2400420	13	Howard	240042090448	103	Deep Run Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	137	100	320	*	87		31	680	137	100	320	87	31	680
1310827	MD	school	2400120	3	Baltimore County	240012000382	104	Edmondson Heights Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	40	336	71	*	28	*	16	499	40	336	71	28	16	499
1312392	MD	school	2400240	7	Cecil	240024000562	104	Cecilton Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	207	16	43	*			15	282	207	16	43		15	282
1312573	MD	school	2400270	8	Charles	240027000601	104	Milton M. Somers Middle School	Regular School	No	Middle	06	08	2021	pk_12_total	386	437	103	*	37	*	83	1049	386	437	103	37	83	1049
1313801	MD	school	2400420	13	Howard	240042090477	104	Mayfield Woods Middle	Regular School	No	Middle	06	08	2021	pk_12_total	191	218	226	*	117	*	37	795	191	218	226	117	37	795
1314329	MD	school	2400480	15	Montgomery	240048000918	104	Seneca Valley High	Regular School	No	High	09	12	2021	pk_12_total	213	616	569	*	168	*	83	1652	213	616	569	168	83	1652
1315677	MD	school	2400510	16	Prince George's	240051000978	104	Beltsville Academy	Regular School	No	Elementary	PK	08	2021	pk_12_total	65	187	820	*	51		15	1143	65	187	820	51	15	1143
1317243	MD	school	2400600	18	Saint Mary's	240060001236	104	Ridge Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	154	27	14	*			31	227	154	27	14		31	227
1317471	MD	school	2400630	20	Talbot	240063001244	104	Easton Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	304	217	424		33		70	1048	304	217	424	33	70	1048
1310835	MD	school	2400120	3	Baltimore County	240012000410	105	Johnnycake Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	39	270	140	*	53	*	22	531	39	270	140	53	22	531
1312132	MD	school	2400210	6	Carroll	240021000543	105	Northwest Middle	Regular School	No	Middle	06	08	2021	pk_12_total	534	26	30	*	*		46	645	534	26	30		46	645
1312581	MD	school	2400270	8	Charles	240027000609	105	Walter J. Mitchell Elementary School	Regular School	No	Elementary	PK	05	2021	pk_12_total	377	105	55	*	13	*	59	613	377	105	55	13	59	613
1313809	MD	school	2400420	13	Howard	240042000396	105	Rockburn Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	277	91	36	*	168		35	611	277	91	36	168	35	611
1314267	MD	school	2400450	14	Kent	240045001695	105	Galena Elementary School	Regular School	No	Elementary	PK	05	2021	pk_12_total	187	30	61				18	296	187	30	61		18	296
1314333	MD	school	2400480	15	Montgomery	240048000903	105	Ridgeview Middle	Regular School	No	Middle	06	08	2021	pk_12_total	288	116	261	*	89		34	792	288	116	261	89	34	792
1315685	MD	school	2400510	16	Prince George's	240051000995	105	Calverton Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	15	241	507	*	38	*	*	811	15	241	507	38		811
1318453	MD	school	2400090	30	Baltimore City	240009000282	105	Moravia Park Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	17	646	26	*	11	*	*	714	17	646	26	11		714
1312586	MD	school	2400270	8	Charles	240027000596	106	La Plata High School	Regular School	No	High	09	12	2021	pk_12_total	703	247	73	*	38	*	107	1174	703	247	73	38	107	1174
1313813	MD	school	2400420	13	Howard	240042000633	106	Elkridge Landing Middle	Regular School	No	Middle	06	08	2021	pk_12_total	287	196	49	*	121	*	54	710	287	196	49	121	54	710
1314341	MD	school	2400480	15	Montgomery	240048000834	106	Fox Chapel Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	63	137	266	*	92	*	27	589	63	137	266	92	27	589
1317168	MD	school	2400540	17	Queen Anne's	240054001197	106	Sudlersville Elementary School	Regular School	No	Elementary	PK	04	2021	pk_12_total	150	14	116				17	297	150	14	116		17	297
1317475	MD	school	2400630	20	Talbot	240063001243	106	Easton Middle	Regular School	No	Middle	06	08	2021	pk_12_total	424	160	207		19		44	854	424	160	207	19	44	854
1317815	MD	school	2400690	22	Wicomico	240069001308	106	Northwestern Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	239	25	10	*	*	*	27	308	239	25	10		27	308