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 and (school_state_id < :p2 or school_state_id is null or (school_state_id = :p2 and rowid > :p1)) order by school_state_id desc, rowid limit 101

Query parameters

This data as json, CSV

rowid	state	admin_level	district_state_id	district	school_state_id	school	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
596039	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	grade_1												0												0
597439	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	grade_10												153												153
598839	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	grade_11												113												113
600239	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	grade_12												0												0
601639	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	grade_2												0												0
603039	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	grade_3												0												0
604439	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	grade_4												0												0
605839	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	grade_5												0												0
607239	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	grade_6												0												0
608639	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	grade_7												0												0
610039	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	grade_8												0												0
611439	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	grade_9												133												133
612839	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	grade_9_transitional												0												0
614239	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	kindergarten												0												0
615639	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	pk_12_total	6.0	369.0	10.0	13.0	1.0	0.0	0.0	193.0	206.0	10.0	368.0	399	6	369	10	13	1	0	0	193	206	10	368	399
617039	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	spring	pre_kindergarten												0												0
1764849	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	extension_academy												0												0
1766246	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	grade_1												0												0
1767643	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	grade_10												107												107
1769040	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	grade_11												145												145
1770437	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	grade_12												108												108
1771834	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	grade_2												0												0
1773231	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	grade_3												0												0
1774628	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	grade_4												0												0
1776025	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	grade_5												0												0
1777422	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	grade_6												0												0
1778819	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	grade_7												0												0
1780216	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	grade_8												0												0
1781613	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	grade_9												102												102
1783010	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	grade_9_transitional												0												0
1784407	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	kindergarten												0												0
1785804	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	pk_12_total	7.0	437.0	7.0	9.0	1.0	0.0	1.0	231.0	231.0	5.0	426.0	462	7	437	7	9	1	0	1	231	231	5	426	462
1787201	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	spring	pre_kindergarten												0												0
1988676	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	extension_academy												0												0
1990075	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	grade_1												0												0
1991474	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	grade_10												121												121
1992873	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	grade_11												152												152
1994272	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	grade_12												109												109
1995671	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	grade_2												0												0
1997070	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	grade_3												0												0
1998469	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	grade_4												0												0
1999868	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	grade_5												0												0
2001267	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	grade_6												0												0
2002666	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	grade_7												0												0
2004065	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	grade_8												0												0
2005464	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	grade_9												99												99
2006863	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	grade_9_transitional												0												0
2008262	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	kindergarten												0												0
2009661	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	pk_12_total	9.0	453.0	7.0	10.0	1.0	0.0	1.0	248.0	233.0	5.0	444.0	481	9	453	7	10	1	0	1	248	233	5	444	481
2011060	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2021	fall	pre_kindergarten												0												0
2012463	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	grade_1												0												0
2013864	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	grade_10												158												158
2015265	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	grade_11												122												122
2016666	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	grade_12												0												0
2018067	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	grade_2												0												0
2019468	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	grade_3												0												0
2020869	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	grade_4												0												0
2022270	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	grade_5												0												0
2023671	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	grade_6												0												0
2025072	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	grade_7												0												0
2026473	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	grade_8												0												0
2027874	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	grade_9												139												139
2029275	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	grade_9_transitional												0												0
2030676	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	kindergarten												0												0
2032077	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	pk_12_total	6.0	383.0	14.0	14.0	2.0	0.0	0.0	212.0	207.0	13.0	378.0	419	6	383	14	14	2	0	0	212	207	13	378	419
2033478	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2020	fall	pre_kindergarten												0												0
2285080	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	grade_1												0												0
2286493	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	grade_10												113												113
2287906	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	grade_11												0												0
2289319	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	grade_12												0												0
2290732	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	grade_2												0												0
2292145	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	grade_3												0												0
2293558	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	grade_4												0												0
2294971	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	grade_5												0												0
2296384	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	grade_6												0												0
2297797	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	grade_7												0												0
2299210	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	grade_8												0												0
2300623	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	grade_9												137												137
2302036	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	grade_9_transitional												1												1
2303449	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	kindergarten												0												0
2304862	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	pk_12_total	5.0	244.0	2.0	0.0	0.0	0.0	0.0	122.0	129.0	1.0	224.0	251	5	244	2	0	0	0	0	122	129	1	224	251
2306275	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	spring	pre_kindergarten												0												0
2519439	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	grade_1												0												0
2520856	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	grade_10												122												122
2522273	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	grade_11												0												0
2523690	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	grade_12												0												0
2525107	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	grade_2												0												0
2526524	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	grade_3												0												0
2527941	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	grade_4												0												0
2529358	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	grade_5												0												0
2530775	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	grade_6												0												0
2532192	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	grade_7												0												0
2533609	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	grade_8												0												0
2535026	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	grade_9												152												152
2536443	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	grade_9_transitional												1												1
2537860	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	kindergarten												0												0
2539277	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	pk_12_total	7.0	263.0	5.0	0.0	0.0	0.0	0.0	137.0	138.0	1.0	246.0	275	7	263	5	0	0	0	0	137	138	1	246	275
2540694	LA	school	CHA	Type 2 Charters	WJ5001	Collegiate Baton Rouge	2019	fall	pre_kindergarten												0												0
596038	LA	school	R36	Orleans Parish	WC3001	IDEA Oscar Dunn	2020	spring	grade_1												27												27
597438	LA	school	R36	Orleans Parish	WC3001	IDEA Oscar Dunn	2020	spring	grade_10												0												0
598838	LA	school	R36	Orleans Parish	WC3001	IDEA Oscar Dunn	2020	spring	grade_11												0												0