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 and (district < :p2 or district is null or (district = :p2 and rowid > :p1)) order by district desc, rowid 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
2532032	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2019	fall	grade_7												0												0
2532033	LA	school	2200039	067	Zachary Community School District	220003900406	67002	Northwestern Middle School	Regular School	No	Middle	07	08	2019	fall	grade_7												422												422
2532034	LA	school	2200039	067	Zachary Community School District	220003900449	67003	Zachary Elementary School	Regular School	No	Elementary	03	04	2019	fall	grade_7												0												0
2532035	LA	school	2200039	067	Zachary Community School District	220003900450	67004	Zachary High School	Regular School	No	High	09	12	2019	fall	grade_7												0												0
2532036	LA	school	2200039	067	Zachary Community School District	220003902013	67006	Copper Mill Elementary/Middle School	Regular School	No	Middle	05	06	2019	fall	grade_7												0												0
2532037	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_7												0												0
2532038	LA	school	2200039	067	Zachary Community School District	220003902347	67010	Rollins Place Elementary	Regular School	No	Elementary	01	02	2019	fall	grade_7												0												0
2532039	LA	school		067	Zachary Community School District		67700	Zachary Community Central Office						2019	fall	grade_7												0												0
2533449	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2019	fall	grade_8												0												0
2533450	LA	school	2200039	067	Zachary Community School District	220003900406	67002	Northwestern Middle School	Regular School	No	Middle	07	08	2019	fall	grade_8												414												414
2533451	LA	school	2200039	067	Zachary Community School District	220003900449	67003	Zachary Elementary School	Regular School	No	Elementary	03	04	2019	fall	grade_8												0												0
2533452	LA	school	2200039	067	Zachary Community School District	220003900450	67004	Zachary High School	Regular School	No	High	09	12	2019	fall	grade_8												0												0
2533453	LA	school	2200039	067	Zachary Community School District	220003902013	67006	Copper Mill Elementary/Middle School	Regular School	No	Middle	05	06	2019	fall	grade_8												0												0
2533454	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_8												0												0
2533455	LA	school	2200039	067	Zachary Community School District	220003902347	67010	Rollins Place Elementary	Regular School	No	Elementary	01	02	2019	fall	grade_8												0												0
2533456	LA	school		067	Zachary Community School District		67700	Zachary Community Central Office						2019	fall	grade_8												0												0
2534866	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2019	fall	grade_9												0												0
2534867	LA	school	2200039	067	Zachary Community School District	220003900406	67002	Northwestern Middle School	Regular School	No	Middle	07	08	2019	fall	grade_9												0												0
2534868	LA	school	2200039	067	Zachary Community School District	220003900449	67003	Zachary Elementary School	Regular School	No	Elementary	03	04	2019	fall	grade_9												0												0
2534869	LA	school	2200039	067	Zachary Community School District	220003900450	67004	Zachary High School	Regular School	No	High	09	12	2019	fall	grade_9												382												382
2534870	LA	school	2200039	067	Zachary Community School District	220003902013	67006	Copper Mill Elementary/Middle School	Regular School	No	Middle	05	06	2019	fall	grade_9												0												0
2534871	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_9												0												0
2534872	LA	school	2200039	067	Zachary Community School District	220003902347	67010	Rollins Place Elementary	Regular School	No	Elementary	01	02	2019	fall	grade_9												0												0
2534873	LA	school		067	Zachary Community School District		67700	Zachary Community Central Office						2019	fall	grade_9												0												0
2536283	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2019	fall	grade_9_transitional												0												0
2536284	LA	school	2200039	067	Zachary Community School District	220003900406	67002	Northwestern Middle School	Regular School	No	Middle	07	08	2019	fall	grade_9_transitional												0												0
2536285	LA	school	2200039	067	Zachary Community School District	220003900449	67003	Zachary Elementary School	Regular School	No	Elementary	03	04	2019	fall	grade_9_transitional												0												0
2536286	LA	school	2200039	067	Zachary Community School District	220003900450	67004	Zachary High School	Regular School	No	High	09	12	2019	fall	grade_9_transitional												33												33
2536287	LA	school	2200039	067	Zachary Community School District	220003902013	67006	Copper Mill Elementary/Middle School	Regular School	No	Middle	05	06	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
2536289	LA	school	2200039	067	Zachary Community School District	220003902347	67010	Rollins Place Elementary	Regular School	No	Elementary	01	02	2019	fall	grade_9_transitional												0												0
2536290	LA	school		067	Zachary Community School District		67700	Zachary Community Central Office						2019	fall	grade_9_transitional												0												0
2537700	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2019	fall	kindergarten												394												394
2537701	LA	school	2200039	067	Zachary Community School District	220003900406	67002	Northwestern Middle School	Regular School	No	Middle	07	08	2019	fall	kindergarten												0												0
2537702	LA	school	2200039	067	Zachary Community School District	220003900449	67003	Zachary Elementary School	Regular School	No	Elementary	03	04	2019	fall	kindergarten												0												0
2537703	LA	school	2200039	067	Zachary Community School District	220003900450	67004	Zachary High School	Regular School	No	High	09	12	2019	fall	kindergarten												0												0
2537704	LA	school	2200039	067	Zachary Community School District	220003902013	67006	Copper Mill Elementary/Middle School	Regular School	No	Middle	05	06	2019	fall	kindergarten												0												0
2537705	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	kindergarten												0												0
2537706	LA	school	2200039	067	Zachary Community School District	220003902347	67010	Rollins Place Elementary	Regular School	No	Elementary	01	02	2019	fall	kindergarten												0												0
2537707	LA	school		067	Zachary Community School District		67700	Zachary Community Central Office						2019	fall	kindergarten												0												0
2539117	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2019	fall	pk_12_total	182.0	180.0	6.0	0.0	6.0	1.0	19.0	207.0	187.0	1.0	208.0	394	182	180	6	0	6	1	19	207	187	1	208	394
2539118	LA	school	2200039	067	Zachary Community School District	220003900406	67002	Northwestern Middle School	Regular School	No	Middle	07	08	2019	fall	pk_12_total	352.0	427.0	18.0	0.0	7.0	0.0	32.0	425.0	411.0	2.0	419.0	836	352	427	18	0	7	0	32	425	411	2	419	836
2539119	LA	school	2200039	067	Zachary Community School District	220003900449	67003	Zachary Elementary School	Regular School	No	Elementary	03	04	2019	fall	pk_12_total	359.0	401.0	16.0	0.0	7.0	0.0	33.0	415.0	401.0	3.0	429.0	816	359	401	16	0	7	0	33	415	401	3	429	816
2539120	LA	school	2200039	067	Zachary Community School District	220003900450	67004	Zachary High School	Regular School	No	High	09	12	2019	fall	pk_12_total	639.0	871.0	26.0	1.0	18.0	1.0	33.0	789.0	799.9999999999999	8.0	742.0	1589	639	871	26	1	18	1	33	789		8	742	1589
2539121	LA	school	2200039	067	Zachary Community School District	220003902013	67006	Copper Mill Elementary/Middle School	Regular School	No	Middle	05	06	2019	fall	pk_12_total	350.0	477.0	15.0	0.0	18.0	0.0	36.0	453.0	443.0	6.0	454.0	896	350	477	15	0	18	0	36	453	443	6	454	896
2539122	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	pk_12_total	115.0	122.0	5.0	0.0	2.0	1.0	6.0	133.0	118.0	0.0	111.0	251	115	122	5	0	2	1	6	133	118	0	111	251
2539123	LA	school	2200039	067	Zachary Community School District	220003902347	67010	Rollins Place Elementary	Regular School	No	Elementary	01	02	2019	fall	pk_12_total	366.0	377.0	11.0	0.0	12.0	0.0	29.0	410.0	385.0	2.0	394.0	795	366	377	11	0	12	0	29	410	385	2	394	795
2539124	LA	school		067	Zachary Community School District		67700	Zachary Community Central Office						2019	fall	pk_12_total	3.0	6.0	0.0	0.0	0.0	0.0	0.0	8.0	1.0	0.0	4.0	9	3	6	0	0	0	0	0	8	1	0	4	9
2540534	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2019	fall	pre_kindergarten												0												0
2540535	LA	school	2200039	067	Zachary Community School District	220003900406	67002	Northwestern Middle School	Regular School	No	Middle	07	08	2019	fall	pre_kindergarten												0												0
2540536	LA	school	2200039	067	Zachary Community School District	220003900449	67003	Zachary Elementary School	Regular School	No	Elementary	03	04	2019	fall	pre_kindergarten												0												0
2540537	LA	school	2200039	067	Zachary Community School District	220003900450	67004	Zachary High School	Regular School	No	High	09	12	2019	fall	pre_kindergarten												0												0
2540538	LA	school	2200039	067	Zachary Community School District	220003902013	67006	Copper Mill Elementary/Middle School	Regular School	No	Middle	05	06	2019	fall	pre_kindergarten												0												0
2540539	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	pre_kindergarten												225												225
2540540	LA	school	2200039	067	Zachary Community School District	220003902347	67010	Rollins Place Elementary	Regular School	No	Elementary	01	02	2019	fall	pre_kindergarten												0												0
2540541	LA	school		067	Zachary Community School District		67700	Zachary Community Central Office						2019	fall	pre_kindergarten												0												0
595857	LA	school	2202010	064	Winn Parish	220201001478	64001	Atlanta High School	Regular School	No	Other	PK	12	2020	spring	grade_1												18												18
595858	LA	school	2202010	064	Winn Parish	220201001479	64002	Calvin High School	Regular School	No	Other	PK	12	2020	spring	grade_1												19												19
595859	LA	school	2202010	064	Winn Parish	220201001480	64003	Dodson High School	Regular School	No	Other	PK	12	2020	spring	grade_1												15												15
595860	LA	school	2202010	064	Winn Parish	220201001484	64006	Winnfield Primary School	Regular School	No	Elementary	PK	04	2020	spring	grade_1												88												88
595861	LA	school	2202010	064	Winn Parish	220201001486	64008	Winnfield Middle School	Regular School	No	Middle	05	08	2020	spring	grade_1												0												0
595862	LA	school	2202010	064	Winn Parish	220201001487	64009	Winnfield High School	Regular School	No	High	09	12	2020	spring	grade_1												0												0
597257	LA	school	2202010	064	Winn Parish	220201001478	64001	Atlanta High School	Regular School	No	Other	PK	12	2020	spring	grade_10												14												14
597258	LA	school	2202010	064	Winn Parish	220201001479	64002	Calvin High School	Regular School	No	Other	PK	12	2020	spring	grade_10												27												27
597259	LA	school	2202010	064	Winn Parish	220201001480	64003	Dodson High School	Regular School	No	Other	PK	12	2020	spring	grade_10												24												24
597260	LA	school	2202010	064	Winn Parish	220201001484	64006	Winnfield Primary School	Regular School	No	Elementary	PK	04	2020	spring	grade_10												0												0
597261	LA	school	2202010	064	Winn Parish	220201001486	64008	Winnfield Middle School	Regular School	No	Middle	05	08	2020	spring	grade_10												0												0
597262	LA	school	2202010	064	Winn Parish	220201001487	64009	Winnfield High School	Regular School	No	High	09	12	2020	spring	grade_10												87												87
598657	LA	school	2202010	064	Winn Parish	220201001478	64001	Atlanta High School	Regular School	No	Other	PK	12	2020	spring	grade_11												14												14
598658	LA	school	2202010	064	Winn Parish	220201001479	64002	Calvin High School	Regular School	No	Other	PK	12	2020	spring	grade_11												24												24
598659	LA	school	2202010	064	Winn Parish	220201001480	64003	Dodson High School	Regular School	No	Other	PK	12	2020	spring	grade_11												24												24
598660	LA	school	2202010	064	Winn Parish	220201001484	64006	Winnfield Primary School	Regular School	No	Elementary	PK	04	2020	spring	grade_11												0												0
598661	LA	school	2202010	064	Winn Parish	220201001486	64008	Winnfield Middle School	Regular School	No	Middle	05	08	2020	spring	grade_11												0												0
598662	LA	school	2202010	064	Winn Parish	220201001487	64009	Winnfield High School	Regular School	No	High	09	12	2020	spring	grade_11												80												80
600057	LA	school	2202010	064	Winn Parish	220201001478	64001	Atlanta High School	Regular School	No	Other	PK	12	2020	spring	grade_12												9												9
600058	LA	school	2202010	064	Winn Parish	220201001479	64002	Calvin High School	Regular School	No	Other	PK	12	2020	spring	grade_12												16												16
600059	LA	school	2202010	064	Winn Parish	220201001480	64003	Dodson High School	Regular School	No	Other	PK	12	2020	spring	grade_12												24												24
600060	LA	school	2202010	064	Winn Parish	220201001484	64006	Winnfield Primary School	Regular School	No	Elementary	PK	04	2020	spring	grade_12												0												0
600061	LA	school	2202010	064	Winn Parish	220201001486	64008	Winnfield Middle School	Regular School	No	Middle	05	08	2020	spring	grade_12												0												0
600062	LA	school	2202010	064	Winn Parish	220201001487	64009	Winnfield High School	Regular School	No	High	09	12	2020	spring	grade_12												87												87
601457	LA	school	2202010	064	Winn Parish	220201001478	64001	Atlanta High School	Regular School	No	Other	PK	12	2020	spring	grade_2												20												20
601458	LA	school	2202010	064	Winn Parish	220201001479	64002	Calvin High School	Regular School	No	Other	PK	12	2020	spring	grade_2												23												23
601459	LA	school	2202010	064	Winn Parish	220201001480	64003	Dodson High School	Regular School	No	Other	PK	12	2020	spring	grade_2												17												17
601460	LA	school	2202010	064	Winn Parish	220201001484	64006	Winnfield Primary School	Regular School	No	Elementary	PK	04	2020	spring	grade_2												81												81
601461	LA	school	2202010	064	Winn Parish	220201001486	64008	Winnfield Middle School	Regular School	No	Middle	05	08	2020	spring	grade_2												0												0
601462	LA	school	2202010	064	Winn Parish	220201001487	64009	Winnfield High School	Regular School	No	High	09	12	2020	spring	grade_2												0												0
602857	LA	school	2202010	064	Winn Parish	220201001478	64001	Atlanta High School	Regular School	No	Other	PK	12	2020	spring	grade_3												18												18
602858	LA	school	2202010	064	Winn Parish	220201001479	64002	Calvin High School	Regular School	No	Other	PK	12	2020	spring	grade_3												27												27
602859	LA	school	2202010	064	Winn Parish	220201001480	64003	Dodson High School	Regular School	No	Other	PK	12	2020	spring	grade_3												25												25
602860	LA	school	2202010	064	Winn Parish	220201001484	64006	Winnfield Primary School	Regular School	No	Elementary	PK	04	2020	spring	grade_3												81												81
602861	LA	school	2202010	064	Winn Parish	220201001486	64008	Winnfield Middle School	Regular School	No	Middle	05	08	2020	spring	grade_3												0												0
602862	LA	school	2202010	064	Winn Parish	220201001487	64009	Winnfield High School	Regular School	No	High	09	12	2020	spring	grade_3												0												0
604257	LA	school	2202010	064	Winn Parish	220201001478	64001	Atlanta High School	Regular School	No	Other	PK	12	2020	spring	grade_4												13												13
604258	LA	school	2202010	064	Winn Parish	220201001479	64002	Calvin High School	Regular School	No	Other	PK	12	2020	spring	grade_4												22												22
604259	LA	school	2202010	064	Winn Parish	220201001480	64003	Dodson High School	Regular School	No	Other	PK	12	2020	spring	grade_4												27												27
604260	LA	school	2202010	064	Winn Parish	220201001484	64006	Winnfield Primary School	Regular School	No	Elementary	PK	04	2020	spring	grade_4												107												107
604261	LA	school	2202010	064	Winn Parish	220201001486	64008	Winnfield Middle School	Regular School	No	Middle	05	08	2020	spring	grade_4												0												0
604262	LA	school	2202010	064	Winn Parish	220201001487	64009	Winnfield High School	Regular School	No	High	09	12	2020	spring	grade_4												0												0
605657	LA	school	2202010	064	Winn Parish	220201001478	64001	Atlanta High School	Regular School	No	Other	PK	12	2020	spring	grade_5												15												15
605658	LA	school	2202010	064	Winn Parish	220201001479	64002	Calvin High School	Regular School	No	Other	PK	12	2020	spring	grade_5												29												29
605659	LA	school	2202010	064	Winn Parish	220201001480	64003	Dodson High School	Regular School	No	Other	PK	12	2020	spring	grade_5												25												25