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 (district > :p3 or (district = :p3 and rowid > :p2)) order by district, 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
1312000	MD	school	2400150	4	Calvert	240015000508	213	Calvert High	Regular School	No	High	09	12	2021	grade_12	298	298
1312017	MD	school	2400150	4	Calvert	240015001342	217	Huntingtown High School	Regular School	No	High	09	12	2021	grade_12	377	377
1312037	MD	school	2400150	4	Calvert	240015000516	314	Northern High	Regular School	No	High	09	12	2021	grade_12	365	365
1239560	MD	school	2400180	5	Caroline	240018000523	703	North Caroline High School	Regular School	No	High	09	12	2020	grade_12	261	261
1239565	MD	school	2400180	5	Caroline	240018000518	801	Colonel Richardson High School	Regular School	No	High	09	12	2020	grade_12	119	119
1312110	MD	school	2400180	5	Caroline	240018000523	703	North Caroline High School	Regular School	No	High	09	12	2021	grade_12	275	275
1312115	MD	school	2400180	5	Caroline	240018000518	801	Colonel Richardson High School	Regular School	No	High	09	12	2021	grade_12	132	132
1239586	MD	school	2400210	6	Carroll	240021000533	202	Francis Scott Key High	Regular School	No	High	09	12	2020	grade_12	245	245
1239650	MD	school	2400210	6	Carroll	240021001394	507	Liberty High	Regular School	No	High	09	12	2020	grade_12	261	261
1239667	MD	school	2400210	6	Carroll	240021001161	510	Century High	Regular School	No	High	09	12	2020	grade_12	263	263
1239680	MD	school	2400210	6	Carroll	240021001672	602	Manchester Valley High	Regular School	No	High	09	12	2020	grade_12	295	295
1239701	MD	school	2400210	6	Carroll	240021001185	704	Winters Mill High	Regular School	No	High	09	12	2020	grade_12	218	218
1239714	MD	school	2400210	6	Carroll	240021000552	707	Westminster High	Regular School	No	High	09	12	2020	grade_12	306	306
1239743	MD	school	2400210	6	Carroll	240021000527	712	Carroll Springs School	Special Education School	No	Other	PK	12	2020	grade_12	*
1239763	MD	school	2400210	6	Carroll	240021001548	716	Gateway School	Alternative School	No	High	09	12	2020	grade_12	13	13
1239765	MD	school	2400210	6	Carroll	240021001348	717	Post Secondary Program	Alternative School	No	High	12	12	2020	grade_12	44	44
1239801	MD	school	2400210	6	Carroll	240021001350	903	Flexible Student Support	Alternative School	No	High	09	12	2020	grade_12	14	14
1239835	MD	school	2400210	6	Carroll	240021000546	1401	South Carroll High	Regular School	No	High	09	12	2020	grade_12	248	248
1312136	MD	school	2400210	6	Carroll	240021000533	202	Francis Scott Key High	Regular School	No	High	09	12	2021	grade_12	207	207
1312200	MD	school	2400210	6	Carroll	240021001394	507	Liberty High	Regular School	No	High	09	12	2021	grade_12	244	244
1312217	MD	school	2400210	6	Carroll	240021001161	510	Century High	Regular School	No	High	09	12	2021	grade_12	291	291
1312230	MD	school	2400210	6	Carroll	240021001672	602	Manchester Valley High	Regular School	No	High	09	12	2021	grade_12	286	286
1312251	MD	school	2400210	6	Carroll	240021001185	704	Winters Mill High	Regular School	No	High	09	12	2021	grade_12	262	262
1312264	MD	school	2400210	6	Carroll	240021000552	707	Westminster High	Regular School	No	High	09	12	2021	grade_12	401	401
1312291	MD	school	2400210	6	Carroll	240021000527	712	Carroll Springs School	Special Education School	No	Other	01	12	2021	grade_12	*
1312311	MD	school	2400210	6	Carroll	240021001548	716	Gateway School	Alternative School	No	High	09	12	2021	grade_12	12	12
1312313	MD	school	2400210	6	Carroll	240021001348	717	Post Secondary Program	Alternative School	No	High	12	12	2021	grade_12	50	50
1312349	MD	school	2400210	6	Carroll	240021001350	903	Flexible Student Support	Alternative School	No	High	09	12	2021	grade_12	12	12
1312383	MD	school	2400210	6	Carroll	240021000546	1401	South Carroll High	Regular School	No	High	09	12	2021	grade_12	249	249
1239848	MD	school	2400240	7	Cecil	240024000558	204	Bohemia Manor High	Regular School	No	High	09	12	2020	grade_12	157	157
1239865	MD	school	2400240	7	Cecil	240024000568	302	Elkton High	Regular School	No	High	09	12	2020	grade_12	229	229
1239954	MD	school	2400240	7	Cecil	240024000575	514	North East High	Regular School	No	High	09	12	2020	grade_12	238	238
1239999	MD	school	2400240	7	Cecil	240024000577	705	Perryville High	Regular School	No	High	09	12	2020	grade_12	199	199
1240020	MD	school	2400240	7	Cecil	240024090469	905	Rising Sun High	Regular School	No	High	09	12	2020	grade_12	278	278
1312396	MD	school	2400240	7	Cecil	240024000558	204	Bohemia Manor High	Regular School	No	High	09	12	2021	grade_12	146	146
1312413	MD	school	2400240	7	Cecil	240024000568	302	Elkton High	Regular School	No	High	09	12	2021	grade_12	245	245
1312502	MD	school	2400240	7	Cecil	240024000575	514	North East High	Regular School	No	High	09	12	2021	grade_12	252	252
1312547	MD	school	2400240	7	Cecil	240024000577	705	Perryville High	Regular School	No	High	09	12	2021	grade_12	193	193
1312568	MD	school	2400240	7	Cecil	240024090469	905	Rising Sun High	Regular School	No	High	09	12	2021	grade_12	271	271
1240037	MD	school	2400270	8	Charles	240027000596	106	La Plata High School	Regular School	No	High	09	12	2020	grade_12	271	271
1240042	MD	school	2400270	8	Charles	240027000600	108	Maurice J. McDonough High School	Regular School	No	High	09	12	2020	grade_12	188	188
1240083	MD	school	2400270	8	Charles	240027000607	605	Thomas Stone High School	Regular School	No	High	09	12	2020	grade_12	264	264
1240152	MD	school	2400270	8	Charles	240027000144	619	Westlake High School	Regular School	No	High	09	12	2020	grade_12	282	282
1240177	MD	school	2400270	8	Charles	240027001416	623	North Point High School	Regular School	No	High	09	12	2020	grade_12	428	428
1240229	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	06	12	2020	grade_12	31	31
1240250	MD	school	2400270	8	Charles	240027001727	802	St. Charles High School	Regular School	No	High	09	12	2020	grade_12	350	350
1240271	MD	school	2400270	8	Charles	240027000597	1002	Henry E. Lackey High School	Regular School	No	High	09	12	2020	grade_12	220	220
1312585	MD	school	2400270	8	Charles	240027000596	106	La Plata High School	Regular School	No	High	09	12	2021	grade_12	292	292
1312590	MD	school	2400270	8	Charles	240027000600	108	Maurice J. McDonough High School	Regular School	No	High	09	12	2021	grade_12	245	245
1312631	MD	school	2400270	8	Charles	240027000607	605	Thomas Stone High School	Regular School	No	High	09	12	2021	grade_12	265	265
1312700	MD	school	2400270	8	Charles	240027000144	619	Westlake High School	Regular School	No	High	09	12	2021	grade_12	269	269
1312725	MD	school	2400270	8	Charles	240027001416	623	North Point High School	Regular School	No	High	09	12	2021	grade_12	438	438
1312776	MD	school	2400270	8	Charles	240027001395	708	Robert D. Stethem Educational Center	Alternative School	No	High	07	12	2021	grade_12	21	21
1312797	MD	school	2400270	8	Charles	240027001727	802	St. Charles High School	Regular School	No	High	09	12	2021	grade_12	310	310
1312818	MD	school	2400270	8	Charles	240027000597	1002	Henry E. Lackey High School	Regular School	No	High	09	12	2021	grade_12	253	253
1240284	MD	school	2400300	9	Dorchester	240030000618	207	North Dorchester High School	Regular School	No	High	09	12	2020	grade_12	102	102
1240332	MD	school	2400300	9	Dorchester	240030000612	713	Cambridge-South Dorchester High School	Regular School	No	High	09	12	2020	grade_12	127	127
1312831	MD	school	2400300	9	Dorchester	240030000618	207	North Dorchester High School	Regular School	No	High	09	12	2021	grade_12	126	126
1312879	MD	school	2400300	9	Dorchester	240030000612	713	Cambridge-South Dorchester High School	Regular School	No	High	09	12	2021	grade_12	139	139
1240387	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	06	12	2020	grade_12	*
1240392	MD	school	2400330	10	Frederick	240033000632	209	Frederick High	Regular School	No	High	09	12	2020	grade_12	379	379
1240409	MD	school	2400330	10	Frederick	240033000634	213	Gov. Thomas Johnson High	Regular School	No	High	09	12	2020	grade_12	422	422
1240472	MD	school	2400330	10	Frederick	240033000641	313	Middletown High	Regular School	No	High	09	12	2020	grade_12	263	263
1240505	MD	school	2400330	10	Frederick	240033000616	713	Urbana High	Regular School	No	High	09	12	2020	grade_12	447	447
1240540	MD	school	2400330	10	Frederick	240033000638	912	Linganore High	Regular School	No	High	09	12	2020	grade_12	309	309
1240590	MD	school	2400330	10	Frederick	240033001688	920	Oakdale High	Regular School	No	High	09	12	2020	grade_12	314	314
1240632	MD	school	2400330	10	Frederick	240033000629	1509	Catoctin High	Regular School	No	High	09	12	2020	grade_12	187	187
1240704	MD	school	2400330	10	Frederick	240033001550	2307	Tuscarora High	Regular School	No	High	09	12	2020	grade_12	369	369
1240735	MD	school	2400330	10	Frederick	240033000647	2404	Rock Creek	Special Education School	No	Other	PK	12	2020	grade_12	23	23
1240740	MD	school	2400330	10	Frederick	240033000627	2503	Brunswick High	Regular School	No	High	09	12	2020	grade_12	180	180
1240769	MD	school	2400330	10	Frederick	240033000655	2610	Walkersville High	Regular School	No	High	09	12	2020	grade_12	274	274
1312933	MD	school	2400330	10	Frederick	240033001410	208	Heather Ridge	Alternative School	No	High	07	12	2021	grade_12	*
1312938	MD	school	2400330	10	Frederick	240033000632	209	Frederick High	Regular School	No	High	09	12	2021	grade_12	362	362
1312955	MD	school	2400330	10	Frederick	240033000634	213	Gov. Thomas Johnson High	Regular School	No	High	09	12	2021	grade_12	402	402
1313018	MD	school	2400330	10	Frederick	240033000641	313	Middletown High	Regular School	No	High	09	12	2021	grade_12	289	289
1313051	MD	school	2400330	10	Frederick	240033000616	713	Urbana High	Regular School	No	High	09	12	2021	grade_12	465	465
1313093	MD	school	2400330	10	Frederick	240033000638	912	Linganore High	Regular School	No	High	09	12	2021	grade_12	322	322
1313143	MD	school	2400330	10	Frederick	240033001688	920	Oakdale High	Regular School	No	High	09	12	2021	grade_12	321	321
1313185	MD	school	2400330	10	Frederick	240033000629	1509	Catoctin High	Regular School	No	High	09	12	2021	grade_12	165	165
1313257	MD	school	2400330	10	Frederick	240033001550	2307	Tuscarora High	Regular School	No	High	09	12	2021	grade_12	384	384
1313288	MD	school	2400330	10	Frederick	240033000647	2404	Rock Creek	Special Education School	No	Other	PK	12	2021	grade_12	19	19
1313293	MD	school	2400330	10	Frederick	240033000627	2503	Brunswick High	Regular School	No	High	09	12	2021	grade_12	187	187
1313322	MD	school	2400330	10	Frederick	240033000655	2610	Walkersville High	Regular School	No	High	09	12	2021	grade_12	281	281
1240855	MD	school	2400360	11	Garrett	240036000671	3512	Northern Garrett High School	Regular School	No	High	09	12	2020	grade_12	92	92
1240860	MD	school	2400360	11	Garrett	240036000674	3709	Southern Garrett High School	Regular School	No	High	09	12	2020	grade_12	178	178
1313408	MD	school	2400360	11	Garrett	240036000671	3512	Northern Garrett High School	Regular School	No	High	09	12	2021	grade_12	107	107
1313413	MD	school	2400360	11	Garrett	240036000674	3709	Southern Garrett High School	Regular School	No	High	09	12	2021	grade_12	175	175
1240943	MD	school	2400390	12	Harford	240039000690	176	Edgewood High	Regular School	No	High	09	12	2020	grade_12	323	323
1240952	MD	school	2400390	12	Harford	240039000705	181	Joppatowne High	Regular School	No	High	09	12	2020	grade_12	156	156
1240961	MD	school	2400390	12	Harford	240039001638	187	Patterson Mill High School	Regular School	No	High	09	12	2020	grade_12	201	201
1240998	MD	school	2400390	12	Harford	240039000679	270	Aberdeen High	Regular School	No	High	09	12	2020	grade_12	331	331
1241004	MD	school	2400390	12	Harford	240039000480	292	Center for Educational Opportunity	Alternative School	No	High	08	12	2020	grade_12	12	12
1241009	MD	school	2400390	12	Harford	240039000694	304	Harford Technical High	Career and Technical School	No	High	09	12	2020	grade_12	234	234
1241098	MD	school	2400390	12	Harford	240039000683	373	Bel Air High	Regular School	No	High	09	12	2020	grade_12	388	388
1241107	MD	school	2400390	12	Harford	240039000691	382	Fallston High	Regular School	No	High	09	12	2020	grade_12	253	253
1241112	MD	school	2400390	12	Harford	240039001380	385	C. Milton Wright High	Regular School	No	High	09	12	2020	grade_12	373	373
1241131	MD	school	2400390	12	Harford	240039000703	391	John Archer School	Special Education School	No	Other	PK	12	2020	grade_12	49	49
1241180	MD	school	2400390	12	Harford	240039000710	580	North Harford High	Regular School	No	High	09	12	2020	grade_12	299	299
1241213	MD	school	2400390	12	Harford	240039000697	678	Havre de Grace High	Regular School	No	High	09	12	2020	grade_12	145	145
1313496	MD	school	2400390	12	Harford	240039000690	176	Edgewood High	Regular School	No	High	09	12	2021	grade_12	302	302
1313505	MD	school	2400390	12	Harford	240039000705	181	Joppatowne High	Regular School	No	High	09	12	2021	grade_12	168	168