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
1242026	MD	school	2400480	15	Montgomery	240048001451	239	Alternative Programs	Alternative School	No	High	07	12	2020	grade_10	32	32
1246271	MD	school	2400090	30	Baltimore City	240009000157	239	Benjamin Franklin High School at Masonville Cove	Regular School	No	High	09	12	2020	grade_10	125	125
1318833	MD	school	2400090	30	Baltimore City	240009000157	239	Benjamin Franklin High School at Masonville Cove	Regular School	No	High	09	12	2021	grade_10	158	158
1242054	MD	school	2400480	15	Montgomery	240048001040	246	Northwest High	Regular School	No	High	09	12	2020	grade_10	698	698
1314612	MD	school	2400480	15	Montgomery	240048001040	246	Northwest High	Regular School	No	High	09	12	2021	grade_10	661	661
1242067	MD	school	2400480	15	Montgomery	240048001541	249	Clarksburg High	Regular School	No	High	09	12	2020	grade_10	686	686
1314625	MD	school	2400480	15	Montgomery	240048001541	249	Clarksburg High	Regular School	No	High	09	12	2021	grade_10	606	606
1240996	MD	school	2400390	12	Harford	240039000679	270	Aberdeen High	Regular School	No	High	09	12	2020	grade_10	331	331
1313549	MD	school	2400390	12	Harford	240039000679	270	Aberdeen High	Regular School	No	High	09	12	2021	grade_10	354	354
1238468	MD	school	2400120	3	Baltimore County	240012000432	271	Milford Mill Academy	Regular School	No	High	09	12	2020	grade_10	346	346
1311023	MD	school	2400120	3	Baltimore County	240012000432	271	Milford Mill Academy	Regular School	No	High	09	12	2021	grade_10	326	326
1238473	MD	school	2400120	3	Baltimore County	240012000458	272	Randallstown High	Regular School	No	High	09	12	2020	grade_10	235	235
1311028	MD	school	2400120	3	Baltimore County	240012000458	272	Randallstown High	Regular School	No	High	09	12	2021	grade_10	333	333
1241002	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	08	12	2020	grade_10	15	15
1313557	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	06	12	2021	grade_10	37	37
1241712	MD	school	2400450	14	Kent	240045000768	301	Kent County High	Regular School	No	High	09	12	2020	grade_10	135	135
1244599	MD	school	2400540	17	Queen Anne's	240054001195	301	Queen Anne's County High School	Regular School	No	High	09	12	2020	grade_10	288	288
1244980	MD	school	2400660	21	Washington	240066001288	301	South Hagerstown High	Regular School	No	High	09	12	2020	grade_10	361	361
1246441	MD	school	2400090	30	Baltimore City	240009000336	301	William S. Baer School	Special Education School	No	Other	PK	12	2020	grade_10	*
1314269	MD	school	2400450	14	Kent	240045000768	301	Kent County High	Regular School	No	High	09	12	2021	grade_10	150	150
1317177	MD	school	2400540	17	Queen Anne's	240054001195	301	Queen Anne's County High School	Regular School	No	High	09	12	2021	grade_10	303	303
1317555	MD	school	2400660	21	Washington	240066001288	301	South Hagerstown High	Regular School	No	High	09	12	2021	grade_10	364	364
1318992	MD	school	2400090	30	Baltimore City	240009000336	301	William S. Baer School	Special Education School	No	Other	PK	12	2021	grade_10	*
1239863	MD	school	2400240	7	Cecil	240024000568	302	Elkton High	Regular School	No	High	09	12	2020	grade_10	253	253
1312411	MD	school	2400240	7	Cecil	240024000568	302	Elkton High	Regular School	No	High	09	12	2021	grade_10	266	266
1244691	MD	school	2400600	18	Saint Mary's	240060001218	303	Chopticon High	Regular School	No	High	09	12	2020	grade_10	418	418
1317269	MD	school	2400600	18	Saint Mary's	240060001218	303	Chopticon High	Regular School	No	High	09	12	2021	grade_10	442	442
1241007	MD	school	2400390	12	Harford	240039000694	304	Harford Technical High	Career and Technical School	No	High	09	12	2020	grade_10	246	246
1313562	MD	school	2400390	12	Harford	240039000694	304	Harford Technical High	Career and Technical School	No	High	09	12	2021	grade_10	247	247
1244700	MD	school	2400600	18	Saint Mary's	240060001356	306	Leonardtown High	Regular School	No	High	09	12	2020	grade_10	429	429
1317278	MD	school	2400600	18	Saint Mary's	240060001356	306	Leonardtown High	Regular School	No	High	09	12	2021	grade_10	502	502
1246447	MD	school	2400090	30	Baltimore City	240009000176	307	Claremont School	Special Education School	No	High	08	12	2020	grade_10	*
1318998	MD	school	2400090	30	Baltimore City	240009000176	307	Claremont School	Special Education School	No	High	07	12	2021	grade_10	*
1241412	MD	school	2400420	13	Howard	240042001437	308	Marriotts Ridge High	Regular School	No	High	09	12	2020	grade_10	372	372
1313967	MD	school	2400420	13	Howard	240042001437	308	Marriotts Ridge High	Regular School	No	High	09	12	2021	grade_10	441	441
1245398	MD	school	2400720	23	Worcester	240072001335	310	Stephen Decatur High	Regular School	No	High	09	12	2020	grade_10	332	332
1317974	MD	school	2400720	23	Worcester	240072001335	310	Stephen Decatur High	Regular School	No	High	09	12	2021	grade_10	374	374
1240470	MD	school	2400330	10	Frederick	240033000641	313	Middletown High	Regular School	No	High	09	12	2020	grade_10	291	291
1313016	MD	school	2400330	10	Frederick	240033000641	313	Middletown High	Regular School	No	High	09	12	2021	grade_10	288	288
1239480	MD	school	2400150	4	Calvert	240015000516	314	Northern High	Regular School	No	High	09	12	2020	grade_10	399	399
1312035	MD	school	2400150	4	Calvert	240015000516	314	Northern High	Regular School	No	High	09	12	2021	grade_10	350	350
1242152	MD	school	2400480	15	Montgomery	240048000890	315	Paint Branch High	Regular School	No	High	09	12	2020	grade_10	532	532
1314711	MD	school	2400480	15	Montgomery	240048000890	315	Paint Branch High	Regular School	No	High	09	12	2021	grade_10	546	546
1242164	MD	school	2400480	15	Montgomery	240048001044	321	James Hubert Blake High	Regular School	No	High	09	12	2020	grade_10	477	477
1314724	MD	school	2400480	15	Montgomery	240048001044	321	James Hubert Blake High	Regular School	No	High	09	12	2021	grade_10	463	463
1246496	MD	school	2400090	30	Baltimore City	240009001302	325	ConneXions: A Community Based Arts School	Regular School	Yes	High	06	12	2020	grade_10	77	77
1319047	MD	school	2400090	30	Baltimore City	240009001302	325	ConneXions: A Community Based Arts School	Regular School	Yes	High	06	12	2021	grade_10	75	75
1246540	MD	school	2400090	30	Baltimore City	240009001632	333	Independence School Local I	Regular School	Yes	High	09	12	2020	grade_10	37	37
1319091	MD	school	2400090	30	Baltimore City	240009001632	333	Independence School Local I	Regular School	Yes	High	09	12	2021	grade_10	39	39
1246569	MD	school	2400090	30	Baltimore City	240009001663	341	The Reach! Partnership School	Regular School	No	High	09	12	2020	grade_10	148	148
1319119	MD	school	2400090	30	Baltimore City	240009001663	341	The Reach! Partnership School	Regular School	No	High	09	12	2021	grade_10	184	184
1246577	MD	school	2400090	30	Baltimore City	240009001662	345	Joseph C. Briscoe Academy	Special Education School	No	High	06	12	2020	grade_10	14	14
1319127	MD	school	2400090	30	Baltimore City	240009001662	345	Joseph C. Briscoe Academy	Special Education School	No	High	06	12	2021	grade_10	*
1246605	MD	school	2400090	30	Baltimore City	240009001682	348	Baltimore Leadership School for Young Women	Regular School	Yes	High	06	12	2020	grade_10	69	69
1319155	MD	school	2400090	30	Baltimore City	240009001682	348	Baltimore Leadership School for Young Women	Regular School	Yes	High	06	12	2021	grade_10	50	50
1246613	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_10	47	47
1246618	MD	school	2400090	30	Baltimore City	240009001735	362	Bard High School Early College	Regular School	No	High	09	12	2020	grade_10	130	130
1319160	MD	school	2400090	30	Baltimore City	240009001735	362	Bard High School Early College	Regular School	No	High	09	12	2021	grade_10	97	97
1246626	MD	school	2400090	30	Baltimore City	240009001675	364	Bluford Drew Jemison STEM Academy West	Regular School	No	High	06	12	2020	grade_10	43	43
1319168	MD	school	2400090	30	Baltimore City	240009001675	364	Bluford Drew Jemison STEM Academy West	Regular School	No	High	06	12	2021	grade_10	25	25
1238527	MD	school	2400120	3	Baltimore County	240012000449	371	Pikesville High	Regular School	No	High	09	12	2020	grade_10	238	238
1311082	MD	school	2400120	3	Baltimore County	240012000449	371	Pikesville High	Regular School	No	High	09	12	2021	grade_10	208	208
1241096	MD	school	2400390	12	Harford	240039000683	373	Bel Air High	Regular School	No	High	09	12	2020	grade_10	395	395
1313652	MD	school	2400390	12	Harford	240039000683	373	Bel Air High	Regular School	No	High	09	12	2021	grade_10	383	383
1246667	MD	school	2400090	30	Baltimore City	240009001690	376	City Neighbors High	Regular School	Yes	High	09	12	2020	grade_10	108	108
1319210	MD	school	2400090	30	Baltimore City	240009001690	376	City Neighbors High	Regular School	Yes	High	09	12	2021	grade_10	106	106
1246675	MD	school	2400090	30	Baltimore City	240009001691	377	Green Street Academy	Regular School	Yes	High	06	12	2020	grade_10	133	133
1319218	MD	school	2400090	30	Baltimore City	240009001691	377	Green Street Academy	Regular School	Yes	High	06	12	2021	grade_10	123	123
1241105	MD	school	2400390	12	Harford	240039000691	382	Fallston High	Regular School	No	High	09	12	2020	grade_10	239	239
1246683	MD	school	2400090	30	Baltimore City	240009001703	382	Baltimore Design School	Regular School	No	High	06	12	2020	grade_10	75	75
1313661	MD	school	2400390	12	Harford	240039000691	382	Fallston High	Regular School	No	High	09	12	2021	grade_10	253	253
1319226	MD	school	2400090	30	Baltimore City	240009001703	382	Baltimore Design School	Regular School	No	High	06	12	2021	grade_10	69	69
1241110	MD	school	2400390	12	Harford	240039001380	385	C. Milton Wright High	Regular School	No	High	09	12	2020	grade_10	360	360
1313666	MD	school	2400390	12	Harford	240039001380	385	C. Milton Wright High	Regular School	No	High	09	12	2021	grade_10	313	313
1241129	MD	school	2400390	12	Harford	240039000703	391	John Archer School	Special Education School	No	Other	PK	12	2020	grade_10	*
1313685	MD	school	2400390	12	Harford	240039000703	391	John Archer School	Special Education School	No	Other	PK	12	2021	grade_10	*
1246698	MD	school	2400090	30	Baltimore City	240009000194	400	Edmondson-Westside High	Career and Technical School	No	High	09	12	2020	grade_10	182	182
1319243	MD	school	2400090	30	Baltimore City	240009000194	400	Edmondson-Westside High	Career and Technical School	No	High	09	12	2021	grade_10	208	208
1245423	MD	school	2400720	23	Worcester	240072001326	401	Cedar Chapel Special School	Special Education School	No	Other	PK	12	2020	grade_10	*
1317999	MD	school	2400720	23	Worcester	240072001326	401	Cedar Chapel Special School	Special Education School	No	Other	PK	12	2021	grade_10	*
1245025	MD	school	2400660	21	Washington	240066001260	403	Clear Spring High	Regular School	No	High	09	12	2020	grade_10	132	132
1246703	MD	school	2400090	30	Baltimore City	240009000151	403	Baltimore Polytechnic Institute	Regular School	No	High	09	12	2020	grade_10	411	411
1317600	MD	school	2400660	21	Washington	240066001260	403	Clear Spring High	Regular School	No	High	09	12	2021	grade_10	120	120
1319248	MD	school	2400090	30	Baltimore City	240009000151	403	Baltimore Polytechnic Institute	Regular School	No	High	09	12	2021	grade_10	399	399
1241417	MD	school	2400420	13	Howard	240042000731	404	Glenelg High	Regular School	No	High	09	12	2020	grade_10	321	321
1313972	MD	school	2400420	13	Howard	240042000731	404	Glenelg High	Regular School	No	High	09	12	2021	grade_10	312	312
1237232	MD	school	2400030	1	Allegany	240003000015	405	Fort Hill High	Regular School	No	High	09	12	2020	grade_10	167	167
1244630	MD	school	2400540	17	Queen Anne's	240054001076	405	Kent Island High School	Regular School	No	High	09	12	2020	grade_10	314	314
1246708	MD	school	2400090	30	Baltimore City	240009000297	405	Patterson High	Career and Technical School	No	High	09	12	2020	grade_10	268	268
1309793	MD	school	2400030	1	Allegany	240003000015	405	Fort Hill High	Regular School	No	High	09	12	2021	grade_10	178	178
1317208	MD	school	2400540	17	Queen Anne's	240054001076	405	Kent Island High School	Regular School	No	High	09	12	2021	grade_10	291	291
1319253	MD	school	2400090	30	Baltimore City	240009000297	405	Patterson High	Career and Technical School	No	High	09	12	2021	grade_10	377	377
1242266	MD	school	2400480	15	Montgomery	240048000784	406	Bethesda-Chevy Chase High	Regular School	No	High	09	12	2020	grade_10	602	602
1246713	MD	school	2400090	30	Baltimore City	240009000203	406	Forest Park High	Regular School	No	High	09	12	2020	grade_10	175	175
1314831	MD	school	2400480	15	Montgomery	240048000784	406	Bethesda-Chevy Chase High	Regular School	No	High	09	12	2021	grade_10	585	585
1319258	MD	school	2400090	30	Baltimore City	240009000203	406	Forest Park High	Regular School	No	High	09	12	2021	grade_10	239	239
1246718	MD	school	2400090	30	Baltimore City	240009000330	407	Western High	Regular School	No	High	09	12	2020	grade_10	288	288
1319263	MD	school	2400090	30	Baltimore City	240009000330	407	Western High	Regular School	No	High	09	12	2021	grade_10	316	316
1246723	MD	school	2400090	30	Baltimore City	240009000280	410	Mergenthaler Vocational-Technical High	Career and Technical School	No	High	09	12	2020	grade_10	312	312
1319268	MD	school	2400090	30	Baltimore City	240009000280	410	Mergenthaler Vocational-Technical High	Career and Technical School	No	High	09	12	2021	grade_10	499	499
1246728	MD	school	2400090	30	Baltimore City	240009000236	413	Achievement Academy at Harbor City High	Alternative School	No	High	09	12	2020	grade_10	150	150