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 order by district_state_id 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
2472988	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	pk_12_total	195.0	59.0	86.0	0.0	16.0	0.0	24.0	5.5	0.8	48.7	380.0	195	59	86	0	16	0	24	380
2472989	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	pk_12_total	284.0	72.0	111.0	0.0	36.0	1.0	23.0	8.5	0.4	47.5	527.0	284	72	111	0	36	1	23	527
2475490	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	pre_kindergarten_full_day											0.0								0
2475491	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	pre_kindergarten_full_day											0.0								0
2477992	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	pre_kindergarten_half_day											0.0								0
2477993	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	pre_kindergarten_half_day											62.0								62
2480494	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	kindergarten_full_day											0.0								0
2480495	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	kindergarten_full_day											96.0								96
2482996	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	kindergarten_half_day											0.0								0
2482997	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	kindergarten_half_day											0.0								0
2485498	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	ungraded											13.0								13
2485499	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	ungraded											19.0								19
2488000	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	grade_1											0.0								0
2488001	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	grade_1											79.0								79
2490502	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	grade_2											0.0								0
2490503	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	grade_2											104.0								104
2493004	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	grade_3											0.0								0
2493005	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	grade_3											84.0								84
2495506	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	grade_4											0.0								0
2495507	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	grade_4											83.0								83
2498008	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	grade_5											90.0								90
2498009	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	grade_5											0.0								0
2500510	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	grade_6											95.0								95
2500511	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	grade_6											0.0								0
2503012	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	grade_7											91.0								91
2503013	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	grade_7											0.0								0
2505514	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	grade_8											91.0								91
2505515	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	grade_8											0.0								0
2508016	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	grade_9											0.0								0
2508017	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	grade_9											0.0								0
2510518	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	grade_10											0.0								0
2510519	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	grade_10											0.0								0
2513020	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	grade_11											0.0								0
2513021	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	grade_11											0.0								0
2515522	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2020	grade_12											0.0								0
2515523	NJ	Atlantic	1	school	3400660	10	Absecon City	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2020	grade_12											0.0								0
2367902	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	pk_12_total	194.0	57.0	88.0	0.0	19.0	0.0	19.0	5.0	0.3	47.7	377.0	194	57	88	0	19	0	19	377
2367903	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	pk_12_total	253.0	76.0	120.0	0.0	38.0	0.0	23.0	11.4	0.2	45.9	510.0	253	76	120	0	38	0	23	510
2370407	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	pre_kindergarten_full_day											0.0								0
2370408	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	pre_kindergarten_full_day											0.0								0
2372912	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	pre_kindergarten_half_day											0.0								0
2372913	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	pre_kindergarten_half_day											48.0								48
2375417	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	kindergarten_full_day											0.0								0
2375418	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	kindergarten_full_day											83.0								83
2377922	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	kindergarten_half_day											0.0								0
2377923	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	kindergarten_half_day											0.0								0
2380427	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	ungraded											11.0								11
2380428	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	ungraded											14.0								14
2382932	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	grade_1											0.0								0
2382933	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	grade_1											94.0								94
2385437	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	grade_2											0.0								0
2385438	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	grade_2											76.0								76
2387942	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	grade_3											0.0								0
2387943	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	grade_3											107.0								107
2390447	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	grade_4											0.0								0
2390448	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	grade_4											88.0								88
2392952	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	grade_5											84.0								84
2392953	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	grade_5											0.0								0
2395457	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	grade_6											94.0								94
2395458	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	grade_6											0.0								0
2397962	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	grade_7											94.0								94
2397963	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	grade_7											0.0								0
2400467	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	grade_8											94.0								94
2400468	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	grade_8											0.0								0
2402972	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	grade_9											0.0								0
2402973	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	grade_9											0.0								0
2405477	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	grade_10											0.0								0
2405478	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	grade_10											0.0								0
2407982	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	grade_11											0.0								0
2407983	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	grade_11											0.0								0
2410487	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000004	50	Emma C Attales	Regular School	No	Middle	05	08	2021	grade_12											0.0								0
2410488	NJ	Atlantic	1	school	3400660	10	Absecon Public Schools District	340066000006	60	H Ashton Marsh	Regular School	No	Elementary	PK	04	2021	grade_12											0.0								0
2474439	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003732	10	Asbury Park High School	Regular School	No	High	09	12	2020	pk_12_total	9.0	242.5	201.0	0.0	0.0	0.0	1.0	15.2	3.7	53.7	453.5	9	242	201	0	0	0	1	453
2474440	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003301	20	Barack Obama Elementary School	Regular School	No	Elementary	PK	05	2020	pk_12_total	13.0	176.0	76.0	0.0	0.0	0.0	2.0	8.2	3.4	78.3	267.0	13	176	76	0	0	0	2	267
2474441	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003740	40	Bradley Elementary School	Regular School	No	Elementary	PK	05	2020	pk_12_total	15.0	184.0	163.0	0.0	0.0	0.0	3.0	9.6	2.5	68.8	365.0	15	184	163	0	0	0	3	365
2474442	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003742	70	Dr. Martin Luther King Middle School	Regular School	No	Middle	06	08	2020	pk_12_total	8.0	154.0	160.0	0.0	0.0	0.0	0.0	10.6	2.5	63.4	322.0	8	154	160	0	0	0	0	322
2474443	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093000157	100	Thurgood Marshall Elementary School	Regular School	No	Elementary	PK	05	2020	pk_12_total	14.0	135.0	186.0	0.0	0.0	0.0	0.0	13.1	2.4	53.1	335.0	14	135	186	0	0	0	0	335
2476941	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003732	10	Asbury Park High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day											0.0								0
2476942	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003301	20	Barack Obama Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_full_day											0.0								0
2476943	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003740	40	Bradley Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_full_day											0.0								0
2476944	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003742	70	Dr. Martin Luther King Middle School	Regular School	No	Middle	06	08	2020	pre_kindergarten_full_day											0.0								0
2476945	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093000157	100	Thurgood Marshall Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_full_day											0.0								0
2479443	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003732	10	Asbury Park High School	Regular School	No	High	09	12	2020	pre_kindergarten_half_day											0.0								0
2479444	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003301	20	Barack Obama Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_half_day											46.0								46
2479445	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003740	40	Bradley Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_half_day											70.0								70
2479446	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003742	70	Dr. Martin Luther King Middle School	Regular School	No	Middle	06	08	2020	pre_kindergarten_half_day											0.0								0
2479447	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093000157	100	Thurgood Marshall Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_half_day											56.0								56
2481945	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003732	10	Asbury Park High School	Regular School	No	High	09	12	2020	kindergarten_full_day											0.0								0
2481946	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003301	20	Barack Obama Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day											28.0								28
2481947	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003740	40	Bradley Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day											39.0								39
2481948	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003742	70	Dr. Martin Luther King Middle School	Regular School	No	Middle	06	08	2020	kindergarten_full_day											0.0								0
2481949	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093000157	100	Thurgood Marshall Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten_full_day											30.0								30
2484447	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003732	10	Asbury Park High School	Regular School	No	High	09	12	2020	kindergarten_half_day											0.0								0
2484448	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003301	20	Barack Obama Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day											0.0								0
2484449	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003740	40	Bradley Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day											0.0								0
2484450	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003742	70	Dr. Martin Luther King Middle School	Regular School	No	Middle	06	08	2020	kindergarten_half_day											0.0								0
2484451	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093000157	100	Thurgood Marshall Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day											0.0								0
2486949	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003732	10	Asbury Park High School	Regular School	No	High	09	12	2020	ungraded											34.5								34
2486950	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003301	20	Barack Obama Elementary School	Regular School	No	Elementary	PK	05	2020	ungraded											0.0								0
2486951	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003740	40	Bradley Elementary School	Regular School	No	Elementary	PK	05	2020	ungraded											39.0								39
2486952	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003742	70	Dr. Martin Luther King Middle School	Regular School	No	Middle	06	08	2020	ungraded											28.0								28