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_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
1994751	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	grade_2												62												62
1996150	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	grade_3												71												71
1997549	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	grade_4												74												74
1998948	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	grade_5												66												66
2000347	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	grade_6												65												65
2001746	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	grade_7												69												69
2003145	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	grade_8												64												64
2004544	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	grade_9												0												0
2005943	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	grade_9_transitional												0												0
2007342	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	kindergarten												64												64
2008741	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	pk_12_total	92.0	82.0	436.0	0.0	18.0	0.0	14.0	315.0	327.0	221.0	578.0	642	92	82	436	0	18	0	14	315	327	221	578	642
2010140	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	pre_kindergarten												35												35
2011538	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	grade_1												64												64
2012939	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	grade_10												0												0
2014340	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	grade_11												0												0
2015741	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	grade_12												0												0
2017142	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	grade_2												77												77
2018543	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	grade_3												78												78
2019944	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	grade_4												71												71
2021345	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	grade_5												66												66
2022746	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	grade_6												56												56
2024147	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	grade_7												63												63
2025548	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	grade_8												46												46
2026949	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	grade_9												0												0
2028350	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	grade_9_transitional												0												0
2029751	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	kindergarten												62												62
2031152	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	pk_12_total	99.0	97.0	404.0	0.0	8.0	0.0	15.0	310.0	313.0	195.0	520.0	623	99	97	404	0	8	0	15	310	313	195	520	623
2032553	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	fall	pre_kindergarten												40												40
594825	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	grade_1												74												74
596225	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	grade_10												0												0
597625	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	grade_11												0												0
599025	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	grade_12												0												0
600425	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	grade_2												80												80
601825	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	grade_3												81												81
603225	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	grade_4												71												71
604625	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	grade_5												72												72
606025	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	grade_6												0												0
607425	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	grade_7												0												0
608825	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	grade_8												0												0
610225	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	grade_9												0												0
611625	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	grade_9_transitional												0												0
613025	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	kindergarten												60												60
614425	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	pk_12_total	313.0	101.0	21.0	1.0	2.0	0.0	20.0	238.0	220.0	8.0	222.0	458	313	101	21	1	2	0	20	238	220	8	222	458
615825	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	spring	pre_kindergarten												20												20
1763723	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	extension_academy												0												0
1765120	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	grade_1												65												65
1766517	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	grade_10												0												0
1767914	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	grade_11												0												0
1769311	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	grade_12												0												0
1770708	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	grade_2												68												68
1772105	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	grade_3												79												79
1773502	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	grade_4												75												75
1774899	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	grade_5												64												64
1776296	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	grade_6												0												0
1777693	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	grade_7												0												0
1779090	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	grade_8												0												0
1780487	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	grade_9												0												0
1781884	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	grade_9_transitional												0												0
1783281	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	kindergarten												63												63
1784678	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	pk_12_total	286.0	96.0	30.0	1.0	0.0	0.0	21.0	210.0	224.0	10.0	230.00000000000003	434	286	96	30	1	0	0	21	210	224	10		434
1786075	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	spring	pre_kindergarten												19												19
1987466	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	extension_academy												0												0
1988865	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	grade_1												62												62
1990264	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	grade_10												0												0
1991663	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	grade_11												0												0
1993062	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	grade_12												0												0
1994461	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	grade_2												71												71
1995860	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	grade_3												79												79
1997259	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	grade_4												77												77
1998658	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	grade_5												68												68
2000057	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	grade_6												0												0
2001456	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	grade_7												0												0
2002855	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	grade_8												0												0
2004254	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	grade_9												0												0
2005653	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	grade_9_transitional												0												0
2007052	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	kindergarten												63												63
2008451	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	pk_12_total	287.0	105.0	28.0	1.0	0.0	0.0	19.0	214.0	226.0	10.0	241.0	440	287	105	28	1	0	0	19	214	226	10	241	440
2009850	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2021	fall	pre_kindergarten												19												19
2011248	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	grade_1												74												74
2012649	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	grade_10												0												0
2014050	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	grade_11												0												0
2015451	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	grade_12												0												0
2016852	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	grade_2												80												80
2018253	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	grade_3												79												79
2019654	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	grade_4												70												70
2021055	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	grade_5												74												74
2022456	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	grade_6												0												0
2023857	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	grade_7												0												0
2025258	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	grade_8												0												0
2026659	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	grade_9												0												0
2028060	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	grade_9_transitional												0												0
2029461	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	kindergarten												56												56
2030862	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	pk_12_total	310.0	100.0	22.0	1.0	2.0	0.0	18.0	236.0	217.0	5.0	204.0	453	310	100	22	1	2	0	18	236	217	5	204	453
2032263	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2020	fall	pre_kindergarten												20												20
2283851	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_1												80												80
2285264	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_10												0												0
2286677	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_11												0												0
2288090	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_12												0												0
2289503	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_2												79												79
2290916	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_3												69												69
2292329	LA	school	2200300	009	Caddo Parish	220030000198	9060	A.C. Steere Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_4												72												72