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_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	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
2488310	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700083	70	Moonachie Campus	Special Education School	No	Elementary	PK	08	2020	grade_1											2.0								2
2490810	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700578	50	Lodi Ms Hs	Special Education School	No	High	06	12	2020	grade_2											0.0								0
2490811	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700081	60	Maywood Campus	Special Education School	No	Elementary	PK	05	2020	grade_2											8.0								8
2490812	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700083	70	Moonachie Campus	Special Education School	No	Elementary	PK	08	2020	grade_2											0.0								0
2493312	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700578	50	Lodi Ms Hs	Special Education School	No	High	06	12	2020	grade_3											0.0								0
2493313	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700081	60	Maywood Campus	Special Education School	No	Elementary	PK	05	2020	grade_3											3.0								3
2493314	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700083	70	Moonachie Campus	Special Education School	No	Elementary	PK	08	2020	grade_3											0.0								0
2495814	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700578	50	Lodi Ms Hs	Special Education School	No	High	06	12	2020	grade_4											0.0								0
2495815	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700081	60	Maywood Campus	Special Education School	No	Elementary	PK	05	2020	grade_4											3.0								3
2495816	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700083	70	Moonachie Campus	Special Education School	No	Elementary	PK	08	2020	grade_4											0.0								0
2498316	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700578	50	Lodi Ms Hs	Special Education School	No	High	06	12	2020	grade_5											0.0								0
2498317	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700081	60	Maywood Campus	Special Education School	No	Elementary	PK	05	2020	grade_5											1.0								1
2498318	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700083	70	Moonachie Campus	Special Education School	No	Elementary	PK	08	2020	grade_5											2.0								2
2500818	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700578	50	Lodi Ms Hs	Special Education School	No	High	06	12	2020	grade_6											2.0								2
2500819	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700081	60	Maywood Campus	Special Education School	No	Elementary	PK	05	2020	grade_6											0.0								0
2500820	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700083	70	Moonachie Campus	Special Education School	No	Elementary	PK	08	2020	grade_6											2.0								2
2503320	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700578	50	Lodi Ms Hs	Special Education School	No	High	06	12	2020	grade_7											3.0								3
2503321	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700081	60	Maywood Campus	Special Education School	No	Elementary	PK	05	2020	grade_7											0.0								0
2503322	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700083	70	Moonachie Campus	Special Education School	No	Elementary	PK	08	2020	grade_7											0.0								0
2505822	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700578	50	Lodi Ms Hs	Special Education School	No	High	06	12	2020	grade_8											3.0								3
2505823	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700081	60	Maywood Campus	Special Education School	No	Elementary	PK	05	2020	grade_8											0.0								0
2505824	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700083	70	Moonachie Campus	Special Education School	No	Elementary	PK	08	2020	grade_8											0.0								0
2508324	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700578	50	Lodi Ms Hs	Special Education School	No	High	06	12	2020	grade_9											3.0								3
2508325	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700081	60	Maywood Campus	Special Education School	No	Elementary	PK	05	2020	grade_9											0.0								0
2508326	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700083	70	Moonachie Campus	Special Education School	No	Elementary	PK	08	2020	grade_9											0.0								0
2510826	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700578	50	Lodi Ms Hs	Special Education School	No	High	06	12	2020	grade_10											0.0								0
2510827	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700081	60	Maywood Campus	Special Education School	No	Elementary	PK	05	2020	grade_10											0.0								0
2510828	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700083	70	Moonachie Campus	Special Education School	No	Elementary	PK	08	2020	grade_10											0.0								0
2513328	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700578	50	Lodi Ms Hs	Special Education School	No	High	06	12	2020	grade_11											0.0								0
2513329	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700081	60	Maywood Campus	Special Education School	No	Elementary	PK	05	2020	grade_11											0.0								0
2513330	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700083	70	Moonachie Campus	Special Education School	No	Elementary	PK	08	2020	grade_11											0.0								0
2515830	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700578	50	Lodi Ms Hs	Special Education School	No	High	06	12	2020	grade_12											8.0								8
2515831	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700081	60	Maywood Campus	Special Education School	No	Elementary	PK	05	2020	grade_12											0.0								0
2515832	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Com	340000700083	70	Moonachie Campus	Special Education School	No	Elementary	PK	08	2020	grade_12											0.0								0
2475372	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	pk_12_total	290.0	5.0	34.0	0.0	4.0	1.0	11.0	.9	0.3	12.5	345.0	290	5	34	0	4	1	11	345
2475373	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	pk_12_total	243.0	2.0	30.0	0.0	9.0	0.0	6.0	1.7	0.7	10.4	290.0	243	2	30	0	9	0	6	290
2477874	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	pre_kindergarten_full_day											0.0								0
2477875	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	pre_kindergarten_full_day											5.0								5
2480376	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	pre_kindergarten_half_day											0.0								0
2480377	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	pre_kindergarten_half_day											7.0								7
2482878	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	kindergarten_full_day											0.0								0
2482879	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	kindergarten_full_day											60.0								60
2485380	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	kindergarten_half_day											0.0								0
2485381	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	kindergarten_half_day											0.0								0
2487882	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	ungraded											13.0								13
2487883	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	ungraded											23.0								23
2490384	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	grade_1											0.0								0
2490385	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	grade_1											65.0								65
2492886	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	grade_2											0.0								0
2492887	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	grade_2											60.0								60
2495388	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	grade_3											0.0								0
2495389	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	grade_3											70.0								70
2497890	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	grade_4											53.0								53
2497891	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	grade_4											0.0								0
2500392	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	grade_5											63.0								63
2500393	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	grade_5											0.0								0
2502894	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	grade_6											61.0								61
2502895	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	grade_6											0.0								0
2505396	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	grade_7											66.0								66
2505397	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	grade_7											0.0								0
2507898	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	grade_8											89.0								89
2507899	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	grade_8											0.0								0
2510400	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	grade_9											0.0								0
2510401	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	grade_9											0.0								0
2512902	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	grade_10											0.0								0
2512903	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	grade_10											0.0								0
2515404	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	grade_11											0.0								0
2515405	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	grade_11											0.0								0
2517906	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800248	40	Great Meadows Regional Middle School	Regular School	No	Middle	04	08	2020	grade_12											0.0								0
2517907	NJ	Warren	41	school	3400008	1785	Great Meadows Regional	340000800107	50	Central Elementary School	Regular School	No	Elementary	PK	03	2020	grade_12											0.0								0
2475133	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900176	20	Bernards High School	Regular School	No	High	09	12	2020	pk_12_total	568.0	9.0	183.0	0.0	47.0	0.0	15.5	4.6	0.0	12.2	822.5	568	9	183	0	47	0	15	822
2475134	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900177	30	Marion T. Bedwell Elementary School	Regular School	No	Elementary	PK	04	2020	pk_12_total	374.0	5.0	142.0	0.0	16.0	0.0	29.0	7.1	0.0	14.9	566.0	374	5	142	0	16	0	29	566
2475135	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900178	40	Bernardsville Middle School	Regular School	No	Middle	05	08	2020	pk_12_total	376.0	2.0	111.0	0.0	18.0	0.0	19.0	2.9	0.0	10.1	526.0	376	2	111	0	18	0	19	526
2477635	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900176	20	Bernards High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day											0.0								0
2477636	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900177	30	Marion T. Bedwell Elementary School	Regular School	No	Elementary	PK	04	2020	pre_kindergarten_full_day											0.0								0
2477637	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900178	40	Bernardsville Middle School	Regular School	No	Middle	05	08	2020	pre_kindergarten_full_day											0.0								0
2480137	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900176	20	Bernards High School	Regular School	No	High	09	12	2020	pre_kindergarten_half_day											0.0								0
2480138	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900177	30	Marion T. Bedwell Elementary School	Regular School	No	Elementary	PK	04	2020	pre_kindergarten_half_day											0.0								0
2480139	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900178	40	Bernardsville Middle School	Regular School	No	Middle	05	08	2020	pre_kindergarten_half_day											0.0								0
2482639	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900176	20	Bernards High School	Regular School	No	High	09	12	2020	kindergarten_full_day											0.0								0
2482640	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900177	30	Marion T. Bedwell Elementary School	Regular School	No	Elementary	PK	04	2020	kindergarten_full_day											114.0								114
2482641	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900178	40	Bernardsville Middle School	Regular School	No	Middle	05	08	2020	kindergarten_full_day											0.0								0
2485141	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900176	20	Bernards High School	Regular School	No	High	09	12	2020	kindergarten_half_day											0.0								0
2485142	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900177	30	Marion T. Bedwell Elementary School	Regular School	No	Elementary	PK	04	2020	kindergarten_half_day											0.0								0
2485143	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900178	40	Bernardsville Middle School	Regular School	No	Middle	05	08	2020	kindergarten_half_day											0.0								0
2487643	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900176	20	Bernards High School	Regular School	No	High	09	12	2020	ungraded											2.0								2
2487644	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900177	30	Marion T. Bedwell Elementary School	Regular School	No	Elementary	PK	04	2020	ungraded											21.0								21
2487645	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900178	40	Bernardsville Middle School	Regular School	No	Middle	05	08	2020	ungraded											3.0								3
2490145	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900176	20	Bernards High School	Regular School	No	High	09	12	2020	grade_1											0.0								0
2490146	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900177	30	Marion T. Bedwell Elementary School	Regular School	No	Elementary	PK	04	2020	grade_1											89.0								89
2490147	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900178	40	Bernardsville Middle School	Regular School	No	Middle	05	08	2020	grade_1											0.0								0
2492647	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900176	20	Bernards High School	Regular School	No	High	09	12	2020	grade_2											0.0								0
2492648	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900177	30	Marion T. Bedwell Elementary School	Regular School	No	Elementary	PK	04	2020	grade_2											100.0								100
2492649	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900178	40	Bernardsville Middle School	Regular School	No	Middle	05	08	2020	grade_2											0.0								0
2495149	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900176	20	Bernards High School	Regular School	No	High	09	12	2020	grade_3											0.0								0
2495150	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900177	30	Marion T. Bedwell Elementary School	Regular School	No	Elementary	PK	04	2020	grade_3											121.0								121
2495151	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900178	40	Bernardsville Middle School	Regular School	No	Middle	05	08	2020	grade_3											0.0								0
2497651	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900176	20	Bernards High School	Regular School	No	High	09	12	2020	grade_4											0.0								0
2497652	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900177	30	Marion T. Bedwell Elementary School	Regular School	No	Elementary	PK	04	2020	grade_4											121.0								121
2497653	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900178	40	Bernardsville Middle School	Regular School	No	Middle	05	08	2020	grade_4											0.0								0
2500153	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900176	20	Bernards High School	Regular School	No	High	09	12	2020	grade_5											0.0								0