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 is null or (district_nces_id = :p3 and rowid > :p2)) order by district_nces_id 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
2397533	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2021	grade_6											1.0								1
2397534	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2021	grade_6											1.0								1
2400036	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2021	grade_7											4.0								4
2400037	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2021	grade_7											1.0								1
2400038	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2021	grade_7											1.0								1
2400039	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2021	grade_7											0.0								0
2402541	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2021	grade_8											3.0								3
2402542	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2021	grade_8											3.0								3
2402543	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2021	grade_8											1.0								1
2402544	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2021	grade_8											1.0								1
2405046	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2021	grade_9											2.0								2
2405047	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2021	grade_9											1.0								1
2405048	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2021	grade_9											2.0								2
2405049	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2021	grade_9											2.0								2
2407551	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2021	grade_10											0.0								0
2407552	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2021	grade_10											5.0								5
2407553	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2021	grade_10											0.0								0
2407554	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2021	grade_10											5.0								5
2410056	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2021	grade_11											1.0								1
2410057	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2021	grade_11											2.0								2
2410058	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2021	grade_11											4.0								4
2410059	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2021	grade_11											8.0								8
2412561	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2021	grade_12											0.0								0
2412562	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2021	grade_12											7.0								7
2412563	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2021	grade_12											6.0								6
2412564	NJ	Salem	33	school	3480361	4635	Salem County Special Services School District	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2021	grade_12											4.0								4
2370103	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	pk_12_total	33.0	2.0	1.0	0.0	0.0	0.0	1.0	0.0	0.0	16.2	37.0	33	2	1	0	0	0	1	37
2372608	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	pre_kindergarten_full_day											0.0								0
2375113	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	pre_kindergarten_half_day											0.0								0
2377618	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	kindergarten_full_day											0.0								0
2380123	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	kindergarten_half_day											0.0								0
2382628	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	ungraded											23.0								23
2385133	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	grade_1											1.0								1
2387638	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	grade_2											2.0								2
2390143	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	grade_3											3.0								3
2392648	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	grade_4											0.0								0
2395153	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	grade_5											1.0								1
2397658	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	grade_6											1.0								1
2400163	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	grade_7											0.0								0
2402668	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	grade_8											0.0								0
2405173	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	grade_9											1.0								1
2407678	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	grade_10											0.0								0
2410183	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	grade_11											2.0								2
2412688	NJ	Sussex	37	school	3480320	5105	Northern Hills Academy School District	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2021	grade_12											3.0								3
2368659	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	pk_12_total	1.0	20.0	2.0	0.0	0.0	0.0	0.0	0.0	4.3	52.2	23.0	1	20	2	0	0	0	0	23
2368660	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	pk_12_total	0.0	18.0	10.0	0.0	1.0	0.0	0.0	3.4	0.0	51.7	29.0	0	18	10	0	1	0	0	29
2368661	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	pk_12_total	2.0	8.0	8.0	0.0	0.0	0.0	0.0	0.0	0.0	38.9	18.0	2	8	8	0	0	0	0	18
2371164	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	pre_kindergarten_full_day											0.0								0
2371165	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	pre_kindergarten_full_day											0.0								0
2371166	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	pre_kindergarten_full_day											0.0								0
2373669	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	pre_kindergarten_half_day											0.0								0
2373670	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	pre_kindergarten_half_day											0.0								0
2373671	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	pre_kindergarten_half_day											0.0								0
2376174	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	kindergarten_full_day											0.0								0
2376175	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	kindergarten_full_day											0.0								0
2376176	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	kindergarten_full_day											0.0								0
2378679	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	kindergarten_half_day											0.0								0
2378680	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	kindergarten_half_day											0.0								0
2378681	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	kindergarten_half_day											0.0								0
2381184	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	ungraded											9.0								9
2381185	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	ungraded											3.0								3
2381186	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	ungraded											0.0								0
2383689	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	grade_1											0.0								0
2383690	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	grade_1											0.0								0
2383691	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	grade_1											0.0								0
2386194	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	grade_2											0.0								0
2386195	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	grade_2											0.0								0
2386196	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	grade_2											0.0								0
2388699	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	grade_3											2.0								2
2388700	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	grade_3											0.0								0
2388701	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	grade_3											0.0								0
2391204	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	grade_4											1.0								1
2391205	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	grade_4											0.0								0
2391206	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	grade_4											0.0								0
2393709	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	grade_5											3.0								3
2393710	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	grade_5											0.0								0
2393711	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	grade_5											0.0								0
2396214	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	grade_6											0.0								0
2396215	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	grade_6											0.0								0
2396216	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	grade_6											0.0								0
2398719	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	grade_7											3.0								3
2398720	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	grade_7											0.0								0
2398721	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	grade_7											0.0								0
2401224	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	grade_8											5.0								5
2401225	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	grade_8											0.0								0
2401226	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	grade_8											0.0								0
2403729	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	grade_9											0.0								0
2403730	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	grade_9											6.0								6
2403731	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	grade_9											0.0								0
2406234	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	grade_10											0.0								0
2406235	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	grade_10											5.0								5
2406236	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	grade_10											1.0								1
2408739	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	grade_11											0.0								0
2408740	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	grade_11											8.0								8
2408741	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	grade_11											4.0								4
2411244	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030006040	40	Essex Junior Academy	Special Education School	No	Elementary	KG	08	2021	grade_12											0.0								0
2411245	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000135	30	Essex High School	Alternative School	No	High	09	12	2021	grade_12											7.0								7
2411246	NJ	Essex	13	school	3480300	1387	Essex Regional Educational Services Commission	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2021	grade_12											13.0								13
2370048	NJ	Somerset	35	school	3480280	4805	Somerset County Educational Services Commission School Distr	348028003292	300	The Career Center Of The Scesc	Special Education School	No	High	09	12	2021	pk_12_total	1.0	2.0	1.0	0.0	1.0	0.0	0.0	0.0	0.0	20.0	5.0	1	2	1	0	1	0	0	5
2370049	NJ	Somerset	35	school	3480280	4805	Somerset County Educational Services Commission School Distr	348028005918	50	Somerset Secondary Academy	Special Education School	No	High	09	12	2021	pk_12_total	7.0	34.0	22.0	0.0	0.0	0.0	3.0	3.0	3.0	39.4	66.0	7	34	22	0	0	0	3	66
2370050	NJ	Somerset	35	school	3480280	4805	Somerset County Educational Services Commission School Distr	348028000070	60	Somerset Elementary Academy	Special Education School	No	Elementary	KG	08	2021	pk_12_total	7.0	18.0	12.0	0.0	0.0	0.0	0.0	2.7	8.1	45.9	37.0	7	18	12	0	0	0	0	37