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_nces_id > :p3 or (school_nces_id = :p3 and rowid > :p2)) order by school_nces_id, 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
2394598	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406016	50	Lafayette Avenue School	Regular School	No	Elementary	04	05	2021	grade_5											289.0								289
2397103	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406016	50	Lafayette Avenue School	Regular School	No	Elementary	04	05	2021	grade_6											0.0								0
2399608	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406016	50	Lafayette Avenue School	Regular School	No	Elementary	04	05	2021	grade_7											0.0								0
2402113	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406016	50	Lafayette Avenue School	Regular School	No	Elementary	04	05	2021	grade_8											0.0								0
2404618	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406016	50	Lafayette Avenue School	Regular School	No	Elementary	04	05	2021	grade_9											0.0								0
2407123	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406016	50	Lafayette Avenue School	Regular School	No	Elementary	04	05	2021	grade_10											0.0								0
2409628	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406016	50	Lafayette Avenue School	Regular School	No	Elementary	04	05	2021	grade_11											0.0								0
2412133	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406016	50	Lafayette Avenue School	Regular School	No	Elementary	04	05	2021	grade_12											0.0								0
2369551	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	pk_12_total	195.0	2.0	23.0	0.0	38.0	0.0	26.0	1.1	0.0	0.7	284.0	195	2	23	0	38	0	26	284
2372056	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten_full_day											45.0								45
2374561	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten_half_day											0.0								0
2377066	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	kindergarten_full_day											3.0								3
2379571	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	kindergarten_half_day											45.0								45
2382076	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	ungraded											26.0								26
2384581	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	grade_1											52.0								52
2387086	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	grade_2											59.0								59
2389591	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	grade_3											54.0								54
2392096	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	grade_4											0.0								0
2394601	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	grade_5											0.0								0
2397106	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	grade_6											0.0								0
2399611	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	grade_7											0.0								0
2402116	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	grade_8											0.0								0
2404621	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	grade_9											0.0								0
2407126	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	grade_10											0.0								0
2409631	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	grade_11											0.0								0
2412136	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406017	60	Milton Avenue School	Regular School	No	Elementary	PK	03	2021	grade_12											0.0								0
2369549	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	pk_12_total	212.0	2.0	30.0	0.0	51.0	0.0	19.0	1.9	0.0	1.9	314.0	212	2	30	0	51	0	19	314
2372054	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten_full_day											0.0								0
2374559	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten_half_day											0.0								0
2377064	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	kindergarten_full_day											2.0								2
2379569	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	kindergarten_half_day											50.0								50
2382074	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	ungraded											8.0								8
2384579	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	grade_1											75.0								75
2387084	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	grade_2											78.0								78
2389589	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	grade_3											101.0								101
2392094	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	grade_4											0.0								0
2394599	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	grade_5											0.0								0
2397104	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	grade_6											0.0								0
2399609	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	grade_7											0.0								0
2402114	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	grade_8											0.0								0
2404619	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	grade_9											0.0								0
2407124	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	grade_10											0.0								0
2409629	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	grade_11											0.0								0
2412134	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406018	70	Washington Avenue School	Regular School	No	Elementary	PK	03	2021	grade_12											0.0								0
2369552	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	pk_12_total	289.0	2.0	18.0	1.0	70.0	1.0	33.0	2.2	0.0	0.7	414.0	289	2	18	1	70	1	33	414
2372057	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten_full_day											0.0								0
2374562	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten_half_day											0.0								0
2377067	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	kindergarten_full_day											1.0								1
2379572	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	kindergarten_half_day											76.0								76
2382077	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	ungraded											7.0								7
2384582	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	grade_1											91.0								91
2387087	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	grade_2											120.0								120
2389592	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	grade_3											119.0								119
2392097	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	grade_4											0.0								0
2394602	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	grade_5											0.0								0
2397107	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	grade_6											0.0								0
2399612	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	grade_7											0.0								0
2402117	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	grade_8											0.0								0
2404622	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	grade_9											0.0								0
2407127	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	grade_10											0.0								0
2409632	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	grade_11											0.0								0
2412137	NJ	Morris	27	school	3400004	785	School District Of The Chathams	340000406019	80	Southern Boulevard School	Regular School	No	Elementary	PK	03	2021	grade_12											0.0								0
2370186	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	pk_12_total	56.0	41.0	30.0	0.0	21.0	1.0	1.0	0.0	0.7	8.0	150.0	56	41	30	0	21	1	1	150
2372691	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	pre_kindergarten_full_day											0.0								0
2375196	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	pre_kindergarten_half_day											0.0								0
2377701	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	kindergarten_full_day											0.0								0
2380206	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	kindergarten_half_day											0.0								0
2382711	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	ungraded											128.0								128
2385216	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	grade_1											0.0								0
2387721	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	grade_2											0.0								0
2390226	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	grade_3											0.0								0
2392731	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	grade_4											0.0								0
2395236	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	grade_5											0.0								0
2397741	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	grade_6											0.0								0
2400246	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	grade_7											0.0								0
2402751	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	grade_8											3.0								3
2405256	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	grade_9											0.0								0
2407761	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	grade_10											5.0								5
2410266	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	grade_11											3.0								3
2412771	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000500817	80	Developmental Learning Center Warren	Special Education School	No	High	06	12	2021	grade_12											11.0								11
2370185	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	pk_12_total	15.0	27.0	20.0	0.0	4.0	0.0	2.0	0.0	0.0	22.1	68.0	15	27	20	0	4	0	2	68
2372690	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	pre_kindergarten_full_day											0.0								0
2375195	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	pre_kindergarten_half_day											0.0								0
2377700	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	kindergarten_full_day											0.0								0
2380205	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	kindergarten_half_day											0.0								0
2382710	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	ungraded											56.0								56
2385215	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	grade_1											2.0								2
2387720	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	grade_2											2.0								2
2390225	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	grade_3											1.0								1
2392730	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	grade_4											4.0								4
2395235	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	grade_5											1.0								1
2397740	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	grade_6											2.0								2
2400245	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	grade_7											0.0								0
2402750	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	grade_8											0.0								0
2405255	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	grade_9											0.0								0
2407760	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	grade_10											0.0								0
2410265	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	grade_11											0.0								0
2412770	NJ	Union	39	school	3400005	3395	Morris-Union Jointure Commisson School District	340000506063	50	Developmental Learning Center New Providence	Special Education School	No	Elementary	KG	06	2021	grade_12											0.0								0
2367917	NJ	Atlantic	1	school	3400006	125	Atlantic County Special Services School District	340000600695	30	Atlantic County Elementary And Middle Schools	Special Education School	No	Elementary	PK	08	2021	pk_12_total	52.0	54.0	70.0	0.0	7.0	4.0	4.0	0.5	1.6	44.0	191.0	52	54	70	0	7	4	4	191
2370422	NJ	Atlantic	1	school	3400006	125	Atlantic County Special Services School District	340000600695	30	Atlantic County Elementary And Middle Schools	Special Education School	No	Elementary	PK	08	2021	pre_kindergarten_full_day											0.0								0
2372927	NJ	Atlantic	1	school	3400006	125	Atlantic County Special Services School District	340000600695	30	Atlantic County Elementary And Middle Schools	Special Education School	No	Elementary	PK	08	2021	pre_kindergarten_half_day											4.0								4