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 "grade" = :p0 and "state" = :p1 order by ccd_school_lvl desc 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	total	total_int
612136	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2020	spring	grade_9_transitional	17	17
612148	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2020	spring	grade_9_transitional	10	10
612193	LA	school	2201170	R36	Orleans Parish	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	11	2020	spring	grade_9_transitional	0	0
1782248	LA	school	2200840	026	Jefferson Parish	220084002419	26128	Jefferson RISE Charter School	Regular School	Yes	Secondary	06	11	2021	spring	grade_9_transitional	4	4
1782403	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2021	spring	grade_9_transitional	16	16
2006017	LA	school	2200840	026	Jefferson Parish	220084002419	26128	Jefferson RISE Charter School	Regular School	Yes	Secondary	06	11	2021	fall	grade_9_transitional	5	5
2006172	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2021	fall	grade_9_transitional	17	17
2028571	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2020	fall	grade_9_transitional	20	20
2028583	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2020	fall	grade_9_transitional	13	13
2028628	LA	school	2201170	R36	Orleans Parish	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	11	2020	fall	grade_9_transitional	0	0
2301323	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	grade_9_transitional	27	27
2301335	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	grade_9_transitional	54	54
2301381	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	grade_9_transitional	0	0
2535726	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	grade_9_transitional	31	31
2535738	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	grade_9_transitional	56	56
2535786	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	grade_9_transitional	0	0
611829	LA	school	2200540	017	East Baton Rouge Parish	220054002360	17143	Delmont Pre-K and Kindergarten Center	Regular School	No	Prekindergarten	PK	PK	2020	spring	grade_9_transitional	0	0
612039	LA	school	2200870	028	Lafayette Parish	220087000691	28033	Truman Early Childhood Education Center	Regular School	No	Prekindergarten	PK	PK	2020	spring	grade_9_transitional	0	0
612111	LA	school	2200990	031	Lincoln Parish	220099002304	31023	Lincoln Parish Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	2020	spring	grade_9_transitional	0	0
612692	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2020	spring	grade_9_transitional	0	0
1781915	LA	school	2200330	010	Calcasieu Parish	220033000222	10009	Jessie D. Clifton Elementary School	Regular School	No	Prekindergarten	PK	PK	2021	spring	grade_9_transitional	0	0
1781931	LA	school	2200330	010	Calcasieu Parish	220033000241	10029	John F. Kennedy Elementary School	Regular School	No	Prekindergarten	PK	PK	2021	spring	grade_9_transitional	0	0
1782030	LA	school	2200540	017	East Baton Rouge Parish	220054001920	17031	Southdowns School	Special Education School	No	Prekindergarten	PK	PK	2021	spring	grade_9_transitional	0	0
1782087	LA	school	2200540	017	East Baton Rouge Parish	220054002360	17143	Delmont Pre-K and Kindergarten Center	Regular School	No	Prekindergarten	PK	PK	2021	spring	grade_9_transitional	0	0
1782295	LA	school	2200870	028	Lafayette Parish	220087000691	28033	Truman Early Childhood Education Center	Regular School	No	Prekindergarten	PK	PK	2021	spring	grade_9_transitional	0	0
1782367	LA	school	2200990	031	Lincoln Parish	220099002304	31023	Lincoln Parish Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	2021	spring	grade_9_transitional	0	0
1782940	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	spring	grade_9_transitional	0	0
2005684	LA	school	2200330	010	Calcasieu Parish	220033000222	10009	Jessie D. Clifton Elementary School	Regular School	No	Prekindergarten	PK	PK	2021	fall	grade_9_transitional	0	0
2005700	LA	school	2200330	010	Calcasieu Parish	220033000241	10029	John F. Kennedy Elementary School	Regular School	No	Prekindergarten	PK	PK	2021	fall	grade_9_transitional	0	0
2005799	LA	school	2200540	017	East Baton Rouge Parish	220054001920	17031	Southdowns School	Special Education School	No	Prekindergarten	PK	PK	2021	fall	grade_9_transitional	0	0
2005856	LA	school	2200540	017	East Baton Rouge Parish	220054002360	17143	Delmont Pre-K and Kindergarten Center	Regular School	No	Prekindergarten	PK	PK	2021	fall	grade_9_transitional	0	0
2006064	LA	school	2200870	028	Lafayette Parish	220087000691	28033	Truman Early Childhood Education Center	Regular School	No	Prekindergarten	PK	PK	2021	fall	grade_9_transitional	0	0
2006136	LA	school	2200990	031	Lincoln Parish	220099002304	31023	Lincoln Parish Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	2021	fall	grade_9_transitional	0	0
2006719	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	fall	grade_9_transitional	0	0
2028264	LA	school	2200540	017	East Baton Rouge Parish	220054002360	17143	Delmont Pre-K and Kindergarten Center	Regular School	No	Prekindergarten	PK	PK	2020	fall	grade_9_transitional	0	0
2028474	LA	school	2200870	028	Lafayette Parish	220087000691	28033	Truman Early Childhood Education Center	Regular School	No	Prekindergarten	PK	PK	2020	fall	grade_9_transitional	0	0
2028546	LA	school	2200990	031	Lincoln Parish	220099002304	31023	Lincoln Parish Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	2020	fall	grade_9_transitional	0	0
2029127	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2020	fall	grade_9_transitional	0	0
2301016	LA	school	2200540	017	East Baton Rouge Parish	220054002360	17143	Delmont Pre-K and Kindergarten Center	Regular School	No	Prekindergarten	PK	PK	2019	spring	grade_9_transitional	0	0
2301229	LA	school	2200870	028	Lafayette Parish	220087000691	28033	Truman Early Childhood Education Center	Regular School	No	Prekindergarten	PK	PK	2019	spring	grade_9_transitional	0	0
2301298	LA	school	2200990	031	Lincoln Parish	220099002304	31023	Lincoln Parish Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	2019	spring	grade_9_transitional	0	0
2301882	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2019	spring	grade_9_transitional	0	0
2535419	LA	school	2200540	017	East Baton Rouge Parish	220054002360	17143	Delmont Pre-K and Kindergarten Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_9_transitional	0	0
2535632	LA	school	2200870	028	Lafayette Parish	220087000691	28033	Truman Early Childhood Education Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_9_transitional	0	0
2535701	LA	school	2200990	031	Lincoln Parish	220099002304	31023	Lincoln Parish Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_9_transitional	0	0
2536288	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_9_transitional	0	0
611471	LA	school	2200030	001	Acadia Parish	220003002381	1036	AMIKids Acadiana	Regular School	No	Other	04	12	2020	spring	grade_9_transitional	0	0
611473	LA	school	2200060	002	Allen Parish	220006000024	2001	Elizabeth High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	7	7
611474	LA	school	2200060	002	Allen Parish	220006000025	2002	Fairview High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	4	4
611482	LA	school	2200060	002	Allen Parish	220006000033	2010	Reeves High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	1	1
611539	LA	school	2200180	006	Beauregard Parish	220018000086	6008	Merryville High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611541	LA	school	2200180	006	Beauregard Parish	220018000088	6010	Singer High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611547	LA	school	2200210	007	Bienville Parish	220021000091	7002	Bienville High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611548	LA	school	2200210	007	Bienville Parish	220021000092	7003	Castor High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611550	LA	school	2200210	007	Bienville Parish	220021000095	7006	Gibsland-Coleman High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611553	LA	school	2200210	007	Bienville Parish	220021000099	7009	Saline High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611571	LA	school	2200270	008	Bossier Parish	220027000132	8022	Plain Dealing High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	3	3
611580	LA	school	2200270	008	Bossier Parish	220027000218	8036	Johnny Gray Jones Youth Shelter & Detention Center	Alternative School	No	Other	KG	12	2020	spring	grade_9_transitional	0	0
611643	LA	school	2200300	009	Caddo Parish	220030002343	9104	Academic Recovery Ombudsman	Regular School	No	Other	02	12	2020	spring	grade_9_transitional	13	13
611644	LA	school	2200300	009	Caddo Parish	220030002377	9106	Magnolia School of Excellence	Regular School	Yes	Other	KG	12	2020	spring	grade_9_transitional	4	4
611655	LA	school	2200330	010	Calcasieu Parish	220033000217	10004	Bell City High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	4	4
611689	LA	school	2200330	010	Calcasieu Parish	220033000265	10051	Starks High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	5	5
611707	LA	school	2200330	010	Calcasieu Parish	220033000220	10071	Jake Drost School for Exceptional Children	Special Education School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611720	LA	school	2200390	012	Cameron Parish	220039000289	12003	Grand Lake High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	8	8
611721	LA	school	2200390	012	Cameron Parish	220039000290	12004	Hackberry High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611722	LA	school	2200390	012	Cameron Parish	220039000291	12005	Johnson Bayou High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611723	LA	school	2200390	012	Cameron Parish	220039000293	12007	South Cameron High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	5	5
611725	LA	school	2200420	013	Catahoula Parish	220042000295	13002	Central High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611726	LA	school	2200420	013	Catahoula Parish	220042000298	13005	Harrisonburg High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611728	LA	school	2200420	013	Catahoula Parish	220042000304	13011	Sicily Island High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611734	LA	school	2200450	014	Claiborne Parish	220045000315	14011	Summerfield High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611740	LA	school	2200480	015	Concordia Parish	220048000322	15006	Monterey High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611745	LA	school	2200480	015	Concordia Parish	220048001515	15014	Concordia Education Center	Regular School	No	Other	03	12	2020	spring	grade_9_transitional	0	0
611747	LA	school	2200510	016	DeSoto Parish	220051000331	16004	Logansport High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	1	1
611749	LA	school	2200510	016	DeSoto Parish	220051000337	16010	Stanley High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611789	LA	school	2200540	017	East Baton Rouge Parish	220054000404	17063	Northdale Superintendent's Academy	Regular School	No	Other	KG	12	2020	spring	grade_9_transitional	1	1
611808	LA	school	2200540	017	East Baton Rouge Parish	220054000339	17092	EBR Readiness Superintendent Academy	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611846	LA	school	2200600	019	East Feliciana Parish	220060000715	19013	East Feliciana Parish Enrichment Academy	Regular School	No	Other	01	12	2020	spring	grade_9_transitional	0	0
611849	LA	school	2200630	020	Evangeline Parish	220063000470	20001	Basile High School	Regular School	No	Other	04	12	2020	spring	grade_9_transitional	6	6
611853	LA	school	2200630	020	Evangeline Parish	220063000475	20008	Mamou High School	Regular School	No	Other	04	12	2020	spring	grade_9_transitional	16	16
611854	LA	school	2200630	020	Evangeline Parish	220063000478	20010	Pine Prairie High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	14	14
611870	LA	school	2200690	022	Grant Parish	220069000500	22004	Georgetown High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611907	LA	school	2200750	024	Iberville Parish	220075000231	24025	East Iberville Elementary/High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	7	7
611910	LA	school	2200780	025	Jackson Parish	220078000556	25007	Quitman High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611912	LA	school	2200780	025	Jackson Parish	220078000560	25010	Weston High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
611934	LA	school	2200840	026	Jefferson Parish	220084000606	26031	Grand Isle High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	1	1
611990	LA	school	2200840	026	Jefferson Parish	220084000653	26125	Kenner Discovery Health Sciences Academy	Regular School	Yes	Other	PK	12	2020	spring	grade_9_transitional	35	35
611991	LA	school	2200840	026	Jefferson Parish	220084000638	26126	Young Audiences Charter School	Regular School	Yes	Other	KG	09	2020	spring	grade_9_transitional	0	0
612001	LA	school	2200810	027	Jefferson Davis Parish	220081000564	27004	Hathaway High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
612005	LA	school	2200810	027	Jefferson Davis Parish	220081000570	27010	Lacassine High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
612048	LA	school	2200870	028	Lafayette Parish	220087001397	28050	Lerosen Preparatory Academy	Regular School	No	Other	KG	12	2020	spring	grade_9_transitional	33	33
612086	LA	school	2200900	029	Lafourche Parish	220090002339	29040	Virtual Academy of Lafourche	Regular School	Yes	Other	KG	12	2020	spring	grade_9_transitional	19	19
612107	LA	school	2200990	031	Lincoln Parish	220099000753	31014	Simsboro High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0
612124	LA	school	2201020	032	Livingston Parish	220102000765	32012	Holden High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	3	3
612128	LA	school	2201020	032	Livingston Parish	220102000768	32017	Maurepas School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	2	2
612165	LA	school	2201110	034	Morehouse Parish	220111002359	34003	Beekman Charter School	Regular School	Yes	Other	PK	12	2020	spring	grade_9_transitional	0	0
612168	LA	school	2201110	034	Morehouse Parish	220111000778	34023	Morehouse Magnet School	Regular School	No	Other	PK	09	2020	spring	grade_9_transitional	0	0
612181	LA	school	2201140	035	Natchitoches Parish	220114001404	35030	Natchitoches Parish Technical and Career Center	Regular School	No	Other	04	12	2020	spring	grade_9_transitional	0	0
612183	LA	school	2201140	035	Natchitoches Parish	220114002022	35032	Lakeview Annex	Regular School	No	Other	04	12	2020	spring	grade_9_transitional	0	0
612188	LA	school	2201170	R36	Orleans Parish	220117001522	36132	Travis Hill School	Regular School	No	Other	03	12	2020	spring	grade_9_transitional	0	0
612236	LA	school	2201230	038	Plaquemines Parish	220123001026	38006	Phoenix High School	Regular School	No	Other	PK	12	2020	spring	grade_9_transitional	0	0