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 school_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
2474166	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	pk_12_total	7.5	14.0	26.0	0.0	2.0	0.0	0.0	6.1	4.0	20.2	49.5	7	14	26	0	2	0	0	49
2474943	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	pk_12_total	8.0	102.0	601.0	0.0	1.0	0.0	0.0	39.6	0.4	55.5	712.0	8	102	601	0	1	0	0	712
2476668	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	pre_kindergarten_full_day											0.0								0
2477445	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	pre_kindergarten_full_day											0.0								0
2479170	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	pre_kindergarten_half_day											0.0								0
2479947	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	pre_kindergarten_half_day											0.0								0
2481672	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	kindergarten_full_day											0.0								0
2482449	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	kindergarten_full_day											0.0								0
2484174	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	kindergarten_half_day											0.0								0
2484951	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	kindergarten_half_day											0.0								0
2486676	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	ungraded											47.5								47
2487453	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	ungraded											37.0								37
2489178	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	grade_1											0.0								0
2489955	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	grade_1											0.0								0
2491680	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	grade_2											0.0								0
2492457	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	grade_2											0.0								0
2494182	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	grade_3											0.0								0
2494959	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	grade_3											0.0								0
2496684	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	grade_4											0.0								0
2497461	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	grade_4											0.0								0
2499186	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	grade_5											0.0								0
2499963	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	grade_5											0.0								0
2501688	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	grade_6											0.0								0
2502465	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	grade_6											0.0								0
2504190	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	grade_7											0.0								0
2504967	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	grade_7											0.0								0
2506692	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	grade_8											0.0								0
2507469	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	grade_8											0.0								0
2509194	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	grade_9											0.0								0
2509971	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	grade_9											143.0								143
2511696	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	grade_10											0.0								0
2512473	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	grade_10											169.0								169
2514198	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	grade_11											0.0								0
2514975	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	grade_11											175.0								175
2516700	NJ	Mercer	21	school	3400778	1431	Katzenbach	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2020	grade_12											2.0								2
2517477	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2020	grade_12											188.0								188
2369085	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	pk_12_total	8.5	14.0	26.0	0.0	2.0	1.0	0.0	3.9	3.9	29.1	51.5	8	14	26	0	2	1	0	51
2369882	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	pk_12_total	9.0	94.0	553.0	0.0	1.0	0.0	0.0	39.7	0.2	47.0	657.0	9	94	553	0	1	0	0	657
2371590	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	pre_kindergarten_full_day											0.0								0
2372387	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	pre_kindergarten_full_day											0.0								0
2374095	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	pre_kindergarten_half_day											0.0								0
2374892	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	pre_kindergarten_half_day											0.0								0
2376600	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	kindergarten_full_day											0.0								0
2377397	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	kindergarten_full_day											0.0								0
2379105	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	kindergarten_half_day											0.0								0
2379902	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	kindergarten_half_day											0.0								0
2381610	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	ungraded											47.5								47
2382407	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	ungraded											45.0								45
2384115	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	grade_1											0.0								0
2384912	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	grade_1											0.0								0
2386620	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	grade_2											0.0								0
2387417	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	grade_2											0.0								0
2389125	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	grade_3											0.0								0
2389922	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	grade_3											0.0								0
2391630	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	grade_4											0.0								0
2392427	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	grade_4											0.0								0
2394135	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	grade_5											0.0								0
2394932	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	grade_5											0.0								0
2396640	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	grade_6											0.0								0
2397437	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	grade_6											0.0								0
2399145	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	grade_7											0.0								0
2399942	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	grade_7											0.0								0
2401650	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	grade_8											0.0								0
2402447	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	grade_8											0.0								0
2404155	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	grade_9											0.0								0
2404952	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	grade_9											135.0								135
2406660	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	grade_10											2.0								2
2407457	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	grade_10											139.0								139
2409165	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	grade_11											0.0								0
2409962	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	grade_11											165.0								165
2411670	NJ	Mercer	21	school	3400778	1431	Marie H. Katzenbach School For The Deaf	340077803329	1	Marie H Katzenbach High School	Special Education School	No	High	09	12	2021	grade_12											2.0								2
2412467	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003101	1	School Of Information Technology	Regular School	No	High	09	12	2021	grade_12											173.0								173
2473063	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	pk_12_total	24.0	12.0	39.0	0.0	6.0	0.0	1.0	0	1.2	12.200000000000001	82.0	24	12	39	0	6	0	1	82
2474024	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	pk_12_total	110.0	84.0	95.0	3.0	138.0	5.0	8.0	.2	0.2	63.0	443.0	110	84	95	3	138	5	8	443
2474944	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003103	2	School Of Culinary Arts Hospitality And Tourism	Regular School	No	High	09	12	2020	pk_12_total	3.0	197.0	486.0	0.0	0.0	0.0	0.0	21.7	1.5	63.1	686.0	3	197	486	0	0	0	0	686
2475565	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	pre_kindergarten_full_day											0.0								0
2476526	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	pre_kindergarten_full_day											0.0								0
2477446	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003103	2	School Of Culinary Arts Hospitality And Tourism	Regular School	No	High	09	12	2020	pre_kindergarten_full_day											0.0								0
2478067	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	pre_kindergarten_half_day											1.0								1
2479028	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	pre_kindergarten_half_day											0.0								0
2479948	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003103	2	School Of Culinary Arts Hospitality And Tourism	Regular School	No	High	09	12	2020	pre_kindergarten_half_day											0.0								0
2480569	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	kindergarten_full_day											2.0								2
2481530	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	kindergarten_full_day											0.0								0
2482450	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003103	2	School Of Culinary Arts Hospitality And Tourism	Regular School	No	High	09	12	2020	kindergarten_full_day											0.0								0
2483071	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	kindergarten_half_day											0.0								0
2484032	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	kindergarten_half_day											0.0								0
2484952	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003103	2	School Of Culinary Arts Hospitality And Tourism	Regular School	No	High	09	12	2020	kindergarten_half_day											0.0								0
2485573	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	ungraded											66.0								66
2486534	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	ungraded											0.0								0
2487454	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003103	2	School Of Culinary Arts Hospitality And Tourism	Regular School	No	High	09	12	2020	ungraded											44.0								44
2488075	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_1											1.0								1
2489036	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	grade_1											0.0								0
2489956	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_1											0.0								0
2490577	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_2											2.0								2
2491538	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	grade_2											0.0								0
2492458	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_2											0.0								0
2493079	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_3											2.0								2
2494040	NJ	Hudson	17	school	3407830	2390	Jersey City	340783003121	2	Infinity Institute	Regular School	No	High	06	12	2020	grade_3											0.0								0
2494960	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_3											0.0								0
2495581	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_4											0.0								0
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