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
382427	SC	school	4500001	5209	Department of Corrections	450000100255	5209003	Tyger River High	Alternative School	No	High	09	12	2021	grade_10	1.0	1
382428	SC	school	4500001	5209	Department of Corrections	450000101731	5209005	Kirkland High	Alternative School	No	High	09	12	2021	grade_10	13.0	13
382429	SC	school	4500001	5209	Department of Corrections	450000101376	5209006	MacDougall High	Alternative School	No	High	09	12	2021	grade_10	3.0	3
382430	SC	school	4500001	5209	Department of Corrections	450000101423	5209009	Wateree River High	Alternative School	No	High	09	12	2021	grade_10	1.0	1
382431	SC	school	4500001	5209	Department of Corrections	450000101378	5209011	Sara Babb High	Alternative School	No	High	09	12	2021	grade_10	1.0	1
382432	SC	school	4500001	5209	Department of Corrections	450000101730	5209017	Allendale	Alternative School	No	High	09	12	2021	grade_10	4.0	4
382433	SC	school	4500001	5209	Department of Corrections	450000101721	5209018	Broad River	Alternative School	No	High	09	12	2021	grade_10	0.0	0
382434	SC	school	4500001	5209	Department of Corrections	450000100063	5209021	Lee High	Alternative School	No	High	09	12	2021	grade_10	2.0	2
382435	SC	school	4500001	5209	Department of Corrections	450000100148	5209022	Trenton High	Alternative School	No	High	09	12	2021	grade_10	3.0	3
382436	SC	school	4500001	5209	Department of Corrections	450000100266	5209023	Ridgeland High	Alternative School	No	High	09	12	2021	grade_10	3.0	3
382437	SC	school	4500001	5209	Department of Corrections	450000100238	5209024	Turbeville High	Alternative School	No	High	09	12	2021	grade_10	18.0	18
381616	SC	school	4500002	1804	Dorchester 04	450000200435	1804016	Harleyville Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381617	SC	school	4500002	1804	Dorchester 04	450000200439	1804017	St. George Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381618	SC	school	4500002	1804	Dorchester 04	450000200444	1804018	Williams Memorial Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381619	SC	school	4500002	1804	Dorchester 04	450000200445	1804019	Woodland High	Regular School	No	High	09	12	2021	grade_10	138.0	138
381620	SC	school	4500002	1804	Dorchester 04	450000201600	1804021	Clay Hill Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381621	SC	school	4500002	1804	Dorchester 04	450000201597	1804022	Harleyville-Ridgeville Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
382419	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_10	5.0	5
382420	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_10	7.0	7
382421	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_10	0.0	0
382422	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_10	0.0	0
382423	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_10	3.0	3
381220	SC	school	4500690	160	Abbeville 60	450069000011	160001	Abbeville High	Regular School	No	High	09	12	2021	grade_10	116.0	116
381221	SC	school	4500690	160	Abbeville 60	450069000012	160003	Dixie High	Regular School	No	High	08	12	2021	grade_10	99.0	99
381222	SC	school	4500690	160	Abbeville 60	450069000002	160007	John C Calhoun Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381223	SC	school	4500690	160	Abbeville 60	450069000010	160016	Wright Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381224	SC	school	4500690	160	Abbeville 60	450069001379	160017	Westwood Elem	Regular School	No	Elementary	03	05	2021	grade_10	0.0	0
381225	SC	school	4500690	160	Abbeville 60	450069000065	160018	Cherokee Trail Elem	Regular School	No	Elementary	PK	07	2021	grade_10	0.0	0
381226	SC	school	4500690	160	Abbeville 60	450069000066	160019	Diamond Hill Elem	Regular School	No	Elementary	PK	07	2021	grade_10	0.0	0
381227	SC	school	4500690	160	Abbeville 60	450069000071	160020	Long Cane Primary	Regular School	No	Elementary	PK	02	2021	grade_10	0.0	0
381228	SC	school	4500720	201	Aiken 01	450072001323	201001	Silver Bluff High	Regular School	No	High	09	12	2021	grade_10	164.0	164
381229	SC	school	4500720	201	Aiken 01	450072000046	201002	Aiken High	Regular School	No	High	09	12	2021	grade_10	324.0	324
381230	SC	school	4500720	201	Aiken 01	450072001202	201003	South Aiken High	Regular School	No	High	09	12	2021	grade_10	388.0	388
381231	SC	school	4500720	201	Aiken 01	450072001193	201005	Jefferson Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381232	SC	school	4500720	201	Aiken 01	450072001198	201006	Midland Valley High	Regular School	No	High	09	12	2021	grade_10	359.0	359
381233	SC	school	4500720	201	Aiken 01	450072000050	201007	Paul Knox Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381234	SC	school	4500720	201	Aiken 01	450072001194	201008	Lang Bath Clrwtr Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381235	SC	school	4500720	201	Aiken 01	450072001196	201009	Leavelle Mccampbell Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381236	SC	school	4500720	201	Aiken 01	450072001199	201010	New Ellenton Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381237	SC	school	4500720	201	Aiken 01	450072000054	201011	North Augusta Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381238	SC	school	4500720	201	Aiken 01	450072000055	201012	North Augusta High	Regular School	No	High	09	12	2021	grade_10	421.0	421
381239	SC	school	4500720	201	Aiken 01	450072000057	201015	Wagener-Salley High	Regular School	No	High	09	12	2021	grade_10	85.0	85
381240	SC	school	4500720	201	Aiken 01	450072001189	201016	Aiken Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381241	SC	school	4500720	201	Aiken 01	450072001197	201017	M B Kennedy Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381242	SC	school	4500720	201	Aiken 01	450072000016	201019	Belvedere Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381243	SC	school	4500720	201	Aiken 01	450072000018	201021	Byrd Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381244	SC	school	4500720	201	Aiken 01	450072000019	201022	J D Lever Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381245	SC	school	4500720	201	Aiken 01	450072000020	201024	Clearwater Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381246	SC	school	4500720	201	Aiken 01	450072000023	201027	East Aiken School of the Arts	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381247	SC	school	4500720	201	Aiken 01	450072001201	201028	Schofield Middle	Regular School	No	Middle	07	08	2021	grade_10	0.0	0
381248	SC	school	4500720	201	Aiken 01	450072000025	201029	Gloverville Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381249	SC	school	4500720	201	Aiken 01	450072000026	201030	Greendale Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381250	SC	school	4500720	201	Aiken 01	450072000027	201031	Hammond Hill Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381251	SC	school	4500720	201	Aiken 01	450072001321	201033	Jackson STEM Magnet Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381252	SC	school	4500720	201	Aiken 01	450072000030	201035	Millbrook Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381253	SC	school	4500720	201	Aiken 01	450072000031	201038	North Aiken Elem/PinecrestAnnex	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381254	SC	school	4500720	201	Aiken 01	450072000032	201039	North Augusta Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381255	SC	school	4500720	201	Aiken 01	450072001191	201051	Cyril B. Busbee Elementary	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381256	SC	school	4500720	201	Aiken 01	450072000040	201052	Warrenville Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381257	SC	school	4500720	201	Aiken 01	450072001200	201054	Oakwood-Windsor Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381258	SC	school	4500720	201	Aiken 01	450072001390	201055	Redcliffe Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381259	SC	school	4500720	201	Aiken 01	450072000045	201056	Chukker Creek Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381260	SC	school	4500720	201	Aiken 01	450072001007	201058	Mossy Creek Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381261	SC	school	4500720	201	Aiken 01	450072000034	201059	Ridge Spring-MonettaElementary	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381262	SC	school	4500720	201	Aiken 01	450072000056	201060	Ridge Spring Monetta High	Regular School	No	High	09	12	2021	grade_10	68.0	68
381263	SC	school	4500720	201	Aiken 01	450072001708	201061	Aiken Scholars Academy	Regular School	No	High	09	12	2021	grade_10	46.0	46
381264	SC	school	4500720	201	Aiken 01	450072001713	201062	Ridge Spring Monetta Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381265	SC	school	4500720	201	Aiken 01	450072001702	201063	A. L. Corbett Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381266	SC	school	4500720	201	Aiken 01	450072001729	201066	Graniteville Elementary	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381267	SC	school	4500720	201	Aiken 01	450072001727	201067	Aiken Intermediate	Regular School	No	Middle	06	06	2021	grade_10	0.0	0
381268	SC	school	4500720	201	Aiken 01	450072000682	201601	Lloyd/Kennedy Charter	Regular School	Yes	Middle	03	08	2021	grade_10	0.0	0
381269	SC	school	4500750	301	Allendale 01	450075000064	301001	Allendale Fairfax High	Regular School	No	High	09	12	2021	grade_10	60.0	60
381270	SC	school	4500750	301	Allendale 01	450075001184	301004	Allendale Elem	Regular School	No	Elementary	03	05	2021	grade_10	0.0	0
381271	SC	school	4500750	301	Allendale 01	450075001661	301006	Fairfax Elem	Regular School	No	Elementary	PK	02	2021	grade_10	0.0	0
381272	SC	school	4500750	301	Allendale 01	450075001415	301008	Allendale-Fairfax Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381273	SC	school	4500780	401	Anderson 01	450078000076	401001	Palmetto High	Regular School	No	High	09	12	2021	grade_10	232.0	232
381274	SC	school	4500780	401	Anderson 01	450078001567	401002	Powdersville High	Regular School	No	High	09	12	2021	grade_10	238.0	238
381275	SC	school	4500780	401	Anderson 01	450078000077	401003	Wren High	Regular School	No	High	09	12	2021	grade_10	309.0	309
381276	SC	school	4500780	401	Anderson 01	450078001324	401004	Palmetto Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381277	SC	school	4500780	401	Anderson 01	450078000067	401005	Cedar Grove Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381278	SC	school	4500780	401	Anderson 01	450078000068	401006	Concrete Primary	Regular School	No	Elementary	PK	02	2021	grade_10	0.0	0
381279	SC	school	4500780	401	Anderson 01	450078001203	401008	Wren Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381280	SC	school	4500780	401	Anderson 01	450078000070	401009	West Pelzer Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381281	SC	school	4500780	401	Anderson 01	450078000072	401011	Spearman Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381282	SC	school	4500780	401	Anderson 01	450078000074	401012	Palmetto Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381283	SC	school	4500780	401	Anderson 01	450078001325	401013	Wren Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381284	SC	school	4500780	401	Anderson 01	450078000545	401014	Hunt Meadows Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381285	SC	school	4500780	401	Anderson 01	450078001444	401061	Powdersville Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381286	SC	school	4500780	401	Anderson 01	450078000686	401062	Powdersville Elem	Regular School	No	Elementary	03	05	2021	grade_10	0.0	0
381287	SC	school	4500810	402	Anderson 02	450081000084	402012	Belton Honea Path High	Regular School	No	High	09	12	2021	grade_10	267.0	267
381288	SC	school	4500810	402	Anderson 02	450081000078	402013	Belton Elem	Regular School	No	Elementary	03	05	2021	grade_10	0.0	0
381289	SC	school	4500810	402	Anderson 02	450081001204	402014	Belton Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381290	SC	school	4500810	402	Anderson 02	450081000079	402015	Marshall Primary	Regular School	No	Elementary	PK	02	2021	grade_10	0.0	0
381291	SC	school	4500810	402	Anderson 02	450081000080	402018	Honea Path Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381292	SC	school	4500810	402	Anderson 02	450081001205	402019	Honea Path Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381293	SC	school	4500810	402	Anderson 02	450081000081	402021	Wright Elem	Regular School	No	Elementary	KG	05	2021	grade_10	0.0	0
381294	SC	school	4500840	403	Anderson 03	450084000089	403022	Crescent High	Regular School	No	High	09	12	2021	grade_10	202.0	202
381295	SC	school	4500840	403	Anderson 03	450084000086	403024	Iva Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381296	SC	school	4500840	403	Anderson 03	450084000088	403025	Starr Iva Middle	Regular School	No	Middle	06	08	2021	grade_10	0.0	0
381297	SC	school	4500840	403	Anderson 03	450084000087	403026	Starr Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
381298	SC	school	4500840	403	Anderson 03	450084001506	403027	Flat Rock Elem.	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0