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 "state" = :p0 and "year" = :p1 and (ccd_school_high_grade > :p3 or (ccd_school_high_grade = :p3 and rowid > :p2)) order by ccd_school_high_grade, 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
370567	SC	school	4501740	1401	Clarendon 01	450174001494	1401022	Summerton Early ChildhoodCtr	Regular School	No	Elementary	PK	02	2021	grade_1	36.0	36
370590	SC	school	4501860	1601	Darlington 01	450186000355	1601018	Pate Elem	Regular School	No	Elementary	PK	02	2021	grade_1	111.0	111
370685	SC	school	4502190	2103	Florence 03	450219001641	2103050	Lake City ECC	Regular School	No	Elementary	PK	02	2021	grade_1	97.0	97
370821	SC	school	4502400	2452	Greenwood 52	450240000746	2452028	Ninety-Six Primary	Regular School	No	Elementary	PK	02	2021	grade_1	97.0	97
370880	SC	school	4502490	2601	Horry 01	450249001732	2601073	Myrtle Beach Primary	Regular School	No	Elementary	01	02	2021	grade_1	327.0	327
370995	SC	school	4502760	3203	Lexington 03	450276000745	3203030	Batesburg-Leesville Primary	Regular School	No	Elementary	PK	02	2021	grade_1	168.0	168
371001	SC	school	4502790	3204	Lexington 04	450279000631	3204040	Sandhills Primary	Regular School	No	Elementary	01	02	2021	grade_1	217.0	217
371028	SC	school	4503908	3410	Marion 10	450390800761	3410003	Easterling Primary	Regular School	No	Elementary	PK	02	2021	grade_1	152.0	152
371034	SC	school	4503908	3410	Marion 10	450390800771	3410013	North Mullins Primary	Regular School	No	Elementary	PK	02	2021	grade_1	102.0	102
371081	SC	school	4503910	3809	Orangeburg	450391000860	3809026	Edisto Primary School	Regular School	No	Elementary	PK	02	2021	grade_1	143.0	143
371098	SC	school	4503910	3809	Orangeburg	450391001693	3809056	Rivelon Elmentary School	Regular School	No	Elementary	PK	02	2021	grade_1	68.0	68
371121	SC	school	4503330	3901	Pickens 01	450333001565	3901031	Libery Primary	Regular School	No	Elementary	PK	02	2021	grade_1	154.0	154
371189	SC	school	4503390	4002	Richland 02	450339000650	4002089	Lake Carolina Elem	Regular School	No	Elementary	PK	02	2021	grade_1	129.0	129
371207	SC	school	4503460	4101	Saluda 01	450346000936	4101007	Saluda Primary	Regular School	No	Elementary	PK	02	2021	grade_1	132.0	132
371241	SC	school	4503570	4204	Spartanburg 04	450357001012	4204040	Woodruff Primary	Regular School	No	Elementary	PK	02	2021	grade_1	190.0	190
371313	SC	school	4503780	4501	Williamsburg 01	450378001094	4501013	Anderson Primary	Regular School	No	Elementary	PK	02	2021	grade_1	117.0	117
371406	SC	school	4503901	4701	SC Public Charter School	450390101689	4701049	Meyers Center for SpecialChildren	Special Education School	Yes	Elementary	PK	02	2021	grade_1	11.0	11
371467	SC	school	4500690	160	Abbeville 60	450069000071	160020	Long Cane Primary	Regular School	No	Elementary	PK	02	2021	grade_2	114.0	114
371511	SC	school	4500750	301	Allendale 01	450075001661	301006	Fairfax Elem	Regular School	No	Elementary	PK	02	2021	grade_2	65.0	65
371518	SC	school	4500780	401	Anderson 01	450078000068	401006	Concrete Primary	Regular School	No	Elementary	PK	02	2021	grade_2	214.0	214
371530	SC	school	4500810	402	Anderson 02	450081000079	402015	Marshall Primary	Regular School	No	Elementary	PK	02	2021	grade_2	128.0	128
371549	SC	school	4500900	405	Anderson 05	450090000099	405047	Homeland Park Primary	Regular School	No	Elementary	PK	02	2021	grade_2	134.0	134
371617	SC	school	4501170	801	Berkeley 01	450117000154	801011	Berkeley Elem	Regular School	No	Elementary	PK	02	2021	grade_2	186.0	186
371626	SC	school	4501170	801	Berkeley 01	450117001209	801023	Sangaree Elem	Regular School	No	Elementary	PK	02	2021	grade_2	206.0	206
371644	SC	school	4501170	801	Berkeley 01	450117000704	801045	Westview Primary	Regular School	No	Elementary	PK	02	2021	grade_2	180.0	180
371720	SC	school	4501440	1001	Charleston 01	450144000944	1001110	Laurel Hill Primary	Regular School	No	Elementary	PK	02	2021	grade_2	173.0	173
371756	SC	school	4501500	1101	Cherokee 01	450150000859	1101025	Blacksburg Primary	Regular School	No	Elementary	PK	02	2021	grade_2	98.0	98
371774	SC	school	4501560	1301	Chesterfield 01	450156000303	1301012	Cheraw Primary	Regular School	No	Elementary	PK	02	2021	grade_2	115.0	115
371777	SC	school	4501560	1301	Chesterfield 01	450156000307	1301019	Petersburg Primary	Regular School	No	Elementary	PK	02	2021	grade_2	100.0	100
371787	SC	school	4501740	1401	Clarendon 01	450174001494	1401022	Summerton Early ChildhoodCtr	Regular School	No	Elementary	PK	02	2021	grade_2	45.0	45
371810	SC	school	4501860	1601	Darlington 01	450186000355	1601018	Pate Elem	Regular School	No	Elementary	PK	02	2021	grade_2	114.0	114
371905	SC	school	4502190	2103	Florence 03	450219001641	2103050	Lake City ECC	Regular School	No	Elementary	PK	02	2021	grade_2	107.0	107
372041	SC	school	4502400	2452	Greenwood 52	450240000746	2452028	Ninety-Six Primary	Regular School	No	Elementary	PK	02	2021	grade_2	110.0	110
372100	SC	school	4502490	2601	Horry 01	450249001732	2601073	Myrtle Beach Primary	Regular School	No	Elementary	01	02	2021	grade_2	326.0	326
372215	SC	school	4502760	3203	Lexington 03	450276000745	3203030	Batesburg-Leesville Primary	Regular School	No	Elementary	PK	02	2021	grade_2	114.0	114
372221	SC	school	4502790	3204	Lexington 04	450279000631	3204040	Sandhills Primary	Regular School	No	Elementary	01	02	2021	grade_2	248.0	248
372248	SC	school	4503908	3410	Marion 10	450390800761	3410003	Easterling Primary	Regular School	No	Elementary	PK	02	2021	grade_2	162.0	162
372254	SC	school	4503908	3410	Marion 10	450390800771	3410013	North Mullins Primary	Regular School	No	Elementary	PK	02	2021	grade_2	118.0	118
372301	SC	school	4503910	3809	Orangeburg	450391000860	3809026	Edisto Primary School	Regular School	No	Elementary	PK	02	2021	grade_2	180.0	180
372318	SC	school	4503910	3809	Orangeburg	450391001693	3809056	Rivelon Elmentary School	Regular School	No	Elementary	PK	02	2021	grade_2	65.0	65
372341	SC	school	4503330	3901	Pickens 01	450333001565	3901031	Libery Primary	Regular School	No	Elementary	PK	02	2021	grade_2	149.0	149
372409	SC	school	4503390	4002	Richland 02	450339000650	4002089	Lake Carolina Elem	Regular School	No	Elementary	PK	02	2021	grade_2	143.0	143
372427	SC	school	4503460	4101	Saluda 01	450346000936	4101007	Saluda Primary	Regular School	No	Elementary	PK	02	2021	grade_2	109.0	109
372461	SC	school	4503570	4204	Spartanburg 04	450357001012	4204040	Woodruff Primary	Regular School	No	Elementary	PK	02	2021	grade_2	189.0	189
372533	SC	school	4503780	4501	Williamsburg 01	450378001094	4501013	Anderson Primary	Regular School	No	Elementary	PK	02	2021	grade_2	119.0	119
372626	SC	school	4503901	4701	SC Public Charter School	450390101689	4701049	Meyers Center for SpecialChildren	Special Education School	Yes	Elementary	PK	02	2021	grade_2	11.0	11
372687	SC	school	4500690	160	Abbeville 60	450069000071	160020	Long Cane Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
372731	SC	school	4500750	301	Allendale 01	450075001661	301006	Fairfax Elem	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
372738	SC	school	4500780	401	Anderson 01	450078000068	401006	Concrete Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
372750	SC	school	4500810	402	Anderson 02	450081000079	402015	Marshall Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
372769	SC	school	4500900	405	Anderson 05	450090000099	405047	Homeland Park Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
372837	SC	school	4501170	801	Berkeley 01	450117000154	801011	Berkeley Elem	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
372846	SC	school	4501170	801	Berkeley 01	450117001209	801023	Sangaree Elem	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
372864	SC	school	4501170	801	Berkeley 01	450117000704	801045	Westview Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
372940	SC	school	4501440	1001	Charleston 01	450144000944	1001110	Laurel Hill Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
372976	SC	school	4501500	1101	Cherokee 01	450150000859	1101025	Blacksburg Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
372994	SC	school	4501560	1301	Chesterfield 01	450156000303	1301012	Cheraw Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
372997	SC	school	4501560	1301	Chesterfield 01	450156000307	1301019	Petersburg Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
373007	SC	school	4501740	1401	Clarendon 01	450174001494	1401022	Summerton Early ChildhoodCtr	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
373030	SC	school	4501860	1601	Darlington 01	450186000355	1601018	Pate Elem	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
373125	SC	school	4502190	2103	Florence 03	450219001641	2103050	Lake City ECC	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
373261	SC	school	4502400	2452	Greenwood 52	450240000746	2452028	Ninety-Six Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
373320	SC	school	4502490	2601	Horry 01	450249001732	2601073	Myrtle Beach Primary	Regular School	No	Elementary	01	02	2021	grade_3	0.0	0
373435	SC	school	4502760	3203	Lexington 03	450276000745	3203030	Batesburg-Leesville Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
373441	SC	school	4502790	3204	Lexington 04	450279000631	3204040	Sandhills Primary	Regular School	No	Elementary	01	02	2021	grade_3	6.0	6
373468	SC	school	4503908	3410	Marion 10	450390800761	3410003	Easterling Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
373474	SC	school	4503908	3410	Marion 10	450390800771	3410013	North Mullins Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
373521	SC	school	4503910	3809	Orangeburg	450391000860	3809026	Edisto Primary School	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
373538	SC	school	4503910	3809	Orangeburg	450391001693	3809056	Rivelon Elmentary School	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
373561	SC	school	4503330	3901	Pickens 01	450333001565	3901031	Libery Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
373629	SC	school	4503390	4002	Richland 02	450339000650	4002089	Lake Carolina Elem	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
373647	SC	school	4503460	4101	Saluda 01	450346000936	4101007	Saluda Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
373681	SC	school	4503570	4204	Spartanburg 04	450357001012	4204040	Woodruff Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
373753	SC	school	4503780	4501	Williamsburg 01	450378001094	4501013	Anderson Primary	Regular School	No	Elementary	PK	02	2021	grade_3	0.0	0
373846	SC	school	4503901	4701	SC Public Charter School	450390101689	4701049	Meyers Center for SpecialChildren	Special Education School	Yes	Elementary	PK	02	2021	grade_3	0.0	0
373907	SC	school	4500690	160	Abbeville 60	450069000071	160020	Long Cane Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
373951	SC	school	4500750	301	Allendale 01	450075001661	301006	Fairfax Elem	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
373958	SC	school	4500780	401	Anderson 01	450078000068	401006	Concrete Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
373970	SC	school	4500810	402	Anderson 02	450081000079	402015	Marshall Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
373989	SC	school	4500900	405	Anderson 05	450090000099	405047	Homeland Park Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374057	SC	school	4501170	801	Berkeley 01	450117000154	801011	Berkeley Elem	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374066	SC	school	4501170	801	Berkeley 01	450117001209	801023	Sangaree Elem	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374084	SC	school	4501170	801	Berkeley 01	450117000704	801045	Westview Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374160	SC	school	4501440	1001	Charleston 01	450144000944	1001110	Laurel Hill Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374196	SC	school	4501500	1101	Cherokee 01	450150000859	1101025	Blacksburg Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374214	SC	school	4501560	1301	Chesterfield 01	450156000303	1301012	Cheraw Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374217	SC	school	4501560	1301	Chesterfield 01	450156000307	1301019	Petersburg Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374227	SC	school	4501740	1401	Clarendon 01	450174001494	1401022	Summerton Early ChildhoodCtr	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374250	SC	school	4501860	1601	Darlington 01	450186000355	1601018	Pate Elem	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374345	SC	school	4502190	2103	Florence 03	450219001641	2103050	Lake City ECC	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374481	SC	school	4502400	2452	Greenwood 52	450240000746	2452028	Ninety-Six Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374540	SC	school	4502490	2601	Horry 01	450249001732	2601073	Myrtle Beach Primary	Regular School	No	Elementary	01	02	2021	grade_4	0.0	0
374655	SC	school	4502760	3203	Lexington 03	450276000745	3203030	Batesburg-Leesville Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374661	SC	school	4502790	3204	Lexington 04	450279000631	3204040	Sandhills Primary	Regular School	No	Elementary	01	02	2021	grade_4	0.0	0
374688	SC	school	4503908	3410	Marion 10	450390800761	3410003	Easterling Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374694	SC	school	4503908	3410	Marion 10	450390800771	3410013	North Mullins Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374741	SC	school	4503910	3809	Orangeburg	450391000860	3809026	Edisto Primary School	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374758	SC	school	4503910	3809	Orangeburg	450391001693	3809056	Rivelon Elmentary School	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374781	SC	school	4503330	3901	Pickens 01	450333001565	3901031	Libery Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374849	SC	school	4503390	4002	Richland 02	450339000650	4002089	Lake Carolina Elem	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0
374867	SC	school	4503460	4101	Saluda 01	450346000936	4101007	Saluda Primary	Regular School	No	Elementary	PK	02	2021	grade_4	0.0	0