schools

Data source: Big Local News · About: Big Local

Custom SQL query returning 43 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 "grade" = :p0 and "state" = :p1 and "year" = :p2 order by rowid 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_alaskan_native	asian	multiracial	male	female	non_binary	ell	homeless	low_income	section_504	total	white_int	black_int	hispanic_int	native_american_alaskan_native_int	asian_int	multiracial_int	male_int	female_int	non_binary_int	ell_int	homeless_int	low_income_int	section_504_int	total_int
2570949	WA	King	school	5300390	17405	Bellevue School District	530039000063	3742	Cherry Crest Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	1	0	0	0	0	0	0	1	0	0	0	0	0.0	1	1	0	0	0	0	0	0	1	0	0	0	0	0	1
2571080	WA	King	school	5300390	17405	Bellevue School District	530039000088	3634	Spiritridge Elementary School	Regular School	No	Elementary	KG	05	2020	kindergarten_half_day	1	0	0	0	0	0	0	1	0	0	0	0	0.0	1	1	0	0	0	0	0	0	1	0	0	0	0	0	1
2571104	WA	King	school	5300390	17405	Bellevue School District	530039003638	5508	Wilburton Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	0	0	0	0	2	0	2	0	0	0	0	0	0.0	2	0	0	0	0	2	0	2	0	0	0	0	0	0	2
2571132	WA	Whatcom	school	5300420	37501	Bellingham School District	530042003476	5366	Bellingham Family Partnership Program	Alternative School	No	Other	KG	12	2020	kindergarten_half_day	1	0	0	0	0	0	0	1	0	0	0	0	0.0	1	1	0	0	0	0	0	0	1	0	0	0	0	0	1
2571837	WA	Clallam	school	5300840	5401	Cape Flattery School District	530084003042	2594	Neah Bay Elementary School	Regular School	No	Elementary	KG	05	2020	kindergarten_half_day	0	0	1	4	0	0	3	2	0	0	0	4	0.0	5	0	0	1	4	0	0	3	2	0	0	0	4	0	5
2571951	WA	Kitsap	school	5301080	18401	Central Kitsap School District	530108003622	5472	Barker Creek Community School	Alternative School	No	Other	KG	12	2020	kindergarten_half_day	7	0	1	0	0	0	5	3	0	0	0	0	1.0	8	7	0	1	0	0	0	5	3	0	0	0	0	1	8
2572085	WA	Spokane	school	5301110	32356	Central Valley School District	530111000187	3259	Adams Elementary	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	1	0	0	0	0	0	2	0	0	0	1	1	0.0	2	1	0	0	0	0	0	2	0	0	0	1	1	0	2
2572097	WA	Spokane	school	5301110	32356	Central Valley School District	530111000190	2892	Broadway Elementary	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	1	0	0	0	0	1	0	2	0	0	1	2	0.0	2	1	0	0	0	0	1	0	2	0	0	1	2	0	2
2572112	WA	Spokane	school	5301110	32356	Central Valley School District	530111000192	3929	Chester Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	1	0	0	0	0	1	1	1	0	0	0	1	0.0	2	1	0	0	0	0	1	1	1	0	0	0	1	0	2
2572128	WA	Spokane	school	5301110	32356	Central Valley School District	530111000194	2157	Greenacres Elementary	Regular School	No	Elementary	KG	05	2020	kindergarten_half_day	3	0	0	0	0	1	2	2	0	0	2	3	0.0	4	3	0	0	0	0	1	2	2	0	0	2	3	0	4
2572154	WA	Spokane	school	5301110	32356	Central Valley School District	530111000197	3127	McDonald Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	1	0	0	0	0	1	1	1	0	0	0	0	0.0	2	1	0	0	0	0	1	1	1	0	0	0	0	0	2
2572171	WA	Spokane	school	5301110	32356	Central Valley School District	530111000199	2113	Opportunity Elementary	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	3	0	0	0	0	0	1	2	0	0	0	0	0.0	3	3	0	0	0	0	0	1	2	0	0	0	0	0	3
2572179	WA	Spokane	school	5301110	32356	Central Valley School District	530111001756	4098	Ponderosa Elementary	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	1	0	0	0	0	0	1	0	0	0	0	1	0.0	1	1	0	0	0	0	0	1	0	0	0	0	1	0	1
2572188	WA	Spokane	school	5301110	32356	Central Valley School District	530111000200	2953	Progress Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	0	0	1	0	0	0	0	1	0	0	0	1	0.0	1	0	0	1	0	0	0	0	1	0	0	0	1	0	1
2572196	WA	Spokane	school	5301110	32356	Central Valley School District	530111003629	5541	Riverbend Elementary School	Regular School	No	Elementary	KG	05	2020	kindergarten_half_day	3	0	0	0	0	0	2	1	0	0	0	1	0.0	3	3	0	0	0	0	0	2	1	0	0	0	1	0	3
2572210	WA	Spokane	school	5301110	32356	Central Valley School District	530111000201	3307	South Pines Elementary	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	0	0	1	0	0	0	1	0	0	1	0	0	0.0	1	0	0	1	0	0	0	1	0	0	1	0	0	0	1
2572221	WA	Spokane	school	5301110	32356	Central Valley School District	530111003137	1964	Spokane Valley Learning Academy	Regular School	No	Elementary	KG	08	2020	kindergarten_half_day	4	0	1	0	0	2	6	1	0	1	0	0	0.0	7	4	0	1	0	0	2	6	1	0	1	0	0	0	7
2572255	WA	Spokane	school	5301110	32356	Central Valley School District	530111000203	3064	University Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	2	0	0	0	0	0	1	1	0	0	0	0	0.0	2	2	0	0	0	0	0	1	1	0	0	0	0	0	2
2573144	WA	Spokane	school	5302070	32414	Deer Park School District	530207002827	1852	Deer Park Home Link Program	Alternative School	No	Other	KG	12	2020	kindergarten_half_day	31	1	1	0	0	0	18	14	1	0	0	12	0.0	33	31	1	1	0	0	0	18	14	1	0	0	12	0	33
2573185	WA	Spokane	school	5302280	32361	East Valley School District (Spokane)	530228002600	1712	Continuous Curriculum School	Regular School	No	Elementary	KG	08	2020	kindergarten_half_day	1	0	0	0	0	0	1	0	0	0	0	1	0.0	1	1	0	0	0	0	0	1	0	0	0	0	1	0	1
2573964	WA	Lewis	school	5302640	21036	Evaline School District	530264000390	2355	Evaline Elementary School	Regular School	No	Elementary	KG	06	2020	kindergarten_half_day	5	0	0	0	0	0	2	3	0	0	0	4	0.0	5	5	0	0	0	0	0	2	3	0	0	0	4	0	5
2574174	WA	Snohomish	school	5302670	31002	Everett School District	530267001792	4125	Woodside Elementary	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	1	0	0	0	0	0	0	1	0	0	0	0	0.0	1	1	0	0	0	0	0	0	1	0	0	0	0	0	1
2575824	WA	Benton	school	5303930	3017	Kennewick School District	530393003330	5220	Cottonwood Elementary	Regular School	No	Elementary	KG	05	2020	kindergarten_half_day	1	0	0	0	0	0	0	1	0	0	0	0	0.0	1	1	0	0	0	0	0	0	1	0	0	0	0	0	1
2575838	WA	Benton	school	5303930	3017	Kennewick School District	530393000599	2824	Eastgate Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	2	0	0	0	0	0	0	2	0	0	0	1	0.0	2	2	0	0	0	0	0	0	2	0	0	0	1	0	2
2575910	WA	Benton	school	5303930	3017	Kennewick School District	530393003115	1941	Mid-Columbia Parent Partnership	Alternative School	No	Other	KG	12	2020	kindergarten_half_day	1	0	0	0	0	0	1	0	0	0	0	0	0.0	1	1	0	0	0	0	0	1	0	0	0	0	0	0	1
2575941	WA	Benton	school	5303930	3017	Kennewick School District	530393000608	4073	Southgate Elementary School	Regular School	No	Elementary	KG	05	2020	kindergarten_half_day	0	0	1	0	0	0	0	1	0	0	0	1	0.0	1	0	0	1	0	0	0	0	1	0	0	0	1	0	1
2575962	WA	Benton	school	5303930	3017	Kennewick School District	530393000609	3369	Vista Elementary School	Regular School	No	Elementary	KG	05	2020	kindergarten_half_day	1	0	0	0	0	0	0	1	0	0	0	0	0.0	1	1	0	0	0	0	0	0	1	0	0	0	0	0	1
2577186	WA	Whatcom	school	5304620	37504	Lynden School District	530462003022	1983	Lynden Academy	Alternative School	No	Other	KG	12	2020	kindergarten_half_day	0	1	0	0	1	0	2	0	0	0	0	0	0.0	2	0	1	0	0	1	0	2	0	0	0	0	0	0	2
2577508	WA	Spokane	school	5304920	32354	Mead School District	530492002844	1858	Mead Education Partnership Prog	Alternative School	No	Other	KG	12	2020	kindergarten_half_day	13	0	1	0	0	0	8	6	0	0	0	4	0.0	14	13	0	1	0	0	0	8	6	0	0	0	4	0	14
2577665	WA	Whatcom	school	5305010	37505	Meridian School District	530501003036	5047	Meridian Parent Partnership Program	Alternative School	No	Elementary	KG	08	2020	kindergarten_half_day	1	0	0	0	0	0	0	1	0	0	0	0	0.0	1	1	0	0	0	0	0	0	1	0	0	0	0	0	1
2577792	WA	Snohomish	school	5305130	31103	Monroe School District	530513002675	1777	Sky Valley Education Center	Alternative School	No	Other	KG	12	2020	kindergarten_half_day	8	0	3	0	0	2	4	9	0	0	0	0	0.0	13	8	0	3	0	0	2	4	9	0	0	0	0	0	13
2579316	WA	Thurston	school	5306180	34111	Olympia School District	530618000929	3066	Madison Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	1	0	0	0	0	0	0	1	0	0	0	0	0.0	1	1	0	0	0	0	0	0	1	0	0	0	0	0	1
2580472	WA	Jefferson	school	5306990	16048	Quilcene School District	530699003353	5236	Partnership for Excellence in Alternative Remote Learning	Alternative School	No	Elementary	KG	08	2020	kindergarten_half_day	13	0	0	0	0	1	7	7	0	0	0	3	0.0	14	13	0	0	0	0	1	7	7	0	0	0	3	0	14
2580665	WA	King	school	5307230	17403	Renton School District	530723001064	3587	Benson Hill Elementary School	Regular School	No	Elementary	KG	05	2020	kindergarten_half_day	1	0	0	0	0	0	0	1	0	0	0	0	0.0	1	1	0	0	0	0	0	0	1	0	0	0	0	0	1
2580708	WA	King	school	5307230	17403	Renton School District	530723002721	1784	H.O.M.E. Program	Alternative School	No	Other	KG	12	2020	kindergarten_half_day	5	0	2	0	1	2	6	4	0	0	0	2	0.0	10	5	0	2	0	1	2	6	4	0	0	0	2	0	10
2580993	WA	Benton	school	5307320	3400	Richland School District	530732003273	5165	Three Rivers Home Link	Alternative School	No	Other	KG	12	2020	kindergarten_half_day	8	0	0	0	0	0	2	6	0	0	0	3	0.0	8	8	0	0	0	0	0	2	6	0	0	0	3	0	8
2582298	WA	King	school	5307920	17412	Shoreline School District	530792002646	1771	Home Education Exchange	Alternative School	No	Elementary	KG	08	2020	kindergarten_half_day	10	0	0	0	0	1	6	5	0	0	0	0	0.0	11	10	0	0	0	0	1	6	5	0	0	0	0	0	11
2583388	WA	Chelan	school	5308430	4069	Stehekin School District	530843001428	2265	Stehekin Elementary	Regular School	No	Elementary	KG	08	2020	kindergarten_half_day	1	0	0	0	0	0	0	1	0	0	0	0	0.0	1	1	0	0	0	0	0	0	1	0	0	0	0	0	1
2583663	WA	Yakima	school	5308670	39201	Sunnyside School District	530867001452	2717	Washington Elementary	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	0	0	1	0	0	0	1	0	0	0	0	0	0.0	1	0	0	1	0	0	0	1	0	0	0	0	0	0	1
2584210	WA	Lewis	school	5308910	21237	Toledo School District	530891001526	2998	Toledo Elementary School	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	5	0	0	0	0	0	2	3	0	0	2	4	0.0	5	5	0	0	0	0	0	2	3	0	0	2	4	0	5
2584871	WA	Thurston	school		34901	WA HE LUT Indian School Agency		5496	Wa He Lut Indian School						2020	kindergarten_half_day	0	1	3	5	0	2	4	7	0	0	1	10	0.0	11	0	1	3	5	0	2	4	7	0	0	1	10	0	11
2585440	WA	Pierce	school	5309780	27416	White River School District	530978001661	2190	Elk Ridge Elementary	Regular School	No	Elementary	PK	05	2020	kindergarten_half_day	14	0	3	1	0	0	7	11	0	0	0	2	0.0	18	14	0	3	1	0	0	7	11	0	0	0	2	0	18
2585462	WA	Pierce	school	5309780	27416	White River School District	530978003722	5564	White River Early Learning Center	Regular School	No	Elementary	PK	KG	2020	kindergarten_half_day	52	1	4	0	1	8	31	35	0	0	0	17	0.0	66	52	1	4	0	1	8	31	35	0	0	0	17	0	66