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 "year" = :p2 and (district_state_id > :p4 or (district_state_id = :p4 and rowid > :p3)) order by district_state_id, 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
380201	SC	school	4501440	1001	Charleston 01	450144000250	1001001	Baptist Hill High	Regular School	No	High	06	12	2021	grade_9	104.0	104
380202	SC	school	4501440	1001	Charleston 01	450144000251	1001002	N Charleston High	Regular School	No	High	09	12	2021	grade_9	291.0	291
380203	SC	school	4501440	1001	Charleston 01	450144001328	1001010	Burke High	Regular School	No	High	09	12	2021	grade_9	127.0	127
380204	SC	school	4501440	1001	Charleston 01	450144000261	1001014	Wando High	Regular School	No	High	09	12	2021	grade_9	669.0	669
380205	SC	school	4501440	1001	Charleston 01	450144001330	1001018	Military Magnet Academy	Regular School	No	High	06	12	2021	grade_9	85.0	85
380206	SC	school	4501440	1001	Charleston 01	450144000264	1001020	St Johns High	Regular School	No	High	09	12	2021	grade_9	111.0	111
380207	SC	school	4501440	1001	Charleston 01	450144000265	1001022	R B Stall High	Regular School	No	High	09	12	2021	grade_9	599.0	599
380208	SC	school	4501440	1001	Charleston 01	450144001211	1001030	Northwoods Middle	Regular School	No	Middle	06	08	2021	grade_9	0.0	0
380209	SC	school	4501440	1001	Charleston 01	450144000197	1001033	Chicora Elem	Regular School	No	Elementary	01	05	2021	grade_9	0.0	0
380210	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380211	SC	school	4501440	1001	Charleston 01	450144000201	1001039	Jane Edwards Elem	Regular School	No	Elementary	PK	06	2021	grade_9	0.0	0
380212	SC	school	4501440	1001	Charleston 01	450144000202	1001040	Mary Ford Elem	Regular School	No	Elementary	PK	KG	2021	grade_9	0.0	0
380213	SC	school	4501440	1001	Charleston 01	450144000204	1001042	W B Goodwin Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380214	SC	school	4501440	1001	Charleston 01	450144001214	1001043	Harbor View Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380215	SC	school	4501440	1001	Charleston 01	450144001215	1001044	Haut Gap Middle	Regular School	No	Middle	06	08	2021	grade_9	0.0	0
380216	SC	school	4501440	1001	Charleston 01	450144000205	1001045	Minnie Hughes Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380217	SC	school	4501440	1001	Charleston 01	450144000206	1001046	Hunley Park Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380218	SC	school	4501440	1001	Charleston 01	450144000207	1001050	Ladson Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380219	SC	school	4501440	1001	Charleston 01	450144001217	1001051	Laing Middle	Regular School	No	Middle	06	08	2021	grade_9	0.0	0
380220	SC	school	4501440	1001	Charleston 01	450144000208	1001052	Lambs Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380221	SC	school	4501440	1001	Charleston 01	450144001352	1001056	St James-Santee Elem	Regular School	No	Elementary	PK	08	2021	grade_9	0.0	0
380222	SC	school	4501440	1001	Charleston 01	450144000210	1001057	Memminger Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380223	SC	school	4501440	1001	Charleston 01	450144000211	1001058	Midland Park Primary	Regular School	No	Elementary	PK	KG	2021	grade_9	0.0	0
380224	SC	school	4501440	1001	Charleston 01	450144000212	1001059	Ellington Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380225	SC	school	4501440	1001	Charleston 01	450144000213	1001060	Mitchell Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380226	SC	school	4501440	1001	Charleston 01	450144000214	1001061	Jennie Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380227	SC	school	4501440	1001	Charleston 01	450144000215	1001062	Morningside Middle	Regular School	No	Middle	06	08	2021	grade_9	0.0	0
380228	SC	school	4501440	1001	Charleston 01	450144000216	1001063	Mt Pleasant Academy	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380229	SC	school	4501440	1001	Charleston 01	450144001218	1001065	Moultrie Middle	Regular School	No	Middle	06	08	2021	grade_9	0.0	0
380230	SC	school	4501440	1001	Charleston 01	450144000218	1001066	Murray LaSaine MontessoriSchool	Regular School	No	Elementary	PK	08	2021	grade_9	0.0	0
380231	SC	school	4501440	1001	Charleston 01	450144000219	1001067	North Charleston Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380232	SC	school	4501440	1001	Charleston 01	450144000220	1001068	Oakland Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380233	SC	school	4501440	1001	Charleston 01	450144000222	1001070	Malcolm C. Hursey MontessoriSchool	Regular School	No	Elementary	PK	08	2021	grade_9	0.0	0
380234	SC	school	4501440	1001	Charleston 01	450144000224	1001072	Matilda Dunston Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380235	SC	school	4501440	1001	Charleston 01	450144000225	1001075	Edith L Frierson Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380236	SC	school	4501440	1001	Charleston 01	450144000226	1001076	Sanders-Clyde Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380237	SC	school	4501440	1001	Charleston 01	450144000227	1001077	Pepperhill Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380238	SC	school	4501440	1001	Charleston 01	450144000228	1001079	James Simon MontessoriSchool	Regular School	No	Elementary	PK	08	2021	grade_9	0.0	0
380239	SC	school	4501440	1001	Charleston 01	450144000229	1001081	Springfield Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380240	SC	school	4501440	1001	Charleston 01	450144000230	1001082	St Andrew's Math and Science	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380241	SC	school	4501440	1001	Charleston 01	450144000231	1001083	Angel Oak Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380242	SC	school	4501440	1001	Charleston 01	450144000232	1001084	Stiles Point Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380243	SC	school	4501440	1001	Charleston 01	450144000233	1001085	Stono Park Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380244	SC	school	4501440	1001	Charleston 01	450144000234	1001086	Sullivan's Island Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380245	SC	school	4501440	1001	Charleston 01	450144000236	1001090	Mamie Whitesides Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380246	SC	school	4501440	1001	Charleston 01	450144001363	1001091	Ashley River Creative Arts	Regular School	No	Elementary	KG	05	2021	grade_9	0.0	0
380247	SC	school	4501440	1001	Charleston 01	450144000249	1001092	C.E. Williams Middle School forCreative and Scientific Arts	Regular School	No	Middle	06	08	2021	grade_9	0.0	0
380248	SC	school	4501440	1001	Charleston 01	450144001329	1001093	James B Edwards Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380249	SC	school	4501440	1001	Charleston 01	450144001382	1001094	Buist Academy	Regular School	No	Elementary	01	08	2021	grade_9	0.0	0
380250	SC	school	4501440	1001	Charleston 01	450144001404	1001095	Mt Zion Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380251	SC	school	4501440	1001	Charleston 01	450144001438	1001096	Belle Hall Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380252	SC	school	4501440	1001	Charleston 01	450144000083	1001098	Charleston School Of The Arts	Regular School	No	High	06	12	2021	grade_9	158.0	158
380253	SC	school	4501440	1001	Charleston 01	450144000168	1001099	Academic Magnet High	Regular School	No	High	09	12	2021	grade_9	184.0	184
380254	SC	school	4501440	1001	Charleston 01	450144000240	1001101	Charleston Progressive	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380255	SC	school	4501440	1001	Charleston 01	450144000429	1001102	Charles Pinckney Elem	Regular School	No	Elementary	03	05	2021	grade_9	0.0	0
380256	SC	school	4501440	1001	Charleston 01	450144000430	1001103	Thomas C. Cario Middle	Regular School	No	Middle	06	08	2021	grade_9	0.0	0
380257	SC	school	4501440	1001	Charleston 01	450144000548	1001104	West Ashley High	Regular School	No	High	09	12	2021	grade_9	586.0	586
380258	SC	school	4501440	1001	Charleston 01	450144000830	1001107	James Island Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380259	SC	school	4501440	1001	Charleston 01	450144001167	1001109	Drayton Hall Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380260	SC	school	4501440	1001	Charleston 01	450144000944	1001110	Laurel Hill Primary	Regular School	No	Elementary	PK	02	2021	grade_9	0.0	0
380261	SC	school	4501440	1001	Charleston 01	450144001533	1001111	Jerry Zucker Middle School Sci	Regular School	No	Middle	06	08	2021	grade_9	0.0	0
380262	SC	school	4501440	1001	Charleston 01	450144001562	1001112	Pinehurst Elementary	Regular School	No	Elementary	01	05	2021	grade_9	0.0	0
380263	SC	school	4501440	1001	Charleston 01	450144001610	1001113	Montessori Community School	Regular School	No	Elementary	PK	08	2021	grade_9	0.0	0
380264	SC	school	4501440	1001	Charleston 01	450144001611	1001114	N. Charleston Creative ArtsElem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380265	SC	school	4501440	1001	Charleston 01	450144001660	1001115	Simmons Pinckney MiddleSchool	Regular School	No	Middle	06	08	2021	grade_9	0.0	0
380266	SC	school	4501440	1001	Charleston 01	450144001667	1001116	Deer Park Middle	Regular School	No	Middle	06	08	2021	grade_9	0.0	0
380267	SC	school	4501440	1001	Charleston 01	450144001690	1001117	Carolina Park Elementary	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380268	SC	school	4501440	1001	Charleston 01	450144001691	1001118	Camp Road Middle School	Regular School	No	Middle	06	08	2021	grade_9	0.0	0
380269	SC	school	4501440	1001	Charleston 01	450144001746	1001121	Lucy Garrett Beckham High	Regular School	No	Secondary	09	10	2021	grade_9	427.0	427
380270	SC	school	4501440	1001	Charleston 01	450144001648	1001200	Meeting Street ElementarySchool	Regular School	No	Elementary	PK	07	2021	grade_9	0.0	0
380271	SC	school	4501440	1001	Charleston 01	450144000838	1001612	Charleston Develop. Charter	Regular School	Yes	Elementary	PK	08	2021	grade_9	0.0	0
380272	SC	school	4501440	1001	Charleston 01	450144000856	1001614	East Cooper MontessoriCharter	Regular School	Yes	Elementary	PK	08	2021	grade_9	0.0	0
380273	SC	school	4501440	1001	Charleston 01	450144000857	1001615	Greg Mathis Charter High	Regular School	Yes	High	09	12	2021	grade_9	31.0	31
380274	SC	school	4501440	1001	Charleston 01	450144001168	1001616	James Island Charter High	Regular School	Yes	High	09	12	2021	grade_9	450.0	450
380275	SC	school	4501440	1001	Charleston 01	450144001457	1001618	Orange Grove Charter	Regular School	Yes	Elementary	PK	08	2021	grade_9	0.0	0
380276	SC	school	4501440	1001	Charleston 01	450144001505	1001620	Charleston CharterMath/Scienc	Regular School	Yes	High	06	12	2021	grade_9	91.0	91
380277	SC	school	4501440	1001	Charleston 01	450144001553	1001628	Pattison's Acad For Compr Edu	Regular School	Yes	Other	KG	12	2021	grade_9	1.0	1
380278	SC	school	4501440	1001	Charleston 01	450144001628	1001629	Carolina Voyager Charter	Regular School	Yes	Elementary	KG	08	2021	grade_9	0.0	0
380279	SC	school	4501440	1001	Charleston 01	450144001655	1001630	Allegro Charter Sch of Music	Regular School	Yes	High	06	12	2021	grade_9	38.0	38
380280	SC	school	4501500	1101	Cherokee 01	450150000283	1101001	Blacksburg High	Regular School	No	High	09	12	2021	grade_9	155.0	155
380281	SC	school	4501500	1101	Cherokee 01	450150000284	1101002	John E Ewing Middle	Regular School	No	Middle	06	08	2021	grade_9	0.0	0
380282	SC	school	4501500	1101	Cherokee 01	450150000285	1101003	Gaffney High	Regular School	No	High	09	12	2021	grade_9	554.0	554
380283	SC	school	4501500	1101	Cherokee 01	450150000269	1101005	Alma Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380284	SC	school	4501500	1101	Cherokee 01	450150000271	1101007	Blacksburg Middle	Regular School	No	Middle	06	08	2021	grade_9	0.0	0
380285	SC	school	4501500	1101	Cherokee 01	450150000273	1101009	Corinth Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380286	SC	school	4501500	1101	Cherokee 01	450150000274	1101010	Draytonville Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380287	SC	school	4501500	1101	Cherokee 01	450150000275	1101011	Mary Bramlett Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380288	SC	school	4501500	1101	Cherokee 01	450150000276	1101012	Goucher Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380289	SC	school	4501500	1101	Cherokee 01	450150000278	1101015	B D Lee Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380290	SC	school	4501500	1101	Cherokee 01	450150000282	1101019	Luther L Vaughan Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380291	SC	school	4501500	1101	Cherokee 01	450150001391	1101020	Blacksburg Elem	Regular School	No	Elementary	03	05	2021	grade_9	0.0	0
380292	SC	school	4501500	1101	Cherokee 01	450150000287	1101021	Limestone/Central Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380293	SC	school	4501500	1101	Cherokee 01	450150000296	1101022	Grassy Pond Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380294	SC	school	4501500	1101	Cherokee 01	450150000297	1101023	Northwest Elem	Regular School	No	Elementary	PK	05	2021	grade_9	0.0	0
380295	SC	school	4501500	1101	Cherokee 01	450150000549	1101024	Gaffney Middle	Regular School	No	Middle	06	08	2021	grade_9	0.0	0
380296	SC	school	4501500	1101	Cherokee 01	450150000859	1101025	Blacksburg Primary	Regular School	No	Elementary	PK	02	2021	grade_9	0.0	0
380297	SC	school	4501530	1201	Chester 01	450153000298	1201002	Chester Sr High	Regular School	No	High	09	12	2021	grade_9	239.0	239
380298	SC	school	4501530	1201	Chester 01	450153000299	1201004	Chester Middle	Regular School	No	Middle	06	08	2021	grade_9	0.0	0
380299	SC	school	4501530	1201	Chester 01	450153000300	1201005	Great Falls High	Regular School	No	High	06	12	2021	grade_9	72.0	72
380300	SC	school	4501530	1201	Chester 01	450153000301	1201006	Lewisville High	Regular School	No	High	09	12	2021	grade_9	115.0	115
380301	SC	school	4501530	1201	Chester 01	450153001225	1201008	Lewisville Middle	Regular School	No	Middle	05	08	2021	grade_9	0.0	0