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
2298021	LA	school	2200330	010	Calcasieu Parish	220033000226	10015	DeQuincy Middle School	Regular School	No	Middle	06	08	2019	spring	grade_8	99	99
2298667	LA	school	2201350	042	Richland Parish	220135001103	42009	Rayville Junior High School	Regular School	No	Middle	07	08	2019	spring	grade_8	99	99
2299136	LA	school	2200054	RLA	RSD-Direct Run	220005400175	396211	Linwood Charter School	Regular School	No	Elementary	PK	08	2019	spring	grade_8	99	99
2532416	LA	school	2200330	010	Calcasieu Parish	220033000226	10015	DeQuincy Middle School	Regular School	No	Middle	06	08	2019	fall	grade_8	99	99
2533199	LA	school	2201620	051	St. Mary Parish	220162001248	51038	B. Edward Boudreaux Middle School	Regular School	No	Middle	06	08	2019	fall	grade_8	99	99
2297841	LA	school	2200060	002	Allen Parish	220006001049	2015	Kinder Middle School	Regular School	No	Middle	05	08	2019	spring	grade_8	98	98
2298505	LA	school	2201020	032	Livingston Parish	220102010339	32038	Springfield Middle School	Regular School	No	Middle	04	08	2019	spring	grade_8	98	98
2298658	LA	school	2201320	041	Red River Parish	220132001530	41011	Red River Junior High School	Regular School	No	Middle	06	08	2019	spring	grade_8	98	98
2298698	LA	school	2201440	045	St. Charles Parish	220144001142	45006	R.K. Smith Middle School	Regular School	No	Middle	06	08	2019	spring	grade_8	98	98
2533055	LA	school	2201320	041	Red River Parish	220132001530	41011	Red River Junior High School	Regular School	No	Middle	06	08	2019	fall	grade_8	98	98
2298968	LA	school	2201830	058	Vernon Parish	220183001415	58012	Rosepine High School	Regular School	No	High	07	12	2019	spring	grade_8	97	97
2299099	LA	school		CHA	Type 2 Charters		337001	Belle Chasse Academy						2019	spring	grade_8	97	97
2299105	LA	school		CHA	Type 2 Charters		346001	Lake Charles Charter Academy						2019	spring	grade_8	97	97
2533095	LA	school	2201440	045	St. Charles Parish	220144001142	45006	R.K. Smith Middle School	Regular School	No	Middle	06	08	2019	fall	grade_8	97	97
2533541	LA	school		R36	All Orleans		398006	KIPP Leadership						2019	fall	grade_8	96	96
2533545	LA	school		R36	All Orleans		399002	Arthur Ashe Charter School						2019	fall	grade_8	96	96
2297880	LA	school	2200150	005	Avoyelles Parish	220015000063	5004	Bunkie Magnet High School	Regular School	No	High	07	12	2019	spring	grade_8	95	95
2299175	LA	school		CHA	Type 2 Charters		W6B001	Acadiana Renaissance Charter Academy						2019	spring	grade_8	95	95
2532275	LA	school	2200150	005	Avoyelles Parish	220015000063	5004	Bunkie Magnet High School	Regular School	No	High	07	12	2019	fall	grade_8	95	95
2532900	LA	school	2201020	032	Livingston Parish	220102010339	32038	Springfield Middle School	Regular School	No	Middle	04	08	2019	fall	grade_8	95	95
2533365	LA	school	2201830	058	Vernon Parish	220183001415	58012	Rosepine High School	Regular School	No	High	07	12	2019	fall	grade_8	95	95
2533497	LA	school		CHA	Type 2 Charters		337001	Belle Chasse Academy						2019	fall	grade_8	95	95
2299146	LA	school		R36	All Orleans		399002	Arthur Ashe Charter School						2019	spring	grade_8	94	94
2533574	LA	school		CHA	Type 2 Charters		W6B001	Acadiana Renaissance Charter Academy						2019	fall	grade_8	94	94
2297961	LA	school	2200300	009	Caddo Parish	220030000163	9025	Green Oaks Performing Arts Academy	Regular School	No	High	07	12	2019	spring	grade_8	93	93
2298095	LA	school	2200480	015	Concordia Parish	220048000318	15003	Ferriday Junior High School	Regular School	No	Middle	06	08	2019	spring	grade_8	93	93
2298112	LA	school	2200510	016	DeSoto Parish	220051000626	16020	Mansfield Middle School	Regular School	No	Middle	05	08	2019	spring	grade_8	93	93
2299118	LA	school		R36	All Orleans		369006	ReNEW Schaumburg Elementary						2019	spring	grade_8	93	93
2532356	LA	school	2200300	009	Caddo Parish	220030000163	9025	Green Oaks Performing Arts Academy	Regular School	No	High	07	12	2019	fall	grade_8	93	93
2533509	LA	school		R36	All Orleans		363001	Harriet Tubman Charter School						2019	fall	grade_8	93	93
2297804	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	grade_8	92	92
2299110	LA	school		R36	All Orleans		363001	Harriet Tubman Charter School						2019	spring	grade_8	92	92
2532208	LA	school	2200030	001	Acadia Parish	220003001015	1015	Iota Middle School	Regular School	No	Middle	06	08	2019	fall	grade_8	92	92
2533576	LA	school		CHA	Type 2 Charters		W7B001	Lafayette Renaissance Charter Academy						2019	fall	grade_8	92	92
2298481	LA	school	2201020	032	Livingston Parish	220102000761	32008	Doyle High School	Regular School	No	High	06	12	2019	spring	grade_8	91	91
2299083	LA	school		R36	All Orleans		300001	Pierre A. Capdau Charter School at Avery Alexander						2019	spring	grade_8	91	91
2532507	LA	school	2200510	016	DeSoto Parish	220051000626	16020	Mansfield Middle School	Regular School	No	Middle	05	08	2019	fall	grade_8	91	91
2298241	LA	school	2200720	023	Iberia Parish	220072000511	23007	Delcambre High School	Regular School	No	High	06	12	2019	spring	grade_8	90	90
2532199	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	grade_8	90	90
2533284	LA	school	2201680	053	Tangipahoa Parish	220168001326	53032	Amite Westside Middle Magnet	Regular School	No	Middle	05	08	2019	fall	grade_8	90	90
2533395	LA	school	2201890	060	Webster Parish	220189001450	60018	Lakeside Junior-Senior High School	Regular School	No	High	06	12	2019	fall	grade_8	90	90
2533547	LA	school		R36	All Orleans		399004	Phillis Wheatley Community School						2019	fall	grade_8	90	90
2298471	LA	school		031	Lincoln Parish		31022	Howard School						2019	spring	grade_8	9	9
2298656	LA	school	2201320	041	Red River Parish	220132000784	41008	Ware Youth Center	Regular School	No	Other	KG	12	2019	spring	grade_8	9	9
2299082	LA	school	2280100	101	Special School District	228010002356	101038	Northlake Youth Academy	Special Education School	No	Other	KG	12	2019	spring	grade_8	9	9
2299184	LA	school		CHA	Type 2 Charters		WAR001	Tangi Academy						2019	spring	grade_8	9	9
2533290	LA	school	2201680	053	Tangipahoa Parish	220168010414	53045	Florida Parishes Juvenile Detention Cntr.	Alternative School	No	Other	03	12	2019	fall	grade_8	9	9
2299149	LA	school		R36	All Orleans		399005	Langston Hughes Charter Academy						2019	spring	grade_8	89	89
2532947	LA	school	2201170	R36	All Orleans	220117001938	36161	Benjamin Franklin Elem. Math and Science	Regular School	Yes	Elementary	PK	08	2019	fall	grade_8	89	89
2533154	LA	school	2201560	049	St. Landry Parish	220156001213	49042	Sunset Elementary School	Regular School	No	Middle	05	08	2019	fall	grade_8	89	89
2533548	LA	school		R36	All Orleans		399005	Langston Hughes Charter Academy						2019	fall	grade_8	89	89
2297813	LA	school	2200030	001	Acadia Parish	220003001015	1015	Iota Middle School	Regular School	No	Middle	06	08	2019	spring	grade_8	88	88
2298550	LA	school	2201170	R36	All Orleans	220117001938	36161	Benjamin Franklin Elem. Math and Science	Regular School	Yes	Elementary	PK	08	2019	spring	grade_8	88	88
2298998	LA	school	2201890	060	Webster Parish	220189001450	60018	Lakeside Junior-Senior High School	Regular School	No	High	06	12	2019	spring	grade_8	88	88
2299148	LA	school		R36	All Orleans		399004	Phillis Wheatley Community School						2019	spring	grade_8	88	88
2299177	LA	school		CHA	Type 2 Charters		W7B001	Lafayette Renaissance Charter Academy						2019	spring	grade_8	88	88
2532490	LA	school	2200480	015	Concordia Parish	220048000318	15003	Ferriday Junior High School	Regular School	No	Middle	06	08	2019	fall	grade_8	88	88
2532636	LA	school	2200720	023	Iberia Parish	220072000511	23007	Delcambre High School	Regular School	No	High	06	12	2019	fall	grade_8	88	88
2532819	LA	school	2200900	029	Lafourche Parish	220090000703	29006	East Thibodaux Middle School	Regular School	No	Middle	06	08	2019	fall	grade_8	88	88
2533220	LA	school	2201650	052	St. Tammany Parish	220165001281	52020	Lee Road Junior High School	Regular School	No	Elementary	PK	08	2019	fall	grade_8	88	88
2533481	LA	school		R36	All Orleans		300001	Pierre A. Capdau Charter School at Avery Alexander						2019	fall	grade_8	88	88
2298005	LA	school	2200300	009	Caddo Parish	220030002431	9111	AmiKiDs Caddo	Regular School	Yes	Middle	06	08	2019	spring	grade_8	87	87
2298526	LA	school	2201110	034	Morehouse Parish	220111002359	34003	Beekman Charter School	Regular School	Yes	Other	PK	12	2019	spring	grade_8	87	87
2298600	LA	school	2201230	038	Plaquemines Parish	220123002028	38013	South Plaquemines High School	Regular School	No	High	07	12	2019	spring	grade_8	87	87
2298757	LA	school	2201560	049	St. Landry Parish	220156001213	49042	Sunset Elementary School	Regular School	No	Middle	05	08	2019	spring	grade_8	87	87
2298823	LA	school	2201650	052	St. Tammany Parish	220165001281	52020	Lee Road Junior High School	Regular School	No	Elementary	PK	08	2019	spring	grade_8	87	87
2299115	LA	school		R36	All Orleans		369002	ReNEW SciTech Academy at Laurel						2019	spring	grade_8	87	87
2532876	LA	school	2201020	032	Livingston Parish	220102000761	32008	Doyle High School	Regular School	No	High	06	12	2019	fall	grade_8	87	87
2532997	LA	school	2201230	038	Plaquemines Parish	220123002028	38013	South Plaquemines High School	Regular School	No	High	07	12	2019	fall	grade_8	87	87
2533085	LA	school	2201410	044	St. Bernard Parish	220141002065	44023	St. Bernard Middle School	Regular School	No	Middle	06	08	2019	fall	grade_8	87	87
2298424	LA	school	2200900	029	Lafourche Parish	220090000703	29006	East Thibodaux Middle School	Regular School	No	Middle	06	08	2019	spring	grade_8	86	86
2298745	LA	school	2201560	049	St. Landry Parish	220156001190	49019	Lawtell Elementary School	Regular School	No	Elementary	PK	08	2019	spring	grade_8	86	86
2532572	LA	school	2200540	017	East Baton Rouge Parish	220054000673	17111	Community School For Apprenticeship Learning	Regular School	Yes	Middle	06	08	2019	fall	grade_8	86	86
2533514	LA	school		R36	All Orleans		369002	ReNEW SciTech Academy at Laurel						2019	fall	grade_8	86	86
2298177	LA	school	2200540	017	East Baton Rouge Parish	220054000673	17111	Community School For Apprenticeship Learning	Regular School	Yes	Middle	06	08	2019	spring	grade_8	85	85
2533142	LA	school	2201560	049	St. Landry Parish	220156001190	49019	Lawtell Elementary School	Regular School	No	Elementary	PK	08	2019	fall	grade_8	85	85
2533590	LA	school		R36	All Orleans		WBC001	Alice M Harte Elementary Charter School						2019	fall	grade_8	85	85
2298052	LA	school	2200330	010	Calcasieu Parish	220033000271	10057	Vinton Middle School	Regular School	No	Middle	06	08	2019	spring	grade_8	84	84
2298688	LA	school	2201410	044	St. Bernard Parish	220141002065	44023	St. Bernard Middle School	Regular School	No	Middle	06	08	2019	spring	grade_8	84	84
2299061	LA	school	2200040	068	City of Baker School District	220004000343	68003	Baker Middle School	Regular School	No	Middle	06	08	2019	spring	grade_8	84	84
2299191	LA	school		R36	All Orleans		WBC001	Alice M Harte Elementary Charter School						2019	spring	grade_8	84	84
2533517	LA	school		R36	All Orleans		369006	ReNEW Schaumburg Elementary						2019	fall	grade_8	84	84
2298887	LA	school	2201680	053	Tangipahoa Parish	220168001326	53032	Amite Westside Middle Magnet	Regular School	No	Middle	05	08	2019	spring	grade_8	83	83
2532642	LA	school	2200720	023	Iberia Parish	220072000523	23020	Loreauville High School	Regular School	No	High	07	12	2019	fall	grade_8	83	83
2532922	LA	school	2201110	034	Morehouse Parish	220111002359	34003	Beekman Charter School	Regular School	Yes	Other	PK	12	2019	fall	grade_8	83	83
2533108	LA	school	2201470	046	St. Helena Parish	220147001154	46002	St. Helena College and Career Academy	Regular School	No	High	07	12	2019	fall	grade_8	83	83
2298440	LA	school	2200900	029	Lafourche Parish	220090000701	29024	Sixth Ward Middle School	Regular School	No	Middle	06	08	2019	spring	grade_8	82	82
2298518	LA	school	2201050	033	Madison Parish	220105000779	33001	Madison Middle School	Regular School	No	Middle	07	08	2019	spring	grade_8	82	82
2532447	LA	school	2200330	010	Calcasieu Parish	220033000271	10057	Vinton Middle School	Regular School	No	Middle	06	08	2019	fall	grade_8	82	82
2297873	LA	school	2200120	004	Assumption Parish	220012000052	4005	Labadieville Middle School	Regular School	No	Middle	05	08	2019	spring	grade_8	81	81
2298711	LA	school	2201470	046	St. Helena Parish	220147001154	46002	St. Helena College and Career Academy	Regular School	No	High	07	12	2019	spring	grade_8	81	81
2298728	LA	school	2201530	048	St. John the Baptist Parish	220153002004	48021	Lake Pontchartrain Elementary School	Regular School	No	Elementary	PK	08	2019	spring	grade_8	81	81
2298775	LA	school	2201590	050	St. Martin Parish	220159001224	50009	Parks Middle School	Regular School	No	Middle	04	08	2019	spring	grade_8	81	81
2532913	LA	school	2201050	033	Madison Parish	220105000779	33001	Madison Middle School	Regular School	No	Middle	07	08	2019	fall	grade_8	81	81
2533172	LA	school	2201590	050	St. Martin Parish	220159001224	50009	Parks Middle School	Regular School	No	Middle	04	08	2019	fall	grade_8	81	81
2533586	LA	school		RBR	RSD-Baton Rouge		WAX001	Baton Rouge College Prep						2019	fall	grade_8	81	81
2297875	LA	school	2200120	004	Assumption Parish	220012000054	4007	Napoleonville Middle School	Regular School	No	Middle	05	08	2019	spring	grade_8	80	80
2298357	LA	school	2200840	026	Jefferson Parish	220084000638	26126	Young Audiences Charter School	Regular School	Yes	Elementary	KG	08	2019	spring	grade_8	80	80
2532752	LA	school	2200840	026	Jefferson Parish	220084000638	26126	Young Audiences Charter School	Regular School	Yes	Elementary	KG	08	2019	fall	grade_8	80	80
2532835	LA	school	2200900	029	Lafourche Parish	220090000701	29024	Sixth Ward Middle School	Regular School	No	Middle	06	08	2019	fall	grade_8	80	80
2533125	LA	school	2201530	048	St. John the Baptist Parish	220153002004	48021	Lake Pontchartrain Elementary School	Regular School	No	Elementary	PK	08	2019	fall	grade_8	80	80