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 (ccd_school_type > :p2 or (ccd_school_type = :p2 and rowid > :p1)) 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	total	total_int
2488599	NJ	Camden	7	school	3412870	4060	Pennsauken Twp	341287003465	300	A.E. Burling High School	Alternative School	No	High	06	12	2020	grade_1	0.0	0
2488756	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_1	0.0	0
2488757	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_1	0.0	0
2489578	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024006080	50	Regional Alternative School	Alternative School	No	High	06	12	2020	grade_1	0.0	0
2489579	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_1	0.0	0
2489950	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_1	0.0	0
2489960	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003111	6	Alternative High School	Alternative School	No	High	06	12	2020	grade_1	0.0	0
2490072	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_1	0.0	0
2490342	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006008	20	Hillcrest Academy-North	Alternative School	No	High	09	12	2020	grade_1	0.0	0
2490343	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006127	25	Hillcrest Academy-South	Alternative School	No	High	09	12	2020	grade_1	0.0	0
2490352	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_1	0.0	0
2490354	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003397	302	Simon Youth Academy	Alternative School	No	High	09	12	2020	grade_1	0.0	0
2490516	NJ	Atlantic	1	school	3400990	120	Atlantic Co Vocational	340099003175	300	Atlantic County Alternative High School	Alternative School	No	High	09	12	2020	grade_2	0.0	0
2490864	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_2	0.0	0
2490978	NJ	Burlington	5	school	3418000	5805	Willingboro Twp	341800003421	300	Alternative School At Levitt	Alternative School	No	High	06	12	2020	grade_2	0.0	0
2491011	NJ	Camden	7	school	3402640	680	Camden City	340264003441	303	Pride Academy	Alternative School	No	High	06	12	2020	grade_2	0.0	0
2491101	NJ	Camden	7	school	3412870	4060	Pennsauken Twp	341287003465	300	A.E. Burling High School	Alternative School	No	High	06	12	2020	grade_2	0.0	0
2491258	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_2	0.0	0
2491259	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_2	0.0	0
2492080	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024006080	50	Regional Alternative School	Alternative School	No	High	06	12	2020	grade_2	0.0	0
2492081	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_2	0.0	0
2492452	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_2	0.0	0
2492462	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003111	6	Alternative High School	Alternative School	No	High	06	12	2020	grade_2	0.0	0
2492574	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_2	0.0	0
2492844	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006008	20	Hillcrest Academy-North	Alternative School	No	High	09	12	2020	grade_2	0.0	0
2492845	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006127	25	Hillcrest Academy-South	Alternative School	No	High	09	12	2020	grade_2	0.0	0
2492854	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_2	0.0	0
2492856	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003397	302	Simon Youth Academy	Alternative School	No	High	09	12	2020	grade_2	0.0	0
2493018	NJ	Atlantic	1	school	3400990	120	Atlantic Co Vocational	340099003175	300	Atlantic County Alternative High School	Alternative School	No	High	09	12	2020	grade_3	0.0	0
2493366	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_3	0.0	0
2493480	NJ	Burlington	5	school	3418000	5805	Willingboro Twp	341800003421	300	Alternative School At Levitt	Alternative School	No	High	06	12	2020	grade_3	0.0	0
2493513	NJ	Camden	7	school	3402640	680	Camden City	340264003441	303	Pride Academy	Alternative School	No	High	06	12	2020	grade_3	0.0	0
2493603	NJ	Camden	7	school	3412870	4060	Pennsauken Twp	341287003465	300	A.E. Burling High School	Alternative School	No	High	06	12	2020	grade_3	0.0	0
2493760	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_3	0.0	0
2493761	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_3	0.0	0
2494582	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024006080	50	Regional Alternative School	Alternative School	No	High	06	12	2020	grade_3	0.0	0
2494583	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_3	0.0	0
2494954	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_3	0.0	0
2494964	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003111	6	Alternative High School	Alternative School	No	High	06	12	2020	grade_3	0.0	0
2495076	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_3	0.0	0
2495346	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006008	20	Hillcrest Academy-North	Alternative School	No	High	09	12	2020	grade_3	0.0	0
2495347	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006127	25	Hillcrest Academy-South	Alternative School	No	High	09	12	2020	grade_3	0.0	0
2495356	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_3	0.0	0
2495358	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003397	302	Simon Youth Academy	Alternative School	No	High	09	12	2020	grade_3	0.0	0
2495520	NJ	Atlantic	1	school	3400990	120	Atlantic Co Vocational	340099003175	300	Atlantic County Alternative High School	Alternative School	No	High	09	12	2020	grade_4	0.0	0
2495868	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_4	0.0	0
2495982	NJ	Burlington	5	school	3418000	5805	Willingboro Twp	341800003421	300	Alternative School At Levitt	Alternative School	No	High	06	12	2020	grade_4	0.0	0
2496015	NJ	Camden	7	school	3402640	680	Camden City	340264003441	303	Pride Academy	Alternative School	No	High	06	12	2020	grade_4	0.0	0
2496105	NJ	Camden	7	school	3412870	4060	Pennsauken Twp	341287003465	300	A.E. Burling High School	Alternative School	No	High	06	12	2020	grade_4	0.0	0
2496262	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_4	0.0	0
2496263	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_4	0.0	0
2497084	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024006080	50	Regional Alternative School	Alternative School	No	High	06	12	2020	grade_4	0.0	0
2497085	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_4	0.0	0
2497456	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_4	0.0	0
2497466	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003111	6	Alternative High School	Alternative School	No	High	06	12	2020	grade_4	0.0	0
2497578	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_4	0.0	0
2497848	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006008	20	Hillcrest Academy-North	Alternative School	No	High	09	12	2020	grade_4	0.0	0
2497849	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006127	25	Hillcrest Academy-South	Alternative School	No	High	09	12	2020	grade_4	0.0	0
2497858	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_4	0.0	0
2497860	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003397	302	Simon Youth Academy	Alternative School	No	High	09	12	2020	grade_4	0.0	0
2498022	NJ	Atlantic	1	school	3400990	120	Atlantic Co Vocational	340099003175	300	Atlantic County Alternative High School	Alternative School	No	High	09	12	2020	grade_5	0.0	0
2498370	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_5	0.0	0
2498484	NJ	Burlington	5	school	3418000	5805	Willingboro Twp	341800003421	300	Alternative School At Levitt	Alternative School	No	High	06	12	2020	grade_5	0.0	0
2498517	NJ	Camden	7	school	3402640	680	Camden City	340264003441	303	Pride Academy	Alternative School	No	High	06	12	2020	grade_5	0.0	0
2498607	NJ	Camden	7	school	3412870	4060	Pennsauken Twp	341287003465	300	A.E. Burling High School	Alternative School	No	High	06	12	2020	grade_5	0.0	0
2498764	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_5	0.0	0
2498765	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_5	0.0	0
2499586	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024006080	50	Regional Alternative School	Alternative School	No	High	06	12	2020	grade_5	0.0	0
2499587	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_5	0.0	0
2499958	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_5	0.0	0
2499968	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003111	6	Alternative High School	Alternative School	No	High	06	12	2020	grade_5	0.0	0
2500080	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_5	0.0	0
2500350	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006008	20	Hillcrest Academy-North	Alternative School	No	High	09	12	2020	grade_5	0.0	0
2500351	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006127	25	Hillcrest Academy-South	Alternative School	No	High	09	12	2020	grade_5	0.0	0
2500360	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_5	0.0	0
2500362	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003397	302	Simon Youth Academy	Alternative School	No	High	09	12	2020	grade_5	0.0	0
2500524	NJ	Atlantic	1	school	3400990	120	Atlantic Co Vocational	340099003175	300	Atlantic County Alternative High School	Alternative School	No	High	09	12	2020	grade_6	0.0	0
2500872	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_6	0.0	0
2500986	NJ	Burlington	5	school	3418000	5805	Willingboro Twp	341800003421	300	Alternative School At Levitt	Alternative School	No	High	06	12	2020	grade_6	0.0	0
2501019	NJ	Camden	7	school	3402640	680	Camden City	340264003441	303	Pride Academy	Alternative School	No	High	06	12	2020	grade_6	0.0	0
2501109	NJ	Camden	7	school	3412870	4060	Pennsauken Twp	341287003465	300	A.E. Burling High School	Alternative School	No	High	06	12	2020	grade_6	0.0	0
2501266	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_6	0.0	0
2501267	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_6	0.0	0
2502088	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024006080	50	Regional Alternative School	Alternative School	No	High	06	12	2020	grade_6	0.0	0
2502089	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_6	0.0	0
2502460	NJ	Passaic	31	school	3480364	3975	Northern Region Educational Services Commission	348036402991	100	Hope Academy	Alternative School	No	High	09	12	2020	grade_6	0.0	0
2502470	NJ	Passaic	31	school	3412690	4010	Paterson City	341269003111	6	Alternative High School	Alternative School	No	High	06	12	2020	grade_6	0.0	0
2502582	NJ	Salem	33	school	3480361	4635	Salem Co Special Service	348036103163	301	Alternative Middle & High School	Alternative School	No	High	06	12	2020	grade_6	0.0	0
2502852	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006008	20	Hillcrest Academy-North	Alternative School	No	High	09	12	2020	grade_6	0.0	0
2502853	NJ	Union	39	school	3416400	5245	Union Co Ed Serv Comm	341640006127	25	Hillcrest Academy-South	Alternative School	No	High	09	12	2020	grade_6	0.0	0
2502862	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_6	0.0	0
2502864	NJ	Union	39	school	3418040	5260	Union County Vocational	341804003397	302	Simon Youth Academy	Alternative School	No	High	09	12	2020	grade_6	0.0	0
2503026	NJ	Atlantic	1	school	3400990	120	Atlantic Co Vocational	340099003175	300	Atlantic County Alternative High School	Alternative School	No	High	09	12	2020	grade_7	0.0	0
2503374	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_7	1.0	1
2503488	NJ	Burlington	5	school	3418000	5805	Willingboro Twp	341800003421	300	Alternative School At Levitt	Alternative School	No	High	06	12	2020	grade_7	2.0	2
2503521	NJ	Camden	7	school	3402640	680	Camden City	340264003441	303	Pride Academy	Alternative School	No	High	06	12	2020	grade_7	5.0	5
2503611	NJ	Camden	7	school	3412870	4060	Pennsauken Twp	341287003465	300	A.E. Burling High School	Alternative School	No	High	06	12	2020	grade_7	2.0	2
2503768	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000543	20	Essex Campus Academy	Alternative School	No	High	09	12	2020	grade_7	0.0	0
2503769	NJ	Essex	13	school	3480300	1387	Essex Co Ed Serv Comm	348030000135	30	Essex High School	Alternative School	No	High	09	12	2020	grade_7	0.0	0
2504590	NJ	Monmouth	25	school	3480240	3255	Monmouth-Ocean Ed Ser Com	348024006080	50	Regional Alternative School	Alternative School	No	High	06	12	2020	grade_7	0.0	0
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