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 (school_nces_id > :p2 or (school_nces_id = :p2 and rowid > :p1)) order by school_nces_id, rowid limit 101

Query parameters

This data as json, CSV

rowid	state	county	admin_level	district_nces_id	district_state_id	district_state_type	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	pacific_islander	multiracial	male	female	ell	low_income	disability	total	white_int	black_int	hispanic_int	native_american_int	asian_int	pacific_islander_int	multiracial_int	male_int	female_int	ell_int	low_income_int	disability_int	total_int
326812	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2017	grade_11													31													31
326813	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2017	grade_12													37													37
326814	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2017	grade_7													40													40
326815	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2017	grade_8													47													47
326816	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2017	grade_9													46													46
2319308	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2020	pk_12_total	268.0	4.0	14.0	3.0	1.0		4.0	148.0	146.0		127	46	294	268	4	14	3	1		4	148	146		127	46	294
2319309	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2020	grade_10													50													50
2319310	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2020	grade_11													54													54
2319311	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2020	grade_12													44													44
2319312	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2020	grade_7													55													55
2319313	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2020	grade_8													44													44
2319314	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2020	grade_9													47													47
2334092	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2021	pk_12_total	251.0	1.0	15.0	2.0			6.0	146.0	129.0		123	42	275	251	1	15	2			6	146	129		123	42	275
2334093	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2021	grade_10													44													44
2334094	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2021	grade_11													41													41
2334095	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2021	grade_12													48													48
2334096	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2021	grade_7													49													49
2334097	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2021	grade_8													49													49
2334098	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2021	grade_9													44													44
3075095	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2019	pk_12_total	235.0	4.0	14.0	2.0	2.0		4.0	126.0	135.0		93	46	261	235	4	14	2	2		4	126	135		93	46	261
3075096	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2019	grade_10													46													46
3075097	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2019	grade_11													44													44
3075098	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2019	grade_12													43													43
3075099	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2019	grade_7													42													42
3075100	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2019	grade_8													46													46
3075101	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2019	grade_9													40													40
3089855	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2018	pk_12_total	237.0	3.0	17.0	3.0	2.0			113.0	149.0		83	46	262	237	3	17	3	2			113	149		83	46	262
3089856	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2018	grade_10													46													46
3089857	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2018	grade_11													49													49
3089858	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2018	grade_12													28													28
3089859	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2018	grade_7													54													54
3089860	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2018	grade_8													39													39
3089861	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602378	11	Blair-Taylor Middle/High	Regular School	No	High	07	12	2018	grade_9													46													46
112919	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2015	pk_12_total	279.0	1.0	10.0	1.0			6.0	151.0	146.0		147	48	297	279	1	10	1			6	151	146		147	48	297
112920	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2015	grade_1													44													44
112921	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2015	grade_2													40													40
112922	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2015	grade_3													33													33
112923	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2015	grade_4													43													43
112924	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2015	grade_5													25													25
112925	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2015	grade_6													33													33
112926	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2015	kindergarten_4_year_old													41													41
112927	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2015	kindergarten													33													33
112928	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2015	pre_kindergarten													5													5
282900	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2016	pk_12_total	291.0	8.0	9.0	2.0	1.0		3.0	156.0	158.0		151	45	314	291	8	9	2	1		3	156	158		151	45	314
282901	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2016	grade_1													34													34
282902	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2016	grade_2													42													42
282903	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2016	grade_3													40													40
282904	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2016	grade_4													35													35
282905	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2016	grade_5													41													41
282906	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2016	grade_6													31													31
282907	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2016	kindergarten_4_year_old													48													48
282908	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2016	kindergarten													40													40
282909	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	1.0	PK	06	2016	pre_kindergarten													3													3
326800	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2017	pk_12_total	299.0	4.0	12.0	1.0	1.0		1.0	156.0	162.0		144	49	318	299	4	12	1	1		1	156	162		144	49	318
326801	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2017	grade_1													32													32
326802	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2017	grade_2													34													34
326803	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2017	grade_3													40													40
326804	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2017	grade_4													39													39
326805	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2017	grade_5													40													40
326806	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2017	grade_6													40													40
326807	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2017	kindergarten_4_year_old													39													39
326808	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2017	kindergarten													50													50
326809	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2017	pre_kindergarten													4													4
2319298	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2020	pk_12_total	322.0	5.0	13.0	1.0	2.0		7.0	172.0	178.0		163	63	350	322	5	13	1	2		7	172	178		163	63	350
2319299	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2020	grade_1													49													49
2319300	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2020	grade_2													41													41
2319301	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2020	grade_3													49													49
2319302	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2020	grade_4													42													42
2319303	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2020	grade_5													38													38
2319304	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2020	grade_6													50													50
2319305	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2020	kindergarten_4_year_old													35													35
2319306	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2020	kindergarten													38													38
2319307	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2020	pre_kindergarten													8													8
2334082	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2021	pk_12_total	290.0	4.0	19.0	1.0		1.0	7.0	155.0	167.0	1.0	152	61	322	290	4	19	1		1	7	155	167	1	152	61	322
2334083	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2021	grade_1													35													35
2334084	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2021	grade_2													38													38
2334085	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2021	grade_3													40													40
2334086	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2021	grade_4													46													46
2334087	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2021	grade_5													39													39
2334088	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2021	grade_6													40													40
2334089	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2021	kindergarten_4_year_old													41													41
2334090	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2021	kindergarten													36													36
2334091	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2021	pre_kindergarten													7													7
3075085	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2019	pk_12_total	331.0	6.0	10.0	2.0	1.0		3.0	171.0	182.0		161	61	353	331	6	10	2	1		3	171	182		161	61	353
3075086	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2019	grade_1													42													42
3075087	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2019	grade_2													48													48
3075088	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2019	grade_3													40													40
3075089	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2019	grade_4													37													37
3075090	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2019	grade_5													48													48
3075091	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2019	grade_6													54													54
3075092	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2019	kindergarten_4_year_old													32													32
3075093	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2019	kindergarten													47													47
3075094	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2019	pre_kindergarten													5													5
3089845	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2018	pk_12_total	286.0	5.0	11.0	3.0	1.0		2.0	149.0	159.0		132	49	308	286	5	11	3	1		2	149	159		132	49	308
3089846	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2018	grade_1													40													40
3089847	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2018	grade_2													30													30
3089848	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2018	grade_3													32													32
3089849	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2018	grade_4													41													41
3089850	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2018	grade_5													42													42
3089851	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2018	grade_6													34													34
3089852	WI	Trempealeau	school	5500016	485	Public school	Blair-Taylor	550001602380	34	Blair-Taylor Elementary	Regular School	No	Elementary	PK	06	2018	kindergarten_4_year_old													43													43