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
2287161	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	spring	grade_11												0												0
2288574	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	spring	grade_12												0												0
2289987	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	spring	grade_2												52												52
2291400	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	spring	grade_3												53												53
2292813	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	spring	grade_4												52												52
2294226	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	spring	grade_5												34												34
2295639	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	spring	grade_6												53												53
2297052	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	spring	grade_7												34												34
2298465	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	spring	grade_8												32												32
2299878	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	spring	grade_9												0												0
2301291	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	spring	grade_9_transitional												0												0
2302704	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	spring	kindergarten												50												50
2304117	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	spring	pk_12_total	290.0	106.0	3.0	1.0	7.0	0.0	6.0	202.0	211.0	0.0	53.0	413	290	106	3	1	7	0	6	202	211	0	53	413
2305530	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	spring	pre_kindergarten												0												0
2518690	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	grade_1												53												53
2520107	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	grade_10												0												0
2521524	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	grade_11												0												0
2522941	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	grade_12												0												0
2524358	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	grade_2												52												52
2525775	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	grade_3												53												53
2527192	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	grade_4												52												52
2528609	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	grade_5												34												34
2530026	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	grade_6												54												54
2531443	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	grade_7												34												34
2532860	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	grade_8												32												32
2534277	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	grade_9												0												0
2535694	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	grade_9_transitional												0												0
2537111	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	kindergarten												50												50
2538528	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	pk_12_total	291.0	106.0	3.0	1.0	7.0	0.0	6.0	203.0	211.00000000000003	0.0	46.0	414	291	106	3	1	7	0	6	203		0	46	414
2539945	LA	school		031	Lincoln Parish		31011	A. E. Phillips Laboratory School						2019	fall	pre_kindergarten												0												0
2284148	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_1												85												85
2285561	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_10												0												0
2286974	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_11												0												0
2288387	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_12												0												0
2289800	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_2												86												86
2291213	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_3												72												72
2292626	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_4												76												76
2294039	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_5												81												81
2295452	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_6												0												0
2296865	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_7												0												0
2298278	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_8												0												0
2299691	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_9												0												0
2301104	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_9_transitional												0												0
2302517	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	kindergarten												66												66
2303930	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	pk_12_total	80.0	76.0	330.0	0.0	7.0	0.0	13.0	257.0	249.0	195.0	441.0	506	80	76	330	0	7	0	13	257	249	195	441	506
2305343	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	spring	pre_kindergarten												37												37
2518503	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	grade_1												86												86
2519920	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	grade_10												0												0
2521337	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	grade_11												0												0
2522754	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	grade_12												0												0
2524171	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	grade_2												88												88
2525588	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	grade_3												72												72
2527005	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	grade_4												78												78
2528422	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	grade_5												78												78
2529839	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	grade_6												0												0
2531256	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	grade_7												0												0
2532673	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	grade_8												0												0
2534090	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	grade_9												0												0
2535507	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	grade_9_transitional												0												0
2536924	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	kindergarten												68												68
2538341	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	pk_12_total	83.0	84.0	324.0	0.0	7.0	0.0	12.0	256.0	254.0	181.0	435.0	510	83	84	324	0	7	0	12	256	254	181	435	510
2539758	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander Elementary School	Regular School	No	Elementary	PK	05	2019	fall	pre_kindergarten												37												37
595115	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	grade_1												64												64
596515	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	grade_10												0												0
597915	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	grade_11												0												0
599315	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	grade_12												0												0
600715	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	grade_2												78												78
602115	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	grade_3												77												77
603515	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	grade_4												71												71
604915	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	grade_5												66												66
606315	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	grade_6												62												62
607715	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	grade_7												60												60
609115	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	grade_8												48												48
610515	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	grade_9												0												0
611915	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	grade_9_transitional												0												0
613315	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	kindergarten												65												65
614715	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	pk_12_total	101.0	94.0	411.0	0.0	8.0	0.0	15.0	319.0	310.0	209.0	543.0	629	101	94	411	0	8	0	15	319	310	209	543	629
616115	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2020	spring	pre_kindergarten												38												38
1764013	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	extension_academy												0												0
1765410	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	grade_1												68												68
1766807	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	grade_10												0												0
1768204	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	grade_11												0												0
1769601	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	grade_12												0												0
1770998	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	grade_2												60												60
1772395	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	grade_3												71												71
1773792	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	grade_4												73												73
1775189	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	grade_5												63												63
1776586	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	grade_6												64												64
1777983	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	grade_7												69												69
1779380	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	grade_8												65												65
1780777	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	grade_9												0												0
1782174	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	grade_9_transitional												0												0
1783571	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	kindergarten												64												64
1784968	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	pk_12_total	91.0	93.0	417.0	0.0	17.0	0.0	14.0	309.0	322.99999999999994	211.0	562.0	632	91	93	417	0	17	0	14	309		211	562	632
1786365	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	spring	pre_kindergarten												32												32
1987756	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	extension_academy												0												0
1989155	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	grade_1												69												69
1990554	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	grade_10												0												0
1991953	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	grade_11												0												0
1993352	LA	school	2200840	026	Jefferson Parish	220084000578	26003	A.C. Alexander School	Regular School	No	Elementary	PK	08	2021	fall	grade_12												0												0
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