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 "year" = :p1 and (school_state_id > :p3 or (school_state_id = :p3 and rowid > :p2)) order by school_state_id, 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	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
600246	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	spring	grade_2												0												0
601646	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	spring	grade_3												0												0
603046	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	spring	grade_4												0												0
604446	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	spring	grade_5												0												0
605846	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	spring	grade_6												84												84
607246	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	spring	grade_7												92												92
608646	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	spring	grade_8												85												85
610046	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	spring	grade_9												0												0
611446	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	spring	grade_9_transitional												0												0
612846	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	spring	kindergarten												0												0
614246	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	spring	pk_12_total	104.0	120.0	20.0	1.0	0.0	0.0	16.0	121.0	140.0	2.0	218.0	261	104	120	20	1	0	0	16	121	140	2	218	261
615646	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	spring	pre_kindergarten												0												0
2011069	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	grade_1												0												0
2012470	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	grade_10												0												0
2013871	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	grade_11												0												0
2015272	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	grade_12												0												0
2016673	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	grade_2												0												0
2018074	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	grade_3												0												0
2019475	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	grade_4												0												0
2020876	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	grade_5												0												0
2022277	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	grade_6												90												90
2023678	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	grade_7												91												91
2025079	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	grade_8												88												88
2026480	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	grade_9												0												0
2027881	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	grade_9_transitional												0												0
2029282	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	kindergarten												0												0
2030683	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	pk_12_total	108.0	122.0	19.0	1.0	0.0	0.0	19.0	126.0	143.0	2.0	222.0	269	108	122	19	1	0	0	19	126	143	2	222	269
2032084	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2020	fall	pre_kindergarten												0												0
594647	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	grade_1												0												0
596047	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	grade_10												146												146
597447	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	grade_11												104												104
598847	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	grade_12												158												158
600247	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	grade_2												0												0
601647	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	grade_3												0												0
603047	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	grade_4												0												0
604447	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	grade_5												0												0
605847	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	grade_6												0												0
607247	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	grade_7												0												0
608647	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	grade_8												0												0
610047	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	grade_9												132												132
611447	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	grade_9_transitional												47												47
612847	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	kindergarten												0												0
614247	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	pk_12_total	281.0	250.0	22.0	1.0	1.0	0.0	32.0	293.0	293.99999999999994	8.0	479.0	587	281	250	22	1	1	0	32	293		8	479	587
615647	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	spring	pre_kindergarten												0												0
2011070	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	grade_1												0												0
2012471	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	grade_10												153												153
2013872	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	grade_11												102												102
2015273	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	grade_12												160												160
2016674	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	grade_2												0												0
2018075	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	grade_3												0												0
2019476	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	grade_4												0												0
2020877	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	grade_5												0												0
2022278	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	grade_6												0												0
2023679	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	grade_7												0												0
2025080	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	grade_8												0												0
2026481	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	grade_9												138												138
2027882	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	grade_9_transitional												53												53
2029283	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	kindergarten												0												0
2030684	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	pk_12_total	281.0	267.0	24.0	1.0	1.0	0.0	32.0	300.0	306.0	9.999999999999998	481.0	606	281	267	24	1	1	0	32	300	306		481	606
2032085	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2020	fall	pre_kindergarten												0												0
594648	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	grade_1												0												0
596048	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	grade_10												0												0
597448	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	grade_11												0												0
598848	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	grade_12												0												0
600248	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	grade_2												0												0
601648	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	grade_3												0												0
603048	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	grade_4												0												0
604448	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	grade_5												0												0
605848	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	grade_6												171												171
607248	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	grade_7												167												167
608648	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	grade_8												145												145
610048	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	grade_9												0												0
611448	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	grade_9_transitional												0												0
612848	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	kindergarten												0												0
614248	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	pk_12_total	189.0	244.0	24.0	0.0	3.0	0.0	23.0	249.0	234.0	9.0	431.0	483	189	244	24	0	3	0	23	249	234	9	431	483
615648	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	spring	pre_kindergarten												0												0
2011071	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	grade_1												0												0
2012472	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	grade_10												0												0
2013873	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	grade_11												0												0
2015274	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	grade_12												0												0
2016675	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	grade_2												0												0
2018076	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	grade_3												0												0
2019477	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	grade_4												0												0
2020878	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	grade_5												0												0
2022279	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	grade_6												177												177
2023680	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	grade_7												169												169
2025081	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	grade_8												144												144
2026482	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	grade_9												0												0
2027883	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	grade_9_transitional												0												0
2029284	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	kindergarten												0												0
2030685	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	pk_12_total	194.0	245.0	26.0	0.0	3.0	0.0	22.0	251.00000000000003	239.0	11.0	422.0	490	194	245	26	0	3	0	22		239	11	422	490
2032086	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2020	fall	pre_kindergarten												0												0
594649	LA	school	2200030	001	Acadia Parish	220003000008	1009	Crowley Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_1												0												0
596049	LA	school	2200030	001	Acadia Parish	220003000008	1009	Crowley Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_10												0												0
597449	LA	school	2200030	001	Acadia Parish	220003000008	1009	Crowley Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_11												0												0
598849	LA	school	2200030	001	Acadia Parish	220003000008	1009	Crowley Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_12												0												0
600249	LA	school	2200030	001	Acadia Parish	220003000008	1009	Crowley Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_2												0												0
601649	LA	school	2200030	001	Acadia Parish	220003000008	1009	Crowley Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_3												0												0
603049	LA	school	2200030	001	Acadia Parish	220003000008	1009	Crowley Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_4												0												0
604449	LA	school	2200030	001	Acadia Parish	220003000008	1009	Crowley Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_5												0												0
605849	LA	school	2200030	001	Acadia Parish	220003000008	1009	Crowley Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_6												0												0