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

Query parameters

This data as json, CSV

rowid	state	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	multiracial	male	ell	disability	total	white_int	black_int	hispanic_int	multiracial_int	male_int	ell_int	disability_int	total_int
1751558	IN	school	1800060	15	Adams Central Community Schools	180006000007	21	Adams Central High School	Regular School	No	High	09	12	2019	adult					3.0			3.0					3			3
1751585	IN	school	1810260	35	South Adams Schools	181026001642	23	South Adams High School	Regular School	No	High	09	12	2019	adult					3.0			3.0					3			3
1751719	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	High	08	12	2019	grade_10					2.0			2.0					2			2
1751720	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	High	08	12	2019	grade_11					1.0			1.0					1			1
1751721	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	High	08	12	2019	grade_12					1.0			1.0					1			1
1751722	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	High	08	12	2019	grade_8					1.0			1.0					1			1
1751723	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	High	08	12	2019	grade_9					1.0			1.0					1			1
1751724	IN	school	1803630	235	Fort Wayne Community Schools	180363002174	100	Allen Co Juvenile Center	Regular School	No	High	08	12	2019	pk_12_total	1.0	3.0	1.0	1.0	6.0	0.0	3.0	6.0	1	3	1	1	6	0	3	6
1752117	IN	school	1802850	255	East Allen County Schools	180285002532	394	East Allen University	Regular School	No	High	09	12	2019	adult					1.0			1.0					1			1
1752489	IN	school	1808940	775	Pioneer Regional School Corp	180894001491	645	Pioneer Jr-Sr High School	Regular School	No	High	06	12	2019	grade_6					2.0			2.0					2			2
1752524	IN	school	1806030	875	Logansport Community Sch Corp	180603001060	701	Logansport Community High School	Regular School	No	High	07	12	2019	grade_7					3.0			3.0					3			3
1752528	IN	school	1806030	875	Logansport Community Sch Corp	180603001058	702	Logansport Junior High School	Regular School	No	Middle	06	08	2019	grade_6					1.0			1.0					1			1
1752563	IN	school	1806030	875	Logansport Community Sch Corp	180603001052	715	Columbia 6th Grade Academy	Regular School	No	Middle	04	08	2019	grade_4					1.0			1.0					1			1
1752568	IN	school	1809370	940	West Clark Community Schools	180937001531	765	Henryville Jr & Sr High School	Regular School	No	High	07	12	2019	adult					2.0			2.0					2			2
1752620	IN	school	1801920	1000	Clarksville Community School Corp	180192000249	833	Clarksville Senior High School	Regular School	No	High	09	12	2019	adult					2.0			2.0					2			2
1752758	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	High	06	12	2019	grade_12					8.0			8.0					8			8
1752759	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	High	06	12	2019	grade_6					2.0			2.0					2			2
1752761	IN	school	1803940	1010	Greater Clark County Schools	180394000832	886	Old Corden Porter School	Special Education School	No	High	06	12	2019	grade_8					4.0			4.0					4			4
1753092	IN	school	1805700	1620	Lawrenceburg Community School Corp	180570001037	1177	Lawrenceburg High School	Regular School	No	High	09	12	2019	adult					3.0			3.0					3			3
1753111	IN	school	1802610	1655	Decatur County Community Schools	180261000311	1263	South Decatur Jr-Sr High School	Regular School	No	High	07	12	2019	adult					1.0			1.0					1			1
1753209	IN	school	1801590	1835	DeKalb Co Ctl United Sch Dist	180159000220	1345	DeKalb High School	Regular School	No	High	09	12	2019	adult					8.0			8.0					8			8
1753325	IN	school	1807230	1910	Yorktown Community Schools	180723001217	1389	Yorktown High School	Regular School	No	High	09	12	2019	adult					1.0			1.0					1			1
1753415	IN	school	1807320	1970	Muncie Community Schools	180732001232	1524	Youth Opportunity Center	Alternative School	No	Other	04	12	2019	grade_12					5.0			5.0					5			5
1753416	IN	school	1807320	1970	Muncie Community Schools	180732001232	1524	Youth Opportunity Center	Alternative School	No	Other	04	12	2019	grade_4					1.0			1.0					1			1
1753417	IN	school	1807320	1970	Muncie Community Schools	180732001232	1524	Youth Opportunity Center	Alternative School	No	Other	04	12	2019	grade_6					4.0			4.0					4			4
1753522	IN	school	1803480	2155	Fairfield Community Schools	180348000491	1613	Fairfield Jr-Sr High School	Regular School	No	High	07	12	2019	adult					3.0			3.0					3			3
1753575	IN	school	1802400	2270	Concord Community Schools	180240000271	1713	Concord Junior High School	Regular School	No	Middle	07	09	2019	grade_9					2.0			2.0					2			2
1753583	IN	school	1802400	2270	Concord Community Schools	180240002484	1718	Concord Intermediate School	Regular School	No	Middle	04	06	2019	grade_4					2.0			2.0					2			2
1753617	IN	school	1806600	2275	Middlebury Community Schools	180660001162	1657	Northridge Middle School	Regular School	No	Middle	06	10	2019	grade_10					1.0			1.0					1			1
1753630	IN	school	1806600	2275	Middlebury Community Schools	180660002427	1731	Heritage Intermediate School	Regular School	No	Middle	04	06	2019	grade_6					2.0			2.0					2			2
1753740	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	02	12	2019	grade_4					2.0			2.0					2			2
1753741	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	02	12	2019	grade_5					5.0			5.0					5			5
1753743	IN	school	1803270	2305	Elkhart Community Schools	180327002585	1752	Elkhart Alternative Education	Regular School	No	Other	02	12	2019	grade_7					5.0			5.0					5			5
1753833	IN	school	1803930	2315	Goshen Community Schools	180393000659	1629	Goshen Middle School	Regular School	No	High	05	12	2019	grade_11					1.0			1.0					1			1
1753887	IN	school	1803930	2315	Goshen Community Schools	180393002180	1847	Prairie View Elementary School	Regular School	No	Elementary	PK	07	2019	grade_6					2.0			2.0					2			2
1753888	IN	school	1803930	2315	Goshen Community Schools	180393002180	1847	Prairie View Elementary School	Regular School	No	Elementary	PK	07	2019	grade_7					1.0			1.0					1			1
1754194	IN	school	1807770	2735	North Gibson School Corporation	180777001324	2223	Princeton Comm Intermediate School	Regular School	No	Elementary	KG	05	2019	grade_2					1.0			1.0					1			1
1754356	IN	school		2865	Marion Community Schools		2416	Grant County Comm Justice Center						2019	grade_11					1.0			1.0					1			1
1754357	IN	school		2865	Marion Community Schools		2416	Grant County Comm Justice Center						2019	pk_12_total	1.0				1.0	0.0	0.0	1.0	1				1	0	0	1
1754543	IN	school	1804260	3025	Hamilton Heights School Corp	180426000728	2477	Hamilton Heights High School	Regular School	No	High	09	12	2019	adult					3.0			3.0					3			3
1754563	IN	school	1813080	3030	Westfield-Washington Schools	181308002074	2491	Westfield Middle School	Regular School	No	Middle	05	08	2019	grade_6					2.0			2.0					2			2
1755029	IN	school	1808100	3295	North West Hendricks Schools	180810001387	2731	Tri-West Senior High School	Regular School	No	High	09	12	2019	adult					2.0			2.0					2			2
1755109	IN	school	1800270	3315	Avon Community School Corp	180027002092	2729	Avon Intermediate School West	Regular School	No	Middle	04	06	2019	grade_4					1.0			1.0					1			1
1755165	IN	school	1802550	3325	Danville Community School Corp	180255000306	2721	North Elementary School	Regular School	No	Elementary	KG	03	2019	grade_3					1.0			1.0					1			1
1755174	IN	school	1802550	3325	Danville Community School Corp	180255000305	2743	Danville Middle School	Regular School	No	Other	04	09	2019	grade_4					1.0			1.0					1			1
1755179	IN	school	1802550	3325	Danville Community School Corp	180255000305	2743	Danville Middle School	Regular School	No	Other	04	09	2019	grade_9					1.0			1.0					1			1
1755300	IN	school	1807440	3445	New Castle Community School Corp	180744001290	2825	New Castle High School	Regular School	No	High	07	12	2019	grade_8					1.0			1.0					1			1
1755418	IN	school	1803150	3480	Eastern Howard School Corporation	180315000412	2909	Eastern Elementary School	Regular School	No	Elementary	PK	07	2019	pre_kindergarten					10.0			10.0					10			10
1755443	IN	school	1804470	3490	Western School Corporation	180447002224	2923	Western Intermediate School	Regular School	No	Middle	03	08	2019	grade_7					1.0			1.0					1			1
1755448	IN	school	1804470	3490	Western School Corporation	180447000755	2935	Western Primary School	Regular School	No	Elementary	KG	03	2019	grade_3					1.0			1.0					1			1
1755646	IN	school	1801050	3695	Brownstown Cnt Com Sch Corp	180105000180	3126	Brownstown Central High School	Regular School	No	High	09	12	2019	adult					1.0			1.0					1			1
1755705	IN	school	1809420	3815	Rensselaer Central School Corp	180942001545	3205	Van Rensselaer Elementary School	Regular School	No	Elementary	02	05	2019	grade_2					2.0			2.0					2			2
1755713	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	Elementary	PK	05	2019	grade_4					1.0			1.0					1			1
1755714	IN	school	1809420	3815	Rensselaer Central School Corp	180942001542	3213	Rensselaer Central Primary School	Regular School	No	Elementary	PK	05	2019	grade_5					1.0			1.0					1			1
1755718	IN	school	1809420	3815	Rensselaer Central School Corp	180942001544	3221	Rensselaer Middle School	Regular School	No	Middle	05	08	2019	grade_5					2.0			2.0					2			2
1755777	IN	school	1806120	3995	Madison Consolidated Schools	180612001090	3309	Madison Consolidated High School	Regular School	No	High	08	12	2019	grade_8					1.0			1.0					1			1
1755805	IN	school	1806120	3995	Madison Consolidated Schools	180612001088	3333	Emery O Muncie Elementary School	Regular School	No	Elementary	KG	05	2019	grade_5					1.0			1.0					1			1
1755978	IN	school	1803240	4215	Edinburgh Community School Corp	180324000422	3447	Edinburgh Community High School	Regular School	No	High	09	12	2019	adult					1.0			1.0					1			1
1756334	IN	school	1809300	4515	Prairie Heights Community Sch Corp	180930001526	3690	Prairie Heights Sr High School	Regular School	No	High	09	12	2019	adult					2.0			2.0					2			2
1756340	IN	school	1813110	4525	Westview School Corporation	181311002079	3697	Westview Jr-Sr High School	Regular School	No	High	06	12	2019	adult					2.0			2.0					2			2
1756344	IN	school	1813110	4525	Westview School Corporation	181311002079	3697	Westview Jr-Sr High School	Regular School	No	High	06	12	2019	grade_6					2.0			2.0					2			2
1756578	IN	school	1811460	4645	Tri-Creek School Corporation	181146001852	3865	Lowell Senior High School	Regular School	No	High	09	12	2019	adult					1.0			1.0					1			1
1756584	IN	school	1805460	4650	Lake Ridge New Tech Schools	180546000989	3869	Calumet New Tech High School	Regular School	No	High	09	12	2019	adult					1.0			1.0					1			1
1757030	IN	school	1804590	4730	School City of Hobart	180459000214	4327	Joan Martin Elementary School	Regular School	No	Elementary	KG	06	2019	kindergarten					1.0			1.0					1			1
1757481	IN	school	1810440	5255	South Madison Com Sch Corp	181044001676	5064	Maple Ridge Elementary School	Regular School	No	Elementary	PK	06	2019	pre_kindergarten					1.0			1.0					1			1
1758207	IN	school		5375	M S D Wayne Township		5271	Sanders School						2019	grade_1					6.0			6.0					6			6
1758209	IN	school		5375	M S D Wayne Township		5271	Sanders School						2019	grade_11					6.0			6.0					6			6
1758210	IN	school		5375	M S D Wayne Township		5271	Sanders School						2019	grade_12					6.0			6.0					6			6
1758212	IN	school		5375	M S D Wayne Township		5271	Sanders School						2019	grade_3					5.0			5.0					5			5
1758213	IN	school		5375	M S D Wayne Township		5271	Sanders School						2019	grade_4					3.0			3.0					3			3
1758218	IN	school		5375	M S D Wayne Township		5271	Sanders School						2019	grade_9					10.0			10.0					10			10
1758219	IN	school		5375	M S D Wayne Township		5271	Sanders School						2019	kindergarten					1.0			1.0					1			1
1758277	IN	school	1804770	5385	Indianapolis Public Schools	180477002651	108	Impact Academy	Regular School	No	Other	03	12	2019	grade_3					2.0			2.0					2			2
1758666	IN	school	1804770	5385	Indianapolis Public Schools	180477000858	5609	Jonathan Jennings School 109	Regular School	No	Elementary	PK	06	2019	pre_kindergarten					2.0			2.0					2			2
1758816	IN	school	1800180	5470	Argos Community Schools	180018000048	5937	Argos Comm Jr-Sr High School	Regular School	No	High	07	12	2019	adult					1.0			1.0					1			1
1758845	IN	school	1809060	5485	Plymouth Community School Corp	180906001500	5945	Plymouth High School	Regular School	No	High	09	12	2019	adult					2.0			2.0					2			2
1758851	IN	school	1809060	5485	Plymouth Community School Corp	180906001499	5949	Lincoln Junior High School	Regular School	No	Middle	06	08	2019	grade_6					2.0			2.0					2			2
1758893	IN	school	1810170	5520	Shoals Community School Corp	181017001635	5985	Shoals Community High School	Regular School	No	High	09	12	2019	adult					1.0			1.0					1			1
1758981	IN	school	1808340	5625	Oak Hill United School Corp	180834001432	6081	Sweetser Elementary School	Regular School	No	Elementary	KG	04	2019	grade_2					1.0			1.0					1			1
1758984	IN	school	1808340	5625	Oak Hill United School Corp	180834001432	6081	Sweetser Elementary School	Regular School	No	Elementary	KG	04	2019	kindergarten					1.0			1.0					1			1
1758993	IN	school	1808850	5635	Peru Community Schools	180885001477	6089	Peru Junior High School	Regular School	No	Middle	05	08	2019	grade_6					3.0			3.0					3			3
1759003	IN	school	1808850	5635	Peru Community Schools	180885001471	6093	Blair Pointe Upper Elementary	Regular School	No	Elementary	KG	06	2019	kindergarten					1.0			1.0					1			1
1759220	IN	school	1810450	5845	South Montgomery Com Sch Corp	181045001714	6233	Ladoga Elementary School	Regular School	No	Elementary	PK	05	2019	pre_kindergarten					1.0			1.0					1			1
1759307	IN	school	1806510	5925	M S D Martinsville Schools	180651001132	6309	Green Township Elementary School	Regular School	No	Elementary	PK	04	2019	pre_kindergarten					1.0			1.0					1			1
1759314	IN	school	1806510	5925	M S D Martinsville Schools	180651002600	6332	John R. Wooden Middle School	Regular School	No	Middle	06	08	2019	grade_6					1.0			1.0					1			1
1759334	IN	school	1806510	5925	M S D Martinsville Schools	180651001129	6341	Centerton Elementary School	Regular School	No	Elementary	PK	04	2019	pre_kindergarten					1.0			1.0					1			1
1759370	IN	school	1807140	5930	Mooresville Con School Corp	180714001212	6373	Paul Hadley Middle School	Regular School	No	Middle	06	08	2019	grade_6					4.0			4.0					4			4
1759904	IN	school	1811700	6530	Union Township School Corp	181170001873	6841	Wheeler High School	Regular School	No	High	09	12	2019	adult					1.0			1.0					1			1
1760101	IN	school	1807950	6600	M S D North Posey Co Schools	180795001366	6975	North Posey High School	Regular School	No	High	09	12	2019	adult					1.0			1.0					1			1
1760132	IN	school	1807110	6620	Eastern Pulaski Community Sch Corp	180711001204	6994	Eastern Pulaski Elementary School	Regular School	No	Elementary	PK	05	2019	pre_kindergarten					4.0			4.0					4			4
1760223	IN	school	1803990	6755	Greencastle Community School Corp	180399000690	7089	Greencastle Senior High School	Regular School	No	High	09	12	2019	adult					1.0			1.0					1			1
1760232	IN	school	1803990	6755	Greencastle Community School Corp	180399000689	7093	Greencastle Middle School	Regular School	No	Middle	06	09	2019	grade_9					1.0			1.0					1			1
1760289	IN	school	1810740	6805	Randolph Southern School Corp	181074001763	7121	Randolph Southern Jr-Sr High Sch	Regular School	No	High	07	12	2019	adult					1.0			1.0					1			1
1760367	IN	school	1810530	6865	South Ripley Com Sch Corp	181053001729	7182	South Ripley High School	Regular School	No	High	09	12	2019	adult					1.0			1.0					1			1
1760470	IN	school	1809120	7150	John Glenn School Corporation	180912001505	7453	John Glenn High School	Regular School	No	High	09	12	2019	adult					1.0			1.0					1			1
1760614	IN	school	1806840	7200	School City of Mishawaka	180684000531	7467	Oaklawn Campus Program	Special Education School	No	Other	04	12	2019	grade_4					1.0			1.0					1			1
1760615	IN	school	1806840	7200	School City of Mishawaka	180684000531	7467	Oaklawn Campus Program	Special Education School	No	Other	04	12	2019	grade_6					1.0			1.0					1			1
1760616	IN	school	1806840	7200	School City of Mishawaka	180684000531	7467	Oaklawn Campus Program	Special Education School	No	Other	04	12	2019	grade_7					3.0			3.0					3			3
1760859	IN	school	1810290	7205	South Bend Community School Corp	181029000898	7632	Juvenile Justice Center	Alternative School	No	High	07	12	2019	grade_10					4.0			4.0					4			4
1760969	IN	school	1808310	7350	Northwestern Con School Corp	180831001423	7689	Triton Central High School	Regular School	No	High	09	12	2019	adult					1.0			1.0					1			1
1761007	IN	school	1810140	7365	Shelbyville Central Schools	181014002496	7671	Especially Kidz Health & Rehab Cnt	Regular School	No	Other	PK	12	2019	grade_2					2.0			2.0					2			2