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 (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	total	total_int
2402634	NJ	Sussex	37	school	3402550	640	Byram Township School District	340255000728	10	Byram Lakes Elementary School	Regular School	No	Elementary	PK	04	2021	grade_8	0.0	0
2402669	NJ	Sussex	37	school	3415930	5110	Sussex County Technical School District	341593005416	10	Sussex County Technical School	Career and Technical School	No	High	09	12	2021	grade_8	0.0	0
2402737	NJ	Union	39	school	3407920	2420	Kenilworth School District	340792000209	10	David Brearley Middle/High School	Regular School	No	High	07	12	2021	grade_8	134.0	134
2402779	NJ	Union	39	school	3414280	4540	Roselle Public Schools	341428005650	10	Abraham Clark High School	Regular School	No	High	09	12	2021	grade_8	0.0	0
2402798	NJ	Union	39	school	3415630	5000	Springfield Public School District	341563000213	10	Jonathan Dayton High School	Regular School	No	High	09	12	2021	grade_8	0.0	0
2402817	NJ	Union	39	school	3416400	5245	Union County Educational Services Commission	341640005988	10	Lamberts Mill Academy	Special Education School	No	High	06	12	2021	grade_8	1.0	1
2402847	NJ	Warren	41	school	3400720	30	Allamuchy Township School District	340072005788	10	Allamuchy Township School	Regular School	No	Middle	03	08	2021	grade_8	53.0	53
2402849	NJ	Warren	41	school	3400840	70	Alpha Borough School District	340084005790	10	Alpha Borough School	Regular School	No	Elementary	PK	08	2021	grade_8	25.0	25
2505516	NJ	Atlantic	1	school	3400960	110	Atlantic City	340096000010	10	Atlantic City High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2505527	NJ	Atlantic	1	school	3400990	120	Atlantic Co Vocational	340099000034	10	Atlantic County Institute Of Technology	Career and Technical School	No	High	09	12	2020	grade_8	0.0	0
2505567	NJ	Atlantic	1	school	3409690	3020	Margate City	340969000162	10	Eugene A. Tighe Middle School	Regular School	No	Middle	05	08	2020	grade_8	38.0	38
2505586	NJ	Bergen	3	school	3400750	40	Allendale Boro	340075000224	10	Brookside School	Regular School	No	Middle	04	08	2020	grade_8	108.0	108
2505588	NJ	Bergen	3	school	3400870	80	Alpine Boro	340087000228	10	Alpine Elementary School	Regular School	No	Elementary	KG	08	2020	grade_8	17.0	17
2505702	NJ	Bergen	3	school	3407260	2180	Hillsdale Boro	340726000524	10	Ann Blanche Smith	Regular School	No	Elementary	KG	04	2020	grade_8	0.0	0
2505860	NJ	Bergen	3	school	3418360	5920	Wyckoff Twp	341836000940	10	Abraham Lincoln Elementary School	Regular School	No	Elementary	KG	05	2020	grade_8	0.0	0
2505881	NJ	Burlington	5	school	3402460	620	Burlington Twp	340246001004	10	Burlington Township High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2505942	NJ	Burlington	5	school	3410950	3440	Mount Laurel Twp	341095001156	10	Countryside Elementary School	Regular School	No	Elementary	PK	04	2020	grade_8	0.0	0
2505994	NJ	Camden	7	school	3401050	150	Audubon Public School Disrict	340105001298	10	Audubon Junior/Senior High School	Regular School	No	High	07	12	2020	grade_8	95.0	95
2505997	NJ	Camden	7	school	3401170	190	Barrington Boro	340117001308	10	Avon Elementary School	Regular School	No	Elementary	PK	04	2020	grade_8	0.0	0
2506008	NJ	Camden	7	school	3402370	580	Brooklawn Boro	340237001340	10	Alice Costello Elementary School	Regular School	No	Elementary	PK	08	2020	grade_8	29.0	29
2506049	NJ	Camden	7	school	3403240	880	Clementon Boro	340324005899	10	Clementon Elementary School	Regular School	No	Elementary	PK	08	2020	grade_8	41.0	41
2506114	NJ	Camden	7	school	3412990	4110	Pine Hill Boro	341299000432	10	Overbrook Senior High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2506133	NJ	Camden	7	school	3418060	5820	Winslow Twp	341806000437	10	Winslow Township High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2506142	NJ	Cape May	9	school	3401110	170	Avalon Boro	340111001702	10	Avalon Elementary School	Regular School	No	Middle	05	08	2020	grade_8	13.0	13
2506325	NJ	Essex	13	school	3411340	3570	Newark City	341134002188	10	Arts High School	Regular School	No	High	08	12	2020	grade_8	0.0	0
2506449	NJ	Gloucester	15	school	3404620	1330	Elk Twp	340462002538	10	Aura Elementary School	Regular School	No	Elementary	PK	06	2020	grade_8	0.0	0
2506460	NJ	Gloucester	15	school	3406040	1775	Gloucester Co Vocational	340604002570	10	Gloucester County Institute Of Technology	Career and Technical School	No	High	09	12	2020	grade_8	0.0	0
2506496	NJ	Gloucester	15	school	3417070	5500	Washington Twp	341707002640	10	Washington Township High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2506519	NJ	Hudson	17	school	3401260	220	Bayonne City	340126003447	10	Bayonne Alternative High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2506634	NJ	Hunterdon	19	school	3400690	20	Alexandria Twp	340069002956	10	Lester D. Wilson Elementary School	Regular School	No	Elementary	PK	03	2020	grade_8	0.0	0
2506836	NJ	Middlesex	23	school	3410080	3150	Middlesex Co Vocational	341008000395	10	Middlesex County Voc Academy Math Science &Engineering Techn	Career and Technical School	No	High	09	12	2020	grade_8	0.0	0
2506845	NJ	Middlesex	23	school	3410500	3290	Monroe Twp	341050003440	10	Barclay Brook School	Regular School	No	Elementary	PK	02	2020	grade_8	0.0	0
2506965	NJ	Monmouth	25	school	3400930	100	Asbury Park City	340093003732	10	Asbury Park High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2506971	NJ	Monmouth	25	school	3401140	180	Avon Boro	340114003748	10	Avon Elementary School	Regular School	No	Elementary	PK	08	2020	grade_8	12.0	12
2506990	NJ	Monmouth	25	school	3405610	1650	Freehold Regional	340561000237	10	Colts Neck High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2507020	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756003862	10	Ardena Elementary School	Regular School	No	Elementary	03	05	2020	grade_8	0.0	0
2507030	NJ	Monmouth	25	school	3407860	2400	Keansburg Boro	340786003880	10	Keansburg High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2507096	NJ	Monmouth	25	school	3417500	3260	Monmouth Co Vocational	341750006095	10	High Technology High School	Career and Technical School	No	High	09	12	2020	grade_8	0.0	0
2507155	NJ	Morris	27	school	3400004	785	Sch Dist Of The Chathams	340000406014	10	Chatham High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2507208	NJ	Morris	27	school	3410650	3340	Montville Twp	341065004332	10	Montville Township High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2507238	NJ	Morris	27	school	3410980	3450	Mount Olive Twp	341098004398	10	Mount Olive High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2507280	NJ	Morris	27	school	3414130	4490	Rockaway Twp	341413004510	10	Birchwood Elementary School	Regular School	No	Elementary	KG	05	2020	grade_8	0.0	0
2507301	NJ	Ocean	29	school	3416470	185	Barnegat Twp	341647004564	10	Lillian M. Dunfee Elementary	Regular School	No	Elementary	PK	05	2020	grade_8	0.0	0
2507366	NJ	Ocean	29	school	3411980	3790	Ocean County Vocational	341198004670	10	Ocean County Vocational Technical School Brick Center	Career and Technical School	No	High	09	12	2020	grade_8	0.0	0
2507377	NJ	Ocean	29	school	3413230	4190	Plumsted Twp	341323000341	10	New Egypt High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2507465	NJ	Passaic	31	school	3412600	3980	Passaic Co Manchester Reg	341260004856	10	Passaic County-Manchester Regional High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2507525	NJ	Passaic	31	school	3413470	4270	Prospect Park Boro	341347004938	10	Prospect Park School No. 1	Regular School	No	Elementary	PK	08	2020	grade_8	95.0	95
2507563	NJ	Salem	33	school	3412210	3860	Oldmans Twp	341221005042	10	Oldmans Township School	Regular School	No	Elementary	PK	08	2020	grade_8	30.0	30
2507609	NJ	Somerset	35	school	3402280	555	Bridgewater-Raritan Reg	340228005162	10	Bridgewater-Raritan Middle School	Regular School	No	Middle	07	08	2020	grade_8	699.0	699
2507674	NJ	Sussex	37	school	3400900	90	Andover Reg	340090005324	10	Florence M. Burd	Regular School	No	Elementary	PK	04	2020	grade_8	0.0	0
2507676	NJ	Sussex	37	school	3402550	640	Byram Twp	340255000728	10	Byram Lakes Elementary School	Regular School	No	Elementary	PK	04	2020	grade_8	0.0	0
2507711	NJ	Sussex	37	school	3415930	5110	Sussex County Vocational	341593005416	10	Sussex County Technical School	Career and Technical School	No	High	09	12	2020	grade_8	0.0	0
2507780	NJ	Union	39	school	3407920	2420	Kenilworth Boro	340792000209	10	David Brearley Middle/High School	Regular School	No	High	07	12	2020	grade_8	132.0	132
2507820	NJ	Union	39	school	3414280	4540	Roselle Boro	341428005650	10	Abraham Clark High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2507841	NJ	Union	39	school	3415630	5000	Springfield Twp	341563000213	10	Jonathan Dayton High School	Regular School	No	High	09	12	2020	grade_8	0.0	0
2507855	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640005988	10	Lamberts Mill Academy	Special Education School	No	High	07	12	2020	grade_8	1.0	1
2507890	NJ	Warren	41	school	3400720	30	Allamuchy Twp	340072005788	10	Allamuchy Township School	Regular School	No	Middle	03	08	2020	grade_8	43.0	43
2507892	NJ	Warren	41	school	3400840	70	Alpha Boro	340084005790	10	Alpha Borough School	Regular School	No	Elementary	PK	08	2020	grade_8	35.0	35
2400831	NJ	Burlington	5	school	3402440	605	Burlington County Special Services School District	340244003303	11	Burlington County Alternative High School	Alternative School	No	High	06	12	2021	grade_8	0.0	0
2401542	NJ	Hudson	17	school	3407830	2390	Jersey City Public Schools	340783005980	11	Regional Day School	Special Education School	No	Other	PK	12	2021	grade_8	0.0	0
2505876	NJ	Burlington	5	school	3402440	605	Burlington Co Spec Serv	340244003303	11	Burlington County Alternative High School	Alternative School	No	High	06	12	2020	grade_8	1.0	1
2506551	NJ	Hudson	17	school	3407830	2390	Jersey City	340783005980	11	Regional Day School	Special Education School	No	Other	PK	12	2020	grade_8	0.0	0
2401987	NJ	Monmouth	25	school	3407560	2290	Howell Township Public School District	340756000722	12	Greenville Elementary School	Regular School	No	Elementary	KG	02	2021	grade_8	0.0	0
2507021	NJ	Monmouth	25	school	3407560	2290	Howell Twp	340756000722	12	Greenville Elementary School	Regular School	No	Elementary	KG	02	2020	grade_8	0.0	0
2400504	NJ	Atlantic	1	school	3405730	1690	Galloway Township Public School District	340573000108	15	Arthur Rann Elementary School	Regular School	No	Elementary	KG	06	2021	grade_8	0.0	0
2400621	NJ	Bergen	3	school	3405370	1580	Franklin Lakes School District	340537000117	15	Franklin Avenue Middle School	Regular School	No	Middle	06	08	2021	grade_8	148.0	148
2400846	NJ	Burlington	5	school	3403780	1060	Delran Township School District	340378000123	15	Delran Intermediate School	Regular School	No	Elementary	03	05	2021	grade_8	0.0	0
2400952	NJ	Camden	7	school	3401380	260	Bellmawr Public School District	340138001316	15	Bell Oaks Upper Elementary School	Regular School	No	Middle	05	08	2021	grade_8	106.0	106
2401417	NJ	Gloucester	15	school	3480363	1774	Gloucester County Special Services School District	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2021	grade_8	0.0	0
2402133	NJ	Morris	27	school	3405250	1530	Florham Park School District	340525004234	15	Briarwood School	Regular School	No	Elementary	PK	02	2021	grade_8	0.0	0
2402242	NJ	Morris	27	school	3414130	4490	Rockaway Township School District	341413004512	15	Copeland Middle School	Regular School	No	Middle	06	08	2021	grade_8	256.0	256
2402263	NJ	Ocean	29	school	3416470	185	Barnegat Township School District	341647005947	15	Cecil S. Collins Elementary	Regular School	No	Elementary	KG	02	2021	grade_8	0.0	0
2402392	NJ	Passaic	31	school	3406450	1920	Haledon Public School District	340645005904	15	Haledon Public School	Regular School	No	Elementary	PK	08	2021	grade_8	98.0	98
2505548	NJ	Atlantic	1	school	3405730	1690	Galloway Twp	340573000108	15	Arthur Rann Elementary School	Regular School	No	Elementary	KG	06	2020	grade_8	0.0	0
2505668	NJ	Bergen	3	school	3405370	1580	Franklin Lakes Boro	340537000117	15	Franklin Avenue Middle School	Regular School	No	Middle	06	08	2020	grade_8	129.0	129
2505894	NJ	Burlington	5	school	3403780	1060	Delran Twp	340378000123	15	Delran Intermediate School	Regular School	No	Elementary	03	05	2020	grade_8	0.0	0
2505999	NJ	Camden	7	school	3401380	260	Bellmawr Boro	340138001316	15	Bell Oaks Upper Elementary School	Regular School	No	Middle	05	08	2020	grade_8	116.0	116
2506459	NJ	Gloucester	15	school	3480363	1774	Gloucester Co Spec Serv	348036300413	15	Bankbridge Regional School	Special Education School	No	Other	PK	12	2020	grade_8	7.0	7
2507175	NJ	Morris	27	school	3405250	1530	Florham Park Boro	340525004234	15	Briarwood School	Regular School	No	Elementary	PK	02	2020	grade_8	0.0	0
2507281	NJ	Morris	27	school	3414130	4490	Rockaway Twp	341413004512	15	Copeland Middle School	Regular School	No	Middle	06	08	2020	grade_8	268.0	268
2507302	NJ	Ocean	29	school	3416470	185	Barnegat Twp	341647005947	15	Cecil S. Collins Elementary	Regular School	No	Elementary	PK	05	2020	grade_8	0.0	0
2507434	NJ	Passaic	31	school	3406450	1920	Haledon Boro	340645005904	15	Haledon Public School	Regular School	No	Elementary	PK	08	2020	grade_8	119.0	119
2400503	NJ	Atlantic	1	school	3405730	1690	Galloway Township Public School District	340573000383	16	Galloway Township Middle School	Regular School	No	Middle	07	08	2021	grade_8	360.0	360
2505549	NJ	Atlantic	1	school	3405730	1690	Galloway Twp	340573000383	16	Galloway Township Middle School	Regular School	No	Middle	07	08	2020	grade_8	363.0	363
2402240	NJ	Morris	27	school	3414130	4490	Rockaway Township School District	341413004514	19	Catherine A Dwyer Elementary School	Regular School	No	Elementary	KG	05	2021	grade_8	0.0	0
2507282	NJ	Morris	27	school	3414130	4490	Rockaway Twp	341413004514	19	Catherine A Dwyer Elementary School	Regular School	No	Elementary	KG	05	2020	grade_8	0.0	0
2400489	NJ	Atlantic	1	school	3404530	1300	Egg Harbor City School District	340453000074	20	Charles L. Spragg School	Regular School	No	Elementary	PK	03	2021	grade_8	0.0	0
2400516	NJ	Atlantic	1	school	3408670	2680	Linwood City School District	340867000144	20	Belhaven Middle School	Regular School	No	Middle	05	08	2021	grade_8	113.0	113
2400521	NJ	Atlantic	1	school	3411070	3480	Mullica Township School District	341107000172	20	Mullica Township Primary School	Regular School	No	Elementary	PK	04	2021	grade_8	0.0	0
2400537	NJ	Atlantic	1	school	3417850	5760	Weymouth Township School District	341785000220	20	Weymouth Township Elementary School	Regular School	No	Elementary	PK	08	2021	grade_8	13.0	13
2400538	NJ	Bergen	3	school	3400750	40	Allendale Public School District	340075000226	20	Hillside Elementary School	Regular School	No	Elementary	PK	03	2021	grade_8	0.0	0
2400551	NJ	Bergen	3	school	3401470	290	Bergen County Vocational Technical School District	340147000250	20	Bergen County Academies	Career and Technical School	No	High	09	12	2021	grade_8	0.0	0
2400552	NJ	Bergen	3	school	3401500	300	Bergenfield Borough School District	340150000268	20	Bergenfield High School	Regular School	No	High	09	12	2021	grade_8	0.0	0
2400559	NJ	Bergen	3	school	3401920	440	Bogota Public School District	340192000284	20	Bogota Jr./Sr. High School	Regular School	No	High	07	12	2021	grade_8	78.0	78
2400620	NJ	Bergen	3	school	3405370	1580	Franklin Lakes School District	340537000460	20	High Mountain Road School	Regular School	No	Elementary	PK	05	2021	grade_8	0.0	0
2400654	NJ	Bergen	3	school	3407260	2180	Hillsdale School District	340726000526	20	George G White	Regular School	No	Middle	05	08	2021	grade_8	127.0	127
2400689	NJ	Bergen	3	school	3410620	3330	Montvale Board Of Education School District	341062000616	20	Fieldstone Middle School	Regular School	No	Middle	05	08	2021	grade_8	110.0	110
2400707	NJ	Bergen	3	school	3411850	3740	Norwood Public School District	341185000660	20	Norwood Public School	Regular School	No	Elementary	PK	08	2021	grade_8	77.0	77
2400815	NJ	Bergen	3	school	3418360	5920	Wyckoff Township Public School District	341836000942	20	Calvin Coolidge Elementary School	Regular School	No	Elementary	KG	05	2021	grade_8	0.0	0
2400827	NJ	Burlington	5	school	3402430	600	Burlington City Public School District	340243000966	20	Burlington City High School	Regular School	No	High	07	12	2021	grade_8	100.0	100
2400868	NJ	Burlington	5	school	3409180	2850	Lumberton Township Board Of Education	340918000222	20	Bobby'S Run Elementary School	Regular School	No	Elementary	03	05	2021	grade_8	0.0	0