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 order by district_nces_id desc 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
2474937	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	pk_12_total	6.0	0.0	1.0	0.0	0.0	0.0	0.0	0	0.0	28.6	7.0	6	0	1	0	0	0	0	7
2474938	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	pk_12_total	0.0	6.0	54.0	0.0	0.0	0.0	1.0	6.6	0.0	>95	61.0	0	6	54	0	0	0	1	61
2477439	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	pre_kindergarten_full_day											0.0								0
2477440	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	pre_kindergarten_full_day											0.0								0
2479941	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	pre_kindergarten_half_day											0.0								0
2479942	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	pre_kindergarten_half_day											0.0								0
2482443	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	kindergarten_full_day											0.0								0
2482444	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	kindergarten_full_day											0.0								0
2484945	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	kindergarten_half_day											0.0								0
2484946	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	kindergarten_half_day											0.0								0
2487447	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	ungraded											6.0								6
2487448	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	ungraded											0.0								0
2489949	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	grade_1											0.0								0
2489950	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_1											0.0								0
2492451	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	grade_2											0.0								0
2492452	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_2											0.0								0
2494953	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	grade_3											0.0								0
2494954	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_3											0.0								0
2497455	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	grade_4											0.0								0
2497456	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_4											0.0								0
2499957	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	grade_5											0.0								0
2499958	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_5											0.0								0
2502459	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	grade_6											0.0								0
2502460	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_6											0.0								0
2504961	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	grade_7											0.0								0
2504962	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_7											0.0								0
2507463	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	grade_8											0.0								0
2507464	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_8											0.0								0
2509965	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	grade_9											0.0								0
2509966	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_9											2.0								2
2512467	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	grade_10											0.0								0
2512468	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_10											5.0								5
2514969	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	grade_11											0.0								0
2514970	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_11											12.0								12
2517471	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036400103	90	Skylands School For The Exceptional	Special Education School	No	High	06	12	2020	grade_12											1.0								1
2517472	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_12											42.0								42
2473933	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	pk_12_total	310.0	129.0	86.0	1.0	7.0	0.0	30.0	.4	1.1	29.299999999999997	563.0	310	129	86	1	7	0	30	563
2476435	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	pre_kindergarten_full_day											0.0								0
2478937	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day											5.0								5
2481439	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	kindergarten_full_day											2.0								2
2483941	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	kindergarten_half_day											0.0								0
2486443	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	ungraded											454.0								454
2488945	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	grade_1											10.0								10
2491447	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	grade_2											2.0								2
2493949	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	grade_3											6.0								6
2496451	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	grade_4											8.0								8
2498953	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	grade_5											8.0								8
2501455	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	grade_6											8.0								8
2503957	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	grade_7											3.0								3
2506459	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	grade_8											7.0								7
2508961	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	grade_9											10.0								10
2511463	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	grade_10											9.0								9
2513965	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	grade_11											9.0								9
2516467	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	grade_12											22.0								22
2475057	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	pk_12_total	16.0	9.0	9.0	1.0	0.0	0.0	1.0	2.8	0.0	27.799999999999997	36.0	16	9	9	1	0	0	1	36
2475058	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	pk_12_total	10.0	10.0	5.0	0.0	0.0	0.0	4.0	0	0.0	55.1	29.0	10	10	5	0	0	0	4	29
2475059	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	pk_12_total	41.0	28.0	44.0	0.0	1.0	0.0	4.0	3.4	0.0	32.2	118.0	41	28	44	0	1	0	4	118
2475060	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	pk_12_total	5.0	16.0	9.0	0.0	0.0	0.0	1.0	6.5	3.2	58.0	31.0	5	16	9	0	0	0	1	31
2477559	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	pre_kindergarten_full_day											0.0								0
2477560	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	pre_kindergarten_full_day											0.0								0
2477561	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	pre_kindergarten_full_day											0.0								0
2477562	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	pre_kindergarten_full_day											0.0								0
2480061	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	pre_kindergarten_half_day											0.0								0
2480062	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day											0.0								0
2480063	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day											0.0								0
2480064	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	pre_kindergarten_half_day											0.0								0
2482563	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	kindergarten_full_day											0.0								0
2482564	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	kindergarten_full_day											0.0								0
2482565	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	kindergarten_full_day											0.0								0
2482566	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	kindergarten_full_day											0.0								0
2485065	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	kindergarten_half_day											0.0								0
2485066	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	kindergarten_half_day											0.0								0
2485067	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	kindergarten_half_day											0.0								0
2485068	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	kindergarten_half_day											0.0								0
2487567	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	ungraded											27.0								27
2487568	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	ungraded											22.0								22
2487569	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	ungraded											96.0								96
2487570	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	ungraded											7.0								7
2490069	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	grade_1											0.0								0
2490070	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	grade_1											0.0								0
2490071	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	grade_1											2.0								2
2490072	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_1											0.0								0
2492571	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	grade_2											0.0								0
2492572	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	grade_2											0.0								0
2492573	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	grade_2											0.0								0
2492574	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_2											0.0								0
2495073	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	grade_3											0.0								0
2495074	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	grade_3											1.0								1
2495075	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	grade_3											3.0								3
2495076	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_3											0.0								0
2497575	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	grade_4											0.0								0
2497576	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	grade_4											0.0								0
2497577	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	grade_4											1.0								1
2497578	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_4											0.0								0
2500077	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	grade_5											0.0								0
2500078	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	grade_5											1.0								1
2500079	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	grade_5											1.0								1
2500080	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_5											0.0								0
2502579	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	grade_6											0.0								0
2502580	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	grade_6											1.0								1
2502581	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	grade_6											1.0								1