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 and "year" = :p2 order by total 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
2296764	LA	school	2200540	017	East Baton Rouge Parish	220054000673	17111	Community School For Apprenticeship Learning	Regular School	Yes	Middle	06	08	2019	spring	grade_7	99	99
2297298	LA	school	2201470	046	St. Helena Parish	220147001154	46002	St. Helena College and Career Academy	Regular School	No	High	07	12	2019	spring	grade_7	99	99
2297305	LA	school	2201500	047	St. James Parish	220150001167	47008	St. James High School	Regular School	No	High	07	12	2019	spring	grade_7	99	99
2297723	LA	school	2200054	RLA	RSD-Direct Run	220005400175	396211	Linwood Charter School	Regular School	No	Elementary	PK	08	2019	spring	grade_7	99	99
2530815	LA	school	2200060	002	Allen Parish	220006000030	2007	Oakdale Middle School	Regular School	No	Middle	05	08	2019	fall	grade_7	99	99
2530858	LA	school	2200150	005	Avoyelles Parish	220015000063	5004	Bunkie Magnet High School	Regular School	No	High	07	12	2019	fall	grade_7	99	99
2530862	LA	school	2200150	005	Avoyelles Parish	220015000073	5016	Marksville High School	Regular School	No	High	07	12	2019	fall	grade_7	99	99
2532092	LA	school		R36	All Orleans		363001	Harriet Tubman Charter School						2019	fall	grade_7	99	99
2296391	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	grade_7	98	98
2296805	LA	school	2200630	020	Evangeline Parish	220063000482	20014	Ville Platte High School	Regular School	No	High	06	12	2019	spring	grade_7	98	98
2297344	LA	school	2201560	049	St. Landry Parish	220156001213	49042	Sunset Elementary School	Regular School	No	Middle	05	08	2019	spring	grade_7	98	98
2531755	LA	school	2201590	050	St. Martin Parish	220159001224	50009	Parks Middle School	Regular School	No	Middle	04	08	2019	fall	grade_7	98	98
2532118	LA	school		RLA	RSD-Direct Run		396211	Linwood Charter School						2019	fall	grade_7	98	98
2296424	LA	school	2200060	002	Allen Parish	220006000030	2007	Oakdale Middle School	Regular School	No	Middle	05	08	2019	spring	grade_7	97	97
2297092	LA	school	2201020	032	Livingston Parish	220102010339	32038	Springfield Middle School	Regular School	No	Middle	04	08	2019	spring	grade_7	97	97
2297310	LA	school	2201530	048	St. John the Baptist Parish	220153001493	48006	LaPlace Elementary School	Regular School	No	Elementary	KG	08	2019	spring	grade_7	97	97
2297362	LA	school	2201590	050	St. Martin Parish	220159001224	50009	Parks Middle School	Regular School	No	Middle	04	08	2019	spring	grade_7	97	97
2297481	LA	school	2201680	053	Tangipahoa Parish	220168002274	53051	Jewel M. Sumner Middle School	Regular School	No	Middle	06	08	2019	spring	grade_7	97	97
2297670	LA	school		R36	All Orleans		300001	Pierre A. Capdau Charter School at Avery Alexander						2019	spring	grade_7	97	97
2297686	LA	school		CHA	Type 2 Charters		337001	Belle Chasse Academy						2019	spring	grade_7	97	97
2297705	LA	school		R36	All Orleans		369006	ReNEW Schaumburg Elementary						2019	spring	grade_7	97	97
2530782	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	grade_7	97	97
2532157	LA	school		CHA	Type 2 Charters		W6B001	Acadiana Renaissance Charter Academy						2019	fall	grade_7	97	97
2531192	LA	school	2200630	020	Evangeline Parish	220063000475	20008	Mamou High School	Regular School	No	Other	04	12	2019	fall	grade_7	96	96
2531698	LA	school	2201500	047	St. James Parish	220150001167	47008	St. James High School	Regular School	No	High	07	12	2019	fall	grade_7	96	96
2532064	LA	school		R36	All Orleans		300001	Pierre A. Capdau Charter School at Avery Alexander						2019	fall	grade_7	96	96
2532128	LA	school		R36	All Orleans		399002	Arthur Ashe Charter School						2019	fall	grade_7	96	96
2296400	LA	school	2200030	001	Acadia Parish	220003001015	1015	Iota Middle School	Regular School	No	Middle	06	08	2019	spring	grade_7	95	95
2297762	LA	school		CHA	Type 2 Charters		W6B001	Acadiana Renaissance Charter Academy						2019	spring	grade_7	95	95
2530791	LA	school	2200030	001	Acadia Parish	220003001015	1015	Iota Middle School	Regular School	No	Middle	06	08	2019	fall	grade_7	95	95
2531483	LA	school	2201020	032	Livingston Parish	220102010339	32038	Springfield Middle School	Regular School	No	Middle	04	08	2019	fall	grade_7	95	95
2531638	LA	school	2201320	041	Red River Parish	220132001530	41011	Red River Junior High School	Regular School	No	Middle	06	08	2019	fall	grade_7	95	95
2531691	LA	school	2201470	046	St. Helena Parish	220147001154	46002	St. Helena College and Career Academy	Regular School	No	High	07	12	2019	fall	grade_7	95	95
2531703	LA	school	2201530	048	St. John the Baptist Parish	220153001493	48006	LaPlace Elementary School	Regular School	No	Elementary	KG	08	2019	fall	grade_7	95	95
2532006	LA	school	2202010	064	Winn Parish	220201001486	64008	Winnfield Middle School	Regular School	No	Middle	05	08	2019	fall	grade_7	95	95
2532080	LA	school		CHA	Type 2 Charters		337001	Belle Chasse Academy						2019	fall	grade_7	95	95
2296801	LA	school	2200630	020	Evangeline Parish	220063000475	20008	Mamou High School	Regular School	No	Other	04	12	2019	spring	grade_7	94	94
2531459	LA	school	2201020	032	Livingston Parish	220102000761	32008	Doyle High School	Regular School	No	High	06	12	2019	fall	grade_7	94	94
2532131	LA	school		R36	All Orleans		399005	Langston Hughes Charter Academy						2019	fall	grade_7	94	94
2297245	LA	school	2201320	041	Red River Parish	220132001530	41011	Red River Junior High School	Regular School	No	Middle	06	08	2019	spring	grade_7	93	93
2297474	LA	school	2201680	053	Tangipahoa Parish	220168001326	53032	Amite Westside Middle Magnet	Regular School	No	Middle	05	08	2019	spring	grade_7	93	93
2297702	LA	school		R36	All Orleans		369002	ReNEW SciTech Academy at Laurel						2019	spring	grade_7	93	93
2531850	LA	school	2201680	053	Tangipahoa Parish	220168001308	53013	Independence Magnet	Regular School	No	Middle	05	08	2019	fall	grade_7	93	93
2297612	LA	school	2202010	064	Winn Parish	220201001486	64008	Winnfield Middle School	Regular School	No	Middle	05	08	2019	spring	grade_7	92	92
2297733	LA	school		R36	All Orleans		399002	Arthur Ashe Charter School						2019	spring	grade_7	92	92
2531910	LA	school	2201740	055	Terrebonne Parish	220174001952	55044	Grand Caillou Middle School	Regular School	No	Middle	05	08	2019	fall	grade_7	92	92
2532098	LA	school		R36	All Orleans		369003	ReNEW Dolores T. Aaron Elementary						2019	fall	grade_7	92	92
2532100	LA	school		R36	All Orleans		369006	ReNEW Schaumburg Elementary						2019	fall	grade_7	92	92
2296467	LA	school	2200150	005	Avoyelles Parish	220015000063	5004	Bunkie Magnet High School	Regular School	No	High	07	12	2019	spring	grade_7	91	91
2297775	LA	school		R36	All Orleans		WAZ001	Audubon Charter School						2019	spring	grade_7	91	91
2531856	LA	school	2201680	053	Tangipahoa Parish	220168001315	53020	Natalbany Middle	Regular School	No	Middle	04	08	2019	fall	grade_7	91	91
2297068	LA	school	2201020	032	Livingston Parish	220102000761	32008	Doyle High School	Regular School	No	High	06	12	2019	spring	grade_7	90	90
2297113	LA	school	2201110	034	Morehouse Parish	220111002359	34003	Beekman Charter School	Regular School	Yes	Other	PK	12	2019	spring	grade_7	90	90
2297410	LA	school	2201650	052	St. Tammany Parish	220165001281	52020	Lee Road Junior High School	Regular School	No	Elementary	PK	08	2019	spring	grade_7	90	90
2297501	LA	school	2201740	055	Terrebonne Parish	220174001354	55021	Lacache Middle School	Regular School	No	Middle	05	08	2019	spring	grade_7	90	90
2532097	LA	school		R36	All Orleans		369002	ReNEW SciTech Academy at Laurel						2019	fall	grade_7	90	90
2532170	LA	school		R36	All Orleans		WAZ001	Audubon Charter School						2019	fall	grade_7	90	90
2296493	LA	school	2200210	007	Bienville Parish	220021000095	7006	Gibsland-Coleman High School	Regular School	No	Other	PK	12	2019	spring	grade_7	9	9
2296669	LA	school	2200420	013	Catahoula Parish	220042000295	13002	Central High School	Regular School	No	Other	KG	12	2019	spring	grade_7	9	9
2296690	LA	school	2200480	015	Concordia Parish	220048001515	15014	Concordia Education Center	Regular School	No	Other	04	12	2019	spring	grade_7	9	9
2296930	LA	school	2200840	026	Jefferson Parish	220084001518	26103	Westbank Community School	Regular School	No	Elementary	KG	08	2019	spring	grade_7	9	9
2296935	LA	school	2200840	026	Jefferson Parish	220084002044	26112	John Martyn Community School	Regular School	No	Other	KG	12	2019	spring	grade_7	9	9
2531057	LA	school	2200390	012	Cameron Parish	220039000291	12005	Johnson Bayou High School	Regular School	No	Other	PK	12	2019	fall	grade_7	9	9
2531060	LA	school	2200420	013	Catahoula Parish	220042000295	13002	Central High School	Regular School	No	Other	KG	12	2019	fall	grade_7	9	9
2531275	LA	school	2200840	026	Jefferson Parish	220084000606	26031	Grand Isle High School	Regular School	No	Other	PK	12	2019	fall	grade_7	9	9
2531321	LA	school	2200840	026	Jefferson Parish	220084001518	26103	Westbank Community School	Regular School	No	Elementary	KG	08	2019	fall	grade_7	9	9
2531875	LA	school	2201680	053	Tangipahoa Parish	220168002399	53052	Tangipahoa Alternative Solutions Program	Regular School	No	High	05	12	2019	fall	grade_7	9	9
2297463	LA	school	2201680	053	Tangipahoa Parish	220168001315	53020	Natalbany Middle	Regular School	No	Middle	04	08	2019	spring	grade_7	89	89
2297517	LA	school	2201740	055	Terrebonne Parish	220174001952	55044	Grand Caillou Middle School	Regular School	No	Middle	05	08	2019	spring	grade_7	89	89
2297552	LA	school	2201830	058	Vernon Parish	220183001664	58009	Pickering High School	Regular School	No	High	07	12	2019	spring	grade_7	89	89
2297735	LA	school		R36	All Orleans		399004	Phillis Wheatley Community School						2019	spring	grade_7	89	89
2531530	LA	school	2201170	R36	All Orleans	220117001938	36161	Benjamin Franklin Elem. Math and Science	Regular School	Yes	Elementary	PK	08	2019	fall	grade_7	89	89
2531894	LA	school	2201740	055	Terrebonne Parish	220174001354	55021	Lacache Middle School	Regular School	No	Middle	05	08	2019	fall	grade_7	89	89
2297011	LA	school	2200900	029	Lafourche Parish	220090000703	29006	East Thibodaux Middle School	Regular School	No	Middle	06	08	2019	spring	grade_7	88	88
2297187	LA	school	2201230	038	Plaquemines Parish	220123002028	38013	South Plaquemines High School	Regular School	No	High	07	12	2019	spring	grade_7	88	88
2297703	LA	school		R36	All Orleans		369003	ReNEW Dolores T. Aaron Elementary						2019	spring	grade_7	88	88
2297736	LA	school		R36	All Orleans		399005	Langston Hughes Charter Academy						2019	spring	grade_7	88	88
2531803	LA	school	2201650	052	St. Tammany Parish	220165001281	52020	Lee Road Junior High School	Regular School	No	Elementary	PK	08	2019	fall	grade_7	88	88
2532120	LA	school		R36	All Orleans		398001	KIPP Believe						2019	fall	grade_7	88	88
2532130	LA	school		R36	All Orleans		399004	Phillis Wheatley Community School						2019	fall	grade_7	88	88
2297137	LA	school	2201170	R36	All Orleans	220117001938	36161	Benjamin Franklin Elem. Math and Science	Regular School	Yes	Elementary	PK	08	2019	spring	grade_7	87	87
2297457	LA	school	2201680	053	Tangipahoa Parish	220168001308	53013	Independence Magnet	Regular School	No	Middle	05	08	2019	spring	grade_7	87	87
2531867	LA	school	2201680	053	Tangipahoa Parish	220168001326	53032	Amite Westside Middle Magnet	Regular School	No	Middle	05	08	2019	fall	grade_7	87	87
2297332	LA	school	2201560	049	St. Landry Parish	220156001190	49019	Lawtell Elementary School	Regular School	No	Elementary	PK	08	2019	spring	grade_7	86	86
2297601	LA	school	2201950	062	West Carroll Parish	220195001472	62006	Oak Grove High School	Regular School	No	High	06	12	2019	spring	grade_7	86	86
2531505	LA	school	2201110	034	Morehouse Parish	220111002359	34003	Beekman Charter School	Regular School	Yes	Other	PK	12	2019	fall	grade_7	86	86
2531561	LA	school	2201200	037	Ouachita Parish	220120001021	37039	Woodlawn Middle School	Regular School	No	Middle	06	08	2019	fall	grade_7	86	86
2531580	LA	school	2201230	038	Plaquemines Parish	220123002028	38013	South Plaquemines High School	Regular School	No	High	07	12	2019	fall	grade_7	86	86
2297105	LA	school	2201050	033	Madison Parish	220105000779	33001	Madison Middle School	Regular School	No	Middle	07	08	2019	spring	grade_7	85	85
2297168	LA	school	2201200	037	Ouachita Parish	220120001021	37039	Woodlawn Middle School	Regular School	No	Middle	06	08	2019	spring	grade_7	85	85
2297389	LA	school	2201620	051	St. Mary Parish	220162001248	51038	B. Edward Boudreaux Middle School	Regular School	No	Middle	06	08	2019	spring	grade_7	85	85
2531978	LA	school	2201890	060	Webster Parish	220189001450	60018	Lakeside Junior-Senior High School	Regular School	No	High	06	12	2019	fall	grade_7	85	85
2531995	LA	school	2201950	062	West Carroll Parish	220195001472	62006	Oak Grove High School	Regular School	No	High	06	12	2019	fall	grade_7	85	85
2296549	LA	school	2200300	009	Caddo Parish	220030000165	9027	Herndon Magnet School	Regular School	No	Elementary	KG	08	2019	spring	grade_7	84	84
2297585	LA	school	2201890	060	Webster Parish	220189001450	60018	Lakeside Junior-Senior High School	Regular School	No	High	06	12	2019	spring	grade_7	84	84
2297719	LA	school		R36	All Orleans		395001	Martin Behrman Charter Acad of Creative Arts & Sci						2019	spring	grade_7	84	84
2297725	LA	school		R36	All Orleans		398001	KIPP Believe						2019	spring	grade_7	84	84
2297778	LA	school		R36	All Orleans		WBC001	Alice M Harte Elementary Charter School						2019	spring	grade_7	84	84
2530853	LA	school	2200120	004	Assumption Parish	220012000054	4007	Napoleonville Middle School	Regular School	No	Middle	05	08	2019	fall	grade_7	84	84
2530940	LA	school	2200300	009	Caddo Parish	220030000165	9027	Herndon Magnet School	Regular School	No	Elementary	KG	08	2019	fall	grade_7	84	84
2531402	LA	school	2200900	029	Lafourche Parish	220090000703	29006	East Thibodaux Middle School	Regular School	No	Middle	06	08	2019	fall	grade_7	84	84