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 order by total_int limit 101

Query parameters

This data as json, CSV

rowid	state	county	admin_level	district_nces_id	district_state_id	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	grade	native_american_alaskan_native	native_american_alaskan_native_int
745200	NY	Albany	school	3602460	10100010000	ALBANY	360246000222	10100010014	MONTESSORI MAGNET SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_10	0.0	0
745201	NY	Albany	school	3602460	10100010000	ALBANY	360246000222	10100010014	MONTESSORI MAGNET SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_11	0.0	0
745202	NY	Albany	school	3602460	10100010000	ALBANY	360246000222	10100010014	MONTESSORI MAGNET SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_12	0.0	0
745207	NY	Albany	school	3602460	10100010000	ALBANY	360246000222	10100010014	MONTESSORI MAGNET SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_6	0.0	0
745208	NY	Albany	school	3602460	10100010000	ALBANY	360246000222	10100010014	MONTESSORI MAGNET SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_7	0.0	0
745209	NY	Albany	school	3602460	10100010000	ALBANY	360246000222	10100010014	MONTESSORI MAGNET SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_8	0.0	0
745210	NY	Albany	school	3602460	10100010000	ALBANY	360246000222	10100010014	MONTESSORI MAGNET SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_9	0.0	0
745212	NY	Albany	school	3602460	10100010000	ALBANY	360246000222	10100010014	MONTESSORI MAGNET SCHOOL	public	Regular School	No	1.0	PK	05	2015	kindergarten_half_day	0.0	0
745215	NY	Albany	school	3602460	10100010000	ALBANY	360246000222	10100010014	MONTESSORI MAGNET SCHOOL	public	Regular School	No	1.0	PK	05	2015	pre_kindergarten_half_day	0.0	0
745217	NY	Albany	school	3602460	10100010000	ALBANY	360246000222	10100010014	MONTESSORI MAGNET SCHOOL	public	Regular School	No	1.0	PK	05	2015	ungraded_secondary	0.0	0
745219	NY	Albany	school	3602460	10100010000	ALBANY	360246000020	10100010016	PINE HILLS ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	07	2015	grade_10
745220	NY	Albany	school	3602460	10100010000	ALBANY	360246000020	10100010016	PINE HILLS ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	07	2015	grade_11
745221	NY	Albany	school	3602460	10100010000	ALBANY	360246000020	10100010016	PINE HILLS ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	07	2015	grade_12
745228	NY	Albany	school	3602460	10100010000	ALBANY	360246000020	10100010016	PINE HILLS ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	07	2015	grade_8
745229	NY	Albany	school	3602460	10100010000	ALBANY	360246000020	10100010016	PINE HILLS ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	07	2015	grade_9
745231	NY	Albany	school	3602460	10100010000	ALBANY	360246000020	10100010016	PINE HILLS ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	07	2015	kindergarten_half_day
745233	NY	Albany	school	3602460	10100010000	ALBANY	360246000020	10100010016	PINE HILLS ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	07	2015	pre_kindergarten_full_day
745234	NY	Albany	school	3602460	10100010000	ALBANY	360246000020	10100010016	PINE HILLS ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	07	2015	pre_kindergarten_half_day
745235	NY	Albany	school	3602460	10100010000	ALBANY	360246000020	10100010016	PINE HILLS ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	07	2015	ungraded_elementary
745236	NY	Albany	school	3602460	10100010000	ALBANY	360246000020	10100010016	PINE HILLS ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	07	2015	ungraded_secondary
745238	NY	Albany	school	3602460	10100010000	ALBANY	360246000022	10100010018	DELAWARE COMMUNITY SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_10	0.0	0
745239	NY	Albany	school	3602460	10100010000	ALBANY	360246000022	10100010018	DELAWARE COMMUNITY SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_11	0.0	0
745240	NY	Albany	school	3602460	10100010000	ALBANY	360246000022	10100010018	DELAWARE COMMUNITY SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_12	0.0	0
745245	NY	Albany	school	3602460	10100010000	ALBANY	360246000022	10100010018	DELAWARE COMMUNITY SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_6	0.0	0
745246	NY	Albany	school	3602460	10100010000	ALBANY	360246000022	10100010018	DELAWARE COMMUNITY SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_7	0.0	0
745247	NY	Albany	school	3602460	10100010000	ALBANY	360246000022	10100010018	DELAWARE COMMUNITY SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_8	0.0	0
745248	NY	Albany	school	3602460	10100010000	ALBANY	360246000022	10100010018	DELAWARE COMMUNITY SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_9	0.0	0
745250	NY	Albany	school	3602460	10100010000	ALBANY	360246000022	10100010018	DELAWARE COMMUNITY SCHOOL	public	Regular School	No	1.0	PK	05	2015	kindergarten_half_day	0.0	0
745253	NY	Albany	school	3602460	10100010000	ALBANY	360246000022	10100010018	DELAWARE COMMUNITY SCHOOL	public	Regular School	No	1.0	PK	05	2015	pre_kindergarten_half_day	0.0	0
745254	NY	Albany	school	3602460	10100010000	ALBANY	360246000022	10100010018	DELAWARE COMMUNITY SCHOOL	public	Regular School	No	1.0	PK	05	2015	ungraded_elementary	0.0	0
745255	NY	Albany	school	3602460	10100010000	ALBANY	360246000022	10100010018	DELAWARE COMMUNITY SCHOOL	public	Regular School	No	1.0	PK	05	2015	ungraded_secondary	0.0	0
745257	NY	Albany	school	3602460	10100010000	ALBANY	360246000023	10100010019	NEW SCOTLAND ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_10	0.0	0
745258	NY	Albany	school	3602460	10100010000	ALBANY	360246000023	10100010019	NEW SCOTLAND ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_11	0.0	0
745259	NY	Albany	school	3602460	10100010000	ALBANY	360246000023	10100010019	NEW SCOTLAND ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_12	0.0	0
745264	NY	Albany	school	3602460	10100010000	ALBANY	360246000023	10100010019	NEW SCOTLAND ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_6	0.0	0
745265	NY	Albany	school	3602460	10100010000	ALBANY	360246000023	10100010019	NEW SCOTLAND ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_7	0.0	0
745266	NY	Albany	school	3602460	10100010000	ALBANY	360246000023	10100010019	NEW SCOTLAND ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_8	0.0	0
745267	NY	Albany	school	3602460	10100010000	ALBANY	360246000023	10100010019	NEW SCOTLAND ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	05	2015	grade_9	0.0	0
745269	NY	Albany	school	3602460	10100010000	ALBANY	360246000023	10100010019	NEW SCOTLAND ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	05	2015	kindergarten_half_day	0.0	0
745272	NY	Albany	school	3602460	10100010000	ALBANY	360246000023	10100010019	NEW SCOTLAND ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	05	2015	pre_kindergarten_half_day	0.0	0
745274	NY	Albany	school	3602460	10100010000	ALBANY	360246000023	10100010019	NEW SCOTLAND ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	05	2015	ungraded_secondary	0.0	0
745276	NY	Albany	school	3602460	10100010000	ALBANY	360246000024	10100010020	NORTH ALBANY ACADEMY	public	Regular School	No	1.0	PK	08	2015	grade_10	0.0	0
745277	NY	Albany	school	3602460	10100010000	ALBANY	360246000024	10100010020	NORTH ALBANY ACADEMY	public	Regular School	No	1.0	PK	08	2015	grade_11	0.0	0
745278	NY	Albany	school	3602460	10100010000	ALBANY	360246000024	10100010020	NORTH ALBANY ACADEMY	public	Regular School	No	1.0	PK	08	2015	grade_12	0.0	0
745286	NY	Albany	school	3602460	10100010000	ALBANY	360246000024	10100010020	NORTH ALBANY ACADEMY	public	Regular School	No	1.0	PK	08	2015	grade_9	0.0	0
745288	NY	Albany	school	3602460	10100010000	ALBANY	360246000024	10100010020	NORTH ALBANY ACADEMY	public	Regular School	No	1.0	PK	08	2015	kindergarten_half_day	0.0	0
745290	NY	Albany	school	3602460	10100010000	ALBANY	360246000024	10100010020	NORTH ALBANY ACADEMY	public	Regular School	No	1.0	PK	08	2015	pre_kindergarten_full_day	0.0	0
745291	NY	Albany	school	3602460	10100010000	ALBANY	360246000024	10100010020	NORTH ALBANY ACADEMY	public	Regular School	No	1.0	PK	08	2015	pre_kindergarten_half_day	0.0	0
745295	NY	Albany	school	3602460	10100010000	ALBANY	360246000026	10100010023	ALBANY SCHOOL OF HUMANITIES	public	Regular School	No	1.0	PK	06	2015	grade_10	0.0	0
745296	NY	Albany	school	3602460	10100010000	ALBANY	360246000026	10100010023	ALBANY SCHOOL OF HUMANITIES	public	Regular School	No	1.0	PK	06	2015	grade_11	0.0	0
745297	NY	Albany	school	3602460	10100010000	ALBANY	360246000026	10100010023	ALBANY SCHOOL OF HUMANITIES	public	Regular School	No	1.0	PK	06	2015	grade_12	0.0	0
745303	NY	Albany	school	3602460	10100010000	ALBANY	360246000026	10100010023	ALBANY SCHOOL OF HUMANITIES	public	Regular School	No	1.0	PK	06	2015	grade_7	0.0	0
745304	NY	Albany	school	3602460	10100010000	ALBANY	360246000026	10100010023	ALBANY SCHOOL OF HUMANITIES	public	Regular School	No	1.0	PK	06	2015	grade_8	0.0	0
745305	NY	Albany	school	3602460	10100010000	ALBANY	360246000026	10100010023	ALBANY SCHOOL OF HUMANITIES	public	Regular School	No	1.0	PK	06	2015	grade_9	0.0	0
745307	NY	Albany	school	3602460	10100010000	ALBANY	360246000026	10100010023	ALBANY SCHOOL OF HUMANITIES	public	Regular School	No	1.0	PK	06	2015	kindergarten_half_day	0.0	0
745310	NY	Albany	school	3602460	10100010000	ALBANY	360246000026	10100010023	ALBANY SCHOOL OF HUMANITIES	public	Regular School	No	1.0	PK	06	2015	pre_kindergarten_half_day	0.0	0
745312	NY	Albany	school	3602460	10100010000	ALBANY	360246000026	10100010023	ALBANY SCHOOL OF HUMANITIES	public	Regular School	No	1.0	PK	06	2015	ungraded_secondary	0.0	0
745314	NY	Albany	school	3602460	10100010000	ALBANY	360246000028	10100010027	EAGLE POINT ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	grade_10	0.0	0
745315	NY	Albany	school	3602460	10100010000	ALBANY	360246000028	10100010027	EAGLE POINT ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	grade_11	0.0	0
745316	NY	Albany	school	3602460	10100010000	ALBANY	360246000028	10100010027	EAGLE POINT ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	grade_12	0.0	0
745322	NY	Albany	school	3602460	10100010000	ALBANY	360246000028	10100010027	EAGLE POINT ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	grade_7	0.0	0
745323	NY	Albany	school	3602460	10100010000	ALBANY	360246000028	10100010027	EAGLE POINT ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	grade_8	0.0	0
745324	NY	Albany	school	3602460	10100010000	ALBANY	360246000028	10100010027	EAGLE POINT ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	grade_9	0.0	0
745326	NY	Albany	school	3602460	10100010000	ALBANY	360246000028	10100010027	EAGLE POINT ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	kindergarten_half_day	0.0	0
745328	NY	Albany	school	3602460	10100010000	ALBANY	360246000028	10100010027	EAGLE POINT ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	pre_kindergarten_full_day	0.0	0
745329	NY	Albany	school	3602460	10100010000	ALBANY	360246000028	10100010027	EAGLE POINT ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	pre_kindergarten_half_day	0.0	0
745330	NY	Albany	school	3602460	10100010000	ALBANY	360246000028	10100010027	EAGLE POINT ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	ungraded_elementary	0.0	0
745331	NY	Albany	school	3602460	10100010000	ALBANY	360246000028	10100010027	EAGLE POINT ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	ungraded_secondary	0.0	0
745333	NY	Albany	school	3602460	10100010000	ALBANY	360246000031	10100010028	THOMAS S O'BRIEN ACAD OF SCI & TECH	public	Regular School	No	1.0	PK	06	2015	grade_10	0.0	0
745334	NY	Albany	school	3602460	10100010000	ALBANY	360246000031	10100010028	THOMAS S O'BRIEN ACAD OF SCI & TECH	public	Regular School	No	1.0	PK	06	2015	grade_11	0.0	0
745335	NY	Albany	school	3602460	10100010000	ALBANY	360246000031	10100010028	THOMAS S O'BRIEN ACAD OF SCI & TECH	public	Regular School	No	1.0	PK	06	2015	grade_12	0.0	0
745341	NY	Albany	school	3602460	10100010000	ALBANY	360246000031	10100010028	THOMAS S O'BRIEN ACAD OF SCI & TECH	public	Regular School	No	1.0	PK	06	2015	grade_7	0.0	0
745342	NY	Albany	school	3602460	10100010000	ALBANY	360246000031	10100010028	THOMAS S O'BRIEN ACAD OF SCI & TECH	public	Regular School	No	1.0	PK	06	2015	grade_8	0.0	0
745343	NY	Albany	school	3602460	10100010000	ALBANY	360246000031	10100010028	THOMAS S O'BRIEN ACAD OF SCI & TECH	public	Regular School	No	1.0	PK	06	2015	grade_9	0.0	0
745345	NY	Albany	school	3602460	10100010000	ALBANY	360246000031	10100010028	THOMAS S O'BRIEN ACAD OF SCI & TECH	public	Regular School	No	1.0	PK	06	2015	kindergarten_half_day	0.0	0
745348	NY	Albany	school	3602460	10100010000	ALBANY	360246000031	10100010028	THOMAS S O'BRIEN ACAD OF SCI & TECH	public	Regular School	No	1.0	PK	06	2015	pre_kindergarten_half_day	0.0	0
745350	NY	Albany	school	3602460	10100010000	ALBANY	360246000031	10100010028	THOMAS S O'BRIEN ACAD OF SCI & TECH	public	Regular School	No	1.0	PK	06	2015	ungraded_secondary	0.0	0
745352	NY	Albany	school	3602460	10100010000	ALBANY	360246000016	10100010029	GIFFEN MEMORIAL ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	grade_10	0.0	0
745353	NY	Albany	school	3602460	10100010000	ALBANY	360246000016	10100010029	GIFFEN MEMORIAL ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	grade_11	0.0	0
745354	NY	Albany	school	3602460	10100010000	ALBANY	360246000016	10100010029	GIFFEN MEMORIAL ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	grade_12	0.0	0
745360	NY	Albany	school	3602460	10100010000	ALBANY	360246000016	10100010029	GIFFEN MEMORIAL ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	grade_7	0.0	0
745361	NY	Albany	school	3602460	10100010000	ALBANY	360246000016	10100010029	GIFFEN MEMORIAL ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	grade_8	0.0	0
745362	NY	Albany	school	3602460	10100010000	ALBANY	360246000016	10100010029	GIFFEN MEMORIAL ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	grade_9	0.0	0
745364	NY	Albany	school	3602460	10100010000	ALBANY	360246000016	10100010029	GIFFEN MEMORIAL ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	kindergarten_half_day	0.0	0
745367	NY	Albany	school	3602460	10100010000	ALBANY	360246000016	10100010029	GIFFEN MEMORIAL ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	pre_kindergarten_half_day	0.0	0
745368	NY	Albany	school	3602460	10100010000	ALBANY	360246000016	10100010029	GIFFEN MEMORIAL ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	ungraded_elementary	0.0	0
745369	NY	Albany	school	3602460	10100010000	ALBANY	360246000016	10100010029	GIFFEN MEMORIAL ELEMENTARY SCHOOL	public	Regular School	No	1.0	PK	06	2015	ungraded_secondary	0.0	0
745370	NY	Albany	school	3602460	10100010000	ALBANY	360246000032	10100010030	WILLIAM S HACKETT MIDDLE SCHOOL	public	Regular School	No	2.0	06	08	2015	grade_1	0.0	0
745371	NY	Albany	school	3602460	10100010000	ALBANY	360246000032	10100010030	WILLIAM S HACKETT MIDDLE SCHOOL	public	Regular School	No	2.0	06	08	2015	grade_10	0.0	0
745372	NY	Albany	school	3602460	10100010000	ALBANY	360246000032	10100010030	WILLIAM S HACKETT MIDDLE SCHOOL	public	Regular School	No	2.0	06	08	2015	grade_11	0.0	0
745373	NY	Albany	school	3602460	10100010000	ALBANY	360246000032	10100010030	WILLIAM S HACKETT MIDDLE SCHOOL	public	Regular School	No	2.0	06	08	2015	grade_12	0.0	0
745374	NY	Albany	school	3602460	10100010000	ALBANY	360246000032	10100010030	WILLIAM S HACKETT MIDDLE SCHOOL	public	Regular School	No	2.0	06	08	2015	grade_2	0.0	0
745375	NY	Albany	school	3602460	10100010000	ALBANY	360246000032	10100010030	WILLIAM S HACKETT MIDDLE SCHOOL	public	Regular School	No	2.0	06	08	2015	grade_3	0.0	0
745376	NY	Albany	school	3602460	10100010000	ALBANY	360246000032	10100010030	WILLIAM S HACKETT MIDDLE SCHOOL	public	Regular School	No	2.0	06	08	2015	grade_4	0.0	0
745377	NY	Albany	school	3602460	10100010000	ALBANY	360246000032	10100010030	WILLIAM S HACKETT MIDDLE SCHOOL	public	Regular School	No	2.0	06	08	2015	grade_5	0.0	0
745381	NY	Albany	school	3602460	10100010000	ALBANY	360246000032	10100010030	WILLIAM S HACKETT MIDDLE SCHOOL	public	Regular School	No	2.0	06	08	2015	grade_9	0.0	0
745382	NY	Albany	school	3602460	10100010000	ALBANY	360246000032	10100010030	WILLIAM S HACKETT MIDDLE SCHOOL	public	Regular School	No	2.0	06	08	2015	kindergarten_full_day	0.0	0
745383	NY	Albany	school	3602460	10100010000	ALBANY	360246000032	10100010030	WILLIAM S HACKETT MIDDLE SCHOOL	public	Regular School	No	2.0	06	08	2015	kindergarten_half_day	0.0	0
745385	NY	Albany	school	3602460	10100010000	ALBANY	360246000032	10100010030	WILLIAM S HACKETT MIDDLE SCHOOL	public	Regular School	No	2.0	06	08	2015	pre_kindergarten_full_day	0.0	0
745386	NY	Albany	school	3602460	10100010000	ALBANY	360246000032	10100010030	WILLIAM S HACKETT MIDDLE SCHOOL	public	Regular School	No	2.0	06	08	2015	pre_kindergarten_half_day	0.0	0
745387	NY	Albany	school	3602460	10100010000	ALBANY	360246000032	10100010030	WILLIAM S HACKETT MIDDLE SCHOOL	public	Regular School	No	2.0	06	08	2015	ungraded_elementary	0.0	0