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 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	term	grade	white	black	hispanic	native_american	asian	native_hawaiian_pacific_islander	multiracial	male	female	ell	low_income	total	white_int	black_int	hispanic_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	male_int	female_int	ell_int	low_income_int	total_int
2284550	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	grade_1												0												0
2285963	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	grade_10												50												50
2287376	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	grade_11												50												50
2288789	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	grade_12												33												33
2290202	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	grade_2												0												0
2291615	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	grade_3												0												0
2293028	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	grade_4												0												0
2294441	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	grade_5												0												0
2295854	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	grade_6												0												0
2297267	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	grade_7												57												57
2298680	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	grade_8												68												68
2300093	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	grade_9												65												65
2301506	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	grade_9_transitional												0												0
2302919	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	kindergarten												0												0
2304332	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	pk_12_total	49.0	102.0	10.0	105.0	0.0	0.0	57.0	166.00000000000003	157.0	1.0	277.0	323	49	102	10	105	0	0	57		157	1	277	323
2305745	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	spring	pre_kindergarten												0												0
2518907	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	grade_1												0												0
2520324	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	grade_10												52												52
2521741	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	grade_11												47												47
2523158	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	grade_12												33												33
2524575	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	grade_2												0												0
2525992	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	grade_3												0												0
2527409	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	grade_4												0												0
2528826	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	grade_5												0												0
2530243	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	grade_6												0												0
2531660	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	grade_7												57												57
2533077	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	grade_8												67												67
2534494	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	grade_9												65												65
2535911	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	grade_9_transitional												0												0
2537328	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	kindergarten												0												0
2538745	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	pk_12_total	50.0	101.0	10.0	104.0	0.0	0.0	56.0	163.99999999999997	157.0	1.0	274.0	321	50	101	10	104	0	0	56		157	1	274	321
2540162	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2019	fall	pre_kindergarten												0												0
595520	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	grade_1												0												0
596920	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	grade_10												60												60
598320	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	grade_11												47												47
599720	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	grade_12												27												27
601120	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	grade_2												0												0
602520	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	grade_3												0												0
603920	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	grade_4												0												0
605320	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	grade_5												0												0
606720	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	grade_6												0												0
608120	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	grade_7												61												61
609520	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	grade_8												53												53
610920	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	grade_9												56												56
612320	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	grade_9_transitional												0												0
613720	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	kindergarten												0												0
615120	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	pk_12_total	42.0	83.0	11.0	107.0	0.0	0.0	61.0	162.0	142.0	1.0	266.0	304	42	83	11	107	0	0	61	162	142	1	266	304
616520	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	spring	pre_kindergarten												0												0
2011943	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	grade_1												0												0
2013344	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	grade_10												60												60
2014745	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	grade_11												47												47
2016146	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	grade_12												28												28
2017547	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	grade_2												0												0
2018948	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	grade_3												0												0
2020349	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	grade_4												0												0
2021750	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	grade_5												0												0
2023151	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	grade_6												0												0
2024552	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	grade_7												60												60
2025953	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	grade_8												55												55
2027354	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	grade_9												59												59
2028755	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	grade_9_transitional												0												0
2030156	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	kindergarten												0												0
2031557	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	pk_12_total	44.0	86.0	11.0	108.0	0.0	0.0	60.0	161.0	148.0	2.0	269.0	309	44	86	11	108	0	0	60	161	148	2	269	309
2032958	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2020	fall	pre_kindergarten												0												0
1764405	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	extension_academy												0												0
1765802	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	grade_1												0												0
1767199	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	grade_10												58												58
1768596	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	grade_11												59												59
1769993	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	grade_12												37												37
1771390	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	grade_2												0												0
1772787	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	grade_3												0												0
1774184	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	grade_4												0												0
1775581	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	grade_5												0												0
1776978	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	grade_6												0												0
1778375	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	grade_7												74												74
1779772	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	grade_8												61												61
1781169	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	grade_9												54												54
1782566	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	grade_9_transitional												0												0
1783963	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	kindergarten												0												0
1785360	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	pk_12_total	40.0	95.0	16.0	122.0	0.0	0.0	70.0	173.0	170.0	3.0	303.0	343	40	95	16	122	0	0	70	173	170	3	303	343
1786757	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	spring	pre_kindergarten												0												0
1988158	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	extension_academy												0												0
1989557	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	grade_1												0												0
1990956	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	grade_10												59												59
1992355	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	grade_11												59												59
1993754	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	grade_12												36												36
1995153	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	grade_2												0												0
1996552	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	grade_3												0												0
1997951	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	grade_4												0												0
1999350	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	grade_5												0												0
2000749	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	grade_6												0												0
2002148	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	grade_7												76												76
2003547	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	grade_8												63												63
2004946	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	grade_9												54												54
2006345	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	grade_9_transitional												0												0
2007744	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	kindergarten												0												0
2009143	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	pk_12_total	42.0	98.0	16.0	120.0	0.0	0.0	71.0	178.0	169.0	3.0000000000000004	307.0	347	42	98	16	120	0	0	71	178	169		307	347
2010542	LA	school	2201380	043	Sabine Parish	220138001118	43012	Zwolle High School	Regular School	No	High	07	12	2021	fall	pre_kindergarten												0												0
2284549	LA	school	2201380	043	Sabine Parish	220138001117	43011	Zwolle Elementary School	Regular School	No	Elementary	PK	06	2019	spring	grade_1												65												65
2285962	LA	school	2201380	043	Sabine Parish	220138001117	43011	Zwolle Elementary School	Regular School	No	Elementary	PK	06	2019	spring	grade_10												0												0
2287375	LA	school	2201380	043	Sabine Parish	220138001117	43011	Zwolle Elementary School	Regular School	No	Elementary	PK	06	2019	spring	grade_11												0												0