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 (ccd_school_type > :p3 or (ccd_school_type = :p3 and rowid > :p2)) order by ccd_school_type, 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
2504591	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024002989	90	New Jersey Virtual School	Alternative School	No	High	06	12	2020	grade_7											0.0								0
2504962	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_7											0.0								0
2504972	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003111	6	Alternative High School	Alternative School	No	High	06	12	2020	grade_7											0.0								0
2505084	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_7											0.0								0
2505354	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006008	20	Hillcrest Academy-North	Alternative School	No	High	09	12	2020	grade_7											0.0								0
2505355	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006127	25	Hillcrest Academy-South	Alternative School	No	High	09	12	2020	grade_7											0.0								0
2505364	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003363	300	Raymond J. Lesniak Experience Strength & Hope Recovery Hs	Alternative School	No	High	09	12	2020	grade_7											0.0								0
2505366	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003397	302	Simon Youth Academy	Alternative School	No	High	09	12	2020	grade_7											0.0								0
2505528	NJ	Atlantic	1	school	3400990	120	Atlantic Co Vocational	340099003175	300	Atlantic County Alternative High School	Alternative School	No	High	09	12	2020	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
2505990	NJ	Burlington	5	school	3418000	5805	Willingboro Twp	341800003421	300	Alternative School At Levitt	Alternative School	No	High	06	12	2020	grade_8											0.0								0
2506023	NJ	Camden	7	school	3402640	680	Camden City	340264003441	303	Pride Academy	Alternative School	No	High	06	12	2020	grade_8											3.0								3
2506113	NJ	Camden	7	school	3412870	4060	Pennsauken Twp	341287003465	300	A.E. Burling High School	Alternative School	No	High	06	12	2020	grade_8											10.0								10
2506270	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_8											0.0								0
2506271	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_8											0.0								0
2507092	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024006080	50	Regional Alternative School	Alternative School	No	High	06	12	2020	grade_8											0.0								0
2507093	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024002989	90	New Jersey Virtual School	Alternative School	No	High	06	12	2020	grade_8											0.0								0
2507464	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_8											0.0								0
2507474	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003111	6	Alternative High School	Alternative School	No	High	06	12	2020	grade_8											0.0								0
2507586	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_8											0.0								0
2507856	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006008	20	Hillcrest Academy-North	Alternative School	No	High	09	12	2020	grade_8											0.0								0
2507857	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006127	25	Hillcrest Academy-South	Alternative School	No	High	09	12	2020	grade_8											0.0								0
2507866	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003363	300	Raymond J. Lesniak Experience Strength & Hope Recovery Hs	Alternative School	No	High	09	12	2020	grade_8											0.0								0
2507868	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003397	302	Simon Youth Academy	Alternative School	No	High	09	12	2020	grade_8											0.0								0
2508030	NJ	Atlantic	1	school	3400990	120	Atlantic Co Vocational	340099003175	300	Atlantic County Alternative High School	Alternative School	No	High	09	12	2020	grade_9											11.0								11
2508378	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_9											6.0								6
2508492	NJ	Burlington	5	school	3418000	5805	Willingboro Twp	341800003421	300	Alternative School At Levitt	Alternative School	No	High	06	12	2020	grade_9											1.0								1
2508525	NJ	Camden	7	school	3402640	680	Camden City	340264003441	303	Pride Academy	Alternative School	No	High	06	12	2020	grade_9											2.0								2
2508615	NJ	Camden	7	school	3412870	4060	Pennsauken Twp	341287003465	300	A.E. Burling High School	Alternative School	No	High	06	12	2020	grade_9											3.0								3
2508772	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_9											0.0								0
2508773	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_9											1.0								1
2509594	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024006080	50	Regional Alternative School	Alternative School	No	High	06	12	2020	grade_9											0.0								0
2509595	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024002989	90	New Jersey Virtual School	Alternative School	No	High	06	12	2020	grade_9											0.0								0
2509966	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_9											2.0								2
2509976	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003111	6	Alternative High School	Alternative School	No	High	06	12	2020	grade_9											0.0								0
2510088	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_9											3.0								3
2510358	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006008	20	Hillcrest Academy-North	Alternative School	No	High	09	12	2020	grade_9											20.0								20
2510359	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006127	25	Hillcrest Academy-South	Alternative School	No	High	09	12	2020	grade_9											22.0								22
2510368	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003363	300	Raymond J. Lesniak Experience Strength & Hope Recovery Hs	Alternative School	No	High	09	12	2020	grade_9											0.0								0
2510370	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003397	302	Simon Youth Academy	Alternative School	No	High	09	12	2020	grade_9											0.0								0
2510532	NJ	Atlantic	1	school	3400990	120	Atlantic Co Vocational	340099003175	300	Atlantic County Alternative High School	Alternative School	No	High	09	12	2020	grade_10											8.0								8
2510880	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_10											25.0								25
2510994	NJ	Burlington	5	school	3418000	5805	Willingboro Twp	341800003421	300	Alternative School At Levitt	Alternative School	No	High	06	12	2020	grade_10											5.0								5
2511027	NJ	Camden	7	school	3402640	680	Camden City	340264003441	303	Pride Academy	Alternative School	No	High	06	12	2020	grade_10											1.0								1
2511117	NJ	Camden	7	school	3412870	4060	Pennsauken Twp	341287003465	300	A.E. Burling High School	Alternative School	No	High	06	12	2020	grade_10											6.0								6
2511274	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_10											6.0								6
2511275	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_10											7.0								7
2512096	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024006080	50	Regional Alternative School	Alternative School	No	High	06	12	2020	grade_10											5.0								5
2512097	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024002989	90	New Jersey Virtual School	Alternative School	No	High	06	12	2020	grade_10											1.0								1
2512468	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_10											5.0								5
2512478	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003111	6	Alternative High School	Alternative School	No	High	06	12	2020	grade_10											25.0								25
2512590	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_10											6.0								6
2512860	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006008	20	Hillcrest Academy-North	Alternative School	No	High	09	12	2020	grade_10											34.0								34
2512861	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006127	25	Hillcrest Academy-South	Alternative School	No	High	09	12	2020	grade_10											43.0								43
2512870	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003363	300	Raymond J. Lesniak Experience Strength & Hope Recovery Hs	Alternative School	No	High	09	12	2020	grade_10											2.0								2
2512872	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003397	302	Simon Youth Academy	Alternative School	No	High	09	12	2020	grade_10											12.0								12
2513034	NJ	Atlantic	1	school	3400990	120	Atlantic Co Vocational	340099003175	300	Atlantic County Alternative High School	Alternative School	No	High	09	12	2020	grade_11											18.0								18
2513382	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_11											26.0								26
2513496	NJ	Burlington	5	school	3418000	5805	Willingboro Twp	341800003421	300	Alternative School At Levitt	Alternative School	No	High	06	12	2020	grade_11											11.0								11
2513529	NJ	Camden	7	school	3402640	680	Camden City	340264003441	303	Pride Academy	Alternative School	No	High	06	12	2020	grade_11											4.0								4
2513619	NJ	Camden	7	school	3412870	4060	Pennsauken Twp	341287003465	300	A.E. Burling High School	Alternative School	No	High	06	12	2020	grade_11											13.0								13
2513776	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_11											8.0								8
2513777	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_11											3.0								3
2514598	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024006080	50	Regional Alternative School	Alternative School	No	High	06	12	2020	grade_11											2.0								2
2514599	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024002989	90	New Jersey Virtual School	Alternative School	No	High	06	12	2020	grade_11											0.0								0
2514970	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_11											12.0								12
2514980	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003111	6	Alternative High School	Alternative School	No	High	06	12	2020	grade_11											52.0								52
2515092	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_11											8.0								8
2515362	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006008	20	Hillcrest Academy-North	Alternative School	No	High	09	12	2020	grade_11											29.0								29
2515363	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006127	25	Hillcrest Academy-South	Alternative School	No	High	09	12	2020	grade_11											23.0								23
2515372	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003363	300	Raymond J. Lesniak Experience Strength & Hope Recovery Hs	Alternative School	No	High	09	12	2020	grade_11											9.0								9
2515374	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003397	302	Simon Youth Academy	Alternative School	No	High	09	12	2020	grade_11											11.0								11
2515536	NJ	Atlantic	1	school	3400990	120	Atlantic Co Vocational	340099003175	300	Atlantic County Alternative High School	Alternative School	No	High	09	12	2020	grade_12											9.0								9
2515884	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_12											28.0								28
2515998	NJ	Burlington	5	school	3418000	5805	Willingboro Twp	341800003421	300	Alternative School At Levitt	Alternative School	No	High	06	12	2020	grade_12											7.0								7
2516031	NJ	Camden	7	school	3402640	680	Camden City	340264003441	303	Pride Academy	Alternative School	No	High	06	12	2020	grade_12											2.0								2
2516121	NJ	Camden	7	school	3412870	4060	Pennsauken Twp	341287003465	300	A.E. Burling High School	Alternative School	No	High	06	12	2020	grade_12											8.0								8
2516278	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_12											17.0								17
2516279	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_12											6.0								6
2517100	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024006080	50	Regional Alternative School	Alternative School	No	High	06	12	2020	grade_12											4.0								4
2517101	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024002989	90	New Jersey Virtual School	Alternative School	No	High	06	12	2020	grade_12											0.0								0
2517472	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_12											42.0								42
2517482	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003111	6	Alternative High School	Alternative School	No	High	06	12	2020	grade_12											58.0								58
2517594	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_12											7.0								7
2517864	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006008	20	Hillcrest Academy-North	Alternative School	No	High	09	12	2020	grade_12											8.0								8
2517865	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006127	25	Hillcrest Academy-South	Alternative School	No	High	09	12	2020	grade_12											6.0								6
2517874	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003363	300	Raymond J. Lesniak Experience Strength & Hope Recovery Hs	Alternative School	No	High	09	12	2020	grade_12											1.0								1
2517876	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003397	302	Simon Youth Academy	Alternative School	No	High	09	12	2020	grade_12											7.0								7
2473001	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	pk_12_total	523.0	321.0	673.0	6.0	86.0	10.0	48.0	0	0.6	62.8	1667.0	523	321	673	6	86	10	48	1667
2473069	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	2020	pk_12_total	408.0	32.0	86.0	0.0	553.0	7.0	0.0	0	0.0	5.1	1086.0	408	32	86	0	553	7	0	1086
2473071	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	2020	pk_12_total	284.0	52.5	129.0	1.0	200.0	8.0	0.0	0	0.0	9.6	674.5	284	52	129	1	200	8	0	674
2473072	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	2020	pk_12_total	72.0	14.5	45.5	0.0	1.0	0.0	0.5	.4	0.0	38.6	133.5	72	14	45	0	1	0	0	133
2473073	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	2020	pk_12_total	90.0	15.0	57.0	0.0	18.0	2.0	0.0	.5	0.0	16.5	182.0	90	15	57	0	18	2	0	182
2473353	NJ	Burlington	5	school	3402490	610	Burlington Co Vocational	340249000996	30	Burlington County Institute Of Technology - Westampton	Career and Technical School	No	High	09	12	2020	pk_12_total	273.0	626.0	237.0	3.0	22.0	2.0	94.0	1	0.1	48.5	1257.0	273	626	237	3	22	2	94	1257
2473354	NJ	Burlington	5	school	3402490	610	Burlington Co Vocational	340249000998	40	Burlington County Institute Of Technology - Medford	Career and Technical School	No	High	09	12	2020	pk_12_total	498.0	145.0	147.0	2.0	7.0	0.0	53.0	0	0.4	34.3	852.0	498	145	147	2	7	0	53	852
2473502	NJ	Camden	7	school	3402670	700	Camden County Vocational	340267001412	30	Camden County Technical School-Pennsauken	Career and Technical School	No	High	09	12	2020	pk_12_total	58.0	143.0	505.0	1.0	28.0	0.0	8.0	.4	0.9	83.6	743.0	58	143	505	1	28	0	8	743
2473503	NJ	Camden	7	school	3402670	700	Camden County Vocational	340267001414	40	Camden County Technical School-Gtc	Career and Technical School	No	High	09	12	2020	pk_12_total	527.0	384.0	338.0	2.0	33.0	1.0	62.0	.1	1.4	53.6	1347.0	527	384	338	2	33	1	62	1347
2473620	NJ	Cape May	9	school	3402730	720	Cape May County Vocational School District	340273001712	30	Cape May County Technical High School	Career and Technical School	No	High	09	12	2020	pk_12_total	493.5	26.0	57.0	0.0	12.0	1.0	0.5	0	0.1	23.799999999999997	590.0	493	26	57	0	12	1	0	590
2473657	NJ	Cumberland	11	school	3403610	995	Cumberland Co Vocational	340361001816	30	Cumberland County Technical Education Center	Career and Technical School	No	High	09	12	2020	pk_12_total	491.0	93.0	329.0	2.0	21.0	0.0	11.0	0	0.4	32.300000000000004	947.0	491	93	329	2	21	0	11	947
2473747	NJ	Essex	13	school	3404800	1390	Essex Co Voc-Tech	340480002074	50	Essex County Donald M. Payne Sr. School Of Technology	Career and Technical School	No	High	09	12	2020	pk_12_total	12.0	500.0	747.0	8.0	10.0	8.0	19.0	5.4	0.0	55.8	1304.0	12	500	747	8	10	8	19	1304
2473748	NJ	Essex	13	school	3404800	1390	Essex Co Voc-Tech	340480000137	70	Essex County Newark Tech	Career and Technical School	No	High	09	12	2020	pk_12_total	4.0	339.0	394.0	3.0	7.0	0.0	4.0	12.8	0.0	61.5	751.0	4	339	394	3	7	0	4	751