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 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	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
2284367	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	grade_1												0												0
2284379	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	grade_1												0												0
2284425	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	grade_1												0												0
2285780	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	grade_10												0												0
2285792	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	grade_10												0												0
2285838	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	grade_10												41												41
2287193	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	grade_11												0												0
2287205	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	grade_11												0												0
2287251	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	grade_11												0												0
2288606	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	grade_12												0												0
2288618	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	grade_12												0												0
2288664	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	grade_12												0												0
2290019	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	grade_2												0												0
2290031	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	grade_2												0												0
2290077	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	grade_2												0												0
2291432	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	grade_3												0												0
2291444	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	grade_3												0												0
2291490	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	grade_3												0												0
2292845	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	grade_4												0												0
2292857	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	grade_4												0												0
2292903	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	grade_4												0												0
2294258	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	grade_5												0												0
2294270	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	grade_5												0												0
2294316	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	grade_5												0												0
2295671	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	grade_6												0												0
2295683	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	grade_6												0												0
2295729	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	grade_6												0												0
2297084	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	grade_7												0												0
2297096	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	grade_7												0												0
2297142	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	grade_7												0												0
2298497	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	grade_8												0												0
2298509	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	grade_8												0												0
2298555	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	grade_8												0												0
2299910	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	grade_9												492												492
2299922	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	grade_9												548												548
2299968	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	grade_9												56												56
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
2302736	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	kindergarten												0												0
2302748	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	kindergarten												0												0
2302794	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	kindergarten												0												0
2304149	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	pk_12_total	436.0	57.0	19.0	0.0	3.0	0.0	4.0	268.0	251.0	3.0	228.0	519	436	57	19	0	3	0	4	268	251	3	228	519
2304161	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	pk_12_total	469.0	56.0	70.0	0.0	4.0	0.0	3.0	308.0	294.0	20.0	289.0	602	469	56	70	0	4	0	3	308	294	20	289	602
2304207	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	pk_12_total	5.0	84.0	7.0	0.0	1.0	0.0	0.0	68.0	29.0	4.0	79.0	97	5	84	7	0	1	0	0	68	29	4	79	97
2305562	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	spring	pre_kindergarten												0												0
2305574	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	spring	pre_kindergarten												0												0
2305620	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	spring	pre_kindergarten												0												0
2518722	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	grade_1												0												0
2518734	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	grade_1												0												0
2518782	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	grade_1												0												0
2520139	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	grade_10												0												0
2520151	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	grade_10												0												0
2520199	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	grade_10												40												40
2521556	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	grade_11												0												0
2521568	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	grade_11												0												0
2521616	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	grade_11												0												0
2522973	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	grade_12												0												0
2522985	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	grade_12												0												0
2523033	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	grade_12												0												0
2524390	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	grade_2												0												0
2524402	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	grade_2												0												0
2524450	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	grade_2												0												0
2525807	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	grade_3												0												0
2525819	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	grade_3												0												0
2525867	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	grade_3												0												0
2527224	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	grade_4												0												0
2527236	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	grade_4												0												0
2527284	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	grade_4												0												0
2528641	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	grade_5												0												0
2528653	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	grade_5												0												0
2528701	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	grade_5												0												0
2530058	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	grade_6												0												0
2530070	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	grade_6												0												0
2530118	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	grade_6												0												0
2531475	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	grade_7												0												0
2531487	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	grade_7												0												0
2531535	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	grade_7												0												0
2532892	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	grade_8												0												0
2532904	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	grade_8												0												0
2532952	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	grade_8												0												0
2534309	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	grade_9												511												511
2534321	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	grade_9												557												557
2534369	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	grade_9												50												50
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
2537143	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	kindergarten												0												0
2537155	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	kindergarten												0												0
2537203	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	kindergarten												0												0
2538560	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	pk_12_total	460.0	56.0	19.0	0.0	3.0	0.0	4.0	281.99999999999994	260.0	3.0	234.0	542	460	56	19	0	3	0	4		260	3	234	542
2538572	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	pk_12_total	479.0	56.0	69.0	1.0	4.0	1.0	3.0	312.99999999999994	300.0	21.0	296.0	613	479	56	69	1	4	1	3		300	21	296	613
2538620	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	pk_12_total	6.0	76.0	7.0	0.0	1.0	0.0	0.0	62.99999999999999	27.0	0.0	67.0	90	6	76	7	0	1	0	0		27	0	67	90
2539977	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2019	fall	pre_kindergarten												0												0
2539989	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2019	fall	pre_kindergarten												0												0
2540037	LA	school	2201170	R36	All Orleans	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	10	2019	fall	pre_kindergarten												0												0
595336	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2020	spring	grade_1												0												0
595348	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2020	spring	grade_1												0												0
595393	LA	school	2201170	R36	Orleans Parish	220117002437	36198	Rooted School	Regular School	Yes	Secondary	09	11	2020	spring	grade_1												0												0
596736	LA	school	2201020	032	Livingston Parish	220102000775	32025	Walker Freshman High School	Regular School	No	Secondary	09	09	2020	spring	grade_10												0												0
596748	LA	school	2201020	032	Livingston Parish	220102000904	32042	Denham Springs Freshman High School	Regular School	No	Secondary	08	09	2020	spring	grade_10												0												0