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 order by ccd_school_high_grade desc 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
231624	SC	school	4500900	405	Anderson 05	450090001515	405800	West Market School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	202.0	202
231625	SC	school	4500900	405	Anderson 05	450090000102	405801	South Fant School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	173.0	173
231964	SC	school	4502130	2101	Florence 01	450213001728	2101800	R.N. Beck Child Development Center	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	120.0	120
231965	SC	school	4502130	2101	Florence 01	450213001657	2101803	Child Dev Ctr at Woods Road	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	163.0	163
232086	SC	school	4502310	2301	Greenville 01	450231001335	2301801	Overbrook Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	913.0	913
232101	SC	school	4502340	2450	Greenwood 50	450234001512	2450800	Greenwood ECC	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	246.0	246
232227	SC	school	4502640	3056	Laurens 56	450264000702	3056018	M S Bailey Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	117.0	117
232565	SC	school	4503660	4207	Spartanburg 07	450366001583	4207800	District 7 Early Learning Ctr	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	143.0	143
232650	SC	school	4503870	4603	York 03	450387000817	4603800	Central Child Development Ctr	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten	307.0	307
232843	SC	school	4500900	405	Anderson 05	450090001515	405800	West Market School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
232844	SC	school	4500900	405	Anderson 05	450090000102	405801	South Fant School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
233183	SC	school	4502130	2101	Florence 01	450213001728	2101800	R.N. Beck Child Development Center	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
233184	SC	school	4502130	2101	Florence 01	450213001657	2101803	Child Dev Ctr at Woods Road	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
233305	SC	school	4502310	2301	Greenville 01	450231001335	2301801	Overbrook Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
233320	SC	school	4502340	2450	Greenwood 50	450234001512	2450800	Greenwood ECC	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
233446	SC	school	4502640	3056	Laurens 56	450264000702	3056018	M S Bailey Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
233784	SC	school	4503660	4207	Spartanburg 07	450366001583	4207800	District 7 Early Learning Ctr	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
233869	SC	school	4503870	4603	York 03	450387000817	4603800	Central Child Development Ctr	Regular School	No	Prekindergarten	PK	PK	2020	kindergarten	0.0	0
234062	SC	school	4500900	405	Anderson 05	450090001515	405800	West Market School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
234063	SC	school	4500900	405	Anderson 05	450090000102	405801	South Fant School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
234402	SC	school	4502130	2101	Florence 01	450213001728	2101800	R.N. Beck Child Development Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
234403	SC	school	4502130	2101	Florence 01	450213001657	2101803	Child Dev Ctr at Woods Road	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
234524	SC	school	4502310	2301	Greenville 01	450231001335	2301801	Overbrook Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
234539	SC	school	4502340	2450	Greenwood 50	450234001512	2450800	Greenwood ECC	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
234665	SC	school	4502640	3056	Laurens 56	450264000702	3056018	M S Bailey Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
235003	SC	school	4503660	4207	Spartanburg 07	450366001583	4207800	District 7 Early Learning Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
235088	SC	school	4503870	4603	York 03	450387000817	4603800	Central Child Development Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_1	0.0	0
235281	SC	school	4500900	405	Anderson 05	450090001515	405800	West Market School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
235282	SC	school	4500900	405	Anderson 05	450090000102	405801	South Fant School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
235621	SC	school	4502130	2101	Florence 01	450213001728	2101800	R.N. Beck Child Development Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
235622	SC	school	4502130	2101	Florence 01	450213001657	2101803	Child Dev Ctr at Woods Road	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
235743	SC	school	4502310	2301	Greenville 01	450231001335	2301801	Overbrook Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
235758	SC	school	4502340	2450	Greenwood 50	450234001512	2450800	Greenwood ECC	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
235884	SC	school	4502640	3056	Laurens 56	450264000702	3056018	M S Bailey Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
236222	SC	school	4503660	4207	Spartanburg 07	450366001583	4207800	District 7 Early Learning Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
236307	SC	school	4503870	4603	York 03	450387000817	4603800	Central Child Development Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_2	0.0	0
236500	SC	school	4500900	405	Anderson 05	450090001515	405800	West Market School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
236501	SC	school	4500900	405	Anderson 05	450090000102	405801	South Fant School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
236840	SC	school	4502130	2101	Florence 01	450213001728	2101800	R.N. Beck Child Development Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
236841	SC	school	4502130	2101	Florence 01	450213001657	2101803	Child Dev Ctr at Woods Road	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
236962	SC	school	4502310	2301	Greenville 01	450231001335	2301801	Overbrook Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
236977	SC	school	4502340	2450	Greenwood 50	450234001512	2450800	Greenwood ECC	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
237103	SC	school	4502640	3056	Laurens 56	450264000702	3056018	M S Bailey Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
237441	SC	school	4503660	4207	Spartanburg 07	450366001583	4207800	District 7 Early Learning Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
237526	SC	school	4503870	4603	York 03	450387000817	4603800	Central Child Development Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_3	0.0	0
237719	SC	school	4500900	405	Anderson 05	450090001515	405800	West Market School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
237720	SC	school	4500900	405	Anderson 05	450090000102	405801	South Fant School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
238059	SC	school	4502130	2101	Florence 01	450213001728	2101800	R.N. Beck Child Development Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
238060	SC	school	4502130	2101	Florence 01	450213001657	2101803	Child Dev Ctr at Woods Road	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
238181	SC	school	4502310	2301	Greenville 01	450231001335	2301801	Overbrook Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
238196	SC	school	4502340	2450	Greenwood 50	450234001512	2450800	Greenwood ECC	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
238322	SC	school	4502640	3056	Laurens 56	450264000702	3056018	M S Bailey Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
238660	SC	school	4503660	4207	Spartanburg 07	450366001583	4207800	District 7 Early Learning Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
238745	SC	school	4503870	4603	York 03	450387000817	4603800	Central Child Development Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_4	0.0	0
238938	SC	school	4500900	405	Anderson 05	450090001515	405800	West Market School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
238939	SC	school	4500900	405	Anderson 05	450090000102	405801	South Fant School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
239278	SC	school	4502130	2101	Florence 01	450213001728	2101800	R.N. Beck Child Development Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
239279	SC	school	4502130	2101	Florence 01	450213001657	2101803	Child Dev Ctr at Woods Road	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
239400	SC	school	4502310	2301	Greenville 01	450231001335	2301801	Overbrook Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
239415	SC	school	4502340	2450	Greenwood 50	450234001512	2450800	Greenwood ECC	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
239541	SC	school	4502640	3056	Laurens 56	450264000702	3056018	M S Bailey Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
239879	SC	school	4503660	4207	Spartanburg 07	450366001583	4207800	District 7 Early Learning Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
239964	SC	school	4503870	4603	York 03	450387000817	4603800	Central Child Development Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_5	0.0	0
240157	SC	school	4500900	405	Anderson 05	450090001515	405800	West Market School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
240158	SC	school	4500900	405	Anderson 05	450090000102	405801	South Fant School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
240497	SC	school	4502130	2101	Florence 01	450213001728	2101800	R.N. Beck Child Development Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
240498	SC	school	4502130	2101	Florence 01	450213001657	2101803	Child Dev Ctr at Woods Road	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
240619	SC	school	4502310	2301	Greenville 01	450231001335	2301801	Overbrook Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
240634	SC	school	4502340	2450	Greenwood 50	450234001512	2450800	Greenwood ECC	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
240760	SC	school	4502640	3056	Laurens 56	450264000702	3056018	M S Bailey Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
241098	SC	school	4503660	4207	Spartanburg 07	450366001583	4207800	District 7 Early Learning Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
241183	SC	school	4503870	4603	York 03	450387000817	4603800	Central Child Development Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_6	0.0	0
241376	SC	school	4500900	405	Anderson 05	450090001515	405800	West Market School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
241377	SC	school	4500900	405	Anderson 05	450090000102	405801	South Fant School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
241716	SC	school	4502130	2101	Florence 01	450213001728	2101800	R.N. Beck Child Development Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
241717	SC	school	4502130	2101	Florence 01	450213001657	2101803	Child Dev Ctr at Woods Road	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
241838	SC	school	4502310	2301	Greenville 01	450231001335	2301801	Overbrook Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
241853	SC	school	4502340	2450	Greenwood 50	450234001512	2450800	Greenwood ECC	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
241979	SC	school	4502640	3056	Laurens 56	450264000702	3056018	M S Bailey Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
242317	SC	school	4503660	4207	Spartanburg 07	450366001583	4207800	District 7 Early Learning Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
242402	SC	school	4503870	4603	York 03	450387000817	4603800	Central Child Development Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_7	0.0	0
242595	SC	school	4500900	405	Anderson 05	450090001515	405800	West Market School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
242596	SC	school	4500900	405	Anderson 05	450090000102	405801	South Fant School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
242935	SC	school	4502130	2101	Florence 01	450213001728	2101800	R.N. Beck Child Development Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
242936	SC	school	4502130	2101	Florence 01	450213001657	2101803	Child Dev Ctr at Woods Road	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
243057	SC	school	4502310	2301	Greenville 01	450231001335	2301801	Overbrook Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
243072	SC	school	4502340	2450	Greenwood 50	450234001512	2450800	Greenwood ECC	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
243198	SC	school	4502640	3056	Laurens 56	450264000702	3056018	M S Bailey Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
243536	SC	school	4503660	4207	Spartanburg 07	450366001583	4207800	District 7 Early Learning Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
243621	SC	school	4503870	4603	York 03	450387000817	4603800	Central Child Development Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_8	0.0	0
243814	SC	school	4500900	405	Anderson 05	450090001515	405800	West Market School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	0.0	0
243815	SC	school	4500900	405	Anderson 05	450090000102	405801	South Fant School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	0.0	0
244154	SC	school	4502130	2101	Florence 01	450213001728	2101800	R.N. Beck Child Development Center	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	0.0	0
244155	SC	school	4502130	2101	Florence 01	450213001657	2101803	Child Dev Ctr at Woods Road	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	0.0	0
244276	SC	school	4502310	2301	Greenville 01	450231001335	2301801	Overbrook Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	0.0	0
244291	SC	school	4502340	2450	Greenwood 50	450234001512	2450800	Greenwood ECC	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	0.0	0
244417	SC	school	4502640	3056	Laurens 56	450264000702	3056018	M S Bailey Child Dev Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	0.0	0
244755	SC	school	4503660	4207	Spartanburg 07	450366001583	4207800	District 7 Early Learning Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	0.0	0
244840	SC	school	4503870	4603	York 03	450387000817	4603800	Central Child Development Ctr	Regular School	No	Prekindergarten	PK	PK	2020	grade_9	0.0	0
245033	SC	school	4500900	405	Anderson 05	450090001515	405800	West Market School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_10	0.0	0
245034	SC	school	4500900	405	Anderson 05	450090000102	405801	South Fant School of Early Ed.	Regular School	No	Prekindergarten	PK	PK	2020	grade_10	0.0	0