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 (school_state_id > :p3 or (school_state_id = :p3 and rowid > :p2)) order by school_state_id, 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
1242066	MD	school	2400480	15	Montgomery	240048001541	249	Clarksburg High	Regular School	No	High	09	12	2020	grade_9	715	715
1314624	MD	school	2400480	15	Montgomery	240048001541	249	Clarksburg High	Regular School	No	High	09	12	2021	grade_9	618	618
1240995	MD	school	2400390	12	Harford	240039000679	270	Aberdeen High	Regular School	No	High	09	12	2020	grade_9	454	454
1313548	MD	school	2400390	12	Harford	240039000679	270	Aberdeen High	Regular School	No	High	09	12	2021	grade_9	464	464
1238467	MD	school	2400120	3	Baltimore County	240012000432	271	Milford Mill Academy	Regular School	No	High	09	12	2020	grade_9	336	336
1311022	MD	school	2400120	3	Baltimore County	240012000432	271	Milford Mill Academy	Regular School	No	High	09	12	2021	grade_9	364	364
1238472	MD	school	2400120	3	Baltimore County	240012000458	272	Randallstown High	Regular School	No	High	09	12	2020	grade_9	340	340
1311027	MD	school	2400120	3	Baltimore County	240012000458	272	Randallstown High	Regular School	No	High	09	12	2021	grade_9	272	272
1241001	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	08	12	2020	grade_9	35	35
1313556	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	06	12	2021	grade_9	36	36
1241711	MD	school	2400450	14	Kent	240045000768	301	Kent County High	Regular School	No	High	09	12	2020	grade_9	164	164
1244598	MD	school	2400540	17	Queen Anne's	240054001195	301	Queen Anne's County High School	Regular School	No	High	09	12	2020	grade_9	307	307
1244979	MD	school	2400660	21	Washington	240066001288	301	South Hagerstown High	Regular School	No	High	09	12	2020	grade_9	421	421
1246440	MD	school	2400090	30	Baltimore City	240009000336	301	William S. Baer School	Special Education School	No	Other	PK	12	2020	grade_9	*
1314268	MD	school	2400450	14	Kent	240045000768	301	Kent County High	Regular School	No	High	09	12	2021	grade_9	158	158
1317176	MD	school	2400540	17	Queen Anne's	240054001195	301	Queen Anne's County High School	Regular School	No	High	09	12	2021	grade_9	314	314
1317554	MD	school	2400660	21	Washington	240066001288	301	South Hagerstown High	Regular School	No	High	09	12	2021	grade_9	467	467
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
1239862	MD	school	2400240	7	Cecil	240024000568	302	Elkton High	Regular School	No	High	09	12	2020	grade_9	284	284
1312410	MD	school	2400240	7	Cecil	240024000568	302	Elkton High	Regular School	No	High	09	12	2021	grade_9	302	302
1244690	MD	school	2400600	18	Saint Mary's	240060001218	303	Chopticon High	Regular School	No	High	09	12	2020	grade_9	474	474
1317268	MD	school	2400600	18	Saint Mary's	240060001218	303	Chopticon High	Regular School	No	High	09	12	2021	grade_9	450	450
1241006	MD	school	2400390	12	Harford	240039000694	304	Harford Technical High	Career and Technical School	No	High	09	12	2020	grade_9	270	270
1313561	MD	school	2400390	12	Harford	240039000694	304	Harford Technical High	Career and Technical School	No	High	09	12	2021	grade_9	264	264
1244699	MD	school	2400600	18	Saint Mary's	240060001356	306	Leonardtown High	Regular School	No	High	09	12	2020	grade_9	537	537
1317277	MD	school	2400600	18	Saint Mary's	240060001356	306	Leonardtown High	Regular School	No	High	09	12	2021	grade_9	486	486
1246446	MD	school	2400090	30	Baltimore City	240009000176	307	Claremont School	Special Education School	No	High	08	12	2020	grade_9	*
1318997	MD	school	2400090	30	Baltimore City	240009000176	307	Claremont School	Special Education School	No	High	07	12	2021	grade_9	10	10
1241411	MD	school	2400420	13	Howard	240042001437	308	Marriotts Ridge High	Regular School	No	High	09	12	2020	grade_9	394	394
1313966	MD	school	2400420	13	Howard	240042001437	308	Marriotts Ridge High	Regular School	No	High	09	12	2021	grade_9	432	432
1245397	MD	school	2400720	23	Worcester	240072001335	310	Stephen Decatur High	Regular School	No	High	09	12	2020	grade_9	367	367
1317973	MD	school	2400720	23	Worcester	240072001335	310	Stephen Decatur High	Regular School	No	High	09	12	2021	grade_9	341	341
1240469	MD	school	2400330	10	Frederick	240033000641	313	Middletown High	Regular School	No	High	09	12	2020	grade_9	294	294
1313015	MD	school	2400330	10	Frederick	240033000641	313	Middletown High	Regular School	No	High	09	12	2021	grade_9	292	292
1239479	MD	school	2400150	4	Calvert	240015000516	314	Northern High	Regular School	No	High	09	12	2020	grade_9	362	362
1312034	MD	school	2400150	4	Calvert	240015000516	314	Northern High	Regular School	No	High	09	12	2021	grade_9	378	378
1242151	MD	school	2400480	15	Montgomery	240048000890	315	Paint Branch High	Regular School	No	High	09	12	2020	grade_9	559	559
1314710	MD	school	2400480	15	Montgomery	240048000890	315	Paint Branch High	Regular School	No	High	09	12	2021	grade_9	606	606
1242163	MD	school	2400480	15	Montgomery	240048001044	321	James Hubert Blake High	Regular School	No	High	09	12	2020	grade_9	521	521
1314723	MD	school	2400480	15	Montgomery	240048001044	321	James Hubert Blake High	Regular School	No	High	09	12	2021	grade_9	531	531
1246495	MD	school	2400090	30	Baltimore City	240009001302	325	ConneXions: A Community Based Arts School	Regular School	Yes	High	06	12	2020	grade_9	106	106
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
1246539	MD	school	2400090	30	Baltimore City	240009001632	333	Independence School Local I	Regular School	Yes	High	09	12	2020	grade_9	47	47
1319090	MD	school	2400090	30	Baltimore City	240009001632	333	Independence School Local I	Regular School	Yes	High	09	12	2021	grade_9	55	55
1246568	MD	school	2400090	30	Baltimore City	240009001663	341	The Reach! Partnership School	Regular School	No	High	09	12	2020	grade_9	212	212
1319118	MD	school	2400090	30	Baltimore City	240009001663	341	The Reach! Partnership School	Regular School	No	High	09	12	2021	grade_9	255	255
1246576	MD	school	2400090	30	Baltimore City	240009001662	345	Joseph C. Briscoe Academy	Special Education School	No	High	06	12	2020	grade_9	10	10
1319126	MD	school	2400090	30	Baltimore City	240009001662	345	Joseph C. Briscoe Academy	Special Education School	No	High	06	12	2021	grade_9	*
1246604	MD	school	2400090	30	Baltimore City	240009001682	348	Baltimore Leadership School for Young Women	Regular School	Yes	High	06	12	2020	grade_9	56	56
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
1246612	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_9	87	87
1246617	MD	school	2400090	30	Baltimore City	240009001735	362	Bard High School Early College	Regular School	No	High	09	12	2020	grade_9	106	106
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
1246625	MD	school	2400090	30	Baltimore City	240009001675	364	Bluford Drew Jemison STEM Academy West	Regular School	No	High	06	12	2020	grade_9	38	38
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
1238526	MD	school	2400120	3	Baltimore County	240012000449	371	Pikesville High	Regular School	No	High	09	12	2020	grade_9	205	205
1311081	MD	school	2400120	3	Baltimore County	240012000449	371	Pikesville High	Regular School	No	High	09	12	2021	grade_9	217	217
1241095	MD	school	2400390	12	Harford	240039000683	373	Bel Air High	Regular School	No	High	09	12	2020	grade_9	401	401
1313651	MD	school	2400390	12	Harford	240039000683	373	Bel Air High	Regular School	No	High	09	12	2021	grade_9	415	415
1246666	MD	school	2400090	30	Baltimore City	240009001690	376	City Neighbors High	Regular School	Yes	High	09	12	2020	grade_9	110	110
1319209	MD	school	2400090	30	Baltimore City	240009001690	376	City Neighbors High	Regular School	Yes	High	09	12	2021	grade_9	116	116
1246674	MD	school	2400090	30	Baltimore City	240009001691	377	Green Street Academy	Regular School	Yes	High	06	12	2020	grade_9	127	127
1319217	MD	school	2400090	30	Baltimore City	240009001691	377	Green Street Academy	Regular School	Yes	High	06	12	2021	grade_9	128	128
1241104	MD	school	2400390	12	Harford	240039000691	382	Fallston High	Regular School	No	High	09	12	2020	grade_9	248	248
1246682	MD	school	2400090	30	Baltimore City	240009001703	382	Baltimore Design School	Regular School	No	High	06	12	2020	grade_9	68	68
1313660	MD	school	2400390	12	Harford	240039000691	382	Fallston High	Regular School	No	High	09	12	2021	grade_9	257	257
1319225	MD	school	2400090	30	Baltimore City	240009001703	382	Baltimore Design School	Regular School	No	High	06	12	2021	grade_9	86	86
1241109	MD	school	2400390	12	Harford	240039001380	385	C. Milton Wright High	Regular School	No	High	09	12	2020	grade_9	330	330
1313665	MD	school	2400390	12	Harford	240039001380	385	C. Milton Wright High	Regular School	No	High	09	12	2021	grade_9	357	357
1241128	MD	school	2400390	12	Harford	240039000703	391	John Archer School	Special Education School	No	Other	PK	12	2020	grade_9	*
1313684	MD	school	2400390	12	Harford	240039000703	391	John Archer School	Special Education School	No	Other	PK	12	2021	grade_9	11	11
1246697	MD	school	2400090	30	Baltimore City	240009000194	400	Edmondson-Westside High	Career and Technical School	No	High	09	12	2020	grade_9	251	251
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
1245422	MD	school	2400720	23	Worcester	240072001326	401	Cedar Chapel Special School	Special Education School	No	Other	PK	12	2020	grade_9	*
1317998	MD	school	2400720	23	Worcester	240072001326	401	Cedar Chapel Special School	Special Education School	No	Other	PK	12	2021	grade_9	*
1245024	MD	school	2400660	21	Washington	240066001260	403	Clear Spring High	Regular School	No	High	09	12	2020	grade_9	117	117
1246702	MD	school	2400090	30	Baltimore City	240009000151	403	Baltimore Polytechnic Institute	Regular School	No	High	09	12	2020	grade_9	399	399
1317599	MD	school	2400660	21	Washington	240066001260	403	Clear Spring High	Regular School	No	High	09	12	2021	grade_9	127	127
1319247	MD	school	2400090	30	Baltimore City	240009000151	403	Baltimore Polytechnic Institute	Regular School	No	High	09	12	2021	grade_9	413	413
1241416	MD	school	2400420	13	Howard	240042000731	404	Glenelg High	Regular School	No	High	09	12	2020	grade_9	281	281
1313971	MD	school	2400420	13	Howard	240042000731	404	Glenelg High	Regular School	No	High	09	12	2021	grade_9	341	341
1237231	MD	school	2400030	1	Allegany	240003000015	405	Fort Hill High	Regular School	No	High	09	12	2020	grade_9	181	181
1244629	MD	school	2400540	17	Queen Anne's	240054001076	405	Kent Island High School	Regular School	No	High	09	12	2020	grade_9	308	308
1246707	MD	school	2400090	30	Baltimore City	240009000297	405	Patterson High	Career and Technical School	No	High	09	12	2020	grade_9	486	486
1309792	MD	school	2400030	1	Allegany	240003000015	405	Fort Hill High	Regular School	No	High	09	12	2021	grade_9	191	191
1317207	MD	school	2400540	17	Queen Anne's	240054001076	405	Kent Island High School	Regular School	No	High	09	12	2021	grade_9	315	315
1319252	MD	school	2400090	30	Baltimore City	240009000297	405	Patterson High	Career and Technical School	No	High	09	12	2021	grade_9	362	362
1242265	MD	school	2400480	15	Montgomery	240048000784	406	Bethesda-Chevy Chase High	Regular School	No	High	09	12	2020	grade_9	630	630
1246712	MD	school	2400090	30	Baltimore City	240009000203	406	Forest Park High	Regular School	No	High	09	12	2020	grade_9	240	240
1314830	MD	school	2400480	15	Montgomery	240048000784	406	Bethesda-Chevy Chase High	Regular School	No	High	09	12	2021	grade_9	602	602
1319257	MD	school	2400090	30	Baltimore City	240009000203	406	Forest Park High	Regular School	No	High	09	12	2021	grade_9	249	249
1246717	MD	school	2400090	30	Baltimore City	240009000330	407	Western High	Regular School	No	High	09	12	2020	grade_9	344	344
1319262	MD	school	2400090	30	Baltimore City	240009000330	407	Western High	Regular School	No	High	09	12	2021	grade_9	351	351
1246722	MD	school	2400090	30	Baltimore City	240009000280	410	Mergenthaler Vocational-Technical High	Career and Technical School	No	High	09	12	2020	grade_9	666	666
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
1246727	MD	school	2400090	30	Baltimore City	240009000236	413	Achievement Academy at Harbor City High	Alternative School	No	High	09	12	2020	grade_9	133	133
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
1246732	MD	school	2400090	30	Baltimore City	240009000298	414	Paul Laurence Dunbar High	Regular School	No	High	09	12	2020	grade_9	281	281
1319277	MD	school	2400090	30	Baltimore City	240009000298	414	Paul Laurence Dunbar High	Regular School	No	High	09	12	2021	grade_9	261	261
1246737	MD	school	2400090	30	Baltimore City	240009001391	415	Baltimore School for the Arts	Regular School	No	High	09	12	2020	grade_9	109	109
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