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 (school_state_id > :p3 or (school_state_id = :p3 and rowid > :p2)) order by school_state_id, 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
2496542	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	grade_4											0.0								0
2497462	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003103	2	School Of Culinary Arts Hospitality And Tourism	Regular School	No	High	09	12	2020	grade_4											0.0								0
2498083	NJ	Bergen	3	school	3401450	285	Bergen Co Special Service	340145005978	2	N. A. Bleshman Regional Day School	Special Education School	No	Other	PK	12	2020	grade_5											1.0								1
2499044	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	grade_5											0.0								0
2499964	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003103	2	School Of Culinary Arts Hospitality And Tourism	Regular School	No	High	09	12	2020	grade_5											0.0								0
2500585	NJ	Bergen	3	school	3401450	285	Bergen Co Special Service	340145005978	2	N. A. Bleshman Regional Day School	Special Education School	No	Other	PK	12	2020	grade_6											1.0								1
2501546	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	grade_6											122.0								122
2502466	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003103	2	School Of Culinary Arts Hospitality And Tourism	Regular School	No	High	09	12	2020	grade_6											0.0								0
2503087	NJ	Bergen	3	school	3401450	285	Bergen Co Special Service	340145005978	2	N. A. Bleshman Regional Day School	Special Education School	No	Other	PK	12	2020	grade_7											0.0								0
2504048	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	grade_7											64.0								64
2504968	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003103	2	School Of Culinary Arts Hospitality And Tourism	Regular School	No	High	09	12	2020	grade_7											0.0								0
2505589	NJ	Bergen	3	school	3401450	285	Bergen Co Special Service	340145005978	2	N. A. Bleshman Regional Day School	Special Education School	No	Other	PK	12	2020	grade_8											0.0								0
2506550	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	grade_8											33.0								33
2507470	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003103	2	School Of Culinary Arts Hospitality And Tourism	Regular School	No	High	09	12	2020	grade_8											0.0								0
2508091	NJ	Bergen	3	school	3401450	285	Bergen Co Special Service	340145005978	2	N. A. Bleshman Regional Day School	Special Education School	No	Other	PK	12	2020	grade_9											0.0								0
2509052	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	grade_9											67.0								67
2509972	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003103	2	School Of Culinary Arts Hospitality And Tourism	Regular School	No	High	09	12	2020	grade_9											180.0								180
2510593	NJ	Bergen	3	school	3401450	285	Bergen Co Special Service	340145005978	2	N. A. Bleshman Regional Day School	Special Education School	No	Other	PK	12	2020	grade_10											1.0								1
2511554	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	grade_10											60.0								60
2512474	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003103	2	School Of Culinary Arts Hospitality And Tourism	Regular School	No	High	09	12	2020	grade_10											158.0								158
2513095	NJ	Bergen	3	school	3401450	285	Bergen Co Special Service	340145005978	2	N. A. Bleshman Regional Day School	Special Education School	No	Other	PK	12	2020	grade_11											0.0								0
2514056	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	grade_11											52.0								52
2514976	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003103	2	School Of Culinary Arts Hospitality And Tourism	Regular School	No	High	09	12	2020	grade_11											145.0								145
2515597	NJ	Bergen	3	school	3401450	285	Bergen Co Special Service	340145005978	2	N. A. Bleshman Regional Day School	Special Education School	No	Other	PK	12	2020	grade_12											5.0								5
2516558	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	grade_12											45.0								45
2517478	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003103	2	School Of Culinary Arts Hospitality And Tourism	Regular School	No	High	09	12	2020	grade_12											159.0								159
2474492	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	pk_12_total	191.0	8.0	93.0	0.0	42.0	0.0	15.0	26.6	0.0	29.200000000000003	349.0	191	8	93	0	42	0	15	349
2474568	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	pk_12_total	15.0	11.0	12.0	0.0	0.0	0.0	0.0	0	0.0	39.4	38.0	15	11	12	0	0	0	0	38
2474945	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	pk_12_total	2.0	81.0	646.0	0.0	0.0	0.0	0.0	39.4	0.7	64.7	729.0	2	81	646	0	0	0	0	729
2476994	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	pre_kindergarten_full_day											0.0								0
2477070	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	pre_kindergarten_full_day											0.0								0
2477447	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	pre_kindergarten_full_day											0.0								0
2479496	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	pre_kindergarten_half_day											0.0								0
2479572	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	pre_kindergarten_half_day											0.0								0
2479949	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	pre_kindergarten_half_day											0.0								0
2481998	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	kindergarten_full_day											106.0								106
2482074	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	kindergarten_full_day											0.0								0
2482451	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	kindergarten_full_day											0.0								0
2484500	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	kindergarten_half_day											0.0								0
2484576	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	kindergarten_half_day											0.0								0
2484953	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	kindergarten_half_day											0.0								0
2487002	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	ungraded											0.0								0
2487078	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	ungraded											0.0								0
2487455	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	ungraded											29.0								29
2489504	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	grade_1											123.0								123
2489580	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	grade_1											0.0								0
2489957	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	grade_1											0.0								0
2492006	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	grade_2											120.0								120
2492082	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	grade_2											0.0								0
2492459	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	grade_2											0.0								0
2494508	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	grade_3											0.0								0
2494584	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	grade_3											0.0								0
2494961	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	grade_3											0.0								0
2497010	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	grade_4											0.0								0
2497086	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	grade_4											0.0								0
2497463	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	grade_4											0.0								0
2499512	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	grade_5											0.0								0
2499588	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	grade_5											0.0								0
2499965	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	grade_5											0.0								0
2502014	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	grade_6											0.0								0
2502090	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	grade_6											0.0								0
2502467	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	grade_6											0.0								0
2504516	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	grade_7											0.0								0
2504592	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	grade_7											0.0								0
2504969	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	grade_7											0.0								0
2507018	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	grade_8											0.0								0
2507094	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	grade_8											0.0								0
2507471	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	grade_8											0.0								0
2509520	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	grade_9											0.0								0
2509596	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	grade_9											1.0								1
2509973	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	grade_9											193.0								193
2512022	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	grade_10											0.0								0
2512098	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	grade_10											0.0								0
2512475	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	grade_10											149.0								149
2514524	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	grade_11											0.0								0
2514600	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	grade_11											13.0								13
2514977	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	grade_11											184.0								184
2517026	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2020	grade_12											0.0								0
2517102	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2020	grade_12											24.0								24
2517479	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2020	grade_12											174.0								174
2473798	NJ	Essex	13	school	3411340	3570	Newark City	341134005985	4	Nj Regional Day School - Newark	Special Education School	No	Other	KG	12	2020	pk_12_total	8.0	68.0	45.0	0.0	0.0	0.0	0.0	0	4.1	86.0	121.0	8	68	45	0	0	0	0	121
2474569	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000409	4	Communications High School	Career and Technical School	No	High	09	12	2020	pk_12_total	251.0	2.0	18.0	0.0	24.0	0.0	8.0	0	0.0	2.0	303.0	251	2	18	0	24	0	8	303
2474946	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003107	4	School Of Health Science	Regular School	No	High	09	12	2020	pk_12_total	11.0	64.0	205.0	0.0	15.0	0.0	0.0	6.8	0.3	62.3	295.0	11	64	205	0	15	0	0	295
2476300	NJ	Essex	13	school	3411340	3570	Newark City	341134005985	4	Nj Regional Day School - Newark	Special Education School	No	Other	KG	12	2020	pre_kindergarten_full_day											0.0								0
2477071	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000409	4	Communications High School	Career and Technical School	No	High	09	12	2020	pre_kindergarten_full_day											0.0								0
2477448	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003107	4	School Of Health Science	Regular School	No	High	09	12	2020	pre_kindergarten_full_day											0.0								0
2478802	NJ	Essex	13	school	3411340	3570	Newark City	341134005985	4	Nj Regional Day School - Newark	Special Education School	No	Other	KG	12	2020	pre_kindergarten_half_day											0.0								0
2479573	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000409	4	Communications High School	Career and Technical School	No	High	09	12	2020	pre_kindergarten_half_day											0.0								0
2479950	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003107	4	School Of Health Science	Regular School	No	High	09	12	2020	pre_kindergarten_half_day											0.0								0
2481304	NJ	Essex	13	school	3411340	3570	Newark City	341134005985	4	Nj Regional Day School - Newark	Special Education School	No	Other	KG	12	2020	kindergarten_full_day											0.0								0
2482075	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000409	4	Communications High School	Career and Technical School	No	High	09	12	2020	kindergarten_full_day											0.0								0
2482452	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003107	4	School Of Health Science	Regular School	No	High	09	12	2020	kindergarten_full_day											0.0								0
2483806	NJ	Essex	13	school	3411340	3570	Newark City	341134005985	4	Nj Regional Day School - Newark	Special Education School	No	Other	KG	12	2020	kindergarten_half_day											0.0								0
2484577	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000409	4	Communications High School	Career and Technical School	No	High	09	12	2020	kindergarten_half_day											0.0								0
2484954	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003107	4	School Of Health Science	Regular School	No	High	09	12	2020	kindergarten_half_day											0.0								0
2486308	NJ	Essex	13	school	3411340	3570	Newark City	341134005985	4	Nj Regional Day School - Newark	Special Education School	No	Other	KG	12	2020	ungraded											118.0								118
2487079	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000409	4	Communications High School	Career and Technical School	No	High	09	12	2020	ungraded											0.0								0
2487456	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003107	4	School Of Health Science	Regular School	No	High	09	12	2020	ungraded											4.0								4
2488810	NJ	Essex	13	school	3411340	3570	Newark City	341134005985	4	Nj Regional Day School - Newark	Special Education School	No	Other	KG	12	2020	grade_1											0.0								0
2489581	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000409	4	Communications High School	Career and Technical School	No	High	09	12	2020	grade_1											0.0								0
2489958	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003107	4	School Of Health Science	Regular School	No	High	09	12	2020	grade_1											0.0								0