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 native_american_alaskan_native 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	asian	native_hawaiian_pacific_islander	multiracial	total	white_int	black_int	hispanic_int	asian_int	multiracial_int	total_int
1309775	MD	school	2400030	1	Allegany	240003000014	301	Flintstone Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	193	*	*			*	205	193					205
1309783	MD	school	2400030	1	Allegany	240003001359	401	South Penn Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	361	40	*	*		85	497	361	40			85	497
1309791	MD	school	2400030	1	Allegany	240003000019	402	John Humbird Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	176	21	*			33	233	176	21			33	233
1309796	MD	school	2400030	1	Allegany	240003000015	405	Fort Hill High	Regular School	No	High	09	12	2021	pk_12_total	556	39	14	*		47	657	556	39	14		47	657
1309808	MD	school	2400030	1	Allegany	240003000024	502	Northeast Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	228	14	*			24	269	228	14			24	269
1309844	MD	school	2400030	1	Allegany	240003000005	702	Bel Air Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	202		*	*		*	216	202					216
1309852	MD	school	2400030	1	Allegany	240003000033	801	Westernport Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	239	*	*		*	10	256	239				10	256
1309856	MD	school	2400030	1	Allegany	240003000007	802	Westmar Middle	Regular School	No	Middle	06	08	2021	pk_12_total	241		*			*	256	241					256
1309864	MD	school	2400030	1	Allegany	240003000017	1001	George's Creek Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	241			*		*	244	241					244
1309872	MD	school	2400030	1	Allegany	240003000016	1101	Frost Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	179		*	*		*	192	179					192
1309905	MD	school	2400030	1	Allegany	240003001338	2901	Cash Valley Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	226	19	*	*		16	273	226	19			16	273
1309913	MD	school	2400030	1	Allegany	240003000026	2902	Parkside Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	134	16	*	*		15	178	134	16			15	178
1309952	MD	school	2400060	2	Anne Arundel	240006000066	1102	Ferndale Early Education Center	Regular School	No	Prekindergarten	PK	PK	2021	pk_12_total	30	19	21	12		*	87	30	19	21	12		87
1309990	MD	school	2400060	2	Anne Arundel	240006000088	1152	Linthicum Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	319	37	53	20	*	18	449	319	37	53	20	18	449
1310006	MD	school	2400060	2	Anne Arundel	240006000102	1172	North Glen Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	85	89	87	15		27	303	85	89	87	15	27	303
1310038	MD	school	2400060	2	Anne Arundel	240006000116	1212	Point Pleasant Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	289	69	99	12		41	510	289	69	99	12	41	510
1310046	MD	school	2400060	2	Anne Arundel	240006000117	1232	Quarterfield Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	146	116	85	47	*	49	445	146	116	85	47	49	445
1310061	MD	school	2400060	2	Anne Arundel	240006000142	1262	Woodside Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	110	65	145	*	*	10	340	110	65	145		10	340
1310114	MD	school	2400060	2	Anne Arundel	240006000044	2062	Belvedere Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	354	30	45	15		39	483	354	30	45	15	39	483
1310129	MD	school	2400060	2	Anne Arundel	240006000046	2082	Bodkin Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	423	*	33	*		19	483	423		33		19	483
1310143	MD	school	2400060	2	Anne Arundel	240006000067	2102	Folger Mckinsey Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	482	17	31	18		28	576	482	17	31	18	28	576
1310151	MD	school	2400060	2	Anne Arundel	240006000068	2112	Fort Smallwood Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	404	17	18	*		19	464	404	17	18		19	464
1310167	MD	school	2400060	2	Anne Arundel	240006000082	2142	Jacobsville Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	394	38	51	11		33	527	394	38	51	11	33	527
1310174	MD	school	2400060	2	Anne Arundel	240006000084	2152	Jones Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	219	12	21	21		19	292	219	12	21	21	19	292
1310182	MD	school	2400060	2	Anne Arundel	240006000085	2162	Lake Shore Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	275	*	19			21	317	275		19		21	317
1310196	MD	school	2400060	2	Anne Arundel	240006000113	2182	Pasadena Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	288	15	26	*		15	347	288	15	26		15	347
1310232	MD	school	2400060	2	Anne Arundel	240006000899	2233	Anne Arundel Evening High	Alternative School	No	High	09	12	2021	pk_12_total	106	55	54	*		*	227	106	55	54			227
1310275	MD	school	2400060	2	Anne Arundel	240006001421	2432	Shipley's Choice Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	320	*	*	13		23	369	320			13	23	369
1310322	MD	school	2400060	2	Anne Arundel	240006001645	3092	Seven Oaks Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	53	354	42	18	*	33	501	53	354	42	18	33	501
1310375	MD	school	2400060	2	Anne Arundel	240006000100	3162	Millersville Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	259	21	28	*	*	32	349	259	21	28		32	349
1310474	MD	school	2400060	2	Anne Arundel	240006001517	3362	Crofton Meadows Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	284	101	49	32		61	527	284	101	49	32	61	527
1310498	MD	school	2400060	2	Anne Arundel	240006000120	3392	Rippling Woods Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	180	240	98	19		40	577	180	240	98	19	40	577
1310513	MD	school	2400060	2	Anne Arundel	240006001425	3414	Ruth Parker Eason School	Special Education School	No	Other	PK	12	2021	pk_12_total	46	68	19	*	*	*	149	46	68	19			149
1310527	MD	school	2400060	2	Anne Arundel	240006000132	4023	Southern High	Regular School	No	High	09	12	2021	pk_12_total	719	73	176	10	*	53	1032	719	73	176	10	53	1032
1310543	MD	school	2400060	2	Anne Arundel	240006001729	4064	Mary Moss at Adams Academy	Alternative School	No	Middle	07	09	2021	pk_12_total	10	19	*			*	42	10	19				42
1310564	MD	school	2400060	2	Anne Arundel	240006000035	4092	Annapolis Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	26	120	38	*		*	194	26	120	38			194
1310566	MD	school	2400060	2	Anne Arundel	240006001746	4102	Carrie Weedon Early Education Center	Regular School	No	Prekindergarten	PK	PK	2021	pk_12_total	33	*	21			*	62	33		21			62
1310587	MD	school	2400060	2	Anne Arundel	240006000063	4132	Deale Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	172	*	18	*		*	209	172		18			209
1310610	MD	school	2400060	2	Anne Arundel	240006000073	4162	Georgetown East Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	11	142	138	*	*	*	308	11	142	138			308
1310626	MD	school	2400060	2	Anne Arundel	240006000080	4192	Hillsmere Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	249	73	55	*		15	398	249	73	55		15	398
1310641	MD	school	2400060	2	Anne Arundel	240006000097	4212	Mayo Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	286	*	39	*		18	353	286		39		18	353
1310649	MD	school	2400060	2	Anne Arundel	240006000112	4222	Walter S. Mills - Parole Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	201	329	*		*	555		201	329			555
1310665	MD	school	2400060	2	Anne Arundel	240006000128	4242	Shady Side Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	352	33	20	*		21	430	352	33	20		21	430
1310672	MD	school	2400060	2	Anne Arundel	240006000135	4252	Traceys Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	216	23	144	*		14	398	216	23	144		14	398
1310680	MD	school	2400060	2	Anne Arundel	240006000136	4262	Tyler Heights Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	17	445	*		*	467		17	445			467
1310687	MD	school	2400060	2	Anne Arundel	240006000139	4272	West Annapolis Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	132	19	39	*		23	215	132	19	39		23	215
1310711	MD	school	2400060	2	Anne Arundel	240006000056	4304	Central Special School	Special Education School	No	Other	PK	12	2021	pk_12_total	67	27	26	*		*	129	67	27	26			129
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		*					*
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
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	*	*	*				*
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
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
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
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
1310850	MD	school	2400120	3	Baltimore County	240012000466	111	Maiden Choice School	Special Education School	No	Other	PK	12	2021	pk_12_total	29	71	*	16		*	130	29	71		16		130
1310912	MD	school	2400120	3	Baltimore County	240012000457	202	Randallstown Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	*	334	28	*	*	12	384		334	28		12	384
1310935	MD	school	2400120	3	Baltimore County	240012000471	206	Scotts Branch Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	*	458	39	*	*	*	520		458	39			520
1310991	MD	school	2400120	3	Baltimore County	240012000371	216	Deer Park Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	*	368	*	*		10	396		368			10	396
1311031	MD	school	2400120	3	Baltimore County	240012000458	272	Randallstown High	Regular School	No	High	09	12	2021	pk_12_total	16	1001	44	22		14	1097	16	1001	44	22	14	1097
1311101	MD	school	2400120	3	Baltimore County	240012000388	403	Franklin Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	203	96	49	28		24	400	203	96	49	28	24	400
1311109	MD	school	2400120	3	Baltimore County	240012000361	404	Chatsworth School	Regular School	No	Elementary	PK	05	2021	pk_12_total	102	171	17	24	*	20	335	102	171	17	24	20	335
1311141	MD	school	2400120	3	Baltimore County	240012000356	408	Cedarmere Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	89	214	159	46		16	524	89	214	159	46	16	524
1311181	MD	school	2400120	3	Baltimore County	240012000456	601	Prettyboy Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	360	*	*	*		*	385	360					385
1311194	MD	school	2400120	3	Baltimore County	240012001432	772	Hereford High	Regular School	No	High	09	12	2021	pk_12_total	1093	33	57	57		45	1285	1093	33	57	57	45	1285
1311208	MD	school	2400120	3	Baltimore County	240012000350	803	Lutherville Laboratory	Regular School	No	Elementary	KG	05	2021	pk_12_total	164	68	30	46	*	29	338	164	68	30	46	29	338
1311215	MD	school	2400120	3	Baltimore County	240012001433	805	Timonium Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	286	22	36	75	*	24	444	286	22	36	75	24	444
1311230	MD	school	2400120	3	Baltimore County	240012000462	809	Riderwood Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	317	20	19	28		21	405	317	20	19	28	21	405
1311246	MD	school	2400120	3	Baltimore County	240012000452	811	Pinewood Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	365	33	22	127		29	576	365	33	22	127	29	576
1311286	MD	school	2400120	3	Baltimore County	240012000479	905	Stoneleigh Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	451	60	59	41		40	651	451	60	59	41	40	651
1311293	MD	school	2400120	3	Baltimore County	240012000465	907	Rodgers Forge Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	298	*	26	33	*	25	392	298		26	33	25	392
1311333	MD	school	2400120	3	Baltimore County	240012000407	912	Halstead Academy	Regular School	No	Elementary	PK	05	2021	pk_12_total	16	402	46	*		*	478	16	402	46			478
1311341	MD	school	2400120	3	Baltimore County	240012000400	915	Harford Hills Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	162	134	32	21	*	20	370	162	134	32	21	20	370
1311357	MD	school	2400120	3	Baltimore County	240012000450	921	Pine Grove Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	289	170	46	39		21	565	289	170	46	39	21	565
1311380	MD	school	2400120	3	Baltimore County	240012001435	923	White Oak School	Special Education School	No	Elementary	PK	05	2021	pk_12_total	30	33	*	*		*	75	30	33				75
1311391	MD	school	2400120	3	Baltimore County	240012000374	953	Dumbarton Middle	Regular School	No	Middle	06	08	2021	pk_12_total	656	151	167	103	*	71	1152	656	151	167	103	71	1152
1311426	MD	school	2400120	3	Baltimore County	240012000352	1001	Carroll Manor Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	309	*	14	*		15	351	309		14		15	351
1311433	MD	school	2400120	3	Baltimore County	240012000467	1002	Jacksonville Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	411	*	20	22		20	480	411		20	22	20	480
1311440	MD	school	2400120	3	Baltimore County	240012000413	1104	Kingsville Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	242	*	*	*	*	*	272	242					272
1311463	MD	school	2400120	3	Baltimore County	240012000358	1107	Chapel Hill Elementary	Regular School	No	Elementary	KG	05	2021	pk_12_total	327	102	17	116	*	30	593	327	102	17	116	30	593
1311533	MD	school	2400120	3	Baltimore County	240012000434	1207	Norwood Elementary	Regular School	No	Elementary	PK	03	2021	pk_12_total	190	40	176	30	*	33	470	190	40	176	30	33	470
1311563	MD	school	2400120	3	Baltimore County	240012000346	1215	Battle Monument School	Special Education School	No	Other	PK	12	2021	pk_12_total	31	19	*	*		*	63	31	19				63
1311651	MD	school	2400120	3	Baltimore County	240012000398	1313	Halethorpe Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	123	43	35	101		18	320	123	43	35	101	18	320
1311672	MD	school	2400120	3	Baltimore County	240012000426	1403	McCormick Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	13	263	18		*	12	308	13	263	18		12	308
1311733	MD	school	2400120	3	Baltimore County	240012000367	1503	Colgate Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	130	34	259	*		28	458	130	34	259		28	458
1311741	MD	school	2400120	3	Baltimore County	240012000489	1505	Victory Villa Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	123	333	123	14	*	45	640	123	333	123	14	45	640
1311757	MD	school	2400120	3	Baltimore County	240012000360	1507	Chase Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	180	89	54	*	*	29	355	180	89	54		29	355
1311797	MD	school	2400120	3	Baltimore County	240012000430	1514	Middlesex Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	139	113	78	*		31	370	139	113	78		31	370
1311876	MD	school	2400120	3	Baltimore County	240012001406	1534	Oliver Beach Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	147	*	*	*		14	168	147				14	168
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
1311944	MD	school	2400150	4	Calvert	240015000778	114	St Leonard Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	282	81	55	*		55	480	282	81	55		55	480
1311988	MD	school	2400150	4	Calvert	240015001655	208	Barstow Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	389	108	37	*	*	65	605	389	108	37		65	605
1311996	MD	school	2400150	4	Calvert	240015000511	209	Huntingtown Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	367	35	23	*	*	53	480	367	35	23		53	480
1312009	MD	school	2400150	4	Calvert	240015090465	215	Plum Point Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	436	58	38	16		54	602	436	58	38	16	54	602
1312013	MD	school	2400150	4	Calvert	240015000027	216	Plum Point Middle	Regular School	No	Middle	06	08	2021	pk_12_total	492	48	34	10		57	641	492	48	34	10	57	641
1312050	MD	school	2400150	4	Calvert	240015001505	316	Sunderland Elementary	Regular School	No	Elementary	PK	05	2021	pk_12_total	444	92	31	*		54	624	444	92	31		54	624
1312070	MD	school	2400180	5	Caroline	240018000522	201	Greensboro Elementary School	Regular School	No	Elementary	PK	05	2021	pk_12_total	325	27	347	*		39	739	325	27	347		39	739
1312078	MD	school	2400180	5	Caroline	240018000520	301	Denton Elementary School	Regular School	No	Elementary	PK	05	2021	pk_12_total	381	130	39	17		67	634	381	130	39	17	67	634