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 (district < :p3 or district is null or (district = :p3 and rowid > :p2)) order by district desc, rowid limit 101

Query parameters

This data as json, CSV

rowid	state	county	county_state_id	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	grade	white	black	hispanic	native_american	asian	native_hawaiian	multiracial	ell_percent	homeless_percent	free_and_reduced_percent	total	white_int	black_int	hispanic_int	native_american_int	asian_int	native_hawaiian_int	multiracial_int	total_int
2475063	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	pk_12_total	458.0	54.5	41.0	0.0	13.5	2.0	26.0	.2	0.5	20.2	595.0	458	54	41	0	13	2	26	595
2475064	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	pk_12_total	364.0	48.0	48.0	0.0	4.0	0.0	27.0	1.6	0.8	26.1	491.0	364	48	48	0	4	0	27	491
2475065	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	pk_12_total	214.0	23.0	33.0	0.0	2.0	0.0	14.0	.3	1.0	27.9	286.0	214	23	33	0	2	0	14	286
2475066	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	pk_12_total	99.0	13.0	11.0	0.0	0.0	0.0	12.0	0	1.5	20.8	135.0	99	13	11	0	0	0	12	135
2477565	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day											0.0								0
2477566	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	pre_kindergarten_full_day											0.0								0
2477567	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	pre_kindergarten_full_day											0.0								0
2477568	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	pre_kindergarten_full_day											29.0								29
2480067	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	pre_kindergarten_half_day											0.0								0
2480068	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	pre_kindergarten_half_day											0.0								0
2480069	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	pre_kindergarten_half_day											0.0								0
2480070	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	pre_kindergarten_half_day											0.0								0
2482569	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	kindergarten_full_day											0.0								0
2482570	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	kindergarten_full_day											0.0								0
2482571	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	kindergarten_full_day											0.0								0
2482572	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	kindergarten_full_day											100.0								100
2485071	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	kindergarten_half_day											0.0								0
2485072	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	kindergarten_half_day											0.0								0
2485073	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	kindergarten_half_day											0.0								0
2485074	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	kindergarten_half_day											0.0								0
2487573	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	ungraded											9.0								9
2487574	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	ungraded											9.0								9
2487575	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	ungraded											9.0								9
2487576	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	ungraded											6.0								6
2490075	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	grade_1											0.0								0
2490076	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	grade_1											102.0								102
2490077	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	grade_1											0.0								0
2490078	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	grade_1											0.0								0
2492577	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	grade_2											0.0								0
2492578	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	grade_2											104.0								104
2492579	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	grade_2											0.0								0
2492580	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	grade_2											0.0								0
2495079	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	grade_3											0.0								0
2495080	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	grade_3											98.0								98
2495081	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	grade_3											0.0								0
2495082	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	grade_3											0.0								0
2497581	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	grade_4											0.0								0
2497582	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	grade_4											97.0								97
2497583	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	grade_4											0.0								0
2497584	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	grade_4											0.0								0
2500083	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	grade_5											0.0								0
2500084	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	grade_5											81.0								81
2500085	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	grade_5											0.0								0
2500086	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	grade_5											0.0								0
2502585	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	grade_6											0.0								0
2502586	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	grade_6											0.0								0
2502587	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	grade_6											104.0								104
2502588	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	grade_6											0.0								0
2505087	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	grade_7											0.0								0
2505088	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	grade_7											0.0								0
2505089	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	grade_7											91.0								91
2505090	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	grade_7											0.0								0
2507589	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	grade_8											0.0								0
2507590	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	grade_8											0.0								0
2507591	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	grade_8											82.0								82
2507592	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	grade_8											0.0								0
2510091	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	grade_9											146.0								146
2510092	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	grade_9											0.0								0
2510093	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	grade_9											0.0								0
2510094	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	grade_9											0.0								0
2512593	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	grade_10											153.5								153
2512594	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	grade_10											0.0								0
2512595	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	grade_10											0.0								0
2512596	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	grade_10											0.0								0
2515095	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	grade_11											138.0								138
2515096	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	grade_11											0.0								0
2515097	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	grade_11											0.0								0
2515098	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	grade_11											0.0								0
2517597	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005114	50	Woodstown High School	Regular School	No	High	09	12	2020	grade_12											148.5								148
2517598	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005116	60	Mary S. Shoemaker School	Regular School	No	Elementary	01	05	2020	grade_12											0.0								0
2517599	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833005118	70	Woodstown Middle School	Regular School	No	Middle	06	08	2020	grade_12											0.0								0
2517600	NJ	Salem	33	school	3418330	5910	Woodstown-Pilesgrove Reg	341833003250	300	William Roper Early Childhood Learning Center	Regular School	No	Elementary	PK	KG	2020	grade_12											0.0								0
2473615	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	pk_12_total	13.0	96.0	249.0	0.0	29.0	1.0	8.0	17.4	1.3	86.1	396.0	13	96	249	0	29	1	8	396
2476117	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day											0.0								0
2478619	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_half_day											26.0								26
2481121	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	kindergarten_full_day											49.0								49
2483623	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	kindergarten_half_day											0.0								0
2486125	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	ungraded											17.0								17
2488627	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	grade_1											30.0								30
2491129	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	grade_2											35.0								35
2493631	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	grade_3											35.0								35
2496133	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	grade_4											33.0								33
2498635	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	grade_5											46.0								46
2501137	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	grade_6											48.0								48
2503639	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	grade_7											46.0								46
2506141	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	grade_8											31.0								31
2508643	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	grade_9											0.0								0
2511145	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	grade_10											0.0								0
2513647	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	grade_11											0.0								0
2516149	NJ	Camden	7	school	3418270	5900	Woodlynne Boro	341827001700	50	Woodlynne Boro Public School	Regular School	No	Elementary	PK	08	2020	grade_12											0.0								0
2473467	NJ	Burlington	5	school	3418240	5890	Woodland Twp	341824001294	30	Chatsworth Elementary School	Regular School	No	Elementary	PK	08	2020	pk_12_total	128.0	1.0	4.0	0.0	0.0	0.0	2.0	0	1.5	17.8	135.0	128	1	4	0	0	0	2	135
2475969	NJ	Burlington	5	school	3418240	5890	Woodland Twp	341824001294	30	Chatsworth Elementary School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day											0.0								0
2478471	NJ	Burlington	5	school	3418240	5890	Woodland Twp	341824001294	30	Chatsworth Elementary School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_half_day											0.0								0
2480973	NJ	Burlington	5	school	3418240	5890	Woodland Twp	341824001294	30	Chatsworth Elementary School	Regular School	No	Elementary	PK	08	2020	kindergarten_full_day											16.0								16
2483475	NJ	Burlington	5	school	3418240	5890	Woodland Twp	341824001294	30	Chatsworth Elementary School	Regular School	No	Elementary	PK	08	2020	kindergarten_half_day											0.0								0
2485977	NJ	Burlington	5	school	3418240	5890	Woodland Twp	341824001294	30	Chatsworth Elementary School	Regular School	No	Elementary	PK	08	2020	ungraded											0.0								0
2488479	NJ	Burlington	5	school	3418240	5890	Woodland Twp	341824001294	30	Chatsworth Elementary School	Regular School	No	Elementary	PK	08	2020	grade_1											9.0								9
2490981	NJ	Burlington	5	school	3418240	5890	Woodland Twp	341824001294	30	Chatsworth Elementary School	Regular School	No	Elementary	PK	08	2020	grade_2											10.0								10
2493483	NJ	Burlington	5	school	3418240	5890	Woodland Twp	341824001294	30	Chatsworth Elementary School	Regular School	No	Elementary	PK	08	2020	grade_3											17.0								17
2495985	NJ	Burlington	5	school	3418240	5890	Woodland Twp	341824001294	30	Chatsworth Elementary School	Regular School	No	Elementary	PK	08	2020	grade_4											11.0								11
2498487	NJ	Burlington	5	school	3418240	5890	Woodland Twp	341824001294	30	Chatsworth Elementary School	Regular School	No	Elementary	PK	08	2020	grade_5											14.0								14