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 (district_state_id < :p2 or district_state_id is null or (district_state_id = :p2 and rowid > :p1)) order by district_state_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
2390162	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005458	30	Cranford High School	Regular School	No	High	09	12	2021	grade_3											0.0								0
2390163	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005466	50	Brookside Place School	Regular School	No	Elementary	KG	05	2021	grade_3											57.0								57
2390164	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005470	80	Livingston Avenue School	Regular School	No	Elementary	03	05	2021	grade_3											80.0								80
2390165	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005474	110	Walnut Avenue School	Regular School	No	Elementary	PK	02	2021	grade_3											0.0								0
2390166	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005460	33	Hillside Avenue School	Regular School	No	Elementary	KG	08	2021	grade_3											46.0								46
2390167	NJ	Union	39	school	3403570	980	Cranford Public School District	340357000206	40	Bloomingdale Avenue School	Regular School	No	Elementary	KG	02	2021	grade_3											0.0								0
2390168	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005462	37	Orange Avenue School	Regular School	No	Middle	03	08	2021	grade_3											91.0								91
2392667	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005458	30	Cranford High School	Regular School	No	High	09	12	2021	grade_4											0.0								0
2392668	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005466	50	Brookside Place School	Regular School	No	Elementary	KG	05	2021	grade_4											60.0								60
2392669	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005470	80	Livingston Avenue School	Regular School	No	Elementary	03	05	2021	grade_4											90.0								90
2392670	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005474	110	Walnut Avenue School	Regular School	No	Elementary	PK	02	2021	grade_4											0.0								0
2392671	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005460	33	Hillside Avenue School	Regular School	No	Elementary	KG	08	2021	grade_4											45.0								45
2392672	NJ	Union	39	school	3403570	980	Cranford Public School District	340357000206	40	Bloomingdale Avenue School	Regular School	No	Elementary	KG	02	2021	grade_4											0.0								0
2392673	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005462	37	Orange Avenue School	Regular School	No	Middle	03	08	2021	grade_4											86.0								86
2395172	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005458	30	Cranford High School	Regular School	No	High	09	12	2021	grade_5											0.0								0
2395173	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005466	50	Brookside Place School	Regular School	No	Elementary	KG	05	2021	grade_5											76.0								76
2395174	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005470	80	Livingston Avenue School	Regular School	No	Elementary	03	05	2021	grade_5											90.0								90
2395175	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005474	110	Walnut Avenue School	Regular School	No	Elementary	PK	02	2021	grade_5											0.0								0
2395176	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005460	33	Hillside Avenue School	Regular School	No	Elementary	KG	08	2021	grade_5											48.0								48
2395177	NJ	Union	39	school	3403570	980	Cranford Public School District	340357000206	40	Bloomingdale Avenue School	Regular School	No	Elementary	KG	02	2021	grade_5											0.0								0
2395178	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005462	37	Orange Avenue School	Regular School	No	Middle	03	08	2021	grade_5											92.0								92
2397677	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005458	30	Cranford High School	Regular School	No	High	09	12	2021	grade_6											0.0								0
2397678	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005466	50	Brookside Place School	Regular School	No	Elementary	KG	05	2021	grade_6											0.0								0
2397679	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005470	80	Livingston Avenue School	Regular School	No	Elementary	03	05	2021	grade_6											0.0								0
2397680	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005474	110	Walnut Avenue School	Regular School	No	Elementary	PK	02	2021	grade_6											0.0								0
2397681	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005460	33	Hillside Avenue School	Regular School	No	Elementary	KG	08	2021	grade_6											137.0								137
2397682	NJ	Union	39	school	3403570	980	Cranford Public School District	340357000206	40	Bloomingdale Avenue School	Regular School	No	Elementary	KG	02	2021	grade_6											0.0								0
2397683	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005462	37	Orange Avenue School	Regular School	No	Middle	03	08	2021	grade_6											144.0								144
2400182	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005458	30	Cranford High School	Regular School	No	High	09	12	2021	grade_7											0.0								0
2400183	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005466	50	Brookside Place School	Regular School	No	Elementary	KG	05	2021	grade_7											0.0								0
2400184	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005470	80	Livingston Avenue School	Regular School	No	Elementary	03	05	2021	grade_7											0.0								0
2400185	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005474	110	Walnut Avenue School	Regular School	No	Elementary	PK	02	2021	grade_7											0.0								0
2400186	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005460	33	Hillside Avenue School	Regular School	No	Elementary	KG	08	2021	grade_7											129.0								129
2400187	NJ	Union	39	school	3403570	980	Cranford Public School District	340357000206	40	Bloomingdale Avenue School	Regular School	No	Elementary	KG	02	2021	grade_7											0.0								0
2400188	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005462	37	Orange Avenue School	Regular School	No	Middle	03	08	2021	grade_7											153.0								153
2402687	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005458	30	Cranford High School	Regular School	No	High	09	12	2021	grade_8											0.0								0
2402688	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005466	50	Brookside Place School	Regular School	No	Elementary	KG	05	2021	grade_8											0.0								0
2402689	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005470	80	Livingston Avenue School	Regular School	No	Elementary	03	05	2021	grade_8											0.0								0
2402690	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005474	110	Walnut Avenue School	Regular School	No	Elementary	PK	02	2021	grade_8											0.0								0
2402691	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005460	33	Hillside Avenue School	Regular School	No	Elementary	KG	08	2021	grade_8											130.0								130
2402692	NJ	Union	39	school	3403570	980	Cranford Public School District	340357000206	40	Bloomingdale Avenue School	Regular School	No	Elementary	KG	02	2021	grade_8											0.0								0
2402693	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005462	37	Orange Avenue School	Regular School	No	Middle	03	08	2021	grade_8											148.0								148
2405192	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005458	30	Cranford High School	Regular School	No	High	09	12	2021	grade_9											248.0								248
2405193	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005466	50	Brookside Place School	Regular School	No	Elementary	KG	05	2021	grade_9											0.0								0
2405194	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005470	80	Livingston Avenue School	Regular School	No	Elementary	03	05	2021	grade_9											0.0								0
2405195	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005474	110	Walnut Avenue School	Regular School	No	Elementary	PK	02	2021	grade_9											0.0								0
2405196	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005460	33	Hillside Avenue School	Regular School	No	Elementary	KG	08	2021	grade_9											0.0								0
2405197	NJ	Union	39	school	3403570	980	Cranford Public School District	340357000206	40	Bloomingdale Avenue School	Regular School	No	Elementary	KG	02	2021	grade_9											0.0								0
2405198	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005462	37	Orange Avenue School	Regular School	No	Middle	03	08	2021	grade_9											0.0								0
2407697	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005458	30	Cranford High School	Regular School	No	High	09	12	2021	grade_10											291.5								291
2407698	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005466	50	Brookside Place School	Regular School	No	Elementary	KG	05	2021	grade_10											0.0								0
2407699	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005470	80	Livingston Avenue School	Regular School	No	Elementary	03	05	2021	grade_10											0.0								0
2407700	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005474	110	Walnut Avenue School	Regular School	No	Elementary	PK	02	2021	grade_10											0.0								0
2407701	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005460	33	Hillside Avenue School	Regular School	No	Elementary	KG	08	2021	grade_10											0.0								0
2407702	NJ	Union	39	school	3403570	980	Cranford Public School District	340357000206	40	Bloomingdale Avenue School	Regular School	No	Elementary	KG	02	2021	grade_10											0.0								0
2407703	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005462	37	Orange Avenue School	Regular School	No	Middle	03	08	2021	grade_10											0.0								0
2410202	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005458	30	Cranford High School	Regular School	No	High	09	12	2021	grade_11											278.0								278
2410203	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005466	50	Brookside Place School	Regular School	No	Elementary	KG	05	2021	grade_11											0.0								0
2410204	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005470	80	Livingston Avenue School	Regular School	No	Elementary	03	05	2021	grade_11											0.0								0
2410205	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005474	110	Walnut Avenue School	Regular School	No	Elementary	PK	02	2021	grade_11											0.0								0
2410206	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005460	33	Hillside Avenue School	Regular School	No	Elementary	KG	08	2021	grade_11											0.0								0
2410207	NJ	Union	39	school	3403570	980	Cranford Public School District	340357000206	40	Bloomingdale Avenue School	Regular School	No	Elementary	KG	02	2021	grade_11											0.0								0
2410208	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005462	37	Orange Avenue School	Regular School	No	Middle	03	08	2021	grade_11											0.0								0
2412707	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005458	30	Cranford High School	Regular School	No	High	09	12	2021	grade_12											313.0								313
2412708	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005466	50	Brookside Place School	Regular School	No	Elementary	KG	05	2021	grade_12											0.0								0
2412709	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005470	80	Livingston Avenue School	Regular School	No	Elementary	03	05	2021	grade_12											0.0								0
2412710	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005474	110	Walnut Avenue School	Regular School	No	Elementary	PK	02	2021	grade_12											0.0								0
2412711	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005460	33	Hillside Avenue School	Regular School	No	Elementary	KG	08	2021	grade_12											0.0								0
2412712	NJ	Union	39	school	3403570	980	Cranford Public School District	340357000206	40	Bloomingdale Avenue School	Regular School	No	Elementary	KG	02	2021	grade_12											0.0								0
2412713	NJ	Union	39	school	3403570	980	Cranford Public School District	340357005462	37	Orange Avenue School	Regular School	No	Middle	03	08	2021	grade_12											0.0								0
2475204	NJ	Union	39	school	3403570	980	Cranford Twp	340357005458	30	Cranford High School	Regular School	No	High	09	12	2020	pk_12_total	994.0	39.0	95.5	0.0	36.0	0.0	14.5	.2	0.0	2.0	1179.0	994	39	95	0	36	0	14	1179
2475205	NJ	Union	39	school	3403570	980	Cranford Twp	340357005460	33	Hillside Avenue School	Regular School	No	Elementary	KG	08	2020	pk_12_total	503.0	45.0	86.0	0.0	39.0	0.0	21.0	.9	0.0	4.9	694.0	503	45	86	0	39	0	21	694
2475206	NJ	Union	39	school	3403570	980	Cranford Twp	340357005462	37	Orange Avenue School	Regular School	No	Middle	03	08	2020	pk_12_total	605.0	3.0	45.0	0.0	29.0	0.0	23.0	0	0.0	1.2	705.0	605	3	45	0	29	0	23	705
2475207	NJ	Union	39	school	3403570	980	Cranford Twp	340357000206	40	Bloomingdale Avenue School	Regular School	No	Elementary	KG	02	2020	pk_12_total	209.0	6.0	15.0	0.0	11.0	0.0	11.0	.4	0.0	0.4	252.0	209	6	15	0	11	0	11	252
2475208	NJ	Union	39	school	3403570	980	Cranford Twp	340357005466	50	Brookside Place School	Regular School	No	Elementary	KG	05	2020	pk_12_total	308.0	1.0	28.0	0.0	15.0	0.0	5.0	0	0.0	0.3	357.0	308	1	28	0	15	0	5	357
2475209	NJ	Union	39	school	3403570	980	Cranford Twp	340357005470	80	Livingston Avenue School	Regular School	No	Elementary	03	05	2020	pk_12_total	212.0	6.0	27.0	0.0	9.0	0.0	8.0	0	0.0	2.3	262.0	212	6	27	0	9	0	8	262
2475210	NJ	Union	39	school	3403570	980	Cranford Twp	340357005474	110	Walnut Avenue School	Regular School	No	Elementary	PK	02	2020	pk_12_total	255.0	4.0	32.0	0.0	14.0	1.0	7.0	0	0.0	0.8999999999999999	313.0	255	4	32	0	14	1	7	313
2477706	NJ	Union	39	school	3403570	980	Cranford Twp	340357005458	30	Cranford High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day											0.0								0
2477707	NJ	Union	39	school	3403570	980	Cranford Twp	340357005460	33	Hillside Avenue School	Regular School	No	Elementary	KG	08	2020	pre_kindergarten_full_day											0.0								0
2477708	NJ	Union	39	school	3403570	980	Cranford Twp	340357005462	37	Orange Avenue School	Regular School	No	Middle	03	08	2020	pre_kindergarten_full_day											0.0								0
2477709	NJ	Union	39	school	3403570	980	Cranford Twp	340357000206	40	Bloomingdale Avenue School	Regular School	No	Elementary	KG	02	2020	pre_kindergarten_full_day											0.0								0
2477710	NJ	Union	39	school	3403570	980	Cranford Twp	340357005466	50	Brookside Place School	Regular School	No	Elementary	KG	05	2020	pre_kindergarten_full_day											0.0								0
2477711	NJ	Union	39	school	3403570	980	Cranford Twp	340357005470	80	Livingston Avenue School	Regular School	No	Elementary	03	05	2020	pre_kindergarten_full_day											0.0								0
2477712	NJ	Union	39	school	3403570	980	Cranford Twp	340357005474	110	Walnut Avenue School	Regular School	No	Elementary	PK	02	2020	pre_kindergarten_full_day											49.0								49
2480208	NJ	Union	39	school	3403570	980	Cranford Twp	340357005458	30	Cranford High School	Regular School	No	High	09	12	2020	pre_kindergarten_half_day											0.0								0
2480209	NJ	Union	39	school	3403570	980	Cranford Twp	340357005460	33	Hillside Avenue School	Regular School	No	Elementary	KG	08	2020	pre_kindergarten_half_day											0.0								0
2480210	NJ	Union	39	school	3403570	980	Cranford Twp	340357005462	37	Orange Avenue School	Regular School	No	Middle	03	08	2020	pre_kindergarten_half_day											0.0								0
2480211	NJ	Union	39	school	3403570	980	Cranford Twp	340357000206	40	Bloomingdale Avenue School	Regular School	No	Elementary	KG	02	2020	pre_kindergarten_half_day											0.0								0
2480212	NJ	Union	39	school	3403570	980	Cranford Twp	340357005466	50	Brookside Place School	Regular School	No	Elementary	KG	05	2020	pre_kindergarten_half_day											0.0								0
2480213	NJ	Union	39	school	3403570	980	Cranford Twp	340357005470	80	Livingston Avenue School	Regular School	No	Elementary	03	05	2020	pre_kindergarten_half_day											0.0								0
2480214	NJ	Union	39	school	3403570	980	Cranford Twp	340357005474	110	Walnut Avenue School	Regular School	No	Elementary	PK	02	2020	pre_kindergarten_half_day											0.0								0
2482710	NJ	Union	39	school	3403570	980	Cranford Twp	340357005458	30	Cranford High School	Regular School	No	High	09	12	2020	kindergarten_full_day											0.0								0
2482711	NJ	Union	39	school	3403570	980	Cranford Twp	340357005460	33	Hillside Avenue School	Regular School	No	Elementary	KG	08	2020	kindergarten_full_day											0.0								0
2482712	NJ	Union	39	school	3403570	980	Cranford Twp	340357005462	37	Orange Avenue School	Regular School	No	Middle	03	08	2020	kindergarten_full_day											0.0								0
2482713	NJ	Union	39	school	3403570	980	Cranford Twp	340357000206	40	Bloomingdale Avenue School	Regular School	No	Elementary	KG	02	2020	kindergarten_full_day											0.0								0
2482714	NJ	Union	39	school	3403570	980	Cranford Twp	340357005466	50	Brookside Place School	Regular School	No	Elementary	KG	05	2020	kindergarten_full_day											0.0								0
2482715	NJ	Union	39	school	3403570	980	Cranford Twp	340357005470	80	Livingston Avenue School	Regular School	No	Elementary	03	05	2020	kindergarten_full_day											0.0								0
2482716	NJ	Union	39	school	3403570	980	Cranford Twp	340357005474	110	Walnut Avenue School	Regular School	No	Elementary	PK	02	2020	kindergarten_full_day											0.0								0
2485212	NJ	Union	39	school	3403570	980	Cranford Twp	340357005458	30	Cranford High School	Regular School	No	High	09	12	2020	kindergarten_half_day											0.0								0
2485213	NJ	Union	39	school	3403570	980	Cranford Twp	340357005460	33	Hillside Avenue School	Regular School	No	Elementary	KG	08	2020	kindergarten_half_day											42.0								42
2485214	NJ	Union	39	school	3403570	980	Cranford Twp	340357005462	37	Orange Avenue School	Regular School	No	Middle	03	08	2020	kindergarten_half_day											0.0								0