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 (ccd_school_lvl > :p4 or (ccd_school_lvl = :p4 and rowid > :p3)) order by ccd_school_lvl, 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
2397971	NJ	Atlantic	1	school	3400960	110	Atlantic City School District	340096000010	10	Atlantic City High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2397975	NJ	Atlantic	1	school	3400990	120	Atlantic County Vocational School District	340099000034	10	Atlantic County Institute Of Technology	Career and Technical School	No	High	09	12	2021	grade_7	0.0	0
2397976	NJ	Atlantic	1	school	3400006	125	Atlantic County Special Services School District	340000600697	60	Atlantic County High School	Special Education School	No	High	09	12	2021	grade_7	0.0	0
2397981	NJ	Atlantic	1	school	3402400	590	Buena Regional School District	340240000044	25	Buena Regional High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2397990	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_7	0.0	0
2398001	NJ	Atlantic	1	school	3406060	1790	Greater Egg Harbor Regional High School District	340606000124	50	Oakcrest High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398002	NJ	Atlantic	1	school	3406060	1790	Greater Egg Harbor Regional High School District	340606003115	60	Cedar Creek High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398003	NJ	Atlantic	1	school	3406060	1790	Greater Egg Harbor Regional High School District	340606000122	40	Absegami High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398009	NJ	Atlantic	1	school	3406570	1960	Hammonton School District	340657000136	50	Hammonton High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398013	NJ	Atlantic	1	school	3409360	2910	Mainland Regional High School	340936000158	50	Mainland Regional High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398025	NJ	Atlantic	1	school	3413200	4180	Pleasantville Public School District	341320000192	50	Pleasantville High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398042	NJ	Bergen	3	school	3401470	290	Bergen County Vocational Technical School District	340147000252	30	Bergen County Technical High School - Paramus	Special Education School	No	High	09	12	2021	grade_7	0.0	0
2398043	NJ	Bergen	3	school	3401470	290	Bergen County Vocational Technical School District	340147000264	75	Bergen County Technical High School - Paramus	Career and Technical School	No	High	09	12	2021	grade_7	0.0	0
2398044	NJ	Bergen	3	school	3401470	290	Bergen County Vocational Technical School District	340147000262	70	Bergen County Technical High School - Teterboro	Career and Technical School	No	High	09	12	2021	grade_7	0.0	0
2398045	NJ	Bergen	3	school	3401470	290	Bergen County Vocational Technical School District	340147003341	300	Applied Technology High School	Career and Technical School	No	High	09	12	2021	grade_7	0.0	0
2398046	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_7	0.0	0
2398047	NJ	Bergen	3	school	3401500	300	Bergenfield Borough School District	340150000268	20	Bergenfield High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398054	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_7	81.0	81
2398058	NJ	Bergen	3	school	3402800	745	Carlstadt-East Rutherford Regional High School District	340280000300	50	Henry P. Becton Regional High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398063	NJ	Bergen	3	school	3403270	890	Cliffside Park School District	340327000304	30	Cliffside Park High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398068	NJ	Bergen	3	school	3403600	990	Cresskill Public School District	340360000324	40	Cresskill High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398077	NJ	Bergen	3	school	3403990	1130	Dumont Public School District	340399000340	40	Dumont High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398085	NJ	Bergen	3	school	3404660	1345	Elmwood Park School District	340466000368	50	Memorial Senior High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398089	NJ	Bergen	3	school	3404710	1360	Emerson Public School District	340471000380	50	Emerson Jr Sr High	Regular School	No	High	07	12	2021	grade_7	73.0	73
2398094	NJ	Bergen	3	school	3404740	1370	Englewood Public School District	340474000388	40	Dwight Morrow High School/Academies@Englewood	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398097	NJ	Bergen	3	school	3404980	1450	Fair Lawn Public School District	340498000410	50	Fair Lawn High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398112	NJ	Bergen	3	school	3405310	1550	Fort Lee School District	340531000442	50	Fort Lee High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398129	NJ	Bergen	3	school	3405760	1700	Garfield Public School District	340576000466	50	Garfield High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398134	NJ	Bergen	3	school	3405970	1760	Glen Rock Public School District	340597000484	50	Glen Rock High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398138	NJ	Bergen	3	school	3406270	1860	Hackensack School District	340627000496	50	Hackensack High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398146	NJ	Bergen	3	school	3406930	2080	Hasbrouck Heights School District	340693000512	50	Hasbrouck Heights High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398154	NJ	Bergen	3	school	3408520	2620	Leonia Public School District	340852000534	50	Leonia High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398163	NJ	Bergen	3	school	3408850	2740	Lodi School District	340885000550	50	Lodi High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398172	NJ	Bergen	3	school	3409210	2860	Lyndhurst School District	340921000568	50	Lyndhurst High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398177	NJ	Bergen	3	school	3409330	2900	Mahwah Township Public School District	340933000586	50	Mahwah High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398182	NJ	Bergen	3	school	3410140	3170	Midland Park School District	341014000608	50	Midland Park Jr./Sr. High School	Regular School	No	High	07	12	2021	grade_7	72.0	72
2398190	NJ	Bergen	3	school	3411280	3550	New Milford Public School District	341128000624	50	New Milford High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398194	NJ	Bergen	3	school	3411430	3600	North Arlington School District	341143000636	50	North Arlington High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398197	NJ	Bergen	3	school	3411730	3700	Northern Highlands Regional High School District	341173000646	50	Northern Highlands Regional High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398198	NJ	Bergen	3	school	3411760	3710	Northern Valley Regional High School District	341176000650	50	Northern Valley Regional High School At Demarest	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398199	NJ	Bergen	3	school	3411760	3710	Northern Valley Regional High School District	341176000652	60	Northern Valley Regional High School At Old Tappan	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398200	NJ	Bergen	3	school	3411760	3710	Northern Valley Regional High School District	341176003359	300	Northern Valley Central	Special Education School	No	High	09	12	2021	grade_7	0.0	0
2398210	NJ	Bergen	3	school	3412360	3910	Palisades Park School District	341236000682	50	Palisades Park Jr-Sr High School	Regular School	No	High	07	12	2021	grade_7	144.0	144
2398217	NJ	Bergen	3	school	3412420	3930	Paramus Public School District	341242000688	50	Paramus High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398222	NJ	Bergen	3	school	3412450	3940	Park Ridge School District	341245000710	50	Park Ridge High School	Regular School	No	High	07	12	2021	grade_7	97.0	97
2398224	NJ	Bergen	3	school	3412510	3960	Pascack Valley Regional High School District	341251000718	40	Pascack Hills High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398225	NJ	Bergen	3	school	3412510	3960	Pascack Valley Regional High School District	341251000720	50	Pascack Valley High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398226	NJ	Bergen	3	school	3413560	4300	Ramapo Indian Hills Regional High School District	341356000724	30	Indian Hills High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398227	NJ	Bergen	3	school	3413560	4300	Ramapo Indian Hills Regional High School District	341356000726	50	Ramapo High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398230	NJ	Bergen	3	school	3413590	4310	Ramsey School District	341359000730	50	Ramsey High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398236	NJ	Bergen	3	school	3413770	4370	Ridgefield School District	341377000742	50	Ridgefield Memorial High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398240	NJ	Bergen	3	school	3413800	4380	Ridgefield Park Public School District	341380000754	50	Ridgefield Park Jr Sr High School	Regular School	No	High	07	12	2021	grade_7	146.0	146
2398244	NJ	Bergen	3	school	3413830	4390	Ridgewood Public School District	341383000764	50	Ridgewood High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398251	NJ	Bergen	3	school	3412260	4405	River Dell Regional School District	341226000786	50	River Dell Regional High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398262	NJ	Bergen	3	school	3414460	4600	Rutherford School District	341446000810	50	Rutherford High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398266	NJ	Bergen	3	school	3414490	4610	Saddle Brook School District	341449000824	50	Saddle Brook Middle/High School	Regular School	No	High	07	12	2021	grade_7	125.0	125
2398272	NJ	Bergen	3	school	3400007	4845	South Bergen Jointure Commission School District	340000700578	50	Lodi Ms Hs	Special Education School	No	High	06	12	2021	grade_7	3.0	3
2398279	NJ	Bergen	3	school	3416080	5150	Teaneck School District	341608000840	50	Teaneck High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398287	NJ	Bergen	3	school	3416110	5160	Tenafly Public School District	341611000864	50	Tenafly High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398292	NJ	Bergen	3	school	3416860	5410	Waldwick School District	341686000888	30	Waldwick High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398296	NJ	Bergen	3	school	3416920	5430	Wallington Boro School District	341692000898	50	Wallington Junior Senior High School	Regular School	No	High	07	12	2021	grade_7	103.0	103
2398298	NJ	Bergen	3	school	3417820	5755	Westwood Regional School District	341782000906	50	Westwood Regional High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398305	NJ	Bergen	3	school	3418300	5830	Wood-Ridge School District	341830000922	50	Wood-Ridge Jr/Sr High School	Regular School	No	High	07	12	2021	grade_7	83.0	83
2398317	NJ	Burlington	5	school	3402030	475	Bordentown Regional School District	340203000960	50	Bordentown Regional High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398322	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_7	91.0	91
2398324	NJ	Burlington	5	school	3402440	605	Burlington County Special Services School District	340244000121	55	Lumberton Campus	Special Education School	No	High	06	12	2021	grade_7	0.0	0
2398326	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_7	0.0	0
2398327	NJ	Burlington	5	school	3402490	610	Burlington County Institute Of Technology School District	340249000998	40	Burlington County Institute Of Technology - Medford	Career and Technical School	No	High	09	12	2021	grade_7	0.0	0
2398328	NJ	Burlington	5	school	3402490	610	Burlington County Institute Of Technology School District	340249000996	30	Burlington County Institute Of Technology - Westampton	Career and Technical School	No	High	09	12	2021	grade_7	0.0	0
2398331	NJ	Burlington	5	school	3402460	620	Burlington Township School District	340246001004	10	Burlington Township High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398334	NJ	Burlington	5	school	3403120	840	Cinnaminson Township School District	340312001020	30	Cinnaminson High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398340	NJ	Burlington	5	school	3403780	1060	Delran Township School District	340378001040	5	Delran High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398357	NJ	Burlington	5	school	3405220	1520	Florence Township School District	340522001082	50	Florence Township Memorial High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398359	NJ	Burlington	5	school	3408490	2610	Lenape Regional High School District	340849000701	70	Seneca High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398360	NJ	Burlington	5	school	3408490	2610	Lenape Regional High School District	340849001096	60	Shawnee High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398361	NJ	Burlington	5	school	3408490	2610	Lenape Regional High School District	340849001094	50	Lenape High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398362	NJ	Burlington	5	school	3408490	2610	Lenape Regional High School District	340849001092	40	Cherokee High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398371	NJ	Burlington	5	school	3409660	3010	Maple Shade School District	340966001104	30	Maple Shade High School	Regular School	No	High	07	12	2021	grade_7	180.0	180
2398383	NJ	Burlington	5	school	3410710	3360	Moorestown Township Public School District	341071001132	40	Moorestown High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398402	NJ	Burlington	5	school	3411700	3690	Northern Burlington County Regional School District	341170001182	50	Northern Burlington County Regional High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398405	NJ	Burlington	5	school	3412390	3920	Palmyra Public School District	341239001188	50	Palmyra High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398410	NJ	Burlington	5	school	3412810	4050	Pemberton Township School District	341281001202	55	Pemberton Township High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398416	NJ	Burlington	5	school	3413620	4320	Rancocas Valley Regional High School District	341362001230	50	Rancocas Valley Regional High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398418	NJ	Burlington	5	school	3414010	4450	Riverside Township School District	341401001234	50	Riverside High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398434	NJ	Burlington	5	school	3418000	5805	Willingboro Public School District	341800003421	300	Willingboro Alternative School	Alternative School	No	High	09	12	2021	grade_7	0.0	0
2398436	NJ	Burlington	5	school	3418000	5805	Willingboro Public School District	341800001264	53	Willingboro High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398443	NJ	Camden	7	school	3401050	150	Audubon Public School District	340105001298	10	Audubon Junior/Senior High School	Regular School	No	High	07	12	2021	grade_7	105.0	105
2398452	NJ	Camden	7	school	3401770	390	Black Horse Pike Regional School District	340177001338	50	Triton Regional High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398453	NJ	Camden	7	school	3401770	390	Black Horse Pike Regional School District	340177000425	30	Timber Creek Regional High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398454	NJ	Camden	7	school	3401770	390	Black Horse Pike Regional School District	340177001336	20	Highland Regional High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398457	NJ	Camden	7	school	3402640	680	Camden City School District	340264001348	40	Woodrow Wilson High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398458	NJ	Camden	7	school	3402640	680	Camden City School District	340264001346	30	Camden High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398462	NJ	Camden	7	school	3402640	680	Camden City School District	340264001384	245	Creative Arts Morgan Village Academy	Regular School	No	High	06	12	2021	grade_7	35.0	35
2398467	NJ	Camden	7	school	3402640	680	Camden City School District	340264000087	29	Dr. Charles E. Brimm Medical Arts High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398472	NJ	Camden	7	school	3402640	680	Camden City School District	340264000579	305	Camden Big Picture Learning Academy	Regular School	No	High	06	12	2021	grade_7	21.0	21
2398474	NJ	Camden	7	school	3402640	680	Camden City School District	340264003441	303	Pride Academy	Alternative School	No	High	06	12	2021	grade_7	1.0	1
2398475	NJ	Camden	7	school	3402670	700	Camden County Technical School District	340267001412	30	Camden County Technical School-Pennsauken	Career and Technical School	No	High	09	12	2021	grade_7	0.0	0
2398476	NJ	Camden	7	school	3402670	700	Camden County Technical School District	340267001414	40	Camden County Technical School-Gtc	Career and Technical School	No	High	09	12	2021	grade_7	0.0	0
2398485	NJ	Camden	7	school	3403000	800	Cherry Hill School District	340300001418	30	Cherry Hill High School East	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398487	NJ	Camden	7	school	3403000	800	Cherry Hill School District	340300000223	60	Alternative High School	Regular School	No	High	09	12	2021	grade_7	0.0	0
2398493	NJ	Camden	7	school	3403000	800	Cherry Hill School District	340300001420	40	Cherry Hill High School West	Regular School	No	High	09	12	2021	grade_7	0.0	0