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 "year" = :p2 order by district_nces_id 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
373887	SC	school	4500001	5209	Department of Corrections	450000100255	5209003	Tyger River High	Alternative School	No	High	09	12	2021	grade_3	0.0	0
373888	SC	school	4500001	5209	Department of Corrections	450000101731	5209005	Kirkland High	Alternative School	No	High	09	12	2021	grade_3	0.0	0
373889	SC	school	4500001	5209	Department of Corrections	450000101376	5209006	MacDougall High	Alternative School	No	High	09	12	2021	grade_3	0.0	0
373890	SC	school	4500001	5209	Department of Corrections	450000101423	5209009	Wateree River High	Alternative School	No	High	09	12	2021	grade_3	0.0	0
373891	SC	school	4500001	5209	Department of Corrections	450000101378	5209011	Sara Babb High	Alternative School	No	High	09	12	2021	grade_3	0.0	0
373892	SC	school	4500001	5209	Department of Corrections	450000101730	5209017	Allendale	Alternative School	No	High	09	12	2021	grade_3	0.0	0
373893	SC	school	4500001	5209	Department of Corrections	450000101721	5209018	Broad River	Alternative School	No	High	09	12	2021	grade_3	0.0	0
373894	SC	school	4500001	5209	Department of Corrections	450000100063	5209021	Lee High	Alternative School	No	High	09	12	2021	grade_3	0.0	0
373895	SC	school	4500001	5209	Department of Corrections	450000100148	5209022	Trenton High	Alternative School	No	High	09	12	2021	grade_3	0.0	0
373896	SC	school	4500001	5209	Department of Corrections	450000100266	5209023	Ridgeland High	Alternative School	No	High	09	12	2021	grade_3	0.0	0
373897	SC	school	4500001	5209	Department of Corrections	450000100238	5209024	Turbeville High	Alternative School	No	High	09	12	2021	grade_3	0.0	0
373076	SC	school	4500002	1804	Dorchester 04	450000200435	1804016	Harleyville Elem	Regular School	No	Elementary	PK	05	2021	grade_3	40.0	40
373077	SC	school	4500002	1804	Dorchester 04	450000200439	1804017	St. George Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
373078	SC	school	4500002	1804	Dorchester 04	450000200444	1804018	Williams Memorial Elem	Regular School	No	Elementary	PK	05	2021	grade_3	91.0	91
373079	SC	school	4500002	1804	Dorchester 04	450000200445	1804019	Woodland High	Regular School	No	High	09	12	2021	grade_3	0.0	0
373080	SC	school	4500002	1804	Dorchester 04	450000201600	1804021	Clay Hill Elem	Regular School	No	Elementary	PK	05	2021	grade_3	21.0	21
373081	SC	school	4500002	1804	Dorchester 04	450000201597	1804022	Harleyville-Ridgeville Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
373879	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_3	0.0	0
373880	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_3	0.0	0
373881	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_3	2.0	2
373882	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_3	1.0	1
373883	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_3	2.0	2
372680	SC	school	4500690	160	Abbeville 60	450069000011	160001	Abbeville High	Regular School	No	High	09	12	2021	grade_3	0.0	0
372681	SC	school	4500690	160	Abbeville 60	450069000012	160003	Dixie High	Regular School	No	High	08	12	2021	grade_3	0.0	0
372682	SC	school	4500690	160	Abbeville 60	450069000002	160007	John C Calhoun Elem	Regular School	No	Elementary	PK	05	2021	grade_3	32.0	32
372683	SC	school	4500690	160	Abbeville 60	450069000010	160016	Wright Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372684	SC	school	4500690	160	Abbeville 60	450069001379	160017	Westwood Elem	Regular School	No	Elementary	03	05	2021	grade_3	103.0	103
372685	SC	school	4500690	160	Abbeville 60	450069000065	160018	Cherokee Trail Elem	Regular School	No	Elementary	PK	07	2021	grade_3	46.0	46
372686	SC	school	4500690	160	Abbeville 60	450069000066	160019	Diamond Hill Elem	Regular School	No	Elementary	PK	07	2021	grade_3	38.0	38
372687	SC	school	4500690	160	Abbeville 60	450069000071	160020	Long Cane Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
372688	SC	school	4500720	201	Aiken 01	450072001323	201001	Silver Bluff High	Regular School	No	High	09	12	2021	grade_3	0.0	0
372689	SC	school	4500720	201	Aiken 01	450072000046	201002	Aiken High	Regular School	No	High	09	12	2021	grade_3	0.0	0
372690	SC	school	4500720	201	Aiken 01	450072001202	201003	South Aiken High	Regular School	No	High	09	12	2021	grade_3	0.0	0
372691	SC	school	4500720	201	Aiken 01	450072001193	201005	Jefferson Elem	Regular School	No	Elementary	PK	05	2021	grade_3	84.0	84
372692	SC	school	4500720	201	Aiken 01	450072001198	201006	Midland Valley High	Regular School	No	High	09	12	2021	grade_3	0.0	0
372693	SC	school	4500720	201	Aiken 01	450072000050	201007	Paul Knox Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372694	SC	school	4500720	201	Aiken 01	450072001194	201008	Lang Bath Clrwtr Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372695	SC	school	4500720	201	Aiken 01	450072001196	201009	Leavelle Mccampbell Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372696	SC	school	4500720	201	Aiken 01	450072001199	201010	New Ellenton Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372697	SC	school	4500720	201	Aiken 01	450072000054	201011	North Augusta Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372698	SC	school	4500720	201	Aiken 01	450072000055	201012	North Augusta High	Regular School	No	High	09	12	2021	grade_3	0.0	0
372699	SC	school	4500720	201	Aiken 01	450072000057	201015	Wagener-Salley High	Regular School	No	High	09	12	2021	grade_3	0.0	0
372700	SC	school	4500720	201	Aiken 01	450072001189	201016	Aiken Elem	Regular School	No	Elementary	PK	05	2021	grade_3	108.0	108
372701	SC	school	4500720	201	Aiken 01	450072001197	201017	M B Kennedy Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372702	SC	school	4500720	201	Aiken 01	450072000016	201019	Belvedere Elem	Regular School	No	Elementary	PK	05	2021	grade_3	102.0	102
372703	SC	school	4500720	201	Aiken 01	450072000018	201021	Byrd Elem	Regular School	No	Elementary	PK	05	2021	grade_3	88.0	88
372704	SC	school	4500720	201	Aiken 01	450072000019	201022	J D Lever Elem	Regular School	No	Elementary	PK	05	2021	grade_3	72.0	72
372705	SC	school	4500720	201	Aiken 01	450072000020	201024	Clearwater Elem	Regular School	No	Elementary	PK	05	2021	grade_3	60.0	60
372706	SC	school	4500720	201	Aiken 01	450072000023	201027	East Aiken School of the Arts	Regular School	No	Elementary	PK	05	2021	grade_3	86.0	86
372707	SC	school	4500720	201	Aiken 01	450072001201	201028	Schofield Middle	Regular School	No	Middle	07	08	2021	grade_3	0.0	0
372708	SC	school	4500720	201	Aiken 01	450072000025	201029	Gloverville Elem	Regular School	No	Elementary	PK	05	2021	grade_3	41.0	41
372709	SC	school	4500720	201	Aiken 01	450072000026	201030	Greendale Elem	Regular School	No	Elementary	PK	05	2021	grade_3	48.0	48
372710	SC	school	4500720	201	Aiken 01	450072000027	201031	Hammond Hill Elem	Regular School	No	Elementary	PK	05	2021	grade_3	103.0	103
372711	SC	school	4500720	201	Aiken 01	450072001321	201033	Jackson STEM Magnet Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372712	SC	school	4500720	201	Aiken 01	450072000030	201035	Millbrook Elem	Regular School	No	Elementary	PK	05	2021	grade_3	107.0	107
372713	SC	school	4500720	201	Aiken 01	450072000031	201038	North Aiken Elem/PinecrestAnnex	Regular School	No	Elementary	PK	05	2021	grade_3	79.0	79
372714	SC	school	4500720	201	Aiken 01	450072000032	201039	North Augusta Elem	Regular School	No	Elementary	PK	05	2021	grade_3	107.0	107
372715	SC	school	4500720	201	Aiken 01	450072001191	201051	Cyril B. Busbee Elementary	Regular School	No	Elementary	PK	05	2021	grade_3	70.0	70
372716	SC	school	4500720	201	Aiken 01	450072000040	201052	Warrenville Elem	Regular School	No	Elementary	PK	05	2021	grade_3	61.0	61
372717	SC	school	4500720	201	Aiken 01	450072001200	201054	Oakwood-Windsor Elem	Regular School	No	Elementary	PK	05	2021	grade_3	79.0	79
372718	SC	school	4500720	201	Aiken 01	450072001390	201055	Redcliffe Elem	Regular School	No	Elementary	PK	05	2021	grade_3	82.0	82
372719	SC	school	4500720	201	Aiken 01	450072000045	201056	Chukker Creek Elem	Regular School	No	Elementary	PK	05	2021	grade_3	115.0	115
372720	SC	school	4500720	201	Aiken 01	450072001007	201058	Mossy Creek Elem	Regular School	No	Elementary	PK	05	2021	grade_3	92.0	92
372721	SC	school	4500720	201	Aiken 01	450072000034	201059	Ridge Spring-MonettaElementary	Regular School	No	Elementary	PK	05	2021	grade_3	44.0	44
372722	SC	school	4500720	201	Aiken 01	450072000056	201060	Ridge Spring Monetta High	Regular School	No	High	09	12	2021	grade_3	0.0	0
372723	SC	school	4500720	201	Aiken 01	450072001708	201061	Aiken Scholars Academy	Regular School	No	High	09	12	2021	grade_3	0.0	0
372724	SC	school	4500720	201	Aiken 01	450072001713	201062	Ridge Spring Monetta Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372725	SC	school	4500720	201	Aiken 01	450072001702	201063	A. L. Corbett Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372726	SC	school	4500720	201	Aiken 01	450072001729	201066	Graniteville Elementary	Regular School	No	Elementary	PK	05	2021	grade_3	44.0	44
372727	SC	school	4500720	201	Aiken 01	450072001727	201067	Aiken Intermediate	Regular School	No	Middle	06	06	2021	grade_3	0.0	0
372728	SC	school	4500720	201	Aiken 01	450072000682	201601	Lloyd/Kennedy Charter	Regular School	Yes	Middle	03	08	2021	grade_3	5.0	5
372729	SC	school	4500750	301	Allendale 01	450075000064	301001	Allendale Fairfax High	Regular School	No	High	09	12	2021	grade_3	0.0	0
372730	SC	school	4500750	301	Allendale 01	450075001184	301004	Allendale Elem	Regular School	No	Elementary	03	05	2021	grade_3	70.0	70
372731	SC	school	4500750	301	Allendale 01	450075001661	301006	Fairfax Elem	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
372732	SC	school	4500750	301	Allendale 01	450075001415	301008	Allendale-Fairfax Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372733	SC	school	4500780	401	Anderson 01	450078000076	401001	Palmetto High	Regular School	No	High	09	12	2021	grade_3	0.0	0
372734	SC	school	4500780	401	Anderson 01	450078001567	401002	Powdersville High	Regular School	No	High	09	12	2021	grade_3	0.0	0
372735	SC	school	4500780	401	Anderson 01	450078000077	401003	Wren High	Regular School	No	High	09	12	2021	grade_3	0.0	0
372736	SC	school	4500780	401	Anderson 01	450078001324	401004	Palmetto Elem	Regular School	No	Elementary	PK	05	2021	grade_3	73.0	73
372737	SC	school	4500780	401	Anderson 01	450078000067	401005	Cedar Grove Elem	Regular School	No	Elementary	PK	05	2021	grade_3	100.0	100
372738	SC	school	4500780	401	Anderson 01	450078000068	401006	Concrete Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
372739	SC	school	4500780	401	Anderson 01	450078001203	401008	Wren Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372740	SC	school	4500780	401	Anderson 01	450078000070	401009	West Pelzer Elem	Regular School	No	Elementary	PK	05	2021	grade_3	51.0	51
372741	SC	school	4500780	401	Anderson 01	450078000072	401011	Spearman Elem	Regular School	No	Elementary	PK	05	2021	grade_3	94.0	94
372742	SC	school	4500780	401	Anderson 01	450078000074	401012	Palmetto Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372743	SC	school	4500780	401	Anderson 01	450078001325	401013	Wren Elem	Regular School	No	Elementary	PK	05	2021	grade_3	89.0	89
372744	SC	school	4500780	401	Anderson 01	450078000545	401014	Hunt Meadows Elem	Regular School	No	Elementary	PK	05	2021	grade_3	74.0	74
372745	SC	school	4500780	401	Anderson 01	450078001444	401061	Powdersville Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372746	SC	school	4500780	401	Anderson 01	450078000686	401062	Powdersville Elem	Regular School	No	Elementary	03	05	2021	grade_3	229.0	229
372747	SC	school	4500810	402	Anderson 02	450081000084	402012	Belton Honea Path High	Regular School	No	High	09	12	2021	grade_3	0.0	0
372748	SC	school	4500810	402	Anderson 02	450081000078	402013	Belton Elem	Regular School	No	Elementary	03	05	2021	grade_3	110.0	110
372749	SC	school	4500810	402	Anderson 02	450081001204	402014	Belton Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372750	SC	school	4500810	402	Anderson 02	450081000079	402015	Marshall Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
372751	SC	school	4500810	402	Anderson 02	450081000080	402018	Honea Path Elem	Regular School	No	Elementary	PK	05	2021	grade_3	80.0	80
372752	SC	school	4500810	402	Anderson 02	450081001205	402019	Honea Path Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372753	SC	school	4500810	402	Anderson 02	450081000081	402021	Wright Elem	Regular School	No	Elementary	KG	05	2021	grade_3	32.0	32
372754	SC	school	4500840	403	Anderson 03	450084000089	403022	Crescent High	Regular School	No	High	09	12	2021	grade_3	0.0	0
372755	SC	school	4500840	403	Anderson 03	450084000086	403024	Iva Elem	Regular School	No	Elementary	PK	05	2021	grade_3	46.0	46
372756	SC	school	4500840	403	Anderson 03	450084000088	403025	Starr Iva Middle	Regular School	No	Middle	06	08	2021	grade_3	0.0	0
372757	SC	school	4500840	403	Anderson 03	450084000087	403026	Starr Elem	Regular School	No	Elementary	PK	05	2021	grade_3	80.0	80
372758	SC	school	4500840	403	Anderson 03	450084001506	403027	Flat Rock Elem.	Regular School	No	Elementary	PK	05	2021	grade_3	50.0	50