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 "grade" = :p0 and "state" = :p1 and "year" = :p2 and (school_state_id > :p4 or (school_state_id = :p4 and rowid > :p3)) 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	total	total_int
2475645	NJ	Bergen	3	school	3405370	1580	Franklin Lakes Boro	340537000460	20	High Mountain Road School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_full_day	6.0	6
2475679	NJ	Bergen	3	school	3407260	2180	Hillsdale Boro	340726000526	20	George G White	Regular School	No	Middle	05	08	2020	pre_kindergarten_full_day	0.0	0
2475713	NJ	Bergen	3	school	3410620	3330	Montvale Boro	341062000616	20	Fieldstone Middle School	Regular School	No	Middle	05	08	2020	pre_kindergarten_full_day	0.0	0
2475730	NJ	Bergen	3	school	3411850	3740	Norwood Boro	341185000660	20	Norwood Public School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	0.0	0
2475837	NJ	Bergen	3	school	3418360	5920	Wyckoff Twp	341836000942	20	Calvin Coolidge Elementary School	Regular School	No	Elementary	KG	05	2020	pre_kindergarten_full_day	0.0	0
2475848	NJ	Burlington	5	school	3402430	600	Burlington City	340243000966	20	Burlington City High School	Regular School	No	High	07	12	2020	pre_kindergarten_full_day	0.0	0
2475891	NJ	Burlington	5	school	3409180	2850	Lumberton Twp	340918000222	20	Bobby'S Run Elementary School	Regular School	No	Elementary	03	05	2020	pre_kindergarten_full_day	0.0	0
2475959	NJ	Burlington	5	school	3417730	5720	Westampton	341773001256	20	Holly Hills Elementary School	Regular School	No	Elementary	PK	03	2020	pre_kindergarten_full_day	26.0	26
2475976	NJ	Camden	7	school	3401380	260	Bellmawr Boro	340138001318	20	Bellmawr Park Elementary School	Regular School	No	Elementary	PK	04	2020	pre_kindergarten_full_day	0.0	0
2475978	NJ	Camden	7	school	3401590	330	Berlin Boro	340159001324	20	Berlin Community School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	15.0	15
2475981	NJ	Camden	7	school	3401770	390	Black Horse Pike Regional	340177001336	20	Highland Regional High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2476035	NJ	Camden	7	school	3405850	1720	Gibbsboro Boro	340585001490	20	Gibbsboro Elementary School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	15.0	15
2476039	NJ	Camden	7	school	3406030	1780	Gloucester Twp	340603001508	20	Blackwood Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_full_day	20.0	20
2476078	NJ	Camden	7	school	3410890	3420	Mount Ephraim Boro	341089001598	20	Raymond W. Kershaw School	Regular School	No	Middle	06	08	2020	pre_kindergarten_full_day	0.0	0
2476094	NJ	Camden	7	school	3414430	4590	Runnemede Boro	341443001650	20	Aline Bingham Elementary School	Regular School	No	Elementary	KG	03	2020	pre_kindergarten_full_day	0.0	0
2476097	NJ	Camden	7	school	3415000	4790	Somerdale Boro	341500001660	20	Somerdale Park School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	28.0	28
2476101	NJ	Camden	7	school	3416830	5400	Voorhees Twp	341683001676	20	Edward T. Hamilton	Regular School	No	Elementary	KG	05	2020	pre_kindergarten_full_day	0.0	0
2476110	NJ	Camden	7	school	3418060	5820	Winslow Twp	341806000439	20	Winslow Township Middle School	Regular School	No	Middle	07	08	2020	pre_kindergarten_full_day	0.0	0
2476120	NJ	Cape May	9	school	3402740	715	Cape May Co Special Serv	340274001708	20	Cape May County High School	Special Education School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2476149	NJ	Cumberland	11	school	3402250	540	Bridgeton City	340225001784	20	Bridgeton High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2476195	NJ	Essex	13	school	3401350	250	Belleville Town	340135001954	20	Belleville High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2476204	NJ	Essex	13	school	3401830	410	Bloomfield Twp	340183001980	20	Bloomfield High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2476246	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2476302	NJ	Essex	13	school	3411340	3570	Newark City	341134002190	20	Barringer High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2476379	NJ	Essex	13	school	3414250	4530	Roseland Boro	341425002418	20	Lester C Noecker	Regular School	No	Elementary	PK	06	2020	pre_kindergarten_full_day	18.0	18
2476413	NJ	Gloucester	15	school	3403210	870	Clearview Regional	340321002506	20	Clearview Regional High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2476423	NJ	Gloucester	15	school	3404140	1180	East Greenwich Twp	340414000063	20	Jeffrey Clark School	Regular School	No	Elementary	PK	02	2020	pre_kindergarten_full_day	24.0	24
2476473	NJ	Gloucester	15	school	3417070	5500	Washington Twp	341707000185	20	Bunker Hill Middle School	Regular School	No	Middle	06	08	2020	pre_kindergarten_full_day	0.0	0
2476496	NJ	Hudson	17	school	3401260	220	Bayonne City	340126002704	20	Bayonne High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2476611	NJ	Hunterdon	19	school	3401710	370	Bethlehem Twp	340171002958	20	Ethel Hoppock Middle School	Regular School	No	Middle	06	08	2020	pre_kindergarten_full_day	0.0	0
2476613	NJ	Hunterdon	19	school	3401890	430	Bloomsbury Boro	340189002960	20	Bloomsbury Borough School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	12.0	12
2476623	NJ	Hunterdon	19	school	3400769	1376	South Hunterdon Regional School District	340076903010	20	Lambertville Public School	Regular School	No	Elementary	PK	06	2020	pre_kindergarten_full_day	0.0	0
2476742	NJ	Mercer	21	school	3417700	5715	W Windsor-Plainsboro Reg	341770003258	20	West Windsor-Plainsboro High School South	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2476822	NJ	Middlesex	23	school	3410500	3290	Monroe Twp	341050003442	20	Monroe Township Middle School	Regular School	No	Middle	06	08	2020	pre_kindergarten_full_day	0.0	0
2476915	NJ	Middlesex	23	school	3418120	5850	Woodbridge Twp	341812003668	20	Colonia High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2476942	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003301	20	Barack Obama Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_full_day	0.0	0
2476946	NJ	Monmouth	25	school	3401020	130	Atlantic Highlands Boro	340102003746	20	Atlantic Highlands Elementary School	Regular School	No	Elementary	PK	06	2020	pre_kindergarten_full_day	15.0	15
2476949	NJ	Monmouth	25	school	3401410	270	Belmar Boro	340141003750	20	Belmar Elementary	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	0.0	0
2476950	NJ	Monmouth	25	school	3402130	500	Bradley Beach Boro	340213003752	20	Bradley Beach Elementary School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	0.0	0
2476951	NJ	Monmouth	25	school	3402310	560	Brielle Boro	340231003754	20	Brielle Elementary School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	21.0	21
2476972	NJ	Monmouth	25	school	3405640	1660	Freehold Twp	340564003810	20	Joseph J Catena School	Regular School	No	Elementary	KG	05	2020	pre_kindergarten_full_day	0.0	0
2476990	NJ	Monmouth	25	school	3407410	2230	Holmdel Twp	340741003850	20	Holmdel High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2476998	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756003864	20	Edith M. Griebling Elementary School	Regular School	No	Elementary	KG	02	2020	pre_kindergarten_full_day	0.0	0
2477073	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750005989	20	Marine Academy Of Science And Technology	Career and Technical School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477124	NJ	Morris	27	school	3401950	450	Boonton Town	340195004154	20	Boonton High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477128	NJ	Morris	27	school	3402520	630	Butler Boro	340252004166	20	Butler High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477137	NJ	Morris	27	school	3403060	820	Chester Twp	340306004194	20	Black River Middle School	Regular School	No	Middle	06	08	2020	pre_kindergarten_full_day	0.0	0
2477152	NJ	Morris	27	school	3405250	1530	Florham Park Boro	340525004236	20	Brooklake School	Regular School	No	Elementary	03	05	2020	pre_kindergarten_full_day	0.0	0
2477161	NJ	Morris	27	school	3407800	2380	Jefferson Twp	340780004264	20	Jefferson Township High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477192	NJ	Morris	27	school	3410720	3365	Morris County Vocational	341072000522	20	Academy For Mathematics Science And Engineering	Career and Technical School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477200	NJ	Morris	27	school	3410770	3380	Morris Plains Boro	341077004358	20	Morris Plains Borough School	Regular School	No	Middle	03	08	2020	pre_kindergarten_full_day	0.0	0
2477283	NJ	Ocean	29	school	3401230	210	Bay Head Boro	340123004568	20	Bay Head Elementary	Regular School	No	Elementary	KG	08	2020	pre_kindergarten_full_day	0.0	0
2477284	NJ	Ocean	29	school	3401290	230	Beach Haven Boro	340129004570	20	Beach Haven School	Regular School	No	Elementary	PK	06	2020	pre_kindergarten_full_day	9.0	9
2477285	NJ	Ocean	29	school	3401560	320	Berkeley Twp	340156004574	20	Bayville Elementary School	Regular School	No	Elementary	PK	04	2020	pre_kindergarten_full_day	0.0	0
2477289	NJ	Ocean	29	school	3402220	530	Brick Twp	340222004582	20	Brick Township High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477303	NJ	Ocean	29	school	3404050	1150	Eagleswood Twp	340405004606	20	Eagleswood Elementary School	Regular School	No	Elementary	PK	06	2020	pre_kindergarten_full_day	0.0	0
2477305	NJ	Ocean	29	school	3407740	2360	Jackson Twp	340774004612	20	Jackson Memorial High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477315	NJ	Ocean	29	school	3408100	2480	Lacey Twp	340810005935	20	Lacey Township High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477334	NJ	Ocean	29	school	3408910	2760	Long Beach Island	340891004654	20	Ethel A. Jacobsen Elementary School	Regular School	No	Elementary	PK	02	2020	pre_kindergarten_full_day	9.0	9
2477343	NJ	Ocean	29	school	3411980	3790	Ocean County Vocational	341198004672	20	Ocean County Vocational Technical School Jackson Center	Career and Technical School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477389	NJ	Passaic	31	school	3401860	420	Bloomingdale Boro	340186004754	20	Martha B. Day Elementary School	Regular School	No	Elementary	PK	01	2020	pre_kindergarten_full_day	6.0	6
2477451	NJ	Passaic	31	school	3412690	4010	Paterson City	341269005998	20	Rosa L. Parks School Of Fine And Performing Arts	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477535	NJ	Salem	33	school	3400810	60	Alloway Twp	340081005028	20	Alloway Township School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	25.0	25
2477569	NJ	Somerset	35	school	3401320	240	Bedminster Twp	340132005120	20	Bedminster Township Public School	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	5.0	5
2477576	NJ	Somerset	35	school	3402100	490	Bound Brook Boro	340210005144	20	Bound Brook High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477581	NJ	Somerset	35	school	3402160	510	Branchburg Twp	340216005154	20	Branchburg Central Middle School	Regular School	No	Middle	06	08	2020	pre_kindergarten_full_day	0.0	0
2477635	NJ	Somerset	35	school	3400009	4815	Somerset Hills Regional	340000900176	20	Bernards High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477683	NJ	Sussex	37	school	3415960	5100	Sussex-Wantage Regional	341596005945	20	Clifton E. Lawrence	Regular School	No	Elementary	PK	02	2020	pre_kindergarten_full_day	0.0	0
2477688	NJ	Sussex	37	school	3416710	5360	Vernon Twp	341671005422	20	Vernon Township High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477696	NJ	Union	39	school	3401530	310	Berkeley Heights Twp	340153005434	20	Thomas P. Hughes School	Regular School	No	Elementary	02	05	2020	pre_kindergarten_full_day	0.0	0
2477797	NJ	Union	39	school	3414280	4540	Roselle Boro	341428005652	20	Harrison Elementary School	Regular School	No	Elementary	01	04	2020	pre_kindergarten_full_day	0.0	0
2477832	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006008	20	Hillcrest Academy-North	Alternative School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477837	NJ	Union	39	school	3418040	5260	Union County Vocational	341804000584	20	Academy For Allied Health Sciences	Career and Technical School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477867	NJ	Warren	41	school	3400720	30	Allamuchy Twp	340072003066	20	Mountain Villa School	Regular School	No	Elementary	PK	02	2020	pre_kindergarten_full_day	1.0	1
2477869	NJ	Warren	41	school	3401440	280	Belvidere Town	340144005794	20	Belvidere High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2476973	NJ	Monmouth	25	school	3405640	1660	Freehold Twp	340564003812	21	C. Richard Applegate School	Regular School	No	Elementary	KG	05	2020	pre_kindergarten_full_day	0.0	0
2476974	NJ	Monmouth	25	school	3405640	1660	Freehold Twp	340564003814	23	Clifton T. Barkalow School	Regular School	No	Middle	06	08	2020	pre_kindergarten_full_day	0.0	0
2477689	NJ	Sussex	37	school	3416710	5360	Vernon Twp	341671006009	23	Cedar Mountain Primary School	Regular School	No	Elementary	KG	01	2020	pre_kindergarten_full_day	0.0	0
2476975	NJ	Monmouth	25	school	3405640	1660	Freehold Twp	340564003816	24	Dwight D. Eisenhower School	Regular School	No	Middle	06	08	2020	pre_kindergarten_full_day	0.0	0
2475508	NJ	Atlantic	1	school	3402400	590	Buena Regional	340240000044	25	Buena Regional High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2475544	NJ	Atlantic	1	school	3409690	3020	Margate City	340969000393	25	William H. Ross Iii School	Regular School	No	Elementary	PK	04	2020	pre_kindergarten_full_day	0.0	0
2475546	NJ	Atlantic	1	school	3411070	3480	Mullica Twp	341107000174	25	Mullica Township Middle School	Regular School	No	Middle	05	08	2020	pre_kindergarten_full_day	0.0	0
2475838	NJ	Bergen	3	school	3418360	5920	Wyckoff Twp	341836000944	25	Dwight D. Eisenhower Middle School	Regular School	No	Middle	06	08	2020	pre_kindergarten_full_day	0.0	0
2475842	NJ	Burlington	5	school	3401740	380	Beverly City	340174000952	25	Beverly City School District	Regular School	No	Elementary	PK	08	2020	pre_kindergarten_full_day	0.0	0
2475861	NJ	Burlington	5	school	3403090	830	Chesterfield Twp	340309001016	25	Chesterfield Township Elementary School	Regular School	No	Elementary	PK	06	2020	pre_kindergarten_full_day	29.0	29
2475985	NJ	Camden	7	school	3402640	680	Camden City	340264001344	25	Early Childhood Development Center	Regular School	No	Prekindergarten	PK	PK	2020	pre_kindergarten_full_day	0.0	0
2476157	NJ	Cumberland	11	school	3403480	950	Commercial Twp	340348001810	25	Haleyville-Mauricetown Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_full_day	0.0	0
2476196	NJ	Essex	13	school	3401350	250	Belleville Town	340135001956	25	Belleville Middle School	Regular School	No	Middle	07	08	2020	pre_kindergarten_full_day	0.0	0
2476443	NJ	Gloucester	15	school	3408880	2750	Logan Twp	340888000443	25	Center Square School	Regular School	No	Elementary	PK	01	2020	pre_kindergarten_full_day	0.0	0
2476474	NJ	Gloucester	15	school	3417070	5500	Washington Twp	341707002644	25	Bells Elementary School	Regular School	No	Elementary	01	05	2020	pre_kindergarten_full_day	0.0	0
2476743	NJ	Mercer	21	school	3417700	5715	W Windsor-Plainsboro Reg	341770000191	25	West Windsor-Plainsboro High School North	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2476976	NJ	Monmouth	25	school	3405640	1660	Freehold Twp	340564003818	25	Marshall W. Errickson School	Regular School	No	Elementary	KG	05	2020	pre_kindergarten_full_day	0.0	0
2476999	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000097	25	Howell Township Middle School North	Regular School	No	Middle	06	08	2020	pre_kindergarten_full_day	0.0	0
2477074	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750000163	25	Monmouth County Academy Of Allied Health And Science	Career and Technical School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477129	NJ	Morris	27	school	3402520	630	Butler Boro	340252004168	25	Aaron Decker School	Regular School	No	Elementary	PK	04	2020	pre_kindergarten_full_day	0.0	0
2477156	NJ	Morris	27	school	3406690	2000	Hanover Twp	340669004250	25	Bee Meadow School	Regular School	No	Elementary	KG	05	2020	pre_kindergarten_full_day	0.0	0
2477185	NJ	Morris	27	school	3410650	3340	Montville Twp	341065004334	25	Cedar Hill School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_full_day	27.0	27
2477259	NJ	Morris	27	school	3414130	4490	Rockaway Twp	341413004516	25	Dennis B O'Brien Elementary School	Regular School	No	Elementary	PK	05	2020	pre_kindergarten_full_day	20.0	20
2477286	NJ	Ocean	29	school	3401560	320	Berkeley Twp	340156006125	25	Berkeley Township Elementary School	Regular School	No	Middle	04	06	2020	pre_kindergarten_full_day	0.0	0
2477290	NJ	Ocean	29	school	3402220	530	Brick Twp	340222005896	25	Brick Township Memorial High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0
2477306	NJ	Ocean	29	school	3407740	2360	Jackson Twp	340774000787	25	Jackson Liberty High School	Regular School	No	High	09	12	2020	pre_kindergarten_full_day	0.0	0