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 "year" = :p1 and (school_state_id > :p3 or (school_state_id = :p3 and rowid > :p2)) order by school_state_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	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
2292151	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	spring	grade_4												0												0
2293564	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	spring	grade_5												0												0
2294977	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	spring	grade_6												0												0
2296390	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	spring	grade_7												0												0
2297803	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	spring	grade_8												0												0
2299216	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	spring	grade_9												125												125
2300629	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	spring	grade_9_transitional												27												27
2302042	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	spring	kindergarten												0												0
2303455	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	spring	pk_12_total	317.0	151.0	19.0	2.0	0.0	0.0	25.0	266.0	248.0	2.0	316.0	514	317	151	19	2	0	0	25	266	248	2	316	514
2304868	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	spring	pre_kindergarten												0												0
2518028	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	grade_1												0												0
2519445	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	grade_10												147												147
2520862	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	grade_11												135												135
2522279	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	grade_12												96												96
2523696	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	grade_2												0												0
2525113	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	grade_3												0												0
2526530	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	grade_4												0												0
2527947	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	grade_5												0												0
2529364	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	grade_6												0												0
2530781	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	grade_7												0												0
2532198	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	grade_8												0												0
2533615	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	grade_9												123												123
2535032	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	grade_9_transitional												27												27
2536449	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	kindergarten												0												0
2537866	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	pk_12_total	322.0	157.0	20.0	2.0	0.0	0.0	27.0	278.0	250.0	3.0	320.0	528	322	157	20	2	0	0	27	278	250	3	320	528
2539283	LA	school	2200030	001	Acadia Parish	220003000004	1005	Church Point High School	Regular School	No	High	08	12	2019	fall	pre_kindergarten												0												0
2283674	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	grade_1												0												0
2285087	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	grade_10												0												0
2286500	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	grade_11												0												0
2287913	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	grade_12												0												0
2289326	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	grade_2												0												0
2290739	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	grade_3												0												0
2292152	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	grade_4												0												0
2293565	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	grade_5												0												0
2294978	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	grade_6												98												98
2296391	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	grade_7												98												98
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
2299217	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	grade_9												0												0
2300630	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	grade_9_transitional												0												0
2302043	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	kindergarten												0												0
2303456	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	pk_12_total	118.0	136.0	13.0	0.0	0.0	0.0	21.0	141.0	147.0	1.0	232.0	288	118	136	13	0	0	0	21	141	147	1	232	288
2304869	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	spring	pre_kindergarten												0												0
2518029	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	grade_1												0												0
2519446	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	grade_10												0												0
2520863	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	grade_11												0												0
2522280	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	grade_12												0												0
2523697	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	grade_2												0												0
2525114	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	grade_3												0												0
2526531	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	grade_4												0												0
2527948	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	grade_5												0												0
2529365	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	grade_6												100												100
2530782	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	grade_7												97												97
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
2533616	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	grade_9												0												0
2535033	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	grade_9_transitional												0												0
2536450	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	kindergarten												0												0
2537867	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	pk_12_total	120.0	136.0	12.0	0.0	0.0	0.0	19.0	141.0	146.0	1.0	230.0	287	120	136	12	0	0	0	19	141	146	1	230	287
2539284	LA	school	2200030	001	Acadia Parish	220003000005	1006	Church Point Middle School	Regular School	No	Middle	06	08	2019	fall	pre_kindergarten												0												0
2283675	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	grade_1												0												0
2285088	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	grade_10												129												129
2286501	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	grade_11												157												157
2287914	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	grade_12												133												133
2289327	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	grade_2												0												0
2290740	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	grade_3												0												0
2292153	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	grade_4												0												0
2293566	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	grade_5												0												0
2294979	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	grade_6												0												0
2296392	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	grade_7												0												0
2297805	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	grade_8												0												0
2299218	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	grade_9												136												136
2300631	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	grade_9_transitional												43												43
2302044	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	kindergarten												0												0
2303457	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	pk_12_total	294.0	255.0	18.0	1.0	1.0	0.0	29.0	292.0	306.0	6.0	469.0	598	294	255	18	1	1	0	29	292	306	6	469	598
2304870	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	spring	pre_kindergarten												0												0
2518030	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	grade_1												0												0
2519447	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	grade_10												131												131
2520864	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	grade_11												156												156
2522281	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	grade_12												137												137
2523698	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	grade_2												0												0
2525115	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	grade_3												0												0
2526532	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	grade_4												0												0
2527949	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	grade_5												0												0
2529366	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	grade_6												0												0
2530783	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	grade_7												0												0
2532200	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	grade_8												0												0
2533617	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	grade_9												142												142
2535034	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	grade_9_transitional												44												44
2536451	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	kindergarten												0												0
2537868	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	pk_12_total	300.0	261.0	21.0	1.0	1.0	0.0	26.0	301.0	309.0	8.0	472.0	610	300	261	21	1	1	0	26	301	309	8	472	610
2539285	LA	school	2200030	001	Acadia Parish	220003000006	1007	Crowley High School	Regular School	No	High	07	12	2019	fall	pre_kindergarten												0												0
2283676	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2019	spring	grade_1												0												0
2285089	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2019	spring	grade_10												0												0
2286502	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2019	spring	grade_11												0												0
2287915	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2019	spring	grade_12												0												0
2289328	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2019	spring	grade_2												0												0
2290741	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2019	spring	grade_3												0												0
2292154	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2019	spring	grade_4												0												0
2293567	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2019	spring	grade_5												0												0
2294980	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2019	spring	grade_6												164												164
2296393	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2019	spring	grade_7												148												148
2297806	LA	school	2200030	001	Acadia Parish	220003000007	1008	Crowley Middle School	Regular School	No	Middle	06	08	2019	spring	grade_8												153												153