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 school 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	white	black	hispanic	native_american	asian	native_hawaiian_pacific_islander	multiracial	unknown_race	male	female	unknown_gender	low_income	total	white_int	black_int	hispanic_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	unknown_race_int	male_int	female_int	unknown_gender_int	low_income_int	total_int
231732	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													114.0													114
232951	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	kindergarten													120.0													120
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
235389	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	grade_2													104.0													104
236608	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	grade_3													109.0													109
237827	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	grade_4													108.0													108
239046	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	grade_5													110.0													110
240265	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	grade_6													0.0													0
241484	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	grade_7													0.0													0
242703	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	grade_8													0.0													0
243922	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	grade_9													0.0													0
245141	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	grade_10													0.0													0
246360	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	grade_11													0.0													0
247579	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	grade_12													0.0													0
248798	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2020	pk_12_total	127.0	508.0	103.0	1.0	9.0	6.0	34.0	0.0	398.0	390.0	0.0	614.0	788.0	127	508	103	1	9	6	34	0	398	390	0	614	788
368010	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	pre_kindergarten													53.0													53
369230	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	kindergarten													106.0													106
370450	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	grade_1													109.0													109
371670	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	grade_2													105.0													105
372890	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	grade_3													104.0													104
374110	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	grade_4													98.0													98
375330	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	grade_5													117.0													117
376550	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	grade_6													0.0													0
377770	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	grade_7													0.0													0
378990	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	grade_8													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
381430	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	grade_10													0.0													0
382650	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	grade_11													0.0													0
383870	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	grade_12													0.0													0
385090	SC	school	4501440	1001	Charleston 01	450144000199	1001036	A C Corcoran Elem	Regular School	No	Elementary	PK	05	2021	pk_12_total	94.0	453.0	107.0	1.0	8.0	1.0	28.0	0.0	342.0	350.0	0.0	566.0	692.0	94	453	107	1	8	1	28	0	342	350	0	566	692
232437	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													36.0													36
233656	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	kindergarten													37.0													37
234875	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	grade_1													36.0													36
236094	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	grade_2													37.0													37
237313	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	grade_3													42.0													42
238532	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	grade_4													24.0													24
239751	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	grade_5													49.0													49
240970	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	grade_6													0.0													0
242189	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	grade_7													0.0													0
243408	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	grade_8													0.0													0
244627	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	grade_9													0.0													0
245846	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	grade_10													0.0													0
247065	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	grade_11													0.0													0
248284	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	grade_12													0.0													0
249503	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2020	pk_12_total	109.0	88.0	39.0	0.0	15.0	0.0	10.0	0.0	138.0	123.0	0.0	149.0	261.0	109	88	39	0	15	0	10	0	138	123	0	149	261
368711	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	pre_kindergarten													12.0													12
369931	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	kindergarten													28.0													28
371151	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_1													32.0													32
372371	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_2													33.0													33
373591	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_3													31.0													31
374811	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_4													32.0													32
376031	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_5													23.0													23
377251	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_6													0.0													0
378471	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_7													0.0													0
379691	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_8													0.0													0
380911	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_9													0.0													0
382131	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_10													0.0													0
383351	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_11													0.0													0
384571	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	grade_12													0.0													0
385791	SC	school	4503360	4001	Richland 01	450336000926	4001048	A C Moore Elem	Regular School	No	Elementary	PK	05	2021	pk_12_total	84.0	54.0	29.0	0.0	12.0	0.0	12.0	0.0	97.0	94.0	0.0	113.0	191.0	84	54	29	0	12	0	12	0	97	94	0	113	191
232429	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													46.0													46
233648	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	kindergarten													51.0													51
234867	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	grade_1													50.0													50
236086	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	grade_2													54.0													54
237305	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	grade_3													54.0													54
238524	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	grade_4													45.0													45
239743	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	grade_5													58.0													58
240962	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	grade_6													0.0													0
242181	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	grade_7													0.0													0
243400	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	grade_8													0.0													0
244619	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	grade_9													0.0													0
245838	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	grade_10													0.0													0
247057	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	grade_11													0.0													0
248276	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	grade_12													0.0													0
249495	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2020	pk_12_total	3.0	330.0	7.0	0.0	1.0	0.0	17.0	0.0	175.0	183.0	0.0	312.0	358.0	3	330	7	0	1	0	17	0	175	183	0	312	358
368703	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	pre_kindergarten													29.0													29
369923	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	kindergarten													52.0													52
371143	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	grade_1													51.0													51
372363	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	grade_2													48.0													48
373583	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	grade_3													52.0													52
374803	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	grade_4													46.0													46
376023	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	grade_5													46.0													46
377243	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	grade_6													0.0													0
378463	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	grade_7													0.0													0
379683	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	grade_8													0.0													0
380903	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	grade_9													0.0													0
382123	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	grade_10													0.0													0
383343	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	grade_11													0.0													0
384563	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	grade_12													0.0													0
385783	SC	school	4503360	4001	Richland 01	450336000919	4001038	A J Lewis Greenview Elem	Regular School	No	Elementary	PK	05	2021	pk_12_total	2.0	298.0	13.0	0.0	0.0	0.0	11.0	0.0	156.0	168.0	0.0	281.0	324.0	2	298	13	0	0	0	11	0	156	168	0	281	324
232082	SC	school	4502310	2301	Greenville 01	450231001551	2301119	A J Whittenburg Elem	Regular School	No	Elementary	PK	05	2020	pre_kindergarten													42.0													42
233301	SC	school	4502310	2301	Greenville 01	450231001551	2301119	A J Whittenburg Elem	Regular School	No	Elementary	PK	05	2020	kindergarten													80.0													80
234520	SC	school	4502310	2301	Greenville 01	450231001551	2301119	A J Whittenburg Elem	Regular School	No	Elementary	PK	05	2020	grade_1													79.0													79
235739	SC	school	4502310	2301	Greenville 01	450231001551	2301119	A J Whittenburg Elem	Regular School	No	Elementary	PK	05	2020	grade_2													73.0													73
236958	SC	school	4502310	2301	Greenville 01	450231001551	2301119	A J Whittenburg Elem	Regular School	No	Elementary	PK	05	2020	grade_3													73.0													73
238177	SC	school	4502310	2301	Greenville 01	450231001551	2301119	A J Whittenburg Elem	Regular School	No	Elementary	PK	05	2020	grade_4													89.0													89
239396	SC	school	4502310	2301	Greenville 01	450231001551	2301119	A J Whittenburg Elem	Regular School	No	Elementary	PK	05	2020	grade_5													75.0													75
240615	SC	school	4502310	2301	Greenville 01	450231001551	2301119	A J Whittenburg Elem	Regular School	No	Elementary	PK	05	2020	grade_6													0.0													0
241834	SC	school	4502310	2301	Greenville 01	450231001551	2301119	A J Whittenburg Elem	Regular School	No	Elementary	PK	05	2020	grade_7													0.0													0
243053	SC	school	4502310	2301	Greenville 01	450231001551	2301119	A J Whittenburg Elem	Regular School	No	Elementary	PK	05	2020	grade_8													0.0													0
244272	SC	school	4502310	2301	Greenville 01	450231001551	2301119	A J Whittenburg Elem	Regular School	No	Elementary	PK	05	2020	grade_9													0.0													0