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
1246790	MD	school	2400090	30	Baltimore City	240009001531	433	Renaissance Academy	Regular School	No	High	09	12	2020	grade_11	52	52
1317142	MD	school	2400510	16	Prince George's	240051001718	2142	College Park Academy	Regular School	Yes	High	06	12	2021	grade_11	52	52
1238170	MD	school	2400060	2	Anne Arundel	240006001401	6223	Chesapeake Science Point	Regular School	Yes	High	06	12	2020	grade_11	54	54
1244555	MD	school	2400510	16	Prince George's	240051001718	2142	College Park Academy	Regular School	Yes	High	06	12	2020	grade_11	54	54
1246762	MD	school	2400090	30	Baltimore City	240009001559	422	New Era Academy	Regular School	No	High	09	12	2020	grade_11	54	54
1317481	MD	school	2400630	20	Talbot	240063001248	202	St. Michaels Middle/High School	Regular School	No	High	06	12	2021	grade_11	55	55
1316045	MD	school	2400510	16	Prince George's	240051001424	705	Tall Oaks High	Alternative School	No	High	11	12	2021	grade_11	59	59
1246775	MD	school	2400090	30	Baltimore City	240009001385	429	Vivien T. Thomas Medical Arts Academy	Career and Technical School	No	High	09	12	2020	grade_11	61	61
1310734	MD	school	2400060	2	Anne Arundel	240006001401	6223	Chesapeake Science Point	Regular School	Yes	High	06	12	2021	grade_11	61	61
1244256	MD	school	2400510	16	Prince George's	240051001738	1732	International High School @ Langley Park	Regular School	No	High	09	12	2020	grade_11	63	63
1310554	MD	school	2400060	2	Anne Arundel	240006001714	4074	Phoenix Academy	Special Education School	No	Other	01	12	2021	grade_11	63	63
1244906	MD	school	2400630	20	Talbot	240063001248	202	St. Michaels Middle/High School	Regular School	No	High	06	12	2020	grade_11	64	64
1246497	MD	school	2400090	30	Baltimore City	240009001302	325	ConneXions: A Community Based Arts School	Regular School	Yes	High	06	12	2020	grade_11	64	64
1319048	MD	school	2400090	30	Baltimore City	240009001302	325	ConneXions: A Community Based Arts School	Regular School	Yes	High	06	12	2021	grade_11	64	64
1319156	MD	school	2400090	30	Baltimore City	240009001682	348	Baltimore Leadership School for Young Women	Regular School	Yes	High	06	12	2021	grade_11	64	64
1246684	MD	school	2400090	30	Baltimore City	240009001703	382	Baltimore Design School	Regular School	No	High	06	12	2020	grade_11	66	66
1246780	MD	school	2400090	30	Baltimore City	240009001387	430	Augusta Fells Savage Institute of Visual Arts	Regular School	No	High	09	12	2020	grade_11	66	66
1246785	MD	school	2400090	30	Baltimore City	240009001530	432	Coppin Academy	Regular School	Yes	High	09	12	2020	grade_11	70	70
1244943	MD	school	2400660	21	Washington	240066001674	40	Barbara Ingram School for the Arts	Regular School	No	High	09	12	2020	grade_11	71	71
1310230	MD	school	2400060	2	Anne Arundel	240006000899	2233	Anne Arundel Evening High	Alternative School	No	High	09	12	2021	grade_11	71	71
1319320	MD	school	2400090	30	Baltimore City	240009001385	429	Vivien T. Thomas Medical Arts Academy	Career and Technical School	No	High	09	12	2021	grade_11	71	71
1246770	MD	school	2400090	30	Baltimore City	240009001381	427	Academy for College and Career Exploration	Regular School	No	High	06	12	2020	grade_11	73	73
1319227	MD	school	2400090	30	Baltimore City	240009001703	382	Baltimore Design School	Regular School	No	High	06	12	2021	grade_11	73	73
1319330	MD	school	2400090	30	Baltimore City	240009001530	432	Coppin Academy	Regular School	Yes	High	09	12	2021	grade_11	73	73
1319274	MD	school	2400090	30	Baltimore City	240009000236	413	Achievement Academy at Harbor City High	Alternative School	No	High	09	12	2021	grade_11	74	74
1316837	MD	school	2400510	16	Prince George's	240051001738	1732	International High School @ Langley Park	Regular School	No	High	09	12	2021	grade_11	77	77
1237668	MD	school	2400060	2	Anne Arundel	240006000899	2233	Anne Arundel Evening High	Alternative School	No	High	09	12	2020	grade_11	79	79
1246729	MD	school	2400090	30	Baltimore City	240009000236	413	Achievement Academy at Harbor City High	Alternative School	No	High	09	12	2020	grade_11	79	79
1244854	MD	school	2400570	19	Somerset	240057001201	702	Crisfield Academy and High School	Regular School	No	High	08	12	2020	grade_11	80	80
1317518	MD	school	2400660	21	Washington	240066001674	40	Barbara Ingram School for the Arts	Regular School	No	High	09	12	2021	grade_11	80	80
1245229	MD	school	2400690	22	Wicomico	240069001306	102	Mardela Middle & High	Regular School	No	High	06	12	2020	grade_11	81	81
1245385	MD	school	2400720	23	Worcester	240072001334	207	Snow Hill High	Regular School	No	High	09	12	2020	grade_11	81	81
1317944	MD	school	2400720	23	Worcester	240072001330	107	Pocomoke High	Regular School	No	High	09	12	2021	grade_11	82	82
1317961	MD	school	2400720	23	Worcester	240072001334	207	Snow Hill High	Regular School	No	High	09	12	2021	grade_11	83	83
1316524	MD	school	2400510	16	Prince George's	240051001726	1351	Chesapeake Math and IT South Public Charter	Regular School	Yes	Other	KG	12	2021	grade_11	84	84
1243948	MD	school	2400510	16	Prince George's	240051001737	1352	International High school @ Largo	Regular School	No	High	09	12	2020	grade_11	88	88
1246749	MD	school	2400090	30	Baltimore City	240009001331	419	Reginald F. Lewis High	Regular School	No	High	09	12	2020	grade_11	89	89
1316529	MD	school	2400510	16	Prince George's	240051001737	1352	International High school @ Largo	Regular School	No	High	09	12	2021	grade_11	90	90
1318546	MD	school	2400090	30	Baltimore City	240009001343	178	Excel Academy at Francis M. Wood High	Alternative School	No	High	09	12	2021	grade_11	90	90
1245368	MD	school	2400720	23	Worcester	240072001330	107	Pocomoke High	Regular School	No	High	09	12	2020	grade_11	91	91
1319307	MD	school	2400090	30	Baltimore City	240009001559	422	New Era Academy	Regular School	No	High	09	12	2021	grade_11	92	92
1317432	MD	school	2400570	19	Somerset	240057001201	702	Crisfield Academy and High School	Regular School	No	High	08	12	2021	grade_11	93	93
1319325	MD	school	2400090	30	Baltimore City	240009001387	430	Augusta Fells Savage Institute of Visual Arts	Regular School	No	High	09	12	2021	grade_11	95	95
1244560	MD	school	2400510	16	Prince George's	240051001054	2211	Northwestern Evening/Saturday High	Alternative School	No	High	09	12	2020	grade_11	96	96
1243944	MD	school	2400510	16	Prince George's	240051001726	1351	Chesapeake Math and IT South Public Charter	Regular School	Yes	Other	KG	12	2020	grade_11	98	98
1244839	MD	school	2400570	19	Somerset	240057001213	102	Washington Academy and High School	Regular School	No	High	08	12	2020	grade_11	98	98
1317601	MD	school	2400660	21	Washington	240066001260	403	Clear Spring High	Regular School	No	High	09	12	2021	grade_11	98	98
1319211	MD	school	2400090	30	Baltimore City	240009001690	376	City Neighbors High	Regular School	Yes	High	09	12	2021	grade_11	98	98
1246272	MD	school	2400090	30	Baltimore City	240009000157	239	Benjamin Franklin High School at Masonville Cove	Regular School	No	High	09	12	2020	grade_11	101	101
1319294	MD	school	2400090	30	Baltimore City	240009001331	419	Reginald F. Lewis High	Regular School	No	High	09	12	2021	grade_11	101	101
1317805	MD	school	2400690	22	Wicomico	240069001306	102	Mardela Middle & High	Regular School	No	High	06	12	2021	grade_11	104	104
1246668	MD	school	2400090	30	Baltimore City	240009001690	376	City Neighbors High	Regular School	Yes	High	09	12	2020	grade_11	105	105
1246619	MD	school	2400090	30	Baltimore City	240009001735	362	Bard High School Early College	Regular School	No	High	09	12	2020	grade_11	106	106
1317417	MD	school	2400570	19	Somerset	240057001213	102	Washington Academy and High School	Regular School	No	High	08	12	2021	grade_11	106	106
1318834	MD	school	2400090	30	Baltimore City	240009000157	239	Benjamin Franklin High School at Masonville Cove	Regular School	No	High	09	12	2021	grade_11	106	106
1319284	MD	school	2400090	30	Baltimore City	240009001391	415	Baltimore School for the Arts	Regular School	No	High	09	12	2021	grade_11	106	106
1246714	MD	school	2400090	30	Baltimore City	240009000203	406	Forest Park High	Regular School	No	High	09	12	2020	grade_11	108	108
1319161	MD	school	2400090	30	Baltimore City	240009001735	362	Bard High School Early College	Regular School	No	High	09	12	2021	grade_11	108	108
1240854	MD	school	2400360	11	Garrett	240036000671	3512	Northern Garrett High School	Regular School	No	High	09	12	2020	grade_11	109	109
1246570	MD	school	2400090	30	Baltimore City	240009001663	341	The Reach! Partnership School	Regular School	No	High	09	12	2020	grade_11	109	109
1319315	MD	school	2400090	30	Baltimore City	240009001381	427	Academy for College and Career Exploration	Regular School	No	High	06	12	2021	grade_11	112	112
1246676	MD	school	2400090	30	Baltimore City	240009001691	377	Green Street Academy	Regular School	Yes	High	06	12	2020	grade_11	113	113
1246739	MD	school	2400090	30	Baltimore City	240009001391	415	Baltimore School for the Arts	Regular School	No	High	09	12	2020	grade_11	114	114
1246757	MD	school	2400090	30	Baltimore City	240009001339	421	National Academy Foundation	Regular School	No	High	06	12	2020	grade_11	115	115
1312114	MD	school	2400180	5	Caroline	240018000518	801	Colonel Richardson High School	Regular School	No	High	09	12	2021	grade_11	115	115
1313407	MD	school	2400360	11	Garrett	240036000671	3512	Northern Garrett High School	Regular School	No	High	09	12	2021	grade_11	120	120
1319302	MD	school	2400090	30	Baltimore City	240009001339	421	National Academy Foundation	Regular School	No	High	06	12	2021	grade_11	120	120
1240283	MD	school	2400300	9	Dorchester	240030000618	207	North Dorchester High School	Regular School	No	High	09	12	2020	grade_11	121	121
1243660	MD	school	2400510	16	Prince George's	240051001708	1015	Chesapeake Math and IT Public Charter	Regular School	Yes	Other	KG	12	2020	grade_11	123	123
1312830	MD	school	2400300	9	Dorchester	240030000618	207	North Dorchester High School	Regular School	No	High	09	12	2021	grade_11	124	124
1245983	MD	school	2400090	30	Baltimore City	240009001343	178	Excel Academy at Francis M. Wood High	Alternative School	No	High	08	12	2020	grade_11	125	125
1237252	MD	school	2400030	1	Allegany	240003000030	601	Center for Career & Technical Education	Career and Technical School	No	High	11	12	2020	grade_11	126	126
1245026	MD	school	2400660	21	Washington	240066001260	403	Clear Spring High	Regular School	No	High	09	12	2020	grade_11	126	126
1309794	MD	school	2400030	1	Allegany	240003000015	405	Fort Hill High	Regular School	No	High	09	12	2021	grade_11	126	126
1319340	MD	school	2400090	30	Baltimore City	240009000209	450	Frederick Douglass High	Regular School	No	High	09	12	2021	grade_11	126	126
1239564	MD	school	2400180	5	Caroline	240018000518	801	Colonel Richardson High School	Regular School	No	High	09	12	2020	grade_11	127	127
1319219	MD	school	2400090	30	Baltimore City	240009001691	377	Green Street Academy	Regular School	Yes	High	06	12	2021	grade_11	128	128
1319259	MD	school	2400090	30	Baltimore City	240009000203	406	Forest Park High	Regular School	No	High	09	12	2021	grade_11	132	132
1241212	MD	school	2400390	12	Harford	240039000697	678	Havre de Grace High	Regular School	No	High	09	12	2020	grade_11	133	133
1309813	MD	school	2400030	1	Allegany	240003000030	601	Center for Career & Technical Education	Career and Technical School	No	High	11	12	2021	grade_11	134	134
1319120	MD	school	2400090	30	Baltimore City	240009001663	341	The Reach! Partnership School	Regular School	No	High	09	12	2021	grade_11	134	134
1243930	MD	school	2400510	16	Prince George's	240051001704	1350	Academy of Health Sciences at PGCC	Regular School	No	High	09	12	2020	grade_11	136	136
1314270	MD	school	2400450	14	Kent	240045000768	301	Kent County High	Regular School	No	High	09	12	2021	grade_11	136	136
1246795	MD	school	2400090	30	Baltimore City	240009000209	450	Frederick Douglass High	Regular School	No	High	09	12	2020	grade_11	137	137
1244284	MD	school	2400510	16	Prince George's	240051001002	1810	Central High	Regular School	No	High	09	12	2020	grade_11	138	138
1239847	MD	school	2400240	7	Cecil	240024000558	204	Bohemia Manor High	Regular School	No	High	09	12	2020	grade_11	140	140
1316143	MD	school	2400510	16	Prince George's	240051001167	908	Surrattsville High	Regular School	No	High	09	12	2021	grade_11	142	142
1240331	MD	school	2400300	9	Dorchester	240030000612	713	Cambridge-South Dorchester High School	Regular School	No	High	09	12	2020	grade_11	145	145
1241713	MD	school	2400450	14	Kent	240045000768	301	Kent County High	Regular School	No	High	09	12	2020	grade_11	148	148
1316510	MD	school	2400510	16	Prince George's	240051001704	1350	Academy of Health Sciences at PGCC	Regular School	No	High	09	12	2021	grade_11	148	148
1316865	MD	school	2400510	16	Prince George's	240051001002	1810	Central High	Regular School	No	High	09	12	2021	grade_11	150	150
1237233	MD	school	2400030	1	Allegany	240003000015	405	Fort Hill High	Regular School	No	High	09	12	2020	grade_11	154	154
1319244	MD	school	2400090	30	Baltimore City	240009000194	400	Edmondson-Westside High	Career and Technical School	No	High	09	12	2021	grade_11	157	157
1237326	MD	school	2400030	1	Allegany	240003001636	2404	Mountain Ridge High School	Regular School	No	High	09	12	2020	grade_11	161	161
1312395	MD	school	2400240	7	Cecil	240024000558	204	Bohemia Manor High	Regular School	No	High	09	12	2021	grade_11	161	161
1309887	MD	school	2400030	1	Allegany	240003001636	2404	Mountain Ridge High School	Regular School	No	High	09	12	2021	grade_11	165	165
1313184	MD	school	2400330	10	Frederick	240033000629	1509	Catoctin High	Regular School	No	High	09	12	2021	grade_11	165	165
1316241	MD	school	2400510	16	Prince George's	240051001708	1015	Chesapeake Math and IT Public Charter	Regular School	Yes	Other	KG	12	2021	grade_11	165	165
1240631	MD	school	2400330	10	Frederick	240033000629	1509	Catoctin High	Regular School	No	High	09	12	2020	grade_11	166	166
1243269	MD	school	2400510	16	Prince George's	240051001038	511	Friendly High	Regular School	No	High	09	12	2020	grade_11	166	166
1317639	MD	school	2400660	21	Washington	240066001285	701	Smithsburg High	Regular School	No	High	09	12	2021	grade_11	166	166