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
2407067	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000409	4	Communications High School	Career and Technical School	No	High	09	12	2021	grade_10											79.0								79
2407472	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003107	4	School Of Health Science	Regular School	No	High	09	12	2021	grade_10											72.0								72
2408796	NJ	Essex	13	school	3411340	3570	Newark Public School District	341134005985	4	Nj Regional Day School - Newark	Special Education School	No	Other	KG	12	2021	grade_11											0.0								0
2409572	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000409	4	Communications High School	Career and Technical School	No	High	09	12	2021	grade_11											73.0								73
2409977	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003107	4	School Of Health Science	Regular School	No	High	09	12	2021	grade_11											71.0								71
2411301	NJ	Essex	13	school	3411340	3570	Newark Public School District	341134005985	4	Nj Regional Day School - Newark	Special Education School	No	Other	KG	12	2021	grade_12											2.0								2
2412077	NJ	Monmouth	25	school	3417500	3260	Monmouth County Vocational School District	341750000409	4	Communications High School	Career and Technical School	No	High	09	12	2021	grade_12											73.0								73
2412482	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003107	4	School Of Health Science	Regular School	No	High	09	12	2021	grade_12											72.0								72
2367930	NJ	Atlantic	1	school	3404560	1310	Egg Harbor Township School District	340456005961	5	Egg Harbor Township High School	Regular School	No	High	09	12	2021	pk_12_total	1032.0	227.0	577.0	3.0	410.0	4.0	79.0	2.4	0.2	41.7	2332.0	1032	227	577	3	410	4	79	2332
2368280	NJ	Burlington	5	school	3403780	1060	Delran Township School District	340378001040	5	Delran High School	Regular School	No	High	09	12	2021	pk_12_total	696.0	81.0	97.0	0.0	29.0	1.0	34.0	3.5	0.5	22.1	938.0	696	81	97	0	29	1	34	938
2368483	NJ	Camden	7	school	3408640	2670	Lindenwold Public School District	340864000429	5	Lindenwold High School	Regular School	No	High	09	12	2021	pk_12_total	49.0	224.0	334.0	0.0	8.0	0.0	6.0	17.6	7.9	81.7	621.0	49	224	334	0	8	0	6	621
2368666	NJ	Essex	13	school	3405010	1465	Fairfield Public School District	340501002086	5	Adlai E. Stevenson School	Regular School	No	Elementary	PK	03	2021	pk_12_total	311.0	2.0	58.0	0.0	21.0	0.0	4.0	4.0	0.0	2.0	396.0	311	2	58	0	21	0	4	396
2368936	NJ	Hudson	17	school	3407350	2210	Hoboken Public School District	340735002746	5	Hoboken High School	Regular School	No	High	09	12	2021	pk_12_total	70.0	73.0	272.0	1.0	8.0	1.0	3.0	0.9	0.9	60.9	428.0	70	73	272	1	8	1	3	428
2369026	NJ	Hunterdon	19	school	3400690	20	Alexandria Township School District	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2021	pk_12_total	242.0	2.0	26.0	0.0	5.0	0.0	3.0	0.0	0.0	5.4	278.0	242	2	26	0	5	0	3	278
2369243	NJ	Middlesex	23	school	3410500	3290	Monroe Township School District	341050003438	5	Monroe Township High School	Regular School	No	High	09	12	2021	pk_12_total	1187.5	95.0	220.5	0.0	937.0	7.0	26.0	1.7	0.1	9.7	2473.0	1187	95	220	0	937	7	26	2473
2369421	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756003860	5	Aldrich Elementary School	Regular School	No	Elementary	03	05	2021	pk_12_total	263.0	18.0	59.0	0.0	12.0	0.0	26.0	0.0	0.5	15.6	378.0	263	18	59	0	12	0	26	378
2369890	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003109	5	School Of Earth And Space Science	Regular School	No	High	09	12	2021	pk_12_total	1.0	68.0	139.0	0.0	7.0	0.0	0.0	8.8	0.5	51.6	215.0	1	68	139	0	7	0	0	215
2370004	NJ	Somerset	35	school	3402280	555	Bridgewater-Raritan Regional School District	340228000173	5	Bridgewater-Raritan High School	Regular School	No	High	09	12	2021	pk_12_total	1260.0	75.5	507.5	6.0	800.0	20.5	36.5	1.7	0.0	11.2	2706.0	1260	75	507	6	800	20	36	2706
2370116	NJ	Union	39	school	3401530	310	Berkeley Heights School District	340153000201	5	Governor Livingston High School	Regular School	No	High	09	12	2021	pk_12_total	710.0	9.0	108.0	1.0	87.5	0.0	35.0	0.2	0.0	0.6000000000000001	950.5	710	9	108	1	87	0	35	950
2370117	NJ	Union	39	school	3403150	850	Clark Township Public School District	340315000205	5	Arthur L. Johnson High School	Regular School	No	High	09	12	2021	pk_12_total	579.5	9.5	80.5	0.0	17.5	0.0	6.0	0.1	0.0	5.3	693.0	579	9	80	0	17	0	6	693
2370435	NJ	Atlantic	1	school	3404560	1310	Egg Harbor Township School District	340456005961	5	Egg Harbor Township High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day											0.0								0
2370785	NJ	Burlington	5	school	3403780	1060	Delran Township School District	340378001040	5	Delran High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day											0.0								0
2370988	NJ	Camden	7	school	3408640	2670	Lindenwold Public School District	340864000429	5	Lindenwold High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day											0.0								0
2371171	NJ	Essex	13	school	3405010	1465	Fairfield Public School District	340501002086	5	Adlai E. Stevenson School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten_full_day											37.0								37
2371441	NJ	Hudson	17	school	3407350	2210	Hoboken Public School District	340735002746	5	Hoboken High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day											0.0								0
2371531	NJ	Hunterdon	19	school	3400690	20	Alexandria Township School District	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2021	pre_kindergarten_full_day											0.0								0
2371748	NJ	Middlesex	23	school	3410500	3290	Monroe Township School District	341050003438	5	Monroe Township High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day											0.0								0
2371926	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756003860	5	Aldrich Elementary School	Regular School	No	Elementary	03	05	2021	pre_kindergarten_full_day											0.0								0
2372395	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003109	5	School Of Earth And Space Science	Regular School	No	High	09	12	2021	pre_kindergarten_full_day											0.0								0
2372509	NJ	Somerset	35	school	3402280	555	Bridgewater-Raritan Regional School District	340228000173	5	Bridgewater-Raritan High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day											0.0								0
2372621	NJ	Union	39	school	3401530	310	Berkeley Heights School District	340153000201	5	Governor Livingston High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day											0.0								0
2372622	NJ	Union	39	school	3403150	850	Clark Township Public School District	340315000205	5	Arthur L. Johnson High School	Regular School	No	High	09	12	2021	pre_kindergarten_full_day											0.0								0
2372940	NJ	Atlantic	1	school	3404560	1310	Egg Harbor Township School District	340456005961	5	Egg Harbor Township High School	Regular School	No	High	09	12	2021	pre_kindergarten_half_day											0.0								0
2373290	NJ	Burlington	5	school	3403780	1060	Delran Township School District	340378001040	5	Delran High School	Regular School	No	High	09	12	2021	pre_kindergarten_half_day											0.0								0
2373493	NJ	Camden	7	school	3408640	2670	Lindenwold Public School District	340864000429	5	Lindenwold High School	Regular School	No	High	09	12	2021	pre_kindergarten_half_day											0.0								0
2373676	NJ	Essex	13	school	3405010	1465	Fairfield Public School District	340501002086	5	Adlai E. Stevenson School	Regular School	No	Elementary	PK	03	2021	pre_kindergarten_half_day											1.0								1
2373946	NJ	Hudson	17	school	3407350	2210	Hoboken Public School District	340735002746	5	Hoboken High School	Regular School	No	High	09	12	2021	pre_kindergarten_half_day											0.0								0
2374036	NJ	Hunterdon	19	school	3400690	20	Alexandria Township School District	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2021	pre_kindergarten_half_day											0.0								0
2374253	NJ	Middlesex	23	school	3410500	3290	Monroe Township School District	341050003438	5	Monroe Township High School	Regular School	No	High	09	12	2021	pre_kindergarten_half_day											0.0								0
2374431	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756003860	5	Aldrich Elementary School	Regular School	No	Elementary	03	05	2021	pre_kindergarten_half_day											0.0								0
2374900	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003109	5	School Of Earth And Space Science	Regular School	No	High	09	12	2021	pre_kindergarten_half_day											0.0								0
2375014	NJ	Somerset	35	school	3402280	555	Bridgewater-Raritan Regional School District	340228000173	5	Bridgewater-Raritan High School	Regular School	No	High	09	12	2021	pre_kindergarten_half_day											0.0								0
2375126	NJ	Union	39	school	3401530	310	Berkeley Heights School District	340153000201	5	Governor Livingston High School	Regular School	No	High	09	12	2021	pre_kindergarten_half_day											0.0								0
2375127	NJ	Union	39	school	3403150	850	Clark Township Public School District	340315000205	5	Arthur L. Johnson High School	Regular School	No	High	09	12	2021	pre_kindergarten_half_day											0.0								0
2375445	NJ	Atlantic	1	school	3404560	1310	Egg Harbor Township School District	340456005961	5	Egg Harbor Township High School	Regular School	No	High	09	12	2021	kindergarten_full_day											0.0								0
2375795	NJ	Burlington	5	school	3403780	1060	Delran Township School District	340378001040	5	Delran High School	Regular School	No	High	09	12	2021	kindergarten_full_day											0.0								0
2375998	NJ	Camden	7	school	3408640	2670	Lindenwold Public School District	340864000429	5	Lindenwold High School	Regular School	No	High	09	12	2021	kindergarten_full_day											0.0								0
2376181	NJ	Essex	13	school	3405010	1465	Fairfield Public School District	340501002086	5	Adlai E. Stevenson School	Regular School	No	Elementary	PK	03	2021	kindergarten_full_day											76.0								76
2376451	NJ	Hudson	17	school	3407350	2210	Hoboken Public School District	340735002746	5	Hoboken High School	Regular School	No	High	09	12	2021	kindergarten_full_day											0.0								0
2376541	NJ	Hunterdon	19	school	3400690	20	Alexandria Township School District	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2021	kindergarten_full_day											0.0								0
2376758	NJ	Middlesex	23	school	3410500	3290	Monroe Township School District	341050003438	5	Monroe Township High School	Regular School	No	High	09	12	2021	kindergarten_full_day											0.0								0
2376936	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756003860	5	Aldrich Elementary School	Regular School	No	Elementary	03	05	2021	kindergarten_full_day											0.0								0
2377405	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003109	5	School Of Earth And Space Science	Regular School	No	High	09	12	2021	kindergarten_full_day											0.0								0
2377519	NJ	Somerset	35	school	3402280	555	Bridgewater-Raritan Regional School District	340228000173	5	Bridgewater-Raritan High School	Regular School	No	High	09	12	2021	kindergarten_full_day											0.0								0
2377631	NJ	Union	39	school	3401530	310	Berkeley Heights School District	340153000201	5	Governor Livingston High School	Regular School	No	High	09	12	2021	kindergarten_full_day											0.0								0
2377632	NJ	Union	39	school	3403150	850	Clark Township Public School District	340315000205	5	Arthur L. Johnson High School	Regular School	No	High	09	12	2021	kindergarten_full_day											0.0								0
2377950	NJ	Atlantic	1	school	3404560	1310	Egg Harbor Township School District	340456005961	5	Egg Harbor Township High School	Regular School	No	High	09	12	2021	kindergarten_half_day											0.0								0
2378300	NJ	Burlington	5	school	3403780	1060	Delran Township School District	340378001040	5	Delran High School	Regular School	No	High	09	12	2021	kindergarten_half_day											0.0								0
2378503	NJ	Camden	7	school	3408640	2670	Lindenwold Public School District	340864000429	5	Lindenwold High School	Regular School	No	High	09	12	2021	kindergarten_half_day											0.0								0
2378686	NJ	Essex	13	school	3405010	1465	Fairfield Public School District	340501002086	5	Adlai E. Stevenson School	Regular School	No	Elementary	PK	03	2021	kindergarten_half_day											0.0								0
2378956	NJ	Hudson	17	school	3407350	2210	Hoboken Public School District	340735002746	5	Hoboken High School	Regular School	No	High	09	12	2021	kindergarten_half_day											0.0								0
2379046	NJ	Hunterdon	19	school	3400690	20	Alexandria Township School District	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2021	kindergarten_half_day											0.0								0
2379263	NJ	Middlesex	23	school	3410500	3290	Monroe Township School District	341050003438	5	Monroe Township High School	Regular School	No	High	09	12	2021	kindergarten_half_day											0.0								0
2379441	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756003860	5	Aldrich Elementary School	Regular School	No	Elementary	03	05	2021	kindergarten_half_day											0.0								0
2379910	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003109	5	School Of Earth And Space Science	Regular School	No	High	09	12	2021	kindergarten_half_day											0.0								0
2380024	NJ	Somerset	35	school	3402280	555	Bridgewater-Raritan Regional School District	340228000173	5	Bridgewater-Raritan High School	Regular School	No	High	09	12	2021	kindergarten_half_day											0.0								0
2380136	NJ	Union	39	school	3401530	310	Berkeley Heights School District	340153000201	5	Governor Livingston High School	Regular School	No	High	09	12	2021	kindergarten_half_day											0.0								0
2380137	NJ	Union	39	school	3403150	850	Clark Township Public School District	340315000205	5	Arthur L. Johnson High School	Regular School	No	High	09	12	2021	kindergarten_half_day											0.0								0
2380455	NJ	Atlantic	1	school	3404560	1310	Egg Harbor Township School District	340456005961	5	Egg Harbor Township High School	Regular School	No	High	09	12	2021	ungraded											27.0								27
2380805	NJ	Burlington	5	school	3403780	1060	Delran Township School District	340378001040	5	Delran High School	Regular School	No	High	09	12	2021	ungraded											13.0								13
2381008	NJ	Camden	7	school	3408640	2670	Lindenwold Public School District	340864000429	5	Lindenwold High School	Regular School	No	High	09	12	2021	ungraded											12.0								12
2381191	NJ	Essex	13	school	3405010	1465	Fairfield Public School District	340501002086	5	Adlai E. Stevenson School	Regular School	No	Elementary	PK	03	2021	ungraded											0.0								0
2381461	NJ	Hudson	17	school	3407350	2210	Hoboken Public School District	340735002746	5	Hoboken High School	Regular School	No	High	09	12	2021	ungraded											5.0								5
2381551	NJ	Hunterdon	19	school	3400690	20	Alexandria Township School District	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2021	ungraded											0.0								0
2381768	NJ	Middlesex	23	school	3410500	3290	Monroe Township School District	341050003438	5	Monroe Township High School	Regular School	No	High	09	12	2021	ungraded											10.0								10
2381946	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756003860	5	Aldrich Elementary School	Regular School	No	Elementary	03	05	2021	ungraded											1.0								1
2382415	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003109	5	School Of Earth And Space Science	Regular School	No	High	09	12	2021	ungraded											14.0								14
2382529	NJ	Somerset	35	school	3402280	555	Bridgewater-Raritan Regional School District	340228000173	5	Bridgewater-Raritan High School	Regular School	No	High	09	12	2021	ungraded											31.0								31
2382641	NJ	Union	39	school	3401530	310	Berkeley Heights School District	340153000201	5	Governor Livingston High School	Regular School	No	High	09	12	2021	ungraded											8.5								8
2382642	NJ	Union	39	school	3403150	850	Clark Township Public School District	340315000205	5	Arthur L. Johnson High School	Regular School	No	High	09	12	2021	ungraded											10.5								10
2382960	NJ	Atlantic	1	school	3404560	1310	Egg Harbor Township School District	340456005961	5	Egg Harbor Township High School	Regular School	No	High	09	12	2021	grade_1											0.0								0
2383310	NJ	Burlington	5	school	3403780	1060	Delran Township School District	340378001040	5	Delran High School	Regular School	No	High	09	12	2021	grade_1											0.0								0
2383513	NJ	Camden	7	school	3408640	2670	Lindenwold Public School District	340864000429	5	Lindenwold High School	Regular School	No	High	09	12	2021	grade_1											0.0								0
2383696	NJ	Essex	13	school	3405010	1465	Fairfield Public School District	340501002086	5	Adlai E. Stevenson School	Regular School	No	Elementary	PK	03	2021	grade_1											99.0								99
2383966	NJ	Hudson	17	school	3407350	2210	Hoboken Public School District	340735002746	5	Hoboken High School	Regular School	No	High	09	12	2021	grade_1											0.0								0
2384056	NJ	Hunterdon	19	school	3400690	20	Alexandria Township School District	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2021	grade_1											0.0								0
2384273	NJ	Middlesex	23	school	3410500	3290	Monroe Township School District	341050003438	5	Monroe Township High School	Regular School	No	High	09	12	2021	grade_1											0.0								0
2384451	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756003860	5	Aldrich Elementary School	Regular School	No	Elementary	03	05	2021	grade_1											0.0								0
2384920	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003109	5	School Of Earth And Space Science	Regular School	No	High	09	12	2021	grade_1											0.0								0
2385034	NJ	Somerset	35	school	3402280	555	Bridgewater-Raritan Regional School District	340228000173	5	Bridgewater-Raritan High School	Regular School	No	High	09	12	2021	grade_1											0.0								0
2385146	NJ	Union	39	school	3401530	310	Berkeley Heights School District	340153000201	5	Governor Livingston High School	Regular School	No	High	09	12	2021	grade_1											0.0								0
2385147	NJ	Union	39	school	3403150	850	Clark Township Public School District	340315000205	5	Arthur L. Johnson High School	Regular School	No	High	09	12	2021	grade_1											0.0								0
2385465	NJ	Atlantic	1	school	3404560	1310	Egg Harbor Township School District	340456005961	5	Egg Harbor Township High School	Regular School	No	High	09	12	2021	grade_2											0.0								0
2385815	NJ	Burlington	5	school	3403780	1060	Delran Township School District	340378001040	5	Delran High School	Regular School	No	High	09	12	2021	grade_2											0.0								0
2386018	NJ	Camden	7	school	3408640	2670	Lindenwold Public School District	340864000429	5	Lindenwold High School	Regular School	No	High	09	12	2021	grade_2											0.0								0
2386201	NJ	Essex	13	school	3405010	1465	Fairfield Public School District	340501002086	5	Adlai E. Stevenson School	Regular School	No	Elementary	PK	03	2021	grade_2											96.0								96
2386471	NJ	Hudson	17	school	3407350	2210	Hoboken Public School District	340735002746	5	Hoboken High School	Regular School	No	High	09	12	2021	grade_2											0.0								0
2386561	NJ	Hunterdon	19	school	3400690	20	Alexandria Township School District	340069002954	5	Alexandria Middle School	Regular School	No	Middle	04	08	2021	grade_2											0.0								0
2386778	NJ	Middlesex	23	school	3410500	3290	Monroe Township School District	341050003438	5	Monroe Township High School	Regular School	No	High	09	12	2021	grade_2											0.0								0
2386956	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756003860	5	Aldrich Elementary School	Regular School	No	Elementary	03	05	2021	grade_2											0.0								0
2387425	NJ	Passaic	31	school	3412690	4010	Paterson Public School District	341269003109	5	School Of Earth And Space Science	Regular School	No	High	09	12	2021	grade_2											0.0								0