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 order by school_state_id desc 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
242490	SC	school	4503907	5395	Governor's School for Science and Mathematics	450390701579	5395001	Governor's School for Science and Mathematics	Regular School	No	High	11	12	2020	grade_7	0.0	0
378779	SC	school	4503907	5395	Governor's School for Science and Mathematics	450390701579	5395001	Governor's School for Science and Mathematics	Regular School	No	High	11	12	2021	grade_7	0.0	0
242489	SC	school	4503904	5364	Governor's School for the Arts and Humanities	450390401580	5364001	Governor's School for the Arts and Humanities	Regular School	No	High	10	12	2020	grade_7	0.0	0
378778	SC	school	4503904	5364	Governor's School for the Arts and Humanities	450390401580	5364001	Governor's School for the Arts and Humanities	Regular School	No	High	10	12	2021	grade_7	0.0	0
242488	SC	school	4500001	5209	Department of Corrections	450000100238	5209024	Turbeville High	Alternative School	No	High	09	12	2020	grade_7	0.0	0
378777	SC	school	4500001	5209	Department of Corrections	450000100238	5209024	Turbeville High	Alternative School	No	High	09	12	2021	grade_7	0.0	0
242487	SC	school	4500001	5209	Department of Corrections	450000100266	5209023	Ridgeland High	Alternative School	No	High	09	12	2020	grade_7	0.0	0
378776	SC	school	4500001	5209	Department of Corrections	450000100266	5209023	Ridgeland High	Alternative School	No	High	09	12	2021	grade_7	0.0	0
242486	SC	school	4500001	5209	Department of Corrections	450000100148	5209022	Trenton High	Alternative School	No	High	09	12	2020	grade_7	0.0	0
378775	SC	school	4500001	5209	Department of Corrections	450000100148	5209022	Trenton High	Alternative School	No	High	09	12	2021	grade_7	0.0	0
242485	SC	school	4500001	5209	Department of Corrections	450000100063	5209021	Lee High	Alternative School	No	High	09	12	2020	grade_7	0.0	0
378774	SC	school	4500001	5209	Department of Corrections	450000100063	5209021	Lee High	Alternative School	No	High	09	12	2021	grade_7	0.0	0
378773	SC	school	4500001	5209	Department of Corrections	450000101721	5209018	Broad River	Alternative School	No	High	09	12	2021	grade_7	0.0	0
378772	SC	school	4500001	5209	Department of Corrections	450000101730	5209017	Allendale	Alternative School	No	High	09	12	2021	grade_7	0.0	0
242484	SC	school	4500001	5209	Department of Corrections	450000101378	5209011	Sara Babb High	Alternative School	No	High	09	12	2020	grade_7	0.0	0
378771	SC	school	4500001	5209	Department of Corrections	450000101378	5209011	Sara Babb High	Alternative School	No	High	09	12	2021	grade_7	0.0	0
242483	SC	school	4500001	5209	Department of Corrections	450000101423	5209009	Wateree River High	Alternative School	No	High	09	12	2020	grade_7	0.0	0
378770	SC	school	4500001	5209	Department of Corrections	450000101423	5209009	Wateree River High	Alternative School	No	High	09	12	2021	grade_7	0.0	0
242482	SC	school	4500001	5209	Department of Corrections	450000100939	5209007	Manning HS	Alternative School	No	High	09	12	2020	grade_7	0.0	0
242481	SC	school	4500001	5209	Department of Corrections	450000101376	5209006	MacDougall High	Alternative School	No	High	09	12	2020	grade_7	0.0	0
378769	SC	school	4500001	5209	Department of Corrections	450000101376	5209006	MacDougall High	Alternative School	No	High	09	12	2021	grade_7	0.0	0
378768	SC	school	4500001	5209	Department of Corrections	450000101731	5209005	Kirkland High	Alternative School	No	High	09	12	2021	grade_7	0.0	0
242480	SC	school	4500001	5209	Department of Corrections	450000100255	5209003	Tyger River High	Alternative School	No	High	09	12	2020	grade_7	0.0	0
378767	SC	school	4500001	5209	Department of Corrections	450000100255	5209003	Tyger River High	Alternative School	No	High	09	12	2021	grade_7	0.0	0
242479	SC	school	4503420	5208	Department of Juvenile Justice	450342001186	5208003	Evaluation & Detention Ctr	Alternative School	No	High	05	12	2020	grade_7	4.0	4
378766	SC	school	4503420	5208	Department of Juvenile Justice	450342001186	5208003	Evaluation & Detention Ctr	Alternative School	No	High	05	12	2021	grade_7	4.0	4
242478	SC	school	4503420	5208	Department of Juvenile Justice	450342001185	5208002	Birchwood School	Alternative School	No	High	05	12	2020	grade_7	3.0	3
378765	SC	school	4503420	5208	Department of Juvenile Justice	450342001185	5208002	Empowerment and EnrichmentAcademy	Alternative School	No	High	05	12	2021	grade_7	0.0	0
242477	SC	school	4503420	5208	Department of Juvenile Justice	450342001187	5208001	Willow Lane	Alternative School	No	High	05	12	2020	grade_7	13.0	13
378764	SC	school	4503420	5208	Department of Juvenile Justice	450342001187	5208001	The Palmetto Empowermentand Enrichment Academy	Alternative School	No	High	05	12	2021	grade_7	2.0	2
242476	SC	school	4500004	5207	SC School for the Deaf and the Blind	450000401402	5207011	Cedar Springs Academy	Special Education School	No	Other	PK	12	2020	grade_7	2.0	2
378763	SC	school	4500004	5207	SC Schools for the Deaf and the Blind	450000401402	5207011	Cedar Springs Academy	Special Education School	No	Other	PK	12	2021	grade_7	2.0	2
242475	SC	school	4500004	5207	SC School for the Deaf and the Blind	450000401246	5207010	SC School For Blind Elem/Middle	Special Education School	No	Elementary	PK	08	2020	grade_7	4.0	4
378762	SC	school	4500004	5207	SC Schools for the Deaf and the Blind	450000401246	5207010	SC School For BlindElem/Middle	Special Education School	No	Elementary	PK	08	2021	grade_7	5.0	5
242474	SC	school	4500004	5207	SC School for the Deaf and the Blind	450000401228	5207009	SC School For Deaf Elem/Middle	Special Education School	No	Elementary	PK	08	2020	grade_7	6.0	6
378761	SC	school	4500004	5207	SC Schools for the Deaf and the Blind	450000401228	5207009	SC School For DeafElem/Middle	Special Education School	No	Elementary	PK	08	2021	grade_7	6.0	6
242473	SC	school	4500004	5207	SC School for the Deaf and the Blind	450000401227	5207007	SC School For Deaf High	Special Education School	No	High	09	12	2020	grade_7	0.0	0
378760	SC	school	4500004	5207	SC Schools for the Deaf and the Blind	450000401227	5207007	SC School For Deaf High	Special Education School	No	High	09	12	2021	grade_7	0.0	0
242472	SC	school	4500004	5207	SC School for the Deaf and the Blind	450000401226	5207005	SC School For Blind High	Special Education School	No	High	09	12	2020	grade_7	0.0	0
378759	SC	school	4500004	5207	SC Schools for the Deaf and the Blind	450000401226	5207005	SC School For Blind High	Special Education School	No	High	09	12	2021	grade_7	0.0	0
378758	SC	school	4503903	5205	John de la Howe	450390301754	5205003	Governor's School for Agriculture at John de la Howe Agriculture	Regular School	No	High	10	12	2021	grade_7	0.0	0
378757	SC	school	4503909	4801	Charter Institute at Erskine	450390901687	4801022	Brashier Middle CollegeCharter High	Regular School	Yes	High	09	12	2021	grade_7	0.0	0
378756	SC	school	4503909	4801	Charter Institute at Erskine	450390900684	4801021	Horse Creek Academy	Regular School	Yes	Other	PK	09	2021	grade_7	72.0	72
378755	SC	school	4503909	4801	Charter Institute at Erskine	450390901755	4801020	Cherokee Charter School	Regular School	Yes	Elementary	KG	05	2021	grade_7	0.0	0
378754	SC	school	4503909	4801	Charter Institute at Erskine	450390901613	4801019	Lowcountry Leadership Charter School	Regular School	Yes	Other	KG	12	2021	grade_7	44.0	44
378753	SC	school	4503909	4801	Charter Institute at Erskine	450390901520	4801018	SC Connections Academy	Regular School	Yes	Other	KG	12	2021	grade_7	584.0	584
242471	SC	school	4503909	4801	Charter Institute at Erskine	450390901719	4801017	Summit Classical School	Regular School	Yes	Elementary	KG	03	2020	grade_7	0.0	0
378752	SC	school	4503909	4801	Charter Institute at Erskine	450390901719	4801017	Summit Classical School	Regular School	Yes	Elementary	KG	05	2021	grade_7	0.0	0
242470	SC	school	4503909	4801	Charter Institute at Erskine	450390901715	4801016	Legion Collegiate Academy	Regular School	Yes	High	09	12	2020	grade_7	0.0	0
378751	SC	school	4503909	4801	Charter Institute at Erskine	450390901715	4801016	Legion Collegiate Academy	Regular School	Yes	High	09	12	2021	grade_7	0.0	0
242469	SC	school	4503909	4801	Charter Institute at Erskine	450390901716	4801015	Thornwell Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_7	0.0	0
378750	SC	school	4503909	4801	Charter Institute at Erskine	450390901716	4801015	Thornwell Charter School	Regular School	Yes	Elementary	KG	08	2021	grade_7	26.0	26
242468	SC	school	4503909	4801	Charter Institute at Erskine	450390901717	4801014	Clear Dot Charter	Regular School	Yes	Elementary	KG	06	2020	grade_7	0.0	0
378749	SC	school	4503909	4801	Charter Institute at Erskine	450390901717	4801014	Clear Dot Charter	Regular School	Yes	Elementary	KG	07	2021	grade_7	17.0	17
242467	SC	school	4503909	4801	Charter Institute at Erskine	450390901510	4801013	Calhoun Falls Charter School	Regular School	Yes	High	06	12	2020	grade_7	23.0	23
378748	SC	school	4503909	4801	Charter Institute at Erskine	450390901510	4801013	Calhoun Falls Charter School	Regular School	Yes	High	06	12	2021	grade_7	20.0	20
242466	SC	school	4503909	4801	Charter Institute at Erskine	450390901616	4801012	Cyber Academy of South Carolina	Regular School	Yes	Other	KG	12	2020	grade_7	230.0	230
378747	SC	school	4503909	4801	Charter Institute at Erskine	450390901616	4801012	Cyber Academy of SouthCarolina	Regular School	Yes	Other	KG	12	2021	grade_7	510.0	510
242465	SC	school	4503909	4801	Charter Institute at Erskine	450390901513	4801011	South Carolina Virtual Charter	Regular School	Yes	Other	KG	12	2020	grade_7	309.0	309
378746	SC	school	4503909	4801	Charter Institute at Erskine	450390901513	4801011	South Carolina Virtual Charter	Regular School	Yes	Other	KG	12	2021	grade_7	410.0	410
242464	SC	school	4503909	4801	Charter Institute at Erskine	450390901527	4801010	Odyssey Online Learning	Regular School	Yes	High	09	12	2020	grade_7	0.0	0
378745	SC	school	4503909	4801	Charter Institute at Erskine	450390901527	4801010	Odyssey Online Learning	Regular School	Yes	High	09	12	2021	grade_7	0.0	0
242463	SC	school	4503909	4801	Charter Institute at Erskine	450390901642	4801009	Midlands STEM Institute	Regular School	Yes	Other	KG	10	2020	grade_7	16.0	16
378744	SC	school	4503909	4801	Charter Institute at Erskine	450390901642	4801009	Midlands STEM Institute	Regular School	Yes	Other	KG	11	2021	grade_7	20.0	20
242462	SC	school	4503909	4801	Charter Institute at Erskine	450390901615	4801008	Coastal Leadership Academy	Regular School	Yes	High	09	12	2020	grade_7	0.0	0
378743	SC	school	4503909	4801	Charter Institute at Erskine	450390901615	4801008	Coastal Leadership Academy	Regular School	Yes	High	09	12	2021	grade_7	0.0	0
242461	SC	school	4503909	4801	Charter Institute at Erskine	450390901650	4801007	Gray Collegiate Academy	Regular School	Yes	High	09	12	2020	grade_7	0.0	0
378742	SC	school	4503909	4801	Charter Institute at Erskine	450390901650	4801007	Gray Collegiate Academy	Regular School	Yes	High	08	12	2021	grade_7	0.0	0
242460	SC	school	4503909	4801	Charter Institute at Erskine	450390901686	4801006	Mevers School of Excellence	Regular School	Yes	Elementary	KG	08	2020	grade_7	93.0	93
378741	SC	school	4503909	4801	Charter Institute at Erskine	450390901686	4801006	Mevers School of Excellence	Regular School	Yes	Elementary	KG	08	2021	grade_7	71.0	71
242459	SC	school	4503909	4801	Charter Institute at Erskine	450390901663	4801005	Oceanside Collegiate Academy	Regular School	Yes	High	09	12	2020	grade_7	0.0	0
378740	SC	school	4503909	4801	Charter Institute at Erskine	450390901663	4801005	Oceanside Collegiate Academy	Regular School	Yes	High	09	12	2021	grade_7	0.0	0
242458	SC	school	4503909	4801	Charter Institute at Erskine	450390901590	4801004	Royal Oaks Academy of the Arts and Sciences	Regular School	Yes	Other	KG	12	2020	grade_7	50.0	50
378739	SC	school	4503909	4801	Charter Institute at Erskine	450390901590	4801004	Royal Oaks Academy of theArts and Sciences	Regular School	Yes	Other	KG	12	2021	grade_7	54.0	54
242457	SC	school	4503909	4801	Charter Institute at Erskine	450390901701	4801003	The Montessori School of Camden	Regular School	Yes	Elementary	KG	07	2020	grade_7	12.0	12
378738	SC	school	4503909	4801	Charter Institute at Erskine	450390901701	4801003	The Montessori School ofCamden	Regular School	Yes	Elementary	PK	08	2021	grade_7	3.0	3
242456	SC	school	4503909	4801	Charter Institute at Erskine	450390901700	4801002	Belton Preparatory Academy	Regular School	Yes	Elementary	KG	03	2020	grade_7	0.0	0
378737	SC	school	4503909	4801	Charter Institute at Erskine	450390901700	4801002	Belton Preparatory Academy	Regular School	Yes	Elementary	KG	04	2021	grade_7	0.0	0
242455	SC	school	4503909	4801	Charter Institute at Erskine	450390901699	4801001	Virtus Academy of South Carolina	Regular School	Yes	Elementary	KG	06	2020	grade_7	0.0	0
378736	SC	school	4503909	4801	Charter Institute at Erskine	450390901699	4801001	Virtus Academy of SouthCarolina	Regular School	Yes	Elementary	KG	07	2021	grade_7	40.0	40
378735	SC	school	4503901	4701	SC Public Charter School	450390101737	4701060	Butler Academy	Regular School	Yes	Elementary	KG	04	2021	grade_7	0.0	0
242454	SC	school	4503901	4701	SC Public Charter School District	450390101733	4701058	Renaissance Collegiate Academy	Regular School	Yes	Elementary	KG	02	2020	grade_7	0.0	0
378734	SC	school	4503901	4701	SC Public Charter School	450390101733	4701058	Renaissance CollegiateAcademy	Regular School	Yes	Elementary	KG	03	2021	grade_7	0.0	0
242453	SC	school	4503901	4701	SC Public Charter School District	450390101722	4701057	GREEN Charter School of Spartanburg	Regular School	Yes	Elementary	KG	06	2020	grade_7	0.0	0
378733	SC	school	4503901	4701	SC Public Charter School	450390101722	4701057	GREEN Charter School ofSpartanburg	Regular School	Yes	Elementary	PK	07	2021	grade_7	28.0	28
242452	SC	school	4503901	4701	SC Public Charter School District	450390101703	4701056	Midlands Arts Conservatory	Regular School	Yes	Middle	06	08	2020	grade_7	48.0	48
378732	SC	school	4503901	4701	SC Public Charter School	450390101703	4701056	Midlands Arts Conservatory	Regular School	Yes	Middle	06	09	2021	grade_7	43.0	43
242451	SC	school	4503901	4701	SC Public Charter School District	450390101706	4701055	Charleston Acceleration Academy	Regular School	Yes	High	09	12	2020	grade_7	0.0	0
378731	SC	school	4503901	4701	SC Public Charter School	450390101706	4701055	Charleston AccelerationAcademy	Regular School	Yes	High	09	12	2021	grade_7	0.0	0
242450	SC	school	4503901	4701	SC Public Charter School District	450390101692	4701054	Lakes and Bridges Charter School	Regular School	Yes	Elementary	01	06	2020	grade_7	0.0	0
378730	SC	school	4503901	4701	SC Public Charter School	450390101692	4701054	Lakes and Bridges CharterSchool	Regular School	Yes	Elementary	01	07	2021	grade_7	39.0	39
242449	SC	school	4503901	4701	SC Public Charter School District	450390101698	4701053	Polaris Tech	Regular School	Yes	Secondary	06	11	2020	grade_7	57.0	57
378729	SC	school	4503901	4701	SC Public Charter School	450390101698	4701053	Polaris Tech	Regular School	Yes	High	05	12	2021	grade_7	50.0	50
242448	SC	school	4503901	4701	SC Public Charter School District	450390101695	4701051	Bettis Preparatory Leadership Academy	Regular School	Yes	Elementary	KG	06	2020	grade_7	0.0	0
378728	SC	school	4503901	4701	SC Public Charter School	450390101695	4701051	Bettis Preparatory LeadershipAcademy	Regular School	Yes	Elementary	KG	07	2021	grade_7	9.0	9
242447	SC	school	4503901	4701	SC Public Charter School District	450390101696	4701050	East Link Academy	Regular School	Yes	Elementary	PK	05	2020	grade_7	0.0	0
378727	SC	school	4503901	4701	SC Public Charter School	450390101696	4701050	East Link Academy	Regular School	Yes	Elementary	PK	06	2021	grade_7	0.0	0
242446	SC	school	4503901	4701	SC Public Charter School District	450390101689	4701049	Meyers Center for Special Children	Special Education School	Yes	Elementary	PK	02	2020	grade_7	0.0	0
378726	SC	school	4503901	4701	SC Public Charter School	450390101689	4701049	Meyers Center for SpecialChildren	Special Education School	Yes	Elementary	PK	02	2021	grade_7	0.0	0
242445	SC	school	4503901	4701	SC Public Charter School District	450390101685	4701048	Legacy Early College	Regular School	Yes	Other	KG	12	2020	grade_7	127.0	127
378725	SC	school	4503901	4701	SC Public Charter School	450390101685	4701048	Legacy Early College	Regular School	Yes	Other	PK	12	2021	grade_7	138.0	138