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 female_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	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_pacific_islander	multiracial	male	female	total	white_int	black_int	hispanic_int	native_american_int	asian_int	native_hawaiian_pacific_islander_int	multiracial_int	male_int	total_int
736773	MA	Suffolk	school	2502790	35	Boston	250279001615	350413	Boston Middle School Academy	Regular School	No	2	07	08	2015	grade_7	*	*	*	*	*	*	*	1	*	1								1	1
736774	MA	Suffolk	school	2502790	35	Boston	250279001615	350413	Boston Middle School Academy	Regular School	No	2	07	08	2015	grade_8	0	5	2	0	0	0	0	5	*	7	0	5	2	0	0	0	0	5	7
737827	MA	Middlesex	school	2504320	79	Dracut	250432002800	790515	Parker Avenue School	Alternative Education School	No	3	09	12	2015	grade_9	*	*	*	*	*	*	*	*	*	2									2
737828	MA	Middlesex	school	2504320	79	Dracut	250432002800	790515	Parker Avenue School	Alternative Education School	No	3	09	12	2015	grade_10	*	*	*	*	*	*	*	*	*	1									1
737829	MA	Middlesex	school	2504320	79	Dracut	250432002800	790515	Parker Avenue School	Alternative Education School	No	3	09	12	2015	grade_11	*	*	*	*	*	*	*	*	*	2									2
737830	MA	Middlesex	school	2504320	79	Dracut	250432002800	790515	Parker Avenue School	Alternative Education School	No	3	09	12	2015	grade_12	*	*	*	*	*	*	*	*	*	2									2
738076	MA	Bristol	school	2504830	95	Fall River	250483000276	950055	ACESE	Alternative Education School	No	1	03	05	2015	grade_3	*	*	*	*	*	*	*	1	*	2								1	2
738077	MA	Bristol	school	2504830	95	Fall River	250483000276	950055	ACESE	Alternative Education School	No	1	03	05	2015	grade_4	*	*	*	*	*	*	*	4	*	4								4	4
738078	MA	Bristol	school	2504830	95	Fall River	250483000276	950055	ACESE	Alternative Education School	No	1	03	05	2015	grade_5	1	3	2	0	0	0	1	7	*	7	1	3	2	0	0	0	1	7	7
738118	MA	Bristol	school	2504830	95	Fall River	250483002696	950326	Stone Therapeutic Day Middle School	Regular School	No	2	06	08	2015	grade_6	2	2	4	0	0	0	1	8	*	9	2	2	4	0	0	0	1	8	9
738119	MA	Bristol	school	2504830	95	Fall River	250483002696	950326	Stone Therapeutic Day Middle School	Regular School	No	2	06	08	2015	grade_7	4	1	3	0	0	0	2	9	*	10	4	1	3	0	0	0	2	9	10
738120	MA	Bristol	school	2504830	95	Fall River	250483002696	950326	Stone Therapeutic Day Middle School	Regular School	No	2	06	08	2015	grade_8	9	0	2	0	0	1	1	10	*	13	9	0	2	0	0	1	1	10	13
738425	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	2	04	05	2015	grade_4	*	*	*	*	*	*	*	*	*	1									1
738426	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	2	04	05	2015	grade_5	*	*	*	*	*	*	*	*	*	1									1
738473	MA	Franklin	school	2505490	114	Greenfield	250549002771	1140030	Green River	Regular School	No	2	04	07	2015	grade_4	*	*	*	*	*	*	*	1	*	1								1	1
738474	MA	Franklin	school	2505490	114	Greenfield	250549002771	1140030	Green River	Regular School	No	2	04	07	2015	grade_5	*	*	*	*	*	*	*	2	*	2								2	2
738475	MA	Franklin	school	2505490	114	Greenfield	250549002771	1140030	Green River	Regular School	No	2	04	07	2015	grade_6	*	*	*	*	*	*	*	2	*	3								2	3
738476	MA	Franklin	school	2505490	114	Greenfield	250549002771	1140030	Green River	Regular School	No	2	04	07	2015	grade_7	*	*	*	*	*	*	*	3	*	3								3	3
739315	MA	Middlesex	school	2507020	160	Lowell	250702002726	1600085	Laura Lee Therapeutic Day School	Regular School	No	1	01	07	2015	grade_1	*	*	*	*	*	*	*	2	*	2								2	2
739316	MA	Middlesex	school	2507020	160	Lowell	250702002726	1600085	Laura Lee Therapeutic Day School	Regular School	No	1	01	07	2015	grade_2	*	*	*	*	*	*	*	1	*	1								1	1
739317	MA	Middlesex	school	2507020	160	Lowell	250702002726	1600085	Laura Lee Therapeutic Day School	Regular School	No	1	01	07	2015	grade_4	*	*	*	*	*	*	*	3	*	4								3	4
739318	MA	Middlesex	school	2507020	160	Lowell	250702002726	1600085	Laura Lee Therapeutic Day School	Regular School	No	1	01	07	2015	grade_5	*	*	*	*	*	*	*	2	*	2								2	2
739319	MA	Middlesex	school	2507020	160	Lowell	250702002726	1600085	Laura Lee Therapeutic Day School	Regular School	No	1	01	07	2015	grade_6	*	*	*	*	*	*	*	3	*	3								3	3
739320	MA	Middlesex	school	2507020	160	Lowell	250702002726	1600085	Laura Lee Therapeutic Day School	Regular School	No	1	01	07	2015	grade_7	*	*	*	*	*	*	*	4	*	4								4	4
739339	MA	Middlesex	school	2507020	160	Lowell	250702002732	1600320	Leblanc Therapeutic Day School	Regular School	No	3	08	12	2015	grade_8	1	1	5	0	0	0	0	7	*	7	1	1	5	0	0	0	0	7	7
739340	MA	Middlesex	school	2507020	160	Lowell	250702002732	1600320	Leblanc Therapeutic Day School	Regular School	No	3	08	12	2015	grade_9	1	2	3	0	0	0	0	5	*	6	1	2	3	0	0	0	0	5	6
739341	MA	Middlesex	school	2507020	160	Lowell	250702002732	1600320	Leblanc Therapeutic Day School	Regular School	No	3	08	12	2015	grade_10	2	1	4	0	0	0	0	5	*	7	2	1	4	0	0	0	0	5	7
739342	MA	Middlesex	school	2507020	160	Lowell	250702002732	1600320	Leblanc Therapeutic Day School	Regular School	No	3	08	12	2015	grade_11	3	0	3	0	0	0	1	5	*	7	3	0	3	0	0	0	1	5	7
739343	MA	Middlesex	school	2507020	160	Lowell	250702002732	1600320	Leblanc Therapeutic Day School	Regular School	No	3	08	12	2015	grade_12	4	1	2	0	0	0	0	7	*	7	4	1	2	0	0	0	0	7	7
741387	MA	Essex	school	2510380	258	Salem	251038002774	2580515	Salem Prep High School	Regular School	No	3	09	12	2015	grade_11	4	2	3	0	0	0	2	10	*	11	4	2	3	0	0	0	2	10	11
741388	MA	Essex	school	2510380	258	Salem	251038002774	2580515	Salem Prep High School	Regular School	No	3	09	12	2015	grade_12	4	0	2	0	0	0	0	5	*	6	4	0	2	0	0	0	0	5	6
741675	MA	Middlesex	school	2510890	274	Somerville	251089002498	2740410	Next Wave Junior High	Alternative Education School	No	2	06	08	2015	grade_6	*	*	*	*	*	*	*	2	*	2								2	2
741676	MA	Middlesex	school	2510890	274	Somerville	251089002498	2740410	Next Wave Junior High	Alternative Education School	No	2	06	08	2015	grade_7	0	2	4	0	0	0	0	5	*	6	0	2	4	0	0	0	0	5	6
741677	MA	Middlesex	school	2510890	274	Somerville	251089002498	2740410	Next Wave Junior High	Alternative Education School	No	2	06	08	2015	grade_8	5	2	3	0	2	0	0	8	*	12	5	2	3	0	2	0	0	8	12
742836	MA	Hampden	school	2512510	332	West Springfield	251251002790	3320515	21st Century Skills Academy	Regular School	No	3	09	12	2015	grade_11	*	*	*	*	*	*	*	2	*	2								2	2
742837	MA	Hampden	school	2512510	332	West Springfield	251251002790	3320515	21st Century Skills Academy	Regular School	No	3	09	12	2015	grade_12	3	0	7	0	0	0	0	7	*	10	3	0	7	0	0	0	0	7	10
744785	MA	Berkshire	school	2511040	765	Southern Berkshire	251104001773	7650015	Monterey	Regular School	No	1	KG	KG	2015	kindergarten	6	0	0	0	0	0	0	*	*	6	6	0	0	0	0	0	0		6
935277	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	2	05	06	2016	grade_5	*	*	*	*	*	*	*	*	*	1									1
935278	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	2	05	06	2016	grade_6	*	*	*	*	*	*	*	*	*	1									1
935326	MA	Franklin	school	2505490	114	Greenfield	250549002771	1140030	Green River	Regular School	No	2	04	04	2016	grade_4	9	0	1	0	1	0	0	10	*	11	9	0	1	0	1	0	0	10	11
936162	MA	Middlesex	school	2507020	160	Lowell	250702002726	1600085	Laura Lee Therapeutic Day School	Regular School	No	1	02	07	2016	grade_2	*	*	*	*	*	*	*	1	*	1								1	1
936163	MA	Middlesex	school	2507020	160	Lowell	250702002726	1600085	Laura Lee Therapeutic Day School	Regular School	No	1	02	07	2016	grade_3	*	*	*	*	*	*	*	2	*	2								2	2
936164	MA	Middlesex	school	2507020	160	Lowell	250702002726	1600085	Laura Lee Therapeutic Day School	Regular School	No	1	02	07	2016	grade_4	*	*	*	*	*	*	*	1	*	1								1	1
936165	MA	Middlesex	school	2507020	160	Lowell	250702002726	1600085	Laura Lee Therapeutic Day School	Regular School	No	1	02	07	2016	grade_5	*	*	*	*	*	*	*	3	*	4								3	4
936166	MA	Middlesex	school	2507020	160	Lowell	250702002726	1600085	Laura Lee Therapeutic Day School	Regular School	No	1	02	07	2016	grade_6	*	*	*	*	*	*	*	3	*	3								3	3
936167	MA	Middlesex	school	2507020	160	Lowell	250702002726	1600085	Laura Lee Therapeutic Day School	Regular School	No	1	02	07	2016	grade_7	*	*	*	*	*	*	*	3	*	3								3	3
936655	MA	Middlesex	school	2507560	176	Medford	250756002393	1760510	Curtis-Tufts	Regular School	No	3	09	12	2016	grade_9	*	*	*	*	*	*	*	1	*	1								1	1
936656	MA	Middlesex	school	2507560	176	Medford	250756002393	1760510	Curtis-Tufts	Regular School	No	3	09	12	2016	grade_10	*	*	*	*	*	*	*	3	*	5								3	5
936657	MA	Middlesex	school	2507560	176	Medford	250756002393	1760510	Curtis-Tufts	Regular School	No	3	09	12	2016	grade_11	*	*	*	*	*	*	*	2	*	3								2	3
936658	MA	Middlesex	school	2507560	176	Medford	250756002393	1760510	Curtis-Tufts	Regular School	No	3	09	12	2016	grade_12	*	*	*	*	*	*	*	2	*	4								2	4
937587	MA	Worcester	school	2509270	226	Oxford	250927002810	2260305	Project C.O.F.F.E.E.	Special Education School	No	4	05	12	2016	grade_8	*	*	*	*	*	*	*	1	*	1								1	1
937588	MA	Worcester	school	2509270	226	Oxford	250927002810	2260305	Project C.O.F.F.E.E.	Special Education School	No	4	05	12	2016	grade_9	5	1	2	0	0	0	0	6	*	8	5	1	2	0	0	0	0	6	8
937589	MA	Worcester	school	2509270	226	Oxford	250927002810	2260305	Project C.O.F.F.E.E.	Special Education School	No	4	05	12	2016	grade_10	*	*	*	*	*	*	*	4	*	5								4	5
937590	MA	Worcester	school	2509270	226	Oxford	250927002810	2260305	Project C.O.F.F.E.E.	Special Education School	No	4	05	12	2016	grade_11	*	*	*	*	*	*	*	5	*	5								5	5
937591	MA	Worcester	school	2509270	226	Oxford	250927002810	2260305	Project C.O.F.F.E.E.	Special Education School	No	4	05	12	2016	grade_12	9	0	1	0	0	0	0	9	*	10	9	0	1	0	0	0	0	9	10
938207	MA	Essex	school	2510380	258	Salem	251038002774	2580515	Salem Prep High School	Regular School	No	3	09	12	2016	grade_10	*	*	*	*	*	*	*	1	*	2								1	2
938208	MA	Essex	school	2510380	258	Salem	251038002774	2580515	Salem Prep High School	Regular School	No	3	09	12	2016	grade_11	*	*	*	*	*	*	*	1	*	3								1	3
938209	MA	Essex	school	2510380	258	Salem	251038002774	2580515	Salem Prep High School	Regular School	No	3	09	12	2016	grade_12	4	2	1	0	0	0	1	7	*	8	4	2	1	0	0	0	1	7	8
938478	MA	Middlesex	school	2510890	274	Somerville	251089002498	2740410	Next Wave Junior High	Alternative Education School	No	2	06	08	2016	grade_6	*	*	*	*	*	*	*	2	*	2								2	2
938479	MA	Middlesex	school	2510890	274	Somerville	251089002498	2740410	Next Wave Junior High	Alternative Education School	No	2	06	08	2016	grade_7	1	3	5	0	0	0	0	7	*	9	1	3	5	0	0	0	0	7	9
938480	MA	Middlesex	school	2510890	274	Somerville	251089002498	2740410	Next Wave Junior High	Alternative Education School	No	2	06	08	2016	grade_8	3	5	7	0	0	0	0	13	*	15	3	5	7	0	0	0	0	13	15
938826	MA	Hampden	school	2511130	281	Springfield	251113002734	2810560	Liberty Preparatory Academy	Regular School	No	3	09	12	2016	grade_10	*	*	*	*	*	*	*	5	*	5								5	5
938827	MA	Hampden	school	2511130	281	Springfield	251113002734	2810560	Liberty Preparatory Academy	Regular School	No	3	09	12	2016	grade_11	*	*	*	*	*	*	*	2	*	3								2	3
938828	MA	Hampden	school	2511130	281	Springfield	251113002734	2810560	Liberty Preparatory Academy	Regular School	No	3	09	12	2016	grade_12	3	0	5	0	0	0	0	4	*	8	3	0	5	0	0	0	0	4	8
939287	MA	Plymouth	school	2512060	310	Wareham	251206002668	3100310	West Academy	Regular School	No	N	N	N	2016	grade_8	*	*	*	*	*	*	*	*	*	1									1
939288	MA	Plymouth	school	2512060	310	Wareham	251206002668	3100310	West Academy	Regular School	No	N	N	N	2016	grade_9	*	*	*	*	*	*	*	*	*	1									1
939289	MA	Plymouth	school	2512060	310	Wareham	251206002668	3100310	West Academy	Regular School	No	N	N	N	2016	grade_10	*	*	*	*	*	*	*	*	*	2									2
939290	MA	Plymouth	school	2512060	310	Wareham	251206002668	3100310	West Academy	Regular School	No	N	N	N	2016	grade_11	*	*	*	*	*	*	*	*	*	1									1
939641	MA	Hampden	school	2512510	332	West Springfield	251251002790	3320515	21st Century Skills Academy	Regular School	No	3	09	12	2016	grade_11	*	*	*	*	*	*	*	5	*	5								5	5
939642	MA	Hampden	school	2512510	332	West Springfield	251251002790	3320515	21st Century Skills Academy	Regular School	No	3	09	12	2016	grade_12	9	2	2	0	0	0	0	9	*	13	9	2	2	0	0	0	0	9	13
941477	MA	Middlesex	school	2508790	735	North Middlesex	250879002705	7350515	Peter Fitzpatrick School	Regular School	No	4	UG	UG	2016	sped_beyond_grade_12	10	0	0	0	0	0	0	*	*	10	10	0	0	0	0	0	0		10
1123285	MA	Suffolk	school	2502790	35	Boston	250279001617	350518	Community Academy	Regular School	No	High	09	12	2017	grade_9	*	*	*	*	*	*	*	2	*	*								2
1123286	MA	Suffolk	school	2502790	35	Boston	250279001617	350518	Community Academy	Regular School	No	High	09	12	2017	grade_10	1	8	3	0	0	0	1	10	*	13	1	8	3	0	0	0	1	10	13
1123287	MA	Suffolk	school	2502790	35	Boston	250279001617	350518	Community Academy	Regular School	No	High	09	12	2017	grade_11	0	8	7	0	0	0	1	15	*	16	0	8	7	0	0	0	1	15	16
1123288	MA	Suffolk	school	2502790	35	Boston	250279001617	350518	Community Academy	Regular School	No	High	09	12	2017	grade_12	0	13	0	0	0	0	0	12	*	13	0	13	0	0	0	0	0	12	13
1124814	MA	Bristol	school	2504830	95	Fall River	250483002852	950340	Stone Day School	Regular School	No	Elementary	02	08	2017	grade_2	*	*	*	*	*	*	*	1	*	*								1
1124815	MA	Bristol	school	2504830	95	Fall River	250483002852	950340	Stone Day School	Regular School	No	Elementary	02	08	2017	grade_3	*	*	*	*	*	*	*	3	*	*								3
1124816	MA	Bristol	school	2504830	95	Fall River	250483002852	950340	Stone Day School	Regular School	No	Elementary	02	08	2017	grade_4	*	*	*	*	*	*	*	2	*	*								2
1124817	MA	Bristol	school	2504830	95	Fall River	250483002852	950340	Stone Day School	Regular School	No	Elementary	02	08	2017	grade_5	3	0	1	0	0	0	2	6	*	6	3	0	1	0	0	0	2	6	6
1124818	MA	Bristol	school	2504830	95	Fall River	250483002852	950340	Stone Day School	Regular School	No	Elementary	02	08	2017	grade_6	*	*	*	*	*	*	*	5	*	*								5
1124819	MA	Bristol	school	2504830	95	Fall River	250483002852	950340	Stone Day School	Regular School	No	Elementary	02	08	2017	grade_7	1	2	2	0	0	0	2	6	*	7	1	2	2	0	0	0	2	6	7
1124820	MA	Bristol	school	2504830	95	Fall River	250483002852	950340	Stone Day School	Regular School	No	Elementary	02	08	2017	grade_8	2	1	3	0	0	0	0	6	*	6	2	1	3	0	0	0	0	6	6
1125185	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	kindergarten	*	*	*	*	*	*	*	*	*	*
1125186	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	pre_kindergarten	*	*	*	*	*	*	*	*	*	*
1125187	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	grade_1	*	*	*	*	*	*	*	*	*	*
1125188	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	grade_2	*	*	*	*	*	*	*	*	*	*
1125189	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	grade_3	*	*	*	*	*	*	*	*	*	*
1125190	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	grade_4	*	*	*	*	*	*	*	*	*	*
1125191	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	grade_5	*	*	*	*	*	*	*	*	*	*
1125192	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	grade_6	*	*	*	*	*	*	*	*	*	*
1125193	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	grade_7	*	*	*	*	*	*	*	*	*	*
1125194	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	grade_8	*	*	*	*	*	*	*	*	*	*
1125195	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	grade_9	*	*	*	*	*	*	*	*	*	*
1125196	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	grade_10	*	*	*	*	*	*	*	*	*	*
1125197	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	grade_11	*	*	*	*	*	*	*	*	*	*
1125198	MA	Dukes	school	2505340	109	Gosnold	250534000725	1090005	Cuttyhunk Elementary	Regular School	No	Middle	06	07	2017	grade_12	*	*	*	*	*	*	*	*	*	*
1125259	MA	Franklin	school	2505490	114	Greenfield	250549002771	1140030	Green River	Regular School	No	Elementary	04	04	2017	kindergarten	*	*	*	*	*	*	*	*	*	*
1125260	MA	Franklin	school	2505490	114	Greenfield	250549002771	1140030	Green River	Regular School	No	Elementary	04	04	2017	pre_kindergarten	*	*	*	*	*	*	*	*	*	*
1125261	MA	Franklin	school	2505490	114	Greenfield	250549002771	1140030	Green River	Regular School	No	Elementary	04	04	2017	grade_1	*	*	*	*	*	*	*	*	*	*
1125262	MA	Franklin	school	2505490	114	Greenfield	250549002771	1140030	Green River	Regular School	No	Elementary	04	04	2017	grade_2	*	*	*	*	*	*	*	*	*	*
1125263	MA	Franklin	school	2505490	114	Greenfield	250549002771	1140030	Green River	Regular School	No	Elementary	04	04	2017	grade_3	*	*	*	*	*	*	*	*	*	*