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 ccd_school_type 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
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
372256	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	grade_2	0.0	0
236382	SC	school	4503420	5208	Department of Juvenile Justice	450342001187	5208001	Willow Lane	Alternative School	No	High	05	12	2020	grade_2	0.0	0
236383	SC	school	4503420	5208	Department of Juvenile Justice	450342001185	5208002	Birchwood School	Alternative School	No	High	05	12	2020	grade_2	0.0	0
236384	SC	school	4503420	5208	Department of Juvenile Justice	450342001186	5208003	Evaluation & Detention Ctr	Alternative School	No	High	05	12	2020	grade_2	0.0	0
236385	SC	school	4500001	5209	Department of Corrections	450000100255	5209003	Tyger River High	Alternative School	No	High	09	12	2020	grade_2	0.0	0
236386	SC	school	4500001	5209	Department of Corrections	450000101376	5209006	MacDougall High	Alternative School	No	High	09	12	2020	grade_2	0.0	0
236387	SC	school	4500001	5209	Department of Corrections	450000100939	5209007	Manning HS	Alternative School	No	High	09	12	2020	grade_2	0.0	0
236388	SC	school	4500001	5209	Department of Corrections	450000101423	5209009	Wateree River High	Alternative School	No	High	09	12	2020	grade_2	0.0	0
236389	SC	school	4500001	5209	Department of Corrections	450000101378	5209011	Sara Babb High	Alternative School	No	High	09	12	2020	grade_2	0.0	0
236390	SC	school	4500001	5209	Department of Corrections	450000100063	5209021	Lee High	Alternative School	No	High	09	12	2020	grade_2	0.0	0
236391	SC	school	4500001	5209	Department of Corrections	450000100148	5209022	Trenton High	Alternative School	No	High	09	12	2020	grade_2	0.0	0
236392	SC	school	4500001	5209	Department of Corrections	450000100266	5209023	Ridgeland High	Alternative School	No	High	09	12	2020	grade_2	0.0	0
236393	SC	school	4500001	5209	Department of Corrections	450000100238	5209024	Turbeville High	Alternative School	No	High	09	12	2020	grade_2	0.0	0
372664	SC	school	4503420	5208	Department of Juvenile Justice	450342001187	5208001	The Palmetto Empowermentand Enrichment Academy	Alternative School	No	High	05	12	2021	grade_2	0.0	0
372665	SC	school	4503420	5208	Department of Juvenile Justice	450342001185	5208002	Empowerment and EnrichmentAcademy	Alternative School	No	High	05	12	2021	grade_2	0.0	0
372666	SC	school	4503420	5208	Department of Juvenile Justice	450342001186	5208003	Evaluation & Detention Ctr	Alternative School	No	High	05	12	2021	grade_2	0.0	0
372667	SC	school	4500001	5209	Department of Corrections	450000100255	5209003	Tyger River High	Alternative School	No	High	09	12	2021	grade_2	0.0	0
372668	SC	school	4500001	5209	Department of Corrections	450000101731	5209005	Kirkland High	Alternative School	No	High	09	12	2021	grade_2	0.0	0
372669	SC	school	4500001	5209	Department of Corrections	450000101376	5209006	MacDougall High	Alternative School	No	High	09	12	2021	grade_2	0.0	0
372670	SC	school	4500001	5209	Department of Corrections	450000101423	5209009	Wateree River High	Alternative School	No	High	09	12	2021	grade_2	0.0	0
372671	SC	school	4500001	5209	Department of Corrections	450000101378	5209011	Sara Babb High	Alternative School	No	High	09	12	2021	grade_2	0.0	0
372672	SC	school	4500001	5209	Department of Corrections	450000101730	5209017	Allendale	Alternative School	No	High	09	12	2021	grade_2	0.0	0
372673	SC	school	4500001	5209	Department of Corrections	450000101721	5209018	Broad River	Alternative School	No	High	09	12	2021	grade_2	0.0	0
372674	SC	school	4500001	5209	Department of Corrections	450000100063	5209021	Lee High	Alternative School	No	High	09	12	2021	grade_2	0.0	0
372675	SC	school	4500001	5209	Department of Corrections	450000100148	5209022	Trenton High	Alternative School	No	High	09	12	2021	grade_2	0.0	0
372676	SC	school	4500001	5209	Department of Corrections	450000100266	5209023	Ridgeland High	Alternative School	No	High	09	12	2021	grade_2	0.0	0
372677	SC	school	4500001	5209	Department of Corrections	450000100238	5209024	Turbeville High	Alternative School	No	High	09	12	2021	grade_2	0.0	0
235177	SC	school	4500690	160	Abbeville 60	450069000011	160001	Abbeville High	Regular School	No	High	09	12	2020	grade_2	0.0	0
235178	SC	school	4500690	160	Abbeville 60	450069000012	160003	Dixie High	Regular School	No	High	08	12	2020	grade_2	0.0	0
235179	SC	school	4500690	160	Abbeville 60	450069000002	160007	John C Calhoun Elem	Regular School	No	Elementary	PK	05	2020	grade_2	29.0	29
235180	SC	school	4500690	160	Abbeville 60	450069000010	160016	Wright Middle	Regular School	No	Middle	06	08	2020	grade_2	0.0	0
235181	SC	school	4500690	160	Abbeville 60	450069001379	160017	Westwood Elem	Regular School	No	Elementary	03	05	2020	grade_2	0.0	0
235182	SC	school	4500690	160	Abbeville 60	450069000065	160018	Cherokee Trail Elem	Regular School	No	Elementary	PK	07	2020	grade_2	46.0	46
235183	SC	school	4500690	160	Abbeville 60	450069000066	160019	Diamond Hill Elem	Regular School	No	Elementary	PK	07	2020	grade_2	45.0	45
235184	SC	school	4500690	160	Abbeville 60	450069000071	160020	Long Cane Primary	Regular School	No	Elementary	PK	02	2020	grade_2	103.0	103
235185	SC	school	4500720	201	Aiken 01	450072001323	201001	Silver Bluff High	Regular School	No	High	09	12	2020	grade_2	0.0	0
235186	SC	school	4500720	201	Aiken 01	450072000046	201002	Aiken High	Regular School	No	High	09	12	2020	grade_2	0.0	0
235187	SC	school	4500720	201	Aiken 01	450072001202	201003	South Aiken High	Regular School	No	High	09	12	2020	grade_2	0.0	0
235188	SC	school	4500720	201	Aiken 01	450072001193	201005	Jefferson Elem	Regular School	No	Elementary	PK	05	2020	grade_2	90.0	90
235189	SC	school	4500720	201	Aiken 01	450072001198	201006	Midland Valley High	Regular School	No	High	09	12	2020	grade_2	0.0	0
235190	SC	school	4500720	201	Aiken 01	450072000050	201007	Paul Knox Middle	Regular School	No	Middle	06	08	2020	grade_2	0.0	0
235191	SC	school	4500720	201	Aiken 01	450072001194	201008	Lang Bath Clrwtr Middle	Regular School	No	Middle	06	08	2020	grade_2	0.0	0
235192	SC	school	4500720	201	Aiken 01	450072001196	201009	Leavelle Mccampbell Middle	Regular School	No	Middle	06	08	2020	grade_2	0.0	0
235193	SC	school	4500720	201	Aiken 01	450072001199	201010	New Ellenton Middle	Regular School	No	Middle	06	08	2020	grade_2	0.0	0
235194	SC	school	4500720	201	Aiken 01	450072000054	201011	North Augusta Middle	Regular School	No	Middle	06	08	2020	grade_2	0.0	0
235195	SC	school	4500720	201	Aiken 01	450072000055	201012	North Augusta High	Regular School	No	High	09	12	2020	grade_2	0.0	0
235196	SC	school	4500720	201	Aiken 01	450072000057	201015	Wagener-Salley High	Regular School	No	High	09	12	2020	grade_2	0.0	0
235197	SC	school	4500720	201	Aiken 01	450072001189	201016	Aiken Elem	Regular School	No	Elementary	PK	05	2020	grade_2	109.0	109
235198	SC	school	4500720	201	Aiken 01	450072001197	201017	M B Kennedy Middle	Regular School	No	Middle	06	08	2020	grade_2	0.0	0
235199	SC	school	4500720	201	Aiken 01	450072000016	201019	Belvedere Elem	Regular School	No	Elementary	PK	05	2020	grade_2	108.0	108
235200	SC	school	4500720	201	Aiken 01	450072000018	201021	Byrd Elem	Regular School	No	Elementary	PK	05	2020	grade_2	82.0	82
235201	SC	school	4500720	201	Aiken 01	450072000019	201022	J D Lever Elem	Regular School	No	Elementary	PK	05	2020	grade_2	88.0	88
235202	SC	school	4500720	201	Aiken 01	450072000020	201024	Clearwater Elem	Regular School	No	Elementary	PK	05	2020	grade_2	64.0	64
235203	SC	school	4500720	201	Aiken 01	450072000023	201027	East Aiken School of the Arts	Regular School	No	Elementary	PK	05	2020	grade_2	91.0	91
235204	SC	school	4500720	201	Aiken 01	450072001201	201028	Schofield Middle	Regular School	No	Middle	07	08	2020	grade_2	0.0	0
235205	SC	school	4500720	201	Aiken 01	450072000025	201029	Gloverville Elem	Regular School	No	Elementary	PK	05	2020	grade_2	52.0	52
235206	SC	school	4500720	201	Aiken 01	450072000026	201030	Greendale Elem	Regular School	No	Elementary	PK	05	2020	grade_2	53.0	53
235207	SC	school	4500720	201	Aiken 01	450072000027	201031	Hammond Hill Elem	Regular School	No	Elementary	PK	05	2020	grade_2	114.0	114
235208	SC	school	4500720	201	Aiken 01	450072001321	201033	Jackson STEM Magnet Middle	Regular School	No	Middle	06	08	2020	grade_2	0.0	0
235209	SC	school	4500720	201	Aiken 01	450072000030	201035	Millbrook Elem	Regular School	No	Elementary	PK	05	2020	grade_2	100.0	100
235210	SC	school	4500720	201	Aiken 01	450072000031	201038	North Aiken Elem/Pinecrest Annex	Regular School	No	Elementary	PK	05	2020	grade_2	66.0	66
235211	SC	school	4500720	201	Aiken 01	450072000032	201039	North Augusta Elem	Regular School	No	Elementary	PK	05	2020	grade_2	110.0	110
235212	SC	school	4500720	201	Aiken 01	450072001191	201051	Cyril B. Busbee Elementary	Regular School	No	Elementary	PK	05	2020	grade_2	73.0	73
235213	SC	school	4500720	201	Aiken 01	450072000040	201052	Warrenville Elem	Regular School	No	Elementary	PK	05	2020	grade_2	64.0	64
235214	SC	school	4500720	201	Aiken 01	450072001200	201054	Oakwood-Windsor Elem	Regular School	No	Elementary	PK	05	2020	grade_2	82.0	82
235215	SC	school	4500720	201	Aiken 01	450072001390	201055	Redcliffe Elem	Regular School	No	Elementary	PK	05	2020	grade_2	93.0	93
235216	SC	school	4500720	201	Aiken 01	450072000045	201056	Chukker Creek Elem	Regular School	No	Elementary	PK	05	2020	grade_2	120.0	120
235217	SC	school	4500720	201	Aiken 01	450072001007	201058	Mossy Creek Elem	Regular School	No	Elementary	PK	05	2020	grade_2	113.0	113
235218	SC	school	4500720	201	Aiken 01	450072000034	201059	Ridge Spring-Monetta Elementary	Regular School	No	Elementary	PK	05	2020	grade_2	55.0	55
235219	SC	school	4500720	201	Aiken 01	450072000056	201060	Ridge Spring Monetta High	Regular School	No	High	09	12	2020	grade_2	0.0	0
235220	SC	school	4500720	201	Aiken 01	450072001708	201061	Aiken Scholars Academy	Regular School	No	High	09	12	2020	grade_2	0.0	0
235221	SC	school	4500720	201	Aiken 01	450072001713	201062	Ridge Spring Monetta Middle	Regular School	No	Middle	06	08	2020	grade_2	0.0	0
235222	SC	school	4500720	201	Aiken 01	450072001702	201063	A. L. Corbett Middle	Regular School	No	Middle	06	08	2020	grade_2	0.0	0
235223	SC	school	4500720	201	Aiken 01	450072001729	201066	Graniteville Elementary	Regular School	No	Elementary	PK	05	2020	grade_2	44.0	44
235224	SC	school	4500720	201	Aiken 01	450072001727	201067	Aiken Intermediate	Regular School	No	Middle	06	06	2020	grade_2	0.0	0
235225	SC	school	4500720	201	Aiken 01	450072000682	201601	Lloyd/Kennedy Charter	Regular School	Yes	Middle	03	08	2020	grade_2	0.0	0
235226	SC	school	4500720	201	Aiken 01	450072000684	201602	Horse Creek Academy	Regular School	Yes	Elementary	PK	08	2020	grade_2	64.0	64
235227	SC	school	4500750	301	Allendale 01	450075000064	301001	Allendale Fairfax High	Regular School	No	High	09	12	2020	grade_2	0.0	0
235228	SC	school	4500750	301	Allendale 01	450075001184	301004	Allendale Elem	Regular School	No	Elementary	03	05	2020	grade_2	0.0	0
235230	SC	school	4500750	301	Allendale 01	450075001415	301008	Allendale-Fairfax Middle	Regular School	No	Middle	06	08	2020	grade_2	0.0	0
235231	SC	school	4500780	401	Anderson 01	450078000076	401001	Palmetto High	Regular School	No	High	09	12	2020	grade_2	0.0	0
235232	SC	school	4500780	401	Anderson 01	450078001567	401002	Powdersville High	Regular School	No	High	09	12	2020	grade_2	0.0	0
235233	SC	school	4500780	401	Anderson 01	450078000077	401003	Wren High	Regular School	No	High	09	12	2020	grade_2	0.0	0
235234	SC	school	4500780	401	Anderson 01	450078001324	401004	Palmetto Elem	Regular School	No	Elementary	PK	05	2020	grade_2	80.0	80
235235	SC	school	4500780	401	Anderson 01	450078000067	401005	Cedar Grove Elem	Regular School	No	Elementary	PK	05	2020	grade_2	97.0	97
235236	SC	school	4500780	401	Anderson 01	450078000068	401006	Concrete Primary	Regular School	No	Elementary	PK	02	2020	grade_2	228.0	228
235237	SC	school	4500780	401	Anderson 01	450078001203	401008	Wren Middle	Regular School	No	Middle	06	08	2020	grade_2	0.0	0
235238	SC	school	4500780	401	Anderson 01	450078000070	401009	West Pelzer Elem	Regular School	No	Elementary	PK	05	2020	grade_2	60.0	60
235239	SC	school	4500780	401	Anderson 01	450078000072	401011	Spearman Elem	Regular School	No	Elementary	PK	05	2020	grade_2	95.0	95
235240	SC	school	4500780	401	Anderson 01	450078000074	401012	Palmetto Middle	Regular School	No	Middle	06	08	2020	grade_2	0.0	0
235241	SC	school	4500780	401	Anderson 01	450078001325	401013	Wren Elem	Regular School	No	Elementary	PK	05	2020	grade_2	85.0	85
235242	SC	school	4500780	401	Anderson 01	450078000545	401014	Hunt Meadows Elem	Regular School	No	Elementary	PK	05	2020	grade_2	66.0	66
235243	SC	school	4500780	401	Anderson 01	450078001444	401061	Powdersville Middle	Regular School	No	Middle	06	08	2020	grade_2	0.0	0
235244	SC	school	4500780	401	Anderson 01	450078000686	401062	Powdersville Elem	Regular School	No	Elementary	03	05	2020	grade_2	0.0	0
235245	SC	school	4500810	402	Anderson 02	450081000084	402012	Belton Honea Path High	Regular School	No	High	09	12	2020	grade_2	0.0	0
235246	SC	school	4500810	402	Anderson 02	450081000078	402013	Belton Elem	Regular School	No	Elementary	03	05	2020	grade_2	0.0	0
235247	SC	school	4500810	402	Anderson 02	450081001204	402014	Belton Middle	Regular School	No	Middle	06	08	2020	grade_2	0.0	0
235248	SC	school	4500810	402	Anderson 02	450081000079	402015	Marshall Primary	Regular School	No	Elementary	PK	02	2020	grade_2	132.0	132
235249	SC	school	4500810	402	Anderson 02	450081000080	402018	Honea Path Elem	Regular School	No	Elementary	PK	05	2020	grade_2	87.0	87