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 (district_nces_id > :p3 or (district_nces_id = :p3 and rowid > :p2)) order by district_nces_id, rowid 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
246138	SC	school	4500001	5209	Department of Corrections	450000101376	5209006	MacDougall High	Alternative School	No	High	09	12	2020	grade_10	0.0	0
246139	SC	school	4500001	5209	Department of Corrections	450000100939	5209007	Manning HS	Alternative School	No	High	09	12	2020	grade_10	0.0	0
246140	SC	school	4500001	5209	Department of Corrections	450000101423	5209009	Wateree River High	Alternative School	No	High	09	12	2020	grade_10	0.0	0
246141	SC	school	4500001	5209	Department of Corrections	450000101378	5209011	Sara Babb High	Alternative School	No	High	09	12	2020	grade_10	0.0	0
246142	SC	school	4500001	5209	Department of Corrections	450000100063	5209021	Lee High	Alternative School	No	High	09	12	2020	grade_10	0.0	0
246143	SC	school	4500001	5209	Department of Corrections	450000100148	5209022	Trenton High	Alternative School	No	High	09	12	2020	grade_10	0.0	0
246144	SC	school	4500001	5209	Department of Corrections	450000100266	5209023	Ridgeland High	Alternative School	No	High	09	12	2020	grade_10	0.0	0
246145	SC	school	4500001	5209	Department of Corrections	450000100238	5209024	Turbeville High	Alternative School	No	High	09	12	2020	grade_10	0.0	0
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
245332	SC	school	4500002	1804	Dorchester 04	450000200435	1804016	Harleyville Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
245333	SC	school	4500002	1804	Dorchester 04	450000200439	1804017	St. George Middle	Regular School	No	Middle	06	08	2020	grade_10	0.0	0
245334	SC	school	4500002	1804	Dorchester 04	450000200444	1804018	Williams Memorial Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
245335	SC	school	4500002	1804	Dorchester 04	450000200445	1804019	Woodland High	Regular School	No	High	09	12	2020	grade_10	167.0	167
245336	SC	school	4500002	1804	Dorchester 04	450000201600	1804021	Clay Hill Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
245337	SC	school	4500002	1804	Dorchester 04	450000201597	1804022	Harleyville-Ridgeville Middle	Regular School	No	Middle	06	08	2020	grade_10	0.0	0
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
246129	SC	school	4500004	5207	SC School for the Deaf and the Blind	450000401226	5207005	SC School For Blind High	Special Education School	No	High	09	12	2020	grade_10	7.0	7
246130	SC	school	4500004	5207	SC School for the Deaf and the Blind	450000401227	5207007	SC School For Deaf High	Special Education School	No	High	09	12	2020	grade_10	6.0	6
246131	SC	school	4500004	5207	SC School for the Deaf and the Blind	450000401228	5207009	SC School For Deaf Elem/Middle	Special Education School	No	Elementary	PK	08	2020	grade_10	0.0	0
246132	SC	school	4500004	5207	SC School for the Deaf and the Blind	450000401246	5207010	SC School For Blind Elem/Middle	Special Education School	No	Elementary	PK	08	2020	grade_10	0.0	0
246133	SC	school	4500004	5207	SC School for the Deaf and the Blind	450000401402	5207011	Cedar Springs Academy	Special Education School	No	Other	PK	12	2020	grade_10	1.0	1
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
244929	SC	school	4500690	160	Abbeville 60	450069000011	160001	Abbeville High	Regular School	No	High	09	12	2020	grade_10	135.0	135
244930	SC	school	4500690	160	Abbeville 60	450069000012	160003	Dixie High	Regular School	No	High	08	12	2020	grade_10	87.0	87
244931	SC	school	4500690	160	Abbeville 60	450069000002	160007	John C Calhoun Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244932	SC	school	4500690	160	Abbeville 60	450069000010	160016	Wright Middle	Regular School	No	Middle	06	08	2020	grade_10	0.0	0
244933	SC	school	4500690	160	Abbeville 60	450069001379	160017	Westwood Elem	Regular School	No	Elementary	03	05	2020	grade_10	0.0	0
244934	SC	school	4500690	160	Abbeville 60	450069000065	160018	Cherokee Trail Elem	Regular School	No	Elementary	PK	07	2020	grade_10	0.0	0
244935	SC	school	4500690	160	Abbeville 60	450069000066	160019	Diamond Hill Elem	Regular School	No	Elementary	PK	07	2020	grade_10	0.0	0
244936	SC	school	4500690	160	Abbeville 60	450069000071	160020	Long Cane Primary	Regular School	No	Elementary	PK	02	2020	grade_10	0.0	0
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
244937	SC	school	4500720	201	Aiken 01	450072001323	201001	Silver Bluff High	Regular School	No	High	09	12	2020	grade_10	176.0	176
244938	SC	school	4500720	201	Aiken 01	450072000046	201002	Aiken High	Regular School	No	High	09	12	2020	grade_10	338.0	338
244939	SC	school	4500720	201	Aiken 01	450072001202	201003	South Aiken High	Regular School	No	High	09	12	2020	grade_10	344.0	344
244940	SC	school	4500720	201	Aiken 01	450072001193	201005	Jefferson Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244941	SC	school	4500720	201	Aiken 01	450072001198	201006	Midland Valley High	Regular School	No	High	09	12	2020	grade_10	323.0	323
244942	SC	school	4500720	201	Aiken 01	450072000050	201007	Paul Knox Middle	Regular School	No	Middle	06	08	2020	grade_10	0.0	0
244943	SC	school	4500720	201	Aiken 01	450072001194	201008	Lang Bath Clrwtr Middle	Regular School	No	Middle	06	08	2020	grade_10	0.0	0
244944	SC	school	4500720	201	Aiken 01	450072001196	201009	Leavelle Mccampbell Middle	Regular School	No	Middle	06	08	2020	grade_10	0.0	0
244945	SC	school	4500720	201	Aiken 01	450072001199	201010	New Ellenton Middle	Regular School	No	Middle	06	08	2020	grade_10	0.0	0
244946	SC	school	4500720	201	Aiken 01	450072000054	201011	North Augusta Middle	Regular School	No	Middle	06	08	2020	grade_10	0.0	0
244947	SC	school	4500720	201	Aiken 01	450072000055	201012	North Augusta High	Regular School	No	High	09	12	2020	grade_10	363.0	363
244948	SC	school	4500720	201	Aiken 01	450072000057	201015	Wagener-Salley High	Regular School	No	High	09	12	2020	grade_10	64.0	64
244949	SC	school	4500720	201	Aiken 01	450072001189	201016	Aiken Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244950	SC	school	4500720	201	Aiken 01	450072001197	201017	M B Kennedy Middle	Regular School	No	Middle	06	08	2020	grade_10	0.0	0
244951	SC	school	4500720	201	Aiken 01	450072000016	201019	Belvedere Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244952	SC	school	4500720	201	Aiken 01	450072000018	201021	Byrd Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244953	SC	school	4500720	201	Aiken 01	450072000019	201022	J D Lever Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244954	SC	school	4500720	201	Aiken 01	450072000020	201024	Clearwater Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244955	SC	school	4500720	201	Aiken 01	450072000023	201027	East Aiken School of the Arts	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244956	SC	school	4500720	201	Aiken 01	450072001201	201028	Schofield Middle	Regular School	No	Middle	07	08	2020	grade_10	0.0	0
244957	SC	school	4500720	201	Aiken 01	450072000025	201029	Gloverville Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244958	SC	school	4500720	201	Aiken 01	450072000026	201030	Greendale Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244959	SC	school	4500720	201	Aiken 01	450072000027	201031	Hammond Hill Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244960	SC	school	4500720	201	Aiken 01	450072001321	201033	Jackson STEM Magnet Middle	Regular School	No	Middle	06	08	2020	grade_10	0.0	0
244961	SC	school	4500720	201	Aiken 01	450072000030	201035	Millbrook Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244962	SC	school	4500720	201	Aiken 01	450072000031	201038	North Aiken Elem/Pinecrest Annex	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244963	SC	school	4500720	201	Aiken 01	450072000032	201039	North Augusta Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244964	SC	school	4500720	201	Aiken 01	450072001191	201051	Cyril B. Busbee Elementary	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244965	SC	school	4500720	201	Aiken 01	450072000040	201052	Warrenville Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244966	SC	school	4500720	201	Aiken 01	450072001200	201054	Oakwood-Windsor Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244967	SC	school	4500720	201	Aiken 01	450072001390	201055	Redcliffe Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244968	SC	school	4500720	201	Aiken 01	450072000045	201056	Chukker Creek Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244969	SC	school	4500720	201	Aiken 01	450072001007	201058	Mossy Creek Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244970	SC	school	4500720	201	Aiken 01	450072000034	201059	Ridge Spring-Monetta Elementary	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244971	SC	school	4500720	201	Aiken 01	450072000056	201060	Ridge Spring Monetta High	Regular School	No	High	09	12	2020	grade_10	58.0	58
244972	SC	school	4500720	201	Aiken 01	450072001708	201061	Aiken Scholars Academy	Regular School	No	High	09	12	2020	grade_10	43.0	43
244973	SC	school	4500720	201	Aiken 01	450072001713	201062	Ridge Spring Monetta Middle	Regular School	No	Middle	06	08	2020	grade_10	0.0	0
244974	SC	school	4500720	201	Aiken 01	450072001702	201063	A. L. Corbett Middle	Regular School	No	Middle	06	08	2020	grade_10	0.0	0
244975	SC	school	4500720	201	Aiken 01	450072001729	201066	Graniteville Elementary	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
244976	SC	school	4500720	201	Aiken 01	450072001727	201067	Aiken Intermediate	Regular School	No	Middle	06	06	2020	grade_10	0.0	0
244977	SC	school	4500720	201	Aiken 01	450072000682	201601	Lloyd/Kennedy Charter	Regular School	Yes	Middle	03	08	2020	grade_10	0.0	0
244978	SC	school	4500720	201	Aiken 01	450072000684	201602	Horse Creek Academy	Regular School	Yes	Elementary	PK	08	2020	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