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 (ccd_school_type > :p3 or (ccd_school_type = :p3 and rowid > :p2)) order by ccd_school_type, 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
2012409	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_1												0												0
2012410	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	grade_1												0												0
2012604	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	fall	grade_10												2												2
2013322	LA	school	2201320	041	Red River Parish	220132002471	41012	Red River Academic Academy	Alternative School	No	Middle	06	06	2020	fall	grade_10												0												0
2013555	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2020	fall	grade_10												18												18
2013809	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_10												16												16
2013810	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_10												29												29
2013811	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	grade_10												9												9
2014005	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	fall	grade_11												1												1
2014723	LA	school	2201320	041	Red River Parish	220132002471	41012	Red River Academic Academy	Alternative School	No	Middle	06	06	2020	fall	grade_11												0												0
2014956	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2020	fall	grade_11												9												9
2015210	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_11												10												10
2015211	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_11												9												9
2015212	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	grade_11												4												4
2015406	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	fall	grade_12												1												1
2016124	LA	school	2201320	041	Red River Parish	220132002471	41012	Red River Academic Academy	Alternative School	No	Middle	06	06	2020	fall	grade_12												0												0
2016357	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2020	fall	grade_12												2												2
2016611	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_12												13												13
2016612	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_12												8												8
2016613	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	grade_12												5												5
2016807	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	fall	grade_2												0												0
2017525	LA	school	2201320	041	Red River Parish	220132002471	41012	Red River Academic Academy	Alternative School	No	Middle	06	06	2020	fall	grade_2												0												0
2017758	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2020	fall	grade_2												0												0
2018012	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_2												0												0
2018013	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_2												0												0
2018014	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	grade_2												0												0
2018208	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	fall	grade_3												0												0
2018926	LA	school	2201320	041	Red River Parish	220132002471	41012	Red River Academic Academy	Alternative School	No	Middle	06	06	2020	fall	grade_3												0												0
2019159	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2020	fall	grade_3												0												0
2019413	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_3												0												0
2019414	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_3												0												0
2019415	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	grade_3												0												0
2019609	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	fall	grade_4												0												0
2020327	LA	school	2201320	041	Red River Parish	220132002471	41012	Red River Academic Academy	Alternative School	No	Middle	06	06	2020	fall	grade_4												0												0
2020560	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2020	fall	grade_4												0												0
2020814	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_4												0												0
2020815	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_4												0												0
2020816	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	grade_4												0												0
2021010	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	fall	grade_5												0												0
2021728	LA	school	2201320	041	Red River Parish	220132002471	41012	Red River Academic Academy	Alternative School	No	Middle	06	06	2020	fall	grade_5												0												0
2021961	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2020	fall	grade_5												0												0
2022215	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_5												0												0
2022216	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_5												0												0
2022217	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	grade_5												0												0
2022411	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	fall	grade_6												1												1
2023129	LA	school	2201320	041	Red River Parish	220132002471	41012	Red River Academic Academy	Alternative School	No	Middle	06	06	2020	fall	grade_6												19												19
2023362	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2020	fall	grade_6												0												0
2023616	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_6												0												0
2023617	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_6												0												0
2023618	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	grade_6												0												0
2023812	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	fall	grade_7												0												0
2024530	LA	school	2201320	041	Red River Parish	220132002471	41012	Red River Academic Academy	Alternative School	No	Middle	06	06	2020	fall	grade_7												0												0
2024763	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2020	fall	grade_7												6												6
2025017	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_7												1												1
2025018	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_7												3												3
2025019	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	grade_7												1												1
2025213	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	fall	grade_8												0												0
2025931	LA	school	2201320	041	Red River Parish	220132002471	41012	Red River Academic Academy	Alternative School	No	Middle	06	06	2020	fall	grade_8												0												0
2026164	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2020	fall	grade_8												11												11
2026418	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_8												2												2
2026419	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_8												7												7
2026420	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	grade_8												1												1
2026614	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	fall	grade_9												6												6
2027332	LA	school	2201320	041	Red River Parish	220132002471	41012	Red River Academic Academy	Alternative School	No	Middle	06	06	2020	fall	grade_9												0												0
2027565	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2020	fall	grade_9												18												18
2027819	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_9												13												13
2027820	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_9												30												30
2027821	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	grade_9												2												2
2028015	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	fall	grade_9_transitional												0												0
2028733	LA	school	2201320	041	Red River Parish	220132002471	41012	Red River Academic Academy	Alternative School	No	Middle	06	06	2020	fall	grade_9_transitional												0												0
2028966	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2020	fall	grade_9_transitional												0												0
2029220	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_9_transitional												1												1
2029221	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_9_transitional												7												7
2029222	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	grade_9_transitional												1												1
2029416	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	fall	kindergarten												0												0
2030134	LA	school	2201320	041	Red River Parish	220132002471	41012	Red River Academic Academy	Alternative School	No	Middle	06	06	2020	fall	kindergarten												0												0
2030367	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2020	fall	kindergarten												0												0
2030621	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	kindergarten												0												0
2030622	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	kindergarten												0												0
2030623	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	kindergarten												0												0
2030817	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	fall	pk_12_total	3.0	8.0	0.0	0.0	0.0	0.0	0.0	8.0	3.0	0.0	10.0	11	3	8	0	0	0	0	0	8	3	0	10	11
2031535	LA	school	2201320	041	Red River Parish	220132002471	41012	Red River Academic Academy	Alternative School	No	Middle	06	06	2020	fall	pk_12_total	8.0	11.0	0.0	0.0	0.0	0.0	0.0	10.0	9.0	0.0	18.0	19	8	11	0	0	0	0	0	10	9	0	18	19
2031768	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2020	fall	pk_12_total	25.0	30.0	3.0	0.0	1.0	4.0	1.0	53.0	11.0	1.0	64.0	64	25	30	3	0	1	4	1	53	11	1	64	64
2032022	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	pk_12_total	9.0	47.0	0.0	0.0	0.0	0.0	0.0	56.0	0.0	0.0	56.0	56	9	47	0	0	0	0	0	56	0	0	56	56
2032023	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	pk_12_total	14.0	77.0	0.0	1.0	0.0	0.0	1.0	93.0	0.0	0.0	93.0	93	14	77	0	1	0	0	1	93	0	0	93	93
2032024	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	pk_12_total	0.0	22.0	1.0	0.0	0.0	0.0	0.0	23.0	0.0	0.0	23.0	23	0	22	1	0	0	0	0	23	0	0	23	23
2032218	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	fall	pre_kindergarten												0												0
2032936	LA	school	2201320	041	Red River Parish	220132002471	41012	Red River Academic Academy	Alternative School	No	Middle	06	06	2020	fall	pre_kindergarten												0												0
2033169	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2020	fall	pre_kindergarten												0												0
2033423	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	pre_kindergarten												0												0
2033424	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	pre_kindergarten												0												0
2033425	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	pre_kindergarten												0												0
594732	LA	school	2200150	005	Avoyelles Parish	220015001378	5025	LA School for Ag Science	Career and Technical School	Yes	High	07	12	2020	spring	grade_1												0												0
595251	LA	school	2200870	028	Lafayette Parish	220087002301	28054	David Thibodaux STEM Magnet Academy	Career and Technical School	No	High	06	12	2020	spring	grade_1												0												0
595506	LA	school	2201350	042	Richland Parish	220135001102	42008	Rayville High School	Career and Technical School	No	High	09	12	2020	spring	grade_1												0												0
596132	LA	school	2200150	005	Avoyelles Parish	220015001378	5025	LA School for Ag Science	Career and Technical School	Yes	High	07	12	2020	spring	grade_10												70												70
596651	LA	school	2200870	028	Lafayette Parish	220087002301	28054	David Thibodaux STEM Magnet Academy	Career and Technical School	No	High	06	12	2020	spring	grade_10												167												167
596906	LA	school	2201350	042	Richland Parish	220135001102	42008	Rayville High School	Career and Technical School	No	High	09	12	2020	spring	grade_10												90												90
597532	LA	school	2200150	005	Avoyelles Parish	220015001378	5025	LA School for Ag Science	Career and Technical School	Yes	High	07	12	2020	spring	grade_11												63												63
598051	LA	school	2200870	028	Lafayette Parish	220087002301	28054	David Thibodaux STEM Magnet Academy	Career and Technical School	No	High	06	12	2020	spring	grade_11												157												157
598306	LA	school	2201350	042	Richland Parish	220135001102	42008	Rayville High School	Career and Technical School	No	High	09	12	2020	spring	grade_11												60												60