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
2008270	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2021	fall	pk_12_total	320.0	152.0	22.0	0.0	0.0	0.0	30.0	263.0	261.0	1.0	372.0	524	320	152	22	0	0	0	30	263	261	1	372	524
2009669	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2021	fall	pre_kindergarten												0												0
1763543	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	extension_academy												0												0
1764940	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	grade_1												0												0
1766337	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	grade_10												0												0
1767734	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	grade_11												0												0
1769131	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	grade_12												0												0
1770528	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	grade_2												0												0
1771925	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	grade_3												0												0
1773322	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	grade_4												0												0
1774719	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	grade_5												0												0
1776116	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	grade_6												80												80
1777513	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	grade_7												80												80
1778910	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	grade_8												86												86
1780307	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	grade_9												0												0
1781704	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	grade_9_transitional												0												0
1783101	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	kindergarten												0												0
1784498	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	pk_12_total	109.0	97.0	21.0	1.0	0.0	0.0	18.0	139.0	107.0	3.0	217.0	246	109	97	21	1	0	0	18	139	107	3	217	246
1785895	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	spring	pre_kindergarten												0												0
1987286	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	extension_academy												0												0
1988685	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	grade_1												0												0
1990084	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	grade_10												0												0
1991483	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	grade_11												0												0
1992882	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	grade_12												0												0
1994281	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	grade_2												0												0
1995680	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	grade_3												0												0
1997079	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	grade_4												0												0
1998478	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	grade_5												0												0
1999877	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	grade_6												85												85
2001276	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	grade_7												84												84
2002675	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	grade_8												90												90
2004074	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	grade_9												0												0
2005473	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	grade_9_transitional												0												0
2006872	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	kindergarten												0												0
2008271	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	pk_12_total	115.0	102.0	22.0	1.0	0.0	0.0	19.0	148.0	111.0	3.0	229.0	259	115	102	22	1	0	0	19	148	111	3	229	259
2009670	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2021	fall	pre_kindergarten												0												0
1763544	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	extension_academy												0												0
1764941	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	grade_1												0												0
1766338	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	grade_10												152												152
1767735	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	grade_11												116												116
1769132	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	grade_12												112												112
1770529	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	grade_2												0												0
1771926	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	grade_3												0												0
1773323	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	grade_4												0												0
1774720	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	grade_5												0												0
1776117	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	grade_6												0												0
1777514	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	grade_7												0												0
1778911	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	grade_8												0												0
1780308	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	grade_9												151												151
1781705	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	grade_9_transitional												5												5
1783102	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	kindergarten												0												0
1784499	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	pk_12_total	259.0	228.0	17.0	0.0	2.0	0.0	30.0	261.0	275.0	3.0	457.0	536	259	228	17	0	2	0	30	261	275	3	457	536
1785896	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	spring	pre_kindergarten												0												0
1987287	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	extension_academy												0												0
1988686	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	grade_1												0												0
1990085	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	grade_10												158												158
1991484	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	grade_11												118												118
1992883	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	grade_12												110												110
1994282	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	grade_2												0												0
1995681	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	grade_3												0												0
1997080	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	grade_4												0												0
1998479	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	grade_5												0												0
1999878	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	grade_6												0												0
2001277	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	grade_7												0												0
2002676	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	grade_8												0												0
2004075	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	grade_9												154												154
2005474	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	grade_9_transitional												6												6
2006873	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	kindergarten												0												0
2008272	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	pk_12_total	263.0	228.0	20.0	0.0	2.0	0.0	33.0	267.0	279.0	4.0	467.0	546	263	228	20	0	2	0	33	267	279	4	467	546
2009671	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2021	fall	pre_kindergarten												0												0
1763545	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	extension_academy												0												0
1764942	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	grade_1												0												0
1766339	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	grade_10												0												0
1767736	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	grade_11												0												0
1769133	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	grade_12												0												0
1770530	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	grade_2												0												0
1771927	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	grade_3												0												0
1773324	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	grade_4												0												0
1774721	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	grade_5												0												0
1776118	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	grade_6												150												150
1777515	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	grade_7												149												149
1778912	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	grade_8												156												156
1780309	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	grade_9												0												0
1781706	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	grade_9_transitional												0												0
1783103	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	kindergarten												0												0
1784500	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	pk_12_total	174.0	231.0	27.0	0.0	2.0	0.0	21.0	228.0	227.0	9.0	420.0	455	174	231	27	0	2	0	21	228	227	9	420	455
1785897	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	spring	pre_kindergarten												0												0
1987288	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	fall	extension_academy												0												0
1988687	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	fall	grade_1												0												0
1990086	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	fall	grade_10												0												0
1991485	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	fall	grade_11												0												0
1992884	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	fall	grade_12												0												0
1994283	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	fall	grade_2												0												0
1995682	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	fall	grade_3												0												0
1997081	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	fall	grade_4												0												0
1998480	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	fall	grade_5												0												0
1999879	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	fall	grade_6												156												156
2001278	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	fall	grade_7												154												154
2002677	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	fall	grade_8												165												165
2004076	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	fall	grade_9												0												0
2005475	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2021	fall	grade_9_transitional												0												0