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 (school > :p3 or (school = :p3 and rowid > :p2)) order by school, 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
374455	SC	school	4502310	2301	Greenville 01	450231001551	2301119	A J Whittenburg Elem	Regular School	No	Elementary	PK	05	2021	grade_4	72.0	72
238508	SC	school	4503360	4001	Richland 01	450336000952	4001007	A. C. Flora High	Regular School	No	High	09	12	2020	grade_4	0.0	0
374787	SC	school	4503360	4001	Richland 01	450336000952	4001007	A. C. Flora High	Regular School	No	High	09	12	2021	grade_4	0.0	0
237660	SC	school	4500720	201	Aiken 01	450072001702	201063	A. L. Corbett Middle	Regular School	No	Middle	06	08	2020	grade_4	0.0	0
373945	SC	school	4500720	201	Aiken 01	450072001702	201063	A. L. Corbett Middle	Regular School	No	Middle	06	08	2021	grade_4	0.0	0
238291	SC	school	4502580	2901	Lancaster 01	450258001260	2901003	A.R. Rucker Middle	Regular School	No	Middle	06	08	2020	grade_4	0.0	0
374570	SC	school	4502580	2901	Lancaster 01	450258001260	2901003	A.R. Rucker Middle	Regular School	No	Middle	06	08	2021	grade_4	0.0	0
237615	SC	school	4500690	160	Abbeville 60	450069000011	160001	Abbeville High	Regular School	No	High	09	12	2020	grade_4	0.0	0
373900	SC	school	4500690	160	Abbeville 60	450069000011	160001	Abbeville High	Regular School	No	High	09	12	2021	grade_4	0.0	0
238635	SC	school	4503600	4205	Spartanburg 05	450360001503	4205094	Abner Creek Academy	Regular School	No	Elementary	PK	04	2020	grade_4	103.0	103
374913	SC	school	4503600	4205	Spartanburg 05	450360001503	4205094	Abner Creek Academy	Regular School	No	Elementary	PK	04	2021	grade_4	129.0	129
237871	SC	school	4501440	1001	Charleston 01	450144000168	1001099	Academic Magnet High	Regular School	No	High	09	12	2020	grade_4	0.0	0
374153	SC	school	4501440	1001	Charleston 01	450144000168	1001099	Academic Magnet High	Regular School	No	High	09	12	2021	grade_4	0.0	0
237925	SC	school	4501530	1201	Chester 01	450153001020	1201601	Academy for Teaching Charter	Regular School	Yes	Elementary	KG	08	2020	grade_4	42.0	42
374207	SC	school	4501530	1201	Chester 01	450153001020	1201601	Academy for Teaching Charter	Regular School	Yes	Elementary	KG	08	2021	grade_4	38.0	38
238266	SC	school	4502490	2601	Horry 01	450249001585	2601603	Academy of Hope Charter	Regular School	Yes	Elementary	PK	08	2020	grade_4	14.0	14
374545	SC	school	4502490	2601	Horry 01	450249001585	2601603	Academy of Hope Charter	Regular School	Yes	Elementary	PK	08	2021	grade_4	15.0	15
237635	SC	school	4500720	201	Aiken 01	450072001189	201016	Aiken Elem	Regular School	No	Elementary	PK	05	2020	grade_4	117.0	117
373920	SC	school	4500720	201	Aiken 01	450072001189	201016	Aiken Elem	Regular School	No	Elementary	PK	05	2021	grade_4	96.0	96
237624	SC	school	4500720	201	Aiken 01	450072000046	201002	Aiken High	Regular School	No	High	09	12	2020	grade_4	0.0	0
373909	SC	school	4500720	201	Aiken 01	450072000046	201002	Aiken High	Regular School	No	High	09	12	2021	grade_4	0.0	0
237662	SC	school	4500720	201	Aiken 01	450072001727	201067	Aiken Intermediate	Regular School	No	Middle	06	06	2020	grade_4	0.0	0
373947	SC	school	4500720	201	Aiken 01	450072001727	201067	Aiken Intermediate	Regular School	No	Middle	06	06	2021	grade_4	0.0	0
237658	SC	school	4500720	201	Aiken 01	450072001708	201061	Aiken Scholars Academy	Regular School	No	High	09	12	2020	grade_4	0.0	0
373943	SC	school	4500720	201	Aiken 01	450072001708	201061	Aiken Scholars Academy	Regular School	No	High	09	12	2021	grade_4	0.0	0
238361	SC	school	4502730	3202	Lexington 02	450273000741	3202009	Airport High	Regular School	No	High	09	12	2020	grade_4	0.0	0
374640	SC	school	4502730	3202	Lexington 02	450273000741	3202009	Airport High	Regular School	No	High	09	12	2021	grade_4	0.0	0
238514	SC	school	4503360	4001	Richland 01	450336001295	4001019	Alcorn Middle	Regular School	No	Middle	06	08	2020	grade_4	0.0	0
374793	SC	school	4503360	4001	Richland 01	450336001295	4001019	Alcorn Middle	Regular School	No	Middle	06	08	2021	grade_4	0.0	0
238113	SC	school	4502310	2301	Greenville 01	450231000488	2301028	Alexander Elem	Regular School	No	Elementary	PK	05	2020	grade_4	57.0	57
374391	SC	school	4502310	2301	Greenville 01	450231000488	2301028	Alexander Elem	Regular School	No	Elementary	PK	05	2021	grade_4	57.0	57
238674	SC	school	4503902	4301	Sumter 01	450390201057	4301026	Alice Drive Elementary	Regular School	No	Elementary	PK	05	2020	grade_4	131.0	131
374952	SC	school	4503902	4301	Sumter 01	450390201057	4301026	Alice Drive Elementary	Regular School	No	Elementary	PK	05	2021	grade_4	120.0	120
238671	SC	school	4503902	4301	Sumter 01	450390201063	4301021	Alice Drive Middle	Regular School	No	Middle	06	08	2020	grade_4	0.0	0
374949	SC	school	4503902	4301	Sumter 01	450390201063	4301021	Alice Drive Middle	Regular School	No	Middle	06	08	2021	grade_4	0.0	0
237897	SC	school	4501440	1001	Charleston 01	450144001655	1001630	Allegro Charter Sch of Music	Regular School	Yes	High	06	12	2020	grade_4	0.0	0
374179	SC	school	4501440	1001	Charleston 01	450144001655	1001630	Allegro Charter Sch of Music	Regular School	Yes	High	06	12	2021	grade_4	0.0	0
375112	SC	school	4500001	5209	Department of Corrections	450000101730	5209017	Allendale	Alternative School	No	High	09	12	2021	grade_4	0.0	0
237666	SC	school	4500750	301	Allendale 01	450075001184	301004	Allendale Elem	Regular School	No	Elementary	03	05	2020	grade_4	77.0	77
373950	SC	school	4500750	301	Allendale 01	450075001184	301004	Allendale Elem	Regular School	No	Elementary	03	05	2021	grade_4	84.0	84
237665	SC	school	4500750	301	Allendale 01	450075000064	301001	Allendale Fairfax High	Regular School	No	High	09	12	2020	grade_4	0.0	0
373949	SC	school	4500750	301	Allendale 01	450075000064	301001	Allendale Fairfax High	Regular School	No	High	09	12	2021	grade_4	0.0	0
237668	SC	school	4500750	301	Allendale 01	450075001415	301008	Allendale-Fairfax Middle	Regular School	No	Middle	06	08	2020	grade_4	0.0	0
373952	SC	school	4500750	301	Allendale 01	450075001415	301008	Allendale-Fairfax Middle	Regular School	No	Middle	06	08	2021	grade_4	0.0	0
237901	SC	school	4501500	1101	Cherokee 01	450150000269	1101005	Alma Elem	Regular School	No	Elementary	PK	05	2020	grade_4	29.0	29
374183	SC	school	4501500	1101	Cherokee 01	450150000269	1101005	Alma Elem	Regular School	No	Elementary	PK	05	2021	grade_4	25.0	25
237998	SC	school	4502010	1802	Dorchester 02	450201000403	1802011	Alston Middle	Regular School	No	Middle	06	08	2020	grade_4	0.0	0
374276	SC	school	4502010	1802	Dorchester 02	450201000403	1802011	Alston Middle	Regular School	No	Middle	06	08	2021	grade_4	0.0	0
238017	SC	school	4502010	1802	Dorchester 02	450201001674	1802031	Alston-Bailey Elementary	Regular School	No	Elementary	PK	05	2020	grade_4	105.0	105
374295	SC	school	4502010	1802	Dorchester 02	450201001674	1802031	Alston-Bailey Elementary	Regular School	No	Elementary	PK	05	2021	grade_4	114.0	114
238504	SC	school	4503330	3901	Pickens 01	450333000881	3901033	Ambler Elementary	Regular School	No	Elementary	PK	05	2020	grade_4	54.0	54
374783	SC	school	4503330	3901	Pickens 01	450333000881	3901033	Ambler Elementary	Regular School	No	Elementary	PK	05	2021	grade_4	51.0	51
237718	SC	school	4500900	405	Anderson 05	450090001602	405601	Anderson Five Charter	Regular School	Yes	High	09	12	2020	grade_4	0.0	0
374002	SC	school	4500900	405	Anderson 05	450090001602	405601	Anderson Five Charter	Regular School	Yes	High	09	12	2021	grade_4	0.0	0
238649	SC	school	4503630	4206	Spartanburg 06	450363000349	4206088	Anderson Mill Elem	Regular School	No	Elementary	PK	05	2020	grade_4	102.0	102
374927	SC	school	4503630	4206	Spartanburg 06	450363000349	4206088	Anderson Mill Elem	Regular School	No	Elementary	PK	05	2021	grade_4	91.0	91
238695	SC	school	4503780	4501	Williamsburg 01	450378001094	4501013	Anderson Primary	Regular School	No	Elementary	PK	02	2020	grade_4	0.0	0
374973	SC	school	4503780	4501	Williamsburg 01	450378001094	4501013	Anderson Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
238293	SC	school	4502580	2901	Lancaster 01	450258000688	2901007	Andrew Jackson High	Regular School	No	High	09	12	2020	grade_4	0.0	0
374572	SC	school	4502580	2901	Lancaster 01	450258000688	2901007	Andrew Jackson High	Regular School	No	High	09	12	2021	grade_4	0.0	0
238305	SC	school	4502580	2901	Lancaster 01	450258000685	2901027	Andrew Jackson Middle	Regular School	No	Middle	06	08	2020	grade_4	0.0	0
374584	SC	school	4502580	2901	Lancaster 01	450258000685	2901027	Andrew Jackson Middle	Regular School	No	Middle	06	08	2021	grade_4	0.0	0
238079	SC	school	4502280	2201	Georgetown 01	450228000469	2201008	Andrews Elem	Regular School	No	Elementary	PK	05	2020	grade_4	117.0	117
374357	SC	school	4502280	2201	Georgetown 01	450228000469	2201008	Andrews Elem	Regular School	No	Elementary	PK	05	2021	grade_4	129.0	129
238077	SC	school	4502280	2201	Georgetown 01	450228000482	2201001	Andrews High	Regular School	No	High	09	12	2020	grade_4	0.0	0
374355	SC	school	4502280	2201	Georgetown 01	450228000482	2201001	Andrews High	Regular School	No	High	09	12	2021	grade_4	0.0	0
237859	SC	school	4501440	1001	Charleston 01	450144000231	1001083	Angel Oak Elem	Regular School	No	Elementary	PK	05	2020	grade_4	78.0	78
374141	SC	school	4501440	1001	Charleston 01	450144000231	1001083	Angel Oak Elem	Regular School	No	Elementary	PK	05	2021	grade_4	73.0	73
238518	SC	school	4503360	4001	Richland 01	450336000913	4001027	Annie Burnside Elem	Regular School	No	Elementary	PK	05	2020	grade_4	52.0	52
374797	SC	school	4503360	4001	Richland 01	450336000913	4001027	Annie Burnside Elem	Regular School	No	Elementary	PK	05	2021	grade_4	47.0	47
238640	SC	school	4503630	4206	Spartanburg 06	450363001024	4206057	Arcadia Elem	Regular School	No	Elementary	PK	05	2020	grade_4	77.0	77
374918	SC	school	4503630	4206	Spartanburg 06	450363001024	4206057	Arcadia Elem	Regular School	No	Elementary	PK	05	2021	grade_4	65.0	65
238515	SC	school	4503360	4001	Richland 01	450336000907	4001020	Arden Elem	Regular School	No	Elementary	PK	05	2020	grade_4	51.0	51
374794	SC	school	4503360	4001	Richland 01	450336000907	4001020	Arden Elem	Regular School	No	Elementary	PK	05	2021	grade_4	36.0	36
238116	SC	school	4502310	2301	Greenville 01	450231000490	2301031	Armstrong Elem	Regular School	No	Elementary	PK	05	2020	grade_4	71.0	71
374394	SC	school	4502310	2301	Greenville 01	450231000490	2301031	Armstrong Elem	Regular School	No	Elementary	PK	05	2021	grade_4	51.0	51
238013	SC	school	4502010	1802	Dorchester 02	450201001508	1802027	Ashley Ridge High	Regular School	No	High	09	12	2020	grade_4	0.0	0
374291	SC	school	4502010	1802	Dorchester 02	450201001508	1802027	Ashley Ridge High	Regular School	No	High	09	12	2021	grade_4	0.0	0
237864	SC	school	4501440	1001	Charleston 01	450144001363	1001091	Ashley River Creative Arts	Regular School	No	Elementary	KG	05	2020	grade_4	101.0	101
374146	SC	school	4501440	1001	Charleston 01	450144001363	1001091	Ashley River Creative Arts	Regular School	No	Elementary	KG	05	2021	grade_4	103.0	103
238117	SC	school	4502310	2301	Greenville 01	450231000492	2301034	Augusta Circle Elem	Regular School	No	Elementary	KG	05	2020	grade_4	93.0	93
374395	SC	school	4502310	2301	Greenville 01	450231000492	2301034	Augusta Circle Elem	Regular School	No	Elementary	KG	05	2021	grade_4	86.0	86
238222	SC	school	4502490	2601	Horry 01	450249000614	2601014	Aynor Elem	Regular School	No	Elementary	PK	05	2020	grade_4	131.0	131
374500	SC	school	4502490	2601	Horry 01	450249000614	2601014	Aynor Elem	Regular School	No	Elementary	PK	05	2021	grade_4	142.0	142
238214	SC	school	4502490	2601	Horry 01	450249000645	2601001	Aynor High	Regular School	No	High	09	12	2020	grade_4	0.0	0
374492	SC	school	4502490	2601	Horry 01	450249000645	2601001	Aynor High	Regular School	No	High	09	12	2021	grade_4	0.0	0
238247	SC	school	4502490	2601	Horry 01	450249000872	2601057	Aynor Middle	Regular School	No	Middle	06	08	2020	grade_4	0.0	0
374525	SC	school	4502490	2601	Horry 01	450249000872	2601057	Aynor Middle	Regular School	No	Middle	06	08	2021	grade_4	0.0	0
238362	SC	school	4502730	3202	Lexington 02	450273000742	3202011	B C Sr High	Regular School	No	High	09	12	2020	grade_4	0.0	0
374641	SC	school	4502730	3202	Lexington 02	450273000742	3202011	B C Sr High	Regular School	No	High	09	12	2021	grade_4	0.0	0
237907	SC	school	4501500	1101	Cherokee 01	450150000278	1101015	B D Lee Elem	Regular School	No	Elementary	PK	05	2020	grade_4	49.0	49
374189	SC	school	4501500	1101	Cherokee 01	450150000278	1101015	B D Lee Elem	Regular School	No	Elementary	PK	05	2021	grade_4	39.0	39
238401	SC	school	4502820	3205	Lexington 05	450282000776	3205055	Ballentine Elem	Regular School	No	Elementary	KG	05	2020	grade_4	116.0	116
374680	SC	school	4502820	3205	Lexington 05	450282000776	3205055	Ballentine Elem	Regular School	No	Elementary	KG	05	2021	grade_4	114.0	114
237721	SC	school	4500930	501	Bamberg 01	450093000119	501001	Bamberg Ehrhardt High	Regular School	No	High	09	12	2020	grade_4	0.0	0
374005	SC	school	4500930	501	Bamberg 01	450093000119	501001	Bamberg Ehrhardt High	Regular School	No	High	09	12	2021	grade_4	0.0	0
237722	SC	school	4500930	501	Bamberg 01	450093000120	501002	Bamberg-Ehrhardt Middle	Regular School	No	Middle	07	08	2020	grade_4	0.0	0
374006	SC	school	4500930	501	Bamberg 01	450093000120	501002	Bamberg-Ehrhardt Middle	Regular School	No	Middle	07	08	2021	grade_4	0.0	0
238758	SC	school	4503900	4604	York 04	450390001564	4604057	Banks Trail Middle	Regular School	No	Middle	06	08	2020	grade_4	0.0	0
375036	SC	school	4503900	4604	York 04	450390001564	4604057	Banks Trail Middle	Regular School	No	Middle	06	08	2021	grade_4	0.0	0
237817	SC	school	4501440	1001	Charleston 01	450144000250	1001001	Baptist Hill High	Regular School	No	High	06	12	2020	grade_4	0.0	0