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 (district_nces_id > :p3 or (district_nces_id = :p3 and rowid > :p2)) order by district_nces_id, 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	total	total_int
2522303	LA	school	2200030	001	Acadia Parish	220003000014	1034	Iota High School	Regular School	No	High	05	12	2019	fall	grade_12	128	128
2522305	LA	school	2200030	001	Acadia Parish	220003002381	1036	AMIKids Acadiana	Regular School	No	Other	04	12	2019	fall	grade_12	1	1
600129	LA	school	2200036	334	New Orleans Center for Creative Arts	220003601499	334001	New Orleans Center for Creative Arts	Special Education School	No	High	09	12	2020	spring	grade_12	52	52
1770395	LA	school	2200036	334	New Orleans Center for Creative Arts	220003601499	334001	New Orleans Center for Creative Arts	Special Education School	No	High	09	12	2021	spring	grade_12	58	58
1994161	LA	school	2200036	334	New Orleans Center for Creative Arts	220003601499	334001	New Orleans Center for Creative Arts	Special Education School	No	High	09	12	2021	fall	grade_12	59	59
2016556	LA	school	2200036	334	New Orleans Center for Creative Arts	220003601499	334001	New Orleans Center for Creative Arts	Special Education School	No	High	09	12	2020	fall	grade_12	53	53
2289206	LA	school	2200036	334	New Orleans Center for Creative Arts	220003601499	334001	New Orleans Center for Creative Arts	Special Education School	No	High	09	12	2019	spring	grade_12	60	60
2523576	LA	school	2200036	334	New Orleans Center for Creative Arts	220003601499	334001	New Orleans Center for Creative Arts	Special Education School	No	High	09	12	2019	fall	grade_12	60	60
600087	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2020	spring	grade_12	0	0
600088	LA	school	2200039	067	Zachary Community School District	220003900406	67002	Northwestern Middle School	Regular School	No	Middle	07	08	2020	spring	grade_12	0	0
600089	LA	school	2200039	067	Zachary Community School District	220003900449	67003	Zachary Elementary School	Regular School	No	Elementary	03	04	2020	spring	grade_12	0	0
600090	LA	school	2200039	067	Zachary Community School District	220003900450	67004	Zachary High School	Regular School	No	High	09	12	2020	spring	grade_12	383	383
600091	LA	school	2200039	067	Zachary Community School District	220003902013	67006	Copper Mill Elementary/Middle School	Regular School	No	Middle	05	06	2020	spring	grade_12	0	0
600092	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2020	spring	grade_12	0	0
600093	LA	school	2200039	067	Zachary Community School District	220003902347	67010	Rollins Place Elementary	Regular School	No	Elementary	01	02	2020	spring	grade_12	0	0
1770362	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2021	spring	grade_12	0	0
1770363	LA	school	2200039	067	Zachary Community School District	220003900406	67002	Northwestern Middle School	Regular School	No	Middle	07	08	2021	spring	grade_12	0	0
1770364	LA	school	2200039	067	Zachary Community School District	220003900449	67003	Zachary Elementary School	Regular School	No	Elementary	03	04	2021	spring	grade_12	0	0
1770365	LA	school	2200039	067	Zachary Community School District	220003900450	67004	Zachary High School	Regular School	No	High	09	12	2021	spring	grade_12	384	384
1770366	LA	school	2200039	067	Zachary Community School District	220003902013	67006	Copper Mill Elementary/Middle School	Regular School	No	Middle	05	06	2021	spring	grade_12	0	0
1770367	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	spring	grade_12	0	0
1770368	LA	school	2200039	067	Zachary Community School District	220003902347	67010	Rollins Place Elementary	Regular School	No	Elementary	01	02	2021	spring	grade_12	0	0
1994123	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2021	fall	grade_12	0	0
1994124	LA	school	2200039	067	Zachary Community School District	220003900406	67002	Northwestern Middle School	Regular School	No	Middle	07	08	2021	fall	grade_12	0	0
1994125	LA	school	2200039	067	Zachary Community School District	220003900449	67003	Zachary Elementary School	Regular School	No	Elementary	03	04	2021	fall	grade_12	0	0
1994126	LA	school	2200039	067	Zachary Community School District	220003900450	67004	Zachary High School	Regular School	No	High	09	12	2021	fall	grade_12	386	386
1994127	LA	school	2200039	067	Zachary Community School District	220003902013	67006	Copper Mill Elementary/Middle School	Regular School	No	Middle	05	06	2021	fall	grade_12	0	0
1994128	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2021	fall	grade_12	0	0
1994129	LA	school	2200039	067	Zachary Community School District	220003902347	67010	Rollins Place Elementary	Regular School	No	Elementary	01	02	2021	fall	grade_12	0	0
2016513	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2020	fall	grade_12	0	0
2016514	LA	school	2200039	067	Zachary Community School District	220003900406	67002	Northwestern Middle School	Regular School	No	Middle	07	08	2020	fall	grade_12	0	0
2016515	LA	school	2200039	067	Zachary Community School District	220003900449	67003	Zachary Elementary School	Regular School	No	Elementary	03	04	2020	fall	grade_12	0	0
2016516	LA	school	2200039	067	Zachary Community School District	220003900450	67004	Zachary High School	Regular School	No	High	09	12	2020	fall	grade_12	387	387
2016517	LA	school	2200039	067	Zachary Community School District	220003902013	67006	Copper Mill Elementary/Middle School	Regular School	No	Middle	05	06	2020	fall	grade_12	0	0
2016518	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2020	fall	grade_12	0	0
2016519	LA	school	2200039	067	Zachary Community School District	220003902347	67010	Rollins Place Elementary	Regular School	No	Elementary	01	02	2020	fall	grade_12	0	0
2289160	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2019	spring	grade_12	0	0
2289161	LA	school	2200039	067	Zachary Community School District	220003900406	67002	Northwestern Middle School	Regular School	No	Middle	07	08	2019	spring	grade_12	0	0
2289162	LA	school	2200039	067	Zachary Community School District	220003900449	67003	Zachary Elementary School	Regular School	No	Elementary	03	04	2019	spring	grade_12	0	0
2289163	LA	school	2200039	067	Zachary Community School District	220003900450	67004	Zachary High School	Regular School	No	High	09	12	2019	spring	grade_12	362	362
2289164	LA	school	2200039	067	Zachary Community School District	220003902013	67006	Copper Mill Elementary/Middle School	Regular School	No	Middle	05	06	2019	spring	grade_12	0	0
2289165	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2019	spring	grade_12	0	0
2289166	LA	school	2200039	067	Zachary Community School District	220003902347	67010	Rollins Place Elementary	Regular School	No	Elementary	01	02	2019	spring	grade_12	0	0
2523530	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2019	fall	grade_12	0	0
2523531	LA	school	2200039	067	Zachary Community School District	220003900406	67002	Northwestern Middle School	Regular School	No	Middle	07	08	2019	fall	grade_12	0	0
2523532	LA	school	2200039	067	Zachary Community School District	220003900449	67003	Zachary Elementary School	Regular School	No	Elementary	03	04	2019	fall	grade_12	0	0
2523533	LA	school	2200039	067	Zachary Community School District	220003900450	67004	Zachary High School	Regular School	No	High	09	12	2019	fall	grade_12	367	367
2523534	LA	school	2200039	067	Zachary Community School District	220003902013	67006	Copper Mill Elementary/Middle School	Regular School	No	Middle	05	06	2019	fall	grade_12	0	0
2523535	LA	school	2200039	067	Zachary Community School District	220003902299	67008	Zachary Early Learning Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_12	0	0
2523536	LA	school	2200039	067	Zachary Community School District	220003902347	67010	Rollins Place Elementary	Regular School	No	Elementary	01	02	2019	fall	grade_12	0	0
600095	LA	school	2200040	068	City of Baker School District	220004000342	68001	Baker Heights Elementary School	Regular School	No	Elementary	PK	05	2020	spring	grade_12	0	0
600096	LA	school	2200040	068	City of Baker School District	220004000344	68002	Baker High School	Regular School	No	High	09	12	2020	spring	grade_12	95	95
600097	LA	school	2200040	068	City of Baker School District	220004000343	68003	Baker Middle School	Regular School	No	Middle	06	08	2020	spring	grade_12	0	0
600098	LA	school	2200040	068	City of Baker School District	220004000410	68005	Park Ridge Academic Magnet School	Regular School	No	Elementary	KG	08	2020	spring	grade_12	0	0
1770370	LA	school	2200040	068	City of Baker School District	220004000342	68001	Baker Heights Elementary School	Regular School	No	Elementary	PK	05	2021	spring	grade_12	0	0
1770371	LA	school	2200040	068	City of Baker School District	220004000344	68002	Baker High School	Regular School	No	High	09	12	2021	spring	grade_12	109	109
1770372	LA	school	2200040	068	City of Baker School District	220004000343	68003	Baker Middle School	Regular School	No	Middle	06	08	2021	spring	grade_12	0	0
1770373	LA	school	2200040	068	City of Baker School District	220004000410	68005	Park Ridge Academic Magnet School	Regular School	No	Elementary	KG	08	2021	spring	grade_12	0	0
1994131	LA	school	2200040	068	City of Baker School District	220004000342	68001	Baker Heights Elementary School	Regular School	No	Elementary	PK	05	2021	fall	grade_12	0	0
1994132	LA	school	2200040	068	City of Baker School District	220004000344	68002	Baker High School	Regular School	No	High	09	12	2021	fall	grade_12	108	108
1994133	LA	school	2200040	068	City of Baker School District	220004000343	68003	Baker Middle School	Regular School	No	Middle	06	08	2021	fall	grade_12	0	0
1994134	LA	school	2200040	068	City of Baker School District	220004000410	68005	Park Ridge Academic Magnet School	Regular School	No	Elementary	KG	08	2021	fall	grade_12	0	0
2016521	LA	school	2200040	068	City of Baker School District	220004000342	68001	Baker Heights Elementary School	Regular School	No	Elementary	PK	05	2020	fall	grade_12	0	0
2016522	LA	school	2200040	068	City of Baker School District	220004000344	68002	Baker High School	Regular School	No	High	09	12	2020	fall	grade_12	98	98
2016523	LA	school	2200040	068	City of Baker School District	220004000343	68003	Baker Middle School	Regular School	No	Middle	06	08	2020	fall	grade_12	0	0
2016524	LA	school	2200040	068	City of Baker School District	220004000410	68005	Park Ridge Academic Magnet School	Regular School	No	Elementary	KG	08	2020	fall	grade_12	0	0
2289168	LA	school	2200040	068	City of Baker School District	220004000342	68001	Baker Heights Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_12	0	0
2289169	LA	school	2200040	068	City of Baker School District	220004000344	68002	Baker High School	Regular School	No	High	09	12	2019	spring	grade_12	117	117
2289170	LA	school	2200040	068	City of Baker School District	220004000343	68003	Baker Middle School	Regular School	No	Middle	06	08	2019	spring	grade_12	0	0
2289171	LA	school	2200040	068	City of Baker School District	220004000345	68004	Bakerfield Elementary School	Regular School	No	Elementary	PK	05	2019	spring	grade_12	0	0
2289172	LA	school	2200040	068	City of Baker School District	220004000410	68005	Park Ridge Academic Magnet School	Regular School	No	Elementary	KG	08	2019	spring	grade_12	0	0
2523538	LA	school	2200040	068	City of Baker School District	220004000342	68001	Baker Heights Elementary School	Regular School	No	Elementary	PK	05	2019	fall	grade_12	0	0
2523539	LA	school	2200040	068	City of Baker School District	220004000344	68002	Baker High School	Regular School	No	High	09	12	2019	fall	grade_12	115	115
2523540	LA	school	2200040	068	City of Baker School District	220004000343	68003	Baker Middle School	Regular School	No	Middle	06	08	2019	fall	grade_12	0	0
2523541	LA	school	2200040	068	City of Baker School District	220004000345	68004	Bakerfield Elementary School	Regular School	No	Elementary	PK	05	2019	fall	grade_12	0	0
2523542	LA	school	2200040	068	City of Baker School District	220004000410	68005	Park Ridge Academic Magnet School	Regular School	No	Elementary	KG	08	2019	fall	grade_12	0	0
600184	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	spring	grade_12	13	13
600185	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	spring	grade_12	7	7
600186	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	spring	grade_12	4	4
1770397	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2021	spring	grade_12	8	8
1770398	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2021	spring	grade_12	10	10
1770399	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2021	spring	grade_12	6	6
1994219	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2021	fall	grade_12	8	8
1994220	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2021	fall	grade_12	9	9
1994221	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2021	fall	grade_12	5	5
2016611	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_12	13	13
2016612	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2020	fall	grade_12	8	8
2016613	LA	school	2200047	A02	Office of Juvenile Justice	220004702462	A02004	Central Southwest Alternative High School	Alternative School	No	Other	KG	12	2020	fall	grade_12	5	5
2289266	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2019	spring	grade_12	5	5
2289267	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2019	spring	grade_12	5	5
2523637	LA	school	2200047	A02	Office of Juvenile Justice	220004701780	A02002	Riverside Alternative High School	Alternative School	No	Other	01	12	2019	fall	grade_12	5	5
2523638	LA	school	2200047	A02	Office of Juvenile Justice	220004701781	A02003	Southside Alternative High School	Alternative School	No	Other	01	12	2019	fall	grade_12	7	7
600165	LA	school	2200054	RLA	Recovery School District - Louisiana	220005400175	396211	Linwood Charter School	Regular School	No	Elementary	PK	08	2020	spring	grade_12	0	0
1770522	LA	school	2200054	RLA	Recovery School District - Louisiana	220005400175	396211	Linwood Charter School	Regular School	No	Elementary	PK	08	2021	spring	grade_12	0	0
1994195	LA	school	2200054	RLA	Recovery School District - Louisiana	220005400175	396211	Linwood Charter School	Regular School	No	Elementary	PK	08	2021	fall	grade_12	0	0
2016592	LA	school	2200054	RLA	Recovery School District - Louisiana	220005400175	396211	Linwood Charter School	Regular School	No	Elementary	PK	08	2020	fall	grade_12	0	0
2289245	LA	school	2200054	RLA	RSD-Direct Run	220005400175	396211	Linwood Charter School	Regular School	No	Elementary	PK	08	2019	spring	grade_12	0	0
598873	LA	school	2200060	002	Allen Parish	220006000024	2001	Elizabeth High School	Regular School	No	Other	PK	12	2020	spring	grade_12	28	28
598874	LA	school	2200060	002	Allen Parish	220006000025	2002	Fairview High School	Regular School	No	Other	PK	12	2020	spring	grade_12	24	24
598875	LA	school	2200060	002	Allen Parish	220006000026	2003	Kinder Elementary School	Regular School	No	Elementary	PK	04	2020	spring	grade_12	0	0
598876	LA	school	2200060	002	Allen Parish	220006000027	2004	Kinder High School	Regular School	No	High	08	12	2020	spring	grade_12	74	74