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 > :p2 or (school = :p2 and rowid > :p1)) order by school, 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
2016627	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2020	fall	grade_12												0												0
2018028	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2020	fall	grade_2												100												100
2019429	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2020	fall	grade_3												101												101
2020830	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2020	fall	grade_4												100												100
2022231	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2020	fall	grade_5												100												100
2023632	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2020	fall	grade_6												100												100
2025033	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2020	fall	grade_7												100												100
2026434	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2020	fall	grade_8												95												95
2027835	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2020	fall	grade_9												0												0
2029236	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2020	fall	grade_9_transitional												0												0
2030637	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2020	fall	kindergarten												100												100
2032038	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2020	fall	pk_12_total	735.0	92.0	36.0	5.0	23.0	0.0	5.0	422.0	474.0	4.0	345.0	896	735	92	36	5	23	0	5	422	474	4	345	896
2033439	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2020	fall	pre_kindergarten												0												0
2285045	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	grade_1												100												100
2286458	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	grade_10												0												0
2287871	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	grade_11												0												0
2289284	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	grade_12												0												0
2290697	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	grade_2												102												102
2292110	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	grade_3												99												99
2293523	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	grade_4												99												99
2294936	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	grade_5												101												101
2296349	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	grade_6												101												101
2297762	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	grade_7												95												95
2299175	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	grade_8												95												95
2300588	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	grade_9												0												0
2302001	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	grade_9_transitional												0												0
2303414	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	kindergarten												100												100
2304827	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	pk_12_total	735.0	89.0	36.0	8.0	18.0	0.0	6.0	418.0	474.0	2.0	367.0	892	735	89	36	8	18	0	6	418	474	2	367	892
2306240	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	spring	pre_kindergarten												0												0
2519404	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	grade_1												99												99
2520821	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	grade_10												0												0
2522238	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	grade_11												0												0
2523655	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	grade_12												0												0
2525072	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	grade_2												100												100
2526489	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	grade_3												99												99
2527906	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	grade_4												99												99
2529323	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	grade_5												101												101
2530740	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	grade_6												102												102
2532157	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	grade_7												97												97
2533574	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	grade_8												94												94
2534991	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	grade_9												0												0
2536408	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	grade_9_transitional												0												0
2537825	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	kindergarten												100												100
2539242	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	pk_12_total	733.0	91.0	36.0	8.0	17.0	0.0	6.0	415.0	476.0	2.0	342.0	891	733	91	36	8	17	0	6	415	476	2	342	891
2540659	LA	school	CHA	Type 2 Charters	W6B001	Acadiana Renaissance Charter Academy	2019	fall	pre_kindergarten												0												0
595363	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	grade_1												0												0
596763	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	grade_10												0												0
598163	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	grade_11												0												0
599563	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	grade_12												0												0
600963	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	grade_2												0												0
602363	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	grade_3												0												0
603763	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	grade_4												0												0
605163	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	grade_5												0												0
606563	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	grade_6												0												0
607963	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	grade_7												0												0
609363	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	grade_8												0												0
610763	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	grade_9												0												0
612163	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	grade_9_transitional												0												0
613563	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	kindergarten												0												0
614963	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	pk_12_total	17.0	34.0	0.0	0.0	0.0	0.0	0.0	38.0	13.0	0.0	48.0	51	17	34	0	0	0	0	0	38	13	0	48	51
616363	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	spring	pre_kindergarten												0												0
1764257	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	extension_academy												0												0
1765654	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	grade_1												0												0
1767051	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	grade_10												0												0
1768448	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	grade_11												0												0
1769845	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	grade_12												0												0
1771242	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	grade_2												0												0
1772639	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	grade_3												0												0
1774036	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	grade_4												0												0
1775433	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	grade_5												0												0
1776830	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	grade_6												0												0
1778227	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	grade_7												0												0
1779624	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	grade_8												0												0
1781021	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	grade_9												0												0
1782418	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	grade_9_transitional												0												0
1783815	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	kindergarten												0												0
1785212	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	pk_12_total	9.0	19.0	0.0	0.0	0.0	0.0	0.0	18.0	10.0	0.0	28.0	28	9	19	0	0	0	0	0	18	10	0	28	28
1786609	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	spring	pre_kindergarten												0												0
1988000	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	extension_academy												0												0
1989399	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	grade_1												0												0
1990798	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	grade_10												0												0
1992197	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	grade_11												0												0
1993596	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	grade_12												0												0
1994995	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	grade_2												0												0
1996394	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	grade_3												0												0
1997793	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	grade_4												0												0
1999192	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	grade_5												0												0
2000591	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	grade_6												0												0
2001990	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	grade_7												0												0
2003389	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	grade_8												0												0
2004788	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	grade_9												0												0
2006187	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	grade_9_transitional												0												0
2007586	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	kindergarten												0												0
2008985	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	pk_12_total	10.0	19.0	0.0	0.0	0.0	0.0	0.0	19.0	10.0	0.0	14.0	29	10	19	0	0	0	0	0	19	10	0	14	29
2010384	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2021	fall	pre_kindergarten												0												0
2011786	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	fall	grade_1												0												0
2013187	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	fall	grade_10												0												0
2014588	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	fall	grade_11												0												0
2015989	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	fall	grade_12												0												0
2017390	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	fall	grade_2												0												0
2018791	LA	school	034	Morehouse Parish	34000	Administrative Services - Special Education	2020	fall	grade_3												0												0