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 (ccd_school_high_grade < :p2 or ccd_school_high_grade is null or (ccd_school_high_grade = :p2 and rowid > :p1)) order by ccd_school_high_grade 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
2531168	LA	school	2200540	017	East Baton Rouge Parish	220054002360	17143	Delmont Pre-K and Kindergarten Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_7												0												0
2531381	LA	school	2200870	028	Lafayette Parish	220087000691	28033	Truman Early Childhood Education Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_7												0												0
2531450	LA	school	2200990	031	Lincoln Parish	220099002304	31023	Lincoln Parish Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	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
2532585	LA	school	2200540	017	East Baton Rouge Parish	220054002360	17143	Delmont Pre-K and Kindergarten Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_8												0												0
2532798	LA	school	2200870	028	Lafayette Parish	220087000691	28033	Truman Early Childhood Education Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_8												0												0
2532867	LA	school	2200990	031	Lincoln Parish	220099002304	31023	Lincoln Parish Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	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
2534002	LA	school	2200540	017	East Baton Rouge Parish	220054002360	17143	Delmont Pre-K and Kindergarten Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_9												0												0
2534215	LA	school	2200870	028	Lafayette Parish	220087000691	28033	Truman Early Childhood Education Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_9												0												0
2534284	LA	school	2200990	031	Lincoln Parish	220099002304	31023	Lincoln Parish Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	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
2535419	LA	school	2200540	017	East Baton Rouge Parish	220054002360	17143	Delmont Pre-K and Kindergarten Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_9_transitional												0												0
2535632	LA	school	2200870	028	Lafayette Parish	220087000691	28033	Truman Early Childhood Education Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	grade_9_transitional												0												0
2535701	LA	school	2200990	031	Lincoln Parish	220099002304	31023	Lincoln Parish Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	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
2536836	LA	school	2200540	017	East Baton Rouge Parish	220054002360	17143	Delmont Pre-K and Kindergarten Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	kindergarten												0												0
2537049	LA	school	2200870	028	Lafayette Parish	220087000691	28033	Truman Early Childhood Education Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	kindergarten												0												0
2537118	LA	school	2200990	031	Lincoln Parish	220099002304	31023	Lincoln Parish Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	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
2538253	LA	school	2200540	017	East Baton Rouge Parish	220054002360	17143	Delmont Pre-K and Kindergarten Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	pk_12_total	2.0	203.0	2.0	1.0	0.0	0.0	1.0	110.0	99.0	0.0	201.0	209	2	203	2	1	0	0	1	110	99	0	201	209
2538466	LA	school	2200870	028	Lafayette Parish	220087000691	28033	Truman Early Childhood Education Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	pk_12_total	81.0	309.0	54.0	1.0	3.0	0.0	9.0	232.0	225.0	49.0	414.0	457	81	309	54	1	3	0	9	232	225	49	414	457
2538535	LA	school	2200990	031	Lincoln Parish	220099002304	31023	Lincoln Parish Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	pk_12_total	124.0	101.0	14.0	0.0	6.0	1.0	2.0	144.0	104.0	0.0	138.0	248	124	101	14	0	6	1	2	144	104	0	138	248
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
2539670	LA	school	2200540	017	East Baton Rouge Parish	220054002360	17143	Delmont Pre-K and Kindergarten Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	pre_kindergarten												194												194
2539883	LA	school	2200870	028	Lafayette Parish	220087000691	28033	Truman Early Childhood Education Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	pre_kindergarten												416												416
2539952	LA	school	2200990	031	Lincoln Parish	220099002304	31023	Lincoln Parish Early Childhood Center	Regular School	No	Prekindergarten	PK	PK	2019	fall	pre_kindergarten												210												210
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
594643	LA	school	2200030	001	Acadia Parish	220003000003	1003	Central Rayne Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_1												0												0
594649	LA	school	2200030	001	Acadia Parish	220003000008	1009	Crowley Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_1												0												0
594802	LA	school	2200300	009	Caddo Parish	220030000159	9021	Eighty-First Street ECE Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_1												0												0
594971	LA	school	2200540	017	East Baton Rouge Parish	220054001920	17031	Southdowns School	Special Education School	No	Elementary	PK	KG	2020	spring	grade_1												0												0
595394	LA	school	2201170	R36	Orleans Parish	220117002468	36199	Edward Hynes Charter School (UNO Campus)	Regular School	Yes	Elementary	KG	KG	2020	spring	grade_1												0												0
595399	LA	school	2201200	037	Ouachita Parish	220120000988	37006	Crosley Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_1												0												0
595447	LA	school	2201290	040	Rapides Parish	220129001038	40001	Acadian Elementary	Regular School	No	Elementary	PK	KG	2020	spring	grade_1												0												0
595461	LA	school	2201290	040	Rapides Parish	220129001054	40017	D.F. Huddle Elementary	Regular School	No	Elementary	PK	KG	2020	spring	grade_1												0												0
595693	LA	school	2201650	052	St. Tammany Parish	220165002089	52059	Little Pearl Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_1												0												0
595698	LA	school	2201650	052	St. Tammany Parish	220165002317	52064	Abney Elementary Early Childhood Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_1												0												0
595727	LA	school	2201680	053	Tangipahoa Parish	220168001841	53034	Perrin Early Learning Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_1												0												0
595811	LA	school	2201830	058	Vernon Parish	220183000192	58019	North Polk Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_1												0												0
595887	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2020	spring	grade_1												0												0
595899	LA	school	2200125	069	Central Community School District	220012500351	69001	Bellingrath Hills Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_1												0												0
596043	LA	school	2200030	001	Acadia Parish	220003000003	1003	Central Rayne Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_10												0												0
596049	LA	school	2200030	001	Acadia Parish	220003000008	1009	Crowley Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_10												0												0
596202	LA	school	2200300	009	Caddo Parish	220030000159	9021	Eighty-First Street ECE Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_10												0												0
596371	LA	school	2200540	017	East Baton Rouge Parish	220054001920	17031	Southdowns School	Special Education School	No	Elementary	PK	KG	2020	spring	grade_10												0												0
596794	LA	school	2201170	R36	Orleans Parish	220117002468	36199	Edward Hynes Charter School (UNO Campus)	Regular School	Yes	Elementary	KG	KG	2020	spring	grade_10												0												0
596799	LA	school	2201200	037	Ouachita Parish	220120000988	37006	Crosley Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_10												0												0
596847	LA	school	2201290	040	Rapides Parish	220129001038	40001	Acadian Elementary	Regular School	No	Elementary	PK	KG	2020	spring	grade_10												0												0
596861	LA	school	2201290	040	Rapides Parish	220129001054	40017	D.F. Huddle Elementary	Regular School	No	Elementary	PK	KG	2020	spring	grade_10												0												0
597093	LA	school	2201650	052	St. Tammany Parish	220165002089	52059	Little Pearl Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_10												0												0
597098	LA	school	2201650	052	St. Tammany Parish	220165002317	52064	Abney Elementary Early Childhood Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_10												0												0
597127	LA	school	2201680	053	Tangipahoa Parish	220168001841	53034	Perrin Early Learning Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_10												0												0
597211	LA	school	2201830	058	Vernon Parish	220183000192	58019	North Polk Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_10												0												0
597287	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2020	spring	grade_10												0												0
597299	LA	school	2200125	069	Central Community School District	220012500351	69001	Bellingrath Hills Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_10												0												0
597443	LA	school	2200030	001	Acadia Parish	220003000003	1003	Central Rayne Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_11												0												0
597449	LA	school	2200030	001	Acadia Parish	220003000008	1009	Crowley Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_11												0												0
597602	LA	school	2200300	009	Caddo Parish	220030000159	9021	Eighty-First Street ECE Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_11												0												0
597771	LA	school	2200540	017	East Baton Rouge Parish	220054001920	17031	Southdowns School	Special Education School	No	Elementary	PK	KG	2020	spring	grade_11												0												0
598194	LA	school	2201170	R36	Orleans Parish	220117002468	36199	Edward Hynes Charter School (UNO Campus)	Regular School	Yes	Elementary	KG	KG	2020	spring	grade_11												0												0
598199	LA	school	2201200	037	Ouachita Parish	220120000988	37006	Crosley Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_11												0												0
598247	LA	school	2201290	040	Rapides Parish	220129001038	40001	Acadian Elementary	Regular School	No	Elementary	PK	KG	2020	spring	grade_11												0												0
598261	LA	school	2201290	040	Rapides Parish	220129001054	40017	D.F. Huddle Elementary	Regular School	No	Elementary	PK	KG	2020	spring	grade_11												0												0
598493	LA	school	2201650	052	St. Tammany Parish	220165002089	52059	Little Pearl Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_11												0												0
598498	LA	school	2201650	052	St. Tammany Parish	220165002317	52064	Abney Elementary Early Childhood Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_11												0												0
598527	LA	school	2201680	053	Tangipahoa Parish	220168001841	53034	Perrin Early Learning Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_11												0												0
598611	LA	school	2201830	058	Vernon Parish	220183000192	58019	North Polk Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_11												0												0
598687	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2020	spring	grade_11												0												0
598699	LA	school	2200125	069	Central Community School District	220012500351	69001	Bellingrath Hills Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_11												0												0
598843	LA	school	2200030	001	Acadia Parish	220003000003	1003	Central Rayne Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_12												0												0
598849	LA	school	2200030	001	Acadia Parish	220003000008	1009	Crowley Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_12												0												0
599002	LA	school	2200300	009	Caddo Parish	220030000159	9021	Eighty-First Street ECE Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_12												0												0
599171	LA	school	2200540	017	East Baton Rouge Parish	220054001920	17031	Southdowns School	Special Education School	No	Elementary	PK	KG	2020	spring	grade_12												0												0
599594	LA	school	2201170	R36	Orleans Parish	220117002468	36199	Edward Hynes Charter School (UNO Campus)	Regular School	Yes	Elementary	KG	KG	2020	spring	grade_12												0												0
599599	LA	school	2201200	037	Ouachita Parish	220120000988	37006	Crosley Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_12												0												0
599647	LA	school	2201290	040	Rapides Parish	220129001038	40001	Acadian Elementary	Regular School	No	Elementary	PK	KG	2020	spring	grade_12												0												0
599661	LA	school	2201290	040	Rapides Parish	220129001054	40017	D.F. Huddle Elementary	Regular School	No	Elementary	PK	KG	2020	spring	grade_12												0												0
599893	LA	school	2201650	052	St. Tammany Parish	220165002089	52059	Little Pearl Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_12												0												0
599898	LA	school	2201650	052	St. Tammany Parish	220165002317	52064	Abney Elementary Early Childhood Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_12												0												0
599927	LA	school	2201680	053	Tangipahoa Parish	220168001841	53034	Perrin Early Learning Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_12												0												0
600011	LA	school	2201830	058	Vernon Parish	220183000192	58019	North Polk Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_12												0												0
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
600099	LA	school	2200125	069	Central Community School District	220012500351	69001	Bellingrath Hills Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_12												0												0
600243	LA	school	2200030	001	Acadia Parish	220003000003	1003	Central Rayne Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_2												0												0
600249	LA	school	2200030	001	Acadia Parish	220003000008	1009	Crowley Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_2												0												0
600402	LA	school	2200300	009	Caddo Parish	220030000159	9021	Eighty-First Street ECE Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_2												0												0
600571	LA	school	2200540	017	East Baton Rouge Parish	220054001920	17031	Southdowns School	Special Education School	No	Elementary	PK	KG	2020	spring	grade_2												0												0
600994	LA	school	2201170	R36	Orleans Parish	220117002468	36199	Edward Hynes Charter School (UNO Campus)	Regular School	Yes	Elementary	KG	KG	2020	spring	grade_2												0												0
600999	LA	school	2201200	037	Ouachita Parish	220120000988	37006	Crosley Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_2												0												0
601047	LA	school	2201290	040	Rapides Parish	220129001038	40001	Acadian Elementary	Regular School	No	Elementary	PK	KG	2020	spring	grade_2												0												0
601061	LA	school	2201290	040	Rapides Parish	220129001054	40017	D.F. Huddle Elementary	Regular School	No	Elementary	PK	KG	2020	spring	grade_2												0												0
601293	LA	school	2201650	052	St. Tammany Parish	220165002089	52059	Little Pearl Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_2												0												0
601298	LA	school	2201650	052	St. Tammany Parish	220165002317	52064	Abney Elementary Early Childhood Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_2												0												0
601327	LA	school	2201680	053	Tangipahoa Parish	220168001841	53034	Perrin Early Learning Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_2												0												0
601411	LA	school	2201830	058	Vernon Parish	220183000192	58019	North Polk Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_2												0												0
601487	LA	school	2200039	067	Zachary Community School District	220003900405	67001	Northwestern Elementary School	Regular School	No	Elementary	KG	KG	2020	spring	grade_2												0												0
601499	LA	school	2200125	069	Central Community School District	220012500351	69001	Bellingrath Hills Elementary School	Regular School	No	Elementary	PK	KG	2020	spring	grade_2												0												0
601643	LA	school	2200030	001	Acadia Parish	220003000003	1003	Central Rayne Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_3												0												0
601649	LA	school	2200030	001	Acadia Parish	220003000008	1009	Crowley Kindergarten School	Regular School	No	Elementary	PK	KG	2020	spring	grade_3												0												0
601802	LA	school	2200300	009	Caddo Parish	220030000159	9021	Eighty-First Street ECE Center	Regular School	No	Elementary	PK	KG	2020	spring	grade_3												0												0