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 (total_int > :p3 or (total_int = :p3 and rowid > :p2)) order by total_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
1310553	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	01	12	2021	grade_10	57	57
1238169	MD	school	2400060	2	Anne Arundel	240006001401	6223	Chesapeake Science Point	Regular School	Yes	High	06	12	2020	grade_10	61	61
1319362	MD	school	2400027	32	SEED	240002701669	1000	The Seed School of Maryland	Regular School	No	High	06	12	2021	grade_10	61	61
1244554	MD	school	2400510	16	Prince George's	240051001718	2142	College Park Academy	Regular School	Yes	High	06	12	2020	grade_10	63	63
1244905	MD	school	2400630	20	Talbot	240063001248	202	St. Michaels Middle/High School	Regular School	No	High	06	12	2020	grade_10	66	66
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
1317480	MD	school	2400630	20	Talbot	240063001248	202	St. Michaels Middle/High School	Regular School	No	High	06	12	2021	grade_10	69	69
1319226	MD	school	2400090	30	Baltimore City	240009001703	382	Baltimore Design School	Regular School	No	High	06	12	2021	grade_10	69	69
1237989	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	KG	12	2020	grade_10	73	73
1310733	MD	school	2400060	2	Anne Arundel	240006001401	6223	Chesapeake Science Point	Regular School	Yes	High	06	12	2021	grade_10	74	74
1246683	MD	school	2400090	30	Baltimore City	240009001703	382	Baltimore Design School	Regular School	No	High	06	12	2020	grade_10	75	75
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
1317141	MD	school	2400510	16	Prince George's	240051001718	2142	College Park Academy	Regular School	Yes	High	06	12	2021	grade_10	76	76
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
1317431	MD	school	2400570	19	Somerset	240057001201	702	Crisfield Academy and High School	Regular School	No	High	08	12	2021	grade_10	77	77
1244942	MD	school	2400660	21	Washington	240066001674	40	Barbara Ingram School for the Arts	Regular School	No	High	09	12	2020	grade_10	80	80
1245367	MD	school	2400720	23	Worcester	240072001330	107	Pocomoke High	Regular School	No	High	09	12	2020	grade_10	80	80
1245384	MD	school	2400720	23	Worcester	240072001334	207	Snow Hill High	Regular School	No	High	09	12	2020	grade_10	81	81
1317517	MD	school	2400660	21	Washington	240066001674	40	Barbara Ingram School for the Arts	Regular School	No	High	09	12	2021	grade_10	81	81
1246774	MD	school	2400090	30	Baltimore City	240009001385	429	Vivien T. Thomas Medical Arts Academy	Career and Technical School	No	High	09	12	2020	grade_10	86	86
1243943	MD	school	2400510	16	Prince George's	240051001726	1351	Chesapeake Math and IT South Public Charter	Regular School	Yes	Other	KG	12	2020	grade_10	87	87
1317960	MD	school	2400720	23	Worcester	240072001334	207	Snow Hill High	Regular School	No	High	09	12	2021	grade_10	90	90
1317943	MD	school	2400720	23	Worcester	240072001330	107	Pocomoke High	Regular School	No	High	09	12	2021	grade_10	94	94
1246784	MD	school	2400090	30	Baltimore City	240009001530	432	Coppin Academy	Regular School	Yes	High	09	12	2020	grade_10	95	95
1317804	MD	school	2400690	22	Wicomico	240069001306	102	Mardela Middle & High	Regular School	No	High	06	12	2021	grade_10	97	97
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
1244853	MD	school	2400570	19	Somerset	240057001201	702	Crisfield Academy and High School	Regular School	No	High	08	12	2020	grade_10	98	98
1319329	MD	school	2400090	30	Baltimore City	240009001530	432	Coppin Academy	Regular School	Yes	High	09	12	2021	grade_10	99	99
1246761	MD	school	2400090	30	Baltimore City	240009001559	422	New Era Academy	Regular School	No	High	09	12	2020	grade_10	100	100
1316523	MD	school	2400510	16	Prince George's	240051001726	1351	Chesapeake Math and IT South Public Charter	Regular School	Yes	Other	KG	12	2021	grade_10	102	102
1319210	MD	school	2400090	30	Baltimore City	240009001690	376	City Neighbors High	Regular School	Yes	High	09	12	2021	grade_10	106	106
1246667	MD	school	2400090	30	Baltimore City	240009001690	376	City Neighbors High	Regular School	Yes	High	09	12	2020	grade_10	108	108
1245228	MD	school	2400690	22	Wicomico	240069001306	102	Mardela Middle & High	Regular School	No	High	06	12	2020	grade_10	110	110
1319324	MD	school	2400090	30	Baltimore City	240009001387	430	Augusta Fells Savage Institute of Visual Arts	Regular School	No	High	09	12	2021	grade_10	110	110
1319306	MD	school	2400090	30	Baltimore City	240009001559	422	New Era Academy	Regular School	No	High	09	12	2021	grade_10	112	112
1313406	MD	school	2400360	11	Garrett	240036000671	3512	Northern Garrett High School	Regular School	No	High	09	12	2021	grade_10	114	114
1319283	MD	school	2400090	30	Baltimore City	240009001391	415	Baltimore School for the Arts	Regular School	No	High	09	12	2021	grade_10	114	114
1246779	MD	school	2400090	30	Baltimore City	240009001387	430	Augusta Fells Savage Institute of Visual Arts	Regular School	No	High	09	12	2020	grade_10	115	115
1319319	MD	school	2400090	30	Baltimore City	240009001385	429	Vivien T. Thomas Medical Arts Academy	Career and Technical School	No	High	09	12	2021	grade_10	115	115
1240853	MD	school	2400360	11	Garrett	240036000671	3512	Northern Garrett High School	Regular School	No	High	09	12	2020	grade_10	117	117
1239563	MD	school	2400180	5	Caroline	240018000518	801	Colonel Richardson High School	Regular School	No	High	09	12	2020	grade_10	119	119
1246738	MD	school	2400090	30	Baltimore City	240009001391	415	Baltimore School for the Arts	Regular School	No	High	09	12	2020	grade_10	119	119
1317416	MD	school	2400570	19	Somerset	240057001213	102	Washington Academy and High School	Regular School	No	High	08	12	2021	grade_10	120	120
1317600	MD	school	2400660	21	Washington	240066001260	403	Clear Spring High	Regular School	No	High	09	12	2021	grade_10	120	120
1319218	MD	school	2400090	30	Baltimore City	240009001691	377	Green Street Academy	Regular School	Yes	High	06	12	2021	grade_10	123	123
1319273	MD	school	2400090	30	Baltimore City	240009000236	413	Achievement Academy at Harbor City High	Alternative School	No	High	09	12	2021	grade_10	123	123
1312113	MD	school	2400180	5	Caroline	240018000518	801	Colonel Richardson High School	Regular School	No	High	09	12	2021	grade_10	124	124
1244838	MD	school	2400570	19	Somerset	240057001213	102	Washington Academy and High School	Regular School	No	High	08	12	2020	grade_10	125	125
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
1318545	MD	school	2400090	30	Baltimore City	240009001343	178	Excel Academy at Francis M. Wood High	Alternative School	No	High	09	12	2021	grade_10	125	125
1246769	MD	school	2400090	30	Baltimore City	240009001381	427	Academy for College and Career Exploration	Regular School	No	High	06	12	2020	grade_10	127	127
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
1246748	MD	school	2400090	30	Baltimore City	240009001331	419	Reginald F. Lewis High	Regular School	No	High	09	12	2020	grade_10	131	131
1245025	MD	school	2400660	21	Washington	240066001260	403	Clear Spring High	Regular School	No	High	09	12	2020	grade_10	132	132
1244559	MD	school	2400510	16	Prince George's	240051001054	2211	Northwestern Evening/Saturday High	Alternative School	No	High	09	12	2020	grade_10	133	133
1246675	MD	school	2400090	30	Baltimore City	240009001691	377	Green Street Academy	Regular School	Yes	High	06	12	2020	grade_10	133	133
1240282	MD	school	2400300	9	Dorchester	240030000618	207	North Dorchester High School	Regular School	No	High	09	12	2020	grade_10	134	134
1241712	MD	school	2400450	14	Kent	240045000768	301	Kent County High	Regular School	No	High	09	12	2020	grade_10	135	135
1316240	MD	school	2400510	16	Prince George's	240051001708	1015	Chesapeake Math and IT Public Charter	Regular School	Yes	Other	KG	12	2021	grade_10	140	140
1319301	MD	school	2400090	30	Baltimore City	240009001339	421	National Academy Foundation	Regular School	No	High	06	12	2021	grade_10	145	145
1246756	MD	school	2400090	30	Baltimore City	240009001339	421	National Academy Foundation	Regular School	No	High	06	12	2020	grade_10	147	147
1246569	MD	school	2400090	30	Baltimore City	240009001663	341	The Reach! Partnership School	Regular School	No	High	09	12	2020	grade_10	148	148
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
1314269	MD	school	2400450	14	Kent	240045000768	301	Kent County High	Regular School	No	High	09	12	2021	grade_10	150	150
1312829	MD	school	2400300	9	Dorchester	240030000618	207	North Dorchester High School	Regular School	No	High	09	12	2021	grade_10	151	151
1243929	MD	school	2400510	16	Prince George's	240051001704	1350	Academy of Health Sciences at PGCC	Regular School	No	High	09	12	2020	grade_10	152	152
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
1316509	MD	school	2400510	16	Prince George's	240051001704	1350	Academy of Health Sciences at PGCC	Regular School	No	High	09	12	2021	grade_10	162	162
1316142	MD	school	2400510	16	Prince George's	240051001167	908	Surrattsville High	Regular School	No	High	09	12	2021	grade_10	163	163
1312394	MD	school	2400240	7	Cecil	240024000558	204	Bohemia Manor High	Regular School	No	High	09	12	2021	grade_10	165	165
1237232	MD	school	2400030	1	Allegany	240003000015	405	Fort Hill High	Regular School	No	High	09	12	2020	grade_10	167	167
1243562	MD	school	2400510	16	Prince George's	240051001167	908	Surrattsville High	Regular School	No	High	09	12	2020	grade_10	167	167
1313411	MD	school	2400360	11	Garrett	240036000674	3709	Southern Garrett High School	Regular School	No	High	09	12	2021	grade_10	167	167
1240858	MD	school	2400360	11	Garrett	240036000674	3709	Southern Garrett High School	Regular School	No	High	09	12	2020	grade_10	170	170
1243659	MD	school	2400510	16	Prince George's	240051001708	1015	Chesapeake Math and IT Public Charter	Regular School	Yes	Other	KG	12	2020	grade_10	171	171
1239846	MD	school	2400240	7	Cecil	240024000558	204	Bohemia Manor High	Regular School	No	High	09	12	2020	grade_10	173	173
1309825	MD	school	2400030	1	Allegany	240003000001	606	Allegany High	Regular School	No	High	09	12	2021	grade_10	173	173
1315850	MD	school	2400510	16	Prince George's	240051001038	511	Friendly High	Regular School	No	High	09	12	2021	grade_10	173	173
1240950	MD	school	2400390	12	Harford	240039000705	181	Joppatowne High	Regular School	No	High	09	12	2020	grade_10	174	174
1246713	MD	school	2400090	30	Baltimore City	240009000203	406	Forest Park High	Regular School	No	High	09	12	2020	grade_10	175	175
1240630	MD	school	2400330	10	Frederick	240033000629	1509	Catoctin High	Regular School	No	High	09	12	2020	grade_10	176	176
1241211	MD	school	2400390	12	Harford	240039000697	678	Havre de Grace High	Regular School	No	High	09	12	2020	grade_10	177	177
1319293	MD	school	2400090	30	Baltimore City	240009001331	419	Reginald F. Lewis High	Regular School	No	High	09	12	2021	grade_10	177	177
1309793	MD	school	2400030	1	Allegany	240003000015	405	Fort Hill High	Regular School	No	High	09	12	2021	grade_10	178	178
1246794	MD	school	2400090	30	Baltimore City	240009000209	450	Frederick Douglass High	Regular School	No	High	09	12	2020	grade_10	181	181
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
1313767	MD	school	2400390	12	Harford	240039000697	678	Havre de Grace High	Regular School	No	High	09	12	2021	grade_10	182	182
1319314	MD	school	2400090	30	Baltimore City	240009001381	427	Academy for College and Career Exploration	Regular School	No	High	06	12	2021	grade_10	182	182
1244283	MD	school	2400510	16	Prince George's	240051001002	1810	Central High	Regular School	No	High	09	12	2020	grade_10	183	183
1319119	MD	school	2400090	30	Baltimore City	240009001663	341	The Reach! Partnership School	Regular School	No	High	09	12	2021	grade_10	184	184
1313503	MD	school	2400390	12	Harford	240039000705	181	Joppatowne High	Regular School	No	High	09	12	2021	grade_10	186	186
1319339	MD	school	2400090	30	Baltimore City	240009000209	450	Frederick Douglass High	Regular School	No	High	09	12	2021	grade_10	187	187
1313183	MD	school	2400330	10	Frederick	240033000629	1509	Catoctin High	Regular School	No	High	09	12	2021	grade_10	190	190
1243268	MD	school	2400510	16	Prince George's	240051001038	511	Friendly High	Regular School	No	High	09	12	2020	grade_10	194	194
1239997	MD	school	2400240	7	Cecil	240024000577	705	Perryville High	Regular School	No	High	09	12	2020	grade_10	195	195
1312877	MD	school	2400300	9	Dorchester	240030000612	713	Cambridge-South Dorchester High School	Regular School	No	High	09	12	2021	grade_10	196	196
1240738	MD	school	2400330	10	Frederick	240033000627	2503	Brunswick High	Regular School	No	High	09	12	2020	grade_10	197	197
1245982	MD	school	2400090	30	Baltimore City	240009001343	178	Excel Academy at Francis M. Wood High	Alternative School	No	High	08	12	2020	grade_10	200	200
1312545	MD	school	2400240	7	Cecil	240024000577	705	Perryville High	Regular School	No	High	09	12	2021	grade_10	203	203
1238856	MD	school	2400120	3	Baltimore County	240012000420	973	Loch Raven High	Regular School	No	High	09	12	2020	grade_10	205	205
1311082	MD	school	2400120	3	Baltimore County	240012000449	371	Pikesville High	Regular School	No	High	09	12	2021	grade_10	208	208