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 (ccd_school_lvl > :p3 or (ccd_school_lvl = :p3 and rowid > :p2)) order by ccd_school_lvl, 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
234138	SC	school	4501170	801	Berkeley 01	450117000035	801039	Devon Forest Elem	Regular School	No	Elementary	PK	05	2020	grade_1	150.0	150
234139	SC	school	4501170	801	Berkeley 01	450117000003	801040	Mount Holly Elementary	Regular School	No	Elementary	PK	05	2020	grade_1	81.0	81
234140	SC	school	4501170	801	Berkeley 01	450117000082	801041	Berkeley Intermed	Regular School	No	Elementary	03	05	2020	grade_1	0.0	0
234142	SC	school	4501170	801	Berkeley 01	450117000423	801044	Hanahan Elem	Regular School	No	Elementary	PK	05	2020	grade_1	163.0	163
234143	SC	school	4501170	801	Berkeley 01	450117000704	801045	Westview Primary	Regular School	No	Elementary	PK	02	2020	grade_1	180.0	180
234144	SC	school	4501170	801	Berkeley 01	450117000822	801046	Goose Creek Elementary	Regular School	No	Elementary	PK	05	2020	grade_1	149.0	149
234146	SC	school	4501170	801	Berkeley 01	450117001472	801048	Daniel Island School	Regular School	No	Elementary	PK	08	2020	grade_1	118.0	118
234148	SC	school	4501170	801	Berkeley 01	450117001537	801050	Cane Bay Elementary	Regular School	No	Elementary	PK	04	2020	grade_1	250.0	250
234151	SC	school	4501170	801	Berkeley 01	450117001658	801053	Nexton Elementary	Regular School	No	Elementary	PK	05	2020	grade_1	144.0	144
234152	SC	school	4501170	801	Berkeley 01	450117001671	801054	Phillip Simmons Elementary	Regular School	No	Elementary	PK	04	2020	grade_1	83.0	83
234155	SC	school	4501170	801	Berkeley 01	450117001682	801057	Bowen's Corner Elementary	Regular School	No	Elementary	PK	05	2020	grade_1	112.0	112
234156	SC	school	4501170	801	Berkeley 01	450117001707	801058	Foxbank Elementary	Regular School	No	Elementary	PK	05	2020	grade_1	169.0	169
234158	SC	school	4501250	901	Calhoun 01	450125000424	901008	Sandy Run School	Regular School	No	Elementary	PK	08	2020	grade_1	64.0	64
234159	SC	school	4501250	901	Calhoun 01	450125001532	901009	St Matthews K-8 School	Regular School	No	Elementary	PK	08	2020	grade_1	63.0	63
234169	SC	school	4501440	1001	Charleston 01	450144000197	1001033	Chicora Elem	Regular School	No	Elementary	PK	05	2020	grade_1	45.0	45
234170	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	grade_1	123.0	123
234171	SC	school	4501440	1001	Charleston 01	450144000200	1001038	Edmund A Burns Elem	Regular School	No	Elementary	04	05	2020	grade_1	0.0	0
234172	SC	school	4501440	1001	Charleston 01	450144000201	1001039	Jane Edwards Elem	Regular School	No	Elementary	PK	06	2020	grade_1	8.0	8
234173	SC	school	4501440	1001	Charleston 01	450144000202	1001040	Mary Ford Elem	Regular School	No	Elementary	PK	05	2020	grade_1	38.0	38
234174	SC	school	4501440	1001	Charleston 01	450144000204	1001042	W B Goodwin Elem	Regular School	No	Elementary	PK	05	2020	grade_1	70.0	70
234175	SC	school	4501440	1001	Charleston 01	450144001214	1001043	Harbor View Elem	Regular School	No	Elementary	PK	05	2020	grade_1	107.0	107
234177	SC	school	4501440	1001	Charleston 01	450144000205	1001045	Minnie Hughes Elem	Regular School	No	Elementary	PK	05	2020	grade_1	23.0	23
234178	SC	school	4501440	1001	Charleston 01	450144000206	1001046	Hunley Park Elem	Regular School	No	Elementary	PK	05	2020	grade_1	65.0	65
234179	SC	school	4501440	1001	Charleston 01	450144000207	1001050	Ladson Elem	Regular School	No	Elementary	PK	05	2020	grade_1	147.0	147
234181	SC	school	4501440	1001	Charleston 01	450144000208	1001052	Lambs Elem	Regular School	No	Elementary	PK	05	2020	grade_1	58.0	58
234182	SC	school	4501440	1001	Charleston 01	450144001352	1001056	St James-Santee Elem	Regular School	No	Elementary	PK	08	2020	grade_1	15.0	15
234183	SC	school	4501440	1001	Charleston 01	450144000210	1001057	Memminger Elem	Regular School	No	Elementary	PK	05	2020	grade_1	38.0	38
234184	SC	school	4501440	1001	Charleston 01	450144000211	1001058	Midland Park Primary	Regular School	No	Elementary	PK	KG	2020	grade_1	0.0	0
234185	SC	school	4501440	1001	Charleston 01	450144000212	1001059	Ellington Elem	Regular School	No	Elementary	PK	05	2020	grade_1	47.0	47
234186	SC	school	4501440	1001	Charleston 01	450144000213	1001060	Mitchell Elem	Regular School	No	Elementary	PK	05	2020	grade_1	39.0	39
234187	SC	school	4501440	1001	Charleston 01	450144000214	1001061	Jennie Moore Elem	Regular School	No	Elementary	PK	05	2020	grade_1	149.0	149
234189	SC	school	4501440	1001	Charleston 01	450144000216	1001063	Mt Pleasant Academy	Regular School	No	Elementary	PK	05	2020	grade_1	105.0	105
234191	SC	school	4501440	1001	Charleston 01	450144000218	1001066	Murray Lasaine Elem	Regular School	No	Elementary	PK	08	2020	grade_1	40.0	40
234192	SC	school	4501440	1001	Charleston 01	450144000219	1001067	North Charleston Elem	Regular School	No	Elementary	PK	05	2020	grade_1	41.0	41
234193	SC	school	4501440	1001	Charleston 01	450144000220	1001068	Oakland Elem	Regular School	No	Elementary	PK	05	2020	grade_1	88.0	88
234194	SC	school	4501440	1001	Charleston 01	450144000222	1001070	Malcolm C Hursey Elem	Regular School	No	Elementary	PK	08	2020	grade_1	51.0	51
234195	SC	school	4501440	1001	Charleston 01	450144000224	1001072	Matilda Dunston Elem	Regular School	No	Elementary	PK	04	2020	grade_1	70.0	70
234196	SC	school	4501440	1001	Charleston 01	450144000225	1001075	Edith L Frierson Elem	Regular School	No	Elementary	PK	05	2020	grade_1	18.0	18
234197	SC	school	4501440	1001	Charleston 01	450144000226	1001076	Sanders-Clyde Elem	Regular School	No	Elementary	PK	05	2020	grade_1	66.0	66
234198	SC	school	4501440	1001	Charleston 01	450144000227	1001077	Pepperhill Elem	Regular School	No	Elementary	PK	05	2020	grade_1	101.0	101
234199	SC	school	4501440	1001	Charleston 01	450144000228	1001079	James Simons Elem	Regular School	No	Elementary	PK	08	2020	grade_1	34.0	34
234200	SC	school	4501440	1001	Charleston 01	450144000229	1001081	Springfield Elem	Regular School	No	Elementary	PK	05	2020	grade_1	96.0	96
234201	SC	school	4501440	1001	Charleston 01	450144000230	1001082	St Andrew's Math and Science	Regular School	No	Elementary	PK	05	2020	grade_1	126.0	126
234202	SC	school	4501440	1001	Charleston 01	450144000231	1001083	Angel Oak Elem	Regular School	No	Elementary	PK	05	2020	grade_1	97.0	97
234203	SC	school	4501440	1001	Charleston 01	450144000232	1001084	Stiles Point Elem	Regular School	No	Elementary	PK	05	2020	grade_1	106.0	106
234204	SC	school	4501440	1001	Charleston 01	450144000233	1001085	Stono Park Elem	Regular School	No	Elementary	PK	05	2020	grade_1	86.0	86
234205	SC	school	4501440	1001	Charleston 01	450144000234	1001086	Sullivan's Island Elem	Regular School	No	Elementary	PK	05	2020	grade_1	74.0	74
234206	SC	school	4501440	1001	Charleston 01	450144000236	1001090	Mamie Whitesides Elem	Regular School	No	Elementary	PK	05	2020	grade_1	131.0	131
234207	SC	school	4501440	1001	Charleston 01	450144001363	1001091	Ashley River Creative Arts	Regular School	No	Elementary	KG	05	2020	grade_1	106.0	106
234209	SC	school	4501440	1001	Charleston 01	450144001329	1001093	James B Edwards Elem	Regular School	No	Elementary	PK	05	2020	grade_1	103.0	103
234210	SC	school	4501440	1001	Charleston 01	450144001382	1001094	Buist Academy	Regular School	No	Elementary	KG	08	2020	grade_1	50.0	50
234211	SC	school	4501440	1001	Charleston 01	450144001404	1001095	Mt Zion Elem	Regular School	No	Elementary	PK	05	2020	grade_1	24.0	24
234212	SC	school	4501440	1001	Charleston 01	450144001438	1001096	Belle Hall Elem	Regular School	No	Elementary	PK	05	2020	grade_1	108.0	108
234215	SC	school	4501440	1001	Charleston 01	450144000240	1001101	Charleston Progressive	Regular School	No	Elementary	PK	05	2020	grade_1	46.0	46
234216	SC	school	4501440	1001	Charleston 01	450144000429	1001102	Charles Pinckney Elem	Regular School	No	Elementary	03	05	2020	grade_1	0.0	0
234220	SC	school	4501440	1001	Charleston 01	450144000830	1001107	James Island Elem	Regular School	No	Elementary	PK	05	2020	grade_1	76.0	76
234221	SC	school	4501440	1001	Charleston 01	450144001167	1001109	Drayton Hall Elem	Regular School	No	Elementary	PK	05	2020	grade_1	118.0	118
234222	SC	school	4501440	1001	Charleston 01	450144000944	1001110	Laurel Hill Primary	Regular School	No	Elementary	PK	02	2020	grade_1	178.0	178
234224	SC	school	4501440	1001	Charleston 01	450144001562	1001112	Pinehurst Elementary	Regular School	No	Elementary	01	05	2020	grade_1	155.0	155
234225	SC	school	4501440	1001	Charleston 01	450144001610	1001113	Montessori Community School	Regular School	No	Elementary	PK	08	2020	grade_1	26.0	26
234226	SC	school	4501440	1001	Charleston 01	450144001611	1001114	N. Charleston Creative Arts Elem	Regular School	No	Elementary	PK	05	2020	grade_1	83.0	83
234229	SC	school	4501440	1001	Charleston 01	450144001690	1001117	Carolina Park Elementary	Regular School	No	Elementary	PK	05	2020	grade_1	156.0	156
234231	SC	school	4501440	1001	Charleston 01	450144001648	1001200	Meeting Street Elementary School	Regular School	No	Elementary	PK	06	2020	grade_1	127.0	127
234232	SC	school	4501440	1001	Charleston 01	450144000838	1001612	Charleston Develop. Charter	Regular School	Yes	Elementary	PK	08	2020	grade_1	21.0	21
234233	SC	school	4501440	1001	Charleston 01	450144000856	1001614	East Cooper Montessori Charter	Regular School	Yes	Elementary	PK	08	2020	grade_1	63.0	63
234236	SC	school	4501440	1001	Charleston 01	450144001457	1001618	Orange Grove Charter	Regular School	Yes	Elementary	PK	08	2020	grade_1	135.0	135
234239	SC	school	4501440	1001	Charleston 01	450144001628	1001629	Carolina Voyager Charter	Regular School	Yes	Elementary	KG	07	2020	grade_1	46.0	46
234244	SC	school	4501500	1101	Cherokee 01	450150000269	1101005	Alma Elem	Regular School	No	Elementary	PK	05	2020	grade_1	35.0	35
234246	SC	school	4501500	1101	Cherokee 01	450150000273	1101009	Corinth Elem	Regular School	No	Elementary	PK	05	2020	grade_1	53.0	53
234247	SC	school	4501500	1101	Cherokee 01	450150000274	1101010	Draytonville Elem	Regular School	No	Elementary	PK	05	2020	grade_1	33.0	33
234248	SC	school	4501500	1101	Cherokee 01	450150000275	1101011	Mary Bramlett Elem	Regular School	No	Elementary	PK	05	2020	grade_1	21.0	21
234249	SC	school	4501500	1101	Cherokee 01	450150000276	1101012	Goucher Elem	Regular School	No	Elementary	PK	05	2020	grade_1	34.0	34
234250	SC	school	4501500	1101	Cherokee 01	450150000278	1101015	B D Lee Elem	Regular School	No	Elementary	PK	05	2020	grade_1	60.0	60
234251	SC	school	4501500	1101	Cherokee 01	450150000282	1101019	Luther L Vaughan Elem	Regular School	No	Elementary	PK	05	2020	grade_1	57.0	57
234252	SC	school	4501500	1101	Cherokee 01	450150001391	1101020	Blacksburg Elem	Regular School	No	Elementary	03	05	2020	grade_1	0.0	0
234253	SC	school	4501500	1101	Cherokee 01	450150000287	1101021	Limestone/Central Elem	Regular School	No	Elementary	PK	05	2020	grade_1	55.0	55
234254	SC	school	4501500	1101	Cherokee 01	450150000296	1101022	Grassy Pond Elem	Regular School	No	Elementary	PK	05	2020	grade_1	72.0	72
234255	SC	school	4501500	1101	Cherokee 01	450150000297	1101023	Northwest Elem	Regular School	No	Elementary	PK	05	2020	grade_1	71.0	71
234257	SC	school	4501500	1101	Cherokee 01	450150000859	1101025	Blacksburg Primary	Regular School	No	Elementary	PK	02	2020	grade_1	113.0	113
234263	SC	school	4501530	1201	Chester 01	450153000291	1201011	Great Falls Elem	Regular School	No	Elementary	PK	05	2020	grade_1	64.0	64
234264	SC	school	4501530	1201	Chester 01	450153000292	1201014	Lewisville Elem	Regular School	No	Elementary	PK	04	2020	grade_1	85.0	85
234265	SC	school	4501530	1201	Chester 01	450153000036	1201018	Chester Park Elem Of Inquiry	Regular School	No	Elementary	PK	05	2020	grade_1	83.0	83
234266	SC	school	4501530	1201	Chester 01	450153001171	1201020	Chester Park Elem Sch for the Arts	Regular School	No	Elementary	PK	05	2020	grade_1	63.0	63
234267	SC	school	4501530	1201	Chester 01	450153001172	1201021	Chester Park Elem Literacy/Tec	Regular School	No	Elementary	PK	05	2020	grade_1	65.0	65
234268	SC	school	4501530	1201	Chester 01	450153001020	1201601	Academy for Teaching Charter	Regular School	Yes	Elementary	KG	08	2020	grade_1	34.0	34
234275	SC	school	4501560	1301	Chesterfield 01	450156000303	1301012	Cheraw Primary	Regular School	No	Elementary	PK	02	2020	grade_1	120.0	120
234276	SC	school	4501560	1301	Chesterfield 01	450156000305	1301014	Edwards Elem	Regular School	No	Elementary	PK	05	2020	grade_1	80.0	80
234277	SC	school	4501560	1301	Chesterfield 01	450156000306	1301015	Jefferson Elem	Regular School	No	Elementary	PK	05	2020	grade_1	46.0	46
234278	SC	school	4501560	1301	Chesterfield 01	450156000307	1301019	Petersburg Primary	Regular School	No	Elementary	PK	02	2020	grade_1	108.0	108
234279	SC	school	4501560	1301	Chesterfield 01	450156000308	1301020	McBee Elem	Regular School	No	Elementary	PK	06	2020	grade_1	76.0	76
234280	SC	school	4501560	1301	Chesterfield 01	450156000309	1301021	Plainview Elem	Regular School	No	Elementary	PK	06	2020	grade_1	21.0	21
234281	SC	school	4501560	1301	Chesterfield 01	450156000310	1301023	Ruby Elem	Regular School	No	Elementary	PK	05	2020	grade_1	43.0	43
234282	SC	school	4501560	1301	Chesterfield 01	450156000170	1301026	Cheraw Intermed	Regular School	No	Elementary	03	05	2020	grade_1	0.0	0
234283	SC	school	4501560	1301	Chesterfield 01	450156000870	1301027	Pageland Elem	Regular School	No	Elementary	03	05	2020	grade_1	0.0	0
234286	SC	school	4501740	1401	Clarendon 01	450174000321	1401005	St. Paul Elem	Regular School	No	Elementary	03	05	2020	grade_1	0.0	0
234288	SC	school	4501740	1401	Clarendon 01	450174001494	1401022	Summerton Early Childhood Ctr	Regular School	No	Elementary	PK	02	2020	grade_1	51.0	51
234291	SC	school	4501770	1402	Clarendon 02	450177000325	1402012	Manning Primary	Regular School	No	Elementary	01	03	2020	grade_1	11.0	11
234293	SC	school	4501770	1402	Clarendon 02	450177000551	1402014	Manning Early Childhood Ctr	Regular School	No	Elementary	PK	01	2020	grade_1	184.0	184
234296	SC	school	4501800	1403	Clarendon 03	450180000329	1403019	Walker-Gamble Elem	Regular School	No	Elementary	PK	05	2020	grade_1	80.0	80
234298	SC	school	4501830	1501	Colleton 01	450183000332	1501006	Bells Elem	Regular School	No	Elementary	PK	05	2020	grade_1	58.0	58
234299	SC	school	4501830	1501	Colleton 01	450183000333	1501008	Black St Early Childhood Ctr	Regular School	No	Elementary	PK	KG	2020	grade_1	0.0	0