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 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
246360	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
382650	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
247065	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
383351	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
247057	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
383343	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
246710	SC	school	4502310	2301	Greenville 01	450231001551	2301119	A J Whittenburg Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
382995	SC	school	4502310	2301	Greenville 01	450231001551	2301119	A J Whittenburg Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
247041	SC	school	4503360	4001	Richland 01	450336000952	4001007	A. C. Flora High	Regular School	No	High	09	12	2020	grade_11	314.0	314
383327	SC	school	4503360	4001	Richland 01	450336000952	4001007	A. C. Flora High	Regular School	No	High	09	12	2021	grade_11	349.0	349
246193	SC	school	4500720	201	Aiken 01	450072001702	201063	A. L. Corbett Middle	Regular School	No	Middle	06	08	2020	grade_11	0.0	0
382485	SC	school	4500720	201	Aiken 01	450072001702	201063	A. L. Corbett Middle	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
246824	SC	school	4502580	2901	Lancaster 01	450258001260	2901003	A.R. Rucker Middle	Regular School	No	Middle	06	08	2020	grade_11	0.0	0
383110	SC	school	4502580	2901	Lancaster 01	450258001260	2901003	A.R. Rucker Middle	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
246148	SC	school	4500690	160	Abbeville 60	450069000011	160001	Abbeville High	Regular School	No	High	09	12	2020	grade_11	114.0	114
382440	SC	school	4500690	160	Abbeville 60	450069000011	160001	Abbeville High	Regular School	No	High	09	12	2021	grade_11	113.0	113
247168	SC	school	4503600	4205	Spartanburg 05	450360001503	4205094	Abner Creek Academy	Regular School	No	Elementary	PK	04	2020	grade_11	0.0	0
383453	SC	school	4503600	4205	Spartanburg 05	450360001503	4205094	Abner Creek Academy	Regular School	No	Elementary	PK	04	2021	grade_11	0.0	0
246404	SC	school	4501440	1001	Charleston 01	450144000168	1001099	Academic Magnet High	Regular School	No	High	09	12	2020	grade_11	164.0	164
382693	SC	school	4501440	1001	Charleston 01	450144000168	1001099	Academic Magnet High	Regular School	No	High	09	12	2021	grade_11	168.0	168
246458	SC	school	4501530	1201	Chester 01	450153001020	1201601	Academy for Teaching Charter	Regular School	Yes	Elementary	KG	08	2020	grade_11	0.0	0
382747	SC	school	4501530	1201	Chester 01	450153001020	1201601	Academy for Teaching Charter	Regular School	Yes	Elementary	KG	08	2021	grade_11	0.0	0
246799	SC	school	4502490	2601	Horry 01	450249001585	2601603	Academy of Hope Charter	Regular School	Yes	Elementary	PK	08	2020	grade_11	0.0	0
383085	SC	school	4502490	2601	Horry 01	450249001585	2601603	Academy of Hope Charter	Regular School	Yes	Elementary	PK	08	2021	grade_11	0.0	0
246168	SC	school	4500720	201	Aiken 01	450072001189	201016	Aiken Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
382460	SC	school	4500720	201	Aiken 01	450072001189	201016	Aiken Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
246157	SC	school	4500720	201	Aiken 01	450072000046	201002	Aiken High	Regular School	No	High	09	12	2020	grade_11	261.0	261
382449	SC	school	4500720	201	Aiken 01	450072000046	201002	Aiken High	Regular School	No	High	09	12	2021	grade_11	295.0	295
246195	SC	school	4500720	201	Aiken 01	450072001727	201067	Aiken Intermediate	Regular School	No	Middle	06	06	2020	grade_11	0.0	0
382487	SC	school	4500720	201	Aiken 01	450072001727	201067	Aiken Intermediate	Regular School	No	Middle	06	06	2021	grade_11	0.0	0
246191	SC	school	4500720	201	Aiken 01	450072001708	201061	Aiken Scholars Academy	Regular School	No	High	09	12	2020	grade_11	0.0	0
382483	SC	school	4500720	201	Aiken 01	450072001708	201061	Aiken Scholars Academy	Regular School	No	High	09	12	2021	grade_11	40.0	40
246894	SC	school	4502730	3202	Lexington 02	450273000741	3202009	Airport High	Regular School	No	High	09	12	2020	grade_11	274.0	274
383180	SC	school	4502730	3202	Lexington 02	450273000741	3202009	Airport High	Regular School	No	High	09	12	2021	grade_11	266.0	266
247047	SC	school	4503360	4001	Richland 01	450336001295	4001019	Alcorn Middle	Regular School	No	Middle	06	08	2020	grade_11	0.0	0
383333	SC	school	4503360	4001	Richland 01	450336001295	4001019	Alcorn Middle	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
246646	SC	school	4502310	2301	Greenville 01	450231000488	2301028	Alexander Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
382931	SC	school	4502310	2301	Greenville 01	450231000488	2301028	Alexander Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
247207	SC	school	4503902	4301	Sumter 01	450390201057	4301026	Alice Drive Elementary	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
383492	SC	school	4503902	4301	Sumter 01	450390201057	4301026	Alice Drive Elementary	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
247204	SC	school	4503902	4301	Sumter 01	450390201063	4301021	Alice Drive Middle	Regular School	No	Middle	06	08	2020	grade_11	0.0	0
383489	SC	school	4503902	4301	Sumter 01	450390201063	4301021	Alice Drive Middle	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
246430	SC	school	4501440	1001	Charleston 01	450144001655	1001630	Allegro Charter Sch of Music	Regular School	Yes	High	06	12	2020	grade_11	20.0	20
382719	SC	school	4501440	1001	Charleston 01	450144001655	1001630	Allegro Charter Sch of Music	Regular School	Yes	High	06	12	2021	grade_11	14.0	14
383652	SC	school	4500001	5209	Department of Corrections	450000101730	5209017	Allendale	Alternative School	No	High	09	12	2021	grade_11	0.0	0
246199	SC	school	4500750	301	Allendale 01	450075001184	301004	Allendale Elem	Regular School	No	Elementary	03	05	2020	grade_11	0.0	0
382490	SC	school	4500750	301	Allendale 01	450075001184	301004	Allendale Elem	Regular School	No	Elementary	03	05	2021	grade_11	0.0	0
246198	SC	school	4500750	301	Allendale 01	450075000064	301001	Allendale Fairfax High	Regular School	No	High	09	12	2020	grade_11	80.0	80
382489	SC	school	4500750	301	Allendale 01	450075000064	301001	Allendale Fairfax High	Regular School	No	High	09	12	2021	grade_11	61.0	61
246201	SC	school	4500750	301	Allendale 01	450075001415	301008	Allendale-Fairfax Middle	Regular School	No	Middle	06	08	2020	grade_11	0.0	0
382492	SC	school	4500750	301	Allendale 01	450075001415	301008	Allendale-Fairfax Middle	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
246434	SC	school	4501500	1101	Cherokee 01	450150000269	1101005	Alma Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
382723	SC	school	4501500	1101	Cherokee 01	450150000269	1101005	Alma Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
246531	SC	school	4502010	1802	Dorchester 02	450201000403	1802011	Alston Middle	Regular School	No	Middle	06	08	2020	grade_11	0.0	0
382816	SC	school	4502010	1802	Dorchester 02	450201000403	1802011	Alston Middle	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
246550	SC	school	4502010	1802	Dorchester 02	450201001674	1802031	Alston-Bailey Elementary	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
382835	SC	school	4502010	1802	Dorchester 02	450201001674	1802031	Alston-Bailey Elementary	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
247037	SC	school	4503330	3901	Pickens 01	450333000881	3901033	Ambler Elementary	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
383323	SC	school	4503330	3901	Pickens 01	450333000881	3901033	Ambler Elementary	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
246251	SC	school	4500900	405	Anderson 05	450090001602	405601	Anderson Five Charter	Regular School	Yes	High	09	12	2020	grade_11	11.0	11
382542	SC	school	4500900	405	Anderson 05	450090001602	405601	Anderson Five Charter	Regular School	Yes	High	09	12	2021	grade_11	8.0	8
247182	SC	school	4503630	4206	Spartanburg 06	450363000349	4206088	Anderson Mill Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
383467	SC	school	4503630	4206	Spartanburg 06	450363000349	4206088	Anderson Mill Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
247228	SC	school	4503780	4501	Williamsburg 01	450378001094	4501013	Anderson Primary	Regular School	No	Elementary	PK	02	2020	grade_11	0.0	0
383513	SC	school	4503780	4501	Williamsburg 01	450378001094	4501013	Anderson Primary	Regular School	No	Elementary	PK	02	2021	grade_11	0.0	0
246826	SC	school	4502580	2901	Lancaster 01	450258000688	2901007	Andrew Jackson High	Regular School	No	High	09	12	2020	grade_11	165.0	165
383112	SC	school	4502580	2901	Lancaster 01	450258000688	2901007	Andrew Jackson High	Regular School	No	High	09	12	2021	grade_11	140.0	140
246838	SC	school	4502580	2901	Lancaster 01	450258000685	2901027	Andrew Jackson Middle	Regular School	No	Middle	06	08	2020	grade_11	0.0	0
383124	SC	school	4502580	2901	Lancaster 01	450258000685	2901027	Andrew Jackson Middle	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
246612	SC	school	4502280	2201	Georgetown 01	450228000469	2201008	Andrews Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
382897	SC	school	4502280	2201	Georgetown 01	450228000469	2201008	Andrews Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
246610	SC	school	4502280	2201	Georgetown 01	450228000482	2201001	Andrews High	Regular School	No	High	09	12	2020	grade_11	145.0	145
382895	SC	school	4502280	2201	Georgetown 01	450228000482	2201001	Andrews High	Regular School	No	High	09	12	2021	grade_11	141.0	141
246392	SC	school	4501440	1001	Charleston 01	450144000231	1001083	Angel Oak Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
382681	SC	school	4501440	1001	Charleston 01	450144000231	1001083	Angel Oak Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
247051	SC	school	4503360	4001	Richland 01	450336000913	4001027	Annie Burnside Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
383337	SC	school	4503360	4001	Richland 01	450336000913	4001027	Annie Burnside Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
247173	SC	school	4503630	4206	Spartanburg 06	450363001024	4206057	Arcadia Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
383458	SC	school	4503630	4206	Spartanburg 06	450363001024	4206057	Arcadia Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
247048	SC	school	4503360	4001	Richland 01	450336000907	4001020	Arden Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
383334	SC	school	4503360	4001	Richland 01	450336000907	4001020	Arden Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
246649	SC	school	4502310	2301	Greenville 01	450231000490	2301031	Armstrong Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
382934	SC	school	4502310	2301	Greenville 01	450231000490	2301031	Armstrong Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
246546	SC	school	4502010	1802	Dorchester 02	450201001508	1802027	Ashley Ridge High	Regular School	No	High	09	12	2020	grade_11	488.0	488
382831	SC	school	4502010	1802	Dorchester 02	450201001508	1802027	Ashley Ridge High	Regular School	No	High	09	12	2021	grade_11	484.0	484
246397	SC	school	4501440	1001	Charleston 01	450144001363	1001091	Ashley River Creative Arts	Regular School	No	Elementary	KG	05	2020	grade_11	0.0	0
382686	SC	school	4501440	1001	Charleston 01	450144001363	1001091	Ashley River Creative Arts	Regular School	No	Elementary	KG	05	2021	grade_11	0.0	0
246650	SC	school	4502310	2301	Greenville 01	450231000492	2301034	Augusta Circle Elem	Regular School	No	Elementary	KG	05	2020	grade_11	0.0	0
382935	SC	school	4502310	2301	Greenville 01	450231000492	2301034	Augusta Circle Elem	Regular School	No	Elementary	KG	05	2021	grade_11	0.0	0
246755	SC	school	4502490	2601	Horry 01	450249000614	2601014	Aynor Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
383040	SC	school	4502490	2601	Horry 01	450249000614	2601014	Aynor Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
246747	SC	school	4502490	2601	Horry 01	450249000645	2601001	Aynor High	Regular School	No	High	09	12	2020	grade_11	214.0	214
383032	SC	school	4502490	2601	Horry 01	450249000645	2601001	Aynor High	Regular School	No	High	09	12	2021	grade_11	209.0	209
246780	SC	school	4502490	2601	Horry 01	450249000872	2601057	Aynor Middle	Regular School	No	Middle	06	08	2020	grade_11	0.0	0
383065	SC	school	4502490	2601	Horry 01	450249000872	2601057	Aynor Middle	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
246895	SC	school	4502730	3202	Lexington 02	450273000742	3202011	B C Sr High	Regular School	No	High	09	12	2020	grade_11	205.0	205
383181	SC	school	4502730	3202	Lexington 02	450273000742	3202011	B C Sr High	Regular School	No	High	09	12	2021	grade_11	218.0	218
246440	SC	school	4501500	1101	Cherokee 01	450150000278	1101015	B D Lee Elem	Regular School	No	Elementary	PK	05	2020	grade_11	0.0	0
382729	SC	school	4501500	1101	Cherokee 01	450150000278	1101015	B D Lee Elem	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
246934	SC	school	4502820	3205	Lexington 05	450282000776	3205055	Ballentine Elem	Regular School	No	Elementary	KG	05	2020	grade_11	0.0	0
383220	SC	school	4502820	3205	Lexington 05	450282000776	3205055	Ballentine Elem	Regular School	No	Elementary	KG	05	2021	grade_11	0.0	0