schools: enrollments: 137,628 rows where where state = "LA" sorted by year descending

Data source: Big Local News · About: Big Local

137,628 rows where state = "LA" sorted by year descending

Search:

descending

Link	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
2011063	2011063	LA	school		R36	Orleans Parish		WZF001	Pierre A. Capdau Charter School						2021	fall	pre_kindergarten	16	16
2011062	2011062	LA	school		R36	Orleans Parish		WZB001	Warren Easton Charter High School						2021	fall	pre_kindergarten	0	0
2011061	2011061	LA	school		CHA	Type 2 Charters		WZ8001	GEO Prep Mid-City of Greater Baton Rouge						2021	fall	pre_kindergarten	0	0
2011060	2011060	LA	school		CHA	Type 2 Charters		WJ5001	Collegiate Baton Rouge						2021	fall	pre_kindergarten	0	0
2011059	2011059	LA	school		R36	Orleans Parish		WC3001	IDEA Oscar Dunn						2021	fall	pre_kindergarten	0	0
2011058	2011058	LA	school		R36	Orleans Parish		WC2001	Opportunities Academy						2021	fall	pre_kindergarten	0	0
2011057	2011057	LA	school		R36	Orleans Parish		WBZ001	McDonogh 35 Senior High School						2021	fall	pre_kindergarten	0	0
2011056	2011056	LA	school		CHA	Type 2 Charters		WBY001	Red River Charter Academy						2021	fall	pre_kindergarten	0	0
2011055	2011055	LA	school		CHA	Type 2 Charters		WBX001	GEO Next Generation High School						2021	fall	pre_kindergarten	0	0
2011054	2011054	LA	school		R36	Orleans Parish		WBW001	Living School						2021	fall	pre_kindergarten	0	0
2011053	2011053	LA	school		R36	Orleans Parish		WBV001	Dwight D. Eisenhower Charter School						2021	fall	pre_kindergarten	33	33
2011052	2011052	LA	school		R36	Orleans Parish		WBU001	Rosenwald Collegiate Academy						2021	fall	pre_kindergarten	0	0
2011051	2011051	LA	school		R36	Orleans Parish		WBT001	Audubon Charter School - Gentilly						2021	fall	pre_kindergarten	29	29
2011050	2011050	LA	school		CHA	Type 2 Charters		WBR001	Athlos Academy of Jefferson Parish						2021	fall	pre_kindergarten	0	0
2011049	2011049	LA	school		CHA	Type 2 Charters		WBQ001	New Harmony High Institute						2021	fall	pre_kindergarten	0	0
2011048	2011048	LA	school		R36	Orleans Parish		WBP001	McDonogh 42 Charter School						2021	fall	pre_kindergarten	18	18
2011047	2011047	LA	school		R36	Orleans Parish		WBO001	Einstein Charter at Sherwood Forest						2021	fall	pre_kindergarten	32	32
2011046	2011046	LA	school		R36	Orleans Parish		WBN001	Einstein Charter Middle Sch at Sarah Towles Reed						2021	fall	pre_kindergarten	0	0
2011045	2011045	LA	school		R36	Orleans Parish		WBM001	Einstein Charter High School at Sarah Towles Reed						2021	fall	pre_kindergarten	0	0
2011044	2011044	LA	school		R36	Orleans Parish		WBL001	Wilson Charter School						2021	fall	pre_kindergarten	31	31
2011043	2011043	LA	school		R36	Orleans Parish		WBK001	Bricolage Academy						2021	fall	pre_kindergarten	20	20
2011042	2011042	LA	school		R36	Orleans Parish		WBJ001	ENCORE Academy						2021	fall	pre_kindergarten	21	21
2011041	2011041	LA	school		R36	Orleans Parish		WBI001	New Orleans Charter Science and Mathematics HS						2021	fall	pre_kindergarten	0	0
2011040	2011040	LA	school		R36	Orleans Parish		WBH001	Lake Forest Elementary Charter School						2021	fall	pre_kindergarten	0	0
2011039	2011039	LA	school		R36	Orleans Parish		WBG001	Robert Russa Moton Charter School						2021	fall	pre_kindergarten	21	21
2011038	2011038	LA	school		R36	Orleans Parish		WBF001	Eleanor McMain Secondary School						2021	fall	pre_kindergarten	0	0
2011037	2011037	LA	school		R36	Orleans Parish		WBE001	Lusher Charter School						2021	fall	pre_kindergarten	0	0
2011036	2011036	LA	school		R36	Orleans Parish		WBD001	Edna Karr High School						2021	fall	pre_kindergarten	0	0
2011035	2011035	LA	school		R36	Orleans Parish		WBC001	Alice M Harte Elementary Charter School						2021	fall	pre_kindergarten	42	42
2011034	2011034	LA	school		R36	Orleans Parish		WBB001	Benjamin Franklin High School						2021	fall	pre_kindergarten	0	0
2011033	2011033	LA	school		R36	Orleans Parish		WBA001	Einstein Charter School at Village De L'Est						2021	fall	pre_kindergarten	16	16
2011032	2011032	LA	school		R36	Orleans Parish		WAZ001	Audubon Charter School						2021	fall	pre_kindergarten	56	56
2011031	2011031	LA	school		RBR	Recovery School District - Baton Rouge		WAV001	Democracy Prep Baton Rouge						2021	fall	pre_kindergarten	0	0
2011030	2011030	LA	school		CHA	Type 2 Charters		WAU001	GEO Prep Academy of Greater Baton Rouge						2021	fall	pre_kindergarten	0	0
2011029	2011029	LA	school		CHA	Type 2 Charters		WAQ001	Baton Rouge University Preparatory Elementary						2021	fall	pre_kindergarten	0	0
2011028	2011028	LA	school		CHA	Type 2 Charters		WAL001	JS Clark Leadership Academy						2021	fall	pre_kindergarten	0	0
2011027	2011027	LA	school		CHA	Type 2 Charters		WAK001	Southwest Louisiana Charter Academy						2021	fall	pre_kindergarten	14	14
2011026	2011026	LA	school		CHA	Type 2 Charters		WAG001	Louisiana Virtual Charter Academy						2021	fall	pre_kindergarten	0	0
2011025	2011025	LA	school		RBR	Recovery School District - Baton Rouge		WA7001	Capitol High School						2021	fall	pre_kindergarten	0	0
2011024	2011024	LA	school		CHA	Type 2 Charters		W8A001	Impact Charter School						2021	fall	pre_kindergarten	20	20
2011023	2011023	LA	school		CHA	Type 2 Charters		W7B001	Lafayette Renaissance Charter Academy						2021	fall	pre_kindergarten	0	0
2011022	2011022	LA	school		CHA	Type 2 Charters		W7A001	Louisiana Key Academy						2021	fall	pre_kindergarten	0	0
2011021	2011021	LA	school		CHA	Type 2 Charters		W6B001	Acadiana Renaissance Charter Academy						2021	fall	pre_kindergarten	0	0
2011020	2011020	LA	school		CHA	Type 2 Charters		W5B001	Northeast Claiborne Charter						2021	fall	pre_kindergarten	0	0
2011019	2011019	LA	school		CHA	Type 2 Charters		W4B001	Lake Charles College Prep						2021	fall	pre_kindergarten	0	0
2011018	2011018	LA	school		CHA	Type 2 Charters		W4A001	Delta Charter School MST						2021	fall	pre_kindergarten	0	0
2011017	2011017	LA	school		CHA	Type 2 Charters		W3B001	Iberville Charter Academy						2021	fall	pre_kindergarten	0	0
2011016	2011016	LA	school		CHA	Type 2 Charters		W33001	Lincoln Preparatory School						2021	fall	pre_kindergarten	0	0
2011015	2011015	LA	school		R36	Orleans Parish		W31001	Dr. Martin Luther King Charter School for Sci Tech						2021	fall	pre_kindergarten	40	40
2011014	2011014	LA	school		CHA	Type 2 Charters		W2B001	Willow Charter Academy						2021	fall	pre_kindergarten	0	0
2011013	2011013	LA	school		CHA	Type 2 Charters		W1D001	JCFA Lafayette						2021	fall	pre_kindergarten	0	0
2011012	2011012	LA	school		CHA	Type 2 Charters		W1B001	Advantage Charter Academy						2021	fall	pre_kindergarten	0	0
2011011	2011011	LA	school		CHA	Type 2 Charters		W1A001	JCFA-East						2021	fall	pre_kindergarten	0	0
2011010	2011010	LA	school		CHA	Type 2 Charters		W18001	Noble Minds						2021	fall	pre_kindergarten	0	0
2011009	2011009	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2021	fall	pre_kindergarten	0	0
2011008	2011008	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2021	fall	pre_kindergarten	0	0
2011007	2011007	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2021	fall	pre_kindergarten	0	0
2011006	2011006	LA	school		R36	Orleans Parish		3C3003	Esperanza Charter School						2021	fall	pre_kindergarten	0	0
2011005	2011005	LA	school		R36	Orleans Parish		3C3002	Lafayette Academy Charter School						2021	fall	pre_kindergarten	10	10
2011004	2011004	LA	school		R36	Orleans Parish		3C3001	Foundation Preparatory Academy						2021	fall	pre_kindergarten	0	0
2011003	2011003	LA	school		R36	Orleans Parish		3C2002	Edward Hynes Charter School - UNO						2021	fall	pre_kindergarten	0	0
2011002	2011002	LA	school		R36	Orleans Parish		3C2001	Edward Hynes Charter School - Lakeview						2021	fall	pre_kindergarten	0	0
2011001	2011001	LA	school	2200290	3C1	Thrive Academy	220029002335	3C1001	Thrive Academy	Special Education School	No	High	07	12	2021	fall	pre_kindergarten	0	0
2011000	2011000	LA	school		RBR	Recovery School District - Baton Rouge		3AP004	Glen Oaks Middle School						2021	fall	pre_kindergarten	0	0
2010999	2010999	LA	school		RBR	Recovery School District - Baton Rouge		3AP003	Dalton Charter School						2021	fall	pre_kindergarten	20	20
2010998	2010998	LA	school		RBR	Recovery School District - Baton Rouge		3AP001	Lanier Charter School						2021	fall	pre_kindergarten	20	20
2010997	2010997	LA	school		R36	Orleans Parish		399006	FirstLine Live Oak						2021	fall	pre_kindergarten	6	6
2010996	2010996	LA	school		R36	Orleans Parish		399005	Langston Hughes Charter Academy						2021	fall	pre_kindergarten	34	34
2010995	2010995	LA	school		R36	Orleans Parish		399004	Phillis Wheatley Community School						2021	fall	pre_kindergarten	38	38
2010994	2010994	LA	school		R36	Orleans Parish		399002	Arthur Ashe Charter School						2021	fall	pre_kindergarten	0	0
2010993	2010993	LA	school		R36	Orleans Parish		399001	Samuel J. Green Charter School						2021	fall	pre_kindergarten	14	14
2010992	2010992	LA	school		R36	Orleans Parish		398009	John F. Kennedy High School						2021	fall	pre_kindergarten	0	0
2010991	2010991	LA	school		R36	Orleans Parish		398008	Booker T. Washington High School						2021	fall	pre_kindergarten	0	0
2010990	2010990	LA	school		R36	Orleans Parish		398007	KIPP East						2021	fall	pre_kindergarten	60	60
2010989	2010989	LA	school		R36	Orleans Parish		398006	KIPP Leadership						2021	fall	pre_kindergarten	18	18
2010988	2010988	LA	school		R36	Orleans Parish		398005	Frederick A. Douglass High School						2021	fall	pre_kindergarten	0	0
2010987	2010987	LA	school		R36	Orleans Parish		398004	KIPP Central City						2021	fall	pre_kindergarten	38	38
2010986	2010986	LA	school		R36	Orleans Parish		398002	KIPP Morial						2021	fall	pre_kindergarten	55	55
2010985	2010985	LA	school		R36	Orleans Parish		398001	KIPP Believe						2021	fall	pre_kindergarten	0	0
2010984	2010984	LA	school		R36	Orleans Parish		397001	Sophie B. Wright Institute of Academic Excellence						2021	fall	pre_kindergarten	0	0
2010983	2010983	LA	school	2200054	RLA	Recovery School District - Louisiana	220005400175	396211	Linwood Charter School	Regular School	No	Elementary	PK	08	2021	fall	pre_kindergarten	30	30
2010982	2010982	LA	school		R36	Orleans Parish		395005	Lord Beaconsfield Landry High School						2021	fall	pre_kindergarten	0	0
2010981	2010981	LA	school		R36	Orleans Parish		395001	Martin Behrman Charter Acad of Creative Arts & Sci						2021	fall	pre_kindergarten	52	52
2010980	2010980	LA	school		R36	Orleans Parish		390001	James M. Singleton Charter School						2021	fall	pre_kindergarten	0	0
2010979	2010979	LA	school		RBR	Recovery School District - Baton Rouge		389002	Kenilworth Science and Technology Charter School						2021	fall	pre_kindergarten	0	0
2010978	2010978	LA	school		R36	Orleans Parish		385003	Lawrence D. Crocker College Prep						2021	fall	pre_kindergarten	6	6
2010977	2010977	LA	school		R36	Orleans Parish		385002	Walter L. Cohen College Prep						2021	fall	pre_kindergarten	0	0
2010976	2010976	LA	school		R36	Orleans Parish		382004	Livingston Collegiate Academy						2021	fall	pre_kindergarten	0	0
2010975	2010975	LA	school		R36	Orleans Parish		382002	G W Carver High School						2021	fall	pre_kindergarten	0	0
2010974	2010974	LA	school		R36	Orleans Parish		382001	Abramson Sci Academy						2021	fall	pre_kindergarten	0	0
2010973	2010973	LA	school		R36	Orleans Parish		381001	Akili Academy of New Orleans						2021	fall	pre_kindergarten	37	37
2010972	2010972	LA	school		R36	Orleans Parish		374001	Success @ Thurgood Marshall						2021	fall	pre_kindergarten	0	0
2010971	2010971	LA	school		R36	Orleans Parish		373002	Mildred Osborne Charter School						2021	fall	pre_kindergarten	0	0
2010970	2010970	LA	school		R36	Orleans Parish		373001	Arise Academy						2021	fall	pre_kindergarten	0	0
2010969	2010969	LA	school		R36	Orleans Parish		369006	ReNEW Schaumburg Elementary						2021	fall	pre_kindergarten	17	17
2010968	2010968	LA	school		R36	Orleans Parish		369003	ReNEW Dolores T. Aaron Elementary						2021	fall	pre_kindergarten	29	29
2010967	2010967	LA	school		R36	Orleans Parish		369002	ReNEW SciTech Academy at Laurel						2021	fall	pre_kindergarten	13	13
2010966	2010966	LA	school		R36	Orleans Parish		368001	Morris Jeff Community School						2021	fall	pre_kindergarten	68	68
2010965	2010965	LA	school		R36	Orleans Parish		364001	Fannie C. Williams Charter School						2021	fall	pre_kindergarten	39	39
2010964	2010964	LA	school		R36	Orleans Parish		363002	Paul Habans Charter School						2021	fall	pre_kindergarten	47	47

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);