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
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
2502582	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_6											0.0								0
2505081	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	grade_7											1.0								1
2505082	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	grade_7											1.0								1
2505083	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	grade_7											2.0								2
2505084	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_7											0.0								0
2507583	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	grade_8											0.0								0
2507584	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	grade_8											2.0								2
2507585	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	grade_8											1.0								1
2507586	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_8											0.0								0
2510085	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	grade_9											2.0								2
2510086	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	grade_9											0.0								0
2510087	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	grade_9											2.0								2
2510088	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_9											3.0								3
2512587	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	grade_10											1.0								1
2512588	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	grade_10											1.0								1
2512589	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	grade_10											3.0								3
2512590	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_10											6.0								6
2515089	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	grade_11											0.0								0
2515090	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	grade_11											0.0								0
2515091	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	grade_11											2.0								2
2515092	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_11											8.0								8
2517591	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103297	9	Salem Campus	Special Education School	No	Other	KG	12	2020	grade_12											5.0								5
2517592	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036106102	50	Daretown School	Special Education School	No	Other	PK	12	2020	grade_12											0.0								0
2517593	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103161	300	Cumberland Campus	Special Education School	No	Other	PK	12	2020	grade_12											4.0								4
2517594	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_12											7.0								7
2475184	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	pk_12_total	35.0	2.0	1.0	0.0	1.0	0.0	1.0	0	0.0	20.0	40.0	35	2	1	0	1	0	1	40
2477686	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	pre_kindergarten_full_day											0.0								0
2480188	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	pre_kindergarten_half_day											0.0								0
2482690	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	kindergarten_full_day											0.0								0
2485192	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	kindergarten_half_day											0.0								0
2487694	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	ungraded											25.0								25
2490196	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	grade_1											1.0								1
2492698	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	grade_2											2.0								2
2495200	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	grade_3											1.0								1
2497702	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	grade_4											2.0								2
2500204	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	grade_5											1.0								1
2502706	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	grade_6											0.0								0
2505208	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	grade_7											0.0								0
2507710	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	grade_8											1.0								1
2510212	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	grade_9											0.0								0
2512714	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	grade_10											3.0								3
2515216	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	grade_11											0.0								0
2517718	NJ	Sussex	37	school	3480320	5105	Sussex Co Ed Serv Comm	348032005960	50	Northern Hills Academy	Special Education School	No	Other	PK	12	2020	grade_12											4.0								4
2473744	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	pk_12_total	3.0	16.0	14.0	0.0	0.0	0.0	0.0	0	6.1	57.5	33.0	3	16	14	0	0	0	0	33
2473745	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	pk_12_total	0.0	10.0	9.0	0.0	0.0	0.0	0.0	0	0.0	57.9	19.0	0	10	9	0	0	0	0	19
2473746	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	pk_12_total	0.0	20.0	3.0	0.0	1.0	0.0	0.0	0	8.3	58.400000000000006	24.0	0	20	3	0	1	0	0	24
2476246	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	pre_kindergarten_full_day											0.0								0
2476247	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	pre_kindergarten_full_day											0.0								0
2476248	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	pre_kindergarten_full_day											0.0								0
2478748	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	pre_kindergarten_half_day											0.0								0
2478749	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	pre_kindergarten_half_day											0.0								0
2478750	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	pre_kindergarten_half_day											0.0								0
2481250	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	kindergarten_full_day											0.0								0
2481251	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	kindergarten_full_day											0.0								0
2481252	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	kindergarten_full_day											0.0								0
2483752	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	kindergarten_half_day											0.0								0
2483753	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	kindergarten_half_day											0.0								0
2483754	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	kindergarten_half_day											0.0								0
2486254	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	ungraded											2.0								2
2486255	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	ungraded											2.0								2
2486256	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	ungraded											6.0								6
2488756	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_1											0.0								0
2488757	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_1											0.0								0
2488758	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	grade_1											1.0								1
2491258	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_2											0.0								0
2491259	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_2											0.0								0
2491260	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	grade_2											1.0								1
2493760	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_3											0.0								0
2493761	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_3											0.0								0
2493762	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	grade_3											0.0								0
2496262	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_4											0.0								0
2496263	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_4											0.0								0
2496264	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	grade_4											2.0								2
2498764	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_5											0.0								0
2498765	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_5											0.0								0
2498766	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	grade_5											1.0								1
2501266	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_6											0.0								0
2501267	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_6											0.0								0
2501268	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	grade_6											4.0								4
2503768	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_7											0.0								0
2503769	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_7											0.0								0
2503770	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	grade_7											0.0								0
2506270	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_8											0.0								0
2506271	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_8											0.0								0
2506272	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	grade_8											6.0								6
2508772	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_9											0.0								0
2508773	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_9											1.0								1
2508774	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	grade_9											2.0								2
2511274	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_10											6.0								6
2511275	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_10											7.0								7
2511276	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	grade_10											0.0								0
2513776	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_11											8.0								8
2513777	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_11											3.0								3
2513778	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	grade_11											1.0								1
2516278	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_12											17.0								17
2516279	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_12											6.0								6
2516280	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030006040	40	Essex Junior Academy	Special Education School	No	Other	KG	12	2020	grade_12											0.0								0
2475129	NJ	Somerset	35	school	3480280	4805	Somerset Co Ed Serv Comm	348028005918	50	Somerset Secondary Academy	Special Education School	No	High	09	12	2020	pk_12_total	8.0	28.0	16.0	0.0	0.0	0.0	0.0	1.9	1.9	30.8	52.0	8	28	16	0	0	0	0	52
2475130	NJ	Somerset	35	school	3480280	4805	Somerset Co Ed Serv Comm	348028000070	60	Somerset Elementary Academy	Special Education School	No	Elementary	KG	08	2020	pk_12_total	3.0	27.0	7.0	0.0	1.0	0.0	1.0	0	10.3	41.0	39.0	3	27	7	0	1	0	1	39
2475131	NJ	Somerset	35	school	3480280	4805	Somerset Co Ed Serv Comm	348028003292	300	The Career Center Of The Scesc	Special Education School	No	High	09	12	2020	pk_12_total	0.0	5.0	0.0	0.0	1.0	0.0	0.0	0	0.0	16.7	6.0	0	5	0	0	1	0	0	6