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 (district_nces_id > :p2 or (district_nces_id = :p2 and rowid > :p1)) order by district_nces_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
2286370	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	spring	grade_10												13												13
2286371	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	spring	grade_10												9												9
2287783	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	spring	grade_11												19												19
2287784	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	spring	grade_11												5												5
2289196	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	spring	grade_12												19												19
2289197	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	spring	grade_12												8												8
2290609	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	spring	grade_2												10												10
2290610	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	spring	grade_2												6												6
2292022	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	spring	grade_3												6												6
2292023	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	spring	grade_3												2												2
2293435	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	spring	grade_4												10												10
2293436	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	spring	grade_4												1												1
2294848	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	spring	grade_5												8												8
2294849	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	spring	grade_5												5												5
2296261	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	spring	grade_6												6												6
2296262	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	spring	grade_6												1												1
2297674	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	spring	grade_7												12												12
2297675	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	spring	grade_7												3												3
2299087	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	spring	grade_8												7												7
2299088	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	spring	grade_8												7												7
2300500	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	spring	grade_9												5												5
2300501	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	spring	grade_9												10												10
2301913	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	spring	grade_9_transitional												10												10
2301914	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	spring	grade_9_transitional												3												3
2303326	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	spring	kindergarten												0												0
2303327	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	spring	kindergarten												2												2
2304739	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	spring	pk_12_total	35.0	91.0	11.0	1.0	0.0	0.0	2.0	73.0	67.0	1.0	136.0	140	35	91	11	1	0	0	2	73	67	1	136	140
2304740	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	spring	pk_12_total	28.0	36.0	6.0	0.0	1.0	0.0	2.0	43.0	30.0	3.0	70.0	73	28	36	6	0	1	0	2	43	30	3	70	73
2306152	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	spring	pre_kindergarten												0												0
2306153	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	spring	pre_kindergarten												0												0
2519315	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	grade_1												8												8
2519316	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	grade_1												7												7
2520732	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	grade_10												13												13
2520733	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	grade_10												8												8
2522149	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	grade_11												19												19
2522150	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	grade_11												5												5
2523566	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	grade_12												19												19
2523567	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	grade_12												8												8
2524983	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	grade_2												9												9
2524984	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	grade_2												5												5
2526400	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	grade_3												7												7
2526401	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	grade_3												2												2
2527817	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	grade_4												11												11
2527818	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	grade_4												1												1
2529234	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	grade_5												6												6
2529235	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	grade_5												6												6
2530651	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	grade_6												5												5
2530652	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	grade_6												1												1
2532068	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	grade_7												10												10
2532069	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	grade_7												3												3
2533485	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	grade_8												7												7
2533486	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	grade_8												7												7
2534902	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	grade_9												4												4
2534903	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	grade_9												9												9
2536319	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	grade_9_transitional												10												10
2536320	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	grade_9_transitional												3												3
2537736	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	kindergarten												0												0
2537737	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	kindergarten												2												2
2539153	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	pk_12_total	34.0	86.0	11.0	1.0	0.0	0.0	2.0	71.0	63.0	1.0	132.0	134	34	86	11	1	0	0	2	71	63	1	132	134
2539154	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	pk_12_total	26.0	35.0	6.0	0.0	1.0	0.0	1.0	40.0	29.0	3.0	66.0	69	26	35	6	0	1	0	1	40	29	3	66	69
2540570	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001801789	304001	Louisiana School for the Deaf	Special Education School	No	Other	PK	12	2019	fall	pre_kindergarten												0												0
2540571	LA	school	2200018	304	LA Schools for the Deaf and Visually Impaired	220001800193	304002	Louisiana School for the Visually Impaired	Special Education School	No	Other	PK	12	2019	fall	pre_kindergarten												0												0
595921	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	grade_1												0												0
597321	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	grade_10												3												3
598721	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	grade_11												5												5
600121	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	grade_12												12												12
601521	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	grade_2												1												1
602921	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	grade_3												0												0
604321	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	grade_4												0												0
605721	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	grade_5												2												2
607121	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	grade_6												1												1
608521	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	grade_7												5												5
609921	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	grade_8												3												3
611321	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	grade_9												5												5
612721	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	grade_9_transitional												0												0
614121	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	kindergarten												2												2
615521	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	pk_12_total	20.0	18.0	0.0	0.0	1.0	0.0	0.0	20.0	19.0	0.0	39.0	39	20	18	0	0	1	0	0	20	19	0	39	39
616921	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	spring	pre_kindergarten												0												0
2012345	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	grade_1												0												0
2013746	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	grade_10												3												3
2015147	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	grade_11												5												5
2016548	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	grade_12												12												12
2017949	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	grade_2												1												1
2019350	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	grade_3												0												0
2020751	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	grade_4												1												1
2022152	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	grade_5												1												1
2023553	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	grade_6												0												0
2024954	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	grade_7												6												6
2026355	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	grade_8												3												3
2027756	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	grade_9												4												4
2029157	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	grade_9_transitional												0												0
2030558	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	kindergarten												2												2
2031959	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	pk_12_total	20.0	17.0	0.0	0.0	1.0	0.0	0.0	20.0	18.0	0.0	25.0	38	20	17	0	0	1	0	0	20	18	0	25	38
2033360	LA	school	2200020	306	Central Louisiana Supports and Services Center	220002000267	306001	Central Louisiana Supports and Services Center	Special Education School	No	Other	PK	12	2020	fall	pre_kindergarten												0												0
2284959	LA	school	2200020	306	Louisiana Special Education Center	220002000267	306001	Louisiana Special Education Center	Special Education School	No	Other	KG	12	2019	spring	grade_1												1												1
2286372	LA	school	2200020	306	Louisiana Special Education Center	220002000267	306001	Louisiana Special Education Center	Special Education School	No	Other	KG	12	2019	spring	grade_10												5												5
2287785	LA	school	2200020	306	Louisiana Special Education Center	220002000267	306001	Louisiana Special Education Center	Special Education School	No	Other	KG	12	2019	spring	grade_11												1												1
2289198	LA	school	2200020	306	Louisiana Special Education Center	220002000267	306001	Louisiana Special Education Center	Special Education School	No	Other	KG	12	2019	spring	grade_12												12												12
2290611	LA	school	2200020	306	Louisiana Special Education Center	220002000267	306001	Louisiana Special Education Center	Special Education School	No	Other	KG	12	2019	spring	grade_2												0												0
2292024	LA	school	2200020	306	Louisiana Special Education Center	220002000267	306001	Louisiana Special Education Center	Special Education School	No	Other	KG	12	2019	spring	grade_3												1												1
2293437	LA	school	2200020	306	Louisiana Special Education Center	220002000267	306001	Louisiana Special Education Center	Special Education School	No	Other	KG	12	2019	spring	grade_4												0												0