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 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
372256	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	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
371460	SC	school	4500690	160	Abbeville 60	450069000011	160001	Abbeville High	Regular School	No	High	09	12	2021	grade_2	0.0	0
371461	SC	school	4500690	160	Abbeville 60	450069000012	160003	Dixie High	Regular School	No	High	08	12	2021	grade_2	0.0	0
371462	SC	school	4500690	160	Abbeville 60	450069000002	160007	John C Calhoun Elem	Regular School	No	Elementary	PK	05	2021	grade_2	22.0	22
371463	SC	school	4500690	160	Abbeville 60	450069000010	160016	Wright Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371464	SC	school	4500690	160	Abbeville 60	450069001379	160017	Westwood Elem	Regular School	No	Elementary	03	05	2021	grade_2	0.0	0
371465	SC	school	4500690	160	Abbeville 60	450069000065	160018	Cherokee Trail Elem	Regular School	No	Elementary	PK	07	2021	grade_2	55.0	55
371466	SC	school	4500690	160	Abbeville 60	450069000066	160019	Diamond Hill Elem	Regular School	No	Elementary	PK	07	2021	grade_2	31.0	31
371467	SC	school	4500690	160	Abbeville 60	450069000071	160020	Long Cane Primary	Regular School	No	Elementary	PK	02	2021	grade_2	114.0	114
371468	SC	school	4500720	201	Aiken 01	450072001323	201001	Silver Bluff High	Regular School	No	High	09	12	2021	grade_2	0.0	0
371469	SC	school	4500720	201	Aiken 01	450072000046	201002	Aiken High	Regular School	No	High	09	12	2021	grade_2	0.0	0
371470	SC	school	4500720	201	Aiken 01	450072001202	201003	South Aiken High	Regular School	No	High	09	12	2021	grade_2	0.0	0
371471	SC	school	4500720	201	Aiken 01	450072001193	201005	Jefferson Elem	Regular School	No	Elementary	PK	05	2021	grade_2	69.0	69
371472	SC	school	4500720	201	Aiken 01	450072001198	201006	Midland Valley High	Regular School	No	High	09	12	2021	grade_2	0.0	0
371473	SC	school	4500720	201	Aiken 01	450072000050	201007	Paul Knox Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371474	SC	school	4500720	201	Aiken 01	450072001194	201008	Lang Bath Clrwtr Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371475	SC	school	4500720	201	Aiken 01	450072001196	201009	Leavelle Mccampbell Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371476	SC	school	4500720	201	Aiken 01	450072001199	201010	New Ellenton Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371477	SC	school	4500720	201	Aiken 01	450072000054	201011	North Augusta Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371478	SC	school	4500720	201	Aiken 01	450072000055	201012	North Augusta High	Regular School	No	High	09	12	2021	grade_2	0.0	0
371479	SC	school	4500720	201	Aiken 01	450072000057	201015	Wagener-Salley High	Regular School	No	High	09	12	2021	grade_2	0.0	0
371480	SC	school	4500720	201	Aiken 01	450072001189	201016	Aiken Elem	Regular School	No	Elementary	PK	05	2021	grade_2	90.0	90
371481	SC	school	4500720	201	Aiken 01	450072001197	201017	M B Kennedy Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371482	SC	school	4500720	201	Aiken 01	450072000016	201019	Belvedere Elem	Regular School	No	Elementary	PK	05	2021	grade_2	90.0	90
371483	SC	school	4500720	201	Aiken 01	450072000018	201021	Byrd Elem	Regular School	No	Elementary	PK	05	2021	grade_2	97.0	97
371484	SC	school	4500720	201	Aiken 01	450072000019	201022	J D Lever Elem	Regular School	No	Elementary	PK	05	2021	grade_2	69.0	69
371485	SC	school	4500720	201	Aiken 01	450072000020	201024	Clearwater Elem	Regular School	No	Elementary	PK	05	2021	grade_2	57.0	57
371486	SC	school	4500720	201	Aiken 01	450072000023	201027	East Aiken School of the Arts	Regular School	No	Elementary	PK	05	2021	grade_2	93.0	93
371487	SC	school	4500720	201	Aiken 01	450072001201	201028	Schofield Middle	Regular School	No	Middle	07	08	2021	grade_2	0.0	0
371488	SC	school	4500720	201	Aiken 01	450072000025	201029	Gloverville Elem	Regular School	No	Elementary	PK	05	2021	grade_2	53.0	53
371489	SC	school	4500720	201	Aiken 01	450072000026	201030	Greendale Elem	Regular School	No	Elementary	PK	05	2021	grade_2	55.0	55
371490	SC	school	4500720	201	Aiken 01	450072000027	201031	Hammond Hill Elem	Regular School	No	Elementary	PK	05	2021	grade_2	88.0	88
371491	SC	school	4500720	201	Aiken 01	450072001321	201033	Jackson STEM Magnet Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371492	SC	school	4500720	201	Aiken 01	450072000030	201035	Millbrook Elem	Regular School	No	Elementary	PK	05	2021	grade_2	90.0	90
371493	SC	school	4500720	201	Aiken 01	450072000031	201038	North Aiken Elem/PinecrestAnnex	Regular School	No	Elementary	PK	05	2021	grade_2	71.0	71
371494	SC	school	4500720	201	Aiken 01	450072000032	201039	North Augusta Elem	Regular School	No	Elementary	PK	05	2021	grade_2	108.0	108
371495	SC	school	4500720	201	Aiken 01	450072001191	201051	Cyril B. Busbee Elementary	Regular School	No	Elementary	PK	05	2021	grade_2	73.0	73
371496	SC	school	4500720	201	Aiken 01	450072000040	201052	Warrenville Elem	Regular School	No	Elementary	PK	05	2021	grade_2	55.0	55
371497	SC	school	4500720	201	Aiken 01	450072001200	201054	Oakwood-Windsor Elem	Regular School	No	Elementary	PK	05	2021	grade_2	54.0	54
371498	SC	school	4500720	201	Aiken 01	450072001390	201055	Redcliffe Elem	Regular School	No	Elementary	PK	05	2021	grade_2	100.0	100
371499	SC	school	4500720	201	Aiken 01	450072000045	201056	Chukker Creek Elem	Regular School	No	Elementary	PK	05	2021	grade_2	103.0	103
371500	SC	school	4500720	201	Aiken 01	450072001007	201058	Mossy Creek Elem	Regular School	No	Elementary	PK	05	2021	grade_2	86.0	86
371501	SC	school	4500720	201	Aiken 01	450072000034	201059	Ridge Spring-MonettaElementary	Regular School	No	Elementary	PK	05	2021	grade_2	49.0	49
371502	SC	school	4500720	201	Aiken 01	450072000056	201060	Ridge Spring Monetta High	Regular School	No	High	09	12	2021	grade_2	0.0	0
371503	SC	school	4500720	201	Aiken 01	450072001708	201061	Aiken Scholars Academy	Regular School	No	High	09	12	2021	grade_2	0.0	0
371504	SC	school	4500720	201	Aiken 01	450072001713	201062	Ridge Spring Monetta Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371505	SC	school	4500720	201	Aiken 01	450072001702	201063	A. L. Corbett Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371506	SC	school	4500720	201	Aiken 01	450072001729	201066	Graniteville Elementary	Regular School	No	Elementary	PK	05	2021	grade_2	33.0	33
371507	SC	school	4500720	201	Aiken 01	450072001727	201067	Aiken Intermediate	Regular School	No	Middle	06	06	2021	grade_2	0.0	0
371508	SC	school	4500720	201	Aiken 01	450072000682	201601	Lloyd/Kennedy Charter	Regular School	Yes	Middle	03	08	2021	grade_2	0.0	0
371509	SC	school	4500750	301	Allendale 01	450075000064	301001	Allendale Fairfax High	Regular School	No	High	09	12	2021	grade_2	0.0	0
371510	SC	school	4500750	301	Allendale 01	450075001184	301004	Allendale Elem	Regular School	No	Elementary	03	05	2021	grade_2	0.0	0
371511	SC	school	4500750	301	Allendale 01	450075001661	301006	Fairfax Elem	Regular School	No	Elementary	PK	02	2021	grade_2	65.0	65
371512	SC	school	4500750	301	Allendale 01	450075001415	301008	Allendale-Fairfax Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371513	SC	school	4500780	401	Anderson 01	450078000076	401001	Palmetto High	Regular School	No	High	09	12	2021	grade_2	0.0	0
371514	SC	school	4500780	401	Anderson 01	450078001567	401002	Powdersville High	Regular School	No	High	09	12	2021	grade_2	0.0	0
371515	SC	school	4500780	401	Anderson 01	450078000077	401003	Wren High	Regular School	No	High	09	12	2021	grade_2	0.0	0
371516	SC	school	4500780	401	Anderson 01	450078001324	401004	Palmetto Elem	Regular School	No	Elementary	PK	05	2021	grade_2	71.0	71
371517	SC	school	4500780	401	Anderson 01	450078000067	401005	Cedar Grove Elem	Regular School	No	Elementary	PK	05	2021	grade_2	81.0	81
371518	SC	school	4500780	401	Anderson 01	450078000068	401006	Concrete Primary	Regular School	No	Elementary	PK	02	2021	grade_2	214.0	214
371519	SC	school	4500780	401	Anderson 01	450078001203	401008	Wren Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371520	SC	school	4500780	401	Anderson 01	450078000070	401009	West Pelzer Elem	Regular School	No	Elementary	PK	05	2021	grade_2	78.0	78
371521	SC	school	4500780	401	Anderson 01	450078000072	401011	Spearman Elem	Regular School	No	Elementary	PK	05	2021	grade_2	108.0	108
371522	SC	school	4500780	401	Anderson 01	450078000074	401012	Palmetto Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371523	SC	school	4500780	401	Anderson 01	450078001325	401013	Wren Elem	Regular School	No	Elementary	PK	05	2021	grade_2	74.0	74
371524	SC	school	4500780	401	Anderson 01	450078000545	401014	Hunt Meadows Elem	Regular School	No	Elementary	PK	05	2021	grade_2	66.0	66
371525	SC	school	4500780	401	Anderson 01	450078001444	401061	Powdersville Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371526	SC	school	4500780	401	Anderson 01	450078000686	401062	Powdersville Elem	Regular School	No	Elementary	03	05	2021	grade_2	0.0	0
371527	SC	school	4500810	402	Anderson 02	450081000084	402012	Belton Honea Path High	Regular School	No	High	09	12	2021	grade_2	0.0	0
371528	SC	school	4500810	402	Anderson 02	450081000078	402013	Belton Elem	Regular School	No	Elementary	03	05	2021	grade_2	0.0	0
371529	SC	school	4500810	402	Anderson 02	450081001204	402014	Belton Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371530	SC	school	4500810	402	Anderson 02	450081000079	402015	Marshall Primary	Regular School	No	Elementary	PK	02	2021	grade_2	128.0	128
371531	SC	school	4500810	402	Anderson 02	450081000080	402018	Honea Path Elem	Regular School	No	Elementary	PK	05	2021	grade_2	86.0	86
371532	SC	school	4500810	402	Anderson 02	450081001205	402019	Honea Path Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371533	SC	school	4500810	402	Anderson 02	450081000081	402021	Wright Elem	Regular School	No	Elementary	KG	05	2021	grade_2	37.0	37
371534	SC	school	4500840	403	Anderson 03	450084000089	403022	Crescent High	Regular School	No	High	09	12	2021	grade_2	0.0	0
371535	SC	school	4500840	403	Anderson 03	450084000086	403024	Iva Elem	Regular School	No	Elementary	PK	05	2021	grade_2	66.0	66
371536	SC	school	4500840	403	Anderson 03	450084000088	403025	Starr Iva Middle	Regular School	No	Middle	06	08	2021	grade_2	0.0	0
371537	SC	school	4500840	403	Anderson 03	450084000087	403026	Starr Elem	Regular School	No	Elementary	PK	05	2021	grade_2	68.0	68
371538	SC	school	4500840	403	Anderson 03	450084001506	403027	Flat Rock Elem.	Regular School	No	Elementary	PK	05	2021	grade_2	58.0	58
371539	SC	school	4500870	404	Anderson 04	450087000094	404027	Pendleton High	Regular School	No	High	09	12	2021	grade_2	0.0	0
371540	SC	school	4500870	404	Anderson 04	450087001326	404029	Riverside Middle	Regular School	No	Middle	07	08	2021	grade_2	0.0	0
371541	SC	school	4500870	404	Anderson 04	450087000090	404031	La France Elem	Regular School	No	Elementary	PK	06	2021	grade_2	61.0	61
371542	SC	school	4500870	404	Anderson 04	450087000091	404034	Pendleton Elem	Regular School	No	Elementary	PK	06	2021	grade_2	51.0	51
371543	SC	school	4500870	404	Anderson 04	450087000092	404036	Townville Elem	Regular School	No	Elementary	PK	06	2021	grade_2	33.0	33
371544	SC	school	4500870	404	Anderson 04	450087001492	404037	Mt Lebanon Elem	Regular School	No	Elementary	PK	06	2021	grade_2	73.0	73
371545	SC	school	4500900	405	Anderson 05	450090000108	405038	T L Hanna High	Regular School	No	High	09	12	2021	grade_2	0.0	0