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 ccd_school_high_grade 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
231572	SC	school		301	Allendale 01		301006	Fairfax Elem						2020	pre_kindergarten	70.0	70
232322	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2020	pre_kindergarten	4.0	4
368596	SC	school		3410	Marion 10		3410413	Mullins ECC ANNEX						2021	pre_kindergarten	2.0	2
231855	SC	school	4501770	1402	Clarendon 02	450177000551	1402014	Manning Early Childhood Ctr	Regular School	No	Elementary	PK	01	2020	pre_kindergarten	130.0	130
232573	SC	school	4503902	4301	Sumter 01	450390201071	4301016	Oakland Primary	Regular School	No	Elementary	PK	01	2020	pre_kindergarten	99.0	99
368846	SC	school	4503902	4301	Sumter 01	450390201071	4301016	Oakland Primary	Regular School	No	Elementary	PK	01	2021	pre_kindergarten	92.0	92
231527	SC	school	4500690	160	Abbeville 60	450069000071	160020	Long Cane Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	50.0	50
231579	SC	school	4500780	401	Anderson 01	450078000068	401006	Concrete Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	80.0	80
231591	SC	school	4500810	402	Anderson 02	450081000079	402015	Marshall Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	95.0	95
231610	SC	school	4500900	405	Anderson 05	450090000099	405047	Homeland Park Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	58.0	58
231678	SC	school	4501170	801	Berkeley 01	450117000154	801011	Berkeley Elem	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	63.0	63
231687	SC	school	4501170	801	Berkeley 01	450117001209	801023	Sangaree Elem	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	80.0	80
231705	SC	school	4501170	801	Berkeley 01	450117000704	801045	Westview Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	242.0	242
231784	SC	school	4501440	1001	Charleston 01	450144000944	1001110	Laurel Hill Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	68.0	68
231819	SC	school	4501500	1101	Cherokee 01	450150000859	1101025	Blacksburg Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	67.0	67
231837	SC	school	4501560	1301	Chesterfield 01	450156000303	1301012	Cheraw Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	65.0	65
231840	SC	school	4501560	1301	Chesterfield 01	450156000307	1301019	Petersburg Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	77.0	77
231850	SC	school	4501740	1401	Clarendon 01	450174001494	1401022	Summerton Early Childhood Ctr	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	30.0	30
231872	SC	school	4501860	1601	Darlington 01	450186000351	1601014	Cain Elem	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	40.0	40
231874	SC	school	4501860	1601	Darlington 01	450186000353	1601016	Lamar Elem	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	40.0	40
231876	SC	school	4501860	1601	Darlington 01	450186000355	1601018	Pate Elem	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	58.0	58
231883	SC	school	4501860	1601	Darlington 01	450186000365	1601029	Washington St Elem	Regular School	No	Elementary	01	02	2020	pre_kindergarten	0.0	0
231972	SC	school	4502190	2103	Florence 03	450219001641	2103050	Lake City ECC	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	64.0	64
232108	SC	school	4502400	2452	Greenwood 52	450240000746	2452028	Ninety-Six Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	43.0	43
232167	SC	school	4502490	2601	Horry 01	450249001732	2601073	Myrtle Beach Primary	Regular School	No	Elementary	01	02	2020	pre_kindergarten	0.0	0
232253	SC	school	4502700	3201	Lexington 01	450270000586	3201059	Gilbert Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	115.0	115
232281	SC	school	4502760	3203	Lexington 03	450276000745	3203030	Batesburg-Leesville Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	128.0	128
232287	SC	school	4502790	3204	Lexington 04	450279000631	3204040	Sandhills Primary	Regular School	No	Elementary	01	02	2020	pre_kindergarten	0.0	0
232314	SC	school	4503908	3410	Marion 10	450390800761	3410003	Easterling Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	55.0	55
232320	SC	school	4503908	3410	Marion 10	450390800771	3410013	North Mullins Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	104.0	104
232367	SC	school	4503910	3809	Orangeburg	450391000860	3809026	Edisto Primary School	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	84.0	84
232384	SC	school	4503910	3809	Orangeburg	450391001693	3809056	Rivelon Elmentary School	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	47.0	47
232475	SC	school	4503390	4002	Richland 02	450339000650	4002089	Lake Carolina Elem	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	34.0	34
232493	SC	school	4503460	4101	Saluda 01	450346000936	4101007	Saluda Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	68.0	68
232528	SC	school	4503570	4204	Spartanburg 04	450357001012	4204040	Woodruff Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	194.0	194
232600	SC	school	4503780	4501	Williamsburg 01	450378001094	4501013	Anderson Primary	Regular School	No	Elementary	PK	02	2020	pre_kindergarten	66.0	66
232694	SC	school	4503901	4701	SC Public Charter School District	450390101689	4701049	Meyers Center for Special Children	Special Education School	Yes	Elementary	PK	02	2020	pre_kindergarten	32.0	32
232702	SC	school	4503901	4701	SC Public Charter School District	450390101733	4701058	Renaissance Collegiate Academy	Regular School	Yes	Elementary	KG	02	2020	pre_kindergarten	0.0	0
367807	SC	school	4500690	160	Abbeville 60	450069000071	160020	Long Cane Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	45.0	45
367851	SC	school	4500750	301	Allendale 01	450075001661	301006	Fairfax Elem	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	69.0	69
367858	SC	school	4500780	401	Anderson 01	450078000068	401006	Concrete Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	55.0	55
367870	SC	school	4500810	402	Anderson 02	450081000079	402015	Marshall Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	61.0	61
367889	SC	school	4500900	405	Anderson 05	450090000099	405047	Homeland Park Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	56.0	56
367957	SC	school	4501170	801	Berkeley 01	450117000154	801011	Berkeley Elem	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	46.0	46
367966	SC	school	4501170	801	Berkeley 01	450117001209	801023	Sangaree Elem	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	59.0	59
367984	SC	school	4501170	801	Berkeley 01	450117000704	801045	Westview Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	181.0	181
368060	SC	school	4501440	1001	Charleston 01	450144000944	1001110	Laurel Hill Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	64.0	64
368096	SC	school	4501500	1101	Cherokee 01	450150000859	1101025	Blacksburg Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	47.0	47
368114	SC	school	4501560	1301	Chesterfield 01	450156000303	1301012	Cheraw Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	44.0	44
368117	SC	school	4501560	1301	Chesterfield 01	450156000307	1301019	Petersburg Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	37.0	37
368127	SC	school	4501740	1401	Clarendon 01	450174001494	1401022	Summerton Early ChildhoodCtr	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	25.0	25
368150	SC	school	4501860	1601	Darlington 01	450186000355	1601018	Pate Elem	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	31.0	31
368245	SC	school	4502190	2103	Florence 03	450219001641	2103050	Lake City ECC	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	58.0	58
368381	SC	school	4502400	2452	Greenwood 52	450240000746	2452028	Ninety-Six Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	44.0	44
368440	SC	school	4502490	2601	Horry 01	450249001732	2601073	Myrtle Beach Primary	Regular School	No	Elementary	01	02	2021	pre_kindergarten	0.0	0
368555	SC	school	4502760	3203	Lexington 03	450276000745	3203030	Batesburg-Leesville Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	79.0	79
368561	SC	school	4502790	3204	Lexington 04	450279000631	3204040	Sandhills Primary	Regular School	No	Elementary	01	02	2021	pre_kindergarten	0.0	0
368588	SC	school	4503908	3410	Marion 10	450390800761	3410003	Easterling Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	41.0	41
368594	SC	school	4503908	3410	Marion 10	450390800771	3410013	North Mullins Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	64.0	64
368641	SC	school	4503910	3809	Orangeburg	450391000860	3809026	Edisto Primary School	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	86.0	86
368658	SC	school	4503910	3809	Orangeburg	450391001693	3809056	Rivelon Elmentary School	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	29.0	29
368681	SC	school	4503330	3901	Pickens 01	450333001565	3901031	Libery Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	145.0	145
368749	SC	school	4503390	4002	Richland 02	450339000650	4002089	Lake Carolina Elem	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	30.0	30
368767	SC	school	4503460	4101	Saluda 01	450346000936	4101007	Saluda Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	60.0	60
368801	SC	school	4503570	4204	Spartanburg 04	450357001012	4204040	Woodruff Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	138.0	138
368873	SC	school	4503780	4501	Williamsburg 01	450378001094	4501013	Anderson Primary	Regular School	No	Elementary	PK	02	2021	pre_kindergarten	53.0	53
368966	SC	school	4503901	4701	SC Public Charter School	450390101689	4701049	Meyers Center for SpecialChildren	Special Education School	Yes	Elementary	PK	02	2021	pre_kindergarten	37.0	37
231639	SC	school	4501080	645	Barnwell 45	450108000130	645011	Barnwell Primary	Regular School	No	Elementary	PK	03	2020	pre_kindergarten	73.0	73
231853	SC	school	4501770	1402	Clarendon 02	450177000325	1402012	Manning Primary	Regular School	No	Elementary	01	03	2020	pre_kindergarten	0.0	0
231894	SC	school	4501920	1704	Dillon 04	450192000381	1704007	East Elementary	Regular School	No	Elementary	PK	03	2020	pre_kindergarten	40.0	40
231895	SC	school	4501920	1704	Dillon 04	450192000382	1704008	South Elementary	Regular School	No	Elementary	PK	03	2020	pre_kindergarten	20.0	20
231898	SC	school	4501920	1704	Dillon 04	450192000384	1704011	Stewart Heights Elementary	Regular School	No	Elementary	PK	03	2020	pre_kindergarten	43.0	43
231994	SC	school	4502280	2201	Georgetown 01	450228000480	2201024	Waccamaw Elem	Regular School	No	Elementary	PK	03	2020	pre_kindergarten	48.0	48
232113	SC	school	4502430	2501	Hampton 01	450243000607	2501009	Varnville Elementary	Regular School	No	Elementary	PK	03	2020	pre_kindergarten	57.0	57
232115	SC	school	4502430	2501	Hampton 01	450243001428	2501018	Ben Hazel Primary	Regular School	No	Elementary	PK	03	2020	pre_kindergarten	36.0	36
232323	SC	school	4502970	3501	Marlboro 01	450297000783	3501012	Bennettsville Primary	Regular School	No	Elementary	PK	03	2020	pre_kindergarten	61.0	61
232501	SC	school	4503480	4201	Spartanburg 01	450348000986	4201010	Inman Elem	Regular School	No	Elementary	PK	03	2020	pre_kindergarten	147.0	147
232575	SC	school	4503902	4301	Sumter 01	450390201073	4301019	Shaw Heights Elementary	Regular School	No	Elementary	02	03	2020	pre_kindergarten	0.0	0
232704	SC	school	4503909	4801	Charter Institute at Erskine	450390901700	4801002	Belton Preparatory Academy	Regular School	Yes	Elementary	KG	03	2020	pre_kindergarten	0.0	0
232719	SC	school	4503909	4801	Charter Institute at Erskine	450390901719	4801017	Summit Classical School	Regular School	Yes	Elementary	KG	03	2020	pre_kindergarten	0.0	0
367918	SC	school	4501080	645	Barnwell 45	450108000130	645011	Barnwell Primary	Regular School	No	Elementary	PK	03	2021	pre_kindergarten	65.0	65
368130	SC	school	4501770	1402	Clarendon 02	450177000325	1402012	Manning Primary	Regular School	No	Elementary	02	03	2021	pre_kindergarten	0.0	0
368132	SC	school	4501770	1402	Clarendon 02	450177000551	1402014	Manning Early Childhood Ctr	Regular School	No	Elementary	PK	03	2021	pre_kindergarten	75.0	75
368167	SC	school	4501920	1704	Dillon 04	450192000381	1704007	East Elementary	Regular School	No	Elementary	PK	03	2021	pre_kindergarten	39.0	39
368168	SC	school	4501920	1704	Dillon 04	450192000382	1704008	South Elementary	Regular School	No	Elementary	PK	03	2021	pre_kindergarten	20.0	20
368171	SC	school	4501920	1704	Dillon 04	450192000384	1704011	Stewart Heights Elementary	Regular School	No	Elementary	PK	03	2021	pre_kindergarten	49.0	49
368267	SC	school	4502280	2201	Georgetown 01	450228000480	2201024	Waccamaw Elem	Regular School	No	Elementary	PK	03	2021	pre_kindergarten	34.0	34
368386	SC	school	4502430	2501	Hampton 01	450243000607	2501009	Varnville Elementary	Regular School	No	Elementary	PK	03	2021	pre_kindergarten	36.0	36
368388	SC	school	4502430	2501	Hampton 01	450243001428	2501018	Ben Hazel Primary	Regular School	No	Elementary	PK	03	2021	pre_kindergarten	31.0	31
368597	SC	school	4502970	3501	Marlboro 01	450297000783	3501012	Bennettsville Primary	Regular School	No	Elementary	PK	03	2021	pre_kindergarten	40.0	40
368775	SC	school	4503480	4201	Spartanburg 01	450348000986	4201010	Inman Elem	Regular School	No	Elementary	PK	03	2021	pre_kindergarten	94.0	94
368848	SC	school	4503902	4301	Sumter 01	450390201073	4301019	Shaw Heights Elementary	Regular School	No	Elementary	02	03	2021	pre_kindergarten	0.0	0
368974	SC	school	4503901	4701	SC Public Charter School	450390101733	4701058	Renaissance CollegiateAcademy	Regular School	Yes	Elementary	KG	03	2021	pre_kindergarten	0.0	0
231654	SC	school	4501110	701	Beaufort 01	450111000392	701023	Whale Branch Elem	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	64.0	64
231710	SC	school	4501170	801	Berkeley 01	450117001537	801050	Cane Bay Elementary	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	21.0	21
231714	SC	school	4501170	801	Berkeley 01	450117001671	801054	Phillip Simmons Elementary	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	19.0	19
231757	SC	school	4501440	1001	Charleston 01	450144000224	1001072	Matilda Dunston Elem	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	47.0	47
231826	SC	school	4501530	1201	Chester 01	450153000292	1201014	Lewisville Elem	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	48.0	48
231890	SC	school	4501950	1703	Dillon 03	450195000389	1703024	Latta Elementary	Regular School	No	Elementary	PK	04	2020	pre_kindergarten	82.0	82
231948	SC	school	4502130	2101	Florence 01	450213000426	2101009	Carver Elem	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0.0	0
231949	SC	school	4502130	2101	Florence 01	450213000427	2101010	Delmae Elem	Regular School	No	Elementary	KG	04	2020	pre_kindergarten	0.0	0