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 > :p3 or (district = :p3 and rowid > :p2)) order by district, 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
2475402	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	pk_12_total	4.0	98.5	72.5	0.0	0.0	0.0	5.0	2.8	0.0	81.69999999999999	180.0	4	98	72	0	0	0	5	180
2477904	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	pre_kindergarten_full_day											0.0								0
2480406	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	pre_kindergarten_half_day											0.0								0
2482908	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	kindergarten_full_day											0.0								0
2485410	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	kindergarten_half_day											0.0								0
2487912	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	ungraded											0.0								0
2490414	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	grade_1											0.0								0
2492916	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	grade_2											0.0								0
2495418	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	grade_3											0.0								0
2497920	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	grade_4											0.0								0
2500422	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	grade_5											0.0								0
2502924	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	grade_6											0.0								0
2505426	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	grade_7											0.0								0
2507928	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	grade_8											0.0								0
2510430	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	grade_9											46.0								46
2512932	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	grade_10											45.5								45
2515434	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	grade_11											41.5								41
2517936	NJ	Charters	80	school	3400048	6010	Academy Charter High School	340004800335	910	Academy Charter High School	Regular School	Yes	High	09	12	2020	grade_12											47.0								47
2475414	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	pk_12_total	4.0	24.0	517.0	0.0	1.0	2.0	1.0	14.6	0.0	66.3	549.0	4	24	517	0	1	2	1	549
2477916	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	pre_kindergarten_full_day											0.0								0
2480418	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	pre_kindergarten_half_day											0.0								0
2482920	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	kindergarten_full_day											0.0								0
2485422	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	kindergarten_half_day											0.0								0
2487924	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	ungraded											0.0								0
2490426	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	grade_1											0.0								0
2492928	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	grade_2											0.0								0
2495430	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	grade_3											0.0								0
2497932	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	grade_4											0.0								0
2500434	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	grade_5											0.0								0
2502936	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	grade_6											0.0								0
2505438	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	grade_7											61.0								61
2507940	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	grade_8											86.0								86
2510442	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	grade_9											110.0								110
2512944	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	grade_10											93.0								93
2515446	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	grade_11											103.0								103
2517948	NJ	Charters	80	school	3400741	6032	Academy For Urban Leadership Charter School	340074103050	901	Academy For Urban Leadership Charter School	Regular School	Yes	High	07	12	2020	grade_12											96.0								96
2475445	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	pk_12_total	5.0	272.0	38.0	0.0	0.0	0.0	0.0	0	2.5	46.0	315.0	5	272	38	0	0	0	0	315
2477947	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	pre_kindergarten_full_day											0.0								0
2480449	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	pre_kindergarten_half_day											0.0								0
2482951	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	kindergarten_full_day											60.0								60
2485453	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	kindergarten_half_day											0.0								0
2487955	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	ungraded											0.0								0
2490457	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_1											49.0								49
2492959	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_2											67.0								67
2495461	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_3											47.0								47
2497963	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_4											0.0								0
2500465	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_5											29.0								29
2502967	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_6											63.0								63
2505469	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_7											0.0								0
2507971	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_8											0.0								0
2510473	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_9											0.0								0
2512975	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_10											0.0								0
2515477	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_11											0.0								0
2517979	NJ	Charters	80	school	3400792	6110	Achieve Community Charter School	340079203419	902	Achieve Community Charter School	Regular School	Yes	Elementary	KG	06	2020	grade_12											0.0								0
2475482	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	pk_12_total	1.0	50.0	121.0	0.0	0.0	0.0	0.0	0	0.0	80.8	172.0	1	50	121	0	0	0	0	172
2477984	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	pre_kindergarten_full_day											0.0								0
2480486	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	pre_kindergarten_half_day											0.0								0
2482988	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	kindergarten_full_day											0.0								0
2485490	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	kindergarten_half_day											0.0								0
2487992	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	ungraded											0.0								0
2490494	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	grade_1											0.0								0
2492996	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	grade_2											0.0								0
2495498	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	grade_3											0.0								0
2498000	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	grade_4											0.0								0
2500502	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	grade_5											0.0								0
2503004	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	grade_6											101.0								101
2505506	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	grade_7											71.0								71
2508008	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	grade_8											0.0								0
2510510	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	grade_9											0.0								0
2513012	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	grade_10											0.0								0
2515514	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	grade_11											0.0								0
2518016	NJ	Charters	80	school	3400794	7895	Achievers Early College Prep Charter School	340079403457	920	Achievers Early College Prep Charter School	Regular School	Yes	Middle	06	07	2020	grade_12											0.0								0
2474107	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	pk_12_total	240.0	2.0	21.0	0.0	10.0	0.0	2.0	0	0.0	5.4	275.0	240	2	21	0	10	0	2	275
2474108	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	pk_12_total	173.0	3.0	12.0	0.0	8.0	0.0	7.0	0	0.0	6.9	203.0	173	3	12	0	8	0	7	203
2476609	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	pre_kindergarten_full_day											0.0								0
2476610	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	pre_kindergarten_full_day											0.0								0
2479111	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	pre_kindergarten_half_day											0.0								0
2479112	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	pre_kindergarten_half_day											37.0								37
2481613	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	kindergarten_full_day											0.0								0
2481614	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	kindergarten_full_day											37.0								37
2484115	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	kindergarten_half_day											0.0								0
2484116	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	kindergarten_half_day											0.0								0
2486617	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	ungraded											0.0								0
2486618	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	ungraded											0.0								0
2489119	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	grade_1											0.0								0
2489120	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	grade_1											35.0								35
2491621	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	grade_2											0.0								0
2491622	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	grade_2											49.0								49
2494123	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	grade_3											0.0								0
2494124	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	grade_3											45.0								45
2496625	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	grade_4											58.0								58
2496626	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	grade_4											0.0								0
2499127	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	grade_5											53.0								53
2499128	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	grade_5											0.0								0
2501629	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	grade_6											57.0								57
2501630	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	grade_6											0.0								0
2504131	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	grade_7											60.0								60
2504132	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	grade_7											0.0								0
2506633	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	grade_8											47.0								47
2506634	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	grade_8											0.0								0
2509135	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2020	grade_9											0.0								0