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 (school_state_id > :p2 or (school_state_id = :p2 and rowid > :p1)) 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
2369415	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	pk_12_total	207.0	11.0	81.0	0.0	30.0	0.0	16.0	25.5	0.0	23.700000000000003	345.0	207	11	81	0	30	0	16	345
2369490	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	pk_12_total	9.0	6.0	3.0	0.0	0.0	0.0	0.0	0.0	0.0	44.4	18.0	9	6	3	0	0	0	0	18
2369889	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	pk_12_total	1.0	78.0	615.0	0.0	1.0	0.0	0.0	46.9	0.4	54.5	695.0	1	78	615	0	1	0	0	695
2371920	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	pre_kindergarten_full_day											0.0								0
2371995	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	pre_kindergarten_full_day											0.0								0
2372394	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	pre_kindergarten_full_day											0.0								0
2374425	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	pre_kindergarten_half_day											0.0								0
2374500	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	pre_kindergarten_half_day											0.0								0
2374899	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	pre_kindergarten_half_day											0.0								0
2376930	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	kindergarten_full_day											112.0								112
2377005	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	kindergarten_full_day											0.0								0
2377404	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	kindergarten_full_day											0.0								0
2379435	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	kindergarten_half_day											0.0								0
2379510	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	kindergarten_half_day											0.0								0
2379909	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	kindergarten_half_day											0.0								0
2381940	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	ungraded											0.0								0
2382015	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	ungraded											0.0								0
2382414	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	ungraded											38.0								38
2384445	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	grade_1											108.0								108
2384520	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	grade_1											0.0								0
2384919	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	grade_1											0.0								0
2386950	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	grade_2											125.0								125
2387025	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	grade_2											0.0								0
2387424	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	grade_2											0.0								0
2389455	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	grade_3											0.0								0
2389530	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	grade_3											0.0								0
2389929	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	grade_3											0.0								0
2391960	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	grade_4											0.0								0
2392035	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	grade_4											0.0								0
2392434	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	grade_4											0.0								0
2394465	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	grade_5											0.0								0
2394540	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	grade_5											0.0								0
2394939	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	grade_5											0.0								0
2396970	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	grade_6											0.0								0
2397045	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	grade_6											0.0								0
2397444	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	grade_6											0.0								0
2399475	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	grade_7											0.0								0
2399550	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	grade_7											0.0								0
2399949	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	grade_7											0.0								0
2401980	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	grade_8											0.0								0
2402055	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	grade_8											0.0								0
2402454	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	grade_8											0.0								0
2404485	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	grade_9											0.0								0
2404560	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	grade_9											0.0								0
2404959	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	grade_9											162.0								162
2406990	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	grade_10											0.0								0
2407065	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	grade_10											1.0								1
2407464	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	grade_10											184.0								184
2409495	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	grade_11											0.0								0
2409570	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	grade_11											1.0								1
2409969	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	grade_11											136.0								136
2412000	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000721	3	Adelphia Elementary School	Regular School	No	Elementary	KG	02	2021	grade_12											0.0								0
2412075	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000161	3	Class Academy	Career and Technical School	No	High	09	12	2021	grade_12											16.0								16
2412474	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003105	3	School Of Government And Public Administration	Regular School	No	High	09	12	2021	grade_12											175.0								175
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