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 (district_state_id > :p4 or (district_state_id = :p4 and rowid > :p3)) order by district_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
2409154	NJ	Mercer	21	school	3404320	1245	East Windsor Regional School District	340432003062	75	Perry L. Drew Elementary School	Regular School	No	Elementary	03	05	2021	grade_11	0.0	0
2409155	NJ	Mercer	21	school	3404320	1245	East Windsor Regional School District	340432003056	55	Ethel Mcknight Elementary School	Regular School	No	Elementary	KG	02	2021	grade_11	0.0	0
2409156	NJ	Mercer	21	school	3404320	1245	East Windsor Regional School District	340432003058	60	Grace N. Rogers Elementary School	Regular School	No	Elementary	03	05	2021	grade_11	0.0	0
2409157	NJ	Mercer	21	school	3404320	1245	East Windsor Regional School District	340432003064	80	Walter C. Black Elementary School	Regular School	No	Elementary	KG	02	2021	grade_11	0.0	0
2409158	NJ	Mercer	21	school	3404320	1245	East Windsor Regional School District	340432003060	70	Melvin H. Kreps Middle School	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
2409159	NJ	Mercer	21	school	3404320	1245	East Windsor Regional School District	340432003054	50	Hightstown High School	Regular School	No	High	09	12	2021	grade_11	375.0	375
2407996	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_11	5.0	5
2407997	NJ	Atlantic	1	school	3400006	125	Atlantic County Special Services School District	340000600695	30	Atlantic County Elementary And Middle Schools	Special Education School	No	Elementary	PK	08	2021	grade_11	0.0	0
2408364	NJ	Burlington	5	school	3404350	1250	Eastampton Township School District	340435001056	60	Eastampton Township Community School	Regular School	No	Elementary	KG	08	2021	grade_11	0.0	0
2408526	NJ	Camden	7	school	3404380	1255	Eastern Camden County Regional School District	340438001488	50	Eastern Regional High School	Regular School	No	High	09	12	2021	grade_11	469.0	469
2409453	NJ	Monmouth	25	school	3404410	1260	Eatontown Public School District	340441003774	110	Woodmere	Regular School	No	Elementary	03	04	2021	grade_11	0.0	0
2409454	NJ	Monmouth	25	school	3404410	1260	Eatontown Public School District	340441003772	80	Meadowbrook	Regular School	No	Elementary	KG	02	2021	grade_11	0.0	0
2409455	NJ	Monmouth	25	school	3404410	1260	Eatontown Public School District	340441003770	70	Memorial Middle School	Regular School	No	Middle	07	08	2021	grade_11	0.0	0
2409456	NJ	Monmouth	25	school	3404410	1260	Eatontown Public School District	340441003768	60	Margaret L Vetter	Regular School	No	Middle	05	06	2021	grade_11	0.0	0
2408100	NJ	Bergen	3	school	3404440	1270	Edgewater School District	340444003211	300	George Washington School	Regular School	No	Elementary	PK	02	2021	grade_11	0.0	0
2408101	NJ	Bergen	3	school	3404440	1270	Edgewater School District	340444000362	50	Eleanor Van Gelder	Regular School	No	Elementary	03	06	2021	grade_11	0.0	0
2408365	NJ	Burlington	5	school	3404470	1280	Edgewater Park Township School District	340447001062	50	Mildred Magowan Elementary School	Regular School	No	Not reported	M	M	2021	grade_11	0.0	0
2408366	NJ	Burlington	5	school	3404470	1280	Edgewater Park Township School District	340447001064	70	Samuel M Ridgway Middle School	Regular School	No	Not reported	M	M	2021	grade_11	0.0	0
2409269	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003334	63	Woodrow Wilson Middle School	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
2409270	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003346	93	James Monroe Elementary School	Regular School	No	Elementary	KG	05	2021	grade_11	0.0	0
2409271	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003336	65	Benjamin Franklin Elementary School	Regular School	No	Elementary	KG	05	2021	grade_11	0.0	0
2409272	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003332	60	Thomas Jefferson Middle School	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
2409273	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003344	92	James Madison Primary School	Regular School	No	Elementary	KG	02	2021	grade_11	0.0	0
2409274	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003237	302	Franklin D Roosevelt School	Regular School	No	Elementary	PK	KG	2021	grade_11	0.0	0
2409275	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003356	105	Menlo Park Elementary School	Regular School	No	Elementary	KG	05	2021	grade_11	0.0	0
2409276	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003330	57	Herbert Hoover Middle School	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
2409277	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003328	55	John Adams Middle School	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
2409278	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003324	50	Edison High School	Regular School	No	High	09	12	2021	grade_11	494.5	494
2409279	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003326	53	John P. Stevens High School	Regular School	No	High	09	12	2021	grade_11	625.5	625
2409280	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003352	103	Lindeneau Elementary School	Regular School	No	Elementary	KG	05	2021	grade_11	0.0	0
2409281	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003342	90	James Madison Intermediate School	Regular School	No	Elementary	03	05	2021	grade_11	0.0	0
2409282	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003348	95	John Marshall Elementary School	Regular School	No	Elementary	KG	05	2021	grade_11	0.0	0
2409283	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003350	100	Lincoln Elementary School	Regular School	No	Elementary	KG	05	2021	grade_11	0.0	0
2409284	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003179	300	Edison Early Learning Center	Regular School	No	Elementary	PK	KG	2021	grade_11	0.0	0
2409285	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003364	150	Washington Elementary School	Regular School	No	Elementary	KG	05	2021	grade_11	0.0	0
2409286	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003354	104	Martin Luther King Elementary School	Regular School	No	Elementary	KG	05	2021	grade_11	0.0	0
2409287	NJ	Middlesex	23	school	3404500	1290	Edison Township School District	340450003366	160	Woodbrook Elementary School	Regular School	No	Elementary	KG	05	2021	grade_11	0.0	0
2409443	NJ	Monmouth	25	school	3401020	130	Atlantic Highlands School District	340102003746	20	Atlantic Highlands Elementary School	Regular School	No	Elementary	PK	06	2021	grade_11	0.0	0
2408004	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_11	0.0	0
2408005	NJ	Atlantic	1	school	3404530	1300	Egg Harbor City School District	340453000076	30	Egg Harbor City Community School	Regular School	No	Middle	04	08	2021	grade_11	0.0	0
2408006	NJ	Atlantic	1	school	3404560	1310	Egg Harbor Township School District	340456000092	50	H. Russel Swift Elementary School	Regular School	No	Elementary	KG	03	2021	grade_11	0.0	0
2408007	NJ	Atlantic	1	school	3404560	1310	Egg Harbor Township School District	340456002953	38	Alder Avenue Middle School	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
2408008	NJ	Atlantic	1	school	3404560	1310	Egg Harbor Township School District	340456000051	35	E. H. Slaybaugh Elementary School	Regular School	No	Elementary	PK	03	2021	grade_11	0.0	0
2408009	NJ	Atlantic	1	school	3404560	1310	Egg Harbor Township School District	340456000086	33	Clayton J. Davenport Elementary School	Regular School	No	Elementary	KG	03	2021	grade_11	0.0	0
2408010	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_11	564.0	564
2408011	NJ	Atlantic	1	school	3404560	1310	Egg Harbor Township School District	340456000698	45	Dr. Joyanne D. Miller Elementary School	Regular School	No	Elementary	04	05	2021	grade_11	0.0	0
2408012	NJ	Atlantic	1	school	3404560	1310	Egg Harbor Township School District	340456002955	39	Fernwood Avenue Middle School	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
2410209	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005478	25	Elizabeth High School - Frank J Cicarell Academy	Regular School	No	High	09	12	2021	grade_11	316.0	316
2410210	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005494	100	Winfield Scott School No. 2	Regular School	No	Elementary	PK	08	2021	grade_11	0.0	0
2410211	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005526	260	Nicholas Murray Butler Academy School No. 23	Regular School	No	Elementary	KG	08	2021	grade_11	0.0	0
2410212	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459000806	295	Dr. Albert Einstein Academy School No. 29	Regular School	No	Elementary	PK	08	2021	grade_11	0.0	0
2410213	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459002983	315	Juan Pablo Duarte - Jose Julian Marti School No 28	Regular School	No	Elementary	PK	08	2021	grade_11	0.0	0
2410214	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005520	230	John Marshal School No. 20	Regular School	No	Elementary	KG	08	2021	grade_11	0.0	0
2410215	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459000207	280	Sonia Sotomayor School No 25	Regular School	No	Elementary	KG	08	2021	grade_11	0.0	0
2410216	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459003293	302	Jerome Dunn Academy No 9	Regular School	No	Elementary	KG	08	2021	grade_11	0.0	0
2410217	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459000825	305	Chessie Dentley Roberts Academy School No. 30	Regular School	No	Elementary	PK	08	2021	grade_11	0.0	0
2410218	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459003049	403	Thomas Jefferson Arts Academy	Regular School	No	High	09	12	2021	grade_11	264.0	264
2410219	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459000013	30	Terence C. Reilly School No 7	Regular School	No	Middle	02	08	2021	grade_11	0.0	0
2410220	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459003197	301	Iprep Academy School No 8	Regular School	No	Elementary	KG	08	2021	grade_11	0.0	0
2410221	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459006131	355	Donald Stewart Early Childhood Center No 51	Regular School	No	Prekindergarten	PK	PK	2021	grade_11	0.0	0
2410222	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005516	210	Robert Morris School No. 18	Regular School	No	Elementary	PK	08	2021	grade_11	0.0	0
2410223	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459003071	401	John E. Dwyer Technology Academy	Regular School	No	High	09	12	2021	grade_11	299.0	299
2410224	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005492	90	George Washington Academy School No. 1	Regular School	No	Elementary	PK	08	2021	grade_11	0.0	0
2410225	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005962	110	Nicholas S. Lacorte-Peterstown School No. 3	Regular School	No	Elementary	KG	08	2021	grade_11	0.0	0
2410226	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005498	120	Toussaint Louverture-Marquis De Lafayette School No. 6	Regular School	No	Elementary	PK	08	2021	grade_11	0.0	0
2410227	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005506	160	Benjamin Franklin School No. 13	Regular School	No	Elementary	KG	08	2021	grade_11	0.0	0
2410228	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005510	180	Christopher Columbus School No. 15	Regular School	No	Elementary	KG	08	2021	grade_11	0.0	0
2410229	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005522	240	Victor Mravlag School No. 21	Regular School	No	Elementary	PK	08	2021	grade_11	0.0	0
2410230	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459000245	290	Dr. Orlando Edreira Academy School No. 26	Regular School	No	Elementary	PK	08	2021	grade_11	0.0	0
2410231	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459003043	405	Alexander Hamilton Preparatory Academy	Regular School	No	High	09	12	2021	grade_11	259.0	259
2410232	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005508	170	Abraham Lincoln School No. 14	Regular School	No	Elementary	KG	08	2021	grade_11	0.0	0
2410233	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005512	190	Madison Monroe School No. 16	Regular School	No	Elementary	PK	08	2021	grade_11	0.0	0
2410234	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459000071	300	Mabel G. Homes School No. 5	Regular School	No	Elementary	PK	08	2021	grade_11	0.0	0
2410235	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459000467	350	Frances C. Smith Early Childhood Center No 50	Regular School	No	Prekindergarten	PK	PK	2021	grade_11	0.0	0
2410236	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459000567	360	Dr. Martin Luther King Jr. Early Childhood Center No 52	Regular School	No	Prekindergarten	PK	PK	2021	grade_11	0.0	0
2410237	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459003039	402	Admiral William F. Halsey Jr. Health & Public Safety Academy	Regular School	No	High	09	12	2021	grade_11	366.0	366
2410238	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005482	35	Joseph Battin School No 4	Regular School	No	Elementary	KG	08	2021	grade_11	0.0	0
2410239	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005504	150	Elmora School No. 12	Regular School	No	Elementary	PK	08	2021	grade_11	0.0	0
2410240	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005518	220	Woodrow Wilson School No. 19	Regular School	No	Elementary	PK	08	2021	grade_11	0.0	0
2410241	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459005524	250	William F. Halloran School No.22	Regular School	No	Middle	02	08	2021	grade_11	0.0	0
2410242	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459003389	303	J. Christian Bollwage Finance Academy	Regular School	No	High	09	12	2021	grade_11	79.0	79
2410243	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459002997	310	Dr. Antonia Pantoja School No. 27	Regular School	No	Elementary	PK	08	2021	grade_11	0.0	0
2410244	NJ	Union	39	school	3404590	1320	Elizabeth Public Schools	340459003045	404	Thomas A. Edison Career And Technical Academy	Regular School	No	High	09	12	2021	grade_11	186.0	186
2408922	NJ	Gloucester	15	school	3404620	1330	Elk Township School District	340462002538	10	Aura Elementary School	Regular School	No	Elementary	PK	06	2021	grade_11	0.0	0
2408102	NJ	Bergen	3	school	3404660	1345	Elmwood Park School District	340466000374	80	Gilbert Avenue School	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
2408103	NJ	Bergen	3	school	3404660	1345	Elmwood Park School District	340466000376	90	Sixteenth Avenue School	Regular School	No	Elementary	PK	05	2021	grade_11	0.0	0
2408104	NJ	Bergen	3	school	3404660	1345	Elmwood Park School District	340466000075	60	Memorial Middle School	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
2408105	NJ	Bergen	3	school	3404660	1345	Elmwood Park School District	340466000368	50	Memorial Senior High School	Regular School	No	High	09	12	2021	grade_11	179.0	179
2408106	NJ	Bergen	3	school	3404660	1345	Elmwood Park School District	340466000372	70	Gantner Avenue School	Regular School	No	Elementary	KG	05	2021	grade_11	0.0	0
2410033	NJ	Salem	33	school	3404680	1350	Elsinboro Township School District	340468005032	50	Elsinboro Township School	Regular School	No	Elementary	KG	08	2021	grade_11	0.0	0
2408107	NJ	Bergen	3	school	3404710	1360	Emerson Public School District	340471000382	60	Patrick M Villano School	Regular School	No	Middle	04	06	2021	grade_11	0.0	0
2408108	NJ	Bergen	3	school	3404710	1360	Emerson Public School District	340471000384	70	Memorial School	Regular School	No	Elementary	PK	03	2021	grade_11	0.0	0
2408109	NJ	Bergen	3	school	3404710	1360	Emerson Public School District	340471000380	50	Emerson Jr Sr High	Regular School	No	High	07	12	2021	grade_11	78.0	78
2408110	NJ	Bergen	3	school	3404740	1370	Englewood Public School District	340474000390	60	Dr. Leroy Mccloud Elementary School	Regular School	No	Elementary	03	05	2021	grade_11	0.0	0
2408111	NJ	Bergen	3	school	3404740	1370	Englewood Public School District	340474003063	86	Dr. John Grieco Elementary School	Regular School	No	Elementary	01	02	2021	grade_11	0.0	0
2408112	NJ	Bergen	3	school	3404740	1370	Englewood Public School District	340474000394	76	Janis E. Dismus Middle School	Regular School	No	Middle	06	08	2021	grade_11	0.0	0
2408113	NJ	Bergen	3	school	3404740	1370	Englewood Public School District	340474000392	70	Donald A. Quarles Early Childhood Center	Regular School	No	Elementary	PK	KG	2021	grade_11	0.0	0
2408114	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_11	227.0	227
2409120	NJ	Hunterdon	19	school	3400769	1376	South Hunterdon Regional School District	340076903048	30	West Amwell Township School	Regular School	No	Elementary	KG	06	2021	grade_11	0.0	0
2409121	NJ	Hunterdon	19	school	3400769	1376	South Hunterdon Regional School District	340076903010	20	Lambertville Public School	Regular School	No	Elementary	PK	06	2021	grade_11	0.0	0
2409122	NJ	Hunterdon	19	school	3400769	1376	South Hunterdon Regional School District	340076903036	50	South Hunterdon Regional High School	Regular School	No	High	07	12	2021	grade_11	65.0	65