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 "state" = :p0 order by ccd_school_lvl 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	white	black	hispanic	native_american	asian	native_hawaiian_pacific_islander	multiracial	unknown_race	male	female	unknown_gender	low_income	total	white_int	black_int	hispanic_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	unknown_race_int	male_int	female_int	unknown_gender_int	low_income_int	total_int
231572	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	pre_kindergarten													70.0													70
232322	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	pre_kindergarten													4.0													4
232791	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	kindergarten													100.0													100
233541	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	kindergarten													0.0													0
234010	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	grade_1													71.0													71
234760	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	grade_1													0.0													0
235229	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	grade_2													76.0													76
235979	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	grade_2													0.0													0
236448	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	grade_3													0.0													0
237198	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	grade_3													0.0													0
237667	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	grade_4													0.0													0
238417	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	grade_4													0.0													0
238886	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	grade_5													0.0													0
239636	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	grade_5													0.0													0
240105	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	grade_6													0.0													0
240855	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	grade_6													0.0													0
241324	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	grade_7													0.0													0
242074	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	grade_7													0.0													0
242543	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	grade_8													0.0													0
243293	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	grade_8													0.0													0
243762	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	grade_9													0.0													0
244512	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	grade_9													0.0													0
244981	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	grade_10													0.0													0
245731	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	grade_10													0.0													0
246200	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	grade_11													0.0													0
246950	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	grade_11													0.0													0
247419	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	grade_12													0.0													0
248169	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	grade_12													0.0													0
248638	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	pk_12_total	11.0	296.0	3.0	4.0	0.0	3.0	0.0	0.0	154.0	163.0	0.0	292.0	317.0	11	296	3	4	0	3	0	0	154	163	0	292	317
249388	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	pk_12_total	2.0	1.0	0.0	0.0	0.0	0.0	1.0	0.0	2.0	2.0	0.0	1.0	4.0	2	1	0	0	0	0	1	0	2	2	0	1	4
368596	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	pre_kindergarten													2.0													2
369816	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	kindergarten													0.0													0
371036	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	grade_1													0.0													0
372256	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	grade_2													0.0													0
373476	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	grade_3													0.0													0
374696	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	grade_4													0.0													0
375916	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	grade_5													0.0													0
377136	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	grade_6													0.0													0
378356	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	grade_7													0.0													0
379576	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	grade_8													0.0													0
380796	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	grade_9													0.0													0
382016	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	grade_10													0.0													0
383236	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	grade_11													0.0													0
384456	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	grade_12													0.0													0
385676	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	pk_12_total	1.0	1.0	0.0	0.0	0.0	0.0	0.0	0.0	1.0	1.0	0.0	1.0	2.0	1	1	0	0	0	0	0	0	1	1	0	1	2
231522	SC	school	4500690	160	Abbeville 60	450069000002	160007	John C Calhoun Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													13.0													13
231524	SC	school	4500690	160	Abbeville 60	450069001379	160017	Westwood Elem	Regular School	No	Elementary	03	05	2020	pre_kindergarten													0.0													0
231525	SC	school	4500690	160	Abbeville 60	450069000065	160018	Cherokee Trail Elem	Regular School	No	Elementary	PK	07	2020	pre_kindergarten													20.0													20
231526	SC	school	4500690	160	Abbeville 60	450069000066	160019	Diamond Hill Elem	Regular School	No	Elementary	PK	07	2020	pre_kindergarten													18.0													18
231527	SC	school	4500690	160	Abbeville 60	450069000071	160020	Long Cane Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten													50.0													50
231531	SC	school	4500720	201	Aiken 01	450072001193	201005	Jefferson Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													49.0													49
231540	SC	school	4500720	201	Aiken 01	450072001189	201016	Aiken Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													43.0													43
231542	SC	school	4500720	201	Aiken 01	450072000016	201019	Belvedere Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													39.0													39
231543	SC	school	4500720	201	Aiken 01	450072000018	201021	Byrd Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													46.0													46
231544	SC	school	4500720	201	Aiken 01	450072000019	201022	J D Lever Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													40.0													40
231545	SC	school	4500720	201	Aiken 01	450072000020	201024	Clearwater Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													39.0													39
231546	SC	school	4500720	201	Aiken 01	450072000023	201027	East Aiken School of the Arts	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													20.0													20
231548	SC	school	4500720	201	Aiken 01	450072000025	201029	Gloverville Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													27.0													27
231549	SC	school	4500720	201	Aiken 01	450072000026	201030	Greendale Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													40.0													40
231550	SC	school	4500720	201	Aiken 01	450072000027	201031	Hammond Hill Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													30.0													30
231552	SC	school	4500720	201	Aiken 01	450072000030	201035	Millbrook Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													28.0													28
231553	SC	school	4500720	201	Aiken 01	450072000031	201038	North Aiken Elem/Pinecrest Annex	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													42.0													42
231554	SC	school	4500720	201	Aiken 01	450072000032	201039	North Augusta Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													20.0													20
231555	SC	school	4500720	201	Aiken 01	450072001191	201051	Cyril B. Busbee Elementary	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													42.0													42
231556	SC	school	4500720	201	Aiken 01	450072000040	201052	Warrenville Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													20.0													20
231557	SC	school	4500720	201	Aiken 01	450072001200	201054	Oakwood-Windsor Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													40.0													40
231558	SC	school	4500720	201	Aiken 01	450072001390	201055	Redcliffe Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													60.0													60
231559	SC	school	4500720	201	Aiken 01	450072000045	201056	Chukker Creek Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													8.0													8
231560	SC	school	4500720	201	Aiken 01	450072001007	201058	Mossy Creek Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													32.0													32
231561	SC	school	4500720	201	Aiken 01	450072000034	201059	Ridge Spring-Monetta Elementary	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													22.0													22
231566	SC	school	4500720	201	Aiken 01	450072001729	201066	Graniteville Elementary	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													19.0													19
231569	SC	school	4500720	201	Aiken 01	450072000684	201602	Horse Creek Academy	Regular School	Yes	Elementary	PK	08	2020	pre_kindergarten													31.0													31
231571	SC	school	4500750	301	Allendale 01	450075001184	301004	Allendale Elem	Regular School	No	Elementary	03	05	2020	pre_kindergarten													0.0													0
231577	SC	school	4500780	401	Anderson 01	450078001324	401004	Palmetto Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													73.0													73
231578	SC	school	4500780	401	Anderson 01	450078000067	401005	Cedar Grove Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													40.0													40
231579	SC	school	4500780	401	Anderson 01	450078000068	401006	Concrete Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten													80.0													80
231581	SC	school	4500780	401	Anderson 01	450078000070	401009	West Pelzer Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													32.0													32
231582	SC	school	4500780	401	Anderson 01	450078000072	401011	Spearman Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													39.0													39
231584	SC	school	4500780	401	Anderson 01	450078001325	401013	Wren Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													37.0													37
231585	SC	school	4500780	401	Anderson 01	450078000545	401014	Hunt Meadows Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													57.0													57
231587	SC	school	4500780	401	Anderson 01	450078000686	401062	Powdersville Elem	Regular School	No	Elementary	03	05	2020	pre_kindergarten													0.0													0
231589	SC	school	4500810	402	Anderson 02	450081000078	402013	Belton Elem	Regular School	No	Elementary	03	05	2020	pre_kindergarten													0.0													0
231591	SC	school	4500810	402	Anderson 02	450081000079	402015	Marshall Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten													95.0													95
231592	SC	school	4500810	402	Anderson 02	450081000080	402018	Honea Path Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													49.0													49
231594	SC	school	4500810	402	Anderson 02	450081000081	402021	Wright Elem	Regular School	No	Elementary	KG	05	2020	pre_kindergarten													0.0													0
231596	SC	school	4500840	403	Anderson 03	450084000086	403024	Iva Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													32.0													32
231598	SC	school	4500840	403	Anderson 03	450084000087	403026	Starr Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													44.0													44
231599	SC	school	4500840	403	Anderson 03	450084001506	403027	Flat Rock Elem.	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													42.0													42
231602	SC	school	4500870	404	Anderson 04	450087000090	404031	La France Elem	Regular School	No	Elementary	PK	06	2020	pre_kindergarten													20.0													20
231603	SC	school	4500870	404	Anderson 04	450087000091	404034	Pendleton Elem	Regular School	No	Elementary	PK	06	2020	pre_kindergarten													22.0													22
231604	SC	school	4500870	404	Anderson 04	450087000092	404036	Townville Elem	Regular School	No	Elementary	PK	06	2020	pre_kindergarten													18.0													18
231605	SC	school	4500870	404	Anderson 04	450087001492	404037	Mt Lebanon Elem	Regular School	No	Elementary	PK	06	2020	pre_kindergarten													20.0													20
231608	SC	school	4500900	405	Anderson 05	450090000096	405044	Centerville Elementary School	Regular School	No	Elementary	KG	05	2020	pre_kindergarten													0.0													0
231609	SC	school	4500900	405	Anderson 05	450090000097	405045	Concord Elem	Regular School	No	Elementary	KG	05	2020	pre_kindergarten													0.0													0
231610	SC	school	4500900	405	Anderson 05	450090000099	405047	Homeland Park Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten													58.0													58
231612	SC	school	4500900	405	Anderson 05	450090000101	405050	Nevitt Forest Elementary	Regular School	No	Elementary	KG	05	2020	pre_kindergarten													0.0													0
231613	SC	school	4500900	405	Anderson 05	450090001206	405051	New Prospect Elementary	Regular School	No	Elementary	KG	05	2020	pre_kindergarten													0.0													0
231614	SC	school	4500900	405	Anderson 05	450090000103	405055	Varennes Elementary	Regular School	No	Elementary	03	05	2020	pre_kindergarten													0.0													0
231615	SC	school	4500900	405	Anderson 05	450090000106	405059	Whitehall Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													40.0													40
231616	SC	school	4500900	405	Anderson 05	450090000107	405060	Calhoun Academy Of The Arts	Regular School	No	Elementary	KG	05	2020	pre_kindergarten													0.0													0
231617	SC	school	4500900	405	Anderson 05	450090000687	405061	Midway Elementary	Regular School	No	Elementary	KG	05	2020	pre_kindergarten													0.0													0