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 school_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
246142	SC	school	4500001	5209	Department of Corrections	450000100063	5209021	Lee High	Alternative School	No	High	09	12	2020	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
246143	SC	school	4500001	5209	Department of Corrections	450000100148	5209022	Trenton High	Alternative School	No	High	09	12	2020	grade_10	0.0	0
382435	SC	school	4500001	5209	Department of Corrections	450000100148	5209022	Trenton High	Alternative School	No	High	09	12	2021	grade_10	3.0	3
246145	SC	school	4500001	5209	Department of Corrections	450000100238	5209024	Turbeville High	Alternative School	No	High	09	12	2020	grade_10	0.0	0
382437	SC	school	4500001	5209	Department of Corrections	450000100238	5209024	Turbeville High	Alternative School	No	High	09	12	2021	grade_10	18.0	18
246137	SC	school	4500001	5209	Department of Corrections	450000100255	5209003	Tyger River 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
246144	SC	school	4500001	5209	Department of Corrections	450000100266	5209023	Ridgeland High	Alternative School	No	High	09	12	2020	grade_10	0.0	0
382436	SC	school	4500001	5209	Department of Corrections	450000100266	5209023	Ridgeland High	Alternative School	No	High	09	12	2021	grade_10	3.0	3
246139	SC	school	4500001	5209	Department of Corrections	450000100939	5209007	Manning HS	Alternative School	No	High	09	12	2020	grade_10	0.0	0
246138	SC	school	4500001	5209	Department of Corrections	450000101376	5209006	MacDougall High	Alternative School	No	High	09	12	2020	grade_10	0.0	0
382429	SC	school	4500001	5209	Department of Corrections	450000101376	5209006	MacDougall High	Alternative School	No	High	09	12	2021	grade_10	3.0	3
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
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
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
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
382433	SC	school	4500001	5209	Department of Corrections	450000101721	5209018	Broad River	Alternative School	No	High	09	12	2021	grade_10	0.0	0
382432	SC	school	4500001	5209	Department of Corrections	450000101730	5209017	Allendale	Alternative School	No	High	09	12	2021	grade_10	4.0	4
382428	SC	school	4500001	5209	Department of Corrections	450000101731	5209005	Kirkland High	Alternative School	No	High	09	12	2021	grade_10	13.0	13
245332	SC	school	4500002	1804	Dorchester 04	450000200435	1804016	Harleyville Elem	Regular School	No	Elementary	PK	05	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
245333	SC	school	4500002	1804	Dorchester 04	450000200439	1804017	St. George Middle	Regular School	No	Middle	06	08	2020	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
245334	SC	school	4500002	1804	Dorchester 04	450000200444	1804018	Williams Memorial Elem	Regular School	No	Elementary	PK	05	2020	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
245335	SC	school	4500002	1804	Dorchester 04	450000200445	1804019	Woodland High	Regular School	No	High	09	12	2020	grade_10	167.0	167
381619	SC	school	4500002	1804	Dorchester 04	450000200445	1804019	Woodland High	Regular School	No	High	09	12	2021	grade_10	138.0	138
245337	SC	school	4500002	1804	Dorchester 04	450000201597	1804022	Harleyville-Ridgeville Middle	Regular School	No	Middle	06	08	2020	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
245336	SC	school	4500002	1804	Dorchester 04	450000201600	1804021	Clay Hill Elem	Regular School	No	Elementary	PK	05	2020	grade_10	0.0	0
381620	SC	school	4500002	1804	Dorchester 04	450000201600	1804021	Clay Hill Elem	Regular School	No	Elementary	PK	05	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
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
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
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
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
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
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
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
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
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
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
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
244932	SC	school	4500690	160	Abbeville 60	450069000010	160016	Wright Middle	Regular School	No	Middle	06	08	2020	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
244929	SC	school	4500690	160	Abbeville 60	450069000011	160001	Abbeville High	Regular School	No	High	09	12	2020	grade_10	135.0	135
381220	SC	school	4500690	160	Abbeville 60	450069000011	160001	Abbeville High	Regular School	No	High	09	12	2021	grade_10	116.0	116
244930	SC	school	4500690	160	Abbeville 60	450069000012	160003	Dixie High	Regular School	No	High	08	12	2020	grade_10	87.0	87
381221	SC	school	4500690	160	Abbeville 60	450069000012	160003	Dixie High	Regular School	No	High	08	12	2021	grade_10	99.0	99
244934	SC	school	4500690	160	Abbeville 60	450069000065	160018	Cherokee Trail Elem	Regular School	No	Elementary	PK	07	2020	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
244935	SC	school	4500690	160	Abbeville 60	450069000066	160019	Diamond Hill Elem	Regular School	No	Elementary	PK	07	2020	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
244936	SC	school	4500690	160	Abbeville 60	450069000071	160020	Long Cane Primary	Regular School	No	Elementary	PK	02	2020	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
244933	SC	school	4500690	160	Abbeville 60	450069001379	160017	Westwood Elem	Regular School	No	Elementary	03	05	2020	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
244951	SC	school	4500720	201	Aiken 01	450072000016	201019	Belvedere Elem	Regular School	No	Elementary	PK	05	2020	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
244952	SC	school	4500720	201	Aiken 01	450072000018	201021	Byrd Elem	Regular School	No	Elementary	PK	05	2020	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
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
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
244954	SC	school	4500720	201	Aiken 01	450072000020	201024	Clearwater Elem	Regular School	No	Elementary	PK	05	2020	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
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
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
244957	SC	school	4500720	201	Aiken 01	450072000025	201029	Gloverville Elem	Regular School	No	Elementary	PK	05	2020	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
244958	SC	school	4500720	201	Aiken 01	450072000026	201030	Greendale Elem	Regular School	No	Elementary	PK	05	2020	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
244959	SC	school	4500720	201	Aiken 01	450072000027	201031	Hammond Hill Elem	Regular School	No	Elementary	PK	05	2020	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
244961	SC	school	4500720	201	Aiken 01	450072000030	201035	Millbrook Elem	Regular School	No	Elementary	PK	05	2020	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
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
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
244963	SC	school	4500720	201	Aiken 01	450072000032	201039	North Augusta Elem	Regular School	No	Elementary	PK	05	2020	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
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
381261	SC	school	4500720	201	Aiken 01	450072000034	201059	Ridge Spring-MonettaElementary	Regular School	No	Elementary	PK	05	2021	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
381256	SC	school	4500720	201	Aiken 01	450072000040	201052	Warrenville Elem	Regular School	No	Elementary	PK	05	2021	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
381259	SC	school	4500720	201	Aiken 01	450072000045	201056	Chukker Creek Elem	Regular School	No	Elementary	PK	05	2021	grade_10	0.0	0
244938	SC	school	4500720	201	Aiken 01	450072000046	201002	Aiken High	Regular School	No	High	09	12	2020	grade_10	338.0	338
381229	SC	school	4500720	201	Aiken 01	450072000046	201002	Aiken High	Regular School	No	High	09	12	2021	grade_10	324.0	324
244942	SC	school	4500720	201	Aiken 01	450072000050	201007	Paul Knox Middle	Regular School	No	Middle	06	08	2020	grade_10	0.0	0
381233	SC	school	4500720	201	Aiken 01	450072000050	201007	Paul Knox Middle	Regular School	No	Middle	06	08	2021	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
381237	SC	school	4500720	201	Aiken 01	450072000054	201011	North Augusta Middle	Regular School	No	Middle	06	08	2021	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
381238	SC	school	4500720	201	Aiken 01	450072000055	201012	North Augusta High	Regular School	No	High	09	12	2021	grade_10	421.0	421
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
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
244948	SC	school	4500720	201	Aiken 01	450072000057	201015	Wagener-Salley High	Regular School	No	High	09	12	2020	grade_10	64.0	64
381239	SC	school	4500720	201	Aiken 01	450072000057	201015	Wagener-Salley High	Regular School	No	High	09	12	2021	grade_10	85.0	85
244977	SC	school	4500720	201	Aiken 01	450072000682	201601	Lloyd/Kennedy Charter	Regular School	Yes	Middle	03	08	2020	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
244978	SC	school	4500720	201	Aiken 01	450072000684	201602	Horse Creek Academy	Regular School	Yes	Elementary	PK	08	2020	grade_10	0.0	0