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
238833	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_4	0.0	0
375119	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_4	0.0	0
238832	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_4	0.0	0
375118	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_4	0.0	0
238831	SC	school	4500001	5209	Department of Corrections	450000100238	5209024	Turbeville High	Alternative School	No	High	09	12	2020	grade_4	0.0	0
375117	SC	school	4500001	5209	Department of Corrections	450000100238	5209024	Turbeville High	Alternative School	No	High	09	12	2021	grade_4	0.0	0
238830	SC	school	4500001	5209	Department of Corrections	450000100266	5209023	Ridgeland High	Alternative School	No	High	09	12	2020	grade_4	0.0	0
375116	SC	school	4500001	5209	Department of Corrections	450000100266	5209023	Ridgeland High	Alternative School	No	High	09	12	2021	grade_4	0.0	0
238829	SC	school	4500001	5209	Department of Corrections	450000100148	5209022	Trenton High	Alternative School	No	High	09	12	2020	grade_4	0.0	0
375115	SC	school	4500001	5209	Department of Corrections	450000100148	5209022	Trenton High	Alternative School	No	High	09	12	2021	grade_4	0.0	0
238828	SC	school	4500001	5209	Department of Corrections	450000100063	5209021	Lee High	Alternative School	No	High	09	12	2020	grade_4	0.0	0
375114	SC	school	4500001	5209	Department of Corrections	450000100063	5209021	Lee High	Alternative School	No	High	09	12	2021	grade_4	0.0	0
375113	SC	school	4500001	5209	Department of Corrections	450000101721	5209018	Broad River	Alternative School	No	High	09	12	2021	grade_4	0.0	0
375112	SC	school	4500001	5209	Department of Corrections	450000101730	5209017	Allendale	Alternative School	No	High	09	12	2021	grade_4	0.0	0
238827	SC	school	4500001	5209	Department of Corrections	450000101378	5209011	Sara Babb High	Alternative School	No	High	09	12	2020	grade_4	0.0	0
375111	SC	school	4500001	5209	Department of Corrections	450000101378	5209011	Sara Babb High	Alternative School	No	High	09	12	2021	grade_4	0.0	0
238826	SC	school	4500001	5209	Department of Corrections	450000101423	5209009	Wateree River High	Alternative School	No	High	09	12	2020	grade_4	0.0	0
375110	SC	school	4500001	5209	Department of Corrections	450000101423	5209009	Wateree River High	Alternative School	No	High	09	12	2021	grade_4	0.0	0
238825	SC	school	4500001	5209	Department of Corrections	450000100939	5209007	Manning HS	Alternative School	No	High	09	12	2020	grade_4	0.0	0
238824	SC	school	4500001	5209	Department of Corrections	450000101376	5209006	MacDougall High	Alternative School	No	High	09	12	2020	grade_4	0.0	0
375109	SC	school	4500001	5209	Department of Corrections	450000101376	5209006	MacDougall High	Alternative School	No	High	09	12	2021	grade_4	0.0	0
375108	SC	school	4500001	5209	Department of Corrections	450000101731	5209005	Kirkland High	Alternative School	No	High	09	12	2021	grade_4	0.0	0
238823	SC	school	4500001	5209	Department of Corrections	450000100255	5209003	Tyger River High	Alternative School	No	High	09	12	2020	grade_4	0.0	0
375107	SC	school	4500001	5209	Department of Corrections	450000100255	5209003	Tyger River High	Alternative School	No	High	09	12	2021	grade_4	0.0	0
238822	SC	school	4503420	5208	Department of Juvenile Justice	450342001186	5208003	Evaluation & Detention Ctr	Alternative School	No	High	05	12	2020	grade_4	0.0	0
375106	SC	school	4503420	5208	Department of Juvenile Justice	450342001186	5208003	Evaluation & Detention Ctr	Alternative School	No	High	05	12	2021	grade_4	0.0	0
238821	SC	school	4503420	5208	Department of Juvenile Justice	450342001185	5208002	Birchwood School	Alternative School	No	High	05	12	2020	grade_4	0.0	0
375105	SC	school	4503420	5208	Department of Juvenile Justice	450342001185	5208002	Empowerment and EnrichmentAcademy	Alternative School	No	High	05	12	2021	grade_4	0.0	0
238820	SC	school	4503420	5208	Department of Juvenile Justice	450342001187	5208001	Willow Lane	Alternative School	No	High	05	12	2020	grade_4	0.0	0
375104	SC	school	4503420	5208	Department of Juvenile Justice	450342001187	5208001	The Palmetto Empowermentand Enrichment Academy	Alternative School	No	High	05	12	2021	grade_4	0.0	0
238819	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_4	5.0	5
375103	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_4	0.0	0
238818	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_4	1.0	1
375102	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_4	1.0	1
238817	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_4	6.0	6
375101	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_4	9.0	9
238816	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_4	0.0	0
375100	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_4	0.0	0
238815	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_4	0.0	0
375099	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_4	0.0	0
375098	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_4	0.0	0
375097	SC	school	4503909	4801	Charter Institute at Erskine	450390901687	4801022	Brashier Middle CollegeCharter High	Regular School	Yes	High	09	12	2021	grade_4	0.0	0
375096	SC	school	4503909	4801	Charter Institute at Erskine	450390900684	4801021	Horse Creek Academy	Regular School	Yes	Other	PK	09	2021	grade_4	85.0	85
375095	SC	school	4503909	4801	Charter Institute at Erskine	450390901755	4801020	Cherokee Charter School	Regular School	Yes	Elementary	KG	05	2021	grade_4	63.0	63
375094	SC	school	4503909	4801	Charter Institute at Erskine	450390901613	4801019	Lowcountry Leadership Charter School	Regular School	Yes	Other	KG	12	2021	grade_4	43.0	43
375093	SC	school	4503909	4801	Charter Institute at Erskine	450390901520	4801018	SC Connections Academy	Regular School	Yes	Other	KG	12	2021	grade_4	348.0	348
238814	SC	school	4503909	4801	Charter Institute at Erskine	450390901719	4801017	Summit Classical School	Regular School	Yes	Elementary	KG	03	2020	grade_4	0.0	0
375092	SC	school	4503909	4801	Charter Institute at Erskine	450390901719	4801017	Summit Classical School	Regular School	Yes	Elementary	KG	05	2021	grade_4	15.0	15
238813	SC	school	4503909	4801	Charter Institute at Erskine	450390901715	4801016	Legion Collegiate Academy	Regular School	Yes	High	09	12	2020	grade_4	0.0	0
375091	SC	school	4503909	4801	Charter Institute at Erskine	450390901715	4801016	Legion Collegiate Academy	Regular School	Yes	High	09	12	2021	grade_4	0.0	0
238812	SC	school	4503909	4801	Charter Institute at Erskine	450390901716	4801015	Thornwell Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_4	22.0	22
375090	SC	school	4503909	4801	Charter Institute at Erskine	450390901716	4801015	Thornwell Charter School	Regular School	Yes	Elementary	KG	08	2021	grade_4	22.0	22
238811	SC	school	4503909	4801	Charter Institute at Erskine	450390901717	4801014	Clear Dot Charter	Regular School	Yes	Elementary	KG	06	2020	grade_4	28.0	28
375089	SC	school	4503909	4801	Charter Institute at Erskine	450390901717	4801014	Clear Dot Charter	Regular School	Yes	Elementary	KG	07	2021	grade_4	27.0	27
238810	SC	school	4503909	4801	Charter Institute at Erskine	450390901510	4801013	Calhoun Falls Charter School	Regular School	Yes	High	06	12	2020	grade_4	0.0	0
375088	SC	school	4503909	4801	Charter Institute at Erskine	450390901510	4801013	Calhoun Falls Charter School	Regular School	Yes	High	06	12	2021	grade_4	0.0	0
238809	SC	school	4503909	4801	Charter Institute at Erskine	450390901616	4801012	Cyber Academy of South Carolina	Regular School	Yes	Other	KG	12	2020	grade_4	99.0	99
375087	SC	school	4503909	4801	Charter Institute at Erskine	450390901616	4801012	Cyber Academy of SouthCarolina	Regular School	Yes	Other	KG	12	2021	grade_4	337.0	337
238808	SC	school	4503909	4801	Charter Institute at Erskine	450390901513	4801011	South Carolina Virtual Charter	Regular School	Yes	Other	KG	12	2020	grade_4	128.0	128
375086	SC	school	4503909	4801	Charter Institute at Erskine	450390901513	4801011	South Carolina Virtual Charter	Regular School	Yes	Other	KG	12	2021	grade_4	344.0	344
238807	SC	school	4503909	4801	Charter Institute at Erskine	450390901527	4801010	Odyssey Online Learning	Regular School	Yes	High	09	12	2020	grade_4	0.0	0
375085	SC	school	4503909	4801	Charter Institute at Erskine	450390901527	4801010	Odyssey Online Learning	Regular School	Yes	High	09	12	2021	grade_4	0.0	0
238806	SC	school	4503909	4801	Charter Institute at Erskine	450390901642	4801009	Midlands STEM Institute	Regular School	Yes	Other	KG	10	2020	grade_4	20.0	20
375084	SC	school	4503909	4801	Charter Institute at Erskine	450390901642	4801009	Midlands STEM Institute	Regular School	Yes	Other	KG	11	2021	grade_4	17.0	17
238805	SC	school	4503909	4801	Charter Institute at Erskine	450390901615	4801008	Coastal Leadership Academy	Regular School	Yes	High	09	12	2020	grade_4	0.0	0
375083	SC	school	4503909	4801	Charter Institute at Erskine	450390901615	4801008	Coastal Leadership Academy	Regular School	Yes	High	09	12	2021	grade_4	0.0	0
238804	SC	school	4503909	4801	Charter Institute at Erskine	450390901650	4801007	Gray Collegiate Academy	Regular School	Yes	High	09	12	2020	grade_4	0.0	0
375082	SC	school	4503909	4801	Charter Institute at Erskine	450390901650	4801007	Gray Collegiate Academy	Regular School	Yes	High	08	12	2021	grade_4	0.0	0
238803	SC	school	4503909	4801	Charter Institute at Erskine	450390901686	4801006	Mevers School of Excellence	Regular School	Yes	Elementary	KG	08	2020	grade_4	93.0	93
375081	SC	school	4503909	4801	Charter Institute at Erskine	450390901686	4801006	Mevers School of Excellence	Regular School	Yes	Elementary	KG	08	2021	grade_4	102.0	102
238802	SC	school	4503909	4801	Charter Institute at Erskine	450390901663	4801005	Oceanside Collegiate Academy	Regular School	Yes	High	09	12	2020	grade_4	0.0	0
375080	SC	school	4503909	4801	Charter Institute at Erskine	450390901663	4801005	Oceanside Collegiate Academy	Regular School	Yes	High	09	12	2021	grade_4	0.0	0
238801	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_4	54.0	54
375079	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_4	53.0	53
238800	SC	school	4503909	4801	Charter Institute at Erskine	450390901701	4801003	The Montessori School of Camden	Regular School	Yes	Elementary	KG	07	2020	grade_4	9.0	9
375078	SC	school	4503909	4801	Charter Institute at Erskine	450390901701	4801003	The Montessori School ofCamden	Regular School	Yes	Elementary	PK	08	2021	grade_4	6.0	6
238799	SC	school	4503909	4801	Charter Institute at Erskine	450390901700	4801002	Belton Preparatory Academy	Regular School	Yes	Elementary	KG	03	2020	grade_4	0.0	0
375077	SC	school	4503909	4801	Charter Institute at Erskine	450390901700	4801002	Belton Preparatory Academy	Regular School	Yes	Elementary	KG	04	2021	grade_4	20.0	20
238798	SC	school	4503909	4801	Charter Institute at Erskine	450390901699	4801001	Virtus Academy of South Carolina	Regular School	Yes	Elementary	KG	06	2020	grade_4	23.0	23
375076	SC	school	4503909	4801	Charter Institute at Erskine	450390901699	4801001	Virtus Academy of SouthCarolina	Regular School	Yes	Elementary	KG	07	2021	grade_4	46.0	46
375075	SC	school	4503901	4701	SC Public Charter School	450390101737	4701060	Butler Academy	Regular School	Yes	Elementary	KG	04	2021	grade_4	39.0	39
238797	SC	school	4503901	4701	SC Public Charter School District	450390101733	4701058	Renaissance Collegiate Academy	Regular School	Yes	Elementary	KG	02	2020	grade_4	0.0	0
375074	SC	school	4503901	4701	SC Public Charter School	450390101733	4701058	Renaissance CollegiateAcademy	Regular School	Yes	Elementary	KG	03	2021	grade_4	0.0	0
238796	SC	school	4503901	4701	SC Public Charter School District	450390101722	4701057	GREEN Charter School of Spartanburg	Regular School	Yes	Elementary	KG	06	2020	grade_4	27.0	27
375073	SC	school	4503901	4701	SC Public Charter School	450390101722	4701057	GREEN Charter School ofSpartanburg	Regular School	Yes	Elementary	PK	07	2021	grade_4	43.0	43
238795	SC	school	4503901	4701	SC Public Charter School District	450390101703	4701056	Midlands Arts Conservatory	Regular School	Yes	Middle	06	08	2020	grade_4	0.0	0
375072	SC	school	4503901	4701	SC Public Charter School	450390101703	4701056	Midlands Arts Conservatory	Regular School	Yes	Middle	06	09	2021	grade_4	0.0	0
238794	SC	school	4503901	4701	SC Public Charter School District	450390101706	4701055	Charleston Acceleration Academy	Regular School	Yes	High	09	12	2020	grade_4	0.0	0
375071	SC	school	4503901	4701	SC Public Charter School	450390101706	4701055	Charleston AccelerationAcademy	Regular School	Yes	High	09	12	2021	grade_4	0.0	0
238793	SC	school	4503901	4701	SC Public Charter School District	450390101692	4701054	Lakes and Bridges Charter School	Regular School	Yes	Elementary	01	06	2020	grade_4	36.0	36
375070	SC	school	4503901	4701	SC Public Charter School	450390101692	4701054	Lakes and Bridges CharterSchool	Regular School	Yes	Elementary	01	07	2021	grade_4	36.0	36
238792	SC	school	4503901	4701	SC Public Charter School District	450390101698	4701053	Polaris Tech	Regular School	Yes	Secondary	06	11	2020	grade_4	0.0	0
375069	SC	school	4503901	4701	SC Public Charter School	450390101698	4701053	Polaris Tech	Regular School	Yes	High	05	12	2021	grade_4	0.0	0
238791	SC	school	4503901	4701	SC Public Charter School District	450390101695	4701051	Bettis Preparatory Leadership Academy	Regular School	Yes	Elementary	KG	06	2020	grade_4	14.0	14
375068	SC	school	4503901	4701	SC Public Charter School	450390101695	4701051	Bettis Preparatory LeadershipAcademy	Regular School	Yes	Elementary	KG	07	2021	grade_4	11.0	11
238790	SC	school	4503901	4701	SC Public Charter School District	450390101696	4701050	East Link Academy	Regular School	Yes	Elementary	PK	05	2020	grade_4	21.0	21
375067	SC	school	4503901	4701	SC Public Charter School	450390101696	4701050	East Link Academy	Regular School	Yes	Elementary	PK	06	2021	grade_4	18.0	18
238789	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_4	0.0	0
375066	SC	school	4503901	4701	SC Public Charter School	450390101689	4701049	Meyers Center for SpecialChildren	Special Education School	Yes	Elementary	PK	02	2021	grade_4	0.0	0
238788	SC	school	4503901	4701	SC Public Charter School District	450390101685	4701048	Legacy Early College	Regular School	Yes	Other	KG	12	2020	grade_4	127.0	127
375065	SC	school	4503901	4701	SC Public Charter School	450390101685	4701048	Legacy Early College	Regular School	Yes	Other	PK	12	2021	grade_4	119.0	119